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.30.12010000.3 2008/10/07 05:50:07 jsundara 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.30.12010000.3 2008/10/07 05:50:07 jsundara 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 3326: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

3322: x_msg_count := 1;
3323: x_msg_data := SQLERRM;
3324:
3325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3326: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
3327: p_procedure_name => 'INSERT_PUBLISHED_RECORDS',
3328: p_error_text => SUBSTRB(SQLERRM,1,240));
3329: when OTHERS then
3330: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

3330: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3331: x_msg_count := 1;
3332: x_msg_data := SUBSTRB(SQLERRM,1,240);
3333:
3334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
3335: p_procedure_name => 'INSERT_PUBLISHED_RECORDS',
3336: p_error_text => SUBSTRB(SQLERRM,1,240));
3337: raise;
3338: END INSERT_PUBLISHED_RECORDS;

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

5928: x_msg_count := 1;
5929: x_msg_data := SQLERRM;
5930:
5931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5932: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
5933: p_procedure_name => 'INSERT_WORKING_RECORDS',
5934: p_error_text => SUBSTRB(SQLERRM,1,240));
5935: when OTHERS then
5936: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

5936: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5937: x_msg_count := 1;
5938: x_msg_data := SUBSTRB(SQLERRM,1,240);
5939:
5940: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
5941: p_procedure_name => 'INSERT_WORKING_RECORDS',
5942: p_error_text => SUBSTRB(SQLERRM,1,240));
5943: raise;
5944: END INSERT_WORKING_RECORDS;

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

7394: x_msg_count := 1;
7395: x_msg_data := SQLERRM;
7396:
7397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7398: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
7399: p_procedure_name => 'INSERT_SUBPROJECTS',
7400: p_error_text => SUBSTRB(SQLERRM,1,240));
7401: when OTHERS then
7402: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

7402: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7403: x_msg_count := 1;
7404: x_msg_data := SUBSTRB(SQLERRM,1,240);
7405:
7406: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
7407: p_procedure_name => 'INSERT_SUBPROJECTS',
7408: p_error_text => SUBSTRB(SQLERRM,1,240));
7409: raise;
7410: END INSERT_SUBPROJECTS;

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

8158: x_msg_count := 1;
8159: x_msg_data := SQLERRM;
8160:
8161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8162: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
8163: p_procedure_name => 'INSERT_PUBLISHED_RECORD',
8164: p_error_text => SUBSTRB(SQLERRM,1,240));
8165: when OTHERS then
8166: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

8166: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
8167: x_msg_count := 1;
8168: x_msg_data := SUBSTRB(SQLERRM,1,240);
8169:
8170: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
8171: p_procedure_name => 'INSERT_PUBLISHED_RECORD',
8172: p_error_text => SUBSTRB(SQLERRM,1,240));
8173: raise;
8174: END INSERT_PUBLISHED_RECORD;

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

8917: x_msg_count := 1;
8918: x_msg_data := SQLERRM;
8919:
8920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8921: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
8922: p_procedure_name => 'INSERT_WORKING_RECORD',
8923: p_error_text => SUBSTRB(SQLERRM,1,240));
8924: when OTHERS then
8925: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

8925: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
8926: x_msg_count := 1;
8927: x_msg_data := SUBSTRB(SQLERRM,1,240);
8928:
8929: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
8930: p_procedure_name => 'INSERT_WORKING_RECORD',
8931: p_error_text => SUBSTRB(SQLERRM,1,240));
8932: raise;
8933: END INSERT_WORKING_RECORD;

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

11531: x_msg_count := 1;
11532: x_msg_data := SQLERRM;
11533:
11534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11535: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
11536: p_procedure_name => 'INSERT_UPD_WORKING_RECORDS',
11537: p_error_text => SUBSTRB(SQLERRM,1,240));
11538: when OTHERS then
11539: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

11539: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
11540: x_msg_count := 1;
11541: x_msg_data := SUBSTRB(SQLERRM,1,240);
11542:
11543: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
11544: p_procedure_name => 'INSERT_UPD_WORKING_RECORDS',
11545: p_error_text => SUBSTRB(SQLERRM,1,240));
11546: raise;
11547: END INSERT_UPD_WORKING_RECORDS;

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:

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

14052: x_msg_count := 1;
14053: x_msg_data := SQLERRM;
14054:
14055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14056: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
14057: p_procedure_name => 'INSERT_UPD_PUBLISHED_RECORDS',
14058: p_error_text => SUBSTRB(SQLERRM,1,240));
14059: when OTHERS then
14060: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

14060: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
14061: x_msg_count := 1;
14062: x_msg_data := SUBSTRB(SQLERRM,1,240);
14063:
14064: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
14065: p_procedure_name => 'INSERT_UPD_PUBLISHED_RECORDS',
14066: p_error_text => SUBSTRB(SQLERRM,1,240));
14067: raise;
14068: END INSERT_UPD_PUBLISHED_RECORDS;

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

14159: x_return_status => l_return_status,
14160: x_msg_code => l_msg_data);
14161: EXCEPTION
14162: WHEN OTHERS THEN
14163: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
14164: p_procedure_name => 'POPULATE_PJI_TAB_FOR_PLAN_PRJ',
14165: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_UTILS.populate_updatewbs_data Failed. SQLERRM='||SQLERRM,1,120));
14166: RAISE FND_API.G_EXC_ERROR;
14167: END;

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

14184: if p_commit = FND_API.G_TRUE then
14185: rollback to plan_qtys;
14186: end if;
14187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14188: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
14189: p_procedure_name => 'populate_pji_tab_for_plan_prj',
14190: p_error_text => SUBSTRB(SQLERRM,1,120));
14191: when OTHERS then
14192: if p_commit = FND_API.G_TRUE then

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

14192: if p_commit = FND_API.G_TRUE then
14193: rollback to plan_qtys;
14194: end if;
14195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14196: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
14197: p_procedure_name => 'populate_pji_tab_for_plan_prj',
14198: p_error_text => SUBSTRB(SQLERRM,1,120));
14199: raise;
14200: end populate_pji_tab_for_plan_prj;

Line 14204: end PA_PROJ_STRUCTURE_PUB;

14200: end populate_pji_tab_for_plan_prj;
14201:
14202: -- Bug # 4875311.
14203:
14204: end PA_PROJ_STRUCTURE_PUB;
14205: