APPS.PA_COMP_PROFILE_PUB dependencies on FND_PROFILE

Line 54: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

50: l_project_id NUMBER := 0;
51: l_role_id NUMBER := 0;
52: l_effective_date_from DATE;
53: l_file_val VARCHAR2(100);
54: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
55:
56: BEGIN
57:
58: IF l_enable_log = 'Y' THEN

Line 227: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

223: l_mandatory_flag VARCHAR2(1);
224: l_err VARCHAR2(2000);
225: l_effective_date_from DATE;
226: l_file_val VARCHAR2(100);
227: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
228: BEGIN
229:
230: -- dbms_output.put_line('Person ID : ' || p_person_id);
231: -- dbms_output.put_line('Entering PUB Update_competence_element');

Line 388: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

384: l_data VARCHAR2(500);
385: l_msg_data VARCHAR2(500);
386: l_msg_count NUMBER;
387: l_msg_index_out NUMBER := 0;
388: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
389: BEGIN
390: PA_COMP_PROFILE_PVT.delete_competence_element
391: ( p_person_id => p_person_id,
392: p_competence_id => p_competence_id,

Line 475: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

471: l_old_competence_id NUMBER;
472: l_old_comp_name VARCHAR2(240);
473: l_old_comp_alias VARCHAR2(30);
474: l_exists VARCHAR2(1);
475: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
476: BEGIN
477:
478: IF l_enable_log = 'Y' THEN
479: pa_debug.init_err_stack ('PA_COMP_PROFILE_PUB.standard_pub_checks');

Line 736: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

732: IS
733: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
734: l_msg_count NUMBER;
735: l_msg_data VARCHAR2(2000);
736: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
737: BEGIN
738: --
739: -- RUN mode - normal process execution
740: --

Line 779: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

775: IS
776: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
777: l_msg_count NUMBER;
778: l_msg_data VARCHAR2(2000);
779: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
780: BEGIN
781: --
782: -- RUN mode - normal process execution
783: --