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.IEB_SYNC_SERVER dependencies on FND_API

Line 51: x_return_status := fnd_api.g_ret_sts_success;

47: v_param4 VARCHAR2(32);
48: v_checkNew VARCHAR2(1);
49:
50: BEGIN
51: x_return_status := fnd_api.g_ret_sts_success;
52:
53: IEB_SYNC_SERVER.SYNC_SERVER(p_language, x_return_status);
54:
55:

Line 120: WHEN fnd_api.g_exc_error THEN

116: v_checkNew);
117: end loop;
118: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
119: EXCEPTION
120: WHEN fnd_api.g_exc_error THEN
121: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
122: x_return_status := fnd_api.g_ret_sts_error;
123:
124: WHEN fnd_api.g_exc_unexpected_error THEN

Line 122: x_return_status := fnd_api.g_ret_sts_error;

118: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
119: EXCEPTION
120: WHEN fnd_api.g_exc_error THEN
121: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
122: x_return_status := fnd_api.g_ret_sts_error;
123:
124: WHEN fnd_api.g_exc_unexpected_error THEN
125: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
126: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 124: WHEN fnd_api.g_exc_unexpected_error THEN

120: WHEN fnd_api.g_exc_error THEN
121: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
122: x_return_status := fnd_api.g_ret_sts_error;
123:
124: WHEN fnd_api.g_exc_unexpected_error THEN
125: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
126: x_return_status := fnd_api.g_ret_sts_unexp_error;
127:
128: WHEN OTHERS THEN

Line 126: x_return_status := fnd_api.g_ret_sts_unexp_error;

122: x_return_status := fnd_api.g_ret_sts_error;
123:
124: WHEN fnd_api.g_exc_unexpected_error THEN
125: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
126: x_return_status := fnd_api.g_ret_sts_unexp_error;
127:
128: WHEN OTHERS THEN
129: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
130: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 130: x_return_status := fnd_api.g_ret_sts_unexp_error;

126: x_return_status := fnd_api.g_ret_sts_unexp_error;
127:
128: WHEN OTHERS THEN
129: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
130: x_return_status := fnd_api.g_ret_sts_unexp_error;
131: END GET_WB_SERVER_LIST;
132:
133: PROCEDURE SYNC_SERVER (
134: p_language IN varchar2,

Line 148: x_return_status := fnd_api.g_ret_sts_success;

144: l_wbsvr_id number(15,0);
145: l_ieo_svr_id number(15,0);
146:
147: BEGIN
148: x_return_status := fnd_api.g_ret_sts_success;
149:
150: -- there are 2 parts to syncing the schema - one is to delete data for
151: -- servers that no longer exist in ieo schema, and the other is to
152: -- create data for new servers created in ieo schema

Line 291: WHEN fnd_api.g_exc_error THEN

287:
288: IEB_SYNC_SERVER.SYNC_CAT_ENTRIES(p_language, x_return_status);
289:
290: EXCEPTION
291: WHEN fnd_api.g_exc_error THEN
292: x_return_status := fnd_api.g_ret_sts_error;
293:
294: WHEN fnd_api.g_exc_unexpected_error THEN
295: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 292: x_return_status := fnd_api.g_ret_sts_error;

288: IEB_SYNC_SERVER.SYNC_CAT_ENTRIES(p_language, x_return_status);
289:
290: EXCEPTION
291: WHEN fnd_api.g_exc_error THEN
292: x_return_status := fnd_api.g_ret_sts_error;
293:
294: WHEN fnd_api.g_exc_unexpected_error THEN
295: x_return_status := fnd_api.g_ret_sts_unexp_error;
296:

Line 294: WHEN fnd_api.g_exc_unexpected_error THEN

290: EXCEPTION
291: WHEN fnd_api.g_exc_error THEN
292: x_return_status := fnd_api.g_ret_sts_error;
293:
294: WHEN fnd_api.g_exc_unexpected_error THEN
295: x_return_status := fnd_api.g_ret_sts_unexp_error;
296:
297: WHEN OTHERS THEN
298: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 295: x_return_status := fnd_api.g_ret_sts_unexp_error;

291: WHEN fnd_api.g_exc_error THEN
292: x_return_status := fnd_api.g_ret_sts_error;
293:
294: WHEN fnd_api.g_exc_unexpected_error THEN
295: x_return_status := fnd_api.g_ret_sts_unexp_error;
296:
297: WHEN OTHERS THEN
298: x_return_status := fnd_api.g_ret_sts_unexp_error;
299:

Line 298: x_return_status := fnd_api.g_ret_sts_unexp_error;

294: WHEN fnd_api.g_exc_unexpected_error THEN
295: x_return_status := fnd_api.g_ret_sts_unexp_error;
296:
297: WHEN OTHERS THEN
298: x_return_status := fnd_api.g_ret_sts_unexp_error;
299:
300: END SYNC_SERVER;
301:
302: PROCEDURE INSERT_SVC_CAT_ENTRIES (

Line 325: x_return_status := fnd_api.g_ret_sts_success;

321: l_parent_id number(15,0);
322: l_parent_id_ib number(15,0);
323: l_parent_id_ob number(15,0);
324: begin
325: x_return_status := fnd_api.g_ret_sts_success;
326:
327: for c1_rec in c1 loop
328: select IEB_SVC_CATS_S1.NEXTVAL into l_wbsc_id from sys.dual;
329: if c1_rec.depth = 0 then

Line 395: WHEN fnd_api.g_exc_error THEN

391:
392: exit when c1%notfound;
393: end loop;
394: EXCEPTION
395: WHEN fnd_api.g_exc_error THEN
396: x_return_status := fnd_api.g_ret_sts_error;
397:
398: WHEN fnd_api.g_exc_unexpected_error THEN
399: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 396: x_return_status := fnd_api.g_ret_sts_error;

392: exit when c1%notfound;
393: end loop;
394: EXCEPTION
395: WHEN fnd_api.g_exc_error THEN
396: x_return_status := fnd_api.g_ret_sts_error;
397:
398: WHEN fnd_api.g_exc_unexpected_error THEN
399: x_return_status := fnd_api.g_ret_sts_unexp_error;
400:

Line 398: WHEN fnd_api.g_exc_unexpected_error THEN

394: EXCEPTION
395: WHEN fnd_api.g_exc_error THEN
396: x_return_status := fnd_api.g_ret_sts_error;
397:
398: WHEN fnd_api.g_exc_unexpected_error THEN
399: x_return_status := fnd_api.g_ret_sts_unexp_error;
400:
401: WHEN OTHERS THEN
402: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 399: x_return_status := fnd_api.g_ret_sts_unexp_error;

395: WHEN fnd_api.g_exc_error THEN
396: x_return_status := fnd_api.g_ret_sts_error;
397:
398: WHEN fnd_api.g_exc_unexpected_error THEN
399: x_return_status := fnd_api.g_ret_sts_unexp_error;
400:
401: WHEN OTHERS THEN
402: x_return_status := fnd_api.g_ret_sts_unexp_error;
403:

Line 402: x_return_status := fnd_api.g_ret_sts_unexp_error;

398: WHEN fnd_api.g_exc_unexpected_error THEN
399: x_return_status := fnd_api.g_ret_sts_unexp_error;
400:
401: WHEN OTHERS THEN
402: x_return_status := fnd_api.g_ret_sts_unexp_error;
403:
404: END INSERT_SVC_CAT_ENTRIES;
405:
406:

Line 446: x_return_status := fnd_api.g_ret_sts_success;

442:
443:
444:
445: BEGIN
446: x_return_status := fnd_api.g_ret_sts_success;
447: l_default_count := 0;
448: l_count := 0;
449:
450:

Line 601: WHEN fnd_api.g_exc_error THEN

597: commit;
598: end loop;
599:
600: EXCEPTION
601: WHEN fnd_api.g_exc_error THEN
602: x_return_status := fnd_api.g_ret_sts_error;
603: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
604:
605: WHEN fnd_api.g_exc_unexpected_error THEN

Line 602: x_return_status := fnd_api.g_ret_sts_error;

598: end loop;
599:
600: EXCEPTION
601: WHEN fnd_api.g_exc_error THEN
602: x_return_status := fnd_api.g_ret_sts_error;
603: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
604:
605: WHEN fnd_api.g_exc_unexpected_error THEN
606: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 605: WHEN fnd_api.g_exc_unexpected_error THEN

601: WHEN fnd_api.g_exc_error THEN
602: x_return_status := fnd_api.g_ret_sts_error;
603: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
604:
605: WHEN fnd_api.g_exc_unexpected_error THEN
606: x_return_status := fnd_api.g_ret_sts_unexp_error;
607: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
608:
609: WHEN OTHERS THEN

Line 606: x_return_status := fnd_api.g_ret_sts_unexp_error;

602: x_return_status := fnd_api.g_ret_sts_error;
603: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
604:
605: WHEN fnd_api.g_exc_unexpected_error THEN
606: x_return_status := fnd_api.g_ret_sts_unexp_error;
607: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
608:
609: WHEN OTHERS THEN
610: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 610: x_return_status := fnd_api.g_ret_sts_unexp_error;

606: x_return_status := fnd_api.g_ret_sts_unexp_error;
607: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
608:
609: WHEN OTHERS THEN
610: x_return_status := fnd_api.g_ret_sts_unexp_error;
611: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
612:
613:
614: