DBA Data[Home] [Help]

APPS.EAM_PROCESS_FAILURE_ENTRY_PUB dependencies on FND_MSG_PUB

Line 104: FND_MSG_PUB.initialize;

100: END IF;
101:
102: -- Initialize message list if p_init_msg_list is set to TRUE.
103: IF FND_API.to_Boolean( p_init_msg_list ) THEN
104: FND_MSG_PUB.initialize;
105: END IF;
106:
107: -- Initialize API return status to success
108: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 123: FND_MSG_PUB.Add;

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

Line 128: 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
132: AND l_eam_failure_codes_tbl(1).transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_UPDATE

Line 136: FND_MSG_PUB.Add;

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
140: AND l_eam_failure_codes_tbl(1).failure_id <> l_eam_failure_entry_record.failure_id

Line 144: FND_MSG_PUB.Add;

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:
148:

Line 168: FND_MSG_PUB.Add;

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;
170: END;
171: END IF;
172:

Line 184: FND_MSG_PUB.Add;

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;
186: END;
187:
188: IF( l_eam_failure_entry_record.object_type IS NOT NULL

Line 198: FND_MSG_PUB.Add;

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;
200: ELSE
201: l_eam_failure_entry_record.object_type := l_object_type;
202: END IF;

Line 214: FND_MSG_PUB.Add;

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;
216: ELSE
217: l_eam_failure_entry_record.object_id := l_object_id;
218: END IF;

Line 230: FND_MSG_PUB.Add;

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;
232: ELSE
233: l_eam_failure_entry_record.maint_organization_id := l_organization_id;
234: END IF;

Line 246: FND_MSG_PUB.Add;

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;
248: ELSE
249: l_eam_failure_entry_record.current_organization_id := l_organization_id;
250: END IF;

Line 271: FND_MSG_PUB.Add;

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;
273: END;
274:
275: IF (l_department_id IS NULL) THEN

Line 289: FND_MSG_PUB.Add;

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;
291: ELSE
292: l_eam_failure_entry_record.department_id := l_department_id;
293: END IF;

Line 305: FND_MSG_PUB.Add;

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;
307: ELSE
308: l_eam_failure_entry_record.area_id := l_eam_location_id;
309: END IF;

Line 349: FND_MSG_PUB.Add;

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;
351: END;
352: ELSE
353: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_FAILURE_ID');

Line 354: 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;
358:

Line 372: FND_MSG_PUB.Add;

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;
374: END;
375:
376: IF l_source_type = 1

Line 396: FND_MSG_PUB.Add;

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;
398: END IF;
399:
400: IF( ( l_eam_failure_entry_record.object_id IS NOT NULL

Line 416: FND_MSG_PUB.Add;

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;
418: END IF;
419:
420: IF( ( l_eam_failure_entry_record.source_type IS NOT NULL

Line 436: FND_MSG_PUB.Add;

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;
438: END IF;
439:
440: IF( ( l_eam_failure_entry_record.source_id IS NOT NULL

Line 456: FND_MSG_PUB.Add;

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;
458: ELSE
459: l_eam_failure_entry_record.source_id := l_source_id;
460: END IF;

Line 474: FND_MSG_PUB.Add;

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;
476: END;
477:
478: IF( ( l_eam_failure_entry_record.maint_organization_id IS NOT NULL

Line 494: FND_MSG_PUB.Add;

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;
496: ELSE
497: l_eam_failure_entry_record.maint_organization_id := l_organization_id;
498: END IF;

Line 516: FND_MSG_PUB.Add;

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;
518: ELSE
519: l_eam_failure_entry_record.current_organization_id := l_current_organization_id;
520: END IF;

Line 542: FND_MSG_PUB.Add;

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;
544: END;
545:
546: IF (l_department_id IS NULL) THEN

Line 567: FND_MSG_PUB.Add;

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;
569: ELSE
570: l_eam_failure_entry_record.department_id := l_department_id;
571: END IF;

Line 590: FND_MSG_PUB.Add;

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;
592: ELSE
593: l_eam_failure_entry_record.area_id := l_eam_location_id;
594: END IF;

Line 651: FND_MSG_PUB.Add;

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;
653: END;
654:
655: ELSE

Line 665: FND_MSG_PUB.Add;

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:
669: IF l_eam_failure_codes_tbl(i).failure_id <> l_eam_failure_entry_record.failure_id

Line 672: FND_MSG_PUB.Add;

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:
676: END IF;

Line 730: FND_MSG_PUB.Add;

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;
732: END;
733:
734: /********************************

Line 755: FND_MSG_PUB.Add;

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;
759:

Line 769: FND_MSG_PUB.Add;

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
773:

Line 782: FND_MSG_PUB.Add;

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
786: IF NOT ( ( l_failure_date IS NOT NULL

Line 800: FND_MSG_PUB.Add;

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;
804:

Line 813: FND_MSG_PUB.Add;

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
817: BEGIN

Line 824: FND_MSG_PUB.Add;

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
828: WHEN NO_DATA_FOUND THEN

Line 869: FND_MSG_PUB.Count_And_Get

865:
866: WHEN FND_API.G_EXC_ERROR THEN
867: ROLLBACK TO Process_Failure_Entry_PUB;
868: x_return_status := FND_API.G_RET_STS_ERROR ;
869: FND_MSG_PUB.Count_And_Get
870: (
871: p_count => x_msg_count ,
872: p_data => x_msg_data
873: );

Line 877: FND_MSG_PUB.Count_And_Get

873: );
874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
875: ROLLBACK TO Process_Failure_Entry_PUB;
876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
877: FND_MSG_PUB.Count_And_Get
878: (
879: p_count => x_msg_count,
880: p_data => x_msg_data
881: );

Line 885: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

881: );
882: WHEN OTHERS THEN
883: ROLLBACK TO Process_Failure_Entry_PUB;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
885: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
886: THEN
887: FND_MSG_PUB.Add_Exc_Msg
888: (
889: G_PKG_NAME,

Line 887: FND_MSG_PUB.Add_Exc_Msg

883: ROLLBACK TO Process_Failure_Entry_PUB;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
885: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
886: THEN
887: FND_MSG_PUB.Add_Exc_Msg
888: (
889: G_PKG_NAME,
890: l_api_name
891: );

Line 893: FND_MSG_PUB.Count_And_Get

889: G_PKG_NAME,
890: l_api_name
891: );
892: END IF;
893: FND_MSG_PUB.Count_And_Get
894: (
895: p_count => x_msg_count,
896: p_data => x_msg_data
897: );