DBA Data[Home] [Help]

APPS.AHL_VWP_TASKS_PVT dependencies on FND_MESSAGE

Line 312: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');

308:
309: OPEN get_workorder_rec(p_x_prd_workorder_rec.workorder_id);
310: FETCH get_workorder_rec INTO l_prd_workorder_rec;
311: IF get_workorder_rec%NOTFOUND THEN
312: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
313: FND_MSG_PUB.ADD;
314: CLOSE get_workorder_rec;
315: END IF;
316: CLOSE get_workorder_rec;

Line 1433: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_MAND');

1429: AND l_task_rec.PAST_TASK_START_DATE <> Fnd_Api.G_MISS_DATE) THEN
1430: IF (l_task_rec.PAST_TASK_END_DATE IS NULL
1431: OR l_task_rec.PAST_TASK_START_DATE = Fnd_Api.G_MISS_DATE) THEN
1432: -- if start date is entered but not end date, throw error
1433: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_MAND');
1434: Fnd_Msg_Pub.ADD;
1435: RAISE FND_API.G_EXC_ERROR;
1436: END IF;
1437: IF (l_task_rec.PAST_TASK_START_DATE >= SYSDATE) THEN

Line 1439: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_PAST_ST_DATE_INV');

1435: RAISE FND_API.G_EXC_ERROR;
1436: END IF;
1437: IF (l_task_rec.PAST_TASK_START_DATE >= SYSDATE) THEN
1438: -- Throw error if start date is not in past
1439: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_PAST_ST_DATE_INV');
1440: Fnd_Msg_Pub.ADD;
1441: RAISE FND_API.G_EXC_ERROR;
1442: END IF;
1443: IF (l_task_rec.PAST_TASK_START_DATE < NVL(c_visit_rec.START_DATE_TIME, l_task_rec.PAST_TASK_START_DATE)) THEN

Line 1445: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_START_DATE_INVLD');

1441: RAISE FND_API.G_EXC_ERROR;
1442: END IF;
1443: IF (l_task_rec.PAST_TASK_START_DATE < NVL(c_visit_rec.START_DATE_TIME, l_task_rec.PAST_TASK_START_DATE)) THEN
1444: -- Throw error if past task start date is before the visit start date
1445: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_START_DATE_INVLD');
1446: Fnd_Msg_Pub.ADD;
1447: RAISE FND_API.G_EXC_ERROR;
1448: END IF;
1449: IF (l_task_rec.PAST_TASK_START_DATE > l_task_rec.PAST_TASK_END_DATE) THEN

Line 1451: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_INVLD');

1447: RAISE FND_API.G_EXC_ERROR;
1448: END IF;
1449: IF (l_task_rec.PAST_TASK_START_DATE > l_task_rec.PAST_TASK_END_DATE) THEN
1450: -- Throw error if past task start date is after the past task end date
1451: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_INVLD');
1452: Fnd_Msg_Pub.ADD;
1453: RAISE FND_API.G_EXC_ERROR;
1454: END IF;
1455: IF (l_task_rec.PAST_TASK_END_DATE > NVL(c_visit_rec.CLOSE_DATE_TIME,l_task_rec.PAST_TASK_END_DATE)) THEN

Line 1457: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_END_DATE_INVLD');

1453: RAISE FND_API.G_EXC_ERROR;
1454: END IF;
1455: IF (l_task_rec.PAST_TASK_END_DATE > NVL(c_visit_rec.CLOSE_DATE_TIME,l_task_rec.PAST_TASK_END_DATE)) THEN
1456: -- Throw error if visit ends before the task
1457: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_END_DATE_INVLD');
1458: Fnd_Msg_Pub.ADD;
1459: RAISE FND_API.G_EXC_ERROR;
1460: END IF;
1461: -- SKPATHAK :: Bug #9402556 :: 24-FEB-2010 :: Added call to Validate_Past_Task_Dates

Line 1483: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_MAND');

1479: -- Changed the condition from l_task_rec.PAST_TASK_START_DATE <> Fnd_Api.G_MISS_DATE
1480: -- to l_task_rec.PAST_TASK_END_DATE <> Fnd_Api.G_MISS_DATE
1481: IF (l_task_rec.PAST_TASK_END_DATE IS NOT NULL
1482: AND l_task_rec.PAST_TASK_END_DATE <> Fnd_Api.G_MISS_DATE) THEN
1483: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_MAND');
1484: Fnd_Msg_Pub.ADD;
1485: RAISE FND_API.G_EXC_ERROR;
1486: END IF;
1487: l_task_rec.PAST_TASK_START_DATE := NULL;

Line 1493: Fnd_Message.SET_NAME('AHL','AHL_VWP_NOT_USE_VISIT');

1489: END IF;
1490: -- SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: END
1491:
1492: IF c_visit_rec.status_code IN ('CLOSED','CANCELLED') THEN
1493: Fnd_Message.SET_NAME('AHL','AHL_VWP_NOT_USE_VISIT');
1494: Fnd_Msg_Pub.ADD;
1495: RAISE Fnd_Api.G_EXC_ERROR;
1496: ELSE
1497: IF l_task_rec.task_type_code = 'SUMMARY' THEN

Line 1950: Fnd_Message.SET_NAME('AHL','AHL_VWP_NOT_USE_VISIT');

1946: 'Visit Id = ' || l_task_rec.visit_id || ', Status Code = ' || c_visit_rec.status_code );
1947: END IF;
1948:
1949: IF c_visit_rec.status_code IN ('CLOSED','CANCELLED') THEN
1950: Fnd_Message.SET_NAME('AHL','AHL_VWP_NOT_USE_VISIT');
1951: Fnd_Msg_Pub.ADD;
1952: RAISE Fnd_Api.G_EXC_ERROR;
1953: /*
1954: Commented to fix bug # 4029318

Line 1992: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NOT_EXISTS');

1988: X_RETURN_STATUS => l_return_status,
1989: x_error_msg_code => l_msg_data );
1990:
1991: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success THEN
1992: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NOT_EXISTS');
1993: Fnd_Msg_Pub.ADD;
1994: RAISE Fnd_Api.G_EXC_ERROR;
1995: END IF;
1996: --

Line 2015: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_NOT_EXISTS');

2011: x_return_status => l_return_status,
2012: x_error_msg_code => l_msg_data);
2013:
2014: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success THEN
2015: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_NOT_EXISTS');
2016: Fnd_Msg_Pub.ADD;
2017: RAISE Fnd_Api.G_EXC_ERROR;
2018: END IF;
2019:

Line 2027: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_USE_LOV');

2023: L_DEBUG_KEY,
2024: ': Compare item name');
2025: END IF;
2026:
2027: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_USE_LOV');
2028: Fnd_Msg_Pub.ADD;
2029: RAISE Fnd_Api.G_EXC_ERROR;
2030: END IF;
2031: ELSE

Line 2037: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_USE_LOV');

2033: fnd_log.string(l_log_statement,
2034: L_DEBUG_KEY,
2035: ': Check item else loop');
2036: END IF;
2037: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_USE_LOV');
2038: Fnd_Msg_Pub.ADD;
2039: RAISE Fnd_Api.G_EXC_ERROR;
2040: END IF;
2041:

Line 2079: Fnd_Message.SET_NAME('AHL','AHL_VWP_DEPT_NOT_EXISTS');

2075: x_error_msg_code => l_msg_data);
2076:
2077: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success
2078: THEN
2079: Fnd_Message.SET_NAME('AHL','AHL_VWP_DEPT_NOT_EXISTS');
2080: Fnd_Msg_Pub.ADD;
2081: RAISE Fnd_Api.G_EXC_ERROR;
2082: END IF;
2083:

Line 2090: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_DEPT_SHIFT');

2086: ( P_DEPT_ID => l_department_id,
2087: X_RETURN_STATUS => l_return_status);
2088:
2089: IF (NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS) THEN
2090: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_DEPT_SHIFT');
2091: Fnd_Msg_Pub.ADD;
2092: RAISE Fnd_Api.G_EXC_ERROR;
2093: END IF;
2094: --Assign the returned value

Line 2123: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERIAL_NOT_EXISTS');

2119: x_return_status => l_return_status,
2120: x_error_msg_code => l_msg_data);
2121:
2122: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success THEN
2123: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERIAL_NOT_EXISTS');
2124: Fnd_Msg_Pub.ADD;
2125: RAISE Fnd_Api.G_EXC_ERROR;
2126: ELSE
2127: --Assign the returned value

Line 2142: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');

2138: --BEGIN: jeli added for bug 3777720
2139: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(l_task_rec.visit_id, l_task_rec.instance_id)
2140: = FND_API.G_RET_STS_ERROR) THEN
2141: --END: jeli added for bug 3777720
2142: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');
2143: Fnd_Msg_Pub.ADD;
2144: RAISE Fnd_Api.G_EXC_ERROR;
2145: END IF;
2146: sowsubra - end */

Line 2173: Fnd_Message.SET_NAME('AHL','AHL_TASK_QTY_NULL');

2169: FETCH c_get_instance_qty INTO l_instance_qty;
2170: CLOSE c_get_instance_qty;
2171:
2172: IF (l_Task_rec.QUANTITY is null) THEN
2173: Fnd_Message.SET_NAME('AHL','AHL_TASK_QTY_NULL');
2174: Fnd_Msg_Pub.ADD;
2175: RAISE Fnd_Api.G_EXC_ERROR;
2176: END IF;
2177:

Line 2179: Fnd_Message.SET_NAME('AHL','AHL_POSITIVE_TSK_QTY');

2175: RAISE Fnd_Api.G_EXC_ERROR;
2176: END IF;
2177:
2178: IF (l_Task_rec.QUANTITY <= 0) THEN
2179: Fnd_Message.SET_NAME('AHL','AHL_POSITIVE_TSK_QTY');
2180: Fnd_Msg_Pub.ADD;
2181: RAISE Fnd_Api.G_EXC_ERROR;
2182: END IF;
2183:

Line 2185: Fnd_Message.SET_NAME('AHL','AHL_INCORRECT_TSK_QTY');

2181: RAISE Fnd_Api.G_EXC_ERROR;
2182: END IF;
2183:
2184: IF (l_Task_rec.QUANTITY > l_instance_qty ) THEN
2185: Fnd_Message.SET_NAME('AHL','AHL_INCORRECT_TSK_QTY');
2186: Fnd_Msg_Pub.ADD;
2187: RAISE Fnd_Api.G_EXC_ERROR;
2188: END IF;
2189: -- End changes by rnahata for Issue 105

Line 2210: Fnd_Message.SET_NAME('AHL','AHL_VWP_PARENT_NOT_EXISTS');

2206: x_error_msg_code => l_msg_data);
2207:
2208: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success
2209: THEN
2210: Fnd_Message.SET_NAME('AHL','AHL_VWP_PARENT_NOT_EXISTS');
2211: Fnd_Msg_Pub.ADD;
2212: RAISE Fnd_Api.g_exc_error;
2213: END IF;
2214:

Line 2266: Fnd_Message.SET_NAME('AHL','AHL_VWP_ORIGINATING_NOT_EXISTS');

2262: x_error_msg_code => l_msg_data);
2263:
2264: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success
2265: THEN
2266: Fnd_Message.SET_NAME('AHL','AHL_VWP_ORIGINATING_NOT_EXISTS');
2267: Fnd_Msg_Pub.ADD;
2268: RAISE Fnd_Api.g_exc_error;
2269: END IF;
2270: --Assign the returned value

Line 2322: Fnd_Message.set_name ('AHL', 'AHL_VWP_NAME_MISSING');

2318: END IF;
2319: /* ELSE Commented to fix bug # 4029318 Senthil
2320: -- TASK NAME ==== NAME
2321: IF (l_task_rec.visit_task_name IS NULL OR l_task_rec.visit_task_name = Fnd_Api.G_MISS_CHAR) THEN
2322: Fnd_Message.set_name ('AHL', 'AHL_VWP_NAME_MISSING');
2323: Fnd_Msg_Pub.ADD;
2324: RAISE Fnd_Api.g_exc_error;
2325: END IF;
2326: END IF;

Line 2722: Fnd_Message.SET_NAME('AHL','AHL_VWP_NOT_USE_VISIT');

2718: ': Status Code ' || c_visit_rec.status_code);
2719: END IF;
2720:
2721: IF c_visit_rec.status_code IN ('CLOSED','CANCELLED') THEN
2722: Fnd_Message.SET_NAME('AHL','AHL_VWP_NOT_USE_VISIT');
2723: Fnd_Msg_Pub.ADD;
2724: RAISE Fnd_Api.G_EXC_ERROR;
2725: ELSE
2726: ----------- Start defining and validate all LOVs on Create Visit's Task UI Screen---

Line 2746: Fnd_Message.SET_NAME('AHL','AHL_VWP_DEPT_NOT_EXISTS');

2742: x_error_msg_code => l_msg_data);
2743:
2744: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success
2745: THEN
2746: Fnd_Message.SET_NAME('AHL','AHL_VWP_DEPT_NOT_EXISTS');
2747: Fnd_Msg_Pub.ADD;
2748: RAISE Fnd_Api.G_EXC_ERROR;
2749: END IF;
2750:

Line 2757: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_DEPT_SHIFT');

2753: ( P_DEPT_ID => l_department_id,
2754: X_RETURN_STATUS => l_return_status);
2755:
2756: IF (NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS) THEN
2757: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_DEPT_SHIFT');
2758: Fnd_Msg_Pub.ADD;
2759: RAISE Fnd_Api.G_EXC_ERROR;
2760: END IF;
2761:

Line 2801: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_NOT_EXISTS');

2797: x_error_msg_code => l_msg_data);
2798:
2799: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success
2800: THEN
2801: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_NOT_EXISTS');
2802: Fnd_Msg_Pub.ADD;
2803: RAISE Fnd_Api.G_EXC_ERROR;
2804: END IF;
2805:

Line 2807: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_USE_LOV');

2803: RAISE Fnd_Api.G_EXC_ERROR;
2804: END IF;
2805:
2806: IF UPPER(l_Task_rec.item_name) <> UPPER(l_item_name) THEN
2807: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_USE_LOV');
2808: Fnd_Msg_Pub.ADD;
2809: RAISE Fnd_Api.G_EXC_ERROR;
2810: END IF;
2811:

Line 2819: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_USE_LOV');

2815:
2816: /* Commented as Item is not mandatory for Summary Task
2817: Post 11.5.10 Changes done by Senthil.
2818: ELSE
2819: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_USE_LOV');
2820: Fnd_Msg_Pub.ADD;
2821: RAISE Fnd_Api.G_EXC_ERROR;
2822: */
2823:

Line 2839: Fnd_Message.SET_NAME('AHL','AHL_VWP_SUM_TASK_ITEM');

2835:
2836: OPEN get_task_inst_dtls(l_task_rec.visit_id);
2837: FETCH get_task_inst_dtls INTO get_task_inst_rec;
2838: IF get_task_inst_dtls%NOTFOUND THEN
2839: Fnd_Message.SET_NAME('AHL','AHL_VWP_SUM_TASK_ITEM');
2840: Fnd_Msg_Pub.ADD;
2841: CLOSE get_task_inst_dtls;
2842: RAISE Fnd_Api.G_EXC_ERROR;
2843: END IF;

Line 2878: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERIAL_NOT_EXISTS');

2874: x_return_status => l_return_status,
2875: x_error_msg_code => l_msg_data);
2876:
2877: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success THEN
2878: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERIAL_NOT_EXISTS');
2879: Fnd_Msg_Pub.ADD;
2880: RAISE Fnd_Api.G_EXC_ERROR;
2881: ELSE
2882: --Assign the returned value

Line 2896: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');

2892: /* sowsubra - start
2893: --BEGIN: jeli added for bug 3777720
2894: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(l_task_rec.visit_id, l_task_rec.instance_id) = FND_API.G_RET_STS_ERROR) THEN
2895: --END: jeli added for bug 3777720
2896: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');
2897: Fnd_Msg_Pub.ADD;
2898: RAISE Fnd_Api.G_EXC_ERROR;
2899: END IF;
2900: sowsubra - end */

Line 2927: Fnd_Message.SET_NAME('AHL','AHL_VWP_PARENT_NOT_EXISTS');

2923: x_error_msg_code => l_msg_data);
2924:
2925: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success
2926: THEN
2927: Fnd_Message.SET_NAME('AHL','AHL_VWP_PARENT_NOT_EXISTS');
2928: Fnd_Msg_Pub.ADD;
2929: RAISE Fnd_Api.g_exc_error;
2930: END IF;
2931:

Line 2976: Fnd_Message.SET_NAME('AHL','AHL_VWP_ORIGINATING_NOT_EXISTS');

2972: x_error_msg_code => l_msg_data);
2973:
2974: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success
2975: THEN
2976: Fnd_Message.SET_NAME('AHL','AHL_VWP_ORIGINATING_NOT_EXISTS');
2977: Fnd_Msg_Pub.ADD;
2978: RAISE Fnd_Api.g_exc_error;
2979: END IF;
2980:

Line 3007: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_CMP_TARGET_QTY_INVLD');

3003: -- Validate target quantity
3004: IF (l_Task_rec.target_qty IS NOT NULL AND
3005: l_Task_rec.target_qty <> Fnd_Api.G_MISS_NUM AND
3006: l_Task_rec.target_qty < 0) THEN
3007: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_CMP_TARGET_QTY_INVLD');
3008: FND_MSG_PUB.add;
3009: RAISE FND_API.G_EXC_ERROR;
3010: END IF;
3011: ----------- End defining and validate all LOVs on Create Visit's Task UI Screen---

Line 3399: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_MAND');

3395: AND l_task_rec.PAST_TASK_START_DATE <> Fnd_Api.G_MISS_DATE) THEN
3396: IF (l_task_rec.PAST_TASK_END_DATE IS NULL
3397: OR l_task_rec.PAST_TASK_START_DATE = Fnd_Api.G_MISS_DATE) THEN
3398: -- if start date is entered but not end date, throw error
3399: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_MAND');
3400: Fnd_Msg_Pub.ADD;
3401: RAISE FND_API.G_EXC_ERROR;
3402: END IF;
3403: IF (l_Task_rec.PAST_TASK_START_DATE >= SYSDATE) THEN

Line 3405: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_PAST_ST_DATE_INV');

3401: RAISE FND_API.G_EXC_ERROR;
3402: END IF;
3403: IF (l_Task_rec.PAST_TASK_START_DATE >= SYSDATE) THEN
3404: -- Throw error if start date is not in past
3405: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_PAST_ST_DATE_INV');
3406: Fnd_Msg_Pub.ADD;
3407: RAISE FND_API.G_EXC_ERROR;
3408: END IF;
3409: IF (l_task_rec.PAST_TASK_START_DATE < NVL(c_visit_rec.START_DATE_TIME, l_task_rec.PAST_TASK_START_DATE)) THEN

Line 3411: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_START_DATE_INVLD');

3407: RAISE FND_API.G_EXC_ERROR;
3408: END IF;
3409: IF (l_task_rec.PAST_TASK_START_DATE < NVL(c_visit_rec.START_DATE_TIME, l_task_rec.PAST_TASK_START_DATE)) THEN
3410: -- Throw error if past task start date is before the visit start date
3411: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_START_DATE_INVLD');
3412: Fnd_Msg_Pub.ADD;
3413: RAISE FND_API.G_EXC_ERROR;
3414: END IF;
3415: IF (l_task_rec.PAST_TASK_START_DATE > l_task_rec.PAST_TASK_END_DATE) THEN

Line 3417: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_INVLD');

3413: RAISE FND_API.G_EXC_ERROR;
3414: END IF;
3415: IF (l_task_rec.PAST_TASK_START_DATE > l_task_rec.PAST_TASK_END_DATE) THEN
3416: -- Throw error if past task start date is after the past task end date
3417: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_INVLD');
3418: Fnd_Msg_Pub.ADD;
3419: RAISE FND_API.G_EXC_ERROR;
3420: END IF;
3421: IF (l_Task_rec.PAST_TASK_END_DATE > NVL(c_visit_rec.CLOSE_DATE_TIME, l_Task_rec.PAST_TASK_END_DATE)) THEN

Line 3423: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_END_DATE_INVLD');

3419: RAISE FND_API.G_EXC_ERROR;
3420: END IF;
3421: IF (l_Task_rec.PAST_TASK_END_DATE > NVL(c_visit_rec.CLOSE_DATE_TIME, l_Task_rec.PAST_TASK_END_DATE)) THEN
3422: -- Throw error if visit ends before the task
3423: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_END_DATE_INVLD');
3424: Fnd_Msg_Pub.ADD;
3425: RAISE FND_API.G_EXC_ERROR;
3426: END IF;
3427: -- Validate past dates against visit stages, task hierarchy and cost parent hierarchy

Line 3447: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_MAND');

3443: -- Changed the condition from l_task_rec.PAST_TASK_START_DATE <> Fnd_Api.G_MISS_DATE
3444: -- to l_task_rec.PAST_TASK_END_DATE <> Fnd_Api.G_MISS_DATE
3445: IF (l_Task_rec.PAST_TASK_END_DATE IS NOT NULL
3446: AND l_Task_rec.PAST_TASK_END_DATE <> Fnd_Api.G_MISS_DATE) THEN
3447: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_MAND');
3448: Fnd_Msg_Pub.ADD;
3449: RAISE FND_API.G_EXC_ERROR;
3450: END IF;
3451: -- If the earlier value of past task date is not null, cannot nullify the past date now

Line 3453: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_DATE_NOT_NULL');

3449: RAISE FND_API.G_EXC_ERROR;
3450: END IF;
3451: -- If the earlier value of past task date is not null, cannot nullify the past date now
3452: IF c_Task_rec.PAST_TASK_START_DATE IS NOT NULL THEN
3453: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_DATE_NOT_NULL');
3454: Fnd_Msg_Pub.ADD;
3455: RAISE FND_API.G_EXC_ERROR;
3456: END IF;
3457: l_Task_rec.PAST_TASK_START_DATE := NULL;

Line 3885: Fnd_Message.SET_NAME('AHL','AHL_VWP_DEPT_NOT_EXISTS');

3881: x_return_status => l_return_status,
3882: x_error_msg_code => l_msg_data);
3883:
3884: IF (NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS) THEN
3885: Fnd_Message.SET_NAME('AHL','AHL_VWP_DEPT_NOT_EXISTS');
3886: Fnd_Msg_Pub.ADD;
3887: RAISE Fnd_Api.G_EXC_ERROR;
3888: END IF;
3889:

Line 3896: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_DEPT_SHIFT');

3892: ( P_DEPT_ID => l_task_rec.department_id,
3893: X_RETURN_STATUS => l_return_status);
3894:
3895: IF (NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS) THEN
3896: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_DEPT_SHIFT');
3897: Fnd_Msg_Pub.ADD;
3898: RAISE Fnd_Api.G_EXC_ERROR;
3899: END IF;
3900: ELSE

Line 4376: Fnd_Message.SET_NAME('AHL','AHL_VWP_PARENT_NOT_EXISTS');

4372: p_x_task_rec.cost_parent_id := l_cost_parent_id;
4373:
4374: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success
4375: THEN
4376: Fnd_Message.SET_NAME('AHL','AHL_VWP_PARENT_NOT_EXISTS');
4377: Fnd_Msg_Pub.ADD;
4378: RAISE Fnd_Api.g_exc_error;
4379: END IF;
4380: --Assign the returned value

Line 4401: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_CMP_TARGET_QTY_INVLD');

4397: -- Validate target quantity
4398: IF (l_Task_rec.target_qty IS NOT NULL AND
4399: l_Task_rec.target_qty <> Fnd_Api.G_MISS_NUM AND
4400: l_Task_rec.target_qty < 0) THEN
4401: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_CMP_TARGET_QTY_INVLD');
4402: FND_MSG_PUB.add;
4403: RAISE FND_API.G_EXC_ERROR;
4404: END IF;
4405:

Line 4716: Fnd_Message.SET_NAME('AHL','AHL_VWP_DEPT_NOT_EXISTS');

4712: x_error_msg_code => l_msg_data);
4713:
4714: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success
4715: THEN
4716: Fnd_Message.SET_NAME('AHL','AHL_VWP_DEPT_NOT_EXISTS');
4717: Fnd_Msg_Pub.ADD;
4718: RAISE Fnd_Api.G_EXC_ERROR;
4719: END IF;
4720:

Line 4755: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERIAL_NOT_EXISTS');

4751: x_return_status => l_return_status,
4752: x_error_msg_code => l_msg_data);
4753:
4754: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success THEN
4755: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERIAL_NOT_EXISTS');
4756: Fnd_Msg_Pub.ADD;
4757: RAISE Fnd_Api.G_EXC_ERROR;
4758: ELSE
4759:

Line 4776: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');

4772:
4773: --BEGIN: jeli added for bug 3777720
4774: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(l_task_rec.visit_id, l_task_rec.instance_id) = FND_API.G_RET_STS_ERROR) THEN
4775: --END: jeli added for bug 3777720
4776: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');
4777: Fnd_Msg_Pub.ADD;
4778: RAISE Fnd_Api.G_EXC_ERROR;
4779: END IF;
4780: END IF;

Line 4808: Fnd_Message.SET_NAME('AHL','AHL_VWP_PARENT_NOT_EXISTS');

4804: x_error_msg_code => l_msg_data);
4805:
4806: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success
4807: THEN
4808: Fnd_Message.SET_NAME('AHL','AHL_VWP_PARENT_NOT_EXISTS');
4809: Fnd_Msg_Pub.ADD;
4810: RAISE Fnd_Api.g_exc_error;
4811: END IF;
4812:

Line 4865: Fnd_Message.SET_NAME('AHL','AHL_VWP_ORIGINATING_NOT_EXISTS');

4861: x_error_msg_code => l_msg_data);
4862:
4863: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success
4864: THEN
4865: Fnd_Message.SET_NAME('AHL','AHL_VWP_ORIGINATING_NOT_EXISTS');
4866: Fnd_Msg_Pub.ADD;
4867: RAISE Fnd_Api.g_exc_error;
4868: END IF;
4869:

Line 4961: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

4957: END IF;
4958:
4959: -- Check Object version number.
4960: IF (c_task_rec.object_version_number <> l_task_rec.object_version_number) THEN
4961: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
4962: Fnd_Msg_Pub.ADD;
4963: RAISE Fnd_Api.G_EXC_ERROR;
4964: END IF;
4965:

Line 5370: Fnd_Message.SET_NAME('AHL','AHL_VWP_DEPT_NOT_EXISTS');

5366: x_error_msg_code => l_msg_data);
5367:
5368: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success
5369: THEN
5370: Fnd_Message.SET_NAME('AHL','AHL_VWP_DEPT_NOT_EXISTS');
5371: Fnd_Msg_Pub.ADD;
5372: RAISE Fnd_Api.G_EXC_ERROR;
5373: END IF;
5374:

Line 5411: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERIAL_NOT_EXISTS');

5407: x_return_status => l_return_status,
5408: x_error_msg_code => l_msg_data);
5409:
5410: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success THEN
5411: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERIAL_NOT_EXISTS');
5412: Fnd_Msg_Pub.ADD;
5413: RAISE Fnd_Api.G_EXC_ERROR;
5414: ELSE
5415:

Line 5430: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');

5426: /* sowsubra - start
5427: --BEGIN: jeli added for bug 3777720
5428: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(l_task_rec.visit_id, l_task_rec.instance_id) = FND_API.G_RET_STS_ERROR) THEN
5429: --END: jeli added for bug 3777720
5430: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');
5431: Fnd_Msg_Pub.ADD;
5432: RAISE Fnd_Api.G_EXC_ERROR;
5433: END IF;
5434: sowsubra - end */

Line 5478: Fnd_Message.SET_NAME('AHL','AHL_VWP_PARENT_NOT_EXISTS');

5474: x_error_msg_code => l_msg_data);
5475:
5476: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success
5477: THEN
5478: Fnd_Message.SET_NAME('AHL','AHL_VWP_PARENT_NOT_EXISTS');
5479: Fnd_Msg_Pub.ADD;
5480: RAISE Fnd_Api.g_exc_error;
5481: END IF;
5482:

Line 5535: Fnd_Message.SET_NAME('AHL','AHL_VWP_ORIGINATING_NOT_EXISTS');

5531: x_error_msg_code => l_msg_data);
5532:
5533: IF NVL(l_return_status,'x') <> Fnd_Api.g_ret_sts_success
5534: THEN
5535: Fnd_Message.SET_NAME('AHL','AHL_VWP_ORIGINATING_NOT_EXISTS');
5536: Fnd_Msg_Pub.ADD;
5537: RAISE Fnd_Api.g_exc_error;
5538: END IF;
5539:

Line 5572: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_CMP_TARGET_QTY_INVLD');

5568: -- Validate target quantity
5569: IF (l_Task_rec.target_qty IS NOT NULL AND
5570: l_Task_rec.target_qty <> Fnd_Api.G_MISS_NUM AND
5571: l_Task_rec.target_qty < 0) THEN
5572: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_CMP_TARGET_QTY_INVLD');
5573: FND_MSG_PUB.add;
5574: RAISE FND_API.G_EXC_ERROR;
5575: END IF;
5576: ----------- End defining and validate all LOVs on Create Visit's Task UI Screen---

Line 5608: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

5604: END IF;
5605:
5606: -- Check Object version number.
5607: IF (c_task_rec.object_version_number <> l_task_rec.object_version_number) THEN
5608: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
5609: Fnd_Msg_Pub.ADD;
5610: RAISE Fnd_Api.G_EXC_ERROR;
5611: END IF;
5612:

Line 5984: Fnd_Message.SET_NAME('AHL','AHL_VWP_NOT_USE_VISIT');

5980:
5981: ---------------------------------------------- Start----------------------------------------------------------
5982:
5983: IF c_visit_rec.status_code IN ('CLOSED','CANCELLED') THEN
5984: Fnd_Message.SET_NAME('AHL','AHL_VWP_NOT_USE_VISIT');
5985: Fnd_Msg_Pub.ADD;
5986: RAISE Fnd_Api.G_EXC_ERROR;
5987: ELSIF c_task_rec.status_code = 'PLANNING' THEN
5988: IF c_task_rec.task_type_code = 'SUMMARY' THEN

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

6502:
6503: IF c_Task%NOTFOUND THEN
6504: CLOSE c_Task;
6505: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6506: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
6507: Fnd_Msg_Pub.ADD;
6508: END IF;
6509: RAISE Fnd_Api.g_exc_error;
6510: END IF;

Line 6577: Fnd_Message.set_name ('AHL', 'AHL_VWP_TSK_CANNOT_DEL');

6573: END IF;
6574:
6575: ELSE
6576: -- if status is not draft
6577: Fnd_Message.set_name ('AHL', 'AHL_VWP_TSK_CANNOT_DEL');
6578: Fnd_Msg_Pub.ADD;
6579: RAISE FND_API.G_EXC_ERROR;
6580: END IF; -- End of Job Status
6581: CLOSE c_workorders;

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

6691: WHERE Visit_Task_ID = l_task_id;
6692:
6693: IF (SQL%NOTFOUND) THEN
6694: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
6695: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');
6696: Fnd_Msg_Pub.ADD;
6697: END IF;
6698: RAISE Fnd_Api.g_exc_error;
6699: END IF;

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

6702: DELETE FROM Ahl_Visit_Tasks_B
6703: WHERE Visit_Task_ID = l_task_id;
6704:
6705: IF (SQL%NOTFOUND) THEN
6706: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');
6707: Fnd_Msg_Pub.ADD;
6708: RAISE Fnd_Api.g_exc_error;
6709: END IF;
6710:

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

6940: CLOSE c_Task;
6941:
6942: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
6943: THEN
6944: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
6945: Fnd_Msg_Pub.ADD;
6946: END IF;
6947: RAISE Fnd_Api.g_exc_error;
6948: ELSE

Line 6982: Fnd_Message.set_name ('AHL', 'AHL_VWP_TSK_CANNOT_DEL');

6978: END IF;
6979: IF c_workrec.status_code<>'17'
6980: THEN
6981: -- ADD THIS MESSAGE TO SEED115
6982: Fnd_Message.set_name ('AHL', 'AHL_VWP_TSK_CANNOT_DEL');
6983: FND_MESSAGE.SET_TOKEN('Task_Number',c_task_rec.visit_task_number);
6984: Fnd_Msg_Pub.ADD;
6985: CLOSE c_workorders;
6986: CLOSE c_SR_tasks;

Line 6983: FND_MESSAGE.SET_TOKEN('Task_Number',c_task_rec.visit_task_number);

6979: IF c_workrec.status_code<>'17'
6980: THEN
6981: -- ADD THIS MESSAGE TO SEED115
6982: Fnd_Message.set_name ('AHL', 'AHL_VWP_TSK_CANNOT_DEL');
6983: FND_MESSAGE.SET_TOKEN('Task_Number',c_task_rec.visit_task_number);
6984: Fnd_Msg_Pub.ADD;
6985: CLOSE c_workorders;
6986: CLOSE c_SR_tasks;
6987: RAISE fnd_Api.g_exc_error;

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

7222:
7223: IF (SQL%NOTFOUND) THEN
7224: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)
7225: THEN
7226: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');
7227: Fnd_Msg_Pub.ADD;
7228: END IF;
7229: CLOSE c_SR_tasks;
7230: RAISE Fnd_Api.g_exc_error;

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

7243:
7244: IF (SQL%NOTFOUND) THEN
7245: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)
7246: THEN
7247: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');
7248: Fnd_Msg_Pub.ADD;
7249: END IF;
7250: CLOSE c_SR_tasks;
7251: RAISE Fnd_Api.g_exc_error;

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

7465: CLOSE c_Task;
7466:
7467: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
7468: THEN
7469: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
7470: Fnd_Msg_Pub.ADD;
7471: END IF;
7472: RAISE Fnd_Api.g_exc_error;
7473:

Line 7577: Fnd_Message.set_name ('AHL', 'AHL_VWP_PLANNING_OPER');

7573:
7574: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063 :: Need to consider DRAFT status also
7575: IF (c_visit_rec.status_code NOT IN ('PLANNING', 'DRAFT', 'PARTIALLY RELEASED'))
7576: THEN
7577: Fnd_Message.set_name ('AHL', 'AHL_VWP_PLANNING_OPER');
7578: Fnd_Msg_Pub.ADD;
7579: RAISE fnd_Api.g_exc_error;
7580: END IF;
7581:

Line 7616: Fnd_Message.set_name ('AHL', 'AHL_VWP_TSK_CANNOT_DEL');

7612:
7613: IF c_workrec.status_code<>'17'
7614: THEN
7615: -- ADD THIS MESSAGE TO SEED115
7616: Fnd_Message.set_name ('AHL', 'AHL_VWP_TSK_CANNOT_DEL');
7617: FND_MESSAGE.SET_TOKEN('Task_Number',c_task_rec.visit_task_number);
7618: Fnd_Msg_Pub.ADD;
7619: CLOSE c_workorders;
7620: CLOSE c_all_tasks;

Line 7617: FND_MESSAGE.SET_TOKEN('Task_Number',c_task_rec.visit_task_number);

7613: IF c_workrec.status_code<>'17'
7614: THEN
7615: -- ADD THIS MESSAGE TO SEED115
7616: Fnd_Message.set_name ('AHL', 'AHL_VWP_TSK_CANNOT_DEL');
7617: FND_MESSAGE.SET_TOKEN('Task_Number',c_task_rec.visit_task_number);
7618: Fnd_Msg_Pub.ADD;
7619: CLOSE c_workorders;
7620: CLOSE c_all_tasks;
7621: RAISE fnd_Api.g_exc_error;

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

7871: DELETE FROM Ahl_Visit_Tasks_TL WHERE Visit_Task_ID = l_task_id;
7872: IF (SQL%NOTFOUND) THEN
7873: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)
7874: THEN
7875: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');
7876: Fnd_Msg_Pub.ADD;
7877: END IF;
7878: CLOSE c_all_tasks;
7879: RAISE Fnd_Api.g_exc_error;

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

7891:
7892: IF (SQL%NOTFOUND) THEN
7893: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)
7894: THEN
7895: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');
7896: Fnd_Msg_Pub.ADD;
7897: END IF;
7898: CLOSE c_all_tasks;
7899: RAISE Fnd_Api.g_exc_error;

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

8121: DELETE FROM Ahl_Visit_Tasks_TL
8122: WHERE Visit_Task_ID = l_task_id;
8123:
8124: IF (SQL%NOTFOUND) THEN
8125: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');
8126: Fnd_Msg_Pub.ADD;
8127: RAISE Fnd_Api.g_exc_error;
8128: END IF;
8129:

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

8137: DELETE FROM Ahl_Visit_Tasks_B
8138: WHERE Visit_Task_ID = l_task_id;
8139:
8140: IF (SQL%NOTFOUND) THEN
8141: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');
8142: Fnd_Msg_Pub.ADD;
8143: RAISE Fnd_Api.g_exc_error;
8144: END IF;
8145:

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

8596: FETCH c_Visit_Task INTO l_task_rec;
8597: IF c_Visit_Task%NOTFOUND THEN
8598: CLOSE c_Visit_Task;
8599: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
8600: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
8601: Fnd_Msg_Pub.ADD;
8602: END IF;
8603: RAISE Fnd_Api.g_exc_error;
8604: END IF;

Line 8650: Fnd_Message.set_name ('AHL', 'AHL_VWP_NAME_MISSING');

8646: x_return_status := Fnd_Api.g_ret_sts_success;
8647:
8648: -- TASK NAME ==== NAME
8649: IF (p_task_rec.VISIT_TASK_NAME IS NULL OR p_Task_rec.VISIT_TASK_NAME = Fnd_Api.G_MISS_CHAR) THEN
8650: Fnd_Message.set_name ('AHL', 'AHL_VWP_NAME_MISSING');
8651: Fnd_Msg_Pub.ADD;
8652: x_return_status := Fnd_Api.g_ret_sts_error;
8653: END IF;
8654:

Line 8660: Fnd_Message.set_name ('AHL', 'AHL_VWP_ITEM_MISSING');

8656:
8657: -- ITEM ==== INVENTORY_ITEM_ID
8658: IF (p_Task_rec.item_name IS NULL OR p_Task_rec.item_name = Fnd_Api.G_MISS_CHAR ) THEN
8659: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
8660: Fnd_Message.set_name ('AHL', 'AHL_VWP_ITEM_MISSING');
8661: Fnd_Msg_Pub.ADD;
8662: END IF;
8663: x_return_status := Fnd_Api.g_ret_sts_error;
8664: END IF;

Line 8668: Fnd_Message.set_name ('AHL', 'AHL_VWP_DURATION_MISSING');

8664: END IF;
8665:
8666: -- TASK DURATION ==== DURATION
8667: IF (p_task_rec.DURATION IS NULL OR p_Task_rec.DURATION = Fnd_Api.G_MISS_NUM) THEN
8668: Fnd_Message.set_name ('AHL', 'AHL_VWP_DURATION_MISSING');
8669: Fnd_Msg_Pub.ADD;
8670: x_return_status := Fnd_Api.g_ret_sts_error;
8671: END IF;
8672:

Line 8675: Fnd_Message.set_name ('AHL', 'AHL_VWP_ONLY_POSITIVE_VALUE');

8671: END IF;
8672:
8673: IF (p_task_rec.DURATION IS NOT NULL AND p_Task_rec.DURATION <> Fnd_Api.G_MISS_NUM) THEN
8674: IF p_task_rec.DURATION < 0 OR FLOOR(p_task_rec.DURATION) <> p_task_rec.DURATION THEN
8675: Fnd_Message.set_name ('AHL', 'AHL_VWP_ONLY_POSITIVE_VALUE');
8676: Fnd_Msg_Pub.ADD;
8677: x_return_status := Fnd_Api.g_ret_sts_error;
8678: END IF;
8679: END IF;

Line 8688: Fnd_Message.set_name ('AHL', 'AHL_VWP_SERIAL_MISSING');

8684: OPEN c_check_inst_nonserial (p_task_rec.instance_id);
8685: FETCH c_check_inst_nonserial INTO l_serial_ctrl;
8686: IF c_check_inst_nonserial%NOTFOUND THEN
8687: IF (p_Task_rec.SERIAL_NUMBER IS NULL OR p_Task_rec.SERIAL_NUMBER = Fnd_Api.G_MISS_CHAR) THEN
8688: Fnd_Message.set_name ('AHL', 'AHL_VWP_SERIAL_MISSING');
8689: Fnd_Msg_Pub.ADD;
8690: x_return_status := Fnd_Api.g_ret_sts_error;
8691: END IF;
8692: ELSE

Line 8694: Fnd_Message.set_name ('AHL', 'AHL_VWP_SERIAL_NOT_NEEDED');

8690: x_return_status := Fnd_Api.g_ret_sts_error;
8691: END IF;
8692: ELSE
8693: IF (p_Task_rec.SERIAL_NUMBER IS NOT NULL) THEN
8694: Fnd_Message.set_name ('AHL', 'AHL_VWP_SERIAL_NOT_NEEDED');
8695: Fnd_Msg_Pub.ADD;
8696: x_return_status := Fnd_Api.g_ret_sts_error;
8697: END IF;
8698: END IF;

Line 8707: Fnd_Message.set_name ('AHL', 'AHL_VWP_ONLY_POSITIVE_VALUE');

8703: END IF;
8704:
8705: IF (p_task_rec.START_FROM_HOUR IS NOT NULL AND p_Task_rec.START_FROM_HOUR <> Fnd_Api.G_MISS_NUM) THEN
8706: IF p_task_rec.START_FROM_HOUR < 0 OR FLOOR(p_task_rec.START_FROM_HOUR) <> p_task_rec.START_FROM_HOUR THEN
8707: Fnd_Message.set_name ('AHL', 'AHL_VWP_ONLY_POSITIVE_VALUE');
8708: Fnd_Msg_Pub.ADD;
8709: x_return_status := Fnd_Api.g_ret_sts_error;
8710: END IF;
8711: END IF;

Line 8765: Fnd_Message.set_name ('AHL', 'AHL_VWP_DUPLICATE_TASK_ID');

8761: 'Visit_Task_ID = ' || p_task_rec.Visit_Task_ID
8762: ) = Fnd_Api.g_false
8763: THEN
8764: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
8765: Fnd_Message.set_name ('AHL', 'AHL_VWP_DUPLICATE_TASK_ID');
8766: Fnd_Msg_Pub.ADD;
8767: END IF;
8768: x_return_status := Fnd_Api.g_ret_sts_error;
8769: RETURN;

Line 8934: Fnd_Message.SET_NAME('AHL','AHL_VWP_LOCKED_VISIT');

8930: -- Flag to identify whether its a component visit
8931: -- Added for Bug #13737408
8932: l_is_comp_visit := AHL_CMP_UTIL_PKG.Is_Comp_Visit (c_visit_rec.visit_id);
8933: IF l_is_comp_visit = 'N' AND c_visit_rec.locked_flag = 'Y' THEN
8934: Fnd_Message.SET_NAME('AHL','AHL_VWP_LOCKED_VISIT');
8935: Fnd_Msg_Pub.ADD;
8936: RAISE Fnd_Api.G_EXC_ERROR;
8937: END IF;
8938:

Line 8940: Fnd_Message.SET_NAME('AHL','AHL_VWP_NOT_USE_VISIT');

8936: RAISE Fnd_Api.G_EXC_ERROR;
8937: END IF;
8938:
8939: IF c_visit_rec.status_code IN ('CLOSED','CANCELLED') THEN
8940: Fnd_Message.SET_NAME('AHL','AHL_VWP_NOT_USE_VISIT');
8941: Fnd_Msg_Pub.ADD;
8942: RAISE Fnd_Api.G_EXC_ERROR;
8943: ELSE
8944: FOR i IN p_x_task_tbl.first .. p_x_task_tbl.last

Line 8952: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_MAND');

8948: AND l_task_tbl(i).PAST_TASK_START_DATE <> Fnd_Api.G_MISS_DATE) THEN
8949: IF (l_task_tbl(i).PAST_TASK_END_DATE IS NULL
8950: OR l_task_tbl(i).PAST_TASK_START_DATE = Fnd_Api.G_MISS_DATE) THEN
8951: -- if start date is entered but not end date, throw error
8952: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_MAND');
8953: Fnd_Msg_Pub.ADD;
8954: RAISE FND_API.G_EXC_ERROR;
8955: END IF;
8956: -- If both past task start and end dates are non-null

Line 8960: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_PAST_ST_DATE_INV');

8956: -- If both past task start and end dates are non-null
8957: l_past_dates_flag := 'Y';
8958: IF (l_task_tbl(i).PAST_TASK_START_DATE >= SYSDATE) THEN
8959: -- Throw error if start date is not in past
8960: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_PAST_ST_DATE_INV');
8961: Fnd_Msg_Pub.ADD;
8962: RAISE FND_API.G_EXC_ERROR;
8963: END IF;
8964: IF (l_task_tbl(i).PAST_TASK_START_DATE < NVL(c_visit_rec.START_DATE_TIME, l_task_tbl(i).PAST_TASK_START_DATE)) THEN

Line 8966: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_START_DATE_INVLD');

8962: RAISE FND_API.G_EXC_ERROR;
8963: END IF;
8964: IF (l_task_tbl(i).PAST_TASK_START_DATE < NVL(c_visit_rec.START_DATE_TIME, l_task_tbl(i).PAST_TASK_START_DATE)) THEN
8965: -- Throw error if past task start date is before the visit start date
8966: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_START_DATE_INVLD');
8967: Fnd_Msg_Pub.ADD;
8968: RAISE FND_API.G_EXC_ERROR;
8969: END IF;
8970: IF (l_task_tbl(i).PAST_TASK_START_DATE > l_task_tbl(i).PAST_TASK_END_DATE) THEN

Line 8972: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_INVLD');

8968: RAISE FND_API.G_EXC_ERROR;
8969: END IF;
8970: IF (l_task_tbl(i).PAST_TASK_START_DATE > l_task_tbl(i).PAST_TASK_END_DATE) THEN
8971: -- Throw error if past task start date is after the past task end date
8972: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_INVLD');
8973: Fnd_Msg_Pub.ADD;
8974: RAISE FND_API.G_EXC_ERROR;
8975: END IF;
8976: IF (l_task_tbl(i).PAST_TASK_END_DATE > NVL(c_visit_rec.CLOSE_DATE_TIME, l_task_tbl(i).PAST_TASK_END_DATE)) THEN

Line 8978: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_END_DATE_INVLD');

8974: RAISE FND_API.G_EXC_ERROR;
8975: END IF;
8976: IF (l_task_tbl(i).PAST_TASK_END_DATE > NVL(c_visit_rec.CLOSE_DATE_TIME, l_task_tbl(i).PAST_TASK_END_DATE)) THEN
8977: -- Throw error if visit ends before the task
8978: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_END_DATE_INVLD');
8979: Fnd_Msg_Pub.ADD;
8980: RAISE FND_API.G_EXC_ERROR;
8981: END IF;
8982: ELSE -- PAST_TASK_START_DATE is null

Line 8988: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_MAND');

8984: -- Also changed the condition from l_task_tbl(i).PAST_TASK_START_DATE <> Fnd_Api.G_MISS_DATE
8985: -- to l_task_tbl(i).PAST_TASK_END_DATE <> Fnd_Api.G_MISS_DATE
8986: IF (l_task_tbl(i).PAST_TASK_END_DATE IS NOT NULL
8987: AND l_task_tbl(i).PAST_TASK_END_DATE <> Fnd_Api.G_MISS_DATE) THEN
8988: Fnd_Message.SET_NAME('AHL','AHL_VWP_PAST_TASK_DATE_MAND');
8989: Fnd_Msg_Pub.ADD;
8990: RAISE FND_API.G_EXC_ERROR;
8991: END IF;
8992: l_task_tbl(i).PAST_TASK_START_DATE := NULL;

Line 9025: Fnd_Message.SET_NAME('AHL','AHL_CMP_TSK_QTY_RPR_QTY');

9021: FETCH c_get_target_qty INTO l_target_qty;
9022: CLOSE c_get_target_qty;
9023:
9024: IF(l_task_tbl(i).QUANTITY > NVL(l_target_qty, 0)) THEN
9025: Fnd_Message.SET_NAME('AHL','AHL_CMP_TSK_QTY_RPR_QTY');
9026: Fnd_Msg_Pub.ADD;
9027: RAISE Fnd_Api.G_EXC_ERROR;
9028: END IF;
9029:

Line 9031: Fnd_Message.SET_NAME('AHL','AHL_INCORRECT_TSK_QTY');

9027: RAISE Fnd_Api.G_EXC_ERROR;
9028: END IF;
9029:
9030: ELSIF(l_task_tbl(i).QUANTITY > l_instance_qty ) THEN
9031: Fnd_Message.SET_NAME('AHL','AHL_INCORRECT_TSK_QTY');
9032: Fnd_Msg_Pub.ADD;
9033: RAISE Fnd_Api.G_EXC_ERROR;
9034: END IF;
9035: */

Line 9037: Fnd_Message.SET_NAME('AHL','AHL_INCORRECT_TSK_QTY');

9033: RAISE Fnd_Api.G_EXC_ERROR;
9034: END IF;
9035: */
9036: IF(l_task_tbl(i).QUANTITY > l_instance_qty ) THEN
9037: Fnd_Message.SET_NAME('AHL','AHL_INCORRECT_TSK_QTY');
9038: Fnd_Msg_Pub.ADD;
9039: RAISE Fnd_Api.G_EXC_ERROR;
9040: END IF;
9041:

Line 9058: FND_MESSAGE.SET_NAME ('AHL', 'AHL_VWP_TSK_START_DATE_INVLD');

9054: -- SKPATHAK :: Bug 8343599 :: 14_APR-2009
9055: -- Check if the user entered task start date is between the visit start and end dates
9056: IF (l_task_tbl(i).task_start_date < c_visit_rec.START_DATE_TIME OR
9057: l_task_tbl(i).task_start_date > c_visit_rec.CLOSE_DATE_TIME) THEN
9058: FND_MESSAGE.SET_NAME ('AHL', 'AHL_VWP_TSK_START_DATE_INVLD');
9059: FND_MESSAGE.SET_TOKEN('DATE', l_task_tbl(i).task_start_date);
9060: FND_MSG_PUB.ADD;
9061: RAISE FND_API.G_EXC_ERROR;
9062: END IF;

Line 9059: FND_MESSAGE.SET_TOKEN('DATE', l_task_tbl(i).task_start_date);

9055: -- Check if the user entered task start date is between the visit start and end dates
9056: IF (l_task_tbl(i).task_start_date < c_visit_rec.START_DATE_TIME OR
9057: l_task_tbl(i).task_start_date > c_visit_rec.CLOSE_DATE_TIME) THEN
9058: FND_MESSAGE.SET_NAME ('AHL', 'AHL_VWP_TSK_START_DATE_INVLD');
9059: FND_MESSAGE.SET_TOKEN('DATE', l_task_tbl(i).task_start_date);
9060: FND_MSG_PUB.ADD;
9061: RAISE FND_API.G_EXC_ERROR;
9062: END IF;
9063:

Line 9097: Fnd_Message.SET_NAME('AHL','AHL_TASK_QTY_NULL');

9093: FETCH c_get_instance_qty INTO l_instance_qty;
9094: CLOSE c_get_instance_qty;
9095:
9096: IF (l_task_tbl(i).QUANTITY is null) THEN
9097: Fnd_Message.SET_NAME('AHL','AHL_TASK_QTY_NULL');
9098: Fnd_Msg_Pub.ADD;
9099: RAISE Fnd_Api.G_EXC_ERROR;
9100: END IF;
9101:

Line 9103: Fnd_Message.SET_NAME('AHL','AHL_POSITIVE_TSK_QTY');

9099: RAISE Fnd_Api.G_EXC_ERROR;
9100: END IF;
9101:
9102: IF (l_task_tbl(i).QUANTITY <= 0 ) THEN
9103: Fnd_Message.SET_NAME('AHL','AHL_POSITIVE_TSK_QTY');
9104: Fnd_Msg_Pub.ADD;
9105: RAISE Fnd_Api.G_EXC_ERROR;
9106: END IF;
9107: /*Kasridha : Changes for Component Maintenance Planning Begins

Line 9120: Fnd_Message.SET_NAME('AHL','AHL_CMP_TSK_QTY_RPR_QTY');

9116: FETCH c_get_target_qty INTO l_target_qty;
9117: CLOSE c_get_target_qty;
9118:
9119: IF(l_task_tbl(i).QUANTITY > NVL(l_target_qty, 0)) THEN
9120: Fnd_Message.SET_NAME('AHL','AHL_CMP_TSK_QTY_RPR_QTY');
9121: Fnd_Msg_Pub.ADD;
9122: RAISE Fnd_Api.G_EXC_ERROR;
9123: END IF;
9124:

Line 9127: Fnd_Message.SET_NAME('AHL','AHL_INCORRECT_TSK_QTY');

9123: END IF;
9124:
9125:
9126: ELSIF(l_task_tbl(i).QUANTITY > l_instance_qty ) THEN
9127: Fnd_Message.SET_NAME('AHL','AHL_INCORRECT_TSK_QTY');
9128: Fnd_Msg_Pub.ADD;
9129: RAISE Fnd_Api.G_EXC_ERROR;
9130: END IF;
9131: */

Line 9134: Fnd_Message.SET_NAME('AHL','AHL_INCORRECT_TSK_QTY');

9130: END IF;
9131: */
9132:
9133: IF(l_task_tbl(i).QUANTITY > l_instance_qty ) THEN
9134: Fnd_Message.SET_NAME('AHL','AHL_INCORRECT_TSK_QTY');
9135: Fnd_Msg_Pub.ADD;
9136: RAISE Fnd_Api.G_EXC_ERROR;
9137: END IF;
9138:

Line 10029: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CST_INPUT_MISS');

10025:
10026: --------------------Start of API Body-----------------------------------
10027:
10028: IF(p_visit_id IS NULL OR p_visit_id = FND_API.G_MISS_NUM) THEN
10029: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CST_INPUT_MISS');
10030: FND_MSG_PUB.ADD;
10031: IF (l_log_statement >= l_log_current_level) THEN
10032: fnd_log.string(l_log_statement,
10033: L_DEBUG_KEY,

Line 10043: FND_MESSAGE.Set_Name('AHL','AHL_STAGE_ID_INVALID');

10039: -- Validate the visit id
10040: OPEN val_visit(p_visit_id);
10041: FETCH val_visit INTO l_dummy;
10042: IF (val_visit%NOTFOUND) THEN
10043: FND_MESSAGE.Set_Name('AHL','AHL_STAGE_ID_INVALID');
10044: FND_MSG_PUB.ADD;
10045:
10046: IF (l_log_statement >= l_log_current_level) THEN
10047: fnd_log.string(l_log_statement,

Line 10063: FND_MESSAGE.Set_Name('AHL','AHL_STAGE_ID_INVALID');

10059: IF p_stage_id IS NOT NULL THEN
10060: OPEN val_visit_stage(p_visit_id, p_stage_id);
10061: FETCH val_visit_stage INTO l_dummy;
10062: IF (val_visit_stage%NOTFOUND) THEN
10063: FND_MESSAGE.Set_Name('AHL','AHL_STAGE_ID_INVALID');
10064: FND_MSG_PUB.ADD;
10065:
10066: IF (l_log_statement >= l_log_current_level) THEN
10067: fnd_log.string(l_log_statement,

Line 10080: FND_MESSAGE.Set_Name('AHL','AHL_VISIT_ID_INVALID');

10076:
10077: OPEN Get_Visit_Details (P_VISIT_ID);
10078: FETCH Get_Visit_Details INTO visit_details_rec;
10079: IF (Get_Visit_Details%NOTFOUND) THEN
10080: FND_MESSAGE.Set_Name('AHL','AHL_VISIT_ID_INVALID');
10081: FND_MSG_PUB.ADD;
10082:
10083: IF (l_log_statement >= l_log_current_level) THEN
10084: fnd_log.string(l_log_statement,

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

10395:
10396: IF c_Task%NOTFOUND THEN
10397: CLOSE c_Task;
10398: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
10399: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
10400: Fnd_Msg_Pub.ADD;
10401: END IF;
10402: RAISE Fnd_Api.g_exc_error;
10403: END IF;

Line 10421: Fnd_Message.SET_NAME('AHL','AHL_VWP_STG_NO_DEL_HAV_TASKS');

10417: FETCH c_stage_tasks_count INTO l_stage_tasks_count;
10418: CLOSE c_stage_tasks_count;
10419:
10420: IF l_stage_tasks_count>0 THEN
10421: Fnd_Message.SET_NAME('AHL','AHL_VWP_STG_NO_DEL_HAV_TASKS');
10422: Fnd_Msg_Pub.ADD;
10423: RAISE FND_API.G_EXC_ERROR;
10424: END IF;*/
10425:

Line 10486: Fnd_Message.set_name ('AHL', 'AHL_VWP_TSK_CANNOT_DEL');

10482: END IF;
10483:
10484: ELSE
10485: -- if status is not draft
10486: Fnd_Message.set_name ('AHL', 'AHL_VWP_TSK_CANNOT_DEL');
10487: Fnd_Msg_Pub.ADD;
10488: RAISE FND_API.G_EXC_ERROR;
10489: END IF; -- End of Job Status
10490: CLOSE c_workorders;