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.IBC_AUDIT_LOG_GRP dependencies on FND_MESSAGE

Line 131: l_orig_msg := FND_MESSAGE.get_string(NVL(p_audit_log.MESSAGE_APPLICATION, 'IBC'),

127: SELECT *
128: FROM ibc_content_items
129: WHERE content_item_id = p_citem_id;
130: BEGIN
131: l_orig_msg := FND_MESSAGE.get_string(NVL(p_audit_log.MESSAGE_APPLICATION, 'IBC'),
132: NVL(p_audit_log.MESSAGE_NAME, 'IBC_DFLT_AUDIT_MSG'));
133: l_orig_msg := UPPER(l_orig_msg);
134:
135: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_LOG_ID') > 0 THEN

Line 136: FND_MESSAGE.set_token('AUDIT_LOG_ID', p_audit_log.audit_log_id);

132: NVL(p_audit_log.MESSAGE_NAME, 'IBC_DFLT_AUDIT_MSG'));
133: l_orig_msg := UPPER(l_orig_msg);
134:
135: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_LOG_ID') > 0 THEN
136: FND_MESSAGE.set_token('AUDIT_LOG_ID', p_audit_log.audit_log_id);
137: END IF;
138:
139: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'ACTIVITY ') > 0 THEN
140: FND_MESSAGE.set_token('ACTIVITY', p_audit_log.activity);

Line 140: FND_MESSAGE.set_token('ACTIVITY', p_audit_log.activity);

136: FND_MESSAGE.set_token('AUDIT_LOG_ID', p_audit_log.audit_log_id);
137: END IF;
138:
139: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'ACTIVITY ') > 0 THEN
140: FND_MESSAGE.set_token('ACTIVITY', p_audit_log.activity);
141: END IF;
142:
143: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'ACTIVITY_MEANING') > 0 THEN
144: FND_MESSAGE.set_token('ACTIVITY_MEANING',

Line 144: FND_MESSAGE.set_token('ACTIVITY_MEANING',

140: FND_MESSAGE.set_token('ACTIVITY', p_audit_log.activity);
141: END IF;
142:
143: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'ACTIVITY_MEANING') > 0 THEN
144: FND_MESSAGE.set_token('ACTIVITY_MEANING',
145: Get_Lookup_Meaning('IBC_AUDIT_ACTIVITIES',
146: p_audit_log.ACTIVITY,
147: p_language));
148: END IF;

Line 151: FND_MESSAGE.set_token('AUDIT_USER_ID', p_audit_log.user_id);

147: p_language));
148: END IF;
149:
150: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_USER_ID') > 0 THEN
151: FND_MESSAGE.set_token('AUDIT_USER_ID', p_audit_log.user_id);
152: END IF;
153:
154: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_TIME_STAMP') > 0 THEN
155: FND_MESSAGE.set_token('AUDIT_TIME_STAMP', p_audit_log.time_stamp);

Line 155: FND_MESSAGE.set_token('AUDIT_TIME_STAMP', p_audit_log.time_stamp);

151: FND_MESSAGE.set_token('AUDIT_USER_ID', p_audit_log.user_id);
152: END IF;
153:
154: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_TIME_STAMP') > 0 THEN
155: FND_MESSAGE.set_token('AUDIT_TIME_STAMP', p_audit_log.time_stamp);
156: END IF;
157:
158: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_TYPE') > 0 THEN
159: FND_MESSAGE.set_token('AUDIT_OBJECT_TYPE', p_audit_log.object_type);

Line 159: FND_MESSAGE.set_token('AUDIT_OBJECT_TYPE', p_audit_log.object_type);

155: FND_MESSAGE.set_token('AUDIT_TIME_STAMP', p_audit_log.time_stamp);
156: END IF;
157:
158: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_TYPE') > 0 THEN
159: FND_MESSAGE.set_token('AUDIT_OBJECT_TYPE', p_audit_log.object_type);
160: END IF;
161:
162: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE1') > 0 THEN
163: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE1', Object_Lookup_Value(p_audit_log.object_value1));

Line 163: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE1', Object_Lookup_Value(p_audit_log.object_value1));

159: FND_MESSAGE.set_token('AUDIT_OBJECT_TYPE', p_audit_log.object_type);
160: END IF;
161:
162: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE1') > 0 THEN
163: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE1', Object_Lookup_Value(p_audit_log.object_value1));
164: END IF;
165:
166: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE2') > 0 THEN
167: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE2', Object_Lookup_Value(p_audit_log.object_value2));

Line 167: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE2', Object_Lookup_Value(p_audit_log.object_value2));

163: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE1', Object_Lookup_Value(p_audit_log.object_value1));
164: END IF;
165:
166: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE2') > 0 THEN
167: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE2', Object_Lookup_Value(p_audit_log.object_value2));
168: END IF;
169:
170: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE3') > 0 THEN
171: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE3', Object_Lookup_Value(p_audit_log.object_value3));

Line 171: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE3', Object_Lookup_Value(p_audit_log.object_value3));

167: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE2', Object_Lookup_Value(p_audit_log.object_value2));
168: END IF;
169:
170: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE3') > 0 THEN
171: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE3', Object_Lookup_Value(p_audit_log.object_value3));
172: END IF;
173:
174: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE4') > 0 THEN
175: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE4', Object_Lookup_Value(p_audit_log.object_value4));

Line 175: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE4', Object_Lookup_Value(p_audit_log.object_value4));

171: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE3', Object_Lookup_Value(p_audit_log.object_value3));
172: END IF;
173:
174: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE4') > 0 THEN
175: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE4', Object_Lookup_Value(p_audit_log.object_value4));
176: END IF;
177:
178: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE5') > 0 THEN
179: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE5', Object_Lookup_Value(p_audit_log.object_value5));

Line 179: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE5', Object_Lookup_Value(p_audit_log.object_value5));

175: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE4', Object_Lookup_Value(p_audit_log.object_value4));
176: END IF;
177:
178: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE5') > 0 THEN
179: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE5', Object_Lookup_Value(p_audit_log.object_value5));
180: END IF;
181:
182: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_PARENT_VALUE') > 0 THEN
183: FND_MESSAGE.set_token('AUDIT_PARENT_VALUE', p_audit_log.parent_value);

Line 183: FND_MESSAGE.set_token('AUDIT_PARENT_VALUE', p_audit_log.parent_value);

179: FND_MESSAGE.set_token('AUDIT_OBJECT_VALUE5', Object_Lookup_Value(p_audit_log.object_value5));
180: END IF;
181:
182: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_PARENT_VALUE') > 0 THEN
183: FND_MESSAGE.set_token('AUDIT_PARENT_VALUE', p_audit_log.parent_value);
184: END IF;
185:
186: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_STATUS') > 0 THEN
187: FND_MESSAGE.set_token('AUDIT_OBJECT_STATUS', p_audit_log.object_status);

Line 187: FND_MESSAGE.set_token('AUDIT_OBJECT_STATUS', p_audit_log.object_status);

183: FND_MESSAGE.set_token('AUDIT_PARENT_VALUE', p_audit_log.parent_value);
184: END IF;
185:
186: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_STATUS') > 0 THEN
187: FND_MESSAGE.set_token('AUDIT_OBJECT_STATUS', p_audit_log.object_status);
188: END IF;
189:
190: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'EXTRA_INFO1_VALUE') > 0 THEN
191: FND_MESSAGE.set_token('EXTRA_INFO1_VALUE',

Line 191: FND_MESSAGE.set_token('EXTRA_INFO1_VALUE',

187: FND_MESSAGE.set_token('AUDIT_OBJECT_STATUS', p_audit_log.object_status);
188: END IF;
189:
190: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'EXTRA_INFO1_VALUE') > 0 THEN
191: FND_MESSAGE.set_token('EXTRA_INFO1_VALUE',
192: get_extra_info(p_audit_log_id => p_audit_log.audit_log_id,
193: p_info_number => 1));
194: END IF;
195:

Line 197: FND_MESSAGE.set_token('EXTRA_INFO2_VALUE',

193: p_info_number => 1));
194: END IF;
195:
196: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'EXTRA_INFO2_VALUE') > 0 THEN
197: FND_MESSAGE.set_token('EXTRA_INFO2_VALUE',
198: get_extra_info(p_audit_log_id => p_audit_log.audit_log_id,
199: p_info_number => 2));
200: END IF;
201:

Line 203: FND_MESSAGE.set_token('EXTRA_INFO3_VALUE',

199: p_info_number => 2));
200: END IF;
201:
202: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'EXTRA_INFO3_VALUE') > 0 THEN
203: FND_MESSAGE.set_token('EXTRA_INFO3_VALUE',
204: get_extra_info(p_audit_log_id => p_audit_log.audit_log_id,
205: p_info_number => 3));
206: END IF;
207:

Line 209: FND_MESSAGE.set_token('EXTRA_INFO4_VALUE',

205: p_info_number => 3));
206: END IF;
207:
208: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'EXTRA_INFO4_VALUE') > 0 THEN
209: FND_MESSAGE.set_token('EXTRA_INFO4_VALUE',
210: get_extra_info(p_audit_log_id => p_audit_log.audit_log_id,
211: p_info_number => 4));
212: END IF;
213:

Line 215: FND_MESSAGE.set_token('EXTRA_INFO5_VALUE',

211: p_info_number => 4));
212: END IF;
213:
214: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'EXTRA_INFO5_VALUE') > 0 THEN
215: FND_MESSAGE.set_token('EXTRA_INFO5_VALUE',
216: get_extra_info(p_audit_log_id => p_audit_log.audit_log_id,
217: p_info_number => 5));
218: END IF;
219:

Line 224: FND_MESSAGE.set_token('ITEM_REFERENCE_CODE', r_citem.item_reference_code);

220: IF p_audit_log.object_type = G_CONTENT_ITEM THEN
221: FOR r_citem IN c_citem(p_audit_log.object_value1) LOOP
222:
223: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'ITEM_REFERENCE_CODE') > 0 THEN
224: FND_MESSAGE.set_token('ITEM_REFERENCE_CODE', r_citem.item_reference_code);
225: END IF;
226:
227: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'CONTENT_TYPE_CODE') > 0 THEN
228: FND_MESSAGE.set_token('CONTENT_TYPE_CODE', r_citem.content_type_code);

Line 228: FND_MESSAGE.set_token('CONTENT_TYPE_CODE', r_citem.content_type_code);

224: FND_MESSAGE.set_token('ITEM_REFERENCE_CODE', r_citem.item_reference_code);
225: END IF;
226:
227: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'CONTENT_TYPE_CODE') > 0 THEN
228: FND_MESSAGE.set_token('CONTENT_TYPE_CODE', r_citem.content_type_code);
229: END IF;
230:
231: END LOOP;
232: END IF;

Line 239: FND_MESSAGE.set_token('CONTENT_ITEM_NAME', r_citem_Ver.name);

235: IF p_audit_log.object_type = G_CITEM_VERSION THEN
236: FOR r_citem_ver IN c_citem_Ver(p_audit_log.object_value1) LOOP
237:
238: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'CONTENT_ITEM_NAME') > 0 THEN
239: FND_MESSAGE.set_token('CONTENT_ITEM_NAME', r_citem_Ver.name);
240: END IF;
241:
242: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'CONTENT_TYPE_CODE') > 0 THEN
243: FND_MESSAGE.set_token('CONTENT_TYPE_CODE', r_citem_Ver.ctype_code);

Line 243: FND_MESSAGE.set_token('CONTENT_TYPE_CODE', r_citem_Ver.ctype_code);

239: FND_MESSAGE.set_token('CONTENT_ITEM_NAME', r_citem_Ver.name);
240: END IF;
241:
242: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'CONTENT_TYPE_CODE') > 0 THEN
243: FND_MESSAGE.set_token('CONTENT_TYPE_CODE', r_citem_Ver.ctype_code);
244: END IF;
245:
246: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'CONTENT_TYPE_NAME') > 0 THEN
247: FND_MESSAGE.set_token('CONTENT_TYPE_NAME', r_citem_Ver.ctype_name);

Line 247: FND_MESSAGE.set_token('CONTENT_TYPE_NAME', r_citem_Ver.ctype_name);

243: FND_MESSAGE.set_token('CONTENT_TYPE_CODE', r_citem_Ver.ctype_code);
244: END IF;
245:
246: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'CONTENT_TYPE_NAME') > 0 THEN
247: FND_MESSAGE.set_token('CONTENT_TYPE_NAME', r_citem_Ver.ctype_name);
248: END IF;
249:
250: END LOOP;
251: END IF;

Line 264: -- p_message_name => Message Name (FND_MESSAGES)

260: -- p_object_type => Object Type
261: -- p_object_value[1..5] => Primary Key for object being audited
262: -- p_parent_value => Parent Value
263: -- p_message_application => Application owner of audit message
264: -- p_message_name => Message Name (FND_MESSAGES)
265: -- p_extra_info[1..5]_type => Extra Information segment type
266: -- i.e. CONSTANT, LOOKUP or MESSAGE
267: -- p_extra_info[1..5]_ref_type => Lookup Type (in case of LOOKUP)
268: -- p_extra_info[1..5]_value => Value (Constant, lookup code or

Line 487: FND_MESSAGE.set_name(NVL(r_audit_log.MESSAGE_APPLICATION, 'IBC'),

483:
484: OPEN c_audit_log(p_audit_log_id);
485: FETCH c_audit_log INTO r_audit_log;
486: IF c_audit_log%FOUND THEN
487: FND_MESSAGE.set_name(NVL(r_audit_log.MESSAGE_APPLICATION, 'IBC'),
488: NVL(r_audit_log.MESSAGE_NAME, 'IBC_DFLT_AUDIT_MSG'));
489: Replace_Tokens(r_audit_log);
490: l_result := FND_MESSAGE.get();
491: FND_MESSAGE.clear;

Line 490: l_result := FND_MESSAGE.get();

486: IF c_audit_log%FOUND THEN
487: FND_MESSAGE.set_name(NVL(r_audit_log.MESSAGE_APPLICATION, 'IBC'),
488: NVL(r_audit_log.MESSAGE_NAME, 'IBC_DFLT_AUDIT_MSG'));
489: Replace_Tokens(r_audit_log);
490: l_result := FND_MESSAGE.get();
491: FND_MESSAGE.clear;
492: END IF;
493: CLOSE c_audit_log;
494:

Line 491: FND_MESSAGE.clear;

487: FND_MESSAGE.set_name(NVL(r_audit_log.MESSAGE_APPLICATION, 'IBC'),
488: NVL(r_audit_log.MESSAGE_NAME, 'IBC_DFLT_AUDIT_MSG'));
489: Replace_Tokens(r_audit_log);
490: l_result := FND_MESSAGE.get();
491: FND_MESSAGE.clear;
492: END IF;
493: CLOSE c_audit_log;
494:
495: RETURN l_result;

Line 578: l_before_message := FND_MESSAGE.get_encoded();

574: ELSE
575: l_msg_application := 'IBC';
576: l_msg_name := l_extra_info_value;
577: END IF;
578: l_before_message := FND_MESSAGE.get_encoded();
579: FND_MESSAGE.clear;
580: FND_MESSAGE.set_name(l_msg_application,l_msg_name);
581: l_result := FND_MESSAGE.get();
582: FND_MESSAGE.clear;

Line 579: FND_MESSAGE.clear;

575: l_msg_application := 'IBC';
576: l_msg_name := l_extra_info_value;
577: END IF;
578: l_before_message := FND_MESSAGE.get_encoded();
579: FND_MESSAGE.clear;
580: FND_MESSAGE.set_name(l_msg_application,l_msg_name);
581: l_result := FND_MESSAGE.get();
582: FND_MESSAGE.clear;
583: FND_MESSAGE.set_encoded(l_before_message);

Line 580: FND_MESSAGE.set_name(l_msg_application,l_msg_name);

576: l_msg_name := l_extra_info_value;
577: END IF;
578: l_before_message := FND_MESSAGE.get_encoded();
579: FND_MESSAGE.clear;
580: FND_MESSAGE.set_name(l_msg_application,l_msg_name);
581: l_result := FND_MESSAGE.get();
582: FND_MESSAGE.clear;
583: FND_MESSAGE.set_encoded(l_before_message);
584: ELSIF l_extra_info_type = G_EI_CS_LOOKUP THEN

Line 581: l_result := FND_MESSAGE.get();

577: END IF;
578: l_before_message := FND_MESSAGE.get_encoded();
579: FND_MESSAGE.clear;
580: FND_MESSAGE.set_name(l_msg_application,l_msg_name);
581: l_result := FND_MESSAGE.get();
582: FND_MESSAGE.clear;
583: FND_MESSAGE.set_encoded(l_before_message);
584: ELSIF l_extra_info_type = G_EI_CS_LOOKUP THEN
585:

Line 582: FND_MESSAGE.clear;

578: l_before_message := FND_MESSAGE.get_encoded();
579: FND_MESSAGE.clear;
580: FND_MESSAGE.set_name(l_msg_application,l_msg_name);
581: l_result := FND_MESSAGE.get();
582: FND_MESSAGE.clear;
583: FND_MESSAGE.set_encoded(l_before_message);
584: ELSIF l_extra_info_type = G_EI_CS_LOOKUP THEN
585:
586: l_curr_value_list := l_extra_info_value;

Line 583: FND_MESSAGE.set_encoded(l_before_message);

579: FND_MESSAGE.clear;
580: FND_MESSAGE.set_name(l_msg_application,l_msg_name);
581: l_result := FND_MESSAGE.get();
582: FND_MESSAGE.clear;
583: FND_MESSAGE.set_encoded(l_before_message);
584: ELSIF l_extra_info_type = G_EI_CS_LOOKUP THEN
585:
586: l_curr_value_list := l_extra_info_value;
587: WHILE l_curr_value_list IS NOT NULL LOOP