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.33 2009/05/13 09:56:59 racheruv 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 2465: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

2461: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
2462: IF(L_DEBUG_ENABLED='Y') THEN
2463:
2464: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2465: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2466: END IF;
2467: IF(IS_DEBUG_PROCEDURE_ON) THEN
2468: BEGIN
2469: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

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

2465: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2466: END IF;
2467: IF(IS_DEBUG_PROCEDURE_ON) THEN
2468: BEGIN
2469: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2470: END;
2471: END IF;
2472: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2473: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

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

2474: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2475: ,p_token1_value => l_token_1);
2476: IF(IS_DEBUG_PROCEDURE_ON) THEN
2477: BEGIN
2478: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2479: END;
2480: END IF;
2481: -- End of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
2482: x_return_status := Okl_Api.G_RET_STS_ERROR;

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

2491: IF (l_row_notfound) THEN
2492: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.set_message
2493: IF(IS_DEBUG_PROCEDURE_ON) THEN
2494: BEGIN
2495: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.set_message ');
2496: END;
2497: END IF;
2498: 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);
2499: IF(IS_DEBUG_PROCEDURE_ON) THEN

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

2498: 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);
2499: IF(IS_DEBUG_PROCEDURE_ON) THEN
2500:
2501: BEGIN
2502: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.set_message ');
2503: END;
2504: END IF;
2505: -- End of wraper code generated automatically by Debug code generator for Okl_Api.set_message
2506: RAISE G_EXCEPTION_HALT_PROCESSING;

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

2565: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
2566:
2567: IF(L_DEBUG_ENABLED='Y') THEN
2568: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2569: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2570: END IF;
2571: IF(IS_DEBUG_PROCEDURE_ON) THEN
2572: BEGIN
2573: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

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

2569: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2570: END IF;
2571: IF(IS_DEBUG_PROCEDURE_ON) THEN
2572: BEGIN
2573: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2574: END;
2575: END IF;
2576: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2577: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

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

2578: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2579: ,p_token1_value => l_token_1);
2580: IF(IS_DEBUG_PROCEDURE_ON) THEN
2581: BEGIN
2582: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2583: END;
2584: END IF;
2585: -- End of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
2586: x_return_status := Okl_Api.G_RET_STS_ERROR;

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

2595: IF (l_row_notfound) THEN
2596: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.set_message
2597: IF(IS_DEBUG_PROCEDURE_ON) THEN
2598: BEGIN
2599: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.set_message ');
2600:
2601: END;
2602: END IF;
2603: 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 2606: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.set_message ');

2602: END IF;
2603: 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);
2604: IF(IS_DEBUG_PROCEDURE_ON) THEN
2605: BEGIN
2606: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.set_message ');
2607: END;
2608: END IF;
2609: -- End of wraper code generated automatically by Debug code generator for Okl_Api.set_message
2610: RAISE G_EXCEPTION_HALT_PROCESSING;

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

2662: (p_pdtv_rec.from_date = Okl_Api.G_MISS_DATE) THEN
2663: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
2664: IF(L_DEBUG_ENABLED='Y') THEN
2665: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2666: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2667: END IF;
2668: IF(IS_DEBUG_PROCEDURE_ON) THEN
2669:
2670: BEGIN

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

2667: END IF;
2668: IF(IS_DEBUG_PROCEDURE_ON) THEN
2669:
2670: BEGIN
2671: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2672: END;
2673: END IF;
2674: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2675: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

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

2676: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2677: ,p_token1_value => l_token_1);
2678: IF(IS_DEBUG_PROCEDURE_ON) THEN
2679: BEGIN
2680: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2681: END;
2682: END IF;
2683: -- End of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
2684: x_return_status := Okl_Api.G_RET_STS_ERROR;

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

2736: (p_pdtv_rec.name = Okl_Api.G_MISS_CHAR) THEN
2737: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
2738: IF(L_DEBUG_ENABLED='Y') THEN
2739: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2740: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2741: END IF;
2742: IF(IS_DEBUG_PROCEDURE_ON) THEN
2743: BEGIN
2744: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

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

2740: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2741: END IF;
2742: IF(IS_DEBUG_PROCEDURE_ON) THEN
2743: BEGIN
2744: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2745: END;
2746: END IF;
2747: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2748: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

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

2749: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2750: ,p_token1_value => l_token_1);
2751: IF(IS_DEBUG_PROCEDURE_ON) THEN
2752: BEGIN
2753: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2754:
2755: END;
2756: END IF;
2757: -- End of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE

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

3661: IF p_flag = G_UPDATE THEN
3662: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.update_pdt_stys
3663: IF(L_DEBUG_ENABLED='Y') THEN
3664: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
3665: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3666: END IF;
3667: IF(IS_DEBUG_PROCEDURE_ON) THEN
3668: BEGIN
3669: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');

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

3665: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3666: END IF;
3667: IF(IS_DEBUG_PROCEDURE_ON) THEN
3668: BEGIN
3669: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');
3670: END;
3671: END IF;
3672: Okl_Pdt_Stys_Pub.update_pdt_stys(p_api_version => p_api_version,
3673: p_init_msg_list => p_init_msg_list,

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

3678: p_psyv_tbl => l_psyv_tbl,
3679: x_psyv_tbl => l_out_psyv_tbl);
3680: IF(IS_DEBUG_PROCEDURE_ON) THEN
3681: BEGIN
3682: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');
3683: END;
3684: END IF;
3685: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.update_pdt_stys
3686: ELSE

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

3686: ELSE
3687: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.insert_pdt_stys
3688: IF(IS_DEBUG_PROCEDURE_ON) THEN
3689: BEGIN
3690: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');
3691: END;
3692: END IF;
3693: Okl_Pdt_Stys_Pub.insert_pdt_stys(p_api_version => p_api_version,
3694: p_init_msg_list => p_init_msg_list,

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

3698: p_psyv_tbl => l_psyv_tbl,
3699: x_psyv_tbl => l_out_psyv_tbl);
3700: IF(IS_DEBUG_PROCEDURE_ON) THEN
3701: BEGIN
3702: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');
3703:
3704: END;
3705: END IF;
3706: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.insert_pdt_stys

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

3731: IF p_flag = G_UPDATE THEN
3732: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
3733: IF(IS_DEBUG_PROCEDURE_ON) THEN
3734: BEGIN
3735: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
3736: END;
3737: END IF;
3738: Okl_Pqy_Values_Pub.update_pqy_values(p_api_version => p_api_version,
3739:

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

3744: p_pqvv_tbl => l_pqvv_tbl,
3745: x_pqvv_tbl => l_out_pqvv_tbl);
3746: IF(IS_DEBUG_PROCEDURE_ON) THEN
3747: BEGIN
3748: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
3749: END;
3750: END IF;
3751: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
3752: ELSE

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

3752: ELSE
3753: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
3754: IF(IS_DEBUG_PROCEDURE_ON) THEN
3755: BEGIN
3756: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
3757: END;
3758: END IF;
3759: Okl_Pqy_Values_Pub.insert_pqy_values(p_api_version => p_api_version,
3760: p_init_msg_list => p_init_msg_list,

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

3764: p_pqvv_tbl => l_pqvv_tbl,
3765: x_pqvv_tbl => l_out_pqvv_tbl);
3766: IF(IS_DEBUG_PROCEDURE_ON) THEN
3767: BEGIN
3768: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
3769: END;
3770: END IF;
3771: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
3772: END IF;

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

3796: IF p_flag = G_UPDATE THEN
3797: -- Start of wraper code generated automatically by Debug code generator for Okl_Product_Options_Pub.update_product_options
3798: IF(IS_DEBUG_PROCEDURE_ON) THEN
3799: BEGIN
3800: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Product_Options_Pub.update_product_options ');
3801: END;
3802: END IF;
3803:
3804: Okl_Product_Options_Pub.update_product_options(p_api_version => p_api_version,

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

3809: p_ponv_tbl => l_ponv_tbl,
3810: x_ponv_tbl => l_out_ponv_tbl);
3811: IF(IS_DEBUG_PROCEDURE_ON) THEN
3812: BEGIN
3813: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Product_Options_Pub.update_product_options ');
3814: END;
3815: END IF;
3816: -- End of wraper code generated automatically by Debug code generator for Okl_Product_Options_Pub.update_product_options
3817: ELSE

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

3817: ELSE
3818: -- Start of wraper code generated automatically by Debug code generator for Okl_Product_Options_Pub.insert_product_options
3819: IF(IS_DEBUG_PROCEDURE_ON) THEN
3820: BEGIN
3821: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Product_Options_Pub.insert_product_options ');
3822: END;
3823: END IF;
3824:
3825: Okl_Product_Options_Pub.insert_product_options(p_api_version => p_api_version,

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

3830: p_ponv_tbl => l_ponv_tbl,
3831: x_ponv_tbl => l_out_ponv_tbl);
3832: IF(IS_DEBUG_PROCEDURE_ON) THEN
3833: BEGIN
3834: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Product_Options_Pub.insert_product_options ');
3835: END;
3836: END IF;
3837: -- End of wraper code generated automatically by Debug code generator for Okl_Product_Options_Pub.insert_product_options
3838: END IF;

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

3864: IF p_flag = G_UPDATE THEN
3865: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Opt_Vals_Pub.update_pdt_opt_vals
3866: IF(IS_DEBUG_PROCEDURE_ON) THEN
3867: BEGIN
3868: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Opt_Vals_Pub.update_pdt_opt_vals ');
3869: END;
3870: END IF;
3871: Okl_Pdt_Opt_Vals_Pub.update_pdt_opt_vals(p_api_version => p_api_version,
3872: p_init_msg_list => p_init_msg_list,

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

3877: x_povv_tbl => l_out_povv_tbl);
3878: IF(IS_DEBUG_PROCEDURE_ON) THEN
3879:
3880: BEGIN
3881: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Opt_Vals_Pub.update_pdt_opt_vals ');
3882: END;
3883: END IF;
3884: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Opt_Vals_Pub.update_pdt_opt_vals
3885: ELSE

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

3885: ELSE
3886: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals
3887: IF(IS_DEBUG_PROCEDURE_ON) THEN
3888: BEGIN
3889: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals ');
3890: END;
3891: END IF;
3892: Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals(p_api_version => p_api_version,
3893: p_init_msg_list => p_init_msg_list,

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

3897: p_povv_tbl => l_povv_tbl,
3898: x_povv_tbl => l_out_povv_tbl);
3899: IF(IS_DEBUG_PROCEDURE_ON) THEN
3900: BEGIN
3901: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals ');
3902: END;
3903:
3904: END IF;
3905: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals

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

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

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

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

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

4335: /* check the changes for product pricing template*/
4336: -- Start of wraper code generated automatically by Debug code generator for Okl_Setup_Prd_Prctempl_Pub.check_product_constraints
4337: IF(IS_DEBUG_PROCEDURE_ON) THEN
4338: BEGIN
4339: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Setup_Prd_Prctempl_Pub.check_product_constraints ');
4340: END;
4341: END IF;
4342:
4343:

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

4351: p_pdtv_rec => l_pdtv_rec,
4352: x_validated => l_validated);
4353: IF(IS_DEBUG_PROCEDURE_ON) THEN
4354: BEGIN
4355: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Setup_Prd_Prctempl_Pub.check_product_constraints ');
4356: END;
4357:
4358: END IF;
4359: -- End of wraper code generated automatically by Debug code generator for Okl_Setup_Prd_Prctempl_Pub.check_product_constraints

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