DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_DOC dependencies on FND_API

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

1741: x_suggested_buyer_id number;
1742: x_progress varchar2(300);
1743:
1744: -- bug2821542
1745: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
1746:
1747: begin
1748:
1749: x_suggested_buyer_id := po_wf_util_pkg.GetItemAttrNumber

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

1757: x_result => l_validate_result);
1758: END IF;
1759:
1760: if (x_suggested_buyer_id is NULL OR
1761: l_validate_result = FND_API.G_FALSE) then -- bug2821542
1762:
1763: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
1764:
1765: x_progress:= '10: get_buyer_from_req_line: result = ACTION_FAILED';

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

1804: x_org_id number;
1805: x_progress varchar2(300);
1806:
1807: -- bug2821542
1808: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
1809: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE; --
1810:
1811: begin
1812:

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

1856: x_result => l_validate_result);
1857: END IF;
1858:
1859: if (x_buyer_id is NULL OR
1860: l_validate_result = FND_API.G_FALSE) then -- bug2821542
1861:
1862: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
1863:
1864: x_progress:='10: get_buyer_from_item: result = ACTION_FAILED';

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

1906: x_agent_id number := null;
1907: x_progress varchar2(300);
1908:
1909: -- bug2821542
1910: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
1911:
1912: begin
1913:
1914: x_category_id := po_wf_util_pkg.GetItemAttrNumber

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

2009: x_result => l_validate_result);
2010: END IF;
2011:
2012: if (x_agent_id is NULL OR
2013: l_validate_result = FND_API.G_FALSE) then -- bug2821542
2014:
2015: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
2016:
2017: x_progress := '30:get_buyer_from_category: result = ACTION_FAILED';

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

2062: x_agent_id number := null;
2063: x_progress varchar2(300);
2064:
2065: -- bug2821542
2066: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
2067:
2068: begin
2069:
2070: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText

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

2110: x_result => l_validate_result);
2111: END IF;
2112:
2113: if (x_agent_id is NULL OR
2114: l_validate_result = FND_API.G_FALSE) then -- bug2821542
2115:
2116: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
2117:
2118: x_progress := '30:get_buyer_from_source_doc: result = ACTION_FAILED';

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

2160: x_agent_id number;
2161: x_progress VARCHAR2(300);
2162:
2163: -- bug2821542
2164: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
2165:
2166: begin
2167:
2168: x_contract_id := po_wf_util_pkg.GetItemAttrNumber

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

2196: x_result => l_validate_result);
2197: END IF;
2198:
2199: if (x_agent_id is NULL OR
2200: l_validate_result = FND_API.G_FALSE) then -- bug2821542
2201:
2202: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
2203:
2204: x_progress := '30:get_buyer_from_source_doc: result = ACTION_FAILED';

Line 3123: p_init_msg_list => fnd_api.g_true,

3119: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3120: END IF;
3121:
3122: PO_DOC_STYLE_PVT.style_validate_req_attrs(p_api_version => 1.0,
3123: p_init_msg_list => fnd_api.g_true,
3124: x_return_status => x_return_status,
3125: x_msg_count => x_msg_count,
3126: x_msg_data => x_msg_data,
3127: p_doc_style_id => c1_style_id,

Line 3134: if x_return_status <> FND_API.g_ret_sts_success THEN

3130: p_purchase_basis => c1_purchase_basis,
3131: p_destination_type => c1_dest_type_code,
3132: p_source => 'AUTOCREATE');
3133:
3134: if x_return_status <> FND_API.g_ret_sts_success THEN
3135: c1_valid_style := FALSE;
3136: end if;
3137: --
3138: --Set Style ID as 1 if P card is used and source doc or cotract are not there

Line 3287: p_init_msg_list => fnd_api.g_true,

3283: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3284: END IF;
3285:
3286: PO_DOC_STYLE_PVT.style_validate_req_attrs(p_api_version => 1.0,
3287: p_init_msg_list => fnd_api.g_true,
3288: x_return_status => x_return_status,
3289: x_msg_count => x_msg_count,
3290: x_msg_data => x_msg_data,
3291: p_doc_style_id => c2_style_id,

Line 3298: if x_return_status <> FND_API.g_ret_sts_success THEN

3294: p_purchase_basis => c2_purchase_basis,
3295: p_destination_type => c2_dest_type_code,
3296: p_source => 'AUTOCREATE');
3297:
3298: if x_return_status <> FND_API.g_ret_sts_success THEN
3299: c2_valid_style := FALSE;
3300: end if;
3301: --
3302: --Set Style ID as 1 if P card is used and source doc or cotract are not there

Line 5113: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5109: p_po_release_id => l_po_release_id,
5110: x_return_status => l_return_status,
5111: p_calling_program => 'AUTOCREATED_DOC_WF');
5112:
5113: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5114: IF (g_po_wf_debug = 'Y') THEN
5115: po_wf_debug_pkg.insert_debug(itemtype,itemkey,'Tax Errored ');
5116: END IF;
5117: END IF;

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

5117: END IF;
5118:
5119: --
5120:
5121: if (x_auto_approve_doc = 'Y' AND l_return_status = FND_API.G_RET_STS_SUCCESS) then --
5122: resultout := wf_engine.eng_completed || ':' || 'Y';
5123:
5124: x_progress:= '10: should_doc_be_approved: result = Y';
5125: IF (g_po_wf_debug = 'Y') THEN

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

6762: * Requires: N/A
6763: * Modifies: N/A
6764: * Effects: Validates that p_agent_id is a valid buyer
6765: * Retunrs:
6766: * x_result: FND_API.G_TRUE if validation suceeds
6767: * FND_API.G_FALSE if validation fails
6768: */
6769:
6770: PROCEDURE validate_buyer (p_agent_id IN NUMBER,

Line 6767: * FND_API.G_FALSE if validation fails

6763: * Modifies: N/A
6764: * Effects: Validates that p_agent_id is a valid buyer
6765: * Retunrs:
6766: * x_result: FND_API.G_TRUE if validation suceeds
6767: * FND_API.G_FALSE if validation fails
6768: */
6769:
6770: PROCEDURE validate_buyer (p_agent_id IN NUMBER,
6771: x_result OUT NOCOPY VARCHAR2) IS

Line 6785: x_result := FND_API.G_TRUE;

6781: INTO l_result
6782: FROM po_buyers_val_v
6783: WHERE employee_id = p_agent_id;
6784:
6785: x_result := FND_API.G_TRUE;
6786: EXCEPTION
6787: WHEN NO_DATA_FOUND THEN
6788: x_result := FND_API.G_FALSE;
6789: WHEN OTHERS THEN

Line 6788: x_result := FND_API.G_FALSE;

6784:
6785: x_result := FND_API.G_TRUE;
6786: EXCEPTION
6787: WHEN NO_DATA_FOUND THEN
6788: x_result := FND_API.G_FALSE;
6789: WHEN OTHERS THEN
6790: x_result := FND_API.G_FALSE;
6791: WF_CORE.context('po_autocreate_doc','validate_buyer',l_progress);
6792: raise;

Line 6790: x_result := FND_API.G_FALSE;

6786: EXCEPTION
6787: WHEN NO_DATA_FOUND THEN
6788: x_result := FND_API.G_FALSE;
6789: WHEN OTHERS THEN
6790: x_result := FND_API.G_FALSE;
6791: WF_CORE.context('po_autocreate_doc','validate_buyer',l_progress);
6792: raise;
6793: END validate_buyer;
6794:

Line 7274: IF l_return_status = FND_API.G_RET_STS_SUCCESS

7270: x_return_status =>l_return_status,
7271: x_error_msg_name =>l_error_msg_name
7272: );
7273:
7274: IF l_return_status = FND_API.G_RET_STS_SUCCESS
7275: THEN
7276: x_progress := '10:ok_to_create_in_diff_ou: result = Y';
7277: resultout := wf_engine.eng_completed || ':' || 'Y';
7278: ELSE