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_UPDATE_API_PUB dependencies on FND_API

Line 55: x_return_status := FND_API.G_RET_STS_SUCCESS;

51: l_valid NUMBER;
52:
53: BEGIN
54:
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: arp_util.debug('EXCEPTION: Validate_id()+ ');
58:
59: --- Cash receipt validation

Line 68: x_return_status := FND_API.G_RET_STS_ERROR;

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,
71: p_data => x_msg_data);
72: return;

Line 69: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
71: p_data => x_msg_data);
72: return;
73:

Line 85: x_return_status := FND_API.G_RET_STS_ERROR;

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,
88: p_data => x_msg_data);
89: return;

Line 86: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
88: p_data => x_msg_data);
89: return;
90: END IF;

Line 126: x_return_status := FND_API.G_RET_STS_ERROR;

122: AND arp_global.sysparam.site_required_flag = 'Y' THEN
123:
124: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_STE_USE_ID_NOT_DEF');
125: FND_MSG_PUB.Add;
126: x_return_status := FND_API.G_RET_STS_ERROR;
127: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
128: p_count => x_msg_count,
129: p_data => x_msg_data);
130: return;

Line 127: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

123:
124: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_STE_USE_ID_NOT_DEF');
125: FND_MSG_PUB.Add;
126: x_return_status := FND_API.G_RET_STS_ERROR;
127: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
128: p_count => x_msg_count,
129: p_data => x_msg_data);
130: return;
131:

Line 141: x_return_status := FND_API.G_RET_STS_ERROR ;

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;
145:

Line 146: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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;
145:
146: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
147: p_count => x_msg_count,
148: p_data => x_msg_data
149: );
150: return;

Line 168: x_return_status := FND_API.G_RET_STS_ERROR ;

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;
172:

Line 173: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

169:
170: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
171: FND_MSG_PUB.Add;
172:
173: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
174: p_count => x_msg_count,
175: p_data => x_msg_data
176: );
177: return;

Line 184: x_return_status := FND_API.G_RET_STS_ERROR ;

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;
188:

Line 189: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

185:
186: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
187: FND_MSG_PUB.Add;
188:
189: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
190: p_count => x_msg_count,
191: p_data => x_msg_data
192: );
193: return;

Line 234: x_return_status := FND_API.G_RET_STS_ERROR ;

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;
238:

Line 239: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

235:
236: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_ID_INVALID');
237: FND_MSG_PUB.Add;
238:
239: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
240: p_count => x_msg_count,
241: p_data => x_msg_data
242: );
243: return;

Line 246: x_return_status := FND_API.G_RET_STS_ERROR ;

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');
250: FND_MSG_PUB.Add;

Line 267: x_return_status := FND_API.G_RET_STS_ERROR ;

263: EXCEPTION
264:
265: WHEN OTHERS THEN
266: IF c_default_location%ISOPEN THEN CLOSE c_default_location; END IF;
267: x_return_status := FND_API.G_RET_STS_ERROR ;
268: IF PG_DEBUG in ('Y', 'C') THEN
269: arp_util.debug('EXCEPTION: Validate_id() ');
270: END IF;
271: raise;

Line 280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_msg_count OUT NOCOPY NUMBER,

Line 281: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_msg_count OUT NOCOPY NUMBER,
285: x_msg_data OUT NOCOPY VARCHAR2,

Line 282: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_msg_count OUT NOCOPY NUMBER,
285: x_msg_data OUT NOCOPY VARCHAR2,
286: -- Receipt info. parameters

Line 319: l_create_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

315: x_dm_number VARCHAR2(255);
316: x_tw_Status VARCHAR2(255);
317:
318: -- Create payment_trxn_extension_id
319: l_create_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
320: l_create_msg_count NUMBER;
321: l_create_msg_data VARCHAR2(2000);
322: l_create_pmt_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
323: l_valid_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 323: l_valid_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

319: l_create_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
320: l_create_msg_count NUMBER;
321: l_create_msg_data VARCHAR2(2000);
322: l_create_pmt_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
323: l_valid_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
324: l_valid_msg_count NUMBER;
325: l_valid_msg_data VARCHAR2(2000);
326:
327:

Line 341: IF NOT FND_API.Compatible_API_Call(

337: /*--------------------------------------------------+
338: | Standard call to check for call compatibility |
339: +--------------------------------------------------*/
340:
341: IF NOT FND_API.Compatible_API_Call(
342: l_api_version,
343: p_api_version,
344: l_api_name,
345: G_PKG_NAME

Line 348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

344: l_api_name,
345: G_PKG_NAME
346: )
347: THEN
348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
349: END IF;
350:
351: /*--------------------------------------------------------------+
352: | Initialize message list if p_init_msg_list is set to TRUE |

Line 355: IF FND_API.to_Boolean( p_init_msg_list )

351: /*--------------------------------------------------------------+
352: | Initialize message list if p_init_msg_list is set to TRUE |
353: +--------------------------------------------------------------*/
354:
355: IF FND_API.to_Boolean( p_init_msg_list )
356: THEN
357: FND_MSG_PUB.initialize;
358: END IF;
359:

Line 367: x_return_status := FND_API.G_RET_STS_SUCCESS;

363: /*-----------------------------------------+
364: | Initialize return status to SUCCESS |
365: +-----------------------------------------*/
366:
367: x_return_status := FND_API.G_RET_STS_SUCCESS;
368:
369: /*-----------------------------------------+
370: | Initialize ORG ID |
371: +-----------------------------------------*/

Line 373: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

369: /*-----------------------------------------+
370: | Initialize ORG ID |
371: +-----------------------------------------*/
372:
373: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
374: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
375: p_return_status =>l_org_return_status);
376:
377: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 377: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

373: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
374: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
375: p_return_status =>l_org_return_status);
376:
377: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END IF;
380:
381: l_payment_trxn_extension_id := p_payment_trxn_extension_id;

Line 378: x_return_status := FND_API.G_RET_STS_ERROR;

374: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
375: p_return_status =>l_org_return_status);
376:
377: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END IF;
380:
381: l_payment_trxn_extension_id := p_payment_trxn_extension_id;
382:

Line 401: IF l_valid_return_status <> FND_API.G_RET_STS_SUCCESS THEN

397:
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);

Line 406: x_return_status := FND_API.G_RET_STS_ERROR ;

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
410: );

Line 407: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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
410: );
411: return;

Line 432: IF l_create_return_status <> FND_API.G_RET_STS_SUCCESS THEN

428: o_payment_trxn_extension_id => l_create_pmt_trxn_extension_id,
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 ;

Line 436: x_return_status := FND_API.G_RET_STS_ERROR ;

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,
438: p_count => x_msg_count,
439: p_data => x_msg_data
440: );

Line 437: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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,
438: p_count => x_msg_count,
439: p_data => x_msg_data
440: );
441: return;

Line 450: x_return_status := FND_API.G_RET_STS_ERROR ;

446: IF l_payment_trxn_extension_id IS NULL THEN
447: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
448: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Unable to create Payment_trxn_extension_id');
449: FND_MSG_PUB.Add;
450: x_return_status := FND_API.G_RET_STS_ERROR ;
451: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
452: p_count => x_msg_count,
453: p_data => x_msg_data
454: );

Line 451: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

447: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
448: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Unable to create Payment_trxn_extension_id');
449: FND_MSG_PUB.Add;
450: x_return_status := FND_API.G_RET_STS_ERROR ;
451: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
452: p_count => x_msg_count,
453: p_data => x_msg_data
454: );
455: return;

Line 604: IF FND_API.To_Boolean( p_commit )

600: /*--------------------------------+
601: | Standard check of p_commit |
602: +--------------------------------*/
603:
604: IF FND_API.To_Boolean( p_commit )
605: THEN
606: IF PG_DEBUG in ('Y', 'C') THEN
607: arp_util.debug('update_receipt_unid_to_unapp : ' || 'committing');
608: END IF;

Line 622: x_return_status := FND_API.G_RET_STS_ERROR ;

618: WHEN OTHERS THEN
619:
620: ROLLBACK TO Create_Cash_PVT;
621: -- Display_Parameters;
622: x_return_status := FND_API.G_RET_STS_ERROR ;
623: x_status := 'XXX';
624: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
625: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UPDATE_RECEIPT_UNID_TO_UNAPP : '||SQLERRM);
626: FND_MSG_PUB.Add;

Line 628: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

624: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
625: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UPDATE_RECEIPT_UNID_TO_UNAPP : '||SQLERRM);
626: FND_MSG_PUB.Add;
627:
628: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
629: p_count => x_msg_count,
630: p_data => x_msg_data
631: );
632: RETURN;