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.AR_RAAPI_UTIL dependencies on FND_MESSAGE

Line 364: FND_MESSAGE.set_name (application => 'AR',

360: OPEN c_trx_num;
361: FETCH c_trx_num INTO g_customer_trx_id;
362: IF c_trx_num%NOTFOUND
363: THEN
364: FND_MESSAGE.set_name (application => 'AR',
365: name => 'AR_RA_TRX_NOTFOUND');
366: FND_MESSAGE.set_token('TRX_NUMBER',p_rev_adj_rec.trx_number);
367: FND_MSG_PUB.Add;
368: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 366: FND_MESSAGE.set_token('TRX_NUMBER',p_rev_adj_rec.trx_number);

362: IF c_trx_num%NOTFOUND
363: THEN
364: FND_MESSAGE.set_name (application => 'AR',
365: name => 'AR_RA_TRX_NOTFOUND');
366: FND_MESSAGE.set_token('TRX_NUMBER',p_rev_adj_rec.trx_number);
367: FND_MSG_PUB.Add;
368: x_return_status := FND_API.G_RET_STS_ERROR ;
369: ELSE
370: FETCH c_trx_num INTO l_customer_trx_id;

Line 374: FND_MESSAGE.set_name (application => 'AR',

370: FETCH c_trx_num INTO l_customer_trx_id;
371: IF c_trx_num%FOUND
372: THEN
373: g_customer_trx_id := NULL;
374: FND_MESSAGE.set_name (application => 'AR',
375: name => 'AR_RA_TRX_TOO_MANY_ROWS');
376: FND_MESSAGE.set_token('TRX_NUMBER',p_rev_adj_rec.trx_number);
377: FND_MSG_PUB.Add;
378: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 376: FND_MESSAGE.set_token('TRX_NUMBER',p_rev_adj_rec.trx_number);

372: THEN
373: g_customer_trx_id := NULL;
374: FND_MESSAGE.set_name (application => 'AR',
375: name => 'AR_RA_TRX_TOO_MANY_ROWS');
376: FND_MESSAGE.set_token('TRX_NUMBER',p_rev_adj_rec.trx_number);
377: FND_MSG_PUB.Add;
378: x_return_status := FND_API.G_RET_STS_ERROR ;
379: END IF;
380: END IF;

Line 383: FND_MESSAGE.set_name (application => 'AR',

379: END IF;
380: END IF;
381: CLOSE c_trx_num;
382: ELSE
383: FND_MESSAGE.set_name (application => 'AR',
384: name => 'AR_RA_NO_TRX_NUMBER');
385: FND_MSG_PUB.Add;
386: x_return_status := FND_API.G_RET_STS_ERROR ;
387: END IF;

Line 393: FND_MESSAGE.set_name (application => 'AR',

389: OPEN c_trx_id;
390: FETCH c_trx_id INTO g_customer_trx_id;
391: IF c_trx_id%NOTFOUND
392: THEN
393: FND_MESSAGE.set_name (application => 'AR',
394: name => 'AR_TAPI_TRANS_NOT_EXIST');
395: FND_MESSAGE.set_token('CUSTOMER_TRX_ID',p_rev_adj_rec.customer_trx_id);
396: FND_MSG_PUB.Add;
397: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 395: FND_MESSAGE.set_token('CUSTOMER_TRX_ID',p_rev_adj_rec.customer_trx_id);

391: IF c_trx_id%NOTFOUND
392: THEN
393: FND_MESSAGE.set_name (application => 'AR',
394: name => 'AR_TAPI_TRANS_NOT_EXIST');
395: FND_MESSAGE.set_token('CUSTOMER_TRX_ID',p_rev_adj_rec.customer_trx_id);
396: FND_MSG_PUB.Add;
397: x_return_status := FND_API.G_RET_STS_ERROR ;
398: END IF;
399: CLOSE c_trx_id;

Line 412: FND_MESSAGE.set_name('AR','AR_RA_CB_DISALLOWED');

408: g_customer_trx_id IS NOT NULL)
409: THEN
410: IF l_trx_type = 'CB'
411: THEN
412: FND_MESSAGE.set_name('AR','AR_RA_CB_DISALLOWED');
413: FND_MSG_PUB.Add;
414: x_return_status := FND_API.G_RET_STS_ERROR ;
415: END IF;
416: -- Bug # 4096889

Line 420: -- FND_MESSAGE.set_name('AR','AR_RA_DM_DISALLOWED');

416: -- Bug # 4096889
417: -- ORASHID
418: -- IF l_trx_type = 'DM'
419: -- THEN
420: -- FND_MESSAGE.set_name('AR','AR_RA_DM_DISALLOWED');
421: -- FND_MSG_PUB.Add;
422: -- x_return_status := FND_API.G_RET_STS_ERROR ;
423: -- END IF;
424: IF l_trx_type = 'BR'

Line 426: FND_MESSAGE.set_name('AR','AR_RA_BR_DISALLOWED');

422: -- x_return_status := FND_API.G_RET_STS_ERROR ;
423: -- END IF;
424: IF l_trx_type = 'BR'
425: THEN
426: FND_MESSAGE.set_name('AR','AR_RA_BR_DISALLOWED');
427: FND_MSG_PUB.Add;
428: x_return_status := FND_API.G_RET_STS_ERROR ;
429: END IF;
430: -- Bug # 4096889

Line 434: -- FND_MESSAGE.set_name('AR','AR_RA_DEP_DISALLOWED');

430: -- Bug # 4096889
431: -- ORASHID
432: -- IF l_trx_type = 'DEP'
433: -- THEN
434: -- FND_MESSAGE.set_name('AR','AR_RA_DEP_DISALLOWED');
435: -- FND_MSG_PUB.Add;
436: -- x_return_status := FND_API.G_RET_STS_ERROR ;
437: -- END IF;
438: IF l_trx_type = 'GUAR'

Line 440: FND_MESSAGE.set_name('AR','AR_RA_GUAR_DISALLOWED');

436: -- x_return_status := FND_API.G_RET_STS_ERROR ;
437: -- END IF;
438: IF l_trx_type = 'GUAR'
439: THEN
440: FND_MESSAGE.set_name('AR','AR_RA_GUAR_DISALLOWED');
441: FND_MSG_PUB.Add;
442: x_return_status := FND_API.G_RET_STS_ERROR ;
443: END IF;
444: /* 5011151 - Only allow revenue adjustments on

Line 454: FND_MESSAGE.set_name('AR','AR_RA_CM_DISALLOWED');

450: raise error if it is Y */
451: IF use_inv_acctg = 'Y'
452: THEN
453: /* raise error */
454: FND_MESSAGE.set_name('AR','AR_RA_CM_DISALLOWED');
455: FND_MSG_PUB.Add;
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: END IF;
458: END IF;

Line 482: FND_MESSAGE.set_name ('AR','AR_RA_FULL_CREDIT');

478: reason to overtly prevent adjustments */
479: --
480: -- Fully credit memo'd so raise an error
481: --
482: FND_MESSAGE.set_name ('AR','AR_RA_FULL_CREDIT');
483: FND_MSG_PUB.Add;
484: ELSE
485: --
486: -- Partially credit memo'd so raise a warning only

Line 488: FND_MESSAGE.set_name ('AR','AR_RA_PARTIAL_CREDIT');

484: ELSE
485: --
486: -- Partially credit memo'd so raise a warning only
487: --
488: FND_MESSAGE.set_name ('AR','AR_RA_PARTIAL_CREDIT');
489: FND_MSG_PUB.Add;
490: END IF;
491: END IF;
492: END IF;

Line 641: FND_MESSAGE.set_name

637: IF c_salesrep_num%NOTFOUND
638: THEN
639: /* Bug 2157246 - shortened message */
640: /* Bug 2191739 - call to message API for degovtized message */
641: FND_MESSAGE.set_name
642: (application => 'AR',
643: name => gl_public_sector.get_message_name
644: (p_message_name => 'AR_RA_INVALID_SALESREP_NUM',
645: p_app_short_name => 'AR'));

Line 646: FND_MESSAGE.set_token('SALESREP_NUMBER',

642: (application => 'AR',
643: name => gl_public_sector.get_message_name
644: (p_message_name => 'AR_RA_INVALID_SALESREP_NUM',
645: p_app_short_name => 'AR'));
646: FND_MESSAGE.set_token('SALESREP_NUMBER',
647: p_rev_adj_rec.from_salesrep_number);
648: FND_MSG_PUB.Add;
649: x_return_status := FND_API.G_RET_STS_ERROR ;
650: END IF;

Line 658: FND_MESSAGE.set_name (application => 'AR',

654: OPEN c_salesrep_id(p_rev_adj_rec.from_salesrep_id);
655: FETCH c_salesrep_id INTO g_from_salesrep_id;
656: IF c_salesrep_id%NOTFOUND
657: THEN
658: FND_MESSAGE.set_name (application => 'AR',
659: name => 'AR_TAPI_INVALID_SALESREP_ID');
660: FND_MESSAGE.set_token('SALESREP_ID',
661: p_rev_adj_rec.from_salesrep_id);
662: FND_MSG_PUB.Add;

Line 660: FND_MESSAGE.set_token('SALESREP_ID',

656: IF c_salesrep_id%NOTFOUND
657: THEN
658: FND_MESSAGE.set_name (application => 'AR',
659: name => 'AR_TAPI_INVALID_SALESREP_ID');
660: FND_MESSAGE.set_token('SALESREP_ID',
661: p_rev_adj_rec.from_salesrep_id);
662: FND_MSG_PUB.Add;
663: x_return_status := FND_API.G_RET_STS_ERROR ;
664: END IF;

Line 715: FND_MESSAGE.set_name

711: CLOSE c_check_sales_credits;
712: IF NVL(l_sales_credit_total,0) = 0
713: THEN
714: /* Bug 2191739 - call to message API for degovtized message */
715: FND_MESSAGE.set_name
716: (application => 'AR',
717: name => gl_public_sector.get_message_name
718: (p_message_name => 'AR_RA_SALESREP_NOT_ON_TRX',
719: p_app_short_name => 'AR'));

Line 720: FND_MESSAGE.set_token('SALESREP_NAME',

716: (application => 'AR',
717: name => gl_public_sector.get_message_name
718: (p_message_name => 'AR_RA_SALESREP_NOT_ON_TRX',
719: p_app_short_name => 'AR'));
720: FND_MESSAGE.set_token('SALESREP_NAME',
721: --begin anuj
722: /* Multi-Org Access Control Changes for SSA;Begin;anukumar;11/01/2002*/
723: -- ARPT_SQL_FUNC_UTIL.get_salesrep_name_number(g_from_salesrep_id,'NAME'));
724: ARPT_SQL_FUNC_UTIL.get_salesrep_name_number(g_from_salesrep_id,'NAME',l_org_id));

Line 750: FND_MESSAGE.set_name

746: THEN
747: IF p_rev_adj_rec.to_salesrep_number IS NULL
748: THEN
749: /* Bug 2191739 - call to message API for degovtized message */
750: FND_MESSAGE.set_name
751: (application => 'AR',
752: name => gl_public_sector.get_message_name
753: (p_message_name => 'AR_RA_NO_TO_SALESREP',
754: p_app_short_name => 'AR'));

Line 764: FND_MESSAGE.set_name

760: IF c_salesrep_num%NOTFOUND
761: THEN
762: /* Bug 2157246 - shortened message */
763: /* Bug 2191739 - call to message API for degovtized message */
764: FND_MESSAGE.set_name
765: (application => 'AR',
766: name => gl_public_sector.get_message_name
767: (p_message_name => 'AR_RA_INVALID_SALESREP_NUM',
768: p_app_short_name => 'AR'));

Line 769: FND_MESSAGE.set_token('SALESREP_NUMBER',

765: (application => 'AR',
766: name => gl_public_sector.get_message_name
767: (p_message_name => 'AR_RA_INVALID_SALESREP_NUM',
768: p_app_short_name => 'AR'));
769: FND_MESSAGE.set_token('SALESREP_NUMBER',
770: p_rev_adj_rec.to_salesrep_number);
771: FND_MSG_PUB.Add;
772: x_return_status := FND_API.G_RET_STS_ERROR ;
773: END IF;

Line 781: FND_MESSAGE.set_name (application => 'AR',

777: OPEN c_salesrep_id(p_rev_adj_rec.to_salesrep_id);
778: FETCH c_salesrep_id INTO g_to_salesrep_id;
779: IF c_salesrep_id%NOTFOUND
780: THEN
781: FND_MESSAGE.set_name (application => 'AR',
782: name => 'AR_TAPI_INVALID_SALESREP_ID');
783: FND_MESSAGE.set_token('SALESREP_ID',
784: p_rev_adj_rec.to_salesrep_id);
785: FND_MSG_PUB.Add;

Line 783: FND_MESSAGE.set_token('SALESREP_ID',

779: IF c_salesrep_id%NOTFOUND
780: THEN
781: FND_MESSAGE.set_name (application => 'AR',
782: name => 'AR_TAPI_INVALID_SALESREP_ID');
783: FND_MESSAGE.set_token('SALESREP_ID',
784: p_rev_adj_rec.to_salesrep_id);
785: FND_MSG_PUB.Add;
786: x_return_status := FND_API.G_RET_STS_ERROR ;
787: END IF;

Line 814: FND_MESSAGE.set_name (application => 'AR',

810: OPEN c_salesgroup_id(p_rev_adj_rec.to_salesgroup_id);
811: FETCH c_salesgroup_id INTO g_to_salesgroup_id;
812: IF c_salesgroup_id%NOTFOUND
813: THEN
814: FND_MESSAGE.set_name (application => 'AR',
815: name => 'AR_INVALID_SALESGROUP_ID');
816: FND_MSG_PUB.Add;
817: x_return_status := FND_API.G_RET_STS_ERROR ;
818: END IF;

Line 968: FND_MESSAGE.set_name (application => 'AR',

964: OPEN c_category_segs(l_segment_rec);
965: FETCH c_category_segs INTO g_from_category_id;
966: IF c_category_segs%NOTFOUND
967: THEN
968: FND_MESSAGE.set_name (application => 'AR',
969: name => 'AR_RA_INVALID_CAT_SEGMENTS');
970: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||
971: l_segment_rec.segment2||l_segment_rec.segment3||
972: l_segment_rec.segment4||l_segment_rec.segment5||

Line 970: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||

966: IF c_category_segs%NOTFOUND
967: THEN
968: FND_MESSAGE.set_name (application => 'AR',
969: name => 'AR_RA_INVALID_CAT_SEGMENTS');
970: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||
971: l_segment_rec.segment2||l_segment_rec.segment3||
972: l_segment_rec.segment4||l_segment_rec.segment5||
973: l_segment_rec.segment6||l_segment_rec.segment7||
974: l_segment_rec.segment8||l_segment_rec.segment9||

Line 987: FND_MESSAGE.set_name (application => 'AR',

983: END IF;
984: CLOSE c_category_segs;
985: ELSIF p_rev_adj_rec.line_selection_mode = 'C'
986: THEN
987: FND_MESSAGE.set_name (application => 'AR',
988: name => 'AR_RA_NO_FROM_CATEGORY');
989: FND_MSG_PUB.Add;
990: x_return_status := FND_API.G_RET_STS_ERROR ;
991: END IF;

Line 997: FND_MESSAGE.set_name (application => 'AR',

993: OPEN c_category_id(p_rev_adj_rec.from_category_id);
994: FETCH c_category_id INTO g_from_category_id;
995: IF c_category_id%NOTFOUND
996: THEN
997: FND_MESSAGE.set_name (application => 'AR',
998: name => 'AR_RA_INVALID_CATEGORY_ID');
999: FND_MESSAGE.set_token('CATEGORY_ID', p_rev_adj_rec.from_category_id);
1000: FND_MSG_PUB.Add;
1001: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 999: FND_MESSAGE.set_token('CATEGORY_ID', p_rev_adj_rec.from_category_id);

995: IF c_category_id%NOTFOUND
996: THEN
997: FND_MESSAGE.set_name (application => 'AR',
998: name => 'AR_RA_INVALID_CATEGORY_ID');
999: FND_MESSAGE.set_token('CATEGORY_ID', p_rev_adj_rec.from_category_id);
1000: FND_MSG_PUB.Add;
1001: x_return_status := FND_API.G_RET_STS_ERROR ;
1002: END IF;
1003: CLOSE c_category_id;

Line 1012: FND_MESSAGE.set_name (application => 'AR',

1008: FETCH c_cat_exists_on_trx INTO l_cat_count;
1009: CLOSE c_cat_exists_on_trx;
1010: IF l_cat_count = 0
1011: THEN
1012: FND_MESSAGE.set_name (application => 'AR',
1013: name => 'AR_RA_CATEGORY_NOT_ON_TRX');
1014: FND_MESSAGE.set_token('CATEGORY_ID', p_rev_adj_rec.from_category_id);
1015: FND_MSG_PUB.Add;
1016: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1014: FND_MESSAGE.set_token('CATEGORY_ID', p_rev_adj_rec.from_category_id);

1010: IF l_cat_count = 0
1011: THEN
1012: FND_MESSAGE.set_name (application => 'AR',
1013: name => 'AR_RA_CATEGORY_NOT_ON_TRX');
1014: FND_MESSAGE.set_token('CATEGORY_ID', p_rev_adj_rec.from_category_id);
1015: FND_MSG_PUB.Add;
1016: x_return_status := FND_API.G_RET_STS_ERROR ;
1017: END IF;
1018: END IF;

Line 1081: FND_MESSAGE.set_name (application => 'AR',

1077: OPEN c_category_segs(l_segment_rec);
1078: FETCH c_category_segs INTO g_to_category_id;
1079: IF c_category_segs%NOTFOUND
1080: THEN
1081: FND_MESSAGE.set_name (application => 'AR',
1082: name => 'AR_RA_INVALID_CAT_SEGMENTS');
1083: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||
1084: l_segment_rec.segment2||l_segment_rec.segment3||
1085: l_segment_rec.segment4||l_segment_rec.segment5||

Line 1083: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||

1079: IF c_category_segs%NOTFOUND
1080: THEN
1081: FND_MESSAGE.set_name (application => 'AR',
1082: name => 'AR_RA_INVALID_CAT_SEGMENTS');
1083: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||
1084: l_segment_rec.segment2||l_segment_rec.segment3||
1085: l_segment_rec.segment4||l_segment_rec.segment5||
1086: l_segment_rec.segment6||l_segment_rec.segment7||
1087: l_segment_rec.segment8||l_segment_rec.segment9||

Line 1099: FND_MESSAGE.set_name (application => 'AR',

1095: x_return_status := FND_API.G_RET_STS_ERROR ;
1096: END IF;
1097: CLOSE c_category_segs;
1098: ELSE
1099: FND_MESSAGE.set_name (application => 'AR',
1100: name => 'AR_RA_NO_TO_CATEGORY');
1101: FND_MSG_PUB.Add;
1102: x_return_status := FND_API.G_RET_STS_ERROR ;
1103: END IF;

Line 1109: FND_MESSAGE.set_name (application => 'AR',

1105: OPEN c_category_id(p_rev_adj_rec.to_category_id);
1106: FETCH c_category_id INTO g_to_category_id;
1107: IF c_category_id%NOTFOUND
1108: THEN
1109: FND_MESSAGE.set_name (application => 'AR',
1110: name => 'AR_RA_INVALID_CATEGORY_ID');
1111: FND_MESSAGE.set_token('CATEGORY_ID', p_rev_adj_rec.to_category_id);
1112: FND_MSG_PUB.Add;
1113: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1111: FND_MESSAGE.set_token('CATEGORY_ID', p_rev_adj_rec.to_category_id);

1107: IF c_category_id%NOTFOUND
1108: THEN
1109: FND_MESSAGE.set_name (application => 'AR',
1110: name => 'AR_RA_INVALID_CATEGORY_ID');
1111: FND_MESSAGE.set_token('CATEGORY_ID', p_rev_adj_rec.to_category_id);
1112: FND_MSG_PUB.Add;
1113: x_return_status := FND_API.G_RET_STS_ERROR ;
1114: END IF;
1115: CLOSE c_category_id;

Line 1124: FND_MESSAGE.set_name (application => 'AR',

1120: FETCH c_cat_exists_on_trx INTO l_cat_count;
1121: CLOSE c_cat_exists_on_trx;
1122: IF l_cat_count = 0
1123: THEN
1124: FND_MESSAGE.set_name (application => 'AR',
1125: name => 'AR_RA_CATEGORY_NOT_ON_TRX');
1126: FND_MESSAGE.set_token('CATEGORY_ID', p_rev_adj_rec.to_category_id);
1127: FND_MSG_PUB.Add;
1128: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1126: FND_MESSAGE.set_token('CATEGORY_ID', p_rev_adj_rec.to_category_id);

1122: IF l_cat_count = 0
1123: THEN
1124: FND_MESSAGE.set_name (application => 'AR',
1125: name => 'AR_RA_CATEGORY_NOT_ON_TRX');
1126: FND_MESSAGE.set_token('CATEGORY_ID', p_rev_adj_rec.to_category_id);
1127: FND_MSG_PUB.Add;
1128: x_return_status := FND_API.G_RET_STS_ERROR ;
1129: END IF;
1130: END IF;

Line 1139: FND_MESSAGE.set_name (application => 'AR',

1135: p_count => x_msg_count,
1136: p_data => x_msg_data);
1137: EXCEPTION
1138: WHEN TOO_MANY_ROWS THEN
1139: FND_MESSAGE.set_name (application => 'AR',
1140: name => 'AR_RA_INVALID_CAT_SEGMENTS');
1141: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||
1142: l_segment_rec.segment2||l_segment_rec.segment3||
1143: l_segment_rec.segment4||l_segment_rec.segment5||

Line 1141: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||

1137: EXCEPTION
1138: WHEN TOO_MANY_ROWS THEN
1139: FND_MESSAGE.set_name (application => 'AR',
1140: name => 'AR_RA_INVALID_CAT_SEGMENTS');
1141: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||
1142: l_segment_rec.segment2||l_segment_rec.segment3||
1143: l_segment_rec.segment4||l_segment_rec.segment5||
1144: l_segment_rec.segment6||l_segment_rec.segment7||
1145: l_segment_rec.segment8||l_segment_rec.segment9||

Line 1286: FND_MESSAGE.set_name (application => 'AR',

1282: OPEN c_item_segs(l_segment_rec);
1283: FETCH c_item_segs INTO g_from_inventory_item_id;
1284: IF c_item_segs%NOTFOUND
1285: THEN
1286: FND_MESSAGE.set_name (application => 'AR',
1287: name => 'AR_RA_INVALID_ITEM_SEGMENTS');
1288: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||
1289: l_segment_rec.segment2||l_segment_rec.segment3||
1290: l_segment_rec.segment4||l_segment_rec.segment5||

Line 1288: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||

1284: IF c_item_segs%NOTFOUND
1285: THEN
1286: FND_MESSAGE.set_name (application => 'AR',
1287: name => 'AR_RA_INVALID_ITEM_SEGMENTS');
1288: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||
1289: l_segment_rec.segment2||l_segment_rec.segment3||
1290: l_segment_rec.segment4||l_segment_rec.segment5||
1291: l_segment_rec.segment6||l_segment_rec.segment7||
1292: l_segment_rec.segment8||l_segment_rec.segment9||

Line 1305: FND_MESSAGE.set_name (application => 'AR',

1301: END IF;
1302: CLOSE c_item_segs;
1303: ELSIF p_rev_adj_rec.line_selection_mode = 'I'
1304: THEN
1305: FND_MESSAGE.set_name (application => 'AR',
1306: name => 'AR_RA_NO_FROM_ITEM');
1307: FND_MSG_PUB.Add;
1308: x_return_status := FND_API.G_RET_STS_ERROR ;
1309: END IF;

Line 1315: FND_MESSAGE.set_name (application => 'AR',

1311: OPEN c_item_id(p_rev_adj_rec.from_inventory_item_id);
1312: FETCH c_item_id INTO g_from_inventory_item_id;
1313: IF c_item_id%NOTFOUND
1314: THEN
1315: FND_MESSAGE.set_name (application => 'AR',
1316: name => 'AR_RA_INVALID_ITEM_ID');
1317: FND_MESSAGE.set_token('ITEM_ID',p_rev_adj_rec.from_inventory_item_id);
1318: FND_MSG_PUB.Add;
1319: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1317: FND_MESSAGE.set_token('ITEM_ID',p_rev_adj_rec.from_inventory_item_id);

1313: IF c_item_id%NOTFOUND
1314: THEN
1315: FND_MESSAGE.set_name (application => 'AR',
1316: name => 'AR_RA_INVALID_ITEM_ID');
1317: FND_MESSAGE.set_token('ITEM_ID',p_rev_adj_rec.from_inventory_item_id);
1318: FND_MSG_PUB.Add;
1319: x_return_status := FND_API.G_RET_STS_ERROR ;
1320: END IF;
1321: close c_item_id;

Line 1330: FND_MESSAGE.set_name (application => 'AR',

1326: FETCH c_item_exists_on_trx INTO l_item_count;
1327: CLOSE c_item_exists_on_trx;
1328: IF l_item_count = 0
1329: THEN
1330: FND_MESSAGE.set_name (application => 'AR',
1331: name => 'AR_RA_ITEM_NOT_ON_TRX');
1332: FND_MESSAGE.set_token('ITEM_ID',p_rev_adj_rec.from_inventory_item_id);
1333: FND_MSG_PUB.Add;
1334: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1332: FND_MESSAGE.set_token('ITEM_ID',p_rev_adj_rec.from_inventory_item_id);

1328: IF l_item_count = 0
1329: THEN
1330: FND_MESSAGE.set_name (application => 'AR',
1331: name => 'AR_RA_ITEM_NOT_ON_TRX');
1332: FND_MESSAGE.set_token('ITEM_ID',p_rev_adj_rec.from_inventory_item_id);
1333: FND_MSG_PUB.Add;
1334: x_return_status := FND_API.G_RET_STS_ERROR ;
1335: END IF;
1336: END IF;

Line 1400: FND_MESSAGE.set_name (application => 'AR',

1396: OPEN c_item_segs(l_segment_rec);
1397: FETCH c_item_segs INTO g_to_inventory_item_id;
1398: IF c_item_segs%NOTFOUND
1399: THEN
1400: FND_MESSAGE.set_name (application => 'AR',
1401: name => 'AR_RA_INVALID_ITEM_SEGMENTS');
1402: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||
1403: l_segment_rec.segment2||l_segment_rec.segment3||
1404: l_segment_rec.segment4||l_segment_rec.segment5||

Line 1402: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||

1398: IF c_item_segs%NOTFOUND
1399: THEN
1400: FND_MESSAGE.set_name (application => 'AR',
1401: name => 'AR_RA_INVALID_ITEM_SEGMENTS');
1402: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||
1403: l_segment_rec.segment2||l_segment_rec.segment3||
1404: l_segment_rec.segment4||l_segment_rec.segment5||
1405: l_segment_rec.segment6||l_segment_rec.segment7||
1406: l_segment_rec.segment8||l_segment_rec.segment9||

Line 1418: FND_MESSAGE.set_name (application => 'AR',

1414: x_return_status := FND_API.G_RET_STS_ERROR ;
1415: END IF;
1416: CLOSE c_item_segs;
1417: ELSE
1418: FND_MESSAGE.set_name (application => 'AR',
1419: name => 'AR_RA_NO_TO_ITEM');
1420: FND_MSG_PUB.Add;
1421: x_return_status := FND_API.G_RET_STS_ERROR ;
1422: END IF;

Line 1428: FND_MESSAGE.set_name (application => 'AR',

1424: OPEN c_item_id(p_rev_adj_rec.to_inventory_item_id);
1425: FETCH c_item_id INTO g_to_inventory_item_id;
1426: IF c_item_id%NOTFOUND
1427: THEN
1428: FND_MESSAGE.set_name (application => 'AR',
1429: name => 'AR_RA_INVALID_ITEM_ID');
1430: FND_MESSAGE.set_token('ITEM_ID',p_rev_adj_rec.to_inventory_item_id);
1431: FND_MSG_PUB.Add;
1432: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1430: FND_MESSAGE.set_token('ITEM_ID',p_rev_adj_rec.to_inventory_item_id);

1426: IF c_item_id%NOTFOUND
1427: THEN
1428: FND_MESSAGE.set_name (application => 'AR',
1429: name => 'AR_RA_INVALID_ITEM_ID');
1430: FND_MESSAGE.set_token('ITEM_ID',p_rev_adj_rec.to_inventory_item_id);
1431: FND_MSG_PUB.Add;
1432: x_return_status := FND_API.G_RET_STS_ERROR ;
1433: END IF;
1434: CLOSE c_item_id;

Line 1443: FND_MESSAGE.set_name (application => 'AR',

1439: FETCH c_item_exists_on_trx INTO l_item_count;
1440: CLOSE c_item_exists_on_trx;
1441: IF l_item_count = 0
1442: THEN
1443: FND_MESSAGE.set_name (application => 'AR',
1444: name => 'AR_RA_ITEM_NOT_ON_TRX');
1445: FND_MESSAGE.set_token('ITEM_ID',p_rev_adj_rec.to_inventory_item_id);
1446: FND_MSG_PUB.Add;
1447: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1445: FND_MESSAGE.set_token('ITEM_ID',p_rev_adj_rec.to_inventory_item_id);

1441: IF l_item_count = 0
1442: THEN
1443: FND_MESSAGE.set_name (application => 'AR',
1444: name => 'AR_RA_ITEM_NOT_ON_TRX');
1445: FND_MESSAGE.set_token('ITEM_ID',p_rev_adj_rec.to_inventory_item_id);
1446: FND_MSG_PUB.Add;
1447: x_return_status := FND_API.G_RET_STS_ERROR ;
1448: END IF;
1449: END IF;

Line 1458: FND_MESSAGE.set_name (application => 'AR',

1454: p_count => x_msg_count,
1455: p_data => x_msg_data);
1456: EXCEPTION
1457: WHEN TOO_MANY_ROWS THEN
1458: FND_MESSAGE.set_name (application => 'AR',
1459: name => 'AR_RA_INVALID_ITEM_SEGMENTS');
1460: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||
1461: l_segment_rec.segment2||l_segment_rec.segment3||
1462: l_segment_rec.segment4||l_segment_rec.segment5||

Line 1460: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||

1456: EXCEPTION
1457: WHEN TOO_MANY_ROWS THEN
1458: FND_MESSAGE.set_name (application => 'AR',
1459: name => 'AR_RA_INVALID_ITEM_SEGMENTS');
1460: FND_MESSAGE.set_token('CONCAT_SEGS', l_segment_rec.segment1||
1461: l_segment_rec.segment2||l_segment_rec.segment3||
1462: l_segment_rec.segment4||l_segment_rec.segment5||
1463: l_segment_rec.segment6||l_segment_rec.segment7||
1464: l_segment_rec.segment8||l_segment_rec.segment9||

Line 1523: FND_MESSAGE.set_name (application => 'AR',

1519: OPEN c_line_num(p_rev_adj_rec.from_line_number);
1520: FETCH c_line_num INTO g_from_cust_trx_line_id;
1521: IF c_line_num%NOTFOUND
1522: THEN
1523: FND_MESSAGE.set_name (application => 'AR',
1524: name => 'AR_RA_LINE_NOT_ON_TRX');
1525: FND_MESSAGE.set_token('LINE_NUMBER', p_rev_adj_rec.from_line_number);
1526: FND_MSG_PUB.Add;
1527: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1525: FND_MESSAGE.set_token('LINE_NUMBER', p_rev_adj_rec.from_line_number);

1521: IF c_line_num%NOTFOUND
1522: THEN
1523: FND_MESSAGE.set_name (application => 'AR',
1524: name => 'AR_RA_LINE_NOT_ON_TRX');
1525: FND_MESSAGE.set_token('LINE_NUMBER', p_rev_adj_rec.from_line_number);
1526: FND_MSG_PUB.Add;
1527: x_return_status := FND_API.G_RET_STS_ERROR ;
1528: END IF;
1529: CLOSE c_line_num;

Line 1532: FND_MESSAGE.set_name (application => 'AR',

1528: END IF;
1529: CLOSE c_line_num;
1530: ELSIF p_rev_adj_rec.line_selection_mode = 'L'
1531: THEN
1532: FND_MESSAGE.set_name (application => 'AR',
1533: name => 'AR_RA_NO_FROM_LINE');
1534: FND_MSG_PUB.Add;
1535: x_return_status := FND_API.G_RET_STS_ERROR ;
1536: END IF;

Line 1542: FND_MESSAGE.set_name (application => 'AR',

1538: OPEN c_line_id(p_rev_adj_rec.from_cust_trx_line_id);
1539: FETCH c_line_id INTO g_from_cust_trx_line_id;
1540: IF c_line_id%NOTFOUND
1541: THEN
1542: FND_MESSAGE.set_name (application => 'AR',
1543: name => 'AR_RA_INVALID_LINE_ID');
1544: FND_MESSAGE.set_token('CUST_TRX_LINE_ID',
1545: p_rev_adj_rec.from_cust_trx_line_id);
1546: FND_MSG_PUB.Add;

Line 1544: FND_MESSAGE.set_token('CUST_TRX_LINE_ID',

1540: IF c_line_id%NOTFOUND
1541: THEN
1542: FND_MESSAGE.set_name (application => 'AR',
1543: name => 'AR_RA_INVALID_LINE_ID');
1544: FND_MESSAGE.set_token('CUST_TRX_LINE_ID',
1545: p_rev_adj_rec.from_cust_trx_line_id);
1546: FND_MSG_PUB.Add;
1547: x_return_status := FND_API.G_RET_STS_ERROR ;
1548: END IF;

Line 1606: FND_MESSAGE.set_name('AR','AR_RA_GL_DATE_CHANGED');

1602: error_message => l_err_mesg)
1603: THEN
1604: IF p_gl_date <> l_valid_gl_date
1605: THEN
1606: FND_MESSAGE.set_name('AR','AR_RA_GL_DATE_CHANGED');
1607: FND_MESSAGE.set_token('GL_DATE',p_gl_date);
1608: FND_MESSAGE.set_token('NEW_GL_DATE',l_valid_gl_date);
1609: FND_MSG_PUB.Add;
1610: END IF;

Line 1607: FND_MESSAGE.set_token('GL_DATE',p_gl_date);

1603: THEN
1604: IF p_gl_date <> l_valid_gl_date
1605: THEN
1606: FND_MESSAGE.set_name('AR','AR_RA_GL_DATE_CHANGED');
1607: FND_MESSAGE.set_token('GL_DATE',p_gl_date);
1608: FND_MESSAGE.set_token('NEW_GL_DATE',l_valid_gl_date);
1609: FND_MSG_PUB.Add;
1610: END IF;
1611: END IF;

Line 1608: FND_MESSAGE.set_token('NEW_GL_DATE',l_valid_gl_date);

1604: IF p_gl_date <> l_valid_gl_date
1605: THEN
1606: FND_MESSAGE.set_name('AR','AR_RA_GL_DATE_CHANGED');
1607: FND_MESSAGE.set_token('GL_DATE',p_gl_date);
1608: FND_MESSAGE.set_token('NEW_GL_DATE',l_valid_gl_date);
1609: FND_MSG_PUB.Add;
1610: END IF;
1611: END IF;
1612: RETURN l_valid_gl_date;

Line 1672: FND_MESSAGE.set_name (application => 'AR',

1668: END IF;
1669: IF p_rev_adj_rec.adjustment_type NOT IN ('UN','EA','SA','NR')
1670: -- 'LL' temporarily disabled
1671: THEN
1672: FND_MESSAGE.set_name (application => 'AR',
1673: name => 'AR_RA_INVALID_ADJUST_TYPE');
1674: FND_MESSAGE.set_token('ADJUST_TYPE', p_rev_adj_rec.adjustment_type);
1675: FND_MSG_PUB.Add;
1676: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1674: FND_MESSAGE.set_token('ADJUST_TYPE', p_rev_adj_rec.adjustment_type);

1670: -- 'LL' temporarily disabled
1671: THEN
1672: FND_MESSAGE.set_name (application => 'AR',
1673: name => 'AR_RA_INVALID_ADJUST_TYPE');
1674: FND_MESSAGE.set_token('ADJUST_TYPE', p_rev_adj_rec.adjustment_type);
1675: FND_MSG_PUB.Add;
1676: x_return_status := FND_API.G_RET_STS_ERROR ;
1677: END IF;
1678: IF p_rev_adj_rec.sales_credit_type NOT IN ('R','N','B')

Line 1680: FND_MESSAGE.set_name (application => 'AR',

1676: x_return_status := FND_API.G_RET_STS_ERROR ;
1677: END IF;
1678: IF p_rev_adj_rec.sales_credit_type NOT IN ('R','N','B')
1679: THEN
1680: FND_MESSAGE.set_name (application => 'AR',
1681: name => 'AR_RA_INVALID_SALESCRED_TYPE');
1682: FND_MESSAGE.set_token('SALESCRED_TYPE', p_rev_adj_rec.sales_credit_type);
1683: FND_MSG_PUB.Add;
1684: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1682: FND_MESSAGE.set_token('SALESCRED_TYPE', p_rev_adj_rec.sales_credit_type);

1678: IF p_rev_adj_rec.sales_credit_type NOT IN ('R','N','B')
1679: THEN
1680: FND_MESSAGE.set_name (application => 'AR',
1681: name => 'AR_RA_INVALID_SALESCRED_TYPE');
1682: FND_MESSAGE.set_token('SALESCRED_TYPE', p_rev_adj_rec.sales_credit_type);
1683: FND_MSG_PUB.Add;
1684: x_return_status := FND_API.G_RET_STS_ERROR ;
1685: END IF;
1686: IF p_rev_adj_rec.amount_mode NOT IN ('T','A','P')

Line 1688: FND_MESSAGE.set_name (application => 'AR',

1684: x_return_status := FND_API.G_RET_STS_ERROR ;
1685: END IF;
1686: IF p_rev_adj_rec.amount_mode NOT IN ('T','A','P')
1687: THEN
1688: FND_MESSAGE.set_name (application => 'AR',
1689: name => 'AR_RA_INVALID_AMOUNT_MODE');
1690: FND_MESSAGE.set_token('AMOUNT_MODE', p_rev_adj_rec.amount_mode);
1691: FND_MSG_PUB.Add;
1692: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1690: FND_MESSAGE.set_token('AMOUNT_MODE', p_rev_adj_rec.amount_mode);

1686: IF p_rev_adj_rec.amount_mode NOT IN ('T','A','P')
1687: THEN
1688: FND_MESSAGE.set_name (application => 'AR',
1689: name => 'AR_RA_INVALID_AMOUNT_MODE');
1690: FND_MESSAGE.set_token('AMOUNT_MODE', p_rev_adj_rec.amount_mode);
1691: FND_MSG_PUB.Add;
1692: x_return_status := FND_API.G_RET_STS_ERROR ;
1693: END IF;
1694: IF p_rev_adj_rec.line_selection_mode NOT IN ('A','C','I','S')

Line 1696: FND_MESSAGE.set_name (application => 'AR',

1692: x_return_status := FND_API.G_RET_STS_ERROR ;
1693: END IF;
1694: IF p_rev_adj_rec.line_selection_mode NOT IN ('A','C','I','S')
1695: THEN
1696: FND_MESSAGE.set_name (application => 'AR',
1697: name => 'AR_RA_INVALID_LINE_MODE');
1698: FND_MESSAGE.set_token('LINE_MODE', p_rev_adj_rec.line_selection_mode);
1699: FND_MSG_PUB.Add;
1700: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1698: FND_MESSAGE.set_token('LINE_MODE', p_rev_adj_rec.line_selection_mode);

1694: IF p_rev_adj_rec.line_selection_mode NOT IN ('A','C','I','S')
1695: THEN
1696: FND_MESSAGE.set_name (application => 'AR',
1697: name => 'AR_RA_INVALID_LINE_MODE');
1698: FND_MESSAGE.set_token('LINE_MODE', p_rev_adj_rec.line_selection_mode);
1699: FND_MSG_PUB.Add;
1700: x_return_status := FND_API.G_RET_STS_ERROR ;
1701: END IF;
1702: IF AR_Revenue_Adjustment_PVT.g_update_db_flag = 'Y'

Line 1717: FND_MESSAGE.set_name (application => 'AR',

1713: END IF;
1714: IF l_meaning IS NULL
1715: THEN
1716: /* Bug 2312077 - incorrect message replaced */
1717: FND_MESSAGE.set_name (application => 'AR',
1718: name => 'AR_RA_INVALID_REASON');
1719: FND_MESSAGE.set_token('REASON_CODE', p_rev_adj_rec.reason_code);
1720: FND_MSG_PUB.Add;
1721: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1719: FND_MESSAGE.set_token('REASON_CODE', p_rev_adj_rec.reason_code);

1715: THEN
1716: /* Bug 2312077 - incorrect message replaced */
1717: FND_MESSAGE.set_name (application => 'AR',
1718: name => 'AR_RA_INVALID_REASON');
1719: FND_MESSAGE.set_token('REASON_CODE', p_rev_adj_rec.reason_code);
1720: FND_MSG_PUB.Add;
1721: x_return_status := FND_API.G_RET_STS_ERROR ;
1722: END IF;
1723: END IF;

Line 1906: FND_MESSAGE.set_name('AR','AR_RA_NO_SELECTED_SALESCRED');

1902: (p_sales_credit_type = 'N' AND l_non_revenue_percent_total = 0) OR
1903: (p_sales_credit_type = 'B' AND l_revenue_percent_total = 0
1904: AND l_non_revenue_percent_total = 0)
1905: THEN
1906: FND_MESSAGE.set_name('AR','AR_RA_NO_SELECTED_SALESCRED');
1907: FND_MSG_PUB.Add;
1908: x_return_status := FND_API.G_RET_STS_ERROR ;
1909: END IF;
1910: FND_MSG_PUB.Count_And_Get

Line 2463: FND_MESSAGE.set_name

2459: WHEN invalid_amount THEN
2460: IF p_amount_mode = 'P'
2461: THEN
2462: l_max_percent := ROUND(l_adjustable_revenue / l_revenue_total * 100,4);
2463: FND_MESSAGE.set_name
2464: (application => 'AR', name => 'AR_RA_PCT_EXCEEDS_AVAIL_PCT');
2465: FND_MESSAGE.set_token('TOT_AVAIL_PCT',l_max_percent);
2466: ELSE
2467: FND_MESSAGE.set_name

Line 2465: FND_MESSAGE.set_token('TOT_AVAIL_PCT',l_max_percent);

2461: THEN
2462: l_max_percent := ROUND(l_adjustable_revenue / l_revenue_total * 100,4);
2463: FND_MESSAGE.set_name
2464: (application => 'AR', name => 'AR_RA_PCT_EXCEEDS_AVAIL_PCT');
2465: FND_MESSAGE.set_token('TOT_AVAIL_PCT',l_max_percent);
2466: ELSE
2467: FND_MESSAGE.set_name
2468: (application => 'AR', name => 'AR_RA_AMT_EXCEEDS_AVAIL_REV');
2469: FND_MESSAGE.set_token('TOT_AVAIL_REV',

Line 2467: FND_MESSAGE.set_name

2463: FND_MESSAGE.set_name
2464: (application => 'AR', name => 'AR_RA_PCT_EXCEEDS_AVAIL_PCT');
2465: FND_MESSAGE.set_token('TOT_AVAIL_PCT',l_max_percent);
2466: ELSE
2467: FND_MESSAGE.set_name
2468: (application => 'AR', name => 'AR_RA_AMT_EXCEEDS_AVAIL_REV');
2469: FND_MESSAGE.set_token('TOT_AVAIL_REV',
2470: g_trx_currency||' '||
2471: TO_CHAR(l_adjustable_revenue,g_trx_curr_format));

Line 2469: FND_MESSAGE.set_token('TOT_AVAIL_REV',

2465: FND_MESSAGE.set_token('TOT_AVAIL_PCT',l_max_percent);
2466: ELSE
2467: FND_MESSAGE.set_name
2468: (application => 'AR', name => 'AR_RA_AMT_EXCEEDS_AVAIL_REV');
2469: FND_MESSAGE.set_token('TOT_AVAIL_REV',
2470: g_trx_currency||' '||
2471: TO_CHAR(l_adjustable_revenue,g_trx_curr_format));
2472: END IF;
2473: FND_MSG_PUB.Add;

Line 2480: FND_MESSAGE.set_name

2476: (p_encoded => FND_API.G_FALSE,
2477: p_count => x_msg_count,
2478: p_data => x_msg_data);
2479: WHEN invalid_zero THEN
2480: FND_MESSAGE.set_name
2481: (application => 'AR', name => 'AR_RA_ZERO_AMOUNT');
2482: FND_MSG_PUB.Add;
2483: x_return_status := FND_API.G_RET_STS_ERROR ;
2484: FND_MSG_PUB.Count_And_Get

Line 2489: FND_MESSAGE.set_name

2485: (p_encoded => FND_API.G_FALSE,
2486: p_count => x_msg_count,
2487: p_data => x_msg_data);
2488: WHEN adjusted_by_other_user THEN
2489: FND_MESSAGE.set_name
2490: (application => 'AR', name => 'AR_RA_ADJUSTED_BY_OTHER_USER');
2491: FND_MSG_PUB.Add;
2492: x_return_status := FND_API.G_RET_STS_ERROR ;
2493: FND_MSG_PUB.Count_And_Get

Line 2552: FND_MESSAGE.set_name('AR','AR_RA_GL_DATE_CHANGED');

2548: UPDATE ra_cust_trx_line_gl_dist
2549: SET gl_date = l_gl_date
2550: WHERE revenue_adjustment_id = p_revenue_adjustment_id
2551: AND gl_date = c1.gl_date;
2552: FND_MESSAGE.set_name('AR','AR_RA_GL_DATE_CHANGED');
2553: FND_MESSAGE.set_token('GL_DATE',c1.gl_date);
2554: FND_MESSAGE.set_token('NEW_GL_DATE',l_gl_date);
2555: FND_MSG_PUB.Add;
2556: l_change_count := l_change_count + 1;

Line 2553: FND_MESSAGE.set_token('GL_DATE',c1.gl_date);

2549: SET gl_date = l_gl_date
2550: WHERE revenue_adjustment_id = p_revenue_adjustment_id
2551: AND gl_date = c1.gl_date;
2552: FND_MESSAGE.set_name('AR','AR_RA_GL_DATE_CHANGED');
2553: FND_MESSAGE.set_token('GL_DATE',c1.gl_date);
2554: FND_MESSAGE.set_token('NEW_GL_DATE',l_gl_date);
2555: FND_MSG_PUB.Add;
2556: l_change_count := l_change_count + 1;
2557: END IF;

Line 2554: FND_MESSAGE.set_token('NEW_GL_DATE',l_gl_date);

2550: WHERE revenue_adjustment_id = p_revenue_adjustment_id
2551: AND gl_date = c1.gl_date;
2552: FND_MESSAGE.set_name('AR','AR_RA_GL_DATE_CHANGED');
2553: FND_MESSAGE.set_token('GL_DATE',c1.gl_date);
2554: FND_MESSAGE.set_token('NEW_GL_DATE',l_gl_date);
2555: FND_MSG_PUB.Add;
2556: l_change_count := l_change_count + 1;
2557: END IF;
2558: ELSE

Line 2559: FND_MESSAGE.set_name('AR','AR_RA_NO_OPEN_PERIODS');

2555: FND_MSG_PUB.Add;
2556: l_change_count := l_change_count + 1;
2557: END IF;
2558: ELSE
2559: FND_MESSAGE.set_name('AR','AR_RA_NO_OPEN_PERIODS');
2560: RETURN FND_API.G_FALSE;
2561: END IF;
2562: END LOOP;
2563: IF l_change_count > 0