DBA Data[Home] [Help]

APPS.IEX_PAYMENT_CAMP_RPT_PKG dependencies on FND_LOG

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

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

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

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

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

41: /*-----------------------------------------------------------------------+
42: | Cursor Declarations |
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 125: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || '');

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;
129:

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

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

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

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);
400: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' -');
401: END gen_xml_data_pcamp;
402: BEGIN
403: G_LOG_ENABLED := 'N';
404: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

Line 404: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

400: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' -');
401: END gen_xml_data_pcamp;
402: BEGIN
403: G_LOG_ENABLED := 'N';
404: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
405:
406: /* getting msg logging info */
407: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
408: if (G_LOG_ENABLED = 'N') then

Line 409: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

405:
406: /* getting msg logging info */
407: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
408: if (G_LOG_ENABLED = 'N') then
409: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
410: else
411: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
412: end if;
413:

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

407: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
408: if (G_LOG_ENABLED = 'N') then
409: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
410: else
411: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
412: end if;
413:
414: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
415:

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

410: else
411: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
412: end if;
413:
414: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
415:
416: END;