437: CLOSE c_getid;
438: RETURN( id );
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:
438: RETURN( id );
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
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',
452: 'gl_budget_utils_pkg.get_unique_id');
453: RAISE;
454: END get_unique_id;
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',
452: 'gl_budget_utils_pkg.get_unique_id');
453: RAISE;
454: END get_unique_id;
455:
572: FROM gl_ledgers
573: WHERE ledger_id = X_Ledger_Id;
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:
573: WHERE ledger_id = X_Ledger_Id;
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(
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;
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:
594: INTO v_first_valid_period_year, v_first_valid_period_num;
595:
596: IF chk_first_period%NOTFOUND THEN
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;
595:
596: IF chk_first_period%NOTFOUND THEN
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:
596: IF chk_first_period%NOTFOUND THEN
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;
609: INTO v_last_valid_period_year, v_last_valid_period_num;
610:
611: IF chk_last_period%NOTFOUND THEN
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;
610:
611: IF chk_last_period%NOTFOUND THEN
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:
611: IF chk_last_period%NOTFOUND THEN
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;
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;
627:
628: END validate_budget;
629: