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

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

21:
22: end if;
23:
24: if FND_GLOBAL.Conc_Request_Id is not null then
25: fnd_file.put_line(FND_FILE.LOG, p_msg);
26: end if;
27:
28: EXCEPTION
29: WHEN OTHERS THEN

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

60: offset => l_start,
61: nth => 1
62: );
63:
64: FND_FILE.put_line( FND_FILE.LOG,'l_end-->'||l_end);
65:
66:
67: IF (NVL (l_end, 0) < 1)
68: THEN

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

73: DBMS_LOB.SUBSTR (lob_loc => lob_loc,
74: amount => l_end - l_start,
75: offset => l_start
76: );
77: FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
78: FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
79: l_start := l_end + c_endline_len;
80: FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
81: FND_FILE.put_line( FND_FILE.LOG,'32');

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

74: amount => l_end - l_start,
75: offset => l_start
76: );
77: FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
78: FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
79: l_start := l_end + c_endline_len;
80: FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
81: FND_FILE.put_line( FND_FILE.LOG,'32');
82: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);

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

76: );
77: FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
78: FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
79: l_start := l_end + c_endline_len;
80: FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
81: FND_FILE.put_line( FND_FILE.LOG,'32');
82: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);
83:
84: END LOOP;

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

77: FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
78: FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
79: l_start := l_end + c_endline_len;
80: FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
81: FND_FILE.put_line( FND_FILE.LOG,'32');
82: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);
83:
84: END LOOP;
85:

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

78: FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
79: l_start := l_end + c_endline_len;
80: FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
81: FND_FILE.put_line( FND_FILE.LOG,'32');
82: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);
83:
84: END LOOP;
85:
86: END PRINT_CLOB;

Line 156: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');

152: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
153:
154: -- p_group_by_value_coll condition is added for bug 13844678 by bibeura
155: IF ( p_group_by_value_coll IS NULL AND p_group_by_mode = 'GROUP' ) THEN
156: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
157: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this report without Collector name at Group Level. *');
158: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Collector Name is a mandatory parameter when report is submitted with Group Level. *');
159: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Please select Collector name from the lov. *');
160: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');

Line 157: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this report without Collector name at Group Level. *');

153:
154: -- p_group_by_value_coll condition is added for bug 13844678 by bibeura
155: IF ( p_group_by_value_coll IS NULL AND p_group_by_mode = 'GROUP' ) THEN
156: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
157: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this report without Collector name at Group Level. *');
158: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Collector Name is a mandatory parameter when report is submitted with Group Level. *');
159: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Please select Collector name from the lov. *');
160: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
161:

Line 158: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Collector Name is a mandatory parameter when report is submitted with Group Level. *');

154: -- p_group_by_value_coll condition is added for bug 13844678 by bibeura
155: IF ( p_group_by_value_coll IS NULL AND p_group_by_mode = 'GROUP' ) THEN
156: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
157: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this report without Collector name at Group Level. *');
158: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Collector Name is a mandatory parameter when report is submitted with Group Level. *');
159: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Please select Collector name from the lov. *');
160: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
161:
162: l_status := fnd_concurrent.set_completion_status (status => 'ERROR',

Line 159: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Please select Collector name from the lov. *');

155: IF ( p_group_by_value_coll IS NULL AND p_group_by_mode = 'GROUP' ) THEN
156: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
157: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this report without Collector name at Group Level. *');
158: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Collector Name is a mandatory parameter when report is submitted with Group Level. *');
159: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Please select Collector name from the lov. *');
160: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
161:
162: l_status := fnd_concurrent.set_completion_status (status => 'ERROR',
163: message => 'Collector name is missing');

Line 160: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');

156: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
157: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this report without Collector name at Group Level. *');
158: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Collector Name is a mandatory parameter when report is submitted with Group Level. *');
159: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Please select Collector name from the lov. *');
160: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
161:
162: l_status := fnd_concurrent.set_completion_status (status => 'ERROR',
163: message => 'Collector name is missing');
164: return;

Line 210: FND_FILE.put_line( FND_FILE.LOG,'2.5');

206: end if;
207:
208: if p_pro_status is null then
209: l_pro_status:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
210: FND_FILE.put_line( FND_FILE.LOG,'2.5');
211: null;
212: else
213: FND_FILE.put_line( FND_FILE.LOG,'3');
214: -- l_pro_status:=p_pro_status;

Line 213: FND_FILE.put_line( FND_FILE.LOG,'3');

209: l_pro_status:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
210: FND_FILE.put_line( FND_FILE.LOG,'2.5');
211: null;
212: else
213: FND_FILE.put_line( FND_FILE.LOG,'3');
214: -- l_pro_status:=p_pro_status;
215: l_where:=l_where||' and ipd1.status='''||p_pro_status||'''';
216: select meaning
217: into l_pro_status

Line 225: FND_FILE.put_line( FND_FILE.LOG,'3.5');

221: end if;
222:
223: if p_pro_state is null then
224: l_pro_state:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
225: FND_FILE.put_line( FND_FILE.LOG,'3.5');
226: null;
227: else
228: FND_FILE.put_line( FND_FILE.LOG,'4');
229: -- l_pro_state:=p_pro_state;

Line 228: FND_FILE.put_line( FND_FILE.LOG,'4');

224: l_pro_state:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
225: FND_FILE.put_line( FND_FILE.LOG,'3.5');
226: null;
227: else
228: FND_FILE.put_line( FND_FILE.LOG,'4');
229: -- l_pro_state:=p_pro_state;
230: l_where:=l_where||' and ipd1.state='''||p_pro_state||'''';
231: select meaning
232: into l_pro_state

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

235: and lookup_type='IEX_PROMISE_STATES';
236: end if;
237:
238: if p_group_by='COLLECTOR' then
239: FND_FILE.put_line( FND_FILE.LOG,'4.5');
240: if p_group_by_value_coll is not null then
241: select source_name
242: into l_collector
243: from jtf_rs_resource_extns

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

264:
265: l_where:=l_where||' and ipd1.resource_id in '|| l_res_qry ;
266: l_where:=l_where||'))';
267: else
268: FND_FILE.put_line( FND_FILE.LOG,'This Collector can see only promises assigned to him');
269: l_where:=l_where||' and ipd1.resource_id= '|| p_group_by_value_coll;
270: end if;
271: else
272: FND_FILE.put_line( FND_FILE.LOG,'4.6');

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

268: FND_FILE.put_line( FND_FILE.LOG,'This Collector can see only promises assigned to him');
269: l_where:=l_where||' and ipd1.resource_id= '|| p_group_by_value_coll;
270: end if;
271: else
272: FND_FILE.put_line( FND_FILE.LOG,'4.6');
273: l_where:=l_where||' and ipd1.resource_id= '|| p_group_by_value_coll;
274: end if;
275: end if;
276: end if;

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

275: end if;
276: end if;
277:
278: if p_group_by='SCHEDULE' then
279: FND_FILE.put_line( FND_FILE.LOG,'5');
280: if p_group_by_value_sch is not null then
281: select source_code
282: into l_campaign
283: from ams_source_codes

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

283: from ams_source_codes
284: where source_code_id=p_group_by_value_sch;
285:
286:
287: FND_FILE.put_line( FND_FILE.LOG,'6');
288: l_where:=l_where||' and ipd1.campaign_sched_id ='||p_group_by_value_sch;
289: end if;
290: end if;
291: l_where:=l_where||' and (ipd1.campaign_sched_id in (Select source_code_id '||

Line 296: -- FND_FILE.put_line( FND_FILE.LOG,'base_curr'||g_base_curr);

292: 'from ams_source_codes '||
293: 'where arc_source_code_for =''CAMP'') '||
294: 'OR IPD1.campaign_sched_id is NULL)';
295:
296: -- FND_FILE.put_line( FND_FILE.LOG,'base_curr'||g_base_curr);
297:
298: --end of get filters
299:
300: /*if p_group_by_value_coll is null then

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

365:
366: l_order_by:=' order by ipd1.promise_detail_id,jrev.resource_name,amsc.source_code,ipd1.cust_account_id,ipd1.promise_amount)';
367: l_query:=l_query||l_where;
368: l_query:=l_query||l_order_by;
369: FND_FILE.put_line( FND_FILE.LOG,'qry-->'||l_query);
370: ctx := DBMS_XMLQUERY.newContext(l_query);
371: end if;
372:
373: --report mode SUMMARY

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

415: p_group_by,p_group_by_mode,p_group_by_value_coll,p_group_by_value_sch);
416: END IF;
417: -- end if;
418:
419: FND_FILE.put_line( FND_FILE.LOG,'l_query_summ-->'||l_query);
420: ctx := DBMS_XMLQUERY.newContext(l_query);
421: FND_FILE.put_line( FND_FILE.LOG,'7.5');
422:
423: end if;

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

417: -- end if;
418:
419: FND_FILE.put_line( FND_FILE.LOG,'l_query_summ-->'||l_query);
420: ctx := DBMS_XMLQUERY.newContext(l_query);
421: FND_FILE.put_line( FND_FILE.LOG,'7.5');
422:
423: end if;
424:
425: DBMS_XMLQUERY.setRaiseNoRowsException(ctx,TRUE);

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

448: DBMS_XMLQUERY.closeContext(ctx);
449: END;
450:
451: IF l_rows_processed <> 0 THEN
452: FND_FILE.put_line( FND_FILE.LOG,'8') ;
453: --get the length og the rowset header
454: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
455: FND_FILE.put_line( FND_FILE.LOG,'9') ;
456: ELSE

Line 455: FND_FILE.put_line( FND_FILE.LOG,'9') ;

451: IF l_rows_processed <> 0 THEN
452: FND_FILE.put_line( FND_FILE.LOG,'8') ;
453: --get the length og the rowset header
454: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
455: FND_FILE.put_line( FND_FILE.LOG,'9') ;
456: ELSE
457: l_resultOffset := 0;
458: END IF;
459:

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

462: from dual;
463:
464: l_new_line := '
465: ';
466: FND_FILE.put_line( FND_FILE.LOG,'10') ;
467: /* Prepare the tag for the report heading */
468: --Start adding for bug 10213070 snuthala 19th Oct 10
469: --l_xml_header := '';
470: -- Instead of hard coding the value, pick the charcter set value from "ICX: Client IANA Encoding" profile.

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

505: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
506: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
507: END IF;
508:
509: FND_FILE.put_line( FND_FILE.LOG,'5.base_curr'||g_base_curr);
510: --append the close tag to tempResult
511: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
512: --print to the o/p file
513: print_clob(lob_loc => tempResult);

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

511: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
512: --print to the o/p file
513: print_clob(lob_loc => tempResult);
514:
515: FND_FILE.put_line( FND_FILE.LOG,'15--end') ;
516: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +end');
517:
518: EXCEPTION
519: WHEN OTHERS THEN

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

516: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +end');
517:
518: EXCEPTION
519: WHEN OTHERS THEN
520: FND_FILE.put_line( FND_FILE.LOG,'err-->'||sqlerrm);
521: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || '-'||sqlerrm);
522: END gen_xml_data;
523:
524: --Procedure to calculate Payment count and Payment amount

Line 557: FND_FILE.put_line( FND_FILE.LOG,'*Start of pmt_amt_cnt procedure*******') ;

553: l_source_code_char varchar2(100);
554: l_hash_value number;
555: begin
556: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
557: FND_FILE.put_line( FND_FILE.LOG,'*****Start of pmt_amt_cnt procedure***********') ;
558:
559:
560: select nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'),'N')
561: into l_coll_rate

Line 581: FND_FILE.put_line( FND_FILE.LOG,'20') ;

577: into l_ctr_enbl_flg
578: from dual;
579:
580: if l_ctr_enbl_flg='N' then
581: FND_FILE.put_line( FND_FILE.LOG,'20') ;
582:
583: l_where :=l_where||' and ipd1.contract_id is null';
584: else
585: l_where :=l_where||' and ipd1.contract_id is not null';

Line 589: FND_FILE.put_line( FND_FILE.LOG,'20') ;

585: l_where :=l_where||' and ipd1.contract_id is not null';
586: end if;
587: */
588:
589: FND_FILE.put_line( FND_FILE.LOG,'20') ;
590: l_where :=l_where||' and ipd1.contract_id is null';
591:
592: --End for bug 10054672 gnramasa 27th Aug 10
593:

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

596: end if;
597:
598:
599: if p_date_from is not null and p_date_to is not null then
600: FND_FILE.put_line( FND_FILE.LOG,'21');
601: l_where:=l_where||' and ipd1.promise_date between(to_date('''||p_date_from||''', ''DD-MON-RR'')) and (to_date('''||p_date_to||''',''DD-MON-RR''))';
602: end if;
603:
604: l_pmt_sum:='select source_code_id,resource_id,pmt_count, pmt_amount from '||

Line 624: FND_FILE.put_line( FND_FILE.LOG,'23');

620: l_where:=l_where||' and ipd1.status='''||p_pro_status||'''';
621: end if;
622:
623: if p_group_by='COLLECTOR' then
624: FND_FILE.put_line( FND_FILE.LOG,'23');
625: if p_group_by_mode='GROUP' then
626: FND_FILE.put_line( FND_FILE.LOG,'24');
627: begin
628: select count(distinct(resource_id))

Line 626: FND_FILE.put_line( FND_FILE.LOG,'24');

622:
623: if p_group_by='COLLECTOR' then
624: FND_FILE.put_line( FND_FILE.LOG,'23');
625: if p_group_by_mode='GROUP' then
626: FND_FILE.put_line( FND_FILE.LOG,'24');
627: begin
628: select count(distinct(resource_id))
629: into l_resr_cnt
630: from

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

645:
646: l_where:=l_where||' and ipd1.resource_id in '|| l_resr_qry ;
647: l_where:=l_where||'))';
648: else
649: FND_FILE.put_line( FND_FILE.LOG,'This Collector can see only promises assigned to him');
650: l_where:=l_where||' and ipd1.resource_id= '|| p_group_by_value_coll;
651: end if;
652: exception
653: when others then

Line 654: FND_FILE.put_line( FND_FILE.LOG,'*error in fetching resource count**'||sqlerrm);

650: l_where:=l_where||' and ipd1.resource_id= '|| p_group_by_value_coll;
651: end if;
652: exception
653: when others then
654: FND_FILE.put_line( FND_FILE.LOG,'***error in fetching resource count****'||sqlerrm);
655: end;
656: else
657: FND_FILE.put_line( FND_FILE.LOG,'26');
658: l_where:=l_where||' and ipd1.resource_id= '|| p_group_by_value_coll;

Line 657: FND_FILE.put_line( FND_FILE.LOG,'26');

653: when others then
654: FND_FILE.put_line( FND_FILE.LOG,'***error in fetching resource count****'||sqlerrm);
655: end;
656: else
657: FND_FILE.put_line( FND_FILE.LOG,'26');
658: l_where:=l_where||' and ipd1.resource_id= '|| p_group_by_value_coll;
659: end if;
660: end if;
661:

Line 663: FND_FILE.put_line( FND_FILE.LOG,'27');

659: end if;
660: end if;
661:
662: if p_group_by='SCHEDULE' then
663: FND_FILE.put_line( FND_FILE.LOG,'27');
664: if p_group_by_value_sch is not null then
665: FND_FILE.put_line( FND_FILE.LOG,'28');
666: l_where:=l_where||' and ipd1.campaign_sched_id ='||p_group_by_value_sch;
667: l_group_by:=' group by amsc.source_code_id,amsc.source_code,jrev.resource_id,jrev.resource_name)';

Line 665: FND_FILE.put_line( FND_FILE.LOG,'28');

661:
662: if p_group_by='SCHEDULE' then
663: FND_FILE.put_line( FND_FILE.LOG,'27');
664: if p_group_by_value_sch is not null then
665: FND_FILE.put_line( FND_FILE.LOG,'28');
666: l_where:=l_where||' and ipd1.campaign_sched_id ='||p_group_by_value_sch;
667: l_group_by:=' group by amsc.source_code_id,amsc.source_code,jrev.resource_id,jrev.resource_name)';
668: end if;
669: end if;

Line 670: FND_FILE.put_line( FND_FILE.LOG,'28.5');

666: l_where:=l_where||' and ipd1.campaign_sched_id ='||p_group_by_value_sch;
667: l_group_by:=' group by amsc.source_code_id,amsc.source_code,jrev.resource_id,jrev.resource_name)';
668: end if;
669: end if;
670: FND_FILE.put_line( FND_FILE.LOG,'28.5');
671: l_where:=l_where||' and (ipd1.campaign_sched_id in (Select source_code_id '||
672: 'from ams_source_codes '||
673: 'where arc_source_code_for =''CAMP'') '||
674: 'OR IPD1.campaign_sched_id is NULL)';

Line 682: FND_FILE.put_line( FND_FILE.LOG,'l_pmt_summ-->'||l_pmt_sum);

678:
679: l_pmt_sum:=l_pmt_sum||l_where;
680: l_pmt_sum:=l_pmt_sum||l_group_by;
681:
682: FND_FILE.put_line( FND_FILE.LOG,'l_pmt_summ-->'||l_pmt_sum);
683:
684: open pmtdet for l_pmt_sum;
685: loop
686: fetch pmtdet into l_temp_source_code_id,l_temp_resource_id,l_temp_pmt_count,l_temp_pmt_amount;

Line 713: FND_FILE.put_line( FND_FILE.LOG,'in loop');

709:
710:
711: l_pmt_cnt(l_hash_value):=l_temp_pmt_count;
712: l_pmt_amt(l_hash_value):=l_temp_pmt_amount;
713: FND_FILE.put_line( FND_FILE.LOG,'in loop');
714: FND_FILE.put_line( FND_FILE.LOG,l_pmt_cnt(l_hash_value));
715: FND_FILE.put_line( FND_FILE.LOG,l_pmt_amt(l_hash_value));
716: end loop;
717: --end if;

Line 714: FND_FILE.put_line( FND_FILE.LOG,l_pmt_cnt(l_hash_value));

710:
711: l_pmt_cnt(l_hash_value):=l_temp_pmt_count;
712: l_pmt_amt(l_hash_value):=l_temp_pmt_amount;
713: FND_FILE.put_line( FND_FILE.LOG,'in loop');
714: FND_FILE.put_line( FND_FILE.LOG,l_pmt_cnt(l_hash_value));
715: FND_FILE.put_line( FND_FILE.LOG,l_pmt_amt(l_hash_value));
716: end loop;
717: --end if;
718: close pmtdet;

Line 715: FND_FILE.put_line( FND_FILE.LOG,l_pmt_amt(l_hash_value));

711: l_pmt_cnt(l_hash_value):=l_temp_pmt_count;
712: l_pmt_amt(l_hash_value):=l_temp_pmt_amount;
713: FND_FILE.put_line( FND_FILE.LOG,'in loop');
714: FND_FILE.put_line( FND_FILE.LOG,l_pmt_cnt(l_hash_value));
715: FND_FILE.put_line( FND_FILE.LOG,l_pmt_amt(l_hash_value));
716: end loop;
717: --end if;
718: close pmtdet;
719: FND_FILE.put_line( FND_FILE.LOG,'29');

Line 719: FND_FILE.put_line( FND_FILE.LOG,'29');

715: FND_FILE.put_line( FND_FILE.LOG,l_pmt_amt(l_hash_value));
716: end loop;
717: --end if;
718: close pmtdet;
719: FND_FILE.put_line( FND_FILE.LOG,'29');
720: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
721: exception
722: when others then
723: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || '-'||sqlerrm);

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

720: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
721: exception
722: when others then
723: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || '-'||sqlerrm);
724: FND_FILE.put_line( FND_FILE.LOG,'err in proc-->'||sqlerrm);
725: end calc_pmt_amt_cnt;
726:
727: function get_pmt_count(p_resource_id number,p_source_code_id in number) return number
728: is

Line 758: FND_FILE.put_line( FND_FILE.LOG,'30');

754: 25000);
755:
756:
757: if l_pmt_cnt.exists(l_hash_value) then
758: FND_FILE.put_line( FND_FILE.LOG,'30');
759: return l_pmt_cnt(l_hash_value);
760: else
761: return 0;
762: end if;

Line 793: FND_FILE.put_line( FND_FILE.LOG,'31');

789: l_resource_char||'@*?'||l_source_code_char,
790: 1000,
791: 25000);
792: if l_pmt_amt.exists(l_hash_value) then
793: FND_FILE.put_line( FND_FILE.LOG,'31');
794: return l_pmt_amt(l_hash_value);
795: else
796: return 0;
797: end if;