DBA Data[Home] [Help]

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 279: FND_LOG_UNIQUE_EXCEPTIONS flue,

275: l_app_sn, l_severity, l_app_id, l_comp_type, l_comp_id
276: FROM fnd_log_transaction_context fltc,
277: fnd_log_messages flm,
278: fnd_log_exceptions fle,
279: FND_LOG_UNIQUE_EXCEPTIONS flue,
280: fnd_application fa
281: WHERE
282: flm.log_sequence = to_number(itemkey)
283: and flm.log_sequence = fle.log_sequence

Line 359: ,FND_LOG_UNIQUE_EXCEPTIONS flue

355: ,l_comp_id, l_unique_ex_id
356: FROM FND_LOG_MESSAGES flm
357: ,FND_LOG_TRANSACTION_CONTEXT fltc
358: ,FND_LOG_EXCEPTIONS fle
359: ,FND_LOG_UNIQUE_EXCEPTIONS flue
360: WHERE
361: flm.LOG_SEQUENCE = TO_NUMBER(itemkey)
362: AND fle.LOG_SEQUENCE = flm.LOG_SEQUENCE
363: AND fltc.TRANSACTION_CONTEXT_ID = flm.TRANSACTION_CONTEXT_ID

Line 515: FND_LOG_UNIQUE_EXCEPTIONS flue,

511: l_app_sn, l_severity, l_app_id, l_comp_type, l_comp_id
512: FROM fnd_log_transaction_context fltc,
513: fnd_log_messages flm,
514: fnd_log_exceptions fle,
515: FND_LOG_UNIQUE_EXCEPTIONS flue,
516: fnd_application_vl fa,
517: fnd_lookups fl
518: WHERE
519: flm.log_sequence = document_id