616:
617: --Default the dependent quality
618: l_pdqv_rec.pqy_id := l_pqy_id;
619:
620: -- Start of wraper code generated automatically by Debug code generator for okl_pdt_pqys_pub.insert_pdt_pqys
621: IF(L_DEBUG_ENABLED='Y') THEN
622: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
623: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
624: END IF;
623: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
624: END IF;
625: IF(IS_DEBUG_PROCEDURE_ON) THEN
626: BEGIN
627: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call okl_pdt_pqys_pub.insert_pdt_pqys ');
628: END;
629: END IF;
630: okl_pdt_pqys_pub.insert_pdt_pqys(p_api_version => p_api_version,
631: p_init_msg_list => p_init_msg_list,
626: BEGIN
627: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call okl_pdt_pqys_pub.insert_pdt_pqys ');
628: END;
629: END IF;
630: okl_pdt_pqys_pub.insert_pdt_pqys(p_api_version => p_api_version,
631: p_init_msg_list => p_init_msg_list,
632: x_return_status => l_return_status,
633: x_msg_count => x_msg_count,
634: x_msg_data => x_msg_data,
635: p_pdqv_rec => l_pdqv_rec,
636: x_pdqv_rec => l_out_pdqv_rec);
637: IF(IS_DEBUG_PROCEDURE_ON) THEN
638: BEGIN
639: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call okl_pdt_pqys_pub.insert_pdt_pqys ');
640: END;
641: END IF;
642: -- End of wraper code generated automatically by Debug code generator for okl_pdt_pqys_pub.insert_pdt_pqys
643: END IF;
638: BEGIN
639: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call okl_pdt_pqys_pub.insert_pdt_pqys ');
640: END;
641: END IF;
642: -- End of wraper code generated automatically by Debug code generator for okl_pdt_pqys_pub.insert_pdt_pqys
643: END IF;
644:
645: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
646: x_return_status := Okl_Api.G_RET_STS_ERROR;
775: RAISE Okl_Api.G_EXCEPTION_ERROR;
776: END IF;
777:
778: /* public api to insert dqualitys */
779: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.insert_pdt_pqys
780: IF(L_DEBUG_ENABLED='Y') THEN
781: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
782: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
783: END IF;
782: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
783: END IF;
784: IF(IS_DEBUG_PROCEDURE_ON) THEN
785: BEGIN
786: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.insert_pdt_pqys ');
787: END;
788: END IF;
789: Okl_Pdt_Pqys_Pub.insert_pdt_pqys(p_api_version => p_api_version,
790: p_init_msg_list => p_init_msg_list,
785: BEGIN
786: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.insert_pdt_pqys ');
787: END;
788: END IF;
789: Okl_Pdt_Pqys_Pub.insert_pdt_pqys(p_api_version => p_api_version,
790: p_init_msg_list => p_init_msg_list,
791:
792: x_return_status => l_return_status,
793: x_msg_count => x_msg_count,
795: p_pdqv_rec => l_pdqv_rec,
796: x_pdqv_rec => x_pdqv_rec);
797: IF(IS_DEBUG_PROCEDURE_ON) THEN
798: BEGIN
799: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.insert_pdt_pqys ');
800: END;
801: END IF;
802: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.insert_pdt_pqys
803:
798: BEGIN
799: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.insert_pdt_pqys ');
800: END;
801: END IF;
802: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.insert_pdt_pqys
803:
804: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
805: RAISE Okl_Api.G_EXCEPTION_ERROR;
806: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1107: END IF;
1108: END IF;
1109: END IF;
1110: --Delete the Master
1111: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.delete_pdt_pqys
1112: IF(IS_DEBUG_PROCEDURE_ON) THEN
1113: BEGIN
1114: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.delete_pdt_pqys ');
1115: END;
1110: --Delete the Master
1111: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.delete_pdt_pqys
1112: IF(IS_DEBUG_PROCEDURE_ON) THEN
1113: BEGIN
1114: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.delete_pdt_pqys ');
1115: END;
1116: END IF;
1117: Okl_Pdt_Pqys_Pub.delete_pdt_pqys(p_api_version => p_api_version,
1118: p_init_msg_list => p_init_msg_list,
1113: BEGIN
1114: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.delete_pdt_pqys ');
1115: END;
1116: END IF;
1117: Okl_Pdt_Pqys_Pub.delete_pdt_pqys(p_api_version => p_api_version,
1118: p_init_msg_list => p_init_msg_list,
1119: x_return_status => l_return_status,
1120: x_msg_count => x_msg_count,
1121: x_msg_data => x_msg_data,
1121: x_msg_data => x_msg_data,
1122: p_pdqv_rec => p_pdqv_rec);
1123: IF(IS_DEBUG_PROCEDURE_ON) THEN
1124: BEGIN
1125: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.delete_pdt_pqys ');
1126: END;
1127: END IF;
1128: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.delete_pdt_pqys
1129:
1124: BEGIN
1125: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.delete_pdt_pqys ');
1126: END;
1127: END IF;
1128: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.delete_pdt_pqys
1129:
1130: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1131: RAISE G_EXCEPTION_HALT_PROCESSING;
1132: ELSE