153: l_exception_code VARCHAR2(50);
154: l_msg_data VARCHAR2(200);
155: l_return_status VARCHAR2(50) := NULL;
156: l_value_set_id NUMBER;
157: l_request_id NUMBER := FND_GLOBAL.Conc_Request_Id;
158: l_user_id NUMBER := FND_GLOBAL.User_Id;
159: l_login_id NUMBER := FND_GLOBAL.Login_Id;
160:
161: TYPE v_msg_list_type IS VARRAY(20) OF
154: l_msg_data VARCHAR2(200);
155: l_return_status VARCHAR2(50) := NULL;
156: l_value_set_id NUMBER;
157: l_request_id NUMBER := FND_GLOBAL.Conc_Request_Id;
158: l_user_id NUMBER := FND_GLOBAL.User_Id;
159: l_login_id NUMBER := FND_GLOBAL.Login_Id;
160:
161: TYPE v_msg_list_type IS VARRAY(20) OF
162: fem_mp_process_ctl_t.message%TYPE;
155: l_return_status VARCHAR2(50) := NULL;
156: l_value_set_id NUMBER;
157: l_request_id NUMBER := FND_GLOBAL.Conc_Request_Id;
158: l_user_id NUMBER := FND_GLOBAL.User_Id;
159: l_login_id NUMBER := FND_GLOBAL.Login_Id;
160:
161: TYPE v_msg_list_type IS VARRAY(20) OF
162: fem_mp_process_ctl_t.message%TYPE;
163: v_msg_list v_msg_list_type;
738: l_msg_data VARCHAR2(500);
739: l_return_status VARCHAR2(20);
740: l_effective_date DATE;
741: l_user_id NUMBER;
742: l_login_id NUMBER := FND_GLOBAL.login_id;
743:
744: BEGIN
745: l_request_id := FND_GLOBAL.Conc_Request_Id;
746: l_user_id := FND_GLOBAL.User_Id;
741: l_user_id NUMBER;
742: l_login_id NUMBER := FND_GLOBAL.login_id;
743:
744: BEGIN
745: l_request_id := FND_GLOBAL.Conc_Request_Id;
746: l_user_id := FND_GLOBAL.User_Id;
747: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
748:
749: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
742: l_login_id NUMBER := FND_GLOBAL.login_id;
743:
744: BEGIN
745: l_request_id := FND_GLOBAL.Conc_Request_Id;
746: l_user_id := FND_GLOBAL.User_Id;
747: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
748:
749: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
750: ,p_module => G_BLOCK||'.'||l_api_name