eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MINMAX_PVT dependencies on FND_GLOBAL

Line 8: G_USER_NAME fnd_user.user_name%TYPE := FND_GLOBAL.USER_NAME;

4: --
5: -- Replenishment Move Order Consolidation
6: -- Initialize the Global variables to the values set in INV_MMX_WRAPPER_PVT.
7: --
8: G_USER_NAME fnd_user.user_name%TYPE := FND_GLOBAL.USER_NAME;
9: G_TRACE_ON NUMBER := NVL(fnd_profile.value('INV_DEBUG_TRACE'),2);
10:
11:
12:

Line 616: ('Starting Min-max planning with the following parameters: ' || fnd_global.local_chr(10) ||

612: -- Query debug settings, set global variables
613: --
614: IF G_TRACE_ON = 1 THEN
615: print_debug
616: ('Starting Min-max planning with the following parameters: ' || fnd_global.local_chr(10) ||
617: ' p_item_select: ' || p_item_select || fnd_global.local_chr(10) ||
618: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10) ||
619: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
620: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10) ||

Line 617: ' p_item_select: ' || p_item_select || fnd_global.local_chr(10) ||

613: --
614: IF G_TRACE_ON = 1 THEN
615: print_debug
616: ('Starting Min-max planning with the following parameters: ' || fnd_global.local_chr(10) ||
617: ' p_item_select: ' || p_item_select || fnd_global.local_chr(10) ||
618: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10) ||
619: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
620: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10) ||
621: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10) ||

Line 618: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10) ||

614: IF G_TRACE_ON = 1 THEN
615: print_debug
616: ('Starting Min-max planning with the following parameters: ' || fnd_global.local_chr(10) ||
617: ' p_item_select: ' || p_item_select || fnd_global.local_chr(10) ||
618: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10) ||
619: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
620: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10) ||
621: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10) ||
622: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10) ||

Line 619: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||

615: print_debug
616: ('Starting Min-max planning with the following parameters: ' || fnd_global.local_chr(10) ||
617: ' p_item_select: ' || p_item_select || fnd_global.local_chr(10) ||
618: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10) ||
619: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
620: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10) ||
621: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10) ||
622: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10) ||
623: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10) ||

Line 620: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10) ||

616: ('Starting Min-max planning with the following parameters: ' || fnd_global.local_chr(10) ||
617: ' p_item_select: ' || p_item_select || fnd_global.local_chr(10) ||
618: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10) ||
619: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
620: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10) ||
621: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10) ||
622: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10) ||
623: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10) ||
624: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10) ||

Line 621: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10) ||

617: ' p_item_select: ' || p_item_select || fnd_global.local_chr(10) ||
618: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10) ||
619: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
620: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10) ||
621: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10) ||
622: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10) ||
623: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10) ||
624: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10) ||
625: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10) ||

Line 622: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10) ||

618: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10) ||
619: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
620: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10) ||
621: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10) ||
622: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10) ||
623: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10) ||
624: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10) ||
625: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10) ||
626: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10) ||

Line 623: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10) ||

619: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
620: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10) ||
621: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10) ||
622: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10) ||
623: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10) ||
624: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10) ||
625: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10) ||
626: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10) ||
627: ', p_include_mo: ' || to_char(p_include_mo) || fnd_global.local_chr(10) ||

Line 624: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10) ||

620: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10) ||
621: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10) ||
622: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10) ||
623: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10) ||
624: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10) ||
625: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10) ||
626: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10) ||
627: ', p_include_mo: ' || to_char(p_include_mo) || fnd_global.local_chr(10) ||
628: ', p_include_wip: ' || to_char(p_include_wip) || fnd_global.local_chr(10) ||

Line 625: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10) ||

621: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10) ||
622: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10) ||
623: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10) ||
624: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10) ||
625: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10) ||
626: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10) ||
627: ', p_include_mo: ' || to_char(p_include_mo) || fnd_global.local_chr(10) ||
628: ', p_include_wip: ' || to_char(p_include_wip) || fnd_global.local_chr(10) ||
629: ', p_include_if: ' || to_char(p_include_if) || fnd_global.local_chr(10)

Line 626: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10) ||

622: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10) ||
623: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10) ||
624: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10) ||
625: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10) ||
626: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10) ||
627: ', p_include_mo: ' || to_char(p_include_mo) || fnd_global.local_chr(10) ||
628: ', p_include_wip: ' || to_char(p_include_wip) || fnd_global.local_chr(10) ||
629: ', p_include_if: ' || to_char(p_include_if) || fnd_global.local_chr(10)
630: , l_proc_name

Line 627: ', p_include_mo: ' || to_char(p_include_mo) || fnd_global.local_chr(10) ||

623: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10) ||
624: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10) ||
625: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10) ||
626: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10) ||
627: ', p_include_mo: ' || to_char(p_include_mo) || fnd_global.local_chr(10) ||
628: ', p_include_wip: ' || to_char(p_include_wip) || fnd_global.local_chr(10) ||
629: ', p_include_if: ' || to_char(p_include_if) || fnd_global.local_chr(10)
630: , l_proc_name
631: , 5

Line 628: ', p_include_wip: ' || to_char(p_include_wip) || fnd_global.local_chr(10) ||

624: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10) ||
625: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10) ||
626: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10) ||
627: ', p_include_mo: ' || to_char(p_include_mo) || fnd_global.local_chr(10) ||
628: ', p_include_wip: ' || to_char(p_include_wip) || fnd_global.local_chr(10) ||
629: ', p_include_if: ' || to_char(p_include_if) || fnd_global.local_chr(10)
630: , l_proc_name
631: , 5
632: );

Line 629: ', p_include_if: ' || to_char(p_include_if) || fnd_global.local_chr(10)

625: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10) ||
626: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10) ||
627: ', p_include_mo: ' || to_char(p_include_mo) || fnd_global.local_chr(10) ||
628: ', p_include_wip: ' || to_char(p_include_wip) || fnd_global.local_chr(10) ||
629: ', p_include_if: ' || to_char(p_include_if) || fnd_global.local_chr(10)
630: , l_proc_name
631: , 5
632: );
633:

Line 635: ('Parameters contd..: ' || fnd_global.local_chr(10) ||

631: , 5
632: );
633:
634: print_debug
635: ('Parameters contd..: ' || fnd_global.local_chr(10) ||
636: ' p_net_rsv: ' || to_char(p_net_rsv) || fnd_global.local_chr(10) ||
637: ', p_net_unrsv: ' || to_char(p_net_unrsv) || fnd_global.local_chr(10) ||
638: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10) ||
639: ', p_org_id: ' || to_char(p_org_id) || fnd_global.local_chr(10) ||

Line 636: ' p_net_rsv: ' || to_char(p_net_rsv) || fnd_global.local_chr(10) ||

632: );
633:
634: print_debug
635: ('Parameters contd..: ' || fnd_global.local_chr(10) ||
636: ' p_net_rsv: ' || to_char(p_net_rsv) || fnd_global.local_chr(10) ||
637: ', p_net_unrsv: ' || to_char(p_net_unrsv) || fnd_global.local_chr(10) ||
638: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10) ||
639: ', p_org_id: ' || to_char(p_org_id) || fnd_global.local_chr(10) ||
640: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||

Line 637: ', p_net_unrsv: ' || to_char(p_net_unrsv) || fnd_global.local_chr(10) ||

633:
634: print_debug
635: ('Parameters contd..: ' || fnd_global.local_chr(10) ||
636: ' p_net_rsv: ' || to_char(p_net_rsv) || fnd_global.local_chr(10) ||
637: ', p_net_unrsv: ' || to_char(p_net_unrsv) || fnd_global.local_chr(10) ||
638: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10) ||
639: ', p_org_id: ' || to_char(p_org_id) || fnd_global.local_chr(10) ||
640: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
641: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||

Line 638: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10) ||

634: print_debug
635: ('Parameters contd..: ' || fnd_global.local_chr(10) ||
636: ' p_net_rsv: ' || to_char(p_net_rsv) || fnd_global.local_chr(10) ||
637: ', p_net_unrsv: ' || to_char(p_net_unrsv) || fnd_global.local_chr(10) ||
638: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10) ||
639: ', p_org_id: ' || to_char(p_org_id) || fnd_global.local_chr(10) ||
640: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
641: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
642: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||

Line 639: ', p_org_id: ' || to_char(p_org_id) || fnd_global.local_chr(10) ||

635: ('Parameters contd..: ' || fnd_global.local_chr(10) ||
636: ' p_net_rsv: ' || to_char(p_net_rsv) || fnd_global.local_chr(10) ||
637: ', p_net_unrsv: ' || to_char(p_net_unrsv) || fnd_global.local_chr(10) ||
638: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10) ||
639: ', p_org_id: ' || to_char(p_org_id) || fnd_global.local_chr(10) ||
640: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
641: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
642: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
643: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10) ||

Line 640: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||

636: ' p_net_rsv: ' || to_char(p_net_rsv) || fnd_global.local_chr(10) ||
637: ', p_net_unrsv: ' || to_char(p_net_unrsv) || fnd_global.local_chr(10) ||
638: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10) ||
639: ', p_org_id: ' || to_char(p_org_id) || fnd_global.local_chr(10) ||
640: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
641: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
642: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
643: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10) ||
644: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||

Line 641: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||

637: ', p_net_unrsv: ' || to_char(p_net_unrsv) || fnd_global.local_chr(10) ||
638: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10) ||
639: ', p_org_id: ' || to_char(p_org_id) || fnd_global.local_chr(10) ||
640: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
641: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
642: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
643: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10) ||
644: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
645: ', p_wip_batch_id: ' || to_char(p_wip_batch_id) || fnd_global.local_chr(10) ||

Line 642: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||

638: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10) ||
639: ', p_org_id: ' || to_char(p_org_id) || fnd_global.local_chr(10) ||
640: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
641: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
642: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
643: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10) ||
644: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
645: ', p_wip_batch_id: ' || to_char(p_wip_batch_id) || fnd_global.local_chr(10) ||
646: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10) ||

Line 643: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10) ||

639: ', p_org_id: ' || to_char(p_org_id) || fnd_global.local_chr(10) ||
640: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
641: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
642: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
643: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10) ||
644: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
645: ', p_wip_batch_id: ' || to_char(p_wip_batch_id) || fnd_global.local_chr(10) ||
646: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10) ||
647: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10) ||

Line 644: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||

640: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
641: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
642: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
643: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10) ||
644: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
645: ', p_wip_batch_id: ' || to_char(p_wip_batch_id) || fnd_global.local_chr(10) ||
646: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10) ||
647: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10) ||
648: ', p_range_buyer: ' || p_range_buyer || fnd_global.local_chr(10)

Line 645: ', p_wip_batch_id: ' || to_char(p_wip_batch_id) || fnd_global.local_chr(10) ||

641: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
642: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
643: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10) ||
644: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
645: ', p_wip_batch_id: ' || to_char(p_wip_batch_id) || fnd_global.local_chr(10) ||
646: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10) ||
647: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10) ||
648: ', p_range_buyer: ' || p_range_buyer || fnd_global.local_chr(10)
649: , l_proc_name

Line 646: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10) ||

642: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
643: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10) ||
644: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
645: ', p_wip_batch_id: ' || to_char(p_wip_batch_id) || fnd_global.local_chr(10) ||
646: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10) ||
647: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10) ||
648: ', p_range_buyer: ' || p_range_buyer || fnd_global.local_chr(10)
649: , l_proc_name
650: , 5

Line 647: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10) ||

643: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10) ||
644: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
645: ', p_wip_batch_id: ' || to_char(p_wip_batch_id) || fnd_global.local_chr(10) ||
646: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10) ||
647: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10) ||
648: ', p_range_buyer: ' || p_range_buyer || fnd_global.local_chr(10)
649: , l_proc_name
650: , 5
651: );

Line 648: ', p_range_buyer: ' || p_range_buyer || fnd_global.local_chr(10)

644: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
645: ', p_wip_batch_id: ' || to_char(p_wip_batch_id) || fnd_global.local_chr(10) ||
646: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10) ||
647: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10) ||
648: ', p_range_buyer: ' || p_range_buyer || fnd_global.local_chr(10)
649: , l_proc_name
650: , 5
651: );
652:

Line 654: ('Parameters contd..: ' || fnd_global.local_chr(10) ||

650: , 5
651: );
652:
653: print_debug
654: ('Parameters contd..: ' || fnd_global.local_chr(10) ||
655: ' p_cust_id: ' || to_char(p_cust_id) || fnd_global.local_chr(10) ||
656: ', p_cust_site_id: ' || to_char(p_cust_site_id) || fnd_global.local_chr(10) ||
657: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
658: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10) ||

Line 655: ' p_cust_id: ' || to_char(p_cust_id) || fnd_global.local_chr(10) ||

651: );
652:
653: print_debug
654: ('Parameters contd..: ' || fnd_global.local_chr(10) ||
655: ' p_cust_id: ' || to_char(p_cust_id) || fnd_global.local_chr(10) ||
656: ', p_cust_site_id: ' || to_char(p_cust_site_id) || fnd_global.local_chr(10) ||
657: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
658: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10) ||
659: ', p_sort: ' || p_sort || fnd_global.local_chr(10) ||

Line 656: ', p_cust_site_id: ' || to_char(p_cust_site_id) || fnd_global.local_chr(10) ||

652:
653: print_debug
654: ('Parameters contd..: ' || fnd_global.local_chr(10) ||
655: ' p_cust_id: ' || to_char(p_cust_id) || fnd_global.local_chr(10) ||
656: ', p_cust_site_id: ' || to_char(p_cust_site_id) || fnd_global.local_chr(10) ||
657: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
658: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10) ||
659: ', p_sort: ' || p_sort || fnd_global.local_chr(10) ||
660: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10) ||

Line 657: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||

653: print_debug
654: ('Parameters contd..: ' || fnd_global.local_chr(10) ||
655: ' p_cust_id: ' || to_char(p_cust_id) || fnd_global.local_chr(10) ||
656: ', p_cust_site_id: ' || to_char(p_cust_site_id) || fnd_global.local_chr(10) ||
657: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
658: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10) ||
659: ', p_sort: ' || p_sort || fnd_global.local_chr(10) ||
660: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10) ||
661: ', p_sysdate: ' || to_char(p_sysdate, 'DD-MON-YYYY HH24:MI:SS') ||

Line 658: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10) ||

654: ('Parameters contd..: ' || fnd_global.local_chr(10) ||
655: ' p_cust_id: ' || to_char(p_cust_id) || fnd_global.local_chr(10) ||
656: ', p_cust_site_id: ' || to_char(p_cust_site_id) || fnd_global.local_chr(10) ||
657: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
658: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10) ||
659: ', p_sort: ' || p_sort || fnd_global.local_chr(10) ||
660: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10) ||
661: ', p_sysdate: ' || to_char(p_sysdate, 'DD-MON-YYYY HH24:MI:SS') ||
662: fnd_global.local_chr(10) ||

Line 659: ', p_sort: ' || p_sort || fnd_global.local_chr(10) ||

655: ' p_cust_id: ' || to_char(p_cust_id) || fnd_global.local_chr(10) ||
656: ', p_cust_site_id: ' || to_char(p_cust_site_id) || fnd_global.local_chr(10) ||
657: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
658: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10) ||
659: ', p_sort: ' || p_sort || fnd_global.local_chr(10) ||
660: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10) ||
661: ', p_sysdate: ' || to_char(p_sysdate, 'DD-MON-YYYY HH24:MI:SS') ||
662: fnd_global.local_chr(10) ||
663: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') ||

Line 660: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10) ||

656: ', p_cust_site_id: ' || to_char(p_cust_site_id) || fnd_global.local_chr(10) ||
657: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
658: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10) ||
659: ', p_sort: ' || p_sort || fnd_global.local_chr(10) ||
660: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10) ||
661: ', p_sysdate: ' || to_char(p_sysdate, 'DD-MON-YYYY HH24:MI:SS') ||
662: fnd_global.local_chr(10) ||
663: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') ||
664: fnd_global.local_chr(10) ||

Line 662: fnd_global.local_chr(10) ||

658: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10) ||
659: ', p_sort: ' || p_sort || fnd_global.local_chr(10) ||
660: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10) ||
661: ', p_sysdate: ' || to_char(p_sysdate, 'DD-MON-YYYY HH24:MI:SS') ||
662: fnd_global.local_chr(10) ||
663: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') ||
664: fnd_global.local_chr(10) ||
665: ', p_d_cutoff: ' || to_char(p_d_cutoff, 'DD-MON-YYYY HH24:MI:SS') ||
666: fnd_global.local_chr(10) ||

Line 664: fnd_global.local_chr(10) ||

660: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10) ||
661: ', p_sysdate: ' || to_char(p_sysdate, 'DD-MON-YYYY HH24:MI:SS') ||
662: fnd_global.local_chr(10) ||
663: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') ||
664: fnd_global.local_chr(10) ||
665: ', p_d_cutoff: ' || to_char(p_d_cutoff, 'DD-MON-YYYY HH24:MI:SS') ||
666: fnd_global.local_chr(10) ||
667: ', p_order_by: ' || p_order_by || fnd_global.local_chr(10) ||
668: ', p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||

Line 666: fnd_global.local_chr(10) ||

662: fnd_global.local_chr(10) ||
663: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') ||
664: fnd_global.local_chr(10) ||
665: ', p_d_cutoff: ' || to_char(p_d_cutoff, 'DD-MON-YYYY HH24:MI:SS') ||
666: fnd_global.local_chr(10) ||
667: ', p_order_by: ' || p_order_by || fnd_global.local_chr(10) ||
668: ', p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
669: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
670: ', p_exception_set_id: ' || to_char(p_exception_set_id)|| fnd_global.local_chr(10) ||

Line 667: ', p_order_by: ' || p_order_by || fnd_global.local_chr(10) ||

663: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') ||
664: fnd_global.local_chr(10) ||
665: ', p_d_cutoff: ' || to_char(p_d_cutoff, 'DD-MON-YYYY HH24:MI:SS') ||
666: fnd_global.local_chr(10) ||
667: ', p_order_by: ' || p_order_by || fnd_global.local_chr(10) ||
668: ', p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
669: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
670: ', p_exception_set_id: ' || to_char(p_exception_set_id)|| fnd_global.local_chr(10) ||
671: ', p_gen_report: ' || p_gen_report || fnd_global.local_chr(10) ||

Line 668: ', p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||

664: fnd_global.local_chr(10) ||
665: ', p_d_cutoff: ' || to_char(p_d_cutoff, 'DD-MON-YYYY HH24:MI:SS') ||
666: fnd_global.local_chr(10) ||
667: ', p_order_by: ' || p_order_by || fnd_global.local_chr(10) ||
668: ', p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
669: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
670: ', p_exception_set_id: ' || to_char(p_exception_set_id)|| fnd_global.local_chr(10) ||
671: ', p_gen_report: ' || p_gen_report || fnd_global.local_chr(10) ||
672: ', p_osfm_batch_id: ' || p_osfm_batch_id || fnd_global.local_chr(10)

Line 669: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||

665: ', p_d_cutoff: ' || to_char(p_d_cutoff, 'DD-MON-YYYY HH24:MI:SS') ||
666: fnd_global.local_chr(10) ||
667: ', p_order_by: ' || p_order_by || fnd_global.local_chr(10) ||
668: ', p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
669: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
670: ', p_exception_set_id: ' || to_char(p_exception_set_id)|| fnd_global.local_chr(10) ||
671: ', p_gen_report: ' || p_gen_report || fnd_global.local_chr(10) ||
672: ', p_osfm_batch_id: ' || p_osfm_batch_id || fnd_global.local_chr(10)
673: , l_proc_name

Line 670: ', p_exception_set_id: ' || to_char(p_exception_set_id)|| fnd_global.local_chr(10) ||

666: fnd_global.local_chr(10) ||
667: ', p_order_by: ' || p_order_by || fnd_global.local_chr(10) ||
668: ', p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
669: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
670: ', p_exception_set_id: ' || to_char(p_exception_set_id)|| fnd_global.local_chr(10) ||
671: ', p_gen_report: ' || p_gen_report || fnd_global.local_chr(10) ||
672: ', p_osfm_batch_id: ' || p_osfm_batch_id || fnd_global.local_chr(10)
673: , l_proc_name
674: , 5

Line 671: ', p_gen_report: ' || p_gen_report || fnd_global.local_chr(10) ||

667: ', p_order_by: ' || p_order_by || fnd_global.local_chr(10) ||
668: ', p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
669: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
670: ', p_exception_set_id: ' || to_char(p_exception_set_id)|| fnd_global.local_chr(10) ||
671: ', p_gen_report: ' || p_gen_report || fnd_global.local_chr(10) ||
672: ', p_osfm_batch_id: ' || p_osfm_batch_id || fnd_global.local_chr(10)
673: , l_proc_name
674: , 5
675: );

Line 672: ', p_osfm_batch_id: ' || p_osfm_batch_id || fnd_global.local_chr(10)

668: ', p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
669: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
670: ', p_exception_set_id: ' || to_char(p_exception_set_id)|| fnd_global.local_chr(10) ||
671: ', p_gen_report: ' || p_gen_report || fnd_global.local_chr(10) ||
672: ', p_osfm_batch_id: ' || p_osfm_batch_id || fnd_global.local_chr(10)
673: , l_proc_name
674: , 5
675: );
676: END IF;

Line 2814: print_debug('Executing get_intransit_time with the following parameters:' || fnd_global.local_chr(10) ||

2810: BEGIN
2811: SAVEPOINT sp_get_intransit_time;
2812: l_return_status := FND_API.G_RET_STS_SUCCESS;
2813: IF G_TRACE_ON = 1 THEN
2814: print_debug('Executing get_intransit_time with the following parameters:' || fnd_global.local_chr(10) ||
2815: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
2816: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
2817: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||
2818: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||

Line 2815: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||

2811: SAVEPOINT sp_get_intransit_time;
2812: l_return_status := FND_API.G_RET_STS_SUCCESS;
2813: IF G_TRACE_ON = 1 THEN
2814: print_debug('Executing get_intransit_time with the following parameters:' || fnd_global.local_chr(10) ||
2815: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
2816: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
2817: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||
2818: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
2819: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||

Line 2816: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||

2812: l_return_status := FND_API.G_RET_STS_SUCCESS;
2813: IF G_TRACE_ON = 1 THEN
2814: print_debug('Executing get_intransit_time with the following parameters:' || fnd_global.local_chr(10) ||
2815: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
2816: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
2817: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||
2818: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
2819: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
2820: ', p_item_id: ' || to_char(p_item_id) || fnd_global.local_chr(10) ||

Line 2817: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||

2813: IF G_TRACE_ON = 1 THEN
2814: print_debug('Executing get_intransit_time with the following parameters:' || fnd_global.local_chr(10) ||
2815: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
2816: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
2817: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||
2818: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
2819: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
2820: ', p_item_id: ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
2821: ', p_sourcing_date : ' || to_char(p_sourcing_date) || fnd_global.local_chr(10)

Line 2818: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||

2814: print_debug('Executing get_intransit_time with the following parameters:' || fnd_global.local_chr(10) ||
2815: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
2816: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
2817: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||
2818: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
2819: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
2820: ', p_item_id: ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
2821: ', p_sourcing_date : ' || to_char(p_sourcing_date) || fnd_global.local_chr(10)
2822: , l_proc_name

Line 2819: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||

2815: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
2816: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
2817: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||
2818: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
2819: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
2820: ', p_item_id: ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
2821: ', p_sourcing_date : ' || to_char(p_sourcing_date) || fnd_global.local_chr(10)
2822: , l_proc_name
2823: , 9);

Line 2820: ', p_item_id: ' || to_char(p_item_id) || fnd_global.local_chr(10) ||

2816: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
2817: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||
2818: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
2819: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
2820: ', p_item_id: ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
2821: ', p_sourcing_date : ' || to_char(p_sourcing_date) || fnd_global.local_chr(10)
2822: , l_proc_name
2823: , 9);
2824: END IF;

Line 2821: ', p_sourcing_date : ' || to_char(p_sourcing_date) || fnd_global.local_chr(10)

2817: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||
2818: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
2819: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
2820: ', p_item_id: ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
2821: ', p_sourcing_date : ' || to_char(p_sourcing_date) || fnd_global.local_chr(10)
2822: , l_proc_name
2823: , 9);
2824: END IF;
2825:

Line 2866: print_debug('MRP_SOURCING_API_PK.mrp_sourcing returned success with Source Sub and Source Org '|| fnd_global.local_chr(10) || l_src_subinv || ' and '|| l_src_org

2862: END IF;
2863: RAISE fnd_api.g_exc_error;
2864: ELSE
2865: IF G_TRACE_ON = 1 THEN
2866: print_debug('MRP_SOURCING_API_PK.mrp_sourcing returned success with Source Sub and Source Org '|| fnd_global.local_chr(10) || l_src_subinv || ' and '|| l_src_org
2867: , l_proc_name
2868: , 9);
2869: END IF;
2870: END IF;

Line 3284: print_debug('Executing Do_restock with the following parameters' || fnd_global.local_chr(10) ||

3280: End If ;
3281: -- Bug 4178417
3282:
3283: IF G_TRACE_ON = 1 THEN
3284: print_debug('Executing Do_restock with the following parameters' || fnd_global.local_chr(10) ||
3285: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
3286: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
3287: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
3288: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||

Line 3285: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||

3281: -- Bug 4178417
3282:
3283: IF G_TRACE_ON = 1 THEN
3284: print_debug('Executing Do_restock with the following parameters' || fnd_global.local_chr(10) ||
3285: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
3286: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
3287: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
3288: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
3289: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||

Line 3286: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||

3282:
3283: IF G_TRACE_ON = 1 THEN
3284: print_debug('Executing Do_restock with the following parameters' || fnd_global.local_chr(10) ||
3285: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
3286: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
3287: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
3288: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
3289: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
3290: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||

Line 3287: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||

3283: IF G_TRACE_ON = 1 THEN
3284: print_debug('Executing Do_restock with the following parameters' || fnd_global.local_chr(10) ||
3285: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
3286: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
3287: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
3288: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
3289: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
3290: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
3291: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||

Line 3288: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||

3284: print_debug('Executing Do_restock with the following parameters' || fnd_global.local_chr(10) ||
3285: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
3286: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
3287: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
3288: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
3289: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
3290: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
3291: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
3292: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||

Line 3289: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||

3285: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
3286: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
3287: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
3288: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
3289: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
3290: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
3291: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
3292: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
3293: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||

Line 3290: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||

3286: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
3287: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
3288: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
3289: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
3290: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
3291: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
3292: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
3293: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
3294: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||

Line 3291: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||

3287: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
3288: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
3289: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
3290: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
3291: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
3292: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
3293: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
3294: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
3295: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||

Line 3292: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||

3288: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
3289: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
3290: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
3291: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
3292: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
3293: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
3294: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
3295: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||
3296: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)

Line 3293: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||

3289: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
3290: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
3291: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
3292: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
3293: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
3294: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
3295: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||
3296: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)
3297: , l_proc_name

Line 3294: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||

3290: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
3291: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
3292: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
3293: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
3294: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
3295: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||
3296: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)
3297: , l_proc_name
3298: , 9);

Line 3295: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||

3291: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
3292: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
3293: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
3294: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
3295: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||
3296: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)
3297: , l_proc_name
3298: , 9);
3299:

Line 3296: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)

3292: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
3293: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
3294: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
3295: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||
3296: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)
3297: , l_proc_name
3298: , 9);
3299:
3300: print_debug('p_charge_acct: ' || to_char(l_charge_acct) || fnd_global.local_chr(10) ||

Line 3300: print_debug('p_charge_acct: ' || to_char(l_charge_acct) || fnd_global.local_chr(10) ||

3296: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)
3297: , l_proc_name
3298: , 9);
3299:
3300: print_debug('p_charge_acct: ' || to_char(l_charge_acct) || fnd_global.local_chr(10) ||
3301: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
3302: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
3303: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
3304: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||

Line 3301: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||

3297: , l_proc_name
3298: , 9);
3299:
3300: print_debug('p_charge_acct: ' || to_char(l_charge_acct) || fnd_global.local_chr(10) ||
3301: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
3302: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
3303: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
3304: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
3305: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||

Line 3302: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||

3298: , 9);
3299:
3300: print_debug('p_charge_acct: ' || to_char(l_charge_acct) || fnd_global.local_chr(10) ||
3301: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
3302: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
3303: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
3304: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
3305: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
3306: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||

Line 3303: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||

3299:
3300: print_debug('p_charge_acct: ' || to_char(l_charge_acct) || fnd_global.local_chr(10) ||
3301: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
3302: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
3303: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
3304: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
3305: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
3306: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
3307: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||

Line 3304: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||

3300: print_debug('p_charge_acct: ' || to_char(l_charge_acct) || fnd_global.local_chr(10) ||
3301: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
3302: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
3303: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
3304: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
3305: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
3306: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
3307: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
3308: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||

Line 3305: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||

3301: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
3302: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
3303: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
3304: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
3305: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
3306: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
3307: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
3308: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
3309: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||

Line 3306: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||

3302: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
3303: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
3304: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
3305: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
3306: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
3307: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
3308: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
3309: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
3310: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||

Line 3307: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||

3303: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
3304: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
3305: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
3306: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
3307: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
3308: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
3309: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
3310: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
3311: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||

Line 3308: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||

3304: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
3305: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
3306: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
3307: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
3308: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
3309: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
3310: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
3311: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||
3312: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)

Line 3309: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||

3305: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
3306: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
3307: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
3308: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
3309: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
3310: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
3311: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||
3312: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)
3313: , l_proc_name

Line 3310: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||

3306: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
3307: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
3308: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
3309: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
3310: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
3311: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||
3312: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)
3313: , l_proc_name
3314: , 9);

Line 3311: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||

3307: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
3308: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
3309: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
3310: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
3311: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||
3312: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)
3313: , l_proc_name
3314: , 9);
3315:

Line 3312: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)

3308: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
3309: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
3310: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
3311: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||
3312: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)
3313: , l_proc_name
3314: , 9);
3315:
3316: print_debug('p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||

Line 3316: print_debug('p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||

3312: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)
3313: , l_proc_name
3314: , 9);
3315:
3316: print_debug('p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
3317: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
3318: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
3319: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
3320: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||

Line 3317: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||

3313: , l_proc_name
3314: , 9);
3315:
3316: print_debug('p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
3317: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
3318: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
3319: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
3320: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
3321: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||

Line 3318: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||

3314: , 9);
3315:
3316: print_debug('p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
3317: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
3318: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
3319: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
3320: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
3321: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
3322: ', p_description: ' || p_description || fnd_global.local_chr(10) ||

Line 3319: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||

3315:
3316: print_debug('p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
3317: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
3318: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
3319: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
3320: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
3321: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
3322: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
3323: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||

Line 3320: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||

3316: print_debug('p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
3317: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
3318: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
3319: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
3320: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
3321: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
3322: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
3323: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
3324: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||

Line 3321: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||

3317: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
3318: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
3319: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
3320: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
3321: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
3322: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
3323: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
3324: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
3325: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||

Line 3322: ', p_description: ' || p_description || fnd_global.local_chr(10) ||

3318: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
3319: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
3320: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
3321: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
3322: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
3323: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
3324: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
3325: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
3326: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||

Line 3323: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||

3319: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
3320: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
3321: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
3322: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
3323: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
3324: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
3325: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
3326: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||
3327: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||

Line 3324: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||

3320: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
3321: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
3322: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
3323: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
3324: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
3325: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
3326: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||
3327: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
3328: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||

Line 3325: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||

3321: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
3322: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
3323: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
3324: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
3325: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
3326: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||
3327: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
3328: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
3329: ', p_osfm_batch_id: ' || to_char(p_osfm_batch_id) || fnd_global.local_chr(10)

Line 3326: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||

3322: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
3323: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
3324: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
3325: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
3326: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||
3327: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
3328: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
3329: ', p_osfm_batch_id: ' || to_char(p_osfm_batch_id) || fnd_global.local_chr(10)
3330: , l_proc_name

Line 3327: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||

3323: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
3324: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
3325: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
3326: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||
3327: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
3328: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
3329: ', p_osfm_batch_id: ' || to_char(p_osfm_batch_id) || fnd_global.local_chr(10)
3330: , l_proc_name
3331: , 9);

Line 3328: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||

3324: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
3325: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
3326: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||
3327: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
3328: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
3329: ', p_osfm_batch_id: ' || to_char(p_osfm_batch_id) || fnd_global.local_chr(10)
3330: , l_proc_name
3331: , 9);
3332: END IF;

Line 3329: ', p_osfm_batch_id: ' || to_char(p_osfm_batch_id) || fnd_global.local_chr(10)

3325: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
3326: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||
3327: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
3328: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
3329: ', p_osfm_batch_id: ' || to_char(p_osfm_batch_id) || fnd_global.local_chr(10)
3330: , l_proc_name
3331: , 9);
3332: END IF;
3333:

Line 3530: print_debug('INV_MMX_WRAPPER_PVT.get_move_order_info returned success with MO Header Id and MO Line Number '|| fnd_global.local_chr(10) || l_mo_header_id ||' and '|| l_mo_line_num

3526: END IF;
3527: RAISE fnd_api.g_exc_error;
3528: ELSE
3529: IF G_TRACE_ON = 1 THEN
3530: print_debug('INV_MMX_WRAPPER_PVT.get_move_order_info returned success with MO Header Id and MO Line Number '|| fnd_global.local_chr(10) || l_mo_header_id ||' and '|| l_mo_line_num
3531: , l_proc_name
3532: , 9);
3533: END IF;
3534: END IF;

Line 4303: fnd_global.user_id,

4299: header_id)
4300: VALUES (
4301: 1,
4302: sysdate,
4303: fnd_global.user_id,
4304: sysdate,
4305: fnd_global.user_id,
4306: fnd_global.login_id,
4307: l_osfm_batch_id,

Line 4305: fnd_global.user_id,

4301: 1,
4302: sysdate,
4303: fnd_global.user_id,
4304: sysdate,
4305: fnd_global.user_id,
4306: fnd_global.login_id,
4307: l_osfm_batch_id,
4308: Decode(l_mode_flag, 1,null,l_header_id),
4309: p_organization_id,

Line 4306: fnd_global.login_id,

4302: sysdate,
4303: fnd_global.user_id,
4304: sysdate,
4305: fnd_global.user_id,
4306: fnd_global.login_id,
4307: l_osfm_batch_id,
4308: Decode(l_mode_flag, 1,null,l_header_id),
4309: p_organization_id,
4310: 5, --job creation