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 336: Fnd_Msg_Pub.ADD;

332: x_error_msg_code => l_msg_data);
333:
334: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
335: Fnd_Message.SET_NAME('AHL','AHL_VWP_DEPT_NOT_EXISTS');
336: Fnd_Msg_Pub.ADD;
337: RAISE Fnd_Api.G_EXC_ERROR;
338: END IF;
339:
340: -- Changes for Post 11.5.10 by amagrawa

Line 347: Fnd_Msg_Pub.ADD;

343: X_RETURN_STATUS => l_return_status);
344:
345: IF (NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS) THEN
346: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_DEPT_SHIFT');
347: Fnd_Msg_Pub.ADD;
348: RAISE Fnd_Api.G_EXC_ERROR;
349: END IF;
350: ELSE
351: p_x_task_Rec.dept_name := NULL;

Line 367: Fnd_Msg_Pub.ADD;

363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
364: fnd_log.string(fnd_log.level_statement,L_DEBUG,' NO ORGANIZATION FOR VISIT');
365: END IF;
366: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_NO_ORG_EXISTS');
367: Fnd_Msg_Pub.ADD;
368: RAISE Fnd_Api.G_EXC_ERROR;
369: END IF;
370: END IF; -- End of if visit org exists
371:

Line 383: Fnd_Msg_Pub.ADD;

379: x_error_msg_code => l_msg_data);
380:
381: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
382: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERVICE_REQ_NOT_EXISTS');
383: Fnd_Msg_Pub.ADD;
384: RAISE Fnd_Api.g_exc_error;
385: END IF;
386:
387: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 617: Fnd_Msg_Pub.initialize;

613: fnd_log.string(fnd_log.level_procedure, L_DEBUG||'.begin','At the start of PLSQL procedure');
614: END IF;
615:
616: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
617: Fnd_Msg_Pub.initialize;
618: END IF;
619:
620: IF NOT Fnd_Api.compatible_api_call (
621: L_API_VERSION,

Line 667: Fnd_Msg_Pub.ADD;

663: -- ERROR MESSAGE
664: x_return_status := Fnd_Api.g_ret_sts_error;
665: Fnd_Message.SET_NAME('AHL','AHL_VWP_UNIT_FOUND');
666: Fnd_Message.SET_TOKEN('VISIT_NUMBER', l_visit_number);
667: Fnd_Msg_Pub.ADD;
668: ELSE -- UE not planned in any other Visit
669: CLOSE c_unit;
670:
671: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 798: Fnd_Msg_Pub.ADD;

794: -- Done to allow creation of a task for an instance that has already been removed.
795: /***
796: IF AHL_VWP_RULES_PVT.instance_in_config_tree(l_visit_id, l_serial_id) = FND_API.G_RET_STS_ERROR THEN
797: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');
798: Fnd_Msg_Pub.ADD;
799: RAISE Fnd_Api.G_EXC_ERROR;
800: END IF; ***/
801:
802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 882: x_msg_count := FND_MSG_PUB.count_msg;

878: );
879: */
880:
881: -- Check Error Message stack.
882: x_msg_count := FND_MSG_PUB.count_msg;
883: IF x_msg_count > 0 THEN
884: RAISE FND_API.G_EXC_ERROR;
885: END IF;
886:

Line 926: Fnd_Msg_Pub.initialize;

922:
923: IF NVL(x_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
924: RAISE Fnd_Api.G_EXC_ERROR;
925: ELSE
926: Fnd_Msg_Pub.initialize;
927: END IF;
928: END IF; -- SR/MR
929: /* Added by rnahata for Bug 6939329 */
930: OPEN c_task_id_for_ue(l_visit_id, l_unit_effectivity_id);

Line 941: Fnd_Msg_Pub.ADD;

937: /* End changes by rnahata for Bug 6939329 */
938: END IF; -- c_unit%FOUND
939: ELSE -- l_unit_effectivity_id
940: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_UNIT_EFFECTIVITY');
941: Fnd_Msg_Pub.ADD;
942: RAISE FND_API.G_EXC_ERROR;
943: END IF; -- End of unit effectivity check
944:
945: OPEN C_VISIT(l_visit_id);

Line 964: Fnd_Msg_Pub.count_and_get

960: CLOSE C_VISIT;
961:
962: ------------------------- finish -------------------------------
963: -- Standard call to get message count and if count is 1, get message info
964: Fnd_Msg_Pub.count_and_get
965: (
966: p_encoded => Fnd_Api.g_false,
967: p_count => x_msg_count,
968: p_data => x_msg_data

Line 972: x_msg_count := FND_MSG_PUB.count_msg;

968: p_data => x_msg_data
969: );
970:
971: -- Check Error Message stack.
972: x_msg_count := FND_MSG_PUB.count_msg;
973: IF x_msg_count > 0 THEN
974: RAISE FND_API.G_EXC_ERROR;
975: END IF;
976:

Line 990: Fnd_Msg_Pub.count_and_get(

986: EXCEPTION
987: WHEN Fnd_Api.g_exc_error THEN
988: ROLLBACK TO Create_Planned_Task;
989: x_return_status := Fnd_Api.g_ret_sts_error;
990: Fnd_Msg_Pub.count_and_get(
991: p_encoded => Fnd_Api.g_false,
992: p_count => x_msg_count,
993: p_data => x_msg_data
994: );

Line 998: Fnd_Msg_Pub.count_and_get (

994: );
995: WHEN Fnd_Api.g_exc_unexpected_error THEN
996: ROLLBACK TO Create_Planned_Task;
997: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
998: Fnd_Msg_Pub.count_and_get (
999: p_encoded => Fnd_Api.g_false,
1000: p_count => x_msg_count,
1001: p_data => x_msg_data
1002: );

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

1002: );
1003: WHEN OTHERS THEN
1004: ROLLBACK TO Create_Planned_Task;
1005: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1006: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1007: THEN
1008: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1009: END IF;
1010: Fnd_Msg_Pub.count_and_get (

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

1004: ROLLBACK TO Create_Planned_Task;
1005: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1006: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1007: THEN
1008: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1009: END IF;
1010: Fnd_Msg_Pub.count_and_get (
1011: p_encoded => Fnd_Api.g_false,
1012: p_count => x_msg_count,

Line 1010: Fnd_Msg_Pub.count_and_get (

1006: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1007: THEN
1008: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1009: END IF;
1010: Fnd_Msg_Pub.count_and_get (
1011: p_encoded => Fnd_Api.g_false,
1012: p_count => x_msg_count,
1013: p_data => x_msg_data
1014: );

Line 1144: Fnd_Msg_Pub.ADD;

1140: -- Done to allow creation of a task for an instance that has already been removed.
1141: /***
1142: IF AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, l_serial_id) = FND_API.G_RET_STS_ERROR THEN
1143: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');
1144: Fnd_Msg_Pub.ADD;
1145: RAISE Fnd_Api.G_EXC_ERROR;
1146: END IF;
1147: ***/
1148:

Line 1324: Fnd_Msg_Pub.initialize;

1320: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');
1321: END IF;
1322:
1323: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
1324: Fnd_Msg_Pub.initialize;
1325: END IF;
1326:
1327: -- Initialize API return status to success
1328: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 1379: Fnd_Msg_Pub.ADD;

1375:
1376: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS
1377: THEN
1378: Fnd_Message.SET_NAME('AHL','AHL_VWP_DEPT_NOT_EXISTS');
1379: Fnd_Msg_Pub.ADD;
1380: RAISE Fnd_Api.G_EXC_ERROR;
1381: END IF;
1382:
1383: --Assign the returned value

Line 1409: Fnd_Msg_Pub.ADD;

1405:
1406: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS
1407: THEN
1408: Fnd_Message.SET_NAME('AHL','AHL_VWP_PARENT_NOT_EXISTS');
1409: Fnd_Msg_Pub.ADD;
1410: RAISE Fnd_Api.g_exc_error;
1411: END IF;
1412:
1413: --Assign the returned value

Line 1470: Fnd_Msg_Pub.ADD;

1466:
1467: -- Check Object version number.
1468: IF (c_task_rec.object_version_number <> l_task_rec.object_version_number) THEN
1469: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1470: Fnd_Msg_Pub.ADD;
1471: RAISE Fnd_Api.g_exc_error;
1472: END IF;
1473:
1474: -- Post 11.5.10 Changes by Senthil.

Line 1490: l_msg_count := Fnd_Msg_Pub.count_msg;

1486:
1487: END IF;
1488:
1489: -- Standard check to count messages
1490: l_msg_count := Fnd_Msg_Pub.count_msg;
1491:
1492: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.g_ret_sts_success THEN
1493: X_msg_count := l_msg_count;
1494: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1583: l_msg_count := Fnd_Msg_Pub.count_msg;

1579: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TIMES_PVT.Adjust_Task_Times - l_return_status : '||l_return_status);
1580: END IF;
1581:
1582: --Standard check to count messages
1583: l_msg_count := Fnd_Msg_Pub.count_msg;
1584:
1585: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.g_ret_sts_success THEN
1586: x_msg_count := l_msg_count;
1587: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1643: l_msg_count := Fnd_Msg_Pub.count_msg;

1639: END IF;
1640: END IF;
1641:
1642: --Standard check to count messages
1643: l_msg_count := Fnd_Msg_Pub.count_msg;
1644:
1645: IF l_msg_count > 0 THEN
1646: X_msg_count := l_msg_count;
1647: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1664: Fnd_Msg_Pub.count_and_get (

1660: EXCEPTION
1661: WHEN Fnd_Api.g_exc_error THEN
1662: ROLLBACK TO Update_Planned_Task;
1663: x_return_status := Fnd_Api.g_ret_sts_error;
1664: Fnd_Msg_Pub.count_and_get (
1665: p_encoded => Fnd_Api.g_false,
1666: p_count => x_msg_count,
1667: p_data => x_msg_data
1668: );

Line 1672: Fnd_Msg_Pub.count_and_get (

1668: );
1669: WHEN Fnd_Api.g_exc_unexpected_error THEN
1670: ROLLBACK TO Update_Planned_Task;
1671: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1672: Fnd_Msg_Pub.count_and_get (
1673: p_encoded => Fnd_Api.g_false,
1674: p_count => x_msg_count,
1675: p_data => x_msg_data
1676: );

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

1676: );
1677: WHEN OTHERS THEN
1678: ROLLBACK TO Update_Planned_Task;
1679: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1680: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
1681: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1682: END IF;
1683: Fnd_Msg_Pub.count_and_get (
1684: p_encoded => Fnd_Api.g_false,

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

1677: WHEN OTHERS THEN
1678: ROLLBACK TO Update_Planned_Task;
1679: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1680: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
1681: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1682: END IF;
1683: Fnd_Msg_Pub.count_and_get (
1684: p_encoded => Fnd_Api.g_false,
1685: p_count => x_msg_count,

Line 1683: Fnd_Msg_Pub.count_and_get (

1679: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1680: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
1681: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1682: END IF;
1683: Fnd_Msg_Pub.count_and_get (
1684: p_encoded => Fnd_Api.g_false,
1685: p_count => x_msg_count,
1686: p_data => x_msg_data
1687: );

Line 1733: Fnd_Msg_Pub.initialize;

1729: fnd_log.string(fnd_log.level_procedure,l_debug||'.begin','At the start of PLSQL procedure');
1730: END IF;
1731:
1732: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
1733: Fnd_Msg_Pub.initialize;
1734: END IF;
1735:
1736: -- Initialize API return status to success
1737: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 1762: Fnd_Msg_Pub.ADD;

1758: IF c_Task%NOTFOUND THEN
1759: CLOSE c_Task;
1760: Fnd_Message.set_name('AHL', 'AHL_VWP_TASK_ID_INVALID');
1761: FND_MESSAGE.SET_TOKEN('TASK_ID',p_visit_task_id,false);
1762: Fnd_Msg_Pub.ADD;
1763: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1764: fnd_log.string(fnd_log.level_statement,l_debug,'Invalid Task Id' || p_visit_task_ID);
1765: END IF;
1766: RAISE Fnd_Api.g_exc_error;

Line 1797: Fnd_Msg_Pub.ADD;

1793: RAISE Fnd_Api.G_EXC_ERROR;
1794: END IF;
1795: ELSE
1796: Fnd_Message.SET_NAME('AHL','AHL_VWP_PLANNEDTASKMR');
1797: Fnd_Msg_Pub.ADD;
1798: RAISE Fnd_Api.G_EXC_ERROR;
1799: End IF;
1800: END IF;
1801: ------------------------End of API Body------------------------------------

Line 1806: Fnd_Msg_Pub.count_and_get (

1802: IF Fnd_Api.to_boolean (p_commit) THEN
1803: COMMIT;
1804: END IF;
1805:
1806: Fnd_Msg_Pub.count_and_get (
1807: p_encoded => Fnd_Api.g_false,
1808: p_count => x_msg_count,
1809: p_data => x_msg_data
1810: );

Line 1819: Fnd_Msg_Pub.count_and_get (

1815: EXCEPTION
1816: WHEN Fnd_Api.g_exc_error THEN
1817: ROLLBACK TO Delete_Planned_Task;
1818: x_return_status := Fnd_Api.g_ret_sts_error;
1819: Fnd_Msg_Pub.count_and_get (
1820: p_encoded => Fnd_Api.g_false,
1821: p_count => x_msg_count,
1822: p_data => x_msg_data
1823: );

Line 1828: Fnd_Msg_Pub.count_and_get (

1824:
1825: WHEN Fnd_Api.g_exc_unexpected_error THEN
1826: ROLLBACK TO Delete_Planned_Task;
1827: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1828: Fnd_Msg_Pub.count_and_get (
1829: p_encoded => Fnd_Api.g_false,
1830: p_count => x_msg_count,
1831: p_data => x_msg_data
1832: );

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

1833:
1834: WHEN OTHERS THEN
1835: ROLLBACK TO Delete_Planned_Task;
1836: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1837: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1838: THEN
1839: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1840: END IF;
1841: Fnd_Msg_Pub.count_and_get (

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

1835: ROLLBACK TO Delete_Planned_Task;
1836: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1837: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1838: THEN
1839: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1840: END IF;
1841: Fnd_Msg_Pub.count_and_get (
1842: p_encoded => Fnd_Api.g_false,
1843: p_count => x_msg_count,

Line 1841: Fnd_Msg_Pub.count_and_get (

1837: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1838: THEN
1839: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1840: END IF;
1841: Fnd_Msg_Pub.count_and_get (
1842: p_encoded => Fnd_Api.g_false,
1843: p_count => x_msg_count,
1844: p_data => x_msg_data
1845: );

Line 1939: Fnd_Msg_Pub.ADD;

1935: FETCH c_Visit_Task INTO l_task_rec;
1936: IF c_Visit_Task%NOTFOUND THEN
1937: CLOSE c_Visit_Task;
1938: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
1939: Fnd_Msg_Pub.ADD;
1940: RAISE Fnd_Api.g_exc_error;
1941: END IF;
1942: CLOSE c_Visit_Task;
1943:

Line 1974: Fnd_Msg_Pub.ADD;

1970:
1971: -- TASK NAME ==== NAME
1972: IF (p_task_rec.VISIT_TASK_NAME IS NULL OR p_Task_rec.VISIT_TASK_NAME = Fnd_Api.G_MISS_CHAR) THEN
1973: Fnd_Message.set_name ('AHL', 'AHL_VWP_NAME_MISSING');
1974: Fnd_Msg_Pub.ADD;
1975: x_return_status := Fnd_Api.g_ret_sts_error;
1976: RETURN;
1977: END IF;
1978:

Line 1986: Fnd_Msg_Pub.ADD;

1982:
1983: IF (p_task_rec.START_FROM_HOUR IS NOT NULL and p_Task_rec.START_FROM_HOUR <> Fnd_Api.G_MISS_NUM) THEN
1984: IF p_task_rec.START_FROM_HOUR < 0 OR FLOOR(p_task_rec.START_FROM_HOUR) <> p_task_rec.START_FROM_HOUR THEN
1985: Fnd_Message.set_name ('AHL', 'AHL_VWP_ONLY_POSITIVE_VALUE');
1986: Fnd_Msg_Pub.ADD;
1987: x_return_status := Fnd_Api.g_ret_sts_error;
1988: RETURN;
1989: END IF;
1990: END IF;

Line 2031: Fnd_Msg_Pub.ADD;

2027: 'Visit_Task_ID = ' || p_task_rec.Visit_Task_ID
2028: ) = Fnd_Api.g_false
2029: THEN
2030: Fnd_Message.set_name ('AHL', 'AHL_VWP_DUPLICATE_TASK_ID');
2031: Fnd_Msg_Pub.ADD;
2032: x_return_status := Fnd_Api.g_ret_sts_error;
2033: RETURN;
2034: END IF;
2035: END IF;