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.CSI_ML_PROGRAM_PUB dependencies on FND_FILE

Line 55: FND_File.Put_Line(Fnd_File.LOG,'Invoking Pre-processor');

51: AND process_status = 'R';
52: COMMIT;
53:
54: IF(l_debug_level>1) THEN
55: FND_File.Put_Line(Fnd_File.LOG,'Invoking Pre-processor');
56: END IF;
57:
58: LOOP
59: OPEN syncup_instance_cur;

Line 86: FND_File.Put_Line(Fnd_File.LOG,'Error : '||l_error_message);

82: x_error_msg => l_error_message
83: );
84: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
85: IF(l_debug_level>1) THEN
86: FND_File.Put_Line(Fnd_File.LOG,'Error : '||l_error_message);
87: end if;
88: RAISE fnd_api.g_exc_error;
89: END IF;
90:

Line 100: FND_File.Put_Line(Fnd_File.LOG,'Error : '||l_error_message);

96: x_error_msg => l_error_message
97: );
98: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
99: IF(l_debug_level>1) THEN
100: FND_File.Put_Line(Fnd_File.LOG,'Error : '||l_error_message);
101: END IF;
102: RAISE fnd_api.g_exc_error;
103: END IF;
104:

Line 262: FND_File.Put_Line(Fnd_File.LOG,'Calling Process_iface_txns: ');

258: -- Step 1: Run the create process to create all instances in the
259: -- Interface Tables.
260:
261: IF(l_debug_level>1) THEN
262: FND_File.Put_Line(Fnd_File.LOG,'Calling Process_iface_txns: ');
263: END IF;
264: CSI_ML_interface_txn_pvt.process_iface_txns(l_error_message,
265: l_return_status,
266: p_txn_from_date,

Line 279: FND_File.Put_Line(Fnd_File.LOG,l_error_message);

275:
276: EXCEPTION
277: WHEN fnd_api.g_exc_error THEN
278: IF(l_debug_level>1) THEN
279: FND_File.Put_Line(Fnd_File.LOG,l_error_message);
280: END IF;
281:
282:
283: WHEN others THEN

Line 288: FND_File.Put_Line(Fnd_File.LOG,'CSI_ML_PROGRAM_PUB.execute_openinterface - Into when others exception ');

284: l_sql_error := SQLERRM;
285: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
286: fnd_message.set_token('API_NAME',l_api_name);
287: fnd_message.set_token('SQL_ERROR',SQLERRM);
288: FND_File.Put_Line(Fnd_File.LOG,'CSI_ML_PROGRAM_PUB.execute_openinterface - Into when others exception ');
289:
290:
291: END execute_openinterface;
292:

Line 397: FND_File.Put_Line(Fnd_File.LOG,'Value of req_data is :'||req_data);

393: BEGIN
394:
395: req_data:= fnd_conc_global.request_data;
396: IF(l_debug_level>1) THEN
397: FND_File.Put_Line(Fnd_File.LOG,'Value of req_data is :'||req_data);
398: END IF;
399: IF req_data IS NULL
400: THEN
401: -- Since req_data is null, I'll assume this is the first run.

Line 475: FND_File.Put_Line(Fnd_File.LOG,'Begin Execute paralle create: '||p_worker_count);

471: IF NOT l_return_status = l_fnd_success THEN
472: RAISE fnd_api.g_exc_error;
473: END IF;
474: IF(l_debug_level>1) THEN
475: FND_File.Put_Line(Fnd_File.LOG,'Begin Execute paralle create: '||p_worker_count);
476: END IF;
477: -- x_return_status := l_fnd_success;
478:
479: -- If the worker number is not provided default to 32

Line 482: FND_File.Put_Line(Fnd_File.LOG,'p_worker_count: '||p_worker_count);

478:
479: -- If the worker number is not provided default to 32
480:
481: IF(l_debug_level>1) THEN
482: FND_File.Put_Line(Fnd_File.LOG,'p_worker_count: '||p_worker_count);
483: END IF;
484: IF (p_worker_count is NULL OR
485: p_worker_count > 32) THEN
486: l_worker_count := 32;

Line 561: FND_File.Put_Line(Fnd_File.LOG,'Records In Table: '||l_tbl_count);

557: l_tbl_count := 0;
558: l_tbl_count := l_inst_id_tbl.count;
559:
560: IF(l_debug_level>1) THEN
561: FND_File.Put_Line(Fnd_File.LOG,'Records In Table: '||l_tbl_count);
562: END IF;
563:
564: -- Now that the parallel_worker_id column is updated and committed
565: -- we can run the create procedure using multiple concurrent workers

Line 572: FND_File.Put_Line(Fnd_File.LOG,'Before apps initialize: ');

568: -- Set FND security valiables
569: END LOOP;
570:
571: IF(l_debug_level>1) THEN
572: FND_File.Put_Line(Fnd_File.LOG,'Before apps initialize: ');
573: END IF;
574:
575: OPEN candidates_exist_cur;
576: FETCH candidates_exist_cur INTO l_dummy;

Line 587: FND_File.Put_Line(Fnd_File.LOG,'Before submit request: ');

583: THEN
584: FOR l_count in 1..l_worker_count LOOP
585:
586: IF(l_debug_level>1) THEN
587: FND_File.Put_Line(Fnd_File.LOG,'Before submit request: ');
588: END IF;
589: l_request_id := FND_REQUEST.SUBMIT_REQUEST
590: ('CSI',
591: 'CSIMCPAW',

Line 602: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Instance Creation Process');

598: l_count, -- Argument4 Worker ID
599: p_resolve_ids); -- Resolve IDS
600:
601: IF(l_debug_level>1) THEN
602: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Instance Creation Process');
603: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
604: FND_File.Put_Line(Fnd_File.LOG,'');
605: END IF;
606:

Line 603: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');

599: p_resolve_ids); -- Resolve IDS
600:
601: IF(l_debug_level>1) THEN
602: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Instance Creation Process');
603: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
604: FND_File.Put_Line(Fnd_File.LOG,'');
605: END IF;
606:
607: IF (l_request_id = 0) THEN

Line 604: FND_File.Put_Line(Fnd_File.LOG,'');

600:
601: IF(l_debug_level>1) THEN
602: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Instance Creation Process');
603: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
604: FND_File.Put_Line(Fnd_File.LOG,'');
605: END IF;
606:
607: IF (l_request_id = 0) THEN
608: l_req_count:=l_req_count+1;

Line 611: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));

607: IF (l_request_id = 0) THEN
608: l_req_count:=l_req_count+1;
609: l_errbuf := FND_MESSAGE.GET;
610: IF(l_debug_level>1) THEN
611: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
612: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
613: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
614: END IF;
615: END IF;

Line 612: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));

608: l_req_count:=l_req_count+1;
609: l_errbuf := FND_MESSAGE.GET;
610: IF(l_debug_level>1) THEN
611: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
612: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
613: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
614: END IF;
615: END IF;
616: COMMIT;

Line 613: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));

609: l_errbuf := FND_MESSAGE.GET;
610: IF(l_debug_level>1) THEN
611: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
612: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
613: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
614: END IF;
615: END IF;
616: COMMIT;
617: END LOOP;

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

618:
619: IF l_req_count>0
620: THEN
621: IF(l_debug_level>1) THEN
622: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------------------------');
623: fnd_file.put_line(FND_FILE.OUTPUT,' PARALLEL WORKER SUBMISSION ERROR ');
624: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------------------------');
625: fnd_file.put_line(FND_FILE.OUTPUT,'One or more sub-requests/parallel workers were not submitted successfully.');
626: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------------------------');

Line 623: fnd_file.put_line(FND_FILE.OUTPUT,' PARALLEL WORKER SUBMISSION ERROR ');

619: IF l_req_count>0
620: THEN
621: IF(l_debug_level>1) THEN
622: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------------------------');
623: fnd_file.put_line(FND_FILE.OUTPUT,' PARALLEL WORKER SUBMISSION ERROR ');
624: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------------------------');
625: fnd_file.put_line(FND_FILE.OUTPUT,'One or more sub-requests/parallel workers were not submitted successfully.');
626: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------------------------');
627: END IF;

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

620: THEN
621: IF(l_debug_level>1) THEN
622: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------------------------');
623: fnd_file.put_line(FND_FILE.OUTPUT,' PARALLEL WORKER SUBMISSION ERROR ');
624: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------------------------');
625: fnd_file.put_line(FND_FILE.OUTPUT,'One or more sub-requests/parallel workers were not submitted successfully.');
626: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------------------------');
627: END IF;
628: END IF;

Line 625: fnd_file.put_line(FND_FILE.OUTPUT,'One or more sub-requests/parallel workers were not submitted successfully.');

621: IF(l_debug_level>1) THEN
622: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------------------------');
623: fnd_file.put_line(FND_FILE.OUTPUT,' PARALLEL WORKER SUBMISSION ERROR ');
624: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------------------------');
625: fnd_file.put_line(FND_FILE.OUTPUT,'One or more sub-requests/parallel workers were not submitted successfully.');
626: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------------------------');
627: END IF;
628: END IF;
629:

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

622: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------------------------');
623: fnd_file.put_line(FND_FILE.OUTPUT,' PARALLEL WORKER SUBMISSION ERROR ');
624: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------------------------');
625: fnd_file.put_line(FND_FILE.OUTPUT,'One or more sub-requests/parallel workers were not submitted successfully.');
626: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------------------------');
627: END IF;
628: END IF;
629:
630: IF(l_debug_level>1) THEN

Line 631: FND_File.Put_Line(Fnd_File.LOG,'Note : Please check the request "view log" of all the child processors for any un-expected error messages.');

627: END IF;
628: END IF;
629:
630: IF(l_debug_level>1) THEN
631: FND_File.Put_Line(Fnd_File.LOG,'Note : Please check the request "view log" of all the child processors for any un-expected error messages.');
632: END IF;
633: -- All the child requests were successfully requested.
634: -- Now I'll put the parent program to sleep/paused state.
635: req_data:=to_char(l_old_error);

Line 639: FND_File.Put_Line(Fnd_File.LOG,'Value of request_data that was passed to fnd_conc_global.set_req_globals is: '||FND_CONC_GLOBAL.request_data);

635: req_data:=to_char(l_old_error);
636: fnd_conc_global.set_req_globals (conc_status => 'PAUSED',
637: request_data => req_data);
638: IF(l_debug_level>1) THEN
639: FND_File.Put_Line(Fnd_File.LOG,'Value of request_data that was passed to fnd_conc_global.set_req_globals is: '||FND_CONC_GLOBAL.request_data);
640: END IF;
641: errbuf := 'sub-requests submitted';
642: retcode := 0;
643: return;

Line 660: FND_File.Put_Line(Fnd_File.LOG,'l_rel_count <> zero');

656: END;
657:
658: IF l_rel_count>0
659: THEN
660: FND_File.Put_Line(Fnd_File.LOG,'l_rel_count <> zero');
661: FND_File.Put_Line(Fnd_File.LOG,'Begin - parallel creation of relationships: '||p_worker_count);
662: FND_File.Put_Line(Fnd_File.LOG,'p_worker_count: '||p_worker_count);
663: IF (p_worker_count IS NULL OR
664: p_worker_count > 32)

Line 661: FND_File.Put_Line(Fnd_File.LOG,'Begin - parallel creation of relationships: '||p_worker_count);

657:
658: IF l_rel_count>0
659: THEN
660: FND_File.Put_Line(Fnd_File.LOG,'l_rel_count <> zero');
661: FND_File.Put_Line(Fnd_File.LOG,'Begin - parallel creation of relationships: '||p_worker_count);
662: FND_File.Put_Line(Fnd_File.LOG,'p_worker_count: '||p_worker_count);
663: IF (p_worker_count IS NULL OR
664: p_worker_count > 32)
665: THEN

Line 662: FND_File.Put_Line(Fnd_File.LOG,'p_worker_count: '||p_worker_count);

658: IF l_rel_count>0
659: THEN
660: FND_File.Put_Line(Fnd_File.LOG,'l_rel_count <> zero');
661: FND_File.Put_Line(Fnd_File.LOG,'Begin - parallel creation of relationships: '||p_worker_count);
662: FND_File.Put_Line(Fnd_File.LOG,'p_worker_count: '||p_worker_count);
663: IF (p_worker_count IS NULL OR
664: p_worker_count > 32)
665: THEN
666: l_r_worker_count := 32;

Line 694: FND_File.Put_Line(Fnd_File.LOG,'Before calling csi_ml_util_pvt.resolve_rel_ids');

690: COMMIT;
691: END LOOP;
692:
693: IF(l_debug_level>1) THEN
694: FND_File.Put_Line(Fnd_File.LOG,'Before calling csi_ml_util_pvt.resolve_rel_ids');
695: END IF;
696: -- To resolve id columns
697: csi_ml_util_pvt.resolve_rel_ids
698: (p_source_system => p_source_system_name

Line 705: FND_File.Put_Line(Fnd_File.LOG,'After calling csi_ml_util_pvt.resolve_rel_ids');

701: ,x_return_status => l_return_status
702: ,x_error_message => l_error_message
703: );
704: IF(l_debug_level>1) THEN
705: FND_File.Put_Line(Fnd_File.LOG,'After calling csi_ml_util_pvt.resolve_rel_ids');
706: END IF;
707:
708: csi_ml_util_pvt.eliminate_dup_records;
709: csi_ml_util_pvt.eliminate_dup_subject;

Line 725: FND_File.Put_Line(Fnd_File.LOG,'Before submitting request for relationships: ');

721: THEN
722: FOR l_count in 1..l_r_worker_count
723: LOOP
724: IF(l_debug_level>1) THEN
725: FND_File.Put_Line(Fnd_File.LOG,'Before submitting request for relationships: ');
726: FND_File.Put_Line(Fnd_File.LOG,'Start time in validate mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
727: END IF;
728: l_request_id := FND_REQUEST.SUBMIT_REQUEST
729: ( 'CSI'

Line 726: FND_File.Put_Line(Fnd_File.LOG,'Start time in validate mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));

722: FOR l_count in 1..l_r_worker_count
723: LOOP
724: IF(l_debug_level>1) THEN
725: FND_File.Put_Line(Fnd_File.LOG,'Before submitting request for relationships: ');
726: FND_File.Put_Line(Fnd_File.LOG,'Start time in validate mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
727: END IF;
728: l_request_id := FND_REQUEST.SUBMIT_REQUEST
729: ( 'CSI'
730: ,'CSIMCREL'

Line 741: FND_File.Put_Line(Fnd_File.LOG,'End time in validate mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));

737: ,p_txn_to_date
738: ,p_source_system_name
739: );
740: IF(l_debug_level>1) THEN
741: FND_File.Put_Line(Fnd_File.LOG,'End time in validate mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
742: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
743: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
744: FND_File.Put_Line(Fnd_File.LOG,'');
745: END IF;

Line 742: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');

738: ,p_source_system_name
739: );
740: IF(l_debug_level>1) THEN
741: FND_File.Put_Line(Fnd_File.LOG,'End time in validate mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
742: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
743: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
744: FND_File.Put_Line(Fnd_File.LOG,'');
745: END IF;
746:

Line 743: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');

739: );
740: IF(l_debug_level>1) THEN
741: FND_File.Put_Line(Fnd_File.LOG,'End time in validate mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
742: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
743: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
744: FND_File.Put_Line(Fnd_File.LOG,'');
745: END IF;
746:
747: IF (l_request_id = 0) THEN

Line 744: FND_File.Put_Line(Fnd_File.LOG,'');

740: IF(l_debug_level>1) THEN
741: FND_File.Put_Line(Fnd_File.LOG,'End time in validate mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
742: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
743: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
744: FND_File.Put_Line(Fnd_File.LOG,'');
745: END IF;
746:
747: IF (l_request_id = 0) THEN
748: l_req_count:=l_req_count+1;

Line 751: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));

747: IF (l_request_id = 0) THEN
748: l_req_count:=l_req_count+1;
749: l_errbuf := FND_MESSAGE.GET;
750: IF(l_debug_level>1) THEN
751: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
752: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
753: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
754: END IF;
755: END IF;

Line 752: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));

748: l_req_count:=l_req_count+1;
749: l_errbuf := FND_MESSAGE.GET;
750: IF(l_debug_level>1) THEN
751: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
752: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
753: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
754: END IF;
755: END IF;
756: COMMIT;

Line 753: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));

749: l_errbuf := FND_MESSAGE.GET;
750: IF(l_debug_level>1) THEN
751: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
752: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
753: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
754: END IF;
755: END IF;
756: COMMIT;
757: END LOOP;

Line 769: FND_File.Put_Line(Fnd_File.LOG,'No candidate records in the interface tables: ');

765: RETURN;
766: ELSE
767:
768: IF(l_debug_level>1) THEN
769: FND_File.Put_Line(Fnd_File.LOG,'No candidate records in the interface tables: ');
770: END IF;
771: l_old_error:=0;
772: l_new_error:=0;
773: errbuf := 'Done!';

Line 784: FND_File.Put_Line(Fnd_File.LOG,'Start time RELATIONSHIP: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));

780:
781: ELSE
782:
783: IF(l_debug_level>1) THEN
784: FND_File.Put_Line(Fnd_File.LOG,'Start time RELATIONSHIP: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
785: END IF;
786: -- Added for relationship interface
787: BEGIN
788: SELECT COUNT(*)

Line 799: FND_File.Put_Line(Fnd_File.LOG,'Value of l_rel_count is: '||l_rel_count);

795: WHEN NO_DATA_FOUND THEN
796: l_rel_count :=0;
797: END;
798: IF(l_debug_level>1) THEN
799: FND_File.Put_Line(Fnd_File.LOG,'Value of l_rel_count is: '||l_rel_count);
800: END IF;
801: BEGIN
802: SELECT COUNT(*)
803: INTO l_valid_count

Line 814: FND_File.Put_Line(Fnd_File.LOG,'Value of l_valid_count is: '||l_valid_count);

810: WHEN NO_DATA_FOUND THEN
811: l_valid_count :=0;
812: END;
813: IF(l_debug_level>1) THEN
814: FND_File.Put_Line(Fnd_File.LOG,'Value of l_valid_count is: '||l_valid_count);
815: END IF;
816: BEGIN
817: SELECT COUNT(*)
818: INTO l_update_count

Line 830: FND_File.Put_Line(Fnd_File.LOG,'Value of l_valid_count is: '||l_valid_count);

826: l_update_count :=0;
827: END;
828:
829: IF(l_debug_level>1) THEN
830: FND_File.Put_Line(Fnd_File.LOG,'Value of l_valid_count is: '||l_valid_count);
831: END IF;
832:
833: BEGIN
834: SELECT COUNT(*)

Line 846: FND_File.Put_Line(Fnd_File.LOG,'Value of l_insert_count is: '||l_insert_count);

842: WHEN NO_DATA_FOUND THEN
843: l_insert_count :=0;
844: END;
845: IF(l_debug_level>1) THEN
846: FND_File.Put_Line(Fnd_File.LOG,'Value of l_insert_count is: '||l_insert_count);
847: END IF;
848: -- End addition for relationship interface
849: IF ( l_rel_count = 0
850: AND l_valid_count = 0

Line 855: FND_File.Put_Line(Fnd_File.LOG,'Values for l_rel_count l_valid_count l_update_count and l_insert_count are zero');

851: AND l_update_count = 0
852: AND l_insert_count = 0 )
853: THEN
854: IF(l_debug_level>1) THEN
855: FND_File.Put_Line(Fnd_File.LOG,'Values for l_rel_count l_valid_count l_update_count and l_insert_count are zero');
856: END IF;
857:
858: -- Parent program wakes up after successful completion of child programs.
859: l_old_error:=to_number(req_data);

Line 878: --FND_File.Put_Line(Fnd_File.LOG,'Total error records in interface table before submission of program are :'||l_old_error);

874:
875: IF l_new_error>l_old_error
876: THEN
877: -- I found that there were some new errors for the current run.
878: --FND_File.Put_Line(Fnd_File.LOG,'Total error records in interface table before submission of program are :'||l_old_error);
879: --FND_File.Put_Line(Fnd_File.LOG,'Total error records in interface table after submission of program are :'||l_new_error);
880: IF(l_debug_level>1) THEN
881: fnd_file.put_line(FND_FILE.OUTPUT,' ');
882: fnd_file.put_line(FND_FILE.OUTPUT,' ');

Line 879: --FND_File.Put_Line(Fnd_File.LOG,'Total error records in interface table after submission of program are :'||l_new_error);

875: IF l_new_error>l_old_error
876: THEN
877: -- I found that there were some new errors for the current run.
878: --FND_File.Put_Line(Fnd_File.LOG,'Total error records in interface table before submission of program are :'||l_old_error);
879: --FND_File.Put_Line(Fnd_File.LOG,'Total error records in interface table after submission of program are :'||l_new_error);
880: IF(l_debug_level>1) THEN
881: fnd_file.put_line(FND_FILE.OUTPUT,' ');
882: fnd_file.put_line(FND_FILE.OUTPUT,' ');
883: fnd_file.put_line(FND_FILE.OUTPUT,' ');

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

877: -- I found that there were some new errors for the current run.
878: --FND_File.Put_Line(Fnd_File.LOG,'Total error records in interface table before submission of program are :'||l_old_error);
879: --FND_File.Put_Line(Fnd_File.LOG,'Total error records in interface table after submission of program are :'||l_new_error);
880: IF(l_debug_level>1) THEN
881: fnd_file.put_line(FND_FILE.OUTPUT,' ');
882: fnd_file.put_line(FND_FILE.OUTPUT,' ');
883: fnd_file.put_line(FND_FILE.OUTPUT,' ');
884: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
885: fnd_file.put_line(FND_FILE.OUTPUT,' OPEN INTERFACE - PARALLEL WORKER ERROR RECORDS ');

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

878: --FND_File.Put_Line(Fnd_File.LOG,'Total error records in interface table before submission of program are :'||l_old_error);
879: --FND_File.Put_Line(Fnd_File.LOG,'Total error records in interface table after submission of program are :'||l_new_error);
880: IF(l_debug_level>1) THEN
881: fnd_file.put_line(FND_FILE.OUTPUT,' ');
882: fnd_file.put_line(FND_FILE.OUTPUT,' ');
883: fnd_file.put_line(FND_FILE.OUTPUT,' ');
884: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
885: fnd_file.put_line(FND_FILE.OUTPUT,' OPEN INTERFACE - PARALLEL WORKER ERROR RECORDS ');
886: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');

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

879: --FND_File.Put_Line(Fnd_File.LOG,'Total error records in interface table after submission of program are :'||l_new_error);
880: IF(l_debug_level>1) THEN
881: fnd_file.put_line(FND_FILE.OUTPUT,' ');
882: fnd_file.put_line(FND_FILE.OUTPUT,' ');
883: fnd_file.put_line(FND_FILE.OUTPUT,' ');
884: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
885: fnd_file.put_line(FND_FILE.OUTPUT,' OPEN INTERFACE - PARALLEL WORKER ERROR RECORDS ');
886: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
887: fnd_file.put_line(FND_FILE.OUTPUT,to_number(l_new_error-l_old_error)||' records were completed with error. Please check the instance interface table');

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

880: IF(l_debug_level>1) THEN
881: fnd_file.put_line(FND_FILE.OUTPUT,' ');
882: fnd_file.put_line(FND_FILE.OUTPUT,' ');
883: fnd_file.put_line(FND_FILE.OUTPUT,' ');
884: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
885: fnd_file.put_line(FND_FILE.OUTPUT,' OPEN INTERFACE - PARALLEL WORKER ERROR RECORDS ');
886: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
887: fnd_file.put_line(FND_FILE.OUTPUT,to_number(l_new_error-l_old_error)||' records were completed with error. Please check the instance interface table');
888: fnd_file.put_line(FND_FILE.OUTPUT,' for detailed error message.');

Line 885: fnd_file.put_line(FND_FILE.OUTPUT,' OPEN INTERFACE - PARALLEL WORKER ERROR RECORDS ');

881: fnd_file.put_line(FND_FILE.OUTPUT,' ');
882: fnd_file.put_line(FND_FILE.OUTPUT,' ');
883: fnd_file.put_line(FND_FILE.OUTPUT,' ');
884: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
885: fnd_file.put_line(FND_FILE.OUTPUT,' OPEN INTERFACE - PARALLEL WORKER ERROR RECORDS ');
886: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
887: fnd_file.put_line(FND_FILE.OUTPUT,to_number(l_new_error-l_old_error)||' records were completed with error. Please check the instance interface table');
888: fnd_file.put_line(FND_FILE.OUTPUT,' for detailed error message.');
889: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');

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

882: fnd_file.put_line(FND_FILE.OUTPUT,' ');
883: fnd_file.put_line(FND_FILE.OUTPUT,' ');
884: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
885: fnd_file.put_line(FND_FILE.OUTPUT,' OPEN INTERFACE - PARALLEL WORKER ERROR RECORDS ');
886: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
887: fnd_file.put_line(FND_FILE.OUTPUT,to_number(l_new_error-l_old_error)||' records were completed with error. Please check the instance interface table');
888: fnd_file.put_line(FND_FILE.OUTPUT,' for detailed error message.');
889: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
890: END IF;

Line 887: fnd_file.put_line(FND_FILE.OUTPUT,to_number(l_new_error-l_old_error)||' records were completed with error. Please check the instance interface table');

883: fnd_file.put_line(FND_FILE.OUTPUT,' ');
884: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
885: fnd_file.put_line(FND_FILE.OUTPUT,' OPEN INTERFACE - PARALLEL WORKER ERROR RECORDS ');
886: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
887: fnd_file.put_line(FND_FILE.OUTPUT,to_number(l_new_error-l_old_error)||' records were completed with error. Please check the instance interface table');
888: fnd_file.put_line(FND_FILE.OUTPUT,' for detailed error message.');
889: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
890: END IF;
891: l_old_error:=0;

Line 888: fnd_file.put_line(FND_FILE.OUTPUT,' for detailed error message.');

884: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
885: fnd_file.put_line(FND_FILE.OUTPUT,' OPEN INTERFACE - PARALLEL WORKER ERROR RECORDS ');
886: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
887: fnd_file.put_line(FND_FILE.OUTPUT,to_number(l_new_error-l_old_error)||' records were completed with error. Please check the instance interface table');
888: fnd_file.put_line(FND_FILE.OUTPUT,' for detailed error message.');
889: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
890: END IF;
891: l_old_error:=0;
892: l_new_error:=0;

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

885: fnd_file.put_line(FND_FILE.OUTPUT,' OPEN INTERFACE - PARALLEL WORKER ERROR RECORDS ');
886: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
887: fnd_file.put_line(FND_FILE.OUTPUT,to_number(l_new_error-l_old_error)||' records were completed with error. Please check the instance interface table');
888: fnd_file.put_line(FND_FILE.OUTPUT,' for detailed error message.');
889: fnd_file.put_line(FND_FILE.OUTPUT,'-----------------------------------------------------------------------------------');
890: END IF;
891: l_old_error:=0;
892: l_new_error:=0;
893: ELSE

Line 909: FND_File.Put_Line(Fnd_File.LOG,'l_rel_count <> zero');

905: -- Start relationship creation
906: IF l_rel_count <> 0
907: THEN
908: IF(l_debug_level>1) THEN
909: FND_File.Put_Line(Fnd_File.LOG,'l_rel_count <> zero');
910: FND_File.Put_Line(Fnd_File.LOG,'Begin - parallel creation of relationships: '||p_worker_count);
911: FND_File.Put_Line(Fnd_File.LOG,'p_worker_count: '||p_worker_count);
912: END IF;
913:

Line 910: FND_File.Put_Line(Fnd_File.LOG,'Begin - parallel creation of relationships: '||p_worker_count);

906: IF l_rel_count <> 0
907: THEN
908: IF(l_debug_level>1) THEN
909: FND_File.Put_Line(Fnd_File.LOG,'l_rel_count <> zero');
910: FND_File.Put_Line(Fnd_File.LOG,'Begin - parallel creation of relationships: '||p_worker_count);
911: FND_File.Put_Line(Fnd_File.LOG,'p_worker_count: '||p_worker_count);
912: END IF;
913:
914: IF (p_worker_count IS NULL OR

Line 911: FND_File.Put_Line(Fnd_File.LOG,'p_worker_count: '||p_worker_count);

907: THEN
908: IF(l_debug_level>1) THEN
909: FND_File.Put_Line(Fnd_File.LOG,'l_rel_count <> zero');
910: FND_File.Put_Line(Fnd_File.LOG,'Begin - parallel creation of relationships: '||p_worker_count);
911: FND_File.Put_Line(Fnd_File.LOG,'p_worker_count: '||p_worker_count);
912: END IF;
913:
914: IF (p_worker_count IS NULL OR
915: p_worker_count > 32)

Line 922: FND_File.Put_Line(Fnd_File.LOG,'source' || p_source_system_name);

918: ELSE
919: l_r_worker_count := p_worker_count;
920: END IF;
921:
922: FND_File.Put_Line(Fnd_File.LOG,'source' || p_source_system_name);
923:
924: SELECT ceil(count(1)/l_r_worker_count)
925: INTO x_r_count
926: FROM csi_ii_relation_interface

Line 935: FND_File.Put_Line(Fnd_File.LOG,'xrcount' || x_r_count);

931: AND process_status = 'R'
932: AND source_system_name = nvl(p_source_system_name,source_system_name)
933: AND parallel_worker_id = -1;
934:
935: FND_File.Put_Line(Fnd_File.LOG,'xrcount' || x_r_count);
936: FND_File.Put_Line(Fnd_File.LOG,'wkcount' || l_r_worker_count);
937:
938:
939: FOR l_r_count in 1 .. l_r_worker_count

Line 936: FND_File.Put_Line(Fnd_File.LOG,'wkcount' || l_r_worker_count);

932: AND source_system_name = nvl(p_source_system_name,source_system_name)
933: AND parallel_worker_id = -1;
934:
935: FND_File.Put_Line(Fnd_File.LOG,'xrcount' || x_r_count);
936: FND_File.Put_Line(Fnd_File.LOG,'wkcount' || l_r_worker_count);
937:
938:
939: FOR l_r_count in 1 .. l_r_worker_count
940: LOOP

Line 942: FND_File.Put_Line(Fnd_File.LOG,'updating CIRI');

938:
939: FOR l_r_count in 1 .. l_r_worker_count
940: LOOP
941:
942: FND_File.Put_Line(Fnd_File.LOG,'updating CIRI');
943: UPDATE csi_ii_relation_interface
944: SET parallel_worker_id = l_r_count
945: WHERE ROWNUM <= x_r_count
946: AND parallel_worker_id = -1

Line 953: FND_File.Put_Line(Fnd_File.LOG,'Before calling csi_ml_util_pvt.resolve_rel_ids');

949: COMMIT;
950: END LOOP;
951:
952: IF(l_debug_level>1) THEN
953: FND_File.Put_Line(Fnd_File.LOG,'Before calling csi_ml_util_pvt.resolve_rel_ids');
954: END IF;
955: -- To resolve id columns
956: csi_ml_util_pvt.resolve_rel_ids
957: (p_source_system => p_source_system_name

Line 964: FND_File.Put_Line(Fnd_File.LOG,'After calling csi_ml_util_pvt.resolve_rel_ids');

960: ,x_return_status => l_return_status
961: ,x_error_message => l_error_message
962: );
963: IF(l_debug_level>1) THEN
964: FND_File.Put_Line(Fnd_File.LOG,'After calling csi_ml_util_pvt.resolve_rel_ids');
965: END IF;
966:
967: csi_ml_util_pvt.eliminate_dup_records;
968: csi_ml_util_pvt.eliminate_dup_subject;

Line 983: FND_File.Put_Line(Fnd_File.LOG,'Before submitting request for relationships: ');

979: THEN
980: FOR l_count in 1..l_r_worker_count
981: LOOP
982: IF(l_debug_level>1) THEN
983: FND_File.Put_Line(Fnd_File.LOG,'Before submitting request for relationships: ');
984: FND_File.Put_Line(Fnd_File.LOG,'Start time in validate mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
985: END IF;
986: l_request_id := FND_REQUEST.SUBMIT_REQUEST
987: ( 'CSI'

Line 984: FND_File.Put_Line(Fnd_File.LOG,'Start time in validate mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));

980: FOR l_count in 1..l_r_worker_count
981: LOOP
982: IF(l_debug_level>1) THEN
983: FND_File.Put_Line(Fnd_File.LOG,'Before submitting request for relationships: ');
984: FND_File.Put_Line(Fnd_File.LOG,'Start time in validate mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
985: END IF;
986: l_request_id := FND_REQUEST.SUBMIT_REQUEST
987: ( 'CSI'
988: ,'CSIMCREL'

Line 999: FND_File.Put_Line(Fnd_File.LOG,'End time in validate mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));

995: ,p_txn_to_date
996: ,p_source_system_name
997: );
998: IF(l_debug_level>1) THEN
999: FND_File.Put_Line(Fnd_File.LOG,'End time in validate mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1000: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
1001: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
1002: FND_File.Put_Line(Fnd_File.LOG,'');
1003: END IF;

Line 1000: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');

996: ,p_source_system_name
997: );
998: IF(l_debug_level>1) THEN
999: FND_File.Put_Line(Fnd_File.LOG,'End time in validate mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1000: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
1001: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
1002: FND_File.Put_Line(Fnd_File.LOG,'');
1003: END IF;
1004:

Line 1001: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');

997: );
998: IF(l_debug_level>1) THEN
999: FND_File.Put_Line(Fnd_File.LOG,'End time in validate mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1000: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
1001: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
1002: FND_File.Put_Line(Fnd_File.LOG,'');
1003: END IF;
1004:
1005: IF (l_request_id = 0) THEN

Line 1002: FND_File.Put_Line(Fnd_File.LOG,'');

998: IF(l_debug_level>1) THEN
999: FND_File.Put_Line(Fnd_File.LOG,'End time in validate mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1000: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
1001: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
1002: FND_File.Put_Line(Fnd_File.LOG,'');
1003: END IF;
1004:
1005: IF (l_request_id = 0) THEN
1006: l_req_count:=l_req_count+1;

Line 1009: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));

1005: IF (l_request_id = 0) THEN
1006: l_req_count:=l_req_count+1;
1007: l_errbuf := FND_MESSAGE.GET;
1008: IF(l_debug_level>1) THEN
1009: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
1010: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
1011: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
1012: END IF;
1013: END IF;

Line 1010: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));

1006: l_req_count:=l_req_count+1;
1007: l_errbuf := FND_MESSAGE.GET;
1008: IF(l_debug_level>1) THEN
1009: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
1010: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
1011: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
1012: END IF;
1013: END IF;
1014: COMMIT;

Line 1011: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));

1007: l_errbuf := FND_MESSAGE.GET;
1008: IF(l_debug_level>1) THEN
1009: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
1010: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
1011: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
1012: END IF;
1013: END IF;
1014: COMMIT;
1015: END LOOP;

Line 1035: FND_File.Put_Line(Fnd_File.LOG,'Before submit request for l_valid_count <> 0: ');

1031:
1032: FOR l_count IN 1..l_r_worker_count
1033: LOOP
1034: IF(l_debug_level>1) THEN
1035: FND_File.Put_Line(Fnd_File.LOG,'Before submit request for l_valid_count <> 0: ');
1036: FND_File.Put_Line(Fnd_File.LOG,'Start time in update mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1037: END IF;
1038: l_request_id := FND_REQUEST.SUBMIT_REQUEST
1039: ( 'CSI'

Line 1036: FND_File.Put_Line(Fnd_File.LOG,'Start time in update mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));

1032: FOR l_count IN 1..l_r_worker_count
1033: LOOP
1034: IF(l_debug_level>1) THEN
1035: FND_File.Put_Line(Fnd_File.LOG,'Before submit request for l_valid_count <> 0: ');
1036: FND_File.Put_Line(Fnd_File.LOG,'Start time in update mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1037: END IF;
1038: l_request_id := FND_REQUEST.SUBMIT_REQUEST
1039: ( 'CSI'
1040: ,'CSIMCREL'

Line 1051: FND_File.Put_Line(Fnd_File.LOG,'End time in update mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));

1047: ,p_txn_to_date
1048: ,p_source_system_name
1049: );
1050: IF(l_debug_level>1) THEN
1051: FND_File.Put_Line(Fnd_File.LOG,'End time in update mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1052: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
1053: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
1054: FND_File.Put_Line(Fnd_File.LOG,'');
1055: END IF;

Line 1052: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');

1048: ,p_source_system_name
1049: );
1050: IF(l_debug_level>1) THEN
1051: FND_File.Put_Line(Fnd_File.LOG,'End time in update mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1052: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
1053: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
1054: FND_File.Put_Line(Fnd_File.LOG,'');
1055: END IF;
1056:

Line 1053: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');

1049: );
1050: IF(l_debug_level>1) THEN
1051: FND_File.Put_Line(Fnd_File.LOG,'End time in update mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1052: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
1053: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
1054: FND_File.Put_Line(Fnd_File.LOG,'');
1055: END IF;
1056:
1057: IF (l_request_id = 0) THEN

Line 1054: FND_File.Put_Line(Fnd_File.LOG,'');

1050: IF(l_debug_level>1) THEN
1051: FND_File.Put_Line(Fnd_File.LOG,'End time in update mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1052: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
1053: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
1054: FND_File.Put_Line(Fnd_File.LOG,'');
1055: END IF;
1056:
1057: IF (l_request_id = 0) THEN
1058: l_req_count:=l_req_count+1;

Line 1061: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));

1057: IF (l_request_id = 0) THEN
1058: l_req_count:=l_req_count+1;
1059: l_errbuf := FND_MESSAGE.GET;
1060: IF(l_debug_level>1) THEN
1061: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
1062: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
1063: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
1064: END IF;
1065: END IF;

Line 1062: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));

1058: l_req_count:=l_req_count+1;
1059: l_errbuf := FND_MESSAGE.GET;
1060: IF(l_debug_level>1) THEN
1061: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
1062: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
1063: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
1064: END IF;
1065: END IF;
1066: COMMIT;

Line 1063: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));

1059: l_errbuf := FND_MESSAGE.GET;
1060: IF(l_debug_level>1) THEN
1061: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
1062: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
1063: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
1064: END IF;
1065: END IF;
1066: COMMIT;
1067: END LOOP;

Line 1087: FND_File.Put_Line(Fnd_File.LOG,'Before submit request for l_update_count <> 0: ');

1083:
1084: FOR l_count IN 1..l_r_worker_count
1085: LOOP
1086: IF(l_debug_level>1) THEN
1087: FND_File.Put_Line(Fnd_File.LOG,'Before submit request for l_update_count <> 0: ');
1088: FND_File.Put_Line(Fnd_File.LOG,'Start time in update mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1089: END IF;
1090: l_request_id := FND_REQUEST.SUBMIT_REQUEST
1091: ( 'CSI'

Line 1088: FND_File.Put_Line(Fnd_File.LOG,'Start time in update mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));

1084: FOR l_count IN 1..l_r_worker_count
1085: LOOP
1086: IF(l_debug_level>1) THEN
1087: FND_File.Put_Line(Fnd_File.LOG,'Before submit request for l_update_count <> 0: ');
1088: FND_File.Put_Line(Fnd_File.LOG,'Start time in update mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1089: END IF;
1090: l_request_id := FND_REQUEST.SUBMIT_REQUEST
1091: ( 'CSI'
1092: ,'CSIMCREL'

Line 1103: FND_File.Put_Line(Fnd_File.LOG,'End time in update mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));

1099: ,p_txn_to_date
1100: ,p_source_system_name
1101: );
1102: IF(l_debug_level>1) THEN
1103: FND_File.Put_Line(Fnd_File.LOG,'End time in update mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1104: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
1105: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
1106: FND_File.Put_Line(Fnd_File.LOG,'');
1107: END IF;

Line 1104: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');

1100: ,p_source_system_name
1101: );
1102: IF(l_debug_level>1) THEN
1103: FND_File.Put_Line(Fnd_File.LOG,'End time in update mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1104: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
1105: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
1106: FND_File.Put_Line(Fnd_File.LOG,'');
1107: END IF;
1108:

Line 1105: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');

1101: );
1102: IF(l_debug_level>1) THEN
1103: FND_File.Put_Line(Fnd_File.LOG,'End time in update mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1104: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
1105: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
1106: FND_File.Put_Line(Fnd_File.LOG,'');
1107: END IF;
1108:
1109: IF (l_request_id = 0) THEN

Line 1106: FND_File.Put_Line(Fnd_File.LOG,'');

1102: IF(l_debug_level>1) THEN
1103: FND_File.Put_Line(Fnd_File.LOG,'End time in update mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1104: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
1105: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
1106: FND_File.Put_Line(Fnd_File.LOG,'');
1107: END IF;
1108:
1109: IF (l_request_id = 0) THEN
1110: l_req_count:=l_req_count+1;

Line 1113: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));

1109: IF (l_request_id = 0) THEN
1110: l_req_count:=l_req_count+1;
1111: l_errbuf := FND_MESSAGE.GET;
1112: IF(l_debug_level>1) THEN
1113: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
1114: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
1115: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
1116: END IF;
1117: END IF;

Line 1114: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));

1110: l_req_count:=l_req_count+1;
1111: l_errbuf := FND_MESSAGE.GET;
1112: IF(l_debug_level>1) THEN
1113: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
1114: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
1115: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
1116: END IF;
1117: END IF;
1118: COMMIT;

Line 1115: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));

1111: l_errbuf := FND_MESSAGE.GET;
1112: IF(l_debug_level>1) THEN
1113: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
1114: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
1115: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
1116: END IF;
1117: END IF;
1118: COMMIT;
1119: END LOOP;

Line 1139: FND_File.Put_Line(Fnd_File.LOG,'Before submit request for l_insert_count <> 0: ');

1135:
1136: FOR l_count in 1..l_r_worker_count
1137: LOOP
1138: IF(l_debug_level>1) THEN
1139: FND_File.Put_Line(Fnd_File.LOG,'Before submit request for l_insert_count <> 0: ');
1140: FND_File.Put_Line(Fnd_File.LOG,'Start time in insert mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1141: END IF;
1142: l_request_id := FND_REQUEST.SUBMIT_REQUEST
1143: ( 'CSI'

Line 1140: FND_File.Put_Line(Fnd_File.LOG,'Start time in insert mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));

1136: FOR l_count in 1..l_r_worker_count
1137: LOOP
1138: IF(l_debug_level>1) THEN
1139: FND_File.Put_Line(Fnd_File.LOG,'Before submit request for l_insert_count <> 0: ');
1140: FND_File.Put_Line(Fnd_File.LOG,'Start time in insert mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1141: END IF;
1142: l_request_id := FND_REQUEST.SUBMIT_REQUEST
1143: ( 'CSI'
1144: ,'CSIMCREL'

Line 1155: FND_File.Put_Line(Fnd_File.LOG,'End time in insert mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));

1151: ,p_txn_to_date
1152: ,p_source_system_name
1153: );
1154: IF(l_debug_level>1) THEN
1155: FND_File.Put_Line(Fnd_File.LOG,'End time in insert mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1156: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
1157: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
1158: FND_File.Put_Line(Fnd_File.LOG,'');
1159: END IF;

Line 1156: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');

1152: ,p_source_system_name
1153: );
1154: IF(l_debug_level>1) THEN
1155: FND_File.Put_Line(Fnd_File.LOG,'End time in insert mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1156: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
1157: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
1158: FND_File.Put_Line(Fnd_File.LOG,'');
1159: END IF;
1160:

Line 1157: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');

1153: );
1154: IF(l_debug_level>1) THEN
1155: FND_File.Put_Line(Fnd_File.LOG,'End time in insert mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1156: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
1157: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
1158: FND_File.Put_Line(Fnd_File.LOG,'');
1159: END IF;
1160:
1161: IF (l_request_id = 0) THEN

Line 1158: FND_File.Put_Line(Fnd_File.LOG,'');

1154: IF(l_debug_level>1) THEN
1155: FND_File.Put_Line(Fnd_File.LOG,'End time in insert mode: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
1156: FND_File.Put_Line(Fnd_File.LOG,'Calling Open Interface Parallel Relationship Creation Process');
1157: FND_File.Put_Line(Fnd_File.LOG,'Request ID: '||l_request_id||' has been submitted');
1158: FND_File.Put_Line(Fnd_File.LOG,'');
1159: END IF;
1160:
1161: IF (l_request_id = 0) THEN
1162: l_req_count:=l_req_count+1;

Line 1165: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));

1161: IF (l_request_id = 0) THEN
1162: l_req_count:=l_req_count+1;
1163: l_errbuf := FND_MESSAGE.GET;
1164: IF(l_debug_level>1) THEN
1165: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
1166: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
1167: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
1168: END IF;
1169: END IF;

Line 1166: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));

1162: l_req_count:=l_req_count+1;
1163: l_errbuf := FND_MESSAGE.GET;
1164: IF(l_debug_level>1) THEN
1165: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
1166: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
1167: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
1168: END IF;
1169: END IF;
1170: COMMIT;

Line 1167: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));

1163: l_errbuf := FND_MESSAGE.GET;
1164: IF(l_debug_level>1) THEN
1165: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,76,150));
1166: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,151,225));
1167: FND_File.Put_Line(Fnd_File.LOG,' :'||substr(l_errbuf,226,300));
1168: END IF;
1169: END IF;
1170: COMMIT;
1171: END LOOP;

Line 1195: FND_File.Put_Line(Fnd_File.LOG,'csi_ml_program_pub.execute_parallel_create -Into when others exception ' || SQLERRM);

1191:
1192: EXCEPTION
1193:
1194: WHEN others THEN
1195: FND_File.Put_Line(Fnd_File.LOG,'csi_ml_program_pub.execute_parallel_create -Into when others exception ' || SQLERRM);
1196: l_sql_error := SQLERRM;
1197: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1198: fnd_message.set_token('API_NAME',l_api_name);
1199: fnd_message.set_token('SQL_ERROR',SQLERRM);