eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_MERGE dependencies on IBY_DEBUG_PUB

Line 328: iby_debug_pub.Add('Updating the instrument Assignment Id...');

324: /*Merge Instruments Use only if the same instrument exists at both the levels
325: We need to merge only those records which are not yer captured
326: */
327:
328: iby_debug_pub.Add('Updating the instrument Assignment Id...');
329: FORALL i in 1..ext_payer_from_list.COUNT
330: UPDATE IBY_FNDCPT_TX_EXTENSIONS DUP
331: SET instr_assignment_id =
332: (SELECT to_instr.instrument_payment_use_id FROM

Line 371: iby_debug_pub.Add('Modifying instrument use id for credit cards');

367:
368:
369: /* For credit cards we need to check the Hashcodes. Same hashcodes mean the same instrument*/
370: /*
371: iby_debug_pub.Add('Modifying instrument use id for credit cards');
372: FORALL i in 1..ext_payer_from_list.COUNT
373: UPDATE iby_fndcpt_tx_extensions dup
374: SET instr_assignment_id =
375: (SELECT to_uses.instrument_payment_use_id FROM

Line 423: iby_debug_pub.Add('Modifying instrument use id for bank accounts');

419: ) ; */
420:
421: /* For Bank Accounts we need to check the Hashcodes. Same hashcodes mean the same instrument*/
422: /*
423: iby_debug_pub.Add('Modifying instrument use id for bank accounts');
424: FORALL i in 1..ext_payer_from_list.COUNT
425: UPDATE iby_fndcpt_tx_extensions dup
426: SET instr_assignment_id =
427: (SELECT to_uses.instrument_payment_use_id FROM

Line 475: iby_debug_pub.Add('Modifying the Payer value');

471: AND to_uses.ext_pmt_party_id = ext_payer_to_list(i)
472: ) ; */
473:
474: /* Update the Payer with the new value */
475: iby_debug_pub.Add('Modifying the Payer value');
476: FORALL i in 1..ext_payer_from_list.COUNT
477: UPDATE iby_fndcpt_tx_extensions dup
478: SET ext_payer_id = ext_payer_to_list(i)
479: WHERE ext_payer_id = ext_payer_from_list(i)

Line 498: iby_debug_pub.Add('After Modifying the Payer value');

494: where o.trxn_extension_id = dup.trxn_extension_id
495: )
496: );
497:
498: iby_debug_pub.Add('After Modifying the Payer value');
499:
500: EXCEPTION
501: WHEN OTHERS THEN
502: arp_message.set_line( 'TRANSACTIONS_EXT_MERGE');

Line 526: iby_debug_pub.Add('Merging the Payment Methods');

522: At target account, if there exists a payer method for an instrument
523: similar to that of the target account, inactivate the payment method
524: for the target account, else transfer the same
525: */
526: iby_debug_pub.Add('Merging the Payment Methods');
527: FORALL i in 1..ext_payer_from_list.COUNT
528: UPDATE iby_ext_party_pmt_mthds dup
529: SET ext_pmt_party_id = ext_payer_to_list(i),
530: last_update_date = SYSDATE,

Line 545: iby_debug_pub.Add('Transferring the Payment Methods');

541: AND mto.payment_method_code = dup.payment_method_code
542: AND mto.payment_flow = dup.payment_flow
543: AND mto.payment_function = dup.payment_function
544: );
545: iby_debug_pub.Add('Transferring the Payment Methods');
546: FORALL i in 1..ext_payer_from_list.COUNT
547: UPDATE iby_ext_party_pmt_mthds dup
548: SET inactive_date = SYSDATE,
549: last_update_date = SYSDATE,

Line 589: iby_debug_pub.Add('Transferring the Instruments');

585: /*
586: If there exists a similar instrument at both the accounts,
587: inactivate the payment method for the target account, else transfer the same
588: */
589: iby_debug_pub.Add('Transferring the Instruments');
590: FORALL i in 1..ext_payer_from_list.COUNT
591: UPDATE iby_pmt_instr_uses_all dup
592: SET ext_pmt_party_id = ext_payer_to_list(i),
593: last_update_date = SYSDATE,

Line 615: iby_debug_pub.Add('Transferring the Credit Cards');

611: /*
612: If two Credit cards carries the same hash codes , it means there
613: exists a single instrument., in which case, we need to transfer
614: */
615: iby_debug_pub.Add('Transferring the Credit Cards');
616: FORALL i in 1..ext_payer_from_list.COUNT
617: UPDATE iby_pmt_instr_uses_all dup
618: SET ext_pmt_party_id = ext_payer_to_list(i),
619: last_update_date = SYSDATE,

Line 646: iby_debug_pub.Add('Transferring the bank accounts');

642: /*
643: If two Bank Accounts carries the same hash codes , it means there
644: exists a single instrument., in which case, we need to transfer
645: */
646: iby_debug_pub.Add('Transferring the bank accounts');
647: FORALL i in 1..ext_payer_from_list.COUNT
648: UPDATE iby_pmt_instr_uses_all dup
649: SET ext_pmt_party_id = ext_payer_to_list(i),
650: last_update_date = SYSDATE,

Line 675: iby_debug_pub.Add('Inactivating the Instruments for duplicat account');

671: );
672:
673:
674:
675: iby_debug_pub.Add('Inactivating the Instruments for duplicat account');
676: FORALL i in 1..ext_payer_from_list.COUNT
677: UPDATE iby_pmt_instr_uses_all dup
678: SET end_date = SYSDATE,
679: last_update_date = SYSDATE,

Line 698: iby_debug_pub.Add('Inactivating the Credit cards for dupliacte account');

694: AND mto.payment_function = dup.payment_function
695: AND mto.instrument_type = dup.instrument_type
696: );
697:
698: iby_debug_pub.Add('Inactivating the Credit cards for dupliacte account');
699: FORALL i in 1..ext_payer_from_list.COUNT
700: UPDATE iby_pmt_instr_uses_all dup
701: SET end_date = SYSDATE,
702: last_update_date = SYSDATE,

Line 724: iby_debug_pub.Add('Inactivating the Bank Accounts for dupliacte account');

720: AND to_card.instrid = uses.instrument_id
721: AND uses.ext_pmt_party_id = ext_payer_to_list(i)
722: );
723:
724: iby_debug_pub.Add('Inactivating the Bank Accounts for dupliacte account');
725: FORALL i in 1..ext_payer_from_list.COUNT
726: UPDATE iby_pmt_instr_uses_all dup
727: SET end_date = SYSDATE,
728: last_update_date = SYSDATE,

Line 860: iby_debug_pub.Add( '*** ext_payer_from_list(i) added ' || ext_payer_from_list(i));

856: */
857: ext_payer_from_list(i) := get_external_payer_id(num_col1_orig_list(i),num_col2_orig_list(i));
858: ext_payer_to_list(i) := get_external_payer_id(num_col1_new_list(i),num_col2_new_list(i));
859: -- added debug
860: iby_debug_pub.Add( '*** ext_payer_from_list(i) added ' || ext_payer_from_list(i));
861: iby_debug_pub.Add( '*** ext_payer_to_list(i) added ' || ext_payer_to_list(i));
862:
863:
864: END LOOP;

Line 861: iby_debug_pub.Add( '*** ext_payer_to_list(i) added ' || ext_payer_to_list(i));

857: ext_payer_from_list(i) := get_external_payer_id(num_col1_orig_list(i),num_col2_orig_list(i));
858: ext_payer_to_list(i) := get_external_payer_id(num_col1_new_list(i),num_col2_new_list(i));
859: -- added debug
860: iby_debug_pub.Add( '*** ext_payer_from_list(i) added ' || ext_payer_from_list(i));
861: iby_debug_pub.Add( '*** ext_payer_to_list(i) added ' || ext_payer_to_list(i));
862:
863:
864: END LOOP;
865: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

Line 901: iby_debug_pub.Add('Transferring the Payer Records');

897: hz_utility_pub.last_updated_by
898: );
899:
900: END IF;
901: iby_debug_pub.Add('Transferring the Payer Records');
902: /*
903: If there is a payer at the duplicate account and if there doesnt exist any
904: payer at the target account, transfer the payer by updating the
905: account and site use with the new values

Line 912: iby_debug_pub.Add( 'checking if a site is already updated');

908: LOOP
909: l_dup_payer := NULL;
910: l_payer_count := 0;
911:
912: iby_debug_pub.Add( 'checking if a site is already updated');
913:
914: iby_debug_pub.Add( '*** num_col1_new_list(i) ' || num_col1_new_list(i));
915: iby_debug_pub.Add( '*** num_col2_new_list(i) ' || num_col2_new_list(i));
916:

Line 914: iby_debug_pub.Add( '*** num_col1_new_list(i) ' || num_col1_new_list(i));

910: l_payer_count := 0;
911:
912: iby_debug_pub.Add( 'checking if a site is already updated');
913:
914: iby_debug_pub.Add( '*** num_col1_new_list(i) ' || num_col1_new_list(i));
915: iby_debug_pub.Add( '*** num_col2_new_list(i) ' || num_col2_new_list(i));
916:
917: SELECT count(ext_payer_id) into l_payer_count
918: FROM IBY_EXTERNAL_PAYERS_ALL

Line 915: iby_debug_pub.Add( '*** num_col2_new_list(i) ' || num_col2_new_list(i));

911:
912: iby_debug_pub.Add( 'checking if a site is already updated');
913:
914: iby_debug_pub.Add( '*** num_col1_new_list(i) ' || num_col1_new_list(i));
915: iby_debug_pub.Add( '*** num_col2_new_list(i) ' || num_col2_new_list(i));
916:
917: SELECT count(ext_payer_id) into l_payer_count
918: FROM IBY_EXTERNAL_PAYERS_ALL
919: WHERE cust_account_id = num_col1_new_list(i)

Line 924: iby_debug_pub.Add( 'l_payer_count after fetching: '|| l_payer_count);

920: AND acct_site_use_id = num_col2_new_list(i)
921: AND ext_payer_from_list(i) is not null
922: AND ext_payer_to_list(i) is null;
923:
924: iby_debug_pub.Add( 'l_payer_count after fetching: '|| l_payer_count);
925:
926:
927: IF( l_payer_count > 0)
928: THEN

Line 936: iby_debug_pub.Add( 'l_dup_payer after fetching: '|| l_dup_payer);

932: AND acct_site_use_id = num_col2_new_list(i)
933: AND ext_payer_from_list(i) is not null
934: AND ext_payer_to_list(i) is null;
935:
936: iby_debug_pub.Add( 'l_dup_payer after fetching: '|| l_dup_payer);
937:
938: ext_payer_to_list(i) := l_dup_payer;
939:
940: iby_debug_pub.Add( 'ext_payer_to_list:'||ext_payer_to_list(i));

Line 940: iby_debug_pub.Add( 'ext_payer_to_list:'||ext_payer_to_list(i));

936: iby_debug_pub.Add( 'l_dup_payer after fetching: '|| l_dup_payer);
937:
938: ext_payer_to_list(i) := l_dup_payer;
939:
940: iby_debug_pub.Add( 'ext_payer_to_list:'||ext_payer_to_list(i));
941:
942: END IF;
943:
944: iby_debug_pub.Add( 'After checking of a site already updated');

Line 944: iby_debug_pub.Add( 'After checking of a site already updated');

940: iby_debug_pub.Add( 'ext_payer_to_list:'||ext_payer_to_list(i));
941:
942: END IF;
943:
944: iby_debug_pub.Add( 'After checking of a site already updated');
945:
946: iby_debug_pub.Add( '*** primary_key_id_list(i) ' || primary_key_id_list(i));
947: iby_debug_pub.Add( '*** ext_payer_from_list(i) ' || ext_payer_from_list(i));
948: iby_debug_pub.Add( '*** ext_payer_to_list(i) added ' || ext_payer_to_list(i));

Line 946: iby_debug_pub.Add( '*** primary_key_id_list(i) ' || primary_key_id_list(i));

942: END IF;
943:
944: iby_debug_pub.Add( 'After checking of a site already updated');
945:
946: iby_debug_pub.Add( '*** primary_key_id_list(i) ' || primary_key_id_list(i));
947: iby_debug_pub.Add( '*** ext_payer_from_list(i) ' || ext_payer_from_list(i));
948: iby_debug_pub.Add( '*** ext_payer_to_list(i) added ' || ext_payer_to_list(i));
949:
950: UPDATE IBY_EXTERNAL_PAYERS_ALL yt SET

Line 947: iby_debug_pub.Add( '*** ext_payer_from_list(i) ' || ext_payer_from_list(i));

943:
944: iby_debug_pub.Add( 'After checking of a site already updated');
945:
946: iby_debug_pub.Add( '*** primary_key_id_list(i) ' || primary_key_id_list(i));
947: iby_debug_pub.Add( '*** ext_payer_from_list(i) ' || ext_payer_from_list(i));
948: iby_debug_pub.Add( '*** ext_payer_to_list(i) added ' || ext_payer_to_list(i));
949:
950: UPDATE IBY_EXTERNAL_PAYERS_ALL yt SET
951: cust_account_id=num_col1_new_list(i)

Line 948: iby_debug_pub.Add( '*** ext_payer_to_list(i) added ' || ext_payer_to_list(i));

944: iby_debug_pub.Add( 'After checking of a site already updated');
945:
946: iby_debug_pub.Add( '*** primary_key_id_list(i) ' || primary_key_id_list(i));
947: iby_debug_pub.Add( '*** ext_payer_from_list(i) ' || ext_payer_from_list(i));
948: iby_debug_pub.Add( '*** ext_payer_to_list(i) added ' || ext_payer_to_list(i));
949:
950: UPDATE IBY_EXTERNAL_PAYERS_ALL yt SET
951: cust_account_id=num_col1_new_list(i)
952: ,acct_site_use_id=num_col2_new_list(i)

Line 962: iby_debug_pub.Add('Performing Transaction summary Merge');

958: AND ext_payer_from_list(i) is not null
959: AND ext_payer_to_list(i) is null;
960: END LOOP;
961:
962: iby_debug_pub.Add('Performing Transaction summary Merge');
963: trx_summary_merge(req_id,set_num,process_mode);
964: iby_debug_pub.Add('Performing Transaction Extensiopns Merge');
965: transactions_ext_merge(ext_payer_from_list,ext_payer_to_list);
966: iby_debug_pub.Add('Performing Instruments Merge');

Line 964: iby_debug_pub.Add('Performing Transaction Extensiopns Merge');

960: END LOOP;
961:
962: iby_debug_pub.Add('Performing Transaction summary Merge');
963: trx_summary_merge(req_id,set_num,process_mode);
964: iby_debug_pub.Add('Performing Transaction Extensiopns Merge');
965: transactions_ext_merge(ext_payer_from_list,ext_payer_to_list);
966: iby_debug_pub.Add('Performing Instruments Merge');
967: instrument_merge(ext_payer_from_list,ext_payer_to_list);
968: iby_debug_pub.Add('Performing Payment Methods Merge');

Line 966: iby_debug_pub.Add('Performing Instruments Merge');

962: iby_debug_pub.Add('Performing Transaction summary Merge');
963: trx_summary_merge(req_id,set_num,process_mode);
964: iby_debug_pub.Add('Performing Transaction Extensiopns Merge');
965: transactions_ext_merge(ext_payer_from_list,ext_payer_to_list);
966: iby_debug_pub.Add('Performing Instruments Merge');
967: instrument_merge(ext_payer_from_list,ext_payer_to_list);
968: iby_debug_pub.Add('Performing Payment Methods Merge');
969: payment_methods_merge(ext_payer_from_list,ext_payer_to_list);
970: l_count := l_count + SQL%ROWCOUNT;

Line 968: iby_debug_pub.Add('Performing Payment Methods Merge');

964: iby_debug_pub.Add('Performing Transaction Extensiopns Merge');
965: transactions_ext_merge(ext_payer_from_list,ext_payer_to_list);
966: iby_debug_pub.Add('Performing Instruments Merge');
967: instrument_merge(ext_payer_from_list,ext_payer_to_list);
968: iby_debug_pub.Add('Performing Payment Methods Merge');
969: payment_methods_merge(ext_payer_from_list,ext_payer_to_list);
970: l_count := l_count + SQL%ROWCOUNT;
971: IF l_last_fetch THEN
972: EXIT;