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_LOG

Line 13: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);

9: IS
10: BEGIN
11: if (p_msg_level >= G_MSG_LEVEL) then
12:
13: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);
14:
15: end if;
16:
17: if FND_GLOBAL.Conc_Request_Id is not null then

Line 23: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);

19: end if;
20:
21: EXCEPTION
22: WHEN OTHERS THEN
23: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);
24: END;
25:
26: PROCEDURE PRINT_CLOB
27: (

Line 46: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

42: /*-----------------------------------------------------------------------+
43: | Cursor Declarations |
44: +-----------------------------------------------------------------------*/
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

Line 128: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

124: l_from_date date;
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:

Line 237: LogMessage(FND_LOG.LEVEL_STATEMENT, 'query: ' || l_query);

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
241: --DBMS_XMLQUERY.setBindValue(ctx, 'p_date_from', p_date_from);

Line 332: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || '-end');

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);
336: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' -');

Line 336: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' -');

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);
336: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' -');
337: END gen_xml_data_collcamp;
338:
339: BEGIN
340: G_LOG_ENABLED := 'N';

Line 341: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

337: END gen_xml_data_collcamp;
338:
339: BEGIN
340: G_LOG_ENABLED := 'N';
341: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
342:
343: /* getting msg logging info */
344: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
345: if (G_LOG_ENABLED = 'N') then

Line 346: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

342:
343: /* getting msg logging info */
344: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
345: if (G_LOG_ENABLED = 'N') then
346: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
347: else
348: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
349: end if;
350:

Line 348: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

344: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
345: if (G_LOG_ENABLED = 'N') then
346: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
347: else
348: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
349: end if;
350:
351: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
352:

Line 351: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);

347: else
348: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
349: end if;
350:
351: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
352:
353: END;