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_TEAM_TEMPLATES

Line 1: PACKAGE BODY pa_team_templates_pub AS

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

Line 6: (p_team_template_id IN pa_team_templates.team_template_id%TYPE

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
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'

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

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
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 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 69: PA_TEAM_TEMPLATES_PUB.Apply_Team_Template(

65: ,x_msg => 'Calling Apply_Team_Template'
66: ,x_log_level => 5);
67: END IF;
68:
69: PA_TEAM_TEMPLATES_PUB.Apply_Team_Template(
70: p_team_template_id_tbl => g_team_template_id_tbl
71: ,p_project_id => p_project_id
72: ,p_project_start_date => p_project_start_date
73: ,p_team_start_date => p_team_start_date

Line 101: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PUB.Execute_Apply_Team_Template'

97: ROLLBACK TO ASG_PUB_EXEC_APPLY_TEAM_TEMP;
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;

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

109: PROCEDURE Apply_Team_Template
110: (p_team_template_id_tbl IN team_template_id_tbl
111: ,p_project_id IN pa_projects_all.project_id%TYPE
112: ,p_project_start_date IN pa_projects_all.start_date%TYPE
113: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
114: ,p_use_project_location IN VARCHAR2 := 'N'
115: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
116: ,p_use_project_calendar IN VARCHAR2 := 'N'
117: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL

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 174: ,x_msg => 'calling PA_TEAM_TEMPLATES_PVT.Apply_Team_Template'

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:
178: --validate that the project is not an unassigned time project.

Line 229: PA_TEAM_TEMPLATES_PVT.Start_Apply_Team_Template_WF(p_team_template_id_tbl => p_team_template_id_tbl

225: x_msg_count := FND_MSG_PUB.Count_Msg;
226:
227: IF x_msg_count = 0 THEN
228:
229: PA_TEAM_TEMPLATES_PVT.Start_Apply_Team_Template_WF(p_team_template_id_tbl => p_team_template_id_tbl
230: ,p_project_id => p_project_id
231: ,p_project_start_date => p_project_start_date
232: ,p_team_start_date => p_team_start_date
233: ,p_use_project_location => p_use_project_location

Line 286: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PUB.Apply_Team_Template'

282: ROLLBACK TO ASG_PUB_APPLY_TEAM_TEMPLATE;
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;

Line 296: (p_team_template_name IN pa_team_templates.team_template_name%TYPE

292: END Apply_Team_Template;
293:
294:
295: PROCEDURE Execute_Create_Team_Template
296: (p_team_template_name IN pa_team_templates.team_template_name%TYPE
297: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
298: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
299: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
300: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 297: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR

293:
294:
295: PROCEDURE Execute_Create_Team_Template
296: (p_team_template_name IN pa_team_templates.team_template_name%TYPE
297: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
298: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
299: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
300: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
301: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM

Line 298: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE

294:
295: PROCEDURE Execute_Create_Team_Template
296: (p_team_template_name IN pa_team_templates.team_template_name%TYPE
297: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
298: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
299: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
300: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
301: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
302: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 299: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE

295: PROCEDURE Execute_Create_Team_Template
296: (p_team_template_name IN pa_team_templates.team_template_name%TYPE
297: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
298: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
299: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
300: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
301: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
302: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
303: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM

Line 301: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM

297: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
298: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
299: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
300: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
301: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
302: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
303: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
304: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
305: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM

Line 303: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM

299: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
300: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
301: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
302: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
303: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
304: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
305: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
306: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
307: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR

Line 305: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM

301: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
302: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
303: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
304: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
305: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
306: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
307: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
308: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
309: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 306: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE

302: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
303: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
304: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
305: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
306: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
307: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
308: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
309: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
310: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR

Line 307: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR

303: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
304: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
305: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
306: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
307: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
308: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
309: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
310: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
311: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR

Line 308: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR

304: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
305: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
306: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
307: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
308: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
309: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
310: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
311: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
312: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR

Line 309: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR

305: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
306: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
307: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
308: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
309: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
310: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
311: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
312: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
313: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR

Line 310: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR

306: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
307: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
308: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
309: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
310: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
311: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
312: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
313: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
314: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR

Line 311: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR

307: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
308: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
309: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
310: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
311: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
312: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
313: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
314: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
315: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR

Line 312: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR

308: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
309: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
310: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
311: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
312: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
313: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
314: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
315: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
316: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR

Line 313: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR

309: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
310: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
311: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
312: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
313: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
314: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
315: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
316: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
317: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR

Line 314: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR

310: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
311: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
312: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
313: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
314: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
315: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
316: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
317: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
318: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR

Line 315: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR

311: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
312: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
313: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
314: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
315: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
316: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
317: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
318: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
319: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR

Line 316: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR

312: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
313: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
314: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
315: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
316: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
317: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
318: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
319: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
320: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR

Line 317: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR

313: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
314: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
315: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
316: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
317: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
318: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
319: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
320: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
321: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR

Line 318: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR

314: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
315: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
316: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
317: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
318: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
319: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
320: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
321: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
322: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR

Line 319: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR

315: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
316: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
317: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
318: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
319: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
320: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
321: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
322: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
323: ,p_api_version IN NUMBER := 1.0

Line 320: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR

316: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
317: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
318: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
319: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
320: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
321: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
322: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
323: ,p_api_version IN NUMBER := 1.0
324: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 321: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR

317: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
318: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
319: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
320: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
321: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
322: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
323: ,p_api_version IN NUMBER := 1.0
324: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
325: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 322: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR

318: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
319: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
320: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
321: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
322: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
323: ,p_api_version IN NUMBER := 1.0
324: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
325: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
326: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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 398: PA_TEAM_TEMPLATES_PUB.Create_Team_Template

394: ,x_log_level => 5);
395: END IF;
396:
397:
398: PA_TEAM_TEMPLATES_PUB.Create_Team_Template
399: (p_team_template_rec => l_team_template_rec
400: ,p_calendar_name => p_calendar_name
401: ,p_work_type_name => p_work_type_name
402: ,p_role_list_name => p_role_list_name

Line 423: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PUB.Execute_Create_Team_Template'

419: ROLLBACK TO ASG_PUB_EXEC_CREATE_TEAM_TEMP;
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;

Line 450: l_new_calendar_id pa_team_templates.calendar_id%TYPE;

446: IS
447:
448: l_team_template_rec team_template_rec;
449: -- added for bug: 4537865
450: l_new_calendar_id pa_team_templates.calendar_id%TYPE;
451: l_new_work_type_id pa_team_templates.work_type_id%TYPE;
452: l_new_role_list_id pa_team_templates.role_list_id%TYPE;
453: -- added for bug: 4537865
454: l_return_status VARCHAR2(1);

Line 451: l_new_work_type_id pa_team_templates.work_type_id%TYPE;

447:
448: l_team_template_rec team_template_rec;
449: -- added for bug: 4537865
450: l_new_calendar_id pa_team_templates.calendar_id%TYPE;
451: l_new_work_type_id pa_team_templates.work_type_id%TYPE;
452: l_new_role_list_id pa_team_templates.role_list_id%TYPE;
453: -- added for bug: 4537865
454: l_return_status VARCHAR2(1);
455: l_error_message_code fnd_new_messages.message_name%TYPE;

Line 452: l_new_role_list_id pa_team_templates.role_list_id%TYPE;

448: l_team_template_rec team_template_rec;
449: -- added for bug: 4537865
450: l_new_calendar_id pa_team_templates.calendar_id%TYPE;
451: l_new_work_type_id pa_team_templates.work_type_id%TYPE;
452: l_new_role_list_id pa_team_templates.role_list_id%TYPE;
453: -- added for bug: 4537865
454: l_return_status VARCHAR2(1);
455: l_error_message_code fnd_new_messages.message_name%TYPE;
456: l_msg_index_out NUMBER;

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 555: PA_TEAM_TEMPLATES_PVT.Create_Team_Template( p_team_template_rec => l_team_template_rec

551: END IF;
552:
553: END IF; --validate role list
554:
555: PA_TEAM_TEMPLATES_PVT.Create_Team_Template( p_team_template_rec => l_team_template_rec
556: ,p_commit => p_commit
557: ,p_validate_only => p_validate_only
558: ,x_team_template_id => x_team_template_id
559: ,x_return_status => x_return_status);

Line 597: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TEAM_TEMPLATES_PUB.Create_Team_Template'

593: IF p_commit = FND_API.G_TRUE THEN
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;

Line 608: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE

604:
605:
606:
607: PROCEDURE Execute_Update_Team_Template
608: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
609: ,p_record_version_number IN pa_team_templates.record_version_number%TYPE
610: ,p_team_template_name IN pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
611: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
612: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE

Line 609: ,p_record_version_number IN pa_team_templates.record_version_number%TYPE

605:
606:
607: PROCEDURE Execute_Update_Team_Template
608: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
609: ,p_record_version_number IN pa_team_templates.record_version_number%TYPE
610: ,p_team_template_name IN pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
611: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
612: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
613: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE

Line 610: ,p_team_template_name IN pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR

606:
607: PROCEDURE Execute_Update_Team_Template
608: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
609: ,p_record_version_number IN pa_team_templates.record_version_number%TYPE
610: ,p_team_template_name IN pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
611: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
612: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
613: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
614: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 611: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR

607: PROCEDURE Execute_Update_Team_Template
608: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
609: ,p_record_version_number IN pa_team_templates.record_version_number%TYPE
610: ,p_team_template_name IN pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
611: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
612: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
613: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
614: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
615: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM

Line 612: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE

608: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
609: ,p_record_version_number IN pa_team_templates.record_version_number%TYPE
610: ,p_team_template_name IN pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
611: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
612: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
613: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
614: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
615: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
616: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 613: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE

609: ,p_record_version_number IN pa_team_templates.record_version_number%TYPE
610: ,p_team_template_name IN pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
611: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
612: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
613: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
614: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
615: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
616: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
617: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM

Line 615: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM

611: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
612: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
613: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
614: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
615: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
616: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
617: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
618: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
619: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM

Line 617: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM

613: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
614: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
615: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
616: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
617: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
618: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
619: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
620: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
621: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR

Line 619: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM

615: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
616: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
617: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
618: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
619: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
620: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
621: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
622: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
623: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR

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

616: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
617: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
618: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
619: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
620: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
621: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
622: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
623: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
624: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 621: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR

617: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
618: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
619: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
620: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
621: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
622: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
623: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
624: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
625: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR

Line 622: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR

618: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
619: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
620: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
621: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
622: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
623: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
624: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
625: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
626: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR

Line 623: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR

619: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
620: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
621: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
622: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
623: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
624: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
625: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
626: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
627: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR

Line 624: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR

620: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
621: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
622: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
623: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
624: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
625: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
626: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
627: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
628: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR

Line 625: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR

621: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
622: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
623: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
624: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
625: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
626: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
627: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
628: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
629: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR

Line 626: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR

622: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
623: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
624: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
625: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
626: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
627: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
628: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
629: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
630: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR

Line 627: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR

623: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
624: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
625: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
626: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
627: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
628: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
629: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
630: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
631: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR

Line 628: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR

624: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
625: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
626: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
627: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
628: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
629: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
630: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
631: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
632: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR

Line 629: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR

625: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
626: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
627: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
628: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
629: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
630: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
631: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
632: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
633: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR

Line 630: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR

626: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
627: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
628: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
629: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
630: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
631: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
632: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
633: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
634: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR

Line 631: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR

627: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
628: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
629: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
630: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
631: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
632: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
633: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
634: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
635: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR

Line 632: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR

628: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
629: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
630: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
631: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
632: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
633: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
634: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
635: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
636: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR

Line 633: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR

629: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
630: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
631: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
632: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
633: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
634: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
635: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
636: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
637: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR

Line 634: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR

630: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
631: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
632: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
633: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
634: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
635: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
636: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
637: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
638: ,p_api_version IN NUMBER := 1.0

Line 635: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR

631: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
632: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
633: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
634: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
635: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
636: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
637: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
638: ,p_api_version IN NUMBER := 1.0
639: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 636: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR

632: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
633: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
634: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
635: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
636: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
637: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
638: ,p_api_version IN NUMBER := 1.0
639: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
640: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 637: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR

633: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
634: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
635: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
636: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
637: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
638: ,p_api_version IN NUMBER := 1.0
639: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
640: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
641: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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 716: PA_TEAM_TEMPLATES_PUB.Update_Team_Template

712: ,x_log_level => 5);
713: END IF;
714:
715:
716: PA_TEAM_TEMPLATES_PUB.Update_Team_Template
717: (p_team_template_rec => l_team_template_rec
718: ,p_calendar_name => p_calendar_name
719: ,p_work_type_name => p_work_type_name
720: ,p_role_list_name => p_role_list_name

Line 740: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PUB.Execute_Update_Team_Template'

736: ROLLBACK TO ASG_PUB_EXEC_UPDATE_TEAM_TEMP;
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;

Line 767: l_new_calendar_id pa_team_templates.calendar_id%TYPE;

763: IS
764:
765: l_team_template_rec team_template_rec;
766: -- added for Bug: 4537865
767: l_new_calendar_id pa_team_templates.calendar_id%TYPE;
768: l_new_work_type_id pa_team_templates.work_type_id%TYPE;
769: l_new_role_list_id pa_team_templates.role_list_id%TYPE;
770: -- added for Bug: 4537865
771: l_return_status VARCHAR2(1);

Line 768: l_new_work_type_id pa_team_templates.work_type_id%TYPE;

764:
765: l_team_template_rec team_template_rec;
766: -- added for Bug: 4537865
767: l_new_calendar_id pa_team_templates.calendar_id%TYPE;
768: l_new_work_type_id pa_team_templates.work_type_id%TYPE;
769: l_new_role_list_id pa_team_templates.role_list_id%TYPE;
770: -- added for Bug: 4537865
771: l_return_status VARCHAR2(1);
772: l_error_message_code fnd_new_messages.message_name%TYPE;

Line 769: l_new_role_list_id pa_team_templates.role_list_id%TYPE;

765: l_team_template_rec team_template_rec;
766: -- added for Bug: 4537865
767: l_new_calendar_id pa_team_templates.calendar_id%TYPE;
768: l_new_work_type_id pa_team_templates.work_type_id%TYPE;
769: l_new_role_list_id pa_team_templates.role_list_id%TYPE;
770: -- added for Bug: 4537865
771: l_return_status VARCHAR2(1);
772: l_error_message_code fnd_new_messages.message_name%TYPE;
773: l_msg_index_out NUMBER;

Line 774: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;

770: -- added for Bug: 4537865
771: l_return_status VARCHAR2(1);
772: l_error_message_code fnd_new_messages.message_name%TYPE;
773: l_msg_index_out NUMBER;
774: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
775:
776:
777: CURSOR check_record_version_and_wf IS
778: SELECT workflow_in_progress_flag

Line 779: FROM pa_team_templates

775:
776:
777: CURSOR check_record_version_and_wf IS
778: SELECT workflow_in_progress_flag
779: FROM pa_team_templates
780: WHERE team_template_id = p_team_template_rec.team_template_id
781: AND record_version_number = p_team_template_rec.record_version_number;
782:
783: BEGIN

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 901: PA_TEAM_TEMPLATES_PVT.Update_Team_Template(p_team_template_rec => l_team_template_rec

897: END IF; --record version number and workflow flag check
898:
899: CLOSE check_record_version_and_wf;
900:
901: PA_TEAM_TEMPLATES_PVT.Update_Team_Template(p_team_template_rec => l_team_template_rec
902: ,p_commit => p_commit
903: ,p_validate_only => p_validate_only
904: ,x_return_status => x_return_status);
905:

Line 942: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TEAM_TEMPLATES_PUB.Update_Team_Template'

938: IF p_commit = FND_API.G_TRUE THEN
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;

Line 952: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE

948: END Update_Team_Template;
949:
950:
951: PROCEDURE Delete_Team_Template
952: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
953: ,p_record_version_number IN NUMBER
954: ,p_api_version IN NUMBER := 1
955: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
956: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 971: FROM pa_team_templates

967: l_check_team_template_in_use VARCHAR2(1);
968:
969: CURSOR check_record_version_and_wf IS
970: SELECT workflow_in_progress_flag
971: FROM pa_team_templates
972: WHERE team_template_id = p_team_template_id
973: AND record_version_number = p_record_version_number;
974:
975: BEGIN

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 1025: PA_TEAM_TEMPLATES_PVT.Delete_Team_Template

1021: ,x_msg => 'Calling delete team template pvt'
1022: ,x_log_level => 5);
1023: END IF;
1024:
1025: PA_TEAM_TEMPLATES_PVT.Delete_Team_Template
1026: (p_team_template_id => p_team_template_id
1027: ,p_record_version_number => p_record_version_number
1028: ,x_return_status => x_return_status);
1029:

Line 1070: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TEAM_TEMPLATES_PUB.Delete_Assignment'

1066: IF p_commit = FND_API.G_TRUE THEN
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;

Line 1078: END pa_team_templates_pub;

1074: RAISE;
1075: --
1076: END Delete_Team_Template;
1077:
1078: END pa_team_templates_pub;