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_RSV_RESERVATIONS_PVT

Line 204: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(

200: -- End addition by surrkuma on 14-JUL-2010 for bug 9901811
201:
202: -- Serial Number reservation Enh.
203: -- When a Visit is unscheduled, all the reservations made for the Visit should also be deleted
204: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(
205: X_RETURN_STATUS => X_RETURN_STATUS,
206: P_VISIT_ID => p_visit_id);
207: IF (l_log_statement >= l_log_current_level)THEN
208: fnd_log.string(fnd_log.level_statement, L_DEBUG_KEY,

Line 209: ' After calling AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS. Error Message Status: ' || X_RETURN_STATUS);

205: X_RETURN_STATUS => X_RETURN_STATUS,
206: P_VISIT_ID => p_visit_id);
207: IF (l_log_statement >= l_log_current_level)THEN
208: fnd_log.string(fnd_log.level_statement, L_DEBUG_KEY,
209: ' After calling AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS. Error Message Status: ' || X_RETURN_STATUS);
210: END IF;
211:
212: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
213: RAISE Fnd_Api.g_exc_error;

Line 1011: AHL_RSV_RESERVATIONS_PVT.UPDATE_RESERVATION(

1007: RAISE FND_API.G_EXC_ERROR;
1008:
1009: END IF;
1010:
1011: AHL_RSV_RESERVATIONS_PVT.UPDATE_RESERVATION(
1012: P_API_VERSION => 1.0,
1013: /*P_INIT_MSG_LIST
1014: P_COMMIT
1015: P_VALIDATION_LEVEL */

Line 2834: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(

2830: CLOSE visit_mtrls_cur;
2831:
2832: -- Serial Number reservation Enh.
2833: -- delete all reservations for this visit on organization change
2834: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(
2835: X_RETURN_STATUS => X_RETURN_STATUS,
2836: P_VISIT_ID => p_visit_id);
2837:
2838: IF (l_log_statement >= l_log_current_level)THEN

Line 2843: ' After calling AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS ErrorMessage Status : ' || X_RETURN_STATUS

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:
2847: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 3022: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(

3018: CLOSE visit_mtrls_cur;
3019:
3020: -- Serial Number reservation Enh.
3021: -- Delete all the reservations for this visit
3022: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(
3023: X_RETURN_STATUS => X_RETURN_STATUS,
3024: P_VISIT_ID => p_visit_id);
3025:
3026: IF (l_log_statement >= l_log_current_level)THEN

Line 3031: ' After calling AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS ErrorMessage Status : ' || X_RETURN_STATUS

3027: fnd_log.string
3028: (
3029: l_log_statement,
3030: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3031: ' After calling AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS ErrorMessage Status : ' || X_RETURN_STATUS
3032: );
3033: END IF;
3034:
3035: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 3188: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(

3184: END IF;
3185:
3186: IF l_prev_org_id <> l_cur_org_id THEN
3187: -- delete all reservations for this visit on organization change
3188: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(
3189: X_RETURN_STATUS => X_RETURN_STATUS,
3190: P_VISIT_ID => p_visit_id);
3191:
3192: IF (l_log_statement >= l_log_current_level)THEN

Line 3197: 'After calling AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS:X_RETURN_STATUS '||X_RETURN_STATUS

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:
3201: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 3219: AHL_RSV_RESERVATIONS_PVT.Delete_Reservation(

3215: LOOP
3216: Fetch get_del_mtl_req_csr into l_scheduled_material_id;
3217: EXIT WHEN get_del_mtl_req_csr%NOTFOUND;
3218: -- Delete all the reservations made for this requirement
3219: AHL_RSV_RESERVATIONS_PVT.Delete_Reservation(
3220: p_module_type => NULL,
3221: x_return_status => l_return_status,
3222: x_msg_count => l_msg_count,
3223: x_msg_data => l_msg_data,

Line 3232: 'After calling AHL_RSV_RESERVATIONS_PVT.Delete_Reservation:l_return_status '||l_return_status

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;
3236: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 3244: AHL_RSV_RESERVATIONS_PVT.Update_Visit_Reservations(

3240: END LOOP; -- For all the material requirements of the deleted tasks
3241: CLOSE get_del_mtl_req_csr;
3242: -- Update all the reservations made for this visit with new requested date and scheduled material ID
3243:
3244: AHL_RSV_RESERVATIONS_PVT.Update_Visit_Reservations(
3245: X_RETURN_STATUS => x_return_status,
3246: P_VISIT_ID => p_visit_id);
3247:
3248: IF (l_log_statement >= l_log_current_level)THEN

Line 3253: 'After calling AHL_RSV_RESERVATIONS_PVT.Update_Visit_Reservations:x_return_status '||x_return_status

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:
3257: -- Return status check and throw exception if return status is not success;