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_MSG_PUB

Line 187: FND_MSG_PUB.initialize;

183: END IF;
184:
185: /* Initialize message list if p_init_msg_list is set to TRUE */
186: IF FND_API.to_Boolean( p_init_msg_list ) THEN
187: FND_MSG_PUB.initialize;
188: END IF;
189:
190: /* Start the loop - Error out if the table is empty */
191: IF (p_formula_header_tbl.count = 0) THEN

Line 243: FND_MSG_PUB.Add;

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:
247: IF (l_debug = 'Y') THEN

Line 267: FND_MSG_PUB.Add;

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;
271: END IF;

Line 275: FND_MSG_PUB.Add;

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;
279: END IF;

Line 293: FND_MSG_PUB.Add;

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;
297: ELSE -- formula header exists

Line 365: FND_MSG_PUB.Add;

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;
368: END IF;
369:

Line 406: FND_MSG_PUB.Add;

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;
409: END IF;
410:

Line 432: FND_MSG_PUB.Add;

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
436: IF NOT (gmd_api_grp.check_orgn_status(p_formula_header_rec.owner_organization_id)) THEN

Line 439: FND_MSG_PUB.Add;

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
443: /* Fetch the Organization Auto-Product qty calculate Parameter*/

Line 451: FND_MSG_PUB.Add;

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 */
455: IF p_formula_header_rec.auto_product_calc = 'Y'

Line 458: FND_MSG_PUB.Add;

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;
462:

Line 476: FND_MSG_PUB.Count_And_Get (

472: EXCEPTION
473: WHEN others THEN
474: ROLLBACK to Insert_FormulaHeader_PUB;
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: FND_MSG_PUB.Count_And_Get (
477: p_count => x_msg_count,
478: p_data => x_msg_data );
479: END;
480:

Line 484: FND_MSG_PUB.Add;

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;
488: /* Bug No.6799624 - End */

Line 514: FND_MSG_PUB.Add;

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:
518: /* ===================================== */

Line 533: FND_MSG_PUB.Add;

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:
537: /* ======================================= */

Line 551: FND_MSG_PUB.Add;

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');
555: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

Line 557: FND_MSG_PUB.Add;

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:
561: /* ====================== */

Line 577: FND_MSG_PUB.Add;

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;
581:

Line 597: FND_MSG_PUB.Add;

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;
601: END IF;

Line 745: FND_MSG_PUB.Add;

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');
749: FND_MSG_PUB.Add;

Line 749: FND_MSG_PUB.Add;

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:
753: /* Based on return codes we need to insert formula details too */

Line 814: FND_MSG_PUB.ADD;

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
818:

Line 823: FND_MSG_PUB.ADD;

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)
827: --kkillams,bug 3408799

Line 863: FND_MSG_PUB.Count_And_Get (

859: Commit;
860: END IF;
861:
862: /* Get the message count and information */
863: FND_MSG_PUB.Count_And_Get (
864: p_count => x_msg_count,
865: p_data => x_msg_data );
866:
867: EXCEPTION

Line 870: FND_MSG_PUB.Count_And_Get (

866:
867: EXCEPTION
868: WHEN default_status_err THEN
869: ROLLBACK TO default_status_sp;
870: FND_MSG_PUB.Count_And_Get (
871: p_count => x_msg_count,
872: p_data => x_msg_data );
873: WHEN FND_API.G_EXC_ERROR THEN
874: ROLLBACK to Insert_FormulaHeader_PUB;

Line 876: FND_MSG_PUB.Count_And_Get (

872: p_data => x_msg_data );
873: WHEN FND_API.G_EXC_ERROR THEN
874: ROLLBACK to Insert_FormulaHeader_PUB;
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: FND_MSG_PUB.Count_And_Get (
877: p_count => x_msg_count,
878: p_data => x_msg_data );
879: IF (l_debug = 'Y') THEN
880: gmd_debug.put_line(' In Formula Header Pub - In Error Exception Section '

Line 887: FND_MSG_PUB.Count_And_Get (

883: END IF;
884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
885: ROLLBACK to Insert_FormulaHeader_PUB;
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
887: FND_MSG_PUB.Count_And_Get (
888: p_count => x_msg_count,
889: p_data => x_msg_data );
890: IF (l_debug = 'Y') THEN
891: gmd_debug.put_line(' In Formula Header Pub - In unexpected Exception Section '

Line 898: FND_MSG_PUB.Count_And_Get (

894: END IF;
895: WHEN RECIPE_GENERATE_ERROR THEN
896: ROLLBACK to Insert_FormulaHeader_PUB;
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
898: FND_MSG_PUB.Count_And_Get (
899: p_count => x_msg_count,
900: p_data => x_msg_data );
901: IF (l_debug = 'Y') THEN
902: gmd_debug.put_line(' In Formula Header Pub - In Recipe Generate Exception Section '

Line 908: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);

904: ||x_return_status);
905: END IF;
906: WHEN OTHERS THEN
907: ROLLBACK to Insert_FormulaHeader_PUB;
908: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: FND_MSG_PUB.Count_And_Get (
911: p_count => x_msg_count,
912: p_data => x_msg_data );

Line 910: FND_MSG_PUB.Count_And_Get (

906: WHEN OTHERS THEN
907: ROLLBACK to Insert_FormulaHeader_PUB;
908: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: FND_MSG_PUB.Count_And_Get (
911: p_count => x_msg_count,
912: p_data => x_msg_data );
913: IF (l_debug = 'Y') THEN
914: gmd_debug.put_line(' In Formula Header Pub - In Others Exception Section '

Line 1023: FND_MSG_PUB.initialize;

1019: END IF;
1020:
1021: /* Initialize message list if p_init_msg_list is set to TRUE */
1022: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1023: FND_MSG_PUB.initialize;
1024: END IF;
1025:
1026: /* Start looping through the table */
1027: IF (p_formula_header_tbl.count = 0) THEN

Line 1051: FND_MSG_PUB.Add;

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:
1055: /* ==================== */

Line 1070: FND_MSG_PUB.Add;

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');
1074: FND_MSG_PUB.Add;

Line 1074: FND_MSG_PUB.Add;

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');
1078: FND_MSG_PUB.Add;

Line 1078: FND_MSG_PUB.Add;

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;
1082: ELSE

Line 1171: FND_MSG_PUB.Add;

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;
1175: END LOOP;

Line 1183: FND_MSG_PUB.Add;

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;
1187:

Line 1198: FND_MSG_PUB.Add;

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;
1202: END IF;

Line 1218: FND_MSG_PUB.Add;

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:
1222: /* ==================== */

Line 1235: FND_MSG_PUB.Add;

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');
1239: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

Line 1241: FND_MSG_PUB.Add;

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
1245: IF p_formula_header_rec.auto_product_calc = 'Y' THEN

Line 1248: FND_MSG_PUB.Add;

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:
1252: /* ====================== */

Line 1268: FND_MSG_PUB.Add;

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;
1272:

Line 1584: FND_MSG_PUB.Add;

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;
1588:

Line 1704: FND_MSG_PUB.Count_And_Get (

1700: END IF;
1701: END IF;
1702:
1703: /* Get the message count and information */
1704: FND_MSG_PUB.Count_And_Get (
1705: p_count => x_msg_count,
1706: p_data => x_msg_data );
1707:
1708: EXCEPTION

Line 1712: FND_MSG_PUB.Count_And_Get (

1708: EXCEPTION
1709: WHEN FND_API.G_EXC_ERROR THEN
1710: ROLLBACK to Update_FormulaHeader_PUB;
1711: x_return_status := FND_API.G_RET_STS_ERROR;
1712: FND_MSG_PUB.Count_And_Get (
1713: p_count => x_msg_count,
1714: p_data => x_msg_data );
1715: IF (l_debug = 'Y') THEN
1716: gmd_debug.put_line(' In Formula Header Pub - In Error Exception Section '

Line 1723: FND_MSG_PUB.Count_And_Get (

1719: END IF;
1720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1721: ROLLBACK to Update_FormulaHeader_PUB;
1722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1723: FND_MSG_PUB.Count_And_Get (
1724: p_count => x_msg_count,
1725: p_data => x_msg_data );
1726: IF (l_debug = 'Y') THEN
1727: gmd_debug.put_line(' In Formula Header Pub - In unexpected Exception Section '

Line 1733: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);

1729: ||x_return_status);
1730: END IF;
1731: WHEN OTHERS THEN
1732: ROLLBACK to Update_FormulaHeader_PUB;
1733: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
1734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1735: FND_MSG_PUB.Count_And_Get (
1736: p_count => x_msg_count,
1737: p_data => x_msg_data );

Line 1735: FND_MSG_PUB.Count_And_Get (

1731: WHEN OTHERS THEN
1732: ROLLBACK to Update_FormulaHeader_PUB;
1733: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
1734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1735: FND_MSG_PUB.Count_And_Get (
1736: p_count => x_msg_count,
1737: p_data => x_msg_data );
1738: IF (l_debug = 'Y') THEN
1739: gmd_debug.put_line(' In Formula Header Pub - In OTHERs Exception Section '

Line 1799: FND_MSG_PUB.initialize;

1795: END IF;
1796:
1797: /* Initialize message list if p_init_msg_list is set to TRUE */
1798: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1799: FND_MSG_PUB.initialize;
1800: END IF;
1801: /* Initialize API return status to success */
1802: x_return_status := FND_API.G_RET_STS_SUCCESS;
1803:

Line 1819: FND_MSG_PUB.Add;

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:
1823:

Line 1832: FND_MSG_PUB.Add;

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:
1836: /* ======================== */

Line 1848: FND_MSG_PUB.Add;

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');
1852: FND_MSG_PUB.Add;

Line 1852: FND_MSG_PUB.Add;

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');
1856: FND_MSG_PUB.Add;

Line 1856: FND_MSG_PUB.Add;

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;
1860: ELSE

Line 1871: FND_MSG_PUB.Add;

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:
1875: /* Call the private API to update the header info */

Line 1968: FND_MSG_PUB.Count_And_Get (

1964: END IF;
1965: END IF;
1966:
1967: /* Get the message count and information */
1968: FND_MSG_PUB.Count_And_Get (
1969: p_count => x_msg_count,
1970: p_data => x_msg_data );
1971:
1972: EXCEPTION

Line 1976: FND_MSG_PUB.Count_And_Get (

1972: EXCEPTION
1973: WHEN FND_API.G_EXC_ERROR THEN
1974: ROLLBACK to Delete_FormulaHeader_PUB;
1975: x_return_status := FND_API.G_RET_STS_ERROR;
1976: FND_MSG_PUB.Count_And_Get (
1977: p_count => x_msg_count,
1978: p_data => x_msg_data );
1979:
1980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1983: FND_MSG_PUB.Count_And_Get (

1979:
1980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1981: ROLLBACK to Delete_FormulaHeader_PUB;
1982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1983: FND_MSG_PUB.Count_And_Get (
1984: p_count => x_msg_count,
1985: p_data => x_msg_data );
1986:
1987: WHEN OTHERS THEN

Line 1989: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);

1985: p_data => x_msg_data );
1986:
1987: WHEN OTHERS THEN
1988: ROLLBACK to Delete_FormulaHeader_PUB;
1989: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
1990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1991: FND_MSG_PUB.Count_And_Get (
1992: p_count => x_msg_count,
1993: p_data => x_msg_data );

Line 1991: FND_MSG_PUB.Count_And_Get (

1987: WHEN OTHERS THEN
1988: ROLLBACK to Delete_FormulaHeader_PUB;
1989: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
1990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1991: FND_MSG_PUB.Count_And_Get (
1992: p_count => x_msg_count,
1993: p_data => x_msg_data );
1994:
1995: END Delete_FormulaHeader;