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 640: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

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

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

Line 669: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

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

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

Line 695: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

691:
692: END IF;
693: --Bug#9356483
694:
695: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
696: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'
697: -- ,p_msg_name => l_error_message_code);
698: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
699: END IF;

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

694:
695: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
696: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'
697: -- ,p_msg_name => l_error_message_code);
698: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
699: END IF;
700: END IF;
701:
702: -- FP.M Development

Line 791: ,p_named_role => FND_API.G_MISS_CHAR

787: ,p_task_version_id_tbl => l_task_version_id_tbl
788: ,p_budget_version_id_tbl => l_budget_version_id_tbl
789: ,p_struct_version_id_tbl => l_struct_version_id_tbl
790: ,p_project_assignment_id => -1
791: ,p_named_role => FND_API.G_MISS_CHAR
792: ,x_return_status => l_return_status
793: );
794: END IF;
795:

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

821: PA_DEBUG.Reset_Err_Stack;
822:
823: -- If g_error_exists is TRUE then set the x_return_status to 'E'
824:
825: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
826:
827: x_return_status := FND_API.G_RET_STS_ERROR;
828:
829: END IF;

Line 827: x_return_status := FND_API.G_RET_STS_ERROR;

823: -- If g_error_exists is TRUE then set the x_return_status to 'E'
824:
825: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
826:
827: x_return_status := FND_API.G_RET_STS_ERROR;
828:
829: END IF;
830:
831:

Line 839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

835: -- Set the excetption Message and the stack
836: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PVT.Delete_Assignment'
837: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
838: --
839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
840: RAISE;
841: END Delete_Assignment;
842:
843: /* --------------------------------------------------------------------

Line 860: x_return_status := FND_API.G_RET_STS_SUCCESS;

856: BEGIN
857:
858: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PVT.Update_Revenue_Bill_Rate');
859:
860: x_return_status := FND_API.G_RET_STS_SUCCESS;
861:
862: IF p_assignment_id_tbl.COUNT > 0 THEN
863: FOR i IN p_assignment_id_tbl.FIRST .. p_assignment_id_tbl.LAST LOOP
864:

Line 874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

870: END IF;
871:
872: EXCEPTION
873: WHEN OTHERS THEN
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875:
876: fnd_msg_pub.add_exc_msg
877: (p_pkg_name => 'PA_ASSIGNMENTS_PVT',
878: p_procedure_name => 'Update_Revenue_Bill_Rate');

Line 901: x_return_status := FND_API.G_RET_STS_SUCCESS;

897: )
898: IS
899: BEGIN
900:
901: x_return_status := FND_API.G_RET_STS_SUCCESS;
902:
903: pa_project_assignments_pkg.update_row(
904: p_assignment_id => p_assignment_id,
905: p_transfer_price_rate => p_transfer_price_rate,

Line 911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

907: x_return_status => x_return_status);
908:
909: EXCEPTION
910: WHEN OTHERS THEN
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912:
913: fnd_msg_pub.add_exc_msg
914: (p_pkg_name => 'PA_ASSIGNMENTS_PVT',
915: p_procedure_name => 'Update_Transfer_Price');

Line 1003: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

999: end if;
1000:
1001: /* Call to update_Transfer_Price to udpate the transfer_price_Rate and transfer_pr_rate_curr only if no error */
1002:
1003: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1004:
1005: IF p_debug_mode = 'Y' THEN
1006: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price',' Calling update_transfer_price with proper Values', 3);
1007: END IF;

Line 1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1024: END IF;
1025: -- 4537865 : Included Exception Block
1026: EXCEPTION
1027: WHEN OTHERS THEN
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029: x_msg_count := 1;
1030: x_msg_data := SUBSTRB(SQLERRM,1,240);
1031:
1032: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PVT'

Line 1144: l_overall_return_status := FND_API.G_RET_STS_SUCCESS;

1140: -- Added for Bug 6856934
1141: l_structure_ver_name pa_proj_elem_ver_structure.name%type;
1142:
1143: BEGIN
1144: l_overall_return_status := FND_API.G_RET_STS_SUCCESS;
1145:
1146: l_task_assignment_id_tbl := p_task_assignment_id_tbl;
1147: l_task_version_id_tbl := p_task_version_id_tbl;
1148: l_budget_version_id_tbl := p_budget_version_id_tbl;

Line 1394: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1390: ,x_msg => 'return status'||l_return_status
1391: ,x_log_level => li_message_level);
1392: END IF;
1393:
1394: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1395: l_overall_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1396:
1397: -- bug 4117269: Remove the error messages added by the above API
1398: l_msg_count2 := FND_MSG_PUB.Count_Msg;

Line 1395: l_overall_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1391: ,x_log_level => li_message_level);
1392: END IF;
1393:
1394: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1395: l_overall_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1396:
1397: -- bug 4117269: Remove the error messages added by the above API
1398: l_msg_count2 := FND_MSG_PUB.Count_Msg;
1399: IF P_DEBUG_MODE = 'Y' THEN

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

1413: END LOOP;
1414:
1415: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1416: ,p_msg_name => 'PA_NO_UPDATE_ASGN_WITH_ACTUALS' );
1417: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1418:
1419: END IF;
1420:
1421: ELSE -- If nvl(l_edit_task_ok,'X') <> 'O'

Line 1440: l_overall_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1436: ,p_token1 => 'TEAM_ROLE'
1437: ,p_value1 => p_named_role
1438: ,p_token2 => 'WP_VERSION_NAME'
1439: ,p_value2 => l_structure_ver_name);
1440: l_overall_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1441: END IF;
1442:
1443: END IF; -- IF 'Y' = l_edit_task_ok THEN
1444:

Line 1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1514: -- Set the excetption Message and the stack
1515: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1516: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1517: --
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1519: RAISE; -- This is optional depending on the needs
1520:
1521:
1522: END Update_Task_Assignments;