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.115 2011/04/01 02:31:46 spdixit ship $ */
3:
4: /*=======================================================================+
5: | Global Constants

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

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

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

968: END IF;
969:
970: <>
971: IF PG_DEBUG in ('Y', 'C') THEN
972: arp_standard.debug( 'ARP_ALLOCATION_PKG.Allocate_Tax()-');
973: END IF;
974:
975: EXCEPTION
976: WHEN NO_DATA_FOUND THEN

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

974:
975: EXCEPTION
976: WHEN NO_DATA_FOUND THEN
977: IF PG_DEBUG in ('Y', 'C') THEN
978: arp_standard.debug( 'ARP_ALLOCATION_PKG.Allocate_Tax - NO_DATA_FOUND' );
979: END IF;
980: RAISE;
981:
982: WHEN What_kind_of_activity THEN

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

980: RAISE;
981:
982: WHEN What_kind_of_activity THEN
983: IF PG_DEBUG in ('Y', 'C') THEN
984: arp_standard.debug( 'EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax - What_kind_of_activity');
985: END IF;
986: RAISE;
987:
988: WHEN impossible_adjust THEN

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

986: RAISE;
987:
988: WHEN impossible_adjust THEN
989: IF PG_DEBUG in ('Y', 'C') THEN
990: arp_standard.debug( 'EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax - impossible_adjust');
991: END IF;
992: RAISE;
993:
994: WHEN OTHERS THEN

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

992: RAISE;
993:
994: WHEN OTHERS THEN
995: IF PG_DEBUG in ('Y', 'C') THEN
996: arp_standard.debug( 'EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax:'||SQLERRM);
997: END IF;
998: RAISE;
999:
1000: END Allocate_Tax;

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

1025:
1026: BEGIN
1027:
1028: IF PG_DEBUG in ('Y', 'C') THEN
1029: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry()+');
1030: END IF;
1031:
1032: --Is tax deferred
1033: BEGIN

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

1032: --Is tax deferred
1033: BEGIN
1034:
1035: IF PG_DEBUG in ('Y', 'C') THEN
1036: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry - Checking for deferred tax');
1037: END IF;
1038:
1039: select gld.customer_trx_id
1040: into l_dummy

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

1046:
1047: l_ae_def_tax := TRUE; --Atleast one deferred tax line exists
1048:
1049: IF PG_DEBUG in ('Y', 'C') THEN
1050: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry - DEFERRED TAX');
1051: END IF;
1052:
1053: EXCEPTION
1054: WHEN NO_DATA_FOUND THEN

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

1052:
1053: EXCEPTION
1054: WHEN NO_DATA_FOUND THEN
1055: IF PG_DEBUG in ('Y', 'C') THEN
1056: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry - NO DEFERRED TAX');
1057: END IF;
1058: l_ae_def_tax := FALSE; --Tax is not deferred
1059: END;
1060:

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

1077: p_required := FALSE;
1078: END IF;
1079:
1080: IF PG_DEBUG in ('Y', 'C') THEN
1081: arp_standard.debug( 'ARP_ALLOCATION_PKG.Check_Entry()-');
1082: END IF;
1083:
1084: EXCEPTION
1085: WHEN OTHERS THEN

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

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

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

1105: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS
1106:
1107: BEGIN
1108: IF PG_DEBUG in ('Y', 'C') THEN
1109: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Tax_Curr()+');
1110: arp_standard.debug( ' p_invoice_id = ' || p_invoice_id);
1111: arp_standard.debug( ' p_payment_schedule_id = ' || p_payment_schedule_id);
1112: END IF;
1113:

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

1141: arp_standard.debug( ' g_ae_curr_rec.minimum_accountable_unit = ' || g_ae_curr_rec.minimum_accountable_unit);
1142: arp_standard.debug( ' g_amount_due_remaining = ' || g_amount_due_remaining);
1143: arp_standard.debug( ' g_acctd_amount_due_remaining = ' || g_acctd_amount_due_remaining);
1144: arp_standard.debug( ' g_amount_due_original = ' || g_amount_due_original);
1145: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Tax_Curr()-');
1146: END IF;
1147:
1148: EXCEPTION
1149: WHEN NO_DATA_FOUND THEN

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

1147:
1148: EXCEPTION
1149: WHEN NO_DATA_FOUND THEN
1150: IF PG_DEBUG in ('Y', 'C') THEN
1151: arp_standard.debug('ARP_ALLOCATION_PKG.Get_Tax_Curr - NO_DATA_FOUND' );
1152: END IF;
1153: RAISE;
1154:
1155: WHEN OTHERS THEN

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

1153: RAISE;
1154:
1155: WHEN OTHERS THEN
1156: IF PG_DEBUG in ('Y', 'C') THEN
1157: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Get_Tax_Curr');
1158: END IF;
1159: RAISE;
1160:
1161: END Get_Tax_Curr;

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

1274:
1275: BEGIN
1276:
1277: IF PG_DEBUG in ('Y', 'C') THEN
1278: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Invoice_Distributions()+');
1279: END IF;
1280: /*------------------------------------------------------------------------------+
1281: | Initialise revenue, tax amounts and accounted amounts |
1282: +------------------------------------------------------------------------------*/

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

2772: arp_standard.debug('Get_Invoice_Distributions: ' || 'g_ae_rule_rec.def_tax_amt = '||
2773: g_ae_rule_rec.def_tax_amt);
2774: arp_standard.debug('Get_Invoice_Distributions: ' || 'g_ae_rule_rec.def_tax_acctd_amt = '||
2775: g_ae_rule_rec.def_tax_acctd_amt);
2776: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Invoice_Distributions()-');
2777: END IF;
2778:
2779:
2780: EXCEPTION

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

2779:
2780: EXCEPTION
2781: WHEN invalid_ccid_error THEN
2782: IF PG_DEBUG in ('Y', 'C') THEN
2783: arp_standard.debug('Invalid Tax ccid - ARP_ALLOCATION_PKG.Get_Invoice_Distributions' );
2784: END IF;
2785: fnd_message.set_name('AR','AR_INVALID_TAX_ACCOUNT');
2786: RAISE;
2787:

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

2786: RAISE;
2787:
2788: WHEN ram_api_error THEN
2789: IF PG_DEBUG in ('Y', 'C') THEN
2790: arp_standard.debug('ram_api_error - ARP_ALLOCATION_PKG.Get_Invoice_Distributions' );
2791: END IF;
2792: RAISE;
2793:
2794: WHEN NO_DATA_FOUND THEN

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

2792: RAISE;
2793:
2794: WHEN NO_DATA_FOUND THEN
2795: IF PG_DEBUG in ('Y', 'C') THEN
2796: arp_standard.debug('ARP_ALLOCATION_PKG.Get_Invoice_Distributions - NO_DATA_FOUND' );
2797: END IF;
2798: RAISE;
2799:
2800: WHEN OTHERS THEN

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

2798: RAISE;
2799:
2800: WHEN OTHERS THEN
2801: IF PG_DEBUG in ('Y', 'C') THEN
2802: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Get_Invoice_Distributions');
2803: END IF;
2804: RAISE;
2805:
2806: END Get_Invoice_Distributions;

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

2852: l_set_pay_link VARCHAR2(1) := 'N';
2853:
2854: BEGIN
2855: IF PG_DEBUG in ('Y', 'C') THEN
2856: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Tax_Link_Id()+');
2857: END IF;
2858:
2859: l_link_ctr := g_link_ctr;
2860:

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

3029:
3030: END IF; --End if tax code source is ACTIVITY
3031:
3032: IF PG_DEBUG in ('Y', 'C') THEN
3033: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Tax_Link_Id()-');
3034: END IF;
3035:
3036: EXCEPTION
3037: WHEN NO_DATA_FOUND THEN

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

3036: EXCEPTION
3037: WHEN NO_DATA_FOUND THEN
3038: IF PG_DEBUG in ('Y', 'C') THEN
3039: arp_standard.debug('Get_Tax_Link_Id: ' || 'SQLERRM ' || SQLERRM);
3040: arp_standard.debug('ARP_ALLOCATION_PKG.Get_Tax_Link_Id - NO_DATA_FOUND' );
3041: END IF;
3042: RAISE;
3043:
3044: WHEN OTHERS THEN

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

3043:
3044: WHEN OTHERS THEN
3045: IF PG_DEBUG in ('Y', 'C') THEN
3046: arp_standard.debug('Get_Tax_Link_Id: ' || 'SQLERRM ' || SQLERRM);
3047: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Get_Tax_Link_Id');
3048: END IF;
3049: RAISE;
3050:
3051: END Get_Tax_Link_Id;

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

3140:
3141: EXCEPTION
3142: WHEN OTHERS THEN
3143: IF PG_DEBUG in ('Y', 'C') THEN
3144: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Override_Accounts ');
3145: END IF;
3146: RAISE;
3147:
3148: END Override_Accounts;

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

3165:
3166: BEGIN
3167:
3168: IF PG_DEBUG in ('Y', 'C') THEN
3169: arp_standard.debug( 'ARP_ALLOCATION_PKG.Process_Amounts()+');
3170: END IF;
3171:
3172: /*------------------------------------------------------------------------------+
3173: | Initialise revenue amounts to allocate for discounts or adjustments |

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

3287:
3288: END IF;
3289:
3290: IF PG_DEBUG in ('Y', 'C') THEN
3291: arp_standard.debug( 'ARP_ALLOCATION_PKG.Process_Amounts()-');
3292: END IF;
3293:
3294: EXCEPTION
3295: WHEN OTHERS THEN

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

3293:
3294: EXCEPTION
3295: WHEN OTHERS THEN
3296: IF PG_DEBUG in ('Y', 'C') THEN
3297: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Process_Amounts');
3298: END IF;
3299: RAISE;
3300:
3301: END Process_Amounts;

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

3330:
3331: BEGIN
3332:
3333: IF PG_DEBUG in ('Y', 'C') THEN
3334: arp_standard.debug( 'ARP_ALLOCATION_PKG.Doc_Tax_Acct_Rule()+');
3335: END IF;
3336:
3337: /*-------------------------------------------------------------------------------+
3338: | Get Rules so that parent discount or adjustment record can be updated with the|

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

3439:
3440: END IF;
3441:
3442: IF PG_DEBUG in ('Y', 'C') THEN
3443: arp_standard.debug( 'ARP_ALLOCATION_PKG.Doc_Tax_Acct_Rule()-');
3444: END IF;
3445:
3446: EXCEPTION
3447: WHEN NO_DATA_FOUND THEN

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

3445:
3446: EXCEPTION
3447: WHEN NO_DATA_FOUND THEN
3448: IF PG_DEBUG in ('Y', 'C') THEN
3449: arp_standard.debug('ARP_ALLOCATION_PKG.Doc_Tax_Acct_Rule- NO_DATA_FOUND' );
3450: END IF;
3451: RAISE;
3452:
3453: WHEN OTHERS THEN

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

3451: RAISE;
3452:
3453: WHEN OTHERS THEN
3454: IF PG_DEBUG in ('Y', 'C') THEN
3455: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Doc_Tax_Acct_Rule');
3456: END IF;
3457: RAISE;
3458:
3459: END Doc_Tax_Acct_Rule;

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

3492:
3493: BEGIN
3494:
3495: IF PG_DEBUG in ('Y', 'C') THEN
3496: arp_standard.debug( 'ARP_ALLOCATION_PKG.Init_Amts()+');
3497: END IF;
3498:
3499: /*---------------------------------------------------------------------------+
3500: | When called from is the Wrapper routine for Bills Receivable, then the |

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

3877: END IF; --end if revenue amount or accounted amount base is 0
3878:
3879:
3880: IF PG_DEBUG in ('Y', 'C') THEN
3881: arp_standard.debug( 'ARP_ALLOCATION_PKG.Init_Amts()-');
3882: END IF;
3883:
3884: EXCEPTION
3885: WHEN rounding_error THEN

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

3883:
3884: EXCEPTION
3885: WHEN rounding_error THEN
3886: IF PG_DEBUG in ('Y', 'C') THEN
3887: arp_standard.debug('Rounding error: ARP_ALLOCATION_PKG.Init_Amts');
3888: END IF;
3889: fnd_message.set_name('AR','AR_ROUNDING_ERROR');
3890: fnd_message.set_token('ROUTINE','ARP_ALLOCATION_PKG.INIT_AMTS');
3891: RAISE;

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

3886: IF PG_DEBUG in ('Y', 'C') THEN
3887: arp_standard.debug('Rounding error: ARP_ALLOCATION_PKG.Init_Amts');
3888: END IF;
3889: fnd_message.set_name('AR','AR_ROUNDING_ERROR');
3890: fnd_message.set_token('ROUTINE','ARP_ALLOCATION_PKG.INIT_AMTS');
3891: RAISE;
3892:
3893: WHEN OTHERS THEN
3894: IF PG_DEBUG in ('Y', 'C') THEN

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

3891: RAISE;
3892:
3893: WHEN OTHERS THEN
3894: IF PG_DEBUG in ('Y', 'C') THEN
3895: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Init_Amts');
3896: END IF;
3897: RAISE;
3898:
3899: END Init_Amts;

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

3916:
3917: BEGIN
3918:
3919: IF PG_DEBUG in ('Y', 'C') THEN
3920: arp_standard.debug('ARP_ALLOCATION_PKG.Gross_To_Activity_GL()+');
3921: END IF;
3922:
3923: /*----------------------------------------------------------------------------+
3924: | Assign Currency Exchange rate information to initialisation record |

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

3945: p_ae_line_init_rec => l_ae_line_init_rec,
3946: p_build_all => TRUE );
3947:
3948: IF PG_DEBUG in ('Y', 'C') THEN
3949: arp_standard.debug( 'ARP_ALLOCATION_PKG.Gross_To_Activity_GL()-');
3950: END IF;
3951:
3952: EXCEPTION
3953: WHEN OTHERS THEN

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

3951:
3952: EXCEPTION
3953: WHEN OTHERS THEN
3954: IF PG_DEBUG in ('Y', 'C') THEN
3955: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Gross_To_Activity_GL');
3956: END IF;
3957: RAISE;
3958:
3959: END Gross_To_Activity_GL;

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

3975:
3976: l_ctr BINARY_INTEGER;
3977:
3978: BEGIN
3979: arp_standard.debug('ARP_ALLOCATION_PKG.Init_Rev_Tax_Tab()+');
3980:
3981: /*------------------------------------------------------------------------------+
3982: | Set the prorate amount and summarized flags to null because they may have |
3983: | been set for earned discounts. |

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

4002: ae_tax_link_id_act = '' ,
4003: ae_counted_flag = 'N'
4004: WHERE ae_id = g_id;
4005:
4006: arp_standard.debug( 'ARP_ALLOCATION_PKG.Init_Rev_Tax_Tab()-');
4007:
4008: EXCEPTION
4009: WHEN OTHERS THEN
4010: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Init_Rev_Tax_Tab');

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

4006: arp_standard.debug( 'ARP_ALLOCATION_PKG.Init_Rev_Tax_Tab()-');
4007:
4008: EXCEPTION
4009: WHEN OTHERS THEN
4010: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Init_Rev_Tax_Tab');
4011: RAISE;
4012:
4013: END Init_Rev_Tax_Tab;
4014:

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

4031:
4032: BEGIN
4033:
4034: IF PG_DEBUG in ('Y', 'C') THEN
4035: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Acctd_Amt()-');
4036: END IF;
4037:
4038: l_acctd_amount := arpcurr.functional_amount(p_amount ,
4039: g_ae_sys_rec.base_currency ,

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

4041: g_ae_sys_rec.base_precision ,
4042: g_ae_sys_rec.base_min_acc_unit );
4043:
4044: IF PG_DEBUG in ('Y', 'C') THEN
4045: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Acctd_Amt()-');
4046: END IF;
4047:
4048: RETURN l_acctd_amount ;
4049:

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

4049:
4050: EXCEPTION
4051: WHEN OTHERS THEN
4052: IF PG_DEBUG in ('Y', 'C') THEN
4053: arp_standard.debug('Get_Acctd_Amt: ' || 'EXCEPTION: ARP_ALLOCATION_PKG.Init_Amts');
4054: END IF;
4055: RAISE;
4056:
4057: END Get_Acctd_Amt;

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

4143: l_last_fetch BOOLEAN;
4144: BEGIN
4145:
4146: IF PG_DEBUG in ('Y', 'C') THEN
4147: arp_standard.debug( 'ARP_ALLOCATION_PKG.Alloc_Rev_Tax_Amt()+');
4148: END IF;
4149:
4150: /*------------------------------------------------------------------------------+
4151: | Allocate discount, adjustment, finance charge amounts over revenue. The check|

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

4660:
4661: END IF;
4662:
4663: IF PG_DEBUG in ('Y', 'C') THEN
4664: arp_standard.debug( 'ARP_ALLOCATION_PKG.Alloc_Rev_Tax_Amt()-');
4665: END IF;
4666:
4667: EXCEPTION
4668:

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

4667: EXCEPTION
4668:
4669: WHEN rounding_error THEN
4670: IF PG_DEBUG in ('Y', 'C') THEN
4671: arp_standard.debug('Rounding Error: ARP_ALLOCATION_PKG.Alloc_Rev_Tax_Amt' );
4672: END IF;
4673: fnd_message.set_name('AR','AR_ROUNDING_ERROR');
4674: fnd_message.set_token('ROUTINE','ARP_ALLOCATION_PKG.ALLOC_REV_TAX_AMT');
4675: RAISE;

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

4670: IF PG_DEBUG in ('Y', 'C') THEN
4671: arp_standard.debug('Rounding Error: ARP_ALLOCATION_PKG.Alloc_Rev_Tax_Amt' );
4672: END IF;
4673: fnd_message.set_name('AR','AR_ROUNDING_ERROR');
4674: fnd_message.set_token('ROUTINE','ARP_ALLOCATION_PKG.ALLOC_REV_TAX_AMT');
4675: RAISE;
4676:
4677: WHEN OTHERS THEN
4678: IF PG_DEBUG in ('Y', 'C') THEN

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

4676:
4677: WHEN OTHERS THEN
4678: IF PG_DEBUG in ('Y', 'C') THEN
4679: arp_standard.debug('Alloc_Rev_Tax_Amt: ' || SQLERRM);
4680: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Alloc_Rev_Tax_Amt');
4681: END IF;
4682: RAISE;
4683:
4684: END Alloc_Rev_Tax_Amt;

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

4754:
4755: BEGIN
4756:
4757: IF PG_DEBUG in ('Y', 'C') THEN
4758: arp_standard.debug( 'ARP_ALLOCATION_PKG.Set_Taxable_Amt()+');
4759: END IF;
4760:
4761: OPEN set_taxable_and_link;
4762:

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

4821:
4822: CLOSE set_taxable_and_link;
4823:
4824: IF PG_DEBUG in ('Y', 'C') THEN
4825: arp_standard.debug( 'ARP_ALLOCATION_PKG.Set_Taxable_Amt()-');
4826: END IF;
4827:
4828: EXCEPTION
4829: WHEN OTHERS THEN

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

4827:
4828: EXCEPTION
4829: WHEN OTHERS THEN
4830: IF PG_DEBUG in ('Y', 'C') THEN
4831: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Set_Taxable_Amt');
4832: END IF;
4833: RAISE;
4834:
4835: END Set_Taxable_Amt;

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

4916: l_prev_collected_ccid NUMBER;
4917:
4918: BEGIN
4919: IF PG_DEBUG in ('Y', 'C') THEN
4920: arp_standard.debug( 'ARP_ALLOCATION_PKG.Set_Taxable_Split_Amt()+');
4921: END IF;
4922:
4923: OPEN set_taxable_split;
4924:

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

5005:
5006: CLOSE set_taxable_split;
5007:
5008: IF PG_DEBUG in ('Y', 'C') THEN
5009: arp_standard.debug( 'ARP_ALLOCATION_PKG.Set_Taxable_Split_Amt()-');
5010: END IF;
5011:
5012: EXCEPTION
5013: WHEN OTHERS THEN

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

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

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

5089:
5090: BEGIN
5091:
5092: IF PG_DEBUG in ('Y', 'C') THEN
5093: arp_standard.debug('Allocate_Tax_To_Rev: ' || 'ARP_ALLOCATION_PKG.Alloc_Tax_To_Rev()+');
5094: END IF;
5095:
5096: IF (((p_type_acct = 'ED_ADJ') AND (g_ae_rule_rec.tax_code_source1 = 'NONE'))
5097: OR ((p_type_acct = 'UNED') AND (g_ae_rule_rec.tax_code_source2 = 'NONE'))) THEN

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

5284:
5285: END IF; --End if TAX_CODE_SOURCE = 'NONE'
5286:
5287: IF PG_DEBUG in ('Y', 'C') THEN
5288: arp_standard.debug('Allocate_Tax_To_Rev: ' || 'ARP_ALLOCATION_PKG.Alloc_Tax_To_Rev()-');
5289: END IF;
5290:
5291: EXCEPTION
5292: WHEN rounding_error THEN

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

5290:
5291: EXCEPTION
5292: WHEN rounding_error THEN
5293: IF PG_DEBUG in ('Y', 'C') THEN
5294: arp_standard.debug('Allocate_Tax_To_Rev: ' || 'Rounding Error: ARP_ALLOCATION_PKG.Alloc_Tax_To_Rev' );
5295: END IF;
5296: fnd_message.set_name('AR','AR_ROUNDING_ERROR');
5297: fnd_message.set_token('ROUTINE','ARP_ALLOCATION_PKG.ALLOC_TAX_TO_REV');
5298: RAISE;

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

5293: IF PG_DEBUG in ('Y', 'C') THEN
5294: arp_standard.debug('Allocate_Tax_To_Rev: ' || 'Rounding Error: ARP_ALLOCATION_PKG.Alloc_Tax_To_Rev' );
5295: END IF;
5296: fnd_message.set_name('AR','AR_ROUNDING_ERROR');
5297: fnd_message.set_token('ROUTINE','ARP_ALLOCATION_PKG.ALLOC_TAX_TO_REV');
5298: RAISE;
5299:
5300: WHEN OTHERS THEN
5301: IF PG_DEBUG in ('Y', 'C') THEN

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

5298: RAISE;
5299:
5300: WHEN OTHERS THEN
5301: IF PG_DEBUG in ('Y', 'C') THEN
5302: arp_standard.debug('Allocate_Tax_To_Rev: ' || 'EXCEPTION: ARP_ALLOCATION_PKG.Alloc_Tax_To_Rev');
5303: END IF;
5304: RAISE;
5305:
5306: END Allocate_Tax_To_Rev;

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

5328:
5329: BEGIN
5330:
5331: IF PG_DEBUG in ('Y', 'C') THEN
5332: arp_standard.debug('ARP_ALLOCATION_PKG.Set_Rev_Links()+');
5333: END IF;
5334:
5335: /*-------------------------------------------------------------------------------+
5336: | Set Rules to determine whether Revenue link id needs to be set |

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

5449: arp_standard.debug(' setlink 3');
5450: --}
5451:
5452: IF PG_DEBUG in ('Y', 'C') THEN
5453: arp_standard.debug('ARP_ALLOCATION_PKG.Set_Rev_Links()-');
5454: END IF;
5455:
5456: EXCEPTION
5457: WHEN OTHERS THEN

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

5454: END IF;
5455:
5456: EXCEPTION
5457: WHEN OTHERS THEN
5458: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Set_Rev_Links'||SQLERRM);
5459: RAISE;
5460:
5461: END Set_Rev_Links;
5462:

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

5477: p_tax_code_source OUT NOCOPY VARCHAR2,
5478: p_tax_recoverable_flag OUT NOCOPY VARCHAR2) IS
5479:
5480: BEGIN
5481: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Rules()+');
5482:
5483: /*----------------------------------------------------------------------------+
5484: | Set Rules for Discounts, Adjustments and Finance charges |
5485: +----------------------------------------------------------------------------*/

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

5499: p_tax_recoverable_flag := g_ae_rule_rec.tax_recoverable_flag2 ;
5500:
5501: END IF;
5502:
5503: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Rules()-');
5504:
5505: EXCEPTION
5506: WHEN OTHERS THEN
5507: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Get_Rules');

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

5503: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Rules()-');
5504:
5505: EXCEPTION
5506: WHEN OTHERS THEN
5507: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Get_Rules');
5508: RAISE;
5509:
5510: END Get_Rules;
5511:

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

5530: l_ae_line_init_rec ar_ae_alloc_rec_gt%ROWTYPE ;
5531:
5532: BEGIN
5533:
5534: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Lines()+');
5535:
5536: -- Get_Rules(p_type_acct => p_type_acct,
5537: -- p_gl_account_source => l_gl_account_source,
5538: -- p_tax_code_source => l_tax_code_source,

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

5575: p_tax_recoverable_flag => l_tax_recoverable_flag ,
5576: p_ae_line_init_rec => l_ae_line_init_rec );
5577:
5578: IF PG_DEBUG in ('Y', 'C') THEN
5579: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Lines()-');
5580: END IF;
5581:
5582: EXCEPTION
5583: WHEN OTHERS THEN

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

5580: END IF;
5581:
5582: EXCEPTION
5583: WHEN OTHERS THEN
5584: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Build_Lines');
5585: RAISE;
5586:
5587: END Build_Lines;
5588:

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

5713: g_ae_summ_rev_blk_tbl summarize_rev_cur;
5714:
5715: BEGIN
5716:
5717: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Rev()+');
5718:
5719: adj_code_combination_id := '';
5720:
5721: /*----------------------------------------------------------------------------+

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

6006: END LOOP;
6007:
6008: -- END IF; --End if Build Revenue lines
6009:
6010: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Rev()-');
6011:
6012: EXCEPTION
6013: WHEN invalid_ccid_error THEN
6014: arp_standard.debug('Invalid Tax ccid - ARP_ALLOCATION_PKG.Build_Rev' );

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

6010: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Rev()-');
6011:
6012: EXCEPTION
6013: WHEN invalid_ccid_error THEN
6014: arp_standard.debug('Invalid Tax ccid - ARP_ALLOCATION_PKG.Build_Rev' );
6015: fnd_message.set_name('AR','AR_INVALID_TAX_ACCOUNT');
6016: RAISE;
6017:
6018: WHEN OTHERS THEN

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

6015: fnd_message.set_name('AR','AR_INVALID_TAX_ACCOUNT');
6016: RAISE;
6017:
6018: WHEN OTHERS THEN
6019: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Build_Rev');
6020: RAISE;
6021:
6022: END Build_Rev;
6023:

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

6238: l_multi_factor NUMBER := 1;
6239: l_actual_tax_ccid NUMBER;
6240: BEGIN
6241:
6242: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Tax()+');
6243: arp_standard.debug( 'p_tax_code_source:'||p_tax_code_source);
6244: arp_standard.debug( 'p_tax_recoverable_flag:'||p_tax_recoverable_flag);
6245:
6246:

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

7230:
7231:
7232:
7233:
7234: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Tax()-');
7235:
7236: EXCEPTION
7237: WHEN invalid_ccid_error THEN
7238: arp_standard.debug('Invalid Tax ccid - ARP_ALLOCATION_PKG.Build_Tax' );

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

7234: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Tax()-');
7235:
7236: EXCEPTION
7237: WHEN invalid_ccid_error THEN
7238: arp_standard.debug('Invalid Tax ccid - ARP_ALLOCATION_PKG.Build_Tax' );
7239: fnd_message.set_name('AR','AR_INVALID_TAX_ACCOUNT');
7240: RAISE;
7241:
7242: WHEN OTHERS THEN

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

7239: fnd_message.set_name('AR','AR_INVALID_TAX_ACCOUNT');
7240: RAISE;
7241:
7242: WHEN OTHERS THEN
7243: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Build_Tax');
7244: RAISE;
7245:
7246: END Build_Tax;
7247:

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

7283: l_line_tax_acctd_amt NUMBER := 0;
7284:
7285: BEGIN
7286:
7287: arp_standard.debug('ARP_ALLOCATION_PKG.Build_Charges_Freight_All()+');
7288:
7289: adj_code_combination_id := '';
7290:
7291: /*----------------------------------------------------------------------------------+

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

7408: Assign_Elements(l_ae_line_rec);
7409:
7410: END IF; --end if p_build_all is TRUE
7411:
7412: arp_standard.debug('ARP_ALLOCATION_PKG.Build_Charges_Freight_All()-');
7413:
7414: EXCEPTION
7415: WHEN OTHERS THEN
7416: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Build_Charges_Freight_All');

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

7412: arp_standard.debug('ARP_ALLOCATION_PKG.Build_Charges_Freight_All()-');
7413:
7414: EXCEPTION
7415: WHEN OTHERS THEN
7416: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Build_Charges_Freight_All');
7417: RAISE;
7418:
7419: END Build_Charges_Freight_All;
7420:

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

7447:
7448: BEGIN
7449:
7450: IF PG_DEBUG in ('Y', 'C') THEN
7451: arp_standard.debug( 'ARP_ALLOCATION_PKG.Substitute_Ccid()+');
7452: END IF;
7453:
7454: /*----------------------------------------------------------------------------+
7455: | Set other in out variables used by flex routine |

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

7528:
7529: p_actual_ccid := l_actual_gain_loss_ccid;
7530:
7531: IF PG_DEBUG in ('Y', 'C') THEN
7532: arp_standard.debug( 'ARP_ALLOCATION_PKG.Substitute_Ccid()-');
7533: END IF;
7534:
7535: EXCEPTION
7536: WHEN flex_subs_ccid_error THEN

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

7534:
7535: EXCEPTION
7536: WHEN flex_subs_ccid_error THEN
7537: IF PG_DEBUG in ('Y', 'C') THEN
7538: arp_standard.debug('Flexbuilder error: ARP_ALLOCATION_PKG.Substitute_Ccid');
7539: arp_standard.debug('Substitute_Ccid: ' || 'Flexbuilder error: Chart of Accounts ' || p_coa_id);
7540: arp_standard.debug('Substitute_Ccid: ' || 'Flexbuilder error: Original CCID ' || p_original_ccid);
7541: arp_standard.debug('Substitute_Ccid: ' || 'Flexbuilder error: Substitute CCID ' || p_subs_ccid);
7542: arp_standard.debug('Substitute_Ccid: ' || 'Flexbuilder error: Actual CCID ' || l_actual_gain_loss_ccid);

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

7548: RAISE;
7549:
7550: WHEN OTHERS THEN
7551: IF PG_DEBUG in ('Y', 'C') THEN
7552: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Substitute_Ccid');
7553: arp_standard.debug('Substitute_Ccid: ' || 'Flexbuilder error: Chart of Accounts ' || p_coa_id);
7554: arp_standard.debug('Substitute_Ccid: ' || 'Flexbuilder error: Original CCID ' || p_original_ccid);
7555: arp_standard.debug('Substitute_Ccid: ' || 'Flexbuilder error: Substitute CCID ' || p_subs_ccid);
7556: arp_standard.debug('Substitute_Ccid: ' || 'Flexbuilder error: Actual CCID ' || l_actual_gain_loss_ccid);

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

7601:
7602: l_taxable_set BOOLEAN;
7603:
7604: BEGIN
7605: arp_standard.debug( 'ARP_ALLOCATION_PKG.Create_Debits_Credits()+');
7606:
7607: arp_standard.debug('p_amount ' || p_amount);
7608: arp_standard.debug('p_acctd_amount ' || p_acctd_amount);
7609: arp_standard.debug('p_taxable_amount' || p_taxable_amount);

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

7818: -- arp_standard.debug('Start Credit Debit Dump');
7819: -- Dump_Line_Amts(p_ae_line_rec);
7820: -- arp_standard.debug('End Credit Debit Dump');
7821:
7822: arp_standard.debug( 'ARP_ALLOCATION_PKG.Create_Debits_Credits()-');
7823:
7824: EXCEPTION
7825: WHEN OTHERS THEN
7826: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Create_Debits_Credits');

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

7822: arp_standard.debug( 'ARP_ALLOCATION_PKG.Create_Debits_Credits()-');
7823:
7824: EXCEPTION
7825: WHEN OTHERS THEN
7826: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Create_Debits_Credits');
7827: RAISE;
7828:
7829: END Create_Debits_Credits;
7830:

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

7971: a1.ae_tax_link_id);
7972: */
7973:
7974: BEGIN
7975: arp_standard.debug( 'ARP_ALLOCATION_PKG.Summarize_Accounting_Lines()+');
7976: /*------------------------------------------------------------------------------+
7977: |Summarize Accounting entries for revenue and tax to net out accounting entries|
7978: |because the table g_ae_line_tbl contains accounting for earned discounts, |
7979: |unearned discounts and payments, so the requirement for another level of |

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

8300: END IF;
8301:
8302: --g_ae_summ_ctr := l_summ_ctr;
8303:
8304: arp_standard.debug( 'ARP_ALLOCATION_PKG.Summarize_Accounting_Lines()-');
8305:
8306: EXCEPTION
8307: WHEN OTHERS THEN
8308: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Summarize_Accounting_Lines:'||SQLERRM);

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

8304: arp_standard.debug( 'ARP_ALLOCATION_PKG.Summarize_Accounting_Lines()-');
8305:
8306: EXCEPTION
8307: WHEN OTHERS THEN
8308: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Summarize_Accounting_Lines:'||SQLERRM);
8309: RAISE;
8310:
8311: END Summarize_Accounting_Lines;
8312:

Line 8426: arp_standard.debug( 'ARP_ALLOCATION_PKG.Summarize_Acct_Lines_Hdr_Level()+');

8422: a1.ae_tax_link_id);
8423:
8424: BEGIN
8425:
8426: arp_standard.debug( 'ARP_ALLOCATION_PKG.Summarize_Acct_Lines_Hdr_Level()+');
8427:
8428: /*------------------------------------------------------------------------------+
8429: |Summarize Accounting entries for revenue and tax to net out accounting entries|
8430: |because the table g_ae_line_tbl contains accounting for earned discounts, |

Line 8502: arp_standard.debug( 'ARP_ALLOCATION_PKG.Summarize_Acct_Lines_Hdr_Level()-');

8498: END LOOP; --End loop summarize lines
8499:
8500: CLOSE summarize_lines;
8501:
8502: arp_standard.debug( 'ARP_ALLOCATION_PKG.Summarize_Acct_Lines_Hdr_Level()-');
8503:
8504: EXCEPTION
8505: WHEN OTHERS THEN
8506: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Summarize_Acct_Lines_Hdr_Level');

Line 8506: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Summarize_Acct_Lines_Hdr_Level');

8502: arp_standard.debug( 'ARP_ALLOCATION_PKG.Summarize_Acct_Lines_Hdr_Level()-');
8503:
8504: EXCEPTION
8505: WHEN OTHERS THEN
8506: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Summarize_Acct_Lines_Hdr_Level');
8507: RAISE;
8508:
8509: END Summarize_Acct_Lines_Hdr_Level;
8510:

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

8632: PROCEDURE Assign_Elements(p_ae_line_rec IN ar_ae_alloc_rec_gt%ROWTYPE) IS
8633:
8634: BEGIN
8635: IF PG_DEBUG IN ('Y','C') THEN
8636: arp_standard.debug( 'ARP_ALLOCATION_PKG.Assign_Elements()+');
8637: END IF;
8638: /*------------------------------------------------------+
8639: | Store AE Line elements in AE Lines temp table |
8640: +------------------------------------------------------*/

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

8797:
8798: Dump_Line_Amts(p_ae_line_rec);
8799:
8800: IF PG_DEBUG IN ('Y','C') THEN
8801: arp_standard.debug( 'ARP_ALLOCATION_PKG.Assign_Elements()-');
8802: END IF;
8803: EXCEPTION
8804: WHEN OTHERS THEN
8805: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Assign_Elements');

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

8801: arp_standard.debug( 'ARP_ALLOCATION_PKG.Assign_Elements()-');
8802: END IF;
8803: EXCEPTION
8804: WHEN OTHERS THEN
8805: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Assign_Elements');
8806: RAISE;
8807:
8808: END Assign_Elements;
8809:

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

8828: l_dummy ar_distributions.line_id%TYPE;
8829:
8830: BEGIN
8831:
8832: arp_standard.debug( 'ARP_ALLOCATION_PKG.Insert_Ae_Lines()+');
8833:
8834: -- Initialize
8835: l_ae_line_rec := l_ae_line_rec_empty;
8836:

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

8949: BEGIN
8950:
8951:
8952: IF PG_DEBUG in ('Y', 'C') THEN
8953: arp_standard.debug( 'ARP_ALLOCATION_PKG.Cache_Ae_Lines()+');
8954: END IF;
8955:
8956: g_ae_summ_ctr := g_ae_summ_ctr + 1;
8957:

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

8995:
8996:
8997:
8998: IF PG_DEBUG in ('Y', 'C') THEN
8999: arp_standard.debug( 'ARP_ALLOCATION_PKG.Cache_Ae_Lines()-');
9000: END IF;
9001:
9002: EXCEPTION
9003: WHEN OTHERS THEN

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

9001:
9002: EXCEPTION
9003: WHEN OTHERS THEN
9004: IF PG_DEBUG in ('Y', 'C') THEN
9005: arp_standard.debug( 'OTHERS EXCEPTION : ARP_ALLOCATION_PKG.Cache_Ae_Lines()');
9006: END IF;
9007:
9008: END Cache_Ae_Lines;
9009:

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

9064: PROCEDURE Dump_Alloc_Rev_Tax(p_type IN VARCHAR2, p_alloc_rec IN ar_ae_alloc_rec_gt%ROWTYPE) IS
9065:
9066: BEGIN
9067: IF PG_DEBUG in ('Y', 'C') THEN
9068: arp_standard.debug( 'ARP_ALLOCATION_PKG.Dump_Alloc_Rev_Tax()+');
9069: arp_standard.debug('Dump_Alloc_Rev_Tax: ' || 'g_ae_alloc_'||p_type||'_tbl.ae_id = ' ||
9070: p_alloc_rec.ae_id);
9071: arp_standard.debug('Dump_Alloc_Rev_Tax: ' || 'g_ae_alloc_'||p_type||'_tbl.ae_account_class = ' ||
9072: p_alloc_rec.ae_account_class);

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

9139: arp_standard.debug('Dump_Alloc_Rev_Tax: ' || 'g_ae_alloc_'||p_type||'_tbl.ae_summarize_flag= ' ||
9140: p_alloc_rec.ae_summarize_flag);
9141: arp_standard.debug('Dump_Alloc_Rev_Tax: ' || 'g_ae_alloc_'||p_type||'_tbl.ae_counted_flag = ' ||
9142: p_alloc_rec.ae_counted_flag);
9143: arp_standard.debug( 'ARP_ALLOCATION_PKG.Dump_Alloc_Rev_Tax()-');
9144: END IF;
9145: EXCEPTION
9146: WHEN OTHERS THEN
9147: IF PG_DEBUG in ('Y', 'C') THEN

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

9144: END IF;
9145: EXCEPTION
9146: WHEN OTHERS THEN
9147: IF PG_DEBUG in ('Y', 'C') THEN
9148: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Dump_Alloc_Rev_Tax');
9149: END IF;
9150: RAISE;
9151:
9152: END Dump_Alloc_Rev_Tax;

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

9168: p_app_rec IN ar_receivable_applications%ROWTYPE,
9169: p_adj_rec IN ar_adjustments%ROWTYPE ) IS
9170: BEGIN
9171: IF PG_DEBUG in ('Y', 'C') THEN
9172: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Init_Amts()+');
9173: arp_standard.debug('Dump_Init_Amts: ' || 'p_type_acct = ' || p_type_acct);
9174: END IF;
9175:
9176: IF p_type_acct = 'ED_ADJ' AND g_ae_doc_rec.source_table = 'RA' THEN

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

9228: arp_standard.debug('Dump_Init_Amts: ' || 'g_ae_rule_rec.freight_amt_alloc = '||g_ae_rule_rec.freight_amt_alloc);
9229: arp_standard.debug('Dump_Init_Amts: ' || 'g_ae_rule_rec.freight_acctd_amt_alloc = '||g_ae_rule_rec.freight_acctd_amt_alloc);
9230: arp_standard.debug('Dump_Init_Amts: ' || 'g_ae_rule_rec.charges_amt_alloc = '||g_ae_rule_rec.charges_amt_alloc);
9231: arp_standard.debug('Dump_Init_Amts: ' || 'g_ae_rule_rec.charges_acctd_amt_alloc = '||g_ae_rule_rec.charges_acctd_amt_alloc);
9232: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Init_Amts()-');
9233: END IF;
9234:
9235: EXCEPTION
9236: WHEN OTHERS THEN

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

9234:
9235: EXCEPTION
9236: WHEN OTHERS THEN
9237: IF PG_DEBUG in ('Y', 'C') THEN
9238: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Dump_Init_Amts');
9239: END IF;
9240: RAISE;
9241:
9242: END Dump_Init_Amts;

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

9255: PROCEDURE Dump_Line_Amts(p_ae_line_rec IN ar_ae_alloc_rec_gt%ROWTYPE) IS
9256:
9257: BEGIN
9258:
9259: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Line_Amts()+');
9260: arp_standard.debug('Dump_Line_Amts: ' || 'ae_id = ' || p_ae_line_rec.ae_id);
9261: arp_standard.debug('Dump_Line_Amts: ' || 'ae_line_type = ' || p_ae_line_rec.ae_line_type);
9262: arp_standard.debug('Dump_Line_Amts: ' || 'ae_line_type_secondary = ' || p_ae_line_rec.ae_line_type_secondary);
9263: arp_standard.debug('Dump_Line_Amts: ' || 'ae_source_id = ' || p_ae_line_rec.ae_source_id);

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

9294: arp_standard.debug('Dump_Line_Amts: ' || 'ref_line_id = ' || p_ae_line_rec.ae_ref_line_id);
9295: arp_standard.debug('Dump_Line_Amts: ' || 'ref_dist_ccid = ' || p_ae_line_rec.ref_dist_ccid);
9296: arp_standard.debug('Dump_Line_Amts: ' || 'ref_mf_dist_flag = ' || p_ae_line_rec.ref_mf_dist_flag);
9297:
9298: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Line_Amts()-');
9299:
9300: EXCEPTION
9301: WHEN OTHERS THEN
9302: IF PG_DEBUG in ('Y', 'C') THEN

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

9299:
9300: EXCEPTION
9301: WHEN OTHERS THEN
9302: IF PG_DEBUG in ('Y', 'C') THEN
9303: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Dump_Line_Amts');
9304: END IF;
9305: RAISE;
9306:
9307: END Dump_Line_Amts;

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

9320: PROCEDURE Dump_Dist_Amts(p_ae_line_rec IN ar_distributions%ROWTYPE) IS
9321: BEGIN
9322:
9323: IF PG_DEBUG in ('Y', 'C') THEN
9324: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Dist_Amts()+');
9325: arp_standard.debug('Dump_Dist_Amts: ' || 'ae_id = ' || g_id);
9326: arp_standard.debug('Dump_Dist_Amts: ' || 'source_type = ' || p_ae_line_rec.source_type);
9327: arp_standard.debug('Dump_Dist_Amts: ' || 'source_type_secondary = ' || p_ae_line_rec.source_type_secondary);
9328: arp_standard.debug('Dump_Dist_Amts: ' || 'source_id = ' || p_ae_line_rec.source_id);

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

9348: arp_standard.debug('Dump_Dist_Amts: ' || 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
9349: arp_standard.debug('Dump_Dist_Amts: ' || 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
9350: arp_standard.debug('Dump_Dist_Amts: ' || 'tax_link_id = ' || p_ae_line_rec.tax_link_id);
9351: arp_standard.debug('Dump_Dist_Amts: ' || 'reversed_source_id = ' || p_ae_line_rec.reversed_source_id);
9352: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Dist_Amts()-');
9353: END IF;
9354:
9355: EXCEPTION
9356: WHEN OTHERS THEN

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

9354:
9355: EXCEPTION
9356: WHEN OTHERS THEN
9357: IF PG_DEBUG in ('Y', 'C') THEN
9358: arp_standard.debug('EXCEPTION: ARP_ALLOCATION_PKG.Dump_Dist_Amts');
9359: END IF;
9360: RAISE;
9361:
9362: END Dump_Dist_Amts;

Line 9596: END ARP_ALLOCATION_PKG;

9592: END IF;
9593: END;
9594:
9595:
9596: END ARP_ALLOCATION_PKG;