DBA Data[Home] [Help]

APPS.PA_HR_COMPETENCE_UTILS dependencies on FND_API

Line 87: x_return_status:= FND_API.G_RET_STS_SUCCESS;

83: ELSE
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;

Line 92: x_return_status:= FND_API.G_RET_STS_ERROR;

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;
93: x_error_msg_code:= 'PA_RATING_INVALID_AMBIGOUS';
94: WHEN too_many_rows THEN
95: x_rating_level_id := NULL;
96: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 96: x_return_status:= FND_API.G_RET_STS_ERROR;

92: x_return_status:= FND_API.G_RET_STS_ERROR;
93: x_error_msg_code:= 'PA_RATING_INVALID_AMBIGOUS';
94: WHEN too_many_rows THEN
95: x_rating_level_id := NULL;
96: x_return_status:= FND_API.G_RET_STS_ERROR;
97: x_error_msg_code:= 'PA_RATING_INVALID_AMBIGOUS';
98: WHEN OTHERS THEN
99: x_rating_level_id := NULL;
100: fnd_msg_pub.add_exc_msg

Line 103: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

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:
107: PROCEDURE Check_CompName_Or_Id

Line 180: x_return_status:= FND_API.G_RET_STS_SUCCESS;

176: ELSE
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;

Line 185: x_return_status:= FND_API.G_RET_STS_ERROR;

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;
186: x_error_msg_code:= 'PA_COMP_INVALID_AMBIGOUS';
187: WHEN too_many_rows THEN
188: x_competence_id := NULL;
189: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 189: x_return_status:= FND_API.G_RET_STS_ERROR;

185: x_return_status:= FND_API.G_RET_STS_ERROR;
186: x_error_msg_code:= 'PA_COMP_INVALID_AMBIGOUS';
187: WHEN too_many_rows THEN
188: x_competence_id := NULL;
189: x_return_status:= FND_API.G_RET_STS_ERROR;
190: x_error_msg_code:= 'PA_COMP_INVALID_AMBIGOUS';
191: WHEN OTHERS THEN
192: x_competence_id := NULL;
193: fnd_msg_pub.add_exc_msg

Line 196: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

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:
200: PROCEDURE Get_KFF_Structure_Num

Line 288: x_return_status:= FND_API.G_RET_STS_SUCCESS;

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;
292: EXIT WHEN l_comp_csr%NOTFOUND;

Line 353: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

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
357: -- defined for a person

Line 391: x_return_status:= FND_API.G_RET_STS_SUCCESS;

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;
394: LOOP
395:

Line 428: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

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
432: ( p_object_name IN per_competence_elements.object_name%TYPE