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 530: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

526: IF price_formulas_cur%NOTFOUND THEN
527:
528: x_return_status := FND_API.G_RET_STS_ERROR;
529:
530: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
531: THEN
532: RAISE E_FORMULA_NOT_FOUND;
533: -- FND_MSG_PUB.Add;
534: END IF;

Line 533: -- FND_MSG_PUB.Add;

529:
530: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
531: THEN
532: RAISE E_FORMULA_NOT_FOUND;
533: -- FND_MSG_PUB.Add;
534: END IF;
535:
536: END IF;
537:

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

556: IF l_no_of_comps = 0 THEN
557:
558: x_return_status := FND_API.G_RET_STS_ERROR;
559:
560: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
561: THEN
562: RAISE E_FORMULA_COMPONENTS_REQ;
563: -- FND_MSG_PUB.Add;
564: END IF;

Line 563: -- FND_MSG_PUB.Add;

559:
560: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
561: THEN
562: RAISE E_FORMULA_COMPONENTS_REQ;
563: -- FND_MSG_PUB.Add;
564: END IF;
565:
566: END IF;
567: --smbalara 11898355 initializing all step values to NULL

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

853: END;
854:
855: ELSE --If customized = 'N'
856: x_return_status := FND_API.G_RET_STS_ERROR;
857: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
858: THEN
859: RAISE E_CUSTOMIZE_GET_CUSTOM_PRICE;
860: END IF;
861: END IF;

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

890: x_return_status := FND_API.G_RET_STS_ERROR;
891: IF l_debug = FND_API.G_TRUE THEN
892: QP_PREQ_GRP.engine_debug('Error converting PRA value to number');
893: END IF;
894: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
895: THEN
896: RAISE E_INVALID_NUMBER;
897: END IF;
898: END; -- for Begin block

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

975: --smbalara 11898355 end
976: ELSE --if price_formula_line_type_code is not one of the expected values.
977:
978: x_return_status := FND_API.G_RET_STS_ERROR;
979: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
980: THEN
981: FND_MESSAGE.SET_NAME('QP','QP_INVALID_FORMULA_LINE_TYPE');
982: END IF;
983:

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

1284: l_formula_value := Select_From_Dual(l_formula, l_operand_tbl);
1285:
1286: IF l_formula_value IS NULL THEN
1287: x_return_status := FND_API.G_RET_STS_ERROR;
1288: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1289: THEN
1290: Set_Message( p_price_formula_id => p_price_formula_id,
1291: p_formula_name => l_formula_name,
1292: p_null_step_number_tbl => l_null_step_number_tbl);

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

1359: WHEN FND_API.G_EXC_ERROR THEN
1360:
1361: x_return_status := FND_API.G_RET_STS_ERROR;
1362:
1363: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1364: THEN
1365: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_FAILED');
1366: END IF;
1367: IF l_debug = FND_API.G_TRUE THEN

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

1396: WHEN OTHERS THEN
1397:
1398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1399:
1400: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1401: THEN
1402: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1403: 'Calculate:'||sqlerrm);
1404: END IF;

Line 1402: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

1398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1399:
1400: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1401: THEN
1402: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1403: 'Calculate:'||sqlerrm);
1404: END IF;
1405:
1406: IF l_debug = FND_API.G_TRUE THEN