DBA Data[Home] [Help]

APPS.FND_SIGNON dependencies on FND_MESSAGE

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

10: procedure GENERIC_ERROR(routine in varchar2,
11: errcode in number,
12: errmsg in varchar2) is
13: begin
14: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
15: fnd_message.set_token('ROUTINE', routine);
16: fnd_message.set_token('ERRNO', errcode);
17: fnd_message.set_token('REASON', errmsg);
18: app_exception.raise_exception;

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

11: errcode in number,
12: errmsg in varchar2) is
13: begin
14: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
15: fnd_message.set_token('ROUTINE', routine);
16: fnd_message.set_token('ERRNO', errcode);
17: fnd_message.set_token('REASON', errmsg);
18: app_exception.raise_exception;
19: end;

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

12: errmsg in varchar2) is
13: begin
14: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
15: fnd_message.set_token('ROUTINE', routine);
16: fnd_message.set_token('ERRNO', errcode);
17: fnd_message.set_token('REASON', errmsg);
18: app_exception.raise_exception;
19: end;
20:

Line 17: fnd_message.set_token('REASON', errmsg);

13: begin
14: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
15: fnd_message.set_token('ROUTINE', routine);
16: fnd_message.set_token('ERRNO', errcode);
17: fnd_message.set_token('REASON', errmsg);
18: app_exception.raise_exception;
19: end;
20:
21: --

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

1008:
1009: EXCEPTION when NO_DATA_FOUND then
1010:
1011: -- raise no data found error.
1012: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1013: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');
1014: fnd_message.set_token('ERRNO',1403 );
1015: fnd_message.set_token('REASON','Invalid User ID provided');
1016: app_exception.raise_exception;

Line 1013: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');

1009: EXCEPTION when NO_DATA_FOUND then
1010:
1011: -- raise no data found error.
1012: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1013: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');
1014: fnd_message.set_token('ERRNO',1403 );
1015: fnd_message.set_token('REASON','Invalid User ID provided');
1016: app_exception.raise_exception;
1017:

Line 1014: fnd_message.set_token('ERRNO',1403 );

1010:
1011: -- raise no data found error.
1012: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1013: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');
1014: fnd_message.set_token('ERRNO',1403 );
1015: fnd_message.set_token('REASON','Invalid User ID provided');
1016: app_exception.raise_exception;
1017:
1018: when OTHERS then

Line 1015: fnd_message.set_token('REASON','Invalid User ID provided');

1011: -- raise no data found error.
1012: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1013: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');
1014: fnd_message.set_token('ERRNO',1403 );
1015: fnd_message.set_token('REASON','Invalid User ID provided');
1016: app_exception.raise_exception;
1017:
1018: when OTHERS then
1019:

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

1017:
1018: when OTHERS then
1019:
1020: --raise generic error.
1021: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1022: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');
1023: fnd_message.set_token('ERRNO',SUBSTR(sqlerrm,5,5));
1024: fnd_message.set_token('REASON', sqlerrm);
1025: app_exception.raise_exception;

Line 1022: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');

1018: when OTHERS then
1019:
1020: --raise generic error.
1021: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1022: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');
1023: fnd_message.set_token('ERRNO',SUBSTR(sqlerrm,5,5));
1024: fnd_message.set_token('REASON', sqlerrm);
1025: app_exception.raise_exception;
1026:

Line 1023: fnd_message.set_token('ERRNO',SUBSTR(sqlerrm,5,5));

1019:
1020: --raise generic error.
1021: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1022: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');
1023: fnd_message.set_token('ERRNO',SUBSTR(sqlerrm,5,5));
1024: fnd_message.set_token('REASON', sqlerrm);
1025: app_exception.raise_exception;
1026:
1027:

Line 1024: fnd_message.set_token('REASON', sqlerrm);

1020: --raise generic error.
1021: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1022: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');
1023: fnd_message.set_token('ERRNO',SUBSTR(sqlerrm,5,5));
1024: fnd_message.set_token('REASON', sqlerrm);
1025: app_exception.raise_exception;
1026:
1027:
1028: END get_invalid_logins;