DBA Data[Home] [Help]

APPS.GMD_VALIDITY_RULES dependencies on FND_MSG_PUB

Line 243: FND_MSG_PUB.initialize;

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

Line 312: FND_MSG_PUB.add;

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

Line 321: FND_MSG_PUB.add;

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

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

705: X_return_status := Fnd_api.G_ret_sts_success;
706: END IF;
707:
708: -- standard call to get msge cnt, and if cnt is 1, get mesg info
709: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
710: EXCEPTION
711: WHEN NO_YIELD_TYPE_UM THEN
712: x_return_status := FND_API.G_RET_STS_ERROR;
713: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALE_BAD_YIELD_TYPE');

Line 714: FND_MSG_PUB.ADD;

710: EXCEPTION
711: WHEN NO_YIELD_TYPE_UM THEN
712: x_return_status := FND_API.G_RET_STS_ERROR;
713: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALE_BAD_YIELD_TYPE');
714: FND_MSG_PUB.ADD;
715: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
716: P_data => x_msg_data);
717: WHEN GET_FORMULA_COST_ERR THEN
718: x_return_status := FND_API.G_RET_STS_ERROR;

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

711: WHEN NO_YIELD_TYPE_UM THEN
712: x_return_status := FND_API.G_RET_STS_ERROR;
713: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALE_BAD_YIELD_TYPE');
714: FND_MSG_PUB.ADD;
715: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
716: P_data => x_msg_data);
717: WHEN GET_FORMULA_COST_ERR THEN
718: x_return_status := FND_API.G_RET_STS_ERROR;
719: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

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

715: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
716: P_data => x_msg_data);
717: WHEN GET_FORMULA_COST_ERR THEN
718: x_return_status := FND_API.G_RET_STS_ERROR;
719: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
720: P_data => x_msg_data);
721: WHEN GET_FORMULA_ERR THEN
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

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

719: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
720: P_data => x_msg_data);
721: WHEN GET_FORMULA_ERR THEN
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
724: P_data => x_msg_data);
725: WHEN GET_TOTAL_QTY_ERR OR GET_OUTPUT_RATIO_ERR
726: OR GET_INGREDPROD_RATIO_ERR OR GET_BATCHFORMULA_RATIO_ERR
727: OR GET_CONTRIBUTING_QTY_ERR OR GET_INPUT_RATIO_ERR THEN

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

725: WHEN GET_TOTAL_QTY_ERR OR GET_OUTPUT_RATIO_ERR
726: OR GET_INGREDPROD_RATIO_ERR OR GET_BATCHFORMULA_RATIO_ERR
727: OR GET_CONTRIBUTING_QTY_ERR OR GET_INPUT_RATIO_ERR THEN
728: x_return_status := FND_API.G_RET_STS_ERROR;
729: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
730: P_data => x_msg_data);
731: WHEN UOM_CONVERSION_ERROR THEN
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: gmd_validity_rules.uom_conversion_mesg(p_item_id => p_item_id,

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

732: x_return_status := FND_API.G_RET_STS_ERROR;
733: gmd_validity_rules.uom_conversion_mesg(p_item_id => p_item_id,
734: p_from_um => p_uom,
735: p_to_um => l_item_uom);
736: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
737: P_data => x_msg_data);
738:
739: WHEN FND_API.G_EXC_ERROR THEN
740: X_return_code := SQLCODE;

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

738:
739: WHEN FND_API.G_EXC_ERROR THEN
740: X_return_code := SQLCODE;
741: x_return_status := FND_API.G_RET_STS_ERROR;
742: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
743:
744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
745: X_return_code := SQLCODE;
746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

743:
744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
745: X_return_code := SQLCODE;
746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
747: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
748:
749: WHEN OTHERS THEN
750: X_return_code := SQLCODE;
751: x_return_status := FND_API.G_RET_STS_ERROR;

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

748:
749: WHEN OTHERS THEN
750: X_return_code := SQLCODE;
751: x_return_status := FND_API.G_RET_STS_ERROR;
752: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
753: END get_validity_rules;
754:
755: /*======================================================================
756: -- PROCEDURE :

Line 1199: FND_MSG_PUB.ADD;

1195: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1196: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
1197: FND_MESSAGE.SET_TOKEN('FROM_UOM', p_from_um);
1198: FND_MESSAGE.SET_TOKEN('TO_UOM', p_to_um);
1199: FND_MSG_PUB.ADD;
1200: END uom_conversion_mesg;
1201:
1202:
1203: /*======================================================================

Line 1301: Fnd_msg_pub.Initialize;

1297: END IF;
1298:
1299: IF (Fnd_api.To_boolean (P_init_msg_list))
1300: THEN
1301: Fnd_msg_pub.Initialize;
1302: END IF;
1303:
1304: X_return_status := Fnd_api.G_ret_sts_success;
1305:

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

1423: x_recipe_validity_out(i).total_cost := l_rec.total_cost ;
1424: END LOOP;
1425:
1426: -- standard call to get msge cnt, and if cnt is 1, get mesg info
1427: Fnd_msg_pub.Count_and_get (P_count => X_msg_count, P_data => X_msg_data);
1428:
1429: EXCEPTION
1430: WHEN GET_FORMULA_COST_ERR THEN
1431: x_return_status := FND_API.G_RET_STS_ERROR;

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

1428:
1429: EXCEPTION
1430: WHEN GET_FORMULA_COST_ERR THEN
1431: x_return_status := FND_API.G_RET_STS_ERROR;
1432: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
1433: P_data => x_msg_data);
1434: WHEN Fnd_api.G_exc_error THEN
1435: X_return_code := SQLCODE;
1436: X_return_status := Fnd_api.G_ret_sts_error;

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

1433: P_data => x_msg_data);
1434: WHEN Fnd_api.G_exc_error THEN
1435: X_return_code := SQLCODE;
1436: X_return_status := Fnd_api.G_ret_sts_error;
1437: Fnd_msg_pub.Count_and_get ( P_count=> X_msg_count,
1438: P_data=> X_msg_data );
1439: WHEN Fnd_api.G_exc_unexpected_error THEN
1440: X_return_code := SQLCODE;
1441: X_return_status := Fnd_api.G_ret_sts_unexp_error;

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

1438: P_data=> X_msg_data );
1439: WHEN Fnd_api.G_exc_unexpected_error THEN
1440: X_return_code := SQLCODE;
1441: X_return_status := Fnd_api.G_ret_sts_unexp_error;
1442: Fnd_msg_pub.Count_and_get ( P_count=> X_msg_count,
1443: P_data=> X_msg_data );
1444: WHEN OTHERS THEN
1445: X_return_code := SQLCODE;
1446: X_return_status := Fnd_api.G_ret_sts_error;

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

1443: P_data=> X_msg_data );
1444: WHEN OTHERS THEN
1445: X_return_code := SQLCODE;
1446: X_return_status := Fnd_api.G_ret_sts_error;
1447: Fnd_msg_pub.Count_and_get ( P_count=> X_msg_count,
1448: P_data=> X_msg_data );
1449: END Get_all_validity_rules;
1450:
1451: /*======================================================================

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

1530: x_return_status := FND_API.g_ret_sts_error;
1531: uom_conversion_mesg (p_item_id, l_prod_rec.detail_uom, p_std_um);
1532: WHEN OTHERS THEN
1533: x_return_status := FND_API.g_ret_sts_unexp_error;
1534: fnd_msg_pub.add_exc_msg ('GMD_VALIDITY_RULES', 'GET_VALIDITY_SCALE_FACTOR');
1535: END get_validity_scale_factor;
1536:
1537: /*======================================================================
1538: -- PROCEDURE :

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

1624: END IF;
1625: EXCEPTION
1626: WHEN OTHERS THEN
1627: x_return_status := FND_API.g_ret_sts_unexp_error;
1628: fnd_msg_pub.add_exc_msg ('GMD_VALIDITY_RULES', 'GET_VALIDITY_OUTPUT_FACTOR');
1629: END get_validity_output_factor;
1630:
1631: /*=================================================================================
1632: -- PROCEDURE :