APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on FV_AR_FIN_CHRG_INVOICES

Line 1212: debug(l_module_name,'Insert fv_ar_fin_chrg_invoices');

1208:
1209: IF (p_retcode = g_SUCCESS) THEN
1210: BEGIN
1211: IF (fnd_log.level_statement >= g_CURRENT_LOG_LEVEL) THEN
1212: debug(l_module_name,'Insert fv_ar_fin_chrg_invoices');
1213: END IF;
1214: INSERT INTO fv_ar_fin_chrg_invoices
1215: (
1216: org_id,

Line 1214: INSERT INTO fv_ar_fin_chrg_invoices

1210: BEGIN
1211: IF (fnd_log.level_statement >= g_CURRENT_LOG_LEVEL) THEN
1212: debug(l_module_name,'Insert fv_ar_fin_chrg_invoices');
1213: END IF;
1214: INSERT INTO fv_ar_fin_chrg_invoices
1215: (
1216: org_id,
1217: customer_id,
1218: invoice_id,

Line 1264: l_location := l_module_name||'.insert_fv_ar_fin_chrg_invoices';

1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: p_retcode := g_FAILURE;
1263: p_errbuf := SQLERRM;
1264: l_location := l_module_name||'.insert_fv_ar_fin_chrg_invoices';
1265: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1266: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
1267: END;
1268: END IF;

Line 1322: debug(l_module_name,'Updating fv_ar_fin_chrg_invoices(1)');

1318: END IF;
1319:
1320: IF (p_retcode = g_SUCCESS) THEN
1321: IF (fnd_log.level_statement >= g_CURRENT_LOG_LEVEL) THEN
1322: debug(l_module_name,'Updating fv_ar_fin_chrg_invoices(1)');
1323: END IF;
1324:
1325: BEGIN
1326: UPDATE fv_ar_fin_chrg_invoices

Line 1326: UPDATE fv_ar_fin_chrg_invoices

1322: debug(l_module_name,'Updating fv_ar_fin_chrg_invoices(1)');
1323: END IF;
1324:
1325: BEGIN
1326: UPDATE fv_ar_fin_chrg_invoices
1327: SET request_id=g_request_id,
1328: last_updated_by = g_user_id,
1329: last_update_date = SYSDATE,
1330: last_accrual_date = p_accrue_as_of_date,

Line 1338: UPDATE fv_ar_fin_chrg_invoices

1334: WHERE invoice_id = p_invoice_id;
1335:
1336: /* Bug 8515997: If p_invoice_id=l_root_invoice_id, then finance charges get doubled. Added condition to check it */
1337: IF (l_root_invoice_id <> p_invoice_id) THEN
1338: UPDATE fv_ar_fin_chrg_invoices
1339: SET last_updated_by = g_user_id,
1340: last_update_date = SYSDATE,
1341: finance_charges = NVL(finance_charges, 0) + p_finance_charges
1342: WHERE invoice_id = l_root_invoice_id;

Line 1352: l_location := l_module_name||'.update_fv_ar_fin_chrg_invoices (1)';

1348: EXCEPTION
1349: WHEN OTHERS THEN
1350: p_retcode := g_FAILURE;
1351: p_errbuf := SQLERRM;
1352: l_location := l_module_name||'.update_fv_ar_fin_chrg_invoices (1)';
1353: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1354: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
1355: END;
1356: END IF;

Line 1696: fv_ar_fin_chrg_invoices fai

1692: fv_finance_charge_history fch,
1693: ra_customer_trx rct,
1694: ra_cust_trx_types rctt,
1695: hz_cust_site_uses_all rsua,
1696: fv_ar_fin_chrg_invoices fai
1697: WHERE (due_date + first_accrual + grace_period) <= l_accrue_as_of_date
1698: AND fifc.waive_flag = 'N'
1699: AND aps.amount_due_remaining > 0
1700: AND aps.status <> 'CL'

Line 2358: INSERT INTO fv_ar_fin_chrg_invoices

2354: finance charges assigned to invoices and debit memos not created by the Accrue
2355: Finance charge process(AcFC) only. It should not display the charges assigned
2356: to debit memos created using AcFC process */
2357:
2358: INSERT INTO fv_ar_fin_chrg_invoices
2359: (
2360: org_id,
2361: customer_id,
2362: invoice_id,

Line 2417: FROM fv_ar_fin_chrg_invoices fai

2413: WHERE ract.bill_to_customer_id = fcfc.customer_id
2414: AND fcfc.enabled_flag = 'Y'
2415: AND fcfc.waive_flag = 'N')
2416: AND NOT EXISTS (SELECT 'x'
2417: FROM fv_ar_fin_chrg_invoices fai
2418: WHERE ract.customer_trx_id = fai.invoice_id
2419: AND ract.bill_to_customer_id=fai.customer_id);
2420: EXCEPTION
2421: WHEN OTHERS THEN