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 3535: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

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

Line 3693: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 3702: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN

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

Line 3718: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE

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

Line 3853: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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