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.27.12020000.2 2012/12/07 13:37:52 sareepar 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.27.12020000.2 2012/12/07 13:37:52 sareepar 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 243: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_REQST_MATRL_PVT',

239: ROLLBACK TO unschedule_visit;
240: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
242: THEN
243: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_REQST_MATRL_PVT',
244: p_procedure_name => 'Unschedule_Visit_Materials ',
245: p_error_text => SUBSTR(SQLERRM,1,240));
246: END IF;
247: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1198: IF (l_log_procedure >= l_log_current_level)THEN
1199: fnd_log.string
1200: (
1201: l_log_procedure,
1202: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1203: 'At the start of PLSQL procedure'
1204: );
1205: END IF;
1206: -- Standard start of API savepoint

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

1231: IF (l_log_statement >= l_log_current_level)THEN
1232: fnd_log.string
1233: (
1234: l_log_statement,
1235: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1236: ' Visit Id: ' || p_visit_id
1237: );
1238: fnd_log.string
1239: (

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

1237: );
1238: fnd_log.string
1239: (
1240: l_log_statement,
1241: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1242: ' Organization Id: ' || l_visit_tasks_rec.organization_id
1243: );
1244:
1245: END IF;

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

1257: IF (l_log_statement >= l_log_current_level)THEN
1258: fnd_log.string
1259: (
1260: l_log_statement,
1261: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1262: ' Visit Task Id: ' || l_visit_tasks_rec.visit_task_id
1263: );
1264: fnd_log.string
1265: (

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

1263: );
1264: fnd_log.string
1265: (
1266: l_log_statement,
1267: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1268: ' Task Start Time: ' || l_visit_tasks_rec.start_date_time
1269: );
1270: fnd_log.string
1271: (

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

1269: );
1270: fnd_log.string
1271: (
1272: l_log_statement,
1273: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1274: ' Mr Route Id: ' || l_visit_tasks_rec.mr_route_id
1275: );
1276:
1277: END IF;

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

1295: IF (l_log_statement >= l_log_current_level)THEN
1296: fnd_log.string
1297: (
1298: l_log_statement,
1299: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1300: ' Before Calling Get Route Mtl Req, Route Id: ' || l_route_id
1301: );
1302: fnd_log.string
1303: (

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

1301: );
1302: fnd_log.string
1303: (
1304: l_log_statement,
1305: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1306: ' Before Calling Get Route Mtl Req, Instance Id: ' || l_instance_id
1307: );
1308:
1309: END IF;

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

1353: IF (l_log_statement >= l_log_current_level)THEN
1354: fnd_log.string
1355: (
1356: l_log_statement,
1357: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1358: ' After Calling Get Route Mtl Req, l_route_mtl_req_tbl COUNT: ' || l_route_mtl_req_tbl.COUNT
1359: );
1360:
1361: END IF;

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

1417: IF (l_log_procedure >= l_log_current_level)THEN
1418: fnd_log.string
1419: (
1420: l_log_procedure,
1421: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create Task Materials.end',
1422: 'At the end of PLSQL procedure'
1423: );
1424: END IF;
1425: EXCEPTION

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

2162: AHL_DEBUG_PUB.enable_debug;
2163: END IF;
2164: -- Debug info.
2165: IF G_DEBUG='Y' THEN
2166: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_reqst_matrl_pvt Unchedule Task Items ','+MAATP+');
2167: END IF;
2168: -- Standard call to check for call compatibility.
2169: IF FND_API.to_boolean(p_init_msg_list)
2170: THEN

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

2239: IF G_DEBUG='Y' THEN
2240:
2241: AHL_DEBUG_PUB.log_app_messages (
2242: x_msg_count, x_msg_data, 'ERROR' );
2243: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items ','+MAMRP+');
2244: -- Check if API is called in debug mode. If yes, disable debug.
2245: AHL_DEBUG_PUB.disable_debug;
2246: END IF;
2247:

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

2255:
2256: -- Debug info.
2257: AHL_DEBUG_PUB.log_app_messages (
2258: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2259: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MAMRP+');
2260: -- Check if API is called in debug mode. If yes, disable debug.
2261: AHL_DEBUG_PUB.disable_debug;
2262: END IF;
2263:

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

2265: ROLLBACK TO Unschedule_Task_Items;
2266: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2267: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2268: THEN
2269: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_REQST_MATRL_PVT',
2270: p_procedure_name => 'UNSCHEDULE_TASK_ITEMS',
2271: p_error_text => SUBSTR(SQLERRM,1,240));
2272: END IF;
2273: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

2277:
2278: -- Debug info.
2279: AHL_DEBUG_PUB.log_app_messages (
2280: x_msg_count, x_msg_data, 'SQL ERROR' );
2281: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MTMRP+');
2282: -- Check if API is called in debug mode. If yes, disable debug.
2283: AHL_DEBUG_PUB.disable_debug;
2284: END IF;
2285:

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

2838: IF (l_log_statement >= l_log_current_level)THEN
2839: fnd_log.string
2840: (
2841: l_log_statement,
2842: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',
2843: ' After calling AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS ErrorMessage Status : ' || X_RETURN_STATUS
2844: );
2845: END IF;
2846:

Line 2982: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Update_Unplanned_Matrls' || '.begin',

2978: IF (l_log_procedure >= l_log_current_level)THEN
2979: fnd_log.string
2980: (
2981: l_log_procedure,
2982: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Update_Unplanned_Matrls' || '.begin',
2983: 'At the start of PLSQL procedure'
2984: );
2985: END IF;
2986:

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

3044: IF (l_log_procedure >= l_log_current_level)THEN
3045: fnd_log.string
3046: (
3047: l_log_procedure,
3048: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Update Unplanned Matrls.end',
3049: 'At the end of PLSQL procedure'
3050: );
3051: END IF;
3052: EXCEPTION

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

3140: IF (l_log_procedure >= l_log_current_level)THEN
3141: fnd_log.string
3142: (
3143: l_log_procedure,
3144: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations.Start',
3145: 'At the end of PLSQL procedure'
3146: );
3147: END IF;
3148:

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

3167: IF (l_log_statement >= l_log_current_level)THEN
3168: fnd_log.string
3169: (
3170: l_log_statement,
3171: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',
3172: 'l_org_count : '||l_org_count||' l_cur_org_id:'||l_cur_org_id||
3173: ' l_prev_org_id:'||l_prev_org_id
3174: );
3175: END IF;

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

3192: IF (l_log_statement >= l_log_current_level)THEN
3193: fnd_log.string
3194: (
3195: l_log_statement,
3196: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',
3197: 'After calling AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS:X_RETURN_STATUS '||X_RETURN_STATUS
3198: );
3199: END IF;
3200:

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

3205: IF (l_log_statement >= l_log_current_level)THEN
3206: fnd_log.string
3207: (
3208: l_log_statement,
3209: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',
3210: 'In the else part of check l_prev_org_id <> l_cur_org_id'
3211: );
3212: END IF;
3213: -- Get all the material requirements with reservation created for deleted tasks

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

3227: IF (l_log_statement >= l_log_current_level)THEN
3228: fnd_log.string
3229: (
3230: l_log_statement,
3231: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',
3232: 'After calling AHL_RSV_RESERVATIONS_PVT.Delete_Reservation:l_return_status '||l_return_status
3233: );
3234: END IF;
3235: -- Return status check and throw exception if return status is not success;

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

3248: IF (l_log_statement >= l_log_current_level)THEN
3249: fnd_log.string
3250: (
3251: l_log_statement,
3252: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',
3253: 'After calling AHL_RSV_RESERVATIONS_PVT.Update_Visit_Reservations:x_return_status '||x_return_status
3254: );
3255: END IF;
3256:

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

3263: IF (l_log_procedure >= l_log_current_level)THEN
3264: fnd_log.string
3265: (
3266: l_log_procedure,
3267: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations.end',
3268: 'At the end of PLSQL procedure'
3269: );
3270: END IF;
3271: END Modify_Visit_Reservations;

Line 3530: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Associate_Stage_Materials';

3526: l_return_status VARCHAR2(1);
3527: l_init_msg_list VARCHAR2(10):= p_init_msg_list;
3528: l_commit VARCHAR2(30) := p_commit;
3529: l_prim_quantity NUMBER;
3530: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Associate_Stage_Materials';
3531: l_nrp_mat_req_tbl AHL_RA_NR_PROFILE_PVT.nrp_mat_req_tbl_type;
3532: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
3533: l_requested_date DATE;
3534: l_workorder_id NUMBER;

Line 3841: 'After calling AHL_LTP_REQST_MATRL_PVT.Insert_Planned_Matrls. l_return_status = ' || l_return_status);

3837:
3838: IF (l_log_statement >= l_log_current_level) THEN
3839: fnd_log.string(l_log_statement,
3840: L_DEBUG_KEY,
3841: 'After calling AHL_LTP_REQST_MATRL_PVT.Insert_Planned_Matrls. l_return_status = ' || l_return_status);
3842: END IF;
3843:
3844: -- Check Error Message stack.
3845: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 3916: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Associate_Stage_Materials.end',

3912: IF (fnd_log.level_procedure >= l_log_current_level)THEN
3913: fnd_log.string
3914: (
3915: fnd_log.level_procedure,
3916: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Associate_Stage_Materials.end',
3917: 'At the end of PLSQL procedure'
3918: );
3919: END IF;
3920:

Line 4007: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Stage_Materials';

4003: l_requested_quantity NUMBER;
4004: l_uom_code VARCHAR2(30);
4005: l_prim_req_quantity NUMBER;
4006: l_prim_sch_quantity NUMBER;
4007: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Stage_Materials';
4008: l_nrp_mat_req_tbl AHL_RA_NR_PROFILE_PVT.nrp_mat_req_tbl_type;
4009: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4010: l_requested_date DATE;
4011: l_workorder_id NUMBER;

Line 4283: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Stage_Materials.end',

4279: IF (fnd_log.level_procedure >= l_log_current_level)THEN
4280: fnd_log.string
4281: (
4282: fnd_log.level_procedure,
4283: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Stage_Materials.end',
4284: 'At the end of PLSQL procedure'
4285: );
4286: END IF;
4287:

Line 4364: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Delete_Default_Stage_Materials';

4360: l_msg_data VARCHAR2(2000);
4361: l_return_status VARCHAR2(1);
4362: l_init_msg_list VARCHAR2(10):= p_init_msg_list;
4363: l_commit VARCHAR2(30) := p_commit;
4364: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Delete_Default_Stage_Materials';
4365: l_requested_date DATE;
4366: l_workorder_id NUMBER;
4367: l_operation_sequence NUMBER;
4368: l_workorder_operation_id NUMBER;

Line 4568: END AHL_LTP_REQST_MATRL_PVT;

4564: END Delete_Default_Stage_Materials;
4565:
4566: -- TCHIMIRA :: 22-JUN-2011 :: VWPE: ER:12673125 :: END
4567:
4568: END AHL_LTP_REQST_MATRL_PVT;