439: ELSE
440: CLOSE c_getid;
441: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
442: fnd_message.set_token('SEQUENCE', 'GL_BUDGET_FROZEN_RANGES_S');
443: app_exception.raise_exception;
444: END IF;
445:
446: EXCEPTION
447: WHEN APP_EXCEPTION.application_exception THEN
443: app_exception.raise_exception;
444: END IF;
445:
446: EXCEPTION
447: WHEN APP_EXCEPTION.application_exception THEN
448: RAISE;
449: WHEN OTHERS THEN
450: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
451: fnd_message.set_token('PROCEDURE',
574:
575: IF (v_rbj_flag = 'Y') THEN
576: fnd_message.set_name('SQLGL', 'GL_API_BUDGET_REQUIRE_JOURNALS');
577: fnd_message.set_token('LEDGER_NAME', v_ledger_name);
578: app_exception.raise_exception;
579: END IF;
580:
581: IF (gl_budget_utils_pkg.is_funding_budget(
582: X_Ledger_Id,
583: v_func_curr_code,
584: X_Budget_Version_Id)) THEN
585: fnd_message.set_name('SQLGL', 'GL_API_BUDGET_FUNDING_JOURNALS');
586: fnd_message.set_token('BUDGET', X_Budget_Name);
587: app_exception.raise_exception;
588: END IF;
589: END IF;
590:
591: -- validate First_Valid_Period_Name
597: CLOSE chk_first_period;
598: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');
599: fnd_message.set_token('VALUE', NVL(X_First_Valid_Period_Name, 'null'));
600: fnd_message.set_token('ATTRIBUTE', 'FirstValidPeriodName');
601: app_exception.raise_exception;
602: END IF;
603:
604: CLOSE chk_first_period;
605:
612: CLOSE chk_last_period;
613: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');
614: fnd_message.set_token('VALUE', NVL(X_Last_Valid_Period_Name, 'null'));
615: fnd_message.set_token('ATTRIBUTE', 'LastValidPeriodName');
616: app_exception.raise_exception;
617: END IF;
618:
619: CLOSE chk_last_period;
620:
618:
619: CLOSE chk_last_period;
620:
621: EXCEPTION
622: WHEN app_exceptions.application_exception THEN
623: RAISE;
624: WHEN OTHERS THEN
625: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
626: RAISE;