[Home] [Help]
8979: IF (l_debug = 1) THEN
8980: debug_print('before sync ' || l_return_status);
8981: END IF;
8982: -- for data sync b/w mtl_demand and mtl_reservations
8983: 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);
8984:
8985: IF (l_debug = 1) THEN
8986: debug_print('After sync ' || l_return_status);
8987: END IF;
10894:
10895: );
10896: -- for data sync b/w mtl_demand and mtl_reservations
10897: IF (l_debug = 1) THEN
10898: debug_print('Calling inv_rsv_synch.for_update');
10899: END IF;
10900: 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);
10901:
10902: IF l_return_status = fnd_api.g_ret_sts_error THEN
10896: -- for data sync b/w mtl_demand and mtl_reservations
10897: IF (l_debug = 1) THEN
10898: debug_print('Calling inv_rsv_synch.for_update');
10899: END IF;
10900: 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);
10901:
10902: IF l_return_status = fnd_api.g_ret_sts_error THEN
10903: RAISE fnd_api.g_exc_error;
10904: END IF;
11408: --Bug 3830160: Added a call to delete the demand if the entire
11409: --reservation is relieved. Code to delete mtl_demand.
11410:
11411: IF (l_debug = 1) THEN
11412: debug_print('calling inv_rsv_synch.for_delete');
11413: END IF;
11414:
11415: inv_rsv_synch.for_delete
11416: (
11411: IF (l_debug = 1) THEN
11412: debug_print('calling inv_rsv_synch.for_delete');
11413: END IF;
11414:
11415: inv_rsv_synch.for_delete
11416: (
11417: p_reservation_id => l_reservation_id
11418: , x_return_status => l_return_status
11419: , x_msg_count => x_msg_count
11421: );
11422:
11423: IF l_return_status = fnd_api.g_ret_sts_error THEN
11424: IF (l_debug = 1) THEN
11425: debug_print('error calling inv_rsv_synch.for_delete');
11426: END IF;
11427: RAISE fnd_api.g_exc_error;
11428: END IF;
11429:
11428: END IF;
11429:
11430: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
11431: IF (l_debug = 1) THEN
11432: debug_print('unexpected error calling inv_rsv_synch.for_delete');
11433: END IF;
11434: RAISE fnd_api.g_exc_unexpected_error;
11435: END IF;
11436: -- End changes for bug 3827307
11467: --so that 'for_relieve' will be called only if there are some pending
11468: --demand and if we are not relieving the entire reservation.
11469:
11470: IF (l_debug = 1) THEN
11471: debug_print('calling inv_rsv_synch.for_relieve');
11472: END IF;
11473:
11474: inv_rsv_synch.for_relieve(
11475: p_reservation_id => l_reservation_id
11470: IF (l_debug = 1) THEN
11471: debug_print('calling inv_rsv_synch.for_relieve');
11472: END IF;
11473:
11474: inv_rsv_synch.for_relieve(
11475: p_reservation_id => l_reservation_id
11476: , p_primary_relieved_quantity => l_primary_relieved_quantity
11477: , x_return_status => l_return_status
11478: , x_msg_count => x_msg_count
11480: );
11481:
11482: IF l_return_status = fnd_api.g_ret_sts_error THEN
11483: IF (l_debug = 1) THEN
11484: debug_print('error calling inv_rsv_synch.for_relieve');
11485: END IF;
11486: RAISE fnd_api.g_exc_error;
11487: END IF;
11488:
11488:
11489: --
11490: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
11491: IF (l_debug = 1) THEN
11492: debug_print('unexpected error calling inv_rsv_synch.for_relieve');
11493: END IF;
11494: RAISE fnd_api.g_exc_unexpected_error;
11495: END IF;
11496:
12098: END IF;
12099:
12100: --
12101: -- for data sync b/w mtl_demand and mtl_reservations
12102: 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);
12103:
12104: IF l_return_status = fnd_api.g_ret_sts_error THEN
12105: RAISE fnd_api.g_exc_error;
12106: END IF;
13399: , program_update_date = l_date
13400: WHERE reservation_id = l_orig_rsv_tbl(1).reservation_id;
13401:
13402: -- for data sync b/w mtl_demand and mtl_reservations
13403: 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);
13404:
13405: IF l_return_status = fnd_api.g_ret_sts_error THEN
13406: RAISE fnd_api.g_exc_error;
13407: END IF;
13467: --
13468: END IF;
13469:
13470: -- for data sync b/w mtl_demand and mtl_reservations
13471: 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);
13472:
13473: IF l_return_status = fnd_api.g_ret_sts_error THEN
13474: RAISE fnd_api.g_exc_error;
13475: END IF;
13701: /*** End R12 ***/
13702: );
13703: --
13704: -- for data sync b/w mtl_demand and mtl_reservations
13705: 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);
13706:
13707: debug_print(' return status after updating row' || l_return_status);
13708:
13709: IF l_return_status = fnd_api.g_ret_sts_error THEN
13889: , program_update_date = l_date
13890: WHERE reservation_id = l_to_rsv_tbl(1).reservation_id;
13891:
13892: -- for data sync b/w mtl_demand and mtl_reservations
13893: 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);
13894:
13895: IF l_return_status = fnd_api.g_ret_sts_error THEN
13896: RAISE fnd_api.g_exc_error;
13897: END IF;
14134: -- insert into mtl_reservations
14135: x_reservation_id := l_reservation_id;
14136:
14137: -- for data sync b/w mtl_demand and mtl_reservations
14138: 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);
14139:
14140: IF l_return_status = fnd_api.g_ret_sts_error THEN
14141: RAISE fnd_api.g_exc_error;
14142: END IF;