DBA Data[Home] [Help]

APPS.EAM_ISOLATION_VALIDATE_PVT dependencies on WIP_CONSTANTS

Line 228: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.draft)) THEN

224:
225: -- status_type
226: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Isolation status_type. . . '); END IF;
227: BEGIN
228: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.draft)) THEN
229: raise fnd_api.g_exc_unexpected_error;
230: -- elsif (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.cancelled,wip_constants.comp_chrg,wip_constants.comp_nochrg,wip_constants.draft )) THEN
231: -- raise fnd_api.g_exc_unexpected_error;
232: END IF;

Line 230: -- elsif (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.cancelled,wip_constants.comp_chrg,wip_constants.comp_nochrg,wip_constants.draft )) THEN

226: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Isolation status_type. . . '); END IF;
227: BEGIN
228: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.draft)) THEN
229: raise fnd_api.g_exc_unexpected_error;
230: -- elsif (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.cancelled,wip_constants.comp_chrg,wip_constants.comp_nochrg,wip_constants.draft )) THEN
231: -- raise fnd_api.g_exc_unexpected_error;
232: END IF;
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234: EXCEPTION

Line 252: p_iso_header_rec.SYSTEM_STATUS = wip_constants.cancelled OR

248:
249: /* IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Isolation status_type for cancelled. . . '); END IF;
250: BEGIN
251: IF (p_iso_header_rec.transaction_type= EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND
252: p_iso_header_rec.SYSTEM_STATUS = wip_constants.cancelled OR
253: p_iso_header_rec.ISOLATION_NAME <> p_old_iso_header_rec.ISOLATION_NAME OR
254: p_iso_header_rec.DESCRIPTION <> p_old_iso_header_rec.DESCRIPTION OR
255: p_iso_header_rec.ORGANIZATION_ID <> p_old_iso_header_rec.ORGANIZATION_ID OR
256: p_iso_header_rec.ISOLATION_TYPE <> p_old_iso_header_rec.ISOLATION_TYPE OR