DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on INV_CACHE

Line 2732: IF (NOT INV_CACHE.set_wpb_rec

2728:
2729: -- Query for and cache the picking batch record for the inputted batch ID
2730: -- {{
2731: -- Test for invalid batch ID entered. API should error out. }}
2732: IF (NOT INV_CACHE.set_wpb_rec
2733: (p_batch_id => p_batch_id,
2734: p_request_number => NULL)) THEN
2735: IF (l_debug = 1) THEN
2736: print_debug('Error caching the WSH picking batch record');

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

2744: -- Test for multiple orgs tied to the picking batch. }}
2745: -- If multiple orgs are tied to the picking batch, there should still be only one
2746: -- org for the sub-batch passed to the crossdock API. Just retrieve the org from
2747: -- p_wsh_release_table instead.
2748: --l_organization_id := inv_cache.wpb_rec.organization_id;
2749: l_organization_id := p_wsh_release_table(p_wsh_release_table.FIRST).organization_id;
2750: l_allocation_method := NVL(inv_cache.wpb_rec.allocation_method, G_INVENTORY_ONLY);
2751: l_wpb_xdock_criteria_id := inv_cache.wpb_rec.crossdock_criteria_id;
2752: l_existing_rsvs_only := NVL(inv_cache.wpb_rec.existing_rsvs_only_flag, 'N');

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

2746: -- org for the sub-batch passed to the crossdock API. Just retrieve the org from
2747: -- p_wsh_release_table instead.
2748: --l_organization_id := inv_cache.wpb_rec.organization_id;
2749: l_organization_id := p_wsh_release_table(p_wsh_release_table.FIRST).organization_id;
2750: l_allocation_method := NVL(inv_cache.wpb_rec.allocation_method, G_INVENTORY_ONLY);
2751: l_wpb_xdock_criteria_id := inv_cache.wpb_rec.crossdock_criteria_id;
2752: l_existing_rsvs_only := NVL(inv_cache.wpb_rec.existing_rsvs_only_flag, 'N');
2753: l_progress := '60';
2754:

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

2747: -- p_wsh_release_table instead.
2748: --l_organization_id := inv_cache.wpb_rec.organization_id;
2749: l_organization_id := p_wsh_release_table(p_wsh_release_table.FIRST).organization_id;
2750: l_allocation_method := NVL(inv_cache.wpb_rec.allocation_method, G_INVENTORY_ONLY);
2751: l_wpb_xdock_criteria_id := inv_cache.wpb_rec.crossdock_criteria_id;
2752: l_existing_rsvs_only := NVL(inv_cache.wpb_rec.existing_rsvs_only_flag, 'N');
2753: l_progress := '60';
2754:
2755: -- Query for and cache the org record.

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

2748: --l_organization_id := inv_cache.wpb_rec.organization_id;
2749: l_organization_id := p_wsh_release_table(p_wsh_release_table.FIRST).organization_id;
2750: l_allocation_method := NVL(inv_cache.wpb_rec.allocation_method, G_INVENTORY_ONLY);
2751: l_wpb_xdock_criteria_id := inv_cache.wpb_rec.crossdock_criteria_id;
2752: l_existing_rsvs_only := NVL(inv_cache.wpb_rec.existing_rsvs_only_flag, 'N');
2753: l_progress := '60';
2754:
2755: -- Query for and cache the org record.
2756: IF (NOT INV_CACHE.set_org_rec(l_organization_id)) THEN

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

2752: l_existing_rsvs_only := NVL(inv_cache.wpb_rec.existing_rsvs_only_flag, 'N');
2753: l_progress := '60';
2754:
2755: -- Query for and cache the org record.
2756: IF (NOT INV_CACHE.set_org_rec(l_organization_id)) THEN
2757: IF (l_debug = 1) THEN
2758: print_debug('Error caching the org record');
2759: END IF;
2760: RAISE fnd_api.g_exc_unexpected_error;

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

2759: END IF;
2760: RAISE fnd_api.g_exc_unexpected_error;
2761: END IF;
2762: -- Set the PJM enabled flag.
2763: l_project_ref_enabled := INV_CACHE.org_rec.project_reference_enabled;
2764: l_progress := '70';
2765:
2766: -- Check if the organization is a WMS organization
2767: l_wms_org_flag := wms_install.check_install

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

6954: g_item_uom_conversion_tb.DELETE;
6955: l_progress := '40';
6956:
6957: -- Query for and cache the org record.
6958: IF (NOT INV_CACHE.set_org_rec(l_organization_id)) THEN
6959: IF (l_debug = 1) THEN
6960: print_debug('Error caching the org record');
6961: END IF;
6962: RAISE fnd_api.g_exc_unexpected_error;

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

6961: END IF;
6962: RAISE fnd_api.g_exc_unexpected_error;
6963: END IF;
6964: -- Set the PJM enabled flag.
6965: l_project_ref_enabled := INV_CACHE.org_rec.project_reference_enabled;
6966: l_progress := '50';
6967:
6968: -- Check if the organization is a WMS organization
6969: l_wms_org_flag := wms_install.check_install