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_ITEM_COST_IMPORT_INTERFACE dependencies on FND_MESSAGE

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

28:
29: Update CST_ITEM_CST_DTLS_INTERFACE ct
30: SET error_flag = 'E',
31: error_code = 'CST_NULL_ORGANIZATION',
32: error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_ORGANIZATION'),1,240)
33: where (Organization_id is null AND organization_code is null)
34: AND error_flag is null
35: AND ct.group_id = SEQ_NEXTVAL;
36:

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

41:
42: Update CST_ITEM_CST_DTLS_INTERFACE ct
43: SET error_flag = 'E',
44: error_code = 'CST_INVALID_ORGANIZATION',
45: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ORGANIZATION'),1,240)
46: WHERE ct.error_flag is null
47: AND ct.group_id = SEQ_NEXTVAL
48: AND NOT EXISTS (select 1 from mtl_parameters mp
49: where (NVL(ct.organization_id,mp.organization_id) = mp.organization_id)

Line 79: substrb(fnd_message.get_string(

75: Update CST_ITEM_CST_DTLS_INTERFACE ct
76: SET error_flag = 'E',
77: error_code = 'CST_PROCESS_ORG_ERROR',
78: error_explanation =
79: substrb(fnd_message.get_string(
80: 'GMF','GMF_PROCESS_ORG_ERROR'),1,240)
81: WHERE ct.error_flag is null
82: AND ct.group_id = SEQ_NEXTVAL
83: AND EXISTS (select 'This is a process manufacturing org'

Line 117: ct.error_explanation = substrb(fnd_message.get_string('BOM','CST_NOT_COSTINGORG'),1,240)

113:
114: UPDATE CST_ITEM_CST_DTLS_INTERFACE ct
115: SET ct.error_flag ='E',
116: ct.error_code = 'CST_NOT_COSTINGORG',
117: ct.error_explanation = substrb(fnd_message.get_string('BOM','CST_NOT_COSTINGORG'),1,240)
118: WHERE ct.group_id = SEQ_NEXTVAL
119: AND ct.error_flag is null
120: AND EXISTS (Select 1 from MTL_PARAMETERS mp
121: WHERE mp.cost_organization_id <> mp.organization_id

Line 131: error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_ITEMID'),1,240)

127: /* check to see if the user has input a valid inventory_item_id */
128: Update CST_ITEM_CST_DTLS_INTERFACE ct set
129: error_flag = 'E',
130: error_code = 'CST_NULL_ITEMID',
131: error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_ITEMID'),1,240)
132: where group_id = SEQ_NEXTVAL
133: AND error_flag is null
134: AND inventory_item_id is null;
135:

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

140: /* check to see if the user has input a valid inventory_item_id */
141: Update CST_ITEM_CST_DTLS_INTERFACE ct set
142: error_flag = 'E',
143: error_code = 'CST_INVALID_ITEM_ID',
144: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ITEMID'),1,240)
145: where group_id = SEQ_NEXTVAL
146: AND error_flag is null
147: AND NOT EXISTS (select 1 from mtl_system_items msi
148: where ct.organization_id = msi.organization_id

Line 167: ct.error_explanation = substrb(fnd_message.get_string('BOM','CST_NOT_INVASSITEM'),1,240)

163:
164: Update CST_ITEM_CST_DTLS_INTERFACE ct
165: set ct.error_flag='E',
166: ct.error_code = 'CST_NOT_INVASSITEM',
167: ct.error_explanation = substrb(fnd_message.get_string('BOM','CST_NOT_INVASSITEM'),1,240)
168: WHERE ct.error_flag is null
169: AND ct.group_id = SEQ_NEXTVAL
170: AND ct.inventory_asset_flag <> 1 ;
171:

Line 184: error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_COSTELEMENT'),1,240)

180:
181: Update CST_ITEM_CST_DTLS_INTERFACE
182: SET error_flag = 'E',
183: error_code = 'CST_NULL_COSTELEMENT',
184: error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_COSTELEMENT'),1,240)
185: where (cost_element_id is null AND cost_element is null)
186: AND group_id = SEQ_NEXTVAL
187: AND error_flag is null;
188:

Line 199: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_COSTELEMENT'),1,240)

195:
196: Update CST_ITEM_CST_DTLS_INTERFACE ct set
197: error_flag = 'E',
198: error_code = 'CST_INVALID_COSTELEMENT',
199: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_COSTELEMENT'),1,240)
200: WHERE group_id = SEQ_NEXTVAL
201: AND error_flag is null
202: AND NOT EXISTS( Select 1 from cst_cost_elements cce where
203: NVL(ct.cost_element_id,cce.cost_element_id)= cce.cost_element_id AND NVL(ct.cost_element,cce.cost_element) = cce.cost_element

Line 229: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_SUBELEMENT'),1,240)

225:
226: Update CST_ITEM_CST_DTLS_INTERFACE ct set
227: error_flag = 'E',
228: error_code = 'CST_INVALID_SUBELEMENT',
229: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_SUBELEMENT'),1,240)
230: WHERE error_flag is null
231: AND ct.group_id = SEQ_NEXTVAL
232: AND (ct.resource_id is NOT NULL OR ct.resource_code is not null)
233: AND NOT EXISTS (select 1 from bom_resources bm

Line 264: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ACTIVITY'),1,240)

260:
261: Update CST_ITEM_CST_DTLS_INTERFACE ct set
262: error_flag = 'E',
263: error_code = 'CST_INVALID_ACTIVITY',
264: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ACTIVITY'),1,240)
265: WHERE group_id = SEQ_NEXTVAL
266: AND ((ct.activity_id is not null ) OR (ct.activity is not null))
267: AND error_flag is null
268: AND NOT EXISTS( Select 1 from cst_activities ca where

Line 308: error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_DEFSUBELEMENT'),1,240)

304:
305: Update CST_ITEM_CST_DTLS_INTERFACE ct set
306: error_flag = 'E',
307: error_code = 'CST_NULL_DEFSUBELEMENT',
308: error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_DEFSUBELEMENT'),1,240)
309: WHERE error_flag is null
310: AND ct.group_id = SEQ_NEXTVAL
311: and resource_id is null;
312:

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

316:
317: Update CST_ITEM_CST_DTLS_INTERFACE ct
318: set ct.error_flag = 'E',
319: ct.error_code = 'CST_EXP_SUBELEMENT',
320: ct.error_explanation = substrb(fnd_message.get_string('BOM','CST_EXP_SUBELEMENT'),1,240)
321: where ct.error_flag is null
322: AND ct.group_id = SEQ_NEXTVAL
323: AND EXISTS (select 1 from BOM_RESOURCES bm
324: where bm.organization_id = ct.organization_id

Line 339: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_FUNCCODE'),1,240)

335:
336: Update CST_ITEM_CST_DTLS_INTERFACE ct
337: set error_flag = 'E',
338: error_code = 'CST_INVALID_FUNCCODE',
339: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_FUNCCODE'),1,240)
340: WHERE error_flag is null
341: AND ct.group_id = SEQ_NEXTVAL
342: AND ct.cost_element_id IN (3,4)
343: AND NOT EXISTS (select 1 from bom_resources bm

Line 373: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));

369: EXCEPTION
370:
371: when others then
372: rollback;
373: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));
374: fnd_file.put_line(fnd_file.log,'CICDI validate_phase1(' || to_char(l_stmt_no) || '),' || to_char(SQLCODE) || ',' || substr(SQLERRM,1,180));
375: Error_number := 1;
376:
377: END validate_phase1;

Line 398: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ROLLUP_SRC_TYPE'),1,240)

394:
395: Update CST_ITEM_CST_DTLS_INTERFACE ct set
396: Error_flag = 'E',
397: error_code = 'CST_INVALID_ROLLUP_SRC_TYPE',
398: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ROLLUP_SRC_TYPE'),1,240)
399: where rollup_source_type <> 1
400: AND ct.error_flag is null
401: AND ct.group_id = SEQ_NEXTVAL;
402:

Line 411: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_LEVELTYPE'),1,240)

407:
408: UPDATE CST_ITEM_CST_DTLS_INTERFACE ct set
409: Error_flag = 'E',
410: error_code = 'CST_INVALID_LEVELTYPE',
411: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_LEVELTYPE'),1,240)
412: where level_type <> 1
413: AND ct.error_flag is null
414: AND ct.group_id = SEQ_NEXTVAL;
415:

Line 424: Error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_USAGERTORAMT'),1,240)

420: /* checking for the Usage rate or amount to be not null */
421: UPDATE CST_ITEM_CST_DTLS_INTERFACE ct set
422: Error_flag = 'E',
423: error_code = 'CST_NULL_USAGERTORAMT',
424: Error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_USAGERTORAMT'),1,240)
425: where error_flag is null
426: AND Usage_rate_or_amount is null
427: AND group_id = SEQ_NEXTVAL;
428:

Line 441: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_BASISTYPE'),1,240)

437:
438: Update CST_ITEM_CST_DTLS_INTERFACE ct set
439: Error_flag = 'E',
440: error_code = 'CST_INVALID_BASISTYPE',
441: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_BASISTYPE'),1,240)
442: where ((ct.cost_element_id IN (1,3,4,5,6) AND ct.basis_type NOT IN (1,2)) OR (ct.cost_element_id = 2 AND (ct.basis_type <= 0 OR ct.basis_type > 6)))
443: AND ct.error_flag is null
444: AND ct.group_id = SEQ_NEXTVAL;
445:

Line 455: error_explanation = substrb(fnd_message.get_string('BOM','CST_NO_ITORACUNITS'),1,240)

451:
452: Update CST_ITEM_CST_DTLS_INTERFACE ct set
453: Error_flag = 'E',
454: error_code ='CST_NO_ITORACUNITS',
455: error_explanation = substrb(fnd_message.get_string('BOM','CST_NO_ITORACUNITS'),1,240)
456: where ct.basis_type = 6
457: AND (ct.activity_units is null OR ct.item_units is null OR ct.item_units = 0)
458: AND ct.error_flag is null
459: AND ct.group_id = SEQ_NEXTVAL;

Line 469: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_SHRRATE'),1,240)

465:
466: Update CST_ITEM_CST_DTLS_INTERFACE ct set
467: error_flag = 'E',
468: error_code = 'CST_INVALID_SHRRATE',
469: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_SHRRATE'),1,240)
470: where (ct.shrinkage_rate < 0 OR ct.shrinkage_rate >= 1)
471: AND ct.error_flag is null
472: AND ct.group_id = SEQ_NEXTVAL;
473:

Line 481: error_explanation = substrb(fnd_message.get_string('BOM','CST_ZERO_LOTSIZE'),1,240)

477: /* check for the lot_size to be > 0 */
478: Update CST_ITEM_CST_DTLS_INTERFACE ct set
479: error_flag = 'E',
480: error_code = 'CST_ZERO_LOTSIZE',
481: error_explanation = substrb(fnd_message.get_string('BOM','CST_ZERO_LOTSIZE'),1,240)
482: where error_flag is null
483: AND group_id = SEQ_NEXTVAL
484: AND ct.lot_size <= 0;
485:

Line 490: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_BASEDONRLP'),1,240)

486: /*this checks for the based on rollup flag to be 1 or 2 */
487: Update CST_ITEM_CST_DTLS_INTERFACE ct set
488: error_flag = 'E',
489: error_code = 'CST_INVALID_BASEDONRLP',
490: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_BASEDONRLP'),1,240)
491: where ct.based_on_rollup_flag NOT IN (1,2)
492: AND ct.error_flag is null
493: AND ct.group_id = SEQ_NEXTVAL;
494:

Line 502: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_INVASSETFLG'),1,240)

498: /* this checks for the inventory asset flag to be 1 or 2 */
499: Update CST_ITEM_CST_DTLS_INTERFACE ct set
500: error_flag = 'E',
501: error_code = 'CST_INVALID_INVASSETFLG',
502: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_INVASSETFLG'),1,240)
503: where ct.inventory_asset_flag NOT IN (1,2)
504: AND ct.error_flag is null
505: AND ct.group_id = SEQ_NEXTVAL;
506:

Line 513: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_RESRATE'),1,240)

509:
510: UPDATE CST_ITEM_CST_DTLS_INTERFACE set
511: error_flag = 'E',
512: error_code = 'CST_INVALID_RESRATE',
513: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_RESRATE'),1,240)
514: where error_flag is null
515: AND group_id = SEQ_NEXTVAL
516: AND ((resource_rate <> 1) AND (resource_rate is not null));
517:

Line 525: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_BUYITEM'),1,240)

521:
522: Update CST_ITEM_CST_DTLS_INTERFACE ct set
523: error_flag = 'E',
524: error_code = 'CST_INVALID_BUYITEM',
525: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_BUYITEM'),1,240)
526: where ct.based_on_rollup_flag <> 1
527: AND ct.shrinkage_rate <> 0
528: AND ct.error_flag is null
529: AND ct.group_id = SEQ_NEXTVAL;

Line 539: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_CICFLAGS'),1,240)

535:
536: Update CST_ITEM_CST_DTLS_INTERFACE ct1 set
537: Error_flag = 'E',
538: error_code = 'CST_INVALID_CICFLAGS',
539: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_CICFLAGS'),1,240)
540: where EXISTS (select 1 from CST_ITEM_CST_DTLS_INTERFACE ct2 where
541: ((NVL(ct1.based_on_rollup_flag,-1)<> NVL(ct2.based_on_rollup_flag,-1))
542: OR (NVL(ct1.shrinkage_rate,-1) <> NVL(ct2.shrinkage_rate,-1))
543: OR (NVL(ct1.inventory_asset_flag,-1) <> NVL(ct2.inventory_asset_flag,-1))

Line 565: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ROWS'),1,240)

561:
562: Update CST_ITEM_CST_DTLS_INTERFACE ct1
563: set ERROR_FLAG ='E',
564: error_code = 'CST_INVALID_ROWS',
565: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ROWS'),1,240)
566: WHERE EXISTS ( select 1 from CST_ITEM_CST_DTLS_INTERFACE ct2
567: WHERE ct1.organization_id = ct2.organization_id
568: AND ct1.inventory_item_id = ct2.inventory_item_id
569: AND ct1.cost_type_id = ct2.cost_type_id

Line 593: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));

589: when others then
590: rollback;
591: fnd_file.put_line(fnd_file.log,'CICDI table validate_phase2(' || to_char(l_stmt_no) || '),' || to_char(SQLCODE) || ',' || substr(SQLERRM,1,180));
592:
593: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));
594: Error_number := 1;
595:
596: END validate_phase2;
597:

Line 642: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_DEFCSTTYPE'),1,240)

638: /*check for the default cost type to be valid for all the or/item combo */
639: Update CST_ITEM_CST_DTLS_INTERFACE ct set
640: error_flag ='E',
641: error_code = 'CST_INVALID_DEFCSTTYPE',
642: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_DEFCSTTYPE'),1,240)
643: where
644: ct.error_flag is null
645: and ct.group_id = SEQ_NEXTVAL
646: and NOT EXISTS (select 1 from cst_item_costs cic where

Line 692: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));

688: when others then
689: rollback;
690: fnd_file.put_line(fnd_file.log,'CICDI insert_csttype_and_def('|| to_char(l_stmt_no) || '),' || to_char(SQLCODE) || ',' || substr(SQLERRM,1,180));
691:
692: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));
693: Error_number := 1;
694:
695: END insert_csttype_and_def;
696:

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

840:
841: UPDATE CST_ITEM_CST_DTLS_INTERFACE ct set
842: ct.error_flag ='E',
843: ct.error_code = 'CST_CANT_INSERT',
844: ct.error_explanation = substrb(fnd_message.get_string('BOM','CST_CANT_INSERT'),1,240)
845: WHERE ct.error_flag is null
846: AND ct.group_id = SEQ_NEXTVAL
847: AND EXISTS(Select 1 from cst_item_costs cic
848: WHERE ct.organization_id = cic.organization_id

Line 1103: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));

1099: when others then
1100: rollback;
1101: fnd_file.put_line(fnd_file.log,'CICD/CICDI table insert_cic_cicd(' || to_char(l_stmt_no) || '),' || to_char(SQLCODE) || ',' || substr(SQLERRM,1,180));
1102:
1103: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));
1104: Error_number := 1;
1105:
1106: END insert_cic_cicd;
1107:

Line 1174: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CICDI')));

1170: where group_id = i_grp_id
1171: and error_flag = 'E';
1172:
1173: If (i_count > 0) then
1174: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CICDI')));
1175: CONC_REQUEST := fnd_concurrent.set_completion_status('WARNING',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
1176: END IF;
1177:
1178: fnd_file.put_line(fnd_file.log,'done with item costs import, quitting');

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

1171: and error_flag = 'E';
1172:
1173: If (i_count > 0) then
1174: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CICDI')));
1175: CONC_REQUEST := fnd_concurrent.set_completion_status('WARNING',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
1176: END IF;
1177:
1178: fnd_file.put_line(fnd_file.log,'done with item costs import, quitting');
1179: EXCEPTION

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

1180: when others then
1181: rollback;
1182: fnd_file.put_line(fnd_file.log,'Start_item_cost_import_process(), Invalid Exception Occured');
1183:
1184: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
1185: Error_number := 1;
1186: END Start_item_cost_import_process;
1187:
1188: END CST_ITEM_COST_IMPORT_INTERFACE;