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 546: WSM_log_PVT.logMessage (p_module_name => l_module ,

542: WHERE TRANSACTION_ID = l_mmt_rec.transaction_id;
543:
544: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
545: l_msg_tokens.delete;
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 ,

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

783: where rowid = l_lot_txn_rec.rowid;
784:
785: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
786: l_msg_tokens.delete;
787: WSM_log_PVT.logMessage (p_module_name => l_module ,
788: p_msg_text => 'Inserted : ' || SQL%ROWCOUNT
789: || ' rows into MTLT for lot '
790: || l_lot_txn_rec.lot_number,
791: p_stmt_num => l_stmt_num ,

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

997: and msn.last_transaction_id = l_mmt_rec.transaction_id; --l_lot_txn_rec.serial_transaction_id;
998:
999: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1000: l_msg_tokens.delete;
1001: WSM_log_PVT.logMessage (p_module_name => l_module ,
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 ,

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

1216: and msn.last_transaction_id = l_mmt_rec.transaction_id;
1217:
1218: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1219: l_msg_tokens.delete;
1220: WSM_log_PVT.logMessage (p_module_name => l_module ,
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 ,

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

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