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_APPROVAL_PKG dependencies on AP_UTILITIES_PKG

Line 1863: IF ap_utilities_pkg.period_status(gl_date.acc_date) ='N' then

1859: return true;
1860: END IF;
1861:
1862: FOR gl_date IN get_gl_date LOOP
1863: IF ap_utilities_pkg.period_status(gl_date.acc_date) ='N' then
1864: return false;
1865: END IF;
1866: END LOOP;
1867: return true;

Line 3672: ap_utilities_pkg.ap_round_currency(

3668:
3669: UPDATE AP_INVOICE_LINES AIL
3670: SET AIL.base_amount = DECODE(p_base_currency_code, p_invoice_currency_code,
3671: NULL,
3672: ap_utilities_pkg.ap_round_currency(
3673: amount * p_exchange_rate,
3674: p_base_currency_code)),
3675: AIL.last_update_date = SYSDATE,
3676: AIL.last_updated_by = FND_GLOBAL.user_id,

Line 3844: NULL, ap_utilities_pkg.ap_round_currency(

3840: --which either have an IPV or ERV or both, during the
3841: --earlier call to exec_matched_variance_checks.
3842: UPDATE AP_INVOICE_DISTRIBUTIONS
3843: SET base_amount = DECODE(p_base_currency_code, p_invoice_currency_code,
3844: NULL, ap_utilities_pkg.ap_round_currency(
3845: amount * p_invoice_exchange_rate,
3846: p_base_currency_code)),
3847: last_update_date = SYSDATE,
3848: last_updated_by = FND_GLOBAL.user_id,

Line 4282: SELECT ap_utilities_pkg.get_auto_offsets_segments(

4278: p_release_count IN OUT NOCOPY COUNTARRAY,
4279: p_calling_sequence IN VARCHAR2) IS
4280:
4281: CURSOR c_manual_awt_dist_segs is
4282: SELECT ap_utilities_pkg.get_auto_offsets_segments(
4283: aid.dist_code_combination_id)
4284: FROM ap_invoice_distributions aid
4285: WHERE aid.invoice_id = p_invoice_id
4286: AND aid.line_type_lookup_code = 'AWT'

Line 4295: SELECT ap_utilities_pkg.get_auto_offsets_segments(

4291: -- is not created by a prepayment application
4292: -- and include the lines table to know if the prepayment was included
4293: -- in the invoice
4294: CURSOR c_non_awt_dists_segs is
4295: SELECT ap_utilities_pkg.get_auto_offsets_segments(
4296: aid.dist_code_combination_id)
4297: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail
4298: WHERE ail.invoice_id = p_invoice_id
4299: AND ail.invoice_id = aid.invoice_id

Line 6269: ap_utilities_pkg.ap_round_currency(

6265: l_debug_info := 'Update ap_payment_schedule for the invoice, case 1';
6266:
6267: UPDATE ap_payment_schedules
6268: SET amount_remaining = (amount_remaining -
6269: ap_utilities_pkg.ap_round_currency(
6270: l_apply_amount_remaining,
6271: p_payment_currency_code)),
6272: payment_status_flag =
6273: DECODE(amount_remaining -

Line 6274: ap_utilities_pkg.ap_round_currency(

6270: l_apply_amount_remaining,
6271: p_payment_currency_code)),
6272: payment_status_flag =
6273: DECODE(amount_remaining -
6274: ap_utilities_pkg.ap_round_currency(
6275: l_apply_amount_remaining,
6276: p_payment_currency_code),
6277: 0,'Y',
6278: gross_amount, 'N',

Line 6437: ap_utilities_pkg.ap_round_currency(

6433: then
6434:
6435: update ap_payment_schedules
6436: set amount_remaining = (amount_remaining +
6437: ap_utilities_pkg.ap_round_currency(
6438: (amount_remaining * (l_manual_awt_amount/l_inv_amt_remaining)
6439: * l_payment_cross_rate), l_pay_curr_code ) )
6440: where invoice_id = p_invoice_id;
6441:

Line 6448: ap_utilities_pkg.ap_round_currency(

6444:
6445: update ap_payment_schedules
6446: set amount_remaining =
6447: (amount_remaining +
6448: ap_utilities_pkg.ap_round_currency(
6449: (gross_amount * (l_manual_awt_amount/l_gross_amount)
6450: * l_payment_cross_rate), l_pay_curr_code) ),
6451: payment_status_flag = DECODE(payment_status_flag,
6452: 'Y','P',payment_status_flag)

Line 6533: SELECT nvl(ap_utilities_pkg.ap_round_currency(

6529:
6530: LOOP
6531: FETCH Update_payment_schedule into l_payment_num,l_gross_amount,l_inv_amt_remaining;
6532: EXIT WHEN Update_payment_schedule%NOTFOUND;
6533: SELECT nvl(ap_utilities_pkg.ap_round_currency(
6534: l_automatic_awt_amount*
6535: ai.payment_cross_rate,l_pay_curr_code),0)*
6536: l_gross_amount/decode(ai.pay_curr_invoice_amount, 0, 1,
6537: nvl(ai.pay_curr_invoice_amount, 1))

Line 6556: ap_utilities_pkg.ap_round_currency(

6552: then
6553:
6554: update ap_payment_schedules
6555: set amount_remaining = (amount_remaining -
6556: ap_utilities_pkg.ap_round_currency(
6557: (amount_remaining * ( l_wt_amt_to_subtract/l_inv_amt_remaining)
6558: * l_payment_cross_rate), l_pay_curr_code ) )
6559: where invoice_id = p_invoice_id
6560: and payment_num=l_payment_num;

Line 7763: ap_utilities_pkg.ap_get_message(l_approval_error);

7759: WHEN TAX_EXCEPTION_HANDLED THEN
7760:
7761: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;
7762:
7763: ap_utilities_pkg.ap_get_message(l_approval_error);
7764: fnd_file.put_line (fnd_file.log, ' ');
7765: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_invoice_num);
7766: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
7767: Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||

Line 7775: ap_utilities_pkg.ap_get_message(l_approval_error);

7771: WHEN OTHERS THEN
7772:
7773: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;
7774:
7775: ap_utilities_pkg.ap_get_message(l_approval_error);
7776: fnd_file.put_line (fnd_file.log, ' ');
7777: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_invoice_num);
7778: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
7779: Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||

Line 7968: ap_utilities_pkg.ap_get_message(l_approval_error);

7964: WHEN TAX_DIST_EXCEPTION_HANDLED THEN
7965:
7966: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
7967:
7968: ap_utilities_pkg.ap_get_message(l_approval_error);
7969:
7970: fnd_file.put_line (fnd_file.log, ' ');
7971: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '||
7972: l_selc_inv_cursor_blk_err(i).invoice_num);

Line 7981: ap_utilities_pkg.ap_get_message(l_approval_error);

7977: WHEN OTHERS THEN
7978:
7979: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
7980:
7981: ap_utilities_pkg.ap_get_message(l_approval_error);
7982:
7983: fnd_file.put_line (fnd_file.log, ' ');
7984: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '||
7985: l_selc_inv_cursor_blk_err(i).invoice_num);

Line 8121: AP_UTILITIES_PKG.AP_GET_MESSAGE(l_approval_error);

8117:
8118: EXCEPTION
8119:
8120: WHEN TAX_EXCEPTION THEN
8121: AP_UTILITIES_PKG.AP_GET_MESSAGE(l_approval_error);
8122: fnd_file.put_line(fnd_file.log,l_approval_error);
8123: fnd_file.put_line(fnd_file.log,sqlerrm);
8124: Print_Debug(l_api_name, 'Exception: '||sqlerrm);
8125:

Line 8153: AP_UTILITIES_PKG.AP_GET_MESSAGE(l_approval_error);

8149:
8150: RETURN (FALSE);
8151:
8152: WHEN OTHERS THEN
8153: AP_UTILITIES_PKG.AP_GET_MESSAGE(l_approval_error);
8154: fnd_file.put_line(fnd_file.log,l_approval_error);
8155: fnd_file.put_line(fnd_file.log,sqlerrm);
8156: Print_Debug(l_api_name, 'Others: Exception: '||sqlerrm);
8157:

Line 8692: ,pay_curr_invoice_amount = ap_utilities_pkg.ap_round_currency

8688: --as pay_curr_invoice_amount has nothing to do with recouped amount. Recoupment
8689: --should effect only amount_paid on the invoice.
8690: update ap_invoices_all
8691: set amount_paid = nvl(amount_paid,0) + abs(l_recouped_amount)
8692: ,pay_curr_invoice_amount = ap_utilities_pkg.ap_round_currency
8693: (pay_curr_invoice_amount * payment_cross_rate,
8694: payment_currency_code)
8695: where invoice_id = t_inv_lines_table(i).invoice_id;
8696: END IF;

Line 8764: ,pay_curr_invoice_amount = ap_utilities_pkg.ap_round_currency

8760: ----------------------------------------------------------------
8761:
8762: update ap_invoices_all
8763: set amount_applicable_to_discount = amount_applicable_to_discount + l_retained_amount
8764: ,pay_curr_invoice_amount = ap_utilities_pkg.ap_round_currency
8765: ((invoice_amount + l_retained_amount) * payment_cross_rate,
8766: payment_currency_code)
8767: where invoice_id = p_invoice_rec.invoice_id
8768: and nvl(net_of_retainage_flag, 'N') <> 'Y';