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 169: -- but not in oe_payments for closed orders

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,
173: null line_id, -- line_id

Line 190: FROM oe_payments op

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

Line 232: FROM oe_payments op

228: WHERE ooh.open_flag = 'N'
229: AND ooh.payment_type_code = 'CREDIT_CARD'
230: AND ooh.ordered_date >= l_cutoff_date
231: AND NOT EXISTS ( SELECT 'Y'
232: FROM oe_payments op
233: WHERE op.header_id = ooh.header_id )
234: AND ita.authcode(+) = ooh.credit_card_approval_code
235: AND ita.updatedate(+) = ooh.credit_card_approval_date
236: AND ita.reqtype(+) = 'ORAPMTREQ'

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

250: AND seg.cc_number_hash2 = cc.cc_number_hash2)
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,

Line 272: oe_payments op

268: ap_bank_accounts_all ba,
269: ap_bank_account_uses_all bau,
270: iby_trans_all_v ita,
271: iby_upg_instruments uba,
272: oe_payments op
273: WHERE ooh.open_flag = 'N'
274: AND ooh.ordered_date >= l_cutoff_date
275: AND ooh.header_id = op.header_id
276: AND op.trxn_extension_id is null

Line 313: oe_payments op,

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,
313: oe_payments op,
314: iby_security_segments seg,
315: iby_creditcard cc
316: WHERE ooh.open_flag = 'N'
317: AND ooh.ordered_date >= l_cutoff_date

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 358: oe_payments op

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
359: WHERE ooh.open_flag = 'N'
360: AND ooh.ordered_date >= l_cutoff_date
361: AND ooh.header_id = op.header_id
362: AND op.trxn_extension_id is null

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 534: INSERT INTO OE_PAYMENTS

530: l_user_id,
531: 1) ;
532:
533: FORALL i in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS
534: INSERT INTO OE_PAYMENTS
535: (trxn_extension_id,
536: payment_level_code,
537: payment_number,
538: header_id,

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

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
639: -----------------------------------------------------------
640: -- Fetching records from OE_PAYMENTS table
641: -----------------------------------------------------------

Line 640: -- Fetching records from OE_PAYMENTS table

636:
637: -- Migrate data in oe_payments for Credit Card payment types.
638: BEGIN
639: -----------------------------------------------------------
640: -- Fetching records from OE_PAYMENTS table
641: -----------------------------------------------------------
642: l_table_name := 'OE_PAYMENTS' ;
643:
644: ad_parallel_updates_pkg.delete_update_information(

Line 642: l_table_name := 'OE_PAYMENTS' ;

638: BEGIN
639: -----------------------------------------------------------
640: -- Fetching records from OE_PAYMENTS table
641: -----------------------------------------------------------
642: l_table_name := 'OE_PAYMENTS' ;
643:
644: ad_parallel_updates_pkg.delete_update_information(
645: 0,
646: l_table_owner,

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

663: X_batch_size,
664: TRUE) ;
665:
666: fnd_file.put_line(FND_FILE.OUTPUT, '');
667: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_PAYMENTS table');
668:
669: IF l_debug_level > 0 THEN
670: oe_debug_pub.add('') ;
671: oe_debug_pub.add('AD parallel details : ') ;

Line 769: UPDATE OE_PAYMENTS

765: l_user_id,
766: 1) ;
767:
768: FORALL i in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS
769: UPDATE OE_PAYMENTS
770: SET trxn_extension_id = trxn_entity_id_tab(i),
771: last_update_date = sysdate,
772: last_updated_by = l_user_id,
773: last_update_login = l_user_id

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

797: IF l_debug_level > 0 THEN
798: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
799: END IF;
800:
801: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_PAYMENTS table');
802: EXCEPTION
803: WHEN NO_DATA_FOUND THEN
804: IF l_debug_level > 0 THEN
805: oe_debug_pub.add('') ;

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

802: EXCEPTION
803: WHEN NO_DATA_FOUND THEN
804: IF l_debug_level > 0 THEN
805: oe_debug_pub.add('') ;
806: oe_debug_pub.add('No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
807: END IF;
808:
809: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
810: WHEN OTHERS THEN

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

805: oe_debug_pub.add('') ;
806: oe_debug_pub.add('No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
807: END IF;
808:
809: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
810: WHEN OTHERS THEN
811: l_error_total := SQL%BULK_EXCEPTIONS.COUNT ;
812:
813: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP

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

817: ' Oracle error is ' ||
818: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
819:
820: fnd_file.put_line(FND_FILE.OUTPUT,
821: 'upgrade failing in oe_payments for credit card for Header ID ' ||
822: header_id_tab(j));
823: END LOOP;
824: END ;
825:

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

823: END LOOP;
824: END ;
825:
826: IF l_debug_level > 0 THEN
827: oe_debug_pub.add('Total No of records errored in oe_payments : ' || l_error_total) ;
828: END IF;
829:
830: -- migrate data in oe_payments for ACH and Direct Debit payment types.
831: BEGIN

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

826: IF l_debug_level > 0 THEN
827: oe_debug_pub.add('Total No of records errored in oe_payments : ' || l_error_total) ;
828: END IF;
829:
830: -- migrate data in oe_payments for ACH and Direct Debit payment types.
831: BEGIN
832: -----------------------------------------------------------
833: -- Fetching records from OE_PAYMENTS table
834: -----------------------------------------------------------

Line 833: -- Fetching records from OE_PAYMENTS table

829:
830: -- migrate data in oe_payments for ACH and Direct Debit payment types.
831: BEGIN
832: -----------------------------------------------------------
833: -- Fetching records from OE_PAYMENTS table
834: -----------------------------------------------------------
835: l_table_name := 'OE_PAYMENTS' ;
836:
837: ad_parallel_updates_pkg.delete_update_information(

Line 835: l_table_name := 'OE_PAYMENTS' ;

831: BEGIN
832: -----------------------------------------------------------
833: -- Fetching records from OE_PAYMENTS table
834: -----------------------------------------------------------
835: l_table_name := 'OE_PAYMENTS' ;
836:
837: ad_parallel_updates_pkg.delete_update_information(
838: 0,
839: l_table_owner,

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

856: X_batch_size,
857: TRUE) ;
858:
859: fnd_file.put_line(FND_FILE.OUTPUT, '');
860: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_PAYMENTS table');
861:
862: IF l_debug_level > 0 THEN
863: oe_debug_pub.add('') ;
864: oe_debug_pub.add('AD parallel details : ') ;

Line 942: UPDATE OE_PAYMENTS

938: l_user_id,
939: 1) ;
940:
941: FORALL i in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS
942: UPDATE OE_PAYMENTS
943: SET trxn_extension_id = trxn_entity_id_tab(i),
944: last_update_date = sysdate,
945: last_updated_by = l_user_id,
946: last_update_login = l_user_id

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

970: IF l_debug_level > 0 THEN
971: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
972: END IF;
973:
974: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_PAYMENTS table');
975:
976: EXCEPTION
977: WHEN NO_DATA_FOUND THEN
978: IF l_debug_level > 0 THEN

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

976: EXCEPTION
977: WHEN NO_DATA_FOUND THEN
978: IF l_debug_level > 0 THEN
979: oe_debug_pub.add('') ;
980: oe_debug_pub.add('No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
981: END IF;
982:
983: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
984: WHEN OTHERS THEN

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

979: oe_debug_pub.add('') ;
980: oe_debug_pub.add('No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
981: END IF;
982:
983: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
984: WHEN OTHERS THEN
985: l_error_total := SQL%BULK_EXCEPTIONS.COUNT ;
986:
987: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP

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

991: ' Oracle error is ' ||
992: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
993:
994: fnd_file.put_line(FND_FILE.OUTPUT,
995: 'upgrade failing in oe_payments for credit card for Header ID ' || header_id_tab(j));
996: END LOOP;
997: END ;
998:
999: IF l_debug_level > 0 THEN

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

996: END LOOP;
997: END ;
998:
999: IF l_debug_level > 0 THEN
1000: oe_debug_pub.add('Total No of records errored in oe_payments : ' || l_error_total) ;
1001: END IF;
1002:
1003: COMMIT ;
1004:

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

1096: l_process_total1 NUMBER := 0 ;
1097:
1098: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level ;
1099:
1100: -- Define a cursor oe_payments_cur to select header_id from oe_payments where
1101: -- payment type code in ('CREDIT_CARD', 'ACH', 'DIRECT_DEBIT'), for the given IN parameters
1102:
1103: CURSOR oe_payments_cur (p_start_rowid ROWID, p_end_rowid ROWID) is
1104: SELECT /*+ LEADING (OP) */ op.header_id,

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

1099:
1100: -- Define a cursor oe_payments_cur to select header_id from oe_payments where
1101: -- payment type code in ('CREDIT_CARD', 'ACH', 'DIRECT_DEBIT'), for the given IN parameters
1102:
1103: CURSOR oe_payments_cur (p_start_rowid ROWID, p_end_rowid ROWID) is
1104: SELECT /*+ LEADING (OP) */ op.header_id,
1105: op.rowid
1106: FROM oe_payments op
1107: WHERE ((op.payment_type_code = 'CREDIT_CARD' AND op.credit_card_number IS NOT NULL)

Line 1106: FROM oe_payments op

1102:
1103: CURSOR oe_payments_cur (p_start_rowid ROWID, p_end_rowid ROWID) is
1104: SELECT /*+ LEADING (OP) */ op.header_id,
1105: op.rowid
1106: FROM oe_payments op
1107: WHERE ((op.payment_type_code = 'CREDIT_CARD' AND op.credit_card_number IS NOT NULL)
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 ;

Line 1158: -- Fetching records from OE_PAYMENTS table

1154: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);
1155:
1156: BEGIN
1157: -----------------------------------------------------------
1158: -- Fetching records from OE_PAYMENTS table
1159: -----------------------------------------------------------
1160: l_table_name := 'OE_PAYMENTS' ;
1161:
1162: ad_parallel_updates_pkg.delete_update_information(

Line 1160: l_table_name := 'OE_PAYMENTS' ;

1156: BEGIN
1157: -----------------------------------------------------------
1158: -- Fetching records from OE_PAYMENTS table
1159: -----------------------------------------------------------
1160: l_table_name := 'OE_PAYMENTS' ;
1161:
1162: ad_parallel_updates_pkg.delete_update_information(
1163: 0,
1164: l_table_owner,

Line 1187: FROM oe_payments

1183:
1184: BEGIN
1185: SELECT 'Y'
1186: INTO l_exists_payment
1187: FROM oe_payments
1188: WHERE ((payment_type_code = 'CREDIT_CARD' AND credit_card_number IS NOT NULL)
1189: OR (payment_type_code IN ('ACH', 'DIRECT_DEBIT') AND payment_trx_id IS NOT NULL))
1190: AND trxn_extension_id IS NULL
1191: AND ROWNUM = 1 ;

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

1192: EXCEPTION
1193: WHEN NO_DATA_FOUND THEN
1194: IF l_debug_level > 0 THEN
1195: oe_debug_pub.add('') ;
1196: oe_debug_pub.add('No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
1197: END IF;
1198:
1199: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
1200: END;

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

1195: oe_debug_pub.add('') ;
1196: oe_debug_pub.add('No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
1197: END IF;
1198:
1199: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
1200: END;
1201:
1202: BEGIN
1203: SELECT 'Y'

Line 1206: oe_payments op

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
1210: AND op.trxn_extension_id IS NULL

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

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;
1247:

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

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:
1253: RETURN ;

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

1253: RETURN ;
1254: END IF ;
1255:
1256: fnd_file.put_line(FND_FILE.OUTPUT, '');
1257: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_PAYMENTS table');
1258:
1259: IF l_debug_level > 0 THEN
1260: oe_debug_pub.add('') ;
1261: oe_debug_pub.add('AD parallel details : ') ;

Line 1278: OPEN oe_payments_cur(l_start_rowid, l_end_rowid) ;

1274: WHILE (l_any_rows_to_process = TRUE) LOOP
1275: header_id_tab.delete ;
1276: row_id_tab.delete ;
1277:
1278: OPEN oe_payments_cur(l_start_rowid, l_end_rowid) ;
1279:
1280: FETCH oe_payments_cur BULK COLLECT INTO
1281: header_id_tab, row_id_tab
1282: LIMIT X_batch_size ;

Line 1280: FETCH oe_payments_cur BULK COLLECT INTO

1276: row_id_tab.delete ;
1277:
1278: OPEN oe_payments_cur(l_start_rowid, l_end_rowid) ;
1279:
1280: FETCH oe_payments_cur BULK COLLECT INTO
1281: header_id_tab, row_id_tab
1282: LIMIT X_batch_size ;
1283:
1284: CLOSE oe_payments_cur ;

Line 1284: CLOSE oe_payments_cur ;

1280: FETCH oe_payments_cur BULK COLLECT INTO
1281: header_id_tab, row_id_tab
1282: LIMIT X_batch_size ;
1283:
1284: CLOSE oe_payments_cur ;
1285:
1286: -- oe_debug_pub.add('Number of Records : ' || header_id_tab.count) ;
1287:
1288: IF header_id_tab.count > 0 THEN

Line 1291: UPDATE oe_payments

1287:
1288: IF header_id_tab.count > 0 THEN
1289: BEGIN
1290: FORALL i in header_id_tab.FIRST..header_id_tab.LAST SAVE EXCEPTIONS
1291: UPDATE oe_payments
1292: SET credit_card_number = null,
1293: credit_card_holder_name = null,
1294: credit_card_expiration_date = null,
1295: credit_card_code = null,

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

1312: ' Oracle error is ' ||
1313: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
1314:
1315: fnd_file.put_line(FND_FILE.OUTPUT,
1316: 'Update failing at OE_PAYMENTS from OE_PAYMENTS_CUR for Header ID ' ||
1317: header_id_tab(j));
1318: END LOOP;
1319: END;
1320:

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

1338: END LOOP ;
1339:
1340: IF l_debug_level > 0 THEN
1341: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
1342: oe_debug_pub.add('Total No of records errored in OE_PAYMENTS : ' || l_error_total1) ;
1343: END IF;
1344:
1345: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_PAYMENTS table');
1346:

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

1341: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
1342: oe_debug_pub.add('Total No of records errored in OE_PAYMENTS : ' || l_error_total1) ;
1343: END IF;
1344:
1345: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_PAYMENTS table');
1346:
1347: EXCEPTION
1348: WHEN NO_DATA_FOUND THEN
1349: IF l_debug_level > 0 THEN

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

1347: EXCEPTION
1348: WHEN NO_DATA_FOUND THEN
1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add('') ;
1351: oe_debug_pub.add('No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
1352: END IF;
1353:
1354: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
1355: END ;

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

1350: oe_debug_pub.add('') ;
1351: oe_debug_pub.add('No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
1352: END IF;
1353:
1354: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_PAYMENTS table for Worker Id : ' || X_worker_id) ;
1355: END ;
1356:
1357: BEGIN
1358: -----------------------------------------------------------