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 823: FND_MESSAGE.SET_NAME('QP','QP_INVALID_FORMULA_LINE_TYPE');

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

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

1103: EXCEPTION
1104:
1105: WHEN E_FORMULA_NOT_FOUND THEN
1106: x_return_status := FND_API.G_RET_STS_ERROR;
1107: fnd_message.set_name('QP','QP_FORMULA_NOT_FOUND');
1108: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1109: -- Change mask back to flexible mask
1110: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1111: RETURN l_formula_value;

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

1104:
1105: WHEN E_FORMULA_NOT_FOUND THEN
1106: x_return_status := FND_API.G_RET_STS_ERROR;
1107: fnd_message.set_name('QP','QP_FORMULA_NOT_FOUND');
1108: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1109: -- Change mask back to flexible mask
1110: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1111: RETURN l_formula_value;
1112:

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

1111: RETURN l_formula_value;
1112:
1113: WHEN E_INVALID_FORMULA THEN
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: fnd_message.set_name('QP','QP_INVALID_FORMULA');
1116: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1117: -- Change mask back to flexible mask
1118: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1119: RETURN l_formula_value;

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

1112:
1113: WHEN E_INVALID_FORMULA THEN
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: fnd_message.set_name('QP','QP_INVALID_FORMULA');
1116: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1117: -- Change mask back to flexible mask
1118: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1119: RETURN l_formula_value;
1120:

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

1119: RETURN l_formula_value;
1120:
1121: WHEN E_FORMULA_COMPONENTS_REQ THEN
1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: fnd_message.set_name('QP','QP_FORMULA_COMPONENTS_REQ');
1124: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1125: -- Change mask back to flexible mask
1126: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1127: RETURN l_formula_value;

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

1120:
1121: WHEN E_FORMULA_COMPONENTS_REQ THEN
1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: fnd_message.set_name('QP','QP_FORMULA_COMPONENTS_REQ');
1124: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1125: -- Change mask back to flexible mask
1126: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1127: RETURN l_formula_value;
1128:

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

1127: RETURN l_formula_value;
1128:
1129: WHEN E_CUSTOMIZE_GET_CUSTOM_PRICE THEN
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: fnd_message.set_name('QP','QP_CUSTOMIZE_GET_CUSTOM_PRICE');
1132: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1133: -- Change mask back to flexible mask
1134: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1135: RETURN l_formula_value;

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

1128:
1129: WHEN E_CUSTOMIZE_GET_CUSTOM_PRICE THEN
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: fnd_message.set_name('QP','QP_CUSTOMIZE_GET_CUSTOM_PRICE');
1132: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1133: -- Change mask back to flexible mask
1134: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1135: RETURN l_formula_value;
1136:

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

1135: RETURN l_formula_value;
1136:
1137: WHEN E_INVALID_NUMBER THEN
1138: x_return_status := FND_API.G_RET_STS_ERROR;
1139: fnd_message.set_name('QP','QP_INVALID_NUMBER');
1140: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1141: -- Change mask back to flexible mask
1142: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1143: RETURN l_formula_value;

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

1136:
1137: WHEN E_INVALID_NUMBER THEN
1138: x_return_status := FND_API.G_RET_STS_ERROR;
1139: fnd_message.set_name('QP','QP_INVALID_NUMBER');
1140: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1141: -- Change mask back to flexible mask
1142: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1143: RETURN l_formula_value;
1144:

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

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

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

1271: AND step_number = l_index;
1272:
1273: IF l_price_formula_line_type_code = 'LP'
1274: THEN
1275: fnd_message.set_name('QP','QP_FORMULA_LIST_PRICE_NULL');
1276:
1277: ELSIF l_price_formula_line_type_code = 'MV'
1278: THEN
1279: fnd_message.set_name('QP','QP_FORMULA_MODIFIER_VALUE_NULL');

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

1275: fnd_message.set_name('QP','QP_FORMULA_LIST_PRICE_NULL');
1276:
1277: ELSIF l_price_formula_line_type_code = 'MV'
1278: THEN
1279: fnd_message.set_name('QP','QP_FORMULA_MODIFIER_VALUE_NULL');
1280:
1281: ELSIF l_price_formula_line_type_code = 'FUNC'
1282: THEN
1283: fnd_message.set_name('QP','QP_FORMULA_GET_CUSTOM_PRICE');

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

1279: fnd_message.set_name('QP','QP_FORMULA_MODIFIER_VALUE_NULL');
1280:
1281: ELSIF l_price_formula_line_type_code = 'FUNC'
1282: THEN
1283: fnd_message.set_name('QP','QP_FORMULA_GET_CUSTOM_PRICE');
1284:
1285: ELSIF l_price_formula_line_type_code = 'PRA'
1286: THEN
1287: SELECT nvl(SEGMENTS_TL.SEEDED_SEGMENT_NAME,SEGMENTS_TL.USER_SEGMENT_NAME)

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

1292: AND segments.prc_context_id = pcontexts.prc_context_id
1293: AND segments.segment_id = segments_tl.segment_id
1294: AND rownum<2;
1295:
1296: fnd_message.set_name('QP','QP_PRICING_ATTRIBUTE_NULL');
1297: fnd_message.set_token('CONTEXT',l_pricing_attribute_context);
1298: fnd_message.set_token('ATTRIBUTE',l_attribute);
1299:
1300: ELSIF l_price_formula_line_type_code = 'PLL'

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

1293: AND segments.segment_id = segments_tl.segment_id
1294: AND rownum<2;
1295:
1296: fnd_message.set_name('QP','QP_PRICING_ATTRIBUTE_NULL');
1297: fnd_message.set_token('CONTEXT',l_pricing_attribute_context);
1298: fnd_message.set_token('ATTRIBUTE',l_attribute);
1299:
1300: ELSIF l_price_formula_line_type_code = 'PLL'
1301: THEN

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

1294: AND rownum<2;
1295:
1296: fnd_message.set_name('QP','QP_PRICING_ATTRIBUTE_NULL');
1297: fnd_message.set_token('CONTEXT',l_pricing_attribute_context);
1298: fnd_message.set_token('ATTRIBUTE',l_attribute);
1299:
1300: ELSIF l_price_formula_line_type_code = 'PLL'
1301: THEN
1302: fnd_message.set_name('QP','QP_PRICE_LIST_LINE_NOT_EXISTS');

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

1298: fnd_message.set_token('ATTRIBUTE',l_attribute);
1299:
1300: ELSIF l_price_formula_line_type_code = 'PLL'
1301: THEN
1302: fnd_message.set_name('QP','QP_PRICE_LIST_LINE_NOT_EXISTS');
1303:
1304: ELSIF l_price_formula_line_type_code = 'ML'
1305: THEN
1306: fnd_message.set_name('QP','QP_FACTOR_LIST_NULL');

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

1302: fnd_message.set_name('QP','QP_PRICE_LIST_LINE_NOT_EXISTS');
1303:
1304: ELSIF l_price_formula_line_type_code = 'ML'
1305: THEN
1306: fnd_message.set_name('QP','QP_FACTOR_LIST_NULL');
1307: END IF;
1308: fnd_message.set_token('STEP_NUMBER',l_index);
1309:
1310: ELSIF p_null_step_number_tbl.COUNT>1 AND l_count = l_no_of_comps

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

1304: ELSIF l_price_formula_line_type_code = 'ML'
1305: THEN
1306: fnd_message.set_name('QP','QP_FACTOR_LIST_NULL');
1307: END IF;
1308: fnd_message.set_token('STEP_NUMBER',l_index);
1309:
1310: ELSIF p_null_step_number_tbl.COUNT>1 AND l_count = l_no_of_comps
1311: THEN -- more than one step nulling out
1312: l_index := p_null_step_number_tbl.FIRST;

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

1319: l_all_steps := l_all_steps || p_null_step_number_tbl(l_index) || ', ';
1320: END IF;
1321: l_index := p_null_step_number_tbl.NEXT(l_index);
1322: END LOOP;
1323: fnd_message.set_name('QP','QP_NULL_STEP_NUMBER');
1324: fnd_message.set_token('STEP_NUMBERS',l_all_steps);
1325: ELSE
1326: fnd_message.set_name('QP','QP_STEP_NO_UNDEFINED');
1327: END IF;

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

1320: END IF;
1321: l_index := p_null_step_number_tbl.NEXT(l_index);
1322: END LOOP;
1323: fnd_message.set_name('QP','QP_NULL_STEP_NUMBER');
1324: fnd_message.set_token('STEP_NUMBERS',l_all_steps);
1325: ELSE
1326: fnd_message.set_name('QP','QP_STEP_NO_UNDEFINED');
1327: END IF;
1328: fnd_message.set_token('FORMULA_NAME',l_formula_name);

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

1322: END LOOP;
1323: fnd_message.set_name('QP','QP_NULL_STEP_NUMBER');
1324: fnd_message.set_token('STEP_NUMBERS',l_all_steps);
1325: ELSE
1326: fnd_message.set_name('QP','QP_STEP_NO_UNDEFINED');
1327: END IF;
1328: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1329: END Set_Message;
1330:

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

1324: fnd_message.set_token('STEP_NUMBERS',l_all_steps);
1325: ELSE
1326: fnd_message.set_name('QP','QP_STEP_NO_UNDEFINED');
1327: END IF;
1328: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1329: END Set_Message;
1330:
1331:
1332: -----------------------------------------------------------------------