DBA Data[Home] [Help]

APPS.FEM_SOURCE_DATA_LOADER_PKG dependencies on FND_GLOBAL

Line 136: l_request_id := FND_GLOBAL.Conc_Request_Id;

132: e_exp_error EXCEPTION;
133: BEGIN
134: -- set value of debug log current level
135: g_log_current_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
136: l_request_id := FND_GLOBAL.Conc_Request_Id;
137:
138: IF G_LOG_LEVEL_PROCEDURE >= g_log_current_level THEN
139: FEM_ENGINES_PKG.TECH_MESSAGE(
140: p_severity => G_LOG_LEVEL_PROCEDURE,

Line 233: p_request_id => FND_GLOBAL.Conc_Request_Id,

229: p_ledger_id => l_ledger_id,
230: p_cal_period_id => l_cal_period_id,
231: p_dataset_code => l_dataset_code,
232: p_source_system_code => l_source_system_code,
233: p_request_id => FND_GLOBAL.Conc_Request_Id,
234: p_user_id => FND_GLOBAL.User_Id,
235: p_login_id => FND_GLOBAL.Login_Id,
236: p_program_id => FND_GLOBAL.Conc_Program_Id,
237: p_program_application_id => FND_GLOBAL.Prog_Appl_ID,

Line 234: p_user_id => FND_GLOBAL.User_Id,

230: p_cal_period_id => l_cal_period_id,
231: p_dataset_code => l_dataset_code,
232: p_source_system_code => l_source_system_code,
233: p_request_id => FND_GLOBAL.Conc_Request_Id,
234: p_user_id => FND_GLOBAL.User_Id,
235: p_login_id => FND_GLOBAL.Login_Id,
236: p_program_id => FND_GLOBAL.Conc_Program_Id,
237: p_program_application_id => FND_GLOBAL.Prog_Appl_ID,
238: x_prev_req_id => l_prev_req_id,

Line 235: p_login_id => FND_GLOBAL.Login_Id,

231: p_dataset_code => l_dataset_code,
232: p_source_system_code => l_source_system_code,
233: p_request_id => FND_GLOBAL.Conc_Request_Id,
234: p_user_id => FND_GLOBAL.User_Id,
235: p_login_id => FND_GLOBAL.Login_Id,
236: p_program_id => FND_GLOBAL.Conc_Program_Id,
237: p_program_application_id => FND_GLOBAL.Prog_Appl_ID,
238: x_prev_req_id => l_prev_req_id,
239: x_exec_state => l_exec_state,

Line 236: p_program_id => FND_GLOBAL.Conc_Program_Id,

232: p_source_system_code => l_source_system_code,
233: p_request_id => FND_GLOBAL.Conc_Request_Id,
234: p_user_id => FND_GLOBAL.User_Id,
235: p_login_id => FND_GLOBAL.Login_Id,
236: p_program_id => FND_GLOBAL.Conc_Program_Id,
237: p_program_application_id => FND_GLOBAL.Prog_Appl_ID,
238: x_prev_req_id => l_prev_req_id,
239: x_exec_state => l_exec_state,
240: x_return_status => l_return_status);

Line 237: p_program_application_id => FND_GLOBAL.Prog_Appl_ID,

233: p_request_id => FND_GLOBAL.Conc_Request_Id,
234: p_user_id => FND_GLOBAL.User_Id,
235: p_login_id => FND_GLOBAL.Login_Id,
236: p_program_id => FND_GLOBAL.Conc_Program_Id,
237: p_program_application_id => FND_GLOBAL.Prog_Appl_ID,
238: x_prev_req_id => l_prev_req_id,
239: x_exec_state => l_exec_state,
240: x_return_status => l_return_status);
241:

Line 315: p_arg1 => FND_GLOBAL.Conc_Request_Id,

311: p_eng_prg => 'FEM_SOURCE_DATA_LOADER_PKG.Process_Data',
312: p_condition => l_condition,
313: p_failed_req_id => l_prev_req_id,
314: p_reuse_slices => l_reuse_slices,
315: p_arg1 => FND_GLOBAL.Conc_Request_Id,
316: p_arg2 => p_exec_mode,
317: p_arg3 => l_table_name,
318: p_arg4 => l_interface_table_name,
319: p_arg5 => l_object_id,

Line 441: p_request_id => FND_GLOBAL.Conc_Request_Id,

437: p_cal_period_id => l_cal_period_id,
438: p_dataset_code => l_dataset_code,
439: p_source_system_code => l_source_system_code,
440: p_exec_status => l_exec_status,
441: p_request_id => FND_GLOBAL.Conc_Request_Id,
442: p_user_id => FND_GLOBAL.User_Id,
443: p_login_id => FND_GLOBAL.Login_Id,
444: x_return_status => l_return_status);
445:

Line 442: p_user_id => FND_GLOBAL.User_Id,

438: p_dataset_code => l_dataset_code,
439: p_source_system_code => l_source_system_code,
440: p_exec_status => l_exec_status,
441: p_request_id => FND_GLOBAL.Conc_Request_Id,
442: p_user_id => FND_GLOBAL.User_Id,
443: p_login_id => FND_GLOBAL.Login_Id,
444: x_return_status => l_return_status);
445:
446: IF G_LOG_LEVEL_PROCEDURE >= g_log_current_level THEN

Line 443: p_login_id => FND_GLOBAL.Login_Id,

439: p_source_system_code => l_source_system_code,
440: p_exec_status => l_exec_status,
441: p_request_id => FND_GLOBAL.Conc_Request_Id,
442: p_user_id => FND_GLOBAL.User_Id,
443: p_login_id => FND_GLOBAL.Login_Id,
444: x_return_status => l_return_status);
445:
446: IF G_LOG_LEVEL_PROCEDURE >= g_log_current_level THEN
447: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 468: p_request_id => FND_GLOBAL.Conc_Request_Id,

464: p_cal_period_id => l_cal_period_id,
465: p_dataset_code => l_dataset_code,
466: p_source_system_code => l_source_system_code,
467: p_exec_status => 'ERROR_RERUN',
468: p_request_id => FND_GLOBAL.Conc_Request_Id,
469: p_user_id => FND_GLOBAL.User_Id,
470: p_login_id => FND_GLOBAL.Login_Id,
471: x_return_status => l_return_status);
472: ELSE

Line 469: p_user_id => FND_GLOBAL.User_Id,

465: p_dataset_code => l_dataset_code,
466: p_source_system_code => l_source_system_code,
467: p_exec_status => 'ERROR_RERUN',
468: p_request_id => FND_GLOBAL.Conc_Request_Id,
469: p_user_id => FND_GLOBAL.User_Id,
470: p_login_id => FND_GLOBAL.Login_Id,
471: x_return_status => l_return_status);
472: ELSE
473: -- Post error rerun message to concurrent log

Line 470: p_login_id => FND_GLOBAL.Login_Id,

466: p_source_system_code => l_source_system_code,
467: p_exec_status => 'ERROR_RERUN',
468: p_request_id => FND_GLOBAL.Conc_Request_Id,
469: p_user_id => FND_GLOBAL.User_Id,
470: p_login_id => FND_GLOBAL.Login_Id,
471: x_return_status => l_return_status);
472: ELSE
473: -- Post error rerun message to concurrent log
474: FEM_ENGINES_PKG.User_Message

Line 514: p_request_id => FND_GLOBAL.Conc_Request_Id,

510: p_cal_period_id => l_cal_period_id,
511: p_dataset_code => l_dataset_code,
512: p_source_system_code => l_source_system_code,
513: p_exec_status => 'ERROR_RERUN',
514: p_request_id => FND_GLOBAL.Conc_Request_Id,
515: p_user_id => FND_GLOBAL.User_Id,
516: p_login_id => FND_GLOBAL.Login_Id,
517: x_return_status => l_return_status);
518: ELSE

Line 515: p_user_id => FND_GLOBAL.User_Id,

511: p_dataset_code => l_dataset_code,
512: p_source_system_code => l_source_system_code,
513: p_exec_status => 'ERROR_RERUN',
514: p_request_id => FND_GLOBAL.Conc_Request_Id,
515: p_user_id => FND_GLOBAL.User_Id,
516: p_login_id => FND_GLOBAL.Login_Id,
517: x_return_status => l_return_status);
518: ELSE
519: -- Post error rerun message to concurrent log

Line 516: p_login_id => FND_GLOBAL.Login_Id,

512: p_source_system_code => l_source_system_code,
513: p_exec_status => 'ERROR_RERUN',
514: p_request_id => FND_GLOBAL.Conc_Request_Id,
515: p_user_id => FND_GLOBAL.User_Id,
516: p_login_id => FND_GLOBAL.Login_Id,
517: x_return_status => l_return_status);
518: ELSE
519: -- Post error rerun message to concurrent log
520: FEM_ENGINES_PKG.User_Message

Line 3332: AND f.user_id = FND_GLOBAL.user_id

3328: WHERE od.object_definition_id = p_obj_def_id
3329: AND od.object_id = o.object_id
3330: AND o.object_type_code = 'SOURCE_DATA_LOADER'
3331: AND o.folder_id = f.folder_id
3332: AND f.user_id = FND_GLOBAL.user_id
3333: AND d.object_id = o.object_id
3334: AND d.table_name = t.table_name
3335: AND table_classification_code = 'SOURCE_DATA_TABLE'
3336: AND old_approved_copy_flag = 'N';

Line 3616: fnd_global.lookup_security_group(lookup_type, view_application_id)

3612: AND lookup_code = p_exec_mode
3613: AND language = USERENV('LANG')
3614: AND view_application_id = 274
3615: AND security_group_id =
3616: fnd_global.lookup_security_group(lookup_type, view_application_id)
3617: AND enabled_flag = 'Y'
3618: AND lookup_code IN ('R','E','S');
3619:
3620: -- End of Replacement mode enhancement