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_DEBUG_PUB

Line 5: L_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

1: PACKAGE BODY Okl_Setupproducts_Pvt AS
2: /* $Header: OKLRSPDB.pls 120.28.12010000.5 2008/10/03 21:30:25 apaul ship $ */
3: -- Start of wraper code generated automatically by Debug code generator
4: L_MODULE VARCHAR2(40) := 'LEASE.SETUP.PRODUCTS';
5: L_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
6: L_LEVEL_PROCEDURE NUMBER;
7: IS_DEBUG_PROCEDURE_ON BOOLEAN;
8: -- End of wraper code generated automatically by Debug code generator
9: G_IN_USE CONSTANT VARCHAR2(100) := 'OKL_IN_USE';

Line 168: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

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;
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 ');

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 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 2436: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

2432: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
2433: IF(L_DEBUG_ENABLED='Y') THEN
2434:
2435: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2436: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2437: END IF;
2438: IF(IS_DEBUG_PROCEDURE_ON) THEN
2439: BEGIN
2440: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

Line 2440: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

2436: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2437: END IF;
2438: IF(IS_DEBUG_PROCEDURE_ON) THEN
2439: BEGIN
2440: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2441: END;
2442: END IF;
2443: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2444: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

Line 2449: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

2445: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2446: ,p_token1_value => l_token_1);
2447: IF(IS_DEBUG_PROCEDURE_ON) THEN
2448: BEGIN
2449: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2450: END;
2451: END IF;
2452: -- End of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
2453: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 2466: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.set_message ');

2462: IF (l_row_notfound) THEN
2463: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.set_message
2464: IF(IS_DEBUG_PROCEDURE_ON) THEN
2465: BEGIN
2466: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.set_message ');
2467: END;
2468: END IF;
2469: Okl_Api.set_message(Okl_Pdt_Pvt.G_APP_NAME, Okl_Pdt_Pvt.G_INVALID_VALUE,Okl_Pdt_Pvt.G_COL_NAME_TOKEN,l_token_1);
2470: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2473: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.set_message ');

2469: Okl_Api.set_message(Okl_Pdt_Pvt.G_APP_NAME, Okl_Pdt_Pvt.G_INVALID_VALUE,Okl_Pdt_Pvt.G_COL_NAME_TOKEN,l_token_1);
2470: IF(IS_DEBUG_PROCEDURE_ON) THEN
2471:
2472: BEGIN
2473: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.set_message ');
2474: END;
2475: END IF;
2476: -- End of wraper code generated automatically by Debug code generator for Okl_Api.set_message
2477: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 2540: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

2536: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
2537:
2538: IF(L_DEBUG_ENABLED='Y') THEN
2539: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2540: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2541: END IF;
2542: IF(IS_DEBUG_PROCEDURE_ON) THEN
2543: BEGIN
2544: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

Line 2544: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

2540: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2541: END IF;
2542: IF(IS_DEBUG_PROCEDURE_ON) THEN
2543: BEGIN
2544: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2545: END;
2546: END IF;
2547: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2548: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

Line 2553: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

2549: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2550: ,p_token1_value => l_token_1);
2551: IF(IS_DEBUG_PROCEDURE_ON) THEN
2552: BEGIN
2553: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2554: END;
2555: END IF;
2556: -- End of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
2557: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 2570: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.set_message ');

2566: IF (l_row_notfound) THEN
2567: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.set_message
2568: IF(IS_DEBUG_PROCEDURE_ON) THEN
2569: BEGIN
2570: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.set_message ');
2571:
2572: END;
2573: END IF;
2574: Okl_Api.set_message(Okl_Pdt_Pvt.G_APP_NAME, Okl_Pdt_Pvt.G_INVALID_VALUE,Okl_Pdt_Pvt.G_COL_NAME_TOKEN,l_token_1);

Line 2577: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.set_message ');

2573: END IF;
2574: Okl_Api.set_message(Okl_Pdt_Pvt.G_APP_NAME, Okl_Pdt_Pvt.G_INVALID_VALUE,Okl_Pdt_Pvt.G_COL_NAME_TOKEN,l_token_1);
2575: IF(IS_DEBUG_PROCEDURE_ON) THEN
2576: BEGIN
2577: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.set_message ');
2578: END;
2579: END IF;
2580: -- End of wraper code generated automatically by Debug code generator for Okl_Api.set_message
2581: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 2637: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

2633: (p_pdtv_rec.from_date = Okl_Api.G_MISS_DATE) THEN
2634: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
2635: IF(L_DEBUG_ENABLED='Y') THEN
2636: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2637: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2638: END IF;
2639: IF(IS_DEBUG_PROCEDURE_ON) THEN
2640:
2641: BEGIN

Line 2642: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

2638: END IF;
2639: IF(IS_DEBUG_PROCEDURE_ON) THEN
2640:
2641: BEGIN
2642: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2643: END;
2644: END IF;
2645: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2646: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

Line 2651: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

2647: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2648: ,p_token1_value => l_token_1);
2649: IF(IS_DEBUG_PROCEDURE_ON) THEN
2650: BEGIN
2651: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2652: END;
2653: END IF;
2654: -- End of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
2655: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 2711: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

2707: (p_pdtv_rec.name = Okl_Api.G_MISS_CHAR) THEN
2708: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
2709: IF(L_DEBUG_ENABLED='Y') THEN
2710: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2711: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2712: END IF;
2713: IF(IS_DEBUG_PROCEDURE_ON) THEN
2714: BEGIN
2715: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

Line 2715: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

2711: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2712: END IF;
2713: IF(IS_DEBUG_PROCEDURE_ON) THEN
2714: BEGIN
2715: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2716: END;
2717: END IF;
2718: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2719: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

Line 2724: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

2720: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2721: ,p_token1_value => l_token_1);
2722: IF(IS_DEBUG_PROCEDURE_ON) THEN
2723: BEGIN
2724: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2725:
2726: END;
2727: END IF;
2728: -- End of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE

Line 3636: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

3632: IF p_flag = G_UPDATE THEN
3633: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.update_pdt_stys
3634: IF(L_DEBUG_ENABLED='Y') THEN
3635: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
3636: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3637: END IF;
3638: IF(IS_DEBUG_PROCEDURE_ON) THEN
3639: BEGIN
3640: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');

Line 3640: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');

3636: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3637: END IF;
3638: IF(IS_DEBUG_PROCEDURE_ON) THEN
3639: BEGIN
3640: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');
3641: END;
3642: END IF;
3643: Okl_Pdt_Stys_Pub.update_pdt_stys(p_api_version => p_api_version,
3644: p_init_msg_list => p_init_msg_list,

Line 3653: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');

3649: p_psyv_tbl => l_psyv_tbl,
3650: x_psyv_tbl => l_out_psyv_tbl);
3651: IF(IS_DEBUG_PROCEDURE_ON) THEN
3652: BEGIN
3653: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');
3654: END;
3655: END IF;
3656: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.update_pdt_stys
3657: ELSE

Line 3661: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');

3657: ELSE
3658: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.insert_pdt_stys
3659: IF(IS_DEBUG_PROCEDURE_ON) THEN
3660: BEGIN
3661: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');
3662: END;
3663: END IF;
3664: Okl_Pdt_Stys_Pub.insert_pdt_stys(p_api_version => p_api_version,
3665: p_init_msg_list => p_init_msg_list,

Line 3673: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');

3669: p_psyv_tbl => l_psyv_tbl,
3670: x_psyv_tbl => l_out_psyv_tbl);
3671: IF(IS_DEBUG_PROCEDURE_ON) THEN
3672: BEGIN
3673: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');
3674:
3675: END;
3676: END IF;
3677: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.insert_pdt_stys

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 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 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 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 3771: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Product_Options_Pub.update_product_options ');

3767: IF p_flag = G_UPDATE THEN
3768: -- Start of wraper code generated automatically by Debug code generator for Okl_Product_Options_Pub.update_product_options
3769: IF(IS_DEBUG_PROCEDURE_ON) THEN
3770: BEGIN
3771: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Product_Options_Pub.update_product_options ');
3772: END;
3773: END IF;
3774:
3775: Okl_Product_Options_Pub.update_product_options(p_api_version => p_api_version,

Line 3784: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Product_Options_Pub.update_product_options ');

3780: p_ponv_tbl => l_ponv_tbl,
3781: x_ponv_tbl => l_out_ponv_tbl);
3782: IF(IS_DEBUG_PROCEDURE_ON) THEN
3783: BEGIN
3784: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Product_Options_Pub.update_product_options ');
3785: END;
3786: END IF;
3787: -- End of wraper code generated automatically by Debug code generator for Okl_Product_Options_Pub.update_product_options
3788: ELSE

Line 3792: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Product_Options_Pub.insert_product_options ');

3788: ELSE
3789: -- Start of wraper code generated automatically by Debug code generator for Okl_Product_Options_Pub.insert_product_options
3790: IF(IS_DEBUG_PROCEDURE_ON) THEN
3791: BEGIN
3792: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Product_Options_Pub.insert_product_options ');
3793: END;
3794: END IF;
3795:
3796: Okl_Product_Options_Pub.insert_product_options(p_api_version => p_api_version,

Line 3805: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Product_Options_Pub.insert_product_options ');

3801: p_ponv_tbl => l_ponv_tbl,
3802: x_ponv_tbl => l_out_ponv_tbl);
3803: IF(IS_DEBUG_PROCEDURE_ON) THEN
3804: BEGIN
3805: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Product_Options_Pub.insert_product_options ');
3806: END;
3807: END IF;
3808: -- End of wraper code generated automatically by Debug code generator for Okl_Product_Options_Pub.insert_product_options
3809: END IF;

Line 3839: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Opt_Vals_Pub.update_pdt_opt_vals ');

3835: IF p_flag = G_UPDATE THEN
3836: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Opt_Vals_Pub.update_pdt_opt_vals
3837: IF(IS_DEBUG_PROCEDURE_ON) THEN
3838: BEGIN
3839: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Opt_Vals_Pub.update_pdt_opt_vals ');
3840: END;
3841: END IF;
3842: Okl_Pdt_Opt_Vals_Pub.update_pdt_opt_vals(p_api_version => p_api_version,
3843: p_init_msg_list => p_init_msg_list,

Line 3852: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Opt_Vals_Pub.update_pdt_opt_vals ');

3848: x_povv_tbl => l_out_povv_tbl);
3849: IF(IS_DEBUG_PROCEDURE_ON) THEN
3850:
3851: BEGIN
3852: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Opt_Vals_Pub.update_pdt_opt_vals ');
3853: END;
3854: END IF;
3855: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Opt_Vals_Pub.update_pdt_opt_vals
3856: ELSE

Line 3860: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals ');

3856: ELSE
3857: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals
3858: IF(IS_DEBUG_PROCEDURE_ON) THEN
3859: BEGIN
3860: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals ');
3861: END;
3862: END IF;
3863: Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals(p_api_version => p_api_version,
3864: p_init_msg_list => p_init_msg_list,

Line 3872: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals ');

3868: p_povv_tbl => l_povv_tbl,
3869: x_povv_tbl => l_out_povv_tbl);
3870: IF(IS_DEBUG_PROCEDURE_ON) THEN
3871: BEGIN
3872: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals ');
3873: END;
3874:
3875: END IF;
3876: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals

Line 4025: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

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;
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 ');

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 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 4235: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

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);
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 ');

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 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 4310: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Setup_Prd_Prctempl_Pub.check_product_constraints ');

4306: /* check the changes for product pricing template*/
4307: -- Start of wraper code generated automatically by Debug code generator for Okl_Setup_Prd_Prctempl_Pub.check_product_constraints
4308: IF(IS_DEBUG_PROCEDURE_ON) THEN
4309: BEGIN
4310: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Setup_Prd_Prctempl_Pub.check_product_constraints ');
4311: END;
4312: END IF;
4313:
4314:

Line 4326: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Setup_Prd_Prctempl_Pub.check_product_constraints ');

4322: p_pdtv_rec => l_pdtv_rec,
4323: x_validated => l_validated);
4324: IF(IS_DEBUG_PROCEDURE_ON) THEN
4325: BEGIN
4326: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Setup_Prd_Prctempl_Pub.check_product_constraints ');
4327: END;
4328:
4329: END IF;
4330: -- End of wraper code generated automatically by Debug code generator for Okl_Setup_Prd_Prctempl_Pub.check_product_constraints

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 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