DBA Data[Home] [Help]

APPS.OKL_STREAM_MIGRATION_PVT dependencies on OKL_SETUPPRODUCTS_PVT

Line 3204: l_pdtv_rec.product_status_code := Okl_Setupproducts_Pvt.G_PDT_STS_INVALID;

3200: -- UPDATE PRODUCT WITH NEW AES_ID
3201: l_pdtv_rec.id := l_product_id;
3202: l_pdtv_rec.aes_id := l_new_aes_id;
3203: l_pdtv_rec.ptl_id := l_ptl_id;
3204: l_pdtv_rec.product_status_code := Okl_Setupproducts_Pvt.G_PDT_STS_INVALID;
3205: Fnd_File.put_line(Fnd_File.LOG,'Associating the product - ' || l_product_name || ' with the new Accounting Template set - ' || l_aesv_rec.name );
3206: Fnd_File.put_line(Fnd_File.LOG,'Invalidating the product - ' || l_product_name );
3207: Okl_Products_Pub.update_products(
3208: p_api_version => l_api_version,

Line 3233: Okl_Setupproducts_Pvt.validate_product(

3229: -- PRODUCT VALIDATIONS
3230: IF x_return_status = Okl_Api.G_RET_STS_SUCCESS
3231: THEN
3232: Fnd_File.put_line(Fnd_File.LOG,'Validating the product - ' || l_product_name );
3233: Okl_Setupproducts_Pvt.validate_product(
3234: p_api_version => l_api_version,
3235: p_init_msg_list => l_init_msg_list,
3236: x_return_status => x_return_status,
3237: x_msg_count => x_msg_count,

Line 3259: Okl_Setupproducts_Pvt.update_product_status(

3255: END IF;
3256: IF x_pdtv_rec.PRODUCT_STATUS_CODE = 'PASSED'
3257: THEN
3258: Fnd_File.put_line(Fnd_File.LOG,'Approving the product - ' || l_product_name );
3259: Okl_Setupproducts_Pvt.update_product_status(
3260: p_api_version => l_api_version,
3261: p_init_msg_list => l_init_msg_list,
3262: x_return_status => x_return_status,
3263: x_msg_count => x_msg_count,

Line 3265: p_pdt_status => Okl_Setupproducts_Pvt.G_PDT_STS_APPROVED,

3261: p_init_msg_list => l_init_msg_list,
3262: x_return_status => x_return_status,
3263: x_msg_count => x_msg_count,
3264: x_msg_data => x_msg_data,
3265: p_pdt_status => Okl_Setupproducts_Pvt.G_PDT_STS_APPROVED,
3266: p_pdt_id => x_pdtv_rec.id);
3267: -- Check if the creation is successful.
3268: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
3269: THEN

Line 3347: l_pdtv_rec.product_status_code := Okl_Setupproducts_Pvt.G_PDT_STS_INVALID;

3343: -- INVALIDATE PRODUCT
3344: l_pdtv_rec.id := l_product_id;
3345: l_pdtv_rec.aes_id := l_aes_id;
3346: l_pdtv_rec.ptl_id := l_ptl_id;
3347: l_pdtv_rec.product_status_code := Okl_Setupproducts_Pvt.G_PDT_STS_INVALID;
3348: Fnd_File.put_line(Fnd_File.LOG,'Invalidating the product - ' || l_product_name );
3349: Okl_Products_Pub.update_products(
3350: p_api_version => l_api_version,
3351: p_init_msg_list => l_init_msg_list,

Line 3376: Okl_Setupproducts_Pvt.validate_product(

3372: END IF;
3373: END IF;
3374: -- PRODUCT VALIDATIONS
3375: Fnd_File.put_line(Fnd_File.LOG,'Validating the product - ' || l_product_name );
3376: Okl_Setupproducts_Pvt.validate_product(
3377: p_api_version => l_api_version,
3378: p_init_msg_list => l_init_msg_list,
3379: x_return_status => x_return_status,
3380: x_msg_count => x_msg_count,

Line 3403: Okl_Setupproducts_Pvt.update_product_status(

3399: END IF;
3400: IF x_pdtv_rec.PRODUCT_STATUS_CODE = 'PASSED'
3401: THEN
3402: Fnd_File.put_line(Fnd_File.LOG,'Approving the product - ' || l_product_name );
3403: Okl_Setupproducts_Pvt.update_product_status(
3404: p_api_version => l_api_version,
3405: p_init_msg_list => l_init_msg_list,
3406: x_return_status => x_return_status,
3407: x_msg_count => x_msg_count,

Line 3409: p_pdt_status => Okl_Setupproducts_Pvt.G_PDT_STS_APPROVED,

3405: p_init_msg_list => l_init_msg_list,
3406: x_return_status => x_return_status,
3407: x_msg_count => x_msg_count,
3408: x_msg_data => x_msg_data,
3409: p_pdt_status => Okl_Setupproducts_Pvt.G_PDT_STS_APPROVED,
3410: p_pdt_id => x_pdtv_rec.id);
3411: -- Check if the creation is successful.
3412: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
3413: THEN

Line 3436: Okl_Setupproducts_Pvt.update_product_status(

3432: ELSE -- l_gts_id IS NULL THEN
3433: Fnd_File.put_line(Fnd_File.LOG,'Stream Template does not exist for Product ' || l_product_name );
3434: Fnd_File.put_line(Fnd_File.LOG,'Invalidating the product - ' || l_product_name );
3435: -- UPDATE THE STATUS OF THE PRODUCT TO INVALID
3436: Okl_Setupproducts_Pvt.update_product_status(
3437: p_api_version => l_api_version,
3438: p_init_msg_list => l_init_msg_list,
3439: x_return_status => x_return_status,
3440: x_msg_count => x_msg_count,

Line 3442: p_pdt_status => Okl_Setupproducts_Pvt.G_PDT_STS_INVALID,

3438: p_init_msg_list => l_init_msg_list,
3439: x_return_status => x_return_status,
3440: x_msg_count => x_msg_count,
3441: x_msg_data => x_msg_data,
3442: p_pdt_status => Okl_Setupproducts_Pvt.G_PDT_STS_INVALID,
3443: p_pdt_id => l_product_id);
3444: -- Check if the creation is successful.
3445: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
3446: THEN