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_FORMULA_DESIGNER_PKG dependencies on FND_MESSAGE

Line 385: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

381: x_return_code := 'F';
382: x_error_msg := l_message;
383:
384: WHEN RECORD_CHANGED_EXCEPTION THEN
385: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
386: x_return_code := 'F';
387: x_error_msg := gmd_api_grp.get_message;
388:
389: WHEN OTHERS THEN

Line 390: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

386: x_return_code := 'F';
387: x_error_msg := gmd_api_grp.get_message;
388:
389: WHEN OTHERS THEN
390: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
391: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
392: x_return_code := 'F';
393: x_error_msg := gmd_api_grp.get_message;
394:

Line 391: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

387: x_error_msg := gmd_api_grp.get_message;
388:
389: WHEN OTHERS THEN
390: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
391: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
392: x_return_code := 'F';
393: x_error_msg := gmd_api_grp.get_message;
394:
395: END Update_Formula_Header;

Line 623: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

619: x_error_msg := l_message;
620:
621: WHEN RECORD_CHANGED_EXCEPTION THEN
622: ROLLBACK TO Add_Item;
623: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
624: x_return_code := 'F';
625: x_error_msg := gmd_api_grp.get_message;
626:
627: WHEN OTHERS THEN

Line 629: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

625: x_error_msg := gmd_api_grp.get_message;
626:
627: WHEN OTHERS THEN
628: ROLLBACK TO Add_Item;
629: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
630: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
631: x_return_code := 'F';
632: x_error_msg := gmd_api_grp.get_message;
633:

Line 630: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

626:
627: WHEN OTHERS THEN
628: ROLLBACK TO Add_Item;
629: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
630: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
631: x_return_code := 'F';
632: x_error_msg := gmd_api_grp.get_message;
633:
634: END Insert_Formula_Detail;

Line 938: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

934: x_return_code := 'F';
935: x_error_msg := l_message;
936:
937: WHEN RECORD_CHANGED_EXCEPTION THEN
938: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
939: x_return_code := 'F';
940: x_error_msg := gmd_api_grp.get_message;
941:
942: WHEN OTHERS THEN

Line 943: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

939: x_return_code := 'F';
940: x_error_msg := gmd_api_grp.get_message;
941:
942: WHEN OTHERS THEN
943: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
944: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
945: x_return_code := 'F';
946: x_error_msg := gmd_api_grp.get_message;
947:

Line 944: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

940: x_error_msg := gmd_api_grp.get_message;
941:
942: WHEN OTHERS THEN
943: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
944: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
945: x_return_code := 'F';
946: x_error_msg := gmd_api_grp.get_message;
947:
948: END Update_Formula_Detail;

Line 1117: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_FORMULA_ID');

1113: x_return_code := 'F';
1114: x_error_msg := l_message;
1115:
1116: WHEN GET_SURROGATE_EXCEPTION THEN
1117: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_FORMULA_ID');
1118: x_return_code := 'F';
1119: x_error_msg := gmd_api_grp.get_message;
1120:
1121: WHEN OTHERS THEN

Line 1122: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1118: x_return_code := 'F';
1119: x_error_msg := gmd_api_grp.get_message;
1120:
1121: WHEN OTHERS THEN
1122: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1123: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1124: x_return_code := 'F';
1125: x_error_msg := gmd_api_grp.get_message;
1126:

Line 1123: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1119: x_error_msg := gmd_api_grp.get_message;
1120:
1121: WHEN OTHERS THEN
1122: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1123: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1124: x_return_code := 'F';
1125: x_error_msg := gmd_api_grp.get_message;
1126:
1127: END Create_Formula_Header;

Line 1222: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

1218:
1219: x_return_code := 'F';
1220: x_error_msg := l_message;
1221: WHEN RECORD_CHANGED_EXCEPTION THEN
1222: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1223: x_return_code := 'F';
1224: x_error_msg := gmd_api_grp.get_message;
1225: WHEN OTHERS THEN
1226: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 1226: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1222: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1223: x_return_code := 'F';
1224: x_error_msg := gmd_api_grp.get_message;
1225: WHEN OTHERS THEN
1226: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1227: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1228: x_return_code := 'F';
1229: x_error_msg := gmd_api_grp.get_message;
1230:

Line 1227: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1223: x_return_code := 'F';
1224: x_error_msg := gmd_api_grp.get_message;
1225: WHEN OTHERS THEN
1226: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1227: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1228: x_return_code := 'F';
1229: x_error_msg := gmd_api_grp.get_message;
1230:
1231: END Delete_Formula_Detail;

Line 1302: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

1298: formulaline_id = p_formulaline_id;
1299:
1300: EXCEPTION
1301: WHEN RECORD_CHANGED_EXCEPTION THEN
1302: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1303: x_return_code := 'F';
1304: x_error_msg := gmd_api_grp.get_message;
1305: WHEN OTHERS THEN
1306: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 1306: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1302: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1303: x_return_code := 'F';
1304: x_error_msg := gmd_api_grp.get_message;
1305: WHEN OTHERS THEN
1306: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1307: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1308: x_return_code := 'F';
1309: x_error_msg := gmd_api_grp.get_message;
1310:

Line 1307: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1303: x_return_code := 'F';
1304: x_error_msg := gmd_api_grp.get_message;
1305: WHEN OTHERS THEN
1306: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1307: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1308: x_return_code := 'F';
1309: x_error_msg := gmd_api_grp.get_message;
1310:
1311: END Del_Formula_Detail_With_No_Val;

Line 1369: FND_MESSAGE.SET_NAME ('GMD','FM_SUM_ALLOC <> 1');

1365: END IF;
1366:
1367: EXCEPTION
1368: WHEN COST_ALLOC_EXCEPTION THEN
1369: FND_MESSAGE.SET_NAME ('GMD','FM_SUM_ALLOC <> 1');
1370: x_return_code := 'W';
1371: x_error_msg := gmd_api_grp.get_message;
1372:
1373: WHEN OTHERS THEN

Line 1374: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1370: x_return_code := 'W';
1371: x_error_msg := gmd_api_grp.get_message;
1372:
1373: WHEN OTHERS THEN
1374: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1375: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1376: x_return_code := 'F';
1377: x_error_msg := gmd_api_grp.get_message;
1378:

Line 1375: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1371: x_error_msg := gmd_api_grp.get_message;
1372:
1373: WHEN OTHERS THEN
1374: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1375: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1376: x_return_code := 'F';
1377: x_error_msg := gmd_api_grp.get_message;
1378:
1379: END Validate_Cost_Allocation;

Line 1453: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');

1449: ,from_name => NULL
1450: ,to_name => NULL);
1451:
1452: IF (l_qty = -1) THEN
1453: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');
1454: RAISE CONV_ITEM_EXCEPTION;
1455: ELSIF (l_qty = -3) THEN
1456: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
1457: RAISE CONV_ITEM_EXCEPTION;

Line 1456: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');

1452: IF (l_qty = -1) THEN
1453: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');
1454: RAISE CONV_ITEM_EXCEPTION;
1455: ELSIF (l_qty = -3) THEN
1456: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
1457: RAISE CONV_ITEM_EXCEPTION;
1458: ELSIF (l_qty = -4) THEN
1459: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
1460: RAISE CONV_ITEM_EXCEPTION;

Line 1459: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');

1455: ELSIF (l_qty = -3) THEN
1456: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
1457: RAISE CONV_ITEM_EXCEPTION;
1458: ELSIF (l_qty = -4) THEN
1459: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
1460: RAISE CONV_ITEM_EXCEPTION;
1461: ELSIF (l_qty = -5) THEN
1462: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
1463: FND_MESSAGE.set_token('FROMUOM',p_item_uom);

Line 1462: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

1458: ELSIF (l_qty = -4) THEN
1459: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
1460: RAISE CONV_ITEM_EXCEPTION;
1461: ELSIF (l_qty = -5) THEN
1462: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
1463: FND_MESSAGE.set_token('FROMUOM',p_item_uom);
1464: FND_MESSAGE.set_token('TOUOM',l_inv_uom);
1465: RAISE CONV_ITEM_EXCEPTION;
1466: ELSIF (l_qty = -6) THEN

Line 1463: FND_MESSAGE.set_token('FROMUOM',p_item_uom);

1459: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
1460: RAISE CONV_ITEM_EXCEPTION;
1461: ELSIF (l_qty = -5) THEN
1462: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
1463: FND_MESSAGE.set_token('FROMUOM',p_item_uom);
1464: FND_MESSAGE.set_token('TOUOM',l_inv_uom);
1465: RAISE CONV_ITEM_EXCEPTION;
1466: ELSIF (l_qty = -6) THEN
1467: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');

Line 1464: FND_MESSAGE.set_token('TOUOM',l_inv_uom);

1460: RAISE CONV_ITEM_EXCEPTION;
1461: ELSIF (l_qty = -5) THEN
1462: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
1463: FND_MESSAGE.set_token('FROMUOM',p_item_uom);
1464: FND_MESSAGE.set_token('TOUOM',l_inv_uom);
1465: RAISE CONV_ITEM_EXCEPTION;
1466: ELSIF (l_qty = -6) THEN
1467: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
1468: RAISE CONV_ITEM_EXCEPTION;

Line 1467: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');

1463: FND_MESSAGE.set_token('FROMUOM',p_item_uom);
1464: FND_MESSAGE.set_token('TOUOM',l_inv_uom);
1465: RAISE CONV_ITEM_EXCEPTION;
1466: ELSIF (l_qty = -6) THEN
1467: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
1468: RAISE CONV_ITEM_EXCEPTION;
1469: ELSIF (l_qty = -7) THEN
1470: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
1471: RAISE CONV_ITEM_EXCEPTION;

Line 1470: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');

1466: ELSIF (l_qty = -6) THEN
1467: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
1468: RAISE CONV_ITEM_EXCEPTION;
1469: ELSIF (l_qty = -7) THEN
1470: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
1471: RAISE CONV_ITEM_EXCEPTION;
1472: ELSIF (l_qty = -10) THEN
1473: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
1474: FND_MESSAGE.set_token('FROMUOM',p_item_uom);

Line 1473: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

1469: ELSIF (l_qty = -7) THEN
1470: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
1471: RAISE CONV_ITEM_EXCEPTION;
1472: ELSIF (l_qty = -10) THEN
1473: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
1474: FND_MESSAGE.set_token('FROMUOM',p_item_uom);
1475: FND_MESSAGE.set_token('TOUOM',l_inv_uom);
1476: RAISE CONV_ITEM_EXCEPTION;
1477: ELSIF (l_qty = -11) THEN

Line 1474: FND_MESSAGE.set_token('FROMUOM',p_item_uom);

1470: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
1471: RAISE CONV_ITEM_EXCEPTION;
1472: ELSIF (l_qty = -10) THEN
1473: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
1474: FND_MESSAGE.set_token('FROMUOM',p_item_uom);
1475: FND_MESSAGE.set_token('TOUOM',l_inv_uom);
1476: RAISE CONV_ITEM_EXCEPTION;
1477: ELSIF (l_qty = -11) THEN
1478: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');

Line 1475: FND_MESSAGE.set_token('TOUOM',l_inv_uom);

1471: RAISE CONV_ITEM_EXCEPTION;
1472: ELSIF (l_qty = -10) THEN
1473: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
1474: FND_MESSAGE.set_token('FROMUOM',p_item_uom);
1475: FND_MESSAGE.set_token('TOUOM',l_inv_uom);
1476: RAISE CONV_ITEM_EXCEPTION;
1477: ELSIF (l_qty = -11) THEN
1478: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
1479: RAISE CONV_ITEM_EXCEPTION;

Line 1478: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');

1474: FND_MESSAGE.set_token('FROMUOM',p_item_uom);
1475: FND_MESSAGE.set_token('TOUOM',l_inv_uom);
1476: RAISE CONV_ITEM_EXCEPTION;
1477: ELSIF (l_qty = -11) THEN
1478: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
1479: RAISE CONV_ITEM_EXCEPTION;
1480: ELSIF (l_qty < -11) THEN
1481: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');
1482: RAISE CONV_ITEM_EXCEPTION;

Line 1481: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');

1477: ELSIF (l_qty = -11) THEN
1478: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
1479: RAISE CONV_ITEM_EXCEPTION;
1480: ELSIF (l_qty < -11) THEN
1481: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');
1482: RAISE CONV_ITEM_EXCEPTION;
1483: END IF;
1484: EXCEPTION
1485: WHEN ITEM_UM_EXCEPTION THEN

Line 1486: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');

1482: RAISE CONV_ITEM_EXCEPTION;
1483: END IF;
1484: EXCEPTION
1485: WHEN ITEM_UM_EXCEPTION THEN
1486: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');
1487: x_return_code := 'F';
1488: x_error_msg := gmd_api_grp.get_message;
1489: WHEN CONV_ITEM_EXCEPTION THEN
1490: x_return_code := 'F';

Line 1493: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1489: WHEN CONV_ITEM_EXCEPTION THEN
1490: x_return_code := 'F';
1491: x_error_msg := gmd_api_grp.get_message;
1492: WHEN OTHERS THEN
1493: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1494: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1495: x_return_code := 'F';
1496: x_error_msg := gmd_api_grp.get_message;
1497:

Line 1494: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1490: x_return_code := 'F';
1491: x_error_msg := gmd_api_grp.get_message;
1492: WHEN OTHERS THEN
1493: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1494: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1495: x_return_code := 'F';
1496: x_error_msg := gmd_api_grp.get_message;
1497:
1498: END Validate_Item_Uom;

Line 1570: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORM_DEL_RECALC_AUTO_STEP');

1566: x_nb_recipes := 0;
1567:
1568: IF l_check_step_mat.asqc_recipes > 0 THEN
1569: x_nb_recipes := l_check_step_mat.asqc_recipes;
1570: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORM_DEL_RECALC_AUTO_STEP');
1571: FND_MESSAGE.SET_TOKEN('RECIPE_NO', x_nb_recipes);
1572: x_warning_message := gmd_api_grp.get_message;
1573: ELSE
1574: -- Else Check if there are any rows in gmd_recipe_step_materials with this

Line 1571: FND_MESSAGE.SET_TOKEN('RECIPE_NO', x_nb_recipes);

1567:
1568: IF l_check_step_mat.asqc_recipes > 0 THEN
1569: x_nb_recipes := l_check_step_mat.asqc_recipes;
1570: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORM_DEL_RECALC_AUTO_STEP');
1571: FND_MESSAGE.SET_TOKEN('RECIPE_NO', x_nb_recipes);
1572: x_warning_message := gmd_api_grp.get_message;
1573: ELSE
1574: -- Else Check if there are any rows in gmd_recipe_step_materials with this
1575: -- formulaline_id, regardless of ASQC flag

Line 1578: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORM_DEL_REVIEW_STEP_QTY');

1574: -- Else Check if there are any rows in gmd_recipe_step_materials with this
1575: -- formulaline_id, regardless of ASQC flag
1576: IF l_check_step_mat.step_assoc_recipes > 0 THEN
1577: x_nb_recipes := l_check_step_mat.step_assoc_recipes;
1578: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORM_DEL_REVIEW_STEP_QTY');
1579: FND_MESSAGE.SET_TOKEN('RECIPE_NO', x_nb_recipes);
1580: x_warning_message := gmd_api_grp.get_message;
1581: END IF;
1582: END IF;

Line 1579: FND_MESSAGE.SET_TOKEN('RECIPE_NO', x_nb_recipes);

1575: -- formulaline_id, regardless of ASQC flag
1576: IF l_check_step_mat.step_assoc_recipes > 0 THEN
1577: x_nb_recipes := l_check_step_mat.step_assoc_recipes;
1578: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORM_DEL_REVIEW_STEP_QTY');
1579: FND_MESSAGE.SET_TOKEN('RECIPE_NO', x_nb_recipes);
1580: x_warning_message := gmd_api_grp.get_message;
1581: END IF;
1582: END IF;
1583:

Line 1595: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1591: x_return_code := 'F';
1592: x_error_msg := l_message;
1593:
1594: WHEN OTHERS THEN
1595: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1596: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1597: x_return_code := 'F';
1598: x_error_msg := gmd_api_grp.get_message;
1599:

Line 1596: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1592: x_error_msg := l_message;
1593:
1594: WHEN OTHERS THEN
1595: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1596: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1597: x_return_code := 'F';
1598: x_error_msg := gmd_api_grp.get_message;
1599:
1600: END Check_Item_Used_In_Recipe;

Line 1675: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1671:
1672: x_return_code := 'F';
1673: x_error_msg := l_message;
1674: WHEN OTHERS THEN
1675: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1676: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1677: x_return_code := 'F';
1678: x_error_msg := gmd_api_grp.get_message;
1679:

Line 1676: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1672: x_return_code := 'F';
1673: x_error_msg := l_message;
1674: WHEN OTHERS THEN
1675: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1676: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1677: x_return_code := 'F';
1678: x_error_msg := gmd_api_grp.get_message;
1679:
1680: END Cascade_Update_Recipes;

Line 1828: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1824: x_return_code := 'F';
1825: x_error_msg := l_message;
1826:
1827: WHEN OTHERS THEN
1828: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1829: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1830: x_return_code := 'F';
1831: x_error_msg := gmd_api_grp.get_message;
1832:

Line 1829: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1825: x_error_msg := l_message;
1826:
1827: WHEN OTHERS THEN
1828: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1829: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1830: x_return_code := 'F';
1831: x_error_msg := gmd_api_grp.get_message;
1832:
1833: END Calculate_Theoretical_yield;

Line 1993: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1989: x_return_code := 'F';
1990: x_error_msg := l_message;
1991:
1992: WHEN OTHERS THEN
1993: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1994: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1995: x_return_code := 'F';
1996: x_error_msg := gmd_api_grp.get_message;
1997:

Line 1994: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1990: x_error_msg := l_message;
1991:
1992: WHEN OTHERS THEN
1993: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1994: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1995: x_return_code := 'F';
1996: x_error_msg := gmd_api_grp.get_message;
1997:
1998: END Scale_Formula;

Line 2068: FND_MESSAGE.SET_NAME('GMD', 'GMD_MUST_HAVE_PRODUCT');

2064: -- Check product
2065: OPEN check_num_details(1);
2066: FETCH check_num_details INTO l_count;
2067: IF check_num_details%NOTFOUND THEN
2068: FND_MESSAGE.SET_NAME('GMD', 'GMD_MUST_HAVE_PRODUCT');
2069: x_return_code := 'F';
2070: END IF;
2071: CLOSE check_num_details;
2072:

Line 2078: FND_MESSAGE.SET_NAME('GMD', 'GMD_MUST_HAVE_INGREDIENT');

2074: -- Check ingredient
2075: OPEN check_num_details(-1);
2076: FETCH check_num_details INTO l_count;
2077: IF check_num_details%NOTFOUND THEN
2078: FND_MESSAGE.SET_NAME('GMD', 'GMD_MUST_HAVE_INGREDIENT');
2079: x_return_code := 'F';
2080: -- Sriram.S Bug# 3702561 Check for ingr. with zero qty. based on profile.
2081: ELSIF (FND_PROFILE.VALUE('FM$ALLOW_ZERO_INGR_QTY')=0) THEN
2082: OPEN check_for_zero_qty(-1);

Line 2085: FND_MESSAGE.SET_NAME('GMD','GMD_ZERO_QTY');

2081: ELSIF (FND_PROFILE.VALUE('FM$ALLOW_ZERO_INGR_QTY')=0) THEN
2082: OPEN check_for_zero_qty(-1);
2083: FETCH check_for_zero_qty INTO l_count;
2084: IF check_for_zero_qty%FOUND THEN
2085: FND_MESSAGE.SET_NAME('GMD','GMD_ZERO_QTY');
2086: x_return_code := 'F';
2087: END IF;
2088: CLOSE check_for_zero_qty;
2089: END IF;

Line 2136: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

2132: END IF;
2133:
2134: EXCEPTION
2135: WHEN OTHERS THEN
2136: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2137: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2138: x_return_code := 'F';
2139: x_error_msg := gmd_api_grp.get_message;
2140:

Line 2137: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

2133:
2134: EXCEPTION
2135: WHEN OTHERS THEN
2136: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2137: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2138: x_return_code := 'F';
2139: x_error_msg := gmd_api_grp.get_message;
2140:
2141: END Validate_Formula_Details;

Line 2176: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

2172: SAVEPOINT Start_Transaction;
2173:
2174: EXCEPTION
2175: WHEN OTHERS THEN
2176: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2177: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2178: x_return_code := 'F';
2179: x_error_msg := gmd_api_grp.get_message;
2180:

Line 2177: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

2173:
2174: EXCEPTION
2175: WHEN OTHERS THEN
2176: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2177: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2178: x_return_code := 'F';
2179: x_error_msg := gmd_api_grp.get_message;
2180:
2181: END Set_Save_Point;

Line 2216: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

2212: ROLLBACK TO Start_Transaction;
2213:
2214: EXCEPTION
2215: WHEN OTHERS THEN
2216: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2217: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2218: x_return_code := 'F';
2219: x_error_msg := gmd_api_grp.get_message;
2220:

Line 2217: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

2213:
2214: EXCEPTION
2215: WHEN OTHERS THEN
2216: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2217: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2218: x_return_code := 'F';
2219: x_error_msg := gmd_api_grp.get_message;
2220:
2221: END Rollback_Save_Point;

Line 2275: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

2271: CLOSE check_fsec_resp;
2272:
2273: EXCEPTION
2274: WHEN OTHERS THEN
2275: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2276: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2277: x_return_code := 'N';
2278: x_error_msg := gmd_api_grp.get_message;
2279:

Line 2276: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

2272:
2273: EXCEPTION
2274: WHEN OTHERS THEN
2275: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2276: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2277: x_return_code := 'N';
2278: x_error_msg := gmd_api_grp.get_message;
2279:
2280: END check_usr_has_fsec_resp;

Line 2383: FND_MESSAGE.SET_NAME('INV','INV_INT_REVEXP');

2379: END IF;
2380: CLOSE Cur_check_revision;
2381: EXCEPTION
2382: WHEN ITEM_REV_EXCEPTION THEN
2383: FND_MESSAGE.SET_NAME('INV','INV_INT_REVEXP');
2384: x_return_code := 'F';
2385: x_error_msg := gmd_api_grp.get_message;
2386: WHEN OTHERS THEN
2387: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 2387: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

2383: FND_MESSAGE.SET_NAME('INV','INV_INT_REVEXP');
2384: x_return_code := 'F';
2385: x_error_msg := gmd_api_grp.get_message;
2386: WHEN OTHERS THEN
2387: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2388: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2389: x_return_code := 'F';
2390: x_error_msg := gmd_api_grp.get_message;
2391: END Validate_Item_Revision;

Line 2388: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

2384: x_return_code := 'F';
2385: x_error_msg := gmd_api_grp.get_message;
2386: WHEN OTHERS THEN
2387: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2388: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2389: x_return_code := 'F';
2390: x_error_msg := gmd_api_grp.get_message;
2391: END Validate_Item_Revision;
2392: