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: -- Bug#6875286

Line 1044: x_return_status := FND_API.G_RET_STS_SUCCESS;

1040: BEGIN
1041:
1042:
1043: -- Initialize the return status to success
1044: x_return_status := FND_API.G_RET_STS_SUCCESS;
1045:
1046:
1047: -- The delete logic deletes all overlapping records in pa_resources_denorm
1048: -- for the incoming assignment record

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

1101:
1102: IF (l_billable_flag = 'X') OR (l_resource_job_level = -99) OR
1103: (l_utilization_flag = 'X') OR (l_schedulable_flag='X') THEN
1104: /* Bug 5689674: Added code to pass the error message to make the
1105: FND_API.G_EXC_ERROR being raised a generic call for any excpetion. */
1106:
1107: PA_UTILS.Add_Message(
1108: p_app_short_name => 'PA'
1109: ,p_msg_name => 'PA_MULT_INF_TYPES_FOR_JOB');

Line 1111: RAISE FND_API.G_EXC_ERROR;

1107: PA_UTILS.Add_Message(
1108: p_app_short_name => 'PA'
1109: ,p_msg_name => 'PA_MULT_INF_TYPES_FOR_JOB');
1110: /* End of changes Bug for 5689674 */
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113:
1114: /* Bug 2898766 - End */
1115:

Line 1267: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

1263:
1264: /* Bug 5689674: Added the below exception handling to throw an error without
1265: proceeding on inserting into pa_resources_denorm. This will show the
1266: error as an exception in the report output. */
1267: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1268: IF l_error_msg_code IS NOT NULL THEN
1269: pa_utils.add_message
1270: ( p_app_short_name => 'PA',
1271: p_msg_name => l_error_msg_code);

Line 1273: RAISE FND_API.G_EXC_ERROR;

1269: pa_utils.add_message
1270: ( p_app_short_name => 'PA',
1271: p_msg_name => l_error_msg_code);
1272: END IF;
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275: /* End of changes for Bug 5689674 */
1276:
1277: INSERT INTO PA_RESOURCES_DENORM ( person_id

Line 1353: x_return_status := FND_API.G_RET_STS_ERROR;

1349: x_msg_count := FND_MSG_PUB.Count_Msg;
1350:
1351: IF x_msg_count > 0 THEN
1352:
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354:
1355: END IF;
1356:
1357: IF p_commit = FND_API.G_TRUE AND l_msg_count=0 THEN

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

1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354:
1355: END IF;
1356:
1357: IF p_commit = FND_API.G_TRUE AND l_msg_count=0 THEN
1358:
1359: COMMIT;
1360:
1361: END IF;

Line 1366: WHEN FND_API.G_EXC_ERROR THEN

1362:
1363: EXCEPTION
1364: /* Bug 2898766 - save the error message in the pa_reporting_exceptions table */
1365:
1366: WHEN FND_API.G_EXC_ERROR THEN
1367: /* Bug 5689674: Modified the code to make the exception handling generic. */
1368:
1369: x_return_status := FND_API.G_RET_STS_ERROR;
1370:

Line 1369: x_return_status := FND_API.G_RET_STS_ERROR;

1365:
1366: WHEN FND_API.G_EXC_ERROR THEN
1367: /* Bug 5689674: Modified the code to make the exception handling generic. */
1368:
1369: x_return_status := FND_API.G_RET_STS_ERROR;
1370:
1371: -- Reset the error stack when returning to the calling program
1372: PA_DEBUG.Reset_Err_Stack;
1373:

Line 1381: (p_encoded => FND_API.G_TRUE

1377: -- Put a message text from message stack into the x_msg_data if there is only
1378: -- single error.
1379: IF x_msg_count = 1 THEN
1380: pa_interface_utils_pub.get_messages
1381: (p_encoded => FND_API.G_TRUE
1382: ,p_msg_index => 1
1383: ,p_data => x_msg_data
1384: ,p_msg_index_out => l_msg_index_out);
1385: END IF;

Line 1405: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1401: /* Bug 2898766 - End */
1402: WHEN OTHERS THEN
1403: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_RESOURCE_PVT.Populate_Resources_Denorm'
1404: , p_procedure_name => PA_DEBUG.G_Err_Stack);
1405: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1406: RAISE;
1407:
1408: END Populate_Resources_Denorm;
1409:

Line 1671: x_return_status := FND_API.G_RET_STS_SUCCESS;

1667: -- initialize error stack
1668: fnd_msg_pub.initialize;
1669:
1670: -- set return status to Success
1671: x_return_status := FND_API.G_RET_STS_SUCCESS;
1672:
1673: IF(p_org_name IS NOT NULL) THEN
1674: -- check whether organization name is valid
1675: PA_HR_ORG_UTILS.Check_OrgName_Or_Id (

Line 1683: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1679: x_organization_id => x_org_id,
1680: x_return_status => l_return_status,
1681: x_error_msg_code => l_error_message_code);
1682:
1683: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1684: PA_UTILS.Add_Message (
1685: p_app_short_name => 'PA'
1686: ,p_msg_name => l_error_message_code );
1687: END IF;

Line 1706: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1702: ,x_msg_count => l_msg_count
1703: ,x_return_status => l_return_status
1704: ,x_error_message_code => l_error_message_code);
1705:
1706: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1707: PA_UTILS.Add_Message(
1708: p_app_short_name => 'PA'
1709: ,p_msg_name => l_error_message_code);
1710: END IF;

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

1714:
1715: x_msg_count := FND_MSG_PUB.Count_Msg;
1716:
1717: IF x_msg_count = 1 THEN
1718: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1719: ,p_msg_index => 1
1720: ,p_data => x_msg_data
1721: ,p_msg_index_out => l_msg_index_out);
1722: END IF;

Line 1725: x_return_status := FND_API.G_RET_STS_ERROR;

1721: ,p_msg_index_out => l_msg_index_out);
1722: END IF;
1723:
1724: IF x_msg_count <> 0 THEN
1725: x_return_status := FND_API.G_RET_STS_ERROR;
1726: END IF;
1727:
1728: EXCEPTION
1729: WHEN OTHERS THEN

Line 1732: x_return_status := FND_API.G_RET_STS_ERROR;

1728: EXCEPTION
1729: WHEN OTHERS THEN
1730: x_manager_id := NULL;
1731: x_org_id := NULL;
1732: x_return_status := FND_API.G_RET_STS_ERROR;
1733: END Validate_Staff_Filter_Values;
1734:
1735: FUNCTION get_res_conf_availability( p_resource_id IN NUMBER,
1736: p_start_date IN DATE,

Line 1833: x_return_status := FND_API.G_RET_STS_SUCCESS;

1829:
1830: BEGIN
1831:
1832: -- Initialize the return status to success
1833: x_return_status := FND_API.G_RET_STS_SUCCESS;
1834:
1835: l_created_by := fnd_global.user_id;
1836: l_last_updated_by := fnd_global.user_id;
1837: l_last_update_login := fnd_global.login_id;

Line 2738: x_return_status := FND_API.G_RET_STS_ERROR;

2734: PA_UTILS.Add_Message(
2735: p_app_short_name => 'PA'
2736: ,p_msg_name => 'PA_NO_AVL_CALC_PROF');
2737:
2738: x_return_status := FND_API.G_RET_STS_ERROR;
2739:
2740: RETURN;
2741: END IF;
2742:

Line 2811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2807:
2808: EXCEPTION
2809: WHEN OTHERS THEN
2810:
2811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2812: RAISE;
2813:
2814: END populate_res_availability;
2815:

Line 2847: x_return_status := FND_API.G_RET_STS_SUCCESS;

2843: -- Initialize the Error Stack
2844: PA_DEBUG.init_err_stack('PA_RESOURCE_PVT.Update_Res_Availability');
2845:
2846: -- Initialize the return status to success
2847: x_return_status := FND_API.G_RET_STS_SUCCESS;
2848:
2849: BEGIN
2850:
2851: select min(resource_effective_start_date)

Line 2882: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2878: p_bstart_date => trunc(l_start_date),
2879: p_bend_date => trunc(l_end_date),
2880: x_return_status => x_return_status );
2881:
2882: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2883: RAISE FND_API.G_EXC_ERROR;
2884: END IF;
2885:
2886: EXCEPTION

Line 2883: RAISE FND_API.G_EXC_ERROR;

2879: p_bend_date => trunc(l_end_date),
2880: x_return_status => x_return_status );
2881:
2882: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2883: RAISE FND_API.G_EXC_ERROR;
2884: END IF;
2885:
2886: EXCEPTION
2887: WHEN FND_API.G_EXC_ERROR THEN

Line 2887: WHEN FND_API.G_EXC_ERROR THEN

2883: RAISE FND_API.G_EXC_ERROR;
2884: END IF;
2885:
2886: EXCEPTION
2887: WHEN FND_API.G_EXC_ERROR THEN
2888: x_return_status := FND_API.G_RET_STS_ERROR;
2889:
2890: -- Reset the error stack when returning to the calling program
2891: PA_DEBUG.Reset_Err_Stack;

Line 2888: x_return_status := FND_API.G_RET_STS_ERROR;

2884: END IF;
2885:
2886: EXCEPTION
2887: WHEN FND_API.G_EXC_ERROR THEN
2888: x_return_status := FND_API.G_RET_STS_ERROR;
2889:
2890: -- Reset the error stack when returning to the calling program
2891: PA_DEBUG.Reset_Err_Stack;
2892:

Line 2900: (p_encoded => FND_API.G_TRUE

2896: -- Put a message text from message stack into the x_msg_data if there is only
2897: -- single error.
2898: IF x_msg_count = 1 THEN
2899: pa_interface_utils_pub.get_messages
2900: (p_encoded => FND_API.G_TRUE
2901: ,p_msg_index => 1
2902: ,p_data => x_msg_data
2903: ,p_msg_index_out => l_msg_index_out);
2904: END IF;

Line 2914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2910: FND_MSG_PUB.add_exc_msg
2911: (p_pkg_name => 'PA_RESOURCE_PVT.Update_Res_Availability'
2912: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2913:
2914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2915:
2916: RAISE;
2917:
2918: END Update_Res_Availability;

Line 2990: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2986: x_return_status => l_return_status );
2987:
2988: l_res_count := l_res_count + 1; --Added for bug 4928773
2989:
2990: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2991:
2992: ROLLBACK TO s_res_avl_begin;
2993: retcode := 2;
2994: EXIT;

Line 3029: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3025: -1
3026: );
3027:
3028:
3029: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3030: retcode := 2;
3031: RAISE FND_API.G_EXC_ERROR;
3032: END IF;
3033:

Line 3031: RAISE FND_API.G_EXC_ERROR;

3027:
3028:
3029: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3030: retcode := 2;
3031: RAISE FND_API.G_EXC_ERROR;
3032: END IF;
3033:
3034: COMMIT;
3035:

Line 3039: WHEN FND_API.G_EXC_ERROR THEN

3035:
3036: retcode := 0;
3037:
3038: EXCEPTION
3039: WHEN FND_API.G_EXC_ERROR THEN
3040:
3041: ROLLBACK TO s_res_avl_begin;
3042:
3043: retcode := 2;