eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_VALIDATE_FORMULA dependencies on FND_API

Line 17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

13: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
14: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: l_count NUMBER := 0;
19: l_cursor INTEGER;
20: l_check_formula VARCHAR2(1); --sfiresto
21: l_dummy_operand_tbl QP_FORMULA_RULES_PVT.t_Operand_Tbl_Type; --sfiresto

Line 32: l_return_status := FND_API.G_RET_STS_ERROR;

28:
29: IF p_FORMULA_rec.price_formula_id IS NULL
30: THEN
31:
32: l_return_status := FND_API.G_RET_STS_ERROR;
33:
34: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
35: THEN
36:

Line 52: l_return_status := FND_API.G_RET_STS_ERROR;

48:
49: IF p_FORMULA_rec.name IS NULL
50: THEN
51:
52: l_return_status := FND_API.G_RET_STS_ERROR;
53:
54: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
55: THEN
56:

Line 68: l_return_status := FND_API.G_RET_STS_ERROR;

64:
65: IF p_FORMULA_rec.formula IS NULL
66: THEN
67:
68: l_return_status := FND_API.G_RET_STS_ERROR;
69:
70: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
71: THEN
72:

Line 84: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

80:
81:
82: -- Return Error if a required attribute is missing.
83:
84: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
85:
86: RAISE FND_API.G_EXC_ERROR;
87:
88: END IF;

Line 86: RAISE FND_API.G_EXC_ERROR;

82: -- Return Error if a required attribute is missing.
83:
84: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
85:
86: RAISE FND_API.G_EXC_ERROR;
87:
88: END IF;
89:
90: -- Give warning message that dynamic formula package generater must be run if it is a new Formula

Line 122: l_return_status := FND_API.G_RET_STS_ERROR;

118: --Raises an exception if expression not valid
119: EXCEPTION
120:
121: WHEN OTHERS THEN
122: l_return_status := FND_API.G_RET_STS_ERROR;
123:
124: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
125: THEN
126:

Line 154: l_return_status := FND_API.G_RET_STS_ERROR;

150:
151: IF l_count > 0
152: THEN
153:
154: l_return_status := FND_API.G_RET_STS_ERROR;
155:
156: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
157: THEN
158:

Line 179: l_return_status := FND_API.G_RET_STS_ERROR;

175: nvl(p_FORMULA_rec.end_date_active,
176: TO_DATE('12-31-9999', 'MM-DD-YYYY'))
177: THEN
178:
179: l_return_status := FND_API.G_RET_STS_ERROR;
180:
181: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
182: THEN
183:

Line 193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

189: END IF;
190:
191: -- Return Error if dependent attribute is invalid.
192:
193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
194:
195: RAISE FND_API.G_EXC_ERROR;
196:
197: END IF;

Line 195: RAISE FND_API.G_EXC_ERROR;

191: -- Return Error if dependent attribute is invalid.
192:
193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
194:
195: RAISE FND_API.G_EXC_ERROR;
196:
197: END IF;
198:
199:

Line 207: WHEN FND_API.G_EXC_ERROR THEN

203:
204: oe_debug_pub.add('Leaving proc Entity in Formula Validation Pkg');
205: EXCEPTION
206:
207: WHEN FND_API.G_EXC_ERROR THEN
208:
209: x_return_status := FND_API.G_RET_STS_ERROR;
210:
211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 209: x_return_status := FND_API.G_RET_STS_ERROR;

205: EXCEPTION
206:
207: WHEN FND_API.G_EXC_ERROR THEN
208:
209: x_return_status := FND_API.G_RET_STS_ERROR;
210:
211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212:
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

207: WHEN FND_API.G_EXC_ERROR THEN
208:
209: x_return_status := FND_API.G_RET_STS_ERROR;
210:
211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212:
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214:
215: WHEN OTHERS THEN

Line 213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

209: x_return_status := FND_API.G_RET_STS_ERROR;
210:
211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212:
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214:
215: WHEN OTHERS THEN
216:
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214:
215: WHEN OTHERS THEN
216:
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218:
219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
220: THEN
221: OE_MSG_PUB.Add_Exc_Msg

Line 241: x_return_status := FND_API.G_RET_STS_SUCCESS;

237: IS
238: BEGIN
239:
240: oe_debug_pub.add('Entering proc Attributes in Formula Validation Pkg');
241: x_return_status := FND_API.G_RET_STS_SUCCESS;
242:
243: -- Validate FORMULA attributes
244:
245: IF p_FORMULA_rec.created_by IS NOT NULL AND

Line 251: x_return_status := FND_API.G_RET_STS_ERROR;

247: p_old_FORMULA_rec.created_by OR
248: p_old_FORMULA_rec.created_by IS NULL )
249: THEN
250: IF NOT QP_Validate.Created_By(p_FORMULA_rec.created_by) THEN
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: END IF;
253: END IF;
254:
255: IF p_FORMULA_rec.creation_date IS NOT NULL AND

Line 261: x_return_status := FND_API.G_RET_STS_ERROR;

257: p_old_FORMULA_rec.creation_date OR
258: p_old_FORMULA_rec.creation_date IS NULL )
259: THEN
260: IF NOT QP_Validate.Creation_Date(p_FORMULA_rec.creation_date) THEN
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: END IF;
263: END IF;
264:
265: IF p_FORMULA_rec.description IS NOT NULL AND

Line 271: x_return_status := FND_API.G_RET_STS_ERROR;

267: p_old_FORMULA_rec.description OR
268: p_old_FORMULA_rec.description IS NULL )
269: THEN
270: IF NOT QP_Validate.Description(p_FORMULA_rec.description) THEN
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: END IF;
273: END IF;
274:
275: IF p_FORMULA_rec.end_date_active IS NOT NULL AND

Line 281: x_return_status := FND_API.G_RET_STS_ERROR;

277: p_old_FORMULA_rec.end_date_active OR
278: p_old_FORMULA_rec.end_date_active IS NULL )
279: THEN
280: IF NOT QP_Validate.End_Date_Active(p_FORMULA_rec.end_date_active) THEN
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: END IF;
283: END IF;
284:
285: IF p_FORMULA_rec.formula IS NOT NULL AND

Line 291: x_return_status := FND_API.G_RET_STS_ERROR;

287: p_old_FORMULA_rec.formula OR
288: p_old_FORMULA_rec.formula IS NULL )
289: THEN
290: IF NOT QP_Validate.Formula(p_FORMULA_rec.formula) THEN
291: x_return_status := FND_API.G_RET_STS_ERROR;
292: END IF;
293: END IF;
294:
295: IF p_FORMULA_rec.last_updated_by IS NOT NULL AND

Line 301: x_return_status := FND_API.G_RET_STS_ERROR;

297: p_old_FORMULA_rec.last_updated_by OR
298: p_old_FORMULA_rec.last_updated_by IS NULL )
299: THEN
300: IF NOT QP_Validate.Last_Updated_By(p_FORMULA_rec.last_updated_by) THEN
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: END IF;
303: END IF;
304:
305: IF p_FORMULA_rec.last_update_date IS NOT NULL AND

Line 311: x_return_status := FND_API.G_RET_STS_ERROR;

307: p_old_FORMULA_rec.last_update_date OR
308: p_old_FORMULA_rec.last_update_date IS NULL )
309: THEN
310: IF NOT QP_Validate.Last_Update_Date(p_FORMULA_rec.last_update_date) THEN
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: END IF;
313: END IF;
314:
315: IF p_FORMULA_rec.last_update_login IS NOT NULL AND

Line 321: x_return_status := FND_API.G_RET_STS_ERROR;

317: p_old_FORMULA_rec.last_update_login OR
318: p_old_FORMULA_rec.last_update_login IS NULL )
319: THEN
320: IF NOT QP_Validate.Last_Update_Login(p_FORMULA_rec.last_update_login) THEN
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: END IF;
323: END IF;
324:
325: IF p_FORMULA_rec.name IS NOT NULL AND

Line 331: x_return_status := FND_API.G_RET_STS_ERROR;

327: p_old_FORMULA_rec.name OR
328: p_old_FORMULA_rec.name IS NULL )
329: THEN
330: IF NOT QP_Validate.Name(p_FORMULA_rec.name) THEN
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: END IF;
333: END IF;
334:
335: IF p_FORMULA_rec.price_formula_id IS NOT NULL AND

Line 341: x_return_status := FND_API.G_RET_STS_ERROR;

337: p_old_FORMULA_rec.price_formula_id OR
338: p_old_FORMULA_rec.price_formula_id IS NULL )
339: THEN
340: IF NOT QP_Validate.Price_Formula(p_FORMULA_rec.price_formula_id) THEN
341: x_return_status := FND_API.G_RET_STS_ERROR;
342: END IF;
343: END IF;
344:
345: IF p_FORMULA_rec.start_date_active IS NOT NULL AND

Line 351: x_return_status := FND_API.G_RET_STS_ERROR;

347: p_old_FORMULA_rec.start_date_active OR
348: p_old_FORMULA_rec.start_date_active IS NULL )
349: THEN
350: IF NOT QP_Validate.Start_Date_Active(p_FORMULA_rec.start_date_active) THEN
351: x_return_status := FND_API.G_RET_STS_ERROR;
352: END IF;
353: END IF;
354:
355: IF (p_FORMULA_rec.attribute1 IS NOT NULL AND

Line 493: x_return_status := FND_API.G_RET_STS_ERROR;

489:
490: -- Validate descriptive flexfield.
491:
492: IF NOT QP_Validate.Desc_Flex( 'FORMULA' ) THEN
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: END IF;
495:
496: END IF;
497:

Line 503: WHEN FND_API.G_EXC_ERROR THEN

499:
500: oe_debug_pub.add('Leaving proc Attributes in Formula Validation Pkg');
501: EXCEPTION
502:
503: WHEN FND_API.G_EXC_ERROR THEN
504:
505: x_return_status := FND_API.G_RET_STS_ERROR;
506:
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 505: x_return_status := FND_API.G_RET_STS_ERROR;

501: EXCEPTION
502:
503: WHEN FND_API.G_EXC_ERROR THEN
504:
505: x_return_status := FND_API.G_RET_STS_ERROR;
506:
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508:
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

503: WHEN FND_API.G_EXC_ERROR THEN
504:
505: x_return_status := FND_API.G_RET_STS_ERROR;
506:
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508:
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510:
511: WHEN OTHERS THEN

Line 509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

505: x_return_status := FND_API.G_RET_STS_ERROR;
506:
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508:
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510:
511: WHEN OTHERS THEN
512:
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510:
511: WHEN OTHERS THEN
512:
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514:
515: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
516: THEN
517: OE_MSG_PUB.Add_Exc_Msg

Line 532: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

528: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
529: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
530: )
531: IS
532: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
533: BEGIN
534:
535: oe_debug_pub.add('Entering proc Entity_Delete in Formula Validation Pkg');
536: -- Validate entity delete.

Line 547: WHEN FND_API.G_EXC_ERROR THEN

543:
544: oe_debug_pub.add('Leaving proc Entity_Delete in Formula Validation Pkg');
545: EXCEPTION
546:
547: WHEN FND_API.G_EXC_ERROR THEN
548:
549: x_return_status := FND_API.G_RET_STS_ERROR;
550:
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 549: x_return_status := FND_API.G_RET_STS_ERROR;

545: EXCEPTION
546:
547: WHEN FND_API.G_EXC_ERROR THEN
548:
549: x_return_status := FND_API.G_RET_STS_ERROR;
550:
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552:
553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

547: WHEN FND_API.G_EXC_ERROR THEN
548:
549: x_return_status := FND_API.G_RET_STS_ERROR;
550:
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552:
553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
554:
555: WHEN OTHERS THEN

Line 553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

549: x_return_status := FND_API.G_RET_STS_ERROR;
550:
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552:
553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
554:
555: WHEN OTHERS THEN
556:
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
554:
555: WHEN OTHERS THEN
556:
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558:
559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
560: THEN
561: OE_MSG_PUB.Add_Exc_Msg