DBA Data[Home] [Help]

APPS.QP_FORMULA_PRICE_CALC_PVT dependencies on FND_MSG_PUB

Line 93: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

89: WHEN FND_API.G_EXC_ERROR THEN
90:
91: x_return_status := FND_API.G_RET_STS_ERROR;
92:
93: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
94: THEN
95: fnd_message.set_name('QP','QP_FORMULA_NOT_FOUND');
96: -- FND_MSG_PUB.Add;
97: END IF;

Line 96: -- FND_MSG_PUB.Add;

92:
93: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
94: THEN
95: fnd_message.set_name('QP','QP_FORMULA_NOT_FOUND');
96: -- FND_MSG_PUB.Add;
97: END IF;
98:
99: -- RAISE;
100:

Line 111: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

107: WHEN OTHERS THEN
108:
109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
110:
111: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
112: THEN
113: FND_MSG_PUB.Add_Exc_Msg
114: (G_PKG_NAME
115: , 'Parse Formula'

Line 113: FND_MSG_PUB.Add_Exc_Msg

109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
110:
111: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
112: THEN
113: FND_MSG_PUB.Add_Exc_Msg
114: (G_PKG_NAME
115: , 'Parse Formula'
116: );
117: END IF;

Line 526: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

522: IF price_formulas_cur%NOTFOUND THEN
523:
524: x_return_status := FND_API.G_RET_STS_ERROR;
525:
526: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
527: THEN
528: RAISE E_FORMULA_NOT_FOUND;
529: -- FND_MSG_PUB.Add;
530: END IF;

Line 529: -- FND_MSG_PUB.Add;

525:
526: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
527: THEN
528: RAISE E_FORMULA_NOT_FOUND;
529: -- FND_MSG_PUB.Add;
530: END IF;
531:
532: END IF;
533:

Line 556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

552: IF l_no_of_comps = 0 THEN
553:
554: x_return_status := FND_API.G_RET_STS_ERROR;
555:
556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
557: THEN
558: RAISE E_FORMULA_COMPONENTS_REQ;
559: -- FND_MSG_PUB.Add;
560: END IF;

Line 559: -- FND_MSG_PUB.Add;

555:
556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
557: THEN
558: RAISE E_FORMULA_COMPONENTS_REQ;
559: -- FND_MSG_PUB.Add;
560: END IF;
561:
562: END IF;
563: --Change flexible mask to mask below for formula pattern use (Bug2195879)

Line 710: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

706: END;
707:
708: ELSE --If customized = 'N'
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
711: THEN
712: RAISE E_CUSTOMIZE_GET_CUSTOM_PRICE;
713: END IF;
714: END IF;

Line 747: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

743: x_return_status := FND_API.G_RET_STS_ERROR;
744: IF l_debug = FND_API.G_TRUE THEN
745: QP_PREQ_GRP.engine_debug('Error converting PRA value to number');
746: END IF;
747: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
748: THEN
749: RAISE E_INVALID_NUMBER;
750: END IF;
751: END; -- for Begin block

Line 821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

817: l_null_step_number_tbl(l_rec.step_number) := l_rec.step_number;
818: ELSE --if price_formula_line_type_code is not one of the expected values.
819:
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
822: THEN
823: FND_MESSAGE.SET_NAME('QP','QP_INVALID_FORMULA_LINE_TYPE');
824: END IF;
825:

Line 1074: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1070: l_formula_value := Select_From_Dual(l_formula, l_operand_tbl);
1071:
1072: IF l_formula_value IS NULL THEN
1073: x_return_status := FND_API.G_RET_STS_ERROR;
1074: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1075: THEN
1076: Set_Message( p_price_formula_id => p_price_formula_id,
1077: p_formula_name => l_formula_name,
1078: p_null_step_number_tbl => l_null_step_number_tbl);

Line 1149: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1145: WHEN FND_API.G_EXC_ERROR THEN
1146:
1147: x_return_status := FND_API.G_RET_STS_ERROR;
1148:
1149: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1150: THEN
1151: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_FAILED');
1152: END IF;
1153: IF l_debug = FND_API.G_TRUE THEN

Line 1186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1182: WHEN OTHERS THEN
1183:
1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1185:
1186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1187: THEN
1188: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1189: 'Calculate:'||sqlerrm);
1190: END IF;

Line 1188: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1185:
1186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1187: THEN
1188: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1189: 'Calculate:'||sqlerrm);
1190: END IF;
1191:
1192: IF l_debug = FND_API.G_TRUE THEN