156: SAVEPOINT ASG_PUB_APPLY_TEAM_TEMPLATE;
157: END IF;
158:
159: --clear globals used to put the team template name / role name in error messages.
160: pa_assignment_utils.g_team_template_id := NULL;
161: pa_assignment_utils.g_team_template_name_token := NULL;
162: pa_assignment_utils.g_team_role_name_token := NULL;
163:
164: --Log Message
157: END IF;
158:
159: --clear globals used to put the team template name / role name in error messages.
160: pa_assignment_utils.g_team_template_id := NULL;
161: pa_assignment_utils.g_team_template_name_token := NULL;
162: pa_assignment_utils.g_team_role_name_token := NULL;
163:
164: --Log Message
165: IF (P_DEBUG_MODE = 'Y') THEN
158:
159: --clear globals used to put the team template name / role name in error messages.
160: pa_assignment_utils.g_team_template_id := NULL;
161: pa_assignment_utils.g_team_template_name_token := NULL;
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'
265: COMMIT;
266: END IF;
267:
268: --clear globals used to put the team template name / role name in error messages.
269: pa_assignment_utils.g_team_template_id := NULL;
270: pa_assignment_utils.g_team_template_name_token := NULL;
271: pa_assignment_utils.g_team_role_name_token := NULL;
272:
273: EXCEPTION
266: END IF;
267:
268: --clear globals used to put the team template name / role name in error messages.
269: pa_assignment_utils.g_team_template_id := NULL;
270: pa_assignment_utils.g_team_template_name_token := NULL;
271: pa_assignment_utils.g_team_role_name_token := NULL;
272:
273: EXCEPTION
274: WHEN OTHERS THEN
267:
268: --clear globals used to put the team template name / role name in error messages.
269: pa_assignment_utils.g_team_template_id := NULL;
270: pa_assignment_utils.g_team_template_name_token := NULL;
271: pa_assignment_utils.g_team_role_name_token := NULL;
272:
273: EXCEPTION
274: WHEN OTHERS THEN
275:
273: EXCEPTION
274: WHEN OTHERS THEN
275:
276: --clear globals used to put the team template name / role name in error messages.
277: pa_assignment_utils.g_team_template_id := NULL;
278: pa_assignment_utils.g_team_template_name_token := NULL;
279: pa_assignment_utils.g_team_role_name_token := NULL;
280:
281: IF p_commit = FND_API.G_TRUE THEN
274: WHEN OTHERS THEN
275:
276: --clear globals used to put the team template name / role name in error messages.
277: pa_assignment_utils.g_team_template_id := NULL;
278: pa_assignment_utils.g_team_template_name_token := NULL;
279: pa_assignment_utils.g_team_role_name_token := NULL;
280:
281: IF p_commit = FND_API.G_TRUE THEN
282: ROLLBACK TO ASG_PUB_APPLY_TEAM_TEMPLATE;
275:
276: --clear globals used to put the team template name / role name in error messages.
277: pa_assignment_utils.g_team_template_id := NULL;
278: pa_assignment_utils.g_team_template_name_token := NULL;
279: pa_assignment_utils.g_team_role_name_token := NULL;
280:
281: IF p_commit = FND_API.G_TRUE THEN
282: ROLLBACK TO ASG_PUB_APPLY_TEAM_TEMPLATE;
283: END IF;