DBA Data[Home] [Help]

APPS.EAM_PROCESS_ISOLATION_PVT dependencies on FND_API

Line 51: x_return_status := FND_API.G_RET_STS_SUCCESS;

47:
48: IF (p_entity = 'ISOLATION') THEN
49: IF (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_CREATE)
50: OR (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_UPDATE) then
51: x_return_status := FND_API.G_RET_STS_SUCCESS;
52:
53: ELSE
54: x_return_status := FND_API.G_RET_STS_ERROR;
55: END IF;

Line 54: x_return_status := FND_API.G_RET_STS_ERROR;

50: OR (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_UPDATE) then
51: x_return_status := FND_API.G_RET_STS_SUCCESS;
52:
53: ELSE
54: x_return_status := FND_API.G_RET_STS_ERROR;
55: END IF;
56: END IF;
57:
58: END VALIDATE_TRANSACTION_TYPE;

Line 130: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

126: , x_mesg_token_tbl => l_out_Mesg_Token_Tbl
127: , x_return_status => l_return_status
128: );
129:
130: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
131: THEN
132: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
133: ( p_mesg_token_Tbl => l_out_Mesg_Token_Tbl
134: , p_error_level => l_error_level

Line 137: raise fnd_api.g_exc_unexpected_error;

133: ( p_mesg_token_Tbl => l_out_Mesg_Token_Tbl
134: , p_error_level => l_error_level
135: , p_entity_index => l_entity_index
136: );
137: raise fnd_api.g_exc_unexpected_error;
138: END IF;
139: l_isolation_id :=lx_iso_header_rec.isolation_id;
140: IF p_establish_iso_tbl.COUNT > 0 THEN
141: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling ESTABLISHMENT from PROCESS_ISOLATION'); end if;

Line 152: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

148: , x_mesg_token_tbl => l_out_Mesg_Token_Tbl
149: , x_return_status => l_return_status
150: );
151:
152: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
153: THEN
154: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
155: ( p_mesg_token_Tbl => l_out_Mesg_Token_Tbl
156: , p_error_level => l_error_level

Line 159: raise fnd_api.g_exc_unexpected_error;

155: ( p_mesg_token_Tbl => l_out_Mesg_Token_Tbl
156: , p_error_level => l_error_level
157: , p_entity_index => l_entity_index
158: );
159: raise fnd_api.g_exc_unexpected_error;
160: END IF;
161:
162: END IF;
163:

Line 177: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

173: , x_mesg_token_tbl => l_out_Mesg_Token_Tbl
174: , x_return_status => l_return_status
175: );
176:
177: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
178: THEN
179: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
180: ( p_mesg_token_Tbl => l_out_Mesg_Token_Tbl
181: , p_error_level => l_error_level

Line 184: raise fnd_api.g_exc_unexpected_error;

180: ( p_mesg_token_Tbl => l_out_Mesg_Token_Tbl
181: , p_error_level => l_error_level
182: , p_entity_index => l_entity_index
183: );
184: raise fnd_api.g_exc_unexpected_error;
185: END IF;
186:
187: END IF;
188:

Line 208: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

204: , x_mesg_token_tbl => l_out_Mesg_Token_Tbl
205: , x_return_status => l_return_status
206: );
207:
208: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
209: THEN
210: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
211: ( p_mesg_token_Tbl => l_out_Mesg_Token_Tbl
212: , p_error_level => l_error_level

Line 215: raise fnd_api.g_exc_unexpected_error;

211: ( p_mesg_token_Tbl => l_out_Mesg_Token_Tbl
212: , p_error_level => l_error_level
213: , p_entity_index => l_entity_index
214: );
215: raise fnd_api.g_exc_unexpected_error;
216: END IF;
217:
218: END IF;
219: x_return_status :=l_return_status;

Line 222: IF (p_commit = FND_API.G_TRUE) THEN

218: END IF;
219: x_return_status :=l_return_status;
220: x_isolation_id :=lx_iso_header_rec.isolation_id;
221:
222: IF (p_commit = FND_API.G_TRUE) THEN
223: COMMIT;
224: END IF;
225:
226:

Line 229: WHEN fnd_api.g_exc_unexpected_error THEN

225:
226:
227: EXCEPTION
228:
229: WHEN fnd_api.g_exc_unexpected_error THEN
230: ROLLBACK TO PROCESS_ISOLATION;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
233:

Line 231: x_return_status := FND_API.G_RET_STS_ERROR;

227: EXCEPTION
228:
229: WHEN fnd_api.g_exc_unexpected_error THEN
230: ROLLBACK TO PROCESS_ISOLATION;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
233:
234: WHEN OTHERS THEN
235: ROLLBACK TO PROCESS_ISOLATION;

Line 236: x_return_status := FND_API.G_RET_STS_ERROR;

232: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
233:
234: WHEN OTHERS THEN
235: ROLLBACK TO PROCESS_ISOLATION;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237:
238:
239: END PROCESS_ISOLATION;
240:

Line 303: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

299: , x_mesg_token_Tbl => l_Mesg_Token_Tbl
300: , x_return_Status => l_return_status
301: );
302:
303: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
304: THEN
305: RAISE l_isolation_transaction_error;
306: END IF;
307:

Line 309: IF (l_isolation_id IS NULL) OR (l_isolation_id = FND_API.G_MISS_NUM) THEN

305: RAISE l_isolation_transaction_error;
306: END IF;
307:
308: IF (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_CREATE) THEN
309: IF (l_isolation_id IS NULL) OR (l_isolation_id = FND_API.G_MISS_NUM) THEN
310: OPEN C;
311: FETCH C INTO l_isolation_id;
312: CLOSE C;
313: l_iso_header_rec.isolation_id :=l_isolation_id;

Line 325: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

321: , x_iso_header_rec => l_old_iso_header_rec
322: , x_mesg_token_Tbl => l_Mesg_Token_Tbl
323: , x_return_Status => l_return_status
324: );
325: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
326: THEN
327: RAISE l_isolation_existence_error;
328: END IF;
329:

Line 351: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

347: , x_mesg_token_Tbl => l_Mesg_Token_Tbl
348: , x_return_Status => l_return_status
349: );
350:
351: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
352: THEN
353: RAISE l_isolation_required_error;
354: END IF;
355:

Line 366: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

362: , x_mesg_token_Tbl => l_Mesg_Token_Tbl
363: , x_return_Status => l_return_status
364: );
365:
366: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
367: Then
368: RAISE l_isolation_attributes_error;
369: END IF;
370:

Line 439: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

435: , x_mesg_token_Tbl => l_Mesg_Token_Tbl
436: , x_return_Status => l_return_status
437: );
438:
439: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
440: THEN
441: RAISE l_isolation_write_error;
442: END IF;
443:

Line 451: OR (l_iso_header_rec.APPROVED_BY <> FND_API.G_MISS_NUM))

447:
448: --If isolation is approved and no workflow then call the procedure CHANGE_ISOLATION_STATUS
449: IF((l_workflow_enabled = 'N')
450: OR (l_iso_header_rec.APPROVED_BY IS NOT NULL)
451: OR (l_iso_header_rec.APPROVED_BY <> FND_API.G_MISS_NUM))
452: AND (l_old_iso_header_rec.SYSTEM_STATUS <>l_iso_header_rec.SYSTEM_STATUS) THEN
453:
454: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling CHANGE_ISOLATION_STATUS') ; END IF ;
455:

Line 469: l_return_status := FND_API.G_RET_STS_ERROR;

465: );
466:
467: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Status Change Isolation completed with status ' || l_return_status) ; END IF ;
468: IF NVL(l_return_status, 'S') <> 'S' THEN
469: l_return_status := FND_API.G_RET_STS_ERROR;
470: RAISE l_err_status_change;
471:
472: END IF;
473:

Line 519: x_return_status := FND_API.G_RET_STS_ERROR;

515: , x_mesg_token_tbl => l_out_mesg_token_tbl
516: );
517: l_mesg_token_tbl := l_out_mesg_token_tbl;
518:
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: x_mesg_token_tbl := l_mesg_token_tbl ;
521:
522: WHEN l_isolation_transaction_error then
523: ROLLBACK TO WORK_ISOLATION;

Line 536: x_return_status := FND_API.G_RET_STS_ERROR;

532: , x_mesg_token_tbl => l_out_mesg_token_tbl
533: );
534: l_mesg_token_tbl := l_out_mesg_token_tbl;
535:
536: x_return_status := FND_API.G_RET_STS_ERROR;
537: x_mesg_token_tbl := l_mesg_token_tbl ;
538:
539: WHEN l_isolation_existence_error then
540: ROLLBACK TO WORK_ISOLATION;

Line 553: x_return_status := FND_API.G_RET_STS_ERROR;

549: , x_mesg_token_tbl => l_out_mesg_token_tbl
550: );
551: l_mesg_token_tbl := l_out_mesg_token_tbl;
552:
553: x_return_status := FND_API.G_RET_STS_ERROR;
554: x_mesg_token_tbl := l_mesg_token_tbl ;
555:
556: WHEN l_isolation_required_error then
557: l_token_tbl(1).token_name := 'SAFETY_NAME';

Line 570: x_return_status := FND_API.G_RET_STS_ERROR;

566: , x_mesg_token_tbl => l_out_mesg_token_tbl
567: );
568: l_mesg_token_tbl := l_out_mesg_token_tbl;
569:
570: x_return_status := FND_API.G_RET_STS_ERROR;
571: x_mesg_token_tbl := l_mesg_token_tbl ;
572:
573: WHEN l_isolation_attributes_error then
574: ROLLBACK TO WORK_ISOLATION;

Line 586: x_return_status := FND_API.G_RET_STS_ERROR;

582: , p_mesg_token_tbl => l_mesg_token_tbl
583: , x_mesg_token_tbl => l_out_mesg_token_tbl
584: );
585: l_mesg_token_tbl := l_out_mesg_token_tbl;
586: x_return_status := FND_API.G_RET_STS_ERROR;
587: x_mesg_token_tbl := l_mesg_token_tbl ;
588:
589: WHEN l_err_status_change then
590: ROLLBACK TO WORK_ISOLATION;

Line 602: x_return_status := FND_API.G_RET_STS_ERROR;

598: , p_mesg_token_tbl => l_mesg_token_tbl
599: , x_mesg_token_tbl => l_out_mesg_token_tbl
600: );
601: l_mesg_token_tbl := l_out_mesg_token_tbl;
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: x_mesg_token_tbl := l_mesg_token_tbl ;
604:
605:
606: WHEN OTHERS THEN

Line 621: x_return_status := FND_API.G_RET_STS_ERROR;

617: , x_mesg_token_tbl => l_out_mesg_token_tbl
618: );
619: l_mesg_token_tbl := l_out_mesg_token_tbl;
620:
621: x_return_status := FND_API.G_RET_STS_ERROR;
622: x_mesg_token_tbl := l_mesg_token_tbl ;
623:
624:
625:

Line 745: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

741: ( p_safety_establishment_rec => l_establish_iso_rec
742: , x_mesg_token_Tbl => l_Mesg_Token_Tbl
743: , x_return_Status => l_return_status
744: );
745: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
746: THEN
747: Raise L_estab_required_error;
748: End If;
749:

Line 758: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

754: , x_mesg_token_Tbl => l_Mesg_Token_Tbl
755: , x_return_Status => l_return_status
756: );
757:
758: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
759: THEN
760: RAISE ISO_ESTABLISH_ERROR;
761: END IF;
762:

Line 781: x_return_status := FND_API.G_RET_STS_ERROR;

777: , p_mesg_token_tbl => l_mesg_token_tbl
778: , x_mesg_token_tbl => l_out_mesg_token_tbl
779: );
780: l_mesg_token_tbl := l_out_mesg_token_tbl;
781: x_return_status := FND_API.G_RET_STS_ERROR;
782: x_mesg_token_tbl := l_mesg_token_tbl ;
783:
784: WHEN l_estab_required_error THEN
785: ROLLBACK TO ESTABLISHMENT;

Line 795: x_return_status := FND_API.G_RET_STS_ERROR;

791: , p_mesg_token_tbl => l_mesg_token_tbl
792: , x_mesg_token_tbl => l_out_mesg_token_tbl
793: );
794: l_mesg_token_tbl := l_out_mesg_token_tbl;
795: x_return_status := FND_API.G_RET_STS_ERROR;
796: x_mesg_token_tbl := l_mesg_token_tbl ;
797:
798: WHEN ISO_ESTABLISH_ERROR THEN
799: ROLLBACK TO ESTABLISHMENT;

Line 809: x_return_status := FND_API.G_RET_STS_ERROR;

805: , p_mesg_token_tbl => l_mesg_token_tbl
806: , x_mesg_token_tbl => l_out_mesg_token_tbl
807: );
808: l_mesg_token_tbl := l_out_mesg_token_tbl;
809: x_return_status := FND_API.G_RET_STS_ERROR;
810: X_mesg_token_tbl := L_mesg_token_tbl ;
811:
812: When Saf_estab_seq_duplicate Then
813: ROLLBACK TO ESTABLISHMENT;

Line 825: X_return_status := Fnd_api.G_ret_sts_error;

821: , p_mesg_token_tbl => l_mesg_token_tbl
822: , x_mesg_token_tbl => l_out_mesg_token_tbl
823: );
824: l_mesg_token_tbl := l_out_mesg_token_tbl;
825: X_return_status := Fnd_api.G_ret_sts_error;
826: X_mesg_token_tbl := L_mesg_token_tbl ;
827:
828: WHEN OTHERS THEN
829:

Line 831: x_return_status := FND_API.G_RET_STS_ERROR;

827:
828: WHEN OTHERS THEN
829:
830: ROLLBACK TO ESTABLISHMENT;
831: x_return_status := FND_API.G_RET_STS_ERROR;
832: END ESTABLISHMENT;
833:
834: /********************************************************************
835: * Procedure: Raise_Workflow_Events

Line 935: x_return_status := FND_API.G_RET_STS_ERROR;

931:
932: EXCEPTION
933: WHEN OTHERS THEN
934: WF_CORE.CONTEXT('Enterprise Asset Management...',l_event_name,'Exception during event construction and raise: ' || SQLERRM);
935: x_return_status := FND_API.G_RET_STS_ERROR;
936:
937: END RAISE_WORKFLOW_EVENTS;
938:
939: END EAM_PROCESS_ISOLATION_PVT;