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_PUB 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_pub AS
2: /*$Header: PARTPUBB.pls 120.2 2005/08/23 04:31:40 sunkalya noship $*/
3: --
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: PROCEDURE Execute_Apply_Team_Template
6: (p_team_template_id IN pa_team_templates.team_template_id%TYPE
7: ,p_project_id IN pa_projects_all.project_id%TYPE
8: ,p_project_start_date IN pa_projects_all.start_date%TYPE

Line 30: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Execute_Apply_Team_Template');

26:
27: BEGIN
28:
29: -- Initialize the Error Stack
30: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Execute_Apply_Team_Template');
31:
32: -- Initialize the return status to success
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34:

Line 47: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.execute_apply_team_template'

43: END IF;
44:
45: --Log Message
46: IF (P_DEBUG_MODE = 'Y') THEN
47: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.execute_apply_team_template'
48: ,x_msg => 'Beginning of Execute_Apply_Team_Template'
49: ,x_log_level => 5);
50: END IF;
51:

Line 64: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.execute_apply_team_template'

60: IF p_apply = 'Y' THEN
61:
62: --Log Message
63: IF (P_DEBUG_MODE = 'Y') THEN
64: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.execute_apply_team_template'
65: ,x_msg => 'Calling Apply_Team_Template'
66: ,x_log_level => 5);
67: END IF;
68:

Line 88: PA_DEBUG.Reset_Err_Stack;

84:
85: END IF; --p_apply='Y'
86:
87: -- Reset the error stack when returning to the calling program
88: PA_DEBUG.Reset_Err_Stack;
89:
90: EXCEPTION
91: WHEN OTHERS THEN
92:

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

98: END IF;
99:
100: -- Set the excetption Message and the stack
101: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PUB.Execute_Apply_Team_Template'
102: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
103: --
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
105: RAISE;
106:

Line 144: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Apply_Team_Template');

140:
141: BEGIN
142:
143: -- Initialize the Error Stack
144: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Apply_Team_Template');
145:
146: -- Initialize the return status to success
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:

Line 166: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.apply_team_template'

162: pa_assignment_utils.g_team_role_name_token := NULL;
163:
164: --Log Message
165: IF (P_DEBUG_MODE = 'Y') THEN
166: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.apply_team_template'
167: ,x_msg => 'Beginning of Apply_Team_Template'
168: ,x_log_level => 5);
169: END IF;
170:

Line 173: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.apply_team_template'

169: END IF;
170:
171: --call private API to apply the team template
172: IF (P_DEBUG_MODE = 'Y') THEN
173: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.apply_team_template'
174: ,x_msg => 'calling PA_TEAM_TEMPLATES_PVT.Apply_Team_Template'
175: ,x_log_level => 5);
176: END IF;
177:

Line 253: PA_DEBUG.Reset_Err_Stack;

249: END IF;
250:
251: -- Reset the error stack when returning to the calling program
252:
253: PA_DEBUG.Reset_Err_Stack;
254:
255: -- If errors exist then set the x_return_status to 'E'
256:
257: IF x_msg_count >0 THEN

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

283: END IF;
284:
285: -- Set the excetption Message and the stack
286: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PUB.Apply_Team_Template'
287: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
288: --
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
290: RAISE;
291:

Line 340: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Execute_Create_Team_Template');

336:
337: BEGIN
338:
339: -- Initialize the Error Stack
340: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Execute_Create_Team_Template');
341:
342: -- Initialize the return status to success
343: x_return_status := FND_API.G_RET_STS_SUCCESS;
344:

Line 357: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.execute_create_team_template.begin'

353: END IF;
354:
355: --Log Message
356: IF (P_DEBUG_MODE = 'Y') THEN
357: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.execute_create_team_template.begin'
358: ,x_msg => 'Beginning of Execute_Create_Team_Template'
359: ,x_log_level => 5);
360: END IF;
361:

Line 392: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.execute_create_team_template.begin'

388: l_team_template_rec.attribute15 := p_attribute15;
389:
390: --Log Message
391: IF (P_DEBUG_MODE = 'Y') THEN
392: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.execute_create_team_template.begin'
393: ,x_msg => 'Calling Create_Team_Template'
394: ,x_log_level => 5);
395: END IF;
396:

Line 414: PA_DEBUG.Reset_Err_Stack;

410: ,x_msg_data => x_msg_data);
411:
412:
413: -- Reset the error stack when returning to the calling program
414: PA_DEBUG.Reset_Err_Stack;
415:
416: EXCEPTION
417: WHEN OTHERS THEN
418: IF p_commit = FND_API.G_TRUE THEN

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

420: END IF;
421:
422: -- Set the excetption Message and the stack
423: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PUB.Execute_Create_Team_Template'
424: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
425: --
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
427: RAISE;
428:

Line 461: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Create_Team_Template');

457:
458: BEGIN
459:
460: -- Initialize the Error Stack
461: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Create_Team_Template');
462:
463: -- Initialize the return status to success
464: x_return_status := FND_API.G_RET_STS_SUCCESS;
465:

Line 478: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.Create_Team_Template.begin'

474: END IF;
475:
476: --Log Message
477: IF (P_DEBUG_MODE = 'Y') THEN
478: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.Create_Team_Template.begin'
479: ,x_msg => 'Beginning of Create_Team_Template'
480: ,x_log_level => 5);
481: END IF;
482:

Line 573: PA_DEBUG.Reset_Err_Stack;

569: END IF;
570:
571: -- Reset the error stack when returning to the calling program
572:
573: PA_DEBUG.Reset_Err_Stack;
574:
575: -- If errors exist then set the x_return_status to 'E'
576:
577: IF x_msg_count >0 THEN

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

594: ROLLBACK TO ASG_PUB_CREATE_TEAM_TEMPLATE;
595: END IF;
596: -- Set the excetption Message and the stack
597: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TEAM_TEMPLATES_PUB.Create_Team_Template'
598: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
599: --
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
601: RAISE;
602: --

Line 655: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Execute_Update_Team_Template');

651:
652: BEGIN
653:
654: -- Initialize the Error Stack
655: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Execute_Update_Team_Template');
656:
657: -- Initialize the return status to success
658: x_return_status := FND_API.G_RET_STS_SUCCESS;
659:

Line 672: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.execute_update_team_template.begin'

668: END IF;
669:
670: --Log Message
671: IF (P_DEBUG_MODE = 'Y') THEN
672: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.execute_update_team_template.begin'
673: ,x_msg => 'Beginning of Execute_Update_Team_Template'
674: ,x_log_level => 5);
675: END IF;
676:

Line 710: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.execute_create_team_template.before_calling_update_team_template'

706: l_team_template_rec.attribute15 := p_attribute15;
707:
708: --Log Message
709: IF (P_DEBUG_MODE = 'Y') THEN
710: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.execute_create_team_template.before_calling_update_team_template'
711: ,x_msg => 'Calling Update_Team_Template'
712: ,x_log_level => 5);
713: END IF;
714:

Line 731: PA_DEBUG.Reset_Err_Stack;

727: ,x_msg_data => x_msg_data);
728:
729:
730: -- Reset the error stack when returning to the calling program
731: PA_DEBUG.Reset_Err_Stack;
732:
733: EXCEPTION
734: WHEN OTHERS THEN
735: IF p_commit = FND_API.G_TRUE THEN

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

737: END IF;
738:
739: -- Set the excetption Message and the stack
740: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PUB.Execute_Update_Team_Template'
741: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
742: --
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
744: RAISE;
745:

Line 786: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Update_Team_Templates');

782:
783: BEGIN
784:
785: -- Initialize the Error Stack
786: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Update_Team_Templates');
787:
788: -- Initialize the return status to success
789: x_return_status := FND_API.G_RET_STS_SUCCESS;
790:

Line 803: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_Team_Teamplates_PUB.Update_Team_Template.begin'

799: END IF;
800:
801: --Log Message
802: IF (P_DEBUG_MODE = 'Y') THEN
803: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_Team_Teamplates_PUB.Update_Team_Template.begin'
804: ,x_msg => 'Beginning of Update_Team_Template'
805: ,x_log_level => 5);
806: END IF;
807:

Line 919: PA_DEBUG.Reset_Err_Stack;

915: END IF;
916:
917: -- Reset the error stack when returning to the calling program
918:
919: PA_DEBUG.Reset_Err_Stack;
920:
921: -- If errors exist then set the x_return_status to 'E'
922:
923: IF x_msg_count >0 THEN

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

939: ROLLBACK TO ASG_PUB_UPDATE_TEAM_TEMPLATE;
940: END IF;
941: -- Set the excetption Message and the stack
942: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TEAM_TEMPLATES_PUB.Update_Team_Template'
943: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
944: --
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
946: RAISE;
947: --

Line 978: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Delete_Team_Template');

974:
975: BEGIN
976:
977: -- Initialize the Error Stack
978: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Delete_Team_Template');
979:
980: -- Initialize the return status to success
981: x_return_status := FND_API.G_RET_STS_SUCCESS;
982:

Line 995: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_Team_Teamplates_PUB.Delete_Team_Template.begin'

991: END IF;
992:
993: --Log Message
994: IF (P_DEBUG_MODE = 'Y') THEN
995: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_Team_Teamplates_PUB.Delete_Team_Template.begin'
996: ,x_msg => 'Beginning of Delete_Team_Template'
997: ,x_log_level => 5);
998: END IF;
999:

Line 1020: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_Team_Teamplates_PUB.Delete_Team_Template.calling_pvt'

1016: ELSE
1017:
1018: --Log Message
1019: IF (P_DEBUG_MODE = 'Y') THEN
1020: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_Team_Teamplates_PUB.Delete_Team_Template.calling_pvt'
1021: ,x_msg => 'Calling delete team template pvt'
1022: ,x_log_level => 5);
1023: END IF;
1024:

Line 1047: PA_DEBUG.Reset_Err_Stack;

1043: );
1044: END IF;
1045:
1046: -- Reset the error stack when returning to the calling program
1047: PA_DEBUG.Reset_Err_Stack;
1048:
1049: -- If any errors exist then set the x_return_status to 'E'
1050:
1051: IF x_msg_count > 0 THEN

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

1067: ROLLBACK TO ASG_PUB_DELETE_TEAM_TEMPLATE;
1068: END IF;
1069: -- Set the excetption Message and the stack
1070: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TEAM_TEMPLATES_PUB.Delete_Assignment'
1071: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1072: --
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1074: RAISE;
1075: --