APPS.AHL_APPR_DEPT_SHIFTS_PUB dependencies on FND_PROFILE

Line 479: 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

475: FND_MESSAGE.Set_Token('INV', p_appr_deptshift_rec.SUBINVENTORY);
476: FND_MSG_PUB.ADD;
477: RAISE FND_API.G_EXC_ERROR;
478: ELSE
479: 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
480: CLOSE validate_subinventory;
481: FND_MESSAGE.SET_NAME('AHL', 'AHL_SUBINVENTORY_NOT_SVC');
482: FND_MESSAGE.Set_Token('INV', p_appr_deptshift_rec.SUBINVENTORY);
483: FND_MSG_PUB.ADD;