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_IMP_SINGLE

Line 1: PACKAGE BODY CZ_IMP_SINGLE AS

1: PACKAGE BODY CZ_IMP_SINGLE AS
2: /* $Header: czisngb.pls 120.32.12020000.3 2012/10/04 20:46:48 lamrute ship $ */
3:
4: /*******************************
5: Stuller's changes :

Line 18: G_PKG_NAME CONSTANT VARCHAR2(50) := 'CZ_IMP_SINGLE';

14:
15: G_BOM_APPLICATION_ID CONSTANT NUMBER := 702;
16: G_EGO_APPLICATION_ID CONSTANT NUMBER := 431;
17:
18: G_PKG_NAME CONSTANT VARCHAR2(50) := 'CZ_IMP_SINGLE';
19:
20: DECIMAL_TYPE CONSTANT NUMBER := 2;
21: TEXT_TYPE CONSTANT NUMBER := 4;
22: TL_TEXT_TYPE CONSTANT NUMBER := 8;

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 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 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 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 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 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 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 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 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 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 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 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 4217: populate_table(genRun_ID, sTableName, nCommit_size, nMax_err, 'IMPORT', CZ_IMP_SINGLE.RP_ROOT_FOLDER, l_failed);

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

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 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 4288: 1, 'CZ_IMP_SINGLE.IMPORTSINGLEBILL.NOCHILD_OC', 11276,genRun_ID);

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.');
4291: END IF;
4292: EXCEPTION

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 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 4392: END CZ_IMP_SINGLE;

4388: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
4389: END ImportSingleBill;
4390: ------------------------------------------------------------------------------------------
4391:
4392: END CZ_IMP_SINGLE;