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.PO_THIRD_PARTY_STOCK_GRP dependencies on STANDARD

Line 54: -- PARAMETERS: In: p_api_version Standard API parameter

50: -- (define the ASL and the validation type). False
51: -- otherwise. It then also returns the Validation Error
52: -- Message name
53: --
54: -- PARAMETERS: In: p_api_version Standard API parameter
55: -- p_init_msg_list Standard API parameter
56: -- p_commit Standard API parameter
57: -- p_validation_level Standard API parameter
58: -- p_inventory_item_id Item identifier

Line 55: -- p_init_msg_list Standard API parameter

51: -- otherwise. It then also returns the Validation Error
52: -- Message name
53: --
54: -- PARAMETERS: In: p_api_version Standard API parameter
55: -- p_init_msg_list Standard API parameter
56: -- p_commit Standard API parameter
57: -- p_validation_level Standard API parameter
58: -- p_inventory_item_id Item identifier
59: -- p_supplier_site_id Supplier site identifier

Line 56: -- p_commit Standard API parameter

52: -- Message name
53: --
54: -- PARAMETERS: In: p_api_version Standard API parameter
55: -- p_init_msg_list Standard API parameter
56: -- p_commit Standard API parameter
57: -- p_validation_level Standard API parameter
58: -- p_inventory_item_id Item identifier
59: -- p_supplier_site_id Supplier site identifier
60: -- p_inventory_org_id Inventory Organization

Line 57: -- p_validation_level Standard API parameter

53: --
54: -- PARAMETERS: In: p_api_version Standard API parameter
55: -- p_init_msg_list Standard API parameter
56: -- p_commit Standard API parameter
57: -- p_validation_level Standard API parameter
58: -- p_inventory_item_id Item identifier
59: -- p_supplier_site_id Supplier site identifier
60: -- p_inventory_org_id Inventory Organization
61: -- p_validation_type Validation to perform:

Line 64: -- Out: x_return_status Standard API parameter

60: -- p_inventory_org_id Inventory Organization
61: -- p_validation_type Validation to perform:
62: -- VMI or SUP_CONS
63: --
64: -- Out: x_return_status Standard API parameter
65: -- x_msg_count Standard API parameter
66: -- x_msg_data Standard API parameter
67: -- x_validation_error_name Error message name
68: --

Line 65: -- x_msg_count Standard API parameter

61: -- p_validation_type Validation to perform:
62: -- VMI or SUP_CONS
63: --
64: -- Out: x_return_status Standard API parameter
65: -- x_msg_count Standard API parameter
66: -- x_msg_data Standard API parameter
67: -- x_validation_error_name Error message name
68: --
69: -- Return: TRUE if OK to have Local VMI/Consigned from supplier ASL

Line 66: -- x_msg_data Standard API parameter

62: -- VMI or SUP_CONS
63: --
64: -- Out: x_return_status Standard API parameter
65: -- x_msg_count Standard API parameter
66: -- x_msg_data Standard API parameter
67: -- x_validation_error_name Error message name
68: --
69: -- Return: TRUE if OK to have Local VMI/Consigned from supplier ASL
70: --

Line 76: -- 15-Jan-03 VMA Add standard API parameters to comply

72: -- DESIGN REFERENCES: ASL_CONSSUP_DLD.doc
73: --
74: --
75: -- CHANGE HISTORY: 18-Sep-02 FDUBOIS Created.
76: -- 15-Jan-03 VMA Add standard API parameters to comply
77: -- with PL/SQL API standard.
78: -- 16-Jan-03 VMA Bug #2660359: Added validation for
79: -- automatic PO/REQ numbering for
80: -- Consigned/VMI.

Line 77: -- with PL/SQL API standard.

73: --
74: --
75: -- CHANGE HISTORY: 18-Sep-02 FDUBOIS Created.
76: -- 15-Jan-03 VMA Add standard API parameters to comply
77: -- with PL/SQL API standard.
78: -- 16-Jan-03 VMA Bug #2660359: Added validation for
79: -- automatic PO/REQ numbering for
80: -- Consigned/VMI.
81: -- 21-Jan-03 VMA Bug #2723366: Added validation for

Line 373: -- PARAMETERS: In: p_api_version Standard API parameter

369: -- VMI or Consigned from supplier for the IN parameters
370: -- (define the ASL). False otherwise. It then also
371: -- returns the Validation Error Message name
372: --
373: -- PARAMETERS: In: p_api_version Standard API parameter
374: -- p_init_msg_list Standard API parameter
375: -- p_commit Standard API parameter
376: -- p_validation_level Standard API parameter
377: -- p_inventory_item_id Item identifier

Line 374: -- p_init_msg_list Standard API parameter

370: -- (define the ASL). False otherwise. It then also
371: -- returns the Validation Error Message name
372: --
373: -- PARAMETERS: In: p_api_version Standard API parameter
374: -- p_init_msg_list Standard API parameter
375: -- p_commit Standard API parameter
376: -- p_validation_level Standard API parameter
377: -- p_inventory_item_id Item identifier
378: -- p_supplier_site_id Supplier site identifier

Line 375: -- p_commit Standard API parameter

371: -- returns the Validation Error Message name
372: --
373: -- PARAMETERS: In: p_api_version Standard API parameter
374: -- p_init_msg_list Standard API parameter
375: -- p_commit Standard API parameter
376: -- p_validation_level Standard API parameter
377: -- p_inventory_item_id Item identifier
378: -- p_supplier_site_id Supplier site identifier
379: -- p_validation_type Validation to perform:

Line 376: -- p_validation_level Standard API parameter

372: --
373: -- PARAMETERS: In: p_api_version Standard API parameter
374: -- p_init_msg_list Standard API parameter
375: -- p_commit Standard API parameter
376: -- p_validation_level Standard API parameter
377: -- p_inventory_item_id Item identifier
378: -- p_supplier_site_id Supplier site identifier
379: -- p_validation_type Validation to perform:
380: -- VMI or SUP_CONS

Line 382: -- Out: x_return_status Standard API parameter

378: -- p_supplier_site_id Supplier site identifier
379: -- p_validation_type Validation to perform:
380: -- VMI or SUP_CONS
381: --
382: -- Out: x_return_status Standard API parameter
383: -- x_msg_count Standard API parameter
384: -- x_msg_data Standard API parameter
385: -- x_validation_error_name Error message name
386: --

Line 383: -- x_msg_count Standard API parameter

379: -- p_validation_type Validation to perform:
380: -- VMI or SUP_CONS
381: --
382: -- Out: x_return_status Standard API parameter
383: -- x_msg_count Standard API parameter
384: -- x_msg_data Standard API parameter
385: -- x_validation_error_name Error message name
386: --
387: -- Return: TRUE if OK to have Global VMI/Consigned ASL

Line 384: -- x_msg_data Standard API parameter

380: -- VMI or SUP_CONS
381: --
382: -- Out: x_return_status Standard API parameter
383: -- x_msg_count Standard API parameter
384: -- x_msg_data Standard API parameter
385: -- x_validation_error_name Error message name
386: --
387: -- Return: TRUE if OK to have Global VMI/Consigned ASL
388: --

Line 393: -- 15-Jan-03 VMA Bug #2677786: Add standard API

389: --
390: -- DESIGN REFERENCES: ASL_CONSSUP_DLD.doc
391: --
392: -- CHANGE HISTORY: 22-Sep-02 FDUBOIS Created.
393: -- 15-Jan-03 VMA Bug #2677786: Add standard API
394: -- parameters to comply with PL/SQL
395: -- API standard.
396: -- 16-Jan-03 VMA Bug #2660359: Added validation for
397: -- automatic PO/REQ numbering for

Line 395: -- API standard.

391: --
392: -- CHANGE HISTORY: 22-Sep-02 FDUBOIS Created.
393: -- 15-Jan-03 VMA Bug #2677786: Add standard API
394: -- parameters to comply with PL/SQL
395: -- API standard.
396: -- 16-Jan-03 VMA Bug #2660359: Added validation for
397: -- automatic PO/REQ numbering for
398: -- Consigned/VMI.
399: -- 21-Jan-03 VMA Bug #2723366: Added validation for

Line 883: -- PARAMETERS : p_api_version Standard API parameter

879: -- - open consumption advices exist
880: -- - open VMI release lines exist
881: -- ('open' meaning neither FINALLY CLOSED nor CANCELLED)
882: --
883: -- PARAMETERS : p_api_version Standard API parameter
884: -- p_init_msg_list Standard API parameter
885: -- p_commit Standard API parameter
886: -- p_validation_level Standard API parameter
887: -- x_return_status Standard API parameter

Line 884: -- p_init_msg_list Standard API parameter

880: -- - open VMI release lines exist
881: -- ('open' meaning neither FINALLY CLOSED nor CANCELLED)
882: --
883: -- PARAMETERS : p_api_version Standard API parameter
884: -- p_init_msg_list Standard API parameter
885: -- p_commit Standard API parameter
886: -- p_validation_level Standard API parameter
887: -- x_return_status Standard API parameter
888: -- x_msg_count Standard API parameter

Line 885: -- p_commit Standard API parameter

881: -- ('open' meaning neither FINALLY CLOSED nor CANCELLED)
882: --
883: -- PARAMETERS : p_api_version Standard API parameter
884: -- p_init_msg_list Standard API parameter
885: -- p_commit Standard API parameter
886: -- p_validation_level Standard API parameter
887: -- x_return_status Standard API parameter
888: -- x_msg_count Standard API parameter
889: -- x_msg_data Standard API parameter

Line 886: -- p_validation_level Standard API parameter

882: --
883: -- PARAMETERS : p_api_version Standard API parameter
884: -- p_init_msg_list Standard API parameter
885: -- p_commit Standard API parameter
886: -- p_validation_level Standard API parameter
887: -- x_return_status Standard API parameter
888: -- x_msg_count Standard API parameter
889: -- x_msg_data Standard API parameter
890: -- p_vendor_site_id Vendor site id

Line 887: -- x_return_status Standard API parameter

883: -- PARAMETERS : p_api_version Standard API parameter
884: -- p_init_msg_list Standard API parameter
885: -- p_commit Standard API parameter
886: -- p_validation_level Standard API parameter
887: -- x_return_status Standard API parameter
888: -- x_msg_count Standard API parameter
889: -- x_msg_data Standard API parameter
890: -- p_vendor_site_id Vendor site id
891: -- x_can_merge FND_API.G_FALSE if the supplier

Line 888: -- x_msg_count Standard API parameter

884: -- p_init_msg_list Standard API parameter
885: -- p_commit Standard API parameter
886: -- p_validation_level Standard API parameter
887: -- x_return_status Standard API parameter
888: -- x_msg_count Standard API parameter
889: -- x_msg_data Standard API parameter
890: -- p_vendor_site_id Vendor site id
891: -- x_can_merge FND_API.G_FALSE if the supplier
892: -- site cannot be merged;

Line 889: -- x_msg_data Standard API parameter

885: -- p_commit Standard API parameter
886: -- p_validation_level Standard API parameter
887: -- x_return_status Standard API parameter
888: -- x_msg_count Standard API parameter
889: -- x_msg_data Standard API parameter
890: -- p_vendor_site_id Vendor site id
891: -- x_can_merge FND_API.G_FALSE if the supplier
892: -- site cannot be merged;
893: -- FND_API.G_TRUE otherwise.

Line 911: -- Added standard API parameters to

907: -- INV_SUPPLIER_OWNED_STOCK_GRP
908: -- has been moved to
909: -- PO_INV_THIRD_PARTY_STOCK_MDTR.
910: -- Modify call accordingly.
911: -- Added standard API parameters to
912: -- comply with PL/SQL coding standard.
913: --===========================================================================
914: PROCEDURE Validate_Supplier_Merge
915: ( p_api_version IN NUMBER

Line 912: -- comply with PL/SQL coding standard.

908: -- has been moved to
909: -- PO_INV_THIRD_PARTY_STOCK_MDTR.
910: -- Modify call accordingly.
911: -- Added standard API parameters to
912: -- comply with PL/SQL coding standard.
913: --===========================================================================
914: PROCEDURE Validate_Supplier_Merge
915: ( p_api_version IN NUMBER
916: , p_init_msg_list IN VARCHAR2

Line 972: -- 1. Consumption advices (standard PO)

968:
969: ELSE
970:
971: -- Check for open PO documents:
972: -- 1. Consumption advices (standard PO)
973: -- 2. Consumption advices (release)
974: -- 3. VMI release lines
975: -- 4. Consigned shipments
976: SELECT COUNT('x')

Line 983: AND type_lookup_code = 'STANDARD'

979: WHERE EXISTS
980: (SELECT 'x'
981: FROM po_headers_all
982: WHERE consigned_consumption_flag = 'Y'
983: AND type_lookup_code = 'STANDARD'
984: AND vendor_site_id = p_vendor_site_id
985: AND vendor_id = p_vendor_id --bug 3649022
986: AND NVL(closed_code, 'a') <> 'FINALLY CLOSED'
987: AND NVL(cancel_flag, 'N') = 'N')