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_COMPETENCE_PUB dependencies on PA_DEBUG

Line 45: pa_debug.init_err_stack ('pa_competence_pub.add_competence_element');

41: l_role_id NUMBER := 0;
42: l_object_id PA_ASSIGNMENTS_PUB.assignment_id_tbl_type;
43:
44: BEGIN
45: pa_debug.init_err_stack ('pa_competence_pub.add_competence_element');
46: SAVEPOINT COMPETENCE_PUB_ADD_COMP_ELE;
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48:
49: -- Initialize the PL/SQL message stack

Line 87: pa_debug.reset_err_stack;

83: x_msg_count := pa_competence_pvt.g_noof_errors;
84: ELSE
85: x_msg_count := pa_competence_pvt.g_noof_errors;
86: END IF;
87: pa_debug.reset_err_stack;
88: RETURN;
89: END IF;
90:
91: IF p_object_name = 'PROJECT_ROLE' THEN

Line 137: pa_debug.reset_err_stack;

133: ELSE
134: x_msg_count := pa_competence_pvt.g_noof_errors;
135: END IF;
136:
137: pa_debug.reset_err_stack;
138: RETURN;
139: ELSE
140: x_return_status:= FND_API.G_RET_STS_SUCCESS;
141: END IF;

Line 156: p_procedure_name => pa_debug.g_err_stack );

152: END IF;
153:
154: fnd_msg_pub.add_exc_msg
155: (p_pkg_name => 'PA_COMPETENCE_PUB',
156: p_procedure_name => pa_debug.g_err_stack );
157:
158: x_msg_count := 1;
159:
160: IF x_msg_count = 1 THEN

Line 213: pa_debug.init_err_stack ('pa_competence_pub.update_competence_element');

209: l_mandatory_flag VARCHAR2(1);
210: l_err VARCHAR2(2000);
211: l_element_id NUMBER := null;
212: BEGIN
213: pa_debug.init_err_stack ('pa_competence_pub.update_competence_element');
214: SAVEPOINT COMPETENCE_PUB_UPD_COMP_ELE;
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216: -- Initialize the PL/SQL message stack
217: pa_competence_pvt.g_noof_errors := 0;

Line 258: pa_debug.reset_err_stack;

254: x_msg_count := pa_competence_pvt.g_noof_errors;
255: ELSE
256: x_msg_count := pa_competence_pvt.g_noof_errors;
257: END IF;
258: pa_debug.reset_err_stack;
259: RETURN;
260: END IF;
261:
262: pa_competence_pvt.update_competence_element

Line 294: pa_debug.reset_err_stack;

290: x_msg_count := pa_competence_pvt.g_noof_errors;
291: ELSE
292: x_msg_count := pa_competence_pvt.g_noof_errors;
293: END IF;
294: pa_debug.reset_err_stack;
295: RETURN;
296: ELSE
297: x_return_status:= FND_API.G_RET_STS_SUCCESS;
298: END IF;

Line 303: pa_debug.reset_err_stack;

299:
300: IF p_commit = FND_API.G_TRUE THEN
301: COMMIT;
302: END IF;
303: pa_debug.reset_err_stack;
304:
305: EXCEPTION
306: WHEN OTHERS THEN
307:

Line 316: p_procedure_name => pa_debug.g_err_stack );

312: END IF;
313:
314: fnd_msg_pub.add_exc_msg
315: (p_pkg_name => 'PA_COMPETENCE_PUB',
316: p_procedure_name => pa_debug.g_err_stack );
317:
318: x_msg_count := 1;
319:
320: IF x_msg_count = 1 THEN

Line 363: pa_debug.init_err_stack ('pa_competence_pub.delete_competence_element');

359: l_error_message_code VARCHAR2(30);
360: l_competence_id NUMBER := 0;
361: l_rating_level_id NUMBER := 0;
362: BEGIN
363: pa_debug.init_err_stack ('pa_competence_pub.delete_competence_element');
364: SAVEPOINT COMPETENCE_PUB_DEL_COMP_ELE;
365: x_return_status := FND_API.G_RET_STS_SUCCESS;
366: -- Initialize the PL/SQL message stack
367: pa_competence_pvt.g_noof_errors := 0;

Line 399: pa_debug.reset_err_stack;

395: x_msg_count := pa_competence_pvt.g_noof_errors;
396: ELSE
397: x_msg_count := pa_competence_pvt.g_noof_errors;
398: END IF;
399: pa_debug.reset_err_stack;
400: RETURN;
401: END IF;
402: -- Call the pvt delete competence element api now
403: pa_competence_pvt.delete_competence_element

Line 431: pa_debug.reset_err_stack;

427: x_msg_count := pa_competence_pvt.g_noof_errors;
428: ELSE
429: x_msg_count := pa_competence_pvt.g_noof_errors;
430: END IF;
431: pa_debug.reset_err_stack;
432: RETURN;
433: ELSE
434: x_return_status:= FND_API.G_RET_STS_SUCCESS;
435: END IF;

Line 440: pa_debug.reset_err_stack;

436:
437: IF p_commit = FND_API.G_TRUE THEN
438: COMMIT;
439: END IF;
440: pa_debug.reset_err_stack;
441:
442: EXCEPTION
443: WHEN OTHERS THEN
444:

Line 451: p_procedure_name => pa_debug.g_err_stack );

447: END IF;
448:
449: fnd_msg_pub.add_exc_msg
450: (p_pkg_name => 'PA_COMPETENCE_PUB',
451: p_procedure_name => pa_debug.g_err_stack );
452:
453: x_msg_count := 1;
454:
455: IF x_msg_count = 1 THEN

Line 500: pa_debug.init_err_stack ('pa_competence_pub.standard_pub_checks');

496: l_old_comp_name VARCHAR2(240);
497: l_old_comp_alias VARCHAR2(30);
498: l_exists VARCHAR2(1);
499: BEGIN
500: pa_debug.init_err_stack ('pa_competence_pub.standard_pub_checks');
501: x_return_status:= FND_API.G_RET_STS_SUCCESS;
502: -- Check whether the object name is one of the supported names
503: IF (p_object_name = FND_API.G_MISS_CHAR) OR
504: (p_object_name IS NULL) OR

Line 585: pa_debug.reset_err_stack;

581: END IF;
582:
583: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
584: x_return_status:= FND_API.G_RET_STS_ERROR;
585: pa_debug.reset_err_stack;
586: RETURN;
587: END IF;
588:
589: pa_hr_competence_utils.Check_CompName_Or_Id

Line 607: pa_debug.reset_err_stack;

603: -- All further validations require a competency id to be present
604:
605: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
606: x_return_status:= FND_API.G_RET_STS_ERROR;
607: pa_debug.reset_err_stack;
608: RETURN;
609: END IF;
610:
611: x_competence_id := l_competence_id;

Line 620: pa_debug.reset_err_stack;

616: -- these values will not be passed , hence do not validate if both the
617: -- values are not passed
618: IF (l_in_rating_level_id IS NULL AND l_in_rating_level_value
619: IS NULL ) THEN
620: pa_debug.reset_err_stack;
621: RETURN;
622: END IF;
623:
624: pa_hr_competence_utils.Check_Rating_Level_Or_Id

Line 640: pa_debug.reset_err_stack;

636: x_return_status:= FND_API.G_RET_STS_ERROR;
637: ELSE
638: x_return_status:= FND_API.G_RET_STS_SUCCESS;
639: END IF;
640: pa_debug.reset_err_stack;
641: x_rating_level_id := l_rating_level_id;
642: EXCEPTION
643: WHEN OTHERS THEN
644: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;