DBA Data[Home] [Help]

APPS.AR_RECEIPT_API_PUB dependencies on FND_MESSAGE

Line 542: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_DFLT_DOC_SEQ');

538: l_receipt_number := l_doc_sequence_value;
539: --warning message
540: IF FND_MSG_PUB.Check_Msg_Level(G_MSG_SUCCESS)
541: THEN
542: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_DFLT_DOC_SEQ');
543: FND_MSG_PUB.Add;
544: END IF;
545: ELSE
546: IF PG_DEBUG in ('Y', 'C') THEN

Line 550: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_NULL');

546: IF PG_DEBUG in ('Y', 'C') THEN
547: arp_util.debug('Create_cash_1: ' || 'Receipt Number is null ');
548: END IF;
549: --raise error message
550: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_NULL');
551: FND_MSG_PUB.Add;
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: END IF;
554: END IF;

Line 591: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');

587: IF ( l_creation_method = 'A' and l_payment_trxn_extension_id is NULL) THEN
588:
589: arp_util.debug('Create_cash_122: ' || l_creation_method_code);
590: arp_util.debug('Create_cash_122: ' || l_payment_trxn_extension_id );
591: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
592: FND_MSG_PUB.Add;
593: x_return_status := FND_API.G_RET_STS_ERROR;
594: END IF;
595:

Line 624: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');

620: );
621:
622: IF l_copy_return_status <> FND_API.G_RET_STS_SUCCESS THEN
623: arp_util.debug('Create_cash_123: ' );
624: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
625: FND_MSG_PUB.Add;
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: END IF;
628:

Line 656: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');

652: );
653:
654: IF l_create_return_status <> FND_API.G_RET_STS_SUCCESS THEN
655: arp_util.debug('Create_cash_123: ' );
656: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
657: FND_MSG_PUB.Add;
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: END IF;
660:

Line 825: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

821: ROLLBACK TO Create_Cash_PVT;
822:
823: -- Display_Parameters;
824: x_return_status := FND_API.G_RET_STS_ERROR ;
825: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
826: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROC_RECEIPTS2.INSERT_CASH_RECEIPT : '||SQLERRM);
827: FND_MSG_PUB.Add;
828:
829: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 826: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROC_RECEIPTS2.INSERT_CASH_RECEIPT : '||SQLERRM);

822:
823: -- Display_Parameters;
824: x_return_status := FND_API.G_RET_STS_ERROR ;
825: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
826: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROC_RECEIPTS2.INSERT_CASH_RECEIPT : '||SQLERRM);
827: FND_MSG_PUB.Add;
828:
829: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
830: p_count => x_msg_count,

Line 921: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

917: ROLLBACK TO Create_Cash_PVT;
918:
919: -- Display_Parameters;
920: x_return_status := FND_API.G_RET_STS_ERROR ;
921: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
922: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_CASH : '||SQLERRM);
923: FND_MSG_PUB.Add;
924:
925: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 922: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_CASH : '||SQLERRM);

918:
919: -- Display_Parameters;
920: x_return_status := FND_API.G_RET_STS_ERROR ;
921: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
922: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_CASH : '||SQLERRM);
923: FND_MSG_PUB.Add;
924:
925: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
926: p_count => x_msg_count,

Line 932: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

928: );
929: RETURN;
930: ELSE
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
932: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
933: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_CASH : '||SQLERRM);
934: FND_MSG_PUB.Add;
935: END IF;
936:

Line 933: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_CASH : '||SQLERRM);

929: RETURN;
930: ELSE
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
932: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
933: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_CASH : '||SQLERRM);
934: FND_MSG_PUB.Add;
935: END IF;
936:
937: IF PG_DEBUG in ('Y', 'C') THEN

Line 1740: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

1736: ROLLBACK TO Apply_PVT;
1737:
1738: -- Display_Parameters;
1739: x_return_status := FND_API.G_RET_STS_ERROR ;
1740: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1741: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.RECEIPT_APPLICATION '||SQLERRM);
1742: FND_MSG_PUB.Add;
1743:
1744: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 1741: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.RECEIPT_APPLICATION '||SQLERRM);

1737:
1738: -- Display_Parameters;
1739: x_return_status := FND_API.G_RET_STS_ERROR ;
1740: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1741: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.RECEIPT_APPLICATION '||SQLERRM);
1742: FND_MSG_PUB.Add;
1743:
1744: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1745: p_count => x_msg_count,

Line 1859: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

1855: --If only one error message on the stack,
1856: --retrive it
1857:
1858: x_return_status := FND_API.G_RET_STS_ERROR ;
1859: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1860: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
1861: FND_MSG_PUB.Add;
1862:
1863: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1860: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);

1856: --retrive it
1857:
1858: x_return_status := FND_API.G_RET_STS_ERROR ;
1859: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1860: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
1861: FND_MSG_PUB.Add;
1862:
1863: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1864: p_count => x_msg_count,

Line 1872: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

1868: RETURN;
1869:
1870: ELSE
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1872: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1873: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
1874: FND_MSG_PUB.Add;
1875: END IF;
1876:

Line 1873: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);

1869:
1870: ELSE
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1872: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1873: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
1874: FND_MSG_PUB.Add;
1875: END IF;
1876:
1877: IF PG_DEBUG in ('Y', 'C') THEN

Line 2113: FND_MESSAGE.set_name('AR', 'AR_SUMMARIZED_DIST_NO_LLCA_RCT');

2109: x_return_status := FND_API.G_RET_STS_ERROR;
2110: ELSE
2111: --Verify whether LLCA is allowed for given invoice
2112: IF NOT arp_standard.is_llca_allowed(l_org_id,p_customer_trx_id) THEN
2113: FND_MESSAGE.set_name('AR', 'AR_SUMMARIZED_DIST_NO_LLCA_RCT');
2114: FND_MSG_PUB.Add;
2115: x_return_status := FND_API.G_RET_STS_ERROR;
2116: RAISE FND_API.G_EXC_ERROR;
2117: END IF;

Line 2739: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

2735: ROLLBACK TO Apply_In_Detail_PVT;
2736:
2737: -- Display_Parameters;
2738: x_return_status := FND_API.G_RET_STS_ERROR ;
2739: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2740: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.RECEIPT_APPLICATION '||SQLERRM);
2741: FND_MSG_PUB.Add;
2742:
2743: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 2740: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.RECEIPT_APPLICATION '||SQLERRM);

2736:
2737: -- Display_Parameters;
2738: x_return_status := FND_API.G_RET_STS_ERROR ;
2739: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2740: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.RECEIPT_APPLICATION '||SQLERRM);
2741: FND_MSG_PUB.Add;
2742:
2743: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2744: p_count => x_msg_count,

Line 2876: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

2872: --If only one error message on the stack,
2873: --retrive it
2874:
2875: x_return_status := FND_API.G_RET_STS_ERROR ;
2876: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2877: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
2878: FND_MSG_PUB.Add;
2879:
2880: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2877: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);

2873: --retrive it
2874:
2875: x_return_status := FND_API.G_RET_STS_ERROR ;
2876: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2877: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
2878: FND_MSG_PUB.Add;
2879:
2880: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2881: p_count => x_msg_count,

Line 2889: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

2885: RETURN;
2886:
2887: ELSE
2888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2889: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2890: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
2891: FND_MSG_PUB.Add;
2892: END IF;
2893:

Line 2890: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);

2886:
2887: ELSE
2888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2889: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2890: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
2891: FND_MSG_PUB.Add;
2892: END IF;
2893:
2894: IF PG_DEBUG in ('Y', 'C') THEN

Line 3292: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

3288: ROLLBACK TO Unapply_PVT;
3289:
3290: -- Display_Parameters;
3291: x_return_status := FND_API.G_RET_STS_ERROR ;
3292: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
3293: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
3294: FND_MSG_PUB.Add;
3295:
3296: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 3293: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);

3289:
3290: -- Display_Parameters;
3291: x_return_status := FND_API.G_RET_STS_ERROR ;
3292: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
3293: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
3294: FND_MSG_PUB.Add;
3295:
3296: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
3297: p_count => x_msg_count,

Line 3370: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

3366:
3367: ROLLBACK TO Unapply_PVT;
3368:
3369: x_return_status := FND_API.G_RET_STS_ERROR ;
3370: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
3371: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY : '||SQLERRM);
3372: FND_MSG_PUB.Add;
3373:
3374: --If only one error message on the stack,

Line 3371: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY : '||SQLERRM);

3367: ROLLBACK TO Unapply_PVT;
3368:
3369: x_return_status := FND_API.G_RET_STS_ERROR ;
3370: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
3371: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY : '||SQLERRM);
3372: FND_MSG_PUB.Add;
3373:
3374: --If only one error message on the stack,
3375: --retrive it

Line 3386: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

3382: RETURN;
3383:
3384: ELSE
3385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3386: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
3387: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY : '||SQLERRM);
3388: FND_MSG_PUB.Add;
3389: END IF;
3390:

Line 3387: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY : '||SQLERRM);

3383:
3384: ELSE
3385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3386: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
3387: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY : '||SQLERRM);
3388: FND_MSG_PUB.Add;
3389: END IF;
3390:
3391: IF PG_DEBUG in ('Y', 'C') THEN

Line 3528: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_INVALID_STATUS');

3524: IF PG_DEBUG in ('Y', 'C') THEN
3525: arp_standard.debug('Apply: ' || 'ERROR: Creation status is ' || rct_info.creation_status);
3526: END IF;
3527:
3528: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_INVALID_STATUS');
3529: FND_MSG_PUB.Add;
3530:
3531: x_return_status := FND_API.G_RET_STS_ERROR; -- should never happen
3532: RETURN;

Line 3667: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_AUTHFAILURE');

3663:
3664: if (l_return_status <> FND_API.G_RET_STS_SUCCESS)
3665: AND (NVL(p_called_from,'NONE') = 'IREC') then
3666:
3667: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_AUTHFAILURE');
3668: FND_MSG_PUB.Add;
3669: x_return_status := l_return_status;
3670: RETURN;
3671: elsif (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3674: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');

3670: RETURN;
3671: elsif (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3672: --bug 3398538
3673: arp_util.debug('Create_cash_124: ');
3674: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
3675: FND_MSG_PUB.Add;
3676: x_return_status := l_return_status;
3677: RETURN;
3678: end if;

Line 3777: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_CAPTFAILURE');

3773: --Add message to message stack only it it is called from iReceivables
3774: --if not pass the message stack received from iPayment
3775:
3776: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) AND (NVL(p_called_from,'NONE') = 'IREC') then
3777: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_CAPTFAILURE');
3778: FND_MSG_PUB.Add;
3779: --bug 3398538
3780: elsif (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3781: FND_MESSAGE.set_name('AR', 'AR_CC_CAPTURE_FAILED');

Line 3781: FND_MESSAGE.set_name('AR', 'AR_CC_CAPTURE_FAILED');

3777: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_CAPTFAILURE');
3778: FND_MSG_PUB.Add;
3779: --bug 3398538
3780: elsif (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3781: FND_MESSAGE.set_name('AR', 'AR_CC_CAPTURE_FAILED');
3782: FND_MSG_PUB.Add;
3783: end if;
3784: x_return_status := l_return_status;
3785:

Line 3923: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_INVALID_STATUS');

3919: IF PG_DEBUG in ('Y', 'C') THEN
3920: arp_standard.debug('Apply: ' || 'ERROR: Creation status is ' || rct_info.creation_status);
3921: END IF;
3922:
3923: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_INVALID_STATUS');
3924: FND_MSG_PUB.Add;
3925:
3926: x_return_status := FND_API.G_RET_STS_ERROR; -- should never happen
3927: RETURN;

Line 4149: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_AUTHFAILURE');

4145:
4146: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
4147: AND (NVL(p_called_from,'NONE') = 'IREC') then
4148:
4149: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_AUTHFAILURE');
4150: FND_MSG_PUB.Add;
4151: x_return_status := l_return_status;
4152: RETURN;
4153:

Line 4157: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');

4153:
4154: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4155:
4156: arp_standard.debug('create_cash_126');
4157: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
4158: FND_MSG_PUB.Add;
4159:
4160: IF l_response_rec.Result_Code is NOT NULL THEN
4161:

Line 4170: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

4166: l_iby_msg_data := substrb( l_response_rec.Result_Code || ': '||
4167: l_response_rec.Result_Message , 1, 240);
4168:
4169: arp_standard.debug( 'l_iby_msg_data: ' || l_iby_msg_data);
4170: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4171: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_iby_msg_data);
4172:
4173: FND_MSG_PUB.Add;
4174:

Line 4171: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_iby_msg_data);

4167: l_response_rec.Result_Message , 1, 240);
4168:
4169: arp_standard.debug( 'l_iby_msg_data: ' || l_iby_msg_data);
4170: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4171: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_iby_msg_data);
4172:
4173: FND_MSG_PUB.Add;
4174:
4175: END IF;

Line 4186: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

4182:
4183: l_vend_msg_data := substrb(l_authresult_rec.PaymentSys_Code || ': '||
4184: l_authresult_rec.PaymentSys_Msg , 1, 240 );
4185:
4186: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4187: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_vend_msg_data);
4188:
4189: FND_MSG_PUB.Add;
4190:

Line 4187: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_vend_msg_data);

4183: l_vend_msg_data := substrb(l_authresult_rec.PaymentSys_Code || ': '||
4184: l_authresult_rec.PaymentSys_Msg , 1, 240 );
4185:
4186: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4187: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_vend_msg_data);
4188:
4189: FND_MSG_PUB.Add;
4190:
4191: END IF;

Line 4283: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_AUTHFAILURE');

4279:
4280: IF (ls_return_status <> FND_API.G_RET_STS_SUCCESS)
4281: AND (NVL(p_called_from,'NONE') = 'IREC') then
4282:
4283: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_AUTHFAILURE');
4284: FND_MSG_PUB.Add;
4285: x_return_status := ls_return_status;
4286: RETURN;
4287:

Line 4291: FND_MESSAGE.set_name('AR', 'AR_CC_CAPTURE_FAILED');

4287:
4288: ELSIF (ls_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4289:
4290:
4291: FND_MESSAGE.set_name('AR', 'AR_CC_CAPTURE_FAILED');
4292: FND_MSG_PUB.Add;
4293:
4294: IF ls_response_rec.Result_Code is NOT NULL THEN
4295:

Line 4304: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

4300: ls_iby_msg_data := substrb( ls_response_rec.Result_Code || ': '||
4301: ls_response_rec.Result_Message , 1, 240);
4302:
4303: arp_standard.debug( 'ls_iby_msg_data: ' || ls_iby_msg_data);
4304: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4305: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',ls_iby_msg_data);
4306:
4307: FND_MSG_PUB.Add;
4308:

Line 4305: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',ls_iby_msg_data);

4301: ls_response_rec.Result_Message , 1, 240);
4302:
4303: arp_standard.debug( 'ls_iby_msg_data: ' || ls_iby_msg_data);
4304: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4305: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',ls_iby_msg_data);
4306:
4307: FND_MSG_PUB.Add;
4308:
4309: END IF;

Line 4434: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

4430: arp_standard.debug ('p_receipt_date: '|| p_receipt_date);
4431:
4432: IF p_receipt_date NOT BETWEEN l_start_date AND NVL(l_end_date, to_date('31-12-4712','DD-MM-YYYY')) THEN
4433: arp_standard.debug ( 'Receipt date out of instrument assignment range. Receipt will not be created for this instrument.');
4434: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4435: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Instrument assignment date range out of bound.');
4436: FND_MSG_PUB.Add;
4437: x_return_status := FND_API.G_RET_STS_ERROR;
4438: RETURN;

Line 4435: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Instrument assignment date range out of bound.');

4431:
4432: IF p_receipt_date NOT BETWEEN l_start_date AND NVL(l_end_date, to_date('31-12-4712','DD-MM-YYYY')) THEN
4433: arp_standard.debug ( 'Receipt date out of instrument assignment range. Receipt will not be created for this instrument.');
4434: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4435: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Instrument assignment date range out of bound.');
4436: FND_MSG_PUB.Add;
4437: x_return_status := FND_API.G_RET_STS_ERROR;
4438: RETURN;
4439: ELSE

Line 4445: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

4441: END IF ;
4442:
4443: EXCEPTION WHEN NO_DATA_FOUND THEN
4444: arp_standard.debug ( 'No Data found while getting date range for instrument assignment '|| sqlerrm);
4445: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4446: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','No data range found for instrument assignment.');
4447: FND_MSG_PUB.Add;
4448: x_return_status := FND_API.G_RET_STS_ERROR;
4449: RETURN;

Line 4446: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','No data range found for instrument assignment.');

4442:
4443: EXCEPTION WHEN NO_DATA_FOUND THEN
4444: arp_standard.debug ( 'No Data found while getting date range for instrument assignment '|| sqlerrm);
4445: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4446: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','No data range found for instrument assignment.');
4447: FND_MSG_PUB.Add;
4448: x_return_status := FND_API.G_RET_STS_ERROR;
4449: RETURN;
4450: WHEN OTHERS THEN

Line 4452: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

4448: x_return_status := FND_API.G_RET_STS_ERROR;
4449: RETURN;
4450: WHEN OTHERS THEN
4451: arp_standard.debug ( 'Exception while getting date range for instrument assignment '|| sqlerrm);
4452: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4453: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error getting data range found for instrument assignment.');
4454: FND_MSG_PUB.Add;
4455: x_return_status := FND_API.G_RET_STS_ERROR;
4456: RETURN;

Line 4453: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error getting data range found for instrument assignment.');

4449: RETURN;
4450: WHEN OTHERS THEN
4451: arp_standard.debug ( 'Exception while getting date range for instrument assignment '|| sqlerrm);
4452: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4453: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error getting data range found for instrument assignment.');
4454: FND_MSG_PUB.Add;
4455: x_return_status := FND_API.G_RET_STS_ERROR;
4456: RETURN;
4457: END ;

Line 4528: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');

4524:
4525: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4526:
4527: arp_standard.debug('create_cash_127');
4528: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
4529: FND_MSG_PUB.Add;
4530:
4531: IF l_response_rec.result_Code is NOT NULL THEN
4532:

Line 4539: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

4535: l_cpy_msg_data := substrb( l_response_rec.Result_Code || ': '||
4536: l_response_rec.Result_Message , 1, 240);
4537:
4538: arp_standard.debug( 'l_cpy_msg_data: ' || l_cpy_msg_data);
4539: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4540: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_cpy_msg_data);
4541:
4542: FND_MSG_PUB.Add;
4543:

Line 4540: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_cpy_msg_data);

4536: l_response_rec.Result_Message , 1, 240);
4537:
4538: arp_standard.debug( 'l_cpy_msg_data: ' || l_cpy_msg_data);
4539: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4540: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_cpy_msg_data);
4541:
4542: FND_MSG_PUB.Add;
4543:
4544: END IF;

Line 4639: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

4635: arp_standard.debug ('p_receipt_date: '|| p_receipt_date);
4636:
4637: IF p_receipt_date NOT BETWEEN l_start_date AND NVL(l_end_date, to_date('31-12-4712','DD-MM-YYYY')) THEN
4638: arp_standard.debug ( 'Receipt date out of instrument assignment range. Receipt will not be created for this instrument.');
4639: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4640: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Instrument assignment date range out of bound.');
4641: FND_MSG_PUB.Add;
4642: x_return_status := FND_API.G_RET_STS_ERROR;
4643: RETURN;

Line 4640: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Instrument assignment date range out of bound.');

4636:
4637: IF p_receipt_date NOT BETWEEN l_start_date AND NVL(l_end_date, to_date('31-12-4712','DD-MM-YYYY')) THEN
4638: arp_standard.debug ( 'Receipt date out of instrument assignment range. Receipt will not be created for this instrument.');
4639: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4640: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Instrument assignment date range out of bound.');
4641: FND_MSG_PUB.Add;
4642: x_return_status := FND_API.G_RET_STS_ERROR;
4643: RETURN;
4644: ELSE

Line 4650: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

4646: END IF ;
4647:
4648: EXCEPTION WHEN NO_DATA_FOUND THEN
4649: arp_standard.debug ( 'No Data found while getting date range for instrument assignment '|| sqlerrm);
4650: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4651: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','No data range found for instrument assignment.');
4652: FND_MSG_PUB.Add;
4653: x_return_status := FND_API.G_RET_STS_ERROR;
4654: RETURN;

Line 4651: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','No data range found for instrument assignment.');

4647:
4648: EXCEPTION WHEN NO_DATA_FOUND THEN
4649: arp_standard.debug ( 'No Data found while getting date range for instrument assignment '|| sqlerrm);
4650: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4651: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','No data range found for instrument assignment.');
4652: FND_MSG_PUB.Add;
4653: x_return_status := FND_API.G_RET_STS_ERROR;
4654: RETURN;
4655: WHEN OTHERS THEN

Line 4657: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

4653: x_return_status := FND_API.G_RET_STS_ERROR;
4654: RETURN;
4655: WHEN OTHERS THEN
4656: arp_standard.debug ( 'Exception while getting date range for instrument assignment '|| sqlerrm);
4657: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4658: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error getting data range found for instrument assignment.');
4659: FND_MSG_PUB.Add;
4660: x_return_status := FND_API.G_RET_STS_ERROR;
4661: RETURN;

Line 4658: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error getting data range found for instrument assignment.');

4654: RETURN;
4655: WHEN OTHERS THEN
4656: arp_standard.debug ( 'Exception while getting date range for instrument assignment '|| sqlerrm);
4657: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4658: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error getting data range found for instrument assignment.');
4659: FND_MSG_PUB.Add;
4660: x_return_status := FND_API.G_RET_STS_ERROR;
4661: RETURN;
4662: END ;

Line 4935: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

4931: IF l_create_msg_count = 1 THEN
4932: /* If one message, like warning, then put this back on stack as the
4933: Create routine must have removed it from the stack and put it on x_msg_data
4934: */
4935: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4936: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||l_create_msg_data);
4937: FND_MSG_PUB.Add;
4938: END IF;
4939:

Line 4936: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||l_create_msg_data);

4932: /* If one message, like warning, then put this back on stack as the
4933: Create routine must have removed it from the stack and put it on x_msg_data
4934: */
4935: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4936: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||l_create_msg_data);
4937: FND_MSG_PUB.Add;
4938: END IF;
4939:
4940: Apply( p_api_version => p_api_version,

Line 5033: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

5029: IF PG_DEBUG in ('Y', 'C') THEN
5030: arp_util.debug('Exception : Create_and_apply() ');
5031: END IF;
5032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5033: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5034: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||SQLERRM);
5035: FND_MSG_PUB.Add;
5036: END Create_and_apply;
5037:

Line 5034: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||SQLERRM);

5030: arp_util.debug('Exception : Create_and_apply() ');
5031: END IF;
5032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5033: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5034: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||SQLERRM);
5035: FND_MSG_PUB.Add;
5036: END Create_and_apply;
5037:
5038: /*=======================================================================

Line 5336: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

5332: ---If one message, like warning, then put this back
5333: ---on stack as the Create routine must have removed
5334: ---it from the stack and put it on x_msg_data
5335:
5336: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5337: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||l_create_msg_data);
5338: FND_MSG_PUB.Add;
5339: END IF;
5340:

Line 5337: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||l_create_msg_data);

5333: ---on stack as the Create routine must have removed
5334: ---it from the stack and put it on x_msg_data
5335:
5336: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5337: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||l_create_msg_data);
5338: FND_MSG_PUB.Add;
5339: END IF;
5340:
5341: /*------------------------------------------------------+

Line 5451: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

5447: arp_util.debug('Create_Apply_On_Acc: ' || 'Exception:'|| SQLERRM);
5448: END IF;
5449:
5450: x_return_status := FND_API.G_RET_STS_ERROR ;
5451: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5452: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_RECEIPT_API_PUB.Create_Apply_On_Acc:'|| SQLERRM);
5453: FND_MSG_PUB.Add;
5454: ROLLBACK TO Create_Apply_On_Acc;
5455: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 5452: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_RECEIPT_API_PUB.Create_Apply_On_Acc:'|| SQLERRM);

5448: END IF;
5449:
5450: x_return_status := FND_API.G_RET_STS_ERROR ;
5451: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5452: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_RECEIPT_API_PUB.Create_Apply_On_Acc:'|| SQLERRM);
5453: FND_MSG_PUB.Add;
5454: ROLLBACK TO Create_Apply_On_Acc;
5455: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5456: p_count => x_msg_count,

Line 5562: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

5558: IF (SQLCODE = -20001)
5559: THEN
5560:
5561: p_return_status := FND_API.G_RET_STS_ERROR ;
5562: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5563: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_REVERSE_RECEIPT.REVERSE : '||SQLERRM);
5564: FND_MSG_PUB.Add;
5565:
5566: RETURN;

Line 5563: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_REVERSE_RECEIPT.REVERSE : '||SQLERRM);

5559: THEN
5560:
5561: p_return_status := FND_API.G_RET_STS_ERROR ;
5562: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5563: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_REVERSE_RECEIPT.REVERSE : '||SQLERRM);
5564: FND_MSG_PUB.Add;
5565:
5566: RETURN;
5567: ELSE

Line 5784: FND_MESSAGE.SET_NAME('AR','AR_RAPI_NON_REVERSIBLE');

5780: IF l_std_reversal_possible <> 'Y' THEN
5781: IF PG_DEBUG in ('Y', 'C') THEN
5782: arp_util.debug('Apply: ' || 'Standard reversal not possible for this receipt');
5783: END IF;
5784: FND_MESSAGE.SET_NAME('AR','AR_RAPI_NON_REVERSIBLE');
5785: FND_MSG_PUB.Add;
5786: l_rev_return_status := FND_API.G_RET_STS_ERROR;
5787: END IF;
5788:

Line 5810: FND_MESSAGE.SET_NAME('AR','AR_IBY_SETTLEMENT_PENDING');

5806: IF l_trxn_extn_id is not null THEN
5807: IF arp_reverse_receipt.check_settlement_status(
5808: p_extension_id => l_trxn_extn_id)
5809: THEN
5810: FND_MESSAGE.SET_NAME('AR','AR_IBY_SETTLEMENT_PENDING');
5811: FND_MSG_PUB.ADD;
5812: l_pend_settlment_status:= FND_API.G_RET_STS_ERROR;
5813: END IF;
5814: END IF;

Line 5820: FND_MESSAGE.SET_NAME('AR','AR_RW_NO_REVERSAL_WITH_CLAIMS');

5816: IF arp_reverse_receipt.receipt_has_non_cancel_claims(
5817: p_cr_id => p_cash_receipt_id,
5818: p_include_trx_claims => 'Y')
5819: THEN
5820: FND_MESSAGE.SET_NAME('AR','AR_RW_NO_REVERSAL_WITH_CLAIMS');
5821: FND_MSG_PUB.Add;
5822: l_clm_return_status := FND_API.G_RET_STS_ERROR;
5823: ELSE
5824: arp_reverse_receipt.cancel_claims(

Line 6180: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

6176: ROLLBACK TO Reverse_PVT;
6177:
6178:
6179: x_return_status := FND_API.G_RET_STS_ERROR ;
6180: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6181: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','REVERSE : '||SQLERRM);
6182: FND_MSG_PUB.Add;
6183:
6184: --If only one error message on the stack,

Line 6181: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','REVERSE : '||SQLERRM);

6177:
6178:
6179: x_return_status := FND_API.G_RET_STS_ERROR ;
6180: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6181: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','REVERSE : '||SQLERRM);
6182: FND_MSG_PUB.Add;
6183:
6184: --If only one error message on the stack,
6185: --retrive it

Line 6195: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

6191: RETURN;
6192:
6193: ELSE
6194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6195: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6196: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','REVERSE : '||SQLERRM);
6197: FND_MSG_PUB.Add;
6198: END IF;
6199:

Line 6196: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','REVERSE : '||SQLERRM);

6192:
6193: ELSE
6194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6195: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6196: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','REVERSE : '||SQLERRM);
6197: FND_MSG_PUB.Add;
6198: END IF;
6199:
6200: IF PG_DEBUG in ('Y', 'C') THEN

Line 6530: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

6526:
6527: -- Display_Parameters
6528:
6529: x_return_status := FND_API.G_RET_STS_ERROR ;
6530: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6531: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.ON_ACCOUNT_RECEIPTS : '||SQLERRM);
6532: FND_MSG_PUB.Add;
6533:
6534: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 6531: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.ON_ACCOUNT_RECEIPTS : '||SQLERRM);

6527: -- Display_Parameters
6528:
6529: x_return_status := FND_API.G_RET_STS_ERROR ;
6530: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6531: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.ON_ACCOUNT_RECEIPTS : '||SQLERRM);
6532: FND_MSG_PUB.Add;
6533:
6534: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
6535: p_count => x_msg_count,

Line 6607: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

6603: --If only one error message on the stack,
6604: --retrive it
6605:
6606: x_return_status := FND_API.G_RET_STS_ERROR ;
6607: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6608: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_ON_ACCOUNT : '||SQLERRM);
6609: FND_MSG_PUB.Add;
6610:
6611: --If only one error message on the stack,

Line 6608: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_ON_ACCOUNT : '||SQLERRM);

6604: --retrive it
6605:
6606: x_return_status := FND_API.G_RET_STS_ERROR ;
6607: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6608: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_ON_ACCOUNT : '||SQLERRM);
6609: FND_MSG_PUB.Add;
6610:
6611: --If only one error message on the stack,
6612: --retrive it

Line 6622: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

6618: RETURN;
6619:
6620: ELSE
6621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6622: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6623: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_ON_ACCOUNT : '||SQLERRM);
6624: FND_MSG_PUB.Add;
6625: END IF;
6626:

Line 6623: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_ON_ACCOUNT : '||SQLERRM);

6619:
6620: ELSE
6621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6622: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6623: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_ON_ACCOUNT : '||SQLERRM);
6624: FND_MSG_PUB.Add;
6625: END IF;
6626:
6627: IF PG_DEBUG in ('Y', 'C') THEN

Line 6837: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

6833: ROLLBACK TO Unapply_on_ac_PVT;
6834:
6835: -- Display_Parameters;
6836: x_return_status := FND_API.G_RET_STS_ERROR ;
6837: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6838: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
6839: FND_MSG_PUB.Add;
6840:
6841: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 6838: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);

6834:
6835: -- Display_Parameters;
6836: x_return_status := FND_API.G_RET_STS_ERROR ;
6837: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6838: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
6839: FND_MSG_PUB.Add;
6840:
6841: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
6842: p_count => x_msg_count,

Line 6918: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

6914: --If only one error message on the stack,
6915: --retrive it
6916:
6917: x_return_status := FND_API.G_RET_STS_ERROR ;
6918: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6919: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_ON_ACCOUNT : '||SQLERRM);
6920: FND_MSG_PUB.Add;
6921: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
6922: p_count => x_msg_count,

Line 6919: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_ON_ACCOUNT : '||SQLERRM);

6915: --retrive it
6916:
6917: x_return_status := FND_API.G_RET_STS_ERROR ;
6918: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6919: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_ON_ACCOUNT : '||SQLERRM);
6920: FND_MSG_PUB.Add;
6921: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
6922: p_count => x_msg_count,
6923: p_data => x_msg_data

Line 6930: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

6926: RETURN;
6927:
6928: ELSE
6929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6930: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6931: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_ON_ACCOUNT : '||SQLERRM);
6932: FND_MSG_PUB.Add;
6933: END IF;
6934:

Line 6931: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_ON_ACCOUNT : '||SQLERRM);

6927:
6928: ELSE
6929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6930: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6931: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_ON_ACCOUNT : '||SQLERRM);
6932: FND_MSG_PUB.Add;
6933: END IF;
6934:
6935: IF PG_DEBUG in ('Y', 'C') THEN

Line 7221: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

7217: ROLLBACK TO Unapply_other_ac_PVT;
7218:
7219: -- Display_Parameters;
7220: x_return_status := FND_API.G_RET_STS_ERROR ;
7221: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7222: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
7223: FND_MSG_PUB.Add;
7224:
7225: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 7222: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);

7218:
7219: -- Display_Parameters;
7220: x_return_status := FND_API.G_RET_STS_ERROR ;
7221: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7222: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
7223: FND_MSG_PUB.Add;
7224:
7225: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
7226: p_count => x_msg_count,

Line 7302: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

7298: --If only one error message on the stack,
7299: --retrive it
7300:
7301: x_return_status := FND_API.G_RET_STS_ERROR ;
7302: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7303: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_ON_ACCOUNT : '||SQLERRM);
7304: FND_MSG_PUB.Add;
7305: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7306: p_count => x_msg_count,

Line 7303: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_ON_ACCOUNT : '||SQLERRM);

7299: --retrive it
7300:
7301: x_return_status := FND_API.G_RET_STS_ERROR ;
7302: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7303: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_ON_ACCOUNT : '||SQLERRM);
7304: FND_MSG_PUB.Add;
7305: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7306: p_count => x_msg_count,
7307: p_data => x_msg_data

Line 7314: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

7310: RETURN;
7311:
7312: ELSE
7313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7314: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7315: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_OTHER_ACCOUNT : '||SQLERRM);
7316: FND_MSG_PUB.Add;
7317: END IF;
7318:

Line 7315: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_OTHER_ACCOUNT : '||SQLERRM);

7311:
7312: ELSE
7313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7314: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7315: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_OTHER_ACCOUNT : '||SQLERRM);
7316: FND_MSG_PUB.Add;
7317: END IF;
7318:
7319: IF PG_DEBUG in ('Y', 'C') THEN

Line 7684: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

7680: EXCEPTION
7681: WHEN OTHERS THEN
7682: l_pay_term_return_status := FND_API.G_RET_STS_ERROR ;
7683:
7684: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7685: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Invalid Payment Term');
7686: FND_MSG_PUB.Add;
7687:
7688: IF PG_DEBUG in ('Y', 'C') THEN

Line 7685: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Invalid Payment Term');

7681: WHEN OTHERS THEN
7682: l_pay_term_return_status := FND_API.G_RET_STS_ERROR ;
7683:
7684: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7685: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Invalid Payment Term');
7686: FND_MSG_PUB.Add;
7687:
7688: IF PG_DEBUG in ('Y', 'C') THEN
7689: arp_util.debug('Activity_application: ' || 'Invalid Payment Term. Rolling back and setting status to ERROR');

Line 7700: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

7696: IF p_payment_priority < 1 OR p_payment_priority > 99 THEN
7697:
7698: l_pay_priority_return_status := FND_API.G_RET_STS_ERROR ;
7699:
7700: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7701: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Payment Priority Not In Range(1-99)');
7702: FND_MSG_PUB.Add;
7703:
7704: IF PG_DEBUG in ('Y', 'C') THEN

Line 7701: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Payment Priority Not In Range(1-99)');

7697:
7698: l_pay_priority_return_status := FND_API.G_RET_STS_ERROR ;
7699:
7700: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7701: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Payment Priority Not In Range(1-99)');
7702: FND_MSG_PUB.Add;
7703:
7704: IF PG_DEBUG in ('Y', 'C') THEN
7705: arp_util.debug('Activity_application: ' || 'Payment Priority Not In Range(1-99). Rolling back and setting status to ERROR');

Line 7827: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

7823: ROLLBACK TO Activity_app_PVT;
7824:
7825: -- Display_Parameters;
7826: x_return_status := FND_API.G_RET_STS_ERROR ;
7827: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7828: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.ACTIVITY_APPLICATION : '||SQLERRM);
7829: FND_MSG_PUB.Add;
7830:
7831: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 7828: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.ACTIVITY_APPLICATION : '||SQLERRM);

7824:
7825: -- Display_Parameters;
7826: x_return_status := FND_API.G_RET_STS_ERROR ;
7827: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7828: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.ACTIVITY_APPLICATION : '||SQLERRM);
7829: FND_MSG_PUB.Add;
7830:
7831: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
7832: p_count => x_msg_count,

Line 7895: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

7891: ROLLBACK TO Activity_app_PVT;
7892:
7893: -- Display_Parameters;
7894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7895: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7896: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_REFUNDS_PVT.Create_Refund : '||SQLERRM);
7897: FND_MSG_PUB.Add;
7898:
7899: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 7896: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_REFUNDS_PVT.Create_Refund : '||SQLERRM);

7892:
7893: -- Display_Parameters;
7894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7895: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7896: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_REFUNDS_PVT.Create_Refund : '||SQLERRM);
7897: FND_MSG_PUB.Add;
7898:
7899: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
7900: p_count => x_msg_count,

Line 7978: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

7974: --If only one error message on the stack,
7975: --retrive it
7976:
7977: x_return_status := FND_API.G_RET_STS_ERROR ;
7978: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7979: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);
7980: FND_MSG_PUB.Add;
7981:
7982: --If only one error message on the stack,

Line 7979: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);

7975: --retrive it
7976:
7977: x_return_status := FND_API.G_RET_STS_ERROR ;
7978: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7979: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);
7980: FND_MSG_PUB.Add;
7981:
7982: --If only one error message on the stack,
7983: --retrive it

Line 7994: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

7990: RETURN;
7991:
7992: ELSE
7993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7994: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7995: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);
7996: FND_MSG_PUB.Add;
7997: END IF;
7998:

Line 7995: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);

7991:
7992: ELSE
7993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7994: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7995: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);
7996: FND_MSG_PUB.Add;
7997: END IF;
7998:
7999: IF PG_DEBUG in ('Y', 'C') THEN

Line 8240: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

8236: ROLLBACK TO Activity_unapplication_PVT;
8237:
8238: -- Display_Parameters;
8239: x_return_status := FND_API.G_RET_STS_ERROR ;
8240: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8241: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
8242: FND_MSG_PUB.Add;
8243:
8244: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 8241: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);

8237:
8238: -- Display_Parameters;
8239: x_return_status := FND_API.G_RET_STS_ERROR ;
8240: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8241: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
8242: FND_MSG_PUB.Add;
8243:
8244: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
8245: p_count => x_msg_count,

Line 8318: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

8314:
8315: ROLLBACK TO Activity_unapplication_PVT;
8316:
8317: x_return_status := FND_API.G_RET_STS_ERROR ;
8318: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8319: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);
8320: FND_MSG_PUB.Add;
8321:
8322: --If only one error message on the stack,

Line 8319: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);

8315: ROLLBACK TO Activity_unapplication_PVT;
8316:
8317: x_return_status := FND_API.G_RET_STS_ERROR ;
8318: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8319: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);
8320: FND_MSG_PUB.Add;
8321:
8322: --If only one error message on the stack,
8323: --retrive it

Line 8333: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

8329: RETURN;
8330:
8331: ELSE
8332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8333: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8334: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);
8335: FND_MSG_PUB.Add;
8336: END IF;
8337:

Line 8334: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);

8330:
8331: ELSE
8332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8333: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8334: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);
8335: FND_MSG_PUB.Add;
8336: END IF;
8337:
8338: IF PG_DEBUG in ('Y', 'C') THEN

Line 8746: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

8742:
8743: -- Display_Parameters
8744:
8745: x_return_status := FND_API.G_RET_STS_ERROR ;
8746: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8747: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.APPLY_OTHER_ACCOUNT : '||SQLERRM);
8748: FND_MSG_PUB.Add;
8749:
8750: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 8747: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.APPLY_OTHER_ACCOUNT : '||SQLERRM);

8743: -- Display_Parameters
8744:
8745: x_return_status := FND_API.G_RET_STS_ERROR ;
8746: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8747: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.APPLY_OTHER_ACCOUNT : '||SQLERRM);
8748: FND_MSG_PUB.Add;
8749:
8750: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
8751: p_count => x_msg_count,

Line 8815: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

8811: --If only one error message on the stack,
8812: --retrive it
8813:
8814: x_return_status := FND_API.G_RET_STS_ERROR ;
8815: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8816: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_OTHER_ACCOUNT : '||SQLERRM);
8817: FND_MSG_PUB.Add;
8818:
8819: --If only one error message on the stack,

Line 8816: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_OTHER_ACCOUNT : '||SQLERRM);

8812: --retrive it
8813:
8814: x_return_status := FND_API.G_RET_STS_ERROR ;
8815: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8816: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_OTHER_ACCOUNT : '||SQLERRM);
8817: FND_MSG_PUB.Add;
8818:
8819: --If only one error message on the stack,
8820: --retrive it

Line 8830: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

8826: RETURN;
8827:
8828: ELSE
8829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8830: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8831: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_OTHER_ACCOUNT : '||SQLERRM);
8832: FND_MSG_PUB.Add;
8833: END IF;
8834:

Line 8831: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_OTHER_ACCOUNT : '||SQLERRM);

8827:
8828: ELSE
8829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8830: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8831: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_OTHER_ACCOUNT : '||SQLERRM);
8832: FND_MSG_PUB.Add;
8833: END IF;
8834:
8835: arp_util.debug(SQLCODE, G_MSG_ERROR);

Line 9201: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_DFLT_DOC_SEQ');

9197: p_receipt_number := l_receipt_number;
9198: --warning message
9199: IF FND_MSG_PUB.Check_Msg_Level(G_MSG_SUCCESS)
9200: THEN
9201: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_DFLT_DOC_SEQ');
9202: FND_MSG_PUB.Add;
9203: END IF;
9204: ELSE
9205: IF PG_DEBUG in ('Y', 'C') THEN

Line 9209: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_NULL');

9205: IF PG_DEBUG in ('Y', 'C') THEN
9206: arp_util.debug('create_misc: ' || 'Receipt Number is null ');
9207: END IF;
9208: --raise error message
9209: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_NULL');
9210: FND_MSG_PUB.Add;
9211: x_return_status := FND_API.G_RET_STS_ERROR;
9212: END IF;
9213: END IF;

Line 9275: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');

9271: IF ( l_creation_method = 'A' and l_payment_trxn_extension_id is NULL) THEN
9272:
9273: arp_util.debug('Create_cash_122: ' || l_creation_method);
9274: arp_util.debug('Create_cash_122: ' || l_payment_trxn_extension_id );
9275: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
9276: FND_MSG_PUB.Add;
9277: x_return_status := FND_API.G_RET_STS_ERROR;
9278: END IF;
9279:

Line 9315: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');

9311: );
9312:
9313: IF l_copy_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9314: arp_util.debug('Create_cash_123: ' );
9315: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
9316: FND_MSG_PUB.Add;
9317: x_return_status := FND_API.G_RET_STS_ERROR;
9318: END IF;
9319: l_payment_trxn_extension_id := l_copy_pmt_trxn_extension_id;

Line 9494: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

9490: ROLLBACK TO Create_misc_PVT;
9491:
9492: -- Display_Parameters;
9493: x_return_status := FND_API.G_RET_STS_ERROR ;
9494: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
9495: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
9496: 'ARP_PROCESS_MISC_RECEIPTS.INSERT_MISC_RECEIPT : '||SQLERRM);
9497: FND_MSG_PUB.Add;
9498:

Line 9495: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',

9491:
9492: -- Display_Parameters;
9493: x_return_status := FND_API.G_RET_STS_ERROR ;
9494: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
9495: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
9496: 'ARP_PROCESS_MISC_RECEIPTS.INSERT_MISC_RECEIPT : '||SQLERRM);
9497: FND_MSG_PUB.Add;
9498:
9499: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 9594: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

9590: ROLLBACK TO Create_misc_PVT;
9591:
9592: -- Display_Parameters;
9593: x_return_status := FND_API.G_RET_STS_ERROR ;
9594: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
9595: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_MISC : '||SQLERRM);
9596: FND_MSG_PUB.Add;
9597:
9598: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 9595: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_MISC : '||SQLERRM);

9591:
9592: -- Display_Parameters;
9593: x_return_status := FND_API.G_RET_STS_ERROR ;
9594: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
9595: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_MISC : '||SQLERRM);
9596: FND_MSG_PUB.Add;
9597:
9598: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
9599: p_count => x_msg_count,

Line 9605: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

9601: );
9602: RETURN;
9603: ELSE
9604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9605: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
9606: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_MISC : '||SQLERRM);
9607: FND_MSG_PUB.Add;
9608: END IF;
9609:

Line 9606: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_MISC : '||SQLERRM);

9602: RETURN;
9603: ELSE
9604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9605: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
9606: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_MISC : '||SQLERRM);
9607: FND_MSG_PUB.Add;
9608: END IF;
9609:
9610: IF PG_DEBUG in ('Y', 'C') THEN

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

10139: arp_util.debug('Apply_Open_Receipt: error updating applications ' || SQLERRM);
10140: arp_util.debug('Apply_Open_Receipt: l_net_rec_app_id = ' || l_net_rec_app_id);
10141: arp_util.debug('Apply_Open_Receipt: l_open_net_rec_app_id = ' || l_open_net_rec_app_id);
10142: END IF;
10143: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_INVALID');
10144: FND_MSG_PUB.Add;
10145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10146: END IF;
10147:

Line 10254: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

10250: --If only one error message on the stack,
10251: --retrive it
10252:
10253: x_return_status := FND_API.G_RET_STS_ERROR ;
10254: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
10255: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_Open_Receipt : '||SQLERRM);
10256: FND_MSG_PUB.Add;
10257:
10258: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 10255: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_Open_Receipt : '||SQLERRM);

10251: --retrive it
10252:
10253: x_return_status := FND_API.G_RET_STS_ERROR ;
10254: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
10255: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_Open_Receipt : '||SQLERRM);
10256: FND_MSG_PUB.Add;
10257:
10258: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
10259: p_count => x_msg_count,

Line 10267: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

10263: RETURN;
10264:
10265: ELSE
10266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10267: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
10268: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_Open_Receipt : '||SQLERRM);
10269: FND_MSG_PUB.Add;
10270: END IF;
10271:

Line 10268: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_Open_Receipt : '||SQLERRM);

10264:
10265: ELSE
10266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10267: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
10268: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_Open_Receipt : '||SQLERRM);
10269: FND_MSG_PUB.Add;
10270: END IF;
10271:
10272: IF PG_DEBUG in ('Y', 'C') THEN

Line 10538: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

10534: --If only one error message on the stack,
10535: --retrive it
10536:
10537: x_return_status := FND_API.G_RET_STS_ERROR ;
10538: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
10539: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UnaPPLY_Open_Receipt : '||SQLERRM);
10540: FND_MSG_PUB.Add;
10541:
10542: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 10539: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UnaPPLY_Open_Receipt : '||SQLERRM);

10535: --retrive it
10536:
10537: x_return_status := FND_API.G_RET_STS_ERROR ;
10538: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
10539: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UnaPPLY_Open_Receipt : '||SQLERRM);
10540: FND_MSG_PUB.Add;
10541:
10542: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
10543: p_count => x_msg_count,

Line 10551: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

10547: RETURN;
10548:
10549: ELSE
10550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10551: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
10552: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UnaPPLY_Open_Receipt : '||SQLERRM);
10553: FND_MSG_PUB.Add;
10554: END IF;
10555:

Line 10552: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UnaPPLY_Open_Receipt : '||SQLERRM);

10548:
10549: ELSE
10550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10551: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
10552: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UnaPPLY_Open_Receipt : '||SQLERRM);
10553: FND_MSG_PUB.Add;
10554: END IF;
10555:
10556: IF PG_DEBUG in ('Y', 'C') THEN

Line 10735: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');

10731: l_request_id_bulk := l_request_id;
10732: END IF;
10733: IF nvl(p_called_from,'X') <> 'SUBMIT_OFFLINE' THEN
10734:
10735: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
10736: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','API called with wrong parameters. Call is not internal');
10737: FND_MSG_PUB.Add;
10738: x_return_status := FND_API.G_RET_STS_ERROR;
10739: return;

Line 10736: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','API called with wrong parameters. Call is not internal');

10732: END IF;
10733: IF nvl(p_called_from,'X') <> 'SUBMIT_OFFLINE' THEN
10734:
10735: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
10736: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','API called with wrong parameters. Call is not internal');
10737: FND_MSG_PUB.Add;
10738: x_return_status := FND_API.G_RET_STS_ERROR;
10739: return;
10740: END IF;

Line 10922: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');

10918: THEN
10919: l_crh_upd.reversal_gl_date(i) := l_default_gl_date;
10920: ELSE
10921: /*
10922: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
10923: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', l_error_message);
10924: FND_MSG_PUB.Add;
10925: x_return_status := FND_API.G_RET_STS_ERROR;
10926: EXIT;

Line 10923: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', l_error_message);

10919: l_crh_upd.reversal_gl_date(i) := l_default_gl_date;
10920: ELSE
10921: /*
10922: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
10923: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', l_error_message);
10924: FND_MSG_PUB.Add;
10925: x_return_status := FND_API.G_RET_STS_ERROR;
10926: EXIT;
10927: */

Line 11305: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');

11301: END IF;
11302:
11303: ROLLBACK TO Reverse_Rem_PVT;
11304: l_error_message := 'Unexpected Error: ' || substr(1,100,sqlerrm);
11305: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
11306: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', l_error_message);
11307: FND_MSG_PUB.Add;
11308: x_return_status := FND_API.G_RET_STS_ERROR;
11309: x_msg_data := substr(1,2000,sqlerrm);

Line 11306: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', l_error_message);

11302:
11303: ROLLBACK TO Reverse_Rem_PVT;
11304: l_error_message := 'Unexpected Error: ' || substr(1,100,sqlerrm);
11305: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
11306: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', l_error_message);
11307: FND_MSG_PUB.Add;
11308: x_return_status := FND_API.G_RET_STS_ERROR;
11309: x_msg_data := substr(1,2000,sqlerrm);
11310: END Reverse_Remittances_in_err;

Line 12031: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_ID_INVALID');

12027: and cust_acct.cust_account_id = l_customer_id
12028: and cust_acct.status = 'A' ;
12029: EXCEPTION
12030: WHEN no_data_found THEN
12031: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_ID_INVALID');
12032: FND_MSG_PUB.Add;
12033: RAISE FND_API.G_EXC_ERROR;
12034: END;
12035: ELSIF ( l_pay_unrel_inv_flag = 'N')

Line 12066: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_ID_INVALID');

12062: AND effective_end_date
12063: );
12064: EXCEPTION
12065: WHEN no_data_found THEN
12066: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_ID_INVALID');
12067: FND_MSG_PUB.Add;
12068: RAISE FND_API.G_EXC_ERROR;
12069: END;
12070: END IF;

Line 12095: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_STE_USE_ID_INVALID');

12091: AND site_uses.site_use_id=l_location;
12092:
12093: EXCEPTION
12094: WHEN no_data_found THEN
12095: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_STE_USE_ID_INVALID');
12096: FND_MSG_PUB.Add;
12097: RAISE FND_API.G_EXC_ERROR;
12098: END;
12099:

Line 12169: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

12165: --If only one error message on the stack,
12166: --retrive it
12167:
12168: x_return_status := FND_API.G_RET_STS_ERROR ;
12169: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
12170: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Change_customer: '||SQLERRM);
12171: FND_MSG_PUB.Add;
12172:
12173: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 12170: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Change_customer: '||SQLERRM);

12166: --retrive it
12167:
12168: x_return_status := FND_API.G_RET_STS_ERROR ;
12169: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
12170: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Change_customer: '||SQLERRM);
12171: FND_MSG_PUB.Add;
12172:
12173: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
12174: p_count => x_msg_count,

Line 12180: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

12176: );
12177: RETURN;
12178: ELSE
12179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12180: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
12181: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Change_customer : '||SQLERRM);
12182: FND_MSG_PUB.Add;
12183: END IF;
12184:

Line 12181: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Change_customer : '||SQLERRM);

12177: RETURN;
12178: ELSE
12179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12180: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
12181: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Change_customer : '||SQLERRM);
12182: FND_MSG_PUB.Add;
12183: END IF;
12184:
12185: IF PG_DEBUG in ('Y', 'C') THEN