DBA Data[Home] [Help]

APPS.QP_FORMULA_PRICE_CALC_PVT dependencies on FND_MESSAGE

Line 95: fnd_message.set_name('QP','QP_FORMULA_NOT_FOUND');

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;
98:
99: -- RAISE;

Line 981: FND_MESSAGE.SET_NAME('QP','QP_INVALID_FORMULA_LINE_TYPE');

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:
984: END IF; -- IF stmt comparing price_formula_line_type_code to various values.
985: l_req_line_attrs_tbl.delete; --3531890 attribute were getting accumulated for every step

Line 1321: fnd_message.set_name('QP','QP_FORMULA_NOT_FOUND');

1317: EXCEPTION
1318:
1319: WHEN E_FORMULA_NOT_FOUND THEN
1320: x_return_status := FND_API.G_RET_STS_ERROR;
1321: fnd_message.set_name('QP','QP_FORMULA_NOT_FOUND');
1322: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1323: -- Change mask back to flexible mask
1324: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1325: RETURN l_formula_value;

Line 1322: fnd_message.set_token('FORMULA_NAME',l_formula_name);

1318:
1319: WHEN E_FORMULA_NOT_FOUND THEN
1320: x_return_status := FND_API.G_RET_STS_ERROR;
1321: fnd_message.set_name('QP','QP_FORMULA_NOT_FOUND');
1322: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1323: -- Change mask back to flexible mask
1324: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1325: RETURN l_formula_value;
1326:

Line 1329: fnd_message.set_name('QP','QP_INVALID_FORMULA');

1325: RETURN l_formula_value;
1326:
1327: WHEN E_INVALID_FORMULA THEN
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: fnd_message.set_name('QP','QP_INVALID_FORMULA');
1330: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1331: -- Change mask back to flexible mask
1332: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1333: RETURN l_formula_value;

Line 1330: fnd_message.set_token('FORMULA_NAME',l_formula_name);

1326:
1327: WHEN E_INVALID_FORMULA THEN
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: fnd_message.set_name('QP','QP_INVALID_FORMULA');
1330: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1331: -- Change mask back to flexible mask
1332: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1333: RETURN l_formula_value;
1334:

Line 1337: fnd_message.set_name('QP','QP_FORMULA_COMPONENTS_REQ');

1333: RETURN l_formula_value;
1334:
1335: WHEN E_FORMULA_COMPONENTS_REQ THEN
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337: fnd_message.set_name('QP','QP_FORMULA_COMPONENTS_REQ');
1338: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1339: -- Change mask back to flexible mask
1340: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1341: RETURN l_formula_value;

Line 1338: fnd_message.set_token('FORMULA_NAME',l_formula_name);

1334:
1335: WHEN E_FORMULA_COMPONENTS_REQ THEN
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337: fnd_message.set_name('QP','QP_FORMULA_COMPONENTS_REQ');
1338: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1339: -- Change mask back to flexible mask
1340: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1341: RETURN l_formula_value;
1342:

Line 1345: fnd_message.set_name('QP','QP_CUSTOMIZE_GET_CUSTOM_PRICE');

1341: RETURN l_formula_value;
1342:
1343: WHEN E_CUSTOMIZE_GET_CUSTOM_PRICE THEN
1344: x_return_status := FND_API.G_RET_STS_ERROR;
1345: fnd_message.set_name('QP','QP_CUSTOMIZE_GET_CUSTOM_PRICE');
1346: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1347: -- Change mask back to flexible mask
1348: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1349: RETURN l_formula_value;

Line 1346: fnd_message.set_token('FORMULA_NAME',l_formula_name);

1342:
1343: WHEN E_CUSTOMIZE_GET_CUSTOM_PRICE THEN
1344: x_return_status := FND_API.G_RET_STS_ERROR;
1345: fnd_message.set_name('QP','QP_CUSTOMIZE_GET_CUSTOM_PRICE');
1346: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1347: -- Change mask back to flexible mask
1348: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1349: RETURN l_formula_value;
1350:

Line 1353: fnd_message.set_name('QP','QP_INVALID_NUMBER');

1349: RETURN l_formula_value;
1350:
1351: WHEN E_INVALID_NUMBER THEN
1352: x_return_status := FND_API.G_RET_STS_ERROR;
1353: fnd_message.set_name('QP','QP_INVALID_NUMBER');
1354: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1355: -- Change mask back to flexible mask
1356: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1357: RETURN l_formula_value;

Line 1354: fnd_message.set_token('FORMULA_NAME',l_formula_name);

1350:
1351: WHEN E_INVALID_NUMBER THEN
1352: x_return_status := FND_API.G_RET_STS_ERROR;
1353: fnd_message.set_name('QP','QP_INVALID_NUMBER');
1354: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1355: -- Change mask back to flexible mask
1356: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1357: RETURN l_formula_value;
1358:

Line 1365: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_FAILED');

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
1368: QP_PREQ_GRP.engine_debug('Exception '||substr(sqlerrm, 1, 240));
1369: QP_PREQ_GRP.engine_debug('Exception occurred. Formula value returned is ' ||

Line 1489: fnd_message.set_name('QP','QP_FORMULA_LIST_PRICE_NULL');

1485: AND step_number = l_index;
1486:
1487: IF l_price_formula_line_type_code = 'LP'
1488: THEN
1489: fnd_message.set_name('QP','QP_FORMULA_LIST_PRICE_NULL');
1490:
1491: ELSIF l_price_formula_line_type_code = 'MV'
1492: THEN
1493: fnd_message.set_name('QP','QP_FORMULA_MODIFIER_VALUE_NULL');

Line 1493: fnd_message.set_name('QP','QP_FORMULA_MODIFIER_VALUE_NULL');

1489: fnd_message.set_name('QP','QP_FORMULA_LIST_PRICE_NULL');
1490:
1491: ELSIF l_price_formula_line_type_code = 'MV'
1492: THEN
1493: fnd_message.set_name('QP','QP_FORMULA_MODIFIER_VALUE_NULL');
1494:
1495: ELSIF l_price_formula_line_type_code = 'FUNC'
1496: THEN
1497: fnd_message.set_name('QP','QP_FORMULA_GET_CUSTOM_PRICE');

Line 1497: fnd_message.set_name('QP','QP_FORMULA_GET_CUSTOM_PRICE');

1493: fnd_message.set_name('QP','QP_FORMULA_MODIFIER_VALUE_NULL');
1494:
1495: ELSIF l_price_formula_line_type_code = 'FUNC'
1496: THEN
1497: fnd_message.set_name('QP','QP_FORMULA_GET_CUSTOM_PRICE');
1498:
1499: ELSIF l_price_formula_line_type_code = 'PRA'
1500: THEN
1501: SELECT nvl(SEGMENTS_TL.SEEDED_SEGMENT_NAME,SEGMENTS_TL.USER_SEGMENT_NAME)

Line 1511: fnd_message.set_name('QP','QP_PRICING_ATTRIBUTE_NULL');

1507: AND segments.segment_id = segments_tl.segment_id
1508: AND segments_tl.language = userenv('LANG') --bug#13250347
1509: AND rownum<2;
1510:
1511: fnd_message.set_name('QP','QP_PRICING_ATTRIBUTE_NULL');
1512: fnd_message.set_token('CONTEXT',l_pricing_attribute_context);
1513: fnd_message.set_token('ATTRIBUTE',l_attribute);
1514:
1515: ELSIF l_price_formula_line_type_code = 'PLL'

Line 1512: fnd_message.set_token('CONTEXT',l_pricing_attribute_context);

1508: AND segments_tl.language = userenv('LANG') --bug#13250347
1509: AND rownum<2;
1510:
1511: fnd_message.set_name('QP','QP_PRICING_ATTRIBUTE_NULL');
1512: fnd_message.set_token('CONTEXT',l_pricing_attribute_context);
1513: fnd_message.set_token('ATTRIBUTE',l_attribute);
1514:
1515: ELSIF l_price_formula_line_type_code = 'PLL'
1516: THEN

Line 1513: fnd_message.set_token('ATTRIBUTE',l_attribute);

1509: AND rownum<2;
1510:
1511: fnd_message.set_name('QP','QP_PRICING_ATTRIBUTE_NULL');
1512: fnd_message.set_token('CONTEXT',l_pricing_attribute_context);
1513: fnd_message.set_token('ATTRIBUTE',l_attribute);
1514:
1515: ELSIF l_price_formula_line_type_code = 'PLL'
1516: THEN
1517: fnd_message.set_name('QP','QP_PRICE_LIST_LINE_NOT_EXISTS');

Line 1517: fnd_message.set_name('QP','QP_PRICE_LIST_LINE_NOT_EXISTS');

1513: fnd_message.set_token('ATTRIBUTE',l_attribute);
1514:
1515: ELSIF l_price_formula_line_type_code = 'PLL'
1516: THEN
1517: fnd_message.set_name('QP','QP_PRICE_LIST_LINE_NOT_EXISTS');
1518:
1519: ELSIF l_price_formula_line_type_code = 'ML'
1520: THEN
1521: fnd_message.set_name('QP','QP_FACTOR_LIST_NULL');

Line 1521: fnd_message.set_name('QP','QP_FACTOR_LIST_NULL');

1517: fnd_message.set_name('QP','QP_PRICE_LIST_LINE_NOT_EXISTS');
1518:
1519: ELSIF l_price_formula_line_type_code = 'ML'
1520: THEN
1521: fnd_message.set_name('QP','QP_FACTOR_LIST_NULL');
1522: END IF;
1523: fnd_message.set_token('STEP_NUMBER',l_index);
1524:
1525: ELSIF p_null_step_number_tbl.COUNT>1 AND l_count = l_no_of_comps

Line 1523: fnd_message.set_token('STEP_NUMBER',l_index);

1519: ELSIF l_price_formula_line_type_code = 'ML'
1520: THEN
1521: fnd_message.set_name('QP','QP_FACTOR_LIST_NULL');
1522: END IF;
1523: fnd_message.set_token('STEP_NUMBER',l_index);
1524:
1525: ELSIF p_null_step_number_tbl.COUNT>1 AND l_count = l_no_of_comps
1526: THEN -- more than one step nulling out
1527: l_index := p_null_step_number_tbl.FIRST;

Line 1538: fnd_message.set_name('QP','QP_NULL_STEP_NUMBER');

1534: l_all_steps := l_all_steps || p_null_step_number_tbl(l_index) || ', ';
1535: END IF;
1536: l_index := p_null_step_number_tbl.NEXT(l_index);
1537: END LOOP;
1538: fnd_message.set_name('QP','QP_NULL_STEP_NUMBER');
1539: fnd_message.set_token('STEP_NUMBERS',l_all_steps);
1540: ELSE
1541: fnd_message.set_name('QP','QP_STEP_NO_UNDEFINED');
1542: END IF;

Line 1539: fnd_message.set_token('STEP_NUMBERS',l_all_steps);

1535: END IF;
1536: l_index := p_null_step_number_tbl.NEXT(l_index);
1537: END LOOP;
1538: fnd_message.set_name('QP','QP_NULL_STEP_NUMBER');
1539: fnd_message.set_token('STEP_NUMBERS',l_all_steps);
1540: ELSE
1541: fnd_message.set_name('QP','QP_STEP_NO_UNDEFINED');
1542: END IF;
1543: fnd_message.set_token('FORMULA_NAME',l_formula_name);

Line 1541: fnd_message.set_name('QP','QP_STEP_NO_UNDEFINED');

1537: END LOOP;
1538: fnd_message.set_name('QP','QP_NULL_STEP_NUMBER');
1539: fnd_message.set_token('STEP_NUMBERS',l_all_steps);
1540: ELSE
1541: fnd_message.set_name('QP','QP_STEP_NO_UNDEFINED');
1542: END IF;
1543: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1544: END Set_Message;
1545:

Line 1543: fnd_message.set_token('FORMULA_NAME',l_formula_name);

1539: fnd_message.set_token('STEP_NUMBERS',l_all_steps);
1540: ELSE
1541: fnd_message.set_name('QP','QP_STEP_NO_UNDEFINED');
1542: END IF;
1543: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1544: END Set_Message;
1545:
1546:
1547: -----------------------------------------------------------------------