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 3530: WSM_log_PVT.logMessage (

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

Line 3692: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

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

Line 3695: l_param_tbl WSM_Log_PVT.param_tbl_type;

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

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

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

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

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