DBA Data[Home] [Help]

APPS.FND_CLIENT_INFO dependencies on FND_MESSAGE

Line 12: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

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);

Line 13: fnd_message.set_token('ROUTINE', routine);

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;

Line 14: fnd_message.set_token('ERRNO', errcode);

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;

Line 15: fnd_message.set_token('REASON', dbms_utility.format_error_stack);

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:

Line 16: -- dbms_output.put_line(fnd_message.get);

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: --

Line 17: fnd_message.raise_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: --
21: -- Public Functions and Procedures

Line 151: fnd_message.set_name('FND', 'FND-ORG_ID PROFILE CANNOT READ');

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,

Line 152: fnd_message.set_token('OPTION', l_morg_profile_name);

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');

Line 153: -- dbms_output.put_line(fnd_message.get);

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

Line 154: fnd_message.raise_error;

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,

Line 260: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');

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;

Line 261: fnd_message.set_token('ROUTINE', 'SET_ORG_CONTEXT');

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

Line 262: fnd_message.set_token('BAD_ARG', context);

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,

Line 263: -- dbms_output.put_line(fnd_message.get);

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');

Line 264: fnd_message.raise_error;

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

Line 340: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');

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;

Line 341: fnd_message.set_token('ROUTINE', 'SET_CURRENCY_CONTEXT');

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

Line 342: fnd_message.set_token('BAD_ARG', context);

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,

Line 343: -- dbms_output.put_line(fnd_message.get);

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');

Line 344: fnd_message.raise_error;

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

Line 418: fnd_message.set_name('FND', 'CLIENT_INFO_ARG_TOO_LONG');

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;

Line 419: fnd_message.set_token('ROUTINE', 'SET_SECURITY_GROUP_CONTEXT');

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

Line 420: fnd_message.set_token('BAD_ARG', context);

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,

Line 421: -- dbms_output.put_line(fnd_message.get);

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');

Line 422: fnd_message.raise_error;

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

Line 480: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

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;

Line 481: fnd_message.set_token('ERRNO', to_char(sqlcode));

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;

Line 482: fnd_message.set_token('REASON', dbms_utility.format_error_stack);

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:

Line 483: fnd_message.set_token('ROUTINE', 'ORG_SECURITY');

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;