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_UTILS

Line 229: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_id);

225:
226: if (CZ_IMP_ALL.get_time) then
227: end_time := dbms_utility.get_time();
228: d_str := inRun_Id || ' Bulk collect item master (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
229: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_id);
230: end if;
231:
232: FOR i IN 1..InventoryItemId.COUNT LOOP
233:

Line 315: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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);
317: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
318: END;
319: ------------------------------------------------------------------------------------------

Line 316: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_MASTER',11276,inRun_Id);

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);
317: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
318: END;
319: ------------------------------------------------------------------------------------------
320:

Line 565: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS', 'IMPORT');

561:
562: -- end of changes for TSO --
563:
564: n_SortWidth NUMBER := cz_imp_ps_node.n_SortWidth;
565: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS', 'IMPORT');
566: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_LOCALIZED_TEXTS', 'IMPORT');
567: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES', 'IMPORT');
568: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS', 'IMPORT');
569: x_error BOOLEAN:=FALSE;

Line 566: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_LOCALIZED_TEXTS', 'IMPORT');

562: -- end of changes for TSO --
563:
564: n_SortWidth NUMBER := cz_imp_ps_node.n_SortWidth;
565: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS', 'IMPORT');
566: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_LOCALIZED_TEXTS', 'IMPORT');
567: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES', 'IMPORT');
568: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS', 'IMPORT');
569: x_error BOOLEAN:=FALSE;
570:

Line 567: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES', 'IMPORT');

563:
564: n_SortWidth NUMBER := cz_imp_ps_node.n_SortWidth;
565: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS', 'IMPORT');
566: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_LOCALIZED_TEXTS', 'IMPORT');
567: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES', 'IMPORT');
568: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS', 'IMPORT');
569: x_error BOOLEAN:=FALSE;
570:
571: ComponentSequenceId tComponentSequenceId;

Line 568: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS', 'IMPORT');

564: n_SortWidth NUMBER := cz_imp_ps_node.n_SortWidth;
565: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS', 'IMPORT');
566: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_LOCALIZED_TEXTS', 'IMPORT');
567: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES', 'IMPORT');
568: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS', 'IMPORT');
569: x_error BOOLEAN:=FALSE;
570:
571: ComponentSequenceId tComponentSequenceId;
572: ComponentCode tComponentCode;

Line 869: x_error:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_BOM_NO_DATA'),1,'CZ_IMP_SINGLE.EXTR_PS_NODE',11276,inRun_Id);

865:
866: IF(ComponentItemId.COUNT = 0)THEN
867: IF(startFlag)THEN
868: --'No BOM data to extract. Verify that the bill you want to import exists on the import-enabled server.'
869: x_error:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_BOM_NO_DATA'),1,'CZ_IMP_SINGLE.EXTR_PS_NODE',11276,inRun_Id);
870: RETURN;
871: ELSE
872: EXIT;
873: END IF;

Line 879: x_ERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

875:
876: if (CZ_IMP_ALL.get_time) then
877: end_time := dbms_utility.get_time();
878: d_str := inRun_Id || ' Extract ps structure (' || nTop_Id || ' - count - ' || componentItemId.COUNT || ' ) :' || (end_time-st_time)/100.00;
879: x_ERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
880: end if;
881:
882: if (CZ_IMP_ALL.get_time) then
883: st_time := dbms_utility.get_time();

Line 891: IF(EffectivityDate(i) < cz_utils.EPOCH_BEGIN_)THEN EffectivityDate(i) := cz_utils.EPOCH_BEGIN_; END IF;

887: FOR i IN ComponentItemId.FIRST..ComponentItemId.LAST LOOP
888:
889: --Need to account for bug #1710684.
890:
891: IF(EffectivityDate(i) < cz_utils.EPOCH_BEGIN_)THEN EffectivityDate(i) := cz_utils.EPOCH_BEGIN_; END IF;
892: IF(DisableDate(i) > cz_utils.EPOCH_END_)THEN DisableDate(i) := cz_utils.EPOCH_END_; END IF;
893:
894: IF(PlanLevel(i) = 0)THEN
895: nStack := 1;

Line 892: IF(DisableDate(i) > cz_utils.EPOCH_END_)THEN DisableDate(i) := cz_utils.EPOCH_END_; END IF;

888:
889: --Need to account for bug #1710684.
890:
891: IF(EffectivityDate(i) < cz_utils.EPOCH_BEGIN_)THEN EffectivityDate(i) := cz_utils.EPOCH_BEGIN_; END IF;
892: IF(DisableDate(i) > cz_utils.EPOCH_END_)THEN DisableDate(i) := cz_utils.EPOCH_END_; END IF;
893:
894: IF(PlanLevel(i) = 0)THEN
895: nStack := 1;
896: StackComponentCode(nStack) := ComponentCode(i);

Line 1273: iEffectiveFrom(nIndex) := CZ_UTILS.EPOCH_BEGIN;

1269: iLastUpdateDate(nIndex) := LastUpdateDate(i);
1270: iLastUpdatedBy(nIndex) := LastUpdatedBy(i);
1271:
1272: IF(BomItemType(i) = cnModel)THEN
1273: iEffectiveFrom(nIndex) := CZ_UTILS.EPOCH_BEGIN;
1274: iEffectiveUntil(nIndex) := CZ_UTILS.EPOCH_END;
1275: iComponentSequenceId(nIndex) := NULL;
1276: ELSE
1277: iEffectiveFrom(nIndex) := EffectivityDate(i);

Line 1274: iEffectiveUntil(nIndex) := CZ_UTILS.EPOCH_END;

1270: iLastUpdatedBy(nIndex) := LastUpdatedBy(i);
1271:
1272: IF(BomItemType(i) = cnModel)THEN
1273: iEffectiveFrom(nIndex) := CZ_UTILS.EPOCH_BEGIN;
1274: iEffectiveUntil(nIndex) := CZ_UTILS.EPOCH_END;
1275: iComponentSequenceId(nIndex) := NULL;
1276: ELSE
1277: iEffectiveFrom(nIndex) := EffectivityDate(i);
1278: iEffectiveUntil(nIndex) := DisableDate(i);

Line 1348: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

1344:
1345: if (CZ_IMP_ALL.get_time) then
1346: end_time := dbms_utility.get_time();
1347: d_str := inRun_Id || ' loop ps structure (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1348: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1349: end if;
1350:
1351: if (CZ_IMP_ALL.get_time) then
1352: st_time := dbms_utility.get_time();

Line 1427: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

1423:
1424: if (CZ_IMP_ALL.get_time) then
1425: end_time := dbms_utility.get_time();
1426: d_str := inRun_Id || ' Insert ps nodes (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1427: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1428: end if;
1429:
1430: -- 9496782
1431: czGatherStatsCnt := czGatherStatsCnt + iOrigSysRef.COUNT ;

Line 1476: x_error:=cz_utils.log_report('Gather Stats : Start' ,1,'EXTRACTION',11299,inRun_Id);

1472: -- uncomment following line to replace existing IF condition with new one.
1473: --IF (czGatherStatsCnt > v_batchSize OR inPlanLevel = 0) THEN
1474: IF (czGatherStatsCnt > v_batchSize) THEN
1475: czGatherStatsCnt := 0;
1476: x_error:=cz_utils.log_report('Gather Stats : Start' ,1,'EXTRACTION',11299,inRun_Id);
1477: fnd_stats.gather_table_stats('CZ', 'CZ_IMP_PS_NODES');
1478: --bug 9496782 comment out following call
1479: -- fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');
1480: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');

Line 1481: x_error:=cz_utils.log_report('Gather Stats : End',1,'EXTRACTION',11299,inRun_Id);

1477: fnd_stats.gather_table_stats('CZ', 'CZ_IMP_PS_NODES');
1478: --bug 9496782 comment out following call
1479: -- fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');
1480: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');
1481: x_error:=cz_utils.log_report('Gather Stats : End',1,'EXTRACTION',11299,inRun_Id);
1482:
1483: if (CZ_IMP_ALL.get_time) then
1484: end_time := dbms_utility.get_time();
1485: d_str := inRun_Id || ' Gather Stats :' || (end_time-st_time)/100.00;

Line 1486: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

1482:
1483: if (CZ_IMP_ALL.get_time) then
1484: end_time := dbms_utility.get_time();
1485: d_str := inRun_Id || ' Gather Stats :' || (end_time-st_time)/100.00;
1486: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1487: end if;
1488: END IF;
1489: END IF;
1490:

Line 1532: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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);
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:

Line 1533: x_error:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.maximum_selected',11276,inRun_Id);

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);
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: ------------------------------------------------------------------------------

Line 1625: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

1621:
1622: if (CZ_IMP_ALL.get_time) then
1623: end_time := dbms_utility.get_time();
1624: d_str := inRun_Id || ' Deleted ps node check (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1625: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1626: end if;
1627:
1628: CLOSE c_onl_ps_node;
1629: COMMIT;

Line 1634: d_str := CZ_UTILS.GET_TEXT('CZ_IMP_CZREFS_DELNODE', 'MSG', d_str);

1630:
1631: EXCEPTION
1632: WHEN CZ_REFS_DELNODE_EXCP THEN
1633: IF d_str IS NULL THEN d_str := 'NO MESSAGE FOUND'; END IF;
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

Line 1635: x_error :=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.EXTR_PS_NODE: delete obsolete nodes',11276,inRun_Id);

1631: EXCEPTION
1632: WHEN CZ_REFS_DELNODE_EXCP THEN
1633: IF d_str IS NULL THEN d_str := 'NO MESSAGE FOUND'; END IF;
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;

Line 1644: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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);
1646: ROLLBACK;
1647: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1648: END;

Line 1645: x_error:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.EXTR_PS_NODE: delete obsolete nodes',11276,inRun_Id);

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);
1646: ROLLBACK;
1647: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1648: END;
1649:

Line 1657: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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);
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: ------------------------------------------------------------------------------------------

Line 1658: x_error:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.EXTR_PS_NODE',11276,inRun_Id);

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);
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,

Line 1847: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

1843:
1844: if (CZ_IMP_ALL.get_time) then
1845: end_time := dbms_utility.get_time();
1846: d_str := inRun_Id || ' Extract text (' || nTop_Id || ' - Count - ' || iLocalizedStr.COUNT || ') :' || (end_time-st_time)/100.00;
1847: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1848: end if;
1849:
1850: COMMIT;
1851: EXCEPTION

Line 1858: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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);
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: ------------------------------------------------------------------------------------------

Line 1859: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.EXTR_INTL_TEXT',11276,inRun_Id);

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);
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,

Line 1933: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

1929:
1930: if (CZ_IMP_ALL.get_time) then
1931: end_time := dbms_utility.get_time();
1932: d_str := inRun_Id || ' Extract projects (' || nTop_Id || ' - Count - ' || OrganizationId.COUNT || ') :' || (end_time-st_time)/100.00;
1933: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1934: end if;
1935:
1936: FOR i IN 1..OrganizationId.COUNT LOOP
1937:

Line 1962: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

1958:
1959: if (CZ_IMP_ALL.get_time) then
1960: loop_end_time := dbms_utility.get_time();
1961: d_str := inRun_Id || ' Loop Projects (' || nTop_Id || ') :' || (loop_end_time-end_time)/100.00;
1962: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1963: end if;
1964:
1965: FORALL i IN 1..iOrigSysRef.COUNT
1966: INSERT INTO CZ_IMP_DEVL_PROJECT

Line 1978: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

1974:
1975: if (CZ_IMP_ALL.get_time) then
1976: insert_end_time := dbms_utility.get_time();
1977: d_str := inRun_Id || ' Insert projects (' || nTop_Id || ') :' || (insert_end_time-loop_end_time)/100.00;
1978: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1979: end if;
1980:
1981: COMMIT;
1982:

Line 1989: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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);
1991: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1992: END;
1993: ------------------------------------------------------------------------------------------

Line 1990: xERROR:=cz_utils.log_report(d_str,1,'EXTR_DEVL_PROJECT',11276,inRun_Id);

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);
1991: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1992: END;
1993: ------------------------------------------------------------------------------------------
1994: PROCEDURE EXTR_ITEM_TYPES(inRun_ID IN PLS_INTEGER,

Line 2041: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

2037:
2038: if (CZ_IMP_ALL.get_time) then
2039: end_time := dbms_utility.get_time();
2040: d_str := inRun_Id || ' Insert item type (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2041: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2042: end if;
2043: COMMIT;
2044:
2045: EXCEPTION

Line 2053: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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);
2055: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2056: END;
2057: ------------------------------------------------------------------------------------------

Line 2054: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_TYPES',11276,inRun_Id);

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);
2055: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2056: END;
2057: ------------------------------------------------------------------------------------------
2058:

Line 2171: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,

2167: BEGIN
2168:
2169: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2170: l_ndebug := 0;
2171: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2172: 'EXTR_APC_PROPERTIES is called ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') :',
2173: fnd_log.LEVEL_STATEMENT);
2174: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2175: 'parameters : RUN_ID='||TO_CHAR(p_run_id)||',p_org_id='||TO_CHAR(p_org_id)||

Line 2174: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,

2170: l_ndebug := 0;
2171: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2172: 'EXTR_APC_PROPERTIES is called ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') :',
2173: fnd_log.LEVEL_STATEMENT);
2174: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2175: 'parameters : RUN_ID='||TO_CHAR(p_run_id)||',p_org_id='||TO_CHAR(p_org_id)||
2176: ', p_top_item_id='||TO_CHAR(p_top_item_id)||',p_expl_type='||p_expl_type ,
2177: fnd_log.LEVEL_STATEMENT);
2178: END IF;

Line 2290: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,

2286: RETURN;
2287: END IF;
2288:
2289: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2290: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2291: 'APC meta data have been retrieved ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2292: fnd_log.LEVEL_STATEMENT);
2293: END IF;
2294:

Line 2345: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,

2341:
2342: COMMIT;
2343:
2344: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2345: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2346: 'CZ_IMP_PROPERTY has been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2347: fnd_log.LEVEL_STATEMENT);
2348: END IF;
2349:

Line 2396: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,

2392: END IF;
2393: END LOOP;
2394:
2395: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2396: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2397: 'CZ_IMP_ITEM_TYPE_PROPERTY has been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2398: fnd_log.LEVEL_STATEMENT);
2399: END IF;
2400:

Line 2464: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,

2460: l_db_columns_tbl.DELETE;
2461: l_db_column_types_tbl.DELETE;
2462:
2463: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2464: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2465: 'Internal arrays have been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2466: fnd_log.LEVEL_STATEMENT);
2467: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2468: 'Retrieving of APC property values will be started ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',

Line 2467: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,

2463: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2464: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2465: 'Internal arrays have been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2466: fnd_log.LEVEL_STATEMENT);
2467: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2468: 'Retrieving of APC property values will be started ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2469: fnd_log.LEVEL_STATEMENT);
2470: END IF;
2471:

Line 2655: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,

2651: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;
2652: COMMIT;
2653:
2654: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2655: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2656: 'CZ_IMP_ITEM_PROPERTY_VALUE has been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2657: fnd_log.LEVEL_STATEMENT);
2658: END IF;
2659:

Line 2664: l_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'EXTR_APC_PROPERTIES',11276,p_run_id);

2660: EXCEPTION
2661: WHEN OTHERS THEN
2662: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;
2663: COMMIT;
2664: l_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'EXTR_APC_PROPERTIES',11276,p_run_id);
2665: RAISE;
2666: END EXTR_APC_PROPERTIES;
2667:
2668: ------------------------------------------------------------------------------------------

Line 2717: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

2713:
2714: if (CZ_IMP_ALL.get_time) then
2715: end_time := dbms_utility.get_time();
2716: d_str := inRun_Id || ' Insert property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2717: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2718: end if;
2719:
2720: COMMIT;
2721:

Line 2810: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

2806: CLOSE C_DATATYPE;
2807: if (CZ_IMP_ALL.get_time) then
2808: loop_end_time := dbms_utility.get_time();
2809: d_str := inRun_Id || ' Resolve property datatype (' || nTop_Id || ') :' || (loop_end_time-end_time)/100.00;
2810: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2811: end if;
2812: EXCEPTION
2813: WHEN NO_DATA_FOUND THEN
2814: NULL;

Line 2821: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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);
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: ------------------------------------------------------------------------------------------

Line 2822: xERROR:=cz_utils.log_report(d_str,1,'EXTR_PROPERTIES',11276,inRun_Id);

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);
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,

Line 2857: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

2853:
2854: if (CZ_IMP_ALL.get_time) then
2855: end_time := dbms_utility.get_time();
2856: d_str := inRun_Id || ' Insert item Type prop (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2857: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2858: end if;
2859:
2860: COMMIT;
2861:

Line 2870: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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);
2872: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2873: END;
2874: ------------------------------------------------------------------------------------------

Line 2871: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_TYPE_PROPERTIES',11276,inRun_Id);

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);
2872: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2873: END;
2874: ------------------------------------------------------------------------------------------
2875: PROCEDURE EXTR_ITEM_PROPERTY_VALUES(inRun_ID IN PLS_INTEGER,

Line 2914: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

2910:
2911: if (CZ_IMP_ALL.get_time) then
2912: loop_end_time := dbms_utility.get_time();
2913: d_str := inRun_Id || ' Bulk collect prop val (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2914: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2915: end if;
2916:
2917: COMMIT;
2918: EXCEPTION

Line 2926: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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);
2928: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2929: END;
2930: ------------------------------------------------------------------------------------------

Line 2927: xERROR:=cz_utils.log_report(d_str,1,'EXTR_ITEM_PROPERTY_VALUES',11276,inRun_Id);

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);
2928: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2929: END;
2930: ------------------------------------------------------------------------------------------
2931: PROCEDURE extract_table(inRun_ID IN PLS_INTEGER,

Line 2954: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

2950: EXTR_ITEM_MASTER(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2951: if (CZ_IMP_ALL.get_time) then
2952: end_time := dbms_utility.get_time();
2953: d_str := inRun_Id || ' Extract item master (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2954: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2955: end if;
2956: ELSIF(lower_table_name='cz_ps_nodes') THEN
2957: if (CZ_IMP_ALL.get_time) then
2958: st_time := dbms_utility.get_time();

Line 2964: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

2960: EXTR_PS_NODE(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2961: if (CZ_IMP_ALL.get_time) then
2962: end_time := dbms_utility.get_time();
2963: d_str :=inRun_Id || ' Extract ps structure (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2964: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2965: end if;
2966: ELSIF(lower_table_name='cz_localized_texts') THEN
2967: if (CZ_IMP_ALL.get_time) then
2968: st_time := dbms_utility.get_time();

Line 2974: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

2970: EXTR_INTL_TEXT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2971: if (CZ_IMP_ALL.get_time) then
2972: end_time := dbms_utility.get_time();
2973: d_str := inRun_Id || ' Extract intl text (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2974: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2975: end if;
2976: ELSIF(lower_table_name='cz_devl_projects') THEN
2977: if (CZ_IMP_ALL.get_time) then
2978: st_time := dbms_utility.get_time();

Line 2984: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

2980: EXTR_DEVL_PROJECT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2981: if (CZ_IMP_ALL.get_time) then
2982: end_time := dbms_utility.get_time();
2983: d_str := inRun_Id || ' Extract devl project (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2984: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2985: end if;
2986: ELSIF(lower_table_name='cz_item_types') THEN
2987: if (CZ_IMP_ALL.get_time) then
2988: st_time := dbms_utility.get_time();

Line 2994: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

2990: EXTR_ITEM_TYPES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2991: if (CZ_IMP_ALL.get_time) then
2992: end_time := dbms_utility.get_time();
2993: d_str := inRun_Id || ' Extract item types (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2994: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2995: end if;
2996: ELSIF(lower_table_name='cz_properties') THEN
2997: if (CZ_IMP_ALL.get_time) then
2998: st_time := dbms_utility.get_time();

Line 3010: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

3006:
3007: if (CZ_IMP_ALL.get_time) then
3008: end_time := dbms_utility.get_time();
3009: d_str := inRun_Id || ' Extract property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
3010: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
3011: end if;
3012: ELSIF(lower_table_name='cz_item_type_properties') THEN
3013: if (CZ_IMP_ALL.get_time) then
3014: st_time := dbms_utility.get_time();

Line 3020: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

3016: EXTR_ITEM_TYPE_PROPERTIES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
3017: if (CZ_IMP_ALL.get_time) then
3018: end_time := dbms_utility.get_time();
3019: d_str := inRun_Id || ' Extract item type property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
3020: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
3021: end if;
3022: ELSIF(lower_table_name='cz_item_property_values') THEN
3023: if (CZ_IMP_ALL.get_time) then
3024: st_time := dbms_utility.get_time();

Line 3030: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);

3026: EXTR_ITEM_PROPERTY_VALUES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
3027: if (CZ_IMP_ALL.get_time) then
3028: end_time := dbms_utility.get_time();
3029: d_str := inRun_Id || ' Extract item property value (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
3030: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
3031: end if;
3032: ELSE
3033: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_EXTRACT','TABLENAME',table_name));
3034: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_EXTRACT','TABLENAME',table_name),1,'SINGLEBILL.EXTRACT_TABLE',11276,inRun_Id);

Line 3033: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_EXTRACT','TABLENAME',table_name));

3029: d_str := inRun_Id || ' Extract item property value (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
3030: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
3031: end if;
3032: ELSE
3033: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_EXTRACT','TABLENAME',table_name));
3034: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_EXTRACT','TABLENAME',table_name),1,'SINGLEBILL.EXTRACT_TABLE',11276,inRun_Id);
3035: END IF;
3036: END extract_table;
3037: ------------------------------------------------------------------------------------------

Line 3034: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_EXTRACT','TABLENAME',table_name),1,'SINGLEBILL.EXTRACT_TABLE',11276,inRun_Id);

3030: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
3031: end if;
3032: ELSE
3033: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_EXTRACT','TABLENAME',table_name));
3034: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_EXTRACT','TABLENAME',table_name),1,'SINGLEBILL.EXTRACT_TABLE',11276,inRun_Id);
3035: END IF;
3036: END extract_table;
3037: ------------------------------------------------------------------------------------------
3038: PROCEDURE populate_table(inRun_ID IN PLS_INTEGER,

Line 3068: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);

3064: Inserts, Updates, x_failed, Dups,NoChange, inXFR_GROUP);
3065: if (CZ_IMP_ALL.get_time) then
3066: end_time := dbms_utility.get_time();
3067: d_str := inRun_Id || ' Populate items :' || (end_time-st_time)/100.00;
3068: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3069: end if;
3070: ELSIF(lower_table_name='cz_ps_nodes') THEN
3071: if (CZ_IMP_ALL.get_time) then
3072: st_time := dbms_utility.get_time();

Line 3079: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);

3075: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);
3076: if (CZ_IMP_ALL.get_time) then
3077: end_time := dbms_utility.get_time();
3078: d_str := inRun_Id || ' Populate product structure :' || (end_time-st_time)/100.00;
3079: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3080: end if;
3081: ELSIF(lower_table_name='cz_localized_texts') THEN
3082: if (CZ_IMP_ALL.get_time) then
3083: st_time := dbms_utility.get_time();

Line 3090: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);

3086: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);
3087: if (CZ_IMP_ALL.get_time) then
3088: end_time := dbms_utility.get_time();
3089: d_str := inRun_Id || ' Populate intl text :' || (end_time-st_time)/100.00;
3090: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3091: end if;
3092: ELSIF(lower_table_name='cz_devl_projects') THEN
3093: if (CZ_IMP_ALL.get_time) then
3094: st_time := dbms_utility.get_time();

Line 3102: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);

3098: inXFR_GROUP,p_rp_folder_id, g_CONFIG_ENGINE_TYPE);
3099: if (CZ_IMP_ALL.get_time) then
3100: end_time := dbms_utility.get_time();
3101: d_str := inRun_Id || ' Populate project :' || (end_time-st_time)/100.00;
3102: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3103: end if;
3104: ELSIF(lower_table_name='cz_item_property_values') THEN
3105: if (CZ_IMP_ALL.get_time) then
3106: st_time := dbms_utility.get_time();

Line 3113: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);

3109: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);
3110: if (CZ_IMP_ALL.get_time) then
3111: end_time := dbms_utility.get_time();
3112: d_str := inRun_Id || ' Populate item property val :' || (end_time-st_time)/100.00;
3113: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3114: end if;
3115: ELSIF(lower_table_name='cz_item_types') THEN
3116: if (CZ_IMP_ALL.get_time) then
3117: st_time := dbms_utility.get_time();

Line 3124: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);

3120: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);
3121: if (CZ_IMP_ALL.get_time) then
3122: end_time := dbms_utility.get_time();
3123: d_str := inRun_Id || ' Populate item type :' || (end_time-st_time)/100.00;
3124: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3125: end if;
3126: ELSIF(lower_table_name='cz_item_type_properties') THEN
3127: if (CZ_IMP_ALL.get_time) then
3128: st_time := dbms_utility.get_time();

Line 3135: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);

3131: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3132: if (CZ_IMP_ALL.get_time) then
3133: end_time := dbms_utility.get_time();
3134: d_str := inRun_Id || ' Populate item type property :' || (end_time-st_time)/100.00;
3135: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3136: end if;
3137: ELSIF(lower_table_name='cz_properties') THEN
3138: if (CZ_IMP_ALL.get_time) then
3139: st_time := dbms_utility.get_time();

Line 3146: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);

3142: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP, p_rp_folder_id);
3143: if (CZ_IMP_ALL.get_time) then
3144: end_time := dbms_utility.get_time();
3145: d_str := inRun_Id || ' Populate property :' || (end_time-st_time)/100.00;
3146: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3147: end if;
3148: ELSE
3149: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name));
3150: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name),1,'CZ_IMP_SINGLE.POPULATE_TABLE',11276,inRun_Id);

Line 3149: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name));

3145: d_str := inRun_Id || ' Populate property :' || (end_time-st_time)/100.00;
3146: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3147: end if;
3148: ELSE
3149: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name));
3150: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name),1,'CZ_IMP_SINGLE.POPULATE_TABLE',11276,inRun_Id);
3151: END IF;
3152: --DBMS_OUTPUT.PUT_LINE('INSERTS: '||to_char(Inserts));
3153: --DBMS_OUTPUT.PUT_LINE('UPDATES: '||to_char(Updates));

Line 3150: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name),1,'CZ_IMP_SINGLE.POPULATE_TABLE',11276,inRun_Id);

3146: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3147: end if;
3148: ELSE
3149: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name));
3150: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name),1,'CZ_IMP_SINGLE.POPULATE_TABLE',11276,inRun_Id);
3151: END IF;
3152: --DBMS_OUTPUT.PUT_LINE('INSERTS: '||to_char(Inserts));
3153: --DBMS_OUTPUT.PUT_LINE('UPDATES: '||to_char(Updates));
3154: --DBMS_OUTPUT.PUT_LINE('FAILED: '||to_char(x_failed));

Line 3194: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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);
3196: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3197: END GET_REMOTE_IMPORT;
3198: ------------------------------------------------------------------------------------------

Line 3195: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.GET_REMOTE_IMPORT',11276);

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);
3196: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3197: END GET_REMOTE_IMPORT;
3198: ------------------------------------------------------------------------------------------
3199: FUNCTION isAppsVersion11i(fndLinkName IN VARCHAR2)

Line 3229: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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);
3231: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3232: END;
3233:

Line 3230: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.isAppsVersion11i',11276);

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);
3231: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3232: END;
3233:
3234: ------------------------------------------------------------------------------------------

Line 3323: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.ImpEnabledChk',11276,inRunId);

3319: AND object_type = 'PRJ' AND object_id = d.devl_project_id) ;
3320: EXCEPTION
3321: WHEN TOO_MANY_ROWS THEN
3322: d_str:= 'Multiple copies of the model enabled for Import : (' || inDevlPrjOSR || ')' ;
3323: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.ImpEnabledChk',11276,inRunId);
3324: --xModelId := -1;
3325: xModelId := NULL;
3326: RAISE IMP_MODEL_NOT_ENABLED ;
3327: WHEN NO_DATA_FOUND THEN

Line 3342: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.ImpEnabledChk',11276,inRunId);

3338: AND d.devl_project_id = r.object_id;
3339: IF (xModelId > 0) THEN
3340: d_str:= 'Either model does not exist in Repository or not enabled for Import :'
3341: || inDevlPrjOSR ;
3342: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.ImpEnabledChk',11276,inRunId);
3343: --xModelId := -1;
3344: xModelId := NULL;
3345: RAISE IMP_MODEL_NOT_ENABLED ;
3346: END IF;

Line 3351: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

3347: xModelId := NULL;
3348: WHEN OTHERS THEN
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:

Line 3352: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.ImpEnabledChk',11276,inRunId);

3348: WHEN OTHERS THEN
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: -------------

Line 3399: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.checkImpEnabled',11276,inRunId);

3395: ' Expecting ModelId=' || xImpEnabledModelId;
3396:
3397: --DBMS_OUTPUT.PUT_LINE(d_str);
3398:
3399: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.checkImpEnabled',11276,inRunId);
3400: RAISE IMP_MODEL_NOT_ENABLED ;
3401: END IF;
3402:
3403:

Line 3531: xERROR:=cz_utils.log_report(outErr_msg, 1, 'BOM_EXPLODER', 11276,inRunId);

3527: fnd_stats.gather_table_stats('BOM', 'BOM_EXPLOSIONS');
3528: END IF;
3529:
3530: IF(outError_code <> 0)THEN
3531: xERROR:=cz_utils.log_report(outErr_msg, 1, 'BOM_EXPLODER', 11276,inRunId);
3532: CZ_ORAAPPS_INTEGRATE.mRETCODE := 2;
3533: CZ_ORAAPPS_INTEGRATE.mERRBUF := outErr_msg;
3534: RETURN nModelId;
3535: END IF;

Line 3553: outErr_msg := CZ_UTILS.GET_TEXT('CZ_IMP_STALE_EXPLOSION');

3549: AND ROWNUM = 1;
3550:
3551: --If found, explosion is not up-to-date.
3552:
3553: outErr_msg := CZ_UTILS.GET_TEXT('CZ_IMP_STALE_EXPLOSION');
3554: xERROR:=CZ_IMP_ALL.REPORT(outErr_msg, 1, 'BOM_EXPLODER', 11276);
3555: CZ_ORAAPPS_INTEGRATE.mRETCODE := 2;
3556: CZ_ORAAPPS_INTEGRATE.mERRBUF := outErr_msg;
3557: RETURN nModelId;

Line 3571: xERROR:=cz_utils.log_report(d_str,1,'BOM_EXPLODER',11299,inRunId);

3567:
3568: if (CZ_IMP_ALL.get_time) then
3569: bom_explode_end := dbms_utility.get_time();
3570: d_str := inRunId || ' Bom Exploder (' || inTopId || ') :' || (bom_explode_end-bom_explode_st)/100.00;
3571: xERROR:=cz_utils.log_report(d_str,1,'BOM_EXPLODER',11299,inRunId);
3572: end if;
3573:
3574: extract_table(inRunId, 'CZ_PS_NODES', inOrgId, inTopId, inExplType, nModelId);
3575:

Line 3615: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.RECURSION',11276,inRunId);

3611: --DBMS_OUTPUT.PUT_LINE('.....nModelId = ' || nModelId || ' and CompCode=' || lCompCode );
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 ;

Line 3630: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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;
3632: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.RECURSION',11276,inRunId);
3633: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3634: END;

Line 3632: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.RECURSION',11276,inRunId);

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;
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;

Line 3703: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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;
3705: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.RECURSION',11276);
3706: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3707: END;

Line 3705: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode.RECURSION',11276);

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;
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;

Line 3725: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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;
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: ------------------------------------------------------------------------------------------

Line 3726: xERROR:=cz_utils.log_report(d_str,1,'ExtractPsNode',11276,inRunId);

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;
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,

Line 3836: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);

3832: FROM cz_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;

Line 3839: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_NO_IMP_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);

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;
3842:
3843: IF(server_id > 0)THEN

Line 3844: IF(CZ_UTILS.check_installed_lang(server_id) <> 0)THEN

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
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;

Line 3845: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_LANGUAGES_DO_NOT_MATCH'),1,'CZ_IMP_ALL.ImportSingleBill',11276);

3841: END;
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:

Line 3916: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

3912: VALUES (genRun_ID,SYSDATE,SYSDATE,'0');
3913: x_run_id := genRun_ID;
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;

Line 3917: xERROR:=cz_utils.log_report(d_str,1,'SINGLEBILL:CZ_XFR_RUN_INFOS',11276,genRun_ID);

3913: x_run_id := genRun_ID;
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:

Line 3972: xERROR:=cz_utils.log_report(SQLERRM,1,'SINGLEBILL:COMMITSIZE',11276,x_run_id);

3968: WHERE UPPER(SETTING_ID) = v_settings_id
3969: AND UPPER(SECTION_NAME) = v_section_name;
3970: EXCEPTION
3971: WHEN OTHERS THEN
3972: xERROR:=cz_utils.log_report(SQLERRM,1,'SINGLEBILL:COMMITSIZE',11276,x_run_id);
3973: END;
3974:
3975: --LA 9595142 : Read settings that disables refresh of multiple copies of the model
3976: v_settings_id := 'DISABLEMULTIPLECOPYIMPORT';

Line 3989: NOUPDATE_SOURCE_BILL_DELETED:=CZ_UTILS.GET_NOUPDATE_FLAG('CZ_XFR_PROJECT_BILLS','SOURCE_BILL_DELETED', 'IMPORT');

3985: disableMultipleCopyImport := 0;
3986: END;
3987:
3988:
3989: NOUPDATE_SOURCE_BILL_DELETED:=CZ_UTILS.GET_NOUPDATE_FLAG('CZ_XFR_PROJECT_BILLS','SOURCE_BILL_DELETED', 'IMPORT');
3990: BEGIN
3991: OPEN C_BILL_OF_MATERIAL;
3992: FETCH C_BILL_OF_MATERIAL INTO cFound;
3993: IF(C_BILL_OF_MATERIAL%FOUND)THEN

Line 4027: xERROR:=cz_utils.log_report(l_msg_data,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL',20001,genRun_ID);

4023: x_msg_data => l_msg_data);
4024: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4025: FOR i IN 1..l_msg_count LOOP
4026: l_msg_data := fnd_msg_pub.GET(i,fnd_api.g_false);
4027: xERROR:=cz_utils.log_report(l_msg_data,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL',20001,genRun_ID);
4028: END LOOP;
4029: RAISE FAILED_TO_LOCK_MODEL;
4030: END IF;
4031: END LOOP;

Line 4036: xERROR:=cz_utils.log_report(d_str,1,'EXTRACT_PS_NODE',11299,genRun_ID);

4032:
4033: if (CZ_IMP_ALL.get_time) then
4034: extract_end := dbms_utility.get_time();
4035: d_str := genRun_Id || ' EXTRACT PS - TOTAL (' || nTop_Id || ') :' || (extract_end-extract_st)/100.00;
4036: xERROR:=cz_utils.log_report(d_str,1,'EXTRACT_PS_NODE',11299,genRun_ID);
4037: end if;
4038:
4039: IF(CZ_ORAAPPS_INTEGRATE.mRETCODE = 2)THEN RETURN; END IF;
4040:

Line 4052: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);

4048: END IF;
4049: CLOSE C_BILL_OF_MATERIAL;
4050: EXCEPTION
4051: WHEN PRIV_CHECK_ERR THEN
4052: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
4053: DBMS_APPLICATION_INFO.SET_MODULE('','');
4054: RAISE;
4055: WHEN HAS_NO_PRIV THEN
4056: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);

Line 4056: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);

4052: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
4053: DBMS_APPLICATION_INFO.SET_MODULE('','');
4054: RAISE;
4055: WHEN HAS_NO_PRIV THEN
4056: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
4057: DBMS_APPLICATION_INFO.SET_MODULE('','');
4058: RAISE;
4059: WHEN FAILED_TO_LOCK_MODEL THEN
4060: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);

Line 4060: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);

4056: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
4057: DBMS_APPLICATION_INFO.SET_MODULE('','');
4058: RAISE;
4059: WHEN FAILED_TO_LOCK_MODEL 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

Line 4090: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

4086: IF C_BILL_OF_MATERIAL%ISOPEN THEN CLOSE C_BILL_OF_MATERIAL; END IF;
4087: processed_expls_tbl.DELETE;
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:

Line 4091: xERROR:=cz_utils.log_report(d_str,1,'EXTRACT_PS_NODE',11299,genRun_ID);

4087: processed_expls_tbl.DELETE;
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.

Line 4145: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.CATALOG',11276,genRun_ID);

4141: END LOOP;
4142:
4143: EXCEPTION
4144: WHEN NO_DATA_FOUND THEN
4145: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.CATALOG',11276,genRun_ID);
4146: END;
4147:
4148: if (CZ_IMP_ALL.get_time) then
4149: end_time := dbms_utility.get_time();

Line 4151: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,genRun_ID);

4147:
4148: if (CZ_IMP_ALL.get_time) then
4149: end_time := dbms_utility.get_time();
4150: d_str := genRun_Id ||' Collect Catalog group id (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
4151: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,genRun_ID);
4152: end if;
4153:
4154: ----2) Populate the table for UI refresh using the extracted list of models
4155:

Line 4191: xERROR:=cz_utils.log_report(sTableName||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.extract_table',11276,genRun_ID);

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
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;

Line 4193: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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
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;

Line 4194: xERROR:=cz_utils.log_report(d_str,1,'SINGLEBILL:EXTRACTION',11276,genRun_ID);

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
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;

Line 4224: xERROR:=cz_utils.log_report(sTableName||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.populate_table',11276,genRun_ID);

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
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;

Line 4226: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

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
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;

Line 4227: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.GO.IMPORT',11276,genRun_ID);

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
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;

Line 4245: xERROR:=cz_utils.log_report(nTop_ID||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.XFRPROJECTS',11276,genRun_ID);

4241: AND explosion_type = sExpl_type
4242: AND last_import_run_id = genRun_ID;
4243: EXCEPTION
4244: WHEN OTHERS THEN
4245: xERROR:=cz_utils.log_report(nTop_ID||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.XFRPROJECTS',11276,genRun_ID);
4246: END;
4247:
4248: BEGIN
4249: cz_refs.set_Trackable_Children_Flag(nModelId);

Line 4252: xERROR:=cz_utils.log_report(nModelId||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.TRACKABLE',11276,genRun_ID);

4248: BEGIN
4249: cz_refs.set_Trackable_Children_Flag(nModelId);
4250: EXCEPTION
4251: WHEN OTHERS THEN
4252: xERROR:=cz_utils.log_report(nModelId||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.TRACKABLE',11276,genRun_ID);
4253: END;
4254:
4255: -- LA 13733007: No children OC
4256: -- Report option classes with no children or all ineffective children

Line 4286: xERROR :=CZ_UTILS.LOG_REPORT('Model ''' || lNoChildOCModelName(i) ||

4282:
4283: IF (lNoChildOCModelName.COUNT > 0) THEN
4284: FOR i IN 1..lNoChildOCModelName.COUNT
4285: LOOP
4286: xERROR :=CZ_UTILS.LOG_REPORT('Model ''' || lNoChildOCModelName(i) ||
4287: ''' contains an option class that has no effective children, option class ''' || lNoChildOCName(i) || '''.',
4288: 1, 'CZ_IMP_SINGLE.IMPORTSINGLEBILL.NOCHILD_OC', 11276,genRun_ID);
4289: END LOOP;
4290: cz_imp_all.setReturnCode(cz_imp_all.CONCURRENT_WARNING,'Model contains option class that does not have effective children.');

Line 4294: xERROR:=cz_utils.log_report(nModelId||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.NOCHILD_OC',11276,genRun_ID);

4290: cz_imp_all.setReturnCode(cz_imp_all.CONCURRENT_WARNING,'Model contains option class that does not have effective children.');
4291: END IF;
4292: EXCEPTION
4293: WHEN OTHERS THEN
4294: xERROR:=cz_utils.log_report(nModelId||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.NOCHILD_OC',11276,genRun_ID);
4295: END;
4296:
4297: ----5) Finally update the (LAST_ACTIVITY,COMPLETED) fields of CZ_XFR_RUN_INFOS
4298: BEGIN

Line 4305: xERROR:=cz_utils.log_report(genRun_ID||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.RUNINFOS',11276,genRun_ID);

4301: COMPLETED='1'
4302: WHERE RUN_ID=genRun_ID;
4303: EXCEPTION
4304: WHEN OTHERS THEN
4305: xERROR:=cz_utils.log_report(genRun_ID||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.RUNINFOS',11276,genRun_ID);
4306: END;
4307:
4308: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_IMPORT_COMPLETED','RUNID',TO_CHAR(genRun_ID)));
4309:

Line 4308: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_IMPORT_COMPLETED','RUNID',TO_CHAR(genRun_ID)));

4304: WHEN OTHERS THEN
4305: xERROR:=cz_utils.log_report(genRun_ID||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.RUNINFOS',11276,genRun_ID);
4306: END;
4307:
4308: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_IMPORT_COMPLETED','RUNID',TO_CHAR(genRun_ID)));
4309:
4310: IF l_compare_detailed_types THEN
4311:
4312: FOR model IN (SELECT devl_project_id FROM cz_imp_devl_project WHERE run_id = genRun_ID

Line 4356: xERROR:=cz_utils.log_report(nModelId||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.UNLOCK',11276,genRun_ID);

4352: x_msg_count => l_msg_count,
4353: x_msg_data => l_msg_data);
4354: EXCEPTION
4355: WHEN OTHERS 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

Line 4363: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'SINGLEBILL.GENERAL',11276,genRun_ID);

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
4367: RAISE;

Line 4369: xERROR:=cz_utils.log_report(SQLERRM,1,'SINGLEBILL.GENERAL',11276,genRun_ID);

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
4371: IF ( l_locked_models.COUNT > 0 ) THEN
4372: BEGIN
4373: cz_security_pvt.unlock_model(

Line 4382: xERROR:=cz_utils.log_report(nModelId||':'||SQLERRM,1,'SINGLEBILL.GENERAL.unlock',11276,genRun_ID);

4378: x_msg_count => l_msg_count,
4379: x_msg_data => l_msg_data);
4380: EXCEPTION
4381: WHEN OTHERS THEN
4382: xERROR:=cz_utils.log_report(nModelId||':'||SQLERRM,1,'SINGLEBILL.GENERAL.unlock',11276,genRun_ID);
4383: END;
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);

Line 4385: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

4381: WHEN OTHERS THEN
4382: xERROR:=cz_utils.log_report(nModelId||':'||SQLERRM,1,'SINGLEBILL.GENERAL.unlock',11276,genRun_ID);
4383: END;
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;

Line 4386: xERROR:=cz_utils.log_report(d_str,1,'SINGLEBILL.GENERAL',11276,genRun_ID);

4382: xERROR:=cz_utils.log_report(nModelId||':'||SQLERRM,1,'SINGLEBILL.GENERAL.unlock',11276,genRun_ID);
4383: END;
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: ------------------------------------------------------------------------------------------