DBA Data[Home] [Help]

APPS.ARP_PROCESS_APPLICATION dependencies on ARP_UTIL

Line 3493: arp_util.debug('trx_id = ' || l_inv_ra_rec.applied_customer_trx_id);

3489: INTO l_inv_ra_rec.applied_customer_trx_id
3490: FROM ar_payment_schedules
3491: WHERE payment_schedule_id = p_invoice_ps_id;
3492:
3493: arp_util.debug('trx_id = ' || l_inv_ra_rec.applied_customer_trx_id);
3494:
3495: -----------------------------------------------------
3496: -- Bug 1814806
3497: -- Prevent the application of a receipt against a claim number

Line 5622: arp_util.debug ( 'cr_rec_id ' || l_ps_rec.cash_receipt_id );

5618:
5619: IF NVL(l_crcpt_rec.exchange_rate_type, 'x') = 'User' THEN
5620: l_ex_rate := l_crcpt_rec.exchange_rate;
5621: END IF;
5622: arp_util.debug ( 'cr_rec_id ' || l_ps_rec.cash_receipt_id );
5623: arp_util.debug ( 'rec_num '|| l_crcpt_rec.receipt_number );
5624: arp_util.debug ( 'payment_trxn_extension_id '|| l_crcpt_rec.payment_trxn_extension_id );
5625:
5626: /* Start Bug 7317841 */

Line 5623: arp_util.debug ( 'rec_num '|| l_crcpt_rec.receipt_number );

5619: IF NVL(l_crcpt_rec.exchange_rate_type, 'x') = 'User' THEN
5620: l_ex_rate := l_crcpt_rec.exchange_rate;
5621: END IF;
5622: arp_util.debug ( 'cr_rec_id ' || l_ps_rec.cash_receipt_id );
5623: arp_util.debug ( 'rec_num '|| l_crcpt_rec.receipt_number );
5624: arp_util.debug ( 'payment_trxn_extension_id '|| l_crcpt_rec.payment_trxn_extension_id );
5625:
5626: /* Start Bug 7317841 */
5627: BEGIN

Line 5624: arp_util.debug ( 'payment_trxn_extension_id '|| l_crcpt_rec.payment_trxn_extension_id );

5620: l_ex_rate := l_crcpt_rec.exchange_rate;
5621: END IF;
5622: arp_util.debug ( 'cr_rec_id ' || l_ps_rec.cash_receipt_id );
5623: arp_util.debug ( 'rec_num '|| l_crcpt_rec.receipt_number );
5624: arp_util.debug ( 'payment_trxn_extension_id '|| l_crcpt_rec.payment_trxn_extension_id );
5625:
5626: /* Start Bug 7317841 */
5627: BEGIN
5628: SELECT payment_trxn_extension_id

Line 5639: arp_util.debug ( 'Latest payment_trxn_extension_id '|| l_crcpt_rec.payment_trxn_extension_id );

5635: AND application_type = 'CASH'
5636: AND application_ref_type = 'MISC_RECEIPT');
5637:
5638: l_crcpt_rec.payment_trxn_extension_id := l_pymnt_trxn_ext_id_temp;
5639: arp_util.debug ( 'Latest payment_trxn_extension_id '|| l_crcpt_rec.payment_trxn_extension_id );
5640: EXCEPTION
5641: WHEN NO_DATA_FOUND THEN
5642: arp_util.debug ( 'Handled Exception for getting max pymnt_trxn_id - First Refund Case' );
5643:

Line 5642: arp_util.debug ( 'Handled Exception for getting max pymnt_trxn_id - First Refund Case' );

5638: l_crcpt_rec.payment_trxn_extension_id := l_pymnt_trxn_ext_id_temp;
5639: arp_util.debug ( 'Latest payment_trxn_extension_id '|| l_crcpt_rec.payment_trxn_extension_id );
5640: EXCEPTION
5641: WHEN NO_DATA_FOUND THEN
5642: arp_util.debug ( 'Handled Exception for getting max pymnt_trxn_id - First Refund Case' );
5643:
5644: WHEN OTHERS THEN
5645: arp_util.debug( 'API EXCEPTION: Getting Max Pymnt_trxn_ext_id ' || SQLERRM);
5646: RAISE;

Line 5645: arp_util.debug( 'API EXCEPTION: Getting Max Pymnt_trxn_ext_id ' || SQLERRM);

5641: WHEN NO_DATA_FOUND THEN
5642: arp_util.debug ( 'Handled Exception for getting max pymnt_trxn_id - First Refund Case' );
5643:
5644: WHEN OTHERS THEN
5645: arp_util.debug( 'API EXCEPTION: Getting Max Pymnt_trxn_ext_id ' || SQLERRM);
5646: RAISE;
5647: END;
5648: /* End Bug 7317841 */
5649:

Line 5686: arp_util.debug( 'API error count '||to_char(NVL(l_msg_count,0)));

5682: /*------------------------------------------------+
5683: | Write API output to the concurrent program log |
5684: +------------------------------------------------*/
5685: IF PG_DEBUG in ('Y', 'C') THEN
5686: arp_util.debug( 'API error count '||to_char(NVL(l_msg_count,0)));
5687: END IF;
5688:
5689: IF NVL(l_msg_count,0) > 0 Then
5690:

Line 5698: arp_util.debug( l_msg_data);

5694: | There is one message returned by the API, so it|
5695: | has been sent out NOCOPY in the parameter x_msg_data |
5696: +------------------------------------------------*/
5697: IF PG_DEBUG in ('Y', 'C') THEN
5698: arp_util.debug( l_msg_data);
5699: END IF;
5700:
5701: ELSIF l_msg_count > 1 Then
5702:

Line 5713: arp_util.debug( to_char(l_count)||' : '||l_msg_data);

5709:
5710: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,
5711: FND_API.G_FALSE);
5712: IF PG_DEBUG in ('Y', 'C') THEN
5713: arp_util.debug( to_char(l_count)||' : '||l_msg_data);
5714: END IF;
5715:
5716: END LOOP;
5717:

Line 5747: arp_util.debug( 'API EXCEPTION: ' ||

5743: +----------------------------------*/
5744: EXCEPTION
5745: WHEN API_exception THEN
5746: IF PG_DEBUG in ('Y', 'C') THEN
5747: arp_util.debug( 'API EXCEPTION: ' ||
5748: 'arp_process_application.activity_application(misc_receipt creation))'
5749: ||SQLERRM);
5750: END IF;
5751: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE,

Line 5758: arp_util.debug( 'API EXCEPTION: ' ||

5754: app_exception.raise_exception;
5755:
5756: WHEN OTHERS THEN
5757: IF PG_DEBUG in ('Y', 'C') THEN
5758: arp_util.debug( 'API EXCEPTION: ' ||
5759: 'arp_process_application.activity_application(misc_receipt creation))'
5760: ||SQLERRM);
5761: END IF;
5762: RAISE;

Line 5984: arp_util.Substitute_Ccid(

5980: | that of Receipt's UNAPP record |
5981: +--------------------------------------------------------------------*/
5982: IF NVL(FND_PROFILE.value('AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION'),
5983: 'N') = 'N' THEN
5984: arp_util.Substitute_Ccid(
5985: p_coa_id => arp_global.chart_of_accounts_id,
5986: p_original_ccid => activity_rec.activity_ccid ,
5987: p_subs_ccid => activity_rec.unapplied_ccid ,
5988: p_actual_ccid => l_ra_rec.code_combination_id );

Line 7003: arp_util.Substitute_Ccid(

6999:
7000: /* bug fix 4025652 */
7001:
7002: IF NVL(FND_PROFILE.value('AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION'),'N') = 'N' THEN
7003: arp_util.Substitute_Ccid(
7004: p_coa_id => arp_global.chart_of_accounts_id,
7005: p_original_ccid => l_activity_cc_id ,
7006: p_subs_ccid => l_unapp_cc_id ,
7007: p_actual_ccid => l_ra_rec.code_combination_id );

Line 8020: arp_util.debug( 'API error count '||to_char(NVL(l_msg_count,0)));

8016: /*------------------------------------------------+
8017: | Write API output to the concurrent program log |
8018: +------------------------------------------------*/
8019: IF PG_DEBUG in ('Y', 'C') THEN
8020: arp_util.debug( 'API error count '||to_char(NVL(l_msg_count,0)));
8021: END IF;
8022:
8023: IF NVL(l_msg_count,0) > 0 Then
8024:

Line 8032: arp_util.debug( l_msg_data);

8028: | There is one message returned by the API, so it|
8029: | has been sent out NOCOPY in the parameter x_msg_data |
8030: +------------------------------------------------*/
8031: IF PG_DEBUG in ('Y', 'C') THEN
8032: arp_util.debug( l_msg_data);
8033: END IF;
8034:
8035: ELSIF l_msg_count > 1 Then
8036:

Line 8047: arp_util.debug( to_char(l_count)||' : '||l_msg_data);

8043:
8044: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,
8045: FND_API.G_FALSE);
8046: IF PG_DEBUG in ('Y', 'C') THEN
8047: arp_util.debug( to_char(l_count)||' : '||l_msg_data);
8048: END IF;
8049:
8050: END LOOP;
8051:

Line 8084: arp_util.debug( 'API EXCEPTION: ' ||

8080: +----------------------------------*/
8081: EXCEPTION
8082: WHEN API_exception THEN
8083: IF PG_DEBUG in ('Y', 'C') THEN
8084: arp_util.debug( 'API EXCEPTION: ' ||
8085: 'arp_process_application.reverse_action_misc_receipt'
8086: ||SQLERRM);
8087: END IF;
8088: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE,

Line 8095: arp_util.debug('EXCEPTION: arp_process_application.reverse_action_misc_receipt'

8091: app_exception.raise_exception;
8092:
8093: WHEN OTHERS THEN
8094: IF PG_DEBUG in ('Y', 'C') THEN
8095: arp_util.debug('EXCEPTION: arp_process_application.reverse_action_misc_receipt'
8096: ||SQLERRM);
8097: END IF;
8098: RAISE;
8099: END reverse_action_misc_receipt;