DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_DOC dependencies on FND_API

Line 1962: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;

1958: x_suggested_buyer_id number;
1959: x_progress varchar2(300);
1960:
1961: -- bug2821542
1962: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
1963:
1964: begin
1965:
1966: x_suggested_buyer_id := po_wf_util_pkg.GetItemAttrNumber

Line 1978: l_validate_result = FND_API.G_FALSE) then -- bug2821542

1974: x_result => l_validate_result);
1975: END IF;
1976:
1977: if (x_suggested_buyer_id is NULL OR
1978: l_validate_result = FND_API.G_FALSE) then -- bug2821542
1979:
1980: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
1981:
1982: x_progress:= '10: get_buyer_from_req_line: result = ACTION_FAILED';

Line 2025: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;

2021: x_org_id number;
2022: x_progress varchar2(300);
2023:
2024: -- bug2821542
2025: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
2026: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE; --
2027:
2028: begin
2029:

Line 2077: l_validate_result = FND_API.G_FALSE) then -- bug2821542

2073: x_result => l_validate_result);
2074: END IF;
2075:
2076: if (x_buyer_id is NULL OR
2077: l_validate_result = FND_API.G_FALSE) then -- bug2821542
2078:
2079: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
2080:
2081: x_progress:='10: get_buyer_from_item: result = ACTION_FAILED';

Line 2127: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;

2123: x_agent_id number := null;
2124: x_progress varchar2(300);
2125:
2126: -- bug2821542
2127: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
2128:
2129: begin
2130:
2131: x_category_id := po_wf_util_pkg.GetItemAttrNumber

Line 2232: l_validate_result = FND_API.G_FALSE) then -- bug2821542

2228: x_result => l_validate_result);
2229: END IF;
2230:
2231: if (x_agent_id is NULL OR
2232: l_validate_result = FND_API.G_FALSE) then -- bug2821542
2233:
2234: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
2235:
2236: x_progress := '30:get_buyer_from_category: result = ACTION_FAILED';

Line 2285: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;

2281: x_agent_id number := null;
2282: x_progress varchar2(300);
2283:
2284: -- bug2821542
2285: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
2286:
2287: begin
2288:
2289: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText

Line 2333: l_validate_result = FND_API.G_FALSE) then -- bug2821542

2329: x_result => l_validate_result);
2330: END IF;
2331:
2332: if (x_agent_id is NULL OR
2333: l_validate_result = FND_API.G_FALSE) then -- bug2821542
2334:
2335: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
2336:
2337: x_progress := '30:get_buyer_from_source_doc: result = ACTION_FAILED';

Line 2383: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;

2379: x_agent_id number;
2380: x_progress VARCHAR2(300);
2381:
2382: -- bug2821542
2383: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
2384:
2385: begin
2386:
2387: x_contract_id := po_wf_util_pkg.GetItemAttrNumber

Line 2419: l_validate_result = FND_API.G_FALSE) then -- bug2821542

2415: x_result => l_validate_result);
2416: END IF;
2417:
2418: if (x_agent_id is NULL OR
2419: l_validate_result = FND_API.G_FALSE) then -- bug2821542
2420:
2421: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
2422:
2423: x_progress := '30:get_buyer_from_source_doc: result = ACTION_FAILED';

Line 3373: p_init_msg_list => fnd_api.g_true,

3369: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3370: END IF;
3371:
3372: PO_DOC_STYLE_PVT.style_validate_req_attrs(p_api_version => 1.0,
3373: p_init_msg_list => fnd_api.g_true,
3374: x_return_status => x_return_status,
3375: x_msg_count => x_msg_count,
3376: x_msg_data => x_msg_data,
3377: p_doc_style_id => c1_style_id,

Line 3384: if x_return_status <> FND_API.g_ret_sts_success THEN

3380: p_purchase_basis => c1_purchase_basis,
3381: p_destination_type => c1_dest_type_code,
3382: p_source => 'AUTOCREATE');
3383:
3384: if x_return_status <> FND_API.g_ret_sts_success THEN
3385: c1_valid_style := FALSE;
3386: end if;
3387: --
3388: --Set Style ID as 1 if P card is used and source doc or cotract are not there

Line 3564: p_init_msg_list => fnd_api.g_true,

3560: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3561: END IF;
3562:
3563: PO_DOC_STYLE_PVT.style_validate_req_attrs(p_api_version => 1.0,
3564: p_init_msg_list => fnd_api.g_true,
3565: x_return_status => x_return_status,
3566: x_msg_count => x_msg_count,
3567: x_msg_data => x_msg_data,
3568: p_doc_style_id => c2_style_id,

Line 3575: if x_return_status <> FND_API.g_ret_sts_success THEN

3571: p_purchase_basis => c2_purchase_basis,
3572: p_destination_type => c2_dest_type_code,
3573: p_source => 'AUTOCREATE');
3574:
3575: if x_return_status <> FND_API.g_ret_sts_success THEN
3576: c2_valid_style := FALSE;
3577: end if;
3578: --
3579: --Set Style ID as 1 if P card is used and source doc or cotract are not there

Line 5462: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5458: p_po_release_id => l_po_release_id,
5459: x_return_status => l_return_status,
5460: p_calling_program => 'AUTOCREATED_DOC_WF');
5461:
5462: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5463: IF (g_po_wf_debug = 'Y') THEN
5464: po_wf_debug_pkg.insert_debug(itemtype,itemkey,'Tax Errored ');
5465: END IF;
5466: END IF;

Line 5470: if (x_auto_approve_doc = 'Y' AND l_return_status = FND_API.G_RET_STS_SUCCESS) then --

5466: END IF;
5467:
5468: --
5469:
5470: if (x_auto_approve_doc = 'Y' AND l_return_status = FND_API.G_RET_STS_SUCCESS) then --
5471:
5472: --Start of code changes for the bug 14243104 fix
5473: l_preparer_id := NULL;
5474: PO_VENDOR_SITES_SV.Get_Transmission_Defaults(

Line 7218: * x_result: FND_API.G_TRUE if validation suceeds

7214: * Requires: N/A
7215: * Modifies: N/A
7216: * Effects: Validates that p_agent_id is a valid buyer
7217: * Retunrs:
7218: * x_result: FND_API.G_TRUE if validation suceeds
7219: * FND_API.G_FALSE if validation fails
7220: */
7221:
7222: PROCEDURE validate_buyer (p_agent_id IN NUMBER,

Line 7219: * FND_API.G_FALSE if validation fails

7215: * Modifies: N/A
7216: * Effects: Validates that p_agent_id is a valid buyer
7217: * Retunrs:
7218: * x_result: FND_API.G_TRUE if validation suceeds
7219: * FND_API.G_FALSE if validation fails
7220: */
7221:
7222: PROCEDURE validate_buyer (p_agent_id IN NUMBER,
7223: x_result OUT NOCOPY VARCHAR2) IS

Line 7237: x_result := FND_API.G_TRUE;

7233: INTO l_result
7234: FROM po_buyers_v
7235: WHERE employee_id = p_agent_id;
7236:
7237: x_result := FND_API.G_TRUE;
7238: EXCEPTION
7239: WHEN NO_DATA_FOUND THEN
7240: x_result := FND_API.G_FALSE;
7241: WHEN OTHERS THEN

Line 7240: x_result := FND_API.G_FALSE;

7236:
7237: x_result := FND_API.G_TRUE;
7238: EXCEPTION
7239: WHEN NO_DATA_FOUND THEN
7240: x_result := FND_API.G_FALSE;
7241: WHEN OTHERS THEN
7242: x_result := FND_API.G_FALSE;
7243: WF_CORE.context('po_autocreate_doc','validate_buyer',l_progress);
7244: raise;

Line 7242: x_result := FND_API.G_FALSE;

7238: EXCEPTION
7239: WHEN NO_DATA_FOUND THEN
7240: x_result := FND_API.G_FALSE;
7241: WHEN OTHERS THEN
7242: x_result := FND_API.G_FALSE;
7243: WF_CORE.context('po_autocreate_doc','validate_buyer',l_progress);
7244: raise;
7245: END validate_buyer;
7246:

Line 7727: IF l_return_status = FND_API.G_RET_STS_SUCCESS

7723: x_return_status =>l_return_status,
7724: x_error_msg_name =>l_error_msg_name
7725: );
7726:
7727: IF l_return_status = FND_API.G_RET_STS_SUCCESS
7728: THEN
7729: x_progress := '10:ok_to_create_in_diff_ou: result = Y';
7730: resultout := wf_engine.eng_completed || ':' || 'Y';
7731: ELSE