APPS.AHL_LTP_MATRL_AVAL_PVT dependencies on AHL_LTP_MATRL_AVAL_PVT

Line 1: PACKAGE BODY AHL_LTP_MATRL_AVAL_PVT AS

1: PACKAGE BODY AHL_LTP_MATRL_AVAL_PVT AS
2: /* $Header: AHLVMTAB.pls 120.7 2008/02/25 11:31:38 rnahata ship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_MATRL_AVAL_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

Line 4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_MATRL_AVAL_PVT';

1: PACKAGE BODY AHL_LTP_MATRL_AVAL_PVT AS
2: /* $Header: AHLVMTAB.pls 120.7 2008/02/25 11:31:38 rnahata ship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_MATRL_AVAL_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: ------------------------------------
7: -- Common constants and variables --
8: ------------------------------------

Line 17: -- AHL_LTP_MATRL_AVAL_PVT

13: l_log_unexpected NUMBER := fnd_log.level_unexpected;
14: -----------------------------------------------------------------------
15: --
16: -- PACKAGE
17: -- AHL_LTP_MATRL_AVAL_PVT
18: --
19: -- PURPOSE
20: -- This package is used to derive requested materials for an item which is associated
21: -- to visit task. It calls ATP to check material availabilty

Line 380: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',

376: ROLLBACK TO check_availability;
377: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
379: THEN
380: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
381: p_procedure_name => 'CHECK_AVAILABILITY',
382: p_error_text => SUBSTR(SQLERRM,1,240));
383: END IF;
384: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 651: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',

647: ROLLBACK TO check_material_aval;
648: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
652: p_procedure_name => 'CHECK_MATERIAL_AVAL',
653: p_error_text => SUBSTR(SQLERRM,1,240));
654: END IF;
655: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 814: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',

810: ROLLBACK TO Get_Visit_Task_Materials;
811: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
813: THEN
814: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
815: p_procedure_name => 'GET_VISIT_TASK_MATERIALS',
816: p_error_text => SUBSTR(SQLERRM,1,240));
817: END IF;
818: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1293: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',

1289: ROLLBACK TO Call_ATP;
1290: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1292: THEN
1293: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1294: p_procedure_name => 'CALL_ATP',
1295: p_error_text => SUBSTR(SQLERRM,1,240));
1296: END IF;
1297: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1561: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',

1557: ROLLBACK TO Schedule_Planned_Matrls;
1558: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1560: THEN
1561: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1562: p_procedure_name => 'SCHEDULE_PLANNED_MATRLS',
1563: p_error_text => SUBSTR(SQLERRM,1,240));
1564: END IF;
1565: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',

1778: ROLLBACK TO Schedule_All_Materials;
1779: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1781: THEN
1782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1783: p_procedure_name => 'SCHEDULE_ALL_MATERIALS',
1784: p_error_text => SUBSTR(SQLERRM,1,240));
1785: END IF;
1786: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1792: END AHL_LTP_MATRL_AVAL_PVT;

1788: p_data => l_msg_data);
1789:
1790: END Schedule_All_Materials;
1791:
1792: END AHL_LTP_MATRL_AVAL_PVT;