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

Line 125: P_return_status := FND_API.G_RET_STS_SUCCESS;

121: GET_STEP_MATERIAL_LINES_FAILED EXCEPTION;
122: ERROR_SORTING_STEPS EXCEPTION;
123:
124: BEGIN
125: P_return_status := FND_API.G_RET_STS_SUCCESS;
126: IF P_parent_id IS NULL THEN
127: RAISE MISSING_PARENT_ID;
128: END IF;
129:

Line 464: P_return_status := FND_API.G_RET_STS_ERROR;

460: END IF;
461:
462: EXCEPTION
463: WHEN MISSING_PARENT_ID THEN
464: P_return_status := FND_API.G_RET_STS_ERROR;
465: FND_MESSAGE.SET_NAME('GMA', 'SY_KEYMISSING');
466: FND_MSG_PUB.ADD;
467: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
468: P_data => P_msg_stack);

Line 470: P_return_status := FND_API.G_RET_STS_ERROR;

466: FND_MSG_PUB.ADD;
467: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
468: P_data => P_msg_stack);
469: WHEN LOAD_STEPS_FAILED THEN
470: P_return_status := FND_API.G_RET_STS_ERROR;
471: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
472: P_data => P_msg_stack);
473: WHEN STEPS_UOM_NOT_MASS_VOLUME_TYPE THEN
474: P_return_status := FND_API.G_RET_STS_ERROR;

Line 474: P_return_status := FND_API.G_RET_STS_ERROR;

470: P_return_status := FND_API.G_RET_STS_ERROR;
471: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
472: P_data => P_msg_stack);
473: WHEN STEPS_UOM_NOT_MASS_VOLUME_TYPE THEN
474: P_return_status := FND_API.G_RET_STS_ERROR;
475: FND_MESSAGE.SET_NAME('GMD', 'GMD_STEP_NOT_MASS_VOL_UOM');
476: FND_MSG_PUB.ADD;
477: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
478: P_data => P_msg_stack);

Line 480: P_return_status := FND_API.G_RET_STS_ERROR;

476: FND_MSG_PUB.ADD;
477: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
478: P_data => P_msg_stack);
479: WHEN GET_STEP_MATERIAL_LINES_FAILED THEN
480: P_return_status := FND_API.G_RET_STS_ERROR;
481: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
482: P_data => P_msg_stack);
483: WHEN ERROR_SORTING_STEPS THEN
484: P_return_status := FND_API.G_RET_STS_ERROR;

Line 484: P_return_status := FND_API.G_RET_STS_ERROR;

480: P_return_status := FND_API.G_RET_STS_ERROR;
481: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
482: P_data => P_msg_stack);
483: WHEN ERROR_SORTING_STEPS THEN
484: P_return_status := FND_API.G_RET_STS_ERROR;
485: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
486: P_data => P_msg_stack);
487: WHEN OTHERS THEN
488: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 488: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

484: P_return_status := FND_API.G_RET_STS_ERROR;
485: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
486: P_data => P_msg_stack);
487: WHEN OTHERS THEN
488: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
490: P_data => P_msg_stack);
491: END calc_step_qty;
492:

Line 622: P_return_status := FND_API.G_RET_STS_SUCCESS;

618:
619: NO_ROUTING_ASSOCIATED EXCEPTION;
620: ROUTING_DETAILS_MISSING EXCEPTION;
621: BEGIN
622: P_return_status := FND_API.G_RET_STS_SUCCESS;
623: /* If called from GMD */
624: IF P_called_from_batch = 0 THEN
625: /* Fetch the routing for the recipe passed in from GMD */
626: OPEN Cur_get_routing;

Line 786: P_return_status := FND_API.G_RET_STS_ERROR;

782: END IF; /* IF P_step_no IS NOT NULL */
783: END IF; /* IF P_called_from_batch = 0 */
784: EXCEPTION
785: WHEN NO_ROUTING_ASSOCIATED THEN
786: P_return_status := FND_API.G_RET_STS_ERROR;
787: FND_MESSAGE.SET_NAME('GMD', 'GMD_AUTO_STEP_QTY_NEEDS_ROUT');
788: FND_MSG_PUB.ADD;
789: WHEN ROUTING_DETAILS_MISSING THEN
790: P_return_status := FND_API.G_RET_STS_ERROR;

Line 790: P_return_status := FND_API.G_RET_STS_ERROR;

786: P_return_status := FND_API.G_RET_STS_ERROR;
787: FND_MESSAGE.SET_NAME('GMD', 'GMD_AUTO_STEP_QTY_NEEDS_ROUT');
788: FND_MSG_PUB.ADD;
789: WHEN ROUTING_DETAILS_MISSING THEN
790: P_return_status := FND_API.G_RET_STS_ERROR;
791: FND_MESSAGE.SET_NAME('GMD', 'FMROUTINGSTEPNOTFOUND');
792: FND_MSG_PUB.ADD;
793: --Following messages added for bug 2077203
794: WHEN CIRCULAR_REFERENCE THEN

Line 795: P_return_status := FND_API.G_RET_STS_ERROR;

791: FND_MESSAGE.SET_NAME('GMD', 'FMROUTINGSTEPNOTFOUND');
792: FND_MSG_PUB.ADD;
793: --Following messages added for bug 2077203
794: WHEN CIRCULAR_REFERENCE THEN
795: P_return_status := FND_API.G_RET_STS_ERROR;
796: FND_MESSAGE.SET_NAME('GMD', 'GMD_CIRCULAR_DEPEN_DETECT');
797: FND_MSG_PUB.ADD;
798: WHEN OTHERS THEN
799: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 799: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

795: P_return_status := FND_API.G_RET_STS_ERROR;
796: FND_MESSAGE.SET_NAME('GMD', 'GMD_CIRCULAR_DEPEN_DETECT');
797: FND_MSG_PUB.ADD;
798: WHEN OTHERS THEN
799: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
801: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
802: FND_MSG_PUB.ADD;
803: END load_steps;

Line 986: P_return_status := FND_API.G_RET_STS_SUCCESS;

982: NO_MATERIAL_STEP_ASSOC EXCEPTION;
983:
984: BEGIN
985: P_work_step_tbl.DELETE;
986: P_return_status := FND_API.G_RET_STS_SUCCESS;
987: X_num_rows := P_step_tbl.COUNT;
988: FOR i IN 1..X_num_rows LOOP
989:
990: /* If called from GMD */

Line 1245: P_return_status := FND_API.G_RET_STS_ERROR;

1241: END IF;
1242:
1243: EXCEPTION
1244: WHEN UOM_CONVERSION_ERROR THEN
1245: P_return_status := FND_API.G_RET_STS_ERROR;
1246: OPEN Cur_get_item;
1247: FETCH Cur_get_item INTO X_item_no;
1248: CLOSE Cur_get_item;
1249: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');

Line 1255: P_return_status := FND_API.G_RET_STS_ERROR;

1251: FND_MESSAGE.SET_TOKEN('FROM_UOM', X_from_uom);
1252: FND_MESSAGE.SET_TOKEN('TO_UOM', X_to_uom);
1253: FND_MSG_PUB.ADD;
1254: WHEN NO_MATERIAL_STEP_ASSOC THEN
1255: P_return_status := FND_API.G_RET_STS_ERROR;
1256: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_MATL_STEP_ASSOC');
1257: FND_MSG_PUB.ADD;
1258: WHEN OTHERS THEN
1259: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1259: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1255: P_return_status := FND_API.G_RET_STS_ERROR;
1256: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_MATL_STEP_ASSOC');
1257: FND_MSG_PUB.ADD;
1258: WHEN OTHERS THEN
1259: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1260: FND_MSG_PUB.ADD;
1261: END get_step_material_lines;
1262:
1263:

Line 1364: P_return_status := FND_API.G_RET_STS_SUCCESS;

1360: COST_SCALING_ERROR EXCEPTION;
1361:
1362: BEGIN
1363: P_work_step_tbl.DELETE;
1364: P_return_status := FND_API.G_RET_STS_SUCCESS;
1365:
1366: /* Perform the formula scaling first */
1367: /* Scale the formula using the scale factor */
1368:

Line 1558: P_return_status := FND_API.G_RET_STS_ERROR;

1554: END IF;
1555:
1556: EXCEPTION
1557: WHEN UOM_CONVERSION_ERROR THEN
1558: P_return_status := FND_API.G_RET_STS_ERROR;
1559: OPEN Cur_get_item;
1560: FETCH Cur_get_item INTO X_item_no;
1561: CLOSE Cur_get_item;
1562: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');

Line 1568: P_return_status := FND_API.G_RET_STS_ERROR;

1564: FND_MESSAGE.SET_TOKEN('FROM_UOM', X_from_uom);
1565: FND_MESSAGE.SET_TOKEN('TO_UOM', X_to_uom);
1566: FND_MSG_PUB.ADD;
1567: WHEN NO_MATERIAL_STEP_ASSOC THEN
1568: P_return_status := FND_API.G_RET_STS_ERROR;
1569: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_MATL_STEP_ASSOC');
1570: FND_MSG_PUB.ADD;
1571: WHEN COST_SCALING_ERROR THEN
1572: P_return_status := FND_API.G_RET_STS_ERROR;

Line 1572: P_return_status := FND_API.G_RET_STS_ERROR;

1568: P_return_status := FND_API.G_RET_STS_ERROR;
1569: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_MATL_STEP_ASSOC');
1570: FND_MSG_PUB.ADD;
1571: WHEN COST_SCALING_ERROR THEN
1572: P_return_status := FND_API.G_RET_STS_ERROR;
1573: WHEN OTHERS THEN
1574: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1575: FND_MSG_PUB.ADD;
1576: END get_step_material_lines;

Line 1574: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1570: FND_MSG_PUB.ADD;
1571: WHEN COST_SCALING_ERROR THEN
1572: P_return_status := FND_API.G_RET_STS_ERROR;
1573: WHEN OTHERS THEN
1574: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1575: FND_MSG_PUB.ADD;
1576: END get_step_material_lines;
1577:
1578:

Line 1646: P_return_status := FND_API.G_RET_STS_SUCCESS;

1642: X_step_vol_qty NUMBER;
1643: X_step_other_qty NUMBER;
1644: X_count NUMBER;
1645: BEGIN
1646: P_return_status := FND_API.G_RET_STS_SUCCESS;
1647: X_count := P_step_tbl.COUNT;
1648: FOR i IN 1..X_count LOOP
1649: FOR j IN i+1..X_count LOOP
1650: IF P_step_tbl(i).step_no > P_step_tbl(j).step_no THEN

Line 1680: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1676: END LOOP; /* FOR j IN 1..X_count */
1677: END LOOP; /* FOR i IN 1..X_count */
1678: EXCEPTION
1679: WHEN OTHERS THEN
1680: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1681: FND_MSG_PUB.ADD;
1682: END sort_step_lines;
1683:
1684:

Line 1828: P_return_status := FND_API.G_RET_STS_SUCCESS;

1824: ROUTING_DETAILS_MISSING EXCEPTION;
1825: ALL_MTL_LINES_NOT_ASSOC EXCEPTION;
1826: UOM_CONVERSION_ERROR EXCEPTION;
1827: BEGIN
1828: P_return_status := FND_API.G_RET_STS_SUCCESS;
1829: FND_MSG_PUB.INITIALIZE;
1830:
1831: /* If recipe id is null it implies that the material
1832: step association has not been done */

Line 1994: P_return_status := FND_API.G_RET_STS_ERROR;

1990:
1991: END LOOP;
1992: EXCEPTION
1993: WHEN NO_ROUTING_ASSOCIATED THEN
1994: P_return_status := FND_API.G_RET_STS_ERROR;
1995: FND_MESSAGE.SET_NAME('GMD', 'GMD_AUTO_STEP_QTY_NEEDS_ROUT');
1996: FND_MSG_PUB.ADD;
1997: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
1998: P_data => P_msg_stack);

Line 2000: P_return_status := FND_API.G_RET_STS_ERROR;

1996: FND_MSG_PUB.ADD;
1997: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
1998: P_data => P_msg_stack);
1999: WHEN ROUTING_DETAILS_MISSING THEN
2000: P_return_status := FND_API.G_RET_STS_ERROR;
2001: FND_MESSAGE.SET_NAME('GMD', 'FMROUTINGSTEPNOTFOUND');
2002: FND_MSG_PUB.ADD;
2003: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2004: P_data => P_msg_stack);

Line 2006: P_return_status := FND_API.G_RET_STS_ERROR;

2002: FND_MSG_PUB.ADD;
2003: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2004: P_data => P_msg_stack);
2005: WHEN NO_MATERIAL_STEP_ASSOC THEN
2006: P_return_status := FND_API.G_RET_STS_ERROR;
2007: -- debug line p_return_status := 'Z';
2008: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_MATL_STEP_ASSOC');
2009: FND_MSG_PUB.ADD;
2010: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,

Line 2013: P_return_status := FND_API.G_RET_STS_ERROR;

2009: FND_MSG_PUB.ADD;
2010: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2011: P_data => P_msg_stack);
2012: WHEN ALL_MTL_LINES_NOT_ASSOC THEN
2013: P_return_status := FND_API.G_RET_STS_ERROR;
2014: -- debug line p_return_status := 'Y';
2015: FND_MESSAGE.SET_NAME('GMD', 'GMD_ALL_MATL_STEP_NOT_ASSOC');
2016: FND_MSG_PUB.ADD;
2017: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,

Line 2020: P_return_status := FND_API.G_RET_STS_ERROR;

2016: FND_MSG_PUB.ADD;
2017: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2018: P_data => P_msg_stack);
2019: WHEN UOM_CONVERSION_ERROR THEN
2020: P_return_status := FND_API.G_RET_STS_ERROR;
2021: OPEN Cur_get_item;
2022: FETCH Cur_get_item INTO X_item_no;
2023: CLOSE Cur_get_item;
2024: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');

Line 2032: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2028: FND_MSG_PUB.ADD;
2029: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2030: P_data => P_msg_stack);
2031: WHEN OTHERS THEN
2032: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2033: fnd_message.set_name('GMD',SQLERRM);
2034: fnd_msg_pub.add;
2035: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2036: P_data => P_msg_stack);

Line 2093: P_return_status := FND_API.G_RET_STS_SUCCESS;

2089:
2090: x_recipe_cntr NUMBER := 0;
2091:
2092: BEGIN
2093: P_return_status := FND_API.G_RET_STS_SUCCESS;
2094: -- 1. Get a list of recipes where this formulaline exists in step/mat association,
2095: -- and where calculate_step_qty flag IS set (ASQC=Yes)
2096: -- and where delete_mark is NOT set
2097: -- and the recipe is NOT marked obsolete.

Line 2118: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2114: EXCEPTION
2115: WHEN OTHERS THEN
2116: -- It is OK if no rows are found in step/mat table.
2117: -- This exception is for database errors
2118: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2119: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2120: P_data => P_msg_stack);
2121: END check_del_from_step_mat;
2122:

Line 2175: P_return_status := FND_API.G_RET_STS_SUCCESS;

2171: x_ignore_vol_conv BOOLEAN;
2172: ALL_MTL_LINES_NOT_ASSOC EXCEPTION;
2173:
2174: BEGIN
2175: P_return_status := FND_API.G_RET_STS_SUCCESS;
2176: -- Calling program should delete from fm_matl_dtl.
2177: -- DELETE FROM fm_matl_dtl WHERE formulaline_id = P_formulaline_id;
2178: -- 1. Use gmd_auto_step_calc.check_del_from_step_mat to get a list of recipes where
2179: -- this formulaline exists in step/mat association,

Line 2304: P_return_status := FND_API.G_RET_STS_ERROR;

2300: P_data => P_msg_stack);
2301: -- debug dbms_output.put_line ('in exception ' || p_return_status);
2302:
2303: WHEN ALL_MTL_LINES_NOT_ASSOC THEN
2304: P_return_status := FND_API.G_RET_STS_ERROR;
2305: FND_MESSAGE.SET_NAME('GMD', 'GMD_ALL_MATL_STEP_NOT_ASSOC');
2306: FND_MSG_PUB.ADD;
2307: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2308: P_data => P_msg_stack);

Line 2312: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2308: P_data => P_msg_stack);
2309: WHEN OTHERS THEN
2310: -- It is OK if no rows are found in step/mat table.
2311: -- The 3 procedures called have their own error handling.
2312: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2313: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2314: P_data => P_msg_stack);
2315: END cascade_del_to_step_mat;
2316: