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 902: fnd_msg_pub.ADD;

898: IF l_temp_qty < 0
899: THEN
900: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
901: fnd_message.set_token('UOM',l_conv_uom);
902: fnd_msg_pub.ADD;
903: RAISE CANNOT_CONVERT;
904: -- EXIT;
905: END IF;
906: ELSE

Line 928: fnd_msg_pub.ADD;

924: IF l_temp_qty < 0
925: THEN
926: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
927: fnd_message.set_token('UOM',l_conv_uom);
928: fnd_msg_pub.ADD;
929: RAISE CANNOT_CONVERT;
930: -- EXIT;
931: END IF;
932: ELSE

Line 954: fnd_msg_pub.ADD;

950: IF l_temp_qty < 0
951: THEN
952: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
953: fnd_message.set_token('UOM',l_conv_uom);
954: fnd_msg_pub.ADD;
955: RAISE CANNOT_CONVERT;
956: -- EXIT;
957: END IF;
958: ELSE

Line 985: fnd_msg_pub.ADD;

981: THEN
982: x_return_status := 'Q';
983: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
984: fnd_message.set_token('UOM',l_conv_uom);
985: fnd_msg_pub.ADD;
986: EXIT;
987: END IF;
988: ELSE
989: l_temp_qty := l_prod_qty;

Line 1003: fnd_msg_pub.ADD; */

999: WHEN CANNOT_CONVERT THEN
1000: x_return_status := fnd_api.g_ret_sts_unexp_error;
1001: /* fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
1002: fnd_message.set_token ('ERROR', SQLERRM);
1003: fnd_msg_pub.ADD; */
1004: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1005: p_data => x_msg_data);
1006: END auto_calc_product;
1007:

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

1000: x_return_status := fnd_api.g_ret_sts_unexp_error;
1001: /* fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
1002: fnd_message.set_token ('ERROR', SQLERRM);
1003: fnd_msg_pub.ADD; */
1004: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1005: p_data => x_msg_data);
1006: END auto_calc_product;
1007:
1008: