APPS.PA_COMPETENCE_PUB dependencies on PA_COMPETENCE_PUB

Line 1: PACKAGE BODY pa_competence_pub AS

1: PACKAGE BODY pa_competence_pub AS
2: -- $Header: PACOMPPB.pls 120.4 2005/08/23 04:31:18 sunkalya noship $
3:
4: --
5: -- PROCEDURE

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 155: (p_pkg_name => 'PA_COMPETENCE_PUB',

151: ROLLBACK TO COMPETENCE_PUB_ADD_COMP_ELE;
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:

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 315: (p_pkg_name => 'PA_COMPETENCE_PUB',

311: ROLLBACK TO COMPETENCE_PUB_UPD_COMP_ELE;
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:

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 450: (p_pkg_name => 'PA_COMPETENCE_PUB',

446: ROLLBACK TO COMPETENCE_PUB_DEL_COMP_ELE;
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:

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 650: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_COMPETENCE_PUB',

646: -- RESET the other OUT PARAMS also : 4537865
647: x_competence_id := NULL ;
648: x_rating_level_id := NULL ;
649:
650: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_COMPETENCE_PUB',
651: p_procedure_name => 'standard_pub_checks',
652: P_ERROR_TEXT => SUBSTRB(SQLERRM,1,240));
653: -- 4537865 : End
654: RAISE;

Line 791: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'PA_COMPETENCE_PUB',

787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
788: x_msg_count := 1;
789: x_msg_data := SUBSTRB(SQLERRM,1,240);
790:
791: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'PA_COMPETENCE_PUB',
792: p_procedure_name => 'Mass_Exec_Process_Competences',
793: p_error_text => x_msg_data);
794: RAISE ;
795:

Line 985: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'PA_COMPETENCE_PUB',

981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
982: x_msg_data := SUBSTRB(SQLERRM ,1,240);
983: x_msg_count := 1;
984:
985: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'PA_COMPETENCE_PUB',
986: p_procedure_name => 'Mass_Process_Competences',
987: p_error_text => x_msg_data);
988: -- ENd : 4537865
989: RAISE;

Line 991: end pa_competence_pub ;

987: p_error_text => x_msg_data);
988: -- ENd : 4537865
989: RAISE;
990: END;
991: end pa_competence_pub ;