APPS.PA_COMP_PROFILE_PVT dependencies on PA_COMP_PROFILE_PVT

Line 1: PACKAGE BODY PA_COMP_PROFILE_PVT AS

1: PACKAGE BODY PA_COMP_PROFILE_PVT AS
2: -- $Header: PARPRFVB.pls 120.5 2005/11/20 20:29:10 sunkalya ship $
3:
4: g_profile_id NUMBER := 0;
5: g_person_id NUMBER := 0;

Line 74: pa_debug.set_err_stack ('PA_COMP_PROFILE_PVT.add_competence_element');

70: WHERE competence_id = p_competence_id;
71:
72: BEGIN
73: IF l_enable_log = 'Y' THEN
74: pa_debug.set_err_stack ('PA_COMP_PROFILE_PVT.add_competence_element');
75: END IF;
76:
77: SAVEPOINT COMPETENCE_PVT_ADD_COMP_ELE;
78:

Line 196: pa_debug.set_err_stack ('PA_COMP_PROFILE_PVT.update_competence_element');

192: BEGIN
193: -- dbms_output.put_line('Entering Update_competence_element');
194: -- dbms_output.put_line('Effective Date From ' || p_effective_date_from);
195: IF l_enable_log = 'Y' THEN
196: pa_debug.set_err_stack ('PA_COMP_PROFILE_PVT.update_competence_element');
197: END IF;
198: SAVEPOINT COMPETENCE_PVT_UPD_COMP_ELE;
199:
200: -- Initialize the message stack if necessary

Line 323: (p_pkg_name => 'PA_COMP_PROFILE_PVT',

319: EXCEPTION
320: WHEN OTHERS THEN
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: fnd_msg_pub.add_exc_msg
323: (p_pkg_name => 'PA_COMP_PROFILE_PVT',
324: p_procedure_name => 'delete_competence_element');
325: -- RAISE is not included as the caller of this API doesnt RAISE
326:
327: END delete_competence_element;

Line 350: pa_debug.set_err_stack ('PA_COMP_PROFILE_PVT.check_element_id');

346: WHERE competence_element_id = p_element_id;
347: l_check_element_rec l_check_element_csr%ROWTYPE;
348: BEGIN
349: IF l_enable_log = 'Y' THEN
350: pa_debug.set_err_stack ('PA_COMP_PROFILE_PVT.check_element_id');
351: END IF;
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353: OPEN l_check_element_csr;
354: FETCH l_check_element_csr INTO l_check_element_rec;

Line 388: pa_debug.set_err_stack ('PA_COMP_PROFILE_PVT.check_error');

384: p_error_message_code IN VARCHAR2) IS
385: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
386: BEGIN
387: IF l_enable_log = 'Y' THEN
388: pa_debug.set_err_stack ('PA_COMP_PROFILE_PVT.check_error');
389: END IF;
390: IF p_return_status = FND_API.G_RET_STS_ERROR THEN
391: g_noof_errors := g_noof_errors + 1;
392: pa_utils.add_message (p_app_short_name => 'PA',

Line 419: pa_debug.set_err_stack ('PA_COMP_PROFILE_PVT.check_object_version_number');

415: l_obj_version_number NUMBER := 0;
416:
417: BEGIN
418: IF l_enable_log = 'Y' THEN
419: pa_debug.set_err_stack ('PA_COMP_PROFILE_PVT.check_object_version_number');
420: END IF;
421: OPEN l_get_obj_vers_csr;
422: FETCH l_get_obj_vers_csr INTO l_obj_version_number;
423: -- dbms_output.put_line (' l obj is '||l_obj_version_number ||

Line 807: pa_debug.write('PA_COMP_PROFILE_PVT.Start_Approval_Process',SUBSTRB( SQLERRM,1,1900),3); -- 4537865 Replaced substr with substrb

803: x_msg_count := 1 ;
804: -- 4537865 : End
805:
806: -- Bug 2697431 - Added debug to write proper error message
807: pa_debug.write('PA_COMP_PROFILE_PVT.Start_Approval_Process',SUBSTRB( SQLERRM,1,1900),3); -- 4537865 Replaced substr with substrb
808: x_msg_data:=SUBSTRB( SQLERRM,1,1900); -- 4537865 Replaced substr with substrb
809:
810: IF g_profile_id > 0 THEN
811: BEGIN

Line 1022: ( p_pkg_name => 'PA_COMP_PROFILE_PVT'

1018: x_msg_count := 1;
1019: x_msg_data := SQLERRM;
1020:
1021: Fnd_Msg_Pub.add_exc_msg
1022: ( p_pkg_name => 'PA_COMP_PROFILE_PVT'
1023: , p_procedure_name => 'Validate_Competency'
1024: , p_error_text => x_msg_data);
1025: -- End : 4537865
1026:

Line 1068: (p_pkg_name => 'PA_COMP_PROFILE_PVT',

1064: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1065: x_error_message_code := SQLERRM;
1066:
1067: fnd_msg_pub.add_exc_msg
1068: (p_pkg_name => 'PA_COMP_PROFILE_PVT',
1069: p_procedure_name => 'Validate_Competency',
1070: p_error_text => SUBSTRB(SQLERRM,1,240));
1071:
1072: RAISE ; -- Included RAISE because Caller of this API needs RAISE

Line 1317: end PA_COMP_PROFILE_PVT ;

1313: WHEN OTHERS THEN
1314: null;
1315: END Clear_Temp_Table;
1316:
1317: end PA_COMP_PROFILE_PVT ;