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.ARP_DEDUCTION_COVER dependencies on ARP_STANDARD

Line 76: arp_standard.debug('ARP_DEDUCTION_COVER.update_amount_in_dispute()+');

72: l_active_claim_flag ar_payment_schedules.active_claim_flag%TYPE;
73:
74: BEGIN
75: IF PG_DEBUG in ('Y', 'C') THEN
76: arp_standard.debug('ARP_DEDUCTION_COVER.update_amount_in_dispute()+');
77: END IF;
78:
79: -- Standard Start of API savepoint
80: SAVEPOINT Update_amount_In_Dispute;

Line 90: arp_standard.debug('update_amount_in_dispute: ' || ' p_customer_trx_id :' || p_customer_trx_id);

86: -- Initialize API return status to success
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88:
89: IF PG_DEBUG in ('Y', 'C') THEN
90: arp_standard.debug('update_amount_in_dispute: ' || ' p_customer_trx_id :' || p_customer_trx_id);
91: arp_standard.debug('update_amount_in_dispute: ' || ' p_claim_number :' || p_claim_number);
92: arp_standard.debug('update_amount_in_dispute: ' || ' p_amount :' || p_amount);
93: END IF;
94: /*---------------------------------------------------------------------+

Line 91: arp_standard.debug('update_amount_in_dispute: ' || ' p_claim_number :' || p_claim_number);

87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88:
89: IF PG_DEBUG in ('Y', 'C') THEN
90: arp_standard.debug('update_amount_in_dispute: ' || ' p_customer_trx_id :' || p_customer_trx_id);
91: arp_standard.debug('update_amount_in_dispute: ' || ' p_claim_number :' || p_claim_number);
92: arp_standard.debug('update_amount_in_dispute: ' || ' p_amount :' || p_amount);
93: END IF;
94: /*---------------------------------------------------------------------+
95: | 1) Retrieve the invoice payment schedule id from the application |

Line 92: arp_standard.debug('update_amount_in_dispute: ' || ' p_amount :' || p_amount);

88:
89: IF PG_DEBUG in ('Y', 'C') THEN
90: arp_standard.debug('update_amount_in_dispute: ' || ' p_customer_trx_id :' || p_customer_trx_id);
91: arp_standard.debug('update_amount_in_dispute: ' || ' p_claim_number :' || p_claim_number);
92: arp_standard.debug('update_amount_in_dispute: ' || ' p_amount :' || p_amount);
93: END IF;
94: /*---------------------------------------------------------------------+
95: | 1) Retrieve the invoice payment schedule id from the application |
96: +---------------------------------------------------------------------*/

Line 145: arp_standard.debug('update_amount_in_dispute: ' || 'New amount in dispute = '||l_ps_rec.amount_in_dispute);

141: l_ps_rec.dispute_date := SYSDATE;
142: l_ps_rec.active_claim_flag := l_active_claim_flag;
143:
144: IF PG_DEBUG in ('Y', 'C') THEN
145: arp_standard.debug('update_amount_in_dispute: ' || 'New amount in dispute = '||l_ps_rec.amount_in_dispute);
146: arp_standard.debug('update_amount_in_dispute: ' || 'New dispute date = '||l_ps_rec.dispute_date);
147: END IF;
148:
149: arp_ps_pkg.update_p

Line 146: arp_standard.debug('update_amount_in_dispute: ' || 'New dispute date = '||l_ps_rec.dispute_date);

142: l_ps_rec.active_claim_flag := l_active_claim_flag;
143:
144: IF PG_DEBUG in ('Y', 'C') THEN
145: arp_standard.debug('update_amount_in_dispute: ' || 'New amount in dispute = '||l_ps_rec.amount_in_dispute);
146: arp_standard.debug('update_amount_in_dispute: ' || 'New dispute date = '||l_ps_rec.dispute_date);
147: END IF;
148:
149: arp_ps_pkg.update_p
150: (p_ps_rec => l_ps_rec,

Line 172: arp_standard.debug('ARP_DEDUCTION_COVER.update_amount_in_dispute()-');

168: x_note_id => l_note_id);
169: END IF;
170:
171: IF PG_DEBUG in ('Y', 'C') THEN
172: arp_standard.debug('ARP_DEDUCTION_COVER.update_amount_in_dispute()-');
173: END IF;
174:
175: EXCEPTION
176: WHEN FND_API.G_EXC_ERROR THEN

Line 185: arp_standard.debug('update_amount_in_dispute: ' || 'Unexpected error '||sqlerrm||

181: p_count => x_msg_count,
182: p_data => x_msg_data);
183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
184: IF PG_DEBUG in ('Y', 'C') THEN
185: arp_standard.debug('update_amount_in_dispute: ' || 'Unexpected error '||sqlerrm||
186: ' at arp_deduction_cover.update_amount_in_dispute()+');
187: END IF;
188: ROLLBACK TO Update_Amount_In_Dispute;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 339: arp_standard.debug('ARP_DEDUCTION_COVER.create_receipt_writeoff()+');

335:
336: BEGIN
337:
338: IF PG_DEBUG in ('Y', 'C') THEN
339: arp_standard.debug('ARP_DEDUCTION_COVER.create_receipt_writeoff()+');
340: END IF;
341:
342: -- Standard Start of API savepoint
343: SAVEPOINT Create_Receipt_Writeoff;

Line 354: arp_standard.init_standard;

350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352: /* Bug 3022077 - initialize global variables */
353: arp_global.init_global;
354: arp_standard.init_standard;
355:
356: /*---------------------------------------------------------------------+
357: | 1) Check that a valid writeoff activity has been passed |
358: +---------------------------------------------------------------------*/

Line 523: arp_standard.debug('create_receipt_writeoff: ' || 'Before Inserting Claim Application (+)');

519: +---------------------------------------------------------------------*/
520: IF l_balance <> 0
521: THEN
522: IF PG_DEBUG in ('Y', 'C') THEN
523: arp_standard.debug('create_receipt_writeoff: ' || 'Before Inserting Claim Application (+)');
524: END IF;
525: l_new_claim_id := p_new_claim_id;
526: /* Bug 2821139 - under no circumstances should AR update claims when
527: they are settled from TM */

Line 562: arp_standard.debug('create_receipt_writeoff: ' || 'After Inserting Claim Application (-)');

558: THEN
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END IF;
561: IF PG_DEBUG in ('Y', 'C') THEN
562: arp_standard.debug('create_receipt_writeoff: ' || 'After Inserting Claim Application (-)');
563: END IF;
564: END IF;
565:
566: /*---------------------------------------------------------------------+

Line 605: arp_standard.debug('ARP_DEDUCTION_COVER.create_receipt_writeoff()-');

601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:
604: IF PG_DEBUG in ('Y', 'C') THEN
605: arp_standard.debug('ARP_DEDUCTION_COVER.create_receipt_writeoff()-');
606: END IF;
607:
608: EXCEPTION
609: WHEN FND_API.G_EXC_ERROR THEN

Line 618: arp_standard.debug('create_receipt_writeoff: ' || 'Unexpected error '||sqlerrm||

614: p_count => x_msg_count,
615: p_data => x_msg_data);
616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
617: IF PG_DEBUG in ('Y', 'C') THEN
618: arp_standard.debug('create_receipt_writeoff: ' || 'Unexpected error '||sqlerrm||
619: ' at arp_deduction_cover.create_receipt_writeoff()+');
620: END IF;
621: ROLLBACK TO Create_Receipt_Writeoff;
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 795: arp_standard.debug('ARP_DEDUCTION_COVER.split_claim_reapplication()+');

791:
792: BEGIN
793:
794: IF PG_DEBUG in ('Y', 'C') THEN
795: arp_standard.debug('ARP_DEDUCTION_COVER.split_claim_reapplication()+');
796: END IF;
797:
798: -- Standard Start of API savepoint
799: SAVEPOINT split_claim_reapplication;

Line 810: arp_standard.init_standard;

806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807:
808: /* Bug 3022077 - initialize global variables */
809: arp_global.init_global;
810: arp_standard.init_standard;
811:
812: /*---------------------------------------------------------------------+
813: | 1) Check that a valid receipt has been passed |
814: +---------------------------------------------------------------------*/

Line 882: arp_standard.debug('p_cash_receipt_id: ' || p_cash_receipt_id);

878: l_error_count := l_error_count + 1;
879: END IF;
880:
881: IF PG_DEBUG in ('Y', 'C') THEN
882: arp_standard.debug('p_cash_receipt_id: ' || p_cash_receipt_id);
883: arp_standard.debug('p_customer_trx_id: ' || p_customer_trx_id);
884: arp_standard.debug('p_claim_id: ' || p_claim_id);
885: END IF;
886:

Line 883: arp_standard.debug('p_customer_trx_id: ' || p_customer_trx_id);

879: END IF;
880:
881: IF PG_DEBUG in ('Y', 'C') THEN
882: arp_standard.debug('p_cash_receipt_id: ' || p_cash_receipt_id);
883: arp_standard.debug('p_customer_trx_id: ' || p_customer_trx_id);
884: arp_standard.debug('p_claim_id: ' || p_claim_id);
885: END IF;
886:
887: OPEN applied_amount( p_cash_receipt_id, p_customer_trx_id, p_claim_id );

Line 884: arp_standard.debug('p_claim_id: ' || p_claim_id);

880:
881: IF PG_DEBUG in ('Y', 'C') THEN
882: arp_standard.debug('p_cash_receipt_id: ' || p_cash_receipt_id);
883: arp_standard.debug('p_customer_trx_id: ' || p_customer_trx_id);
884: arp_standard.debug('p_claim_id: ' || p_claim_id);
885: END IF;
886:
887: OPEN applied_amount( p_cash_receipt_id, p_customer_trx_id, p_claim_id );
888: FETCH applied_amount INTO l_amount, l_discount_earned, l_discount_unearned;

Line 896: arp_standard.debug('l_applied_amount_from: ' || l_applied_amount_from);

892: l_applied_amt_from_old:= arpcurr.currround(l_amount * nvl(l_trans_to_receipt_rate,1),l_currency_code) ; /* Bug fix 5291088 */
893: l_discount := nvl(l_discount_earned,0) + nvl(l_discount_unearned,0); -- Bug 2535663
894:
895: IF PG_DEBUG in ('Y', 'C') THEN
896: arp_standard.debug('l_applied_amount_from: ' || l_applied_amount_from);
897: arp_standard.debug('l_applied_amt_from_old: ' || l_applied_amt_from_old);
898: arp_standard.debug('l_discount_earned: ' || l_discount_earned);
899: arp_standard.debug('l_discount_unearned: ' || l_discount_unearned);
900: END IF;

Line 897: arp_standard.debug('l_applied_amt_from_old: ' || l_applied_amt_from_old);

893: l_discount := nvl(l_discount_earned,0) + nvl(l_discount_unearned,0); -- Bug 2535663
894:
895: IF PG_DEBUG in ('Y', 'C') THEN
896: arp_standard.debug('l_applied_amount_from: ' || l_applied_amount_from);
897: arp_standard.debug('l_applied_amt_from_old: ' || l_applied_amt_from_old);
898: arp_standard.debug('l_discount_earned: ' || l_discount_earned);
899: arp_standard.debug('l_discount_unearned: ' || l_discount_unearned);
900: END IF;
901: -- Bug 3809272

Line 898: arp_standard.debug('l_discount_earned: ' || l_discount_earned);

894:
895: IF PG_DEBUG in ('Y', 'C') THEN
896: arp_standard.debug('l_applied_amount_from: ' || l_applied_amount_from);
897: arp_standard.debug('l_applied_amt_from_old: ' || l_applied_amt_from_old);
898: arp_standard.debug('l_discount_earned: ' || l_discount_earned);
899: arp_standard.debug('l_discount_unearned: ' || l_discount_unearned);
900: END IF;
901: -- Bug 3809272
902: /*---------------------------------------------------------------------+

Line 899: arp_standard.debug('l_discount_unearned: ' || l_discount_unearned);

895: IF PG_DEBUG in ('Y', 'C') THEN
896: arp_standard.debug('l_applied_amount_from: ' || l_applied_amount_from);
897: arp_standard.debug('l_applied_amt_from_old: ' || l_applied_amt_from_old);
898: arp_standard.debug('l_discount_earned: ' || l_discount_earned);
899: arp_standard.debug('l_discount_unearned: ' || l_discount_unearned);
900: END IF;
901: -- Bug 3809272
902: /*---------------------------------------------------------------------+
903: | 2b) Check that the receipt will not go negative

Line 1008: arp_standard.debug('split_claim_reapplication: ' || 'Before Inserting Claim Application (+)');

1004: /*---------------------------------------------------------------------+
1005: | 5) Apply new amount using original claim |
1006: +---------------------------------------------------------------------*/
1007: IF PG_DEBUG in ('Y', 'C') THEN
1008: arp_standard.debug('split_claim_reapplication: ' || 'Before Inserting Claim Application (+)');
1009: END IF;
1010: /* Bug 2279399 - do not apply if amount is zero */
1011: IF p_amount <> 0
1012: THEN

Line 1078: arp_standard.debug('split_claim_reapplication: ' || 'ERROR occured updating payment schedule: '||sqlerrm);

1074: WHERE payment_schedule_id = l_applied_ps_id;
1075: EXCEPTION
1076: WHEN others then
1077: IF PG_DEBUG in ('Y', 'C') THEN
1078: arp_standard.debug('split_claim_reapplication: ' || 'ERROR occured updating payment schedule: '||sqlerrm);
1079: END IF;
1080:
1081: l_return_status := 'U';
1082: END;

Line 1094: arp_standard.debug('split_claim_reapplication: ' || 'After Inserting Claim Application (-)');

1090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1091: END IF;
1092: END IF;
1093: IF PG_DEBUG in ('Y', 'C') THEN
1094: arp_standard.debug('split_claim_reapplication: ' || 'After Inserting Claim Application (-)');
1095: arp_standard.debug('ARP_DEDUCTION_COVER.split_claim_reapplication()-');
1096: END IF;
1097:
1098: EXCEPTION

Line 1095: arp_standard.debug('ARP_DEDUCTION_COVER.split_claim_reapplication()-');

1091: END IF;
1092: END IF;
1093: IF PG_DEBUG in ('Y', 'C') THEN
1094: arp_standard.debug('split_claim_reapplication: ' || 'After Inserting Claim Application (-)');
1095: arp_standard.debug('ARP_DEDUCTION_COVER.split_claim_reapplication()-');
1096: END IF;
1097:
1098: EXCEPTION
1099: WHEN FND_API.G_EXC_ERROR THEN

Line 1108: arp_standard.debug('split_claim_reapplication: ' || 'Unexpected error '||sqlerrm||

1104: p_count => x_msg_count,
1105: p_data => x_msg_data);
1106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1107: IF PG_DEBUG in ('Y', 'C') THEN
1108: arp_standard.debug('split_claim_reapplication: ' || 'Unexpected error '||sqlerrm||
1109: ' at arp_deduction_cover.split_claim_reapplication()+');
1110: END IF;
1111: ROLLBACK TO split_claim_reapplication;
1112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1190: arp_standard.debug('ARP_DEDUCTION_COVER.receipt_valid()+');

1186: RETURN BOOLEAN
1187: IS
1188: BEGIN
1189: IF PG_DEBUG in ('Y', 'C') THEN
1190: arp_standard.debug('ARP_DEDUCTION_COVER.receipt_valid()+');
1191: END IF;
1192:
1193: x_receipt_number := NULL;
1194: x_receipt_date := NULL;

Line 1227: arp_standard.debug('ARP_DEDUCTION_COVER.receipt_valid()-');

1223: AND cr.cash_receipt_id = p_cash_receipt_id;
1224: END IF;
1225: RETURN TRUE;
1226: IF PG_DEBUG in ('Y', 'C') THEN
1227: arp_standard.debug('ARP_DEDUCTION_COVER.receipt_valid()-');
1228: END IF;
1229:
1230: EXCEPTION
1231: WHEN OTHERS

Line 1309: arp_standard.debug('ARP_DEDUCTION_COVER.claim_on_receipt()+');

1305:
1306: BEGIN
1307:
1308: IF PG_DEBUG in ('Y', 'C') THEN
1309: arp_standard.debug('ARP_DEDUCTION_COVER.claim_on_receipt()+');
1310: END IF;
1311:
1312: IF (p_claim_id IS NULL)
1313: THEN

Line 1548: arp_standard.debug('ARP_DEDUCTION_COVER.claim_on_receipt()-');

1544: FND_MSG_PUB.Add;
1545: RETURN FALSE;
1546: END IF;
1547: IF PG_DEBUG in ('Y', 'C') THEN
1548: arp_standard.debug('ARP_DEDUCTION_COVER.claim_on_receipt()-');
1549: END IF;
1550:
1551: EXCEPTION
1552: WHEN OTHERS

Line 1601: arp_standard.debug('ARP_DEDUCTION_COVER.claim_valid()+');

1597: l_query VARCHAR2(2000);
1598: l_api_name CONSTANT VARCHAR2(30) := 'claim_valid';
1599: BEGIN
1600: IF PG_DEBUG in ('Y', 'C') THEN
1601: arp_standard.debug('ARP_DEDUCTION_COVER.claim_valid()+');
1602: END IF;
1603: --
1604: -- The sql to check for the existence of the claim in iClaim is dynamic
1605: -- to avoid package compilation problems if iClaim is not installed

Line 1637: arp_standard.debug('ARP_DEDUCTION_COVER.claim_valid()-');

1633: FND_MSG_PUB.Add;
1634: RETURN FALSE;
1635: END IF;
1636: IF PG_DEBUG in ('Y', 'C') THEN
1637: arp_standard.debug('ARP_DEDUCTION_COVER.claim_valid()-');
1638: END IF;
1639: EXCEPTION
1640: WHEN OTHERS THEN
1641: IF (SQLCODE = -20001)

Line 1644: arp_standard.debug('claim_valid: ' || '20001 error '||

1640: WHEN OTHERS THEN
1641: IF (SQLCODE = -20001)
1642: THEN
1643: IF PG_DEBUG in ('Y', 'C') THEN
1644: arp_standard.debug('claim_valid: ' || '20001 error '||
1645: ' at arp_deduction_cover.claim_valid()+');
1646: END IF;
1647: ELSE
1648: IF PG_DEBUG in ('Y', 'C') THEN

Line 1649: arp_standard.debug('claim_valid: ' || 'Unexpected error '||sqlerrm||

1645: ' at arp_deduction_cover.claim_valid()+');
1646: END IF;
1647: ELSE
1648: IF PG_DEBUG in ('Y', 'C') THEN
1649: arp_standard.debug('claim_valid: ' || 'Unexpected error '||sqlerrm||
1650: ' at arp_deduction_cover.claim_valid()+');
1651: END IF;
1652: IF FND_MSG_PUB.Check_Msg_Level
1653: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1693: arp_standard.debug('ARP_DEDUCTION_COVER.negative_rct_writeoffs_allowed()+');

1689: RETURN BOOLEAN
1690: IS
1691: BEGIN
1692: IF PG_DEBUG in ('Y', 'C') THEN
1693: arp_standard.debug('ARP_DEDUCTION_COVER.negative_rct_writeoffs_allowed()+');
1694: END IF;
1695: RETURN TRUE;
1696: END ;
1697:

Line 1737: arp_standard.debug('ARP_DEDUCTION_COVER.validate_amount_applied()+');

1733:
1734: BEGIN
1735:
1736: IF PG_DEBUG in ('Y', 'C') THEN
1737: arp_standard.debug('ARP_DEDUCTION_COVER.validate_amount_applied()+');
1738: END IF;
1739:
1740: x_return_status := FND_API.G_RET_STS_SUCCESS;
1741:

Line 1753: arp_standard.debug('p_cash_receipt_id = '||p_cash_receipt_id);

1749: l_new_unapplied_total := (l_unapplied_total + p_amount_applied - p_new_amount_applied);
1750:
1751: /* Bug fix 5291088 : Added additional debug messages */
1752: IF PG_DEBUG in ('Y', 'C') THEN
1753: arp_standard.debug('p_cash_receipt_id = '||p_cash_receipt_id);
1754: arp_standard.debug('p_amount_applied = '||p_amount_applied);
1755: arp_standard.debug('p_new_amount_applied = '||p_new_amount_applied);
1756: arp_standard.debug('l_unapplied_total = '||l_unapplied_total);
1757: arp_standard.debug('l_new_unapplied_total = '||l_new_unapplied_total);

Line 1754: arp_standard.debug('p_amount_applied = '||p_amount_applied);

1750:
1751: /* Bug fix 5291088 : Added additional debug messages */
1752: IF PG_DEBUG in ('Y', 'C') THEN
1753: arp_standard.debug('p_cash_receipt_id = '||p_cash_receipt_id);
1754: arp_standard.debug('p_amount_applied = '||p_amount_applied);
1755: arp_standard.debug('p_new_amount_applied = '||p_new_amount_applied);
1756: arp_standard.debug('l_unapplied_total = '||l_unapplied_total);
1757: arp_standard.debug('l_new_unapplied_total = '||l_new_unapplied_total);
1758: END IF;

Line 1755: arp_standard.debug('p_new_amount_applied = '||p_new_amount_applied);

1751: /* Bug fix 5291088 : Added additional debug messages */
1752: IF PG_DEBUG in ('Y', 'C') THEN
1753: arp_standard.debug('p_cash_receipt_id = '||p_cash_receipt_id);
1754: arp_standard.debug('p_amount_applied = '||p_amount_applied);
1755: arp_standard.debug('p_new_amount_applied = '||p_new_amount_applied);
1756: arp_standard.debug('l_unapplied_total = '||l_unapplied_total);
1757: arp_standard.debug('l_new_unapplied_total = '||l_new_unapplied_total);
1758: END IF;
1759:

Line 1756: arp_standard.debug('l_unapplied_total = '||l_unapplied_total);

1752: IF PG_DEBUG in ('Y', 'C') THEN
1753: arp_standard.debug('p_cash_receipt_id = '||p_cash_receipt_id);
1754: arp_standard.debug('p_amount_applied = '||p_amount_applied);
1755: arp_standard.debug('p_new_amount_applied = '||p_new_amount_applied);
1756: arp_standard.debug('l_unapplied_total = '||l_unapplied_total);
1757: arp_standard.debug('l_new_unapplied_total = '||l_new_unapplied_total);
1758: END IF;
1759:
1760: IF l_new_unapplied_total < 0 THEN

Line 1757: arp_standard.debug('l_new_unapplied_total = '||l_new_unapplied_total);

1753: arp_standard.debug('p_cash_receipt_id = '||p_cash_receipt_id);
1754: arp_standard.debug('p_amount_applied = '||p_amount_applied);
1755: arp_standard.debug('p_new_amount_applied = '||p_new_amount_applied);
1756: arp_standard.debug('l_unapplied_total = '||l_unapplied_total);
1757: arp_standard.debug('l_new_unapplied_total = '||l_new_unapplied_total);
1758: END IF;
1759:
1760: IF l_new_unapplied_total < 0 THEN
1761: FND_MESSAGE.set_name('AR','AR_RW_CLAIM_SETTLMT_NEG_RCT');

Line 1767: arp_standard.debug('ARP_DEDUCTION_COVER.validate_amount_applied()-');

1763: x_return_status := FND_API.G_RET_STS_ERROR;
1764: END IF;
1765:
1766: IF PG_DEBUG in ('Y', 'C') THEN
1767: arp_standard.debug('ARP_DEDUCTION_COVER.validate_amount_applied()-');
1768: END IF;
1769:
1770: EXCEPTION WHEN OTHERS THEN
1771: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');