APPS.PA_PROJECT_SETS_PVT dependencies on FND_PROFILE

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

34: l_return_status VARCHAR2(1);
35: l_unique VARCHAR2(1);
36: l_msg_count NUMBER;
37: l_msg_data VARCHAR2(240);
38: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
39:
40: BEGIN
41:
42: -- Initialize the return status to success

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

178: l_return_status VARCHAR2(1);
179: l_unique VARCHAR2(1);
180: l_msg_count NUMBER;
181: l_msg_data VARCHAR2(240);
182: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
183:
184: BEGIN
185:
186: -- Initialize the return status to success

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

285: IS
286: l_return_status VARCHAR2(1);
287: l_do_lines_exist VARCHAR2(1);
288: l_project_set_lines_tbl pa_project_set_utils.project_set_lines_tbl_type;
289: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
290:
291: BEGIN
292:
293: -- Initialize the return status to success

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

355: l_exists VARCHAR2(1);
356: l_project_set_id PA_PROJECT_SETS_B.project_set_id%TYPE;
357: e_row_is_locked EXCEPTION;
358: PRAGMA EXCEPTION_INIT(e_row_is_locked, -54);
359: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
360:
361: BEGIN
362:
363: -- Initialize the return status to success

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

411: )
412: IS
413: l_return_status VARCHAR2(1);
414: l_exists VARCHAR2(1);
415: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
416: BEGIN
417:
418: -- Initialize the return status to success
419: x_return_status := FND_API.G_RET_STS_SUCCESS;