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.GMF_API_WRP dependencies on DBMS_OUTPUT

Line 161: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

157:
158: /********************************************************
159: * Loop thru flat file and call Inventory Quantities API *
160: ********************************************************/
161: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
162: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
163: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
164: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
165: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 162: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

158: /********************************************************
159: * Loop thru flat file and call Inventory Quantities API *
160: ********************************************************/
161: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
162: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
163: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
164: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
165: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
166: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 163: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

159: * Loop thru flat file and call Inventory Quantities API *
160: ********************************************************/
161: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
162: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
163: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
164: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
165: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
166: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
167: UTL_FILE.NEW_LINE(l_log_handle);

Line 164: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

160: ********************************************************/
161: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
162: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
163: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
164: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
165: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
166: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
167: UTL_FILE.NEW_LINE(l_log_handle);
168: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );

Line 165: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

161: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
162: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
163: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
164: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
165: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
166: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
167: UTL_FILE.NEW_LINE(l_log_handle);
168: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
169: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );

Line 340: -- DBMS_OUTPUT.PUT_LINE('Check to call Create_Item_Cost API...type - ' || l_type || ' count = ' || l_record_count);

336: goto GET_MSG_STACK ;
337: END IF ;
338: END;
339:
340: -- DBMS_OUTPUT.PUT_LINE('Check to call Create_Item_Cost API...type - ' || l_type || ' count = ' || l_record_count);
341: IF (l_type = '10' AND l_record_count <> 1 AND l_skip_details = 'N') THEN
342: -- DBMS_OUTPUT.PUT_LINE('Calling Create_Item_Cost API...');
343: GMF_ItemCost_PUB.Create_Item_Cost
344: (

Line 342: -- DBMS_OUTPUT.PUT_LINE('Calling Create_Item_Cost API...');

338: END;
339:
340: -- DBMS_OUTPUT.PUT_LINE('Check to call Create_Item_Cost API...type - ' || l_type || ' count = ' || l_record_count);
341: IF (l_type = '10' AND l_record_count <> 1 AND l_skip_details = 'N') THEN
342: -- DBMS_OUTPUT.PUT_LINE('Calling Create_Item_Cost API...');
343: GMF_ItemCost_PUB.Create_Item_Cost
344: (
345: p_api_version => 3.0,
346: p_init_msg_list => FND_API.G_TRUE,

Line 377: -- DBMS_OUTPUT.PUT_LINE(l_data );

373: p_encoded => FND_API.G_FALSE,
374: p_msg_index_out => l_dummy_cnt
375: );
376:
377: -- DBMS_OUTPUT.PUT_LINE(l_data );
378: --UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
379: --UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
380: --UTL_FILE.NEW_LINE(l_outfile_handle);
381: UTL_FILE.PUT_LINE(l_log_handle, l_data);

Line 400: -- DBMS_OUTPUT.PUT_LINE('# of CostIds inserted : ' || l_costcmpnt_ids.count);

396: END IF;
397: END LOOP;
398: l_count := 0 ;
399: END IF;
400: -- DBMS_OUTPUT.PUT_LINE('# of CostIds inserted : ' || l_costcmpnt_ids.count);
401: FOR i in 1..l_costcmpnt_ids.count
402: LOOP
403: UTL_FILE.PUT_LINE(l_log_handle, ' CmpntClsId : ' || l_costcmpnt_ids(i).cost_cmpntcls_id ||
404: ' Analysis Code : ' || l_costcmpnt_ids(i).cost_analysis_code ||

Line 412: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

408: IF l_continue = 'N' THEN
409: EXIT ;
410: END IF ;
411: END LOOP;
412: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
413: UTL_FILE.NEW_LINE(l_log_handle);
414: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
415: UTL_FILE.FCLOSE_ALL;
416:

Line 420: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);

416:
417: RETURN l_return_status;
418: EXCEPTION
419: WHEN UTL_FILE.INVALID_OPERATION THEN
420: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);
421: UTL_FILE.FCLOSE_ALL;
422: RETURN l_return_status;
423: WHEN UTL_FILE.INVALID_PATH THEN
424: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);

Line 424: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);

420: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);
421: UTL_FILE.FCLOSE_ALL;
422: RETURN l_return_status;
423: WHEN UTL_FILE.INVALID_PATH THEN
424: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);
425: UTL_FILE.FCLOSE_ALL;
426: RETURN l_return_status;
427: WHEN UTL_FILE.INVALID_MODE THEN
428: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);

Line 428: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);

424: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);
425: UTL_FILE.FCLOSE_ALL;
426: RETURN l_return_status;
427: WHEN UTL_FILE.INVALID_MODE THEN
428: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);
429: UTL_FILE.FCLOSE_ALL;
430: RETURN l_return_status;
431: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
432: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);

Line 432: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);

428: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);
429: UTL_FILE.FCLOSE_ALL;
430: RETURN l_return_status;
431: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
432: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);
433: UTL_FILE.FCLOSE_ALL;
434: RETURN l_return_status;
435: WHEN UTL_FILE.WRITE_ERROR THEN
436: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);

Line 436: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);

432: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);
433: UTL_FILE.FCLOSE_ALL;
434: RETURN l_return_status;
435: WHEN UTL_FILE.WRITE_ERROR THEN
436: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);
437: UTL_FILE.FCLOSE_ALL;
438: RETURN l_return_status;
439: WHEN UTL_FILE.READ_ERROR THEN
440: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);

Line 440: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);

436: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);
437: UTL_FILE.FCLOSE_ALL;
438: RETURN l_return_status;
439: WHEN UTL_FILE.READ_ERROR THEN
440: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);
441: UTL_FILE.FCLOSE_ALL;
442: RETURN l_return_status;
443: WHEN UTL_FILE.INTERNAL_ERROR THEN
444: -- DBMS_OUTPUT.PUT_LINE('Internal Error');

Line 444: -- DBMS_OUTPUT.PUT_LINE('Internal Error');

440: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);
441: UTL_FILE.FCLOSE_ALL;
442: RETURN l_return_status;
443: WHEN UTL_FILE.INTERNAL_ERROR THEN
444: -- DBMS_OUTPUT.PUT_LINE('Internal Error');
445: UTL_FILE.FCLOSE_ALL;
446: RETURN l_return_status;
447: WHEN OTHERS THEN
448: -- DBMS_OUTPUT.PUT_LINE('Other Error');

Line 448: -- DBMS_OUTPUT.PUT_LINE('Other Error');

444: -- DBMS_OUTPUT.PUT_LINE('Internal Error');
445: UTL_FILE.FCLOSE_ALL;
446: RETURN l_return_status;
447: WHEN OTHERS THEN
448: -- DBMS_OUTPUT.PUT_LINE('Other Error');
449: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
450: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
451: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
452: UTL_FILE.FCLOSE_ALL;

Line 584: /* DBMS_OUTPUT.ENABLE(1000000); */

580: BEGIN
581: /********************
582: * Enable The Buffer *
583: ********************/
584: /* DBMS_OUTPUT.ENABLE(1000000); */
585: -- DBMS_OUTPUT.PUT_LINE('in Update_Item_Cost function...');
586: l_p_dir := p_dir;
587: l_input_file := p_input_file;
588: l_output_file := p_output_file;

Line 585: -- DBMS_OUTPUT.PUT_LINE('in Update_Item_Cost function...');

581: /********************
582: * Enable The Buffer *
583: ********************/
584: /* DBMS_OUTPUT.ENABLE(1000000); */
585: -- DBMS_OUTPUT.PUT_LINE('in Update_Item_Cost function...');
586: l_p_dir := p_dir;
587: l_input_file := p_input_file;
588: l_output_file := p_output_file;
589: l_delimiter := p_delimiter;

Line 613: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

609:
610: /********************************************************
611: * Loop thru flat file and call Inventory Quantities API *
612: ********************************************************/
613: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
614: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
615: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
616: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
617: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 614: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

610: /********************************************************
611: * Loop thru flat file and call Inventory Quantities API *
612: ********************************************************/
613: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
614: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
615: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
616: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
617: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
618: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

Line 615: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

611: * Loop thru flat file and call Inventory Quantities API *
612: ********************************************************/
613: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
614: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
615: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
616: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
617: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
618: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
619: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 616: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

612: ********************************************************/
613: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
614: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
615: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
616: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
617: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
618: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
619: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
620: UTL_FILE.NEW_LINE(l_log_handle);

Line 617: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

613: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
614: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
615: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
616: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
617: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
618: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
619: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
620: UTL_FILE.NEW_LINE(l_log_handle);
621: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );

Line 618: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

614: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
615: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
616: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
617: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
618: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
619: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
620: UTL_FILE.NEW_LINE(l_log_handle);
621: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
622: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );

Line 641: DBMS_OUTPUT.PUT_LINE('firt record of type = ' || l_type);

637: UTL_FILE.NEW_LINE(l_log_handle);
638: UTL_FILE.PUT_LINE(l_log_handle, 'Reading Record...' || l_record_count );
639: l_type := Get_Field(l_line,l_delimiter,1) ; -- 10 : header rec, 20 : this level, 30 : lower level
640: UTL_FILE.PUT_LINE(l_log_handle, 'Type = ' || l_type) ;
641: DBMS_OUTPUT.PUT_LINE('firt record of type = ' || l_type);
642: */
643: LOOP
644: BEGIN
645: UTL_FILE.PUT_LINE(l_log_handle, '--');

Line 668: -- DBMS_OUTPUT.PUT_LINE('in wrapper. l_this_lvl_tbl count : ' || l_this_lvl_tbl.count) ;

664: l_header_rec.item_number := Get_Field(l_line,l_delimiter,10) ;
665: l_header_rec.user_name := Get_Field(l_line,l_delimiter,11) ;
666: l_idx := 0 ;
667: l_idx1 := 0 ;
668: -- DBMS_OUTPUT.PUT_LINE('in wrapper. l_this_lvl_tbl count : ' || l_this_lvl_tbl.count) ;
669: -- DBMS_OUTPUT.PUT_LINE('in wrapper. l_lower_lvl_tbl count : ' || l_lower_lvl_tbl.count) ;
670: -- DBMS_OUTPUT.PUT_LINE('calendar_code = ' || l_header_rec.calendar_code) ;
671: /*
672: UTL_FILE.PUT_LINE(l_log_handle, 'Type = ' || l_type) ;

Line 669: -- DBMS_OUTPUT.PUT_LINE('in wrapper. l_lower_lvl_tbl count : ' || l_lower_lvl_tbl.count) ;

665: l_header_rec.user_name := Get_Field(l_line,l_delimiter,11) ;
666: l_idx := 0 ;
667: l_idx1 := 0 ;
668: -- DBMS_OUTPUT.PUT_LINE('in wrapper. l_this_lvl_tbl count : ' || l_this_lvl_tbl.count) ;
669: -- DBMS_OUTPUT.PUT_LINE('in wrapper. l_lower_lvl_tbl count : ' || l_lower_lvl_tbl.count) ;
670: -- DBMS_OUTPUT.PUT_LINE('calendar_code = ' || l_header_rec.calendar_code) ;
671: /*
672: UTL_FILE.PUT_LINE(l_log_handle, 'Type = ' || l_type) ;
673: UTL_FILE.PUT_LINE(l_log_handle, 'calendar_code = ' || l_header_rec.calendar_code) ;

Line 670: -- DBMS_OUTPUT.PUT_LINE('calendar_code = ' || l_header_rec.calendar_code) ;

666: l_idx := 0 ;
667: l_idx1 := 0 ;
668: -- DBMS_OUTPUT.PUT_LINE('in wrapper. l_this_lvl_tbl count : ' || l_this_lvl_tbl.count) ;
669: -- DBMS_OUTPUT.PUT_LINE('in wrapper. l_lower_lvl_tbl count : ' || l_lower_lvl_tbl.count) ;
670: -- DBMS_OUTPUT.PUT_LINE('calendar_code = ' || l_header_rec.calendar_code) ;
671: /*
672: UTL_FILE.PUT_LINE(l_log_handle, 'Type = ' || l_type) ;
673: UTL_FILE.PUT_LINE(l_log_handle, 'calendar_code = ' || l_header_rec.calendar_code) ;
674: UTL_FILE.PUT_LINE(l_log_handle, 'period_code = ' || l_header_rec.period_code) ;

Line 785: -- DBMS_OUTPUT.PUT_LINE('In exception. Calling Update_Item_Cost API...');

781: --UTL_FILE.PUT_LINE(l_log_handle, 'Type = ' || l_type) ;
782: EXCEPTION
783: WHEN NO_DATA_FOUND THEN
784: IF l_skip_details = 'N' THEN
785: -- DBMS_OUTPUT.PUT_LINE('In exception. Calling Update_Item_Cost API...');
786: GMF_ItemCost_PUB.Update_Item_Cost
787: (
788: p_api_version => 3.0,
789: p_init_msg_list => FND_API.G_TRUE,

Line 803: -- DBMS_OUTPUT.PUT_LINE('Check to call Update_Item_Cost API...type - ' || l_type || ' count = ' || l_record_count);

799: l_continue := 'N' ;
800: goto GET_MSG_STACK ;
801: END IF ;
802: END;
803: -- DBMS_OUTPUT.PUT_LINE('Check to call Update_Item_Cost API...type - ' || l_type || ' count = ' || l_record_count);
804: IF (l_type = '10' AND l_record_count <> 1 AND l_skip_details = 'N') THEN
805: -- DBMS_OUTPUT.PUT_LINE('Calling Update_Item_Cost API...');
806: GMF_ItemCost_PUB.Update_Item_Cost
807: (

Line 805: -- DBMS_OUTPUT.PUT_LINE('Calling Update_Item_Cost API...');

801: END IF ;
802: END;
803: -- DBMS_OUTPUT.PUT_LINE('Check to call Update_Item_Cost API...type - ' || l_type || ' count = ' || l_record_count);
804: IF (l_type = '10' AND l_record_count <> 1 AND l_skip_details = 'N') THEN
805: -- DBMS_OUTPUT.PUT_LINE('Calling Update_Item_Cost API...');
806: GMF_ItemCost_PUB.Update_Item_Cost
807: (
808: p_api_version => 3.0,
809: p_init_msg_list => FND_API.G_TRUE,

Line 836: -- DBMS_OUTPUT.PUT_LINE(l_data );

832: p_data => l_data,
833: p_encoded => FND_API.G_FALSE,
834: p_msg_index_out => l_dummy_cnt
835: );
836: -- DBMS_OUTPUT.PUT_LINE(l_data );
837: --UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
838: --UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
839: --UTL_FILE.NEW_LINE(l_outfile_handle);
840: UTL_FILE.PUT_LINE(l_log_handle, l_data);

Line 862: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

858: IF l_continue = 'N' THEN
859: EXIT ;
860: END IF ;
861: END LOOP;
862: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
863: UTL_FILE.NEW_LINE(l_log_handle);
864: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
865: UTL_FILE.FCLOSE_ALL;
866: RETURN l_return_status;

Line 869: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);

865: UTL_FILE.FCLOSE_ALL;
866: RETURN l_return_status;
867: EXCEPTION
868: WHEN UTL_FILE.INVALID_OPERATION THEN
869: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);
870: UTL_FILE.FCLOSE_ALL;
871: RETURN l_return_status;
872: WHEN UTL_FILE.INVALID_PATH THEN
873: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);

Line 873: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);

869: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);
870: UTL_FILE.FCLOSE_ALL;
871: RETURN l_return_status;
872: WHEN UTL_FILE.INVALID_PATH THEN
873: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);
874: UTL_FILE.FCLOSE_ALL;
875: RETURN l_return_status;
876: WHEN UTL_FILE.INVALID_MODE THEN
877: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);

Line 877: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);

873: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);
874: UTL_FILE.FCLOSE_ALL;
875: RETURN l_return_status;
876: WHEN UTL_FILE.INVALID_MODE THEN
877: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);
878: UTL_FILE.FCLOSE_ALL;
879: RETURN l_return_status;
880: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
881: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);

Line 881: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);

877: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);
878: UTL_FILE.FCLOSE_ALL;
879: RETURN l_return_status;
880: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
881: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);
882: UTL_FILE.FCLOSE_ALL;
883: RETURN l_return_status;
884: WHEN UTL_FILE.WRITE_ERROR THEN
885: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);

Line 885: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);

881: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);
882: UTL_FILE.FCLOSE_ALL;
883: RETURN l_return_status;
884: WHEN UTL_FILE.WRITE_ERROR THEN
885: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);
886: UTL_FILE.FCLOSE_ALL;
887: RETURN l_return_status;
888: WHEN UTL_FILE.READ_ERROR THEN
889: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);

Line 889: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);

885: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);
886: UTL_FILE.FCLOSE_ALL;
887: RETURN l_return_status;
888: WHEN UTL_FILE.READ_ERROR THEN
889: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);
890: UTL_FILE.FCLOSE_ALL;
891: RETURN l_return_status;
892: WHEN UTL_FILE.INTERNAL_ERROR THEN
893: -- DBMS_OUTPUT.PUT_LINE('Internal Error');

Line 893: -- DBMS_OUTPUT.PUT_LINE('Internal Error');

889: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);
890: UTL_FILE.FCLOSE_ALL;
891: RETURN l_return_status;
892: WHEN UTL_FILE.INTERNAL_ERROR THEN
893: -- DBMS_OUTPUT.PUT_LINE('Internal Error');
894: UTL_FILE.FCLOSE_ALL;
895: RETURN l_return_status;
896: WHEN OTHERS THEN
897: -- DBMS_OUTPUT.PUT_LINE('Other Error');

Line 897: -- DBMS_OUTPUT.PUT_LINE('Other Error');

893: -- DBMS_OUTPUT.PUT_LINE('Internal Error');
894: UTL_FILE.FCLOSE_ALL;
895: RETURN l_return_status;
896: WHEN OTHERS THEN
897: -- DBMS_OUTPUT.PUT_LINE('Other Error');
898: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
899: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
900: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
901: UTL_FILE.FCLOSE_ALL;

Line 1031: /* DBMS_OUTPUT.ENABLE(1000000); */

1027: BEGIN
1028: /********************
1029: * Enable The Buffer *
1030: ********************/
1031: /* DBMS_OUTPUT.ENABLE(1000000); */
1032: -- DBMS_OUTPUT.PUT_LINE('in Delete_Item_Cost function...');
1033: l_p_dir := p_dir;
1034: l_input_file := p_input_file;
1035: l_output_file := p_output_file;

Line 1032: -- DBMS_OUTPUT.PUT_LINE('in Delete_Item_Cost function...');

1028: /********************
1029: * Enable The Buffer *
1030: ********************/
1031: /* DBMS_OUTPUT.ENABLE(1000000); */
1032: -- DBMS_OUTPUT.PUT_LINE('in Delete_Item_Cost function...');
1033: l_p_dir := p_dir;
1034: l_input_file := p_input_file;
1035: l_output_file := p_output_file;
1036: l_delimiter := p_delimiter;

Line 1060: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

1056:
1057: /********************************************************
1058: * Loop thru flat file and call Inventory Quantities API *
1059: ********************************************************/
1060: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1061: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1062: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1063: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1064: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 1061: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

1057: /********************************************************
1058: * Loop thru flat file and call Inventory Quantities API *
1059: ********************************************************/
1060: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1061: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1062: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1063: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1064: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
1065: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

Line 1062: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

1058: * Loop thru flat file and call Inventory Quantities API *
1059: ********************************************************/
1060: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1061: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1062: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1063: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1064: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
1065: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
1066: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 1063: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

1059: ********************************************************/
1060: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1061: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1062: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1063: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1064: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
1065: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
1066: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1067: UTL_FILE.NEW_LINE(l_log_handle);

Line 1064: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

1060: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1061: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1062: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1063: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1064: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
1065: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
1066: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1067: UTL_FILE.NEW_LINE(l_log_handle);
1068: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );

Line 1065: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

1061: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1062: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1063: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1064: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
1065: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
1066: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1067: UTL_FILE.NEW_LINE(l_log_handle);
1068: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
1069: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );

Line 1108: -- DBMS_OUTPUT.PUT_LINE('in wrapper. l_this_lvl_tbl count : ' || l_this_lvl_tbl.count) ;

1104: l_header_rec.item_number := Get_Field(l_line,l_delimiter,10) ;
1105: l_header_rec.user_name := Get_Field(l_line,l_delimiter,11) ;
1106: l_idx := 0 ;
1107: l_idx1 := 0 ;
1108: -- DBMS_OUTPUT.PUT_LINE('in wrapper. l_this_lvl_tbl count : ' || l_this_lvl_tbl.count) ;
1109: -- DBMS_OUTPUT.PUT_LINE('in wrapper. l_lower_lvl_tbl count : ' || l_lower_lvl_tbl.count) ;
1110: -- DBMS_OUTPUT.PUT_LINE('calendar_code = ' || l_header_rec.calendar_code) ;
1111: /*
1112: UTL_FILE.PUT_LINE(l_log_handle, 'Type = ' || l_type) ;

Line 1109: -- DBMS_OUTPUT.PUT_LINE('in wrapper. l_lower_lvl_tbl count : ' || l_lower_lvl_tbl.count) ;

1105: l_header_rec.user_name := Get_Field(l_line,l_delimiter,11) ;
1106: l_idx := 0 ;
1107: l_idx1 := 0 ;
1108: -- DBMS_OUTPUT.PUT_LINE('in wrapper. l_this_lvl_tbl count : ' || l_this_lvl_tbl.count) ;
1109: -- DBMS_OUTPUT.PUT_LINE('in wrapper. l_lower_lvl_tbl count : ' || l_lower_lvl_tbl.count) ;
1110: -- DBMS_OUTPUT.PUT_LINE('calendar_code = ' || l_header_rec.calendar_code) ;
1111: /*
1112: UTL_FILE.PUT_LINE(l_log_handle, 'Type = ' || l_type) ;
1113: UTL_FILE.PUT_LINE(l_log_handle, 'calendar_code = ' || l_header_rec.calendar_code) ;

Line 1110: -- DBMS_OUTPUT.PUT_LINE('calendar_code = ' || l_header_rec.calendar_code) ;

1106: l_idx := 0 ;
1107: l_idx1 := 0 ;
1108: -- DBMS_OUTPUT.PUT_LINE('in wrapper. l_this_lvl_tbl count : ' || l_this_lvl_tbl.count) ;
1109: -- DBMS_OUTPUT.PUT_LINE('in wrapper. l_lower_lvl_tbl count : ' || l_lower_lvl_tbl.count) ;
1110: -- DBMS_OUTPUT.PUT_LINE('calendar_code = ' || l_header_rec.calendar_code) ;
1111: /*
1112: UTL_FILE.PUT_LINE(l_log_handle, 'Type = ' || l_type) ;
1113: UTL_FILE.PUT_LINE(l_log_handle, 'calendar_code = ' || l_header_rec.calendar_code) ;
1114: UTL_FILE.PUT_LINE(l_log_handle, 'period_code = ' || l_header_rec.period_code) ;

Line 1225: -- DBMS_OUTPUT.PUT_LINE('In exception. Calling Delete_Item_Cost API...');

1221: --UTL_FILE.PUT_LINE(l_log_handle, 'Type = ' || l_type) ;
1222: EXCEPTION
1223: WHEN NO_DATA_FOUND THEN
1224: IF l_skip_details = 'N' THEN
1225: -- DBMS_OUTPUT.PUT_LINE('In exception. Calling Delete_Item_Cost API...');
1226: GMF_ItemCost_PUB.Delete_Item_Cost
1227: (
1228: p_api_version => 3.0,
1229: p_init_msg_list => FND_API.G_TRUE,

Line 1243: -- DBMS_OUTPUT.PUT_LINE('Check to call Delete_Item_Cost API...type - ' || l_type || ' count = ' || l_record_count);

1239: l_continue := 'N' ;
1240: GOTO GET_MSG_STACK ;
1241: END IF ;
1242: END;
1243: -- DBMS_OUTPUT.PUT_LINE('Check to call Delete_Item_Cost API...type - ' || l_type || ' count = ' || l_record_count);
1244: IF (l_type = '10' AND l_record_count <> 1 AND l_skip_details = 'N') THEN
1245: -- DBMS_OUTPUT.PUT_LINE('Calling Delete_Item_Cost API...');
1246: GMF_ItemCost_PUB.Delete_Item_Cost
1247: (

Line 1245: -- DBMS_OUTPUT.PUT_LINE('Calling Delete_Item_Cost API...');

1241: END IF ;
1242: END;
1243: -- DBMS_OUTPUT.PUT_LINE('Check to call Delete_Item_Cost API...type - ' || l_type || ' count = ' || l_record_count);
1244: IF (l_type = '10' AND l_record_count <> 1 AND l_skip_details = 'N') THEN
1245: -- DBMS_OUTPUT.PUT_LINE('Calling Delete_Item_Cost API...');
1246: GMF_ItemCost_PUB.Delete_Item_Cost
1247: (
1248: p_api_version => 3.0,
1249: p_init_msg_list => FND_API.G_TRUE,

Line 1276: -- DBMS_OUTPUT.PUT_LINE(l_data );

1272: p_data => l_data,
1273: p_encoded => FND_API.G_FALSE,
1274: p_msg_index_out => l_dummy_cnt
1275: );
1276: -- DBMS_OUTPUT.PUT_LINE(l_data );
1277: --UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
1278: --UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
1279: --UTL_FILE.NEW_LINE(l_outfile_handle);
1280: UTL_FILE.PUT_LINE(l_log_handle, l_data);

Line 1303: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

1299: IF l_continue = 'N' THEN
1300: EXIT ;
1301: END IF ;
1302: END LOOP;
1303: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1304: UTL_FILE.NEW_LINE(l_log_handle);
1305: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1306: UTL_FILE.FCLOSE_ALL;
1307: RETURN l_return_status;

Line 1310: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);

1306: UTL_FILE.FCLOSE_ALL;
1307: RETURN l_return_status;
1308: EXCEPTION
1309: WHEN UTL_FILE.INVALID_OPERATION THEN
1310: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);
1311: UTL_FILE.FCLOSE_ALL;
1312: RETURN l_return_status;
1313: WHEN UTL_FILE.INVALID_PATH THEN
1314: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);

Line 1314: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);

1310: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);
1311: UTL_FILE.FCLOSE_ALL;
1312: RETURN l_return_status;
1313: WHEN UTL_FILE.INVALID_PATH THEN
1314: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);
1315: UTL_FILE.FCLOSE_ALL;
1316: RETURN l_return_status;
1317: WHEN UTL_FILE.INVALID_MODE THEN
1318: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);

Line 1318: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);

1314: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);
1315: UTL_FILE.FCLOSE_ALL;
1316: RETURN l_return_status;
1317: WHEN UTL_FILE.INVALID_MODE THEN
1318: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);
1319: UTL_FILE.FCLOSE_ALL;
1320: RETURN l_return_status;
1321: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
1322: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);

Line 1322: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);

1318: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);
1319: UTL_FILE.FCLOSE_ALL;
1320: RETURN l_return_status;
1321: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
1322: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);
1323: UTL_FILE.FCLOSE_ALL;
1324: RETURN l_return_status;
1325: WHEN UTL_FILE.WRITE_ERROR THEN
1326: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);

Line 1326: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);

1322: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);
1323: UTL_FILE.FCLOSE_ALL;
1324: RETURN l_return_status;
1325: WHEN UTL_FILE.WRITE_ERROR THEN
1326: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);
1327: UTL_FILE.FCLOSE_ALL;
1328: RETURN l_return_status;
1329: WHEN UTL_FILE.READ_ERROR THEN
1330: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);

Line 1330: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);

1326: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);
1327: UTL_FILE.FCLOSE_ALL;
1328: RETURN l_return_status;
1329: WHEN UTL_FILE.READ_ERROR THEN
1330: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);
1331: UTL_FILE.FCLOSE_ALL;
1332: RETURN l_return_status;
1333: WHEN UTL_FILE.INTERNAL_ERROR THEN
1334: -- DBMS_OUTPUT.PUT_LINE('Internal Error');

Line 1334: -- DBMS_OUTPUT.PUT_LINE('Internal Error');

1330: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);
1331: UTL_FILE.FCLOSE_ALL;
1332: RETURN l_return_status;
1333: WHEN UTL_FILE.INTERNAL_ERROR THEN
1334: -- DBMS_OUTPUT.PUT_LINE('Internal Error');
1335: UTL_FILE.FCLOSE_ALL;
1336: RETURN l_return_status;
1337: WHEN OTHERS THEN
1338: -- DBMS_OUTPUT.PUT_LINE('Other Error');

Line 1338: -- DBMS_OUTPUT.PUT_LINE('Other Error');

1334: -- DBMS_OUTPUT.PUT_LINE('Internal Error');
1335: UTL_FILE.FCLOSE_ALL;
1336: RETURN l_return_status;
1337: WHEN OTHERS THEN
1338: -- DBMS_OUTPUT.PUT_LINE('Other Error');
1339: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
1340: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
1341: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1342: UTL_FILE.FCLOSE_ALL;

Line 1474: /* DBMS_OUTPUT.ENABLE(1000000); */

1470: BEGIN
1471: /********************
1472: * Enable The Buffer *
1473: ********************/
1474: /* DBMS_OUTPUT.ENABLE(1000000); */
1475: -- DBMS_OUTPUT.PUT_LINE('in Get_Item_Cost function...');
1476: l_p_dir := p_dir;
1477: l_input_file := p_input_file;
1478: l_output_file := p_output_file;

Line 1475: -- DBMS_OUTPUT.PUT_LINE('in Get_Item_Cost function...');

1471: /********************
1472: * Enable The Buffer *
1473: ********************/
1474: /* DBMS_OUTPUT.ENABLE(1000000); */
1475: -- DBMS_OUTPUT.PUT_LINE('in Get_Item_Cost function...');
1476: l_p_dir := p_dir;
1477: l_input_file := p_input_file;
1478: l_output_file := p_output_file;
1479: l_delimiter := p_delimiter;

Line 1501: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

1497: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
1498: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
1499:
1500: /* Loop thru flat file and call Inventory Quantities API */
1501: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1502: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1503: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1504: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1505: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 1502: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

1498: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
1499:
1500: /* Loop thru flat file and call Inventory Quantities API */
1501: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1502: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1503: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1504: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1505: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
1506: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

Line 1503: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

1499:
1500: /* Loop thru flat file and call Inventory Quantities API */
1501: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1502: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1503: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1504: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1505: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
1506: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
1507: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 1504: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

1500: /* Loop thru flat file and call Inventory Quantities API */
1501: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1502: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1503: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1504: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1505: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
1506: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
1507: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1508: UTL_FILE.NEW_LINE(l_log_handle);

Line 1505: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

1501: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1502: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1503: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1504: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1505: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
1506: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
1507: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1508: UTL_FILE.NEW_LINE(l_log_handle);
1509: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );

Line 1506: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

1502: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1503: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1504: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1505: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
1506: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
1507: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1508: UTL_FILE.NEW_LINE(l_log_handle);
1509: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
1510: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );

Line 1545: -- DBMS_OUTPUT.PUT_LINE('Calling Get_Item_Cost API...');

1541: UTL_FILE.PUT_LINE(l_log_handle, 'Organization_code= ' || l_header_rec.organization_code) ;
1542: UTL_FILE.PUT_LINE(l_log_handle, 'inventory_item_id= ' || l_header_rec.inventory_item_id) ;
1543: UTL_FILE.PUT_LINE(l_log_handle, 'item_number = ' || l_header_rec.item_number) ;
1544: UTL_FILE.PUT_LINE(l_log_handle, 'user_name = ' || l_header_rec.user_name) ;
1545: -- DBMS_OUTPUT.PUT_LINE('Calling Get_Item_Cost API...');
1546: GMF_ItemCost_PUB.Get_Item_Cost
1547: (
1548: p_api_version => 3.0,
1549: p_init_msg_list => FND_API.G_TRUE,

Line 1568: -- DBMS_OUTPUT.PUT_LINE(l_data );

1564: p_data => l_data,
1565: p_encoded => FND_API.G_FALSE,
1566: p_msg_index_out => l_dummy_cnt
1567: );
1568: -- DBMS_OUTPUT.PUT_LINE(l_data );
1569: --UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
1570: --UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
1571: --UTL_FILE.NEW_LINE(l_outfile_handle);
1572: UTL_FILE.PUT_LINE(l_log_handle, l_data);

Line 1615: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

1611: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
1612: l_return_status := 'U' ;
1613: END ;
1614: END LOOP;
1615: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1616: UTL_FILE.NEW_LINE(l_log_handle);
1617: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1618: UTL_FILE.FCLOSE_ALL;
1619: RETURN l_return_status;

Line 1622: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);

1618: UTL_FILE.FCLOSE_ALL;
1619: RETURN l_return_status;
1620: EXCEPTION
1621: WHEN UTL_FILE.INVALID_OPERATION THEN
1622: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);
1623: UTL_FILE.FCLOSE_ALL;
1624: RETURN l_return_status;
1625: WHEN UTL_FILE.INVALID_PATH THEN
1626: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);

Line 1626: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);

1622: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);
1623: UTL_FILE.FCLOSE_ALL;
1624: RETURN l_return_status;
1625: WHEN UTL_FILE.INVALID_PATH THEN
1626: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);
1627: UTL_FILE.FCLOSE_ALL;
1628: RETURN l_return_status;
1629: WHEN UTL_FILE.INVALID_MODE THEN
1630: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);

Line 1630: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);

1626: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);
1627: UTL_FILE.FCLOSE_ALL;
1628: RETURN l_return_status;
1629: WHEN UTL_FILE.INVALID_MODE THEN
1630: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);
1631: UTL_FILE.FCLOSE_ALL;
1632: RETURN l_return_status;
1633: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
1634: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);

Line 1634: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);

1630: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);
1631: UTL_FILE.FCLOSE_ALL;
1632: RETURN l_return_status;
1633: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
1634: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);
1635: UTL_FILE.FCLOSE_ALL;
1636: RETURN l_return_status;
1637: WHEN UTL_FILE.WRITE_ERROR THEN
1638: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);

Line 1638: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);

1634: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);
1635: UTL_FILE.FCLOSE_ALL;
1636: RETURN l_return_status;
1637: WHEN UTL_FILE.WRITE_ERROR THEN
1638: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);
1639: UTL_FILE.FCLOSE_ALL;
1640: RETURN l_return_status;
1641: WHEN UTL_FILE.READ_ERROR THEN
1642: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);

Line 1642: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);

1638: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);
1639: UTL_FILE.FCLOSE_ALL;
1640: RETURN l_return_status;
1641: WHEN UTL_FILE.READ_ERROR THEN
1642: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);
1643: UTL_FILE.FCLOSE_ALL;
1644: RETURN l_return_status;
1645: WHEN UTL_FILE.INTERNAL_ERROR THEN
1646: -- DBMS_OUTPUT.PUT_LINE('Internal Error');

Line 1646: -- DBMS_OUTPUT.PUT_LINE('Internal Error');

1642: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);
1643: UTL_FILE.FCLOSE_ALL;
1644: RETURN l_return_status;
1645: WHEN UTL_FILE.INTERNAL_ERROR THEN
1646: -- DBMS_OUTPUT.PUT_LINE('Internal Error');
1647: UTL_FILE.FCLOSE_ALL;
1648: RETURN l_return_status;
1649: WHEN OTHERS THEN
1650: -- DBMS_OUTPUT.PUT_LINE('Other Error');

Line 1650: -- DBMS_OUTPUT.PUT_LINE('Other Error');

1646: -- DBMS_OUTPUT.PUT_LINE('Internal Error');
1647: UTL_FILE.FCLOSE_ALL;
1648: RETURN l_return_status;
1649: WHEN OTHERS THEN
1650: -- DBMS_OUTPUT.PUT_LINE('Other Error');
1651: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
1652: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
1653: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1654: UTL_FILE.FCLOSE_ALL;

Line 1818: DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

1814: *****************************************************************/
1815: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
1816: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
1817: /*
1818: DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1819: DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1820: DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1821: DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1822: DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 1819: DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

1815: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
1816: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
1817: /*
1818: DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1819: DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1820: DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1821: DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1822: DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
1823: */

Line 1820: DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

1816: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
1817: /*
1818: DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1819: DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1820: DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1821: DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1822: DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
1823: */
1824:

Line 1821: DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

1817: /*
1818: DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1819: DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1820: DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1821: DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1822: DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
1823: */
1824:
1825: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 1822: DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

1818: DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1819: DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
1820: DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
1821: DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
1822: DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
1823: */
1824:
1825: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1826: UTL_FILE.NEW_LINE(l_log_handle);

Line 1955: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);

1951: UTL_FILE.FCLOSE_ALL;
1952: RETURN l_return_status;
1953: EXCEPTION
1954: WHEN UTL_FILE.INVALID_OPERATION THEN
1955: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);
1956: UTL_FILE.FCLOSE_ALL;
1957: RETURN l_return_status;
1958: WHEN UTL_FILE.INVALID_PATH THEN
1959: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);

Line 1959: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);

1955: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);
1956: UTL_FILE.FCLOSE_ALL;
1957: RETURN l_return_status;
1958: WHEN UTL_FILE.INVALID_PATH THEN
1959: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);
1960: UTL_FILE.FCLOSE_ALL;
1961: RETURN l_return_status;
1962: WHEN UTL_FILE.INVALID_MODE THEN
1963: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);

Line 1963: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);

1959: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);
1960: UTL_FILE.FCLOSE_ALL;
1961: RETURN l_return_status;
1962: WHEN UTL_FILE.INVALID_MODE THEN
1963: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);
1964: UTL_FILE.FCLOSE_ALL;
1965: RETURN l_return_status;
1966: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
1967: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);

Line 1967: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);

1963: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);
1964: UTL_FILE.FCLOSE_ALL;
1965: RETURN l_return_status;
1966: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
1967: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);
1968: UTL_FILE.FCLOSE_ALL;
1969: RETURN l_return_status;
1970: WHEN UTL_FILE.WRITE_ERROR THEN
1971: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);

Line 1971: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);

1967: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);
1968: UTL_FILE.FCLOSE_ALL;
1969: RETURN l_return_status;
1970: WHEN UTL_FILE.WRITE_ERROR THEN
1971: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);
1972: UTL_FILE.FCLOSE_ALL;
1973: RETURN l_return_status;
1974: WHEN UTL_FILE.READ_ERROR THEN
1975: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);

Line 1975: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);

1971: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);
1972: UTL_FILE.FCLOSE_ALL;
1973: RETURN l_return_status;
1974: WHEN UTL_FILE.READ_ERROR THEN
1975: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);
1976: UTL_FILE.FCLOSE_ALL;
1977: RETURN l_return_status;
1978: WHEN UTL_FILE.INTERNAL_ERROR THEN
1979: -- DBMS_OUTPUT.PUT_LINE('Internal Error');

Line 1979: -- DBMS_OUTPUT.PUT_LINE('Internal Error');

1975: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);
1976: UTL_FILE.FCLOSE_ALL;
1977: RETURN l_return_status;
1978: WHEN UTL_FILE.INTERNAL_ERROR THEN
1979: -- DBMS_OUTPUT.PUT_LINE('Internal Error');
1980: UTL_FILE.FCLOSE_ALL;
1981: RETURN l_return_status;
1982: WHEN OTHERS THEN
1983: -- DBMS_OUTPUT.PUT_LINE('Other Error');

Line 1983: -- DBMS_OUTPUT.PUT_LINE('Other Error');

1979: -- DBMS_OUTPUT.PUT_LINE('Internal Error');
1980: UTL_FILE.FCLOSE_ALL;
1981: RETURN l_return_status;
1982: WHEN OTHERS THEN
1983: -- DBMS_OUTPUT.PUT_LINE('Other Error');
1984: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
1985: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
1986: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
1987: UTL_FILE.FCLOSE_ALL;

Line 2166: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

2162: * Open The Wrapper File For Output And The Input File for Input *
2163: ****************************************************************/
2164: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
2165: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
2166: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2167: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
2168: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
2169: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2170: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 2167: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

2163: ****************************************************************/
2164: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
2165: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
2166: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2167: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
2168: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
2169: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2170: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
2171: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 2168: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

2164: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
2165: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
2166: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2167: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
2168: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
2169: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2170: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
2171: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2172: UTL_FILE.NEW_LINE(l_log_handle);

Line 2169: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

2165: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
2166: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2167: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
2168: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
2169: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2170: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
2171: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2172: UTL_FILE.NEW_LINE(l_log_handle);
2173: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );

Line 2170: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

2166: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2167: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
2168: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
2169: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2170: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
2171: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2172: UTL_FILE.NEW_LINE(l_log_handle);
2173: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
2174: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );

Line 2302: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);

2298: UTL_FILE.FCLOSE_ALL;
2299: RETURN l_return_status;
2300: EXCEPTION
2301: WHEN UTL_FILE.INVALID_OPERATION THEN
2302: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);
2303: UTL_FILE.FCLOSE_ALL;
2304: RETURN l_return_status;
2305: WHEN UTL_FILE.INVALID_PATH THEN
2306: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);

Line 2306: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);

2302: -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file);
2303: UTL_FILE.FCLOSE_ALL;
2304: RETURN l_return_status;
2305: WHEN UTL_FILE.INVALID_PATH THEN
2306: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);
2307: UTL_FILE.FCLOSE_ALL;
2308: RETURN l_return_status;
2309: WHEN UTL_FILE.INVALID_MODE THEN
2310: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);

Line 2310: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);

2306: -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file);
2307: UTL_FILE.FCLOSE_ALL;
2308: RETURN l_return_status;
2309: WHEN UTL_FILE.INVALID_MODE THEN
2310: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);
2311: UTL_FILE.FCLOSE_ALL;
2312: RETURN l_return_status;
2313: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
2314: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);

Line 2314: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);

2310: -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file);
2311: UTL_FILE.FCLOSE_ALL;
2312: RETURN l_return_status;
2313: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
2314: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);
2315: UTL_FILE.FCLOSE_ALL;
2316: RETURN l_return_status;
2317: WHEN UTL_FILE.WRITE_ERROR THEN
2318: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);

Line 2318: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);

2314: -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file);
2315: UTL_FILE.FCLOSE_ALL;
2316: RETURN l_return_status;
2317: WHEN UTL_FILE.WRITE_ERROR THEN
2318: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);
2319: UTL_FILE.FCLOSE_ALL;
2320: RETURN l_return_status;
2321: WHEN UTL_FILE.READ_ERROR THEN
2322: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);

Line 2322: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);

2318: -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file);
2319: UTL_FILE.FCLOSE_ALL;
2320: RETURN l_return_status;
2321: WHEN UTL_FILE.READ_ERROR THEN
2322: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);
2323: UTL_FILE.FCLOSE_ALL;
2324: RETURN l_return_status;
2325: WHEN UTL_FILE.INTERNAL_ERROR THEN
2326: -- DBMS_OUTPUT.PUT_LINE('Internal Error');

Line 2326: -- DBMS_OUTPUT.PUT_LINE('Internal Error');

2322: -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file);
2323: UTL_FILE.FCLOSE_ALL;
2324: RETURN l_return_status;
2325: WHEN UTL_FILE.INTERNAL_ERROR THEN
2326: -- DBMS_OUTPUT.PUT_LINE('Internal Error');
2327: UTL_FILE.FCLOSE_ALL;
2328: RETURN l_return_status;
2329: WHEN OTHERS THEN
2330: -- DBMS_OUTPUT.PUT_LINE('Other Error');

Line 2330: -- DBMS_OUTPUT.PUT_LINE('Other Error');

2326: -- DBMS_OUTPUT.PUT_LINE('Internal Error');
2327: UTL_FILE.FCLOSE_ALL;
2328: RETURN l_return_status;
2329: WHEN OTHERS THEN
2330: -- DBMS_OUTPUT.PUT_LINE('Other Error');
2331: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
2332: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
2333: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2334: UTL_FILE.FCLOSE_ALL;

Line 2384: ---- DBMS_OUTPUT.PUT_LINE('in Create_Alloc_Def procedure... ');

2380: l_return_status VARCHAR2(1);
2381:
2382: BEGIN
2383:
2384: ---- DBMS_OUTPUT.PUT_LINE('in Create_Alloc_Def procedure... ');
2385: l_return_status :=Create_Alloc_Def( p_dir
2386: , p_input_file
2387: , p_output_file
2388: , p_delimiter

Line 2391: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);

2387: , p_output_file
2388: , p_delimiter
2389: );
2390:
2391: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);
2392: End Create_Alloc_Def;
2393:
2394: /* +==========================================================================+
2395: | FUNCTION NAME |

Line 2464: /* DBMS_OUTPUT.ENABLE(1000000); */

2460:
2461: BEGIN
2462:
2463: /* Enable The Buffer */
2464: /* DBMS_OUTPUT.ENABLE(1000000); */
2465:
2466: -- DBMS_OUTPUT.PUT_LINE('in Create_Alloc_Def function...');
2467:
2468: l_p_dir :=p_dir;

Line 2466: -- DBMS_OUTPUT.PUT_LINE('in Create_Alloc_Def function...');

2462:
2463: /* Enable The Buffer */
2464: /* DBMS_OUTPUT.ENABLE(1000000); */
2465:
2466: -- DBMS_OUTPUT.PUT_LINE('in Create_Alloc_Def function...');
2467:
2468: l_p_dir :=p_dir;
2469: l_input_file :=p_input_file;
2470: l_output_file :=p_output_file;

Line 2491: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

2487: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
2488: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
2489:
2490: /* Loop thru flat file and call Inventory Quantities API */
2491: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2492: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
2493: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
2494: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2495: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 2492: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

2488: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
2489:
2490: /* Loop thru flat file and call Inventory Quantities API */
2491: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2492: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
2493: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
2494: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2495: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
2496:

Line 2493: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

2489:
2490: /* Loop thru flat file and call Inventory Quantities API */
2491: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2492: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
2493: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
2494: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2495: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
2496:
2497:

Line 2494: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

2490: /* Loop thru flat file and call Inventory Quantities API */
2491: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2492: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
2493: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
2494: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2495: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
2496:
2497:
2498: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

Line 2495: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

2491: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2492: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
2493: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
2494: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2495: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
2496:
2497:
2498: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
2499: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 2498: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

2494: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2495: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
2496:
2497:
2498: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
2499: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2500: UTL_FILE.NEW_LINE(l_log_handle);
2501: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
2502: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );

Line 2587: -- DBMS_OUTPUT.PUT_LINE(l_data );

2583: p_encoded => FND_API.G_FALSE,
2584: p_msg_index_out => l_dummy_cnt);
2585:
2586:
2587: -- DBMS_OUTPUT.PUT_LINE(l_data );
2588:
2589: UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
2590: UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
2591: UTL_FILE.NEW_LINE(l_outfile_handle);

Line 2633: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

2629: END ;
2630:
2631: END LOOP;
2632:
2633: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2634: UTL_FILE.NEW_LINE(l_log_handle);
2635: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2636:
2637: /* Check if any messages generated. If so then decode and */

Line 2646: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */

2642: RETURN l_return_status;
2643:
2644: EXCEPTION
2645: WHEN UTL_FILE.INVALID_OPERATION THEN
2646: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */
2647: UTL_FILE.FCLOSE_ALL;
2648: RETURN l_return_status;
2649:
2650: WHEN UTL_FILE.INVALID_PATH THEN

Line 2651: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */

2647: UTL_FILE.FCLOSE_ALL;
2648: RETURN l_return_status;
2649:
2650: WHEN UTL_FILE.INVALID_PATH THEN
2651: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */
2652: UTL_FILE.FCLOSE_ALL;
2653: RETURN l_return_status;
2654:
2655: WHEN UTL_FILE.INVALID_MODE THEN

Line 2656: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */

2652: UTL_FILE.FCLOSE_ALL;
2653: RETURN l_return_status;
2654:
2655: WHEN UTL_FILE.INVALID_MODE THEN
2656: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */
2657: UTL_FILE.FCLOSE_ALL;
2658: RETURN l_return_status;
2659:
2660: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 2661: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */

2657: UTL_FILE.FCLOSE_ALL;
2658: RETURN l_return_status;
2659:
2660: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
2661: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */
2662: UTL_FILE.FCLOSE_ALL;
2663: RETURN l_return_status;
2664:
2665: WHEN UTL_FILE.WRITE_ERROR THEN

Line 2666: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */

2662: UTL_FILE.FCLOSE_ALL;
2663: RETURN l_return_status;
2664:
2665: WHEN UTL_FILE.WRITE_ERROR THEN
2666: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */
2667: UTL_FILE.FCLOSE_ALL;
2668: RETURN l_return_status;
2669:
2670: WHEN UTL_FILE.READ_ERROR THEN

Line 2671: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */

2667: UTL_FILE.FCLOSE_ALL;
2668: RETURN l_return_status;
2669:
2670: WHEN UTL_FILE.READ_ERROR THEN
2671: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */
2672: UTL_FILE.FCLOSE_ALL;
2673: RETURN l_return_status;
2674:
2675: WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 2676: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */

2672: UTL_FILE.FCLOSE_ALL;
2673: RETURN l_return_status;
2674:
2675: WHEN UTL_FILE.INTERNAL_ERROR THEN
2676: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */
2677: UTL_FILE.FCLOSE_ALL;
2678: RETURN l_return_status;
2679:
2680: WHEN OTHERS THEN

Line 2681: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */

2677: UTL_FILE.FCLOSE_ALL;
2678: RETURN l_return_status;
2679:
2680: WHEN OTHERS THEN
2681: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */
2682: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
2683: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
2684: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2685: UTL_FILE.FCLOSE_ALL;

Line 2734: ---- DBMS_OUTPUT.PUT_LINE('in Update_Alloc_Def procedure... ');

2730: l_return_status VARCHAR2(1);
2731:
2732: BEGIN
2733:
2734: ---- DBMS_OUTPUT.PUT_LINE('in Update_Alloc_Def procedure... ');
2735: l_return_status :=Update_Alloc_Def( p_dir
2736: , p_input_file
2737: , p_output_file
2738: , p_delimiter

Line 2741: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);

2737: , p_output_file
2738: , p_delimiter
2739: );
2740:
2741: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);
2742: End Update_Alloc_Def;
2743:
2744: /* +==========================================================================+
2745: | FUNCTION NAME |

Line 2814: /* DBMS_OUTPUT.ENABLE(1000000); */

2810:
2811: BEGIN
2812:
2813: /* Enable The Buffer */
2814: /* DBMS_OUTPUT.ENABLE(1000000); */
2815:
2816: -- DBMS_OUTPUT.PUT_LINE('in Update_Alloc_Def function...');
2817:
2818: l_p_dir :=p_dir;

Line 2816: -- DBMS_OUTPUT.PUT_LINE('in Update_Alloc_Def function...');

2812:
2813: /* Enable The Buffer */
2814: /* DBMS_OUTPUT.ENABLE(1000000); */
2815:
2816: -- DBMS_OUTPUT.PUT_LINE('in Update_Alloc_Def function...');
2817:
2818: l_p_dir :=p_dir;
2819: l_input_file :=p_input_file;
2820: l_output_file :=p_output_file;

Line 2841: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

2837: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
2838: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
2839:
2840: /* Loop thru flat file and call Inventory Quantities API */
2841: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2842: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
2843: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
2844: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2845: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 2842: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

2838: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
2839:
2840: /* Loop thru flat file and call Inventory Quantities API */
2841: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2842: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
2843: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
2844: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2845: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
2846:

Line 2843: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

2839:
2840: /* Loop thru flat file and call Inventory Quantities API */
2841: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2842: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
2843: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
2844: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2845: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
2846:
2847:

Line 2844: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

2840: /* Loop thru flat file and call Inventory Quantities API */
2841: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2842: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
2843: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
2844: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2845: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
2846:
2847:
2848: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

Line 2845: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

2841: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2842: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
2843: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
2844: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2845: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
2846:
2847:
2848: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
2849: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 2848: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

2844: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
2845: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
2846:
2847:
2848: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
2849: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2850: UTL_FILE.NEW_LINE(l_log_handle);
2851: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
2852: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );

Line 2914: -- DBMS_OUTPUT.PUT_LINE('before calling Update API...');

2910: UTL_FILE.PUT_LINE(l_log_handle, 'organization_code = ' || alloc_rec.organization_code) ;
2911: UTL_FILE.PUT_LINE(l_log_handle, 'delete_mark = ' || alloc_rec.delete_mark) ;
2912: UTL_FILE.PUT_LINE(l_log_handle, 'user_name = ' || alloc_rec.user_name) ;
2913:
2914: -- DBMS_OUTPUT.PUT_LINE('before calling Update API...');
2915: GMF_ALLOCATIONDEFINITION_PUB.Update_Allocation_Definition
2916: ( p_api_version => 3.0
2917: , p_init_msg_list => FND_API.G_TRUE
2918: , p_commit => FND_API.G_TRUE

Line 2940: -- DBMS_OUTPUT.PUT_LINE(l_data );

2936: p_encoded => FND_API.G_FALSE,
2937: p_msg_index_out => l_dummy_cnt);
2938:
2939:
2940: -- DBMS_OUTPUT.PUT_LINE(l_data );
2941:
2942: UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
2943: UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
2944: UTL_FILE.NEW_LINE(l_outfile_handle);

Line 2986: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

2982: l_return_status := 'U' ;
2983: END ;
2984:
2985: END LOOP;
2986: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2987: UTL_FILE.NEW_LINE(l_log_handle);
2988: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
2989:
2990: /* Check if any messages generated. If so then decode and */

Line 2999: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */

2995: RETURN l_return_status;
2996:
2997: EXCEPTION
2998: WHEN UTL_FILE.INVALID_OPERATION THEN
2999: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */
3000: UTL_FILE.FCLOSE_ALL;
3001: RETURN l_return_status;
3002:
3003: WHEN UTL_FILE.INVALID_PATH THEN

Line 3004: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */

3000: UTL_FILE.FCLOSE_ALL;
3001: RETURN l_return_status;
3002:
3003: WHEN UTL_FILE.INVALID_PATH THEN
3004: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */
3005: UTL_FILE.FCLOSE_ALL;
3006: RETURN l_return_status;
3007:
3008: WHEN UTL_FILE.INVALID_MODE THEN

Line 3009: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */

3005: UTL_FILE.FCLOSE_ALL;
3006: RETURN l_return_status;
3007:
3008: WHEN UTL_FILE.INVALID_MODE THEN
3009: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */
3010: UTL_FILE.FCLOSE_ALL;
3011: RETURN l_return_status;
3012:
3013: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 3014: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */

3010: UTL_FILE.FCLOSE_ALL;
3011: RETURN l_return_status;
3012:
3013: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
3014: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */
3015: UTL_FILE.FCLOSE_ALL;
3016: RETURN l_return_status;
3017:
3018: WHEN UTL_FILE.WRITE_ERROR THEN

Line 3019: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */

3015: UTL_FILE.FCLOSE_ALL;
3016: RETURN l_return_status;
3017:
3018: WHEN UTL_FILE.WRITE_ERROR THEN
3019: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */
3020: UTL_FILE.FCLOSE_ALL;
3021: RETURN l_return_status;
3022:
3023: WHEN UTL_FILE.READ_ERROR THEN

Line 3024: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */

3020: UTL_FILE.FCLOSE_ALL;
3021: RETURN l_return_status;
3022:
3023: WHEN UTL_FILE.READ_ERROR THEN
3024: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */
3025: UTL_FILE.FCLOSE_ALL;
3026: RETURN l_return_status;
3027:
3028: WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 3029: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */

3025: UTL_FILE.FCLOSE_ALL;
3026: RETURN l_return_status;
3027:
3028: WHEN UTL_FILE.INTERNAL_ERROR THEN
3029: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */
3030: UTL_FILE.FCLOSE_ALL;
3031: RETURN l_return_status;
3032:
3033: WHEN OTHERS THEN

Line 3034: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */

3030: UTL_FILE.FCLOSE_ALL;
3031: RETURN l_return_status;
3032:
3033: WHEN OTHERS THEN
3034: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */
3035: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
3036: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
3037: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3038: UTL_FILE.FCLOSE_ALL;

Line 3087: ---- DBMS_OUTPUT.PUT_LINE('in Delete_Alloc_def procedure... ');

3083: l_return_status VARCHAR2(1);
3084:
3085: BEGIN
3086:
3087: ---- DBMS_OUTPUT.PUT_LINE('in Delete_Alloc_def procedure... ');
3088: l_return_status :=Delete_Alloc_def( p_dir
3089: , p_input_file
3090: , p_output_file
3091: , p_delimiter

Line 3094: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);

3090: , p_output_file
3091: , p_delimiter
3092: );
3093:
3094: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);
3095: End Delete_Alloc_def;
3096:
3097: /* +==========================================================================+
3098: | FUNCTION NAME |

Line 3167: /* DBMS_OUTPUT.ENABLE(1000000); */

3163:
3164: BEGIN
3165:
3166: /* Enable The Buffer */
3167: /* DBMS_OUTPUT.ENABLE(1000000); */
3168:
3169: -- DBMS_OUTPUT.PUT_LINE('in Delete_Alloc_def function...');
3170:
3171: l_p_dir :=p_dir;

Line 3169: -- DBMS_OUTPUT.PUT_LINE('in Delete_Alloc_def function...');

3165:
3166: /* Enable The Buffer */
3167: /* DBMS_OUTPUT.ENABLE(1000000); */
3168:
3169: -- DBMS_OUTPUT.PUT_LINE('in Delete_Alloc_def function...');
3170:
3171: l_p_dir :=p_dir;
3172: l_input_file :=p_input_file;
3173: l_output_file :=p_output_file;

Line 3194: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

3190: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
3191: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
3192:
3193: /* Loop thru flat file and call Inventory Quantities API */
3194: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3195: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
3196: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
3197: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
3198: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 3195: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

3191: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
3192:
3193: /* Loop thru flat file and call Inventory Quantities API */
3194: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3195: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
3196: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
3197: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
3198: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
3199:

Line 3196: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

3192:
3193: /* Loop thru flat file and call Inventory Quantities API */
3194: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3195: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
3196: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
3197: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
3198: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
3199:
3200:

Line 3197: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

3193: /* Loop thru flat file and call Inventory Quantities API */
3194: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3195: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
3196: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
3197: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
3198: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
3199:
3200:
3201: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

Line 3198: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

3194: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3195: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
3196: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
3197: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
3198: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
3199:
3200:
3201: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
3202: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 3201: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

3197: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
3198: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
3199:
3200:
3201: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
3202: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3203: UTL_FILE.NEW_LINE(l_log_handle);
3204: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
3205: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );

Line 3267: -- DBMS_OUTPUT.PUT_LINE('before calling Delete API...');

3263: UTL_FILE.PUT_LINE(l_log_handle, 'organization_code = ' || alloc_rec.organization_code) ;
3264: UTL_FILE.PUT_LINE(l_log_handle, 'delete_mark = ' || alloc_rec.delete_mark) ;
3265: UTL_FILE.PUT_LINE(l_log_handle, 'user_name = ' || alloc_rec.user_name) ;
3266:
3267: -- DBMS_OUTPUT.PUT_LINE('before calling Delete API...');
3268: GMF_ALLOCATIONDEFINITION_PUB.Delete_Allocation_Definition
3269: ( p_api_version => 3.0
3270: , p_init_msg_list => FND_API.G_TRUE
3271: , p_commit => FND_API.G_TRUE

Line 3293: -- DBMS_OUTPUT.PUT_LINE(l_data );

3289: p_encoded => FND_API.G_FALSE,
3290: p_msg_index_out => l_dummy_cnt);
3291:
3292:
3293: -- DBMS_OUTPUT.PUT_LINE(l_data );
3294:
3295: UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
3296: UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
3297: UTL_FILE.NEW_LINE(l_outfile_handle);

Line 3324: -- DBMS_OUTPUT.PUT_LINE('Other Error...1');

3320: END IF;
3321:
3322: EXCEPTION
3323: WHEN OTHERS THEN
3324: -- DBMS_OUTPUT.PUT_LINE('Other Error...1');
3325: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
3326: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
3327: l_return_status := 'U' ;
3328: END ;

Line 3332: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

3328: END ;
3329:
3330: END LOOP;
3331:
3332: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3333: UTL_FILE.NEW_LINE(l_log_handle);
3334: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3335:
3336: /* Check if any messages generated. If so then decode and */

Line 3345: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */

3341: RETURN l_return_status;
3342:
3343: EXCEPTION
3344: WHEN UTL_FILE.INVALID_OPERATION THEN
3345: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */
3346: UTL_FILE.FCLOSE_ALL;
3347: RETURN l_return_status;
3348:
3349: WHEN UTL_FILE.INVALID_PATH THEN

Line 3350: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */

3346: UTL_FILE.FCLOSE_ALL;
3347: RETURN l_return_status;
3348:
3349: WHEN UTL_FILE.INVALID_PATH THEN
3350: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */
3351: UTL_FILE.FCLOSE_ALL;
3352: RETURN l_return_status;
3353:
3354: WHEN UTL_FILE.INVALID_MODE THEN

Line 3355: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */

3351: UTL_FILE.FCLOSE_ALL;
3352: RETURN l_return_status;
3353:
3354: WHEN UTL_FILE.INVALID_MODE THEN
3355: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */
3356: UTL_FILE.FCLOSE_ALL;
3357: RETURN l_return_status;
3358:
3359: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 3360: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */

3356: UTL_FILE.FCLOSE_ALL;
3357: RETURN l_return_status;
3358:
3359: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
3360: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */
3361: UTL_FILE.FCLOSE_ALL;
3362: RETURN l_return_status;
3363:
3364: WHEN UTL_FILE.WRITE_ERROR THEN

Line 3365: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */

3361: UTL_FILE.FCLOSE_ALL;
3362: RETURN l_return_status;
3363:
3364: WHEN UTL_FILE.WRITE_ERROR THEN
3365: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */
3366: UTL_FILE.FCLOSE_ALL;
3367: RETURN l_return_status;
3368:
3369: WHEN UTL_FILE.READ_ERROR THEN

Line 3370: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */

3366: UTL_FILE.FCLOSE_ALL;
3367: RETURN l_return_status;
3368:
3369: WHEN UTL_FILE.READ_ERROR THEN
3370: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */
3371: UTL_FILE.FCLOSE_ALL;
3372: RETURN l_return_status;
3373:
3374: WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 3375: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */

3371: UTL_FILE.FCLOSE_ALL;
3372: RETURN l_return_status;
3373:
3374: WHEN UTL_FILE.INTERNAL_ERROR THEN
3375: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */
3376: UTL_FILE.FCLOSE_ALL;
3377: RETURN l_return_status;
3378:
3379: WHEN OTHERS THEN

Line 3380: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */

3376: UTL_FILE.FCLOSE_ALL;
3377: RETURN l_return_status;
3378:
3379: WHEN OTHERS THEN
3380: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */
3381: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
3382: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
3383: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3384: UTL_FILE.FCLOSE_ALL;

Line 3435: --DBMS_OUTPUT.PUT_LINE('in Process_LotCost_Adjustment procedure... ');

3431: l_return_status VARCHAR2(1);
3432:
3433: BEGIN
3434:
3435: --DBMS_OUTPUT.PUT_LINE('in Process_LotCost_Adjustment procedure... ');
3436: l_return_status :=Process_LotCost_Adjustment( p_dir
3437: , p_input_file
3438: , p_output_file
3439: , p_delimiter

Line 3526: -- DBMS_OUTPUT.ENABLE(1000000);

3522:
3523: BEGIN
3524:
3525: /* Enable The Buffer */
3526: -- DBMS_OUTPUT.ENABLE(1000000);
3527:
3528: --DBMS_OUTPUT.PUT_LINE('in Process_LotCost_Adjustment function...');
3529:
3530: l_p_dir :=p_dir;

Line 3528: --DBMS_OUTPUT.PUT_LINE('in Process_LotCost_Adjustment function...');

3524:
3525: /* Enable The Buffer */
3526: -- DBMS_OUTPUT.ENABLE(1000000);
3527:
3528: --DBMS_OUTPUT.PUT_LINE('in Process_LotCost_Adjustment function...');
3529:
3530: l_p_dir :=p_dir;
3531: l_log_dir := p_dir;
3532: l_input_file :=p_input_file;

Line 3561: DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

3557: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
3558:
3559: /* Loop thru flat file and call Inventory Quantities API */
3560: /*
3561: DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3562: DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
3563: DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
3564: DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
3565: DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 3562: DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

3558:
3559: /* Loop thru flat file and call Inventory Quantities API */
3560: /*
3561: DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3562: DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
3563: DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
3564: DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
3565: DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
3566: */

Line 3563: DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

3559: /* Loop thru flat file and call Inventory Quantities API */
3560: /*
3561: DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3562: DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
3563: DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
3564: DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
3565: DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
3566: */
3567:

Line 3564: DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

3560: /*
3561: DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3562: DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
3563: DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
3564: DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
3565: DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
3566: */
3567:
3568: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 3565: DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

3561: DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3562: DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
3563: DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
3564: DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
3565: DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
3566: */
3567:
3568: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3569: UTL_FILE.NEW_LINE(l_log_handle);

Line 3796: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

3792: END IF ;
3793:
3794: END LOOP;
3795:
3796: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3797: UTL_FILE.NEW_LINE(l_log_handle);
3798: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3799: UTL_FILE.FCLOSE_ALL;
3800:

Line 3805: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */

3801: RETURN l_return_status;
3802:
3803: EXCEPTION
3804: WHEN UTL_FILE.INVALID_OPERATION THEN
3805: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */
3806: UTL_FILE.FCLOSE_ALL;
3807: RETURN l_return_status;
3808:
3809: WHEN UTL_FILE.INVALID_PATH THEN

Line 3810: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */

3806: UTL_FILE.FCLOSE_ALL;
3807: RETURN l_return_status;
3808:
3809: WHEN UTL_FILE.INVALID_PATH THEN
3810: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */
3811: UTL_FILE.FCLOSE_ALL;
3812: RETURN l_return_status;
3813:
3814: WHEN UTL_FILE.INVALID_MODE THEN

Line 3815: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */

3811: UTL_FILE.FCLOSE_ALL;
3812: RETURN l_return_status;
3813:
3814: WHEN UTL_FILE.INVALID_MODE THEN
3815: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */
3816: UTL_FILE.FCLOSE_ALL;
3817: RETURN l_return_status;
3818:
3819: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 3820: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */

3816: UTL_FILE.FCLOSE_ALL;
3817: RETURN l_return_status;
3818:
3819: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
3820: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */
3821: UTL_FILE.FCLOSE_ALL;
3822: RETURN l_return_status;
3823:
3824: WHEN UTL_FILE.WRITE_ERROR THEN

Line 3825: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */

3821: UTL_FILE.FCLOSE_ALL;
3822: RETURN l_return_status;
3823:
3824: WHEN UTL_FILE.WRITE_ERROR THEN
3825: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */
3826: UTL_FILE.FCLOSE_ALL;
3827: RETURN l_return_status;
3828:
3829: WHEN UTL_FILE.READ_ERROR THEN

Line 3830: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */

3826: UTL_FILE.FCLOSE_ALL;
3827: RETURN l_return_status;
3828:
3829: WHEN UTL_FILE.READ_ERROR THEN
3830: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */
3831: UTL_FILE.FCLOSE_ALL;
3832: RETURN l_return_status;
3833:
3834: WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 3835: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */

3831: UTL_FILE.FCLOSE_ALL;
3832: RETURN l_return_status;
3833:
3834: WHEN UTL_FILE.INTERNAL_ERROR THEN
3835: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */
3836: UTL_FILE.FCLOSE_ALL;
3837: RETURN l_return_status;
3838:
3839: WHEN OTHERS THEN

Line 3840: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */

3836: UTL_FILE.FCLOSE_ALL;
3837: RETURN l_return_status;
3838:
3839: WHEN OTHERS THEN
3840: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */
3841: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
3842: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
3843: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
3844: UTL_FILE.FCLOSE_ALL;

Line 4006: /* DBMS_OUTPUT.ENABLE(1000000); */

4002:
4003: BEGIN
4004:
4005: /* Enable The Buffer */
4006: /* DBMS_OUTPUT.ENABLE(1000000); */
4007:
4008: -- DBMS_OUTPUT.PUT_LINE('in Get_Burden_details function...');
4009:
4010: l_p_dir :=p_dir;

Line 4008: -- DBMS_OUTPUT.PUT_LINE('in Get_Burden_details function...');

4004:
4005: /* Enable The Buffer */
4006: /* DBMS_OUTPUT.ENABLE(1000000); */
4007:
4008: -- DBMS_OUTPUT.PUT_LINE('in Get_Burden_details function...');
4009:
4010: l_p_dir :=p_dir;
4011: l_log_dir := p_dir;
4012: l_input_file :=p_input_file;

Line 4034: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

4030: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
4031: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
4032:
4033: /* Loop thru flat file and call Inventory Quantities API */
4034: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4035: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
4036: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
4037: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4038: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 4035: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

4031: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
4032:
4033: /* Loop thru flat file and call Inventory Quantities API */
4034: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4035: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
4036: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
4037: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4038: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
4039:

Line 4036: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

4032:
4033: /* Loop thru flat file and call Inventory Quantities API */
4034: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4035: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
4036: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
4037: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4038: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
4039:
4040:

Line 4037: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

4033: /* Loop thru flat file and call Inventory Quantities API */
4034: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4035: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
4036: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
4037: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4038: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
4039:
4040:
4041: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

Line 4038: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

4034: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4035: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
4036: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
4037: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4038: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
4039:
4040:
4041: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
4042: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 4041: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

4037: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4038: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
4039:
4040:
4041: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
4042: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4043: UTL_FILE.NEW_LINE(l_log_handle);
4044: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
4045: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );

Line 4130: -- DBMS_OUTPUT.PUT_LINE('Calling Get_Item_Cost API...');

4126: l_header_rec.user_name := Get_Field(l_line,l_delimiter,45);
4127:
4128:
4129:
4130: -- DBMS_OUTPUT.PUT_LINE('Calling Get_Item_Cost API...');
4131:
4132: GMF_LotCostAdjustment_PUB.Get_LotCost_Adjustment
4133: (
4134: p_api_version => 2.0

Line 4162: ---- DBMS_OUTPUT.PUT_LINE(l_data );

4158: p_data => l_data,
4159: p_encoded => FND_API.G_FALSE,
4160: p_msg_index_out => l_dummy_cnt);
4161:
4162: ---- DBMS_OUTPUT.PUT_LINE(l_data );
4163: UTL_FILE.PUT_LINE(l_log_handle, l_data);
4164:
4165: /* Update error status */
4166: IF (l_status = 'U') THEN

Line 4209: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

4205: END ;
4206:
4207: END LOOP;
4208:
4209: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4210: UTL_FILE.NEW_LINE(l_log_handle);
4211: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4212: UTL_FILE.FCLOSE_ALL;
4213:

Line 4218: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */

4214: RETURN l_return_status;
4215:
4216: EXCEPTION
4217: WHEN UTL_FILE.INVALID_OPERATION THEN
4218: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */
4219: UTL_FILE.FCLOSE_ALL;
4220: RETURN l_return_status;
4221:
4222: WHEN UTL_FILE.INVALID_PATH THEN

Line 4223: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */

4219: UTL_FILE.FCLOSE_ALL;
4220: RETURN l_return_status;
4221:
4222: WHEN UTL_FILE.INVALID_PATH THEN
4223: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */
4224: UTL_FILE.FCLOSE_ALL;
4225: RETURN l_return_status;
4226:
4227: WHEN UTL_FILE.INVALID_MODE THEN

Line 4228: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */

4224: UTL_FILE.FCLOSE_ALL;
4225: RETURN l_return_status;
4226:
4227: WHEN UTL_FILE.INVALID_MODE THEN
4228: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */
4229: UTL_FILE.FCLOSE_ALL;
4230: RETURN l_return_status;
4231:
4232: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 4233: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */

4229: UTL_FILE.FCLOSE_ALL;
4230: RETURN l_return_status;
4231:
4232: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
4233: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */
4234: UTL_FILE.FCLOSE_ALL;
4235: RETURN l_return_status;
4236:
4237: WHEN UTL_FILE.WRITE_ERROR THEN

Line 4238: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */

4234: UTL_FILE.FCLOSE_ALL;
4235: RETURN l_return_status;
4236:
4237: WHEN UTL_FILE.WRITE_ERROR THEN
4238: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */
4239: UTL_FILE.FCLOSE_ALL;
4240: RETURN l_return_status;
4241:
4242: WHEN UTL_FILE.READ_ERROR THEN

Line 4243: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */

4239: UTL_FILE.FCLOSE_ALL;
4240: RETURN l_return_status;
4241:
4242: WHEN UTL_FILE.READ_ERROR THEN
4243: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */
4244: UTL_FILE.FCLOSE_ALL;
4245: RETURN l_return_status;
4246:
4247: WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 4248: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */

4244: UTL_FILE.FCLOSE_ALL;
4245: RETURN l_return_status;
4246:
4247: WHEN UTL_FILE.INTERNAL_ERROR THEN
4248: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */
4249: UTL_FILE.FCLOSE_ALL;
4250: RETURN l_return_status;
4251:
4252: WHEN OTHERS THEN

Line 4253: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */

4249: UTL_FILE.FCLOSE_ALL;
4250: RETURN l_return_status;
4251:
4252: WHEN OTHERS THEN
4253: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */
4254: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
4255: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
4256: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4257: UTL_FILE.FCLOSE_ALL;

Line 4277: -- DBMS_OUTPUT.PUT_LINE('in Process_Burden_details procedure... ');

4273: l_return_status VARCHAR2(1);
4274:
4275: BEGIN
4276:
4277: -- DBMS_OUTPUT.PUT_LINE('in Process_Burden_details procedure... ');
4278: l_return_status :=Process_Burden_details( p_dir
4279: , p_input_file
4280: , p_output_file
4281: , p_delimiter

Line 4285: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);

4281: , p_delimiter
4282: , p_operation
4283: );
4284:
4285: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);
4286: END Process_Burden_details;
4287:
4288: /* +========================================================================+
4289: | FUNCTION NAME |

Line 4366: /* DBMS_OUTPUT.ENABLE(1000000); */

4362:
4363: BEGIN
4364:
4365: /* Enable The Buffer */
4366: /* DBMS_OUTPUT.ENABLE(1000000); */
4367:
4368:
4369: l_p_dir :=p_dir;
4370: l_input_file :=p_input_file;

Line 4400: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

4396: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
4397: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
4398:
4399: /* Loop thru flat file and call Inventory Quantities API */
4400: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4401: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
4402: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
4403: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4404: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 4401: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

4397: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
4398:
4399: /* Loop thru flat file and call Inventory Quantities API */
4400: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4401: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
4402: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
4403: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4404: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
4405:

Line 4402: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

4398:
4399: /* Loop thru flat file and call Inventory Quantities API */
4400: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4401: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
4402: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
4403: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4404: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
4405:
4406: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

Line 4403: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

4399: /* Loop thru flat file and call Inventory Quantities API */
4400: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4401: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
4402: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
4403: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4404: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
4405:
4406: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
4407: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 4404: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

4400: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4401: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
4402: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
4403: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4404: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
4405:
4406: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
4407: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4408: UTL_FILE.NEW_LINE(l_log_handle);

Line 4406: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

4402: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
4403: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4404: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
4405:
4406: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
4407: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4408: UTL_FILE.NEW_LINE(l_log_handle);
4409: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
4410: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );

Line 4536: -- DBMS_OUTPUT.PUT_LINE('Check to call Call_Burden_API...type - ' || l_type || ' count = ' || l_record_count);

4532: goto GET_MSG_STACK ;
4533: END IF ;
4534: END;
4535:
4536: -- DBMS_OUTPUT.PUT_LINE('Check to call Call_Burden_API...type - ' || l_type || ' count = ' || l_record_count);
4537:
4538: IF (l_type = 10 AND l_record_count <> 1 AND l_skip_details = 'N') THEN
4539: UTL_FILE.PUT_LINE(l_log_handle,'In wrapper exception. Call to Call_Burden_API...');
4540: Call_Burden_API

Line 4570: ---- DBMS_OUTPUT.PUT_LINE(l_data );

4566: p_data => l_data,
4567: p_encoded => FND_API.G_FALSE,
4568: p_msg_index_out => l_dummy_cnt);
4569:
4570: ---- DBMS_OUTPUT.PUT_LINE(l_data );
4571: UTL_FILE.PUT_LINE(l_log_handle, l_data);
4572:
4573: /* Update error status */
4574: IF (l_status = 'U') THEN

Line 4611: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

4607: END IF ;
4608:
4609: END LOOP;
4610:
4611: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4612: UTL_FILE.NEW_LINE(l_log_handle);
4613: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4614: UTL_FILE.FCLOSE_ALL;
4615:

Line 4620: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */

4616: RETURN l_return_status;
4617:
4618: EXCEPTION
4619: WHEN UTL_FILE.INVALID_OPERATION THEN
4620: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */
4621: UTL_FILE.FCLOSE_ALL;
4622: RETURN l_return_status;
4623:
4624: WHEN UTL_FILE.INVALID_PATH THEN

Line 4625: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */

4621: UTL_FILE.FCLOSE_ALL;
4622: RETURN l_return_status;
4623:
4624: WHEN UTL_FILE.INVALID_PATH THEN
4625: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */
4626: UTL_FILE.FCLOSE_ALL;
4627: RETURN l_return_status;
4628:
4629: WHEN UTL_FILE.INVALID_MODE THEN

Line 4630: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */

4626: UTL_FILE.FCLOSE_ALL;
4627: RETURN l_return_status;
4628:
4629: WHEN UTL_FILE.INVALID_MODE THEN
4630: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */
4631: UTL_FILE.FCLOSE_ALL;
4632: RETURN l_return_status;
4633:
4634: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 4635: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */

4631: UTL_FILE.FCLOSE_ALL;
4632: RETURN l_return_status;
4633:
4634: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
4635: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */
4636: UTL_FILE.FCLOSE_ALL;
4637: RETURN l_return_status;
4638:
4639: WHEN UTL_FILE.WRITE_ERROR THEN

Line 4640: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */

4636: UTL_FILE.FCLOSE_ALL;
4637: RETURN l_return_status;
4638:
4639: WHEN UTL_FILE.WRITE_ERROR THEN
4640: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */
4641: UTL_FILE.FCLOSE_ALL;
4642: RETURN l_return_status;
4643:
4644: WHEN UTL_FILE.READ_ERROR THEN

Line 4645: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */

4641: UTL_FILE.FCLOSE_ALL;
4642: RETURN l_return_status;
4643:
4644: WHEN UTL_FILE.READ_ERROR THEN
4645: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */
4646: UTL_FILE.FCLOSE_ALL;
4647: RETURN l_return_status;
4648:
4649: WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 4650: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */

4646: UTL_FILE.FCLOSE_ALL;
4647: RETURN l_return_status;
4648:
4649: WHEN UTL_FILE.INTERNAL_ERROR THEN
4650: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */
4651: UTL_FILE.FCLOSE_ALL;
4652: RETURN l_return_status;
4653:
4654: WHEN OTHERS THEN

Line 4655: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */

4651: UTL_FILE.FCLOSE_ALL;
4652: RETURN l_return_status;
4653:
4654: WHEN OTHERS THEN
4655: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */
4656: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
4657: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
4658: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4659: UTL_FILE.FCLOSE_ALL;

Line 4710: DBMS_OUTPUT.PUT_LINE('in Get_Burden_details procedure... ');

4706: l_return_status VARCHAR2(1);
4707:
4708: BEGIN
4709:
4710: DBMS_OUTPUT.PUT_LINE('in Get_Burden_details procedure... ');
4711: l_return_status :=Get_Burden_details( p_dir
4712: , p_input_file
4713: , p_output_file
4714: , p_delimiter

Line 4717: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);

4713: , p_output_file
4714: , p_delimiter
4715: );
4716:
4717: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);
4718: END Get_Burden_details;
4719:
4720: /* +========================================================================+
4721: | FUNCTION NAME |

Line 4796: /* DBMS_OUTPUT.ENABLE(1000000); */

4792:
4793: BEGIN
4794:
4795: /* Enable The Buffer */
4796: /* DBMS_OUTPUT.ENABLE(1000000); */
4797:
4798: -- DBMS_OUTPUT.PUT_LINE('in Get_Burden_details function...');
4799:
4800: l_p_dir :=p_dir;

Line 4798: -- DBMS_OUTPUT.PUT_LINE('in Get_Burden_details function...');

4794:
4795: /* Enable The Buffer */
4796: /* DBMS_OUTPUT.ENABLE(1000000); */
4797:
4798: -- DBMS_OUTPUT.PUT_LINE('in Get_Burden_details function...');
4799:
4800: l_p_dir :=p_dir;
4801: l_input_file :=p_input_file;
4802: l_output_file :=p_output_file;

Line 4822: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

4818: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
4819: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
4820:
4821: /* Loop thru flat file and call Inventory Quantities API */
4822: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4823: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
4824: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
4825: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4826: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 4823: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

4819: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
4820:
4821: /* Loop thru flat file and call Inventory Quantities API */
4822: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4823: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
4824: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
4825: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4826: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
4827:

Line 4824: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

4820:
4821: /* Loop thru flat file and call Inventory Quantities API */
4822: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4823: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
4824: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
4825: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4826: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
4827:
4828:

Line 4825: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

4821: /* Loop thru flat file and call Inventory Quantities API */
4822: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4823: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
4824: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
4825: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4826: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
4827:
4828:
4829: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

Line 4826: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

4822: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4823: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
4824: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
4825: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4826: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
4827:
4828:
4829: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
4830: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 4829: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

4825: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
4826: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
4827:
4828:
4829: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
4830: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4831: UTL_FILE.NEW_LINE(l_log_handle);
4832: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
4833: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );

Line 4905: ---- DBMS_OUTPUT.PUT_LINE(l_data );

4901: p_data => l_data,
4902: p_encoded => FND_API.G_FALSE,
4903: p_msg_index_out => l_dummy_cnt);
4904:
4905: ---- DBMS_OUTPUT.PUT_LINE(l_data );
4906: UTL_FILE.PUT_LINE(l_log_handle, l_data);
4907:
4908: /* Update error status */
4909: IF (l_status = 'U') THEN

Line 4959: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

4955: END ;
4956:
4957: END LOOP;
4958:
4959: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4960: UTL_FILE.NEW_LINE(l_log_handle);
4961: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
4962: UTL_FILE.FCLOSE_ALL;
4963:

Line 4968: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */

4964: RETURN l_return_status;
4965:
4966: EXCEPTION
4967: WHEN UTL_FILE.INVALID_OPERATION THEN
4968: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */
4969: UTL_FILE.FCLOSE_ALL;
4970: RETURN l_return_status;
4971:
4972: WHEN UTL_FILE.INVALID_PATH THEN

Line 4973: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */

4969: UTL_FILE.FCLOSE_ALL;
4970: RETURN l_return_status;
4971:
4972: WHEN UTL_FILE.INVALID_PATH THEN
4973: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */
4974: UTL_FILE.FCLOSE_ALL;
4975: RETURN l_return_status;
4976:
4977: WHEN UTL_FILE.INVALID_MODE THEN

Line 4978: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */

4974: UTL_FILE.FCLOSE_ALL;
4975: RETURN l_return_status;
4976:
4977: WHEN UTL_FILE.INVALID_MODE THEN
4978: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */
4979: UTL_FILE.FCLOSE_ALL;
4980: RETURN l_return_status;
4981:
4982: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 4983: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */

4979: UTL_FILE.FCLOSE_ALL;
4980: RETURN l_return_status;
4981:
4982: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
4983: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */
4984: UTL_FILE.FCLOSE_ALL;
4985: RETURN l_return_status;
4986:
4987: WHEN UTL_FILE.WRITE_ERROR THEN

Line 4988: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */

4984: UTL_FILE.FCLOSE_ALL;
4985: RETURN l_return_status;
4986:
4987: WHEN UTL_FILE.WRITE_ERROR THEN
4988: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */
4989: UTL_FILE.FCLOSE_ALL;
4990: RETURN l_return_status;
4991:
4992: WHEN UTL_FILE.READ_ERROR THEN

Line 4993: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */

4989: UTL_FILE.FCLOSE_ALL;
4990: RETURN l_return_status;
4991:
4992: WHEN UTL_FILE.READ_ERROR THEN
4993: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */
4994: UTL_FILE.FCLOSE_ALL;
4995: RETURN l_return_status;
4996:
4997: WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 4998: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */

4994: UTL_FILE.FCLOSE_ALL;
4995: RETURN l_return_status;
4996:
4997: WHEN UTL_FILE.INTERNAL_ERROR THEN
4998: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */
4999: UTL_FILE.FCLOSE_ALL;
5000: RETURN l_return_status;
5001:
5002: WHEN OTHERS THEN

Line 5003: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */

4999: UTL_FILE.FCLOSE_ALL;
5000: RETURN l_return_status;
5001:
5002: WHEN OTHERS THEN
5003: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */
5004: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
5005: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
5006: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5007: UTL_FILE.FCLOSE_ALL;

Line 5154: -- DBMS_OUTPUT.PUT_LINE('in Create_resource_cost procedure... ');

5150: l_return_status VARCHAR2(1);
5151:
5152: BEGIN
5153:
5154: -- DBMS_OUTPUT.PUT_LINE('in Create_resource_cost procedure... ');
5155: l_return_status :=Create_resource_cost( p_dir
5156: , p_input_file
5157: , p_output_file
5158: , p_delimiter

Line 5161: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);

5157: , p_output_file
5158: , p_delimiter
5159: );
5160:
5161: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);
5162: END Create_resource_cost;
5163:
5164: /* +========================================================================+
5165: | FUNCTION NAME |

Line 5236: /* DBMS_OUTPUT.ENABLE(1000000); */

5232:
5233: BEGIN
5234:
5235: /* Enable The Buffer */
5236: /* DBMS_OUTPUT.ENABLE(1000000); */
5237:
5238: -- DBMS_OUTPUT.PUT_LINE('in Create_resource_cost function...');
5239:
5240: l_p_dir :=p_dir;

Line 5238: -- DBMS_OUTPUT.PUT_LINE('in Create_resource_cost function...');

5234:
5235: /* Enable The Buffer */
5236: /* DBMS_OUTPUT.ENABLE(1000000); */
5237:
5238: -- DBMS_OUTPUT.PUT_LINE('in Create_resource_cost function...');
5239:
5240: l_p_dir :=p_dir;
5241: l_input_file :=p_input_file;
5242: l_output_file :=p_output_file;

Line 5260: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

5256: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
5257: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
5258:
5259: /* Loop thru flat file and call Inventory Quantities API */
5260: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5261: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
5262: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
5263: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5264: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 5261: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

5257: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
5258:
5259: /* Loop thru flat file and call Inventory Quantities API */
5260: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5261: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
5262: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
5263: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5264: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
5265:

Line 5262: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

5258:
5259: /* Loop thru flat file and call Inventory Quantities API */
5260: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5261: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
5262: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
5263: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5264: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
5265:
5266: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

Line 5263: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

5259: /* Loop thru flat file and call Inventory Quantities API */
5260: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5261: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
5262: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
5263: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5264: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
5265:
5266: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
5267: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 5264: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

5260: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5261: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
5262: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
5263: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5264: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
5265:
5266: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
5267: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5268: UTL_FILE.NEW_LINE(l_log_handle);

Line 5266: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

5262: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
5263: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5264: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
5265:
5266: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
5267: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5268: UTL_FILE.NEW_LINE(l_log_handle);
5269: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
5270: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );

Line 5343: -- DBMS_OUTPUT.PUT_LINE(l_data );

5339: p_encoded => FND_API.G_FALSE,
5340: p_msg_index_out => l_dummy_cnt);
5341:
5342:
5343: -- DBMS_OUTPUT.PUT_LINE(l_data );
5344:
5345: UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
5346: UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
5347: UTL_FILE.NEW_LINE(l_outfile_handle);

Line 5389: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

5385: END ;
5386:
5387:
5388: END LOOP;
5389: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5390: UTL_FILE.NEW_LINE(l_log_handle);
5391: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5392:
5393: /* Check if any messages generated. If so then decode and */

Line 5402: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */

5398: RETURN l_return_status;
5399:
5400: EXCEPTION
5401: WHEN UTL_FILE.INVALID_OPERATION THEN
5402: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */
5403: UTL_FILE.FCLOSE_ALL;
5404: RETURN l_return_status;
5405:
5406: WHEN UTL_FILE.INVALID_PATH THEN

Line 5407: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */

5403: UTL_FILE.FCLOSE_ALL;
5404: RETURN l_return_status;
5405:
5406: WHEN UTL_FILE.INVALID_PATH THEN
5407: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */
5408: UTL_FILE.FCLOSE_ALL;
5409: RETURN l_return_status;
5410:
5411: WHEN UTL_FILE.INVALID_MODE THEN

Line 5412: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */

5408: UTL_FILE.FCLOSE_ALL;
5409: RETURN l_return_status;
5410:
5411: WHEN UTL_FILE.INVALID_MODE THEN
5412: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */
5413: UTL_FILE.FCLOSE_ALL;
5414: RETURN l_return_status;
5415:
5416: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 5417: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */

5413: UTL_FILE.FCLOSE_ALL;
5414: RETURN l_return_status;
5415:
5416: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
5417: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */
5418: UTL_FILE.FCLOSE_ALL;
5419: RETURN l_return_status;
5420:
5421: WHEN UTL_FILE.WRITE_ERROR THEN

Line 5422: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */

5418: UTL_FILE.FCLOSE_ALL;
5419: RETURN l_return_status;
5420:
5421: WHEN UTL_FILE.WRITE_ERROR THEN
5422: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */
5423: UTL_FILE.FCLOSE_ALL;
5424: RETURN l_return_status;
5425:
5426: WHEN UTL_FILE.READ_ERROR THEN

Line 5427: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */

5423: UTL_FILE.FCLOSE_ALL;
5424: RETURN l_return_status;
5425:
5426: WHEN UTL_FILE.READ_ERROR THEN
5427: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */
5428: UTL_FILE.FCLOSE_ALL;
5429: RETURN l_return_status;
5430:
5431: WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 5432: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */

5428: UTL_FILE.FCLOSE_ALL;
5429: RETURN l_return_status;
5430:
5431: WHEN UTL_FILE.INTERNAL_ERROR THEN
5432: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */
5433: UTL_FILE.FCLOSE_ALL;
5434: RETURN l_return_status;
5435:
5436: WHEN OTHERS THEN

Line 5437: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */

5433: UTL_FILE.FCLOSE_ALL;
5434: RETURN l_return_status;
5435:
5436: WHEN OTHERS THEN
5437: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */
5438: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
5439: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
5440: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5441: UTL_FILE.FCLOSE_ALL;

Line 5491: ---- DBMS_OUTPUT.PUT_LINE('in Update_resource_cost procedure... ');

5487: l_return_status VARCHAR2(1);
5488:
5489: BEGIN
5490:
5491: ---- DBMS_OUTPUT.PUT_LINE('in Update_resource_cost procedure... ');
5492: l_return_status :=Update_resource_cost( p_dir
5493: , p_input_file
5494: , p_output_file
5495: , p_delimiter

Line 5498: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);

5494: , p_output_file
5495: , p_delimiter
5496: );
5497:
5498: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);
5499: END Update_resource_cost;
5500:
5501: /* +==========================================================================+
5502: | FUNCTION NAME |

Line 5573: /* DBMS_OUTPUT.ENABLE(1000000); */

5569:
5570: BEGIN
5571:
5572: /* Enable The Buffer */
5573: /* DBMS_OUTPUT.ENABLE(1000000); */
5574:
5575: -- DBMS_OUTPUT.PUT_LINE('in Update_resource_cost function...');
5576:
5577: l_p_dir :=p_dir;

Line 5575: -- DBMS_OUTPUT.PUT_LINE('in Update_resource_cost function...');

5571:
5572: /* Enable The Buffer */
5573: /* DBMS_OUTPUT.ENABLE(1000000); */
5574:
5575: -- DBMS_OUTPUT.PUT_LINE('in Update_resource_cost function...');
5576:
5577: l_p_dir :=p_dir;
5578: l_input_file :=p_input_file;
5579: l_output_file :=p_output_file;

Line 5600: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

5596: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
5597: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
5598:
5599: /* Loop thru flat file and call Inventory Quantities API */
5600: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5601: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
5602: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
5603: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5604: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 5601: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

5597: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
5598:
5599: /* Loop thru flat file and call Inventory Quantities API */
5600: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5601: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
5602: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
5603: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5604: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
5605:

Line 5602: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

5598:
5599: /* Loop thru flat file and call Inventory Quantities API */
5600: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5601: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
5602: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
5603: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5604: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
5605:
5606:

Line 5603: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

5599: /* Loop thru flat file and call Inventory Quantities API */
5600: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5601: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
5602: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
5603: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5604: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
5605:
5606:
5607: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

Line 5604: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

5600: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5601: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
5602: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
5603: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5604: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
5605:
5606:
5607: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
5608: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 5607: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

5603: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5604: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
5605:
5606:
5607: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
5608: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5609: UTL_FILE.NEW_LINE(l_log_handle);
5610: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
5611: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );

Line 5659: -- DBMS_OUTPUT.PUT_LINE('before calling Update API...');

5655: UTL_FILE.PUT_LINE(l_log_handle, 'nominal_cost = ' || rsrc_rec.nominal_cost);
5656: UTL_FILE.PUT_LINE(l_log_handle, 'delete_mark = ' || rsrc_rec.delete_mark);
5657: UTL_FILE.PUT_LINE(l_log_handle, 'user_name = ' || rsrc_rec.user_name);
5658:
5659: -- DBMS_OUTPUT.PUT_LINE('before calling Update API...');
5660: GMF_ResourceCost_PUB.Update_Resource_Cost
5661: ( p_api_version => 2.0
5662: , p_init_msg_list => FND_API.G_TRUE
5663: , p_commit => FND_API.G_TRUE

Line 5685: -- DBMS_OUTPUT.PUT_LINE(l_data );

5681: p_encoded => FND_API.G_FALSE,
5682: p_msg_index_out => l_dummy_cnt);
5683:
5684:
5685: -- DBMS_OUTPUT.PUT_LINE(l_data );
5686:
5687: UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
5688: UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
5689: UTL_FILE.NEW_LINE(l_outfile_handle);

Line 5733: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

5729: l_return_status := 'U' ;
5730: END ;
5731:
5732: END LOOP;
5733: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5734: UTL_FILE.NEW_LINE(l_log_handle);
5735: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5736:
5737: /* Check if any messages generated. If so then decode and */

Line 5746: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */

5742: RETURN l_return_status;
5743:
5744: EXCEPTION
5745: WHEN UTL_FILE.INVALID_OPERATION THEN
5746: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */
5747: UTL_FILE.FCLOSE_ALL;
5748: RETURN l_return_status;
5749:
5750: WHEN UTL_FILE.INVALID_PATH THEN

Line 5751: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */

5747: UTL_FILE.FCLOSE_ALL;
5748: RETURN l_return_status;
5749:
5750: WHEN UTL_FILE.INVALID_PATH THEN
5751: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */
5752: UTL_FILE.FCLOSE_ALL;
5753: RETURN l_return_status;
5754:
5755: WHEN UTL_FILE.INVALID_MODE THEN

Line 5756: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */

5752: UTL_FILE.FCLOSE_ALL;
5753: RETURN l_return_status;
5754:
5755: WHEN UTL_FILE.INVALID_MODE THEN
5756: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */
5757: UTL_FILE.FCLOSE_ALL;
5758: RETURN l_return_status;
5759:
5760: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 5761: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */

5757: UTL_FILE.FCLOSE_ALL;
5758: RETURN l_return_status;
5759:
5760: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
5761: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */
5762: UTL_FILE.FCLOSE_ALL;
5763: RETURN l_return_status;
5764:
5765: WHEN UTL_FILE.WRITE_ERROR THEN

Line 5766: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */

5762: UTL_FILE.FCLOSE_ALL;
5763: RETURN l_return_status;
5764:
5765: WHEN UTL_FILE.WRITE_ERROR THEN
5766: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */
5767: UTL_FILE.FCLOSE_ALL;
5768: RETURN l_return_status;
5769:
5770: WHEN UTL_FILE.READ_ERROR THEN

Line 5771: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */

5767: UTL_FILE.FCLOSE_ALL;
5768: RETURN l_return_status;
5769:
5770: WHEN UTL_FILE.READ_ERROR THEN
5771: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */
5772: UTL_FILE.FCLOSE_ALL;
5773: RETURN l_return_status;
5774:
5775: WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 5776: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */

5772: UTL_FILE.FCLOSE_ALL;
5773: RETURN l_return_status;
5774:
5775: WHEN UTL_FILE.INTERNAL_ERROR THEN
5776: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */
5777: UTL_FILE.FCLOSE_ALL;
5778: RETURN l_return_status;
5779:
5780: WHEN OTHERS THEN

Line 5781: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */

5777: UTL_FILE.FCLOSE_ALL;
5778: RETURN l_return_status;
5779:
5780: WHEN OTHERS THEN
5781: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */
5782: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
5783: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
5784: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5785: UTL_FILE.FCLOSE_ALL;

Line 5834: ---- DBMS_OUTPUT.PUT_LINE('in Delete_resource_cost procedure... ');

5830: l_return_status VARCHAR2(1);
5831:
5832: BEGIN
5833:
5834: ---- DBMS_OUTPUT.PUT_LINE('in Delete_resource_cost procedure... ');
5835: l_return_status :=Delete_resource_cost( p_dir
5836: , p_input_file
5837: , p_output_file
5838: , p_delimiter

Line 5841: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);

5837: , p_output_file
5838: , p_delimiter
5839: );
5840:
5841: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);
5842: END Delete_resource_cost;
5843:
5844: /* +==========================================================================+
5845: | FUNCTION NAME |

Line 5916: /* DBMS_OUTPUT.ENABLE(1000000); */

5912:
5913: BEGIN
5914:
5915: /* Enable The Buffer */
5916: /* DBMS_OUTPUT.ENABLE(1000000); */
5917:
5918: -- DBMS_OUTPUT.PUT_LINE('in Delete_resource_cost function...');
5919:
5920: l_p_dir :=p_dir;

Line 5918: -- DBMS_OUTPUT.PUT_LINE('in Delete_resource_cost function...');

5914:
5915: /* Enable The Buffer */
5916: /* DBMS_OUTPUT.ENABLE(1000000); */
5917:
5918: -- DBMS_OUTPUT.PUT_LINE('in Delete_resource_cost function...');
5919:
5920: l_p_dir :=p_dir;
5921: l_input_file :=p_input_file;
5922: l_output_file :=p_output_file;

Line 5943: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

5939: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
5940: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
5941:
5942: /* Loop thru flat file and call Inventory Quantities API */
5943: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5944: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
5945: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
5946: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5947: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 5944: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

5940: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
5941:
5942: /* Loop thru flat file and call Inventory Quantities API */
5943: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5944: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
5945: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
5946: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5947: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
5948:

Line 5945: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

5941:
5942: /* Loop thru flat file and call Inventory Quantities API */
5943: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5944: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
5945: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
5946: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5947: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
5948:
5949:

Line 5946: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

5942: /* Loop thru flat file and call Inventory Quantities API */
5943: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5944: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
5945: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
5946: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5947: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
5948:
5949:
5950: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

Line 5947: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

5943: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5944: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
5945: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
5946: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5947: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
5948:
5949:
5950: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
5951: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 5950: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

5946: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
5947: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
5948:
5949:
5950: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
5951: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
5952: UTL_FILE.NEW_LINE(l_log_handle);
5953: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
5954: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );

Line 6003: -- DBMS_OUTPUT.PUT_LINE('before calling Delete API...');

5999: UTL_FILE.PUT_LINE(l_log_handle, 'nominal_cost = ' || rsrc_rec.nominal_cost);
6000: UTL_FILE.PUT_LINE(l_log_handle, 'delete_mark = ' || rsrc_rec.delete_mark);
6001: UTL_FILE.PUT_LINE(l_log_handle, 'user_name = ' || rsrc_rec.user_name);
6002:
6003: -- DBMS_OUTPUT.PUT_LINE('before calling Delete API...');
6004: GMF_ResourceCost_PUB.Delete_Resource_Cost
6005: ( p_api_version => 2.0
6006: , p_init_msg_list => FND_API.G_TRUE
6007: , p_commit => FND_API.G_TRUE

Line 6029: -- DBMS_OUTPUT.PUT_LINE(l_data );

6025: p_encoded => FND_API.G_FALSE,
6026: p_msg_index_out => l_dummy_cnt);
6027:
6028:
6029: -- DBMS_OUTPUT.PUT_LINE(l_data );
6030:
6031: UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
6032: UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
6033: UTL_FILE.NEW_LINE(l_outfile_handle);

Line 6067: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

6063: END ;
6064:
6065:
6066: END LOOP;
6067: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
6068: UTL_FILE.NEW_LINE(l_log_handle);
6069: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
6070:
6071: /* Check if any messages generated. If so then decode and */

Line 6080: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */

6076: RETURN l_return_status;
6077:
6078: EXCEPTION
6079: WHEN UTL_FILE.INVALID_OPERATION THEN
6080: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */
6081: UTL_FILE.FCLOSE_ALL;
6082: RETURN l_return_status;
6083:
6084: WHEN UTL_FILE.INVALID_PATH THEN

Line 6085: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */

6081: UTL_FILE.FCLOSE_ALL;
6082: RETURN l_return_status;
6083:
6084: WHEN UTL_FILE.INVALID_PATH THEN
6085: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */
6086: UTL_FILE.FCLOSE_ALL;
6087: RETURN l_return_status;
6088:
6089: WHEN UTL_FILE.INVALID_MODE THEN

Line 6090: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */

6086: UTL_FILE.FCLOSE_ALL;
6087: RETURN l_return_status;
6088:
6089: WHEN UTL_FILE.INVALID_MODE THEN
6090: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */
6091: UTL_FILE.FCLOSE_ALL;
6092: RETURN l_return_status;
6093:
6094: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 6095: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */

6091: UTL_FILE.FCLOSE_ALL;
6092: RETURN l_return_status;
6093:
6094: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
6095: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */
6096: UTL_FILE.FCLOSE_ALL;
6097: RETURN l_return_status;
6098:
6099: WHEN UTL_FILE.WRITE_ERROR THEN

Line 6100: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */

6096: UTL_FILE.FCLOSE_ALL;
6097: RETURN l_return_status;
6098:
6099: WHEN UTL_FILE.WRITE_ERROR THEN
6100: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */
6101: UTL_FILE.FCLOSE_ALL;
6102: RETURN l_return_status;
6103:
6104: WHEN UTL_FILE.READ_ERROR THEN

Line 6105: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */

6101: UTL_FILE.FCLOSE_ALL;
6102: RETURN l_return_status;
6103:
6104: WHEN UTL_FILE.READ_ERROR THEN
6105: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */
6106: UTL_FILE.FCLOSE_ALL;
6107: RETURN l_return_status;
6108:
6109: WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 6110: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */

6106: UTL_FILE.FCLOSE_ALL;
6107: RETURN l_return_status;
6108:
6109: WHEN UTL_FILE.INTERNAL_ERROR THEN
6110: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */
6111: UTL_FILE.FCLOSE_ALL;
6112: RETURN l_return_status;
6113:
6114: WHEN OTHERS THEN

Line 6115: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */

6111: UTL_FILE.FCLOSE_ALL;
6112: RETURN l_return_status;
6113:
6114: WHEN OTHERS THEN
6115: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */
6116: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
6117: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
6118: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
6119: UTL_FILE.FCLOSE_ALL;

Line 6168: -- DBMS_OUTPUT.PUT_LINE('in Get_Resource_Cost procedure... ');

6164: l_return_status VARCHAR2(1);
6165:
6166: BEGIN
6167:
6168: -- DBMS_OUTPUT.PUT_LINE('in Get_Resource_Cost procedure... ');
6169: l_return_status :=Get_Resource_Cost( p_dir
6170: , p_input_file
6171: , p_output_file
6172: , p_delimiter

Line 6175: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);

6171: , p_output_file
6172: , p_delimiter
6173: );
6174:
6175: -- DBMS_OUTPUT.PUT_LINE('return status := ' || l_return_status);
6176: END Get_Resource_Cost;
6177:
6178: /* +========================================================================+
6179: | FUNCTION NAME |

Line 6250: /* DBMS_OUTPUT.ENABLE(1000000); */

6246:
6247: BEGIN
6248:
6249: /* Enable The Buffer */
6250: /* DBMS_OUTPUT.ENABLE(1000000); */
6251:
6252: -- DBMS_OUTPUT.PUT_LINE('in Get_resource_cost function...');
6253:
6254: l_p_dir :=p_dir;

Line 6252: -- DBMS_OUTPUT.PUT_LINE('in Get_resource_cost function...');

6248:
6249: /* Enable The Buffer */
6250: /* DBMS_OUTPUT.ENABLE(1000000); */
6251:
6252: -- DBMS_OUTPUT.PUT_LINE('in Get_resource_cost function...');
6253:
6254: l_p_dir :=p_dir;
6255: l_input_file :=p_input_file;
6256: l_output_file :=p_output_file;

Line 6277: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

6273: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
6274: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
6275:
6276: /* Loop thru flat file and call Inventory Quantities API */
6277: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
6278: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
6279: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
6280: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
6281: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

Line 6278: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );

6274: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
6275:
6276: /* Loop thru flat file and call Inventory Quantities API */
6277: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
6278: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
6279: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
6280: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
6281: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
6282:

Line 6279: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );

6275:
6276: /* Loop thru flat file and call Inventory Quantities API */
6277: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
6278: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
6279: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
6280: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
6281: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
6282:
6283:

Line 6280: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );

6276: /* Loop thru flat file and call Inventory Quantities API */
6277: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
6278: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
6279: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
6280: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
6281: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
6282:
6283:
6284: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

Line 6281: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );

6277: -- DBMS_OUTPUT.PUT_LINE('Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
6278: -- DBMS_OUTPUT.PUT_LINE('Input Directory ' || l_p_dir );
6279: -- DBMS_OUTPUT.PUT_LINE('Input File ' || l_input_file );
6280: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
6281: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
6282:
6283:
6284: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
6285: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

Line 6284: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */

6280: -- DBMS_OUTPUT.PUT_LINE('Delimiter ' || l_delimiter );
6281: -- DBMS_OUTPUT.PUT_LINE('Output File ' || l_output_file );
6282:
6283:
6284: /* -- DBMS_OUTPUT.PUT_LINE('Start Processing'); */
6285: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
6286: UTL_FILE.NEW_LINE(l_log_handle);
6287: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
6288: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );

Line 6337: -- DBMS_OUTPUT.PUT_LINE('before calling Get Resource Cost Public API...');

6333: UTL_FILE.PUT_LINE(l_log_handle, 'nominal_cost = ' || rsrc_rec.nominal_cost);
6334: UTL_FILE.PUT_LINE(l_log_handle, 'delete_mark = ' || rsrc_rec.delete_mark);
6335: UTL_FILE.PUT_LINE(l_log_handle, 'user_name = ' || rsrc_rec.user_name);
6336:
6337: -- DBMS_OUTPUT.PUT_LINE('before calling Get Resource Cost Public API...');
6338: GMF_ResourceCost_PUB.Get_Resource_Cost
6339: ( p_api_version => 2.0
6340: , p_init_msg_list => FND_API.G_TRUE
6341:

Line 6363: -- DBMS_OUTPUT.PUT_LINE(l_data );

6359: p_encoded => FND_API.G_FALSE,
6360: p_msg_index_out => l_dummy_cnt);
6361:
6362:
6363: -- DBMS_OUTPUT.PUT_LINE(l_data );
6364: --UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
6365: --UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
6366: --UTL_FILE.NEW_LINE(l_outfile_handle);
6367:

Line 6410: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));

6406: END ;
6407:
6408: END LOOP ;
6409:
6410: -- DBMS_OUTPUT.PUT_LINE('Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
6411: UTL_FILE.NEW_LINE(l_log_handle);
6412: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
6413: UTL_FILE.FCLOSE_ALL;
6414:

Line 6419: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */

6415: RETURN l_return_status;
6416:
6417: EXCEPTION
6418: WHEN UTL_FILE.INVALID_OPERATION THEN
6419: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Operation For '|| l_global_file); */
6420: UTL_FILE.FCLOSE_ALL;
6421: RETURN l_return_status;
6422:
6423: WHEN UTL_FILE.INVALID_PATH THEN

Line 6424: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */

6420: UTL_FILE.FCLOSE_ALL;
6421: RETURN l_return_status;
6422:
6423: WHEN UTL_FILE.INVALID_PATH THEN
6424: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Path For '|| l_global_file); */
6425: UTL_FILE.FCLOSE_ALL;
6426: RETURN l_return_status;
6427:
6428: WHEN UTL_FILE.INVALID_MODE THEN

Line 6429: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */

6425: UTL_FILE.FCLOSE_ALL;
6426: RETURN l_return_status;
6427:
6428: WHEN UTL_FILE.INVALID_MODE THEN
6429: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Mode For '|| l_global_file); */
6430: UTL_FILE.FCLOSE_ALL;
6431: RETURN l_return_status;
6432:
6433: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 6434: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */

6430: UTL_FILE.FCLOSE_ALL;
6431: RETURN l_return_status;
6432:
6433: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
6434: /* -- DBMS_OUTPUT.PUT_LINE('Invalid File Handle '|| l_global_file); */
6435: UTL_FILE.FCLOSE_ALL;
6436: RETURN l_return_status;
6437:
6438: WHEN UTL_FILE.WRITE_ERROR THEN

Line 6439: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */

6435: UTL_FILE.FCLOSE_ALL;
6436: RETURN l_return_status;
6437:
6438: WHEN UTL_FILE.WRITE_ERROR THEN
6439: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Write Error '|| l_global_file); */
6440: UTL_FILE.FCLOSE_ALL;
6441: RETURN l_return_status;
6442:
6443: WHEN UTL_FILE.READ_ERROR THEN

Line 6444: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */

6440: UTL_FILE.FCLOSE_ALL;
6441: RETURN l_return_status;
6442:
6443: WHEN UTL_FILE.READ_ERROR THEN
6444: /* -- DBMS_OUTPUT.PUT_LINE('Invalid Read Error '|| l_global_file); */
6445: UTL_FILE.FCLOSE_ALL;
6446: RETURN l_return_status;
6447:
6448: WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 6449: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */

6445: UTL_FILE.FCLOSE_ALL;
6446: RETURN l_return_status;
6447:
6448: WHEN UTL_FILE.INTERNAL_ERROR THEN
6449: /* -- DBMS_OUTPUT.PUT_LINE('Internal Error'); */
6450: UTL_FILE.FCLOSE_ALL;
6451: RETURN l_return_status;
6452:
6453: WHEN OTHERS THEN

Line 6454: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */

6450: UTL_FILE.FCLOSE_ALL;
6451: RETURN l_return_status;
6452:
6453: WHEN OTHERS THEN
6454: /* -- DBMS_OUTPUT.PUT_LINE('Other Error'); */
6455: UTL_FILE.PUT_LINE(l_outfile_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
6456: UTL_FILE.PUT_LINE(l_log_handle, 'Error : ' || to_char(SQLCODE) || ' ' || SQLERRM);
6457: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at ' || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
6458: UTL_FILE.FCLOSE_ALL;