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_SPREAD_FETCH_PKG dependencies on GMD_SPREAD_FETCH_PKG

Line 1: PACKAGE BODY GMD_SPREAD_FETCH_PKG AS

1: PACKAGE BODY GMD_SPREAD_FETCH_PKG AS
2: /* $Header: GMDSPDFB.pls 120.13.12010000.2 2008/10/23 07:50:13 kannavar ship $ */
3:
4: /*##############################################################
5: # NAME

Line 25: gmd_spread_fetch_pkg.load_spread_details(V_entity_id,V_sprd_id,V_orgn_id);

21: BEGIN
22: DELETE FROM gmd_material_details_gtmp;
23: DELETE FROM gmd_technical_data_gtmp;
24: IF (V_sprd_id IS NOT NULL) THEN
25: gmd_spread_fetch_pkg.load_spread_details(V_entity_id,V_sprd_id,V_orgn_id);
26: ELSIF (V_batch_id IS NOT NULL AND V_spec_id IS NULL) THEN
27: gmd_spread_fetch_pkg.load_batch_details(V_entity_id,V_batch_id,V_orgn_id,V_update_inv_ind,V_plant_id);
28: ELSIF (V_formula_id IS NOT NULL AND V_spec_id IS NULL) THEN
29: gmd_spread_fetch_pkg.load_formula_details(V_entity_id,V_formula_id,V_orgn_id,V_plant_id);

Line 27: gmd_spread_fetch_pkg.load_batch_details(V_entity_id,V_batch_id,V_orgn_id,V_update_inv_ind,V_plant_id);

23: DELETE FROM gmd_technical_data_gtmp;
24: IF (V_sprd_id IS NOT NULL) THEN
25: gmd_spread_fetch_pkg.load_spread_details(V_entity_id,V_sprd_id,V_orgn_id);
26: ELSIF (V_batch_id IS NOT NULL AND V_spec_id IS NULL) THEN
27: gmd_spread_fetch_pkg.load_batch_details(V_entity_id,V_batch_id,V_orgn_id,V_update_inv_ind,V_plant_id);
28: ELSIF (V_formula_id IS NOT NULL AND V_spec_id IS NULL) THEN
29: gmd_spread_fetch_pkg.load_formula_details(V_entity_id,V_formula_id,V_orgn_id,V_plant_id);
30: ELSE
31: gmd_spread_fetch_pkg.load_lcf_details(V_entity_id,V_orgn_id,V_plant_id);

Line 29: gmd_spread_fetch_pkg.load_formula_details(V_entity_id,V_formula_id,V_orgn_id,V_plant_id);

25: gmd_spread_fetch_pkg.load_spread_details(V_entity_id,V_sprd_id,V_orgn_id);
26: ELSIF (V_batch_id IS NOT NULL AND V_spec_id IS NULL) THEN
27: gmd_spread_fetch_pkg.load_batch_details(V_entity_id,V_batch_id,V_orgn_id,V_update_inv_ind,V_plant_id);
28: ELSIF (V_formula_id IS NOT NULL AND V_spec_id IS NULL) THEN
29: gmd_spread_fetch_pkg.load_formula_details(V_entity_id,V_formula_id,V_orgn_id,V_plant_id);
30: ELSE
31: gmd_spread_fetch_pkg.load_lcf_details(V_entity_id,V_orgn_id,V_plant_id);
32: END IF;
33: END load_details;

Line 31: gmd_spread_fetch_pkg.load_lcf_details(V_entity_id,V_orgn_id,V_plant_id);

27: gmd_spread_fetch_pkg.load_batch_details(V_entity_id,V_batch_id,V_orgn_id,V_update_inv_ind,V_plant_id);
28: ELSIF (V_formula_id IS NOT NULL AND V_spec_id IS NULL) THEN
29: gmd_spread_fetch_pkg.load_formula_details(V_entity_id,V_formula_id,V_orgn_id,V_plant_id);
30: ELSE
31: gmd_spread_fetch_pkg.load_lcf_details(V_entity_id,V_orgn_id,V_plant_id);
32: END IF;
33: END load_details;
34:
35: /*##############################################################

Line 130: gmd_spread_fetch_pkg.load_spread_values(V_entity_id,V_sprd_id,V_orgn_id,l_sprd_rec.parent_line_id);

126: l_spread_rec.move_order_line_id,l_spread_rec.secondary_default_ind,l_spread_rec.locator_id);
127: END LOOP;
128: CLOSE Cur_get_spread;
129: FOR l_sprd_rec IN Cur_get_lines LOOP
130: gmd_spread_fetch_pkg.load_spread_values(V_entity_id,V_sprd_id,V_orgn_id,l_sprd_rec.parent_line_id);
131: END LOOP;
132: END IF;
133: EXCEPTION
134: WHEN OTHERS THEN

Line 135: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Spread_Details');

131: END LOOP;
132: END IF;
133: EXCEPTION
134: WHEN OTHERS THEN
135: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Spread_Details');
136: END load_spread_details;
137:
138: /*##############################################################
139: # NAME

Line 466: gmd_spread_fetch_pkg.load_batch_values(V_entity_id => V_entity_id,

462: END IF;
463: END LOOP;
464: CLOSE Cur_get_batch;
465: FOR l_mat_rec IN Cur_get_lines LOOP
466: gmd_spread_fetch_pkg.load_batch_values(V_entity_id => V_entity_id,
467: V_batch_id => V_batch_id,
468: V_orgn_id => V_orgn_id,
469: V_matl_detl_id => l_mat_rec.material_detail_id,
470: V_plant_id => V_plant_id);

Line 477: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Batch_Details');

473:
474: EXCEPTION
475: WHEN OTHERS THEN
476: gmd_debug.put_line('error '||SQLERRM);
477: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Batch_Details');
478: END load_batch_details;
479:
480: /*##############################################################
481: # NAME

Line 678: gmd_spread_fetch_pkg.load_formula_values(V_entity_id => V_entity_id,

674: l_line_no := l_line_no + 1;
675: END LOOP;
676: CLOSE Cur_get_materials;
677: FOR l_form_rec IN Cur_get_lines LOOP
678: gmd_spread_fetch_pkg.load_formula_values(V_entity_id => V_entity_id,
679: V_formula_id => V_formula_id,
680: V_orgn_id => V_orgn_id,
681: V_formulaline_id => l_form_rec.formulaline_id,
682: V_plant_id => V_plant_id);

Line 687: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Formula_Details');

683: END LOOP;
684: END IF;
685: EXCEPTION
686: WHEN OTHERS THEN
687: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Formula_Details');
688: END load_formula_details;
689:
690: /*##############################################################
691: # NAME

Line 870: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Tech_Params');

866: END IF;
867: END IF;
868: EXCEPTION
869: WHEN OTHERS THEN
870: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Tech_Params');
871: END load_tech_params;
872:
873: /*##############################################################
874: # NAME

Line 1017: gmd_spread_fetch_pkg.load_formula_values(V_entity_id => V_entity_id,

1013: RAISE create_mo_line_err;
1014: ELSE
1015: X_move_order_line_id := l_materials_out(1).move_order_line_id;
1016: END IF;
1017: gmd_spread_fetch_pkg.load_formula_values(V_entity_id => V_entity_id,
1018: V_formula_id => V_formula_id,
1019: V_orgn_id => V_orgn_id,
1020: V_formulaline_id => l_parentline_id,
1021: V_plant_id => V_plant_id);

Line 1033: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Add_New_line');

1029: END LOOP;
1030: WHEN setup_failure THEN
1031: x_return_status := fnd_api.g_ret_sts_error;
1032: WHEN OTHERS THEN
1033: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Add_New_line');
1034: END add_new_line;
1035:
1036: /*##############################################################
1037: # NAME

Line 1071: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Spread_Values');

1067: AND c.parent_line_id = V_parent_line_id;
1068: END IF;
1069: EXCEPTION
1070: WHEN OTHERS THEN
1071: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Spread_Values');
1072: END load_spread_values;
1073:
1074: /*##############################################################
1075: # NAME

Line 1122: gmd_spread_fetch_pkg.get_lot_density (P_orgn_id => V_orgn_id,

1118: AND a.delete_mark = 0
1119: AND NVL(c.organization_id, -1) = NVL(a.lot_organization_id, c.organization_id)
1120: AND NVL(c.lot_number, '-1') = NVL(a.lot_number, '-1');
1121:
1122: gmd_spread_fetch_pkg.get_lot_density (P_orgn_id => V_orgn_id,
1123: P_parent_detl_id => V_matl_detl_id,
1124: P_entity_id => V_entity_id);
1125:
1126:

Line 1134: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Batch_Values');

1130: load_quality_data (l_quality_rec.line_id,V_orgn_id,V_plant_id);
1131: END LOOP;
1132: EXCEPTION
1133: WHEN OTHERS THEN
1134: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Batch_Values');
1135: END load_batch_values;
1136:
1137: /*##############################################################
1138: # NAME

Line 1184: gmd_spread_fetch_pkg.get_lot_density (P_orgn_id => V_orgn_id,

1180: AND a.batch_id IS NULL
1181: AND NVL(c.organization_id, -1) = NVL(a.lot_organization_id, c.organization_id)
1182: AND NVL(c.lot_number, '-1') = NVL(a.lot_number, '-1');
1183:
1184: gmd_spread_fetch_pkg.get_lot_density (P_orgn_id => V_orgn_id,
1185: P_parent_detl_id => V_formulaline_id,
1186: P_entity_id => V_entity_id);
1187:
1188: END IF;

Line 1196: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Formula_Values');

1192: load_quality_data (l_quality_rec.line_id,V_orgn_id,V_plant_id);
1193: END LOOP;
1194: EXCEPTION
1195: WHEN OTHERS THEN
1196: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Formula_Values');
1197: END load_formula_values;
1198:
1199: /*##############################################################
1200: # NAME

Line 1312: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Save_Spreadsheet');

1308: AND line_id = l_rec.line_id;
1309: END LOOP;
1310: EXCEPTION
1311: WHEN OTHERS THEN
1312: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Save_Spreadsheet');
1313: END save_spreadsheet;
1314:
1315: /*##############################################################
1316: # NAME

Line 1462: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Update_Line_Mass_Vol_Qty');

1458: EXCEPTION
1459: WHEN line_not_found THEN
1460: X_return_status := FND_API.g_ret_sts_error;
1461: WHEN OTHERS THEN
1462: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Update_Line_Mass_Vol_Qty');
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464: END update_line_mass_vol_qty;
1465:
1466: /*##############################################################

Line 1609: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'load_quality_data');

1605: END IF;
1606: END LOOP;
1607: EXCEPTION
1608: WHEN OTHERS THEN
1609: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'load_quality_data');
1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1611: NULL;
1612: END load_quality_data;
1613:

Line 1754: gmd_spread_fetch_pkg.load_lcf_values(V_entity_id => V_entity_id,

1750: END LOOP;
1751: CLOSE Cur_get_lcf;
1752:
1753: FOR l_form_rec IN Cur_get_lines LOOP
1754: gmd_spread_fetch_pkg.load_lcf_values(V_entity_id => V_entity_id,
1755: V_orgn_id => V_orgn_id,
1756: V_formulaline_id => l_form_rec.formulaline_id,
1757: V_plant_id => V_plant_id);
1758: END LOOP;

Line 1762: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Lcf_Details');

1758: END LOOP;
1759: END IF;
1760: EXCEPTION
1761: WHEN OTHERS THEN
1762: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Lcf_Details');
1763: END load_lcf_details;
1764:
1765: /*##############################################################
1766: # NAME

Line 1808: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Lcf_Values');

1804: load_quality_data (l_quality_rec.line_id,V_orgn_id,V_plant_id);
1805: END LOOP;
1806: EXCEPTION
1807: WHEN OTHERS THEN
1808: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Lcf_Values');
1809: END load_lcf_values;
1810:
1811: /*##############################################################
1812: # NAME

Line 1852: END GMD_SPREAD_FETCH_PKG;

1848: END LOOP;
1849: END load_derived_cost;
1850:
1851:
1852: END GMD_SPREAD_FETCH_PKG;
1853: