DBA Data[Home] [Help]

APPS.OZF_FUND_APPROVAL_PVT dependencies on FND_API

Line 1225: IF l_return_status = fnd_api.g_ret_sts_success THEN

1221: x_approval_detail_id=> l_approval_detail_id,
1222: x_approver_seq=> l_approver_seq,
1223: x_return_status=> l_return_status
1224: );
1225: IF l_return_status = fnd_api.g_ret_sts_success THEN
1226: /* AMS_GEN_APPROVAL_PVT.Get_User_Name
1227: ( p_user_id => l_object_details.owner_id,
1228: x_full_name => l_full_name,
1229: x_return_status => l_return_status );

Line 1359: p_encoded=> fnd_api.g_false,

1355: /* End of Addition for Bug#2352621*/
1356: resultout := 'COMPLETE:SUCCESS';
1357: ELSE
1358: fnd_msg_pub.count_and_get (
1359: p_encoded=> fnd_api.g_false,
1360: p_count=> l_msg_count,
1361: p_data=> l_msg_data
1362: );
1363: ams_gen_approval_pvt.handle_err (

Line 1379: -- RAISE FND_API.G_EXC_ERROR;

1375: itemkey,
1376: actid,
1377: l_error_msg
1378: );
1379: -- RAISE FND_API.G_EXC_ERROR;
1380: resultout := 'COMPLETE:ERROR';
1381: END IF;
1382: END IF;
1383: --

Line 1399: WHEN fnd_api.g_exc_error THEN

1395: RETURN;
1396: END IF;
1397: --
1398: EXCEPTION
1399: WHEN fnd_api.g_exc_error THEN
1400: wf_core.context (
1401: 'AMS_FundApproval_pvt',
1402: 'Set_ParBudget_Activity_Details',
1403: itemtype,

Line 1412: p_encoded=> fnd_api.g_false,

1408: );
1409: RAISE;
1410: WHEN OTHERS THEN
1411: fnd_msg_pub.count_and_get (
1412: p_encoded=> fnd_api.g_false,
1413: p_count=> l_msg_count,
1414: p_data=> l_msg_data
1415: );
1416: RAISE;

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

1501: resultout OUT NOCOPY VARCHAR2
1502: ) IS
1503: l_status_code VARCHAR2 (30);
1504: l_api_version CONSTANT NUMBER := 1.0;
1505: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
1506: l_msg_count NUMBER;
1507: l_msg_data VARCHAR2 (4000);
1508: l_api_name CONSTANT VARCHAR2 (30) := 'Update_ParBudget_Status';
1509: l_full_name CONSTANT VARCHAR2 (60) := g_pkg_name

Line 1519: l_validation_level NUMBER := fnd_api.g_valid_level_full;

1515: l_update_status VARCHAR2 (12);
1516: l_error_msg VARCHAR2 (4000);
1517: l_object_version_number NUMBER;
1518: l_fund_id NUMBER;
1519: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1520: l_approver VARCHAR2(320);
1521: l_text_value VARCHAR2(2000);
1522: l_number_value NUMBER;
1523: l_requested_amt NUMBER;

Line 1682: l_validation_level := fnd_api.g_valid_level_none;

1678: l_next_status_id := wf_engine.GetItemAttrNumber(
1679: itemtype => itemtype,
1680: itemkey => itemkey,
1681: aname => 'AMS_ORIG_STAT_ID' );
1682: l_validation_level := fnd_api.g_valid_level_none;
1683: END IF;
1684: -- x_return_status := fnd_api.g_ret_sts_success;
1685: l_status_code :=
1686: ozf_utility_pvt.get_system_status_code (l_next_status_id);

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

1680: itemkey => itemkey,
1681: aname => 'AMS_ORIG_STAT_ID' );
1682: l_validation_level := fnd_api.g_valid_level_none;
1683: END IF;
1684: -- x_return_status := fnd_api.g_ret_sts_success;
1685: l_status_code :=
1686: ozf_utility_pvt.get_system_status_code (l_next_status_id);
1687: l_fund_rec.fund_id := l_fund_id;
1688: l_fund_rec.user_status_id := l_next_status_id;

Line 1702: p_init_msg_list=> fnd_api.g_false,

1698: );
1699: END IF;
1700: ozf_funds_pvt.update_fund (
1701: p_api_version=> l_api_version,
1702: p_init_msg_list=> fnd_api.g_false,
1703: p_validation_level => l_validation_level,
1704: x_return_status=> l_return_status,
1705: x_msg_count=> l_msg_count,
1706: x_msg_data=> l_msg_data,

Line 1710: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1706: x_msg_data=> l_msg_data,
1707: p_fund_rec=> l_fund_rec,
1708: p_mode=> g_fund_mode
1709: );
1710: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1711: IF G_DEBUG THEN
1712: ozf_utility_pvt.debug_message(l_full_name || ' failed to update fund to status ' || l_status_code);
1713: END IF;
1714: ams_gen_approval_pvt.handle_err (

Line 1742: p_encoded=> fnd_api.g_false,

1738: resultout := 'COMPLETE:';
1739: RETURN;
1740: END IF;
1741: fnd_msg_pub.count_and_get (
1742: p_encoded=> fnd_api.g_false,
1743: p_count=> l_msg_count,
1744: p_data=> l_msg_data
1745: );
1746: IF G_DEBUG THEN

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

1751: );
1752: END IF;
1753: EXCEPTION
1754: WHEN OTHERS THEN
1755: -- x_return_status := fnd_api.g_ret_sts_error;
1756: ROLLBACK TO update_parbudget_status ;
1757: resultout := 'COMPLETE:ERROR';
1758: fnd_msg_pub.count_and_get (
1759: p_encoded=> fnd_api.g_false,

Line 1759: p_encoded=> fnd_api.g_false,

1755: -- x_return_status := fnd_api.g_ret_sts_error;
1756: ROLLBACK TO update_parbudget_status ;
1757: resultout := 'COMPLETE:ERROR';
1758: fnd_msg_pub.count_and_get (
1759: p_encoded=> fnd_api.g_false,
1760: p_count=> l_msg_count,
1761: p_data=> l_msg_data
1762: );
1763: ams_gen_approval_pvt.handle_err (

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

1780: resultout OUT NOCOPY VARCHAR2
1781: ) IS
1782: l_status_code VARCHAR2 (30);
1783: l_api_version CONSTANT NUMBER := 1.0;
1784: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
1785: l_msg_count NUMBER;
1786: l_msg_data VARCHAR2 (4000);
1787: l_api_name CONSTANT VARCHAR2 (30) := 'Update_ParBudget_Status';
1788: l_full_name CONSTANT VARCHAR2 (60) := g_pkg_name

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

1808: itemtype=> itemtype,
1809: itemkey=> itemkey,
1810: aname => 'AMS_ACTIVITY_ID'
1811: );
1812: -- x_return_status := fnd_api.g_ret_sts_success;
1813: l_status_code :=
1814: ozf_utility_pvt.get_system_status_code (2100);
1815: ozf_funds_pvt.init_fund_rec (x_fund_rec => l_fund_rec);
1816: l_fund_rec.fund_id := l_fund_id;

Line 1831: p_init_msg_list=> fnd_api.g_false,

1827: );
1828: END IF;
1829: ozf_funds_pvt.update_fund (
1830: p_api_version=> l_api_version,
1831: p_init_msg_list=> fnd_api.g_false,
1832: x_return_status=> l_return_status,
1833: x_msg_count=> l_msg_count,
1834: x_msg_data=> l_msg_data,
1835: p_fund_rec=> l_fund_rec,

Line 1838: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1834: x_msg_data=> l_msg_data,
1835: p_fund_rec=> l_fund_rec,
1836: p_mode=> g_fund_mode
1837: );
1838: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1839: ams_gen_approval_pvt.handle_err (
1840: p_itemtype=> itemtype,
1841: p_itemkey=> itemkey,
1842: p_msg_count=> l_msg_count, -- Number of error Messages

Line 1863: p_encoded=> fnd_api.g_false,

1859: resultout := 'COMPLETE:';
1860: RETURN;
1861: END IF;
1862: fnd_msg_pub.count_and_get (
1863: p_encoded=> fnd_api.g_false,
1864: p_count=> l_msg_count,
1865: p_data=> l_msg_data
1866: );
1867: IF G_DEBUG THEN

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

1872: );
1873: END IF;
1874: EXCEPTION
1875: WHEN OTHERS THEN
1876: -- x_return_status := fnd_api.g_ret_sts_error;
1877: fnd_msg_pub.count_and_get (
1878: p_encoded=> fnd_api.g_false,
1879: p_count=> l_msg_count,
1880: p_data=> l_msg_data

Line 1878: p_encoded=> fnd_api.g_false,

1874: EXCEPTION
1875: WHEN OTHERS THEN
1876: -- x_return_status := fnd_api.g_ret_sts_error;
1877: fnd_msg_pub.count_and_get (
1878: p_encoded=> fnd_api.g_false,
1879: p_count=> l_msg_count,
1880: p_data=> l_msg_data
1881: );
1882: RAISE;

Line 1923: x_return_status := fnd_api.g_ret_sts_success;

1919: AND ozf1.fund_id = p_fund_id;
1920: l_fund_id NUMBER;
1921: l_fund_owner_id NUMBER;
1922: BEGIN
1923: x_return_status := fnd_api.g_ret_sts_success;
1924: l_fund_id :=
1925: wf_engine.getitemattrnumber (
1926: itemtype=> itemtype,
1927: itemkey=> itemkey,

Line 1938: x_return_status := fnd_api.g_ret_sts_error;

1934: x_approver_id := l_fund_owner_id;
1935: END IF;
1936: EXCEPTION
1937: WHEN OTHERS THEN
1938: x_return_status := fnd_api.g_ret_sts_error;
1939: RAISE;
1940: END get_fund_parent_owner;
1941: END ozf_fund_approval_pvt;