APPS.AHL_UMP_NONROUTINES_PVT dependencies on FND_PROFILE

Line 2920: p_x_nonroutine_rec.type_id := fnd_profile.value('AHL_PRD_SR_TYPE');

2916: FND_MSG_PUB.ADD;
2917: END;
2918: ELSIF (p_x_nonroutine_rec.type_id is null or p_x_nonroutine_rec.type_id = FND_API.G_MISS_NUM)
2919: THEN
2920: p_x_nonroutine_rec.type_id := fnd_profile.value('AHL_PRD_SR_TYPE');
2921:
2922: IF (p_x_nonroutine_rec.type_id is null or p_x_nonroutine_rec.type_id = FND_API.G_MISS_NUM)
2923: THEN
2924: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_TYPE_NULL');

Line 2946: p_x_nonroutine_rec.status_id := nvl(fnd_profile.value('AHL_PRD_SR_STATUS'), G_SR_OPEN_STATUS_ID);

2942: FND_MSG_PUB.ADD;
2943: END;
2944: ELSIF (p_x_nonroutine_rec.status_id is null or p_x_nonroutine_rec.status_id = FND_API.G_MISS_NUM)
2945: THEN
2946: p_x_nonroutine_rec.status_id := nvl(fnd_profile.value('AHL_PRD_SR_STATUS'), G_SR_OPEN_STATUS_ID);
2947: END IF;
2948:
2949: -- Validate and default SR severity
2950: IF (p_x_nonroutine_rec.severity_name is not null and p_x_nonroutine_rec.severity_name <> FND_API.G_MISS_CHAR)

Line 2966: p_x_nonroutine_rec.severity_id := fnd_profile.value('AHL_PRD_SR_SEVERITY');

2962: FND_MSG_PUB.ADD;
2963: END;
2964: ELSIF (p_x_nonroutine_rec.severity_id is null or p_x_nonroutine_rec.severity_id = FND_API.G_MISS_NUM)
2965: THEN
2966: p_x_nonroutine_rec.severity_id := fnd_profile.value('AHL_PRD_SR_SEVERITY');
2967:
2968: IF (p_x_nonroutine_rec.severity_id is null or p_x_nonroutine_rec.severity_id = FND_API.G_MISS_NUM)
2969: THEN
2970: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_SEVERITY_NULL');

Line 3098: IF ( nvl(fnd_profile.value('AHL_SR_RESL_CODE_COMP'), 'N') = 'Y') THEN

3094: -- Bug # 6447467 -- start
3095: -- Check if resolution_code is not null. If resolution_code
3096: -- is null then return error message.
3097:
3098: IF ( nvl(fnd_profile.value('AHL_SR_RESL_CODE_COMP'), 'N') = 'Y') THEN
3099:
3100: IF ( p_x_nonroutine_rec.resolution_code IS NULL OR
3101: p_x_nonroutine_rec.resolution_code = FND_API.G_MISS_CHAR) THEN
3102:

Line 3170: IF ( nvl(fnd_profile.value('AHL_SR_RESL_CODE_COMP'), 'N') = 'Y') THEN

3166: -- Bug # 6447467 -- start
3167: -- Check if resolution_code is not null. If resolution_code
3168: -- is null then return error message.
3169:
3170: IF ( nvl(fnd_profile.value('AHL_SR_RESL_CODE_COMP'), 'N') = 'Y') THEN
3171:
3172: IF ( p_x_nonroutine_rec.resolution_code IS NULL OR
3173: p_x_nonroutine_rec.resolution_code = FND_API.G_MISS_CHAR) THEN
3174:

Line 3244: AND incident_type_id=fnd_profile.value('AHL_MCL_M_AND_O_SR_TYPE')

3240: SELECT INCIDENT_TYPE_ID
3241: FROM cs_incident_types_vl
3242: where INCIDENT_SUBTYPE = 'INC'
3243: AND CMRO_FLAG = 'Y'
3244: AND incident_type_id=fnd_profile.value('AHL_MCL_M_AND_O_SR_TYPE')
3245: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate))
3246: AND trunc(nvl(end_date_active,sysdate));
3247:
3248: -- query m and o procedures.