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.CZ_ORAAPPS_INTEGRATE dependencies on CZ_UTILS

Line 1238: cz_utils.log_report('CZ_ORAAPPS_INTEGRATE', null, null,

1234: PROCEDURE LOG_REPORT
1235: (inStr IN VARCHAR2) AS
1236:
1237: BEGIN
1238: cz_utils.log_report('CZ_ORAAPPS_INTEGRATE', null, null,
1239: instr, fnd_log.LEVEL_ERROR);
1240: EXCEPTION
1241: WHEN OTHERS THEN
1242: ROLLBACK;

Line 1278: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_GETSETTING_FAILED','ERRORTEXT',SQLERRM);

1274: END LOOP;
1275: CLOSE C_GETSET;
1276: EXCEPTION
1277: WHEN OTHERS THEN
1278: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_GETSETTING_FAILED','ERRORTEXT',SQLERRM);
1279: --Now done from GET_TEXT
1280: --FND_FILE.PUT_LINE(FND_FILE.LOG,'GetSetting failed: '||SQLERRM);
1281: END;
1282: ------------------------------------------------------------------------------

Line 1310: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_SETSETTING_FAILED','ERRORTEXT',SQLERRM);

1306: CLOSE c1;
1307: COMMIT;
1308: EXCEPTION
1309: WHEN OTHERS THEN
1310: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_SETSETTING_FAILED','ERRORTEXT',SQLERRM);
1311: --Now done from GET_TEXT
1312: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Setting not assigned: '||SQLERRM);
1313: END;
1314: ------------------------------------------------------------------------------

Line 1343: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_READXFRTABLE_FAILED','ERRORTEXT',SQLERRM);

1339: END LOOP;
1340: CLOSE C_GETSET;
1341: EXCEPTION
1342: WHEN OTHERS THEN
1343: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_READXFRTABLE_FAILED','ERRORTEXT',SQLERRM);
1344: END;
1345: ------------------------------------------------------------------------------
1346: PROCEDURE SetTableImport(errbuf OUT NOCOPY VARCHAR2,
1347: retcode OUT NOCOPY NUMBER,

Line 1360: LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_NOXFRTABLEDATA'));

1356: DISABLED=DECODE(UPPER(EnableImport),'0','1','OFF','1','N','1','DISABLE','1',
1357: '1','0','ON','0','Y','0','ENABLE','0',DISABLED)
1358: WHERE DST_TABLE=DstTableName AND XFR_GROUP LIKE LIKE_PhaseName;
1359: IF(SQL%NOTFOUND)THEN
1360: LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_NOXFRTABLEDATA'));
1361: END IF;
1362: COMMIT;
1363: EXCEPTION
1364: WHEN OTHERS THEN

Line 1365: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_SETXFRTABLE_FAILED','ERRORTEXT',SQLERRM);

1361: END IF;
1362: COMMIT;
1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_SETXFRTABLE_FAILED','ERRORTEXT',SQLERRM);
1366: LOG_REPORT(errbuf);
1367: END;
1368:
1369: ------------------------------------------------------------------------------

Line 1888: cz_utils.get_text('CZ_EXT_VIEW_CREATION_ERR_DTL','SQLERRM',Sqlerrm));

1884: EXCEPTION
1885: WHEN OTHERS THEN
1886:
1887: log_report('APC is not installed, stub views will be created.'||
1888: cz_utils.get_text('CZ_EXT_VIEW_CREATION_ERR_DTL','SQLERRM',Sqlerrm));
1889:
1890: v_apc_props_string :=
1891: 'CREATE OR REPLACE VIEW CZ_EXV_APC_PROPERTIES AS ' ||
1892: ' SELECT ' ||

Line 1952: log_report(v_errorString || cz_utils.get_text('CZ_EXT_VIEW_CREATION_ERR_DTL','SQLERRM',Sqlerrm));

1948: return v_success;
1949:
1950: EXCEPTION
1951: WHEN OTHERS THEN
1952: log_report(v_errorString || cz_utils.get_text('CZ_EXT_VIEW_CREATION_ERR_DTL','SQLERRM',Sqlerrm));
1953: return v_error;
1954: END create_exv_views;
1955:
1956: ------------------------------------------------------------------------------

Line 2010: log_report('recreate_exv_views: ' || CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS'));

2006: END IF;
2007: COMMIT;
2008: EXCEPTION
2009: WHEN TOO_MANY_ROWS THEN
2010: log_report('recreate_exv_views: ' || CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS'));
2011: WHEN OTHERS THEN
2012: log_report(SQLERRM);
2013: END;
2014:

Line 2032: errbuf:=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);

2028: errbuf:='';
2029: END IF;
2030: IF v_views_status=LINK_IS_DOWN THEN
2031: retcode:=2;
2032: errbuf:=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
2033: END IF;
2034: END;
2035:
2036: ------------------------------------------------------------------------------

Line 2122: log_report(v_errorString || cz_utils.get_text('CZ_DROP_EXT_VIEWS_ERR','SQLERRM',Sqlerrm));

2118: return v_success;
2119:
2120: EXCEPTION
2121: WHEN OTHERS THEN
2122: log_report(v_errorString || cz_utils.get_text('CZ_DROP_EXT_VIEWS_ERR','SQLERRM',Sqlerrm));
2123: return v_error;
2124: END drop_exv_views;
2125:
2126:

Line 2214: Errbuf := cz_utils.get_text('CZ_IMP_SERVER_EXISTS_DEF');

2210: IF (v_import_enabled = '1') THEN
2211: SELECT count(*) INTO v_import_count FROM cz_servers
2212: WHERE import_enabled = '1';
2213: IF (V_IMPORT_count > 0) THEN
2214: Errbuf := cz_utils.get_text('CZ_IMP_SERVER_EXISTS_DEF');
2215: log_report(Errbuf);
2216: Retcode := '2';
2217: return;
2218: END IF;

Line 2231: errbuf := cz_utils.get_text('CZ_DB_LINK_EXISTS','LINKNAME',v_fndnam_link_name);

2227:
2228: v_dummy := doesLinkExist(v_fndnam_link_name);
2229:
2230: if (v_dummy > 0) THEN
2231: errbuf := cz_utils.get_text('CZ_DB_LINK_EXISTS','LINKNAME',v_fndnam_link_name);
2232: log_report(v_errorString || errbuf);
2233: Retcode := '2';
2234: return;
2235: END IF;

Line 2238: errbuf := cz_utils.get_text('CZ_DB_LINK_ERROR', 'SQLERRM', Sqlerrm);

2234: return;
2235: END IF;
2236: EXCEPTION
2237: WHEN OTHERS THEN
2238: errbuf := cz_utils.get_text('CZ_DB_LINK_ERROR', 'SQLERRM', Sqlerrm);
2239: log_report(v_errorString || errbuf);
2240: Retcode := '2';
2241: return;
2242: END;

Line 2259: errbuf := cz_utils.get_text('CZ_CANNOT_INSERT_SERVER','SQLERRM',Sqlerrm);

2255: FNDNAM_LINK_NAME, v_IMPORT_ENABLED );
2256: COMMIT;
2257: EXCEPTION
2258: WHEN OTHERS THEN
2259: errbuf := cz_utils.get_text('CZ_CANNOT_INSERT_SERVER','SQLERRM',Sqlerrm);
2260: v_error_status := SQLERRM;
2261: log_report(v_errorString || errbuf);
2262: Retcode := '2';
2263: return;

Line 2268: errbuf := cz_utils.get_text('CZ_SERVER_EXISTS_DEF');

2264: END;
2265: ELSE
2266: -- this message should have name of existing server with same configuration
2267: -- should change code to get the name of this server and add it to the message
2268: errbuf := cz_utils.get_text('CZ_SERVER_EXISTS_DEF');
2269: log_report(v_errorString || errbuf);
2270: Retcode := '0';
2271: return;
2272: END IF;

Line 2362: errbuf := cz_utils.get_text('CZ_SERVER_EXISTS_MOD','SVRNAME',matching_local_name);

2358: AND db_listener_port = v_db_listener_port
2359: AND fndnam = v_fndnam
2360: AND local_name <> v_local_name;
2361: IF (sql%FOUND) THEN
2362: errbuf := cz_utils.get_text('CZ_SERVER_EXISTS_MOD','SVRNAME',matching_local_name);
2363: log_report(v_errorString || errbuf);
2364: Retcode := '2';
2365: return;
2366: END IF;

Line 2378: errbuf := cz_utils.get_text('CZ_IMP_ALTER_LOCAL_SERVER_ERR');

2374: or (v_instance_name <> l_instance_name) or (v_fndnam <> l_fndnam)
2375: or (v_global_identity <> l_global_identity) or (v_notes <> l_notes)
2376: or (v_fndnam_link_name <> l_fndnam_link_name)) ) THEN
2377: -- cannot alter anything other than import_enabled for Local entry
2378: errbuf := cz_utils.get_text('CZ_IMP_ALTER_LOCAL_SERVER_ERR');
2379: log_report(v_errorString || errbuf);
2380: Retcode := '2';
2381: return;
2382: END IF;

Line 2391: errbuf := cz_utils.get_text('CZ_IMP_SERVER_EXISTS_MOD');

2387: WHERE import_enabled = '1'
2388: AND local_name <> v_local_name;
2389: IF (V_IMPORT_count > 0) THEN
2390: -- another server has import enabled, only one is allowed
2391: errbuf := cz_utils.get_text('CZ_IMP_SERVER_EXISTS_MOD');
2392: log_report(v_errorString || errbuf);
2393: Retcode := '2';
2394: return;
2395: END IF;

Line 2420: cz_utils.get_text('CZ_DB_LINK_DROPPED','LINKNAME',

2416: if (v_dummy > 0) then
2417: v_CreateString := 'drop database link ' || l_fndnam_link_name;
2418: EXECUTE IMMEDIATE v_CreateString;
2419: log_report(v_errorstring ||
2420: cz_utils.get_text('CZ_DB_LINK_DROPPED','LINKNAME',
2421: l_fndnam_link_name));
2422: END IF;
2423: EXCEPTION
2424: WHEN OTHERS THEN

Line 2426: cz_utils.get_text('CZ_DB_LINK_ERROR','SQLERRM',Sqlerrm));

2422: END IF;
2423: EXCEPTION
2424: WHEN OTHERS THEN
2425: log_report(v_errorString ||
2426: cz_utils.get_text('CZ_DB_LINK_ERROR','SQLERRM',Sqlerrm));
2427: Retcode := '1';
2428: END;
2429: END IF;
2430:

Line 2454: errbuf := cz_utils.get_text('CZ_MOD_SERVER_ERR','SQLERRM',Sqlerrm);

2450:
2451: EXCEPTION
2452: WHEN OTHERS THEN
2453: Retcode := '2';
2454: errbuf := cz_utils.get_text('CZ_MOD_SERVER_ERR','SQLERRM',Sqlerrm);
2455: log_report(v_errorString|| errbuf);
2456: return;
2457: END;
2458: END IF;

Line 2463: errbuf := cz_utils.get_text('CZ_MOD_SERVER_ERR','SQLERRM',Sqlerrm);

2459: END IF;
2460: EXCEPTION
2461: WHEN OTHERS THEN
2462: Retcode := '2';
2463: errbuf := cz_utils.get_text('CZ_MOD_SERVER_ERR','SQLERRM',Sqlerrm);
2464: log_report(v_errorString|| errbuf);
2465: return;
2466: END;
2467:

Line 2483: errbuf := cz_utils.get_text('CZ_MOD_SERVER_ERR','SQLERRM',Sqlerrm);

2479: WHERE cz_servers.server_local_id = v_server_id ;
2480: EXCEPTION
2481: WHEN OTHERS THEN
2482: Retcode := '2';
2483: errbuf := cz_utils.get_text('CZ_MOD_SERVER_ERR','SQLERRM',Sqlerrm);
2484: log_report(v_errorString|| errbuf);
2485: return;
2486: END;
2487:

Line 2495: errbuf := cz_utils.get_text('CZ_EXT_VIEW_CREATION_ERR');

2491: BEGIN
2492: xerror := create_exv_views(v_local_name);
2493: IF (xerror <> '0') THEN
2494: -- detailed error has already been logged
2495: errbuf := cz_utils.get_text('CZ_EXT_VIEW_CREATION_ERR');
2496: Retcode := '2';
2497: return;
2498: END IF;
2499: EXCEPTION

Line 2502: errbuf := cz_utils.get_text('CZ_LINK_CREATION_ERR','SQLERRM',Sqlerrm);

2498: END IF;
2499: EXCEPTION
2500: WHEN OTHERS THEN
2501: Retcode := '2';
2502: errbuf := cz_utils.get_text('CZ_LINK_CREATION_ERR','SQLERRM',Sqlerrm);
2503: log_report(v_errorString|| errbuf);
2504: return;
2505: END;
2506: END IF;

Line 2516: errbuf := cz_utils.get_text('CZ_SERVER_NOT_EXIST','SVRNAME',v_local_name);

2512: COMMIT;
2513:
2514: EXCEPTION
2515: WHEN NO_DATA_FOUND THEN
2516: errbuf := cz_utils.get_text('CZ_SERVER_NOT_EXIST','SVRNAME',v_local_name);
2517: log_report(v_errorString || errbuf);
2518: RetCode := '1';
2519: WHEN OTHERS THEN
2520: Retcode := '2';

Line 2521: errbuf := cz_utils.get_text('CZ_LINK_CREATION_ERR','SQLERRM',Sqlerrm);

2517: log_report(v_errorString || errbuf);
2518: RetCode := '1';
2519: WHEN OTHERS THEN
2520: Retcode := '2';
2521: errbuf := cz_utils.get_text('CZ_LINK_CREATION_ERR','SQLERRM',Sqlerrm);
2522: log_report(v_errorString|| errbuf);
2523: END;
2524: END alter_cz_server_cp;
2525:

Line 2581: Errbuf:= cz_utils.get_text('CZ_SHOW_SERVERS_ERR','SQLERRM',Sqlerrm);

2577: END LOOP;
2578: CLOSE C_GETSERVERS;
2579: EXCEPTION
2580: WHEN OTHERS THEN
2581: Errbuf:= cz_utils.get_text('CZ_SHOW_SERVERS_ERR','SQLERRM',Sqlerrm);
2582: log_report(v_errorString || errbuf);
2583: retcode := 2;
2584: END show_cz_servers_cp;
2585:

Line 2602: log_report(cz_utils.get_text('CZ_HGRID_VIEW_ERROR_DTL', 'ERRORTEXT', SQLERRM));

2598: ' WHERE object_type = ''FLD''';
2599: RETURN v_success;
2600: EXCEPTION
2601: WHEN OTHERS THEN
2602: log_report(cz_utils.get_text('CZ_HGRID_VIEW_ERROR_DTL', 'ERRORTEXT', SQLERRM));
2603: RETURN v_error;
2604: END;
2605: ---------- Create db link ----------------------------------------------------
2606: PROCEDURE create_link_cp(Errbuf IN OUT NOCOPY VARCHAR2,

Line 2671: errbuf := CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_fndnam_link_name);

2667: --
2668: v_link_status:=isLinkAlive(v_fndnam_link_name);
2669:
2670: IF v_link_status = LINK_IS_DOWN THEN
2671: errbuf := CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_fndnam_link_name);
2672: Retcode := 1;
2673: RETURN;
2674: END IF;
2675:

Line 2689: errbuf := cz_utils.get_text('CZ_EXT_VIEW_CREATION_ERR');

2685: xerror := create_exv_views(v_local_name);
2686:
2687: IF (xerror <> '0') THEN
2688: -- detailed error has already been logged
2689: errbuf := cz_utils.get_text('CZ_EXT_VIEW_CREATION_ERR');
2690: Retcode := 2;
2691: return;
2692: END IF;
2693: END IF;

Line 2695: -- errbuf := cz_utils.get_text('CZ_LINK_FOR_CREATION_EXISTS','LINKNAME',v_fndnam_link_name);

2691: return;
2692: END IF;
2693: END IF;
2694:
2695: -- errbuf := cz_utils.get_text('CZ_LINK_FOR_CREATION_EXISTS','LINKNAME',v_fndnam_link_name);
2696: -- log_report(v_errorString || errbuf);
2697: -- retCode := 2;
2698: -- retCode := 1;
2699: -- return;

Line 2707: errbuf := cz_utils.get_text('CZ_LINK_CREATION_ERR','SQLERRM',Sqlerrm);

2703: ' using ''(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = '||v_hostname||')(PORT = '||v_db_listener_port||'))(CONNECT_DATA = (SID = '||v_instance_name||')))''';
2704: EXECUTE IMMEDIATE v_CreateString;
2705: EXCEPTION
2706: WHEN OTHERS THEN
2707: errbuf := cz_utils.get_text('CZ_LINK_CREATION_ERR','SQLERRM',Sqlerrm);
2708: log_report(v_errorString || errbuf);
2709: retCode := 2;
2710: return;
2711: END;

Line 2727: errbuf := cz_utils.get_text('CZ_DB_VERSION_NOT_FOUND', 'SQLERRM', Sqlerrm);

2723: end if;
2724: dbms_sql.close_cursor(v_cur);
2725: EXCEPTION
2726: WHEN OTHERS THEN
2727: errbuf := cz_utils.get_text('CZ_DB_VERSION_NOT_FOUND', 'SQLERRM', Sqlerrm);
2728: Retcode := 1;
2729: log_report(v_errorString || errbuf);
2730: END;
2731:

Line 2740: errbuf := cz_utils.get_text('CZ_DB_VERSION_UPDATE_FAILURE', 'SQLERRM', Sqlerrm);

2736: WHERE cz_servers.local_name = v_local_name ;
2737: COMMIT;
2738: EXCEPTION
2739: WHEN OTHERS THEN
2740: errbuf := cz_utils.get_text('CZ_DB_VERSION_UPDATE_FAILURE', 'SQLERRM', Sqlerrm);
2741: Retcode := 2;
2742: log_report(v_errorString || errbuf);
2743: return;
2744: END;

Line 2750: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_fndnam_link_name);

2746:
2747: v_link_status:=isLinkAlive(v_fndnam_link_name);
2748:
2749: IF v_link_status = LINK_IS_DOWN THEN
2750: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_fndnam_link_name);
2751: Retcode := 2;
2752: RETURN;
2753: END IF;
2754:

Line 2766: errbuf := cz_utils.get_text('CZ_EXT_VIEW_CREATION_ERR');

2762: IF(v_import_enabled = '1') THEN
2763:
2764: IF (xerror <> '0') THEN
2765: -- detailed error has already been logged
2766: errbuf := cz_utils.get_text('CZ_EXT_VIEW_CREATION_ERR');
2767: Retcode := 2;
2768: RETURN;
2769: END IF;
2770: END IF;

Line 2774: errbuf := cz_utils.get_text('CZ_LINK_CREATION_ERR','SQLERRM',Sqlerrm);

2770: END IF;
2771:
2772: EXCEPTION
2773: WHEN OTHERS THEN
2774: errbuf := cz_utils.get_text('CZ_LINK_CREATION_ERR','SQLERRM',Sqlerrm);
2775: log_report(v_errorString || errbuf);
2776: Retcode := 2;
2777: return;
2778: END;

Line 2782: errbuf := cz_utils.get_text('CZ_LINK_CREATION_ERR','SQLERRM',Sqlerrm);

2778: END;
2779: END IF;
2780: EXCEPTION
2781: WHEN OTHERS THEN
2782: errbuf := cz_utils.get_text('CZ_LINK_CREATION_ERR','SQLERRM',Sqlerrm);
2783: log_report(v_errorString || errbuf);
2784: Retcode := 2;
2785: return;
2786: END;

Line 3143: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');

3139:
3140: EXCEPTION
3141: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3142: retcode:=2;
3143: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');
3144: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3145: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3146: retcode:=2;
3147: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');

Line 3144: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

3140: EXCEPTION
3141: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3142: retcode:=2;
3143: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');
3144: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3145: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3146: retcode:=2;
3147: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3148: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

Line 3147: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');

3143: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');
3144: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3145: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3146: retcode:=2;
3147: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3148: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3149: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3150: retcode:=2;
3151: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

Line 3148: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

3144: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3145: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3146: retcode:=2;
3147: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3148: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3149: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3150: retcode:=2;
3151: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3152: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

Line 3151: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

3147: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3148: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3149: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3150: retcode:=2;
3151: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3152: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3153: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3154: retcode:=2;
3155: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);

Line 3152: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

3148: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3149: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3150: retcode:=2;
3151: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3152: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3153: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3154: retcode:=2;
3155: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3156: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

Line 3155: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);

3151: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3152: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3153: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3154: retcode:=2;
3155: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3156: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3157: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3158: retcode:=2;
3159: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

Line 3156: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

3152: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3153: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3154: retcode:=2;
3155: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3156: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3157: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3158: retcode:=2;
3159: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3160: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

Line 3159: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

3155: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3156: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3157: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3158: retcode:=2;
3159: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3160: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3161: WHEN CZ_ADMIN.IMP_MODEL_NOT_FOUND THEN
3162: retcode:=2;
3163: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MODEL_NOT_FOUND', 'MODELID', iModel_Id);

Line 3160: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

3156: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3157: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3158: retcode:=2;
3159: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3160: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3161: WHEN CZ_ADMIN.IMP_MODEL_NOT_FOUND THEN
3162: retcode:=2;
3163: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MODEL_NOT_FOUND', 'MODELID', iModel_Id);
3164: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

Line 3163: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MODEL_NOT_FOUND', 'MODELID', iModel_Id);

3159: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3160: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3161: WHEN CZ_ADMIN.IMP_MODEL_NOT_FOUND THEN
3162: retcode:=2;
3163: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MODEL_NOT_FOUND', 'MODELID', iModel_Id);
3164: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3165: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3166: retcode:=2;
3167: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 3164: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

3160: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3161: WHEN CZ_ADMIN.IMP_MODEL_NOT_FOUND THEN
3162: retcode:=2;
3163: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MODEL_NOT_FOUND', 'MODELID', iModel_Id);
3164: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3165: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3166: retcode:=2;
3167: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3168: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

Line 3167: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

3163: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MODEL_NOT_FOUND', 'MODELID', iModel_Id);
3164: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3165: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3166: retcode:=2;
3167: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3168: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3169: WHEN OTHERS THEN
3170: retcode:=2;
3171: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 3168: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

3164: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3165: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3166: retcode:=2;
3167: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3168: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3169: WHEN OTHERS THEN
3170: retcode:=2;
3171: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3172: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

Line 3171: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

3167: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3168: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3169: WHEN OTHERS THEN
3170: retcode:=2;
3171: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3172: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3173: END RefreshSingleModel_cp;
3174:
3175: ------------------------------------------------------------------------------------------

Line 3172: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);

3168: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3169: WHEN OTHERS THEN
3170: retcode:=2;
3171: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3172: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.RefreshSingleModel_cp',11276,NULL);
3173: END RefreshSingleModel_cp;
3174:
3175: ------------------------------------------------------------------------------------------
3176: PROCEDURE RemoveModel_cp

Line 3196: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');

3192:
3193: EXCEPTION
3194: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3195: retcode:=2;
3196: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');
3197: log_report('REMOVEMODEL_CP: ' || errbuf);
3198: WHEN OTHERS THEN
3199: retcode:=2;
3200: errbuf:=cz_utils.get_text('CZ_IMP_CHANGE_PARAMS_ERR','SQLERRM',sqlerrm);

Line 3200: errbuf:=cz_utils.get_text('CZ_IMP_CHANGE_PARAMS_ERR','SQLERRM',sqlerrm);

3196: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');
3197: log_report('REMOVEMODEL_CP: ' || errbuf);
3198: WHEN OTHERS THEN
3199: retcode:=2;
3200: errbuf:=cz_utils.get_text('CZ_IMP_CHANGE_PARAMS_ERR','SQLERRM',sqlerrm);
3201: log_report('REMOVEMODEL_CP: ' || errbuf);
3202: END;
3203:
3204: ------------------------------------------------------------------------------------------

Line 3243: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');

3239: END IF;
3240: EXCEPTION
3241: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3242: retcode:=2;
3243: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
3244: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3245: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3246: retcode:=2;
3247: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

Line 3244: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

3240: EXCEPTION
3241: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3242: retcode:=2;
3243: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
3244: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3245: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3246: retcode:=2;
3247: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3248: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

Line 3247: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

3243: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
3244: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3245: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3246: retcode:=2;
3247: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3248: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3249: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3250: retcode:=2;
3251: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');

Line 3248: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

3244: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3245: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3246: retcode:=2;
3247: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3248: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3249: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3250: retcode:=2;
3251: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3252: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

Line 3251: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');

3247: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3248: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3249: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3250: retcode:=2;
3251: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3252: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3253: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3254: retcode:=2;
3255: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

Line 3252: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

3248: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3249: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3250: retcode:=2;
3251: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3252: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3253: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3254: retcode:=2;
3255: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3256: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

Line 3255: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

3251: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3252: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3253: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3254: retcode:=2;
3255: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3256: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3257: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3258: retcode:=2;
3259: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);

Line 3256: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

3252: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3253: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3254: retcode:=2;
3255: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3256: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3257: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3258: retcode:=2;
3259: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3260: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

Line 3259: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);

3255: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3256: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3257: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3258: retcode:=2;
3259: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3260: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3261: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3262: retcode:=2;
3263: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 3260: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

3256: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3257: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3258: retcode:=2;
3259: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3260: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3261: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3262: retcode:=2;
3263: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3264: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

Line 3263: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

3259: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3260: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3261: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3262: retcode:=2;
3263: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3264: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3265: WHEN OTHERS THEN
3266: retcode:=2;
3267: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 3264: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

3260: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3261: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3262: retcode:=2;
3263: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3264: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3265: WHEN OTHERS THEN
3266: retcode:=2;
3267: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3268: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

Line 3267: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

3263: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3264: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3265: WHEN OTHERS THEN
3266: retcode:=2;
3267: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3268: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3269: END;
3270:
3271: ------------------------------------------------------------------------------------------

Line 3268: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);

3264: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3265: WHEN OTHERS THEN
3266: retcode:=2;
3267: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3268: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.go_cp',11276,NULL);
3269: END;
3270:
3271: ------------------------------------------------------------------------------------------
3272:

Line 3318: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');

3314: END IF;
3315: EXCEPTION
3316: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3317: retcode:=2;
3318: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
3319: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3320: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3321: retcode:=2;
3322: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

Line 3319: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

3315: EXCEPTION
3316: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3317: retcode:=2;
3318: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
3319: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3320: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3321: retcode:=2;
3322: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3323: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

Line 3322: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

3318: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
3319: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3320: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3321: retcode:=2;
3322: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3323: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3324: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3325: retcode:=2;
3326: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');

Line 3323: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

3319: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3320: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3321: retcode:=2;
3322: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3323: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3324: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3325: retcode:=2;
3326: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3327: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

Line 3326: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');

3322: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3323: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3324: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3325: retcode:=2;
3326: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3327: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3328: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3329: retcode:=2;
3330: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

Line 3327: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

3323: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3324: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3325: retcode:=2;
3326: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3327: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3328: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3329: retcode:=2;
3330: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3331: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

Line 3330: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

3326: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3327: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3328: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3329: retcode:=2;
3330: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3331: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3332: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3333: retcode:=2;
3334: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);

Line 3331: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

3327: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3328: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3329: retcode:=2;
3330: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3331: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3332: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3333: retcode:=2;
3334: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3335: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

Line 3334: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);

3330: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3331: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3332: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3333: retcode:=2;
3334: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3335: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3336: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3337: retcode:=2;
3338: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 3335: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

3331: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3332: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3333: retcode:=2;
3334: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3335: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3336: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3337: retcode:=2;
3338: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3339: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

Line 3338: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

3334: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3335: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3336: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3337: retcode:=2;
3338: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3339: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3340: WHEN OTHERS THEN
3341: retcode:=2;
3342: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 3339: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

3335: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3336: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3337: retcode:=2;
3338: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3339: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3340: WHEN OTHERS THEN
3341: retcode:=2;
3342: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3343: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

Line 3342: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

3338: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3339: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3340: WHEN OTHERS THEN
3341: retcode:=2;
3342: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3343: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3344: END;
3345:
3346: ------------------------------------------------------------------------------------------

Line 3343: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);

3339: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3340: WHEN OTHERS THEN
3341: retcode:=2;
3342: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3343: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3344: END;
3345:
3346: ------------------------------------------------------------------------------------------
3347:

Line 3412: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');

3408: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3409: EXCEPTION
3410: WHEN TOO_MANY_ROWS THEN
3411: retcode:=2;
3412: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3413: log_report('sync_all_models_cp: ' || errbuf);
3414: WHEN NO_DATA_FOUND THEN
3415: retcode:=2;
3416: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

Line 3416: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

3412: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3413: log_report('sync_all_models_cp: ' || errbuf);
3414: WHEN NO_DATA_FOUND THEN
3415: retcode:=2;
3416: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3417: log_report('sync_all_models_cp: ' || errbuf);
3418: WHEN OTHERS THEN
3419: retcode:=2;
3420: errbuf:=SQLERRM;