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 195: FND_MSG_PUB.initialize;

191: END IF;
192:
193: /* Initialize message list if p_init_msg_list is set to TRUE */
194: IF FND_API.to_Boolean( p_init_msg_list ) THEN
195: FND_MSG_PUB.initialize;
196: END IF;
197:
198: /* Start the loop - Error out if the table is empty */
199: IF (p_formula_header_tbl.count = 0) THEN

Line 251: FND_MSG_PUB.Add;

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

Line 275: FND_MSG_PUB.Add;

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

Line 283: FND_MSG_PUB.Add;

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

Line 301: -- FND_MSG_PUB.Add;

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

Line 320: FND_MSG_PUB.Add;

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
323: WHEN others THEN
324: NULL;

Line 396: FND_MSG_PUB.Add;

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

Line 437: FND_MSG_PUB.Add;

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

Line 463: FND_MSG_PUB.Add;

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

Line 470: FND_MSG_PUB.Add;

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

Line 482: FND_MSG_PUB.Add;

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

Line 489: FND_MSG_PUB.Add;

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

Line 510: FND_MSG_PUB.Count_And_Get (

506: EXCEPTION
507: WHEN others THEN
508: ROLLBACK to Insert_FormulaHeader_PUB;
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: FND_MSG_PUB.Count_And_Get (
511: p_count => x_msg_count,
512: p_data => x_msg_data );
513: END;
514:

Line 518: FND_MSG_PUB.Add;

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

Line 548: FND_MSG_PUB.Add;

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

Line 567: FND_MSG_PUB.Add;

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

Line 585: FND_MSG_PUB.Add;

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

Line 591: FND_MSG_PUB.Add;

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

Line 611: FND_MSG_PUB.Add;

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

Line 631: FND_MSG_PUB.Add;

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

Line 784: FND_MSG_PUB.Add;

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

Line 788: FND_MSG_PUB.Add;

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

Line 880: FND_MSG_PUB.ADD;

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

Line 889: FND_MSG_PUB.ADD;

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

Line 932: FND_MSG_PUB.Count_And_Get (

928: END IF;
929: END IF;
930:
931: /* Get the message count and information */
932: FND_MSG_PUB.Count_And_Get (
933: p_count => x_msg_count,
934: p_data => x_msg_data );
935: EXCEPTION
936: WHEN default_status_err THEN

Line 938: FND_MSG_PUB.Count_And_Get (

934: p_data => x_msg_data );
935: EXCEPTION
936: WHEN default_status_err THEN
937: ROLLBACK TO default_status_sp;
938: FND_MSG_PUB.Count_And_Get (
939: p_count => x_msg_count,
940: p_data => x_msg_data );
941: WHEN FND_API.G_EXC_ERROR THEN
942: ROLLBACK to Insert_FormulaHeader_PUB;

Line 944: FND_MSG_PUB.Count_And_Get (

940: p_data => x_msg_data );
941: WHEN FND_API.G_EXC_ERROR THEN
942: ROLLBACK to Insert_FormulaHeader_PUB;
943: x_return_status := FND_API.G_RET_STS_ERROR;
944: FND_MSG_PUB.Count_And_Get (
945: p_count => x_msg_count,
946: p_data => x_msg_data );
947: IF (l_debug = 'Y') THEN
948: gmd_debug.put_line(' In Formula Header Pub - In Error Exception Section '

Line 955: FND_MSG_PUB.Count_And_Get (

951: END IF;
952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
953: ROLLBACK to Insert_FormulaHeader_PUB;
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955: FND_MSG_PUB.Count_And_Get (
956: p_count => x_msg_count,
957: p_data => x_msg_data );
958: IF (l_debug = 'Y') THEN
959: gmd_debug.put_line(' In Formula Header Pub - In unexpected Exception Section '

Line 966: FND_MSG_PUB.Count_And_Get (

962: END IF;
963: WHEN RECIPE_GENERATE_ERROR THEN
964: ROLLBACK to Insert_FormulaHeader_PUB;
965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
966: FND_MSG_PUB.Count_And_Get (
967: p_count => x_msg_count,
968: p_data => x_msg_data );
969: IF (l_debug = 'Y') THEN
970: gmd_debug.put_line(' In Formula Header Pub - In Recipe Generate Exception Section '

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

972: ||x_return_status);
973: END IF;
974: WHEN OTHERS THEN
975: ROLLBACK to Insert_FormulaHeader_PUB;
976: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: FND_MSG_PUB.Count_And_Get (
979: p_count => x_msg_count,
980: p_data => x_msg_data );

Line 978: FND_MSG_PUB.Count_And_Get (

974: WHEN OTHERS THEN
975: ROLLBACK to Insert_FormulaHeader_PUB;
976: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: FND_MSG_PUB.Count_And_Get (
979: p_count => x_msg_count,
980: p_data => x_msg_data );
981: IF (l_debug = 'Y') THEN
982: gmd_debug.put_line(' In Formula Header Pub - In Others Exception Section '

Line 1092: FND_MSG_PUB.initialize;

1088: END IF;
1089:
1090: /* Initialize message list if p_init_msg_list is set to TRUE */
1091: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1092: FND_MSG_PUB.initialize;
1093: END IF;
1094:
1095: /* Start looping through the table */
1096: IF (p_formula_header_tbl.count = 0) THEN

Line 1120: FND_MSG_PUB.Add;

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

Line 1139: FND_MSG_PUB.Add;

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

Line 1143: FND_MSG_PUB.Add;

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

Line 1147: FND_MSG_PUB.Add;

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

Line 1240: FND_MSG_PUB.Add;

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

Line 1252: FND_MSG_PUB.Add;

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

Line 1272: FND_MSG_PUB.Add;

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

Line 1292: FND_MSG_PUB.Add;

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

Line 1309: FND_MSG_PUB.Add;

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

Line 1315: FND_MSG_PUB.Add;

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

Line 1322: FND_MSG_PUB.Add;

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

Line 1342: FND_MSG_PUB.Add;

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

Line 1658: FND_MSG_PUB.Add;

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

Line 1779: FND_MSG_PUB.Count_And_Get (

1775: END IF;
1776: END IF;
1777:
1778: /* Get the message count and information */
1779: FND_MSG_PUB.Count_And_Get (
1780: p_count => x_msg_count,
1781: p_data => x_msg_data );
1782:
1783: EXCEPTION

Line 1787: FND_MSG_PUB.Count_And_Get (

1783: EXCEPTION
1784: WHEN FND_API.G_EXC_ERROR THEN
1785: ROLLBACK to Update_FormulaHeader_PUB;
1786: x_return_status := FND_API.G_RET_STS_ERROR;
1787: FND_MSG_PUB.Count_And_Get (
1788: p_count => x_msg_count,
1789: p_data => x_msg_data );
1790: IF (l_debug = 'Y') THEN
1791: gmd_debug.put_line(' In Formula Header Pub - In Error Exception Section '

Line 1798: FND_MSG_PUB.Count_And_Get (

1794: END IF;
1795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1796: ROLLBACK to Update_FormulaHeader_PUB;
1797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1798: FND_MSG_PUB.Count_And_Get (
1799: p_count => x_msg_count,
1800: p_data => x_msg_data );
1801: IF (l_debug = 'Y') THEN
1802: gmd_debug.put_line(' In Formula Header Pub - In unexpected Exception Section '

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

1804: ||x_return_status);
1805: END IF;
1806: WHEN OTHERS THEN
1807: ROLLBACK to Update_FormulaHeader_PUB;
1808: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1810: FND_MSG_PUB.Count_And_Get (
1811: p_count => x_msg_count,
1812: p_data => x_msg_data );

Line 1810: FND_MSG_PUB.Count_And_Get (

1806: WHEN OTHERS THEN
1807: ROLLBACK to Update_FormulaHeader_PUB;
1808: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1810: FND_MSG_PUB.Count_And_Get (
1811: p_count => x_msg_count,
1812: p_data => x_msg_data );
1813: IF (l_debug = 'Y') THEN
1814: gmd_debug.put_line(' In Formula Header Pub - In OTHERs Exception Section '

Line 1874: FND_MSG_PUB.initialize;

1870: END IF;
1871:
1872: /* Initialize message list if p_init_msg_list is set to TRUE */
1873: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1874: FND_MSG_PUB.initialize;
1875: END IF;
1876: /* Initialize API return status to success */
1877: x_return_status := FND_API.G_RET_STS_SUCCESS;
1878:

Line 1894: FND_MSG_PUB.Add;

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

Line 1907: FND_MSG_PUB.Add;

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

Line 1923: FND_MSG_PUB.Add;

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

Line 1927: FND_MSG_PUB.Add;

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

Line 1931: FND_MSG_PUB.Add;

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

Line 1946: FND_MSG_PUB.Add;

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

Line 2043: FND_MSG_PUB.Count_And_Get (

2039: END IF;
2040: END IF;
2041:
2042: /* Get the message count and information */
2043: FND_MSG_PUB.Count_And_Get (
2044: p_count => x_msg_count,
2045: p_data => x_msg_data );
2046:
2047: EXCEPTION

Line 2051: FND_MSG_PUB.Count_And_Get (

2047: EXCEPTION
2048: WHEN FND_API.G_EXC_ERROR THEN
2049: ROLLBACK to Delete_FormulaHeader_PUB;
2050: x_return_status := FND_API.G_RET_STS_ERROR;
2051: FND_MSG_PUB.Count_And_Get (
2052: p_count => x_msg_count,
2053: p_data => x_msg_data );
2054:
2055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2058: FND_MSG_PUB.Count_And_Get (

2054:
2055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2056: ROLLBACK to Delete_FormulaHeader_PUB;
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: FND_MSG_PUB.Count_And_Get (
2059: p_count => x_msg_count,
2060: p_data => x_msg_data );
2061:
2062: WHEN OTHERS THEN

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

2060: p_data => x_msg_data );
2061:
2062: WHEN OTHERS THEN
2063: ROLLBACK to Delete_FormulaHeader_PUB;
2064: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066: FND_MSG_PUB.Count_And_Get (
2067: p_count => x_msg_count,
2068: p_data => x_msg_data );

Line 2066: FND_MSG_PUB.Count_And_Get (

2062: WHEN OTHERS THEN
2063: ROLLBACK to Delete_FormulaHeader_PUB;
2064: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066: FND_MSG_PUB.Count_And_Get (
2067: p_count => x_msg_count,
2068: p_data => x_msg_data );
2069:
2070: END Delete_FormulaHeader;