19: -- validate_organization
20: -- Description
21: -- is valid if all of the following are satisfied
22: -- 1. p_organization_id is null
23: -- 2. p_organization_id is in mtl_parameters
24: PROCEDURE validate_organization
25: (
26: x_return_status OUT NOCOPY VARCHAR2
27: , p_organization_id IN NUMBER
61: , negative_inv_receipt_code
62: , project_reference_enabled
63: , stock_locator_control_code
64: INTO l_rec
65: FROM mtl_parameters
66: WHERE organization_id = p_organization_id;
67:
68: EXCEPTION
69: WHEN no_data_found THEN
695: END IF;
696:
697: SELECT wms_enabled_flag
698: INTO l_wms_enabled
699: FROM mtl_parameters
700: WHERE organization_id = p_organization_id;
701:
702: IF (l_debug = 1) THEN
703: debug_print('l_wms_enabled = ' || l_wms_enabled);
814: END IF;
815:
816: SELECT wms_enabled_flag
817: INTO l_wms_enabled
818: FROM mtl_parameters
819: WHERE organization_id = p_organization_id;
820:
821: IF (l_debug = 1) THEN
822: debug_print('l_wms_enabled = ' || l_wms_enabled);
951: END IF;
952:
953: SELECT wms_enabled_flag
954: INTO l_wms_enabled
955: FROM mtl_parameters
956: WHERE organization_id = p_organization_id;
957:
958: IF (l_debug = 1) THEN
959: debug_print('l_wms_enabled = ' || l_wms_enabled);
4167: END IF;
4168:
4169: SELECT wms_enabled_flag, project_reference_enabled
4170: INTO l_wms_enabled, l_pjm_enabled
4171: FROM mtl_parameters
4172: WHERE organization_id = p_organization_id;
4173:
4174: IF (l_pjm_enabled = 1 and l_wms_enabled = 'Y') THEN
4175: IF (p_supply_source_type_id = inv_reservation_global.g_source_type_intransit) THEN