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_FNDCPT_TX_EXTENSIONS

Line 153: IBY_FNDCPT_TX_EXTENSIONS_S.nextval, --trxn_extension_id

149: pmt.credit_card_expiration_date,
150: to_char(pmt.payment_id) ||'-'|| hdr.quote_number, --order_id
151: to_char(hdr.quote_header_id) trxn_ref_number1,
152: nvl(hdr.invoice_to_cust_party_id, hdr.cust_party_id), --party_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

Line 197: iby_fndcpt_tx_extensions_s.nextval, --trxn_extension_id

193: pmt.credit_card_expiration_date,
194: to_char(pmt.payment_id) ||'-'|| hdr.quote_number, --order_id
195: to_char(hdr.quote_header_id) trxn_ref_number1,
196: nvl(hdr.invoice_to_cust_party_id, hdr.cust_party_id), --party_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

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

515: -- insert the transactions into IBY transaction extension table
516:
517: BEGIN --begin3
518:
519: fnd_file.put_line(FND_FILE.OUTPUT, 'Before insering into table IBY_FNDCPT_TX_EXTENSIONS');
520:
521: FORALL i IN payment_id_tab.first .. payment_id_tab.last SAVE EXCEPTIONS
522:
523: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS( TRXN_EXTENSION_ID,

Line 523: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS( TRXN_EXTENSION_ID,

519: fnd_file.put_line(FND_FILE.OUTPUT, 'Before insering into table IBY_FNDCPT_TX_EXTENSIONS');
520:
521: FORALL i IN payment_id_tab.first .. payment_id_tab.last SAVE EXCEPTIONS
522:
523: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS( TRXN_EXTENSION_ID,
524: PAYMENT_CHANNEL_CODE,
525: INSTR_ASSIGNMENT_ID,
526: ORDER_ID,
527: PO_NUMBER,

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

557: 'Y',
558: 679
559: );
560:
561: fnd_file.put_line(FND_FILE.OUTPUT, 'After insering into table IBY_FNDCPT_TX_EXTENSIONS');
562:
563: EXCEPTION
564:
565: WHEN OTHERS THEN

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

794: -- insert the transactions into IBY transaction extension table
795:
796: BEGIN -- begin6
797:
798: fnd_file.put_line(FND_FILE.OUTPUT, 'Before insering into table IBY_FNDCPT_TX_EXTENSIONS');
799:
800: FORALL i IN payment_id_tab.first .. payment_id_tab.last SAVE EXCEPTIONS
801:
802: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS( TRXN_EXTENSION_ID,

Line 802: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS( TRXN_EXTENSION_ID,

798: fnd_file.put_line(FND_FILE.OUTPUT, 'Before insering into table IBY_FNDCPT_TX_EXTENSIONS');
799:
800: FORALL i IN payment_id_tab.first .. payment_id_tab.last SAVE EXCEPTIONS
801:
802: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS( TRXN_EXTENSION_ID,
803: PAYMENT_CHANNEL_CODE,
804: INSTR_ASSIGNMENT_ID,
805: ORDER_ID,
806: PO_NUMBER,

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

836: 'Y',
837: 679
838: );
839:
840: fnd_file.put_line(FND_FILE.OUTPUT, 'After insering into table IBY_FNDCPT_TX_EXTENSIONS');
841:
842: EXCEPTION
843:
844: WHEN OTHERS THEN