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 2804: print_debug('Executing get_intransit_time with the following parameters:' || fnd_global.local_chr(10) ||

2800: BEGIN
2801: SAVEPOINT sp_get_intransit_time;
2802: l_return_status := FND_API.G_RET_STS_SUCCESS;
2803: IF G_TRACE_ON = 1 THEN
2804: print_debug('Executing get_intransit_time with the following parameters:' || fnd_global.local_chr(10) ||
2805: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
2806: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
2807: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||
2808: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||

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

2801: SAVEPOINT sp_get_intransit_time;
2802: l_return_status := FND_API.G_RET_STS_SUCCESS;
2803: IF G_TRACE_ON = 1 THEN
2804: print_debug('Executing get_intransit_time with the following parameters:' || fnd_global.local_chr(10) ||
2805: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
2806: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
2807: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||
2808: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
2809: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||

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

2802: l_return_status := FND_API.G_RET_STS_SUCCESS;
2803: IF G_TRACE_ON = 1 THEN
2804: print_debug('Executing get_intransit_time with the following parameters:' || fnd_global.local_chr(10) ||
2805: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
2806: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
2807: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||
2808: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
2809: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
2810: ', p_item_id: ' || to_char(p_item_id) || fnd_global.local_chr(10) ||

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

2803: IF G_TRACE_ON = 1 THEN
2804: print_debug('Executing get_intransit_time with the following parameters:' || fnd_global.local_chr(10) ||
2805: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
2806: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
2807: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||
2808: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
2809: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
2810: ', p_item_id: ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
2811: ', p_sourcing_date : ' || to_char(p_sourcing_date) || fnd_global.local_chr(10)

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

2804: print_debug('Executing get_intransit_time with the following parameters:' || fnd_global.local_chr(10) ||
2805: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
2806: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
2807: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||
2808: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
2809: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
2810: ', p_item_id: ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
2811: ', p_sourcing_date : ' || to_char(p_sourcing_date) || fnd_global.local_chr(10)
2812: , l_proc_name

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

2805: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
2806: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
2807: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||
2808: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
2809: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
2810: ', p_item_id: ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
2811: ', p_sourcing_date : ' || to_char(p_sourcing_date) || fnd_global.local_chr(10)
2812: , l_proc_name
2813: , 9);

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

2806: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
2807: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||
2808: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
2809: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
2810: ', p_item_id: ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
2811: ', p_sourcing_date : ' || to_char(p_sourcing_date) || fnd_global.local_chr(10)
2812: , l_proc_name
2813: , 9);
2814: END IF;

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

2807: ', p_customer_site_id: ' || to_char(p_to_customer_site_id)|| fnd_global.local_chr(10) ||
2808: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
2809: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
2810: ', p_item_id: ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
2811: ', p_sourcing_date : ' || to_char(p_sourcing_date) || fnd_global.local_chr(10)
2812: , l_proc_name
2813: , 9);
2814: END IF;
2815:

Line 2856: 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

2852: END IF;
2853: RAISE fnd_api.g_exc_error;
2854: ELSE
2855: IF G_TRACE_ON = 1 THEN
2856: 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
2857: , l_proc_name
2858: , 9);
2859: END IF;
2860: END IF;

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

3270: End If ;
3271: -- Bug 4178417
3272:
3273: IF G_TRACE_ON = 1 THEN
3274: print_debug('Executing Do_restock with the following parameters' || fnd_global.local_chr(10) ||
3275: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
3276: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
3277: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
3278: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||

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

3271: -- Bug 4178417
3272:
3273: IF G_TRACE_ON = 1 THEN
3274: print_debug('Executing Do_restock with the following parameters' || fnd_global.local_chr(10) ||
3275: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
3276: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
3277: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
3278: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
3279: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||

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

3272:
3273: IF G_TRACE_ON = 1 THEN
3274: print_debug('Executing Do_restock with the following parameters' || fnd_global.local_chr(10) ||
3275: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
3276: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
3277: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
3278: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
3279: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
3280: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||

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

3273: IF G_TRACE_ON = 1 THEN
3274: print_debug('Executing Do_restock with the following parameters' || fnd_global.local_chr(10) ||
3275: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
3276: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
3277: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
3278: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
3279: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
3280: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
3281: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||

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

3274: print_debug('Executing Do_restock with the following parameters' || fnd_global.local_chr(10) ||
3275: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
3276: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
3277: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
3278: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
3279: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
3280: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
3281: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
3282: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||

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

3275: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
3276: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
3277: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
3278: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
3279: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
3280: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
3281: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
3282: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
3283: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||

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

3276: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
3277: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
3278: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
3279: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
3280: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
3281: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
3282: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
3283: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
3284: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||

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

3277: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
3278: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
3279: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
3280: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
3281: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
3282: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
3283: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
3284: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
3285: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||

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

3278: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
3279: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
3280: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
3281: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
3282: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
3283: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
3284: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
3285: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||
3286: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)

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

3279: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
3280: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
3281: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
3282: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
3283: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
3284: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
3285: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||
3286: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)
3287: , l_proc_name

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

3280: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
3281: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
3282: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
3283: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
3284: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
3285: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||
3286: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)
3287: , l_proc_name
3288: , 9);

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

3281: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
3282: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
3283: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
3284: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
3285: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||
3286: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)
3287: , l_proc_name
3288: , 9);
3289:

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

3282: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
3283: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
3284: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
3285: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||
3286: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)
3287: , l_proc_name
3288: , 9);
3289:
3290: print_debug('p_charge_acct: ' || to_char(l_charge_acct) || fnd_global.local_chr(10) ||

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

3286: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)
3287: , l_proc_name
3288: , 9);
3289:
3290: print_debug('p_charge_acct: ' || to_char(l_charge_acct) || fnd_global.local_chr(10) ||
3291: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
3292: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
3293: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
3294: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||

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

3287: , l_proc_name
3288: , 9);
3289:
3290: print_debug('p_charge_acct: ' || to_char(l_charge_acct) || fnd_global.local_chr(10) ||
3291: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
3292: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
3293: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
3294: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
3295: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||

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

3288: , 9);
3289:
3290: print_debug('p_charge_acct: ' || to_char(l_charge_acct) || fnd_global.local_chr(10) ||
3291: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
3292: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
3293: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
3294: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
3295: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
3296: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||

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

3289:
3290: print_debug('p_charge_acct: ' || to_char(l_charge_acct) || fnd_global.local_chr(10) ||
3291: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
3292: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
3293: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
3294: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
3295: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
3296: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
3297: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||

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

3290: print_debug('p_charge_acct: ' || to_char(l_charge_acct) || fnd_global.local_chr(10) ||
3291: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
3292: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
3293: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
3294: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
3295: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
3296: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
3297: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
3298: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||

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

3291: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
3292: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
3293: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
3294: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
3295: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
3296: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
3297: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
3298: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
3299: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||

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

3292: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
3293: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
3294: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
3295: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
3296: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
3297: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
3298: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
3299: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
3300: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||

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

3293: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
3294: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
3295: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
3296: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
3297: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
3298: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
3299: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
3300: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
3301: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||

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

3294: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
3295: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
3296: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
3297: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
3298: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
3299: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
3300: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
3301: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||
3302: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)

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

3295: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
3296: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
3297: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
3298: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
3299: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
3300: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
3301: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||
3302: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)
3303: , l_proc_name

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

3296: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
3297: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
3298: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
3299: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
3300: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
3301: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||
3302: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)
3303: , l_proc_name
3304: , 9);

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

3297: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
3298: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
3299: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
3300: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
3301: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||
3302: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)
3303: , l_proc_name
3304: , 9);
3305:

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

3298: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
3299: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
3300: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
3301: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||
3302: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)
3303: , l_proc_name
3304: , 9);
3305:
3306: print_debug('p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||

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

3302: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)
3303: , l_proc_name
3304: , 9);
3305:
3306: print_debug('p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
3307: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
3308: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
3309: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
3310: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||

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

3303: , l_proc_name
3304: , 9);
3305:
3306: print_debug('p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
3307: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
3308: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
3309: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
3310: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
3311: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||

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

3304: , 9);
3305:
3306: print_debug('p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
3307: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
3308: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
3309: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
3310: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
3311: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
3312: ', p_description: ' || p_description || fnd_global.local_chr(10) ||

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

3305:
3306: print_debug('p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
3307: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
3308: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
3309: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
3310: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
3311: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
3312: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
3313: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||

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

3306: print_debug('p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
3307: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
3308: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
3309: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
3310: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
3311: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
3312: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
3313: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
3314: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||

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

3307: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
3308: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
3309: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
3310: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
3311: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
3312: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
3313: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
3314: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
3315: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||

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

3308: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
3309: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
3310: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
3311: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
3312: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
3313: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
3314: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
3315: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
3316: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||

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

3309: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
3310: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
3311: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
3312: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
3313: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
3314: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
3315: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
3316: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||
3317: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||

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

3310: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
3311: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
3312: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
3313: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
3314: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
3315: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
3316: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||
3317: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
3318: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||

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

3311: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
3312: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
3313: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
3314: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
3315: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
3316: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||
3317: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
3318: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
3319: ', p_osfm_batch_id: ' || to_char(p_osfm_batch_id) || fnd_global.local_chr(10)

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

3312: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
3313: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
3314: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
3315: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
3316: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||
3317: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
3318: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
3319: ', p_osfm_batch_id: ' || to_char(p_osfm_batch_id) || fnd_global.local_chr(10)
3320: , l_proc_name

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

3313: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
3314: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
3315: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
3316: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||
3317: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
3318: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
3319: ', p_osfm_batch_id: ' || to_char(p_osfm_batch_id) || fnd_global.local_chr(10)
3320: , l_proc_name
3321: , 9);

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

3314: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
3315: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
3316: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||
3317: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
3318: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
3319: ', p_osfm_batch_id: ' || to_char(p_osfm_batch_id) || fnd_global.local_chr(10)
3320: , l_proc_name
3321: , 9);
3322: END IF;

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

3315: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
3316: ', l_location_id: ' || to_char(l_location_id) || fnd_global.local_chr(10) ||
3317: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
3318: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
3319: ', p_osfm_batch_id: ' || to_char(p_osfm_batch_id) || fnd_global.local_chr(10)
3320: , l_proc_name
3321: , 9);
3322: END IF;
3323:

Line 3520: 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

3516: END IF;
3517: RAISE fnd_api.g_exc_error;
3518: ELSE
3519: IF G_TRACE_ON = 1 THEN
3520: 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
3521: , l_proc_name
3522: , 9);
3523: END IF;
3524: END IF;

Line 4285: fnd_global.user_id,

4281: header_id)
4282: VALUES (
4283: 1,
4284: sysdate,
4285: fnd_global.user_id,
4286: sysdate,
4287: fnd_global.user_id,
4288: fnd_global.login_id,
4289: l_osfm_batch_id,

Line 4287: fnd_global.user_id,

4283: 1,
4284: sysdate,
4285: fnd_global.user_id,
4286: sysdate,
4287: fnd_global.user_id,
4288: fnd_global.login_id,
4289: l_osfm_batch_id,
4290: Decode(l_mode_flag, 1,null,l_header_id),
4291: p_organization_id,

Line 4288: fnd_global.login_id,

4284: sysdate,
4285: fnd_global.user_id,
4286: sysdate,
4287: fnd_global.user_id,
4288: fnd_global.login_id,
4289: l_osfm_batch_id,
4290: Decode(l_mode_flag, 1,null,l_header_id),
4291: p_organization_id,
4292: 5, --job creation