[Home] [Help]
147: END IF;
148: -- bug#2876849. Added the two new parameters from org id and from loc id.
149: -- previously they were being obtained from the LPN. but in case of
150: -- staging Xfr, the LPN will not have any sub/loc stamped to it.
151: inv_loc_wms_utils.update_lpn_loc_curr_capacity(
152: x_return_status => l_return_status
153: , x_msg_count => l_msg_count
154: , x_msg_data => l_msg_data
155: , p_organization_id => l_transfer_organization
164: , p_quantity => l_primary_quantity
165: , p_from_org_id => l_organization_id
166: , p_from_loc_id => l_locator_id
167: );
168: inv_loc_wms_utils.loc_empty_mixed_flag_auto(
169: x_return_status => l_return_status
170: , x_msg_count => l_msg_count
171: , x_msg_data => l_msg_data
172: , p_organization_id => l_organization_id
180: IF (l_debug =1) THEN
181: inv_trx_util_pub.TRACE('In DB trigger -status is ' || l_return_status, 'UPDATE_LPN_LOC_CURR_CAPACITY', 4);
182: END IF;
183: ELSE
184: inv_loc_wms_utils.update_lpn_loc_curr_capacity(
185: x_return_status => l_return_status
186: , x_msg_count => l_msg_count
187: , x_msg_data => l_msg_data
188: , p_organization_id => l_organization_id
195: , p_transfer_lpn_id => l_transfer_lpn_id
196: , p_content_lpn_id => l_content_lpn_id
197: , p_quantity => l_primary_quantity
198: );
199: inv_loc_wms_utils.loc_empty_mixed_flag_auto(
200: x_return_status => l_return_status
201: , x_msg_count => l_msg_count
202: , x_msg_data => l_msg_data
203: , p_organization_id => l_organization_id
244: l_primary_quantity := ABS(:NEW.primary_quantity);
245: l_sql_stmt_num := 5;
246: -- Update locator capacity in source locator
247: -- Receipts, Issues, Xfers
248: inv_loc_wms_utils.update_loc_current_capacity(
249: x_return_status => l_return_status
250: , x_msg_count => l_msg_count
251: , x_msg_data => l_msg_data
252: , p_organization_id => l_organization_id
282: l_primary_quantity := ABS(l_primary_quantity);
283: l_sql_stmt_num := 8;
284: -- Update locator capacity in destination locator
285:
286: inv_loc_wms_utils.update_loc_current_capacity(
287: x_return_status => l_return_status
288: , x_msg_count => l_msg_count
289: , x_msg_data => l_msg_data
290: , p_organization_id => l_transfer_organization
302: l_sql_stmt_num := 9;
303: END IF;
304:
305: l_sql_stmt_num := 10;
306: inv_loc_wms_utils.loc_empty_mixed_flag_auto(
307: x_return_status => l_return_status
308: , x_msg_count => l_msg_count
309: , x_msg_data => l_msg_data
310: , p_organization_id => l_organization_id
429: -- Update locator current capacity.
430: -- bug#2876849. Added the two new parameters from org id and from loc id.
431: -- previously they were being obtained from the LPN. but in case of
432: -- staging Xfr, the LPN will not have any sub/loc stamped to it.
433: inv_loc_wms_utils.update_lpn_loc_curr_capacity(
434: x_return_status => l_return_status
435: , x_msg_count => l_msg_count
436: , x_msg_data => l_msg_data
437: , p_organization_id => l_transfer_organization
451: inv_trx_util_pub.TRACE('IN DB TRIGGER -status is ' || l_return_status, 'UPDATE_LPN_LOC_CURR_CAPACITY', 4);
452: END IF;
453: END IF; /*End of fix for Bug#4046825.*/
454: --Revert Suggested Capacity.
455: inv_loc_wms_utils.revert_loc_suggested_capacity(
456: x_return_status => l_return_status
457: , x_msg_count => l_msg_count
458: , x_msg_data => l_msg_data
459: , p_organization_id => l_transfer_organization
485: --Update Locator Capacity.
486: -- added the two new parameters because for bulk pack, the transfer lpn
487: -- does not have the container capacity stamped. it needs to be calculated
488: -- from the container item.
489: inv_loc_wms_utils.update_lpn_loc_curr_capacity(
490: x_return_status => l_return_status
491: , x_msg_count => l_msg_count
492: , x_msg_data => l_msg_data
493: , p_organization_id => l_organization_id
505: );
506: inv_trx_util_pub.TRACE('In DB TRIGGER -status is ' || l_return_status, 'UPDATE_LPN_LOC_CURR_CAPACITY', 4);
507: END IF; /*End of fix for Bug#4046825.*/
508: --Revert Suggested Capacity.
509: inv_loc_wms_utils.revert_loc_suggested_capacity(
510: x_return_status => l_return_status
511: , x_msg_count => l_msg_count
512: , x_msg_data => l_msg_data
513: , p_organization_id => l_organization_id
527: l_primary_quantity := ABS(l_primary_quantity);
528: l_sql_stmt_num := 13;
529: -- Update locator current capacity in source locator
530:
531: inv_loc_wms_utils.update_loc_current_capacity(
532: x_return_status => l_return_status
533: , x_msg_count => l_msg_count
534: , x_msg_data => l_msg_data
535: , p_organization_id => l_organization_id
542: );
543: l_sql_stmt_num := 14;
544: -- Update locator capacity in destination locator
545:
546: inv_loc_wms_utils.update_loc_current_capacity(
547: x_return_status => l_return_status
548: , x_msg_count => l_msg_count
549: , x_msg_data => l_msg_data
550: , p_organization_id => l_transfer_organization
557: );
558: l_sql_stmt_num := 15;
559: -- Revert locator suggested capacity in destination locator
560:
561: inv_loc_wms_utils.revert_loc_suggested_capacity(
562: x_return_status => l_return_status
563: , x_msg_count => l_msg_count
564: , x_msg_data => l_msg_data
565: , p_organization_id => l_transfer_organization
580: l_primary_quantity := ABS(l_primary_quantity);
581: l_sql_stmt_num := 17;
582: -- Update locator current capacity in receipt locator
583:
584: inv_loc_wms_utils.update_loc_current_capacity(
585: x_return_status => l_return_status
586: , x_msg_count => l_msg_count
587: , x_msg_data => l_msg_data
588: , p_organization_id => l_organization_id
595: );
596: l_sql_stmt_num := 18;
597: -- Revert locator suggested capacity in receipt locator
598:
599: inv_loc_wms_utils.revert_loc_suggested_capacity(
600: x_return_status => l_return_status
601: , x_msg_count => l_msg_count
602: , x_msg_data => l_msg_data
603: , p_organization_id => l_organization_id
615: l_primary_quantity := ABS(l_primary_quantity);
616: l_sql_stmt_num := 21;
617: -- Update locator current capacity in source locator
618:
619: inv_loc_wms_utils.update_loc_current_capacity(
620: x_return_status => l_return_status
621: , x_msg_count => l_msg_count
622: , x_msg_data => l_msg_data
623: , p_organization_id => l_organization_id
634:
635:
636: END IF;
637: --Update Mixed Items Flag.
638: inv_loc_wms_utils.loc_empty_mixed_flag_auto(
639: x_return_status => l_return_status
640: , x_msg_count => l_msg_count
641: , x_msg_data => l_msg_data
642: , p_organization_id => l_organization_id