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_API_GRP dependencies on FND_API

Line 185: x_return_status := FND_API.G_RET_STS_SUCCESS;

181: context_value_required EXCEPTION;
182: context_not_existing EXCEPTION;
183: BEGIN
184: /* Set return status to success initially */
185: x_return_status := FND_API.G_RET_STS_SUCCESS;
186:
187: /* Package variables have been introduced to avoid unnecessary open */
188: /* of cursor and packages multiple times, as this pakage would be */
189: /* called in a loop in most of the scenarios */

Line 311: x_return_status := FND_API.G_RET_STS_ERROR;

307: CLOSE cur_column_values;
308: END IF; /* IF p_field_name = pkg_context_column_name */
309: EXCEPTION
310: WHEN flex_not_enabled THEN
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: gmd_api_grp.log_message (
313: 'GMD_FLEX_NOT_ENABLED'
314: ,'FLEX_NAME'
315: ,p_flex_field_name);

Line 321: x_return_status := FND_API.G_RET_STS_ERROR;

317: gmd_api_grp.log_message (
318: 'GMD_CONTEXT_VALUE_REQD'
319: ,'CONTEXT_NAME'
320: ,pkg_context_column_name);
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: WHEN context_not_existing THEN
323: gmd_api_grp.log_message (
324: 'GMD_NON_EXISTING_CONTEXT'
325: ,'CONTEXT_VALUE'

Line 327: x_return_status := FND_API.G_RET_STS_ERROR;

323: gmd_api_grp.log_message (
324: 'GMD_NON_EXISTING_CONTEXT'
325: ,'CONTEXT_VALUE'
326: ,p_field_value);
327: x_return_status := FND_API.G_RET_STS_ERROR;
328: WHEN column_not_defined THEN
329: x_return_status := FND_API.G_RET_STS_ERROR;
330: gmd_api_grp.log_message (
331: 'GMD_FLEX_COL_NOT_DEF'

Line 329: x_return_status := FND_API.G_RET_STS_ERROR;

325: ,'CONTEXT_VALUE'
326: ,p_field_value);
327: x_return_status := FND_API.G_RET_STS_ERROR;
328: WHEN column_not_defined THEN
329: x_return_status := FND_API.G_RET_STS_ERROR;
330: gmd_api_grp.log_message (
331: 'GMD_FLEX_COL_NOT_DEF'
332: ,'FLEX_NAME'
333: ,p_flex_field_name

Line 337: x_return_status := FND_API.G_RET_STS_ERROR;

333: ,p_flex_field_name
334: ,'COLUMN_NAME'
335: ,p_field_name);
336: WHEN field_value_required THEN
337: x_return_status := FND_API.G_RET_STS_ERROR;
338: gmd_api_grp.log_message (
339: 'GMD_FIELD_VALUE_REQUIRED'
340: ,'FIELD_NAME'
341: ,p_field_name);

Line 343: x_return_status := FND_API.G_RET_STS_ERROR;

339: 'GMD_FIELD_VALUE_REQUIRED'
340: ,'FIELD_NAME'
341: ,p_field_name);
342: WHEN validation_failure THEN
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: END validate_flex_field;
345:
346: /*************************************************************
347: Procedure

Line 385: x_return_status := FND_API.G_RET_STS_SUCCESS;

381: WHERE application_id = vAppl_id;
382:
383: BEGIN
384: /* Set return status to success initially */
385: x_return_status := FND_API.G_RET_STS_SUCCESS;
386: /* Let us fetch the field value first */
387: SELECT DECODE (
388: p_field_name,
389: 'ATTRIBUTE_CATEGORY', p_flex_record.attribute_category,

Line 449: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

445: x_field_value => l_storage_value,
446: x_return_status => x_return_status
447: );
448:
449: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
450: RAISE validation_failure;
451: END IF;
452:
453: IF ( l_debug IS NOT NULL ) THEN

Line 545: x_return_status := FND_API.G_RET_STS_SUCCESS;

541: ) IS
542: validation_failure EXCEPTION;
543: BEGIN
544: /* Initialize the return status to success */
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546: validate_flex_field (
547: p_table_name => p_table_name,
548: p_flex_record => p_flex_record,
549: p_field_name => 'ATTRIBUTE_CATEGORY',

Line 554: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

550: x_flex_record => x_flex_record,
551: x_return_status => x_return_status
552: );
553:
554: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
555: RAISE validation_failure;
556: END IF;
557:
558: FOR i IN 1 .. 30

Line 568: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

564: x_flex_record => x_flex_record,
565: x_return_status => x_return_status
566: );
567:
568: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
569: RAISE validation_failure;
570: END IF;
571: END LOOP;
572: EXCEPTION

Line 1624: x_return_status := FND_API.G_RET_STS_SUCCESS;

1620: l_recipe_vr_tbl.preference := l_preference;
1621: END IF;
1622: CLOSE c_get_recipe_info;
1623:
1624: x_return_status := FND_API.G_RET_STS_SUCCESS;
1625:
1626: END retrieve_vr;
1627:
1628:

Line 1732: x_return_status := FND_API.G_RET_STS_SUCCESS;

1728: create_recipe_err EXCEPTION;
1729:
1730: BEGIN
1731:
1732: x_return_status := FND_API.G_RET_STS_SUCCESS;
1733:
1734: OPEN c_get_recipe_id;
1735: FETCH c_get_recipe_id INTO l_recipe_id;
1736: CLOSE c_get_recipe_id;

Line 1853: x_return_status := FND_API.G_RET_STS_SUCCESS;

1849:
1850:
1851: END IF; --If c_get_formula_info%found
1852:
1853: x_return_status := FND_API.G_RET_STS_SUCCESS;
1854: CLOSE c_get_formula_info;
1855:
1856: END retrieve_recipe;
1857:

Line 1993: X_return_status := FND_API.g_ret_sts_success;

1989: ITEM_MISSING EXCEPTION;
1990:
1991: BEGIN
1992: /* Initialize the return status */
1993: X_return_status := FND_API.g_ret_sts_success;
1994: IF p_formula_id IS NULL THEN
1995: RAISE formula_missing;
1996: END IF;
1997:

Line 2042: X_return_status := FND_API.g_ret_sts_error;

2038: FND_MESSAGE.SET_NAME('GMD', 'GMD_RCP_ITEMORG_NOT_FOUND');
2039: FND_MESSAGE.SET_TOKEN('ORGN',X_orgn_code);
2040: FND_MESSAGE.SET_TOKEN('ITEM',X_item_list);
2041: FND_MSG_PUB.ADD;
2042: X_return_status := FND_API.g_ret_sts_error;
2043: RAISE ITEM_MISSING;
2044: END IF;
2045:
2046: OPEN Cur_check_item_revision (X_organization_id);

Line 2072: X_return_status := FND_API.g_ret_sts_error;

2068: FND_MESSAGE.SET_NAME('GMD', 'GMD_RCP_ITEMORG_REV_NOT_FOUND');
2069: FND_MESSAGE.SET_TOKEN('ORGN',X_orgn_code);
2070: FND_MESSAGE.SET_TOKEN('ITEM REVISION',X_item_rev_list);
2071: FND_MSG_PUB.ADD;
2072: X_return_status := FND_API.g_ret_sts_error;
2073: RAISE ITEM_MISSING;
2074: END IF;
2075:
2076: IF p_production_check THEN

Line 2107: X_return_status := FND_API.g_ret_sts_error;

2103: FND_MESSAGE.SET_NAME('GMD', 'GMD_PROD_ITEMORG_NOT_FOUND');
2104: FND_MESSAGE.SET_TOKEN('ORGN',X_orgn_code);
2105: FND_MESSAGE.SET_TOKEN('ITEM',X_item_list);
2106: FND_MSG_PUB.ADD;
2107: X_return_status := FND_API.g_ret_sts_error;
2108: RAISE ITEM_MISSING;
2109: END IF;
2110: END IF;
2111: IF p_costing_check THEN

Line 2142: X_return_status := FND_API.g_ret_sts_error;

2138: FND_MESSAGE.SET_NAME('GMD', 'GMD_COST_ITEMORG_NOT_FOUND');
2139: FND_MESSAGE.SET_TOKEN('ORGN',X_orgn_code);
2140: FND_MESSAGE.SET_TOKEN('ITEM',X_item_list);
2141: FND_MSG_PUB.ADD;
2142: X_return_status := FND_API.g_ret_sts_error;
2143: RAISE ITEM_MISSING;
2144: END IF;
2145: END IF;
2146:

Line 2178: X_return_status := FND_API.g_ret_sts_error;

2174: FND_MESSAGE.SET_NAME('GMD', 'GMD_SERIAL_ITEMS_NOT_ALLOWED');
2175: FND_MESSAGE.SET_TOKEN('ORGN',X_orgn_code);
2176: FND_MESSAGE.SET_TOKEN('ITEM',X_item_list);
2177: FND_MSG_PUB.ADD;
2178: X_return_status := FND_API.g_ret_sts_error;
2179: RAISE ITEM_MISSING;
2180: END IF;
2181:
2182: EXCEPTION

Line 2184: X_return_status := FND_API.g_ret_sts_error;

2180: END IF;
2181:
2182: EXCEPTION
2183: WHEN formula_missing THEN
2184: X_return_status := FND_API.g_ret_sts_error;
2185: gmd_api_grp.log_message('GMD_MISSING', 'FORMULA_ID');
2186: WHEN item_missing THEN
2187: X_return_status := FND_API.g_ret_sts_error;
2188: WHEN orgn_missing THEN

Line 2187: X_return_status := FND_API.g_ret_sts_error;

2183: WHEN formula_missing THEN
2184: X_return_status := FND_API.g_ret_sts_error;
2185: gmd_api_grp.log_message('GMD_MISSING', 'FORMULA_ID');
2186: WHEN item_missing THEN
2187: X_return_status := FND_API.g_ret_sts_error;
2188: WHEN orgn_missing THEN
2189: X_return_status := FND_API.g_ret_sts_error;
2190: gmd_api_grp.log_message('GMD_MISSING', 'ORGN_CODE');
2191: WHEN OTHERS THEN

Line 2189: X_return_status := FND_API.g_ret_sts_error;

2185: gmd_api_grp.log_message('GMD_MISSING', 'FORMULA_ID');
2186: WHEN item_missing THEN
2187: X_return_status := FND_API.g_ret_sts_error;
2188: WHEN orgn_missing THEN
2189: X_return_status := FND_API.g_ret_sts_error;
2190: gmd_api_grp.log_message('GMD_MISSING', 'ORGN_CODE');
2191: WHEN OTHERS THEN
2192: X_return_status := FND_API.g_ret_sts_unexp_error;
2193: fnd_msg_pub.add_exc_msg (l_package_name, 'CHECK_ITEM_EXISTS');

Line 2192: X_return_status := FND_API.g_ret_sts_unexp_error;

2188: WHEN orgn_missing THEN
2189: X_return_status := FND_API.g_ret_sts_error;
2190: gmd_api_grp.log_message('GMD_MISSING', 'ORGN_CODE');
2191: WHEN OTHERS THEN
2192: X_return_status := FND_API.g_ret_sts_unexp_error;
2193: fnd_msg_pub.add_exc_msg (l_package_name, 'CHECK_ITEM_EXISTS');
2194: END check_item_exists;
2195:
2196: /* *********************************************************************** *

Line 2262: x_return_status := FND_API.G_RET_STS_SUCCESS;

2258:
2259: BEGIN
2260:
2261: /* Set return status to success initially */
2262: x_return_status := FND_API.G_RET_STS_SUCCESS;
2263:
2264: OPEN Cur_get_lab_plant_ind;
2265: FETCH Cur_get_lab_plant_ind INTO x_out_rec.plant_ind, x_out_rec.lab_ind;
2266: IF P_orgn_id IS NOT NULL AND Cur_get_lab_plant_ind%NOTFOUND THEN

Line 2341: x_return_status := FND_API.G_RET_STS_SUCCESS;

2337: EXCEPTION
2338: WHEN PARM_NOT_FOUND THEN
2339: fnd_message.set_name ('GMD', 'GMD_PARM_NOT_FOUND');
2340: fnd_msg_pub.add;
2341: x_return_status := FND_API.G_RET_STS_SUCCESS;
2342: WHEN OTHERS THEN
2343: fnd_message.set_name ('GMD', 'GMD_PARM_NOT_FOUND');
2344: fnd_msg_pub.add;
2345: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2345: x_return_status := FND_API.G_RET_STS_ERROR;

2341: x_return_status := FND_API.G_RET_STS_SUCCESS;
2342: WHEN OTHERS THEN
2343: fnd_message.set_name ('GMD', 'GMD_PARM_NOT_FOUND');
2344: fnd_msg_pub.add;
2345: x_return_status := FND_API.G_RET_STS_ERROR;
2346:
2347: END FETCH_PARM_VALUES;
2348:
2349:

Line 2390: x_return_status := FND_API.G_RET_STS_SUCCESS;

2386:
2387: BEGIN
2388:
2389: /* Set return status to success initially */
2390: x_return_status := FND_API.G_RET_STS_SUCCESS;
2391:
2392: OPEN Cur_get_parameter;
2393: FETCH Cur_get_parameter INTO P_parm_value;
2394: IF Cur_get_parameter%NOTFOUND THEN

Line 2401: x_return_status := FND_API.G_RET_STS_SUCCESS;

2397: CLOSE Cur_get_parameter;
2398:
2399: EXCEPTION
2400: WHEN PARM_NOT_FOUND THEN
2401: x_return_status := FND_API.G_RET_STS_SUCCESS;
2402: WHEN OTHERS THEN
2403: fnd_msg_pub.add_exc_msg (l_package_name, 'FETCH_PARM_VALUES');
2404: x_return_status := FND_API.G_RET_STS_ERROR;
2405: END FETCH_PARM_VALUES;

Line 2404: x_return_status := FND_API.G_RET_STS_ERROR;

2400: WHEN PARM_NOT_FOUND THEN
2401: x_return_status := FND_API.G_RET_STS_SUCCESS;
2402: WHEN OTHERS THEN
2403: fnd_msg_pub.add_exc_msg (l_package_name, 'FETCH_PARM_VALUES');
2404: x_return_status := FND_API.G_RET_STS_ERROR;
2405: END FETCH_PARM_VALUES;
2406:
2407: -- Bug number 4479101
2408: FUNCTION derive_ingredent_end (P_substitution_id IN NUMBER,

Line 2556: p_encoded => FND_API.G_FALSE,

2552: IF (l_msg_txt IS NULL) THEN
2553: FND_MSG_PUB.Get(
2554: p_msg_index => 1,
2555: p_data => l_msg_txt,
2556: p_encoded => FND_API.G_FALSE,
2557: p_msg_index_out => l_msg_index);
2558: END IF;
2559:
2560: Return l_msg_txt;