APPS.PA_PROJECT_SET_UTILS dependencies on PA_DEBUG

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

14: )
15: IS
16: l_employee_id fnd_user.employee_id%type;
17: l_customer_id fnd_user.person_party_id%type; -- 4586987 changed from customer_id to person_party_id
18: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
19: BEGIN
20: -- 4586987 changed customer_id to person_party_id
21: /*
22: SELECT employee_id, customer_id

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

256: l_proj_set_name pa_project_sets_tl.name%TYPE;
257: l_project_list VARCHAR2(2000) := '';
258: l_project_name pa_projects_all.name%TYPE;
259: l_project_number pa_projects_all.segment1%TYPE;
260: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
261:
262: CURSOR get_proj_name_number(l_project_id IN NUMBER)
263: IS
264: SELECT name, segment1

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

335: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
336: x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
337: IS
338:
339: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
340:
341: BEGIN
342:
343: -- Initialize the Error Stack

Line 345: PA_DEBUG.init_err_stack('PA_PROJECT_SET_UTILS.Check_PartyName_Or_Id');

341: BEGIN
342:
343: -- Initialize the Error Stack
344: IF l_enable_log = 'Y' THEN
345: PA_DEBUG.init_err_stack('PA_PROJECT_SET_UTILS.Check_PartyName_Or_Id');
346: END IF;
347:
348: -- Initialize the return status to success
349: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 379: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

375: x_error_msg_code := 'PA_MULTIPLE_PARTY';
376: WHEN OTHERS THEN
377: -- Set the exception Message and the stack
378: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECT_SET_UTILS.Check_PartyName_Or_Id'
379: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
381: RAISE;
382: END Check_PartyName_Or_Id;
383:

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

392: IS
393: l_current_id NUMBER := NULL;
394: l_num_ids NUMBER := 0;
395: l_id_found_flag VARCHAR(1) := 'N';
396: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
397:
398: CURSOR p_ids IS
399: SELECT project_set_id
400: FROM pa_project_sets_vl