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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 129: FND_FILE.put_line( FND_FILE.LOG,'Begin procedure');

125: l_to_date date;
126:
127: BEGIN
128: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
129: FND_FILE.put_line( FND_FILE.LOG,'Begin procedure');
130: l_from_date := TRUNC(fnd_date.canonical_to_date(p_date_from));
131: l_to_date := TRUNC(fnd_date.canonical_to_date(p_date_to));
132:
133: if p_date_from is not null and p_date_to is not null then

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

135: l_where:=l_where||'and trunc(jii.creation_date) <=to_date('''||l_to_date||''',''DD-MM-RRRR'')+1 ';
136: end if;
137:
138: IF (p_coll_camp_typ='COLLECTOR' OR p_coll_camp_typ='CAMPAIGN') THEN
139: FND_FILE.put_line( FND_FILE.LOG,'4.5');
140: if p_collector is not null then
141: IF p_report_level='GROUP' THEN
142: SELECT DISTINCT COUNT(resource_id)
143: INTO l_res_cnt

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

157: 'where b.manager_person_id = a.source_id '|| 'and a.resource_id = '||p_collector;
158: l_where :=l_where||' and jii.resource_id in '|| l_res_qry ;
159: l_where :=l_where||'))';
160: ELSE
161: FND_FILE.put_line( FND_FILE.LOG,'This Collector can see only promises assigned to him');
162: l_where:=l_where||' and jii.resource_id= '|| p_collector;
163: END IF;
164: ELSE
165: FND_FILE.put_line( FND_FILE.LOG,'4.6');

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

161: FND_FILE.put_line( FND_FILE.LOG,'This Collector can see only promises assigned to him');
162: l_where:=l_where||' and jii.resource_id= '|| p_collector;
163: END IF;
164: ELSE
165: FND_FILE.put_line( FND_FILE.LOG,'4.6');
166: l_where:=l_where||' and jii.resource_id= '|| p_collector;
167: END IF;
168: end if;
169: END IF;

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

168: end if;
169: END IF;
170:
171: IF p_campaign IS NOT NULL THEN
172: FND_FILE.put_line( FND_FILE.LOG,'6');
173: l_where:=l_where||' and jii.source_code_id ='||p_campaign;
174: else
175: l_where:=l_where||' and (jii.source_code_id in (Select source_code_id '||
176: 'from ams_source_codes '||

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

232: 'and jii.source_code= amsc.source_code(+) ';
233:
234: l_query:=l_query||l_where;
235: l_query:=l_query||l_group_by;
236: FND_FILE.put_line( FND_FILE.LOG,'qry-->'||l_query);
237: LogMessage(FND_LOG.LEVEL_STATEMENT, 'query: ' || l_query);
238: ctx := DBMS_XMLQUERY.newContext(l_query);
239: DBMS_XMLQUERY.setRaiseNoRowsException(ctx,TRUE);
240: -- Bind Mandatory Variables

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

256: END IF;
257: DBMS_XMLQUERY.closeContext(ctx);
258: END;
259: IF l_rows_processed <> 0 THEN
260: FND_FILE.put_line( FND_FILE.LOG,'8') ;
261: --get the length og the rowset header
262: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
263: FND_FILE.put_line( FND_FILE.LOG,'9') ;
264: ELSE

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

259: IF l_rows_processed <> 0 THEN
260: FND_FILE.put_line( FND_FILE.LOG,'8') ;
261: --get the length og the rowset header
262: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
263: FND_FILE.put_line( FND_FILE.LOG,'9') ;
264: ELSE
265: l_resultOffset := 0;
266: END IF;
267:

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

288: from dual;
289:
290: l_new_line := '
291: ';
292: FND_FILE.put_line( FND_FILE.LOG,'10') ;
293: /* Prepare the tag for the report heading */
294: --Start adding for bug 10213070 snuthala 19th Oct 10
295: --l_xml_header := '';
296: -- Instead of hard coding the value, pick the charcter set value from "ICX: Client IANA Encoding" profile.

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

327: --append the close tag to tempResult
328: dbms_lob.writeAppend(tempResult, LENGTH(l_close_tag), l_close_tag);
329: --print to the o/p file
330: print_clob(lob_loc => tempResult);
331: FND_FILE.put_line( FND_FILE.LOG,'15--end') ;
332: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || '-end');
333: EXCEPTION
334: WHEN OTHERS THEN
335: --dbms_output.put_line('err'||sqlerrm);