DBA Data[Home] [Help]

APPS.AR_CM_API_PUB dependencies on ARP_UTIL

Line 76: arp_util.debug('AR_CM_API_PUB.APPLY_ON_ACCOUNT(+)');

72: BEGIN
73:
74:
75: IF PG_DEBUG in ('Y', 'C') THEN
76: arp_util.debug('AR_CM_API_PUB.APPLY_ON_ACCOUNT(+)');
77: END IF;
78:
79: /*------------------------------------+
80: | Standard start of API savepoint |

Line 167: arp_util.debug( 'Defaulting Ids Return_status = '||l_def_ids_return_status);

163: l_def_ids_return_status);
164:
165:
166: IF PG_DEBUG in ('Y', 'C') THEN
167: arp_util.debug( 'Defaulting Ids Return_status = '||l_def_ids_return_status);
168: END IF;
169: /*---------------------+
170: | |
171: | DEFAULTING |

Line 203: arp_util.debug( 'Default Info Return_status = '||l_def_return_status);

199: l_inv_line_amount ,
200: l_def_return_status
201: );
202: IF PG_DEBUG in ('Y', 'C') THEN
203: arp_util.debug( 'Default Info Return_status = '||l_def_return_status);
204: arp_util.debug( 'Applied PS ID = '||l_applied_payment_schedule_id);
205: END IF;
206:
207:

Line 204: arp_util.debug( 'Applied PS ID = '||l_applied_payment_schedule_id);

200: l_def_return_status
201: );
202: IF PG_DEBUG in ('Y', 'C') THEN
203: arp_util.debug( 'Default Info Return_status = '||l_def_return_status);
204: arp_util.debug( 'Applied PS ID = '||l_applied_payment_schedule_id);
205: END IF;
206:
207:
208: /*---------------------+

Line 238: arp_util.debug( 'Validation Return_status = '||l_val_return_status);

234: l_inv_currency_code,
235: l_val_return_status
236: );
237: IF PG_DEBUG in ('Y', 'C') THEN
238: arp_util.debug( 'Validation Return_status = '||l_val_return_status);
239: arp_util.debug( 'Applied PS ID = '||l_applied_payment_schedule_id);
240: END IF;
241: END IF;
242:

Line 239: arp_util.debug( 'Applied PS ID = '||l_applied_payment_schedule_id);

235: l_val_return_status
236: );
237: IF PG_DEBUG in ('Y', 'C') THEN
238: arp_util.debug( 'Validation Return_status = '||l_val_return_status);
239: arp_util.debug( 'Applied PS ID = '||l_applied_payment_schedule_id);
240: END IF;
241: END IF;
242:
243: -- Validate DFF

Line 294: arp_util.debug( 'Error(s) occurred. Rolling back and setting status to ERROR');

290: x_return_status := FND_API.G_RET_STS_ERROR ;
291:
292:
293: IF PG_DEBUG in ('Y', 'C') THEN
294: arp_util.debug( 'Error(s) occurred. Rolling back and setting status to ERROR');
295: END IF;
296: Return;
297: END IF;
298:

Line 308: arp_util.debug( 'CM PS ID = '||l_cm_ps_id ||

304: +--------------------*/
305:
306: -- Display inputs to entity handler
307: IF PG_DEBUG in ('Y', 'C') THEN
308: arp_util.debug( 'CM PS ID = '||l_cm_ps_id ||
309: ' Invoice PS ID = '|| l_applied_payment_schedule_id ||
310: ' AMount applied = '|| l_amount_applied ||
311: ' Apply date = ' || l_apply_date||
312: ' GL date = '|| l_apply_gl_date);

Line 427: arp_util.debug( 'committing');

423:
424: IF FND_API.To_Boolean( p_commit )
425: THEN
426: IF PG_DEBUG in ('Y', 'C') THEN
427: arp_util.debug( 'committing');
428: END IF;
429: Commit;
430: END IF;
431: IF PG_DEBUG in ('Y', 'C') THEN

Line 432: arp_util.debug('Apply ()- ');

428: END IF;
429: Commit;
430: END IF;
431: IF PG_DEBUG in ('Y', 'C') THEN
432: arp_util.debug('Apply ()- ');
433: END IF;
434: EXCEPTION
435: WHEN FND_API.G_EXC_ERROR THEN
436:

Line 438: arp_util.debug( SQLCODE, G_MSG_ERROR);

434: EXCEPTION
435: WHEN FND_API.G_EXC_ERROR THEN
436:
437: IF PG_DEBUG in ('Y', 'C') THEN
438: arp_util.debug( SQLCODE, G_MSG_ERROR);
439: arp_util.debug( SQLERRM, G_MSG_ERROR);
440: END IF;
441:
442: ROLLBACK TO Apply_CM;

Line 439: arp_util.debug( SQLERRM, G_MSG_ERROR);

435: WHEN FND_API.G_EXC_ERROR THEN
436:
437: IF PG_DEBUG in ('Y', 'C') THEN
438: arp_util.debug( SQLCODE, G_MSG_ERROR);
439: arp_util.debug( SQLERRM, G_MSG_ERROR);
440: END IF;
441:
442: ROLLBACK TO Apply_CM;
443: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 455: arp_util.debug( SQLERRM, G_MSG_ERROR);

451:
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453:
454: IF PG_DEBUG in ('Y', 'C') THEN
455: arp_util.debug( SQLERRM, G_MSG_ERROR);
456: END IF;
457: ROLLBACK TO Apply_CM;
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
459:

Line 502: arp_util.debug( SQLCODE, G_MSG_ERROR);

498: FND_MSG_PUB.Add;
499: END IF;
500:
501: IF PG_DEBUG in ('Y', 'C') THEN
502: arp_util.debug( SQLCODE, G_MSG_ERROR);
503: arp_util.debug( SQLERRM, G_MSG_ERROR);
504: END IF;
505:
506: ROLLBACK TO Apply_CM;

Line 503: arp_util.debug( SQLERRM, G_MSG_ERROR);

499: END IF;
500:
501: IF PG_DEBUG in ('Y', 'C') THEN
502: arp_util.debug( SQLCODE, G_MSG_ERROR);
503: arp_util.debug( SQLERRM, G_MSG_ERROR);
504: END IF;
505:
506: ROLLBACK TO Apply_CM;
507:

Line 570: arp_util.debug('ar_cm_api_pub.Unapply_on_account()+ ');

566: and ra.customer_trx_id = ct.customer_trx_id;
567:
568: BEGIN
569: IF PG_DEBUG in ('Y', 'C') THEN
570: arp_util.debug('ar_cm_api_pub.Unapply_on_account()+ ');
571: END IF;
572:
573: /*------------------------------------+
574: | Standard start of API savepoint |

Line 665: arp_util.debug( 'Cm customer trx id : '|| l_cm_customer_trx_id );

661: l_apply_gl_date,
662: l_def_ids_return_status
663: );
664: IF PG_DEBUG in ('Y', 'C') THEN
665: arp_util.debug( 'Cm customer trx id : '|| l_cm_customer_trx_id );
666: arp_util.debug( 'receivable app id : '|| l_receivable_application_id );
667: END IF;
668:
669: ar_cm_val_pvt.default_unapp_info(

Line 666: arp_util.debug( 'receivable app id : '|| l_receivable_application_id );

662: l_def_ids_return_status
663: );
664: IF PG_DEBUG in ('Y', 'C') THEN
665: arp_util.debug( 'Cm customer trx id : '|| l_cm_customer_trx_id );
666: arp_util.debug( 'receivable app id : '|| l_receivable_application_id );
667: END IF;
668:
669: ar_cm_val_pvt.default_unapp_info(
670: l_receivable_application_id,

Line 677: arp_util.debug( 'Cm customer trx id : '|| l_cm_customer_trx_id );

673: l_reversal_gl_date,
674: l_cm_gl_date);
675:
676: IF PG_DEBUG in ('Y', 'C') THEN
677: arp_util.debug( 'Cm customer trx id : '|| l_cm_customer_trx_id );
678: arp_util.debug( 'receivable app id : '|| l_receivable_application_id );
679: arp_util.debug( 'reversal date : '|| l_reversal_gl_date );
680: END IF;
681: ar_cm_val_pvt.validate_unapp_info(

Line 678: arp_util.debug( 'receivable app id : '|| l_receivable_application_id );

674: l_cm_gl_date);
675:
676: IF PG_DEBUG in ('Y', 'C') THEN
677: arp_util.debug( 'Cm customer trx id : '|| l_cm_customer_trx_id );
678: arp_util.debug( 'receivable app id : '|| l_receivable_application_id );
679: arp_util.debug( 'reversal date : '|| l_reversal_gl_date );
680: END IF;
681: ar_cm_val_pvt.validate_unapp_info(
682: l_cm_gl_date,

Line 679: arp_util.debug( 'reversal date : '|| l_reversal_gl_date );

675:
676: IF PG_DEBUG in ('Y', 'C') THEN
677: arp_util.debug( 'Cm customer trx id : '|| l_cm_customer_trx_id );
678: arp_util.debug( 'receivable app id : '|| l_receivable_application_id );
679: arp_util.debug( 'reversal date : '|| l_reversal_gl_date );
680: END IF;
681: ar_cm_val_pvt.validate_unapp_info(
682: l_cm_gl_date,
683: l_receivable_application_id,

Line 689: arp_util.debug( 'validation return status :'||l_val_return_status);

685: l_apply_gl_date,
686: l_val_return_status);
687:
688: IF PG_DEBUG in ('Y', 'C') THEN
689: arp_util.debug( 'validation return status :'||l_val_return_status);
690: END IF;
691:
692: IF l_def_ids_return_status <> FND_API.G_RET_STS_SUCCESS OR
693: l_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 712: arp_util.debug( 'Error(s) occurred. Rolling back and setting status to ERROR');

708: p_data => x_msg_data
709: );
710:
711: IF PG_DEBUG in ('Y', 'C') THEN
712: arp_util.debug( 'Error(s) occurred. Rolling back and setting status to ERROR');
713: END IF;
714: Return;
715: END IF;
716:

Line 718: arp_util.debug( '*******DUMP THE INPUT PARAMETERS ********');

714: Return;
715: END IF;
716:
717: IF PG_DEBUG in ('Y', 'C') THEN
718: arp_util.debug( '*******DUMP THE INPUT PARAMETERS ********');
719: arp_util.debug( 'l_receivable_application_id :'||to_char(l_receivable_application_id));
720: arp_util.debug( 'l_applied_payment_schedule_id :'||to_char(l_applied_payment_schedule_id));
721: arp_util.debug( 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
722: END IF;

Line 719: arp_util.debug( 'l_receivable_application_id :'||to_char(l_receivable_application_id));

715: END IF;
716:
717: IF PG_DEBUG in ('Y', 'C') THEN
718: arp_util.debug( '*******DUMP THE INPUT PARAMETERS ********');
719: arp_util.debug( 'l_receivable_application_id :'||to_char(l_receivable_application_id));
720: arp_util.debug( 'l_applied_payment_schedule_id :'||to_char(l_applied_payment_schedule_id));
721: arp_util.debug( 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
722: END IF;
723:

Line 720: arp_util.debug( 'l_applied_payment_schedule_id :'||to_char(l_applied_payment_schedule_id));

716:
717: IF PG_DEBUG in ('Y', 'C') THEN
718: arp_util.debug( '*******DUMP THE INPUT PARAMETERS ********');
719: arp_util.debug( 'l_receivable_application_id :'||to_char(l_receivable_application_id));
720: arp_util.debug( 'l_applied_payment_schedule_id :'||to_char(l_applied_payment_schedule_id));
721: arp_util.debug( 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
722: END IF;
723:
724:

Line 721: arp_util.debug( 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));

717: IF PG_DEBUG in ('Y', 'C') THEN
718: arp_util.debug( '*******DUMP THE INPUT PARAMETERS ********');
719: arp_util.debug( 'l_receivable_application_id :'||to_char(l_receivable_application_id));
720: arp_util.debug( 'l_applied_payment_schedule_id :'||to_char(l_applied_payment_schedule_id));
721: arp_util.debug( 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
722: END IF;
723:
724:
725: BEGIN

Line 786: arp_util.debug( 'committing');

782:
783: IF FND_API.To_Boolean( p_commit )
784: THEN
785: IF PG_DEBUG in ('Y', 'C') THEN
786: arp_util.debug( 'committing');
787: END IF;
788: Commit;
789: END IF;
790:

Line 792: arp_util.debug('ar_cm_api.Unapply_on_account ()- ');

788: Commit;
789: END IF;
790:
791: IF PG_DEBUG in ('Y', 'C') THEN
792: arp_util.debug('ar_cm_api.Unapply_on_account ()- ');
793: END IF;
794: EXCEPTION
795: WHEN FND_API.G_EXC_ERROR THEN
796:

Line 798: arp_util.debug( SQLCODE, G_MSG_ERROR);

794: EXCEPTION
795: WHEN FND_API.G_EXC_ERROR THEN
796:
797: IF PG_DEBUG in ('Y', 'C') THEN
798: arp_util.debug( SQLCODE, G_MSG_ERROR);
799: arp_util.debug( SQLERRM, G_MSG_ERROR);
800: END IF;
801:
802: ROLLBACK TO Unapply_CM;

Line 799: arp_util.debug( SQLERRM, G_MSG_ERROR);

795: WHEN FND_API.G_EXC_ERROR THEN
796:
797: IF PG_DEBUG in ('Y', 'C') THEN
798: arp_util.debug( SQLCODE, G_MSG_ERROR);
799: arp_util.debug( SQLERRM, G_MSG_ERROR);
800: END IF;
801:
802: ROLLBACK TO Unapply_CM;
803: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 815: arp_util.debug( SQLERRM, G_MSG_ERROR);

811:
812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
813:
814: IF PG_DEBUG in ('Y', 'C') THEN
815: arp_util.debug( SQLERRM, G_MSG_ERROR);
816: END IF;
817: ROLLBACK TO Unapply_CM;
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
819:

Line 863: arp_util.debug( SQLCODE, G_MSG_ERROR);

859: FND_MSG_PUB.Add;
860: END IF;
861:
862: IF PG_DEBUG in ('Y', 'C') THEN
863: arp_util.debug( SQLCODE, G_MSG_ERROR);
864: arp_util.debug( SQLERRM, G_MSG_ERROR);
865: END IF;
866:
867: ROLLBACK TO Unapply_CM;

Line 864: arp_util.debug( SQLERRM, G_MSG_ERROR);

860: END IF;
861:
862: IF PG_DEBUG in ('Y', 'C') THEN
863: arp_util.debug( SQLCODE, G_MSG_ERROR);
864: arp_util.debug( SQLERRM, G_MSG_ERROR);
865: END IF;
866:
867: ROLLBACK TO Unapply_CM;
868: