APPS.PA_COMPETENCE_PVT dependencies on PA_COMPETENCE_PVT

Line 1: PACKAGE BODY pa_competence_pvt AS

1: PACKAGE BODY pa_competence_pvt AS
2: -- $Header: PACOMPVB.pls 120.1 2005/08/19 16:20:26 mwasowic noship $
3:
4: --
5: -- PROCEDURE

Line 52: pa_debug.set_err_stack ('pa_competence_pvt.add_competence_element');

48: FROM per_competence_elements
49: WHERE competence_element_id = l_element_id;
50:
51: BEGIN
52: pa_debug.set_err_stack ('pa_competence_pvt.add_competence_element');
53: SAVEPOINT COMPETENCE_PVT_ADD_COMP_ELE;
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55:
56: -- Initialize the message stack if necessary

Line 270: pa_debug.set_err_stack ('pa_competence_pvt.update_competence_element');

266: l_error_message_code VARCHAR2(30);
267: l_mandatory_flag VARCHAR2(1);
268:
269: BEGIN
270: pa_debug.set_err_stack ('pa_competence_pvt.update_competence_element');
271: SAVEPOINT COMPETENCE_PVT_UPD_COMP_ELE;
272: -- Initialize the message stack if necessary
273: IF p_init_msg_list = FND_API.G_TRUE THEN
274: fnd_msg_pub.initialize;

Line 377: pa_debug.set_err_stack ('pa_competence_pvt.delete_competence_element');

373: l_object_version_number NUMBER ;
374: l_error_message_code VARCHAR2(30);
375:
376: BEGIN
377: pa_debug.set_err_stack ('pa_competence_pvt.delete_competence_element');
378: SAVEPOINT COMPETENCE_PVT_DEL_COMP_ELE;
379: -- Initialize the message stack if necessary
380: IF p_init_msg_list = FND_API.G_TRUE THEN
381: fnd_msg_pub.initialize;

Line 465: pa_debug.set_err_stack ('pa_competence_pvt.check_element_id');

461: FROM per_competence_elements
462: WHERE competence_element_id = p_element_id;
463: l_check_element_rec l_check_element_csr%ROWTYPE;
464: BEGIN
465: pa_debug.set_err_stack ('pa_competence_pvt.check_element_id');
466: x_return_status := FND_API.G_RET_STS_SUCCESS;
467: OPEN l_check_element_csr;
468: FETCH l_check_element_csr INTO l_check_element_rec;
469: IF l_check_element_csr%NOTFOUND

Line 492: pa_debug.set_err_stack ('pa_competence_pvt.check_error');

488:
489: PROCEDURE Check_Error (p_return_status IN VARCHAR2,
490: p_error_message_code IN VARCHAR2) IS
491: BEGIN
492: pa_debug.set_err_stack ('pa_competence_pvt.check_error');
493: IF p_return_status = FND_API.G_RET_STS_ERROR THEN
494: g_noof_errors := g_noof_errors + 1;
495: pa_utils.add_message (p_app_short_name => 'PA',
496: p_msg_name => p_error_message_code);

Line 517: pa_debug.set_err_stack ('pa_competence_pvt.check_object_version_number');

513: WHERE competence_element_id = p_element_id;
514: l_obj_version_number NUMBER := 0;
515:
516: BEGIN
517: pa_debug.set_err_stack ('pa_competence_pvt.check_object_version_number');
518: OPEN l_get_obj_vers_csr;
519: FETCH l_get_obj_vers_csr INTO l_obj_version_number;
520: IF l_obj_version_number <> p_object_version_number THEN
521: x_return_status := FND_API.G_RET_STS_ERROR;

Line 533: end pa_competence_pvt ;

529: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
530: RAISE;
531: END Check_Object_Version_Number ;
532:
533: end pa_competence_pvt ;