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 1630: x_return_status := FND_API.G_RET_STS_SUCCESS;

1626: l_recipe_vr_tbl.preference := l_preference;
1627: END IF;
1628: CLOSE c_get_recipe_info;
1629:
1630: x_return_status := FND_API.G_RET_STS_SUCCESS;
1631:
1632: END retrieve_vr;
1633:
1634:

Line 1746: x_return_status := FND_API.G_RET_STS_SUCCESS;

1742: create_recipe_err EXCEPTION;
1743:
1744: BEGIN
1745:
1746: x_return_status := FND_API.G_RET_STS_SUCCESS;
1747:
1748: OPEN c_get_recipe_id;
1749: FETCH c_get_recipe_id INTO l_recipe_id;
1750: CLOSE c_get_recipe_id;

Line 1873: x_return_status := FND_API.G_RET_STS_SUCCESS;

1869:
1870:
1871: END IF; --If c_get_formula_info%found
1872:
1873: x_return_status := FND_API.G_RET_STS_SUCCESS;
1874: CLOSE c_get_formula_info;
1875:
1876: END retrieve_recipe;
1877:

Line 2013: X_return_status := FND_API.g_ret_sts_success;

2009: ITEM_MISSING EXCEPTION;
2010:
2011: BEGIN
2012: /* Initialize the return status */
2013: X_return_status := FND_API.g_ret_sts_success;
2014: IF p_formula_id IS NULL THEN
2015: RAISE formula_missing;
2016: END IF;
2017:

Line 2062: X_return_status := FND_API.g_ret_sts_error;

2058: FND_MESSAGE.SET_NAME('GMD', 'GMD_RCP_ITEMORG_NOT_FOUND');
2059: FND_MESSAGE.SET_TOKEN('ORGN',X_orgn_code);
2060: FND_MESSAGE.SET_TOKEN('ITEM',X_item_list);
2061: FND_MSG_PUB.ADD;
2062: X_return_status := FND_API.g_ret_sts_error;
2063: RAISE ITEM_MISSING;
2064: END IF;
2065:
2066: OPEN Cur_check_item_revision (X_organization_id);

Line 2092: X_return_status := FND_API.g_ret_sts_error;

2088: FND_MESSAGE.SET_NAME('GMD', 'GMD_RCP_ITEMORG_REV_NOT_FOUND');
2089: FND_MESSAGE.SET_TOKEN('ORGN',X_orgn_code);
2090: FND_MESSAGE.SET_TOKEN('ITEM REVISION',X_item_rev_list);
2091: FND_MSG_PUB.ADD;
2092: X_return_status := FND_API.g_ret_sts_error;
2093: RAISE ITEM_MISSING;
2094: END IF;
2095:
2096: IF p_production_check THEN

Line 2127: X_return_status := FND_API.g_ret_sts_error;

2123: FND_MESSAGE.SET_NAME('GMD', 'GMD_PROD_ITEMORG_NOT_FOUND');
2124: FND_MESSAGE.SET_TOKEN('ORGN',X_orgn_code);
2125: FND_MESSAGE.SET_TOKEN('ITEM',X_item_list);
2126: FND_MSG_PUB.ADD;
2127: X_return_status := FND_API.g_ret_sts_error;
2128: RAISE ITEM_MISSING;
2129: END IF;
2130: END IF;
2131: IF p_costing_check THEN

Line 2162: X_return_status := FND_API.g_ret_sts_error;

2158: FND_MESSAGE.SET_NAME('GMD', 'GMD_COST_ITEMORG_NOT_FOUND');
2159: FND_MESSAGE.SET_TOKEN('ORGN',X_orgn_code);
2160: FND_MESSAGE.SET_TOKEN('ITEM',X_item_list);
2161: FND_MSG_PUB.ADD;
2162: X_return_status := FND_API.g_ret_sts_error;
2163: RAISE ITEM_MISSING;
2164: END IF;
2165: END IF;
2166:

Line 2198: X_return_status := FND_API.g_ret_sts_error;

2194: FND_MESSAGE.SET_NAME('GMD', 'GMD_SERIAL_ITEMS_NOT_ALLOWED');
2195: FND_MESSAGE.SET_TOKEN('ORGN',X_orgn_code);
2196: FND_MESSAGE.SET_TOKEN('ITEM',X_item_list);
2197: FND_MSG_PUB.ADD;
2198: X_return_status := FND_API.g_ret_sts_error;
2199: RAISE ITEM_MISSING;
2200: END IF;
2201:
2202: EXCEPTION

Line 2204: X_return_status := FND_API.g_ret_sts_error;

2200: END IF;
2201:
2202: EXCEPTION
2203: WHEN formula_missing THEN
2204: X_return_status := FND_API.g_ret_sts_error;
2205: gmd_api_grp.log_message('GMD_MISSING', 'FORMULA_ID');
2206: WHEN item_missing THEN
2207: X_return_status := FND_API.g_ret_sts_error;
2208: WHEN orgn_missing THEN

Line 2207: X_return_status := FND_API.g_ret_sts_error;

2203: WHEN formula_missing THEN
2204: X_return_status := FND_API.g_ret_sts_error;
2205: gmd_api_grp.log_message('GMD_MISSING', 'FORMULA_ID');
2206: WHEN item_missing THEN
2207: X_return_status := FND_API.g_ret_sts_error;
2208: WHEN orgn_missing THEN
2209: X_return_status := FND_API.g_ret_sts_error;
2210: gmd_api_grp.log_message('GMD_MISSING', 'ORGN_CODE');
2211: WHEN OTHERS THEN

Line 2209: X_return_status := FND_API.g_ret_sts_error;

2205: gmd_api_grp.log_message('GMD_MISSING', 'FORMULA_ID');
2206: WHEN item_missing THEN
2207: X_return_status := FND_API.g_ret_sts_error;
2208: WHEN orgn_missing THEN
2209: X_return_status := FND_API.g_ret_sts_error;
2210: gmd_api_grp.log_message('GMD_MISSING', 'ORGN_CODE');
2211: WHEN OTHERS THEN
2212: X_return_status := FND_API.g_ret_sts_unexp_error;
2213: fnd_msg_pub.add_exc_msg (l_package_name, 'CHECK_ITEM_EXISTS');

Line 2212: X_return_status := FND_API.g_ret_sts_unexp_error;

2208: WHEN orgn_missing THEN
2209: X_return_status := FND_API.g_ret_sts_error;
2210: gmd_api_grp.log_message('GMD_MISSING', 'ORGN_CODE');
2211: WHEN OTHERS THEN
2212: X_return_status := FND_API.g_ret_sts_unexp_error;
2213: fnd_msg_pub.add_exc_msg (l_package_name, 'CHECK_ITEM_EXISTS');
2214: END check_item_exists;
2215:
2216: /* *********************************************************************** *

Line 2282: x_return_status := FND_API.G_RET_STS_SUCCESS;

2278:
2279: BEGIN
2280:
2281: /* Set return status to success initially */
2282: x_return_status := FND_API.G_RET_STS_SUCCESS;
2283:
2284: OPEN Cur_get_lab_plant_ind;
2285: FETCH Cur_get_lab_plant_ind INTO x_out_rec.plant_ind, x_out_rec.lab_ind;
2286: IF P_orgn_id IS NOT NULL AND Cur_get_lab_plant_ind%NOTFOUND THEN

Line 2361: x_return_status := FND_API.G_RET_STS_SUCCESS;

2357: EXCEPTION
2358: WHEN PARM_NOT_FOUND THEN
2359: fnd_message.set_name ('GMD', 'GMD_PARM_NOT_FOUND');
2360: fnd_msg_pub.add;
2361: x_return_status := FND_API.G_RET_STS_SUCCESS;
2362: WHEN OTHERS THEN
2363: fnd_message.set_name ('GMD', 'GMD_PARM_NOT_FOUND');
2364: fnd_msg_pub.add;
2365: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2365: x_return_status := FND_API.G_RET_STS_ERROR;

2361: x_return_status := FND_API.G_RET_STS_SUCCESS;
2362: WHEN OTHERS THEN
2363: fnd_message.set_name ('GMD', 'GMD_PARM_NOT_FOUND');
2364: fnd_msg_pub.add;
2365: x_return_status := FND_API.G_RET_STS_ERROR;
2366:
2367: END FETCH_PARM_VALUES;
2368:
2369:

Line 2410: x_return_status := FND_API.G_RET_STS_SUCCESS;

2406:
2407: BEGIN
2408:
2409: /* Set return status to success initially */
2410: x_return_status := FND_API.G_RET_STS_SUCCESS;
2411:
2412: OPEN Cur_get_parameter;
2413: FETCH Cur_get_parameter INTO P_parm_value;
2414: IF Cur_get_parameter%NOTFOUND THEN

Line 2421: x_return_status := FND_API.G_RET_STS_SUCCESS;

2417: CLOSE Cur_get_parameter;
2418:
2419: EXCEPTION
2420: WHEN PARM_NOT_FOUND THEN
2421: x_return_status := FND_API.G_RET_STS_SUCCESS;
2422: WHEN OTHERS THEN
2423: fnd_msg_pub.add_exc_msg (l_package_name, 'FETCH_PARM_VALUES');
2424: x_return_status := FND_API.G_RET_STS_ERROR;
2425: END FETCH_PARM_VALUES;

Line 2424: x_return_status := FND_API.G_RET_STS_ERROR;

2420: WHEN PARM_NOT_FOUND THEN
2421: x_return_status := FND_API.G_RET_STS_SUCCESS;
2422: WHEN OTHERS THEN
2423: fnd_msg_pub.add_exc_msg (l_package_name, 'FETCH_PARM_VALUES');
2424: x_return_status := FND_API.G_RET_STS_ERROR;
2425: END FETCH_PARM_VALUES;
2426:
2427: -- Bug number 4479101
2428: FUNCTION derive_ingredent_end (P_substitution_id IN NUMBER,

Line 2576: p_encoded => FND_API.G_FALSE,

2572: IF (l_msg_txt IS NULL) THEN
2573: FND_MSG_PUB.Get(
2574: p_msg_index => 1,
2575: p_data => l_msg_txt,
2576: p_encoded => FND_API.G_FALSE,
2577: p_msg_index_out => l_msg_index);
2578: END IF;
2579:
2580: Return l_msg_txt;