DBA Data[Home] [Help]

APPS.QP_VALIDATE_LIMIT_ATTRS dependencies on FND_MESSAGE

Line 39: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_NOT_ALLOWED');

35: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 46: FND_MESSAGE.SET_NAME('QP','QP_ORG_NOT_ALLOWED');

42: return;
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;

Line 54: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

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

Line 79: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_NOT_ALLOWED');

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

Line 86: FND_MESSAGE.SET_NAME('QP','QP_ORG_NOT_ALLOWED');

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

Line 94: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

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

Line 226: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');

222: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 3' || 'l_error_code = ' || l_error_code);
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;

Line 245: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');

241: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 4' || 'l_error_code = ' || l_error_code);
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;

Line 252: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');

248: return;
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;

Line 260: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

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

Line 284: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');

280: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 6' || 'l_error_code = ' || l_error_code);
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;

Line 303: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');

299: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 7' || 'l_error_code = ' || l_errorde);
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;

Line 310: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');

306: return;
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;

Line 318: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

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

Line 342: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');

338: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 9' || 'l_error_code = ' || l_error_code);
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;

Line 349: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');

345: return;
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;

Line 356: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

352: return;
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;

Line 378: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');

374: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 10' || 'l_error_code = ' || l_error_code);
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;

Line 385: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');

381: return;
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;

Line 392: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

388: return;
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;

Line 414: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');

410: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 11' || 'l_error_code = ' || l_error_code);
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;

Line 421: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');

417: return;
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;

Line 428: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

424: return;
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;

Line 450: FND_MESSAGE.SET_NAME('QP','QP_CONT_CUST_PROD_NOT_ALLOWED');

446: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 12' || 'l_error_code = ' || l_error_code);
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;

Line 457: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_LEVEL');

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_LEVEL');
458: OE_MSG_PUB.Add;
459: l_error_code := 1;
460: return;
461: END IF;

Line 464: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

460: return;
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;

Line 490: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

486: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 13' || 'l_error_code = ' || l_error_code);
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;

Line 509: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

505: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 14' || 'l_error_code = ' || l_error_code);
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;

Line 530: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

526: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 15' || 'l_error_code = ' || l_error_code);
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;

Line 549: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

545: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 16' || 'l_error_code = ' || l_error_code);
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;

Line 569: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

565: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 17' || 'l_error_code = ' || l_error_code);
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;

Line 589: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

585: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 18' || '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;
593: END IF;

Line 608: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

604: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 19' || '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;
612: END IF;

Line 627: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

623: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 20' || 'l_error_code = ' || l_error_code);
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;

Line 646: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIMIT_BASIS');

642: --DBMS_OUTPUT.PUT_LINE('INSIDE VALIDATE ENTITY 21' || 'l_error_code = ' || l_error_code);
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;

Line 722: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

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');
724: OE_MSG_PUB.Add;
725:
726: END IF;

Line 723: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','attribute1');

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');
724: OE_MSG_PUB.Add;
725:
726: END IF;
727:

Line 781: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

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');
784: OE_MSG_PUB.Add;
785: END IF;

Line 782: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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');
784: OE_MSG_PUB.Add;
785: END IF;
786: RAISE FND_API.G_EXC_ERROR;

Line 783: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Context');

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');
784: OE_MSG_PUB.Add;
785: END IF;
786: RAISE FND_API.G_EXC_ERROR;
787: End If;

Line 800: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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;
803: END IF;
804: RAISE FND_API.G_EXC_ERROR;

Line 801: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');

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;
803: END IF;
804: RAISE FND_API.G_EXC_ERROR;
805:

Line 822: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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');
824: --OE_MSG_PUB.Add;
825: OE_MSG_PUB.Add;
826: END IF;

Line 823: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value');

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');
824: --OE_MSG_PUB.Add;
825: OE_MSG_PUB.Add;
826: END IF;
827: RAISE FND_API.G_EXC_ERROR;

Line 874: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');

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);
877: FND_MESSAGE.set_token('SS', l_ss_code);
878: OE_MSG_PUB.Add;

Line 875: FND_MESSAGE.set_token('CATID', l_LIMIT_ATTRS_rec.limit_attr_value);

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);
877: FND_MESSAGE.set_token('SS', l_ss_code);
878: OE_MSG_PUB.Add;
879: END IF;

Line 876: FND_MESSAGE.set_token('PTE', l_pte_code);

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);
877: FND_MESSAGE.set_token('SS', l_ss_code);
878: OE_MSG_PUB.Add;
879: END IF;
880:

Line 877: FND_MESSAGE.set_token('SS', l_ss_code);

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);
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;

Line 1305: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_INS_LIMIT_BAL_EXISTS');

1301: l_return_status := FND_API.G_RET_STS_SUCCESS;
1302: ELSIF l_dummy > 0
1303: THEN
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;

Line 1306: FND_MESSAGE.SET_TOKEN('ENTITY1','Limit');

1302: ELSIF l_dummy > 0
1303: THEN
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:

Line 1307: FND_MESSAGE.SET_TOKEN('ENTITY2','Limit Attribute');

1303: THEN
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.

Line 1361: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_DEL_LIMIT_BAL_EXISTS');

1357: l_return_status := FND_API.G_RET_STS_SUCCESS;
1358: ELSIF l_dummy > 0
1359: THEN
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;

Line 1362: FND_MESSAGE.SET_TOKEN('ENTITY1','Limit');

1358: ELSIF l_dummy > 0
1359: THEN
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:

Line 1363: FND_MESSAGE.SET_TOKEN('ENTITY2','Limit Attribute');

1359: THEN
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.

Line 1470: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPD_LIMIT_BAL_EXISTS');

1466:
1467: IF l_error_code = 1
1468: THEN
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

Line 1471: FND_MESSAGE.SET_TOKEN('ENTITY1','Limit');

1467: IF l_error_code = 1
1468: THEN
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

Line 1472: FND_MESSAGE.SET_TOKEN('ENTITY2','Limit Attribute');

1468: THEN
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;