eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJ_STRUCTURE_PUB dependencies on PA_DEBUG

Line 29: pa_debug.init_err_stack('PA_PROJ_STRUCTURE_PUB.CREATE_RELATIONSHIP');

25: IS
26: l_task_id NUMBER;
27: l_project_id NUMBER;
28: Begin
29: pa_debug.init_err_stack('PA_PROJ_STRUCTURE_PUB.CREATE_RELATIONSHIP');
30: IF (p_commit= FND_API.G_TRUE) THEN
31: SAVEPOINT CREATE_TASK_PROJ_REL;
32: END IF;
33: l_task_id := p_task_id;

Line 50: p_procedure_name => PA_DEBUG.G_Err_Stack

46: ROLLBACK TO CREATE_TASK_PROJ_REL;
47: END IF;
48: FND_MSG_PUB.add_exc_msg(
49: p_pkg_name => 'CREATE_RELATIONSHIP',
50: p_procedure_name => PA_DEBUG.G_Err_Stack
51: );
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
53: RAISE;
54: END CREATE_RELATIONSHIP;

Line 65: pa_debug.init_err_stack('PA_PROJ_STRUCTURE_PUB.CHECK_SUBPROJ_CONTRACT_ASSO');

61: )
62: return VARCHAR2
63: IS
64: BEGIN
65: pa_debug.init_err_stack('PA_PROJ_STRUCTURE_PUB.CHECK_SUBPROJ_CONTRACT_ASSO');
66:
67: return PA_PROJ_STRUCTURE_UTILS.CHECK_PROJECT_CONTRACT_EXISTS(p_project_id);
68: EXCEPTION
69: WHEN OTHERS THEN

Line 72: p_procedure_name => PA_DEBUG.G_Err_Stack

68: EXCEPTION
69: WHEN OTHERS THEN
70: FND_MSG_PUB.add_exc_msg(
71: p_pkg_name => 'CHECK_SUBPROJ_CONTRACT_ASSO',
72: p_procedure_name => PA_DEBUG.G_Err_Stack
73: );
74: RAISE;
75: END CHECK_SUBPROJ_CONTRACT_ASSO;
76:

Line 86: pa_debug.init_err_stack('PA_PROJ_STRUCTURE_PUB.CHECK_TASK_CONTRACT_ASSO');

82: )
83: return VARCHAR2
84: IS
85: Begin
86: pa_debug.init_err_stack('PA_PROJ_STRUCTURE_PUB.CHECK_TASK_CONTRACT_ASSO');
87:
88: return PA_PROJ_STRUCTURE_UTILS.CHECK_TASK_CONTRACT_EXISTS(p_task_id);
89: EXCEPTION
90: WHEN OTHERS THEN

Line 93: p_procedure_name => PA_DEBUG.G_Err_Stack

89: EXCEPTION
90: WHEN OTHERS THEN
91: FND_MSG_PUB.add_exc_msg(
92: p_pkg_name => 'CHECK_TASK_CONTRACT_ASSO',
93: p_procedure_name => PA_DEBUG.G_Err_Stack
94: );
95: RAISE;
96: END CHECK_TASK_CONTRACT_ASSO;
97:

Line 118: pa_debug.init_err_stack('PA_PROJ_STRUCTURE_PUB.DELETE_RELATIONSHIP');

114: l_project_id NUMBER;
115: l_task_id NUMBER;
116:
117: BEGIN
118: pa_debug.init_err_stack('PA_PROJ_STRUCTURE_PUB.DELETE_RELATIONSHIP');
119: IF (p_commit= FND_API.G_TRUE) THEN
120: SAVEPOINT DELETE_TASK_PROJ_REL;
121: END IF;
122:

Line 139: p_procedure_name => PA_DEBUG.G_Err_Stack

135: ROLLBACK TO DELETE_TASK_PROJ_REL;
136: END IF;
137: FND_MSG_PUB.add_exc_msg(
138: p_pkg_name => 'DELETE_RELATIONSHIP',
139: p_procedure_name => PA_DEBUG.G_Err_Stack
140: );
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: RAISE;
143: END DELETE_RELATIONSHIP;

Line 211: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');

207:
208: -- Bug # 4875311.
209:
210: BEGIN
211: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
212:
213: IF g1_debug_mode = 'Y' THEN
214: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'ENTERED', x_Log_Level=> 3);
215: END IF;

Line 214: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'ENTERED', x_Log_Level=> 3);

210: BEGIN
211: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
212:
213: IF g1_debug_mode = 'Y' THEN
214: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'ENTERED', x_Log_Level=> 3);
215: END IF;
216:
217: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 228: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);

224: END IF;
225:
226:
227: IF g1_debug_mode = 'Y' THEN
228: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);
229: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_structure_version_id: '||p_structure_version_id, x_Log_Level=> 3);
230: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_calling_page_name: '||p_calling_page_name, x_Log_Level=> 3);
231: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_parent_project_id: '||p_parent_project_id, x_Log_Level=> 3);
232: --bug 4448499

Line 229: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_structure_version_id: '||p_structure_version_id, x_Log_Level=> 3);

225:
226:
227: IF g1_debug_mode = 'Y' THEN
228: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);
229: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_structure_version_id: '||p_structure_version_id, x_Log_Level=> 3);
230: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_calling_page_name: '||p_calling_page_name, x_Log_Level=> 3);
231: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_parent_project_id: '||p_parent_project_id, x_Log_Level=> 3);
232: --bug 4448499
233: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_sequence_offset: '||p_sequence_offset, x_Log_Level=> 3);

Line 230: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_calling_page_name: '||p_calling_page_name, x_Log_Level=> 3);

226:
227: IF g1_debug_mode = 'Y' THEN
228: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);
229: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_structure_version_id: '||p_structure_version_id, x_Log_Level=> 3);
230: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_calling_page_name: '||p_calling_page_name, x_Log_Level=> 3);
231: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_parent_project_id: '||p_parent_project_id, x_Log_Level=> 3);
232: --bug 4448499
233: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_sequence_offset: '||p_sequence_offset, x_Log_Level=> 3);
234: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_populate_tmp_tab_flag: '||p_populate_tmp_tab_flag, x_Log_Level=> 3);

Line 231: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_parent_project_id: '||p_parent_project_id, x_Log_Level=> 3);

227: IF g1_debug_mode = 'Y' THEN
228: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);
229: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_structure_version_id: '||p_structure_version_id, x_Log_Level=> 3);
230: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_calling_page_name: '||p_calling_page_name, x_Log_Level=> 3);
231: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_parent_project_id: '||p_parent_project_id, x_Log_Level=> 3);
232: --bug 4448499
233: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_sequence_offset: '||p_sequence_offset, x_Log_Level=> 3);
234: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_populate_tmp_tab_flag: '||p_populate_tmp_tab_flag, x_Log_Level=> 3);
235: --bug 4448499

Line 233: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_sequence_offset: '||p_sequence_offset, x_Log_Level=> 3);

229: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_structure_version_id: '||p_structure_version_id, x_Log_Level=> 3);
230: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_calling_page_name: '||p_calling_page_name, x_Log_Level=> 3);
231: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_parent_project_id: '||p_parent_project_id, x_Log_Level=> 3);
232: --bug 4448499
233: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_sequence_offset: '||p_sequence_offset, x_Log_Level=> 3);
234: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_populate_tmp_tab_flag: '||p_populate_tmp_tab_flag, x_Log_Level=> 3);
235: --bug 4448499
236: END IF;
237:

Line 234: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_populate_tmp_tab_flag: '||p_populate_tmp_tab_flag, x_Log_Level=> 3);

230: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_calling_page_name: '||p_calling_page_name, x_Log_Level=> 3);
231: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_parent_project_id: '||p_parent_project_id, x_Log_Level=> 3);
232: --bug 4448499
233: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_sequence_offset: '||p_sequence_offset, x_Log_Level=> 3);
234: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'p_populate_tmp_tab_flag: '||p_populate_tmp_tab_flag, x_Log_Level=> 3);
235: --bug 4448499
236: END IF;
237:
238: --bug 4197654

Line 274: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'l_program_flag='||l_program_flag, x_Log_Level=> 3);

270:
271: -- Bug # 4875311.
272:
273: IF g1_debug_mode = 'Y' THEN
274: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'l_program_flag='||l_program_flag, x_Log_Level=> 3);
275: END IF;
276:
277: IF l_parent_project_id = p_project_id
278: THEN

Line 342: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After deleting from temp table', x_Log_Level=> 3);

338: END IF;
339: CLOSE check_pub_str;
340:
341: IF g1_debug_mode = 'Y' THEN
342: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After deleting from temp table', x_Log_Level=> 3);
343: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'l_pub_structure_flag='||l_pub_structure_flag, x_Log_Level=> 3);
344: END IF;
345:
346:

Line 343: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'l_pub_structure_flag='||l_pub_structure_flag, x_Log_Level=> 3);

339: CLOSE check_pub_str;
340:
341: IF g1_debug_mode = 'Y' THEN
342: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After deleting from temp table', x_Log_Level=> 3);
343: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'l_pub_structure_flag='||l_pub_structure_flag, x_Log_Level=> 3);
344: END IF;
345:
346:
347: IF l_pub_structure_flag = 'Y'

Line 355: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'Calling PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORD', x_Log_Level=> 3);

351: AND p_task_version_id IS NOT NULL
352: AND p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
353: THEN
354: IF g1_debug_mode = 'Y' THEN
355: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'Calling PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORD', x_Log_Level=> 3);
356: END IF;
357:
358: PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORD(
359: p_api_version => p_api_version,

Line 374: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After calling PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORD l_return_status='||l_return_status, x_Log_Level=> 3);

370: x_msg_data => x_msg_data)
371: ;
372:
373: IF g1_debug_mode = 'Y' THEN
374: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After calling PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORD l_return_status='||l_return_status, x_Log_Level=> 3);
375: END IF;
376:
377: ELSIF p_calling_page_name = 'WP_UPD_TASKS' THEN
378:

Line 380: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'Before calling PA_PROJ_STRUCTURE_PUB.INSERT_UPD_PUBLISHED_RECORDS', x_Log_Level=> 3);

376:
377: ELSIF p_calling_page_name = 'WP_UPD_TASKS' THEN
378:
379: IF g1_debug_mode = 'Y' THEN
380: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'Before calling PA_PROJ_STRUCTURE_PUB.INSERT_UPD_PUBLISHED_RECORDS', x_Log_Level=> 3);
381: END IF;
382:
383: PA_PROJ_STRUCTURE_PUB.INSERT_UPD_PUBLISHED_RECORDS(
384: p_api_version => p_api_version,

Line 400: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After calling PA_PROJ_STRUCTURE_PUB.INSERT_UPD_PUBLISHED_RECORDS l_return_status='||l_return_status, x_Log_Level=> 3);

396: x_msg_data => x_msg_data)
397: ;
398:
399: IF g1_debug_mode = 'Y' THEN
400: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After calling PA_PROJ_STRUCTURE_PUB.INSERT_UPD_PUBLISHED_RECORDS l_return_status='||l_return_status, x_Log_Level=> 3);
401: END IF;
402:
403: ELSE
404:

Line 406: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'Calling PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORDS', x_Log_Level=> 3);

402:
403: ELSE
404:
405: IF g1_debug_mode = 'Y' THEN
406: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'Calling PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORDS', x_Log_Level=> 3);
407: END IF;
408:
409: PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORDS(
410: p_api_version => p_api_version,

Line 427: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After calling PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORDS l_return_status='||l_return_status, x_Log_Level=> 3);

423: x_msg_data => x_msg_data)
424: ;
425:
426: IF g1_debug_mode = 'Y' THEN
427: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After calling PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORDS l_return_status='||l_return_status, x_Log_Level=> 3);
428: END IF;
429:
430:
431: END IF; --p_calling_page_name = 'TASK_DETAILS'

Line 447: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'Before calling PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORD', x_Log_Level=> 3);

443: AND p_task_version_id IS NOT NULL
444: AND p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
445: THEN
446: IF g1_debug_mode = 'Y' THEN
447: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'Before calling PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORD', x_Log_Level=> 3);
448: END IF;
449:
450: PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORD(
451: p_api_version => p_api_version,

Line 466: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After calling PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORD l_return_status='||l_return_status, x_Log_Level=> 3);

462: x_msg_data => x_msg_data)
463: ;
464:
465: IF g1_debug_mode = 'Y' THEN
466: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After calling PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORD l_return_status='||l_return_status, x_Log_Level=> 3);
467: END IF;
468:
469: ELSIF p_calling_page_name = 'WP_UPD_TASKS' THEN
470:

Line 472: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'Before calling PA_PROJ_STRUCTURE_PUB.INSERT_UPD_WORKING_RECORDS', x_Log_Level=> 3);

468:
469: ELSIF p_calling_page_name = 'WP_UPD_TASKS' THEN
470:
471: IF g1_debug_mode = 'Y' THEN
472: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'Before calling PA_PROJ_STRUCTURE_PUB.INSERT_UPD_WORKING_RECORDS', x_Log_Level=> 3);
473: END IF;
474:
475: PA_PROJ_STRUCTURE_PUB.INSERT_UPD_WORKING_RECORDS(
476: p_api_version => p_api_version,

Line 492: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After calling PA_PROJ_STRUCTURE_PUB.INSERT_UPD_WORKING_RECORDS l_return_status='||l_return_status, x_Log_Level=> 3);

488: x_msg_data => x_msg_data)
489: ;
490:
491: IF g1_debug_mode = 'Y' THEN
492: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After calling PA_PROJ_STRUCTURE_PUB.INSERT_UPD_WORKING_RECORDS l_return_status='||l_return_status, x_Log_Level=> 3);
493: END IF;
494:
495: ELSE
496:

Line 498: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'Before calling PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORDS', x_Log_Level=> 3);

494:
495: ELSE
496:
497: IF g1_debug_mode = 'Y' THEN
498: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'Before calling PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORDS', x_Log_Level=> 3);
499: END IF;
500:
501: PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORDS(
502: p_api_version => p_api_version,

Line 519: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After calling PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORDS l_return_status='||l_return_status, x_Log_Level=> 3);

515: x_msg_data => x_msg_data)
516: ;
517:
518: IF g1_debug_mode = 'Y' THEN
519: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After calling PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORDS l_return_status='||l_return_status, x_Log_Level=> 3);
520: END IF;
521:
522:
523: END IF; --- p_calling_page_name = 'TASK_DETAILS'

Line 544: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'l_program_flag='||l_program_flag, x_Log_Level=> 3);

540: END IF;
541: CLOSE check_prog_flag;
542:
543: IF g1_debug_mode = 'Y' THEN
544: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'l_program_flag='||l_program_flag, x_Log_Level=> 3);
545: END IF;
546: */
547:
548: IF l_program_flag = 'Y'

Line 552: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'Before calling PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Log_Level=> 3);

548: IF l_program_flag = 'Y'
549: THEN
550:
551: IF g1_debug_mode = 'Y' THEN
552: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'Before calling PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Log_Level=> 3);
553: END IF;
554:
555: PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS(
556: p_api_version => p_api_version,

Line 572: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After calling PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS l_return_status='||l_return_status, x_Log_Level=> 3);

568: x_msg_data => x_msg_data)
569: ;
570:
571: IF g1_debug_mode = 'Y' THEN
572: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'After calling PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS l_return_status='||l_return_status, x_Log_Level=> 3);
573: END IF;
574:
575: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 709: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');

705:
706: -- End of Bug Fix 5609629
707:
708: BEGIN
709: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
710:
711: IF g1_debug_mode = 'Y' THEN
712: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORDS', x_Msg => 'ENTERED', x_Log_Level=> 3);
713: END IF;

Line 712: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORDS', x_Msg => 'ENTERED', x_Log_Level=> 3);

708: BEGIN
709: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
710:
711: IF g1_debug_mode = 'Y' THEN
712: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORDS', x_Msg => 'ENTERED', x_Log_Level=> 3);
713: END IF;
714:
715: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 726: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORDS', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);

722: END IF;
723:
724:
725: IF g1_debug_mode = 'Y' THEN
726: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORDS', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);
727: END IF;
728:
729: x_return_status := FND_API.G_RET_STS_SUCCESS;
730:

Line 3388: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');

3384: -- End of Bug Fix 5609629
3385:
3386:
3387: BEGIN
3388: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
3389:
3390: IF g1_debug_mode = 'Y' THEN
3391: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORDS', x_Msg => 'ENTERED', x_Log_Level=> 3);
3392: END IF;

Line 3391: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORDS', x_Msg => 'ENTERED', x_Log_Level=> 3);

3387: BEGIN
3388: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
3389:
3390: IF g1_debug_mode = 'Y' THEN
3391: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORDS', x_Msg => 'ENTERED', x_Log_Level=> 3);
3392: END IF;
3393:
3394: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
3395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3405: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORDS', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);

3401: END IF;
3402:
3403:
3404: IF g1_debug_mode = 'Y' THEN
3405: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORDS', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);
3406: END IF;
3407:
3408: x_return_status := FND_API.G_RET_STS_SUCCESS;
3409:

Line 6027: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');

6023:
6024: -- End of Bug Fix 5609629
6025:
6026: BEGIN
6027: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
6028:
6029: IF g1_debug_mode = 'Y' THEN
6030: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'ENTERED', x_Log_Level=> 3);
6031: END IF;

Line 6030: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'ENTERED', x_Log_Level=> 3);

6026: BEGIN
6027: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
6028:
6029: IF g1_debug_mode = 'Y' THEN
6030: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'ENTERED', x_Log_Level=> 3);
6031: END IF;
6032:
6033: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
6034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6044: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);

6040: END IF;
6041:
6042:
6043: IF g1_debug_mode = 'Y' THEN
6044: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);
6045: END IF;
6046:
6047: x_return_status := FND_API.G_RET_STS_SUCCESS;
6048:

Line 7342: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'global_sequence_number: '||global_sequence_number, x_Log_Level=> 3);

7338: ;
7339: END IF;
7340:
7341: IF g1_debug_mode = 'Y' THEN
7342: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'global_sequence_number: '||global_sequence_number, x_Log_Level=> 3);
7343: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_sub_proj_str_disp_seq: '||l_sub_proj_str_disp_seq, x_Log_Level=> 3);
7344: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before global_sub_proj_task_count: '||global_sub_proj_task_count, x_Log_Level=> 3);
7345: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before calling Populate_structures_tmp_tab recursively:', x_Log_Level=> 3);
7346: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);

Line 7343: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_sub_proj_str_disp_seq: '||l_sub_proj_str_disp_seq, x_Log_Level=> 3);

7339: END IF;
7340:
7341: IF g1_debug_mode = 'Y' THEN
7342: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'global_sequence_number: '||global_sequence_number, x_Log_Level=> 3);
7343: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_sub_proj_str_disp_seq: '||l_sub_proj_str_disp_seq, x_Log_Level=> 3);
7344: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before global_sub_proj_task_count: '||global_sub_proj_task_count, x_Log_Level=> 3);
7345: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before calling Populate_structures_tmp_tab recursively:', x_Log_Level=> 3);
7346: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);
7347: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'p_parent_project_id='||p_parent_project_id, x_Log_Level=> 3);

Line 7344: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before global_sub_proj_task_count: '||global_sub_proj_task_count, x_Log_Level=> 3);

7340:
7341: IF g1_debug_mode = 'Y' THEN
7342: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'global_sequence_number: '||global_sequence_number, x_Log_Level=> 3);
7343: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_sub_proj_str_disp_seq: '||l_sub_proj_str_disp_seq, x_Log_Level=> 3);
7344: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before global_sub_proj_task_count: '||global_sub_proj_task_count, x_Log_Level=> 3);
7345: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before calling Populate_structures_tmp_tab recursively:', x_Log_Level=> 3);
7346: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);
7347: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'p_parent_project_id='||p_parent_project_id, x_Log_Level=> 3);
7348: END IF;

Line 7345: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before calling Populate_structures_tmp_tab recursively:', x_Log_Level=> 3);

7341: IF g1_debug_mode = 'Y' THEN
7342: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'global_sequence_number: '||global_sequence_number, x_Log_Level=> 3);
7343: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_sub_proj_str_disp_seq: '||l_sub_proj_str_disp_seq, x_Log_Level=> 3);
7344: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before global_sub_proj_task_count: '||global_sub_proj_task_count, x_Log_Level=> 3);
7345: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before calling Populate_structures_tmp_tab recursively:', x_Log_Level=> 3);
7346: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);
7347: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'p_parent_project_id='||p_parent_project_id, x_Log_Level=> 3);
7348: END IF;
7349: --bug 4448499

Line 7346: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);

7342: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'global_sequence_number: '||global_sequence_number, x_Log_Level=> 3);
7343: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_sub_proj_str_disp_seq: '||l_sub_proj_str_disp_seq, x_Log_Level=> 3);
7344: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before global_sub_proj_task_count: '||global_sub_proj_task_count, x_Log_Level=> 3);
7345: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before calling Populate_structures_tmp_tab recursively:', x_Log_Level=> 3);
7346: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);
7347: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'p_parent_project_id='||p_parent_project_id, x_Log_Level=> 3);
7348: END IF;
7349: --bug 4448499
7350:

Line 7347: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'p_parent_project_id='||p_parent_project_id, x_Log_Level=> 3);

7343: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_sub_proj_str_disp_seq: '||l_sub_proj_str_disp_seq, x_Log_Level=> 3);
7344: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before global_sub_proj_task_count: '||global_sub_proj_task_count, x_Log_Level=> 3);
7345: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before calling Populate_structures_tmp_tab recursively:', x_Log_Level=> 3);
7346: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);
7347: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'p_parent_project_id='||p_parent_project_id, x_Log_Level=> 3);
7348: END IF;
7349: --bug 4448499
7350:
7351: --insert tasks by calling populate_structures_tmp_tab

Line 7364: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'After calling Populate_structures_tmp_tab recursively for project:'||l_project_id, x_Log_Level=> 3);

7360: x_msg_data => l_msg_data);
7361:
7362: --bug 4448499
7363: IF g1_debug_mode = 'Y' THEN
7364: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'After calling Populate_structures_tmp_tab recursively for project:'||l_project_id, x_Log_Level=> 3);
7365: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'After global_sub_proj_task_count: '||global_sub_proj_task_count, x_Log_Level=> 3);
7366: END IF;
7367:
7368: /* IF p_calling_page_name = 'GANTT_REGION'

Line 7365: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'After global_sub_proj_task_count: '||global_sub_proj_task_count, x_Log_Level=> 3);

7361:
7362: --bug 4448499
7363: IF g1_debug_mode = 'Y' THEN
7364: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'After calling Populate_structures_tmp_tab recursively for project:'||l_project_id, x_Log_Level=> 3);
7365: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'After global_sub_proj_task_count: '||global_sub_proj_task_count, x_Log_Level=> 3);
7366: END IF;
7367:
7368: /* IF p_calling_page_name = 'GANTT_REGION'
7369: THEN

Line 7457: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');

7453:
7454: -- End of Bug Fix 5609629
7455:
7456: BEGIN
7457: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
7458:
7459: IF g1_debug_mode = 'Y' THEN
7460: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORD', x_Msg => 'ENTERED', x_Log_Level=> 3);
7461: END IF;

Line 7460: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORD', x_Msg => 'ENTERED', x_Log_Level=> 3);

7456: BEGIN
7457: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
7458:
7459: IF g1_debug_mode = 'Y' THEN
7460: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORD', x_Msg => 'ENTERED', x_Log_Level=> 3);
7461: END IF;
7462:
7463: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
7464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7474: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORD', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);

7470: END IF;
7471:
7472:
7473: IF g1_debug_mode = 'Y' THEN
7474: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORD', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);
7475: END IF;
7476:
7477: x_return_status := FND_API.G_RET_STS_SUCCESS;
7478:

Line 8217: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');

8213:
8214: -- End of Bug Fix 5609629
8215:
8216: BEGIN
8217: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
8218:
8219: IF g1_debug_mode = 'Y' THEN
8220: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORD', x_Msg => 'ENTERED', x_Log_Level=> 3);
8221: END IF;

Line 8220: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORD', x_Msg => 'ENTERED', x_Log_Level=> 3);

8216: BEGIN
8217: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
8218:
8219: IF g1_debug_mode = 'Y' THEN
8220: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORD', x_Msg => 'ENTERED', x_Log_Level=> 3);
8221: END IF;
8222:
8223: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
8224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8234: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORD', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);

8230: END IF;
8231:
8232:
8233: IF g1_debug_mode = 'Y' THEN
8234: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORD', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);
8235: END IF;
8236:
8237: x_return_status := FND_API.G_RET_STS_SUCCESS;
8238:

Line 8988: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');

8984: -- End of Fix for bug 5611634.
8985:
8986:
8987: BEGIN
8988: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
8989:
8990: IF g1_debug_mode = 'Y' THEN
8991: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_UPD_WORKING_RECORDS', x_Msg => 'ENTERED', x_Log_Level=> 3);
8992: END IF;

Line 8991: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_UPD_WORKING_RECORDS', x_Msg => 'ENTERED', x_Log_Level=> 3);

8987: BEGIN
8988: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
8989:
8990: IF g1_debug_mode = 'Y' THEN
8991: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_UPD_WORKING_RECORDS', x_Msg => 'ENTERED', x_Log_Level=> 3);
8992: END IF;
8993:
8994: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
8995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9005: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_UPD_WORKING_RECORDS', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);

9001: END IF;
9002:
9003:
9004: IF g1_debug_mode = 'Y' THEN
9005: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_UPD_WORKING_RECORDS', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);
9006: END IF;
9007:
9008: x_return_status := FND_API.G_RET_STS_SUCCESS;
9009:

Line 11602: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');

11598: -- End of Fix for bug 5611634.
11599:
11600:
11601: BEGIN
11602: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
11603:
11604: IF g1_debug_mode = 'Y' THEN
11605: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_UPD_PUBLISHED_RECORDS', x_Msg => 'ENTERED', x_Log_Level=> 3);
11606: END IF;

Line 11605: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_UPD_PUBLISHED_RECORDS', x_Msg => 'ENTERED', x_Log_Level=> 3);

11601: BEGIN
11602: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
11603:
11604: IF g1_debug_mode = 'Y' THEN
11605: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_UPD_PUBLISHED_RECORDS', x_Msg => 'ENTERED', x_Log_Level=> 3);
11606: END IF;
11607:
11608: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
11609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 11619: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_UPD_PUBLISHED_RECORDS', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);

11615: END IF;
11616:
11617:
11618: IF g1_debug_mode = 'Y' THEN
11619: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_UPD_PUBLISHED_RECORDS', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);
11620: END IF;
11621:
11622: x_return_status := FND_API.G_RET_STS_SUCCESS;
11623: