DBA Data[Home] [Help]

APPS.FND_RESPONSIBILITY_PKG dependencies on FND_MESSAGE

Line 362: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

358: open c;
359: fetch c into recinfo;
360: if (c%notfound) then
361: close c;
362: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
363: app_exception.raise_exception;
364: end if;
365: close c;
366: if ( ((recinfo.WEB_HOST_NAME = X_WEB_HOST_NAME)

Line 386: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

382: AND (recinfo.RESPONSIBILITY_KEY = X_RESPONSIBILITY_KEY)
383: ) then
384: null;
385: else
386: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
387: app_exception.raise_exception;
388: end if;
389:
390: open c1;

Line 404: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

400: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
401: ) then
402: null;
403: else
404: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
405: app_exception.raise_exception;
406: end if;
407: return;
408: end LOCK_ROW;

Line 678: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

674: from fnd_application
675: where application_short_name = X_APP_SHORT_NAME;
676: exception
677: when no_data_found then
678: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
679: fnd_message.set_token('TABLE', 'FND_APPLICATION');
680: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
681: fnd_message.set_token('VALUE', x_app_short_name);
682: app_exception.raise_exception;

Line 679: fnd_message.set_token('TABLE', 'FND_APPLICATION');

675: where application_short_name = X_APP_SHORT_NAME;
676: exception
677: when no_data_found then
678: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
679: fnd_message.set_token('TABLE', 'FND_APPLICATION');
680: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
681: fnd_message.set_token('VALUE', x_app_short_name);
682: app_exception.raise_exception;
683: end;

Line 680: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');

676: exception
677: when no_data_found then
678: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
679: fnd_message.set_token('TABLE', 'FND_APPLICATION');
680: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
681: fnd_message.set_token('VALUE', x_app_short_name);
682: app_exception.raise_exception;
683: end;
684:

Line 681: fnd_message.set_token('VALUE', x_app_short_name);

677: when no_data_found then
678: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
679: fnd_message.set_token('TABLE', 'FND_APPLICATION');
680: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
681: fnd_message.set_token('VALUE', x_app_short_name);
682: app_exception.raise_exception;
683: end;
684:
685: begin

Line 695: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

691: and dgu.application_id = a.application_id
692: and a.application_short_name = X_DATA_GROUP_APP_SHORT_NAME;
693: exception
694: when no_data_found then
695: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
696: fnd_message.set_token('TABLE', 'FND_DATA_GROUP_UNITS');
697: fnd_message.set_token('COLUMN',
698: '(DATA_GROUP_NAME, DATA_GROUP_APP_SHORT_NAME)');
699: fnd_message.set_token('VALUE', '('||X_DATA_GROUP_NAME||', '||

Line 696: fnd_message.set_token('TABLE', 'FND_DATA_GROUP_UNITS');

692: and a.application_short_name = X_DATA_GROUP_APP_SHORT_NAME;
693: exception
694: when no_data_found then
695: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
696: fnd_message.set_token('TABLE', 'FND_DATA_GROUP_UNITS');
697: fnd_message.set_token('COLUMN',
698: '(DATA_GROUP_NAME, DATA_GROUP_APP_SHORT_NAME)');
699: fnd_message.set_token('VALUE', '('||X_DATA_GROUP_NAME||', '||
700: X_DATA_GROUP_APP_SHORT_NAME||')');

Line 697: fnd_message.set_token('COLUMN',

693: exception
694: when no_data_found then
695: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
696: fnd_message.set_token('TABLE', 'FND_DATA_GROUP_UNITS');
697: fnd_message.set_token('COLUMN',
698: '(DATA_GROUP_NAME, DATA_GROUP_APP_SHORT_NAME)');
699: fnd_message.set_token('VALUE', '('||X_DATA_GROUP_NAME||', '||
700: X_DATA_GROUP_APP_SHORT_NAME||')');
701: fnd_message.set_token('NOTE',

Line 699: fnd_message.set_token('VALUE', '('||X_DATA_GROUP_NAME||', '||

695: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
696: fnd_message.set_token('TABLE', 'FND_DATA_GROUP_UNITS');
697: fnd_message.set_token('COLUMN',
698: '(DATA_GROUP_NAME, DATA_GROUP_APP_SHORT_NAME)');
699: fnd_message.set_token('VALUE', '('||X_DATA_GROUP_NAME||', '||
700: X_DATA_GROUP_APP_SHORT_NAME||')');
701: fnd_message.set_token('NOTE',
702: 'This warning can be ignored while MRC '||
703: '(Multiple Reporting Currency) responsibilities '||

Line 701: fnd_message.set_token('NOTE',

697: fnd_message.set_token('COLUMN',
698: '(DATA_GROUP_NAME, DATA_GROUP_APP_SHORT_NAME)');
699: fnd_message.set_token('VALUE', '('||X_DATA_GROUP_NAME||', '||
700: X_DATA_GROUP_APP_SHORT_NAME||')');
701: fnd_message.set_token('NOTE',
702: 'This warning can be ignored while MRC '||
703: '(Multiple Reporting Currency) responsibilities '||
704: 'are being uploaded. It simply means that the MRC '||
705: 'responsibility is not being uploaded because it '||

Line 720: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

716: from fnd_menus_vl
717: where menu_name = X_MENU_NAME;
718: exception
719: when no_data_found then
720: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
721: fnd_message.set_token('TABLE', 'FND_MENUS_VL');
722: fnd_message.set_token('COLUMN', 'MENU_NAME');
723: fnd_message.set_token('VALUE', x_menu_name);
724: app_exception.raise_exception;

Line 721: fnd_message.set_token('TABLE', 'FND_MENUS_VL');

717: where menu_name = X_MENU_NAME;
718: exception
719: when no_data_found then
720: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
721: fnd_message.set_token('TABLE', 'FND_MENUS_VL');
722: fnd_message.set_token('COLUMN', 'MENU_NAME');
723: fnd_message.set_token('VALUE', x_menu_name);
724: app_exception.raise_exception;
725: end;

Line 722: fnd_message.set_token('COLUMN', 'MENU_NAME');

718: exception
719: when no_data_found then
720: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
721: fnd_message.set_token('TABLE', 'FND_MENUS_VL');
722: fnd_message.set_token('COLUMN', 'MENU_NAME');
723: fnd_message.set_token('VALUE', x_menu_name);
724: app_exception.raise_exception;
725: end;
726:

Line 723: fnd_message.set_token('VALUE', x_menu_name);

719: when no_data_found then
720: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
721: fnd_message.set_token('TABLE', 'FND_MENUS_VL');
722: fnd_message.set_token('COLUMN', 'MENU_NAME');
723: fnd_message.set_token('VALUE', x_menu_name);
724: app_exception.raise_exception;
725: end;
726:
727: if ((X_GROUP_APP_SHORT_NAME is not null) or

Line 737: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

733: where application_short_name = X_GROUP_APP_SHORT_NAME;
734:
735: exception
736: when no_data_found then
737: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
738: fnd_message.set_token('TABLE', 'FND_APPLICATION');
739: fnd_message.set_token('COLUMN', 'GROUP_APP_SHORT_NAME');
740: fnd_message.set_token('VALUE', X_GROUP_APP_SHORT_NAME);
741: app_exception.raise_exception;

Line 738: fnd_message.set_token('TABLE', 'FND_APPLICATION');

734:
735: exception
736: when no_data_found then
737: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
738: fnd_message.set_token('TABLE', 'FND_APPLICATION');
739: fnd_message.set_token('COLUMN', 'GROUP_APP_SHORT_NAME');
740: fnd_message.set_token('VALUE', X_GROUP_APP_SHORT_NAME);
741: app_exception.raise_exception;
742: end;

Line 739: fnd_message.set_token('COLUMN', 'GROUP_APP_SHORT_NAME');

735: exception
736: when no_data_found then
737: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
738: fnd_message.set_token('TABLE', 'FND_APPLICATION');
739: fnd_message.set_token('COLUMN', 'GROUP_APP_SHORT_NAME');
740: fnd_message.set_token('VALUE', X_GROUP_APP_SHORT_NAME);
741: app_exception.raise_exception;
742: end;
743:

Line 740: fnd_message.set_token('VALUE', X_GROUP_APP_SHORT_NAME);

736: when no_data_found then
737: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
738: fnd_message.set_token('TABLE', 'FND_APPLICATION');
739: fnd_message.set_token('COLUMN', 'GROUP_APP_SHORT_NAME');
740: fnd_message.set_token('VALUE', X_GROUP_APP_SHORT_NAME);
741: app_exception.raise_exception;
742: end;
743:
744: begin