1: Package BODY Okl_Setuppqvalues_Pvt AS
2: /* $Header: OKLRSUVB.pls 120.20 2007/09/26 08:25:39 rajnisku noship $ */
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:
822: (p_pqvv_rec.qve_id = Okl_Api.G_MISS_NUM) THEN
823: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
824: IF(L_DEBUG_ENABLED='Y') THEN
825: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
826: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
827: END IF;
828: IF(IS_DEBUG_PROCEDURE_ON) THEN
829: BEGIN
830: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSUVB.pls call Okl_Api.SET_MESSAGE ');
826: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
827: END IF;
828: IF(IS_DEBUG_PROCEDURE_ON) THEN
829: BEGIN
830: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSUVB.pls call Okl_Api.SET_MESSAGE ');
831: END;
832: END IF;
833: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pqv_Pvt.g_app_name
834: ,p_msg_name => Okl_Pqv_Pvt.g_required_value
836: ,p_token1_value => l_token_1);
837:
838: IF(IS_DEBUG_PROCEDURE_ON) THEN
839: BEGIN
840: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSUVB.pls call Okl_Api.SET_MESSAGE ');
841: END;
842: END IF;
843: -- End of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
844: x_return_status := Okl_Api.G_RET_STS_ERROR;
854: IF (l_row_notfound) THEN
855: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.set_message
856: IF(IS_DEBUG_PROCEDURE_ON) THEN
857: BEGIN
858: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSUVB.pls call Okl_Api.set_message ');
859: END;
860: END IF;
861: Okl_Api.set_message(Okl_Pqv_Pvt.G_APP_NAME, Okl_Pqv_Pvt.G_INVALID_VALUE,Okl_Pqv_Pvt.G_COL_NAME_TOKEN,l_token_1);
862: IF(IS_DEBUG_PROCEDURE_ON) THEN
860: END IF;
861: Okl_Api.set_message(Okl_Pqv_Pvt.G_APP_NAME, Okl_Pqv_Pvt.G_INVALID_VALUE,Okl_Pqv_Pvt.G_COL_NAME_TOKEN,l_token_1);
862: IF(IS_DEBUG_PROCEDURE_ON) THEN
863: BEGIN
864: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSUVB.pls call Okl_Api.set_message ');
865:
866:
867: END;
868: END IF;
1032:
1033: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
1034: IF(L_DEBUG_ENABLED='Y') THEN
1035: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1036: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1037: END IF;
1038: IF(IS_DEBUG_PROCEDURE_ON) THEN
1039: BEGIN
1040:
1037: END IF;
1038: IF(IS_DEBUG_PROCEDURE_ON) THEN
1039: BEGIN
1040:
1041: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
1042: END;
1043: END IF;
1044: Okl_Pqy_Values_Pub.insert_pqy_values(p_api_version => p_api_version,
1045: p_init_msg_list => p_init_msg_list,
1049: p_pqvv_rec => l_pqvv_rec,
1050: x_pqvv_rec => x_pqvv_rec);
1051: IF(IS_DEBUG_PROCEDURE_ON) THEN
1052: BEGIN
1053: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
1054: END;
1055: END IF;
1056: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
1057:
1194:
1195: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
1196: IF(L_DEBUG_ENABLED='Y') THEN
1197: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1198: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1199: END IF;
1200: IF(IS_DEBUG_PROCEDURE_ON) THEN
1201: BEGIN
1202: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
1198: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1199: END IF;
1200: IF(IS_DEBUG_PROCEDURE_ON) THEN
1201: BEGIN
1202: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
1203: END;
1204: END IF;
1205: Okl_Pqy_Values_Pub.update_pqy_values(p_api_version => p_api_version,
1206: p_init_msg_list => p_init_msg_list,
1210: p_pqvv_rec => l_pqvv_rec,
1211: x_pqvv_rec => x_pqvv_rec);
1212: IF(IS_DEBUG_PROCEDURE_ON) THEN
1213: BEGIN
1214: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
1215: END;
1216: END IF;
1217: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
1218: