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 353: fnd_file.put_line(FND_FILE.OUTPUT, '');

349:
350: -----------------------------------------------------------
351: -- Log Output file
352: -----------------------------------------------------------
353: fnd_file.put_line(FND_FILE.OUTPUT, '');
354: fnd_file.put_line(FND_FILE.OUTPUT, 'Migrate Payment Data for Closed Orders to Oracle Payment - Concurrent Program');
355: fnd_file.put_line(FND_FILE.OUTPUT, '');
356: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
357: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);

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

350: -----------------------------------------------------------
351: -- Log Output file
352: -----------------------------------------------------------
353: fnd_file.put_line(FND_FILE.OUTPUT, '');
354: fnd_file.put_line(FND_FILE.OUTPUT, 'Migrate Payment Data for Closed Orders to Oracle Payment - Concurrent Program');
355: fnd_file.put_line(FND_FILE.OUTPUT, '');
356: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
357: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
358: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);

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

351: -- Log Output file
352: -----------------------------------------------------------
353: fnd_file.put_line(FND_FILE.OUTPUT, '');
354: fnd_file.put_line(FND_FILE.OUTPUT, 'Migrate Payment Data for Closed Orders to Oracle Payment - Concurrent Program');
355: fnd_file.put_line(FND_FILE.OUTPUT, '');
356: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
357: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
358: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);
359:

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

352: -----------------------------------------------------------
353: fnd_file.put_line(FND_FILE.OUTPUT, '');
354: fnd_file.put_line(FND_FILE.OUTPUT, 'Migrate Payment Data for Closed Orders to Oracle Payment - Concurrent Program');
355: fnd_file.put_line(FND_FILE.OUTPUT, '');
356: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
357: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
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')) ;

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

353: fnd_file.put_line(FND_FILE.OUTPUT, '');
354: fnd_file.put_line(FND_FILE.OUTPUT, 'Migrate Payment Data for Closed Orders to Oracle Payment - Concurrent Program');
355: fnd_file.put_line(FND_FILE.OUTPUT, '');
356: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
357: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
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:

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

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

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

387: l_any_rows_to_process,
388: X_batch_size,
389: TRUE) ;
390:
391: fnd_file.put_line(FND_FILE.OUTPUT, '');
392: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_ORDER_HEADERS_ALL table');
393:
394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add('') ;

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

388: X_batch_size,
389: TRUE) ;
390:
391: fnd_file.put_line(FND_FILE.OUTPUT, '');
392: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_ORDER_HEADERS_ALL table');
393:
394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add('') ;
396: oe_debug_pub.add('AD parallel details : ') ;

Line 539: fnd_file.put_line(FND_FILE.OUTPUT,

535: END IF;
536: l_error_total := SQL%BULK_EXCEPTIONS.COUNT ;
537:
538: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
539: fnd_file.put_line(FND_FILE.OUTPUT,
540: 'Inner Block :Error occurred during iteration ' ||
541: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
542: ' Oracle error is ' ||
543: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );

Line 545: 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));

541: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
542: ' Oracle error is ' ||
543: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
544:
545: 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));
546: END LOOP;
547: END ;
548: --6757060
549:

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

564: IF l_debug_level > 0 THEN
565: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
566: END IF;
567:
568: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_ORDER_HEADERS_ALL table');
569: EXCEPTION
570: WHEN NO_DATA_FOUND THEN
571:
572: IF l_debug_level > 0 THEN

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

573: oe_debug_pub.add('') ;
574: oe_debug_pub.add('No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
575: END IF;
576:
577: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
578: WHEN OTHERS THEN
579: l_error_total := SQL%BULK_EXCEPTIONS.COUNT ;
580:
581: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP

Line 582: fnd_file.put_line(FND_FILE.OUTPUT,

578: WHEN OTHERS THEN
579: l_error_total := SQL%BULK_EXCEPTIONS.COUNT ;
580:
581: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
582: fnd_file.put_line(FND_FILE.OUTPUT,
583: 'Error occurred during iteration ' ||
584: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
585: ' Oracle error is ' ||
586: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );

Line 588: fnd_file.put_line(FND_FILE.OUTPUT,

584: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
585: ' Oracle error is ' ||
586: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
587:
588: fnd_file.put_line(FND_FILE.OUTPUT,
589: 'upgrading failing for data from oe_order_headers_all for Header ID ' ||
590: header_id_tab(j));
591: END LOOP;
592: END ;

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

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

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

771: WHEN OTHERS THEN
772: l_error_total := SQL%BULK_EXCEPTIONS.COUNT ;
773:
774: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
775: fnd_file.put_line(FND_FILE.OUTPUT,
776: 'Error occurred during iteration ' ||
777: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
778: ' Oracle error is ' ||
779: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );

Line 781: fnd_file.put_line(FND_FILE.OUTPUT,

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

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

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

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

945: WHEN OTHERS THEN
946: l_error_total := SQL%BULK_EXCEPTIONS.COUNT ;
947:
948: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
949: fnd_file.put_line(FND_FILE.OUTPUT,
950: 'Error occurred during iteration ' ||
951: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
952: ' Oracle error is ' ||
953: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );

Line 955: fnd_file.put_line(FND_FILE.OUTPUT,

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

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

972: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
973: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Migrate_Data_WKR');
974: END IF;
975:
976: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
978: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
979:
980: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

980: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
981: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Migrate_Data_WKR');
982: END IF;
983:
984: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
985: WHEN OTHERS THEN
986: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
987:
988: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

988: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
989: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Migrate_Data_WKR');
990: END IF;
991:
992: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
993: END Migrate_Data_WKR ;
994:
995: PROCEDURE Purge_Data_MGR
996: ( X_errbuf OUT NOCOPY VARCHAR2,

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

1106:
1107: -----------------------------------------------------------
1108: -- Log Output file
1109: -----------------------------------------------------------
1110: fnd_file.put_line(FND_FILE.OUTPUT, '');
1111: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Secured Payment Data - Concurrent Program');
1112: fnd_file.put_line(FND_FILE.OUTPUT, '');
1113: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1114: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);

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

1107: -----------------------------------------------------------
1108: -- Log Output file
1109: -----------------------------------------------------------
1110: fnd_file.put_line(FND_FILE.OUTPUT, '');
1111: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Secured Payment Data - Concurrent Program');
1112: fnd_file.put_line(FND_FILE.OUTPUT, '');
1113: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1114: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
1115: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);

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

1108: -- Log Output file
1109: -----------------------------------------------------------
1110: fnd_file.put_line(FND_FILE.OUTPUT, '');
1111: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Secured Payment Data - Concurrent Program');
1112: fnd_file.put_line(FND_FILE.OUTPUT, '');
1113: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1114: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
1115: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);
1116:

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

1109: -----------------------------------------------------------
1110: fnd_file.put_line(FND_FILE.OUTPUT, '');
1111: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Secured Payment Data - Concurrent Program');
1112: fnd_file.put_line(FND_FILE.OUTPUT, '');
1113: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1114: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
1115: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);
1116:
1117: BEGIN

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

1110: fnd_file.put_line(FND_FILE.OUTPUT, '');
1111: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Secured Payment Data - Concurrent Program');
1112: fnd_file.put_line(FND_FILE.OUTPUT, '');
1113: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1114: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
1115: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);
1116:
1117: BEGIN
1118: -----------------------------------------------------------

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

1111: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Secured Payment Data - Concurrent Program');
1112: fnd_file.put_line(FND_FILE.OUTPUT, '');
1113: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1114: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
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

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

1176: oe_debug_pub.add('') ;
1177: oe_debug_pub.add('No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
1178: END IF;
1179:
1180: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
1181: END;
1182:
1183: BEGIN
1184: SELECT 'Y'

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

1193: oe_debug_pub.add('') ;
1194: oe_debug_pub.add('No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1195: END IF;
1196:
1197: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1198: END;
1199:
1200: IF l_exists_header = 'Y' OR l_exists_payment = 'Y' OR l_exists_history = 'Y' THEN
1201: IF l_debug_level > 0 THEN

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

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

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

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

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

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

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

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

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

1266: WHEN OTHERS THEN
1267: l_error_total1 := SQL%BULK_EXCEPTIONS.COUNT ;
1268:
1269: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
1270: fnd_file.put_line(FND_FILE.OUTPUT,
1271: 'Error occurred during iteration ' ||
1272: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
1273: ' Oracle error is ' ||
1274: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );

Line 1276: fnd_file.put_line(FND_FILE.OUTPUT,

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

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

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

1342: l_any_rows_to_process,
1343: X_batch_size,
1344: TRUE) ;
1345:
1346: fnd_file.put_line(FND_FILE.OUTPUT, '');
1347: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_ORDER_HEADERS_ALL table');
1348:
1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add('') ;

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

1343: X_batch_size,
1344: TRUE) ;
1345:
1346: fnd_file.put_line(FND_FILE.OUTPUT, '');
1347: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_ORDER_HEADERS_ALL table');
1348:
1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add('') ;
1351: oe_debug_pub.add('AD parallel details : ') ;

Line 1397: fnd_file.put_line(FND_FILE.OUTPUT,

1393: WHEN OTHERS THEN
1394: l_error_total1 := SQL%BULK_EXCEPTIONS.COUNT ;
1395:
1396: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
1397: fnd_file.put_line(FND_FILE.OUTPUT,
1398: 'Error occurred during iteration ' ||
1399: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
1400: ' Oracle error is ' ||
1401: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );

Line 1403: fnd_file.put_line(FND_FILE.OUTPUT,

1399: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
1400: ' Oracle error is ' ||
1401: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
1402:
1403: fnd_file.put_line(FND_FILE.OUTPUT,
1404: 'Update failing at OE_ORDER_HEADERS_ALL from HEADER_PAYMENTS_CUR ' ||
1405: header_id_tab(j));
1406: END LOOP;
1407: END;

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

1429: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
1430: oe_debug_pub.add('Total No of records errored in OE_ORDER_HEADERS_ALL : ' || l_error_total1) ;
1431: END IF;
1432:
1433: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_ORDER_HEADERS_ALL table');
1434:
1435: EXCEPTION
1436: WHEN NO_DATA_FOUND THEN
1437: IF l_debug_level > 0 THEN

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

1438: oe_debug_pub.add('') ;
1439: oe_debug_pub.add('No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
1440: END IF;
1441:
1442: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
1443: END ;
1444:
1445:
1446: -- start processing oe_order_header_history

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

1471: l_any_rows_to_process,
1472: X_batch_size,
1473: TRUE) ;
1474:
1475: fnd_file.put_line(FND_FILE.OUTPUT, '');
1476: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_ORDER_HEADER_HISTORY table');
1477:
1478: IF l_debug_level > 0 THEN
1479: oe_debug_pub.add('') ;

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

1472: X_batch_size,
1473: TRUE) ;
1474:
1475: fnd_file.put_line(FND_FILE.OUTPUT, '');
1476: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_ORDER_HEADER_HISTORY table');
1477:
1478: IF l_debug_level > 0 THEN
1479: oe_debug_pub.add('') ;
1480: oe_debug_pub.add('AD parallel details : ') ;

Line 1524: fnd_file.put_line(FND_FILE.OUTPUT,

1520: WHEN OTHERS THEN
1521: l_error_total1 := SQL%BULK_EXCEPTIONS.COUNT ;
1522:
1523: FOR j IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
1524: fnd_file.put_line(FND_FILE.OUTPUT,
1525: 'Error occurred during iteration ' ||
1526: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
1527: ' Oracle error is ' ||
1528: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );

Line 1530: fnd_file.put_line(FND_FILE.OUTPUT,

1526: SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
1527: ' Oracle error is ' ||
1528: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
1529:
1530: fnd_file.put_line(FND_FILE.OUTPUT,
1531: 'Update failing at OE_ORDER_HEADER_HISTORY from HIST_PAYMENTS_CUR ' ||
1532: header_id_tab(j));
1533: END LOOP;
1534: END;

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

1556: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
1557: oe_debug_pub.add('Total No of records errored in OE_ORDER_HEADER_HISTORY : ' || l_error_total1) ;
1558: END IF;
1559:
1560: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_ORDER_HEADER_HISTORY table');
1561:
1562: EXCEPTION
1563: WHEN NO_DATA_FOUND THEN
1564: IF l_debug_level > 0 THEN

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

1565: oe_debug_pub.add('') ;
1566: oe_debug_pub.add('No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1567: END IF;
1568:
1569: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1570: END ;
1571: -- end of processsing oe_order_header_history
1572:
1573: COMMIT ;

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

1581: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1582: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purge_Data_WKR');
1583: END IF;
1584:
1585: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1587: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
1588:
1589: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

1589: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1590: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purge_Data_WKR');
1591: END IF;
1592:
1593: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1594: WHEN OTHERS THEN
1595: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
1596:
1597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

1597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1598: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purge_Data_WKR');
1599: END IF;
1600:
1601: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1602: END Purge_Data_WKR ;
1603:
1604: END OE_Payment_Data_Migration_Util ;