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.ARP_ALLOCATION_PKG dependencies on ARP_ALLOCATION_PKG

Line 1: PACKAGE BODY ARP_ALLOCATION_PKG AS

1: PACKAGE BODY ARP_ALLOCATION_PKG AS
2: /* $Header: ARALLOCB.pls 120.76.12010000.6 2008/12/02 05:42:50 mpsingh ship $ */
3:
4: /*=======================================================================+
5: | Global Constants

Line 395: arp_standard.debug( 'ARP_ALLOCATION_PKG.Allocate_Tax()+');

391: What_kind_of_activity EXCEPTION;
392: impossible_adjust EXCEPTION;
393: BEGIN
394: -- IF PG_DEBUG in ('Y', 'C') THEN
395: arp_standard.debug( 'ARP_ALLOCATION_PKG.Allocate_Tax()+');
396: -- END IF;
397:
398: /*----------------------------------------------------------------------------+
399: | Assign globals and get system options info |

Line 868: arp_standard.debug( 'ARP_ALLOCATION_PKG.Allocate_Tax()-');

864: g_adj_act_gl_acct_ccid := -9999;
865:
866: <>
867: IF PG_DEBUG in ('Y', 'C') THEN
868: arp_standard.debug( 'ARP_ALLOCATION_PKG.Allocate_Tax()-');
869: END IF;
870:
871: EXCEPTION
872: WHEN NO_DATA_FOUND THEN

Line 874: arp_standard.debug( 'ARP_ALLOCATION_PKG.Allocate_Tax - NO_DATA_FOUND' );

870:
871: EXCEPTION
872: WHEN NO_DATA_FOUND THEN
873: IF PG_DEBUG in ('Y', 'C') THEN
874: arp_standard.debug( 'ARP_ALLOCATION_PKG.Allocate_Tax - NO_DATA_FOUND' );
875: END IF;
876: RAISE;
877:
878: WHEN What_kind_of_activity THEN

Line 880: arp_standard.debug( 'EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax - What_kind_of_activity');

876: RAISE;
877:
878: WHEN What_kind_of_activity THEN
879: IF PG_DEBUG in ('Y', 'C') THEN
880: arp_standard.debug( 'EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax - What_kind_of_activity');
881: END IF;
882: RAISE;
883:
884: WHEN impossible_adjust THEN

Line 886: arp_standard.debug( 'EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax - impossible_adjust');

882: RAISE;
883:
884: WHEN impossible_adjust THEN
885: IF PG_DEBUG in ('Y', 'C') THEN
886: arp_standard.debug( 'EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax - impossible_adjust');
887: END IF;
888: RAISE;
889:
890: WHEN OTHERS THEN

Line 892: arp_standard.debug( 'EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax:'||SQLERRM);

888: RAISE;
889:
890: WHEN OTHERS THEN
891: IF PG_DEBUG in ('Y', 'C') THEN
892: arp_standard.debug( 'EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax:'||SQLERRM);
893: END IF;
894: RAISE;
895:
896: END Allocate_Tax;

Line 926: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry()+');

922: l_dummy NUMBER;
923: BEGIN
924:
925: IF PG_DEBUG in ('Y', 'C') THEN
926: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry()+');
927: END IF;
928:
929: --Is tax deferred
930: BEGIN

Line 933: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry - Checking for deferred tax');

929: --Is tax deferred
930: BEGIN
931:
932: IF PG_DEBUG in ('Y', 'C') THEN
933: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry - Checking for deferred tax');
934: END IF;
935:
936: select gld.customer_trx_id
937: into l_dummy

Line 947: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry - DEFERRED TAX');

943:
944: g_ae_def_tax := TRUE; --Atleast one deferred tax line exists
945:
946: IF PG_DEBUG in ('Y', 'C') THEN
947: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry - DEFERRED TAX');
948: END IF;
949:
950: EXCEPTION
951: WHEN NO_DATA_FOUND THEN

Line 953: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry - NO DEFERRED TAX');

949:
950: EXCEPTION
951: WHEN NO_DATA_FOUND THEN
952: IF PG_DEBUG in ('Y', 'C') THEN
953: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry - NO DEFERRED TAX');
954: END IF;
955: g_ae_def_tax := FALSE; --Tax is not deferred
956: END;
957:

Line 962: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry - Check whether Rev Recognition is to be Run');

958: --Has revenue been recognized, no need to check whether invoice is complete - implied
959: BEGIN
960:
961: IF PG_DEBUG in ('Y', 'C') THEN
962: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry - Check whether Rev Recognition is to be Run');
963: END IF;
964:
965: select ctl.customer_trx_id
966: into l_dummy

Line 975: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry - Rev Recognition to be Run');

971:
972: p_rev_rec_req := TRUE;
973:
974: IF PG_DEBUG in ('Y', 'C') THEN
975: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry - Rev Recognition to be Run');
976: END IF;
977:
978: EXCEPTION
979: WHEN NO_DATA_FOUND THEN

Line 981: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry - Rev Recognition not required to be Run');

977:
978: EXCEPTION
979: WHEN NO_DATA_FOUND THEN
980: IF PG_DEBUG in ('Y', 'C') THEN
981: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry - Rev Recognition not required to be Run');
982: END IF;
983: p_rev_rec_req := FALSE;
984: END;
985:

Line 1015: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry()-');

1011: g_done_def_tax := TRUE;
1012: END IF;
1013:
1014: IF PG_DEBUG in ('Y', 'C') THEN
1015: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry()-');
1016: END IF;
1017:
1018: EXCEPTION
1019: WHEN OTHERS THEN

Line 1021: arp_standard.debug( 'EXCEPTION: ARP_ALLOCATION_PKG.Check_Entry');

1017:
1018: EXCEPTION
1019: WHEN OTHERS THEN
1020: IF PG_DEBUG in ('Y', 'C') THEN
1021: arp_standard.debug( 'EXCEPTION: ARP_ALLOCATION_PKG.Check_Entry');
1022: END IF;
1023: RAISE;
1024:
1025: END Check_Entry;

Line 1044: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Tax_Curr()+');

1040: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS
1041:
1042: BEGIN
1043: IF PG_DEBUG in ('Y', 'C') THEN
1044: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Tax_Curr()+');
1045: arp_standard.debug( ' p_invoice_id = ' || p_invoice_id);
1046: arp_standard.debug( ' p_payment_schedule_id = ' || p_payment_schedule_id);
1047: END IF;
1048:

Line 1080: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Tax_Curr()-');

1076: arp_standard.debug( ' g_ae_curr_rec.minimum_accountable_unit = ' || g_ae_curr_rec.minimum_accountable_unit);
1077: arp_standard.debug( ' g_amount_due_remaining = ' || g_amount_due_remaining);
1078: arp_standard.debug( ' g_acctd_amount_due_remaining = ' || g_acctd_amount_due_remaining);
1079: arp_standard.debug( ' g_amount_due_original = ' || g_amount_due_original);
1080: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Tax_Curr()-');
1081: END IF;
1082:
1083: EXCEPTION
1084: WHEN NO_DATA_FOUND THEN

Line 1086: arp_standard.debug('ARP_ALLOCATION_PKG.Get_Tax_Curr - NO_DATA_FOUND' );

1082:
1083: EXCEPTION
1084: WHEN NO_DATA_FOUND THEN
1085: IF PG_DEBUG in ('Y', 'C') THEN
1086: arp_standard.debug('ARP_ALLOCATION_PKG.Get_Tax_Curr - NO_DATA_FOUND' );
1087: END IF;
1088: RAISE;
1089:
1090: WHEN OTHERS THEN

Line 1092: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Get_Tax_Curr');

1088: RAISE;
1089:
1090: WHEN OTHERS THEN
1091: IF PG_DEBUG in ('Y', 'C') THEN
1092: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Get_Tax_Curr');
1093: END IF;
1094: RAISE;
1095:
1096: END Get_Tax_Curr;

Line 1209: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Invoice_Distributions()+');

1205:
1206: BEGIN
1207:
1208: IF PG_DEBUG in ('Y', 'C') THEN
1209: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Invoice_Distributions()+');
1210: END IF;
1211: /*------------------------------------------------------------------------------+
1212: | Initialise revenue, tax amounts and accounted amounts |
1213: +------------------------------------------------------------------------------*/

Line 2490: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Invoice_Distributions()-');

2486: arp_standard.debug('Get_Invoice_Distributions: ' || 'g_ae_rule_rec.def_tax_amt = '||
2487: g_ae_rule_rec.def_tax_amt);
2488: arp_standard.debug('Get_Invoice_Distributions: ' || 'g_ae_rule_rec.def_tax_acctd_amt = '||
2489: g_ae_rule_rec.def_tax_acctd_amt);
2490: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Invoice_Distributions()-');
2491: END IF;
2492:
2493:
2494: EXCEPTION

Line 2497: arp_standard.debug('Invalid Tax ccid - ARP_ALLOCATION_PKG.Get_Invoice_Distributions' );

2493:
2494: EXCEPTION
2495: WHEN invalid_ccid_error THEN
2496: IF PG_DEBUG in ('Y', 'C') THEN
2497: arp_standard.debug('Invalid Tax ccid - ARP_ALLOCATION_PKG.Get_Invoice_Distributions' );
2498: END IF;
2499: fnd_message.set_name('AR','AR_INVALID_TAX_ACCOUNT');
2500: RAISE;
2501:

Line 2504: arp_standard.debug('ram_api_error - ARP_ALLOCATION_PKG.Get_Invoice_Distributions' );

2500: RAISE;
2501:
2502: WHEN ram_api_error THEN
2503: IF PG_DEBUG in ('Y', 'C') THEN
2504: arp_standard.debug('ram_api_error - ARP_ALLOCATION_PKG.Get_Invoice_Distributions' );
2505: END IF;
2506: RAISE;
2507:
2508: WHEN NO_DATA_FOUND THEN

Line 2510: arp_standard.debug('ARP_ALLOCATION_PKG.Get_Invoice_Distributions - NO_DATA_FOUND' );

2506: RAISE;
2507:
2508: WHEN NO_DATA_FOUND THEN
2509: IF PG_DEBUG in ('Y', 'C') THEN
2510: arp_standard.debug('ARP_ALLOCATION_PKG.Get_Invoice_Distributions - NO_DATA_FOUND' );
2511: END IF;
2512: RAISE;
2513:
2514: WHEN OTHERS THEN

Line 2516: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Get_Invoice_Distributions');

2512: RAISE;
2513:
2514: WHEN OTHERS THEN
2515: IF PG_DEBUG in ('Y', 'C') THEN
2516: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Get_Invoice_Distributions');
2517: END IF;
2518: RAISE;
2519:
2520: END Get_Invoice_Distributions;

Line 2570: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Tax_Link_Id()+');

2566: l_set_pay_link VARCHAR2(1) := 'N';
2567:
2568: BEGIN
2569: IF PG_DEBUG in ('Y', 'C') THEN
2570: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Tax_Link_Id()+');
2571: END IF;
2572:
2573: l_link_ctr := g_link_ctr;
2574:

Line 2747: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Tax_Link_Id()-');

2743:
2744: END IF; --End if tax code source is ACTIVITY
2745:
2746: IF PG_DEBUG in ('Y', 'C') THEN
2747: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Tax_Link_Id()-');
2748: END IF;
2749:
2750: EXCEPTION
2751: WHEN NO_DATA_FOUND THEN

Line 2754: arp_standard.debug('ARP_ALLOCATION_PKG.Get_Tax_Link_Id - NO_DATA_FOUND' );

2750: EXCEPTION
2751: WHEN NO_DATA_FOUND THEN
2752: IF PG_DEBUG in ('Y', 'C') THEN
2753: arp_standard.debug('Get_Tax_Link_Id: ' || 'SQLERRM ' || SQLERRM);
2754: arp_standard.debug('ARP_ALLOCATION_PKG.Get_Tax_Link_Id - NO_DATA_FOUND' );
2755: END IF;
2756: RAISE;
2757:
2758: WHEN OTHERS THEN

Line 2761: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Get_Tax_Link_Id');

2757:
2758: WHEN OTHERS THEN
2759: IF PG_DEBUG in ('Y', 'C') THEN
2760: arp_standard.debug('Get_Tax_Link_Id: ' || 'SQLERRM ' || SQLERRM);
2761: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Get_Tax_Link_Id');
2762: END IF;
2763: RAISE;
2764:
2765: END Get_Tax_Link_Id;

Line 2858: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Override_Accounts ');

2854:
2855: EXCEPTION
2856: WHEN OTHERS THEN
2857: IF PG_DEBUG in ('Y', 'C') THEN
2858: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Override_Accounts ');
2859: END IF;
2860: RAISE;
2861:
2862: END Override_Accounts;

Line 2883: arp_standard.debug( 'ARP_ALLOCATION_PKG.Process_Amounts()+');

2879:
2880: BEGIN
2881:
2882: IF PG_DEBUG in ('Y', 'C') THEN
2883: arp_standard.debug( 'ARP_ALLOCATION_PKG.Process_Amounts()+');
2884: END IF;
2885:
2886: /*------------------------------------------------------------------------------+
2887: | Initialise revenue amounts to allocate for discounts or adjustments |

Line 3005: arp_standard.debug( 'ARP_ALLOCATION_PKG.Process_Amounts()-');

3001:
3002: END IF;
3003:
3004: IF PG_DEBUG in ('Y', 'C') THEN
3005: arp_standard.debug( 'ARP_ALLOCATION_PKG.Process_Amounts()-');
3006: END IF;
3007:
3008: EXCEPTION
3009: WHEN OTHERS THEN

Line 3011: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Process_Amounts');

3007:
3008: EXCEPTION
3009: WHEN OTHERS THEN
3010: IF PG_DEBUG in ('Y', 'C') THEN
3011: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Process_Amounts');
3012: END IF;
3013: RAISE;
3014:
3015: END Process_Amounts;

Line 3048: arp_standard.debug( 'ARP_ALLOCATION_PKG.Doc_Tax_Acct_Rule()+');

3044:
3045: BEGIN
3046:
3047: IF PG_DEBUG in ('Y', 'C') THEN
3048: arp_standard.debug( 'ARP_ALLOCATION_PKG.Doc_Tax_Acct_Rule()+');
3049: END IF;
3050:
3051: /*-------------------------------------------------------------------------------+
3052: | Get Rules so that parent discount or adjustment record can be updated with the|

Line 3157: arp_standard.debug( 'ARP_ALLOCATION_PKG.Doc_Tax_Acct_Rule()-');

3153:
3154: END IF;
3155:
3156: IF PG_DEBUG in ('Y', 'C') THEN
3157: arp_standard.debug( 'ARP_ALLOCATION_PKG.Doc_Tax_Acct_Rule()-');
3158: END IF;
3159:
3160: EXCEPTION
3161: WHEN NO_DATA_FOUND THEN

Line 3163: arp_standard.debug('ARP_ALLOCATION_PKG.Doc_Tax_Acct_Rule- NO_DATA_FOUND' );

3159:
3160: EXCEPTION
3161: WHEN NO_DATA_FOUND THEN
3162: IF PG_DEBUG in ('Y', 'C') THEN
3163: arp_standard.debug('ARP_ALLOCATION_PKG.Doc_Tax_Acct_Rule- NO_DATA_FOUND' );
3164: END IF;
3165: RAISE;
3166:
3167: WHEN OTHERS THEN

Line 3169: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Doc_Tax_Acct_Rule');

3165: RAISE;
3166:
3167: WHEN OTHERS THEN
3168: IF PG_DEBUG in ('Y', 'C') THEN
3169: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Doc_Tax_Acct_Rule');
3170: END IF;
3171: RAISE;
3172:
3173: END Doc_Tax_Acct_Rule;

Line 3210: arp_standard.debug( 'ARP_ALLOCATION_PKG.Init_Amts()+');

3206:
3207: BEGIN
3208:
3209: IF PG_DEBUG in ('Y', 'C') THEN
3210: arp_standard.debug( 'ARP_ALLOCATION_PKG.Init_Amts()+');
3211: END IF;
3212:
3213: /*---------------------------------------------------------------------------+
3214: | When called from is the Wrapper routine for Bills Receivable, then the |

Line 3595: arp_standard.debug( 'ARP_ALLOCATION_PKG.Init_Amts()-');

3591: END IF; --end if revenue amount or accounted amount base is 0
3592:
3593:
3594: IF PG_DEBUG in ('Y', 'C') THEN
3595: arp_standard.debug( 'ARP_ALLOCATION_PKG.Init_Amts()-');
3596: END IF;
3597:
3598: EXCEPTION
3599: WHEN rounding_error THEN

Line 3601: arp_standard.debug('Rounding error: ARP_ALLOCATION_PKG.Init_Amts');

3597:
3598: EXCEPTION
3599: WHEN rounding_error THEN
3600: IF PG_DEBUG in ('Y', 'C') THEN
3601: arp_standard.debug('Rounding error: ARP_ALLOCATION_PKG.Init_Amts');
3602: END IF;
3603: fnd_message.set_name('AR','AR_ROUNDING_ERROR');
3604: fnd_message.set_token('ROUTINE','ARP_ALLOCATION_PKG.INIT_AMTS');
3605: RAISE;

Line 3604: fnd_message.set_token('ROUTINE','ARP_ALLOCATION_PKG.INIT_AMTS');

3600: IF PG_DEBUG in ('Y', 'C') THEN
3601: arp_standard.debug('Rounding error: ARP_ALLOCATION_PKG.Init_Amts');
3602: END IF;
3603: fnd_message.set_name('AR','AR_ROUNDING_ERROR');
3604: fnd_message.set_token('ROUTINE','ARP_ALLOCATION_PKG.INIT_AMTS');
3605: RAISE;
3606:
3607: WHEN OTHERS THEN
3608: IF PG_DEBUG in ('Y', 'C') THEN

Line 3609: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Init_Amts');

3605: RAISE;
3606:
3607: WHEN OTHERS THEN
3608: IF PG_DEBUG in ('Y', 'C') THEN
3609: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Init_Amts');
3610: END IF;
3611: RAISE;
3612:
3613: END Init_Amts;

Line 3634: arp_standard.debug('ARP_ALLOCATION_PKG.Gross_To_Activity_GL()+');

3630:
3631: BEGIN
3632:
3633: IF PG_DEBUG in ('Y', 'C') THEN
3634: arp_standard.debug('ARP_ALLOCATION_PKG.Gross_To_Activity_GL()+');
3635: END IF;
3636:
3637: /*----------------------------------------------------------------------------+
3638: | Assign Currency Exchange rate information to initialisation record |

Line 3663: arp_standard.debug( 'ARP_ALLOCATION_PKG.Gross_To_Activity_GL()-');

3659: p_ae_line_init_rec => l_ae_line_init_rec,
3660: p_build_all => TRUE );
3661:
3662: IF PG_DEBUG in ('Y', 'C') THEN
3663: arp_standard.debug( 'ARP_ALLOCATION_PKG.Gross_To_Activity_GL()-');
3664: END IF;
3665:
3666: EXCEPTION
3667: WHEN OTHERS THEN

Line 3669: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Gross_To_Activity_GL');

3665:
3666: EXCEPTION
3667: WHEN OTHERS THEN
3668: IF PG_DEBUG in ('Y', 'C') THEN
3669: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Gross_To_Activity_GL');
3670: END IF;
3671: RAISE;
3672:
3673: END Gross_To_Activity_GL;

Line 3693: arp_standard.debug('ARP_ALLOCATION_PKG.Init_Rev_Tax_Tab()+');

3689:
3690: l_ctr BINARY_INTEGER;
3691:
3692: BEGIN
3693: arp_standard.debug('ARP_ALLOCATION_PKG.Init_Rev_Tax_Tab()+');
3694:
3695: /*------------------------------------------------------------------------------+
3696: | Set the prorate amount and summarized flags to null because they may have |
3697: | been set for earned discounts. |

Line 3720: arp_standard.debug( 'ARP_ALLOCATION_PKG.Init_Rev_Tax_Tab()-');

3716: ae_tax_link_id_act = '' ,
3717: ae_counted_flag = 'N'
3718: WHERE ae_id = g_id;
3719:
3720: arp_standard.debug( 'ARP_ALLOCATION_PKG.Init_Rev_Tax_Tab()-');
3721:
3722: EXCEPTION
3723: WHEN OTHERS THEN
3724: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Init_Rev_Tax_Tab');

Line 3724: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Init_Rev_Tax_Tab');

3720: arp_standard.debug( 'ARP_ALLOCATION_PKG.Init_Rev_Tax_Tab()-');
3721:
3722: EXCEPTION
3723: WHEN OTHERS THEN
3724: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Init_Rev_Tax_Tab');
3725: RAISE;
3726:
3727: END Init_Rev_Tax_Tab;
3728:

Line 3749: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Acctd_Amt()-');

3745:
3746: BEGIN
3747:
3748: IF PG_DEBUG in ('Y', 'C') THEN
3749: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Acctd_Amt()-');
3750: END IF;
3751:
3752: l_acctd_amount := arpcurr.functional_amount(p_amount ,
3753: g_ae_sys_rec.base_currency ,

Line 3759: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Acctd_Amt()-');

3755: g_ae_sys_rec.base_precision ,
3756: g_ae_sys_rec.base_min_acc_unit );
3757:
3758: IF PG_DEBUG in ('Y', 'C') THEN
3759: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Acctd_Amt()-');
3760: END IF;
3761:
3762: RETURN l_acctd_amount ;
3763:

Line 3767: arp_standard.debug('Get_Acctd_Amt: ' || 'EXCEPTION: ARP_ALLOCATION_PKG.Init_Amts');

3763:
3764: EXCEPTION
3765: WHEN OTHERS THEN
3766: IF PG_DEBUG in ('Y', 'C') THEN
3767: arp_standard.debug('Get_Acctd_Amt: ' || 'EXCEPTION: ARP_ALLOCATION_PKG.Init_Amts');
3768: END IF;
3769: RAISE;
3770:
3771: END Get_Acctd_Amt;

Line 3861: arp_standard.debug( 'ARP_ALLOCATION_PKG.Alloc_Rev_Tax_Amt()+');

3857: l_last_fetch BOOLEAN;
3858: BEGIN
3859:
3860: IF PG_DEBUG in ('Y', 'C') THEN
3861: arp_standard.debug( 'ARP_ALLOCATION_PKG.Alloc_Rev_Tax_Amt()+');
3862: END IF;
3863:
3864: /*------------------------------------------------------------------------------+
3865: | Allocate discount, adjustment, finance charge amounts over revenue. The check|

Line 4378: arp_standard.debug( 'ARP_ALLOCATION_PKG.Alloc_Rev_Tax_Amt()-');

4374:
4375: END IF;
4376:
4377: IF PG_DEBUG in ('Y', 'C') THEN
4378: arp_standard.debug( 'ARP_ALLOCATION_PKG.Alloc_Rev_Tax_Amt()-');
4379: END IF;
4380:
4381: EXCEPTION
4382:

Line 4385: arp_standard.debug('Rounding Error: ARP_ALLOCATION_PKG.Alloc_Rev_Tax_Amt' );

4381: EXCEPTION
4382:
4383: WHEN rounding_error THEN
4384: IF PG_DEBUG in ('Y', 'C') THEN
4385: arp_standard.debug('Rounding Error: ARP_ALLOCATION_PKG.Alloc_Rev_Tax_Amt' );
4386: END IF;
4387: fnd_message.set_name('AR','AR_ROUNDING_ERROR');
4388: fnd_message.set_token('ROUTINE','ARP_ALLOCATION_PKG.ALLOC_REV_TAX_AMT');
4389: RAISE;

Line 4388: fnd_message.set_token('ROUTINE','ARP_ALLOCATION_PKG.ALLOC_REV_TAX_AMT');

4384: IF PG_DEBUG in ('Y', 'C') THEN
4385: arp_standard.debug('Rounding Error: ARP_ALLOCATION_PKG.Alloc_Rev_Tax_Amt' );
4386: END IF;
4387: fnd_message.set_name('AR','AR_ROUNDING_ERROR');
4388: fnd_message.set_token('ROUTINE','ARP_ALLOCATION_PKG.ALLOC_REV_TAX_AMT');
4389: RAISE;
4390:
4391: WHEN OTHERS THEN
4392: IF PG_DEBUG in ('Y', 'C') THEN

Line 4394: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Alloc_Rev_Tax_Amt');

4390:
4391: WHEN OTHERS THEN
4392: IF PG_DEBUG in ('Y', 'C') THEN
4393: arp_standard.debug('Alloc_Rev_Tax_Amt: ' || SQLERRM);
4394: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Alloc_Rev_Tax_Amt');
4395: END IF;
4396: RAISE;
4397:
4398: END Alloc_Rev_Tax_Amt;

Line 4472: arp_standard.debug( 'ARP_ALLOCATION_PKG.Set_Taxable_Amt()+');

4468:
4469: BEGIN
4470:
4471: IF PG_DEBUG in ('Y', 'C') THEN
4472: arp_standard.debug( 'ARP_ALLOCATION_PKG.Set_Taxable_Amt()+');
4473: END IF;
4474:
4475: OPEN set_taxable_and_link;
4476:

Line 4539: arp_standard.debug( 'ARP_ALLOCATION_PKG.Set_Taxable_Amt()-');

4535:
4536: CLOSE set_taxable_and_link;
4537:
4538: IF PG_DEBUG in ('Y', 'C') THEN
4539: arp_standard.debug( 'ARP_ALLOCATION_PKG.Set_Taxable_Amt()-');
4540: END IF;
4541:
4542: EXCEPTION
4543: WHEN OTHERS THEN

Line 4545: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Set_Taxable_Amt');

4541:
4542: EXCEPTION
4543: WHEN OTHERS THEN
4544: IF PG_DEBUG in ('Y', 'C') THEN
4545: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Set_Taxable_Amt');
4546: END IF;
4547: RAISE;
4548:
4549: END Set_Taxable_Amt;

Line 4634: arp_standard.debug( 'ARP_ALLOCATION_PKG.Set_Taxable_Split_Amt()+');

4630: l_prev_collected_ccid NUMBER;
4631:
4632: BEGIN
4633: IF PG_DEBUG in ('Y', 'C') THEN
4634: arp_standard.debug( 'ARP_ALLOCATION_PKG.Set_Taxable_Split_Amt()+');
4635: END IF;
4636:
4637: OPEN set_taxable_split;
4638:

Line 4723: arp_standard.debug( 'ARP_ALLOCATION_PKG.Set_Taxable_Split_Amt()-');

4719:
4720: CLOSE set_taxable_split;
4721:
4722: IF PG_DEBUG in ('Y', 'C') THEN
4723: arp_standard.debug( 'ARP_ALLOCATION_PKG.Set_Taxable_Split_Amt()-');
4724: END IF;
4725:
4726: EXCEPTION
4727: WHEN OTHERS THEN

Line 4729: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Set_Taxable_Split_Amt');

4725:
4726: EXCEPTION
4727: WHEN OTHERS THEN
4728: IF PG_DEBUG in ('Y', 'C') THEN
4729: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Set_Taxable_Split_Amt');
4730: END IF;
4731: RAISE;
4732:
4733: END Set_Taxable_Split_Amt;

Line 4807: arp_standard.debug('Allocate_Tax_To_Rev: ' || 'ARP_ALLOCATION_PKG.Alloc_Tax_To_Rev()+');

4803:
4804: BEGIN
4805:
4806: IF PG_DEBUG in ('Y', 'C') THEN
4807: arp_standard.debug('Allocate_Tax_To_Rev: ' || 'ARP_ALLOCATION_PKG.Alloc_Tax_To_Rev()+');
4808: END IF;
4809:
4810: IF (((p_type_acct = 'ED_ADJ') AND (g_ae_rule_rec.tax_code_source1 = 'NONE'))
4811: OR ((p_type_acct = 'UNED') AND (g_ae_rule_rec.tax_code_source2 = 'NONE'))) THEN

Line 5002: arp_standard.debug('Allocate_Tax_To_Rev: ' || 'ARP_ALLOCATION_PKG.Alloc_Tax_To_Rev()-');

4998:
4999: END IF; --End if TAX_CODE_SOURCE = 'NONE'
5000:
5001: IF PG_DEBUG in ('Y', 'C') THEN
5002: arp_standard.debug('Allocate_Tax_To_Rev: ' || 'ARP_ALLOCATION_PKG.Alloc_Tax_To_Rev()-');
5003: END IF;
5004:
5005: EXCEPTION
5006: WHEN rounding_error THEN

Line 5008: arp_standard.debug('Allocate_Tax_To_Rev: ' || 'Rounding Error: ARP_ALLOCATION_PKG.Alloc_Tax_To_Rev' );

5004:
5005: EXCEPTION
5006: WHEN rounding_error THEN
5007: IF PG_DEBUG in ('Y', 'C') THEN
5008: arp_standard.debug('Allocate_Tax_To_Rev: ' || 'Rounding Error: ARP_ALLOCATION_PKG.Alloc_Tax_To_Rev' );
5009: END IF;
5010: fnd_message.set_name('AR','AR_ROUNDING_ERROR');
5011: fnd_message.set_token('ROUTINE','ARP_ALLOCATION_PKG.ALLOC_TAX_TO_REV');
5012: RAISE;

Line 5011: fnd_message.set_token('ROUTINE','ARP_ALLOCATION_PKG.ALLOC_TAX_TO_REV');

5007: IF PG_DEBUG in ('Y', 'C') THEN
5008: arp_standard.debug('Allocate_Tax_To_Rev: ' || 'Rounding Error: ARP_ALLOCATION_PKG.Alloc_Tax_To_Rev' );
5009: END IF;
5010: fnd_message.set_name('AR','AR_ROUNDING_ERROR');
5011: fnd_message.set_token('ROUTINE','ARP_ALLOCATION_PKG.ALLOC_TAX_TO_REV');
5012: RAISE;
5013:
5014: WHEN OTHERS THEN
5015: IF PG_DEBUG in ('Y', 'C') THEN

Line 5016: arp_standard.debug('Allocate_Tax_To_Rev: ' || 'EXCEPTION: ARP_ALLOCATION_PKG.Alloc_Tax_To_Rev');

5012: RAISE;
5013:
5014: WHEN OTHERS THEN
5015: IF PG_DEBUG in ('Y', 'C') THEN
5016: arp_standard.debug('Allocate_Tax_To_Rev: ' || 'EXCEPTION: ARP_ALLOCATION_PKG.Alloc_Tax_To_Rev');
5017: END IF;
5018: RAISE;
5019:
5020: END Allocate_Tax_To_Rev;

Line 5046: arp_standard.debug('ARP_ALLOCATION_PKG.Set_Rev_Links()+');

5042:
5043: BEGIN
5044:
5045: IF PG_DEBUG in ('Y', 'C') THEN
5046: arp_standard.debug('ARP_ALLOCATION_PKG.Set_Rev_Links()+');
5047: END IF;
5048:
5049: /*-------------------------------------------------------------------------------+
5050: | Set Rules to determine whether Revenue link id needs to be set |

Line 5167: arp_standard.debug('ARP_ALLOCATION_PKG.Set_Rev_Links()-');

5163: arp_standard.debug(' setlink 3');
5164: --}
5165:
5166: IF PG_DEBUG in ('Y', 'C') THEN
5167: arp_standard.debug('ARP_ALLOCATION_PKG.Set_Rev_Links()-');
5168: END IF;
5169:
5170: EXCEPTION
5171: WHEN OTHERS THEN

Line 5172: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Set_Rev_Links'||SQLERRM);

5168: END IF;
5169:
5170: EXCEPTION
5171: WHEN OTHERS THEN
5172: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Set_Rev_Links'||SQLERRM);
5173: RAISE;
5174:
5175: END Set_Rev_Links;
5176:

Line 5195: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Rules()+');

5191: p_tax_code_source OUT NOCOPY VARCHAR2,
5192: p_tax_recoverable_flag OUT NOCOPY VARCHAR2) IS
5193:
5194: BEGIN
5195: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Rules()+');
5196:
5197: /*----------------------------------------------------------------------------+
5198: | Set Rules for Discounts, Adjustments and Finance charges |
5199: +----------------------------------------------------------------------------*/

Line 5217: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Rules()-');

5213: p_tax_recoverable_flag := g_ae_rule_rec.tax_recoverable_flag2 ;
5214:
5215: END IF;
5216:
5217: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Rules()-');
5218:
5219: EXCEPTION
5220: WHEN OTHERS THEN
5221: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Get_Rules');

Line 5221: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Get_Rules');

5217: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Rules()-');
5218:
5219: EXCEPTION
5220: WHEN OTHERS THEN
5221: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Get_Rules');
5222: RAISE;
5223:
5224: END Get_Rules;
5225:

Line 5248: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Lines()+');

5244: l_ae_line_init_rec ar_ae_alloc_rec_gt%ROWTYPE ;
5245:
5246: BEGIN
5247:
5248: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Lines()+');
5249:
5250: -- Get_Rules(p_type_acct => p_type_acct,
5251: -- p_gl_account_source => l_gl_account_source,
5252: -- p_tax_code_source => l_tax_code_source,

Line 5293: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Lines()-');

5289: p_tax_recoverable_flag => l_tax_recoverable_flag ,
5290: p_ae_line_init_rec => l_ae_line_init_rec );
5291:
5292: IF PG_DEBUG in ('Y', 'C') THEN
5293: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Lines()-');
5294: END IF;
5295:
5296: EXCEPTION
5297: WHEN OTHERS THEN

Line 5298: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Build_Lines');

5294: END IF;
5295:
5296: EXCEPTION
5297: WHEN OTHERS THEN
5298: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Build_Lines');
5299: RAISE;
5300:
5301: END Build_Lines;
5302:

Line 5431: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Rev()+');

5427: g_ae_summ_rev_blk_tbl summarize_rev_cur;
5428:
5429: BEGIN
5430:
5431: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Rev()+');
5432:
5433: adj_code_combination_id := '';
5434:
5435: /*----------------------------------------------------------------------------+

Line 5720: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Rev()-');

5716: END LOOP;
5717:
5718: -- END IF; --End if Build Revenue lines
5719:
5720: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Rev()-');
5721:
5722: EXCEPTION
5723: WHEN invalid_ccid_error THEN
5724: arp_standard.debug('Invalid Tax ccid - ARP_ALLOCATION_PKG.Build_Rev' );

Line 5724: arp_standard.debug('Invalid Tax ccid - ARP_ALLOCATION_PKG.Build_Rev' );

5720: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Rev()-');
5721:
5722: EXCEPTION
5723: WHEN invalid_ccid_error THEN
5724: arp_standard.debug('Invalid Tax ccid - ARP_ALLOCATION_PKG.Build_Rev' );
5725: fnd_message.set_name('AR','AR_INVALID_TAX_ACCOUNT');
5726: RAISE;
5727:
5728: WHEN OTHERS THEN

Line 5729: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Build_Rev');

5725: fnd_message.set_name('AR','AR_INVALID_TAX_ACCOUNT');
5726: RAISE;
5727:
5728: WHEN OTHERS THEN
5729: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Build_Rev');
5730: RAISE;
5731:
5732: END Build_Rev;
5733:

Line 5952: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Tax()+');

5948: l_multi_factor NUMBER := 1;
5949: l_actual_tax_ccid NUMBER;
5950: BEGIN
5951:
5952: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Tax()+');
5953: arp_standard.debug( 'p_tax_code_source:'||p_tax_code_source);
5954: arp_standard.debug( 'p_tax_recoverable_flag:'||p_tax_recoverable_flag);
5955:
5956:

Line 6943: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Tax()-');

6939:
6940:
6941:
6942:
6943: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Tax()-');
6944:
6945: EXCEPTION
6946: WHEN invalid_ccid_error THEN
6947: arp_standard.debug('Invalid Tax ccid - ARP_ALLOCATION_PKG.Build_Tax' );

Line 6947: arp_standard.debug('Invalid Tax ccid - ARP_ALLOCATION_PKG.Build_Tax' );

6943: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Tax()-');
6944:
6945: EXCEPTION
6946: WHEN invalid_ccid_error THEN
6947: arp_standard.debug('Invalid Tax ccid - ARP_ALLOCATION_PKG.Build_Tax' );
6948: fnd_message.set_name('AR','AR_INVALID_TAX_ACCOUNT');
6949: RAISE;
6950:
6951: WHEN OTHERS THEN

Line 6952: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Build_Tax');

6948: fnd_message.set_name('AR','AR_INVALID_TAX_ACCOUNT');
6949: RAISE;
6950:
6951: WHEN OTHERS THEN
6952: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Build_Tax');
6953: RAISE;
6954:
6955: END Build_Tax;
6956:

Line 6996: arp_standard.debug('ARP_ALLOCATION_PKG.Build_Charges_Freight_All()+');

6992: l_line_tax_acctd_amt NUMBER := 0;
6993:
6994: BEGIN
6995:
6996: arp_standard.debug('ARP_ALLOCATION_PKG.Build_Charges_Freight_All()+');
6997:
6998: adj_code_combination_id := '';
6999:
7000: /*----------------------------------------------------------------------------------+

Line 7121: arp_standard.debug('ARP_ALLOCATION_PKG.Build_Charges_Freight_All()-');

7117: Assign_Elements(l_ae_line_rec);
7118:
7119: END IF; --end if p_build_all is TRUE
7120:
7121: arp_standard.debug('ARP_ALLOCATION_PKG.Build_Charges_Freight_All()-');
7122:
7123: EXCEPTION
7124: WHEN OTHERS THEN
7125: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Build_Charges_Freight_All');

Line 7125: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Build_Charges_Freight_All');

7121: arp_standard.debug('ARP_ALLOCATION_PKG.Build_Charges_Freight_All()-');
7122:
7123: EXCEPTION
7124: WHEN OTHERS THEN
7125: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Build_Charges_Freight_All');
7126: RAISE;
7127:
7128: END Build_Charges_Freight_All;
7129:

Line 7160: arp_standard.debug( 'ARP_ALLOCATION_PKG.Substitute_Ccid()+');

7156:
7157: BEGIN
7158:
7159: IF PG_DEBUG in ('Y', 'C') THEN
7160: arp_standard.debug( 'ARP_ALLOCATION_PKG.Substitute_Ccid()+');
7161: END IF;
7162:
7163: /*----------------------------------------------------------------------------+
7164: | Set other in out variables used by flex routine |

Line 7241: arp_standard.debug( 'ARP_ALLOCATION_PKG.Substitute_Ccid()-');

7237:
7238: p_actual_ccid := l_actual_gain_loss_ccid;
7239:
7240: IF PG_DEBUG in ('Y', 'C') THEN
7241: arp_standard.debug( 'ARP_ALLOCATION_PKG.Substitute_Ccid()-');
7242: END IF;
7243:
7244: EXCEPTION
7245: WHEN flex_subs_ccid_error THEN

Line 7247: arp_standard.debug('Flexbuilder error: ARP_ALLOCATION_PKG.Substitute_Ccid');

7243:
7244: EXCEPTION
7245: WHEN flex_subs_ccid_error THEN
7246: IF PG_DEBUG in ('Y', 'C') THEN
7247: arp_standard.debug('Flexbuilder error: ARP_ALLOCATION_PKG.Substitute_Ccid');
7248: arp_standard.debug('Substitute_Ccid: ' || 'Flexbuilder error: Chart of Accounts ' || p_coa_id);
7249: arp_standard.debug('Substitute_Ccid: ' || 'Flexbuilder error: Original CCID ' || p_original_ccid);
7250: arp_standard.debug('Substitute_Ccid: ' || 'Flexbuilder error: Substitute CCID ' || p_subs_ccid);
7251: arp_standard.debug('Substitute_Ccid: ' || 'Flexbuilder error: Actual CCID ' || l_actual_gain_loss_ccid);

Line 7261: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Substitute_Ccid');

7257: RAISE;
7258:
7259: WHEN OTHERS THEN
7260: IF PG_DEBUG in ('Y', 'C') THEN
7261: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Substitute_Ccid');
7262: arp_standard.debug('Substitute_Ccid: ' || 'Flexbuilder error: Chart of Accounts ' || p_coa_id);
7263: arp_standard.debug('Substitute_Ccid: ' || 'Flexbuilder error: Original CCID ' || p_original_ccid);
7264: arp_standard.debug('Substitute_Ccid: ' || 'Flexbuilder error: Substitute CCID ' || p_subs_ccid);
7265: arp_standard.debug('Substitute_Ccid: ' || 'Flexbuilder error: Actual CCID ' || l_actual_gain_loss_ccid);

Line 7314: arp_standard.debug( 'ARP_ALLOCATION_PKG.Create_Debits_Credits()+');

7310:
7311: l_taxable_set BOOLEAN;
7312:
7313: BEGIN
7314: arp_standard.debug( 'ARP_ALLOCATION_PKG.Create_Debits_Credits()+');
7315:
7316: arp_standard.debug('p_amount ' || p_amount);
7317: arp_standard.debug('p_acctd_amount ' || p_acctd_amount);
7318: arp_standard.debug('p_taxable_amount' || p_taxable_amount);

Line 7531: arp_standard.debug( 'ARP_ALLOCATION_PKG.Create_Debits_Credits()-');

7527: -- arp_standard.debug('Start Credit Debit Dump');
7528: -- Dump_Line_Amts(p_ae_line_rec);
7529: -- arp_standard.debug('End Credit Debit Dump');
7530:
7531: arp_standard.debug( 'ARP_ALLOCATION_PKG.Create_Debits_Credits()-');
7532:
7533: EXCEPTION
7534: WHEN OTHERS THEN
7535: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Create_Debits_Credits');

Line 7535: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Create_Debits_Credits');

7531: arp_standard.debug( 'ARP_ALLOCATION_PKG.Create_Debits_Credits()-');
7532:
7533: EXCEPTION
7534: WHEN OTHERS THEN
7535: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Create_Debits_Credits');
7536: RAISE;
7537:
7538: END Create_Debits_Credits;
7539:

Line 7684: arp_standard.debug( 'ARP_ALLOCATION_PKG.Summarize_Accounting_Lines()+');

7680: a1.ae_tax_link_id);
7681: */
7682:
7683: BEGIN
7684: arp_standard.debug( 'ARP_ALLOCATION_PKG.Summarize_Accounting_Lines()+');
7685: /*------------------------------------------------------------------------------+
7686: |Summarize Accounting entries for revenue and tax to net out accounting entries|
7687: |because the table g_ae_line_tbl contains accounting for earned discounts, |
7688: |unearned discounts and payments, so the requirement for another level of |

Line 8013: arp_standard.debug( 'ARP_ALLOCATION_PKG.Summarize_Accounting_Lines()-');

8009: END IF;
8010:
8011: --g_ae_summ_ctr := l_summ_ctr;
8012:
8013: arp_standard.debug( 'ARP_ALLOCATION_PKG.Summarize_Accounting_Lines()-');
8014:
8015: EXCEPTION
8016: WHEN OTHERS THEN
8017: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Summarize_Accounting_Lines:'||SQLERRM);

Line 8017: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Summarize_Accounting_Lines:'||SQLERRM);

8013: arp_standard.debug( 'ARP_ALLOCATION_PKG.Summarize_Accounting_Lines()-');
8014:
8015: EXCEPTION
8016: WHEN OTHERS THEN
8017: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Summarize_Accounting_Lines:'||SQLERRM);
8018: RAISE;
8019:
8020: END Summarize_Accounting_Lines;
8021:

Line 8146: arp_standard.debug( 'ARP_ALLOCATION_PKG.Assign_Elements()+');

8142: PROCEDURE Assign_Elements(p_ae_line_rec IN ar_ae_alloc_rec_gt%ROWTYPE) IS
8143:
8144: BEGIN
8145: IF PG_DEBUG IN ('Y','C') THEN
8146: arp_standard.debug( 'ARP_ALLOCATION_PKG.Assign_Elements()+');
8147: END IF;
8148: /*------------------------------------------------------+
8149: | Store AE Line elements in AE Lines temp table |
8150: +------------------------------------------------------*/

Line 8311: arp_standard.debug( 'ARP_ALLOCATION_PKG.Assign_Elements()-');

8307:
8308: Dump_Line_Amts(p_ae_line_rec);
8309:
8310: IF PG_DEBUG IN ('Y','C') THEN
8311: arp_standard.debug( 'ARP_ALLOCATION_PKG.Assign_Elements()-');
8312: END IF;
8313: EXCEPTION
8314: WHEN OTHERS THEN
8315: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Assign_Elements');

Line 8315: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Assign_Elements');

8311: arp_standard.debug( 'ARP_ALLOCATION_PKG.Assign_Elements()-');
8312: END IF;
8313: EXCEPTION
8314: WHEN OTHERS THEN
8315: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Assign_Elements');
8316: RAISE;
8317:
8318: END Assign_Elements;
8319:

Line 8342: arp_standard.debug( 'ARP_ALLOCATION_PKG.Insert_Ae_Lines()+');

8338: l_dummy ar_distributions.line_id%TYPE;
8339:
8340: BEGIN
8341:
8342: arp_standard.debug( 'ARP_ALLOCATION_PKG.Insert_Ae_Lines()+');
8343:
8344: -- Initialize
8345: l_ae_line_rec := l_ae_line_rec_empty;
8346:

Line 8463: arp_standard.debug( 'ARP_ALLOCATION_PKG.Cache_Ae_Lines()+');

8459: BEGIN
8460:
8461:
8462: IF PG_DEBUG in ('Y', 'C') THEN
8463: arp_standard.debug( 'ARP_ALLOCATION_PKG.Cache_Ae_Lines()+');
8464: END IF;
8465:
8466: g_ae_summ_ctr := g_ae_summ_ctr + 1;
8467:

Line 8509: arp_standard.debug( 'ARP_ALLOCATION_PKG.Cache_Ae_Lines()-');

8505:
8506:
8507:
8508: IF PG_DEBUG in ('Y', 'C') THEN
8509: arp_standard.debug( 'ARP_ALLOCATION_PKG.Cache_Ae_Lines()-');
8510: END IF;
8511:
8512: EXCEPTION
8513: WHEN OTHERS THEN

Line 8515: arp_standard.debug( 'OTHERS EXCEPTION : ARP_ALLOCATION_PKG.Cache_Ae_Lines()');

8511:
8512: EXCEPTION
8513: WHEN OTHERS THEN
8514: IF PG_DEBUG in ('Y', 'C') THEN
8515: arp_standard.debug( 'OTHERS EXCEPTION : ARP_ALLOCATION_PKG.Cache_Ae_Lines()');
8516: END IF;
8517:
8518: END Cache_Ae_Lines;
8519:

Line 8578: arp_standard.debug( 'ARP_ALLOCATION_PKG.Dump_Alloc_Rev_Tax()+');

8574: PROCEDURE Dump_Alloc_Rev_Tax(p_type IN VARCHAR2, p_alloc_rec IN ar_ae_alloc_rec_gt%ROWTYPE) IS
8575:
8576: BEGIN
8577: IF PG_DEBUG in ('Y', 'C') THEN
8578: arp_standard.debug( 'ARP_ALLOCATION_PKG.Dump_Alloc_Rev_Tax()+');
8579: arp_standard.debug('Dump_Alloc_Rev_Tax: ' || 'g_ae_alloc_'||p_type||'_tbl.ae_id = ' ||
8580: p_alloc_rec.ae_id);
8581: arp_standard.debug('Dump_Alloc_Rev_Tax: ' || 'g_ae_alloc_'||p_type||'_tbl.ae_account_class = ' ||
8582: p_alloc_rec.ae_account_class);

Line 8653: arp_standard.debug( 'ARP_ALLOCATION_PKG.Dump_Alloc_Rev_Tax()-');

8649: arp_standard.debug('Dump_Alloc_Rev_Tax: ' || 'g_ae_alloc_'||p_type||'_tbl.ae_summarize_flag= ' ||
8650: p_alloc_rec.ae_summarize_flag);
8651: arp_standard.debug('Dump_Alloc_Rev_Tax: ' || 'g_ae_alloc_'||p_type||'_tbl.ae_counted_flag = ' ||
8652: p_alloc_rec.ae_counted_flag);
8653: arp_standard.debug( 'ARP_ALLOCATION_PKG.Dump_Alloc_Rev_Tax()-');
8654: END IF;
8655: EXCEPTION
8656: WHEN OTHERS THEN
8657: IF PG_DEBUG in ('Y', 'C') THEN

Line 8658: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Dump_Alloc_Rev_Tax');

8654: END IF;
8655: EXCEPTION
8656: WHEN OTHERS THEN
8657: IF PG_DEBUG in ('Y', 'C') THEN
8658: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Dump_Alloc_Rev_Tax');
8659: END IF;
8660: RAISE;
8661:
8662: END Dump_Alloc_Rev_Tax;

Line 8682: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Init_Amts()+');

8678: p_app_rec IN ar_receivable_applications%ROWTYPE,
8679: p_adj_rec IN ar_adjustments%ROWTYPE ) IS
8680: BEGIN
8681: IF PG_DEBUG in ('Y', 'C') THEN
8682: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Init_Amts()+');
8683: arp_standard.debug('Dump_Init_Amts: ' || 'p_type_acct = ' || p_type_acct);
8684: END IF;
8685:
8686: IF p_type_acct = 'ED_ADJ' AND g_ae_doc_rec.source_table = 'RA' THEN

Line 8742: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Init_Amts()-');

8738: arp_standard.debug('Dump_Init_Amts: ' || 'g_ae_rule_rec.freight_amt_alloc = '||g_ae_rule_rec.freight_amt_alloc);
8739: arp_standard.debug('Dump_Init_Amts: ' || 'g_ae_rule_rec.freight_acctd_amt_alloc = '||g_ae_rule_rec.freight_acctd_amt_alloc);
8740: arp_standard.debug('Dump_Init_Amts: ' || 'g_ae_rule_rec.charges_amt_alloc = '||g_ae_rule_rec.charges_amt_alloc);
8741: arp_standard.debug('Dump_Init_Amts: ' || 'g_ae_rule_rec.charges_acctd_amt_alloc = '||g_ae_rule_rec.charges_acctd_amt_alloc);
8742: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Init_Amts()-');
8743: END IF;
8744:
8745: EXCEPTION
8746: WHEN OTHERS THEN

Line 8748: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Dump_Init_Amts');

8744:
8745: EXCEPTION
8746: WHEN OTHERS THEN
8747: IF PG_DEBUG in ('Y', 'C') THEN
8748: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Dump_Init_Amts');
8749: END IF;
8750: RAISE;
8751:
8752: END Dump_Init_Amts;

Line 8769: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Line_Amts()+');

8765: PROCEDURE Dump_Line_Amts(p_ae_line_rec IN ar_ae_alloc_rec_gt%ROWTYPE) IS
8766:
8767: BEGIN
8768:
8769: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Line_Amts()+');
8770: arp_standard.debug('Dump_Line_Amts: ' || 'ae_id = ' || p_ae_line_rec.ae_id);
8771: arp_standard.debug('Dump_Line_Amts: ' || 'ae_line_type = ' || p_ae_line_rec.ae_line_type);
8772: arp_standard.debug('Dump_Line_Amts: ' || 'ae_line_type_secondary = ' || p_ae_line_rec.ae_line_type_secondary);
8773: arp_standard.debug('Dump_Line_Amts: ' || 'ae_source_id = ' || p_ae_line_rec.ae_source_id);

Line 8808: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Line_Amts()-');

8804: arp_standard.debug('Dump_Line_Amts: ' || 'ref_line_id = ' || p_ae_line_rec.ae_ref_line_id);
8805: arp_standard.debug('Dump_Line_Amts: ' || 'ref_dist_ccid = ' || p_ae_line_rec.ref_dist_ccid);
8806: arp_standard.debug('Dump_Line_Amts: ' || 'ref_mf_dist_flag = ' || p_ae_line_rec.ref_mf_dist_flag);
8807:
8808: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Line_Amts()-');
8809:
8810: EXCEPTION
8811: WHEN OTHERS THEN
8812: IF PG_DEBUG in ('Y', 'C') THEN

Line 8813: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Dump_Line_Amts');

8809:
8810: EXCEPTION
8811: WHEN OTHERS THEN
8812: IF PG_DEBUG in ('Y', 'C') THEN
8813: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Dump_Line_Amts');
8814: END IF;
8815: RAISE;
8816:
8817: END Dump_Line_Amts;

Line 8834: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Dist_Amts()+');

8830: PROCEDURE Dump_Dist_Amts(p_ae_line_rec IN ar_distributions%ROWTYPE) IS
8831: BEGIN
8832:
8833: IF PG_DEBUG in ('Y', 'C') THEN
8834: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Dist_Amts()+');
8835: arp_standard.debug('Dump_Dist_Amts: ' || 'ae_id = ' || g_id);
8836: arp_standard.debug('Dump_Dist_Amts: ' || 'source_type = ' || p_ae_line_rec.source_type);
8837: arp_standard.debug('Dump_Dist_Amts: ' || 'source_type_secondary = ' || p_ae_line_rec.source_type_secondary);
8838: arp_standard.debug('Dump_Dist_Amts: ' || 'source_id = ' || p_ae_line_rec.source_id);

Line 8862: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Dist_Amts()-');

8858: arp_standard.debug('Dump_Dist_Amts: ' || 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
8859: arp_standard.debug('Dump_Dist_Amts: ' || 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
8860: arp_standard.debug('Dump_Dist_Amts: ' || 'tax_link_id = ' || p_ae_line_rec.tax_link_id);
8861: arp_standard.debug('Dump_Dist_Amts: ' || 'reversed_source_id = ' || p_ae_line_rec.reversed_source_id);
8862: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Dist_Amts()-');
8863: END IF;
8864:
8865: EXCEPTION
8866: WHEN OTHERS THEN

Line 8868: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Dump_Dist_Amts');

8864:
8865: EXCEPTION
8866: WHEN OTHERS THEN
8867: IF PG_DEBUG in ('Y', 'C') THEN
8868: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Dump_Dist_Amts');
8869: END IF;
8870: RAISE;
8871:
8872: END Dump_Dist_Amts;

Line 9106: END ARP_ALLOCATION_PKG;

9102: END IF;
9103: END;
9104:
9105:
9106: END ARP_ALLOCATION_PKG;