DBA Data[Home] [Help]

APPS.QP_FORMULA_PRICE_CALC_PVT dependencies on QP_NUMBER

Line 711: qp_number.canonical_mask :=

707: END IF;
708: --process all factors before for bug 10273166 smbalara END
709:
710: --Change flexible mask to mask below for formula pattern use (Bug2195879)
711: qp_number.canonical_mask :=
712: '00999999999999999999999.99999999999999999999999999999999999999';
713: --Begin more POSCO changes.
714: FOR l_rec IN formula_lines_cur(p_price_formula_id)
715: LOOP

Line 881: qp_number.canonical_to_number(l_pra_rec.value_from);

877: IF l_debug = FND_API.G_TRUE THEN
878: QP_PREQ_GRP.engine_debug('l_pra_rec.value_from = '||l_pra_rec.value_from);
879: END IF;
880: l_formula_line_tbl(l_rec.step_number).component_value :=
881: qp_number.canonical_to_number(l_pra_rec.value_from);
882:
883: l_Operand_Tbl(l_rec.step_number) := l_formula_line_tbl(l_rec.step_number).component_value;
884:
885: IF l_debug = FND_API.G_TRUE THEN

Line 1028: qp_number.canonical_mask :=

1024: END IF;
1025: -- smbalara bug 7188211
1026: END LOOP; --Loop over formula_lines_cur
1027: -- Change mask back to flexible mask
1028: qp_number.canonical_mask :=
1029: 'FM999999999999999999999.9999999999999999999999999999999999999999';
1030: --commenting below for bug 10273166 smbalara START
1031: -- Now Process all Factor Lists in the formula
1032:

Line 1324: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

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:
1327: WHEN E_INVALID_FORMULA THEN
1328: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1332: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

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:
1335: WHEN E_FORMULA_COMPONENTS_REQ THEN
1336: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1340: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

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:
1343: WHEN E_CUSTOMIZE_GET_CUSTOM_PRICE THEN
1344: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1348: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

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:
1351: WHEN E_INVALID_NUMBER THEN
1352: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1356: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

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:
1359: WHEN FND_API.G_EXC_ERROR THEN
1360:

Line 1376: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

1372:
1373: l_formula_line_tbl.DELETE; --Clear the temp table table
1374:
1375: -- Change mask back to flexible mask
1376: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1377:
1378: RETURN l_formula_value;
1379:
1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1392: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

1388: END IF;
1389: l_formula_line_tbl.DELETE; --Clear the temp table table
1390:
1391: -- Change mask back to flexible mask
1392: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1393:
1394: RETURN l_formula_value;
1395:
1396: WHEN OTHERS THEN

Line 1415: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

1411: END IF;
1412: l_formula_line_tbl.DELETE; --Clear the temp table table
1413:
1414: -- Change mask back to flexible mask
1415: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1416:
1417: RETURN l_formula_value;
1418:
1419: END Calculate;