APPS.PA_HR_COMPETENCE_UTILS dependencies on PA_DEBUG

Line 35: pa_debug.init_err_stack ('pa_competence_utils.check_rating_level_or_id');

31: FROM per_competence_levels_v
32: WHERE competence_id = p_competence_id
33: AND step_value = p_rating_level;
34: BEGIN
35: pa_debug.init_err_stack ('pa_competence_utils.check_rating_level_or_id');
36: IF (p_rating_level_id is not null) THEN
37: IF (p_check_id_flag = 'Y') THEN
38: SELECT rating_level_id
39: INTO x_rating_level_id

Line 88: pa_debug.reset_err_stack;

84: x_rating_level_id := NULL;
85: END IF;
86: END IF;
87: x_return_status:= FND_API.G_RET_STS_SUCCESS;
88: pa_debug.reset_err_stack;
89: EXCEPTION
90: WHEN no_data_found THEN
91: x_rating_level_id := NULL;
92: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 102: p_procedure_name => pa_debug.g_err_stack );

98: WHEN OTHERS THEN
99: x_rating_level_id := NULL;
100: fnd_msg_pub.add_exc_msg
101: (p_pkg_name => 'PA_COMPETENCE_UTILS',
102: p_procedure_name => pa_debug.g_err_stack );
103: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
104: RAISE;
105: END Check_Rating_Level_Or_Id;
106:

Line 125: pa_debug.init_err_stack ('pa_competence_utils.check_compName_or_id');

121: SELECT competence_id
122: FROM per_competences
123: WHERE name = p_competence_name;
124: BEGIN
125: pa_debug.init_err_stack ('pa_competence_utils.check_compName_or_id');
126: IF p_competence_id IS NOT NULL THEN
127: IF (p_check_id_flag = 'Y') THEN
128: SELECT competence_id
129: INTO x_competence_id

Line 181: pa_debug.reset_err_stack;

177: x_competence_id := NULL;
178: END IF;
179: END IF;
180: x_return_status:= FND_API.G_RET_STS_SUCCESS;
181: pa_debug.reset_err_stack;
182: EXCEPTION
183: WHEN no_data_found THEN
184: x_competence_id := NULL;
185: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 195: p_procedure_name => pa_debug.g_err_stack );

191: WHEN OTHERS THEN
192: x_competence_id := NULL;
193: fnd_msg_pub.add_exc_msg
194: (p_pkg_name => 'PA_COMPETENCE_UTILS',
195: p_procedure_name => pa_debug.g_err_stack );
196: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
197: RAISE;
198: END Check_CompName_Or_Id ;
199:

Line 287: pa_debug.init_err_stack ('pa_competence_utils.get_competencies');

283: l_competence_exists VARCHAR2(1);
284: l_comp_csr_rec l_comp_csr%ROWTYPE;
285: l_competency_tbl competency_tbl_typ;
286: BEGIN
287: pa_debug.init_err_stack ('pa_competence_utils.get_competencies');
288: x_return_status:= FND_API.G_RET_STS_SUCCESS;
289: IF p_object_name IN ('OPEN_ASSIGNMENT','PROJECT_ROLE') THEN
290: OPEN l_comp_csr; LOOP
291: FETCH l_comp_csr INTO l_comp_csr_rec;

Line 347: pa_debug.reset_err_stack;

343: CLOSE l_job_comp_csr;
344: x_competency_tbl := l_competency_tbl;
345: END IF; -- End if p_object_name = 'JOB'
346: x_no_of_competencies := l_index;
347: pa_debug.reset_err_stack;
348: EXCEPTION
349: WHEN OTHERS THEN
350: fnd_msg_pub.add_exc_msg
351: (p_pkg_name => 'PA_COMPETENCE_UTILS',

Line 352: p_procedure_name => pa_debug.g_err_stack );

348: EXCEPTION
349: WHEN OTHERS THEN
350: fnd_msg_pub.add_exc_msg
351: (p_pkg_name => 'PA_COMPETENCE_UTILS',
352: p_procedure_name => pa_debug.g_err_stack );
353: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
354: END get_competencies;
355:
356: -- Get Person Competencies : This procedure returns the competencies

Line 389: pa_debug.init_err_stack ('pa_competence_utils.get_person_competencies');

385: l_comp_csr_rec l_comp_csr%ROWTYPE;
386: l_competency_tbl competency_tbl_typ;
387: BEGIN
388:
389: pa_debug.init_err_stack ('pa_competence_utils.get_person_competencies');
390:
391: x_return_status:= FND_API.G_RET_STS_SUCCESS;
392:
393: OPEN l_comp_csr;

Line 421: pa_debug.reset_err_stack;

417: CLOSE l_comp_csr;
418:
419: x_no_of_competencies := l_index;
420:
421: pa_debug.reset_err_stack;
422:
423: EXCEPTION
424: WHEN OTHERS THEN
425: fnd_msg_pub.add_exc_msg

Line 427: p_procedure_name => pa_debug.g_err_stack );

423: EXCEPTION
424: WHEN OTHERS THEN
425: fnd_msg_pub.add_exc_msg
426: (p_pkg_name => 'PA_COMPETENCE_UTILS',
427: p_procedure_name => pa_debug.g_err_stack );
428: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
429: END get_person_competencies;
430:
431: FUNCTION check_competence_exists