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_LIMITS dependencies on FND_API

Line 34: x_return_status := FND_API.G_RET_STS_SUCCESS;

30: IF ((nvl(p_LIMITS_rec.multival_attr1_context,'NA') <> 'CUSTOMER') AND
31: (nvl(p_LIMITS_rec.multival_attr2_context,'NA') <> 'CUSTOMER'))
32: THEN
33: l_error_code := 0;
34: x_return_status := FND_API.G_RET_STS_SUCCESS;
35: return;
36: ELSE
37: x_return_status := FND_API.G_RET_STS_ERROR;
38: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_NOT_ALLOWED');

Line 37: x_return_status := FND_API.G_RET_STS_ERROR;

33: l_error_code := 0;
34: x_return_status := FND_API.G_RET_STS_SUCCESS;
35: return;
36: ELSE
37: x_return_status := FND_API.G_RET_STS_ERROR;
38: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_NOT_ALLOWED');
39: OE_MSG_PUB.Add;
40: l_error_code := 1;
41: return;

Line 44: x_return_status := FND_API.G_RET_STS_ERROR;

40: l_error_code := 1;
41: return;
42: END IF;
43: ELSE
44: x_return_status := FND_API.G_RET_STS_ERROR;
45: FND_MESSAGE.SET_NAME('QP','QP_ORG_NOT_ALLOWED');
46: OE_MSG_PUB.Add;
47: l_error_code := 1;
48: return;

Line 52: x_return_status := FND_API.G_RET_STS_ERROR;

48: return;
49: END IF;
50: END IF;
51: ELSE
52: x_return_status := FND_API.G_RET_STS_ERROR;
53: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
54: OE_MSG_PUB.Add;
55: l_error_code := 1;
56: return;

Line 75: x_return_status := FND_API.G_RET_STS_SUCCESS;

71: IF ((nvl(p_LIMITS_rec.multival_attr1_context,'NA') <> 'CUSTOMER') AND
72: (nvl(p_LIMITS_rec.multival_attr2_context,'NA') <> 'CUSTOMER'))
73: THEN
74: l_error_code := 0;
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76: return;
77: ELSE
78: x_return_status := FND_API.G_RET_STS_ERROR;
79: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_NOT_ALLOWED');

Line 78: x_return_status := FND_API.G_RET_STS_ERROR;

74: l_error_code := 0;
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76: return;
77: ELSE
78: x_return_status := FND_API.G_RET_STS_ERROR;
79: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_NOT_ALLOWED');
80: OE_MSG_PUB.Add;
81: l_error_code := 1;
82: return;

Line 85: x_return_status := FND_API.G_RET_STS_ERROR;

81: l_error_code := 1;
82: return;
83: END IF;
84: ELSE
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: FND_MESSAGE.SET_NAME('QP','QP_ORG_NOT_ALLOWED');
87: OE_MSG_PUB.Add;
88: l_error_code := 1;
89: return;

Line 93: x_return_status := FND_API.G_RET_STS_ERROR;

89: return;
90: END IF;
91: END IF;
92: ELSE
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
95: OE_MSG_PUB.Add;
96: l_error_code := 1;
97: return;

Line 105: l_return_status := FND_API.G_RET_STS_SUCCESS;

101: END IF;
102:
103: IF l_error_code = 0 -- Validation Passed
104: THEN
105: l_return_status := FND_API.G_RET_STS_SUCCESS;
106:
107: END IF;
108:
109: --Done validating List Header Limits

Line 117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

113: EXCEPTION
114:
115: WHEN OTHERS THEN
116:
117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
118:
119: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
120: THEN
121: OE_MSG_PUB.Add_Exc_Msg

Line 225: x_return_status := FND_API.G_RET_STS_SUCCESS;

221: AND
222: (nvl(p_LIMITS_rec.multival_attr2_context,'NA') <> 'ITEM'))
223: THEN
224: l_error_code := 0;
225: x_return_status := FND_API.G_RET_STS_SUCCESS;
226: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 6' || 'l_error_code = ' || l_error_code);
227: return;
228: ELSE
229: x_return_status := FND_API.G_RET_STS_ERROR;

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225: x_return_status := FND_API.G_RET_STS_SUCCESS;
226: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 6' || 'l_error_code = ' || l_error_code);
227: return;
228: ELSE
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');
231: OE_MSG_PUB.Add;
232: l_error_code := 1;
233: return;

Line 248: x_return_status := FND_API.G_RET_STS_SUCCESS;

244: AND
245: (nvl(p_LIMITS_rec.multival_attr2_context,'NA') <> 'ITEM'))
246: THEN
247: l_error_code := 0;
248: x_return_status := FND_API.G_RET_STS_SUCCESS;
249: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 7' || 'l_error_code = ' || l_errorde);
250: return;
251: ELSE
252: x_return_status := FND_API.G_RET_STS_ERROR;

Line 252: x_return_status := FND_API.G_RET_STS_ERROR;

248: x_return_status := FND_API.G_RET_STS_SUCCESS;
249: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 7' || 'l_error_code = ' || l_errorde);
250: return;
251: ELSE
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');
254: OE_MSG_PUB.Add;
255: l_error_code := 1;
256: return;

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

255: l_error_code := 1;
256: return;
257: END IF;
258: ELSE
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');
261: OE_MSG_PUB.Add;
262: l_error_code := 1;
263: return;

Line 267: x_return_status := FND_API.G_RET_STS_ERROR;

263: return;
264: END IF;
265: END IF;
266: ELSE
267: x_return_status := FND_API.G_RET_STS_ERROR;
268: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
269: OE_MSG_PUB.Add;
270: l_error_code := 1;
271: return;

Line 292: x_return_status := FND_API.G_RET_STS_SUCCESS;

288: AND
289: (nvl(p_LIMITS_rec.multival_attr2_context,'NA') <> 'ITEM'))
290: THEN
291: l_error_code := 0;
292: x_return_status := FND_API.G_RET_STS_SUCCESS;
293: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 3' || 'l_error_code = ' || l_error_code);
294: return;
295: ELSE
296: x_return_status := FND_API.G_RET_STS_ERROR;

Line 296: x_return_status := FND_API.G_RET_STS_ERROR;

292: x_return_status := FND_API.G_RET_STS_SUCCESS;
293: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 3' || 'l_error_code = ' || l_error_code);
294: return;
295: ELSE
296: x_return_status := FND_API.G_RET_STS_ERROR;
297: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');
298: OE_MSG_PUB.Add;
299: l_error_code := 1;
300: return;

Line 315: x_return_status := FND_API.G_RET_STS_SUCCESS;

311: AND
312: (nvl(p_LIMITS_rec.multival_attr2_context,'NA') <> 'ITEM'))
313: THEN
314: l_error_code := 0;
315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 4' || 'l_error_code = ' || l_error_code);
317: return;
318: ELSE
319: x_return_status := FND_API.G_RET_STS_ERROR;

Line 319: x_return_status := FND_API.G_RET_STS_ERROR;

315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 4' || 'l_error_code = ' || l_error_code);
317: return;
318: ELSE
319: x_return_status := FND_API.G_RET_STS_ERROR;
320: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');
321: OE_MSG_PUB.Add;
322: l_error_code := 1;
323: return;

Line 326: x_return_status := FND_API.G_RET_STS_ERROR;

322: l_error_code := 1;
323: return;
324: END IF;
325: ELSE
326: x_return_status := FND_API.G_RET_STS_ERROR;
327: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');
328: OE_MSG_PUB.Add;
329: l_error_code := 1;
330: return;

Line 334: x_return_status := FND_API.G_RET_STS_ERROR;

330: return;
331: END IF;
332: END IF;
333: ELSE
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
336: OE_MSG_PUB.Add;
337: l_error_code := 1;
338: return;

Line 358: x_return_status := FND_API.G_RET_STS_SUCCESS;

354: AND
355: (nvl(p_LIMITS_rec.multival_attr2_context,'NA') <> 'ITEM'))
356: THEN
357: l_error_code := 0;
358: x_return_status := FND_API.G_RET_STS_SUCCESS;
359: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 9' || 'l_error_code = ' || l_error_code);
360: return;
361: ELSE
362: x_return_status := FND_API.G_RET_STS_ERROR;

Line 362: x_return_status := FND_API.G_RET_STS_ERROR;

358: x_return_status := FND_API.G_RET_STS_SUCCESS;
359: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 9' || 'l_error_code = ' || l_error_code);
360: return;
361: ELSE
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');
364: OE_MSG_PUB.Add;
365: l_error_code := 1;
366: return;

Line 369: x_return_status := FND_API.G_RET_STS_ERROR;

365: l_error_code := 1;
366: return;
367: END IF;
368: ELSE
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');
371: OE_MSG_PUB.Add;
372: l_error_code := 1;
373: return;

Line 376: x_return_status := FND_API.G_RET_STS_ERROR;

372: l_error_code := 1;
373: return;
374: END IF;
375: ELSE
376: x_return_status := FND_API.G_RET_STS_ERROR;
377: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
378: OE_MSG_PUB.Add;
379: l_error_code := 1;
380: return;

Line 398: x_return_status := FND_API.G_RET_STS_SUCCESS;

394: AND
395: (nvl(p_LIMITS_rec.multival_attr2_context,'NA') <> 'ITEM'))
396: THEN
397: l_error_code := 0;
398: x_return_status := FND_API.G_RET_STS_SUCCESS;
399: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 10' || 'l_error_code = ' || l_error_code);
400: return;
401: ELSE
402: x_return_status := FND_API.G_RET_STS_ERROR;

Line 402: x_return_status := FND_API.G_RET_STS_ERROR;

398: x_return_status := FND_API.G_RET_STS_SUCCESS;
399: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 10' || 'l_error_code = ' || l_error_code);
400: return;
401: ELSE
402: x_return_status := FND_API.G_RET_STS_ERROR;
403: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');
404: OE_MSG_PUB.Add;
405: l_error_code := 1;
406: return;

Line 409: x_return_status := FND_API.G_RET_STS_ERROR;

405: l_error_code := 1;
406: return;
407: END IF;
408: ELSE
409: x_return_status := FND_API.G_RET_STS_ERROR;
410: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');
411: OE_MSG_PUB.Add;
412: l_error_code := 1;
413: return;

Line 416: x_return_status := FND_API.G_RET_STS_ERROR;

412: l_error_code := 1;
413: return;
414: END IF;
415: ELSE
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
418: OE_MSG_PUB.Add;
419: l_error_code := 1;
420: return;

Line 438: x_return_status := FND_API.G_RET_STS_SUCCESS;

434: AND
435: (nvl(p_LIMITS_rec.multival_attr2_context,'NA') <> 'ITEM'))
436: THEN
437: l_error_code := 0;
438: x_return_status := FND_API.G_RET_STS_SUCCESS;
439: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 11' || 'l_error_code = ' || l_error_code);
440: return;
441: ELSE
442: x_return_status := FND_API.G_RET_STS_ERROR;

Line 442: x_return_status := FND_API.G_RET_STS_ERROR;

438: x_return_status := FND_API.G_RET_STS_SUCCESS;
439: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 11' || 'l_error_code = ' || l_error_code);
440: return;
441: ELSE
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');
444: OE_MSG_PUB.Add;
445: l_error_code := 1;
446: return;

Line 449: x_return_status := FND_API.G_RET_STS_ERROR;

445: l_error_code := 1;
446: return;
447: END IF;
448: ELSE
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');
451: OE_MSG_PUB.Add;
452: l_error_code := 1;
453: return;

Line 456: x_return_status := FND_API.G_RET_STS_ERROR;

452: l_error_code := 1;
453: return;
454: END IF;
455: ELSE
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
458: OE_MSG_PUB.Add;
459: l_error_code := 1;
460: return;

Line 478: x_return_status := FND_API.G_RET_STS_SUCCESS;

474: AND
475: (nvl(p_LIMITS_rec.multival_attr2_context,'NA') <> 'ITEM'))
476: THEN
477: l_error_code := 0;
478: x_return_status := FND_API.G_RET_STS_SUCCESS;
479: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 12' || 'l_error_code = ' || l_error_code);
480: return;
481: ELSE
482: x_return_status := FND_API.G_RET_STS_ERROR;

Line 482: x_return_status := FND_API.G_RET_STS_ERROR;

478: x_return_status := FND_API.G_RET_STS_SUCCESS;
479: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 12' || 'l_error_code = ' || l_error_code);
480: return;
481: ELSE
482: x_return_status := FND_API.G_RET_STS_ERROR;
483: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');
484: OE_MSG_PUB.Add;
485: l_error_code := 1;
486: return;

Line 489: x_return_status := FND_API.G_RET_STS_ERROR;

485: l_error_code := 1;
486: return;
487: END IF;
488: ELSE
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');
491: OE_MSG_PUB.Add;
492: l_error_code := 1;
493: return;

Line 496: x_return_status := FND_API.G_RET_STS_ERROR;

492: l_error_code := 1;
493: return;
494: END IF;
495: ELSE
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
498: OE_MSG_PUB.Add;
499: l_error_code := 1;
500: return;

Line 513: x_return_status := FND_API.G_RET_STS_SUCCESS;

509: IF (l_non_monetary_accrual = true) THEN
510: IF (l_application_method IN ('AMT','LUMPSUM')) THEN
511: IF (p_LIMITS_rec.basis IN ('GROSS_REVENUE','ACCRUAL','USAGE','QUANTITY')) THEN
512: l_error_code := 0;
513: x_return_status := FND_API.G_RET_STS_SUCCESS;
514: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 17' || 'l_error_code = ' || l_error_code);
515: return;
516: ELSE
517: x_return_status := FND_API.G_RET_STS_ERROR;

Line 517: x_return_status := FND_API.G_RET_STS_ERROR;

513: x_return_status := FND_API.G_RET_STS_SUCCESS;
514: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 17' || 'l_error_code = ' || l_error_code);
515: return;
516: ELSE
517: x_return_status := FND_API.G_RET_STS_ERROR;
518: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
519: OE_MSG_PUB.Add;
520: l_error_code := 1;
521: return;

Line 524: x_return_status := FND_API.G_RET_STS_ERROR;

520: l_error_code := 1;
521: return;
522: END IF;
523: ELSE
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
526: OE_MSG_PUB.Add;
527: l_error_code := 1;
528: return;

Line 543: x_return_status := FND_API.G_RET_STS_SUCCESS;

539: THEN
540: IF (p_LIMITS_rec.basis IN ('GROSS_REVENUE','COST','USAGE','QUANTITY'))
541: THEN
542: l_error_code := 0;
543: x_return_status := FND_API.G_RET_STS_SUCCESS;
544: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 13' || 'l_error_code = ' || l_error_code);
545: return;
546: ELSE
547: x_return_status := FND_API.G_RET_STS_ERROR;

Line 547: x_return_status := FND_API.G_RET_STS_ERROR;

543: x_return_status := FND_API.G_RET_STS_SUCCESS;
544: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 13' || 'l_error_code = ' || l_error_code);
545: return;
546: ELSE
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
549: OE_MSG_PUB.Add;
550: l_error_code := 1;
551: return;

Line 562: x_return_status := FND_API.G_RET_STS_SUCCESS;

558: THEN
559: IF (p_LIMITS_rec.basis IN ('GROSS_REVENUE','COST','USAGE','QUANTITY'))
560: THEN
561: l_error_code := 0;
562: x_return_status := FND_API.G_RET_STS_SUCCESS;
563: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 14' || 'l_error_code = ' || l_error_code);
564: return;
565: ELSE
566: x_return_status := FND_API.G_RET_STS_ERROR;

Line 566: x_return_status := FND_API.G_RET_STS_ERROR;

562: x_return_status := FND_API.G_RET_STS_SUCCESS;
563: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 14' || 'l_error_code = ' || l_error_code);
564: return;
565: ELSE
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
568: OE_MSG_PUB.Add;
569: l_error_code := 1;
570: return;

Line 584: x_return_status := FND_API.G_RET_STS_SUCCESS;

580: THEN
581: IF (p_LIMITS_rec.basis IN ('GROSS_REVENUE','COST','USAGE','QUANTITY'))
582: THEN
583: l_error_code := 0;
584: x_return_status := FND_API.G_RET_STS_SUCCESS;
585: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 15' || 'l_error_code = ' || l_error_code);
586: return;
587: ELSE
588: x_return_status := FND_API.G_RET_STS_ERROR;

Line 588: x_return_status := FND_API.G_RET_STS_ERROR;

584: x_return_status := FND_API.G_RET_STS_SUCCESS;
585: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 15' || 'l_error_code = ' || l_error_code);
586: return;
587: ELSE
588: x_return_status := FND_API.G_RET_STS_ERROR;
589: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
590: OE_MSG_PUB.Add;
591: l_error_code := 1;
592: return;

Line 603: x_return_status := FND_API.G_RET_STS_SUCCESS;

599: THEN
600: IF (p_LIMITS_rec.basis IN ('GROSS_REVENUE','COST','USAGE','QUANTITY'))
601: THEN
602: l_error_code := 0;
603: x_return_status := FND_API.G_RET_STS_SUCCESS;
604: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 16' || 'l_error_code = ' || l_error_code);
605: return;
606: ELSE
607: x_return_status := FND_API.G_RET_STS_ERROR;

Line 607: x_return_status := FND_API.G_RET_STS_ERROR;

603: x_return_status := FND_API.G_RET_STS_SUCCESS;
604: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 16' || 'l_error_code = ' || l_error_code);
605: return;
606: ELSE
607: x_return_status := FND_API.G_RET_STS_ERROR;
608: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
609: OE_MSG_PUB.Add;
610: l_error_code := 1;
611: return;

Line 624: x_return_status := FND_API.G_RET_STS_SUCCESS;

620: THEN
621: IF (p_LIMITS_rec.basis IN ('GROSS_REVENUE','CHARGE','USAGE','QUANTITY'))
622: THEN
623: l_error_code := 0;
624: x_return_status := FND_API.G_RET_STS_SUCCESS;
625: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 18' || 'l_error_code = ' || l_error_code);
626: return;
627: ELSE
628: x_return_status := FND_API.G_RET_STS_ERROR;

Line 628: x_return_status := FND_API.G_RET_STS_ERROR;

624: x_return_status := FND_API.G_RET_STS_SUCCESS;
625: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 18' || 'l_error_code = ' || l_error_code);
626: return;
627: ELSE
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
630: OE_MSG_PUB.Add;
631: l_error_code := 1;
632: return;

Line 643: x_return_status := FND_API.G_RET_STS_SUCCESS;

639: THEN
640: IF (p_LIMITS_rec.basis IN ('GROSS_REVENUE','COST','USAGE'))
641: THEN
642: l_error_code := 0;
643: x_return_status := FND_API.G_RET_STS_SUCCESS;
644: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 19' || 'l_error_code = ' || l_error_code);
645: return;
646: ELSE
647: x_return_status := FND_API.G_RET_STS_ERROR;

Line 647: x_return_status := FND_API.G_RET_STS_ERROR;

643: x_return_status := FND_API.G_RET_STS_SUCCESS;
644: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 19' || 'l_error_code = ' || l_error_code);
645: return;
646: ELSE
647: x_return_status := FND_API.G_RET_STS_ERROR;
648: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
649: OE_MSG_PUB.Add;
650: l_error_code := 1;
651: return;

Line 662: x_return_status := FND_API.G_RET_STS_SUCCESS;

658: THEN
659: IF (p_LIMITS_rec.basis IN ('GROSS_REVENUE','COST','USAGE','ACCRUAL','QUANTITY'))
660: THEN
661: l_error_code := 0;
662: x_return_status := FND_API.G_RET_STS_SUCCESS;
663: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 20' || 'l_error_code = ' || l_error_code);
664: return;
665: ELSE
666: x_return_status := FND_API.G_RET_STS_ERROR;

Line 666: x_return_status := FND_API.G_RET_STS_ERROR;

662: x_return_status := FND_API.G_RET_STS_SUCCESS;
663: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 20' || 'l_error_code = ' || l_error_code);
664: return;
665: ELSE
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
668: OE_MSG_PUB.Add;
669: l_error_code := 1;
670: return;

Line 681: x_return_status := FND_API.G_RET_STS_SUCCESS;

677: THEN
678: IF (p_LIMITS_rec.basis IN ('GROSS_REVENUE','COST','USAGE'))
679: THEN
680: l_error_code := 0;
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 21' || 'l_error_code = ' || l_error_code);
683: return;
684: ELSE
685: x_return_status := FND_API.G_RET_STS_ERROR;

Line 685: x_return_status := FND_API.G_RET_STS_ERROR;

681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 21' || 'l_error_code = ' || l_error_code);
683: return;
684: ELSE
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
687: OE_MSG_PUB.Add;
688: l_error_code := 1;
689: return;

Line 699: l_return_status := FND_API.G_RET_STS_SUCCESS;

695: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY ' || 'l_error_code = ' || l_error_code);
696:
697: IF (l_error_code = 0) -- Validation Passed
698: THEN
699: l_return_status := FND_API.G_RET_STS_SUCCESS;
700: END IF;
701:
702: --Done validating List Line Limits
703:

Line 710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

706: EXCEPTION
707:
708: WHEN OTHERS THEN
709:
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711:
712: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
713: THEN
714: OE_MSG_PUB.Add_Exc_Msg

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

727: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
728: QP_Limits_PUB.G_MISS_LIMITS_REC
729: )
730: IS
731: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
732: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
733: BEGIN
734: l_LIMITS_rec := p_LIMITS_rec;
735: -- Check required attributes.

Line 740: l_return_status := FND_API.G_RET_STS_ERROR;

736:
737: IF p_LIMITS_rec.limit_id IS NULL
738: THEN
739:
740: l_return_status := FND_API.G_RET_STS_ERROR;
741:
742: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
743: THEN
744:

Line 760: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

756:
757:
758: -- Return Error if a required attribute is missing.
759:
760: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
761:
762: RAISE FND_API.G_EXC_ERROR;
763:
764: END IF;

Line 762: RAISE FND_API.G_EXC_ERROR;

758: -- Return Error if a required attribute is missing.
759:
760: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
761:
762: RAISE FND_API.G_EXC_ERROR;
763:
764: END IF;
765:
766: --

Line 793: WHEN FND_API.G_EXC_ERROR THEN

789: x_return_status := l_return_status;
790:
791: EXCEPTION
792:
793: WHEN FND_API.G_EXC_ERROR THEN
794:
795: x_return_status := FND_API.G_RET_STS_ERROR;
796:
797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 795: x_return_status := FND_API.G_RET_STS_ERROR;

791: EXCEPTION
792:
793: WHEN FND_API.G_EXC_ERROR THEN
794:
795: x_return_status := FND_API.G_RET_STS_ERROR;
796:
797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
798:
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

793: WHEN FND_API.G_EXC_ERROR THEN
794:
795: x_return_status := FND_API.G_RET_STS_ERROR;
796:
797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
798:
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800:
801: WHEN OTHERS THEN

Line 799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

795: x_return_status := FND_API.G_RET_STS_ERROR;
796:
797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
798:
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800:
801: WHEN OTHERS THEN
802:
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800:
801: WHEN OTHERS THEN
802:
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804:
805: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
806: THEN
807: OE_MSG_PUB.Add_Exc_Msg

Line 826: x_return_status := FND_API.G_RET_STS_SUCCESS;

822: )
823: IS
824: BEGIN
825:
826: x_return_status := FND_API.G_RET_STS_SUCCESS;
827:
828: --dbms_output.put_line('Inside QP_Validate_Limits.Attributes ' || x_return_status);
829: -- Validate LIMITS attributes
830: IF p_LIMITS_rec.amount IS NOT NULL AND

Line 836: x_return_status := FND_API.G_RET_STS_ERROR;

832: p_old_LIMITS_rec.amount OR
833: p_old_LIMITS_rec.amount IS NULL )
834: THEN
835: IF NOT QP_Validate.Amount(p_LIMITS_rec.amount) THEN
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: END IF;
838: --dbms_output.put_line('Inside QP_Validate.Amount ' || x_return_status);
839: END IF;
840:

Line 847: x_return_status := FND_API.G_RET_STS_ERROR;

843: p_old_LIMITS_rec.basis OR
844: p_old_LIMITS_rec.basis IS NULL )
845: THEN
846: IF NOT QP_Validate.Basis(p_LIMITS_rec.basis) THEN
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: END IF;
849: --dbms_output.put_line('Inside QP_Validate.Basis ' || x_return_status);
850: END IF;
851:

Line 858: x_return_status := FND_API.G_RET_STS_ERROR;

854: p_old_LIMITS_rec.created_by OR
855: p_old_LIMITS_rec.created_by IS NULL )
856: THEN
857: IF NOT QP_Validate.Created_By(p_LIMITS_rec.created_by) THEN
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: END IF;
860: --dbms_output.put_line('Inside QP_Validate.created_by ' || x_return_status);
861: END IF;
862:

Line 869: x_return_status := FND_API.G_RET_STS_ERROR;

865: p_old_LIMITS_rec.creation_date OR
866: p_old_LIMITS_rec.creation_date IS NULL )
867: THEN
868: IF NOT QP_Validate.Creation_Date(p_LIMITS_rec.creation_date) THEN
869: x_return_status := FND_API.G_RET_STS_ERROR;
870: END IF;
871: --dbms_output.put_line('Inside QP_Validate.Creation_Date ' || x_return_status);
872: END IF;
873:

Line 880: x_return_status := FND_API.G_RET_STS_ERROR;

876: p_old_LIMITS_rec.last_updated_by OR
877: p_old_LIMITS_rec.last_updated_by IS NULL )
878: THEN
879: IF NOT QP_Validate.Last_Updated_By(p_LIMITS_rec.last_updated_by) THEN
880: x_return_status := FND_API.G_RET_STS_ERROR;
881: END IF;
882: --dbms_output.put_line('Inside QP_Validate.Last_Updated_By ' || x_return_status);
883: END IF;
884:

Line 891: x_return_status := FND_API.G_RET_STS_ERROR;

887: p_old_LIMITS_rec.last_update_date OR
888: p_old_LIMITS_rec.last_update_date IS NULL )
889: THEN
890: IF NOT QP_Validate.Last_Update_Date(p_LIMITS_rec.last_update_date) THEN
891: x_return_status := FND_API.G_RET_STS_ERROR;
892: END IF;
893: --dbms_output.put_line('Inside QP_Validate.Last_Update_Date ' || x_return_status);
894: END IF;
895:

Line 902: x_return_status := FND_API.G_RET_STS_ERROR;

898: p_old_LIMITS_rec.last_update_login OR
899: p_old_LIMITS_rec.last_update_login IS NULL )
900: THEN
901: IF NOT QP_Validate.Last_Update_Login(p_LIMITS_rec.last_update_login) THEN
902: x_return_status := FND_API.G_RET_STS_ERROR;
903: END IF;
904: --dbms_output.put_line('Inside QP_Validate.last_update_login ' || x_return_status);
905: END IF;
906:

Line 913: x_return_status := FND_API.G_RET_STS_ERROR;

909: p_old_LIMITS_rec.limit_exceed_action_code OR
910: p_old_LIMITS_rec.limit_exceed_action_code IS NULL )
911: THEN
912: IF NOT QP_Validate.Limit_Exceed_Action(p_LIMITS_rec.limit_exceed_action_code) THEN
913: x_return_status := FND_API.G_RET_STS_ERROR;
914: END IF;
915: --dbms_output.put_line('Inside QP_Validate.Limit_Exceed_Action ' || x_return_status);
916: END IF;
917:

Line 924: x_return_status := FND_API.G_RET_STS_ERROR;

920: p_old_LIMITS_rec.limit_hold_flag OR
921: p_old_LIMITS_rec.limit_hold_flag IS NULL )
922: THEN
923: IF NOT QP_Validate.LIMIT_HOLD(p_LIMITS_rec.limit_hold_flag) THEN
924: x_return_status := FND_API.G_RET_STS_ERROR;
925: END IF;
926: --dbms_output.put_line('Inside QP_Validate.LIMIT_HOLD ' || x_return_status);
927: END IF;
928:

Line 935: x_return_status := FND_API.G_RET_STS_ERROR;

931: p_old_LIMITS_rec.limit_id OR
932: p_old_LIMITS_rec.limit_id IS NULL )
933: THEN
934: IF NOT QP_Validate.Limit(p_LIMITS_rec.limit_id) THEN
935: x_return_status := FND_API.G_RET_STS_ERROR;
936: END IF;
937: --dbms_output.put_line('Inside QP_Validate.limit_id ' || x_return_status);
938: END IF;
939:

Line 946: x_return_status := FND_API.G_RET_STS_ERROR;

942: p_old_LIMITS_rec.limit_level_code OR
943: p_old_LIMITS_rec.limit_level_code IS NULL )
944: THEN
945: IF NOT QP_Validate.Limit_Level(p_LIMITS_rec.limit_level_code) THEN
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: END IF;
948: --dbms_output.put_line('Inside QP_Validate.Limit_Level ' || x_return_status);
949: END IF;
950:

Line 957: x_return_status := FND_API.G_RET_STS_ERROR;

953: p_old_LIMITS_rec.limit_number OR
954: p_old_LIMITS_rec.limit_number IS NULL )
955: THEN
956: IF NOT QP_Validate.Limit_Number(p_LIMITS_rec.limit_number) THEN
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: END IF;
959: --dbms_output.put_line('Inside QP_Validate.Limit_Number ' || x_return_status);
960: END IF;
961:

Line 968: x_return_status := FND_API.G_RET_STS_ERROR;

964: p_old_LIMITS_rec.list_header_id OR
965: p_old_LIMITS_rec.list_header_id IS NULL )
966: THEN
967: IF NOT QP_Validate.List_Header(p_LIMITS_rec.list_header_id) THEN
968: x_return_status := FND_API.G_RET_STS_ERROR;
969: END IF;
970: --dbms_output.put_line('Inside QP_Validate.List_Header ' || x_return_status);
971: END IF;
972:

Line 979: x_return_status := FND_API.G_RET_STS_ERROR;

975: p_old_LIMITS_rec.list_line_id OR
976: p_old_LIMITS_rec.list_line_id IS NULL )
977: THEN
978: IF NOT QP_Validate.List_Line(p_LIMITS_rec.list_line_id) THEN
979: x_return_status := FND_API.G_RET_STS_ERROR;
980: END IF;
981: --dbms_output.put_line('Inside QP_Validate.List_Line ' || x_return_status);
982: END IF;
983:

Line 990: x_return_status := FND_API.G_RET_STS_ERROR;

986: p_old_LIMITS_rec.multival_attr1_type OR
987: p_old_LIMITS_rec.multival_attr1_type IS NULL )
988: THEN
989: IF NOT QP_Validate.Multival_Attr1_Type(p_LIMITS_rec.multival_attr1_type) THEN
990: x_return_status := FND_API.G_RET_STS_ERROR;
991: END IF;
992: END IF;
993:
994: IF p_LIMITS_rec.multival_attr1_context IS NOT NULL AND

Line 1000: x_return_status := FND_API.G_RET_STS_ERROR;

996: p_old_LIMITS_rec.multival_attr1_context OR
997: p_old_LIMITS_rec.multival_attr1_context IS NULL )
998: THEN
999: IF NOT QP_Validate.Multival_Attr1_Context(p_LIMITS_rec.multival_attr1_context) THEN
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: END IF;
1002: END IF;
1003:
1004: IF p_LIMITS_rec.multival_attribute2 IS NOT NULL AND

Line 1010: x_return_status := FND_API.G_RET_STS_ERROR;

1006: p_old_LIMITS_rec.multival_attribute2 OR
1007: p_old_LIMITS_rec.multival_attribute2 IS NULL )
1008: THEN
1009: IF NOT QP_Validate.Multival_Attribute2(p_LIMITS_rec.multival_attribute2) THEN
1010: x_return_status := FND_API.G_RET_STS_ERROR;
1011: END IF;
1012: END IF;
1013:
1014: IF p_LIMITS_rec.multival_attr1_datatype IS NOT NULL AND

Line 1020: x_return_status := FND_API.G_RET_STS_ERROR;

1016: p_old_LIMITS_rec.multival_attr1_datatype OR
1017: p_old_LIMITS_rec.multival_attr1_datatype IS NULL )
1018: THEN
1019: IF NOT QP_Validate.Multival_Attr1_Datatype(p_LIMITS_rec.multival_attr1_datatype) THEN
1020: x_return_status := FND_API.G_RET_STS_ERROR;
1021: END IF;
1022: END IF;
1023:
1024: IF p_LIMITS_rec.multival_attr2_type IS NOT NULL AND

Line 1030: x_return_status := FND_API.G_RET_STS_ERROR;

1026: p_old_LIMITS_rec.multival_attr2_type OR
1027: p_old_LIMITS_rec.multival_attr2_type IS NULL )
1028: THEN
1029: IF NOT QP_Validate.Multival_Attr2_Type(p_LIMITS_rec.multival_attr2_type) THEN
1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: END IF;
1032: END IF;
1033:
1034: IF p_LIMITS_rec.multival_attr2_context IS NOT NULL AND

Line 1040: x_return_status := FND_API.G_RET_STS_ERROR;

1036: p_old_LIMITS_rec.multival_attr2_context OR
1037: p_old_LIMITS_rec.multival_attr2_context IS NULL )
1038: THEN
1039: IF NOT QP_Validate.Multival_Attr2_Context(p_LIMITS_rec.multival_attr2_context) THEN
1040: x_return_status := FND_API.G_RET_STS_ERROR;
1041: END IF;
1042: END IF;
1043:
1044: IF p_LIMITS_rec.multival_attribute2 IS NOT NULL AND

Line 1050: x_return_status := FND_API.G_RET_STS_ERROR;

1046: p_old_LIMITS_rec.multival_attribute2 OR
1047: p_old_LIMITS_rec.multival_attribute2 IS NULL )
1048: THEN
1049: IF NOT QP_Validate.Multival_Attribute2(p_LIMITS_rec.multival_attribute2) THEN
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: END IF;
1052: END IF;
1053:
1054: IF p_LIMITS_rec.multival_attr2_datatype IS NOT NULL AND

Line 1060: x_return_status := FND_API.G_RET_STS_ERROR;

1056: p_old_LIMITS_rec.multival_attr2_datatype OR
1057: p_old_LIMITS_rec.multival_attr2_datatype IS NULL )
1058: THEN
1059: IF NOT QP_Validate.Multival_Attr2_Datatype(p_LIMITS_rec.multival_attr2_datatype) THEN
1060: x_return_status := FND_API.G_RET_STS_ERROR;
1061: END IF;
1062: END IF;
1063:
1064: IF p_LIMITS_rec.organization_flag IS NOT NULL AND

Line 1070: x_return_status := FND_API.G_RET_STS_ERROR;

1066: p_old_LIMITS_rec.organization_flag OR
1067: p_old_LIMITS_rec.organization_flag IS NULL )
1068: THEN
1069: IF NOT QP_Validate.Organization(p_LIMITS_rec.organization_flag) THEN
1070: x_return_status := FND_API.G_RET_STS_ERROR;
1071: END IF;
1072: --dbms_output.put_line('Inside QP_Validate.Organization ' || x_return_status);
1073: END IF;
1074:

Line 1082: x_return_status := FND_API.G_RET_STS_ERROR;

1078: p_old_LIMITS_rec.program_application_id OR
1079: p_old_LIMITS_rec.program_application_id IS NULL )
1080: THEN
1081: IF NOT QP_Validate.Program_Application(p_LIMITS_rec.program_application_id) THEN
1082: x_return_status := FND_API.G_RET_STS_ERROR;
1083: END IF;
1084: END IF;
1085:
1086: IF p_LIMITS_rec.program_id IS NOT NULL AND

Line 1092: x_return_status := FND_API.G_RET_STS_ERROR;

1088: p_old_LIMITS_rec.program_id OR
1089: p_old_LIMITS_rec.program_id IS NULL )
1090: THEN
1091: IF NOT QP_Validate.Program(p_LIMITS_rec.program_id) THEN
1092: x_return_status := FND_API.G_RET_STS_ERROR;
1093: END IF;
1094: END IF;
1095:
1096: IF p_LIMITS_rec.program_update_date IS NOT NULL AND

Line 1102: x_return_status := FND_API.G_RET_STS_ERROR;

1098: p_old_LIMITS_rec.program_update_date OR
1099: p_old_LIMITS_rec.program_update_date IS NULL )
1100: THEN
1101: IF NOT QP_Validate.Program_Update_Date(p_LIMITS_rec.program_update_date) THEN
1102: x_return_status := FND_API.G_RET_STS_ERROR;
1103: END IF;
1104: END IF;
1105:
1106: IF p_LIMITS_rec.request_id IS NOT NULL AND

Line 1112: x_return_status := FND_API.G_RET_STS_ERROR;

1108: p_old_LIMITS_rec.request_id OR
1109: p_old_LIMITS_rec.request_id IS NULL )
1110: THEN
1111: IF NOT QP_Validate.Request(p_LIMITS_rec.request_id) THEN
1112: x_return_status := FND_API.G_RET_STS_ERROR;
1113: --dbms_output.put_line('Inside QP_Validate.request_id ' || x_return_status);
1114: END IF;
1115: END IF;
1116:

Line 1255: x_return_status := FND_API.G_RET_STS_ERROR;

1251:
1252: -- Validate descriptive flexfield.
1253:
1254: IF NOT QP_Validate.Desc_Flex( 'LIMITS' ) THEN
1255: x_return_status := FND_API.G_RET_STS_ERROR;
1256: END IF;
1257:
1258: END IF;
1259:

Line 1264: WHEN FND_API.G_EXC_ERROR THEN

1260: -- Done validating attributes
1261:
1262: EXCEPTION
1263:
1264: WHEN FND_API.G_EXC_ERROR THEN
1265:
1266: x_return_status := FND_API.G_RET_STS_ERROR;
1267:
1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1266: x_return_status := FND_API.G_RET_STS_ERROR;

1262: EXCEPTION
1263:
1264: WHEN FND_API.G_EXC_ERROR THEN
1265:
1266: x_return_status := FND_API.G_RET_STS_ERROR;
1267:
1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1269:
1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1264: WHEN FND_API.G_EXC_ERROR THEN
1265:
1266: x_return_status := FND_API.G_RET_STS_ERROR;
1267:
1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1269:
1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1271:
1272: WHEN OTHERS THEN

Line 1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1266: x_return_status := FND_API.G_RET_STS_ERROR;
1267:
1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1269:
1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1271:
1272: WHEN OTHERS THEN
1273:
1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1271:
1272: WHEN OTHERS THEN
1273:
1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1275:
1276: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1277: THEN
1278: OE_MSG_PUB.Add_Exc_Msg

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

1289: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1290: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
1291: )
1292: IS
1293: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1294: l_dummy NUMBER := 0;
1295: BEGIN
1296:
1297: -- Validate entity delete.

Line 1305: l_return_status := FND_API.G_RET_STS_SUCCESS;

1301: AND nvl(consumed_amount,0) > 0;
1302:
1303: IF l_dummy = 0
1304: THEN
1305: l_return_status := FND_API.G_RET_STS_SUCCESS;
1306: ELSIF l_dummy > 0
1307: THEN
1308: l_return_status := FND_API.G_RET_STS_ERROR;
1309: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_DEL_LIMIT_BAL_EXISTS');

Line 1308: l_return_status := FND_API.G_RET_STS_ERROR;

1304: THEN
1305: l_return_status := FND_API.G_RET_STS_SUCCESS;
1306: ELSIF l_dummy > 0
1307: THEN
1308: l_return_status := FND_API.G_RET_STS_ERROR;
1309: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_DEL_LIMIT_BAL_EXISTS');
1310: FND_MESSAGE.SET_TOKEN('ENTITY1','Limit');
1311: FND_MESSAGE.SET_TOKEN('ENTITY2','Limit');
1312: OE_MSG_PUB.Add;

Line 1320: WHEN FND_API.G_EXC_ERROR THEN

1316: x_return_status := l_return_status;
1317:
1318: EXCEPTION
1319:
1320: WHEN FND_API.G_EXC_ERROR THEN
1321:
1322: x_return_status := FND_API.G_RET_STS_ERROR;
1323:
1324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1322: x_return_status := FND_API.G_RET_STS_ERROR;

1318: EXCEPTION
1319:
1320: WHEN FND_API.G_EXC_ERROR THEN
1321:
1322: x_return_status := FND_API.G_RET_STS_ERROR;
1323:
1324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1325:
1326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1320: WHEN FND_API.G_EXC_ERROR THEN
1321:
1322: x_return_status := FND_API.G_RET_STS_ERROR;
1323:
1324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1325:
1326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1327:
1328: WHEN OTHERS THEN

Line 1326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1322: x_return_status := FND_API.G_RET_STS_ERROR;
1323:
1324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1325:
1326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1327:
1328: WHEN OTHERS THEN
1329:
1330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1327:
1328: WHEN OTHERS THEN
1329:
1330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1331:
1332: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1333: THEN
1334: OE_MSG_PUB.Add_Exc_Msg

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

1344: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1345: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
1346: )
1347: IS
1348: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1349: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
1350: l_error_code NUMBER := 0;
1351: l_dummy NUMBER := 0;
1352: l_consumed_amount NUMBER := 0;

Line 1368: l_return_status := FND_API.G_RET_STS_SUCCESS;

1364: WHERE limit_id = p_LIMITS_rec.limit_id;
1365:
1366: IF l_dummy = 0
1367: THEN
1368: l_return_status := FND_API.G_RET_STS_SUCCESS;
1369: ELSIF l_dummy > 0
1370: THEN
1371:
1372: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id

Line 1479: l_return_status := FND_API.G_RET_STS_ERROR;

1475: END IF;
1476:
1477: IF l_error_code = 1
1478: THEN
1479: l_return_status := FND_API.G_RET_STS_ERROR;
1480: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPD_LIMIT_BAL_EXISTS');
1481: FND_MESSAGE.SET_TOKEN('ENTITY1','Limit');
1482: FND_MESSAGE.SET_TOKEN('ENTITY2','Limit');
1483: OE_MSG_PUB.Add;

Line 1486: l_return_status := FND_API.G_RET_STS_SUCCESS;

1482: FND_MESSAGE.SET_TOKEN('ENTITY2','Limit');
1483: OE_MSG_PUB.Add;
1484: ELSIF l_error_code = 0
1485: THEN
1486: l_return_status := FND_API.G_RET_STS_SUCCESS;
1487: END IF;
1488:
1489: END IF;
1490: -- Done.

Line 1496: WHEN FND_API.G_EXC_ERROR THEN

1492: x_return_status := l_return_status;
1493:
1494: EXCEPTION
1495:
1496: WHEN FND_API.G_EXC_ERROR THEN
1497:
1498: x_return_status := FND_API.G_RET_STS_ERROR;
1499:
1500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1498: x_return_status := FND_API.G_RET_STS_ERROR;

1494: EXCEPTION
1495:
1496: WHEN FND_API.G_EXC_ERROR THEN
1497:
1498: x_return_status := FND_API.G_RET_STS_ERROR;
1499:
1500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1501:
1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1496: WHEN FND_API.G_EXC_ERROR THEN
1497:
1498: x_return_status := FND_API.G_RET_STS_ERROR;
1499:
1500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1501:
1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1503:
1504: WHEN OTHERS THEN

Line 1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1498: x_return_status := FND_API.G_RET_STS_ERROR;
1499:
1500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1501:
1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1503:
1504: WHEN OTHERS THEN
1505:
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1503:
1504: WHEN OTHERS THEN
1505:
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1507:
1508: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1509: THEN
1510: OE_MSG_PUB.Add_Exc_Msg