DBA Data[Home] [Help]

APPS.OZF_FUND_APPROVAL_PVT dependencies on FND_API

Line 1261: IF l_return_status = fnd_api.g_ret_sts_success THEN

1257: x_approval_detail_id=> l_approval_detail_id,
1258: x_approver_seq=> l_approver_seq,
1259: x_return_status=> l_return_status
1260: );
1261: IF l_return_status = fnd_api.g_ret_sts_success THEN
1262: /* AMS_GEN_APPROVAL_PVT.Get_User_Name
1263: ( p_user_id => l_object_details.owner_id,
1264: x_full_name => l_full_name,
1265: x_return_status => l_return_status );

Line 1395: p_encoded=> fnd_api.g_false,

1391: /* End of Addition for Bug#2352621*/
1392: resultout := 'COMPLETE:SUCCESS';
1393: ELSE
1394: fnd_msg_pub.count_and_get (
1395: p_encoded=> fnd_api.g_false,
1396: p_count=> l_msg_count,
1397: p_data=> l_msg_data
1398: );
1399: ams_gen_approval_pvt.handle_err (

Line 1415: -- RAISE FND_API.G_EXC_ERROR;

1411: itemkey,
1412: actid,
1413: l_error_msg
1414: );
1415: -- RAISE FND_API.G_EXC_ERROR;
1416: resultout := 'COMPLETE:ERROR';
1417: END IF;
1418: END IF;
1419: --

Line 1435: WHEN fnd_api.g_exc_error THEN

1431: RETURN;
1432: END IF;
1433: --
1434: EXCEPTION
1435: WHEN fnd_api.g_exc_error THEN
1436: wf_core.context (
1437: 'AMS_FundApproval_pvt',
1438: 'Set_ParBudget_Activity_Details',
1439: itemtype,

Line 1448: p_encoded=> fnd_api.g_false,

1444: );
1445: RAISE;
1446: WHEN OTHERS THEN
1447: fnd_msg_pub.count_and_get (
1448: p_encoded=> fnd_api.g_false,
1449: p_count=> l_msg_count,
1450: p_data=> l_msg_data
1451: );
1452: RAISE;

Line 1541: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

1537: resultout OUT NOCOPY VARCHAR2
1538: ) IS
1539: l_status_code VARCHAR2 (30);
1540: l_api_version CONSTANT NUMBER := 1.0;
1541: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
1542: l_msg_count NUMBER;
1543: l_msg_data VARCHAR2 (4000);
1544: l_api_name CONSTANT VARCHAR2 (30) := 'Update_ParBudget_Status';
1545: l_full_name CONSTANT VARCHAR2 (60) := g_pkg_name

Line 1555: l_validation_level NUMBER := fnd_api.g_valid_level_full;

1551: l_update_status VARCHAR2 (12);
1552: l_error_msg VARCHAR2 (4000);
1553: l_object_version_number NUMBER;
1554: l_fund_id NUMBER;
1555: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1556: l_approver VARCHAR2(320);
1557: l_text_value VARCHAR2(2000);
1558: l_number_value NUMBER;
1559: l_requested_amt NUMBER;

Line 1666: p_encoded => fnd_api.g_false

1662: ,aname => 'UPDATE_GEN_STATUS'
1663: ,avalue => l_update_status
1664: );
1665: FND_MSG_PUB.count_and_get (
1666: p_encoded => fnd_api.g_false
1667: ,p_count => l_msg_count
1668: ,p_data => l_msg_data
1669: );
1670: AMS_GEN_APPROVAL_PVT.handle_err(

Line 1788: l_validation_level := fnd_api.g_valid_level_none;

1784: l_next_status_id := wf_engine.GetItemAttrNumber(
1785: itemtype => itemtype,
1786: itemkey => itemkey,
1787: aname => 'AMS_ORIG_STAT_ID' );
1788: l_validation_level := fnd_api.g_valid_level_none;
1789: END IF;
1790: -- x_return_status := fnd_api.g_ret_sts_success;
1791: l_status_code :=
1792: ozf_utility_pvt.get_system_status_code (l_next_status_id);

Line 1790: -- x_return_status := fnd_api.g_ret_sts_success;

1786: itemkey => itemkey,
1787: aname => 'AMS_ORIG_STAT_ID' );
1788: l_validation_level := fnd_api.g_valid_level_none;
1789: END IF;
1790: -- x_return_status := fnd_api.g_ret_sts_success;
1791: l_status_code :=
1792: ozf_utility_pvt.get_system_status_code (l_next_status_id);
1793: l_fund_rec.fund_id := l_fund_id;
1794: l_fund_rec.user_status_id := l_next_status_id;

Line 1808: p_init_msg_list=> fnd_api.g_false,

1804: );
1805: END IF;
1806: ozf_funds_pvt.update_fund (
1807: p_api_version=> l_api_version,
1808: p_init_msg_list=> fnd_api.g_false,
1809: p_validation_level => l_validation_level,
1810: x_return_status=> l_return_status,
1811: x_msg_count=> l_msg_count,
1812: x_msg_data=> l_msg_data,

Line 1816: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1812: x_msg_data=> l_msg_data,
1813: p_fund_rec=> l_fund_rec,
1814: p_mode=> g_fund_mode
1815: );
1816: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1817: IF G_DEBUG THEN
1818: ozf_utility_pvt.debug_message(l_full_name || ' failed to update fund to status ' || l_status_code);
1819: END IF;
1820: ams_gen_approval_pvt.handle_err (

Line 1848: p_encoded=> fnd_api.g_false,

1844: resultout := 'COMPLETE:';
1845: RETURN;
1846: END IF;
1847: fnd_msg_pub.count_and_get (
1848: p_encoded=> fnd_api.g_false,
1849: p_count=> l_msg_count,
1850: p_data=> l_msg_data
1851: );
1852: IF G_DEBUG THEN

Line 1861: -- x_return_status := fnd_api.g_ret_sts_error;

1857: );
1858: END IF;
1859: EXCEPTION
1860: WHEN OTHERS THEN
1861: -- x_return_status := fnd_api.g_ret_sts_error;
1862: ROLLBACK TO update_parbudget_status ;
1863: resultout := 'COMPLETE:ERROR';
1864: fnd_msg_pub.count_and_get (
1865: p_encoded=> fnd_api.g_false,

Line 1865: p_encoded=> fnd_api.g_false,

1861: -- x_return_status := fnd_api.g_ret_sts_error;
1862: ROLLBACK TO update_parbudget_status ;
1863: resultout := 'COMPLETE:ERROR';
1864: fnd_msg_pub.count_and_get (
1865: p_encoded=> fnd_api.g_false,
1866: p_count=> l_msg_count,
1867: p_data=> l_msg_data
1868: );
1869: ams_gen_approval_pvt.handle_err (

Line 1890: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

1886: resultout OUT NOCOPY VARCHAR2
1887: ) IS
1888: l_status_code VARCHAR2 (30);
1889: l_api_version CONSTANT NUMBER := 1.0;
1890: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
1891: l_msg_count NUMBER;
1892: l_msg_data VARCHAR2 (4000);
1893: l_api_name CONSTANT VARCHAR2 (30) := 'Update_ParBudget_Status';
1894: l_full_name CONSTANT VARCHAR2 (60) := g_pkg_name

Line 1918: -- x_return_status := fnd_api.g_ret_sts_success;

1914: itemtype=> itemtype,
1915: itemkey=> itemkey,
1916: aname => 'AMS_ACTIVITY_ID'
1917: );
1918: -- x_return_status := fnd_api.g_ret_sts_success;
1919: l_status_code :=
1920: ozf_utility_pvt.get_system_status_code (2100);
1921: ozf_funds_pvt.init_fund_rec (x_fund_rec => l_fund_rec);
1922: l_fund_rec.fund_id := l_fund_id;

Line 1937: p_init_msg_list=> fnd_api.g_false,

1933: );
1934: END IF;
1935: ozf_funds_pvt.update_fund (
1936: p_api_version=> l_api_version,
1937: p_init_msg_list=> fnd_api.g_false,
1938: x_return_status=> l_return_status,
1939: x_msg_count=> l_msg_count,
1940: x_msg_data=> l_msg_data,
1941: p_fund_rec=> l_fund_rec,

Line 1944: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1940: x_msg_data=> l_msg_data,
1941: p_fund_rec=> l_fund_rec,
1942: p_mode=> g_fund_mode
1943: );
1944: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1945: ams_gen_approval_pvt.handle_err (
1946: p_itemtype=> itemtype,
1947: p_itemkey=> itemkey,
1948: p_msg_count=> l_msg_count, -- Number of error Messages

Line 1969: p_encoded=> fnd_api.g_false,

1965: resultout := 'COMPLETE:';
1966: RETURN;
1967: END IF;
1968: fnd_msg_pub.count_and_get (
1969: p_encoded=> fnd_api.g_false,
1970: p_count=> l_msg_count,
1971: p_data=> l_msg_data
1972: );
1973: IF G_DEBUG THEN

Line 1982: -- x_return_status := fnd_api.g_ret_sts_error;

1978: );
1979: END IF;
1980: EXCEPTION
1981: WHEN OTHERS THEN
1982: -- x_return_status := fnd_api.g_ret_sts_error;
1983: fnd_msg_pub.count_and_get (
1984: p_encoded=> fnd_api.g_false,
1985: p_count=> l_msg_count,
1986: p_data=> l_msg_data

Line 1984: p_encoded=> fnd_api.g_false,

1980: EXCEPTION
1981: WHEN OTHERS THEN
1982: -- x_return_status := fnd_api.g_ret_sts_error;
1983: fnd_msg_pub.count_and_get (
1984: p_encoded=> fnd_api.g_false,
1985: p_count=> l_msg_count,
1986: p_data=> l_msg_data
1987: );
1988: RAISE;

Line 2029: x_return_status := fnd_api.g_ret_sts_success;

2025: AND ozf1.fund_id = p_fund_id;
2026: l_fund_id NUMBER;
2027: l_fund_owner_id NUMBER;
2028: BEGIN
2029: x_return_status := fnd_api.g_ret_sts_success;
2030: l_fund_id :=
2031: wf_engine.getitemattrnumber (
2032: itemtype=> itemtype,
2033: itemkey=> itemkey,

Line 2044: x_return_status := fnd_api.g_ret_sts_error;

2040: x_approver_id := l_fund_owner_id;
2041: END IF;
2042: EXCEPTION
2043: WHEN OTHERS THEN
2044: x_return_status := fnd_api.g_ret_sts_error;
2045: RAISE;
2046: END get_fund_parent_owner;
2047: END ozf_fund_approval_pvt;