8: procedure generic_error(routine in varchar2,
9: errcode in number,
10: errmsg in varchar2) is
11: begin
12: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
13: fnd_message.set_token('ROUTINE', routine);
14: fnd_message.set_token('ERRNO', errcode);
15: fnd_message.set_token('REASON', dbms_utility.format_error_stack);
16: -- dbms_output.put_line(fnd_message.get);
9: errcode in number,
10: errmsg in varchar2) is
11: begin
12: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
13: fnd_message.set_token('ROUTINE', routine);
14: fnd_message.set_token('ERRNO', errcode);
15: fnd_message.set_token('REASON', dbms_utility.format_error_stack);
16: -- dbms_output.put_line(fnd_message.get);
17: fnd_message.raise_error;
10: errmsg in varchar2) is
11: begin
12: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
13: fnd_message.set_token('ROUTINE', routine);
14: fnd_message.set_token('ERRNO', errcode);
15: fnd_message.set_token('REASON', dbms_utility.format_error_stack);
16: -- dbms_output.put_line(fnd_message.get);
17: fnd_message.raise_error;
18: end;
11: begin
12: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
13: fnd_message.set_token('ROUTINE', routine);
14: fnd_message.set_token('ERRNO', errcode);
15: fnd_message.set_token('REASON', dbms_utility.format_error_stack);
16: -- dbms_output.put_line(fnd_message.get);
17: fnd_message.raise_error;
18: end;
19:
12: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
13: fnd_message.set_token('ROUTINE', routine);
14: fnd_message.set_token('ERRNO', errcode);
15: fnd_message.set_token('REASON', dbms_utility.format_error_stack);
16: -- dbms_output.put_line(fnd_message.get);
17: fnd_message.raise_error;
18: end;
19:
20: --
13: fnd_message.set_token('ROUTINE', routine);
14: fnd_message.set_token('ERRNO', errcode);
15: fnd_message.set_token('REASON', dbms_utility.format_error_stack);
16: -- dbms_output.put_line(fnd_message.get);
17: fnd_message.raise_error;
18: end;
19:
20: --
21: -- Public Functions and Procedures
147: fnd_client_info.set_security_group_context(to_char(security_group_id));
148:
149: exception
150: when no_morg_profile_value then
151: fnd_message.set_name('FND', 'FND-ORG_ID PROFILE CANNOT READ');
152: fnd_message.set_token('OPTION', l_morg_profile_name);
153: -- dbms_output.put_line(fnd_message.get);
154: fnd_message.raise_error;
155: -- generic_error('FND_CLIENT_INFO.SETUP_CLIENT_INFO', -20000,
148:
149: exception
150: when no_morg_profile_value then
151: fnd_message.set_name('FND', 'FND-ORG_ID PROFILE CANNOT READ');
152: fnd_message.set_token('OPTION', l_morg_profile_name);
153: -- dbms_output.put_line(fnd_message.get);
154: fnd_message.raise_error;
155: -- generic_error('FND_CLIENT_INFO.SETUP_CLIENT_INFO', -20000,
156: -- 'MultiOrg enabled but ORG_ID profile not defined');
149: exception
150: when no_morg_profile_value then
151: fnd_message.set_name('FND', 'FND-ORG_ID PROFILE CANNOT READ');
152: fnd_message.set_token('OPTION', l_morg_profile_name);
153: -- dbms_output.put_line(fnd_message.get);
154: fnd_message.raise_error;
155: -- generic_error('FND_CLIENT_INFO.SETUP_CLIENT_INFO', -20000,
156: -- 'MultiOrg enabled but ORG_ID profile not defined');
157: when no_mcur_profile_value then
150: when no_morg_profile_value then
151: fnd_message.set_name('FND', 'FND-ORG_ID PROFILE CANNOT READ');
152: fnd_message.set_token('OPTION', l_morg_profile_name);
153: -- dbms_output.put_line(fnd_message.get);
154: fnd_message.raise_error;
155: -- generic_error('FND_CLIENT_INFO.SETUP_CLIENT_INFO', -20000,
156: -- 'MultiOrg enabled but ORG_ID profile not defined');
157: when no_mcur_profile_value then
158: generic_error('FND_CLIENT_INFO.SETUP_CLIENT_INFO', -20000,
256: dbms_application_info.set_client_info(context_area);
257:
258: exception
259: when context_too_long then
260: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');
261: fnd_message.set_token('ROUTINE', 'SET_ORG_CONTEXT');
262: fnd_message.set_token('BAD_ARG', context);
263: -- dbms_output.put_line(fnd_message.get);
264: fnd_message.raise_error;
257:
258: exception
259: when context_too_long then
260: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');
261: fnd_message.set_token('ROUTINE', 'SET_ORG_CONTEXT');
262: fnd_message.set_token('BAD_ARG', context);
263: -- dbms_output.put_line(fnd_message.get);
264: fnd_message.raise_error;
265: when bad_characters then
258: exception
259: when context_too_long then
260: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');
261: fnd_message.set_token('ROUTINE', 'SET_ORG_CONTEXT');
262: fnd_message.set_token('BAD_ARG', context);
263: -- dbms_output.put_line(fnd_message.get);
264: fnd_message.raise_error;
265: when bad_characters then
266: generic_error('FND_CLIENT_INFO.SET_ORG_CONTEXT', -20000,
259: when context_too_long then
260: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');
261: fnd_message.set_token('ROUTINE', 'SET_ORG_CONTEXT');
262: fnd_message.set_token('BAD_ARG', context);
263: -- dbms_output.put_line(fnd_message.get);
264: fnd_message.raise_error;
265: when bad_characters then
266: generic_error('FND_CLIENT_INFO.SET_ORG_CONTEXT', -20000,
267: 'Only single-byte characters are valid input');
260: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');
261: fnd_message.set_token('ROUTINE', 'SET_ORG_CONTEXT');
262: fnd_message.set_token('BAD_ARG', context);
263: -- dbms_output.put_line(fnd_message.get);
264: fnd_message.raise_error;
265: when bad_characters then
266: generic_error('FND_CLIENT_INFO.SET_ORG_CONTEXT', -20000,
267: 'Only single-byte characters are valid input');
268: when others then
336: dbms_application_info.set_client_info(context_area);
337:
338: exception
339: when context_too_long then
340: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');
341: fnd_message.set_token('ROUTINE', 'SET_CURRENCY_CONTEXT');
342: fnd_message.set_token('BAD_ARG', context);
343: -- dbms_output.put_line(fnd_message.get);
344: fnd_message.raise_error;
337:
338: exception
339: when context_too_long then
340: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');
341: fnd_message.set_token('ROUTINE', 'SET_CURRENCY_CONTEXT');
342: fnd_message.set_token('BAD_ARG', context);
343: -- dbms_output.put_line(fnd_message.get);
344: fnd_message.raise_error;
345: when bad_characters then
338: exception
339: when context_too_long then
340: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');
341: fnd_message.set_token('ROUTINE', 'SET_CURRENCY_CONTEXT');
342: fnd_message.set_token('BAD_ARG', context);
343: -- dbms_output.put_line(fnd_message.get);
344: fnd_message.raise_error;
345: when bad_characters then
346: generic_error('FND_CLIENT_INFO.SET_CURRENCY_CONTEXT', -20000,
339: when context_too_long then
340: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');
341: fnd_message.set_token('ROUTINE', 'SET_CURRENCY_CONTEXT');
342: fnd_message.set_token('BAD_ARG', context);
343: -- dbms_output.put_line(fnd_message.get);
344: fnd_message.raise_error;
345: when bad_characters then
346: generic_error('FND_CLIENT_INFO.SET_CURRENCY_CONTEXT', -20000,
347: 'Only single-byte characters are valid input');
340: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');
341: fnd_message.set_token('ROUTINE', 'SET_CURRENCY_CONTEXT');
342: fnd_message.set_token('BAD_ARG', context);
343: -- dbms_output.put_line(fnd_message.get);
344: fnd_message.raise_error;
345: when bad_characters then
346: generic_error('FND_CLIENT_INFO.SET_CURRENCY_CONTEXT', -20000,
347: 'Only single-byte characters are valid input');
348: when others then
414: dbms_application_info.set_client_info(context_area);
415:
416: exception
417: when context_too_long then
418: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');
419: fnd_message.set_token('ROUTINE', 'SET_SECURITY_GROUP_CONTEXT');
420: fnd_message.set_token('BAD_ARG', context);
421: -- dbms_output.put_line(fnd_message.get);
422: fnd_message.raise_error;
415:
416: exception
417: when context_too_long then
418: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');
419: fnd_message.set_token('ROUTINE', 'SET_SECURITY_GROUP_CONTEXT');
420: fnd_message.set_token('BAD_ARG', context);
421: -- dbms_output.put_line(fnd_message.get);
422: fnd_message.raise_error;
423: when bad_characters then
416: exception
417: when context_too_long then
418: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');
419: fnd_message.set_token('ROUTINE', 'SET_SECURITY_GROUP_CONTEXT');
420: fnd_message.set_token('BAD_ARG', context);
421: -- dbms_output.put_line(fnd_message.get);
422: fnd_message.raise_error;
423: when bad_characters then
424: generic_error('FND_CLIENT_INFO.SET_SECURITY_GROUP_CONTEXT', -20000,
417: when context_too_long then
418: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');
419: fnd_message.set_token('ROUTINE', 'SET_SECURITY_GROUP_CONTEXT');
420: fnd_message.set_token('BAD_ARG', context);
421: -- dbms_output.put_line(fnd_message.get);
422: fnd_message.raise_error;
423: when bad_characters then
424: generic_error('FND_CLIENT_INFO.SET_SECURITY_GROUP_CONTEXT', -20000,
425: 'Only single-byte characters are valid input');
418: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');
419: fnd_message.set_token('ROUTINE', 'SET_SECURITY_GROUP_CONTEXT');
420: fnd_message.set_token('BAD_ARG', context);
421: -- dbms_output.put_line(fnd_message.get);
422: fnd_message.raise_error;
423: when bad_characters then
424: generic_error('FND_CLIENT_INFO.SET_SECURITY_GROUP_CONTEXT', -20000,
425: 'Only single-byte characters are valid input');
426: when others then
476: -- compilation.
477:
478: EXCEPTION
479: WHEN OTHERS THEN
480: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
481: fnd_message.set_token('ERRNO', to_char(sqlcode));
482: fnd_message.set_token('REASON', dbms_utility.format_error_stack);
483: fnd_message.set_token('ROUTINE', 'ORG_SECURITY');
484: app_exception.raise_exception;
477:
478: EXCEPTION
479: WHEN OTHERS THEN
480: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
481: fnd_message.set_token('ERRNO', to_char(sqlcode));
482: fnd_message.set_token('REASON', dbms_utility.format_error_stack);
483: fnd_message.set_token('ROUTINE', 'ORG_SECURITY');
484: app_exception.raise_exception;
485: END org_security;
478: EXCEPTION
479: WHEN OTHERS THEN
480: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
481: fnd_message.set_token('ERRNO', to_char(sqlcode));
482: fnd_message.set_token('REASON', dbms_utility.format_error_stack);
483: fnd_message.set_token('ROUTINE', 'ORG_SECURITY');
484: app_exception.raise_exception;
485: END org_security;
486:
479: WHEN OTHERS THEN
480: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
481: fnd_message.set_token('ERRNO', to_char(sqlcode));
482: fnd_message.set_token('REASON', dbms_utility.format_error_stack);
483: fnd_message.set_token('ROUTINE', 'ORG_SECURITY');
484: app_exception.raise_exception;
485: END org_security;
486:
487: end fnd_client_info;