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_LTP_REQST_MATRL_PVT dependencies on AHL_LTP_REQST_MATRL_PVT

Line 1: PACKAGE BODY AHL_LTP_REQST_MATRL_PVT AS

1: PACKAGE BODY AHL_LTP_REQST_MATRL_PVT AS
2: /* $Header: AHLVRMTB.pls 120.22 2008/03/20 10:30:07 rnahata ship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_REQST_MATRL_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

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

1: PACKAGE BODY AHL_LTP_REQST_MATRL_PVT AS
2: /* $Header: AHLVRMTB.pls 120.22 2008/03/20 10:30:07 rnahata ship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_REQST_MATRL_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6:
7: ------------------------------------
8: -- Common constants and variables --

Line 83: AHL_DEBUG_PUB.debug( 'enter AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');

79: AHL_DEBUG_PUB.enable_debug;
80: END IF;
81: -- Debug info.
82: IF G_DEBUG='Y' THEN
83: AHL_DEBUG_PUB.debug( 'enter AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');
84: END IF;
85: -- Standard call to check for call compatibility.
86: IF FND_API.to_boolean(p_init_msg_list)
87: THEN

Line 138: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',

134: IF (l_log_statement >= l_log_current_level)THEN
135: fnd_log.string
136: (
137: l_log_statement,
138: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',
139: ' After calling AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS ErrorMessage Status : ' || X_RETURN_STATUS
140: );
141: END IF;
142:

Line 160: AHL_DEBUG_PUB.debug( 'AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');

156: p_count => x_msg_count,
157: p_data => x_msg_data);
158: IF G_DEBUG='Y' THEN
159: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
160: AHL_DEBUG_PUB.debug( 'AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');
161: -- Check if API is called in debug mode. If yes, disable debug.
162: AHL_DEBUG_PUB.disable_debug;
163: END IF;
164: WHEN FND_API.G_EXC_ERROR THEN

Line 174: AHL_DEBUG_PUB.debug( 'AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');

170: IF G_DEBUG='Y' THEN
171: -- Debug info.
172: AHL_DEBUG_PUB.log_app_messages (
173: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
174: AHL_DEBUG_PUB.debug( 'AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');
175: -- Check if API is called in debug mode. If yes, disable debug.
176: AHL_DEBUG_PUB.disable_debug;
177: END IF;
178: WHEN OTHERS THEN

Line 183: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_REQST_MATRL_PVT',

179: ROLLBACK TO unschedule_visit;
180: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
182: THEN
183: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_REQST_MATRL_PVT',
184: p_procedure_name => 'Unschedule_Visit_Materials ',
185: p_error_text => SUBSTR(SQLERRM,1,240));
186: END IF;
187: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 354: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Insert_Planned_Matrls',

350: IF (l_log_procedure >= l_log_current_level)THEN
351: fnd_log.string
352: (
353: l_log_procedure,
354: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Insert_Planned_Matrls',
355: 'At the start of PLSQL procedure'
356: );
357: END IF;
358: -- Standard start of API savepoint

Line 681: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Insert Planned Matrls.end',

677: IF (l_log_procedure >= l_log_current_level)THEN
678: fnd_log.string
679: (
680: l_log_procedure,
681: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Insert Planned Matrls.end',
682: 'At the end of PLSQL procedure'
683: );
684: END IF;
685:

Line 809: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Update_Planned_Materials',

805: IF (l_log_procedure >= l_log_current_level)THEN
806: fnd_log.string
807: (
808: l_log_procedure,
809: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Update_Planned_Materials',
810: 'At the start of PLSQL procedure'
811: );
812: END IF;
813: -- Standard start of API savepoint

Line 1064: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Update Planned Materials.end',

1060: IF (l_log_procedure >= l_log_current_level)THEN
1061: fnd_log.string
1062: (
1063: l_log_procedure,
1064: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Update Planned Materials.end',
1065: 'At the end of PLSQL procedure'
1066: );
1067: END IF;
1068: EXCEPTION

Line 1191: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',

1187: IF (l_log_procedure >= l_log_current_level)THEN
1188: fnd_log.string
1189: (
1190: l_log_procedure,
1191: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1192: 'At the start of PLSQL procedure'
1193: );
1194: END IF;
1195: -- Standard start of API savepoint

Line 1224: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',

1220: IF (l_log_statement >= l_log_current_level)THEN
1221: fnd_log.string
1222: (
1223: l_log_statement,
1224: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1225: ' Visit Id: ' || p_visit_id
1226: );
1227: fnd_log.string
1228: (

Line 1230: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',

1226: );
1227: fnd_log.string
1228: (
1229: l_log_statement,
1230: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1231: ' Organization Id: ' || l_visit_tasks_rec.organization_id
1232: );
1233:
1234: END IF;

Line 1250: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',

1246: IF (l_log_statement >= l_log_current_level)THEN
1247: fnd_log.string
1248: (
1249: l_log_statement,
1250: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1251: ' Visit Task Id: ' || l_visit_tasks_rec.visit_task_id
1252: );
1253: fnd_log.string
1254: (

Line 1256: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',

1252: );
1253: fnd_log.string
1254: (
1255: l_log_statement,
1256: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1257: ' Task Start Time: ' || l_visit_tasks_rec.start_date_time
1258: );
1259: fnd_log.string
1260: (

Line 1262: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',

1258: );
1259: fnd_log.string
1260: (
1261: l_log_statement,
1262: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1263: ' Mr Route Id: ' || l_visit_tasks_rec.mr_route_id
1264: );
1265:
1266: END IF;

Line 1288: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',

1284: IF (l_log_statement >= l_log_current_level)THEN
1285: fnd_log.string
1286: (
1287: l_log_statement,
1288: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1289: ' Before Calling Get Route Mtl Req, Route Id: ' || l_route_id
1290: );
1291: fnd_log.string
1292: (

Line 1294: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',

1290: );
1291: fnd_log.string
1292: (
1293: l_log_statement,
1294: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1295: ' Before Calling Get Route Mtl Req, Instance Id: ' || l_instance_id
1296: );
1297:
1298: END IF;

Line 1345: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',

1341: IF (l_log_statement >= l_log_current_level)THEN
1342: fnd_log.string
1343: (
1344: l_log_statement,
1345: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1346: ' After Calling Get Route Mtl Req, l_route_mtl_req_tbl COUNT: ' || l_route_mtl_req_tbl.COUNT
1347: );
1348:
1349: END IF;

Line 1405: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create Task Materials.end',

1401: IF (l_log_procedure >= l_log_current_level)THEN
1402: fnd_log.string
1403: (
1404: l_log_procedure,
1405: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create Task Materials.end',
1406: 'At the end of PLSQL procedure'
1407: );
1408: END IF;
1409: EXCEPTION

Line 1583: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Task_Matrls',

1579: IF (l_log_procedure >= l_log_current_level)THEN
1580: fnd_log.string
1581: (
1582: l_log_procedure,
1583: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Task_Matrls',
1584: 'At the start of PLSQL procedure'
1585: );
1586: END IF;
1587: -- Standard start of API savepoint

Line 1620: 'AHL.PLSQL.AHL_LTP_REQST_MATRL_PVT.MODIFY_VISIT_TASK_MATRLS',

1616: IF (l_log_procedure >= l_log_current_level)THEN
1617: fnd_log.string
1618: (
1619: l_log_procedure,
1620: 'AHL.PLSQL.AHL_LTP_REQST_MATRL_PVT.MODIFY_VISIT_TASK_MATRLS',
1621: 'Updating the status to DELETED for Material Requirement' || l_Deleted_Items_Rec.scheduled_material_id
1622: );
1623: END IF;
1624:

Line 1680: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',

1676: IF (l_log_statement >= l_log_current_level)THEN
1677: fnd_log.string
1678: (
1679: l_log_statement,
1680: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',
1681: ' After Calling Derive task times, l_Visit_Task_Route_Tbl.COUNT: ' || l_Visit_Task_Route_Tbl.COUNT
1682: );
1683:
1684: END IF;

Line 1694: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',

1690: IF (l_log_statement >= l_log_current_level)THEN
1691: fnd_log.string
1692: (
1693: l_log_statement,
1694: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',
1695: ' Before Calling Get Route Mtl Req, Route Id: ' || l_Visit_Task_Route_Tbl(i).route_id
1696: );
1697: fnd_log.string
1698: (

Line 1700: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',

1696: );
1697: fnd_log.string
1698: (
1699: l_log_statement,
1700: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',
1701: ' Before Calling Get Route Mtl Req, Instance Id: ' || l_Visit_Task_Route_Tbl(i).instance_id
1702: );
1703: fnd_log.string
1704: (

Line 1706: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',

1702: );
1703: fnd_log.string
1704: (
1705: l_log_statement,
1706: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',
1707: ' Before Calling Get Route Mtl Req, Task Start Time: ' || l_Visit_Task_Route_Tbl(i).task_start_date
1708: );
1709:
1710: END IF;

Line 1765: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',

1761: IF (l_log_statement >= l_log_current_level)THEN
1762: fnd_log.string
1763: (
1764: l_log_statement,
1765: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',
1766: ' After Calling Get Route Mtl Req, l_route_mtl_req_tbl COUNT: ' || l_route_mtl_req_tbl.COUNT
1767: );
1768:
1769: END IF;

Line 1796: 'AHL.PLSQL.AHL_LTP_REQST_MATRL_PVT.MODIFY_VISIT_TASK_MATRLS',

1792: IF (l_log_procedure >= l_log_current_level)THEN
1793: fnd_log.string
1794: (
1795: l_log_procedure,
1796: 'AHL.PLSQL.AHL_LTP_REQST_MATRL_PVT.MODIFY_VISIT_TASK_MATRLS',
1797: 'Updating the status to DELETED for Material Requirement' || l_Planned_Items_Rec.scheduled_material_id
1798: );
1799: END IF;
1800:

Line 1902: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify Visit Task Matrls.end',

1898: IF (l_log_procedure >= l_log_current_level)THEN
1899: fnd_log.string
1900: (
1901: l_log_procedure,
1902: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify Visit Task Matrls.end',
1903: 'At the end of PLSQL procedure'
1904: );
1905: END IF;
1906: EXCEPTION

Line 2019: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_reqst_matrl_pvt Unchedule Task Items ','+MAATP+');

2015: AHL_DEBUG_PUB.enable_debug;
2016: END IF;
2017: -- Debug info.
2018: IF G_DEBUG='Y' THEN
2019: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_reqst_matrl_pvt Unchedule Task Items ','+MAATP+');
2020: END IF;
2021: -- Standard call to check for call compatibility.
2022: IF FND_API.to_boolean(p_init_msg_list)
2023: THEN

Line 2096: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items ','+MAMRP+');

2092: IF G_DEBUG='Y' THEN
2093:
2094: AHL_DEBUG_PUB.log_app_messages (
2095: x_msg_count, x_msg_data, 'ERROR' );
2096: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items ','+MAMRP+');
2097: -- Check if API is called in debug mode. If yes, disable debug.
2098: AHL_DEBUG_PUB.disable_debug;
2099: END IF;
2100:

Line 2112: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MAMRP+');

2108:
2109: -- Debug info.
2110: AHL_DEBUG_PUB.log_app_messages (
2111: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2112: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MAMRP+');
2113: -- Check if API is called in debug mode. If yes, disable debug.
2114: AHL_DEBUG_PUB.disable_debug;
2115: END IF;
2116:

Line 2122: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_REQST_MATRL_PVT',

2118: ROLLBACK TO Unschedule_Task_Items;
2119: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2120: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2121: THEN
2122: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_REQST_MATRL_PVT',
2123: p_procedure_name => 'UNSCHEDULE_TASK_ITEMS',
2124: p_error_text => SUBSTR(SQLERRM,1,240));
2125: END IF;
2126: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2134: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MTMRP+');

2130:
2131: -- Debug info.
2132: AHL_DEBUG_PUB.log_app_messages (
2133: x_msg_count, x_msg_data, 'SQL ERROR' );
2134: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MTMRP+');
2135: -- Check if API is called in debug mode. If yes, disable debug.
2136: AHL_DEBUG_PUB.disable_debug;
2137: END IF;
2138:

Line 2205: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials',

2201: IF (l_log_procedure >= l_log_current_level)THEN
2202: fnd_log.string
2203: (
2204: l_log_procedure,
2205: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials',
2206: 'At the start of PLSQL procedure'
2207: );
2208: END IF;
2209:

Line 2556: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Process Planned Materials.end',

2552: IF (l_log_procedure >= l_log_current_level)THEN
2553: fnd_log.string
2554: (
2555: l_log_procedure,
2556: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Process Planned Materials.end',
2557: 'At the end of PLSQL procedure'
2558: );
2559: END IF;
2560: EXCEPTION

Line 2684: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',

2680: IF (l_log_procedure >= l_log_current_level)THEN
2681: fnd_log.string
2682: (
2683: l_log_procedure,
2684: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',
2685: 'At the start of PLSQL procedure'
2686: );
2687: END IF;
2688: -- Standard start of API savepoint

Line 2722: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',

2718: IF (l_log_statement >= l_log_current_level)THEN
2719: fnd_log.string
2720: (
2721: l_log_statement,
2722: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',
2723: ' After visit task details cur, Visit Id: ' || l_visit_id
2724: );
2725: END IF;
2726:

Line 2734: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',

2730: IF (l_log_statement >= l_log_current_level)THEN
2731: fnd_log.string
2732: (
2733: l_log_statement,
2734: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',
2735: ' Before Retrieving task materials cur, Visit Task Id: ' || l_visit_task_id
2736: );
2737: END IF;
2738: --Retrieve task materials only

Line 2758: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',

2754: IF (l_log_statement >= l_log_current_level)THEN
2755: fnd_log.string
2756: (
2757: l_log_statement,
2758: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',
2759: ' Before Retrieving all visit task materials cur, For Visit Id: ' || l_visit_id
2760: );
2761: END IF;
2762:

Line 2789: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',

2785: IF (l_log_statement >= l_log_current_level)THEN
2786: fnd_log.string
2787: (
2788: l_log_statement,
2789: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',
2790: ' After calling AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS ErrorMessage Status : ' || X_RETURN_STATUS
2791: );
2792: END IF;
2793:

Line 2819: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove Visit Task Matrls.end',

2815: IF (l_log_procedure >= l_log_current_level)THEN
2816: fnd_log.string
2817: (
2818: l_log_procedure,
2819: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove Visit Task Matrls.end',
2820: 'At the end of PLSQL procedure'
2821: );
2822: END IF;
2823: EXCEPTION

Line 2913: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Update_Unplanned_Matrls',

2909: IF (l_log_procedure >= l_log_current_level)THEN
2910: fnd_log.string
2911: (
2912: l_log_procedure,
2913: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Update_Unplanned_Matrls',
2914: 'At the start of PLSQL procedure'
2915: );
2916: END IF;
2917:

Line 2961: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',

2957: IF (l_log_statement >= l_log_current_level)THEN
2958: fnd_log.string
2959: (
2960: l_log_statement,
2961: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',
2962: ' After calling AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS ErrorMessage Status : ' || X_RETURN_STATUS
2963: );
2964: END IF;
2965:

Line 2979: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Update Unplanned Matrls.end',

2975: IF (l_log_procedure >= l_log_current_level)THEN
2976: fnd_log.string
2977: (
2978: l_log_procedure,
2979: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Update Unplanned Matrls.end',
2980: 'At the end of PLSQL procedure'
2981: );
2982: END IF;
2983: EXCEPTION

Line 3075: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations.Start',

3071: IF (l_log_procedure >= l_log_current_level)THEN
3072: fnd_log.string
3073: (
3074: l_log_procedure,
3075: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations.Start',
3076: 'At the end of PLSQL procedure'
3077: );
3078: END IF;
3079:

Line 3102: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',

3098: IF (l_log_statement >= l_log_current_level)THEN
3099: fnd_log.string
3100: (
3101: l_log_statement,
3102: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',
3103: 'l_org_count : '||l_org_count||' l_cur_org_id:'||l_cur_org_id||
3104: ' l_prev_org_id:'||l_prev_org_id
3105: );
3106: END IF;

Line 3127: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',

3123: IF (l_log_statement >= l_log_current_level)THEN
3124: fnd_log.string
3125: (
3126: l_log_statement,
3127: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',
3128: 'After calling AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS:X_RETURN_STATUS '||X_RETURN_STATUS
3129: );
3130: END IF;
3131:

Line 3140: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',

3136: IF (l_log_statement >= l_log_current_level)THEN
3137: fnd_log.string
3138: (
3139: l_log_statement,
3140: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',
3141: 'In the else part of check l_prev_org_id <> l_cur_org_id'
3142: );
3143: END IF;
3144: -- Get all the material requirements with reservation created for deleted tasks

Line 3162: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',

3158: IF (l_log_statement >= l_log_current_level)THEN
3159: fnd_log.string
3160: (
3161: l_log_statement,
3162: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',
3163: 'After calling AHL_RSV_RESERVATIONS_PVT.Delete_Reservation:l_return_status '||l_return_status
3164: );
3165: END IF;
3166: -- Return status check and throw exception if return status is not success;

Line 3183: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',

3179: IF (l_log_statement >= l_log_current_level)THEN
3180: fnd_log.string
3181: (
3182: l_log_statement,
3183: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',
3184: 'After calling AHL_RSV_RESERVATIONS_PVT.Update_Visit_Reservations:x_return_status '||x_return_status
3185: );
3186: END IF;
3187:

Line 3198: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations.end',

3194: IF (l_log_procedure >= l_log_current_level)THEN
3195: fnd_log.string
3196: (
3197: l_log_procedure,
3198: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations.end',
3199: 'At the end of PLSQL procedure'
3200: );
3201: END IF;
3202: END Modify_Visit_Reservations;

Line 3317: END AHL_LTP_REQST_MATRL_PVT;

3313: p_count => x_msg_count,
3314: p_data => x_msg_data );
3315: END Update_Material_Reqrs_status;
3316:
3317: END AHL_LTP_REQST_MATRL_PVT;