DBA Data[Home] [Help]

APPS.IEX_PAYMENT_COLL_RPT_PKG dependencies on FND_LOG

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

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

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

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

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

41: l_one_line VARCHAR2 (7000);
42: l_charset VARCHAR2(100);
43:
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

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

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));
132: l_to_date := TRUNC(fnd_date.canonical_to_date(p_date_to));

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

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

Line 393: LogMessage (FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || '-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
397: G_LOG_ENABLED := 'N';

Line 398: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

394: END gen_xml_data_pcol;
395:
396: BEGIN
397: G_LOG_ENABLED := 'N';
398: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
399:
400: /* getting msg logging info */
401: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
402: if (G_LOG_ENABLED = 'N') then

Line 403: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

399:
400: /* getting msg logging info */
401: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
402: if (G_LOG_ENABLED = 'N') then
403: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
404: else
405: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
406: end if;
407:

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

401: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
402: if (G_LOG_ENABLED = 'N') then
403: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
404: else
405: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
406: end if;
407:
408: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
409:

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

404: else
405: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
406: end if;
407:
408: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
409:
410: END;