8: pc_log_level_event CONSTANT NUMBER := FND_LOG.level_event;
9: pc_log_level_error CONSTANT NUMBER := FND_LOG.level_error;
10: pc_log_level_unexpected CONSTANT NUMBER := FND_LOG.level_unexpected;
11: pc_api_version CONSTANT NUMBER := 1.0;
12: pv_req_id CONSTANT NUMBER := FND_GLOBAL.Conc_Request_Id;
13: pv_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;
14: pv_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;
15: pc_max_disp_len constant number := 15;
16: pc_success constant number := 0;
9: pc_log_level_error CONSTANT NUMBER := FND_LOG.level_error;
10: pc_log_level_unexpected CONSTANT NUMBER := FND_LOG.level_unexpected;
11: pc_api_version CONSTANT NUMBER := 1.0;
12: pv_req_id CONSTANT NUMBER := FND_GLOBAL.Conc_Request_Id;
13: pv_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;
14: pv_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;
15: pc_max_disp_len constant number := 15;
16: pc_success constant number := 0;
17: pc_failure constant number := 2;
10: pc_log_level_unexpected CONSTANT NUMBER := FND_LOG.level_unexpected;
11: pc_api_version CONSTANT NUMBER := 1.0;
12: pv_req_id CONSTANT NUMBER := FND_GLOBAL.Conc_Request_Id;
13: pv_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;
14: pv_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;
15: pc_max_disp_len constant number := 15;
16: pc_success constant number := 0;
17: pc_failure constant number := 2;
18: v_new_hier_obj_def_created BOOLEAN := FALSE;
2634: p_hier_rule_obj_def_id IN NUMBER) IS
2635: FEM_INTG_fatal_err EXCEPTION;
2636: TYPE DimensionGroupID_cursor IS REF CURSOR;
2637: DimensionGroupID DimensionGroupID_cursor;
2638: pv_pgm_id CONSTANT NUMBER := FND_GLOBAL.Conc_Program_Id;
2639: pv_pgm_app_id CONSTANT NUMBER := FND_GLOBAL.Prog_Appl_ID;
2640: v_msg_count NUMBER;
2641: v_msg_data VARCHAR2(4000);
2642: v_API_return_status VARCHAR2(30);
2635: FEM_INTG_fatal_err EXCEPTION;
2636: TYPE DimensionGroupID_cursor IS REF CURSOR;
2637: DimensionGroupID DimensionGroupID_cursor;
2638: pv_pgm_id CONSTANT NUMBER := FND_GLOBAL.Conc_Program_Id;
2639: pv_pgm_app_id CONSTANT NUMBER := FND_GLOBAL.Prog_Appl_ID;
2640: v_msg_count NUMBER;
2641: v_msg_data VARCHAR2(4000);
2642: v_API_return_status VARCHAR2(30);
2643: v_compl_code NUMBER;