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: --
984:
985: EXCEPTION when NO_DATA_FOUND then
986:
987: -- raise no data found error.
988: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
989: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');
990: fnd_message.set_token('ERRNO',1403 );
991: fnd_message.set_token('REASON','Invalid User ID provided');
992: app_exception.raise_exception;
985: EXCEPTION when NO_DATA_FOUND then
986:
987: -- raise no data found error.
988: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
989: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');
990: fnd_message.set_token('ERRNO',1403 );
991: fnd_message.set_token('REASON','Invalid User ID provided');
992: app_exception.raise_exception;
993:
986:
987: -- raise no data found error.
988: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
989: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');
990: fnd_message.set_token('ERRNO',1403 );
991: fnd_message.set_token('REASON','Invalid User ID provided');
992: app_exception.raise_exception;
993:
994: when OTHERS then
987: -- raise no data found error.
988: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
989: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');
990: fnd_message.set_token('ERRNO',1403 );
991: fnd_message.set_token('REASON','Invalid User ID provided');
992: app_exception.raise_exception;
993:
994: when OTHERS then
995:
993:
994: when OTHERS then
995:
996: --raise generic error.
997: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
998: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');
999: fnd_message.set_token('ERRNO',SUBSTR(sqlerrm,5,5));
1000: fnd_message.set_token('REASON', sqlerrm);
1001: app_exception.raise_exception;
994: when OTHERS then
995:
996: --raise generic error.
997: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
998: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');
999: fnd_message.set_token('ERRNO',SUBSTR(sqlerrm,5,5));
1000: fnd_message.set_token('REASON', sqlerrm);
1001: app_exception.raise_exception;
1002:
995:
996: --raise generic error.
997: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
998: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');
999: fnd_message.set_token('ERRNO',SUBSTR(sqlerrm,5,5));
1000: fnd_message.set_token('REASON', sqlerrm);
1001: app_exception.raise_exception;
1002:
1003:
996: --raise generic error.
997: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
998: fnd_message.set_token('ROUTINE','FND_AOLJ_UTIL.get_invalid_logins()');
999: fnd_message.set_token('ERRNO',SUBSTR(sqlerrm,5,5));
1000: fnd_message.set_token('REASON', sqlerrm);
1001: app_exception.raise_exception;
1002:
1003:
1004: END get_invalid_logins;