DBA Data[Home] [Help]

APPS.GL_BUDGET_UTILS_PKG dependencies on FND_MESSAGE

Line 441: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');

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:

Line 442: fnd_message.set_token('SEQUENCE', 'GL_BUDGET_FROZEN_RANGES_S');

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

Line 450: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_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;

Line 451: fnd_message.set_token('PROCEDURE',

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:

Line 576: fnd_message.set_name('SQLGL', 'GL_API_BUDGET_REQUIRE_JOURNALS');

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:

Line 577: fnd_message.set_token('LEDGER_NAME', v_ledger_name);

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(

Line 585: fnd_message.set_name('SQLGL', 'GL_API_BUDGET_FUNDING_JOURNALS');

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;

Line 586: fnd_message.set_token('BUDGET', X_Budget_Name);

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:

Line 598: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');

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;

Line 599: fnd_message.set_token('VALUE', NVL(X_First_Valid_Period_Name, 'null'));

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:

Line 600: fnd_message.set_token('ATTRIBUTE', 'FirstValidPeriodName');

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;

Line 613: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');

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;

Line 614: fnd_message.set_token('VALUE', NVL(X_Last_Valid_Period_Name, 'null'));

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:

Line 615: fnd_message.set_token('ATTRIBUTE', 'LastValidPeriodName');

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;

Line 625: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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: