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.13.12000000.2 2007/09/26 09:08:11 kannavar ship $ */
3:
4: G_PKG_NAME VARCHAR2(32);
5: G_default_cost_mthd VARCHAR2(20);

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

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

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

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

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

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

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

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

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

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

Line 434: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id

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

Line 446: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec

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

Line 527: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id

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

Line 540: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec

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

Line 617: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id

613: -- Select validity rule only if qty. is greater than min qty and lesser than max qty of validity rule.
614: 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
615:
616: IF p_least_cost_validity = 'T' THEN
617: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id
618: ,p_requested_qty => l_quantity
619: ,p_requested_uom => get_rec.detail_uom
620: ,p_product_id => get_rec.inventory_item_id
621: ,p_organization_id => p_organization_id

Line 630: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec

626: RAISE GET_FORMULA_COST_ERR;
627: END IF;
628: END IF; /* IF p_least_cost_validity = 'T' */
629:
630: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec
631: ,p_unit_cost => l_unit_cost
632: ,p_total_cost => l_total_cost);
633:
634: END IF; /* IF (l_quantity >= get_rec.min_qty AND l_quantity <= get_rec.max_qty) */

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

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

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

822:
823: EXCEPTION
824: WHEN UOM_CONVERSION_ERROR THEN
825: x_return_status := FND_API.G_RET_STS_ERROR;
826: gmd_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,
827: p_from_um => X_detail_uom,
828: p_to_um => p_yield_um);
829: END get_output_ratio;
830:

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

915: X_ingred_prod_ratio := l_sum_prods/l_sum_ingreds;
916: EXCEPTION
917: WHEN UOM_CONVERSION_ERROR THEN
918: x_return_status := FND_API.G_RET_STS_ERROR;
919: gmd_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,
920: p_from_um => X_detail_uom,
921: p_to_um => p_yield_um);
922: END get_ingredprod_ratio;
923:

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

992: X_batchformula_ratio := l_batch_input / l_formula_input;
993: EXCEPTION
994: WHEN UOM_CONVERSION_ERROR THEN
995: x_return_status := FND_API.G_RET_STS_ERROR;
996: gmd_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,
997: p_from_um => X_detail_uom,
998: p_to_um => p_yield_um);
999: END get_batchformula_ratio;
1000:

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

1088: X_contributing_qty := X_contributing_qty * (100 - NVL(l_process_loss,0))/100;
1089: EXCEPTION
1090: WHEN UOM_CONVERSION_ERROR THEN
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092: gmd_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,
1093: p_from_um => X_detail_uom,
1094: p_to_um => p_yield_um);
1095: END get_contributing_qty;
1096:

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

1158: X_output_ratio := l_contributing_qty / l_formula_output;
1159: EXCEPTION
1160: WHEN UOM_CONVERSION_ERROR THEN
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: gmd_validity_rules.uom_conversion_mesg(p_item_id => X_item_id,
1163: p_from_um => X_detail_uom,
1164: p_to_um => p_yield_um);
1165: END get_input_ratio;
1166:

Line 1318: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id

1314: OPEN Cur_get_form_id (get_rec.recipe_id, get_rec.inventory_item_id);
1315: FETCH Cur_get_form_id INTO l_formula_id, l_quantity, l_uom;
1316: CLOSE Cur_get_form_id;
1317: IF (get_rec.organization_id IS NOT NULL) THEN
1318: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id
1319: ,p_requested_qty => l_quantity
1320: ,p_requested_uom => l_uom
1321: ,p_product_id => get_rec.inventory_item_id
1322: ,p_organization_id => get_rec.organization_id

Line 1331: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec

1327: RAISE GET_FORMULA_COST_ERR;
1328: END IF;
1329: END IF;
1330: END IF; /* IF p_least_cost_validity = 'T' */
1331: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec
1332: ,p_unit_cost => l_unit_cost
1333: ,p_total_cost => l_total_cost);
1334: END LOOP;
1335: ELSE

Line 1345: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id

1341: OPEN Cur_get_form_id (get_rec.recipe_id, get_rec.inventory_item_id);
1342: FETCH Cur_get_form_id INTO l_formula_id, l_quantity, l_uom;
1343: CLOSE Cur_get_form_id;
1344: IF (get_rec.organization_id IS NOT NULL) THEN
1345: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id
1346: ,p_requested_qty => l_quantity
1347: ,p_requested_uom => l_uom
1348: ,p_product_id => get_rec.inventory_item_id
1349: ,p_organization_id => get_rec.organization_id

Line 1358: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec

1354: RAISE GET_FORMULA_COST_ERR;
1355: END IF;
1356: END IF;
1357: END IF; /* IF p_least_cost_validity = 'T' */
1358: GMD_VALIDITY_RULES.insert_val_temp_tbl(p_val_rec => get_rec
1359: ,p_unit_cost => l_unit_cost
1360: ,p_total_cost => l_total_cost);
1361: END LOOP;
1362: END IF;

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

1576: /* Let us initialize the return status to success */
1577: x_return_status := FND_API.g_ret_sts_success;
1578:
1579: /* Lets get the scale factor between the validity std qty and the formula product qty */
1580: gmd_validity_rules.get_validity_scale_factor (p_recipe_id => p_recipe_id
1581: ,p_item_id => p_item_id
1582: ,p_std_qty => p_std_qty
1583: ,p_std_um => p_std_um
1584: ,x_scale_factor => l_scale_factor

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 :

Line 1851: END GMD_VALIDITY_RULES;

1847: x_return_status := FND_API.G_RET_STS_ERROR;
1848: END Get_Formula_Cost;
1849:
1850:
1851: END GMD_VALIDITY_RULES;