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

Line 19: fnd_file.put_line(FND_FILE.LOG, p_msg);

15:
16: end if;
17:
18: if FND_GLOBAL.Conc_Request_Id is not null then
19: fnd_file.put_line(FND_FILE.LOG, p_msg);
20: end if;
21:
22: EXCEPTION
23: WHEN OTHERS THEN

Line 48: FND_FILE.put_line( FND_FILE.LOG,'l_end-->'||l_end);

44: BEGIN
45: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
46: LOOP
47: l_end := DBMS_LOB.INSTR (lob_loc => lob_loc, pattern => c_endline, offset => l_start, nth => 1 );
48: FND_FILE.put_line( FND_FILE.LOG,'l_end-->'||l_end);
49: IF (NVL (l_end, 0) < 1) THEN
50: EXIT;
51: END IF;
52: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );

Line 53: FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);

49: IF (NVL (l_end, 0) < 1) THEN
50: EXIT;
51: END IF;
52: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );
53: FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
54: FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
55: l_start := l_end + c_endline_len;
56: FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
57: FND_FILE.put_line( FND_FILE.LOG,'32');

Line 54: FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);

50: EXIT;
51: END IF;
52: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );
53: FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
54: FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
55: l_start := l_end + c_endline_len;
56: FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
57: FND_FILE.put_line( FND_FILE.LOG,'32');
58: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);

Line 56: FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);

52: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );
53: FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
54: FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
55: l_start := l_end + c_endline_len;
56: FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
57: FND_FILE.put_line( FND_FILE.LOG,'32');
58: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);
59: END LOOP;
60: END PRINT_CLOB;

Line 57: FND_FILE.put_line( FND_FILE.LOG,'32');

53: FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
54: FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
55: l_start := l_end + c_endline_len;
56: FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
57: FND_FILE.put_line( FND_FILE.LOG,'32');
58: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);
59: END LOOP;
60: END PRINT_CLOB;
61: PROCEDURE gen_xml_data_pcol

Line 58: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);

54: FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
55: l_start := l_end + c_endline_len;
56: FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
57: FND_FILE.put_line( FND_FILE.LOG,'32');
58: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);
59: END LOOP;
60: END PRINT_CLOB;
61: PROCEDURE gen_xml_data_pcol
62: (

Line 127: FND_FILE.put_line( FND_FILE.LOG,'*start of the proc***');

123: l_from_date date;
124: l_to_date date;
125:
126: BEGIN
127: FND_FILE.put_line( FND_FILE.LOG,'*************start of the proc***************');
128: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
129:
130: --start of get filters
131: l_from_date := TRUNC(fnd_date.canonical_to_date(p_date_from));

Line 165: -- FND_FILE.put_line( FND_FILE.LOG,'4.5');

161: l_coll_rate:='Corporate';
162: end if;
163:
164: IF p_collector IS NOT NULL THEN
165: -- FND_FILE.put_line( FND_FILE.LOG,'4.5');
166: select source_name
167: into l_collector
168: from jtf_rs_resource_extns
169: where resource_id=p_collector;

Line 190: FND_FILE.put_line( FND_FILE.LOG,'This Collector can see only promises assigned to him');

186: 'where b.manager_person_id = a.source_id '|| 'and a.resource_id = '||p_collector;
187: l_where :=l_where||' and p.resource_id in '|| l_res_qry ;
188: l_where :=l_where||'))';
189: ELSE
190: FND_FILE.put_line( FND_FILE.LOG,'This Collector can see only promises assigned to him');
191: l_where:=l_where||' and p.resource_id= '|| p_collector;
192: END IF;
193: ELSE
194: -- FND_FILE.put_line( FND_FILE.LOG,'4.6');

Line 194: -- FND_FILE.put_line( FND_FILE.LOG,'4.6');

190: FND_FILE.put_line( FND_FILE.LOG,'This Collector can see only promises assigned to him');
191: l_where:=l_where||' and p.resource_id= '|| p_collector;
192: END IF;
193: ELSE
194: -- FND_FILE.put_line( FND_FILE.LOG,'4.6');
195: l_where:=l_where||' and p.resource_id= '|| p_collector;
196: END IF;
197: END IF;
198: IF p_payment_type IS NOT NULL THEN

Line 199: FND_FILE.put_line( FND_FILE.LOG,'4.7');

195: l_where:=l_where||' and p.resource_id= '|| p_collector;
196: END IF;
197: END IF;
198: IF p_payment_type IS NOT NULL THEN
199: FND_FILE.put_line( FND_FILE.LOG,'4.7');
200: l_where:=l_where||' and l.lookup_code='''||p_payment_type||'''';
201: select meaning
202: into l_pay_typ_meaning
203: from iex_lookups_v

Line 247: FND_FILE.put_line( FND_FILE.LOG,'qry-->'||l_query);

243: -- END IF;
244: l_order_by :=' order by d.cust_account_id,p.payment_id';
245: l_query:=l_query||l_where;
246: l_query:=l_query||l_order_by;
247: FND_FILE.put_line( FND_FILE.LOG,'qry-->'||l_query);
248: ctx := DBMS_XMLQUERY.newContext(l_query);
249: -- FND_FILE.put_line( FND_FILE.LOG,'21');
250: END IF;
251: --report mode SUMMARY

Line 249: -- FND_FILE.put_line( FND_FILE.LOG,'21');

245: l_query:=l_query||l_where;
246: l_query:=l_query||l_order_by;
247: FND_FILE.put_line( FND_FILE.LOG,'qry-->'||l_query);
248: ctx := DBMS_XMLQUERY.newContext(l_query);
249: -- FND_FILE.put_line( FND_FILE.LOG,'21');
250: END IF;
251: --report mode SUMMARY
252: IF p_summ_det = 'SUMMARY' THEN
253: IF p_goal IS NOT NULL THEN

Line 255: -- FND_FILE.put_line( FND_FILE.LOG,'4.8');

251: --report mode SUMMARY
252: IF p_summ_det = 'SUMMARY' THEN
253: IF p_goal IS NOT NULL THEN
254: IF (p_goal_amount IS NOT NULL AND p_goal_amount >0) THEN
255: -- FND_FILE.put_line( FND_FILE.LOG,'4.8');
256: FND_FILE.put_line( FND_FILE.LOG,'goal-->'||p_goal);
257: IF p_goal ='HOURLY' THEN
258: l_hourly_goal:=round(p_goal_amount,2);
259: l_daily_goal :=round(p_goal_amount*8,2); --default 8 hours per day

Line 256: FND_FILE.put_line( FND_FILE.LOG,'goal-->'||p_goal);

252: IF p_summ_det = 'SUMMARY' THEN
253: IF p_goal IS NOT NULL THEN
254: IF (p_goal_amount IS NOT NULL AND p_goal_amount >0) THEN
255: -- FND_FILE.put_line( FND_FILE.LOG,'4.8');
256: FND_FILE.put_line( FND_FILE.LOG,'goal-->'||p_goal);
257: IF p_goal ='HOURLY' THEN
258: l_hourly_goal:=round(p_goal_amount,2);
259: l_daily_goal :=round(p_goal_amount*8,2); --default 8 hours per day
260: FND_FILE.put_line( FND_FILE.LOG,'l_hourly_goal1-->'||l_hourly_goal);

Line 260: FND_FILE.put_line( FND_FILE.LOG,'l_hourly_goal1-->'||l_hourly_goal);

256: FND_FILE.put_line( FND_FILE.LOG,'goal-->'||p_goal);
257: IF p_goal ='HOURLY' THEN
258: l_hourly_goal:=round(p_goal_amount,2);
259: l_daily_goal :=round(p_goal_amount*8,2); --default 8 hours per day
260: FND_FILE.put_line( FND_FILE.LOG,'l_hourly_goal1-->'||l_hourly_goal);
261: ELSE
262: l_hourly_goal:=round(p_goal_amount/8,2);
263: l_daily_goal :=round(p_goal_amount,2);
264: FND_FILE.put_line( FND_FILE.LOG,'l_hourly_goal2-->'||l_hourly_goal);

Line 264: FND_FILE.put_line( FND_FILE.LOG,'l_hourly_goal2-->'||l_hourly_goal);

260: FND_FILE.put_line( FND_FILE.LOG,'l_hourly_goal1-->'||l_hourly_goal);
261: ELSE
262: l_hourly_goal:=round(p_goal_amount/8,2);
263: l_daily_goal :=round(p_goal_amount,2);
264: FND_FILE.put_line( FND_FILE.LOG,'l_hourly_goal2-->'||l_hourly_goal);
265: END IF;
266: ELSE
267: FND_FILE.put_line( FND_FILE.LOG,'Goal Amount cannot be null or negative');
268: END IF;

Line 267: FND_FILE.put_line( FND_FILE.LOG,'Goal Amount cannot be null or negative');

263: l_daily_goal :=round(p_goal_amount,2);
264: FND_FILE.put_line( FND_FILE.LOG,'l_hourly_goal2-->'||l_hourly_goal);
265: END IF;
266: ELSE
267: FND_FILE.put_line( FND_FILE.LOG,'Goal Amount cannot be null or negative');
268: END IF;
269: END IF;
270: -- FND_FILE.put_line( FND_FILE.LOG,'5');
271: l_query:='SELECT IEX_UTILITIES.REPLACE_SPECIAL_CHARS(j.source_name) Collector,'||

Line 270: -- FND_FILE.put_line( FND_FILE.LOG,'5');

266: ELSE
267: FND_FILE.put_line( FND_FILE.LOG,'Goal Amount cannot be null or negative');
268: END IF;
269: END IF;
270: -- FND_FILE.put_line( FND_FILE.LOG,'5');
271: l_query:='SELECT IEX_UTILITIES.REPLACE_SPECIAL_CHARS(j.source_name) Collector,'||
272: 'SUM(gl_currency_api.convert_amount(r.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',r.amount)) Total_Amount_Collected,'||
273: 'ROUND((SUM(gl_currency_api.convert_amount(r.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',r.amount))/((to_date('''||l_to_date||
274: ''',''DD-MON-RRRR'')-to_date('''||l_from_date||''',''DD-MON-RRRR''))+1))/8,2) Hourly_Average,'|| l_hourly_goal||' Hourly_Goal,'||

Line 298: FND_FILE.put_line( FND_FILE.LOG,'l_query_summ-->'||l_query);

294: l_group_by :=' group by IEX_UTILITIES.REPLACE_SPECIAL_CHARS(j.source_name)';
295: l_query:=l_query||l_where;
296: l_query:=l_query||l_group_by;
297: --call procedure to calculate pmt_cnt and pmt_amt
298: FND_FILE.put_line( FND_FILE.LOG,'l_query_summ-->'||l_query);
299: ctx := DBMS_XMLQUERY.newContext(l_query);
300: -- FND_FILE.put_line( FND_FILE.LOG,'7.5');
301: END IF;
302: DBMS_XMLQUERY.setRaiseNoRowsException(ctx,TRUE);

Line 300: -- FND_FILE.put_line( FND_FILE.LOG,'7.5');

296: l_query:=l_query||l_group_by;
297: --call procedure to calculate pmt_cnt and pmt_amt
298: FND_FILE.put_line( FND_FILE.LOG,'l_query_summ-->'||l_query);
299: ctx := DBMS_XMLQUERY.newContext(l_query);
300: -- FND_FILE.put_line( FND_FILE.LOG,'7.5');
301: END IF;
302: DBMS_XMLQUERY.setRaiseNoRowsException(ctx,TRUE);
303:
304: -- Bind Mandatory Variables

Line 313: FND_FILE.put_line( FND_FILE.LOG,'l_res_len-->'||dbms_lob.getlength(l_result));

309: BEGIN
310: l_result := DBMS_XMLQUERY.getXML(ctx);
311: DBMS_XMLQUERY.closeContext(ctx);
312: l_rows_processed := 1;
313: FND_FILE.put_line( FND_FILE.LOG,'l_res_len-->'||dbms_lob.getlength(l_result));
314: --FND_FILE.put_line( FND_FILE.LOG,'l_res-->'||l_result);
315: EXCEPTION
316: WHEN OTHERS THEN
317: DBMS_XMLQUERY.getExceptionContent(ctx,l_errNo,l_errMsg);

Line 314: --FND_FILE.put_line( FND_FILE.LOG,'l_res-->'||l_result);

310: l_result := DBMS_XMLQUERY.getXML(ctx);
311: DBMS_XMLQUERY.closeContext(ctx);
312: l_rows_processed := 1;
313: FND_FILE.put_line( FND_FILE.LOG,'l_res_len-->'||dbms_lob.getlength(l_result));
314: --FND_FILE.put_line( FND_FILE.LOG,'l_res-->'||l_result);
315: EXCEPTION
316: WHEN OTHERS THEN
317: DBMS_XMLQUERY.getExceptionContent(ctx,l_errNo,l_errMsg);
318: FND_FILE.put_line( FND_FILE.LOG,'l_errMsg-->'||l_errMsg);

Line 318: FND_FILE.put_line( FND_FILE.LOG,'l_errMsg-->'||l_errMsg);

314: --FND_FILE.put_line( FND_FILE.LOG,'l_res-->'||l_result);
315: EXCEPTION
316: WHEN OTHERS THEN
317: DBMS_XMLQUERY.getExceptionContent(ctx,l_errNo,l_errMsg);
318: FND_FILE.put_line( FND_FILE.LOG,'l_errMsg-->'||l_errMsg);
319: IF l_errNo = 1403 THEN
320: l_rows_processed := 0;
321: END IF;
322: DBMS_XMLQUERY.closeContext(ctx);

Line 325: -- FND_FILE.put_line( FND_FILE.LOG,'8') ;

321: END IF;
322: DBMS_XMLQUERY.closeContext(ctx);
323: END;
324: IF l_rows_processed <> 0 THEN
325: -- FND_FILE.put_line( FND_FILE.LOG,'8') ;
326:
327: --get the length of the rowset header
328: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
329: FND_FILE.put_line( FND_FILE.LOG,'l_res_off-->'||l_resultOffset) ;

Line 329: FND_FILE.put_line( FND_FILE.LOG,'l_res_off-->'||l_resultOffset) ;

325: -- FND_FILE.put_line( FND_FILE.LOG,'8') ;
326:
327: --get the length of the rowset header
328: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
329: FND_FILE.put_line( FND_FILE.LOG,'l_res_off-->'||l_resultOffset) ;
330: ELSE
331: l_resultOffset := 0;
332: END IF;
333:

Line 343: -- FND_FILE.put_line( FND_FILE.LOG,'10') ;

339: l_collector:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
340: end if;
341: l_new_line := '
342: ';
343: -- FND_FILE.put_line( FND_FILE.LOG,'10') ;
344: /* Prepare the tag for the report heading */
345: --Start adding for bug 10213070 snuthala 19th Oct 10
346: --l_xml_header := '';
347: -- Instead of hard coding the value, pick the charcter set value from "ICX: Client IANA Encoding" profile.

Line 371: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes0-->'||tempResult);

367: l_xml_header := l_xml_header ||l_new_line||' ';
368: l_close_tag := l_new_line||''||l_new_line;
369: l_xml_header_length := dbms_lob.getlength(l_xml_header);
370: tempResult :=l_xml_header;
371: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes0-->'||tempResult);
372: IF l_rows_processed <> 0 THEN
373: --copy result set to tempResult
374: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset, l_xml_header_length,l_resultOffset);
375: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes1-->'||tempResult);

Line 375: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes1-->'||tempResult);

371: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes0-->'||tempResult);
372: IF l_rows_processed <> 0 THEN
373: --copy result set to tempResult
374: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset, l_xml_header_length,l_resultOffset);
375: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes1-->'||tempResult);
376: ELSE
377:
378: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
379: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

Line 382: FND_FILE.put_line( FND_FILE.LOG,'5.base_curr'||g_base_curr);

378: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
379: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
380: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);
381: END IF;
382: FND_FILE.put_line( FND_FILE.LOG,'5.base_curr'||g_base_curr);
383: --append the close tag to tempResult
384: dbms_lob.writeAppend(tempResult, LENGTH(l_close_tag), l_close_tag);
385: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes2-->'||tempResult);
386: --print to the o/p file

Line 385: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes2-->'||tempResult);

381: END IF;
382: FND_FILE.put_line( FND_FILE.LOG,'5.base_curr'||g_base_curr);
383: --append the close tag to tempResult
384: dbms_lob.writeAppend(tempResult, LENGTH(l_close_tag), l_close_tag);
385: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes2-->'||tempResult);
386: --print to the o/p file
387: print_clob(lob_loc => tempResult);
388: FND_FILE.put_line( FND_FILE.LOG,'15--end') ;
389: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

Line 388: FND_FILE.put_line( FND_FILE.LOG,'15--end') ;

384: dbms_lob.writeAppend(tempResult, LENGTH(l_close_tag), l_close_tag);
385: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes2-->'||tempResult);
386: --print to the o/p file
387: print_clob(lob_loc => tempResult);
388: FND_FILE.put_line( FND_FILE.LOG,'15--end') ;
389: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
390: EXCEPTION
391: WHEN OTHERS THEN
392: FND_FILE.put_line( FND_FILE.LOG,'err-->'||sqlerrm);

Line 392: FND_FILE.put_line( FND_FILE.LOG,'err-->'||sqlerrm);

388: FND_FILE.put_line( FND_FILE.LOG,'15--end') ;
389: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
390: EXCEPTION
391: WHEN OTHERS THEN
392: FND_FILE.put_line( FND_FILE.LOG,'err-->'||sqlerrm);
393: LogMessage (FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || '-end');
394: END gen_xml_data_pcol;
395:
396: BEGIN