[Home] [Help]
1164: AND xal.ae_header_id = xah.ae_header_id
1165: AND xdl.event_id = xah.event_id
1166: AND xdl.ae_header_id = xah.ae_header_id
1167: AND xdl.ae_line_num = xal.ae_line_num
1168: AND xdl.source_distribution_type = ''FV_TREASURY_CONFIRMATIONS_ALL''
1169: AND xdl.source_distribution_id_num_1 = aphd.payment_hist_dist_id
1170: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
1171: AND xdl.application_id = 8901
1172:
2317: ELSIF l_reference_1 IS NOT NULL THEN
2318: BEGIN
2319: SELECT 'Y'
2320: INTO l_exists
2321: FROM Fv_treasury_confirmations_all
2322: WHERE treasury_confirmation_id = to_number(l_reference_1)
2323: AND org_id = p_def_org_id;
2324:
2325: EXCEPTION
2328: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2330: l_module_name,
2331: ' NO_DATA_FOUND WHEN SELECTING FROM '||
2332: 'FV_TREASURY_CONFIRMATIONS_ALL WITH REF_1, HENCE MANUAL');
2333: END IF;
2334:
2335: When INVALID_NUMBER OR VALUE_ERROR THEN
2336: l_name := 'MANUAL';
2914: BEGIN
2915:
2916: SELECT cba.agency_location_code
2917: INTO l_temp_alc_code
2918: FROM Fv_Treasury_Confirmations_all ftc,
2919: Ap_Inv_Selection_Criteria_all aisc,
2920: ce_bank_accounts cba,
2921: ce_bank_acct_uses_all cbau
2922: WHERE ftc.treasury_confirmation_id = to_number(l_reference_1)
3410: ELSE
3411: BEGIN
3412: SELECT treasury_doc_date
3413: INTO l_accomplish_date
3414: FROM fv_treasury_confirmations_all
3415: WHERE TO_CHAR(treasury_confirmation_id) = l_reference_1
3416: AND org_id = p_def_org_id;
3417: EXCEPTION
3418: WHEN TOO_MANY_ROWS THEN
3428: WHEN OTHERS THEN
3429: p_error_code := -1 ;
3430: p_error_msg := SQLERRM|| ' - Error when deriving the ' ||
3431: ' treasury_doc_date from ' ||
3432: 'fv_treasury_confirmations_all.';
3433: END ;
3434: END IF;
3435:
3436: l_sf1219_type_code := 'DISBURSEMENT' ;