DBA Data[Home] [Help]

APPS.GMD_AUTO_STEP_CALC dependencies on FND_MESSAGE

Line 465: FND_MESSAGE.SET_NAME('GMA', 'SY_KEYMISSING');

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);
469: WHEN LOAD_STEPS_FAILED THEN

Line 475: FND_MESSAGE.SET_NAME('GMD', 'GMD_STEP_NOT_MASS_VOL_UOM');

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);
479: WHEN GET_STEP_MATERIAL_LINES_FAILED THEN

Line 787: FND_MESSAGE.SET_NAME('GMD', 'GMD_AUTO_STEP_QTY_NEEDS_ROUT');

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;
791: FND_MESSAGE.SET_NAME('GMD', 'FMROUTINGSTEPNOTFOUND');

Line 791: FND_MESSAGE.SET_NAME('GMD', 'FMROUTINGSTEPNOTFOUND');

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
795: P_return_status := FND_API.G_RET_STS_ERROR;

Line 796: FND_MESSAGE.SET_NAME('GMD', 'GMD_CIRCULAR_DEPEN_DETECT');

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;
800: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 800: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_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;
804:

Line 801: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

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;
804:
805: /*======================================================================

Line 1255: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');

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');
1256: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
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;

Line 1256: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);

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');
1256: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
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

Line 1257: FND_MESSAGE.SET_TOKEN('FROM_UOM', X_from_uom);

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');
1256: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
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;

Line 1258: FND_MESSAGE.SET_TOKEN('TO_UOM', X_to_uom);

1254: CLOSE Cur_get_item;
1255: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1256: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
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');

Line 1262: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_MATL_STEP_ASSOC');

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;
1266: FND_MSG_PUB.ADD;

Line 1568: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');

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');
1569: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
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;

Line 1569: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);

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');
1569: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
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

Line 1570: FND_MESSAGE.SET_TOKEN('FROM_UOM', X_from_uom);

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');
1569: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
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;

Line 1571: FND_MESSAGE.SET_TOKEN('TO_UOM', X_to_uom);

1567: CLOSE Cur_get_item;
1568: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1569: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
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');

Line 1575: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_MATL_STEP_ASSOC');

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;
1579: WHEN OTHERS THEN

Line 2003: FND_MESSAGE.SET_NAME('GMD', 'GMD_AUTO_STEP_QTY_NEEDS_ROUT');

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);
2007: WHEN ROUTING_DETAILS_MISSING THEN

Line 2009: FND_MESSAGE.SET_NAME('GMD', 'FMROUTINGSTEPNOTFOUND');

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);
2013: WHEN NO_MATERIAL_STEP_ASSOC THEN

Line 2016: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_MATL_STEP_ASSOC');

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,
2019: P_data => P_msg_stack);
2020: WHEN ALL_MTL_LINES_NOT_ASSOC THEN

Line 2023: FND_MESSAGE.SET_NAME('GMD', 'GMD_ALL_MATL_STEP_NOT_ASSOC');

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,
2026: P_data => P_msg_stack);
2027: WHEN UOM_CONVERSION_ERROR THEN

Line 2032: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');

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');
2033: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
2034: FND_MESSAGE.SET_TOKEN('FROM_UOM', X_from_uom);
2035: FND_MESSAGE.SET_TOKEN('TO_UOM', X_to_uom);
2036: FND_MSG_PUB.ADD;

Line 2033: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);

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');
2033: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
2034: FND_MESSAGE.SET_TOKEN('FROM_UOM', X_from_uom);
2035: FND_MESSAGE.SET_TOKEN('TO_UOM', X_to_uom);
2036: FND_MSG_PUB.ADD;
2037: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,

Line 2034: FND_MESSAGE.SET_TOKEN('FROM_UOM', X_from_uom);

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');
2033: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
2034: FND_MESSAGE.SET_TOKEN('FROM_UOM', X_from_uom);
2035: FND_MESSAGE.SET_TOKEN('TO_UOM', X_to_uom);
2036: FND_MSG_PUB.ADD;
2037: FND_MSG_PUB.COUNT_AND_GET (P_count => P_msg_count,
2038: P_data => P_msg_stack);

Line 2035: FND_MESSAGE.SET_TOKEN('TO_UOM', X_to_uom);

2031: CLOSE Cur_get_item;
2032: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');
2033: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
2034: FND_MESSAGE.SET_TOKEN('FROM_UOM', X_from_uom);
2035: FND_MESSAGE.SET_TOKEN('TO_UOM', X_to_uom);
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

Line 2041: fnd_message.set_name('GMD',SQLERRM);

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);
2045: END check_step_qty_calculatable;

Line 2313: FND_MESSAGE.SET_NAME('GMD', 'GMD_ALL_MATL_STEP_NOT_ASSOC');

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);
2317: WHEN OTHERS THEN