eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ROLE_UTILS dependencies on PA_DEBUG

Line 34: pa_debug.init_err_stack ('pa_role_utils.Check_Role_Name_Or_Id');

30: l_num_ids NUMBER:= 0;
31: l_id_found_flag VARCHAR(1) := 'N';
32:
33: BEGIN
34: pa_debug.init_err_stack ('pa_role_utils.Check_Role_Name_Or_Id');
35: IF p_role_id IS NOT NULL AND p_role_id <> FND_API.G_MISS_NUM THEN
36: IF p_check_id_flag = 'Y' THEN
37: SELECT project_role_id
38: INTO x_role_id

Line 93: pa_debug.reset_err_stack;

89: END IF;
90: END IF;
91:
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93: pa_debug.reset_err_stack;
94: EXCEPTION
95: WHEN NO_DATA_FOUND THEN
96: x_role_id := null;
97: x_return_status := FND_API.G_RET_STS_ERROR;

Line 108: p_procedure_name => pa_debug.g_err_stack );

104: WHEN OTHERS THEN
105: x_role_id := null;
106: fnd_msg_pub.add_exc_msg
107: (p_pkg_name => 'PA_ROLE_UTILS',
108: p_procedure_name => pa_debug.g_err_stack );
109: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
110: RAISE;
111: END Check_Role_Name_Or_Id;
112:

Line 127: pa_debug.init_err_stack ('pa_role_utils.Check_Role_RoleList');

123:
124: l_status VARCHAR2(10) ;
125: l_sysdate DATE := TRUNC(sysdate);
126: BEGIN
127: pa_debug.init_err_stack ('pa_role_utils.Check_Role_RoleList');
128:
129: x_return_status := FND_API.G_RET_STS_SUCCESS;
130:
131: begin

Line 168: p_procedure_name => pa_debug.g_err_stack );

164:
165: WHEN OTHERS THEN
166: fnd_msg_pub.add_exc_msg
167: (p_pkg_name => 'PA_ROLE_UTILS',
168: p_procedure_name => pa_debug.g_err_stack );
169: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
170: RAISE;
171: END;
172:

Line 220: p_procedure_name => pa_debug.g_err_stack );

216:
217: WHEN OTHERS THEN
218: fnd_msg_pub.add_exc_msg
219: (p_pkg_name => 'PA_ROLE_LIST_UTILS',
220: p_procedure_name => pa_debug.g_err_stack );
221: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
222: RAISE;
223:
224: END;

Line 244: pa_debug.reset_err_stack;

240: );
241:
242: x_return_status := FND_API.G_RET_STS_SUCCESS;
243: x_error_message_code := NULL;
244: pa_debug.reset_err_stack;
245:
246: EXCEPTION
247: WHEN NO_DATA_FOUND THEN
248: x_return_status := FND_API.G_RET_STS_ERROR;

Line 253: p_procedure_name => pa_debug.g_err_stack );

249: x_error_message_code := 'PA_ROLE_NOT_IN_ROLELIST';
250: WHEN OTHERS THEN
251: fnd_msg_pub.add_exc_msg
252: (p_pkg_name => 'PA_ROLE_UTILS',
253: p_procedure_name => pa_debug.g_err_stack );
254: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
255: RAISE;
256:
257: END Check_Role_RoleList;

Line 291: pa_debug.init_err_stack ('pa_role_utils.get_role_defaults');

287: default_job_id
288: FROM pa_project_role_types_vl
289: WHERE project_role_id = p_role_id ;
290: BEGIN
291: pa_debug.init_err_stack ('pa_role_utils.get_role_defaults');
292: OPEN l_role_csr;
293: FETCH l_role_csr INTO
294: x_meaning,
295: x_default_min_job_level,

Line 303: pa_debug.reset_err_stack;

299: IF l_role_csr%NOTFOUND THEN
300: x_return_status := FND_API.G_RET_STS_ERROR;
301: x_error_message_code := 'PA_ROLE_INVALID_AMBIGOUS';
302: CLOSE l_role_csr;
303: pa_debug.reset_err_stack;
304: RETURN;
305: END IF;
306: CLOSE l_role_csr;
307: -- Get the info on whether the role is schedulable here

Line 323: pa_debug.reset_err_stack;

319: -- if l_num = 0;
320: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
321: x_error_message_code := l_error_message_code;
322: x_return_status := l_return_status;
323: pa_debug.reset_err_stack;
324: RETURN ;
325: END IF ;
326: x_def_competencies := l_competency_tbl;
327: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 328: pa_debug.reset_err_stack;

324: RETURN ;
325: END IF ;
326: x_def_competencies := l_competency_tbl;
327: x_return_status:= FND_API.G_RET_STS_SUCCESS;
328: pa_debug.reset_err_stack;
329: EXCEPTION
330: WHEN OTHERS THEN
331: fnd_msg_pub.add_exc_msg
332: (p_pkg_name => 'PA_ROLE_UTILS',

Line 333: p_procedure_name => pa_debug.g_err_stack );

329: EXCEPTION
330: WHEN OTHERS THEN
331: fnd_msg_pub.add_exc_msg
332: (p_pkg_name => 'PA_ROLE_UTILS',
333: p_procedure_name => pa_debug.g_err_stack );
334: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
335: RAISE;
336: END Get_Role_Defaults;
337:

Line 356: pa_debug.init_err_stack ('pa_role_utils.validate_role_competency');

352: SELECT business_group_id
353: FROM per_competences
354: WHERE competence_id = p_competence_id;
355: BEGIN
356: pa_debug.init_err_stack ('pa_role_utils.validate_role_competency');
357: OPEN l_get_bg_csr;
358: FETCH l_get_bg_csr INTO l_business_group_id;
359: IF l_get_bg_csr%NOTFOUND THEN
360: x_return_status := FND_API.G_RET_STS_ERROR;

Line 375: pa_debug.reset_err_stack;

371: ELSE
372: x_return_status := FND_API.G_RET_STS_SUCCESS;
373: END IF;
374: CLOSE l_get_bg_csr;
375: pa_debug.reset_err_stack;
376: EXCEPTION
377: WHEN OTHERS THEN
378: fnd_msg_pub.add_exc_msg
379: (p_pkg_name => 'PA_ROLE_UTILS',

Line 380: p_procedure_name => pa_debug.g_err_stack );

376: EXCEPTION
377: WHEN OTHERS THEN
378: fnd_msg_pub.add_exc_msg
379: (p_pkg_name => 'PA_ROLE_UTILS',
380: p_procedure_name => pa_debug.g_err_stack );
381: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
382: RAISE;
383: END Validate_Role_Competency ;
384: