DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PVT dependencies on INV_RSV_SYNCH

Line 1298: inv_rsv_synch.for_update(

1294: ,reservation_quantity = l_new_rsv_quantity
1295: ,secondary_reservation_quantity = l_new_sec_rsv_quantity
1296: WHERE reservation_id = l_org_wide_res_id;
1297:
1298: inv_rsv_synch.for_update(
1299: p_reservation_id => l_org_wide_res_id
1300: , x_return_status => l_api_return_status
1301: , x_msg_count => x_msg_count
1302: , x_msg_data => x_msg_data);

Line 1306: print_debug('Error from inv_rsv_synch.for_update', 'Inv_Pick_Release_PVT.Process_Reservations');

1302: , x_msg_data => x_msg_data);
1303:
1304: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1305: IF (is_debug) THEN
1306: print_debug('Error from inv_rsv_synch.for_update', 'Inv_Pick_Release_PVT.Process_Reservations');
1307: END IF;
1308: RAISE fnd_api.g_exc_error;
1309: END IF;
1310: --

Line 1313: print_debug('Unexp. error from inv_rsv_synch.for_update', 'Inv_Pick_Release_PVT.Process_Reservations');

1309: END IF;
1310: --
1311: IF l_api_return_status = fnd_api.g_ret_sts_unexp_error THEN
1312: IF (is_debug) THEN
1313: print_debug('Unexp. error from inv_rsv_synch.for_update', 'Inv_Pick_Release_PVT.Process_Reservations');
1314: END IF;
1315: RAISE fnd_api.g_exc_unexpected_error;
1316: END IF;
1317:

Line 3135: inv_rsv_synch.for_update(

3131: ,reservation_quantity = l_new_rsv_quantity
3132: ,secondary_reservation_quantity = l_new_sec_rsv_quantity -- Bug 6989438
3133: WHERE reservation_id = l_reservation_id;
3134:
3135: inv_rsv_synch.for_update(
3136: p_reservation_id => l_reservation_id
3137: , x_return_status => l_api_return_status
3138: , x_msg_count => x_msg_count
3139: , x_msg_data => x_msg_data);

Line 3143: print_debug('Error from inv_rsv_synch.for_update','Inv_Pick_Release_PVT.Process_Reservations');

3139: , x_msg_data => x_msg_data);
3140:
3141: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
3142: IF (is_debug) THEN
3143: print_debug('Error from inv_rsv_synch.for_update','Inv_Pick_Release_PVT.Process_Reservations');
3144: END IF;
3145: RAISE fnd_api.g_exc_error;
3146: END IF;
3147: --

Line 3150: print_debug('Unexp. error from inv_rsv_synch.for_update','Inv_Pick_Release_PVT.Process_Reservations');

3146: END IF;
3147: --
3148: IF l_api_return_status = fnd_api.g_ret_sts_unexp_error THEN
3149: IF (is_debug) THEN
3150: print_debug('Unexp. error from inv_rsv_synch.for_update','Inv_Pick_Release_PVT.Process_Reservations');
3151: END IF;
3152: RAISE fnd_api.g_exc_unexpected_error;
3153: END IF;
3154:

Line 3304: /* inv_rsv_synch.for_update(

3300: fnd_msg_pub.ADD;
3301: RAISE fnd_api.g_exc_unexpected_error;
3302: END IF;
3303:
3304: /* inv_rsv_synch.for_update(
3305: p_reservation_id => l_demand_rsvs_ordered(l_res_ordered_index).reservation_id
3306: , x_return_status => l_api_return_status
3307: , x_msg_count => x_msg_count
3308: , x_msg_data => x_msg_data);

Line 3312: print_debug('Error from inv_rsv_synch.for_update','Inv_Pick_Release_PVT.Process_Line');

3308: , x_msg_data => x_msg_data);
3309:
3310: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
3311: IF (is_debug) THEN
3312: print_debug('Error from inv_rsv_synch.for_update','Inv_Pick_Release_PVT.Process_Line');
3313: END IF;
3314: RAISE fnd_api.g_exc_error;
3315: END IF;
3316: --

Line 3319: print_debug('Unexp. error from inv_rsv_synch.for_update','Inv_Pick_Release_PVT.Process_Line');

3315: END IF;
3316: --
3317: IF l_api_return_status = fnd_api.g_ret_sts_unexp_error THEN
3318: IF (is_debug) THEN
3319: print_debug('Unexp. error from inv_rsv_synch.for_update','Inv_Pick_Release_PVT.Process_Line');
3320: END IF;
3321: RAISE fnd_api.g_exc_unexpected_error;
3322: END IF;*/
3323: /* end bug 7253296 */