DBA Data[Home] [Help]

APPS.AHL_APPR_DEPT_SHIFTS_PUB dependencies on FND_PROFILE

Line 505: IF l_status_id in (NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1), NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) THEN

501: FND_MESSAGE.Set_Token('INV', p_appr_deptshift_rec.SUBINVENTORY);
502: FND_MSG_PUB.ADD;
503: RAISE FND_API.G_EXC_ERROR;
504: ELSE
505: IF l_status_id in (NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1), NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) THEN
506: CLOSE validate_subinventory;
507: FND_MESSAGE.SET_NAME('AHL', 'AHL_SUBINVENTORY_NOT_SVC');
508: FND_MESSAGE.Set_Token('INV', p_appr_deptshift_rec.SUBINVENTORY);
509: FND_MSG_PUB.ADD;