[Home] [Help]
9537: IF (l_debug = 1) THEN
9538: debug_print('before sync ' || l_return_status);
9539: END IF;
9540: -- for data sync b/w mtl_demand and mtl_reservations
9541: inv_rsv_synch.for_insert(p_reservation_id => l_reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
9542:
9543: IF (l_debug = 1) THEN
9544: debug_print('After sync ' || l_return_status);
9545: END IF;
11658: l_secondary_quantity_reserved := l_to_rsv_rec.secondary_reservation_quantity;
11659:
11660: -- for data sync b/w mtl_demand and mtl_reservations
11661: IF (l_debug = 1) THEN
11662: debug_print('Calling inv_rsv_synch.for_update');
11663: END IF;
11664: inv_rsv_synch.for_update(p_reservation_id => l_orig_rsv_tbl(1).reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
11665:
11666: IF l_return_status = fnd_api.g_ret_sts_error THEN
11660: -- for data sync b/w mtl_demand and mtl_reservations
11661: IF (l_debug = 1) THEN
11662: debug_print('Calling inv_rsv_synch.for_update');
11663: END IF;
11664: inv_rsv_synch.for_update(p_reservation_id => l_orig_rsv_tbl(1).reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
11665:
11666: IF l_return_status = fnd_api.g_ret_sts_error THEN
11667: RAISE fnd_api.g_exc_error;
11668: END IF;
12175: --Bug 3830160: Added a call to delete the demand if the entire
12176: --reservation is relieved. Code to delete mtl_demand.
12177:
12178: IF (l_debug = 1) THEN
12179: debug_print('calling inv_rsv_synch.for_delete');
12180: END IF;
12181:
12182: inv_rsv_synch.for_delete
12183: (
12178: IF (l_debug = 1) THEN
12179: debug_print('calling inv_rsv_synch.for_delete');
12180: END IF;
12181:
12182: inv_rsv_synch.for_delete
12183: (
12184: p_reservation_id => l_reservation_id
12185: , x_return_status => l_return_status
12186: , x_msg_count => x_msg_count
12188: );
12189:
12190: IF l_return_status = fnd_api.g_ret_sts_error THEN
12191: IF (l_debug = 1) THEN
12192: debug_print('error calling inv_rsv_synch.for_delete');
12193: END IF;
12194: RAISE fnd_api.g_exc_error;
12195: END IF;
12196:
12195: END IF;
12196:
12197: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
12198: IF (l_debug = 1) THEN
12199: debug_print('unexpected error calling inv_rsv_synch.for_delete');
12200: END IF;
12201: RAISE fnd_api.g_exc_unexpected_error;
12202: END IF;
12203: -- End changes for bug 3827307
12234: --so that 'for_relieve' will be called only if there are some pending
12235: --demand and if we are not relieving the entire reservation.
12236:
12237: IF (l_debug = 1) THEN
12238: debug_print('calling inv_rsv_synch.for_relieve');
12239: END IF;
12240:
12241: inv_rsv_synch.for_relieve(
12242: p_reservation_id => l_reservation_id
12237: IF (l_debug = 1) THEN
12238: debug_print('calling inv_rsv_synch.for_relieve');
12239: END IF;
12240:
12241: inv_rsv_synch.for_relieve(
12242: p_reservation_id => l_reservation_id
12243: , p_primary_relieved_quantity => l_primary_relieved_quantity
12244: , x_return_status => l_return_status
12245: , x_msg_count => x_msg_count
12247: );
12248:
12249: IF l_return_status = fnd_api.g_ret_sts_error THEN
12250: IF (l_debug = 1) THEN
12251: debug_print('error calling inv_rsv_synch.for_relieve');
12252: END IF;
12253: RAISE fnd_api.g_exc_error;
12254: END IF;
12255:
12255:
12256: --
12257: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
12258: IF (l_debug = 1) THEN
12259: debug_print('unexpected error calling inv_rsv_synch.for_relieve');
12260: END IF;
12261: RAISE fnd_api.g_exc_unexpected_error;
12262: END IF;
12263:
12868: END IF;
12869:
12870: --
12871: -- for data sync b/w mtl_demand and mtl_reservations
12872: inv_rsv_synch.for_delete(p_reservation_id => l_reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
12873:
12874: IF l_return_status = fnd_api.g_ret_sts_error THEN
12875: RAISE fnd_api.g_exc_error;
12876: END IF;
14508: , program_update_date = l_date
14509: WHERE reservation_id = l_orig_rsv_tbl(1).reservation_id;
14510:
14511: -- for data sync b/w mtl_demand and mtl_reservations
14512: inv_rsv_synch.for_update(p_reservation_id => l_orig_rsv_tbl(1).reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
14513:
14514: IF l_return_status = fnd_api.g_ret_sts_error THEN
14515: RAISE fnd_api.g_exc_error;
14516: END IF;
14576: --
14577: END IF;
14578:
14579: -- for data sync b/w mtl_demand and mtl_reservations
14580: inv_rsv_synch.for_delete(p_reservation_id => l_orig_rsv_tbl(1).reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
14581:
14582: IF l_return_status = fnd_api.g_ret_sts_error THEN
14583: RAISE fnd_api.g_exc_error;
14584: END IF;
14810: /*** End R12 ***/
14811: );
14812: --
14813: -- for data sync b/w mtl_demand and mtl_reservations
14814: inv_rsv_synch.for_update(p_reservation_id => l_orig_rsv_tbl(1).reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
14815:
14816: debug_print(' return status after updating row' || l_return_status);
14817:
14818: IF l_return_status = fnd_api.g_ret_sts_error THEN
14999: , program_update_date = l_date
15000: WHERE reservation_id = l_to_rsv_tbl(1).reservation_id;
15001:
15002: -- for data sync b/w mtl_demand and mtl_reservations
15003: inv_rsv_synch.for_update(p_reservation_id => l_to_rsv_tbl(1).reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
15004:
15005: IF l_return_status = fnd_api.g_ret_sts_error THEN
15006: RAISE fnd_api.g_exc_error;
15007: END IF;
15263: -- insert into mtl_reservations
15264: x_reservation_id := l_reservation_id;
15265:
15266: -- for data sync b/w mtl_demand and mtl_reservations
15267: inv_rsv_synch.for_insert(p_reservation_id => l_reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
15268:
15269: IF l_return_status = fnd_api.g_ret_sts_error THEN
15270: RAISE fnd_api.g_exc_error;
15271: END IF;