DBA Data[Home] [Help]

APPS.WSM_SERIAL_SUPPORT_GRP dependencies on FND_LOG

Line 4: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;

1: PACKAGE BODY WSM_Serial_support_GRP AS
2: /* $Header: WSMGSERB.pls 120.2.12000000.2 2007/02/23 12:32:48 mprathap ship $ */
3:
4: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
5: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
6: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
7: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
8: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;

Line 5: g_log_level_error number := FND_LOG.LEVEL_ERROR ;

1: PACKAGE BODY WSM_Serial_support_GRP AS
2: /* $Header: WSMGSERB.pls 120.2.12000000.2 2007/02/23 12:32:48 mprathap ship $ */
3:
4: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
5: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
6: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
7: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
8: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
9: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;

Line 6: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;

2: /* $Header: WSMGSERB.pls 120.2.12000000.2 2007/02/23 12:32:48 mprathap ship $ */
3:
4: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
5: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
6: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
7: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
8: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
9: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
10:

Line 7: g_log_level_event number := FND_LOG.LEVEL_EVENT ;

3:
4: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
5: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
6: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
7: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
8: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
9: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
10:
11: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;

Line 8: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;

4: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
5: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
6: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
7: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
8: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
9: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
10:
11: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
12: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;

Line 9: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;

5: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
6: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
7: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
8: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
9: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
10:
11: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
12: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
13: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;

Line 53: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

49: l_job_type NUMBER;
50:
51: -- Logging variables.....
52: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
53: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
54:
55: l_stmt_num NUMBER;
56: l_module VARCHAR2(100) := 'wsm.plsql.WSM_Serial_support_GRP.backflush_comp';
57: -- Logging variables....

Line 91: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

87: WSM_log_PVT.logMessage (p_module_name => l_module ,
88: p_msg_text => 'Invoking populate_components',
89: p_stmt_num => l_stmt_num ,
90: p_msg_tokens => l_msg_tokens ,
91: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
92: p_run_log_level => l_log_level
93: );
94: END IF;
95:

Line 126: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

122: WSM_log_PVT.logMessage (p_module_name => l_module ,
123: p_msg_text => 'Invoking wip_movProc_grp.backflushIntoMTI',
124: p_stmt_num => l_stmt_num ,
125: p_msg_tokens => l_msg_tokens ,
126: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
127: p_run_log_level => l_log_level
128: );
129: END IF;
130:

Line 188: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

184: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
185: THEN
186: WSM_log_PVT.handle_others( p_module_name => l_module ,
187: p_stmt_num => l_stmt_num ,
188: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
189: p_run_log_level => l_log_level
190: );
191: END IF;
192:

Line 265: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

261: l_open_past_period BOOLEAN := false;
262:
263: -- Logging variables.....
264: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
265: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
266:
267: l_stmt_num NUMBER;
268: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_GRP.populate_components';
269: l_param_tbl WSM_Log_PVT.param_tbl_type;

Line 295: p_fnd_log_level => l_log_level

291: l_param_tbl(4).paramValue := p_wip_entity_id;
292:
293: WSM_Log_PVT.logProcParams(p_module_name => 'wsm.plsql.WSM_SERIAL_SUPPORT_GRP.populate_components',
294: p_param_tbl => l_param_tbl,
295: p_fnd_log_level => l_log_level
296: );
297: END IF;
298:
299: l_stmt_num := 20;

Line 324: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

320: p_msg_appl_name => 'INV' ,
321: p_msg_tokens => l_msg_tokens ,
322: p_stmt_num => l_stmt_num ,
323: p_fnd_msg_level => G_MSG_LVL_ERROR ,
324: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
325: p_run_log_level => l_log_level
326: );
327: END IF;
328: RAISE FND_API.G_EXC_ERROR;

Line 384: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

380: WSM_log_PVT.logMessage (p_module_name => l_module ,
381: p_msg_text => 'Old Transaction Values : Move Transaction ID : ' || l_move_txn_id || ' Scrap Transaction ID : ' || l_scrap_txn_id,
382: p_stmt_num => l_stmt_num ,
383: p_msg_tokens => l_msg_tokens ,
384: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
385: p_run_log_level => l_log_level
386: );
387: END IF;
388:

Line 402: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

398: WSM_log_PVT.logMessage (p_module_name => l_module ,
399: p_msg_text => 'MMTT Transaction ID : ' || l_temp_id,
400: p_stmt_num => l_stmt_num ,
401: p_msg_tokens => l_msg_tokens ,
402: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
403: p_run_log_level => l_log_level
404: );
405: END IF;
406:

Line 550: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

546: WSM_log_PVT.logMessage (p_module_name => l_module ,
547: p_msg_text => 'Inserted : ' || SQL%ROWCOUNT || ' rows into MMTT',
548: p_stmt_num => l_stmt_num ,
549: p_msg_tokens => l_msg_tokens ,
550: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
551: p_run_log_level => l_log_level
552: );
553: END IF;
554:

Line 793: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

789: || ' rows into MTLT for lot '
790: || l_lot_txn_rec.lot_number,
791: p_stmt_num => l_stmt_num ,
792: p_msg_tokens => l_msg_tokens ,
793: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
794: p_run_log_level => l_log_level
795: );
796: END IF;
797:

Line 1006: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

1002: p_msg_text => 'Inserted : ' || SQL%ROWCOUNT
1003: || ' rows into MSTT(Serial)',
1004: p_stmt_num => l_stmt_num ,
1005: p_msg_tokens => l_msg_tokens ,
1006: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1007: p_run_log_level => l_log_level
1008: );
1009: END IF;
1010: end if;

Line 1225: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

1221: p_msg_text => 'Inserted : ' || SQL%ROWCOUNT
1222: || ' rows into MSTT(Serial)',
1223: p_stmt_num => l_stmt_num ,
1224: p_msg_tokens => l_msg_tokens ,
1225: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1226: p_run_log_level => l_log_level
1227: );
1228: END IF;
1229:

Line 1261: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

1257: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1258: THEN
1259: WSM_log_PVT.handle_others( p_module_name => l_module ,
1260: p_stmt_num => l_stmt_num ,
1261: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1262: p_run_log_level => l_log_level
1263: );
1264: END IF;
1265: