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