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.EDR_UTILITIES dependencies on FND_FILE

Line 80: fnd_file.put_line(fnd_file.output, fnd_message.get);

76: /* Check if Profile option is Defined or Not */
77:
78: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CHECK_SETUP');
79: fnd_message.set_token('EVENT', p_Event);
80: fnd_file.put_line(fnd_file.output, fnd_message.get);
81: fnd_file.new_line(fnd_file.output, 2);
82:
83: if (fnd_profile.defined('EDR_ERES_ENABLED')) THEN
84: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_Y') );

Line 81: fnd_file.new_line(fnd_file.output, 2);

77:
78: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CHECK_SETUP');
79: fnd_message.set_token('EVENT', p_Event);
80: fnd_file.put_line(fnd_file.output, fnd_message.get);
81: fnd_file.new_line(fnd_file.output, 2);
82:
83: if (fnd_profile.defined('EDR_ERES_ENABLED')) THEN
84: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_Y') );
85: else

Line 84: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_Y') );

80: fnd_file.put_line(fnd_file.output, fnd_message.get);
81: fnd_file.new_line(fnd_file.output, 2);
82:
83: if (fnd_profile.defined('EDR_ERES_ENABLED')) THEN
84: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_Y') );
85: else
86: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_N') );
87: end if;
88:

Line 86: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_N') );

82:
83: if (fnd_profile.defined('EDR_ERES_ENABLED')) THEN
84: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_Y') );
85: else
86: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_N') );
87: end if;
88:
89: fnd_file.new_line(fnd_file.output, 1);
90: if (fnd_timezones.GET_SERVER_TIMEZONE_CODE IS NULL) THEN

Line 89: fnd_file.new_line(fnd_file.output, 1);

85: else
86: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_N') );
87: end if;
88:
89: fnd_file.new_line(fnd_file.output, 1);
90: if (fnd_timezones.GET_SERVER_TIMEZONE_CODE IS NULL) THEN
91: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_TIME_ZONE_N') );
92: else
93: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_TIME_ZONE_Y');

Line 91: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_TIME_ZONE_N') );

87: end if;
88:
89: fnd_file.new_line(fnd_file.output, 1);
90: if (fnd_timezones.GET_SERVER_TIMEZONE_CODE IS NULL) THEN
91: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_TIME_ZONE_N') );
92: else
93: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_TIME_ZONE_Y');
94: fnd_message.set_token('TMZONE', fnd_timezones.GET_SERVER_TIMEZONE_CODE);
95: fnd_file.put_line(fnd_file.output, fnd_message.get);

Line 95: fnd_file.put_line(fnd_file.output, fnd_message.get);

91: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_TIME_ZONE_N') );
92: else
93: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_TIME_ZONE_Y');
94: fnd_message.set_token('TMZONE', fnd_timezones.GET_SERVER_TIMEZONE_CODE);
95: fnd_file.put_line(fnd_file.output, fnd_message.get);
96: end if;
97:
98: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_V');
99: fnd_message.set_token( 'ERESPROFILE', fnd_profile.value('EDR_ERES_ENABLED'));

Line 100: fnd_file.put_line(fnd_file.output, fnd_message.get);

96: end if;
97:
98: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_V');
99: fnd_message.set_token( 'ERESPROFILE', fnd_profile.value('EDR_ERES_ENABLED'));
100: fnd_file.put_line(fnd_file.output, fnd_message.get);
101: fnd_file.new_line(fnd_file.output, 1);
102:
103:
104: /*check if event and subscritptions are Enabled */

Line 101: fnd_file.new_line(fnd_file.output, 1);

97:
98: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_V');
99: fnd_message.set_token( 'ERESPROFILE', fnd_profile.value('EDR_ERES_ENABLED'));
100: fnd_file.put_line(fnd_file.output, fnd_message.get);
101: fnd_file.new_line(fnd_file.output, 1);
102:
103:
104: /*check if event and subscritptions are Enabled */
105: BEGIN

Line 144: fnd_file.put_line(fnd_file.output, fnd_message.get);

140: EXIT WHEN GET_EVT_SUBSCRIPTION_DETAILS%NOTFOUND;
141: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_STATUS');
142: fnd_message.set_token( 'EVENT', p_event);
143: fnd_message.set_token( 'STATUS', l_event_status);
144: fnd_file.put_line(fnd_file.output, fnd_message.get);
145:
146: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_SUBSCRIBE_STATUS');
147: fnd_message.set_token( 'EVENT', p_event);
148: fnd_message.set_token( 'STATUS', l_sub_status);

Line 149: fnd_file.put_line(fnd_file.output, fnd_message.get);

145:
146: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_SUBSCRIBE_STATUS');
147: fnd_message.set_token( 'EVENT', p_event);
148: fnd_message.set_token( 'STATUS', l_sub_status);
149: fnd_file.put_line(fnd_file.output, fnd_message.get);
150: END LOOP;
151: CLOSE GET_EVT_SUBSCRIPTION_DETAILS;
152: END IF;
153: END IF;

Line 161: fnd_file.put_line(fnd_file.output, fnd_message.get);

157: EXCEPTION
158: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
159: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRP_ERR');
160: fnd_message.set_token( 'EVENT', p_event);
161: fnd_file.put_line(fnd_file.output, fnd_message.get);
162: RETURN;
163: WHEN NO_DATA_FOUND THEN
164: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENTSUB_NOEXIST');
165: fnd_message.set_token( 'EVENT', p_event);

Line 166: fnd_file.put_line(fnd_file.output, fnd_message.get);

162: RETURN;
163: WHEN NO_DATA_FOUND THEN
164: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENTSUB_NOEXIST');
165: fnd_message.set_token( 'EVENT', p_event);
166: fnd_file.put_line(fnd_file.output, fnd_message.get);
167: RETURN;
168: END;
169:
170: /*check if any AMe stuff is available */

Line 188: fnd_file.put_line(fnd_file.output, fnd_message.get);

184: -- Bug 5639849 : Ends
185:
186: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_TRANS_TYPE');
187: fnd_message.set_token( 'TRANSTYPE', l_ame_transaction_type);
188: fnd_file.put_line(fnd_file.output, fnd_message.get);
189:
190:
191: /* AME Processing, Select APPLICATION_ID of the Event. */
192: /* Required by AME. Assumption made here is OWNER_TAG will always be set to application Short Name*/

Line 201: fnd_file.put_line(fnd_file.output, fnd_message.get);

197: (SELECT OWNER_TAG from WF_EVENTS WHERE NAME=evt.getEventName( ));
198:
199: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_CODE');
200: fnd_message.set_token( 'APPCODE', l_application_code);
201: fnd_file.put_line(fnd_file.output, fnd_message.get);
202: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID');
203: fnd_message.set_token( 'APPID', l_application_id);
204: fnd_file.put_line(fnd_file.output, fnd_message.get);
205:

Line 204: fnd_file.put_line(fnd_file.output, fnd_message.get);

200: fnd_message.set_token( 'APPCODE', l_application_code);
201: fnd_file.put_line(fnd_file.output, fnd_message.get);
202: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID');
203: fnd_message.set_token( 'APPID', l_application_id);
204: fnd_file.put_line(fnd_file.output, fnd_message.get);
205:
206: EXCEPTION
207: WHEN NO_DATA_FOUND THEN
208: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID_NO') );

Line 208: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID_NO') );

204: fnd_file.put_line(fnd_file.output, fnd_message.get);
205:
206: EXCEPTION
207: WHEN NO_DATA_FOUND THEN
208: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID_NO') );
209: END;
210:
211: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_AME_RULE_EVAL') );
212:

Line 211: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_AME_RULE_EVAL') );

207: WHEN NO_DATA_FOUND THEN
208: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID_NO') );
209: END;
210:
211: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_AME_RULE_EVAL') );
212:
213:
214: --Bug 2674799: start
215:

Line 229: fnd_file.put_line(fnd_file.output, fnd_message.get);

225: --Bug 2674799: end
226:
227: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_APPROVER_NUM');
228: fnd_message.set_token( 'APPR_NUM', approverlist.count);
229: fnd_file.put_line(fnd_file.output, fnd_message.get);
230:
231: select application_name into l_application_name
232: from ame_Calling_Apps
233: where FND_APPLICATION_ID=l_application_id

Line 250: fnd_file.put_line(fnd_file.output, fnd_message.get);

246:
247: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_APPROVER_SEQ');
248: fnd_message.set_token( 'APPROVER', l_user);
249: fnd_message.set_token( 'APPR_SEQ', i);
250: fnd_file.put_line(fnd_file.output, fnd_message.get);
251:
252: end loop;
253:
254: for i in 1..l_ruleids.count loop

Line 258: fnd_file.put_line(fnd_file.output, fnd_message.get);

254: for i in 1..l_ruleids.count loop
255: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_RULE_APPLY');
256: fnd_message.set_token( 'RULEID', l_ruleids(i));
257: fnd_message.set_token( 'RULENAME', l_rulenames(i));
258: fnd_file.put_line(fnd_file.output, fnd_message.get);
259:
260: -- Bug 3214495 : Start
261:
262: EDR_STANDARD.GET_AMERULE_INPUT_VARIABLES( transactiontypeid =>NVL(l_ame_transaction_type,evt.getEventName( )),

Line 271: fnd_file.put_line(fnd_file.output, fnd_message.get);

267: -- Bug 3214495 : End
268:
269: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_VAR_NUM');
270: fnd_message.set_token( 'NUM_INPUT', l_rulevalues.count);
271: fnd_file.put_line(fnd_file.output, fnd_message.get);
272: if l_rulevalues.count > 0 then
273: for i in 1..l_rulevalues.count loop
274: if l_rulevalues(i).input_name = 'ESIG_REQUIRED' then
275: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_ESIG_REQ');

Line 277: fnd_file.put_line(fnd_file.output, fnd_message.get);

273: for i in 1..l_rulevalues.count loop
274: if l_rulevalues(i).input_name = 'ESIG_REQUIRED' then
275: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_ESIG_REQ');
276: fnd_message.set_token( 'VAR_ESIGREQ', l_rulevalues(i).input_value);
277: fnd_file.put_line(fnd_file.output, fnd_message.get);
278: elsif l_rulevalues(i).input_name = 'EREC_REQUIRED' then
279: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_REQ');
280: fnd_message.set_token( 'VAR_ERECREQ', l_rulevalues(i).input_value);
281: fnd_file.put_line(fnd_file.output, fnd_message.get);

Line 281: fnd_file.put_line(fnd_file.output, fnd_message.get);

277: fnd_file.put_line(fnd_file.output, fnd_message.get);
278: elsif l_rulevalues(i).input_name = 'EREC_REQUIRED' then
279: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_REQ');
280: fnd_message.set_token( 'VAR_ERECREQ', l_rulevalues(i).input_value);
281: fnd_file.put_line(fnd_file.output, fnd_message.get);
282: elsif l_rulevalues(i).input_name = 'EREC_STYLE_SHEET' then
283: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_XSL');
284: fnd_message.set_token( 'VAR_ERECXSL', l_rulevalues(i).input_value);
285: fnd_file.put_line(fnd_file.output, fnd_message.get);

Line 285: fnd_file.put_line(fnd_file.output, fnd_message.get);

281: fnd_file.put_line(fnd_file.output, fnd_message.get);
282: elsif l_rulevalues(i).input_name = 'EREC_STYLE_SHEET' then
283: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_XSL');
284: fnd_message.set_token( 'VAR_ERECXSL', l_rulevalues(i).input_value);
285: fnd_file.put_line(fnd_file.output, fnd_message.get);
286: elsif l_rulevalues(i).input_name = 'EREC_STYLE_SHEET_VER' then
287: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_VER');
288: fnd_message.set_token( 'VAR_ERECVER', l_rulevalues(i).input_value);
289: fnd_file.put_line(fnd_file.output, fnd_message.get);

Line 289: fnd_file.put_line(fnd_file.output, fnd_message.get);

285: fnd_file.put_line(fnd_file.output, fnd_message.get);
286: elsif l_rulevalues(i).input_name = 'EREC_STYLE_SHEET_VER' then
287: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_VER');
288: fnd_message.set_token( 'VAR_ERECVER', l_rulevalues(i).input_value);
289: fnd_file.put_line(fnd_file.output, fnd_message.get);
290: end if;
291: end loop;
292: end if;
293:

Line 297: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_GET_XML') );

293:
294: END LOOP;
295: END IF;
296:
297: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_GET_XML') );
298: -- Bug 5639849 : Starts
299: -- Read EDR_XML_MAP_CODE from subscription parameter rather than
300: -- event parameter list.
301: l_xml_map_code := NVL(EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_XML_MAP_CODE',l_sub_guid),

Line 307: fnd_file.put_line(fnd_file.output, fnd_message.get);

303: -- Bug 5639849 : Ends
304:
305: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_DOC_GET_MAP');
306: fnd_message.set_token( 'DOC_MAP', l_xml_map_code);
307: fnd_file.put_line(fnd_file.output, fnd_message.get);
308: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_DOC_GET_ID');
309: fnd_message.set_token( 'DOC_ID', evt.getEventKey());
310: fnd_file.put_line(fnd_file.output, fnd_message.get);
311:

Line 310: fnd_file.put_line(fnd_file.output, fnd_message.get);

306: fnd_message.set_token( 'DOC_MAP', l_xml_map_code);
307: fnd_file.put_line(fnd_file.output, fnd_message.get);
308: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_DOC_GET_ID');
309: fnd_message.set_token( 'DOC_ID', evt.getEventKey());
310: fnd_file.put_line(fnd_file.output, fnd_message.get);
311:
312: wf_event.AddParameterToList('ECX_MAP_CODE', l_xml_map_code,evt.Parameter_List); /* XML Map Code*/
313: wf_event.AddParameterToList('ECX_DOCUMENT_ID', evt.getEventKey( ),evt.Parameter_List); /* XML Document ID*/
314:

Line 315: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_GET_ECX') );

311:
312: wf_event.AddParameterToList('ECX_MAP_CODE', l_xml_map_code,evt.Parameter_List); /* XML Map Code*/
313: wf_event.AddParameterToList('ECX_DOCUMENT_ID', evt.getEventKey( ),evt.Parameter_List); /* XML Document ID*/
314:
315: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_GET_ECX') );
316:
317: /* Generate XML Document */
318: L_XML_DOCUMENT:=ECX_STANDARD.GENERATE
319: ( p_event_name=>evt.getEventName( ),

Line 323: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_XML_GOT') );

319: ( p_event_name=>evt.getEventName( ),
320: p_event_key=>evt.getEventKey( ),
321: p_parameter_list=>evt.Parameter_List );
322:
323: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_XML_GOT') );
324: -- 3186732 start: fnd_message.set_token limit 3000 char, fnd_message.get limit 2000 char
325: fnd_file.put_line(fnd_file.output, dbms_lob.SUBSTR(l_xml_document,32767) );
326: -- 3186732 end: removed fnd_message set_name/set_token/get statements, write to output directly
327:

Line 325: fnd_file.put_line(fnd_file.output, dbms_lob.SUBSTR(l_xml_document,32767) );

321: p_parameter_list=>evt.Parameter_List );
322:
323: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_XML_GOT') );
324: -- 3186732 start: fnd_message.set_token limit 3000 char, fnd_message.get limit 2000 char
325: fnd_file.put_line(fnd_file.output, dbms_lob.SUBSTR(l_xml_document,32767) );
326: -- 3186732 end: removed fnd_message set_name/set_token/get statements, write to output directly
327:
328: fnd_file.new_line(fnd_file.output, 2);
329: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_SETUP_OK') );

Line 328: fnd_file.new_line(fnd_file.output, 2);

324: -- 3186732 start: fnd_message.set_token limit 3000 char, fnd_message.get limit 2000 char
325: fnd_file.put_line(fnd_file.output, dbms_lob.SUBSTR(l_xml_document,32767) );
326: -- 3186732 end: removed fnd_message set_name/set_token/get statements, write to output directly
327:
328: fnd_file.new_line(fnd_file.output, 2);
329: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_SETUP_OK') );
330:
331:
332: EXCEPTION

Line 329: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_SETUP_OK') );

325: fnd_file.put_line(fnd_file.output, dbms_lob.SUBSTR(l_xml_document,32767) );
326: -- 3186732 end: removed fnd_message set_name/set_token/get statements, write to output directly
327:
328: fnd_file.new_line(fnd_file.output, 2);
329: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_SETUP_OK') );
330:
331:
332: EXCEPTION
333: WHEN OTHERS THEN

Line 334: fnd_file.put_line(fnd_file.output,SQLERRM);

330:
331:
332: EXCEPTION
333: WHEN OTHERS THEN
334: fnd_file.put_line(fnd_file.output,SQLERRM);
335: fnd_file.new_line(fnd_file.output,2);
336: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_SETUP_NO') );
337: END VERIFY_SETUP;
338:

Line 335: fnd_file.new_line(fnd_file.output,2);

331:
332: EXCEPTION
333: WHEN OTHERS THEN
334: fnd_file.put_line(fnd_file.output,SQLERRM);
335: fnd_file.new_line(fnd_file.output,2);
336: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_SETUP_NO') );
337: END VERIFY_SETUP;
338:
339:

Line 336: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_SETUP_NO') );

332: EXCEPTION
333: WHEN OTHERS THEN
334: fnd_file.put_line(fnd_file.output,SQLERRM);
335: fnd_file.new_line(fnd_file.output,2);
336: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_SETUP_NO') );
337: END VERIFY_SETUP;
338:
339:
340:

Line 455: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_CLEAN_TEMP') );

451: IS
452:
453: BEGIN
454:
455: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_CLEAN_TEMP') );
456:
457: DELETE EDR_ERECORDS where ERECORD_SIGNATURE_STATUS not in ('PENDING');
458:
459: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_EREC');

Line 461: fnd_file.put_line(fnd_file.output, fnd_message.get);

457: DELETE EDR_ERECORDS where ERECORD_SIGNATURE_STATUS not in ('PENDING');
458:
459: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_EREC');
460: fnd_message.set_token( 'CLN_NUMREC', SQL%ROWCOUNT);
461: fnd_file.put_line(fnd_file.output, fnd_message.get);
462:
463: DELETE EDR_ESIGNATURES where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);
464:
465: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_ESIG');

Line 467: fnd_file.put_line(fnd_file.output, fnd_message.get);

463: DELETE EDR_ESIGNATURES where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);
464:
465: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_ESIG');
466: fnd_message.set_token( 'CLN_NUMSIG', SQL%ROWCOUNT);
467: fnd_file.put_line(fnd_file.output, fnd_message.get);
468:
469: -- Bug 3761813 rvsingh start
470: --Bug 4306292: Start
471: --Commenting the changes made for the red lining project.

Line 477: fnd_file.put_line(fnd_file.output, fnd_message.get);

473: DELETE EDR_REDLINE_TRANS_DATA where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);
474:
475: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_REDLINE');
476: fnd_message.set_token( 'CLN_NUMREDLINE', SQL%ROWCOUNT);
477: fnd_file.put_line(fnd_file.output, fnd_message.get);
478:
479: --Bug 4306292: End
480: -- Bug 3761813 rvsing stop
481:

Line 486: fnd_file.put_line(fnd_file.output, fnd_message.get);

482: DELETE EDR_TRANS_QUERY_TEMP;
483:
484: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_TQRY');
485: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);
486: fnd_file.put_line(fnd_file.output, fnd_message.get);
487:
488: --Bug 5256904: Start
489: DELETE FROM EDR_ERESPARAMETERS_T
490: WHERE PARENT_TYPE = 'EDR_XDOC_PARAMS';

Line 509: fnd_file.put_line(fnd_file.output, fnd_message.get);

505: (SELECT REQUEST_ID FROM EDR_COLLATE_PRINT_TEMP
506: WHERE CREATION_DATE < (SYSDATE - 2) );
507: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_PREP');
508: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);
509: fnd_file.put_line(fnd_file.output, fnd_message.get);
510:
511: DELETE FROM EDR_COLLATE_PRINT_TEMP where CREATION_DATE < (SYSDATE - 2);
512: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_COLL');
513: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);

Line 514: fnd_file.put_line(fnd_file.output, fnd_message.get);

510:
511: DELETE FROM EDR_COLLATE_PRINT_TEMP where CREATION_DATE < (SYSDATE - 2);
512: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_COLL');
513: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);
514: fnd_file.put_line(fnd_file.output, fnd_message.get);
515:
516: -- Bug 3776079 : End
517:
518: COMMIT;