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 FND_FILE

Line 392: fnd_file.put_line(FND_FILE.OUTPUT, '');

388:
389: -----------------------------------------------------------
390: -- Log Output file
391: -----------------------------------------------------------
392: fnd_file.put_line(FND_FILE.OUTPUT, '');
393: fnd_file.put_line(FND_FILE.OUTPUT, 'Migrate Payment Data for Closed Orders to Oracle Payment - Concurrent Program');
394: fnd_file.put_line(FND_FILE.OUTPUT, '');
395: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
396: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);

Line 393: fnd_file.put_line(FND_FILE.OUTPUT, 'Migrate Payment Data for Closed Orders to Oracle Payment - Concurrent Program');

389: -----------------------------------------------------------
390: -- Log Output file
391: -----------------------------------------------------------
392: fnd_file.put_line(FND_FILE.OUTPUT, '');
393: fnd_file.put_line(FND_FILE.OUTPUT, 'Migrate Payment Data for Closed Orders to Oracle Payment - Concurrent Program');
394: fnd_file.put_line(FND_FILE.OUTPUT, '');
395: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
396: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
397: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);

Line 394: fnd_file.put_line(FND_FILE.OUTPUT, '');

390: -- Log Output file
391: -----------------------------------------------------------
392: fnd_file.put_line(FND_FILE.OUTPUT, '');
393: fnd_file.put_line(FND_FILE.OUTPUT, 'Migrate Payment Data for Closed Orders to Oracle Payment - Concurrent Program');
394: fnd_file.put_line(FND_FILE.OUTPUT, '');
395: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
396: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
397: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);
398:

Line 395: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');

391: -----------------------------------------------------------
392: fnd_file.put_line(FND_FILE.OUTPUT, '');
393: fnd_file.put_line(FND_FILE.OUTPUT, 'Migrate Payment Data for Closed Orders to Oracle Payment - Concurrent Program');
394: fnd_file.put_line(FND_FILE.OUTPUT, '');
395: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
396: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
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')) ;

Line 396: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);

392: fnd_file.put_line(FND_FILE.OUTPUT, '');
393: fnd_file.put_line(FND_FILE.OUTPUT, 'Migrate Payment Data for Closed Orders to Oracle Payment - Concurrent Program');
394: fnd_file.put_line(FND_FILE.OUTPUT, '');
395: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
396: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
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:

Line 397: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);

393: fnd_file.put_line(FND_FILE.OUTPUT, 'Migrate Payment Data for Closed Orders to Oracle Payment - Concurrent Program');
394: fnd_file.put_line(FND_FILE.OUTPUT, '');
395: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
396: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
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

Line 430: fnd_file.put_line(FND_FILE.OUTPUT, '');

426: l_any_rows_to_process,
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('') ;

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 578: fnd_file.put_line(FND_FILE.OUTPUT,

574: END IF;
575: l_error_total := SQL%BULK_EXCEPTIONS.COUNT ;
576:
577: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
578: fnd_file.put_line(FND_FILE.OUTPUT,
579: 'Inner Block :Error occurred during iteration ' ||
580: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
581: ' Oracle error is ' ||
582: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );

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 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 621: fnd_file.put_line(FND_FILE.OUTPUT,

617: WHEN OTHERS THEN
618: l_error_total := SQL%BULK_EXCEPTIONS.COUNT ;
619:
620: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
621: fnd_file.put_line(FND_FILE.OUTPUT,
622: 'Error occurred during iteration ' ||
623: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
624: ' Oracle error is ' ||
625: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );

Line 627: fnd_file.put_line(FND_FILE.OUTPUT,

623: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
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 ;

Line 666: fnd_file.put_line(FND_FILE.OUTPUT, '');

662: l_any_rows_to_process,
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('') ;

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 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 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 814: fnd_file.put_line(FND_FILE.OUTPUT,

810: WHEN OTHERS THEN
811: l_error_total := SQL%BULK_EXCEPTIONS.COUNT ;
812:
813: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
814: fnd_file.put_line(FND_FILE.OUTPUT,
815: 'Error occurred during iteration ' ||
816: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
817: ' Oracle error is ' ||
818: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );

Line 820: fnd_file.put_line(FND_FILE.OUTPUT,

816: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
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 ;

Line 859: fnd_file.put_line(FND_FILE.OUTPUT, '');

855: l_any_rows_to_process,
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('') ;

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 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 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 988: fnd_file.put_line(FND_FILE.OUTPUT,

984: WHEN OTHERS THEN
985: l_error_total := SQL%BULK_EXCEPTIONS.COUNT ;
986:
987: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
988: fnd_file.put_line(FND_FILE.OUTPUT,
989: 'Error occurred during iteration ' ||
990: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
991: ' Oracle error is ' ||
992: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );

Line 994: fnd_file.put_line(FND_FILE.OUTPUT,

990: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
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:

Line 1015: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));

1011: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1012: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Migrate_Data_WKR');
1013: END IF;
1014:
1015: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1017: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
1018:
1019: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1023: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));

1019: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1020: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Migrate_Data_WKR');
1021: END IF;
1022:
1023: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1024: WHEN OTHERS THEN
1025: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
1026:
1027: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1031: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));

1027: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1028: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Migrate_Data_WKR');
1029: END IF;
1030:
1031: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1032: END Migrate_Data_WKR ;
1033:
1034: PROCEDURE Purge_Data_MGR
1035: ( X_errbuf OUT NOCOPY VARCHAR2,

Line 1149: fnd_file.put_line(FND_FILE.OUTPUT, '');

1145:
1146: -----------------------------------------------------------
1147: -- Log Output file
1148: -----------------------------------------------------------
1149: fnd_file.put_line(FND_FILE.OUTPUT, '');
1150: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Secured Payment Data - Concurrent Program');
1151: fnd_file.put_line(FND_FILE.OUTPUT, '');
1152: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1153: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);

Line 1150: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Secured Payment Data - Concurrent Program');

1146: -----------------------------------------------------------
1147: -- Log Output file
1148: -----------------------------------------------------------
1149: fnd_file.put_line(FND_FILE.OUTPUT, '');
1150: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Secured Payment Data - Concurrent Program');
1151: fnd_file.put_line(FND_FILE.OUTPUT, '');
1152: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1153: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
1154: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);

Line 1151: fnd_file.put_line(FND_FILE.OUTPUT, '');

1147: -- Log Output file
1148: -----------------------------------------------------------
1149: fnd_file.put_line(FND_FILE.OUTPUT, '');
1150: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Secured Payment Data - Concurrent Program');
1151: fnd_file.put_line(FND_FILE.OUTPUT, '');
1152: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1153: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
1154: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);
1155:

Line 1152: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');

1148: -----------------------------------------------------------
1149: fnd_file.put_line(FND_FILE.OUTPUT, '');
1150: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Secured Payment Data - Concurrent Program');
1151: fnd_file.put_line(FND_FILE.OUTPUT, '');
1152: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1153: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
1154: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);
1155:
1156: BEGIN

Line 1153: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);

1149: fnd_file.put_line(FND_FILE.OUTPUT, '');
1150: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Secured Payment Data - Concurrent Program');
1151: fnd_file.put_line(FND_FILE.OUTPUT, '');
1152: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1153: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
1154: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);
1155:
1156: BEGIN
1157: -----------------------------------------------------------

Line 1154: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);

1150: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Secured Payment Data - Concurrent Program');
1151: fnd_file.put_line(FND_FILE.OUTPUT, '');
1152: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1153: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
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

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 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 1236: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;

1232: oe_debug_pub.add('') ;
1233: oe_debug_pub.add('No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1234: END IF;
1235:
1236: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1237: END;
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

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 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 1250: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;

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 ;
1254: END IF ;

Line 1251: fnd_file.put_line(FND_FILE.OUTPUT, 'Please migrate the data before proceeding to purge secured payment data') ;

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 ;
1254: END IF ;
1255:

Line 1256: fnd_file.put_line(FND_FILE.OUTPUT, '');

1252:
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('') ;

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 1309: fnd_file.put_line(FND_FILE.OUTPUT,

1305: WHEN OTHERS THEN
1306: l_error_total1 := SQL%BULK_EXCEPTIONS.COUNT ;
1307:
1308: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
1309: fnd_file.put_line(FND_FILE.OUTPUT,
1310: 'Error occurred during iteration ' ||
1311: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
1312: ' Oracle error is ' ||
1313: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );

Line 1315: fnd_file.put_line(FND_FILE.OUTPUT,

1311: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
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;

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

Line 1385: fnd_file.put_line(FND_FILE.OUTPUT, '');

1381: l_any_rows_to_process,
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('') ;

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 1436: fnd_file.put_line(FND_FILE.OUTPUT,

1432: WHEN OTHERS THEN
1433: l_error_total1 := SQL%BULK_EXCEPTIONS.COUNT ;
1434:
1435: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
1436: fnd_file.put_line(FND_FILE.OUTPUT,
1437: 'Error occurred during iteration ' ||
1438: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
1439: ' Oracle error is ' ||
1440: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );

Line 1442: fnd_file.put_line(FND_FILE.OUTPUT,

1438: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
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;

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 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

Line 1514: fnd_file.put_line(FND_FILE.OUTPUT, '');

1510: l_any_rows_to_process,
1511: X_batch_size,
1512: TRUE) ;
1513:
1514: fnd_file.put_line(FND_FILE.OUTPUT, '');
1515: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_ORDER_HEADER_HISTORY table');
1516:
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add('') ;

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

1511: X_batch_size,
1512: TRUE) ;
1513:
1514: fnd_file.put_line(FND_FILE.OUTPUT, '');
1515: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_ORDER_HEADER_HISTORY table');
1516:
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add('') ;
1519: oe_debug_pub.add('AD parallel details : ') ;

Line 1563: fnd_file.put_line(FND_FILE.OUTPUT,

1559: WHEN OTHERS THEN
1560: l_error_total1 := SQL%BULK_EXCEPTIONS.COUNT ;
1561:
1562: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
1563: fnd_file.put_line(FND_FILE.OUTPUT,
1564: 'Error occurred during iteration ' ||
1565: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
1566: ' Oracle error is ' ||
1567: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );

Line 1569: fnd_file.put_line(FND_FILE.OUTPUT,

1565: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
1566: ' Oracle error is ' ||
1567: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
1568:
1569: fnd_file.put_line(FND_FILE.OUTPUT,
1570: 'Update failing at OE_ORDER_HEADER_HISTORY from HIST_PAYMENTS_CUR ' ||
1571: header_id_tab(j));
1572: END LOOP;
1573: END;

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

1595: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
1596: oe_debug_pub.add('Total No of records errored in OE_ORDER_HEADER_HISTORY : ' || l_error_total1) ;
1597: END IF;
1598:
1599: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_ORDER_HEADER_HISTORY table');
1600:
1601: EXCEPTION
1602: WHEN NO_DATA_FOUND THEN
1603: IF l_debug_level > 0 THEN

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

1604: oe_debug_pub.add('') ;
1605: oe_debug_pub.add('No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1606: END IF;
1607:
1608: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1609: END ;
1610: -- end of processsing oe_order_header_history
1611:
1612: COMMIT ;

Line 1624: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));

1620: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1621: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purge_Data_WKR');
1622: END IF;
1623:
1624: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1626: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
1627:
1628: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1632: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));

1628: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1629: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purge_Data_WKR');
1630: END IF;
1631:
1632: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1633: WHEN OTHERS THEN
1634: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
1635:
1636: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1640: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));

1636: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1637: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purge_Data_WKR');
1638: END IF;
1639:
1640: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1641: END Purge_Data_WKR ;
1642:
1643: END OE_Payment_Data_Migration_Util ;