DBA Data[Home] [Help]

APPS.GMD_VALIDITY_RULES dependencies on FND_MSG_PUB

Line 244: FND_MSG_PUB.initialize;

240: l_api_name, G_PKG_NAME)) THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: END IF;
243: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
244: FND_MSG_PUB.initialize;
245: END IF;
246: X_return_status := FND_API.G_RET_STS_SUCCESS;
247:
248: /* Bug No.6346013 - Start */

Line 313: FND_MSG_PUB.add;

309: /*the validity rules are being fetched based on total ouput then this should */
310: /*be raised as an error */
311: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERR_CALC_OUTPUT');
312: FND_MESSAGE.SET_TOKEN('UOM', l_uom);
313: FND_MSG_PUB.add;
314: RAISE GET_TOTAL_QTY_ERR;
315: ELSIF (p_total_input IS NOT NULL) AND
316: (l_formula_input IS NULL) THEN
317: /*This implies that the system cannot calculate the total input qty and */

Line 322: FND_MSG_PUB.add;

318: /*the validity rules are being fetched based on total input then this should */
319: /*be raised as an error */
320: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERR_CALC_INPUT');
321: FND_MESSAGE.SET_TOKEN('UOM', l_uom);
322: FND_MSG_PUB.add;
323: RAISE GET_TOTAL_QTY_ERR;
324: END IF;
325: END IF;
326:

Line 731: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

727: X_return_status := Fnd_api.G_ret_sts_success;
728: END IF;
729:
730: -- standard call to get msge cnt, and if cnt is 1, get mesg info
731: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
732: EXCEPTION
733: WHEN NO_YIELD_TYPE_UM THEN
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALE_BAD_YIELD_TYPE');

Line 736: FND_MSG_PUB.ADD;

732: EXCEPTION
733: WHEN NO_YIELD_TYPE_UM THEN
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALE_BAD_YIELD_TYPE');
736: FND_MSG_PUB.ADD;
737: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
738: P_data => x_msg_data);
739: WHEN GET_FORMULA_COST_ERR THEN
740: x_return_status := FND_API.G_RET_STS_ERROR;

Line 737: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

733: WHEN NO_YIELD_TYPE_UM THEN
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALE_BAD_YIELD_TYPE');
736: FND_MSG_PUB.ADD;
737: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
738: P_data => x_msg_data);
739: WHEN GET_FORMULA_COST_ERR THEN
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

Line 741: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

737: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
738: P_data => x_msg_data);
739: WHEN GET_FORMULA_COST_ERR THEN
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
742: P_data => x_msg_data);
743: WHEN GET_FORMULA_ERR THEN
744: x_return_status := FND_API.G_RET_STS_ERROR;
745: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

Line 745: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

741: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
742: P_data => x_msg_data);
743: WHEN GET_FORMULA_ERR THEN
744: x_return_status := FND_API.G_RET_STS_ERROR;
745: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
746: P_data => x_msg_data);
747: WHEN GET_TOTAL_QTY_ERR OR GET_OUTPUT_RATIO_ERR
748: OR GET_INGREDPROD_RATIO_ERR OR GET_BATCHFORMULA_RATIO_ERR
749: OR GET_CONTRIBUTING_QTY_ERR OR GET_INPUT_RATIO_ERR THEN

Line 751: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

747: WHEN GET_TOTAL_QTY_ERR OR GET_OUTPUT_RATIO_ERR
748: OR GET_INGREDPROD_RATIO_ERR OR GET_BATCHFORMULA_RATIO_ERR
749: OR GET_CONTRIBUTING_QTY_ERR OR GET_INPUT_RATIO_ERR THEN
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
752: P_data => x_msg_data);
753: WHEN UOM_CONVERSION_ERROR THEN
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: gmd_validity_rules.uom_conversion_mesg(p_item_id => p_item_id,

Line 758: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

754: x_return_status := FND_API.G_RET_STS_ERROR;
755: gmd_validity_rules.uom_conversion_mesg(p_item_id => p_item_id,
756: p_from_um => p_uom,
757: p_to_um => l_item_uom);
758: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
759: P_data => x_msg_data);
760:
761: WHEN FND_API.G_EXC_ERROR THEN
762: X_return_code := SQLCODE;

Line 764: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

760:
761: WHEN FND_API.G_EXC_ERROR THEN
762: X_return_code := SQLCODE;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
767: X_return_code := SQLCODE;
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 769: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
767: X_return_code := SQLCODE;
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
770:
771: WHEN OTHERS THEN
772: X_return_code := SQLCODE;
773: x_return_status := FND_API.G_RET_STS_ERROR;

Line 774: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

770:
771: WHEN OTHERS THEN
772: X_return_code := SQLCODE;
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
775: END get_validity_rules;
776:
777: /*======================================================================
778: -- PROCEDURE :

Line 1221: FND_MSG_PUB.ADD;

1217: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1218: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
1219: FND_MESSAGE.SET_TOKEN('FROM_UOM', p_from_um);
1220: FND_MESSAGE.SET_TOKEN('TO_UOM', p_to_um);
1221: FND_MSG_PUB.ADD;
1222: END uom_conversion_mesg;
1223:
1224:
1225: /*======================================================================

Line 1323: Fnd_msg_pub.Initialize;

1319: END IF;
1320:
1321: IF (Fnd_api.To_boolean (P_init_msg_list))
1322: THEN
1323: Fnd_msg_pub.Initialize;
1324: END IF;
1325:
1326: X_return_status := Fnd_api.G_ret_sts_success;
1327:

Line 1449: Fnd_msg_pub.Count_and_get (P_count => X_msg_count, P_data => X_msg_data);

1445: x_recipe_validity_out(i).total_cost := l_rec.total_cost ;
1446: END LOOP;
1447:
1448: -- standard call to get msge cnt, and if cnt is 1, get mesg info
1449: Fnd_msg_pub.Count_and_get (P_count => X_msg_count, P_data => X_msg_data);
1450:
1451: EXCEPTION
1452: WHEN GET_FORMULA_COST_ERR THEN
1453: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1454: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

1450:
1451: EXCEPTION
1452: WHEN GET_FORMULA_COST_ERR THEN
1453: x_return_status := FND_API.G_RET_STS_ERROR;
1454: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
1455: P_data => x_msg_data);
1456: WHEN Fnd_api.G_exc_error THEN
1457: X_return_code := SQLCODE;
1458: X_return_status := Fnd_api.G_ret_sts_error;

Line 1459: Fnd_msg_pub.Count_and_get ( P_count=> X_msg_count,

1455: P_data => x_msg_data);
1456: WHEN Fnd_api.G_exc_error THEN
1457: X_return_code := SQLCODE;
1458: X_return_status := Fnd_api.G_ret_sts_error;
1459: Fnd_msg_pub.Count_and_get ( P_count=> X_msg_count,
1460: P_data=> X_msg_data );
1461: WHEN Fnd_api.G_exc_unexpected_error THEN
1462: X_return_code := SQLCODE;
1463: X_return_status := Fnd_api.G_ret_sts_unexp_error;

Line 1464: Fnd_msg_pub.Count_and_get ( P_count=> X_msg_count,

1460: P_data=> X_msg_data );
1461: WHEN Fnd_api.G_exc_unexpected_error THEN
1462: X_return_code := SQLCODE;
1463: X_return_status := Fnd_api.G_ret_sts_unexp_error;
1464: Fnd_msg_pub.Count_and_get ( P_count=> X_msg_count,
1465: P_data=> X_msg_data );
1466: WHEN OTHERS THEN
1467: X_return_code := SQLCODE;
1468: X_return_status := Fnd_api.G_ret_sts_error;

Line 1469: Fnd_msg_pub.Count_and_get ( P_count=> X_msg_count,

1465: P_data=> X_msg_data );
1466: WHEN OTHERS THEN
1467: X_return_code := SQLCODE;
1468: X_return_status := Fnd_api.G_ret_sts_error;
1469: Fnd_msg_pub.Count_and_get ( P_count=> X_msg_count,
1470: P_data=> X_msg_data );
1471: END Get_all_validity_rules;
1472:
1473: /*======================================================================

Line 1556: fnd_msg_pub.add_exc_msg ('GMD_VALIDITY_RULES', 'GET_VALIDITY_SCALE_FACTOR');

1552: x_return_status := FND_API.g_ret_sts_error;
1553: uom_conversion_mesg (p_item_id, l_prod_rec.detail_uom, p_std_um);
1554: WHEN OTHERS THEN
1555: x_return_status := FND_API.g_ret_sts_unexp_error;
1556: fnd_msg_pub.add_exc_msg ('GMD_VALIDITY_RULES', 'GET_VALIDITY_SCALE_FACTOR');
1557: END get_validity_scale_factor;
1558:
1559: /*======================================================================
1560: -- PROCEDURE :

Line 1650: fnd_msg_pub.add_exc_msg ('GMD_VALIDITY_RULES', 'GET_VALIDITY_OUTPUT_FACTOR');

1646: END IF;
1647: EXCEPTION
1648: WHEN OTHERS THEN
1649: x_return_status := FND_API.g_ret_sts_unexp_error;
1650: fnd_msg_pub.add_exc_msg ('GMD_VALIDITY_RULES', 'GET_VALIDITY_OUTPUT_FACTOR');
1651: END get_validity_output_factor;
1652:
1653: /*=================================================================================
1654: -- PROCEDURE :