DBA Data[Home] [Help]

APPS.WSMPOPRN dependencies on FND_LOG

Line 25: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;

21: +============================================================================*/
22:
23: g_update_flag boolean:=TRUE;
24: --mes
25: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
26: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
27: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
28: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
29: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;

Line 26: g_log_level_error number := FND_LOG.LEVEL_ERROR ;

22:
23: g_update_flag boolean:=TRUE;
24: --mes
25: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
26: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
27: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
28: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
29: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
30: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;

Line 27: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;

23: g_update_flag boolean:=TRUE;
24: --mes
25: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
26: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
27: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
28: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
29: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
30: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
31:

Line 28: g_log_level_event number := FND_LOG.LEVEL_EVENT ;

24: --mes
25: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
26: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
27: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
28: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
29: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
30: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
31:
32: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;

Line 29: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;

25: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
26: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
27: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
28: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
29: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
30: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
31:
32: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
33: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;

Line 30: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;

26: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
27: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
28: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
29: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
30: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
31:
32: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
33: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
34: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;

Line 147: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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);
151: l_msg_count number;

Line 1621: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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;
1625: l_return_code NUMBER;

Line 1678: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,

1674: ';l_to_move_flag '||
1675: l_to_move_flag,
1676: p_stmt_num => l_stmt_num,
1677: p_msg_tokens => l_msg_tokens,
1678: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
1679: p_run_log_level => l_log_level
1680: );
1681: END IF;
1682: --***VJ End Changes***--

Line 2224: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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);
2228: l_msg_count number;

Line 3534: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

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 ,
3534: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
3535: p_run_log_level => l_log_level
3536: );
3537: END IF;
3538: END IF;

Line 3692: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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;
3696: x_return_code NUMBER;

Line 3701: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN

3697: x_error_msg VARCHAR2(4000);
3698:
3699: BEGIN
3700: x_return_status := G_RET_SUCCESS;
3701: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
3702:
3703: l_param_tbl.delete;
3704: l_param_tbl(1).paramName := 'p_wip_entity_id';
3705: l_param_tbl(1).paramValue := p_wip_entity_id;

Line 3717: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE

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;
3720:
3721: INSERT INTO WSM_OP_SECONDARY_QUANTITIES

Line 3852: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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: );
3855: END IF;
3856: