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 274: FND_MSG_PUB.Add;

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;
276: END;
277:
278: IF (l_department_id IS NULL) THEN

Line 292: FND_MSG_PUB.Add;

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;
294: ELSE
295: l_eam_failure_entry_record.department_id := l_department_id;
296: END IF;

Line 308: FND_MSG_PUB.Add;

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;
310: ELSE
311: l_eam_failure_entry_record.area_id := l_eam_location_id;
312: END IF;

Line 352: FND_MSG_PUB.Add;

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;
354: END;
355: ELSE
356: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_FAILURE_ID');

Line 357: 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;
361:

Line 375: FND_MSG_PUB.Add;

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;
377: END;
378:
379: IF l_source_type = 1

Line 399: FND_MSG_PUB.Add;

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;
401: END IF;
402:
403: IF( ( l_eam_failure_entry_record.object_id IS NOT NULL

Line 419: FND_MSG_PUB.Add;

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;
421: END IF;
422:
423: IF( ( l_eam_failure_entry_record.source_type IS NOT NULL

Line 439: FND_MSG_PUB.Add;

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;
441: END IF;
442:
443: IF( ( l_eam_failure_entry_record.source_id IS NOT NULL

Line 459: FND_MSG_PUB.Add;

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;
461: ELSE
462: l_eam_failure_entry_record.source_id := l_source_id;
463: END IF;

Line 477: FND_MSG_PUB.Add;

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;
479: END;
480:
481: IF( ( l_eam_failure_entry_record.maint_organization_id IS NOT NULL

Line 497: FND_MSG_PUB.Add;

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;
499: ELSE
500: l_eam_failure_entry_record.maint_organization_id := l_organization_id;
501: END IF;

Line 519: FND_MSG_PUB.Add;

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;
521: ELSE
522: l_eam_failure_entry_record.current_organization_id := l_current_organization_id;
523: END IF;

Line 548: FND_MSG_PUB.Add;

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;
550: END;
551:
552: IF (l_department_id IS NULL) THEN

Line 573: FND_MSG_PUB.Add;

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;
575: ELSE
576: l_eam_failure_entry_record.department_id := l_department_id;
577: END IF;

Line 596: FND_MSG_PUB.Add;

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;
598: ELSE
599: l_eam_failure_entry_record.area_id := l_eam_location_id;
600: END IF;

Line 657: FND_MSG_PUB.Add;

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;
659: END;
660:
661: ELSE

Line 671: FND_MSG_PUB.Add;

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

Line 678: FND_MSG_PUB.Add;

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

Line 736: FND_MSG_PUB.Add;

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;
738: END;
739:
740: /********************************

Line 761: FND_MSG_PUB.Add;

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

Line 775: FND_MSG_PUB.Add;

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

Line 788: FND_MSG_PUB.Add;

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

Line 806: FND_MSG_PUB.Add;

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

Line 819: FND_MSG_PUB.Add;

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

Line 830: FND_MSG_PUB.Add;

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

Line 875: FND_MSG_PUB.Count_And_Get

871:
872: WHEN FND_API.G_EXC_ERROR THEN
873: ROLLBACK TO Process_Failure_Entry_PUB;
874: x_return_status := FND_API.G_RET_STS_ERROR ;
875: FND_MSG_PUB.Count_And_Get
876: (
877: p_count => x_msg_count ,
878: p_data => x_msg_data
879: );

Line 883: FND_MSG_PUB.Count_And_Get

879: );
880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
881: ROLLBACK TO Process_Failure_Entry_PUB;
882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
883: FND_MSG_PUB.Count_And_Get
884: (
885: p_count => x_msg_count,
886: p_data => x_msg_data
887: );

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

887: );
888: WHEN OTHERS THEN
889: ROLLBACK TO Process_Failure_Entry_PUB;
890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
891: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
892: THEN
893: FND_MSG_PUB.Add_Exc_Msg
894: (
895: G_PKG_NAME,

Line 893: FND_MSG_PUB.Add_Exc_Msg

889: ROLLBACK TO Process_Failure_Entry_PUB;
890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
891: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
892: THEN
893: FND_MSG_PUB.Add_Exc_Msg
894: (
895: G_PKG_NAME,
896: l_api_name
897: );

Line 899: FND_MSG_PUB.Count_And_Get

895: G_PKG_NAME,
896: l_api_name
897: );
898: END IF;
899: FND_MSG_PUB.Count_And_Get
900: (
901: p_count => x_msg_count,
902: p_data => x_msg_data
903: );