2016/02/09 13:41:58 :
----------------------------------------------------
XML Packet:
2016/02/09 13:41:58 :
          <union>
             <hdr>
                <session_id>1844385</session_id>
                <user_id>110004</user_id>
                <activity>1005</activity>
                <ip_address>41.161.80.58</ip_address>
                <debug>255</debug>
                <member_no>786406</member_no>
                <union_id>33</union_id>
                <menu_id>-1</menu_id>
             </hdr>
             <data>
                        <union_member_subs>
                        <class_action>3</class_action>
                        <union_id>33</union_id>
                        <member_no>786406</member_no>
                        <subscription_id>10</subscription_id>
                        <amount>85.28</amount>
                        <percentage>0</percentage>
                        <provider_id>33</provider_id>
                        <instit_id></instit_id>
                        <reference_no></reference_no>
                        <payment_method>1</payment_method>
                        <payment_frequency>01</payment_frequency>
                        <start_date></start_date>
                        <end_date></end_date>
                        <status>A</status>
                     </union_member_subs></data></union>
TUnionsListG::LoadAppend() (Err:0 SELECT     ROWID,NVL(UNION_ID       , 0  ), NVL(UNION_NAME     , ' '), NVL(REGISTERED     , ' '), NVL(GROUP_ID       , 0  ), NVL(REGISTRATION_FEE, 0  ), NVL(LONG_NAME      , ' '), NVL(GEN_PREFIX     , ' '), NVL(MEMBER_NO_SEQ  , 0  ), NVL(RECEIPT_NO_SEQ , 0  ), NVL(INSTIT_ID      , 0  )  FROM UNIONS  WHERE UNION_ID = decode(33,0,union_id,33) )
TPayrollMembersListG::LoadAppend() (Err:0 SELECT     ROWID,NVL(EMPL_NO        , ' '), NVL(PAYSYS_ID      , 0  ), NVL(MEMBER_NO      , ' '), NVL(UNION_ID       , 0  ), NVL(STATUS         , 0  ), NVL(ACTIVITY_LOG_ID, 0  )  FROM PAYROLL_MEMBERS  where union_id = 33 and member_no = '786406' and nvl(status,0) = 1 and paysys_id in (select paysys_id from payroll_union where  union_id = payroll_members.union_id and paysys_id=payroll_members.paysys_id and payment_method=1 ))
TPayrollMembersListG::LoadAppend() (Err:0 SELECT     ROWID,NVL(EMPL_NO        , ' '), NVL(PAYSYS_ID      , 0  ), NVL(MEMBER_NO      , ' '), NVL(UNION_ID       , 0  ), NVL(STATUS         , 0  ), NVL(ACTIVITY_LOG_ID, 0  )  FROM PAYROLL_MEMBERS  where union_id = 33 and member_no = '786406' and nvl(status,0) = 1 and paysys_id in (select paysys_id from payroll_union where  union_id = payroll_members.union_id and paysys_id=payroll_members.paysys_id and payment_method=1 ))
2016/02/09 13:41:58 :Subscription payment type changed - update Contribution raised for salary month 201601
2016/02/09 13:41:58 :Subscription payment type changed - update Contribution raised for salary month 201602
TPayrollMembersListG::LoadAppend() (Err:0 SELECT     ROWID,NVL(EMPL_NO        , ' '), NVL(PAYSYS_ID      , 0  ), NVL(MEMBER_NO      , ' '), NVL(UNION_ID       , 0  ), NVL(STATUS         , 0  ), NVL(ACTIVITY_LOG_ID, 0  )  FROM PAYROLL_MEMBERS  where union_id = 33 and member_no = '786406' and nvl(status,0) = 1 and paysys_id in (select paysys_id from payroll_union where  union_id = payroll_members.union_id and paysys_id=payroll_members.paysys_id and payment_method=1 ))
TPayrollMembersListG::LoadAppend() (Err:0 SELECT     ROWID,NVL(EMPL_NO        , ' '), NVL(PAYSYS_ID      , 0  ), NVL(MEMBER_NO      , ' '), NVL(UNION_ID       , 0  ), NVL(STATUS         , 0  ), NVL(ACTIVITY_LOG_ID, 0  )  FROM PAYROLL_MEMBERS  where union_id = 33 and member_no = '786406' and nvl(status,0) = 1 and paysys_id in (select paysys_id from payroll_union where  union_id = payroll_members.union_id and paysys_id=payroll_members.paysys_id and payment_method=1 ))
TTransactionRequestsListG::Insert() (Err:0 INSERT INTO TRANSACTION_REQUESTS (TRANS_NO,TRANTYPE,START_DATE,END_DATE,NEW_REFNO,AMOUNT,PERCENTAGE,DEDUCTTYPE,STATUS,UNION_ID,MEMBER_NO,REFERENCE_NO,SALARY_MONTH,PAYROLL_GROUP_ID,PAYSYS_ID,TRACK_ID,EMPL_NO,INSTIT_ID,SEQ_NO,ACTIVITY_LOG_ID,CHANGE_REQUEST,CR_TASK_NO ) VALUES (  2807463,  'QDEL',  TO_DATE(DECODE('',' ',NULL,'00000000',NULL,'0',NULL,''),'YYYYMMDD'),  TO_DATE(DECODE('20151231',' ',NULL,'00000000',NULL,'0',NULL,'20151231'),'YYYYMMDD'),  '',   85.28,   0.00,  '0028',  'O',   33,  '786406',  '786406',   201601,   33,   29,   0,  '786406',   340,   0,   14440376,   0,   0  ))
TPayrollMembersListG::LoadAppend() (Err:0 SELECT     ROWID,NVL(EMPL_NO        , ' '), NVL(PAYSYS_ID      , 0  ), NVL(MEMBER_NO      , ' '), NVL(UNION_ID       , 0  ), NVL(STATUS         , 0  ), NVL(ACTIVITY_LOG_ID, 0  )  FROM PAYROLL_MEMBERS  where union_id = 33 and member_no = '786406' and nvl(status,0) = 1 and paysys_id in (select paysys_id from payroll_union where  union_id = payroll_members.union_id and paysys_id=payroll_members.paysys_id and payment_method=1 ))
TTransactionRequestsListG::Insert() (Err:0 INSERT INTO TRANSACTION_REQUESTS (TRANS_NO,TRANTYPE,START_DATE,END_DATE,NEW_REFNO,AMOUNT,PERCENTAGE,DEDUCTTYPE,STATUS,UNION_ID,MEMBER_NO,REFERENCE_NO,SALARY_MONTH,PAYROLL_GROUP_ID,PAYSYS_ID,TRACK_ID,EMPL_NO,INSTIT_ID,SEQ_NO,ACTIVITY_LOG_ID,CHANGE_REQUEST,CR_TASK_NO ) VALUES (  2807464,  'QADD',  TO_DATE(DECODE('20160301',' ',NULL,'00000000',NULL,'0',NULL,'20160301'),'YYYYMMDD'),  TO_DATE(DECODE('',' ',NULL,'00000000',NULL,'0',NULL,''),'YYYYMMDD'),  '',   85.28,   0.00,  '0028',  'O',   33,  '786406',  '786406',   201603,   33,   41,   0,  '62387049',   340,   0,   14440376,   0,   0  ))
2016/02/09 13:41:59 :[110004,1844385,1005] {TPayrollUnionMemSubsGroupListG::DoInsert} (0)<?xml version='1.0' encoding='UTF-8'?><union><hdr><session_id>1844385</session_id></hdr><data><err_code>-3</err_code><err_descr>Error : Oracle row id is not zero</err_descr></data></union>
2016/02/09 13:41:59 :[110004,1844385,1005] {TPayrollUnionMemSubsGroupListG::DoInsert} (-3)Error : Oracle row id is not zero
2016/02/09 13:43:44 :
----------------------------------------------------
XML Packet:
2016/02/09 13:43:44 :
<union>
	<hdr>
		<session_id>1844385</session_id>
		<user_id>110004</user_id>
		<activity>2</activity>
		<ip_address>41.161.80.58</ip_address>
		<debug>255</debug>
		<menu_id>-1</menu_id>
		<union_id>33</union_id>		
	</hdr>
	<data>
	</data>
</union>
2016/02/09 13:43:44 :[110004,1844385,2] {TMAS::Init} (0)<?xml version='1.0' encoding='UTF-8'?><union><hdr><session_id>1844385</session_id></hdr><data><err_code>0</err_code><err_descr>None</err_descr></data></union>
2016/02/09 13:43:44 :[110004,1844385,2] {TMAS::Init} (0)None