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

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

238: /* Check if there is a valid userid/ownerid */
239: /* ======================================== */
240: /* Bug 4603060 check if the user context is set */
241: IF (l_user_id IS NULL) THEN
242: FND_MESSAGE.SET_NAME('GMD', 'GMD_USER_CONTEXT_NOT_SET');
243: FND_MSG_PUB.Add;
244: RAISE FND_API.G_EXC_ERROR;
245: END IF;
246:

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

262: p_formula_header_rec.formula_vers,
263: l_formula_id, l_return_val);
264: IF (l_return_val <> 0) THEN
265: IF (p_formula_header_rec.formula_no IS NULL) THEN
266: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
267: FND_MSG_PUB.Add;
268: RAISE FND_API.G_EXC_ERROR;
269: ELSE
270: l_formula_no := p_formula_header_rec.formula_no;

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

270: l_formula_no := p_formula_header_rec.formula_no;
271: END IF;
272:
273: IF (p_formula_header_rec.formula_vers IS NULL) THEN
274: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
275: FND_MSG_PUB.Add;
276: RAISE FND_API.G_EXC_ERROR;
277: ELSE
278: l_formula_vers := p_formula_header_rec.formula_vers;

Line 290: FND_MESSAGE.SET_NAME('GMD', 'FM_ALREADYEXISTS');

286:
287: --BEGIN BUG#2930523 V. Ajay Kumar
288: --Added code such that a message is displayed if the user tries to
289: --create an exisiting formula/version thru API.
290: FND_MESSAGE.SET_NAME('GMD', 'FM_ALREADYEXISTS');
291: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
292: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
293: FND_MSG_PUB.Add;
294: --END BUG#2930523

Line 291: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

287: --BEGIN BUG#2930523 V. Ajay Kumar
288: --Added code such that a message is displayed if the user tries to
289: --create an exisiting formula/version thru API.
290: FND_MESSAGE.SET_NAME('GMD', 'FM_ALREADYEXISTS');
291: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
292: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
293: FND_MSG_PUB.Add;
294: --END BUG#2930523
295:

Line 292: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);

288: --Added code such that a message is displayed if the user tries to
289: --create an exisiting formula/version thru API.
290: FND_MESSAGE.SET_NAME('GMD', 'FM_ALREADYEXISTS');
291: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
292: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
293: FND_MSG_PUB.Add;
294: --END BUG#2930523
295:
296: END IF;

Line 361: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');

357: END IF;
358: END LOOP; -- for j IN ..
359:
360: IF (l_line_type_counter > 0) THEN
361: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');
362: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
363: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
364: -- Bug #3119000 (JKB) Changed values returned above to l_.
365: FND_MSG_PUB.Add;

Line 362: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);

358: END LOOP; -- for j IN ..
359:
360: IF (l_line_type_counter > 0) THEN
361: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');
362: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
363: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
364: -- Bug #3119000 (JKB) Changed values returned above to l_.
365: FND_MSG_PUB.Add;
366: RAISE FND_API.G_EXC_ERROR;

Line 363: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);

359:
360: IF (l_line_type_counter > 0) THEN
361: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');
362: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
363: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
364: -- Bug #3119000 (JKB) Changed values returned above to l_.
365: FND_MSG_PUB.Add;
366: RAISE FND_API.G_EXC_ERROR;
367: END IF;

Line 402: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');

398: END IF;
399: END LOOP;
400:
401: IF (l_line_type_counter > 0) THEN
402: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');
403: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
404: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
405: -- Bug #3119000 (JKB) Changed values returned above to l_.
406: FND_MSG_PUB.Add;

Line 403: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);

399: END LOOP;
400:
401: IF (l_line_type_counter > 0) THEN
402: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');
403: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
404: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
405: -- Bug #3119000 (JKB) Changed values returned above to l_.
406: FND_MSG_PUB.Add;
407: RAISE FND_API.G_EXC_ERROR;

Line 404: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);

400:
401: IF (l_line_type_counter > 0) THEN
402: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');
403: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
404: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
405: -- Bug #3119000 (JKB) Changed values returned above to l_.
406: FND_MSG_PUB.Add;
407: RAISE FND_API.G_EXC_ERROR;
408: END IF;

Line 431: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_ORGANIZATION_ID');

427: END IF;
428:
429: --Check that organization id is not null if raise an error message
430: IF (p_formula_header_rec.owner_organization_id IS NULL) THEN
431: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_ORGANIZATION_ID');
432: FND_MSG_PUB.Add;
433: RAISE FND_API.G_EXC_ERROR;
434: ELSE
435: --Check the organization id passed is process enabled if not raise an error message

Line 437: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');

433: RAISE FND_API.G_EXC_ERROR;
434: ELSE
435: --Check the organization id passed is process enabled if not raise an error message
436: IF NOT (gmd_api_grp.check_orgn_status(p_formula_header_rec.owner_organization_id)) THEN
437: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
438: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_formula_header_rec.owner_organization_id);
439: FND_MSG_PUB.Add;
440: RAISE FND_API.G_EXC_ERROR;
441: END IF;

Line 438: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_formula_header_rec.owner_organization_id);

434: ELSE
435: --Check the organization id passed is process enabled if not raise an error message
436: IF NOT (gmd_api_grp.check_orgn_status(p_formula_header_rec.owner_organization_id)) THEN
437: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
438: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_formula_header_rec.owner_organization_id);
439: FND_MSG_PUB.Add;
440: RAISE FND_API.G_EXC_ERROR;
441: END IF;
442: -- Kapil ME Auto-Prod :Bug# 5716318

Line 450: FND_MESSAGE.SET_NAME('GMD', 'GMD_AUTO_PRODUCT_OFF');

446: P_parm_value => l_auto_calc,
447: X_return_status => X_return_status );
448: IF (l_auto_calc IS NULL OR l_auto_calc = 'N') AND p_formula_header_rec.AUTO_PRODUCT_CALC = 'Y' THEN
449: /* Error raised when passing Formula Parameter as Yes when organziation parmater is NO */
450: FND_MESSAGE.SET_NAME('GMD', 'GMD_AUTO_PRODUCT_OFF');
451: FND_MSG_PUB.Add;
452: RAISE FND_API.G_EXC_ERROR;
453: END IF;
454: /* Error to be raised when Setting Scaling Allowed to No */

Line 457: FND_MESSAGE.SET_NAME('GMD', 'GMD_SCALE_AUTO_NO');

453: END IF;
454: /* Error to be raised when Setting Scaling Allowed to No */
455: IF p_formula_header_rec.auto_product_calc = 'Y'
456: AND p_formula_header_rec.scale_type_hdr = 0 THEN
457: FND_MESSAGE.SET_NAME('GMD', 'GMD_SCALE_AUTO_NO');
458: FND_MSG_PUB.Add;
459: RAISE FND_API.G_EXC_ERROR;
460: END IF;
461: END IF;

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

478: p_data => x_msg_data );
479: END;
480:
481: IF v_recipe_enabled <> 'Y' THEN
482: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_NOT_RECIPE_ENABLED');
483: FND_MESSAGE.SET_TOKEN('ITEM_NO', v_item_no);
484: FND_MSG_PUB.Add;
485: RAISE FND_API.G_EXC_ERROR;
486: END IF ;

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

479: END;
480:
481: IF v_recipe_enabled <> 'Y' THEN
482: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_NOT_RECIPE_ENABLED');
483: FND_MESSAGE.SET_TOKEN('ITEM_NO', v_item_no);
484: FND_MSG_PUB.Add;
485: RAISE FND_API.G_EXC_ERROR;
486: END IF ;
487: END LOOP;

Line 511: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_DESC');

507: ||' - '
508: ||x_return_status);
509: END IF;
510: IF (p_formula_header_rec.formula_desc1 IS NULL) THEN
511: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_DESC');
512: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
513: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
514: FND_MSG_PUB.Add;
515: RAISE FND_API.G_EXC_ERROR;

Line 512: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

508: ||x_return_status);
509: END IF;
510: IF (p_formula_header_rec.formula_desc1 IS NULL) THEN
511: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_DESC');
512: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
513: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
514: FND_MSG_PUB.Add;
515: RAISE FND_API.G_EXC_ERROR;
516: END IF;

Line 513: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);

509: END IF;
510: IF (p_formula_header_rec.formula_desc1 IS NULL) THEN
511: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_DESC');
512: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
513: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
514: FND_MSG_PUB.Add;
515: RAISE FND_API.G_EXC_ERROR;
516: END IF;
517:

Line 530: FND_MESSAGE.SET_NAME('GMD', 'FM_WRONG_TYPE');

526: ||x_return_status);
527: END IF;
528: IF (p_formula_header_rec.formula_type <> 0) AND
529: (p_formula_header_rec.formula_type <> 1) THEN
530: FND_MESSAGE.SET_NAME('GMD', 'FM_WRONG_TYPE');
531: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
532: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
533: FND_MSG_PUB.Add;
534: RAISE FND_API.G_EXC_ERROR;

Line 531: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

527: END IF;
528: IF (p_formula_header_rec.formula_type <> 0) AND
529: (p_formula_header_rec.formula_type <> 1) THEN
530: FND_MESSAGE.SET_NAME('GMD', 'FM_WRONG_TYPE');
531: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
532: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
533: FND_MSG_PUB.Add;
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;

Line 532: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);

528: IF (p_formula_header_rec.formula_type <> 0) AND
529: (p_formula_header_rec.formula_type <> 1) THEN
530: FND_MESSAGE.SET_NAME('GMD', 'FM_WRONG_TYPE');
531: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
532: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
533: FND_MSG_PUB.Add;
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
536:

Line 548: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_SCALE_TYPE');

544: ||' - '
545: ||x_return_status);
546: END IF;
547: IF (p_formula_header_rec.scale_type_hdr IS NULL) THEN
548: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_SCALE_TYPE');
549: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
550: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
551: FND_MSG_PUB.Add;
552: RAISE FND_API.G_EXC_ERROR;

Line 549: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

545: ||x_return_status);
546: END IF;
547: IF (p_formula_header_rec.scale_type_hdr IS NULL) THEN
548: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_SCALE_TYPE');
549: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
550: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
551: FND_MSG_PUB.Add;
552: RAISE FND_API.G_EXC_ERROR;
553: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN

Line 550: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);

546: END IF;
547: IF (p_formula_header_rec.scale_type_hdr IS NULL) THEN
548: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_SCALE_TYPE');
549: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
550: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
551: FND_MSG_PUB.Add;
552: RAISE FND_API.G_EXC_ERROR;
553: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN
554: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');

Line 554: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');

550: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
551: FND_MSG_PUB.Add;
552: RAISE FND_API.G_EXC_ERROR;
553: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN
554: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');
555: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
556: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
557: FND_MSG_PUB.Add;
558: RAISE FND_API.G_EXC_ERROR;

Line 555: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

551: FND_MSG_PUB.Add;
552: RAISE FND_API.G_EXC_ERROR;
553: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN
554: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');
555: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
556: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
557: FND_MSG_PUB.Add;
558: RAISE FND_API.G_EXC_ERROR;
559: END IF;

Line 556: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);

552: RAISE FND_API.G_EXC_ERROR;
553: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN
554: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');
555: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
556: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
557: FND_MSG_PUB.Add;
558: RAISE FND_API.G_EXC_ERROR;
559: END IF;
560:

Line 574: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');

570: END IF;
571: IF (p_formula_header_rec.formula_class IS NOT NULL) THEN
572: l_return_val := GMDFMVAL_PUB.formula_class_val(p_formula_header_rec.formula_class);
573: IF (l_return_val <> 0) THEN
574: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
575: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
576: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
577: FND_MSG_PUB.Add;
578: RAISE FND_API.G_EXC_ERROR;

Line 575: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

571: IF (p_formula_header_rec.formula_class IS NOT NULL) THEN
572: l_return_val := GMDFMVAL_PUB.formula_class_val(p_formula_header_rec.formula_class);
573: IF (l_return_val <> 0) THEN
574: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
575: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
576: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
577: FND_MSG_PUB.Add;
578: RAISE FND_API.G_EXC_ERROR;
579: END IF;

Line 576: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);

572: l_return_val := GMDFMVAL_PUB.formula_class_val(p_formula_header_rec.formula_class);
573: IF (l_return_val <> 0) THEN
574: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
575: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
576: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
577: FND_MSG_PUB.Add;
578: RAISE FND_API.G_EXC_ERROR;
579: END IF;
580: END IF;

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

592: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
593: IF (p_formula_header_rec.formula_id IS NULL) THEN
594: l_return_val := GMDSURG.get_surrogate('formula_id');
595: IF (l_return_val < 1) THEN
596: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_FORMULA_ID');
597: FND_MSG_PUB.Add;
598: RAISE FND_API.G_EXC_ERROR;
599: ELSE
600: l_surrogate := l_return_val;

Line 741: FND_MESSAGE.SET_NAME('GMD','GMD_ZERO_INGREDIENT_QTY');

737: /* BEGIN BUG#2868184 Based on the ingredient quantity and parameter value */
738: /* Formula/Formula's are either rolled back or inserted with warning */
739:
740: IF l_flag = 'F' AND l_formula_detail_tbl(1).line_type = -1 AND l_formula_detail_tbl(1).qty = 0 THEN
741: FND_MESSAGE.SET_NAME('GMD','GMD_ZERO_INGREDIENT_QTY');
742: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
743: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
744: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_formula_detail_tbl(1).item_no );
745: FND_MSG_PUB.Add;

Line 742: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);

738: /* Formula/Formula's are either rolled back or inserted with warning */
739:
740: IF l_flag = 'F' AND l_formula_detail_tbl(1).line_type = -1 AND l_formula_detail_tbl(1).qty = 0 THEN
741: FND_MESSAGE.SET_NAME('GMD','GMD_ZERO_INGREDIENT_QTY');
742: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
743: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
744: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_formula_detail_tbl(1).item_no );
745: FND_MSG_PUB.Add;
746: RAISE FND_API.G_EXC_ERROR;

Line 743: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);

739:
740: IF l_flag = 'F' AND l_formula_detail_tbl(1).line_type = -1 AND l_formula_detail_tbl(1).qty = 0 THEN
741: FND_MESSAGE.SET_NAME('GMD','GMD_ZERO_INGREDIENT_QTY');
742: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
743: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
744: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_formula_detail_tbl(1).item_no );
745: FND_MSG_PUB.Add;
746: RAISE FND_API.G_EXC_ERROR;
747: ELSIF l_flag = 'W' AND l_formula_detail_tbl(1).line_type = -1 AND l_formula_detail_tbl(1).qty = 0 THEN

Line 744: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_formula_detail_tbl(1).item_no );

740: IF l_flag = 'F' AND l_formula_detail_tbl(1).line_type = -1 AND l_formula_detail_tbl(1).qty = 0 THEN
741: FND_MESSAGE.SET_NAME('GMD','GMD_ZERO_INGREDIENT_QTY');
742: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
743: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
744: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_formula_detail_tbl(1).item_no );
745: FND_MSG_PUB.Add;
746: RAISE FND_API.G_EXC_ERROR;
747: ELSIF l_flag = 'W' AND l_formula_detail_tbl(1).line_type = -1 AND l_formula_detail_tbl(1).qty = 0 THEN
748: FND_MESSAGE.SET_NAME('GMD','GMD_ALLOW_ZERO_QTY');

Line 748: FND_MESSAGE.SET_NAME('GMD','GMD_ALLOW_ZERO_QTY');

744: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_formula_detail_tbl(1).item_no );
745: FND_MSG_PUB.Add;
746: RAISE FND_API.G_EXC_ERROR;
747: ELSIF l_flag = 'W' AND l_formula_detail_tbl(1).line_type = -1 AND l_formula_detail_tbl(1).qty = 0 THEN
748: FND_MESSAGE.SET_NAME('GMD','GMD_ALLOW_ZERO_QTY');
749: FND_MSG_PUB.Add;
750: END IF;
751: /* END BUG#2868184 */
752:

Line 813: FND_MESSAGE.SET_NAME('GMD','GMD_EXPR_ITEMS_FOUND');

809: X_entity_status => l_entity_status);
810: -- Check for any experimental items when formula status is apfgu.
811: IF (l_entity_status.status_type = 700) THEN
812: IF (gmdfmval_pub.check_expr_items(l_tbl_formula_id(i).formula_id)) THEN
813: FND_MESSAGE.SET_NAME('GMD','GMD_EXPR_ITEMS_FOUND');
814: FND_MSG_PUB.ADD;
815: RAISE FND_API.G_EXC_ERROR;
816: END IF; -- IF (gmdfmval_pub.check_expr_items(p_formula_header_rec.formula_id) THEN
817: END IF; -- IF (X_status_type = 700) THEN

Line 822: FND_MESSAGE.SET_NAME('GMI','IC_ITEM_INACTIVE');

818:
819: --Check any inactive items in formula before changing the status
820: IF (l_entity_status.status_type IN (400,700)) THEN
821: IF (gmdfmval_pub.inactive_items(l_tbl_formula_id(i).formula_id)) THEN
822: FND_MESSAGE.SET_NAME('GMI','IC_ITEM_INACTIVE');
823: FND_MSG_PUB.ADD;
824: RAISE FND_API.G_EXC_ERROR;
825: END IF; -- IF (gmdfmval_pub.inactive_items(V_formula_id) THEN
826: END IF; --l_entity_status.status_type IN (400,700)

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

1046: gmd_debug.put_line(' In Formula Header Pub - Before user validation ');
1047: END IF;
1048: -- Bug 4603060
1049: IF (l_user_id IS NULL) THEN
1050: FND_MESSAGE.SET_NAME('GMD', 'GMD_USER_CONTEXT_NOT_SET');
1051: FND_MSG_PUB.Add;
1052: RAISE FND_API.G_EXC_ERROR;
1053: END IF;
1054:

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

1065: p_formula_header_rec.formula_vers,
1066: l_formula_id, l_return_val);
1067: IF (l_return_val <> 0) THEN
1068: IF (p_formula_header_rec.formula_no IS NULL) THEN
1069: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
1070: FND_MSG_PUB.Add;
1071: RAISE FND_API.G_EXC_ERROR;
1072: ELSIF (p_formula_header_rec.formula_vers IS NULL) THEN
1073: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');

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

1069: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
1070: FND_MSG_PUB.Add;
1071: RAISE FND_API.G_EXC_ERROR;
1072: ELSIF (p_formula_header_rec.formula_vers IS NULL) THEN
1073: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
1074: FND_MSG_PUB.Add;
1075: RAISE FND_API.G_EXC_ERROR;
1076: ELSE
1077: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_FORMULA_ID');

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

1073: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
1074: FND_MSG_PUB.Add;
1075: RAISE FND_API.G_EXC_ERROR;
1076: ELSE
1077: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_FORMULA_ID');
1078: FND_MSG_PUB.Add;
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081: END IF;

Line 1170: FND_MESSAGE.SET_NAME('GMD', 'GMD_CANNOT_AUTO_FLAG');

1166: := update_not_null_rec.auto_product_calc;
1167: ELSE
1168: /* Update of the Flag is prevented form the API as the user cannot specify the Percentages. */
1169: IF NVL(UPPER(p_called_from_forms),'NO') <> 'YES' THEN
1170: FND_MESSAGE.SET_NAME('GMD', 'GMD_CANNOT_AUTO_FLAG');
1171: FND_MSG_PUB.Add;
1172: RAISE FND_API.G_EXC_ERROR;
1173: END IF;
1174: END IF;

Line 1181: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');

1177: --Check that organization id is not null if raise an error message
1178: IF (p_formula_header_rec.owner_organization_id IS NOT NULL) THEN
1179: --Check the organization id passed is process enabled if not raise an error message
1180: IF NOT (gmd_api_grp.check_orgn_status(p_formula_header_rec.owner_organization_id)) THEN
1181: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
1182: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_formula_header_rec.owner_organization_id);
1183: FND_MSG_PUB.Add;
1184: RAISE FND_API.G_EXC_ERROR;
1185: END IF;

Line 1182: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_formula_header_rec.owner_organization_id);

1178: IF (p_formula_header_rec.owner_organization_id IS NOT NULL) THEN
1179: --Check the organization id passed is process enabled if not raise an error message
1180: IF NOT (gmd_api_grp.check_orgn_status(p_formula_header_rec.owner_organization_id)) THEN
1181: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
1182: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_formula_header_rec.owner_organization_id);
1183: FND_MSG_PUB.Add;
1184: RAISE FND_API.G_EXC_ERROR;
1185: END IF;
1186: END IF;

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

1188: /* Check if update is allowed */
1189: IF l_lastformula_id <> l_formula_id THEN
1190: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
1191: IF NOT (l_dbdelete_mark = 1 AND p_formula_header_rec.delete_mark = 0) THEN
1192: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1193: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1194: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1195: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1196: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);

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

1189: IF l_lastformula_id <> l_formula_id THEN
1190: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
1191: IF NOT (l_dbdelete_mark = 1 AND p_formula_header_rec.delete_mark = 0) THEN
1192: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1193: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1194: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1195: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1196: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1197: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));

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

1190: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
1191: IF NOT (l_dbdelete_mark = 1 AND p_formula_header_rec.delete_mark = 0) THEN
1192: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1193: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1194: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1195: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1196: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1197: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));
1198: FND_MSG_PUB.Add;

Line 1195: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);

1191: IF NOT (l_dbdelete_mark = 1 AND p_formula_header_rec.delete_mark = 0) THEN
1192: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1193: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1194: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1195: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1196: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1197: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));
1198: FND_MSG_PUB.Add;
1199: RAISE FND_API.G_EXC_ERROR;

Line 1196: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);

1192: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1193: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1194: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1195: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1196: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1197: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));
1198: FND_MSG_PUB.Add;
1199: RAISE FND_API.G_EXC_ERROR;
1200: END IF;

Line 1197: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));

1193: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1194: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1195: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1196: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1197: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));
1198: FND_MSG_PUB.Add;
1199: RAISE FND_API.G_EXC_ERROR;
1200: END IF;
1201: END IF;

Line 1215: FND_MESSAGE.SET_NAME('GMD', 'FM_WRONG_TYPE');

1211: ||x_return_status);
1212: END IF;
1213: IF (p_formula_header_rec.formula_type <> 0) AND
1214: (p_formula_header_rec.formula_type <> 1) THEN
1215: FND_MESSAGE.SET_NAME('GMD', 'FM_WRONG_TYPE');
1216: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1217: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1218: FND_MSG_PUB.Add;
1219: RAISE FND_API.G_EXC_ERROR;

Line 1216: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

1212: END IF;
1213: IF (p_formula_header_rec.formula_type <> 0) AND
1214: (p_formula_header_rec.formula_type <> 1) THEN
1215: FND_MESSAGE.SET_NAME('GMD', 'FM_WRONG_TYPE');
1216: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1217: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1218: FND_MSG_PUB.Add;
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;

Line 1217: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);

1213: IF (p_formula_header_rec.formula_type <> 0) AND
1214: (p_formula_header_rec.formula_type <> 1) THEN
1215: FND_MESSAGE.SET_NAME('GMD', 'FM_WRONG_TYPE');
1216: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1217: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1218: FND_MSG_PUB.Add;
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;
1221:

Line 1232: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_SCALE_TYPE');

1228: ||' - '
1229: ||x_return_status);
1230: END IF;
1231: IF (p_formula_header_rec.scale_type_hdr IS NULL) THEN
1232: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_SCALE_TYPE');
1233: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1234: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1235: FND_MSG_PUB.Add;
1236: RAISE FND_API.G_EXC_ERROR;

Line 1233: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

1229: ||x_return_status);
1230: END IF;
1231: IF (p_formula_header_rec.scale_type_hdr IS NULL) THEN
1232: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_SCALE_TYPE');
1233: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1234: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1235: FND_MSG_PUB.Add;
1236: RAISE FND_API.G_EXC_ERROR;
1237: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN

Line 1234: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);

1230: END IF;
1231: IF (p_formula_header_rec.scale_type_hdr IS NULL) THEN
1232: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_SCALE_TYPE');
1233: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1234: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1235: FND_MSG_PUB.Add;
1236: RAISE FND_API.G_EXC_ERROR;
1237: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN
1238: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');

Line 1238: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');

1234: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1235: FND_MSG_PUB.Add;
1236: RAISE FND_API.G_EXC_ERROR;
1237: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN
1238: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');
1239: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1240: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1241: FND_MSG_PUB.Add;
1242: RAISE FND_API.G_EXC_ERROR;

Line 1239: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

1235: FND_MSG_PUB.Add;
1236: RAISE FND_API.G_EXC_ERROR;
1237: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN
1238: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');
1239: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1240: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1241: FND_MSG_PUB.Add;
1242: RAISE FND_API.G_EXC_ERROR;
1243: -- SCALING KAPIL

Line 1240: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);

1236: RAISE FND_API.G_EXC_ERROR;
1237: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN
1238: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');
1239: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1240: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1241: FND_MSG_PUB.Add;
1242: RAISE FND_API.G_EXC_ERROR;
1243: -- SCALING KAPIL
1244: ELSIF p_formula_header_rec.scale_type_hdr = 0 THEN

Line 1247: FND_MESSAGE.SET_NAME('GMD', 'GMD_SCALE_SET_AUTO_OFF');

1243: -- SCALING KAPIL
1244: ELSIF p_formula_header_rec.scale_type_hdr = 0 THEN
1245: IF p_formula_header_rec.auto_product_calc = 'Y' THEN
1246: p_formula_header_rec.auto_product_calc := 'N';
1247: FND_MESSAGE.SET_NAME('GMD', 'GMD_SCALE_SET_AUTO_OFF');
1248: FND_MSG_PUB.Add;
1249: END IF;
1250: END IF;
1251:

Line 1265: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');

1261: IF (p_formula_header_rec.formula_class IS NOT NULL) THEN
1262: l_return_val := GMDFMVAL_PUB.formula_class_val(
1263: p_formula_header_rec.formula_class);
1264: IF (l_return_val <> 0) THEN
1265: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
1266: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1267: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1268: FND_MSG_PUB.Add;
1269: RAISE FND_API.G_EXC_ERROR;

Line 1266: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

1262: l_return_val := GMDFMVAL_PUB.formula_class_val(
1263: p_formula_header_rec.formula_class);
1264: IF (l_return_val <> 0) THEN
1265: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
1266: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1267: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1268: FND_MSG_PUB.Add;
1269: RAISE FND_API.G_EXC_ERROR;
1270: END IF;

Line 1267: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);

1263: p_formula_header_rec.formula_class);
1264: IF (l_return_val <> 0) THEN
1265: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
1266: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1267: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1268: FND_MSG_PUB.Add;
1269: RAISE FND_API.G_EXC_ERROR;
1270: END IF;
1271: END IF;

Line 1581: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');

1577: IF (l_formula_class IS NOT NULL ) THEN
1578: l_return_val := GMDFMVAL_PUB.formula_class_val(
1579: l_formula_class);
1580: IF (l_return_val <> 0) THEN
1581: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
1582: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1583: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1584: FND_MSG_PUB.Add;
1585: RAISE FND_API.G_EXC_ERROR;

Line 1582: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

1578: l_return_val := GMDFMVAL_PUB.formula_class_val(
1579: l_formula_class);
1580: IF (l_return_val <> 0) THEN
1581: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
1582: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1583: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1584: FND_MSG_PUB.Add;
1585: RAISE FND_API.G_EXC_ERROR;
1586: END IF;

Line 1583: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);

1579: l_formula_class);
1580: IF (l_return_val <> 0) THEN
1581: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
1582: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1583: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1584: FND_MSG_PUB.Add;
1585: RAISE FND_API.G_EXC_ERROR;
1586: END IF;
1587: END IF;

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

1814: /* Check if there is a valid userid/ownerid */
1815: /* ======================================== */
1816: -- Bug 4603060
1817: IF (l_user_id IS NULL) THEN
1818: FND_MESSAGE.SET_NAME('GMD', 'GMD_USER_CONTEXT_NOT_SET');
1819: FND_MSG_PUB.Add;
1820: RAISE FND_API.G_EXC_ERROR;
1821: END IF;
1822:

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

1825: /* Check if an appropriate action_code */
1826: /* has been supplied */
1827: /* ================================== */
1828: IF (p_formula_header_rec.record_type <> 'D') THEN
1829: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_ACTION');
1830: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1831: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1832: FND_MSG_PUB.Add;
1833: RAISE FND_API.G_EXC_ERROR;

Line 1830: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

1826: /* has been supplied */
1827: /* ================================== */
1828: IF (p_formula_header_rec.record_type <> 'D') THEN
1829: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_ACTION');
1830: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1831: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1832: FND_MSG_PUB.Add;
1833: RAISE FND_API.G_EXC_ERROR;
1834: END IF;

Line 1831: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);

1827: /* ================================== */
1828: IF (p_formula_header_rec.record_type <> 'D') THEN
1829: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_ACTION');
1830: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1831: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1832: FND_MSG_PUB.Add;
1833: RAISE FND_API.G_EXC_ERROR;
1834: END IF;
1835:

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

1843: p_formula_header_rec.formula_vers,
1844: l_formula_id, l_return_val);
1845: IF (l_return_val <> 0) THEN
1846: IF (p_formula_header_rec.formula_no IS NULL) THEN
1847: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
1848: FND_MSG_PUB.Add;
1849: RAISE FND_API.G_EXC_ERROR;
1850: ELSIF (p_formula_header_rec.formula_vers IS NULL) THEN
1851: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');

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

1847: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
1848: FND_MSG_PUB.Add;
1849: RAISE FND_API.G_EXC_ERROR;
1850: ELSIF (p_formula_header_rec.formula_vers IS NULL) THEN
1851: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
1852: FND_MSG_PUB.Add;
1853: RAISE FND_API.G_EXC_ERROR;
1854: ELSE
1855: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_FORMULA_ID');

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

1851: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
1852: FND_MSG_PUB.Add;
1853: RAISE FND_API.G_EXC_ERROR;
1854: ELSE
1855: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_FORMULA_ID');
1856: FND_MSG_PUB.Add;
1857: RAISE FND_API.G_EXC_ERROR;
1858: END IF;
1859: END IF;

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

1861: l_formula_id := p_formula_header_rec.formula_id;
1862: END IF;
1863:
1864: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
1865: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1866: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1867: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1868: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1869: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);

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

1862: END IF;
1863:
1864: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
1865: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1866: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1867: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1868: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1869: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1870: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));

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

1863:
1864: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
1865: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1866: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1867: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1868: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1869: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1870: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));
1871: FND_MSG_PUB.Add;

Line 1868: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);

1864: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
1865: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1866: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1867: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1868: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1869: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1870: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));
1871: FND_MSG_PUB.Add;
1872: RAISE FND_API.G_EXC_ERROR;

Line 1869: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);

1865: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1866: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1867: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1868: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1869: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1870: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));
1871: FND_MSG_PUB.Add;
1872: RAISE FND_API.G_EXC_ERROR;
1873: END IF;

Line 1870: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));

1866: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1867: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1868: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1869: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1870: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));
1871: FND_MSG_PUB.Add;
1872: RAISE FND_API.G_EXC_ERROR;
1873: END IF;
1874: