DBA Data[Home] [Help]

APPS.WSMPOPRN dependencies on WSM_LOG_PVT

Line 146: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

142: l_job_copy_flag NUMBER;
143: l_wsor_max_res_seq_num NUMBER := 0;
144:
145: -- Logging variables.....
146: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
147: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
148: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPOPRN.add_operation';
149: l_param_tbl WSM_Log_PVT.param_tbl_type;
150: l_return_status VARCHAR2(1);

Line 149: l_param_tbl WSM_Log_PVT.param_tbl_type;

145: -- Logging variables.....
146: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
147: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
148: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPOPRN.add_operation';
149: l_param_tbl WSM_Log_PVT.param_tbl_type;
150: l_return_status VARCHAR2(1);
151: l_msg_count number;
152: l_msg_data varchar2(4000);
153:

Line 1620: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

1616: l_to_move_flag NUMBER;
1617: l_stat_num NUMBER;
1618: l_row_count NUMBER;
1619: -- Logging variables.....
1620: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1621: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1622: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPOPRN.get_intra_operation_value';
1623: l_param_tbl WSM_Log_PVT.param_tbl_type;
1624: l_error_count NUMBER;

Line 1623: l_param_tbl WSM_Log_PVT.param_tbl_type;

1619: -- Logging variables.....
1620: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1621: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1622: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPOPRN.get_intra_operation_value';
1623: l_param_tbl WSM_Log_PVT.param_tbl_type;
1624: l_error_count NUMBER;
1625: l_return_code NUMBER;
1626: l_error_msg VARCHAR2(4000);
1627: l_stmt_num NUMBER := 0;

Line 1667: WSM_log_PVT.logMessage (

1663: END IF;
1664:
1665: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1666: l_msg_tokens.delete;
1667: WSM_log_PVT.logMessage (
1668: p_module_name => l_module,
1669: p_msg_text => 'After SELECT from BOM_STANDARD_OPERATIONS '||
1670: ';l_queue_flag '||
1671: l_queue_flag||

Line 2223: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

2219: e_proc_error EXCEPTION;
2220: l_phantom_exists NUMBER;
2221:
2222: -- Logging variables.....
2223: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2224: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2225: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPOPRN.copy_plan_to_execution';
2226: l_param_tbl WSM_Log_PVT.param_tbl_type;
2227: l_return_status VARCHAR2(1);

Line 2226: l_param_tbl WSM_Log_PVT.param_tbl_type;

2222: -- Logging variables.....
2223: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2224: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2225: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPOPRN.copy_plan_to_execution';
2226: l_param_tbl WSM_Log_PVT.param_tbl_type;
2227: l_return_status VARCHAR2(1);
2228: l_msg_count number;
2229: l_msg_data varchar2(4000);
2230: BEGIN

Line 3529: WSM_log_PVT.logMessage (

3525:
3526: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
3527: IF (l_return_status = g_ret_success) THEN
3528: l_msg_tokens.delete;
3529: WSM_log_PVT.logMessage (
3530: p_module_name => l_module ,
3531: p_msg_text => 'WSMPOPRN.copy_to_op_mes_info returned successfully',
3532: p_stmt_num => l_stmt_num ,
3533: p_msg_tokens => l_msg_tokens ,

Line 3691: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

3687: l_stmt_num NUMBER;
3688: l_serialization_started NUMBER;
3689:
3690: -- Logging variables.....
3691: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3692: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3693: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPLBMI.getJobOpPageProperties';
3694: l_param_tbl WSM_Log_PVT.param_tbl_type;
3695: x_error_count NUMBER;

Line 3694: l_param_tbl WSM_Log_PVT.param_tbl_type;

3690: -- Logging variables.....
3691: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3692: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3693: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPLBMI.getJobOpPageProperties';
3694: l_param_tbl WSM_Log_PVT.param_tbl_type;
3695: x_error_count NUMBER;
3696: x_return_code NUMBER;
3697: x_error_msg VARCHAR2(4000);
3698:

Line 3715: WSM_Log_PVT.logProcParams(p_module_name => l_module ,

3711: l_param_tbl(5).paramValue := p_user;
3712: l_param_tbl(6).paramName := 'p_login';
3713: l_param_tbl(6).paramValue := p_login;
3714:
3715: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
3716: p_param_tbl => l_param_tbl,
3717: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE
3718: );
3719: END IF;

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

3846:
3847: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3848: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3849: THEN
3850: WSM_log_PVT.handle_others( p_module_name => l_module ,
3851: p_stmt_num => l_stmt_num ,
3852: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3853: p_run_log_level => l_log_level
3854: );