DBA Data[Home] [Help]

APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_PRODUCTS_PUB

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

1485: UPDATE OKL_PRODUCTS SET PRODUCT_STATUS_CODE = l_upd_pdtv_rec.product_status_code
1486: WHERE ID = l_UPD_pdtv_rec.id;
1487:
1488: /*
1489: Okl_Products_Pub.update_products(p_api_version => p_api_version,
1490: p_init_msg_list => p_init_msg_list,
1491: x_return_status => l_return_status,
1492: x_msg_count => x_msg_count,
1493: x_msg_data => x_msg_data,

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

4047: RAISE Okl_Api.G_EXCEPTION_ERROR;
4048: END IF;
4049:
4050: /* public api to insert products */
4051: -- Start of wraper code generated automatically by Debug code generator for Okl_Products_Pub.insert_products
4052: IF(L_DEBUG_ENABLED='Y') THEN
4053: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
4054: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
4055: END IF;

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

4054: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
4055: END IF;
4056: IF(IS_DEBUG_PROCEDURE_ON) THEN
4057: BEGIN
4058: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Products_Pub.insert_products ');
4059: END;
4060: END IF;
4061:
4062:

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

4062:
4063:
4064: l_pdtv_rec.PRODUCT_STATUS_CODE := G_PDT_STS_NEW;
4065:
4066: Okl_Products_Pub.insert_products(p_api_version => p_api_version,
4067: p_init_msg_list => p_init_msg_list,
4068: x_return_status => l_return_status,
4069: x_msg_count => x_msg_count,
4070: x_msg_data => x_msg_data,

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

4073:
4074:
4075: IF(IS_DEBUG_PROCEDURE_ON) THEN
4076: BEGIN
4077: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.insert_products ');
4078: END;
4079: END IF;
4080: -- End of wraper code generated automatically by Debug code generator for Okl_Products_Pub.insert_products
4081:

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

4076: BEGIN
4077: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.insert_products ');
4078: END;
4079: END IF;
4080: -- End of wraper code generated automatically by Debug code generator for Okl_Products_Pub.insert_products
4081:
4082: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
4083: RAISE Okl_Api.G_EXCEPTION_ERROR;
4084:

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

4256: /* Scenario 1: only changing description */
4257: IF l_action = '1' THEN
4258:
4259: /* public api to update products */
4260: -- Start of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products
4261: /*
4262: IF(L_DEBUG_ENABLED='Y') THEN
4263: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
4264: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

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

4264: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
4265: END IF;
4266: IF(IS_DEBUG_PROCEDURE_ON) THEN
4267: BEGIN
4268: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
4269: END;
4270: END IF;
4271: */
4272:

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

4274: IF P_pdtv_rec.product_status_code NOT IN ('PENDING APPROVAL','APPROVED') THEN
4275: l_upd_pdtv_rec.product_status_code := 'PASSED';
4276: END IF;
4277:
4278: Okl_Products_Pub.update_products(p_api_version => p_api_version,
4279: p_init_msg_list => p_init_msg_list,
4280: x_return_status => l_return_status,
4281: x_msg_count => x_msg_count,
4282: x_msg_data => x_msg_data,

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

4283: p_pdtv_rec => l_upd_pdtv_rec,
4284: x_pdtv_rec => x_pdtv_rec);
4285: IF(IS_DEBUG_PROCEDURE_ON) THEN
4286: BEGIN
4287: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
4288:
4289: END;
4290: END IF;
4291: -- End of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products

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

4287: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
4288:
4289: END;
4290: END IF;
4291: -- End of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products
4292:
4293: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
4294:
4295: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

4365:
4366:
4367:
4368: /* public api to update formulae */
4369: -- Start of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products
4370: IF(IS_DEBUG_PROCEDURE_ON) THEN
4371: BEGIN
4372: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
4373: END;

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

4368: /* public api to update formulae */
4369: -- Start of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products
4370: IF(IS_DEBUG_PROCEDURE_ON) THEN
4371: BEGIN
4372: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
4373: END;
4374: END IF;
4375:
4376:

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

4405: END IF;
4406:
4407:
4408:
4409: Okl_Products_Pub.update_products(p_api_version => p_api_version,
4410: p_init_msg_list => p_init_msg_list,
4411: x_return_status => l_return_status,
4412: x_msg_count => x_msg_count,
4413: x_msg_data => x_msg_data,

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

4415:
4416: x_pdtv_rec => x_pdtv_rec);
4417: IF(IS_DEBUG_PROCEDURE_ON) THEN
4418: BEGIN
4419: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
4420: END;
4421: END IF;
4422: -- End of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products
4423: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

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

4418: BEGIN
4419: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
4420: END;
4421: END IF;
4422: -- End of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products
4423: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
4424: RAISE Okl_Api.G_EXCEPTION_ERROR;
4425: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
4426: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;