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 FND_API

Line 9: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE

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
9: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
10: ,p_use_project_location IN VARCHAR2 := 'N'
11: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
12: ,p_use_project_calendar IN VARCHAR2 := 'N'
13: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL

Line 14: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

10: ,p_use_project_location IN VARCHAR2 := 'N'
11: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
12: ,p_use_project_calendar IN VARCHAR2 := 'N'
13: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
14: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
15: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
16: )
17: IS
18:

Line 40: x_return_status := FND_API.G_RET_STS_SUCCESS;

36: WHERE team_template_id = l_team_template_id;
37:
38: BEGIN
39: --initialize return status to Success
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41:
42: -- Setting thresold value to run the process in background
43: l_save_threshold := wf_engine.threshold;
44:

Line 187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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:
190: END Start_Apply_Team_Template_WF;
191:

Line 280: p_commit => FND_API.G_TRUE,

276: p_use_project_location => l_use_project_location,
277: p_project_location_id => l_project_location_id,
278: p_use_project_calendar => l_use_project_calendar,
279: p_project_calendar_id => l_project_calendar_id,
280: p_commit => FND_API.G_TRUE,
281: x_return_status => l_return_status);
282:
283: l_msg_count := FND_MSG_PUB.Count_Msg;
284:

Line 290: FND_MSG_PUB.get( p_encoded => FND_API.G_FALSE

286: p_result := 'COMPLETE:S';
287: ELSE
288: p_result := 'COMPLETE:F';
289: FOR l_count IN 1..l_msg_count LOOP
290: FND_MSG_PUB.get( p_encoded => FND_API.G_FALSE
291: ,p_msg_index => l_count
292: ,p_data => l_msg_data
293: ,p_msg_index_out => l_msg_index_out);
294:

Line 355: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE

351: PROCEDURE Apply_Team_Template
352: (p_team_template_id IN pa_team_templates.team_template_id%TYPE
353: ,p_project_id IN pa_projects_all.project_id%TYPE
354: ,p_project_start_date IN pa_projects_all.start_date%TYPE
355: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
356: ,p_use_project_location IN VARCHAR2 := 'N'
357: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
358: ,p_use_project_calendar IN VARCHAR2 := 'N'
359: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL

Line 360: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

356: ,p_use_project_location IN VARCHAR2 := 'N'
357: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
358: ,p_use_project_calendar IN VARCHAR2 := 'N'
359: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
360: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
361: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
362: )
363: IS
364:

Line 454: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
456: -- Issue API savepoint if the transaction is to be committed
457: IF p_commit = FND_API.G_TRUE THEN
458: SAVEPOINT ASG_PVT_APPLY_TEAM_TEMPLATE;

Line 457: IF p_commit = FND_API.G_TRUE THEN

453: -- Initialize the return status to success
454: x_return_status := FND_API.G_RET_STS_SUCCESS;
455:
456: -- Issue API savepoint if the transaction is to be committed
457: IF p_commit = FND_API.G_TRUE THEN
458: SAVEPOINT ASG_PVT_APPLY_TEAM_TEMPLATE;
459: END IF;
460:
461: --Log Message

Line 512: IF p_team_start_date IS NULL OR p_team_start_date = FND_API.G_MISS_DATE THEN

508:
509: --if the team start date was not passed in then get it
510: l_team_start_date := p_team_start_date;
511:
512: IF p_team_start_date IS NULL OR p_team_start_date = FND_API.G_MISS_DATE THEN
513:
514: OPEN get_team_start_date(p_team_template_id);
515:
516: FETCH get_team_start_date INTO l_team_start_date;

Line 555: p_validate_only => FND_API.G_FALSE,

551:
552: PA_PROJECT_SUBTEAMS_PUB.Create_Subteam(p_subteam_name => l_subteam_name,
553: p_object_type => 'PA_PROJECTS',
554: p_object_id => p_project_id,
555: p_validate_only => FND_API.G_FALSE,
556: p_init_msg_list => FND_API.G_FALSE,
557: x_new_subteam_id => l_project_subteam_id,
558: x_subteam_row_id => l_subteam_row_id,
559: x_return_status => l_return_status,

Line 556: p_init_msg_list => FND_API.G_FALSE,

552: PA_PROJECT_SUBTEAMS_PUB.Create_Subteam(p_subteam_name => l_subteam_name,
553: p_object_type => 'PA_PROJECTS',
554: p_object_id => p_project_id,
555: p_validate_only => FND_API.G_FALSE,
556: p_init_msg_list => FND_API.G_FALSE,
557: x_new_subteam_id => l_project_subteam_id,
558: x_subteam_row_id => l_subteam_row_id,
559: x_return_status => l_return_status,
560: x_msg_count => l_msg_count,

Line 671: ,p_validate_only => FND_API.G_FALSE

667: --template requirement - and then the source assignment id will only be
668: --used to get the subteams to copy, and will not be inserted to the db (no link kept).
669: PA_ASSIGNMENTS_PUB.Create_Assignment(p_assignment_rec => l_template_requirement_rec
670: ,p_asgn_creation_mode => 'COPY'
671: ,p_validate_only => FND_API.G_FALSE
672: ,x_new_assignment_id => l_new_assignment_id
673: ,x_assignment_number => l_assignment_number
674: ,x_assignment_row_id => l_assignment_row_id
675: ,x_resource_id => l_resource_id

Line 681: IF p_commit = FND_API.G_TRUE THEN

677: ,x_msg_count => l_msg_count
678: ,x_msg_data => l_msg_data
679: );
680:
681: IF p_commit = FND_API.G_TRUE THEN
682: IF l_return_status <> 'S' THEN
683: ROLLBACK;
684: ELSE COMMIT;
685: END IF;

Line 700: IF p_commit = FND_API.G_TRUE THEN

696:
697:
698: EXCEPTION
699: WHEN OTHERS THEN
700: IF p_commit = FND_API.G_TRUE THEN
701: ROLLBACK TO ASG_PVT_APPLY_TEAM_TEMPLATE;
702: END IF;
703:
704: -- Set the excetption Message and the stack

Line 708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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:
711: END Apply_Team_Template;
712:

Line 717: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

713:
714:
715: PROCEDURE Create_Team_Template
716: ( p_team_template_rec IN PA_TEAM_TEMPLATES_PUB.team_template_rec
717: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
718: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
719: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
720: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
721: )

Line 718: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

714:
715: PROCEDURE Create_Team_Template
716: ( p_team_template_rec IN PA_TEAM_TEMPLATES_PUB.team_template_rec
717: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
718: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
719: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
720: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
721: )
722: IS

Line 741: x_return_status := FND_API.G_RET_STS_SUCCESS;

737: ,x_log_level => 5);
738: END IF;
739:
740: -- Initialize the return status to success
741: x_return_status := FND_API.G_RET_STS_SUCCESS;
742:
743: --Issue API savepoint if the transaction is to be committed
744: IF p_commit = FND_API.G_TRUE THEN
745: SAVEPOINT ASGN_PVT_CREATE_TEAM_TEMPLATE;

Line 744: IF p_commit = FND_API.G_TRUE THEN

740: -- Initialize the return status to success
741: x_return_status := FND_API.G_RET_STS_SUCCESS;
742:
743: --Issue API savepoint if the transaction is to be committed
744: IF p_commit = FND_API.G_TRUE THEN
745: SAVEPOINT ASGN_PVT_CREATE_TEAM_TEMPLATE;
746: END IF;
747:
748: l_team_template_rec := p_team_template_rec;

Line 762: IF l_team_template_rec.end_date_active IS NOT NULL and l_team_template_rec.end_date_active <> FND_API.G_MISS_DATE AND l_team_template_rec.start_date_active > l_team_template_rec.end_date_active THEN

758:
759: END IF;
760:
761: --validate effective start date is before effective end date
762: IF l_team_template_rec.end_date_active IS NOT NULL and l_team_template_rec.end_date_active <> FND_API.G_MISS_DATE AND l_team_template_rec.start_date_active > l_team_template_rec.end_date_active THEN
763: PA_UTILS.Add_Message( p_app_short_name => 'PA'
764: ,p_msg_name => 'PA_INVALID_START_DATE');
765: END IF;
766:

Line 768: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg = 0 THEN

764: ,p_msg_name => 'PA_INVALID_START_DATE');
765: END IF;
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);

Line 792: IF p_commit = FND_API.G_TRUE AND l_msg_count =0 THEN

788:
789: l_msg_count := FND_MSG_PUB.Count_Msg;
790:
791: -- Commit if the flag is set and there is no error
792: IF p_commit = FND_API.G_TRUE AND l_msg_count =0 THEN
793: COMMIT;
794: END IF;
795:
796: -- Reset the error stack when returning to the calling program

Line 803: x_return_status := FND_API.G_RET_STS_ERROR;

799: -- If any errors exist then set the x_return_status to 'E'
800:
801: IF l_msg_count>0 THEN
802:
803: x_return_status := FND_API.G_RET_STS_ERROR;
804:
805: END IF;
806:
807:

Line 810: IF p_commit = FND_API.G_TRUE THEN

806:
807:
808: EXCEPTION
809: WHEN OTHERS THEN
810: IF p_commit = FND_API.G_TRUE THEN
811: ROLLBACK TO ASGN_PVT_CREATE_TEAM_TEMPLATE;
812: END IF;
813: --
814: -- Set the excetption Message and the stack

Line 818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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:
821: END Create_Team_Template;
822:

Line 826: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

822:
823:
824: PROCEDURE Update_Team_Template
825: ( p_team_template_rec IN PA_TEAM_TEMPLATES_PUB.team_template_rec
826: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
827: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
828: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
829: )
830: IS

Line 827: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

823:
824: PROCEDURE Update_Team_Template
825: ( p_team_template_rec IN PA_TEAM_TEMPLATES_PUB.team_template_rec
826: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
827: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
828: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
829: )
830: IS
831:

Line 848: x_return_status := FND_API.G_RET_STS_SUCCESS;

844: ,x_log_level => 5);
845: END IF;
846:
847: -- Initialize the return status to success
848: x_return_status := FND_API.G_RET_STS_SUCCESS;
849:
850: --Issue API savepoint if the transaction is to be committed
851: IF p_commit = FND_API.G_TRUE THEN
852: SAVEPOINT ASGN_PVT_Update_TEAM_TEMPLATE;

Line 851: IF p_commit = FND_API.G_TRUE THEN

847: -- Initialize the return status to success
848: x_return_status := FND_API.G_RET_STS_SUCCESS;
849:
850: --Issue API savepoint if the transaction is to be committed
851: IF p_commit = FND_API.G_TRUE THEN
852: SAVEPOINT ASGN_PVT_Update_TEAM_TEMPLATE;
853: END IF;
854:
855: l_team_template_rec := p_team_template_rec;

Line 858: IF l_team_template_rec.end_date_active IS NOT NULL and l_team_template_rec.end_date_active <> FND_API.G_MISS_DATE AND l_team_template_rec.start_date_active > l_team_template_rec.end_date_active THEN

854:
855: l_team_template_rec := p_team_template_rec;
856:
857: --validate effective start date is before effective end date
858: IF l_team_template_rec.end_date_active IS NOT NULL and l_team_template_rec.end_date_active <> FND_API.G_MISS_DATE AND l_team_template_rec.start_date_active > l_team_template_rec.end_date_active THEN
859: PA_UTILS.Add_Message( p_app_short_name => 'PA'
860: ,p_msg_name => 'PA_INVALID_START_DATE');
861: END IF;
862:

Line 864: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg = 0 THEN

860: ,p_msg_name => 'PA_INVALID_START_DATE');
861: END IF;
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);

Line 890: IF p_commit = FND_API.G_TRUE AND l_msg_count =0 THEN

886:
887: l_msg_count := FND_MSG_PUB.Count_Msg;
888:
889: -- Commit if the flag is set and there is no error
890: IF p_commit = FND_API.G_TRUE AND l_msg_count =0 THEN
891: COMMIT;
892: END IF;
893:
894: -- Reset the error stack when returning to the calling program

Line 901: x_return_status := FND_API.G_RET_STS_ERROR;

897: -- If any errors exist then set the x_return_status to 'E'
898:
899: IF l_msg_count>0 THEN
900:
901: x_return_status := FND_API.G_RET_STS_ERROR;
902:
903: END IF;
904:
905:

Line 908: IF p_commit = FND_API.G_TRUE THEN

904:
905:
906: EXCEPTION
907: WHEN OTHERS THEN
908: IF p_commit = FND_API.G_TRUE THEN
909: ROLLBACK TO ASGN_PVT_UPDATE_TEAM_TEMPLATE;
910: END IF;
911: --
912: -- Set the excetption Message and the stack

Line 916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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:
919: END Update_Team_Template;
920:

Line 924: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

920:
921: PROCEDURE Delete_Team_Template
922: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
923: ,p_record_version_number IN NUMBER
924: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
925: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
926: )
927: IS
928:

Line 954: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
956: -- Issue API savepoint if the transaction is to be committed
957: IF p_commit = FND_API.G_TRUE THEN
958: SAVEPOINT ASGN_PVT_DELETE_TEAM_TEMPLATE;

Line 957: IF p_commit = FND_API.G_TRUE THEN

953: -- Initialize the return status to success
954: x_return_status := FND_API.G_RET_STS_SUCCESS;
955:
956: -- Issue API savepoint if the transaction is to be committed
957: IF p_commit = FND_API.G_TRUE THEN
958: SAVEPOINT ASGN_PVT_DELETE_TEAM_TEMPLATE;
959: END IF;
960:
961: --Log Message

Line 992: (p_init_msg_list => FND_API.G_FALSE,

988: END IF;
989: --don't pass subteam id and this API will delete all subteams belonging to the
990: --team template.
991: PA_PROJECT_SUBTEAMS_PUB.Delete_Subteam_By_Obj
992: (p_init_msg_list => FND_API.G_FALSE,
993: p_validate_only => FND_API.G_FALSE,
994: p_object_type => 'PA_TEAM_TEMPLATES',
995: p_object_id => p_team_template_id,
996: x_return_status => l_return_status,

Line 993: p_validate_only => FND_API.G_FALSE,

989: --don't pass subteam id and this API will delete all subteams belonging to the
990: --team template.
991: PA_PROJECT_SUBTEAMS_PUB.Delete_Subteam_By_Obj
992: (p_init_msg_list => FND_API.G_FALSE,
993: p_validate_only => FND_API.G_FALSE,
994: p_object_type => 'PA_TEAM_TEMPLATES',
995: p_object_id => p_team_template_id,
996: x_return_status => l_return_status,
997: x_msg_count => l_msg_count,

Line 1014: p_validate_only => FND_API.G_FALSE,

1010: p_assignment_id => l_template_requirements.assignment_id,
1011: p_record_version_number => l_template_requirements.record_version_number,
1012: p_assignment_type => l_template_requirements.assignment_type,
1013: p_calling_module => 'TEMPLATE_REQUIREMENT',
1014: p_validate_only => FND_API.G_FALSE,
1015: x_return_status => l_return_status,
1016: x_msg_count => l_msg_count,
1017: x_msg_data => l_msg_data);
1018:

Line 1041: x_return_status := FND_API.G_RET_STS_ERROR;

1037: -- If errors exist then set the x_return_status to 'E'
1038:
1039: IF FND_MSG_PUB.Count_Msg > 0 THEN
1040:
1041: x_return_status := FND_API.G_RET_STS_ERROR;
1042:
1043: END IF;
1044:
1045: EXCEPTION

Line 1047: IF p_commit = FND_API.G_TRUE THEN

1043: END IF;
1044:
1045: EXCEPTION
1046: WHEN OTHERS THEN
1047: IF p_commit = FND_API.G_TRUE THEN
1048: ROLLBACK TO ASGN_PVT_DELETE_ASSIGNMENTT;
1049: END IF;
1050:
1051: -- Set the excetption Message and the stack

Line 1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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:
1058: END Delete_Team_Template;
1059: