APPS.EAM_PROCESS_PERMIT_PVT dependencies on WIP_CONSTANTS

Line 443: IF (l_work_permit_header_rec.status_type in (wip_constants.comp_chrg,wip_constants.comp_nochrg)) THEN

439: END IF; --end of check for workflow enabled
440:
441: -- Put permit completion details if status is changed to complete
442:
443: IF (l_work_permit_header_rec.status_type in (wip_constants.comp_chrg,wip_constants.comp_nochrg)) THEN
444:
445: IF (l_old_work_permit_header_rec.status_type = wip_constants.draft) THEN
446: RAISE l_err_status_change;
447: ELSE

Line 445: IF (l_old_work_permit_header_rec.status_type = wip_constants.draft) THEN

441: -- Put permit completion details if status is changed to complete
442:
443: IF (l_work_permit_header_rec.status_type in (wip_constants.comp_chrg,wip_constants.comp_nochrg)) THEN
444:
445: IF (l_old_work_permit_header_rec.status_type = wip_constants.draft) THEN
446: RAISE l_err_status_change;
447: ELSE
448: l_work_permit_header_rec.COMPLETION_DATE := NVL(l_work_permit_header_rec.COMPLETION_DATE,sysdate);
449: END IF;

Line 702: (l_wo_status not in (wip_constants.released, wip_constants.draft) or

698: and organization_id =p_organization_id;
699:
700:
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:

Line 703: l_permit_status not in (wip_constants.released, wip_constants.draft))) then

699:
700:
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

Line 708: (l_wo_status not in (wip_constants.released, wip_constants.draft) or

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
710:
711: raise fnd_api.g_exc_unexpected_error;
712:

Line 709: l_permit_status not in (wip_constants.released, wip_constants.draft))) then

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
710:
711: raise fnd_api.g_exc_unexpected_error;
712:
713: end if;

Line 1013: -- IF (l_work_permit_header_rec.STATUS_TYPE = wip_constants.comp_chrg) THEN

1009: IF l_work_permit_header_rec.VALID_TO < SYSDATE THEN
1010: l_work_permit_header_rec.VALID_TO :=NULL;
1011: END IF;
1012:
1013: -- IF (l_work_permit_header_rec.STATUS_TYPE = wip_constants.comp_chrg) THEN
1014: l_work_permit_header_rec.STATUS_TYPE :=wip_constants.draft;
1015: l_work_permit_header_rec.USER_DEFINED_STATUS_ID :=wip_constants.draft;
1016: -- END IF;
1017:

Line 1014: l_work_permit_header_rec.STATUS_TYPE :=wip_constants.draft;

1010: l_work_permit_header_rec.VALID_TO :=NULL;
1011: END IF;
1012:
1013: -- IF (l_work_permit_header_rec.STATUS_TYPE = wip_constants.comp_chrg) THEN
1014: l_work_permit_header_rec.STATUS_TYPE :=wip_constants.draft;
1015: l_work_permit_header_rec.USER_DEFINED_STATUS_ID :=wip_constants.draft;
1016: -- END IF;
1017:
1018:

Line 1015: l_work_permit_header_rec.USER_DEFINED_STATUS_ID :=wip_constants.draft;

1011: END IF;
1012:
1013: -- IF (l_work_permit_header_rec.STATUS_TYPE = wip_constants.comp_chrg) THEN
1014: l_work_permit_header_rec.STATUS_TYPE :=wip_constants.draft;
1015: l_work_permit_header_rec.USER_DEFINED_STATUS_ID :=wip_constants.draft;
1016: -- END IF;
1017:
1018:
1019: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling WORK_PERMIT from PROCESS_WORK_PERMIT'); end if;