DBA Data[Home] [Help]

APPS.ZX_TCM_CONTROL_PKG dependencies on FND_PRODUCT_INSTALLATIONS

Line 309: from fnd_product_installations

305:
306: Begin
307: Select STATUS, DB_STATUS
308: into l_status, l_db_status
309: from fnd_product_installations
310: where APPLICATION_ID = '401';
311: Exception
312: When OTHERS then
313: -- Logging Infra: YK: 3/5

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

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

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

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