DBA Data[Home] [Help]

APPS.GCS_CREATE_LEVELS_PKG dependencies on FND_FILE

Line 69: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || 'Gcs_Create_Levels' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

65: IF (statementloglevel >= runtimeloglevel ) THEN
66: FND_LOG.STRING(statementloglevel, 'gcs.plsql.gcs_create_levels_pkg.gcs_create_level', 'p_dimension = ' || p_dimension);
67: END IF;
68:
69: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || 'Gcs_Create_Levels' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
70:
71: -- Set the dimension table info
72: IF ( p_dimension = 'COMPANY_COST_CENTER_ORG') THEN
73: l_btable := 'FEM_CCTR_ORGS_B';

Line 200: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gcs_Create_Levels : dim loader status = '

196: retcode => retcode,
197: p_execution_mode => 'S',
198: p_dimension_id => l_dim_id);
199:
200: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gcs_Create_Levels : dim loader status = '
201: || retcode
202: || ' '
203: || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
204:

Line 215: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gcs_Create_Levels : Dimension _B table = ' || l_btable );

211: AND tempsp.dim_display_code = dimb.' || l_displaycol || ' AND dimb.value_set_id = val.value_set_id AND val.value_set_display_code = tempsp.dim_value_set_display_code ';
212:
213: EXECUTE IMMEDIATE stmt INTO level_flag;
214:
215: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gcs_Create_Levels : Dimension _B table = ' || l_btable );
216: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gcs_Create_Levels : Dimension display column = ' || l_displaycol );
217: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gcs_Create_Levels : Conflicting level row count = ' || to_char(level_flag) );
218:
219: IF ( level_flag) = 0 THEN

Line 216: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gcs_Create_Levels : Dimension display column = ' || l_displaycol );

212:
213: EXECUTE IMMEDIATE stmt INTO level_flag;
214:
215: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gcs_Create_Levels : Dimension _B table = ' || l_btable );
216: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gcs_Create_Levels : Dimension display column = ' || l_displaycol );
217: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gcs_Create_Levels : Conflicting level row count = ' || to_char(level_flag) );
218:
219: IF ( level_flag) = 0 THEN
220: p_level_exists := 'N';

Line 217: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gcs_Create_Levels : Conflicting level row count = ' || to_char(level_flag) );

213: EXECUTE IMMEDIATE stmt INTO level_flag;
214:
215: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gcs_Create_Levels : Dimension _B table = ' || l_btable );
216: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gcs_Create_Levels : Dimension display column = ' || l_displaycol );
217: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gcs_Create_Levels : Conflicting level row count = ' || to_char(level_flag) );
218:
219: IF ( level_flag) = 0 THEN
220: p_level_exists := 'N';
221: ELSE

Line 272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gcs_Create_Levels : Update rows = ' || to_char(SQL%ROWCOUNT));

268:
269:
270: EXECUTE IMMEDIATE stmt;
271:
272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gcs_Create_Levels : Update rows = ' || to_char(SQL%ROWCOUNT));
273:
274: END IF;
275: END IF; -- if p_level_exists is 'N'
276: