57: l_atr NUMBER;
58:
59: BEGIN
60:
61: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
62: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
63: l_log_module || '.begin',
64: 'Parameters: ' ||
65: 'p_inventory_item_id = ' || p_inventory_item_id || ', ' ||
58:
59: BEGIN
60:
61: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
62: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
63: l_log_module || '.begin',
64: 'Parameters: ' ||
65: 'p_inventory_item_id = ' || p_inventory_item_id || ', ' ||
66: 'p_subinventory_name = ' || p_subinventory_name || ', ' ||
69: 'p_source_subinventory = ' || p_source_subinventory || ', ' ||
70: 'p_source_locator_id = ' || p_source_locator_id);
71: END IF;
72:
73: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
74: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
75: l_log_module || '.query_quantities',
76: 'Calling INV_QUANTITY_TREE_PUB.query_quantities');
77: END IF;
70: 'p_source_locator_id = ' || p_source_locator_id);
71: END IF;
72:
73: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
74: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
75: l_log_module || '.query_quantities',
76: 'Calling INV_QUANTITY_TREE_PUB.query_quantities');
77: END IF;
78:
107: x_att => l_att,
108: x_atr => l_atr
109: );
110:
111: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
112: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
113: l_log_module || '.query_quantities',
114: 'After INV_QUANTITY_TREE_PUB.query_quantities: ' ||
115: 'x_att = ' || l_att || ', ' ||
108: x_atr => l_atr
109: );
110:
111: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
112: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
113: l_log_module || '.query_quantities',
114: 'After INV_QUANTITY_TREE_PUB.query_quantities: ' ||
115: 'x_att = ' || l_att || ', ' ||
116: 'x_return_status = ' || x_retcode || ', ' ||
130:
131: END IF;
132:
133:
134: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
136: l_log_module || '.end',
137: 'x_available_to_transact = ' || x_available_to_transact || ', ' ||
138: 'x_retcode = ' || x_retcode || ', ' ||
131: END IF;
132:
133:
134: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
136: l_log_module || '.end',
137: 'x_available_to_transact = ' || x_available_to_transact || ', ' ||
138: 'x_retcode = ' || x_retcode || ', ' ||
139: 'x_errmsg = ' || x_errmsg);
257: l_cnt NUMBER:=0;
258:
259: BEGIN
260:
261: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
262: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
263: l_log_module || '.begin',
264: 'Parameters: ' ||
265: 'p_kanban_card_id = ' || p_kanban_card_id || ', ' ||
258:
259: BEGIN
260:
261: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
262: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
263: l_log_module || '.begin',
264: 'Parameters: ' ||
265: 'p_kanban_card_id = ' || p_kanban_card_id || ', ' ||
266: 'p_organization_id = ' || p_organization_id || ', ' ||
314:
315:
316: IF l_delivery_ids_tbl.COUNT > 0 THEN
317:
318: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
319: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
320: l_log_module || '.autocreate_deliveries',
321: 'Calling WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries');
322: END IF;
315:
316: IF l_delivery_ids_tbl.COUNT > 0 THEN
317:
318: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
319: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
320: l_log_module || '.autocreate_deliveries',
321: 'Calling WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries');
322: END IF;
323:
335: x_del_rows => l_del_rows_tbl
336: );
337:
338:
339: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
340: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
341: l_log_module || '.autocreate_deliveries',
342: 'After WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries: ' ||
343: 'x_return_status = ' || x_retcode || ', ' ||
336: );
337:
338:
339: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
340: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
341: l_log_module || '.autocreate_deliveries',
342: 'After WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries: ' ||
343: 'x_return_status = ' || x_retcode || ', ' ||
344: 'x_msg_count = ' || l_msg_count || ', ' ||
366: LOOP
367: FETCH c_delivery_dtl into l_delivery_detail_rec;
368: EXIT WHEN c_delivery_dtl%NOTFOUND;
369:
370: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
372: l_log_module || '.delivery_detail',
373: 'delivery_detail_id = ' || l_delivery_detail_rec.delivery_detail_id || ', ' ||
374: 'delivery_id = ' || l_delivery_detail_rec.delivery_id);
367: FETCH c_delivery_dtl into l_delivery_detail_rec;
368: EXIT WHEN c_delivery_dtl%NOTFOUND;
369:
370: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
372: l_log_module || '.delivery_detail',
373: 'delivery_detail_id = ' || l_delivery_detail_rec.delivery_detail_id || ', ' ||
374: 'delivery_id = ' || l_delivery_detail_rec.delivery_id);
375: END IF;
398: l_batch_info_rec.default_stage_subinventory := l_delivery_detail_rec.original_subinventory;
399: l_batch_info_rec.pick_from_subinventory := l_delivery_detail_rec.original_subinventory;
400: END IF;
401:
402: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
404: l_log_module || '.create_batch',
405: 'Calling WSH_PICKING_BATCHES_PUB.create_batch');
406: END IF;
399: l_batch_info_rec.pick_from_subinventory := l_delivery_detail_rec.original_subinventory;
400: END IF;
401:
402: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
404: l_log_module || '.create_batch',
405: 'Calling WSH_PICKING_BATCHES_PUB.create_batch');
406: END IF;
407:
414: p_batch_rec => l_batch_info_rec,
415: x_batch_id => l_batch_id
416: );
417:
418: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
419: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
420: l_log_module || '.create_batch',
421: 'After WSH_PICKING_BATCHES_PUB.create_batch: ' ||
422: 'x_return_status = ' || x_retcode || ', ' ||
415: x_batch_id => l_batch_id
416: );
417:
418: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
419: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
420: l_log_module || '.create_batch',
421: 'After WSH_PICKING_BATCHES_PUB.create_batch: ' ||
422: 'x_return_status = ' || x_retcode || ', ' ||
423: 'x_msg_count = ' || l_msg_count || ', ' ||
437: RETURN;
438: END IF;
439:
440:
441: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
443: l_log_module || '.release_batch',
444: 'Calling WSH_PICKING_BATCHES_PUB.release_batch');
445: END IF;
438: END IF;
439:
440:
441: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
443: l_log_module || '.release_batch',
444: 'Calling WSH_PICKING_BATCHES_PUB.release_batch');
445: END IF;
446:
458: p_release_mode => 'ONLINE',
459: x_request_id => l_request_id
460: );
461:
462: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
463: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
464: l_log_module || '.release_batch',
465: 'After WSH_PICKING_BATCHES_PUB.release_batch: ' ||
466: 'x_return_status = ' || x_retcode || ', ' ||
459: x_request_id => l_request_id
460: );
461:
462: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
463: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
464: l_log_module || '.release_batch',
465: 'After WSH_PICKING_BATCHES_PUB.release_batch: ' ||
466: 'x_return_status = ' || x_retcode || ', ' ||
467: 'x_msg_count = ' || l_msg_count || ', ' ||
500: l_trolin_tbl(1).operation := INV_GLOBALS.G_OPR_UPDATE;
501: l_trolin_tbl(1).header_id := l_move_order_header_id;
502: l_trolin_tbl(1).quantity_detailed := p_transfer_qty;
503:
504: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
505: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
506: l_log_module || '.process_move_order_line',
507: 'Calling INV_MOVE_ORDER_PUB.process_move_order_line');
508: END IF;
501: l_trolin_tbl(1).header_id := l_move_order_header_id;
502: l_trolin_tbl(1).quantity_detailed := p_transfer_qty;
503:
504: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
505: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
506: l_log_module || '.process_move_order_line',
507: 'Calling INV_MOVE_ORDER_PUB.process_move_order_line');
508: END IF;
509:
519: p_trolin_old_tbl => l_trolin_old_tbl,
520: x_trolin_tbl => l_trolin_out_tbl
521: );
522:
523: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
524: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
525: l_log_module || '.process_move_order_line',
526: 'After INV_MOVE_ORDER_PUB.process_move_order_line: ' ||
527: 'x_return_status = ' || x_retcode || ', ' ||
520: x_trolin_tbl => l_trolin_out_tbl
521: );
522:
523: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
524: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
525: l_log_module || '.process_move_order_line',
526: 'After INV_MOVE_ORDER_PUB.process_move_order_line: ' ||
527: 'x_return_status = ' || x_retcode || ', ' ||
528: 'x_msg_count = ' || l_msg_count || ', ' ||
550: l_mmtt_tbl(1).primary_quantity := p_transfer_qty;
551:
552: l_trolin_tbl.DELETE;
553:
554: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
555: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
556: l_log_module || '.pick_confirm',
557: 'Calling INV_PICK_WAVE_PICK_CONFIRM_PUB.pick_confirm');
558: END IF;
551:
552: l_trolin_tbl.DELETE;
553:
554: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
555: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
556: l_log_module || '.pick_confirm',
557: 'Calling INV_PICK_WAVE_PICK_CONFIRM_PUB.pick_confirm');
558: END IF;
559:
572: x_trolin_tbl => l_trolin_tbl,
573: p_transaction_date => SYSDATE
574: );
575:
576: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
578: l_log_module || '.pick_confirm',
579: 'After INV_PICK_WAVE_PICK_CONFIRM_PUB.pick_confirm: ' ||
580: 'x_return_status = ' || x_retcode || ', ' ||
573: p_transaction_date => SYSDATE
574: );
575:
576: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
578: l_log_module || '.pick_confirm',
579: 'After INV_PICK_WAVE_PICK_CONFIRM_PUB.pick_confirm: ' ||
580: 'x_return_status = ' || x_retcode || ', ' ||
581: 'x_msg_count = ' || l_msg_count || ', ' ||
599: -- ***************************************************************************************
600: -- Calling the WSH_DELIVERIES_PUB.delivery_action to ship confirm the delivery.
601: -- ****************************************************************************************
602:
603: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
605: l_log_module || '.delivery_action',
606: 'Calling WSH_DELIVERIES_PUB.delivery_action');
607: END IF;
600: -- Calling the WSH_DELIVERIES_PUB.delivery_action to ship confirm the delivery.
601: -- ****************************************************************************************
602:
603: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
605: l_log_module || '.delivery_action',
606: 'Calling WSH_DELIVERIES_PUB.delivery_action');
607: END IF;
608:
625: x_trip_id => l_trip_id,
626: x_trip_name => l_trip_name
627: );
628:
629: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
630: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
631: l_log_module || '.delivery_action',
632: 'After WSH_DELIVERIES_PUB.delivery_action: ' ||
633: 'x_return_status = ' || x_retcode || ', ' ||
626: x_trip_name => l_trip_name
627: );
628:
629: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
630: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
631: l_log_module || '.delivery_action',
632: 'After WSH_DELIVERIES_PUB.delivery_action: ' ||
633: 'x_return_status = ' || x_retcode || ', ' ||
634: 'x_msg_count = ' || l_msg_count || ', ' ||
652: -- ***************************************************************************************
653: -- Calling the Interface Trip Stops Program.
654: -- ***************************************************************************************
655:
656: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
657: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
658: l_log_module || '.interface_all',
659: 'Calling WSH_SHIP_CONFIRM_ACTIONS.interface_all');
660: END IF;
653: -- Calling the Interface Trip Stops Program.
654: -- ***************************************************************************************
655:
656: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
657: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
658: l_log_module || '.interface_all',
659: 'Calling WSH_SHIP_CONFIRM_ACTIONS.interface_all');
660: END IF;
661:
671: p_organization_id => NULL,
672: p_stops_per_batch => 1
673: );
674:
675: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
676: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
677: l_log_module || '.interface_all',
678: 'After WSH_SHIP_CONFIRM_ACTIONS.interface_all: ' ||
679: 'retcode = ' || x_retcode || ', ' ||
672: p_stops_per_batch => 1
673: );
674:
675: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
676: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
677: l_log_module || '.interface_all',
678: 'After WSH_SHIP_CONFIRM_ACTIONS.interface_all: ' ||
679: 'retcode = ' || x_retcode || ', ' ||
680: 'errbuf = ' || x_errmsg);
691: END LOOP;
692:
693:
694:
695: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
696: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
697: l_log_module || '.interorg_transfer_hook',
698: 'Calling FLM_KANBAN_CUSTOM_PKG.interorg_transfer_hook');
699: END IF;
692:
693:
694:
695: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
696: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
697: l_log_module || '.interorg_transfer_hook',
698: 'Calling FLM_KANBAN_CUSTOM_PKG.interorg_transfer_hook');
699: END IF;
700:
708: x_errmsg => x_errmsg
709: );
710:
711:
712: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
713: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
714: l_log_module || '.end',
715: 'x_retcode = ' || x_retcode || ', ' ||
716: 'x_errmsg = ' || x_errmsg);
709: );
710:
711:
712: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
713: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
714: l_log_module || '.end',
715: 'x_retcode = ' || x_retcode || ', ' ||
716: 'x_errmsg = ' || x_errmsg);
717: END IF;
803: l_mmtt_tbl INV_MO_LINE_DETAIL_UTIL.G_MMTT_Tbl_Type;
804:
805: BEGIN
806:
807: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
808: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
809: l_log_module || '.begin',
810: 'Parameters: ' ||
811: 'p_kanban_card_id = ' || p_kanban_card_id || ', ' ||
804:
805: BEGIN
806:
807: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
808: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
809: l_log_module || '.begin',
810: 'Parameters: ' ||
811: 'p_kanban_card_id = ' || p_kanban_card_id || ', ' ||
812: 'p_intra_order_id = ' || p_intra_order_id || ', ' ||
830: FETCH c_move_order INTO l_request_number, l_move_order_type;
831: CLOSE c_move_order;
832:
833:
834: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
835: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
836: l_log_module || '.line_details_pub',
837: 'Calling INV_REPLENISH_DETAIL_PUB.line_details_pub');
838: END IF;
831: CLOSE c_move_order;
832:
833:
834: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
835: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
836: l_log_module || '.line_details_pub',
837: 'Calling INV_REPLENISH_DETAIL_PUB.line_details_pub');
838: END IF;
839:
861: p_auto_pick_confirm => FALSE,
862: p_commit => FALSE
863: );
864:
865: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
866: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
867: l_log_module || '.line_details_pub',
868: 'After INV_REPLENISH_DETAIL_PUB.line_details_pub: ' ||
869: 'x_return_status = ' || x_retcode || ', ' ||
862: p_commit => FALSE
863: );
864:
865: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
866: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
867: l_log_module || '.line_details_pub',
868: 'After INV_REPLENISH_DETAIL_PUB.line_details_pub: ' ||
869: 'x_return_status = ' || x_retcode || ', ' ||
870: 'x_msg_count = ' || l_msg_count || ', ' ||
895: l_mmtt_tbl := inv_mo_line_detail_util.query_rows(p_intra_line_id);
896: l_mmtt_tbl(1).transaction_quantity := p_transfer_qty;
897: l_mmtt_tbl(1).primary_quantity := p_transfer_qty;
898:
899: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
900: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
901: l_log_module || '.pick_confirm',
902: 'Calling INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm');
903: END IF;
896: l_mmtt_tbl(1).transaction_quantity := p_transfer_qty;
897: l_mmtt_tbl(1).primary_quantity := p_transfer_qty;
898:
899: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
900: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
901: l_log_module || '.pick_confirm',
902: 'Calling INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm');
903: END IF;
904:
917: x_trolin_tbl => l_trolin_tbl,
918: p_transaction_date => SYSDATE
919: );
920:
921: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
922: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
923: l_log_module || '.pick_confirm',
924: 'After INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm: ' ||
925: 'x_return_status = ' || x_retcode || ', ' ||
918: p_transaction_date => SYSDATE
919: );
920:
921: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
922: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
923: l_log_module || '.pick_confirm',
924: 'After INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm: ' ||
925: 'x_return_status = ' || x_retcode || ', ' ||
926: 'x_msg_count = ' || l_msg_count || ', ' ||
964: CLOSE c_open_lines;
965:
966: IF l_open_lines.line_id IS NULL THEN
967:
968: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
969: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
970: l_log_module || '.close_order',
971: 'Calling INV_MO_ADMIN_PUB.close_order');
972: END IF;
965:
966: IF l_open_lines.line_id IS NULL THEN
967:
968: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
969: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
970: l_log_module || '.close_order',
971: 'Calling INV_MO_ADMIN_PUB.close_order');
972: END IF;
973:
981: x_msg_data => x_errmsg,
982: x_return_status => x_retcode
983: );
984:
985: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
986: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
987: l_log_module || '.close_order',
988: 'After INV_MO_ADMIN_PUB.close_order: ' ||
989: 'x_return_status = ' || x_retcode || ', ' ||
982: x_return_status => x_retcode
983: );
984:
985: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
986: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
987: l_log_module || '.close_order',
988: 'After INV_MO_ADMIN_PUB.close_order: ' ||
989: 'x_return_status = ' || x_retcode || ', ' ||
990: 'x_msg_count = ' || l_msg_count || ', ' ||
1009:
1010: END IF; -- l_open_lines
1011:
1012:
1013: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1014: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1015: l_log_module || '.intraorg_transfer_hook',
1016: 'Calling FLM_KANBAN_CUSTOM_PKG.intraorg_transfer_hook');
1017: END IF;
1010: END IF; -- l_open_lines
1011:
1012:
1013: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1014: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1015: l_log_module || '.intraorg_transfer_hook',
1016: 'Calling FLM_KANBAN_CUSTOM_PKG.intraorg_transfer_hook');
1017: END IF;
1018:
1026: x_errmsg => x_errmsg
1027: );
1028:
1029:
1030: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1031: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1032: l_log_module || '.end',
1033: 'x_retcode = ' || x_retcode || ', ' ||
1034: 'x_errmsg = ' || x_errmsg);
1027: );
1028:
1029:
1030: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1031: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1032: l_log_module || '.end',
1033: 'x_retcode = ' || x_retcode || ', ' ||
1034: 'x_errmsg = ' || x_errmsg);
1035: END IF;
1199: l_item_details_rec c_item_details%ROWTYPE;
1200:
1201: BEGIN
1202:
1203: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1204: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1205: l_log_module || '.begin',
1206: 'Parameters: ' ||
1207: 'p_kanban_card_id = ' || p_kanban_card_id || ', ' ||
1200:
1201: BEGIN
1202:
1203: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1204: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1205: l_log_module || '.begin',
1206: 'Parameters: ' ||
1207: 'p_kanban_card_id = ' || p_kanban_card_id || ', ' ||
1208: 'p_transfer_qty = ' || p_transfer_qty);
1388: RETURN;
1389: END IF;
1390:
1391:
1392: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1393: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1394: l_log_module || '.get_available_to_transact',
1395: 'Calling get_available_to_transact');
1396: END IF;
1389: END IF;
1390:
1391:
1392: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1393: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1394: l_log_module || '.get_available_to_transact',
1395: 'Calling get_available_to_transact');
1396: END IF;
1397:
1408: x_retcode => x_retcode,
1409: x_errmsg => x_errmsg
1410: );
1411:
1412: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1413: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1414: l_log_module || '.get_available_to_transact',
1415: 'After get_available_to_transact: ' ||
1416: 'x_available_to_transact = ' || l_available_to_transact || ', ' ||
1409: x_errmsg => x_errmsg
1410: );
1411:
1412: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1413: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1414: l_log_module || '.get_available_to_transact',
1415: 'After get_available_to_transact: ' ||
1416: 'x_available_to_transact = ' || l_available_to_transact || ', ' ||
1417: 'x_retcode = ' || x_retcode || ', ' ||
1430:
1431: END IF;
1432:
1433:
1434: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1435: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1436: l_log_module || '.end',
1437: 'x_organization_id = ' || x_organization_id || ', ' ||
1438: 'x_source_type = ' || x_source_type || ', ' ||
1431: END IF;
1432:
1433:
1434: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1435: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1436: l_log_module || '.end',
1437: 'x_organization_id = ' || x_organization_id || ', ' ||
1438: 'x_source_type = ' || x_source_type || ', ' ||
1439: 'x_kanban_size = ' || x_kanban_size || ', ' ||
1506: BEGIN
1507:
1508: SAVEPOINT complete_process;
1509:
1510: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1511: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1512: l_log_module || '.begin',
1513: 'Parameters: ' ||
1514: 'p_kanban_id = ' || p_kanban_id || ', ' ||
1507:
1508: SAVEPOINT complete_process;
1509:
1510: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1511: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1512: l_log_module || '.begin',
1513: 'Parameters: ' ||
1514: 'p_kanban_id = ' || p_kanban_id || ', ' ||
1515: 'p_transfer_qty = ' || p_transfer_qty || ', ' ||
1516: 'p_process_flag = ' || p_process_flag);
1517: END IF;
1518:
1519:
1520: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1521: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1522: l_log_module || '.validate_data',
1523: 'Calling validate_data');
1524: END IF;
1517: END IF;
1518:
1519:
1520: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1521: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1522: l_log_module || '.validate_data',
1523: 'Calling validate_data');
1524: END IF;
1525:
1538: x_line_id => l_line_id,
1539: x_retcode => x_retcode,
1540: x_errmsg => x_errmsg);
1541:
1542: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1543: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1544: l_log_module || '.validate_data',
1545: 'After validate_data: ' ||
1546: 'x_retcode = ' || x_retcode || ', ' ||
1539: x_retcode => x_retcode,
1540: x_errmsg => x_errmsg);
1541:
1542: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1543: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1544: l_log_module || '.validate_data',
1545: 'After validate_data: ' ||
1546: 'x_retcode = ' || x_retcode || ', ' ||
1547: 'x_errmsg = ' || x_errmsg);
1554: IF p_process_flag = 'Y' THEN
1555:
1556: IF l_source_type = INV_KANBAN_PVT.G_Source_Type_InterOrg THEN
1557:
1558: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1559: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1560: l_log_module || '.complete_inter_transfer',
1561: 'Calling complete_inter_transfer');
1562: END IF;
1555:
1556: IF l_source_type = INV_KANBAN_PVT.G_Source_Type_InterOrg THEN
1557:
1558: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1559: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1560: l_log_module || '.complete_inter_transfer',
1561: 'Calling complete_inter_transfer');
1562: END IF;
1563:
1571: p_line_id => l_line_id,
1572: x_retcode => x_retcode,
1573: x_errmsg => x_errmsg);
1574:
1575: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1576: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1577: l_log_module || '.complete_inter_transfer',
1578: 'After complete_inter_transfer: ' ||
1579: 'x_retcode = ' || x_retcode || ', ' ||
1572: x_retcode => x_retcode,
1573: x_errmsg => x_errmsg);
1574:
1575: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1576: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1577: l_log_module || '.complete_inter_transfer',
1578: 'After complete_inter_transfer: ' ||
1579: 'x_retcode = ' || x_retcode || ', ' ||
1580: 'x_errmsg = ' || x_errmsg);
1581: END IF;
1582:
1583: ELSIF l_source_type = INV_KANBAN_PVT.G_Source_Type_IntraOrg THEN
1584:
1585: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1586: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1587: l_log_module || '.complete_intra_transfer',
1588: 'Calling complete_intra_transfer');
1589: END IF;
1582:
1583: ELSIF l_source_type = INV_KANBAN_PVT.G_Source_Type_IntraOrg THEN
1584:
1585: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1586: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1587: l_log_module || '.complete_intra_transfer',
1588: 'Calling complete_intra_transfer');
1589: END IF;
1590:
1595: p_kanban_size => l_kanban_size,
1596: x_retcode => x_retcode,
1597: x_errmsg => x_errmsg);
1598:
1599: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1600: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1601: l_log_module || '.complete_intra_transfer',
1602: 'After complete_intra_transfer: ' ||
1603: 'x_retcode = ' || x_retcode || ', ' ||
1596: x_retcode => x_retcode,
1597: x_errmsg => x_errmsg);
1598:
1599: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1600: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1601: l_log_module || '.complete_intra_transfer',
1602: 'After complete_intra_transfer: ' ||
1603: 'x_retcode = ' || x_retcode || ', ' ||
1604: 'x_errmsg = ' || x_errmsg);
1607: END IF; -- l_source_type
1608:
1609: END IF; -- p_process_flag
1610:
1611: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1612: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1613: l_log_module || '.end',
1614: 'x_retcode = ' || x_retcode || ', ' ||
1615: 'x_errmsg = ' || x_errmsg);
1608:
1609: END IF; -- p_process_flag
1610:
1611: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1612: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1613: l_log_module || '.end',
1614: 'x_retcode = ' || x_retcode || ', ' ||
1615: 'x_errmsg = ' || x_errmsg);
1616: END IF;