APPS.FND_EVENT dependencies on DUAL

Line 114: dual_no_rows exception;

110: severity IN VARCHAR2 default 'WARNING',
111: module IN VARCHAR2 default Null) return number is
112: empty_token token_tab_type;
113:
114: dual_no_rows exception;
115: dual_too_many_rows exception;
116: BEGIN
117:
118: reset_vars;

Line 115: dual_too_many_rows exception;

111: module IN VARCHAR2 default Null) return number is
112: empty_token token_tab_type;
113:
114: dual_no_rows exception;
115: dual_too_many_rows exception;
116: BEGIN
117:
118: reset_vars;
119:

Line 136: from sys.dual;

132: -- get next event_id from sequence
133: begin
134: select fnd_events_s.nextval
135: into g_event_id
136: from sys.dual;
137:
138: exception
139: when no_data_found then
140: raise dual_no_rows;

Line 140: raise dual_no_rows;

136: from sys.dual;
137:
138: exception
139: when no_data_found then
140: raise dual_no_rows;
141: when too_many_rows then
142: raise dual_too_many_rows;
143: when others then
144: raise;

Line 142: raise dual_too_many_rows;

138: exception
139: when no_data_found then
140: raise dual_no_rows;
141: when too_many_rows then
142: raise dual_too_many_rows;
143: when others then
144: raise;
145: end;
146:

Line 149: when dual_no_rows then

145: end;
146:
147: return g_event_id;
148: exception
149: when dual_no_rows then
150: fnd_message.set_name ('FND', 'No Rows in Dual');
151: return(0);
152: when dual_too_many_rows then
153: fnd_message.set_name ('FND', 'Too many rows in Dual');

Line 150: fnd_message.set_name ('FND', 'No Rows in Dual');

146:
147: return g_event_id;
148: exception
149: when dual_no_rows then
150: fnd_message.set_name ('FND', 'No Rows in Dual');
151: return(0);
152: when dual_too_many_rows then
153: fnd_message.set_name ('FND', 'Too many rows in Dual');
154: return(0);

Line 152: when dual_too_many_rows then

148: exception
149: when dual_no_rows then
150: fnd_message.set_name ('FND', 'No Rows in Dual');
151: return(0);
152: when dual_too_many_rows then
153: fnd_message.set_name ('FND', 'Too many rows in Dual');
154: return(0);
155: when others then
156: fnd_message.set_name ('FND', 'SQL-Generic error');

Line 153: fnd_message.set_name ('FND', 'Too many rows in Dual');

149: when dual_no_rows then
150: fnd_message.set_name ('FND', 'No Rows in Dual');
151: return(0);
152: when dual_too_many_rows then
153: fnd_message.set_name ('FND', 'Too many rows in Dual');
154: return(0);
155: when others then
156: fnd_message.set_name ('FND', 'SQL-Generic error');
157: fnd_message.set_token ('ERRNO', sqlcode, FALSE);

Line 230: dual_no_rows exception;

226:
227: has_tokens varchar2(1);
228:
229: message_not_set exception;
230: dual_no_rows exception;
231: dual_too_many_rows exception;
232: app_not_found exception;
233: source_id_null exception;
234: insert_error exception;

Line 231: dual_too_many_rows exception;

227: has_tokens varchar2(1);
228:
229: message_not_set exception;
230: dual_no_rows exception;
231: dual_too_many_rows exception;
232: app_not_found exception;
233: source_id_null exception;
234: insert_error exception;
235:

Line 271: from sys.dual;

267: end;
268:
269: select USERENV('SESSIONID')
270: into g_audsid
271: from sys.dual;
272:
273: select MACHINE
274: into g_node
275: from v$session

Line 452: from sys.dual;

448: -- if source_id is 0 or -1 then use the session id
449: if ( source_id <= 0 ) then
450: select USERENV('SESSIONID')
451: into l_source_id
452: from sys.dual;
453: l_source_type := 'O'; -- use source_type as Others
454: else
455: l_source_id := source_id;
456: l_source_type := source_type;