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_CAMP_RPT_PKG dependencies on FND_FILE

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

13:
14: end if;
15:
16: if FND_GLOBAL.Conc_Request_Id is not null then
17: fnd_file.put_line(FND_FILE.LOG, p_msg);
18: end if;
19:
20: EXCEPTION
21: 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_pcamp

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_pcamp
62: (

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

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

Line 166: -- FND_FILE.put_line( FND_FILE.LOG,'6');

162: select source_code
163: into l_campaign
164: from ams_source_codes
165: where source_code_id=p_campaign;
166: -- FND_FILE.put_line( FND_FILE.LOG,'6');
167: l_where:=l_where||' and p.campaign_sched_id ='||p_campaign;
168: else
169: l_where:=l_where||' and (p.campaign_sched_id in (Select source_code_id '||
170: 'from ams_source_codes '||

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

172: 'OR p.campaign_sched_id is NULL)';
173: end if;
174:
175: IF p_collector IS NOT NULL THEN
176: -- FND_FILE.put_line( FND_FILE.LOG,'4.5');
177: select source_name
178: into l_collector
179: from jtf_rs_resource_extns
180: where resource_id=p_collector;

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

197: 'where b.manager_person_id = a.source_id '|| 'and a.resource_id = '||p_collector;
198: l_where :=l_where||' and p.resource_id in '|| l_res_qry ;
199: l_where :=l_where||'))';
200: ELSE
201: FND_FILE.put_line( FND_FILE.LOG,'This Collector can see only promises assigned to him');
202: l_where:=l_where||' and p.resource_id= '|| p_collector;
203: END IF;
204: ELSE
205: -- FND_FILE.put_line( FND_FILE.LOG,'4.6');

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

201: FND_FILE.put_line( FND_FILE.LOG,'This Collector can see only promises assigned to him');
202: l_where:=l_where||' and p.resource_id= '|| p_collector;
203: END IF;
204: ELSE
205: -- FND_FILE.put_line( FND_FILE.LOG,'4.6');
206: l_where:=l_where||' and p.resource_id= '|| p_collector;
207: END IF;
208: END IF;
209:

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

213: l_campaign:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
214: end if;
215:
216: IF p_payment_type IS NOT NULL THEN
217: -- FND_FILE.put_line( FND_FILE.LOG,'4.7');
218: l_where:=l_where||' and l.lookup_code='''||p_payment_type||'''';
219: select meaning
220: into l_pay_typ_meaning
221: from iex_lookups_v

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

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

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

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

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

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

Line 260: FND_FILE.put_line( FND_FILE.LOG,'hourly-->'||p_goal);

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

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

260: FND_FILE.put_line( FND_FILE.LOG,'hourly-->'||p_goal);
261: IF p_goal ='HOURLY' THEN
262: l_hourly_goal:=round(p_goal_amount,2);
263: l_daily_goal :=round(p_goal_amount*8,2); --default 8 hours per day
264: FND_FILE.put_line( FND_FILE.LOG,'l_hourly_goal1-->'||l_hourly_goal);
265: ELSE
266: l_hourly_goal:=round(p_goal_amount/8,2);
267: l_daily_goal :=round(p_goal_amount,2);
268: FND_FILE.put_line( FND_FILE.LOG,'l_hourly_goal2-->'||l_hourly_goal);

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

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

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

267: l_daily_goal :=round(p_goal_amount,2);
268: FND_FILE.put_line( FND_FILE.LOG,'l_hourly_goal2-->'||l_hourly_goal);
269: END IF;
270: ELSE
271: FND_FILE.put_line( FND_FILE.LOG,'Goal Amount cannot be null or negative');
272: END IF;
273: END IF;
274:
275: --FND_FILE.put_line( FND_FILE.LOG,'5');

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

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

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

300: ' IEX_UTILITIES.REPLACE_SPECIAL_CHARS(j.source_name)' ;
301: l_query:=l_query||l_where;
302: l_query:=l_query||l_group_by;
303: --call procedure to calculate pmt_cnt and pmt_amt
304: FND_FILE.put_line( FND_FILE.LOG,'l_query_summ-->'||l_query);
305: ctx := DBMS_XMLQUERY.newContext(l_query);
306: -- FND_FILE.put_line( FND_FILE.LOG,'7.5');
307: END IF;
308: DBMS_XMLQUERY.setRaiseNoRowsException(ctx,TRUE);

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

302: l_query:=l_query||l_group_by;
303: --call procedure to calculate pmt_cnt and pmt_amt
304: FND_FILE.put_line( FND_FILE.LOG,'l_query_summ-->'||l_query);
305: ctx := DBMS_XMLQUERY.newContext(l_query);
306: -- FND_FILE.put_line( FND_FILE.LOG,'7.5');
307: END IF;
308: DBMS_XMLQUERY.setRaiseNoRowsException(ctx,TRUE);
309:
310: -- Bind Mandatory Variables

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

315: BEGIN
316: l_result := DBMS_XMLQUERY.getXML(ctx);
317: DBMS_XMLQUERY.closeContext(ctx);
318: l_rows_processed := 1;
319: FND_FILE.put_line( FND_FILE.LOG,'l_res_len-->'||dbms_lob.getlength(l_result));
320: --FND_FILE.put_line( FND_FILE.LOG,'l_res-->'||l_result);
321: EXCEPTION
322: WHEN OTHERS THEN
323: DBMS_XMLQUERY.getExceptionContent(ctx,l_errNo,l_errMsg);

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

316: l_result := DBMS_XMLQUERY.getXML(ctx);
317: DBMS_XMLQUERY.closeContext(ctx);
318: l_rows_processed := 1;
319: FND_FILE.put_line( FND_FILE.LOG,'l_res_len-->'||dbms_lob.getlength(l_result));
320: --FND_FILE.put_line( FND_FILE.LOG,'l_res-->'||l_result);
321: EXCEPTION
322: WHEN OTHERS THEN
323: DBMS_XMLQUERY.getExceptionContent(ctx,l_errNo,l_errMsg);
324: FND_FILE.put_line( FND_FILE.LOG,'l_errMsg-->'||l_errMsg);

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

320: --FND_FILE.put_line( FND_FILE.LOG,'l_res-->'||l_result);
321: EXCEPTION
322: WHEN OTHERS THEN
323: DBMS_XMLQUERY.getExceptionContent(ctx,l_errNo,l_errMsg);
324: FND_FILE.put_line( FND_FILE.LOG,'l_errMsg-->'||l_errMsg);
325: IF l_errNo = 1403 THEN
326: l_rows_processed := 0;
327: END IF;
328: DBMS_XMLQUERY.closeContext(ctx);

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

327: END IF;
328: DBMS_XMLQUERY.closeContext(ctx);
329: END;
330: IF l_rows_processed <> 0 THEN
331: -- FND_FILE.put_line( FND_FILE.LOG,'8') ;
332:
333: --get the length of the rowset header
334: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
335: FND_FILE.put_line( FND_FILE.LOG,'l_res_off-->'||l_resultOffset) ;

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

331: -- FND_FILE.put_line( FND_FILE.LOG,'8') ;
332:
333: --get the length of the rowset header
334: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
335: FND_FILE.put_line( FND_FILE.LOG,'l_res_off-->'||l_resultOffset) ;
336: ELSE
337: l_resultOffset := 0;
338: END IF;
339:

Line 344: FND_FILE.put_line( FND_FILE.LOG,' Sysdate '|| l_sysdate);

340: select trunc(sysdate)
341: into l_sysdate
342: from dual;
343:
344: FND_FILE.put_line( FND_FILE.LOG,' Sysdate '|| l_sysdate);
345: l_new_line := '
346: ';
347: -- FND_FILE.put_line( FND_FILE.LOG,'10') ;
348: /* Prepare the tag for the report heading */

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

343:
344: FND_FILE.put_line( FND_FILE.LOG,' Sysdate '|| l_sysdate);
345: l_new_line := '
346: ';
347: -- FND_FILE.put_line( FND_FILE.LOG,'10') ;
348: /* Prepare the tag for the report heading */
349: --Start adding for bug 10213070 snuthala 19th Oct 10
350: --l_xml_header := '';
351: -- Instead of hard coding the value, pick the charcter set value from "ICX: Client IANA Encoding" profile.

Line 365: FND_FILE.put_line( FND_FILE.LOG, 'xml header '|| l_xml_header);

361: l_xml_header := l_xml_header ||l_new_line||' ' ||''||'';
362: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_LEVEL',p_report_level)||'';
363: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_MODE',p_summ_det)||'';
364: l_xml_header := l_xml_header ||l_new_line||' ' ||l_pay_typ_meaning||'';
365: FND_FILE.put_line( FND_FILE.LOG, 'xml header '|| l_xml_header);
366: IF p_summ_det ='SUMMARY' THEN
367: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_GOAL_TYPES',p_goal)||'';
368: l_xml_header := l_xml_header ||l_new_line||' ' ||p_goal_amount||'';
369: END IF;

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

373: l_xml_header := l_xml_header ||l_new_line||' ';
374: l_close_tag := l_new_line||''||l_new_line;
375: l_xml_header_length := dbms_lob.getlength(l_xml_header);
376: tempResult :=l_xml_header;
377: FND_FILE.put_line( FND_FILE.LOG,'tempRes0-->'||tempResult);
378: IF l_rows_processed <> 0 THEN
379: --copy result set to tempResult
380: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset, l_xml_header_length,l_resultOffset);
381: -- FND_FILE.put_line( FND_FILE.LOG,'11') ;

Line 381: -- FND_FILE.put_line( FND_FILE.LOG,'11') ;

377: FND_FILE.put_line( FND_FILE.LOG,'tempRes0-->'||tempResult);
378: IF l_rows_processed <> 0 THEN
379: --copy result set to tempResult
380: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset, l_xml_header_length,l_resultOffset);
381: -- FND_FILE.put_line( FND_FILE.LOG,'11') ;
382: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes1-->'||tempResult);
383: ELSE
384: -- FND_FILE.put_line( FND_FILE.LOG,'12') ;
385: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

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

378: IF l_rows_processed <> 0 THEN
379: --copy result set to tempResult
380: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset, l_xml_header_length,l_resultOffset);
381: -- FND_FILE.put_line( FND_FILE.LOG,'11') ;
382: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes1-->'||tempResult);
383: ELSE
384: -- FND_FILE.put_line( FND_FILE.LOG,'12') ;
385: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
386: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

Line 384: -- FND_FILE.put_line( FND_FILE.LOG,'12') ;

380: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset, l_xml_header_length,l_resultOffset);
381: -- FND_FILE.put_line( FND_FILE.LOG,'11') ;
382: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes1-->'||tempResult);
383: ELSE
384: -- FND_FILE.put_line( FND_FILE.LOG,'12') ;
385: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
386: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
387: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);
388: END IF;

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

388: END IF;
389:
390: --append the close tag to tempResult
391: dbms_lob.writeAppend(tempResult, LENGTH(l_close_tag), l_close_tag);
392: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes2-->'||tempResult);
393: --print to the o/p file
394: print_clob(lob_loc => tempResult);
395: FND_FILE.put_line( FND_FILE.LOG,'15--end') ;
396: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || '-end');

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

391: dbms_lob.writeAppend(tempResult, LENGTH(l_close_tag), l_close_tag);
392: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes2-->'||tempResult);
393: --print to the o/p file
394: print_clob(lob_loc => tempResult);
395: FND_FILE.put_line( FND_FILE.LOG,'15--end') ;
396: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || '-end');
397: EXCEPTION
398: WHEN OTHERS THEN
399: -- dbms_output.put_line('err'||sqlerrm);