DBA Data[Home] [Help]

APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on FND_MESSAGE

Line 524: FND_MESSAGE.Set_Name('AHL','AHL_UMP_MR_SERQ_INPUT');

520: -- if both MR title and (INCIDENT_TYPE_ID and/or SERVICE_REQ_NUM) entered, raise error.
521: IF (p_search_mr_instance_rec.mr_title is NOT NULL) AND
522: (p_search_mr_instance_rec.INCIDENT_TYPE_ID IS NOT NULL OR p_search_mr_instance_rec.SERVICE_REQ_NUM IS NOT NULL)
523: THEN
524: FND_MESSAGE.Set_Name('AHL','AHL_UMP_MR_SERQ_INPUT');
525: FND_MSG_PUB.ADD;
526: RAISE FND_API.G_EXC_ERROR;
527: END IF;
528:

Line 970: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_SCAT_NON_NUM');

966: NULL;
967: END IF;
968: EXCEPTION
969: WHEN OTHERS THEN
970: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_SCAT_NON_NUM');
971: FND_MSG_PUB.ADD;
972: RAISE FND_API.G_EXC_ERROR;
973: END;
974: l_sql_string := l_sql_string || ' and exists (select ''x'' from AHL_MR_HEADERS_B MRB ';

Line 2063: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_DFROM_DWITHIN_CFLT');

2059: L_DUE_TO := TRUNC(P_SEARCH_UMP_REC.DUE_TO) + 1;
2060: END IF;
2061: /* *********************************** BEGIN: SHOW TOLERANCE ****************************************** */
2062: IF ((P_SEARCH_UMP_REC.DUE_FROM IS NOT NULL AND P_SEARCH_UMP_REC.DUE_TO IS NOT NULL) AND (P_SEARCH_UMP_REC.DUE_WITHIN IS NOT NULL))THEN
2063: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_DFROM_DWITHIN_CFLT');
2064: FND_MSG_PUB.ADD;
2065: RAISE FND_API.G_EXC_ERROR;
2066: ELSIF ((P_SEARCH_UMP_REC.DUE_FROM IS NULL OR P_SEARCH_UMP_REC.DUE_TO IS NULL) AND (P_SEARCH_UMP_REC.DUE_WITHIN IS NOT NULL AND (P_SEARCH_UMP_REC.DUE_WITHIN_UOM IS NULL
2067: OR P_SEARCH_UMP_REC.DUE_WITHIN_UOM NOT IN ('HOUR','DAY')) ))THEN

Line 2068: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_DWITHIN_UOM_NLL');

2064: FND_MSG_PUB.ADD;
2065: RAISE FND_API.G_EXC_ERROR;
2066: ELSIF ((P_SEARCH_UMP_REC.DUE_FROM IS NULL OR P_SEARCH_UMP_REC.DUE_TO IS NULL) AND (P_SEARCH_UMP_REC.DUE_WITHIN IS NOT NULL AND (P_SEARCH_UMP_REC.DUE_WITHIN_UOM IS NULL
2067: OR P_SEARCH_UMP_REC.DUE_WITHIN_UOM NOT IN ('HOUR','DAY')) ))THEN
2068: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_DWITHIN_UOM_NLL');
2069: FND_MSG_PUB.ADD;
2070: RAISE FND_API.G_EXC_ERROR;
2071: ELSIF (P_SEARCH_UMP_REC.DUE_WITHIN IS NOT NULL AND P_SEARCH_UMP_REC.DUE_WITHIN_UOM IS NOT NULL)THEN
2072: IF(L_DUE_FROM IS NULL AND L_DUE_TO IS NULL)THEN

Line 2153: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_MXDUR_UOM_NLL');

2149: /* ***********************************END: SHOW TOLERANCE ****************************************** */
2150: -- Max Duration
2151: IF (P_SEARCH_UMP_REC.MAX_DURATION IS NOT NULL AND (P_SEARCH_UMP_REC.MAX_DURATION_UOM IS NULL
2152: OR P_SEARCH_UMP_REC.MAX_DURATION_UOM NOT IN ('HOUR','DAY')) )THEN
2153: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_MXDUR_UOM_NLL');
2154: FND_MSG_PUB.ADD;
2155: RAISE FND_API.G_EXC_ERROR;
2156: ELSIF (P_SEARCH_UMP_REC.MAX_DURATION IS NOT NULL AND P_SEARCH_UMP_REC.MAX_DURATION_UOM IS NOT NULL)THEN
2157: L_DURATION := 0;

Line 2179: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_SCAT_NON_NUM');

2175: NULL;
2176: END IF;
2177: EXCEPTION
2178: WHEN OTHERS THEN
2179: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_SCAT_NON_NUM');
2180: FND_MSG_PUB.ADD;
2181: RAISE FND_API.G_EXC_ERROR;
2182: END;
2183: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.SERVICE_CATEGORY;

Line 2335: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_DFROM_DWITHIN_CFLT');

2331: L_DUE_TO := TRUNC(P_SEARCH_UMP_REC.DUE_TO) + 1;
2332: END IF;
2333: /* *********************************** BEGIN: SHOW TOLERANCE ****************************************** */
2334: IF ((P_SEARCH_UMP_REC.DUE_FROM IS NOT NULL AND P_SEARCH_UMP_REC.DUE_TO IS NOT NULL) AND (P_SEARCH_UMP_REC.DUE_WITHIN IS NOT NULL))THEN
2335: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_DFROM_DWITHIN_CFLT');
2336: FND_MSG_PUB.ADD;
2337: RAISE FND_API.G_EXC_ERROR;
2338: ELSIF ((P_SEARCH_UMP_REC.DUE_FROM IS NULL OR P_SEARCH_UMP_REC.DUE_TO IS NULL) AND (P_SEARCH_UMP_REC.DUE_WITHIN IS NOT NULL AND (P_SEARCH_UMP_REC.DUE_WITHIN_UOM IS NULL
2339: OR P_SEARCH_UMP_REC.DUE_WITHIN_UOM NOT IN ('HOUR','DAY')) ))THEN

Line 2340: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_DWITHIN_UOM_NLL');

2336: FND_MSG_PUB.ADD;
2337: RAISE FND_API.G_EXC_ERROR;
2338: ELSIF ((P_SEARCH_UMP_REC.DUE_FROM IS NULL OR P_SEARCH_UMP_REC.DUE_TO IS NULL) AND (P_SEARCH_UMP_REC.DUE_WITHIN IS NOT NULL AND (P_SEARCH_UMP_REC.DUE_WITHIN_UOM IS NULL
2339: OR P_SEARCH_UMP_REC.DUE_WITHIN_UOM NOT IN ('HOUR','DAY')) ))THEN
2340: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_DWITHIN_UOM_NLL');
2341: FND_MSG_PUB.ADD;
2342: RAISE FND_API.G_EXC_ERROR;
2343: ELSIF (P_SEARCH_UMP_REC.DUE_WITHIN IS NOT NULL AND P_SEARCH_UMP_REC.DUE_WITHIN_UOM IS NOT NULL)THEN
2344: IF(L_DUE_FROM IS NULL AND L_DUE_TO IS NULL)THEN