DBA Data[Home] [Help]

APPS.IGC_CC_YEP_PROCESS_PKG dependencies on FND_LOG

Line 6: --following variables added for bug 3199488: fnd logging changes: sdixit

2: /* $Header: IGCCYEPB.pls 120.16.12010000.3 2008/11/04 09:43:17 dramired ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_YEP_PROCESS_PKG';
5: g_debug_flag VARCHAR2(1) := 'N' ;
6: --following variables added for bug 3199488: fnd logging changes: sdixit
7: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_state_level number := FND_LOG.LEVEL_STATEMENT;
9: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
10: g_event_level number := FND_LOG.LEVEL_EVENT;

Line 7: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_YEP_PROCESS_PKG';
5: g_debug_flag VARCHAR2(1) := 'N' ;
6: --following variables added for bug 3199488: fnd logging changes: sdixit
7: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_state_level number := FND_LOG.LEVEL_STATEMENT;
9: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
10: g_event_level number := FND_LOG.LEVEL_EVENT;
11: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;

Line 8: g_state_level number := FND_LOG.LEVEL_STATEMENT;

4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_YEP_PROCESS_PKG';
5: g_debug_flag VARCHAR2(1) := 'N' ;
6: --following variables added for bug 3199488: fnd logging changes: sdixit
7: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_state_level number := FND_LOG.LEVEL_STATEMENT;
9: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
10: g_event_level number := FND_LOG.LEVEL_EVENT;
11: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
12: g_error_level number := FND_LOG.LEVEL_ERROR;

Line 9: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;

5: g_debug_flag VARCHAR2(1) := 'N' ;
6: --following variables added for bug 3199488: fnd logging changes: sdixit
7: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_state_level number := FND_LOG.LEVEL_STATEMENT;
9: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
10: g_event_level number := FND_LOG.LEVEL_EVENT;
11: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
12: g_error_level number := FND_LOG.LEVEL_ERROR;
13: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

Line 10: g_event_level number := FND_LOG.LEVEL_EVENT;

6: --following variables added for bug 3199488: fnd logging changes: sdixit
7: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_state_level number := FND_LOG.LEVEL_STATEMENT;
9: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
10: g_event_level number := FND_LOG.LEVEL_EVENT;
11: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
12: g_error_level number := FND_LOG.LEVEL_ERROR;
13: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
14: g_path varchar2(500) := 'igc.plsql.igccyepb.igc_cc_yep_process_pkg.';

Line 11: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;

7: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_state_level number := FND_LOG.LEVEL_STATEMENT;
9: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
10: g_event_level number := FND_LOG.LEVEL_EVENT;
11: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
12: g_error_level number := FND_LOG.LEVEL_ERROR;
13: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
14: g_path varchar2(500) := 'igc.plsql.igccyepb.igc_cc_yep_process_pkg.';
15:

Line 12: g_error_level number := FND_LOG.LEVEL_ERROR;

8: g_state_level number := FND_LOG.LEVEL_STATEMENT;
9: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
10: g_event_level number := FND_LOG.LEVEL_EVENT;
11: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
12: g_error_level number := FND_LOG.LEVEL_ERROR;
13: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
14: g_path varchar2(500) := 'igc.plsql.igccyepb.igc_cc_yep_process_pkg.';
15:
16:

Line 13: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

9: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
10: g_event_level number := FND_LOG.LEVEL_EVENT;
11: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
12: g_error_level number := FND_LOG.LEVEL_ERROR;
13: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
14: g_path varchar2(500) := 'igc.plsql.igccyepb.igc_cc_yep_process_pkg.';
15:
16:
17:

Line 243: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

239: ROLLBACK TO S1;
240: l_EXCEPTION := NULL;
241: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADER_HST_INSERT');
242: IF(g_excep_level >= g_debug_level) THEN
243: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
244: END IF;
245: l_EXCEPTION := FND_MESSAGE.GET;
246: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
247: (PROCESS_TYPE,

Line 348: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

344: ROLLBACK TO S1;
345: l_EXCEPTION := NULL;
346: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINE_HST_INSERT');
347: IF(g_excep_level >= g_debug_level) THEN
348: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
349: END IF;
350: l_EXCEPTION := FND_MESSAGE.GET;
351:
352:

Line 462: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

458: ROLLBACK TO S1;
459: l_EXCEPTION := NULL;
460: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINES_UPDATE');
461: IF(g_excep_level >= g_debug_level) THEN
462: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
463: END IF;
464: l_EXCEPTION := FND_MESSAGE.GET;
465:
466:

Line 569: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

565: ROLLBACK TO S1;
566: l_EXCEPTION := NULL;
567: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_HST_INSERT');
568: IF(g_excep_level >= g_debug_level) THEN
569: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
570: END IF;
571: l_EXCEPTION := FND_MESSAGE.GET;
572:
573:

Line 670: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

666: ROLLBACK TO S1;
667: l_EXCEPTION := NULL;
668: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_UPDATE');
669: IF(g_excep_level >= g_debug_level) THEN
670: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
671: END IF;
672: l_EXCEPTION := FND_MESSAGE.GET;
673:
674:

Line 795: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

791: ROLLBACK TO S1;
792: l_EXCEPTION := NULL;
793: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADERS_UPDATE');
794: IF(g_excep_level >= g_debug_level) THEN
795: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
796: END IF;
797: l_EXCEPTION := FND_MESSAGE.GET;
798:
799:

Line 868: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

864: ROLLBACK TO S1;
865: l_EXCEPTION := NULL;
866: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACTION_HST_INSERT');
867: IF(g_excep_level >= g_debug_level) THEN
868: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
869: END IF;
870: l_EXCEPTION := FND_MESSAGE.GET;
871:
872:

Line 1165: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

1161:
1162: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
1163: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);
1164: IF(g_excep_level >= g_debug_level) THEN
1165: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1166: END IF;
1167: lv_message := fnd_message.get;
1168: errbuf := lv_message;
1169: retcode := 2;

Line 1314: fnd_log.string(g_excep_level,l_full_path,l_error_text);

1310: LOOP
1311: l_error_text := l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
1312:
1313: IF (g_excep_level >= g_debug_level) then
1314: fnd_log.string(g_excep_level,l_full_path,l_error_text);
1315: END IF;
1316:
1317: fnd_file.put_line (FND_FILE.LOG,
1318: l_error_text);

Line 1512: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

1508: l_EXCEPTION := NULL;
1509: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CC_EXIST');
1510: FND_MESSAGE.SET_TOKEN('YEP_YEAR',p_YEAR,TRUE);
1511: IF(g_excep_level >= g_debug_level) THEN
1512: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1513: END IF;
1514: l_EXCEPTION := FND_MESSAGE.GET;
1515:
1516:

Line 1706: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

1702: l_EXCEPTION := NULL;
1703: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADER_LOCK');
1704: FND_MESSAGE.SET_TOKEN('NUMBER',l_CC_NUM,TRUE);
1705: IF(g_excep_level >= g_debug_level) THEN
1706: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1707: END IF;
1708: l_EXCEPTION := FND_MESSAGE.GET;
1709:
1710:

Line 1751: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

1747: l_EXCEPTION := NULL;
1748: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_PO_LOCKED');
1749: FND_MESSAGE.SET_TOKEN('NUMBER',l_CC_NUM,TRUE);
1750: IF(g_excep_level >= g_debug_level) THEN
1751: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1752: END IF;
1753: l_EXCEPTION := FND_MESSAGE.GET;
1754:
1755: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

Line 1810: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

1806: l_EXCEPTION := NULL;
1807: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CC_PERIOD_STATUS');
1808: FND_MESSAGE.SET_TOKEN('PERIOD_NAME',V6.PERIOD_NAME,TRUE);
1809: IF(g_excep_level >= g_debug_level) THEN
1810: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1811: END IF;
1812: l_EXCEPTION := FND_MESSAGE.GET;
1813:
1814:

Line 1850: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

1846: l_EXCEPTION := NULL;
1847: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CC_LAST_PERIOD');
1848: FND_MESSAGE.SET_TOKEN('PERIOD_NAME',V6.PERIOD_NAME,TRUE);
1849: IF(g_excep_level >= g_debug_level) THEN
1850: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1851: END IF;
1852: l_EXCEPTION := FND_MESSAGE.GET;
1853:
1854:

Line 1893: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

1889: THEN
1890: l_EXCEPTION := NULL;
1891: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CC_PERIOD_EXISTS');
1892: IF(g_excep_level >= g_debug_level) THEN
1893: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1894: END IF;
1895: l_EXCEPTION := FND_MESSAGE.GET;
1896:
1897:

Line 1933: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

1929: l_EXCEPTION := NULL;
1930: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CC_FUTURE_PERIOD');
1931: FND_MESSAGE.SET_TOKEN('PERIOD_NAME',V7.PERIOD_NAME,TRUE);
1932: IF(g_excep_level >= g_debug_level) THEN
1933: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1934: END IF;
1935: l_EXCEPTION := FND_MESSAGE.GET;
1936:
1937:

Line 1975: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

1971: THEN
1972: l_EXCEPTION := NULL;
1973: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_GL_PERIOD_EXISTS');
1974: IF(g_excep_level >= g_debug_level) THEN
1975: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1976: END IF;
1977: l_EXCEPTION := FND_MESSAGE.GET;
1978:
1979:

Line 2010: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

2006: l_EXCEPTION := NULL;
2007: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_GL_FIRST_PERIOD');
2008: FND_MESSAGE.SET_TOKEN('PERIOD_NAME',V8.PERIOD_NAME,TRUE);
2009: IF(g_excep_level >= g_debug_level) THEN
2010: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
2011: END IF;
2012: l_EXCEPTION := FND_MESSAGE.GET;
2013:
2014: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

Line 2053: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

2049: THEN
2050: l_EXCEPTION := NULL;
2051: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_GL_LAST_PRD_EXISTS');
2052: IF(g_excep_level >= g_debug_level) THEN
2053: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
2054: END IF;
2055: l_EXCEPTION := FND_MESSAGE.GET;
2056:
2057: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

Line 2087: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

2083: l_EXCEPTION := NULL;
2084: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_GL_LAST_PERIOD');
2085: FND_MESSAGE.SET_TOKEN('PERIOD_NAME',V8.PERIOD_NAME,TRUE);
2086: IF(g_excep_level >= g_debug_level) THEN
2087: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
2088: END IF;
2089: l_EXCEPTION := FND_MESSAGE.GET;
2090:
2091: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

Line 2495: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

2491:
2492: l_EXCEPTION := NULL;
2493: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_COVER_REL_INSERT');
2494: IF(g_excep_level >= g_debug_level) THEN
2495: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
2496: END IF;
2497: l_EXCEPTION := FND_MESSAGE.GET;
2498:
2499:

Line 2625: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

2621: l_EXCEPTION := NULL;
2622: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_VAL_DUE_TO_ENC_FAIL');
2623: FND_MESSAGE.SET_TOKEN('NUMBER',l_CC_NUM,TRUE);
2624: IF(g_excep_level >= g_debug_level) THEN
2625: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
2626: END IF;
2627: l_EXCEPTION := FND_MESSAGE.GET;
2628:
2629: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

Line 2890: fnd_log.string(g_excep_level,l_full_path,l_error_text);

2886: FOR l_cur IN 1..l_msg_count LOOP
2887: l_error_text := l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
2888:
2889: IF (g_excep_level >= g_debug_level) then
2890: fnd_log.string(g_excep_level,l_full_path,l_error_text);
2891: END IF;
2892:
2893: fnd_file.put_line (FND_FILE.LOG,
2894: l_error_text);

Line 2915: fnd_log.string(g_excep_level,l_full_path,l_error_text);

2911: l_error_text := l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
2912:
2913: IF (g_excep_level >= g_debug_level) then
2914:
2915: fnd_log.string(g_excep_level,l_full_path,l_error_text);
2916: END IF;
2917:
2918: fnd_file.put_line(fnd_file.log,l_error_text);
2919: END LOOP;

Line 2925: fnd_log.string(g_excep_level,l_full_path,l_error_text);

2921: l_error_text := 'Error Returned but Error stack has no data';
2922:
2923: IF (g_excep_level >= g_debug_level) then
2924:
2925: fnd_log.string(g_excep_level,l_full_path,l_error_text);
2926: END IF;
2927:
2928: fnd_file.put_line(fnd_file.log,l_error_text);
2929: END IF;

Line 2934: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

2930: IF ( g_unexp_level >= g_debug_level ) THEN
2931: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2932: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2933: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2934: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2935: END IF;
2936:
2937: END YEAR_END_MAIN;
2938: