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_LIMIT_ATTRS dependencies on OE_MSG_PUB

Line 40: OE_MSG_PUB.Add;

36: return;
37: ELSE
38: x_return_status := FND_API.G_RET_STS_ERROR;
39: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_NOT_ALLOWED');
40: OE_MSG_PUB.Add;
41: l_error_code := 1;
42: return;
43: END IF;
44: ELSE

Line 47: OE_MSG_PUB.Add;

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

Line 55: OE_MSG_PUB.Add;

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

Line 80: OE_MSG_PUB.Add;

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;
83: END IF;
84: ELSE

Line 87: OE_MSG_PUB.Add;

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;
90: END IF;
91: END IF;

Line 95: OE_MSG_PUB.Add;

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;
98: END IF;
99:

Line 119: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
122: ( G_PKG_NAME
123: , 'Validate_List_Header_Limits'

Line 121: OE_MSG_PUB.Add_Exc_Msg

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
122: ( G_PKG_NAME
123: , 'Validate_List_Header_Limits'
124: );
125: END IF;

Line 227: OE_MSG_PUB.Add;

223: return;
224: ELSE
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');
227: OE_MSG_PUB.Add;
228: l_error_code := 1;
229: return;
230: END IF;
231: ELSIF (p_LIMITS_rec.basis = 'USAGE')

Line 246: OE_MSG_PUB.Add;

242: return;
243: ELSE
244: x_return_status := FND_API.G_RET_STS_ERROR;
245: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');
246: OE_MSG_PUB.Add;
247: l_error_code := 1;
248: return;
249: END IF;
250: ELSE

Line 253: OE_MSG_PUB.Add;

249: END IF;
250: ELSE
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');
253: OE_MSG_PUB.Add;
254: l_error_code := 1;
255: return;
256: END IF;
257: END IF;

Line 261: OE_MSG_PUB.Add;

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

Line 285: OE_MSG_PUB.Add;

281: return;
282: ELSE
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');
285: OE_MSG_PUB.Add;
286: l_error_code := 1;
287: return;
288: END IF;
289: END IF;

Line 304: OE_MSG_PUB.Add;

300: return;
301: ELSE
302: x_return_status := FND_API.G_RET_STS_ERROR;
303: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');
304: OE_MSG_PUB.Add;
305: l_error_code := 1;
306: return;
307: END IF;
308: ELSE

Line 311: OE_MSG_PUB.Add;

307: END IF;
308: ELSE
309: x_return_status := FND_API.G_RET_STS_ERROR;
310: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');
311: OE_MSG_PUB.Add;
312: l_error_code := 1;
313: return;
314: END IF;
315: END IF;

Line 319: OE_MSG_PUB.Add;

315: END IF;
316: ELSE
317: x_return_status := FND_API.G_RET_STS_ERROR;
318: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
319: OE_MSG_PUB.Add;
320: l_error_code := 1;
321: return;
322: END IF;
323: END IF;

Line 343: OE_MSG_PUB.Add;

339: return;
340: ELSE
341: x_return_status := FND_API.G_RET_STS_ERROR;
342: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');
343: OE_MSG_PUB.Add;
344: l_error_code := 1;
345: return;
346: END IF;
347: ELSE

Line 350: OE_MSG_PUB.Add;

346: END IF;
347: ELSE
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');
350: OE_MSG_PUB.Add;
351: l_error_code := 1;
352: return;
353: END IF;
354: ELSE

Line 357: OE_MSG_PUB.Add;

353: END IF;
354: ELSE
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
357: OE_MSG_PUB.Add;
358: l_error_code := 1;
359: return;
360: END IF;
361: END IF;

Line 379: OE_MSG_PUB.Add;

375: return;
376: ELSE
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');
379: OE_MSG_PUB.Add;
380: l_error_code := 1;
381: return;
382: END IF;
383: ELSE

Line 386: OE_MSG_PUB.Add;

382: END IF;
383: ELSE
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');
386: OE_MSG_PUB.Add;
387: l_error_code := 1;
388: return;
389: END IF;
390: ELSE

Line 393: OE_MSG_PUB.Add;

389: END IF;
390: ELSE
391: x_return_status := FND_API.G_RET_STS_ERROR;
392: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
393: OE_MSG_PUB.Add;
394: l_error_code := 1;
395: return;
396: END IF;
397: END IF;

Line 415: OE_MSG_PUB.Add;

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

Line 422: OE_MSG_PUB.Add;

418: END IF;
419: ELSE
420: x_return_status := FND_API.G_RET_STS_ERROR;
421: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');
422: OE_MSG_PUB.Add;
423: l_error_code := 1;
424: return;
425: END IF;
426: ELSE

Line 429: OE_MSG_PUB.Add;

425: END IF;
426: ELSE
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
429: OE_MSG_PUB.Add;
430: l_error_code := 1;
431: return;
432: END IF;
433: END IF;

Line 451: OE_MSG_PUB.Add;

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

Line 458: OE_MSG_PUB.Add;

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

Line 465: OE_MSG_PUB.Add;

461: END IF;
462: ELSE
463: x_return_status := FND_API.G_RET_STS_ERROR;
464: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
465: OE_MSG_PUB.Add;
466: l_error_code := 1;
467: return;
468: END IF;
469: END IF;

Line 491: OE_MSG_PUB.Add;

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

Line 510: OE_MSG_PUB.Add;

506: return;
507: ELSE
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
510: OE_MSG_PUB.Add;
511: l_error_code := 1;
512: return;
513: END IF;
514: END IF;

Line 531: OE_MSG_PUB.Add;

527: return;
528: ELSE
529: x_return_status := FND_API.G_RET_STS_ERROR;
530: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
531: OE_MSG_PUB.Add;
532: l_error_code := 1;
533: return;
534: END IF;
535: END IF;

Line 550: OE_MSG_PUB.Add;

546: return;
547: ELSE
548: x_return_status := FND_API.G_RET_STS_ERROR;
549: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
550: OE_MSG_PUB.Add;
551: l_error_code := 1;
552: return;
553: END IF;
554: END IF;

Line 570: OE_MSG_PUB.Add;

566: return;
567: ELSE
568: x_return_status := FND_API.G_RET_STS_ERROR;
569: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
570: OE_MSG_PUB.Add;
571: l_error_code := 1;
572: return;
573: END IF;
574: END IF;

Line 590: OE_MSG_PUB.Add;

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;
593: END IF;
594: END IF;

Line 609: OE_MSG_PUB.Add;

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;
612: END IF;
613: END IF;

Line 628: OE_MSG_PUB.Add;

624: return;
625: ELSE
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
628: OE_MSG_PUB.Add;
629: l_error_code := 1;
630: return;
631: END IF;
632: END IF;

Line 647: OE_MSG_PUB.Add;

643: return;
644: ELSE
645: x_return_status := FND_API.G_RET_STS_ERROR;
646: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');
647: OE_MSG_PUB.Add;
648: l_error_code := 1;
649: return;
650: END IF;
651: END IF;

Line 672: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

668: WHEN OTHERS THEN
669:
670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
671:
672: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
673: THEN
674: OE_MSG_PUB.Add_Exc_Msg
675: ( G_PKG_NAME
676: , 'Validate_List_Line_Limits'

Line 674: OE_MSG_PUB.Add_Exc_Msg

670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
671:
672: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
673: THEN
674: OE_MSG_PUB.Add_Exc_Msg
675: ( G_PKG_NAME
676: , 'Validate_List_Line_Limits'
677: );
678: END IF;

Line 719: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

715:
716: l_return_status := FND_API.G_RET_STS_ERROR;
717: x_return_status := l_return_status;
718:
719: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
720: THEN
721:
722: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
723: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','attribute1');

Line 724: OE_MSG_PUB.Add;

720: THEN
721:
722: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
723: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','attribute1');
724: OE_MSG_PUB.Add;
725:
726: END IF;
727:
728: END IF;

Line 779: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

775: --dbms_output.put_line('IN ENTITY VALIDATION ' || 'l_context_error ' || l_context_error || ' l_error_code ' || l_error_code);
776: If (l_context_error = 'N' AND l_error_code = 7) -- invalid context
777: Then
778: l_return_status := FND_API.G_RET_STS_ERROR;
779: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
780: THEN
781: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
782: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
783: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Context');

Line 784: OE_MSG_PUB.Add;

780: THEN
781: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
782: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
783: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Context');
784: OE_MSG_PUB.Add;
785: END IF;
786: RAISE FND_API.G_EXC_ERROR;
787: End If;
788:

Line 798: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

794: If l_attribute_error = 'N' AND l_error_code = 8 -- invalid Attribute
795: Then
796: l_return_status := FND_API.G_RET_STS_ERROR;
797:
798: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
799: THEN
800: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
801: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');
802: OE_MSG_PUB.Add;

Line 802: OE_MSG_PUB.Add;

798: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
799: THEN
800: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
801: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');
802: OE_MSG_PUB.Add;
803: END IF;
804: RAISE FND_API.G_EXC_ERROR;
805:
806: End If;

Line 819: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

815: IF l_value_error = 'N' AND l_error_code = 9 -- invalid value
816: THEN
817: l_return_status := FND_API.G_RET_STS_ERROR;
818:
819: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
820: THEN
821:
822: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
823: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value');

Line 824: --OE_MSG_PUB.Add;

820: THEN
821:
822: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
823: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value');
824: --OE_MSG_PUB.Add;
825: OE_MSG_PUB.Add;
826: END IF;
827: RAISE FND_API.G_EXC_ERROR;
828: End If;

Line 825: OE_MSG_PUB.Add;

821:
822: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
823: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value');
824: --OE_MSG_PUB.Add;
825: OE_MSG_PUB.Add;
826: END IF;
827: RAISE FND_API.G_EXC_ERROR;
828: End If;
829: END IF;

Line 872: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

868: IF NOT l_fna_valid THEN
869:
870: l_return_status := FND_API.G_RET_STS_ERROR;
871:
872: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
873: THEN
874: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');
875: FND_MESSAGE.set_token('CATID', l_LIMIT_ATTRS_rec.limit_attr_value);
876: FND_MESSAGE.set_token('PTE', l_pte_code);

Line 878: OE_MSG_PUB.Add;

874: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');
875: FND_MESSAGE.set_token('CATID', l_LIMIT_ATTRS_rec.limit_attr_value);
876: FND_MESSAGE.set_token('PTE', l_pte_code);
877: FND_MESSAGE.set_token('SS', l_ss_code);
878: OE_MSG_PUB.Add;
879: END IF;
880:
881: RAISE FND_API.G_EXC_ERROR;
882:

Line 916: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

912: WHEN OTHERS THEN
913:
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915:
916: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
917: THEN
918: OE_MSG_PUB.Add_Exc_Msg
919: ( G_PKG_NAME
920: , 'Entity'

Line 918: OE_MSG_PUB.Add_Exc_Msg

914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915:
916: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
917: THEN
918: OE_MSG_PUB.Add_Exc_Msg
919: ( G_PKG_NAME
920: , 'Entity'
921: );
922: END IF;

Line 1271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1267: WHEN OTHERS THEN
1268:
1269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1270:
1271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1272: THEN
1273: OE_MSG_PUB.Add_Exc_Msg
1274: ( G_PKG_NAME
1275: , 'Attributes'

Line 1273: OE_MSG_PUB.Add_Exc_Msg

1269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1270:
1271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1272: THEN
1273: OE_MSG_PUB.Add_Exc_Msg
1274: ( G_PKG_NAME
1275: , 'Attributes'
1276: );
1277: END IF;

Line 1308: OE_MSG_PUB.Add;

1304: l_return_status := FND_API.G_RET_STS_ERROR;
1305: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_INS_LIMIT_BAL_EXISTS');
1306: FND_MESSAGE.SET_TOKEN('ENTITY1','Limit');
1307: FND_MESSAGE.SET_TOKEN('ENTITY2','Limit Attribute');
1308: OE_MSG_PUB.Add;
1309: END IF;
1310:
1311: -- Done.
1312:

Line 1329: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 1331: OE_MSG_PUB.Add_Exc_Msg

1327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1328:
1329: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1330: THEN
1331: OE_MSG_PUB.Add_Exc_Msg
1332: ( G_PKG_NAME
1333: , 'Entity_Delete'
1334: );
1335: END IF;

Line 1364: OE_MSG_PUB.Add;

1360: l_return_status := FND_API.G_RET_STS_ERROR;
1361: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_DEL_LIMIT_BAL_EXISTS');
1362: FND_MESSAGE.SET_TOKEN('ENTITY1','Limit');
1363: FND_MESSAGE.SET_TOKEN('ENTITY2','Limit Attribute');
1364: OE_MSG_PUB.Add;
1365: END IF;
1366:
1367: -- Done.
1368:

Line 1385: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1381: WHEN OTHERS THEN
1382:
1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1384:
1385: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1386: THEN
1387: OE_MSG_PUB.Add_Exc_Msg
1388: ( G_PKG_NAME
1389: , 'Entity_Delete'

Line 1387: OE_MSG_PUB.Add_Exc_Msg

1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1384:
1385: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1386: THEN
1387: OE_MSG_PUB.Add_Exc_Msg
1388: ( G_PKG_NAME
1389: , 'Entity_Delete'
1390: );
1391: END IF;

Line 1473: OE_MSG_PUB.Add;

1469: l_return_status := FND_API.G_RET_STS_ERROR;
1470: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPD_LIMIT_BAL_EXISTS');
1471: FND_MESSAGE.SET_TOKEN('ENTITY1','Limit');
1472: FND_MESSAGE.SET_TOKEN('ENTITY2','Limit Attribute');
1473: OE_MSG_PUB.Add;
1474: ELSIF l_error_code = 0
1475: THEN
1476: l_return_status := FND_API.G_RET_STS_SUCCESS;
1477: END IF;

Line 1498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1494: WHEN OTHERS THEN
1495:
1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1497:
1498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1499: THEN
1500: OE_MSG_PUB.Add_Exc_Msg
1501: ( G_PKG_NAME
1502: , 'Entity_Delete'

Line 1500: OE_MSG_PUB.Add_Exc_Msg

1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1497:
1498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1499: THEN
1500: OE_MSG_PUB.Add_Exc_Msg
1501: ( G_PKG_NAME
1502: , 'Entity_Delete'
1503: );
1504: END IF;