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

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

Line 190: 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

186: --in that case use the status from the template requirement.
187:
188: l_source_assignment_id := l_assignment_rec.source_assignment_id;
189:
190: 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
191:
192: l_assignment_rec.source_assignment_id := NULL;
193:
194: --get the default starting requirement status.

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

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

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

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

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

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

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

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

Line 231: p_assignment_rec.assignment_name = FND_API.G_MISS_CHAR THEN

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

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

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

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

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

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

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

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

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

Line 265: AND l_source_assignment_id <> FND_API.G_MISS_NUM

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

Line 275: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

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

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

Line 297: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

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

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

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

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

Line 312: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

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

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

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

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

Line 325: l_assignment_rec.fcst_job_id = FND_API.G_MISS_NUM THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 475: IF l_fcst_job_id_tmp = FND_API.G_MISS_NUM THEN

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

Line 480: IF l_expenditure_org_id_tmp = FND_API.G_MISS_NUM THEN

476: l_fcst_job_id_tmp := NULL;
477: END IF;
478:
479: l_expenditure_org_id_tmp := l_assignment_rec.expenditure_organization_id;
480: IF l_expenditure_org_id_tmp = FND_API.G_MISS_NUM THEN
481: l_expenditure_org_id_tmp := NULL;
482: END IF;
483:
484: l_expenditure_type_tmp := l_assignment_rec.expenditure_type;

Line 485: IF l_expenditure_type_tmp = FND_API.G_MISS_CHAR THEN

481: l_expenditure_org_id_tmp := NULL;
482: END IF;
483:
484: l_expenditure_type_tmp := l_assignment_rec.expenditure_type;
485: IF l_expenditure_type_tmp = FND_API.G_MISS_CHAR THEN
486: l_expenditure_type_tmp := NULL;
487: END IF;
488:
489: l_project_role_id_tmp := l_assignment_rec.project_role_id;

Line 490: IF l_project_role_id_tmp = FND_API.G_MISS_NUM THEN

486: l_expenditure_type_tmp := NULL;
487: END IF;
488:
489: l_project_role_id_tmp := l_assignment_rec.project_role_id;
490: IF l_project_role_id_tmp = FND_API.G_MISS_NUM THEN
491: l_project_role_id_tmp := NULL;
492: END IF;
493:
494: l_assignment_name_tmp := l_assignment_rec.assignment_name;

Line 495: IF l_assignment_name_tmp = FND_API.G_MISS_CHAR THEN

491: l_project_role_id_tmp := NULL;
492: END IF;
493:
494: l_assignment_name_tmp := l_assignment_rec.assignment_name;
495: IF l_assignment_name_tmp = FND_API.G_MISS_CHAR THEN
496: l_assignment_name_tmp := NULL;
497: END IF;
498:
499: IF P_DEBUG_MODE = 'Y' THEN

Line 534: OR l_assignment_rec.work_type_id = FND_API.G_MISS_NUM

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

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

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

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

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

Line 551: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

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

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

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

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

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

634: -- use candidate and search settings defaulted from the project
635:
636: -- FP.M Development: Default the following attributes when
637: -- l_assignment_rec.resource_list_member_id IS NOT NULL
638: IF l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM
639: 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)
640: AND PA_STARTUP.G_Calling_Application <> 'PLSQL' -- Bug 5130421 : added PLSQL check
641: THEN
642: l_assignment_rec.comp_match_weighting := l_comp_match_weighting;

Line 639: 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)

635:
636: -- FP.M Development: Default the following attributes when
637: -- l_assignment_rec.resource_list_member_id IS NOT NULL
638: IF l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM
639: 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)
640: AND PA_STARTUP.G_Calling_Application <> 'PLSQL' -- Bug 5130421 : added PLSQL check
641: THEN
642: l_assignment_rec.comp_match_weighting := l_comp_match_weighting;
643: l_assignment_rec.avail_match_weighting := l_avail_match_weighting;

Line 652: 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

648: l_assignment_rec.search_country_code := l_search_country_code;
649: l_assignment_rec.search_min_candidate_score := l_search_min_candidate_score;
650: 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;
651: -- Bug 5130421 Added ELSIF
652: 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
653: THEN
654: IF l_assignment_rec.comp_match_weighting IS NULL OR l_assignment_rec.comp_match_weighting = FND_API.G_MISS_NUM THEN
655: l_assignment_rec.comp_match_weighting := l_comp_match_weighting;
656: END IF;

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

650: 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;
651: -- Bug 5130421 Added ELSIF
652: 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
653: THEN
654: IF l_assignment_rec.comp_match_weighting IS NULL OR l_assignment_rec.comp_match_weighting = FND_API.G_MISS_NUM THEN
655: l_assignment_rec.comp_match_weighting := l_comp_match_weighting;
656: END IF;
657: IF l_assignment_rec.avail_match_weighting IS NULL OR l_assignment_rec.avail_match_weighting = FND_API.G_MISS_NUM THEN
658: l_assignment_rec.avail_match_weighting := l_avail_match_weighting;

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

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

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

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

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

659: END IF;
660: IF l_assignment_rec.job_level_match_weighting IS NULL OR l_assignment_rec.job_level_match_weighting = FND_API.G_MISS_NUM THEN
661: l_assignment_rec.job_level_match_weighting := l_job_level_match_weighting;
662: END IF;
663: IF l_assignment_rec.search_min_availability IS NULL OR l_assignment_rec.search_min_availability = FND_API.G_MISS_NUM THEN
664: l_assignment_rec.search_min_availability := l_search_min_availability;
665: END IF;
666: 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
667: l_assignment_rec.search_exp_org_struct_ver_id := l_search_exp_org_struct_ver_id;

Line 666: 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

662: END IF;
663: IF l_assignment_rec.search_min_availability IS NULL OR l_assignment_rec.search_min_availability = FND_API.G_MISS_NUM THEN
664: l_assignment_rec.search_min_availability := l_search_min_availability;
665: END IF;
666: 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
667: l_assignment_rec.search_exp_org_struct_ver_id := l_search_exp_org_struct_ver_id;
668: END IF;
669: 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
670: l_assignment_rec.search_exp_start_org_id := l_search_exp_start_org_id;

Line 669: 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

665: END IF;
666: 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
667: l_assignment_rec.search_exp_org_struct_ver_id := l_search_exp_org_struct_ver_id;
668: END IF;
669: 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
670: l_assignment_rec.search_exp_start_org_id := l_search_exp_start_org_id;
671: END IF;
672: IF l_assignment_rec.search_country_code = FND_API.G_MISS_CHAR THEN
673: -- Search country code can be null

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

668: END IF;
669: 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
670: l_assignment_rec.search_exp_start_org_id := l_search_exp_start_org_id;
671: END IF;
672: IF l_assignment_rec.search_country_code = FND_API.G_MISS_CHAR THEN
673: -- Search country code can be null
674: l_assignment_rec.search_country_code := l_search_country_code;
675: END IF;
676: 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 676: IF l_assignment_rec.search_min_candidate_score IS NULL OR l_assignment_rec.search_min_candidate_score = FND_API.G_MISS_NUM THEN

672: IF l_assignment_rec.search_country_code = FND_API.G_MISS_CHAR THEN
673: -- Search country code can be null
674: l_assignment_rec.search_country_code := l_search_country_code;
675: END IF;
676: IF l_assignment_rec.search_min_candidate_score IS NULL OR l_assignment_rec.search_min_candidate_score = FND_API.G_MISS_NUM THEN
677: l_assignment_rec.search_min_candidate_score := l_search_min_candidate_score;
678: END IF;
679: 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
680: l_assignment_rec.enable_auto_cand_nom_flag := 'Y';

Line 679: 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

675: END IF;
676: IF l_assignment_rec.search_min_candidate_score IS NULL OR l_assignment_rec.search_min_candidate_score = FND_API.G_MISS_NUM THEN
677: l_assignment_rec.search_min_candidate_score := l_search_min_candidate_score;
678: END IF;
679: 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
680: l_assignment_rec.enable_auto_cand_nom_flag := 'Y';
681: END IF;
682: END IF;
683:

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

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

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

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

Line 805: IF l_source_assignment_id = FND_API.G_MISS_NUM THEN

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

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

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

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

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

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

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

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

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

Line 881: IF l_assignment_rec.resource_list_member_id IS NOT NULL AND l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM THEN

877:
878: ELSE
879:
880: /*Added this IF for bug 9095861 */
881: IF l_assignment_rec.resource_list_member_id IS NOT NULL AND l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM THEN
882: OPEN get_td_resource_assignments;
883: FETCH get_td_resource_assignments
884: BULK COLLECT INTO l_task_assignment_id_tbl,
885: l_task_version_id_tbl,

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

908: ,p_project_role_id => p_assignment_rec.project_role_id
909: ,x_return_status => l_return_status
910: );
911:
912: END IF; -- IF p_assignment_rec.project_id <> FND_API.G_MISS_NUM AND
913: -- p_asgn_creation_mode <> 'COPY' THEN
914:
915: PA_SCHEDULE_PVT.Create_OPN_ASG_Schedule
916: ( p_project_id => l_assignment_rec.project_id

Line 940: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

936:
937: /* Bug 3051110 - Added code to call PA_ASSIGNMENTS_PVT.Calc_Init_Transfer_Price if the l_return status is success,
938: this is to populate the TP columns in pa_project_assignments table */
939:
940: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
941:
942: IF p_debug_mode = 'Y' THEN
943: PA_DEBUG.WRITE('PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment', 'About to call .Calc_Init_Transfer_Price', 3);
944: 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 969: IF p_adv_action_set_id IS NOT NULL AND p_adv_action_set_id <> FND_API.G_MISS_NUM THEN

965: --
966: -- Bug 2388060 - Apply Action Set after schedule has been created
967: -- Apply the Advertisement Action Set on the non-template requirement
968: --
969: IF p_adv_action_set_id IS NOT NULL AND p_adv_action_set_id <> FND_API.G_MISS_NUM THEN
970: l_adv_action_set_id := p_adv_action_set_id;
971: END IF;
972:
973: IF p_start_adv_action_set_flag IS NOT NULL AND p_start_adv_action_set_flag <> FND_API.G_MISS_CHAR THEN

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

969: IF p_adv_action_set_id IS NOT NULL AND p_adv_action_set_id <> FND_API.G_MISS_NUM THEN
970: l_adv_action_set_id := p_adv_action_set_id;
971: END IF;
972:
973: IF p_start_adv_action_set_flag IS NOT NULL AND p_start_adv_action_set_flag <> FND_API.G_MISS_CHAR THEN
974: l_start_adv_action_set_flag := p_start_adv_action_set_flag;
975: END IF;
976:
977: -- set the global variable for PA_ADVERTISEMENTS_PUB

Line 1019: ,p_init_msg_list => FND_API.G_FALSE

1015: ,p_object_id => PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id
1016: ,p_perform_action_set_flag => 'Y'
1017: ,p_commit => p_commit
1018: ,p_validate_only => p_validate_only
1019: ,p_init_msg_list => FND_API.G_FALSE
1020: ,x_new_action_set_id => l_new_action_set_id
1021: ,x_return_status => l_return_status
1022: ,x_msg_count => l_msg_count
1023: ,x_msg_data => l_msg_data);

Line 1065: l_source_assignment_id <> FND_API.G_MISS_NUM AND

1061: -- 5130421 : Added G_Calling_Application check so that competencies are copied
1062: -- while creation of new requirments
1063:
1064: IF (l_source_assignment_id IS NOT NULL AND
1065: l_source_assignment_id <> FND_API.G_MISS_NUM AND
1066: l_assignment_rec.source_assignment_type IN ( 'OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT')) /*Bug#12422340*/
1067: OR (p_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM AND
1068: l_assignment_rec.source_assignment_type IN ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT')) /*bug#12422340*/
1069: OR (p_budget_version_id IS NOT NULL AND

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

1063:
1064: IF (l_source_assignment_id IS NOT NULL AND
1065: l_source_assignment_id <> FND_API.G_MISS_NUM AND
1066: l_assignment_rec.source_assignment_type IN ( 'OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT')) /*Bug#12422340*/
1067: OR (p_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM AND
1068: l_assignment_rec.source_assignment_type IN ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT')) /*bug#12422340*/
1069: OR (p_budget_version_id IS NOT NULL AND
1070: p_budget_version_id <> FND_API.G_MISS_NUM AND
1071: l_assignment_rec.resource_list_member_id IS NOT NULL AND

Line 1070: p_budget_version_id <> FND_API.G_MISS_NUM AND

1066: l_assignment_rec.source_assignment_type IN ( 'OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT')) /*Bug#12422340*/
1067: OR (p_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM AND
1068: l_assignment_rec.source_assignment_type IN ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT')) /*bug#12422340*/
1069: OR (p_budget_version_id IS NOT NULL AND
1070: p_budget_version_id <> FND_API.G_MISS_NUM AND
1071: l_assignment_rec.resource_list_member_id IS NOT NULL AND
1072: l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM)
1073: OR (PA_STARTUP.G_Calling_Application = 'PLSQL' AND PA_STARTUP.G_Calling_module = 'AMG')
1074: THEN

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

1068: l_assignment_rec.source_assignment_type IN ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT')) /*bug#12422340*/
1069: OR (p_budget_version_id IS NOT NULL AND
1070: p_budget_version_id <> FND_API.G_MISS_NUM AND
1071: l_assignment_rec.resource_list_member_id IS NOT NULL AND
1072: l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM)
1073: OR (PA_STARTUP.G_Calling_Application = 'PLSQL' AND PA_STARTUP.G_Calling_module = 'AMG')
1074: THEN
1075:
1076: FOR i IN 1..l_competencies_tbl.COUNT LOOP

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

1105: PA_DEBUG.Reset_Err_Stack;
1106:
1107: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1108:
1109: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
1110:
1111: x_return_status := FND_API.G_RET_STS_ERROR;
1112:
1113: END IF;

Line 1111: x_return_status := FND_API.G_RET_STS_ERROR;

1107: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1108:
1109: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
1110:
1111: x_return_status := FND_API.G_RET_STS_ERROR;
1112:
1113: END IF;
1114:
1115:

Line 1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1125: -- Set the excetption Message and the stack
1126: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
1127: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1128: --
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1130: RAISE; -- This is optional depending on the needs
1131: END Create_Open_Assignment;
1132:
1133:

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

1132:
1133:
1134: PROCEDURE Update_Open_Assignment
1135: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1136: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1137: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1138: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1139: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1140: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

1133:
1134: PROCEDURE Update_Open_Assignment
1135: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1136: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1137: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1138: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1139: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1140: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1141: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

1134: PROCEDURE Update_Open_Assignment
1135: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1136: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1137: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1138: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1139: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1140: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1141: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1142: )

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

1135: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1136: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1137: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1138: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1139: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1140: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1141: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1142: )
1143: IS

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

1136: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1137: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1138: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1139: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1140: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1141: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1142: )
1143: IS
1144:

Line 1330: x_return_status := FND_API.G_RET_STS_SUCCESS;

1326: END IF;
1327:
1328:
1329: -- Initialize the return status to success
1330: x_return_status := FND_API.G_RET_STS_SUCCESS;
1331:
1332: -- Assign the input record to the local variable
1333: l_assignment_rec := p_assignment_rec;
1334:

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

1346: l_cur_resource_list_member_id,
1347: l_cur_project_role_id;
1348: CLOSE get_cur_asgmt_attributes;
1349:
1350: IF p_assignment_rec.project_role_id = FND_API.G_MISS_NUM THEN
1351: l_assignment_rec.project_role_id := l_cur_project_role_id;
1352: END IF;
1353:
1354: --Log Message

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

1358: ,x_log_level => li_message_level);
1359: END IF;
1360:
1361: IF l_cur_resource_list_member_id IS NOT NULL AND
1362: p_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN
1363:
1364: -- get the mandatory attributes of planning resource
1365: OPEN get_res_mand_attributes;
1366: FETCH get_res_mand_attributes INTO

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

1372: CLOSE get_res_mand_attributes;
1373:
1374: -- check if mandatory attributes are changed
1375: IF (l_cur_res_type_flag = 'Y' AND
1376: p_assignment_rec.resource_id <> FND_API.G_MISS_NUM AND
1377: p_assignment_rec.resource_id <> l_cur_resource_id) OR
1378: (l_cur_res_type_flag = 'Y' AND
1379: p_assignment_rec.fcst_job_id <> FND_API.G_MISS_NUM AND
1380: p_assignment_rec.fcst_job_id <> l_cur_fcst_job_id) OR

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

1375: IF (l_cur_res_type_flag = 'Y' AND
1376: p_assignment_rec.resource_id <> FND_API.G_MISS_NUM AND
1377: p_assignment_rec.resource_id <> l_cur_resource_id) OR
1378: (l_cur_res_type_flag = 'Y' AND
1379: p_assignment_rec.fcst_job_id <> FND_API.G_MISS_NUM AND
1380: p_assignment_rec.fcst_job_id <> l_cur_fcst_job_id) OR
1381: (l_cur_orgn_flag = 'Y' AND
1382: p_assignment_rec.expenditure_organization_id <> FND_API.G_MISS_NUM AND
1383: p_assignment_rec.expenditure_organization_id <> l_cur_exp_org_id) OR

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

1378: (l_cur_res_type_flag = 'Y' AND
1379: p_assignment_rec.fcst_job_id <> FND_API.G_MISS_NUM AND
1380: p_assignment_rec.fcst_job_id <> l_cur_fcst_job_id) OR
1381: (l_cur_orgn_flag = 'Y' AND
1382: p_assignment_rec.expenditure_organization_id <> FND_API.G_MISS_NUM AND
1383: p_assignment_rec.expenditure_organization_id <> l_cur_exp_org_id) OR
1384: (l_cur_fin_cat_flag = 'Y' AND
1385: p_assignment_rec.expenditure_type <> FND_API.G_MISS_CHAR AND
1386: p_assignment_rec.expenditure_type <> l_cur_expenditure_type) OR

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

1381: (l_cur_orgn_flag = 'Y' AND
1382: p_assignment_rec.expenditure_organization_id <> FND_API.G_MISS_NUM AND
1383: p_assignment_rec.expenditure_organization_id <> l_cur_exp_org_id) OR
1384: (l_cur_fin_cat_flag = 'Y' AND
1385: p_assignment_rec.expenditure_type <> FND_API.G_MISS_CHAR AND
1386: p_assignment_rec.expenditure_type <> l_cur_expenditure_type) OR
1387: (l_cur_role_flag = 'Y' AND
1388: p_assignment_rec.project_role_id <> FND_API.G_MISS_NUM AND
1389: p_assignment_rec.project_role_id <> l_cur_project_role_id) OR

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

1384: (l_cur_fin_cat_flag = 'Y' AND
1385: p_assignment_rec.expenditure_type <> FND_API.G_MISS_CHAR AND
1386: p_assignment_rec.expenditure_type <> l_cur_expenditure_type) OR
1387: (l_cur_role_flag = 'Y' AND
1388: p_assignment_rec.project_role_id <> FND_API.G_MISS_NUM AND
1389: p_assignment_rec.project_role_id <> l_cur_project_role_id) OR
1390: (l_cur_role_flag = 'Y' AND
1391: p_assignment_rec.assignment_name <> FND_API.G_MISS_CHAR AND
1392: p_assignment_rec.assignment_name <> l_cur_assignment_name) THEN

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

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

Line 1401: IF l_fcst_job_id_tmp = FND_API.G_MISS_NUM THEN

1397: ,x_log_level => li_message_level);
1398: END IF;
1399:
1400: l_fcst_job_id_tmp := l_assignment_rec.fcst_job_id;
1401: IF l_fcst_job_id_tmp = FND_API.G_MISS_NUM THEN
1402: l_fcst_job_id_tmp := NULL;
1403: END IF;
1404:
1405: l_expenditure_org_id_tmp := l_assignment_rec.expenditure_organization_id;

Line 1406: IF l_expenditure_org_id_tmp = FND_API.G_MISS_NUM THEN

1402: l_fcst_job_id_tmp := NULL;
1403: END IF;
1404:
1405: l_expenditure_org_id_tmp := l_assignment_rec.expenditure_organization_id;
1406: IF l_expenditure_org_id_tmp = FND_API.G_MISS_NUM THEN
1407: l_expenditure_org_id_tmp := NULL;
1408: END IF;
1409:
1410: l_expenditure_type_tmp := l_assignment_rec.expenditure_type;

Line 1411: IF l_expenditure_type_tmp = FND_API.G_MISS_CHAR THEN

1407: l_expenditure_org_id_tmp := NULL;
1408: END IF;
1409:
1410: l_expenditure_type_tmp := l_assignment_rec.expenditure_type;
1411: IF l_expenditure_type_tmp = FND_API.G_MISS_CHAR THEN
1412: l_expenditure_type_tmp := NULL;
1413: END IF;
1414:
1415: l_project_role_id_tmp := l_assignment_rec.project_role_id;

Line 1416: IF l_project_role_id_tmp = FND_API.G_MISS_NUM THEN

1412: l_expenditure_type_tmp := NULL;
1413: END IF;
1414:
1415: l_project_role_id_tmp := l_assignment_rec.project_role_id;
1416: IF l_project_role_id_tmp = FND_API.G_MISS_NUM THEN
1417: l_project_role_id_tmp := NULL;
1418: END IF;
1419:
1420: l_assignment_name_tmp := l_assignment_rec.assignment_name;

Line 1421: IF l_assignment_name_tmp = FND_API.G_MISS_CHAR THEN

1417: l_project_role_id_tmp := NULL;
1418: END IF;
1419:
1420: l_assignment_name_tmp := l_assignment_rec.assignment_name;
1421: IF l_assignment_name_tmp = FND_API.G_MISS_CHAR THEN
1422: l_assignment_name_tmp := NULL;
1423: END IF;
1424:
1425: IF P_DEBUG_MODE = 'Y' THEN

Line 1614: ,p_named_role => FND_API.G_MISS_CHAR

1610: ,p_task_version_id_tbl => l_task_version_id_tbl
1611: ,p_budget_version_id_tbl => l_budget_version_id_tbl
1612: ,p_struct_version_id_tbl => l_struct_version_id_tbl
1613: ,p_project_assignment_id => -1
1614: ,p_named_role => FND_API.G_MISS_CHAR
1615: ,x_return_status => l_return_status
1616: );
1617: END IF;
1618:

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

1625:
1626: END IF; --IF l_assignment_rec.resource_list_member_id IS NOT NULL THEN
1627:
1628: -- IF mandatory attributes are NOT changed
1629: ELSIF p_assignment_rec.assignment_name <> FND_API.G_MISS_CHAR AND
1630: p_assignment_rec.assignment_name <> l_cur_assignment_name THEN
1631:
1632: --Log Message
1633: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

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

1674: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1675: ,p_msg_name => 'PA_ASGN_ID_REQUIRED_FOR_ASG'
1676: ,p_token1 => 'ASGNTYPE'
1677: ,p_value1 => l_req_text);
1678: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1679: END IF;
1680:
1681:
1682: --the following validation not required for updating an assignment.

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

1687: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1688: ,p_msg_name => 'PA_ASGN_NAME_REQUIRED_FOR_ASG'
1689: ,p_token1 => 'ASGNTYPE'
1690: ,p_value1 => l_req_text);
1691: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1692: END IF;
1693:
1694:
1695: --Status code updates and start/end date updates for TEMPLATE REQUIREMENTS ONLY are allowed through this

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

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

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

1712: IF ('Y' <> PA_PROJECT_STUS_UTILS.Allow_Status_Change( o_status_code => l_old_status_code
1713: ,n_status_code => l_assignment_rec.status_code))THEN
1714: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1715: ,p_msg_name => 'PA_ASGN_INV_NEXT_STATUS_CODE');
1716: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1717: END IF;
1718:
1719: END IF;
1720:

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

1721: --start date <= end_date validation
1722: IF l_assignment_rec.start_date > l_assignment_rec.end_date THEN
1723: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1724: ,p_msg_name => 'PA_INVALID_START_DATE');
1725: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1726: END IF;
1727:
1728: END IF; --project id is null
1729: --

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

1732: IF l_assignment_rec.work_type_id IS NULL THEN
1733: --dbms_output.put_line('WORK TYPE INVALID');
1734: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1735: ,p_msg_name => 'PA_WORK_TYPE_REQUIRED_FOR_ASGN' );
1736: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1737:
1738: END IF;
1739:
1740:

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

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

Line 1761: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1757:
1758: --dbms_output.put_line('location id is '||l_assignment_rec.location_id);
1759: --dbms_output.put_line('return status is '||l_return_status);
1760:
1761: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1762: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
1763: ,p_msg_name => l_error_message_code );
1764: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1765: END IF;

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

1760:
1761: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1762: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
1763: ,p_msg_name => l_error_message_code );
1764: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1765: END IF;
1766: END IF;
1767:
1768: /*

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

1767:
1768: /*
1769: -- commenting this out for mass update
1770: -- should not null out location id if
1771: -- l_assignment_rec.location_id = FND_API.G_MISS_NUM
1772:
1773: -- for single update, if location_country_name is passed in as null
1774: -- then null out location id (in pa_assignment_pub)
1775:

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

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

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

1782:
1783: --dbms_output.put_line('validate only = '||p_validate_only);
1784: --dbms_output.put_line('error exists = '||PA_ASSIGNMENTS_PUB.g_error_exists);
1785:
1786: IF p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_FALSE
1787: THEN
1788:
1789: --Log Message
1790: IF (P_DEBUG_MODE = 'Y') THEN

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

1878: PA_DEBUG.Reset_Err_Stack;
1879:
1880: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1881:
1882: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
1883:
1884: x_return_status := FND_API.G_RET_STS_ERROR;
1885:
1886: END IF;

Line 1884: x_return_status := FND_API.G_RET_STS_ERROR;

1880: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1881:
1882: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
1883:
1884: x_return_status := FND_API.G_RET_STS_ERROR;
1885:
1886: END IF;
1887:
1888: EXCEPTION

Line 1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1891: -- Set the excetption Message and the stack
1892: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment'
1893: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1894: --
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1896: RAISE; -- This is optional depending on the needs
1897: END Update_Open_Assignment;
1898:
1899:

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

1899:
1900:
1901: PROCEDURE Delete_Open_Assignment
1902: ( p_assignment_row_id IN ROWID
1903: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
1904: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1905: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
1906: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1907: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

1900:
1901: PROCEDURE Delete_Open_Assignment
1902: ( p_assignment_row_id IN ROWID
1903: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
1904: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1905: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
1906: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1907: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1908: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

1901: PROCEDURE Delete_Open_Assignment
1902: ( p_assignment_row_id IN ROWID
1903: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
1904: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1905: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
1906: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1907: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1908: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1909: )

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

1902: ( p_assignment_row_id IN ROWID
1903: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
1904: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1905: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
1906: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1907: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1908: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1909: )
1910: IS

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

1903: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
1904: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1905: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
1906: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1907: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1908: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1909: )
1910: IS
1911:

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

1908: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1909: )
1910: IS
1911:
1912: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1913: l_msg_count NUMBER;
1914: l_msg_count_sum NUMBER;
1915: l_msg_data VARCHAR2(2000);
1916: l_competency_tbl PA_HR_COMPETENCE_UTILS.competency_tbl_typ;

Line 1944: x_return_status := FND_API.G_RET_STS_SUCCESS;

1940: ,x_log_level => li_message_level);
1941: END IF;
1942:
1943: -- Initialize the return status to success
1944: x_return_status := FND_API.G_RET_STS_SUCCESS;
1945:
1946: IF p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE THEN
1947:
1948: IF p_calling_module <> 'TEMPLATE_REQUIREMENT' THEN

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

1942:
1943: -- Initialize the return status to success
1944: x_return_status := FND_API.G_RET_STS_SUCCESS;
1945:
1946: IF p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE THEN
1947:
1948: IF p_calling_module <> 'TEMPLATE_REQUIREMENT' THEN
1949:
1950: --Log Message

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

1958: -- unless this is a template requirement. No schedules exists for template requirements.
1959:
1960: PA_SCHEDULE_PVT.Delete_Asgn_Schedules
1961: ( p_assignment_id => p_assignment_id
1962: ,p_perm_delete => FND_API.G_TRUE --Added for bug 4389372
1963: ,x_return_status => l_return_status
1964: ,x_msg_count => l_msg_count
1965: ,x_msg_data => l_msg_data
1966: );

Line 1971: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1967:
1968: END IF; --calling module <> template requirement
1969:
1970: --Delete the advertisement action set
1971: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1972:
1973: -- Bug 2497298: PJ.J:B3:GEN: DELETE TEAM TEMPLATE GIVES SQLEXCEPTION
1974: -- Do not delete action set if requirement does not have an
1975: -- associated action set

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

1979: CLOSE get_action_set;
1980: ELSE
1981:
1982: PA_ACTION_SETS_PUB.Delete_Action_Set (
1983: p_init_msg_list => FND_API.G_FALSE -- 5130421
1984: ,p_action_set_id => l_action_set_id
1985: ,p_action_set_type_code => 'ADVERTISEMENT'
1986: ,p_object_id => p_assignment_id
1987: ,p_object_type => 'OPEN_ASSIGNMENT'

Line 2002: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1998: END IF;
1999:
2000:
2001: --Delete related candidate records
2002: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2003: PA_CANDIDATE_PUB.Delete_Candidates (p_assignment_id => p_assignment_id
2004: ,x_return_status => l_return_status
2005: ,x_msg_count => l_msg_count
2006: ,x_msg_data => l_msg_data );

Line 2010: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2006: ,x_msg_data => l_msg_data );
2007: END IF;
2008:
2009: --l_return_status is initialized to success.
2010: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2011:
2012: --dbms_output.put_line('Getting Competency Table');
2013: --Delete the Competencies associated with the assignment
2014: --Get the Competencies table first

Line 2024: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2020: ,x_no_of_competencies => l_no_of_competencies
2021: ,x_error_message_code => l_error_message_code
2022: ,x_return_status => l_return_status);
2023:
2024: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2025:
2026: --Delete the Competencies Elements
2027:
2028: l_msg_count_sum := 0;

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

2066:
2067: END IF; --competency tbl is not null
2068:
2069: IF (l_msg_count_sum > 0 ) THEN
2070: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2071: ELSE
2072:
2073: --Log Message
2074: IF (P_DEBUG_MODE = 'Y') THEN

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

2092:
2093: ELSE
2094: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2095: ,p_msg_name => l_error_message_code);
2096: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2097: END IF; --success getting the competencies
2098:
2099: ELSE
2100:

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

2099: ELSE
2100:
2101: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2102: ,p_msg_name => 'PA_FAILED_TO_DEL_ASGN_SCHEDULE');
2103: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2104:
2105: END IF; --success deleting the schedule
2106:
2107: END IF; --validate only is false and no errors exist

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

2108:
2109:
2110: -- If g_error_exists is TRUE then set the x_return_status to 'E'
2111:
2112: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
2113:
2114: x_return_status := FND_API.G_RET_STS_ERROR;
2115:
2116: END IF;

Line 2114: x_return_status := FND_API.G_RET_STS_ERROR;

2110: -- If g_error_exists is TRUE then set the x_return_status to 'E'
2111:
2112: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN
2113:
2114: x_return_status := FND_API.G_RET_STS_ERROR;
2115:
2116: END IF;
2117:
2118: EXCEPTION

Line 2125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2121: -- Set the excetption Message and the stack
2122: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment'
2123: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2124: --
2125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2126: RAISE;
2127: END Delete_Open_Assignment;
2128: --
2129: --