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_VALIDITY_RULES dependencies on GMD_VALIDITY_RULES

Line 1: PACKAGE BODY GMD_VALIDITY_RULES AS

1: PACKAGE BODY GMD_VALIDITY_RULES AS
2: /* $Header: GMDPRVRB.pls 120.16 2010/07/01 15:36:59 rnalla ship $ */
3:
4: G_PKG_NAME VARCHAR2(32);
5: G_default_cost_mthd VARCHAR2(20);

Line 332: gmd_validity_rules.get_output_ratio(p_formula_id => l_formula_id,

328: IF (p_total_output IS NOT NULL) THEN
329:
330: /* Try to get validity rules based on recipe ID and total output qty */
331: /* Get the ratio of the batch output qty to the ratio of the formula ouput qty */
332: gmd_validity_rules.get_output_ratio(p_formula_id => l_formula_id,
333: p_batch_output => p_total_output,
334: p_yield_um => l_uom,
335: p_formula_output => l_formula_output,
336: x_return_status => l_return_status,

Line 344: gmd_validity_rules.get_ingredprod_ratio(p_formula_id => l_formula_id,

340: END IF;
341: ELSIF (p_total_input IS NOT NULL) THEN
342:
343: /* Get the product to ingredient ratio for the formula */
344: gmd_validity_rules.get_ingredprod_ratio(p_formula_id => l_formula_id,
345: p_yield_um => l_uom,
346: x_return_status => l_return_status,
347: X_ingred_prod_ratio => l_ingred_prod_ratio);
348: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 352: gmd_validity_rules.get_batchformula_ratio(p_formula_id => l_formula_id,

348: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
349: RAISE GET_INGREDPROD_RATIO_ERR;
350: END IF;
351: /* Get the ratio of the batch input to the formula input */
352: gmd_validity_rules.get_batchformula_ratio(p_formula_id => l_formula_id,
353: p_batch_input => p_total_input,
354: p_yield_um => l_uom,
355: p_formula_input => l_formula_input,
356: x_return_status => l_return_status,

Line 363: gmd_validity_rules.get_contributing_qty(p_formula_id => l_formula_id,

359: RAISE GET_BATCHFORMULA_RATIO_ERR;
360: END IF;
361:
362: /* Get the contributing qty of the formula */
363: gmd_validity_rules.get_contributing_qty(p_formula_id => l_formula_id,
364: p_recipe_id => l_recipe_id,
365: p_batchformula_ratio => l_batchformula_ratio,
366: p_yield_um => l_uom,
367: x_return_status => l_return_status,

Line 376: gmd_validity_rules.get_input_ratio(p_formula_id => l_formula_id,

372: /* Calculate actual contributing qty of formula */
373: l_contributing_qty := l_contributing_qty * l_ingred_prod_ratio;
374:
375: /* Get the ratio of the product based on contributing qty */
376: gmd_validity_rules.get_input_ratio(p_formula_id => l_formula_id,
377: p_contributing_qty => l_contributing_qty,
378: p_yield_um => l_uom,
379: p_formula_output => l_formula_input,
380: x_return_status => l_return_status,

Line 435: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id

431: /* gmicuom.icuomcv(get_rec.item_id, 0, l_item_qty, l_line_um, get_rec.item_um, l_item_qty); */
432: END IF;
433: IF (l_item_qty >= get_rec.min_qty AND l_item_qty <= get_rec.max_qty) THEN
434: IF p_least_cost_validity = 'T' THEN
435: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id
436: ,p_requested_qty => l_item_qty
437: ,p_requested_uom => get_rec.detail_uom
438: ,p_product_id => get_rec.inventory_item_id
439: ,p_organization_id => p_organization_id

Line 447: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec

443: IF l_return_status <> FND_API.g_ret_sts_success THEN
444: RAISE GET_FORMULA_COST_ERR;
445: END IF;
446: END IF; /* IF p_least_cost_validity = 'T' */
447: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec
448: ,p_unit_cost => l_unit_cost
449: ,p_total_cost => l_total_cost);
450: END IF; /* IF (l_item_qty >= get_rec.min_qty AND l_item_qty <= get_rec.max_qty) */
451: END IF; /* IF (l_scale_type = 1) */

Line 528: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id

524: END IF;
525: -- End NPD Conv.
526:
527: IF p_least_cost_validity = 'T' THEN
528: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id
529: ,p_requested_qty => l_quantity
530: ,p_requested_uom => l_item_uom
531: ,p_product_id => get_rec.inventory_item_id
532: ,p_organization_id => p_organization_id

Line 541: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec

537: RAISE GET_FORMULA_COST_ERR;
538: END IF;
539: END IF; /* IF p_least_cost_validity = 'T' */
540:
541: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec
542: ,p_unit_cost => l_unit_cost
543: ,p_total_cost => l_total_cost);
544: EXCEPTION
545: WHEN ITEM_ORGN_MISSING THEN

Line 639: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id

635: -- Select validity rule only if qty. is greater than min qty and lesser than max qty of validity rule.
636: IF (l_quantity >= get_rec.inv_min_qty AND l_quantity <= get_rec.inv_max_qty) THEN -- Bug #5211935 inv_min_qty , inv_max_qty instead of min_qty, max_qty
637:
638: IF p_least_cost_validity = 'T' THEN
639: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id
640: ,p_requested_qty => l_quantity
641: ,p_requested_uom => get_rec.detail_uom
642: ,p_product_id => get_rec.inventory_item_id
643: ,p_organization_id => p_organization_id

Line 652: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec

648: RAISE GET_FORMULA_COST_ERR;
649: END IF;
650: END IF; /* IF p_least_cost_validity = 'T' */
651:
652: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec
653: ,p_unit_cost => l_unit_cost
654: ,p_total_cost => l_total_cost);
655:
656: END IF; /* IF (l_quantity >= get_rec.min_qty AND l_quantity <= get_rec.max_qty) */

Line 755: gmd_validity_rules.uom_conversion_mesg(p_item_id => p_item_id,

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,
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);

Line 848: gmd_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,

844:
845: EXCEPTION
846: WHEN UOM_CONVERSION_ERROR THEN
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: gmd_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,
849: p_from_um => X_detail_uom,
850: p_to_um => p_yield_um);
851: END get_output_ratio;
852:

Line 941: gmd_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,

937: X_ingred_prod_ratio := l_sum_prods/l_sum_ingreds;
938: EXCEPTION
939: WHEN UOM_CONVERSION_ERROR THEN
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: gmd_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,
942: p_from_um => X_detail_uom,
943: p_to_um => p_yield_um);
944: END get_ingredprod_ratio;
945:

Line 1018: gmd_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,

1014: X_batchformula_ratio := l_batch_input / l_formula_input;
1015: EXCEPTION
1016: WHEN UOM_CONVERSION_ERROR THEN
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018: gmd_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,
1019: p_from_um => X_detail_uom,
1020: p_to_um => p_yield_um);
1021: END get_batchformula_ratio;
1022:

Line 1114: gmd_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,

1110: X_contributing_qty := X_contributing_qty * (100 - NVL(l_process_loss,0))/100;
1111: EXCEPTION
1112: WHEN UOM_CONVERSION_ERROR THEN
1113: x_return_status := FND_API.G_RET_STS_ERROR;
1114: gmd_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,
1115: p_from_um => X_detail_uom,
1116: p_to_um => p_yield_um);
1117: END get_contributing_qty;
1118:

Line 1184: gmd_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,

1180: X_output_ratio := l_contributing_qty / l_formula_output;
1181: EXCEPTION
1182: WHEN UOM_CONVERSION_ERROR THEN
1183: x_return_status := FND_API.G_RET_STS_ERROR;
1184: gmd_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,
1185: p_from_um => X_detail_uom,
1186: p_to_um => p_yield_um);
1187: END get_input_ratio;
1188:

Line 1340: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id

1336: OPEN Cur_get_form_id (get_rec.recipe_id, get_rec.inventory_item_id);
1337: FETCH Cur_get_form_id INTO l_formula_id, l_quantity, l_uom;
1338: CLOSE Cur_get_form_id;
1339: IF (get_rec.organization_id IS NOT NULL) THEN
1340: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id
1341: ,p_requested_qty => l_quantity
1342: ,p_requested_uom => l_uom
1343: ,p_product_id => get_rec.inventory_item_id
1344: ,p_organization_id => get_rec.organization_id

Line 1353: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec

1349: RAISE GET_FORMULA_COST_ERR;
1350: END IF;
1351: END IF;
1352: END IF; /* IF p_least_cost_validity = 'T' */
1353: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec
1354: ,p_unit_cost => l_unit_cost
1355: ,p_total_cost => l_total_cost);
1356: END LOOP;
1357: ELSE

Line 1367: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id

1363: OPEN Cur_get_form_id (get_rec.recipe_id, get_rec.inventory_item_id);
1364: FETCH Cur_get_form_id INTO l_formula_id, l_quantity, l_uom;
1365: CLOSE Cur_get_form_id;
1366: IF (get_rec.organization_id IS NOT NULL) THEN
1367: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id
1368: ,p_requested_qty => l_quantity
1369: ,p_requested_uom => l_uom
1370: ,p_product_id => get_rec.inventory_item_id
1371: ,p_organization_id => get_rec.organization_id

Line 1380: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec

1376: RAISE GET_FORMULA_COST_ERR;
1377: END IF;
1378: END IF;
1379: END IF; /* IF p_least_cost_validity = 'T' */
1380: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec
1381: ,p_unit_cost => l_unit_cost
1382: ,p_total_cost => l_total_cost);
1383: END LOOP;
1384: END IF;

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 1602: gmd_validity_rules.get_validity_scale_factor (p_recipe_id => p_recipe_id

1598: /* Let us initialize the return status to success */
1599: x_return_status := FND_API.g_ret_sts_success;
1600:
1601: /* Lets get the scale factor between the validity std qty and the formula product qty */
1602: gmd_validity_rules.get_validity_scale_factor (p_recipe_id => p_recipe_id
1603: ,p_item_id => p_item_id
1604: ,p_std_qty => p_std_qty
1605: ,p_std_um => p_std_um
1606: ,x_scale_factor => l_scale_factor

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 :

Line 1873: END GMD_VALIDITY_RULES;

1869: x_return_status := FND_API.G_RET_STS_ERROR;
1870: END Get_Formula_Cost;
1871:
1872:
1873: END GMD_VALIDITY_RULES;