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_FETCH_VALIDITY_RULES dependencies on GMD_FETCH_VALIDITY_RULES

Line 1: PACKAGE BODY gmd_fetch_validity_rules AS

1: PACKAGE BODY gmd_fetch_validity_rules AS
2: /* $Header: GMDPVRFB.pls 120.3 2006/11/21 16:43:54 txdaniel ship $ */
3:
4: G_PKG_NAME VARCHAR2(32);
5:

Line 193: gmd_fetch_validity_rules.get_output_ratio(p_formula_id => l_formula_id,

189: END IF;
190:
191: /* Try to get validity rules based on recipe ID and total output qty */
192: /* Get the ratio of the batch output qty to the ratio of the formula ouput qty */
193: gmd_fetch_validity_rules.get_output_ratio(p_formula_id => l_formula_id,
194: p_batch_output => l_total_output,
195: p_yield_um => l_yield_um,
196: p_formula_output => l_formula_output,
197: x_return_status => l_return_status,

Line 220: gmd_fetch_validity_rules.get_ingredprod_ratio(p_formula_id => l_formula_id,

216: l_total_input := p_total_input;
217: END IF;
218:
219: /* Get the product to ingredient ratio for the formula */
220: gmd_fetch_validity_rules.get_ingredprod_ratio(p_formula_id => l_formula_id,
221: p_yield_um => l_yield_um,
222: x_return_status => l_return_status,
223: X_ingred_prod_ratio => l_ingred_prod_ratio);
224: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 228: gmd_fetch_validity_rules.get_batchformula_ratio(p_formula_id => l_formula_id,

224: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
225: RAISE GET_INGREDPROD_RATIO_ERR;
226: END IF;
227: /* Get the ratio of the batch input to the formula input */
228: gmd_fetch_validity_rules.get_batchformula_ratio(p_formula_id => l_formula_id,
229: p_batch_input => l_total_input,
230: p_yield_um => l_yield_um,
231: p_formula_input => l_formula_input,
232: x_return_status => l_return_status,

Line 239: gmd_fetch_validity_rules.get_contributing_qty(p_formula_id => l_formula_id,

235: RAISE GET_BATCHFORMULA_RATIO_ERR;
236: END IF;
237:
238: /* Get the contributing qty of the formula */
239: gmd_fetch_validity_rules.get_contributing_qty(p_formula_id => l_formula_id,
240: p_recipe_id => p_recipe_id,
241: p_batchformula_ratio => l_batchformula_ratio,
242: p_yield_um => l_yield_um,
243: x_return_status => l_return_status,

Line 252: gmd_fetch_validity_rules.get_input_ratio(p_formula_id => l_formula_id,

248: /* Calculate actual contributing qty of formula */
249: l_contributing_qty := l_contributing_qty * l_ingred_prod_ratio;
250:
251: /* Get the ratio of the product based on contributing qty */
252: gmd_fetch_validity_rules.get_input_ratio(p_formula_id => l_formula_id,
253: p_contributing_qty => l_contributing_qty,
254: p_yield_um => l_yield_um,
255: p_formula_output => l_formula_output,
256: x_return_status => l_return_status,

Line 390: gmd_fetch_validity_rules.uom_conversion_mesg(p_item_id => p_item_id,

386: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
387: P_data => x_msg_data);
388: WHEN UOM_CONVERSION_ERROR THEN
389: x_return_status := FND_API.G_RET_STS_ERROR;
390: gmd_fetch_validity_rules.uom_conversion_mesg(p_item_id => p_item_id,
391: p_from_um => p_uom,
392: p_to_um => l_item_uom);
393: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
394: P_data => x_msg_data);

Line 477: gmd_fetch_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,

473: X_output_ratio := l_batch_output/l_formula_output;
474: EXCEPTION
475: WHEN UOM_CONVERSION_ERROR THEN
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: gmd_fetch_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,
478: p_from_um => X_item_um,
479: p_to_um => p_yield_um);
480: END get_output_ratio;
481:

Line 562: gmd_fetch_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,

558: X_ingred_prod_ratio := l_sum_prods/l_sum_ingreds;
559: EXCEPTION
560: WHEN UOM_CONVERSION_ERROR THEN
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: gmd_fetch_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,
563: p_from_um => X_item_um,
564: p_to_um => p_yield_um);
565: END get_ingredprod_ratio;
566:

Line 635: gmd_fetch_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,

631: X_batchformula_ratio := l_batch_input / l_formula_input;
632: EXCEPTION
633: WHEN UOM_CONVERSION_ERROR THEN
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: gmd_fetch_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,
636: p_from_um => X_item_um,
637: p_to_um => p_yield_um);
638: END get_batchformula_ratio;
639:

Line 729: gmd_fetch_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,

725: X_contributing_qty := X_contributing_qty * (100 - l_process_loss);
726: EXCEPTION
727: WHEN UOM_CONVERSION_ERROR THEN
728: x_return_status := FND_API.G_RET_STS_ERROR;
729: gmd_fetch_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,
730: p_from_um => X_item_um,
731: p_to_um => p_yield_um);
732: END get_contributing_qty;
733:

Line 795: gmd_fetch_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,

791: X_output_ratio := l_contributing_qty / l_formula_output;
792: EXCEPTION
793: WHEN UOM_CONVERSION_ERROR THEN
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: gmd_fetch_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,
796: p_from_um => X_item_um,
797: p_to_um => p_yield_um);
798: END get_input_ratio;
799:

Line 833: END gmd_fetch_validity_rules;

829: FND_MESSAGE.SET_TOKEN('TO_UOM', p_to_um);
830: FND_MSG_PUB.ADD;
831: END uom_conversion_mesg;
832:
833: END gmd_fetch_validity_rules;