62:
63: IF l_cash_receipt_id is NUll THEN
64: arp_standard.debug('Null Cash_receipt_id passed .');
65:
66: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_NULL');
67: FND_MSG_PUB.Add;
68: x_return_status := FND_API.G_RET_STS_ERROR;
69: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
70: p_count => x_msg_count,
79: WHERE cash_receipt_id = p_cash_receipt_id;
80:
81: IF l_valid = 0 THEN
82: arp_standard.debug('Invlaid Cash_receipt_id passed .');
83: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_INVALID');
84: FND_MSG_PUB.Add;
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
87: p_count => x_msg_count,
119: ------------------------- Getting the site use id END --------------------
120:
121: IF l_customer_site_use_id IS NULL THEN
122:
123: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_STE_USE_ID_NOT_DEF');
124: FND_MSG_PUB.Add;
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
127: p_count => x_msg_count,
137:
138: IF l_crv_rec.receipt_status <> 'UNID' THEN
139: arp_standard.debug('Receipt Status is not UNID.');
140: x_return_status := FND_API.G_RET_STS_ERROR ;
141: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
142: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Only receipt with Status UNID can be updated');
143: FND_MSG_PUB.Add;
144:
145: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
138: IF l_crv_rec.receipt_status <> 'UNID' THEN
139: arp_standard.debug('Receipt Status is not UNID.');
140: x_return_status := FND_API.G_RET_STS_ERROR ;
141: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
142: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Only receipt with Status UNID can be updated');
143: FND_MSG_PUB.Add;
144:
145: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
146: p_count => x_msg_count,
165:
166: arp_standard.debug('payment_trxn_extension_id is null for Automatic receipt');
167: x_return_status := FND_API.G_RET_STS_ERROR ;
168:
169: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
170: FND_MSG_PUB.Add;
171:
172: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
173: p_count => x_msg_count,
181:
182: arp_standard.debug('payment_trxn_extension_id is not null for Manual receipt');
183: x_return_status := FND_API.G_RET_STS_ERROR ;
184:
185: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
186: FND_MSG_PUB.Add;
187:
188: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
189: p_count => x_msg_count,
231:
232: arp_standard.debug('Bank id is incorrect for provided customer details');
233: x_return_status := FND_API.G_RET_STS_ERROR ;
234:
235: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_ID_INVALID');
236: FND_MSG_PUB.Add;
237:
238: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
239: p_count => x_msg_count,
243: ELSIF NVL(l_bank_chk,0) = -1 THEN
244: arp_standard.debug('Unknown error occur for bank details');
245: x_return_status := FND_API.G_RET_STS_ERROR ;
246:
247: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
248: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Unknown error occur for bank details');
249: FND_MSG_PUB.Add;
250: END IF;
251:
244: arp_standard.debug('Unknown error occur for bank details');
245: x_return_status := FND_API.G_RET_STS_ERROR ;
246:
247: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
248: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Unknown error occur for bank details');
249: FND_MSG_PUB.Add;
250: END IF;
251:
252: END IF;
429: );
430:
431: IF l_create_return_status <> FND_API.G_RET_STS_SUCCESS THEN
432: arp_standard.debug('update_receipt_unid_to_unapp: Payment_trxn_extension_id creation fails ' );
433: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
434: FND_MSG_PUB.Add;
435: x_return_status := FND_API.G_RET_STS_ERROR ;
436: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
437: p_count => x_msg_count,
442:
443: l_payment_trxn_extension_id := l_create_pmt_trxn_extension_id;
444:
445: IF l_payment_trxn_extension_id IS NULL THEN
446: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
447: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Unable to create Payment_trxn_extension_id');
448: FND_MSG_PUB.Add;
449: x_return_status := FND_API.G_RET_STS_ERROR ;
450: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
443: l_payment_trxn_extension_id := l_create_pmt_trxn_extension_id;
444:
445: IF l_payment_trxn_extension_id IS NULL THEN
446: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
447: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Unable to create Payment_trxn_extension_id');
448: FND_MSG_PUB.Add;
449: x_return_status := FND_API.G_RET_STS_ERROR ;
450: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
451: p_count => x_msg_count,
619: ROLLBACK TO Create_Cash_PVT;
620: -- Display_Parameters;
621: x_return_status := FND_API.G_RET_STS_ERROR ;
622: x_status := 'XXX';
623: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
624: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UPDATE_RECEIPT_UNID_TO_UNAPP : '||SQLERRM);
625: FND_MSG_PUB.Add;
626:
627: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
620: -- Display_Parameters;
621: x_return_status := FND_API.G_RET_STS_ERROR ;
622: x_status := 'XXX';
623: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
624: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UPDATE_RECEIPT_UNID_TO_UNAPP : '||SQLERRM);
625: FND_MSG_PUB.Add;
626:
627: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
628: p_count => x_msg_count,