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

Line 11: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

7: -- API name : CHECK_LIFECYCLE_NAME_OR_ID
8: -- Type : Utility
9: -- Pre-reqs : None.
10: -- Parameters :
11: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
12: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
13: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
14: -- x_lifecycle_id OUT NUMBER Required
15: -- x_return_status OUT VARCHAR2 Required

Line 12: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

8: -- Type : Utility
9: -- Pre-reqs : None.
10: -- Parameters :
11: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
12: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
13: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
14: -- x_lifecycle_id OUT NUMBER Required
15: -- x_return_status OUT VARCHAR2 Required
16: -- x_error_msg_code OUT VARCHAR2 Required

Line 19: ( p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM

15: -- x_return_status OUT VARCHAR2 Required
16: -- x_error_msg_code OUT VARCHAR2 Required
17:
18: PROCEDURE CHECK_LIFECYCLE_NAME_OR_ID
19: ( p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
20: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
21: ,p_check_id_flag IN VARCHAR2 := 'A'
22: ,x_lifecycle_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
23: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 20: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR

16: -- x_error_msg_code OUT VARCHAR2 Required
17:
18: PROCEDURE CHECK_LIFECYCLE_NAME_OR_ID
19: ( p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
20: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
21: ,p_check_id_flag IN VARCHAR2 := 'A'
22: ,x_lifecycle_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
23: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
24: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 28: if (p_lifecycle_id = FND_API.G_MISS_NUM) OR (p_lifecycle_id is NULL) then

24: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
25: )
26: IS
27: BEGIN
28: if (p_lifecycle_id = FND_API.G_MISS_NUM) OR (p_lifecycle_id is NULL) then
29: if (p_lifecycle_name is not NULL) then
30: SELECT pev.element_version_id
31: INTO x_lifecycle_id
32: FROM pa_proj_elements pe, pa_proj_element_versions pev,

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60: END IF;
61: end if;
62: end if;
63:
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65: EXCEPTION
66: when NO_DATA_FOUND then
67: x_lifecycle_id := NULL;
68: x_return_status := FND_API.G_RET_STS_ERROR;

Line 68: x_return_status := FND_API.G_RET_STS_ERROR;

64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65: EXCEPTION
66: when NO_DATA_FOUND then
67: x_lifecycle_id := NULL;
68: x_return_status := FND_API.G_RET_STS_ERROR;
69: x_error_msg_code := 'PA_LCYL_NOT_VALID';
70: when OTHERS then
71: x_lifecycle_id := NULL;
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

68: x_return_status := FND_API.G_RET_STS_ERROR;
69: x_error_msg_code := 'PA_LCYL_NOT_VALID';
70: when OTHERS then
71: x_lifecycle_id := NULL;
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_UTILS', p_procedure_name => 'CHECK_LIFECYCLE_NAME_OR_ID');
74: raise;
75: END CHECK_LIFECYCLE_NAME_OR_ID;
76:

Line 81: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

77: -- API name : CHECK_LIFECYCLE_PHASE_NAME_ID
78: -- Type : Utility
79: -- Pre-reqs : None.
80: -- Parameters :
81: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
82: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
83: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
84: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
85: -- x_current_lifecycle_phase_id OUT NUMBER Required

Line 82: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

78: -- Type : Utility
79: -- Pre-reqs : None.
80: -- Parameters :
81: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
82: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
83: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
84: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
85: -- x_current_lifecycle_phase_id OUT NUMBER Required
86: -- x_return_status OUT VARCHAR2 Required

Line 83: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

79: -- Pre-reqs : None.
80: -- Parameters :
81: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
82: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
83: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
84: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
85: -- x_current_lifecycle_phase_id OUT NUMBER Required
86: -- x_return_status OUT VARCHAR2 Required
87: -- x_error_msg_code OUT VARCHAR2 Required

Line 90: ( p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM

86: -- x_return_status OUT VARCHAR2 Required
87: -- x_error_msg_code OUT VARCHAR2 Required
88:
89: PROCEDURE CHECK_LIFECYCLE_PHASE_NAME_ID
90: ( p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
91: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
92: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
93: ,p_check_id_flag IN VARCHAR2 := 'A'
94: ,x_current_lifecycle_phase_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 91: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM

87: -- x_error_msg_code OUT VARCHAR2 Required
88:
89: PROCEDURE CHECK_LIFECYCLE_PHASE_NAME_ID
90: ( p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
91: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
92: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
93: ,p_check_id_flag IN VARCHAR2 := 'A'
94: ,x_current_lifecycle_phase_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
95: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 92: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR

88:
89: PROCEDURE CHECK_LIFECYCLE_PHASE_NAME_ID
90: ( p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
91: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
92: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
93: ,p_check_id_flag IN VARCHAR2 := 'A'
94: ,x_current_lifecycle_phase_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
95: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 101: if (p_lifecycle_id = FND_API.G_MISS_NUM) OR (p_lifecycle_id is NULL) then

97: )
98: IS
99: NO_LIFECYCLE EXCEPTION;
100: BEGIN
101: if (p_lifecycle_id = FND_API.G_MISS_NUM) OR (p_lifecycle_id is NULL) then
102: RAISE NO_LIFECYCLE;
103: end if;
104:
105: if (p_current_lifecycle_phase_id = FND_API.G_MISS_NUM) OR (p_current_lifecycle_phase_id is NULL) then

Line 105: if (p_current_lifecycle_phase_id = FND_API.G_MISS_NUM) OR (p_current_lifecycle_phase_id is NULL) then

101: if (p_lifecycle_id = FND_API.G_MISS_NUM) OR (p_lifecycle_id is NULL) then
102: RAISE NO_LIFECYCLE;
103: end if;
104:
105: if (p_current_lifecycle_phase_id = FND_API.G_MISS_NUM) OR (p_current_lifecycle_phase_id is NULL) then
106: if (p_current_lifecycle_phase is not NULL) then
107: SELECT pev.element_version_id
108: INTO x_current_lifecycle_phase_id
109: FROM pa_proj_elements pe, pa_proj_element_versions pev

Line 137: x_return_status := FND_API.G_RET_STS_SUCCESS;

133: END IF;
134: end if;
135: end if;
136:
137: x_return_status := FND_API.G_RET_STS_SUCCESS;
138: EXCEPTION
139: when NO_LIFECYCLE then
140: x_current_lifecycle_phase_id := NULL;
141: x_return_status := FND_API.G_RET_STS_ERROR;

Line 141: x_return_status := FND_API.G_RET_STS_ERROR;

137: x_return_status := FND_API.G_RET_STS_SUCCESS;
138: EXCEPTION
139: when NO_LIFECYCLE then
140: x_current_lifecycle_phase_id := NULL;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: x_error_msg_code := 'PA_LCYL_LIFECYCLE_REQUIRED';
143: when NO_DATA_FOUND then
144: x_current_lifecycle_phase_id := NULL;
145: x_return_status := FND_API.G_RET_STS_ERROR;

Line 145: x_return_status := FND_API.G_RET_STS_ERROR;

141: x_return_status := FND_API.G_RET_STS_ERROR;
142: x_error_msg_code := 'PA_LCYL_LIFECYCLE_REQUIRED';
143: when NO_DATA_FOUND then
144: x_current_lifecycle_phase_id := NULL;
145: x_return_status := FND_API.G_RET_STS_ERROR;
146: x_error_msg_code := 'PA_LCYL_PHASE_NOT_VALID';
147: when OTHERS then
148: x_current_lifecycle_phase_id := NULL;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

145: x_return_status := FND_API.G_RET_STS_ERROR;
146: x_error_msg_code := 'PA_LCYL_PHASE_NOT_VALID';
147: when OTHERS then
148: x_current_lifecycle_phase_id := NULL;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_UTILS', p_procedure_name => 'CHECK_LIFECYCLE_PHASE_NAME_ID');
151: raise;
152: END CHECK_LIFECYCLE_PHASE_NAME_ID;
153:

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

154: -- API name : Check_Approver_Name_Or_Id
155: -- Type : Utility
156: -- Pre-reqs : None.
157: -- Parameters :
158: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
159: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
160: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
161: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
162: -- x_approver_source_id OUT NUMBER Required

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

155: -- Type : Utility
156: -- Pre-reqs : None.
157: -- Parameters :
158: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
159: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
160: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
161: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
162: -- x_approver_source_id OUT NUMBER Required
163: -- x_approver_source_type OUT NUMBER Required

Line 160: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

156: -- Pre-reqs : None.
157: -- Parameters :
158: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
159: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
160: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
161: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
162: -- x_approver_source_id OUT NUMBER Required
163: -- x_approver_source_type OUT NUMBER Required
164: -- x_return_status OUT VARCHAR2 Required

Line 168: ( p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM

164: -- x_return_status OUT VARCHAR2 Required
165: -- x_error_msg_code OUT VARCHAR2 Required
166:
167: PROCEDURE CHECK_APPROVER_NAME_OR_ID
168: ( p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
169: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
170: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
171: ,p_check_id_flag IN VARCHAR2 := 'A'
172: ,x_approver_source_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 169: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM

165: -- x_error_msg_code OUT VARCHAR2 Required
166:
167: PROCEDURE CHECK_APPROVER_NAME_OR_ID
168: ( p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
169: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
170: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
171: ,p_check_id_flag IN VARCHAR2 := 'A'
172: ,x_approver_source_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
173: ,x_approver_source_type OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 170: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR

166:
167: PROCEDURE CHECK_APPROVER_NAME_OR_ID
168: ( p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
169: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
170: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
171: ,p_check_id_flag IN VARCHAR2 := 'A'
172: ,x_approver_source_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
173: ,x_approver_source_type OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
174: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 189: if (p_approver_source_id = FND_API.G_MISS_NUM) OR (p_approver_source_id is NULL) then

185: FROM pa_people_lov_v
186: WHERE name = p_approver_name;
187:
188: BEGIN
189: if (p_approver_source_id = FND_API.G_MISS_NUM) OR (p_approver_source_id is NULL) then
190: if (p_approver_name is not NULL) then
191: SELECT resource_source_id, resource_type_id
192: INTO x_approver_source_id, x_approver_source_type
193: FROM pa_people_lov_v

Line 247: x_return_status := FND_API.G_RET_STS_SUCCESS;

243: END IF;
244: END IF;
245: end if;
246: end if;
247: x_return_status := FND_API.G_RET_STS_SUCCESS;
248: EXCEPTION
249: when NO_DATA_FOUND then
250: x_approver_source_id := NULL;
251: x_approver_source_type := NULL;

Line 252: x_return_status := FND_API.G_RET_STS_ERROR;

248: EXCEPTION
249: when NO_DATA_FOUND then
250: x_approver_source_id := NULL;
251: x_approver_source_type := NULL;
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: x_error_msg_code := 'PA_APPR_SOURCE_NAME_INV';
254: when TOO_MANY_ROWS then
255: x_approver_source_id := NULL;
256: x_approver_source_type := NULL;

Line 257: x_return_status := FND_API.G_RET_STS_ERROR;

253: x_error_msg_code := 'PA_APPR_SOURCE_NAME_INV';
254: when TOO_MANY_ROWS then
255: x_approver_source_id := NULL;
256: x_approver_source_type := NULL;
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: x_error_msg_code := 'PA_APPR_SOURCE_NAME_MULTIPLE';
259: when OTHERS then
260: x_approver_source_id := NULL;
261: x_approver_source_type := NULL;

Line 262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

258: x_error_msg_code := 'PA_APPR_SOURCE_NAME_MULTIPLE';
259: when OTHERS then
260: x_approver_source_id := NULL;
261: x_approver_source_type := NULL;
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_UTILS', p_procedure_name => 'CHECK_APPROVER_NAME_OR_ID');
264: raise;
265: END CHECK_APPROVER_NAME_OR_ID;
266:

Line 419: x_return_status := FND_API.G_RET_STS_SUCCESS;

415: l_new_msg_data VARCHAR2(2000);
416: -- added for Bug fix: 4537865
417:
418: BEGIN
419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420:
421: OPEN get_lifecycle_version(p_lifecycle_id);
422: FETCH get_lifecycle_version INTO cur_lifecycle_version;
423: CLOSE get_lifecycle_version;

Line 434: x_return_status := FND_API.G_RET_STS_ERROR;

430:
431: EXCEPTION
432: WHEN l_delete_lifecycle_error THEN
433: PA_UTILS.add_message('PA','PA_DEL_LIFECYCLE_ERROR');
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: x_msg_data := 'PA_DEL_LIFECYCLE_ERROR';
436: x_msg_count := FND_MSG_PUB.Count_Msg;
437: If x_msg_count = 1 THEN
438: pa_interface_utils_pub.get_messages

Line 439: (p_encoded => FND_API.G_TRUE,

435: x_msg_data := 'PA_DEL_LIFECYCLE_ERROR';
436: x_msg_count := FND_MSG_PUB.Count_Msg;
437: If x_msg_count = 1 THEN
438: pa_interface_utils_pub.get_messages
439: (p_encoded => FND_API.G_TRUE,
440: p_msg_index => 1,
441: p_msg_count => x_msg_count,
442: p_msg_data => x_msg_data,
443: --p_data => x_msg_data, * Commented for Bug fix: 4537865

Line 489: x_return_status := FND_API.G_RET_STS_SUCCESS;

485: -- added for Bug fix: 4537865
486: l_new_msg_data VARCHAR2(2000);
487: -- added for Bug fix: 4537865
488: BEGIN
489: x_return_status := FND_API.G_RET_STS_SUCCESS;
490:
491: OPEN get_phase_version(p_lifecycle_phase_id);
492: FETCH get_phase_version INTO cur_phase_version;
493: CLOSE get_phase_version;

Line 504: x_return_status := FND_API.G_RET_STS_ERROR;

500:
501: EXCEPTION
502: WHEN l_del_lifecycle_phase_error THEN
503: PA_UTILS.add_message('PA','PA_DEL_LIFECYCLE_PHASE_ERROR');
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: x_msg_data := 'PA_DEL_LIFECYCLE_PHASE_ERROR';
506: x_msg_count := FND_MSG_PUB.Count_Msg;
507: If x_msg_count = 1 THEN
508: pa_interface_utils_pub.get_messages

Line 509: (p_encoded => FND_API.G_TRUE,

505: x_msg_data := 'PA_DEL_LIFECYCLE_PHASE_ERROR';
506: x_msg_count := FND_MSG_PUB.Count_Msg;
507: If x_msg_count = 1 THEN
508: pa_interface_utils_pub.get_messages
509: (p_encoded => FND_API.G_TRUE,
510: p_msg_index => 1,
511: p_msg_count => x_msg_count,
512: p_msg_data => x_msg_data,
513: -- p_data => x_msg_data, * Commented for Bug fix: 4537865

Line 579: p_validate_only => FND_API.G_FALSE

575: FETCH cur_wrkpln_attrs INTO l_cur_wrkpln_attrs_rec;
576: IF cur_wrkpln_attrs%FOUND
577: THEN
578: PA_WORKPLAN_ATTR_PUB.update_proj_workplan_attrs(
579: p_validate_only => FND_API.G_FALSE
580: ,p_project_id => l_cur_wrkpln_attrs_rec.project_id
581: ,p_proj_element_id => p_proj_element_id
582: ,p_approval_reqd_flag => l_cur_wrkpln_attrs_rec.WP_APPROVAL_REQD_FLAG
583: ,p_auto_publish_flag => l_cur_wrkpln_attrs_rec.WP_AUTO_PUBLISH_FLAG

Line 598: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

594: ,x_return_status => l_return_status
595: ,x_msg_count => l_msg_count
596: ,x_msg_data => l_msg_data
597: );
598: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
599: x_msg_count := FND_MSG_PUB.count_msg;
600: if x_msg_count = 1 then
601: pa_interface_utils_pub.get_messages
602: (p_encoded => FND_API.G_TRUE,

Line 602: (p_encoded => FND_API.G_TRUE,

598: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
599: x_msg_count := FND_MSG_PUB.count_msg;
600: if x_msg_count = 1 then
601: pa_interface_utils_pub.get_messages
602: (p_encoded => FND_API.G_TRUE,
603: p_msg_index => 1,
604: p_msg_count => l_msg_count,
605: p_msg_data => l_msg_data,
606: p_data => l_data,

Line 610: raise FND_API.G_EXC_ERROR;

606: p_data => l_data,
607: p_msg_index_out => l_msg_index_out);
608: x_msg_data := l_data;
609: end if;
610: raise FND_API.G_EXC_ERROR;
611: end if;
612:
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614:

Line 613: x_return_status := FND_API.G_RET_STS_SUCCESS;

609: end if;
610: raise FND_API.G_EXC_ERROR;
611: end if;
612:
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614:
615: END IF;
616: CLOSE cur_wrkpln_attrs;
617:

Line 623: x_return_status := FND_API.G_RET_STS_SUCCESS;

619: SET current_phase_version_id = p_lifecycle_phase_id
620: WHERE proj_element_id = p_proj_element_id;
621: */
622:
623: x_return_status := FND_API.G_RET_STS_SUCCESS;
624: x_msg_count := 0;
625:
626: EXCEPTION
627: when FND_API.G_EXC_ERROR then

Line 627: when FND_API.G_EXC_ERROR then

623: x_return_status := FND_API.G_RET_STS_SUCCESS;
624: x_msg_count := 0;
625:
626: EXCEPTION
627: when FND_API.G_EXC_ERROR then
628: FND_MSG_PUB.add_exc_msg
629: (p_pkg_name => 'PA_WORKPLAN_ATTR_UTILS.UPDATE_CURRENT_PHASE',
630: p_procedure_name => PA_DEBUG.G_Err_Stack );
631: x_return_status := FND_API.G_RET_STS_ERROR;

Line 631: x_return_status := FND_API.G_RET_STS_ERROR;

627: when FND_API.G_EXC_ERROR then
628: FND_MSG_PUB.add_exc_msg
629: (p_pkg_name => 'PA_WORKPLAN_ATTR_UTILS.UPDATE_CURRENT_PHASE',
630: p_procedure_name => PA_DEBUG.G_Err_Stack );
631: x_return_status := FND_API.G_RET_STS_ERROR;
632:
633: WHEN OTHERS THEN
634: FND_MSG_PUB.add_exc_msg
635: (p_pkg_name => 'PA_WORKPLAN_ATTR_UTILS.UPDATE_CURRENT_PHASE',

Line 637: x_return_status := FND_API.G_RET_STS_ERROR;

633: WHEN OTHERS THEN
634: FND_MSG_PUB.add_exc_msg
635: (p_pkg_name => 'PA_WORKPLAN_ATTR_UTILS.UPDATE_CURRENT_PHASE',
636: p_procedure_name => PA_DEBUG.G_Err_Stack );
637: x_return_status := FND_API.G_RET_STS_ERROR;
638: RAISE;
639:
640: END UPDATE_CURRENT_PHASE;
641: