DBA Data[Home] [Help]

APPS.GMD_SPREAD_CALCULATE_PKG dependencies on FND_MSG_PUB

Line 30: FND_MSG_PUB.INITIALIZE;

26: l_density VARCHAR2(2000);
27: BEGIN
28: DELETE FROM GMD_SPREAD_ERRORS_GTMP;
29: FOR l_rec IN Cur_get_prod LOOP
30: FND_MSG_PUB.INITIALIZE;
31: IF ((l_rec.data_type = 4) OR (l_rec.line_type = 1 AND l_rec.data_type = 11)) THEN
32: evaluate_expression (V_entity_id => V_entity_id,
33: V_line_id => l_rec.line_id,
34: V_parm_name => l_rec.tech_parm_name,

Line 81: l_count := FND_MSG_PUB.COUNT_MSG;

77: X_return_status => X_return_status);
78: ELSE
79: NULL;
80: END IF;
81: l_count := FND_MSG_PUB.COUNT_MSG;
82: FOR i IN 1 .. l_count LOOP
83: FND_MSG_PUB.GET(P_msg_index => i, P_data => l_data, p_msg_index_out => j, P_encoded => 'F');
84: INSERT INTO GMD_SPREAD_ERRORS_GTMP
85: (ENTITY_ID,LINE_ID,LINE_TYPE,INVENTORY_ITEM_ID,CONCATENATED_SEGMENTS,LOT_NUMBER,

Line 83: FND_MSG_PUB.GET(P_msg_index => i, P_data => l_data, p_msg_index_out => j, P_encoded => 'F');

79: NULL;
80: END IF;
81: l_count := FND_MSG_PUB.COUNT_MSG;
82: FOR i IN 1 .. l_count LOOP
83: FND_MSG_PUB.GET(P_msg_index => i, P_data => l_data, p_msg_index_out => j, P_encoded => 'F');
84: INSERT INTO GMD_SPREAD_ERRORS_GTMP
85: (ENTITY_ID,LINE_ID,LINE_TYPE,INVENTORY_ITEM_ID,CONCATENATED_SEGMENTS,LOT_NUMBER,
86: TECH_PARM_ID,TECH_PARM_NAME,ERROR_MESSAGE,EXPRESSION_TYPE)
87: VALUES

Line 180: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_CALCULATE_PKG', 'Rollup_Wt_Pct');

176: END IF;
177:
178: EXCEPTION
179: WHEN OTHERS THEN
180: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_CALCULATE_PKG', 'Rollup_Wt_Pct');
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: END rollup_wt_pct;
183:
184: /*##############################################################

Line 244: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_CALCULATE_PKG', 'Evaluate_Expression');

240: END IF;
241:
242: EXCEPTION
243: WHEN OTHERS THEN
244: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_CALCULATE_PKG', 'Evaluate_Expression');
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: END evaluate_expression;
247:
248: /*##############################################################

Line 381: fnd_msg_pub.add_exc_msg ('GMD', 'GMD_PARM_NOT_FOUND');

377: END IF;
378:
379: EXCEPTION
380: WHEN NO_PARAMETER THEN
381: fnd_msg_pub.add_exc_msg ('GMD', 'GMD_PARM_NOT_FOUND');
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: WHEN OTHERS THEN
384: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_CALCULATE_PKG', 'Rollup_Vol_Pct');
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 384: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_CALCULATE_PKG', 'Rollup_Vol_Pct');

380: WHEN NO_PARAMETER THEN
381: fnd_msg_pub.add_exc_msg ('GMD', 'GMD_PARM_NOT_FOUND');
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: WHEN OTHERS THEN
384: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_CALCULATE_PKG', 'Rollup_Vol_Pct');
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: END rollup_vol_pct;
387:
388: /*##############################################################

Line 542: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_CALCULATE_PKG', 'Rollup_Cost_Units');

538: END IF;
539: RETURN(X_rollup);
540: EXCEPTION
541: WHEN OTHERS THEN
542: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_CALCULATE_PKG', 'Rollup_Cost_Units');
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
544: RETURN(0);
545: END rollup_cost_units;
546:

Line 678: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_CALCULATE_PKG', 'Rollup_Equiv_Wt');

674: END IF;
675:
676: EXCEPTION
677: WHEN OTHERS THEN
678: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_CALCULATE_PKG', 'Rollup_Equiv_Wt');
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: END rollup_equiv_wt;
681:
682:

Line 866: fnd_msg_pub.ADD;

862: IF l_temp_qty < 0
863: THEN
864: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
865: fnd_message.set_token('UOM',l_conv_uom);
866: fnd_msg_pub.ADD;
867: RAISE CANNOT_CONVERT;
868: -- EXIT;
869: END IF;
870: ELSE

Line 892: fnd_msg_pub.ADD;

888: IF l_temp_qty < 0
889: THEN
890: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
891: fnd_message.set_token('UOM',l_conv_uom);
892: fnd_msg_pub.ADD;
893: RAISE CANNOT_CONVERT;
894: -- EXIT;
895: END IF;
896: ELSE

Line 918: fnd_msg_pub.ADD;

914: IF l_temp_qty < 0
915: THEN
916: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
917: fnd_message.set_token('UOM',l_conv_uom);
918: fnd_msg_pub.ADD;
919: RAISE CANNOT_CONVERT;
920: -- EXIT;
921: END IF;
922: ELSE

Line 949: fnd_msg_pub.ADD;

945: THEN
946: x_return_status := 'Q';
947: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
948: fnd_message.set_token('UOM',l_conv_uom);
949: fnd_msg_pub.ADD;
950: EXIT;
951: END IF;
952: ELSE
953: l_temp_qty := l_prod_qty;

Line 967: fnd_msg_pub.ADD; */

963: WHEN CANNOT_CONVERT THEN
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965: /* fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
966: fnd_message.set_token ('ERROR', SQLERRM);
967: fnd_msg_pub.ADD; */
968: fnd_msg_pub.count_and_get (p_count => x_msg_count,
969: p_data => x_msg_data);
970: END auto_calc_product;
971:

Line 968: fnd_msg_pub.count_and_get (p_count => x_msg_count,

964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965: /* fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
966: fnd_message.set_token ('ERROR', SQLERRM);
967: fnd_msg_pub.ADD; */
968: fnd_msg_pub.count_and_get (p_count => x_msg_count,
969: p_data => x_msg_data);
970: END auto_calc_product;
971:
972: