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.

[Home] [Help]

APPS.IBC_AUDIT_LOG_GRP dependencies on FND_GLOBAL

Line 135: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_LOG_ID') > 0 THEN

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
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

Line 139: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'ACTIVITY ') > 0 THEN

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);
141: END IF;
142:
143: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'ACTIVITY_MEANING') > 0 THEN

Line 143: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'ACTIVITY_MEANING') > 0 THEN

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',
145: Get_Lookup_Meaning('IBC_AUDIT_ACTIVITIES',
146: p_audit_log.ACTIVITY,
147: p_language));

Line 150: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_USER_ID') > 0 THEN

146: p_audit_log.ACTIVITY,
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

Line 154: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_TIME_STAMP') > 0 THEN

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);
156: END IF;
157:
158: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_TYPE') > 0 THEN

Line 158: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_TYPE') > 0 THEN

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);
160: END IF;
161:
162: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE1') > 0 THEN

Line 162: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE1') > 0 THEN

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));
164: END IF;
165:
166: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE2') > 0 THEN

Line 166: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE2') > 0 THEN

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));
168: END IF;
169:
170: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE3') > 0 THEN

Line 170: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE3') > 0 THEN

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));
172: END IF;
173:
174: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE4') > 0 THEN

Line 174: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE4') > 0 THEN

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));
176: END IF;
177:
178: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE5') > 0 THEN

Line 178: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_VALUE5') > 0 THEN

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));
180: END IF;
181:
182: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_PARENT_VALUE') > 0 THEN

Line 182: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_PARENT_VALUE') > 0 THEN

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);
184: END IF;
185:
186: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_STATUS') > 0 THEN

Line 186: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'AUDIT_OBJECT_STATUS') > 0 THEN

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);
188: END IF;
189:
190: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'EXTRA_INFO1_VALUE') > 0 THEN

Line 190: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'EXTRA_INFO1_VALUE') > 0 THEN

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',
192: get_extra_info(p_audit_log_id => p_audit_log.audit_log_id,
193: p_info_number => 1));
194: END IF;

Line 196: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'EXTRA_INFO2_VALUE') > 0 THEN

192: get_extra_info(p_audit_log_id => p_audit_log.audit_log_id,
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;

Line 202: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'EXTRA_INFO3_VALUE') > 0 THEN

198: get_extra_info(p_audit_log_id => p_audit_log.audit_log_id,
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;

Line 208: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'EXTRA_INFO4_VALUE') > 0 THEN

204: get_extra_info(p_audit_log_id => p_audit_log.audit_log_id,
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;

Line 214: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'EXTRA_INFO5_VALUE') > 0 THEN

210: get_extra_info(p_audit_log_id => p_audit_log.audit_log_id,
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;

Line 223: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'ITEM_REFERENCE_CODE') > 0 THEN

219:
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

Line 227: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'CONTENT_TYPE_CODE') > 0 THEN

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);
229: END IF;
230:
231: END LOOP;

Line 238: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'CONTENT_ITEM_NAME') > 0 THEN

234:
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

Line 242: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'CONTENT_TYPE_CODE') > 0 THEN

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);
244: END IF;
245:
246: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'CONTENT_TYPE_NAME') > 0 THEN

Line 246: IF INSTR(l_orig_msg, FND_GLOBAL.local_chr(38) || 'CONTENT_TYPE_NAME') > 0 THEN

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);
248: END IF;
249:
250: END LOOP;

Line 375: ,p_user_id => Fnd_Global.user_id

371: Ibc_Audit_Logs_Pkg.insert_row(
372: px_audit_log_id => audit_log_id
373: ,p_activity => p_activity
374: ,p_parent_value => p_parent_value
375: ,p_user_id => Fnd_Global.user_id
376: ,p_time_stamp => SYSDATE
377: ,p_object_type => p_object_type
378: ,p_object_value1 => p_object_value1
379: ,p_object_value2 => p_object_value2