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.ASO_PAYMENT_DATA_MIGRATION_PVT dependencies on IBY_PMT_INSTR_USES_ALL

Line 157: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id

153: IBY_FNDCPT_TX_EXTENSIONS_S.nextval, --trxn_extension_id
154: IBY_INSTR_S.nextval,
155: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval, PAYER.EXT_PAYER_ID),
156: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we should create new external payer
157: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
158: sec.cc_number_hash1,
159: sec.cc_number_hash2,
160: sec.cc_issuer_range_id,
161: sec.sec_segment_id,

Line 201: iby_pmt_instr_uses_all_s.nextval, -- the new instrument use id

197: iby_fndcpt_tx_extensions_s.nextval, --trxn_extension_id
198: iby_instr_s.nextval,
199: decode(payer.ext_payer_id, null, iby_external_payers_all_s.nextval, payer.ext_payer_id),
200: decode(payer.ext_payer_id, null,'Y', 'N'), -- this flag determines whether we should create new external payer
201: iby_pmt_instr_uses_all_s.nextval, -- the new instrument use id
202: iby_fndcpt_setup_pub.get_hash(pmt.payment_ref_number, fnd_api.g_false) cc_number_hash1,
203: iby_fndcpt_setup_pub.get_hash(pmt.payment_ref_number, fnd_api.g_true) cc_number_hash2,
204: iby_cc_validate.get_cc_issuer_range(pmt.payment_ref_number) cc_issuer_range_id,
205: --null sec_segment_id,

Line 449: fnd_file.put_line(FND_FILE.OUTPUT, 'Before insering into table IBY_PMT_INSTR_USES_ALL ');

445:
446:
447: -- Now insert into the instrument use table
448: BEGIN -- begin2
449: fnd_file.put_line(FND_FILE.OUTPUT, 'Before insering into table IBY_PMT_INSTR_USES_ALL ');
450:
451: FORALL i IN payment_id_tab.first .. payment_id_tab.last SAVE EXCEPTIONS
452:
453: INSERT INTO IBY_PMT_INSTR_USES_ALL( INSTRUMENT_PAYMENT_USE_ID,

Line 453: INSERT INTO IBY_PMT_INSTR_USES_ALL( INSTRUMENT_PAYMENT_USE_ID,

449: fnd_file.put_line(FND_FILE.OUTPUT, 'Before insering into table IBY_PMT_INSTR_USES_ALL ');
450:
451: FORALL i IN payment_id_tab.first .. payment_id_tab.last SAVE EXCEPTIONS
452:
453: INSERT INTO IBY_PMT_INSTR_USES_ALL( INSTRUMENT_PAYMENT_USE_ID,
454: EXT_PMT_PARTY_ID,
455: INSTRUMENT_TYPE,
456: INSTRUMENT_ID,
457: PAYMENT_FUNCTION,

Line 498: fnd_file.put_line(FND_FILE.OUTPUT, 'After insering into table IBY_PMT_INSTR_USES_ALL ');

494: and acct_site_use_id is null
495: and rownum = 1;
496:
497:
498: fnd_file.put_line(FND_FILE.OUTPUT, 'After insering into table IBY_PMT_INSTR_USES_ALL ');
499:
500: EXCEPTION
501:
502: WHEN OTHERS THEN

Line 509: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_PMT_INSTR_USES_ALL for Payment Id: ' || payment_id_tab(j));

505: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
506:
507: fnd_file.put_line(FND_FILE.OUTPUT, 'Error occurred during iteration ' || SQL%BULK_EXCEPTIONS(j).ERROR_INDEX || ' Oracle error is ' || SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
508:
509: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_PMT_INSTR_USES_ALL for Payment Id: ' || payment_id_tab(j));
510: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_PMT_INSTR_USES_ALL for Instrument Assignment Id: ' || instr_assignment_id_tab(j));
511: END LOOP;
512:
513: END; --end2

Line 510: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_PMT_INSTR_USES_ALL for Instrument Assignment Id: ' || instr_assignment_id_tab(j));

506:
507: fnd_file.put_line(FND_FILE.OUTPUT, 'Error occurred during iteration ' || SQL%BULK_EXCEPTIONS(j).ERROR_INDEX || ' Oracle error is ' || SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
508:
509: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_PMT_INSTR_USES_ALL for Payment Id: ' || payment_id_tab(j));
510: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_PMT_INSTR_USES_ALL for Instrument Assignment Id: ' || instr_assignment_id_tab(j));
511: END LOOP;
512:
513: END; --end2
514:

Line 572: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_PMT_INSTR_USES_ALL for trxn_ref_number1_tab(j): ' || trxn_ref_number1_tab(j));

568: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
569:
570: fnd_file.put_line(FND_FILE.OUTPUT, 'Error occurred during iteration ' || SQL%BULK_EXCEPTIONS(j).ERROR_INDEX || ' Oracle error is ' || SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
571:
572: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_PMT_INSTR_USES_ALL for trxn_ref_number1_tab(j): ' || trxn_ref_number1_tab(j));
573: END LOOP;
574:
575: END; --end3
576:

Line 728: fnd_file.put_line(FND_FILE.OUTPUT, 'Before insering into table IBY_PMT_INSTR_USES_ALL');

724:
725: -- Now insert into the instrument use table
726: BEGIN --begin5
727:
728: fnd_file.put_line(FND_FILE.OUTPUT, 'Before insering into table IBY_PMT_INSTR_USES_ALL');
729:
730: FORALL i IN payment_id_tab.first .. payment_id_tab.last SAVE EXCEPTIONS
731:
732: INSERT INTO IBY_PMT_INSTR_USES_ALL( INSTRUMENT_PAYMENT_USE_ID,

Line 732: INSERT INTO IBY_PMT_INSTR_USES_ALL( INSTRUMENT_PAYMENT_USE_ID,

728: fnd_file.put_line(FND_FILE.OUTPUT, 'Before insering into table IBY_PMT_INSTR_USES_ALL');
729:
730: FORALL i IN payment_id_tab.first .. payment_id_tab.last SAVE EXCEPTIONS
731:
732: INSERT INTO IBY_PMT_INSTR_USES_ALL( INSTRUMENT_PAYMENT_USE_ID,
733: EXT_PMT_PARTY_ID,
734: INSTRUMENT_TYPE,
735: INSTRUMENT_ID,
736: PAYMENT_FUNCTION,

Line 776: fnd_file.put_line(FND_FILE.OUTPUT, 'After insering into table IBY_PMT_INSTR_USES_ALL');

772: and cust_account_id is null
773: and acct_site_use_id is null
774: and rownum = 1;
775:
776: fnd_file.put_line(FND_FILE.OUTPUT, 'After insering into table IBY_PMT_INSTR_USES_ALL');
777:
778: EXCEPTION
779:
780: WHEN OTHERS THEN

Line 787: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_PMT_INSTR_USES_ALL for Payment Id: ' || payment_id_tab(j));

783: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
784:
785: fnd_file.put_line(FND_FILE.OUTPUT, 'Error occurred during iteration ' || SQL%BULK_EXCEPTIONS(j).ERROR_INDEX || ' Oracle error is ' || SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
786:
787: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_PMT_INSTR_USES_ALL for Payment Id: ' || payment_id_tab(j));
788: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_PMT_INSTR_USES_ALL for Instrument Assignment Id: ' || instr_assignment_id_tab(j));
789: END LOOP;
790:
791: END; --end5

Line 788: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_PMT_INSTR_USES_ALL for Instrument Assignment Id: ' || instr_assignment_id_tab(j));

784:
785: fnd_file.put_line(FND_FILE.OUTPUT, 'Error occurred during iteration ' || SQL%BULK_EXCEPTIONS(j).ERROR_INDEX || ' Oracle error is ' || SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
786:
787: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_PMT_INSTR_USES_ALL for Payment Id: ' || payment_id_tab(j));
788: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_PMT_INSTR_USES_ALL for Instrument Assignment Id: ' || instr_assignment_id_tab(j));
789: END LOOP;
790:
791: END; --end5
792:

Line 851: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_PMT_INSTR_USES_ALL for trxn_ref_number1_tab(j): ' || trxn_ref_number1_tab(j));

847: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
848:
849: fnd_file.put_line(FND_FILE.OUTPUT, 'Error occurred during iteration ' || SQL%BULK_EXCEPTIONS(j).ERROR_INDEX || ' Oracle error is ' || SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
850:
851: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_PMT_INSTR_USES_ALL for trxn_ref_number1_tab(j): ' || trxn_ref_number1_tab(j));
852: END LOOP;
853:
854: END; --end6
855: END IF; -- for payment table count