DBA Data[Home] [Help]

APPS.OKC_TERMS_VERSION_PVT dependencies on FND_LOG

Line 24: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

20: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
21: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
22: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
23:
24: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
25: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
26: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
27:
28: --<<<<<<<<<<<<<<<<<<<<<<<<<<< INTERNAL PROCEDURES <<<<<<<<<<<<<<<<<<<<<<<<<<<

Line 25: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

21: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
22: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
23:
24: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
25: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
26: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
27:
28: --<<<<<<<<<<<<<<<<<<<<<<<<<<< INTERNAL PROCEDURES <<<<<<<<<<<<<<<<<<<<<<<<<<<
29:

Line 26: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

22: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
23:
24: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
25: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
26: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
27:
28: --<<<<<<<<<<<<<<<<<<<<<<<<<<< INTERNAL PROCEDURES <<<<<<<<<<<<<<<<<<<<<<<<<<<
29:
30: -->>>>>>>>>>>>>>>>>>>>>>>>>>> INTERNAL PROCEDURES >>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 101: FND_LOG.STRING(G_PROC_LEVEL,

97: Okc_Debug.Log('100: Entered clear_amendment', 2);
98: END IF; */
99:
100: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
101: FND_LOG.STRING(G_PROC_LEVEL,
102: G_PKG_NAME, '100: Entered clear_amendment' );
103: END IF;
104:
105:

Line 113: FND_LOG.STRING(G_PROC_LEVEL,

109: Okc_Debug.Log('110: p_keep_summary=N', 2);
110: END IF; */
111:
112: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
113: FND_LOG.STRING(G_PROC_LEVEL,
114: G_PKG_NAME, '110: p_keep_summary=N' );
115: END IF;
116:
117: FOR cr in scn_crs LOOP

Line 256: FND_LOG.STRING(G_PROC_LEVEL,

252: Okc_Debug.Log('210: p_keep_summary=Y ', 2);
253: END IF; */
254:
255: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
256: FND_LOG.STRING(G_PROC_LEVEL,
257: G_PKG_NAME, '210: p_keep_summary=Y' );
258: END IF;
259:
260: FOR cr in l_del_scn_crs LOOP

Line 415: FND_LOG.STRING(G_PROC_LEVEL,

411: Okc_Debug.Log('300: Leaving clear_amendment', 2);
412: END IF; */
413:
414: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
415: FND_LOG.STRING(G_PROC_LEVEL,
416: G_PKG_NAME, '300: Leaving clear_amendment' );
417: END IF;
418:
419: EXCEPTION

Line 426: FND_LOG.STRING(G_EXCP_LEVEL,

422: okc_debug.log('400: Leaving clear_amendment : OKC_API.G_EXCEPTION_ERROR Exception', 2);
423: END IF;*/
424:
425: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
426: FND_LOG.STRING(G_EXCP_LEVEL,
427: G_PKG_NAME, '400: Leaving clear_amendment : OKC_API.G_EXCEPTION_ERROR Exception' );
428: END IF;
429: x_return_status := G_RET_STS_ERROR ;
430: IF l_ctrt_src_crs%ISOPEN THEN

Line 439: FND_LOG.STRING(G_EXCP_LEVEL,

435: okc_debug.log('500: Leaving clear_amendment : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
436: END IF;*/
437:
438: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
439: FND_LOG.STRING(G_EXCP_LEVEL,
440: G_PKG_NAME, '500: Leaving clear_amendment : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
441: END IF;
442: x_return_status := G_RET_STS_UNEXP_ERROR ;
443: IF l_ctrt_src_crs%ISOPEN THEN

Line 452: FND_LOG.STRING(G_EXCP_LEVEL,

448: okc_debug.log('600: Leaving clear_amendment because of EXCEPTION: '||sqlerrm, 2);
449: END IF;*/
450:
451: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
452: FND_LOG.STRING(G_EXCP_LEVEL,
453: G_PKG_NAME, '600: Leaving clear_amendment because of EXCEPTION: '||sqlerrm );
454: END IF;
455:
456: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 517: FND_LOG.STRING(G_PROC_LEVEL,

513: Okc_Debug.Log('100: Call Create_Version for sections', 2);
514: END IF;*/
515:
516: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
517: FND_LOG.STRING(G_PROC_LEVEL,
518: G_PKG_NAME, '100: Entered Version_Doc' );
519: FND_LOG.STRING(G_PROC_LEVEL,
520: G_PKG_NAME, '100: Call Create_Version for sections' );
521: END IF;

Line 519: FND_LOG.STRING(G_PROC_LEVEL,

515:
516: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
517: FND_LOG.STRING(G_PROC_LEVEL,
518: G_PKG_NAME, '100: Entered Version_Doc' );
519: FND_LOG.STRING(G_PROC_LEVEL,
520: G_PKG_NAME, '100: Call Create_Version for sections' );
521: END IF;
522:
523: --------------------------------------------

Line 547: FND_LOG.STRING(G_PROC_LEVEL,

543: Okc_Debug.Log('100: Call Create_Version for articles', 2);
544: END IF;*/
545:
546: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
547: FND_LOG.STRING(G_PROC_LEVEL,
548: G_PKG_NAME, '100: Call Create_Version for articles' );
549: END IF;
550:
551: x_return_status := OKC_K_ARTICLES_PVT.Create_Version(

Line 572: FND_LOG.STRING(G_PROC_LEVEL,

568: Okc_Debug.Log('100: Call Create_Version for article variables', 2);
569: END IF;*/
570:
571: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
572: FND_LOG.STRING(G_PROC_LEVEL,
573: G_PKG_NAME, '100: Call Create_Version for article variables' );
574: END IF;
575:
576: x_return_status := OKC_K_ART_VARIABLES_PVT.Create_Version(

Line 597: FND_LOG.STRING(G_PROC_LEVEL,

593: Okc_Debug.Log('100: Call Create_Version for template usages', 2);
594: END IF;*/
595:
596: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
597: FND_LOG.STRING(G_PROC_LEVEL,
598: G_PKG_NAME, '100: Call Create_Version for template usages' );
599: END IF;
600:
601: x_return_status := OKC_TEMPLATE_USAGES_PVT.Create_Version(

Line 745: FND_LOG.STRING(G_PROC_LEVEL,

741: Okc_Debug.Log('300: Leaving Version_Doc', 2);
742: END IF;*/
743:
744: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
745: FND_LOG.STRING(G_PROC_LEVEL,
746: G_PKG_NAME, '300: Leaving Version_Doc' );
747: END IF;
748:
749: EXCEPTION

Line 756: FND_LOG.STRING(G_EXCP_LEVEL,

752: okc_debug.log('400: Leaving Version_Doc : OKC_API.G_EXCEPTION_ERROR Exception', 2);
753: END IF;*/
754:
755: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
756: FND_LOG.STRING(G_EXCP_LEVEL,
757: G_PKG_NAME, '400: Leaving Version_Doc : OKC_API.G_EXCEPTION_ERROR Exception' );
758: END IF;
759: x_return_status := G_RET_STS_ERROR ;
760:

Line 767: FND_LOG.STRING(G_EXCP_LEVEL,

763: okc_debug.log('500: Leaving Version_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
764: END IF;*/
765:
766: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
767: FND_LOG.STRING(G_EXCP_LEVEL,
768: G_PKG_NAME, '500: Leaving Version_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
769: END IF;
770: x_return_status := G_RET_STS_UNEXP_ERROR ;
771: WHEN OTHERS THEN

Line 777: FND_LOG.STRING(G_EXCP_LEVEL,

773: okc_debug.log('600: Leaving Version_Doc because of EXCEPTION: '||sqlerrm, 2);
774: END IF;*/
775:
776: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
777: FND_LOG.STRING(G_EXCP_LEVEL,
778: G_PKG_NAME, '600: Leaving Version_Doc because of EXCEPTION: '||sqlerrm );
779: END IF;
780:
781: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 807: FND_LOG.STRING(G_PROC_LEVEL,

803: Okc_Debug.Log('100: Call Restore_Version for sections', 2);
804: END IF;*/
805:
806: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
807: FND_LOG.STRING(G_PROC_LEVEL,
808: G_PKG_NAME, '100: Entered Restore_Doc_Version');
809: FND_LOG.STRING(G_PROC_LEVEL,
810: G_PKG_NAME, '100: Call Restore_Version for sections' );
811: END IF;

Line 809: FND_LOG.STRING(G_PROC_LEVEL,

805:
806: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
807: FND_LOG.STRING(G_PROC_LEVEL,
808: G_PKG_NAME, '100: Entered Restore_Doc_Version');
809: FND_LOG.STRING(G_PROC_LEVEL,
810: G_PKG_NAME, '100: Call Restore_Version for sections' );
811: END IF;
812:
813: --------------------------------------------

Line 837: FND_LOG.STRING(G_PROC_LEVEL,

833: Okc_Debug.Log('100: Call Restore_Version for articles', 2);
834: END IF;*/
835:
836: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
837: FND_LOG.STRING(G_PROC_LEVEL,
838: G_PKG_NAME, '100: Call Restore_Version for articles');
839: END IF;
840:
841: x_return_status := OKC_K_ARTICLES_PVT.Restore_Version(

Line 862: FND_LOG.STRING(G_PROC_LEVEL,

858: Okc_Debug.Log('100: Call Restore_Version for article variables', 2);
859: END IF;*/
860:
861: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
862: FND_LOG.STRING(G_PROC_LEVEL,
863: G_PKG_NAME, '100: Call Restore_Version for article variables');
864: END IF;
865: x_return_status := OKC_K_ART_VARIABLES_PVT.Restore_Version(
866: p_doc_type => p_doc_type,

Line 886: FND_LOG.STRING(G_PROC_LEVEL,

882: Okc_Debug.Log('100: Call Restore_Version for template usages', 2);
883: END IF;*/
884:
885: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
886: FND_LOG.STRING(G_PROC_LEVEL,
887: G_PKG_NAME, '100: Call Restore_Version for template usages');
888: END IF;
889: x_return_status := OKC_TEMPLATE_USAGES_PVT.Restore_Version(
890: p_doc_type => p_doc_type,

Line 908: FND_LOG.STRING(G_PROC_LEVEL,

904: Okc_Debug.Log('300: Leaving Restore_Doc_Version', 2);
905: END IF;*/
906:
907: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
908: FND_LOG.STRING(G_PROC_LEVEL,
909: G_PKG_NAME, '300: Leaving Restore_Doc_Version');
910: END IF;
911:
912: EXCEPTION

Line 919: FND_LOG.STRING(G_PROC_LEVEL,

915: okc_debug.log('400: Leaving Restore_Doc_Version : OKC_API.G_EXCEPTION_ERROR Exception', 2);
916: END IF;*/
917:
918: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
919: FND_LOG.STRING(G_PROC_LEVEL,
920: G_PKG_NAME, '400: Leaving Restore_Doc_Version : OKC_API.G_EXCEPTION_ERROR Exception');
921: END IF;
922: x_return_status := G_RET_STS_ERROR ;
923:

Line 930: FND_LOG.STRING(G_EXCP_LEVEL,

926: okc_debug.log('500: Leaving Restore_Doc_Version : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
927: END IF;*/
928:
929: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
930: FND_LOG.STRING(G_EXCP_LEVEL,
931: G_PKG_NAME, '500: Leaving Restore_Doc_Version : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
932: END IF;
933: x_return_status := G_RET_STS_UNEXP_ERROR ;
934:

Line 941: FND_LOG.STRING(G_EXCP_LEVEL,

937: okc_debug.log('600: Leaving Restore_Doc_Version because of EXCEPTION: '||sqlerrm, 2);
938: END IF;*/
939:
940: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
941: FND_LOG.STRING(G_EXCP_LEVEL,
942: G_PKG_NAME, '600: Leaving Restore_Doc_Version because of EXCEPTION: '||sqlerrm);
943: END IF;
944:
945: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 970: FND_LOG.STRING(G_PROC_LEVEL,

966: Okc_Debug.Log('100: Call Delete_Version for sections', 2);
967: END IF;*/
968:
969: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
970: FND_LOG.STRING(G_PROC_LEVEL,
971: G_PKG_NAME, '100: Entered Delete_Doc_Version');
972: FND_LOG.STRING(G_PROC_LEVEL,
973: G_PKG_NAME, '100: Call Delete_Version for sections');
974: END IF;

Line 972: FND_LOG.STRING(G_PROC_LEVEL,

968:
969: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
970: FND_LOG.STRING(G_PROC_LEVEL,
971: G_PKG_NAME, '100: Entered Delete_Doc_Version');
972: FND_LOG.STRING(G_PROC_LEVEL,
973: G_PKG_NAME, '100: Call Delete_Version for sections');
974: END IF;
975:
976:

Line 1001: FND_LOG.STRING(G_PROC_LEVEL,

997: --------------------------------------------
998: -- Call Delete_Version for article variables
999: --------------------------------------------
1000: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1001: FND_LOG.STRING(G_PROC_LEVEL,
1002: G_PKG_NAME, '100: Call Delete_Version for article variables');
1003: END IF;
1004: x_return_status := OKC_K_ART_VARIABLES_PVT.Delete_Version(
1005: p_doc_type => p_doc_type,

Line 1022: FND_LOG.STRING(G_PROC_LEVEL,

1018: -- Call Delete_Version for articles
1019: --------------------------------------------
1020:
1021: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1022: FND_LOG.STRING(G_PROC_LEVEL,
1023: G_PKG_NAME, '100: Call Delete_Version for articles');
1024: END IF;
1025: x_return_status := OKC_K_ARTICLES_PVT.Delete_Version(
1026: p_doc_type => p_doc_type,

Line 1046: FND_LOG.STRING(G_PROC_LEVEL,

1042: Okc_Debug.Log('100: Call Delete_Version for template usages', 2);
1043: END IF;*/
1044:
1045: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1046: FND_LOG.STRING(G_PROC_LEVEL,
1047: G_PKG_NAME, '100: Call Delete_Version for template usages' );
1048: END IF;
1049: x_return_status := OKC_TEMPLATE_USAGES_PVT.Delete_Version(
1050: p_doc_type => p_doc_type,

Line 1068: FND_LOG.STRING(G_PROC_LEVEL,

1064: Okc_Debug.Log('300: Leaving Delete_Doc_Version', 2);
1065: END IF;*/
1066:
1067: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1068: FND_LOG.STRING(G_PROC_LEVEL,
1069: G_PKG_NAME, '300: Leaving Delete_Doc_Version' );
1070: END IF;
1071:
1072: EXCEPTION

Line 1079: FND_LOG.STRING(G_EXCP_LEVEL,

1075: okc_debug.log('400: Leaving Delete_Doc_Version : OKC_API.G_EXCEPTION_ERROR Exception', 2);
1076: END IF;*/
1077:
1078: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1079: FND_LOG.STRING(G_EXCP_LEVEL,
1080: G_PKG_NAME, '400: Leaving Delete_Doc_Version : OKC_API.G_EXCEPTION_ERROR Exception' );
1081: END IF;
1082: x_return_status := G_RET_STS_ERROR ;
1083:

Line 1090: FND_LOG.STRING(G_EXCP_LEVEL,

1086: okc_debug.log('500: Leaving Delete_Doc_Version : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1087: END IF;*/
1088:
1089: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1090: FND_LOG.STRING(G_EXCP_LEVEL,
1091: G_PKG_NAME, '500: Leaving Delete_Doc_Version : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
1092: END IF;
1093: x_return_status := G_RET_STS_UNEXP_ERROR ;
1094:

Line 1101: FND_LOG.STRING(G_EXCP_LEVEL,

1097: okc_debug.log('600: Leaving Delete_Doc_Version because of EXCEPTION: '||sqlerrm, 2);
1098: END IF;*/
1099:
1100: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1101: FND_LOG.STRING(G_EXCP_LEVEL,
1102: G_PKG_NAME, '600: Leaving Delete_Doc_Version because of EXCEPTION: '||sqlerrm );
1103: END IF;
1104:
1105: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN