DBA Data[Home] [Help]

APPS.EAM_PROCESS_FAILURE_ENTRY_PUB dependencies on FND_MESSAGE

Line 122: FND_MESSAGE.SET_NAME ('EAM', 'EAM_FA_INVALID_TXN_TYPE');

118: OR l_eam_failure_entry_record.transaction_type IS NULL
119: )
120: THEN
121: /* Invalid Transaction Type */
122: FND_MESSAGE.SET_NAME ('EAM', 'EAM_FA_INVALID_TXN_TYPE');
123: FND_MSG_PUB.Add;
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF l_eam_failure_codes_tbl.count > 1
126: THEN

Line 127: FND_MESSAGE.SET_NAME ('EAM', 'EAM_MULTIPLE_CHILD');

123: FND_MSG_PUB.Add;
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF l_eam_failure_codes_tbl.count > 1
126: THEN
127: FND_MESSAGE.SET_NAME ('EAM', 'EAM_MULTIPLE_CHILD');
128: FND_MSG_PUB.Add;
129: RAISE FND_API.G_EXC_ERROR;
130: ELSIF ( l_eam_failure_codes_tbl.count = 1
131: AND l_eam_failure_codes_tbl(1).transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_CREATE

Line 135: FND_MESSAGE.SET_NAME ('EAM', 'EAM_FA_INVALID_TXN_TYPE');

131: AND l_eam_failure_codes_tbl(1).transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_CREATE
132: AND l_eam_failure_codes_tbl(1).transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_UPDATE
133: )
134: THEN
135: FND_MESSAGE.SET_NAME ('EAM', 'EAM_FA_INVALID_TXN_TYPE');
136: FND_MSG_PUB.Add;
137: RAISE FND_API.G_EXC_ERROR;
138: ELSIF ( l_eam_failure_codes_tbl.count = 1
139: AND l_eam_failure_codes_tbl(1).failure_id IS NOT NULL

Line 143: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CHILD_NOT_SYNC');

139: AND l_eam_failure_codes_tbl(1).failure_id IS NOT NULL
140: AND l_eam_failure_codes_tbl(1).failure_id <> l_eam_failure_entry_record.failure_id
141: )
142: THEN
143: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CHILD_NOT_SYNC');
144: FND_MSG_PUB.Add;
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147:

Line 164: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');

160: AND organization_id = l_eam_failure_entry_record.maint_organization_id
161: AND entity_type in (6,7);
162: EXCEPTION
163: WHEN NO_DATA_FOUND THEN
164: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');
165: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'
166: , value => l_eam_failure_entry_record.source_name
167: );
168: FND_MSG_PUB.Add;

Line 165: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'

161: AND entity_type in (6,7);
162: EXCEPTION
163: WHEN NO_DATA_FOUND THEN
164: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');
165: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'
166: , value => l_eam_failure_entry_record.source_name
167: );
168: FND_MSG_PUB.Add;
169: RAISE FND_API.G_EXC_ERROR;

Line 180: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');

176: FROM wip_discrete_jobs
177: WHERE wip_entity_id = l_eam_failure_entry_record.source_id;
178: EXCEPTION
179: WHEN NO_DATA_FOUND THEN
180: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');
181: fnd_message.set_token( token => 'SOURCE_ID'
182: , value => l_eam_failure_entry_record.source_id
183: );
184: FND_MSG_PUB.Add;

Line 181: fnd_message.set_token( token => 'SOURCE_ID'

177: WHERE wip_entity_id = l_eam_failure_entry_record.source_id;
178: EXCEPTION
179: WHEN NO_DATA_FOUND THEN
180: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');
181: fnd_message.set_token( token => 'SOURCE_ID'
182: , value => l_eam_failure_entry_record.source_id
183: );
184: FND_MSG_PUB.Add;
185: RAISE FND_API.G_EXC_ERROR;

Line 194: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_TYPE');

190: OR ( l_object_type <> l_eam_failure_entry_record.object_type)
191: )
192: )
193: THEN
194: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_TYPE');
195: FND_MESSAGE.SET_TOKEN( token => 'OBJECT_TYPE'
196: , value => l_eam_failure_entry_record.object_type
197: );
198: FND_MSG_PUB.Add;

Line 195: FND_MESSAGE.SET_TOKEN( token => 'OBJECT_TYPE'

191: )
192: )
193: THEN
194: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_TYPE');
195: FND_MESSAGE.SET_TOKEN( token => 'OBJECT_TYPE'
196: , value => l_eam_failure_entry_record.object_type
197: );
198: FND_MSG_PUB.Add;
199: RAISE FND_API.G_EXC_ERROR;

Line 210: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_ID');

206: OR (l_object_id <> l_eam_failure_entry_record.object_id)
207: )
208: )
209: THEN
210: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_ID');
211: FND_MESSAGE.SET_TOKEN( token => 'ASSET_NUMBER'
212: , value => l_eam_failure_entry_record.object_id
213: );
214: FND_MSG_PUB.Add;

Line 211: FND_MESSAGE.SET_TOKEN( token => 'ASSET_NUMBER'

207: )
208: )
209: THEN
210: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_ID');
211: FND_MESSAGE.SET_TOKEN( token => 'ASSET_NUMBER'
212: , value => l_eam_failure_entry_record.object_id
213: );
214: FND_MSG_PUB.Add;
215: RAISE FND_API.G_EXC_ERROR;

Line 226: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_MAINT_ORG');

222: OR (l_organization_id <> l_eam_failure_entry_record.maint_organization_id)
223: )
224: )
225: THEN
226: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_MAINT_ORG');
227: FND_MESSAGE.SET_TOKEN( token => 'MAINT_ORG_ID'
228: , value => l_eam_failure_entry_record.maint_organization_id
229: );
230: FND_MSG_PUB.Add;

Line 227: FND_MESSAGE.SET_TOKEN( token => 'MAINT_ORG_ID'

223: )
224: )
225: THEN
226: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_MAINT_ORG');
227: FND_MESSAGE.SET_TOKEN( token => 'MAINT_ORG_ID'
228: , value => l_eam_failure_entry_record.maint_organization_id
229: );
230: FND_MSG_PUB.Add;
231: RAISE FND_API.G_EXC_ERROR;

Line 242: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_CURRENT_ORG');

238: OR (l_organization_id <> l_eam_failure_entry_record.current_organization_id)
239: )
240: )
241: THEN
242: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_CURRENT_ORG');
243: FND_MESSAGE.SET_TOKEN( token => 'CURR_ORG_ID'
244: , value => l_eam_failure_entry_record.current_organization_id
245: );
246: FND_MSG_PUB.Add;

Line 243: FND_MESSAGE.SET_TOKEN( token => 'CURR_ORG_ID'

239: )
240: )
241: THEN
242: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_CURRENT_ORG');
243: FND_MESSAGE.SET_TOKEN( token => 'CURR_ORG_ID'
244: , value => l_eam_failure_entry_record.current_organization_id
245: );
246: FND_MSG_PUB.Add;
247: RAISE FND_API.G_EXC_ERROR;

Line 267: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_ID');

263: mp.maint_organization_id = eomd.organization_id);
264:
265: EXCEPTION
266: WHEN OTHERS THEN
267: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_ID');
268: FND_MESSAGE.SET_TOKEN( token => 'ASSET_NUMBER'
269: ,value => l_eam_failure_entry_record.object_id
270: );
271: FND_MSG_PUB.Add;

Line 268: FND_MESSAGE.SET_TOKEN( token => 'ASSET_NUMBER'

264:
265: EXCEPTION
266: WHEN OTHERS THEN
267: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_ID');
268: FND_MESSAGE.SET_TOKEN( token => 'ASSET_NUMBER'
269: ,value => l_eam_failure_entry_record.object_id
270: );
271: FND_MSG_PUB.Add;
272: RAISE FND_API.G_EXC_ERROR;

Line 285: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_DEPARTMENT');

281: OR l_department_id <> l_eam_failure_entry_record.department_id
282: )
283: )
284: THEN
285: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_DEPARTMENT');
286: FND_MESSAGE.SET_TOKEN( token => 'DEPARTMENT'
287: ,value => l_eam_failure_entry_record.department_id
288: );
289: FND_MSG_PUB.Add;

Line 286: FND_MESSAGE.SET_TOKEN( token => 'DEPARTMENT'

282: )
283: )
284: THEN
285: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_DEPARTMENT');
286: FND_MESSAGE.SET_TOKEN( token => 'DEPARTMENT'
287: ,value => l_eam_failure_entry_record.department_id
288: );
289: FND_MSG_PUB.Add;
290: RAISE FND_API.G_EXC_ERROR;

Line 301: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_AREA');

297: OR (l_eam_location_id <> l_eam_failure_entry_record.area_id)
298: )
299: )
300: THEN
301: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_AREA');
302: FND_MESSAGE.SET_TOKEN( token => 'AREA'
303: ,value => l_eam_failure_entry_record.area_id
304: );
305: FND_MSG_PUB.Add;

Line 302: FND_MESSAGE.SET_TOKEN( token => 'AREA'

298: )
299: )
300: THEN
301: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_AREA');
302: FND_MESSAGE.SET_TOKEN( token => 'AREA'
303: ,value => l_eam_failure_entry_record.area_id
304: );
305: FND_MSG_PUB.Add;
306: RAISE FND_API.G_EXC_ERROR;

Line 345: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');

341: AND source_type = 1;
342: END IF;
343: EXCEPTION
344: WHEN NO_DATA_FOUND THEN
345: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');
346: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'
347: , value => l_eam_failure_entry_record.source_id||l_eam_failure_entry_record.source_name
348: );
349: FND_MSG_PUB.Add;

Line 346: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'

342: END IF;
343: EXCEPTION
344: WHEN NO_DATA_FOUND THEN
345: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');
346: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'
347: , value => l_eam_failure_entry_record.source_id||l_eam_failure_entry_record.source_name
348: );
349: FND_MSG_PUB.Add;
350: RAISE FND_API.G_EXC_ERROR;

Line 353: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_FAILURE_ID');

349: FND_MSG_PUB.Add;
350: RAISE FND_API.G_EXC_ERROR;
351: END;
352: ELSE
353: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_FAILURE_ID');
354: FND_MSG_PUB.Add;
355: RAISE FND_API.G_EXC_ERROR;
356: END IF;
357: END IF;

Line 368: FND_MESSAGE.SET_NAME ('EAM', 'EAM_FAILURE_NOT_EXISTS');

364: WHERE failure_id = l_eam_failure_entry_record.failure_id;
365: l_eam_failure_entry_record.source_id := l_source_id;
366: EXCEPTION
367: WHEN NO_DATA_FOUND THEN
368: FND_MESSAGE.SET_NAME ('EAM', 'EAM_FAILURE_NOT_EXISTS');
369: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'
370: , value => 'Failure Id :'||l_eam_failure_entry_record.failure_id
371: );
372: FND_MSG_PUB.Add;

Line 369: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'

365: l_eam_failure_entry_record.source_id := l_source_id;
366: EXCEPTION
367: WHEN NO_DATA_FOUND THEN
368: FND_MESSAGE.SET_NAME ('EAM', 'EAM_FAILURE_NOT_EXISTS');
369: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'
370: , value => 'Failure Id :'||l_eam_failure_entry_record.failure_id
371: );
372: FND_MSG_PUB.Add;
373: RAISE FND_API.G_EXC_ERROR;

Line 392: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CANNOT_UPDATE');

388: AND l_object_type IS NOT NULL
389: )
390: )
391: THEN
392: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CANNOT_UPDATE');
393: FND_MESSAGE.SET_TOKEN( token => 'ATTRIBUTE'
394: , value => 'OBJECT_TYPE'
395: );
396: FND_MSG_PUB.Add;

Line 393: FND_MESSAGE.SET_TOKEN( token => 'ATTRIBUTE'

389: )
390: )
391: THEN
392: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CANNOT_UPDATE');
393: FND_MESSAGE.SET_TOKEN( token => 'ATTRIBUTE'
394: , value => 'OBJECT_TYPE'
395: );
396: FND_MSG_PUB.Add;
397: RAISE FND_API.G_EXC_ERROR;

Line 412: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CANNOT_UPDATE');

408: AND l_object_id IS NOT NULL
409: )
410: )
411: THEN
412: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CANNOT_UPDATE');
413: FND_MESSAGE.SET_TOKEN( token => 'ATTRIBUTE'
414: , value => 'OBJECT_ID'
415: );
416: FND_MSG_PUB.Add;

Line 413: FND_MESSAGE.SET_TOKEN( token => 'ATTRIBUTE'

409: )
410: )
411: THEN
412: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CANNOT_UPDATE');
413: FND_MESSAGE.SET_TOKEN( token => 'ATTRIBUTE'
414: , value => 'OBJECT_ID'
415: );
416: FND_MSG_PUB.Add;
417: RAISE FND_API.G_EXC_ERROR;

Line 432: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CANNOT_UPDATE');

428: AND l_source_type IS NOT NULL
429: )
430: )
431: THEN
432: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CANNOT_UPDATE');
433: FND_MESSAGE.SET_TOKEN( token => 'ATTRIBUTE'
434: , value => 'SOURCE_TYPE'
435: );
436: FND_MSG_PUB.Add;

Line 433: FND_MESSAGE.SET_TOKEN( token => 'ATTRIBUTE'

429: )
430: )
431: THEN
432: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CANNOT_UPDATE');
433: FND_MESSAGE.SET_TOKEN( token => 'ATTRIBUTE'
434: , value => 'SOURCE_TYPE'
435: );
436: FND_MSG_PUB.Add;
437: RAISE FND_API.G_EXC_ERROR;

Line 452: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CANNOT_UPDATE');

448: AND l_source_id IS NOT NULL
449: )
450: )
451: THEN
452: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CANNOT_UPDATE');
453: FND_MESSAGE.SET_TOKEN( token => 'ATTRIBUTE'
454: , value => 'SOURCE_ID'
455: );
456: FND_MSG_PUB.Add;

Line 453: FND_MESSAGE.SET_TOKEN( token => 'ATTRIBUTE'

449: )
450: )
451: THEN
452: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CANNOT_UPDATE');
453: FND_MESSAGE.SET_TOKEN( token => 'ATTRIBUTE'
454: , value => 'SOURCE_ID'
455: );
456: FND_MSG_PUB.Add;
457: RAISE FND_API.G_EXC_ERROR;

Line 470: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');

466: FROM WIP_DISCRETE_JOBS
467: WHERE wip_entity_id = l_source_id;
468: EXCEPTION
469: WHEN NO_DATA_FOUND THEN
470: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');
471: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'
472: , value => l_eam_failure_entry_record.source_id
473: );
474: FND_MSG_PUB.Add;

Line 471: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'

467: WHERE wip_entity_id = l_source_id;
468: EXCEPTION
469: WHEN NO_DATA_FOUND THEN
470: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');
471: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'
472: , value => l_eam_failure_entry_record.source_id
473: );
474: FND_MSG_PUB.Add;
475: RAISE FND_API.G_EXC_ERROR;

Line 490: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_MAINT_ORG');

486: AND l_organization_id IS NOT NULL
487: )
488: )
489: THEN
490: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_MAINT_ORG');
491: FND_MESSAGE.SET_TOKEN( token => 'MAINT_ORG_ID'
492: , value => l_eam_failure_entry_record.maint_organization_id
493: );
494: FND_MSG_PUB.Add;

Line 491: FND_MESSAGE.SET_TOKEN( token => 'MAINT_ORG_ID'

487: )
488: )
489: THEN
490: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_MAINT_ORG');
491: FND_MESSAGE.SET_TOKEN( token => 'MAINT_ORG_ID'
492: , value => l_eam_failure_entry_record.maint_organization_id
493: );
494: FND_MSG_PUB.Add;
495: RAISE FND_API.G_EXC_ERROR;

Line 512: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_CURRENT_ORG');

508: AND l_current_organization_id IS NOT NULL
509: )
510: )
511: THEN
512: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_CURRENT_ORG');
513: FND_MESSAGE.SET_TOKEN( token => 'CURR_ORG_ID'
514: , value => l_eam_failure_entry_record.current_organization_id
515: );
516: FND_MSG_PUB.Add;

Line 513: FND_MESSAGE.SET_TOKEN( token => 'CURR_ORG_ID'

509: )
510: )
511: THEN
512: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_CURRENT_ORG');
513: FND_MESSAGE.SET_TOKEN( token => 'CURR_ORG_ID'
514: , value => l_eam_failure_entry_record.current_organization_id
515: );
516: FND_MSG_PUB.Add;
517: RAISE FND_API.G_EXC_ERROR;

Line 538: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_ID');

534:
535:
536: EXCEPTION
537: WHEN OTHERS THEN
538: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_ID');
539: FND_MESSAGE.SET_TOKEN( token => 'ASSET_NUMBER'
540: ,value => l_object_id
541: );
542: FND_MSG_PUB.Add;

Line 539: FND_MESSAGE.SET_TOKEN( token => 'ASSET_NUMBER'

535:
536: EXCEPTION
537: WHEN OTHERS THEN
538: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_ID');
539: FND_MESSAGE.SET_TOKEN( token => 'ASSET_NUMBER'
540: ,value => l_object_id
541: );
542: FND_MSG_PUB.Add;
543: RAISE FND_API.G_EXC_ERROR;

Line 563: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_DEPARTMENT');

559: AND l_department_id IS NOT NULL
560: )
561: )
562: THEN
563: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_DEPARTMENT');
564: FND_MESSAGE.SET_TOKEN( token => 'DEPARTMENT'
565: ,value => l_eam_failure_entry_record.department_id
566: );
567: FND_MSG_PUB.Add;

Line 564: FND_MESSAGE.SET_TOKEN( token => 'DEPARTMENT'

560: )
561: )
562: THEN
563: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_DEPARTMENT');
564: FND_MESSAGE.SET_TOKEN( token => 'DEPARTMENT'
565: ,value => l_eam_failure_entry_record.department_id
566: );
567: FND_MSG_PUB.Add;
568: RAISE FND_API.G_EXC_ERROR;

Line 586: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_AREA');

582: AND l_eam_location_id IS NOT NULL
583: )
584: )
585: THEN
586: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_AREA');
587: FND_MESSAGE.SET_TOKEN( token => 'AREA'
588: ,value => l_eam_failure_entry_record.area_id
589: );
590: FND_MSG_PUB.Add;

Line 587: FND_MESSAGE.SET_TOKEN( token => 'AREA'

583: )
584: )
585: THEN
586: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_AREA');
587: FND_MESSAGE.SET_TOKEN( token => 'AREA'
588: ,value => l_eam_failure_entry_record.area_id
589: );
590: FND_MSG_PUB.Add;
591: RAISE FND_API.G_EXC_ERROR;

Line 647: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_FAILURE');

643: FROM eam_asset_failure_codes
644: WHERE failure_id = l_eam_failure_codes_tbl(i).failure_id;
645: EXCEPTION
646: WHEN NO_DATA_FOUND THEN
647: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_FAILURE');
648: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'
649: , value => l_eam_failure_codes_tbl(i).failure_id
650: );
651: FND_MSG_PUB.Add;

Line 648: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'

644: WHERE failure_id = l_eam_failure_codes_tbl(i).failure_id;
645: EXCEPTION
646: WHEN NO_DATA_FOUND THEN
647: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_FAILURE');
648: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'
649: , value => l_eam_failure_codes_tbl(i).failure_id
650: );
651: FND_MSG_PUB.Add;
652: RAISE FND_API.G_EXC_ERROR;

Line 664: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_FAILURE_ENTRY_ID');

660: FROM eam_asset_failure_codes
661: WHERE failure_entry_id = l_eam_failure_codes_tbl(i).failure_entry_id;
662: EXCEPTION
663: WHEN NO_DATA_FOUND THEN
664: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_FAILURE_ENTRY_ID');
665: FND_MSG_PUB.Add;
666: RAISE FND_API.G_EXC_ERROR;
667: END;
668:

Line 671: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CHILD_NOT_SYNC');

667: END;
668:
669: IF l_eam_failure_codes_tbl(i).failure_id <> l_eam_failure_entry_record.failure_id
670: THEN
671: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CHILD_NOT_SYNC');
672: FND_MSG_PUB.Add;
673: RAISE FND_API.G_EXC_ERROR;
674: END IF;
675:

Line 726: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');

722: WHERE wdj.wip_entity_id = edw.wip_entity_id
723: AND wdj.wip_entity_id = l_eam_failure_entry_record.source_id;
724: EXCEPTION
725: WHEN NO_DATA_FOUND THEN
726: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');
727: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'
728: , value => l_eam_failure_entry_record.source_name
729: );
730: FND_MSG_PUB.Add;

Line 727: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'

723: AND wdj.wip_entity_id = l_eam_failure_entry_record.source_id;
724: EXCEPTION
725: WHEN NO_DATA_FOUND THEN
726: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');
727: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'
728: , value => l_eam_failure_entry_record.source_name
729: );
730: FND_MSG_PUB.Add;
731: RAISE FND_API.G_EXC_ERROR;

Line 754: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');

750: FROM eam_asset_failure_codes
751: WHERE failure_id = l_eam_failure_entry_record.failure_id;
752: EXCEPTION
753: WHEN NO_DATA_FOUND THEN
754: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');
755: FND_MSG_PUB.Add;
756: RAISE FND_API.G_EXC_ERROR;
757: END;
758: END IF;

Line 768: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');

764: AND l_cause_code IS NOT NULL
765: AND l_resolution_code IS NOT NULL
766: )
767: THEN
768: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');
769: FND_MSG_PUB.Add;
770: RAISE FND_API.G_EXC_ERROR;
771: END IF;
772: ELSE

Line 781: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');

777: OR l_cause_code IS NULL
778: OR l_resolution_code IS NULL
779: )
780: THEN
781: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');
782: FND_MSG_PUB.Add;
783: RAISE FND_API.G_EXC_ERROR;
784: END IF;
785: ELSE

Line 799: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');

795: AND l_resolution_code IS NULL
796: )
797: )
798: THEN
799: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');
800: FND_MSG_PUB.Add;
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;
803: END IF;

Line 812: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');

808: IF ( l_eam_failure_codes_tbl.count = 1
809: AND l_eam_failure_codes_tbl(1).comments IS NOT NULL
810: )
811: THEN
812: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');
813: FND_MSG_PUB.Add;
814: RAISE FND_API.G_EXC_ERROR;
815: ELSIF l_eam_failure_codes_tbl.count = 0
816: THEN

Line 823: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');

819: INTO l_comments
820: FROM eam_asset_failure_codes
821: WHERE failure_id = l_eam_failure_entry_record.failure_id;
822: IF l_comments IS NOT NULL THEN
823: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');
824: FND_MSG_PUB.Add;
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;
827: EXCEPTION