APPS.WSM_SERIAL_SUPPORT_GRP dependencies on WSM_LOG_PVT

Line 52: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

48:
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';

Line 87: WSM_log_PVT.logMessage (p_module_name => l_module ,

83:
84:
85: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
86: l_msg_tokens.delete;
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 ,

Line 122: WSM_log_PVT.logMessage (p_module_name => l_module ,

118: l_stmt_num := 50;
119:
120: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
121: l_msg_tokens.delete;
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 ,

Line 186: WSM_log_PVT.handle_others( p_module_name => l_module ,

182:
183: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );

Line 264: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

260:
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';

Line 269: l_param_tbl WSM_Log_PVT.param_tbl_type;

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;
270: -- Logging variables...
271:
272: BEGIN
273: l_stmt_num := 10;

Line 293: WSM_Log_PVT.logProcParams(p_module_name => 'wsm.plsql.WSM_SERIAL_SUPPORT_GRP.populate_components',

289:
290: l_param_tbl(4).paramName := 'p_wip_entity_id';
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;

Line 318: WSM_log_PVT.logMessage(p_module_name => l_module ,

314: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
315: THEN
316:
317: l_msg_tokens.delete;
318: WSM_log_PVT.logMessage(p_module_name => l_module ,
319: p_msg_name => 'INV_NO_OPEN_PERIOD' ,
320: p_msg_appl_name => 'INV' ,
321: p_msg_tokens => l_msg_tokens ,
322: p_stmt_num => l_stmt_num ,

Line 380: WSM_log_PVT.logMessage (p_module_name => l_module ,

376: l_stmt_num := 50;
377:
378: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
379: l_msg_tokens.delete;
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 ,

Line 398: WSM_log_PVT.logMessage (p_module_name => l_module ,

394: from dual;
395:
396: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
397: l_msg_tokens.delete;
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 ,

Line 552: WSM_log_PVT.logMessage (p_module_name => l_module ,

548: WHERE TRANSACTION_ID = l_mmt_rec.transaction_id;
549:
550: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
551: l_msg_tokens.delete;
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 ,

Line 793: WSM_log_PVT.logMessage (p_module_name => l_module ,

789: where rowid = l_lot_txn_rec.rowid;
790:
791: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
792: l_msg_tokens.delete;
793: WSM_log_PVT.logMessage (p_module_name => l_module ,
794: p_msg_text => 'Inserted : ' || SQL%ROWCOUNT
795: || ' rows into MTLT for lot '
796: || l_lot_txn_rec.lot_number,
797: p_stmt_num => l_stmt_num ,

Line 1007: WSM_log_PVT.logMessage (p_module_name => l_module ,

1003: and msn.last_transaction_id = l_mmt_rec.transaction_id; --l_lot_txn_rec.serial_transaction_id;
1004:
1005: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1006: l_msg_tokens.delete;
1007: WSM_log_PVT.logMessage (p_module_name => l_module ,
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 ,

Line 1226: WSM_log_PVT.logMessage (p_module_name => l_module ,

1222: and msn.last_transaction_id = l_mmt_rec.transaction_id;
1223:
1224: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1225: l_msg_tokens.delete;
1226: WSM_log_PVT.logMessage (p_module_name => l_module ,
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 ,

Line 1265: WSM_log_PVT.handle_others( p_module_name => l_module ,

1261:
1262: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );