DBA Data[Home] [Help]

APPS.BSC_MO_INDICATOR_PKG dependencies on FND_MESSAGE

Line 1154: fnd_message.set_name('BSC', 'BSC_RETR_DIMSET_KPI_FAILED');

1150:
1151: EXCEPTION WHEN OTHERS THEN
1152: g_error := sqlerrm;
1153: bsc_mo_helper_pkg.TerminateWithMsg('Exception in GetConfigurationsForIndic for Indic='||Indic||', error is '||g_error);
1154: fnd_message.set_name('BSC', 'BSC_RETR_DIMSET_KPI_FAILED');
1155: fnd_message.set_token('INDICATOR', Indic);
1156: app_exception.raise_exception;
1157:
1158:

Line 1155: fnd_message.set_token('INDICATOR', Indic);

1151: EXCEPTION WHEN OTHERS THEN
1152: g_error := sqlerrm;
1153: bsc_mo_helper_pkg.TerminateWithMsg('Exception in GetConfigurationsForIndic for Indic='||Indic||', error is '||g_error);
1154: fnd_message.set_name('BSC', 'BSC_RETR_DIMSET_KPI_FAILED');
1155: fnd_message.set_token('INDICATOR', Indic);
1156: app_exception.raise_exception;
1157:
1158:
1159: End;

Line 2031: fnd_message.set_name('BSC', 'BSC_KPICONFIG_SYSTABLES_FAILED');

2027:
2028: EXCEPTION WHEN OTHERS THEN
2029: l_stmt := sqlerrm;
2030: bsc_mo_helper_pkg.writeTmp( 'exception in deduce_and_configure_s_tables:'||l_stmt, FND_LOG.LEVEL_UNEXPECTED, true);
2031: fnd_message.set_name('BSC', 'BSC_KPICONFIG_SYSTABLES_FAILED');
2032: fnd_message.set_token('INDICATOR', Indicator.code);
2033: fnd_message.set_token('DIMENSION_SET', Configuration);
2034: g_error := fnd_message.get;
2035: bsc_mo_helper_pkg.terminatewithMsg(g_error);

Line 2032: fnd_message.set_token('INDICATOR', Indicator.code);

2028: EXCEPTION WHEN OTHERS THEN
2029: l_stmt := sqlerrm;
2030: bsc_mo_helper_pkg.writeTmp( 'exception in deduce_and_configure_s_tables:'||l_stmt, FND_LOG.LEVEL_UNEXPECTED, true);
2031: fnd_message.set_name('BSC', 'BSC_KPICONFIG_SYSTABLES_FAILED');
2032: fnd_message.set_token('INDICATOR', Indicator.code);
2033: fnd_message.set_token('DIMENSION_SET', Configuration);
2034: g_error := fnd_message.get;
2035: bsc_mo_helper_pkg.terminatewithMsg(g_error);
2036: raise;

Line 2033: fnd_message.set_token('DIMENSION_SET', Configuration);

2029: l_stmt := sqlerrm;
2030: bsc_mo_helper_pkg.writeTmp( 'exception in deduce_and_configure_s_tables:'||l_stmt, FND_LOG.LEVEL_UNEXPECTED, true);
2031: fnd_message.set_name('BSC', 'BSC_KPICONFIG_SYSTABLES_FAILED');
2032: fnd_message.set_token('INDICATOR', Indicator.code);
2033: fnd_message.set_token('DIMENSION_SET', Configuration);
2034: g_error := fnd_message.get;
2035: bsc_mo_helper_pkg.terminatewithMsg(g_error);
2036: raise;
2037:

Line 2034: g_error := fnd_message.get;

2030: bsc_mo_helper_pkg.writeTmp( 'exception in deduce_and_configure_s_tables:'||l_stmt, FND_LOG.LEVEL_UNEXPECTED, true);
2031: fnd_message.set_name('BSC', 'BSC_KPICONFIG_SYSTABLES_FAILED');
2032: fnd_message.set_token('INDICATOR', Indicator.code);
2033: fnd_message.set_token('DIMENSION_SET', Configuration);
2034: g_error := fnd_message.get;
2035: bsc_mo_helper_pkg.terminatewithMsg(g_error);
2036: raise;
2037:
2038: End ;

Line 2384: fnd_message.set_name('BSC', 'BSC_REL_DEDUCTION_FAILED');

2380:
2381: EXCEPTION WHEN OTHERS THEN
2382: g_error := sqlerrm;
2383: bsc_mo_helper_pkg.TerminateWithMsg('Exception in DeduceInternalGraph : '||g_error);
2384: fnd_message.set_name('BSC', 'BSC_REL_DEDUCTION_FAILED');
2385: app_exception.raise_exception;
2386: End;
2387:
2388:

Line 2982: fnd_message.set_name('BSC', 'BSC_BASICTABLE_DEDUCT_FAILED');

2978: return colBasicaTablas;
2979:
2980: EXCEPTION WHEN OTHERS THEN
2981: bsc_mo_helper_pkg.TerminateWithError('BSC_BASICTABLE_DEDUCT_FAILED');
2982: fnd_message.set_name('BSC', 'BSC_BASICTABLE_DEDUCT_FAILED');
2983: fnd_message.set_token('INDICATOR', Indicator.code);
2984: fnd_message.set_token('DIMENSION_SET', Configuration);
2985:
2986: app_exception.raise_exception;

Line 2983: fnd_message.set_token('INDICATOR', Indicator.code);

2979:
2980: EXCEPTION WHEN OTHERS THEN
2981: bsc_mo_helper_pkg.TerminateWithError('BSC_BASICTABLE_DEDUCT_FAILED');
2982: fnd_message.set_name('BSC', 'BSC_BASICTABLE_DEDUCT_FAILED');
2983: fnd_message.set_token('INDICATOR', Indicator.code);
2984: fnd_message.set_token('DIMENSION_SET', Configuration);
2985:
2986: app_exception.raise_exception;
2987:

Line 2984: fnd_message.set_token('DIMENSION_SET', Configuration);

2980: EXCEPTION WHEN OTHERS THEN
2981: bsc_mo_helper_pkg.TerminateWithError('BSC_BASICTABLE_DEDUCT_FAILED');
2982: fnd_message.set_name('BSC', 'BSC_BASICTABLE_DEDUCT_FAILED');
2983: fnd_message.set_token('INDICATOR', Indicator.code);
2984: fnd_message.set_token('DIMENSION_SET', Configuration);
2985:
2986: app_exception.raise_exception;
2987:
2988:

Line 3614: fnd_message.set_name('BSC', 'BSC_PMA_OPT_DUP_MEASURE');

3610: If DataFieldExistsForSource(l_col_measure_columns, l_measure_names_list(i), l_source) THEN
3611: null;--ignore this as we may have a, b and (a+b)
3612: ELSE
3613: -- raise error, two measures with same name (possibly one PMF and one BSC)
3614: fnd_message.set_name('BSC', 'BSC_PMA_OPT_DUP_MEASURE');
3615: fnd_message.set_token('OBJECTIVE', Indic);
3616: fnd_message.set_token('MEASURE_NAME', l_measure_names_list(i));
3617: g_error := fnd_message.get;
3618: bsc_mo_helper_pkg.writeTmp('ERROR BSC_PMA_OPT_DUP_MEASURE(Duplicate measure names) : '||g_error, FND_LOG.LEVEL_EXCEPTION, true);

Line 3615: fnd_message.set_token('OBJECTIVE', Indic);

3611: null;--ignore this as we may have a, b and (a+b)
3612: ELSE
3613: -- raise error, two measures with same name (possibly one PMF and one BSC)
3614: fnd_message.set_name('BSC', 'BSC_PMA_OPT_DUP_MEASURE');
3615: fnd_message.set_token('OBJECTIVE', Indic);
3616: fnd_message.set_token('MEASURE_NAME', l_measure_names_list(i));
3617: g_error := fnd_message.get;
3618: bsc_mo_helper_pkg.writeTmp('ERROR BSC_PMA_OPT_DUP_MEASURE(Duplicate measure names) : '||g_error, FND_LOG.LEVEL_EXCEPTION, true);
3619: bsc_mo_helper_pkg.terminateWithMsg(g_error);

Line 3616: fnd_message.set_token('MEASURE_NAME', l_measure_names_list(i));

3612: ELSE
3613: -- raise error, two measures with same name (possibly one PMF and one BSC)
3614: fnd_message.set_name('BSC', 'BSC_PMA_OPT_DUP_MEASURE');
3615: fnd_message.set_token('OBJECTIVE', Indic);
3616: fnd_message.set_token('MEASURE_NAME', l_measure_names_list(i));
3617: g_error := fnd_message.get;
3618: bsc_mo_helper_pkg.writeTmp('ERROR BSC_PMA_OPT_DUP_MEASURE(Duplicate measure names) : '||g_error, FND_LOG.LEVEL_EXCEPTION, true);
3619: bsc_mo_helper_pkg.terminateWithMsg(g_error);
3620: raise bsc_metadata_optimizer_pkg.optimizer_exception ;

Line 3617: g_error := fnd_message.get;

3613: -- raise error, two measures with same name (possibly one PMF and one BSC)
3614: fnd_message.set_name('BSC', 'BSC_PMA_OPT_DUP_MEASURE');
3615: fnd_message.set_token('OBJECTIVE', Indic);
3616: fnd_message.set_token('MEASURE_NAME', l_measure_names_list(i));
3617: g_error := fnd_message.get;
3618: bsc_mo_helper_pkg.writeTmp('ERROR BSC_PMA_OPT_DUP_MEASURE(Duplicate measure names) : '||g_error, FND_LOG.LEVEL_EXCEPTION, true);
3619: bsc_mo_helper_pkg.terminateWithMsg(g_error);
3620: raise bsc_metadata_optimizer_pkg.optimizer_exception ;
3621: EXIT ;

Line 3625: fnd_message.set_name('BSC', 'BSC_FIELDNME_NOT_REGISTERED');

3621: EXIT ;
3622: END IF;
3623: END IF;
3624: Else
3625: fnd_message.set_name('BSC', 'BSC_FIELDNME_NOT_REGISTERED');
3626: fnd_message.set_token('FIELD_NAME', l_measure_names_list(i));
3627: fnd_message.set_token('INDICATOR_CODE', Indic);
3628: g_error := fnd_message.get;
3629: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

Line 3626: fnd_message.set_token('FIELD_NAME', l_measure_names_list(i));

3622: END IF;
3623: END IF;
3624: Else
3625: fnd_message.set_name('BSC', 'BSC_FIELDNME_NOT_REGISTERED');
3626: fnd_message.set_token('FIELD_NAME', l_measure_names_list(i));
3627: fnd_message.set_token('INDICATOR_CODE', Indic);
3628: g_error := fnd_message.get;
3629: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
3630: bsc_mo_helper_pkg.writeTmp(g_error);

Line 3627: fnd_message.set_token('INDICATOR_CODE', Indic);

3623: END IF;
3624: Else
3625: fnd_message.set_name('BSC', 'BSC_FIELDNME_NOT_REGISTERED');
3626: fnd_message.set_token('FIELD_NAME', l_measure_names_list(i));
3627: fnd_message.set_token('INDICATOR_CODE', Indic);
3628: g_error := fnd_message.get;
3629: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
3630: bsc_mo_helper_pkg.writeTmp(g_error);
3631: bsc_mo_helper_pkg.writeTmp('ERROR : BSC_FIELDNME_NOT_REGISTERED : '||g_error);

Line 3628: g_error := fnd_message.get;

3624: Else
3625: fnd_message.set_name('BSC', 'BSC_FIELDNME_NOT_REGISTERED');
3626: fnd_message.set_token('FIELD_NAME', l_measure_names_list(i));
3627: fnd_message.set_token('INDICATOR_CODE', Indic);
3628: g_error := fnd_message.get;
3629: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
3630: bsc_mo_helper_pkg.writeTmp(g_error);
3631: bsc_mo_helper_pkg.writeTmp('ERROR : BSC_FIELDNME_NOT_REGISTERED : '||g_error);
3632: END IF;

Line 3713: fnd_message.set_name('BSC', 'BSC_BASICTABLE_DEDUCT_FAILED');

3709: close cv;
3710: bsc_mo_helper_pkg.writeTmp( 'Compl. GetDataFields, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, false);
3711: return l_col_measure_columns;
3712: EXCEPTION WHEN OTHERS THEN
3713: fnd_message.set_name('BSC', 'BSC_BASICTABLE_DEDUCT_FAILED');
3714: fnd_message.set_token('INDICATOR', Indic);
3715: fnd_message.set_token('DIMENSION_SET', Configuration);
3716: g_error := fnd_message.get;
3717: bsc_mo_helper_pkg.terminatewithMsg(g_error);

Line 3714: fnd_message.set_token('INDICATOR', Indic);

3710: bsc_mo_helper_pkg.writeTmp( 'Compl. GetDataFields, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, false);
3711: return l_col_measure_columns;
3712: EXCEPTION WHEN OTHERS THEN
3713: fnd_message.set_name('BSC', 'BSC_BASICTABLE_DEDUCT_FAILED');
3714: fnd_message.set_token('INDICATOR', Indic);
3715: fnd_message.set_token('DIMENSION_SET', Configuration);
3716: g_error := fnd_message.get;
3717: bsc_mo_helper_pkg.terminatewithMsg(g_error);
3718: raise;

Line 3715: fnd_message.set_token('DIMENSION_SET', Configuration);

3711: return l_col_measure_columns;
3712: EXCEPTION WHEN OTHERS THEN
3713: fnd_message.set_name('BSC', 'BSC_BASICTABLE_DEDUCT_FAILED');
3714: fnd_message.set_token('INDICATOR', Indic);
3715: fnd_message.set_token('DIMENSION_SET', Configuration);
3716: g_error := fnd_message.get;
3717: bsc_mo_helper_pkg.terminatewithMsg(g_error);
3718: raise;
3719: --app_exception.raise_exception;

Line 3716: g_error := fnd_message.get;

3712: EXCEPTION WHEN OTHERS THEN
3713: fnd_message.set_name('BSC', 'BSC_BASICTABLE_DEDUCT_FAILED');
3714: fnd_message.set_token('INDICATOR', Indic);
3715: fnd_message.set_token('DIMENSION_SET', Configuration);
3716: g_error := fnd_message.get;
3717: bsc_mo_helper_pkg.terminatewithMsg(g_error);
3718: raise;
3719: --app_exception.raise_exception;
3720:

Line 4386: fnd_message.set_name('BSC', 'BSC_RETR_DIM_KPI_FAILED');

4382: return l_dimension_families;
4383: EXCEPTION WHEN OTHERS THEN
4384: l_stmt := sqlerrm;
4385: bsc_mo_helper_pkg.TerminateWithMsg( ' Exception in GetLevelCollection : '||l_stmt);
4386: fnd_message.set_name('BSC', 'BSC_RETR_DIM_KPI_FAILED');
4387: fnd_message.set_token('INDICATOR', Indic);
4388: fnd_message.set_token('DIMENSION_SET', Configuration);
4389: g_error := fnd_message.get;
4390: bsc_mo_helper_pkg.terminatewithMsg(g_error);

Line 4387: fnd_message.set_token('INDICATOR', Indic);

4383: EXCEPTION WHEN OTHERS THEN
4384: l_stmt := sqlerrm;
4385: bsc_mo_helper_pkg.TerminateWithMsg( ' Exception in GetLevelCollection : '||l_stmt);
4386: fnd_message.set_name('BSC', 'BSC_RETR_DIM_KPI_FAILED');
4387: fnd_message.set_token('INDICATOR', Indic);
4388: fnd_message.set_token('DIMENSION_SET', Configuration);
4389: g_error := fnd_message.get;
4390: bsc_mo_helper_pkg.terminatewithMsg(g_error);
4391: raise;

Line 4388: fnd_message.set_token('DIMENSION_SET', Configuration);

4384: l_stmt := sqlerrm;
4385: bsc_mo_helper_pkg.TerminateWithMsg( ' Exception in GetLevelCollection : '||l_stmt);
4386: fnd_message.set_name('BSC', 'BSC_RETR_DIM_KPI_FAILED');
4387: fnd_message.set_token('INDICATOR', Indic);
4388: fnd_message.set_token('DIMENSION_SET', Configuration);
4389: g_error := fnd_message.get;
4390: bsc_mo_helper_pkg.terminatewithMsg(g_error);
4391: raise;
4392: --app_exception.raise_exception;

Line 4389: g_error := fnd_message.get;

4385: bsc_mo_helper_pkg.TerminateWithMsg( ' Exception in GetLevelCollection : '||l_stmt);
4386: fnd_message.set_name('BSC', 'BSC_RETR_DIM_KPI_FAILED');
4387: fnd_message.set_token('INDICATOR', Indic);
4388: fnd_message.set_token('DIMENSION_SET', Configuration);
4389: g_error := fnd_message.get;
4390: bsc_mo_helper_pkg.terminatewithMsg(g_error);
4391: raise;
4392: --app_exception.raise_exception;
4393:

Line 4495: fnd_message.set_name('BSC', 'BSC_RETR_KPI_PERIOD_FAILED');

4491:
4492:
4493: EXCEPTION WHEN OTHERS THEN
4494: BSC_MO_HELPER_PKG.TerminateWithError('BSC_RETR_KPI_PERIOD_FAILED');
4495: fnd_message.set_name('BSC', 'BSC_RETR_KPI_PERIOD_FAILED');
4496: fnd_message.set_token('INDICATOR', Indic);
4497: app_exception.raise_exception;
4498:
4499: End;

Line 4496: fnd_message.set_token('INDICATOR', Indic);

4492:
4493: EXCEPTION WHEN OTHERS THEN
4494: BSC_MO_HELPER_PKG.TerminateWithError('BSC_RETR_KPI_PERIOD_FAILED');
4495: fnd_message.set_name('BSC', 'BSC_RETR_KPI_PERIOD_FAILED');
4496: fnd_message.set_token('INDICATOR', Indic);
4497: app_exception.raise_exception;
4498:
4499: End;
4500:

Line 4638: fnd_message.set_name('BSC', 'BSC_KPI_TBLS_SET_DEDUCT_FAILED');

4634: END IF;
4635: bsc_mo_helper_pkg.writeTmp( 'Compl ConfigureIndics, system time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
4636: EXCEPTION WHEN OTHERS THEN
4637: bsc_mo_helper_pkg.writeTmp( 'Exception in ConfigureIndics : '||sqlerrm, fnd_log.level_exception, true);
4638: fnd_message.set_name('BSC', 'BSC_KPI_TBLS_SET_DEDUCT_FAILED');
4639: fnd_message.set_token('INDICATOR', Indicator.code);
4640: fnd_message.set_token('DIMENSION_SET', Configuration);
4641: g_error := fnd_message.get ;
4642: bsc_mo_helper_pkg.terminatewithMsg(g_error);

Line 4639: fnd_message.set_token('INDICATOR', Indicator.code);

4635: bsc_mo_helper_pkg.writeTmp( 'Compl ConfigureIndics, system time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
4636: EXCEPTION WHEN OTHERS THEN
4637: bsc_mo_helper_pkg.writeTmp( 'Exception in ConfigureIndics : '||sqlerrm, fnd_log.level_exception, true);
4638: fnd_message.set_name('BSC', 'BSC_KPI_TBLS_SET_DEDUCT_FAILED');
4639: fnd_message.set_token('INDICATOR', Indicator.code);
4640: fnd_message.set_token('DIMENSION_SET', Configuration);
4641: g_error := fnd_message.get ;
4642: bsc_mo_helper_pkg.terminatewithMsg(g_error);
4643: raise;

Line 4640: fnd_message.set_token('DIMENSION_SET', Configuration);

4636: EXCEPTION WHEN OTHERS THEN
4637: bsc_mo_helper_pkg.writeTmp( 'Exception in ConfigureIndics : '||sqlerrm, fnd_log.level_exception, true);
4638: fnd_message.set_name('BSC', 'BSC_KPI_TBLS_SET_DEDUCT_FAILED');
4639: fnd_message.set_token('INDICATOR', Indicator.code);
4640: fnd_message.set_token('DIMENSION_SET', Configuration);
4641: g_error := fnd_message.get ;
4642: bsc_mo_helper_pkg.terminatewithMsg(g_error);
4643: raise;
4644: End;

Line 4641: g_error := fnd_message.get ;

4637: bsc_mo_helper_pkg.writeTmp( 'Exception in ConfigureIndics : '||sqlerrm, fnd_log.level_exception, true);
4638: fnd_message.set_name('BSC', 'BSC_KPI_TBLS_SET_DEDUCT_FAILED');
4639: fnd_message.set_token('INDICATOR', Indicator.code);
4640: fnd_message.set_token('DIMENSION_SET', Configuration);
4641: g_error := fnd_message.get ;
4642: bsc_mo_helper_pkg.terminatewithMsg(g_error);
4643: raise;
4644: End;
4645:

Line 4681: fnd_message.set_name('BSC', 'BSC_RETR_DIMSET_KPI_FAILED');

4677: return colConfigurations;
4678: EXCEPTION WHEN OTHERS THEN
4679: g_error := sqlerrm;
4680: bsc_mo_helper_pkg.TerminateWithMsg(' Exception in GetColConfigForIndic : '||g_error);
4681: fnd_message.set_name('BSC', 'BSC_RETR_DIMSET_KPI_FAILED');
4682: fnd_message.set_token('INDICATOR', Indic);
4683: app_exception.raise_exception;
4684: End;
4685: --***************************************************************************

Line 4682: fnd_message.set_token('INDICATOR', Indic);

4678: EXCEPTION WHEN OTHERS THEN
4679: g_error := sqlerrm;
4680: bsc_mo_helper_pkg.TerminateWithMsg(' Exception in GetColConfigForIndic : '||g_error);
4681: fnd_message.set_name('BSC', 'BSC_RETR_DIMSET_KPI_FAILED');
4682: fnd_message.set_token('INDICATOR', Indic);
4683: app_exception.raise_exception;
4684: End;
4685: --***************************************************************************
4686: --TablasIndicatores