APPS.WSM_MES_UTILITIES_PVT dependencies on WSM_LOG_PVT

Line 50: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

46: l_move_in_option number := 0;
47: l_move_next_option number := 0;
48:
49: -- Logging variables.....
50: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
51: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
52: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.move_txn_allowed';
53: l_param_tbl WSM_Log_PVT.param_tbl_type;
54: l_error_count NUMBER;

Line 53: l_param_tbl WSM_Log_PVT.param_tbl_type;

49: -- Logging variables.....
50: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
51: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
52: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.move_txn_allowed';
53: l_param_tbl WSM_Log_PVT.param_tbl_type;
54: l_error_count NUMBER;
55: l_return_code NUMBER;
56: l_error_msg VARCHAR2(4000);
57:

Line 76: WSM_Log_PVT.logProcParams(

72: l_param_tbl(6).paramValue := p_intraop_step;
73: l_param_tbl(7).paramName := 'p_status_type';
74: l_param_tbl(7).paramValue := p_status_type;
75:
76: WSM_Log_PVT.logProcParams(
77: p_module_name => l_module,
78: p_param_tbl => l_param_tbl,
79: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE
80: );

Line 237: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

233: l_max_move_txn_date date; -- bugfix 5471833
234: l_max_wlt_txn_date date; -- bugfix 5471833
235:
236: -- Logging variables.....
237: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
238: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
239: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.wsm_transaction_allowed';
240: l_param_tbl WSM_Log_PVT.param_tbl_type;
241: l_error_count NUMBER;

Line 240: l_param_tbl WSM_Log_PVT.param_tbl_type;

236: -- Logging variables.....
237: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
238: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
239: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.wsm_transaction_allowed';
240: l_param_tbl WSM_Log_PVT.param_tbl_type;
241: l_error_count NUMBER;
242: l_return_code NUMBER;
243: l_error_msg VARCHAR2(4000);
244:

Line 265: WSM_Log_PVT.logProcParams(

261: l_param_tbl(7).paramValue := p_intraop_step;
262: l_param_tbl(8).paramName := 'p_status_type';
263: l_param_tbl(8).paramValue := p_status_type;
264:
265: WSM_Log_PVT.logProcParams(
266: p_module_name => l_module,
267: p_param_tbl => l_param_tbl,
268: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE
269: );

Line 646: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

642: l_quantity number;
643: l_job_name varchar2(100);
644:
645: -- Logging variables.....
646: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
647: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
648: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.wsm_job_changed';
649: l_param_tbl WSM_Log_PVT.param_tbl_type;
650: l_error_count NUMBER;

Line 649: l_param_tbl WSM_Log_PVT.param_tbl_type;

645: -- Logging variables.....
646: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
647: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
648: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.wsm_job_changed';
649: l_param_tbl WSM_Log_PVT.param_tbl_type;
650: l_error_count NUMBER;
651: l_return_code NUMBER;
652: l_error_msg VARCHAR2(4000);
653:

Line 670: WSM_Log_PVT.logProcParams(

666: l_param_tbl(5).paramValue := p_quantity;
667: l_param_tbl(6).paramName := 'p_job_name';
668: l_param_tbl(6).paramValue := p_job_name;
669:
670: WSM_Log_PVT.logProcParams(
671: p_module_name => l_module,
672: p_param_tbl => l_param_tbl,
673: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE
674: );

Line 873: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

869: l_job_op_seq_num number;
870: l_org_id number;
871:
872: -- Logging variables.....
873: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
874: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
875: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.check_po_req_exists';
876: l_param_tbl WSM_Log_PVT.param_tbl_type;
877:

Line 876: l_param_tbl WSM_Log_PVT.param_tbl_type;

872: -- Logging variables.....
873: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
874: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
875: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.check_po_req_exists';
876: l_param_tbl WSM_Log_PVT.param_tbl_type;
877:
878: begin
879: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
880: l_param_tbl.delete;

Line 886: WSM_Log_PVT.logProcParams(

882: l_param_tbl(1).paramValue := p_wip_entity_id;
883: l_param_tbl(2).paramName := 'p_txn_type';
884: l_param_tbl(2).paramValue := p_txn_type;
885:
886: WSM_Log_PVT.logProcParams(
887: p_module_name => l_module,
888: p_param_tbl => l_param_tbl,
889: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE
890: );

Line 943: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

939: p_resource_id in number) return number IS
940:
941: l_share_from_dept NUMBER;
942: -- Logging variables.....
943: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
944: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
945: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.get_share_from_dept';
946: l_param_tbl WSM_Log_PVT.param_tbl_type;
947: l_error_count NUMBER;

Line 946: l_param_tbl WSM_Log_PVT.param_tbl_type;

942: -- Logging variables.....
943: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
944: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
945: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.get_share_from_dept';
946: l_param_tbl WSM_Log_PVT.param_tbl_type;
947: l_error_count NUMBER;
948: l_return_code NUMBER;
949: l_error_msg VARCHAR2(4000);
950:

Line 959: WSM_Log_PVT.logProcParams(

955: l_param_tbl(1).paramValue := p_department_id;
956: l_param_tbl(1).paramName := 'p_resource_id';
957: l_param_tbl(1).paramValue := p_resource_id;
958:
959: WSM_Log_PVT.logProcParams(
960: p_module_name => l_module,
961: p_param_tbl => l_param_tbl,
962: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE
963: );