DBA Data[Home] [Help]

APPS.OKL_SETUPDQUALITYS_PVT dependencies on OKL_DEBUG_PUB

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

1: Package BODY Okl_Setupdqualitys_Pvt AS
2: /* $Header: OKLRSDQB.pls 120.5 2007/09/12 12:18:38 rajnisku 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_ITEM_NOT_FOUND_ERROR EXCEPTION;

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

452: (p_pdqv_rec.pqy_id = Okl_Api.G_MISS_NUM) THEN
453: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
454: IF(L_DEBUG_ENABLED='Y') THEN
455: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
456: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
457: END IF;
458: IF(IS_DEBUG_PROCEDURE_ON) THEN
459: BEGIN
460: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Api.SET_MESSAGE ');

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

456: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
457: END IF;
458: IF(IS_DEBUG_PROCEDURE_ON) THEN
459: BEGIN
460: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Api.SET_MESSAGE ');
461: END;
462: END IF;
463: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name
464: ,p_msg_name => Okl_Pdq_Pvt.g_required_value

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

465: ,p_token1 => Okl_Pdq_Pvt.g_col_name_token
466: ,p_token1_value => l_token_1);
467: IF(IS_DEBUG_PROCEDURE_ON) THEN
468: BEGIN
469: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Api.SET_MESSAGE ');
470: END;
471: END IF;
472: -- End of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
473: x_return_status := Okl_Api.G_RET_STS_ERROR;

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

484: IF (l_row_notfound) THEN
485: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.set_message
486: IF(IS_DEBUG_PROCEDURE_ON) THEN
487: BEGIN
488: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Api.set_message ');
489: END;
490: END IF;
491: Okl_Api.set_message(Okl_Pdq_Pvt.G_APP_NAME, Okl_Pdq_Pvt.G_INVALID_VALUE,Okl_Pdq_Pvt.G_COL_NAME_TOKEN,l_token_1);
492: IF(IS_DEBUG_PROCEDURE_ON) THEN

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

490: END IF;
491: Okl_Api.set_message(Okl_Pdq_Pvt.G_APP_NAME, Okl_Pdq_Pvt.G_INVALID_VALUE,Okl_Pdq_Pvt.G_COL_NAME_TOKEN,l_token_1);
492: IF(IS_DEBUG_PROCEDURE_ON) THEN
493: BEGIN
494: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Api.set_message ');
495: END;
496: END IF;
497: -- End of wraper code generated automatically by Debug code generator for Okl_Api.set_message
498: RAISE G_ITEM_NOT_FOUND_ERROR;

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

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

Line 627: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call okl_pdt_pqys_pub.insert_pdt_pqys ');

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,

Line 639: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call okl_pdt_pqys_pub.insert_pdt_pqys ');

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;

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

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

Line 786: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.insert_pdt_pqys ');

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,

Line 799: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.insert_pdt_pqys ');

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:

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

1077: IF l_del_pqvv_tbl.COUNT > 0 THEN
1078: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.delete_pqy_values
1079: IF(L_DEBUG_ENABLED='Y') THEN
1080: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1081: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1082: END IF;
1083: IF(IS_DEBUG_PROCEDURE_ON) THEN
1084: BEGIN
1085: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pqy_Values_Pub.delete_pqy_values ');

Line 1085: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pqy_Values_Pub.delete_pqy_values ');

1081: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1082: END IF;
1083: IF(IS_DEBUG_PROCEDURE_ON) THEN
1084: BEGIN
1085: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pqy_Values_Pub.delete_pqy_values ');
1086: END;
1087: END IF;
1088: Okl_Pqy_Values_Pub.delete_pqy_values(p_api_version => p_api_version,
1089: p_init_msg_list => p_init_msg_list,

Line 1096: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pqy_Values_Pub.delete_pqy_values ');

1092: x_msg_data => x_msg_data,
1093: p_pqvv_tbl => l_del_pqvv_tbl);
1094: IF(IS_DEBUG_PROCEDURE_ON) THEN
1095: BEGIN
1096: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pqy_Values_Pub.delete_pqy_values ');
1097: END;
1098: END IF;
1099: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.delete_pqy_values
1100:

Line 1114: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.delete_pdt_pqys ');

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,

Line 1125: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.delete_pdt_pqys ');

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: