DBA Data[Home] [Help]

APPS.CST_START_IMP_PROCESS dependencies on FND_FILE

Line 28: fnd_file.put_line(fnd_file.log,'---------------------------------------------');

24: i_opt := 5;
25:
26: l_next_val := i_next_val;
27:
28: fnd_file.put_line(fnd_file.log,'---------------------------------------------');
29: fnd_file.put_line(fnd_file.log,'Option to import : ' || to_char(i_option));
30: fnd_file.put_line(fnd_file.log,'Mode to run : ' || to_char(i_run_option));
31: fnd_file.put_line(fnd_file.log,'Group ID option : ' || to_char(i_group_option));
32: fnd_file.put_line(fnd_file.log,'Group ID selected: ' || i_next_val);

Line 29: fnd_file.put_line(fnd_file.log,'Option to import : ' || to_char(i_option));

25:
26: l_next_val := i_next_val;
27:
28: fnd_file.put_line(fnd_file.log,'---------------------------------------------');
29: fnd_file.put_line(fnd_file.log,'Option to import : ' || to_char(i_option));
30: fnd_file.put_line(fnd_file.log,'Mode to run : ' || to_char(i_run_option));
31: fnd_file.put_line(fnd_file.log,'Group ID option : ' || to_char(i_group_option));
32: fnd_file.put_line(fnd_file.log,'Group ID selected: ' || i_next_val);
33: fnd_file.put_line(fnd_file.log,'Cost type : '|| i_cost_type);

Line 30: fnd_file.put_line(fnd_file.log,'Mode to run : ' || to_char(i_run_option));

26: l_next_val := i_next_val;
27:
28: fnd_file.put_line(fnd_file.log,'---------------------------------------------');
29: fnd_file.put_line(fnd_file.log,'Option to import : ' || to_char(i_option));
30: fnd_file.put_line(fnd_file.log,'Mode to run : ' || to_char(i_run_option));
31: fnd_file.put_line(fnd_file.log,'Group ID option : ' || to_char(i_group_option));
32: fnd_file.put_line(fnd_file.log,'Group ID selected: ' || i_next_val);
33: fnd_file.put_line(fnd_file.log,'Cost type : '|| i_cost_type);
34: fnd_file.put_line(fnd_file.log,'Delete option : ' || to_char (i_del_option));

Line 31: fnd_file.put_line(fnd_file.log,'Group ID option : ' || to_char(i_group_option));

27:
28: fnd_file.put_line(fnd_file.log,'---------------------------------------------');
29: fnd_file.put_line(fnd_file.log,'Option to import : ' || to_char(i_option));
30: fnd_file.put_line(fnd_file.log,'Mode to run : ' || to_char(i_run_option));
31: fnd_file.put_line(fnd_file.log,'Group ID option : ' || to_char(i_group_option));
32: fnd_file.put_line(fnd_file.log,'Group ID selected: ' || i_next_val);
33: fnd_file.put_line(fnd_file.log,'Cost type : '|| i_cost_type);
34: fnd_file.put_line(fnd_file.log,'Delete option : ' || to_char (i_del_option));
35: fnd_file.put_line(fnd_file.log,'---------------------------------------------');

Line 32: fnd_file.put_line(fnd_file.log,'Group ID selected: ' || i_next_val);

28: fnd_file.put_line(fnd_file.log,'---------------------------------------------');
29: fnd_file.put_line(fnd_file.log,'Option to import : ' || to_char(i_option));
30: fnd_file.put_line(fnd_file.log,'Mode to run : ' || to_char(i_run_option));
31: fnd_file.put_line(fnd_file.log,'Group ID option : ' || to_char(i_group_option));
32: fnd_file.put_line(fnd_file.log,'Group ID selected: ' || i_next_val);
33: fnd_file.put_line(fnd_file.log,'Cost type : '|| i_cost_type);
34: fnd_file.put_line(fnd_file.log,'Delete option : ' || to_char (i_del_option));
35: fnd_file.put_line(fnd_file.log,'---------------------------------------------');
36:

Line 33: fnd_file.put_line(fnd_file.log,'Cost type : '|| i_cost_type);

29: fnd_file.put_line(fnd_file.log,'Option to import : ' || to_char(i_option));
30: fnd_file.put_line(fnd_file.log,'Mode to run : ' || to_char(i_run_option));
31: fnd_file.put_line(fnd_file.log,'Group ID option : ' || to_char(i_group_option));
32: fnd_file.put_line(fnd_file.log,'Group ID selected: ' || i_next_val);
33: fnd_file.put_line(fnd_file.log,'Cost type : '|| i_cost_type);
34: fnd_file.put_line(fnd_file.log,'Delete option : ' || to_char (i_del_option));
35: fnd_file.put_line(fnd_file.log,'---------------------------------------------');
36:
37: /*check first to see if there is another request running with similar parameters */

Line 34: fnd_file.put_line(fnd_file.log,'Delete option : ' || to_char (i_del_option));

30: fnd_file.put_line(fnd_file.log,'Mode to run : ' || to_char(i_run_option));
31: fnd_file.put_line(fnd_file.log,'Group ID option : ' || to_char(i_group_option));
32: fnd_file.put_line(fnd_file.log,'Group ID selected: ' || i_next_val);
33: fnd_file.put_line(fnd_file.log,'Cost type : '|| i_cost_type);
34: fnd_file.put_line(fnd_file.log,'Delete option : ' || to_char (i_del_option));
35: fnd_file.put_line(fnd_file.log,'---------------------------------------------');
36:
37: /*check first to see if there is another request running with similar parameters */
38:

Line 35: fnd_file.put_line(fnd_file.log,'---------------------------------------------');

31: fnd_file.put_line(fnd_file.log,'Group ID option : ' || to_char(i_group_option));
32: fnd_file.put_line(fnd_file.log,'Group ID selected: ' || i_next_val);
33: fnd_file.put_line(fnd_file.log,'Cost type : '|| i_cost_type);
34: fnd_file.put_line(fnd_file.log,'Delete option : ' || to_char (i_del_option));
35: fnd_file.put_line(fnd_file.log,'---------------------------------------------');
36:
37: /*check first to see if there is another request running with similar parameters */
38:
39: select FCR.argument5 into l_req_arg

Line 55: fnd_file.put_line(fnd_file.log,fnd_message.get_string('BOM','CST_REQ_ERROR'));

51: OR (FCR.argument5 is null)
52: OR (l_req_arg is null));
53:
54: if (NVL(l_min_reqid,FND_GLOBAL.CONC_REQUEST_ID) <> FND_GLOBAL.CONC_REQUEST_ID) then
55: fnd_file.put_line(fnd_file.log,fnd_message.get_string('BOM','CST_REQ_ERROR'));
56: CONC_STATUS := fnd_concurrent.set_completion_status('ERROR',substr(fnd_message.get_string('BOM','CST_REQ_ERROR'),1,240));
57: return;
58: end if;
59:

Line 70: fnd_file.put_line(fnd_file.log,'---------------------------------------------');

66: else
67: l_grp_id := to_number(l_next_val);
68: end if;
69:
70: fnd_file.put_line(fnd_file.log,'---------------------------------------------');
71:
72: fnd_file.put_line(fnd_file.log,'Group ID selected: ' || l_grp_id);
73:
74: fnd_file.put_line(fnd_file.log,'---------------------------------------------');

Line 72: fnd_file.put_line(fnd_file.log,'Group ID selected: ' || l_grp_id);

68: end if;
69:
70: fnd_file.put_line(fnd_file.log,'---------------------------------------------');
71:
72: fnd_file.put_line(fnd_file.log,'Group ID selected: ' || l_grp_id);
73:
74: fnd_file.put_line(fnd_file.log,'---------------------------------------------');
75:
76: fnd_file.put_line(fnd_file.log,'Start time: ' || to_char(sysdate,'DD-MON-YY HH24:MI:SS'));

Line 74: fnd_file.put_line(fnd_file.log,'---------------------------------------------');

70: fnd_file.put_line(fnd_file.log,'---------------------------------------------');
71:
72: fnd_file.put_line(fnd_file.log,'Group ID selected: ' || l_grp_id);
73:
74: fnd_file.put_line(fnd_file.log,'---------------------------------------------');
75:
76: fnd_file.put_line(fnd_file.log,'Start time: ' || to_char(sysdate,'DD-MON-YY HH24:MI:SS'));
77:
78: IF i_option = 1 then

Line 76: fnd_file.put_line(fnd_file.log,'Start time: ' || to_char(sysdate,'DD-MON-YY HH24:MI:SS'));

72: fnd_file.put_line(fnd_file.log,'Group ID selected: ' || l_grp_id);
73:
74: fnd_file.put_line(fnd_file.log,'---------------------------------------------');
75:
76: fnd_file.put_line(fnd_file.log,'Start time: ' || to_char(sysdate,'DD-MON-YY HH24:MI:SS'));
77:
78: IF i_option = 1 then
79: CST_ITEM_COST_IMPORT_INTERFACE.Start_item_cost_import_process(Error_number,l_next_val,l_grp_id,i_del_option,i_cost_type,i_run_option);
80:

Line 91: fnd_file.put_line(fnd_file.log,'Exception in CST_ITEM_COST_IMPORT_INTERFACE');

87: ELSIF i_option = 4 then
88: CST_ITEM_COST_IMPORT_INTERFACE.Start_item_cost_import_process(Error_number,l_next_val,l_grp_id,i_del_option,i_cost_type,i_run_option);
89:
90: IF Error_number = 1 then
91: fnd_file.put_line(fnd_file.log,'Exception in CST_ITEM_COST_IMPORT_INTERFACE');
92: raise CST_ERROR_EXCEPTION;
93: END IF;
94:
95: CST_RES_COST_IMPORT_INTERFACE.Start_res_cost_import_process(Error_number,l_next_val,l_grp_id,i_cost_type,i_del_option,i_run_option);

Line 109: fnd_file.put_line(fnd_file.log,'End date is : ' || to_char(sysdate,'DD-MON-YY HH24:MI:SS'));

105: END IF;
106:
107: END IF;
108:
109: fnd_file.put_line(fnd_file.log,'End date is : ' || to_char(sysdate,'DD-MON-YY HH24:MI:SS'));
110:
111:
112: EXCEPTION
113: When others then

Line 115: fnd_file.put_line(fnd_file.log,'CST_START_IMP_PROCESS.Start_Process() '|| to_char(SQLCODE) || ','|| substr(SQLERRM,1,180));

111:
112: EXCEPTION
113: When others then
114: rollback;
115: fnd_file.put_line(fnd_file.log,'CST_START_IMP_PROCESS.Start_Process() '|| to_char(SQLCODE) || ','|| substr(SQLERRM,1,180));
116: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));
117:
118:
119: END Start_process;

Line 116: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));

112: EXCEPTION
113: When others then
114: rollback;
115: fnd_file.put_line(fnd_file.log,'CST_START_IMP_PROCESS.Start_Process() '|| to_char(SQLCODE) || ','|| substr(SQLERRM,1,180));
116: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));
117:
118:
119: END Start_process;
120: