[Home] [Help]
775: fv_fund_parameters ffp,
776: fv_treasury_symbols fts,
777: ap_invoices_all ai,
778: ap_invoice_distributions_all aid,
779: ap_invoice_payments_all aip,
780: ap_payment_hist_dists aphd,
781: gl_import_references glir,
782: xla_ae_headers xah,
783: xla_ae_lines xal,
954: fv_fund_parameters ffp,
955: fv_treasury_symbols fts,
956: ap_invoices_all ai,
957: ap_invoice_distributions_all aid,
958: ap_invoice_payments_all aip,
959: gl_import_references glir,
960: xla_ae_headers xah,
961: xla_ae_lines xal,
962: xla_events xet,
1133: fv_sf1219_definitions_accts fda,
1134: fv_fund_parameters ffp,
1135: fv_treasury_symbols fts,
1136: ap_invoice_distributions_all aid,
1137: ap_invoice_payments_all aip,
1138: ap_payment_hist_dists aphd,
1139: gl_import_references glir,
1140: xla_ae_headers xah,
1141: xla_ae_lines xal,
2498: ELSE
2499: BEGIN
2500: SELECT 'Y'
2501: INTO l_exists
2502: FROM ap_invoice_payments_all
2503: WHERE invoice_payment_id = to_number(l_REFERENCE_9)
2504: AND org_id = p_def_org_id;
2505: EXCEPTION
2506: WHEN NO_DATA_FOUND THEN
2509: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2510: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2511: l_module_name,' NO_DATA_FOUND ' ||
2512: ' WHEN SELECTING FROM ' ||
2513: ' AP_INVOICE_PAYMENTS_ALL ' ||
2514: ' WITH REF_9, HENCE MANUAL');
2515: END IF;
2516:
2517: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2998:
2999: BEGIN
3000: SELECT distinct org_id
3001: INTO l_org_id
3002: FROM ap_invoice_payments_all
3003: WHERE invoice_id = to_number(l_reference_2);
3004: EXCEPTION
3005: WHEN OTHERS THEN
3006: p_error_code := 2;
3101: -- Get agency location code
3102: BEGIN
3103: SELECT cba.agency_location_code
3104: INTO l_temp_alc_code
3105: FROM ap_invoice_payments_all aip,
3106: ap_checks_all aca,
3107: ce_bank_accounts cba,
3108: ce_bank_acct_uses_all cbau
3109: WHERE TO_CHAR(aip.invoice_id) = l_reference_2