DBA Data[Home] [Help]

APPS.IBY_ASSIGN_PUB dependencies on FND_LOG

Line 8: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

4: --
5: -- Declare global variables
6: --
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_ASSIGN_PUB';
8: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: G_CUR_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 9: G_CUR_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5: -- Declare global variables
6: --
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_ASSIGN_PUB';
8: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: G_CUR_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

6: --
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_ASSIGN_PUB';
8: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: G_CUR_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_ASSIGN_PUB';
8: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: G_CUR_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15:

Line 12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

8: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: G_CUR_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15:
16: --

Line 13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

9: G_CUR_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15:
16: --
17: -- List of document statuses that are set in this

Line 14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15:
16: --
17: -- List of document statuses that are set in this
18: -- module (assignment flow).

Line 50: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT

46: --
47: PROCEDURE print_debuginfo(
48: p_module IN VARCHAR2,
49: p_debug_text IN VARCHAR2,
50: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
51: );
52:
53: /*--------------------------------------------------------------------
54: | NAME:

Line 1501: || 'when calling assignment hook.', FND_LOG.LEVEL_UNEXPECTED);

1497: EXCEPTION
1498: WHEN OTHERS THEN
1499: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
1500: print_debuginfo(l_module_name, 'Fatal: Exception occured '
1501: || 'when calling assignment hook.', FND_LOG.LEVEL_UNEXPECTED);
1502: END IF;
1503:
1504: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
1505: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,

Line 1506: FND_LOG.LEVEL_UNEXPECTED);

1502: END IF;
1503:
1504: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
1505: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
1506: FND_LOG.LEVEL_UNEXPECTED);
1507: END IF;
1508:
1509: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
1510: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,

Line 1511: FND_LOG.LEVEL_UNEXPECTED);

1507: END IF;
1508:
1509: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
1510: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
1511: FND_LOG.LEVEL_UNEXPECTED);
1512: END IF;
1513:
1514: /*
1515: * Propogate exception to caller.

Line 1592: FND_LOG.LEVEL_UNEXPECTED);

1588: WHEN OTHERS THEN
1589: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
1590: print_debuginfo(l_module_name, 'Fatal: Exception when '
1591: || 'attempting to update request status.',
1592: FND_LOG.LEVEL_UNEXPECTED);
1593: END IF;
1594:
1595: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
1596: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,

Line 1597: FND_LOG.LEVEL_UNEXPECTED);

1593: END IF;
1594:
1595: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
1596: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
1597: FND_LOG.LEVEL_UNEXPECTED);
1598: END IF;
1599:
1600: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
1601: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,

Line 1602: FND_LOG.LEVEL_UNEXPECTED);

1598: END IF;
1599:
1600: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
1601: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
1602: FND_LOG.LEVEL_UNEXPECTED);
1603: END IF;
1604:
1605: /*
1606: * Propogate exception to caller.

Line 2006: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);

2002: END IF;
2003:
2004: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
2005: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
2006: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
2007: END IF;
2008:
2009: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
2010: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,

Line 2011: FND_LOG.LEVEL_UNEXPECTED);

2007: END IF;
2008:
2009: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
2010: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
2011: FND_LOG.LEVEL_UNEXPECTED);
2012: END IF;
2013:
2014: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
2015: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,

Line 2016: FND_LOG.LEVEL_UNEXPECTED);

2012: END IF;
2013:
2014: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
2015: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
2016: FND_LOG.LEVEL_UNEXPECTED);
2017: END IF;
2018:
2019: /*
2020: * Propogate exception to caller.

Line 2139: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT

2135: *---------------------------------------------------------------------*/
2136: PROCEDURE print_debuginfo(
2137: p_module IN VARCHAR2,
2138: p_debug_text IN VARCHAR2,
2139: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
2140: )
2141: IS
2142: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
2143: BEGIN

Line 2142: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;

2138: p_debug_text IN VARCHAR2,
2139: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
2140: )
2141: IS
2142: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
2143: BEGIN
2144:
2145: /*
2146: * Set the debug level to the value passed in