DBA Data[Home] [Help]

APPS.GMD_LCF_FETCH_PKG dependencies on FND_MSG_PUB

Line 31: FND_MSG_PUB.INITIALIZE;

27: AND a.data_type IN (5,6,12);
28:
29: BEGIN
30: FOR l_rec IN Cur_get_prod LOOP
31: FND_MSG_PUB.INITIALIZE;
32: IF (l_rec.data_type = 5 OR l_rec.data_type = 12) THEN
33: rollup_wt_pct (V_parm_name => l_rec.tech_parm_name,
34: V_parm_id => l_rec.tech_parm_id,
35: V_line_id => V_line_id,

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 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 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: