DBA Data[Home] [Help]

APPS.AR_ADJUST_PUB dependencies on FND_MESSAGE

Line 237: FND_MESSAGE.SET_NAME('AR','AR_TW_PRORATE_ADJ_NO_TAX_RATE');

233: END IF;
234: /*-----------------------------------------------+
235: | Set the message |
236: +-----------------------------------------------*/
237: FND_MESSAGE.SET_NAME('AR','AR_TW_PRORATE_ADJ_NO_TAX_RATE');
238: FND_MSG_PUB.ADD ;
239: p_validation_status := FND_API.G_RET_STS_ERROR;
240: ELSIF (l_error_num = 2) THEN
241: IF PG_DEBUG in ('Y', 'C') THEN

Line 247: FND_MESSAGE.SET_NAME('AR','AR_TW_PRORATE_ADJ_OVERAPPLY');

243: END IF;
244: /*-----------------------------------------------+
245: | Set the message |
246: +-----------------------------------------------*/
247: FND_MESSAGE.SET_NAME('AR','AR_TW_PRORATE_ADJ_OVERAPPLY');
248: FND_MSG_PUB.ADD ;
249: p_validation_status := FND_API.G_RET_STS_ERROR;
250: ELSIF (l_error_num = 3) THEN
251: IF PG_DEBUG in ('Y', 'C') THEN

Line 586: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CHANGE_OR_REVERSE');

582:
583: IF ((( p_old_adj_rec.status = 'A' ) AND (p_adj_rec.created_from <> 'ASSOCIATE_RECEIPT'))
584: OR (p_old_adj_rec.status = 'R')) /*Bug 4303601*/
585: THEN
586: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CHANGE_OR_REVERSE');
587: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_old_adj_rec.status ) ;
588: FND_MSG_PUB.ADD ;
589: p_validation_status := FND_API.G_RET_STS_ERROR;
590: IF PG_DEBUG in ('Y', 'C') THEN

Line 587: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_old_adj_rec.status ) ;

583: IF ((( p_old_adj_rec.status = 'A' ) AND (p_adj_rec.created_from <> 'ASSOCIATE_RECEIPT'))
584: OR (p_old_adj_rec.status = 'R')) /*Bug 4303601*/
585: THEN
586: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CHANGE_OR_REVERSE');
587: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_old_adj_rec.status ) ;
588: FND_MSG_PUB.ADD ;
589: p_validation_status := FND_API.G_RET_STS_ERROR;
590: IF PG_DEBUG in ('Y', 'C') THEN
591: arp_util.debug('Validate_Adj_modify: ' || 'The old adjustment status is A, cannot modify');

Line 603: FND_MESSAGE.SET_NAME ('AR', 'AR_RAPI_RCPT_RA_ID_X_INVALID');

599: (p_adj_rec.created_from = 'ASSOCIATE_RECEIPT') AND
600: (p_adj_rec.associated_application_id IS NULL ) AND
601: (p_adj_rec.associated_cash_receipt_id IS NULL)
602: ) THEN
603: FND_MESSAGE.SET_NAME ('AR', 'AR_RAPI_RCPT_RA_ID_X_INVALID');
604: FND_MSG_PUB.ADD ;
605: p_validation_status := FND_API.G_RET_STS_ERROR;
606: IF PG_DEBUG in ('Y', 'C') THEN
607: arp_util.debug('Validate_Adj_modify: ' || 'Invalid associated cash_receipt_id or application id -should not be null');

Line 620: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CHANGE_OR_REVERSE');

616: ((p_adj_rec.comments IS NOT NULL ) OR
617: (p_adj_rec.status IS NOT NULL ) OR
618: (p_adj_rec.gl_date IS NOT NULL )))
619: THEN
620: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CHANGE_OR_REVERSE');
621: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_old_adj_rec.status ) ;
622: FND_MSG_PUB.ADD ;
623: p_validation_status := FND_API.G_RET_STS_ERROR;
624: IF PG_DEBUG in ('Y', 'C') THEN

Line 621: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_old_adj_rec.status ) ;

617: (p_adj_rec.status IS NOT NULL ) OR
618: (p_adj_rec.gl_date IS NOT NULL )))
619: THEN
620: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CHANGE_OR_REVERSE');
621: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_old_adj_rec.status ) ;
622: FND_MSG_PUB.ADD ;
623: p_validation_status := FND_API.G_RET_STS_ERROR;
624: IF PG_DEBUG in ('Y', 'C') THEN
625: arp_util.debug('Validate_Adj_modify: ' || 'Cannot modify comments,status or gl date of an approved adjustment');

Line 637: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_CHANGE_STATUS');

633:
634: IF ( (p_adj_rec.status IS NOT NULL) AND
635: (p_adj_rec.status NOT IN ('A', 'R', 'W', 'M')) )
636: THEN
637: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_CHANGE_STATUS');
638: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_adj_rec.status ) ;
639: FND_MSG_PUB.ADD ;
640: p_validation_status := FND_API.G_RET_STS_ERROR;
641: IF PG_DEBUG in ('Y', 'C') THEN

Line 638: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_adj_rec.status ) ;

634: IF ( (p_adj_rec.status IS NOT NULL) AND
635: (p_adj_rec.status NOT IN ('A', 'R', 'W', 'M')) )
636: THEN
637: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_CHANGE_STATUS');
638: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_adj_rec.status ) ;
639: FND_MSG_PUB.ADD ;
640: p_validation_status := FND_API.G_RET_STS_ERROR;
641: IF PG_DEBUG in ('Y', 'C') THEN
642: arp_util.debug('Validate_Adj_modify: ' || 'The new adjustment status is not valid, cannot modify');

Line 668: FND_MESSAGE.SET_NAME ( 'AR', 'AR_AAPI_INVALID_PAYMENT_SCHEDULE');

664: /*-----------------------------------------------+
665: | Payment schedule Id does not exist |
666: | Set the message and status accordingly |
667: +-----------------------------------------------*/
668: FND_MESSAGE.SET_NAME ( 'AR', 'AR_AAPI_INVALID_PAYMENT_SCHEDULE');
669: FND_MESSAGE.SET_TOKEN('PAYMENT_SCHEDULE_ID',to_char(p_old_adj_rec.payment_schedule_id));
670: FND_MSG_PUB.ADD ;
671:
672: p_validation_status := FND_API.G_RET_STS_ERROR;

Line 669: FND_MESSAGE.SET_TOKEN('PAYMENT_SCHEDULE_ID',to_char(p_old_adj_rec.payment_schedule_id));

665: | Payment schedule Id does not exist |
666: | Set the message and status accordingly |
667: +-----------------------------------------------*/
668: FND_MESSAGE.SET_NAME ( 'AR', 'AR_AAPI_INVALID_PAYMENT_SCHEDULE');
669: FND_MESSAGE.SET_TOKEN('PAYMENT_SCHEDULE_ID',to_char(p_old_adj_rec.payment_schedule_id));
670: FND_MSG_PUB.ADD ;
671:
672: p_validation_status := FND_API.G_RET_STS_ERROR;
673: IF PG_DEBUG in ('Y', 'C') THEN

Line 709: FND_MESSAGE.SET_NAME ( 'AR', 'AR_VAL_AMT_APPROVAL_LIMIT');

705: END IF;
706:
707: IF ( l_approved_flag <> FND_API.G_TRUE )
708: THEN
709: FND_MESSAGE.SET_NAME ( 'AR', 'AR_VAL_AMT_APPROVAL_LIMIT');
710: FND_MSG_PUB.ADD ;
711: p_validation_status := FND_API.G_RET_STS_ERROR;
712: IF PG_DEBUG in ('Y', 'C') THEN
713: arp_util.debug('Validate_Adj_modify: ' || 'amount not in approval limits ');

Line 780: FND_MESSAGE.SET_NAME ( 'AR', 'AR_RAPI_REC_APP_ID_INVALID');

776: AND receivable_application_id = p_adj_rec.associated_application_id
777: AND applied_payment_schedule_id= p_old_adj_rec.payment_schedule_id;
778: EXCEPTION
779: WHEN no_data_found THEN
780: FND_MESSAGE.SET_NAME ( 'AR', 'AR_RAPI_REC_APP_ID_INVALID');
781: FND_MSG_PUB.ADD ;
782: p_validation_status := FND_API.G_RET_STS_ERROR;
783: IF PG_DEBUG in ('Y', 'C') THEN
784: arp_util.debug('Validate_Adj_modify: ' || 'Associated Application ID passed is invalid');

Line 797: FND_MESSAGE.SET_NAME ( 'AR', 'AR_RAPI_REC_APP_ID_INVALID');

793: ( p_old_adj_rec.associated_cash_receipt_id IS NULL ) AND
794: ( p_adj_rec.associated_cash_receipt_id IS NULL ) AND
795: ( l_cash_receipt_id IS NULL )) THEN
796:
797: FND_MESSAGE.SET_NAME ( 'AR', 'AR_RAPI_REC_APP_ID_INVALID');
798: FND_MSG_PUB.ADD ;
799: p_validation_status := FND_API.G_RET_STS_ERROR;
800: IF PG_DEBUG in ('Y', 'C') THEN
801: arp_util.debug('Validate_Adj_modify: ' || 'Associated Application ID should belongs to valid Receipt,pass cash receipt id');

Line 925: FND_MESSAGE.SET_NAME ( 'AR', 'AR_AAPI_NO_CHANGE_OR_REVERSE');

921: +----------------------------------------------*/
922:
923: IF ( p_old_adj_rec.status <> 'A' )
924: THEN
925: FND_MESSAGE.SET_NAME ( 'AR', 'AR_AAPI_NO_CHANGE_OR_REVERSE');
926: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_old_adj_rec.status);
927: FND_MSG_PUB.ADD ;
928: p_validation_status := FND_API.G_RET_STS_ERROR;
929: IF PG_DEBUG in ('Y', 'C') THEN

Line 926: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_old_adj_rec.status);

922:
923: IF ( p_old_adj_rec.status <> 'A' )
924: THEN
925: FND_MESSAGE.SET_NAME ( 'AR', 'AR_AAPI_NO_CHANGE_OR_REVERSE');
926: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_old_adj_rec.status);
927: FND_MSG_PUB.ADD ;
928: p_validation_status := FND_API.G_RET_STS_ERROR;
929: IF PG_DEBUG in ('Y', 'C') THEN
930: arp_util.debug('Validate_Adj_Reverse: ' || 'the status of the old adj is not A ');

Line 969: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_PAYMENT_SCHEDULE');

965: | Payment schedule Id does not exist |
966: | Set the message and status accordingly |
967: +-----------------------------------------------*/
968:
969: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_PAYMENT_SCHEDULE');
970: FND_MESSAGE.SET_TOKEN ( 'PAYMENT_SCHEDULE_ID', to_char(p_old_adj_rec.payment_schedule_id) ) ;
971: FND_MSG_PUB.ADD ;
972:
973: p_validation_status := FND_API.G_RET_STS_ERROR;

Line 970: FND_MESSAGE.SET_TOKEN ( 'PAYMENT_SCHEDULE_ID', to_char(p_old_adj_rec.payment_schedule_id) ) ;

966: | Set the message and status accordingly |
967: +-----------------------------------------------*/
968:
969: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_PAYMENT_SCHEDULE');
970: FND_MESSAGE.SET_TOKEN ( 'PAYMENT_SCHEDULE_ID', to_char(p_old_adj_rec.payment_schedule_id) ) ;
971: FND_MSG_PUB.ADD ;
972:
973: p_validation_status := FND_API.G_RET_STS_ERROR;
974: IF PG_DEBUG in ('Y', 'C') THEN

Line 1072: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CHANGE_OR_REVERSE');

1068:
1069: IF ( p_old_adj_rec.status IN ('A','R') ) /*Bug 4290494*/
1070: THEN
1071:
1072: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CHANGE_OR_REVERSE');
1073: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_old_adj_rec.status ) ;
1074: FND_MSG_PUB.ADD ;
1075: p_validation_status := FND_API.G_RET_STS_ERROR;
1076: IF PG_DEBUG in ('Y', 'C') THEN

Line 1073: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_old_adj_rec.status ) ;

1069: IF ( p_old_adj_rec.status IN ('A','R') ) /*Bug 4290494*/
1070: THEN
1071:
1072: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CHANGE_OR_REVERSE');
1073: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_old_adj_rec.status ) ;
1074: FND_MSG_PUB.ADD ;
1075: p_validation_status := FND_API.G_RET_STS_ERROR;
1076: IF PG_DEBUG in ('Y', 'C') THEN
1077: arp_util.debug('Validate_Adj_Approve: ' || 'the adjustment is already approved or rejected');

Line 1098: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_CHANGE_STATUS');

1094: IF ( (p_adj_rec.status IS NOT NULL) AND
1095: (p_adj_rec.status NOT IN ('A', 'R', 'W', 'M')) )
1096: THEN
1097:
1098: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_CHANGE_STATUS');
1099: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_adj_rec.status ) ;
1100: FND_MSG_PUB.ADD ;
1101: p_validation_status := FND_API.G_RET_STS_ERROR;
1102: IF PG_DEBUG in ('Y', 'C') THEN

Line 1099: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_adj_rec.status ) ;

1095: (p_adj_rec.status NOT IN ('A', 'R', 'W', 'M')) )
1096: THEN
1097:
1098: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_CHANGE_STATUS');
1099: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_adj_rec.status ) ;
1100: FND_MSG_PUB.ADD ;
1101: p_validation_status := FND_API.G_RET_STS_ERROR;
1102: IF PG_DEBUG in ('Y', 'C') THEN
1103: arp_util.debug('Validate_Adj_Approve: ' || 'the value of the new status is not in A, R, W, M');

Line 1133: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_PAYMENT_SCHEDULE');

1129: | Payment schedule Id does not exist |
1130: | Set the message and status accordingly |
1131: +-----------------------------------------------*/
1132:
1133: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_PAYMENT_SCHEDULE');
1134: FND_MESSAGE.SET_TOKEN('PAYMENT_SCHEDULE_ID',to_char(p_old_adj_rec.payment_schedule_id));
1135: FND_MSG_PUB.ADD ;
1136: p_validation_status := FND_API.G_RET_STS_ERROR;
1137: IF PG_DEBUG in ('Y', 'C') THEN

Line 1134: FND_MESSAGE.SET_TOKEN('PAYMENT_SCHEDULE_ID',to_char(p_old_adj_rec.payment_schedule_id));

1130: | Set the message and status accordingly |
1131: +-----------------------------------------------*/
1132:
1133: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_PAYMENT_SCHEDULE');
1134: FND_MESSAGE.SET_TOKEN('PAYMENT_SCHEDULE_ID',to_char(p_old_adj_rec.payment_schedule_id));
1135: FND_MSG_PUB.ADD ;
1136: p_validation_status := FND_API.G_RET_STS_ERROR;
1137: IF PG_DEBUG in ('Y', 'C') THEN
1138: arp_util.debug('Validate_Adj_Approve: ' || 'Invalid payment schedule id');

Line 1173: FND_MESSAGE.SET_NAME ('AR', 'AR_VAL_AMT_APPROVAL_LIMIT');

1169: END IF;
1170:
1171: IF ( l_approved_flag <> FND_API.G_TRUE )
1172: THEN
1173: FND_MESSAGE.SET_NAME ('AR', 'AR_VAL_AMT_APPROVAL_LIMIT');
1174: FND_MSG_PUB.ADD ;
1175:
1176: p_validation_status := FND_API.G_RET_STS_ERROR;
1177: IF PG_DEBUG in ('Y', 'C') THEN

Line 1425: FND_MESSAGE.SET_NAME ('AR', 'AR_ADJ_API_TYPE_DISALLOW');

1421: IF p_adj_rec.type NOT IN ('LINE')
1422: THEN
1423:
1424: l_return_status := FND_API.G_RET_STS_ERROR ;
1425: FND_MESSAGE.SET_NAME ('AR', 'AR_ADJ_API_TYPE_DISALLOW');
1426: FND_MESSAGE.SET_TOKEN ( 'TYPE', p_adj_rec.TYPE ) ;
1427: FND_MSG_PUB.ADD ;
1428:
1429: IF PG_DEBUG in ('Y', 'C') THEN

Line 1426: FND_MESSAGE.SET_TOKEN ( 'TYPE', p_adj_rec.TYPE ) ;

1422: THEN
1423:
1424: l_return_status := FND_API.G_RET_STS_ERROR ;
1425: FND_MESSAGE.SET_NAME ('AR', 'AR_ADJ_API_TYPE_DISALLOW');
1426: FND_MESSAGE.SET_TOKEN ( 'TYPE', p_adj_rec.TYPE ) ;
1427: FND_MSG_PUB.ADD ;
1428:
1429: IF PG_DEBUG in ('Y', 'C') THEN
1430: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');

Line 1439: FND_MESSAGE.SET_NAME ('AR', 'AR_ADJ_API_CUST_LINE_ID_IG');

1435:
1436: IF p_adj_rec.customer_trx_line_id IS NOT NULL
1437: THEN
1438:
1439: FND_MESSAGE.SET_NAME ('AR', 'AR_ADJ_API_CUST_LINE_ID_IG');
1440: FND_MESSAGE.SET_TOKEN ( 'CUSTOMER_TRX_LINE_ID', p_adj_rec.customer_trx_line_id ) ;
1441: FND_MSG_PUB.ADD ;
1442:
1443: IF PG_DEBUG in ('Y', 'C') THEN

Line 1440: FND_MESSAGE.SET_TOKEN ( 'CUSTOMER_TRX_LINE_ID', p_adj_rec.customer_trx_line_id ) ;

1436: IF p_adj_rec.customer_trx_line_id IS NOT NULL
1437: THEN
1438:
1439: FND_MESSAGE.SET_NAME ('AR', 'AR_ADJ_API_CUST_LINE_ID_IG');
1440: FND_MESSAGE.SET_TOKEN ( 'CUSTOMER_TRX_LINE_ID', p_adj_rec.customer_trx_line_id ) ;
1441: FND_MSG_PUB.ADD ;
1442:
1443: IF PG_DEBUG in ('Y', 'C') THEN
1444: arp_util.debug('create_linelevel_adjustment : ' || 'Warning(s) occurred. Ignoring header level customer trx line id');

Line 1454: FND_MESSAGE.SET_NAME ('AR', 'AR_ADJ_API_RECV_TRX_ID_IG');

1450:
1451: IF p_adj_rec.receivables_trx_id IS NOT NULL
1452: THEN
1453:
1454: FND_MESSAGE.SET_NAME ('AR', 'AR_ADJ_API_RECV_TRX_ID_IG');
1455: FND_MESSAGE.SET_TOKEN ( 'RECEIVABLES_TRX_ID', p_adj_rec.receivables_trx_id ) ;
1456: FND_MSG_PUB.ADD ;
1457:
1458: IF PG_DEBUG in ('Y', 'C') THEN

Line 1455: FND_MESSAGE.SET_TOKEN ( 'RECEIVABLES_TRX_ID', p_adj_rec.receivables_trx_id ) ;

1451: IF p_adj_rec.receivables_trx_id IS NOT NULL
1452: THEN
1453:
1454: FND_MESSAGE.SET_NAME ('AR', 'AR_ADJ_API_RECV_TRX_ID_IG');
1455: FND_MESSAGE.SET_TOKEN ( 'RECEIVABLES_TRX_ID', p_adj_rec.receivables_trx_id ) ;
1456: FND_MSG_PUB.ADD ;
1457:
1458: IF PG_DEBUG in ('Y', 'C') THEN
1459: arp_util.debug('create_linelevel_adjustment : ' || 'Warning(s) occurred. Ignoring header level receivables trx id');

Line 1467: FND_MESSAGE.SET_NAME ('AR', 'AR_ADJ_API_AMOUNT_IG');

1463: END IF;
1464:
1465: IF p_adj_rec.amount IS NOT NULL
1466: THEN
1467: FND_MESSAGE.SET_NAME ('AR', 'AR_ADJ_API_AMOUNT_IG');
1468: FND_MESSAGE.SET_TOKEN ( 'AMOUNT', p_adj_rec.amount ) ;
1469: FND_MSG_PUB.ADD ;
1470:
1471: IF PG_DEBUG in ('Y', 'C') THEN

Line 1468: FND_MESSAGE.SET_TOKEN ( 'AMOUNT', p_adj_rec.amount ) ;

1464:
1465: IF p_adj_rec.amount IS NOT NULL
1466: THEN
1467: FND_MESSAGE.SET_NAME ('AR', 'AR_ADJ_API_AMOUNT_IG');
1468: FND_MESSAGE.SET_TOKEN ( 'AMOUNT', p_adj_rec.amount ) ;
1469: FND_MSG_PUB.ADD ;
1470:
1471: IF PG_DEBUG in ('Y', 'C') THEN
1472: arp_util.debug('create_linelevel_adjustment : ' || 'Warning(s) occurred. Ignoring header level Amount');

Line 1488: FND_MESSAGE.SET_NAME ('AR', 'AR_LL_ADJ_INSTALL_NOT_ALLOWED');

1484:
1485: IF nvl(ll_installment,0) > 1
1486: THEN
1487: l_return_status := FND_API.G_RET_STS_ERROR ;
1488: FND_MESSAGE.SET_NAME ('AR', 'AR_LL_ADJ_INSTALL_NOT_ALLOWED');
1489: FND_MESSAGE.SET_TOKEN ( 'CUST_TRX_ID', p_adj_rec.customer_trx_id ) ;
1490: FND_MSG_PUB.ADD ;
1491: IF PG_DEBUG in ('Y', 'C') THEN
1492: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');

Line 1489: FND_MESSAGE.SET_TOKEN ( 'CUST_TRX_ID', p_adj_rec.customer_trx_id ) ;

1485: IF nvl(ll_installment,0) > 1
1486: THEN
1487: l_return_status := FND_API.G_RET_STS_ERROR ;
1488: FND_MESSAGE.SET_NAME ('AR', 'AR_LL_ADJ_INSTALL_NOT_ALLOWED');
1489: FND_MESSAGE.SET_TOKEN ( 'CUST_TRX_ID', p_adj_rec.customer_trx_id ) ;
1490: FND_MSG_PUB.ADD ;
1491: IF PG_DEBUG in ('Y', 'C') THEN
1492: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
1493: arp_util.debug('create_linelevel_adjustment : ' || 'Multiple Installment transaction not allowed at line-level');

Line 1509: FND_MESSAGE.SET_NAME ('AR', 'AR_LL_ADJ_LEGACY_NOT_ALLOWED');

1505: x_mfar_app => ll_mfar_app );
1506: IF (ll_leg_adj = 'Y') OR (ll_leg_app = 'Y')
1507: THEN
1508: l_return_status := FND_API.G_RET_STS_ERROR ;
1509: FND_MESSAGE.SET_NAME ('AR', 'AR_LL_ADJ_LEGACY_NOT_ALLOWED');
1510: FND_MESSAGE.SET_TOKEN ( 'CUST_TRX_ID', p_adj_rec.customer_trx_id ) ;
1511: FND_MSG_PUB.ADD ;
1512: IF PG_DEBUG in ('Y', 'C') THEN
1513: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');

Line 1510: FND_MESSAGE.SET_TOKEN ( 'CUST_TRX_ID', p_adj_rec.customer_trx_id ) ;

1506: IF (ll_leg_adj = 'Y') OR (ll_leg_app = 'Y')
1507: THEN
1508: l_return_status := FND_API.G_RET_STS_ERROR ;
1509: FND_MESSAGE.SET_NAME ('AR', 'AR_LL_ADJ_LEGACY_NOT_ALLOWED');
1510: FND_MESSAGE.SET_TOKEN ( 'CUST_TRX_ID', p_adj_rec.customer_trx_id ) ;
1511: FND_MSG_PUB.ADD ;
1512: IF PG_DEBUG in ('Y', 'C') THEN
1513: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
1514: arp_util.debug('create_linelevel_adjustment : ' || 'Legacy data with activity not allowed at line-level');

Line 1941: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );

1937:
1938: ROLLBACK TO ar_adjust_PUB;
1939: p_return_status := FND_API.G_RET_STS_ERROR ;
1940:
1941: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
1942: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.insert_adjustment exception: '||SQLERRM );
1943: --2920926
1944: FND_MSG_PUB.ADD;
1945: /*--------------------------------------------------+

Line 1942: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.insert_adjustment exception: '||SQLERRM );

1938: ROLLBACK TO ar_adjust_PUB;
1939: p_return_status := FND_API.G_RET_STS_ERROR ;
1940:
1941: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
1942: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.insert_adjustment exception: '||SQLERRM );
1943: --2920926
1944: FND_MSG_PUB.ADD;
1945: /*--------------------------------------------------+
1946: | Get message count and if 1, return message data |

Line 2230: FND_MESSAGE.set_name('AR', 'AR_SUMMARIZED_DIST_NO_LLCA_ADJ');

2226: p_return_status := FND_API.G_RET_STS_ERROR;
2227: ELSE
2228: --Verify whether line level adjustment is allowed for given org/invoice
2229: IF NOT arp_standard.is_llca_allowed(l_org_id,p_adj_rec.customer_trx_id) THEN
2230: FND_MESSAGE.set_name('AR', 'AR_SUMMARIZED_DIST_NO_LLCA_ADJ');
2231: FND_MSG_PUB.Add;
2232: l_return_status := FND_API.G_RET_STS_ERROR;
2233: RAISE FND_API.G_EXC_ERROR;
2234: END IF;

Line 2541: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );

2537:
2538: ROLLBACK TO ar_adjust_line_PUB;
2539: p_return_status := FND_API.G_RET_STS_ERROR ;
2540:
2541: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
2542: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.insert_adjustment exception: '||SQLERRM );
2543: --2920926
2544: FND_MSG_PUB.ADD;
2545: /*--------------------------------------------------+

Line 2542: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.insert_adjustment exception: '||SQLERRM );

2538: ROLLBACK TO ar_adjust_line_PUB;
2539: p_return_status := FND_API.G_RET_STS_ERROR ;
2540:
2541: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
2542: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.insert_adjustment exception: '||SQLERRM );
2543: --2920926
2544: FND_MSG_PUB.ADD;
2545: /*--------------------------------------------------+
2546: | Get message count and if 1, return message data |

Line 2888: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_ADJ_ID');

2884: | Rollback to the defined Savepoint |
2885: +---------------------------------------------------*/
2886: ROLLBACK TO ar_adjust_PUB;
2887: p_return_status := FND_API.G_RET_STS_ERROR ;
2888: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_ADJ_ID');
2889: FND_MESSAGE.SET_TOKEN ( 'ADJUSTMENT_ID', to_char(p_old_adjust_id) ) ;
2890: FND_MSG_PUB.ADD ;
2891: RETURN;
2892: END ;

Line 2889: FND_MESSAGE.SET_TOKEN ( 'ADJUSTMENT_ID', to_char(p_old_adjust_id) ) ;

2885: +---------------------------------------------------*/
2886: ROLLBACK TO ar_adjust_PUB;
2887: p_return_status := FND_API.G_RET_STS_ERROR ;
2888: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_ADJ_ID');
2889: FND_MESSAGE.SET_TOKEN ( 'ADJUSTMENT_ID', to_char(p_old_adjust_id) ) ;
2890: FND_MSG_PUB.ADD ;
2891: RETURN;
2892: END ;
2893:

Line 2977: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );

2973: ROLLBACK TO ar_adjust_PUB;
2974:
2975: p_return_status := FND_API.G_RET_STS_ERROR ;
2976:
2977: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
2978: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.update_adjustment exception: '||SQLERRM );
2979: --2920926
2980: FND_MSG_PUB.ADD;
2981:

Line 2978: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.update_adjustment exception: '||SQLERRM );

2974:
2975: p_return_status := FND_API.G_RET_STS_ERROR ;
2976:
2977: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
2978: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.update_adjustment exception: '||SQLERRM );
2979: --2920926
2980: FND_MSG_PUB.ADD;
2981:
2982: /*--------------------------------------------------+

Line 3311: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_ADJ_ID');

3307: ROLLBACK TO ar_adjust_PUB;
3308:
3309: p_return_status := FND_API.G_RET_STS_ERROR ;
3310:
3311: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_ADJ_ID');
3312: FND_MESSAGE.SET_TOKEN ( 'ADJUSTMENT_ID', to_char(p_old_adjust_id) ) ;
3313: FND_MSG_PUB.ADD ;
3314: RETURN;
3315: END ;

Line 3312: FND_MESSAGE.SET_TOKEN ( 'ADJUSTMENT_ID', to_char(p_old_adjust_id) ) ;

3308:
3309: p_return_status := FND_API.G_RET_STS_ERROR ;
3310:
3311: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_ADJ_ID');
3312: FND_MESSAGE.SET_TOKEN ( 'ADJUSTMENT_ID', to_char(p_old_adjust_id) ) ;
3313: FND_MSG_PUB.ADD ;
3314: RETURN;
3315: END ;
3316:

Line 3906: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_ADJ_ID');

3902: ROLLBACK TO ar_adjust_PUB;
3903:
3904: p_return_status := FND_API.G_RET_STS_ERROR ;
3905:
3906: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_ADJ_ID');
3907: FND_MESSAGE.SET_TOKEN ( 'ADJUSTMENT_ID', to_char(p_old_adjust_id) ) ;
3908: FND_MSG_PUB.ADD ;
3909: RETURN;
3910: END ;

Line 3907: FND_MESSAGE.SET_TOKEN ( 'ADJUSTMENT_ID', to_char(p_old_adjust_id) ) ;

3903:
3904: p_return_status := FND_API.G_RET_STS_ERROR ;
3905:
3906: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_ADJ_ID');
3907: FND_MESSAGE.SET_TOKEN ( 'ADJUSTMENT_ID', to_char(p_old_adjust_id) ) ;
3908: FND_MSG_PUB.ADD ;
3909: RETURN;
3910: END ;
3911:

Line 3988: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );

3984: ROLLBACK TO ar_adjust_PUB;
3985:
3986: p_return_status := FND_API.G_RET_STS_ERROR ;
3987:
3988: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
3989: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.update_approve_adj exception: '||SQLERRM );
3990: --2920926
3991: FND_MSG_PUB.ADD;
3992: /*--------------------------------------------------+

Line 3989: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.update_approve_adj exception: '||SQLERRM );

3985:
3986: p_return_status := FND_API.G_RET_STS_ERROR ;
3987:
3988: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
3989: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.update_approve_adj exception: '||SQLERRM );
3990: --2920926
3991: FND_MSG_PUB.ADD;
3992: /*--------------------------------------------------+
3993: | Get message count and if 1, return message data |