[Home] [Help]
1: package body WSM_WLT_VALIDATE_PVT as
2: /* $Header: WSMVVLDB.pls 120.28 2006/09/19 07:28:21 nlal noship $ */
3:
4: -- Package name
5: g_pkg_name VARCHAR2(20) := 'WSM_WLT_VALIDATE_PVT';
1: package body WSM_WLT_VALIDATE_PVT as
2: /* $Header: WSMVVLDB.pls 120.28 2006/09/19 07:28:21 nlal noship $ */
3:
4: -- Package name
5: g_pkg_name VARCHAR2(20) := 'WSM_WLT_VALIDATE_PVT';
6:
7: --logging variables
8: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
9: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
48: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
49: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
50:
51: l_stmt_num NUMBER;
52: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.routing_seq';
53: l_param_tbl WSM_Log_PVT.param_tbl_type;
54: -- Logging variables...
55:
56:
272: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
273: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
274:
275: l_stmt_num NUMBER;
276: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.bom_seq';
277: l_param_tbl WSM_Log_PVT.param_tbl_type;
278: -- Logging variables...
279:
280: BEGIN
578: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
579: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
580:
581: l_stmt_num NUMBER;
582: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.wip_entity';
583: l_param_tbl WSM_Log_PVT.param_tbl_type;
584:
585: BEGIN
586:
749:
750: -- logging variables
751: l_msg_tokens WSM_log_PVT.token_rec_tbl;
752: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
753: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.validate_txn_header';
754: l_stmt_num NUMBER := 0;
755: BEGIN
756:
757: l_stmt_num := 10;
1109: -- local variable for debug purpose
1110: l_stmt_num NUMBER := 0;
1111: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1112: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1113: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.validate_sj_txn_date';
1114: l_param_tbl WSM_Log_PVT.param_tbl_type;
1115:
1116: BEGIN
1117:
1410: -- local variable for debug purpose
1411: l_stmt_num NUMBER := 0;
1412: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1413: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1414: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_st_job_details';
1415: l_param_tbl WSM_Log_PVT.param_tbl_type;
1416:
1417: BEGIN
1418: SAVEPOINT start_def_start_job;
1887: -- local variable for logging purpose
1888: l_stmt_num NUMBER := 0;
1889: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1890: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1891: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.DERIVE_VAL_ST_JOB_DETAILS';
1892:
1893: -- Loop Variable
1894: l_counter NUMBER;
1895:
2259: -- local variable for logging purpose
2260: l_stmt_num NUMBER := 0;
2261: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2262: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2263: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.DERIVE_VAL_RES_JOB_DETAILS';
2264:
2265: -- G_MISS_NUM and G_MISS_CHAR (now use G_NULL_CHAR and equivalents..
2266: l_null_num NUMBER := FND_API.G_NULL_NUM;
2267: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
3701: l_return_status varchar2(1);
3702: l_msg_count number;
3703: l_msg_data varchar2(2000);
3704: --logging variables--
3705: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_res_job_details';
3706: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3707: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3708: l_stmt_num NUMBER := 0;
3709:
4016:
4017: l_return_status varchar2(1);
4018: l_msg_count number;
4019: l_msg_data varchar2(2000);
4020: l_module_name VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_res_job_details';
4021: l_null_char varchar2(10) := FND_API.G_NULL_CHAR;
4022:
4023: l_counter number;
4024: l_job_name_tbl t_wip_entity_name_tbl;
4035: -- Variable indicating the index of the starting job is also a resulting job.. --
4036: l_start_as_result NUMBER := -1;
4037:
4038: --logging variables --
4039: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_res_job_details';
4040: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
4041: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4042: l_stmt_num NUMBER := 0;
4043:
5003: l_err_msg VARCHAR2(2000);
5004: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
5005:
5006: -- logging variables
5007: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_res_job_details';
5008: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
5009: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5010: l_stmt_num NUMBER := 0;
5011:
5758: -- So this has to be handled as a function error and not as an unexpected error...
5759: PRAGMA EXCEPTION_INIT(e_invalid_revision,-20001);
5760:
5761: -- logging variables
5762: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_routing_info';
5763: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
5764: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5765: l_stmt_num NUMBER := 0;
5766: l_param_tbl WSM_Log_PVT.param_tbl_type;
6136: -- So this has to be handled as a function error and not as an unexpected error...
6137: PRAGMA EXCEPTION_INIT(e_invalid_revision,-20001);
6138:
6139: -- logging variables
6140: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_bom_info';
6141: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
6142: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6143: l_stmt_num NUMBER := 0;
6144: l_param_tbl WSM_Log_PVT.param_tbl_type;
6464: l_temp_boolean boolean := true;
6465: l_rtg_item_id NUMBER;
6466:
6467: --- logging variables
6468: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_compl_subinv';
6469: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
6470: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6471: l_stmt_num NUMBER := 0;
6472: l_param_tbl WSM_Log_PVT.param_tbl_type;
6798: -- logging variables
6799: l_stmt_num number:=0;
6800: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
6801: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6802: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_starting_op';
6803:
6804: begin
6805: x_return_status := FND_API.G_RET_STS_SUCCESS;
6806: -- currently not supported for option 'a' : assumption it is not supported
7208: -- logging variables
7209: l_stmt_num number:=0;
7210: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
7211: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7212: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_primary_item';
7213:
7214: begin
7215: x_return_status := FND_API.G_RET_STS_SUCCESS;
7216:
7378: -- local variable for logging purpose
7379: l_stmt_num NUMBER := 0;
7380: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
7381: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7382: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.insert_txn_data';
7383:
7384: -- Loop Variable --
7385: l_counter NUMBER := 0;
7386:
7849: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
7850: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7851:
7852: l_stmt_num NUMBER;
7853: l_module VARCHAR2(100) :='wsm.plsql.WSM_WLT_VALIDATE_PVT.validate_network';
7854: BEGIN
7855: x_return_status := G_RET_SUCCESS;
7856: l_stmt_num := 10;
7857: l_err_code := 0;
8097: p_count => x_msg_count ,
8098: p_data => x_msg_data
8099: );
8100: END;
8101: end WSM_WLT_VALIDATE_PVT;