[Home] [Help]
1: PACKAGE BODY OKL_SETUPDQUALITYS_PUB AS
2: /* $Header: OKLPSDQB.pls 120.3 2007/03/04 10:04:44 dcshanmu ship $ */
3: -- Start of wraper code generated automatically by Debug code generator
4: L_MODULE VARCHAR2(40) := 'LEASE.SETUP.PRODUCTS';
5: L_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
6: L_LEVEL_PROCEDURE NUMBER;
7: IS_DEBUG_PROCEDURE_ON BOOLEAN;
8: -- End of wraper code generated automatically by Debug code generator
9: ---------------------------------------------------------------------------
25:
26: -- Start of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.get_rec
27: IF(L_DEBUG_ENABLED='Y') THEN
28: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
29: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
30: END IF;
31: IF(IS_DEBUG_PROCEDURE_ON) THEN
32: BEGIN
33: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.get_rec ');
29: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
30: END IF;
31: IF(IS_DEBUG_PROCEDURE_ON) THEN
32: BEGIN
33: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.get_rec ');
34: END;
35: END IF;
36: okl_setupdqualitys_pvt.get_rec(p_pdqv_rec => l_pdqv_rec,
37: x_return_status => l_return_status,
38: x_no_data_found => l_no_data_found,
39: x_pdqv_rec => x_pdqv_rec);
40: IF(IS_DEBUG_PROCEDURE_ON) THEN
41: BEGIN
42: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.get_rec ');
43: END;
44: END IF;
45: -- End of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.get_rec
46:
86: -- call process api to insert dqualitys
87: -- Start of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.insert_dqualitys
88: IF(L_DEBUG_ENABLED='Y') THEN
89: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
90: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
91: END IF;
92: IF(IS_DEBUG_PROCEDURE_ON) THEN
93: BEGIN
94: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.insert_dqualitys ');
90: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
91: END IF;
92: IF(IS_DEBUG_PROCEDURE_ON) THEN
93: BEGIN
94: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.insert_dqualitys ');
95: END;
96: END IF;
97: okl_setupdqualitys_pvt.insert_dqualitys(p_api_version => p_api_version, p_init_msg_list => p_init_msg_list,
98: x_return_status => l_return_status,
102: p_pdqv_rec => l_pdqv_rec,
103: x_pdqv_rec => x_pdqv_rec);
104: IF(IS_DEBUG_PROCEDURE_ON) THEN
105: BEGIN
106: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.insert_dqualitys ');
107: END;
108: END IF;
109: -- End of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.insert_dqualitys
110:
178: -- call process api to insert dqualitys
179: -- Start of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.insert_dqualitys
180: IF(L_DEBUG_ENABLED='Y') THEN
181: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
182: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
183: END IF;
184: IF(IS_DEBUG_PROCEDURE_ON) THEN
185: BEGIN
186: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.insert_dqualitys ');
182: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
183: END IF;
184: IF(IS_DEBUG_PROCEDURE_ON) THEN
185: BEGIN
186: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.insert_dqualitys ');
187: END;
188: END IF;
189: okl_setupdqualitys_pvt.insert_dqualitys(p_api_version => p_api_version, p_init_msg_list => p_init_msg_list,
190: x_return_status => l_return_status,
194: p_pdqv_tbl => l_pdqv_tbl,
195: x_pdqv_tbl => x_pdqv_tbl);
196: IF(IS_DEBUG_PROCEDURE_ON) THEN
197: BEGIN
198: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.insert_dqualitys ');
199: END;
200: END IF;
201: -- End of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.insert_dqualitys
202:
272: -- call process api to delete dqualitys
273: -- Start of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.delete_dqualitys
274: IF(L_DEBUG_ENABLED='Y') THEN
275: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
276: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
277: END IF;
278: IF(IS_DEBUG_PROCEDURE_ON) THEN
279: BEGIN
280: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.delete_dqualitys ');
276: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
277: END IF;
278: IF(IS_DEBUG_PROCEDURE_ON) THEN
279: BEGIN
280: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.delete_dqualitys ');
281: END;
282: END IF;
283: okl_setupdqualitys_pvt.delete_dqualitys(p_api_version => p_api_version,
284: p_init_msg_list => p_init_msg_list,
288: p_ptlv_rec => l_ptlv_rec,
289: p_pdqv_tbl => l_pdqv_tbl);
290: IF(IS_DEBUG_PROCEDURE_ON) THEN
291: BEGIN
292: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.delete_dqualitys ');
293: END;
294: END IF;
295: -- End of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.delete_dqualitys
296: