24: -- (define the ASL and the validation type). False
25: -- otherwize. It then also return the Validation Error
26: -- Message name
27: --
28: -- PARAMETERS: In: p_api_version Standard API parameter
29: -- p_init_msg_list Standard API parameter
30: -- p_commit Standard API parameter
31: -- p_validation_level Standard API parameter
32: -- p_inventory_item_id Item identifier
25: -- otherwize. It then also return the Validation Error
26: -- Message name
27: --
28: -- PARAMETERS: In: p_api_version Standard API parameter
29: -- p_init_msg_list Standard API parameter
30: -- p_commit Standard API parameter
31: -- p_validation_level Standard API parameter
32: -- p_inventory_item_id Item identifier
33: -- p_supplier_site_id Supplier site identifier
26: -- Message name
27: --
28: -- PARAMETERS: In: p_api_version Standard API parameter
29: -- p_init_msg_list Standard API parameter
30: -- p_commit Standard API parameter
31: -- p_validation_level Standard API parameter
32: -- p_inventory_item_id Item identifier
33: -- p_supplier_site_id Supplier site identifier
34: -- p_inventory_org_id Inventory Organization
27: --
28: -- PARAMETERS: In: p_api_version Standard API parameter
29: -- p_init_msg_list Standard API parameter
30: -- p_commit Standard API parameter
31: -- p_validation_level Standard API parameter
32: -- p_inventory_item_id Item identifier
33: -- p_supplier_site_id Supplier site identifier
34: -- p_inventory_org_id Inventory Organization
35: -- p_validation_type Validation to perform:
34: -- p_inventory_org_id Inventory Organization
35: -- p_validation_type Validation to perform:
36: -- VMI or SUP_CONS
37: --
38: -- Out: x_return_status Standard API parameter
39: -- x_msg_count Standard API parameter
40: -- x_msg_data Standard API parameter
41: -- x_validation_error_name Error message name
42: --
35: -- p_validation_type Validation to perform:
36: -- VMI or SUP_CONS
37: --
38: -- Out: x_return_status Standard API parameter
39: -- x_msg_count Standard API parameter
40: -- x_msg_data Standard API parameter
41: -- x_validation_error_name Error message name
42: --
43: -- Return: TRUE if OK to have Local VMI/Consigned from supplier ASL
36: -- VMI or SUP_CONS
37: --
38: -- Out: x_return_status Standard API parameter
39: -- x_msg_count Standard API parameter
40: -- x_msg_data Standard API parameter
41: -- x_validation_error_name Error message name
42: --
43: -- Return: TRUE if OK to have Local VMI/Consigned from supplier ASL
44: --
46: -- DESIGN REFERENCES: ASL_CONSSUP_DLD.doc
47: --
48: --
49: -- CHANGE HISTORY: 18-Sep-02 FDUBOIS Created.
50: -- 15-Jan-03 VMA Add standard API parameters to comply
51: -- with PL/SQL API standard.
52: --===========================================================================
53: FUNCTION validate_local_asl
54: ( p_api_version IN NUMBER
47: --
48: --
49: -- CHANGE HISTORY: 18-Sep-02 FDUBOIS Created.
50: -- 15-Jan-03 VMA Add standard API parameters to comply
51: -- with PL/SQL API standard.
52: --===========================================================================
53: FUNCTION validate_local_asl
54: ( p_api_version IN NUMBER
55: , p_init_msg_list IN VARCHAR2
74: -- VMI or Consigned from supplier for the IN parameters
75: -- (define the ASL). False otherwize. It then also
76: -- return the Validation Error Message name
77: --
78: -- PARAMETERS: In: p_api_version Standard API parameter
79: -- p_init_msg_list Standard API parameter
80: -- p_commit Standard API parameter
81: -- p_validation_level Standard API parameter
82: -- p_inventory_item_id Item identifier
75: -- (define the ASL). False otherwize. It then also
76: -- return the Validation Error Message name
77: --
78: -- PARAMETERS: In: p_api_version Standard API parameter
79: -- p_init_msg_list Standard API parameter
80: -- p_commit Standard API parameter
81: -- p_validation_level Standard API parameter
82: -- p_inventory_item_id Item identifier
83: -- p_supplier_site_id Supplier site identifier
76: -- return the Validation Error Message name
77: --
78: -- PARAMETERS: In: p_api_version Standard API parameter
79: -- p_init_msg_list Standard API parameter
80: -- p_commit Standard API parameter
81: -- p_validation_level Standard API parameter
82: -- p_inventory_item_id Item identifier
83: -- p_supplier_site_id Supplier site identifier
84: -- p_validation_type Validation to perform:
77: --
78: -- PARAMETERS: In: p_api_version Standard API parameter
79: -- p_init_msg_list Standard API parameter
80: -- p_commit Standard API parameter
81: -- p_validation_level Standard API parameter
82: -- p_inventory_item_id Item identifier
83: -- p_supplier_site_id Supplier site identifier
84: -- p_validation_type Validation to perform:
85: -- VMI or SUP_CONS
83: -- p_supplier_site_id Supplier site identifier
84: -- p_validation_type Validation to perform:
85: -- VMI or SUP_CONS
86: --
87: -- Out: x_return_status Standard API parameter
88: -- x_msg_count Standard API parameter
89: -- x_msg_data Standard API parameter
90: -- x_validation_error_name Error message name
91: --
84: -- p_validation_type Validation to perform:
85: -- VMI or SUP_CONS
86: --
87: -- Out: x_return_status Standard API parameter
88: -- x_msg_count Standard API parameter
89: -- x_msg_data Standard API parameter
90: -- x_validation_error_name Error message name
91: --
92: -- Return: TRUE if OK to have Global VMI/Consigned ASL
85: -- VMI or SUP_CONS
86: --
87: -- Out: x_return_status Standard API parameter
88: -- x_msg_count Standard API parameter
89: -- x_msg_data Standard API parameter
90: -- x_validation_error_name Error message name
91: --
92: -- Return: TRUE if OK to have Global VMI/Consigned ASL
93: --
94: --
95: -- DESIGN REFERENCES: ASL_CONSSUP_DLD.doc
96: --
97: -- CHANGE HISTORY: 22-Sep-02 FDUBOIS Created.
98: -- 15-Jan-03 VMA Add standard API parameters to comply
99: -- with PL/SQL API standard.
100: --===========================================================================
101: FUNCTION validate_global_asl
102: ( p_api_version IN NUMBER
95: -- DESIGN REFERENCES: ASL_CONSSUP_DLD.doc
96: --
97: -- CHANGE HISTORY: 22-Sep-02 FDUBOIS Created.
98: -- 15-Jan-03 VMA Add standard API parameters to comply
99: -- with PL/SQL API standard.
100: --===========================================================================
101: FUNCTION validate_global_asl
102: ( p_api_version IN NUMBER
103: , p_init_msg_list IN VARCHAR2
171: -- - open consumption advices exist
172: -- - open VMI release lines exist
173: -- ('open' meaning neither FINALLY CLOSED nor CANCELLED)
174: --
175: -- PARAMETERS : p_api_version Standard API parameter
176: -- p_init_msg_list Standard API parameter
177: -- p_commit Standard API parameter
178: -- p_validation_level Standard API parameter
179: -- x_return_status Standard API parameter
172: -- - open VMI release lines exist
173: -- ('open' meaning neither FINALLY CLOSED nor CANCELLED)
174: --
175: -- PARAMETERS : p_api_version Standard API parameter
176: -- p_init_msg_list Standard API parameter
177: -- p_commit Standard API parameter
178: -- p_validation_level Standard API parameter
179: -- x_return_status Standard API parameter
180: -- x_msg_count Standard API parameter
173: -- ('open' meaning neither FINALLY CLOSED nor CANCELLED)
174: --
175: -- PARAMETERS : p_api_version Standard API parameter
176: -- p_init_msg_list Standard API parameter
177: -- p_commit Standard API parameter
178: -- p_validation_level Standard API parameter
179: -- x_return_status Standard API parameter
180: -- x_msg_count Standard API parameter
181: -- x_msg_data Standard API parameter
174: --
175: -- PARAMETERS : p_api_version Standard API parameter
176: -- p_init_msg_list Standard API parameter
177: -- p_commit Standard API parameter
178: -- p_validation_level Standard API parameter
179: -- x_return_status Standard API parameter
180: -- x_msg_count Standard API parameter
181: -- x_msg_data Standard API parameter
182: -- p_vendor_site_id Vendor site id
175: -- PARAMETERS : p_api_version Standard API parameter
176: -- p_init_msg_list Standard API parameter
177: -- p_commit Standard API parameter
178: -- p_validation_level Standard API parameter
179: -- x_return_status Standard API parameter
180: -- x_msg_count Standard API parameter
181: -- x_msg_data Standard API parameter
182: -- p_vendor_site_id Vendor site id
183: -- x_can_merge FND_API.G_FALSE if the supplier
176: -- p_init_msg_list Standard API parameter
177: -- p_commit Standard API parameter
178: -- p_validation_level Standard API parameter
179: -- x_return_status Standard API parameter
180: -- x_msg_count Standard API parameter
181: -- x_msg_data Standard API parameter
182: -- p_vendor_site_id Vendor site id
183: -- x_can_merge FND_API.G_FALSE if the supplier
184: -- site cannot be merged;
177: -- p_commit Standard API parameter
178: -- p_validation_level Standard API parameter
179: -- x_return_status Standard API parameter
180: -- x_msg_count Standard API parameter
181: -- x_msg_data Standard API parameter
182: -- p_vendor_site_id Vendor site id
183: -- x_can_merge FND_API.G_FALSE if the supplier
184: -- site cannot be merged;
185: -- FND_API.G_TRUE otherwise.
199: -- INV_SUPPLIER_OWNED_STOCK_GRP
200: -- has been moved to
201: -- PO_INV_THIRD_PARTY_STOCK_MDTR.
202: -- Modify call accordingly.
203: -- Added standard API parameters to
204: -- comply with PL/SQL API coding standard.
205: --===========================================================================
206: PROCEDURE Validate_Supplier_Merge
207: ( p_api_version IN NUMBER
200: -- has been moved to
201: -- PO_INV_THIRD_PARTY_STOCK_MDTR.
202: -- Modify call accordingly.
203: -- Added standard API parameters to
204: -- comply with PL/SQL API coding standard.
205: --===========================================================================
206: PROCEDURE Validate_Supplier_Merge
207: ( p_api_version IN NUMBER
208: , p_init_msg_list IN VARCHAR2