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 FND_API

Line 15: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

11:
12: procedure CREATE_RELATIONSHIP
13: (
14: p_api_version IN NUMBER := 1.0,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
18: p_debug_mode IN VARCHAR2 := 'N',
19: p_task_id IN NUMBER,

Line 16: p_commit IN VARCHAR2 := FND_API.G_FALSE,

12: procedure CREATE_RELATIONSHIP
13: (
14: p_api_version IN NUMBER := 1.0,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
18: p_debug_mode IN VARCHAR2 := 'N',
19: p_task_id IN NUMBER,
20: p_project_id IN NUMBER,

Line 17: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

13: (
14: p_api_version IN NUMBER := 1.0,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
18: p_debug_mode IN VARCHAR2 := 'N',
19: p_task_id IN NUMBER,
20: p_project_id IN NUMBER,
21: x_return_status OUT NOCOPY VARCHAR2,

Line 30: IF (p_commit= FND_API.G_TRUE) THEN

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;
34: l_project_id := p_project_id;

Line 45: IF (p_commit = FND_API.G_TRUE) THEN

41: x_msg_data => x_msg_data
42: );
43: EXCEPTION
44: When OTHERS Then
45: IF (p_commit = FND_API.G_TRUE) THEN
46: ROLLBACK TO CREATE_TASK_PROJ_REL;
47: END IF;
48: FND_MSG_PUB.add_exc_msg(
49: p_pkg_name => 'CREATE_RELATIONSHIP',

Line 52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
55:
56:

Line 103: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

99:
100: procedure DELETE_RELATIONSHIP
101: (
102: p_api_version IN NUMBER := 1.0,
103: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE,
105: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
106: p_debug_mode IN VARCHAR2 := 'N',
107: p_task_id IN NUMBER,

Line 104: p_commit IN VARCHAR2 := FND_API.G_FALSE,

100: procedure DELETE_RELATIONSHIP
101: (
102: p_api_version IN NUMBER := 1.0,
103: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE,
105: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
106: p_debug_mode IN VARCHAR2 := 'N',
107: p_task_id IN NUMBER,
108: p_project_id IN NUMBER,

Line 105: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

101: (
102: p_api_version IN NUMBER := 1.0,
103: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE,
105: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
106: p_debug_mode IN VARCHAR2 := 'N',
107: p_task_id IN NUMBER,
108: p_project_id IN NUMBER,
109: x_return_status OUT NOCOPY VARCHAR2,

Line 119: IF (p_commit= FND_API.G_TRUE) THEN

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:
123: l_project_id := p_project_id;

Line 134: IF (p_commit = FND_API.G_TRUE) THEN

130: x_msg_data=> x_msg_data);
131:
132: EXCEPTION
133: When OTHERS Then
134: IF (p_commit = FND_API.G_TRUE) THEN
135: ROLLBACK TO DELETE_TASK_PROJ_REL;
136: END IF;
137: FND_MSG_PUB.add_exc_msg(
138: p_pkg_name => 'DELETE_RELATIONSHIP',

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
144:
145: procedure POPULATE_STRUCTURES_TMP_TAB

Line 148: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

144:
145: procedure POPULATE_STRUCTURES_TMP_TAB
146: (
147: p_api_version IN NUMBER := 1.0,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
151: p_debug_mode IN VARCHAR2 := 'N',
152: p_project_id IN NUMBER,

Line 149: p_commit IN VARCHAR2 := FND_API.G_FALSE,

145: procedure POPULATE_STRUCTURES_TMP_TAB
146: (
147: p_api_version IN NUMBER := 1.0,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
151: p_debug_mode IN VARCHAR2 := 'N',
152: p_project_id IN NUMBER,
153: p_structure_version_id IN NUMBER,

Line 150: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

146: (
147: p_api_version IN NUMBER := 1.0,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
151: p_debug_mode IN VARCHAR2 := 'N',
152: p_project_id IN NUMBER,
153: p_structure_version_id IN NUMBER,
154: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 217: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

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;
219: END IF;
220:
221:

Line 218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
219: END IF;
220:
221:
222: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 222: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: END IF;
220:
221:
222: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
223: FND_MSG_PUB.initialize;
224: END IF;
225:
226:

Line 246: x_return_status := FND_API.G_RET_STS_SUCCESS;

242: l_parent_project_id := p_parent_project_id;
243: END IF;
244: --end bug 4197654
245:
246: x_return_status := FND_API.G_RET_STS_SUCCESS;
247:
248: --bug 4448499 moved this code here from below to have access to program flag.
249: IF p_calling_page_name NOT IN ('TASK_DETAILS','WP_UPD_TASKS')
250: -- <> 'TASK_DETAILS' --No need to get the program data for Task details page.

Line 433: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

429:
430:
431: END IF; --p_calling_page_name = 'TASK_DETAILS'
432:
433: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
435: END IF;
436:
437: END IF; -- l_pub_structure_flag = 'Y'

Line 434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

430:
431: END IF; --p_calling_page_name = 'TASK_DETAILS'
432:
433: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
435: END IF;
436:
437: END IF; -- l_pub_structure_flag = 'Y'
438:

Line 525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

521:
522:
523: END IF; --- p_calling_page_name = 'TASK_DETAILS'
524:
525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528:
529: END IF; -- l_pub_structure_flag = 'N'

Line 526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

522:
523: END IF; --- p_calling_page_name = 'TASK_DETAILS'
524:
525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528:
529: END IF; -- l_pub_structure_flag = 'N'
530:

Line 575: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;
577: END IF;
578: END IF; --l_program_flag = 'Y'
579: END IF; -- p_calling_page_name <> 'TASK_DETAILS'

Line 576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
577: END IF;
578: END IF; --l_program_flag = 'Y'
579: END IF; -- p_calling_page_name <> 'TASK_DETAILS'
580:

Line 583: when FND_API.G_EXC_UNEXPECTED_ERROR then

579: END IF; -- p_calling_page_name <> 'TASK_DETAILS'
580:
581: EXCEPTION
582:
583: when FND_API.G_EXC_UNEXPECTED_ERROR then
584: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
585: x_msg_count := 1;
586: x_msg_data := SQLERRM;
587:

Line 584: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

580:
581: EXCEPTION
582:
583: when FND_API.G_EXC_UNEXPECTED_ERROR then
584: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
585: x_msg_count := 1;
586: x_msg_data := SQLERRM;
587:
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

584: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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

Line 593: 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;
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',

Line 608: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

604:
605: procedure INSERT_PUBLISHED_RECORDS
606: (
607: p_api_version IN NUMBER := 1.0,
608: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
609: p_commit IN VARCHAR2 := FND_API.G_FALSE,
610: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
611: p_debug_mode IN VARCHAR2 := 'N',
612: p_project_id IN NUMBER,

Line 609: p_commit IN VARCHAR2 := FND_API.G_FALSE,

605: procedure INSERT_PUBLISHED_RECORDS
606: (
607: p_api_version IN NUMBER := 1.0,
608: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
609: p_commit IN VARCHAR2 := FND_API.G_FALSE,
610: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
611: p_debug_mode IN VARCHAR2 := 'N',
612: p_project_id IN NUMBER,
613: p_structure_version_id IN NUMBER,

Line 610: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

606: (
607: p_api_version IN NUMBER := 1.0,
608: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
609: p_commit IN VARCHAR2 := FND_API.G_FALSE,
610: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
611: p_debug_mode IN VARCHAR2 := 'N',
612: p_project_id IN NUMBER,
613: p_structure_version_id IN NUMBER,
614: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 715: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

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;
717: END IF;
718:
719:

Line 716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
717: END IF;
718:
719:
720: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 720: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718:
719:
720: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
721: FND_MSG_PUB.initialize;
722: END IF;
723:
724:

Line 729: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
731: /*4275236 : Some Perf Enhancements*/
732: l_yes := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','Y');
733: l_no := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','N');

Line 5131: when FND_API.G_EXC_UNEXPECTED_ERROR then

5127:
5128: END IF;
5129:
5130: EXCEPTION
5131: when FND_API.G_EXC_UNEXPECTED_ERROR then
5132: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5133: x_msg_count := 1;
5134: x_msg_data := SQLERRM;
5135:

Line 5132: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

5128: END IF;
5129:
5130: EXCEPTION
5131: when FND_API.G_EXC_UNEXPECTED_ERROR then
5132: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5133: x_msg_count := 1;
5134: x_msg_data := SQLERRM;
5135:
5136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5132: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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

Line 5141: 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;
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',

Line 5155: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

5151:
5152: procedure INSERT_WORKING_RECORDS
5153: (
5154: p_api_version IN NUMBER := 1.0,
5155: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
5156: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5157: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
5158: p_debug_mode IN VARCHAR2 := 'N',
5159: p_project_id IN NUMBER,

Line 5156: p_commit IN VARCHAR2 := FND_API.G_FALSE,

5152: procedure INSERT_WORKING_RECORDS
5153: (
5154: p_api_version IN NUMBER := 1.0,
5155: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
5156: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5157: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
5158: p_debug_mode IN VARCHAR2 := 'N',
5159: p_project_id IN NUMBER,
5160: p_structure_version_id IN NUMBER,

Line 5157: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

5153: (
5154: p_api_version IN NUMBER := 1.0,
5155: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
5156: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5157: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
5158: p_debug_mode IN VARCHAR2 := 'N',
5159: p_project_id IN NUMBER,
5160: p_structure_version_id IN NUMBER,
5161: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 5205: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

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;
5207: END IF;
5208:
5209:

Line 5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
5207: END IF;
5208:
5209:
5210: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 5210: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5207: END IF;
5208:
5209:
5210: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
5211: FND_MSG_PUB.initialize;
5212: END IF;
5213:
5214:

Line 5219: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
5221: /*4275236: Perf Enhancements*/
5222: l_yes := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','Y');
5223: l_no := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','N');

Line 7740: when FND_API.G_EXC_UNEXPECTED_ERROR then

7736:
7737: END IF;
7738:
7739: EXCEPTION
7740: when FND_API.G_EXC_UNEXPECTED_ERROR then
7741: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7742: x_msg_count := 1;
7743: x_msg_data := SQLERRM;
7744:

Line 7741: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

7737: END IF;
7738:
7739: EXCEPTION
7740: when FND_API.G_EXC_UNEXPECTED_ERROR then
7741: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7742: x_msg_count := 1;
7743: x_msg_data := SQLERRM;
7744:
7745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7741: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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

Line 7750: 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;
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',

Line 7764: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

7760:
7761: procedure INSERT_SUBPROJECTS
7762: (
7763: p_api_version IN NUMBER := 1.0,
7764: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
7765: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7766: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
7767: p_debug_mode IN VARCHAR2 := 'N',
7768: p_calling_page_name IN VARCHAR2,

Line 7765: p_commit IN VARCHAR2 := FND_API.G_FALSE,

7761: procedure INSERT_SUBPROJECTS
7762: (
7763: p_api_version IN NUMBER := 1.0,
7764: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
7765: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7766: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
7767: p_debug_mode IN VARCHAR2 := 'N',
7768: p_calling_page_name IN VARCHAR2,
7769: p_project_id IN NUMBER,

Line 7766: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

7762: (
7763: p_api_version IN NUMBER := 1.0,
7764: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
7765: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7766: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
7767: p_debug_mode IN VARCHAR2 := 'N',
7768: p_calling_page_name IN VARCHAR2,
7769: p_project_id IN NUMBER,
7770: p_structure_version_id IN NUMBER,

Line 7847: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

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;
7849: END IF;
7850:
7851:

Line 7848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
7849: END IF;
7850:
7851:
7852: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 7852: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

7848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7849: END IF;
7850:
7851:
7852: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
7853: FND_MSG_PUB.initialize;
7854: END IF;
7855:
7856:

Line 7861: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
7863: --check if projects has subprojects
7864: OPEN get_structures;
7865: FETCH get_structures into l_struc_ver_id, l_project_id

Line 9722: when FND_API.G_EXC_UNEXPECTED_ERROR then

9718: --end code to populate tasks for subprojects
9719: --end bug 4197654
9720:
9721: EXCEPTION
9722: when FND_API.G_EXC_UNEXPECTED_ERROR then
9723: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
9724: x_msg_count := 1;
9725: x_msg_data := SQLERRM;
9726:

Line 9723: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

9719: --end bug 4197654
9720:
9721: EXCEPTION
9722: when FND_API.G_EXC_UNEXPECTED_ERROR then
9723: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
9724: x_msg_count := 1;
9725: x_msg_data := SQLERRM;
9726:
9727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9723: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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

Line 9732: 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;
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',

Line 9750: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

9746:
9747: procedure INSERT_PUBLISHED_RECORD
9748: (
9749: p_api_version IN NUMBER := 1.0,
9750: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
9751: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9752: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
9753: p_debug_mode IN VARCHAR2 := 'N',
9754: p_project_id IN NUMBER,

Line 9751: p_commit IN VARCHAR2 := FND_API.G_FALSE,

9747: procedure INSERT_PUBLISHED_RECORD
9748: (
9749: p_api_version IN NUMBER := 1.0,
9750: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
9751: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9752: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
9753: p_debug_mode IN VARCHAR2 := 'N',
9754: p_project_id IN NUMBER,
9755: p_structure_version_id IN NUMBER,

Line 9752: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

9748: (
9749: p_api_version IN NUMBER := 1.0,
9750: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
9751: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9752: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
9753: p_debug_mode IN VARCHAR2 := 'N',
9754: p_project_id IN NUMBER,
9755: p_structure_version_id IN NUMBER,
9756: p_task_version_id IN NUMBER,

Line 9793: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

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;
9795: END IF;
9796:
9797:

Line 9794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
9795: END IF;
9796:
9797:
9798: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 9798: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

9794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9795: END IF;
9796:
9797:
9798: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
9799: FND_MSG_PUB.initialize;
9800: END IF;
9801:
9802:

Line 9807: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
9809: -- Bug Fix 5609629
9810: -- Caching the versioning_enabled_flag attribute value locally.
9811: l_versioning_enabled_flag := pa_workplan_attr_utils.check_wp_versioning_enabled(p_project_id);

Line 10486: when FND_API.G_EXC_UNEXPECTED_ERROR then

10482: ----and ppc.structure_type (+) = ppru.structure_type -- Fix for Bug # 4216980.
10483: ;
10484:
10485: EXCEPTION
10486: when FND_API.G_EXC_UNEXPECTED_ERROR then
10487: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
10488: x_msg_count := 1;
10489: x_msg_data := SQLERRM;
10490:

Line 10487: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

10483: ;
10484:
10485: EXCEPTION
10486: when FND_API.G_EXC_UNEXPECTED_ERROR then
10487: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
10488: x_msg_count := 1;
10489: x_msg_data := SQLERRM;
10490:
10491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10487: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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

Line 10496: 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;
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',

Line 10510: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

10506:
10507: procedure INSERT_WORKING_RECORD
10508: (
10509: p_api_version IN NUMBER := 1.0,
10510: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
10511: p_commit IN VARCHAR2 := FND_API.G_FALSE,
10512: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
10513: p_debug_mode IN VARCHAR2 := 'N',
10514: p_project_id IN NUMBER,

Line 10511: p_commit IN VARCHAR2 := FND_API.G_FALSE,

10507: procedure INSERT_WORKING_RECORD
10508: (
10509: p_api_version IN NUMBER := 1.0,
10510: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
10511: p_commit IN VARCHAR2 := FND_API.G_FALSE,
10512: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
10513: p_debug_mode IN VARCHAR2 := 'N',
10514: p_project_id IN NUMBER,
10515: p_structure_version_id IN NUMBER,

Line 10512: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

10508: (
10509: p_api_version IN NUMBER := 1.0,
10510: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
10511: p_commit IN VARCHAR2 := FND_API.G_FALSE,
10512: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
10513: p_debug_mode IN VARCHAR2 := 'N',
10514: p_project_id IN NUMBER,
10515: p_structure_version_id IN NUMBER,
10516: p_task_version_id IN NUMBER,

Line 10553: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

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;
10555: END IF;
10556:
10557:

Line 10554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
10555: END IF;
10556:
10557:
10558: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 10558: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

10554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10555: END IF;
10556:
10557:
10558: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
10559: FND_MSG_PUB.initialize;
10560: END IF;
10561:
10562:

Line 10567: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
10569: -- Bug Fix 5609629
10570: -- Caching the versioning_enabled_flag attribute value locally.
10571: l_versioning_enabled_flag := pa_workplan_attr_utils.check_wp_versioning_enabled(p_project_id);

Line 11245: when FND_API.G_EXC_UNEXPECTED_ERROR then

11241: ---and ppc.structure_type (+) = ppru.structure_type -- Fix for Bug # 4627329.
11242: ;
11243:
11244: EXCEPTION
11245: when FND_API.G_EXC_UNEXPECTED_ERROR then
11246: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
11247: x_msg_count := 1;
11248: x_msg_data := SQLERRM;
11249:

Line 11246: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

11242: ;
11243:
11244: EXCEPTION
11245: when FND_API.G_EXC_UNEXPECTED_ERROR then
11246: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
11247: x_msg_count := 1;
11248: x_msg_data := SQLERRM;
11249:
11250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 11250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11246: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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

Line 11255: 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;
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',

Line 11268: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

11264:
11265: procedure INSERT_UPD_WORKING_RECORDS
11266: (
11267: p_api_version IN NUMBER := 1.0,
11268: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
11269: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11270: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
11271: p_debug_mode IN VARCHAR2 := 'N',
11272: p_project_id IN NUMBER,

Line 11269: p_commit IN VARCHAR2 := FND_API.G_FALSE,

11265: procedure INSERT_UPD_WORKING_RECORDS
11266: (
11267: p_api_version IN NUMBER := 1.0,
11268: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
11269: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11270: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
11271: p_debug_mode IN VARCHAR2 := 'N',
11272: p_project_id IN NUMBER,
11273: p_structure_version_id IN NUMBER,

Line 11270: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

11266: (
11267: p_api_version IN NUMBER := 1.0,
11268: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
11269: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11270: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
11271: p_debug_mode IN VARCHAR2 := 'N',
11272: p_project_id IN NUMBER,
11273: p_structure_version_id IN NUMBER,
11274: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 11324: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

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;
11326: END IF;
11327:
11328:

Line 11325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
11326: END IF;
11327:
11328:
11329: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 11329: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

11325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11326: END IF;
11327:
11328:
11329: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
11330: FND_MSG_PUB.initialize;
11331: END IF;
11332:
11333:

Line 11338: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
11340: -- Bug # 4875311.
11341:
11342: -- ************************************************************************************************************************

Line 13862: when FND_API.G_EXC_UNEXPECTED_ERROR then

13858:
13859: END IF;
13860:
13861: EXCEPTION
13862: when FND_API.G_EXC_UNEXPECTED_ERROR then
13863: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
13864: x_msg_count := 1;
13865: x_msg_data := SQLERRM;
13866:

Line 13863: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

13859: END IF;
13860:
13861: EXCEPTION
13862: when FND_API.G_EXC_UNEXPECTED_ERROR then
13863: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
13864: x_msg_count := 1;
13865: x_msg_data := SQLERRM;
13866:
13867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 13867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13863: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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

Line 13872: 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;
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',

Line 13885: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

13881:
13882: procedure INSERT_UPD_PUBLISHED_RECORDS
13883: (
13884: p_api_version IN NUMBER := 1.0,
13885: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
13886: p_commit IN VARCHAR2 := FND_API.G_FALSE,
13887: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
13888: p_debug_mode IN VARCHAR2 := 'N',
13889: p_project_id IN NUMBER,

Line 13886: p_commit IN VARCHAR2 := FND_API.G_FALSE,

13882: procedure INSERT_UPD_PUBLISHED_RECORDS
13883: (
13884: p_api_version IN NUMBER := 1.0,
13885: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
13886: p_commit IN VARCHAR2 := FND_API.G_FALSE,
13887: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
13888: p_debug_mode IN VARCHAR2 := 'N',
13889: p_project_id IN NUMBER,
13890: p_structure_version_id IN NUMBER,

Line 13887: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

13883: (
13884: p_api_version IN NUMBER := 1.0,
13885: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
13886: p_commit IN VARCHAR2 := FND_API.G_FALSE,
13887: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
13888: p_debug_mode IN VARCHAR2 := 'N',
13889: p_project_id IN NUMBER,
13890: p_structure_version_id IN NUMBER,
13891: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 13941: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

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;
13943: END IF;
13944:
13945:

Line 13942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
13943: END IF;
13944:
13945:
13946: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 13946: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

13942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13943: END IF;
13944:
13945:
13946: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
13947: FND_MSG_PUB.initialize;
13948: END IF;
13949:
13950:

Line 13955: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
13957: -- Bug # 4875311.
13958:
13959: -- ************************************************************************************************************************

Line 16386: when FND_API.G_EXC_UNEXPECTED_ERROR then

16382:
16383: END IF;
16384:
16385: EXCEPTION
16386: when FND_API.G_EXC_UNEXPECTED_ERROR then
16387: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
16388: x_msg_count := 1;
16389: x_msg_data := SQLERRM;
16390:

Line 16387: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

16383: END IF;
16384:
16385: EXCEPTION
16386: when FND_API.G_EXC_UNEXPECTED_ERROR then
16387: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
16388: x_msg_count := 1;
16389: x_msg_data := SQLERRM;
16390:
16391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 16391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

16387: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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

Line 16396: 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;
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',

Line 16410: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

16406: -- Bug # 4875311.
16407:
16408: procedure populate_pji_tab_for_plan_prj
16409: (p_api_version IN NUMBER :=1.0
16410: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
16411: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
16412: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
16413: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
16414: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 16411: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

16407:
16408: procedure populate_pji_tab_for_plan_prj
16409: (p_api_version IN NUMBER :=1.0
16410: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
16411: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
16412: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
16413: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
16414: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
16415: ,p_debug_mode IN VARCHAR2 :='N'

Line 16412: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

16408: procedure populate_pji_tab_for_plan_prj
16409: (p_api_version IN NUMBER :=1.0
16410: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
16411: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
16412: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
16413: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
16414: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
16415: ,p_debug_mode IN VARCHAR2 :='N'
16416: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 16413: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

16409: (p_api_version IN NUMBER :=1.0
16410: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
16411: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
16412: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
16413: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
16414: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
16415: ,p_debug_mode IN VARCHAR2 :='N'
16416: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16417: ,p_project_id IN NUMBER

Line 16446: IF (p_commit = FND_API.G_TRUE) THEN

16442: l_wbs_display_depth NUMBER;
16443: l_delete_flag VARCHAR2(1);
16444: begin
16445:
16446: IF (p_commit = FND_API.G_TRUE) THEN
16447: savepoint plan_qtys;
16448: END IF;
16449:
16450: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 16450: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

16446: IF (p_commit = FND_API.G_TRUE) THEN
16447: savepoint plan_qtys;
16448: END IF;
16449:
16450: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
16451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16452: END IF;
16453:
16454: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 16451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

16447: savepoint plan_qtys;
16448: END IF;
16449:
16450: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
16451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16452: END IF;
16453:
16454: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
16455: FND_MSG_PUB.initialize;

Line 16454: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

16450: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
16451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16452: END IF;
16453:
16454: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
16455: FND_MSG_PUB.initialize;
16456: END IF;
16457:
16458: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 16458: x_return_status := FND_API.G_RET_STS_SUCCESS;

16454: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
16455: FND_MSG_PUB.initialize;
16456: END IF;
16457:
16458: x_return_status := FND_API.G_RET_STS_SUCCESS;
16459:
16460: --bug 4290593
16461: IF p_populate_tmp_tab_flag = 'N' AND PA_PROJ_STRUCTURE_UTILS.CHECK_PJI_TEMP_TAB_POPULATED(p_project_id) = 'Y'
16462: THEN

Line 16502: RAISE FND_API.G_EXC_ERROR;

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;
16504:
16505: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
16506: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 16505: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;
16504:
16505: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
16506: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16507: p_msg_name => l_msg_data);
16508: x_msg_data := l_msg_data;
16509: x_return_status := 'E';

Line 16511: RAISE FND_API.G_EXC_ERROR;

16507: p_msg_name => l_msg_data);
16508: x_msg_data := l_msg_data;
16509: x_return_status := 'E';
16510: x_msg_count := l_msg_count;
16511: RAISE FND_API.G_EXC_ERROR;
16512: END IF;
16513: exception
16514: when FND_API.G_EXC_ERROR then
16515: if p_commit = FND_API.G_TRUE then

Line 16514: when FND_API.G_EXC_ERROR then

16510: x_msg_count := l_msg_count;
16511: RAISE FND_API.G_EXC_ERROR;
16512: END IF;
16513: exception
16514: when FND_API.G_EXC_ERROR then
16515: if p_commit = FND_API.G_TRUE then
16516: rollback to plan_qtys;
16517: end if;
16518: x_return_status := FND_API.G_RET_STS_ERROR;

Line 16515: if p_commit = FND_API.G_TRUE then

16511: RAISE FND_API.G_EXC_ERROR;
16512: END IF;
16513: exception
16514: when FND_API.G_EXC_ERROR then
16515: if p_commit = FND_API.G_TRUE then
16516: rollback to plan_qtys;
16517: end if;
16518: x_return_status := FND_API.G_RET_STS_ERROR;
16519: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 16518: x_return_status := FND_API.G_RET_STS_ERROR;

16514: when FND_API.G_EXC_ERROR then
16515: if p_commit = FND_API.G_TRUE then
16516: rollback to plan_qtys;
16517: end if;
16518: x_return_status := FND_API.G_RET_STS_ERROR;
16519: when FND_API.G_EXC_UNEXPECTED_ERROR then
16520: if p_commit = FND_API.G_TRUE then
16521: rollback to plan_qtys;
16522: end if;

Line 16519: when FND_API.G_EXC_UNEXPECTED_ERROR then

16515: if p_commit = FND_API.G_TRUE then
16516: rollback to plan_qtys;
16517: end if;
16518: x_return_status := FND_API.G_RET_STS_ERROR;
16519: when FND_API.G_EXC_UNEXPECTED_ERROR then
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;

Line 16520: if p_commit = FND_API.G_TRUE then

16516: rollback to plan_qtys;
16517: end if;
16518: x_return_status := FND_API.G_RET_STS_ERROR;
16519: when FND_API.G_EXC_UNEXPECTED_ERROR then
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',

Line 16523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

16519: when FND_API.G_EXC_UNEXPECTED_ERROR then
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

Line 16528: if p_commit = FND_API.G_TRUE then

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
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',

Line 16531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

16527: when OTHERS then
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;