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_MSG_PUB

Line 191: FND_MSG_PUB.initialize;

187: END IF;
188: -- Initialize message list if p_init_msg_list is set to TRUE.
189: IF FND_API.to_Boolean( p_init_msg_list )
190: THEN
191: FND_MSG_PUB.initialize;
192: END IF;
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194: Validate_Transaction (p_init_msg_list => FND_API.G_FALSE
195: ,p_rev_adj_rec => p_rev_adj_rec

Line 348: FND_MSG_PUB.initialize;

344: END IF;
345: -- Initialize message list if p_init_msg_list is set to TRUE.
346: IF FND_API.to_Boolean( p_init_msg_list )
347: THEN
348: FND_MSG_PUB.initialize;
349: END IF;
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL
352: THEN

Line 367: FND_MSG_PUB.Add;

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;
371: IF c_trx_num%FOUND

Line 377: FND_MSG_PUB.Add;

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;
381: CLOSE c_trx_num;

Line 385: FND_MSG_PUB.Add;

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;
388: ELSE
389: OPEN c_trx_id;

Line 396: FND_MSG_PUB.Add;

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

Line 413: FND_MSG_PUB.Add;

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
417: -- ORASHID

Line 421: -- FND_MSG_PUB.Add;

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'
425: THEN

Line 427: FND_MSG_PUB.Add;

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
431: -- ORASHID

Line 435: -- FND_MSG_PUB.Add;

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'
439: THEN

Line 441: FND_MSG_PUB.Add;

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
445: credit memos if they are on-account or use_inv_acct=N */

Line 455: FND_MSG_PUB.Add;

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

Line 483: FND_MSG_PUB.Add;

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
487: --

Line 489: FND_MSG_PUB.Add;

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;
493: FND_MSG_PUB.Count_And_Get

Line 493: FND_MSG_PUB.Count_And_Get

489: FND_MSG_PUB.Add;
490: END IF;
491: END IF;
492: END IF;
493: FND_MSG_PUB.Count_And_Get
494: (p_encoded => FND_API.G_FALSE,
495: p_count => x_msg_count,
496: p_data => x_msg_data);
497: EXCEPTION

Line 614: FND_MSG_PUB.initialize;

610: END IF;
611: -- Initialize message list if p_init_msg_list is set to TRUE.
612: IF FND_API.to_Boolean( p_init_msg_list )
613: THEN
614: FND_MSG_PUB.initialize;
615: END IF;
616: --
617: -- Validate from salesrep
618: --

Line 648: FND_MSG_PUB.Add;

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;
651: CLOSE c_salesrep_num;
652: END IF;

Line 662: FND_MSG_PUB.Add;

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;
665: CLOSE c_salesrep_id;
666: END IF;

Line 727: FND_MSG_PUB.Add;

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));
725: /* Multi-Org Access Control Changes for SSA;end;anukumar;11/01/2002*/
726: --end anuj
727: FND_MSG_PUB.Add;
728: x_return_status := FND_API.G_RET_STS_ERROR ;
729: END IF;
730: END IF;
731: --END IF; -- commented for bug 3067675

Line 755: FND_MSG_PUB.Add;

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'));
755: FND_MSG_PUB.Add;
756: x_return_status := FND_API.G_RET_STS_ERROR ;
757: ELSE
758: OPEN c_salesrep_num (p_rev_adj_rec.to_salesrep_number);
759: FETCH c_salesrep_num INTO g_to_salesrep_id;

Line 771: FND_MSG_PUB.Add;

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;
774: CLOSE c_salesrep_num;
775: END IF;

Line 785: FND_MSG_PUB.Add;

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;
788: CLOSE c_salesrep_id;
789: END IF;

Line 816: FND_MSG_PUB.Add;

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;
819: CLOSE c_salesgroup_id;
820: END IF;

Line 825: FND_MSG_PUB.Count_And_Get

821: END IF;
822: END IF;
823: /* END bug 3067675 */
824:
825: FND_MSG_PUB.Count_And_Get
826: (p_encoded => FND_API.G_FALSE,
827: p_count => x_msg_count,
828: p_data => x_msg_data);
829: EXCEPTION

Line 907: FND_MSG_PUB.initialize;

903:
904: -- Initialize message list if p_init_msg_list is set to TRUE.
905: IF FND_API.to_Boolean( p_init_msg_list )
906: THEN
907: FND_MSG_PUB.initialize;
908: END IF;
909: --
910: -- Validate category
911: --

Line 981: FND_MSG_PUB.Add;

977: l_segment_rec.segment14||l_segment_rec.segment15||
978: l_segment_rec.segment16||l_segment_rec.segment17||
979: l_segment_rec.segment18||l_segment_rec.segment19||
980: l_segment_rec.segment20);
981: FND_MSG_PUB.Add;
982: x_return_status := FND_API.G_RET_STS_ERROR ;
983: END IF;
984: CLOSE c_category_segs;
985: ELSIF p_rev_adj_rec.line_selection_mode = 'C'

Line 989: FND_MSG_PUB.Add;

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;
992: ELSE
993: OPEN c_category_id(p_rev_adj_rec.from_category_id);

Line 1000: FND_MSG_PUB.Add;

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

Line 1015: FND_MSG_PUB.Add;

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

Line 1094: FND_MSG_PUB.Add;

1090: l_segment_rec.segment14||l_segment_rec.segment15||
1091: l_segment_rec.segment16||l_segment_rec.segment17||
1092: l_segment_rec.segment18||l_segment_rec.segment19||
1093: l_segment_rec.segment20);
1094: FND_MSG_PUB.Add;
1095: x_return_status := FND_API.G_RET_STS_ERROR ;
1096: END IF;
1097: CLOSE c_category_segs;
1098: ELSE

Line 1101: FND_MSG_PUB.Add;

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;
1104: ELSE
1105: OPEN c_category_id(p_rev_adj_rec.to_category_id);

Line 1112: FND_MSG_PUB.Add;

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

Line 1127: FND_MSG_PUB.Add;

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

Line 1133: FND_MSG_PUB.Count_And_Get

1129: END IF;
1130: END IF;
1131: END IF;
1132: END IF;
1133: FND_MSG_PUB.Count_And_Get
1134: (p_encoded => FND_API.G_FALSE,
1135: p_count => x_msg_count,
1136: p_data => x_msg_data);
1137: EXCEPTION

Line 1152: FND_MSG_PUB.Add;

1148: l_segment_rec.segment14||l_segment_rec.segment15||
1149: l_segment_rec.segment16||l_segment_rec.segment17||
1150: l_segment_rec.segment18||l_segment_rec.segment19||
1151: l_segment_rec.segment20);
1152: FND_MSG_PUB.Add;
1153: x_return_status := FND_API.G_RET_STS_ERROR ;
1154: WHEN OTHERS THEN
1155: IF PG_DEBUG in ('Y', 'C') THEN
1156: arp_util.debug('Validate_Category: ' || 'Unexpected error '||sqlerrm||

Line 1225: FND_MSG_PUB.initialize;

1221: END IF;
1222: -- Initialize message list if p_init_msg_list is set to TRUE.
1223: IF FND_API.to_Boolean( p_init_msg_list )
1224: THEN
1225: FND_MSG_PUB.initialize;
1226: END IF;
1227: --
1228: -- Validate from item
1229: --

Line 1299: FND_MSG_PUB.Add;

1295: l_segment_rec.segment14||l_segment_rec.segment15||
1296: l_segment_rec.segment16||l_segment_rec.segment17||
1297: l_segment_rec.segment18||l_segment_rec.segment19||
1298: l_segment_rec.segment20);
1299: FND_MSG_PUB.Add;
1300: x_return_status := FND_API.G_RET_STS_ERROR ;
1301: END IF;
1302: CLOSE c_item_segs;
1303: ELSIF p_rev_adj_rec.line_selection_mode = 'I'

Line 1307: FND_MSG_PUB.Add;

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;
1310: ELSE
1311: OPEN c_item_id(p_rev_adj_rec.from_inventory_item_id);

Line 1318: FND_MSG_PUB.Add;

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

Line 1333: FND_MSG_PUB.Add;

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

Line 1413: FND_MSG_PUB.Add;

1409: l_segment_rec.segment14||l_segment_rec.segment15||
1410: l_segment_rec.segment16||l_segment_rec.segment17||
1411: l_segment_rec.segment18||l_segment_rec.segment19||
1412: l_segment_rec.segment20);
1413: FND_MSG_PUB.Add;
1414: x_return_status := FND_API.G_RET_STS_ERROR ;
1415: END IF;
1416: CLOSE c_item_segs;
1417: ELSE

Line 1420: FND_MSG_PUB.Add;

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;
1423: ELSE
1424: OPEN c_item_id(p_rev_adj_rec.to_inventory_item_id);

Line 1431: FND_MSG_PUB.Add;

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

Line 1446: FND_MSG_PUB.Add;

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

Line 1452: FND_MSG_PUB.Count_And_Get

1448: END IF;
1449: END IF;
1450: END IF;
1451: END IF;
1452: FND_MSG_PUB.Count_And_Get
1453: (p_encoded => FND_API.G_FALSE,
1454: p_count => x_msg_count,
1455: p_data => x_msg_data);
1456: EXCEPTION

Line 1471: FND_MSG_PUB.Add;

1467: l_segment_rec.segment14||l_segment_rec.segment15||
1468: l_segment_rec.segment16||l_segment_rec.segment17||
1469: l_segment_rec.segment18||l_segment_rec.segment19||
1470: l_segment_rec.segment20);
1471: FND_MSG_PUB.Add;
1472: x_return_status := FND_API.G_RET_STS_ERROR ;
1473: WHEN OTHERS THEN
1474: IF PG_DEBUG in ('Y', 'C') THEN
1475: arp_util.debug('Validate_Item: ' || 'Unexpected error '||sqlerrm||

Line 1510: FND_MSG_PUB.initialize;

1506: END IF;
1507: -- Initialize message list if p_init_msg_list is set to TRUE.
1508: IF FND_API.to_Boolean( p_init_msg_list )
1509: THEN
1510: FND_MSG_PUB.initialize;
1511: END IF;
1512: --
1513: -- Validate from line
1514: --

Line 1526: FND_MSG_PUB.Add;

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;
1530: ELSIF p_rev_adj_rec.line_selection_mode = 'L'

Line 1534: FND_MSG_PUB.Add;

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;
1537: ELSE
1538: OPEN c_line_id(p_rev_adj_rec.from_cust_trx_line_id);

Line 1546: FND_MSG_PUB.Add;

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;
1549: CLOSE c_line_id;
1550: END IF;

Line 1552: FND_MSG_PUB.Count_And_Get

1548: END IF;
1549: CLOSE c_line_id;
1550: END IF;
1551:
1552: FND_MSG_PUB.Count_And_Get
1553: (p_encoded => FND_API.G_FALSE,
1554: p_count => x_msg_count,
1555: p_data => x_msg_data);
1556: EXCEPTION

Line 1610: FND_MSG_PUB.Add;

1606: FND_MESSAGE.set_name('AR','AR_RA_GL_DATE_CHANGED');
1607: --Int'l Calendar Project
1608: FND_MESSAGE.set_token('GL_DATE',fnd_date.date_to_chardate(p_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
1609: FND_MESSAGE.set_token('NEW_GL_DATE',fnd_date.date_to_chardate(l_valid_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
1610: FND_MSG_PUB.Add;
1611: END IF;
1612: END IF;
1613: RETURN l_valid_gl_date;
1614: EXCEPTION

Line 1668: FND_MSG_PUB.initialize;

1664: END IF;
1665: -- Initialize message list if p_init_msg_list is set to TRUE.
1666: IF FND_API.to_Boolean( p_init_msg_list )
1667: THEN
1668: FND_MSG_PUB.initialize;
1669: END IF;
1670: IF p_rev_adj_rec.adjustment_type NOT IN ('UN','EA','SA','NR')
1671: -- 'LL' temporarily disabled
1672: THEN

Line 1676: FND_MSG_PUB.Add;

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

Line 1684: FND_MSG_PUB.Add;

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

Line 1692: FND_MSG_PUB.Add;

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

Line 1700: FND_MSG_PUB.Add;

1696: THEN
1697: FND_MESSAGE.set_name (application => 'AR',
1698: name => 'AR_RA_INVALID_LINE_MODE');
1699: FND_MESSAGE.set_token('LINE_MODE', p_rev_adj_rec.line_selection_mode);
1700: FND_MSG_PUB.Add;
1701: x_return_status := FND_API.G_RET_STS_ERROR ;
1702: END IF;
1703: IF AR_Revenue_Adjustment_PVT.g_update_db_flag = 'Y'
1704: THEN

Line 1721: FND_MSG_PUB.Add;

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

Line 1754: FND_MSG_PUB.Count_And_Get

1750: FND_API.G_RET_STS_SUCCESS
1751: THEN
1752: x_return_status := l_df_return_status;
1753: END IF;
1754: FND_MSG_PUB.Count_And_Get
1755: (p_encoded => FND_API.G_FALSE,
1756: p_count => x_msg_count,
1757: p_data => x_msg_data);
1758: EXCEPTION

Line 1895: FND_MSG_PUB.initialize;

1891: END IF;
1892: -- Initialize message list if p_init_msg_list is set to TRUE.
1893: IF FND_API.to_Boolean( p_init_msg_list )
1894: THEN
1895: FND_MSG_PUB.initialize;
1896: END IF;
1897: x_return_status := FND_API.G_RET_STS_SUCCESS;
1898: OPEN c_salesrep_totals;
1899: FETCH c_salesrep_totals INTO l_revenue_percent_total,

Line 1908: FND_MSG_PUB.Add;

1904: (p_sales_credit_type = 'B' AND l_revenue_percent_total = 0
1905: AND l_non_revenue_percent_total = 0)
1906: THEN
1907: FND_MESSAGE.set_name('AR','AR_RA_NO_SELECTED_SALESCRED');
1908: FND_MSG_PUB.Add;
1909: x_return_status := FND_API.G_RET_STS_ERROR ;
1910: END IF;
1911: FND_MSG_PUB.Count_And_Get
1912: (p_encoded => FND_API.G_FALSE,

Line 1911: FND_MSG_PUB.Count_And_Get

1907: FND_MESSAGE.set_name('AR','AR_RA_NO_SELECTED_SALESCRED');
1908: FND_MSG_PUB.Add;
1909: x_return_status := FND_API.G_RET_STS_ERROR ;
1910: END IF;
1911: FND_MSG_PUB.Count_And_Get
1912: (p_encoded => FND_API.G_FALSE,
1913: p_count => x_msg_count,
1914: p_data => x_msg_data);
1915: EXCEPTION

Line 2531: FND_MSG_PUB.initialize;

2527:
2528: -- Initialize message list if p_init_msg_list is set to TRUE.
2529: IF FND_API.to_Boolean( p_init_msg_list )
2530: THEN
2531: FND_MSG_PUB.initialize;
2532: END IF;
2533: x_return_status := FND_API.G_RET_STS_SUCCESS;
2534: IF NVL(g_last_customer_trx_id,p_customer_trx_id - 1) <> p_customer_trx_id
2535: THEN

Line 2632: FND_MSG_PUB.Add;

2628: FND_MESSAGE.set_token('TOT_AVAIL_REV',
2629: g_trx_currency||' '||
2630: TO_CHAR(l_adjustable_revenue,g_trx_curr_format));
2631: END IF;
2632: FND_MSG_PUB.Add;
2633: x_return_status := FND_API.G_RET_STS_ERROR ;
2634: FND_MSG_PUB.Count_And_Get
2635: (p_encoded => FND_API.G_FALSE,
2636: p_count => x_msg_count,

Line 2634: FND_MSG_PUB.Count_And_Get

2630: TO_CHAR(l_adjustable_revenue,g_trx_curr_format));
2631: END IF;
2632: FND_MSG_PUB.Add;
2633: x_return_status := FND_API.G_RET_STS_ERROR ;
2634: FND_MSG_PUB.Count_And_Get
2635: (p_encoded => FND_API.G_FALSE,
2636: p_count => x_msg_count,
2637: p_data => x_msg_data);
2638: WHEN invalid_zero THEN

Line 2641: FND_MSG_PUB.Add;

2637: p_data => x_msg_data);
2638: WHEN invalid_zero THEN
2639: FND_MESSAGE.set_name
2640: (application => 'AR', name => 'AR_RA_ZERO_AMOUNT');
2641: FND_MSG_PUB.Add;
2642: x_return_status := FND_API.G_RET_STS_ERROR ;
2643: FND_MSG_PUB.Count_And_Get
2644: (p_encoded => FND_API.G_FALSE,
2645: p_count => x_msg_count,

Line 2643: FND_MSG_PUB.Count_And_Get

2639: FND_MESSAGE.set_name
2640: (application => 'AR', name => 'AR_RA_ZERO_AMOUNT');
2641: FND_MSG_PUB.Add;
2642: x_return_status := FND_API.G_RET_STS_ERROR ;
2643: FND_MSG_PUB.Count_And_Get
2644: (p_encoded => FND_API.G_FALSE,
2645: p_count => x_msg_count,
2646: p_data => x_msg_data);
2647: WHEN adjusted_by_other_user THEN

Line 2650: FND_MSG_PUB.Add;

2646: p_data => x_msg_data);
2647: WHEN adjusted_by_other_user THEN
2648: FND_MESSAGE.set_name
2649: (application => 'AR', name => 'AR_RA_ADJUSTED_BY_OTHER_USER');
2650: FND_MSG_PUB.Add;
2651: x_return_status := FND_API.G_RET_STS_ERROR ;
2652: FND_MSG_PUB.Count_And_Get
2653: (p_encoded => FND_API.G_FALSE,
2654: p_count => x_msg_count,

Line 2652: FND_MSG_PUB.Count_And_Get

2648: FND_MESSAGE.set_name
2649: (application => 'AR', name => 'AR_RA_ADJUSTED_BY_OTHER_USER');
2650: FND_MSG_PUB.Add;
2651: x_return_status := FND_API.G_RET_STS_ERROR ;
2652: FND_MSG_PUB.Count_And_Get
2653: (p_encoded => FND_API.G_FALSE,
2654: p_count => x_msg_count,
2655: p_data => x_msg_data);
2656: WHEN OTHERS THEN

Line 2715: FND_MSG_PUB.Add;

2711: FND_MESSAGE.set_name('AR','AR_RA_GL_DATE_CHANGED');
2712: --Int'l Calendar Project
2713: FND_MESSAGE.set_token('GL_DATE',fnd_date.date_to_chardate(c1.gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
2714: FND_MESSAGE.set_token('NEW_GL_DATE',fnd_date.date_to_chardate(l_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
2715: FND_MSG_PUB.Add;
2716: l_change_count := l_change_count + 1;
2717: END IF;
2718: ELSE
2719: FND_MESSAGE.set_name('AR','AR_RA_NO_OPEN_PERIODS');

Line 2725: FND_MSG_PUB.Count_And_Get

2721: END IF;
2722: END LOOP;
2723: IF l_change_count > 0
2724: THEN
2725: FND_MSG_PUB.Count_And_Get
2726: (p_encoded => FND_API.G_FALSE,
2727: p_count => x_msg_count,
2728: p_data => x_msg_data);
2729: RETURN FND_API.G_FALSE;