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 1609: FND_MSG_PUB.Add;

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;
1613: EXCEPTION

Line 1667: FND_MSG_PUB.initialize;

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

Line 1675: FND_MSG_PUB.Add;

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')
1679: THEN

Line 1683: FND_MSG_PUB.Add;

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')
1687: THEN

Line 1691: FND_MSG_PUB.Add;

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')
1695: THEN

Line 1699: FND_MSG_PUB.Add;

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

Line 1720: FND_MSG_PUB.Add;

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;
1724:

Line 1753: FND_MSG_PUB.Count_And_Get

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

Line 1894: FND_MSG_PUB.initialize;

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

Line 1907: FND_MSG_PUB.Add;

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
1911: (p_encoded => FND_API.G_FALSE,

Line 1910: FND_MSG_PUB.Count_And_Get

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
1911: (p_encoded => FND_API.G_FALSE,
1912: p_count => x_msg_count,
1913: p_data => x_msg_data);
1914: EXCEPTION

Line 2373: FND_MSG_PUB.initialize;

2369:
2370: -- Initialize message list if p_init_msg_list is set to TRUE.
2371: IF FND_API.to_Boolean( p_init_msg_list )
2372: THEN
2373: FND_MSG_PUB.initialize;
2374: END IF;
2375: x_return_status := FND_API.G_RET_STS_SUCCESS;
2376: IF NVL(g_last_customer_trx_id,p_customer_trx_id - 1) <> p_customer_trx_id
2377: THEN

Line 2473: FND_MSG_PUB.Add;

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;
2474: x_return_status := FND_API.G_RET_STS_ERROR ;
2475: FND_MSG_PUB.Count_And_Get
2476: (p_encoded => FND_API.G_FALSE,
2477: p_count => x_msg_count,

Line 2475: FND_MSG_PUB.Count_And_Get

2471: TO_CHAR(l_adjustable_revenue,g_trx_curr_format));
2472: END IF;
2473: FND_MSG_PUB.Add;
2474: x_return_status := FND_API.G_RET_STS_ERROR ;
2475: FND_MSG_PUB.Count_And_Get
2476: (p_encoded => FND_API.G_FALSE,
2477: p_count => x_msg_count,
2478: p_data => x_msg_data);
2479: WHEN invalid_zero THEN

Line 2482: FND_MSG_PUB.Add;

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
2485: (p_encoded => FND_API.G_FALSE,
2486: p_count => x_msg_count,

Line 2484: FND_MSG_PUB.Count_And_Get

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

Line 2491: FND_MSG_PUB.Add;

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
2494: (p_encoded => FND_API.G_FALSE,
2495: p_count => x_msg_count,

Line 2493: FND_MSG_PUB.Count_And_Get

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
2494: (p_encoded => FND_API.G_FALSE,
2495: p_count => x_msg_count,
2496: p_data => x_msg_data);
2497: WHEN OTHERS THEN

Line 2555: FND_MSG_PUB.Add;

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
2559: FND_MESSAGE.set_name('AR','AR_RA_NO_OPEN_PERIODS');

Line 2565: FND_MSG_PUB.Count_And_Get

2561: END IF;
2562: END LOOP;
2563: IF l_change_count > 0
2564: THEN
2565: FND_MSG_PUB.Count_And_Get
2566: (p_encoded => FND_API.G_FALSE,
2567: p_count => x_msg_count,
2568: p_data => x_msg_data);
2569: RETURN FND_API.G_FALSE;