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.FND_NEW_MESSAGES_PKG dependencies on FND_LOOKUPS

Line 971: select count(*) into count_category from fnd_lookups

967: -- ******************************
968: -- Check for valid Category
969: -- ******************************
970: if (X_CATEGORY is not NULL) then
971: select count(*) into count_category from fnd_lookups
972: where lookup_type = 'FND_KBF_CATEGORY';
973: if ( count_category > 0 ) then
974: select count(*) into count_category from fnd_lookups
975: where lookup_type = 'FND_KBF_CATEGORY' AND

Line 974: select count(*) into count_category from fnd_lookups

970: if (X_CATEGORY is not NULL) then
971: select count(*) into count_category from fnd_lookups
972: where lookup_type = 'FND_KBF_CATEGORY';
973: if ( count_category > 0 ) then
974: select count(*) into count_category from fnd_lookups
975: where lookup_type = 'FND_KBF_CATEGORY' AND
976: lookup_code = X_CATEGORY;
977: if ( count_category = 0 ) then
978: fnd_message.set_name('FND', 'AFDICT_CATEGORY_NOT_VALID');

Line 989: select count(*) into count_severity from fnd_lookups

985: -- ******************************
986: -- Check for valid Severity
987: -- ******************************
988: if (X_SEVERITY is not NULL) then
989: select count(*) into count_severity from fnd_lookups
990: where lookup_type = 'FND_KBF_SEVERITY';
991: if ( count_severity > 0 ) then
992: select count(*) into count_severity from fnd_lookups
993: where lookup_type = 'FND_KBF_SEVERITY' AND

Line 992: select count(*) into count_severity from fnd_lookups

988: if (X_SEVERITY is not NULL) then
989: select count(*) into count_severity from fnd_lookups
990: where lookup_type = 'FND_KBF_SEVERITY';
991: if ( count_severity > 0 ) then
992: select count(*) into count_severity from fnd_lookups
993: where lookup_type = 'FND_KBF_SEVERITY' AND
994: lookup_code = X_SEVERITY;
995: if ( count_severity = 0 ) then
996: fnd_message.set_name('FND', 'AFDICT_SEVERITY_NOT_VALID');

Line 1007: select count(*) into count_severity from fnd_lookups

1003: -- ******************************
1004: -- Check for valid Fnd_Log_Severity
1005: -- ******************************
1006: if (X_FND_LOG_SEVERITY is not NULL) then
1007: select count(*) into count_severity from fnd_lookups
1008: where lookup_type = 'AFLOG_LEVELS';
1009: if ( count_severity > 0 ) then
1010: select count(*) into count_severity from fnd_lookups
1011: where lookup_type = 'AFLOG_LEVELS' AND

Line 1010: select count(*) into count_severity from fnd_lookups

1006: if (X_FND_LOG_SEVERITY is not NULL) then
1007: select count(*) into count_severity from fnd_lookups
1008: where lookup_type = 'AFLOG_LEVELS';
1009: if ( count_severity > 0 ) then
1010: select count(*) into count_severity from fnd_lookups
1011: where lookup_type = 'AFLOG_LEVELS' AND
1012: lookup_code = X_FND_LOG_SEVERITY;
1013: if ( count_severity = 0 ) then
1014: fnd_message.set_name('FND', 'AFDICT_SEVERITY_NOT_VALID');