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 CST_RESOURCE_COSTS

Line 25: Update CST_RESOURCE_COSTS_INTERFACE crci

21: Error_number := 0;
22: /* check for both the organization_id and code to be null */
23: fnd_file.put_line(fnd_file.log,'--------entering the validate_resource_costs procedure----------');
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)

Line 38: Update CST_RESOURCE_COSTS_INTERFACE crci

34: fnd_file.put_line(fnd_file.log,'done checking for null organization ID and code ');
35:
36: /* check to see if the input organization_id or code is valid */
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

Line 54: Update CST_RESOURCE_COSTS_INTERFACE crci

50: fnd_file.put_line(fnd_file.log,'done checking for the organization to be invalid');
51:
52: /* Get the organization_id from the code */
53:
54: Update CST_RESOURCE_COSTS_INTERFACE crci
55: SET organization_id = (select organization_id
56: FROM mtl_parameters mp
57: WHERE mp.organization_code = crci.organization_code
58: )

Line 69: Update CST_RESOURCE_COSTS_INTERFACE ct

65: **/
66:
67: l_stmt_no := 30;
68:
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(

Line 91: Update CST_RESOURCE_COSTS_INTERFACE crci

87: fnd_file.put_line(fnd_file.log,'done getting the organization_id from the code if it has not been provided');
88:
89: /* Set the unique transaction_id for each row */
90:
91: Update CST_RESOURCE_COSTS_INTERFACE crci
92: SET transaction_id = CST_ITEM_CST_DTLS_INTERFACE_S.NEXTVAL,
93: error_code =null,
94: error_explanation = null,
95: request_id = FND_GLOBAL.CONC_REQUEST_ID,

Line 111: UPDATE CST_RESOURCE_COSTS_INTERFACE crci

107: COMMIT;
108:
109: /* check for the organization to be a costing org */
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

Line 127: Update CST_RESOURCE_COSTS_INTERFACE crci

123:
124:
125: /* now set teh cost type and cost type id */
126:
127: Update CST_RESOURCE_COSTS_INTERFACE crci
128: SET crci.cost_type_id = (select cost_type_id from CST_COST_TYPES cct
129: WHERE cct.cost_type = i_new_csttype
130: ),
131: crci.cost_type = i_new_csttype

Line 141: Update CST_RESOURCE_COSTS_INTERFACE crci

137:
138:
139: /* check for resource_id and resource_code to be null */
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

Line 153: Update CST_RESOURCE_COSTS_INTERFACE crci set

149: l_stmt_no := 90;
150: fnd_file.put_line(fnd_file.log,'done checking for null sub element');
151:
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

Line 171: Update CST_RESOURCE_COSTS_INTERFACE crci set

167:
168: l_stmt_no := 100;
169:
170:
171: Update CST_RESOURCE_COSTS_INTERFACE crci set
172: crci.resource_id = (select bm.resource_id from bom_resources bm
173: WHERE bm.resource_code = crci.resource_code
174: AND (bm.cost_element_id = 3 or bm.cost_element_id = 4)
175: AND bm.functional_currency_flag <> 1

Line 186: Update CST_RESOURCE_COSTS_INTERFACE crci

182: l_stmt_no := 105;
183:
184: /* check for the validity date of the resource_id */
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

Line 204: UPDATE CST_RESOURCE_COSTS_INTERFACE crci

200:
201:
202: /* check for the resource rate that is provided to be not null */
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

Line 213: Update CST_RESOURCE_COSTS_INTERFACE crci

209: and crci.error_flag is null
210: and crci.group_id = SEQ_NEXTVAL;
211:
212:
213: Update CST_RESOURCE_COSTS_INTERFACE crci
214: set process_flag = 3
215: WHERE process_flag = 2
216: AND group_id = SEQ_NEXTVAL
217: AND error_flag is null;

Line 223: Update cst_resource_costs_interface crci

219: COMMIT;
220:
221: /* check for the duplicate rows in the interface table*/
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

Line 229: AND EXISTS (select 1 from cst_resource_costs_interface crci2

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
231: AND crci.organization_id = crci2.organization_id
232: AND crci.cost_type_id = crci2.cost_type_id
233: AND crci.rowid <> crci2.rowid

Line 238: Update CST_RESOURCE_COSTS_INTERFACE crci

234: AND crci2.group_id = SEQ_NEXTVAL);
235:
236: fnd_file.put_line(fnd_file.log,'done checking for duplicate rows');
237:
238: Update CST_RESOURCE_COSTS_INTERFACE crci
239: set process_flag = 4
240: WHERE crci.process_flag = 3
241: AND crci.error_flag is null
242: AND crci.group_id = SEQ_NEXTVAL;

Line 248: /* Now begin inserting rows into CST_RESOURCE_COSTS */

244: COMMIT;
245:
246: l_stmt_no := 110;
247:
248: /* Now begin inserting rows into CST_RESOURCE_COSTS */
249:
250: /* first check the run option */
251:
252: if i_run_option = 2 then

Line 255: Delete from CST_RESOURCE_COSTS crc

251:
252: if i_run_option = 2 then
253: l_stmt_no := 115;
254:
255: Delete from CST_RESOURCE_COSTS crc
256: where EXISTS (select 1 from CST_RESOURCE_COSTS_INTERFACE crci
257: where crci.organization_id = crc.organization_id
258: AND crci.cost_type_id = crc.cost_type_id
259: AND crci.resource_id = crc.resource_id

Line 256: where EXISTS (select 1 from CST_RESOURCE_COSTS_INTERFACE crci

252: if i_run_option = 2 then
253: l_stmt_no := 115;
254:
255: Delete from CST_RESOURCE_COSTS crc
256: where EXISTS (select 1 from CST_RESOURCE_COSTS_INTERFACE crci
257: where crci.organization_id = crc.organization_id
258: AND crci.cost_type_id = crc.cost_type_id
259: AND crci.resource_id = crc.resource_id
260: AND crci.error_flag is null

Line 265: UPDATE CST_RESOURCE_COSTS_INTERFACE crci set

261: AND crci.group_id = SEQ_NEXTVAL);
262:
263: elsif i_run_option = 1 then
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

Line 271: AND EXISTS (Select 1 from CST_RESOURCE_COSTS crc

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
273: AND crc.cost_type_id = crci.cost_type_id
274: AND crc.resource_id = crci.resource_id
275: );

Line 282: INSERT INTO CST_RESOURCE_COSTS(Resource_id,

278:
279: l_stmt_no := 117;
280:
281:
282: INSERT INTO CST_RESOURCE_COSTS(Resource_id,
283: cost_type_id,
284: last_update_date,
285: last_updated_by,
286: creation_date,

Line 338: FROM CST_RESOURCE_COSTS_INTERFACE

334: attribute12,
335: attribute13,
336: attribute14,
337: attribute15
338: FROM CST_RESOURCE_COSTS_INTERFACE
339: WHERE error_flag is null
340: AND group_id = SEQ_NEXTVAL;
341: fnd_file.put_line(fnd_file.log,'done inserting ' || to_char(SQL%ROWCOUNT) ||' rows into CST_RESOURCE_COSTS');
342:

Line 341: fnd_file.put_line(fnd_file.log,'done inserting ' || to_char(SQL%ROWCOUNT) ||' rows into CST_RESOURCE_COSTS');

337: attribute15
338: FROM CST_RESOURCE_COSTS_INTERFACE
339: WHERE error_flag is null
340: AND group_id = SEQ_NEXTVAL;
341: fnd_file.put_line(fnd_file.log,'done inserting ' || to_char(SQL%ROWCOUNT) ||' rows into CST_RESOURCE_COSTS');
342:
343: l_stmt_no := 120;
344:
345: UPDATE CST_RESOURCE_COSTS_INTERFACE

Line 345: UPDATE CST_RESOURCE_COSTS_INTERFACE

341: fnd_file.put_line(fnd_file.log,'done inserting ' || to_char(SQL%ROWCOUNT) ||' rows into CST_RESOURCE_COSTS');
342:
343: l_stmt_no := 120;
344:
345: UPDATE CST_RESOURCE_COSTS_INTERFACE
346: set process_flag = 5
347: where process_flag = 4
348: and error_flag is null
349: and group_id = SEQ_NEXTVAL;

Line 352: delete from CST_RESOURCE_COSTS_INTERFACE

348: and error_flag is null
349: and group_id = SEQ_NEXTVAL;
350:
351: IF i_del_option = 1 then
352: delete from CST_RESOURCE_COSTS_INTERFACE
353: WHERE process_flag = 5
354: AND error_flag is null
355: AND group_id = SEQ_NEXTVAL;
356:

Line 389: UPDATE CST_RESOURCE_COSTS_INTERFACE crci

385: CST_STOP_EXCEPTION EXCEPTION;
386: i_count NUMBER;
387: BEGIN
388: IF i_Next_value is null then
389: UPDATE CST_RESOURCE_COSTS_INTERFACE crci
390: SET group_id = i_grp_id
391: where process_flag = 1
392: AND error_flag is null;
393: END IF;

Line 396: FROM CST_RESOURCE_COSTS_INTERFACE crci

392: AND error_flag is null;
393: END IF;
394:
395: Select count(*) into l_crci_count
396: FROM CST_RESOURCE_COSTS_INTERFACE crci
397: where crci.group_id = i_grp_id
398: AND crci.error_flag is null
399: AND crci.process_flag = 1
400: AND rownum =1;

Line 403: fnd_file.put_line(fnd_file.log,'no rows to process in CST_RESOURCE_COSTS_INTERFACE,quitting.....');

399: AND crci.process_flag = 1
400: AND rownum =1;
401:
402: If l_crci_count = 0 then
403: fnd_file.put_line(fnd_file.log,'no rows to process in CST_RESOURCE_COSTS_INTERFACE,quitting.....');
404: return;
405: end If;
406:
407: Validate_resource_costs(Err,i_grp_id,i_cst_type,i_del_option,i_run_option);

Line 414: select count(*) into i_count from CST_RESOURCE_COSTS_INTERFACE

410: Error_number := 1;
411: raise CST_STOP_EXCEPTION;
412: END IF;
413:
414: select count(*) into i_count from CST_RESOURCE_COSTS_INTERFACE
415: where group_id = i_grp_id
416: and error_flag ='E';
417:
418: IF i_count > 0 then