DBA Data[Home] [Help]

APPS.WSM_RESERVATIONS_PVT dependencies on INV_RESERVATION_PUB

Line 117: inv_reservation_pub.delete_reservation

113: If l_wsm_rsv_v_tbl.count > 0 then --MP Delete Changes
114: For i in l_wsm_rsv_v_tbl.first .. l_wsm_rsv_v_tbl.last loop --MP Delete Changes
115: l_rsv_old.reservation_id := l_wsm_rsv_v_tbl(i).reservation_id;
116: --log proc entry
117: inv_reservation_pub.delete_reservation
118: (
119: p_api_version_number => 1.0
120: , p_init_msg_lst => fnd_api.g_true
121: , x_return_status => l_return_status

Line 136: p_msg_text => 'inv_reservation_pub.delete_reservation failed',

132: --log that rsv api failed
133: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
134: l_msg_tokens.delete;
135: WSM_log_PVT.logMessage (p_module_name => l_module ,
136: p_msg_text => 'inv_reservation_pub.delete_reservation failed',
137: p_stmt_num => l_stmt_num ,
138: p_msg_tokens => l_msg_tokens ,
139: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
140: p_run_log_level => l_log_level

Line 157: --and call inv_reservation_pub.delete_reservation

153: --First query to check if any reservations asscoiated with the starting job in the calling pgm itself--
154: --Check if parent job is resulting job.
155: --If yes, then check if there is update of assembly.
156: --If yes, then write to WIE 'Note: Starting job is reserved against sales order(s).Update Assembly transaction will result in deletion of the starting job reservations'
157: --and call inv_reservation_pub.delete_reservation
158: --Else, compare starting job's net qty with net qty of same job in resulting jobs.
159: --Write to WIE 'Note: New net quantity is less than the starting job's reserved quantity.This transaction will result in reduction in reserved quantity' and Call reduce_reservations( );
160: --populate l_rsv_old record with the reservation details of the SJ.
161: --populate l_mtl_rsv record with the RJ details for Supply source info and new quantity info.

Line 194: inv_reservation_pub.delete_reservation

190: --MP Delete Changes
191: If l_wsm_rsv_v_tbl.count > 0 then --MP Delete Changes
192: For i in l_wsm_rsv_v_tbl.first .. l_wsm_rsv_v_tbl.last loop
193: l_rsv_old.reservation_id := l_wsm_rsv_v_tbl(i).reservation_id;
194: inv_reservation_pub.delete_reservation
195: (
196: p_api_version_number => 1.0
197: , p_init_msg_lst => fnd_api.g_true
198: , x_return_status => l_return_status

Line 212: p_msg_text => 'inv_reservation_pub.delete_reservation failed',

208: --log that rsv api failed
209: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
210: l_msg_tokens.delete;
211: WSM_log_PVT.logMessage (p_module_name => l_module ,
212: p_msg_text => 'inv_reservation_pub.delete_reservation failed',
213: p_stmt_num => l_stmt_num ,
214: p_msg_tokens => l_msg_tokens ,
215: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
216: p_run_log_level => l_log_level

Line 284: p_msg_text => 'inv_reservation_pub.reduce_reservation failed',

280: --log that rsv api failed
281: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
282: l_msg_tokens.delete;
283: WSM_log_PVT.logMessage (p_module_name => l_module ,
284: p_msg_text => 'inv_reservation_pub.reduce_reservation failed',
285: p_stmt_num => l_stmt_num ,
286: p_msg_tokens => l_msg_tokens ,
287: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
288: p_run_log_level => l_log_level

Line 327: inv_reservation_pub.delete_reservation

323: If l_wsm_rsv_v_tbl.count > 0 then --MP Delete Changes
324: For i in l_wsm_rsv_v_tbl.first .. l_wsm_rsv_v_tbl.last loop
325: l_rsv_old.reservation_id := l_wsm_rsv_v_tbl(i).reservation_id;
326: --log proc entry
327: inv_reservation_pub.delete_reservation
328: (
329: p_api_version_number => 1.0
330: , p_init_msg_lst => fnd_api.g_true
331: , x_return_status => l_return_status

Line 346: p_msg_text => 'inv_reservation_pub.delete_reservation failed',

342: --log that rsv api failed
343: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
344: l_msg_tokens.delete;
345: WSM_log_PVT.logMessage (p_module_name => l_module ,
346: p_msg_text => 'inv_reservation_pub.delete_reservation failed',
347: p_stmt_num => l_stmt_num ,
348: p_msg_tokens => l_msg_tokens ,
349: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
350: p_run_log_level => l_log_level

Line 425: inv_reservation_pub.transfer_reservation(

421: l_msg_data := null;
422:
423: l_msg_index := fnd_msg_pub.count_msg;
424:
425: inv_reservation_pub.transfer_reservation(
426: p_api_version_number => 1.0
427: , p_init_msg_lst => fnd_api.g_true
428: , x_return_status => l_return_status
429: , x_msg_count => l_msg_count

Line 448: p_msg_text => 'inv_reservation_pub.transfer_reservation failed',

444: --log that rsv api failed
445: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
446: l_msg_tokens.delete;
447: WSM_log_PVT.logMessage (p_module_name => l_module ,
448: p_msg_text => 'inv_reservation_pub.transfer_reservation failed',
449: p_stmt_num => l_stmt_num ,
450: p_msg_tokens => l_msg_tokens ,
451: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
452: p_run_log_level => l_log_level

Line 496: inv_reservation_pub.Delete_reservation (

492: --MP Delete Changes
493: If l_wsm_rsv_v_tbl.count > 0 then --MP Delete Changes
494: For i in l_wsm_rsv_v_tbl.first .. l_wsm_rsv_v_tbl.last loop
495: l_rsv_old.reservation_id := l_wsm_rsv_v_tbl(i).reservation_id;
496: inv_reservation_pub.Delete_reservation (
497: p_api_version_number => 1.0
498: , p_init_msg_lst => fnd_api.g_true
499: , x_return_status => l_return_status
500: , x_msg_count => l_msg_count

Line 514: p_msg_text => 'inv_reservation_pub.reduce_reservation failed',

510: --log that rsv api failed
511: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
512: l_msg_tokens.delete;
513: WSM_log_PVT.logMessage (p_module_name => l_module ,
514: p_msg_text => 'inv_reservation_pub.reduce_reservation failed',
515: p_stmt_num => l_stmt_num ,
516: p_msg_tokens => l_msg_tokens ,
517: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
518: p_run_log_level => l_log_level

Line 719: --inv_reservation_pub.reduce_reservations (

715: l_msg_data := null;
716:
717: l_msg_index := fnd_msg_pub.count_msg;
718:
719: --inv_reservation_pub.reduce_reservations (
720: -- x_return_status => l_return_status
721: -- , x_msg_count =>l_msg_count
722: -- , x_msg_data =>l_msg_data
723: -- , x_quantity_modified => l_quantity_modified

Line 750: p_msg_text => 'inv_reservation_pub.reduce_reservation failed',

746: --log that rsv api failed
747: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
748: l_msg_tokens.delete;
749: WSM_log_PVT.logMessage (p_module_name => l_module ,
750: p_msg_text => 'inv_reservation_pub.reduce_reservation failed',
751: p_stmt_num => l_stmt_num ,
752: p_msg_tokens => l_msg_tokens ,
753: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
754: p_run_log_level => l_log_level

Line 857: inv_reservation_pub.transfer_reservation( p_api_version_number => 1.0

853: l_msg_data := null;
854:
855: l_msg_index := fnd_msg_pub.count_msg;
856:
857: inv_reservation_pub.transfer_reservation( p_api_version_number => 1.0
858: , p_init_msg_lst => fnd_api.g_true
859: , x_return_status => l_return_status
860: , x_msg_count => l_msg_count
861: , x_msg_data => l_msg_data

Line 879: p_msg_text => 'inv_reservation_pub.transfer_reservation failed',

875: --log that rsv api failed
876: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
877: l_msg_tokens.delete;
878: WSM_log_PVT.logMessage (p_module_name => l_module ,
879: p_msg_text => 'inv_reservation_pub.transfer_reservation failed',
880: p_stmt_num => l_stmt_num ,
881: p_msg_tokens => l_msg_tokens ,
882: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
883: p_run_log_level => l_log_level

Line 1032: --inv_reservation_pub.reduce_reservations (

1028: l_msg_data := null;
1029:
1030: l_msg_index := fnd_msg_pub.count_msg;
1031:
1032: --inv_reservation_pub.reduce_reservations (
1033: -- x_return_status => l_return_status
1034: -- , x_msg_count =>l_msg_count
1035: -- , x_msg_data =>l_msg_data
1036: -- , x_quantity_modified => l_quantity_modified

Line 1085: p_msg_text => 'inv_reservation_pub.reduce_reservation failed',

1081: --log that rsv api failed
1082: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1083: l_msg_tokens.delete;
1084: WSM_log_PVT.logMessage (p_module_name => l_module ,
1085: p_msg_text => 'inv_reservation_pub.reduce_reservation failed',
1086: p_stmt_num => l_stmt_num ,
1087: p_msg_tokens => l_msg_tokens ,
1088: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1089: p_run_log_level => l_log_level

Line 1137: /* inv_reservation_pub.delete_reservation

1133: , p_sort_by_criteria => null
1134: );
1135: -- END: Adding for bug fix 5347562.
1136: -- Commenting call to delete_reservation API for bug 5347562.
1137: /* inv_reservation_pub.delete_reservation
1138: (
1139: p_api_version_number => 1.0
1140: , p_init_msg_lst => fnd_api.g_true
1141: , x_return_status => l_return_status

Line 1181: inv_reservation_pub.delete_reservation

1177:
1178: l_msg_index := fnd_msg_pub.count_msg;
1179: -- Commenting call to delete_reservation API for bug 5347562.
1180: /*
1181: inv_reservation_pub.delete_reservation
1182: (
1183: p_api_version_number => 1.0
1184: , p_init_msg_lst => fnd_api.g_true
1185: , x_return_status => l_return_status