eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_INVOICE_UTILS dependencies on AR_BFB_UTILS_PVT

Line 998: AND ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'Y'

994: billing_date
995: FROM ar_trx_header_gt
996: WHERE term_id IS NOT NULL
997: AND billing_date IS NULL
998: AND ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'Y'
999: AND nvl(ar_bfb_utils_pvt.get_cycle_type (ar_bfb_utils_pvt.get_billing_cycle(term_id)),'XXX') = 'EVENT';
1000:
1001: -- R12:BFB : BFB is not allowed with open Rec = No
1002: INSERT INTO ar_trx_errors_gt (

Line 999: AND nvl(ar_bfb_utils_pvt.get_cycle_type (ar_bfb_utils_pvt.get_billing_cycle(term_id)),'XXX') = 'EVENT';

995: FROM ar_trx_header_gt
996: WHERE term_id IS NOT NULL
997: AND billing_date IS NULL
998: AND ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'Y'
999: AND nvl(ar_bfb_utils_pvt.get_cycle_type (ar_bfb_utils_pvt.get_billing_cycle(term_id)),'XXX') = 'EVENT';
1000:
1001: -- R12:BFB : BFB is not allowed with open Rec = No
1002: INSERT INTO ar_trx_errors_gt (
1003: trx_header_id,

Line 1012: AND ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'Y'

1008: term_id
1009: FROM ar_trx_header_gt
1010: WHERE term_id IS NOT NULL
1011: AND cust_trx_type_id IS NOT NULL
1012: AND ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'Y'
1013: AND ar_bfb_utils_pvt.get_open_rec(cust_trx_type_id) = 'N';
1014:
1015: -- R12:BFB : billing_date validation
1016: INSERT INTO ar_trx_errors_gt (

Line 1013: AND ar_bfb_utils_pvt.get_open_rec(cust_trx_type_id) = 'N';

1009: FROM ar_trx_header_gt
1010: WHERE term_id IS NOT NULL
1011: AND cust_trx_type_id IS NOT NULL
1012: AND ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'Y'
1013: AND ar_bfb_utils_pvt.get_open_rec(cust_trx_type_id) = 'N';
1014:
1015: -- R12:BFB : billing_date validation
1016: INSERT INTO ar_trx_errors_gt (
1017: trx_header_id,

Line 1029: ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'N'

1025: AND billing_date IS NOT NULL
1026: AND
1027: (
1028: (-- billing_date should be null for non-BFB
1029: ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'N'
1030: )
1031: OR
1032: (-- BFB is not valid for open_rec = No, so there should be NO billing date either
1033: cust_trx_type_id IS NOT NULL

Line 1034: AND ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'Y'

1030: )
1031: OR
1032: (-- BFB is not valid for open_rec = No, so there should be NO billing date either
1033: cust_trx_type_id IS NOT NULL
1034: AND ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'Y'
1035: AND ar_bfb_utils_pvt.get_open_rec(cust_trx_type_id) = 'N'
1036: )
1037: );
1038:

Line 1035: AND ar_bfb_utils_pvt.get_open_rec(cust_trx_type_id) = 'N'

1031: OR
1032: (-- BFB is not valid for open_rec = No, so there should be NO billing date either
1033: cust_trx_type_id IS NOT NULL
1034: AND ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'Y'
1035: AND ar_bfb_utils_pvt.get_open_rec(cust_trx_type_id) = 'N'
1036: )
1037: );
1038:
1039: IF pg_debug = 'Y' THEN

Line 2037: AND ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'Y'

2033: arp_standard.fnd_message('AR_TAPI_BFB_INVALID_TERM'),
2034: term_id
2035: FROM ar_trx_header_gt gt
2036: WHERE gt.term_id IS NOT NULL
2037: AND ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'Y'
2038: AND ar_bfb_utils_pvt.get_bill_level(gt.bill_to_customer_id) = 'N';
2039:
2040: IF pg_debug = 'Y'
2041: THEN

Line 2038: AND ar_bfb_utils_pvt.get_bill_level(gt.bill_to_customer_id) = 'N';

2034: term_id
2035: FROM ar_trx_header_gt gt
2036: WHERE gt.term_id IS NOT NULL
2037: AND ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'Y'
2038: AND ar_bfb_utils_pvt.get_bill_level(gt.bill_to_customer_id) = 'N';
2039:
2040: IF pg_debug = 'Y'
2041: THEN
2042: debug ('AR_INVOICE_UTILS.validate_terms(-)' );

Line 3727: AND ar_bfb_utils_pvt.get_bill_level(gt.bill_to_customer_id) = 'N';

3723: AND NVL(t_cp2.end_date_active(+),
3724: gt.trx_date))
3725: WHERE gt.term_id IS NULL
3726: AND gt.trx_class in ('INV','DM') -- added for ER 5869149
3727: AND ar_bfb_utils_pvt.get_bill_level(gt.bill_to_customer_id) = 'N';
3728:
3729: -- R12:BFB : get term_id for BFB-enabled customers
3730: UPDATE ar_trx_header_gt gt
3731: SET term_id = ar_bfb_utils_pvt.get_default_term(

Line 3731: SET term_id = ar_bfb_utils_pvt.get_default_term(

3727: AND ar_bfb_utils_pvt.get_bill_level(gt.bill_to_customer_id) = 'N';
3728:
3729: -- R12:BFB : get term_id for BFB-enabled customers
3730: UPDATE ar_trx_header_gt gt
3731: SET term_id = ar_bfb_utils_pvt.get_default_term(
3732: gt.cust_trx_type_id,
3733: gt.trx_date,
3734: gt.org_id,
3735: gt.bill_to_site_use_id,

Line 3739: AND ar_bfb_utils_pvt.get_bill_level(gt.bill_to_customer_id) in ('A','S');

3735: gt.bill_to_site_use_id,
3736: gt.bill_to_customer_id)
3737: WHERE gt.term_id IS NULL
3738: AND gt.trx_class in ('INV','DM') -- added for ER 5869149 **addtional condition**
3739: AND ar_bfb_utils_pvt.get_bill_level(gt.bill_to_customer_id) in ('A','S');
3740:
3741: IF pg_debug = 'Y'
3742: THEN
3743: debug ('Getting term_id(-)' );

Line 3748: SET billing_date = ar_bfb_utils_pvt.get_billing_date

3744: debug ('Getting billing_date(+)');
3745: END IF;
3746:
3747: UPDATE ar_trx_header_gt gt
3748: SET billing_date = ar_bfb_utils_pvt.get_billing_date
3749: (ar_bfb_utils_pvt.get_billing_cycle(gt.term_id),
3750: nvl(gt.trx_date,sysdate))
3751: WHERE gt.term_id IS NOT NULL
3752: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'

Line 3749: (ar_bfb_utils_pvt.get_billing_cycle(gt.term_id),

3745: END IF;
3746:
3747: UPDATE ar_trx_header_gt gt
3748: SET billing_date = ar_bfb_utils_pvt.get_billing_date
3749: (ar_bfb_utils_pvt.get_billing_cycle(gt.term_id),
3750: nvl(gt.trx_date,sysdate))
3751: WHERE gt.term_id IS NOT NULL
3752: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'
3753: AND gt.billing_date IS NULL

Line 3752: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'

3748: SET billing_date = ar_bfb_utils_pvt.get_billing_date
3749: (ar_bfb_utils_pvt.get_billing_cycle(gt.term_id),
3750: nvl(gt.trx_date,sysdate))
3751: WHERE gt.term_id IS NOT NULL
3752: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'
3753: AND gt.billing_date IS NULL
3754: AND ar_bfb_utils_pvt.get_bill_level(gt.bill_to_customer_id) in ('A','S')
3755: AND nvl(ar_bfb_utils_pvt.get_cycle_type
3756: (ar_bfb_utils_pvt.get_billing_cycle(term_id)),'XXX') = 'RECURRING';

Line 3754: AND ar_bfb_utils_pvt.get_bill_level(gt.bill_to_customer_id) in ('A','S')

3750: nvl(gt.trx_date,sysdate))
3751: WHERE gt.term_id IS NOT NULL
3752: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'
3753: AND gt.billing_date IS NULL
3754: AND ar_bfb_utils_pvt.get_bill_level(gt.bill_to_customer_id) in ('A','S')
3755: AND nvl(ar_bfb_utils_pvt.get_cycle_type
3756: (ar_bfb_utils_pvt.get_billing_cycle(term_id)),'XXX') = 'RECURRING';
3757:
3758: -- override incorrect billing dates

Line 3755: AND nvl(ar_bfb_utils_pvt.get_cycle_type

3751: WHERE gt.term_id IS NOT NULL
3752: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'
3753: AND gt.billing_date IS NULL
3754: AND ar_bfb_utils_pvt.get_bill_level(gt.bill_to_customer_id) in ('A','S')
3755: AND nvl(ar_bfb_utils_pvt.get_cycle_type
3756: (ar_bfb_utils_pvt.get_billing_cycle(term_id)),'XXX') = 'RECURRING';
3757:
3758: -- override incorrect billing dates
3759: UPDATE ar_trx_header_gt gt

Line 3756: (ar_bfb_utils_pvt.get_billing_cycle(term_id)),'XXX') = 'RECURRING';

3752: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'
3753: AND gt.billing_date IS NULL
3754: AND ar_bfb_utils_pvt.get_bill_level(gt.bill_to_customer_id) in ('A','S')
3755: AND nvl(ar_bfb_utils_pvt.get_cycle_type
3756: (ar_bfb_utils_pvt.get_billing_cycle(term_id)),'XXX') = 'RECURRING';
3757:
3758: -- override incorrect billing dates
3759: UPDATE ar_trx_header_gt gt
3760: SET billing_date = ar_bfb_utils_pvt.get_billing_date

Line 3760: SET billing_date = ar_bfb_utils_pvt.get_billing_date

3756: (ar_bfb_utils_pvt.get_billing_cycle(term_id)),'XXX') = 'RECURRING';
3757:
3758: -- override incorrect billing dates
3759: UPDATE ar_trx_header_gt gt
3760: SET billing_date = ar_bfb_utils_pvt.get_billing_date
3761: (ar_bfb_utils_pvt.get_billing_cycle(gt.term_id),
3762: gt.billing_date)
3763: WHERE gt.term_id IS NOT NULL
3764: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'

Line 3761: (ar_bfb_utils_pvt.get_billing_cycle(gt.term_id),

3757:
3758: -- override incorrect billing dates
3759: UPDATE ar_trx_header_gt gt
3760: SET billing_date = ar_bfb_utils_pvt.get_billing_date
3761: (ar_bfb_utils_pvt.get_billing_cycle(gt.term_id),
3762: gt.billing_date)
3763: WHERE gt.term_id IS NOT NULL
3764: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'
3765: AND gt.billing_date IS NOT NULL

Line 3764: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'

3760: SET billing_date = ar_bfb_utils_pvt.get_billing_date
3761: (ar_bfb_utils_pvt.get_billing_cycle(gt.term_id),
3762: gt.billing_date)
3763: WHERE gt.term_id IS NOT NULL
3764: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'
3765: AND gt.billing_date IS NOT NULL
3766: AND billing_date <> ar_bfb_utils_pvt.get_billing_date(
3767: ar_bfb_utils_pvt.get_billing_cycle(term_id),
3768: gt.billing_date)

Line 3766: AND billing_date <> ar_bfb_utils_pvt.get_billing_date(

3762: gt.billing_date)
3763: WHERE gt.term_id IS NOT NULL
3764: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'
3765: AND gt.billing_date IS NOT NULL
3766: AND billing_date <> ar_bfb_utils_pvt.get_billing_date(
3767: ar_bfb_utils_pvt.get_billing_cycle(term_id),
3768: gt.billing_date)
3769: AND nvl(ar_bfb_utils_pvt.get_cycle_type
3770: (ar_bfb_utils_pvt.get_billing_cycle(term_id)),'XXX') = 'RECURRING';

Line 3767: ar_bfb_utils_pvt.get_billing_cycle(term_id),

3763: WHERE gt.term_id IS NOT NULL
3764: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'
3765: AND gt.billing_date IS NOT NULL
3766: AND billing_date <> ar_bfb_utils_pvt.get_billing_date(
3767: ar_bfb_utils_pvt.get_billing_cycle(term_id),
3768: gt.billing_date)
3769: AND nvl(ar_bfb_utils_pvt.get_cycle_type
3770: (ar_bfb_utils_pvt.get_billing_cycle(term_id)),'XXX') = 'RECURRING';
3771:

Line 3769: AND nvl(ar_bfb_utils_pvt.get_cycle_type

3765: AND gt.billing_date IS NOT NULL
3766: AND billing_date <> ar_bfb_utils_pvt.get_billing_date(
3767: ar_bfb_utils_pvt.get_billing_cycle(term_id),
3768: gt.billing_date)
3769: AND nvl(ar_bfb_utils_pvt.get_cycle_type
3770: (ar_bfb_utils_pvt.get_billing_cycle(term_id)),'XXX') = 'RECURRING';
3771:
3772: IF pg_debug = 'Y'
3773: THEN

Line 3770: (ar_bfb_utils_pvt.get_billing_cycle(term_id)),'XXX') = 'RECURRING';

3766: AND billing_date <> ar_bfb_utils_pvt.get_billing_date(
3767: ar_bfb_utils_pvt.get_billing_cycle(term_id),
3768: gt.billing_date)
3769: AND nvl(ar_bfb_utils_pvt.get_cycle_type
3770: (ar_bfb_utils_pvt.get_billing_cycle(term_id)),'XXX') = 'RECURRING';
3771:
3772: IF pg_debug = 'Y'
3773: THEN
3774: debug ('Getting billing_date(-)');

Line 3787: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'N'

3783: UPDATE ar_trx_header_gt gt
3784: SET term_due_date = trunc(arpt_sql_func_util.get_First_Due_Date(
3785: gt.term_id, NVL(gt.trx_date,sysdate)))
3786: WHERE gt.term_id IS NOT NULL
3787: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'N'
3788: AND NOT EXISTS
3789: (SELECT 'X'
3790: FROM ar_trx_errors_gt errgt
3791: WHERE errgt.trx_header_id = gt.trx_header_id);

Line 3795: SET term_due_date = ar_bfb_utils_pvt.get_due_date(gt.billing_date, gt.term_id)

3791: WHERE errgt.trx_header_id = gt.trx_header_id);
3792:
3793: -- get due_date for BFB enabled
3794: UPDATE ar_trx_header_gt gt
3795: SET term_due_date = ar_bfb_utils_pvt.get_due_date(gt.billing_date, gt.term_id)
3796: WHERE gt.term_id IS NOT NULL
3797: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'
3798: AND gt.billing_date IS NOT NULL
3799: AND NOT EXISTS

Line 3797: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'

3793: -- get due_date for BFB enabled
3794: UPDATE ar_trx_header_gt gt
3795: SET term_due_date = ar_bfb_utils_pvt.get_due_date(gt.billing_date, gt.term_id)
3796: WHERE gt.term_id IS NOT NULL
3797: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'
3798: AND gt.billing_date IS NOT NULL
3799: AND NOT EXISTS
3800: (SELECT 'X'
3801: FROM ar_trx_errors_gt errgt