2016/02/11 10:29:28 :
----------------------------------------------------
XML Packet:
2016/02/11 10:29:28 :
        <union>
          <hdr>
            <activity>1002</activity>
            <debug>255</debug>
            <ip_address>105.225.25.150</ip_address>
            <member_no>NUP050140</member_no>
            <menu_id>245</menu_id>
            <session_id>1846248</session_id>
            <union_id>15</union_id>
            <user_id>1045</user_id>
          </hdr>
          <data><members><class_action>3</class_action><union_id>15</union_id><account_holder></account_holder>
<action_day>31</action_day>
<bank_account_number></bank_account_number>
<bank_branch_code></bank_branch_code>
<bank_name></bank_name>
<bargain_council_id>567</bargain_council_id>
<classification></classification>
<email></email>
<ethnic_group></ethnic_group>
<first_name>PHUTI FRANK</first_name>
<maiden_name></maiden_name>
<surname>MATLAMELA</surname>
<gender>M</gender>
<grouping1>13</grouping1>
<grouping2>0005</grouping2>
<grouping3>0246</grouping3>
<grouping4></grouping4>
<id_no>5405035439088</id_no>
<initials>DM</initials>
<language>SEP</language>
<liason_officer>NUP054134</liason_officer>
<marital_status>M</marital_status>
<member_id></member_id>
<member_no>NUP050140</member_no>
<resig_date></resig_date>
<collection_method></collection_method>
<tracking_indicator></tracking_indicator>
<tracking_start_indicator></tracking_start_indicator>
<type_of_grouping></type_of_grouping>
<home_owner></home_owner>
<news_method></news_method>
<no_dependants></no_dependants>
<paying_flag>Y</paying_flag>
<qualification></qualification>
<race></race>
<recruitment_officer>NUP054134</recruitment_officer>
<sector>02</sector>
<title></title>
<type_of_member>01</type_of_member>
<union_specific_status>A</union_specific_status>
<variable_action_day>Y</variable_action_day>
<bank_account_type></bank_account_type>
<income_tax_no></income_tax_no>
<passport_no></passport_no>
<contact_method></contact_method>
<consent></consent>
<correspondence_address></correspondence_address>
<recruitment_week></recruitment_week>
</members> <member_dates>
                   <class_action>3</class_action>
                   <member_no>NUP050140</member_no>
                   <union_id>15</union_id>
                   <date_type>4</date_type>
                   <actual_date>20100101</actual_date>
                  </member_dates>
 <member_dates>
                   <class_action>2</class_action>
                   <member_no>NUP050140</member_no>
                   <union_id>15</union_id>
                   <date_type>10</date_type>
                   <actual_date></actual_date>
                  </member_dates>
</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(15,0,union_id,15) )
2016/02/11 10:29:29 :[1045,1846248,1153] {TMembersListG::HandleActivity} (0)<?xml version='1.0' encoding='UTF-8'?><union><hdr><session_id>1846248</session_id></hdr><data><err_code>0</err_code><err_descr>Success</err_descr><members><member_no>NUP050140</member_no></members></data></union>
2016/02/11 10:29:29 :[1045,1846248,1153] {TMembersListG::HandleActivity} (0)Success
2016/02/11 10:29:29 :[1045,1846248,1153] {TMemberAdmin::HandleXML} (0)<?xml version='1.0' encoding='UTF-8'?><union><hdr><session_id>1846248</session_id></hdr><data><err_code>0</err_code><err_descr>Success</err_descr></data></union>
2016/02/11 10:29:29 :[1045,1846248,1153] {TMemberAdmin::HandleXML} (0)Success
2016/02/11 10:30:21 :
----------------------------------------------------
XML Packet:
2016/02/11 10:30:21 :
          <union>
             <hdr>
                <session_id>1846248</session_id>
                <user_id>1045</user_id>
                <activity>1006</activity>
                <ip_address>105.225.25.150</ip_address>
                <debug>255</debug>
                <member_no>NUP050140</member_no>
                <union_id>15</union_id>
                <menu_id>245</menu_id>
             </hdr>
             <data>
                        <union_member_subs>
                        <class_action>3</class_action>
                        <union_id>15</union_id>
                        <member_no>NUP050140</member_no>
                        <subscription_id>10</subscription_id>
                        <amount>65.00</amount>
                        <percentage>0</percentage>
                        <provider_id>53</provider_id>
                        <instit_id></instit_id>
                        <reference_no>5405035439088</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(15,0,union_id,15) )
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 (  2808142,  'QADD',  TO_DATE(DECODE('20140401',' ',NULL,'00000000',NULL,'0',NULL,'20140401'),'YYYYMMDD'),  TO_DATE(DECODE('',' ',NULL,'00000000',NULL,'0',NULL,''),'YYYYMMDD'),  '',   65.00,   0.00,  '0028',  'O',   15,  'NUP050140',  '5405035439088',   201404,   11,   15018,   0,  '00000109',   363,   0,   14449532,   0,   0  ))
2016/02/11 10:30:22 :[1045,1846248,1006] {ForceTran::MYSTUFF} (0)Result = 0 date = 20140401 ERR 0
2016/02/11 10:30:22 :[1045,1846248,1006] {ForceTran::MYSTUFF} (0)mem NUP050140 ded 0028 ref 5405035439088 sal 201404 empl 00000109 pg 11 type QADD 
2016/02/11 10:30:22 :[1045,1846248,1006] {TMembersListG::HandleActivity} (0)<?xml version='1.0' encoding='UTF-8'?><union><hdr><session_id>1846248</session_id></hdr><data><err_code>0</err_code><err_descr>Success</err_descr><members><member_no>NUP050140</member_no></members></data></union>
2016/02/11 10:30:22 :[1045,1846248,1006] {TMembersListG::HandleActivity} (0)Success
2016/02/11 10:30:22 :[1045,1846248,1006] {TMemberAdmin::HandleXML} (0)<?xml version='1.0' encoding='UTF-8'?><union><hdr><session_id>1846248</session_id></hdr><data><err_code>0</err_code><err_descr>Success</err_descr></data></union>
2016/02/11 10:30:22 :[1045,1846248,1006] {TMemberAdmin::HandleXML} (0)Success
2016/02/11 10:30:22 :
----------------------------------------------------
XML Packet:
2016/02/11 10:30:22 :
          <union>
             <hdr>
                <session_id>1846248</session_id>
                <user_id>1045</user_id>
                <activity>1006</activity>
                <ip_address>105.225.25.150</ip_address>
                <debug>255</debug>
                <member_no>NUP050140</member_no>
                <union_id>15</union_id>
                <menu_id>245</menu_id>
             </hdr>
             <data>
                        <union_member_subs>
                        <class_action>3</class_action>
                        <union_id>15</union_id>
                        <member_no>NUP050140</member_no>
                        <subscription_id>10</subscription_id>
                        <amount>65.00</amount>
                        <percentage>0</percentage>
                        <provider_id>53</provider_id>
                        <instit_id></instit_id>
                        <reference_no>5405035439088</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(15,0,union_id,15) )
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 (  2808143,  'QADD',  TO_DATE(DECODE('20140401',' ',NULL,'00000000',NULL,'0',NULL,'20140401'),'YYYYMMDD'),  TO_DATE(DECODE('',' ',NULL,'00000000',NULL,'0',NULL,''),'YYYYMMDD'),  '',   65.00,   0.00,  '0028',  'O',   15,  'NUP050140',  '5405035439088',   201404,   11,   15018,   0,  '00000109',   363,   0,   14449533,   0,   0  ))
2016/02/11 10:30:22 :[1045,1846248,1006] {ForceTran::MYSTUFF} (0)Result = 0 date = 20140401 ERR 0
2016/02/11 10:30:22 :[1045,1846248,1006] {ForceTran::MYSTUFF} (0)mem NUP050140 ded 0028 ref 5405035439088 sal 201404 empl 00000109 pg 11 type QADD 
2016/02/11 10:30:22 :[1045,1846248,1006] {TMembersListG::HandleActivity} (0)<?xml version='1.0' encoding='UTF-8'?><union><hdr><session_id>1846248</session_id></hdr><data><err_code>0</err_code><err_descr>Success</err_descr><members><member_no>NUP050140</member_no></members></data></union>
2016/02/11 10:30:22 :[1045,1846248,1006] {TMembersListG::HandleActivity} (0)Success
2016/02/11 10:30:22 :[1045,1846248,1006] {TMemberAdmin::HandleXML} (0)<?xml version='1.0' encoding='UTF-8'?><union><hdr><session_id>1846248</session_id></hdr><data><err_code>0</err_code><err_descr>Success</err_descr></data></union>
2016/02/11 10:30:22 :[1045,1846248,1006] {TMemberAdmin::HandleXML} (0)Success
2016/02/11 10:30:47 :
----------------------------------------------------
XML Packet:
2016/02/11 10:30:47 :
          <union>
             <hdr>
                <session_id>1846248</session_id>
                <user_id>1045</user_id>
                <activity>1005</activity>
                <ip_address>105.225.25.150</ip_address>
                <debug>255</debug>
                <member_no>NUP050140</member_no>
                <union_id>15</union_id>
                <menu_id>245</menu_id>
             </hdr>
             <data>
                        <union_member_subs>
                        <class_action>3</class_action>
                        <union_id>15</union_id>
                        <member_no>NUP050140</member_no>
                        <subscription_id>10</subscription_id>
                        <amount>65.00</amount>
                        <percentage>0</percentage>
                        <provider_id>53</provider_id>
                        <instit_id></instit_id>
                        <reference_no>5405035439088</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(15,0,union_id,15) )
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 = 15 and member_no = 'NUP050140' 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 = 15 and member_no = 'NUP050140' 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 = 15 and member_no = 'NUP050140' 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/11 10:30:48 :[1045,1846248,1005] {TMembersListG::HandleActivity} (0)<?xml version='1.0' encoding='UTF-8'?><union><hdr><session_id>1846248</session_id></hdr><data><err_code>0</err_code><err_descr>Success</err_descr><members><member_no>NUP050140</member_no></members></data></union>
2016/02/11 10:30:48 :[1045,1846248,1005] {TMembersListG::HandleActivity} (0)Success
2016/02/11 10:30:48 :[1045,1846248,1005] {TMemberAdmin::HandleXML} (0)<?xml version='1.0' encoding='UTF-8'?><union><hdr><session_id>1846248</session_id></hdr><data><err_code>0</err_code><err_descr>Success</err_descr></data></union>
2016/02/11 10:30:48 :[1045,1846248,1005] {TMemberAdmin::HandleXML} (0)Success
2016/02/11 10:31:26 :
----------------------------------------------------
XML Packet:
2016/02/11 10:31:26 :
          <union>
             <hdr>
                <session_id>1846248</session_id>
                <user_id>1045</user_id>
                <activity>1006</activity>
                <ip_address>105.225.25.150</ip_address>
                <debug>255</debug>
                <member_no>NUP050140</member_no>
                <union_id>15</union_id>
                <menu_id>245</menu_id>
             </hdr>
             <data>
                        <union_member_subs>
                        <class_action>3</class_action>
                        <union_id>15</union_id>
                        <member_no>NUP050140</member_no>
                        <subscription_id>10</subscription_id>
                        <amount>65.00</amount>
                        <percentage>0</percentage>
                        <provider_id>53</provider_id>
                        <instit_id></instit_id>
                        <reference_no>5405035439088</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(15,0,union_id,15) )
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 (  2808145,  'QADD',  TO_DATE(DECODE('20140401',' ',NULL,'00000000',NULL,'0',NULL,'20140401'),'YYYYMMDD'),  TO_DATE(DECODE('',' ',NULL,'00000000',NULL,'0',NULL,''),'YYYYMMDD'),  '',   65.00,   0.00,  '0028',  'O',   15,  'NUP050140',  '5405035439088',   201404,   11,   15018,   0,  '00000109',   363,   0,   14449542,   0,   0  ))
2016/02/11 10:31:26 :[1045,1846248,1006] {ForceTran::MYSTUFF} (0)Result = 0 date = 20140401 ERR 0
2016/02/11 10:31:26 :[1045,1846248,1006] {ForceTran::MYSTUFF} (0)mem NUP050140 ded 0028 ref 5405035439088 sal 201404 empl 00000109 pg 11 type QADD 
2016/02/11 10:31:26 :[1045,1846248,1006] {TMembersListG::HandleActivity} (0)<?xml version='1.0' encoding='UTF-8'?><union><hdr><session_id>1846248</session_id></hdr><data><err_code>0</err_code><err_descr>Success</err_descr><members><member_no>NUP050140</member_no></members></data></union>
2016/02/11 10:31:26 :[1045,1846248,1006] {TMembersListG::HandleActivity} (0)Success
2016/02/11 10:31:26 :[1045,1846248,1006] {TMemberAdmin::HandleXML} (0)<?xml version='1.0' encoding='UTF-8'?><union><hdr><session_id>1846248</session_id></hdr><data><err_code>0</err_code><err_descr>Success</err_descr></data></union>
2016/02/11 10:31:26 :[1045,1846248,1006] {TMemberAdmin::HandleXML} (0)Success
2016/02/11 10:31:28 :
----------------------------------------------------
XML Packet:
2016/02/11 10:31:28 :
          <union>
             <hdr>
                <session_id>1846248</session_id>
                <user_id>1045</user_id>
                <activity>1006</activity>
                <ip_address>105.225.25.150</ip_address>
                <debug>255</debug>
                <member_no>NUP050140</member_no>
                <union_id>15</union_id>
                <menu_id>245</menu_id>
             </hdr>
             <data>
                        <union_member_subs>
                        <class_action>3</class_action>
                        <union_id>15</union_id>
                        <member_no>NUP050140</member_no>
                        <subscription_id>10</subscription_id>
                        <amount>65.00</amount>
                        <percentage>0</percentage>
                        <provider_id>53</provider_id>
                        <instit_id></instit_id>
                        <reference_no>5405035439088</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(15,0,union_id,15) )
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 (  2808146,  'QADD',  TO_DATE(DECODE('20140401',' ',NULL,'00000000',NULL,'0',NULL,'20140401'),'YYYYMMDD'),  TO_DATE(DECODE('',' ',NULL,'00000000',NULL,'0',NULL,''),'YYYYMMDD'),  '',   65.00,   0.00,  '0028',  'O',   15,  'NUP050140',  '5405035439088',   201404,   11,   15018,   0,  '00000109',   363,   0,   14449543,   0,   0  ))
2016/02/11 10:31:28 :[1045,1846248,1006] {ForceTran::MYSTUFF} (0)Result = 0 date = 20140401 ERR 0
2016/02/11 10:31:28 :[1045,1846248,1006] {ForceTran::MYSTUFF} (0)mem NUP050140 ded 0028 ref 5405035439088 sal 201404 empl 00000109 pg 11 type QADD 
2016/02/11 10:31:28 :[1045,1846248,1006] {TMembersListG::HandleActivity} (0)<?xml version='1.0' encoding='UTF-8'?><union><hdr><session_id>1846248</session_id></hdr><data><err_code>0</err_code><err_descr>Success</err_descr><members><member_no>NUP050140</member_no></members></data></union>
2016/02/11 10:31:28 :[1045,1846248,1006] {TMembersListG::HandleActivity} (0)Success
2016/02/11 10:31:28 :[1045,1846248,1006] {TMemberAdmin::HandleXML} (0)<?xml version='1.0' encoding='UTF-8'?><union><hdr><session_id>1846248</session_id></hdr><data><err_code>0</err_code><err_descr>Success</err_descr></data></union>
2016/02/11 10:31:28 :[1045,1846248,1006] {TMemberAdmin::HandleXML} (0)Success