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.

APPS.GMD_ERES_UTILS dependencies on FND_API

Line 979: X_return_status := FND_API.g_ret_sts_success;

975: --End of Declaration for Bug# 3497522
976:
977: BEGIN
978: SAVEPOINT update_formula;
979: X_return_status := FND_API.g_ret_sts_success;
980:
981: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORMULA');
982: l_object_type := FND_MESSAGE.GET;
983:

Line 1087: X_return_status := FND_API.g_ret_sts_error;

1083: EXCEPTION
1084: WHEN PENDING_STATUS_ERR OR
1085: REWORK_STATUS_ERR THEN
1086: ROLLBACK TO SAVEPOINT update_formula;
1087: X_return_status := FND_API.g_ret_sts_error;
1088: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1089: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1090: l_text := FND_MESSAGE.GET;
1091: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');

Line 1105: X_return_status := FND_API.g_ret_sts_error;

1101: FND_MSG_PUB.add;
1102: END IF;
1103: WHEN app_exception.record_lock_exception THEN
1104: ROLLBACK TO SAVEPOINT update_formula;
1105: X_return_status := FND_API.g_ret_sts_error;
1106: IF (l_debug = 'Y') THEN
1107: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1108: END IF;
1109: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

Line 1122: X_return_status := FND_API.g_ret_sts_error;

1118: --Sriram.S Bug# 3497522 31-MAR-2004
1119: --Added this Exception for Update failure due to View access
1120: WHEN STATUS_UPDATE_FAILURE THEN
1121: ROLLBACK TO SAVEPOINT update_formula;
1122: X_return_status := FND_API.g_ret_sts_error;
1123: IF (l_debug = 'Y') THEN
1124: gmd_debug.put_line ('In GMDERESB.pls - Status update failure section');
1125: END IF;
1126:

Line 1129: X_return_status := FND_API.g_ret_sts_unexp_error;

1125: END IF;
1126:
1127: WHEN OTHERS THEN
1128: ROLLBACK TO SAVEPOINT update_formula;
1129: X_return_status := FND_API.g_ret_sts_unexp_error;
1130: OPEN Cur_get_desc;
1131: FETCH Cur_get_desc INTO l_replace_type_desc;
1132: CLOSE Cur_get_desc;
1133:

Line 1198: X_return_status := FND_API.g_ret_sts_success;

1194: PENDING_STATUS_ERR EXCEPTION;
1195: REWORK_STATUS_ERR EXCEPTION;
1196: BEGIN
1197: SAVEPOINT update_operation;
1198: X_return_status := FND_API.g_ret_sts_success;
1199:
1200: FND_MESSAGE.SET_NAME('GMD', 'GMD_OPERATION');
1201: l_object_type := FND_MESSAGE.GET;
1202:

Line 1289: X_return_status := FND_API.g_ret_sts_error;

1285: EXCEPTION
1286: WHEN PENDING_STATUS_ERR OR
1287: REWORK_STATUS_ERR THEN
1288: ROLLBACK TO SAVEPOINT update_operation;
1289: X_return_status := FND_API.g_ret_sts_error;
1290: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1291: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1292: l_text := FND_MESSAGE.GET;
1293: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');

Line 1307: X_return_status := FND_API.g_ret_sts_error;

1303: FND_MSG_PUB.add;
1304: END IF;
1305: WHEN app_exception.record_lock_exception THEN
1306: ROLLBACK TO SAVEPOINT update_operation;
1307: X_return_status := FND_API.g_ret_sts_error;
1308: IF (l_debug = 'Y') THEN
1309: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1310: END IF;
1311: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

Line 1321: X_return_status := FND_API.g_ret_sts_unexp_error;

1317: p_object_name||':'||p_object_version
1318: );
1319: WHEN OTHERS THEN
1320: ROLLBACK TO SAVEPOINT update_operation;
1321: X_return_status := FND_API.g_ret_sts_unexp_error;
1322: OPEN Cur_get_desc;
1323: FETCH Cur_get_desc INTO l_replace_type_desc;
1324: CLOSE Cur_get_desc;
1325:

Line 1388: X_return_status := FND_API.g_ret_sts_success;

1384: PENDING_STATUS_ERR EXCEPTION;
1385: REWORK_STATUS_ERR EXCEPTION;
1386: BEGIN
1387: SAVEPOINT update_routing;
1388: X_return_status := FND_API.g_ret_sts_success;
1389:
1390: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING');
1391: l_object_type := FND_MESSAGE.GET;
1392:

Line 1475: X_return_status := FND_API.g_ret_sts_error;

1471: EXCEPTION
1472: WHEN PENDING_STATUS_ERR OR
1473: REWORK_STATUS_ERR THEN
1474: ROLLBACK TO SAVEPOINT update_routing;
1475: X_return_status := FND_API.g_ret_sts_error;
1476: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1477: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1478: l_text := FND_MESSAGE.GET;
1479: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');

Line 1493: X_return_status := FND_API.g_ret_sts_error;

1489: FND_MSG_PUB.add;
1490: END IF;
1491: WHEN app_exception.record_lock_exception THEN
1492: ROLLBACK TO SAVEPOINT update_routing;
1493: X_return_status := FND_API.g_ret_sts_error;
1494: IF (l_debug = 'Y') THEN
1495: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1496: END IF;
1497: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

Line 1507: X_return_status := FND_API.g_ret_sts_unexp_error;

1503: p_object_name||':'||p_object_version
1504: );
1505: WHEN OTHERS THEN
1506: ROLLBACK TO SAVEPOINT update_routing;
1507: X_return_status := FND_API.g_ret_sts_unexp_error;
1508: OPEN Cur_get_desc;
1509: FETCH Cur_get_desc INTO l_replace_type_desc;
1510: CLOSE Cur_get_desc;
1511:

Line 1583: X_return_status := FND_API.g_ret_sts_success;

1579: REWORK_STATUS_ERR EXCEPTION;
1580: VR_ERES_REQ EXCEPTION;
1581: BEGIN
1582: SAVEPOINT update_recipe;
1583: X_return_status := FND_API.g_ret_sts_success;
1584:
1585: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE');
1586: l_object_type := FND_MESSAGE.GET;
1587:

Line 1757: X_return_status := FND_API.g_ret_sts_error;

1753: EXCEPTION
1754: WHEN PENDING_STATUS_ERR OR
1755: REWORK_STATUS_ERR THEN
1756: ROLLBACK TO SAVEPOINT update_recipe;
1757: X_return_status := FND_API.g_ret_sts_error;
1758: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1759: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1760: l_text := FND_MESSAGE.GET;
1761: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');

Line 1775: X_return_status := FND_API.g_ret_sts_error;

1771: FND_MSG_PUB.add;
1772: END IF;
1773: WHEN VR_ERES_REQ THEN
1774: ROLLBACK TO SAVEPOINT update_recipe;
1775: X_return_status := FND_API.g_ret_sts_error;
1776: FND_MESSAGE.SET_NAME('GMD', 'GMD_VLDT_APPR_REQD');
1777: FND_MESSAGE.SET_TOKEN('STATUS', l_to_status_desc);
1778: l_text := FND_MESSAGE.GET;
1779:

Line 1795: X_return_status := FND_API.g_ret_sts_error;

1791: FND_MSG_PUB.add;
1792: END IF;
1793: WHEN app_exception.record_lock_exception THEN
1794: ROLLBACK TO SAVEPOINT update_recipe;
1795: X_return_status := FND_API.g_ret_sts_error;
1796: IF (l_debug = 'Y') THEN
1797: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1798: END IF;
1799: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

Line 1809: X_return_status := FND_API.g_ret_sts_unexp_error;

1805: p_object_name||':'||p_object_version
1806: );
1807: WHEN OTHERS THEN
1808: ROLLBACK TO SAVEPOINT update_recipe;
1809: X_return_status := FND_API.g_ret_sts_unexp_error;
1810: OPEN Cur_get_desc;
1811: FETCH Cur_get_desc INTO l_replace_type_desc;
1812: CLOSE Cur_get_desc;
1813:

Line 1891: X_return_status := FND_API.g_ret_sts_success;

1887: REWORK_STATUS_ERR EXCEPTION;
1888: RECIPE_IS_INVALID EXCEPTION;
1889: BEGIN
1890: SAVEPOINT update_validity;
1891: X_return_status := FND_API.g_ret_sts_success;
1892:
1893: FND_MESSAGE.SET_NAME('GMD', 'GMD_VALIDITY');
1894: l_object_type := FND_MESSAGE.GET;
1895:

Line 1994: X_return_status := FND_API.g_ret_sts_error;

1990: EXCEPTION
1991: WHEN PENDING_STATUS_ERR OR
1992: REWORK_STATUS_ERR THEN
1993: ROLLBACK TO SAVEPOINT update_validity;
1994: X_return_status := FND_API.g_ret_sts_error;
1995: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1996: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1997:
1998: l_text := FND_MESSAGE.GET;

Line 2004: X_return_status := FND_API.g_ret_sts_error;

2000: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
2001: FND_MSG_PUB.add;
2002: WHEN RECIPE_IS_INVALID THEN
2003: ROLLBACK TO SAVEPOINT update_validity;
2004: X_return_status := FND_API.g_ret_sts_error;
2005: FND_MESSAGE.SET_NAME ('GMD', 'GMD_RECIPE_INFO');
2006: FND_MSG_PUB.ADD;
2007: WHEN app_exception.record_lock_exception THEN
2008: ROLLBACK TO SAVEPOINT update_validity;

Line 2009: X_return_status := FND_API.g_ret_sts_error;

2005: FND_MESSAGE.SET_NAME ('GMD', 'GMD_RECIPE_INFO');
2006: FND_MSG_PUB.ADD;
2007: WHEN app_exception.record_lock_exception THEN
2008: ROLLBACK TO SAVEPOINT update_validity;
2009: X_return_status := FND_API.g_ret_sts_error;
2010: IF (l_debug = 'Y') THEN
2011: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
2012: END IF;
2013: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

Line 2023: X_return_status := FND_API.g_ret_sts_unexp_error;

2019: P_validity_rule_id
2020: );
2021: WHEN OTHERS THEN
2022: ROLLBACK TO SAVEPOINT update_validity;
2023: X_return_status := FND_API.g_ret_sts_unexp_error;
2024: fnd_msg_pub.add_exc_msg ('GMD_ERES_UTILS', l_api_name);
2025: END update_validity_rule_status;
2026:
2027: /*###############################################################

Line 2073: X_return_status := FND_API.g_ret_sts_success;

2069: REWORK_STATUS_ERR EXCEPTION;
2070:
2071: BEGIN
2072: SAVEPOINT update_substitution;
2073: X_return_status := FND_API.g_ret_sts_success;
2074:
2075: SELECT 'x'
2076: INTO l_text
2077: FROM gmd_item_substitution_hdr_b

Line 2160: X_return_status := FND_API.g_ret_sts_error;

2156: EXCEPTION
2157: WHEN PENDING_STATUS_ERR OR
2158: REWORK_STATUS_ERR THEN
2159: ROLLBACK TO SAVEPOINT update_substitution;
2160: X_return_status := FND_API.g_ret_sts_error;
2161: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
2162: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
2163:
2164: l_text := FND_MESSAGE.GET;

Line 2170: X_return_status := FND_API.g_ret_sts_error;

2166: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
2167: FND_MSG_PUB.add;
2168: WHEN app_exception.record_lock_exception THEN
2169: ROLLBACK TO SAVEPOINT update_substitution;
2170: X_return_status := FND_API.g_ret_sts_error;
2171: IF (l_debug = 'Y') THEN
2172: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
2173: END IF;
2174: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

Line 2184: X_return_status := FND_API.g_ret_sts_unexp_error;

2180: P_substitution_id
2181: );
2182: WHEN OTHERS THEN
2183: ROLLBACK TO SAVEPOINT update_substitution;
2184: X_return_status := FND_API.g_ret_sts_unexp_error;
2185: fnd_msg_pub.add_exc_msg ('GMD_ERES_UTILS', l_api_name);
2186:
2187:
2188: END update_substitution_status;

Line 2211: l_return_status := FND_API.G_RET_STS_SUCCESS;

2207: X_recipe_tbl GMD_RECIPE_HEADER.recipe_hdr;
2208: X_recipe_flex GMD_RECIPE_HEADER.flex;
2209: l_return_status VARCHAR2(1);
2210: BEGIN
2211: l_return_status := FND_API.G_RET_STS_SUCCESS;
2212:
2213: gmd_api_grp.retrieve_recipe (
2214: p_formula_id => p_formula_id,
2215: l_recipe_tbl => X_recipe_tbl,

Line 2219: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2215: l_recipe_tbl => X_recipe_tbl,
2216: l_recipe_flex => X_recipe_flex,
2217: x_return_status => l_return_status);
2218:
2219: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2220: p_recipe_no := X_recipe_tbl.recipe_no;
2221: p_recipe_vers := X_recipe_tbl.recipe_version;
2222: p_recipe_desc := X_recipe_tbl.recipe_description;
2223: p_recipe_status := X_recipe_tbl.recipe_status;

Line 2271: l_return_status := FND_API.G_RET_STS_SUCCESS;

2267: WHERE lookup_type = 'GMD_FORMULA_USE'
2268: and lookup_code = V_lookup_code;
2269:
2270: BEGIN
2271: l_return_status := FND_API.G_RET_STS_SUCCESS;
2272:
2273: gmd_api_grp.retrieve_vr (
2274: p_formula_id => p_formula_id,
2275: l_recipe_vr_tbl => X_recipe_vr,

Line 2279: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2275: l_recipe_vr_tbl => X_recipe_vr,
2276: l_vr_flex => X_vr_flex,
2277: x_return_status => l_return_status );
2278:
2279: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2280: p_item_id := X_recipe_vr.inventory_item_id;
2281: p_revision := X_recipe_vr.revision; -- NPD Conv
2282: p_orgn_id := X_recipe_vr.organization_id; -- NPD Conv
2283: p_item_um := X_recipe_vr.detail_uom;