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 131: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(

127: CLOSE c_sch_mat_cur;
128:
129: -- Serial Number reservation Enh.
130: -- When a Visit is unscheduled, all the reservations made for the Visit should also be deleted
131: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(
132: X_RETURN_STATUS => X_RETURN_STATUS,
133: P_VISIT_ID => p_visit_id);
134: IF (l_log_statement >= l_log_current_level)THEN
135: fnd_log.string

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

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

Line 1000: AHL_RSV_RESERVATIONS_PVT.UPDATE_RESERVATION(

996: RAISE FND_API.G_EXC_ERROR;
997:
998: END IF;
999:
1000: AHL_RSV_RESERVATIONS_PVT.UPDATE_RESERVATION(
1001: P_API_VERSION => 1.0,
1002: /*P_INIT_MSG_LIST
1003: P_COMMIT
1004: P_VALIDATION_LEVEL */

Line 2781: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(

2777: CLOSE visit_mtrls_cur;
2778:
2779: -- Serial Number reservation Enh.
2780: -- delete all reservations for this visit on organization change
2781: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(
2782: X_RETURN_STATUS => X_RETURN_STATUS,
2783: P_VISIT_ID => p_visit_id);
2784:
2785: IF (l_log_statement >= l_log_current_level)THEN

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

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

Line 2953: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(

2949: CLOSE visit_mtrls_cur;
2950:
2951: -- Serial Number reservation Enh.
2952: -- Delete all the reservations for this visit
2953: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(
2954: X_RETURN_STATUS => X_RETURN_STATUS,
2955: P_VISIT_ID => p_visit_id);
2956:
2957: IF (l_log_statement >= l_log_current_level)THEN

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

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

Line 3119: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(

3115: END IF;
3116:
3117: IF l_prev_org_id <> l_cur_org_id THEN
3118: -- delete all reservations for this visit on organization change
3119: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(
3120: X_RETURN_STATUS => X_RETURN_STATUS,
3121: P_VISIT_ID => p_visit_id);
3122:
3123: IF (l_log_statement >= l_log_current_level)THEN

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

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

Line 3150: AHL_RSV_RESERVATIONS_PVT.Delete_Reservation(

3146: LOOP
3147: Fetch get_del_mtl_req_csr into l_scheduled_material_id;
3148: EXIT WHEN get_del_mtl_req_csr%NOTFOUND;
3149: -- Delete all the reservations made for this requirement
3150: AHL_RSV_RESERVATIONS_PVT.Delete_Reservation(
3151: p_module_type => NULL,
3152: x_return_status => l_return_status,
3153: x_msg_count => l_msg_count,
3154: x_msg_data => l_msg_data,

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

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

Line 3175: AHL_RSV_RESERVATIONS_PVT.Update_Visit_Reservations(

3171: END LOOP; -- For all the material requirements of the deleted tasks
3172: CLOSE get_del_mtl_req_csr;
3173: -- Update all the reservations made for this visit with new requested date and scheduled material ID
3174:
3175: AHL_RSV_RESERVATIONS_PVT.Update_Visit_Reservations(
3176: X_RETURN_STATUS => x_return_status,
3177: P_VISIT_ID => p_visit_id);
3178:
3179: IF (l_log_statement >= l_log_current_level)THEN

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

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