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

156: l_process_total2 NUMBER := 0 ;
157:
158: l_error_total NUMBER := 0 ;
159:
160: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level ;
161:
162: -- Cursors that query all transactions needed to be migrated
163: -- since all credit cards for closed orders would have already created bank account id
164: -- in ap_bank_accounts, so we can get the bank_account_id first, then get the instrument

Line 434: oe_debug_pub.add('') ;

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 : ') ;
436: oe_debug_pub.add('') ;
437: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
438: oe_debug_pub.add('Table name : ' || l_table_name) ;

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

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 : ') ;
436: oe_debug_pub.add('') ;
437: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
438: oe_debug_pub.add('Table name : ' || l_table_name) ;
439: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

Line 436: oe_debug_pub.add('') ;

432:
433: IF l_debug_level > 0 THEN
434: oe_debug_pub.add('') ;
435: oe_debug_pub.add('AD parallel details : ') ;
436: oe_debug_pub.add('') ;
437: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
438: oe_debug_pub.add('Table name : ' || l_table_name) ;
439: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
440: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

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

433: IF l_debug_level > 0 THEN
434: oe_debug_pub.add('') ;
435: oe_debug_pub.add('AD parallel details : ') ;
436: oe_debug_pub.add('') ;
437: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
438: oe_debug_pub.add('Table name : ' || l_table_name) ;
439: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
440: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
441: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

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

434: oe_debug_pub.add('') ;
435: oe_debug_pub.add('AD parallel details : ') ;
436: oe_debug_pub.add('') ;
437: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
438: oe_debug_pub.add('Table name : ' || l_table_name) ;
439: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
440: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
441: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
442: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;

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

435: oe_debug_pub.add('AD parallel details : ') ;
436: oe_debug_pub.add('') ;
437: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
438: oe_debug_pub.add('Table name : ' || l_table_name) ;
439: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
440: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
441: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
442: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
443: END IF ;

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

436: oe_debug_pub.add('') ;
437: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
438: oe_debug_pub.add('Table name : ' || l_table_name) ;
439: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
440: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
441: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
442: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
443: END IF ;
444:

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

437: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
438: oe_debug_pub.add('Table name : ' || l_table_name) ;
439: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
440: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
441: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
442: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
443: END IF ;
444:
445: l_process_total1 := 0 ;

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

438: oe_debug_pub.add('Table name : ' || l_table_name) ;
439: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
440: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
441: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
442: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
443: END IF ;
444:
445: l_process_total1 := 0 ;
446:

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

485:
486: CLOSE payments_cur1_sec ;
487: END IF ;
488:
489: -- oe_debug_pub.add('Number of Records selected in payments_cur1 : ' || trxn_entity_id_tab.count) ;
490:
491: IF trxn_entity_id_tab.count > 0 THEN
492: -- insert the transactions into IBY transaction extension table
493: FORALL k in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS

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

600: FALSE) ;
601: END LOOP ;
602:
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

Line 612: oe_debug_pub.add('') ;

608: EXCEPTION
609: WHEN NO_DATA_FOUND THEN
610:
611: IF l_debug_level > 0 THEN
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) ;

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

609: WHEN NO_DATA_FOUND THEN
610:
611: IF l_debug_level > 0 THEN
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

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

630: END LOOP;
631: END ;
632:
633: IF l_debug_level > 0 THEN
634: oe_debug_pub.add('Total No of records errored in oe_order_headers_all : ' || l_error_total) ;
635: END IF;
636:
637: -- Migrate data in oe_payments for Credit Card payment types.
638: BEGIN

Line 670: oe_debug_pub.add('') ;

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 : ') ;
672: oe_debug_pub.add('') ;
673: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
674: oe_debug_pub.add('Table name : ' || l_table_name) ;

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

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 : ') ;
672: oe_debug_pub.add('') ;
673: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
674: oe_debug_pub.add('Table name : ' || l_table_name) ;
675: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

Line 672: oe_debug_pub.add('') ;

668:
669: IF l_debug_level > 0 THEN
670: oe_debug_pub.add('') ;
671: oe_debug_pub.add('AD parallel details : ') ;
672: oe_debug_pub.add('') ;
673: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
674: oe_debug_pub.add('Table name : ' || l_table_name) ;
675: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
676: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

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

669: IF l_debug_level > 0 THEN
670: oe_debug_pub.add('') ;
671: oe_debug_pub.add('AD parallel details : ') ;
672: oe_debug_pub.add('') ;
673: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
674: oe_debug_pub.add('Table name : ' || l_table_name) ;
675: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
676: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
677: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

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

670: oe_debug_pub.add('') ;
671: oe_debug_pub.add('AD parallel details : ') ;
672: oe_debug_pub.add('') ;
673: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
674: oe_debug_pub.add('Table name : ' || l_table_name) ;
675: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
676: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
677: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
678: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;

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

671: oe_debug_pub.add('AD parallel details : ') ;
672: oe_debug_pub.add('') ;
673: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
674: oe_debug_pub.add('Table name : ' || l_table_name) ;
675: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
676: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
677: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
678: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
679: END IF ;

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

672: oe_debug_pub.add('') ;
673: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
674: oe_debug_pub.add('Table name : ' || l_table_name) ;
675: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
676: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
677: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
678: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
679: END IF ;
680:

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

673: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
674: oe_debug_pub.add('Table name : ' || l_table_name) ;
675: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
676: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
677: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
678: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
679: END IF ;
680:
681: l_process_total1 := 0 ;

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

674: oe_debug_pub.add('Table name : ' || l_table_name) ;
675: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
676: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
677: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
678: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
679: END IF ;
680:
681: l_process_total1 := 0 ;
682:

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

720:
721: CLOSE payments_cur2_sec ;
722: END IF ;
723:
724: -- oe_debug_pub.add('Number of Records selected in payments_cur2 : ' || trxn_entity_id_tab.count) ;
725:
726: IF trxn_entity_id_tab.count > 0 THEN
727: -- insert the transactions into IBY transaction extension table
728: FORALL k in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS

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

794: FALSE) ;
795: END LOOP ;
796:
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

Line 805: oe_debug_pub.add('') ;

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

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

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

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

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

Line 863: oe_debug_pub.add('') ;

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 : ') ;
865: oe_debug_pub.add('') ;
866: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
867: oe_debug_pub.add('Table name : ' || l_table_name) ;

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

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 : ') ;
865: oe_debug_pub.add('') ;
866: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
867: oe_debug_pub.add('Table name : ' || l_table_name) ;
868: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

Line 865: oe_debug_pub.add('') ;

861:
862: IF l_debug_level > 0 THEN
863: oe_debug_pub.add('') ;
864: oe_debug_pub.add('AD parallel details : ') ;
865: oe_debug_pub.add('') ;
866: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
867: oe_debug_pub.add('Table name : ' || l_table_name) ;
868: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
869: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

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

862: IF l_debug_level > 0 THEN
863: oe_debug_pub.add('') ;
864: oe_debug_pub.add('AD parallel details : ') ;
865: oe_debug_pub.add('') ;
866: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
867: oe_debug_pub.add('Table name : ' || l_table_name) ;
868: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
869: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
870: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

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

863: oe_debug_pub.add('') ;
864: oe_debug_pub.add('AD parallel details : ') ;
865: oe_debug_pub.add('') ;
866: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
867: oe_debug_pub.add('Table name : ' || l_table_name) ;
868: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
869: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
870: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
871: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;

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

864: oe_debug_pub.add('AD parallel details : ') ;
865: oe_debug_pub.add('') ;
866: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
867: oe_debug_pub.add('Table name : ' || l_table_name) ;
868: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
869: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
870: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
871: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
872: END IF ;

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

865: oe_debug_pub.add('') ;
866: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
867: oe_debug_pub.add('Table name : ' || l_table_name) ;
868: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
869: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
870: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
871: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
872: END IF ;
873:

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

866: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
867: oe_debug_pub.add('Table name : ' || l_table_name) ;
868: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
869: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
870: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
871: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
872: END IF ;
873:
874: l_process_total1 := 0 ;

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

867: oe_debug_pub.add('Table name : ' || l_table_name) ;
868: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
869: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
870: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
871: oe_debug_pub.add('Cut off Date : ' || l_cutoff_date) ;
872: END IF ;
873:
874: l_process_total1 := 0 ;
875:

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

895: Limit X_batch_size ;
896:
897: CLOSE payments_cur3 ;
898:
899: -- oe_debug_pub.add('Number of Records selected in payments_cur3 is : ' || trxn_entity_id_tab.count) ;
900:
901: IF trxn_entity_id_tab.count > 0 THEN
902: -- insert the transactions into IBY transaction extension table
903: FORALL k in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS

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

967: FALSE) ;
968: END LOOP ;
969:
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:

Line 979: oe_debug_pub.add('') ;

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

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

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

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

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

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

1094: l_error_total1 NUMBER := 0 ;
1095:
1096: l_process_total1 NUMBER := 0 ;
1097:
1098: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level ;
1099:
1100: -- Define a cursor oe_payments_cur to select header_id from oe_payments where
1101: -- payment type code in ('CREDIT_CARD', 'ACH', 'DIRECT_DEBIT'), for the given IN parameters
1102:

Line 1195: oe_debug_pub.add('') ;

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

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

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

Line 1215: oe_debug_pub.add('') ;

1211: AND ROWNUM = 1 ;
1212: EXCEPTION
1213: WHEN NO_DATA_FOUND THEN
1214: IF l_debug_level > 0 THEN
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) ;

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

1212: EXCEPTION
1213: WHEN NO_DATA_FOUND THEN
1214: IF l_debug_level > 0 THEN
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;

Line 1232: oe_debug_pub.add('') ;

1228: AND ROWNUM = 1 ;
1229: EXCEPTION
1230: WHEN NO_DATA_FOUND THEN
1231: IF l_debug_level > 0 THEN
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) ;

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

1229: EXCEPTION
1230: WHEN NO_DATA_FOUND THEN
1231: IF l_debug_level > 0 THEN
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;

Line 1241: oe_debug_pub.add('') ;

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
1241: oe_debug_pub.add('') ;
1242: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;
1243: oe_debug_pub.add('Data NOT migrated from OE_PAYMENTS table (Y/N) : ' || l_exists_payment) ;
1244: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;
1245: oe_debug_pub.add('Please migrate the data before proceeding to purge secured payment data') ;

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

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
1241: oe_debug_pub.add('') ;
1242: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;
1243: oe_debug_pub.add('Data NOT migrated from OE_PAYMENTS table (Y/N) : ' || l_exists_payment) ;
1244: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;
1245: oe_debug_pub.add('Please migrate the data before proceeding to purge secured payment data') ;
1246: END IF;

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

1239: IF l_exists_header = 'Y' OR l_exists_payment = 'Y' OR l_exists_history = 'Y' THEN
1240: IF l_debug_level > 0 THEN
1241: oe_debug_pub.add('') ;
1242: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;
1243: oe_debug_pub.add('Data NOT migrated from OE_PAYMENTS table (Y/N) : ' || l_exists_payment) ;
1244: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;
1245: oe_debug_pub.add('Please migrate the data before proceeding to purge secured payment data') ;
1246: END IF;
1247:

Line 1244: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;

1240: IF l_debug_level > 0 THEN
1241: oe_debug_pub.add('') ;
1242: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;
1243: oe_debug_pub.add('Data NOT migrated from OE_PAYMENTS table (Y/N) : ' || l_exists_payment) ;
1244: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;
1245: oe_debug_pub.add('Please migrate the data before proceeding to purge secured payment data') ;
1246: END IF;
1247:
1248: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;

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

1241: oe_debug_pub.add('') ;
1242: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;
1243: oe_debug_pub.add('Data NOT migrated from OE_PAYMENTS table (Y/N) : ' || l_exists_payment) ;
1244: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;
1245: oe_debug_pub.add('Please migrate the data before proceeding to purge secured payment data') ;
1246: END IF;
1247:
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) ;

Line 1260: oe_debug_pub.add('') ;

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 : ') ;
1262: oe_debug_pub.add('') ;
1263: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1264: oe_debug_pub.add('Table name : ' || l_table_name) ;

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

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 : ') ;
1262: oe_debug_pub.add('') ;
1263: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1264: oe_debug_pub.add('Table name : ' || l_table_name) ;
1265: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

Line 1262: oe_debug_pub.add('') ;

1258:
1259: IF l_debug_level > 0 THEN
1260: oe_debug_pub.add('') ;
1261: oe_debug_pub.add('AD parallel details : ') ;
1262: oe_debug_pub.add('') ;
1263: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1264: oe_debug_pub.add('Table name : ' || l_table_name) ;
1265: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1266: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

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

1259: IF l_debug_level > 0 THEN
1260: oe_debug_pub.add('') ;
1261: oe_debug_pub.add('AD parallel details : ') ;
1262: oe_debug_pub.add('') ;
1263: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1264: oe_debug_pub.add('Table name : ' || l_table_name) ;
1265: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1266: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1267: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

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

1260: oe_debug_pub.add('') ;
1261: oe_debug_pub.add('AD parallel details : ') ;
1262: oe_debug_pub.add('') ;
1263: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1264: oe_debug_pub.add('Table name : ' || l_table_name) ;
1265: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1266: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1267: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1268: END IF ;

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

1261: oe_debug_pub.add('AD parallel details : ') ;
1262: oe_debug_pub.add('') ;
1263: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1264: oe_debug_pub.add('Table name : ' || l_table_name) ;
1265: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1266: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1267: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1268: END IF ;
1269:

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

1262: oe_debug_pub.add('') ;
1263: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1264: oe_debug_pub.add('Table name : ' || l_table_name) ;
1265: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1266: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1267: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1268: END IF ;
1269:
1270: l_error_total1 := 0 ;

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

1263: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1264: oe_debug_pub.add('Table name : ' || l_table_name) ;
1265: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1266: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1267: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1268: END IF ;
1269:
1270: l_error_total1 := 0 ;
1271:

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

1282: LIMIT X_batch_size ;
1283:
1284: CLOSE oe_payments_cur ;
1285:
1286: -- oe_debug_pub.add('Number of Records : ' || header_id_tab.count) ;
1287:
1288: IF header_id_tab.count > 0 THEN
1289: BEGIN
1290: FORALL i in header_id_tab.FIRST..header_id_tab.LAST SAVE EXCEPTIONS

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

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

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

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

Line 1350: oe_debug_pub.add('') ;

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

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

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

Line 1389: oe_debug_pub.add('') ;

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 : ') ;
1391: oe_debug_pub.add('') ;
1392: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1393: oe_debug_pub.add('Table name : ' || l_table_name) ;

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

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 : ') ;
1391: oe_debug_pub.add('') ;
1392: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1393: oe_debug_pub.add('Table name : ' || l_table_name) ;
1394: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

Line 1391: oe_debug_pub.add('') ;

1387:
1388: IF l_debug_level > 0 THEN
1389: oe_debug_pub.add('') ;
1390: oe_debug_pub.add('AD parallel details : ') ;
1391: oe_debug_pub.add('') ;
1392: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1393: oe_debug_pub.add('Table name : ' || l_table_name) ;
1394: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1395: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

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

1388: IF l_debug_level > 0 THEN
1389: oe_debug_pub.add('') ;
1390: oe_debug_pub.add('AD parallel details : ') ;
1391: oe_debug_pub.add('') ;
1392: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1393: oe_debug_pub.add('Table name : ' || l_table_name) ;
1394: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1395: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1396: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

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

1389: oe_debug_pub.add('') ;
1390: oe_debug_pub.add('AD parallel details : ') ;
1391: oe_debug_pub.add('') ;
1392: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1393: oe_debug_pub.add('Table name : ' || l_table_name) ;
1394: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1395: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1396: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1397: END IF ;

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

1390: oe_debug_pub.add('AD parallel details : ') ;
1391: oe_debug_pub.add('') ;
1392: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1393: oe_debug_pub.add('Table name : ' || l_table_name) ;
1394: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1395: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1396: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1397: END IF ;
1398:

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

1391: oe_debug_pub.add('') ;
1392: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1393: oe_debug_pub.add('Table name : ' || l_table_name) ;
1394: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1395: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1396: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1397: END IF ;
1398:
1399: l_error_total1 := 0 ;

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

1392: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1393: oe_debug_pub.add('Table name : ' || l_table_name) ;
1394: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1395: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1396: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1397: END IF ;
1398:
1399: l_error_total1 := 0 ;
1400:

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

1411: LIMIT X_batch_size ;
1412:
1413: CLOSE header_payments_cur ;
1414:
1415: -- oe_debug_pub.add('Number of Records : ' || header_id_tab.count) ;
1416:
1417: IF header_id_tab.count > 0 THEN
1418: BEGIN
1419: FORALL i in header_id_tab.FIRST..header_id_tab.LAST SAVE EXCEPTIONS

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

1464: FALSE) ;
1465: END LOOP ;
1466:
1467: IF l_debug_level > 0 THEN
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');

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

1465: END LOOP ;
1466:
1467: IF l_debug_level > 0 THEN
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:

Line 1477: oe_debug_pub.add('') ;

1473:
1474: EXCEPTION
1475: WHEN NO_DATA_FOUND THEN
1476: IF l_debug_level > 0 THEN
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) ;

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

1474: EXCEPTION
1475: WHEN NO_DATA_FOUND THEN
1476: IF l_debug_level > 0 THEN
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 ;

Line 1518: oe_debug_pub.add('') ;

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 : ') ;
1520: oe_debug_pub.add('') ;
1521: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1522: oe_debug_pub.add('Table name : ' || l_table_name) ;

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

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 : ') ;
1520: oe_debug_pub.add('') ;
1521: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1522: oe_debug_pub.add('Table name : ' || l_table_name) ;
1523: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;

Line 1520: oe_debug_pub.add('') ;

1516:
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add('') ;
1519: oe_debug_pub.add('AD parallel details : ') ;
1520: oe_debug_pub.add('') ;
1521: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1522: oe_debug_pub.add('Table name : ' || l_table_name) ;
1523: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1524: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;

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

1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add('') ;
1519: oe_debug_pub.add('AD parallel details : ') ;
1520: oe_debug_pub.add('') ;
1521: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1522: oe_debug_pub.add('Table name : ' || l_table_name) ;
1523: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1524: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1525: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;

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

1518: oe_debug_pub.add('') ;
1519: oe_debug_pub.add('AD parallel details : ') ;
1520: oe_debug_pub.add('') ;
1521: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1522: oe_debug_pub.add('Table name : ' || l_table_name) ;
1523: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1524: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1525: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1526: END IF ;

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

1519: oe_debug_pub.add('AD parallel details : ') ;
1520: oe_debug_pub.add('') ;
1521: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1522: oe_debug_pub.add('Table name : ' || l_table_name) ;
1523: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1524: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1525: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1526: END IF ;
1527:

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

1520: oe_debug_pub.add('') ;
1521: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1522: oe_debug_pub.add('Table name : ' || l_table_name) ;
1523: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1524: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1525: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1526: END IF ;
1527:
1528: l_error_total1 := 0 ;

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

1521: oe_debug_pub.add('Table owner : ' || l_table_owner) ;
1522: oe_debug_pub.add('Table name : ' || l_table_name) ;
1523: oe_debug_pub.add('Batch Size : ' || X_batch_size) ;
1524: oe_debug_pub.add('Worker ID : ' || X_worker_id) ;
1525: oe_debug_pub.add('No of Worker : ' || X_num_workers) ;
1526: END IF ;
1527:
1528: l_error_total1 := 0 ;
1529:

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

1540: LIMIT X_batch_size ;
1541:
1542: CLOSE hist_payments_cur ;
1543:
1544: -- oe_debug_pub.add('Number of Records : ' || header_id_tab.count) ;
1545:
1546: IF row_id_tab.count > 0 THEN
1547: BEGIN
1548: FORALL i in row_id_tab.FIRST..row_id_tab.LAST SAVE EXCEPTIONS

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

1591: FALSE) ;
1592: END LOOP ;
1593:
1594: IF l_debug_level > 0 THEN
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');

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

1592: END LOOP ;
1593:
1594: IF l_debug_level > 0 THEN
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:

Line 1604: oe_debug_pub.add('') ;

1600:
1601: EXCEPTION
1602: WHEN NO_DATA_FOUND THEN
1603: IF l_debug_level > 0 THEN
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) ;

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

1601: EXCEPTION
1602: WHEN NO_DATA_FOUND THEN
1603: IF l_debug_level > 0 THEN
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 ;