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 3869: nvl(ap_utilities_pkg.get_exchange_rate( -- Added this Condition.

3865: END IF;
3866:
3867: IF ((l_conversion_type <> 'User') AND
3868: (p_invoice_rec.exchange_rate is NOT NULL)) AND -- Bug 5003374
3869: nvl(ap_utilities_pkg.get_exchange_rate( -- Added this Condition.
3870: p_invoice_rec.invoice_currency_code,
3871: p_base_currency_code,
3872: l_conversion_type,
3873: l_exchange_date,

Line 3894: (AP_UTILITIES_PKG.calculate_user_xrate (

3890: l_current_invoice_status := 'N';
3891:
3892: ELSIF ((l_conversion_type = 'User') AND
3893: (p_invoice_rec.exchange_rate is NULL)) AND
3894: (AP_UTILITIES_PKG.calculate_user_xrate (
3895: p_invoice_rec.invoice_currency_code,
3896: p_base_currency_code,
3897: l_exchange_date,
3898: l_conversion_type) <> 'Y') THEN

Line 3927: l_exchange_rate := ap_utilities_pkg.get_exchange_rate(

3923: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
3924: debug_info);
3925: END IF;
3926:
3927: l_exchange_rate := ap_utilities_pkg.get_exchange_rate(
3928: p_invoice_rec.invoice_currency_code,
3929: p_base_currency_code,
3930: l_conversion_type,
3931: l_exchange_date,

Line 5735: l_payment_cross_rate := ap_utilities_pkg.get_exchange_rate(

5731:
5732: l_current_invoice_status := 'N';
5733: ELSE
5734: p_payment_cross_rate_type := 'EMU FIXED';
5735: l_payment_cross_rate := ap_utilities_pkg.get_exchange_rate(
5736: p_invoice_rec.invoice_currency_code,
5737: p_invoice_rec.payment_currency_code,
5738: p_payment_cross_rate_type,
5739: p_payment_cross_rate_date,

Line 6186: IF (ap_utilities_pkg.ap_round_currency(

6182: (p_invoice_rec.no_xrate_base_amount IS NOT NULL) AND
6183: (p_invoice_rec.invoice_amount IS NOT NULL) AND
6184: (p_invoice_rec.exchange_rate is NOT NULL)) THEN
6185:
6186: IF (ap_utilities_pkg.ap_round_currency(
6187: (p_invoice_rec.invoice_amount*p_invoice_rec.exchange_rate),
6188: p_base_currency_code) <> p_invoice_rec.no_xrate_base_amount)
6189: THEN
6190:

Line 6248: AP_UTILITIES_PKG.calculate_user_xrate (

6244: debug_info);
6245: END IF;
6246:
6247: IF (p_invoice_rec.exchange_rate_type <> 'User' AND
6248: AP_UTILITIES_PKG.calculate_user_xrate (
6249: p_invoice_rec.invoice_currency_code,
6250: p_base_currency_code,
6251: p_invoice_rec.exchange_date,
6252: p_invoice_rec.exchange_rate_type) = 'N') THEN

Line 6260: p_invoice_base_amount := ap_utilities_pkg.ap_round_currency(

6256: p_invoice_rec.exchange_date,
6257: p_invoice_rec.exchange_rate_type,
6258: p_invoice_rec.invoice_amount);
6259: ELSE
6260: p_invoice_base_amount := ap_utilities_pkg.ap_round_currency(
6261: (p_invoice_rec.invoice_amount *
6262: p_invoice_rec.exchange_rate),
6263: p_base_currency_code);
6264: END IF;

Line 6888: ap_utilities_pkg.ap_round_currency(

6884:
6885: -- Retropricing: Base Amount is populated for proposed PPA Lines
6886: IF AP_IMPORT_INVOICES_PKG.g_source <> 'PPA' THEN
6887: p_invoice_lines_tab(i).base_amount :=
6888: ap_utilities_pkg.ap_round_currency(
6889: p_invoice_lines_tab(i).amount*p_invoice_rec.exchange_rate,
6890: p_base_currency_code );
6891: END IF;
6892:

Line 7140: IF (AP_UTILITIES_PKG.Check_partial(

7136: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7137: debug_info);
7138: END IF;
7139:
7140: IF (AP_UTILITIES_PKG.Check_partial(
7141: p_invoice_lines_tab(i).dist_code_concatenated, -- IN
7142: P_invoice_lines_tab(i).partial_segments, -- OUT
7143: p_set_of_books_id, -- IN
7144: l_error_message, -- OUT

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

7144: l_error_message, -- OUT
7145: current_calling_sequence) <> TRUE) THEN
7146: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
7147: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7148: 'AP_UTILITIES_PKG.Check_Partial<-'||current_calling_sequence);
7149: END IF;
7150: RAISE check_lines_failure;
7151: END IF;
7152:

Line 11732: nvl(ap_utilities_pkg.ap_round_currency(

11728: debug_info);
11729: END IF;
11730:
11731: l_line_amt_calculated :=
11732: nvl(ap_utilities_pkg.ap_round_currency(
11733: p_invoice_lines_rec.unit_price*
11734: p_invoice_lines_rec.quantity_invoiced,
11735: p_invoice_rec.invoice_currency_code)
11736: ,0);

Line 12984: l_po_unit_price := ap_utilities_pkg.ap_round_currency (

12980:
12981: IF (p_invoice_lines_rec.quantity_invoiced=0) THEN
12982: l_po_unit_price :=0;
12983: ELSE
12984: l_po_unit_price := ap_utilities_pkg.ap_round_currency (
12985: p_invoice_lines_rec.amount /
12986: p_invoice_lines_rec.quantity_invoiced,
12987: p_invoice_rec.invoice_currency_code);
12988: END IF; --Bug6932650

Line 13143: l_calc_line_amount := ap_utilities_pkg.ap_round_currency (

13139: -- The following can have rounding issues so use line_amount
13140: -- for consistency check.
13141: -- l_calculated_unit_price :=
13142: -- p_invoice_lines_rec.amount / p_quantity_invoiced;
13143: l_calc_line_amount := ap_utilities_pkg.ap_round_currency (
13144: p_invoice_lines_rec.unit_price * p_invoice_lines_rec.quantity_invoiced,
13145: p_invoice_rec.invoice_currency_code);
13146: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
13147: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,

Line 13299: l_calc_line_amount := ap_utilities_pkg.ap_round_currency (

13295: -- The following can have rounding issues so use line_amount
13296: -- for consistency check.
13297: -- l_calculated_unit_price :=
13298: -- p_invoice_lines_rec.amount / p_quantity_invoiced;
13299: l_calc_line_amount := ap_utilities_pkg.ap_round_currency (
13300: p_invoice_lines_rec.unit_price * p_invoice_lines_rec.quantity_invoiced,
13301: p_invoice_rec.invoice_currency_code);
13302: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
13303: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,

Line 14090: IF (AP_UTILITIES_PKG.overlay_segments(

14086: '(v_check_po_overlay 2) Check Overlay Segments fOR '
14087: ||'l_po_distribution_id ');
14088: END IF;
14089:
14090: IF (AP_UTILITIES_PKG.overlay_segments(
14091: p_invoice_lines_rec.balancing_segment,
14092: p_invoice_lines_rec.cost_center_segment,
14093: p_invoice_lines_rec.account_segment,
14094: l_dist_code_concatenated,

Line 14182: IF (AP_UTILITIES_PKG.overlay_segments(

14178: '(v_check_po_overlay 3) Check Overlay Segments fOR '
14179: ||'l_po_line_location_id ');
14180: END IF;
14181:
14182: IF (AP_UTILITIES_PKG.overlay_segments(
14183: p_invoice_lines_rec.balancing_segment,
14184: p_invoice_lines_rec.cost_center_segment,
14185: p_invoice_lines_rec.account_segment,
14186: l_dist_code_concatenated,

Line 14286: IF (AP_UTILITIES_PKG.overlay_segments(

14282: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
14283: '(v_check_po_overlay 3) Check Overlay Segments fOR l_po_line_id ');
14284: END IF;
14285:
14286: IF (AP_UTILITIES_PKG.overlay_segments(
14287: p_invoice_lines_rec.balancing_segment,
14288: p_invoice_lines_rec.cost_center_segment,
14289: p_invoice_lines_rec.account_segment,
14290: l_dist_code_concatenated,

Line 16222: IF (AP_UTILITIES_PKG.overlay_segments

16218: END IF;
16219:
16220: l_overlayed_ccid := l_dist_code_combination_id;
16221:
16222: IF (AP_UTILITIES_PKG.overlay_segments
16223: (p_invoice_lines_rec.balancing_segment,
16224: p_invoice_lines_rec.cost_center_segment,
16225: p_invoice_lines_rec.account_segment,
16226: p_invoice_lines_rec.dist_code_concatenated,

Line 16448: IF (AP_UTILITIES_PKG.overlay_segments(

16444: END IF;
16445:
16446: l_overlayed_ccid := l_dist_code_combination_id;
16447:
16448: IF (AP_UTILITIES_PKG.overlay_segments(
16449: p_invoice_lines_rec.balancing_segment,
16450: p_invoice_lines_rec.cost_center_segment,
16451: p_invoice_lines_rec.account_segment,
16452: NULL,

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

17352: IF (l_total_percent_distribution <> 100) THEN
17353: l_dset_lines_tab(i).amount := 0;
17354: l_dset_lines_tab(i).base_amount := 0;
17355: ELSE
17356: l_dset_lines_tab(i).amount := AP_UTILITIES_PKG.Ap_Round_Currency(
17357: NVL(l_dset_lines_tab(i).percent_distribution,0)
17358: * NVL(p_invoice_lines_rec.amount,0)/100,
17359: p_invoice_rec.invoice_currency_code);
17360: l_dset_lines_tab(i).base_amount :=

Line 17361: AP_UTILITIES_PKG.Ap_Round_Currency(

17357: NVL(l_dset_lines_tab(i).percent_distribution,0)
17358: * NVL(p_invoice_lines_rec.amount,0)/100,
17359: p_invoice_rec.invoice_currency_code);
17360: l_dset_lines_tab(i).base_amount :=
17361: AP_UTILITIES_PKG.Ap_Round_Currency(
17362: NVL(l_dset_lines_tab(i).amount, 0)
17363: * NVL(p_invoice_rec.exchange_rate, 1),
17364: p_base_currency_code);
17365: END IF;

Line 17767: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(

17763: AP_IMPORT_UTILITIES_PKG.Print(
17764: AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
17765: END IF;
17766:
17767: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(
17768: l_dset_lines_tab(i).dist_code_combination_id,
17769: p_chart_of_accounts_id,
17770: nvl(p_invoice_lines_rec.accounting_date,
17771: p_gl_date_from_get_info),

Line 17818: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (

17814: IF ( AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y' ) THEN
17815: AP_IMPORT_UTILITIES_PKG.Print(
17816: AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
17817: END IF;
17818: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (
17819: p_invoice_lines_rec.balancing_segment,
17820: p_invoice_lines_rec.cost_center_segment,
17821: p_invoice_lines_rec.account_segment,
17822: p_invoice_lines_rec.dist_code_concatenated,

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

18329: ------------------------------------------------------------------------
18330: IF (p_invoice_lines_rec.quantity_invoiced is NOT NULL AND
18331: p_invoice_lines_rec.unit_price is NOT NULL AND
18332: p_invoice_lines_rec.amount is NOT NULL AND
18333: p_invoice_lines_rec.amount <> ap_utilities_pkg.ap_round_currency(
18334: p_invoice_lines_rec.quantity_invoiced *
18335: p_invoice_lines_rec.unit_price,
18336: p_invoice_rec.invoice_currency_code)) THEN
18337: debug_info :=