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.OE_PAYMENT_DATA_MIGRATION_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 168: -- Define a cursor payments_cur1 to select the payment data that only exist in oe_order_headers_all

164: -- in ap_bank_accounts, so we can get the bank_account_id first, then get the instrument
165: -- assignment id from IBY_UPG_INSTRUMENTS. With the instrument assignemen id, we can directly
166: -- create and insert a new record in Oracle Payments table IBY_FNDCPT_TX_EXTENSIONS.
167:
168: -- Define a cursor payments_cur1 to select the payment data that only exist in oe_order_headers_all
169: -- but not in oe_payments for closed orders
170:
171: CURSOR payments_cur1 (p_start_rowid ROWID, p_end_rowid ROWID, l_cutoff_date DATE) is
172: SELECT /*+ LEADING (OOH) */ ooh.header_id,

Line 179: FROM oe_order_headers_all ooh,

175: ita.tangibleid,
176: uba.instr_assignment_id,
177: uba.ext_party_id,
178: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
179: FROM oe_order_headers_all ooh,
180: hz_cust_site_uses_all su,
181: hz_cust_acct_sites_all cas,
182: ap_bank_accounts_all ba,
183: ap_bank_account_uses_all bau,

Line 221: FROM oe_order_headers_all ooh,

217: ita.tangibleid,
218: uba.instr_assignment_id,
219: uba.ext_party_id,
220: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
221: FROM oe_order_headers_all ooh,
222: hz_cust_site_uses_all su,
223: hz_cust_acct_sites_all cas,
224: iby_trans_all_v ita,
225: iby_upg_instruments uba,

Line 255: -- but not in oe_order_headers_all

251: AND cc.instrid = uba.instrument_id
252: AND ooh.rowid BETWEEN p_start_rowid AND p_end_rowid ;
253:
254: -- Define another cursor payments_cur2 to select payment data that only exist in oe_payments
255: -- but not in oe_order_headers_all
256:
257: CURSOR payments_cur2 (p_start_rowid ROWID, p_end_rowid ROWID, l_cutoff_date DATE) is
258: SELECT /*+ LEADING (OP) */ op.header_id,
259: op.line_id,

Line 265: FROM oe_order_headers_all ooh,

261: ita.tangibleid,
262: uba.instr_assignment_id,
263: uba.ext_party_id,
264: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
265: FROM oe_order_headers_all ooh,
266: hz_cust_site_uses_all su,
267: hz_cust_acct_sites_all cas,
268: ap_bank_accounts_all ba,
269: ap_bank_account_uses_all bau,

Line 308: FROM oe_order_headers_all ooh,

304: ita.tangibleid,
305: uba.instr_assignment_id,
306: uba.ext_party_id,
307: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
308: FROM oe_order_headers_all ooh,
309: hz_cust_site_uses_all su,
310: hz_cust_acct_sites_all cas,
311: iby_trans_all_v ita,
312: iby_upg_instruments uba,

Line 343: -- that only exist in oe_payments but not in oe_order_headers_all, for these payment types,

339: AND cc.instrid = uba.instrument_id
340: AND op.rowid BETWEEN p_start_rowid AND p_end_rowid ;
341:
342: -- Define another cursor payments_cur3 to select payment data with ACH and Direct Debit payment types
343: -- that only exist in oe_payments but not in oe_order_headers_all, for these payment types,
344: -- we only need join with iby_upg_assignments directly to get the instrument assignment id and
345: -- then directly insert into iby_trxn_extensions table.
346:
347: CURSOR payments_cur3 (p_start_rowid ROWID, p_end_rowid ROWID, l_cutoff_date DATE) is

Line 354: FROM oe_order_headers_all ooh,

350: op.payment_number,
351: uba.instr_assignment_id,
352: uba.ext_party_id,
353: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
354: FROM oe_order_headers_all ooh,
355: hz_cust_site_uses_all su,
356: hz_cust_acct_sites_all cas,
357: iby_upg_instruments uba,
358: oe_payments op

Line 401: -- migrate data in oe_oe_order_headers_all and not exist in oe_payments

397: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);
398:
399: l_cutoff_date := NVL(fnd_profile.value('IBY_CREDITCARD_CUTOFF_DATE'), to_date('01/01/1000', 'DD/MM/YYYY')) ;
400:
401: -- migrate data in oe_oe_order_headers_all and not exist in oe_payments
402: BEGIN
403: -----------------------------------------------------------
404: -- Fetching records from OE_ORDER_HEADERS_ALL table
405: -----------------------------------------------------------

Line 404: -- Fetching records from OE_ORDER_HEADERS_ALL table

400:
401: -- migrate data in oe_oe_order_headers_all and not exist in oe_payments
402: BEGIN
403: -----------------------------------------------------------
404: -- Fetching records from OE_ORDER_HEADERS_ALL table
405: -----------------------------------------------------------
406: l_table_name := 'OE_ORDER_HEADERS_ALL' ;
407:
408: ad_parallel_updates_pkg.delete_update_information(

Line 406: l_table_name := 'OE_ORDER_HEADERS_ALL' ;

402: BEGIN
403: -----------------------------------------------------------
404: -- Fetching records from OE_ORDER_HEADERS_ALL table
405: -----------------------------------------------------------
406: l_table_name := 'OE_ORDER_HEADERS_ALL' ;
407:
408: ad_parallel_updates_pkg.delete_update_information(
409: 0,
410: l_table_owner,

Line 431: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_ORDER_HEADERS_ALL table');

427: X_batch_size,
428: TRUE) ;
429:
430: fnd_file.put_line(FND_FILE.OUTPUT, '');
431: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_ORDER_HEADERS_ALL table');
432:
433: IF l_debug_level > 0 THEN
434: oe_debug_pub.add('') ;
435: oe_debug_pub.add('AD parallel details : ') ;

Line 584: fnd_file.put_line(FND_FILE.OUTPUT, 'Inner Block :upgrading failing for data from oe_order_headers_all for Header ID ' || header_id_tab(j));

580: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
581: ' Oracle error is ' ||
582: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
583:
584: fnd_file.put_line(FND_FILE.OUTPUT, 'Inner Block :upgrading failing for data from oe_order_headers_all for Header ID ' || header_id_tab(j));
585: END LOOP;
586: END ;
587: --6757060
588:

Line 607: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_ORDER_HEADERS_ALL table');

603: IF l_debug_level > 0 THEN
604: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
605: END IF;
606:
607: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_ORDER_HEADERS_ALL table');
608: EXCEPTION
609: WHEN NO_DATA_FOUND THEN
610:
611: IF l_debug_level > 0 THEN

Line 613: oe_debug_pub.add('No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;

609: WHEN NO_DATA_FOUND THEN
610:
611: IF l_debug_level > 0 THEN
612: oe_debug_pub.add('') ;
613: oe_debug_pub.add('No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
614: END IF;
615:
616: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
617: WHEN OTHERS THEN

Line 616: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;

612: oe_debug_pub.add('') ;
613: oe_debug_pub.add('No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
614: END IF;
615:
616: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
617: WHEN OTHERS THEN
618: l_error_total := SQL%BULK_EXCEPTIONS.COUNT ;
619:
620: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP

Line 628: 'upgrading failing for data from oe_order_headers_all for Header ID ' ||

624: ' Oracle error is ' ||
625: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
626:
627: fnd_file.put_line(FND_FILE.OUTPUT,
628: 'upgrading failing for data from oe_order_headers_all for Header ID ' ||
629: header_id_tab(j));
630: END LOOP;
631: END ;
632:

Line 634: oe_debug_pub.add('Total No of records errored in oe_order_headers_all : ' || l_error_total) ;

630: END LOOP;
631: END ;
632:
633: IF l_debug_level > 0 THEN
634: oe_debug_pub.add('Total No of records errored in oe_order_headers_all : ' || l_error_total) ;
635: END IF;
636:
637: -- Migrate data in oe_payments for Credit Card payment types.
638: BEGIN

Line 1112: -- Define another cursor header_payments_cur to select header_id from oe_order_headers_all,

1108: OR (op.payment_type_code IN ('ACH', 'DIRECT_DEBIT') AND op.payment_trx_id IS NOT NULL))
1109: AND op.trxn_extension_id IS NOT NULL
1110: AND op.rowid BETWEEN p_start_rowid AND p_end_rowid ;
1111:
1112: -- Define another cursor header_payments_cur to select header_id from oe_order_headers_all,
1113: -- where payment type = 'CREDIT_CARD' for the given IN parameters
1114:
1115: CURSOR header_payments_cur (p_start_rowid ROWID, p_end_rowid ROWID) is
1116: SELECT /*+ LEADING (OOH) */ ooh.header_id,

Line 1118: FROM oe_order_headers_all ooh

1114:
1115: CURSOR header_payments_cur (p_start_rowid ROWID, p_end_rowid ROWID) is
1116: SELECT /*+ LEADING (OOH) */ ooh.header_id,
1117: ooh.rowid
1118: FROM oe_order_headers_all ooh
1119: WHERE (ooh.payment_type_code = 'CREDIT_CARD' AND ooh.credit_card_number IS NOT NULL)
1120: AND ooh.rowid BETWEEN p_start_rowid AND p_end_rowid ;
1121:
1122: -- cursor to select from oe_order_header_history

Line 1205: FROM oe_order_headers_all ooh,

1201:
1202: BEGIN
1203: SELECT 'Y'
1204: INTO l_exists_header
1205: FROM oe_order_headers_all ooh,
1206: oe_payments op
1207: WHERE op.payment_type_code = 'CREDIT_CARD'
1208: AND op.credit_card_number IS NOT NULL
1209: AND ooh.header_id = op.header_id

Line 1216: oe_debug_pub.add('No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;

1212: EXCEPTION
1213: WHEN NO_DATA_FOUND THEN
1214: IF l_debug_level > 0 THEN
1215: oe_debug_pub.add('') ;
1216: oe_debug_pub.add('No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
1217: END IF;
1218:
1219: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
1220: END;

Line 1219: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;

1215: oe_debug_pub.add('') ;
1216: oe_debug_pub.add('No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
1217: END IF;
1218:
1219: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
1220: END;
1221:
1222: BEGIN
1223: SELECT 'Y'

Line 1242: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;

1238:
1239: IF l_exists_header = 'Y' OR l_exists_payment = 'Y' OR l_exists_history = 'Y' THEN
1240: IF l_debug_level > 0 THEN
1241: oe_debug_pub.add('') ;
1242: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;
1243: oe_debug_pub.add('Data NOT migrated from OE_PAYMENTS table (Y/N) : ' || l_exists_payment) ;
1244: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;
1245: oe_debug_pub.add('Please migrate the data before proceeding to purge secured payment data') ;
1246: END IF;

Line 1248: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;

1244: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;
1245: oe_debug_pub.add('Please migrate the data before proceeding to purge secured payment data') ;
1246: END IF;
1247:
1248: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;
1249: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_PAYMENTS table (Y/N) : ' || l_exists_payment) ;
1250: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;
1251: fnd_file.put_line(FND_FILE.OUTPUT, 'Please migrate the data before proceeding to purge secured payment data') ;
1252:

Line 1359: -- Fetching records from OE_ORDER_HEADERS_ALL table

1355: END ;
1356:
1357: BEGIN
1358: -----------------------------------------------------------
1359: -- Fetching records from OE_ORDER_HEADERS_ALL table
1360: -----------------------------------------------------------
1361: l_table_name := 'OE_ORDER_HEADERS_ALL' ;
1362:
1363: ad_parallel_updates_pkg.delete_update_information(

Line 1361: l_table_name := 'OE_ORDER_HEADERS_ALL' ;

1357: BEGIN
1358: -----------------------------------------------------------
1359: -- Fetching records from OE_ORDER_HEADERS_ALL table
1360: -----------------------------------------------------------
1361: l_table_name := 'OE_ORDER_HEADERS_ALL' ;
1362:
1363: ad_parallel_updates_pkg.delete_update_information(
1364: 0,
1365: l_table_owner,

Line 1386: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_ORDER_HEADERS_ALL table');

1382: X_batch_size,
1383: TRUE) ;
1384:
1385: fnd_file.put_line(FND_FILE.OUTPUT, '');
1386: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_ORDER_HEADERS_ALL table');
1387:
1388: IF l_debug_level > 0 THEN
1389: oe_debug_pub.add('') ;
1390: oe_debug_pub.add('AD parallel details : ') ;

Line 1420: UPDATE oe_order_headers_all

1416:
1417: IF header_id_tab.count > 0 THEN
1418: BEGIN
1419: FORALL i in header_id_tab.FIRST..header_id_tab.LAST SAVE EXCEPTIONS
1420: UPDATE oe_order_headers_all
1421: SET credit_card_number = null,
1422: credit_card_holder_name = null,
1423: credit_card_expiration_date = null,
1424: credit_card_code = null,

Line 1443: 'Update failing at OE_ORDER_HEADERS_ALL from HEADER_PAYMENTS_CUR ' ||

1439: ' Oracle error is ' ||
1440: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
1441:
1442: fnd_file.put_line(FND_FILE.OUTPUT,
1443: 'Update failing at OE_ORDER_HEADERS_ALL from HEADER_PAYMENTS_CUR ' ||
1444: header_id_tab(j));
1445: END LOOP;
1446: END;
1447:

Line 1469: oe_debug_pub.add('Total No of records errored in OE_ORDER_HEADERS_ALL : ' || l_error_total1) ;

1465: END LOOP ;
1466:
1467: IF l_debug_level > 0 THEN
1468: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
1469: oe_debug_pub.add('Total No of records errored in OE_ORDER_HEADERS_ALL : ' || l_error_total1) ;
1470: END IF;
1471:
1472: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_ORDER_HEADERS_ALL table');
1473:

Line 1472: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_ORDER_HEADERS_ALL table');

1468: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
1469: oe_debug_pub.add('Total No of records errored in OE_ORDER_HEADERS_ALL : ' || l_error_total1) ;
1470: END IF;
1471:
1472: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_ORDER_HEADERS_ALL table');
1473:
1474: EXCEPTION
1475: WHEN NO_DATA_FOUND THEN
1476: IF l_debug_level > 0 THEN

Line 1478: oe_debug_pub.add('No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;

1474: EXCEPTION
1475: WHEN NO_DATA_FOUND THEN
1476: IF l_debug_level > 0 THEN
1477: oe_debug_pub.add('') ;
1478: oe_debug_pub.add('No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
1479: END IF;
1480:
1481: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
1482: END ;

Line 1481: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;

1477: oe_debug_pub.add('') ;
1478: oe_debug_pub.add('No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
1479: END IF;
1480:
1481: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
1482: END ;
1483:
1484:
1485: -- start processing oe_order_header_history