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

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

5: li_message_level NUMBER := 1;
6: PROCEDURE Create_Open_Assignment
7: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
8: ,p_asgn_creation_mode IN VARCHAR2
9: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
10: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
11: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
13: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

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

6: PROCEDURE Create_Open_Assignment
7: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
8: ,p_asgn_creation_mode IN VARCHAR2
9: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
10: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
11: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
13: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
14: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development

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

7: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
8: ,p_asgn_creation_mode IN VARCHAR2
9: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
10: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
11: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
13: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
14: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
15: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM

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

8: ,p_asgn_creation_mode IN VARCHAR2
9: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
10: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
11: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
13: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
14: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
15: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
16: ,p_number_of_requirements IN NUMBER := 1

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

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

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

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

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

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

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

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

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

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

Line 165: x_return_status := FND_API.G_RET_STS_SUCCESS;

161:
162: END IF;
163:
164: -- Initialize the return status to success
165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166:
167: -- Assign the input record to the local variable
168: l_assignment_rec := p_assignment_rec;
169:

Line 187: IF p_asgn_creation_mode = 'COPY' AND (l_assignment_rec.assignment_template_id IS NULL OR l_assignment_rec.assignment_template_id = FND_API.G_MISS_NUM) THEN

183: --in that case use the status from the template requirement.
184:
185: l_source_assignment_id := l_assignment_rec.source_assignment_id;
186:
187: IF p_asgn_creation_mode = 'COPY' AND (l_assignment_rec.assignment_template_id IS NULL OR l_assignment_rec.assignment_template_id = FND_API.G_MISS_NUM) THEN
188:
189: l_assignment_rec.source_assignment_id := NULL;
190:
191: --get the default starting requirement status.

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

197: IF l_assignment_rec.status_code IS NULL THEN
198:
199: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
200: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
201: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
202:
203: END IF;
204:
205: END IF; --asgn creation mode is copy.

Line 215: IF (p_assignment_rec.project_id IS NULL OR p_assignment_rec.project_id = FND_API.G_MISS_NUM) AND

211:
212: --
213: -- Check that mandatory project id exists if this is not a template requirement.
214: --
215: IF (p_assignment_rec.project_id IS NULL OR p_assignment_rec.project_id = FND_API.G_MISS_NUM) AND
216: (p_assignment_rec.assignment_template_id IS NULL OR p_assignment_rec.assignment_template_id = FND_API.G_MISS_NUM) THEN
217: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
218: ,p_msg_name => 'PA_PROJ_ID_REQUIRED_FOR_ASGN'
219: ,p_token1 => 'ASGNTYPE'

Line 216: (p_assignment_rec.assignment_template_id IS NULL OR p_assignment_rec.assignment_template_id = FND_API.G_MISS_NUM) THEN

212: --
213: -- Check that mandatory project id exists if this is not a template requirement.
214: --
215: IF (p_assignment_rec.project_id IS NULL OR p_assignment_rec.project_id = FND_API.G_MISS_NUM) AND
216: (p_assignment_rec.assignment_template_id IS NULL OR p_assignment_rec.assignment_template_id = FND_API.G_MISS_NUM) THEN
217: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
218: ,p_msg_name => 'PA_PROJ_ID_REQUIRED_FOR_ASGN'
219: ,p_token1 => 'ASGNTYPE'
220: ,p_value1 => l_req_text);

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

217: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
218: ,p_msg_name => 'PA_PROJ_ID_REQUIRED_FOR_ASGN'
219: ,p_token1 => 'ASGNTYPE'
220: ,p_value1 => l_req_text);
221: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
222: END IF;
223:
224: --
225: -- Check that mandatory assignment name exists

Line 228: p_assignment_rec.assignment_name = FND_API.G_MISS_CHAR THEN

224: --
225: -- Check that mandatory assignment name exists
226: --
227: IF p_assignment_rec.assignment_name IS NULL OR
228: p_assignment_rec.assignment_name = FND_API.G_MISS_CHAR THEN
229: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
230: ,p_msg_name => 'PA_NAME_REQUIRED_FOR_ASGN');
231: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
232: END IF;

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

227: IF p_assignment_rec.assignment_name IS NULL OR
228: p_assignment_rec.assignment_name = FND_API.G_MISS_CHAR THEN
229: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
230: ,p_msg_name => 'PA_NAME_REQUIRED_FOR_ASGN');
231: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
232: END IF;
233:
234: --
235: -- Check valid starting status

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

238: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
239: ,p_msg_name => 'PA_INVALID_ASGN_STARTING_STUS'
240: ,p_token1 => 'ASGNTYPE'
241: ,p_value1 => l_req_text);
242: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
243: END IF;
244:
245: --
246: -- Check that mandatory project role exists

Line 249: OR p_assignment_rec.project_role_id = FND_API.G_MISS_NUM THEN

245: --
246: -- Check that mandatory project role exists
247: --
248: IF p_assignment_rec.project_role_id IS NULL
249: OR p_assignment_rec.project_role_id = FND_API.G_MISS_NUM THEN
250: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
251: ,p_msg_name => 'PA_PROJ_ROLE_REQUIRED_FOR_ASGN'
252: ,p_token1 => 'ASGNTYPE'
253: ,p_value1 => l_req_text);

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

250: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
251: ,p_msg_name => 'PA_PROJ_ROLE_REQUIRED_FOR_ASGN'
252: ,p_token1 => 'ASGNTYPE'
253: ,p_value1 => l_req_text);
254: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
255: END IF;
256:
257: --if the new requirement is being copied from a requirement or a template
258: --requirement then get the competencies from the source requirement

Line 262: AND l_source_assignment_id <> FND_API.G_MISS_NUM

258: --requirement then get the competencies from the source requirement
259: --otherwise get the competencies from the role.
260: -- Bug 2401916: ADDED COMPETENCE IN THE BASE REQ. IS NOT GETTING COPIED
261: IF l_source_assignment_id IS NOT NULL
262: AND l_source_assignment_id <> FND_API.G_MISS_NUM
263: AND l_assignment_rec.source_assignment_type = 'OPEN_ASSIGNMENT' THEN
264:
265: PA_HR_COMPETENCE_UTILS.get_competencies(p_object_name => 'OPEN_ASSIGNMENT',
266: p_object_id => l_source_assignment_id,

Line 272: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

268: x_no_of_competencies => l_no_of_competencies,
269: x_error_message_code => l_error_message_code,
270: x_return_status => l_return_status);
271:
272: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
273: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
274: ,p_msg_name => l_error_message_code );
275: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
276: END IF;

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

271:
272: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
273: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
274: ,p_msg_name => l_error_message_code );
275: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
276: END IF;
277:
278: ELSE
279:

Line 294: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

290: ,x_def_competencies => l_competencies_tbl
291: ,x_return_status => l_return_status
292: ,x_error_message_code => l_error_message_code );
293:
294: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
295:
296: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
297: ,p_msg_name => l_error_message_code );
298: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

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

294: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
295:
296: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
297: ,p_msg_name => l_error_message_code );
298: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
299: END IF;
300:
301: IF l_schedulable_flag <> 'Y' THEN
302:

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

301: IF l_schedulable_flag <> 'Y' THEN
302:
303: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
304: ,p_msg_name => 'PA_ROLE_NOT_SCHEDULABLE' );
305: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
306: return;
307: END IF;
308:
309: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 309: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

305: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
306: return;
307: END IF;
308:
309: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
310: IF l_assignment_rec.min_resource_job_level IS NULL
311: OR l_assignment_rec.min_resource_job_level = FND_API.G_MISS_NUM THEN
312: l_assignment_rec.min_resource_job_level := l_def_min_resource_job_level;
313: END IF;

Line 311: OR l_assignment_rec.min_resource_job_level = FND_API.G_MISS_NUM THEN

307: END IF;
308:
309: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
310: IF l_assignment_rec.min_resource_job_level IS NULL
311: OR l_assignment_rec.min_resource_job_level = FND_API.G_MISS_NUM THEN
312: l_assignment_rec.min_resource_job_level := l_def_min_resource_job_level;
313: END IF;
314: --
315: IF l_assignment_rec.max_resource_job_level IS NULL

Line 316: OR l_assignment_rec.max_resource_job_level = FND_API.G_MISS_NUM THEN

312: l_assignment_rec.min_resource_job_level := l_def_min_resource_job_level;
313: END IF;
314: --
315: IF l_assignment_rec.max_resource_job_level IS NULL
316: OR l_assignment_rec.max_resource_job_level = FND_API.G_MISS_NUM THEN
317: l_assignment_rec.max_resource_job_level := l_def_max_resource_job_level;
318: END IF;
319:
320: -- 5130421 : It is possible to null out the job so remove the null check

Line 322: l_assignment_rec.fcst_job_id = FND_API.G_MISS_NUM THEN

318: END IF;
319:
320: -- 5130421 : It is possible to null out the job so remove the null check
321: IF --l_assignment_rec.fcst_job_id IS NULL
322: l_assignment_rec.fcst_job_id = FND_API.G_MISS_NUM THEN
323: l_assignment_rec.fcst_job_id := l_fcst_job_id_tmp;
324: END IF;
325: END IF;
326: END IF;

Line 334: (l_assignment_rec.expenditure_type = FND_API.G_MISS_CHAR) OR

330: --IF it is copying from an assignment into a requirement AND
331: --IF IT IS NOT a template requirement.
332:
333: IF (((l_assignment_rec.expenditure_type IS NULL) OR
334: (l_assignment_rec.expenditure_type = FND_API.G_MISS_CHAR) OR
335: (p_asgn_creation_mode <> 'COPY') OR
336: (p_asgn_creation_mode = 'COPY' AND l_assignment_rec.source_assignment_type <> 'OPEN_ASSIGNMENT')) AND
337: (l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM))THEN
338:

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

333: IF (((l_assignment_rec.expenditure_type IS NULL) OR
334: (l_assignment_rec.expenditure_type = FND_API.G_MISS_CHAR) OR
335: (p_asgn_creation_mode <> 'COPY') OR
336: (p_asgn_creation_mode = 'COPY' AND l_assignment_rec.source_assignment_type <> 'OPEN_ASSIGNMENT')) AND
337: (l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM))THEN
338:
339: --dbms_output.put_line('calling assignment default');
340: --Log Message
341: IF (P_DEBUG_MODE = 'Y') THEN

Line 367: IF l_assignment_rec.work_type_id IS NOT NULL AND l_assignment_rec.work_type_id <> FND_API.G_MISS_NUM THEN

363: );
364: -- Bug 5130421
365: -- fcst tp amount type shd get default from work type
366: -- it was getting default from the default work type
367: IF l_assignment_rec.work_type_id IS NOT NULL AND l_assignment_rec.work_type_id <> FND_API.G_MISS_NUM THEN
368: Pa_Fp_Org_Fcst_Utils.Get_Tp_Amount_Type(
369: p_project_id => l_assignment_rec.project_id,
370: p_work_type_id => l_assignment_rec.work_type_id,
371: x_tp_amount_type => l_fcst_tp_amount_type_tmp,

Line 376: l_assignment_rec.fcst_tp_amount_type = FND_API.G_MISS_CHAR) THEN

372: x_return_status => l_return_status,
373: x_msg_count => l_msg_count,
374: x_msg_data => l_msg_data);
375: IF (l_assignment_rec.fcst_tp_amount_type IS NULL OR
376: l_assignment_rec.fcst_tp_amount_type = FND_API.G_MISS_CHAR) THEN
377: l_assignment_rec.fcst_tp_amount_type := l_fcst_tp_amount_type_tmp;
378: END IF;
379: ELSE
380: IF (l_assignment_rec.fcst_tp_amount_type IS NULL OR

Line 381: l_assignment_rec.fcst_tp_amount_type = FND_API.G_MISS_CHAR) THEN

377: l_assignment_rec.fcst_tp_amount_type := l_fcst_tp_amount_type_tmp;
378: END IF;
379: ELSE
380: IF (l_assignment_rec.fcst_tp_amount_type IS NULL OR
381: l_assignment_rec.fcst_tp_amount_type = FND_API.G_MISS_CHAR) THEN
382: l_assignment_rec.fcst_tp_amount_type := l_fcst_tp_amount_type_tmp;
383: END IF;
384: END IF;
385: -- 5130421 : It is possible to null out the job and job group so remove the null check

Line 387: l_assignment_rec.fcst_job_group_id = FND_API.G_MISS_NUM) THEN

383: END IF;
384: END IF;
385: -- 5130421 : It is possible to null out the job and job group so remove the null check
386: IF (--l_assignment_rec.fcst_job_group_id IS NULL OR
387: l_assignment_rec.fcst_job_group_id = FND_API.G_MISS_NUM) THEN
388: l_assignment_rec.fcst_job_group_id := l_fcst_job_group_id_tmp;
389: END IF;
390: IF (--l_assignment_rec.fcst_job_id IS NULL OR
391: l_assignment_rec.fcst_job_id = FND_API.G_MISS_NUM) THEN

Line 391: l_assignment_rec.fcst_job_id = FND_API.G_MISS_NUM) THEN

387: l_assignment_rec.fcst_job_group_id = FND_API.G_MISS_NUM) THEN
388: l_assignment_rec.fcst_job_group_id := l_fcst_job_group_id_tmp;
389: END IF;
390: IF (--l_assignment_rec.fcst_job_id IS NULL OR
391: l_assignment_rec.fcst_job_id = FND_API.G_MISS_NUM) THEN
392: l_assignment_rec.fcst_job_id := l_fcst_job_id_tmp;
393: END IF;
394: IF (l_assignment_rec.expenditure_org_id IS NULL OR
395: l_assignment_rec.expenditure_org_id = FND_API.G_MISS_NUM) THEN

Line 395: l_assignment_rec.expenditure_org_id = FND_API.G_MISS_NUM) THEN

391: l_assignment_rec.fcst_job_id = FND_API.G_MISS_NUM) THEN
392: l_assignment_rec.fcst_job_id := l_fcst_job_id_tmp;
393: END IF;
394: IF (l_assignment_rec.expenditure_org_id IS NULL OR
395: l_assignment_rec.expenditure_org_id = FND_API.G_MISS_NUM) THEN
396: l_assignment_rec.expenditure_org_id := l_exp_org_id_tmp;
397: END IF;
398: IF (l_assignment_rec.expenditure_organization_id IS NULL OR
399: l_assignment_rec.expenditure_organization_id = FND_API.G_MISS_NUM) THEN

Line 399: l_assignment_rec.expenditure_organization_id = FND_API.G_MISS_NUM) THEN

395: l_assignment_rec.expenditure_org_id = FND_API.G_MISS_NUM) THEN
396: l_assignment_rec.expenditure_org_id := l_exp_org_id_tmp;
397: END IF;
398: IF (l_assignment_rec.expenditure_organization_id IS NULL OR
399: l_assignment_rec.expenditure_organization_id = FND_API.G_MISS_NUM) THEN
400: l_assignment_rec.expenditure_organization_id := l_expenditure_org_id_tmp;
401: END IF;
402: IF (l_assignment_rec.expenditure_type IS NULL OR
403: l_assignment_rec.expenditure_type = FND_API.G_MISS_CHAR) THEN

Line 403: l_assignment_rec.expenditure_type = FND_API.G_MISS_CHAR) THEN

399: l_assignment_rec.expenditure_organization_id = FND_API.G_MISS_NUM) THEN
400: l_assignment_rec.expenditure_organization_id := l_expenditure_org_id_tmp;
401: END IF;
402: IF (l_assignment_rec.expenditure_type IS NULL OR
403: l_assignment_rec.expenditure_type = FND_API.G_MISS_CHAR) THEN
404: l_assignment_rec.expenditure_type := l_expenditure_type_tmp;
405: END IF;
406: IF (l_assignment_rec.expenditure_type_class IS NULL OR
407: l_assignment_rec.expenditure_type_class = FND_API.G_MISS_CHAR) THEN

Line 407: l_assignment_rec.expenditure_type_class = FND_API.G_MISS_CHAR) THEN

403: l_assignment_rec.expenditure_type = FND_API.G_MISS_CHAR) THEN
404: l_assignment_rec.expenditure_type := l_expenditure_type_tmp;
405: END IF;
406: IF (l_assignment_rec.expenditure_type_class IS NULL OR
407: l_assignment_rec.expenditure_type_class = FND_API.G_MISS_CHAR) THEN
408: l_assignment_rec.expenditure_type_class := l_expenditure_type_class_tmp;
409: END IF;
410:
411: --dbms_output.put_line('after assignment default:'|| l_return_status);

Line 412: --IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

408: l_assignment_rec.expenditure_type_class := l_expenditure_type_class_tmp;
409: END IF;
410:
411: --dbms_output.put_line('after assignment default:'|| l_return_status);
412: --IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
413: -- PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
414: --ELSE
415:
416: END IF;

Line 413: -- PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

409: END IF;
410:
411: --dbms_output.put_line('after assignment default:'|| l_return_status);
412: --IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
413: -- PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
414: --ELSE
415:
416: END IF;
417:

Line 422: IF l_assignment_rec.fcst_job_id IS NOT NULL AND l_assignment_rec.fcst_job_id <> FND_API.G_MISS_NUM AND

418: --
419: -- Get bill rate and bill rate currency code, and markup percent
420: -- Call this API only if the required parameters are present.
421: -- Note: expenditure_org_id(OU) can be NULL in the case of single org
422: IF l_assignment_rec.fcst_job_id IS NOT NULL AND l_assignment_rec.fcst_job_id <> FND_API.G_MISS_NUM AND
423: l_assignment_rec.fcst_job_group_id IS NOT NULL AND l_assignment_rec.fcst_job_group_id <> FND_API.G_MISS_NUM AND
424: l_assignment_rec.expenditure_organization_id IS NOT NULL AND l_assignment_rec.expenditure_organization_id <> FND_API.G_MISS_NUM THEN
425:
426: --Log Message

Line 423: l_assignment_rec.fcst_job_group_id IS NOT NULL AND l_assignment_rec.fcst_job_group_id <> FND_API.G_MISS_NUM AND

419: -- Get bill rate and bill rate currency code, and markup percent
420: -- Call this API only if the required parameters are present.
421: -- Note: expenditure_org_id(OU) can be NULL in the case of single org
422: IF l_assignment_rec.fcst_job_id IS NOT NULL AND l_assignment_rec.fcst_job_id <> FND_API.G_MISS_NUM AND
423: l_assignment_rec.fcst_job_group_id IS NOT NULL AND l_assignment_rec.fcst_job_group_id <> FND_API.G_MISS_NUM AND
424: l_assignment_rec.expenditure_organization_id IS NOT NULL AND l_assignment_rec.expenditure_organization_id <> FND_API.G_MISS_NUM THEN
425:
426: --Log Message
427: IF (P_DEBUG_MODE = 'Y') THEN

Line 424: l_assignment_rec.expenditure_organization_id IS NOT NULL AND l_assignment_rec.expenditure_organization_id <> FND_API.G_MISS_NUM THEN

420: -- Call this API only if the required parameters are present.
421: -- Note: expenditure_org_id(OU) can be NULL in the case of single org
422: IF l_assignment_rec.fcst_job_id IS NOT NULL AND l_assignment_rec.fcst_job_id <> FND_API.G_MISS_NUM AND
423: l_assignment_rec.fcst_job_group_id IS NOT NULL AND l_assignment_rec.fcst_job_group_id <> FND_API.G_MISS_NUM AND
424: l_assignment_rec.expenditure_organization_id IS NOT NULL AND l_assignment_rec.expenditure_organization_id <> FND_API.G_MISS_NUM THEN
425:
426: --Log Message
427: IF (P_DEBUG_MODE = 'Y') THEN
428: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

Line 463: IF (p_assignment_rec.resource_list_member_id = FND_API.G_MISS_NUM OR

459: ,x_msg => 'FP.M Development'
460: ,x_log_level => li_message_level);
461: END IF;
462:
463: IF (p_assignment_rec.resource_list_member_id = FND_API.G_MISS_NUM OR
464: p_assignment_rec.resource_list_member_id IS NULL) AND
465: p_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN
466: SELECT proj_req_res_format_id
467: INTO l_proj_req_res_format_id

Line 465: p_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN

461: END IF;
462:
463: IF (p_assignment_rec.resource_list_member_id = FND_API.G_MISS_NUM OR
464: p_assignment_rec.resource_list_member_id IS NULL) AND
465: p_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN
466: SELECT proj_req_res_format_id
467: INTO l_proj_req_res_format_id
468: FROM PA_PROJECTS_ALL
469: WHERE project_id = p_assignment_rec.project_id;

Line 472: IF l_fcst_job_id_tmp = FND_API.G_MISS_NUM THEN

468: FROM PA_PROJECTS_ALL
469: WHERE project_id = p_assignment_rec.project_id;
470:
471: l_fcst_job_id_tmp := l_assignment_rec.fcst_job_id;
472: IF l_fcst_job_id_tmp = FND_API.G_MISS_NUM THEN
473: l_fcst_job_id_tmp := NULL;
474: END IF;
475:
476: l_expenditure_org_id_tmp := l_assignment_rec.expenditure_organization_id;

Line 477: IF l_expenditure_org_id_tmp = FND_API.G_MISS_NUM THEN

473: l_fcst_job_id_tmp := NULL;
474: END IF;
475:
476: l_expenditure_org_id_tmp := l_assignment_rec.expenditure_organization_id;
477: IF l_expenditure_org_id_tmp = FND_API.G_MISS_NUM THEN
478: l_expenditure_org_id_tmp := NULL;
479: END IF;
480:
481: l_expenditure_type_tmp := l_assignment_rec.expenditure_type;

Line 482: IF l_expenditure_type_tmp = FND_API.G_MISS_CHAR THEN

478: l_expenditure_org_id_tmp := NULL;
479: END IF;
480:
481: l_expenditure_type_tmp := l_assignment_rec.expenditure_type;
482: IF l_expenditure_type_tmp = FND_API.G_MISS_CHAR THEN
483: l_expenditure_type_tmp := NULL;
484: END IF;
485:
486: l_project_role_id_tmp := l_assignment_rec.project_role_id;

Line 487: IF l_project_role_id_tmp = FND_API.G_MISS_NUM THEN

483: l_expenditure_type_tmp := NULL;
484: END IF;
485:
486: l_project_role_id_tmp := l_assignment_rec.project_role_id;
487: IF l_project_role_id_tmp = FND_API.G_MISS_NUM THEN
488: l_project_role_id_tmp := NULL;
489: END IF;
490:
491: l_assignment_name_tmp := l_assignment_rec.assignment_name;

Line 492: IF l_assignment_name_tmp = FND_API.G_MISS_CHAR THEN

488: l_project_role_id_tmp := NULL;
489: END IF;
490:
491: l_assignment_name_tmp := l_assignment_rec.assignment_name;
492: IF l_assignment_name_tmp = FND_API.G_MISS_CHAR THEN
493: l_assignment_name_tmp := NULL;
494: END IF;
495:
496: IF P_DEBUG_MODE = 'Y' THEN

Line 531: OR l_assignment_rec.work_type_id = FND_API.G_MISS_NUM

527: --
528: --Check p_work_type_id IS NOT NULL
529: --
530: IF l_assignment_rec.work_type_id IS NULL
531: OR l_assignment_rec.work_type_id = FND_API.G_MISS_NUM
532: OR l_assignment_rec.work_type_id = 0 THEN
533: --dbms_output.put_line('WORK TYPE INVALID');
534: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
535: ,p_msg_name => 'PA_WORK_TYPE_REQUIRED_FOR_ASGN' );

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

532: OR l_assignment_rec.work_type_id = 0 THEN
533: --dbms_output.put_line('WORK TYPE INVALID');
534: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
535: ,p_msg_name => 'PA_WORK_TYPE_REQUIRED_FOR_ASGN' );
536: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
537:
538: ELSIF l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN
539: --
540: --check for indirect project, only non-billable work types if this is NOT

Line 538: ELSIF l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN

534: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
535: ,p_msg_name => 'PA_WORK_TYPE_REQUIRED_FOR_ASGN' );
536: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
537:
538: ELSIF l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN
539: --
540: --check for indirect project, only non-billable work types if this is NOT
541: --a template requirement
542: PA_WORK_TYPE_UTILS.CHECK_WORK_TYPE (

Line 548: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

544: ,P_PROJECT_ID => l_assignment_rec.project_id
545: ,P_TASK_ID => NULL
546: ,X_RETURN_STATUS => l_return_status
547: ,X_ERROR_MESSAGE_CODE => l_error_message_code);
548: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
549: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
550: ,p_msg_name => l_error_message_code );
551: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
552: END IF;

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

547: ,X_ERROR_MESSAGE_CODE => l_error_message_code);
548: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
549: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
550: ,p_msg_name => l_error_message_code );
551: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
552: END IF;
553:
554: END IF;
555:

Line 567: IF (l_assignment_rec.location_id IS NULL OR l_assignment_rec.location_id = FND_API.G_MISS_NUM)

563: -- If all the location input parameters are null then default location from project
564: -- If location details are passed then get the location id for the for the given location parameters
565: -- If the location does not already exist then create it
566: --
567: IF (l_assignment_rec.location_id IS NULL OR l_assignment_rec.location_id = FND_API.G_MISS_NUM)
568: AND (p_location_city IS NULL OR p_location_city = FND_API.G_MISS_CHAR)
569: AND (p_location_region IS NULL OR p_location_region = FND_API.G_MISS_CHAR)
570: AND (p_location_country_code IS NULL OR p_location_country_code = FND_API.G_MISS_CHAR)
571: AND (l_assignment_rec.project_id IS NOT NULL and l_assignment_rec.project_id <> FND_API.G_MISS_NUM)

Line 568: AND (p_location_city IS NULL OR p_location_city = FND_API.G_MISS_CHAR)

564: -- If location details are passed then get the location id for the for the given location parameters
565: -- If the location does not already exist then create it
566: --
567: IF (l_assignment_rec.location_id IS NULL OR l_assignment_rec.location_id = FND_API.G_MISS_NUM)
568: AND (p_location_city IS NULL OR p_location_city = FND_API.G_MISS_CHAR)
569: AND (p_location_region IS NULL OR p_location_region = FND_API.G_MISS_CHAR)
570: AND (p_location_country_code IS NULL OR p_location_country_code = FND_API.G_MISS_CHAR)
571: AND (l_assignment_rec.project_id IS NOT NULL and l_assignment_rec.project_id <> FND_API.G_MISS_NUM)
572: THEN

Line 569: AND (p_location_region IS NULL OR p_location_region = FND_API.G_MISS_CHAR)

565: -- If the location does not already exist then create it
566: --
567: IF (l_assignment_rec.location_id IS NULL OR l_assignment_rec.location_id = FND_API.G_MISS_NUM)
568: AND (p_location_city IS NULL OR p_location_city = FND_API.G_MISS_CHAR)
569: AND (p_location_region IS NULL OR p_location_region = FND_API.G_MISS_CHAR)
570: AND (p_location_country_code IS NULL OR p_location_country_code = FND_API.G_MISS_CHAR)
571: AND (l_assignment_rec.project_id IS NOT NULL and l_assignment_rec.project_id <> FND_API.G_MISS_NUM)
572: THEN
573:

Line 570: AND (p_location_country_code IS NULL OR p_location_country_code = FND_API.G_MISS_CHAR)

566: --
567: IF (l_assignment_rec.location_id IS NULL OR l_assignment_rec.location_id = FND_API.G_MISS_NUM)
568: AND (p_location_city IS NULL OR p_location_city = FND_API.G_MISS_CHAR)
569: AND (p_location_region IS NULL OR p_location_region = FND_API.G_MISS_CHAR)
570: AND (p_location_country_code IS NULL OR p_location_country_code = FND_API.G_MISS_CHAR)
571: AND (l_assignment_rec.project_id IS NOT NULL and l_assignment_rec.project_id <> FND_API.G_MISS_NUM)
572: THEN
573:
574: --Bug 1795160: no need to get location from project, location not required

Line 571: AND (l_assignment_rec.project_id IS NOT NULL and l_assignment_rec.project_id <> FND_API.G_MISS_NUM)

567: IF (l_assignment_rec.location_id IS NULL OR l_assignment_rec.location_id = FND_API.G_MISS_NUM)
568: AND (p_location_city IS NULL OR p_location_city = FND_API.G_MISS_CHAR)
569: AND (p_location_region IS NULL OR p_location_region = FND_API.G_MISS_CHAR)
570: AND (p_location_country_code IS NULL OR p_location_country_code = FND_API.G_MISS_CHAR)
571: AND (l_assignment_rec.project_id IS NOT NULL and l_assignment_rec.project_id <> FND_API.G_MISS_NUM)
572: THEN
573:
574: --Bug 1795160: no need to get location from project, location not required
575: /*

Line 591: ELSIF l_assignment_rec.location_id IS NULL OR l_assignment_rec.location_id = FND_API.G_MISS_NUM THEN

587:
588:
589:
590: --only call get_location if location_id IS NULL
591: ELSIF l_assignment_rec.location_id IS NULL OR l_assignment_rec.location_id = FND_API.G_MISS_NUM THEN
592:
593: PA_LOCATION_UTILS.Get_Location( p_city => p_location_city
594: ,p_region => p_location_region
595: ,p_country_code => p_location_country_code

Line 600: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

596: ,x_location_id => l_assignment_rec.location_id
597: ,x_error_message_code => l_error_message_code
598: ,x_return_status => l_return_status );
599:
600: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
601: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
602: ,p_msg_name => l_error_message_code );
603: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
604: END IF;

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

599:
600: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
601: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
602: ,p_msg_name => l_error_message_code );
603: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
604: END IF;
605:
606: END IF;
607:

Line 611: IF l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN

607:
608: --get defaults from project when a requirement (not template
609: --requirement) is being either newly created
610: --or created(copied) from an assignment
611: IF l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN
612:
613: OPEN get_project_info;
614: FETCH get_project_info INTO l_calendar_id,
615: l_comp_match_weighting,

Line 635: IF l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM

631: -- use candidate and search settings defaulted from the project
632:
633: -- FP.M Development: Default the following attributes when
634: -- l_assignment_rec.resource_list_member_id IS NOT NULL
635: IF l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM
636: AND (l_assignment_rec.comp_match_weighting IS NULL OR l_assignment_rec.comp_match_weighting = FND_API.G_MISS_NUM OR l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM)
637: AND PA_STARTUP.G_Calling_Application <> 'PLSQL' -- Bug 5130421 : added PLSQL check
638: THEN
639: l_assignment_rec.comp_match_weighting := l_comp_match_weighting;

Line 636: AND (l_assignment_rec.comp_match_weighting IS NULL OR l_assignment_rec.comp_match_weighting = FND_API.G_MISS_NUM OR l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM)

632:
633: -- FP.M Development: Default the following attributes when
634: -- l_assignment_rec.resource_list_member_id IS NOT NULL
635: IF l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM
636: AND (l_assignment_rec.comp_match_weighting IS NULL OR l_assignment_rec.comp_match_weighting = FND_API.G_MISS_NUM OR l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM)
637: AND PA_STARTUP.G_Calling_Application <> 'PLSQL' -- Bug 5130421 : added PLSQL check
638: THEN
639: l_assignment_rec.comp_match_weighting := l_comp_match_weighting;
640: l_assignment_rec.avail_match_weighting := l_avail_match_weighting;

Line 649: ELSIF PA_STARTUP.G_Calling_Application = 'PLSQL' AND l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM

645: l_assignment_rec.search_country_code := l_search_country_code;
646: l_assignment_rec.search_min_candidate_score := l_search_min_candidate_score;
647: l_assignment_rec.enable_auto_cand_nom_flag := l_enable_auto_cand_nom_flag; -- Changed 'Y' to l_enable_auto_cand_nom_flag for bug 4306049;
648: -- Bug 5130421 Added ELSIF
649: ELSIF PA_STARTUP.G_Calling_Application = 'PLSQL' AND l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM
650: THEN
651: IF l_assignment_rec.comp_match_weighting IS NULL OR l_assignment_rec.comp_match_weighting = FND_API.G_MISS_NUM THEN
652: l_assignment_rec.comp_match_weighting := l_comp_match_weighting;
653: END IF;

Line 651: IF l_assignment_rec.comp_match_weighting IS NULL OR l_assignment_rec.comp_match_weighting = FND_API.G_MISS_NUM THEN

647: l_assignment_rec.enable_auto_cand_nom_flag := l_enable_auto_cand_nom_flag; -- Changed 'Y' to l_enable_auto_cand_nom_flag for bug 4306049;
648: -- Bug 5130421 Added ELSIF
649: ELSIF PA_STARTUP.G_Calling_Application = 'PLSQL' AND l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM
650: THEN
651: IF l_assignment_rec.comp_match_weighting IS NULL OR l_assignment_rec.comp_match_weighting = FND_API.G_MISS_NUM THEN
652: l_assignment_rec.comp_match_weighting := l_comp_match_weighting;
653: END IF;
654: IF l_assignment_rec.avail_match_weighting IS NULL OR l_assignment_rec.avail_match_weighting = FND_API.G_MISS_NUM THEN
655: l_assignment_rec.avail_match_weighting := l_avail_match_weighting;

Line 654: IF l_assignment_rec.avail_match_weighting IS NULL OR l_assignment_rec.avail_match_weighting = FND_API.G_MISS_NUM THEN

650: THEN
651: IF l_assignment_rec.comp_match_weighting IS NULL OR l_assignment_rec.comp_match_weighting = FND_API.G_MISS_NUM THEN
652: l_assignment_rec.comp_match_weighting := l_comp_match_weighting;
653: END IF;
654: IF l_assignment_rec.avail_match_weighting IS NULL OR l_assignment_rec.avail_match_weighting = FND_API.G_MISS_NUM THEN
655: l_assignment_rec.avail_match_weighting := l_avail_match_weighting;
656: END IF;
657: IF l_assignment_rec.job_level_match_weighting IS NULL OR l_assignment_rec.job_level_match_weighting = FND_API.G_MISS_NUM THEN
658: l_assignment_rec.job_level_match_weighting := l_job_level_match_weighting;

Line 657: IF l_assignment_rec.job_level_match_weighting IS NULL OR l_assignment_rec.job_level_match_weighting = FND_API.G_MISS_NUM THEN

653: END IF;
654: IF l_assignment_rec.avail_match_weighting IS NULL OR l_assignment_rec.avail_match_weighting = FND_API.G_MISS_NUM THEN
655: l_assignment_rec.avail_match_weighting := l_avail_match_weighting;
656: END IF;
657: IF l_assignment_rec.job_level_match_weighting IS NULL OR l_assignment_rec.job_level_match_weighting = FND_API.G_MISS_NUM THEN
658: l_assignment_rec.job_level_match_weighting := l_job_level_match_weighting;
659: END IF;
660: IF l_assignment_rec.search_min_availability IS NULL OR l_assignment_rec.search_min_availability = FND_API.G_MISS_NUM THEN
661: l_assignment_rec.search_min_availability := l_search_min_availability;

Line 660: IF l_assignment_rec.search_min_availability IS NULL OR l_assignment_rec.search_min_availability = FND_API.G_MISS_NUM THEN

656: END IF;
657: IF l_assignment_rec.job_level_match_weighting IS NULL OR l_assignment_rec.job_level_match_weighting = FND_API.G_MISS_NUM THEN
658: l_assignment_rec.job_level_match_weighting := l_job_level_match_weighting;
659: END IF;
660: IF l_assignment_rec.search_min_availability IS NULL OR l_assignment_rec.search_min_availability = FND_API.G_MISS_NUM THEN
661: l_assignment_rec.search_min_availability := l_search_min_availability;
662: END IF;
663: IF l_assignment_rec.search_exp_org_struct_ver_id IS NULL OR l_assignment_rec.search_exp_org_struct_ver_id = FND_API.G_MISS_NUM THEN
664: l_assignment_rec.search_exp_org_struct_ver_id := l_search_exp_org_struct_ver_id;

Line 663: IF l_assignment_rec.search_exp_org_struct_ver_id IS NULL OR l_assignment_rec.search_exp_org_struct_ver_id = FND_API.G_MISS_NUM THEN

659: END IF;
660: IF l_assignment_rec.search_min_availability IS NULL OR l_assignment_rec.search_min_availability = FND_API.G_MISS_NUM THEN
661: l_assignment_rec.search_min_availability := l_search_min_availability;
662: END IF;
663: IF l_assignment_rec.search_exp_org_struct_ver_id IS NULL OR l_assignment_rec.search_exp_org_struct_ver_id = FND_API.G_MISS_NUM THEN
664: l_assignment_rec.search_exp_org_struct_ver_id := l_search_exp_org_struct_ver_id;
665: END IF;
666: IF l_assignment_rec.search_exp_start_org_id IS NULL OR l_assignment_rec.search_exp_start_org_id = FND_API.G_MISS_NUM THEN
667: l_assignment_rec.search_exp_start_org_id := l_search_exp_start_org_id;

Line 666: IF l_assignment_rec.search_exp_start_org_id IS NULL OR l_assignment_rec.search_exp_start_org_id = FND_API.G_MISS_NUM THEN

662: END IF;
663: IF l_assignment_rec.search_exp_org_struct_ver_id IS NULL OR l_assignment_rec.search_exp_org_struct_ver_id = FND_API.G_MISS_NUM THEN
664: l_assignment_rec.search_exp_org_struct_ver_id := l_search_exp_org_struct_ver_id;
665: END IF;
666: IF l_assignment_rec.search_exp_start_org_id IS NULL OR l_assignment_rec.search_exp_start_org_id = FND_API.G_MISS_NUM THEN
667: l_assignment_rec.search_exp_start_org_id := l_search_exp_start_org_id;
668: END IF;
669: IF l_assignment_rec.search_country_code = FND_API.G_MISS_CHAR THEN
670: -- Search country code can be null

Line 669: IF l_assignment_rec.search_country_code = FND_API.G_MISS_CHAR THEN

665: END IF;
666: IF l_assignment_rec.search_exp_start_org_id IS NULL OR l_assignment_rec.search_exp_start_org_id = FND_API.G_MISS_NUM THEN
667: l_assignment_rec.search_exp_start_org_id := l_search_exp_start_org_id;
668: END IF;
669: IF l_assignment_rec.search_country_code = FND_API.G_MISS_CHAR THEN
670: -- Search country code can be null
671: l_assignment_rec.search_country_code := l_search_country_code;
672: END IF;
673: IF l_assignment_rec.search_min_candidate_score IS NULL OR l_assignment_rec.search_min_candidate_score = FND_API.G_MISS_NUM THEN

Line 673: IF l_assignment_rec.search_min_candidate_score IS NULL OR l_assignment_rec.search_min_candidate_score = FND_API.G_MISS_NUM THEN

669: IF l_assignment_rec.search_country_code = FND_API.G_MISS_CHAR THEN
670: -- Search country code can be null
671: l_assignment_rec.search_country_code := l_search_country_code;
672: END IF;
673: IF l_assignment_rec.search_min_candidate_score IS NULL OR l_assignment_rec.search_min_candidate_score = FND_API.G_MISS_NUM THEN
674: l_assignment_rec.search_min_candidate_score := l_search_min_candidate_score;
675: END IF;
676: IF l_assignment_rec.enable_auto_cand_nom_flag IS NULL OR l_assignment_rec.enable_auto_cand_nom_flag = FND_API.G_MISS_CHAR THEN
677: l_assignment_rec.enable_auto_cand_nom_flag := 'Y';

Line 676: IF l_assignment_rec.enable_auto_cand_nom_flag IS NULL OR l_assignment_rec.enable_auto_cand_nom_flag = FND_API.G_MISS_CHAR THEN

672: END IF;
673: IF l_assignment_rec.search_min_candidate_score IS NULL OR l_assignment_rec.search_min_candidate_score = FND_API.G_MISS_NUM THEN
674: l_assignment_rec.search_min_candidate_score := l_search_min_candidate_score;
675: END IF;
676: IF l_assignment_rec.enable_auto_cand_nom_flag IS NULL OR l_assignment_rec.enable_auto_cand_nom_flag = FND_API.G_MISS_CHAR THEN
677: l_assignment_rec.enable_auto_cand_nom_flag := 'Y';
678: END IF;
679: END IF;
680:

Line 700: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg = 0 THEN

696: --
697: -- Create the Open Assignment Record
698: --
699:
700: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg = 0 THEN
701:
702: --Log Message
703: IF (P_DEBUG_MODE = 'Y') THEN
704: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment.insert_row'

Line 800: IF l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN

796:
797: --
798: -- Insert the schedule days for the open assignment
799: -- Do not create the schedule if this is a template requirement.
800: IF l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN
801:
802: IF l_source_assignment_id = FND_API.G_MISS_NUM THEN
803: l_source_assignment_id := NULL;
804: END IF;

Line 802: IF l_source_assignment_id = FND_API.G_MISS_NUM THEN

798: -- Insert the schedule days for the open assignment
799: -- Do not create the schedule if this is a template requirement.
800: IF l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN
801:
802: IF l_source_assignment_id = FND_API.G_MISS_NUM THEN
803: l_source_assignment_id := NULL;
804: END IF;
805:
806: --if this requirement is being copied from a team role then

Line 819: l_assignment_rec.assignment_template_id = FND_API.G_MISS_NUM) THEN

815: --If this requirement is being created from a template requirement (assignment template id
816: --is populated then we must pass the calendar and status because a template requirement
817: --does not have any schedule so it must be created.
818: IF p_asgn_creation_mode = 'COPY' AND (l_assignment_rec.assignment_template_id IS NULL OR
819: l_assignment_rec.assignment_template_id = FND_API.G_MISS_NUM) THEN
820:
821: IF l_source_calendar_type <> 'RESOURCE' THEN
822: l_assignment_rec.calendar_id := NULL;
823:

Line 846: IF p_assignment_rec.project_id <> FND_API.G_MISS_NUM AND

842: dbms_output.put_line('l_assignment_rec.status_code='||l_assignment_rec.status_code);
843: */
844:
845: --FP.M Development
846: IF p_assignment_rec.project_id <> FND_API.G_MISS_NUM AND
847: p_asgn_creation_mode <> 'COPY' THEN
848:
849: IF P_DEBUG_MODE = 'Y' THEN
850: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

Line 863: IF p_budget_version_id IS NOT NULL AND p_budget_version_id <> FND_API.G_MISS_NUM AND

859: ,x_msg => 'budget_version_id'||p_budget_version_id
860: ,x_log_level => li_message_level);
861: END IF;
862:
863: IF p_budget_version_id IS NOT NULL AND p_budget_version_id <> FND_API.G_MISS_NUM AND
864: l_assignment_rec.resource_list_member_id IS NOT NULL AND
865: l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM THEN
866:
867: OPEN get_bu_resource_assignments;

Line 865: l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM THEN

861: END IF;
862:
863: IF p_budget_version_id IS NOT NULL AND p_budget_version_id <> FND_API.G_MISS_NUM AND
864: l_assignment_rec.resource_list_member_id IS NOT NULL AND
865: l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM THEN
866:
867: OPEN get_bu_resource_assignments;
868: FETCH get_bu_resource_assignments
869: BULK COLLECT INTO l_task_assignment_id_tbl,

Line 906: END IF; -- IF p_assignment_rec.project_id <> FND_API.G_MISS_NUM AND

902: ,p_project_role_id => p_assignment_rec.project_role_id
903: ,x_return_status => l_return_status
904: );
905:
906: END IF; -- IF p_assignment_rec.project_id <> FND_API.G_MISS_NUM AND
907: -- p_asgn_creation_mode <> 'COPY' THEN
908:
909: PA_SCHEDULE_PVT.Create_OPN_ASG_Schedule
910: ( p_project_id => l_assignment_rec.project_id

Line 934: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

930:
931: /* Bug 3051110 - Added code to call PA_ASSIGNMENTS_PVT.Calc_Init_Transfer_Price if the l_return status is success,
932: this is to populate the TP columns in pa_project_assignments table */
933:
934: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
935:
936: IF p_debug_mode = 'Y' THEN
937: PA_DEBUG.WRITE('PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment', 'About to call .Calc_Init_Transfer_Price', 3);
938: PA_DEBUG.WRITE('PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment', 'Assignment_id is :'||l_assignment_id||' and start date:'||l_assignment_rec.start_date, 3);

Line 963: IF p_adv_action_set_id IS NOT NULL AND p_adv_action_set_id <> FND_API.G_MISS_NUM THEN

959: --
960: -- Bug 2388060 - Apply Action Set after schedule has been created
961: -- Apply the Advertisement Action Set on the non-template requirement
962: --
963: IF p_adv_action_set_id IS NOT NULL AND p_adv_action_set_id <> FND_API.G_MISS_NUM THEN
964: l_adv_action_set_id := p_adv_action_set_id;
965: END IF;
966:
967: IF p_start_adv_action_set_flag IS NOT NULL AND p_start_adv_action_set_flag <> FND_API.G_MISS_CHAR THEN

Line 967: IF p_start_adv_action_set_flag IS NOT NULL AND p_start_adv_action_set_flag <> FND_API.G_MISS_CHAR THEN

963: IF p_adv_action_set_id IS NOT NULL AND p_adv_action_set_id <> FND_API.G_MISS_NUM THEN
964: l_adv_action_set_id := p_adv_action_set_id;
965: END IF;
966:
967: IF p_start_adv_action_set_flag IS NOT NULL AND p_start_adv_action_set_flag <> FND_API.G_MISS_CHAR THEN
968: l_start_adv_action_set_flag := p_start_adv_action_set_flag;
969: END IF;
970:
971: -- set the global variable for PA_ADVERTISEMENTS_PUB

Line 1013: ,p_init_msg_list => FND_API.G_FALSE

1009: ,p_object_id => PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id
1010: ,p_perform_action_set_flag => 'Y'
1011: ,p_commit => p_commit
1012: ,p_validate_only => p_validate_only
1013: ,p_init_msg_list => FND_API.G_FALSE
1014: ,x_new_action_set_id => l_new_action_set_id
1015: ,x_return_status => l_return_status
1016: ,x_msg_count => l_msg_count
1017: ,x_msg_data => l_msg_data);

Line 1059: l_source_assignment_id <> FND_API.G_MISS_NUM AND

1055: -- 5130421 : Added G_Calling_Application check so that competencies are copied
1056: -- while creation of new requirments
1057:
1058: IF (l_source_assignment_id IS NOT NULL AND
1059: l_source_assignment_id <> FND_API.G_MISS_NUM AND
1060: l_assignment_rec.source_assignment_type = 'OPEN_ASSIGNMENT')
1061: OR (p_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM AND
1062: l_assignment_rec.source_assignment_type = 'OPEN_ASSIGNMENT')
1063: OR (p_budget_version_id IS NOT NULL AND

Line 1061: OR (p_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM AND

1057:
1058: IF (l_source_assignment_id IS NOT NULL AND
1059: l_source_assignment_id <> FND_API.G_MISS_NUM AND
1060: l_assignment_rec.source_assignment_type = 'OPEN_ASSIGNMENT')
1061: OR (p_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM AND
1062: l_assignment_rec.source_assignment_type = 'OPEN_ASSIGNMENT')
1063: OR (p_budget_version_id IS NOT NULL AND
1064: p_budget_version_id <> FND_API.G_MISS_NUM AND
1065: l_assignment_rec.resource_list_member_id IS NOT NULL AND

Line 1064: p_budget_version_id <> FND_API.G_MISS_NUM AND

1060: l_assignment_rec.source_assignment_type = 'OPEN_ASSIGNMENT')
1061: OR (p_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM AND
1062: l_assignment_rec.source_assignment_type = 'OPEN_ASSIGNMENT')
1063: OR (p_budget_version_id IS NOT NULL AND
1064: p_budget_version_id <> FND_API.G_MISS_NUM AND
1065: l_assignment_rec.resource_list_member_id IS NOT NULL AND
1066: l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM)
1067: OR (PA_STARTUP.G_Calling_Application = 'PLSQL' AND PA_STARTUP.G_Calling_module = 'AMG')
1068: THEN

Line 1066: l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM)

1062: l_assignment_rec.source_assignment_type = 'OPEN_ASSIGNMENT')
1063: OR (p_budget_version_id IS NOT NULL AND
1064: p_budget_version_id <> FND_API.G_MISS_NUM AND
1065: l_assignment_rec.resource_list_member_id IS NOT NULL AND
1066: l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM)
1067: OR (PA_STARTUP.G_Calling_Application = 'PLSQL' AND PA_STARTUP.G_Calling_module = 'AMG')
1068: THEN
1069:
1070: FOR i IN 1..l_competencies_tbl.COUNT LOOP

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

1099: PA_DEBUG.Reset_Err_Stack;
1100:
1101: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1102:
1103: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
1104:
1105: x_return_status := FND_API.G_RET_STS_ERROR;
1106:
1107: END IF;

Line 1105: x_return_status := FND_API.G_RET_STS_ERROR;

1101: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1102:
1103: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
1104:
1105: x_return_status := FND_API.G_RET_STS_ERROR;
1106:
1107: END IF;
1108:
1109:

Line 1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1119: -- Set the excetption Message and the stack
1120: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
1121: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1122: --
1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1124: RAISE; -- This is optional depending on the needs
1125: END Create_Open_Assignment;
1126:
1127:

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

1126:
1127:
1128: PROCEDURE Update_Open_Assignment
1129: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1130: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1131: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1132: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1133: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1134: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

1127:
1128: PROCEDURE Update_Open_Assignment
1129: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1130: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1131: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1132: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1133: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1134: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1135: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

1128: PROCEDURE Update_Open_Assignment
1129: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1130: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1131: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1132: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1133: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1134: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1135: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1136: )

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

1129: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1130: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1131: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1132: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1133: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1134: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1135: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1136: )
1137: IS

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

1130: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1131: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1132: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1133: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1134: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1135: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1136: )
1137: IS
1138:

Line 1324: x_return_status := FND_API.G_RET_STS_SUCCESS;

1320: END IF;
1321:
1322:
1323: -- Initialize the return status to success
1324: x_return_status := FND_API.G_RET_STS_SUCCESS;
1325:
1326: -- Assign the input record to the local variable
1327: l_assignment_rec := p_assignment_rec;
1328:

Line 1344: IF p_assignment_rec.project_role_id = FND_API.G_MISS_NUM THEN

1340: l_cur_resource_list_member_id,
1341: l_cur_project_role_id;
1342: CLOSE get_cur_asgmt_attributes;
1343:
1344: IF p_assignment_rec.project_role_id = FND_API.G_MISS_NUM THEN
1345: l_assignment_rec.project_role_id := l_cur_project_role_id;
1346: END IF;
1347:
1348: --Log Message

Line 1356: p_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN

1352: ,x_log_level => li_message_level);
1353: END IF;
1354:
1355: IF l_cur_resource_list_member_id IS NOT NULL AND
1356: p_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN
1357:
1358: -- get the mandatory attributes of planning resource
1359: OPEN get_res_mand_attributes;
1360: FETCH get_res_mand_attributes INTO

Line 1370: p_assignment_rec.resource_id <> FND_API.G_MISS_NUM AND

1366: CLOSE get_res_mand_attributes;
1367:
1368: -- check if mandatory attributes are changed
1369: IF (l_cur_res_type_flag = 'Y' AND
1370: p_assignment_rec.resource_id <> FND_API.G_MISS_NUM AND
1371: p_assignment_rec.resource_id <> l_cur_resource_id) OR
1372: (l_cur_res_type_flag = 'Y' AND
1373: p_assignment_rec.fcst_job_id <> FND_API.G_MISS_NUM AND
1374: p_assignment_rec.fcst_job_id <> l_cur_fcst_job_id) OR

Line 1373: p_assignment_rec.fcst_job_id <> FND_API.G_MISS_NUM AND

1369: IF (l_cur_res_type_flag = 'Y' AND
1370: p_assignment_rec.resource_id <> FND_API.G_MISS_NUM AND
1371: p_assignment_rec.resource_id <> l_cur_resource_id) OR
1372: (l_cur_res_type_flag = 'Y' AND
1373: p_assignment_rec.fcst_job_id <> FND_API.G_MISS_NUM AND
1374: p_assignment_rec.fcst_job_id <> l_cur_fcst_job_id) OR
1375: (l_cur_orgn_flag = 'Y' AND
1376: p_assignment_rec.expenditure_organization_id <> FND_API.G_MISS_NUM AND
1377: p_assignment_rec.expenditure_organization_id <> l_cur_exp_org_id) OR

Line 1376: p_assignment_rec.expenditure_organization_id <> FND_API.G_MISS_NUM AND

1372: (l_cur_res_type_flag = 'Y' AND
1373: p_assignment_rec.fcst_job_id <> FND_API.G_MISS_NUM AND
1374: p_assignment_rec.fcst_job_id <> l_cur_fcst_job_id) OR
1375: (l_cur_orgn_flag = 'Y' AND
1376: p_assignment_rec.expenditure_organization_id <> FND_API.G_MISS_NUM AND
1377: p_assignment_rec.expenditure_organization_id <> l_cur_exp_org_id) OR
1378: (l_cur_fin_cat_flag = 'Y' AND
1379: p_assignment_rec.expenditure_type <> FND_API.G_MISS_CHAR AND
1380: p_assignment_rec.expenditure_type <> l_cur_expenditure_type) OR

Line 1379: p_assignment_rec.expenditure_type <> FND_API.G_MISS_CHAR AND

1375: (l_cur_orgn_flag = 'Y' AND
1376: p_assignment_rec.expenditure_organization_id <> FND_API.G_MISS_NUM AND
1377: p_assignment_rec.expenditure_organization_id <> l_cur_exp_org_id) OR
1378: (l_cur_fin_cat_flag = 'Y' AND
1379: p_assignment_rec.expenditure_type <> FND_API.G_MISS_CHAR AND
1380: p_assignment_rec.expenditure_type <> l_cur_expenditure_type) OR
1381: (l_cur_role_flag = 'Y' AND
1382: p_assignment_rec.project_role_id <> FND_API.G_MISS_NUM AND
1383: p_assignment_rec.project_role_id <> l_cur_project_role_id) OR

Line 1382: p_assignment_rec.project_role_id <> FND_API.G_MISS_NUM AND

1378: (l_cur_fin_cat_flag = 'Y' AND
1379: p_assignment_rec.expenditure_type <> FND_API.G_MISS_CHAR AND
1380: p_assignment_rec.expenditure_type <> l_cur_expenditure_type) OR
1381: (l_cur_role_flag = 'Y' AND
1382: p_assignment_rec.project_role_id <> FND_API.G_MISS_NUM AND
1383: p_assignment_rec.project_role_id <> l_cur_project_role_id) OR
1384: (l_cur_role_flag = 'Y' AND
1385: p_assignment_rec.assignment_name <> FND_API.G_MISS_CHAR AND
1386: p_assignment_rec.assignment_name <> l_cur_assignment_name) THEN

Line 1385: p_assignment_rec.assignment_name <> FND_API.G_MISS_CHAR AND

1381: (l_cur_role_flag = 'Y' AND
1382: p_assignment_rec.project_role_id <> FND_API.G_MISS_NUM AND
1383: p_assignment_rec.project_role_id <> l_cur_project_role_id) OR
1384: (l_cur_role_flag = 'Y' AND
1385: p_assignment_rec.assignment_name <> FND_API.G_MISS_CHAR AND
1386: p_assignment_rec.assignment_name <> l_cur_assignment_name) THEN
1387: --Log Message
1388: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1389: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'

Line 1395: IF l_fcst_job_id_tmp = FND_API.G_MISS_NUM THEN

1391: ,x_log_level => li_message_level);
1392: END IF;
1393:
1394: l_fcst_job_id_tmp := l_assignment_rec.fcst_job_id;
1395: IF l_fcst_job_id_tmp = FND_API.G_MISS_NUM THEN
1396: l_fcst_job_id_tmp := NULL;
1397: END IF;
1398:
1399: l_expenditure_org_id_tmp := l_assignment_rec.expenditure_organization_id;

Line 1400: IF l_expenditure_org_id_tmp = FND_API.G_MISS_NUM THEN

1396: l_fcst_job_id_tmp := NULL;
1397: END IF;
1398:
1399: l_expenditure_org_id_tmp := l_assignment_rec.expenditure_organization_id;
1400: IF l_expenditure_org_id_tmp = FND_API.G_MISS_NUM THEN
1401: l_expenditure_org_id_tmp := NULL;
1402: END IF;
1403:
1404: l_expenditure_type_tmp := l_assignment_rec.expenditure_type;

Line 1405: IF l_expenditure_type_tmp = FND_API.G_MISS_CHAR THEN

1401: l_expenditure_org_id_tmp := NULL;
1402: END IF;
1403:
1404: l_expenditure_type_tmp := l_assignment_rec.expenditure_type;
1405: IF l_expenditure_type_tmp = FND_API.G_MISS_CHAR THEN
1406: l_expenditure_type_tmp := NULL;
1407: END IF;
1408:
1409: l_project_role_id_tmp := l_assignment_rec.project_role_id;

Line 1410: IF l_project_role_id_tmp = FND_API.G_MISS_NUM THEN

1406: l_expenditure_type_tmp := NULL;
1407: END IF;
1408:
1409: l_project_role_id_tmp := l_assignment_rec.project_role_id;
1410: IF l_project_role_id_tmp = FND_API.G_MISS_NUM THEN
1411: l_project_role_id_tmp := NULL;
1412: END IF;
1413:
1414: l_assignment_name_tmp := l_assignment_rec.assignment_name;

Line 1415: IF l_assignment_name_tmp = FND_API.G_MISS_CHAR THEN

1411: l_project_role_id_tmp := NULL;
1412: END IF;
1413:
1414: l_assignment_name_tmp := l_assignment_rec.assignment_name;
1415: IF l_assignment_name_tmp = FND_API.G_MISS_CHAR THEN
1416: l_assignment_name_tmp := NULL;
1417: END IF;
1418:
1419: IF P_DEBUG_MODE = 'Y' THEN

Line 1608: ,p_named_role => FND_API.G_MISS_CHAR

1604: ,p_task_version_id_tbl => l_task_version_id_tbl
1605: ,p_budget_version_id_tbl => l_budget_version_id_tbl
1606: ,p_struct_version_id_tbl => l_struct_version_id_tbl
1607: ,p_project_assignment_id => -1
1608: ,p_named_role => FND_API.G_MISS_CHAR
1609: ,x_return_status => l_return_status
1610: );
1611: END IF;
1612:

Line 1623: ELSIF p_assignment_rec.assignment_name <> FND_API.G_MISS_CHAR AND

1619:
1620: END IF; --IF l_assignment_rec.resource_list_member_id IS NOT NULL THEN
1621:
1622: -- IF mandatory attributes are NOT changed
1623: ELSIF p_assignment_rec.assignment_name <> FND_API.G_MISS_CHAR AND
1624: p_assignment_rec.assignment_name <> l_cur_assignment_name THEN
1625:
1626: --Log Message
1627: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

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

1668: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1669: ,p_msg_name => 'PA_ASGN_ID_REQUIRED_FOR_ASG'
1670: ,p_token1 => 'ASGNTYPE'
1671: ,p_value1 => l_req_text);
1672: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1673: END IF;
1674:
1675:
1676: --the following validation not required for updating an assignment.

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

1681: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1682: ,p_msg_name => 'PA_ASGN_NAME_REQUIRED_FOR_ASG'
1683: ,p_token1 => 'ASGNTYPE'
1684: ,p_value1 => l_req_text);
1685: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1686: END IF;
1687:
1688:
1689: --Status code updates and start/end date updates for TEMPLATE REQUIREMENTS ONLY are allowed through this

Line 1694: IF l_assignment_rec.project_id IS NULL or l_assignment_rec.project_id = FND_API.G_MISS_NUM THEN

1690: --API - status updates and start/end date updates to PROJECT REQUIREMENTS must go through the schedule
1691: --page. If this is a template requirement then validate the next allowable status and that
1692: --start date <= end date
1693:
1694: IF l_assignment_rec.project_id IS NULL or l_assignment_rec.project_id = FND_API.G_MISS_NUM THEN
1695:
1696: OPEN assignment_status_code_csr;
1697: FETCH assignment_status_code_csr INTO l_old_status_code
1698: ,l_old_start_date

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

1706: IF ('Y' <> PA_PROJECT_STUS_UTILS.Allow_Status_Change( o_status_code => l_old_status_code
1707: ,n_status_code => l_assignment_rec.status_code))THEN
1708: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1709: ,p_msg_name => 'PA_ASGN_INV_NEXT_STATUS_CODE');
1710: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1711: END IF;
1712:
1713: END IF;
1714:

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

1715: --start date <= end_date validation
1716: IF l_assignment_rec.start_date > l_assignment_rec.end_date THEN
1717: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1718: ,p_msg_name => 'PA_INVALID_START_DATE');
1719: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1720: END IF;
1721:
1722: END IF; --project id is null
1723: --

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

1726: IF l_assignment_rec.work_type_id IS NULL THEN
1727: --dbms_output.put_line('WORK TYPE INVALID');
1728: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1729: ,p_msg_name => 'PA_WORK_TYPE_REQUIRED_FOR_ASGN' );
1730: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1731:
1732: END IF;
1733:
1734:

Line 1742: IF (p_location_country_code IS NOT NULL AND p_location_country_code <> FND_API.G_MISS_CHAR) THEN

1738: -- Get the location id for the p_location_id for the given location parameters
1739: -- If the location does not already exsists, then create it
1740: --However, if country code is not available then no need to get_location at all.
1741:
1742: IF (p_location_country_code IS NOT NULL AND p_location_country_code <> FND_API.G_MISS_CHAR) THEN
1743:
1744: --dbms_output.put_line('location code is '||p_location_country_code);
1745: PA_LOCATION_UTILS.Get_Location( p_city => p_location_city
1746: ,p_region => p_location_region

Line 1755: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1751:
1752: --dbms_output.put_line('location id is '||l_assignment_rec.location_id);
1753: --dbms_output.put_line('return status is '||l_return_status);
1754:
1755: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1756: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
1757: ,p_msg_name => l_error_message_code );
1758: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1759: END IF;

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

1754:
1755: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1756: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
1757: ,p_msg_name => l_error_message_code );
1758: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1759: END IF;
1760: END IF;
1761:
1762: /*

Line 1765: -- l_assignment_rec.location_id = FND_API.G_MISS_NUM

1761:
1762: /*
1763: -- commenting this out for mass update
1764: -- should not null out location id if
1765: -- l_assignment_rec.location_id = FND_API.G_MISS_NUM
1766:
1767: -- for single update, if location_country_name is passed in as null
1768: -- then null out location id (in pa_assignment_pub)
1769:

Line 1772: IF l_assignment_rec.location_id = FND_API.G_MISS_NUM AND PA_STARTUP.G_Calling_Application = 'SELF_SERVICE' THEN

1768: -- then null out location id (in pa_assignment_pub)
1769:
1770: --Bug 1795160: when user empty the location fields, the location id need to be nulled out.
1771: --If in self-service mode, and still no location id by now, then set it to NULL
1772: IF l_assignment_rec.location_id = FND_API.G_MISS_NUM AND PA_STARTUP.G_Calling_Application = 'SELF_SERVICE' THEN
1773: l_assignment_rec.location_id := NULL;
1774: END IF;
1775: */
1776:

Line 1780: IF p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_FALSE

1776:
1777: --dbms_output.put_line('validate only = '||p_validate_only);
1778: --dbms_output.put_line('error exists = '||PA_ASSIGNMENTS_PUB.g_error_exists);
1779:
1780: IF p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_FALSE
1781: THEN
1782:
1783: --Log Message
1784: IF (P_DEBUG_MODE = 'Y') THEN

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

1872: PA_DEBUG.Reset_Err_Stack;
1873:
1874: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1875:
1876: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
1877:
1878: x_return_status := FND_API.G_RET_STS_ERROR;
1879:
1880: END IF;

Line 1878: x_return_status := FND_API.G_RET_STS_ERROR;

1874: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1875:
1876: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
1877:
1878: x_return_status := FND_API.G_RET_STS_ERROR;
1879:
1880: END IF;
1881:
1882: EXCEPTION

Line 1889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1885: -- Set the excetption Message and the stack
1886: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment'
1887: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1888: --
1889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1890: RAISE; -- This is optional depending on the needs
1891: END Update_Open_Assignment;
1892:
1893:

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

1893:
1894:
1895: PROCEDURE Delete_Open_Assignment
1896: ( p_assignment_row_id IN ROWID
1897: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
1898: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1899: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
1900: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1901: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

1894:
1895: PROCEDURE Delete_Open_Assignment
1896: ( p_assignment_row_id IN ROWID
1897: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
1898: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1899: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
1900: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1901: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1902: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1899: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM

1895: PROCEDURE Delete_Open_Assignment
1896: ( p_assignment_row_id IN ROWID
1897: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
1898: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1899: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
1900: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1901: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1902: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1903: )

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

1896: ( p_assignment_row_id IN ROWID
1897: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
1898: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1899: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
1900: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1901: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1902: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1903: )
1904: IS

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

1897: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
1898: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1899: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
1900: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1901: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1902: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1903: )
1904: IS
1905:

Line 1906: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1902: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1903: )
1904: IS
1905:
1906: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1907: l_msg_count NUMBER;
1908: l_msg_count_sum NUMBER;
1909: l_msg_data VARCHAR2(2000);
1910: l_competency_tbl PA_HR_COMPETENCE_UTILS.competency_tbl_typ;

Line 1938: x_return_status := FND_API.G_RET_STS_SUCCESS;

1934: ,x_log_level => li_message_level);
1935: END IF;
1936:
1937: -- Initialize the return status to success
1938: x_return_status := FND_API.G_RET_STS_SUCCESS;
1939:
1940: IF p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE THEN
1941:
1942: IF p_calling_module <> 'TEMPLATE_REQUIREMENT' THEN

Line 1940: IF p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE THEN

1936:
1937: -- Initialize the return status to success
1938: x_return_status := FND_API.G_RET_STS_SUCCESS;
1939:
1940: IF p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE THEN
1941:
1942: IF p_calling_module <> 'TEMPLATE_REQUIREMENT' THEN
1943:
1944: --Log Message

Line 1956: ,p_perm_delete => FND_API.G_TRUE --Added for bug 4389372

1952: -- unless this is a template requirement. No schedules exists for template requirements.
1953:
1954: PA_SCHEDULE_PVT.Delete_Asgn_Schedules
1955: ( p_assignment_id => p_assignment_id
1956: ,p_perm_delete => FND_API.G_TRUE --Added for bug 4389372
1957: ,x_return_status => l_return_status
1958: ,x_msg_count => l_msg_count
1959: ,x_msg_data => l_msg_data
1960: );

Line 1965: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1961:
1962: END IF; --calling module <> template requirement
1963:
1964: --Delete the advertisement action set
1965: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1966:
1967: -- Bug 2497298: PJ.J:B3:GEN: DELETE TEAM TEMPLATE GIVES SQLEXCEPTION
1968: -- Do not delete action set if requirement does not have an
1969: -- associated action set

Line 1977: p_init_msg_list => FND_API.G_FALSE -- 5130421

1973: CLOSE get_action_set;
1974: ELSE
1975:
1976: PA_ACTION_SETS_PUB.Delete_Action_Set (
1977: p_init_msg_list => FND_API.G_FALSE -- 5130421
1978: ,p_action_set_id => l_action_set_id
1979: ,p_action_set_type_code => 'ADVERTISEMENT'
1980: ,p_object_id => p_assignment_id
1981: ,p_object_type => 'OPEN_ASSIGNMENT'

Line 1996: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1992: END IF;
1993:
1994:
1995: --Delete related candidate records
1996: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1997: PA_CANDIDATE_PUB.Delete_Candidates (p_assignment_id => p_assignment_id
1998: ,x_return_status => l_return_status
1999: ,x_msg_count => l_msg_count
2000: ,x_msg_data => l_msg_data );

Line 2004: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2000: ,x_msg_data => l_msg_data );
2001: END IF;
2002:
2003: --l_return_status is initialized to success.
2004: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2005:
2006: --dbms_output.put_line('Getting Competency Table');
2007: --Delete the Competencies associated with the assignment
2008: --Get the Competencies table first

Line 2018: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2014: ,x_no_of_competencies => l_no_of_competencies
2015: ,x_error_message_code => l_error_message_code
2016: ,x_return_status => l_return_status);
2017:
2018: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2019:
2020: --Delete the Competencies Elements
2021:
2022: l_msg_count_sum := 0;

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

2060:
2061: END IF; --competency tbl is not null
2062:
2063: IF (l_msg_count_sum > 0 ) THEN
2064: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2065: ELSE
2066:
2067: --Log Message
2068: IF (P_DEBUG_MODE = 'Y') THEN

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

2086:
2087: ELSE
2088: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2089: ,p_msg_name => l_error_message_code);
2090: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2091: END IF; --success getting the competencies
2092:
2093: ELSE
2094:

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

2093: ELSE
2094:
2095: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2096: ,p_msg_name => 'PA_FAILED_TO_DEL_ASGN_SCHEDULE');
2097: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2098:
2099: END IF; --success deleting the schedule
2100:
2101: END IF; --validate only is false and no errors exist

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

2102:
2103:
2104: -- If g_error_exists is TRUE then set the x_return_status to 'E'
2105:
2106: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
2107:
2108: x_return_status := FND_API.G_RET_STS_ERROR;
2109:
2110: END IF;

Line 2108: x_return_status := FND_API.G_RET_STS_ERROR;

2104: -- If g_error_exists is TRUE then set the x_return_status to 'E'
2105:
2106: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
2107:
2108: x_return_status := FND_API.G_RET_STS_ERROR;
2109:
2110: END IF;
2111:
2112: EXCEPTION

Line 2119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2115: -- Set the excetption Message and the stack
2116: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment'
2117: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2118: --
2119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2120: RAISE;
2121: END Delete_Open_Assignment;
2122: --
2123: --