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

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

14: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
15:
16: PROCEDURE apply_on_account(
17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_cm_app_rec IN cm_app_rec_type,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,

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

15:
16: PROCEDURE apply_on_account(
17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_cm_app_rec IN cm_app_rec_type,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,
23: x_msg_data OUT NOCOPY VARCHAR2,

Line 86: IF NOT FND_API.Compatible_API_Call(

82: /*--------------------------------------------------+
83: | Standard call to check for call compatibility |
84: +--------------------------------------------------*/
85:
86: IF NOT FND_API.Compatible_API_Call(
87: l_api_version,
88: p_api_version,
89: l_api_name,
90: G_PKG_NAME

Line 93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

89: l_api_name,
90: G_PKG_NAME
91: )
92: THEN
93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: END IF;
95:
96: /*--------------------------------------------------------------+
97: | Initialize message list if p_init_msg_list is set to TRUE |

Line 100: IF FND_API.to_Boolean( p_init_msg_list )

96: /*--------------------------------------------------------------+
97: | Initialize message list if p_init_msg_list is set to TRUE |
98: +--------------------------------------------------------------*/
99:
100: IF FND_API.to_Boolean( p_init_msg_list )
101: THEN
102: FND_MSG_PUB.initialize;
103: END IF;
104:

Line 115: x_return_status := FND_API.G_RET_STS_SUCCESS;

111: /*-----------------------------------------+
112: | Initialize return status to SUCCESS |
113: +-----------------------------------------*/
114:
115: x_return_status := FND_API.G_RET_STS_SUCCESS;
116:
117: /*---------------------------------------------+
118: | ========== Start of API Body ========== |
119: +---------------------------------------------*/

Line 198: IF l_def_return_status = FND_API.G_RET_STS_SUCCESS AND

194: | VALIDATION |
195: | |
196: +---------------------*/
197: -- Call new PVT API for validation
198: IF l_def_return_status = FND_API.G_RET_STS_SUCCESS AND
199: l_def_ids_return_status = FND_API.G_RET_STS_SUCCESS
200: THEN
201: ar_cm_val_pvt.validate_app_info(
202: l_apply_date,

Line 199: l_def_ids_return_status = FND_API.G_RET_STS_SUCCESS

195: | |
196: +---------------------*/
197: -- Call new PVT API for validation
198: IF l_def_return_status = FND_API.G_RET_STS_SUCCESS AND
199: l_def_ids_return_status = FND_API.G_RET_STS_SUCCESS
200: THEN
201: ar_cm_val_pvt.validate_app_info(
202: l_apply_date,
203: l_cm_trx_date,

Line 254: IF l_def_ids_return_status <> FND_API.G_RET_STS_SUCCESS OR

250: 'AR_RECEIVABLE_APPLICATIONS',
251: l_dflex_val_return_status
252: );
253:
254: IF l_def_ids_return_status <> FND_API.G_RET_STS_SUCCESS OR
255: l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
256: l_def_return_status <> FND_API.G_RET_STS_SUCCESS OR
257: l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN
258: x_return_status := FND_API.G_RET_STS_ERROR;

Line 255: l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR

251: l_dflex_val_return_status
252: );
253:
254: IF l_def_ids_return_status <> FND_API.G_RET_STS_SUCCESS OR
255: l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
256: l_def_return_status <> FND_API.G_RET_STS_SUCCESS OR
257: l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: END IF;

Line 256: l_def_return_status <> FND_API.G_RET_STS_SUCCESS OR

252: );
253:
254: IF l_def_ids_return_status <> FND_API.G_RET_STS_SUCCESS OR
255: l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
256: l_def_return_status <> FND_API.G_RET_STS_SUCCESS OR
257: l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: END IF;
260:

Line 257: l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN

253:
254: IF l_def_ids_return_status <> FND_API.G_RET_STS_SUCCESS OR
255: l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
256: l_def_return_status <> FND_API.G_RET_STS_SUCCESS OR
257: l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: END IF;
260:
261:

Line 258: x_return_status := FND_API.G_RET_STS_ERROR;

254: IF l_def_ids_return_status <> FND_API.G_RET_STS_SUCCESS OR
255: l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
256: l_def_return_status <> FND_API.G_RET_STS_SUCCESS OR
257: l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: END IF;
260:
261:
262: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

258: x_return_status := FND_API.G_RET_STS_ERROR;
259: END IF;
260:
261:
262: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,
264: p_data => x_msg_data
265: );
266:

Line 267: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

263: p_count => x_msg_count,
264: p_data => x_msg_data
265: );
266:
267: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
268: THEN
269:
270: ROLLBACK TO Apply_CM;
271:

Line 272: x_return_status := FND_API.G_RET_STS_ERROR ;

268: THEN
269:
270: ROLLBACK TO Apply_CM;
271:
272: x_return_status := FND_API.G_RET_STS_ERROR ;
273:
274:
275: IF PG_DEBUG in ('Y', 'C') THEN
276: arp_util.debug( 'Error(s) occurred. Rolling back and setting status to ERROR');

Line 303: l_return_status := FND_API.G_RET_STS_SUCCESS;

299:
300: -- Lock the PS of the transaction to be applied
301: arp_ps_pkg.nowaitlock_p (p_ps_id => l_applied_payment_schedule_id);
302:
303: l_return_status := FND_API.G_RET_STS_SUCCESS;
304:
305:
306: BEGIN
307: --call the entity handler

Line 379: x_return_status := FND_API.G_RET_STS_ERROR ;

375: THEN
376: ROLLBACK TO Apply_CM;
377:
378: -- Display_Parameters;
379: x_return_status := FND_API.G_RET_STS_ERROR ;
380: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
381: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.CM_APPLICATION'||SQLERRM);
382: FND_MSG_PUB.Add;
383:

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

380: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
381: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.CM_APPLICATION'||SQLERRM);
382: FND_MSG_PUB.Add;
383:
384: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
385: p_count => x_msg_count,
386: p_data => x_msg_data
387: );
388: RETURN;

Line 394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

390: RAISE;
391: END IF;
392: END;
393:
394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 395: RAISE FND_API.G_EXC_ERROR;

391: END IF;
392: END;
393:
394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
399: END IF;

Line 397: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

393:
394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
399: END IF;
400:
401:

Line 398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
399: END IF;
400:
401:
402: /*--------------------------------+

Line 406: IF FND_API.To_Boolean( p_commit )

402: /*--------------------------------+
403: | Standard check of p_commit |
404: +--------------------------------*/
405:
406: IF FND_API.To_Boolean( p_commit )
407: THEN
408: IF PG_DEBUG in ('Y', 'C') THEN
409: arp_util.debug( 'committing');
410: END IF;

Line 417: WHEN FND_API.G_EXC_ERROR THEN

413: IF PG_DEBUG in ('Y', 'C') THEN
414: arp_util.debug('Apply ()- ');
415: END IF;
416: EXCEPTION
417: WHEN FND_API.G_EXC_ERROR THEN
418:
419: IF PG_DEBUG in ('Y', 'C') THEN
420: arp_util.debug( SQLCODE, G_MSG_ERROR);
421: arp_util.debug( SQLERRM, G_MSG_ERROR);

Line 425: x_return_status := FND_API.G_RET_STS_ERROR ;

421: arp_util.debug( SQLERRM, G_MSG_ERROR);
422: END IF;
423:
424: ROLLBACK TO Apply_CM;
425: x_return_status := FND_API.G_RET_STS_ERROR ;
426:
427: -- Display_Parameters;
428:
429: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

425: x_return_status := FND_API.G_RET_STS_ERROR ;
426:
427: -- Display_Parameters;
428:
429: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
430: p_count => x_msg_count,
431: p_data => x_msg_data
432: );
433:

Line 434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

430: p_count => x_msg_count,
431: p_data => x_msg_data
432: );
433:
434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
435:
436: IF PG_DEBUG in ('Y', 'C') THEN
437: arp_util.debug( SQLERRM, G_MSG_ERROR);
438: END IF;

Line 440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

436: IF PG_DEBUG in ('Y', 'C') THEN
437: arp_util.debug( SQLERRM, G_MSG_ERROR);
438: END IF;
439: ROLLBACK TO Apply_CM;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
441:
442: -- Display_Parameters;
443:
444: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
441:
442: -- Display_Parameters;
443:
444: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
445: p_count => x_msg_count,
446: p_data => x_msg_data
447: );
448:

Line 464: x_return_status := FND_API.G_RET_STS_ERROR ;

460:
461: --If only one error message on the stack,
462: --retrive it
463:
464: x_return_status := FND_API.G_RET_STS_ERROR ;
465: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
466: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
467: FND_MSG_PUB.Add;
468:

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

465: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
466: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
467: FND_MSG_PUB.Add;
468:
469: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
470: p_count => x_msg_count,
471: p_data => x_msg_data
472: );
473:

Line 477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

473:
474: RETURN;
475:
476: ELSE
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
478: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
479: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY : '||SQLERRM);
480: FND_MSG_PUB.Add;
481: END IF;

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

495: END IF;
496:
497: -- Display_Parameters;
498:
499: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
500: p_count => x_msg_count,
501: p_data => x_msg_data
502: );
503:

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

505: END apply_on_account;
506:
507: PROCEDURE unapply_on_account(
508: p_api_version IN NUMBER,
509: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
510: p_commit IN VARCHAR2 := FND_API.G_FALSE,
511: p_cm_unapp_rec IN cm_unapp_rec_type,
512: x_return_status OUT NOCOPY VARCHAR2,
513: x_msg_count OUT NOCOPY NUMBER,

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

506:
507: PROCEDURE unapply_on_account(
508: p_api_version IN NUMBER,
509: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
510: p_commit IN VARCHAR2 := FND_API.G_FALSE,
511: p_cm_unapp_rec IN cm_unapp_rec_type,
512: x_return_status OUT NOCOPY VARCHAR2,
513: x_msg_count OUT NOCOPY NUMBER,
514: x_msg_data OUT NOCOPY VARCHAR2)

Line 530: l_def_ids_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

526: l_reversal_gl_date DATE;
527: l_apply_gl_date DATE;
528: l_cm_gl_date DATE;
529:
530: l_def_ids_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
531: l_val_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
532:
533: BEGIN
534: IF PG_DEBUG in ('Y', 'C') THEN

Line 531: l_val_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

527: l_apply_gl_date DATE;
528: l_cm_gl_date DATE;
529:
530: l_def_ids_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
531: l_val_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
532:
533: BEGIN
534: IF PG_DEBUG in ('Y', 'C') THEN
535: arp_util.debug('ar_cm_api_pub.Unapply_on_account()+ ');

Line 548: IF NOT FND_API.Compatible_API_Call(

544: /*--------------------------------------------------+
545: | Standard call to check for call compatibility |
546: +--------------------------------------------------*/
547:
548: IF NOT FND_API.Compatible_API_Call(
549: l_api_version,
550: p_api_version,
551: l_api_name,
552: G_PKG_NAME

Line 555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

551: l_api_name,
552: G_PKG_NAME
553: )
554: THEN
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556: END IF;
557:
558:
559: /*--------------------------------------------------------------+

Line 563: IF FND_API.to_Boolean( p_init_msg_list )

559: /*--------------------------------------------------------------+
560: | Initialize message list if p_init_msg_list is set to TRUE |
561: +--------------------------------------------------------------*/
562:
563: IF FND_API.to_Boolean( p_init_msg_list )
564: THEN
565: FND_MSG_PUB.initialize;
566: END IF;
567:

Line 587: x_return_status := FND_API.G_RET_STS_SUCCESS;

583: /*-----------------------------------------+
584: | Initialize return status to SUCCESS |
585: +-----------------------------------------*/
586:
587: x_return_status := FND_API.G_RET_STS_SUCCESS;
588: /*---------------------------------------------+
589: | ========== Start of API Body ========== |
590: +---------------------------------------------*/
591:

Line 644: IF l_def_ids_return_status <> FND_API.G_RET_STS_SUCCESS OR

640: IF PG_DEBUG in ('Y', 'C') THEN
641: arp_util.debug( 'validation return status :'||l_val_return_status);
642: END IF;
643:
644: IF l_def_ids_return_status <> FND_API.G_RET_STS_SUCCESS OR
645: l_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN
646: x_return_status := FND_API.G_RET_STS_ERROR ;
647: END IF;
648:

Line 645: l_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN

641: arp_util.debug( 'validation return status :'||l_val_return_status);
642: END IF;
643:
644: IF l_def_ids_return_status <> FND_API.G_RET_STS_SUCCESS OR
645: l_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN
646: x_return_status := FND_API.G_RET_STS_ERROR ;
647: END IF;
648:
649: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

Line 646: x_return_status := FND_API.G_RET_STS_ERROR ;

642: END IF;
643:
644: IF l_def_ids_return_status <> FND_API.G_RET_STS_SUCCESS OR
645: l_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN
646: x_return_status := FND_API.G_RET_STS_ERROR ;
647: END IF;
648:
649: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
650: THEN

Line 649: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

645: l_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN
646: x_return_status := FND_API.G_RET_STS_ERROR ;
647: END IF;
648:
649: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
650: THEN
651:
652: ROLLBACK TO Unapply_CM;
653:

Line 654: x_return_status := FND_API.G_RET_STS_ERROR ;

650: THEN
651:
652: ROLLBACK TO Unapply_CM;
653:
654: x_return_status := FND_API.G_RET_STS_ERROR ;
655:
656: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
657: p_count => x_msg_count,
658: p_data => x_msg_data

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

652: ROLLBACK TO Unapply_CM;
653:
654: x_return_status := FND_API.G_RET_STS_ERROR ;
655:
656: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
657: p_count => x_msg_count,
658: p_data => x_msg_data
659: );
660:

Line 699: x_return_status := FND_API.G_RET_STS_ERROR ;

695: THEN
696: ROLLBACK TO Unapply_CM;
697:
698: -- Display_Parameters;
699: x_return_status := FND_API.G_RET_STS_ERROR ;
700: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
701: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE_CM_APP : '||SQLERRM);
702: FND_MSG_PUB.Add;
703:

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

700: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
701: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE_CM_APP : '||SQLERRM);
702: FND_MSG_PUB.Add;
703:
704: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
705: p_count => x_msg_count,
706: p_data => x_msg_data
707: );
708: RETURN;

Line 718: IF FND_API.To_Boolean( p_commit )

714: /*--------------------------------+
715: | Standard check of p_commit |
716: +--------------------------------*/
717:
718: IF FND_API.To_Boolean( p_commit )
719: THEN
720: IF PG_DEBUG in ('Y', 'C') THEN
721: arp_util.debug( 'committing');
722: END IF;

Line 730: WHEN FND_API.G_EXC_ERROR THEN

726: IF PG_DEBUG in ('Y', 'C') THEN
727: arp_util.debug('ar_cm_api.Unapply_on_account ()- ');
728: END IF;
729: EXCEPTION
730: WHEN FND_API.G_EXC_ERROR THEN
731:
732: IF PG_DEBUG in ('Y', 'C') THEN
733: arp_util.debug( SQLCODE, G_MSG_ERROR);
734: arp_util.debug( SQLERRM, G_MSG_ERROR);

Line 738: x_return_status := FND_API.G_RET_STS_ERROR ;

734: arp_util.debug( SQLERRM, G_MSG_ERROR);
735: END IF;
736:
737: ROLLBACK TO Unapply_CM;
738: x_return_status := FND_API.G_RET_STS_ERROR ;
739:
740: -- Display_Parameters;
741:
742: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

738: x_return_status := FND_API.G_RET_STS_ERROR ;
739:
740: -- Display_Parameters;
741:
742: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
743: p_count => x_msg_count,
744: p_data => x_msg_data
745: );
746:

Line 747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

743: p_count => x_msg_count,
744: p_data => x_msg_data
745: );
746:
747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
748:
749: IF PG_DEBUG in ('Y', 'C') THEN
750: arp_util.debug( SQLERRM, G_MSG_ERROR);
751: END IF;

Line 753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

749: IF PG_DEBUG in ('Y', 'C') THEN
750: arp_util.debug( SQLERRM, G_MSG_ERROR);
751: END IF;
752: ROLLBACK TO Unapply_CM;
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754:
755: -- Display_Parameters;
756:
757: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754:
755: -- Display_Parameters;
756:
757: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
758: p_count => x_msg_count,
759: p_data => x_msg_data
760: );
761:

Line 775: x_return_status := FND_API.G_RET_STS_ERROR ;

771: THEN
772:
773: ROLLBACK TO Unapply_CM;
774:
775: x_return_status := FND_API.G_RET_STS_ERROR ;
776: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
777: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY : '||SQLERRM);
778: FND_MSG_PUB.Add;
779:

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

779:
780: --If only one error message on the stack,
781: --retrive it
782:
783: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
784: p_count => x_msg_count,
785: p_data => x_msg_data
786: );
787:

Line 791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

787:
788: RETURN;
789:
790: ELSE
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
792: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
793: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY : '||SQLERRM);
794: FND_MSG_PUB.Add;
795: END IF;

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

809: END IF;
810:
811: -- Display_Parameters;
812:
813: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
814: p_count => x_msg_count,
815: p_data => x_msg_data
816: );
817: