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

Line 68: fnd_file.put_line(fnd_file.log,'PAP Group ID:'||l_pap_group_id_frm_profile);

64: if (pay_core_utils.pay_action_parameter_group_id is null) then
65: pay_core_utils.pay_action_parameter_group_id := l_pap_group_id_frm_profile;
66: end if;
67:
68: fnd_file.put_line(fnd_file.log,'PAP Group ID:'||l_pap_group_id_frm_profile);
69:
70: /* Check if logging for pl/sql code is set. If yes, enable log statments */
71: lv_debug_flag := 'N';
72: pay_core_utils.get_action_parameter('LOGGING',lv_logging,lv_param_found);

Line 93: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);

89: end if;
90: lv_param_found := FALSE;
91:
92: If lv_debug_enabled then
93: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);
94: fnd_file.put_line(fnd_file.log,'In P_PURGE_DATE :'|| p_purge_date);
95: fnd_file.put_line(fnd_file.log,'PPE_BATCH_SIZE :'|| lv_batch_size);
96: End if;
97:

Line 94: fnd_file.put_line(fnd_file.log,'In P_PURGE_DATE :'|| p_purge_date);

90: lv_param_found := FALSE;
91:
92: If lv_debug_enabled then
93: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);
94: fnd_file.put_line(fnd_file.log,'In P_PURGE_DATE :'|| p_purge_date);
95: fnd_file.put_line(fnd_file.log,'PPE_BATCH_SIZE :'|| lv_batch_size);
96: End if;
97:
98: l_stmt_num :=0;

Line 95: fnd_file.put_line(fnd_file.log,'PPE_BATCH_SIZE :'|| lv_batch_size);

91:
92: If lv_debug_enabled then
93: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);
94: fnd_file.put_line(fnd_file.log,'In P_PURGE_DATE :'|| p_purge_date);
95: fnd_file.put_line(fnd_file.log,'PPE_BATCH_SIZE :'|| lv_batch_size);
96: End if;
97:
98: l_stmt_num :=0;
99: l_stmt_num :=5;

Line 144: fnd_file.put_line(fnd_file.log,'Before pay_core_utils.get_action_parameter ');

140: lv_Num_Workers := X_Num_Workers;
141:
142: /* Get the Pay Action Parameter Value of THREADS */
143: If lv_debug_enabled then
144: fnd_file.put_line(fnd_file.log,'Before pay_core_utils.get_action_parameter ');
145: End if;
146:
147: pay_core_utils.get_action_parameter('THREADS',lv_Num_Workers,lv_param_found);
148:

Line 154: fnd_file.put_line(fnd_file.log,'No of Workers :'||to_char(lv_Num_Workers));

150: lv_Num_Workers := x_Num_Workers;
151: end if;
152:
153: If lv_debug_enabled then
154: fnd_file.put_line(fnd_file.log,'No of Workers :'||to_char(lv_Num_Workers));
155: End if;
156:
157: If lv_debug_enabled then
158: fnd_file.put_line(fnd_file.log,'After pay_core_utils.get_action_parameter ');

Line 158: fnd_file.put_line(fnd_file.log,'After pay_core_utils.get_action_parameter ');

154: fnd_file.put_line(fnd_file.log,'No of Workers :'||to_char(lv_Num_Workers));
155: End if;
156:
157: If lv_debug_enabled then
158: fnd_file.put_line(fnd_file.log,'After pay_core_utils.get_action_parameter ');
159: End if;
160:
161: begin
162:

Line 164: fnd_file.put_line(fnd_file.log,'Before AD_CONC_UTILS_PKG.submit_subrequests ');

160:
161: begin
162:
163: If lv_debug_enabled then
164: fnd_file.put_line(fnd_file.log,'Before AD_CONC_UTILS_PKG.submit_subrequests ');
165: End if;
166:
167: /* Call worker program based on number of threads */
168: AD_CONC_UTILS_PKG.submit_subrequests(

Line 184: fnd_file.put_line(FND_FILE.LOG,'Error '||sqlcode ||' '||sqlerrm);

180: X_Argument9 => null,
181: X_Argument10 => null);
182:
183: exception when others then
184: fnd_file.put_line(FND_FILE.LOG,'Error '||sqlcode ||' '||sqlerrm);
185:
186: end;
187:
188: If lv_debug_enabled then

Line 189: fnd_file.put_line(fnd_file.log,'After AD_CONC_UTILS_PKG.submit_subrequests ');

185:
186: end;
187:
188: If lv_debug_enabled then
189: fnd_file.put_line(fnd_file.log,'After AD_CONC_UTILS_PKG.submit_subrequests ');
190: End if;
191:
192: exception
193: when others then

Line 194: fnd_file.put_line(FND_FILE.LOG,'Error '||sqlcode ||' '||sqlerrm);

190: End if;
191:
192: exception
193: when others then
194: fnd_file.put_line(FND_FILE.LOG,'Error '||sqlcode ||' '||sqlerrm);
195:
196: end;
197: end if;
198:

Line 216: fnd_file.put_line(FND_FILE.LOG,'* Process completed successfully *');

212: end loop;
213:
214: /* Display process completion message */
215: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then
216: fnd_file.put_line(FND_FILE.LOG,'***** Process completed successfully *****');
217: end if;
218:
219: end if;
220:

Line 222: fnd_file.put_line(fnd_file.log,'Leaving :'||l_module);

218:
219: end if;
220:
221: If lv_debug_enabled then
222: fnd_file.put_line(fnd_file.log,'Leaving :'||l_module);
223: End if;
224:
225: EXCEPTION
226: WHEN submit_conc_failed THEN

Line 303: fnd_file.put_line(fnd_file.log,'Enter:'||l_module);

299: lv_debug_enabled := TRUE;
300: end if;
301:
302: If lv_debug_enabled then
303: fnd_file.put_line(fnd_file.log,'Enter:'||l_module);
304: fnd_file.put_line(fnd_file.log,'In Purge Date :'||X_Argument5);
305: End if;
306:
307: BEGIN

Line 304: fnd_file.put_line(fnd_file.log,'In Purge Date :'||X_Argument5);

300: end if;
301:
302: If lv_debug_enabled then
303: fnd_file.put_line(fnd_file.log,'Enter:'||l_module);
304: fnd_file.put_line(fnd_file.log,'In Purge Date :'||X_Argument5);
305: End if;
306:
307: BEGIN
308: l_stmt_num :=10;

Line 340: fnd_file.put_line(fnd_file.log,'Before calling Purge Process Events');

336: while (l_any_rows_to_process = TRUE)
337: loop
338: l_stmt_num :=30;
339: If lv_debug_enabled then
340: fnd_file.put_line(fnd_file.log,'Before calling Purge Process Events');
341: fnd_file.put_line(fnd_file.log,'l_start_id :'||l_start_id);
342: fnd_file.put_line(fnd_file.log,'l_end_id :'||l_end_id);
343: End if;
344:

Line 341: fnd_file.put_line(fnd_file.log,'l_start_id :'||l_start_id);

337: loop
338: l_stmt_num :=30;
339: If lv_debug_enabled then
340: fnd_file.put_line(fnd_file.log,'Before calling Purge Process Events');
341: fnd_file.put_line(fnd_file.log,'l_start_id :'||l_start_id);
342: fnd_file.put_line(fnd_file.log,'l_end_id :'||l_end_id);
343: End if;
344:
345: /* Call to code for prcoessing purge process events request */

Line 342: fnd_file.put_line(fnd_file.log,'l_end_id :'||l_end_id);

338: l_stmt_num :=30;
339: If lv_debug_enabled then
340: fnd_file.put_line(fnd_file.log,'Before calling Purge Process Events');
341: fnd_file.put_line(fnd_file.log,'l_start_id :'||l_start_id);
342: fnd_file.put_line(fnd_file.log,'l_end_id :'||l_end_id);
343: End if;
344:
345: /* Call to code for prcoessing purge process events request */
346: PAY_PRG_PROCESS_EVENTS.Purge_process_events(

Line 355: fnd_file.put_line(fnd_file.log,'After calling Purge Process Events' );

351: P_Purge_Date=>X_Argument5,
352: P_Debug_Flag=>X_Argument4);
353:
354: If lv_debug_enabled then
355: fnd_file.put_line(fnd_file.log,'After calling Purge Process Events' );
356: End if;
357:
358: if (X_retcode <>FND_API.G_RET_STS_SUCCESS) then
359: raise purge_events_exception;

Line 391: fnd_file.put_line(fnd_file.log,'Leaving :'||l_module);

387: raise;
388: END;
389:
390: If lv_debug_enabled then
391: fnd_file.put_line(fnd_file.log,'Leaving :'||l_module);
392: End if;
393:
394: EXCEPTION
395:

Line 500: fnd_file.put_line(fnd_file.log,'Enter :'|| l_module);

496: lv_bulk_limit := 10000;
497: end if;
498:
499: If lv_debug_enabled then
500: fnd_file.put_line(fnd_file.log,'Enter :'|| l_module);
501: fnd_file.put_line(fnd_file.log,'In P_Purge_Date :'|| P_Purge_Date);
502: fnd_file.put_line(fnd_file.log,'In X_START_ID :'|| to_char(X_start_id));
503: fnd_file.put_line(fnd_file.log,'In X_END_ID :'|| to_char(X_end_id));
504: fnd_file.put_line(fnd_file.log,'PPE_BULK_LIMIT :'|| lv_bulk_limit);

Line 501: fnd_file.put_line(fnd_file.log,'In P_Purge_Date :'|| P_Purge_Date);

497: end if;
498:
499: If lv_debug_enabled then
500: fnd_file.put_line(fnd_file.log,'Enter :'|| l_module);
501: fnd_file.put_line(fnd_file.log,'In P_Purge_Date :'|| P_Purge_Date);
502: fnd_file.put_line(fnd_file.log,'In X_START_ID :'|| to_char(X_start_id));
503: fnd_file.put_line(fnd_file.log,'In X_END_ID :'|| to_char(X_end_id));
504: fnd_file.put_line(fnd_file.log,'PPE_BULK_LIMIT :'|| lv_bulk_limit);
505: End if;

Line 502: fnd_file.put_line(fnd_file.log,'In X_START_ID :'|| to_char(X_start_id));

498:
499: If lv_debug_enabled then
500: fnd_file.put_line(fnd_file.log,'Enter :'|| l_module);
501: fnd_file.put_line(fnd_file.log,'In P_Purge_Date :'|| P_Purge_Date);
502: fnd_file.put_line(fnd_file.log,'In X_START_ID :'|| to_char(X_start_id));
503: fnd_file.put_line(fnd_file.log,'In X_END_ID :'|| to_char(X_end_id));
504: fnd_file.put_line(fnd_file.log,'PPE_BULK_LIMIT :'|| lv_bulk_limit);
505: End if;
506:

Line 503: fnd_file.put_line(fnd_file.log,'In X_END_ID :'|| to_char(X_end_id));

499: If lv_debug_enabled then
500: fnd_file.put_line(fnd_file.log,'Enter :'|| l_module);
501: fnd_file.put_line(fnd_file.log,'In P_Purge_Date :'|| P_Purge_Date);
502: fnd_file.put_line(fnd_file.log,'In X_START_ID :'|| to_char(X_start_id));
503: fnd_file.put_line(fnd_file.log,'In X_END_ID :'|| to_char(X_end_id));
504: fnd_file.put_line(fnd_file.log,'PPE_BULK_LIMIT :'|| lv_bulk_limit);
505: End if;
506:
507: v_time := dbms_utility.get_time;

Line 504: fnd_file.put_line(fnd_file.log,'PPE_BULK_LIMIT :'|| lv_bulk_limit);

500: fnd_file.put_line(fnd_file.log,'Enter :'|| l_module);
501: fnd_file.put_line(fnd_file.log,'In P_Purge_Date :'|| P_Purge_Date);
502: fnd_file.put_line(fnd_file.log,'In X_START_ID :'|| to_char(X_start_id));
503: fnd_file.put_line(fnd_file.log,'In X_END_ID :'|| to_char(X_end_id));
504: fnd_file.put_line(fnd_file.log,'PPE_BULK_LIMIT :'|| lv_bulk_limit);
505: End if;
506:
507: v_time := dbms_utility.get_time;
508:

Line 559: fnd_file.put_line(fnd_file.log,'Time used: ' || (dbms_utility.get_time - v_time) / 100 || ' secs');

555:
556: end loop;
557:
558: if lv_debug_enabled then
559: fnd_file.put_line(fnd_file.log,'Time used: ' || (dbms_utility.get_time - v_time) / 100 || ' secs');
560: end if;
561:
562: close get_archive_events;
563:

Line 567: fnd_file.put_line(fnd_file.log,'Leaving :'||l_module);

563:
564: commit;
565:
566: If lv_debug_enabled then
567: fnd_file.put_line(fnd_file.log,'Leaving :'||l_module);
568: End if;
569:
570: EXCEPTION when others then
571: Rollback;

Line 573: fnd_file.put_line(FND_FILE.LOG,'Error Purge_process_events '||SQLCODE||' '||SQLERRM);

569:
570: EXCEPTION when others then
571: Rollback;
572: X_errbuf:=l_module||': '|| SQLERRM;
573: fnd_file.put_line(FND_FILE.LOG,'Error Purge_process_events '||SQLCODE||' '||SQLERRM);
574:
575: END Purge_process_events;
576:
577: END PAY_PRG_PROCESS_EVENTS;