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

246: /* Check if there is a valid userid/ownerid */
247: /* ======================================== */
248: /* Bug 4603060 check if the user context is set */
249: IF (l_user_id IS NULL) THEN
250: FND_MESSAGE.SET_NAME('GMD', 'GMD_USER_CONTEXT_NOT_SET');
251: FND_MSG_PUB.Add;
252: RAISE FND_API.G_EXC_ERROR;
253: END IF;
254:

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

270: p_formula_header_rec.formula_vers,
271: l_formula_id, l_return_val);
272: IF (l_return_val <> 0) THEN
273: IF (p_formula_header_rec.formula_no IS NULL) THEN
274: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
275: FND_MSG_PUB.Add;
276: RAISE FND_API.G_EXC_ERROR;
277: ELSE
278: l_formula_no := p_formula_header_rec.formula_no;

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

278: l_formula_no := p_formula_header_rec.formula_no;
279: END IF;
280:
281: IF (p_formula_header_rec.formula_vers IS NULL) THEN
282: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
283: FND_MSG_PUB.Add;
284: RAISE FND_API.G_EXC_ERROR;
285: ELSE
286: l_formula_vers := p_formula_header_rec.formula_vers;

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

294:
295: --BEGIN BUG#2930523 V. Ajay Kumar
296: --Added code such that a message is displayed if the user tries to
297: --create an exisiting formula/version thru API.
298: -- FND_MESSAGE.SET_NAME('GMD', 'FM_ALREADYEXISTS');
299: -- FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
300: -- FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
301: -- FND_MSG_PUB.Add;
302: --END BUG#2930523

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

295: --BEGIN BUG#2930523 V. Ajay Kumar
296: --Added code such that a message is displayed if the user tries to
297: --create an exisiting formula/version thru API.
298: -- FND_MESSAGE.SET_NAME('GMD', 'FM_ALREADYEXISTS');
299: -- FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
300: -- FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
301: -- FND_MSG_PUB.Add;
302: --END BUG#2930523
303:

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

296: --Added code such that a message is displayed if the user tries to
297: --create an exisiting formula/version thru API.
298: -- FND_MESSAGE.SET_NAME('GMD', 'FM_ALREADYEXISTS');
299: -- FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
300: -- FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
301: -- FND_MSG_PUB.Add;
302: --END BUG#2930523
303:
304: BEGIN

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

311: EXIT;
312: END IF;
313: END LOOP;
314: IF l_temp_fm_id = -1 THEN
315: FND_MESSAGE.SET_NAME('GMD', 'FM_ALREADYEXISTS');
316: FND_MESSAGE.SET_TOKEN('FORMULA_NO',
317: p_formula_header_rec.formula_no);
318: FND_MESSAGE.SET_TOKEN('FORMULA_VERS',
319: p_formula_header_rec.formula_vers);

Line 316: FND_MESSAGE.SET_TOKEN('FORMULA_NO',

312: END IF;
313: END LOOP;
314: IF l_temp_fm_id = -1 THEN
315: FND_MESSAGE.SET_NAME('GMD', 'FM_ALREADYEXISTS');
316: FND_MESSAGE.SET_TOKEN('FORMULA_NO',
317: p_formula_header_rec.formula_no);
318: FND_MESSAGE.SET_TOKEN('FORMULA_VERS',
319: p_formula_header_rec.formula_vers);
320: FND_MSG_PUB.Add;

Line 318: FND_MESSAGE.SET_TOKEN('FORMULA_VERS',

314: IF l_temp_fm_id = -1 THEN
315: FND_MESSAGE.SET_NAME('GMD', 'FM_ALREADYEXISTS');
316: FND_MESSAGE.SET_TOKEN('FORMULA_NO',
317: p_formula_header_rec.formula_no);
318: FND_MESSAGE.SET_TOKEN('FORMULA_VERS',
319: p_formula_header_rec.formula_vers);
320: FND_MSG_PUB.Add;
321: END IF;
322: EXCEPTION

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

388: END IF;
389: END LOOP; -- for j IN ..
390:
391: IF (l_line_type_counter > 0) THEN
392: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');
393: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
394: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
395: -- Bug #3119000 (JKB) Changed values returned above to l_.
396: FND_MSG_PUB.Add;

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

389: END LOOP; -- for j IN ..
390:
391: IF (l_line_type_counter > 0) THEN
392: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');
393: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
394: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
395: -- Bug #3119000 (JKB) Changed values returned above to l_.
396: FND_MSG_PUB.Add;
397: RAISE FND_API.G_EXC_ERROR;

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

390:
391: IF (l_line_type_counter > 0) THEN
392: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');
393: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
394: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
395: -- Bug #3119000 (JKB) Changed values returned above to l_.
396: FND_MSG_PUB.Add;
397: RAISE FND_API.G_EXC_ERROR;
398: END IF;

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

429: END IF;
430: END LOOP;
431:
432: IF (l_line_type_counter > 0) THEN
433: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');
434: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
435: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
436: -- Bug #3119000 (JKB) Changed values returned above to l_.
437: FND_MSG_PUB.Add;

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

430: END LOOP;
431:
432: IF (l_line_type_counter > 0) THEN
433: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');
434: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
435: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
436: -- Bug #3119000 (JKB) Changed values returned above to l_.
437: FND_MSG_PUB.Add;
438: RAISE FND_API.G_EXC_ERROR;

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

431:
432: IF (l_line_type_counter > 0) THEN
433: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');
434: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
435: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
436: -- Bug #3119000 (JKB) Changed values returned above to l_.
437: FND_MSG_PUB.Add;
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;

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

458: END IF;
459:
460: --Check that organization id is not null if raise an error message
461: IF (p_formula_header_rec.owner_organization_id IS NULL) THEN
462: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_ORGANIZATION_ID');
463: FND_MSG_PUB.Add;
464: RAISE FND_API.G_EXC_ERROR;
465: ELSE
466: --Check the organization id passed is process enabled if not raise an error message

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

464: RAISE FND_API.G_EXC_ERROR;
465: ELSE
466: --Check the organization id passed is process enabled if not raise an error message
467: IF NOT (gmd_api_grp.check_orgn_status(p_formula_header_rec.owner_organization_id)) THEN
468: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
469: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_formula_header_rec.owner_organization_id);
470: FND_MSG_PUB.Add;
471: RAISE FND_API.G_EXC_ERROR;
472: END IF;

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

465: ELSE
466: --Check the organization id passed is process enabled if not raise an error message
467: IF NOT (gmd_api_grp.check_orgn_status(p_formula_header_rec.owner_organization_id)) THEN
468: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
469: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_formula_header_rec.owner_organization_id);
470: FND_MSG_PUB.Add;
471: RAISE FND_API.G_EXC_ERROR;
472: END IF;
473: -- Kapil ME Auto-Prod :Bug# 5716318

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

477: P_parm_value => l_auto_calc,
478: X_return_status => X_return_status );
479: IF (l_auto_calc IS NULL OR l_auto_calc = 'N') AND p_formula_header_rec.AUTO_PRODUCT_CALC = 'Y' THEN
480: /* Error raised when passing Formula Parameter as Yes when organziation parmater is NO */
481: FND_MESSAGE.SET_NAME('GMD', 'GMD_AUTO_PRODUCT_OFF');
482: FND_MSG_PUB.Add;
483: RAISE FND_API.G_EXC_ERROR;
484: END IF;
485: /* Error to be raised when Setting Scaling Allowed to No */

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

484: END IF;
485: /* Error to be raised when Setting Scaling Allowed to No */
486: IF p_formula_header_rec.auto_product_calc = 'Y'
487: AND p_formula_header_rec.scale_type_hdr = 0 THEN
488: FND_MESSAGE.SET_NAME('GMD', 'GMD_SCALE_AUTO_NO');
489: FND_MSG_PUB.Add;
490: RAISE FND_API.G_EXC_ERROR;
491: END IF;
492: END IF;

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

512: p_data => x_msg_data );
513: END;
514:
515: IF v_recipe_enabled <> 'Y' THEN
516: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_NOT_RECIPE_ENABLED');
517: FND_MESSAGE.SET_TOKEN('ITEM_NO', v_item_no);
518: FND_MSG_PUB.Add;
519: RAISE FND_API.G_EXC_ERROR;
520: END IF ;

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

513: END;
514:
515: IF v_recipe_enabled <> 'Y' THEN
516: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_NOT_RECIPE_ENABLED');
517: FND_MESSAGE.SET_TOKEN('ITEM_NO', v_item_no);
518: FND_MSG_PUB.Add;
519: RAISE FND_API.G_EXC_ERROR;
520: END IF ;
521: END LOOP; */

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

541: ||' - '
542: ||x_return_status);
543: END IF;
544: IF (p_formula_header_rec.formula_desc1 IS NULL) THEN
545: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_DESC');
546: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
547: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
548: FND_MSG_PUB.Add;
549: RAISE FND_API.G_EXC_ERROR;

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

542: ||x_return_status);
543: END IF;
544: IF (p_formula_header_rec.formula_desc1 IS NULL) THEN
545: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_DESC');
546: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
547: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
548: FND_MSG_PUB.Add;
549: RAISE FND_API.G_EXC_ERROR;
550: END IF;

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

543: END IF;
544: IF (p_formula_header_rec.formula_desc1 IS NULL) THEN
545: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_DESC');
546: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
547: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
548: FND_MSG_PUB.Add;
549: RAISE FND_API.G_EXC_ERROR;
550: END IF;
551:

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

560: ||x_return_status);
561: END IF;
562: IF (p_formula_header_rec.formula_type <> 0) AND
563: (p_formula_header_rec.formula_type <> 1) THEN
564: FND_MESSAGE.SET_NAME('GMD', 'FM_WRONG_TYPE');
565: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
566: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
567: FND_MSG_PUB.Add;
568: RAISE FND_API.G_EXC_ERROR;

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

561: END IF;
562: IF (p_formula_header_rec.formula_type <> 0) AND
563: (p_formula_header_rec.formula_type <> 1) THEN
564: FND_MESSAGE.SET_NAME('GMD', 'FM_WRONG_TYPE');
565: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
566: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
567: FND_MSG_PUB.Add;
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;

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

562: IF (p_formula_header_rec.formula_type <> 0) AND
563: (p_formula_header_rec.formula_type <> 1) THEN
564: FND_MESSAGE.SET_NAME('GMD', 'FM_WRONG_TYPE');
565: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
566: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
567: FND_MSG_PUB.Add;
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;
570:

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

578: ||' - '
579: ||x_return_status);
580: END IF;
581: IF (p_formula_header_rec.scale_type_hdr IS NULL) THEN
582: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_SCALE_TYPE');
583: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
584: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
585: FND_MSG_PUB.Add;
586: RAISE FND_API.G_EXC_ERROR;

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

579: ||x_return_status);
580: END IF;
581: IF (p_formula_header_rec.scale_type_hdr IS NULL) THEN
582: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_SCALE_TYPE');
583: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
584: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
585: FND_MSG_PUB.Add;
586: RAISE FND_API.G_EXC_ERROR;
587: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN

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

580: END IF;
581: IF (p_formula_header_rec.scale_type_hdr IS NULL) THEN
582: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_SCALE_TYPE');
583: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
584: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
585: FND_MSG_PUB.Add;
586: RAISE FND_API.G_EXC_ERROR;
587: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN
588: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');

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

584: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
585: FND_MSG_PUB.Add;
586: RAISE FND_API.G_EXC_ERROR;
587: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN
588: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');
589: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
590: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
591: FND_MSG_PUB.Add;
592: RAISE FND_API.G_EXC_ERROR;

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

585: FND_MSG_PUB.Add;
586: RAISE FND_API.G_EXC_ERROR;
587: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN
588: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');
589: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
590: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
591: FND_MSG_PUB.Add;
592: RAISE FND_API.G_EXC_ERROR;
593: END IF;

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

586: RAISE FND_API.G_EXC_ERROR;
587: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN
588: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');
589: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
590: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
591: FND_MSG_PUB.Add;
592: RAISE FND_API.G_EXC_ERROR;
593: END IF;
594:

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

604: END IF;
605: IF (p_formula_header_rec.formula_class IS NOT NULL) THEN
606: l_return_val := GMDFMVAL_PUB.formula_class_val(p_formula_header_rec.formula_class);
607: IF (l_return_val <> 0) THEN
608: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
609: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
610: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
611: FND_MSG_PUB.Add;
612: RAISE FND_API.G_EXC_ERROR;

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

605: IF (p_formula_header_rec.formula_class IS NOT NULL) THEN
606: l_return_val := GMDFMVAL_PUB.formula_class_val(p_formula_header_rec.formula_class);
607: IF (l_return_val <> 0) THEN
608: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
609: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
610: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
611: FND_MSG_PUB.Add;
612: RAISE FND_API.G_EXC_ERROR;
613: END IF;

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

606: l_return_val := GMDFMVAL_PUB.formula_class_val(p_formula_header_rec.formula_class);
607: IF (l_return_val <> 0) THEN
608: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
609: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
610: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
611: FND_MSG_PUB.Add;
612: RAISE FND_API.G_EXC_ERROR;
613: END IF;
614: END IF;

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

626: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
627: IF (p_formula_header_rec.formula_id IS NULL) THEN
628: l_return_val := GMDSURG.get_surrogate('formula_id');
629: IF (l_return_val < 1) THEN
630: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_FORMULA_ID');
631: FND_MSG_PUB.Add;
632: RAISE FND_API.G_EXC_ERROR;
633: ELSE
634: l_surrogate := l_return_val;

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

776: /* BEGIN BUG#2868184 Based on the ingredient quantity and parameter value */
777: /* Formula/Formula's are either rolled back or inserted with warning */
778:
779: IF l_flag = 'F' AND l_formula_detail_tbl(1).line_type = -1 AND l_formula_detail_tbl(1).qty = 0 THEN
780: FND_MESSAGE.SET_NAME('GMD','GMD_ZERO_INGREDIENT_QTY');
781: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
782: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
783: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_formula_detail_tbl(1).item_no );
784: FND_MSG_PUB.Add;

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

777: /* Formula/Formula's are either rolled back or inserted with warning */
778:
779: IF l_flag = 'F' AND l_formula_detail_tbl(1).line_type = -1 AND l_formula_detail_tbl(1).qty = 0 THEN
780: FND_MESSAGE.SET_NAME('GMD','GMD_ZERO_INGREDIENT_QTY');
781: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
782: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
783: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_formula_detail_tbl(1).item_no );
784: FND_MSG_PUB.Add;
785: RAISE FND_API.G_EXC_ERROR;

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

778:
779: IF l_flag = 'F' AND l_formula_detail_tbl(1).line_type = -1 AND l_formula_detail_tbl(1).qty = 0 THEN
780: FND_MESSAGE.SET_NAME('GMD','GMD_ZERO_INGREDIENT_QTY');
781: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
782: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
783: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_formula_detail_tbl(1).item_no );
784: FND_MSG_PUB.Add;
785: RAISE FND_API.G_EXC_ERROR;
786: ELSIF l_flag = 'W' AND l_formula_detail_tbl(1).line_type = -1 AND l_formula_detail_tbl(1).qty = 0 THEN

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

779: IF l_flag = 'F' AND l_formula_detail_tbl(1).line_type = -1 AND l_formula_detail_tbl(1).qty = 0 THEN
780: FND_MESSAGE.SET_NAME('GMD','GMD_ZERO_INGREDIENT_QTY');
781: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_no);
782: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_vers);
783: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_formula_detail_tbl(1).item_no );
784: FND_MSG_PUB.Add;
785: RAISE FND_API.G_EXC_ERROR;
786: ELSIF l_flag = 'W' AND l_formula_detail_tbl(1).line_type = -1 AND l_formula_detail_tbl(1).qty = 0 THEN
787: FND_MESSAGE.SET_NAME('GMD','GMD_ALLOW_ZERO_QTY');

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

783: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_formula_detail_tbl(1).item_no );
784: FND_MSG_PUB.Add;
785: RAISE FND_API.G_EXC_ERROR;
786: ELSIF l_flag = 'W' AND l_formula_detail_tbl(1).line_type = -1 AND l_formula_detail_tbl(1).qty = 0 THEN
787: FND_MESSAGE.SET_NAME('GMD','GMD_ALLOW_ZERO_QTY');
788: FND_MSG_PUB.Add;
789: END IF;
790: /* END BUG#2868184 */
791:

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

875: X_entity_status => l_entity_status);
876: -- Check for any experimental items when formula status is apfgu.
877: IF (l_entity_status.status_type = 700) THEN
878: IF (gmdfmval_pub.check_expr_items(l_tbl_formula_id(i).formula_id)) THEN
879: FND_MESSAGE.SET_NAME('GMD','GMD_EXPR_ITEMS_FOUND');
880: FND_MSG_PUB.ADD;
881: RAISE FND_API.G_EXC_ERROR;
882: END IF; -- IF (gmdfmval_pub.check_expr_items(p_formula_header_rec.formula_id) THEN
883: END IF; -- IF (X_status_type = 700) THEN

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

884:
885: --Check any inactive items in formula before changing the status
886: IF (l_entity_status.status_type IN (400,700)) THEN
887: IF (gmdfmval_pub.inactive_items(l_tbl_formula_id(i).formula_id)) THEN
888: FND_MESSAGE.SET_NAME('GMI','IC_ITEM_INACTIVE');
889: FND_MSG_PUB.ADD;
890: RAISE FND_API.G_EXC_ERROR;
891: END IF; -- IF (gmdfmval_pub.inactive_items(V_formula_id) THEN
892: END IF; --l_entity_status.status_type IN (400,700)

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

1115: gmd_debug.put_line(' In Formula Header Pub - Before user validation ');
1116: END IF;
1117: -- Bug 4603060
1118: IF (l_user_id IS NULL) THEN
1119: FND_MESSAGE.SET_NAME('GMD', 'GMD_USER_CONTEXT_NOT_SET');
1120: FND_MSG_PUB.Add;
1121: RAISE FND_API.G_EXC_ERROR;
1122: END IF;
1123:

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

1134: p_formula_header_rec.formula_vers,
1135: l_formula_id, l_return_val);
1136: IF (l_return_val <> 0) THEN
1137: IF (p_formula_header_rec.formula_no IS NULL) THEN
1138: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
1139: FND_MSG_PUB.Add;
1140: RAISE FND_API.G_EXC_ERROR;
1141: ELSIF (p_formula_header_rec.formula_vers IS NULL) THEN
1142: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');

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

1138: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
1139: FND_MSG_PUB.Add;
1140: RAISE FND_API.G_EXC_ERROR;
1141: ELSIF (p_formula_header_rec.formula_vers IS NULL) THEN
1142: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
1143: FND_MSG_PUB.Add;
1144: RAISE FND_API.G_EXC_ERROR;
1145: ELSE
1146: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_FORMULA_ID');

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

1142: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
1143: FND_MSG_PUB.Add;
1144: RAISE FND_API.G_EXC_ERROR;
1145: ELSE
1146: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_FORMULA_ID');
1147: FND_MSG_PUB.Add;
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;
1150: END IF;

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

1235: := update_not_null_rec.auto_product_calc;
1236: ELSE
1237: /* Update of the Flag is prevented form the API as the user cannot specify the Percentages. */
1238: IF NVL(UPPER(p_called_from_forms),'NO') <> 'YES' THEN
1239: FND_MESSAGE.SET_NAME('GMD', 'GMD_CANNOT_AUTO_FLAG');
1240: FND_MSG_PUB.Add;
1241: RAISE FND_API.G_EXC_ERROR;
1242: END IF;
1243: END IF;

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

1246: --Check that organization id is not null if raise an error message
1247: IF (p_formula_header_rec.owner_organization_id IS NOT NULL) THEN
1248: --Check the organization id passed is process enabled if not raise an error message
1249: IF NOT (gmd_api_grp.check_orgn_status(p_formula_header_rec.owner_organization_id)) THEN
1250: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
1251: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_formula_header_rec.owner_organization_id);
1252: FND_MSG_PUB.Add;
1253: RAISE FND_API.G_EXC_ERROR;
1254: END IF;

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

1247: IF (p_formula_header_rec.owner_organization_id IS NOT NULL) THEN
1248: --Check the organization id passed is process enabled if not raise an error message
1249: IF NOT (gmd_api_grp.check_orgn_status(p_formula_header_rec.owner_organization_id)) THEN
1250: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
1251: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_formula_header_rec.owner_organization_id);
1252: FND_MSG_PUB.Add;
1253: RAISE FND_API.G_EXC_ERROR;
1254: END IF;
1255: END IF;

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

1262: l_update_chk_col := NULL;
1263: END IF;
1264: --Check whether record is update allowed or not
1265: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id, l_update_chk_col) THEN
1266: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1267: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1268: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1269: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1270: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);

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

1263: END IF;
1264: --Check whether record is update allowed or not
1265: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id, l_update_chk_col) THEN
1266: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1267: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1268: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1269: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1270: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1271: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));

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

1264: --Check whether record is update allowed or not
1265: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id, l_update_chk_col) THEN
1266: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1267: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1268: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1269: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1270: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1271: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));
1272: FND_MSG_PUB.Add;

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

1265: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id, l_update_chk_col) THEN
1266: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1267: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1268: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1269: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1270: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1271: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));
1272: FND_MSG_PUB.Add;
1273: RAISE FND_API.G_EXC_ERROR;

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

1266: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1267: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1268: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1269: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1270: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1271: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));
1272: FND_MSG_PUB.Add;
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;

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

1267: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1268: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1269: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1270: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1271: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));
1272: FND_MSG_PUB.Add;
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275:

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

1285: ||x_return_status);
1286: END IF;
1287: IF (p_formula_header_rec.formula_type <> 0) AND
1288: (p_formula_header_rec.formula_type <> 1) THEN
1289: FND_MESSAGE.SET_NAME('GMD', 'FM_WRONG_TYPE');
1290: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1291: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1292: FND_MSG_PUB.Add;
1293: RAISE FND_API.G_EXC_ERROR;

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

1286: END IF;
1287: IF (p_formula_header_rec.formula_type <> 0) AND
1288: (p_formula_header_rec.formula_type <> 1) THEN
1289: FND_MESSAGE.SET_NAME('GMD', 'FM_WRONG_TYPE');
1290: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1291: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1292: FND_MSG_PUB.Add;
1293: RAISE FND_API.G_EXC_ERROR;
1294: END IF;

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

1287: IF (p_formula_header_rec.formula_type <> 0) AND
1288: (p_formula_header_rec.formula_type <> 1) THEN
1289: FND_MESSAGE.SET_NAME('GMD', 'FM_WRONG_TYPE');
1290: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1291: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1292: FND_MSG_PUB.Add;
1293: RAISE FND_API.G_EXC_ERROR;
1294: END IF;
1295:

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

1302: ||' - '
1303: ||x_return_status);
1304: END IF;
1305: IF (p_formula_header_rec.scale_type_hdr IS NULL) THEN
1306: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_SCALE_TYPE');
1307: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1308: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1309: FND_MSG_PUB.Add;
1310: RAISE FND_API.G_EXC_ERROR;

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

1303: ||x_return_status);
1304: END IF;
1305: IF (p_formula_header_rec.scale_type_hdr IS NULL) THEN
1306: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_SCALE_TYPE');
1307: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1308: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1309: FND_MSG_PUB.Add;
1310: RAISE FND_API.G_EXC_ERROR;
1311: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN

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

1304: END IF;
1305: IF (p_formula_header_rec.scale_type_hdr IS NULL) THEN
1306: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_SCALE_TYPE');
1307: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1308: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1309: FND_MSG_PUB.Add;
1310: RAISE FND_API.G_EXC_ERROR;
1311: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN
1312: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');

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

1308: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1309: FND_MSG_PUB.Add;
1310: RAISE FND_API.G_EXC_ERROR;
1311: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN
1312: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');
1313: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1314: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1315: FND_MSG_PUB.Add;
1316: RAISE FND_API.G_EXC_ERROR;

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

1309: FND_MSG_PUB.Add;
1310: RAISE FND_API.G_EXC_ERROR;
1311: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN
1312: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');
1313: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1314: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1315: FND_MSG_PUB.Add;
1316: RAISE FND_API.G_EXC_ERROR;
1317: -- SCALING KAPIL

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

1310: RAISE FND_API.G_EXC_ERROR;
1311: ELSIF (p_formula_header_rec.scale_type_hdr NOT IN (0,1)) THEN
1312: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALETYPERR');
1313: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1314: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1315: FND_MSG_PUB.Add;
1316: RAISE FND_API.G_EXC_ERROR;
1317: -- SCALING KAPIL
1318: ELSIF p_formula_header_rec.scale_type_hdr = 0 THEN

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

1317: -- SCALING KAPIL
1318: ELSIF p_formula_header_rec.scale_type_hdr = 0 THEN
1319: IF p_formula_header_rec.auto_product_calc = 'Y' THEN
1320: p_formula_header_rec.auto_product_calc := 'N';
1321: FND_MESSAGE.SET_NAME('GMD', 'GMD_SCALE_SET_AUTO_OFF');
1322: FND_MSG_PUB.Add;
1323: END IF;
1324: END IF;
1325:

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

1335: IF (p_formula_header_rec.formula_class IS NOT NULL) THEN
1336: l_return_val := GMDFMVAL_PUB.formula_class_val(
1337: p_formula_header_rec.formula_class);
1338: IF (l_return_val <> 0) THEN
1339: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
1340: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1341: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1342: FND_MSG_PUB.Add;
1343: RAISE FND_API.G_EXC_ERROR;

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

1336: l_return_val := GMDFMVAL_PUB.formula_class_val(
1337: p_formula_header_rec.formula_class);
1338: IF (l_return_val <> 0) THEN
1339: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
1340: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1341: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1342: FND_MSG_PUB.Add;
1343: RAISE FND_API.G_EXC_ERROR;
1344: END IF;

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

1337: p_formula_header_rec.formula_class);
1338: IF (l_return_val <> 0) THEN
1339: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
1340: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1341: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1342: FND_MSG_PUB.Add;
1343: RAISE FND_API.G_EXC_ERROR;
1344: END IF;
1345: END IF;

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

1651: IF (l_formula_class IS NOT NULL ) THEN
1652: l_return_val := GMDFMVAL_PUB.formula_class_val(
1653: l_formula_class);
1654: IF (l_return_val <> 0) THEN
1655: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
1656: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1657: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1658: FND_MSG_PUB.Add;
1659: RAISE FND_API.G_EXC_ERROR;

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

1652: l_return_val := GMDFMVAL_PUB.formula_class_val(
1653: l_formula_class);
1654: IF (l_return_val <> 0) THEN
1655: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
1656: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1657: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1658: FND_MSG_PUB.Add;
1659: RAISE FND_API.G_EXC_ERROR;
1660: END IF;

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

1653: l_formula_class);
1654: IF (l_return_val <> 0) THEN
1655: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
1656: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1657: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1658: FND_MSG_PUB.Add;
1659: RAISE FND_API.G_EXC_ERROR;
1660: END IF;
1661: END IF;

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

1889: /* Check if there is a valid userid/ownerid */
1890: /* ======================================== */
1891: -- Bug 4603060
1892: IF (l_user_id IS NULL) THEN
1893: FND_MESSAGE.SET_NAME('GMD', 'GMD_USER_CONTEXT_NOT_SET');
1894: FND_MSG_PUB.Add;
1895: RAISE FND_API.G_EXC_ERROR;
1896: END IF;
1897:

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

1900: /* Check if an appropriate action_code */
1901: /* has been supplied */
1902: /* ================================== */
1903: IF (p_formula_header_rec.record_type <> 'D') THEN
1904: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_ACTION');
1905: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1906: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1907: FND_MSG_PUB.Add;
1908: RAISE FND_API.G_EXC_ERROR;

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

1901: /* has been supplied */
1902: /* ================================== */
1903: IF (p_formula_header_rec.record_type <> 'D') THEN
1904: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_ACTION');
1905: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1906: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1907: FND_MSG_PUB.Add;
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;

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

1902: /* ================================== */
1903: IF (p_formula_header_rec.record_type <> 'D') THEN
1904: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_ACTION');
1905: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
1906: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);
1907: FND_MSG_PUB.Add;
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;
1910:

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

1918: p_formula_header_rec.formula_vers,
1919: l_formula_id, l_return_val);
1920: IF (l_return_val <> 0) THEN
1921: IF (p_formula_header_rec.formula_no IS NULL) THEN
1922: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
1923: FND_MSG_PUB.Add;
1924: RAISE FND_API.G_EXC_ERROR;
1925: ELSIF (p_formula_header_rec.formula_vers IS NULL) THEN
1926: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');

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

1922: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
1923: FND_MSG_PUB.Add;
1924: RAISE FND_API.G_EXC_ERROR;
1925: ELSIF (p_formula_header_rec.formula_vers IS NULL) THEN
1926: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
1927: FND_MSG_PUB.Add;
1928: RAISE FND_API.G_EXC_ERROR;
1929: ELSE
1930: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_FORMULA_ID');

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

1926: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
1927: FND_MSG_PUB.Add;
1928: RAISE FND_API.G_EXC_ERROR;
1929: ELSE
1930: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_FORMULA_ID');
1931: FND_MSG_PUB.Add;
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;
1934: END IF;

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

1936: l_formula_id := p_formula_header_rec.formula_id;
1937: END IF;
1938:
1939: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
1940: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1941: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1942: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1943: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1944: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);

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

1937: END IF;
1938:
1939: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
1940: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1941: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1942: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1943: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1944: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1945: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));

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

1938:
1939: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
1940: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1941: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1942: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1943: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1944: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1945: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));
1946: FND_MSG_PUB.Add;

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

1939: IF NOT GMD_COMMON_VAL.Update_Allowed('FORMULA',l_formula_id) THEN
1940: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1941: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1942: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1943: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1944: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1945: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));
1946: FND_MSG_PUB.Add;
1947: RAISE FND_API.G_EXC_ERROR;

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

1940: FND_MESSAGE.SET_NAME('GMD','GMD_CANNOT_UPD_ENTITY');
1941: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1942: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1943: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1944: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1945: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));
1946: FND_MSG_PUB.Add;
1947: RAISE FND_API.G_EXC_ERROR;
1948: END IF;

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

1941: FND_MESSAGE.SET_TOKEN('NAME', 'formula');
1942: FND_MESSAGE.SET_TOKEN('ID', l_formula_id);
1943: FND_MESSAGE.SET_TOKEN('NO', p_formula_header_rec.formula_no);
1944: FND_MESSAGE.SET_TOKEN('VERS', p_formula_header_rec.formula_vers);
1945: FND_MESSAGE.SET_TOKEN('STATUS',get_fm_status_meaning(l_formula_id));
1946: FND_MSG_PUB.Add;
1947: RAISE FND_API.G_EXC_ERROR;
1948: END IF;
1949: