DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on INV_CACHE

Line 2767: IF (NOT INV_CACHE.set_wpb_rec

2763: -- Test for invalid batch ID entered. API should error out. }}
2764:
2765: if p_simulation_mode = 'N' THEN
2766:
2767: IF (NOT INV_CACHE.set_wpb_rec
2768: (p_batch_id => p_batch_id,
2769: p_request_number => NULL)) THEN
2770: IF (l_debug = 1) THEN
2771: print_debug('Error caching the WSH picking batch record');

Line 2800: --l_organization_id := inv_cache.wpb_rec.organization_id;

2796: -- Test for multiple orgs tied to the picking batch. }}
2797: -- If multiple orgs are tied to the picking batch, there should still be only one
2798: -- org for the sub-batch passed to the crossdock API. Just retrieve the org from
2799: -- p_wsh_release_table instead.
2800: --l_organization_id := inv_cache.wpb_rec.organization_id;
2801: l_organization_id := p_wsh_release_table(p_wsh_release_table.FIRST).organization_id;
2802: l_allocation_method := NVL(inv_cache.wpb_rec.allocation_method, G_INVENTORY_ONLY);
2803: l_wpb_xdock_criteria_id := inv_cache.wpb_rec.crossdock_criteria_id;
2804: l_existing_rsvs_only := NVL(inv_cache.wpb_rec.existing_rsvs_only_flag, 'N');

Line 2802: l_allocation_method := NVL(inv_cache.wpb_rec.allocation_method, G_INVENTORY_ONLY);

2798: -- org for the sub-batch passed to the crossdock API. Just retrieve the org from
2799: -- p_wsh_release_table instead.
2800: --l_organization_id := inv_cache.wpb_rec.organization_id;
2801: l_organization_id := p_wsh_release_table(p_wsh_release_table.FIRST).organization_id;
2802: l_allocation_method := NVL(inv_cache.wpb_rec.allocation_method, G_INVENTORY_ONLY);
2803: l_wpb_xdock_criteria_id := inv_cache.wpb_rec.crossdock_criteria_id;
2804: l_existing_rsvs_only := NVL(inv_cache.wpb_rec.existing_rsvs_only_flag, 'N');
2805: l_progress := '60';
2806:

Line 2803: l_wpb_xdock_criteria_id := inv_cache.wpb_rec.crossdock_criteria_id;

2799: -- p_wsh_release_table instead.
2800: --l_organization_id := inv_cache.wpb_rec.organization_id;
2801: l_organization_id := p_wsh_release_table(p_wsh_release_table.FIRST).organization_id;
2802: l_allocation_method := NVL(inv_cache.wpb_rec.allocation_method, G_INVENTORY_ONLY);
2803: l_wpb_xdock_criteria_id := inv_cache.wpb_rec.crossdock_criteria_id;
2804: l_existing_rsvs_only := NVL(inv_cache.wpb_rec.existing_rsvs_only_flag, 'N');
2805: l_progress := '60';
2806:
2807: -- Query for and cache the org record.

Line 2804: l_existing_rsvs_only := NVL(inv_cache.wpb_rec.existing_rsvs_only_flag, 'N');

2800: --l_organization_id := inv_cache.wpb_rec.organization_id;
2801: l_organization_id := p_wsh_release_table(p_wsh_release_table.FIRST).organization_id;
2802: l_allocation_method := NVL(inv_cache.wpb_rec.allocation_method, G_INVENTORY_ONLY);
2803: l_wpb_xdock_criteria_id := inv_cache.wpb_rec.crossdock_criteria_id;
2804: l_existing_rsvs_only := NVL(inv_cache.wpb_rec.existing_rsvs_only_flag, 'N');
2805: l_progress := '60';
2806:
2807: -- Query for and cache the org record.
2808: IF (NOT INV_CACHE.set_org_rec(l_organization_id)) THEN

Line 2808: IF (NOT INV_CACHE.set_org_rec(l_organization_id)) THEN

2804: l_existing_rsvs_only := NVL(inv_cache.wpb_rec.existing_rsvs_only_flag, 'N');
2805: l_progress := '60';
2806:
2807: -- Query for and cache the org record.
2808: IF (NOT INV_CACHE.set_org_rec(l_organization_id)) THEN
2809: IF (l_debug = 1) THEN
2810: print_debug('Error caching the org record');
2811: END IF;
2812: RAISE fnd_api.g_exc_unexpected_error;

Line 2817: l_project_ref_enabled := INV_CACHE.org_rec.project_reference_enabled;

2813: END IF;
2814:
2815: end if; -- For SImulation Mode
2816: -- Set the PJM enabled flag.
2817: l_project_ref_enabled := INV_CACHE.org_rec.project_reference_enabled;
2818: l_progress := '70';
2819:
2820: -- Check if the organization is a WMS organization
2821: l_wms_org_flag := wms_install.check_install

Line 7133: IF (NOT INV_CACHE.set_org_rec(l_organization_id)) THEN

7129: g_item_uom_conversion_tb.DELETE;
7130: l_progress := '40';
7131:
7132: -- Query for and cache the org record.
7133: IF (NOT INV_CACHE.set_org_rec(l_organization_id)) THEN
7134: IF (l_debug = 1) THEN
7135: print_debug('Error caching the org record');
7136: END IF;
7137: RAISE fnd_api.g_exc_unexpected_error;

Line 7140: l_project_ref_enabled := INV_CACHE.org_rec.project_reference_enabled;

7136: END IF;
7137: RAISE fnd_api.g_exc_unexpected_error;
7138: END IF;
7139: -- Set the PJM enabled flag.
7140: l_project_ref_enabled := INV_CACHE.org_rec.project_reference_enabled;
7141: l_progress := '50';
7142:
7143: -- Check if the organization is a WMS organization
7144: l_wms_org_flag := wms_install.check_install