DBA Data[Home] [Help]

APPS.AHL_APPROVALS_PVT dependencies on FND_MESSAGE

Line 398: Fnd_Message.set_name('AHL', 'AHL_UTIL_NO_WHERE_OPERATOR');

394: IF l_eq_pos = 0 AND l_not_pos = 0 AND l_like_pos = 0 THEN
395: -- Could not find either an = or an <>
396: -- operator.
397: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
398: Fnd_Message.set_name('AHL', 'AHL_UTIL_NO_WHERE_OPERATOR');
399: Fnd_Msg_Pub.ADD;
400: RAISE Fnd_Api.g_exc_unexpected_error;
401: END IF;
402: ELSIF l_eq_pos > 0 AND l_not_pos = 0 THEN

Line 717: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');

713: OPEN c_appl_usg;
714: FETCH c_appl_usg INTO l_Approval_Rules_rec.Application_Usg_Code;
715: IF c_appl_usg%NOTFOUND THEN
716: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
717: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');
718: Fnd_Msg_Pub.ADD;
719: END IF;
720: RAISE Fnd_Api.g_exc_unexpected_error;
721: END IF;

Line 950: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');

946: OPEN c_appl_usg;
947: FETCH c_appl_usg INTO l_Approval_Rules_rec.Application_Usg_Code;
948: IF c_appl_usg%NOTFOUND THEN
949: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
950: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');
951: Fnd_Msg_Pub.ADD;
952: END IF;
953: RAISE Fnd_Api.g_exc_unexpected_error;
954: END IF;

Line 1181: Fnd_Message.set_name ('AHL', 'AHL_APPR_STATUS_NOT_TO_ACTIVE');

1177:
1178: IF check_approver1%NOTFOUND THEN
1179: CLOSE check_approver1;
1180: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1181: Fnd_Message.set_name ('AHL', 'AHL_APPR_STATUS_NOT_TO_ACTIVE');
1182: Fnd_Msg_Pub.ADD;
1183: END IF;
1184: x_return_status := Fnd_Api.g_ret_sts_error;
1185: RETURN;

Line 1195: Fnd_Message.set_name ('AHL', 'AHL_APPR_STATUS_NOT_TO_ACTIVE');

1191: Fetch check_approver2 into l_count;
1192: IF check_approver2%notfound THEN
1193: Close check_approver1;
1194: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1195: Fnd_Message.set_name ('AHL', 'AHL_APPR_STATUS_NOT_TO_ACTIVE');
1196: Fnd_Msg_Pub.ADD;
1197: END IF;
1198: x_return_status := Fnd_Api.g_ret_sts_error;
1199: RETURN;

Line 1209: Fnd_Message.set_name ('AHL', 'AHL_APPR_STATUS_NOT_TO_ACTIVE');

1205: Fetch check_approver3 into l_count;
1206: IF check_approver3%notfound THEN
1207: Close check_approver3;
1208: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1209: Fnd_Message.set_name ('AHL', 'AHL_APPR_STATUS_NOT_TO_ACTIVE');
1210: Fnd_Msg_Pub.ADD;
1211: END IF;
1212: x_return_status := Fnd_Api.g_ret_sts_error;
1213: RETURN;

Line 1223: Fnd_Message.set_name ('AHL', 'AHL_APPR_STATUS_NOT_TO_ACTIVE');

1219: Fetch check_approver4 into l_count;
1220: IF check_approver4%notfound THEN
1221: Close check_approver4;
1222: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1223: Fnd_Message.set_name ('AHL', 'AHL_APPR_STATUS_NOT_TO_ACTIVE');
1224: Fnd_Msg_Pub.ADD;
1225: END IF;
1226: x_return_status := Fnd_Api.g_ret_sts_error;
1227: RETURN;

Line 1314: Fnd_Message.set_name ('AHL', 'AHL_APPR_QUALIFIER_ACTIVE');

1310: FETCH check_active1 INTO l_count1;
1311: IF check_active1%FOUND THEN
1312: CLOSE check_active1;
1313: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1314: Fnd_Message.set_name ('AHL', 'AHL_APPR_QUALIFIER_ACTIVE');
1315: Fnd_Msg_Pub.ADD;
1316: END IF;
1317: x_return_status := Fnd_Api.g_ret_sts_error;
1318: RETURN;

Line 1328: Fnd_Message.set_name ('AHL', 'AHL_APPR_QUALIFIER_ACTIVE');

1324: FETCH check_active2 INTO l_count2;
1325: IF check_active2%FOUND THEN
1326: CLOSE check_active2;
1327: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1328: Fnd_Message.set_name ('AHL', 'AHL_APPR_QUALIFIER_ACTIVE');
1329: Fnd_Msg_Pub.ADD;
1330: END IF;
1331: x_return_status := Fnd_Api.g_ret_sts_error;
1332: RETURN;

Line 1342: Fnd_Message.set_name ('AHL', 'AHL_APPR_QUALIFIER_ACTIVE');

1338: FETCH check_active3 INTO l_count3;
1339: IF check_active3%FOUND THEN
1340: CLOSE check_active3;
1341: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1342: Fnd_Message.set_name ('AHL', 'AHL_APPR_QUALIFIER_ACTIVE');
1343: Fnd_Msg_Pub.ADD;
1344: END IF;
1345: x_return_status := Fnd_Api.g_ret_sts_error;
1346: RETURN;

Line 1356: Fnd_Message.set_name ('AHL', 'AHL_APPR_QUALIFIER_ACTIVE');

1352: FETCH check_active4 INTO l_count4;
1353: IF check_active4%FOUND THEN
1354: CLOSE check_active4;
1355: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1356: Fnd_Message.set_name ('AHL', 'AHL_APPR_QUALIFIER_ACTIVE');
1357: Fnd_Msg_Pub.ADD;
1358: END IF;
1359: x_return_status := Fnd_Api.g_ret_sts_error;
1360: RETURN;

Line 1370: Fnd_Message.set_name ('AHL', 'AHL_APPR_QUALIFIER_ACTIVE');

1366: FETCH check_active5 INTO l_count5;
1367: IF check_active5%FOUND THEN
1368: CLOSE check_active5;
1369: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1370: Fnd_Message.set_name ('AHL', 'AHL_APPR_QUALIFIER_ACTIVE');
1371: Fnd_Msg_Pub.ADD;
1372: END IF;
1373: x_return_status := Fnd_Api.g_ret_sts_error;
1374: RETURN;

Line 1405: Fnd_Message.set_name ('AHL', 'AHL_APPR_NO_OPERATING_NAME');

1401: FETCH chk_op_name INTO l_count;
1402: IF chk_op_name%NOTFOUND THEN
1403: CLOSE chk_op_name;
1404: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1405: Fnd_Message.set_name ('AHL', 'AHL_APPR_NO_OPERATING_NAME');
1406: Fnd_Msg_Pub.ADD;
1407: END IF;
1408: x_return_status := Fnd_Api.g_ret_sts_error;
1409: RETURN;

Line 1438: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');

1434: FETCH chk_appl_usg_code INTO l_count;
1435: IF chk_appl_usg_code%NOTFOUND THEN
1436: CLOSE chk_appl_usg_code;
1437: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1438: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');
1439: Fnd_Msg_Pub.ADD;
1440: END IF;
1441: x_return_status := Fnd_Api.g_ret_sts_error;
1442: RETURN;

Line 1483: Fnd_Message.set_name ('AHL', 'AHL_APPR_INVALID_STATUS');

1479: FETCH check_status INTO l_count;
1480: IF check_status%NOTFOUND THEN
1481: CLOSE check_status;
1482: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1483: Fnd_Message.set_name ('AHL', 'AHL_APPR_INVALID_STATUS');
1484: Fnd_Msg_Pub.ADD;
1485: END IF;
1486: x_return_status := Fnd_Api.g_ret_sts_error;
1487: RETURN;

Line 1561: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');

1557: FETCH c_Approval_Rules INTO l_Approval_Rules_rec;
1558: IF c_Approval_Rules%NOTFOUND THEN
1559: CLOSE c_Approval_Rules;
1560: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1561: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
1562: Fnd_Msg_Pub.ADD;
1563: END IF;
1564: RAISE Fnd_Api.g_exc_error;
1565: END IF;

Line 1574: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');

1570: WHERE Approval_Rule_id = p_Approval_Rule_id;
1571: IF (SQL%NOTFOUND) THEN
1572: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)
1573: THEN
1574: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');
1575: Fnd_Msg_Pub.ADD;
1576: END IF;
1577: RAISE Fnd_Api.g_exc_error;
1578: END IF;

Line 1589: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');

1585: WHERE Approval_Rule_id = p_Approval_Rule_id;
1586: IF (SQL%NOTFOUND) THEN
1587: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)
1588: THEN
1589: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');
1590: Fnd_Msg_Pub.ADD;
1591: END IF;
1592: RAISE Fnd_Api.g_exc_error;
1593: END IF;

Line 1839: Fnd_Message.set_name ('AHL', 'AHL_APPR_FROMDT_GTR_TODT');

1835: -- Validate the active dates.
1836: IF l_active_start_date IS NOT NULL AND l_active_end_date IS NOT NULL THEN
1837: IF l_active_start_date > l_active_end_date THEN
1838: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1839: Fnd_Message.set_name ('AHL', 'AHL_APPR_FROMDT_GTR_TODT');
1840: Fnd_Msg_Pub.ADD;
1841: END IF;
1842: x_return_status := Fnd_Api.g_ret_sts_error;
1843: RETURN;

Line 1848: Fnd_Message.set_name ('AHL', 'AHL_APPR_FROMDT_EQU_TODT');

1844: END IF;
1845:
1846: IF l_active_start_date = l_active_end_date THEN
1847: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1848: Fnd_Message.set_name ('AHL', 'AHL_APPR_FROMDT_EQU_TODT');
1849: Fnd_Msg_Pub.ADD;
1850: END IF;
1851: x_return_status := Fnd_Api.g_ret_sts_error;
1852: RETURN;

Line 1931: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');

1927: FETCH c_Approval_Rules INTO l_Approval_Rules_rec;
1928: IF c_Approval_Rules%NOTFOUND THEN
1929: CLOSE c_Approval_Rules;
1930: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1931: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
1932: Fnd_Msg_Pub.ADD;
1933: END IF;
1934: RAISE Fnd_Api.g_exc_error;
1935: END IF;

Line 2048: Fnd_Message.set_name ('AHL', 'AHL_APPR_RULE_NAME_MISSING');

2044: BEGIN
2045: -- APPROVAL RULE NAME
2046: IF p_Approval_Rules_rec.Approval_Rule_Name IS NULL THEN
2047: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2048: Fnd_Message.set_name ('AHL', 'AHL_APPR_RULE_NAME_MISSING');
2049: Fnd_Msg_Pub.ADD;
2050: END IF;
2051: x_return_status := Fnd_Api.g_ret_sts_error;
2052: RETURN;

Line 2060: Fnd_Message.set_name ('AHL', 'AHL_APPR_OBJECT_CODE_MISSING');

2056:
2057: -- APPROVAL OBJECT CODE
2058: IF p_Approval_Rules_rec.Approval_object_code IS NULL THEN
2059: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2060: Fnd_Message.set_name ('AHL', 'AHL_APPR_OBJECT_CODE_MISSING');
2061: Fnd_Msg_Pub.ADD;
2062: END IF;
2063: x_return_status := Fnd_Api.g_ret_sts_error;
2064: RETURN;

Line 2070: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_ISNULL');

2066:
2067: -- APPLICATION USAGE
2068: IF p_Approval_Rules_rec.application_usg_code IS NULL THEN
2069: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2070: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_ISNULL');
2071: Fnd_Msg_Pub.ADD;
2072: END IF;
2073: x_return_status := Fnd_Api.g_ret_sts_error;
2074: RETURN;

Line 2080: Fnd_Message.set_name ('AHL', 'AHL_APPR_TYPE_CODE_MISSING');

2076:
2077: -- TYPE CODE
2078: /*IF p_Approval_Rules_rec.approval_type_code IS NULL THEN
2079: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2080: Fnd_Message.set_name ('AHL', 'AHL_APPR_TYPE_CODE_MISSING');
2081: Fnd_Msg_Pub.ADD;
2082: END IF;
2083: x_return_status := Fnd_Api.g_ret_sts_error;
2084: RETURN;

Line 2093: Fnd_Message.set_name ('AHL', 'AHL_APPR_ST_DATE_MISSING');

2089:
2090: -- START DATE
2091: IF p_Approval_Rules_rec.active_start_date IS NULL THEN
2092: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2093: Fnd_Message.set_name ('AHL', 'AHL_APPR_ST_DATE_MISSING');
2094: Fnd_Msg_Pub.ADD;
2095: END IF;
2096: x_return_status := Fnd_Api.g_ret_sts_error;
2097: RETURN;

Line 2103: Fnd_Message.set_name ('AHL', 'AHL_APPR_PROIRITY_CODE_MISSING');

2099:
2100: /*-- PROIRITY CODE
2101: IF p_Approval_Rules_rec.approval_priority_code IS NULL THEN
2102: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2103: Fnd_Message.set_name ('AHL', 'AHL_APPR_PROIRITY_CODE_MISSING');
2104: Fnd_Msg_Pub.ADD;
2105: END IF;
2106: x_return_status := Fnd_Api.g_ret_sts_error;
2107: RETURN;

Line 2113: Fnd_Message.set_name ('AHL', 'AHL_APPR_OP_UNIT_CODE_MISSING');

2109:
2110: /* -- OPERATING UNIT CODE
2111: IF p_Approval_Rules_rec.OPERATING_UNIT_ID IS NULL THEN
2112: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2113: Fnd_Message.set_name ('AHL', 'AHL_APPR_OP_UNIT_CODE_MISSING');
2114: Fnd_Msg_Pub.ADD;
2115: END IF;
2116: x_return_status := Fnd_Api.g_ret_sts_error;
2117: RETURN;

Line 2169: Fnd_Message.set_name ('AHL', 'AHL_APPR_DUPLICATE_ID');

2165: 'Approval_Rule_Id = ' || p_Approval_Rules_rec.Approval_Rule_id
2166: ) = Fnd_Api.g_false
2167: THEN
2168: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2169: Fnd_Message.set_name ('AHL', 'AHL_APPR_DUPLICATE_ID');
2170: Fnd_Msg_Pub.ADD;
2171: END IF;
2172: x_return_status := Fnd_Api.g_ret_sts_error;
2173: RETURN;

Line 2195: Fnd_Message.set_name ('AHL', 'AHL_APPR_DUPLICATE_NAME');

2191: END IF;
2192:
2193: IF l_valid_flag = Fnd_Api.g_false THEN
2194: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2195: Fnd_Message.set_name ('AHL', 'AHL_APPR_DUPLICATE_NAME');
2196: Fnd_Msg_Pub.ADD;
2197: END IF;
2198: x_return_status := Fnd_Api.g_ret_sts_error;
2199: RETURN;

Line 2321: Fnd_Message.set_name ('AHL', 'AHL_APPR_RULE_NOT_UNIQUE');

2317: END IF;
2318: END IF;
2319: IF l_valid_flag = Fnd_Api.g_false THEN
2320: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2321: Fnd_Message.set_name ('AHL', 'AHL_APPR_RULE_NOT_UNIQUE');
2322: Fnd_Msg_Pub.ADD;
2323: END IF;
2324: x_return_status := Fnd_Api.g_ret_sts_error;
2325: RETURN;

Line 2762: Fnd_Message.set_name ('AHL', 'AHL_APPR_ORDER_INVALID_JSP');

2758: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2759: IF p_Approvers_rec.approver_sequence IS NOT NULL THEN
2760: IF p_Approvers_rec.approver_sequence = 0 OR p_Approvers_rec.approver_sequence < 0 THEN
2761: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2762: Fnd_Message.set_name ('AHL', 'AHL_APPR_ORDER_INVALID_JSP');
2763: Fnd_Msg_Pub.ADD;
2764: END IF;
2765: x_return_status := Fnd_Api.g_ret_sts_error;
2766: RETURN;

Line 2788: Fnd_Message.set_name ('AHL', 'AHL_APPR_TYPE_NOT_USER');

2784: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2785: IF p_Approvers_rec.APPROVER_NAME IS NULL THEN
2786: IF UPPER(p_Approvers_rec.approver_type_code) = 'USER' THEN
2787: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2788: Fnd_Message.set_name ('AHL', 'AHL_APPR_TYPE_NOT_USER');
2789: Fnd_Msg_Pub.ADD;
2790: END IF;
2791: x_return_status := Fnd_Api.g_ret_sts_error;
2792: RETURN;

Line 2872: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');

2868: FETCH c_Approvers INTO l_Approvers_rec;
2869: IF c_Approvers%NOTFOUND THEN
2870: CLOSE c_Approvers;
2871: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2872: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
2873: Fnd_Msg_Pub.ADD;
2874: END IF;
2875: RAISE Fnd_Api.g_exc_error;
2876: END IF;

Line 2893: Fnd_Message.set_name('AHL', 'AHL_APPR_NOT_DELETE');

2889: ELSE
2890: CLOSE check_approval_rules;
2891: IF UPPER(l_status) = 'ACTIVE' THEN
2892: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2893: Fnd_Message.set_name('AHL', 'AHL_APPR_NOT_DELETE');
2894: Fnd_Msg_Pub.ADD;
2895: END IF;
2896: RAISE Fnd_Api.g_exc_error;
2897: END IF;

Line 2915: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');

2911: DELETE FROM Ahl_Approvers
2912: WHERE APPROVAL_APPROVER_ID = p_Approval_Approver_Id;
2913: IF (SQL%NOTFOUND) THEN
2914: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2915: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');
2916: Fnd_Msg_Pub.ADD;
2917: END IF;
2918: RAISE Fnd_Api.g_exc_error;
2919: END IF;

Line 3154: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');

3150: FETCH c_Approvers INTO l_Approvers_rec;
3151: IF c_Approvers%NOTFOUND THEN
3152: CLOSE c_Approvers;
3153: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3154: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
3155: Fnd_Msg_Pub.ADD;
3156: END IF;
3157: RAISE Fnd_Api.g_exc_error;
3158: END IF;

Line 3197: Fnd_Message.set_name ('AHL', 'AHL_APPR_SEQUENCE_MISSING');

3193: BEGIN
3194: -- APPROVAL SEQUENCE
3195: IF p_Approvers_rec.Approver_sequence IS NULL THEN
3196: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
3197: Fnd_Message.set_name ('AHL', 'AHL_APPR_SEQUENCE_MISSING');
3198: Fnd_Msg_Pub.ADD;
3199: END IF;
3200: x_return_status := Fnd_Api.g_ret_sts_error;
3201: RETURN;

Line 3208: Fnd_Message.set_name ('AHL', 'AHL_APPR_TYPE_MISSING');

3204: -- APPROVER_NAME - Approver Name is mandatory only if the approver type is user
3205: -- if approver name is null and the approval type is role, then the default approver is picked up
3206: IF UPPER(p_Approvers_rec.APPROVER_TYPE_CODE) = 'USER' AND p_Approvers_rec.APPROVER_NAME IS NULL THEN
3207: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
3208: Fnd_Message.set_name ('AHL', 'AHL_APPR_TYPE_MISSING');
3209: Fnd_Msg_Pub.ADD;
3210: END IF;
3211: x_return_status := Fnd_Api.g_ret_sts_error;
3212: RETURN;

Line 3315: Fnd_Message.set_name ('AHL', 'AHL_APPR_TYPE_MISSING');

3311: END LOOP;
3312:
3313: IF c_approver_id_role%ROWCOUNT = 0 THEN
3314: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
3315: Fnd_Message.set_name ('AHL', 'AHL_APPR_TYPE_MISSING');
3316: Fnd_Msg_Pub.ADD;
3317: END IF;
3318: x_return_status := Fnd_Api.g_ret_sts_error;
3319: RETURN;

Line 3322: Fnd_Message.set_name ('AHL', 'AHL_APPR_TYPE_MISSING');

3318: x_return_status := Fnd_Api.g_ret_sts_error;
3319: RETURN;
3320: ELSIF c_approver_id_role%ROWCOUNT > 1 THEN
3321: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
3322: Fnd_Message.set_name ('AHL', 'AHL_APPR_TYPE_MISSING');
3323: Fnd_Msg_Pub.ADD;
3324: END IF;
3325: x_return_status := Fnd_Api.g_ret_sts_error;
3326: RETURN;

Line 3348: Fnd_Message.set_name ('AHL', 'AHL_APPR_TYPE_MISSING');

3344: END LOOP;
3345:
3346: IF c_approver_id_user%ROWCOUNT = 0 THEN
3347: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
3348: Fnd_Message.set_name ('AHL', 'AHL_APPR_TYPE_MISSING');
3349: Fnd_Msg_Pub.ADD;
3350: END IF;
3351: x_return_status := Fnd_Api.g_ret_sts_error;
3352: RETURN;

Line 3355: Fnd_Message.set_name ('AHL', 'AHL_APPR_TYPE_MISSING');

3351: x_return_status := Fnd_Api.g_ret_sts_error;
3352: RETURN;
3353: ELSIF c_approver_id_user%ROWCOUNT > 1 THEN
3354: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
3355: Fnd_Message.set_name ('AHL', 'AHL_APPR_TYPE_MISSING');
3356: Fnd_Msg_Pub.ADD;
3357: END IF;
3358: x_return_status := Fnd_Api.g_ret_sts_error;
3359: RETURN;

Line 3393: Fnd_Message.set_name ('AHL', 'AHL_APPR_DUPLICATE_ID');

3389: 'APPROVAL_APPROVER_ID = ' || p_Approvers_rec.Approval_Approver_Id
3390: ) = Fnd_Api.g_false
3391: THEN
3392: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
3393: Fnd_Message.set_name ('AHL', 'AHL_APPR_DUPLICATE_ID');
3394: Fnd_Msg_Pub.ADD;
3395: END IF;
3396: x_return_status := Fnd_Api.g_ret_sts_error;
3397: RETURN;

Line 3418: Fnd_Message.set_name ('AHL', 'AHL_APPR_SEQ_NOT_UNIQUE');

3414: );
3415: END IF;
3416: IF l_valid_flag = Fnd_Api.g_false THEN
3417: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
3418: Fnd_Message.set_name ('AHL', 'AHL_APPR_SEQ_NOT_UNIQUE');
3419: Fnd_Msg_Pub.ADD;
3420: END IF;
3421: x_return_status := Fnd_Api.g_ret_sts_error;
3422: RETURN;