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 988: fnd_message.set_name('FND','SQL_PLSQL_ERROR');

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;

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

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:

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

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

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

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:

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

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;

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

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:

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

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:

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

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;