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.21.12020000.3 2013/03/07 02:51:10 mtou 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,l_spread_rec.prod_percent);
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 679: gmd_spread_fetch_pkg.load_formula_values(V_entity_id => V_entity_id,

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

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

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

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

896: END IF;
897: END IF;
898: EXCEPTION
899: WHEN OTHERS THEN
900: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Tech_Params');
901: END load_tech_params;
902:
903: /*##############################################################
904: # NAME

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

1047: END IF;
1048: END IF;
1049: --Fixed for ADS demo this code was in the if condition before.
1050: IF (V_line_type = -1) THEN
1051: gmd_spread_fetch_pkg.load_formula_values(V_entity_id => V_entity_id,
1052: V_formula_id => V_formula_id,
1053: V_orgn_id => V_orgn_id,
1054: V_formulaline_id => l_parentline_id,
1055: V_plant_id => V_plant_id);

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

1062: END LOOP;
1063: WHEN setup_failure THEN
1064: x_return_status := fnd_api.g_ret_sts_error;
1065: WHEN OTHERS THEN
1066: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Add_New_line');
1067: END add_new_line;
1068:
1069: /*##############################################################
1070: # NAME

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

1100: AND c.parent_line_id = V_parent_line_id;
1101: END IF;
1102: EXCEPTION
1103: WHEN OTHERS THEN
1104: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Spread_Values');
1105: END load_spread_values;
1106:
1107: /*##############################################################
1108: # NAME

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

1151: AND a.delete_mark = 0
1152: AND NVL(c.organization_id, -1) = NVL(a.lot_organization_id, c.organization_id)
1153: AND NVL(c.lot_number, '-1') = NVL(a.lot_number, '-1');
1154:
1155: gmd_spread_fetch_pkg.get_lot_density (P_orgn_id => V_orgn_id,
1156: P_parent_detl_id => V_matl_detl_id,
1157: P_entity_id => V_entity_id);
1158:
1159:

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

1163: load_quality_data (l_quality_rec.line_id,V_orgn_id,V_plant_id);
1164: END LOOP;
1165: EXCEPTION
1166: WHEN OTHERS THEN
1167: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Batch_Values');
1168: END load_batch_values;
1169:
1170: /*##############################################################
1171: # NAME

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

1214: AND a.delete_mark = 0
1215: AND NVL(c.organization_id, -1) = NVL(a.lot_organization_id, c.organization_id)
1216: AND NVL(c.lot_number, '-1') = NVL(a.lot_number, '-1');
1217:
1218: gmd_spread_fetch_pkg.get_lot_density (P_orgn_id => V_orgn_id,
1219: P_parent_detl_id => V_formulaline_id,
1220: P_entity_id => V_entity_id);
1221:
1222: END IF;

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

1226: load_quality_data (l_quality_rec.line_id,V_orgn_id,V_plant_id);
1227: END LOOP;
1228: EXCEPTION
1229: WHEN OTHERS THEN
1230: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Formula_Values');
1231: END load_formula_values;
1232:
1233: /*##############################################################
1234: # NAME

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

1342: AND line_id = l_rec.line_id;
1343: END LOOP;
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Save_Spreadsheet');
1347: END save_spreadsheet;
1348:
1349: /*##############################################################
1350: # NAME

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

1502: EXCEPTION
1503: WHEN line_not_found THEN
1504: X_return_status := FND_API.g_ret_sts_error;
1505: WHEN OTHERS THEN
1506: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Update_Line_Mass_Vol_Qty');
1507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1508: END update_line_mass_vol_qty;
1509:
1510: /*##############################################################

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

1649: END IF;
1650: END LOOP;
1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'load_quality_data');
1654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1655: NULL;
1656: END load_quality_data;
1657:

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

1797: END LOOP;
1798: CLOSE Cur_get_lcf;
1799:
1800: FOR l_form_rec IN Cur_get_lines LOOP
1801: gmd_spread_fetch_pkg.load_lcf_values(V_entity_id => V_entity_id,
1802: V_orgn_id => V_orgn_id,
1803: V_formulaline_id => l_form_rec.formulaline_id,
1804: V_plant_id => V_plant_id);
1805: END LOOP;

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

1805: END LOOP;
1806: END IF;
1807: EXCEPTION
1808: WHEN OTHERS THEN
1809: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Lcf_Details');
1810: END load_lcf_details;
1811:
1812: /*##############################################################
1813: # NAME

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

1851: load_quality_data (l_quality_rec.line_id,V_orgn_id,V_plant_id);
1852: END LOOP;
1853: EXCEPTION
1854: WHEN OTHERS THEN
1855: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Load_Lcf_Values');
1856: END load_lcf_values;
1857:
1858: /*##############################################################
1859: # NAME

Line 2073: gmd_spread_fetch_pkg.Update_formula_values(V_entity_id => V_entity_id,

2069: l_line_no := l_line_no + 1;
2070: END LOOP;
2071: CLOSE Cur_get_materials;
2072:
2073: gmd_spread_fetch_pkg.Update_formula_values(V_entity_id => V_entity_id,
2074: V_formula_id => V_formula_id,
2075: V_orgn_id => V_orgn_id,
2076: V_formulaline_id => fmid,
2077: V_line_id => V_line_id,

Line 2085: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Update_Formula_Details');

2081: END IF;
2082:
2083: EXCEPTION
2084: WHEN OTHERS THEN
2085: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Update_Formula_Details');
2086: END update_formula_details;
2087:
2088:
2089: PROCEDURE Update_Formula_Values (V_entity_id IN NUMBER,V_formula_id IN NUMBER,

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

2153:
2154: AND a.batch_id IS NULL
2155: AND NVL(c.lot_id,-1) = NVL(a.lot_id,-1);
2156:
2157: gmd_spread_fetch_pkg.get_lot_density (P_orgn_id => V_orgn_id,
2158: P_parent_detl_id => V_formulaline_id,
2159: P_entity_id => V_entity_id);
2160:
2161: ELSE

Line 2181: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Update_Formula_Values');

2177: END LOOP;
2178:
2179: EXCEPTION
2180: WHEN OTHERS THEN
2181: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Update_Formula_Values');
2182: END Update_Formula_Values;
2183: /* Bug#7254259 (add procedure ,update_formula_details ,Update_Formula_Values ) End */
2184:
2185:

Line 2186: END GMD_SPREAD_FETCH_PKG;

2182: END Update_Formula_Values;
2183: /* Bug#7254259 (add procedure ,update_formula_details ,Update_Formula_Values ) End */
2184:
2185:
2186: END GMD_SPREAD_FETCH_PKG;