eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on FND_MSG_PUB

Line 343: Fnd_Msg_Pub.ADD;

339: x_error_msg_code => l_msg_data);
340:
341: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
342: Fnd_Message.SET_NAME('AHL','AHL_VWP_DEPT_NOT_EXISTS');
343: Fnd_Msg_Pub.ADD;
344: RAISE Fnd_Api.G_EXC_ERROR;
345: END IF;
346:
347: -- Changes for Post 11.5.10 by amagrawa

Line 354: Fnd_Msg_Pub.ADD;

350: X_RETURN_STATUS => l_return_status);
351:
352: IF (NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS) THEN
353: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_DEPT_SHIFT');
354: Fnd_Msg_Pub.ADD;
355: RAISE Fnd_Api.G_EXC_ERROR;
356: END IF;
357: ELSE
358: p_x_task_Rec.dept_name := NULL;

Line 374: Fnd_Msg_Pub.ADD;

370: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
371: fnd_log.string(fnd_log.level_statement,L_DEBUG,' NO ORGANIZATION FOR VISIT');
372: END IF;
373: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_NO_ORG_EXISTS');
374: Fnd_Msg_Pub.ADD;
375: RAISE Fnd_Api.G_EXC_ERROR;
376: END IF;
377: END IF; -- End of if visit org exists
378:

Line 390: Fnd_Msg_Pub.ADD;

386: x_error_msg_code => l_msg_data);
387:
388: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
389: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERVICE_REQ_NOT_EXISTS');
390: Fnd_Msg_Pub.ADD;
391: RAISE Fnd_Api.g_exc_error;
392: END IF;
393:
394: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 628: Fnd_Msg_Pub.initialize;

624: fnd_log.string(fnd_log.level_procedure, L_DEBUG||'.begin','At the start of PLSQL procedure');
625: END IF;
626:
627: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
628: Fnd_Msg_Pub.initialize;
629: END IF;
630:
631: IF NOT Fnd_Api.compatible_api_call (
632: L_API_VERSION,

Line 691: Fnd_Msg_Pub.ADD;

687: -- ERROR MESSAGE
688: x_return_status := Fnd_Api.g_ret_sts_error;
689: Fnd_Message.SET_NAME('AHL','AHL_VWP_UNIT_FOUND');
690: Fnd_Message.SET_TOKEN('VISIT_NUMBER', l_visit_number);
691: Fnd_Msg_Pub.ADD;
692: ELSE -- UE not planned in any other Visit
693: CLOSE c_unit;
694:
695: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 838: Fnd_Msg_Pub.ADD;

834: -- Done to allow creation of a task for an instance that has already been removed.
835: /***
836: IF AHL_VWP_RULES_PVT.instance_in_config_tree(l_visit_id, l_serial_id) = FND_API.G_RET_STS_ERROR THEN
837: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');
838: Fnd_Msg_Pub.ADD;
839: RAISE Fnd_Api.G_EXC_ERROR;
840: END IF; ***/
841:
842: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 949: x_msg_count := FND_MSG_PUB.count_msg;

945: );
946: */
947:
948: -- Check Error Message stack.
949: x_msg_count := FND_MSG_PUB.count_msg;
950: IF x_msg_count > 0 THEN
951: RAISE FND_API.G_EXC_ERROR;
952: END IF;
953:

Line 993: Fnd_Msg_Pub.initialize;

989:
990: IF NVL(x_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
991: RAISE Fnd_Api.G_EXC_ERROR;
992: ELSE
993: Fnd_Msg_Pub.initialize;
994: END IF;
995: END IF; -- SR/MR
996: /* Added by rnahata for Bug 6939329 */
997: OPEN c_task_id_for_ue(l_visit_id, l_unit_effectivity_id);

Line 1008: Fnd_Msg_Pub.ADD;

1004: /* End changes by rnahata for Bug 6939329 */
1005: END IF; -- c_unit%FOUND
1006: ELSE -- l_unit_effectivity_id
1007: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_UNIT_EFFECTIVITY');
1008: Fnd_Msg_Pub.ADD;
1009: RAISE FND_API.G_EXC_ERROR;
1010: END IF; -- End of unit effectivity check
1011:
1012: OPEN C_VISIT(l_visit_id);

Line 1031: Fnd_Msg_Pub.count_and_get

1027: CLOSE C_VISIT;
1028:
1029: ------------------------- finish -------------------------------
1030: -- Standard call to get message count and if count is 1, get message info
1031: Fnd_Msg_Pub.count_and_get
1032: (
1033: p_encoded => Fnd_Api.g_false,
1034: p_count => x_msg_count,
1035: p_data => x_msg_data

Line 1039: x_msg_count := FND_MSG_PUB.count_msg;

1035: p_data => x_msg_data
1036: );
1037:
1038: -- Check Error Message stack.
1039: x_msg_count := FND_MSG_PUB.count_msg;
1040: IF x_msg_count > 0 THEN
1041: RAISE FND_API.G_EXC_ERROR;
1042: END IF;
1043:

Line 1057: Fnd_Msg_Pub.count_and_get(

1053: EXCEPTION
1054: WHEN Fnd_Api.g_exc_error THEN
1055: ROLLBACK TO Create_Planned_Task;
1056: x_return_status := Fnd_Api.g_ret_sts_error;
1057: Fnd_Msg_Pub.count_and_get(
1058: p_encoded => Fnd_Api.g_false,
1059: p_count => x_msg_count,
1060: p_data => x_msg_data
1061: );

Line 1065: Fnd_Msg_Pub.count_and_get (

1061: );
1062: WHEN Fnd_Api.g_exc_unexpected_error THEN
1063: ROLLBACK TO Create_Planned_Task;
1064: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1065: Fnd_Msg_Pub.count_and_get (
1066: p_encoded => Fnd_Api.g_false,
1067: p_count => x_msg_count,
1068: p_data => x_msg_data
1069: );

Line 1073: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

1069: );
1070: WHEN OTHERS THEN
1071: ROLLBACK TO Create_Planned_Task;
1072: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1073: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1074: THEN
1075: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1076: END IF;
1077: Fnd_Msg_Pub.count_and_get (

Line 1075: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

1071: ROLLBACK TO Create_Planned_Task;
1072: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1073: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1074: THEN
1075: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1076: END IF;
1077: Fnd_Msg_Pub.count_and_get (
1078: p_encoded => Fnd_Api.g_false,
1079: p_count => x_msg_count,

Line 1077: Fnd_Msg_Pub.count_and_get (

1073: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1074: THEN
1075: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1076: END IF;
1077: Fnd_Msg_Pub.count_and_get (
1078: p_encoded => Fnd_Api.g_false,
1079: p_count => x_msg_count,
1080: p_data => x_msg_data
1081: );

Line 1239: Fnd_Msg_Pub.ADD;

1235: FETCH c_validate_mr INTO l_dummy;
1236: IF c_validate_mr%FOUND THEN
1237: CLOSE c_validate_mr;
1238: Fnd_Message.SET_NAME('AHL','AHL_VWP_NR_MR_EXPIRED');
1239: Fnd_Msg_Pub.ADD;
1240: RAISE Fnd_Api.G_EXC_ERROR;
1241: END IF;
1242: CLOSE c_validate_mr;
1243:

Line 1259: Fnd_Msg_Pub.ADD;

1255: FETCH c_validate_child_mrs INTO l_dummy1;
1256: IF c_validate_child_mrs%FOUND THEN
1257: CLOSE c_validate_child_mrs;
1258: Fnd_Message.SET_NAME('AHL','AHL_VWP_NR_MR_EXPIRED');
1259: Fnd_Msg_Pub.ADD;
1260: RAISE Fnd_Api.G_EXC_ERROR;
1261: END IF;
1262: CLOSE c_validate_child_mrs;
1263:

Line 1279: Fnd_Msg_Pub.ADD;

1275: -- Done to allow creation of a task for an instance that has already been removed.
1276: /***
1277: IF AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, l_serial_id) = FND_API.G_RET_STS_ERROR THEN
1278: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');
1279: Fnd_Msg_Pub.ADD;
1280: RAISE Fnd_Api.G_EXC_ERROR;
1281: END IF;
1282: ***/
1283:

Line 1476: Fnd_Msg_Pub.initialize;

1472: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');
1473: END IF;
1474:
1475: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
1476: Fnd_Msg_Pub.initialize;
1477: END IF;
1478:
1479: -- Initialize API return status to success
1480: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 1531: Fnd_Msg_Pub.ADD;

1527:
1528: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS
1529: THEN
1530: Fnd_Message.SET_NAME('AHL','AHL_VWP_DEPT_NOT_EXISTS');
1531: Fnd_Msg_Pub.ADD;
1532: RAISE Fnd_Api.G_EXC_ERROR;
1533: END IF;
1534:
1535: --Assign the returned value

Line 1561: Fnd_Msg_Pub.ADD;

1557:
1558: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS
1559: THEN
1560: Fnd_Message.SET_NAME('AHL','AHL_VWP_PARENT_NOT_EXISTS');
1561: Fnd_Msg_Pub.ADD;
1562: RAISE Fnd_Api.g_exc_error;
1563: END IF;
1564:
1565: --Assign the returned value

Line 1622: Fnd_Msg_Pub.ADD;

1618:
1619: -- Check Object version number.
1620: IF (c_task_rec.object_version_number <> l_task_rec.object_version_number) THEN
1621: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1622: Fnd_Msg_Pub.ADD;
1623: RAISE Fnd_Api.g_exc_error;
1624: END IF;
1625:
1626: -- Post 11.5.10 Changes by Senthil.

Line 1642: l_msg_count := Fnd_Msg_Pub.count_msg;

1638:
1639: END IF;
1640:
1641: -- Standard check to count messages
1642: l_msg_count := Fnd_Msg_Pub.count_msg;
1643:
1644: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.g_ret_sts_success THEN
1645: X_msg_count := l_msg_count;
1646: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1777: l_msg_count := Fnd_Msg_Pub.count_msg;

1773: 'After calling AHL_WARRANTY_ENTL_PVT.Process_Warranty_Entitlements. Return Status = ' ||
1774: l_return_status);
1775: END IF;
1776:
1777: l_msg_count := Fnd_Msg_Pub.count_msg;
1778: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
1779: x_msg_count := l_msg_count;
1780: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1781: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 1808: l_msg_count := Fnd_Msg_Pub.count_msg;

1804: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TIMES_PVT.Adjust_Task_Times - l_return_status : '||l_return_status);
1805: END IF;
1806:
1807: --Standard check to count messages
1808: l_msg_count := Fnd_Msg_Pub.count_msg;
1809:
1810: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.g_ret_sts_success THEN
1811: x_msg_count := l_msg_count;
1812: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1868: l_msg_count := Fnd_Msg_Pub.count_msg;

1864: END IF;
1865: END IF;
1866:
1867: --Standard check to count messages
1868: l_msg_count := Fnd_Msg_Pub.count_msg;
1869:
1870: IF l_msg_count > 0 THEN
1871: X_msg_count := l_msg_count;
1872: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1889: Fnd_Msg_Pub.count_and_get (

1885: EXCEPTION
1886: WHEN Fnd_Api.g_exc_error THEN
1887: ROLLBACK TO Update_Planned_Task;
1888: x_return_status := Fnd_Api.g_ret_sts_error;
1889: Fnd_Msg_Pub.count_and_get (
1890: p_encoded => Fnd_Api.g_false,
1891: p_count => x_msg_count,
1892: p_data => x_msg_data
1893: );

Line 1897: Fnd_Msg_Pub.count_and_get (

1893: );
1894: WHEN Fnd_Api.g_exc_unexpected_error THEN
1895: ROLLBACK TO Update_Planned_Task;
1896: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1897: Fnd_Msg_Pub.count_and_get (
1898: p_encoded => Fnd_Api.g_false,
1899: p_count => x_msg_count,
1900: p_data => x_msg_data
1901: );

Line 1905: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN

1901: );
1902: WHEN OTHERS THEN
1903: ROLLBACK TO Update_Planned_Task;
1904: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1905: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
1906: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1907: END IF;
1908: Fnd_Msg_Pub.count_and_get (
1909: p_encoded => Fnd_Api.g_false,

Line 1906: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

1902: WHEN OTHERS THEN
1903: ROLLBACK TO Update_Planned_Task;
1904: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1905: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
1906: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1907: END IF;
1908: Fnd_Msg_Pub.count_and_get (
1909: p_encoded => Fnd_Api.g_false,
1910: p_count => x_msg_count,

Line 1908: Fnd_Msg_Pub.count_and_get (

1904: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1905: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
1906: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1907: END IF;
1908: Fnd_Msg_Pub.count_and_get (
1909: p_encoded => Fnd_Api.g_false,
1910: p_count => x_msg_count,
1911: p_data => x_msg_data
1912: );

Line 1958: Fnd_Msg_Pub.initialize;

1954: fnd_log.string(fnd_log.level_procedure,l_debug||'.begin','At the start of PLSQL procedure');
1955: END IF;
1956:
1957: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
1958: Fnd_Msg_Pub.initialize;
1959: END IF;
1960:
1961: -- Initialize API return status to success
1962: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 1987: Fnd_Msg_Pub.ADD;

1983: IF c_Task%NOTFOUND THEN
1984: CLOSE c_Task;
1985: Fnd_Message.set_name('AHL', 'AHL_VWP_TASK_ID_INVALID');
1986: FND_MESSAGE.SET_TOKEN('TASK_ID',p_visit_task_id,false);
1987: Fnd_Msg_Pub.ADD;
1988: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1989: fnd_log.string(fnd_log.level_statement,l_debug,'Invalid Task Id' || p_visit_task_ID);
1990: END IF;
1991: RAISE Fnd_Api.g_exc_error;

Line 2022: Fnd_Msg_Pub.ADD;

2018: RAISE Fnd_Api.G_EXC_ERROR;
2019: END IF;
2020: ELSE
2021: Fnd_Message.SET_NAME('AHL','AHL_VWP_PLANNEDTASKMR');
2022: Fnd_Msg_Pub.ADD;
2023: RAISE Fnd_Api.G_EXC_ERROR;
2024: End IF;
2025: END IF;
2026: ------------------------End of API Body------------------------------------

Line 2031: Fnd_Msg_Pub.count_and_get (

2027: IF Fnd_Api.to_boolean (p_commit) THEN
2028: COMMIT;
2029: END IF;
2030:
2031: Fnd_Msg_Pub.count_and_get (
2032: p_encoded => Fnd_Api.g_false,
2033: p_count => x_msg_count,
2034: p_data => x_msg_data
2035: );

Line 2044: Fnd_Msg_Pub.count_and_get (

2040: EXCEPTION
2041: WHEN Fnd_Api.g_exc_error THEN
2042: ROLLBACK TO Delete_Planned_Task;
2043: x_return_status := Fnd_Api.g_ret_sts_error;
2044: Fnd_Msg_Pub.count_and_get (
2045: p_encoded => Fnd_Api.g_false,
2046: p_count => x_msg_count,
2047: p_data => x_msg_data
2048: );

Line 2053: Fnd_Msg_Pub.count_and_get (

2049:
2050: WHEN Fnd_Api.g_exc_unexpected_error THEN
2051: ROLLBACK TO Delete_Planned_Task;
2052: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2053: Fnd_Msg_Pub.count_and_get (
2054: p_encoded => Fnd_Api.g_false,
2055: p_count => x_msg_count,
2056: p_data => x_msg_data
2057: );

Line 2062: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

2058:
2059: WHEN OTHERS THEN
2060: ROLLBACK TO Delete_Planned_Task;
2061: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2062: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
2063: THEN
2064: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
2065: END IF;
2066: Fnd_Msg_Pub.count_and_get (

Line 2064: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

2060: ROLLBACK TO Delete_Planned_Task;
2061: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2062: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
2063: THEN
2064: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
2065: END IF;
2066: Fnd_Msg_Pub.count_and_get (
2067: p_encoded => Fnd_Api.g_false,
2068: p_count => x_msg_count,

Line 2066: Fnd_Msg_Pub.count_and_get (

2062: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
2063: THEN
2064: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
2065: END IF;
2066: Fnd_Msg_Pub.count_and_get (
2067: p_encoded => Fnd_Api.g_false,
2068: p_count => x_msg_count,
2069: p_data => x_msg_data
2070: );

Line 2164: Fnd_Msg_Pub.ADD;

2160: FETCH c_Visit_Task INTO l_task_rec;
2161: IF c_Visit_Task%NOTFOUND THEN
2162: CLOSE c_Visit_Task;
2163: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
2164: Fnd_Msg_Pub.ADD;
2165: RAISE Fnd_Api.g_exc_error;
2166: END IF;
2167: CLOSE c_Visit_Task;
2168:

Line 2199: Fnd_Msg_Pub.ADD;

2195:
2196: -- TASK NAME ==== NAME
2197: IF (p_task_rec.VISIT_TASK_NAME IS NULL OR p_Task_rec.VISIT_TASK_NAME = Fnd_Api.G_MISS_CHAR) THEN
2198: Fnd_Message.set_name ('AHL', 'AHL_VWP_NAME_MISSING');
2199: Fnd_Msg_Pub.ADD;
2200: x_return_status := Fnd_Api.g_ret_sts_error;
2201: RETURN;
2202: END IF;
2203:

Line 2211: Fnd_Msg_Pub.ADD;

2207:
2208: IF (p_task_rec.START_FROM_HOUR IS NOT NULL and p_Task_rec.START_FROM_HOUR <> Fnd_Api.G_MISS_NUM) THEN
2209: IF p_task_rec.START_FROM_HOUR < 0 OR FLOOR(p_task_rec.START_FROM_HOUR) <> p_task_rec.START_FROM_HOUR THEN
2210: Fnd_Message.set_name ('AHL', 'AHL_VWP_ONLY_POSITIVE_VALUE');
2211: Fnd_Msg_Pub.ADD;
2212: x_return_status := Fnd_Api.g_ret_sts_error;
2213: RETURN;
2214: END IF;
2215: END IF;

Line 2256: Fnd_Msg_Pub.ADD;

2252: 'Visit_Task_ID = ' || p_task_rec.Visit_Task_ID
2253: ) = Fnd_Api.g_false
2254: THEN
2255: Fnd_Message.set_name ('AHL', 'AHL_VWP_DUPLICATE_TASK_ID');
2256: Fnd_Msg_Pub.ADD;
2257: x_return_status := Fnd_Api.g_ret_sts_error;
2258: RETURN;
2259: END IF;
2260: END IF;