eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.MTL_PARAMETERS_PKG dependencies on FND_API

Line 1254: 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))

1250: AND(NVL(recinfo.borrpay_osp_var_account, -1) = NVL(x_borrpay_osp_var_account, -1))
1251: AND(NVL(recinfo.borrpay_ovh_var_account, -1) = NVL(x_borrpay_ovh_var_account, -1))
1252: AND(NVL(recinfo.org_max_weight, -1) = NVL(x_org_max_weight, -1))
1253: AND(NVL(recinfo.org_max_volume, -1) = NVL(x_org_max_volume, -1))
1254: 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))
1255: 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))
1256: AND(NVL(recinfo.mo_source_required, -1) = NVL(x_mo_source_required, -1))
1257: AND(NVL(recinfo.mo_pick_confirm_required, -1) = NVL(x_mo_pick_confirm_required, -1))
1258: AND(NVL(recinfo.mo_approval_timeout_action, -1) = NVL(x_mo_approval_timeout_action, -1))

Line 1255: 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))

1251: AND(NVL(recinfo.borrpay_ovh_var_account, -1) = NVL(x_borrpay_ovh_var_account, -1))
1252: AND(NVL(recinfo.org_max_weight, -1) = NVL(x_org_max_weight, -1))
1253: AND(NVL(recinfo.org_max_volume, -1) = NVL(x_org_max_volume, -1))
1254: 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))
1255: 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))
1256: AND(NVL(recinfo.mo_source_required, -1) = NVL(x_mo_source_required, -1))
1257: AND(NVL(recinfo.mo_pick_confirm_required, -1) = NVL(x_mo_pick_confirm_required, -1))
1258: AND(NVL(recinfo.mo_approval_timeout_action, -1) = NVL(x_mo_approval_timeout_action, -1))
1259: --)

Line 1906: x_return_status := fnd_api.g_ret_sts_success;

1902: resource_busy EXCEPTION;
1903: PRAGMA EXCEPTION_INIT(resource_busy, -00054);
1904: j NUMBER := NULL;
1905: BEGIN
1906: x_return_status := fnd_api.g_ret_sts_success;
1907:
1908: SELECT ROWID
1909: BULK COLLECT INTO ROWS
1910: FROM mtl_secondary_inventories

Line 1934: x_return_status := fnd_api.g_ret_sts_success;

1930: --encumbrance_account = p_Encumbrance_Account
1931: WHERE ROWID = ROWS(j);
1932: END IF;
1933:
1934: x_return_status := fnd_api.g_ret_sts_success;
1935: EXCEPTION
1936: WHEN resource_busy THEN
1937: x_return_status := fnd_api.g_ret_sts_error;
1938: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1937: x_return_status := fnd_api.g_ret_sts_error;

1933:
1934: x_return_status := fnd_api.g_ret_sts_success;
1935: EXCEPTION
1936: WHEN resource_busy THEN
1937: x_return_status := fnd_api.g_ret_sts_error;
1938: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1939: WHEN NO_DATA_FOUND THEN
1940: x_return_status := fnd_api.g_ret_sts_success;
1941: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1940: x_return_status := fnd_api.g_ret_sts_success;

1936: WHEN resource_busy THEN
1937: x_return_status := fnd_api.g_ret_sts_error;
1938: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1939: WHEN NO_DATA_FOUND THEN
1940: x_return_status := fnd_api.g_ret_sts_success;
1941: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1942: WHEN fnd_api.g_exc_error THEN
1943: x_return_status := fnd_api.g_ret_sts_error;
1944: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1942: WHEN fnd_api.g_exc_error THEN

1938: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1939: WHEN NO_DATA_FOUND THEN
1940: x_return_status := fnd_api.g_ret_sts_success;
1941: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1942: WHEN fnd_api.g_exc_error THEN
1943: x_return_status := fnd_api.g_ret_sts_error;
1944: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1945: WHEN fnd_api.g_exc_unexpected_error THEN
1946: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1943: x_return_status := fnd_api.g_ret_sts_error;

1939: WHEN NO_DATA_FOUND THEN
1940: x_return_status := fnd_api.g_ret_sts_success;
1941: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1942: WHEN fnd_api.g_exc_error THEN
1943: x_return_status := fnd_api.g_ret_sts_error;
1944: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1945: WHEN fnd_api.g_exc_unexpected_error THEN
1946: x_return_status := fnd_api.g_ret_sts_unexp_error;
1947: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1945: WHEN fnd_api.g_exc_unexpected_error THEN

1941: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1942: WHEN fnd_api.g_exc_error THEN
1943: x_return_status := fnd_api.g_ret_sts_error;
1944: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1945: WHEN fnd_api.g_exc_unexpected_error THEN
1946: x_return_status := fnd_api.g_ret_sts_unexp_error;
1947: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1948: WHEN OTHERS THEN
1949: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1946: x_return_status := fnd_api.g_ret_sts_unexp_error;

1942: WHEN fnd_api.g_exc_error THEN
1943: x_return_status := fnd_api.g_ret_sts_error;
1944: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1945: WHEN fnd_api.g_exc_unexpected_error THEN
1946: x_return_status := fnd_api.g_ret_sts_unexp_error;
1947: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1948: WHEN OTHERS THEN
1949: x_return_status := fnd_api.g_ret_sts_unexp_error;
1950:

Line 1949: x_return_status := fnd_api.g_ret_sts_unexp_error;

1945: WHEN fnd_api.g_exc_unexpected_error THEN
1946: x_return_status := fnd_api.g_ret_sts_unexp_error;
1947: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1948: WHEN OTHERS THEN
1949: x_return_status := fnd_api.g_ret_sts_unexp_error;
1950:
1951: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1952: fnd_msg_pub.add_exc_msg(g_pkg_name, 'MTL_PARAMETERS_PKG');
1953: END IF;

Line 1959: RETURN fnd_api.g_miss_num;

1955:
1956: FUNCTION get_miss_num
1957: RETURN NUMBER IS
1958: BEGIN
1959: RETURN fnd_api.g_miss_num;
1960: END;
1961:
1962: PROCEDURE default_pjm_rule_setup(
1963: x_return_status OUT NOCOPY VARCHAR2

Line 1972: x_return_status := fnd_api.g_ret_sts_success;

1968: strgy_assn_exist VARCHAR2(1) := 'N';
1969: l_stg_assignment_id NUMBER;
1970: --l_row_id ROWID;
1971: BEGIN
1972: x_return_status := fnd_api.g_ret_sts_success;
1973:
1974: -- Added by grao on 02 Dec, 2002 for the new Strrategy Assignment Matrix
1975: --
1976: BEGIN

Line 2044: WHEN fnd_api.g_exc_error THEN

2040: );
2041: --- End of new code
2042:
2043: EXCEPTION
2044: WHEN fnd_api.g_exc_error THEN
2045: x_return_status := fnd_api.g_ret_sts_error;
2046: WHEN fnd_api.g_exc_unexpected_error THEN
2047: x_return_status := fnd_api.g_ret_sts_unexp_error;
2048: WHEN OTHERS THEN

Line 2045: x_return_status := fnd_api.g_ret_sts_error;

2041: --- End of new code
2042:
2043: EXCEPTION
2044: WHEN fnd_api.g_exc_error THEN
2045: x_return_status := fnd_api.g_ret_sts_error;
2046: WHEN fnd_api.g_exc_unexpected_error THEN
2047: x_return_status := fnd_api.g_ret_sts_unexp_error;
2048: WHEN OTHERS THEN
2049: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2046: WHEN fnd_api.g_exc_unexpected_error THEN

2042:
2043: EXCEPTION
2044: WHEN fnd_api.g_exc_error THEN
2045: x_return_status := fnd_api.g_ret_sts_error;
2046: WHEN fnd_api.g_exc_unexpected_error THEN
2047: x_return_status := fnd_api.g_ret_sts_unexp_error;
2048: WHEN OTHERS THEN
2049: x_return_status := fnd_api.g_ret_sts_unexp_error;
2050: END default_pjm_rule_setup;

Line 2047: x_return_status := fnd_api.g_ret_sts_unexp_error;

2043: EXCEPTION
2044: WHEN fnd_api.g_exc_error THEN
2045: x_return_status := fnd_api.g_ret_sts_error;
2046: WHEN fnd_api.g_exc_unexpected_error THEN
2047: x_return_status := fnd_api.g_ret_sts_unexp_error;
2048: WHEN OTHERS THEN
2049: x_return_status := fnd_api.g_ret_sts_unexp_error;
2050: END default_pjm_rule_setup;
2051:

Line 2049: x_return_status := fnd_api.g_ret_sts_unexp_error;

2045: x_return_status := fnd_api.g_ret_sts_error;
2046: WHEN fnd_api.g_exc_unexpected_error THEN
2047: x_return_status := fnd_api.g_ret_sts_unexp_error;
2048: WHEN OTHERS THEN
2049: x_return_status := fnd_api.g_ret_sts_unexp_error;
2050: END default_pjm_rule_setup;
2051:
2052: FUNCTION g_ret_sts_success
2053: RETURN VARCHAR2 IS

Line 2055: RETURN fnd_api.g_ret_sts_success;

2051:
2052: FUNCTION g_ret_sts_success
2053: RETURN VARCHAR2 IS
2054: BEGIN
2055: RETURN fnd_api.g_ret_sts_success;
2056: END;
2057: END mtl_parameters_pkg;