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_PROJ_STRUCTURE_PUB

Line 1: package body PA_PROJ_STRUCTURE_PUB as

1: package body PA_PROJ_STRUCTURE_PUB as
2: /* $Header: PAXSTRPB.pls 120.42 2011/12/22 20:28:24 pstawar ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJ_STRUCTURE_PUB';
5: -- Added for Bug# 6156686

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJ_STRUCTURE_PUB';

1: package body PA_PROJ_STRUCTURE_PUB as
2: /* $Header: PAXSTRPB.pls 120.42 2011/12/22 20:28:24 pstawar ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJ_STRUCTURE_PUB';
5: -- Added for Bug# 6156686
6: l_d_lines_exist_flag VARCHAR2(1);
7: l_issue_lines_exist_flag VARCHAR2(1);
8: l_cr_lines_exist_flag VARCHAR2(1);

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 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 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 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 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 358: PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORD(

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,
360: p_init_msg_list => p_init_msg_list,
361: p_commit => p_commit,
362: p_validate_only => p_validate_only,

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 383: PA_PROJ_STRUCTURE_PUB.INSERT_UPD_PUBLISHED_RECORDS(

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,
385: p_init_msg_list => p_init_msg_list,
386: p_commit => p_commit,
387: p_validate_only => p_validate_only,

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 409: PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORDS(

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,
411: p_init_msg_list => p_init_msg_list,
412: p_commit => p_commit,
413: p_validate_only => p_validate_only,

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 450: PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORD(

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,
452: p_init_msg_list => p_init_msg_list,
453: p_commit => p_commit,
454: p_validate_only => p_validate_only,

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 475: PA_PROJ_STRUCTURE_PUB.INSERT_UPD_WORKING_RECORDS(

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,
477: p_init_msg_list => p_init_msg_list,
478: p_commit => p_commit,
479: p_validate_only => p_validate_only,

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 501: PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORDS(

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,
503: p_init_msg_list => p_init_msg_list,
504: p_commit => p_commit,
505: p_validate_only => p_validate_only,

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 555: PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS(

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,
557: p_init_msg_list => p_init_msg_list,
558: p_commit => p_commit,
559: p_validate_only => p_validate_only,

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 589: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

585: x_msg_count := 1;
586: x_msg_data := SQLERRM;
587:
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
590: p_procedure_name => 'POPULATE_STRUCTURES_TMP_TAB',
591: p_error_text => SUBSTRB(SQLERRM,1,240));
592: when OTHERS then
593: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 597: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

593: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
594: x_msg_count := 1;
595: x_msg_data := SUBSTRB(SQLERRM,1,240);
596:
597: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
598: p_procedure_name => 'POPULATE_STRUCTURES_TMP_TAB',
599: p_error_text => SUBSTRB(SQLERRM,1,240));
600: raise;
601:

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 5137: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

5133: x_msg_count := 1;
5134: x_msg_data := SQLERRM;
5135:
5136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5137: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
5138: p_procedure_name => 'INSERT_PUBLISHED_RECORDS',
5139: p_error_text => SUBSTRB(SQLERRM,1,240));
5140: when OTHERS then
5141: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 5145: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

5141: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5142: x_msg_count := 1;
5143: x_msg_data := SUBSTRB(SQLERRM,1,240);
5144:
5145: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
5146: p_procedure_name => 'INSERT_PUBLISHED_RECORDS',
5147: p_error_text => SUBSTRB(SQLERRM,1,240));
5148: raise;
5149: END INSERT_PUBLISHED_RECORDS;

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

5198: BEGIN
5199: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
5200:
5201: IF g1_debug_mode = 'Y' THEN
5202: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORDS', x_Msg => 'ENTERED', x_Log_Level=> 3);
5203: END IF;
5204:
5205: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5212: END IF;
5213:
5214:
5215: IF g1_debug_mode = 'Y' THEN
5216: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORDS', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);
5217: END IF;
5218:
5219: x_return_status := FND_API.G_RET_STS_SUCCESS;
5220:

Line 7746: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

7742: x_msg_count := 1;
7743: x_msg_data := SQLERRM;
7744:
7745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7746: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
7747: p_procedure_name => 'INSERT_WORKING_RECORDS',
7748: p_error_text => SUBSTRB(SQLERRM,1,240));
7749: when OTHERS then
7750: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 7754: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

7750: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7751: x_msg_count := 1;
7752: x_msg_data := SUBSTRB(SQLERRM,1,240);
7753:
7754: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
7755: p_procedure_name => 'INSERT_WORKING_RECORDS',
7756: p_error_text => SUBSTRB(SQLERRM,1,240));
7757: raise;
7758: END INSERT_WORKING_RECORDS;

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

7840: BEGIN
7841: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
7842:
7843: IF g1_debug_mode = 'Y' THEN
7844: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'ENTERED', x_Log_Level=> 3);
7845: END IF;
7846:
7847: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
7848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7854: END IF;
7855:
7856:
7857: IF g1_debug_mode = 'Y' THEN
7858: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);
7859: END IF;
7860:
7861: x_return_status := FND_API.G_RET_STS_SUCCESS;
7862:

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

9668: ;
9669: END IF;
9670:
9671: IF g1_debug_mode = 'Y' THEN
9672: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'global_sequence_number: '||global_sequence_number, x_Log_Level=> 3);
9673: 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);
9674: 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);
9675: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before calling Populate_structures_tmp_tab recursively:', x_Log_Level=> 3);
9676: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);

Line 9673: 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);

9669: END IF;
9670:
9671: IF g1_debug_mode = 'Y' THEN
9672: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'global_sequence_number: '||global_sequence_number, x_Log_Level=> 3);
9673: 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);
9674: 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);
9675: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before calling Populate_structures_tmp_tab recursively:', x_Log_Level=> 3);
9676: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);
9677: 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 9674: 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);

9670:
9671: IF g1_debug_mode = 'Y' THEN
9672: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'global_sequence_number: '||global_sequence_number, x_Log_Level=> 3);
9673: 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);
9674: 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);
9675: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before calling Populate_structures_tmp_tab recursively:', x_Log_Level=> 3);
9676: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);
9677: 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);
9678: END IF;

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

9671: IF g1_debug_mode = 'Y' THEN
9672: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'global_sequence_number: '||global_sequence_number, x_Log_Level=> 3);
9673: 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);
9674: 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);
9675: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before calling Populate_structures_tmp_tab recursively:', x_Log_Level=> 3);
9676: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);
9677: 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);
9678: END IF;
9679: --bug 4448499

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

9672: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'global_sequence_number: '||global_sequence_number, x_Log_Level=> 3);
9673: 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);
9674: 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);
9675: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before calling Populate_structures_tmp_tab recursively:', x_Log_Level=> 3);
9676: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);
9677: 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);
9678: END IF;
9679: --bug 4448499
9680:

Line 9677: 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);

9673: 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);
9674: 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);
9675: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'Before calling Populate_structures_tmp_tab recursively:', x_Log_Level=> 3);
9676: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_SUBPROJECTS', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);
9677: 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);
9678: END IF;
9679: --bug 4448499
9680:
9681: --insert tasks by calling populate_structures_tmp_tab

Line 9694: 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);

9690: x_msg_data => l_msg_data);
9691:
9692: --bug 4448499
9693: IF g1_debug_mode = 'Y' THEN
9694: 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);
9695: 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);
9696: END IF;
9697:
9698: /* IF p_calling_page_name = 'GANTT_REGION'

Line 9695: 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);

9691:
9692: --bug 4448499
9693: IF g1_debug_mode = 'Y' THEN
9694: 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);
9695: 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);
9696: END IF;
9697:
9698: /* IF p_calling_page_name = 'GANTT_REGION'
9699: THEN

Line 9728: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

9724: x_msg_count := 1;
9725: x_msg_data := SQLERRM;
9726:
9727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9728: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
9729: p_procedure_name => 'INSERT_SUBPROJECTS',
9730: p_error_text => SUBSTRB(SQLERRM,1,240));
9731: when OTHERS then
9732: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 9736: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

9732: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
9733: x_msg_count := 1;
9734: x_msg_data := SUBSTRB(SQLERRM,1,240);
9735:
9736: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
9737: p_procedure_name => 'INSERT_SUBPROJECTS',
9738: p_error_text => SUBSTRB(SQLERRM,1,240));
9739: raise;
9740: END INSERT_SUBPROJECTS;

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

9786: BEGIN
9787: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
9788:
9789: IF g1_debug_mode = 'Y' THEN
9790: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORD', x_Msg => 'ENTERED', x_Log_Level=> 3);
9791: END IF;
9792:
9793: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
9794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

9800: END IF;
9801:
9802:
9803: IF g1_debug_mode = 'Y' THEN
9804: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORD', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);
9805: END IF;
9806:
9807: x_return_status := FND_API.G_RET_STS_SUCCESS;
9808:

Line 10492: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

10488: x_msg_count := 1;
10489: x_msg_data := SQLERRM;
10490:
10491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10492: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
10493: p_procedure_name => 'INSERT_PUBLISHED_RECORD',
10494: p_error_text => SUBSTRB(SQLERRM,1,240));
10495: when OTHERS then
10496: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 10500: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

10496: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
10497: x_msg_count := 1;
10498: x_msg_data := SUBSTRB(SQLERRM,1,240);
10499:
10500: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
10501: p_procedure_name => 'INSERT_PUBLISHED_RECORD',
10502: p_error_text => SUBSTRB(SQLERRM,1,240));
10503: raise;
10504: END INSERT_PUBLISHED_RECORD;

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

10546: BEGIN
10547: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
10548:
10549: IF g1_debug_mode = 'Y' THEN
10550: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORD', x_Msg => 'ENTERED', x_Log_Level=> 3);
10551: END IF;
10552:
10553: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
10554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

10560: END IF;
10561:
10562:
10563: IF g1_debug_mode = 'Y' THEN
10564: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORD', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);
10565: END IF;
10566:
10567: x_return_status := FND_API.G_RET_STS_SUCCESS;
10568:

Line 11251: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

11247: x_msg_count := 1;
11248: x_msg_data := SQLERRM;
11249:
11250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11251: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
11252: p_procedure_name => 'INSERT_WORKING_RECORD',
11253: p_error_text => SUBSTRB(SQLERRM,1,240));
11254: when OTHERS then
11255: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 11259: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

11255: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
11256: x_msg_count := 1;
11257: x_msg_data := SUBSTRB(SQLERRM,1,240);
11258:
11259: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
11260: p_procedure_name => 'INSERT_WORKING_RECORD',
11261: p_error_text => SUBSTRB(SQLERRM,1,240));
11262: raise;
11263: END INSERT_WORKING_RECORD;

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

11317: BEGIN
11318: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
11319:
11320: IF g1_debug_mode = 'Y' THEN
11321: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_UPD_WORKING_RECORDS', x_Msg => 'ENTERED', x_Log_Level=> 3);
11322: END IF;
11323:
11324: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
11325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 11335: 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);

11331: END IF;
11332:
11333:
11334: IF g1_debug_mode = 'Y' THEN
11335: 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);
11336: END IF;
11337:
11338: x_return_status := FND_API.G_RET_STS_SUCCESS;
11339:

Line 13868: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

13864: x_msg_count := 1;
13865: x_msg_data := SQLERRM;
13866:
13867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13868: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
13869: p_procedure_name => 'INSERT_UPD_WORKING_RECORDS',
13870: p_error_text => SUBSTRB(SQLERRM,1,240));
13871: when OTHERS then
13872: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 13876: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

13872: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
13873: x_msg_count := 1;
13874: x_msg_data := SUBSTRB(SQLERRM,1,240);
13875:
13876: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
13877: p_procedure_name => 'INSERT_UPD_WORKING_RECORDS',
13878: p_error_text => SUBSTRB(SQLERRM,1,240));
13879: raise;
13880: END INSERT_UPD_WORKING_RECORDS;

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

13934: BEGIN
13935: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id,l_login_id,275,null,null), 'N');
13936:
13937: IF g1_debug_mode = 'Y' THEN
13938: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.INSERT_UPD_PUBLISHED_RECORDS', x_Msg => 'ENTERED', x_Log_Level=> 3);
13939: END IF;
13940:
13941: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
13942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 13952: 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);

13948: END IF;
13949:
13950:
13951: IF g1_debug_mode = 'Y' THEN
13952: 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);
13953: END IF;
13954:
13955: x_return_status := FND_API.G_RET_STS_SUCCESS;
13956:

Line 16392: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

16388: x_msg_count := 1;
16389: x_msg_data := SQLERRM;
16390:
16391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16392: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
16393: p_procedure_name => 'INSERT_UPD_PUBLISHED_RECORDS',
16394: p_error_text => SUBSTRB(SQLERRM,1,240));
16395: when OTHERS then
16396: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 16400: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

16396: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
16397: x_msg_count := 1;
16398: x_msg_data := SUBSTRB(SQLERRM,1,240);
16399:
16400: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
16401: p_procedure_name => 'INSERT_UPD_PUBLISHED_RECORDS',
16402: p_error_text => SUBSTRB(SQLERRM,1,240));
16403: raise;
16404: END INSERT_UPD_PUBLISHED_RECORDS;

Line 16499: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

16495: x_return_status => l_return_status,
16496: x_msg_code => l_msg_data);
16497: EXCEPTION
16498: WHEN OTHERS THEN
16499: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
16500: p_procedure_name => 'POPULATE_PJI_TAB_FOR_PLAN_PRJ',
16501: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_UTILS.populate_updatewbs_data Failed. SQLERRM='||SQLERRM,1,120));
16502: RAISE FND_API.G_EXC_ERROR;
16503: END;

Line 16524: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

16520: if p_commit = FND_API.G_TRUE then
16521: rollback to plan_qtys;
16522: end if;
16523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16524: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
16525: p_procedure_name => 'populate_pji_tab_for_plan_prj',
16526: p_error_text => SUBSTRB(SQLERRM,1,120));
16527: when OTHERS then
16528: if p_commit = FND_API.G_TRUE then

Line 16532: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

16528: if p_commit = FND_API.G_TRUE then
16529: rollback to plan_qtys;
16530: end if;
16531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16532: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
16533: p_procedure_name => 'populate_pji_tab_for_plan_prj',
16534: p_error_text => SUBSTRB(SQLERRM,1,120));
16535: raise;
16536: end populate_pji_tab_for_plan_prj;

Line 16540: end PA_PROJ_STRUCTURE_PUB;

16536: end populate_pji_tab_for_plan_prj;
16537:
16538: -- Bug # 4875311.
16539:
16540: end PA_PROJ_STRUCTURE_PUB;
16541: