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 683: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

679: from fnd_application
680: where application_short_name = X_APP_SHORT_NAME;
681: exception
682: when no_data_found then
683: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
684: fnd_message.set_token('TABLE', 'FND_APPLICATION');
685: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
686: fnd_message.set_token('VALUE', x_app_short_name);
687: app_exception.raise_exception;

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

680: where application_short_name = X_APP_SHORT_NAME;
681: exception
682: when no_data_found then
683: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
684: fnd_message.set_token('TABLE', 'FND_APPLICATION');
685: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
686: fnd_message.set_token('VALUE', x_app_short_name);
687: app_exception.raise_exception;
688: end;

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

681: exception
682: when no_data_found then
683: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
684: fnd_message.set_token('TABLE', 'FND_APPLICATION');
685: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
686: fnd_message.set_token('VALUE', x_app_short_name);
687: app_exception.raise_exception;
688: end;
689:

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

682: when no_data_found then
683: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
684: fnd_message.set_token('TABLE', 'FND_APPLICATION');
685: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
686: fnd_message.set_token('VALUE', x_app_short_name);
687: app_exception.raise_exception;
688: end;
689:
690: begin

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

696: and dgu.application_id = a.application_id
697: and a.application_short_name = X_DATA_GROUP_APP_SHORT_NAME;
698: exception
699: when no_data_found then
700: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
701: fnd_message.set_token('TABLE', 'FND_DATA_GROUP_UNITS');
702: fnd_message.set_token('COLUMN',
703: '(DATA_GROUP_NAME, DATA_GROUP_APP_SHORT_NAME)');
704: fnd_message.set_token('VALUE', '('||X_DATA_GROUP_NAME||', '||

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

697: and a.application_short_name = X_DATA_GROUP_APP_SHORT_NAME;
698: exception
699: when no_data_found then
700: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
701: fnd_message.set_token('TABLE', 'FND_DATA_GROUP_UNITS');
702: fnd_message.set_token('COLUMN',
703: '(DATA_GROUP_NAME, DATA_GROUP_APP_SHORT_NAME)');
704: fnd_message.set_token('VALUE', '('||X_DATA_GROUP_NAME||', '||
705: X_DATA_GROUP_APP_SHORT_NAME||')');

Line 702: fnd_message.set_token('COLUMN',

698: exception
699: when no_data_found then
700: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
701: fnd_message.set_token('TABLE', 'FND_DATA_GROUP_UNITS');
702: fnd_message.set_token('COLUMN',
703: '(DATA_GROUP_NAME, DATA_GROUP_APP_SHORT_NAME)');
704: fnd_message.set_token('VALUE', '('||X_DATA_GROUP_NAME||', '||
705: X_DATA_GROUP_APP_SHORT_NAME||')');
706: fnd_message.set_token('NOTE',

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

700: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
701: fnd_message.set_token('TABLE', 'FND_DATA_GROUP_UNITS');
702: fnd_message.set_token('COLUMN',
703: '(DATA_GROUP_NAME, DATA_GROUP_APP_SHORT_NAME)');
704: fnd_message.set_token('VALUE', '('||X_DATA_GROUP_NAME||', '||
705: X_DATA_GROUP_APP_SHORT_NAME||')');
706: fnd_message.set_token('NOTE',
707: 'This warning can be ignored while MRC '||
708: '(Multiple Reporting Currency) responsibilities '||

Line 706: fnd_message.set_token('NOTE',

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

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

721: from fnd_menus_vl
722: where menu_name = X_MENU_NAME;
723: exception
724: when no_data_found then
725: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
726: fnd_message.set_token('TABLE', 'FND_MENUS_VL');
727: fnd_message.set_token('COLUMN', 'MENU_NAME');
728: fnd_message.set_token('VALUE', x_menu_name);
729: app_exception.raise_exception;

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

722: where menu_name = X_MENU_NAME;
723: exception
724: when no_data_found then
725: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
726: fnd_message.set_token('TABLE', 'FND_MENUS_VL');
727: fnd_message.set_token('COLUMN', 'MENU_NAME');
728: fnd_message.set_token('VALUE', x_menu_name);
729: app_exception.raise_exception;
730: end;

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

723: exception
724: when no_data_found then
725: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
726: fnd_message.set_token('TABLE', 'FND_MENUS_VL');
727: fnd_message.set_token('COLUMN', 'MENU_NAME');
728: fnd_message.set_token('VALUE', x_menu_name);
729: app_exception.raise_exception;
730: end;
731:

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

724: when no_data_found then
725: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
726: fnd_message.set_token('TABLE', 'FND_MENUS_VL');
727: fnd_message.set_token('COLUMN', 'MENU_NAME');
728: fnd_message.set_token('VALUE', x_menu_name);
729: app_exception.raise_exception;
730: end;
731:
732: if ((X_GROUP_APP_SHORT_NAME is not null) or

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

738: where application_short_name = X_GROUP_APP_SHORT_NAME;
739:
740: exception
741: when no_data_found then
742: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
743: fnd_message.set_token('TABLE', 'FND_APPLICATION');
744: fnd_message.set_token('COLUMN', 'GROUP_APP_SHORT_NAME');
745: fnd_message.set_token('VALUE', X_GROUP_APP_SHORT_NAME);
746: app_exception.raise_exception;

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

739:
740: exception
741: when no_data_found then
742: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
743: fnd_message.set_token('TABLE', 'FND_APPLICATION');
744: fnd_message.set_token('COLUMN', 'GROUP_APP_SHORT_NAME');
745: fnd_message.set_token('VALUE', X_GROUP_APP_SHORT_NAME);
746: app_exception.raise_exception;
747: end;

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

740: exception
741: when no_data_found then
742: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
743: fnd_message.set_token('TABLE', 'FND_APPLICATION');
744: fnd_message.set_token('COLUMN', 'GROUP_APP_SHORT_NAME');
745: fnd_message.set_token('VALUE', X_GROUP_APP_SHORT_NAME);
746: app_exception.raise_exception;
747: end;
748:

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

741: when no_data_found then
742: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
743: fnd_message.set_token('TABLE', 'FND_APPLICATION');
744: fnd_message.set_token('COLUMN', 'GROUP_APP_SHORT_NAME');
745: fnd_message.set_token('VALUE', X_GROUP_APP_SHORT_NAME);
746: app_exception.raise_exception;
747: end;
748:
749: begin