DBA Data[Home] [Help]

APPS.GCS_BUILD_EPB_DATA_TR_PKG dependencies on FND_LOG

Line 70: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

66: l_category_id VARCHAR2(30);
67:
68: BEGIN
69:
70: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
71: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_FEM_POSTING_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
72: GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DATATR_PKG' ||
73: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
74: END IF;

Line 71: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_FEM_POSTING_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',

67:
68: BEGIN
69:
70: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
71: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_FEM_POSTING_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
72: GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DATATR_PKG' ||
73: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
74: END IF;
75: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DATATR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 344: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;

340:
341:
342: /* $Header: gcsepbtrdatab.pls 120.10 2007/12/13 11:56:54 cdesouza noship $ */
343: -- Store the log level
344: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
345: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
346: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
347: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
348: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;

Line 345: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;

341:
342: /* $Header: gcsepbtrdatab.pls 120.10 2007/12/13 11:56:54 cdesouza noship $ */
343: -- Store the log level
344: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
345: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
346: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
347: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
348: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
349: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;

Line 346: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;

342: /* $Header: gcsepbtrdatab.pls 120.10 2007/12/13 11:56:54 cdesouza noship $ */
343: -- Store the log level
344: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
345: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
346: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
347: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
348: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
349: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
350:

Line 347: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;

343: -- Store the log level
344: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
345: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
346: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
347: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
348: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
349: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
350:
351: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;

Line 348: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;

344: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
345: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
346: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
347: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
348: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
349: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
350:
351: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;
352: -- bugfix 5569522: Added for FND logging.

Line 349: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;

345: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
346: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
347: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
348: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
349: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
350:
351: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;
352: -- bugfix 5569522: Added for FND logging.
353: g_api VARCHAR2(200) := ''gcs.plsql.GCS_DYN_EPB_DATATR_PKG'';

Line 352: -- bugfix 5569522: Added for FND logging.

348: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
349: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
350:
351: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;
352: -- bugfix 5569522: Added for FND logging.
353: g_api VARCHAR2(200) := ''gcs.plsql.GCS_DYN_EPB_DATATR_PKG'';
354:
355: -- bugfix 5569522: Added p_analysis_cycle_id parameter for launching business
356: -- process.

Line 412: runtimeLogLevel := FND_LOG.g_current_runtime_level;

408: l_row_count NUMBER(15);
409:
410: BEGIN
411:
412: runtimeLogLevel := FND_LOG.g_current_runtime_level;
413:
414: IF (procedureloglevel >= runtimeloglevel ) THEN
415: FND_LOG.STRING(procedureloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data.begin'' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, ''DD-MON-YYYY HH:MI:SS''));
416: END IF;

Line 415: FND_LOG.STRING(procedureloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data.begin'' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, ''DD-MON-YYYY HH:MI:SS''));

411:
412: runtimeLogLevel := FND_LOG.g_current_runtime_level;
413:
414: IF (procedureloglevel >= runtimeloglevel ) THEN
415: FND_LOG.STRING(procedureloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data.begin'' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, ''DD-MON-YYYY HH:MI:SS''));
416: END IF;
417: IF (statementloglevel >= runtimeloglevel ) THEN
418: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_hierarchy_id = '' || to_char(p_hierarchy_id));
419: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_balance_type_code = '' || p_balance_type_code);

Line 418: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_hierarchy_id = '' || to_char(p_hierarchy_id));

414: IF (procedureloglevel >= runtimeloglevel ) THEN
415: FND_LOG.STRING(procedureloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data.begin'' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, ''DD-MON-YYYY HH:MI:SS''));
416: END IF;
417: IF (statementloglevel >= runtimeloglevel ) THEN
418: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_hierarchy_id = '' || to_char(p_hierarchy_id));
419: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_balance_type_code = '' || p_balance_type_code);
420: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_cal_period_id = '' || to_char(p_cal_period_id));
421: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_analysis_cycle_id = '' || to_char(p_analysis_cycle_id));
422: END IF;

Line 419: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_balance_type_code = '' || p_balance_type_code);

415: FND_LOG.STRING(procedureloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data.begin'' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, ''DD-MON-YYYY HH:MI:SS''));
416: END IF;
417: IF (statementloglevel >= runtimeloglevel ) THEN
418: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_hierarchy_id = '' || to_char(p_hierarchy_id));
419: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_balance_type_code = '' || p_balance_type_code);
420: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_cal_period_id = '' || to_char(p_cal_period_id));
421: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_analysis_cycle_id = '' || to_char(p_analysis_cycle_id));
422: END IF;
423:

Line 420: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_cal_period_id = '' || to_char(p_cal_period_id));

416: END IF;
417: IF (statementloglevel >= runtimeloglevel ) THEN
418: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_hierarchy_id = '' || to_char(p_hierarchy_id));
419: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_balance_type_code = '' || p_balance_type_code);
420: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_cal_period_id = '' || to_char(p_cal_period_id));
421: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_analysis_cycle_id = '' || to_char(p_analysis_cycle_id));
422: END IF;
423:
424: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || ''Gcs_Epb_Tr_Data'' || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));

Line 421: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_analysis_cycle_id = '' || to_char(p_analysis_cycle_id));

417: IF (statementloglevel >= runtimeloglevel ) THEN
418: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_hierarchy_id = '' || to_char(p_hierarchy_id));
419: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_balance_type_code = '' || p_balance_type_code);
420: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_cal_period_id = '' || to_char(p_cal_period_id));
421: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_analysis_cycle_id = '' || to_char(p_analysis_cycle_id));
422: END IF;
423:
424: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || ''Gcs_Epb_Tr_Data'' || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
425: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_hierarchy_id = '' || to_char(p_hierarchy_id));

Line 446: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''Called Dimension Transfer '');

442:
443: FND_FILE.PUT_LINE(FND_FILE.LOG, '' Call Dimension Transfer '');
444:
445: IF (statementloglevel >= runtimeloglevel ) THEN
446: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''Called Dimension Transfer '');
447: END IF;
448:
449: IF retcode = ''0'' THEN
450: RAISE DIM_TRANSFER_FAILED;

Line 973: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DATA_TR_PKG.GCS_EPB_TR_DATA'', ''NO_DATASET_CREATED'');

969: FND_MESSAGE.set_name( ''GCS'', ''GCS_EPB_NO_DATASET'' );
970: errbuf := FND_MESSAGE.get;
971: retcode := ''0'';
972: IF (unexpectedloglevel >= runtimeloglevel ) THEN
973: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DATA_TR_PKG.GCS_EPB_TR_DATA'', ''NO_DATASET_CREATED'');
974: END IF;
975: fnd_file.put_line(fnd_file.log, ''Fatal Error Occurred : '' || SQLERRM);
976: l_ret_status := fnd_concurrent.set_completion_status(
977: status => ''ERROR'',

Line 988: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DATA_TR_PKG.GCS_EPB_TR_DATA'', ''DIM_TRANSFER_FAILED'');

984: FND_MESSAGE.set_name( ''GCS'', ''GCS_EPB_FAIL_DIM_TRANSFER'' );
985: errbuf := FND_MESSAGE.get;
986: retcode := ''0'';
987: IF (unexpectedloglevel >= runtimeloglevel ) THEN
988: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DATA_TR_PKG.GCS_EPB_TR_DATA'', ''DIM_TRANSFER_FAILED'');
989: END IF;
990: fnd_file.put_line(fnd_file.log, ''Fatal Error Occurred : '' || SQLERRM);
991: l_ret_status := fnd_concurrent.set_completion_status(
992: status => ''ERROR'',

Line 998: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DATA_TR_PKG.GCS_EPB_TR_DATA'', ''GCS_NO_DATA_FOUND'');

994: RAISE;
995:
996: WHEN NO_DATA_FOUND THEN
997: IF (unexpectedloglevel >= runtimeloglevel ) THEN
998: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DATA_TR_PKG.GCS_EPB_TR_DATA'', ''GCS_NO_DATA_FOUND'');
999: END IF;
1000: retcode := ''0'';
1001: errbuf := ''GCS_NO_DATA_FOUND'';
1002: fnd_file.put_line(fnd_file.log, ''Fatal Error Occurred : '' || SQLERRM);

Line 1011: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DATA_TR_PKG.GCS_EPB_TR_DATA'', errbuf);

1007:
1008: WHEN OTHERS THEN
1009: errbuf := substr( SQLERRM, 1, 2000);
1010: IF (unexpectedloglevel >= runtimeloglevel ) THEN
1011: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DATA_TR_PKG.GCS_EPB_TR_DATA'', errbuf);
1012: END IF;
1013: retcode := ''0'';
1014: fnd_file.put_line(fnd_file.log, ''Fatal Error Occurred : '' || SQLERRM);
1015: l_ret_status := fnd_concurrent.set_completion_status(

Line 1071: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1067: l_conc_req_status BOOLEAN;
1068:
1069: BEGIN
1070:
1071: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1072: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.SUBMIT_BUSINESS_PROCESS.begin'', ''<>'');
1073: END IF;
1074:
1075: fnd_file.put_line(fnd_file.log, ''<>'');

Line 1072: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.SUBMIT_BUSINESS_PROCESS.begin'', ''<>'');

1068:
1069: BEGIN
1070:
1071: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1072: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.SUBMIT_BUSINESS_PROCESS.begin'', ''<>'');
1073: END IF;
1074:
1075: fnd_file.put_line(fnd_file.log, ''<>'');
1076: fnd_file.put_line(fnd_file.log, ''Calendar Period : '' || p_cal_period_id);

Line 1189: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1185: END IF;
1186:
1187: END IF;
1188:
1189: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1190: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.SUBMIT_BUSINESS_PROCESS.end'', ''<>'');
1191: END IF;
1192: END;
1193:

Line 1190: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.SUBMIT_BUSINESS_PROCESS.end'', ''<>'');

1186:
1187: END IF;
1188:
1189: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1190: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.SUBMIT_BUSINESS_PROCESS.end'', ''<>'');
1191: END IF;
1192: END;
1193:
1194:

Line 1210: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1206: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', 'GCS_DYN_EPB_DATATR_PKG',1, r - 1, 'FALSE', err);
1207:
1208: -- dbms_output.put_line('Error' || AD_DDL.error_buf);
1209:
1210: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_EPB_DATATR_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
1212: GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DATATR_PKG' ||
1213: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1214: END IF;

Line 1211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_EPB_DATATR_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',

1207:
1208: -- dbms_output.put_line('Error' || AD_DDL.error_buf);
1209:
1210: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_EPB_DATATR_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
1212: GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DATATR_PKG' ||
1213: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1214: END IF;
1215: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DATATR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 1219: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

1215: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DATATR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1216:
1217: EXCEPTION
1218: WHEN OTHERS THEN
1219: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1220: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1221: 'GCS_BUILD_EPB_DATA_TR_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
1222: SUBSTR(SQLERRM, 1, 255));
1223: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

Line 1220: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

1216:
1217: EXCEPTION
1218: WHEN OTHERS THEN
1219: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1220: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1221: 'GCS_BUILD_EPB_DATA_TR_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
1222: SUBSTR(SQLERRM, 1, 255));
1223: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1224: 'GCS_BUILD_EPB_DATA_TR_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',

Line 1223: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

1219: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1220: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1221: 'GCS_BUILD_EPB_DATA_TR_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
1222: SUBSTR(SQLERRM, 1, 255));
1223: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1224: 'GCS_BUILD_EPB_DATA_TR_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
1225: GCS_UTILITY_PKG.g_module_failure || 'BUILD_EPB_DATATR_PKG' ||
1226: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1227: END IF;