DBA Data[Home] [Help]

APPS.PA_IMPL_OPTIONS_PUB dependencies on FND_API

Line 58: x_return_status := FND_API.G_RET_STS_SUCCESS;

54:
55: UPDATE pa_implementations
56: SET ENABLE_MRC_FOR_FUND_FLAG = 'U';
57:
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59: EXCEPTION
60: WHEN OTHERS THEN
61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
62: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_IMPL_OPTIONS_PUB',

Line 61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

57:
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59: EXCEPTION
60: WHEN OTHERS THEN
61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
62: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_IMPL_OPTIONS_PUB',
63: p_procedure_name => 'Upgrade_MRC_fund_bud_flag',
64: p_error_text => SUBSTRB(SQLERRM,1,240));
65: rollback to upgrade_ou;

Line 409: x_return_status := FND_API.G_RET_STS_SUCCESS;

405: l_dummy_char VARCHAR2(1);
406: l_api_name CONSTANT VARCHAR2(30) := 'check_asset_alloc_method';
407: BEGIN
408:
409: x_return_status := FND_API.G_RET_STS_SUCCESS;
410:
411: OPEN cur_lookup;
412: FETCH cur_lookup INTO l_dummy_char;
413: IF cur_lookup%NOTFOUND

Line 429: RAISE FND_API.G_EXC_ERROR;

425: ,p_attribute3 => ''
426: ,p_attribute4 => ''
427: ,p_attribute5 => '');
428: END IF;
429: RAISE FND_API.G_EXC_ERROR;
430: ELSE
431: CLOSE cur_lookup;
432: END IF;
433:

Line 436: WHEN FND_API.G_EXC_ERROR

432: END IF;
433:
434: EXCEPTION
435:
436: WHEN FND_API.G_EXC_ERROR
437: THEN
438: x_return_status := FND_API.G_RET_STS_ERROR;
439:
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 438: x_return_status := FND_API.G_RET_STS_ERROR;

434: EXCEPTION
435:
436: WHEN FND_API.G_EXC_ERROR
437: THEN
438: x_return_status := FND_API.G_RET_STS_ERROR;
439:
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
441: THEN
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

436: WHEN FND_API.G_EXC_ERROR
437: THEN
438: x_return_status := FND_API.G_RET_STS_ERROR;
439:
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
441: THEN
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443:
444: WHEN OTHERS THEN

Line 442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

438: x_return_status := FND_API.G_RET_STS_ERROR;
439:
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
441: THEN
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443:
444: WHEN OTHERS THEN
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446:

Line 445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

441: THEN
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443:
444: WHEN OTHERS THEN
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446:
447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
448: THEN
449: FND_MSG_PUB.add_exc_msg

Line 473: x_return_status := FND_API.G_RET_STS_SUCCESS;

469: l_dummy_char VARCHAR2(1);
470: l_api_name CONSTANT VARCHAR2(30) := 'check_cap_event_method';
471: BEGIN
472:
473: x_return_status := FND_API.G_RET_STS_SUCCESS;
474:
475: OPEN cur_lookup;
476: FETCH cur_lookup INTO l_dummy_char;
477: IF cur_lookup%NOTFOUND

Line 493: RAISE FND_API.G_EXC_ERROR;

489: ,p_attribute3 => ''
490: ,p_attribute4 => ''
491: ,p_attribute5 => '');
492: END IF;
493: RAISE FND_API.G_EXC_ERROR;
494: ELSE
495: CLOSE cur_lookup;
496: END IF;
497:

Line 500: WHEN FND_API.G_EXC_ERROR

496: END IF;
497:
498: EXCEPTION
499:
500: WHEN FND_API.G_EXC_ERROR
501: THEN
502: x_return_status := FND_API.G_RET_STS_ERROR;
503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 502: x_return_status := FND_API.G_RET_STS_ERROR;

498: EXCEPTION
499:
500: WHEN FND_API.G_EXC_ERROR
501: THEN
502: x_return_status := FND_API.G_RET_STS_ERROR;
503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
505: THEN
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

500: WHEN FND_API.G_EXC_ERROR
501: THEN
502: x_return_status := FND_API.G_RET_STS_ERROR;
503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
505: THEN
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507:
508: WHEN OTHERS THEN

Line 506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

502: x_return_status := FND_API.G_RET_STS_ERROR;
503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
505: THEN
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507:
508: WHEN OTHERS THEN
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510:

Line 509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

505: THEN
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507:
508: WHEN OTHERS THEN
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510:
511: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
512: THEN
513: FND_MSG_PUB.add_exc_msg

Line 540: x_return_status := FND_API.G_RET_STS_SUCCESS;

536: l_dummy_char VARCHAR2(1);
537: l_api_name CONSTANT VARCHAR2(30) := 'check_cint_schedule';
538: BEGIN
539:
540: x_return_status := FND_API.G_RET_STS_SUCCESS;
541:
542: OPEN cur_sch;
543: FETCH cur_sch INTO l_dummy_char;
544: IF cur_sch%NOTFOUND

Line 560: RAISE FND_API.G_EXC_ERROR;

556: ,p_attribute3 => ''
557: ,p_attribute4 => ''
558: ,p_attribute5 => '');
559: END IF;
560: RAISE FND_API.G_EXC_ERROR;
561: ELSE
562: CLOSE cur_sch;
563: END IF;
564:

Line 567: WHEN FND_API.G_EXC_ERROR

563: END IF;
564:
565: EXCEPTION
566:
567: WHEN FND_API.G_EXC_ERROR
568: THEN
569: x_return_status := FND_API.G_RET_STS_ERROR;
570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 569: x_return_status := FND_API.G_RET_STS_ERROR;

565: EXCEPTION
566:
567: WHEN FND_API.G_EXC_ERROR
568: THEN
569: x_return_status := FND_API.G_RET_STS_ERROR;
570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
572: THEN
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

567: WHEN FND_API.G_EXC_ERROR
568: THEN
569: x_return_status := FND_API.G_RET_STS_ERROR;
570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
572: THEN
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574:
575: WHEN OTHERS THEN

Line 573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

569: x_return_status := FND_API.G_RET_STS_ERROR;
570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
572: THEN
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574:
575: WHEN OTHERS THEN
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577:

Line 576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

572: THEN
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574:
575: WHEN OTHERS THEN
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577:
578: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
579: THEN
580: FND_MSG_PUB.add_exc_msg