32: p_FORMULA_LINES_rec.formula_line_type_code IN ('PLL', 'FUNC', 'LP')
33: THEN
34:
35: l_return_status := FND_API.G_RET_STS_ERROR;
36: FND_MESSAGE.SET_NAME('QP', 'QP_BASIC_PRICING_UNAVAILABLE');
37: OE_MSG_PUB.Add;
38: RAISE FND_API.G_EXC_ERROR;
39:
40: END IF;
49:
50: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
51: THEN
52:
53: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
54: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula_line');
55: OE_MSG_PUB.Add;
56:
57: END IF;
50: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
51: THEN
52:
53: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
54: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula_line');
55: OE_MSG_PUB.Add;
56:
57: END IF;
58:
69:
70: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
71: THEN
72:
73: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
74: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula');
75: OE_MSG_PUB.Add;
76:
77: END IF;
70: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
71: THEN
72:
73: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
74: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula');
75: OE_MSG_PUB.Add;
76:
77: END IF;
78:
85:
86: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
87: THEN
88:
89: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
90: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula_line_type');
91: OE_MSG_PUB.Add;
92:
93: END IF;
86: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
87: THEN
88:
89: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
90: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula_line_type');
91: OE_MSG_PUB.Add;
92:
93: END IF;
94:
101:
102: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
103: THEN
104:
105: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
106: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','step_number');
107: OE_MSG_PUB.Add;
108:
109: END IF;
102: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
103: THEN
104:
105: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
106: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','step_number');
107: OE_MSG_PUB.Add;
108:
109: END IF;
110:
130:
131: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
132: THEN
133:
134: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
135: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','numeric_constant');
136: OE_MSG_PUB.Add;
137:
138: END IF;
131: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
132: THEN
133:
134: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
135: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','numeric_constant');
136: OE_MSG_PUB.Add;
137:
138: END IF;
139:
146:
147: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
148: THEN
149:
150: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
151: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line');
152: OE_MSG_PUB.Add;
153:
154: END IF;
147: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
148: THEN
149:
150: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
151: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line');
152: OE_MSG_PUB.Add;
153:
154: END IF;
155:
162:
163: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
164: THEN
165:
166: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
167: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_modifier_list');
168: OE_MSG_PUB.Add;
169:
170: END IF;
163: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
164: THEN
165:
166: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
167: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_modifier_list');
168: OE_MSG_PUB.Add;
169:
170: END IF;
171:
179:
180: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
181: THEN
182:
183: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
184: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute_context');
185: OE_MSG_PUB.Add;
186:
187: END IF;
180: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
181: THEN
182:
183: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
184: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute_context');
185: OE_MSG_PUB.Add;
186:
187: END IF;
188:
193:
194: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
195: THEN
196:
197: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
198: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute');
199: OE_MSG_PUB.Add;
200:
201: END IF;
194: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
195: THEN
196:
197: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
198: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute');
199: OE_MSG_PUB.Add;
200:
201: END IF;
202:
209:
210: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
211: THEN
212:
213: FND_MESSAGE.SET_NAME('QP','QP_INVALID_FORMULA_LINE_TYPE');
214: OE_MSG_PUB.Add;
215:
216: END IF;
217:
239:
240: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
241: THEN
242:
243: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_ATTRIBUTE');
244: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','step_number');
245: OE_MSG_PUB.Add;
246:
247: END IF;
240: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
241: THEN
242:
243: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_ATTRIBUTE');
244: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','step_number');
245: OE_MSG_PUB.Add;
246:
247: END IF;
248:
268:
269: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
270: THEN
271:
272: FND_MESSAGE.SET_NAME('QP','QP_INVALID_NUM_ATTRIBUTE');
273: OE_MSG_PUB.Add;
274:
275: END IF;
276: