DBA Data[Home] [Help]

APPS.AR_RECEIPT_UPDATE_API_PUB dependencies on STANDARD

Line 64: arp_standard.debug('Null Cash_receipt_id passed .');

60:
61: begin
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;

Line 82: arp_standard.debug('Invlaid Cash_receipt_id passed .');

78: FROM AR_CASH_RECEIPTS_V
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,

Line 140: arp_standard.debug('Receipt Status is not UNID.');

136:
137: ----- Checking Receipt Status
138:
139: IF l_crv_rec.receipt_status <> 'UNID' THEN
140: arp_standard.debug('Receipt Status is not UNID.');
141: x_return_status := FND_API.G_RET_STS_ERROR ;
142: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
143: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Only receipt with Status UNID can be updated');
144: FND_MSG_PUB.Add;

Line 167: arp_standard.debug('payment_trxn_extension_id is null for Automatic receipt');

163:
164:
165: IF ( l_creation_method_code = 'AUTOMATIC' and l_payment_trxn_extension_id is NULL) THEN
166:
167: arp_standard.debug('payment_trxn_extension_id is null for Automatic receipt');
168: x_return_status := FND_API.G_RET_STS_ERROR ;
169:
170: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
171: FND_MSG_PUB.Add;

Line 183: arp_standard.debug('payment_trxn_extension_id is not null for Manual receipt');

179: END IF;
180:
181: IF ( l_creation_method_code <> 'AUTOMATIC' and l_payment_trxn_extension_id is NOT NULL) THEN
182:
183: arp_standard.debug('payment_trxn_extension_id is not null for Manual receipt');
184: x_return_status := FND_API.G_RET_STS_ERROR ;
185:
186: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
187: FND_MSG_PUB.Add;

Line 204: arp_standard.debug('Customer Bank id is not required for Automatic receipt');

200:
201:
202: IF ( l_creation_method_code = 'AUTOMATIC' and l_customer_bank_account_id is NOT NULL) THEN
203:
204: arp_standard.debug('Customer Bank id is not required for Automatic receipt');
205: arp_standard.debug('Ignoring Customer Bank Id');
206: l_customer_bank_account_id := NULL;
207: END IF;
208:

Line 205: arp_standard.debug('Ignoring Customer Bank Id');

201:
202: IF ( l_creation_method_code = 'AUTOMATIC' and l_customer_bank_account_id is NOT NULL) THEN
203:
204: arp_standard.debug('Customer Bank id is not required for Automatic receipt');
205: arp_standard.debug('Ignoring Customer Bank Id');
206: l_customer_bank_account_id := NULL;
207: END IF;
208:
209: IF ( l_creation_method_code <> 'AUTOMATIC' and l_customer_bank_account_id is NOT NULL) THEN

Line 233: arp_standard.debug('Bank id is incorrect for provided customer details');

229: end;
230:
231: IF NVL(l_bank_chk,0) = 0 THEN
232:
233: arp_standard.debug('Bank id is incorrect for provided customer details');
234: x_return_status := FND_API.G_RET_STS_ERROR ;
235:
236: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_ID_INVALID');
237: FND_MSG_PUB.Add;

Line 245: arp_standard.debug('Unknown error occur for bank details');

241: p_data => x_msg_data
242: );
243: return;
244: ELSIF NVL(l_bank_chk,0) = -1 THEN
245: arp_standard.debug('Unknown error occur for bank details');
246: x_return_status := FND_API.G_RET_STS_ERROR ;
247:
248: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
249: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Unknown error occur for bank details');

Line 278: -- Standard API parameters.

274:
275: --- End Validate
276:
277: PROCEDURE update_receipt_unid_to_unapp (
278: -- Standard API parameters.
279: p_api_version IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281: p_commit IN VARCHAR2 := FND_API.G_FALSE,
282: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 332: | Standard start of API savepoint |

328:
329: BEGIN
330:
331: /*------------------------------------+
332: | Standard start of API savepoint |
333: +------------------------------------*/
334:
335: SAVEPOINT Create_cash_PVT;
336:

Line 338: | Standard call to check for call compatibility |

334:
335: SAVEPOINT Create_cash_PVT;
336:
337: /*--------------------------------------------------+
338: | Standard call to check for call compatibility |
339: +--------------------------------------------------*/
340:
341: IF NOT FND_API.Compatible_API_Call(
342: l_api_version,

Line 361: arp_standard.debug('ar_receipt_update_api_pub.update_receipt_unid_to_unapp()+');

357: FND_MSG_PUB.initialize;
358: END IF;
359:
360: IF PG_DEBUG in ('Y', 'C') THEN
361: arp_standard.debug('ar_receipt_update_api_pub.update_receipt_unid_to_unapp()+');
362: END IF;
363: /*-----------------------------------------+
364: | Initialize return status to SUCCESS |
365: +-----------------------------------------*/

Line 402: arp_standard.debug('Validation of input parametrs fails ' );

398:
399:
400:
401: IF l_valid_return_status <> FND_API.G_RET_STS_SUCCESS THEN
402: arp_standard.debug('Validation of input parametrs fails ' );
403: arp_standard.debug('Customer ID : '||l_customer_id);
404: arp_standard.debug('Cash Receipt ID : '||l_cash_receipt_id);
405: arp_standard.debug('Payment trxn extension id : '||l_payment_trxn_extension_id);
406: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 403: arp_standard.debug('Customer ID : '||l_customer_id);

399:
400:
401: IF l_valid_return_status <> FND_API.G_RET_STS_SUCCESS THEN
402: arp_standard.debug('Validation of input parametrs fails ' );
403: arp_standard.debug('Customer ID : '||l_customer_id);
404: arp_standard.debug('Cash Receipt ID : '||l_cash_receipt_id);
405: arp_standard.debug('Payment trxn extension id : '||l_payment_trxn_extension_id);
406: x_return_status := FND_API.G_RET_STS_ERROR ;
407: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 404: arp_standard.debug('Cash Receipt ID : '||l_cash_receipt_id);

400:
401: IF l_valid_return_status <> FND_API.G_RET_STS_SUCCESS THEN
402: arp_standard.debug('Validation of input parametrs fails ' );
403: arp_standard.debug('Customer ID : '||l_customer_id);
404: arp_standard.debug('Cash Receipt ID : '||l_cash_receipt_id);
405: arp_standard.debug('Payment trxn extension id : '||l_payment_trxn_extension_id);
406: x_return_status := FND_API.G_RET_STS_ERROR ;
407: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
408: p_count => x_msg_count,

Line 405: arp_standard.debug('Payment trxn extension id : '||l_payment_trxn_extension_id);

401: IF l_valid_return_status <> FND_API.G_RET_STS_SUCCESS THEN
402: arp_standard.debug('Validation of input parametrs fails ' );
403: arp_standard.debug('Customer ID : '||l_customer_id);
404: arp_standard.debug('Cash Receipt ID : '||l_cash_receipt_id);
405: arp_standard.debug('Payment trxn extension id : '||l_payment_trxn_extension_id);
406: x_return_status := FND_API.G_RET_STS_ERROR ;
407: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
408: p_count => x_msg_count,
409: p_data => x_msg_data

Line 416: arp_standard.debug('calling CREATE Extension....');

412:
413: ELSE
414:
415: IF l_crv_rec.creation_method_code = 'AUTOMATIC' THEN
416: arp_standard.debug('calling CREATE Extension....');
417: AR_RECEIPT_API_PUB.Create_payment_extension (
418: p_payment_trxn_extension_id => l_payment_trxn_extension_id,
419: p_customer_id => l_customer_id,
420: p_receipt_method_id => l_crv_rec.receipt_method_id,

Line 433: arp_standard.debug('update_receipt_unid_to_unapp: Payment_trxn_extension_id creation fails ' );

429: p_receipt_date => l_crv_rec.RECEIPT_DATE
430: );
431:
432: IF l_create_return_status <> FND_API.G_RET_STS_SUCCESS THEN
433: arp_standard.debug('update_receipt_unid_to_unapp: Payment_trxn_extension_id creation fails ' );
434: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
435: FND_MSG_PUB.Add;
436: x_return_status := FND_API.G_RET_STS_ERROR ;
437: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 590: arp_standard.debug('update_receipt_unid_to_unapp: ' || 'New Status : ' || to_char(X_NEW_STATUS));

586: P_PAYMENT_TRXN_EXTENSION_ID => l_payment_trxn_extension_id
587: );
588:
589: IF PG_DEBUG in ('Y', 'C') THEN
590: arp_standard.debug('update_receipt_unid_to_unapp: ' || 'New Status : ' || to_char(X_NEW_STATUS));
591: arp_standard.debug('update_receipt_unid_to_unapp: ' || 'New Status Displayed : ' || to_char(X_NEW_STATUS_DSP));
592: END IF;
593:
594: -- Updating Return Status for Receipt ----

Line 591: arp_standard.debug('update_receipt_unid_to_unapp: ' || 'New Status Displayed : ' || to_char(X_NEW_STATUS_DSP));

587: );
588:
589: IF PG_DEBUG in ('Y', 'C') THEN
590: arp_standard.debug('update_receipt_unid_to_unapp: ' || 'New Status : ' || to_char(X_NEW_STATUS));
591: arp_standard.debug('update_receipt_unid_to_unapp: ' || 'New Status Displayed : ' || to_char(X_NEW_STATUS_DSP));
592: END IF;
593:
594: -- Updating Return Status for Receipt ----
595:

Line 601: | Standard check of p_commit |

597:
598:
599:
600: /*--------------------------------+
601: | Standard check of p_commit |
602: +--------------------------------*/
603:
604: IF FND_API.To_Boolean( p_commit )
605: THEN

Line 614: arp_standard.debug('ar_receipt_update_api_pub.update_receipt_unid_to_unapp()-');

610: END IF;
611:
612:
613: IF PG_DEBUG in ('Y', 'C') THEN
614: arp_standard.debug('ar_receipt_update_api_pub.update_receipt_unid_to_unapp()-');
615: END IF;
616:
617: EXCEPTION
618: WHEN OTHERS THEN