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_PERMIT_PVT dependencies on FND_API

Line 52: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 55: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 169: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

165: , x_work_permit_header_rec => x_work_permit_header_rec
166: , x_mesg_token_tbl => l_out_Mesg_Token_Tbl
167: , x_return_status => l_return_status
168: );
169: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
170: THEN
171: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
172: ( p_mesg_token_Tbl => l_out_Mesg_Token_Tbl
173: , p_error_level => l_error_level

Line 176: raise fnd_api.g_exc_unexpected_error;

172: ( p_mesg_token_Tbl => l_out_Mesg_Token_Tbl
173: , p_error_level => l_error_level
174: , p_entity_index => l_entity_index
175: );
176: raise fnd_api.g_exc_unexpected_error;
177: END IF;
178:
179: l_permit_id :=x_work_permit_header_rec.permit_id;
180:

Line 205: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

201: );
202: END IF;
203:
204:
205: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
206: THEN
207: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
208: ( p_mesg_token_Tbl => l_out_Mesg_Token_Tbl
209: , p_error_level => l_error_level

Line 212: raise fnd_api.g_exc_unexpected_error;

208: ( p_mesg_token_Tbl => l_out_Mesg_Token_Tbl
209: , p_error_level => l_error_level
210: , p_entity_index => l_entity_index
211: );
212: raise fnd_api.g_exc_unexpected_error;
213: END IF;
214:
215: IF p_permit_wo_association_tbl.COUNT > 0 THEN
216: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling PERMIT_WORK_ORDER_ASSOCIATION from PROCESS_WORK_PERMIT'); end if;

Line 237: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

233:
234: END IF;
235:
236:
237: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
238: THEN
239: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
240: ( p_mesg_token_Tbl => l_out_Mesg_Token_Tbl
241: , p_error_level => l_error_level

Line 244: raise fnd_api.g_exc_unexpected_error;

240: ( p_mesg_token_Tbl => l_out_Mesg_Token_Tbl
241: , p_error_level => l_error_level
242: , p_entity_index => l_entity_index
243: );
244: raise fnd_api.g_exc_unexpected_error;
245: END IF;
246:
247: x_return_status :=l_return_status;
248:

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

245: END IF;
246:
247: x_return_status :=l_return_status;
248:
249: IF (p_commit = FND_API.G_TRUE) THEN
250: COMMIT;
251: END IF;
252:
253:

Line 256: WHEN fnd_api.g_exc_unexpected_error THEN

252:
253:
254: EXCEPTION
255:
256: WHEN fnd_api.g_exc_unexpected_error THEN
257: ROLLBACK TO PROCESS_PERMIT;
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
260:

Line 258: x_return_status := FND_API.G_RET_STS_ERROR;

254: EXCEPTION
255:
256: WHEN fnd_api.g_exc_unexpected_error THEN
257: ROLLBACK TO PROCESS_PERMIT;
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
260:
261: WHEN OTHERS THEN
262: ROLLBACK TO PROCESS_PERMIT;

Line 263: x_return_status := FND_API.G_RET_STS_ERROR;

259: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
260:
261: WHEN OTHERS THEN
262: ROLLBACK TO PROCESS_PERMIT;
263: x_return_status := FND_API.G_RET_STS_ERROR;
264:
265:
266: END PROCESS_WORK_PERMIT;
267:

Line 329: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

325: , x_mesg_token_Tbl => l_Mesg_Token_Tbl
326: , x_return_Status => l_return_status
327: );
328:
329: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
330: THEN
331: RAISE l_permit_transaction_error;
332: END IF;
333:

Line 335: IF (l_permit_id IS NULL) OR (l_permit_id = FND_API.G_MISS_NUM) THEN

331: RAISE l_permit_transaction_error;
332: END IF;
333:
334: IF (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_CREATE) THEN
335: IF (l_permit_id IS NULL) OR (l_permit_id = FND_API.G_MISS_NUM) THEN
336: OPEN C;
337: FETCH C INTO l_permit_id;
338: CLOSE C;
339: l_work_permit_header_rec.permit_id :=l_permit_id;

Line 353: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

349: , x_return_Status => l_return_status
350: );
351:
352:
353: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
354: THEN
355: RAISE l_permit_existence_error;
356: END IF;
357:

Line 382: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

378: , x_mesg_token_Tbl => l_Mesg_Token_Tbl
379: , x_return_Status => l_return_status
380: );
381:
382: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
383: THEN
384: RAISE l_permit_required_error;
385: END IF;
386:

Line 398: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

394: , x_mesg_token_Tbl => l_Mesg_Token_Tbl
395: , x_return_Status => l_return_status
396: );
397:
398: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
399: THEN
400: RAISE l_permit_attributes_error;
401: END IF;
402:

Line 460: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

456: ( p_work_permit_header_rec => l_work_permit_header_rec
457: , x_mesg_token_Tbl => l_Mesg_Token_Tbl
458: , x_return_Status => l_return_status
459: );
460: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
461: THEN
462: RAISE l_permit_write_error;
463: END IF;
464:

Line 472: OR (l_work_permit_header_rec.APPROVED_BY <> FND_API.G_MISS_NUM) THEN

468:
469: --If work permit is approved and no workflow then call the procedure CHANGE_WORK_PERMIT_STATUS
470: IF(l_workflow_enabled = 'N')
471: OR (l_work_permit_header_rec.APPROVED_BY IS NOT NULL)
472: OR (l_work_permit_header_rec.APPROVED_BY <> FND_API.G_MISS_NUM) THEN
473:
474: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling CHANGE_WORK_PERMIT_STATUS') ; END IF ;
475:
476: EAM_PERMIT_UTILITY_PVT.CHANGE_WORK_PERMIT_STATUS

Line 489: l_return_status := FND_API.G_RET_STS_ERROR;

485: );
486:
487: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Status Change WO completed with status ' || l_return_status) ; END IF ;
488: IF NVL(l_return_status, 'S') <> 'S' THEN
489: l_return_status := FND_API.G_RET_STS_ERROR;
490: RAISE l_err_status_change;
491:
492: END IF;
493:

Line 539: x_return_status := FND_API.G_RET_STS_ERROR;

535: , x_mesg_token_tbl => l_out_mesg_token_tbl
536: );
537: l_mesg_token_tbl := l_out_mesg_token_tbl;
538:
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: x_mesg_token_tbl := l_mesg_token_tbl ;
541: ROLLBACK TO WORK_PERMIT;
542:
543: WHEN l_permit_transaction_error then

Line 556: x_return_status := FND_API.G_RET_STS_ERROR;

552: , x_mesg_token_tbl => l_out_mesg_token_tbl
553: );
554: l_mesg_token_tbl := l_out_mesg_token_tbl;
555:
556: x_return_status := FND_API.G_RET_STS_ERROR;
557: x_mesg_token_tbl := l_mesg_token_tbl ;
558: ROLLBACK TO WORK_PERMIT;
559:
560: WHEN l_permit_existence_error then

Line 573: x_return_status := FND_API.G_RET_STS_ERROR;

569: , x_mesg_token_tbl => l_out_mesg_token_tbl
570: );
571: l_mesg_token_tbl := l_out_mesg_token_tbl;
572:
573: x_return_status := FND_API.G_RET_STS_ERROR;
574: x_mesg_token_tbl := l_mesg_token_tbl ;
575: ROLLBACK TO WORK_PERMIT;
576: WHEN l_permit_required_error then
577: l_token_tbl(1).token_name := 'PERMIT_NAME';

Line 589: x_return_status := FND_API.G_RET_STS_ERROR;

585: , x_mesg_token_tbl => l_out_mesg_token_tbl
586: );
587: l_mesg_token_tbl := l_out_mesg_token_tbl;
588:
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: x_mesg_token_tbl := l_mesg_token_tbl ;
591: ROLLBACK TO WORK_PERMIT;
592: WHEN l_permit_attributes_error then
593: l_token_tbl(1).token_name := 'PERMIT_NAME';

Line 605: x_return_status := FND_API.G_RET_STS_ERROR;

601: , x_mesg_token_tbl => l_out_mesg_token_tbl
602: );
603:
604: l_mesg_token_tbl := l_out_mesg_token_tbl;
605: x_return_status := FND_API.G_RET_STS_ERROR;
606: x_mesg_token_tbl := l_mesg_token_tbl ;
607: ROLLBACK TO WORK_PERMIT;
608: WHEN l_err_status_change then
609: l_token_tbl(1).token_name := 'PERMIT_NAME';

Line 620: x_return_status := FND_API.G_RET_STS_ERROR;

616: , p_mesg_token_tbl => l_mesg_token_tbl
617: , x_mesg_token_tbl => l_out_mesg_token_tbl
618: );
619: l_mesg_token_tbl := l_out_mesg_token_tbl;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: x_mesg_token_tbl := l_mesg_token_tbl ;
622: ROLLBACK TO WORK_PERMIT;
623:
624: WHEN OTHERS THEN

Line 636: x_return_status := FND_API.G_RET_STS_ERROR;

632: , x_mesg_token_tbl => l_out_mesg_token_tbl
633: );
634: l_mesg_token_tbl := l_out_mesg_token_tbl;
635:
636: x_return_status := FND_API.G_RET_STS_ERROR;
637: x_mesg_token_tbl := l_mesg_token_tbl ;
638: ROLLBACK TO WORK_PERMIT;
639:
640:

Line 705: raise fnd_api.g_exc_unexpected_error;

701: if (p_permit_wo_association_tbl(i).transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE and
702: (l_wo_status not in (wip_constants.released, wip_constants.draft) or
703: l_permit_status not in (wip_constants.released, wip_constants.draft))) then
704:
705: raise fnd_api.g_exc_unexpected_error;
706:
707: elsif (p_permit_wo_association_tbl(i).transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE and
708: (l_wo_status not in (wip_constants.released, wip_constants.draft) or
709: l_permit_status not in (wip_constants.released, wip_constants.draft))) then

Line 711: raise fnd_api.g_exc_unexpected_error;

707: elsif (p_permit_wo_association_tbl(i).transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE and
708: (l_wo_status not in (wip_constants.released, wip_constants.draft) or
709: l_permit_status not in (wip_constants.released, wip_constants.draft))) then
710:
711: raise fnd_api.g_exc_unexpected_error;
712:
713: end if;
714:
715: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 715: l_return_status := FND_API.G_RET_STS_SUCCESS;

711: raise fnd_api.g_exc_unexpected_error;
712:
713: end if;
714:
715: l_return_status := FND_API.G_RET_STS_SUCCESS;
716:
717:
718:
719: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 719: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

715: l_return_status := FND_API.G_RET_STS_SUCCESS;
716:
717:
718:
719: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
720: l_safety_assoc_rec := p_permit_wo_association_tbl(i);
721: if l_safety_assoc_rec.source_id is null then
722: l_safety_assoc_rec.source_id := p_work_permit_id;
723: end if;

Line 744: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

740: , p_association_type =>p_permit_wo_association_tbl(1).association_type
741: , x_mesg_token_Tbl => l_Mesg_Token_Tbl
742: , x_return_Status => l_return_status
743: );
744: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
745: THEN
746: RAISE l_wp_association_error;
747: END IF;
748: -- END IF;

Line 752: when fnd_api.g_exc_unexpected_error then

748: -- END IF;
749:
750: /* exception
751:
752: when fnd_api.g_exc_unexpected_error then
753: ROLLBACK TO PERMIT_WORK_ORDER_ASSOCIATION;
754: --l_token_tbl(1).token_name := 'Status type';
755: --l_token_tbl(1).token_value := p_eam_wo_rec.status_type;
756:

Line 766: x_return_status := FND_API.G_RET_STS_ERROR;

762: , x_mesg_token_tbl => l_out_mesg_token_tbl
763: );
764: l_mesg_token_tbl := l_out_mesg_token_tbl;
765:
766: x_return_status := FND_API.G_RET_STS_ERROR;
767: x_mesg_token_tbl := l_mesg_token_tbl ;
768: return;
769: WHEN l_wp_association_error then
770: ROLLBACK TO PERMIT_WORK_ORDER_ASSOCIATION;

Line 783: x_return_status := FND_API.G_RET_STS_ERROR;

779: , x_mesg_token_tbl => l_out_mesg_token_tbl
780: );
781: l_mesg_token_tbl := l_out_mesg_token_tbl;
782:
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: x_mesg_token_tbl := l_mesg_token_tbl ;
785:
786: return;
787: when no_data_found then

Line 801: x_return_status := FND_API.G_RET_STS_ERROR;

797: , x_mesg_token_tbl => l_out_mesg_token_tbl
798: );
799: l_mesg_token_tbl := l_out_mesg_token_tbl;
800:
801: x_return_status := FND_API.G_RET_STS_ERROR;
802: x_mesg_token_tbl := l_mesg_token_tbl ;
803: return;
804:
805: end;*/

Line 827: x_return_status := FND_API.G_RET_STS_ERROR;

823: , p_token_tbl => l_token_tbl
824: );
825: l_mesg_token_tbl := l_out_mesg_token_tbl;*/
826: /* ROLLBACK TO PERMIT_WORK_ORDER_ASSOCIATION;
827: x_return_status := FND_API.G_RET_STS_ERROR;
828:
829: END PERMIT_WORK_ORDER_ASSOCIATION;*/
830:
831:

Line 933: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 989: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

985: , x_work_permit_header_rec => l_work_permit_header_rec
986: , x_return_Status => l_return_status
987: );
988:
989: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
990: THEN
991: RAISE fnd_api.g_exc_unexpected_error;
992: END IF;
993: /*Get the next permit name sequence*/

Line 991: RAISE fnd_api.g_exc_unexpected_error;

987: );
988:
989: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
990: THEN
991: RAISE fnd_api.g_exc_unexpected_error;
992: END IF;
993: /*Get the next permit name sequence*/
994: OPEN C;
995: FETCH C INTO l_permit_name;

Line 1054: IF(x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

1050: X_request_id => ''
1051: );
1052:
1053:
1054: IF(x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1055: px_permit_id :=l_out_work_permit_header_rec.permit_id;
1056: IF(p_commit = FND_API.G_TRUE) THEN
1057: COMMIT;
1058: END IF;

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

1052:
1053:
1054: IF(x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1055: px_permit_id :=l_out_work_permit_header_rec.permit_id;
1056: IF(p_commit = FND_API.G_TRUE) THEN
1057: COMMIT;
1058: END IF;
1059: END IF;
1060:

Line 1062: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

1058: END IF;
1059: END IF;
1060:
1061:
1062: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1063: THEN
1064: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
1065: ( p_mesg_token_Tbl => l_out_Mesg_Token_Tbl
1066: , p_error_level => l_error_level

Line 1069: raise fnd_api.g_exc_unexpected_error;

1065: ( p_mesg_token_Tbl => l_out_Mesg_Token_Tbl
1066: , p_error_level => l_error_level
1067: , p_entity_index => l_entity_index
1068: );
1069: raise fnd_api.g_exc_unexpected_error;
1070: END IF;
1071:
1072: EXCEPTION
1073: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1073: WHEN fnd_api.g_exc_unexpected_error THEN

1069: raise fnd_api.g_exc_unexpected_error;
1070: END IF;
1071:
1072: EXCEPTION
1073: WHEN fnd_api.g_exc_unexpected_error THEN
1074: ROLLBACK TO COPY_PERMIT;
1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
1077: WHEN OTHERS THEN

Line 1075: x_return_status := FND_API.G_RET_STS_ERROR;

1071:
1072: EXCEPTION
1073: WHEN fnd_api.g_exc_unexpected_error THEN
1074: ROLLBACK TO COPY_PERMIT;
1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
1077: WHEN OTHERS THEN
1078: ROLLBACK TO COPY_PERMIT;
1079: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1079: x_return_status := FND_API.G_RET_STS_ERROR;

1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
1077: WHEN OTHERS THEN
1078: ROLLBACK TO COPY_PERMIT;
1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080:
1081: END COPY_WORK_PERMIT;
1082:
1083: END EAM_PROCESS_PERMIT_PVT;