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_RECEIPT_API_PUB dependencies on FND_MESSAGE

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

530: l_receipt_number := l_doc_sequence_value;
531: --warning message
532: IF FND_MSG_PUB.Check_Msg_Level(G_MSG_SUCCESS)
533: THEN
534: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_DFLT_DOC_SEQ');
535: FND_MSG_PUB.Add;
536: END IF;
537: ELSE
538: IF PG_DEBUG in ('Y', 'C') THEN

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

538: IF PG_DEBUG in ('Y', 'C') THEN
539: arp_util.debug('Create_cash_1: ' || 'Receipt Number is null ');
540: END IF;
541: --raise error message
542: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_NULL');
543: FND_MSG_PUB.Add;
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: END IF;
546: END IF;

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

579: IF ( l_creation_method = 'A' and l_payment_trxn_extension_id is NULL) THEN
580:
581: arp_util.debug('Create_cash_122: ' || l_creation_method_code);
582: arp_util.debug('Create_cash_122: ' || l_payment_trxn_extension_id );
583: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
584: FND_MSG_PUB.Add;
585: x_return_status := FND_API.G_RET_STS_ERROR;
586: END IF;
587:

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

610: );
611:
612: IF l_copy_return_status <> FND_API.G_RET_STS_SUCCESS THEN
613: arp_util.debug('Create_cash_123: ' );
614: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
615: FND_MSG_PUB.Add;
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: END IF;
618:

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

641: );
642:
643: IF l_create_return_status <> FND_API.G_RET_STS_SUCCESS THEN
644: arp_util.debug('Create_cash_123: ' );
645: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
646: FND_MSG_PUB.Add;
647: x_return_status := FND_API.G_RET_STS_ERROR;
648: END IF;
649:

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

810: ROLLBACK TO Create_Cash_PVT;
811:
812: -- Display_Parameters;
813: x_return_status := FND_API.G_RET_STS_ERROR ;
814: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
815: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROC_RECEIPTS2.INSERT_CASH_RECEIPT : '||SQLERRM);
816: FND_MSG_PUB.Add;
817:
818: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

811:
812: -- Display_Parameters;
813: x_return_status := FND_API.G_RET_STS_ERROR ;
814: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
815: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROC_RECEIPTS2.INSERT_CASH_RECEIPT : '||SQLERRM);
816: FND_MSG_PUB.Add;
817:
818: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
819: p_count => x_msg_count,

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

906: ROLLBACK TO Create_Cash_PVT;
907:
908: -- Display_Parameters;
909: x_return_status := FND_API.G_RET_STS_ERROR ;
910: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
911: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_CASH : '||SQLERRM);
912: FND_MSG_PUB.Add;
913:
914: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

907:
908: -- Display_Parameters;
909: x_return_status := FND_API.G_RET_STS_ERROR ;
910: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
911: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_CASH : '||SQLERRM);
912: FND_MSG_PUB.Add;
913:
914: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
915: p_count => x_msg_count,

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

917: );
918: RETURN;
919: ELSE
920: x_return_status := FND_API.G_RET_STS_UNEXP_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: END IF;
925:

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

918: RETURN;
919: ELSE
920: x_return_status := FND_API.G_RET_STS_UNEXP_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: END IF;
925:
926: IF PG_DEBUG in ('Y', 'C') THEN

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

1703: ROLLBACK TO Apply_PVT;
1704:
1705: -- Display_Parameters;
1706: x_return_status := FND_API.G_RET_STS_ERROR ;
1707: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1708: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.RECEIPT_APPLICATION '||SQLERRM);
1709: FND_MSG_PUB.Add;
1710:
1711: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

1704:
1705: -- Display_Parameters;
1706: x_return_status := FND_API.G_RET_STS_ERROR ;
1707: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1708: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.RECEIPT_APPLICATION '||SQLERRM);
1709: FND_MSG_PUB.Add;
1710:
1711: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1712: p_count => x_msg_count,

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

1822: --If only one error message on the stack,
1823: --retrive it
1824:
1825: x_return_status := FND_API.G_RET_STS_ERROR ;
1826: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1827: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
1828: FND_MSG_PUB.Add;
1829:
1830: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

1823: --retrive it
1824:
1825: x_return_status := FND_API.G_RET_STS_ERROR ;
1826: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1827: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
1828: FND_MSG_PUB.Add;
1829:
1830: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1831: p_count => x_msg_count,

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

1835: RETURN;
1836:
1837: ELSE
1838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1839: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1840: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
1841: FND_MSG_PUB.Add;
1842: END IF;
1843:

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

1836:
1837: ELSE
1838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1839: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1840: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
1841: FND_MSG_PUB.Add;
1842: END IF;
1843:
1844: IF PG_DEBUG in ('Y', 'C') THEN

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

2689: ROLLBACK TO Apply_In_Detail_PVT;
2690:
2691: -- Display_Parameters;
2692: x_return_status := FND_API.G_RET_STS_ERROR ;
2693: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2694: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.RECEIPT_APPLICATION '||SQLERRM);
2695: FND_MSG_PUB.Add;
2696:
2697: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

2690:
2691: -- Display_Parameters;
2692: x_return_status := FND_API.G_RET_STS_ERROR ;
2693: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2694: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.RECEIPT_APPLICATION '||SQLERRM);
2695: FND_MSG_PUB.Add;
2696:
2697: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2698: p_count => x_msg_count,

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

2826: --If only one error message on the stack,
2827: --retrive it
2828:
2829: x_return_status := FND_API.G_RET_STS_ERROR ;
2830: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2831: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
2832: FND_MSG_PUB.Add;
2833:
2834: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

2827: --retrive it
2828:
2829: x_return_status := FND_API.G_RET_STS_ERROR ;
2830: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2831: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
2832: FND_MSG_PUB.Add;
2833:
2834: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2835: p_count => x_msg_count,

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

2839: RETURN;
2840:
2841: ELSE
2842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2843: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2844: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
2845: FND_MSG_PUB.Add;
2846: END IF;
2847:

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

2840:
2841: ELSE
2842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2843: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2844: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
2845: FND_MSG_PUB.Add;
2846: END IF;
2847:
2848: IF PG_DEBUG in ('Y', 'C') THEN

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

3242: ROLLBACK TO Unapply_PVT;
3243:
3244: -- Display_Parameters;
3245: x_return_status := FND_API.G_RET_STS_ERROR ;
3246: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
3247: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
3248: FND_MSG_PUB.Add;
3249:
3250: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

3243:
3244: -- Display_Parameters;
3245: x_return_status := FND_API.G_RET_STS_ERROR ;
3246: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
3247: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
3248: FND_MSG_PUB.Add;
3249:
3250: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
3251: p_count => x_msg_count,

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

3320:
3321: ROLLBACK TO Unapply_PVT;
3322:
3323: x_return_status := FND_API.G_RET_STS_ERROR ;
3324: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
3325: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY : '||SQLERRM);
3326: FND_MSG_PUB.Add;
3327:
3328: --If only one error message on the stack,

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

3321: ROLLBACK TO Unapply_PVT;
3322:
3323: x_return_status := FND_API.G_RET_STS_ERROR ;
3324: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
3325: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY : '||SQLERRM);
3326: FND_MSG_PUB.Add;
3327:
3328: --If only one error message on the stack,
3329: --retrive it

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

3336: RETURN;
3337:
3338: ELSE
3339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3340: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
3341: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY : '||SQLERRM);
3342: FND_MSG_PUB.Add;
3343: END IF;
3344:

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

3337:
3338: ELSE
3339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3340: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
3341: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY : '||SQLERRM);
3342: FND_MSG_PUB.Add;
3343: END IF;
3344:
3345: IF PG_DEBUG in ('Y', 'C') THEN

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

3478: IF PG_DEBUG in ('Y', 'C') THEN
3479: arp_standard.debug('Apply: ' || 'ERROR: Creation status is ' || rct_info.creation_status);
3480: END IF;
3481:
3482: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_INVALID_STATUS');
3483: FND_MSG_PUB.Add;
3484:
3485: x_return_status := FND_API.G_RET_STS_ERROR; -- should never happen
3486: RETURN;

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

3617:
3618: if (l_return_status <> FND_API.G_RET_STS_SUCCESS)
3619: AND (NVL(p_called_from,'NONE') = 'IREC') then
3620:
3621: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_AUTHFAILURE');
3622: FND_MSG_PUB.Add;
3623: x_return_status := l_return_status;
3624: RETURN;
3625: elsif (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

3624: RETURN;
3625: elsif (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3626: --bug 3398538
3627: arp_util.debug('Create_cash_124: ');
3628: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
3629: FND_MSG_PUB.Add;
3630: x_return_status := l_return_status;
3631: RETURN;
3632: end if;

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

3727: --Add message to message stack only it it is called from iReceivables
3728: --if not pass the message stack received from iPayment
3729:
3730: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) AND (NVL(p_called_from,'NONE') = 'IREC') then
3731: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_CAPTFAILURE');
3732: FND_MSG_PUB.Add;
3733: --bug 3398538
3734: elsif (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3735: FND_MESSAGE.set_name('AR', 'AR_CC_CAPTURE_FAILED');

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

3731: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_CAPTFAILURE');
3732: FND_MSG_PUB.Add;
3733: --bug 3398538
3734: elsif (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3735: FND_MESSAGE.set_name('AR', 'AR_CC_CAPTURE_FAILED');
3736: FND_MSG_PUB.Add;
3737: end if;
3738: x_return_status := l_return_status;
3739:

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

3863: IF PG_DEBUG in ('Y', 'C') THEN
3864: arp_standard.debug('Apply: ' || 'ERROR: Creation status is ' || rct_info.creation_status);
3865: END IF;
3866:
3867: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_INVALID_STATUS');
3868: FND_MSG_PUB.Add;
3869:
3870: x_return_status := FND_API.G_RET_STS_ERROR; -- should never happen
3871: RETURN;

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

4083:
4084: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
4085: AND (NVL(p_called_from,'NONE') = 'IREC') then
4086:
4087: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_AUTHFAILURE');
4088: FND_MSG_PUB.Add;
4089: x_return_status := l_return_status;
4090: RETURN;
4091:

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

4091:
4092: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4093:
4094: arp_standard.debug('create_cash_126');
4095: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
4096: FND_MSG_PUB.Add;
4097:
4098: IF l_response_rec.Result_Code is NOT NULL THEN
4099:

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

4102: l_iby_msg_data := substrb( l_response_rec.Result_Code || ': '||
4103: l_response_rec.Result_Message , 1, 240);
4104:
4105: arp_standard.debug( 'l_iby_msg_data: ' || l_iby_msg_data);
4106: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4107: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_iby_msg_data);
4108:
4109: FND_MSG_PUB.Add;
4110:

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

4103: l_response_rec.Result_Message , 1, 240);
4104:
4105: arp_standard.debug( 'l_iby_msg_data: ' || l_iby_msg_data);
4106: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4107: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_iby_msg_data);
4108:
4109: FND_MSG_PUB.Add;
4110:
4111: END IF;

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

4116:
4117: l_vend_msg_data := substrb(l_authresult_rec.PaymentSys_Code || ': '||
4118: l_authresult_rec.PaymentSys_Msg , 1, 240 );
4119:
4120: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4121: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_vend_msg_data);
4122:
4123: FND_MSG_PUB.Add;
4124:

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

4117: l_vend_msg_data := substrb(l_authresult_rec.PaymentSys_Code || ': '||
4118: l_authresult_rec.PaymentSys_Msg , 1, 240 );
4119:
4120: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4121: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_vend_msg_data);
4122:
4123: FND_MSG_PUB.Add;
4124:
4125: END IF;

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

4213:
4214: IF (ls_return_status <> FND_API.G_RET_STS_SUCCESS)
4215: AND (NVL(p_called_from,'NONE') = 'IREC') then
4216:
4217: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_AUTHFAILURE');
4218: FND_MSG_PUB.Add;
4219: x_return_status := ls_return_status;
4220: RETURN;
4221:

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

4221:
4222: ELSIF (ls_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4223:
4224:
4225: FND_MESSAGE.set_name('AR', 'AR_CC_CAPTURE_FAILED');
4226: FND_MSG_PUB.Add;
4227:
4228: IF ls_response_rec.Result_Code is NOT NULL THEN
4229:

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

4232: ls_iby_msg_data := substrb( ls_response_rec.Result_Code || ': '||
4233: ls_response_rec.Result_Message , 1, 240);
4234:
4235: arp_standard.debug( 'ls_iby_msg_data: ' || ls_iby_msg_data);
4236: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4237: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',ls_iby_msg_data);
4238:
4239: FND_MSG_PUB.Add;
4240:

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

4233: ls_response_rec.Result_Message , 1, 240);
4234:
4235: arp_standard.debug( 'ls_iby_msg_data: ' || ls_iby_msg_data);
4236: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4237: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',ls_iby_msg_data);
4238:
4239: FND_MSG_PUB.Add;
4240:
4241: END IF;

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

4398:
4399: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4400:
4401: arp_standard.debug('create_cash_127');
4402: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
4403: FND_MSG_PUB.Add;
4404:
4405: IF l_response_rec.result_Code is NOT NULL THEN
4406:

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

4409: l_cpy_msg_data := substrb( l_response_rec.Result_Code || ': '||
4410: l_response_rec.Result_Message , 1, 240);
4411:
4412: arp_standard.debug( 'l_cpy_msg_data: ' || l_cpy_msg_data);
4413: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4414: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_cpy_msg_data);
4415:
4416: FND_MSG_PUB.Add;
4417:

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

4410: l_response_rec.Result_Message , 1, 240);
4411:
4412: arp_standard.debug( 'l_cpy_msg_data: ' || l_cpy_msg_data);
4413: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4414: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_cpy_msg_data);
4415:
4416: FND_MSG_PUB.Add;
4417:
4418: END IF;

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

4758: IF l_create_msg_count = 1 THEN
4759: /* If one message, like warning, then put this back on stack as the
4760: Create routine must have removed it from the stack and put it on x_msg_data
4761: */
4762: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4763: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||l_create_msg_data);
4764: FND_MSG_PUB.Add;
4765: END IF;
4766:

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

4759: /* If one message, like warning, then put this back on stack as the
4760: Create routine must have removed it from the stack and put it on x_msg_data
4761: */
4762: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4763: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||l_create_msg_data);
4764: FND_MSG_PUB.Add;
4765: END IF;
4766:
4767: Apply( p_api_version => p_api_version,

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

4856: IF PG_DEBUG in ('Y', 'C') THEN
4857: arp_util.debug('Exception : Create_and_apply() ');
4858: END IF;
4859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4860: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4861: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||SQLERRM);
4862: FND_MSG_PUB.Add;
4863: END Create_and_apply;
4864:

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

4857: arp_util.debug('Exception : Create_and_apply() ');
4858: END IF;
4859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4860: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4861: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||SQLERRM);
4862: FND_MSG_PUB.Add;
4863: END Create_and_apply;
4864:
4865: /*=======================================================================

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

5159: ---If one message, like warning, then put this back
5160: ---on stack as the Create routine must have removed
5161: ---it from the stack and put it on x_msg_data
5162:
5163: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5164: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||l_create_msg_data);
5165: FND_MSG_PUB.Add;
5166: END IF;
5167:

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

5160: ---on stack as the Create routine must have removed
5161: ---it from the stack and put it on x_msg_data
5162:
5163: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5164: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||l_create_msg_data);
5165: FND_MSG_PUB.Add;
5166: END IF;
5167:
5168: /*------------------------------------------------------+

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

5274: arp_util.debug('Create_Apply_On_Acc: ' || 'Exception:'|| SQLERRM);
5275: END IF;
5276:
5277: x_return_status := FND_API.G_RET_STS_ERROR ;
5278: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5279: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_RECEIPT_API_PUB.Create_Apply_On_Acc:'|| SQLERRM);
5280: FND_MSG_PUB.Add;
5281: ROLLBACK TO Create_Apply_On_Acc;
5282: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

5275: END IF;
5276:
5277: x_return_status := FND_API.G_RET_STS_ERROR ;
5278: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5279: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_RECEIPT_API_PUB.Create_Apply_On_Acc:'|| SQLERRM);
5280: FND_MSG_PUB.Add;
5281: ROLLBACK TO Create_Apply_On_Acc;
5282: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5283: p_count => x_msg_count,

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

5379: IF (SQLCODE = -20001)
5380: THEN
5381:
5382: p_return_status := FND_API.G_RET_STS_ERROR ;
5383: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5384: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_REVERSE_RECEIPT.REVERSE : '||SQLERRM);
5385: FND_MSG_PUB.Add;
5386:
5387: RETURN;

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

5380: THEN
5381:
5382: p_return_status := FND_API.G_RET_STS_ERROR ;
5383: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5384: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_REVERSE_RECEIPT.REVERSE : '||SQLERRM);
5385: FND_MSG_PUB.Add;
5386:
5387: RETURN;
5388: ELSE

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

5593: IF l_std_reversal_possible <> 'Y' THEN
5594: IF PG_DEBUG in ('Y', 'C') THEN
5595: arp_util.debug('Apply: ' || 'Standard reversal not possible for this receipt');
5596: END IF;
5597: FND_MESSAGE.SET_NAME('AR','AR_RAPI_NON_REVERSIBLE');
5598: FND_MSG_PUB.Add;
5599: l_rev_return_status := FND_API.G_RET_STS_ERROR;
5600: END IF;
5601:

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

5603: IF arp_reverse_receipt.receipt_has_non_cancel_claims(
5604: p_cr_id => p_cash_receipt_id,
5605: p_include_trx_claims => 'Y')
5606: THEN
5607: FND_MESSAGE.SET_NAME('AR','AR_RW_NO_REVERSAL_WITH_CLAIMS');
5608: FND_MSG_PUB.Add;
5609: l_clm_return_status := FND_API.G_RET_STS_ERROR;
5610: ELSE
5611: arp_reverse_receipt.cancel_claims(

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

5897: ROLLBACK TO Reverse_PVT;
5898:
5899:
5900: x_return_status := FND_API.G_RET_STS_ERROR ;
5901: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5902: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','REVERSE : '||SQLERRM);
5903: FND_MSG_PUB.Add;
5904:
5905: --If only one error message on the stack,

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

5898:
5899:
5900: x_return_status := FND_API.G_RET_STS_ERROR ;
5901: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5902: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','REVERSE : '||SQLERRM);
5903: FND_MSG_PUB.Add;
5904:
5905: --If only one error message on the stack,
5906: --retrive it

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

5912: RETURN;
5913:
5914: ELSE
5915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5916: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5917: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','REVERSE : '||SQLERRM);
5918: FND_MSG_PUB.Add;
5919: END IF;
5920:

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

5913:
5914: ELSE
5915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5916: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5917: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','REVERSE : '||SQLERRM);
5918: FND_MSG_PUB.Add;
5919: END IF;
5920:
5921: IF PG_DEBUG in ('Y', 'C') THEN

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

6247:
6248: -- Display_Parameters
6249:
6250: x_return_status := FND_API.G_RET_STS_ERROR ;
6251: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6252: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.ON_ACCOUNT_RECEIPTS : '||SQLERRM);
6253: FND_MSG_PUB.Add;
6254:
6255: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

6248: -- Display_Parameters
6249:
6250: x_return_status := FND_API.G_RET_STS_ERROR ;
6251: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6252: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.ON_ACCOUNT_RECEIPTS : '||SQLERRM);
6253: FND_MSG_PUB.Add;
6254:
6255: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
6256: p_count => x_msg_count,

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

6324: --If only one error message on the stack,
6325: --retrive it
6326:
6327: x_return_status := FND_API.G_RET_STS_ERROR ;
6328: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6329: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_ON_ACCOUNT : '||SQLERRM);
6330: FND_MSG_PUB.Add;
6331:
6332: --If only one error message on the stack,

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

6325: --retrive it
6326:
6327: x_return_status := FND_API.G_RET_STS_ERROR ;
6328: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6329: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_ON_ACCOUNT : '||SQLERRM);
6330: FND_MSG_PUB.Add;
6331:
6332: --If only one error message on the stack,
6333: --retrive it

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

6339: RETURN;
6340:
6341: ELSE
6342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6343: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6344: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_ON_ACCOUNT : '||SQLERRM);
6345: FND_MSG_PUB.Add;
6346: END IF;
6347:

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

6340:
6341: ELSE
6342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6343: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6344: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_ON_ACCOUNT : '||SQLERRM);
6345: FND_MSG_PUB.Add;
6346: END IF;
6347:
6348: IF PG_DEBUG in ('Y', 'C') THEN

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

6554: ROLLBACK TO Unapply_on_ac_PVT;
6555:
6556: -- Display_Parameters;
6557: x_return_status := FND_API.G_RET_STS_ERROR ;
6558: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6559: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
6560: FND_MSG_PUB.Add;
6561:
6562: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

6555:
6556: -- Display_Parameters;
6557: x_return_status := FND_API.G_RET_STS_ERROR ;
6558: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6559: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
6560: FND_MSG_PUB.Add;
6561:
6562: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
6563: p_count => x_msg_count,

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

6635: --If only one error message on the stack,
6636: --retrive it
6637:
6638: x_return_status := FND_API.G_RET_STS_ERROR ;
6639: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6640: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_ON_ACCOUNT : '||SQLERRM);
6641: FND_MSG_PUB.Add;
6642: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
6643: p_count => x_msg_count,

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

6636: --retrive it
6637:
6638: x_return_status := FND_API.G_RET_STS_ERROR ;
6639: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6640: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_ON_ACCOUNT : '||SQLERRM);
6641: FND_MSG_PUB.Add;
6642: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
6643: p_count => x_msg_count,
6644: p_data => x_msg_data

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

6647: RETURN;
6648:
6649: ELSE
6650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6651: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6652: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_ON_ACCOUNT : '||SQLERRM);
6653: FND_MSG_PUB.Add;
6654: END IF;
6655:

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

6648:
6649: ELSE
6650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6651: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6652: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_ON_ACCOUNT : '||SQLERRM);
6653: FND_MSG_PUB.Add;
6654: END IF;
6655:
6656: IF PG_DEBUG in ('Y', 'C') THEN

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

6926: ROLLBACK TO Unapply_other_ac_PVT;
6927:
6928: -- Display_Parameters;
6929: x_return_status := FND_API.G_RET_STS_ERROR ;
6930: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6931: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
6932: FND_MSG_PUB.Add;
6933:
6934: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

6927:
6928: -- Display_Parameters;
6929: x_return_status := FND_API.G_RET_STS_ERROR ;
6930: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
6931: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
6932: FND_MSG_PUB.Add;
6933:
6934: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
6935: p_count => x_msg_count,

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

7007: --If only one error message on the stack,
7008: --retrive it
7009:
7010: x_return_status := FND_API.G_RET_STS_ERROR ;
7011: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7012: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_ON_ACCOUNT : '||SQLERRM);
7013: FND_MSG_PUB.Add;
7014: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7015: p_count => x_msg_count,

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

7008: --retrive it
7009:
7010: x_return_status := FND_API.G_RET_STS_ERROR ;
7011: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7012: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_ON_ACCOUNT : '||SQLERRM);
7013: FND_MSG_PUB.Add;
7014: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7015: p_count => x_msg_count,
7016: p_data => x_msg_data

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

7019: RETURN;
7020:
7021: ELSE
7022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7023: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7024: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_OTHER_ACCOUNT : '||SQLERRM);
7025: FND_MSG_PUB.Add;
7026: END IF;
7027:

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

7020:
7021: ELSE
7022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7023: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7024: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY_OTHER_ACCOUNT : '||SQLERRM);
7025: FND_MSG_PUB.Add;
7026: END IF;
7027:
7028: IF PG_DEBUG in ('Y', 'C') THEN

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

7467: ROLLBACK TO Activity_app_PVT;
7468:
7469: -- Display_Parameters;
7470: x_return_status := FND_API.G_RET_STS_ERROR ;
7471: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7472: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.ACTIVITY_APPLICATION : '||SQLERRM);
7473: FND_MSG_PUB.Add;
7474:
7475: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

7468:
7469: -- Display_Parameters;
7470: x_return_status := FND_API.G_RET_STS_ERROR ;
7471: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7472: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.ACTIVITY_APPLICATION : '||SQLERRM);
7473: FND_MSG_PUB.Add;
7474:
7475: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
7476: p_count => x_msg_count,

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

7531: ROLLBACK TO Activity_app_PVT;
7532:
7533: -- Display_Parameters;
7534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7535: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7536: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_REFUNDS_PVT.Create_Refund : '||SQLERRM);
7537: FND_MSG_PUB.Add;
7538:
7539: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

7532:
7533: -- Display_Parameters;
7534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7535: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7536: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_REFUNDS_PVT.Create_Refund : '||SQLERRM);
7537: FND_MSG_PUB.Add;
7538:
7539: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
7540: p_count => x_msg_count,

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

7614: --If only one error message on the stack,
7615: --retrive it
7616:
7617: x_return_status := FND_API.G_RET_STS_ERROR ;
7618: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7619: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);
7620: FND_MSG_PUB.Add;
7621:
7622: --If only one error message on the stack,

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

7615: --retrive it
7616:
7617: x_return_status := FND_API.G_RET_STS_ERROR ;
7618: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7619: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);
7620: FND_MSG_PUB.Add;
7621:
7622: --If only one error message on the stack,
7623: --retrive it

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

7630: RETURN;
7631:
7632: ELSE
7633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7634: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7635: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);
7636: FND_MSG_PUB.Add;
7637: END IF;
7638:

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

7631:
7632: ELSE
7633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7634: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7635: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);
7636: FND_MSG_PUB.Add;
7637: END IF;
7638:
7639: IF PG_DEBUG in ('Y', 'C') THEN

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

7876: ROLLBACK TO Activity_unapplication_PVT;
7877:
7878: -- Display_Parameters;
7879: x_return_status := FND_API.G_RET_STS_ERROR ;
7880: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7881: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
7882: FND_MSG_PUB.Add;
7883:
7884: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

7877:
7878: -- Display_Parameters;
7879: x_return_status := FND_API.G_RET_STS_ERROR ;
7880: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7881: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
7882: FND_MSG_PUB.Add;
7883:
7884: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
7885: p_count => x_msg_count,

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

7954:
7955: ROLLBACK TO Activity_unapplication_PVT;
7956:
7957: x_return_status := FND_API.G_RET_STS_ERROR ;
7958: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7959: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);
7960: FND_MSG_PUB.Add;
7961:
7962: --If only one error message on the stack,

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

7955: ROLLBACK TO Activity_unapplication_PVT;
7956:
7957: x_return_status := FND_API.G_RET_STS_ERROR ;
7958: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7959: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);
7960: FND_MSG_PUB.Add;
7961:
7962: --If only one error message on the stack,
7963: --retrive it

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

7969: RETURN;
7970:
7971: ELSE
7972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7973: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7974: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);
7975: FND_MSG_PUB.Add;
7976: END IF;
7977:

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

7970:
7971: ELSE
7972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7973: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
7974: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);
7975: FND_MSG_PUB.Add;
7976: END IF;
7977:
7978: IF PG_DEBUG in ('Y', 'C') THEN

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

8382:
8383: -- Display_Parameters
8384:
8385: x_return_status := FND_API.G_RET_STS_ERROR ;
8386: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8387: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.APPLY_OTHER_ACCOUNT : '||SQLERRM);
8388: FND_MSG_PUB.Add;
8389:
8390: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

8383: -- Display_Parameters
8384:
8385: x_return_status := FND_API.G_RET_STS_ERROR ;
8386: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8387: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.APPLY_OTHER_ACCOUNT : '||SQLERRM);
8388: FND_MSG_PUB.Add;
8389:
8390: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
8391: p_count => x_msg_count,

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

8451: --If only one error message on the stack,
8452: --retrive it
8453:
8454: x_return_status := FND_API.G_RET_STS_ERROR ;
8455: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8456: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_OTHER_ACCOUNT : '||SQLERRM);
8457: FND_MSG_PUB.Add;
8458:
8459: --If only one error message on the stack,

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

8452: --retrive it
8453:
8454: x_return_status := FND_API.G_RET_STS_ERROR ;
8455: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8456: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_OTHER_ACCOUNT : '||SQLERRM);
8457: FND_MSG_PUB.Add;
8458:
8459: --If only one error message on the stack,
8460: --retrive it

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

8466: RETURN;
8467:
8468: ELSE
8469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8470: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8471: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_OTHER_ACCOUNT : '||SQLERRM);
8472: FND_MSG_PUB.Add;
8473: END IF;
8474:

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

8467:
8468: ELSE
8469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8470: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
8471: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_OTHER_ACCOUNT : '||SQLERRM);
8472: FND_MSG_PUB.Add;
8473: END IF;
8474:
8475: arp_util.debug(SQLCODE, G_MSG_ERROR);

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

8837: p_receipt_number := l_receipt_number;
8838: --warning message
8839: IF FND_MSG_PUB.Check_Msg_Level(G_MSG_SUCCESS)
8840: THEN
8841: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_DFLT_DOC_SEQ');
8842: FND_MSG_PUB.Add;
8843: END IF;
8844: ELSE
8845: IF PG_DEBUG in ('Y', 'C') THEN

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

8845: IF PG_DEBUG in ('Y', 'C') THEN
8846: arp_util.debug('create_misc: ' || 'Receipt Number is null ');
8847: END IF;
8848: --raise error message
8849: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_NULL');
8850: FND_MSG_PUB.Add;
8851: x_return_status := FND_API.G_RET_STS_ERROR;
8852: END IF;
8853: END IF;

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

8911: IF ( l_creation_method = 'A' and l_payment_trxn_extension_id is NULL) THEN
8912:
8913: arp_util.debug('Create_cash_122: ' || l_creation_method);
8914: arp_util.debug('Create_cash_122: ' || l_payment_trxn_extension_id );
8915: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
8916: FND_MSG_PUB.Add;
8917: x_return_status := FND_API.G_RET_STS_ERROR;
8918: END IF;
8919:

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

8950: );
8951:
8952: IF l_copy_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8953: arp_util.debug('Create_cash_123: ' );
8954: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
8955: FND_MSG_PUB.Add;
8956: x_return_status := FND_API.G_RET_STS_ERROR;
8957: END IF;
8958: l_payment_trxn_extension_id := l_copy_pmt_trxn_extension_id;

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

9129: ROLLBACK TO Create_misc_PVT;
9130:
9131: -- Display_Parameters;
9132: x_return_status := FND_API.G_RET_STS_ERROR ;
9133: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
9134: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
9135: 'ARP_PROCESS_MISC_RECEIPTS.INSERT_MISC_RECEIPT : '||SQLERRM);
9136: FND_MSG_PUB.Add;
9137:

Line 9134: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',

9130:
9131: -- Display_Parameters;
9132: x_return_status := FND_API.G_RET_STS_ERROR ;
9133: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
9134: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
9135: 'ARP_PROCESS_MISC_RECEIPTS.INSERT_MISC_RECEIPT : '||SQLERRM);
9136: FND_MSG_PUB.Add;
9137:
9138: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

9229: ROLLBACK TO Create_misc_PVT;
9230:
9231: -- Display_Parameters;
9232: x_return_status := FND_API.G_RET_STS_ERROR ;
9233: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
9234: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_MISC : '||SQLERRM);
9235: FND_MSG_PUB.Add;
9236:
9237: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

9230:
9231: -- Display_Parameters;
9232: x_return_status := FND_API.G_RET_STS_ERROR ;
9233: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
9234: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_MISC : '||SQLERRM);
9235: FND_MSG_PUB.Add;
9236:
9237: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
9238: p_count => x_msg_count,

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

9240: );
9241: RETURN;
9242: ELSE
9243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9244: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
9245: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_MISC : '||SQLERRM);
9246: FND_MSG_PUB.Add;
9247: END IF;
9248:

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

9241: RETURN;
9242: ELSE
9243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9244: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
9245: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_MISC : '||SQLERRM);
9246: FND_MSG_PUB.Add;
9247: END IF;
9248:
9249: IF PG_DEBUG in ('Y', 'C') THEN

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

9778: arp_util.debug('Apply_Open_Receipt: error updating applications ' || SQLERRM);
9779: arp_util.debug('Apply_Open_Receipt: l_net_rec_app_id = ' || l_net_rec_app_id);
9780: arp_util.debug('Apply_Open_Receipt: l_open_net_rec_app_id = ' || l_open_net_rec_app_id);
9781: END IF;
9782: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_INVALID');
9783: FND_MSG_PUB.Add;
9784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9785: END IF;
9786:

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

9889: --If only one error message on the stack,
9890: --retrive it
9891:
9892: x_return_status := FND_API.G_RET_STS_ERROR ;
9893: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
9894: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_Open_Receipt : '||SQLERRM);
9895: FND_MSG_PUB.Add;
9896:
9897: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

9890: --retrive it
9891:
9892: x_return_status := FND_API.G_RET_STS_ERROR ;
9893: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
9894: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_Open_Receipt : '||SQLERRM);
9895: FND_MSG_PUB.Add;
9896:
9897: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
9898: p_count => x_msg_count,

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

9902: RETURN;
9903:
9904: ELSE
9905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9906: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
9907: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_Open_Receipt : '||SQLERRM);
9908: FND_MSG_PUB.Add;
9909: END IF;
9910:

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

9903:
9904: ELSE
9905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9906: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
9907: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_Open_Receipt : '||SQLERRM);
9908: FND_MSG_PUB.Add;
9909: END IF;
9910:
9911: IF PG_DEBUG in ('Y', 'C') THEN

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

10173: --If only one error message on the stack,
10174: --retrive it
10175:
10176: x_return_status := FND_API.G_RET_STS_ERROR ;
10177: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
10178: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UnaPPLY_Open_Receipt : '||SQLERRM);
10179: FND_MSG_PUB.Add;
10180:
10181: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

10174: --retrive it
10175:
10176: x_return_status := FND_API.G_RET_STS_ERROR ;
10177: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
10178: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UnaPPLY_Open_Receipt : '||SQLERRM);
10179: FND_MSG_PUB.Add;
10180:
10181: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
10182: p_count => x_msg_count,

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

10186: RETURN;
10187:
10188: ELSE
10189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10190: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
10191: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UnaPPLY_Open_Receipt : '||SQLERRM);
10192: FND_MSG_PUB.Add;
10193: END IF;
10194:

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

10187:
10188: ELSE
10189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10190: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
10191: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UnaPPLY_Open_Receipt : '||SQLERRM);
10192: FND_MSG_PUB.Add;
10193: END IF;
10194:
10195: IF PG_DEBUG in ('Y', 'C') THEN