11: g_ret_sts_unexp_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_unexp_error;
12:
13: c_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;
14:
15: c_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
16: c_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
17: c_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
18: c_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
19: c_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
12:
13: c_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;
14:
15: c_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
16: c_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
17: c_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
18: c_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
19: c_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
20: c_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
13: c_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;
14:
15: c_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
16: c_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
17: c_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
18: c_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
19: c_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
20: c_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
21:
14:
15: c_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
16: c_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
17: c_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
18: c_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
19: c_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
20: c_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
21:
22: -- ******************************************************************************
15: c_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
16: c_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
17: c_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
18: c_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
19: c_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
20: c_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
21:
22: -- ******************************************************************************
23: PROCEDURE get_personal_folder (p_user_id IN NUMBER, p_folder_id OUT NOCOPY NUMBER) AS
16: c_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
17: c_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
18: c_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
19: c_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
20: c_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
21:
22: -- ******************************************************************************
23: PROCEDURE get_personal_folder (p_user_id IN NUMBER, p_folder_id OUT NOCOPY NUMBER) AS
24: