174: l_error_code NUMBER;
175:
176: BEGIN
177:
178: l_user_id := xla_environment_pkg.g_usr_id;
179: l_login_id := xla_environment_pkg.g_login_id;
180: l_date := SYSDATE;
181: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
182: l_prog_id := xla_environment_pkg.g_prog_id;
175:
176: BEGIN
177:
178: l_user_id := xla_environment_pkg.g_usr_id;
179: l_login_id := xla_environment_pkg.g_login_id;
180: l_date := SYSDATE;
181: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
182: l_prog_id := xla_environment_pkg.g_prog_id;
183: l_req_id := xla_environment_pkg.g_req_id;
177:
178: l_user_id := xla_environment_pkg.g_usr_id;
179: l_login_id := xla_environment_pkg.g_login_id;
180: l_date := SYSDATE;
181: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
182: l_prog_id := xla_environment_pkg.g_prog_id;
183: l_req_id := xla_environment_pkg.g_req_id;
184:
185: IF g_log_enabled THEN
178: l_user_id := xla_environment_pkg.g_usr_id;
179: l_login_id := xla_environment_pkg.g_login_id;
180: l_date := SYSDATE;
181: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
182: l_prog_id := xla_environment_pkg.g_prog_id;
183: l_req_id := xla_environment_pkg.g_req_id;
184:
185: IF g_log_enabled THEN
186: l_log_module := C_DEFAULT_MODULE||'.upload_rules';
179: l_login_id := xla_environment_pkg.g_login_id;
180: l_date := SYSDATE;
181: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
182: l_prog_id := xla_environment_pkg.g_prog_id;
183: l_req_id := xla_environment_pkg.g_req_id;
184:
185: IF g_log_enabled THEN
186: l_log_module := C_DEFAULT_MODULE||'.upload_rules';
187: END IF;