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.6 2012/01/13 12:42:48 akuppa 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.6 2012/01/13 12:42:48 akuppa 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.6 2012/01/13 12:42:48 akuppa 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 556: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

552: WSM_log_PVT.logMessage (p_module_name => l_module ,
553: p_msg_text => 'Inserted : ' || SQL%ROWCOUNT || ' rows into MMTT',
554: p_stmt_num => l_stmt_num ,
555: p_msg_tokens => l_msg_tokens ,
556: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
557: p_run_log_level => l_log_level
558: );
559: END IF;
560:

Line 799: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

795: || ' rows into MTLT for lot '
796: || l_lot_txn_rec.lot_number,
797: p_stmt_num => l_stmt_num ,
798: p_msg_tokens => l_msg_tokens ,
799: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
800: p_run_log_level => l_log_level
801: );
802: END IF;
803:

Line 1012: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

1008: p_msg_text => 'Inserted : ' || SQL%ROWCOUNT
1009: || ' rows into MSTT(Serial)',
1010: p_stmt_num => l_stmt_num ,
1011: p_msg_tokens => l_msg_tokens ,
1012: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1013: p_run_log_level => l_log_level
1014: );
1015: END IF;
1016: end if;

Line 1231: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

1227: p_msg_text => 'Inserted : ' || SQL%ROWCOUNT
1228: || ' rows into MSTT(Serial)',
1229: p_stmt_num => l_stmt_num ,
1230: p_msg_tokens => l_msg_tokens ,
1231: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1232: p_run_log_level => l_log_level
1233: );
1234: END IF;
1235:

Line 1267: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

1263: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1264: THEN
1265: WSM_log_PVT.handle_others( p_module_name => l_module ,
1266: p_stmt_num => l_stmt_num ,
1267: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1268: p_run_log_level => l_log_level
1269: );
1270: END IF;
1271: