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: OR EXISTS(select 1 from mtl_system_items msi

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

185:
186: Update CST_ITEM_CST_DTLS_INTERFACE
187: SET error_flag = 'E',
188: error_code = 'CST_NULL_COSTELEMENT',
189: error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_COSTELEMENT'),1,240)
190: where (cost_element_id is null AND cost_element is null)
191: AND group_id = SEQ_NEXTVAL
192: AND error_flag is null;
193:

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

200:
201: Update CST_ITEM_CST_DTLS_INTERFACE ct set
202: error_flag = 'E',
203: error_code = 'CST_INVALID_COSTELEMENT',
204: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_COSTELEMENT'),1,240)
205: WHERE group_id = SEQ_NEXTVAL
206: AND error_flag is null
207: AND NOT EXISTS( Select 1 from cst_cost_elements cce where
208: 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 234: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_SUBELEMENT'),1,240)

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

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

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

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

309:
310: Update CST_ITEM_CST_DTLS_INTERFACE ct set
311: error_flag = 'E',
312: error_code = 'CST_NULL_DEFSUBELEMENT',
313: error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_DEFSUBELEMENT'),1,240)
314: WHERE error_flag is null
315: AND ct.group_id = SEQ_NEXTVAL
316: and resource_id is null;
317:

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

321:
322: Update CST_ITEM_CST_DTLS_INTERFACE ct
323: set ct.error_flag = 'E',
324: ct.error_code = 'CST_EXP_SUBELEMENT',
325: ct.error_explanation = substrb(fnd_message.get_string('BOM','CST_EXP_SUBELEMENT'),1,240)
326: where ct.error_flag is null
327: AND ct.group_id = SEQ_NEXTVAL
328: AND EXISTS (select 1 from BOM_RESOURCES bm
329: where bm.organization_id = ct.organization_id

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

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

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

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

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

399:
400: Update CST_ITEM_CST_DTLS_INTERFACE ct set
401: Error_flag = 'E',
402: error_code = 'CST_INVALID_ROLLUP_SRC_TYPE',
403: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ROLLUP_SRC_TYPE'),1,240)
404: where rollup_source_type <> 1
405: AND ct.error_flag is null
406: AND ct.group_id = SEQ_NEXTVAL;
407:

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

412:
413: UPDATE CST_ITEM_CST_DTLS_INTERFACE ct set
414: Error_flag = 'E',
415: error_code = 'CST_INVALID_LEVELTYPE',
416: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_LEVELTYPE'),1,240)
417: where level_type <> 1
418: AND ct.error_flag is null
419: AND ct.group_id = SEQ_NEXTVAL;
420:

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

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

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

442:
443: Update CST_ITEM_CST_DTLS_INTERFACE ct set
444: Error_flag = 'E',
445: error_code = 'CST_INVALID_BASISTYPE',
446: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_BASISTYPE'),1,240)
447: 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)))
448: AND ct.error_flag is null
449: AND ct.group_id = SEQ_NEXTVAL;
450:

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

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

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

470:
471: Update CST_ITEM_CST_DTLS_INTERFACE ct set
472: error_flag = 'E',
473: error_code = 'CST_INVALID_SHRRATE',
474: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_SHRRATE'),1,240)
475: where (ct.shrinkage_rate < 0 OR ct.shrinkage_rate >= 1)
476: AND ct.error_flag is null
477: AND ct.group_id = SEQ_NEXTVAL;
478:

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

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

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

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

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

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

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

514:
515: UPDATE CST_ITEM_CST_DTLS_INTERFACE set
516: error_flag = 'E',
517: error_code = 'CST_INVALID_RESRATE',
518: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_RESRATE'),1,240)
519: where error_flag is null
520: AND group_id = SEQ_NEXTVAL
521: AND ((resource_rate <> 1) AND (resource_rate is not null));
522:

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

526:
527: Update CST_ITEM_CST_DTLS_INTERFACE ct set
528: error_flag = 'E',
529: error_code = 'CST_INVALID_BUYITEM',
530: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_BUYITEM'),1,240)
531: where ct.based_on_rollup_flag <> 1
532: AND ct.shrinkage_rate <> 0
533: AND ct.error_flag is null
534: AND ct.group_id = SEQ_NEXTVAL;

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

540:
541: Update CST_ITEM_CST_DTLS_INTERFACE ct1 set
542: Error_flag = 'E',
543: error_code = 'CST_INVALID_CICFLAGS',
544: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_CICFLAGS'),1,240)
545: where EXISTS (select 1 from CST_ITEM_CST_DTLS_INTERFACE ct2 where
546: ((NVL(ct1.based_on_rollup_flag,-1)<> NVL(ct2.based_on_rollup_flag,-1))
547: OR (NVL(ct1.shrinkage_rate,-1) <> NVL(ct2.shrinkage_rate,-1))
548: OR (NVL(ct1.inventory_asset_flag,-1) <> NVL(ct2.inventory_asset_flag,-1))

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

566:
567: Update CST_ITEM_CST_DTLS_INTERFACE ct1
568: set ERROR_FLAG ='E',
569: error_code = 'CST_INVALID_ROWS',
570: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ROWS'),1,240)
571: WHERE EXISTS ( select 1 from CST_ITEM_CST_DTLS_INTERFACE ct2
572: WHERE ct1.organization_id = ct2.organization_id
573: AND ct1.inventory_item_id = ct2.inventory_item_id
574: AND ct1.cost_type_id = ct2.cost_type_id

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

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

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

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

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

693: when others then
694: rollback;
695: fnd_file.put_line(fnd_file.log,'CICDI insert_csttype_and_def('|| to_char(l_stmt_no) || '),' || to_char(SQLCODE) || ',' || substr(SQLERRM,1,180));
696:
697: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));
698: Error_number := 1;
699:
700: END insert_csttype_and_def;
701:

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

845:
846: UPDATE CST_ITEM_CST_DTLS_INTERFACE ct set
847: ct.error_flag ='E',
848: ct.error_code = 'CST_CANT_INSERT',
849: ct.error_explanation = substrb(fnd_message.get_string('BOM','CST_CANT_INSERT'),1,240)
850: WHERE ct.error_flag is null
851: AND ct.group_id = SEQ_NEXTVAL
852: AND EXISTS(Select 1 from cst_item_costs cic
853: WHERE ct.organization_id = cic.organization_id

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

1055: when others then
1056: rollback;
1057: 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));
1058:
1059: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));
1060: Error_number := 1;
1061:
1062: END insert_cic_cicd;
1063:

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

1125: where group_id = i_grp_id
1126: and error_flag = 'E';
1127:
1128: If (i_count > 0) then
1129: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CICDI')));
1130: CONC_REQUEST := fnd_concurrent.set_completion_status('WARNING',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
1131: END IF;
1132:
1133: fnd_file.put_line(fnd_file.log,'done with item costs import, quitting');

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

1126: and error_flag = 'E';
1127:
1128: If (i_count > 0) then
1129: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CICDI')));
1130: CONC_REQUEST := fnd_concurrent.set_completion_status('WARNING',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
1131: END IF;
1132:
1133: fnd_file.put_line(fnd_file.log,'done with item costs import, quitting');
1134: EXCEPTION

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

1135: when others then
1136: rollback;
1137: fnd_file.put_line(fnd_file.log,'Start_item_cost_import_process(), Invalid Exception Occured');
1138:
1139: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
1140: Error_number := 1;
1141: END Start_item_cost_import_process;
1142:
1143: END CST_ITEM_COST_IMPORT_INTERFACE;