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

Line 188: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');

184: xTable_out => pTable_out,
185: xReturn => x_return_status);
186: IF (x_return_status <> 'S') THEN
187: IF (p_formula_detail_rec.formula_no IS NULL) THEN
188: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
189: FND_MSG_PUB.Add;
190: ELSIF (p_formula_detail_rec.formula_vers IS NULL) THEN
191: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
192: FND_MSG_PUB.Add;

Line 191: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');

187: IF (p_formula_detail_rec.formula_no IS NULL) THEN
188: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
189: FND_MSG_PUB.Add;
190: ELSIF (p_formula_detail_rec.formula_vers IS NULL) THEN
191: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
192: FND_MSG_PUB.Add;
193: ELSE
194: FND_MESSAGE.SET_NAME('GMD', 'FM_INVFORMULANO');
195: FND_MESSAGE.SET_TOKEN('FORMULA_NO',p_formula_detail_rec.formula_no);

Line 194: FND_MESSAGE.SET_NAME('GMD', 'FM_INVFORMULANO');

190: ELSIF (p_formula_detail_rec.formula_vers IS NULL) THEN
191: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
192: FND_MSG_PUB.Add;
193: ELSE
194: FND_MESSAGE.SET_NAME('GMD', 'FM_INVFORMULANO');
195: FND_MESSAGE.SET_TOKEN('FORMULA_NO',p_formula_detail_rec.formula_no);
196: FND_MSG_PUB.Add;
197: END IF;
198: RAISE FND_API.G_EXC_ERROR;

Line 195: FND_MESSAGE.SET_TOKEN('FORMULA_NO',p_formula_detail_rec.formula_no);

191: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
192: FND_MSG_PUB.Add;
193: ELSE
194: FND_MESSAGE.SET_NAME('GMD', 'FM_INVFORMULANO');
195: FND_MESSAGE.SET_TOKEN('FORMULA_NO',p_formula_detail_rec.formula_no);
196: FND_MSG_PUB.Add;
197: END IF;
198: RAISE FND_API.G_EXC_ERROR;
199: ELSE

Line 213: FND_MESSAGE.SET_NAME('GMI', 'GMI_API_ITEM_NOT_FOUND');

209:
210: p_formula_detail_rec.owner_organization_id := l_org_id;
211:
212: IF (p_formula_detail_rec.inventory_item_id is NULL AND p_formula_detail_rec.item_no IS NULL) THEN
213: FND_MESSAGE.SET_NAME('GMI', 'GMI_API_ITEM_NOT_FOUND');
214: FND_MSG_PUB.Add;
215: ELSE
216: GMDFMVAL_PUB.get_item_id(pitem_no => p_formula_detail_rec.item_no,
217: pinventory_item_id => p_formula_detail_rec.inventory_item_id,

Line 223: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');

219: xitem_id => l_item_id,
220: xitem_um => l_inv_uom,
221: xreturn_code => l_return_val);
222: IF (l_return_val < 0) THEN
223: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
224: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_formula_detail_rec.item_no);
225: FND_MSG_PUB.Add;
226: RAISE FND_API.G_EXC_ERROR;
227: END IF;

Line 224: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_formula_detail_rec.item_no);

220: xitem_um => l_inv_uom,
221: xreturn_code => l_return_val);
222: IF (l_return_val < 0) THEN
223: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
224: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_formula_detail_rec.item_no);
225: FND_MSG_PUB.Add;
226: RAISE FND_API.G_EXC_ERROR;
227: END IF;
228: END IF;

Line 248: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_NOT_RECIPE_ENABLED');

244: p_data => x_msg_data );
245: END;
246:
247: IF v_recipe_enabled <> 'Y' THEN
248: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_NOT_RECIPE_ENABLED');
249: FND_MESSAGE.SET_TOKEN('ITEM_NO', v_item_no);
250: FND_MSG_PUB.Add;
251: RAISE FND_API.G_EXC_ERROR;
252: END IF ;

Line 249: FND_MESSAGE.SET_TOKEN('ITEM_NO', v_item_no);

245: END;
246:
247: IF v_recipe_enabled <> 'Y' THEN
248: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_NOT_RECIPE_ENABLED');
249: FND_MESSAGE.SET_TOKEN('ITEM_NO', v_item_no);
250: FND_MSG_PUB.Add;
251: RAISE FND_API.G_EXC_ERROR;
252: END IF ;
253:

Line 262: FND_MESSAGE.SET_NAME('GMD', 'GMD_USER_CONTEXT_NOT_SET');

258: END IF;
259: -- Bug 4603060 Use the user from context
260: l_user_id := FND_GLOBAL.user_id;
261: IF (l_user_id IS NULL) THEN
262: FND_MESSAGE.SET_NAME('GMD', 'GMD_USER_CONTEXT_NOT_SET');
263: FND_MSG_PUB.Add;
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266:

Line 296: FND_MESSAGE.SET_NAME('GMD','FM_DUPLICATE_LINE_NO');

292: (l_formula_id,
293: p_formula_detail_rec.line_no,
294: p_formula_detail_rec.line_type);
295: IF (l_return_val <> 0) THEN
296: FND_MESSAGE.SET_NAME('GMD','FM_DUPLICATE_LINE_NO');
297: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_formula_detail_rec.item_no);
298: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_detail_rec.formula_no);
299: FND_MESSAGE.SET_TOKEN('FORMULA_VERS',p_formula_detail_rec.formula_vers );
300: FND_MSG_PUB.Add;

Line 297: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_formula_detail_rec.item_no);

293: p_formula_detail_rec.line_no,
294: p_formula_detail_rec.line_type);
295: IF (l_return_val <> 0) THEN
296: FND_MESSAGE.SET_NAME('GMD','FM_DUPLICATE_LINE_NO');
297: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_formula_detail_rec.item_no);
298: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_detail_rec.formula_no);
299: FND_MESSAGE.SET_TOKEN('FORMULA_VERS',p_formula_detail_rec.formula_vers );
300: FND_MSG_PUB.Add;
301: RAISE FND_API.G_EXC_ERROR;

Line 298: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_detail_rec.formula_no);

294: p_formula_detail_rec.line_type);
295: IF (l_return_val <> 0) THEN
296: FND_MESSAGE.SET_NAME('GMD','FM_DUPLICATE_LINE_NO');
297: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_formula_detail_rec.item_no);
298: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_detail_rec.formula_no);
299: FND_MESSAGE.SET_TOKEN('FORMULA_VERS',p_formula_detail_rec.formula_vers );
300: FND_MSG_PUB.Add;
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;

Line 299: FND_MESSAGE.SET_TOKEN('FORMULA_VERS',p_formula_detail_rec.formula_vers );

295: IF (l_return_val <> 0) THEN
296: FND_MESSAGE.SET_NAME('GMD','FM_DUPLICATE_LINE_NO');
297: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_formula_detail_rec.item_no);
298: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_detail_rec.formula_no);
299: FND_MESSAGE.SET_TOKEN('FORMULA_VERS',p_formula_detail_rec.formula_vers );
300: FND_MSG_PUB.Add;
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303:

Line 322: FND_MESSAGE.SET_NAME('GMD','FM_INVALID_FMLINE_ID');

318: IF (p_formula_detail_rec.formulaline_id IS NULL) THEN
319: l_surrogate := GMDSURG.get_surrogate('formulaline_id');
320: /* Call for private API */
321: IF (l_surrogate < 1) THEN
322: FND_MESSAGE.SET_NAME('GMD','FM_INVALID_FMLINE_ID');
323: FND_MSG_PUB.Add;
324: RAISE FND_API.G_EXC_ERROR;
325: END IF;
326: ELSE

Line 359: FND_MESSAGE.SET_NAME('GMD', 'GMD_ENTER_PERCENTAGE_YES');

355: IF l_auto_calc = 'Y' THEN
356: IF l_formula_calc_flag = 'Y' AND p_formula_detail_rec.line_type = 1
357: AND p_formula_detail_rec.scale_type_dtl =1 AND p_formula_detail_rec.prod_percent IS NULL THEN
358: /* Error to be raised for Proportional Products when Percentages are not passed */
359: FND_MESSAGE.SET_NAME('GMD', 'GMD_ENTER_PERCENTAGE_YES');
360: FND_MSG_PUB.Add;
361: RAISE FND_API.G_EXC_ERROR;
362: ELSIF l_formula_calc_flag = 'Y' AND (p_formula_detail_rec.prod_percent IS NOT NULL )
363: AND ( p_formula_detail_rec.line_type IN (-1,2) OR

Line 367: FND_MESSAGE.SET_NAME('GMD', 'GMD_ENTER_PERCENTAGE_CANNOT');

363: AND ( p_formula_detail_rec.line_type IN (-1,2) OR
364: ( p_formula_detail_rec.line_type = 1 AND p_formula_detail_rec.scale_type_dtl = 0 ) ) THEN
365: /* Error to be raised when Percentages are passed for Ingredients/By-Products or Fixed
366: Products */
367: FND_MESSAGE.SET_NAME('GMD', 'GMD_ENTER_PERCENTAGE_CANNOT');
368: FND_MSG_PUB.Add;
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;
371: END IF;

Line 377: FND_MESSAGE.SET_NAME('GMD', 'GMD_ENTER_PERCENTAGE_NO');

373: IF ( ( l_auto_calc IS NULL OR l_auto_calc = 'N') OR (l_formula_calc_flag IS NULL OR l_formula_calc_flag = 'N' ))
374: AND p_formula_detail_rec.prod_percent IS NOT NULL THEN
375: /* Error to be raised when Percentages are passed when Parameter is not Set tp
376: Calculate Product qty */
377: FND_MESSAGE.SET_NAME('GMD', 'GMD_ENTER_PERCENTAGE_NO');
378: FND_MSG_PUB.Add;
379: RAISE FND_API.G_EXC_ERROR;
380: END IF;
381: -- Kapil ME Auto-Prod :Bug#5716318

Line 738: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');

734: p_formula_detail_rec.formula_vers,
735: l_formula_id, l_return_val);
736: IF (l_return_val <> 0) THEN
737: IF (p_formula_detail_rec.formula_no IS NULL) THEN
738: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
739: FND_MSG_PUB.Add;
740: RAISE FND_API.G_EXC_ERROR;
741: ELSIF (p_formula_detail_rec.formula_vers IS NULL) THEN
742: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');

Line 742: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');

738: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
739: FND_MSG_PUB.Add;
740: RAISE FND_API.G_EXC_ERROR;
741: ELSIF (p_formula_detail_rec.formula_vers IS NULL) THEN
742: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
743: FND_MSG_PUB.Add;
744: RAISE FND_API.G_EXC_ERROR;
745: ELSE
746: FND_MESSAGE.SET_NAME('GMD', 'FM_INVFORMULANO');

Line 746: FND_MESSAGE.SET_NAME('GMD', 'FM_INVFORMULANO');

742: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
743: FND_MSG_PUB.Add;
744: RAISE FND_API.G_EXC_ERROR;
745: ELSE
746: FND_MESSAGE.SET_NAME('GMD', 'FM_INVFORMULANO');
747: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_detail_rec.formula_no);
748: FND_MSG_PUB.Add;
749: RAISE FND_API.G_EXC_ERROR;
750: END IF;

Line 747: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_detail_rec.formula_no);

743: FND_MSG_PUB.Add;
744: RAISE FND_API.G_EXC_ERROR;
745: ELSE
746: FND_MESSAGE.SET_NAME('GMD', 'FM_INVFORMULANO');
747: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_detail_rec.formula_no);
748: FND_MSG_PUB.Add;
749: RAISE FND_API.G_EXC_ERROR;
750: END IF;
751: END IF;

Line 762: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');

758: On-Hold or Obsolete or Frozen or Requested for Approval -
759: the change of this formula is prevented */
760: /* Check if update is allowed */
761: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
762: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
763: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
764: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
765: FND_MESSAGE.SET_TOKEN('NO', p_formula_detail_rec.formula_no);
766: FND_MESSAGE.SET_TOKEN('VERS', p_formula_detail_rec.formula_vers);

Line 763: FND_MESSAGE.SET_TOKEN('NAME', 'formula');

759: the change of this formula is prevented */
760: /* Check if update is allowed */
761: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
762: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
763: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
764: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
765: FND_MESSAGE.SET_TOKEN('NO', p_formula_detail_rec.formula_no);
766: FND_MESSAGE.SET_TOKEN('VERS', p_formula_detail_rec.formula_vers);
767: FND_MESSAGE.SET_TOKEN('STATUS',

Line 764: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);

760: /* Check if update is allowed */
761: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
762: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
763: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
764: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
765: FND_MESSAGE.SET_TOKEN('NO', p_formula_detail_rec.formula_no);
766: FND_MESSAGE.SET_TOKEN('VERS', p_formula_detail_rec.formula_vers);
767: FND_MESSAGE.SET_TOKEN('STATUS',
768: GMD_FORMULA_DETAIL_PUB.get_fm_status_meaning(l_formula_id));

Line 765: FND_MESSAGE.SET_TOKEN('NO', p_formula_detail_rec.formula_no);

761: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
762: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
763: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
764: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
765: FND_MESSAGE.SET_TOKEN('NO', p_formula_detail_rec.formula_no);
766: FND_MESSAGE.SET_TOKEN('VERS', p_formula_detail_rec.formula_vers);
767: FND_MESSAGE.SET_TOKEN('STATUS',
768: GMD_FORMULA_DETAIL_PUB.get_fm_status_meaning(l_formula_id));
769: FND_MSG_PUB.Add;

Line 766: FND_MESSAGE.SET_TOKEN('VERS', p_formula_detail_rec.formula_vers);

762: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
763: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
764: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
765: FND_MESSAGE.SET_TOKEN('NO', p_formula_detail_rec.formula_no);
766: FND_MESSAGE.SET_TOKEN('VERS', p_formula_detail_rec.formula_vers);
767: FND_MESSAGE.SET_TOKEN('STATUS',
768: GMD_FORMULA_DETAIL_PUB.get_fm_status_meaning(l_formula_id));
769: FND_MSG_PUB.Add;
770: RAISE FND_API.G_EXC_ERROR;

Line 767: FND_MESSAGE.SET_TOKEN('STATUS',

763: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
764: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
765: FND_MESSAGE.SET_TOKEN('NO', p_formula_detail_rec.formula_no);
766: FND_MESSAGE.SET_TOKEN('VERS', p_formula_detail_rec.formula_vers);
767: FND_MESSAGE.SET_TOKEN('STATUS',
768: GMD_FORMULA_DETAIL_PUB.get_fm_status_meaning(l_formula_id));
769: FND_MSG_PUB.Add;
770: RAISE FND_API.G_EXC_ERROR;
771: END IF;

Line 781: FND_MESSAGE.SET_NAME('GMD', 'GMD_USER_CONTEXT_NOT_SET');

777: END IF;
778: -- Bug 4603060 User the user_id from context
779: l_user_id := FND_GLOBAL.user_id;
780: IF (l_user_id IS NULL) THEN
781: FND_MESSAGE.SET_NAME('GMD', 'GMD_USER_CONTEXT_NOT_SET');
782: FND_MSG_PUB.Add;
783: RAISE FND_API.G_EXC_ERROR;
784: END IF;
785:

Line 797: FND_MESSAGE.SET_NAME('GMD','FM_INVALID_FMLINE_ID');

793: END IF;
794: IF (p_formula_detail_rec.formulaline_id IS NOT NULL) THEN /* if invalid formula no */
795: GMDFMVAL_PUB.get_formulaline_id(p_formula_detail_rec.formulaline_id,l_return_val);
796: IF (l_return_val <> 0) THEN
797: FND_MESSAGE.SET_NAME('GMD','FM_INVALID_FMLINE_ID');
798: FND_MSG_PUB.Add;
799: RAISE FND_API.G_EXC_ERROR;
800: END IF;
801: ELSIF (p_formula_detail_rec.formulaline_id IS NULL) THEN /* missing formula no */

Line 802: FND_MESSAGE.SET_NAME('GMD','FM_MISSING_FMLINE_ID');

798: FND_MSG_PUB.Add;
799: RAISE FND_API.G_EXC_ERROR;
800: END IF;
801: ELSIF (p_formula_detail_rec.formulaline_id IS NULL) THEN /* missing formula no */
802: FND_MESSAGE.SET_NAME('GMD','FM_MISSING_FMLINE_ID');
803: FND_MSG_PUB.Add;
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;
806:

Line 809: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_COL_UPDATES');

805: END IF;
806:
807: -- Bug# 5554631 KMOTUPAL - TO prevent Update of Item Revision
808: IF (p_formula_detail_rec.revision IS NOT NULL) THEN
809: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_COL_UPDATES');
810: FND_MESSAGE.SET_TOKEN('NAME','REVISION');
811: FND_MSG_PUB.Add;
812: END IF;
813:

Line 810: FND_MESSAGE.SET_TOKEN('NAME','REVISION');

806:
807: -- Bug# 5554631 KMOTUPAL - TO prevent Update of Item Revision
808: IF (p_formula_detail_rec.revision IS NOT NULL) THEN
809: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_COL_UPDATES');
810: FND_MESSAGE.SET_TOKEN('NAME','REVISION');
811: FND_MSG_PUB.Add;
812: END IF;
813:
814: OPEN C_get_orgid (l_formula_id);

Line 935: FND_MESSAGE.SET_NAME('GMD', 'GMD_ENTER_PERCENTAGES_NOT');

931: OR (fmline_not_null.line_type IN (-1,2) OR
932: (p_formula_detail_rec.line_type = 1 And p_formula_detail_rec.scale_type_dtl = 0 ) ) THEN
933: /* Error to be raised if Percentages are passed for Ingredients/By-Products or when
934: when the Parameter is not set to calculate Product Qty */
935: FND_MESSAGE.SET_NAME('GMD', 'GMD_ENTER_PERCENTAGES_NOT');
936: FND_MSG_PUB.Add;
937: RAISE FND_API.G_EXC_ERROR;
938: END IF;
939: END IF;

Line 1648: FND_MESSAGE.SET_NAME('GMD', 'GMD_USER_CONTEXT_NOT_SET');

1644: /* Check if there is a valid userid */
1645: -- Bug 4603060
1646: l_user_id := FND_GLOBAL.user_id;
1647: IF (l_user_id IS NULL) THEN
1648: FND_MESSAGE.SET_NAME('GMD', 'GMD_USER_CONTEXT_NOT_SET');
1649: FND_MSG_PUB.Add;
1650: RAISE FND_API.G_EXC_ERROR;
1651: END IF;
1652:

Line 1658: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_ACTION');

1654: /* Check if an appropriate action_code */
1655: /* has been supplied */
1656: /* ================================== */
1657: IF (p_formula_detail_rec.record_type <> 'D')THEN
1658: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_ACTION');
1659: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_detail_rec.formula_no);
1660: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_detail_rec.formula_vers);
1661: FND_MSG_PUB.Add;
1662: RAISE FND_API.G_EXC_ERROR;

Line 1659: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_detail_rec.formula_no);

1655: /* has been supplied */
1656: /* ================================== */
1657: IF (p_formula_detail_rec.record_type <> 'D')THEN
1658: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_ACTION');
1659: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_detail_rec.formula_no);
1660: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_detail_rec.formula_vers);
1661: FND_MSG_PUB.Add;
1662: RAISE FND_API.G_EXC_ERROR;
1663: END IF;

Line 1660: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_detail_rec.formula_vers);

1656: /* ================================== */
1657: IF (p_formula_detail_rec.record_type <> 'D')THEN
1658: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_ACTION');
1659: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_detail_rec.formula_no);
1660: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_detail_rec.formula_vers);
1661: FND_MSG_PUB.Add;
1662: RAISE FND_API.G_EXC_ERROR;
1663: END IF;
1664:

Line 1674: FND_MESSAGE.SET_NAME('GMD','FM_MISSING_FMLINE_ID');

1670: IF (p_formula_detail_rec.formulaline_id IS NOT NULL) THEN /* if invalid formulaline no */
1671:
1672: GMDFMVAL_PUB.get_formulaline_id(p_formula_detail_rec.formulaline_id,l_return_val);
1673: IF (l_return_val <> 0) THEN
1674: FND_MESSAGE.SET_NAME('GMD','FM_MISSING_FMLINE_ID');
1675: FND_MSG_PUB.Add;
1676: RAISE FND_API.G_EXC_ERROR;
1677: END IF;
1678: ELSIF (p_formula_detail_rec.formulaline_id IS NULL) THEN

Line 1679: FND_MESSAGE.SET_NAME('GMD','FM_MISSING_FMLINE_ID');

1675: FND_MSG_PUB.Add;
1676: RAISE FND_API.G_EXC_ERROR;
1677: END IF;
1678: ELSIF (p_formula_detail_rec.formulaline_id IS NULL) THEN
1679: FND_MESSAGE.SET_NAME('GMD','FM_MISSING_FMLINE_ID');
1680: FND_MSG_PUB.Add;
1681: RAISE FND_API.G_EXC_ERROR;
1682: END IF;
1683:

Line 1696: FND_MESSAGE.SET_NAME('GMD', 'FM_INVFORMULANO');

1692: IF (p_formula_detail_rec.formula_id is NULL) THEN
1693: OPEN get_formula_id(p_formula_detail_rec.formulaline_id);
1694: FETCH get_formula_id INTO l_formula_id;
1695: IF (get_formula_id%NOTFOUND) THEN
1696: FND_MESSAGE.SET_NAME('GMD', 'FM_INVFORMULANO');
1697: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_detail_rec.formula_no);
1698: FND_MSG_PUB.Add;
1699: CLOSE get_formula_id;
1700: RAISE FND_API.G_EXC_ERROR;

Line 1697: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_detail_rec.formula_no);

1693: OPEN get_formula_id(p_formula_detail_rec.formulaline_id);
1694: FETCH get_formula_id INTO l_formula_id;
1695: IF (get_formula_id%NOTFOUND) THEN
1696: FND_MESSAGE.SET_NAME('GMD', 'FM_INVFORMULANO');
1697: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_detail_rec.formula_no);
1698: FND_MSG_PUB.Add;
1699: CLOSE get_formula_id;
1700: RAISE FND_API.G_EXC_ERROR;
1701: END IF;

Line 1708: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');

1704: l_formula_id := p_formula_detail_rec.formula_id;
1705: END IF;
1706:
1707: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
1708: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1709: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1710: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1711: FND_MESSAGE.SET_TOKEN('NO', p_formula_detail_rec.formula_no);
1712: FND_MESSAGE.SET_TOKEN('VERS', p_formula_detail_rec.formula_vers);

Line 1709: FND_MESSAGE.SET_TOKEN('NAME', 'formula');

1705: END IF;
1706:
1707: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
1708: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1709: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1710: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1711: FND_MESSAGE.SET_TOKEN('NO', p_formula_detail_rec.formula_no);
1712: FND_MESSAGE.SET_TOKEN('VERS', p_formula_detail_rec.formula_vers);
1713: FND_MESSAGE.SET_TOKEN('STATUS',

Line 1710: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);

1706:
1707: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
1708: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1709: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1710: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1711: FND_MESSAGE.SET_TOKEN('NO', p_formula_detail_rec.formula_no);
1712: FND_MESSAGE.SET_TOKEN('VERS', p_formula_detail_rec.formula_vers);
1713: FND_MESSAGE.SET_TOKEN('STATUS',
1714: GMD_FORMULA_DETAIL_PUB.get_fm_status_meaning(l_formula_id));

Line 1711: FND_MESSAGE.SET_TOKEN('NO', p_formula_detail_rec.formula_no);

1707: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
1708: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1709: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1710: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1711: FND_MESSAGE.SET_TOKEN('NO', p_formula_detail_rec.formula_no);
1712: FND_MESSAGE.SET_TOKEN('VERS', p_formula_detail_rec.formula_vers);
1713: FND_MESSAGE.SET_TOKEN('STATUS',
1714: GMD_FORMULA_DETAIL_PUB.get_fm_status_meaning(l_formula_id));
1715: FND_MSG_PUB.Add;

Line 1712: FND_MESSAGE.SET_TOKEN('VERS', p_formula_detail_rec.formula_vers);

1708: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1709: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1710: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1711: FND_MESSAGE.SET_TOKEN('NO', p_formula_detail_rec.formula_no);
1712: FND_MESSAGE.SET_TOKEN('VERS', p_formula_detail_rec.formula_vers);
1713: FND_MESSAGE.SET_TOKEN('STATUS',
1714: GMD_FORMULA_DETAIL_PUB.get_fm_status_meaning(l_formula_id));
1715: FND_MSG_PUB.Add;
1716: RAISE FND_API.G_EXC_ERROR;

Line 1713: FND_MESSAGE.SET_TOKEN('STATUS',

1709: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1710: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1711: FND_MESSAGE.SET_TOKEN('NO', p_formula_detail_rec.formula_no);
1712: FND_MESSAGE.SET_TOKEN('VERS', p_formula_detail_rec.formula_vers);
1713: FND_MESSAGE.SET_TOKEN('STATUS',
1714: GMD_FORMULA_DETAIL_PUB.get_fm_status_meaning(l_formula_id));
1715: FND_MSG_PUB.Add;
1716: RAISE FND_API.G_EXC_ERROR;
1717: END IF;

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

1725: FETCH check_num_details INTO l_count;
1726: /* If there s only 1 ingredient or product, stop the delete */
1727: IF (l_count < 2) THEN
1728: IF p_formula_detail_rec.line_type = 1 THEN
1729: FND_MESSAGE.SET_NAME('GMD', 'GMD_MUST_HAVE_PRODUCT');
1730: ELSE
1731: FND_MESSAGE.SET_NAME('GMD', 'GMD_MUST_HAVE_INGREDIENT');
1732: END IF;
1733: FND_MSG_PUB.Add;

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

1727: IF (l_count < 2) THEN
1728: IF p_formula_detail_rec.line_type = 1 THEN
1729: FND_MESSAGE.SET_NAME('GMD', 'GMD_MUST_HAVE_PRODUCT');
1730: ELSE
1731: FND_MESSAGE.SET_NAME('GMD', 'GMD_MUST_HAVE_INGREDIENT');
1732: END IF;
1733: FND_MSG_PUB.Add;
1734: RAISE FND_API.G_EXC_ERROR;
1735: END IF;

Line 1747: FND_MESSAGE.SET_NAME('GMD', 'GMD_VALID_VALIDITY');

1743: p_formula_detail_rec.line_type);
1744: FETCH check_validity_rules INTO l_count;
1745: /* If there are valid validity rules, stop the delete */
1746: IF (check_validity_rules%FOUND) THEN
1747: FND_MESSAGE.SET_NAME('GMD', 'GMD_VALID_VALIDITY');
1748: FND_MSG_PUB.Add;
1749: RAISE FND_API.G_EXC_ERROR;
1750: END IF;
1751: CLOSE check_validity_rules;