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

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

40: /* check for both the organization_id and code to be null */
41: Update CST_DEPT_OVERHEADS_INTERFACE cdoi
42: SET error_flag = 'E',
43: error_code = 'CST_NULL_ORGANIZATION',
44: error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_ORGANIZATION'),1,240)
45: where (Organization_id is null AND organization_code is null)
46: AND cdoi.error_flag is null
47: AND cdoi.group_id = SEQ_NEXTVAL;
48:

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

53:
54: Update CST_DEPT_OVERHEADS_INTERFACE cdoi
55: SET error_flag = 'E',
56: error_code = 'CST_INVALID_ORGANIZATION',
57: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ORGANIZATION'),1,240)
58: WHERE cdoi.error_flag is null
59: AND cdoi.group_id = SEQ_NEXTVAL
60: AND NOT EXISTS (select 1 from mtl_parameters mp
61: where NVL(cdoi.organization_id,mp.organization_id) = mp.organization_id

Line 89: substrb(fnd_message.get_string(

85: Update CST_DEPT_OVERHEADS_INTERFACE ct
86: SET error_flag = 'E',
87: error_code = 'CST_PROCESS_ORG_ERROR',
88: error_explanation =
89: substrb(fnd_message.get_string(
90: 'GMF','GMF_PROCESS_ORG_ERROR'),1,240)
91: WHERE ct.error_flag is null
92: AND ct.group_id = SEQ_NEXTVAL
93: AND EXISTS (select 'This is a process manufacturing org'

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

125:
126: Update CST_DEPT_OVERHEADS_INTERFACE cdoi
127: set cdoi.error_flag = 'E',
128: cdoi.error_code = 'CST_NOT_COSTINGORG',
129: cdoi.error_explanation = substrb(fnd_message.get_string('BOM','CST_NOT_COSTINGORG'),1,240)
130: WHERE cdoi.group_id = SEQ_NEXTVAL
131: AND cdoi.error_flag is null
132: AND EXISTS (select 1 from MTL_PARAMETERS mp
133: WHERE mp.cost_organization_id <> mp.organization_id

Line 157: cdoi.error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_DEPARTMENT'),1,240)

153:
154: Update CST_DEPT_OVERHEADS_INTERFACE cdoi
155: SET cdoi.error_flag = 'E',
156: cdoi.error_code = 'CST_NULL_DEPARTMENT',
157: cdoi.error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_DEPARTMENT'),1,240)
158: WHERE cdoi.error_flag is null
159: AND cdoi.group_id = SEQ_NEXTVAL
160: AND (cdoi.department_id is null AND cdoi.department_code is null);
161:

Line 170: cdoi.error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_OVERHEAD'),1,240)

166:
167: Update CST_DEPT_OVERHEADS_INTERFACE cdoi
168: SET cdoi.error_flag = 'E',
169: cdoi.error_code = 'CST_NULL_OVERHEAD',
170: cdoi.error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_OVERHEAD'),1,240)
171: WHERE cdoi.error_flag is null
172: AND cdoi.group_id = SEQ_NEXTVAL
173: AND (cdoi.overhead_id is null AND cdoi.overhead is null);
174:

Line 185: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_DEPTS'),1,240)

181:
182: Update CST_DEPT_OVERHEADS_INTERFACE cdoi set
183: error_flag = 'E',
184: error_code = 'CST_INVALID_DEPTS',
185: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_DEPTS'),1,240)
186: WHERE cdoi.error_flag is null
187: AND cdoi.group_id = SEQ_NEXTVAL
188: AND NOT EXISTS (select 1 from bom_departments bd
189: WHERE NVL(cdoi.department_id,bd.department_id)=bd.department_id

Line 215: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_OVERHEAD'),1,240)

211: /* check if the entered overhead_id or code is actually valid */
212: Update CST_DEPT_OVERHEADS_INTERFACE cdoi set
213: error_flag = 'E',
214: error_code = 'CST_INVALID_OVERHEAD',
215: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_OVERHEAD'),1,240)
216: WHERE cdoi.error_flag is null
217: AND cdoi.group_id = SEQ_NEXTVAL
218: AND NOT EXISTS (select 1 from bom_resources bm
219: WHERE NVL(cdoi.overhead_id,bm.resource_id)=bm.resource_id

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

242:
243: Update CST_DEPT_OVERHEADS_INTERFACE cdoi
244: set cdoi.error_flag = 'E',
245: cdoi.error_code = 'CST_EXP_SUBELEMENT',
246: cdoi.error_explanation = substrb(fnd_message.get_string('BOM','CST_EXP_SUBELEMENT'),1,240)
247: WHERE cdoi.error_flag is null
248: AND cdoi.group_id = SEQ_NEXTVAL
249: AND EXISTS (select 1 from BOM_RESOURCES bm
250: where bm.organization_id = cdoi.organization_id

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

260:
261: Update CST_DEPT_OVERHEADS_INTERFACE cdoi
262: set error_flag = 'E',
263: error_code = 'CST_INVALID_BASISTYPE',
264: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_BASISTYPE'),1,240)
265: where error_flag is null
266: AND cdoi.group_id = SEQ_NEXTVAL
267: AND (cdoi.basis_type < 1 OR cdoi.basis_type > 4);
268:

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

271:
272: Update CST_DEPT_OVERHEADS_INTERFACE cdoi set
273: error_flag = 'E',
274: error_code = 'CST_INVALID_RESRATE',
275: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_RESRATE'),1,240)
276: where error_flag is null
277: and cdoi.group_id = SEQ_NEXTVAL
278: and cdoi.rate_or_amount is null;
279:

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

284:
285: Update CST_DEPT_OVERHEADS_INTERFACE cdoi set
286: error_flag = 'E',
287: error_code = 'CST_INVALID_ACTIVITY',
288: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ACTIVITY'),1,240)
289: where group_id = SEQ_NEXTVAL
290: AND (cdoi.activity_id is not null OR cdoi.activity is not null)
291: AND error_flag is null
292: AND NOT EXISTS(select 1 from cst_activities ca where

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

322:
323: Update CST_DEPT_OVERHEADS_INTERFACE cdoi
324: set cdoi.error_flag = 'E',
325: cdoi.error_code = 'CST_DUPL_ROWS',
326: cdoi.error_explanation = substrb(fnd_message.get_string('BOM','CST_DUPL_ROWS'),1,240)
327: where cdoi.error_flag is null
328: AND cdoi.group_id = SEQ_NEXTVAL
329: AND EXISTS( Select 1 from CST_DEPT_OVERHEADS_INTERFACE cdoi2
330: where cdoi2.organization_id = cdoi.organization_id

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

365: elsif i_run_option = 1 then
366: Update CST_DEPT_OVERHEADS_INTERFACE cdoi
367: set cdoi.error_flag = 'E',
368: cdoi.error_code = 'CST_CANT_INSERT',
369: cdoi.error_explanation = substrb(fnd_message.get_string('BOM','CST_CANT_INSERT'),1,240)
370: where cdoi.error_flag is null
371: AND cdoi.group_id = SEQ_NEXTVAL
372: AND EXISTS (select 1 from CST_DEPARTMENT_OVERHEADS cdo
373: where cdoi.organization_id = cdo.organization_id

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

473: when others then
474: rollback;
475: fnd_file.put_line(fnd_file.log,'Validate_department_overheads('|| to_char(l_stmt_no) || '),'|| to_char(SQLCODE) || ',' || substr(SQLERRM,1.180));
476:
477: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
478: Error_number := 1;
479: END Validate_Department_overheads;
480:
481:

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

519:
520: Update CST_RES_OVERHEADS_INTERFACE croi
521: SET error_flag = 'E',
522: error_code = 'CST_NULL_ORGANIZATION',
523: error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_ORGANIZATION'),1,240)
524: where (Organization_id is null AND organization_code is null)
525: AND error_flag is null
526: AND croi.group_id = SEQ_NEXTVAL;
527:

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

532:
533: Update CST_RES_OVERHEADS_INTERFACE croi
534: SET error_flag = 'E',
535: error_code = 'CST_INVALID_ORGANIZATION',
536: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ORGANIZATION'),1,240)
537: WHERE croi.error_flag is null
538: AND croi.group_id = SEQ_NEXTVAL
539: AND NOT EXISTS (select 1 from mtl_parameters mp
540: where NVL(croi.organization_id,mp.organization_id) = mp.organization_id

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

582:
583: Update CST_RES_OVERHEADS_INTERFACE croi
584: set croi.error_flag = 'E',
585: croi.error_code = 'CST_NOT_COSTINGORG',
586: croi.error_explanation = substrb(fnd_message.get_string('BOM','CST_NOT_COSTINGORG'),1,240)
587: WHERE croi.group_id = SEQ_NEXTVAL
588: AND croi.error_flag is null
589: AND EXISTS (select 1 from MTL_PARAMETERS mp
590: WHERE mp.cost_organization_id <> mp.organization_id

Line 615: croi.error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_OVERHEAD'),1,240)

611:
612: Update CST_RES_OVERHEADS_INTERFACE croi
613: SET croi.error_flag = 'E',
614: croi.error_code = 'CST_NULL_OVERHEAD',
615: croi.error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_OVERHEAD'),1,240)
616: WHERE croi.error_flag is null
617: AND croi.group_id = SEQ_NEXTVAL
618: AND (croi.overhead_id is null AND croi.overhead is null);
619:

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

624:
625: Update CST_RES_OVERHEADS_INTERFACE croi
626: SET croi.error_flag = 'E',
627: croi.error_code = 'CST_NULL_SUBELEMENT',
628: croi.error_explanation = substrb(fnd_message.get_string('BOM','CST_NULL_SUBELEMENT'),1,240)
629: WHERE croi.error_flag is null
630: AND croi.group_id = SEQ_NEXTVAL
631: AND (croi.resource_id is null AND croi.resource_code is null);
632:

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

636: /* check if the entered resource_id or code is actually valid */
637: Update CST_RES_OVERHEADS_INTERFACE croi set
638: error_flag = 'E',
639: error_code = 'CST_INVALID_SUBELEMENT',
640: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_SUBELEMENT'),1,240)
641: WHERE croi.error_flag is null
642: AND croi.group_id = SEQ_NEXTVAL
643: AND NOT EXISTS (select 1 from bom_resources bm
644: WHERE NVL(croi.resource_id,bm.resource_id)=bm.resource_id

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

668: /* check for the validty_date for the resource_id */
669: Update CST_RES_OVERHEADS_INTERFACE croi
670: set croi.error_flag = 'E',
671: croi.error_code = 'CST_EXP_SUBELEMENT',
672: croi.error_explanation = substrb(fnd_message.get_string('BOM','CST_EXP_SUBELEMENT'),1,240)
673: WHERE croi.error_flag is null
674: AND croi.group_id = SEQ_NEXTVAl
675: AND exists (select 1 from BOM_RESOURCES bm
676: WHERE bm.organization_id = croi.organization_id

Line 686: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_OVERHEAD'),1,240)

682: /* check if the entered overhead_id or overhead is actually valid */
683: Update CST_RES_OVERHEADS_INTERFACE croi set
684: error_flag = 'E',
685: error_code = 'CST_INVALID_OVERHEAD',
686: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_OVERHEAD'),1,240)
687: WHERE croi.error_flag is null
688: AND croi.group_id = SEQ_NEXTVAL
689: AND NOT EXISTS (select 1 from bom_resources bm
690: WHERE NVL(croi.overhead_id,bm.resource_id)=bm.resource_id

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

714: /* now check for the validity date of the overhead */
715: Update CST_RES_OVERHEADS_INTERFACE croi
716: set croi.error_flag='E',
717: croi.error_code = 'CST_EXP_SUBELEMENT',
718: croi.error_explanation = substrb(fnd_message.get_string('BOM','CST_EXP_SUBELEMENT'),1,240)
719: WHERE croi.error_flag is null
720: AND croi.group_id = SEQ_NEXTVAL
721: AND exists (select 1 from BOM_RESOURCES bm
722: WHERE bm.organization_id = croi.organization_id

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

739:
740: Update CST_RES_OVERHEADS_INTERFACE croi
741: set croi.error_flag = 'E',
742: croi.error_code = 'CST_DUPL_ROWS',
743: croi.error_explanation = substrb(fnd_message.get_string('BOM','CST_DUPL_ROWS'),1,240)
744: WHERE croi.error_flag is null
745: AND croi.group_id = SEQ_NEXTVAL
746: AND EXISTS(select 1 from CST_RES_OVERHEADS_INTERFACE croi2
747: WHERE croi2.resource_id = croi.resource_id

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

781: elsif i_run_option = 1 then
782: Update CST_RES_OVERHEADS_INTERFACE croi
783: set croi.error_flag = 'E',
784: croi.error_code = 'CST_CANT_INSERT',
785: croi.error_explanation = substrb(fnd_message.get_string('BOM','CST_CANT_INSERT'),1,240)
786: where croi.error_flag is null
787: AND croi.group_id = SEQ_NEXTVAL
788: AND EXISTS (select 1 from CST_RESOURCE_OVERHEADS cro
789: where croi.organization_id = cro.organization_id

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

885: rollback;
886: fnd_file.put_line(fnd_file.log,'Validate_resource_overheads('|| to_char(l_stmt_no)|| '),'||to_char(SQLCODE)||',' || substr(SQLERRM,1,180));
887: Error_number := 1;
888:
889: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
890: END Validate_Resource_overheads;
891:
892: /* This procedure Start_process is the starting point in the program.This
893: Procedure actually decides which procedures need to be called */

Line 940: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CDOI')));

936: where group_id = i_grp_id
937: and error_flag = 'E';
938:
939: if i_count > 0 then
940: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CDOI')));
941: CONC_REQUEST := fnd_concurrent.set_completion_status('WARNING',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
942: END IF;
943:
944: Select count(*) into i_count from CST_RES_OVERHEADS_INTERFACE

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

937: and error_flag = 'E';
938:
939: if i_count > 0 then
940: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CDOI')));
941: CONC_REQUEST := fnd_concurrent.set_completion_status('WARNING',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
942: END IF;
943:
944: Select count(*) into i_count from CST_RES_OVERHEADS_INTERFACE
945: where group_id = i_grp_id

Line 949: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CROI')));

945: where group_id = i_grp_id
946: and error_flag = 'E';
947:
948: if i_count > 0 then
949: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CROI')));
950: CONC_REQUEST := fnd_concurrent.set_completion_status('WARNING',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
951: END IF;
952:
953: EXCEPTION

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

946: and error_flag = 'E';
947:
948: if i_count > 0 then
949: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CROI')));
950: CONC_REQUEST := fnd_concurrent.set_completion_status('WARNING',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
951: END IF;
952:
953: EXCEPTION
954: when others then

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

955: rollback;
956: fnd_file.put_line(fnd_file.log,'Start_process() Exception Occured');
957: Error_number := 1;
958:
959: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
960:
961: END Start_process;
962:
963: END CST_OVHD_RATE_IMPORT_INTERFACE;