45: wf_event.seterrorinfo (p_event, 'WARNING');
46: l_ret_mode := 'WARNING';
47:
48: ELSE
49: DELETE fun_balance_accounts
50: WHERE (dr_bsv = l_bsv OR cr_bsv = l_bsv)
51: AND template_id IN (SELECT template_id
52: FROM fun_balance_options
53: WHERE ledger_id = l_ledger_id);
55: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
56: THEN
57: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
58: 'fun.plsql.fun_gl_asf_events_pkg.ledger_bsv_remove',
59: ' No. of rows deleted from fun_balance_accounts is ' ||
60: SQL%ROWCOUNT);
61: END IF;
62:
63:
131: wf_event.seterrorinfo (p_event, 'WARNING');
132: l_ret_mode := 'WARNING';
133:
134: ELSE
135: DELETE fun_balance_accounts
136: WHERE (dr_bsv = l_bsv OR cr_bsv = l_bsv)
137: AND template_id IN (SELECT template_id
138: FROM fun_balance_options
139: WHERE le_id = l_le_id);
141: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
142: THEN
143: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
144: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',
145: ' No. of rows deleted from fun_balance_accounts is ' ||
146: SQL%ROWCOUNT);
147: END IF;
148:
149:
338: wf_event.seterrorinfo (p_event, 'WARNING');
339: l_ret_mode := 'WARNING';
340:
341: ELSE
342: DELETE FROM fun_balance_accounts
343: WHERE template_id in (SELECT template_id
344: FROM fun_balance_options
345: WHERE ledger_id = l_sec_ledger_id);
346:
347: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
348: THEN
349: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
350: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
351: ' No. of rows deleted in fun_balance_accounts is ' ||
352: SQL%ROWCOUNT);
353: END IF;
354:
355: DELETE FROM fun_balance_options
444: wf_event.seterrorinfo (p_event, 'WARNING');
445: l_ret_mode := 'WARNING';
446:
447: ELSE
448: DELETE FROM fun_balance_accounts
449: WHERE template_id in (SELECT template_id
450: FROM fun_balance_options
451: WHERE ledger_id = l_rep_ledger_id);
452:
453: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
454: THEN
455: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
456: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
457: ' No. of rows deleted in fun_balance_accounts is ' ||
458: SQL%ROWCOUNT);
459: END IF;
460:
461: DELETE FROM fun_balance_options