eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_PQY_VALUES_PUB

Line 149: l_del_pqvv_tbl OKL_PQY_VALUES_PUB.pqvv_tbl_type;

145: ,x_msg_data OUT NOCOPY VARCHAR2
146: ,p_pdtv_rec IN pdtv_rec_type) IS
147: i PLS_INTEGER :=0;
148: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
149: l_del_pqvv_tbl OKL_PQY_VALUES_PUB.pqvv_tbl_type;
150:
151: CURSOR pqv_csr IS
152: SELECT pqvv.id
153: FROM okl_pdt_pqy_vals_v pqvv

Line 165: -- Start of wraper code generated automatically by Debug code generator for OKL_PQY_VALUES_PUB.delete_pqy_values

161: l_del_pqvv_tbl(i).id := pqv_rec.id;
162: END LOOP;
163: IF l_del_pqvv_tbl.COUNT > 0 THEN
164: /* public api to delete product option values */
165: -- Start of wraper code generated automatically by Debug code generator for OKL_PQY_VALUES_PUB.delete_pqy_values
166: IF(L_DEBUG_ENABLED='Y') THEN
167: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
168: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
169: END IF;

Line 172: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call OKL_PQY_VALUES_PUB.delete_pqy_values ');

168: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
169: END IF;
170: IF(IS_DEBUG_PROCEDURE_ON) THEN
171: BEGIN
172: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call OKL_PQY_VALUES_PUB.delete_pqy_values ');
173: END;
174: END IF;
175: OKL_PQY_VALUES_PUB.delete_pqy_values(p_api_version => p_api_version,
176: p_init_msg_list => p_init_msg_list,

Line 175: OKL_PQY_VALUES_PUB.delete_pqy_values(p_api_version => p_api_version,

171: BEGIN
172: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call OKL_PQY_VALUES_PUB.delete_pqy_values ');
173: END;
174: END IF;
175: OKL_PQY_VALUES_PUB.delete_pqy_values(p_api_version => p_api_version,
176: p_init_msg_list => p_init_msg_list,
177: x_return_status => l_return_status,
178: x_msg_count => x_msg_count,
179: x_msg_data => x_msg_data,

Line 183: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call OKL_PQY_VALUES_PUB.delete_pqy_values ');

179: x_msg_data => x_msg_data,
180: p_pqvv_tbl => l_del_pqvv_tbl);
181: IF(IS_DEBUG_PROCEDURE_ON) THEN
182: BEGIN
183: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call OKL_PQY_VALUES_PUB.delete_pqy_values ');
184: END;
185: END IF;
186:
187: -- End of wraper code generated automatically by Debug code generator for OKL_PQY_VALUES_PUB.delete_pqy_values

Line 187: -- End of wraper code generated automatically by Debug code generator for OKL_PQY_VALUES_PUB.delete_pqy_values

183: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call OKL_PQY_VALUES_PUB.delete_pqy_values ');
184: END;
185: END IF;
186:
187: -- End of wraper code generated automatically by Debug code generator for OKL_PQY_VALUES_PUB.delete_pqy_values
188:
189: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
190: RAISE G_EXCEPTION_HALT_PROCESSING;
191: ELSE

Line 3732: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values

3728: END IF;
3729:
3730: IF l_pqv_count > 0 THEN
3731: IF p_flag = G_UPDATE THEN
3732: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
3733: IF(IS_DEBUG_PROCEDURE_ON) THEN
3734: BEGIN
3735: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
3736: END;

Line 3735: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');

3731: IF p_flag = G_UPDATE THEN
3732: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
3733: IF(IS_DEBUG_PROCEDURE_ON) THEN
3734: BEGIN
3735: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
3736: END;
3737: END IF;
3738: Okl_Pqy_Values_Pub.update_pqy_values(p_api_version => p_api_version,
3739:

Line 3738: Okl_Pqy_Values_Pub.update_pqy_values(p_api_version => p_api_version,

3734: BEGIN
3735: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
3736: END;
3737: END IF;
3738: Okl_Pqy_Values_Pub.update_pqy_values(p_api_version => p_api_version,
3739:
3740: p_init_msg_list => p_init_msg_list,
3741: x_return_status => l_return_status,
3742: x_msg_count => x_msg_count,

Line 3748: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');

3744: p_pqvv_tbl => l_pqvv_tbl,
3745: x_pqvv_tbl => l_out_pqvv_tbl);
3746: IF(IS_DEBUG_PROCEDURE_ON) THEN
3747: BEGIN
3748: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
3749: END;
3750: END IF;
3751: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
3752: ELSE

Line 3751: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values

3747: BEGIN
3748: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
3749: END;
3750: END IF;
3751: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
3752: ELSE
3753: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
3754: IF(IS_DEBUG_PROCEDURE_ON) THEN
3755: BEGIN

Line 3753: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values

3749: END;
3750: END IF;
3751: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
3752: ELSE
3753: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
3754: IF(IS_DEBUG_PROCEDURE_ON) THEN
3755: BEGIN
3756: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
3757: END;

Line 3756: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');

3752: ELSE
3753: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
3754: IF(IS_DEBUG_PROCEDURE_ON) THEN
3755: BEGIN
3756: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
3757: END;
3758: END IF;
3759: Okl_Pqy_Values_Pub.insert_pqy_values(p_api_version => p_api_version,
3760: p_init_msg_list => p_init_msg_list,

Line 3759: Okl_Pqy_Values_Pub.insert_pqy_values(p_api_version => p_api_version,

3755: BEGIN
3756: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
3757: END;
3758: END IF;
3759: Okl_Pqy_Values_Pub.insert_pqy_values(p_api_version => p_api_version,
3760: p_init_msg_list => p_init_msg_list,
3761: x_return_status => l_return_status,
3762: x_msg_count => x_msg_count,
3763: x_msg_data => x_msg_data,

Line 3768: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');

3764: p_pqvv_tbl => l_pqvv_tbl,
3765: x_pqvv_tbl => l_out_pqvv_tbl);
3766: IF(IS_DEBUG_PROCEDURE_ON) THEN
3767: BEGIN
3768: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
3769: END;
3770: END IF;
3771: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
3772: END IF;

Line 3771: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values

3767: BEGIN
3768: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
3769: END;
3770: END IF;
3771: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
3772: END IF;
3773: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
3774: x_return_status := Okl_Api.G_RET_STS_ERROR;
3775: RAISE G_EXCEPTION_HALT_PROCESSING;