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_LCF_FETCH_PKG dependencies on GMD_LCF_FETCH_PKG

Line 1: PACKAGE BODY GMD_LCF_FETCH_PKG AS

1: PACKAGE BODY GMD_LCF_FETCH_PKG AS
2: /* $Header: GMDLCFMB.pls 120.15 2006/10/11 19:20:33 rajreddy noship $ */
3:
4: /*##############################################################
5: # NAME

Line 109: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Rollup_Wt_Pct');

105: END IF;
106:
107: EXCEPTION
108: WHEN OTHERS THEN
109: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Rollup_Wt_Pct');
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: END rollup_wt_pct;
112:
113: /*##############################################################

Line 175: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Rollup_Vol_Pct');

171: X_return_status := FND_API.g_ret_sts_error;
172: END IF;
173: EXCEPTION
174: WHEN OTHERS THEN
175: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Rollup_Vol_Pct');
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: END rollup_vol_pct;
178:
179: /*##############################################################

Line 326: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Update_Line_Mass_Vol_Qty');

322: EXCEPTION
323: WHEN line_not_found THEN
324: X_return_status := FND_API.g_ret_sts_error;
325: WHEN OTHERS THEN
326: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Update_Line_Mass_Vol_Qty');
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328: END update_line_mass_vol_qty;
329:
330: /*##############################################################

Line 430: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Load_cost_Values');

426: END IF;
427: END IF;
428: EXCEPTION
429: WHEN OTHERS THEN
430: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Load_cost_Values');
431: END load_cost_values;
432:
433: /*##############################################################
434: # NAME

Line 557: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Load_Tech_Values');

553: AND a.inventory_item_id = c.inventory_item_id;
554: END IF;
555: EXCEPTION
556: WHEN OTHERS THEN
557: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Load_Tech_Values');
558: END load_tech_values;
559:
560: /*##############################################################
561: # NAME

Line 663: gmd_lcf_fetch_pkg.get_category_value (V_inventory_item_id => l_simulation_rec.inventory_item_id,

659: l_simulation_rec.inventory_item_id,l_simulation_rec.item,l_new_qty,
660: l_simulation_rec.description,l_simulation_rec.detail_uom,l_simulation_rec.detail_uom,
661: l_simulation_rec.created_by,l_simulation_rec.creation_date,
662: l_simulation_rec.last_updated_by,l_simulation_rec.last_update_date);
663: gmd_lcf_fetch_pkg.get_category_value (V_inventory_item_id => l_simulation_rec.inventory_item_id,
664: V_organization_id => V_organization_id,
665: V_line_id => l_simulation_rec.line_id);
666: END LOOP;
667: CLOSE Cur_get_sim_material;

Line 703: gmd_lcf_fetch_pkg.get_category_value (V_inventory_item_id => l_formula_rec.inventory_item_id,

699: (1,l_line_id,-1,l_formula_rec.line_no,0,l_formula_rec.inventory_item_id,l_formula_rec.concatenated_segments,
700: l_new_qty,l_formula_rec.description,l_formula_rec.primary_uom_code,l_formula_rec.primary_uom_code,
701: l_formula_rec.created_by,l_formula_rec.creation_date,
702: l_formula_rec.last_updated_by,l_formula_rec.last_update_date);
703: gmd_lcf_fetch_pkg.get_category_value (V_inventory_item_id => l_formula_rec.inventory_item_id,
704: V_organization_id => V_organization_id,
705: V_line_id => l_line_id);
706: END LOOP;
707: CLOSE Cur_get_formula;

Line 742: gmd_lcf_fetch_pkg.get_category_value (V_inventory_item_id => l_comp_rec.inventory_item_id,

738: VALUES
739: (1,l_line_id,-1,l_line_no,0,l_comp_rec.inventory_item_id,l_comp_rec.concatenated_segments,
740: l_new_qty,l_comp_rec.description,l_comp_rec.primary_uom_code,l_comp_rec.primary_uom_code);
741:
742: gmd_lcf_fetch_pkg.get_category_value (V_inventory_item_id => l_comp_rec.inventory_item_id,
743: V_organization_id => V_organization_id,
744: V_line_id => l_line_id);
745: END LOOP;
746: CLOSE Cur_get_comp;

Line 751: gmd_lcf_fetch_pkg.load_tech_values (V_orgn_id => V_organization_id,

747: END IF;
748: END IF;
749: END IF;
750: --Call to load the item technical data.
751: gmd_lcf_fetch_pkg.load_tech_values (V_orgn_id => V_organization_id,
752: V_formulation_spec_id => V_formulation_spec_id,
753: V_date => V_date);
754: EXCEPTION
755: WHEN OTHERS THEN

Line 756: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Load_items');

752: V_formulation_spec_id => V_formulation_spec_id,
753: V_date => V_date);
754: EXCEPTION
755: WHEN OTHERS THEN
756: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Load_items');
757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
758: END load_items;
759:
760: /*##############################################################

Line 787: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Load_Categories');

783: ORDER BY order_no;
784: END IF;
785: EXCEPTION
786: WHEN OTHERS THEN
787: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Load_Categories');
788: END load_categories;
789:
790: /*##############################################################
791: # NAME

Line 832: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Load_Category_Value');

828: VALUES (V_line_id,l_value_ind,l_rec.category_id);
829: END LOOP;
830: EXCEPTION
831: WHEN OTHERS THEN
832: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Load_Category_Value');
833: END get_category_value;
834:
835: /*##############################################################
836: # NAME

Line 885: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'load_quality_data');

881: AND tech_parm_id = V_tech_parm_id;
882: END IF;
883: EXCEPTION
884: WHEN OTHERS THEN
885: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'load_quality_data');
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
887: NULL;
888: END load_quality_data;
889:

Line 1029: gmd_lcf_fetch_pkg.load_items (V_formulation_spec_id => V_formulation_spec_id,

1025: FETCH Cur_get_formulation INTO l_formulation;
1026: CLOSE Cur_get_formulation;
1027:
1028: --Call the load items procedure here to load the material lines and there item technical data.
1029: gmd_lcf_fetch_pkg.load_items (V_formulation_spec_id => V_formulation_spec_id,
1030: V_organization_id => V_organization_id,
1031: V_ingred_pick_base => l_formulation.ingred_pick_base_ind,
1032: V_formula_no => V_formula_no,
1033: V_batch_no => V_batch_no,

Line 1317: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Generate_Lcf_Data');

1313: WHERE qty IS NULL OR qty = 0;
1314:
1315: EXCEPTION
1316: WHEN OTHERS THEN
1317: fnd_msg_pub.add_exc_msg ('GMD_LCF_FETCH_PKG', 'Generate_Lcf_Data');
1318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1319: NULL;
1320: END generate_lcf_data;
1321:

Line 1371: END GMD_LCF_FETCH_PKG;

1367: END LOOP;
1368: end temp_category;
1369:
1370:
1371: END GMD_LCF_FETCH_PKG;