APPS.ZX_TCM_CONTROL_PKG dependencies on FND_PRODUCT_INSTALLATIONS

Line 308: FROM fnd_product_installations

304: IF zx_global_Structures_pkg.g_inventory_installed_flag IS NULL THEN
305: BEGIN
306: SELECT STATUS, DB_STATUS
307: INTO l_status, l_db_status
308: FROM fnd_product_installations
309: WHERE APPLICATION_ID = '401';
310: EXCEPTION
311: WHEN OTHERS THEN
312: -- Logging Infra: YK: 3/5

Line 318: l_log_msg := 'E: EXC: OTHERS: select fnd_product_installations: '|| SQLCODE||': '||SQLERRM;

314: -- NULL;
315:
316: -- Logging Infra: YK: 3/5: Statement level
317: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
318: l_log_msg := 'E: EXC: OTHERS: select fnd_product_installations: '|| SQLCODE||': '||SQLERRM;
319: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
320: END IF;
321: END;
322:

Line 338: l_log_msg := 'E: SEL fnd_product_installations: inventory not enabled: l_status='|| l_status ||

334: p_fsc_rec.fsc_code:= null;
335:
336: -- Logging Infra: YK: 3/5: Statement level: "E" means "E"rror
337: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
338: l_log_msg := 'E: SEL fnd_product_installations: inventory not enabled: l_status='|| l_status ||
339: ', l_db_status=' || l_db_status;
340: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
341: END IF;
342: