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_ADJVALIDATE_PVT dependencies on FND_MSG_PUB

Line 5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;

1: PACKAGE BODY AR_ADJVALIDATE_PVT AS
2: /* $Header: ARXVADJB.pls 120.13.12010000.2 2008/11/13 10:14:42 dgaurab ship $*/
3: G_PKG_NAME CONSTANT VARCHAR2(30) :='AR_ADJVALIDATE_PVT';
4:
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
8: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
9: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

Line 6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;

2: /* $Header: ARXVADJB.pls 120.13.12010000.2 2008/11/13 10:14:42 dgaurab ship $*/
3: G_PKG_NAME CONSTANT VARCHAR2(30) :='AR_ADJVALIDATE_PVT';
4:
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
8: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
9: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
10:

Line 7: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

3: G_PKG_NAME CONSTANT VARCHAR2(30) :='AR_ADJVALIDATE_PVT';
4:
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
8: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
9: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
10:
11: G_caching_done varchar2(1) := FND_API.G_FALSE;

Line 8: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;

4:
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
8: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
9: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
10:
11: G_caching_done varchar2(1) := FND_API.G_FALSE;
12: G_cache_date date := NULL ;

Line 9: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
8: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
9: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
10:
11: G_caching_done varchar2(1) := FND_API.G_FALSE;
12: G_cache_date date := NULL ;
13: G_receivables_name ar_receivables_trx.name%type := NULL;

Line 190: FND_MSG_PUB.Add_Exc_Msg (

186: IF PG_DEBUG in ('Y', 'C') THEN
187: arp_util.debug('EXCEPTION: Init_Context_Rec() ', G_MSG_UERROR);
188: END IF;
189:
190: FND_MSG_PUB.Add_Exc_Msg (
191: G_PKG_NAME,
192: 'Init_Context_Rec'
193: );
194:

Line 266: FND_MSG_PUB.ADD ;

262: | Set the message |
263: +-----------------------------------------------*/
264: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_OPEN_FUTURE_PERIOD');
265: FND_MESSAGE.SET_TOKEN ( 'SET_OF_BOOKS_ID', to_char(arp_global.set_of_books_id)) ;
266: FND_MSG_PUB.ADD ;
267:
268: p_return_status := FND_API.G_RET_STS_ERROR;
269:
270: WHEN OTHERS THEN

Line 277: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Gl_Periods');

273: END IF;
274: /*-----------------------------------------------+
275: | Set unexpected error message and status |
276: +-----------------------------------------------*/
277: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Gl_Periods');
278: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
279: END;
280:
281: l_index := 0 ;

Line 308: FND_MSG_PUB.ADD ;

304: | Set the message |
305: +-----------------------------------------------*/
306: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_OPEN_FUTURE_PERIOD');
307: FND_MESSAGE.SET_TOKEN ( 'SET_OF_BOOKS_ID', to_char(arp_global.set_of_books_id)) ;
308: FND_MSG_PUB.ADD ;
309:
310: p_return_status := FND_API.G_RET_STS_ERROR;
311: WHEN OTHERS THEN
312: IF PG_DEBUG in ('Y', 'C') THEN

Line 318: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Gl_Periods');

314: END IF;
315: /*-----------------------------------------------+
316: | Set unexpected error message and status |
317: +-----------------------------------------------*/
318: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Gl_Periods');
319: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
320: RETURN;
321:
322: END Cache_Gl_Periods;

Line 384: FND_MSG_PUB.ADD ;

380: | Set the message |
381: +-----------------------------------------------*/
382:
383: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_APPROVAL_CODES');
384: FND_MSG_PUB.ADD ;
385:
386: p_return_status := FND_API.G_RET_STS_ERROR ;
387:
388: WHEN OTHERS THEN

Line 395: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Approval_Type');

391: END IF;
392: /*-----------------------------------------------+
393: | Set unexpected error message and status |
394: +-----------------------------------------------*/
395: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Approval_Type');
396: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
397: RETURN;
398:
399: END Cache_Approval_Type;

Line 459: FND_MSG_PUB.ADD ;

455: /*-----------------------------------------------+
456: | Set the message |
457: +-----------------------------------------------*/
458: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_TYPE_CODES');
459: FND_MSG_PUB.ADD ;
460:
461: p_return_status := FND_API.G_RET_STS_ERROR ;
462:
463: WHEN OTHERS THEN

Line 470: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Adjustment_Type');

466: END IF;
467: /*-----------------------------------------------+
468: | Set unexpected error message and status |
469: +-----------------------------------------------*/
470: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Adjustment_Type');
471: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
472: RETURN;
473:
474: END Cache_Adjustment_Type;

Line 534: FND_MSG_PUB.ADD ;

530: /*-----------------------------------------------+
531: | Set the message |
532: +-----------------------------------------------*/
533: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_REASON_CODES');
534: FND_MSG_PUB.ADD ;
535:
536: p_return_status := FND_API.G_RET_STS_ERROR ;
537:
538: WHEN OTHERS THEN

Line 545: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Adjustment_Reason');

541: END IF;
542: /*-----------------------------------------------+
543: | Set unexpected error message and status |
544: +-----------------------------------------------*/
545: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Adjustment_Reason');
546: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
547: RETURN;
548:
549: END Cache_Adjustment_Reason;

Line 633: FND_MSG_PUB.ADD ;

629: | Set the message |
630: +-----------------------------------------------*/
631:
632: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_RECEIVABLES_TRX');
633: FND_MSG_PUB.ADD ;
634:
635: p_return_status := FND_API.G_RET_STS_ERROR ;
636:
637: WHEN OTHERS THEN

Line 644: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Receivables_Trx');

640: END IF;
641: /*-----------------------------------------------+
642: | Set unexpected error message and status |
643: +-----------------------------------------------*/
644: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Receivables_Trx');
645: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
646: RETURN;
647:
648: END Cache_Receivables_Trx;

Line 727: FND_MSG_PUB.ADD ;

723: | Set the message |
724: +-----------------------------------------------*/
725:
726: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_USSGL_CODES');
727: FND_MSG_PUB.ADD ;
728:
729: p_return_status := FND_API.G_RET_STS_SUCCESS ;
730:
731: WHEN OTHERS THEN

Line 738: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Ussgl_Code');

734: END IF;
735: /*-----------------------------------------------+
736: | Set unexpected error message and status |
737: +-----------------------------------------------*/
738: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Ussgl_Code');
739: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
740: RETURN;
741:
742: END Cache_Ussgl_code;

Line 823: FND_MSG_PUB.ADD ;

819: | Set the message |
820: +-----------------------------------------------*/
821:
822: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CCID');
823: FND_MSG_PUB.ADD ;
824:
825: p_return_status := FND_API.G_RET_STS_ERROR ;
826:
827: WHEN OTHERS THEN

Line 834: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Code_Combination');

830: END IF;
831: /*-----------------------------------------------+
832: | Set unexpected error message and status |
833: +-----------------------------------------------*/
834: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Code_Combination');
835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
836: RETURN;
837:
838: END Cache_Code_Combination;

Line 1070: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Details');

1066: IF PG_DEBUG in ('Y', 'C') THEN
1067: arp_util.debug('EXCEPTION: Cache_Details() ', G_MSG_UERROR);
1068: END IF;
1069:
1070: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Details');
1071: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1072: RETURN;
1073:
1074: END Cache_Details;

Line 1168: FND_MSG_PUB.ADD ;

1164: END IF;
1165:
1166: FND_MESSAGE.SET_NAME ('AR', 'AR_VAL_USER_LIMIT');
1167: FND_MESSAGE.SET_TOKEN ( 'CURRENCY', p_inv_curr_code ) ;
1168: FND_MSG_PUB.ADD ;
1169: p_approved_flag := FND_API.G_FALSE;
1170:
1171: WHEN OTHERS THEN
1172:

Line 1180: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Within_approval_limits');

1176:
1177: /*-------------------------------------------------+
1178: | Set unexpected error message, status and return |
1179: +-------------------------------------------------*/
1180: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Within_approval_limits');
1181: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1182: END;
1183:
1184: /*-----------------------------------------------+

Line 1210: FND_MSG_PUB.ADD ;

1206: | Add a message. But do not signal error|
1207: +--------------------------------------*/
1208:
1209: FND_MESSAGE.SET_NAME ('AR', 'AR_VAL_AMT_APPROVAL_LIMIT');
1210: FND_MSG_PUB.ADD ;
1211:
1212: p_approved_flag := FND_API.G_FALSE;
1213:
1214: END IF;

Line 1232: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Within_approval_limits'

1228: END IF;
1229: /*-----------------------------------------------+
1230: | Set unexpected error message and status |
1231: +-----------------------------------------------*/
1232: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Within_approval_limits'
1233: );
1234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1235: RETURN;
1236:

Line 1303: FND_MSG_PUB.ADD;

1299: AND p_ps_rec.amount_line_items_remaining <> 0)
1300: THEN
1301: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_INC_BUCKET');
1302: FND_MESSAGE.SET_TOKEN('BUCKET','LINE');
1303: FND_MSG_PUB.ADD;
1304:
1305: p_return_status := FND_API.G_RET_STS_ERROR;
1306: ELSIF (p_adj_rec.line_adjusted + p_ps_rec.amount_line_items_remaining <> 0)
1307: THEN

Line 1310: FND_MSG_PUB.ADD;

1306: ELSIF (p_adj_rec.line_adjusted + p_ps_rec.amount_line_items_remaining <> 0)
1307: THEN
1308: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_ADJ_BUCKETS');
1309: FND_MESSAGE.SET_TOKEN('BUCKET','LINE');
1310: FND_MSG_PUB.ADD;
1311:
1312: p_return_status := FND_API.G_RET_STS_ERROR;
1313: END IF;
1314:

Line 1322: FND_MSG_PUB.ADD;

1318: AND p_ps_rec.tax_remaining <> 0)
1319: THEN
1320: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_INC_BUCKET');
1321: FND_MESSAGE.SET_TOKEN('BUCKET','TAX');
1322: FND_MSG_PUB.ADD;
1323:
1324: p_return_status := FND_API.G_RET_STS_ERROR;
1325: ELSIF (p_adj_rec.tax_adjusted + p_ps_rec.tax_remaining <> 0)
1326: THEN

Line 1329: FND_MSG_PUB.ADD;

1325: ELSIF (p_adj_rec.tax_adjusted + p_ps_rec.tax_remaining <> 0)
1326: THEN
1327: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_ADJ_BUCKETS');
1328: FND_MESSAGE.SET_TOKEN('BUCKET','TAX');
1329: FND_MSG_PUB.ADD;
1330:
1331: p_return_status := FND_API.G_RET_STS_ERROR;
1332: END IF;
1333:

Line 1341: FND_MSG_PUB.ADD;

1337: AND p_ps_rec.freight_remaining <> 0)
1338: THEN
1339: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_INC_BUCKET');
1340: FND_MESSAGE.SET_TOKEN('BUCKET','FREIGHT');
1341: FND_MSG_PUB.ADD;
1342:
1343: p_return_status := FND_API.G_RET_STS_ERROR;
1344: ELSIF (p_adj_rec.freight_adjusted + p_ps_rec.freight_remaining <> 0)
1345: THEN

Line 1348: FND_MSG_PUB.ADD;

1344: ELSIF (p_adj_rec.freight_adjusted + p_ps_rec.freight_remaining <> 0)
1345: THEN
1346: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_ADJ_BUCKETS');
1347: FND_MESSAGE.SET_TOKEN('BUCKET','FREIGHT');
1348: FND_MSG_PUB.ADD;
1349:
1350: p_return_status := FND_API.G_RET_STS_ERROR;
1351: END IF;
1352:

Line 1360: FND_MSG_PUB.ADD;

1356: AND p_ps_rec.receivables_charges_remaining <> 0)
1357: THEN
1358: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_INC_BUCKET');
1359: FND_MESSAGE.SET_TOKEN('BUCKET','CHARGES');
1360: FND_MSG_PUB.ADD;
1361:
1362: p_return_status := FND_API.G_RET_STS_ERROR;
1363: ELSIF (p_adj_rec.receivables_charges_adjusted + p_ps_rec.receivables_charges_remaining <> 0)
1364: THEN

Line 1367: FND_MSG_PUB.ADD;

1363: ELSIF (p_adj_rec.receivables_charges_adjusted + p_ps_rec.receivables_charges_remaining <> 0)
1364: THEN
1365: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_ADJ_BUCKETS');
1366: FND_MESSAGE.SET_TOKEN('BUCKET','CHARGES');
1367: FND_MSG_PUB.ADD;
1368:
1369: p_return_status := FND_API.G_RET_STS_ERROR;
1370: END IF;
1371: END IF;

Line 1388: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_buckets'

1384: END IF;
1385: /*-----------------------------------------------+
1386: | Set unexpected error message and status |
1387: +-----------------------------------------------*/
1388: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_buckets'
1389: );
1390: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1391: RETURN;
1392:

Line 1469: FND_MSG_PUB.ADD ;

1465: +-----------------------------------------------*/
1466:
1467: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_ADJUSTMENT_TYPE');
1468: FND_MESSAGE.SET_TOKEN ( 'TYPE', p_adj_rec.type ) ;
1469: FND_MSG_PUB.ADD ;
1470:
1471: END IF;
1472:
1473: IF PG_DEBUG in ('Y', 'C') THEN

Line 1489: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Type' );

1485:
1486: /*-----------------------------------------------+
1487: | Set unexpected error message and status |
1488: +-----------------------------------------------*/
1489: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Type' );
1490:
1491: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1492:
1493: RETURN;

Line 1586: FND_MSG_PUB.ADD ;

1582: +-----------------------------------------------*/
1583:
1584: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_PAYSCHD');
1585: FND_MESSAGE.SET_TOKEN ( 'PAYMENT_SCHEDULE_ID', to_char(p_adj_rec.payment_schedule_id)) ;
1586: FND_MSG_PUB.ADD ;
1587:
1588: p_return_status := FND_API.G_RET_STS_ERROR;
1589:
1590: IF PG_DEBUG in ('Y', 'C') THEN

Line 1618: FND_MSG_PUB.ADD ;

1614: +-----------------------------------------------*/
1615:
1616: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_PAYSCHD');
1617: FND_MESSAGE.SET_TOKEN('PAYMENT_SCHEDULE_ID',to_char(p_adj_rec.payment_schedule_id)) ;
1618: FND_MSG_PUB.ADD ;
1619: p_return_status := FND_API.G_RET_STS_ERROR;
1620: IF PG_DEBUG in ('Y', 'C') THEN
1621: arp_util.debug('Validate_Payschd: ' || 'payment schedule id is invalid');
1622: END IF;

Line 1637: FND_MSG_PUB.ADD ;

1633: THEN
1634:
1635: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_TRX_CLASS');
1636: FND_MESSAGE.SET_TOKEN ( 'CLASS', p_ps_rec.class ) ;
1637: FND_MSG_PUB.ADD ;
1638:
1639: p_return_status := FND_API.G_RET_STS_ERROR;
1640: IF PG_DEBUG in ('Y', 'C') THEN
1641: arp_util.debug('Validate_Payschd: ' || 'class of transaction is invalid');

Line 1659: FND_MSG_PUB.ADD ;

1655: +-----------------------------------------------*/
1656:
1657: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CUSTOMER_TRX_ID');
1658: FND_MESSAGE.SET_TOKEN('PAYMENT_SCHEDULE_ID',to_char(p_adj_rec.payment_schedule_id));
1659: FND_MSG_PUB.ADD ;
1660: p_return_status := FND_API.G_RET_STS_ERROR;
1661: IF PG_DEBUG in ('Y', 'C') THEN
1662: arp_util.debug('Validate_Payschd: ' || 'there is no valid customer trx id for the paysch id');
1663: END IF;

Line 1681: FND_MSG_PUB.ADD ;

1677: +-----------------------------------------------*/
1678:
1679: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CUSTOMER_ID');
1680: FND_MESSAGE.SET_TOKEN('PAYMENT_SCHEDULE_ID',to_char(p_adj_rec.payment_schedule_id));
1681: FND_MSG_PUB.ADD ;
1682:
1683: p_return_status := FND_API.G_RET_STS_ERROR;
1684: IF PG_DEBUG in ('Y', 'C') THEN
1685: arp_util.debug('Validate_Payschd: ' || 'there is no valid customer id for the paysch id');

Line 1726: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Payschd');

1722: /*-----------------------------------------------+
1723: | Set unexpected error message and status |
1724: +-----------------------------------------------*/
1725: IF p_from_llca_call <> 'Y' THEN
1726: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Payschd');
1727: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1728: RETURN;
1729: ELSE
1730: insert into ar_llca_adj_trx_errors_gt

Line 1759: FND_MSG_PUB.ADD ;

1755: IF p_from_llca_call <> 'Y' THEN
1756: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CUSTOMER_TRX_LINEID');
1757: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_LINE_ID',to_char(p_adj_rec.customer_trx_line_id) ) ;
1758: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_ID',to_char(p_adj_rec.customer_trx_id));
1759: FND_MSG_PUB.ADD ;
1760:
1761: p_return_status := FND_API.G_RET_STS_ERROR;
1762: IF PG_DEBUG in ('Y', 'C') THEN
1763: arp_util.debug('Validate_Payschd: ' || 'customer trx line id is invalid');

Line 1803: FND_MSG_PUB.ADD ;

1799: -- customer_trx_line_id is null |
1800: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CUSTOMER_TRX_LINEID');
1801: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_LINE_ID',to_char(p_adj_rec.customer_trx_line_id) ) ;
1802: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_ID',to_char(p_adj_rec.customer_trx_id));
1803: FND_MSG_PUB.ADD ;
1804:
1805: p_return_status := FND_API.G_RET_STS_ERROR;
1806:
1807: IF PG_DEBUG in ('Y', 'C') THEN

Line 1826: FND_MSG_PUB.ADD ;

1822:
1823: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_LINE_ID_FOR_NONLINE');
1824: FND_MESSAGE.SET_TOKEN ( 'CUSTOMER_TRX_LINE_ID', to_char(p_adj_rec.customer_trx_line_id) ) ;
1825: FND_MESSAGE.SET_TOKEN ( 'TYPE', p_ps_rec.class ) ;
1826: FND_MSG_PUB.ADD ;
1827:
1828: p_return_status := FND_API.G_RET_STS_ERROR;
1829: IF PG_DEBUG in ('Y', 'C') THEN
1830: arp_util.debug('Validate_Payschd: ' || 'customer trx line id is not required for adj type ');

Line 1855: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Validate_Payschd' );

1851: END IF;
1852: /*-----------------------------------------------+
1853: | Set unexpected error message and status |
1854: +-----------------------------------------------*/
1855: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Validate_Payschd' );
1856: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1857: RETURN;
1858:
1859: END Validate_Payschd;

Line 1973: FND_MSG_PUB.ADD ;

1969: IF ( p_ps_rec.amount_due_remaining = 0 )
1970: THEN
1971:
1972: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_ADR_ZERO_INV');
1973: FND_MSG_PUB.ADD ;
1974:
1975: p_return_status := FND_API.G_RET_STS_ERROR ;
1976: END IF;
1977: p_adj_rec.amount := - p_ps_rec.amount_due_remaining ;

Line 1991: FND_MSG_PUB.ADD ;

1987: IF ( p_adj_rec.amount + p_ps_rec.amount_due_remaining <> 0 )
1988: THEN
1989:
1990: FND_MESSAGE.SET_NAME ('AR', 'AR_TW_VAL_AMT_ADJ_INV');
1991: FND_MSG_PUB.ADD ;
1992:
1993: p_return_status := FND_API.G_RET_STS_ERROR;
1994: END IF;
1995: /*Bug 4258945*/

Line 2027: FND_MSG_PUB.ADD ;

2023: | Set the message and return |
2024: +--------------------------------------------*/
2025:
2026: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_ADJ_AMOUNT_ZERO');
2027: FND_MSG_PUB.ADD ;
2028:
2029: p_return_status := FND_API.G_RET_STS_ERROR;
2030: END IF;
2031:

Line 2087: FND_MSG_PUB.ADD ;

2083: THEN
2084:
2085: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_CREATE_STATUS');
2086: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_adj_rec.status ) ;
2087: FND_MSG_PUB.ADD ;
2088:
2089: p_return_status := FND_API.G_RET_STS_ERROR ;
2090: END IF;
2091:

Line 2120: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Amount');

2116:
2117: /*-----------------------------------------------+
2118: | Set unexpected error message and status |
2119: +-----------------------------------------------*/
2120: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Amount');
2121: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2122: RETURN;
2123:
2124: END Validate_Amount;

Line 2249: FND_MSG_PUB.ADD ;

2245:
2246: IF p_from_llca_call <> 'Y' THEN
2247: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_RCVABLE_TRX_ID');
2248: FND_MESSAGE.SET_TOKEN ( 'RECEIVABLES_TRX_ID', to_char(p_adj_rec.receivables_trx_id) ) ;
2249: FND_MSG_PUB.ADD ;
2250: p_return_status := FND_API.G_RET_STS_ERROR;
2251: ELSE
2252: insert into ar_llca_adj_trx_errors_gt
2253: (

Line 2296: FND_MSG_PUB.ADD ;

2292: IF p_from_llca_call <> 'Y' THEN
2293:
2294: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_RCVABLE_TRX_ID');
2295: FND_MESSAGE.SET_TOKEN ( 'RECEIVABLES_TRX_ID', to_char(p_adj_rec.receivables_trx_id) ) ;
2296: FND_MSG_PUB.ADD ;
2297: p_return_status := FND_API.G_RET_STS_ERROR;
2298:
2299: ELSE
2300: insert into ar_llca_adj_trx_errors_gt

Line 2354: FND_MSG_PUB.ADD ;

2350: THEN
2351: IF p_from_llca_call <> 'Y' THEN
2352: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CCID_FOR_ACTIVITY');
2353: FND_MESSAGE.SET_TOKEN ( 'RECEIVABLES_TRX_ID', to_char(p_adj_rec.receivables_trx_id) ) ;
2354: FND_MSG_PUB.ADD ;
2355: p_return_status := FND_API.G_RET_STS_ERROR;
2356: ELSE
2357: insert into ar_llca_adj_trx_errors_gt
2358: (

Line 2424: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Rcvtrxccid');

2420: WHEN OTHERS THEN
2421: /*---------------------------------------------+
2422: |Set unexpected error message and status |
2423: +---------------------------------------------*/
2424: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Rcvtrxccid');
2425: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2426: END ;
2427:
2428: IF ( l_count <> 1 )

Line 2436: FND_MSG_PUB.ADD ;

2432: +-------------------------------------------*/
2433: IF p_from_llca_call <> 'Y' THEN
2434: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_CCID');
2435: FND_MESSAGE.SET_TOKEN ( 'CCID', p_adj_rec.code_combination_id ) ;
2436: FND_MSG_PUB.ADD ;
2437: p_return_status := FND_API.G_RET_STS_ERROR;
2438: ELSE
2439: insert into ar_llca_adj_trx_errors_gt
2440: (

Line 2475: FND_MSG_PUB.ADD ;

2471: IF ( p_adj_rec.code_combination_id <> l_cc_id )
2472: THEN
2473: IF p_from_llca_call <> 'Y' THEN
2474: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_OVERRIDE_CCID_DISALLOW');
2475: FND_MSG_PUB.ADD ;
2476: p_return_status := FND_API.G_RET_STS_ERROR;
2477: ELSE
2478: insert into ar_llca_adj_trx_errors_gt
2479: (

Line 2520: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Rcvtrxccid');

2516: END IF;
2517: /*-----------------------------------------------+
2518: | Set unexpected error message and status |
2519: +-----------------------------------------------*/
2520: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Rcvtrxccid');
2521: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2522:
2523: RETURN;
2524:

Line 2585: FND_MSG_PUB.ADD ;

2581: IF ( p_apply_date IS NULL )
2582: THEN
2583:
2584: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_APPLY_DATE');
2585: FND_MSG_PUB.ADD ;
2586: p_return_status := FND_API.G_RET_STS_ERROR;
2587: END IF;
2588:
2589: IF ( p_gl_date IS NULL )

Line 2593: FND_MSG_PUB.ADD ;

2589: IF ( p_gl_date IS NULL )
2590: THEN
2591:
2592: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_GL_DATE');
2593: FND_MSG_PUB.ADD ;
2594: p_return_status := FND_API.G_RET_STS_ERROR;
2595: END IF;
2596:
2597: /*------------------------------------------+

Line 2663: FND_MSG_PUB.ADD ;

2659: IF ( NOT l_found_flag )
2660: THEN
2661: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_GLDATE_INVALID_PERIOD');
2662: FND_MESSAGE.SET_TOKEN ( 'GL_DATE', to_char(p_gl_date,'DD-MON-YYYY') ) ;
2663: FND_MSG_PUB.ADD ;
2664: p_return_status := FND_API.G_RET_STS_ERROR;
2665: END IF;
2666:
2667: /*---------------------------------------+

Line 2677: FND_MSG_PUB.ADD ;

2673: THEN
2674: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_APPLYDATE_LT_TRXDATE');
2675: FND_MESSAGE.SET_TOKEN ( 'APPLY_DATE', to_char(p_apply_date,'DD-MON-YYYY') ) ;
2676: FND_MESSAGE.SET_TOKEN ( 'TRX_DATE', to_char(p_ps_rec.trx_date,'DD-MON-YYYY') ) ;
2677: FND_MSG_PUB.ADD ;
2678: p_return_status := FND_API.G_RET_STS_ERROR;
2679:
2680: END IF;
2681:

Line 2692: FND_MSG_PUB.ADD ;

2688: THEN
2689: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_GLDATE_LT_TRXGLDATE');
2690: FND_MESSAGE.SET_TOKEN ( 'GL_DATE', to_char(p_gl_date,'DD-MON-YYYY') ) ;
2691: FND_MESSAGE.SET_TOKEN ( 'TRX_GL_DATE', to_char(p_ps_rec.gl_date,'DD-MON-YYYY') ) ;
2692: FND_MSG_PUB.ADD ;
2693: p_return_status := FND_API.G_RET_STS_ERROR;
2694: END IF;
2695:
2696: IF PG_DEBUG in ('Y', 'C') THEN

Line 2711: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_dates' );

2707: END IF;
2708: /*-----------------------------------------------+
2709: | Set unexpected error message and status |
2710: +-----------------------------------------------*/
2711: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_dates' );
2712: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2713:
2714: RETURN;
2715:

Line 2804: FND_MSG_PUB.ADD ;

2800: THEN
2801: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_DOC_SEQ_NOT_REQD');
2802: FND_MESSAGE.SET_TOKEN ( 'DOCUMENT_SEQ',
2803: to_char(nvl(p_adj_rec.doc_sequence_id,p_adj_rec.doc_sequence_value ))) ;
2804: FND_MSG_PUB.ADD ;
2805: p_return_status := FND_API.G_RET_STS_ERROR;
2806: END IF;
2807: ELSE
2808: /*--------------------------------------------------------+

Line 2857: FND_MSG_PUB.ADD ;

2853: +-----------------------------------------*/
2854: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_DOC_SEQ_NOT_REQD');
2855: FND_MESSAGE.SET_TOKEN ( 'DOCUMENT_SEQ',
2856: to_char(p_adj_rec.doc_sequence_value) ) ;
2857: FND_MSG_PUB.ADD ;
2858:
2859: p_return_status := FND_API.G_RET_STS_ERROR;
2860: END IF;
2861: END IF;

Line 2901: FND_MSG_PUB.ADD ;

2897: AND p_adj_rec.doc_sequence_value IS NULL )
2898: THEN
2899:
2900: FND_MESSAGE.SET_NAME ('FND', 'UNIQUE-ALWAYS USED');
2901: FND_MSG_PUB.ADD ;
2902:
2903: p_return_status := FND_API.G_RET_STS_ERROR;
2904: END IF;
2905:

Line 2928: FND_MSG_PUB.ADD ;

2924: IF (g_context_rec.unique_seq_numbers = 'A' )
2925: THEN
2926:
2927: FND_MESSAGE.SET_NAME ('FND', 'UNIQUE-ALWAYS USED');
2928: FND_MSG_PUB.ADD ;
2929:
2930: p_return_status := FND_API.G_RET_STS_ERROR;
2931: ELSE
2932: p_adj_rec.doc_sequence_id := NULL;

Line 2944: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_doc_seq' );

2940: END IF;
2941: /*-----------------------------------------------+
2942: | Set unexpected error message and status |
2943: +-----------------------------------------------*/
2944: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_doc_seq' );
2945: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2946: RETURN;
2947:
2948: END Validate_doc_seq;

Line 3034: FND_MSG_PUB.ADD ;

3030: | Set the message |
3031: +-----------------------------------------------*/
3032: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_REASON_CODE');
3033: FND_MESSAGE.SET_TOKEN ( 'REASON_CODE', p_adj_rec.reason_code ) ;
3034: FND_MSG_PUB.ADD ;
3035: p_return_status := FND_API.G_RET_STS_ERROR;
3036:
3037: END IF;
3038:

Line 3056: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Reason_code' );

3052: END IF;
3053: /*-----------------------------------------------+
3054: | Set unexpected error message and status |
3055: +-----------------------------------------------*/
3056: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Reason_code' );
3057: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3058:
3059: RETURN;
3060:

Line 3138: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Desc_Flexfield' );

3134: END IF;
3135: /*-----------------------------------------------+
3136: | Set unexpected error message and status |
3137: +-----------------------------------------------*/
3138: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Desc_Flexfield' );
3139: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3140: RETURN;
3141: END ;
3142:

Line 3172: FND_MSG_PUB.ADD ;

3168: IF PG_DEBUG in ('Y', 'C') THEN
3169: arp_util.debug('arp_util.Validate_Desc_Flexfield - Failed', G_MSG_UERROR);
3170: END IF;
3171: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_DESC_FLEX');
3172: FND_MSG_PUB.ADD ;
3173: p_return_status := FND_API.G_RET_STS_ERROR;
3174: END IF;
3175:
3176: p_adj_rec.attribute_category := p_desc_flex_rec.attribute_category;

Line 3205: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Desc_Flexfield' );

3201: END IF;
3202: /*-----------------------------------------------+
3203: | Set unexpected error message and status |
3204: +-----------------------------------------------*/
3205: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Desc_Flexfield' );
3206: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3207:
3208: RETURN;
3209:

Line 3271: FND_MSG_PUB.ADD ;

3267: /*------------------------------------------+
3268: | Set the message |
3269: +------------------------------------------*/
3270: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CREATED_FROM');
3271: FND_MSG_PUB.ADD ;
3272: p_return_status := FND_API.G_RET_STS_ERROR;
3273: END IF;
3274:
3275:

Line 3291: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Created_From'

3287: END IF;
3288: /*-----------------------------------------------+
3289: | Set unexpected error message and status |
3290: +-----------------------------------------------*/
3291: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Created_From'
3292: );
3293: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3294: RETURN;
3295:

Line 3382: FND_MSG_PUB.ADD ;

3378: | Set the message |
3379: +-----------------------------------------------*/
3380: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_USSGL_CODE');
3381: FND_MESSAGE.SET_TOKEN ( 'USSGL_CODE', p_adj_rec.ussgl_transaction_code ) ;
3382: FND_MSG_PUB.ADD ;
3383:
3384: END IF;
3385:
3386: ELSE

Line 3396: FND_MSG_PUB.ADD ;

3392: p_adj_rec.ussgl_transaction_code <> ' ' )
3393: THEN
3394: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_USSGL_CODE_DISALLOW');
3395: FND_MESSAGE.SET_TOKEN ( 'USSGL_CODE', p_adj_rec.ussgl_transaction_code ) ;
3396: FND_MSG_PUB.ADD ;
3397:
3398: ELSE
3399: p_return_status := FND_API.G_RET_STS_SUCCESS;
3400: END IF ;

Line 3418: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Ussgl_code' );

3414: END IF;
3415: /*-----------------------------------------------+
3416: | Set unexpected error message and status |
3417: +-----------------------------------------------*/
3418: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Ussgl_code' );
3419: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3420:
3421: RETURN;
3422:

Line 3502: FND_MSG_PUB.ADD ;

3498: | Set the message |
3499: +------------------------------------------*/
3500: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_RECEIPT_ID');
3501: FND_MESSAGE.SET_TOKEN ( 'ASSOCIATED_CASH_RECEIPT_ID', to_char(p_adj_rec.associated_cash_receipt_id) ) ;
3502: FND_MSG_PUB.ADD ;
3503:
3504: p_return_status := FND_API.G_RET_STS_ERROR;
3505: END IF;
3506:

Line 3526: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Associated_Receipt');

3522: END IF;
3523: /*-----------------------------------------------+
3524: | Set unexpected error message and status |
3525: +-----------------------------------------------*/
3526: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Associated_Receipt');
3527: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3528: RETURN;
3529:
3530: END Validate_Associated_Receipt;

Line 3642: FND_MSG_PUB.Add;

3638: IF ( l_type_adr + p_adj_rec.amount <> 0 )
3639: THEN
3640: p_return_status := FND_API.G_RET_STS_ERROR;
3641: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_ADJ_INV');
3642: FND_MSG_PUB.Add;
3643: END IF;*/
3644:
3645:
3646: ELSE

Line 3670: FND_MSG_PUB.Add;

3666: IF ( l_message_name IS NOT NULL)
3667: THEN
3668: p_return_status := FND_API.G_RET_STS_ERROR;
3669: FND_MESSAGE.SET_NAME('AR',l_message_name);
3670: FND_MSG_PUB.Add;
3671: END IF;
3672:
3673:
3674: /*------------------------------------+

Line 3697: FND_MSG_PUB.Add;

3693: IF ( l_message_name IS NOT NULL)
3694: THEN
3695: p_return_status := FND_API.G_RET_STS_ERROR;
3696: FND_MESSAGE.SET_NAME('AR',l_message_name);
3697: FND_MSG_PUB.Add;
3698: END IF;
3699:
3700: END IF;
3701:

Line 3716: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Over_Application');

3712: END IF;
3713: /*-----------------------------------------------+
3714: | Set unexpected error message and status |
3715: +-----------------------------------------------*/
3716: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Over_Application');
3717: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3718: RETURN;
3719: END Validate_Over_Application;
3720:

Line 3932: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Over_Application_llca');

3928: END IF;
3929: /*-----------------------------------------------+
3930: | Set unexpected error message and status |
3931: +-----------------------------------------------*/
3932: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Over_Application_llca');
3933: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3934: RETURN;
3935: END Validate_Over_Application_llca;
3936: