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 992: P_return_status := FND_API.G_RET_STS_SUCCESS;

988: NO_MATERIAL_STEP_ASSOC EXCEPTION;
989:
990: BEGIN
991: P_work_step_tbl.DELETE;
992: P_return_status := FND_API.G_RET_STS_SUCCESS;
993: X_num_rows := P_step_tbl.COUNT;
994: FOR i IN 1..X_num_rows LOOP
995:
996: /* If called from GMD */

Line 1251: P_return_status := FND_API.G_RET_STS_ERROR;

1247: END IF;
1248:
1249: EXCEPTION
1250: WHEN UOM_CONVERSION_ERROR THEN
1251: P_return_status := FND_API.G_RET_STS_ERROR;
1252: OPEN Cur_get_item;
1253: FETCH Cur_get_item INTO X_item_no;
1254: CLOSE Cur_get_item;
1255: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');

Line 1261: P_return_status := FND_API.G_RET_STS_ERROR;

1257: FND_MESSAGE.SET_TOKEN('FROM_UOM', X_from_uom);
1258: FND_MESSAGE.SET_TOKEN('TO_UOM', X_to_uom);
1259: FND_MSG_PUB.ADD;
1260: WHEN NO_MATERIAL_STEP_ASSOC THEN
1261: P_return_status := FND_API.G_RET_STS_ERROR;
1262: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_MATL_STEP_ASSOC');
1263: FND_MSG_PUB.ADD;
1264: WHEN OTHERS THEN
1265: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1265: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1261: P_return_status := FND_API.G_RET_STS_ERROR;
1262: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_MATL_STEP_ASSOC');
1263: FND_MSG_PUB.ADD;
1264: WHEN OTHERS THEN
1265: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: FND_MSG_PUB.ADD;
1267: END get_step_material_lines;
1268:
1269:

Line 1370: P_return_status := FND_API.G_RET_STS_SUCCESS;

1366: COST_SCALING_ERROR EXCEPTION;
1367:
1368: BEGIN
1369: P_work_step_tbl.DELETE;
1370: P_return_status := FND_API.G_RET_STS_SUCCESS;
1371:
1372: /* Perform the formula scaling first */
1373: /* Scale the formula using the scale factor */
1374:

Line 1564: P_return_status := FND_API.G_RET_STS_ERROR;

1560: END IF;
1561:
1562: EXCEPTION
1563: WHEN UOM_CONVERSION_ERROR THEN
1564: P_return_status := FND_API.G_RET_STS_ERROR;
1565: OPEN Cur_get_item;
1566: FETCH Cur_get_item INTO X_item_no;
1567: CLOSE Cur_get_item;
1568: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');

Line 1574: P_return_status := FND_API.G_RET_STS_ERROR;

1570: FND_MESSAGE.SET_TOKEN('FROM_UOM', X_from_uom);
1571: FND_MESSAGE.SET_TOKEN('TO_UOM', X_to_uom);
1572: FND_MSG_PUB.ADD;
1573: WHEN NO_MATERIAL_STEP_ASSOC THEN
1574: P_return_status := FND_API.G_RET_STS_ERROR;
1575: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_MATL_STEP_ASSOC');
1576: FND_MSG_PUB.ADD;
1577: WHEN COST_SCALING_ERROR THEN
1578: P_return_status := FND_API.G_RET_STS_ERROR;

Line 1578: P_return_status := FND_API.G_RET_STS_ERROR;

1574: P_return_status := FND_API.G_RET_STS_ERROR;
1575: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_MATL_STEP_ASSOC');
1576: FND_MSG_PUB.ADD;
1577: WHEN COST_SCALING_ERROR THEN
1578: P_return_status := FND_API.G_RET_STS_ERROR;
1579: WHEN OTHERS THEN
1580: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1581: FND_MSG_PUB.ADD;
1582: END get_step_material_lines;

Line 1580: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1576: FND_MSG_PUB.ADD;
1577: WHEN COST_SCALING_ERROR THEN
1578: P_return_status := FND_API.G_RET_STS_ERROR;
1579: WHEN OTHERS THEN
1580: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1581: FND_MSG_PUB.ADD;
1582: END get_step_material_lines;
1583:
1584:

Line 1652: P_return_status := FND_API.G_RET_STS_SUCCESS;

1648: X_step_vol_qty NUMBER;
1649: X_step_other_qty NUMBER;
1650: X_count NUMBER;
1651: BEGIN
1652: P_return_status := FND_API.G_RET_STS_SUCCESS;
1653: X_count := P_step_tbl.COUNT;
1654: FOR i IN 1..X_count LOOP
1655: FOR j IN i+1..X_count LOOP
1656: IF P_step_tbl(i).step_no > P_step_tbl(j).step_no THEN

Line 1686: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1682: END LOOP; /* FOR j IN 1..X_count */
1683: END LOOP; /* FOR i IN 1..X_count */
1684: EXCEPTION
1685: WHEN OTHERS THEN
1686: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1687: FND_MSG_PUB.ADD;
1688: END sort_step_lines;
1689:
1690:

Line 1836: P_return_status := FND_API.G_RET_STS_SUCCESS;

1832: ROUTING_DETAILS_MISSING EXCEPTION;
1833: ALL_MTL_LINES_NOT_ASSOC EXCEPTION;
1834: UOM_CONVERSION_ERROR EXCEPTION;
1835: BEGIN
1836: P_return_status := FND_API.G_RET_STS_SUCCESS;
1837: FND_MSG_PUB.INITIALIZE;
1838:
1839: /* If recipe id is null it implies that the material
1840: step association has not been done */

Line 2002: P_return_status := FND_API.G_RET_STS_ERROR;

1998:
1999: END LOOP;
2000: EXCEPTION
2001: WHEN NO_ROUTING_ASSOCIATED THEN
2002: P_return_status := FND_API.G_RET_STS_ERROR;
2003: FND_MESSAGE.SET_NAME('GMD', 'GMD_AUTO_STEP_QTY_NEEDS_ROUT');
2004: FND_MSG_PUB.ADD;
2005: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2006: P_data => P_msg_stack);

Line 2008: P_return_status := FND_API.G_RET_STS_ERROR;

2004: FND_MSG_PUB.ADD;
2005: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2006: P_data => P_msg_stack);
2007: WHEN ROUTING_DETAILS_MISSING THEN
2008: P_return_status := FND_API.G_RET_STS_ERROR;
2009: FND_MESSAGE.SET_NAME('GMD', 'FMROUTINGSTEPNOTFOUND');
2010: FND_MSG_PUB.ADD;
2011: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2012: P_data => P_msg_stack);

Line 2014: P_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2021: P_return_status := FND_API.G_RET_STS_ERROR;

2017: FND_MSG_PUB.ADD;
2018: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2019: P_data => P_msg_stack);
2020: WHEN ALL_MTL_LINES_NOT_ASSOC THEN
2021: P_return_status := FND_API.G_RET_STS_ERROR;
2022: -- debug line p_return_status := 'Y';
2023: FND_MESSAGE.SET_NAME('GMD', 'GMD_ALL_MATL_STEP_NOT_ASSOC');
2024: FND_MSG_PUB.ADD;
2025: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,

Line 2028: P_return_status := FND_API.G_RET_STS_ERROR;

2024: FND_MSG_PUB.ADD;
2025: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2026: P_data => P_msg_stack);
2027: WHEN UOM_CONVERSION_ERROR THEN
2028: P_return_status := FND_API.G_RET_STS_ERROR;
2029: OPEN Cur_get_item;
2030: FETCH Cur_get_item INTO X_item_no;
2031: CLOSE Cur_get_item;
2032: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');

Line 2040: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2036: FND_MSG_PUB.ADD;
2037: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2038: P_data => P_msg_stack);
2039: WHEN OTHERS THEN
2040: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2041: fnd_message.set_name('GMD',SQLERRM);
2042: fnd_msg_pub.add;
2043: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2044: P_data => P_msg_stack);

Line 2101: P_return_status := FND_API.G_RET_STS_SUCCESS;

2097:
2098: x_recipe_cntr NUMBER := 0;
2099:
2100: BEGIN
2101: P_return_status := FND_API.G_RET_STS_SUCCESS;
2102: -- 1. Get a list of recipes where this formulaline exists in step/mat association,
2103: -- and where calculate_step_qty flag IS set (ASQC=Yes)
2104: -- and where delete_mark is NOT set
2105: -- and the recipe is NOT marked obsolete.

Line 2126: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2122: EXCEPTION
2123: WHEN OTHERS THEN
2124: -- It is OK if no rows are found in step/mat table.
2125: -- This exception is for database errors
2126: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2127: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2128: P_data => P_msg_stack);
2129: END check_del_from_step_mat;
2130:

Line 2183: P_return_status := FND_API.G_RET_STS_SUCCESS;

2179: x_ignore_vol_conv BOOLEAN;
2180: ALL_MTL_LINES_NOT_ASSOC EXCEPTION;
2181:
2182: BEGIN
2183: P_return_status := FND_API.G_RET_STS_SUCCESS;
2184: -- Calling program should delete from fm_matl_dtl.
2185: -- DELETE FROM fm_matl_dtl WHERE formulaline_id = P_formulaline_id;
2186: -- 1. Use gmd_auto_step_calc.check_del_from_step_mat to get a list of recipes where
2187: -- this formulaline exists in step/mat association,

Line 2312: P_return_status := FND_API.G_RET_STS_ERROR;

2308: P_data => P_msg_stack);
2309: -- debug dbms_output.put_line ('in exception ' || p_return_status);
2310:
2311: WHEN ALL_MTL_LINES_NOT_ASSOC THEN
2312: P_return_status := FND_API.G_RET_STS_ERROR;
2313: FND_MESSAGE.SET_NAME('GMD', 'GMD_ALL_MATL_STEP_NOT_ASSOC');
2314: FND_MSG_PUB.ADD;
2315: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2316: P_data => P_msg_stack);

Line 2320: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2316: P_data => P_msg_stack);
2317: WHEN OTHERS THEN
2318: -- It is OK if no rows are found in step/mat table.
2319: -- The 3 procedures called have their own error handling.
2320: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2321: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2322: P_data => P_msg_stack);
2323: END cascade_del_to_step_mat;
2324: