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 125: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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,
128: p_data => x_msg_data);
129: return;
130:

Line 140: x_return_status := FND_API.G_RET_STS_ERROR ;

136: ----- Checking Receipt Status
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:

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

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,
147: p_data => x_msg_data
148: );
149: return;

Line 167: x_return_status := FND_API.G_RET_STS_ERROR ;

163:
164: IF ( l_creation_method_code = 'AUTOMATIC' and l_payment_trxn_extension_id is NULL) THEN
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:

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

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,
174: p_data => x_msg_data
175: );
176: return;

Line 183: x_return_status := FND_API.G_RET_STS_ERROR ;

179:
180: IF ( l_creation_method_code <> 'AUTOMATIC' and l_payment_trxn_extension_id is NOT NULL) THEN
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:

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

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,
190: p_data => x_msg_data
191: );
192: return;

Line 233: x_return_status := FND_API.G_RET_STS_ERROR ;

229:
230: IF NVL(l_bank_chk,0) = 0 THEN
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:

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

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,
240: p_data => x_msg_data
241: );
242: return;

Line 245: x_return_status := FND_API.G_RET_STS_ERROR ;

241: );
242: return;
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;

Line 266: x_return_status := FND_API.G_RET_STS_ERROR ;

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

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

275:
276: PROCEDURE update_receipt_unid_to_unapp (
277: -- Standard API parameters.
278: p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280: p_commit IN VARCHAR2 := FND_API.G_FALSE,
281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,

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

276: PROCEDURE update_receipt_unid_to_unapp (
277: -- Standard API parameters.
278: p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280: p_commit IN VARCHAR2 := FND_API.G_FALSE,
281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,

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

277: -- Standard API parameters.
278: p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280: p_commit IN VARCHAR2 := FND_API.G_FALSE,
281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,
285: -- 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 431: IF l_create_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 435: x_return_status := FND_API.G_RET_STS_ERROR ;

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

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

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

Line 449: x_return_status := FND_API.G_RET_STS_ERROR ;

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,
452: p_data => x_msg_data
453: );

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

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,
452: p_data => x_msg_data
453: );
454: return;

Line 603: IF FND_API.To_Boolean( p_commit )

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

Line 621: x_return_status := FND_API.G_RET_STS_ERROR ;

617: WHEN OTHERS THEN
618:
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;

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

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,
629: p_data => x_msg_data
630: );
631: RETURN;