DBA Data[Home] [Help]

APPS.FEM_SOURCE_DATA_LOADER_PKG dependencies on FEM_PL_PKG

Line 772: -- FEM_PL_PKG.Register_Object_Execution

768: -- p_program_application_id : Concurrent program application ID
769: -- x_prev_req_id : Previously run (and now restarted) concurrent
770: -- request ID
771: -- x_exec_state : Object execution status set by call to
772: -- FEM_PL_PKG.Register_Object_Execution
773: -- x_return_status : Return status
774: -- (look at FND_API for the possible statuses)
775: -- Notes
776: --

Line 871: FEM_PL_PKG.Register_Request

867:
868: -- Init var
869: l_obj_exec_failed := G_FALSE;
870:
871: FEM_PL_PKG.Register_Request
872: (p_api_version => G_API_VERSION,
873: p_commit => G_TRUE,
874: p_cal_period_id => p_cal_period_id,
875: p_ledger_id => p_ledger_id,

Line 894: p_msg_text => 'Call to FEM_PL_PKG.Register_Request returned with status '

890: IF G_LOG_LEVEL_STATEMENT >= g_log_current_level THEN
891: FEM_ENGINES_PKG.Tech_Message
892: (p_severity => G_LOG_LEVEL_STATEMENT,
893: p_module => C_MODULE,
894: p_msg_text => 'Call to FEM_PL_PKG.Register_Request returned with status '
895: ||l_return_status);
896: END IF;
897:
898: IF l_msg_count > 0 THEN

Line 908: FEM_PL_PKG.Register_Object_Execution

904: IF l_return_status <> G_RET_STS_SUCCESS THEN
905: RAISE e_process_lock_error;
906: END IF;
907:
908: FEM_PL_PKG.Register_Object_Execution
909: (p_api_version => G_API_VERSION,
910: p_commit => G_TRUE,
911: p_request_id => p_request_id,
912: p_object_id => p_object_id,

Line 927: p_msg_text => 'Call to FEM_PL_PKG.Register_Object_Execution returned with '

923: IF G_LOG_LEVEL_STATEMENT >= g_log_current_level THEN
924: FEM_ENGINES_PKG.Tech_Message
925: (p_severity => G_LOG_LEVEL_STATEMENT,
926: p_module => C_MODULE,
927: p_msg_text => 'Call to FEM_PL_PKG.Register_Object_Execution returned with '
928: ||' status as '||l_return_status
929: ||', execution state as '||x_exec_state
930: ||' and previous request ID as '||to_char(x_prev_req_id));
931: END IF;

Line 946: FEM_PL_PKG.Register_Object_Def

942: l_obj_exec_failed := G_TRUE;
943: RAISE e_process_lock_error;
944: END IF;
945:
946: FEM_PL_PKG.Register_Object_Def
947: (p_api_version => G_API_VERSION,
948: p_commit => G_TRUE,
949: p_request_id => p_request_id,
950: p_object_id => p_object_id,

Line 962: p_msg_text => 'Call to FEM_PL_PKG.Register_Object_Def returned with status '

958: IF G_LOG_LEVEL_STATEMENT >= g_log_current_level THEN
959: FEM_ENGINES_PKG.Tech_Message
960: (p_severity => G_LOG_LEVEL_STATEMENT,
961: p_module => C_MODULE,
962: p_msg_text => 'Call to FEM_PL_PKG.Register_Object_Def returned with status '
963: ||l_return_status);
964: END IF;
965:
966: IF l_msg_count > 0 THEN

Line 976: FEM_PL_PKG.Register_Table

972: IF l_return_status <> G_RET_STS_SUCCESS THEN
973: RAISE e_process_lock_error;
974: END IF;
975:
976: FEM_PL_PKG.Register_Table
977: (p_api_version => G_API_VERSION,
978: p_commit => G_TRUE,
979: p_request_id => p_request_id,
980: p_object_id => p_object_id,

Line 994: p_msg_text => 'Call to FEM_PL_PKG.Register_Table returned with status '

990: IF G_LOG_LEVEL_STATEMENT >= g_log_current_level THEN
991: FEM_ENGINES_PKG.Tech_Message
992: (p_severity => G_LOG_LEVEL_STATEMENT,
993: p_module => C_MODULE,
994: p_msg_text => 'Call to FEM_PL_PKG.Register_Table returned with status '
995: ||l_return_status);
996: END IF;
997:
998: IF l_msg_count > 0 THEN

Line 1064: FEM_PL_PKG.Unregister_Request

1060: END IF;
1061:
1062: IF l_obj_exec_failed = G_TRUE THEN
1063: -- Unregister the concurrent request to clean up data
1064: FEM_PL_PKG.Unregister_Request
1065: (p_api_version => G_API_VERSION,
1066: p_commit => G_FALSE,
1067: p_request_id => p_request_id,
1068: x_msg_count => l_msg_count,

Line 1075: p_msg_text => 'Call to FEM_PL_PKG.Unregister_Request returned with status '

1071:
1072: FEM_ENGINES_PKG.TECH_MESSAGE(
1073: p_severity => G_LOG_LEVEL_STATEMENT,
1074: p_module => C_MODULE,
1075: p_msg_text => 'Call to FEM_PL_PKG.Unregister_Request returned with status '
1076: ||l_return_status);
1077: END IF;
1078:
1079: WHEN others THEN

Line 2943: FEM_PL_PKG.Update_Num_of_Output_Rows(

2939: p_token2 => 'REJECTNUM',
2940: p_value2 => l_num_rows_rejected);
2941:
2942: -- Update Number of Output Rows
2943: FEM_PL_PKG.Update_Num_of_Output_Rows(
2944: p_api_version => G_API_VERSION,
2945: p_commit => G_TRUE,
2946: p_request_id => p_request_id,
2947: p_object_id => p_object_id,

Line 2961: p_msg_text => 'Call to FEM_PL_PKG.Update_Num_of_Output_Rows returned with status '

2957: IF G_LOG_LEVEL_STATEMENT >= g_log_current_level THEN
2958: FEM_ENGINES_PKG.Tech_Message
2959: (p_severity => G_LOG_LEVEL_STATEMENT,
2960: p_module => C_MODULE,
2961: p_msg_text => 'Call to FEM_PL_PKG.Update_Num_of_Output_Rows returned with status '
2962: ||l_return_status);
2963: END IF;
2964:
2965: IF l_msg_count > 0 THEN

Line 2976: FEM_PL_PKG.Update_Obj_Exec_Status(

2972: RAISE e_unexp_error;
2973: END IF;
2974:
2975: -- Update Object Execution Status
2976: FEM_PL_PKG.Update_Obj_Exec_Status(
2977: p_api_version => G_API_VERSION,
2978: p_commit => G_TRUE,
2979: p_request_id => p_request_id,
2980: p_object_id => p_object_id,

Line 2992: p_msg_text => 'Call to FEM_PL_PKG.pdate_Obj_Exec_Status returned with status '

2988: IF G_LOG_LEVEL_STATEMENT >= g_log_current_level THEN
2989: FEM_ENGINES_PKG.Tech_Message
2990: (p_severity => G_LOG_LEVEL_STATEMENT,
2991: p_module => C_MODULE,
2992: p_msg_text => 'Call to FEM_PL_PKG.pdate_Obj_Exec_Status returned with status '
2993: ||l_return_status);
2994: END IF;
2995:
2996: IF l_msg_count > 0 THEN

Line 3007: FEM_PL_PKG.Update_Obj_Exec_Errors(

3003: RAISE e_unexp_error;
3004: END IF;
3005:
3006: -- Update Object Execution Errors
3007: FEM_PL_PKG.Update_Obj_Exec_Errors(
3008: p_api_version => G_API_VERSION,
3009: p_commit => G_TRUE,
3010: p_request_id => p_request_id,
3011: p_object_id => p_object_id,

Line 3024: p_msg_text => 'Call to FEM_PL_PKG.Update_Obj_Exec_Errors returned with status '

3020: IF G_LOG_LEVEL_STATEMENT >= g_log_current_level THEN
3021: FEM_ENGINES_PKG.Tech_Message
3022: (p_severity => G_LOG_LEVEL_STATEMENT,
3023: p_module => C_MODULE,
3024: p_msg_text => 'Call to FEM_PL_PKG.Update_Obj_Exec_Errors returned with status '
3025: ||l_return_status);
3026: END IF;
3027:
3028: IF l_msg_count > 0 THEN

Line 3039: FEM_PL_PKG.Update_Request_Status(

3035: RAISE e_unexp_error;
3036: END IF;
3037:
3038: -- Update Request Status --
3039: FEM_PL_PKG.Update_Request_Status(
3040: p_api_version => G_API_VERSION,
3041: p_commit => G_TRUE,
3042: p_request_id => p_request_id,
3043: p_exec_status_code => p_exec_status,

Line 3054: p_msg_text => 'Call to FEM_PL_PKG.Update_Request_Status returned with status '

3050: IF G_LOG_LEVEL_STATEMENT >= g_log_current_level THEN
3051: FEM_ENGINES_PKG.Tech_Message
3052: (p_severity => G_LOG_LEVEL_STATEMENT,
3053: p_module => C_MODULE,
3054: p_msg_text => 'Call to FEM_PL_PKG.Update_Request_Status returned with status '
3055: ||l_return_status);
3056: END IF;
3057:
3058: IF l_msg_count > 0 THEN