684:
685: begin
686: select dgu.data_group_id, dgu.application_id
687: into dataGroup_Id, dataGroupApp_id
688: from fnd_data_group_units dgu, fnd_data_groups dg, fnd_application a
689: where dgu.data_group_id = dg.data_group_id
690: and dg.data_group_name = X_DATA_GROUP_NAME
691: and dgu.application_id = a.application_id
692: and a.application_short_name = X_DATA_GROUP_APP_SHORT_NAME;
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||')');