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 207: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_id);

203:
204: if (CZ_IMP_ALL.get_time) then
205: end_time := dbms_utility.get_time();
206: d_str := inRun_Id || ' Bulk collect item master (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
207: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_id);
208: end if;
209:
210: FOR i IN 1..InventoryItemId.COUNT LOOP
211:

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

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);
293: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
294: END;
295: ------------------------------------------------------------------------------------------

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

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);
293: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
294: END;
295: ------------------------------------------------------------------------------------------
296:

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

537:
538: -- end of changes for TSO --
539:
540: n_SortWidth NUMBER := cz_imp_ps_node.n_SortWidth;
541: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS', 'IMPORT');
542: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_LOCALIZED_TEXTS', 'IMPORT');
543: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES', 'IMPORT');
544: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS', 'IMPORT');
545: x_error BOOLEAN:=FALSE;

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

538: -- end of changes for TSO --
539:
540: n_SortWidth NUMBER := cz_imp_ps_node.n_SortWidth;
541: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS', 'IMPORT');
542: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_LOCALIZED_TEXTS', 'IMPORT');
543: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES', 'IMPORT');
544: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS', 'IMPORT');
545: x_error BOOLEAN:=FALSE;
546:

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

539:
540: n_SortWidth NUMBER := cz_imp_ps_node.n_SortWidth;
541: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS', 'IMPORT');
542: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_LOCALIZED_TEXTS', 'IMPORT');
543: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES', 'IMPORT');
544: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS', 'IMPORT');
545: x_error BOOLEAN:=FALSE;
546:
547: ComponentSequenceId tComponentSequenceId;

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

540: n_SortWidth NUMBER := cz_imp_ps_node.n_SortWidth;
541: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS', 'IMPORT');
542: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_LOCALIZED_TEXTS', 'IMPORT');
543: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES', 'IMPORT');
544: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS', 'IMPORT');
545: x_error BOOLEAN:=FALSE;
546:
547: ComponentSequenceId tComponentSequenceId;
548: ComponentCode tComponentCode;

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

838:
839: IF(ComponentItemId.COUNT = 0)THEN
840: IF(startFlag)THEN
841: --'No BOM data to extract. Verify that the bill you want to import exists on the import-enabled server.'
842: 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);
843: RETURN;
844: ELSE
845: EXIT;
846: END IF;

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

848:
849: if (CZ_IMP_ALL.get_time) then
850: end_time := dbms_utility.get_time();
851: d_str := inRun_Id || ' Extract ps structure (' || nTop_Id || ' - count - ' || componentItemId.COUNT || ' ) :' || (end_time-st_time)/100.00;
852: x_ERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
853: end if;
854:
855: if (CZ_IMP_ALL.get_time) then
856: st_time := dbms_utility.get_time();

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

860: FOR i IN ComponentItemId.FIRST..ComponentItemId.LAST LOOP
861:
862: --Need to account for bug #1710684.
863:
864: IF(EffectivityDate(i) < cz_utils.EPOCH_BEGIN_)THEN EffectivityDate(i) := cz_utils.EPOCH_BEGIN_; END IF;
865: IF(DisableDate(i) > cz_utils.EPOCH_END_)THEN DisableDate(i) := cz_utils.EPOCH_END_; END IF;
866:
867: IF(PlanLevel(i) = 0)THEN
868: nStack := 1;

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

861:
862: --Need to account for bug #1710684.
863:
864: IF(EffectivityDate(i) < cz_utils.EPOCH_BEGIN_)THEN EffectivityDate(i) := cz_utils.EPOCH_BEGIN_; END IF;
865: IF(DisableDate(i) > cz_utils.EPOCH_END_)THEN DisableDate(i) := cz_utils.EPOCH_END_; END IF;
866:
867: IF(PlanLevel(i) = 0)THEN
868: nStack := 1;
869: StackComponentCode(nStack) := ComponentCode(i);

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

1242: iLastUpdateDate(nIndex) := LastUpdateDate(i);
1243: iLastUpdatedBy(nIndex) := LastUpdatedBy(i);
1244:
1245: IF(BomItemType(i) = cnModel)THEN
1246: iEffectiveFrom(nIndex) := CZ_UTILS.EPOCH_BEGIN;
1247: iEffectiveUntil(nIndex) := CZ_UTILS.EPOCH_END;
1248: iComponentSequenceId(nIndex) := NULL;
1249: ELSE
1250: iEffectiveFrom(nIndex) := EffectivityDate(i);

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

1243: iLastUpdatedBy(nIndex) := LastUpdatedBy(i);
1244:
1245: IF(BomItemType(i) = cnModel)THEN
1246: iEffectiveFrom(nIndex) := CZ_UTILS.EPOCH_BEGIN;
1247: iEffectiveUntil(nIndex) := CZ_UTILS.EPOCH_END;
1248: iComponentSequenceId(nIndex) := NULL;
1249: ELSE
1250: iEffectiveFrom(nIndex) := EffectivityDate(i);
1251: iEffectiveUntil(nIndex) := DisableDate(i);

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

1317:
1318: if (CZ_IMP_ALL.get_time) then
1319: end_time := dbms_utility.get_time();
1320: d_str := inRun_Id || ' loop ps structure (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1321: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1322: end if;
1323:
1324: if (CZ_IMP_ALL.get_time) then
1325: st_time := dbms_utility.get_time();

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

1396:
1397: if (CZ_IMP_ALL.get_time) then
1398: end_time := dbms_utility.get_time();
1399: d_str := inRun_Id || ' Insert ps nodes (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1400: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1401: end if;
1402:
1403: COMMIT;
1404: startFlag := FALSE;

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

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

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

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

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

1559:
1560: if (CZ_IMP_ALL.get_time) then
1561: end_time := dbms_utility.get_time();
1562: d_str := inRun_Id || ' Deleted ps node check (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1563: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1564: end if;
1565:
1566: CLOSE c_onl_ps_node;
1567: COMMIT;

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

1568:
1569: EXCEPTION
1570: WHEN CZ_REFS_DELNODE_EXCP THEN
1571: IF d_str IS NULL THEN d_str := 'NO MESSAGE FOUND'; END IF;
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

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

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

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

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);
1584: ROLLBACK;
1585: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1586: END;

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

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);
1584: ROLLBACK;
1585: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1586: END;
1587:

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

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

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

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

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

1781:
1782: if (CZ_IMP_ALL.get_time) then
1783: end_time := dbms_utility.get_time();
1784: d_str := inRun_Id || ' Extract text (' || nTop_Id || ' - Count - ' || iLocalizedStr.COUNT || ') :' || (end_time-st_time)/100.00;
1785: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1786: end if;
1787:
1788: COMMIT;
1789: EXCEPTION

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

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

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

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

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

1867:
1868: if (CZ_IMP_ALL.get_time) then
1869: end_time := dbms_utility.get_time();
1870: d_str := inRun_Id || ' Extract projects (' || nTop_Id || ' - Count - ' || OrganizationId.COUNT || ') :' || (end_time-st_time)/100.00;
1871: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1872: end if;
1873:
1874: FOR i IN 1..OrganizationId.COUNT LOOP
1875:

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

1896:
1897: if (CZ_IMP_ALL.get_time) then
1898: loop_end_time := dbms_utility.get_time();
1899: d_str := inRun_Id || ' Loop Projects (' || nTop_Id || ') :' || (loop_end_time-end_time)/100.00;
1900: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1901: end if;
1902:
1903: FORALL i IN 1..iOrigSysRef.COUNT
1904: INSERT INTO CZ_IMP_DEVL_PROJECT

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

1912:
1913: if (CZ_IMP_ALL.get_time) then
1914: insert_end_time := dbms_utility.get_time();
1915: d_str := inRun_Id || ' Insert projects (' || nTop_Id || ') :' || (insert_end_time-loop_end_time)/100.00;
1916: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1917: end if;
1918:
1919: COMMIT;
1920:

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

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);
1929: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1930: END;
1931: ------------------------------------------------------------------------------------------

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

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);
1929: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1930: END;
1931: ------------------------------------------------------------------------------------------
1932: PROCEDURE EXTR_ITEM_TYPES(inRun_ID IN PLS_INTEGER,

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

1975:
1976: if (CZ_IMP_ALL.get_time) then
1977: end_time := dbms_utility.get_time();
1978: d_str := inRun_Id || ' Insert item type (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1979: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1980: end if;
1981: COMMIT;
1982:
1983: EXCEPTION

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

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

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

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);
1993: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1994: END;
1995: ------------------------------------------------------------------------------------------
1996:

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

2105: BEGIN
2106:
2107: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2108: l_ndebug := 0;
2109: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2110: 'EXTR_APC_PROPERTIES is called ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') :',
2111: fnd_log.LEVEL_STATEMENT);
2112: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2113: 'parameters : RUN_ID='||TO_CHAR(p_run_id)||',p_org_id='||TO_CHAR(p_org_id)||

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

2108: l_ndebug := 0;
2109: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2110: 'EXTR_APC_PROPERTIES is called ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') :',
2111: fnd_log.LEVEL_STATEMENT);
2112: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2113: 'parameters : RUN_ID='||TO_CHAR(p_run_id)||',p_org_id='||TO_CHAR(p_org_id)||
2114: ', p_top_item_id='||TO_CHAR(p_top_item_id)||',p_expl_type='||p_expl_type ,
2115: fnd_log.LEVEL_STATEMENT);
2116: END IF;

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

2224: RETURN;
2225: END IF;
2226:
2227: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2228: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2229: 'APC meta data have been retrieved ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2230: fnd_log.LEVEL_STATEMENT);
2231: END IF;
2232:

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

2279:
2280: COMMIT;
2281:
2282: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2283: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2284: 'CZ_IMP_PROPERTY has been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2285: fnd_log.LEVEL_STATEMENT);
2286: END IF;
2287:

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

2330: END IF;
2331: END LOOP;
2332:
2333: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2334: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2335: 'CZ_IMP_ITEM_TYPE_PROPERTY has been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2336: fnd_log.LEVEL_STATEMENT);
2337: END IF;
2338:

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

2398: l_db_columns_tbl.DELETE;
2399: l_db_column_types_tbl.DELETE;
2400:
2401: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2402: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2403: 'Internal arrays have been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2404: fnd_log.LEVEL_STATEMENT);
2405: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2406: 'Retrieving of APC property values will be started ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',

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

2401: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2402: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2403: 'Internal arrays have been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2404: fnd_log.LEVEL_STATEMENT);
2405: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2406: 'Retrieving of APC property values will be started ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2407: fnd_log.LEVEL_STATEMENT);
2408: END IF;
2409:

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

2581: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;
2582: COMMIT;
2583:
2584: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2585: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2586: 'CZ_IMP_ITEM_PROPERTY_VALUE has been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2587: fnd_log.LEVEL_STATEMENT);
2588: END IF;
2589:

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

2590: EXCEPTION
2591: WHEN OTHERS THEN
2592: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;
2593: COMMIT;
2594: l_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'EXTR_APC_PROPERTIES',11276,p_run_id);
2595: RAISE;
2596: END EXTR_APC_PROPERTIES;
2597:
2598: ------------------------------------------------------------------------------------------

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

2643:
2644: if (CZ_IMP_ALL.get_time) then
2645: end_time := dbms_utility.get_time();
2646: d_str := inRun_Id || ' Insert property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2647: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2648: end if;
2649:
2650: COMMIT;
2651:

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

2736: CLOSE C_DATATYPE;
2737: if (CZ_IMP_ALL.get_time) then
2738: loop_end_time := dbms_utility.get_time();
2739: d_str := inRun_Id || ' Resolve property datatype (' || nTop_Id || ') :' || (loop_end_time-end_time)/100.00;
2740: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2741: end if;
2742: EXCEPTION
2743: WHEN NO_DATA_FOUND THEN
2744: NULL;

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

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

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

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

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

2783:
2784: if (CZ_IMP_ALL.get_time) then
2785: end_time := dbms_utility.get_time();
2786: d_str := inRun_Id || ' Insert item Type prop (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2787: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2788: end if;
2789:
2790: COMMIT;
2791:

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

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);
2802: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2803: END;
2804: ------------------------------------------------------------------------------------------

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

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);
2802: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2803: END;
2804: ------------------------------------------------------------------------------------------
2805: PROCEDURE EXTR_ITEM_PROPERTY_VALUES(inRun_ID IN PLS_INTEGER,

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

2840:
2841: if (CZ_IMP_ALL.get_time) then
2842: loop_end_time := dbms_utility.get_time();
2843: d_str := inRun_Id || ' Bulk collect prop val (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2844: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2845: end if;
2846:
2847: COMMIT;
2848: EXCEPTION

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

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);
2858: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2859: END;
2860: ------------------------------------------------------------------------------------------

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

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);
2858: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2859: END;
2860: ------------------------------------------------------------------------------------------
2861: PROCEDURE extract_table(inRun_ID IN PLS_INTEGER,

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

2880: EXTR_ITEM_MASTER(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2881: if (CZ_IMP_ALL.get_time) then
2882: end_time := dbms_utility.get_time();
2883: d_str := inRun_Id || ' Extract item master (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2884: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2885: end if;
2886: ELSIF(lower_table_name='cz_ps_nodes') THEN
2887: if (CZ_IMP_ALL.get_time) then
2888: st_time := dbms_utility.get_time();

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

2890: EXTR_PS_NODE(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2891: if (CZ_IMP_ALL.get_time) then
2892: end_time := dbms_utility.get_time();
2893: d_str :=inRun_Id || ' Extract ps structure (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2894: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2895: end if;
2896: ELSIF(lower_table_name='cz_localized_texts') THEN
2897: if (CZ_IMP_ALL.get_time) then
2898: st_time := dbms_utility.get_time();

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

2900: EXTR_INTL_TEXT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2901: if (CZ_IMP_ALL.get_time) then
2902: end_time := dbms_utility.get_time();
2903: d_str := inRun_Id || ' Extract intl text (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2904: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2905: end if;
2906: ELSIF(lower_table_name='cz_devl_projects') THEN
2907: if (CZ_IMP_ALL.get_time) then
2908: st_time := dbms_utility.get_time();

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

2910: EXTR_DEVL_PROJECT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2911: if (CZ_IMP_ALL.get_time) then
2912: end_time := dbms_utility.get_time();
2913: d_str := inRun_Id || ' Extract devl project (' || 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: ELSIF(lower_table_name='cz_item_types') THEN
2917: if (CZ_IMP_ALL.get_time) then
2918: st_time := dbms_utility.get_time();

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

2920: EXTR_ITEM_TYPES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2921: if (CZ_IMP_ALL.get_time) then
2922: end_time := dbms_utility.get_time();
2923: d_str := inRun_Id || ' Extract item types (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2924: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2925: end if;
2926: ELSIF(lower_table_name='cz_properties') THEN
2927: if (CZ_IMP_ALL.get_time) then
2928: st_time := dbms_utility.get_time();

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

2936:
2937: if (CZ_IMP_ALL.get_time) then
2938: end_time := dbms_utility.get_time();
2939: d_str := inRun_Id || ' Extract property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2940: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2941: end if;
2942: ELSIF(lower_table_name='cz_item_type_properties') THEN
2943: if (CZ_IMP_ALL.get_time) then
2944: st_time := dbms_utility.get_time();

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

2946: EXTR_ITEM_TYPE_PROPERTIES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2947: if (CZ_IMP_ALL.get_time) then
2948: end_time := dbms_utility.get_time();
2949: d_str := inRun_Id || ' Extract item type property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2950: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2951: end if;
2952: ELSIF(lower_table_name='cz_item_property_values') THEN
2953: if (CZ_IMP_ALL.get_time) then
2954: st_time := dbms_utility.get_time();

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

2956: EXTR_ITEM_PROPERTY_VALUES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2957: if (CZ_IMP_ALL.get_time) then
2958: end_time := dbms_utility.get_time();
2959: d_str := inRun_Id || ' Extract item property value (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2960: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2961: end if;
2962: ELSE
2963: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_EXTRACT','TABLENAME',table_name));
2964: 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 2963: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_EXTRACT','TABLENAME',table_name));

2959: d_str := inRun_Id || ' Extract item property value (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2960: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2961: end if;
2962: ELSE
2963: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_EXTRACT','TABLENAME',table_name));
2964: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_EXTRACT','TABLENAME',table_name),1,'SINGLEBILL.EXTRACT_TABLE',11276,inRun_Id);
2965: END IF;
2966: END extract_table;
2967: ------------------------------------------------------------------------------------------

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

2960: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2961: end if;
2962: ELSE
2963: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_EXTRACT','TABLENAME',table_name));
2964: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_EXTRACT','TABLENAME',table_name),1,'SINGLEBILL.EXTRACT_TABLE',11276,inRun_Id);
2965: END IF;
2966: END extract_table;
2967: ------------------------------------------------------------------------------------------
2968: PROCEDURE populate_table(inRun_ID IN PLS_INTEGER,

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

2993: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
2994: if (CZ_IMP_ALL.get_time) then
2995: end_time := dbms_utility.get_time();
2996: d_str := inRun_Id || ' Populate items :' || (end_time-st_time)/100.00;
2997: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
2998: end if;
2999: ELSIF(lower_table_name='cz_ps_nodes') THEN
3000: if (CZ_IMP_ALL.get_time) then
3001: st_time := dbms_utility.get_time();

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

3004: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3005: if (CZ_IMP_ALL.get_time) then
3006: end_time := dbms_utility.get_time();
3007: d_str := inRun_Id || ' Populate product structure :' || (end_time-st_time)/100.00;
3008: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3009: end if;
3010: ELSIF(lower_table_name='cz_localized_texts') THEN
3011: if (CZ_IMP_ALL.get_time) then
3012: st_time := dbms_utility.get_time();

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

3015: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3016: if (CZ_IMP_ALL.get_time) then
3017: end_time := dbms_utility.get_time();
3018: d_str := inRun_Id || ' Populate intl text :' || (end_time-st_time)/100.00;
3019: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3020: end if;
3021: ELSIF(lower_table_name='cz_devl_projects') THEN
3022: if (CZ_IMP_ALL.get_time) then
3023: st_time := dbms_utility.get_time();

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

3027: inXFR_GROUP,p_rp_folder_id);
3028: if (CZ_IMP_ALL.get_time) then
3029: end_time := dbms_utility.get_time();
3030: d_str := inRun_Id || ' Populate project :' || (end_time-st_time)/100.00;
3031: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3032: end if;
3033: ELSIF(lower_table_name='cz_item_property_values') THEN
3034: if (CZ_IMP_ALL.get_time) then
3035: st_time := dbms_utility.get_time();

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

3038: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3039: if (CZ_IMP_ALL.get_time) then
3040: end_time := dbms_utility.get_time();
3041: d_str := inRun_Id || ' Populate item property val :' || (end_time-st_time)/100.00;
3042: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3043: end if;
3044: ELSIF(lower_table_name='cz_item_types') THEN
3045: if (CZ_IMP_ALL.get_time) then
3046: st_time := dbms_utility.get_time();

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

3049: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3050: if (CZ_IMP_ALL.get_time) then
3051: end_time := dbms_utility.get_time();
3052: d_str := inRun_Id || ' Populate item type :' || (end_time-st_time)/100.00;
3053: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3054: end if;
3055: ELSIF(lower_table_name='cz_item_type_properties') THEN
3056: if (CZ_IMP_ALL.get_time) then
3057: st_time := dbms_utility.get_time();

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

3060: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3061: if (CZ_IMP_ALL.get_time) then
3062: end_time := dbms_utility.get_time();
3063: d_str := inRun_Id || ' Populate item type property :' || (end_time-st_time)/100.00;
3064: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3065: end if;
3066: ELSIF(lower_table_name='cz_properties') THEN
3067: if (CZ_IMP_ALL.get_time) then
3068: st_time := dbms_utility.get_time();

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

3071: Inserts, Updates, x_failed, Dups, inXFR_GROUP, p_rp_folder_id);
3072: if (CZ_IMP_ALL.get_time) then
3073: end_time := dbms_utility.get_time();
3074: d_str := inRun_Id || ' Populate property :' || (end_time-st_time)/100.00;
3075: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3076: end if;
3077: ELSE
3078: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name));
3079: 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 3078: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name));

3074: d_str := inRun_Id || ' Populate property :' || (end_time-st_time)/100.00;
3075: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3076: end if;
3077: ELSE
3078: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name));
3079: 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);
3080: END IF;
3081: --DBMS_OUTPUT.PUT_LINE('INSERTS: '||to_char(Inserts));
3082: --DBMS_OUTPUT.PUT_LINE('UPDATES: '||to_char(Updates));

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

3075: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3076: end if;
3077: ELSE
3078: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name));
3079: 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);
3080: END IF;
3081: --DBMS_OUTPUT.PUT_LINE('INSERTS: '||to_char(Inserts));
3082: --DBMS_OUTPUT.PUT_LINE('UPDATES: '||to_char(Updates));
3083: --DBMS_OUTPUT.PUT_LINE('FAILED: '||to_char(x_failed));

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

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);
3122: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3123: END GET_REMOTE_IMPORT;
3124: ------------------------------------------------------------------------------------------

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

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);
3122: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3123: END GET_REMOTE_IMPORT;
3124: ------------------------------------------------------------------------------------------
3125: FUNCTION isAppsVersion11i(fndLinkName IN VARCHAR2)

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

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);
3157: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3158: END;
3159:

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

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);
3157: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3158: END;
3159:
3160: ------------------------------------------------------------------------------------------

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

3299: fnd_stats.gather_table_stats('BOM', 'BOM_EXPLOSIONS');
3300: END IF;
3301:
3302: IF(outError_code <> 0)THEN
3303: xERROR:=cz_utils.log_report(outErr_msg, 1, 'BOM_EXPLODER', 11276,inRunId);
3304: CZ_ORAAPPS_INTEGRATE.mRETCODE := 2;
3305: CZ_ORAAPPS_INTEGRATE.mERRBUF := outErr_msg;
3306: RETURN nModelId;
3307: END IF;

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

3321: AND ROWNUM = 1;
3322:
3323: --If found, explosion is not up-to-date.
3324:
3325: outErr_msg := CZ_UTILS.GET_TEXT('CZ_IMP_STALE_EXPLOSION');
3326: xERROR:=CZ_IMP_ALL.REPORT(outErr_msg, 1, 'BOM_EXPLODER', 11276);
3327: CZ_ORAAPPS_INTEGRATE.mRETCODE := 2;
3328: CZ_ORAAPPS_INTEGRATE.mERRBUF := outErr_msg;
3329: RETURN nModelId;

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

3339:
3340: if (CZ_IMP_ALL.get_time) then
3341: bom_explode_end := dbms_utility.get_time();
3342: d_str := inRunId || ' Bom Exploder (' || inTopId || ') :' || (bom_explode_end-bom_explode_st)/100.00;
3343: xERROR:=cz_utils.log_report(d_str,1,'BOM_EXPLODER',11299,inRunId);
3344: end if;
3345:
3346: extract_table(inRunId, 'CZ_PS_NODES', inOrgId, inTopId, inExplType, nModelId);
3347:

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

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);
3405: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3406: END;
3407: END LOOP;

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

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);
3405: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3406: END;
3407: END LOOP;
3408: CLOSE c_expl;

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

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);
3420: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3421: END;
3422: ------------------------------------------------------------------------------------------

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

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);
3420: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3421: END;
3422: ------------------------------------------------------------------------------------------
3423: PROCEDURE ImportSingleBill(nOrg_ID IN NUMBER,nTop_ID IN NUMBER,

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

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

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

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

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

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

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

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

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

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

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

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

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

3655: WHERE UPPER(SETTING_ID) = v_settings_id
3656: AND UPPER(SECTION_NAME) = v_section_name;
3657: EXCEPTION
3658: WHEN OTHERS THEN
3659: xERROR:=cz_utils.log_report(SQLERRM,1,'SINGLEBILL:COMMITSIZE',11276,x_run_id);
3660: END;
3661:
3662: NOUPDATE_SOURCE_BILL_DELETED:=CZ_UTILS.GET_NOUPDATE_FLAG('CZ_XFR_PROJECT_BILLS','SOURCE_BILL_DELETED', 'IMPORT');
3663: BEGIN

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

3658: WHEN OTHERS THEN
3659: xERROR:=cz_utils.log_report(SQLERRM,1,'SINGLEBILL:COMMITSIZE',11276,x_run_id);
3660: END;
3661:
3662: NOUPDATE_SOURCE_BILL_DELETED:=CZ_UTILS.GET_NOUPDATE_FLAG('CZ_XFR_PROJECT_BILLS','SOURCE_BILL_DELETED', 'IMPORT');
3663: BEGIN
3664: OPEN C_BILL_OF_MATERIAL;
3665: FETCH C_BILL_OF_MATERIAL INTO cFound;
3666: IF(C_BILL_OF_MATERIAL%FOUND)THEN

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

3690: x_msg_data => l_msg_data);
3691: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3692: FOR i IN 1..l_msg_count LOOP
3693: l_msg_data := fnd_msg_pub.GET(i,fnd_api.g_false);
3694: xERROR:=cz_utils.log_report(l_msg_data,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL',20001,genRun_ID);
3695: END LOOP;
3696: RAISE FAILED_TO_LOCK_MODEL;
3697: END IF;
3698: END LOOP;

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

3699:
3700: if (CZ_IMP_ALL.get_time) then
3701: extract_end := dbms_utility.get_time();
3702: d_str := genRun_Id || ' EXTRACT PS - TOTAL (' || nTop_Id || ') :' || (extract_end-extract_st)/100.00;
3703: xERROR:=cz_utils.log_report(d_str,1,'EXTRACT_PS_NODE',11299,genRun_ID);
3704: end if;
3705:
3706: IF(CZ_ORAAPPS_INTEGRATE.mRETCODE = 2)THEN RETURN; END IF;
3707:

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

3715: END IF;
3716: CLOSE C_BILL_OF_MATERIAL;
3717: EXCEPTION
3718: WHEN PRIV_CHECK_ERR THEN
3719: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
3720: DBMS_APPLICATION_INFO.SET_MODULE('','');
3721: RAISE;
3722: WHEN HAS_NO_PRIV THEN
3723: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);

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

3719: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
3720: DBMS_APPLICATION_INFO.SET_MODULE('','');
3721: RAISE;
3722: WHEN HAS_NO_PRIV THEN
3723: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
3724: DBMS_APPLICATION_INFO.SET_MODULE('','');
3725: RAISE;
3726: WHEN FAILED_TO_LOCK_MODEL THEN
3727: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);

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

3723: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
3724: DBMS_APPLICATION_INFO.SET_MODULE('','');
3725: RAISE;
3726: WHEN FAILED_TO_LOCK_MODEL 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

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

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

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

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

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

3791: END LOOP;
3792:
3793: EXCEPTION
3794: WHEN NO_DATA_FOUND THEN
3795: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.CATALOG',11276,genRun_ID);
3796: END;
3797:
3798: if (CZ_IMP_ALL.get_time) then
3799: end_time := dbms_utility.get_time();

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

3797:
3798: if (CZ_IMP_ALL.get_time) then
3799: end_time := dbms_utility.get_time();
3800: d_str := genRun_Id ||' Collect Catalog group id (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
3801: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,genRun_ID);
3802: end if;
3803:
3804: ----2) Populate the table for UI refresh using the extracted list of models
3805:

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

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

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

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

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

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

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

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

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

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

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

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

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

3891: AND explosion_type = sExpl_type
3892: AND last_import_run_id = genRun_ID;
3893: EXCEPTION
3894: WHEN OTHERS THEN
3895: xERROR:=cz_utils.log_report(nTop_ID||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.XFRPROJECTS',11276,genRun_ID);
3896: END;
3897:
3898: BEGIN
3899: cz_refs.set_Trackable_Children_Flag(nModelId);

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

3898: BEGIN
3899: cz_refs.set_Trackable_Children_Flag(nModelId);
3900: EXCEPTION
3901: WHEN OTHERS THEN
3902: xERROR:=cz_utils.log_report(nModelId||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.TRACKABLE',11276,genRun_ID);
3903: END;
3904:
3905: ----5) Finally update the (LAST_ACTIVITY,COMPLETED) fields of CZ_XFR_RUN_INFOS
3906: BEGIN

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

3909: COMPLETED='1'
3910: WHERE RUN_ID=genRun_ID;
3911: EXCEPTION
3912: WHEN OTHERS THEN
3913: xERROR:=cz_utils.log_report(genRun_ID||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.RUNINFOS',11276,genRun_ID);
3914: END;
3915:
3916: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_IMPORT_COMPLETED','RUNID',TO_CHAR(genRun_ID)));
3917:

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

3912: WHEN OTHERS THEN
3913: xERROR:=cz_utils.log_report(genRun_ID||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.RUNINFOS',11276,genRun_ID);
3914: END;
3915:
3916: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_IMPORT_COMPLETED','RUNID',TO_CHAR(genRun_ID)));
3917:
3918: IF l_compare_detailed_types THEN
3919:
3920: FOR model IN (SELECT devl_project_id FROM cz_imp_devl_project WHERE run_id = genRun_ID

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

3960: x_msg_count => l_msg_count,
3961: x_msg_data => l_msg_data);
3962: EXCEPTION
3963: WHEN OTHERS 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

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

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

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

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
3979: IF ( l_locked_models.COUNT > 0 ) THEN
3980: BEGIN
3981: cz_security_pvt.unlock_model(

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

3986: x_msg_count => l_msg_count,
3987: x_msg_data => l_msg_data);
3988: EXCEPTION
3989: WHEN OTHERS THEN
3990: xERROR:=cz_utils.log_report(nModelId||':'||SQLERRM,1,'SINGLEBILL.GENERAL.unlock',11276,genRun_ID);
3991: END;
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);

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

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

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

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