31: where APPLICATION_SHORT_NAME = upper(p_appl_short_name);
32:
33: exception
34: when others then
35: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
36: fnd_message.set_token('ROUTINE', 'REMOVE_APPLICATION');
37: fnd_message.set_token('ERRNO', to_char(sqlcode));
38: fnd_message.set_token('REASON', sqlerrm);
39: app_exception.raise_exception;
32:
33: exception
34: when others then
35: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
36: fnd_message.set_token('ROUTINE', 'REMOVE_APPLICATION');
37: fnd_message.set_token('ERRNO', to_char(sqlcode));
38: fnd_message.set_token('REASON', sqlerrm);
39: app_exception.raise_exception;
40: end;
33: exception
34: when others then
35: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
36: fnd_message.set_token('ROUTINE', 'REMOVE_APPLICATION');
37: fnd_message.set_token('ERRNO', to_char(sqlcode));
38: fnd_message.set_token('REASON', sqlerrm);
39: app_exception.raise_exception;
40: end;
41:
34: when others then
35: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
36: fnd_message.set_token('ROUTINE', 'REMOVE_APPLICATION');
37: fnd_message.set_token('ERRNO', to_char(sqlcode));
38: fnd_message.set_token('REASON', sqlerrm);
39: app_exception.raise_exception;
40: end;
41:
42: end remove_application;
118: 0,
119: nvl(upper(p_status),'N'));
120:
121: when others then
122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
123: fnd_message.set_token('ROUTINE', 'REGISTER_APPLICATION');
124: fnd_message.set_token('ERRNO', to_char(sqlcode));
125: fnd_message.set_token('REASON', sqlerrm);
126: app_exception.raise_exception;
119: nvl(upper(p_status),'N'));
120:
121: when others then
122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
123: fnd_message.set_token('ROUTINE', 'REGISTER_APPLICATION');
124: fnd_message.set_token('ERRNO', to_char(sqlcode));
125: fnd_message.set_token('REASON', sqlerrm);
126: app_exception.raise_exception;
127: end;
120:
121: when others then
122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
123: fnd_message.set_token('ROUTINE', 'REGISTER_APPLICATION');
124: fnd_message.set_token('ERRNO', to_char(sqlcode));
125: fnd_message.set_token('REASON', sqlerrm);
126: app_exception.raise_exception;
127: end;
128:
121: when others then
122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
123: fnd_message.set_token('ROUTINE', 'REGISTER_APPLICATION');
124: fnd_message.set_token('ERRNO', to_char(sqlcode));
125: fnd_message.set_token('REASON', sqlerrm);
126: app_exception.raise_exception;
127: end;
128:
129: end register_application;