[Home] [Help]
28: --x_mode
29: -- Valid values 'VENDOR','INVENTORY', 'BOTH', 'DOCUMENT'
30: --x_destination_doc_type
31: -- The form from which the call to the API is made. Vaild values are
32: -- 'PO', 'REQ', 'STANDARD PO', 'REQ_NONCATALOG' and NULL.
33: -- 'REQ_NONCATALOG' is for requisition lines that are non-catalog requests (created
34: -- through iProcurement) --
35: --x_item_id
36: -- item_id to be matched to source document
954: PROCEDURE NAME: document_sourcing
955:
956: REQUIRED INPUTS: item_id
957: vendor_id
958: destination_doc_type ('PO','REQ','STANDARD PO','REQ_NONCATALOG')
959:
960: OPTIONAL INPUTS: organization_id
961: currency_code
962: item_rev
1373: --x_vendor_id
1374: -- vendor_id to be matched for ASL
1375: --x_destination_doc_type
1376: -- The form from which the call to the API is made. Vaild values are
1377: -- 'PO', 'STANDARD PO', 'REQ', 'REQ_NONCATALOG' and NULL --
1379: -- Currency code to be compared to get matching document
1380: --x_item_rev
1381: -- Item revision that needs to be compared to.
1544: AND ( x_destination_doc_type = 'REQ'
1545: OR x_destination_doc_type = 'REQ_NONCATALOG' --
1546: OR x_destination_doc_type IS NULL
1547: --
1548: OR (x_destination_doc_type = 'STANDARD PO' and
1549: (poh.type_lookup_code = 'QUOTATION' OR
1550: (poh.type_lookup_code = 'BLANKET' AND nvl(poh.global_agreement_flag, 'N') = 'Y'))
1551: )
1552: --
1683: FROM po_ga_org_assignments poga
1684: WHERE poh.po_header_id = poga.po_header_id
1685: AND poga.vendor_site_id = decode( Nvl (poh.Enable_All_Sites,'N'),'Y',poga.Vendor_Site_Id,x_vendor_site_id) --< R12 GCPA ER>
1686: AND poga.enabled_flag = 'Y')
1687: AND (x_destination_doc_type = 'STANDARD PO'
1688: OR EXISTS (
1689: SELECT 'enabled org exists'
1690: FROM po_ga_org_assignments poga
1691: WHERE poh.po_header_id = poga.po_header_id
2054: END IF;
2055: end if;
2056: end if;
2057:
2058: else -- x_destination_doc_type = 'STANDARD PO','PO' OR NULL
2059:
2060: If (p_style_id <>
2061: PO_DOC_STYLE_PVT.get_doc_style_id(x_document_header_id)) THEN
2062: l_eligible_doc_flag := FALSE;
2251: END IF;
2252: end if;
2253: end if;
2254:
2255: else -- x_destination_doc_type = 'STANDARD PO','PO' OR NULL
2256:
2257: If (p_style_id <>
2258: PO_DOC_STYLE_PVT.get_doc_style_id(x_document_header_id)) THEN
2259: l_eligible_doc_flag := FALSE;
2389: --x_vendor_id
2390: -- vendor_id to be matched for ASL
2391: --x_destination_doc_type
2392: -- The form from which the call to the API is made. Vaild values are
2393: -- 'PO', 'STANDARD PO', 'REQ', 'REQ_NONCATALOG' and NULL --
2395: -- Currency code to be compared to get matching document
2396: --x_item_rev
2397: -- Item revision that needs to be compared to.
2537: AND ( x_destination_doc_type = 'REQ'
2538: OR x_destination_doc_type = 'REQ_NONCATALOG' --
2539: OR x_destination_doc_type IS NULL
2540: --
2541: OR (x_destination_doc_type = 'STANDARD PO' and
2542: (poh.type_lookup_code = 'QUOTATION' OR
2543: (poh.type_lookup_code = 'BLANKET' AND nvl(poh.global_agreement_flag, 'N') = 'Y'))
2544: )
2545: --
2669: WHERE poh.po_header_id = poga.po_header_id
2670: AND poga.vendor_site_id = x_vendor_site_id
2671: AND poga.enabled_flag = 'Y')
2672: )
2673: AND (x_destination_doc_type = 'STANDARD PO'
2674: OR EXISTS (
2675: SELECT 'enabled org exists'
2676: FROM po_ga_org_assignments poga
2677: WHERE poh.po_header_id = poga.po_header_id
2708: NULL expiration_date --Bug14145177
2709: FROM po_headers_all poh
2710: WHERE ( x_destination_doc_type = 'REQ'
2711: OR x_destination_doc_type = 'REQ_NONCATALOG' --
2712: OR x_destination_doc_type = 'STANDARD PO' --ER 12625661
2713: OR x_destination_doc_type IS NULL
2714: )
2715: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --
2716: and poh.approved_date is not null)
2781: WHERE poh.po_header_id = poga.po_header_id
2782: AND poga.vendor_site_id = decode( Nvl (poh.Enable_All_Sites,'N'),'Y',poga.Vendor_Site_Id,x_vendor_site_id) --< R12 GCPA ER>
2783: AND poga.enabled_flag = 'Y')
2784: )
2785: AND (x_destination_doc_type = 'STANDARD PO'
2786: OR EXISTS (
2787: SELECT 'enabled org exists'
2788: FROM po_ga_org_assignments poga
2789: WHERE poh.po_header_id = poga.po_header_id
2834: FROM po_headers_all poh --CTO changes FPH
2835: WHERE
2836: ( x_destination_doc_type = 'REQ'
2837: OR x_destination_doc_type = 'REQ_NONCATALOG' --
2838: OR x_destination_doc_type = 'STANDARD PO' --ER 12625661
2839: OR x_destination_doc_type IS NULL
2840: --
2841: )
2842: AND (
3144: l_eligible_doc_flag := FALSE;
3145: end if;
3146: end if;
3147:
3148: else -- x_destination_doc_type = 'STANDARD PO','PO' OR NULL
3149:
3150: If (p_style_id <>
3151: PO_DOC_STYLE_PVT.get_doc_style_id(x_document_header_id)) THEN
3152: l_eligible_doc_flag := FALSE;
3151: PO_DOC_STYLE_PVT.get_doc_style_id(x_document_header_id)) THEN
3152: l_eligible_doc_flag := FALSE;
3153: end if;
3154:
3155: end if; -- x_destination_doc_type = 'STANDARD PO','PO' OR NULL
3156: end if; -- if p_line_type_id IS NULL
3157:
3158: --
3159:
3312: end if;
3313:
3314: end if;
3315:
3316: else -- x_destination_doc_type = 'STANDARD PO','PO' OR NULL
3317:
3318: If (p_style_id <>
3319: PO_DOC_STYLE_PVT.get_doc_style_id(x_document_header_id)) THEN
3320: l_eligible_doc_flag := FALSE;
3319: PO_DOC_STYLE_PVT.get_doc_style_id(x_document_header_id)) THEN
3320: l_eligible_doc_flag := FALSE;
3321: end if;
3322:
3323: end if; -- x_destination_doc_type = 'STANDARD PO','PO' OR NULL
3324: end if; -- if p_line_type_id IS NULL
3325: --
3326:
3327: if l_eligible_doc_flag then --
3470:
3471: l_progress := '020';
3472:
3473: --
3474: IF p_destination_doc_type = 'STANDARD PO' AND
3475: p_vendor_site_sourcing_flag = 'N'
3476: THEN
3477: --Get purchasing org from site
3478: l_purchasing_org_id := PO_VENDOR_SITES_SV.get_org_id_from_vendor_site(
5843: -- p_start_date : Assignment start date to determine pricing
5844: -- p_deliver_to_loc_id : Deliver to location to determine pricing
5845: -- p_destination_org_id : Destination organizations to determine pricing
5846: -- p_api_version : The value is 1.0
5847: -- p_init_msg_list : Standard API parameter: Initializes FND
5848: -- message list if set to FND_API.G_TRUE.
5849: --
5850: --IN OUT: : None
5851: --
5867: --
5868: -- x_return_status - (a) FND_API.G_RET_STS_SUCCESS if validation successful
5869: -- (b) FND_API.G_RET_STS_ERROR if error during validation
5870: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
5871: -- x_msg_count - Standard API parameter: The count of number of messages
5872: -- added to the message list in this call.
5873: -- x_msg_data - Standard API parameter: Contains error msg in case
5874: -- x_return_status is returned as FND_API.G_RET_STS_ERROR
5875: -- or FND_API.G_RET_STS_UNEXP_ERROR.
5869: -- (b) FND_API.G_RET_STS_ERROR if error during validation
5870: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
5871: -- x_msg_count - Standard API parameter: The count of number of messages
5872: -- added to the message list in this call.
5873: -- x_msg_data - Standard API parameter: Contains error msg in case
5874: -- x_return_status is returned as FND_API.G_RET_STS_ERROR
5875: -- or FND_API.G_RET_STS_UNEXP_ERROR.
5876: --Notes : None
5877: --
5886: p_start_date IN DATE,
5887: p_deliver_to_loc_id IN NUMBER,
5888: p_destination_org_id IN NUMBER,
5889: p_api_version IN NUMBER,
5890: -- Bug# 3404477: Follow the API standards
5891: p_init_msg_list IN VARCHAR2,
5892: x_vendor_id OUT NOCOPY po_tbl_number,
5893: x_vendor_site_id OUT NOCOPY po_tbl_number,
5894: x_vendor_contact_id OUT NOCOPY po_tbl_number,
6205: -- Bug# 3404477: Return msg count and data
6206: x_msg_count := 0;
6207: x_msg_data := NULL;
6208:
6209: -- Bug# 3404477: Follow the API standards
6210: IF FND_API.to_boolean(p_init_msg_list) THEN
6211: -- initialize message list
6212: FND_MSG_PUB.initialize;
6213: END IF;
6898: -- Determines whether or not contract agreements can be sourced to
6899: -- Parameters:
6900: -- IN:
6901: -- p_destination_doc_type:
6902: -- Valid values are 'PO','REQ','STANDARD PO','REQ_NONCATALOG'and NULL
6903: -- p_document_type_code:
6904: -- Valid value is 'REQUISITION'
6905: -- p_document_subtype:
6906: -- Valid value is 'PURCHASE'