10: e_pagg_no_setting_found EXCEPTION;
11: e_pagg_update_tb_label_fail EXCEPTION;
12:
13: --bug 3236479
14: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
15: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
17: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
18: g_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
11: e_pagg_update_tb_label_fail EXCEPTION;
12:
13: --bug 3236479
14: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
15: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
17: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
18: g_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
19: G_ERROR_LEVEL NUMBER :=FND_LOG.LEVEL_EXCEPTION;
12:
13: --bug 3236479
14: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
15: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
17: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
18: g_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
19: G_ERROR_LEVEL NUMBER :=FND_LOG.LEVEL_EXCEPTION;
20:
13: --bug 3236479
14: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
15: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
17: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
18: g_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
19: G_ERROR_LEVEL NUMBER :=FND_LOG.LEVEL_EXCEPTION;
20:
21: FUNCTION transform_and_save (p_name VARCHAR2,
14: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
15: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
17: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
18: g_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
19: G_ERROR_LEVEL NUMBER :=FND_LOG.LEVEL_EXCEPTION;
20:
21: FUNCTION transform_and_save (p_name VARCHAR2,
22: p_ref_date DATE,
15: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
17: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
18: g_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
19: G_ERROR_LEVEL NUMBER :=FND_LOG.LEVEL_EXCEPTION;
20:
21: FUNCTION transform_and_save (p_name VARCHAR2,
22: p_ref_date DATE,
23: p_caller_flag VARCHAR2)