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_RESOURCE_SETUP_PVT dependencies on FND_API

Line 14: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

10:
11:
12: PROCEDURE UPDATE_ADDITIONAL_STAFF_INFO
13: (p_api_version IN NUMBER := 1.0 ,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
16: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
17: p_project_id IN NUMBER ,
18: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,

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

11:
12: PROCEDURE UPDATE_ADDITIONAL_STAFF_INFO
13: (p_api_version IN NUMBER := 1.0 ,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
16: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
17: p_project_id IN NUMBER ,
18: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
19: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,

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

12: PROCEDURE UPDATE_ADDITIONAL_STAFF_INFO
13: (p_api_version IN NUMBER := 1.0 ,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
16: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
17: p_project_id IN NUMBER ,
18: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
19: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
20: p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 18: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,

14: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
16: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
17: p_project_id IN NUMBER ,
18: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
19: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
20: p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM ,
21: p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
22: p_record_version_number IN NUMBER ,

Line 19: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,

15: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
16: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
17: p_project_id IN NUMBER ,
18: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
19: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
20: p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM ,
21: p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
22: p_record_version_number IN NUMBER ,
23: p_initial_team_template_id IN NUMBER := FND_API.G_MISS_NUM , -- added for bug 2607631

Line 20: p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM ,

16: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
17: p_project_id IN NUMBER ,
18: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
19: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
20: p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM ,
21: p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
22: p_record_version_number IN NUMBER ,
23: p_initial_team_template_id IN NUMBER := FND_API.G_MISS_NUM , -- added for bug 2607631
24: p_proj_req_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 21: p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,

17: p_project_id IN NUMBER ,
18: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
19: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
20: p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM ,
21: p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
22: p_record_version_number IN NUMBER ,
23: p_initial_team_template_id IN NUMBER := FND_API.G_MISS_NUM , -- added for bug 2607631
24: p_proj_req_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
25: p_proj_asgmt_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 23: p_initial_team_template_id IN NUMBER := FND_API.G_MISS_NUM , -- added for bug 2607631

19: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
20: p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM ,
21: p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
22: p_record_version_number IN NUMBER ,
23: p_initial_team_template_id IN NUMBER := FND_API.G_MISS_NUM , -- added for bug 2607631
24: p_proj_req_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
25: p_proj_asgmt_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
27: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 24: p_proj_req_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,

20: p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM ,
21: p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
22: p_record_version_number IN NUMBER ,
23: p_initial_team_template_id IN NUMBER := FND_API.G_MISS_NUM , -- added for bug 2607631
24: p_proj_req_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
25: p_proj_asgmt_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
27: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
28: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 25: p_proj_asgmt_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,

21: p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
22: p_record_version_number IN NUMBER ,
23: p_initial_team_template_id IN NUMBER := FND_API.G_MISS_NUM , -- added for bug 2607631
24: p_proj_req_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
25: p_proj_asgmt_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
27: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
28: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
29: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 26: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,

22: p_record_version_number IN NUMBER ,
23: p_initial_team_template_id IN NUMBER := FND_API.G_MISS_NUM , -- added for bug 2607631
24: p_proj_req_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
25: p_proj_asgmt_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
27: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
28: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
29: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
30: IS

Line 57: x_return_status := FND_API.G_RET_STS_SUCCESS;

53: ' asgmt_format='||p_proj_asgmt_res_format_id
54: ,x_log_level => li_message_level);
55: END IF;
56:
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59: IF p_commit = FND_API.G_TRUE THEN
60: SAVEPOINT update_addition_staff_info;
61: END IF;

Line 59: IF p_commit = FND_API.G_TRUE THEN

55: END IF;
56:
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59: IF p_commit = FND_API.G_TRUE THEN
60: SAVEPOINT update_addition_staff_info;
61: END IF;
62:
63: if p_validate_only <> FND_API.G_TRUE then

Line 63: if p_validate_only <> FND_API.G_TRUE then

59: IF p_commit = FND_API.G_TRUE THEN
60: SAVEPOINT update_addition_staff_info;
61: END IF;
62:
63: if p_validate_only <> FND_API.G_TRUE then
64: BEGIN
65:
66: SELECT 'x' INTO l_dummy
67: FROM pa_projects

Line 127: RAISE FND_API.G_EXC_ERROR;

123:
124: IF l_msg_count > 0 THEN
125: x_msg_count := l_msg_count;
126: x_return_status := 'E';
127: RAISE FND_API.G_EXC_ERROR;
128: END IF;
129:
130: -- write your program logic from here
131:

Line 133: IF NOT FND_API.TO_BOOLEAN(p_validate_only) THEN

129:
130: -- write your program logic from here
131:
132:
133: IF NOT FND_API.TO_BOOLEAN(p_validate_only) THEN
134:
135: -- update the project table
136: UPDATE pa_projects_all
137: SET record_version_number = record_version_number + 1

Line 138: ,calendar_id = decode(p_calendar_id, FND_API.G_MISS_NUM, calendar_id, p_calendar_id)

134:
135: -- update the project table
136: UPDATE pa_projects_all
137: SET record_version_number = record_version_number + 1
138: ,calendar_id = decode(p_calendar_id, FND_API.G_MISS_NUM, calendar_id, p_calendar_id)
139: ,role_list_id = decode(p_role_list_id, FND_API.G_MISS_NUM, role_list_id, p_role_list_id)
140: ,adv_action_set_id = decode(p_adv_action_set_id, FND_API.G_MISS_NUM, adv_action_set_id, p_adv_action_set_id)
141: ,start_adv_action_set_flag = decode(p_start_adv_action_set_flag, FND_API.G_MISS_CHAR, start_adv_action_set_flag, p_start_adv_action_set_flag)
142: ,initial_team_template_id = DECODE(p_initial_team_template_id, FND_API.G_MISS_NUM, initial_team_template_id, p_initial_team_template_id) -- added for bug 2607631

Line 139: ,role_list_id = decode(p_role_list_id, FND_API.G_MISS_NUM, role_list_id, p_role_list_id)

135: -- update the project table
136: UPDATE pa_projects_all
137: SET record_version_number = record_version_number + 1
138: ,calendar_id = decode(p_calendar_id, FND_API.G_MISS_NUM, calendar_id, p_calendar_id)
139: ,role_list_id = decode(p_role_list_id, FND_API.G_MISS_NUM, role_list_id, p_role_list_id)
140: ,adv_action_set_id = decode(p_adv_action_set_id, FND_API.G_MISS_NUM, adv_action_set_id, p_adv_action_set_id)
141: ,start_adv_action_set_flag = decode(p_start_adv_action_set_flag, FND_API.G_MISS_CHAR, start_adv_action_set_flag, p_start_adv_action_set_flag)
142: ,initial_team_template_id = DECODE(p_initial_team_template_id, FND_API.G_MISS_NUM, initial_team_template_id, p_initial_team_template_id) -- added for bug 2607631
143: ,proj_req_res_format_id = DECODE(p_proj_req_res_format_id, FND_API.G_MISS_NUM, proj_req_res_format_id, p_proj_req_res_format_id)

Line 140: ,adv_action_set_id = decode(p_adv_action_set_id, FND_API.G_MISS_NUM, adv_action_set_id, p_adv_action_set_id)

136: UPDATE pa_projects_all
137: SET record_version_number = record_version_number + 1
138: ,calendar_id = decode(p_calendar_id, FND_API.G_MISS_NUM, calendar_id, p_calendar_id)
139: ,role_list_id = decode(p_role_list_id, FND_API.G_MISS_NUM, role_list_id, p_role_list_id)
140: ,adv_action_set_id = decode(p_adv_action_set_id, FND_API.G_MISS_NUM, adv_action_set_id, p_adv_action_set_id)
141: ,start_adv_action_set_flag = decode(p_start_adv_action_set_flag, FND_API.G_MISS_CHAR, start_adv_action_set_flag, p_start_adv_action_set_flag)
142: ,initial_team_template_id = DECODE(p_initial_team_template_id, FND_API.G_MISS_NUM, initial_team_template_id, p_initial_team_template_id) -- added for bug 2607631
143: ,proj_req_res_format_id = DECODE(p_proj_req_res_format_id, FND_API.G_MISS_NUM, proj_req_res_format_id, p_proj_req_res_format_id)
144: ,proj_asgmt_res_format_id = DECODE(p_proj_asgmt_res_format_id, FND_API.G_MISS_NUM, proj_asgmt_res_format_id, p_proj_asgmt_res_format_id)

Line 141: ,start_adv_action_set_flag = decode(p_start_adv_action_set_flag, FND_API.G_MISS_CHAR, start_adv_action_set_flag, p_start_adv_action_set_flag)

137: SET record_version_number = record_version_number + 1
138: ,calendar_id = decode(p_calendar_id, FND_API.G_MISS_NUM, calendar_id, p_calendar_id)
139: ,role_list_id = decode(p_role_list_id, FND_API.G_MISS_NUM, role_list_id, p_role_list_id)
140: ,adv_action_set_id = decode(p_adv_action_set_id, FND_API.G_MISS_NUM, adv_action_set_id, p_adv_action_set_id)
141: ,start_adv_action_set_flag = decode(p_start_adv_action_set_flag, FND_API.G_MISS_CHAR, start_adv_action_set_flag, p_start_adv_action_set_flag)
142: ,initial_team_template_id = DECODE(p_initial_team_template_id, FND_API.G_MISS_NUM, initial_team_template_id, p_initial_team_template_id) -- added for bug 2607631
143: ,proj_req_res_format_id = DECODE(p_proj_req_res_format_id, FND_API.G_MISS_NUM, proj_req_res_format_id, p_proj_req_res_format_id)
144: ,proj_asgmt_res_format_id = DECODE(p_proj_asgmt_res_format_id, FND_API.G_MISS_NUM, proj_asgmt_res_format_id, p_proj_asgmt_res_format_id)
145: WHERE project_id = p_project_id;

Line 142: ,initial_team_template_id = DECODE(p_initial_team_template_id, FND_API.G_MISS_NUM, initial_team_template_id, p_initial_team_template_id) -- added for bug 2607631

138: ,calendar_id = decode(p_calendar_id, FND_API.G_MISS_NUM, calendar_id, p_calendar_id)
139: ,role_list_id = decode(p_role_list_id, FND_API.G_MISS_NUM, role_list_id, p_role_list_id)
140: ,adv_action_set_id = decode(p_adv_action_set_id, FND_API.G_MISS_NUM, adv_action_set_id, p_adv_action_set_id)
141: ,start_adv_action_set_flag = decode(p_start_adv_action_set_flag, FND_API.G_MISS_CHAR, start_adv_action_set_flag, p_start_adv_action_set_flag)
142: ,initial_team_template_id = DECODE(p_initial_team_template_id, FND_API.G_MISS_NUM, initial_team_template_id, p_initial_team_template_id) -- added for bug 2607631
143: ,proj_req_res_format_id = DECODE(p_proj_req_res_format_id, FND_API.G_MISS_NUM, proj_req_res_format_id, p_proj_req_res_format_id)
144: ,proj_asgmt_res_format_id = DECODE(p_proj_asgmt_res_format_id, FND_API.G_MISS_NUM, proj_asgmt_res_format_id, p_proj_asgmt_res_format_id)
145: WHERE project_id = p_project_id;
146: END IF;

Line 143: ,proj_req_res_format_id = DECODE(p_proj_req_res_format_id, FND_API.G_MISS_NUM, proj_req_res_format_id, p_proj_req_res_format_id)

139: ,role_list_id = decode(p_role_list_id, FND_API.G_MISS_NUM, role_list_id, p_role_list_id)
140: ,adv_action_set_id = decode(p_adv_action_set_id, FND_API.G_MISS_NUM, adv_action_set_id, p_adv_action_set_id)
141: ,start_adv_action_set_flag = decode(p_start_adv_action_set_flag, FND_API.G_MISS_CHAR, start_adv_action_set_flag, p_start_adv_action_set_flag)
142: ,initial_team_template_id = DECODE(p_initial_team_template_id, FND_API.G_MISS_NUM, initial_team_template_id, p_initial_team_template_id) -- added for bug 2607631
143: ,proj_req_res_format_id = DECODE(p_proj_req_res_format_id, FND_API.G_MISS_NUM, proj_req_res_format_id, p_proj_req_res_format_id)
144: ,proj_asgmt_res_format_id = DECODE(p_proj_asgmt_res_format_id, FND_API.G_MISS_NUM, proj_asgmt_res_format_id, p_proj_asgmt_res_format_id)
145: WHERE project_id = p_project_id;
146: END IF;
147:

Line 144: ,proj_asgmt_res_format_id = DECODE(p_proj_asgmt_res_format_id, FND_API.G_MISS_NUM, proj_asgmt_res_format_id, p_proj_asgmt_res_format_id)

140: ,adv_action_set_id = decode(p_adv_action_set_id, FND_API.G_MISS_NUM, adv_action_set_id, p_adv_action_set_id)
141: ,start_adv_action_set_flag = decode(p_start_adv_action_set_flag, FND_API.G_MISS_CHAR, start_adv_action_set_flag, p_start_adv_action_set_flag)
142: ,initial_team_template_id = DECODE(p_initial_team_template_id, FND_API.G_MISS_NUM, initial_team_template_id, p_initial_team_template_id) -- added for bug 2607631
143: ,proj_req_res_format_id = DECODE(p_proj_req_res_format_id, FND_API.G_MISS_NUM, proj_req_res_format_id, p_proj_req_res_format_id)
144: ,proj_asgmt_res_format_id = DECODE(p_proj_asgmt_res_format_id, FND_API.G_MISS_NUM, proj_asgmt_res_format_id, p_proj_asgmt_res_format_id)
145: WHERE project_id = p_project_id;
146: END IF;
147:
148: EXCEPTION

Line 150: WHEN FND_API.G_EXC_ERROR THEN

146: END IF;
147:
148: EXCEPTION
149:
150: WHEN FND_API.G_EXC_ERROR THEN
151:
152: IF p_commit = FND_API.G_TRUE THEN
153: ROLLBACK TO update_addition_staff_info;
154: END IF;

Line 152: IF p_commit = FND_API.G_TRUE THEN

148: EXCEPTION
149:
150: WHEN FND_API.G_EXC_ERROR THEN
151:
152: IF p_commit = FND_API.G_TRUE THEN
153: ROLLBACK TO update_addition_staff_info;
154: END IF;
155: x_return_status := FND_API.G_RET_STS_ERROR;
156:

Line 155: x_return_status := FND_API.G_RET_STS_ERROR;

151:
152: IF p_commit = FND_API.G_TRUE THEN
153: ROLLBACK TO update_addition_staff_info;
154: END IF;
155: x_return_status := FND_API.G_RET_STS_ERROR;
156:
157: WHEN OTHERS THEN
158: IF p_commit = FND_API.G_TRUE THEN
159: ROLLBACK TO update_addition_staff_info;

Line 158: IF p_commit = FND_API.G_TRUE THEN

154: END IF;
155: x_return_status := FND_API.G_RET_STS_ERROR;
156:
157: WHEN OTHERS THEN
158: IF p_commit = FND_API.G_TRUE THEN
159: ROLLBACK TO update_addition_staff_info;
160: END IF;
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
162: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RESOURCE_SETUP_PUB',

Line 161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

157: WHEN OTHERS THEN
158: IF p_commit = FND_API.G_TRUE THEN
159: ROLLBACK TO update_addition_staff_info;
160: END IF;
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
162: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RESOURCE_SETUP_PUB',
163: p_procedure_name => 'UPDATE_ADDITIONAL_STAFF_INFO',
164: p_error_text => SUBSTRB(SQLERRM,1,240));
165: raise;