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.AP_IMPORT_VALIDATION_PKG dependencies on AP_UTILITIES_PKG

Line 4084: nvl(ap_utilities_pkg.get_exchange_rate( -- Added this Condition.

4080: l_current_invoice_status := 'N';
4081: --End of bug8766019
4082: ELSIF ((l_conversion_type <> 'User') AND
4083: (p_invoice_rec.exchange_rate is NOT NULL)) AND -- Bug 5003374
4084: nvl(ap_utilities_pkg.get_exchange_rate( -- Added this Condition.
4085: p_invoice_rec.invoice_currency_code,
4086: p_base_currency_code,
4087: l_conversion_type,
4088: l_exchange_date,

Line 4109: (AP_UTILITIES_PKG.calculate_user_xrate (

4105: l_current_invoice_status := 'N';
4106:
4107: ELSIF ((l_conversion_type = 'User') AND
4108: (p_invoice_rec.exchange_rate is NULL)) AND
4109: (AP_UTILITIES_PKG.calculate_user_xrate (
4110: p_invoice_rec.invoice_currency_code,
4111: p_base_currency_code,
4112: l_exchange_date,
4113: l_conversion_type) <> 'Y') THEN

Line 4142: l_exchange_rate := ap_utilities_pkg.get_exchange_rate(

4138: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
4139: debug_info);
4140: END IF;
4141:
4142: l_exchange_rate := ap_utilities_pkg.get_exchange_rate(
4143: p_invoice_rec.invoice_currency_code,
4144: p_base_currency_code,
4145: l_conversion_type,
4146: l_exchange_date,

Line 6173: l_payment_cross_rate := ap_utilities_pkg.get_exchange_rate(

6169:
6170: l_current_invoice_status := 'N';
6171: ELSE
6172: p_payment_cross_rate_type := 'EMU FIXED';
6173: l_payment_cross_rate := ap_utilities_pkg.get_exchange_rate(
6174: p_invoice_rec.invoice_currency_code,
6175: p_invoice_rec.payment_currency_code,
6176: p_payment_cross_rate_type,
6177: p_payment_cross_rate_date,

Line 6637: IF (ap_utilities_pkg.ap_round_currency(

6633: (p_invoice_rec.no_xrate_base_amount IS NOT NULL) AND
6634: (p_invoice_rec.invoice_amount IS NOT NULL) AND
6635: (p_invoice_rec.exchange_rate is NOT NULL)) THEN
6636:
6637: IF (ap_utilities_pkg.ap_round_currency(
6638: (p_invoice_rec.invoice_amount*p_invoice_rec.exchange_rate),
6639: p_base_currency_code) <> p_invoice_rec.no_xrate_base_amount)
6640: THEN
6641:

Line 6705: AP_UTILITIES_PKG.calculate_user_xrate (

6701: CLOSE c_get_rate_mand_flag;
6702: -- bug 9326733 ends
6703:
6704: IF (p_invoice_rec.exchange_rate_type <> 'User' AND
6705: AP_UTILITIES_PKG.calculate_user_xrate (
6706: p_invoice_rec.invoice_currency_code,
6707: p_base_currency_code,
6708: p_invoice_rec.exchange_date,
6709: p_invoice_rec.exchange_rate_type) = 'N') THEN

Line 6745: p_invoice_base_amount := ap_utilities_pkg.ap_round_currency(

6741:
6742: END;
6743: --End of Bug8739726
6744: ELSE
6745: p_invoice_base_amount := ap_utilities_pkg.ap_round_currency(
6746: (p_invoice_rec.invoice_amount *
6747: p_invoice_rec.exchange_rate),
6748: p_base_currency_code);
6749: END IF;

Line 7445: ap_utilities_pkg.ap_round_currency(

7441:
7442: -- Retropricing: Base Amount is populated for proposed PPA Lines
7443: IF AP_IMPORT_INVOICES_PKG.g_source <> 'PPA' THEN
7444: p_invoice_lines_tab(i).base_amount :=
7445: ap_utilities_pkg.ap_round_currency(
7446: p_invoice_lines_tab(i).amount*p_invoice_rec.exchange_rate,
7447: p_base_currency_code );
7448: END IF;
7449:

Line 7697: IF (AP_UTILITIES_PKG.Check_partial(

7693: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7694: debug_info);
7695: END IF;
7696:
7697: IF (AP_UTILITIES_PKG.Check_partial(
7698: p_invoice_lines_tab(i).dist_code_concatenated, -- IN
7699: P_invoice_lines_tab(i).partial_segments, -- OUT
7700: p_set_of_books_id, -- IN
7701: l_error_message, -- OUT

Line 7705: 'AP_UTILITIES_PKG.Check_Partial<-'||current_calling_sequence);

7701: l_error_message, -- OUT
7702: current_calling_sequence) <> TRUE) THEN
7703: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
7704: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7705: 'AP_UTILITIES_PKG.Check_Partial<-'||current_calling_sequence);
7706: END IF;
7707: RAISE check_lines_failure;
7708: END IF;
7709:

Line 12901: nvl(ap_utilities_pkg.ap_round_currency(

12897: debug_info);
12898: END IF;
12899:
12900: l_line_amt_calculated :=
12901: nvl(ap_utilities_pkg.ap_round_currency(
12902: p_invoice_lines_rec.unit_price*
12903: p_invoice_lines_rec.quantity_invoiced,
12904: p_invoice_rec.invoice_currency_code)
12905: ,0);

Line 14348: l_po_unit_price := ap_utilities_pkg.ap_round_currency (

14344:
14345: IF (p_invoice_lines_rec.quantity_invoiced=0) THEN
14346: l_po_unit_price :=0;
14347: ELSE
14348: l_po_unit_price := ap_utilities_pkg.ap_round_currency (
14349: p_invoice_lines_rec.amount /
14350: p_invoice_lines_rec.quantity_invoiced,
14351: p_invoice_rec.invoice_currency_code);
14352: END IF; --Bug6932650

Line 14507: l_calc_line_amount := ap_utilities_pkg.ap_round_currency (

14503: -- The following can have rounding issues so use line_amount
14504: -- for consistency check.
14505: -- l_calculated_unit_price :=
14506: -- p_invoice_lines_rec.amount / p_quantity_invoiced;
14507: l_calc_line_amount := ap_utilities_pkg.ap_round_currency (
14508: p_invoice_lines_rec.unit_price * p_invoice_lines_rec.quantity_invoiced,
14509: p_invoice_rec.invoice_currency_code);
14510: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
14511: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,

Line 14669: l_calc_line_amount := ap_utilities_pkg.ap_round_currency (

14665: -- The following can have rounding issues so use line_amount
14666: -- for consistency check.
14667: -- l_calculated_unit_price :=
14668: -- p_invoice_lines_rec.amount / p_quantity_invoiced;
14669: l_calc_line_amount := ap_utilities_pkg.ap_round_currency (
14670: p_invoice_lines_rec.unit_price * p_invoice_lines_rec.quantity_invoiced,
14671: p_invoice_rec.invoice_currency_code);
14672: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
14673: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,

Line 15469: IF (AP_UTILITIES_PKG.overlay_segments(

15465: '(v_check_po_overlay 2) Check Overlay Segments fOR '
15466: ||'l_po_distribution_id ');
15467: END IF;
15468:
15469: IF (AP_UTILITIES_PKG.overlay_segments(
15470: p_invoice_lines_rec.balancing_segment,
15471: p_invoice_lines_rec.cost_center_segment,
15472: p_invoice_lines_rec.account_segment,
15473: l_dist_code_concatenated,

Line 15563: IF (AP_UTILITIES_PKG.overlay_segments(

15559: '(v_check_po_overlay 3) Check Overlay Segments fOR '
15560: ||'l_po_line_location_id ');
15561: END IF;
15562:
15563: IF (AP_UTILITIES_PKG.overlay_segments(
15564: p_invoice_lines_rec.balancing_segment,
15565: p_invoice_lines_rec.cost_center_segment,
15566: p_invoice_lines_rec.account_segment,
15567: l_dist_code_concatenated,

Line 15669: IF (AP_UTILITIES_PKG.overlay_segments(

15665: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
15666: '(v_check_po_overlay 3) Check Overlay Segments fOR l_po_line_id ');
15667: END IF;
15668:
15669: IF (AP_UTILITIES_PKG.overlay_segments(
15670: p_invoice_lines_rec.balancing_segment,
15671: p_invoice_lines_rec.cost_center_segment,
15672: p_invoice_lines_rec.account_segment,
15673: l_dist_code_concatenated,

Line 16726: ap_utilities_pkg.get_gl_date_and_period_1

16722: END IF;
16723:
16724: /* l_accounting_date := p_invoice_rec.invoice_date; commented for bug#12356854 */
16725: /* Added for bug#12356854 Start */
16726: ap_utilities_pkg.get_gl_date_and_period_1
16727: ( p_invoice_rec.invoice_date,
16728: NULL,
16729: l_period_name,
16730: l_accounting_date,

Line 17644: IF (AP_UTILITIES_PKG.is_balancing_segment_valid(

17640: '(v_check_line_account_info 1.1) '
17641: || 'Check Overlay Balancing Segment if entered');
17642: END IF;
17643:
17644: IF (AP_UTILITIES_PKG.is_balancing_segment_valid(
17645: p_set_of_books_id => p_set_of_books_id,
17646: p_balancing_segment_value => p_invoice_lines_rec.balancing_segment,
17647: p_date => p_accounting_date,
17648: p_calling_sequence => current_calling_sequence) <> TRUE )

Line 17805: IF (AP_UTILITIES_PKG.overlay_segments

17801: END IF;
17802:
17803: l_overlayed_ccid := l_dist_code_combination_id;
17804:
17805: IF (AP_UTILITIES_PKG.overlay_segments
17806: (p_invoice_lines_rec.balancing_segment,
17807: p_invoice_lines_rec.cost_center_segment,
17808: p_invoice_lines_rec.account_segment,
17809: p_invoice_lines_rec.dist_code_concatenated,

Line 18034: IF (AP_UTILITIES_PKG.overlay_segments(

18030: END IF;
18031:
18032: l_overlayed_ccid := l_dist_code_combination_id;
18033:
18034: IF (AP_UTILITIES_PKG.overlay_segments(
18035: p_invoice_lines_rec.balancing_segment,
18036: p_invoice_lines_rec.cost_center_segment,
18037: p_invoice_lines_rec.account_segment,
18038: NULL,

Line 18416: l_period_name := Ap_Utilities_Pkg.Get_Current_Gl_Date_No_Cache(

18412:
18413: IF (p_invoice_lines_rec.def_acctg_start_date IS NOT NULL) THEN
18414: -- Bug 15835723 BEGIN
18415: -- Bug 15835723
18416: l_period_name := Ap_Utilities_Pkg.Get_Current_Gl_Date_No_Cache(
18417: p_invoice_lines_rec.def_acctg_start_date,
18418: p_invoice_lines_rec.org_id);
18419: /* Bug 15835723
18420: SELECT period_name

Line 18502: l_period_name := Ap_Utilities_Pkg.Get_Current_Gl_Date_No_Cache(

18498:
18499: -- Bug 15835723
18500: IF (p_invoice_lines_rec.def_acctg_end_date IS NOT NULL) THEN
18501: -- Bug 15835723 BEGIN
18502: l_period_name := Ap_Utilities_Pkg.Get_Current_Gl_Date_No_Cache(
18503: p_invoice_lines_rec.def_acctg_end_date,
18504: p_invoice_lines_rec.org_id);
18505: -- Bug 15835723
18506: /* EXCEPTION

Line 19033: l_dset_lines_tab(i).amount := AP_UTILITIES_PKG.Ap_Round_Currency(

19029: IF (l_total_percent_distribution <> 100) THEN
19030: l_dset_lines_tab(i).amount := 0;
19031: l_dset_lines_tab(i).base_amount := 0;
19032: ELSE
19033: l_dset_lines_tab(i).amount := AP_UTILITIES_PKG.Ap_Round_Currency(
19034: NVL(l_dset_lines_tab(i).percent_distribution,0)
19035: * NVL(p_invoice_lines_rec.amount,0)/100,
19036: p_invoice_rec.invoice_currency_code);
19037: l_dset_lines_tab(i).base_amount :=

Line 19038: AP_UTILITIES_PKG.Ap_Round_Currency(

19034: NVL(l_dset_lines_tab(i).percent_distribution,0)
19035: * NVL(p_invoice_lines_rec.amount,0)/100,
19036: p_invoice_rec.invoice_currency_code);
19037: l_dset_lines_tab(i).base_amount :=
19038: AP_UTILITIES_PKG.Ap_Round_Currency(
19039: NVL(l_dset_lines_tab(i).amount, 0)
19040: * NVL(p_invoice_rec.exchange_rate, 1),
19041: p_base_currency_code);
19042: END IF;

Line 19445: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(

19441: AP_IMPORT_UTILITIES_PKG.Print(
19442: AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
19443: END IF;
19444:
19445: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(
19446: l_dset_lines_tab(i).dist_code_combination_id,
19447: p_chart_of_accounts_id,
19448: nvl(p_invoice_lines_rec.accounting_date,
19449: p_gl_date_from_get_info),

Line 19499: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (

19495: IF ( AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y' ) THEN
19496: AP_IMPORT_UTILITIES_PKG.Print(
19497: AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
19498: END IF;
19499: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (
19500: p_invoice_lines_rec.balancing_segment,
19501: p_invoice_lines_rec.cost_center_segment,
19502: p_invoice_lines_rec.account_segment,
19503: p_invoice_lines_rec.dist_code_concatenated,

Line 20016: p_invoice_lines_rec.amount <> ap_utilities_pkg.ap_round_currency(

20012: ------------------------------------------------------------------------
20013: IF (p_invoice_lines_rec.quantity_invoiced is NOT NULL AND
20014: p_invoice_lines_rec.unit_price is NOT NULL AND
20015: p_invoice_lines_rec.amount is NOT NULL AND
20016: p_invoice_lines_rec.amount <> ap_utilities_pkg.ap_round_currency(
20017: p_invoice_lines_rec.quantity_invoiced *
20018: p_invoice_lines_rec.unit_price,
20019: p_invoice_rec.invoice_currency_code)) THEN
20020: debug_info :=