eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RESOURCE_PVT dependencies on FND_API

Line 234: x_return_status := FND_API.G_RET_STS_SUCCESS;

230: -- Initialize the Error Stack
231: PA_DEBUG.init_err_stack('PA_RESOURCE_PVT.Insert_resource_denorm');
232:
233: -- Initialize the return status to success
234: x_return_status := FND_API.G_RET_STS_SUCCESS;
235:
236: -- Save point in case of Roll back
237: savepoint RES_PVT_INSERT_RES_DENORM;
238:

Line 250: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

246: ( p_resource_denorm_rec => l_resource_denorm_rec,
247: x_return_status => l_return_status,
248: x_err_msg_code => l_err_msg_code);
249:
250: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
251: pa_utils.add_message
252: ( p_app_short_name => 'PA',
253: p_msg_name => l_err_msg_code);
254:

Line 255: RAISE FND_API.G_EXC_ERROR;

251: pa_utils.add_message
252: ( p_app_short_name => 'PA',
253: p_msg_name => l_err_msg_code);
254:
255: RAISE FND_API.G_EXC_ERROR;
256: END IF;
257:
258:
259: --

Line 277: RAISE FND_API.G_EXC_ERROR;

273: IF l_rows_exists = 'Y' THEN
274: pa_utils.add_message
275: ( p_app_short_name => 'PA',
276: p_msg_name => 'PA_PERSON_ID_JOB_ID_EXIST');
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279:
280: --
281: -- Get resource_id for the person_id

Line 289: RAISE FND_API.G_EXC_ERROR;

285: IF l_resource_id= -999 OR l_resource_id IS NULL THEN
286: pa_utils.add_message
287: (p_app_short_name => 'PA',
288: p_msg_name => 'PA_NO_RESOURCE_ID_FOUND');
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291:
292: -- Get the resource's person type from HR
293: --select decode(current_employee_flag, 'Y', 'EMP', 'CWK')

Line 341: DECODE(l_resource_denorm_rec.resource_country_code, FND_API.G_MISS_CHAR,

337: l_resource_id,
338: l_resource_denorm_rec.resource_name,
339: l_resource_denorm_rec.resource_type,
340: l_resource_denorm_rec.resource_organization_id,
341: DECODE(l_resource_denorm_rec.resource_country_code, FND_API.G_MISS_CHAR,
342: NULL, l_resource_denorm_rec.resource_country_code),
343: DECODE(l_resource_denorm_rec.resource_country, FND_API.G_MISS_CHAR,
344: NULL, l_resource_denorm_rec.RESOURCE_COUNTRY),
345: DECODE(l_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,

Line 343: DECODE(l_resource_denorm_rec.resource_country, FND_API.G_MISS_CHAR,

339: l_resource_denorm_rec.resource_type,
340: l_resource_denorm_rec.resource_organization_id,
341: DECODE(l_resource_denorm_rec.resource_country_code, FND_API.G_MISS_CHAR,
342: NULL, l_resource_denorm_rec.resource_country_code),
343: DECODE(l_resource_denorm_rec.resource_country, FND_API.G_MISS_CHAR,
344: NULL, l_resource_denorm_rec.RESOURCE_COUNTRY),
345: DECODE(l_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,
346: NULL, l_resource_denorm_rec.resource_region),
347: DECODE(l_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,

Line 345: DECODE(l_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,

341: DECODE(l_resource_denorm_rec.resource_country_code, FND_API.G_MISS_CHAR,
342: NULL, l_resource_denorm_rec.resource_country_code),
343: DECODE(l_resource_denorm_rec.resource_country, FND_API.G_MISS_CHAR,
344: NULL, l_resource_denorm_rec.RESOURCE_COUNTRY),
345: DECODE(l_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,
346: NULL, l_resource_denorm_rec.resource_region),
347: DECODE(l_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,
348: NULL, l_resource_denorm_rec.resource_city),
349: DECODE(l_resource_denorm_rec.job_id, FND_API.G_MISS_NUM,

Line 347: DECODE(l_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,

343: DECODE(l_resource_denorm_rec.resource_country, FND_API.G_MISS_CHAR,
344: NULL, l_resource_denorm_rec.RESOURCE_COUNTRY),
345: DECODE(l_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,
346: NULL, l_resource_denorm_rec.resource_region),
347: DECODE(l_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,
348: NULL, l_resource_denorm_rec.resource_city),
349: DECODE(l_resource_denorm_rec.job_id, FND_API.G_MISS_NUM,
350: NULL, l_resource_denorm_rec.job_id),
351: DECODE(l_resource_denorm_rec.resource_job_level, FND_API.G_MISS_NUM,

Line 349: DECODE(l_resource_denorm_rec.job_id, FND_API.G_MISS_NUM,

345: DECODE(l_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,
346: NULL, l_resource_denorm_rec.resource_region),
347: DECODE(l_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,
348: NULL, l_resource_denorm_rec.resource_city),
349: DECODE(l_resource_denorm_rec.job_id, FND_API.G_MISS_NUM,
350: NULL, l_resource_denorm_rec.job_id),
351: DECODE(l_resource_denorm_rec.resource_job_level, FND_API.G_MISS_NUM,
352: NULL, l_resource_denorm_rec.resource_job_level),
353: l_resource_denorm_rec.resource_effective_start_date,

Line 351: DECODE(l_resource_denorm_rec.resource_job_level, FND_API.G_MISS_NUM,

347: DECODE(l_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,
348: NULL, l_resource_denorm_rec.resource_city),
349: DECODE(l_resource_denorm_rec.job_id, FND_API.G_MISS_NUM,
350: NULL, l_resource_denorm_rec.job_id),
351: DECODE(l_resource_denorm_rec.resource_job_level, FND_API.G_MISS_NUM,
352: NULL, l_resource_denorm_rec.resource_job_level),
353: l_resource_denorm_rec.resource_effective_start_date,
354: DECODE(l_resource_denorm_rec.resource_effective_end_date, FND_API.G_MISS_DATE,
355: NULL, l_resource_denorm_rec.resource_effective_end_date),

Line 354: DECODE(l_resource_denorm_rec.resource_effective_end_date, FND_API.G_MISS_DATE,

350: NULL, l_resource_denorm_rec.job_id),
351: DECODE(l_resource_denorm_rec.resource_job_level, FND_API.G_MISS_NUM,
352: NULL, l_resource_denorm_rec.resource_job_level),
353: l_resource_denorm_rec.resource_effective_start_date,
354: DECODE(l_resource_denorm_rec.resource_effective_end_date, FND_API.G_MISS_DATE,
355: NULL, l_resource_denorm_rec.resource_effective_end_date),
356: l_resource_denorm_rec.employee_flag,
357: DECODE(l_resource_denorm_rec.manager_id, FND_API.G_MISS_NUM,
358: NULL, l_resource_denorm_rec.manager_id),

Line 357: DECODE(l_resource_denorm_rec.manager_id, FND_API.G_MISS_NUM,

353: l_resource_denorm_rec.resource_effective_start_date,
354: DECODE(l_resource_denorm_rec.resource_effective_end_date, FND_API.G_MISS_DATE,
355: NULL, l_resource_denorm_rec.resource_effective_end_date),
356: l_resource_denorm_rec.employee_flag,
357: DECODE(l_resource_denorm_rec.manager_id, FND_API.G_MISS_NUM,
358: NULL, l_resource_denorm_rec.manager_id),
359: DECODE(l_resource_denorm_rec.manager_name, FND_API.G_MISS_CHAR,
360: NULL, l_resource_denorm_rec.manager_name),
361: DECODE(l_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,

Line 359: DECODE(l_resource_denorm_rec.manager_name, FND_API.G_MISS_CHAR,

355: NULL, l_resource_denorm_rec.resource_effective_end_date),
356: l_resource_denorm_rec.employee_flag,
357: DECODE(l_resource_denorm_rec.manager_id, FND_API.G_MISS_NUM,
358: NULL, l_resource_denorm_rec.manager_id),
359: DECODE(l_resource_denorm_rec.manager_name, FND_API.G_MISS_CHAR,
360: NULL, l_resource_denorm_rec.manager_name),
361: DECODE(l_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,
362: NULL, l_resource_denorm_rec.billable_flag),
363: DECODE(l_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,

Line 361: DECODE(l_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,

357: DECODE(l_resource_denorm_rec.manager_id, FND_API.G_MISS_NUM,
358: NULL, l_resource_denorm_rec.manager_id),
359: DECODE(l_resource_denorm_rec.manager_name, FND_API.G_MISS_CHAR,
360: NULL, l_resource_denorm_rec.manager_name),
361: DECODE(l_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,
362: NULL, l_resource_denorm_rec.billable_flag),
363: DECODE(l_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,
364: NULL, l_resource_denorm_rec.utilization_flag),
365: DECODE(l_resource_denorm_rec.schedulable_flag, FND_API.G_MISS_CHAR,

Line 363: DECODE(l_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,

359: DECODE(l_resource_denorm_rec.manager_name, FND_API.G_MISS_CHAR,
360: NULL, l_resource_denorm_rec.manager_name),
361: DECODE(l_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,
362: NULL, l_resource_denorm_rec.billable_flag),
363: DECODE(l_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,
364: NULL, l_resource_denorm_rec.utilization_flag),
365: DECODE(l_resource_denorm_rec.schedulable_flag, FND_API.G_MISS_CHAR,
366: NULL, l_resource_denorm_rec.schedulable_flag),
367: DECODE(l_resource_denorm_rec.resource_org_id, FND_API.G_MISS_NUM,

Line 365: DECODE(l_resource_denorm_rec.schedulable_flag, FND_API.G_MISS_CHAR,

361: DECODE(l_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,
362: NULL, l_resource_denorm_rec.billable_flag),
363: DECODE(l_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,
364: NULL, l_resource_denorm_rec.utilization_flag),
365: DECODE(l_resource_denorm_rec.schedulable_flag, FND_API.G_MISS_CHAR,
366: NULL, l_resource_denorm_rec.schedulable_flag),
367: DECODE(l_resource_denorm_rec.resource_org_id, FND_API.G_MISS_NUM,
368: NULL,l_resource_denorm_rec.resource_org_id),
369: null, -- REQUEST_ID

Line 367: DECODE(l_resource_denorm_rec.resource_org_id, FND_API.G_MISS_NUM,

363: DECODE(l_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,
364: NULL, l_resource_denorm_rec.utilization_flag),
365: DECODE(l_resource_denorm_rec.schedulable_flag, FND_API.G_MISS_CHAR,
366: NULL, l_resource_denorm_rec.schedulable_flag),
367: DECODE(l_resource_denorm_rec.resource_org_id, FND_API.G_MISS_NUM,
368: NULL,l_resource_denorm_rec.resource_org_id),
369: null, -- REQUEST_ID
370: null, -- PROGRAM_APPLICATION_ID
371: null, -- PROGRAM_ID

Line 383: WHEN FND_API.G_EXC_ERROR THEN

379: );
380:
381:
382: EXCEPTION
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO RES_PVT_INSERT_RES_DENORM;
385:
386: x_return_status := FND_API.G_RET_STS_ERROR;
387:

Line 386: x_return_status := FND_API.G_RET_STS_ERROR;

382: EXCEPTION
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO RES_PVT_INSERT_RES_DENORM;
385:
386: x_return_status := FND_API.G_RET_STS_ERROR;
387:
388: -- Reset the error stack when returning to the calling program
389: PA_DEBUG.Reset_Err_Stack;
390:

Line 398: (p_encoded => FND_API.G_TRUE

394: -- Put a message text from message stack into the x_msg_data if there is only
395: -- single error.
396: IF x_msg_count = 1 THEN
397: pa_interface_utils_pub.get_messages
398: (p_encoded => FND_API.G_TRUE
399: ,p_msg_index => 1
400: ,p_data => x_msg_data
401: ,p_msg_index_out => l_msg_index_out);
402: END IF;

Line 412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

408: FND_MSG_PUB.add_exc_msg
409: (p_pkg_name => 'PA_RESOURCE_PVT.Insert_resource_denorm'
410: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
411:
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413:
414: END Insert_resource_denorm;
415:
416:

Line 431: x_return_status := FND_API.G_RET_STS_SUCCESS;

427: x_err_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
428: IS
429: BEGIN
430: -- Initialize the return status to success
431: x_return_status := FND_API.G_RET_STS_SUCCESS;
432:
433: IF p_resource_denorm_rec.person_id = FND_API.G_MISS_NUM
434: OR p_resource_denorm_rec.resource_name = FND_API.G_MISS_CHAR
435: OR p_resource_denorm_rec.resource_type = FND_API.G_MISS_CHAR

Line 433: IF p_resource_denorm_rec.person_id = FND_API.G_MISS_NUM

429: BEGIN
430: -- Initialize the return status to success
431: x_return_status := FND_API.G_RET_STS_SUCCESS;
432:
433: IF p_resource_denorm_rec.person_id = FND_API.G_MISS_NUM
434: OR p_resource_denorm_rec.resource_name = FND_API.G_MISS_CHAR
435: OR p_resource_denorm_rec.resource_type = FND_API.G_MISS_CHAR
436: OR p_resource_denorm_rec.resource_organization_id = FND_API.G_MISS_NUM
437: OR p_resource_denorm_rec.resource_effective_start_date = FND_API.G_MISS_DATE

Line 434: OR p_resource_denorm_rec.resource_name = FND_API.G_MISS_CHAR

430: -- Initialize the return status to success
431: x_return_status := FND_API.G_RET_STS_SUCCESS;
432:
433: IF p_resource_denorm_rec.person_id = FND_API.G_MISS_NUM
434: OR p_resource_denorm_rec.resource_name = FND_API.G_MISS_CHAR
435: OR p_resource_denorm_rec.resource_type = FND_API.G_MISS_CHAR
436: OR p_resource_denorm_rec.resource_organization_id = FND_API.G_MISS_NUM
437: OR p_resource_denorm_rec.resource_effective_start_date = FND_API.G_MISS_DATE
438: OR p_resource_denorm_rec.employee_flag = FND_API.G_MISS_char THEN

Line 435: OR p_resource_denorm_rec.resource_type = FND_API.G_MISS_CHAR

431: x_return_status := FND_API.G_RET_STS_SUCCESS;
432:
433: IF p_resource_denorm_rec.person_id = FND_API.G_MISS_NUM
434: OR p_resource_denorm_rec.resource_name = FND_API.G_MISS_CHAR
435: OR p_resource_denorm_rec.resource_type = FND_API.G_MISS_CHAR
436: OR p_resource_denorm_rec.resource_organization_id = FND_API.G_MISS_NUM
437: OR p_resource_denorm_rec.resource_effective_start_date = FND_API.G_MISS_DATE
438: OR p_resource_denorm_rec.employee_flag = FND_API.G_MISS_char THEN
439:

Line 436: OR p_resource_denorm_rec.resource_organization_id = FND_API.G_MISS_NUM

432:
433: IF p_resource_denorm_rec.person_id = FND_API.G_MISS_NUM
434: OR p_resource_denorm_rec.resource_name = FND_API.G_MISS_CHAR
435: OR p_resource_denorm_rec.resource_type = FND_API.G_MISS_CHAR
436: OR p_resource_denorm_rec.resource_organization_id = FND_API.G_MISS_NUM
437: OR p_resource_denorm_rec.resource_effective_start_date = FND_API.G_MISS_DATE
438: OR p_resource_denorm_rec.employee_flag = FND_API.G_MISS_char THEN
439:
440: x_err_msg_code := 'REQUIRED_FIELD_NULL';

Line 437: OR p_resource_denorm_rec.resource_effective_start_date = FND_API.G_MISS_DATE

433: IF p_resource_denorm_rec.person_id = FND_API.G_MISS_NUM
434: OR p_resource_denorm_rec.resource_name = FND_API.G_MISS_CHAR
435: OR p_resource_denorm_rec.resource_type = FND_API.G_MISS_CHAR
436: OR p_resource_denorm_rec.resource_organization_id = FND_API.G_MISS_NUM
437: OR p_resource_denorm_rec.resource_effective_start_date = FND_API.G_MISS_DATE
438: OR p_resource_denorm_rec.employee_flag = FND_API.G_MISS_char THEN
439:
440: x_err_msg_code := 'REQUIRED_FIELD_NULL';
441: x_return_status := FND_API.G_RET_STS_ERROR;

Line 438: OR p_resource_denorm_rec.employee_flag = FND_API.G_MISS_char THEN

434: OR p_resource_denorm_rec.resource_name = FND_API.G_MISS_CHAR
435: OR p_resource_denorm_rec.resource_type = FND_API.G_MISS_CHAR
436: OR p_resource_denorm_rec.resource_organization_id = FND_API.G_MISS_NUM
437: OR p_resource_denorm_rec.resource_effective_start_date = FND_API.G_MISS_DATE
438: OR p_resource_denorm_rec.employee_flag = FND_API.G_MISS_char THEN
439:
440: x_err_msg_code := 'REQUIRED_FIELD_NULL';
441: x_return_status := FND_API.G_RET_STS_ERROR;
442:

Line 441: x_return_status := FND_API.G_RET_STS_ERROR;

437: OR p_resource_denorm_rec.resource_effective_start_date = FND_API.G_MISS_DATE
438: OR p_resource_denorm_rec.employee_flag = FND_API.G_MISS_char THEN
439:
440: x_err_msg_code := 'REQUIRED_FIELD_NULL';
441: x_return_status := FND_API.G_RET_STS_ERROR;
442:
443: END IF;
444: END check_required_fields;
445:

Line 473: x_return_status := FND_API.G_RET_STS_SUCCESS;

469: -- Initialize the Error Stack
470: PA_DEBUG.init_err_stack('PA_RESOURCE_PVT.Update_resource_denorm');
471:
472: -- Initialize the return status to success
473: x_return_status := FND_API.G_RET_STS_SUCCESS;
474:
475: -- Save point in case of Roll back
476: savepoint RES_PVT_UPDATE_RES_DENORM;
477:

Line 485: IF l_resource_denorm_new_rec.person_id = FND_API.G_MISS_NUM AND

481: -------------------------------------------------------------------------
482: -- Check if either person_id or job_id has been passed.
483: -- Both person_id and job_id should not be null at the same time.
484: -------------------------------------------------------------------------
485: IF l_resource_denorm_new_rec.person_id = FND_API.G_MISS_NUM AND
486: l_resource_denorm_new_rec.job_id = FND_API.G_MISS_num THEN
487: pa_utils.add_message (
488: p_app_short_name => 'PA',
489: p_msg_name => 'PA_PERSON_ID_JOB_ID_NULL');

Line 486: l_resource_denorm_new_rec.job_id = FND_API.G_MISS_num THEN

482: -- Check if either person_id or job_id has been passed.
483: -- Both person_id and job_id should not be null at the same time.
484: -------------------------------------------------------------------------
485: IF l_resource_denorm_new_rec.person_id = FND_API.G_MISS_NUM AND
486: l_resource_denorm_new_rec.job_id = FND_API.G_MISS_num THEN
487: pa_utils.add_message (
488: p_app_short_name => 'PA',
489: p_msg_name => 'PA_PERSON_ID_JOB_ID_NULL');
490:

Line 491: RAISE FND_API.G_EXC_ERROR;

487: pa_utils.add_message (
488: p_app_short_name => 'PA',
489: p_msg_name => 'PA_PERSON_ID_JOB_ID_NULL');
490:
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494: -------------------------------------------------------------------------
495: -- If resource_effective_start_date has been passed, update an individual

Line 501: IF l_resource_denorm_new_rec.resource_effective_start_date <> FND_API.G_MISS_DATE AND

497: -- Since the combination of person_id and resource_effective_start_date is
498: -- the primary key in the table 'PA_RESOURCES_DENORM', resource_effective
499: -- _start_date should not be null for individual record update.
500: -------------------------------------------------------------------------
501: IF l_resource_denorm_new_rec.resource_effective_start_date <> FND_API.G_MISS_DATE AND
502: l_resource_denorm_new_rec.resource_effective_start_date is not null THEN
503:
504: -- Update individual record.
505: update_single_res_denorm_rec (

Line 511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

507: x_return_status => l_return_status,
508: x_err_msg_code => l_err_msg_code );
509:
510:
511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
512: pa_utils.add_message
513: ( p_app_short_name => 'PA',
514: p_msg_name => l_err_msg_code);
515:

Line 516: RAISE FND_API.G_EXC_ERROR;

512: pa_utils.add_message
513: ( p_app_short_name => 'PA',
514: p_msg_name => l_err_msg_code);
515:
516: RAISE FND_API.G_EXC_ERROR;
517: END IF;
518:
519: -------------------------------------------------------------------------
520: -- If resource_effective_start_date has not been passed, update multiple

Line 523: ELSIF l_resource_denorm_new_rec.resource_effective_start_date = FND_API.G_MISS_DATE THEN

519: -------------------------------------------------------------------------
520: -- If resource_effective_start_date has not been passed, update multiple
521: -- records after some appropriate validations.
522: -------------------------------------------------------------------------
523: ELSIF l_resource_denorm_new_rec.resource_effective_start_date = FND_API.G_MISS_DATE THEN
524:
525: -- If person_id has been passed but not job_id
526: IF l_resource_denorm_new_rec.person_id <> FND_API.G_MISS_NUM AND
527: l_resource_denorm_new_rec.person_id is not null AND

Line 526: IF l_resource_denorm_new_rec.person_id <> FND_API.G_MISS_NUM AND

522: -------------------------------------------------------------------------
523: ELSIF l_resource_denorm_new_rec.resource_effective_start_date = FND_API.G_MISS_DATE THEN
524:
525: -- If person_id has been passed but not job_id
526: IF l_resource_denorm_new_rec.person_id <> FND_API.G_MISS_NUM AND
527: l_resource_denorm_new_rec.person_id is not null AND
528: l_resource_denorm_new_rec.job_id = FND_API.G_MISS_NUM THEN
529:
530: -- Update person related multiple records

Line 528: l_resource_denorm_new_rec.job_id = FND_API.G_MISS_NUM THEN

524:
525: -- If person_id has been passed but not job_id
526: IF l_resource_denorm_new_rec.person_id <> FND_API.G_MISS_NUM AND
527: l_resource_denorm_new_rec.person_id is not null AND
528: l_resource_denorm_new_rec.job_id = FND_API.G_MISS_NUM THEN
529:
530: -- Update person related multiple records
531: update_person_res_denorm_recs (
532: p_resource_denorm_rec => l_resource_denorm_new_rec,

Line 536: IF l_return_status = FND_API.G_RET_STS_error THEN

532: p_resource_denorm_rec => l_resource_denorm_new_rec,
533: x_return_status => l_return_status,
534: x_err_msg_code => l_err_msg_code );
535:
536: IF l_return_status = FND_API.G_RET_STS_error THEN
537: pa_utils.add_message
538: (p_app_short_name => 'PA',
539: p_msg_name => l_err_msg_code);
540:

Line 541: RAISE FND_API.G_EXC_ERROR;

537: pa_utils.add_message
538: (p_app_short_name => 'PA',
539: p_msg_name => l_err_msg_code);
540:
541: RAISE FND_API.G_EXC_ERROR;
542: END IF;
543:
544: -- If job_id has been passed but not person_id, usually update attribute
545: -- job_level or billable_flag on multiple records.

Line 546: ELSIF l_resource_denorm_new_rec.person_id = FND_API.G_MISS_NUM

542: END IF;
543:
544: -- If job_id has been passed but not person_id, usually update attribute
545: -- job_level or billable_flag on multiple records.
546: ELSIF l_resource_denorm_new_rec.person_id = FND_API.G_MISS_NUM
547: AND l_resource_denorm_new_rec.job_id <> FND_API.G_MISS_NUM
548: AND l_resource_denorm_new_rec.job_id is not null THEN
549:
550: -- Update job related multiple records.

Line 547: AND l_resource_denorm_new_rec.job_id <> FND_API.G_MISS_NUM

543:
544: -- If job_id has been passed but not person_id, usually update attribute
545: -- job_level or billable_flag on multiple records.
546: ELSIF l_resource_denorm_new_rec.person_id = FND_API.G_MISS_NUM
547: AND l_resource_denorm_new_rec.job_id <> FND_API.G_MISS_NUM
548: AND l_resource_denorm_new_rec.job_id is not null THEN
549:
550: -- Update job related multiple records.
551: update_job_res_denorm_recs (

Line 556: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

552: p_resource_denorm_rec => l_resource_denorm_new_rec,
553: x_return_status => l_return_status,
554: x_err_msg_code => l_err_msg_code );
555:
556: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
557: pa_utils.add_message (
558: p_app_short_name => 'PA',
559: p_msg_name => l_err_msg_code);
560:

Line 561: RAISE FND_API.G_EXC_ERROR;

557: pa_utils.add_message (
558: p_app_short_name => 'PA',
559: p_msg_name => l_err_msg_code);
560:
561: RAISE FND_API.G_EXC_ERROR;
562: END IF;
563:
564: END IF;
565:

Line 569: WHEN FND_API.G_EXC_ERROR THEN

565:
566: END IF;
567:
568: EXCEPTION
569: WHEN FND_API.G_EXC_ERROR THEN
570: ROLLBACK TO RES_PVT_UPDATE_RES_DENORM;
571:
572: x_return_status := FND_API.G_RET_STS_ERROR;
573:

Line 572: x_return_status := FND_API.G_RET_STS_ERROR;

568: EXCEPTION
569: WHEN FND_API.G_EXC_ERROR THEN
570: ROLLBACK TO RES_PVT_UPDATE_RES_DENORM;
571:
572: x_return_status := FND_API.G_RET_STS_ERROR;
573:
574: -- Reset the error stack when returning to the calling program
575: PA_DEBUG.Reset_Err_Stack;
576:

Line 584: (p_encoded => FND_API.G_TRUE

580: -- Put a message text from message stack into the x_msg_data if there is only
581: -- single error.
582: IF x_msg_count = 1 THEN
583: pa_interface_utils_pub.get_messages
584: (p_encoded => FND_API.G_TRUE
585: ,p_msg_index => 1
586: ,p_data => x_msg_data
587: ,p_msg_index_out => l_msg_index_out);
588: END IF;

Line 598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

594: FND_MSG_PUB.add_exc_msg
595: (p_pkg_name => 'PA_RESOURCE_PVT.Update_resource_denorm'
596: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
597:
598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
599:
600: END Update_resource_denorm;
601:
602:

Line 621: x_return_status := FND_API.G_RET_STS_SUCCESS;

617: l_err_msg_code fnd_new_messages.message_name%TYPE;
618:
619: BEGIN
620: -- Initialize the return status to success
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: -- check if the person_id or resource_effective_start_date attribute is not null
624: IF p_resource_denorm_rec.person_id = FND_API.G_MISS_NUM OR
625: p_resource_denorm_rec.resource_effective_start_date = FND_API.G_MISS_date

Line 624: IF p_resource_denorm_rec.person_id = FND_API.G_MISS_NUM OR

620: -- Initialize the return status to success
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: -- check if the person_id or resource_effective_start_date attribute is not null
624: IF p_resource_denorm_rec.person_id = FND_API.G_MISS_NUM OR
625: p_resource_denorm_rec.resource_effective_start_date = FND_API.G_MISS_date
626: THEN
627: x_err_msg_code := 'PA_PERSON_ID_OR_START_DATE_NULL';
628: x_return_status := FND_API.G_RET_STS_ERROR;

Line 625: p_resource_denorm_rec.resource_effective_start_date = FND_API.G_MISS_date

621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: -- check if the person_id or resource_effective_start_date attribute is not null
624: IF p_resource_denorm_rec.person_id = FND_API.G_MISS_NUM OR
625: p_resource_denorm_rec.resource_effective_start_date = FND_API.G_MISS_date
626: THEN
627: x_err_msg_code := 'PA_PERSON_ID_OR_START_DATE_NULL';
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: RETURN;

Line 628: x_return_status := FND_API.G_RET_STS_ERROR;

624: IF p_resource_denorm_rec.person_id = FND_API.G_MISS_NUM OR
625: p_resource_denorm_rec.resource_effective_start_date = FND_API.G_MISS_date
626: THEN
627: x_err_msg_code := 'PA_PERSON_ID_OR_START_DATE_NULL';
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: RETURN;
630: END IF;
631:
632:

Line 635: resource_type = DECODE(p_resource_denorm_rec.resource_type, FND_API.G_MISS_CHAR,

631:
632:
633: UPDATE pa_resources_denorm
634: SET
635: resource_type = DECODE(p_resource_denorm_rec.resource_type, FND_API.G_MISS_CHAR,
636: resource_type,p_resource_denorm_rec.resource_type),
637: resource_organization_id = DECODE(p_resource_denorm_rec.resource_organization_ID,
638: FND_API.G_MISS_NUM, resource_organization_id,
639: p_resource_denorm_rec.resource_organization_id),

Line 638: FND_API.G_MISS_NUM, resource_organization_id,

634: SET
635: resource_type = DECODE(p_resource_denorm_rec.resource_type, FND_API.G_MISS_CHAR,
636: resource_type,p_resource_denorm_rec.resource_type),
637: resource_organization_id = DECODE(p_resource_denorm_rec.resource_organization_ID,
638: FND_API.G_MISS_NUM, resource_organization_id,
639: p_resource_denorm_rec.resource_organization_id),
640: resource_country_code = DECODE(p_resource_denorm_rec.resource_country_code, FND_API.G_MISS_CHAR,
641: resource_country_code,p_resource_denorm_rec.resource_country_code),
642: resource_country = DECODE(p_resource_denorm_rec.resource_country, FND_API.G_MISS_CHAR,

Line 640: resource_country_code = DECODE(p_resource_denorm_rec.resource_country_code, FND_API.G_MISS_CHAR,

636: resource_type,p_resource_denorm_rec.resource_type),
637: resource_organization_id = DECODE(p_resource_denorm_rec.resource_organization_ID,
638: FND_API.G_MISS_NUM, resource_organization_id,
639: p_resource_denorm_rec.resource_organization_id),
640: resource_country_code = DECODE(p_resource_denorm_rec.resource_country_code, FND_API.G_MISS_CHAR,
641: resource_country_code,p_resource_denorm_rec.resource_country_code),
642: resource_country = DECODE(p_resource_denorm_rec.resource_country, FND_API.G_MISS_CHAR,
643: resource_country,p_resource_denorm_rec.resource_country),
644: resource_region = DECODE(p_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,

Line 642: resource_country = DECODE(p_resource_denorm_rec.resource_country, FND_API.G_MISS_CHAR,

638: FND_API.G_MISS_NUM, resource_organization_id,
639: p_resource_denorm_rec.resource_organization_id),
640: resource_country_code = DECODE(p_resource_denorm_rec.resource_country_code, FND_API.G_MISS_CHAR,
641: resource_country_code,p_resource_denorm_rec.resource_country_code),
642: resource_country = DECODE(p_resource_denorm_rec.resource_country, FND_API.G_MISS_CHAR,
643: resource_country,p_resource_denorm_rec.resource_country),
644: resource_region = DECODE(p_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,
645: resource_region,p_resource_denorm_rec.resource_region),
646: resource_city = DECODE(p_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,

Line 644: resource_region = DECODE(p_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,

640: resource_country_code = DECODE(p_resource_denorm_rec.resource_country_code, FND_API.G_MISS_CHAR,
641: resource_country_code,p_resource_denorm_rec.resource_country_code),
642: resource_country = DECODE(p_resource_denorm_rec.resource_country, FND_API.G_MISS_CHAR,
643: resource_country,p_resource_denorm_rec.resource_country),
644: resource_region = DECODE(p_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,
645: resource_region,p_resource_denorm_rec.resource_region),
646: resource_city = DECODE(p_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,
647: resource_city,p_resource_denorm_rec.resource_city),
648: job_id = DECODE(p_resource_denorm_rec.job_id, FND_API.G_MISS_NUM,

Line 646: resource_city = DECODE(p_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,

642: resource_country = DECODE(p_resource_denorm_rec.resource_country, FND_API.G_MISS_CHAR,
643: resource_country,p_resource_denorm_rec.resource_country),
644: resource_region = DECODE(p_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,
645: resource_region,p_resource_denorm_rec.resource_region),
646: resource_city = DECODE(p_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,
647: resource_city,p_resource_denorm_rec.resource_city),
648: job_id = DECODE(p_resource_denorm_rec.job_id, FND_API.G_MISS_NUM,
649: job_id,p_resource_denorm_rec.job_id),
650: resource_job_level = DECODE(p_resource_denorm_rec.resource_job_level, FND_API.G_MISS_NUM,

Line 648: job_id = DECODE(p_resource_denorm_rec.job_id, FND_API.G_MISS_NUM,

644: resource_region = DECODE(p_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,
645: resource_region,p_resource_denorm_rec.resource_region),
646: resource_city = DECODE(p_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,
647: resource_city,p_resource_denorm_rec.resource_city),
648: job_id = DECODE(p_resource_denorm_rec.job_id, FND_API.G_MISS_NUM,
649: job_id,p_resource_denorm_rec.job_id),
650: resource_job_level = DECODE(p_resource_denorm_rec.resource_job_level, FND_API.G_MISS_NUM,
651: resource_job_level,p_resource_denorm_rec.resource_job_level),
652: resource_effective_end_date = DECODE(p_resource_denorm_rec.resource_effective_end_date,

Line 650: resource_job_level = DECODE(p_resource_denorm_rec.resource_job_level, FND_API.G_MISS_NUM,

646: resource_city = DECODE(p_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,
647: resource_city,p_resource_denorm_rec.resource_city),
648: job_id = DECODE(p_resource_denorm_rec.job_id, FND_API.G_MISS_NUM,
649: job_id,p_resource_denorm_rec.job_id),
650: resource_job_level = DECODE(p_resource_denorm_rec.resource_job_level, FND_API.G_MISS_NUM,
651: resource_job_level,p_resource_denorm_rec.resource_job_level),
652: resource_effective_end_date = DECODE(p_resource_denorm_rec.resource_effective_end_date,
653: FND_API.G_MISS_DATE, resource_effective_end_date,
654: p_resource_denorm_rec. resource_effective_end_date),

Line 653: FND_API.G_MISS_DATE, resource_effective_end_date,

649: job_id,p_resource_denorm_rec.job_id),
650: resource_job_level = DECODE(p_resource_denorm_rec.resource_job_level, FND_API.G_MISS_NUM,
651: resource_job_level,p_resource_denorm_rec.resource_job_level),
652: resource_effective_end_date = DECODE(p_resource_denorm_rec.resource_effective_end_date,
653: FND_API.G_MISS_DATE, resource_effective_end_date,
654: p_resource_denorm_rec. resource_effective_end_date),
655: employee_flag = DECODE(p_resource_denorm_rec.employee_flag, FND_API.G_MISS_CHAR,
656: employee_flag,p_resource_denorm_rec.employee_flag),
657: manager_id = DECODE(p_resource_denorm_rec.manager_id, FND_API.G_MISS_NUM,

Line 655: employee_flag = DECODE(p_resource_denorm_rec.employee_flag, FND_API.G_MISS_CHAR,

651: resource_job_level,p_resource_denorm_rec.resource_job_level),
652: resource_effective_end_date = DECODE(p_resource_denorm_rec.resource_effective_end_date,
653: FND_API.G_MISS_DATE, resource_effective_end_date,
654: p_resource_denorm_rec. resource_effective_end_date),
655: employee_flag = DECODE(p_resource_denorm_rec.employee_flag, FND_API.G_MISS_CHAR,
656: employee_flag,p_resource_denorm_rec.employee_flag),
657: manager_id = DECODE(p_resource_denorm_rec.manager_id, FND_API.G_MISS_NUM,
658: manager_id,p_resource_denorm_rec.manager_id),
659: manager_name = DECODE(p_resource_denorm_rec.manager_name, FND_API.G_MISS_CHAR,

Line 657: manager_id = DECODE(p_resource_denorm_rec.manager_id, FND_API.G_MISS_NUM,

653: FND_API.G_MISS_DATE, resource_effective_end_date,
654: p_resource_denorm_rec. resource_effective_end_date),
655: employee_flag = DECODE(p_resource_denorm_rec.employee_flag, FND_API.G_MISS_CHAR,
656: employee_flag,p_resource_denorm_rec.employee_flag),
657: manager_id = DECODE(p_resource_denorm_rec.manager_id, FND_API.G_MISS_NUM,
658: manager_id,p_resource_denorm_rec.manager_id),
659: manager_name = DECODE(p_resource_denorm_rec.manager_name, FND_API.G_MISS_CHAR,
660: manager_name,p_resource_denorm_rec.manager_name),
661: billable_flag = DECODE(p_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,

Line 659: manager_name = DECODE(p_resource_denorm_rec.manager_name, FND_API.G_MISS_CHAR,

655: employee_flag = DECODE(p_resource_denorm_rec.employee_flag, FND_API.G_MISS_CHAR,
656: employee_flag,p_resource_denorm_rec.employee_flag),
657: manager_id = DECODE(p_resource_denorm_rec.manager_id, FND_API.G_MISS_NUM,
658: manager_id,p_resource_denorm_rec.manager_id),
659: manager_name = DECODE(p_resource_denorm_rec.manager_name, FND_API.G_MISS_CHAR,
660: manager_name,p_resource_denorm_rec.manager_name),
661: billable_flag = DECODE(p_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,
662: billable_flag,p_resource_denorm_rec.billable_flag),
663: utilization_flag = DECODE(p_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,

Line 661: billable_flag = DECODE(p_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,

657: manager_id = DECODE(p_resource_denorm_rec.manager_id, FND_API.G_MISS_NUM,
658: manager_id,p_resource_denorm_rec.manager_id),
659: manager_name = DECODE(p_resource_denorm_rec.manager_name, FND_API.G_MISS_CHAR,
660: manager_name,p_resource_denorm_rec.manager_name),
661: billable_flag = DECODE(p_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,
662: billable_flag,p_resource_denorm_rec.billable_flag),
663: utilization_flag = DECODE(p_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,
664: utilization_flag,p_resource_denorm_rec.utilization_flag),
665: schedulable_flag = DECODE(p_resource_denorm_rec.schedulable_flag, FND_API.G_MISS_CHAR,

Line 663: utilization_flag = DECODE(p_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,

659: manager_name = DECODE(p_resource_denorm_rec.manager_name, FND_API.G_MISS_CHAR,
660: manager_name,p_resource_denorm_rec.manager_name),
661: billable_flag = DECODE(p_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,
662: billable_flag,p_resource_denorm_rec.billable_flag),
663: utilization_flag = DECODE(p_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,
664: utilization_flag,p_resource_denorm_rec.utilization_flag),
665: schedulable_flag = DECODE(p_resource_denorm_rec.schedulable_flag, FND_API.G_MISS_CHAR,
666: schedulable_flag,p_resource_denorm_rec.schedulable_flag),
667: resource_org_id = DECODE(p_resource_denorm_rec.resource_org_id, FND_API.G_MISS_NUM,

Line 665: schedulable_flag = DECODE(p_resource_denorm_rec.schedulable_flag, FND_API.G_MISS_CHAR,

661: billable_flag = DECODE(p_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,
662: billable_flag,p_resource_denorm_rec.billable_flag),
663: utilization_flag = DECODE(p_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,
664: utilization_flag,p_resource_denorm_rec.utilization_flag),
665: schedulable_flag = DECODE(p_resource_denorm_rec.schedulable_flag, FND_API.G_MISS_CHAR,
666: schedulable_flag,p_resource_denorm_rec.schedulable_flag),
667: resource_org_id = DECODE(p_resource_denorm_rec.resource_org_id, FND_API.G_MISS_NUM,
668: resource_org_id,p_resource_denorm_rec.resource_org_id),
669: LAST_UPDATE_date = sysdate,

Line 667: resource_org_id = DECODE(p_resource_denorm_rec.resource_org_id, FND_API.G_MISS_NUM,

663: utilization_flag = DECODE(p_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,
664: utilization_flag,p_resource_denorm_rec.utilization_flag),
665: schedulable_flag = DECODE(p_resource_denorm_rec.schedulable_flag, FND_API.G_MISS_CHAR,
666: schedulable_flag,p_resource_denorm_rec.schedulable_flag),
667: resource_org_id = DECODE(p_resource_denorm_rec.resource_org_id, FND_API.G_MISS_NUM,
668: resource_org_id,p_resource_denorm_rec.resource_org_id),
669: LAST_UPDATE_date = sysdate,
670: LAST_UPDATED_by = fnd_global.user_id,
671: LAST_UPDATE_login = fnd_global.login_id

Line 683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

679: FND_MSG_PUB.add_exc_msg
680: (p_pkg_name => 'PA_RESOURCE_PVT.update_person_res_denorm_recs',
681: p_procedure_name => PA_DEBUG.G_Err_Stack );
682:
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: -- RAISE;
685: END update_single_res_denorm_rec;
686:
687:

Line 706: x_return_status := FND_API.G_RET_STS_SUCCESS;

702: num_of_rec NUMBER;
703: l_return_status VARCHAR2(1);
704: BEGIN
705: -- Initialize the return status to success
706: x_return_status := FND_API.G_RET_STS_SUCCESS;
707:
708: -- check if the person_id or resource_effective_start_date attribute is not null
709: IF p_resource_denorm_rec.person_id = FND_API.G_MISS_NUM OR
710: p_resource_denorm_rec.person_id is null

Line 709: IF p_resource_denorm_rec.person_id = FND_API.G_MISS_NUM OR

705: -- Initialize the return status to success
706: x_return_status := FND_API.G_RET_STS_SUCCESS;
707:
708: -- check if the person_id or resource_effective_start_date attribute is not null
709: IF p_resource_denorm_rec.person_id = FND_API.G_MISS_NUM OR
710: p_resource_denorm_rec.person_id is null
711: THEN
712: x_err_msg_code := 'PA_PERSON_ID_NULL';
713: x_return_status := FND_API.G_RET_STS_ERROR;

Line 713: x_return_status := FND_API.G_RET_STS_ERROR;

709: IF p_resource_denorm_rec.person_id = FND_API.G_MISS_NUM OR
710: p_resource_denorm_rec.person_id is null
711: THEN
712: x_err_msg_code := 'PA_PERSON_ID_NULL';
713: x_return_status := FND_API.G_RET_STS_ERROR;
714: RETURN;
715: END IF;
716:
717:

Line 727: resource_name = DECODE(p_resource_denorm_rec.resource_name, FND_API.G_MISS_CHAR,

723:
724:
725: UPDATE pa_resources_denorm
726: SET
727: resource_name = DECODE(p_resource_denorm_rec.resource_name, FND_API.G_MISS_CHAR,
728: resource_name,p_resource_denorm_rec.resource_name),
729: resource_country_code = DECODE(p_resource_denorm_rec.resource_country_code, FND_API.G_MISS_CHAR,
730: resource_country_code,p_resource_denorm_rec.resource_country_code),
731: resource_country = DECODE(p_resource_denorm_rec.resource_country, fnd_API.G_MISS_CHAR,

Line 729: resource_country_code = DECODE(p_resource_denorm_rec.resource_country_code, FND_API.G_MISS_CHAR,

725: UPDATE pa_resources_denorm
726: SET
727: resource_name = DECODE(p_resource_denorm_rec.resource_name, FND_API.G_MISS_CHAR,
728: resource_name,p_resource_denorm_rec.resource_name),
729: resource_country_code = DECODE(p_resource_denorm_rec.resource_country_code, FND_API.G_MISS_CHAR,
730: resource_country_code,p_resource_denorm_rec.resource_country_code),
731: resource_country = DECODE(p_resource_denorm_rec.resource_country, fnd_API.G_MISS_CHAR,
732: resource_country,p_resource_denorm_rec.resource_country),
733: resource_region = DECODE(p_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,

Line 731: resource_country = DECODE(p_resource_denorm_rec.resource_country, fnd_API.G_MISS_CHAR,

727: resource_name = DECODE(p_resource_denorm_rec.resource_name, FND_API.G_MISS_CHAR,
728: resource_name,p_resource_denorm_rec.resource_name),
729: resource_country_code = DECODE(p_resource_denorm_rec.resource_country_code, FND_API.G_MISS_CHAR,
730: resource_country_code,p_resource_denorm_rec.resource_country_code),
731: resource_country = DECODE(p_resource_denorm_rec.resource_country, fnd_API.G_MISS_CHAR,
732: resource_country,p_resource_denorm_rec.resource_country),
733: resource_region = DECODE(p_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,
734: resource_region,p_resource_denorm_rec.resource_region),
735: resource_city = DECODE(p_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,

Line 733: resource_region = DECODE(p_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,

729: resource_country_code = DECODE(p_resource_denorm_rec.resource_country_code, FND_API.G_MISS_CHAR,
730: resource_country_code,p_resource_denorm_rec.resource_country_code),
731: resource_country = DECODE(p_resource_denorm_rec.resource_country, fnd_API.G_MISS_CHAR,
732: resource_country,p_resource_denorm_rec.resource_country),
733: resource_region = DECODE(p_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,
734: resource_region,p_resource_denorm_rec.resource_region),
735: resource_city = DECODE(p_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,
736: resource_city,p_resource_denorm_rec.resource_city),
737: last_update_date = sysdate,

Line 735: resource_city = DECODE(p_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,

731: resource_country = DECODE(p_resource_denorm_rec.resource_country, fnd_API.G_MISS_CHAR,
732: resource_country,p_resource_denorm_rec.resource_country),
733: resource_region = DECODE(p_resource_denorm_rec.resource_region, FND_API.G_MISS_CHAR,
734: resource_region,p_resource_denorm_rec.resource_region),
735: resource_city = DECODE(p_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,
736: resource_city,p_resource_denorm_rec.resource_city),
737: last_update_date = sysdate,
738: last_updated_by = fnd_global.user_id,
739: last_update_login = fnd_global.login_id

Line 754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

750: FND_MSG_PUB.add_exc_msg
751: (p_pkg_name => 'PA_RESOURCE_PVT.update_person_res_denorm_recs'
752: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
753:
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
755:
756: END update_person_res_denorm_recs;
757:
758: ------------------------------------------------------------------------------------

Line 774: x_return_status := FND_API.G_RET_STS_SUCCESS;

770: l_new_resource_name pa_resources_denorm.resource_name%TYPE := p_new_resource_denorm_rec.resource_name;
771: l_name_changed VARCHAR2(1):='N'; -- 5336386
772: BEGIN
773: -- Initialize the return status to success
774: x_return_status := FND_API.G_RET_STS_SUCCESS;
775:
776: IF l_new_resource_name = FND_API.G_MISS_CHAR THEN
777: RETURN;
778: END IF;

Line 776: IF l_new_resource_name = FND_API.G_MISS_CHAR THEN

772: BEGIN
773: -- Initialize the return status to success
774: x_return_status := FND_API.G_RET_STS_SUCCESS;
775:
776: IF l_new_resource_name = FND_API.G_MISS_CHAR THEN
777: RETURN;
778: END IF;
779:
780:

Line 817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

813: FND_MSG_PUB.add_exc_msg
814: (p_pkg_name => 'PA_RESOURCE_PVT.update_person_res_denorm_recs',
815: p_procedure_name => 'PA_RESOURCE_PVT.syncronize_manager_name'); --PA_DEBUG.G_Err_Stack ); 5336386
816:
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
818:
819: END syncronize_manager_name;
820:
821:

Line 836: x_return_status := FND_API.G_RET_STS_SUCCESS;

832: x_err_msg_code OUT NOCOPY VARCHAR ) --File.Sql.39 bug 4440895
833: IS
834: BEGIN
835: -- Initialize the return status to success
836: x_return_status := FND_API.G_RET_STS_SUCCESS;
837:
838: -- fixed the bug 1559045 here
839: UPDATE pa_resources_denorm
840: SET

Line 841: resource_job_level = DECODE(p_resource_denorm_rec.resource_job_level, FND_API.G_MISS_NUM,

837:
838: -- fixed the bug 1559045 here
839: UPDATE pa_resources_denorm
840: SET
841: resource_job_level = DECODE(p_resource_denorm_rec.resource_job_level, FND_API.G_MISS_NUM,
842: resource_job_level,p_resource_denorm_rec.resource_job_level),
843: employee_flag = DECODE(p_resource_denorm_rec.employee_flag, FND_API.G_MISS_CHAR,
844: employee_flag, p_resource_denorm_rec.employee_flag),
845: billable_flag = DECODE(p_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,

Line 843: employee_flag = DECODE(p_resource_denorm_rec.employee_flag, FND_API.G_MISS_CHAR,

839: UPDATE pa_resources_denorm
840: SET
841: resource_job_level = DECODE(p_resource_denorm_rec.resource_job_level, FND_API.G_MISS_NUM,
842: resource_job_level,p_resource_denorm_rec.resource_job_level),
843: employee_flag = DECODE(p_resource_denorm_rec.employee_flag, FND_API.G_MISS_CHAR,
844: employee_flag, p_resource_denorm_rec.employee_flag),
845: billable_flag = DECODE(p_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,
846: billable_flag, p_resource_denorm_rec.billable_flag),
847: utilization_flag = DECODE(p_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,

Line 845: billable_flag = DECODE(p_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,

841: resource_job_level = DECODE(p_resource_denorm_rec.resource_job_level, FND_API.G_MISS_NUM,
842: resource_job_level,p_resource_denorm_rec.resource_job_level),
843: employee_flag = DECODE(p_resource_denorm_rec.employee_flag, FND_API.G_MISS_CHAR,
844: employee_flag, p_resource_denorm_rec.employee_flag),
845: billable_flag = DECODE(p_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,
846: billable_flag, p_resource_denorm_rec.billable_flag),
847: utilization_flag = DECODE(p_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,
848: utilization_flag, p_resource_denorm_rec.utilization_flag),
849: schedulable_flag = DECODE(p_resource_denorm_rec.schedulable_flag, FND_API.G_MISS_CHAR,

Line 847: utilization_flag = DECODE(p_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,

843: employee_flag = DECODE(p_resource_denorm_rec.employee_flag, FND_API.G_MISS_CHAR,
844: employee_flag, p_resource_denorm_rec.employee_flag),
845: billable_flag = DECODE(p_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,
846: billable_flag, p_resource_denorm_rec.billable_flag),
847: utilization_flag = DECODE(p_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,
848: utilization_flag, p_resource_denorm_rec.utilization_flag),
849: schedulable_flag = DECODE(p_resource_denorm_rec.schedulable_flag, FND_API.G_MISS_CHAR,
850: schedulable_flag, p_resource_denorm_rec.schedulable_flag),
851: last_update_date = sysdate,

Line 849: schedulable_flag = DECODE(p_resource_denorm_rec.schedulable_flag, FND_API.G_MISS_CHAR,

845: billable_flag = DECODE(p_resource_denorm_rec.billable_flag, FND_API.G_MISS_CHAR,
846: billable_flag, p_resource_denorm_rec.billable_flag),
847: utilization_flag = DECODE(p_resource_denorm_rec.utilization_flag, FND_API.G_MISS_CHAR,
848: utilization_flag, p_resource_denorm_rec.utilization_flag),
849: schedulable_flag = DECODE(p_resource_denorm_rec.schedulable_flag, FND_API.G_MISS_CHAR,
850: schedulable_flag, p_resource_denorm_rec.schedulable_flag),
851: last_update_date = sysdate,
852: last_updated_by = fnd_global.user_id,
853: last_update_login = fnd_global.login_id

Line 865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

861: FND_MSG_PUB.add_exc_msg
862: (p_pkg_name => 'PA_RESOURCE_PVT.update_person_res_denorm_recs'
863: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
864:
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
866:
867: RAISE;
868: END update_job_res_denorm_recs;
869:

Line 891: x_return_status := FND_API.G_RET_STS_SUCCESS;

887: -- l_err_msg_code fnd_new_messages.message_name%TYPE;
888:
889: BEGIN
890: -- Initialize the return status to success
891: x_return_status := FND_API.G_RET_STS_SUCCESS;
892:
893:
894: DELETE FROM PA_RESOURCES_DENORM
895: WHERE person_id = p_person_id

Line 907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

903: FND_MSG_PUB.add_exc_msg
904: ( p_pkg_name => 'PA_RESOURCE_PVT.delete_resource_denorm'
905: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
906:
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
908: END delete_resource_denorm;
909:
910:
911:

Line 970: x_return_status := FND_API.G_RET_STS_SUCCESS;

966: BEGIN
967:
968:
969: -- Initialize the return status to success
970: x_return_status := FND_API.G_RET_STS_SUCCESS;
971:
972:
973: -- The delete logic deletes all overlapping records in pa_resources_denorm
974: -- for the incoming assignment record

Line 1012: FND_API.G_EXC_ERROR being raised a generic call for any excpetion. */

1008:
1009: IF (l_billable_flag = 'X') OR (l_resource_job_level = -99) OR
1010: (l_utilization_flag = 'X') OR (l_schedulable_flag='X') THEN
1011: /* Bug 5689674: Added code to pass the error message to make the
1012: FND_API.G_EXC_ERROR being raised a generic call for any excpetion. */
1013:
1014: PA_UTILS.Add_Message(
1015: p_app_short_name => 'PA'
1016: ,p_msg_name => 'PA_MULT_INF_TYPES_FOR_JOB');

Line 1018: RAISE FND_API.G_EXC_ERROR;

1014: PA_UTILS.Add_Message(
1015: p_app_short_name => 'PA'
1016: ,p_msg_name => 'PA_MULT_INF_TYPES_FOR_JOB');
1017: /* End of changes Bug for 5689674 */
1018: RAISE FND_API.G_EXC_ERROR;
1019: END IF;
1020:
1021: /* Bug 2898766 - End */
1022:

Line 1174: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

1170:
1171: /* Bug 5689674: Added the below exception handling to throw an error without
1172: proceeding on inserting into pa_resources_denorm. This will show the
1173: error as an exception in the report output. */
1174: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1175: IF l_error_msg_code IS NOT NULL THEN
1176: pa_utils.add_message
1177: ( p_app_short_name => 'PA',
1178: p_msg_name => l_error_msg_code);

Line 1180: RAISE FND_API.G_EXC_ERROR;

1176: pa_utils.add_message
1177: ( p_app_short_name => 'PA',
1178: p_msg_name => l_error_msg_code);
1179: END IF;
1180: RAISE FND_API.G_EXC_ERROR;
1181: END IF;
1182: /* End of changes for Bug 5689674 */
1183:
1184: INSERT INTO PA_RESOURCES_DENORM ( person_id

Line 1260: x_return_status := FND_API.G_RET_STS_ERROR;

1256: x_msg_count := FND_MSG_PUB.Count_Msg;
1257:
1258: IF x_msg_count > 0 THEN
1259:
1260: x_return_status := FND_API.G_RET_STS_ERROR;
1261:
1262: END IF;
1263:
1264: IF p_commit = FND_API.G_TRUE AND l_msg_count=0 THEN

Line 1264: IF p_commit = FND_API.G_TRUE AND l_msg_count=0 THEN

1260: x_return_status := FND_API.G_RET_STS_ERROR;
1261:
1262: END IF;
1263:
1264: IF p_commit = FND_API.G_TRUE AND l_msg_count=0 THEN
1265:
1266: COMMIT;
1267:
1268: END IF;

Line 1273: WHEN FND_API.G_EXC_ERROR THEN

1269:
1270: EXCEPTION
1271: /* Bug 2898766 - save the error message in the pa_reporting_exceptions table */
1272:
1273: WHEN FND_API.G_EXC_ERROR THEN
1274: /* Bug 5689674: Modified the code to make the exception handling generic. */
1275:
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277:

Line 1276: x_return_status := FND_API.G_RET_STS_ERROR;

1272:
1273: WHEN FND_API.G_EXC_ERROR THEN
1274: /* Bug 5689674: Modified the code to make the exception handling generic. */
1275:
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277:
1278: -- Reset the error stack when returning to the calling program
1279: PA_DEBUG.Reset_Err_Stack;
1280:

Line 1288: (p_encoded => FND_API.G_TRUE

1284: -- Put a message text from message stack into the x_msg_data if there is only
1285: -- single error.
1286: IF x_msg_count = 1 THEN
1287: pa_interface_utils_pub.get_messages
1288: (p_encoded => FND_API.G_TRUE
1289: ,p_msg_index => 1
1290: ,p_data => x_msg_data
1291: ,p_msg_index_out => l_msg_index_out);
1292: END IF;

Line 1312: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1308: /* Bug 2898766 - End */
1309: WHEN OTHERS THEN
1310: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_RESOURCE_PVT.Populate_Resources_Denorm'
1311: , p_procedure_name => PA_DEBUG.G_Err_Stack);
1312: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1313: RAISE;
1314:
1315: END Populate_Resources_Denorm;
1316:

Line 1572: x_return_status := FND_API.G_RET_STS_SUCCESS;

1568: -- initialize error stack
1569: fnd_msg_pub.initialize;
1570:
1571: -- set return status to Success
1572: x_return_status := FND_API.G_RET_STS_SUCCESS;
1573:
1574: IF(p_org_name IS NOT NULL) THEN
1575: -- check whether organization name is valid
1576: PA_HR_ORG_UTILS.Check_OrgName_Or_Id (

Line 1584: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1580: x_organization_id => x_org_id,
1581: x_return_status => l_return_status,
1582: x_error_msg_code => l_error_message_code);
1583:
1584: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1585: PA_UTILS.Add_Message (
1586: p_app_short_name => 'PA'
1587: ,p_msg_name => l_error_message_code );
1588: END IF;

Line 1607: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1603: ,x_msg_count => l_msg_count
1604: ,x_return_status => l_return_status
1605: ,x_error_message_code => l_error_message_code);
1606:
1607: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1608: PA_UTILS.Add_Message(
1609: p_app_short_name => 'PA'
1610: ,p_msg_name => l_error_message_code);
1611: END IF;

Line 1619: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

1615:
1616: x_msg_count := FND_MSG_PUB.Count_Msg;
1617:
1618: IF x_msg_count = 1 THEN
1619: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1620: ,p_msg_index => 1
1621: ,p_data => x_msg_data
1622: ,p_msg_index_out => l_msg_index_out);
1623: END IF;

Line 1626: x_return_status := FND_API.G_RET_STS_ERROR;

1622: ,p_msg_index_out => l_msg_index_out);
1623: END IF;
1624:
1625: IF x_msg_count <> 0 THEN
1626: x_return_status := FND_API.G_RET_STS_ERROR;
1627: END IF;
1628:
1629: EXCEPTION
1630: WHEN OTHERS THEN

Line 1633: x_return_status := FND_API.G_RET_STS_ERROR;

1629: EXCEPTION
1630: WHEN OTHERS THEN
1631: x_manager_id := NULL;
1632: x_org_id := NULL;
1633: x_return_status := FND_API.G_RET_STS_ERROR;
1634: END Validate_Staff_Filter_Values;
1635:
1636: FUNCTION get_res_conf_availability( p_resource_id IN NUMBER,
1637: p_start_date IN DATE,

Line 1734: x_return_status := FND_API.G_RET_STS_SUCCESS;

1730:
1731: BEGIN
1732:
1733: -- Initialize the return status to success
1734: x_return_status := FND_API.G_RET_STS_SUCCESS;
1735:
1736: l_created_by := fnd_global.user_id;
1737: l_last_updated_by := fnd_global.user_id;
1738: l_last_update_login := fnd_global.login_id;

Line 2639: x_return_status := FND_API.G_RET_STS_ERROR;

2635: PA_UTILS.Add_Message(
2636: p_app_short_name => 'PA'
2637: ,p_msg_name => 'PA_NO_AVL_CALC_PROF');
2638:
2639: x_return_status := FND_API.G_RET_STS_ERROR;
2640:
2641: RETURN;
2642: END IF;
2643:

Line 2712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2708:
2709: EXCEPTION
2710: WHEN OTHERS THEN
2711:
2712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2713: RAISE;
2714:
2715: END populate_res_availability;
2716:

Line 2748: x_return_status := FND_API.G_RET_STS_SUCCESS;

2744: -- Initialize the Error Stack
2745: PA_DEBUG.init_err_stack('PA_RESOURCE_PVT.Update_Res_Availability');
2746:
2747: -- Initialize the return status to success
2748: x_return_status := FND_API.G_RET_STS_SUCCESS;
2749:
2750: BEGIN
2751:
2752: select min(resource_effective_start_date)

Line 2783: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2779: p_bstart_date => trunc(l_start_date),
2780: p_bend_date => trunc(l_end_date),
2781: x_return_status => x_return_status );
2782:
2783: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2784: RAISE FND_API.G_EXC_ERROR;
2785: END IF;
2786:
2787: EXCEPTION

Line 2784: RAISE FND_API.G_EXC_ERROR;

2780: p_bend_date => trunc(l_end_date),
2781: x_return_status => x_return_status );
2782:
2783: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2784: RAISE FND_API.G_EXC_ERROR;
2785: END IF;
2786:
2787: EXCEPTION
2788: WHEN FND_API.G_EXC_ERROR THEN

Line 2788: WHEN FND_API.G_EXC_ERROR THEN

2784: RAISE FND_API.G_EXC_ERROR;
2785: END IF;
2786:
2787: EXCEPTION
2788: WHEN FND_API.G_EXC_ERROR THEN
2789: x_return_status := FND_API.G_RET_STS_ERROR;
2790:
2791: -- Reset the error stack when returning to the calling program
2792: PA_DEBUG.Reset_Err_Stack;

Line 2789: x_return_status := FND_API.G_RET_STS_ERROR;

2785: END IF;
2786:
2787: EXCEPTION
2788: WHEN FND_API.G_EXC_ERROR THEN
2789: x_return_status := FND_API.G_RET_STS_ERROR;
2790:
2791: -- Reset the error stack when returning to the calling program
2792: PA_DEBUG.Reset_Err_Stack;
2793:

Line 2801: (p_encoded => FND_API.G_TRUE

2797: -- Put a message text from message stack into the x_msg_data if there is only
2798: -- single error.
2799: IF x_msg_count = 1 THEN
2800: pa_interface_utils_pub.get_messages
2801: (p_encoded => FND_API.G_TRUE
2802: ,p_msg_index => 1
2803: ,p_data => x_msg_data
2804: ,p_msg_index_out => l_msg_index_out);
2805: END IF;

Line 2815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2811: FND_MSG_PUB.add_exc_msg
2812: (p_pkg_name => 'PA_RESOURCE_PVT.Update_Res_Availability'
2813: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2814:
2815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2816:
2817: RAISE;
2818:
2819: END Update_Res_Availability;

Line 2891: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2887: x_return_status => l_return_status );
2888:
2889: l_res_count := l_res_count + 1; --Added for bug 4928773
2890:
2891: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2892:
2893: ROLLBACK TO s_res_avl_begin;
2894: retcode := 2;
2895: EXIT;

Line 2930: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2926: -1
2927: );
2928:
2929:
2930: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2931: retcode := 2;
2932: RAISE FND_API.G_EXC_ERROR;
2933: END IF;
2934:

Line 2932: RAISE FND_API.G_EXC_ERROR;

2928:
2929:
2930: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2931: retcode := 2;
2932: RAISE FND_API.G_EXC_ERROR;
2933: END IF;
2934:
2935: COMMIT;
2936:

Line 2940: WHEN FND_API.G_EXC_ERROR THEN

2936:
2937: retcode := 0;
2938:
2939: EXCEPTION
2940: WHEN FND_API.G_EXC_ERROR THEN
2941:
2942: ROLLBACK TO s_res_avl_begin;
2943:
2944: retcode := 2;