DBA Data[Home] [Help]

APPS.GL_BUDGET_UTILS_PKG dependencies on FND_MESSAGE

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

420: CLOSE c_getid;
421: RETURN( id );
422: ELSE
423: CLOSE c_getid;
424: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
425: fnd_message.set_token('SEQUENCE', 'GL_BUDGET_FROZEN_RANGES_S');
426: app_exception.raise_exception;
427: END IF;
428:

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

421: RETURN( id );
422: ELSE
423: CLOSE c_getid;
424: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
425: fnd_message.set_token('SEQUENCE', 'GL_BUDGET_FROZEN_RANGES_S');
426: app_exception.raise_exception;
427: END IF;
428:
429: EXCEPTION

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

429: EXCEPTION
430: WHEN APP_EXCEPTION.application_exception THEN
431: RAISE;
432: WHEN OTHERS THEN
433: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
434: fnd_message.set_token('PROCEDURE',
435: 'gl_budget_utils_pkg.get_unique_id');
436: RAISE;
437: END get_unique_id;

Line 434: fnd_message.set_token('PROCEDURE',

430: WHEN APP_EXCEPTION.application_exception THEN
431: RAISE;
432: WHEN OTHERS THEN
433: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
434: fnd_message.set_token('PROCEDURE',
435: 'gl_budget_utils_pkg.get_unique_id');
436: RAISE;
437: END get_unique_id;
438:

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

555: FROM gl_ledgers
556: WHERE ledger_id = X_Ledger_Id;
557:
558: IF (v_rbj_flag = 'Y') THEN
559: fnd_message.set_name('SQLGL', 'GL_API_BUDGET_REQUIRE_JOURNALS');
560: fnd_message.set_token('LEDGER_NAME', v_ledger_name);
561: app_exception.raise_exception;
562: END IF;
563:

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

556: WHERE ledger_id = X_Ledger_Id;
557:
558: IF (v_rbj_flag = 'Y') THEN
559: fnd_message.set_name('SQLGL', 'GL_API_BUDGET_REQUIRE_JOURNALS');
560: fnd_message.set_token('LEDGER_NAME', v_ledger_name);
561: app_exception.raise_exception;
562: END IF;
563:
564: IF (gl_budget_utils_pkg.is_funding_budget(

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

564: IF (gl_budget_utils_pkg.is_funding_budget(
565: X_Ledger_Id,
566: v_func_curr_code,
567: X_Budget_Version_Id)) THEN
568: fnd_message.set_name('SQLGL', 'GL_API_BUDGET_FUNDING_JOURNALS');
569: fnd_message.set_token('BUDGET', X_Budget_Name);
570: app_exception.raise_exception;
571: END IF;
572: END IF;

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

565: X_Ledger_Id,
566: v_func_curr_code,
567: X_Budget_Version_Id)) THEN
568: fnd_message.set_name('SQLGL', 'GL_API_BUDGET_FUNDING_JOURNALS');
569: fnd_message.set_token('BUDGET', X_Budget_Name);
570: app_exception.raise_exception;
571: END IF;
572: END IF;
573:

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

577: INTO v_first_valid_period_year, v_first_valid_period_num;
578:
579: IF chk_first_period%NOTFOUND THEN
580: CLOSE chk_first_period;
581: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');
582: fnd_message.set_token('VALUE', NVL(X_First_Valid_Period_Name, 'null'));
583: fnd_message.set_token('ATTRIBUTE', 'FirstValidPeriodName');
584: app_exception.raise_exception;
585: END IF;

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

578:
579: IF chk_first_period%NOTFOUND THEN
580: CLOSE chk_first_period;
581: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');
582: fnd_message.set_token('VALUE', NVL(X_First_Valid_Period_Name, 'null'));
583: fnd_message.set_token('ATTRIBUTE', 'FirstValidPeriodName');
584: app_exception.raise_exception;
585: END IF;
586:

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

579: IF chk_first_period%NOTFOUND THEN
580: CLOSE chk_first_period;
581: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');
582: fnd_message.set_token('VALUE', NVL(X_First_Valid_Period_Name, 'null'));
583: fnd_message.set_token('ATTRIBUTE', 'FirstValidPeriodName');
584: app_exception.raise_exception;
585: END IF;
586:
587: CLOSE chk_first_period;

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

592: INTO v_last_valid_period_year, v_last_valid_period_num;
593:
594: IF chk_last_period%NOTFOUND THEN
595: CLOSE chk_last_period;
596: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');
597: fnd_message.set_token('VALUE', NVL(X_Last_Valid_Period_Name, 'null'));
598: fnd_message.set_token('ATTRIBUTE', 'LastValidPeriodName');
599: app_exception.raise_exception;
600: END IF;

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

593:
594: IF chk_last_period%NOTFOUND THEN
595: CLOSE chk_last_period;
596: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');
597: fnd_message.set_token('VALUE', NVL(X_Last_Valid_Period_Name, 'null'));
598: fnd_message.set_token('ATTRIBUTE', 'LastValidPeriodName');
599: app_exception.raise_exception;
600: END IF;
601:

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

594: IF chk_last_period%NOTFOUND THEN
595: CLOSE chk_last_period;
596: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');
597: fnd_message.set_token('VALUE', NVL(X_Last_Valid_Period_Name, 'null'));
598: fnd_message.set_token('ATTRIBUTE', 'LastValidPeriodName');
599: app_exception.raise_exception;
600: END IF;
601:
602: CLOSE chk_last_period;

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

604: EXCEPTION
605: WHEN app_exceptions.application_exception THEN
606: RAISE;
607: WHEN OTHERS THEN
608: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
609: RAISE;
610:
611: END validate_budget;
612: