200: , p_transaction_temp_id => l_temp_id
201: , p_quantity_to_delete => l_quantity
202: );
203:
204: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
205: IF (l_debug = 1) THEN
206: mydebug(' error returned from inv_mo_cancel_pvt.reduce_rsv_allocation');
207: mydebug(x_message);
208: END IF;
206: mydebug(' error returned from inv_mo_cancel_pvt.reduce_rsv_allocation');
207: mydebug(x_message);
208: END IF;
209:
210: RAISE fnd_api.g_exc_error;
211: ELSE
212: IF (l_debug = 1) THEN
213: mydebug(' Successful from inv_mo_cancel_pvt.reduce_rsv_allocation Call');
214: END IF;
402:
403: wms_container_pvt.Modify_LPN
404: (
405: p_api_version => 1.0
406: , p_validation_level => fnd_api.g_valid_level_none
407: , x_return_status => l_return_status
408: , x_msg_count => l_msg_count
409: , x_msg_data => l_msg_data
410: , p_lpn => l_lpn
476:
477: wms_container_pvt.Modify_LPN
478: (
479: p_api_version => 1.0
480: , p_validation_level => fnd_api.g_valid_level_none
481: , x_return_status => l_return_status
482: , x_msg_count => l_msg_count
483: , x_msg_data => l_msg_data
484: , p_lpn => l_lpn
498:
499: wms_container_pvt.Modify_LPN
500: (
501: p_api_version => 1.0
502: , p_validation_level => fnd_api.g_valid_level_none
503: , x_return_status => l_return_status
504: , x_msg_count => l_msg_count
505: , x_msg_data => l_msg_data
506: , p_lpn => l_lpn
751: END IF;
752:
753: print_version_info;
754:
755: x_return_status := fnd_api.g_ret_sts_success;
756: x_next_temp_id := NULL;
757:
758: SAVEPOINT unload_bulk_sp;
759:
798:
799: wms_container_pvt.Modify_LPN
800: (
801: p_api_version => 1.0
802: , p_validation_level => fnd_api.g_valid_level_none
803: , x_return_status => l_return_status
804: , x_msg_count => l_msg_count
805: , x_msg_data => l_msg_data
806: , p_lpn => l_lpn
830: ', l_line_type: ' || l_line_type
831: );
832: END IF;
833:
834: l_return_status := fnd_api.g_ret_sts_success;
835:
836: IF l_line_type = 'CANCELLED'
837: THEN
838: inv_mo_cancel_pvt.reduce_rsv_allocation
852: , p_update_parent => TRUE
853: );
854: END IF;
855:
856: IF (l_return_status <> fnd_api.g_ret_sts_success)
857: THEN
858: IF (l_debug = 1) THEN
859: mydebug('Error returned from API for deleting transaction');
860: mydebug(l_msg_data);
859: mydebug('Error returned from API for deleting transaction');
860: mydebug(l_msg_data);
861: END IF;
862:
863: RAISE fnd_api.g_exc_error;
864: END IF;
865:
866: IF l_mo_line_id IS NOT NULL
867: THEN
1083:
1084: wms_container_pvt.Modify_LPN
1085: (
1086: p_api_version => 1.0
1087: , p_validation_level => fnd_api.g_valid_level_none
1088: , x_return_status => l_return_status
1089: , x_msg_count => l_msg_count
1090: , x_msg_data => l_msg_data
1091: , p_lpn => l_lpn
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: ROLLBACK TO unload_bulk_sp;
1117:
1118: x_return_status := fnd_api.g_ret_sts_error;
1119:
1120: IF (l_debug = 1) THEN
1121: mydebug('Exception unload_bulk_task: ' || sqlerrm);
1122: END IF;