APPS.PA_ROLE_PROFILES_UTILS dependencies on PA_DEBUG

Line 22: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

18:
19: l_current_id NUMBER := NULL;
20: l_num_ids NUMBER := 0;
21: l_id_found_flag VARCHAR(1) := 'N';
22: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
23:
24: CURSOR c_ids IS
25: SELECT business_group_id
26: FROM per_business_groups

Line 30: pa_debug.init_err_stack ('pa_role_profiles_utils.Check_BusGroup_Name_Or_Id');

26: FROM per_business_groups
27: WHERE name = p_business_group_name;
28: BEGIN
29: IF l_enable_log = 'Y' THEN
30: pa_debug.init_err_stack ('pa_role_profiles_utils.Check_BusGroup_Name_Or_Id');
31: END IF;
32:
33: IF p_business_group_id IS NOT NULL THEN
34: IF p_business_group_name IS NOT NULL THEN

Line 68: pa_debug.reset_err_stack;

64:
65: x_return_status:= FND_API.G_RET_STS_SUCCESS;
66: x_error_msg_code := NULL;
67: IF l_enable_log = 'Y' THEN
68: pa_debug.reset_err_stack;
69: END IF;
70:
71: EXCEPTION
72: WHEN NO_DATA_FOUND THEN

Line 86: p_procedure_name => pa_debug.g_err_stack );

82: WHEN OTHERS THEN
83: x_business_group_id := NULL;
84: fnd_msg_pub.add_exc_msg
85: (p_pkg_name => 'PA_ROLE_PROFILES_UTILS',
86: p_procedure_name => pa_debug.g_err_stack );
87: x_error_msg_code:= FND_API.G_RET_STS_UNEXP_ERROR;
88: RAISE;
89:
90: END Check_BusGroup_Name_Or_Id;

Line 111: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

107:
108: l_current_id NUMBER := NULL;
109: l_num_ids NUMBER := 0;
110: l_id_found_flag VARCHAR(1) := 'N';
111: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
112:
113: CURSOR c_ids IS
114: SELECT position_id
115: FROM per_positions

Line 119: pa_debug.init_err_stack ('pa_role_profiles_utils.Check_Position_Name_Or_Id');

115: FROM per_positions
116: WHERE name = p_position_name;
117: BEGIN
118: IF l_enable_log = 'Y' THEN
119: pa_debug.init_err_stack ('pa_role_profiles_utils.Check_Position_Name_Or_Id');
120: END IF;
121:
122: IF p_position_id IS NOT NULL THEN
123: IF p_position_name IS NOT NULL THEN

Line 157: pa_debug.reset_err_stack;

153:
154: x_return_status:= FND_API.G_RET_STS_SUCCESS;
155: x_error_msg_code := NULL;
156: IF l_enable_log = 'Y' THEN
157: pa_debug.reset_err_stack;
158: END IF;
159:
160: EXCEPTION
161: WHEN NO_DATA_FOUND THEN

Line 173: p_procedure_name => pa_debug.g_err_stack );

169: WHEN OTHERS THEN
170: x_position_id := NULL;
171: fnd_msg_pub.add_exc_msg
172: (p_pkg_name => 'PA_ROLE_PROFILES_UTILS',
173: p_procedure_name => pa_debug.g_err_stack );
174: x_error_msg_code:= FND_API.G_RET_STS_UNEXP_ERROR;
175: RAISE;
176:
177: END Check_Position_Name_Or_Id;

Line 209: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

205:
206: l_return_status VARCHAR2(1);
207: l_error_msg_code VARCHAR2(500);
208: l_exists VARCHAR(1);
209: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
210:
211: BEGIN
212: x_return_status := FND_API.G_RET_STS_SUCCESS;
213: --FND_MSG_PUB.initialize;

Line 370: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

366: l_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := p_role_id_tbl;
367: l_return_status VARCHAR2(1);
368: l_error_msg_code VARCHAR2(500);
369: l_sum NUMBER := 0;
370: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
371: BEGIN
372:
373: x_return_status := FND_API.G_RET_STS_SUCCESS;
374: