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_PAYMENTS

Line 130: -- but not in oe_payments for closed orders

126: -- assignment id from IBY_UPG_INSTRUMENTS. With the instrument assignemen id, we can directly
127: -- create and insert a new record in Oracle Payments table IBY_FNDCPT_TX_EXTENSIONS.
128:
129: -- Define a cursor payments_cur1 to select the payment data that only exist in oe_order_headers_all
130: -- but not in oe_payments for closed orders
131:
132: CURSOR payments_cur1 (p_start_rowid ROWID, p_end_rowid ROWID, l_cutoff_date DATE) is
133: SELECT /*+ LEADING (OOH) */ ooh.header_id,
134: null line_id, -- line_id

Line 151: FROM oe_payments op

147: WHERE ooh.open_flag = 'N'
148: AND ooh.payment_type_code = 'CREDIT_CARD'
149: AND ooh.ordered_date >= l_cutoff_date
150: AND NOT EXISTS ( SELECT 'Y'
151: FROM oe_payments op
152: WHERE op.header_id = ooh.header_id )
153: AND ita.authcode(+) = ooh.credit_card_approval_code
154: AND ita.updatedate(+) = ooh.credit_card_approval_date
155: AND ita.reqtype(+) = 'ORAPMTREQ'

Line 193: FROM oe_payments op

189: WHERE ooh.open_flag = 'N'
190: AND ooh.payment_type_code = 'CREDIT_CARD'
191: AND ooh.ordered_date >= l_cutoff_date
192: AND NOT EXISTS ( SELECT 'Y'
193: FROM oe_payments op
194: WHERE op.header_id = ooh.header_id )
195: AND ita.authcode(+) = ooh.credit_card_approval_code
196: AND ita.updatedate(+) = ooh.credit_card_approval_date
197: AND ita.reqtype(+) = 'ORAPMTREQ'

Line 215: -- Define another cursor payments_cur2 to select payment data that only exist in oe_payments

211: AND seg.cc_number_hash2 = cc.cc_number_hash2)
212: AND cc.instrid = uba.instrument_id
213: AND ooh.rowid BETWEEN p_start_rowid AND p_end_rowid ;
214:
215: -- Define another cursor payments_cur2 to select payment data that only exist in oe_payments
216: -- but not in oe_order_headers_all
217:
218: CURSOR payments_cur2 (p_start_rowid ROWID, p_end_rowid ROWID, l_cutoff_date DATE) is
219: SELECT /*+ LEADING (OP) */ op.header_id,

Line 233: oe_payments op

229: ap_bank_accounts_all ba,
230: ap_bank_account_uses_all bau,
231: iby_trans_all_v ita,
232: iby_upg_instruments uba,
233: oe_payments op
234: WHERE ooh.open_flag = 'N'
235: AND ooh.ordered_date >= l_cutoff_date
236: AND ooh.header_id = op.header_id
237: AND op.trxn_extension_id is null

Line 274: oe_payments op,

270: hz_cust_site_uses_all su,
271: hz_cust_acct_sites_all cas,
272: iby_trans_all_v ita,
273: iby_upg_instruments uba,
274: oe_payments op,
275: iby_security_segments seg,
276: iby_creditcard cc
277: WHERE ooh.open_flag = 'N'
278: AND ooh.ordered_date >= l_cutoff_date

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

300: AND cc.instrid = uba.instrument_id
301: AND op.rowid BETWEEN p_start_rowid AND p_end_rowid ;
302:
303: -- Define another cursor payments_cur3 to select payment data with ACH and Direct Debit payment types
304: -- that only exist in oe_payments but not in oe_order_headers_all, for these payment types,
305: -- we only need join with iby_upg_assignments directly to get the instrument assignment id and
306: -- then directly insert into iby_trxn_extensions table.
307:
308: CURSOR payments_cur3 (p_start_rowid ROWID, p_end_rowid ROWID, l_cutoff_date DATE) is

Line 319: oe_payments op

315: FROM oe_order_headers_all ooh,
316: hz_cust_site_uses_all su,
317: hz_cust_acct_sites_all cas,
318: iby_upg_instruments uba,
319: oe_payments op
320: WHERE ooh.open_flag = 'N'
321: AND ooh.ordered_date >= l_cutoff_date
322: AND ooh.header_id = op.header_id
323: AND op.trxn_extension_id is null

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

358: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);
359:
360: l_cutoff_date := NVL(fnd_profile.value('IBY_CREDITCARD_CUTOFF_DATE'), to_date('01/01/1000', 'DD/MM/YYYY')) ;
361:
362: -- migrate data in oe_oe_order_headers_all and not exist in oe_payments
363: BEGIN
364: -----------------------------------------------------------
365: -- Fetching records from OE_ORDER_HEADERS_ALL table
366: -----------------------------------------------------------

Line 495: INSERT INTO OE_PAYMENTS

491: l_user_id,
492: 1) ;
493:
494: FORALL i in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS
495: INSERT INTO OE_PAYMENTS
496: (trxn_extension_id,
497: payment_level_code,
498: payment_number,
499: header_id,

Line 598: -- Migrate data in oe_payments for Credit Card payment types.

594: IF l_debug_level > 0 THEN
595: oe_debug_pub.add('Total No of records errored in oe_order_headers_all : ' || l_error_total) ;
596: END IF;
597:
598: -- Migrate data in oe_payments for Credit Card payment types.
599: BEGIN
600: -----------------------------------------------------------
601: -- Fetching records from OE_PAYMENTS table
602: -----------------------------------------------------------

Line 601: -- Fetching records from OE_PAYMENTS table

597:
598: -- Migrate data in oe_payments for Credit Card payment types.
599: BEGIN
600: -----------------------------------------------------------
601: -- Fetching records from OE_PAYMENTS table
602: -----------------------------------------------------------
603: l_table_name := 'OE_PAYMENTS' ;
604:
605: ad_parallel_updates_pkg.delete_update_information(

Line 603: l_table_name := 'OE_PAYMENTS' ;

599: BEGIN
600: -----------------------------------------------------------
601: -- Fetching records from OE_PAYMENTS table
602: -----------------------------------------------------------
603: l_table_name := 'OE_PAYMENTS' ;
604:
605: ad_parallel_updates_pkg.delete_update_information(
606: 0,
607: l_table_owner,

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

624: X_batch_size,
625: TRUE) ;
626:
627: fnd_file.put_line(FND_FILE.OUTPUT, '');
628: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_PAYMENTS table');
629:
630: IF l_debug_level > 0 THEN
631: oe_debug_pub.add('') ;
632: oe_debug_pub.add('AD parallel details : ') ;

Line 730: UPDATE OE_PAYMENTS

726: l_user_id,
727: 1) ;
728:
729: FORALL i in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS
730: UPDATE OE_PAYMENTS
731: SET trxn_extension_id = trxn_entity_id_tab(i),
732: last_update_date = sysdate,
733: last_updated_by = l_user_id,
734: last_update_login = l_user_id

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

758: IF l_debug_level > 0 THEN
759: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
760: END IF;
761:
762: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_PAYMENTS table');
763: EXCEPTION
764: WHEN NO_DATA_FOUND THEN
765: IF l_debug_level > 0 THEN
766: oe_debug_pub.add('') ;

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

763: EXCEPTION
764: WHEN NO_DATA_FOUND THEN
765: IF l_debug_level > 0 THEN
766: oe_debug_pub.add('') ;
767: oe_debug_pub.add('No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
768: END IF;
769:
770: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
771: WHEN OTHERS THEN

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

766: oe_debug_pub.add('') ;
767: oe_debug_pub.add('No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
768: END IF;
769:
770: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
771: WHEN OTHERS THEN
772: l_error_total := SQL%BULK_EXCEPTIONS.COUNT ;
773:
774: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP

Line 782: 'upgrade failing in oe_payments for credit card for Header ID ' ||

778: ' Oracle error is ' ||
779: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
780:
781: fnd_file.put_line(FND_FILE.OUTPUT,
782: 'upgrade failing in oe_payments for credit card for Header ID ' ||
783: header_id_tab(j));
784: END LOOP;
785: END ;
786:

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

784: END LOOP;
785: END ;
786:
787: IF l_debug_level > 0 THEN
788: oe_debug_pub.add('Total No of records errored in oe_payments : ' || l_error_total) ;
789: END IF;
790:
791: -- migrate data in oe_payments for ACH and Direct Debit payment types.
792: BEGIN

Line 791: -- migrate data in oe_payments for ACH and Direct Debit payment types.

787: IF l_debug_level > 0 THEN
788: oe_debug_pub.add('Total No of records errored in oe_payments : ' || l_error_total) ;
789: END IF;
790:
791: -- migrate data in oe_payments for ACH and Direct Debit payment types.
792: BEGIN
793: -----------------------------------------------------------
794: -- Fetching records from OE_PAYMENTS table
795: -----------------------------------------------------------

Line 794: -- Fetching records from OE_PAYMENTS table

790:
791: -- migrate data in oe_payments for ACH and Direct Debit payment types.
792: BEGIN
793: -----------------------------------------------------------
794: -- Fetching records from OE_PAYMENTS table
795: -----------------------------------------------------------
796: l_table_name := 'OE_PAYMENTS' ;
797:
798: ad_parallel_updates_pkg.delete_update_information(

Line 796: l_table_name := 'OE_PAYMENTS' ;

792: BEGIN
793: -----------------------------------------------------------
794: -- Fetching records from OE_PAYMENTS table
795: -----------------------------------------------------------
796: l_table_name := 'OE_PAYMENTS' ;
797:
798: ad_parallel_updates_pkg.delete_update_information(
799: 0,
800: l_table_owner,

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

817: X_batch_size,
818: TRUE) ;
819:
820: fnd_file.put_line(FND_FILE.OUTPUT, '');
821: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_PAYMENTS table');
822:
823: IF l_debug_level > 0 THEN
824: oe_debug_pub.add('') ;
825: oe_debug_pub.add('AD parallel details : ') ;

Line 903: UPDATE OE_PAYMENTS

899: l_user_id,
900: 1) ;
901:
902: FORALL i in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS
903: UPDATE OE_PAYMENTS
904: SET trxn_extension_id = trxn_entity_id_tab(i),
905: last_update_date = sysdate,
906: last_updated_by = l_user_id,
907: last_update_login = l_user_id

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

931: IF l_debug_level > 0 THEN
932: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
933: END IF;
934:
935: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_PAYMENTS table');
936:
937: EXCEPTION
938: WHEN NO_DATA_FOUND THEN
939: IF l_debug_level > 0 THEN

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

937: EXCEPTION
938: WHEN NO_DATA_FOUND THEN
939: IF l_debug_level > 0 THEN
940: oe_debug_pub.add('') ;
941: oe_debug_pub.add('No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
942: END IF;
943:
944: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
945: WHEN OTHERS THEN

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

940: oe_debug_pub.add('') ;
941: oe_debug_pub.add('No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
942: END IF;
943:
944: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
945: WHEN OTHERS THEN
946: l_error_total := SQL%BULK_EXCEPTIONS.COUNT ;
947:
948: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP

Line 956: 'upgrade failing in oe_payments for credit card for Header ID ' || header_id_tab(j));

952: ' Oracle error is ' ||
953: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
954:
955: fnd_file.put_line(FND_FILE.OUTPUT,
956: 'upgrade failing in oe_payments for credit card for Header ID ' || header_id_tab(j));
957: END LOOP;
958: END ;
959:
960: IF l_debug_level > 0 THEN

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

957: END LOOP;
958: END ;
959:
960: IF l_debug_level > 0 THEN
961: oe_debug_pub.add('Total No of records errored in oe_payments : ' || l_error_total) ;
962: END IF;
963:
964: COMMIT ;
965:

Line 1061: -- Define a cursor oe_payments_cur to select header_id from oe_payments where

1057: l_process_total1 NUMBER := 0 ;
1058:
1059: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level ;
1060:
1061: -- Define a cursor oe_payments_cur to select header_id from oe_payments where
1062: -- payment type code in ('CREDIT_CARD', 'ACH', 'DIRECT_DEBIT'), for the given IN parameters
1063:
1064: CURSOR oe_payments_cur (p_start_rowid ROWID, p_end_rowid ROWID) is
1065: SELECT /*+ LEADING (OP) */ op.header_id,

Line 1064: CURSOR oe_payments_cur (p_start_rowid ROWID, p_end_rowid ROWID) is

1060:
1061: -- Define a cursor oe_payments_cur to select header_id from oe_payments where
1062: -- payment type code in ('CREDIT_CARD', 'ACH', 'DIRECT_DEBIT'), for the given IN parameters
1063:
1064: CURSOR oe_payments_cur (p_start_rowid ROWID, p_end_rowid ROWID) is
1065: SELECT /*+ LEADING (OP) */ op.header_id,
1066: op.rowid
1067: FROM oe_payments op
1068: WHERE ((op.payment_type_code = 'CREDIT_CARD' AND op.credit_card_number IS NOT NULL)

Line 1067: FROM oe_payments op

1063:
1064: CURSOR oe_payments_cur (p_start_rowid ROWID, p_end_rowid ROWID) is
1065: SELECT /*+ LEADING (OP) */ op.header_id,
1066: op.rowid
1067: FROM oe_payments op
1068: WHERE ((op.payment_type_code = 'CREDIT_CARD' AND op.credit_card_number IS NOT NULL)
1069: OR (op.payment_type_code IN ('ACH', 'DIRECT_DEBIT') AND op.payment_trx_id IS NOT NULL))
1070: AND op.trxn_extension_id IS NOT NULL
1071: AND op.rowid BETWEEN p_start_rowid AND p_end_rowid ;

Line 1119: -- Fetching records from OE_PAYMENTS table

1115: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);
1116:
1117: BEGIN
1118: -----------------------------------------------------------
1119: -- Fetching records from OE_PAYMENTS table
1120: -----------------------------------------------------------
1121: l_table_name := 'OE_PAYMENTS' ;
1122:
1123: ad_parallel_updates_pkg.delete_update_information(

Line 1121: l_table_name := 'OE_PAYMENTS' ;

1117: BEGIN
1118: -----------------------------------------------------------
1119: -- Fetching records from OE_PAYMENTS table
1120: -----------------------------------------------------------
1121: l_table_name := 'OE_PAYMENTS' ;
1122:
1123: ad_parallel_updates_pkg.delete_update_information(
1124: 0,
1125: l_table_owner,

Line 1148: FROM oe_payments

1144:
1145: BEGIN
1146: SELECT 'Y'
1147: INTO l_exists_payment
1148: FROM oe_payments
1149: WHERE ((payment_type_code = 'CREDIT_CARD' AND credit_card_number IS NOT NULL)
1150: OR (payment_type_code IN ('ACH', 'DIRECT_DEBIT') AND payment_trx_id IS NOT NULL))
1151: AND trxn_extension_id IS NULL
1152: AND ROWNUM = 1 ;

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

1153: EXCEPTION
1154: WHEN NO_DATA_FOUND THEN
1155: IF l_debug_level > 0 THEN
1156: oe_debug_pub.add('') ;
1157: oe_debug_pub.add('No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
1158: END IF;
1159:
1160: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
1161: END;

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

1156: oe_debug_pub.add('') ;
1157: oe_debug_pub.add('No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
1158: END IF;
1159:
1160: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
1161: END;
1162:
1163: BEGIN
1164: SELECT 'Y'

Line 1167: oe_payments op

1163: BEGIN
1164: SELECT 'Y'
1165: INTO l_exists_header
1166: FROM oe_order_headers_all ooh,
1167: oe_payments op
1168: WHERE op.payment_type_code = 'CREDIT_CARD'
1169: AND op.credit_card_number IS NOT NULL
1170: AND ooh.header_id = op.header_id
1171: AND op.trxn_extension_id IS NULL

Line 1204: oe_debug_pub.add('Data NOT migrated from OE_PAYMENTS table (Y/N) : ' || l_exists_payment) ;

1200: IF l_exists_header = 'Y' OR l_exists_payment = 'Y' OR l_exists_history = 'Y' THEN
1201: IF l_debug_level > 0 THEN
1202: oe_debug_pub.add('') ;
1203: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;
1204: oe_debug_pub.add('Data NOT migrated from OE_PAYMENTS table (Y/N) : ' || l_exists_payment) ;
1205: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;
1206: oe_debug_pub.add('Please migrate the data before proceeding to purge secured payment data') ;
1207: END IF;
1208:

Line 1210: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_PAYMENTS table (Y/N) : ' || l_exists_payment) ;

1206: oe_debug_pub.add('Please migrate the data before proceeding to purge secured payment data') ;
1207: END IF;
1208:
1209: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;
1210: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_PAYMENTS table (Y/N) : ' || l_exists_payment) ;
1211: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;
1212: fnd_file.put_line(FND_FILE.OUTPUT, 'Please migrate the data before proceeding to purge secured payment data') ;
1213:
1214: RETURN ;

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

1214: RETURN ;
1215: END IF ;
1216:
1217: fnd_file.put_line(FND_FILE.OUTPUT, '');
1218: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_PAYMENTS table');
1219:
1220: IF l_debug_level > 0 THEN
1221: oe_debug_pub.add('') ;
1222: oe_debug_pub.add('AD parallel details : ') ;

Line 1239: OPEN oe_payments_cur(l_start_rowid, l_end_rowid) ;

1235: WHILE (l_any_rows_to_process = TRUE) LOOP
1236: header_id_tab.delete ;
1237: row_id_tab.delete ;
1238:
1239: OPEN oe_payments_cur(l_start_rowid, l_end_rowid) ;
1240:
1241: FETCH oe_payments_cur BULK COLLECT INTO
1242: header_id_tab, row_id_tab
1243: LIMIT X_batch_size ;

Line 1241: FETCH oe_payments_cur BULK COLLECT INTO

1237: row_id_tab.delete ;
1238:
1239: OPEN oe_payments_cur(l_start_rowid, l_end_rowid) ;
1240:
1241: FETCH oe_payments_cur BULK COLLECT INTO
1242: header_id_tab, row_id_tab
1243: LIMIT X_batch_size ;
1244:
1245: CLOSE oe_payments_cur ;

Line 1245: CLOSE oe_payments_cur ;

1241: FETCH oe_payments_cur BULK COLLECT INTO
1242: header_id_tab, row_id_tab
1243: LIMIT X_batch_size ;
1244:
1245: CLOSE oe_payments_cur ;
1246:
1247: -- oe_debug_pub.add('Number of Records : ' || header_id_tab.count) ;
1248:
1249: IF header_id_tab.count > 0 THEN

Line 1252: UPDATE oe_payments

1248:
1249: IF header_id_tab.count > 0 THEN
1250: BEGIN
1251: FORALL i in header_id_tab.FIRST..header_id_tab.LAST SAVE EXCEPTIONS
1252: UPDATE oe_payments
1253: SET credit_card_number = null,
1254: credit_card_holder_name = null,
1255: credit_card_expiration_date = null,
1256: credit_card_code = null,

Line 1277: 'Update failing at OE_PAYMENTS from OE_PAYMENTS_CUR for Header ID ' ||

1273: ' Oracle error is ' ||
1274: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
1275:
1276: fnd_file.put_line(FND_FILE.OUTPUT,
1277: 'Update failing at OE_PAYMENTS from OE_PAYMENTS_CUR for Header ID ' ||
1278: header_id_tab(j));
1279: END LOOP;
1280: END;
1281:

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

1299: END LOOP ;
1300:
1301: IF l_debug_level > 0 THEN
1302: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
1303: oe_debug_pub.add('Total No of records errored in OE_PAYMENTS : ' || l_error_total1) ;
1304: END IF;
1305:
1306: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_PAYMENTS table');
1307:

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

1302: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
1303: oe_debug_pub.add('Total No of records errored in OE_PAYMENTS : ' || l_error_total1) ;
1304: END IF;
1305:
1306: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_PAYMENTS table');
1307:
1308: EXCEPTION
1309: WHEN NO_DATA_FOUND THEN
1310: IF l_debug_level > 0 THEN

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

1308: EXCEPTION
1309: WHEN NO_DATA_FOUND THEN
1310: IF l_debug_level > 0 THEN
1311: oe_debug_pub.add('') ;
1312: oe_debug_pub.add('No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
1313: END IF;
1314:
1315: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
1316: END ;

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

1311: oe_debug_pub.add('') ;
1312: oe_debug_pub.add('No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
1313: END IF;
1314:
1315: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
1316: END ;
1317:
1318: BEGIN
1319: -----------------------------------------------------------