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 FND_LOG

Line 2169: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2165: l_attr_counter NUMBER;
2166:
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);

Line 2173: fnd_log.LEVEL_STATEMENT);

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)||
2176: ', p_top_item_id='||TO_CHAR(p_top_item_id)||',p_expl_type='||p_expl_type ,
2177: fnd_log.LEVEL_STATEMENT);

Line 2177: fnd_log.LEVEL_STATEMENT);

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;
2179:
2180: --
2181: -- if l_check_for_stub_views > 0 then stub views are used

Line 2289: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2285: DELETE FROM CZ_IMP_TMP_ITEMCAT where run_id=p_run_id;
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;

Line 2292: fnd_log.LEVEL_STATEMENT);

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:
2295: FOR ii IN (SELECT item_catalog_group_id FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id)
2296: LOOP

Line 2344: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2340: END LOOP;
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;

Line 2347: fnd_log.LEVEL_STATEMENT);

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:
2350: --
2351: -- populate Import Property table with APC properties meta data for Item Types

Line 2395: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

Line 2398: fnd_log.LEVEL_STATEMENT);

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:
2401: --
2402: -- collect APC meta data for properties :

Line 2463: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2459: l_att_names_tbl.DELETE;
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,

Line 2466: fnd_log.LEVEL_STATEMENT);

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')||') ',
2469: fnd_log.LEVEL_STATEMENT);
2470: END IF;

Line 2469: fnd_log.LEVEL_STATEMENT);

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:
2472: ---Bug Fix - 8519380
2473: l_sql := 'SELECT apcpropvals.* FROM CZ_EXV_ITEM_APC_PROP_VALUES apcpropvals,'||

Line 2654: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

Line 2657: fnd_log.LEVEL_STATEMENT);

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:
2660: EXCEPTION
2661: WHEN OTHERS THEN