[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
950: PROCEDURE NAME: document_sourcing
951:
952: REQUIRED INPUTS: item_id
953: vendor_id
954: destination_doc_type ('PO','REQ','STANDARD PO','REQ_NONCATALOG')
955:
956: OPTIONAL INPUTS: organization_id
957: currency_code
958: item_rev
1369: --x_vendor_id
1370: -- vendor_id to be matched for ASL
1371: --x_destination_doc_type
1372: -- The form from which the call to the API is made. Vaild values are
1373: -- 'PO', 'STANDARD PO', 'REQ', 'REQ_NONCATALOG' and NULL --
1375: -- Currency code to be compared to get matching document
1376: --x_item_rev
1377: -- Item revision that needs to be compared to.
1535: AND ( x_destination_doc_type = 'REQ'
1536: OR x_destination_doc_type = 'REQ_NONCATALOG' --
1537: OR x_destination_doc_type IS NULL
1538: --
1539: OR (x_destination_doc_type = 'STANDARD PO' and
1540: (poh.type_lookup_code = 'QUOTATION' OR
1541: (poh.type_lookup_code = 'BLANKET' AND nvl(poh.global_agreement_flag, 'N') = 'Y'))
1542: )
1543: --
1673: FROM po_ga_org_assignments poga
1674: WHERE poh.po_header_id = poga.po_header_id
1675: AND poga.vendor_site_id = decode( Nvl (poh.Enable_All_Sites,'N'),'Y',poga.Vendor_Site_Id,x_vendor_site_id) --< R12 GCPA ER>
1676: AND poga.enabled_flag = 'Y')
1677: AND (x_destination_doc_type = 'STANDARD PO'
1678: OR EXISTS (
1679: SELECT 'enabled org exists'
1680: FROM po_ga_org_assignments poga
1681: WHERE poh.po_header_id = poga.po_header_id
2041: END IF;
2042: end if;
2043: end if;
2044:
2045: else -- x_destination_doc_type = 'STANDARD PO','PO' OR NULL
2046:
2047: If (p_style_id <>
2048: PO_DOC_STYLE_PVT.get_doc_style_id(x_document_header_id)) THEN
2049: l_eligible_doc_flag := FALSE;
2238: END IF;
2239: end if;
2240: end if;
2241:
2242: else -- x_destination_doc_type = 'STANDARD PO','PO' OR NULL
2243:
2244: If (p_style_id <>
2245: PO_DOC_STYLE_PVT.get_doc_style_id(x_document_header_id)) THEN
2246: l_eligible_doc_flag := FALSE;
2376: --x_vendor_id
2377: -- vendor_id to be matched for ASL
2378: --x_destination_doc_type
2379: -- The form from which the call to the API is made. Vaild values are
2380: -- 'PO', 'STANDARD PO', 'REQ', 'REQ_NONCATALOG' and NULL --
2382: -- Currency code to be compared to get matching document
2383: --x_item_rev
2384: -- Item revision that needs to be compared to.
2518: AND ( x_destination_doc_type = 'REQ'
2519: OR x_destination_doc_type = 'REQ_NONCATALOG' --
2520: OR x_destination_doc_type IS NULL
2521: --
2522: OR (x_destination_doc_type = 'STANDARD PO' and
2523: (poh.type_lookup_code = 'QUOTATION' OR
2524: (poh.type_lookup_code = 'BLANKET' AND nvl(poh.global_agreement_flag, 'N') = 'Y'))
2525: )
2526: --
2650: WHERE poh.po_header_id = poga.po_header_id
2651: AND poga.vendor_site_id = x_vendor_site_id
2652: AND poga.enabled_flag = 'Y')
2653: )
2654: AND (x_destination_doc_type = 'STANDARD PO'
2655: OR EXISTS (
2656: SELECT 'enabled org exists'
2657: FROM po_ga_org_assignments poga
2658: WHERE poh.po_header_id = poga.po_header_id
2760: WHERE poh.po_header_id = poga.po_header_id
2761: AND poga.vendor_site_id = decode( Nvl (poh.Enable_All_Sites,'N'),'Y',poga.Vendor_Site_Id,x_vendor_site_id) --< R12 GCPA ER>
2762: AND poga.enabled_flag = 'Y')
2763: )
2764: AND (x_destination_doc_type = 'STANDARD PO'
2765: OR EXISTS (
2766: SELECT 'enabled org exists'
2767: FROM po_ga_org_assignments poga
2768: WHERE poh.po_header_id = poga.po_header_id
3120: l_eligible_doc_flag := FALSE;
3121: end if;
3122: end if;
3123:
3124: else -- x_destination_doc_type = 'STANDARD PO','PO' OR NULL
3125:
3126: If (p_style_id <>
3127: PO_DOC_STYLE_PVT.get_doc_style_id(x_document_header_id)) THEN
3128: l_eligible_doc_flag := FALSE;
3127: PO_DOC_STYLE_PVT.get_doc_style_id(x_document_header_id)) THEN
3128: l_eligible_doc_flag := FALSE;
3129: end if;
3130:
3131: end if; -- x_destination_doc_type = 'STANDARD PO','PO' OR NULL
3132: end if; -- if p_line_type_id IS NULL
3133:
3134: --
3135:
3287: end if;
3288:
3289: end if;
3290:
3291: else -- x_destination_doc_type = 'STANDARD PO','PO' OR NULL
3292:
3293: If (p_style_id <>
3294: PO_DOC_STYLE_PVT.get_doc_style_id(x_document_header_id)) THEN
3295: l_eligible_doc_flag := FALSE;
3294: PO_DOC_STYLE_PVT.get_doc_style_id(x_document_header_id)) THEN
3295: l_eligible_doc_flag := FALSE;
3296: end if;
3297:
3298: end if; -- x_destination_doc_type = 'STANDARD PO','PO' OR NULL
3299: end if; -- if p_line_type_id IS NULL
3300: --
3301:
3302: if l_eligible_doc_flag then --
3444:
3445: l_progress := '020';
3446:
3447: --
3448: IF p_destination_doc_type = 'STANDARD PO' AND
3449: p_vendor_site_sourcing_flag = 'N'
3450: THEN
3451: --Get purchasing org from site
3452: l_purchasing_org_id := PO_VENDOR_SITES_SV.get_org_id_from_vendor_site(
5766: -- p_start_date : Assignment start date to determine pricing
5767: -- p_deliver_to_loc_id : Deliver to location to determine pricing
5768: -- p_destination_org_id : Destination organizations to determine pricing
5769: -- p_api_version : The value is 1.0
5770: -- p_init_msg_list : Standard API parameter: Initializes FND
5771: -- message list if set to FND_API.G_TRUE.
5772: --
5773: --IN OUT: : None
5774: --
5790: --
5791: -- x_return_status - (a) FND_API.G_RET_STS_SUCCESS if validation successful
5792: -- (b) FND_API.G_RET_STS_ERROR if error during validation
5793: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
5794: -- x_msg_count - Standard API parameter: The count of number of messages
5795: -- added to the message list in this call.
5796: -- x_msg_data - Standard API parameter: Contains error msg in case
5797: -- x_return_status is returned as FND_API.G_RET_STS_ERROR
5798: -- or FND_API.G_RET_STS_UNEXP_ERROR.
5792: -- (b) FND_API.G_RET_STS_ERROR if error during validation
5793: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
5794: -- x_msg_count - Standard API parameter: The count of number of messages
5795: -- added to the message list in this call.
5796: -- x_msg_data - Standard API parameter: Contains error msg in case
5797: -- x_return_status is returned as FND_API.G_RET_STS_ERROR
5798: -- or FND_API.G_RET_STS_UNEXP_ERROR.
5799: --Notes : None
5800: --
5809: p_start_date IN DATE,
5810: p_deliver_to_loc_id IN NUMBER,
5811: p_destination_org_id IN NUMBER,
5812: p_api_version IN NUMBER,
5813: -- Bug# 3404477: Follow the API standards
5814: p_init_msg_list IN VARCHAR2,
5815: x_vendor_id OUT NOCOPY po_tbl_number,
5816: x_vendor_site_id OUT NOCOPY po_tbl_number,
5817: x_vendor_contact_id OUT NOCOPY po_tbl_number,
6128: -- Bug# 3404477: Return msg count and data
6129: x_msg_count := 0;
6130: x_msg_data := NULL;
6131:
6132: -- Bug# 3404477: Follow the API standards
6133: IF FND_API.to_boolean(p_init_msg_list) THEN
6134: -- initialize message list
6135: FND_MSG_PUB.initialize;
6136: END IF;
6821: -- Determines whether or not contract agreements can be sourced to
6822: -- Parameters:
6823: -- IN:
6824: -- p_destination_doc_type:
6825: -- Valid values are 'PO','REQ','STANDARD PO','REQ_NONCATALOG'and NULL
6826: -- p_document_type_code:
6827: -- Valid value is 'REQUISITION'
6828: -- p_document_subtype:
6829: -- Valid value is 'PURCHASE'