39:
40: -- Run the MAIN Procedure
41:
42:
43: -- Start of wraper code generated automatically by Debug code generator for OKL_PERD_STATUS_PVT.SEARCH_PERIOD_STATUS
44: IF(L_DEBUG_ENABLED='Y') THEN
45: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
46: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
47: END IF;
46: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
47: END IF;
48: IF(IS_DEBUG_PROCEDURE_ON) THEN
49: BEGIN
50: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPPSMB.pls call OKL_PERD_STATUS_PVT.SEARCH_PERIOD_STATUS ');
51: END;
52: END IF;
53: OKL_PERD_STATUS_PVT.SEARCH_PERIOD_STATUS(p_api_version => l_api_version,
54: p_init_msg_list => p_init_msg_list,
49: BEGIN
50: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPPSMB.pls call OKL_PERD_STATUS_PVT.SEARCH_PERIOD_STATUS ');
51: END;
52: END IF;
53: OKL_PERD_STATUS_PVT.SEARCH_PERIOD_STATUS(p_api_version => l_api_version,
54: p_init_msg_list => p_init_msg_list,
55: x_return_status => x_return_status,
56: x_msg_count => x_msg_count,
57: x_msg_data => x_msg_data,
58: p_period_rec => p_period_rec,
59: x_period_tbl => x_period_tbl);
60: IF(IS_DEBUG_PROCEDURE_ON) THEN
61: BEGIN
62: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPPSMB.pls call OKL_PERD_STATUS_PVT.SEARCH_PERIOD_STATUS ');
63: END;
64: END IF;
65: -- End of wraper code generated automatically by Debug code generator for OKL_PERD_STATUS_PVT.SEARCH_PERIOD_STATUS
66:
61: BEGIN
62: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPPSMB.pls call OKL_PERD_STATUS_PVT.SEARCH_PERIOD_STATUS ');
63: END;
64: END IF;
65: -- End of wraper code generated automatically by Debug code generator for OKL_PERD_STATUS_PVT.SEARCH_PERIOD_STATUS
66:
67:
68:
69: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
139:
140:
141: -- Run the MAIN Procedure
142:
143: -- Start of wraper code generated automatically by Debug code generator for OKL_PERD_STATUS_PVT.UPDATE_PERIOD_STATUS
144: IF(L_DEBUG_ENABLED='Y') THEN
145: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
146: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
147: END IF;
146: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
147: END IF;
148: IF(IS_DEBUG_PROCEDURE_ON) THEN
149: BEGIN
150: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPPSMB.pls call OKL_PERD_STATUS_PVT.UPDATE_PERIOD_STATUS ');
151: END;
152: END IF;
153: OKL_PERD_STATUS_PVT.UPDATE_PERIOD_STATUS(p_api_version => l_api_version,
154: p_init_msg_list => p_init_msg_list,
149: BEGIN
150: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPPSMB.pls call OKL_PERD_STATUS_PVT.UPDATE_PERIOD_STATUS ');
151: END;
152: END IF;
153: OKL_PERD_STATUS_PVT.UPDATE_PERIOD_STATUS(p_api_version => l_api_version,
154: p_init_msg_list => p_init_msg_list,
155: x_return_status => x_return_status,
156: x_msg_count => x_msg_count,
157: x_msg_data => x_msg_data,
157: x_msg_data => x_msg_data,
158: p_period_tbl => p_period_tbl);
159: IF(IS_DEBUG_PROCEDURE_ON) THEN
160: BEGIN
161: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPPSMB.pls call OKL_PERD_STATUS_PVT.UPDATE_PERIOD_STATUS ');
162: END;
163: END IF;
164: -- End of wraper code generated automatically by Debug code generator for OKL_PERD_STATUS_PVT.UPDATE_PERIOD_STATUS
165:
160: BEGIN
161: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPPSMB.pls call OKL_PERD_STATUS_PVT.UPDATE_PERIOD_STATUS ');
162: END;
163: END IF;
164: -- End of wraper code generated automatically by Debug code generator for OKL_PERD_STATUS_PVT.UPDATE_PERIOD_STATUS
165:
166:
167: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;