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_DEBUG_PUB

Line 121: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level ;

117: l_process_total2 NUMBER := 0 ;
118:
119: l_error_total NUMBER := 0 ;
120:
121: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level ;
122:
123: -- Cursors that query all transactions needed to be migrated
124: -- since all credit cards for closed orders would have already created bank account id
125: -- in ap_bank_accounts, so we can get the bank_account_id first, then get the instrument

Line 395: oe_debug_pub.add('') ;

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 : ') ;
397: oe_debug_pub.add('') ;
398: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
399: oe_debug_pub.add('Table name : ' || l_table_name) ;

Line 396: oe_debug_pub.add('AD parallel details : ') ;

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 : ') ;
397: oe_debug_pub.add('') ;
398: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
399: oe_debug_pub.add('Table name : ' || l_table_name) ;
400: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

Line 397: oe_debug_pub.add('') ;

393:
394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add('') ;
396: oe_debug_pub.add('AD parallel details : ') ;
397: oe_debug_pub.add('') ;
398: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
399: oe_debug_pub.add('Table name : ' || l_table_name) ;
400: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
401: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

Line 398: oe_debug_pub.add('Table owner : ' || l_table_owner) ;

394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add('') ;
396: oe_debug_pub.add('AD parallel details : ') ;
397: oe_debug_pub.add('') ;
398: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
399: oe_debug_pub.add('Table name : ' || l_table_name) ;
400: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
401: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
402: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

Line 399: oe_debug_pub.add('Table name : ' || l_table_name) ;

395: oe_debug_pub.add('') ;
396: oe_debug_pub.add('AD parallel details : ') ;
397: oe_debug_pub.add('') ;
398: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
399: oe_debug_pub.add('Table name : ' || l_table_name) ;
400: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
401: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
402: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
403: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;

Line 400: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

396: oe_debug_pub.add('AD parallel details : ') ;
397: oe_debug_pub.add('') ;
398: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
399: oe_debug_pub.add('Table name : ' || l_table_name) ;
400: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
401: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
402: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
403: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
404: END IF ;

Line 401: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

397: oe_debug_pub.add('') ;
398: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
399: oe_debug_pub.add('Table name : ' || l_table_name) ;
400: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
401: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
402: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
403: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
404: END IF ;
405:

Line 402: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

398: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
399: oe_debug_pub.add('Table name : ' || l_table_name) ;
400: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
401: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
402: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
403: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
404: END IF ;
405:
406: l_process_total1 := 0 ;

Line 403: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;

399: oe_debug_pub.add('Table name : ' || l_table_name) ;
400: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
401: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
402: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
403: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
404: END IF ;
405:
406: l_process_total1 := 0 ;
407:

Line 450: -- oe_debug_pub.add('Number of Records selected in payments_cur1 : ' || trxn_entity_id_tab.count) ;

446:
447: CLOSE payments_cur1_sec ;
448: END IF ;
449:
450: -- oe_debug_pub.add('Number of Records selected in payments_cur1 : ' || trxn_entity_id_tab.count) ;
451:
452: IF trxn_entity_id_tab.count > 0 THEN
453: -- insert the transactions into IBY transaction extension table
454: FORALL k in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS

Line 565: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;

561: FALSE) ;
562: END LOOP ;
563:
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

Line 573: oe_debug_pub.add('') ;

569: EXCEPTION
570: WHEN NO_DATA_FOUND THEN
571:
572: IF l_debug_level > 0 THEN
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) ;

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

570: WHEN NO_DATA_FOUND THEN
571:
572: IF l_debug_level > 0 THEN
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

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

591: END LOOP;
592: END ;
593:
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

Line 631: oe_debug_pub.add('') ;

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 : ') ;
633: oe_debug_pub.add('') ;
634: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
635: oe_debug_pub.add('Table name : ' || l_table_name) ;

Line 632: oe_debug_pub.add('AD parallel details : ') ;

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 : ') ;
633: oe_debug_pub.add('') ;
634: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
635: oe_debug_pub.add('Table name : ' || l_table_name) ;
636: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

Line 633: oe_debug_pub.add('') ;

629:
630: IF l_debug_level > 0 THEN
631: oe_debug_pub.add('') ;
632: oe_debug_pub.add('AD parallel details : ') ;
633: oe_debug_pub.add('') ;
634: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
635: oe_debug_pub.add('Table name : ' || l_table_name) ;
636: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
637: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

Line 634: oe_debug_pub.add('Table owner : ' || l_table_owner) ;

630: IF l_debug_level > 0 THEN
631: oe_debug_pub.add('') ;
632: oe_debug_pub.add('AD parallel details : ') ;
633: oe_debug_pub.add('') ;
634: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
635: oe_debug_pub.add('Table name : ' || l_table_name) ;
636: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
637: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
638: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

Line 635: oe_debug_pub.add('Table name : ' || l_table_name) ;

631: oe_debug_pub.add('') ;
632: oe_debug_pub.add('AD parallel details : ') ;
633: oe_debug_pub.add('') ;
634: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
635: oe_debug_pub.add('Table name : ' || l_table_name) ;
636: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
637: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
638: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
639: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;

Line 636: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

632: oe_debug_pub.add('AD parallel details : ') ;
633: oe_debug_pub.add('') ;
634: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
635: oe_debug_pub.add('Table name : ' || l_table_name) ;
636: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
637: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
638: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
639: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
640: END IF ;

Line 637: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

633: oe_debug_pub.add('') ;
634: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
635: oe_debug_pub.add('Table name : ' || l_table_name) ;
636: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
637: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
638: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
639: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
640: END IF ;
641:

Line 638: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

634: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
635: oe_debug_pub.add('Table name : ' || l_table_name) ;
636: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
637: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
638: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
639: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
640: END IF ;
641:
642: l_process_total1 := 0 ;

Line 639: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;

635: oe_debug_pub.add('Table name : ' || l_table_name) ;
636: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
637: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
638: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
639: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
640: END IF ;
641:
642: l_process_total1 := 0 ;
643:

Line 685: -- oe_debug_pub.add('Number of Records selected in payments_cur2 : ' || trxn_entity_id_tab.count) ;

681:
682: CLOSE payments_cur2_sec ;
683: END IF ;
684:
685: -- oe_debug_pub.add('Number of Records selected in payments_cur2 : ' || trxn_entity_id_tab.count) ;
686:
687: IF trxn_entity_id_tab.count > 0 THEN
688: -- insert the transactions into IBY transaction extension table
689: FORALL k in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS

Line 759: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;

755: FALSE) ;
756: END LOOP ;
757:
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

Line 766: oe_debug_pub.add('') ;

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

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 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 824: oe_debug_pub.add('') ;

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 : ') ;
826: oe_debug_pub.add('') ;
827: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
828: oe_debug_pub.add('Table name : ' || l_table_name) ;

Line 825: oe_debug_pub.add('AD parallel details : ') ;

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 : ') ;
826: oe_debug_pub.add('') ;
827: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
828: oe_debug_pub.add('Table name : ' || l_table_name) ;
829: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

Line 826: oe_debug_pub.add('') ;

822:
823: IF l_debug_level > 0 THEN
824: oe_debug_pub.add('') ;
825: oe_debug_pub.add('AD parallel details : ') ;
826: oe_debug_pub.add('') ;
827: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
828: oe_debug_pub.add('Table name : ' || l_table_name) ;
829: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
830: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

Line 827: oe_debug_pub.add('Table owner : ' || l_table_owner) ;

823: IF l_debug_level > 0 THEN
824: oe_debug_pub.add('') ;
825: oe_debug_pub.add('AD parallel details : ') ;
826: oe_debug_pub.add('') ;
827: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
828: oe_debug_pub.add('Table name : ' || l_table_name) ;
829: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
830: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
831: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

Line 828: oe_debug_pub.add('Table name : ' || l_table_name) ;

824: oe_debug_pub.add('') ;
825: oe_debug_pub.add('AD parallel details : ') ;
826: oe_debug_pub.add('') ;
827: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
828: oe_debug_pub.add('Table name : ' || l_table_name) ;
829: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
830: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
831: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
832: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;

Line 829: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

825: oe_debug_pub.add('AD parallel details : ') ;
826: oe_debug_pub.add('') ;
827: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
828: oe_debug_pub.add('Table name : ' || l_table_name) ;
829: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
830: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
831: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
832: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
833: END IF ;

Line 830: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

826: oe_debug_pub.add('') ;
827: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
828: oe_debug_pub.add('Table name : ' || l_table_name) ;
829: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
830: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
831: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
832: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
833: END IF ;
834:

Line 831: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

827: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
828: oe_debug_pub.add('Table name : ' || l_table_name) ;
829: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
830: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
831: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
832: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
833: END IF ;
834:
835: l_process_total1 := 0 ;

Line 832: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;

828: oe_debug_pub.add('Table name : ' || l_table_name) ;
829: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
830: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
831: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
832: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
833: END IF ;
834:
835: l_process_total1 := 0 ;
836:

Line 860: -- oe_debug_pub.add('Number of Records selected in payments_cur3 is : ' || trxn_entity_id_tab.count) ;

856: Limit X_batch_size ;
857:
858: CLOSE payments_cur3 ;
859:
860: -- oe_debug_pub.add('Number of Records selected in payments_cur3 is : ' || trxn_entity_id_tab.count) ;
861:
862: IF trxn_entity_id_tab.count > 0 THEN
863: -- insert the transactions into IBY transaction extension table
864: FORALL k in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS

Line 932: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;

928: FALSE) ;
929: END LOOP ;
930:
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:

Line 940: oe_debug_pub.add('') ;

936:
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) ;

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 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 1059: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level ;

1055: l_error_total1 NUMBER := 0 ;
1056:
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:

Line 1156: oe_debug_pub.add('') ;

1152: AND ROWNUM = 1 ;
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) ;

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 1176: oe_debug_pub.add('') ;

1172: AND ROWNUM = 1 ;
1173: EXCEPTION
1174: WHEN NO_DATA_FOUND THEN
1175: IF l_debug_level > 0 THEN
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) ;

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

1173: EXCEPTION
1174: WHEN NO_DATA_FOUND THEN
1175: IF l_debug_level > 0 THEN
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;

Line 1193: oe_debug_pub.add('') ;

1189: AND ROWNUM = 1 ;
1190: EXCEPTION
1191: WHEN NO_DATA_FOUND THEN
1192: IF l_debug_level > 0 THEN
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) ;

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

1190: EXCEPTION
1191: WHEN NO_DATA_FOUND THEN
1192: IF l_debug_level > 0 THEN
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;

Line 1202: oe_debug_pub.add('') ;

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
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') ;

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

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

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 1205: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;

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

Line 1206: oe_debug_pub.add('Please migrate the data before proceeding to purge secured payment data') ;

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

Line 1221: oe_debug_pub.add('') ;

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 : ') ;
1223: oe_debug_pub.add('') ;
1224: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1225: oe_debug_pub.add('Table name : ' || l_table_name) ;

Line 1222: oe_debug_pub.add('AD parallel details : ') ;

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 : ') ;
1223: oe_debug_pub.add('') ;
1224: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1225: oe_debug_pub.add('Table name : ' || l_table_name) ;
1226: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

Line 1223: oe_debug_pub.add('') ;

1219:
1220: IF l_debug_level > 0 THEN
1221: oe_debug_pub.add('') ;
1222: oe_debug_pub.add('AD parallel details : ') ;
1223: oe_debug_pub.add('') ;
1224: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1225: oe_debug_pub.add('Table name : ' || l_table_name) ;
1226: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1227: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

Line 1224: oe_debug_pub.add('Table owner : ' || l_table_owner) ;

1220: IF l_debug_level > 0 THEN
1221: oe_debug_pub.add('') ;
1222: oe_debug_pub.add('AD parallel details : ') ;
1223: oe_debug_pub.add('') ;
1224: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1225: oe_debug_pub.add('Table name : ' || l_table_name) ;
1226: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1227: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1228: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

Line 1225: oe_debug_pub.add('Table name : ' || l_table_name) ;

1221: oe_debug_pub.add('') ;
1222: oe_debug_pub.add('AD parallel details : ') ;
1223: oe_debug_pub.add('') ;
1224: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1225: oe_debug_pub.add('Table name : ' || l_table_name) ;
1226: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1227: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1228: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1229: END IF ;

Line 1226: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

1222: oe_debug_pub.add('AD parallel details : ') ;
1223: oe_debug_pub.add('') ;
1224: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1225: oe_debug_pub.add('Table name : ' || l_table_name) ;
1226: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1227: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1228: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1229: END IF ;
1230:

Line 1227: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

1223: oe_debug_pub.add('') ;
1224: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1225: oe_debug_pub.add('Table name : ' || l_table_name) ;
1226: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1227: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1228: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1229: END IF ;
1230:
1231: l_error_total1 := 0 ;

Line 1228: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

1224: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1225: oe_debug_pub.add('Table name : ' || l_table_name) ;
1226: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1227: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1228: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1229: END IF ;
1230:
1231: l_error_total1 := 0 ;
1232:

Line 1247: -- oe_debug_pub.add('Number of Records : ' || header_id_tab.count) ;

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
1250: BEGIN
1251: FORALL i in header_id_tab.FIRST..header_id_tab.LAST SAVE EXCEPTIONS

Line 1302: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;

1298: FALSE) ;
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');

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 1311: oe_debug_pub.add('') ;

1307:
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) ;

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 1350: oe_debug_pub.add('') ;

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 : ') ;
1352: oe_debug_pub.add('') ;
1353: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1354: oe_debug_pub.add('Table name : ' || l_table_name) ;

Line 1351: oe_debug_pub.add('AD parallel details : ') ;

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 : ') ;
1352: oe_debug_pub.add('') ;
1353: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1354: oe_debug_pub.add('Table name : ' || l_table_name) ;
1355: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

Line 1352: oe_debug_pub.add('') ;

1348:
1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add('') ;
1351: oe_debug_pub.add('AD parallel details : ') ;
1352: oe_debug_pub.add('') ;
1353: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1354: oe_debug_pub.add('Table name : ' || l_table_name) ;
1355: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1356: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

Line 1353: oe_debug_pub.add('Table owner : ' || l_table_owner) ;

1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add('') ;
1351: oe_debug_pub.add('AD parallel details : ') ;
1352: oe_debug_pub.add('') ;
1353: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1354: oe_debug_pub.add('Table name : ' || l_table_name) ;
1355: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1356: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1357: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

Line 1354: oe_debug_pub.add('Table name : ' || l_table_name) ;

1350: oe_debug_pub.add('') ;
1351: oe_debug_pub.add('AD parallel details : ') ;
1352: oe_debug_pub.add('') ;
1353: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1354: oe_debug_pub.add('Table name : ' || l_table_name) ;
1355: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1356: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1357: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1358: END IF ;

Line 1355: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

1351: oe_debug_pub.add('AD parallel details : ') ;
1352: oe_debug_pub.add('') ;
1353: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1354: oe_debug_pub.add('Table name : ' || l_table_name) ;
1355: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1356: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1357: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1358: END IF ;
1359:

Line 1356: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

1352: oe_debug_pub.add('') ;
1353: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1354: oe_debug_pub.add('Table name : ' || l_table_name) ;
1355: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1356: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1357: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1358: END IF ;
1359:
1360: l_error_total1 := 0 ;

Line 1357: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

1353: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1354: oe_debug_pub.add('Table name : ' || l_table_name) ;
1355: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1356: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1357: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1358: END IF ;
1359:
1360: l_error_total1 := 0 ;
1361:

Line 1376: -- oe_debug_pub.add('Number of Records : ' || header_id_tab.count) ;

1372: LIMIT X_batch_size ;
1373:
1374: CLOSE header_payments_cur ;
1375:
1376: -- oe_debug_pub.add('Number of Records : ' || header_id_tab.count) ;
1377:
1378: IF header_id_tab.count > 0 THEN
1379: BEGIN
1380: FORALL i in header_id_tab.FIRST..header_id_tab.LAST SAVE EXCEPTIONS

Line 1429: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;

1425: FALSE) ;
1426: END LOOP ;
1427:
1428: IF l_debug_level > 0 THEN
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');

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

1426: END LOOP ;
1427:
1428: IF l_debug_level > 0 THEN
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:

Line 1438: oe_debug_pub.add('') ;

1434:
1435: EXCEPTION
1436: WHEN NO_DATA_FOUND THEN
1437: IF l_debug_level > 0 THEN
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) ;

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

1435: EXCEPTION
1436: WHEN NO_DATA_FOUND THEN
1437: IF l_debug_level > 0 THEN
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 ;

Line 1479: oe_debug_pub.add('') ;

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 : ') ;
1481: oe_debug_pub.add('') ;
1482: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1483: oe_debug_pub.add('Table name : ' || l_table_name) ;

Line 1480: oe_debug_pub.add('AD parallel details : ') ;

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 : ') ;
1481: oe_debug_pub.add('') ;
1482: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1483: oe_debug_pub.add('Table name : ' || l_table_name) ;
1484: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

Line 1481: oe_debug_pub.add('') ;

1477:
1478: IF l_debug_level > 0 THEN
1479: oe_debug_pub.add('') ;
1480: oe_debug_pub.add('AD parallel details : ') ;
1481: oe_debug_pub.add('') ;
1482: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1483: oe_debug_pub.add('Table name : ' || l_table_name) ;
1484: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1485: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

Line 1482: oe_debug_pub.add('Table owner : ' || l_table_owner) ;

1478: IF l_debug_level > 0 THEN
1479: oe_debug_pub.add('') ;
1480: oe_debug_pub.add('AD parallel details : ') ;
1481: oe_debug_pub.add('') ;
1482: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1483: oe_debug_pub.add('Table name : ' || l_table_name) ;
1484: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1485: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1486: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

Line 1483: oe_debug_pub.add('Table name : ' || l_table_name) ;

1479: oe_debug_pub.add('') ;
1480: oe_debug_pub.add('AD parallel details : ') ;
1481: oe_debug_pub.add('') ;
1482: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1483: oe_debug_pub.add('Table name : ' || l_table_name) ;
1484: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1485: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1486: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1487: END IF ;

Line 1484: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

1480: oe_debug_pub.add('AD parallel details : ') ;
1481: oe_debug_pub.add('') ;
1482: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1483: oe_debug_pub.add('Table name : ' || l_table_name) ;
1484: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1485: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1486: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1487: END IF ;
1488:

Line 1485: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

1481: oe_debug_pub.add('') ;
1482: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1483: oe_debug_pub.add('Table name : ' || l_table_name) ;
1484: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1485: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1486: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1487: END IF ;
1488:
1489: l_error_total1 := 0 ;

Line 1486: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

1482: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1483: oe_debug_pub.add('Table name : ' || l_table_name) ;
1484: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1485: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1486: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1487: END IF ;
1488:
1489: l_error_total1 := 0 ;
1490:

Line 1505: -- oe_debug_pub.add('Number of Records : ' || header_id_tab.count) ;

1501: LIMIT X_batch_size ;
1502:
1503: CLOSE hist_payments_cur ;
1504:
1505: -- oe_debug_pub.add('Number of Records : ' || header_id_tab.count) ;
1506:
1507: IF row_id_tab.count > 0 THEN
1508: BEGIN
1509: FORALL i in row_id_tab.FIRST..row_id_tab.LAST SAVE EXCEPTIONS

Line 1556: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;

1552: FALSE) ;
1553: END LOOP ;
1554:
1555: IF l_debug_level > 0 THEN
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');

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

1553: END LOOP ;
1554:
1555: IF l_debug_level > 0 THEN
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:

Line 1565: oe_debug_pub.add('') ;

1561:
1562: EXCEPTION
1563: WHEN NO_DATA_FOUND THEN
1564: IF l_debug_level > 0 THEN
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) ;

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

1562: EXCEPTION
1563: WHEN NO_DATA_FOUND THEN
1564: IF l_debug_level > 0 THEN
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 ;