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_IMP_SINGLE dependencies on CZ_ADMIN

Line 286: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

282:
283: COMMIT;
284:
285: EXCEPTION
286: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
287: RAISE;
288: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
289: RAISE;
290: WHEN OTHERS THEN

Line 288: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

284:
285: EXCEPTION
286: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
287: RAISE;
288: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
289: RAISE;
290: WHEN OTHERS THEN
291: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
292: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_MASTER',11276,inRun_Id);

Line 293: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

289: RAISE;
290: WHEN OTHERS THEN
291: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
292: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_MASTER',11276,inRun_Id);
293: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
294: END;
295: ------------------------------------------------------------------------------------------
296:
297: PROCEDURE setFCEMinMax (minVal IN OUT NOCOPY NUMBER,

Line 1466: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

1462: END LOOP;
1463: CLOSE c_parent;
1464:
1465: EXCEPTION
1466: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1467: RAISE;
1468: WHEN OTHERS THEN
1469: IF(c_parent%ISOPEN)THEN CLOSE c_parent; END IF;
1470: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 1472: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

1468: WHEN OTHERS THEN
1469: IF(c_parent%ISOPEN)THEN CLOSE c_parent; END IF;
1470: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1471: x_error:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.maximum_selected',11276,inRun_Id);
1472: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1473: END;
1474:
1475: ------------------------------------------------------------------------------
1476: ---Check the online PS_NODE table for obsolete ps_nodes, i.e. ps_nodes -

Line 1576: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

1572: d_str := CZ_UTILS.GET_TEXT('CZ_IMP_CZREFS_DELNODE', 'MSG', d_str);
1573: x_error :=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.EXTR_PS_NODE: delete obsolete nodes',11276,inRun_Id);
1574: ROLLBACK;
1575: RAISE;
1576: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1577: ROLLBACK;
1578: RAISE;
1579: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1580: RAISE;

Line 1579: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

1575: RAISE;
1576: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1577: ROLLBACK;
1578: RAISE;
1579: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1580: RAISE;
1581: WHEN OTHERS THEN
1582: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1583: x_error:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.EXTR_PS_NODE: delete obsolete nodes',11276,inRun_Id);

Line 1585: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

1581: WHEN OTHERS THEN
1582: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1583: x_error:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.EXTR_PS_NODE: delete obsolete nodes',11276,inRun_Id);
1584: ROLLBACK;
1585: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1586: END;
1587:
1588: EXCEPTION
1589: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

Line 1589: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

1585: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1586: END;
1587:
1588: EXCEPTION
1589: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1590: RAISE;
1591: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1592: RAISE;
1593: WHEN OTHERS THEN

Line 1591: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

1587:
1588: EXCEPTION
1589: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1590: RAISE;
1591: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1592: RAISE;
1593: WHEN OTHERS THEN
1594: IF(c_data%ISOPEN)THEN CLOSE c_data; END IF;
1595: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 1597: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

1593: WHEN OTHERS THEN
1594: IF(c_data%ISOPEN)THEN CLOSE c_data; END IF;
1595: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1596: x_error:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.EXTR_PS_NODE',11276,inRun_Id);
1597: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1598: END;
1599: ------------------------------------------------------------------------------------------
1600: PROCEDURE EXTR_INTL_TEXT(inRun_ID IN PLS_INTEGER,
1601: nOrg_ID IN NUMBER,

Line 1790: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

1786: end if;
1787:
1788: COMMIT;
1789: EXCEPTION
1790: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1791: RAISE;
1792: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1793: RAISE;
1794: WHEN OTHERS THEN

Line 1792: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

1788: COMMIT;
1789: EXCEPTION
1790: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1791: RAISE;
1792: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1793: RAISE;
1794: WHEN OTHERS THEN
1795: IF(c_data%ISOPEN)THEN CLOSE c_data; END IF;
1796: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 1798: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

1794: WHEN OTHERS THEN
1795: IF(c_data%ISOPEN)THEN CLOSE c_data; END IF;
1796: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1797: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.EXTR_INTL_TEXT',11276,inRun_Id);
1798: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1799: END;
1800: ------------------------------------------------------------------------------------------
1801: PROCEDURE EXTR_DEVL_PROJECT(inRun_ID IN PLS_INTEGER,
1802: nOrg_ID IN NUMBER,

Line 1922: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

1918:
1919: COMMIT;
1920:
1921: EXCEPTION
1922: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1923: RAISE;
1924: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1925: RAISE;
1926: WHEN OTHERS THEN

Line 1924: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

1920:
1921: EXCEPTION
1922: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1923: RAISE;
1924: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1925: RAISE;
1926: WHEN OTHERS THEN
1927: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1928: xERROR:=cz_utils.log_report(d_str,1,'EXTR_DEVL_PROJECT',11276,inRun_Id);

Line 1929: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

1925: RAISE;
1926: WHEN OTHERS THEN
1927: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1928: xERROR:=cz_utils.log_report(d_str,1,'EXTR_DEVL_PROJECT',11276,inRun_Id);
1929: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1930: END;
1931: ------------------------------------------------------------------------------------------
1932: PROCEDURE EXTR_ITEM_TYPES(inRun_ID IN PLS_INTEGER,
1933: nOrg_ID IN NUMBER,

Line 1986: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

1982:
1983: EXCEPTION
1984: WHEN NO_DATA_FOUND THEN
1985: NULL;
1986: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1987: RAISE;
1988: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1989: RAISE;
1990: WHEN OTHERS THEN

Line 1988: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

1984: WHEN NO_DATA_FOUND THEN
1985: NULL;
1986: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1987: RAISE;
1988: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1989: RAISE;
1990: WHEN OTHERS THEN
1991: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1992: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_TYPES',11276,inRun_Id);

Line 1993: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

1989: RAISE;
1990: WHEN OTHERS THEN
1991: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1992: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_TYPES',11276,inRun_Id);
1993: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1994: END;
1995: ------------------------------------------------------------------------------------------
1996:
1997: FUNCTION get_Col_Num(p_col_name IN VARCHAR2,p_col_tbl IN OUT NOCOPY rec_cols_tbl) RETURN NUMBER IS

Line 2745: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

2741: end if;
2742: EXCEPTION
2743: WHEN NO_DATA_FOUND THEN
2744: NULL;
2745: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2746: RAISE;
2747: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
2748: RAISE;
2749: WHEN OTHERS THEN

Line 2747: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

2743: WHEN NO_DATA_FOUND THEN
2744: NULL;
2745: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2746: RAISE;
2747: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
2748: RAISE;
2749: WHEN OTHERS THEN
2750: IF(c_datatype%ISOPEN)THEN CLOSE c_datatype; END IF;
2751: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 2753: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

2749: WHEN OTHERS THEN
2750: IF(c_datatype%ISOPEN)THEN CLOSE c_datatype; END IF;
2751: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
2752: xERROR:=cz_utils.log_report(d_str,1,'EXTR_PROPERTIES',11276,inRun_Id);
2753: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2754: END;
2755: ------------------------------------------------------------------------------------------
2756: PROCEDURE EXTR_ITEM_TYPE_PROPERTIES(inRun_ID IN PLS_INTEGER,
2757: nOrg_ID IN NUMBER,

Line 2795: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

2791:
2792: EXCEPTION
2793: WHEN NO_DATA_FOUND THEN
2794: NULL;
2795: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2796: RAISE;
2797: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
2798: RAISE;
2799: WHEN OTHERS THEN

Line 2797: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

2793: WHEN NO_DATA_FOUND THEN
2794: NULL;
2795: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2796: RAISE;
2797: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
2798: RAISE;
2799: WHEN OTHERS THEN
2800: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
2801: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_TYPE_PROPERTIES',11276,inRun_Id);

Line 2802: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

2798: RAISE;
2799: WHEN OTHERS THEN
2800: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
2801: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_TYPE_PROPERTIES',11276,inRun_Id);
2802: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2803: END;
2804: ------------------------------------------------------------------------------------------
2805: PROCEDURE EXTR_ITEM_PROPERTY_VALUES(inRun_ID IN PLS_INTEGER,
2806: nOrg_ID IN NUMBER,

Line 2849: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

2845: end if;
2846:
2847: COMMIT;
2848: EXCEPTION
2849: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2850: RAISE;
2851: WHEN NO_DATA_FOUND THEN
2852: NULL;
2853: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

Line 2853: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

2849: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2850: RAISE;
2851: WHEN NO_DATA_FOUND THEN
2852: NULL;
2853: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
2854: RAISE;
2855: WHEN OTHERS THEN
2856: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
2857: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_PROPERTY_VALUES',11276,inRun_Id);

Line 2858: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

2854: RAISE;
2855: WHEN OTHERS THEN
2856: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
2857: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_PROPERTY_VALUES',11276,inRun_Id);
2858: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2859: END;
2860: ------------------------------------------------------------------------------------------
2861: PROCEDURE extract_table(inRun_ID IN PLS_INTEGER,
2862: table_name IN VARCHAR2,

Line 3117: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

3113: ELSE
3114: RETURN TRUE;
3115: END IF;
3116: EXCEPTION
3117: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3118: RAISE;
3119: WHEN OTHERS THEN
3120: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3121: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.GET_REMOTE_IMPORT',11276);

Line 3122: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3118: RAISE;
3119: WHEN OTHERS THEN
3120: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3121: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.GET_REMOTE_IMPORT',11276);
3122: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3123: END GET_REMOTE_IMPORT;
3124: ------------------------------------------------------------------------------------------
3125: FUNCTION isAppsVersion11i(fndLinkName IN VARCHAR2)
3126: RETURN BOOLEAN

Line 3150: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

3146: return false;
3147: END IF;
3148:
3149: EXCEPTION
3150: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3151: RAISE;
3152: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3153: RAISE;
3154: WHEN OTHERS THEN

Line 3152: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

3148:
3149: EXCEPTION
3150: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3151: RAISE;
3152: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3153: RAISE;
3154: WHEN OTHERS THEN
3155: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3156: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.isAppsVersion11i',11276);

Line 3157: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3153: RAISE;
3154: WHEN OTHERS THEN
3155: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3156: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.isAppsVersion11i',11276);
3157: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3158: END;
3159:
3160: ------------------------------------------------------------------------------------------
3161: FUNCTION ExtractPsNode(inRunId IN NUMBER,

Line 3398: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

3394:
3395: END IF; -- NOT processed_expls_tbl(nTopItemId).EXISTS
3396:
3397: EXCEPTION
3398: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3399: RAISE;
3400: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3401: RAISE;
3402: WHEN OTHERS THEN

Line 3400: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

3396:
3397: EXCEPTION
3398: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3399: RAISE;
3400: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3401: RAISE;
3402: WHEN OTHERS THEN
3403: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3404: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.RECURSION',11276);

Line 3405: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3401: RAISE;
3402: WHEN OTHERS THEN
3403: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3404: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.RECURSION',11276);
3405: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3406: END;
3407: END LOOP;
3408: CLOSE c_expl;
3409:

Line 3413: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

3409:
3410: RETURN nModelId;
3411:
3412: EXCEPTION
3413: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3414: RAISE;
3415: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3416: RAISE;
3417: WHEN OTHERS THEN

Line 3415: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

3411:
3412: EXCEPTION
3413: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3414: RAISE;
3415: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3416: RAISE;
3417: WHEN OTHERS THEN
3418: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3419: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode',11276,inRunId);

Line 3420: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3416: RAISE;
3417: WHEN OTHERS THEN
3418: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3419: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode',11276,inRunId);
3420: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3421: END;
3422: ------------------------------------------------------------------------------------------
3423: PROCEDURE ImportSingleBill(nOrg_ID IN NUMBER,nTop_ID IN NUMBER,
3424: COPY_CHILD_MODELS IN VARCHAR2,

Line 3514: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;

3510: SELECT NVL(config_engine_type,'L') INTO g_CONFIG_ENGINE_TYPE FROM CZ_DEVL_PROJECTS
3511: WHERE devl_project_id=REFRESH_MODEL_ID;
3512: END IF;
3513:
3514: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;
3515: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');
3516:
3517: BEGIN
3518: SELECT server_local_id INTO server_id

Line 3524: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;

3520: WHERE import_enabled = v_enabled;
3521: EXCEPTION
3522: WHEN TOO_MANY_ROWS THEN
3523: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3524: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;
3525: WHEN NO_DATA_FOUND THEN
3526: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_NO_IMP_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3527: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;
3528: END;

Line 3527: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;

3523: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3524: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;
3525: WHEN NO_DATA_FOUND THEN
3526: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_NO_IMP_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3527: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;
3528: END;
3529:
3530: IF(server_id > 0)THEN
3531: IF(CZ_UTILS.check_installed_lang(server_id) <> 0)THEN

Line 3533: RAISE CZ_ADMIN.CZ_LANGUAGES_DO_NOT_MATCH;

3529:
3530: IF(server_id > 0)THEN
3531: IF(CZ_UTILS.check_installed_lang(server_id) <> 0)THEN
3532: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_LANGUAGES_DO_NOT_MATCH'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3533: RAISE CZ_ADMIN.CZ_LANGUAGES_DO_NOT_MATCH;
3534: END IF;
3535: END IF;
3536:
3537: --Determines whether unchanged child models should be refreshed during this run, default - YES.

Line 3605: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3601: EXCEPTION
3602: WHEN OTHERS THEN
3603: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3604: xERROR:=cz_utils.log_report(d_str,1,'SINGLEBILL:CZ_XFR_RUN_INFOS',11276,genRun_ID);
3605: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3606: END;
3607: COMMIT;
3608:
3609: ----1) Run the BOM EXPLODER for the specified bills which are not deleted

Line 3731: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

3727: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
3728: COMMIT;
3729: DBMS_APPLICATION_INFO.SET_MODULE('','');
3730: RAISE;
3731: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3732: IF C_BILL_OF_MATERIAL%ISOPEN THEN CLOSE C_BILL_OF_MATERIAL; END IF;
3733: processed_expls_tbl.DELETE;
3734: RAISE;
3735: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

Line 3735: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

3731: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3732: IF C_BILL_OF_MATERIAL%ISOPEN THEN CLOSE C_BILL_OF_MATERIAL; END IF;
3733: processed_expls_tbl.DELETE;
3734: RAISE;
3735: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3736: RAISE;
3737: WHEN OTHERS THEN
3738: IF C_BILL_OF_MATERIAL%ISOPEN THEN CLOSE C_BILL_OF_MATERIAL; END IF;
3739: processed_expls_tbl.DELETE;

Line 3742: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3738: IF C_BILL_OF_MATERIAL%ISOPEN THEN CLOSE C_BILL_OF_MATERIAL; END IF;
3739: processed_expls_tbl.DELETE;
3740: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3741: xERROR:=cz_utils.log_report(d_str,1,'EXTRACT_PS_NODE',11299,genRun_ID);
3742: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3743: END;
3744:
3745: -------Create the table of all relevant item catalog group ids which will be used for extraction of property related data.
3746:

Line 3836: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

3832:
3833: extract_table(genRun_ID, sTableName, nOrg_ID, nTop_ID, sExpl_type, nModelId);
3834:
3835: EXCEPTION
3836: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3837: RAISE;
3838: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3839: RAISE;
3840: WHEN NO_DATA_FOUND THEN

Line 3838: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

3834:
3835: EXCEPTION
3836: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3837: RAISE;
3838: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3839: RAISE;
3840: WHEN NO_DATA_FOUND THEN
3841: xERROR:=cz_utils.log_report(sTableName||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.extract_table',11276,genRun_ID);
3842: WHEN OTHERS THEN

Line 3845: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3841: xERROR:=cz_utils.log_report(sTableName||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.extract_table',11276,genRun_ID);
3842: WHEN OTHERS THEN
3843: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3844: xERROR:=cz_utils.log_report(d_str,1,'SINGLEBILL:EXTRACTION',11276,genRun_ID);
3845: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3846: END;
3847: END LOOP;
3848: CLOSE C_EXTRACTION_ORDER;
3849:

Line 3869: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

3865: FETCH C_IMPORT_ORDER INTO sTableName;
3866: EXIT WHEN C_IMPORT_ORDER%NOTFOUND;
3867: populate_table(genRun_ID, sTableName, nCommit_size, nMax_err, 'IMPORT', CZ_IMP_SINGLE.RP_ROOT_FOLDER, l_failed);
3868: EXCEPTION
3869: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3870: RAISE;
3871: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3872: RAISE;
3873: WHEN NO_DATA_FOUND THEN

Line 3871: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

3867: populate_table(genRun_ID, sTableName, nCommit_size, nMax_err, 'IMPORT', CZ_IMP_SINGLE.RP_ROOT_FOLDER, l_failed);
3868: EXCEPTION
3869: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3870: RAISE;
3871: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3872: RAISE;
3873: WHEN NO_DATA_FOUND THEN
3874: xERROR:=cz_utils.log_report(sTableName||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.populate_table',11276,genRun_ID);
3875: WHEN OTHERS THEN

Line 3878: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3874: xERROR:=cz_utils.log_report(sTableName||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.populate_table',11276,genRun_ID);
3875: WHEN OTHERS THEN
3876: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3877: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.GO.IMPORT',11276,genRun_ID);
3878: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3879: END;
3880: END LOOP;
3881: CLOSE C_IMPORT_ORDER;
3882:

Line 3968: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

3964: xERROR:=cz_utils.log_report(nModelId||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.UNLOCK',11276,genRun_ID);
3965: END;
3966: END IF;
3967: EXCEPTION
3968: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3969: RAISE;
3970: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3971: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'SINGLEBILL.GENERAL',11276,genRun_ID);
3972: DBMS_APPLICATION_INFO.SET_MODULE('','');

Line 3970: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

3966: END IF;
3967: EXCEPTION
3968: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3969: RAISE;
3970: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3971: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'SINGLEBILL.GENERAL',11276,genRun_ID);
3972: DBMS_APPLICATION_INFO.SET_MODULE('','');
3973: RAISE;
3974: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

Line 3974: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

3970: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3971: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'SINGLEBILL.GENERAL',11276,genRun_ID);
3972: DBMS_APPLICATION_INFO.SET_MODULE('','');
3973: RAISE;
3974: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3975: RAISE;
3976: WHEN NO_DATA_FOUND THEN
3977: xERROR:=cz_utils.log_report(SQLERRM,1,'SINGLEBILL.GENERAL',11276,genRun_ID);
3978: WHEN OTHERS THEN

Line 3996: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3992: END IF;
3993: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3994: xERROR:=cz_utils.log_report(d_str,1,'SINGLEBILL.GENERAL',11276,genRun_ID);
3995: DBMS_APPLICATION_INFO.SET_MODULE('','');
3996: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3997: END ImportSingleBill;
3998: ------------------------------------------------------------------------------------------
3999:
4000: END CZ_IMP_SINGLE;