DBA Data[Home] [Help]

APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_PRODUCTS_PUB

Line 1472: Okl_Products_Pub.update_products(p_api_version => p_api_version,

1468: UPDATE OKL_PRODUCTS SET PRODUCT_STATUS_CODE = l_upd_pdtv_rec.product_status_code
1469: WHERE ID = l_UPD_pdtv_rec.id;
1470:
1471: /*
1472: Okl_Products_Pub.update_products(p_api_version => p_api_version,
1473: p_init_msg_list => p_init_msg_list,
1474: x_return_status => l_return_status,
1475: x_msg_count => x_msg_count,
1476: x_msg_data => x_msg_data,

Line 4022: -- Start of wraper code generated automatically by Debug code generator for Okl_Products_Pub.insert_products

4018: RAISE Okl_Api.G_EXCEPTION_ERROR;
4019: END IF;
4020:
4021: /* public api to insert products */
4022: -- Start of wraper code generated automatically by Debug code generator for Okl_Products_Pub.insert_products
4023: IF(L_DEBUG_ENABLED='Y') THEN
4024: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
4025: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
4026: END IF;

Line 4029: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Products_Pub.insert_products ');

4025: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
4026: END IF;
4027: IF(IS_DEBUG_PROCEDURE_ON) THEN
4028: BEGIN
4029: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Products_Pub.insert_products ');
4030: END;
4031: END IF;
4032:
4033:

Line 4037: Okl_Products_Pub.insert_products(p_api_version => p_api_version,

4033:
4034:
4035: l_pdtv_rec.PRODUCT_STATUS_CODE := G_PDT_STS_NEW;
4036:
4037: Okl_Products_Pub.insert_products(p_api_version => p_api_version,
4038: p_init_msg_list => p_init_msg_list,
4039: x_return_status => l_return_status,
4040: x_msg_count => x_msg_count,
4041: x_msg_data => x_msg_data,

Line 4048: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.insert_products ');

4044:
4045:
4046: IF(IS_DEBUG_PROCEDURE_ON) THEN
4047: BEGIN
4048: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.insert_products ');
4049: END;
4050: END IF;
4051: -- End of wraper code generated automatically by Debug code generator for Okl_Products_Pub.insert_products
4052:

Line 4051: -- End of wraper code generated automatically by Debug code generator for Okl_Products_Pub.insert_products

4047: BEGIN
4048: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.insert_products ');
4049: END;
4050: END IF;
4051: -- End of wraper code generated automatically by Debug code generator for Okl_Products_Pub.insert_products
4052:
4053: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
4054: RAISE Okl_Api.G_EXCEPTION_ERROR;
4055:

Line 4231: -- Start of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products

4227: /* Scenario 1: only changing description */
4228: IF l_action = '1' THEN
4229:
4230: /* public api to update products */
4231: -- Start of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products
4232: /*
4233: IF(L_DEBUG_ENABLED='Y') THEN
4234: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
4235: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

Line 4239: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');

4235: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
4236: END IF;
4237: IF(IS_DEBUG_PROCEDURE_ON) THEN
4238: BEGIN
4239: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
4240: END;
4241: END IF;
4242: */
4243:

Line 4249: Okl_Products_Pub.update_products(p_api_version => p_api_version,

4245: IF P_pdtv_rec.product_status_code NOT IN ('PENDING APPROVAL','APPROVED') THEN
4246: l_upd_pdtv_rec.product_status_code := 'PASSED';
4247: END IF;
4248:
4249: Okl_Products_Pub.update_products(p_api_version => p_api_version,
4250: p_init_msg_list => p_init_msg_list,
4251: x_return_status => l_return_status,
4252: x_msg_count => x_msg_count,
4253: x_msg_data => x_msg_data,

Line 4258: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');

4254: p_pdtv_rec => l_upd_pdtv_rec,
4255: x_pdtv_rec => x_pdtv_rec);
4256: IF(IS_DEBUG_PROCEDURE_ON) THEN
4257: BEGIN
4258: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
4259:
4260: END;
4261: END IF;
4262: -- End of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products

Line 4262: -- End of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products

4258: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
4259:
4260: END;
4261: END IF;
4262: -- End of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products
4263:
4264: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
4265:
4266: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 4340: -- Start of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products

4336:
4337:
4338:
4339: /* public api to update formulae */
4340: -- Start of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products
4341: IF(IS_DEBUG_PROCEDURE_ON) THEN
4342: BEGIN
4343: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
4344: END;

Line 4343: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');

4339: /* public api to update formulae */
4340: -- Start of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products
4341: IF(IS_DEBUG_PROCEDURE_ON) THEN
4342: BEGIN
4343: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
4344: END;
4345: END IF;
4346:
4347:

Line 4380: Okl_Products_Pub.update_products(p_api_version => p_api_version,

4376: END IF;
4377:
4378:
4379:
4380: Okl_Products_Pub.update_products(p_api_version => p_api_version,
4381: p_init_msg_list => p_init_msg_list,
4382: x_return_status => l_return_status,
4383: x_msg_count => x_msg_count,
4384: x_msg_data => x_msg_data,

Line 4390: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');

4386:
4387: x_pdtv_rec => x_pdtv_rec);
4388: IF(IS_DEBUG_PROCEDURE_ON) THEN
4389: BEGIN
4390: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
4391: END;
4392: END IF;
4393: -- End of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products
4394: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

Line 4393: -- End of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products

4389: BEGIN
4390: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
4391: END;
4392: END IF;
4393: -- End of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products
4394: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
4395: RAISE Okl_Api.G_EXCEPTION_ERROR;
4396: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
4397: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;