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 1890: cz_utils.get_text('CZ_EXT_VIEW_CREATION_ERR_DTL','SQLERRM',Sqlerrm));

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3341: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3342: WHEN OTHERS THEN
3343: retcode:=2;
3344: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3345: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateModels_cp',11276,NULL);
3346: END;
3347:
3348: ------------------------------------------------------------------------------------------
3349: -- Bug10011026 This procedure was introduced for Sun implementation where new Concurrent Program

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

3394: END IF;
3395: EXCEPTION
3396: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3397: retcode:=2;
3398: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
3399: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3400: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3401: retcode:=2;
3402: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

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

3395: EXCEPTION
3396: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3397: retcode:=2;
3398: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
3399: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3400: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3401: retcode:=2;
3402: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3403: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);

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

3398: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
3399: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3400: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3401: retcode:=2;
3402: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3403: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3404: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3405: retcode:=2;
3406: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');

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

3399: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3400: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3401: retcode:=2;
3402: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3403: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3404: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3405: retcode:=2;
3406: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3407: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);

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

3402: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
3403: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3404: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3405: retcode:=2;
3406: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3407: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3408: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3409: retcode:=2;
3410: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

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

3403: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3404: WHEN CZ_ADMIN.IMP_TOO_MANY_SERVERS THEN
3405: retcode:=2;
3406: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3407: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3408: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3409: retcode:=2;
3410: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3411: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);

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

3406: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3407: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3408: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3409: retcode:=2;
3410: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3411: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3412: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3413: retcode:=2;
3414: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);

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

3407: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3408: WHEN CZ_ADMIN.IMP_NO_IMP_SERVER THEN
3409: retcode:=2;
3410: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3411: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3412: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3413: retcode:=2;
3414: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3415: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);

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

3410: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3411: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3412: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3413: retcode:=2;
3414: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3415: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3416: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3417: retcode:=2;
3418: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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

3411: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3412: WHEN CZ_ADMIN.IMP_LINK_IS_DOWN THEN
3413: retcode:=2;
3414: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3415: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3416: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3417: retcode:=2;
3418: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3419: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);

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

3414: errbuf :=CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','DBLINK',v_db_link);
3415: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3416: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3417: retcode:=2;
3418: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3419: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3420: WHEN OTHERS THEN
3421: retcode:=2;
3422: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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

3415: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3416: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3417: retcode:=2;
3418: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3419: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3420: WHEN OTHERS THEN
3421: retcode:=2;
3422: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3423: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);

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

3418: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3419: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3420: WHEN OTHERS THEN
3421: retcode:=2;
3422: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3423: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3424: END;
3425:
3426: ------------------------------------------------------------------------------------------

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

3419: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3420: WHEN OTHERS THEN
3421: retcode:=2;
3422: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3423: v_ret:=CZ_UTILS.log_report(errbuf,1,'CZ_ORAAPPS_INTEGRATE.PopulateSingleModel_cp',11276,NULL);
3424: END;
3425:
3426: ------------------------------------------------------------------------------------------
3427:

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

3489: retcode:=CZ_ORAAPPS_INTEGRATE.mRETCODE;
3490: EXCEPTION
3491: WHEN TOO_MANY_ROWS THEN
3492: retcode:=2;
3493: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3494: log_report('sync_all_models_cp: ' || errbuf);
3495: WHEN NO_DATA_FOUND THEN
3496: retcode:=2;
3497: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

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

3493: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
3494: log_report('sync_all_models_cp: ' || errbuf);
3495: WHEN NO_DATA_FOUND THEN
3496: retcode:=2;
3497: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
3498: log_report('sync_all_models_cp: ' || errbuf);
3499: WHEN OTHERS THEN
3500: retcode:=2;
3501: errbuf:=SQLERRM;

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

3562:
3563: EXCEPTION
3564: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3565: retcode:=2;
3566: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');
3567: log_report('UpdateImportFlag_cp: ' || errbuf);
3568: WHEN OTHERS THEN
3569: retcode:=2;
3570: errbuf:=cz_utils.get_text('CZ_IMP_CHANGE_PARAMS_ERR','SQLERRM',sqlerrm);

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

3566: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');
3567: log_report('UpdateImportFlag_cp: ' || errbuf);
3568: WHEN OTHERS THEN
3569: retcode:=2;
3570: errbuf:=cz_utils.get_text('CZ_IMP_CHANGE_PARAMS_ERR','SQLERRM',sqlerrm);
3571: log_report('UpdateImportFlag_cp: ' || errbuf);
3572: END;
3573:
3574: