APPS.PA_PROJECT_CORE1 dependencies on PA_TEAM_TEMPLATES

Line 299: l_team_template_id PA_TEAM_TEMPLATES.TEAM_TEMPLATE_ID%TYPE;

295: l_wf_party_process VARCHAR2(30);
296: l_wf_enabled_flag VARCHAR2(1);
297: l_assignment_id NUMBER;
298: l_err_code NUMBER := 0;
299: l_team_template_id PA_TEAM_TEMPLATES.TEAM_TEMPLATE_ID%TYPE;
300: l_location_id PA_LOCATIONS.LOCATION_ID%TYPE;
301: l_start_date DATE;
302: l_return_status VARCHAR2(1);
303: l_msg_data VARCHAR2(2000);

Line 1997: PA_TEAM_TEMPLATES_PUB.EXECUTE_APPLY_TEAM_TEMPLATE

1993: if l_team_template_id is not null then
1994: --EH Changes
1995: BEGIN
1996:
1997: PA_TEAM_TEMPLATES_PUB.EXECUTE_APPLY_TEAM_TEMPLATE
1998: ( p_team_template_id => l_team_template_id
1999: ,p_project_id => x_new_project_id
2000: ,p_project_start_date => l_start_date
2001: ,x_return_status => l_return_status

Line 2009: x_err_stack := x_err_stack||'->PA_TEAM_TEMPLATES_PUB.EXECUTE_APPLY_TEAM_TEMPLATE';

2005: if l_return_status <> 'S' then
2006: x_err_code := 256;
2007: -- x_err_stage := 'PA_NO_PROJ_CREATED';
2008: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_EXEC_APPLY_TEAM_TMP');
2009: x_err_stack := x_err_stack||'->PA_TEAM_TEMPLATES_PUB.EXECUTE_APPLY_TEAM_TEMPLATE';
2010: rollback to copy_project;
2011: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2012: return;
2013: end if;

Line 2019: x_err_stage := 'API: '||'PA_TEAM_TEMPLATES_PUB.EXECUTE_APPLY_TEAM_TEMPLATE'||

2015: x_err_code := 256;
2016: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2017: -- IF x_err_stage IS NULL
2018: -- THEN
2019: x_err_stage := 'API: '||'PA_TEAM_TEMPLATES_PUB.EXECUTE_APPLY_TEAM_TEMPLATE'||
2020: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
2021: -- END IF;
2022: rollback to copy_project;
2023: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534