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

Line 10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

6:
7: PROCEDURE Create_Assignment
8: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
9: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
13: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

Line 11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM

7: PROCEDURE Create_Assignment
8: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
9: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
13: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
15: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

Line 12: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

8: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
9: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
13: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
15: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
16: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM

Line 13: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

9: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
13: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
15: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
16: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
17: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 14: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
13: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
15: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
16: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
17: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
18: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development

Line 15: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
13: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
15: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
16: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
17: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
18: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
19: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM

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

12: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
13: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
15: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
16: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
17: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
18: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
19: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
20: ,p_number_of_requirements IN NUMBER := 1

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

13: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
15: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
16: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
17: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
18: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
19: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
20: ,p_number_of_requirements IN NUMBER := 1
21: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 18: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development

14: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
15: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
16: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
17: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
18: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
19: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
20: ,p_number_of_requirements IN NUMBER := 1
21: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
22: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 19: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM

15: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
16: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
17: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
18: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
19: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
20: ,p_number_of_requirements IN NUMBER := 1
21: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
22: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
23: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895

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

17: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
18: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
19: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
20: ,p_number_of_requirements IN NUMBER := 1
21: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
22: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
23: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
24: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
25: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895

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

18: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
19: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
20: ,p_number_of_requirements IN NUMBER := 1
21: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
22: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
23: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
24: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
25: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
26: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

64: ,x_msg => 'Beginning of the PVT Create_Assignment'
65: ,x_log_level => 5);
66: END IF;
67: -- Initialize the return status to success
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: --Assign p_assignment_rec to l_assignment_rec
71: l_assignment_rec := p_assignment_rec;
72:

Line 80: IF l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM

76: -- the api must be called by the create team role page.
77: -- In this case, we need to default assignment attributes that
78: -- are not specified on page.
79:
80: IF l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM
81: AND p_asgn_creation_mode <> 'COPY' THEN
82:
83: -- Commented for Performance fix 4898314 SQL ID 14905834
84: -- SELECT work_type_id

Line 206: IF ((l_assignment_rec.calendar_type='PROJECT' OR l_assignment_rec.calendar_type='OTHER') AND l_assignment_rec.calendar_id IS NOT NULL AND l_assignment_rec.calendar_id <> FND_API.G_MISS_NUM) OR

202: --the resource id until create_staffed_assignment is called (create_staffed_assignment calls create_resource).
203: --if calendar_type is PROJECT or OTHER, calendar_id must be not null
204: --if calendar_type is RESOURCE, calendar_id must be not null
205:
206: IF ((l_assignment_rec.calendar_type='PROJECT' OR l_assignment_rec.calendar_type='OTHER') AND l_assignment_rec.calendar_id IS NOT NULL AND l_assignment_rec.calendar_id <> FND_API.G_MISS_NUM) OR
207: (l_assignment_rec.calendar_type='RESOURCE' AND x_resource_id IS NOT NULL AND x_resource_id<>FND_API.G_MISS_NUM) THEN
208: PA_SCHEDULE_UTILS.Check_Calendar(p_calendar_type => l_assignment_rec.calendar_type,
209: p_calendar_id => l_assignment_rec.calendar_id,
210: p_resource_id => x_resource_id,

Line 207: (l_assignment_rec.calendar_type='RESOURCE' AND x_resource_id IS NOT NULL AND x_resource_id<>FND_API.G_MISS_NUM) THEN

203: --if calendar_type is PROJECT or OTHER, calendar_id must be not null
204: --if calendar_type is RESOURCE, calendar_id must be not null
205:
206: IF ((l_assignment_rec.calendar_type='PROJECT' OR l_assignment_rec.calendar_type='OTHER') AND l_assignment_rec.calendar_id IS NOT NULL AND l_assignment_rec.calendar_id <> FND_API.G_MISS_NUM) OR
207: (l_assignment_rec.calendar_type='RESOURCE' AND x_resource_id IS NOT NULL AND x_resource_id<>FND_API.G_MISS_NUM) THEN
208: PA_SCHEDULE_UTILS.Check_Calendar(p_calendar_type => l_assignment_rec.calendar_type,
209: p_calendar_id => l_assignment_rec.calendar_id,
210: p_resource_id => x_resource_id,
211: p_start_date => l_assignment_rec.start_date,

Line 229: (l_assignment_rec.source_assignment_id=FND_API.G_MISS_NUM) THEN

225: --else loop through the source assignment's subteam party table and
226: --call create subteam party on each one of the source subteam ids
227:
228: IF (l_assignment_rec.source_assignment_id IS NULL) OR
229: (l_assignment_rec.source_assignment_id=FND_API.G_MISS_NUM) THEN
230:
231: -- Check the necessary input parameters are there
232: IF (p_project_subteam_id IS NOT NULL AND p_project_subteam_id <> FND_API.G_MISS_NUM) THEN
233:

Line 232: IF (p_project_subteam_id IS NOT NULL AND p_project_subteam_id <> FND_API.G_MISS_NUM) THEN

228: IF (l_assignment_rec.source_assignment_id IS NULL) OR
229: (l_assignment_rec.source_assignment_id=FND_API.G_MISS_NUM) THEN
230:
231: -- Check the necessary input parameters are there
232: IF (p_project_subteam_id IS NOT NULL AND p_project_subteam_id <> FND_API.G_MISS_NUM) THEN
233:
234: --Log Message
235: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
236: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment.create_subteam_party'

Line 253: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

249: ,x_msg_count => l_msg_count
250: ,x_msg_data => l_msg_data
251: );
252:
253: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
254: -- PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
255: -- ,p_msg_name => l_error_message_code);
256: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
257: END IF;

Line 256: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

252:
253: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
254: -- PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
255: -- ,p_msg_name => l_error_message_code);
256: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
257: END IF;
258: END IF;
259:
260: -- else source assignment id exist, then loop through subteam party table

Line 286: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

282: ,x_msg_count => l_msg_count
283: ,x_msg_data => l_msg_data
284: );
285:
286: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
287: -- PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
288: -- ,p_msg_name => l_error_message_code);
289: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
290:

Line 289: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

285:
286: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
287: -- PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
288: -- ,p_msg_name => l_error_message_code);
289: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
290:
291: END IF; --error
292:
293: END IF; --project subteam id is not null

Line 306: IF (l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM) THEN

302: --Calculate for assignment effort
303:
304: --Do not calculate assignment effort if this is a template requirement.
305: --No timeline/schedule is created for template requirements.
306: IF (l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM) THEN
307:
308: l_assignment_effort := PA_SCHEDULE_UTILS.get_num_hours(p_assignment_rec.project_id, PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(1).assignment_id);
309:
310: END IF;

Line 333: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

329: ,p_assignment_effort => l_assignment_effort
330: ,x_return_status => l_return_status
331: );
332:
333: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
334: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
335: END IF;
336: END IF;
337:

Line 334: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

330: ,x_return_status => l_return_status
331: );
332:
333: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
334: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
335: END IF;
336: END IF;
337:
338: END IF; --checking there are any new assignments ids

Line 345: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN

341: PA_DEBUG.Reset_Err_Stack;
342:
343: -- If g_error_exists is TRUE then set the x_return_status to 'E'
344:
345: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
346:
347: x_return_status := FND_API.G_RET_STS_ERROR;
348:
349: END IF;

Line 347: x_return_status := FND_API.G_RET_STS_ERROR;

343: -- If g_error_exists is TRUE then set the x_return_status to 'E'
344:
345: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
346:
347: x_return_status := FND_API.G_RET_STS_ERROR;
348:
349: END IF;
350:
351:

Line 365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

361: -- Set the excetption Message and the stack
362: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PVT.Create_Assignment'
363: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
364: --
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
366: RAISE;
367: END Create_Assignment;
368:
369:

Line 373: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

369:
370:
371: PROCEDURE Update_Assignment
372: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
373: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
374: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
375: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
376: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
377: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

Line 374: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM

370:
371: PROCEDURE Update_Assignment
372: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
373: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
374: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
375: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
376: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
377: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
378: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 375: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

371: PROCEDURE Update_Assignment
372: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
373: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
374: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
375: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
376: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
377: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
378: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
379: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 376: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

372: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
373: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
374: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
375: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
376: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
377: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
378: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
379: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
380: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 377: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

373: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
374: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
375: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
376: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
377: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
378: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
379: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
380: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
381: )

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

374: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
375: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
376: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
377: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
378: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
379: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
380: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
381: )
382: IS

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

375: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
376: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
377: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
378: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
379: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
380: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
381: )
382: IS
383:

Line 415: x_return_status := FND_API.G_RET_STS_SUCCESS;

411: END IF;
412:
413:
414: -- Initialize the return status to success
415: x_return_status := FND_API.G_RET_STS_SUCCESS;
416:
417: --dbms_output.put_line('Update Subteam party 1');
418: --
419: --Update Subteam Party

Line 422: IF (p_project_subteam_id IS NOT NULL AND p_project_subteam_id <> FND_API.G_MISS_NUM OR

418: --
419: --Update Subteam Party
420: --
421: --If Subteam Party Id exist or Subteam Id exist, then call Update Subteam Party
422: IF (p_project_subteam_id IS NOT NULL AND p_project_subteam_id <> FND_API.G_MISS_NUM OR
423: p_project_subteam_party_id IS NOT NULL AND p_project_subteam_party_id <> FND_API.G_MISS_NUM) AND
424: (p_assignment_rec.assignment_id IS NOT NULL AND p_assignment_rec.assignment_id <>FND_API.G_MISS_NUM) THEN
425:
426: --Log Message

Line 423: p_project_subteam_party_id IS NOT NULL AND p_project_subteam_party_id <> FND_API.G_MISS_NUM) AND

419: --Update Subteam Party
420: --
421: --If Subteam Party Id exist or Subteam Id exist, then call Update Subteam Party
422: IF (p_project_subteam_id IS NOT NULL AND p_project_subteam_id <> FND_API.G_MISS_NUM OR
423: p_project_subteam_party_id IS NOT NULL AND p_project_subteam_party_id <> FND_API.G_MISS_NUM) AND
424: (p_assignment_rec.assignment_id IS NOT NULL AND p_assignment_rec.assignment_id <>FND_API.G_MISS_NUM) THEN
425:
426: --Log Message
427: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 424: (p_assignment_rec.assignment_id IS NOT NULL AND p_assignment_rec.assignment_id <>FND_API.G_MISS_NUM) THEN

420: --
421: --If Subteam Party Id exist or Subteam Id exist, then call Update Subteam Party
422: IF (p_project_subteam_id IS NOT NULL AND p_project_subteam_id <> FND_API.G_MISS_NUM OR
423: p_project_subteam_party_id IS NOT NULL AND p_project_subteam_party_id <> FND_API.G_MISS_NUM) AND
424: (p_assignment_rec.assignment_id IS NOT NULL AND p_assignment_rec.assignment_id <>FND_API.G_MISS_NUM) THEN
425:
426: --Log Message
427: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
428: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Assignment.update_subteam_party'

Line 445: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

441: ,x_msg_count => l_msg_count
442: ,x_msg_data => l_msg_data
443: );
444:
445: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
446: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'
447: -- ,p_msg_name => l_error_message_code);
448: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
449: END IF;

Line 448: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

444:
445: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
446: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'
447: -- ,p_msg_name => l_error_message_code);
448: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
449: END IF;
450: END IF;
451:
452: --If this is a template requirement then it is possible to update the

Line 457: IF p_assignment_rec.start_date<> FND_API.G_MISS_DATE OR p_assignment_rec.end_date<>FND_API.G_MISS_DATE THEN

453: --start date and the end date through this API - as template requirements
454: --do not have schedules. For requirements which belong to projects, these updates
455: --are not allowed through this API and would have already caused a validation error
456: --in the public API.
457: IF p_assignment_rec.start_date<> FND_API.G_MISS_DATE OR p_assignment_rec.end_date<>FND_API.G_MISS_DATE THEN
458: IF p_assignment_rec.start_date > p_assignment_rec.end_date THEN
459: PA_UTILS.Add_Message( p_app_short_name => 'PA'
460: ,p_msg_name => 'PA_INVALID_START_DATE');
461: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

Line 461: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

457: IF p_assignment_rec.start_date<> FND_API.G_MISS_DATE OR p_assignment_rec.end_date<>FND_API.G_MISS_DATE THEN
458: IF p_assignment_rec.start_date > p_assignment_rec.end_date THEN
459: PA_UTILS.Add_Message( p_app_short_name => 'PA'
460: ,p_msg_name => 'PA_INVALID_START_DATE');
461: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
462: END IF;
463: END IF;
464:
465: -- Get the old values of Work Type

Line 476: AND l_assignment_rec.work_type_id <> FND_API.G_MISS_NUM

472:
473: -- FP-J Bug: no data found in Mass Update Team Role
474: -- work_type_id may be passed in as null within Mass Update
475: IF l_assignment_rec.work_type_id IS NOT NULL
476: AND l_assignment_rec.work_type_id <> FND_API.G_MISS_NUM
477: AND l_assignment_rec.work_type_id <> l_work_type_id THEN
478:
479: PA_FP_ORG_FCST_UTILS.Get_Tp_Amount_Type(
480: p_project_id => l_assignment_rec.project_id

Line 488: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

484: ,x_msg_count => l_msg_count
485: ,x_msg_data => l_msg_data
486: );
487:
488: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
489: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
490: END IF;
491:
492:

Line 489: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

485: ,x_msg_data => l_msg_data
486: );
487:
488: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
489: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
490: END IF;
491:
492:
493: END IF;

Line 538: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN

534: PA_DEBUG.Reset_Err_Stack;
535:
536: -- If g_error_exists is TRUE then set the x_return_status to 'E'
537:
538: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
539:
540: x_return_status := FND_API.G_RET_STS_ERROR;
541:
542: END IF;

Line 540: x_return_status := FND_API.G_RET_STS_ERROR;

536: -- If g_error_exists is TRUE then set the x_return_status to 'E'
537:
538: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
539:
540: x_return_status := FND_API.G_RET_STS_ERROR;
541:
542: END IF;
543:
544:

Line 552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

548: -- Set the excetption Message and the stack
549: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PVT.Update_Assignment'
550: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
551: --
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
553: RAISE;
554: END Update_Assignment;
555:
556:

Line 559: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM

555:
556:
557: PROCEDURE Delete_Assignment
558: ( p_assignment_row_id IN ROWID := NULL
559: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
560: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
561: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
562: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
563: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 560: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR

556:
557: PROCEDURE Delete_Assignment
558: ( p_assignment_row_id IN ROWID := NULL
559: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
560: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
561: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
562: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
563: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
564: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM

Line 561: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

557: PROCEDURE Delete_Assignment
558: ( p_assignment_row_id IN ROWID := NULL
559: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
560: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
561: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
562: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
563: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
564: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
565: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 562: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM

558: ( p_assignment_row_id IN ROWID := NULL
559: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
560: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
561: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
562: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
563: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
564: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
565: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
566: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 563: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR

559: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
560: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
561: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
562: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
563: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
564: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
565: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
566: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
567: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 564: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM

560: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
561: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
562: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
563: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
564: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
565: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
566: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
567: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
568: )

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

561: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
562: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
563: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
564: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
565: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
566: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
567: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
568: )
569: IS

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

562: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
563: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
564: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
565: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
566: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
567: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
568: )
569: IS
570:

Line 638: x_return_status := FND_API.G_RET_STS_SUCCESS;

634: -- Initialize the Error Stack
635: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PVT.Delete_Assignment');
636:
637: -- Initialize the return status to success
638: x_return_status := FND_API.G_RET_STS_SUCCESS;
639:
640: --Log Message
641: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
642: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Delete_Assignment.begin'

Line 648: IF (p_assignment_id IS NOT NULL AND p_assignment_id <>FND_API.G_MISS_NUM) THEN

644: ,x_log_level => 5);
645: END IF;
646:
647: -- Delete Subteam Party if assignment id exists
648: IF (p_assignment_id IS NOT NULL AND p_assignment_id <>FND_API.G_MISS_NUM) THEN
649:
650: --Log Message
651: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
652: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Delete_Assignment.delete_subteam_party'

Line 660: ,p_init_msg_list => FND_API.G_FALSE -- Added for bug 5130421

656: PA_PROJECT_SUBTEAM_PARTIES_PVT.Delete_SubteamParty_By_Obj
657: ( p_validate_only => p_validate_only
658: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'
659: ,p_object_id => p_assignment_id
660: ,p_init_msg_list => FND_API.G_FALSE -- Added for bug 5130421
661: ,x_return_status => l_return_status
662: ,x_msg_count => l_msg_count
663: ,x_msg_data => l_msg_data
664: );

Line 667: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

663: ,x_msg_data => l_msg_data
664: );
665: --dbms_output.put_line('return status is '||l_return_status);
666: --dbms_output.put_line('message count is '||l_msg_count);
667: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
668: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'
669: -- ,p_msg_name => l_error_message_code);
670: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
671: END IF;

Line 670: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

666: --dbms_output.put_line('message count is '||l_msg_count);
667: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
668: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'
669: -- ,p_msg_name => l_error_message_code);
670: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
671: END IF;
672:
673: --Bug 6330317
674: IF P_DEBUG_MODE = 'Y' THEN

Line 687: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

683: ,x_msg_count => l_msg_count
684: ,x_msg_data => l_msg_data
685: );
686:
687: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
688: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'
689: -- ,p_msg_name => l_error_message_code);
690: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
691: END IF;

Line 690: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

686:
687: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
688: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'
689: -- ,p_msg_name => l_error_message_code);
690: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
691: END IF;
692: END IF;
693:
694: -- FP.M Development

Line 783: ,p_named_role => FND_API.G_MISS_CHAR

779: ,p_task_version_id_tbl => l_task_version_id_tbl
780: ,p_budget_version_id_tbl => l_budget_version_id_tbl
781: ,p_struct_version_id_tbl => l_struct_version_id_tbl
782: ,p_project_assignment_id => -1
783: ,p_named_role => FND_API.G_MISS_CHAR
784: ,x_return_status => l_return_status
785: );
786: END IF;
787:

Line 817: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN

813: PA_DEBUG.Reset_Err_Stack;
814:
815: -- If g_error_exists is TRUE then set the x_return_status to 'E'
816:
817: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
818:
819: x_return_status := FND_API.G_RET_STS_ERROR;
820:
821: END IF;

Line 819: x_return_status := FND_API.G_RET_STS_ERROR;

815: -- If g_error_exists is TRUE then set the x_return_status to 'E'
816:
817: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
818:
819: x_return_status := FND_API.G_RET_STS_ERROR;
820:
821: END IF;
822:
823:

Line 831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

827: -- Set the excetption Message and the stack
828: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PVT.Delete_Assignment'
829: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
830: --
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
832: RAISE;
833: END Delete_Assignment;
834:
835: /* --------------------------------------------------------------------

Line 852: x_return_status := FND_API.G_RET_STS_SUCCESS;

848: BEGIN
849:
850: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PVT.Update_Revenue_Bill_Rate');
851:
852: x_return_status := FND_API.G_RET_STS_SUCCESS;
853:
854: IF p_assignment_id_tbl.COUNT > 0 THEN
855: FOR i IN p_assignment_id_tbl.FIRST .. p_assignment_id_tbl.LAST LOOP
856:

Line 866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

862: END IF;
863:
864: EXCEPTION
865: WHEN OTHERS THEN
866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
867:
868: fnd_msg_pub.add_exc_msg
869: (p_pkg_name => 'PA_ASSIGNMENTS_PVT',
870: p_procedure_name => 'Update_Revenue_Bill_Rate');

Line 893: x_return_status := FND_API.G_RET_STS_SUCCESS;

889: )
890: IS
891: BEGIN
892:
893: x_return_status := FND_API.G_RET_STS_SUCCESS;
894:
895: pa_project_assignments_pkg.update_row(
896: p_assignment_id => p_assignment_id,
897: p_transfer_price_rate => p_transfer_price_rate,

Line 903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

899: x_return_status => x_return_status);
900:
901: EXCEPTION
902: WHEN OTHERS THEN
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904:
905: fnd_msg_pub.add_exc_msg
906: (p_pkg_name => 'PA_ASSIGNMENTS_PVT',
907: p_procedure_name => 'Update_Transfer_Price');

Line 995: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

991: end if;
992:
993: /* Call to update_Transfer_Price to udpate the transfer_price_Rate and transfer_pr_rate_curr only if no error */
994:
995: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
996:
997: IF p_debug_mode = 'Y' THEN
998: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price',' Calling update_transfer_price with proper Values', 3);
999: END IF;

Line 1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1016: END IF;
1017: -- 4537865 : Included Exception Block
1018: EXCEPTION
1019: WHEN OTHERS THEN
1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1021: x_msg_count := 1;
1022: x_msg_data := SUBSTRB(SQLERRM,1,240);
1023:
1024: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PVT'

Line 1136: l_overall_return_status := FND_API.G_RET_STS_SUCCESS;

1132: -- Added for Bug 6856934
1133: l_structure_ver_name pa_proj_elem_ver_structure.name%type;
1134:
1135: BEGIN
1136: l_overall_return_status := FND_API.G_RET_STS_SUCCESS;
1137:
1138: l_task_assignment_id_tbl := p_task_assignment_id_tbl;
1139: l_task_version_id_tbl := p_task_version_id_tbl;
1140: l_budget_version_id_tbl := p_budget_version_id_tbl;

Line 1386: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1382: ,x_msg => 'return status'||l_return_status
1383: ,x_log_level => li_message_level);
1384: END IF;
1385:
1386: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1387: l_overall_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1388:
1389: -- bug 4117269: Remove the error messages added by the above API
1390: l_msg_count2 := FND_MSG_PUB.Count_Msg;

Line 1387: l_overall_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1383: ,x_log_level => li_message_level);
1384: END IF;
1385:
1386: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1387: l_overall_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1388:
1389: -- bug 4117269: Remove the error messages added by the above API
1390: l_msg_count2 := FND_MSG_PUB.Count_Msg;
1391: IF P_DEBUG_MODE = 'Y' THEN

Line 1409: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

1405: END LOOP;
1406:
1407: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1408: ,p_msg_name => 'PA_NO_UPDATE_ASGN_WITH_ACTUALS' );
1409: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1410:
1411: END IF;
1412:
1413: ELSE -- If nvl(l_edit_task_ok,'X') <> 'O'

Line 1432: l_overall_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1428: ,p_token1 => 'TEAM_ROLE'
1429: ,p_value1 => p_named_role
1430: ,p_token2 => 'WP_VERSION_NAME'
1431: ,p_value2 => l_structure_ver_name);
1432: l_overall_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1433: END IF;
1434:
1435: END IF; -- IF 'Y' = l_edit_task_ok THEN
1436:

Line 1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1506: -- Set the excetption Message and the stack
1507: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1508: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1509: --
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511: RAISE; -- This is optional depending on the needs
1512:
1513:
1514: END Update_Task_Assignments;