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.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 270: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_ID');

266: WHEN NO_DATA_FOUND THEN
267: l_msn_department_id := NULL;
268: l_eam_location_id := NULL;
269: WHEN OTHERS THEN
270: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_ID');
271: FND_MESSAGE.SET_TOKEN( token => 'ASSET_NUMBER'
272: ,value => l_eam_failure_entry_record.object_id
273: );
274: FND_MSG_PUB.Add;

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

267: l_msn_department_id := NULL;
268: l_eam_location_id := NULL;
269: WHEN OTHERS THEN
270: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_ID');
271: FND_MESSAGE.SET_TOKEN( token => 'ASSET_NUMBER'
272: ,value => l_eam_failure_entry_record.object_id
273: );
274: FND_MSG_PUB.Add;
275: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

540: WHEN NO_DATA_FOUND THEN
541: l_msn_department_id := NULL;
542: l_eam_location_id := NULL;
543: WHEN OTHERS THEN
544: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_ID');
545: FND_MESSAGE.SET_TOKEN( token => 'ASSET_NUMBER'
546: ,value => l_object_id
547: );
548: FND_MSG_PUB.Add;

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

541: l_msn_department_id := NULL;
542: l_eam_location_id := NULL;
543: WHEN OTHERS THEN
544: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_OBJECT_ID');
545: FND_MESSAGE.SET_TOKEN( token => 'ASSET_NUMBER'
546: ,value => l_object_id
547: );
548: FND_MSG_PUB.Add;
549: RAISE FND_API.G_EXC_ERROR;

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

565: AND l_department_id IS NOT NULL
566: )
567: )
568: THEN
569: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_DEPARTMENT');
570: FND_MESSAGE.SET_TOKEN( token => 'DEPARTMENT'
571: ,value => l_eam_failure_entry_record.department_id
572: );
573: FND_MSG_PUB.Add;

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

566: )
567: )
568: THEN
569: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_DEPARTMENT');
570: FND_MESSAGE.SET_TOKEN( token => 'DEPARTMENT'
571: ,value => l_eam_failure_entry_record.department_id
572: );
573: FND_MSG_PUB.Add;
574: RAISE FND_API.G_EXC_ERROR;

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

588: AND l_eam_location_id IS NOT NULL
589: )
590: )
591: THEN
592: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_AREA');
593: FND_MESSAGE.SET_TOKEN( token => 'AREA'
594: ,value => l_eam_failure_entry_record.area_id
595: );
596: FND_MSG_PUB.Add;

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

589: )
590: )
591: THEN
592: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_AREA');
593: FND_MESSAGE.SET_TOKEN( token => 'AREA'
594: ,value => l_eam_failure_entry_record.area_id
595: );
596: FND_MSG_PUB.Add;
597: RAISE FND_API.G_EXC_ERROR;

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

649: FROM eam_asset_failure_codes
650: WHERE failure_id = l_eam_failure_codes_tbl(i).failure_id;
651: EXCEPTION
652: WHEN NO_DATA_FOUND THEN
653: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_FAILURE');
654: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'
655: , value => l_eam_failure_codes_tbl(i).failure_id
656: );
657: FND_MSG_PUB.Add;

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

650: WHERE failure_id = l_eam_failure_codes_tbl(i).failure_id;
651: EXCEPTION
652: WHEN NO_DATA_FOUND THEN
653: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_FAILURE');
654: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'
655: , value => l_eam_failure_codes_tbl(i).failure_id
656: );
657: FND_MSG_PUB.Add;
658: RAISE FND_API.G_EXC_ERROR;

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

666: FROM eam_asset_failure_codes
667: WHERE failure_entry_id = l_eam_failure_codes_tbl(i).failure_entry_id;
668: EXCEPTION
669: WHEN NO_DATA_FOUND THEN
670: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_FAILURE_ENTRY_ID');
671: FND_MSG_PUB.Add;
672: RAISE FND_API.G_EXC_ERROR;
673: END;
674:

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

673: END;
674:
675: IF l_eam_failure_codes_tbl(i).failure_id <> l_eam_failure_entry_record.failure_id
676: THEN
677: FND_MESSAGE.SET_NAME ('EAM', 'EAM_CHILD_NOT_SYNC');
678: FND_MSG_PUB.Add;
679: RAISE FND_API.G_EXC_ERROR;
680: END IF;
681:

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

728: WHERE wdj.wip_entity_id = edw.wip_entity_id
729: AND wdj.wip_entity_id = l_eam_failure_entry_record.source_id;
730: EXCEPTION
731: WHEN NO_DATA_FOUND THEN
732: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');
733: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'
734: , value => l_eam_failure_entry_record.source_name
735: );
736: FND_MSG_PUB.Add;

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

729: AND wdj.wip_entity_id = l_eam_failure_entry_record.source_id;
730: EXCEPTION
731: WHEN NO_DATA_FOUND THEN
732: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');
733: FND_MESSAGE.SET_TOKEN( token => 'SOURCE_ID'
734: , value => l_eam_failure_entry_record.source_name
735: );
736: FND_MSG_PUB.Add;
737: RAISE FND_API.G_EXC_ERROR;

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

756: FROM eam_asset_failure_codes
757: WHERE failure_id = l_eam_failure_entry_record.failure_id;
758: EXCEPTION
759: WHEN NO_DATA_FOUND THEN
760: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');
761: FND_MSG_PUB.Add;
762: RAISE FND_API.G_EXC_ERROR;
763: END;
764: END IF;

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

770: AND l_cause_code IS NOT NULL
771: AND l_resolution_code IS NOT NULL
772: )
773: THEN
774: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');
775: FND_MSG_PUB.Add;
776: RAISE FND_API.G_EXC_ERROR;
777: END IF;
778: ELSE

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

783: OR l_cause_code IS NULL
784: OR l_resolution_code IS NULL
785: )
786: THEN
787: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');
788: FND_MSG_PUB.Add;
789: RAISE FND_API.G_EXC_ERROR;
790: END IF;
791: ELSE

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

801: AND l_resolution_code IS NULL
802: )
803: )
804: THEN
805: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');
806: FND_MSG_PUB.Add;
807: RAISE FND_API.G_EXC_ERROR;
808: END IF;
809: END IF;

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

814: IF ( l_eam_failure_codes_tbl.count = 1
815: AND l_eam_failure_codes_tbl(1).comments IS NOT NULL
816: )
817: THEN
818: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');
819: FND_MSG_PUB.Add;
820: RAISE FND_API.G_EXC_ERROR;
821: ELSIF l_eam_failure_codes_tbl.count = 0
822: THEN

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

825: INTO l_comments
826: FROM eam_asset_failure_codes
827: WHERE failure_id = l_eam_failure_entry_record.failure_id;
828: IF l_comments IS NOT NULL THEN
829: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');
830: FND_MSG_PUB.Add;
831: RAISE FND_API.G_EXC_ERROR;
832: END IF;
833: EXCEPTION