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 981: X_return_status := FND_API.g_ret_sts_success;

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

Line 1089: X_return_status := FND_API.g_ret_sts_error;

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

Line 1107: X_return_status := FND_API.g_ret_sts_error;

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

Line 1124: X_return_status := FND_API.g_ret_sts_error;

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

Line 1131: X_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 1200: X_return_status := FND_API.g_ret_sts_success;

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

Line 1291: X_return_status := FND_API.g_ret_sts_error;

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

Line 1309: X_return_status := FND_API.g_ret_sts_error;

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

Line 1323: X_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 1390: X_return_status := FND_API.g_ret_sts_success;

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

Line 1477: X_return_status := FND_API.g_ret_sts_error;

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

Line 1495: X_return_status := FND_API.g_ret_sts_error;

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

Line 1509: X_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 1585: X_return_status := FND_API.g_ret_sts_success;

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

Line 1759: X_return_status := FND_API.g_ret_sts_error;

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

Line 1777: X_return_status := FND_API.g_ret_sts_error;

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

Line 1797: X_return_status := FND_API.g_ret_sts_error;

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

Line 1811: X_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 1893: X_return_status := FND_API.g_ret_sts_success;

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

Line 1996: X_return_status := FND_API.g_ret_sts_error;

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

Line 2006: X_return_status := FND_API.g_ret_sts_error;

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

Line 2011: X_return_status := FND_API.g_ret_sts_error;

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

Line 2025: X_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 2075: X_return_status := FND_API.g_ret_sts_success;

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

Line 2162: X_return_status := FND_API.g_ret_sts_error;

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

Line 2172: X_return_status := FND_API.g_ret_sts_error;

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

Line 2186: X_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 2213: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 2273: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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