eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_MO_DOC_PKG dependencies on FND_MESSAGE

Line 355: fnd_message.set_name('BSC', 'BSC_NO_CHANGES_VERIF');

351: --No changes were made.
352: --BSC-MV Note: Show if there was a summarization level change
353: If BSC_METADATA_OPTIMIZER_PKG.g_Sum_Level_Change = 0 Then
354: --No changes were made.
355: fnd_message.set_name('BSC', 'BSC_NO_CHANGES_VERIF');
356: msg := fnd_message.get;
357: WriteLineTextFile (msg);
358: ShowITables := False;
359: ShowOldITables := False;

Line 356: msg := fnd_message.get;

352: --BSC-MV Note: Show if there was a summarization level change
353: If BSC_METADATA_OPTIMIZER_PKG.g_Sum_Level_Change = 0 Then
354: --No changes were made.
355: fnd_message.set_name('BSC', 'BSC_NO_CHANGES_VERIF');
356: msg := fnd_message.get;
357: WriteLineTextFile (msg);
358: ShowITables := False;
359: ShowOldITables := False;
360: Else

Line 365: fnd_message.set_name('BSC', 'BSC_INPUT_TABLES_NO_CHANGED');

361: --There was just a change in the summarization level
362: --Input tables were not changed
363: --Bug#3306248
364: WriteLineTextFile (l_sumLevelChangedMsg);
365: fnd_message.set_name('BSC', 'BSC_INPUT_TABLES_NO_CHANGED');
366: msg := fnd_message.get;
367: WriteLineTextFile (msg);
368: ShowITables := False;
369: ShowOldITables := False;

Line 366: msg := fnd_message.get;

362: --Input tables were not changed
363: --Bug#3306248
364: WriteLineTextFile (l_sumLevelChangedMsg);
365: fnd_message.set_name('BSC', 'BSC_INPUT_TABLES_NO_CHANGED');
366: msg := fnd_message.get;
367: WriteLineTextFile (msg);
368: ShowITables := False;
369: ShowOldITables := False;
370: End If;

Line 377: fnd_message.set_name('BSC', 'BSC_ADD_DROP_DIMENSION');

373: If BSC_MO_HELPER_PKG.findIndex(BSC_METADATA_OPTIMIZER_PKG.garrOldIndicators, Indicator.Code)>=0 Then
374: --Structural changes: Add or drop a dimension, data set, analysis group, etc.
375: msg := BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'STRUCTURAL_CHANGE');
376: msg := msg || BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'SYMBOL_COLON');
377: fnd_message.set_name('BSC', 'BSC_ADD_DROP_DIMENSION');
378: msg := msg || ' ' ||fnd_message.get;
379: WriteLineTextFile (msg);
380: --Bug#3306248
381: If BSC_METADATA_OPTIMIZER_PKG.g_Sum_Level_Change <> 0 Then

Line 378: msg := msg || ' ' ||fnd_message.get;

374: --Structural changes: Add or drop a dimension, data set, analysis group, etc.
375: msg := BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'STRUCTURAL_CHANGE');
376: msg := msg || BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'SYMBOL_COLON');
377: fnd_message.set_name('BSC', 'BSC_ADD_DROP_DIMENSION');
378: msg := msg || ' ' ||fnd_message.get;
379: WriteLineTextFile (msg);
380: --Bug#3306248
381: If BSC_METADATA_OPTIMIZER_PKG.g_Sum_Level_Change <> 0 Then
382: WriteLineTextFile (l_sumLevelChangedMsg);

Line 410: fnd_message.set_name('BSC', 'BSC_INPUT_TABLES_NO_CHANGED');

406: --Bug#3306248
407: If BSC_METADATA_OPTIMIZER_PKG.g_Sum_Level_Change <> 0 Then
408: WriteLineTextFile (l_sumLevelChangedMsg);
409: End If;
410: fnd_message.set_name('BSC', 'BSC_INPUT_TABLES_NO_CHANGED');
411: msg := fnd_message.get;
412: WriteLineTextFile (msg);
413: ShowITables := False;
414: ShowOldITables := False;

Line 411: msg := fnd_message.get;

407: If BSC_METADATA_OPTIMIZER_PKG.g_Sum_Level_Change <> 0 Then
408: WriteLineTextFile (l_sumLevelChangedMsg);
409: End If;
410: fnd_message.set_name('BSC', 'BSC_INPUT_TABLES_NO_CHANGED');
411: msg := fnd_message.get;
412: WriteLineTextFile (msg);
413: ShowITables := False;
414: ShowOldITables := False;
415: --Case Else

Line 686: fnd_message.set_name('BSC', 'BSC_TABLE_FOR_BENCHMARKS');

682: --BSC-MV Note
683: If (BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV And (Tabla.Type = 0 Or isBaseTable)) Or (Not BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV) Then
684: WriteLineTextFile (StrFix(BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'TABLE') || BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'SYMBOL_COLON') || ' ', TABLELENGTH) || TableName);
685: If Tabla.IsTargetTable Then
686: fnd_message.set_name('BSC', 'BSC_TABLE_FOR_BENCHMARKS');
687: WriteLineTextFile (StrFix(' ', TABLELENGTH) || fnd_message.get);
688: End If;
689: WriteLineTextFile (StrFix(BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'PERIODICITY') || BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'SYMBOL_COLON') || ' ', TABLELENGTH) || l_periodicity_name);
690: Else

Line 687: WriteLineTextFile (StrFix(' ', TABLELENGTH) || fnd_message.get);

683: If (BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV And (Tabla.Type = 0 Or isBaseTable)) Or (Not BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV) Then
684: WriteLineTextFile (StrFix(BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'TABLE') || BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'SYMBOL_COLON') || ' ', TABLELENGTH) || TableName);
685: If Tabla.IsTargetTable Then
686: fnd_message.set_name('BSC', 'BSC_TABLE_FOR_BENCHMARKS');
687: WriteLineTextFile (StrFix(' ', TABLELENGTH) || fnd_message.get);
688: End If;
689: WriteLineTextFile (StrFix(BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'PERIODICITY') || BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'SYMBOL_COLON') || ' ', TABLELENGTH) || l_periodicity_name);
690: Else
691: If Tabla.dbObjectType = 'VIEW' Then

Line 815: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');

811: Else
812: Linea := Linea || BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'CODE');
813: End If;
814: l_temp := BSC_MO_HELPER_PKG.findKeyIndex(BSC_METADATA_OPTIMIZER_PKG.gMasterTable, rsColumn_Name);
815: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
816: IF (l_temp <> -1) THEN
817: fnd_message.set_token('TABLE_NAME', BSC_METADATA_OPTIMIZER_PKG.gMasterTable(l_temp).Name );
818: msg := fnd_message.get;
819: Linea := Linea || ' (' || msg || ')';

Line 817: fnd_message.set_token('TABLE_NAME', BSC_METADATA_OPTIMIZER_PKG.gMasterTable(l_temp).Name );

813: End If;
814: l_temp := BSC_MO_HELPER_PKG.findKeyIndex(BSC_METADATA_OPTIMIZER_PKG.gMasterTable, rsColumn_Name);
815: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
816: IF (l_temp <> -1) THEN
817: fnd_message.set_token('TABLE_NAME', BSC_METADATA_OPTIMIZER_PKG.gMasterTable(l_temp).Name );
818: msg := fnd_message.get;
819: Linea := Linea || ' (' || msg || ')';
820: END IF;
821: If Tabla.Type = 0 Then --input table

Line 818: msg := fnd_message.get;

814: l_temp := BSC_MO_HELPER_PKG.findKeyIndex(BSC_METADATA_OPTIMIZER_PKG.gMasterTable, rsColumn_Name);
815: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
816: IF (l_temp <> -1) THEN
817: fnd_message.set_token('TABLE_NAME', BSC_METADATA_OPTIMIZER_PKG.gMasterTable(l_temp).Name );
818: msg := fnd_message.get;
819: Linea := Linea || ' (' || msg || ')';
820: END IF;
821: If Tabla.Type = 0 Then --input table
822: l_temp := BSC_MO_HELPER_PKG.findIndex(Table_Keys, rsColumn_Name);

Line 893: fnd_message.set_name ('BSC', 'BSC_TABLENAME_DESCR_FAILED');

889: WriteLineTextFile ('');
890: EXCEPTION WHEN OTHERS THEN
891: g_error := sqlerrm;
892: BSC_MO_HELPER_PKG.TerminateWithMsg('Exception in Documentation.writeTableDescription :' ||sqlerrm);
893: fnd_message.set_name ('BSC', 'BSC_TABLENAME_DESCR_FAILED');
894: fnd_message.set_token('TABLE_NAME', Tabla.name);
895: g_error := fnd_message.get;
896: BSC_MO_HELPER_PKG.TerminateWithMsg(g_error);
897: raise;

Line 894: fnd_message.set_token('TABLE_NAME', Tabla.name);

890: EXCEPTION WHEN OTHERS THEN
891: g_error := sqlerrm;
892: BSC_MO_HELPER_PKG.TerminateWithMsg('Exception in Documentation.writeTableDescription :' ||sqlerrm);
893: fnd_message.set_name ('BSC', 'BSC_TABLENAME_DESCR_FAILED');
894: fnd_message.set_token('TABLE_NAME', Tabla.name);
895: g_error := fnd_message.get;
896: BSC_MO_HELPER_PKG.TerminateWithMsg(g_error);
897: raise;
898: End ;

Line 895: g_error := fnd_message.get;

891: g_error := sqlerrm;
892: BSC_MO_HELPER_PKG.TerminateWithMsg('Exception in Documentation.writeTableDescription :' ||sqlerrm);
893: fnd_message.set_name ('BSC', 'BSC_TABLENAME_DESCR_FAILED');
894: fnd_message.set_token('TABLE_NAME', Tabla.name);
895: g_error := fnd_message.get;
896: BSC_MO_HELPER_PKG.TerminateWithMsg(g_error);
897: raise;
898: End ;
899: --****************************************************************************

Line 1826: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');

1822: End If;
1823: If UPPER(substr(rsColumn_Name, -4)) = '_USR' Then
1824: iRel := BSC_MO_HELPER_PKG.findKeyIndex(BSC_METADATA_OPTIMIZER_PKG.gMasterTable, substr(rsColumn_Name, 1, Length(rsColumn_Name) - 4));
1825: If iRel <> -1 Then
1826: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
1827: fnd_message.set_token('TABLE_NAME', BSC_METADATA_OPTIMIZER_PKG.gMasterTable(iRel).Name || '.USER_CODE');
1828: msg := fnd_message.get;
1829: Linea := Linea || StrFix(msg, DESCLENGTH);
1830: End If;

Line 1827: fnd_message.set_token('TABLE_NAME', BSC_METADATA_OPTIMIZER_PKG.gMasterTable(iRel).Name || '.USER_CODE');

1823: If UPPER(substr(rsColumn_Name, -4)) = '_USR' Then
1824: iRel := BSC_MO_HELPER_PKG.findKeyIndex(BSC_METADATA_OPTIMIZER_PKG.gMasterTable, substr(rsColumn_Name, 1, Length(rsColumn_Name) - 4));
1825: If iRel <> -1 Then
1826: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
1827: fnd_message.set_token('TABLE_NAME', BSC_METADATA_OPTIMIZER_PKG.gMasterTable(iRel).Name || '.USER_CODE');
1828: msg := fnd_message.get;
1829: Linea := Linea || StrFix(msg, DESCLENGTH);
1830: End If;
1831: Else

Line 1828: msg := fnd_message.get;

1824: iRel := BSC_MO_HELPER_PKG.findKeyIndex(BSC_METADATA_OPTIMIZER_PKG.gMasterTable, substr(rsColumn_Name, 1, Length(rsColumn_Name) - 4));
1825: If iRel <> -1 Then
1826: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
1827: fnd_message.set_token('TABLE_NAME', BSC_METADATA_OPTIMIZER_PKG.gMasterTable(iRel).Name || '.USER_CODE');
1828: msg := fnd_message.get;
1829: Linea := Linea || StrFix(msg, DESCLENGTH);
1830: End If;
1831: Else
1832: iRel := BSC_MO_HELPER_PKG.findKeyIndex(BSC_METADATA_OPTIMIZER_PKG.gMasterTable, rsColumn_Name);

Line 1834: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');

1830: End If;
1831: Else
1832: iRel := BSC_MO_HELPER_PKG.findKeyIndex(BSC_METADATA_OPTIMIZER_PKG.gMasterTable, rsColumn_Name);
1833: If iRel <> -1 Then
1834: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
1835: fnd_message.set_token('TABLE_NAME', BSC_METADATA_OPTIMIZER_PKG.gMasterTable(iRel).Name || '.CODE');
1836: msg := fnd_message.get;
1837: Linea := Linea || StrFix(msg, DESCLENGTH);
1838: End If;

Line 1835: fnd_message.set_token('TABLE_NAME', BSC_METADATA_OPTIMIZER_PKG.gMasterTable(iRel).Name || '.CODE');

1831: Else
1832: iRel := BSC_MO_HELPER_PKG.findKeyIndex(BSC_METADATA_OPTIMIZER_PKG.gMasterTable, rsColumn_Name);
1833: If iRel <> -1 Then
1834: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
1835: fnd_message.set_token('TABLE_NAME', BSC_METADATA_OPTIMIZER_PKG.gMasterTable(iRel).Name || '.CODE');
1836: msg := fnd_message.get;
1837: Linea := Linea || StrFix(msg, DESCLENGTH);
1838: End If;
1839: End If;

Line 1836: msg := fnd_message.get;

1832: iRel := BSC_MO_HELPER_PKG.findKeyIndex(BSC_METADATA_OPTIMIZER_PKG.gMasterTable, rsColumn_Name);
1833: If iRel <> -1 Then
1834: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
1835: fnd_message.set_token('TABLE_NAME', BSC_METADATA_OPTIMIZER_PKG.gMasterTable(iRel).Name || '.CODE');
1836: msg := fnd_message.get;
1837: Linea := Linea || StrFix(msg, DESCLENGTH);
1838: End If;
1839: End If;
1840: WriteLineTextFile (Linea);

Line 1946: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');

1942: --Input table
1943: TableName := Tabla.InputTable;
1944: Else
1945: If Tabla.Source = 'BSC' Then
1946: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
1947: fnd_message.set_token('TABLE_NAME', Tabla.InputTable);
1948: msg := fnd_message.get;
1949: TableName := Tabla.Name || '(' || msg || ')';
1950: Else

Line 1947: fnd_message.set_token('TABLE_NAME', Tabla.InputTable);

1943: TableName := Tabla.InputTable;
1944: Else
1945: If Tabla.Source = 'BSC' Then
1946: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
1947: fnd_message.set_token('TABLE_NAME', Tabla.InputTable);
1948: msg := fnd_message.get;
1949: TableName := Tabla.Name || '(' || msg || ')';
1950: Else
1951: TableName := Tabla.Name;

Line 1948: msg := fnd_message.get;

1944: Else
1945: If Tabla.Source = 'BSC' Then
1946: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
1947: fnd_message.set_token('TABLE_NAME', Tabla.InputTable);
1948: msg := fnd_message.get;
1949: TableName := Tabla.Name || '(' || msg || ')';
1950: Else
1951: TableName := Tabla.Name;
1952: End If;

Line 2054: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');

2050: Else
2051: If UPPER(substr(rsColumn_Name, -4)) = '_USR' Then
2052: iRel := FindRelationIndex(Tabla.Name, substr(rsColumn_Name, 1, Length(rsColumn_Name) - 4));
2053: If iRel <> -1 Then
2054: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
2055: fnd_message.set_token('TABLE_NAME', l_Parents(iRel) ||'.USER_CODE');
2056: msg := fnd_message.get;
2057: Linea := Linea || StrFix(msg, DESCLENGTH);
2058: End If;

Line 2055: fnd_message.set_token('TABLE_NAME', l_Parents(iRel) ||'.USER_CODE');

2051: If UPPER(substr(rsColumn_Name, -4)) = '_USR' Then
2052: iRel := FindRelationIndex(Tabla.Name, substr(rsColumn_Name, 1, Length(rsColumn_Name) - 4));
2053: If iRel <> -1 Then
2054: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
2055: fnd_message.set_token('TABLE_NAME', l_Parents(iRel) ||'.USER_CODE');
2056: msg := fnd_message.get;
2057: Linea := Linea || StrFix(msg, DESCLENGTH);
2058: End If;
2059: Else

Line 2056: msg := fnd_message.get;

2052: iRel := FindRelationIndex(Tabla.Name, substr(rsColumn_Name, 1, Length(rsColumn_Name) - 4));
2053: If iRel <> -1 Then
2054: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
2055: fnd_message.set_token('TABLE_NAME', l_Parents(iRel) ||'.USER_CODE');
2056: msg := fnd_message.get;
2057: Linea := Linea || StrFix(msg, DESCLENGTH);
2058: End If;
2059: Else
2060: iRel := FindRelationIndex(Tabla.Name, rsColumn_Name);

Line 2062: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');

2058: End If;
2059: Else
2060: iRel := FindRelationIndex(Tabla.Name, rsColumn_Name);
2061: If iRel <> -1 Then
2062: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
2063: fnd_message.set_token('TABLE_NAME', l_Parents(iRel) ||'.CODE');
2064: msg := fnd_message.get;
2065: Linea := Linea || StrFix(msg, DESCLENGTH);
2066: End If;

Line 2063: fnd_message.set_token('TABLE_NAME', l_Parents(iRel) ||'.CODE');

2059: Else
2060: iRel := FindRelationIndex(Tabla.Name, rsColumn_Name);
2061: If iRel <> -1 Then
2062: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
2063: fnd_message.set_token('TABLE_NAME', l_Parents(iRel) ||'.CODE');
2064: msg := fnd_message.get;
2065: Linea := Linea || StrFix(msg, DESCLENGTH);
2066: End If;
2067: End If;

Line 2064: msg := fnd_message.get;

2060: iRel := FindRelationIndex(Tabla.Name, rsColumn_Name);
2061: If iRel <> -1 Then
2062: fnd_message.set_name('BSC', 'BSC_SEE_TABLE_NAME');
2063: fnd_message.set_token('TABLE_NAME', l_Parents(iRel) ||'.CODE');
2064: msg := fnd_message.get;
2065: Linea := Linea || StrFix(msg, DESCLENGTH);
2066: End If;
2067: End If;
2068: End If;