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_WORKPLAN_ATTR_PVT dependencies on FND_API

Line 12: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

8: -- API name : Create_Proj_Workplan_Attrs
9: -- Type : Private
10: -- Pre-reqs : None.
11: -- Parameters :
12: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
13: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
14: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
15: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
16: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 13: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

9: -- Type : Private
10: -- Pre-reqs : None.
11: -- Parameters :
12: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
13: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
14: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
15: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
16: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
17: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 14: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

10: -- Pre-reqs : None.
11: -- Parameters :
12: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
13: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
14: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
15: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
16: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
17: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
18: -- p_project_id IN NUMBER Required

Line 17: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

13: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
14: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
15: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
16: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
17: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
18: -- p_project_id IN NUMBER Required
19: -- p_proj_element_id IN NUMBER Required
20: -- p_approval_reqd_flag IN VARCHAR2 Required
21: -- p_auto_publish_flag IN VARCHAR2 Required

Line 28: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM

24: -- p_default_display_lvl IN NUMBER Required
25: -- p_enable_wp_version_flag IN VARCHAR2 Required
26: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required
27: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required
28: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_use_task_schedule_flag IN VARCHAR2 Optional
30: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
31: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
32: -- x_return_status OUT VARCHAR2 Required

Line 30: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM

26: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required
27: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required
28: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_use_task_schedule_flag IN VARCHAR2 Optional
30: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
31: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
32: -- x_return_status OUT VARCHAR2 Required
33: -- x_msg_count OUT NUMBER Required
34: -- x_msg_data OUT VARCHAR2 Optional

Line 31: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM

27: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required
28: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_use_task_schedule_flag IN VARCHAR2 Optional
30: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
31: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
32: -- x_return_status OUT VARCHAR2 Required
33: -- x_msg_count OUT NUMBER Required
34: -- x_msg_data OUT VARCHAR2 Optional
35:

Line 37: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

33: -- x_msg_count OUT NUMBER Required
34: -- x_msg_data OUT VARCHAR2 Optional
35:
36: PROCEDURE CREATE_PROJ_WORKPLAN_ATTRS
37: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
38: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
39: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
40: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
41: ,p_debug_mode IN VARCHAR2 := 'N'

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

34: -- x_msg_data OUT VARCHAR2 Optional
35:
36: PROCEDURE CREATE_PROJ_WORKPLAN_ATTRS
37: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
38: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
39: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
40: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
41: ,p_debug_mode IN VARCHAR2 := 'N'
42: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

35:
36: PROCEDURE CREATE_PROJ_WORKPLAN_ATTRS
37: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
38: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
39: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
40: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
41: ,p_debug_mode IN VARCHAR2 := 'N'
42: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
43: ,p_project_id IN NUMBER

Line 42: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

38: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
39: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
40: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
41: ,p_debug_mode IN VARCHAR2 := 'N'
42: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
43: ,p_project_id IN NUMBER
44: ,p_proj_element_id IN NUMBER
45: ,p_approval_reqd_flag IN VARCHAR2
46: ,p_auto_publish_flag IN VARCHAR2

Line 53: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM

49: ,p_default_display_lvl IN NUMBER
50: ,p_enable_wp_version_flag IN VARCHAR2
51: ,p_auto_pub_upon_creation_flag IN VARCHAR2
52: ,p_auto_sync_txn_date_flag IN VARCHAR2
53: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
54: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
55: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
56: --bug 3325803: FP M
57: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 54: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM

50: ,p_enable_wp_version_flag IN VARCHAR2
51: ,p_auto_pub_upon_creation_flag IN VARCHAR2
52: ,p_auto_sync_txn_date_flag IN VARCHAR2
53: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
54: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
55: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
56: --bug 3325803: FP M
57: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
58: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 55: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM

51: ,p_auto_pub_upon_creation_flag IN VARCHAR2
52: ,p_auto_sync_txn_date_flag IN VARCHAR2
53: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
54: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
55: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
56: --bug 3325803: FP M
57: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
58: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
59: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 57: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

53: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
54: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
55: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
56: --bug 3325803: FP M
57: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
58: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
59: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
60: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
61: --bug 3325803: FP M

Line 58: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

54: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
55: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
56: --bug 3325803: FP M
57: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
58: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
59: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
60: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
61: --bug 3325803: FP M
62: -- gboomina added from MC-07 bug 8586393 - start

Line 59: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

55: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
56: --bug 3325803: FP M
57: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
58: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
59: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
60: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
61: --bug 3325803: FP M
62: -- gboomina added from MC-07 bug 8586393 - start
63: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 60: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

56: --bug 3325803: FP M
57: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
58: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
59: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
60: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
61: --bug 3325803: FP M
62: -- gboomina added from MC-07 bug 8586393 - start
63: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
64: -- gboomina added from MC-07 bug 8586393 - end

Line 63: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

59: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
60: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
61: --bug 3325803: FP M
62: -- gboomina added from MC-07 bug 8586393 - start
63: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
64: -- gboomina added from MC-07 bug 8586393 - end
65: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
66: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
67: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 110: IF (p_use_task_schedule_flag <> FND_API.G_MISS_CHAR) THEN

106: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Create_Proj_Workplan_Attrs BEGIN');
107: end if;
108:
109: -- gboomina added from MC-07 bug 8586393 - start
110: IF (p_use_task_schedule_flag <> FND_API.G_MISS_CHAR) THEN
111: --if values is passed as parameter
112: l_use_task_schedule_flag := p_use_task_schedule_flag;
113: ELSE
114: --get value from parent project or template

Line 121: if p_commit = FND_API.G_TRUE then

117: CLOSE C2;
118: END IF;
119: -- gboomina added from MC-07 bug 8586393 - end
120:
121: if p_commit = FND_API.G_TRUE then
122: savepoint create_proj_workplan_attrs_pvt;
123: end if;
124:
125: if p_approval_reqd_flag <> 'Y' then

Line 135: if p_txn_date_sync_buf_days = FND_API.G_MISS_NUM THEN

131: l_approver_source_id := p_approver_source_id;
132: l_approver_source_type := p_approver_source_type;
133: end if;
134:
135: if p_txn_date_sync_buf_days = FND_API.G_MISS_NUM THEN
136: l_txn_date_sync_buf_days := NULL;
137: else
138: l_txn_date_sync_buf_days := p_txn_date_sync_buf_days;
139: end if;

Line 141: If p_lifecycle_version_id = FND_API.G_MISS_NUM THEN

137: else
138: l_txn_date_sync_buf_days := p_txn_date_sync_buf_days;
139: end if;
140:
141: If p_lifecycle_version_id = FND_API.G_MISS_NUM THEN
142: l_lifecycle_version_id := NULL;
143: else
144: l_lifecycle_version_id := p_lifecycle_version_id;
145: end if;

Line 147: IF p_current_phase_version_id = FND_API.G_MISS_NUM THEN

143: else
144: l_lifecycle_version_id := p_lifecycle_version_id;
145: end if;
146:
147: IF p_current_phase_version_id = FND_API.G_MISS_NUM THEN
148: l_current_phase_version_id := NULL;
149: else
150: l_current_phase_version_id := p_current_phase_version_id;
151: end if;

Line 154: IF (p_allow_lowest_tsk_dep_flag = FND_API.G_MISS_CHAR) THEN

150: l_current_phase_version_id := p_current_phase_version_id;
151: end if;
152:
153: --bug 3325803: FP M
154: IF (p_allow_lowest_tsk_dep_flag = FND_API.G_MISS_CHAR) THEN
155: l_allow_lowest_tsk_dep_flag := 'N';
156: ELSE
157: l_allow_lowest_tsk_dep_flag := p_allow_lowest_tsk_dep_flag;
158: END IF;

Line 160: IF (p_schedule_third_party_flag = FND_API.G_MISS_CHAR) THEN

156: ELSE
157: l_allow_lowest_tsk_dep_flag := p_allow_lowest_tsk_dep_flag;
158: END IF;
159:
160: IF (p_schedule_third_party_flag = FND_API.G_MISS_CHAR) THEN
161: l_schedule_third_party_flag := 'N';
162: ELSE
163: l_schedule_third_party_flag := p_schedule_third_party_flag;
164: END IF;

Line 166: IF (p_third_party_schedule_code = FND_API.G_MISS_CHAR) THEN

162: ELSE
163: l_schedule_third_party_flag := p_schedule_third_party_flag;
164: END IF;
165:
166: IF (p_third_party_schedule_code = FND_API.G_MISS_CHAR) THEN
167: l_third_party_schedule_code := NULL;
168: ELSE
169: l_third_party_schedule_code := p_third_party_schedule_code;
170: END IF;

Line 172: IF (p_auto_rollup_subproj_flag = FND_API.G_MISS_CHAR) THEN

168: ELSE
169: l_third_party_schedule_code := p_third_party_schedule_code;
170: END IF;
171:
172: IF (p_auto_rollup_subproj_flag = FND_API.G_MISS_CHAR) THEN
173: --l_auto_rollup_subproj_flag := 'N';
174: l_auto_rollup_subproj_flag := 'Y';
175: ELSE
176: l_auto_rollup_subproj_flag := p_auto_rollup_subproj_flag;

Line 180: if p_validate_only <> FND_API.G_TRUE then

176: l_auto_rollup_subproj_flag := p_auto_rollup_subproj_flag;
177: END IF;
178: --end bug 3325803
179:
180: if p_validate_only <> FND_API.G_TRUE then
181: INSERT INTO PA_PROJ_WORKPLAN_ATTR (
182: project_id
183: ,proj_element_id
184: ,wp_approval_reqd_flag

Line 237: x_return_status := FND_API.G_RET_STS_SUCCESS;

233: ,'PA_PROJECTS'
234: ,l_use_task_schedule_flag); -- gboomina added for bug 8586393
235: end if;
236:
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: if p_commit = FND_API.G_TRUE then
240: commit work;
241: end if;

Line 239: if p_commit = FND_API.G_TRUE then

235: end if;
236:
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: if p_commit = FND_API.G_TRUE then
240: commit work;
241: end if;
242:
243: if (p_debug_mode = 'Y') then

Line 248: when FND_API.G_EXC_ERROR then

244: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Create_Proj_Workplan_Attrs END');
245: end if;
246:
247: EXCEPTION
248: when FND_API.G_EXC_ERROR then
249: if p_commit = FND_API.G_TRUE then
250: rollback to create_proj_workplan_attrs_pvt;
251: end if;
252: x_return_status := FND_API.G_RET_STS_ERROR;

Line 249: if p_commit = FND_API.G_TRUE then

245: end if;
246:
247: EXCEPTION
248: when FND_API.G_EXC_ERROR then
249: if p_commit = FND_API.G_TRUE then
250: rollback to create_proj_workplan_attrs_pvt;
251: end if;
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 252: x_return_status := FND_API.G_RET_STS_ERROR;

248: when FND_API.G_EXC_ERROR then
249: if p_commit = FND_API.G_TRUE then
250: rollback to create_proj_workplan_attrs_pvt;
251: end if;
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: when FND_API.G_EXC_UNEXPECTED_ERROR then
254: if p_commit = FND_API.G_TRUE then
255: rollback to create_proj_workplan_attrs_pvt;
256: end if;

Line 253: when FND_API.G_EXC_UNEXPECTED_ERROR then

249: if p_commit = FND_API.G_TRUE then
250: rollback to create_proj_workplan_attrs_pvt;
251: end if;
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: when FND_API.G_EXC_UNEXPECTED_ERROR then
254: if p_commit = FND_API.G_TRUE then
255: rollback to create_proj_workplan_attrs_pvt;
256: end if;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 254: if p_commit = FND_API.G_TRUE then

250: rollback to create_proj_workplan_attrs_pvt;
251: end if;
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: when FND_API.G_EXC_UNEXPECTED_ERROR then
254: if p_commit = FND_API.G_TRUE then
255: rollback to create_proj_workplan_attrs_pvt;
256: end if;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

Line 257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

253: when FND_API.G_EXC_UNEXPECTED_ERROR then
254: if p_commit = FND_API.G_TRUE then
255: rollback to create_proj_workplan_attrs_pvt;
256: end if;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
259: p_procedure_name => 'Create_Proj_Workplan_Attrs',
260: p_error_text => SUBSTRB(SQLERRM,1,240));
261: when OTHERS then

Line 262: if p_commit = FND_API.G_TRUE then

258: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
259: p_procedure_name => 'Create_Proj_Workplan_Attrs',
260: p_error_text => SUBSTRB(SQLERRM,1,240));
261: when OTHERS then
262: if p_commit = FND_API.G_TRUE then
263: rollback to create_proj_workplan_attrs_pvt;
264: end if;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

261: when OTHERS then
262: if p_commit = FND_API.G_TRUE then
263: rollback to create_proj_workplan_attrs_pvt;
264: end if;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
267: p_procedure_name => 'Create_Proj_Workplan_Attrs',
268: p_error_text => SUBSTRB(SQLERRM,1,240));
269: raise;

Line 277: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

273: -- API name : Update_Proj_Workplan_Attrs
274: -- Type : Private
275: -- Pre-reqs : None.
276: -- Parameters :
277: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
278: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
279: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
280: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
281: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 278: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

274: -- Type : Private
275: -- Pre-reqs : None.
276: -- Parameters :
277: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
278: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
279: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
280: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
281: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
282: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 279: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

275: -- Pre-reqs : None.
276: -- Parameters :
277: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
278: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
279: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
280: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
281: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
282: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
283: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM

Line 282: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

278: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
279: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
280: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
281: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
282: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
283: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
284: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

Line 283: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM

279: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
280: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
281: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
282: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
283: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
284: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 284: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM

280: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
281: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
282: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
283: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
284: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM

281: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
282: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
283: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
284: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM

Line 286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

282: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
283: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
284: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
290: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

Line 287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

283: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
284: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
290: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
291: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

Line 288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM

284: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
290: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
291: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
292: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

Line 289: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM

285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
290: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
291: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
292: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
293: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 290: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
290: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
291: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
292: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
293: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
294: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM

Line 291: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
290: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
291: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
292: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
293: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
294: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
295: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM

Line 292: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
290: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
291: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
292: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
293: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
294: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
295: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
296: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 293: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM

289: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
290: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
291: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
292: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
293: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
294: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
295: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
296: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
297: -- p_use_task_schedule_flag IN NUMBER Optional

Line 294: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM

290: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
291: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
292: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
293: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
294: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
295: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
296: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
297: -- p_use_task_schedule_flag IN NUMBER Optional
298: -- x_return_status OUT VARCHAR2 Required

Line 295: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM

291: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
292: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
293: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
294: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
295: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
296: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
297: -- p_use_task_schedule_flag IN NUMBER Optional
298: -- x_return_status OUT VARCHAR2 Required
299: -- x_msg_count OUT NUMBER Required

Line 296: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM

292: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
293: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
294: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
295: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
296: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
297: -- p_use_task_schedule_flag IN NUMBER Optional
298: -- x_return_status OUT VARCHAR2 Required
299: -- x_msg_count OUT NUMBER Required
300: -- x_msg_data OUT VARCHAR2 Optional

Line 305: p_commit IN VARCHAR2 := FND_API.G_FALSE

301:
302:
303: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
304: (
305: p_commit IN VARCHAR2 := FND_API.G_FALSE
306: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
307: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
308: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
309: ,p_debug_mode IN VARCHAR2 := 'N'

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

302:
303: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
304: (
305: p_commit IN VARCHAR2 := FND_API.G_FALSE
306: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
307: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
308: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
309: ,p_debug_mode IN VARCHAR2 := 'N'
310: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

303: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
304: (
305: p_commit IN VARCHAR2 := FND_API.G_FALSE
306: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
307: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
308: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
309: ,p_debug_mode IN VARCHAR2 := 'N'
310: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
311: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

Line 310: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

306: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
307: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
308: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
309: ,p_debug_mode IN VARCHAR2 := 'N'
310: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
311: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
312: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
313: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
314: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

Line 311: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

307: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
308: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
309: ,p_debug_mode IN VARCHAR2 := 'N'
310: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
311: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
312: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
313: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
314: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
315: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

Line 312: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

308: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
309: ,p_debug_mode IN VARCHAR2 := 'N'
310: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
311: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
312: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
313: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
314: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
315: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
316: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

Line 313: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

309: ,p_debug_mode IN VARCHAR2 := 'N'
310: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
311: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
312: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
313: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
314: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
315: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
316: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
317: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

Line 314: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

310: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
311: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
312: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
313: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
314: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
315: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
316: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
317: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
318: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

Line 315: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

311: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
312: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
313: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
314: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
315: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
316: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
317: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
318: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
319: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

Line 316: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

312: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
313: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
314: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
315: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
316: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
317: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
318: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
319: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
320: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

Line 317: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

313: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
314: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
315: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
316: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
317: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
318: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
319: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
320: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
321: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM

Line 318: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

314: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
315: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
316: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
317: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
318: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
319: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
320: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
321: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
322: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM

Line 319: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

315: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
316: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
317: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
318: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
319: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
320: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
321: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
322: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
323: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM

Line 320: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

316: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
317: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
318: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
319: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
320: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
321: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
322: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
323: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
324: --bug 3325803: FP M

Line 321: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM

317: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
318: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
319: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
320: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
321: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
322: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
323: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
324: --bug 3325803: FP M
325: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 322: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM

318: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
319: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
320: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
321: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
322: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
323: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
324: --bug 3325803: FP M
325: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
326: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 323: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM

319: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
320: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
321: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
322: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
323: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
324: --bug 3325803: FP M
325: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
326: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
327: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 325: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

321: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
322: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
323: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
324: --bug 3325803: FP M
325: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
326: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
327: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
328: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
329: --bug 3325803: FP M

Line 326: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

322: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
323: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
324: --bug 3325803: FP M
325: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
326: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
327: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
328: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
329: --bug 3325803: FP M
330: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

Line 327: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

323: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
324: --bug 3325803: FP M
325: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
326: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
327: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
328: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
329: --bug 3325803: FP M
330: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
331: -- gboomina added for bug 8586393 - start

Line 328: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

324: --bug 3325803: FP M
325: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
326: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
327: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
328: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
329: --bug 3325803: FP M
330: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
331: -- gboomina added for bug 8586393 - start
332: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 330: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

326: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
327: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
328: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
329: --bug 3325803: FP M
330: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
331: -- gboomina added for bug 8586393 - start
332: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
333: -- gboomina added for bug 8586393 - end
334: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 332: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

328: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
329: --bug 3325803: FP M
330: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
331: -- gboomina added for bug 8586393 - start
332: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
333: -- gboomina added for bug 8586393 - end
334: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
335: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
336: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 410: if (p_commit = FND_API.G_TRUE) then

406: if (p_debug_mode = 'Y') then
407: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Update_Proj_Workplan_Attrs BEGIN');
408: end if;
409:
410: if (p_commit = FND_API.G_TRUE) then
411: savepoint update_proj_workplan_attrs_pvt;
412: end if;
413:
414: --LDENG

Line 445: IF l_is_lifecycle_tracking = FND_API.G_TRUE THEN

441: x_msg_count => l_msg_count ,
442: x_msg_data => l_msg_data );
443:
444:
445: IF l_is_lifecycle_tracking = FND_API.G_TRUE THEN
446: IF( p_lifecycle_version_id IS NOT NULL ) and (p_lifecycle_version_id <> FND_API.G_MISS_NUM) AND (l_lifecycle_version_id IS NOT NULL) AND (l_lifecycle_version_id <> p_lifecycle_version_id) THEN
447:
448: /* Bug2760719 -- Added code to populate error message */
449:

Line 446: IF( p_lifecycle_version_id IS NOT NULL ) and (p_lifecycle_version_id <> FND_API.G_MISS_NUM) AND (l_lifecycle_version_id IS NOT NULL) AND (l_lifecycle_version_id <> p_lifecycle_version_id) THEN

442: x_msg_data => l_msg_data );
443:
444:
445: IF l_is_lifecycle_tracking = FND_API.G_TRUE THEN
446: IF( p_lifecycle_version_id IS NOT NULL ) and (p_lifecycle_version_id <> FND_API.G_MISS_NUM) AND (l_lifecycle_version_id IS NOT NULL) AND (l_lifecycle_version_id <> p_lifecycle_version_id) THEN
447:
448: /* Bug2760719 -- Added code to populate error message */
449:
450: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 462: raise FND_API.G_EXC_ERROR;

458: IF x_msg_count = 1 THEN
459: x_msg_data := l_msg_data;
460: END IF;
461:
462: raise FND_API.G_EXC_ERROR;
463: END IF;
464: END IF;
465: END IF;
466:

Line 469: if p_validate_only <> FND_API.G_TRUE then

465: END IF;
466:
467: --END mrajput
468:
469: if p_validate_only <> FND_API.G_TRUE then
470: BEGIN
471: SELECT LIFECYCLE_VERSION_ID, CURRENT_PHASE_VERSION_ID
472: INTO l_lifecycle_version_id, l_current_phase_version_id
473: FROM pa_proj_workplan_attr

Line 529: raise FND_API.G_EXC_ERROR;

525: x_msg_count := l_msg_count;
526: if x_msg_count = 1 then
527: x_msg_data := l_msg_data;
528: end if;
529: raise FND_API.G_EXC_ERROR;
530: end if;
531:
532: if p_approval_reqd_flag <> 'Y' then
533: l_auto_publish_flag := 'N';

Line 542: if p_txn_date_sync_buf_days = FND_API.G_MISS_NUM THEN

538: l_approver_source_id := p_approver_source_id;
539: l_approver_source_type := p_approver_source_type;
540: end if;
541:
542: if p_txn_date_sync_buf_days = FND_API.G_MISS_NUM THEN
543: l_txn_date_sync_buf_days := NULL;
544: else
545: l_txn_date_sync_buf_days := p_txn_date_sync_buf_days;
546: end if;

Line 550: IF (l_is_lifecycle_tracking = FND_API.G_TRUE ) THEN

546: end if;
547:
548: --mrajput
549: -- 18 Nov 2002. For Product Lifecycle Management through Bug2665633.
550: IF (l_is_lifecycle_tracking = FND_API.G_TRUE ) THEN
551:
552: -- changes for bug 2808582
553: OPEN c_current_display_sequence;
554: FETCH c_current_display_sequence into l_current_sequence,l_curr_phase_id;

Line 561: -- IF (l_current_phase_version_id is not NULL) and (p_current_phase_version_id <> FND_API.G_MISS_NUM) THEN

557: OPEN c_change_display_sequence;
558: FETCH c_change_display_sequence into l_change_sequence,l_future_phase_id;
559: CLOSE c_change_display_sequence;
560:
561: -- IF (l_current_phase_version_id is not NULL) and (p_current_phase_version_id <> FND_API.G_MISS_NUM) THEN
562: --changes for bug 2742365
563:
564: -- Changes for Bug 2760719 , Added condition so that it considers the case of nulling out the phase
565:

Line 566: IF (p_current_phase_version_id <> FND_API.G_MISS_NUM OR p_current_phase_version_id is null ) THEN

562: --changes for bug 2742365
563:
564: -- Changes for Bug 2760719 , Added condition so that it considers the case of nulling out the phase
565:
566: IF (p_current_phase_version_id <> FND_API.G_MISS_NUM OR p_current_phase_version_id is null ) THEN
567: IF ((l_current_phase_version_id IS NOT NULL ) AND (l_current_phase_version_id <> p_current_phase_version_id) AND (p_current_phase_version_id IS NOT NULL)
568: OR
569: ((l_current_phase_version_id IS NOT NULL ) AND (p_current_phase_version_id IS NULL)))THEN
570:

Line 592: raise FND_API.G_EXC_UNEXPECTED_ERROR;

588: from pa_proj_element_versions
589: where element_version_id = l_lifecycle_version_id;
590: EXCEPTION
591: WHEN OTHERS THEN
592: raise FND_API.G_EXC_UNEXPECTED_ERROR;
593: END;
594:
595: --hsiu
596: --bug 3254091

Line 619: IF l_policy_code IN ('CHANGE_ORDER_REQUIRED','NOT_ALLOWED') OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN -- bug 3423005

615: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'EGO',
616: p_msg_name => l_error_message);
617: END IF;
618:
619: IF l_policy_code IN ('CHANGE_ORDER_REQUIRED','NOT_ALLOWED') OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN -- bug 3423005
620: l_msg_count := FND_MSG_PUB.count_msg;
621: If l_msg_count > 0 THEN
622: x_msg_count := l_msg_count;
623: If l_msg_count = 1 THEN

Line 625: (p_encoded => FND_API.G_TRUE ,

621: If l_msg_count > 0 THEN
622: x_msg_count := l_msg_count;
623: If l_msg_count = 1 THEN
624: pa_interface_utils_pub.get_messages
625: (p_encoded => FND_API.G_TRUE ,
626: p_msg_index => 1 ,
627: p_msg_count => l_msg_count ,
628: p_msg_data => l_msg_data ,
629: p_data => l_data ,

Line 635: RAISE FND_API.G_EXC_ERROR;

631: );
632: x_msg_data := l_data;
633: End if;
634: End if;
635: RAISE FND_API.G_EXC_ERROR;
636: END IF;
637: end if;
638: --end bug 3254091
639:

Line 647: IF (l_lifecycle_version_id is not NULL) and (p_lifecycle_version_id <> FND_API.G_MISS_NUM or p_lifecycle_version_id is null) THEN

643: END IF;
644: ---END mrajput
645:
646: --LDENG
647: IF (l_lifecycle_version_id is not NULL) and (p_lifecycle_version_id <> FND_API.G_MISS_NUM or p_lifecycle_version_id is null) THEN
648: IF(p_lifecycle_version_id is null or l_lifecycle_version_id <> p_lifecycle_version_id) THEN
649: l_clear_phase_flag := 'Y';
650: END IF;
651: END IF;

Line 653: If p_lifecycle_version_id <> FND_API.G_MISS_NUM or p_lifecycle_version_id is null THEN

649: l_clear_phase_flag := 'Y';
650: END IF;
651: END IF;
652:
653: If p_lifecycle_version_id <> FND_API.G_MISS_NUM or p_lifecycle_version_id is null THEN
654: l_lifecycle_version_id := p_lifecycle_version_id;
655: end if;
656:
657: IF p_current_phase_version_id <> FND_API.G_MISS_NUM or p_current_phase_version_id is null THEN

Line 657: IF p_current_phase_version_id <> FND_API.G_MISS_NUM or p_current_phase_version_id is null THEN

653: If p_lifecycle_version_id <> FND_API.G_MISS_NUM or p_lifecycle_version_id is null THEN
654: l_lifecycle_version_id := p_lifecycle_version_id;
655: end if;
656:
657: IF p_current_phase_version_id <> FND_API.G_MISS_NUM or p_current_phase_version_id is null THEN
658: l_current_phase_version_id := p_current_phase_version_id;
659: end if;
660: --END LDENG
661:

Line 678: raise FND_API.G_EXC_ERROR;

674: x_msg_count := l_msg_count;
675: if x_msg_count = 1 then
676: x_msg_data := l_msg_data;
677: end if;
678: raise FND_API.G_EXC_ERROR;
679: end if;
680: END IF;
681:
682: --bug 3305199: FP M

Line 702: raise FND_API.G_EXC_ERROR;

698: x_msg_count := l_msg_count;
699: IF x_msg_count = 1 THEN
700: x_msg_data := l_msg_data;
701: END IF;
702: raise FND_API.G_EXC_ERROR;
703: END IF;
704: END IF;
705:
706: END LOOP;

Line 712: IF (p_allow_lowest_tsk_dep_flag <> FND_API.G_MISS_CHAR) THEN

708: END IF;
709:
710: /*** bug 3305199 ****/
711:
712: IF (p_allow_lowest_tsk_dep_flag <> FND_API.G_MISS_CHAR) THEN
713: l_allow_lowest_tsk_dep_flag := p_allow_lowest_tsk_dep_flag;
714: END IF;
715:
716: --gboomina added for Bug 8586393 - start

Line 717: IF (p_use_task_schedule_flag <> FND_API.G_MISS_CHAR) THEN

713: l_allow_lowest_tsk_dep_flag := p_allow_lowest_tsk_dep_flag;
714: END IF;
715:
716: --gboomina added for Bug 8586393 - start
717: IF (p_use_task_schedule_flag <> FND_API.G_MISS_CHAR) THEN
718: l_use_task_schedule_flag := p_use_task_schedule_flag;
719: END IF;
720: --gboomina added for Bug 8586393 - end
721:

Line 722: IF (p_schedule_third_party_flag <> FND_API.G_MISS_CHAR) THEN

718: l_use_task_schedule_flag := p_use_task_schedule_flag;
719: END IF;
720: --gboomina added for Bug 8586393 - end
721:
722: IF (p_schedule_third_party_flag <> FND_API.G_MISS_CHAR) THEN
723: l_schedule_third_party_flag := p_schedule_third_party_flag;
724: END IF;
725:
726: IF (l_schedule_third_party_flag = 'N') THEN

Line 733: IF (p_third_party_schedule_code <> FND_API.G_MISS_CHAR) THEN

729: set SCHEDULE_DIRTY_FLAG = 'N'
730: WHERE project_id = p_project_id and proj_element_id = p_proj_element_id;
731: END IF;
732:
733: IF (p_third_party_schedule_code <> FND_API.G_MISS_CHAR) THEN
734: l_third_party_schedule_code := p_third_party_schedule_code;
735: END IF;
736:
737: IF (p_auto_rollup_subproj_flag <> FND_API.G_MISS_CHAR) THEN

Line 737: IF (p_auto_rollup_subproj_flag <> FND_API.G_MISS_CHAR) THEN

733: IF (p_third_party_schedule_code <> FND_API.G_MISS_CHAR) THEN
734: l_third_party_schedule_code := p_third_party_schedule_code;
735: END IF;
736:
737: IF (p_auto_rollup_subproj_flag <> FND_API.G_MISS_CHAR) THEN
738: l_auto_rollup_subproj_flag := p_auto_rollup_subproj_flag;
739: END IF;
740: --end bug 3325803
741:

Line 742: if p_validate_only <> FND_API.G_TRUE then

738: l_auto_rollup_subproj_flag := p_auto_rollup_subproj_flag;
739: END IF;
740: --end bug 3325803
741:
742: if p_validate_only <> FND_API.G_TRUE then
743: --added condition to specify proj_element_id
744: /*
745: Modified this update for task progress bug 3420093. Added decodes with default values in following columns
746: wp_approval_reqd_flag,wp_auto_publish_flag,wp_default_display_lvl,wp_enable_version_flag,auto_pub_upon_creation_flag,

Line 751: SET wp_approval_reqd_flag = decode( p_approval_reqd_flag, FND_API.G_MISS_CHAR, wp_approval_reqd_flag, p_approval_reqd_flag ),

747: auto_sync_txn_date_flag.
748: */
749: --bug 3905167: added nvl for p_default_display_lvl.
750: UPDATE PA_PROJ_WORKPLAN_ATTR
751: SET wp_approval_reqd_flag = decode( p_approval_reqd_flag, FND_API.G_MISS_CHAR, wp_approval_reqd_flag, p_approval_reqd_flag ),
752: wp_auto_publish_flag = decode( l_auto_publish_flag, FND_API.G_MISS_CHAR, wp_auto_publish_flag, l_auto_publish_flag ),
753: wp_approver_source_id = l_approver_source_id,
754: wp_approver_source_type = l_approver_source_type,
755: wp_default_display_lvl = decode( p_default_display_lvl, FND_API.G_MISS_NUM, wp_default_display_lvl, nvl(p_default_display_lvl,0)),

Line 752: wp_auto_publish_flag = decode( l_auto_publish_flag, FND_API.G_MISS_CHAR, wp_auto_publish_flag, l_auto_publish_flag ),

748: */
749: --bug 3905167: added nvl for p_default_display_lvl.
750: UPDATE PA_PROJ_WORKPLAN_ATTR
751: SET wp_approval_reqd_flag = decode( p_approval_reqd_flag, FND_API.G_MISS_CHAR, wp_approval_reqd_flag, p_approval_reqd_flag ),
752: wp_auto_publish_flag = decode( l_auto_publish_flag, FND_API.G_MISS_CHAR, wp_auto_publish_flag, l_auto_publish_flag ),
753: wp_approver_source_id = l_approver_source_id,
754: wp_approver_source_type = l_approver_source_type,
755: wp_default_display_lvl = decode( p_default_display_lvl, FND_API.G_MISS_NUM, wp_default_display_lvl, nvl(p_default_display_lvl,0)),
756: wp_enable_version_flag = decode( p_enable_wp_version_flag, FND_API.G_MISS_CHAR, wp_enable_version_flag, p_enable_wp_version_flag),

Line 755: wp_default_display_lvl = decode( p_default_display_lvl, FND_API.G_MISS_NUM, wp_default_display_lvl, nvl(p_default_display_lvl,0)),

751: SET wp_approval_reqd_flag = decode( p_approval_reqd_flag, FND_API.G_MISS_CHAR, wp_approval_reqd_flag, p_approval_reqd_flag ),
752: wp_auto_publish_flag = decode( l_auto_publish_flag, FND_API.G_MISS_CHAR, wp_auto_publish_flag, l_auto_publish_flag ),
753: wp_approver_source_id = l_approver_source_id,
754: wp_approver_source_type = l_approver_source_type,
755: wp_default_display_lvl = decode( p_default_display_lvl, FND_API.G_MISS_NUM, wp_default_display_lvl, nvl(p_default_display_lvl,0)),
756: wp_enable_version_flag = decode( p_enable_wp_version_flag, FND_API.G_MISS_CHAR, wp_enable_version_flag, p_enable_wp_version_flag),
757: auto_pub_upon_creation_flag = decode( p_auto_pub_upon_creation_flag, FND_API.G_MISS_CHAR, auto_pub_upon_creation_flag, p_auto_pub_upon_creation_flag ),
758: auto_sync_txn_date_flag = decode( p_auto_sync_txn_date_flag, FND_API.G_MISS_CHAR, auto_sync_txn_date_flag, p_auto_sync_txn_date_flag ),
759: txn_date_sync_buf_days = l_txn_date_sync_buf_days,

Line 756: wp_enable_version_flag = decode( p_enable_wp_version_flag, FND_API.G_MISS_CHAR, wp_enable_version_flag, p_enable_wp_version_flag),

752: wp_auto_publish_flag = decode( l_auto_publish_flag, FND_API.G_MISS_CHAR, wp_auto_publish_flag, l_auto_publish_flag ),
753: wp_approver_source_id = l_approver_source_id,
754: wp_approver_source_type = l_approver_source_type,
755: wp_default_display_lvl = decode( p_default_display_lvl, FND_API.G_MISS_NUM, wp_default_display_lvl, nvl(p_default_display_lvl,0)),
756: wp_enable_version_flag = decode( p_enable_wp_version_flag, FND_API.G_MISS_CHAR, wp_enable_version_flag, p_enable_wp_version_flag),
757: auto_pub_upon_creation_flag = decode( p_auto_pub_upon_creation_flag, FND_API.G_MISS_CHAR, auto_pub_upon_creation_flag, p_auto_pub_upon_creation_flag ),
758: auto_sync_txn_date_flag = decode( p_auto_sync_txn_date_flag, FND_API.G_MISS_CHAR, auto_sync_txn_date_flag, p_auto_sync_txn_date_flag ),
759: txn_date_sync_buf_days = l_txn_date_sync_buf_days,
760: lifecycle_version_id = l_lifecycle_version_id,

Line 757: auto_pub_upon_creation_flag = decode( p_auto_pub_upon_creation_flag, FND_API.G_MISS_CHAR, auto_pub_upon_creation_flag, p_auto_pub_upon_creation_flag ),

753: wp_approver_source_id = l_approver_source_id,
754: wp_approver_source_type = l_approver_source_type,
755: wp_default_display_lvl = decode( p_default_display_lvl, FND_API.G_MISS_NUM, wp_default_display_lvl, nvl(p_default_display_lvl,0)),
756: wp_enable_version_flag = decode( p_enable_wp_version_flag, FND_API.G_MISS_CHAR, wp_enable_version_flag, p_enable_wp_version_flag),
757: auto_pub_upon_creation_flag = decode( p_auto_pub_upon_creation_flag, FND_API.G_MISS_CHAR, auto_pub_upon_creation_flag, p_auto_pub_upon_creation_flag ),
758: auto_sync_txn_date_flag = decode( p_auto_sync_txn_date_flag, FND_API.G_MISS_CHAR, auto_sync_txn_date_flag, p_auto_sync_txn_date_flag ),
759: txn_date_sync_buf_days = l_txn_date_sync_buf_days,
760: lifecycle_version_id = l_lifecycle_version_id,
761: current_phase_version_id = l_current_phase_version_id,

Line 758: auto_sync_txn_date_flag = decode( p_auto_sync_txn_date_flag, FND_API.G_MISS_CHAR, auto_sync_txn_date_flag, p_auto_sync_txn_date_flag ),

754: wp_approver_source_type = l_approver_source_type,
755: wp_default_display_lvl = decode( p_default_display_lvl, FND_API.G_MISS_NUM, wp_default_display_lvl, nvl(p_default_display_lvl,0)),
756: wp_enable_version_flag = decode( p_enable_wp_version_flag, FND_API.G_MISS_CHAR, wp_enable_version_flag, p_enable_wp_version_flag),
757: auto_pub_upon_creation_flag = decode( p_auto_pub_upon_creation_flag, FND_API.G_MISS_CHAR, auto_pub_upon_creation_flag, p_auto_pub_upon_creation_flag ),
758: auto_sync_txn_date_flag = decode( p_auto_sync_txn_date_flag, FND_API.G_MISS_CHAR, auto_sync_txn_date_flag, p_auto_sync_txn_date_flag ),
759: txn_date_sync_buf_days = l_txn_date_sync_buf_days,
760: lifecycle_version_id = l_lifecycle_version_id,
761: current_phase_version_id = l_current_phase_version_id,
762: schedule_third_party_flag = l_schedule_third_party_flag,

Line 778: IF (l_is_lifecycle_tracking = FND_API.G_TRUE) THEN

774:
775: --mrajput
776: -- 18 Nov 2002. For Product Lifecycle Management through Bug2665633.
777: ---changes for bug2742365
778: IF (l_is_lifecycle_tracking = FND_API.G_TRUE) THEN
779:
780: PA_EGO_WRAPPER_PUB.sync_phase_change(
781: p_api_version => 1.0 ,
782: p_project_id => p_project_id ,

Line 800: raise FND_API.G_EXC_ERROR;

796: x_msg_count := l_msg_count;
797: if x_msg_count = 1 then
798: x_msg_data := l_msg_data;
799: end if;
800: raise FND_API.G_EXC_ERROR;
801: end if;
802: END IF;
803:
804:

Line 817: x_return_status := FND_API.G_RET_STS_SUCCESS;

813: end if;
814: --END LDENG
815: end if;
816:
817: x_return_status := FND_API.G_RET_STS_SUCCESS;
818:
819: if p_commit = FND_API.G_TRUE then
820: commit work;
821: end if;

Line 819: if p_commit = FND_API.G_TRUE then

815: end if;
816:
817: x_return_status := FND_API.G_RET_STS_SUCCESS;
818:
819: if p_commit = FND_API.G_TRUE then
820: commit work;
821: end if;
822:
823: if (p_debug_mode = 'Y') then

Line 828: when FND_API.G_EXC_ERROR then

824: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Update_Proj_Workplan_Attrs END');
825: end if;
826:
827: EXCEPTION
828: when FND_API.G_EXC_ERROR then
829: if p_commit = FND_API.G_TRUE then
830: rollback to update_proj_workplan_attrs_pvt;
831: end if;
832: x_return_status := FND_API.G_RET_STS_ERROR;

Line 829: if p_commit = FND_API.G_TRUE then

825: end if;
826:
827: EXCEPTION
828: when FND_API.G_EXC_ERROR then
829: if p_commit = FND_API.G_TRUE then
830: rollback to update_proj_workplan_attrs_pvt;
831: end if;
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 832: x_return_status := FND_API.G_RET_STS_ERROR;

828: when FND_API.G_EXC_ERROR then
829: if p_commit = FND_API.G_TRUE then
830: rollback to update_proj_workplan_attrs_pvt;
831: end if;
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: when FND_API.G_EXC_UNEXPECTED_ERROR then
834: if p_commit = FND_API.G_TRUE then
835: rollback to update_proj_workplan_attrs_pvt;
836: end if;

Line 833: when FND_API.G_EXC_UNEXPECTED_ERROR then

829: if p_commit = FND_API.G_TRUE then
830: rollback to update_proj_workplan_attrs_pvt;
831: end if;
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: when FND_API.G_EXC_UNEXPECTED_ERROR then
834: if p_commit = FND_API.G_TRUE then
835: rollback to update_proj_workplan_attrs_pvt;
836: end if;
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 834: if p_commit = FND_API.G_TRUE then

830: rollback to update_proj_workplan_attrs_pvt;
831: end if;
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: when FND_API.G_EXC_UNEXPECTED_ERROR then
834: if p_commit = FND_API.G_TRUE then
835: rollback to update_proj_workplan_attrs_pvt;
836: end if;
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

Line 837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

833: when FND_API.G_EXC_UNEXPECTED_ERROR then
834: if p_commit = FND_API.G_TRUE then
835: rollback to update_proj_workplan_attrs_pvt;
836: end if;
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
839: p_procedure_name => 'Update_Proj_Workplan_Attrs',
840: p_error_text => SUBSTRB(SQLERRM,1,240));
841: when OTHERS then

Line 842: if p_commit = FND_API.G_TRUE then

838: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
839: p_procedure_name => 'Update_Proj_Workplan_Attrs',
840: p_error_text => SUBSTRB(SQLERRM,1,240));
841: when OTHERS then
842: if p_commit = FND_API.G_TRUE then
843: rollback to update_proj_workplan_attrs_pvt;
844: end if;
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
846: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

Line 845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

841: when OTHERS then
842: if p_commit = FND_API.G_TRUE then
843: rollback to update_proj_workplan_attrs_pvt;
844: end if;
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
846: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
847: p_procedure_name => 'Update_Proj_Workplan_Attrs',
848: p_error_text => SUBSTRB(SQLERRM,1,240));
849: raise;

Line 857: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

853: -- API name : Update_Structure_Name
854: -- Type : Private
855: -- Pre-reqs : None.
856: -- Parameters :
857: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
858: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
859: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
860: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
861: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 858: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

854: -- Type : Private
855: -- Pre-reqs : None.
856: -- Parameters :
857: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
858: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
859: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
860: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
861: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
862: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 859: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

855: -- Pre-reqs : None.
856: -- Parameters :
857: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
858: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
859: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
860: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
861: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
862: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
863: -- p_proj_element_id IN NUMBER Required

Line 862: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

858: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
859: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
860: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
861: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
862: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
863: -- p_proj_element_id IN NUMBER Required
864: -- p_structure_name IN VARCHAR2 Required
865: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
866: -- x_return_status OUT VARCHAR2 Required

Line 865: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM

861: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
862: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
863: -- p_proj_element_id IN NUMBER Required
864: -- p_structure_name IN VARCHAR2 Required
865: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
866: -- x_return_status OUT VARCHAR2 Required
867: -- x_msg_count OUT NUMBER Required
868: -- x_msg_data OUT VARCHAR2 Optional
869:

Line 871: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

867: -- x_msg_count OUT NUMBER Required
868: -- x_msg_data OUT VARCHAR2 Optional
869:
870: PROCEDURE UPDATE_STRUCTURE_NAME
871: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
872: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
873: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
874: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
875: ,p_debug_mode IN VARCHAR2 := 'N'

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

868: -- x_msg_data OUT VARCHAR2 Optional
869:
870: PROCEDURE UPDATE_STRUCTURE_NAME
871: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
872: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
873: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
874: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
875: ,p_debug_mode IN VARCHAR2 := 'N'
876: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

869:
870: PROCEDURE UPDATE_STRUCTURE_NAME
871: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
872: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
873: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
874: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
875: ,p_debug_mode IN VARCHAR2 := 'N'
876: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
877: ,p_proj_element_id IN NUMBER

Line 876: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

872: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
873: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
874: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
875: ,p_debug_mode IN VARCHAR2 := 'N'
876: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
877: ,p_proj_element_id IN NUMBER
878: ,p_structure_name IN VARCHAR2
879: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
880: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 879: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

875: ,p_debug_mode IN VARCHAR2 := 'N'
876: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
877: ,p_proj_element_id IN NUMBER
878: ,p_structure_name IN VARCHAR2
879: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
880: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
881: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
882: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
883: )

Line 898: if p_commit = FND_API.G_TRUE then

894: if (p_debug_mode = 'Y') then
895: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Update_Structure_Name BEGIN');
896: end if;
897:
898: if p_commit = FND_API.G_TRUE then
899: savepoint update_structure_name_pvt;
900: end if;
901:
902: if p_validate_only <> FND_API.G_TRUE then

Line 902: if p_validate_only <> FND_API.G_TRUE then

898: if p_commit = FND_API.G_TRUE then
899: savepoint update_structure_name_pvt;
900: end if;
901:
902: if p_validate_only <> FND_API.G_TRUE then
903: BEGIN
904: SELECT 'x' INTO l_dummy
905: FROM pa_proj_elements
906: WHERE proj_element_id = p_proj_element_id

Line 959: raise FND_API.G_EXC_ERROR;

955: x_msg_count := l_msg_count;
956: if x_msg_count = 1 then
957: x_msg_data := l_msg_data;
958: end if;
959: raise FND_API.G_EXC_ERROR;
960: end if;
961:
962: if p_validate_only <> FND_API.G_TRUE then
963: UPDATE PA_PROJ_ELEMENTS

Line 962: if p_validate_only <> FND_API.G_TRUE then

958: end if;
959: raise FND_API.G_EXC_ERROR;
960: end if;
961:
962: if p_validate_only <> FND_API.G_TRUE then
963: UPDATE PA_PROJ_ELEMENTS
964: SET name = p_structure_name,
965: record_version_number = record_version_number + 1,
966: last_update_date = SYSDATE,

Line 972: x_return_status := FND_API.G_RET_STS_SUCCESS;

968: last_update_login = FND_GLOBAL.LOGIN_ID
969: WHERE proj_element_id = p_proj_element_id;
970: end if;
971:
972: x_return_status := FND_API.G_RET_STS_SUCCESS;
973:
974: if p_commit = FND_API.G_TRUE then
975: commit work;
976: end if;

Line 974: if p_commit = FND_API.G_TRUE then

970: end if;
971:
972: x_return_status := FND_API.G_RET_STS_SUCCESS;
973:
974: if p_commit = FND_API.G_TRUE then
975: commit work;
976: end if;
977:
978: if (p_debug_mode = 'Y') then

Line 983: when FND_API.G_EXC_ERROR then

979: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Update_Structure_Name END');
980: end if;
981:
982: EXCEPTION
983: when FND_API.G_EXC_ERROR then
984: if p_commit = FND_API.G_TRUE then
985: rollback to update_structure_name_pvt;
986: end if;
987: x_return_status := FND_API.G_RET_STS_ERROR;

Line 984: if p_commit = FND_API.G_TRUE then

980: end if;
981:
982: EXCEPTION
983: when FND_API.G_EXC_ERROR then
984: if p_commit = FND_API.G_TRUE then
985: rollback to update_structure_name_pvt;
986: end if;
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 987: x_return_status := FND_API.G_RET_STS_ERROR;

983: when FND_API.G_EXC_ERROR then
984: if p_commit = FND_API.G_TRUE then
985: rollback to update_structure_name_pvt;
986: end if;
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: when FND_API.G_EXC_UNEXPECTED_ERROR then
989: if p_commit = FND_API.G_TRUE then
990: rollback to update_structure_name_pvt;
991: end if;

Line 988: when FND_API.G_EXC_UNEXPECTED_ERROR then

984: if p_commit = FND_API.G_TRUE then
985: rollback to update_structure_name_pvt;
986: end if;
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: when FND_API.G_EXC_UNEXPECTED_ERROR then
989: if p_commit = FND_API.G_TRUE then
990: rollback to update_structure_name_pvt;
991: end if;
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 989: if p_commit = FND_API.G_TRUE then

985: rollback to update_structure_name_pvt;
986: end if;
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: when FND_API.G_EXC_UNEXPECTED_ERROR then
989: if p_commit = FND_API.G_TRUE then
990: rollback to update_structure_name_pvt;
991: end if;
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
993: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

Line 992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

988: when FND_API.G_EXC_UNEXPECTED_ERROR then
989: if p_commit = FND_API.G_TRUE then
990: rollback to update_structure_name_pvt;
991: end if;
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
993: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
994: p_procedure_name => 'Update_Structure_Name',
995: p_error_text => SUBSTRB(SQLERRM,1,240));
996: when OTHERS then

Line 997: if p_commit = FND_API.G_TRUE then

993: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
994: p_procedure_name => 'Update_Structure_Name',
995: p_error_text => SUBSTRB(SQLERRM,1,240));
996: when OTHERS then
997: if p_commit = FND_API.G_TRUE then
998: rollback to update_structure_name_pvt;
999: end if;
1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1001: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

Line 1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

996: when OTHERS then
997: if p_commit = FND_API.G_TRUE then
998: rollback to update_structure_name_pvt;
999: end if;
1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1001: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
1002: p_procedure_name => 'Update_Structure_Name',
1003: p_error_text => SUBSTRB(SQLERRM,1,240));
1004: raise;

Line 1012: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

1008: -- API name : Delete_Proj_Workplan_Attrs
1009: -- Type : Private
1010: -- Pre-reqs : None.
1011: -- Parameters :
1012: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
1013: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
1014: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1015: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
1016: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 1013: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

1009: -- Type : Private
1010: -- Pre-reqs : None.
1011: -- Parameters :
1012: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
1013: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
1014: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1015: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
1016: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
1017: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 1014: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

1010: -- Pre-reqs : None.
1011: -- Parameters :
1012: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
1013: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
1014: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1015: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
1016: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
1017: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
1018: -- p_project_id IN NUMBER Required

Line 1017: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

1013: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
1014: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1015: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
1016: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
1017: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
1018: -- p_project_id IN NUMBER Required
1019: -- p_proj_element_id IN NUMBER Required
1020: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
1021: -- x_return_status OUT VARCHAR2 Required

Line 1020: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM

1016: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
1017: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
1018: -- p_project_id IN NUMBER Required
1019: -- p_proj_element_id IN NUMBER Required
1020: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
1021: -- x_return_status OUT VARCHAR2 Required
1022: -- x_msg_count OUT NUMBER Required
1023: -- x_msg_data OUT VARCHAR2 Optional
1024:

Line 1026: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

1022: -- x_msg_count OUT NUMBER Required
1023: -- x_msg_data OUT VARCHAR2 Optional
1024:
1025: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
1026: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
1027: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1028: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1029: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1030: ,p_debug_mode IN VARCHAR2 := 'N'

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

1023: -- x_msg_data OUT VARCHAR2 Optional
1024:
1025: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
1026: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
1027: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1028: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1029: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1030: ,p_debug_mode IN VARCHAR2 := 'N'
1031: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

1024:
1025: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
1026: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
1027: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1028: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1029: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1030: ,p_debug_mode IN VARCHAR2 := 'N'
1031: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1032: ,p_project_id IN NUMBER

Line 1031: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

1027: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1028: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1029: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1030: ,p_debug_mode IN VARCHAR2 := 'N'
1031: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1032: ,p_project_id IN NUMBER
1033: ,p_proj_element_id IN NUMBER
1034: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1035: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1034: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

1030: ,p_debug_mode IN VARCHAR2 := 'N'
1031: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1032: ,p_project_id IN NUMBER
1033: ,p_proj_element_id IN NUMBER
1034: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1035: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1036: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1037: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1038: )

Line 1051: if p_commit = FND_API.G_TRUE then

1047: if (p_debug_mode = 'Y') then
1048: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Delete_Proj_Workplan_Attrs BEGIN');
1049: end if;
1050:
1051: if p_commit = FND_API.G_TRUE then
1052: savepoint delete_proj_workplan_attrs_pvt;
1053: end if;
1054:
1055: if (p_debug_mode = 'Y') then

Line 1059: if p_validate_only <> FND_API.G_TRUE then

1055: if (p_debug_mode = 'Y') then
1056: pa_debug.debug('Locking record...');
1057: end if;
1058:
1059: if p_validate_only <> FND_API.G_TRUE then
1060: BEGIN
1061: SELECT 'x' INTO l_dummy
1062: FROM pa_proj_workplan_attr
1063: WHERE proj_element_id = p_proj_element_id

Line 1118: raise FND_API.G_EXC_ERROR;

1114: x_msg_count := l_msg_count;
1115: if x_msg_count = 1 then
1116: x_msg_data := l_msg_data;
1117: end if;
1118: raise FND_API.G_EXC_ERROR;
1119: end if;
1120:
1121: if p_validate_only <> FND_API.G_TRUE then
1122:

Line 1121: if p_validate_only <> FND_API.G_TRUE then

1117: end if;
1118: raise FND_API.G_EXC_ERROR;
1119: end if;
1120:
1121: if p_validate_only <> FND_API.G_TRUE then
1122:
1123: DELETE FROM PA_PROJ_WORKPLAN_ATTR
1124: WHERE proj_element_id = p_proj_element_id;
1125:

Line 1128: x_return_status := FND_API.G_RET_STS_SUCCESS;

1124: WHERE proj_element_id = p_proj_element_id;
1125:
1126: end if;
1127:
1128: x_return_status := FND_API.G_RET_STS_SUCCESS;
1129:
1130: if p_commit = FND_API.G_TRUE then
1131: commit work;
1132: end if;

Line 1130: if p_commit = FND_API.G_TRUE then

1126: end if;
1127:
1128: x_return_status := FND_API.G_RET_STS_SUCCESS;
1129:
1130: if p_commit = FND_API.G_TRUE then
1131: commit work;
1132: end if;
1133:
1134: if (p_debug_mode = 'Y') then

Line 1139: when FND_API.G_EXC_ERROR then

1135: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Delete_Proj_Workplan_Attrs END');
1136: end if;
1137:
1138: EXCEPTION
1139: when FND_API.G_EXC_ERROR then
1140: if p_commit = FND_API.G_TRUE then
1141: rollback to delete_proj_workplan_attrs_pvt;
1142: end if;
1143: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1140: if p_commit = FND_API.G_TRUE then

1136: end if;
1137:
1138: EXCEPTION
1139: when FND_API.G_EXC_ERROR then
1140: if p_commit = FND_API.G_TRUE then
1141: rollback to delete_proj_workplan_attrs_pvt;
1142: end if;
1143: x_return_status := FND_API.G_RET_STS_ERROR;
1144: when others then

Line 1143: x_return_status := FND_API.G_RET_STS_ERROR;

1139: when FND_API.G_EXC_ERROR then
1140: if p_commit = FND_API.G_TRUE then
1141: rollback to delete_proj_workplan_attrs_pvt;
1142: end if;
1143: x_return_status := FND_API.G_RET_STS_ERROR;
1144: when others then
1145: if p_commit = FND_API.G_TRUE then
1146: rollback to delete_proj_workplan_attrs_pvt;
1147: end if;

Line 1145: if p_commit = FND_API.G_TRUE then

1141: rollback to delete_proj_workplan_attrs_pvt;
1142: end if;
1143: x_return_status := FND_API.G_RET_STS_ERROR;
1144: when others then
1145: if p_commit = FND_API.G_TRUE then
1146: rollback to delete_proj_workplan_attrs_pvt;
1147: end if;
1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1149: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

Line 1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1144: when others then
1145: if p_commit = FND_API.G_TRUE then
1146: rollback to delete_proj_workplan_attrs_pvt;
1147: end if;
1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1149: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
1150: p_procedure_name => 'Delete_Proj_Workplan_Attrs',
1151: p_error_text => SUBSTRB(SQLERRM,1,240));
1152: raise;