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 310: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

306:
307: COMMIT;
308:
309: EXCEPTION
310: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
311: RAISE;
312: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
313: RAISE;
314: WHEN OTHERS THEN

Line 312: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

308:
309: EXCEPTION
310: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
311: RAISE;
312: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
313: RAISE;
314: WHEN OTHERS THEN
315: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
316: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_MASTER',11276,inRun_Id);

Line 317: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

313: RAISE;
314: WHEN OTHERS THEN
315: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
316: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_MASTER',11276,inRun_Id);
317: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
318: END;
319: ------------------------------------------------------------------------------------------
320:
321: PROCEDURE setFCEMinMax (minVal IN OUT NOCOPY NUMBER,

Line 1528: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

1524: END LOOP;
1525: CLOSE c_parent;
1526:
1527: EXCEPTION
1528: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1529: RAISE;
1530: WHEN OTHERS THEN
1531: IF(c_parent%ISOPEN)THEN CLOSE c_parent; END IF;
1532: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 1534: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

1530: WHEN OTHERS THEN
1531: IF(c_parent%ISOPEN)THEN CLOSE c_parent; END IF;
1532: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1533: x_error:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.maximum_selected',11276,inRun_Id);
1534: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1535: END;
1536:
1537: ------------------------------------------------------------------------------
1538: ---Check the online PS_NODE table for obsolete ps_nodes, i.e. ps_nodes -

Line 1638: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

1634: d_str := CZ_UTILS.GET_TEXT('CZ_IMP_CZREFS_DELNODE', 'MSG', d_str);
1635: x_error :=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.EXTR_PS_NODE: delete obsolete nodes',11276,inRun_Id);
1636: ROLLBACK;
1637: RAISE;
1638: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1639: ROLLBACK;
1640: RAISE;
1641: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1642: RAISE;

Line 1641: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

1637: RAISE;
1638: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1639: ROLLBACK;
1640: RAISE;
1641: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1642: RAISE;
1643: WHEN OTHERS THEN
1644: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1645: x_error:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.EXTR_PS_NODE: delete obsolete nodes',11276,inRun_Id);

Line 1647: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

1643: WHEN OTHERS THEN
1644: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1645: x_error:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.EXTR_PS_NODE: delete obsolete nodes',11276,inRun_Id);
1646: ROLLBACK;
1647: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1648: END;
1649:
1650: EXCEPTION
1651: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

Line 1651: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

1647: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1648: END;
1649:
1650: EXCEPTION
1651: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1652: RAISE;
1653: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1654: RAISE;
1655: WHEN OTHERS THEN

Line 1653: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

1649:
1650: EXCEPTION
1651: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1652: RAISE;
1653: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1654: RAISE;
1655: WHEN OTHERS THEN
1656: IF(c_data%ISOPEN)THEN CLOSE c_data; END IF;
1657: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 1659: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

1655: WHEN OTHERS THEN
1656: IF(c_data%ISOPEN)THEN CLOSE c_data; END IF;
1657: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1658: x_error:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.EXTR_PS_NODE',11276,inRun_Id);
1659: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1660: END;
1661: ------------------------------------------------------------------------------------------
1662: PROCEDURE EXTR_INTL_TEXT(inRun_ID IN PLS_INTEGER,
1663: nOrg_ID IN NUMBER,

Line 1852: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

1848: end if;
1849:
1850: COMMIT;
1851: EXCEPTION
1852: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1853: RAISE;
1854: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1855: RAISE;
1856: WHEN OTHERS THEN

Line 1854: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

1850: COMMIT;
1851: EXCEPTION
1852: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1853: RAISE;
1854: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1855: RAISE;
1856: WHEN OTHERS THEN
1857: IF(c_data%ISOPEN)THEN CLOSE c_data; END IF;
1858: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 1860: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

1856: WHEN OTHERS THEN
1857: IF(c_data%ISOPEN)THEN CLOSE c_data; END IF;
1858: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1859: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.EXTR_INTL_TEXT',11276,inRun_Id);
1860: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1861: END;
1862: ------------------------------------------------------------------------------------------
1863: PROCEDURE EXTR_DEVL_PROJECT(inRun_ID IN PLS_INTEGER,
1864: nOrg_ID IN NUMBER,

Line 1984: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

1980:
1981: COMMIT;
1982:
1983: EXCEPTION
1984: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1985: RAISE;
1986: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1987: RAISE;
1988: WHEN OTHERS THEN

Line 1986: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

1982:
1983: EXCEPTION
1984: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1985: RAISE;
1986: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1987: RAISE;
1988: WHEN OTHERS THEN
1989: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1990: xERROR:=cz_utils.log_report(d_str,1,'EXTR_DEVL_PROJECT',11276,inRun_Id);

Line 1991: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

1987: RAISE;
1988: WHEN OTHERS THEN
1989: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1990: xERROR:=cz_utils.log_report(d_str,1,'EXTR_DEVL_PROJECT',11276,inRun_Id);
1991: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1992: END;
1993: ------------------------------------------------------------------------------------------
1994: PROCEDURE EXTR_ITEM_TYPES(inRun_ID IN PLS_INTEGER,
1995: nOrg_ID IN NUMBER,

Line 2048: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

2044:
2045: EXCEPTION
2046: WHEN NO_DATA_FOUND THEN
2047: NULL;
2048: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2049: RAISE;
2050: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
2051: RAISE;
2052: WHEN OTHERS THEN

Line 2050: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

2046: WHEN NO_DATA_FOUND THEN
2047: NULL;
2048: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2049: RAISE;
2050: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
2051: RAISE;
2052: WHEN OTHERS THEN
2053: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
2054: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_TYPES',11276,inRun_Id);

Line 2055: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

2051: RAISE;
2052: WHEN OTHERS THEN
2053: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
2054: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_TYPES',11276,inRun_Id);
2055: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2056: END;
2057: ------------------------------------------------------------------------------------------
2058:
2059: FUNCTION get_Col_Num(p_col_name IN VARCHAR2,p_col_tbl IN OUT NOCOPY rec_cols_tbl) RETURN NUMBER IS

Line 2815: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

2811: end if;
2812: EXCEPTION
2813: WHEN NO_DATA_FOUND THEN
2814: NULL;
2815: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2816: RAISE;
2817: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
2818: RAISE;
2819: WHEN OTHERS THEN

Line 2817: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

2813: WHEN NO_DATA_FOUND THEN
2814: NULL;
2815: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2816: RAISE;
2817: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
2818: RAISE;
2819: WHEN OTHERS THEN
2820: IF(c_datatype%ISOPEN)THEN CLOSE c_datatype; END IF;
2821: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 2823: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

2819: WHEN OTHERS THEN
2820: IF(c_datatype%ISOPEN)THEN CLOSE c_datatype; END IF;
2821: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
2822: xERROR:=cz_utils.log_report(d_str,1,'EXTR_PROPERTIES',11276,inRun_Id);
2823: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2824: END;
2825: ------------------------------------------------------------------------------------------
2826: PROCEDURE EXTR_ITEM_TYPE_PROPERTIES(inRun_ID IN PLS_INTEGER,
2827: nOrg_ID IN NUMBER,

Line 2865: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

2861:
2862: EXCEPTION
2863: WHEN NO_DATA_FOUND THEN
2864: NULL;
2865: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2866: RAISE;
2867: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
2868: RAISE;
2869: WHEN OTHERS THEN

Line 2867: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

2863: WHEN NO_DATA_FOUND THEN
2864: NULL;
2865: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2866: RAISE;
2867: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
2868: RAISE;
2869: WHEN OTHERS THEN
2870: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
2871: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_TYPE_PROPERTIES',11276,inRun_Id);

Line 2872: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

2868: RAISE;
2869: WHEN OTHERS THEN
2870: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
2871: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_TYPE_PROPERTIES',11276,inRun_Id);
2872: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2873: END;
2874: ------------------------------------------------------------------------------------------
2875: PROCEDURE EXTR_ITEM_PROPERTY_VALUES(inRun_ID IN PLS_INTEGER,
2876: nOrg_ID IN NUMBER,

Line 2919: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

2915: end if;
2916:
2917: COMMIT;
2918: EXCEPTION
2919: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2920: RAISE;
2921: WHEN NO_DATA_FOUND THEN
2922: NULL;
2923: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

Line 2923: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

2919: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2920: RAISE;
2921: WHEN NO_DATA_FOUND THEN
2922: NULL;
2923: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
2924: RAISE;
2925: WHEN OTHERS THEN
2926: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
2927: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_PROPERTY_VALUES',11276,inRun_Id);

Line 2928: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

2924: RAISE;
2925: WHEN OTHERS THEN
2926: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
2927: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_PROPERTY_VALUES',11276,inRun_Id);
2928: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2929: END;
2930: ------------------------------------------------------------------------------------------
2931: PROCEDURE extract_table(inRun_ID IN PLS_INTEGER,
2932: table_name IN VARCHAR2,

Line 3191: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

3187: ELSE
3188: RETURN TRUE;
3189: END IF;
3190: EXCEPTION
3191: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3192: RAISE;
3193: WHEN OTHERS THEN
3194: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3195: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.GET_REMOTE_IMPORT',11276);

Line 3196: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3192: RAISE;
3193: WHEN OTHERS THEN
3194: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3195: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.GET_REMOTE_IMPORT',11276);
3196: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3197: END GET_REMOTE_IMPORT;
3198: ------------------------------------------------------------------------------------------
3199: FUNCTION isAppsVersion11i(fndLinkName IN VARCHAR2)
3200: RETURN BOOLEAN

Line 3224: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

3220: return false;
3221: END IF;
3222:
3223: EXCEPTION
3224: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3225: RAISE;
3226: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3227: RAISE;
3228: WHEN OTHERS THEN

Line 3226: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

3222:
3223: EXCEPTION
3224: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3225: RAISE;
3226: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3227: RAISE;
3228: WHEN OTHERS THEN
3229: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3230: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.isAppsVersion11i',11276);

Line 3231: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3227: RAISE;
3228: WHEN OTHERS THEN
3229: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3230: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.isAppsVersion11i',11276);
3231: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3232: END;
3233:
3234: ------------------------------------------------------------------------------------------
3235: FUNCTION ExtractPsNode(inRunId IN NUMBER,

Line 3353: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3349: --xModelId := -1;
3350: xModelId := NULL;
3351: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3352: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.ImpEnabledChk',11276,inRunId);
3353: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3354: END getImpEnabledModelId;
3355:
3356: -------------
3357: PROCEDURE checkImpEnabled (inDevlPrjOSR IN VARCHAR2,

Line 3616: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3612:
3613: -- 14544881
3614: d_str := 'Error retrieveing reference_id: ' || SQLERRM ;
3615: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.RECURSION',11276,inRunId);
3616: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3617: END;
3618: --DBMS_OUTPUT.PUT_LINE('lInvItemId=' || lInvItemId || ' lCompCode=' || lCompCode || ' nImpEnabledModelId=' || nImpEnabledModelId);
3619: lDevlPrjOSR := lExplType || ':' || lOrgId || ':' || lInvItemId ;
3620: checkImpEnabled(lDevlPrjOSR, lInvItemId, inRunId, l_curr_ref_id,nImpEnabledModelId, nModelId);

Line 3625: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

3621:
3622: EXCEPTION
3623: WHEN IMP_MODEL_NOT_ENABLED THEN
3624: RAISE ;
3625: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3626: RAISE;
3627: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3628: RAISE;
3629: WHEN OTHERS THEN

Line 3627: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

3623: WHEN IMP_MODEL_NOT_ENABLED THEN
3624: RAISE ;
3625: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3626: RAISE;
3627: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3628: RAISE;
3629: WHEN OTHERS THEN
3630: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3631: d_str:= d_str || ' Current info:' || inOrgId || ':'|| nTopItemId;

Line 3633: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3629: WHEN OTHERS THEN
3630: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3631: d_str:= d_str || ' Current info:' || inOrgId || ':'|| nTopItemId;
3632: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.RECURSION',11276,inRunId);
3633: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3634: END;
3635: END LOOP;
3636: CLOSE c_ref;
3637: END IF;

Line 3698: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

3694: WHEN IMP_CHILD_MULTI_COPIES THEN --LA 9595142
3695: RAISE;
3696: WHEN IMP_MODEL_NOT_ENABLED THEN --LA 9595142
3697: RAISE ;
3698: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3699: RAISE;
3700: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3701: RAISE;
3702: WHEN OTHERS THEN

Line 3700: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

3696: WHEN IMP_MODEL_NOT_ENABLED THEN --LA 9595142
3697: RAISE ;
3698: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3699: RAISE;
3700: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3701: RAISE;
3702: WHEN OTHERS THEN
3703: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3704: d_str:= d_str || ' Current info:' || inOrgId || ':'|| nTopItemId;

Line 3706: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3702: WHEN OTHERS THEN
3703: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3704: d_str:= d_str || ' Current info:' || inOrgId || ':'|| nTopItemId;
3705: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.RECURSION',11276);
3706: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3707: END;
3708: END LOOP;
3709: CLOSE c_expl;
3710:

Line 3718: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

3714: WHEN IMP_CHILD_MULTI_COPIES THEN --LA 9595142
3715: RAISE;
3716: WHEN IMP_MODEL_NOT_ENABLED THEN --LA 9595142
3717: RAISE ;
3718: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3719: RAISE;
3720: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3721: RAISE;
3722: WHEN OTHERS THEN

Line 3720: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

3716: WHEN IMP_MODEL_NOT_ENABLED THEN --LA 9595142
3717: RAISE ;
3718: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3719: RAISE;
3720: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3721: RAISE;
3722: WHEN OTHERS THEN
3723: IF(c_ref%ISOPEN)THEN CLOSE c_ref; END IF;
3724: IF(c_expl%ISOPEN)THEN CLOSE c_expl; END IF;

Line 3727: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3723: IF(c_ref%ISOPEN)THEN CLOSE c_ref; END IF;
3724: IF(c_expl%ISOPEN)THEN CLOSE c_expl; END IF;
3725: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3726: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode',11276,inRunId);
3727: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3728: END;
3729: ------------------------------------------------------------------------------------------
3730: PROCEDURE ImportSingleBill(nOrg_ID IN NUMBER,nTop_ID IN NUMBER,
3731: COPY_CHILD_MODELS IN VARCHAR2,

Line 3827: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;

3823: SELECT NVL(config_engine_type,'L') INTO g_CONFIG_ENGINE_TYPE FROM CZ_DEVL_PROJECTS
3824: WHERE devl_project_id=REFRESH_MODEL_ID;
3825: END IF;
3826:
3827: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;
3828: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');
3829:
3830: BEGIN
3831: SELECT server_local_id INTO server_id

Line 3837: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;

3833: WHERE import_enabled = v_enabled;
3834: EXCEPTION
3835: WHEN TOO_MANY_ROWS THEN
3836: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3837: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;
3838: WHEN NO_DATA_FOUND THEN
3839: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_NO_IMP_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3840: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;
3841: END;

Line 3840: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;

3836: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3837: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;
3838: WHEN NO_DATA_FOUND THEN
3839: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_NO_IMP_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3840: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;
3841: END;
3842:
3843: IF(server_id > 0)THEN
3844: IF(CZ_UTILS.check_installed_lang(server_id) <> 0)THEN

Line 3846: RAISE CZ_ADMIN.CZ_LANGUAGES_DO_NOT_MATCH;

3842:
3843: IF(server_id > 0)THEN
3844: IF(CZ_UTILS.check_installed_lang(server_id) <> 0)THEN
3845: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_LANGUAGES_DO_NOT_MATCH'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3846: RAISE CZ_ADMIN.CZ_LANGUAGES_DO_NOT_MATCH;
3847: END IF;
3848: END IF;
3849:
3850: --Determines whether unchanged child models should be refreshed during this run, default - YES.

Line 3918: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

3914: EXCEPTION
3915: WHEN OTHERS THEN
3916: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3917: xERROR:=cz_utils.log_report(d_str,1,'SINGLEBILL:CZ_XFR_RUN_INFOS',11276,genRun_ID);
3918: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3919: END;
3920: COMMIT;
3921:
3922: ----1) Run the BOM EXPLODER for the specified bills which are not deleted

Line 4064: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

4060: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
4061: COMMIT;
4062: DBMS_APPLICATION_INFO.SET_MODULE('','');
4063: RAISE;
4064: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
4065: IF C_BILL_OF_MATERIAL%ISOPEN THEN CLOSE C_BILL_OF_MATERIAL; END IF;
4066: processed_expls_tbl.DELETE;
4067: --LA 9595142
4068: import_enabled_tbl.DELETE;

Line 4070: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

4066: processed_expls_tbl.DELETE;
4067: --LA 9595142
4068: import_enabled_tbl.DELETE;
4069: RAISE;
4070: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
4071: RAISE;
4072: --LA 9595142
4073: WHEN IMP_CHILD_MULTI_COPIES THEN
4074: IF C_BILL_OF_MATERIAL%ISOPEN THEN CLOSE C_BILL_OF_MATERIAL; END IF;

Line 4092: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

4088: --LA 9595142
4089: import_enabled_tbl.DELETE;
4090: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
4091: xERROR:=cz_utils.log_report(d_str,1,'EXTRACT_PS_NODE',11299,genRun_ID);
4092: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
4093: END;
4094:
4095: -------Create the table of all relevant item catalog group ids which will be used for extraction of property related data.
4096:

Line 4186: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

4182:
4183: extract_table(genRun_ID, sTableName, nOrg_ID, nTop_ID, sExpl_type, nModelId);
4184:
4185: EXCEPTION
4186: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
4187: RAISE;
4188: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
4189: RAISE;
4190: WHEN NO_DATA_FOUND THEN

Line 4188: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

4184:
4185: EXCEPTION
4186: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
4187: RAISE;
4188: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
4189: RAISE;
4190: WHEN NO_DATA_FOUND THEN
4191: xERROR:=cz_utils.log_report(sTableName||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.extract_table',11276,genRun_ID);
4192: WHEN OTHERS THEN

Line 4195: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

4191: xERROR:=cz_utils.log_report(sTableName||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.extract_table',11276,genRun_ID);
4192: WHEN OTHERS THEN
4193: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
4194: xERROR:=cz_utils.log_report(d_str,1,'SINGLEBILL:EXTRACTION',11276,genRun_ID);
4195: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
4196: END;
4197: END LOOP;
4198: CLOSE C_EXTRACTION_ORDER;
4199:

Line 4219: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

4215: FETCH C_IMPORT_ORDER INTO sTableName;
4216: EXIT WHEN C_IMPORT_ORDER%NOTFOUND;
4217: populate_table(genRun_ID, sTableName, nCommit_size, nMax_err, 'IMPORT', CZ_IMP_SINGLE.RP_ROOT_FOLDER, l_failed);
4218: EXCEPTION
4219: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
4220: RAISE;
4221: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
4222: RAISE;
4223: WHEN NO_DATA_FOUND THEN

Line 4221: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

4217: populate_table(genRun_ID, sTableName, nCommit_size, nMax_err, 'IMPORT', CZ_IMP_SINGLE.RP_ROOT_FOLDER, l_failed);
4218: EXCEPTION
4219: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
4220: RAISE;
4221: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
4222: RAISE;
4223: WHEN NO_DATA_FOUND THEN
4224: xERROR:=cz_utils.log_report(sTableName||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.populate_table',11276,genRun_ID);
4225: WHEN OTHERS THEN

Line 4228: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

4224: xERROR:=cz_utils.log_report(sTableName||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.populate_table',11276,genRun_ID);
4225: WHEN OTHERS THEN
4226: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
4227: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.GO.IMPORT',11276,genRun_ID);
4228: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
4229: END;
4230: END LOOP;
4231: CLOSE C_IMPORT_ORDER;
4232:

Line 4360: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN

4356: xERROR:=cz_utils.log_report(nModelId||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.UNLOCK',11276,genRun_ID);
4357: END;
4358: END IF;
4359: EXCEPTION
4360: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
4361: RAISE;
4362: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
4363: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'SINGLEBILL.GENERAL',11276,genRun_ID);
4364: DBMS_APPLICATION_INFO.SET_MODULE('','');

Line 4362: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

4358: END IF;
4359: EXCEPTION
4360: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
4361: RAISE;
4362: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
4363: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'SINGLEBILL.GENERAL',11276,genRun_ID);
4364: DBMS_APPLICATION_INFO.SET_MODULE('','');
4365: RAISE;
4366: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

Line 4366: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN

4362: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
4363: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'SINGLEBILL.GENERAL',11276,genRun_ID);
4364: DBMS_APPLICATION_INFO.SET_MODULE('','');
4365: RAISE;
4366: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
4367: RAISE;
4368: WHEN NO_DATA_FOUND THEN
4369: xERROR:=cz_utils.log_report(SQLERRM,1,'SINGLEBILL.GENERAL',11276,genRun_ID);
4370: WHEN OTHERS THEN

Line 4388: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

4384: END IF;
4385: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
4386: xERROR:=cz_utils.log_report(d_str,1,'SINGLEBILL.GENERAL',11276,genRun_ID);
4387: DBMS_APPLICATION_INFO.SET_MODULE('','');
4388: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
4389: END ImportSingleBill;
4390: ------------------------------------------------------------------------------------------
4391:
4392: END CZ_IMP_SINGLE;