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.CST_RES_COST_IMPORT_INTERFACE dependencies on FND_MESSAGE

Line 28: error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_ORGANIZATION'),1,240)

24:
25: Update CST_RESOURCE_COSTS_INTERFACE crci
26: SET error_flag = 'E',
27: error_code = 'CST_NULL_ORGANIZATION',
28: error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_ORGANIZATION'),1,240)
29: where (Organization_id is null AND organization_code is null)
30: AND error_flag is null
31: AND crci.group_id = SEQ_NEXTVAL;
32:

Line 41: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ORGANIZATION'),1,240)

37:
38: Update CST_RESOURCE_COSTS_INTERFACE crci
39: SET error_flag = 'E',
40: error_code = 'CST_INVALID_ORGANIZATION',
41: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ORGANIZATION'),1,240)
42: WHERE crci.error_flag is null
43: AND crci.group_id = SEQ_NEXTVAL
44: AND NOT EXISTS (select 1 from mtl_parameters mp
45: where NVL(crci.organization_id,mp.organization_id) = mp.organization_id

Line 73: substrb(fnd_message.get_string(

69: Update CST_RESOURCE_COSTS_INTERFACE ct
70: SET error_flag = 'E',
71: error_code = 'CST_PROCESS_ORG_ERROR',
72: error_explanation =
73: substrb(fnd_message.get_string(
74: 'GMF','GMF_PROCESS_ORG_ERROR'),1,240)
75: WHERE ct.error_flag is null
76: AND ct.group_id = SEQ_NEXTVAL
77: AND EXISTS (select 'This is a process manufacturing org'

Line 114: crci.Error_explanation = substrb(fnd_message.get_string('BOM','CST_NOT_COSTINGORG'),1,240)

110:
111: UPDATE CST_RESOURCE_COSTS_INTERFACE crci
112: set crci.Error_flag = 'E',
113: crci.Error_code = 'CST_NOT_COSTINGORG',
114: crci.Error_explanation = substrb(fnd_message.get_string('BOM','CST_NOT_COSTINGORG'),1,240)
115: WHERE crci.group_id = SEQ_NEXTVAL
116: AND crci.error_flag is null
117: AND EXISTS ( Select 1 from mtl_parameters mp
118: WHERE mp.cost_organization_id <> mp.organization_id

Line 144: crci.error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_SUBELEMENT'),1,240)

140:
141: Update CST_RESOURCE_COSTS_INTERFACE crci
142: SET crci.error_flag = 'E',
143: crci.error_code = 'CST_NULL_SUBELEMENT',
144: crci.error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_SUBELEMENT'),1,240)
145: WHERE crci.error_flag is null
146: AND crci.group_id = SEQ_NEXTVAL
147: AND (crci.resource_id is null AND crci.resource_code is null);
148:

Line 156: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_RESOURCE'),1,240)

152: /* check if the entered resource_id or code is actually valid and also that functional currency flag is not = 1 */
153: Update CST_RESOURCE_COSTS_INTERFACE crci set
154: error_flag = 'E',
155: error_code = 'CST_INVALID_RESOURCE',
156: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_RESOURCE'),1,240)
157: WHERE crci.error_flag is null
158: AND crci.group_id = SEQ_NEXTVAL
159: AND NOT EXISTS (select 1 from bom_resources bm
160: WHERE NVL(crci.resource_id,bm.resource_id)=bm.resource_id

Line 189: crci.error_explanation = substrb(fnd_message.get_string('BOM','CST_EXP_SUBELEMENT'),1,240)

185:
186: Update CST_RESOURCE_COSTS_INTERFACE crci
187: set crci.error_flag = 'E',
188: crci.error_code = 'CST_EXP_SUBELEMENT',
189: crci.error_explanation = substrb(fnd_message.get_string('BOM','CST_EXP_SUBELEMENT'),1,240)
190: where crci.error_flag is null
191: AND crci.group_id = SEQ_NEXTVAL
192: AND EXISTS ( select 1 from BOM_RESOURCES bm
193: WHERE bm.organization_id = crci.organization_id

Line 207: error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_RESRT'),1,240)

203:
204: UPDATE CST_RESOURCE_COSTS_INTERFACE crci
205: set error_flag = 'E',
206: error_code = 'CST_NULL_RESRT',
207: error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_RESRT'),1,240)
208: where crci.resource_rate is null
209: and crci.error_flag is null
210: and crci.group_id = SEQ_NEXTVAL;
211:

Line 226: crci.error_explanation = substrb(fnd_message.get_string('BOM','CST_DUPL_ROWS'),1,240)

222:
223: Update cst_resource_costs_interface crci
224: set crci.error_flag = 'E',
225: crci.error_code = 'CST_DUPL_ROWS',
226: crci.error_explanation = substrb(fnd_message.get_string('BOM','CST_DUPL_ROWS'),1,240)
227: where crci.error_flag is null
228: AND crci.group_id = SEQ_NEXTVAL
229: AND EXISTS (select 1 from cst_resource_costs_interface crci2
230: WHERE crci.resource_id = crci2.resource_id

Line 268: error_explanation = substrb(fnd_message.get_string('BOM','CST_CANT_INSERT'),1,240)

264:
265: UPDATE CST_RESOURCE_COSTS_INTERFACE crci set
266: error_flag ='E',
267: error_code = 'CST_CANT_INSERT',
268: error_explanation = substrb(fnd_message.get_string('BOM','CST_CANT_INSERT'),1,240)
269: where crci.error_flag is null
270: AND crci.group_id = SEQ_NEXTVAL
271: AND EXISTS (Select 1 from CST_RESOURCE_COSTS crc
272: where crc.organization_id = crci.organization_id

Line 368: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));

364: when others then
365: rollback;
366: fnd_file.put_line(fnd_file.log,'Validate_resource_costs(' || to_char(l_stmt_no) ||'),' || to_char(SQLCODE) || ',' || substr(SQLERRM,1,180));
367: Error_number := 1;
368: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
369:
370: END Validate_resource_costs;
371:
372: /*This procedure Start_res_cost_import_process is the Starting point for the process and calls the appropriate procedures after verifying that there are rows to process in the interface table */

Line 419: CONC_REQUEST := fnd_concurrent.set_completion_status('WARNING',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));

415: where group_id = i_grp_id
416: and error_flag ='E';
417:
418: IF i_count > 0 then
419: CONC_REQUEST := fnd_concurrent.set_completion_status('WARNING',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
420: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CRCI')));
421: END IF;
422:
423: EXCEPTION

Line 420: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CRCI')));

416: and error_flag ='E';
417:
418: IF i_count > 0 then
419: CONC_REQUEST := fnd_concurrent.set_completion_status('WARNING',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
420: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CRCI')));
421: END IF;
422:
423: EXCEPTION
424: when others then

Line 427: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));

423: EXCEPTION
424: when others then
425: rollback;
426: fnd_file.put_line(fnd_file.log,'CST_RES_IMPORT_PROCESS.Start_res_cost_import_process() Exception occured');
427: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
428:
429:
430: END Start_res_cost_import_process;
431: