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 2107: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2103: l_attr_counter NUMBER;
2104:
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);

Line 2111: fnd_log.LEVEL_STATEMENT);

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

Line 2115: fnd_log.LEVEL_STATEMENT);

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;
2117:
2118: --
2119: -- if l_check_for_stub_views > 0 then stub views are used

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

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

Line 2230: fnd_log.LEVEL_STATEMENT);

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

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

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

Line 2285: fnd_log.LEVEL_STATEMENT);

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

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

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

Line 2336: fnd_log.LEVEL_STATEMENT);

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:
2339: --
2340: -- collect APC meta data for properties :

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

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

Line 2404: fnd_log.LEVEL_STATEMENT);

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

Line 2407: fnd_log.LEVEL_STATEMENT);

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:
2410: l_sql := 'SELECT apcpropvals.* FROM CZ_EXV_ITEM_APC_PROP_VALUES apcpropvals,'||
2411: 'CZ_IMP_TMP_ITEMCAT itemtypes '||

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

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

Line 2587: fnd_log.LEVEL_STATEMENT);

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:
2590: EXCEPTION
2591: WHEN OTHERS THEN