APPS.FND_OAM_KBF_SUBS dependencies on FND_LOG_UNIQUE_EXCEPTIONS

Line 98: * pItemException comes from fnd_log_unique_exceptions which is ultimately

94: * CRITICAL
95: * ERROR
96: * WARNING
97: *
98: * pItemException comes from fnd_log_unique_exceptions which is ultimately
99: * from the message dictionary.
100: *
101: *
102: * Below logic should be:

Line 110: * fnd_log_unique_exceptions is ERROR or CRITICAL.

106: * if setup to get a notification for WARNING return true (because that is the
107: * lowest level in the message dictionary).
108: *
109: * if setup to get a notification for ERROR return true if the severity in
110: * fnd_log_unique_exceptions is ERROR or CRITICAL.
111: *
112: * if setup to only get CRITICAL notifications only return true if
113: * fnd_log_unique_exceptions has a CRITICAL severity.
114: *

Line 113: * fnd_log_unique_exceptions has a CRITICAL severity.

109: * if setup to get a notification for ERROR return true if the severity in
110: * fnd_log_unique_exceptions is ERROR or CRITICAL.
111: *
112: * if setup to only get CRITICAL notifications only return true if
113: * fnd_log_unique_exceptions has a CRITICAL severity.
114: *
115: * */
116:
117:

Line 272: FND_LOG_UNIQUE_EXCEPTIONS flue,

268: l_app_sn, l_severity, l_app_id, l_comp_type, l_comp_id
269: FROM fnd_log_transaction_context fltc,
270: fnd_log_messages flm,
271: fnd_log_exceptions fle,
272: FND_LOG_UNIQUE_EXCEPTIONS flue,
273: fnd_application fa
274: WHERE
275: flm.log_sequence = to_number(itemkey)
276: and flm.log_sequence = fle.log_sequence

Line 352: ,FND_LOG_UNIQUE_EXCEPTIONS flue

348: ,l_comp_id, l_unique_ex_id
349: FROM FND_LOG_MESSAGES flm
350: ,FND_LOG_TRANSACTION_CONTEXT fltc
351: ,FND_LOG_EXCEPTIONS fle
352: ,FND_LOG_UNIQUE_EXCEPTIONS flue
353: WHERE
354: flm.LOG_SEQUENCE = TO_NUMBER(itemkey)
355: AND fle.LOG_SEQUENCE = flm.LOG_SEQUENCE
356: AND fltc.TRANSACTION_CONTEXT_ID = flm.TRANSACTION_CONTEXT_ID

Line 508: FND_LOG_UNIQUE_EXCEPTIONS flue,

504: l_app_sn, l_severity, l_app_id, l_comp_type, l_comp_id
505: FROM fnd_log_transaction_context fltc,
506: fnd_log_messages flm,
507: fnd_log_exceptions fle,
508: FND_LOG_UNIQUE_EXCEPTIONS flue,
509: fnd_application_vl fa,
510: fnd_lookups fl
511: WHERE
512: flm.log_sequence = document_id