DBA Data[Home] [Help]

APPS.MTL_PARAMETERS_PKG dependencies on FND_API

Line 1232: AND(NVL(recinfo.org_max_weight_uom_code, fnd_api.g_miss_char) = NVL(x_org_max_weight_uom_code, fnd_api.g_miss_char))

1228: AND(NVL(recinfo.borrpay_osp_var_account, -1) = NVL(x_borrpay_osp_var_account, -1))
1229: AND(NVL(recinfo.borrpay_ovh_var_account, -1) = NVL(x_borrpay_ovh_var_account, -1))
1230: AND(NVL(recinfo.org_max_weight, -1) = NVL(x_org_max_weight, -1))
1231: AND(NVL(recinfo.org_max_volume, -1) = NVL(x_org_max_volume, -1))
1232: AND(NVL(recinfo.org_max_weight_uom_code, fnd_api.g_miss_char) = NVL(x_org_max_weight_uom_code, fnd_api.g_miss_char))
1233: AND(NVL(recinfo.org_max_volume_uom_code, fnd_api.g_miss_char) = NVL(x_org_max_volume_uom_code, fnd_api.g_miss_char))
1234: AND(NVL(recinfo.mo_source_required, -1) = NVL(x_mo_source_required, -1))
1235: AND(NVL(recinfo.mo_pick_confirm_required, -1) = NVL(x_mo_pick_confirm_required, -1))
1236: AND(NVL(recinfo.mo_approval_timeout_action, -1) = NVL(x_mo_approval_timeout_action, -1))

Line 1233: AND(NVL(recinfo.org_max_volume_uom_code, fnd_api.g_miss_char) = NVL(x_org_max_volume_uom_code, fnd_api.g_miss_char))

1229: AND(NVL(recinfo.borrpay_ovh_var_account, -1) = NVL(x_borrpay_ovh_var_account, -1))
1230: AND(NVL(recinfo.org_max_weight, -1) = NVL(x_org_max_weight, -1))
1231: AND(NVL(recinfo.org_max_volume, -1) = NVL(x_org_max_volume, -1))
1232: AND(NVL(recinfo.org_max_weight_uom_code, fnd_api.g_miss_char) = NVL(x_org_max_weight_uom_code, fnd_api.g_miss_char))
1233: AND(NVL(recinfo.org_max_volume_uom_code, fnd_api.g_miss_char) = NVL(x_org_max_volume_uom_code, fnd_api.g_miss_char))
1234: AND(NVL(recinfo.mo_source_required, -1) = NVL(x_mo_source_required, -1))
1235: AND(NVL(recinfo.mo_pick_confirm_required, -1) = NVL(x_mo_pick_confirm_required, -1))
1236: AND(NVL(recinfo.mo_approval_timeout_action, -1) = NVL(x_mo_approval_timeout_action, -1))
1237: --)

Line 1875: x_return_status := fnd_api.g_ret_sts_success;

1871: resource_busy EXCEPTION;
1872: PRAGMA EXCEPTION_INIT(resource_busy, -00054);
1873: j NUMBER := NULL;
1874: BEGIN
1875: x_return_status := fnd_api.g_ret_sts_success;
1876:
1877: SELECT ROWID
1878: BULK COLLECT INTO ROWS
1879: FROM mtl_secondary_inventories

Line 1903: x_return_status := fnd_api.g_ret_sts_success;

1899: --encumbrance_account = p_Encumbrance_Account
1900: WHERE ROWID = ROWS(j);
1901: END IF;
1902:
1903: x_return_status := fnd_api.g_ret_sts_success;
1904: EXCEPTION
1905: WHEN resource_busy THEN
1906: x_return_status := fnd_api.g_ret_sts_error;
1907: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1906: x_return_status := fnd_api.g_ret_sts_error;

1902:
1903: x_return_status := fnd_api.g_ret_sts_success;
1904: EXCEPTION
1905: WHEN resource_busy THEN
1906: x_return_status := fnd_api.g_ret_sts_error;
1907: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1908: WHEN NO_DATA_FOUND THEN
1909: x_return_status := fnd_api.g_ret_sts_success;
1910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1909: x_return_status := fnd_api.g_ret_sts_success;

1905: WHEN resource_busy THEN
1906: x_return_status := fnd_api.g_ret_sts_error;
1907: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1908: WHEN NO_DATA_FOUND THEN
1909: x_return_status := fnd_api.g_ret_sts_success;
1910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1911: WHEN fnd_api.g_exc_error THEN
1912: x_return_status := fnd_api.g_ret_sts_error;
1913: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1911: WHEN fnd_api.g_exc_error THEN

1907: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1908: WHEN NO_DATA_FOUND THEN
1909: x_return_status := fnd_api.g_ret_sts_success;
1910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1911: WHEN fnd_api.g_exc_error THEN
1912: x_return_status := fnd_api.g_ret_sts_error;
1913: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1914: WHEN fnd_api.g_exc_unexpected_error THEN
1915: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1912: x_return_status := fnd_api.g_ret_sts_error;

1908: WHEN NO_DATA_FOUND THEN
1909: x_return_status := fnd_api.g_ret_sts_success;
1910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1911: WHEN fnd_api.g_exc_error THEN
1912: x_return_status := fnd_api.g_ret_sts_error;
1913: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1914: WHEN fnd_api.g_exc_unexpected_error THEN
1915: x_return_status := fnd_api.g_ret_sts_unexp_error;
1916: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1914: WHEN fnd_api.g_exc_unexpected_error THEN

1910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1911: WHEN fnd_api.g_exc_error THEN
1912: x_return_status := fnd_api.g_ret_sts_error;
1913: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1914: WHEN fnd_api.g_exc_unexpected_error THEN
1915: x_return_status := fnd_api.g_ret_sts_unexp_error;
1916: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1917: WHEN OTHERS THEN
1918: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1915: x_return_status := fnd_api.g_ret_sts_unexp_error;

1911: WHEN fnd_api.g_exc_error THEN
1912: x_return_status := fnd_api.g_ret_sts_error;
1913: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1914: WHEN fnd_api.g_exc_unexpected_error THEN
1915: x_return_status := fnd_api.g_ret_sts_unexp_error;
1916: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1917: WHEN OTHERS THEN
1918: x_return_status := fnd_api.g_ret_sts_unexp_error;
1919:

Line 1918: x_return_status := fnd_api.g_ret_sts_unexp_error;

1914: WHEN fnd_api.g_exc_unexpected_error THEN
1915: x_return_status := fnd_api.g_ret_sts_unexp_error;
1916: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1917: WHEN OTHERS THEN
1918: x_return_status := fnd_api.g_ret_sts_unexp_error;
1919:
1920: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1921: fnd_msg_pub.add_exc_msg(g_pkg_name, 'MTL_PARAMETERS_PKG');
1922: END IF;

Line 1928: RETURN fnd_api.g_miss_num;

1924:
1925: FUNCTION get_miss_num
1926: RETURN NUMBER IS
1927: BEGIN
1928: RETURN fnd_api.g_miss_num;
1929: END;
1930:
1931: PROCEDURE default_pjm_rule_setup(
1932: x_return_status OUT NOCOPY VARCHAR2

Line 1941: x_return_status := fnd_api.g_ret_sts_success;

1937: strgy_assn_exist VARCHAR2(1) := 'N';
1938: l_stg_assignment_id NUMBER;
1939: --l_row_id ROWID;
1940: BEGIN
1941: x_return_status := fnd_api.g_ret_sts_success;
1942:
1943: -- Added by grao on 02 Dec, 2002 for the new Strrategy Assignment Matrix
1944: --
1945: BEGIN

Line 2013: WHEN fnd_api.g_exc_error THEN

2009: );
2010: --- End of new code
2011:
2012: EXCEPTION
2013: WHEN fnd_api.g_exc_error THEN
2014: x_return_status := fnd_api.g_ret_sts_error;
2015: WHEN fnd_api.g_exc_unexpected_error THEN
2016: x_return_status := fnd_api.g_ret_sts_unexp_error;
2017: WHEN OTHERS THEN

Line 2014: x_return_status := fnd_api.g_ret_sts_error;

2010: --- End of new code
2011:
2012: EXCEPTION
2013: WHEN fnd_api.g_exc_error THEN
2014: x_return_status := fnd_api.g_ret_sts_error;
2015: WHEN fnd_api.g_exc_unexpected_error THEN
2016: x_return_status := fnd_api.g_ret_sts_unexp_error;
2017: WHEN OTHERS THEN
2018: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2015: WHEN fnd_api.g_exc_unexpected_error THEN

2011:
2012: EXCEPTION
2013: WHEN fnd_api.g_exc_error THEN
2014: x_return_status := fnd_api.g_ret_sts_error;
2015: WHEN fnd_api.g_exc_unexpected_error THEN
2016: x_return_status := fnd_api.g_ret_sts_unexp_error;
2017: WHEN OTHERS THEN
2018: x_return_status := fnd_api.g_ret_sts_unexp_error;
2019: END default_pjm_rule_setup;

Line 2016: x_return_status := fnd_api.g_ret_sts_unexp_error;

2012: EXCEPTION
2013: WHEN fnd_api.g_exc_error THEN
2014: x_return_status := fnd_api.g_ret_sts_error;
2015: WHEN fnd_api.g_exc_unexpected_error THEN
2016: x_return_status := fnd_api.g_ret_sts_unexp_error;
2017: WHEN OTHERS THEN
2018: x_return_status := fnd_api.g_ret_sts_unexp_error;
2019: END default_pjm_rule_setup;
2020:

Line 2018: x_return_status := fnd_api.g_ret_sts_unexp_error;

2014: x_return_status := fnd_api.g_ret_sts_error;
2015: WHEN fnd_api.g_exc_unexpected_error THEN
2016: x_return_status := fnd_api.g_ret_sts_unexp_error;
2017: WHEN OTHERS THEN
2018: x_return_status := fnd_api.g_ret_sts_unexp_error;
2019: END default_pjm_rule_setup;
2020:
2021: FUNCTION g_ret_sts_success
2022: RETURN VARCHAR2 IS

Line 2024: RETURN fnd_api.g_ret_sts_success;

2020:
2021: FUNCTION g_ret_sts_success
2022: RETURN VARCHAR2 IS
2023: BEGIN
2024: RETURN fnd_api.g_ret_sts_success;
2025: END;
2026: END mtl_parameters_pkg;