179: l_total_customers NUMBER;
180: l_region_code NUMBER;
181: l_object_def_id NUMBER;
182: l_cust_wo_rgn_code NUMBER;
183: l_request_id NUMBER := FND_GLOBAL.Conc_Request_Id;
184: l_user_id NUMBER := FND_GLOBAL.User_Id;
185: l_login_id NUMBER := FND_GLOBAL.Login_Id;
186:
187: TYPE v_msg_list_type IS VARRAY(20) OF
180: l_region_code NUMBER;
181: l_object_def_id NUMBER;
182: l_cust_wo_rgn_code NUMBER;
183: l_request_id NUMBER := FND_GLOBAL.Conc_Request_Id;
184: l_user_id NUMBER := FND_GLOBAL.User_Id;
185: l_login_id NUMBER := FND_GLOBAL.Login_Id;
186:
187: TYPE v_msg_list_type IS VARRAY(20) OF
188: fem_mp_process_ctl_t.message%TYPE;
181: l_object_def_id NUMBER;
182: l_cust_wo_rgn_code NUMBER;
183: l_request_id NUMBER := FND_GLOBAL.Conc_Request_Id;
184: l_user_id NUMBER := FND_GLOBAL.User_Id;
185: l_login_id NUMBER := FND_GLOBAL.Login_Id;
186:
187: TYPE v_msg_list_type IS VARRAY(20) OF
188: fem_mp_process_ctl_t.message%TYPE;
189: v_msg_list v_msg_list_type;
897: l_msg_data VARCHAR2(500);
898: l_return_status VARCHAR2(20);
899: l_effective_date DATE;
900: l_user_id NUMBER;
901: l_login_id NUMBER := FND_GLOBAL.Login_Id;
902:
903: BEGIN
904: l_request_id := FND_GLOBAL.Conc_Request_Id;
905: l_user_id := FND_GLOBAL.User_Id;
900: l_user_id NUMBER;
901: l_login_id NUMBER := FND_GLOBAL.Login_Id;
902:
903: BEGIN
904: l_request_id := FND_GLOBAL.Conc_Request_Id;
905: l_user_id := FND_GLOBAL.User_Id;
906: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
907:
908: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
901: l_login_id NUMBER := FND_GLOBAL.Login_Id;
902:
903: BEGIN
904: l_request_id := FND_GLOBAL.Conc_Request_Id;
905: l_user_id := FND_GLOBAL.User_Id;
906: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
907:
908: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
909: ,p_module => G_BLOCK||'.'||l_api_name
1158: l_msg_data VARCHAR2(500);
1159: l_return_status VARCHAR2(20);
1160: l_effective_date DATE;
1161: l_user_id NUMBER;
1162: l_login_id NUMBER := FND_GLOBAL.Login_Id;
1163:
1164: BEGIN
1165: l_request_id := FND_GLOBAL.Conc_Request_Id;
1166: l_user_id := FND_GLOBAL.User_Id;
1161: l_user_id NUMBER;
1162: l_login_id NUMBER := FND_GLOBAL.Login_Id;
1163:
1164: BEGIN
1165: l_request_id := FND_GLOBAL.Conc_Request_Id;
1166: l_user_id := FND_GLOBAL.User_Id;
1167: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
1168:
1169: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1162: l_login_id NUMBER := FND_GLOBAL.Login_Id;
1163:
1164: BEGIN
1165: l_request_id := FND_GLOBAL.Conc_Request_Id;
1166: l_user_id := FND_GLOBAL.User_Id;
1167: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
1168:
1169: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1170: ,p_module => G_BLOCK||'.'||l_api_name