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_TEAM_TEMPLATES_PVT dependencies on PA_DEBUG

Line 4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1: PACKAGE BODY pa_team_templates_pvt AS
2: /*$Header: PARTPVTB.pls 120.1 2005/08/19 17:01:20 mwasowic noship $*/
3: --
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: PROCEDURE Start_Apply_Team_Template_WF
6: (p_team_template_id_tbl IN PA_TEAM_TEMPLATES_PUB.team_template_id_tbl
7: ,p_project_id IN pa_projects_all.project_id%TYPE
8: ,p_project_start_date IN pa_projects_all.start_date%TYPE

Line 185: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

181: wf_engine.threshold := l_save_threshold;
182:
183: -- Set the excetption Message and the stack
184: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PVT.Apply_Team_Template'
185: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
186: --
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
188: RAISE;
189:

Line 344: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

340:
341: WHEN OTHERS THEN
342: -- Set the excetption Message and the stack
343: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PVT.Apply_Team_Template'
344: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
345: RAISE;
346:
347:
348: END Apply_Team_Template_WF;

Line 451: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PVT.Apply_Team_Template');

447:
448: BEGIN
449:
450: -- Initialize the Error Stack
451: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PVT.Apply_Team_Template');
452:
453: -- Initialize the return status to success
454: x_return_status := FND_API.G_RET_STS_SUCCESS;
455:

Line 463: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PVT.apply_team_template'

459: END IF;
460:
461: --Log Message
462: IF (P_DEBUG_MODE ='Y') THEN
463: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PVT.apply_team_template'
464: ,x_msg => 'Beginning of Apply_Team_Template'
465: ,x_log_level => 5);
466: END IF;
467:

Line 706: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

702: END IF;
703:
704: -- Set the excetption Message and the stack
705: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PVT.Apply_Team_Template'
706: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
707: --
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
709: RAISE;
710:

Line 731: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_PVT.Create_Team_Template');

727:
728: BEGIN
729:
730: -- Initialize the Error Stack
731: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_PVT.Create_Team_Template');
732:
733: --Log Message
734: IF (P_DEBUG_MODE ='Y') THEN
735: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PVT.Create_Team_Template.begin'

Line 735: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PVT.Create_Team_Template.begin'

731: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_PVT.Create_Team_Template');
732:
733: --Log Message
734: IF (P_DEBUG_MODE ='Y') THEN
735: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PVT.Create_Team_Template.begin'
736: ,x_msg => 'Beginning of the PVT Create_Team_Template'
737: ,x_log_level => 5);
738: END IF;
739:

Line 770: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATE_PVT.Create_Team_Template.calling_insert_row'

766:
767: --If no validation errors then insert the team template.
768: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg = 0 THEN
769: IF (P_DEBUG_MODE ='Y') THEN
770: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATE_PVT.Create_Team_Template.calling_insert_row'
771: ,x_msg => 'calling pa_team_templates.insert_row.'
772: ,x_log_level => 5);
773: END IF;
774:

Line 797: PA_DEBUG.Reset_Err_Stack;

793: COMMIT;
794: END IF;
795:
796: -- Reset the error stack when returning to the calling program
797: PA_DEBUG.Reset_Err_Stack;
798:
799: -- If any errors exist then set the x_return_status to 'E'
800:
801: IF l_msg_count>0 THEN

Line 816: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

812: END IF;
813: --
814: -- Set the excetption Message and the stack
815: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATE_PVT.Create_Team_Template'
816: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
817: --
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
819: RAISE;
820:

Line 838: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_PVT.Update_Team_Template');

834:
835: BEGIN
836:
837: -- Initialize the Error Stack
838: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_PVT.Update_Team_Template');
839:
840: --Log Message
841: IF (P_DEBUG_MODE ='Y') THEN
842: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PVT.Update_Team_Template.begin'

Line 842: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PVT.Update_Team_Template.begin'

838: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_PVT.Update_Team_Template');
839:
840: --Log Message
841: IF (P_DEBUG_MODE ='Y') THEN
842: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PVT.Update_Team_Template.begin'
843: ,x_msg => 'Beginning of the PVT Update_Team_Template'
844: ,x_log_level => 5);
845: END IF;
846:

Line 866: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATE_PVT.Update_Team_Template.calling_update_row'

862:
863: --If no validation errors then insert the team template.
864: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg = 0 THEN
865: IF (P_DEBUG_MODE ='Y') THEN
866: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATE_PVT.Update_Team_Template.calling_update_row'
867: ,x_msg => 'calling pa_team_templates.update_row.'
868: ,x_log_level => 5);
869: END IF;
870:

Line 895: PA_DEBUG.Reset_Err_Stack;

891: COMMIT;
892: END IF;
893:
894: -- Reset the error stack when returning to the calling program
895: PA_DEBUG.Reset_Err_Stack;
896:
897: -- If any errors exist then set the x_return_status to 'E'
898:
899: IF l_msg_count>0 THEN

Line 914: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

910: END IF;
911: --
912: -- Set the excetption Message and the stack
913: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATE_PVT.Update_Team_Template'
914: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
915: --
916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
917: RAISE;
918:

Line 951: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATE_PVT.Delete_Assignment');

947:
948: BEGIN
949:
950: -- Initialize the Error Stack
951: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATE_PVT.Delete_Assignment');
952:
953: -- Initialize the return status to success
954: x_return_status := FND_API.G_RET_STS_SUCCESS;
955:

Line 963: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATE_PVT.Delete_Team_Template.begin'

959: END IF;
960:
961: --Log Message
962: IF (P_DEBUG_MODE ='Y') THEN
963: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATE_PVT.Delete_Team_Template.begin'
964: ,x_msg => 'Beginning of Delete Team Template PVT.'
965: ,x_log_level => 5);
966: END IF;
967:

Line 985: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATE_PVT.Delete_Team_Template'

981:
982: --delete the subteams belonging to this team template
983: --Log Message
984: IF (P_DEBUG_MODE ='Y') THEN
985: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATE_PVT.Delete_Team_Template'
986: ,x_msg => 'calling delete subteam'
987: ,x_log_level => 5);
988: END IF;
989: --don't pass subteam id and this API will delete all subteams belonging to the

Line 1003: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATE_PVT.Delete_Team_Template'

999:
1000: --delete the template requirements
1001: --Log Message
1002: IF (P_DEBUG_MODE ='Y') THEN
1003: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATE_PVT.Delete_Team_Template'
1004: ,x_msg => 'calling delete assignment (template req)'
1005: ,x_log_level => 5);
1006: END IF;
1007: FOR l_template_requirements IN get_template_req_details LOOP

Line 1026: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATE_PVT.Delete_Team_Template'

1022: --delete the team template header
1023:
1024: --Log Message
1025: IF (P_DEBUG_MODE ='Y') THEN
1026: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATE_PVT.Delete_Team_Template'
1027: ,x_msg => 'calling delete_row'
1028: ,x_log_level => 5);
1029: END IF;
1030: PA_TEAM_TEMPLATES_PKG.Delete_Row(p_team_template_id => p_team_template_id

Line 1053: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

1049: END IF;
1050:
1051: -- Set the excetption Message and the stack
1052: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATE_PVT.Delete_Team_Template'
1053: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1054: --
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056: RAISE;
1057: