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 2648: IF ap_utilities_pkg.period_status(gl_date.acc_date) ='N' then

2644: return true;
2645: END IF;
2646:
2647: FOR gl_date IN get_gl_date LOOP
2648: IF ap_utilities_pkg.period_status(gl_date.acc_date) ='N' then
2649: return false;
2650: END IF;
2651: END LOOP;
2652: return true;

Line 4725: l_out_status := AP_UTILITIES_PKG.GET_CCR_STATUS(

4721: END IF;
4722:
4723: P_Vendor_Site_Reg_Expired := 'N';
4724:
4725: l_out_status := AP_UTILITIES_PKG.GET_CCR_STATUS(
4726: p_object_id => P_vendor_id,
4727: p_object_type => 'S');
4728:
4729:

Line 4743: l_vndr_ccr_status := AP_UTILITIES_PKG.GET_CCR_REG_STATUS(p_vendor_site_id);

4739: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_debug_info );
4740: END IF;
4741: --Bug16247029: End
4742:
4743: l_vndr_ccr_status := AP_UTILITIES_PKG.GET_CCR_REG_STATUS(p_vendor_site_id);
4744:
4745: l_debug_info := 'l_vndr_ccr_status = '|| l_vndr_ccr_status;
4746: --Bug16247029: Start
4747: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4763: l_vndr_ccr_status := AP_UTILITIES_PKG.GET_CCR_REG_STATUS

4759:
4760: IF(nvl(p_remit_to_supplier_site_id,p_vendor_site_id) <> p_vendor_site_id
4761: and P_Vendor_Site_Reg_Expired <> 'Y') THEN
4762:
4763: l_vndr_ccr_status := AP_UTILITIES_PKG.GET_CCR_REG_STATUS
4764: (p_remit_to_supplier_site_id);
4765:
4766: l_debug_info := 'l_rmt_vndr_ccr_status = '|| l_vndr_ccr_status;
4767: --Bug16247029: Start

Line 5069: ap_utilities_pkg.ap_round_currency(

5065:
5066: UPDATE AP_INVOICE_LINES AIL
5067: SET AIL.base_amount = DECODE(p_base_currency_code, p_invoice_currency_code,
5068: NULL,
5069: ap_utilities_pkg.ap_round_currency(
5070: amount * p_exchange_rate,
5071: p_base_currency_code)),
5072: AIL.last_update_date = SYSDATE,
5073: AIL.last_updated_by = FND_GLOBAL.user_id,

Line 5267: NULL, ap_utilities_pkg.ap_round_currency(

5263: --which either have an IPV or ERV or both, during the
5264: --earlier call to exec_matched_variance_checks.
5265: UPDATE AP_INVOICE_DISTRIBUTIONS
5266: SET base_amount = DECODE(p_base_currency_code, p_invoice_currency_code,
5267: NULL, ap_utilities_pkg.ap_round_currency(
5268: amount * p_invoice_exchange_rate,
5269: p_base_currency_code)),
5270: last_update_date = SYSDATE,
5271: last_updated_by = FND_GLOBAL.user_id,

Line 5784: SELECT ap_utilities_pkg.get_auto_offsets_segments(

5780: p_release_count IN OUT NOCOPY COUNTARRAY,
5781: p_calling_sequence IN VARCHAR2) IS
5782:
5783: CURSOR c_manual_awt_dist_segs is
5784: SELECT ap_utilities_pkg.get_auto_offsets_segments(
5785: aid.dist_code_combination_id)
5786: FROM ap_invoice_distributions aid
5787: WHERE aid.invoice_id = p_invoice_id
5788: AND aid.line_type_lookup_code = 'AWT'

Line 5797: SELECT ap_utilities_pkg.get_auto_offsets_segments(

5793: -- is not created by a prepayment application
5794: -- and include the lines table to know if the prepayment was included
5795: -- in the invoice
5796: CURSOR c_non_awt_dists_segs is
5797: SELECT ap_utilities_pkg.get_auto_offsets_segments(
5798: aid.dist_code_combination_id)
5799: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail
5800: WHERE ail.invoice_id = p_invoice_id
5801: AND ail.invoice_id = aid.invoice_id

Line 8246: ap_utilities_pkg.ap_round_currency(

8242: l_debug_info := 'Update ap_payment_schedule for the invoice, case 1';
8243:
8244: UPDATE ap_payment_schedules
8245: SET amount_remaining = (amount_remaining -
8246: ap_utilities_pkg.ap_round_currency(
8247: l_apply_amount_remaining,
8248: p_payment_currency_code)),
8249: payment_status_flag =
8250: DECODE(amount_remaining -

Line 8251: ap_utilities_pkg.ap_round_currency(

8247: l_apply_amount_remaining,
8248: p_payment_currency_code)),
8249: payment_status_flag =
8250: DECODE(amount_remaining -
8251: ap_utilities_pkg.ap_round_currency(
8252: l_apply_amount_remaining,
8253: p_payment_currency_code),
8254: 0,'Y',
8255: gross_amount, 'N',

Line 8415: ap_utilities_pkg.ap_round_currency(

8411: then
8412:
8413: update ap_payment_schedules
8414: set amount_remaining = (amount_remaining +
8415: ap_utilities_pkg.ap_round_currency(
8416: (amount_remaining * (l_manual_awt_amount/l_inv_amt_remaining)
8417: * l_payment_cross_rate), l_pay_curr_code ) )
8418: where invoice_id = p_invoice_id;
8419:

Line 8426: ap_utilities_pkg.ap_round_currency(

8422:
8423: update ap_payment_schedules
8424: set amount_remaining =
8425: (amount_remaining +
8426: ap_utilities_pkg.ap_round_currency(
8427: (gross_amount * (l_manual_awt_amount/l_gross_amount)
8428: * l_payment_cross_rate), l_pay_curr_code) ),
8429: payment_status_flag = DECODE(payment_status_flag,
8430: 'Y','P',payment_status_flag)

Line 8511: SELECT nvl(ap_utilities_pkg.ap_round_currency(

8507:
8508: LOOP
8509: FETCH Update_payment_schedule into l_payment_num,l_gross_amount,l_inv_amt_remaining;
8510: EXIT WHEN Update_payment_schedule%NOTFOUND;
8511: SELECT nvl(ap_utilities_pkg.ap_round_currency(
8512: l_automatic_awt_amount*
8513: ai.payment_cross_rate,l_pay_curr_code),0)*
8514: l_gross_amount/decode(ai.pay_curr_invoice_amount, 0, 1,
8515: nvl(ai.pay_curr_invoice_amount, 1))

Line 8534: ap_utilities_pkg.ap_round_currency(

8530: then
8531:
8532: update ap_payment_schedules
8533: set amount_remaining = (amount_remaining -
8534: ap_utilities_pkg.ap_round_currency(
8535: (amount_remaining * ( l_wt_amt_to_subtract/l_inv_amt_remaining)
8536: * l_payment_cross_rate), l_pay_curr_code ) )
8537: where invoice_id = p_invoice_id
8538: and payment_num=l_payment_num;

Line 10399: ap_utilities_pkg.ap_get_message(l_approval_error);

10395: WHEN TAX_EXCEPTION_HANDLED THEN
10396:
10397: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;
10398:
10399: ap_utilities_pkg.ap_get_message(l_approval_error);
10400: fnd_file.put_line (fnd_file.log, ' ');
10401: --Bug9436217
10402: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_selected_invoices_cursor(i).invoice_num);
10403: --Bug9436217

Line 10425: ap_utilities_pkg.ap_get_message(l_approval_error);

10421: WHEN OTHERS THEN
10422:
10423: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;
10424:
10425: ap_utilities_pkg.ap_get_message(l_approval_error);
10426: fnd_file.put_line (fnd_file.log, ' ');
10427: --Bug9436217
10428: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_selected_invoices_cursor(i).invoice_num);
10429: --Bug9436217

Line 10828: ap_utilities_pkg.ap_get_message(l_approval_error);

10824: WHEN TAX_DIST_EXCEPTION_HANDLED THEN
10825:
10826: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
10827:
10828: ap_utilities_pkg.ap_get_message(l_approval_error);
10829:
10830: fnd_file.put_line (fnd_file.log, ' ');
10831:
10832: --Bug9436217

Line 10861: ap_utilities_pkg.ap_get_message(l_approval_error);

10857: WHEN OTHERS THEN
10858:
10859: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
10860:
10861: ap_utilities_pkg.ap_get_message(l_approval_error);
10862:
10863: fnd_file.put_line (fnd_file.log, ' ');
10864:
10865: --Bug9436217

Line 11140: AP_UTILITIES_PKG.AP_GET_MESSAGE(l_approval_error);

11136:
11137: EXCEPTION
11138:
11139: WHEN TAX_EXCEPTION THEN
11140: AP_UTILITIES_PKG.AP_GET_MESSAGE(l_approval_error);
11141: fnd_file.put_line(fnd_file.log,l_approval_error);
11142: fnd_file.put_line(fnd_file.log,sqlerrm);
11143: -- Print_Debug(l_api_name, 'Exception: '||sqlerrm);
11144: IF g_debug_mode = 'Y' THEN

Line 11179: AP_UTILITIES_PKG.AP_GET_MESSAGE(l_approval_error);

11175:
11176: RETURN (FALSE);
11177:
11178: WHEN OTHERS THEN
11179: AP_UTILITIES_PKG.AP_GET_MESSAGE(l_approval_error);
11180: fnd_file.put_line(fnd_file.log,l_approval_error);
11181: fnd_file.put_line(fnd_file.log,sqlerrm);
11182: -- Print_Debug(l_api_name, 'Others: Exception: '||sqlerrm);
11183: IF g_debug_mode = 'Y' THEN

Line 11836: ,pay_curr_invoice_amount = ap_utilities_pkg.ap_round_currency

11832: --as pay_curr_invoice_amount has nothing to do with recouped amount. Recoupment
11833: --should effect only amount_paid on the invoice.
11834: update ap_invoices_all
11835: set amount_paid = nvl(amount_paid,0) + abs(l_recouped_amount)
11836: ,pay_curr_invoice_amount = ap_utilities_pkg.ap_round_currency
11837: (pay_curr_invoice_amount * payment_cross_rate,
11838: payment_currency_code)
11839: where invoice_id = t_inv_lines_table(i).invoice_id;
11840: END IF;

Line 11939: ,pay_curr_invoice_amount = ap_utilities_pkg.ap_round_currency

11935: ----------------------------------------------------------------
11936:
11937: update ap_invoices_all
11938: set amount_applicable_to_discount = amount_applicable_to_discount + l_retained_amount
11939: ,pay_curr_invoice_amount = ap_utilities_pkg.ap_round_currency
11940: ((invoice_amount + l_retained_amount) * payment_cross_rate,
11941: payment_currency_code)
11942: where invoice_id = p_invoice_rec.invoice_id
11943: and nvl(net_of_retainage_flag, 'N') <> 'Y';

Line 12459: , pay_curr_invoice_amount = ap_utilities_pkg.ap_round_currency(

12455:
12456: UPDATE ap_invoices_all
12457: SET amount_applicable_to_discount = amount_applicable_to_discount
12458: + l_retained_amount
12459: , pay_curr_invoice_amount = ap_utilities_pkg.ap_round_currency(
12460: (invoice_amount + l_retained_amount)
12461: * payment_cross_rate
12462: , payment_currency_code)
12463: WHERE invoice_id = p_invoice_rec.invoice_id