eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJ_STAT_ACTSET dependencies on PA_PROJ_STAT_ACTSET

Line 1: PACKAGE BODY PA_PROJ_STAT_ACTSET AS

1: PACKAGE BODY PA_PROJ_STAT_ACTSET AS
2: --$Header: PAASPSB.pls 115.18 2003/04/08 18:46:59 mwasowic noship $
3:
4:
5: PROCEDURE process_action_set (

Line 21: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.process_action_set');

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

Line 23: ,x_Msg => 'in PA_PROJ_STAT_ACTSET.process_action_set'

19: BEGIN
20: --initialize error stack
21: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.process_action_set');
22: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_APROJ_STAT_ACTSET.process_action_set.begin'
23: ,x_Msg => 'in PA_PROJ_STAT_ACTSET.process_action_set'
24: ,x_Log_Level => 6);
25:
26:
27: --initialize return status

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

31: IF p_action_set_id is NULL THEN
32: --PA_UTILS.Add_Message (p_app_short_name => 'PA'
33: -- ,p_msg_name => 'PA_NULL_ACTION_SET_ID');
34: --x_return_status := 'E';
35: --dbms_output.put_line('IN pa_proj_stat_actset.process_action_set, p_action_set_id is NULL');
36: return;
37: END IF;
38:
39:

Line 89: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJ_STAT_ACTSET.process_action_set'

85: -- Put any message text from message stack into the Message ARRAY
86: EXCEPTION
87: WHEN OTHERS THEN
88: -- Set the excetption Message and the stack
89: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJ_STAT_ACTSET.process_action_set'
90: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
92: RAISE;
93:

Line 120: l_api_name VARCHAR2(30) := 'PA_PROJ_STAT_ACTSET';

116: AND l.object_id = p.project_id;
117:
118: cp_rpt_info c_report_info%ROWTYPE;
119:
120: l_api_name VARCHAR2(30) := 'PA_PROJ_STAT_ACTSET';
121: l_project_id pa_projects_all.project_id%TYPE;
122: l_report_type_id pa_object_page_layouts.object_page_layout_id%TYPE;
123: l_report_date pa_object_page_layouts.next_reporting_date%TYPE;
124: l_project_status pa_projects_all.project_status_code%TYPE;

Line 138: pa_debug.init_err_stack('PA_PROJ_STAT_ACTSET:perform_action_set_line');

134:
135:
136: BEGIN
137:
138: pa_debug.init_err_stack('PA_PROJ_STAT_ACTSET:perform_action_set_line');
139: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED ;
140: g_action_line_audit_tbl.DELETE;
141:
142: if validate_action_type_code(p_action_set_type_code) = FALSE then

Line 225: x_action_line_audit_tbl := PA_PROJ_STAT_ACTSET.g_action_line_audit_tbl;

221: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_ACTIVE;
222: else
223: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_COMPLETE;
224: end if;
225: x_action_line_audit_tbl := PA_PROJ_STAT_ACTSET.g_action_line_audit_tbl;
226:
227: else
228: if nvl(l_msg_count,0) > 0 then
229: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED ;

Line 239: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJ_STAT_ACTSET.perform_action_set_line'

235:
236:
237: EXCEPTION
238: WHEN OTHERS THEN
239: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJ_STAT_ACTSET.perform_action_set_line'
240: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
241: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED;
242: RAISE;
243:

Line 425: --FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_proj_stat_actset.perform_selected_action'

421: WHEN OTHERS THEN
422: RAISE;
423:
424: -- Set the exception Message and the stack
425: --FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_proj_stat_actset.perform_selected_action'
426: -- ,p_procedure_name => PA_DEBUG.G_Err_Stack );
427: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: -- x_msg_count := 1;
429: -- x_msg_data := substr(SQLERRM,1,2000);

Line 482: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.copy_action_sets');

478:
479: BEGIN
480:
481: x_return_status := fnd_api.g_ret_sts_success;
482: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.copy_action_sets');
483: savepoint copy_proj_action_sets;
484:
485:
486: FOR c_action_set_rec in c_action_set_ids LOOP

Line 524: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_proj_stat_actset.copy_action_sets'

520: EXCEPTION
521: WHEN OTHERS THEN
522: ROLLBACK TO copy_proj_action_sets;
523: -- Set the exception Message and the stack
524: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_proj_stat_actset.copy_action_sets'
525: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
527: RAISE;
528:

Line 566: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.delete_action_set');

562: l_action_set_id NUMBER;
563: cp_action_set_info c_action_set_info%ROWTYPE;
564:
565: BEGIN
566: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.delete_action_set');
567: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_PROJ_STAT_ACTSET.delete_action_set.begin'
568: ,x_Msg => 'in PA_PROJ_STAT_ACTSET.delete_action_set'
569: ,x_Log_Level => 6);
570:

Line 567: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_PROJ_STAT_ACTSET.delete_action_set.begin'

563: cp_action_set_info c_action_set_info%ROWTYPE;
564:
565: BEGIN
566: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.delete_action_set');
567: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_PROJ_STAT_ACTSET.delete_action_set.begin'
568: ,x_Msg => 'in PA_PROJ_STAT_ACTSET.delete_action_set'
569: ,x_Log_Level => 6);
570:
571: x_return_status := 'S';

Line 568: ,x_Msg => 'in PA_PROJ_STAT_ACTSET.delete_action_set'

564:
565: BEGIN
566: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.delete_action_set');
567: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_PROJ_STAT_ACTSET.delete_action_set.begin'
568: ,x_Msg => 'in PA_PROJ_STAT_ACTSET.delete_action_set'
569: ,x_Log_Level => 6);
570:
571: x_return_status := 'S';
572: l_action_set_id := p_action_set_id;

Line 614: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJ_STAT_ACTSET.delete_action_set'

610:
611: EXCEPTION
612:
613: WHEN OTHERS THEN
614: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJ_STAT_ACTSET.delete_action_set'
615: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
616:
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
618: RAISE;

Line 655: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.update_action_set');

651: l_new_action_set_id NUMBER := NULL;
652:
653:
654: BEGIN
655: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.update_action_set');
656: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_PROJ_STAT_ACTSET.update_action_set.begin'
657: ,x_Msg => 'in PA_PROJ_STAT_ACTSET.update_action_set'
658: ,x_Log_Level => 6);
659:

Line 656: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_PROJ_STAT_ACTSET.update_action_set.begin'

652:
653:
654: BEGIN
655: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.update_action_set');
656: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_PROJ_STAT_ACTSET.update_action_set.begin'
657: ,x_Msg => 'in PA_PROJ_STAT_ACTSET.update_action_set'
658: ,x_Log_Level => 6);
659:
660: x_return_status := 'S';

Line 657: ,x_Msg => 'in PA_PROJ_STAT_ACTSET.update_action_set'

653:
654: BEGIN
655: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.update_action_set');
656: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_PROJ_STAT_ACTSET.update_action_set.begin'
657: ,x_Msg => 'in PA_PROJ_STAT_ACTSET.update_action_set'
658: ,x_Log_Level => 6);
659:
660: x_return_status := 'S';
661: --l_record_version_number := p_record_version_number;

Line 741: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJ_STAT_ACTSET.update_action_set'

737:
738: EXCEPTION
739:
740: WHEN OTHERS THEN
741: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJ_STAT_ACTSET.update_action_set'
742: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
743:
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
745: RAISE;