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 3703: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values

3699: END IF;
3700:
3701: IF l_pqv_count > 0 THEN
3702: IF p_flag = G_UPDATE THEN
3703: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
3704: IF(IS_DEBUG_PROCEDURE_ON) THEN
3705: BEGIN
3706: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
3707: END;

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

3702: IF p_flag = G_UPDATE THEN
3703: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
3704: IF(IS_DEBUG_PROCEDURE_ON) THEN
3705: BEGIN
3706: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
3707: END;
3708: END IF;
3709: Okl_Pqy_Values_Pub.update_pqy_values(p_api_version => p_api_version,
3710:

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

3705: BEGIN
3706: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
3707: END;
3708: END IF;
3709: Okl_Pqy_Values_Pub.update_pqy_values(p_api_version => p_api_version,
3710:
3711: p_init_msg_list => p_init_msg_list,
3712: x_return_status => l_return_status,
3713: x_msg_count => x_msg_count,

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

3715: p_pqvv_tbl => l_pqvv_tbl,
3716: x_pqvv_tbl => l_out_pqvv_tbl);
3717: IF(IS_DEBUG_PROCEDURE_ON) THEN
3718: BEGIN
3719: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
3720: END;
3721: END IF;
3722: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
3723: ELSE

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

3718: BEGIN
3719: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
3720: END;
3721: END IF;
3722: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
3723: ELSE
3724: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
3725: IF(IS_DEBUG_PROCEDURE_ON) THEN
3726: BEGIN

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

3720: END;
3721: END IF;
3722: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
3723: ELSE
3724: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
3725: IF(IS_DEBUG_PROCEDURE_ON) THEN
3726: BEGIN
3727: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
3728: END;

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

3723: ELSE
3724: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
3725: IF(IS_DEBUG_PROCEDURE_ON) THEN
3726: BEGIN
3727: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
3728: END;
3729: END IF;
3730: Okl_Pqy_Values_Pub.insert_pqy_values(p_api_version => p_api_version,
3731: p_init_msg_list => p_init_msg_list,

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

3726: BEGIN
3727: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
3728: END;
3729: END IF;
3730: Okl_Pqy_Values_Pub.insert_pqy_values(p_api_version => p_api_version,
3731: p_init_msg_list => p_init_msg_list,
3732: x_return_status => l_return_status,
3733: x_msg_count => x_msg_count,
3734: x_msg_data => x_msg_data,

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

3735: p_pqvv_tbl => l_pqvv_tbl,
3736: x_pqvv_tbl => l_out_pqvv_tbl);
3737: IF(IS_DEBUG_PROCEDURE_ON) THEN
3738: BEGIN
3739: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
3740: END;
3741: END IF;
3742: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
3743: END IF;

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

3738: BEGIN
3739: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
3740: END;
3741: END IF;
3742: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
3743: END IF;
3744: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
3745: x_return_status := Okl_Api.G_RET_STS_ERROR;
3746: RAISE G_EXCEPTION_HALT_PROCESSING;