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_TASK_PROG_ACTSET dependencies on PA_TASK_PROG_ACTSET

Line 1: PACKAGE BODY PA_TASK_PROG_ACTSET AS

1: PACKAGE BODY PA_TASK_PROG_ACTSET AS
2: --$Header: PAASTPB.pls 115.15 2003/04/08 18:46:36 mwasowic noship $
3:
4:
5:

Line 20: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.process_action_set');

16: l_return_status VARCHAR2(1):= 'S';
17: l_loop_cnt NUMBER;
18:
19: BEGIN
20: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.process_action_set');
21: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.process_action_set.begin'
22: ,x_Msg => 'in PA_TASK_PROG_ACTSET.process_action_set'
23: ,x_Log_Level => 6);
24:

Line 21: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.process_action_set.begin'

17: l_loop_cnt NUMBER;
18:
19: BEGIN
20: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.process_action_set');
21: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.process_action_set.begin'
22: ,x_Msg => 'in PA_TASK_PROG_ACTSET.process_action_set'
23: ,x_Log_Level => 6);
24:
25: --initialize return status

Line 22: ,x_Msg => 'in PA_TASK_PROG_ACTSET.process_action_set'

18:
19: BEGIN
20: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.process_action_set');
21: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.process_action_set.begin'
22: ,x_Msg => 'in PA_TASK_PROG_ACTSET.process_action_set'
23: ,x_Log_Level => 6);
24:
25: --initialize return status
26: x_return_status := l_return_status;

Line 33: --dbms_output.put_line('IN pa_task_prog_actset.process_action_set, p_action_set_id is NULL');

29: IF p_action_set_id is NULL THEN
30: --PA_UTILS.Add_Message (p_app_short_name => 'PA'
31: -- ,p_msg_name => 'PA_NULL_ACTION_SET_ID');
32: --x_return_status := 'E';
33: --dbms_output.put_line('IN pa_task_prog_actset.process_action_set, p_action_set_id is NULL');
34: return;
35: END IF;
36:
37: -- get all action lines and conditions of the object

Line 81: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.process_action_set'

77: -- Put any message text from message stack into the Message ARRAY
78: EXCEPTION
79: WHEN OTHERS THEN
80: -- Set the excetption Message and the stack
81: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.process_action_set'
82: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
84: RAISE;
85:

Line 103: l_api_name VARCHAR2(30) := 'PA_TASK_PROG_ACTSET';

99: FROM pa_projects_all p
100: WHERE p.project_id = cp_project_id;
101:
102: cp_proj_info c_proj_info%ROWTYPE;
103: l_api_name VARCHAR2(30) := 'PA_TASK_PROG_ACTSET';
104: l_project_id NUMBER;
105: l_proj_start_date DATE;
106: l_project_status VARCHAR2(30);
107: l_action_is_repeating BOOLEAN := TRUE;

Line 113: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.process_action_set');

109: l_msg_count NUMBER := 0;
110: l_msg_data VARCHAR2(2000);
111:
112: BEGIN
113: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.process_action_set');
114: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.perform_action_set_line.begin'
115: ,x_Msg => 'in PA_TASK_PROG_ACTSET.perform_action_set_line'
116: ,x_Log_Level => 6);
117:

Line 114: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.perform_action_set_line.begin'

110: l_msg_data VARCHAR2(2000);
111:
112: BEGIN
113: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.process_action_set');
114: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.perform_action_set_line.begin'
115: ,x_Msg => 'in PA_TASK_PROG_ACTSET.perform_action_set_line'
116: ,x_Log_Level => 6);
117:
118: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED ;

Line 115: ,x_Msg => 'in PA_TASK_PROG_ACTSET.perform_action_set_line'

111:
112: BEGIN
113: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.process_action_set');
114: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.perform_action_set_line.begin'
115: ,x_Msg => 'in PA_TASK_PROG_ACTSET.perform_action_set_line'
116: ,x_Log_Level => 6);
117:
118: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED ;
119:

Line 177: --x_action_line_audit_tbl := PA_TASK_PROG_ACTSET.g_action_line_audit_tbl;

173: x_action_line_audit_tbl => x_action_line_audit_tbl,
174: x_return_status => l_return_status,
175: x_msg_count => l_msg_count,
176: x_msg_data => l_msg_data);
177: --x_action_line_audit_tbl := PA_TASK_PROG_ACTSET.g_action_line_audit_tbl;
178: l_action_is_repeating := is_action_repeating(p_action_line_conditions_tbl);
179: if (l_action_is_repeating) then
180: /*Don't set the staus to "Complete", it's a repeating action */
181: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_ACTIVE;

Line 192: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.peform_action_set_line'

188: return;
189: EXCEPTION
190: WHEN OTHERS THEN
191: -- Set the excetption Message and the stack
192: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.peform_action_set_line'
193: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
194: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED;
195: RAISE;
196:

Line 227: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.action_allowed_for_status');

223: IS
224: --l_project_status VARCHAR2(30);--mwxx REMOVE!!!
225: BEGIN
226:
227: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.action_allowed_for_status');
228: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.action_allowed_for_status.begin'
229: ,x_Msg => 'in PA_TASK_PROG_ACTSET.action_allowed_for_status'
230: ,x_Log_Level => 6);
231:

Line 228: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.action_allowed_for_status.begin'

224: --l_project_status VARCHAR2(30);--mwxx REMOVE!!!
225: BEGIN
226:
227: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.action_allowed_for_status');
228: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.action_allowed_for_status.begin'
229: ,x_Msg => 'in PA_TASK_PROG_ACTSET.action_allowed_for_status'
230: ,x_Log_Level => 6);
231:
232: --l_project_status := 'APPROVED'; --mwxx REMOVE!!!

Line 229: ,x_Msg => 'in PA_TASK_PROG_ACTSET.action_allowed_for_status'

225: BEGIN
226:
227: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.action_allowed_for_status');
228: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.action_allowed_for_status.begin'
229: ,x_Msg => 'in PA_TASK_PROG_ACTSET.action_allowed_for_status'
230: ,x_Log_Level => 6);
231:
232: --l_project_status := 'APPROVED'; --mwxx REMOVE!!!
233: if PA_PROJECT_UTILS.check_prj_stus_action_allowed

Line 246: -- FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.action_allowed_for_status'

242: EXCEPTION
243: WHEN OTHERS THEN
244: RAISE;
245:
246: -- FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.action_allowed_for_status'
247: -- ,p_procedure_name => PA_DEBUG.G_Err_Stack );
248:
249: END action_allowed_for_status;
250: /*----------------------------------------------------------------------------------*/

Line 269: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.ok_to_perform_action');

265:
266: cp_proj_date c_proj_date%ROWTYPE;
267: BEGIN
268:
269: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.ok_to_perform_action');
270: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.ok_to_perform_action.begin'
271: ,x_Msg => 'in PA_TASK_PROG_ACTSET.ok_to_perform_action'
272: ,x_Log_Level => 6);
273:

Line 270: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.ok_to_perform_action.begin'

266: cp_proj_date c_proj_date%ROWTYPE;
267: BEGIN
268:
269: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.ok_to_perform_action');
270: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.ok_to_perform_action.begin'
271: ,x_Msg => 'in PA_TASK_PROG_ACTSET.ok_to_perform_action'
272: ,x_Log_Level => 6);
273:
274:

Line 271: ,x_Msg => 'in PA_TASK_PROG_ACTSET.ok_to_perform_action'

267: BEGIN
268:
269: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.ok_to_perform_action');
270: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.ok_to_perform_action.begin'
271: ,x_Msg => 'in PA_TASK_PROG_ACTSET.ok_to_perform_action'
272: ,x_Log_Level => 6);
273:
274:
275: if (TRUNC(p_proj_start_date) > l_sysdate) then

Line 295: --FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.ok_to_perform_action'

291: WHEN OTHERS THEN
292: RAISE;
293:
294: -- Set the excetption Message and the stack
295: --FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.ok_to_perform_action'
296: -- ,p_procedure_name => PA_DEBUG.G_Err_Stack );
297:
298: END ok_to_perform_action;
299: /*-----------------------------------------------------------------------------*/

Line 340: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.copy_action_sets');

336:
337: BEGIN
338: x_return_status := fnd_api.g_ret_sts_success;
339:
340: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.copy_action_sets');
341: savepoint copy_task_action_sets;
342:
343:
344: OPEN task_reminder_action_set;

Line 374: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_task_prog_actset.copy_action_sets'

370: EXCEPTION
371: WHEN TOO_MANY_ROWS THEN
372: ROLLBACK TO copy_task_action_sets;
373: -- Set the exception Message and the stack
374: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_task_prog_actset.copy_action_sets'
375: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
377: RAISE;
378:

Line 382: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_task_prog_actset.copy_action_sets'

378:
379: WHEN OTHERS THEN
380: ROLLBACK TO copy_task_action_sets;
381: -- Set the exception Message and the stack
382: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_task_prog_actset.copy_action_sets'
383: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: RAISE;
386:

Line 411: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.delete_action_set');

407: l_msg_data VARCHAR2(2000);
408: l_record_version_number NUMBER;
409:
410: BEGIN
411: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.delete_action_set');
412: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.delete_action_set.begin'
413: ,x_Msg => 'in PA_TASK_PROG_ACTSET.delete_action_set'
414: ,x_Log_Level => 6);
415:

Line 412: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.delete_action_set.begin'

408: l_record_version_number NUMBER;
409:
410: BEGIN
411: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.delete_action_set');
412: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.delete_action_set.begin'
413: ,x_Msg => 'in PA_TASK_PROG_ACTSET.delete_action_set'
414: ,x_Log_Level => 6);
415:
416: l_record_version_number := p_record_version_number;

Line 413: ,x_Msg => 'in PA_TASK_PROG_ACTSET.delete_action_set'

409:
410: BEGIN
411: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.delete_action_set');
412: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.delete_action_set.begin'
413: ,x_Msg => 'in PA_TASK_PROG_ACTSET.delete_action_set'
414: ,x_Log_Level => 6);
415:
416: l_record_version_number := p_record_version_number;
417: IF l_record_version_number is NULL THEN

Line 448: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.delete_action_set'

444:
445: EXCEPTION
446:
447: WHEN OTHERS THEN
448: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.delete_action_set'
449: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
450:
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
452: RAISE;

Line 495: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.update_action_set.begin'

491:
492:
493: BEGIN
494: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.update_action_set');
495: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.update_action_set.begin'
496: ,x_Msg => 'in PA_TASK_PROG_ACTSET.update_action_set'
497: ,x_Log_Level => 6);
498:
499: x_return_status := 'S';

Line 496: ,x_Msg => 'in PA_TASK_PROG_ACTSET.update_action_set'

492:
493: BEGIN
494: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.update_action_set');
495: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.update_action_set.begin'
496: ,x_Msg => 'in PA_TASK_PROG_ACTSET.update_action_set'
497: ,x_Log_Level => 6);
498:
499: x_return_status := 'S';
500: l_record_version_number := p_record_version_number;

Line 597: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.update_action_set'

593:
594: EXCEPTION
595:
596: WHEN OTHERS THEN
597: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.update_action_set'
598: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
599:
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
601: RAISE;