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

Line 129: x_ret_code VARCHAR2(1); --FND_API.G_TRUE%TYPE;

125: and prv.version_id = p_version_id;
126:
127: l_approval_required pa_object_page_layouts.approval_required%TYPE;
128: l_auto_publish VARCHAR2(1);
129: x_ret_code VARCHAR2(1); --FND_API.G_TRUE%TYPE;
130: x_return_status VARCHAR2(1); --FND_API.G_RET_STS_SUCCESS%TYPE;
131: BEGIN
132: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_UTILS_PKG.check_action_allowed');
133: x_ret_code:= fnd_api.g_true;

Line 130: x_return_status VARCHAR2(1); --FND_API.G_RET_STS_SUCCESS%TYPE;

126:
127: l_approval_required pa_object_page_layouts.approval_required%TYPE;
128: l_auto_publish VARCHAR2(1);
129: x_ret_code VARCHAR2(1); --FND_API.G_TRUE%TYPE;
130: x_return_status VARCHAR2(1); --FND_API.G_RET_STS_SUCCESS%TYPE;
131: BEGIN
132: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_UTILS_PKG.check_action_allowed');
133: x_ret_code:= fnd_api.g_true;
134: x_return_status:=fnd_api.g_ret_sts_success;

Line 133: x_ret_code:= fnd_api.g_true;

129: x_ret_code VARCHAR2(1); --FND_API.G_TRUE%TYPE;
130: x_return_status VARCHAR2(1); --FND_API.G_RET_STS_SUCCESS%TYPE;
131: BEGIN
132: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_UTILS_PKG.check_action_allowed');
133: x_ret_code:= fnd_api.g_true;
134: x_return_status:=fnd_api.g_ret_sts_success;
135: -- Initialize the Error Stack
136: PA_DEBUG.init_err_stack('PA_PROJECT_SUBTEAMS_PVT.Create_Subteam');
137:

Line 134: x_return_status:=fnd_api.g_ret_sts_success;

130: x_return_status VARCHAR2(1); --FND_API.G_RET_STS_SUCCESS%TYPE;
131: BEGIN
132: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_UTILS_PKG.check_action_allowed');
133: x_ret_code:= fnd_api.g_true;
134: x_return_status:=fnd_api.g_ret_sts_success;
135: -- Initialize the Error Stack
136: PA_DEBUG.init_err_stack('PA_PROJECT_SUBTEAMS_PVT.Create_Subteam');
137:
138: -- Validation the INPUT parameters

Line 144: x_return_status := FND_API.G_RET_STS_ERROR;

140: fetch C into l_project_system_status_code;
141: if (C%NOTFOUND) then
142: PA_UTILS.Add_Message( p_app_short_name => 'PA'
143: ,p_msg_name => 'PA_PJX_INV_PRJ_REP_STATUS');
144: x_return_status := FND_API.G_RET_STS_ERROR;
145: --x_ret_code:= fnd_api.g_false;
146: --return x_ret_code;
147: --x_msg_count := x_msg_count + 1;
148: end if;

Line 145: --x_ret_code:= fnd_api.g_false;

141: if (C%NOTFOUND) then
142: PA_UTILS.Add_Message( p_app_short_name => 'PA'
143: ,p_msg_name => 'PA_PJX_INV_PRJ_REP_STATUS');
144: x_return_status := FND_API.G_RET_STS_ERROR;
145: --x_ret_code:= fnd_api.g_false;
146: --return x_ret_code;
147: --x_msg_count := x_msg_count + 1;
148: end if;
149: close C;

Line 155: x_return_status := FND_API.G_RET_STS_ERROR;

151: fetch C1 into l_approval_required; --,l_auto_publish;
152: if (C1%NOTFOUND) then
153: PA_UTILS.Add_Message( p_app_short_name => 'PA'
154: ,p_msg_name => 'PA_PJX_INV_REP_VERSION');
155: x_return_status := FND_API.G_RET_STS_ERROR;
156: --x_ret_code:= fnd_api.g_false;
157: --x_msg_count := x_msg_count + 1;
158: end if;
159: close C1;

Line 156: --x_ret_code:= fnd_api.g_false;

152: if (C1%NOTFOUND) then
153: PA_UTILS.Add_Message( p_app_short_name => 'PA'
154: ,p_msg_name => 'PA_PJX_INV_REP_VERSION');
155: x_return_status := FND_API.G_RET_STS_ERROR;
156: --x_ret_code:= fnd_api.g_false;
157: --x_msg_count := x_msg_count + 1;
158: end if;
159: close C1;
160: if (l_approval_required = 'A') then

Line 168: x_return_status := FND_API.G_RET_STS_ERROR;

164: end if;
165: if (p_action_code NOT IN ('REWORK','EDIT','SUBMIT','PUBLISH','CANCEL')) then
166: PA_UTILS.Add_Message( p_app_short_name => 'PA'
167: ,p_msg_name => 'PA_PJX_INV_ACTION_CODE');
168: x_return_status := FND_API.G_RET_STS_ERROR;
169: --x_msg_count := x_msg_count + 1;
170: end if;
171: /* Return False if any parameter validation fails */
172: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

Line 172: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

168: x_return_status := FND_API.G_RET_STS_ERROR;
169: --x_msg_count := x_msg_count + 1;
170: end if;
171: /* Return False if any parameter validation fails */
172: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
173: x_ret_code:= fnd_api.g_false;
174: RETURN x_ret_code;
175: END IF;
176:

Line 173: x_ret_code:= fnd_api.g_false;

169: --x_msg_count := x_msg_count + 1;
170: end if;
171: /* Return False if any parameter validation fails */
172: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
173: x_ret_code:= fnd_api.g_false;
174: RETURN x_ret_code;
175: END IF;
176:
177: IF (l_project_system_status_code = 'PROGRESS_REPORT_WORKING') then

Line 181: x_ret_code:= fnd_api.g_true;

177: IF (l_project_system_status_code = 'PROGRESS_REPORT_WORKING') then
178: IF ( (p_action_code = 'EDIT') OR
179: (p_action_code ='SUBMIT' AND l_approval_required = 'Y') OR
180: (p_action_code ='PUBLISH' AND l_approval_required = 'N') ) then
181: x_ret_code:= fnd_api.g_true;
182: ELSE
183: x_ret_code:= fnd_api.g_false;
184: END IF;
185: ELSIF (l_project_system_status_code = 'PROGRESS_REPORT_SUBMITTED' OR

Line 183: x_ret_code:= fnd_api.g_false;

179: (p_action_code ='SUBMIT' AND l_approval_required = 'Y') OR
180: (p_action_code ='PUBLISH' AND l_approval_required = 'N') ) then
181: x_ret_code:= fnd_api.g_true;
182: ELSE
183: x_ret_code:= fnd_api.g_false;
184: END IF;
185: ELSIF (l_project_system_status_code = 'PROGRESS_REPORT_SUBMITTED' OR
186: l_project_system_status_code = 'PROGRESS_REPORT_REJECTED') then
187: IF ( p_action_code = 'REWORK' ) THEN

Line 188: x_ret_code:= fnd_api.g_true;

184: END IF;
185: ELSIF (l_project_system_status_code = 'PROGRESS_REPORT_SUBMITTED' OR
186: l_project_system_status_code = 'PROGRESS_REPORT_REJECTED') then
187: IF ( p_action_code = 'REWORK' ) THEN
188: x_ret_code:= fnd_api.g_true;
189: ELSE
190: x_ret_code:= fnd_api.g_false;
191: END IF;
192: ELSIF (l_project_system_status_code = 'PROGRESS_REPORT_APPROVED') THEN

Line 190: x_ret_code:= fnd_api.g_false;

186: l_project_system_status_code = 'PROGRESS_REPORT_REJECTED') then
187: IF ( p_action_code = 'REWORK' ) THEN
188: x_ret_code:= fnd_api.g_true;
189: ELSE
190: x_ret_code:= fnd_api.g_false;
191: END IF;
192: ELSIF (l_project_system_status_code = 'PROGRESS_REPORT_APPROVED') THEN
193: IF ( (p_action_code ='REWORK' ) OR
194: (p_action_code ='PUBLISH' AND l_auto_publish = 'N') ) then

Line 195: x_ret_code:= fnd_api.g_true;

191: END IF;
192: ELSIF (l_project_system_status_code = 'PROGRESS_REPORT_APPROVED') THEN
193: IF ( (p_action_code ='REWORK' ) OR
194: (p_action_code ='PUBLISH' AND l_auto_publish = 'N') ) then
195: x_ret_code:= fnd_api.g_true;
196: ELSE
197: x_ret_code:= fnd_api.g_false;
198: END IF;
199: ELSIF (l_project_system_status_code = 'PROGRESS_REPORT_PUBLISHED') THEN

Line 197: x_ret_code:= fnd_api.g_false;

193: IF ( (p_action_code ='REWORK' ) OR
194: (p_action_code ='PUBLISH' AND l_auto_publish = 'N') ) then
195: x_ret_code:= fnd_api.g_true;
196: ELSE
197: x_ret_code:= fnd_api.g_false;
198: END IF;
199: ELSIF (l_project_system_status_code = 'PROGRESS_REPORT_PUBLISHED') THEN
200: IF ( p_action_code ='CANCEL') then
201: x_ret_code:= fnd_api.g_true;

Line 201: x_ret_code:= fnd_api.g_true;

197: x_ret_code:= fnd_api.g_false;
198: END IF;
199: ELSIF (l_project_system_status_code = 'PROGRESS_REPORT_PUBLISHED') THEN
200: IF ( p_action_code ='CANCEL') then
201: x_ret_code:= fnd_api.g_true;
202: ELSE
203: x_ret_code:= fnd_api.g_false;
204: END IF;
205: ELSIF (l_project_system_status_code = 'PROGRESS_REPORT_CANCELED') THEN

Line 203: x_ret_code:= fnd_api.g_false;

199: ELSIF (l_project_system_status_code = 'PROGRESS_REPORT_PUBLISHED') THEN
200: IF ( p_action_code ='CANCEL') then
201: x_ret_code:= fnd_api.g_true;
202: ELSE
203: x_ret_code:= fnd_api.g_false;
204: END IF;
205: ELSIF (l_project_system_status_code = 'PROGRESS_REPORT_CANCELED') THEN
206: x_ret_code:= fnd_api.g_false;
207: END IF;

Line 206: x_ret_code:= fnd_api.g_false;

202: ELSE
203: x_ret_code:= fnd_api.g_false;
204: END IF;
205: ELSIF (l_project_system_status_code = 'PROGRESS_REPORT_CANCELED') THEN
206: x_ret_code:= fnd_api.g_false;
207: END IF;
208: return x_ret_code;
209: EXCEPTION
210: WHEN OTHERS THEN

Line 215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

211: -- Set the excetption Message and the stack
212: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_UTILS_PKG'
213: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
214: --
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: x_ret_code:= fnd_api.g_false;
217: return x_ret_code;
218: --RAISE; -- This is optional depending on the needs
219: END check_action_allowed;

Line 216: x_ret_code:= fnd_api.g_false;

212: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_UTILS_PKG'
213: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
214: --
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: x_ret_code:= fnd_api.g_false;
217: return x_ret_code;
218: --RAISE; -- This is optional depending on the needs
219: END check_action_allowed;
220:

Line 236: x_return_status := FND_API.G_RET_STS_SUCCESS;

232: x_msg_data OUT NOCOPY Varchar2) is --File.Sql.39 bug 4440895
233: l_msg_index_out Number;
234:
235: begin
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237: x_msg_count := 0;
238: FND_MSG_PUB.initialize;
239:
240: if p_estimated_ed_date < p_estimated_st_date then

Line 243: x_return_status := FND_API.G_RET_STS_ERROR;

239:
240: if p_estimated_ed_date < p_estimated_st_date then
241: PA_UTILS.Add_Message( p_app_short_name => 'PA'
242: ,p_msg_name => 'PA_EST_DATES_INV');
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: end if;
245:
246: if p_actual_ed_date < p_actual_st_date then
247: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 249: x_return_status := FND_API.G_RET_STS_ERROR;

245:
246: if p_actual_ed_date < p_actual_st_date then
247: PA_UTILS.Add_Message( p_app_short_name => 'PA'
248: ,p_msg_name => 'PA_ACT_DATES_INV');
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: end if;
251:
252: -- if actual dates are given estimated are not required
253:

Line 257: x_return_status := FND_API.G_RET_STS_ERROR;

253:
254: /* if p_estimated_st_date > get_earliest_task_st_date(p_project_id) then
255: PA_UTILS.Add_Message( p_app_short_name => 'PA'
256: ,p_msg_name => 'PA_EST_ST_DATE_INV');
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: end if;
259:
260: if p_estimated_ed_date < get_latest_task_ed_date(p_project_id) then
261: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 263: x_return_status := FND_API.G_RET_STS_ERROR;

259:
260: if p_estimated_ed_date < get_latest_task_ed_date(p_project_id) then
261: PA_UTILS.Add_Message( p_app_short_name => 'PA'
262: ,p_msg_name => 'PA_EST_ED_DATE_INV');
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: end if;
265:
266: if p_actual_st_date > get_earliest_task_st_date(p_project_id) then
267: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 269: x_return_status := FND_API.G_RET_STS_ERROR;

265:
266: if p_actual_st_date > get_earliest_task_st_date(p_project_id) then
267: PA_UTILS.Add_Message( p_app_short_name => 'PA'
268: ,p_msg_name => 'PA_ACT_ST_DATE_INV');
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: end if;
271:
272: if p_actual_ed_date < get_latest_task_ed_date(p_project_id) then
273: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 275: x_return_status := FND_API.G_RET_STS_ERROR;

271:
272: if p_actual_ed_date < get_latest_task_ed_date(p_project_id) then
273: PA_UTILS.Add_Message( p_app_short_name => 'PA'
274: ,p_msg_name => 'PA_ACT_ED_DATE_INV');
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: end if;
277: */
278:
279: if not (p_percent_complete between 0 and 100) then

Line 282: x_return_status := FND_API.G_RET_STS_ERROR;

278:
279: if not (p_percent_complete between 0 and 100) then
280: PA_UTILS.Add_Message( p_app_short_name => 'PA'
281: ,p_msg_name => 'PA_PERC_COMP_INV');
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: end if;
284:
285: if (p_est_to_complete < 0) then
286: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 288: x_return_status := FND_API.G_RET_STS_ERROR;

284:
285: if (p_est_to_complete < 0) then
286: PA_UTILS.Add_Message( p_app_short_name => 'PA'
287: ,p_msg_name => 'PA_EST_TO_COMP_INV');
288: x_return_status := FND_API.G_RET_STS_ERROR;
289:
290: end if;
291:
292: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 294: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

290: end if;
291:
292: x_msg_count := FND_MSG_PUB.Count_Msg;
293: IF x_msg_count = 1 THEN
294: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
295: ,p_msg_index => 1
296: ,p_data => x_msg_data
297: ,p_msg_index_out => l_msg_index_out
298: );

Line 346: IF FND_API.TO_BOOLEAN( fnd_api.g_true ) THEN

342:
343: BEGIN
344:
345: --Clear the global PL/SQL message table
346: IF FND_API.TO_BOOLEAN( fnd_api.g_true ) THEN
347: FND_MSG_PUB.initialize;
348: END IF;
349:
350: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 350: x_return_status := FND_API.G_RET_STS_SUCCESS;

346: IF FND_API.TO_BOOLEAN( fnd_api.g_true ) THEN
347: FND_MSG_PUB.initialize;
348: END IF;
349:
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351: -- Check it is a seeded template
352: if (p_page_id < 1000) then
353: l_ok_to_delete := 'N';
354:

Line 404: x_return_status := FND_API.G_RET_STS_ERROR;

400:
401: IF (l_ok_to_delete = 'N') then
402: PA_UTILS.Add_Message( p_app_short_name => 'PA'
403: ,p_msg_name => 'PA_EDIT_TEMPLATE_INV');
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: x_msg_count := FND_MSG_PUB.Count_Msg;
406: IF x_msg_count = 1 then
407: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
408: ,p_msg_index => 1

Line 407: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

403: ,p_msg_name => 'PA_EDIT_TEMPLATE_INV');
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: x_msg_count := FND_MSG_PUB.Count_Msg;
406: IF x_msg_count = 1 then
407: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
408: ,p_msg_index => 1
409: ,p_data => x_msg_data
410: ,p_msg_index_out => l_msg_index_out
411: );

Line 444: x_return_status := FND_API.G_RET_STS_SUCCESS;

440: -- Initialize the Error Stack
441: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_UTILS.update_perccomplete');
442:
443: -- Initialize the return status to success
444: x_return_status := FND_API.G_RET_STS_SUCCESS;
445:
446: SAVEPOINT update_perccomplete;
447:
448: --debug_msg( 'p_object_id' || To_char(p_object_id));

Line 467: ,p_msg_name => 'PA_PR_PERCENT_COMPLETE_INV'); x_return_status := FND_API.G_RET_STS_ERROR;

463:
464:
465: IF (p_percent_complete > 100 or p_percent_complete< 0 )THEN
466: PA_UTILS.Add_Message( p_app_short_name => 'PA'
467: ,p_msg_name => 'PA_PR_PERCENT_COMPLETE_INV'); x_return_status := FND_API.G_RET_STS_ERROR;
468:
469: ELSE
470: -- todo
471:

Line 496: IF (x_return_status <> FND_API.g_ret_sts_success) THEN

492:
493: --debug_msg ('before get_percent_complete 3' );
494: END IF;
495:
496: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
497:
498: ROLLBACK TO update_perccomplete;
499: RETURN;
500: END IF;

Line 511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

507: -- Set the excetption Message and the stack
508: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_Progress_Report_Utils.update_perccomplete'
509: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
510: --
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
512: RAISE; -- This is optional depending on the needs
513:
514:
515: END update_perccomplete;

Line 618: x_return_status := FND_API.G_RET_STS_SUCCESS;

614: -- Initialize the Error Stack
615: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_UTILS.remove_progress_report_setup');
616:
617: -- Initialize the return status to success
618: x_return_status := FND_API.G_RET_STS_SUCCESS;
619:
620: SAVEPOINT remove_progress_report_setup;
621:
622: pa_progress_report_pkg.delete_object_page_layouts

Line 632: IF (x_return_status <> FND_API.g_ret_sts_success) THEN

628: x_msg_count,
629: x_msg_data
630: );
631:
632: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
633:
634: ROLLBACK TO remove_progress_report_setup;
635: RETURN;
636: END IF;

Line 647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

643: -- Set the excetption Message and the stack
644: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_Progress_Report_Utils.remove_progress_report_setup'
645: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
646: --
647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
648: RAISE; -- This is optional depending on the needs
649:
650: END remove_progress_report_setup;
651:

Line 1167: x_return_status := FND_API.G_RET_STS_SUCCESS;

1163: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1164: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1165: IS
1166: BEGIN
1167: x_return_status := FND_API.G_RET_STS_SUCCESS;
1168: x_msg_count := 0;
1169: x_msg_data := NULL;
1170: END copy_project_tab_menu;
1171: