eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMO_OPER_CERT_TRANS_DBL dependencies on FND_API

Line 90: x_return_status := fnd_api.g_ret_sts_success;

86:
87:
88: BEGIN
89: -- Initially let us assign the return status to success
90: x_return_status := fnd_api.g_ret_sts_success;
91:
92:
93:
94:

Line 140: x_return_status := fnd_api.g_ret_sts_error;

136: RETURNING operator_CERTIFICATE_ID
137: INTO p_operator_CERTIFICATE_ID ;
138:
139: IF SQL%NOTFOUND THEN
140: x_return_status := fnd_api.g_ret_sts_error;
141: END IF;
142:
143: EXCEPTION
144: WHEN FND_API.g_exc_error THEN

Line 144: WHEN FND_API.g_exc_error THEN

140: x_return_status := fnd_api.g_ret_sts_error;
141: END IF;
142:
143: EXCEPTION
144: WHEN FND_API.g_exc_error THEN
145: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
146: x_return_status := fnd_api.g_ret_sts_error;
147: WHEN OTHERS THEN
148: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 146: x_return_status := fnd_api.g_ret_sts_error;

142:
143: EXCEPTION
144: WHEN FND_API.g_exc_error THEN
145: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
146: x_return_status := fnd_api.g_ret_sts_error;
147: WHEN OTHERS THEN
148: x_return_status := fnd_api.g_ret_sts_unexp_error;
149: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
150:

Line 148: x_return_status := fnd_api.g_ret_sts_unexp_error;

144: WHEN FND_API.g_exc_error THEN
145: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
146: x_return_status := fnd_api.g_ret_sts_error;
147: WHEN OTHERS THEN
148: x_return_status := fnd_api.g_ret_sts_unexp_error;
149: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
150:
151: END insert_row;
152:

Line 194: x_return_status := fnd_api.g_ret_sts_success;

190: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);
191:
192: BEGIN
193: -- Initially let us assign the return status to success
194: x_return_status := fnd_api.g_ret_sts_success;
195: IF p_oper_cert_ID IS NOT NULL THEN
196: SELECT 1
197: INTO l_dummy
198: FROM gmo_operator_cert_trans

Line 213: x_return_status := fnd_api.g_ret_sts_error;

209: END IF;
210: EXCEPTION
211: WHEN NO_DATA_FOUND THEN
212:
213: x_return_status := fnd_api.g_ret_sts_error;
214:
215: WHEN OTHERS THEN
216: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
217: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 217: x_return_status := fnd_api.g_ret_sts_unexp_error;

213: x_return_status := fnd_api.g_ret_sts_error;
214:
215: WHEN OTHERS THEN
216: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
217: x_return_status := fnd_api.g_ret_sts_unexp_error;
218: END delete_row;
219:
220: /* Api start of comments
221: +============================================================================

Line 277: x_return_status := fnd_api.g_ret_sts_success;

273: locked_by_other_user EXCEPTION;
274: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);
275:
276: BEGIN
277: x_return_status := fnd_api.g_ret_sts_success;
278:
279: IF p_operator_CERTIFICATE_ID IS NOT NULL THEN
280: SELECT 1
281: INTO l_dummy

Line 310: x_return_status := fnd_api.g_ret_sts_error;

306: RAISE NO_DATA_FOUND;
307: END IF;
308: EXCEPTION
309: WHEN NO_DATA_FOUND THEN
310: x_return_status := fnd_api.g_ret_sts_error;
311:
312: WHEN OTHERS THEN
313: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
314: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 314: x_return_status := fnd_api.g_ret_sts_unexp_error;

310: x_return_status := fnd_api.g_ret_sts_error;
311:
312: WHEN OTHERS THEN
313: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
314: x_return_status := fnd_api.g_ret_sts_unexp_error;
315:
316: END update_row;
317:
318: /* Api start of comments

Line 364: x_return_status := fnd_api.g_ret_sts_error;

360:
361:
362: EXCEPTION
363: WHEN NO_DATA_FOUND THEN
364: x_return_status := fnd_api.g_ret_sts_error;
365: WHEN app_exception.record_lock_exception THEN
366: x_return_status := fnd_api.g_ret_sts_error;
367:
368: WHEN OTHERS THEN

Line 366: x_return_status := fnd_api.g_ret_sts_error;

362: EXCEPTION
363: WHEN NO_DATA_FOUND THEN
364: x_return_status := fnd_api.g_ret_sts_error;
365: WHEN app_exception.record_lock_exception THEN
366: x_return_status := fnd_api.g_ret_sts_error;
367:
368: WHEN OTHERS THEN
369: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
370: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 370: x_return_status := fnd_api.g_ret_sts_unexp_error;

366: x_return_status := fnd_api.g_ret_sts_error;
367:
368: WHEN OTHERS THEN
369: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
370: x_return_status := fnd_api.g_ret_sts_unexp_error;
371: END lock_row;
372: END gmo_oper_cert_trans_dbl;