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.OKC_TERMS_SECTIONS_PVT dependencies on FND_LOG

Line 49: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

45: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
46: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
47: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
48:
49: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
50: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
51: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
52:
53: E_Resource_Busy EXCEPTION;

Line 50: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

46: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
47: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
48:
49: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
50: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
51: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
52:
53: E_Resource_Busy EXCEPTION;
54: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);

Line 51: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

47: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
48:
49: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
50: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
51: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
52:
53: E_Resource_Busy EXCEPTION;
54: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
55:

Line 71: FND_LOG.STRING(G_PROC_LEVEL,

67: Okc_Debug.Log('100: Entered get_seq_id', 2);
68: END IF;*/
69:
70: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
71: FND_LOG.STRING(G_PROC_LEVEL,
72: G_PKG_NAME, '100: Entered get_seq_id' );
73: END IF;
74:
75: IF( p_id IS NULL ) THEN

Line 89: FND_LOG.STRING(G_PROC_LEVEL,

85: Okc_Debug.Log('200: Leaving get_seq_id', 2);
86: END IF;*/
87:
88: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
89: FND_LOG.STRING(G_PROC_LEVEL,
90: G_PKG_NAME, '200: Leaving get_seq_id' );
91: END IF;
92: RETURN G_RET_STS_SUCCESS;
93: EXCEPTION

Line 101: FND_LOG.STRING(G_EXCP_LEVEL,

97: Okc_Debug.Log('300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm, 2);
98: END IF;*/
99:
100: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
101: FND_LOG.STRING(G_EXCP_LEVEL,
102: G_PKG_NAME, '300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm );
103: END IF;
104:
105: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 217: FND_LOG.STRING(G_PROC_LEVEL,

213: Okc_Debug.Log('400: Entered get_rec', 2);
214: END IF;*/
215:
216: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
217: FND_LOG.STRING(G_PROC_LEVEL,
218: G_PKG_NAME, '400: Entered get_rec' );
219: END IF;
220:
221: -- Get current database values

Line 273: FND_LOG.STRING(G_PROC_LEVEL,

269: Okc_Debug.Log('500: Leaving get_rec ', 2);
270: END IF;*/
271:
272: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
273: FND_LOG.STRING(G_PROC_LEVEL,
274: G_PKG_NAME, '500: Leaving get_rec ' );
275: END IF;
276:
277: RETURN G_RET_STS_SUCCESS ;

Line 287: FND_LOG.STRING(G_EXCP_LEVEL,

283: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);
284: END IF;*/
285:
286: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
287: FND_LOG.STRING(G_EXCP_LEVEL,
288: G_PKG_NAME, '600: Leaving get_rec because of EXCEPTION: '||sqlerrm);
289: END IF;
290:
291: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 393: FND_LOG.STRING(G_PROC_LEVEL,

389: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
390: END IF;*/
391:
392: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
393: FND_LOG.STRING(G_PROC_LEVEL,
394: G_PKG_NAME, '700: Entered Set_Attributes ' );
395: END IF;
396:
397: IF( p_id IS NOT NULL ) THEN

Line 658: FND_LOG.STRING(G_PROC_LEVEL,

654: Okc_Debug.Log('800: Leaving Set_Attributes ', 2);
655: END IF;*/
656:
657: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
658: FND_LOG.STRING(G_PROC_LEVEL,
659: G_PKG_NAME, '800: Leaving Set_Attributes ' );
660: END IF;
661:
662: RETURN G_RET_STS_SUCCESS ;

Line 670: FND_LOG.STRING(G_EXCP_LEVEL,

666: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
667: END IF;*/
668:
669: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
670: FND_LOG.STRING(G_EXCP_LEVEL,
671: G_PKG_NAME, '900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');
672: END IF;
673: RETURN G_RET_STS_ERROR;
674:

Line 681: FND_LOG.STRING(G_EXCP_LEVEL,

677: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
678: END IF;*/
679:
680: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
681: FND_LOG.STRING(G_EXCP_LEVEL,
682: G_PKG_NAME, '1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
683: END IF;
684: RETURN G_RET_STS_UNEXP_ERROR;
685:

Line 692: FND_LOG.STRING(G_EXCP_LEVEL,

688: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);
689: END IF;*/
690:
691: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
692: FND_LOG.STRING(G_EXCP_LEVEL,
693: G_PKG_NAME, '1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm);
694: END IF;
695: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
696: p_msg_name => G_UNEXPECTED_ERROR,

Line 764: FND_LOG.STRING(G_PROC_LEVEL,

760: Okc_Debug.Log('1200: Entered Validate_Attributes', 2);
761: END IF;*/
762:
763: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
764: FND_LOG.STRING(G_PROC_LEVEL,
765: G_PKG_NAME, '1200: Entered Validate_Attributes' );
766: END IF;
767:
768: IF p_validation_level > G_REQUIRED_VALUE_VALID_LEVEL THEN

Line 774: FND_LOG.STRING(G_PROC_LEVEL,

770: Okc_Debug.Log('1300: required values validation', 2);
771: END IF;*/
772:
773: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
774: FND_LOG.STRING(G_PROC_LEVEL,
775: G_PKG_NAME, '1300: required values validation' );
776: END IF;
777:
778: /*IF (l_debug = 'Y') THEN

Line 783: FND_LOG.STRING(G_PROC_LEVEL,

779: Okc_Debug.Log('1400: - attribute ID ', 2);
780: END IF;*/
781:
782: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
783: FND_LOG.STRING(G_PROC_LEVEL,
784: G_PKG_NAME, '1400: - attribute ID ' );
785: END IF;
786:
787: IF ( p_id IS NULL) THEN

Line 793: FND_LOG.STRING(G_PROC_LEVEL,

789: Okc_Debug.Log('1500: - attribute ID is invalid', 2);
790: END IF;*/
791:
792: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
793: FND_LOG.STRING(G_PROC_LEVEL,
794: G_PKG_NAME, '1500: - attribute ID is invalid' );
795: END IF;
796: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ID');
797: l_return_status := G_RET_STS_ERROR;

Line 805: FND_LOG.STRING(G_PROC_LEVEL,

801: Okc_Debug.Log('1400: - attribute DOCUMENT_TYPE ', 2);
802: END IF;*/
803:
804: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
805: FND_LOG.STRING(G_PROC_LEVEL,
806: G_PKG_NAME, '1400: - attribute DOCUMENT_TYPE ' );
807: END IF;
808: IF ( p_document_type IS NULL) THEN
809: /*IF (l_debug = 'Y') THEN

Line 814: FND_LOG.STRING(G_PROC_LEVEL,

810: Okc_Debug.Log('1500: - attribute DOCUMENT_TYPE is invalid', 2);
811: END IF;*/
812:
813: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
814: FND_LOG.STRING(G_PROC_LEVEL,
815: G_PKG_NAME, '1500: - attribute DOCUMENT_TYPE is invalid' );
816: END IF;
817: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DOCUMENT_TYPE');
818: l_return_status := G_RET_STS_ERROR;

Line 826: FND_LOG.STRING(G_PROC_LEVEL,

822: Okc_Debug.Log('1400: - attribute DOCUMENT_ID ', 2);
823: END IF;*/
824:
825: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
826: FND_LOG.STRING(G_PROC_LEVEL,
827: G_PKG_NAME, '1400: - attribute DOCUMENT_ID ' );
828: END IF;
829: IF ( p_document_id IS NULL) THEN
830: /*IF (l_debug = 'Y') THEN

Line 835: FND_LOG.STRING(G_PROC_LEVEL,

831: Okc_Debug.Log('1500: - attribute DOCUMENT_ID is invalid', 2);
832: END IF;*/
833:
834: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
835: FND_LOG.STRING(G_PROC_LEVEL,
836: G_PKG_NAME, '1500: - attribute DOCUMENT_ID is invalid' );
837: END IF;
838: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DOCUMENT_ID');
839: l_return_status := G_RET_STS_ERROR;

Line 847: FND_LOG.STRING(G_PROC_LEVEL,

843: Okc_Debug.Log('1400: - attribute SECTION_SEQUENCE ', 2);
844: END IF;*/
845:
846: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
847: FND_LOG.STRING(G_PROC_LEVEL,
848: G_PKG_NAME, '1400: - attribute SECTION_SEQUENCE ' );
849: END IF;
850: IF ( p_section_sequence IS NULL) THEN
851: /*IF (l_debug = 'Y') THEN

Line 856: FND_LOG.STRING(G_PROC_LEVEL,

852: Okc_Debug.Log('1500: - attribute SECTION_SEQUENCE is invalid', 2);
853: END IF;*/
854:
855: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
856: FND_LOG.STRING(G_PROC_LEVEL,
857: G_PKG_NAME, '1500: - attribute SECTION_SEQUENCE is invalid' );
858: END IF;
859: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'SECTION_SEQUENCE');
860: l_return_status := G_RET_STS_ERROR;

Line 871: FND_LOG.STRING(G_PROC_LEVEL,

867: Okc_Debug.Log('1600: static values and range validation', 2);
868: END IF;*/
869:
870: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
871: FND_LOG.STRING(G_PROC_LEVEL,
872: G_PKG_NAME, '1600: static values and range validation' );
873: END IF;
874:
875: /*IF (l_debug = 'Y') THEN

Line 880: FND_LOG.STRING(G_PROC_LEVEL,

876: Okc_Debug.Log('1700: - attribute PRINT_YN ', 2);
877: END IF;*/
878:
879: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
880: FND_LOG.STRING(G_PROC_LEVEL,
881: G_PKG_NAME, '1700: - attribute PRINT_YN ' );
882: END IF;
883: IF ( p_print_yn NOT IN ('Y','N') AND p_print_yn IS NOT NULL) THEN
884: /*IF (l_debug = 'Y') THEN

Line 889: FND_LOG.STRING(G_PROC_LEVEL,

885: Okc_Debug.Log('1800: - attribute PRINT_YN is invalid', 2);
886: END IF;*/
887:
888: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
889: FND_LOG.STRING(G_PROC_LEVEL,
890: G_PKG_NAME, '1800: - attribute PRINT_YN is invalid' );
891: END IF;
892: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'PRINT_YN');
893: l_return_status := G_RET_STS_ERROR;

Line 904: FND_LOG.STRING(G_PROC_LEVEL,

900: Okc_Debug.Log('1900: lookup codes validation', 2);
901: END IF;*/
902:
903: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
904: FND_LOG.STRING(G_PROC_LEVEL,
905: G_PKG_NAME, '1900: lookup codes validation' );
906: END IF;
907:
908:

Line 914: FND_LOG.STRING(G_PROC_LEVEL,

910: Okc_Debug.Log('2000: - attribute SCN_CODE ', 2);
911: END IF;*/
912:
913: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
914: FND_LOG.STRING(G_PROC_LEVEL,
915: G_PKG_NAME, '2000: - attribute SCN_CODE ' );
916: END IF;
917:
918: /* bug 3676155

Line 934: FND_LOG.STRING(G_PROC_LEVEL,

930: Okc_Debug.Log('2000: - attribute AMENDMENT_OPERATION_CODE ', 2);
931: END IF;*/
932:
933: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
934: FND_LOG.STRING(G_PROC_LEVEL,
935: G_PKG_NAME, '2000: - attribute AMENDMENT_OPERATION_CODE ' );
936: END IF;
937: IF p_amendment_operation_code IS NOT NULL THEN
938: l_return_status := Okc_Util.Check_Lookup_Code('OKC_AMEND_OPN_CODE',p_amendment_operation_code);

Line 953: FND_LOG.STRING(G_PROC_LEVEL,

949: Okc_Debug.Log('2100: foreigh keys validation ', 2);
950: END IF;*/
951:
952: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
953: FND_LOG.STRING(G_PROC_LEVEL,
954: G_PKG_NAME, '2100: foreigh keys validation ' );
955: END IF;
956:
957: /*IF (l_debug = 'Y') THEN

Line 962: FND_LOG.STRING(G_PROC_LEVEL,

958: Okc_Debug.Log('2190: - attribute DOCUMENT_TYPE ', 2);
959: END IF;*/
960:
961: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
962: FND_LOG.STRING(G_PROC_LEVEL,
963: G_PKG_NAME, '2190: - attribute DOCUMENT_TYPE ' );
964: END IF;
965:
966: IF p_document_type IS NOT NULL THEN

Line 977: FND_LOG.STRING(G_PROC_LEVEL,

973: Okc_Debug.Log('2300: - attribute DOCUMENT_TYPE is invalid', 2);
974: END IF;*/
975:
976: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
977: FND_LOG.STRING(G_PROC_LEVEL,
978: G_PKG_NAME, '2300: - attribute DOCUMENT_TYPE is invalid' );
979: END IF;
980:
981: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DOCUMENT_TYPE');

Line 991: FND_LOG.STRING(G_PROC_LEVEL,

987: Okc_Debug.Log('2200: - attribute SCN_ID ', 2);
988: END IF;*/
989:
990: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
991: FND_LOG.STRING(G_PROC_LEVEL,
992: G_PKG_NAME, '2200: - attribute SCN_ID ' );
993: END IF;
994:
995: IF p_scn_id IS NOT NULL THEN

Line 1006: FND_LOG.STRING(G_PROC_LEVEL,

1002: Okc_Debug.Log('2300: - attribute SCN_ID is invalid', 2);
1003: END IF;*/
1004:
1005: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1006: FND_LOG.STRING(G_PROC_LEVEL,
1007: G_PKG_NAME, '2300: - attribute SCN_ID is invalid' );
1008: END IF;
1009: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SCN_ID');
1010: l_return_status := G_RET_STS_ERROR;

Line 1022: FND_LOG.STRING(G_PROC_LEVEL,

1018: Okc_Debug.Log('2400: Leaving Validate_Attributes ', 2);
1019: END IF;*/
1020:
1021: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1022: FND_LOG.STRING(G_PROC_LEVEL,
1023: G_PKG_NAME, '2400: Leaving Validate_Attributes ' );
1024: END IF;
1025:
1026: RETURN l_return_status;

Line 1032: FND_LOG.STRING(G_EXCP_LEVEL,

1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: --Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
1031: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1032: FND_LOG.STRING(G_EXCP_LEVEL,
1033: G_PKG_NAME, '2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm);
1034: END IF;
1035: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1036: p_msg_name => G_UNEXPECTED_ERROR,

Line 1107: FND_LOG.STRING(G_PROC_LEVEL,

1103: Okc_Debug.Log('2600: Entered Validate_Record', 2);
1104: END IF;*/
1105:
1106: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1107: FND_LOG.STRING(G_PROC_LEVEL,
1108: G_PKG_NAME, '2600: Entered Validate_Record' );
1109: END IF;
1110:
1111: --- Validate all non-missing attributes (Item Level Validation)

Line 1153: FND_LOG.STRING(G_PROC_LEVEL,

1149: Okc_Debug.Log('2700: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm, 2);
1150: END IF;*/
1151:
1152: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1153: FND_LOG.STRING(G_PROC_LEVEL,
1154: G_PKG_NAME, '2700: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm );
1155: END IF;
1156: RETURN G_RET_STS_UNEXP_ERROR;
1157: END IF;

Line 1166: FND_LOG.STRING(G_PROC_LEVEL,

1162: Okc_Debug.Log('2800: Entered Record Level Validations', 2);
1163: END IF;*/
1164:
1165: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1166: FND_LOG.STRING(G_PROC_LEVEL,
1167: G_PKG_NAME, '2800: Entered Record Level Validations' );
1168: END IF;
1169: /*+++++++++++++start of hand code +++++++++++++++++++*/
1170: -- ?? manual coding for Record Level Validations if required ??

Line 1179: FND_LOG.STRING(G_PROC_LEVEL,

1175: Okc_Debug.Log('2900: Leaving Validate_Record : '||sqlerrm, 2);
1176: END IF;*/
1177:
1178: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1179: FND_LOG.STRING(G_PROC_LEVEL,
1180: G_PKG_NAME, '2900: Leaving Validate_Record : '||sqlerrm);
1181: END IF;
1182: RETURN l_return_status ;
1183:

Line 1192: FND_LOG.STRING(G_EXCP_LEVEL,

1188: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
1189: END IF;*/
1190:
1191: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1192: FND_LOG.STRING(G_EXCP_LEVEL,
1193: G_PKG_NAME, '3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm );
1194: END IF;
1195:
1196: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1295: FND_LOG.STRING(G_PROC_LEVEL,

1291: Okc_Debug.Log('3100: Entered validate_row', 2);
1292: END IF;*/
1293:
1294: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1295: FND_LOG.STRING(G_PROC_LEVEL,
1296: G_PKG_NAME, '3100: Entered validate_row');
1297: END IF;
1298:
1299: -- Setting attributes

Line 1419: FND_LOG.STRING(G_PROC_LEVEL,

1415: Okc_Debug.Log('3200: Leaving validate_row', 2);
1416: END IF;*/
1417:
1418: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1419: FND_LOG.STRING(G_PROC_LEVEL,
1420: G_PKG_NAME, '3200: Leaving validate_row' );
1421: END IF;
1422:
1423: EXCEPTION

Line 1430: FND_LOG.STRING(G_EXCP_LEVEL,

1426: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
1427: END IF;*/
1428:
1429: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1430: FND_LOG.STRING(G_EXCP_LEVEL,
1431: G_PKG_NAME, '3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');
1432: END IF;
1433: x_return_status := G_RET_STS_ERROR;
1434:

Line 1441: FND_LOG.STRING(G_EXCP_LEVEL,

1437: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1438: END IF;*/
1439:
1440: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1441: FND_LOG.STRING(G_EXCP_LEVEL,
1442: G_PKG_NAME, '3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1443: END IF;
1444: x_return_status := G_RET_STS_UNEXP_ERROR;
1445:

Line 1452: FND_LOG.STRING(G_EXCP_LEVEL,

1448: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
1449: END IF;*/
1450:
1451: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1452: FND_LOG.STRING(G_EXCP_LEVEL,
1453: G_PKG_NAME, '3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm);
1454: END IF;
1455: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1456: p_msg_name => G_UNEXPECTED_ERROR,

Line 1524: FND_LOG.STRING(G_PROC_LEVEL,

1520: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
1521: END IF;*/
1522:
1523: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1524: FND_LOG.STRING(G_PROC_LEVEL,
1525: G_PKG_NAME, '3600: Entered Insert_Row function' );
1526: END IF;
1527: IF p_document_type IN ('OKC_SELL','OKC_BUY','OKO','OKS','OKE_SELL','OKE_BUY','OKL') THEN
1528: l_chr_id := okc_terms_util_pvt.get_chr_id_for_doc_id(p_document_id);

Line 1625: FND_LOG.STRING(G_PROC_LEVEL,

1621: Okc_Debug.Log('3700: Leaving Insert_Row', 2);
1622: END IF;*/
1623:
1624: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1625: FND_LOG.STRING(G_PROC_LEVEL,
1626: G_PKG_NAME, '3700: Leaving Insert_Row' );
1627: END IF;
1628:
1629: RETURN( G_RET_STS_SUCCESS );

Line 1639: FND_LOG.STRING(G_EXCP_LEVEL,

1635: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
1636: END IF;*/
1637:
1638: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1639: FND_LOG.STRING(G_EXCP_LEVEL,
1640: G_PKG_NAME, '3800: Leaving Insert_Row:OTHERS Exception' );
1641: END IF;
1642: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1643: p_msg_name => G_UNEXPECTED_ERROR,

Line 1713: FND_LOG.STRING(G_PROC_LEVEL,

1709: Okc_Debug.Log('4200: Entered Insert_Row', 2);
1710: END IF;*/
1711:
1712: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1713: FND_LOG.STRING(G_PROC_LEVEL,
1714: G_PKG_NAME, '4200: Entered Insert_Row' );
1715: END IF;
1716:
1717: --- Setting item attributes

Line 1797: FND_LOG.STRING(G_PROC_LEVEL,

1793: Okc_Debug.Log('4300: Call the internal Insert_Row for Base Table', 2);
1794: END IF;*/
1795:
1796: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1797: FND_LOG.STRING(G_PROC_LEVEL,
1798: G_PKG_NAME, '4300: Call the internal Insert_Row for Base Table' );
1799: END IF;
1800:
1801: x_return_status := Insert_Row(

Line 1856: FND_LOG.STRING(G_PROC_LEVEL,

1852: Okc_Debug.Log('4500: Leaving Insert_Row', 2);
1853: END IF;*/
1854:
1855: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1856: FND_LOG.STRING(G_PROC_LEVEL,
1857: G_PKG_NAME, '4500: Leaving Insert_Row');
1858: END IF;
1859:
1860: EXCEPTION

Line 1867: FND_LOG.STRING(G_EXCP_LEVEL,

1863: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
1864: END IF;*/
1865:
1866: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1867: FND_LOG.STRING(G_EXCP_LEVEL,
1868: G_PKG_NAME, '4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception' );
1869: END IF;
1870: x_return_status := G_RET_STS_ERROR;
1871:

Line 1878: FND_LOG.STRING(G_EXCP_LEVEL,

1874: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1875: END IF;*/
1876:
1877: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1878: FND_LOG.STRING(G_EXCP_LEVEL,
1879: G_PKG_NAME, '4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1880: END IF;
1881: x_return_status := G_RET_STS_UNEXP_ERROR;
1882:

Line 1889: FND_LOG.STRING(G_EXCP_LEVEL,

1885: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
1886: END IF;*/
1887:
1888: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1889: FND_LOG.STRING(G_EXCP_LEVEL,
1890: G_PKG_NAME, '4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm);
1891: END IF;
1892: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1893: p_msg_name => G_UNEXPECTED_ERROR,

Line 1937: FND_LOG.STRING(G_PROC_LEVEL,

1933: Okc_Debug.Log('4900: Entered Lock_Row', 2);
1934: END IF;*/
1935:
1936: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1937: FND_LOG.STRING(G_PROC_LEVEL,
1938: G_PKG_NAME, '4900: Entered Lock_Row');
1939: END IF;
1940:
1941: BEGIN

Line 1956: FND_LOG.STRING(G_EXCP_LEVEL,

1952: Okc_Debug.Log('5000: Leaving Lock_Row:E_Resource_Busy Exception', 2);
1953: END IF;*/
1954:
1955: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1956: FND_LOG.STRING(G_EXCP_LEVEL,
1957: G_PKG_NAME, '5000: Leaving Lock_Row:E_Resource_Busy Exception' );
1958: END IF;
1959:
1960: IF (lock_csr%ISOPEN) THEN

Line 1997: FND_LOG.STRING(G_PROC_LEVEL,

1993: Okc_Debug.Log('5100: Leaving Lock_Row', 2);
1994: END IF;*/
1995:
1996: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1997: FND_LOG.STRING(G_PROC_LEVEL,
1998: G_PKG_NAME, '5100: Leaving Lock_Row');
1999: END IF;
2000:
2001: RETURN( l_return_status );

Line 2018: FND_LOG.STRING(G_PROC_LEVEL,

2014: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
2015: END IF;*/
2016:
2017: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2018: FND_LOG.STRING(G_PROC_LEVEL,
2019: G_PKG_NAME, '5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm);
2020: END IF;
2021:
2022: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 2048: FND_LOG.STRING(G_PROC_LEVEL,

2044: Okc_Debug.Log('5800: Locking Row for Base Table', 2);
2045: END IF;*/
2046:
2047: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2048: FND_LOG.STRING(G_PROC_LEVEL,
2049: G_PKG_NAME, '5700: Entered Lock_Row');
2050: FND_LOG.STRING(G_PROC_LEVEL,
2051: G_PKG_NAME, '5800: Locking Row for Base Table');
2052: END IF;

Line 2050: FND_LOG.STRING(G_PROC_LEVEL,

2046:
2047: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2048: FND_LOG.STRING(G_PROC_LEVEL,
2049: G_PKG_NAME, '5700: Entered Lock_Row');
2050: FND_LOG.STRING(G_PROC_LEVEL,
2051: G_PKG_NAME, '5800: Locking Row for Base Table');
2052: END IF;
2053:
2054: --------------------------------------------

Line 2072: FND_LOG.STRING(G_PROC_LEVEL,

2068: Okc_Debug.Log('6000: Leaving Lock_Row', 2);
2069: END IF;*/
2070:
2071: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2072: FND_LOG.STRING(G_PROC_LEVEL,
2073: G_PKG_NAME, '6000: Leaving Lock_Row');
2074: END IF;
2075:
2076: EXCEPTION

Line 2083: FND_LOG.STRING(G_EXCP_LEVEL,

2079: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
2080: END IF;*/
2081:
2082: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2083: FND_LOG.STRING(G_EXCP_LEVEL,
2084: G_PKG_NAME, '6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception' );
2085: END IF;
2086: x_return_status := G_RET_STS_ERROR;
2087:

Line 2094: FND_LOG.STRING(G_EXCP_LEVEL,

2090: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2091: END IF;*/
2092:
2093: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2094: FND_LOG.STRING(G_EXCP_LEVEL,
2095: G_PKG_NAME, '6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
2096: END IF;
2097: x_return_status := G_RET_STS_UNEXP_ERROR;
2098:

Line 2105: FND_LOG.STRING(G_EXCP_LEVEL,

2101: Okc_Debug.Log('6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
2102: END IF;*/
2103:
2104: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2105: FND_LOG.STRING(G_EXCP_LEVEL,
2106: G_PKG_NAME, '6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm );
2107: END IF;
2108: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2109: p_msg_name => G_UNEXPECTED_ERROR,

Line 2175: FND_LOG.STRING(G_PROC_LEVEL,

2171: Okc_Debug.Log('6400: Entered Update_Row', 2);
2172: END IF;*/
2173:
2174: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2175: FND_LOG.STRING(G_PROC_LEVEL,
2176: G_PKG_NAME, '6400: Entered Update_Row');
2177: END IF;
2178: IF p_document_type IN ('OKC_SELL','OKC_BUY','OKO','OKS','OKE_SELL','OKE_BUY','OKL') THEN
2179: l_chr_id := okc_terms_util_pvt.get_chr_id_for_doc_id(p_document_id);

Line 2228: FND_LOG.STRING(G_PROC_LEVEL,

2224: Okc_Debug.Log('6500: Leaving Update_Row', 2);
2225: END IF;*/
2226:
2227: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2228: FND_LOG.STRING(G_PROC_LEVEL,
2229: G_PKG_NAME, '6500: Leaving Update_Row');
2230: END IF;
2231:
2232: RETURN G_RET_STS_SUCCESS ;

Line 2242: FND_LOG.STRING(G_EXCP_LEVEL,

2238: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
2239: END IF;*/
2240:
2241: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2242: FND_LOG.STRING(G_EXCP_LEVEL,
2243: G_PKG_NAME, '6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm);
2244: END IF;
2245:
2246: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 2349: FND_LOG.STRING(G_PROC_LEVEL,

2345: Okc_Debug.Log('7100: Locking _B row', 2);
2346: END IF;*/
2347:
2348: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2349: FND_LOG.STRING(G_PROC_LEVEL,
2350: G_PKG_NAME, '7000: Entered Update_Row');
2351: FND_LOG.STRING(G_PROC_LEVEL,
2352: G_PKG_NAME, '7100: Locking _B row');
2353: END IF;

Line 2351: FND_LOG.STRING(G_PROC_LEVEL,

2347:
2348: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2349: FND_LOG.STRING(G_PROC_LEVEL,
2350: G_PKG_NAME, '7000: Entered Update_Row');
2351: FND_LOG.STRING(G_PROC_LEVEL,
2352: G_PKG_NAME, '7100: Locking _B row');
2353: END IF;
2354:
2355: x_return_status := Lock_row(

Line 2371: FND_LOG.STRING(G_PROC_LEVEL,

2367: Okc_Debug.Log('7300: Setting attributes', 2);
2368: END IF;*/
2369:
2370: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2371: FND_LOG.STRING(G_PROC_LEVEL,
2372: G_PKG_NAME, '7300: Setting attributes');
2373: END IF;
2374:
2375: x_return_status := Set_Attributes(

Line 2457: FND_LOG.STRING(G_PROC_LEVEL,

2453: Okc_Debug.Log('7400: Record Validation', 2);
2454: END IF;*/
2455:
2456: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2457: FND_LOG.STRING(G_PROC_LEVEL,
2458: G_PKG_NAME, '7400: Record Validation');
2459: END IF;
2460:
2461: --- Validate all non-missing attributes

Line 2509: FND_LOG.STRING(G_PROC_LEVEL,

2505: Okc_Debug.Log('7500: Filling WHO columns', 2);
2506: END IF;*/
2507:
2508: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2509: FND_LOG.STRING(G_PROC_LEVEL,
2510: G_PKG_NAME, '7500: Filling WHO columns');
2511: END IF;
2512:
2513: -- Filling who columns

Line 2531: FND_LOG.STRING(G_PROC_LEVEL,

2527: Okc_Debug.Log('7600: Updating Row', 2);
2528: END IF;*/
2529:
2530: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2531: FND_LOG.STRING(G_PROC_LEVEL,
2532: G_PKG_NAME, '7600: Updating Row');
2533: END IF;
2534:
2535: x_return_status := Update_Row(

Line 2589: FND_LOG.STRING(G_PROC_LEVEL,

2585: Okc_Debug.Log('7800: Leaving Update_Row', 2);
2586: END IF;*/
2587:
2588: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2589: FND_LOG.STRING(G_PROC_LEVEL,
2590: G_PKG_NAME, '7800: Leaving Update_Row');
2591: END IF;
2592:
2593: EXCEPTION

Line 2600: FND_LOG.STRING(G_EXCP_LEVEL,

2596: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
2597: END IF;*/
2598:
2599: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2600: FND_LOG.STRING(G_EXCP_LEVEL,
2601: G_PKG_NAME, '7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception' );
2602: END IF;
2603: x_return_status := G_RET_STS_ERROR;
2604:

Line 2611: FND_LOG.STRING(G_EXCP_LEVEL,

2607: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2608: END IF;*/
2609:
2610: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2611: FND_LOG.STRING(G_EXCP_LEVEL,
2612: G_PKG_NAME, '8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
2613: END IF;
2614: x_return_status := G_RET_STS_UNEXP_ERROR;
2615:

Line 2622: FND_LOG.STRING(G_EXCP_LEVEL,

2618: Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
2619: END IF;*/
2620:
2621: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2622: FND_LOG.STRING(G_EXCP_LEVEL,
2623: G_PKG_NAME, '8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm);
2624: END IF;
2625: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2626: p_msg_name => G_UNEXPECTED_ERROR,

Line 2652: FND_LOG.STRING(G_PROC_LEVEL,

2648: Okc_Debug.Log('8200: Entered Delete_Row', 2);
2649: END IF;*/
2650:
2651: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2652: FND_LOG.STRING(G_PROC_LEVEL,
2653: G_PKG_NAME, '8200: Entered Delete_Row');
2654: END IF;
2655:
2656: DELETE FROM OKC_SECTIONS_B WHERE ID = p_ID;

Line 2663: FND_LOG.STRING(G_PROC_LEVEL,

2659: Okc_Debug.Log('8300: Leaving Delete_Row', 2);
2660: END IF;*/
2661:
2662: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2663: FND_LOG.STRING(G_PROC_LEVEL,
2664: G_PKG_NAME, '8300: Leaving Delete_Row');
2665: END IF;
2666:
2667: RETURN( G_RET_STS_SUCCESS );

Line 2677: FND_LOG.STRING(G_EXCP_LEVEL,

2673: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
2674: END IF;*/
2675:
2676: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2677: FND_LOG.STRING(G_EXCP_LEVEL,
2678: G_PKG_NAME, '8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );
2679: END IF;
2680:
2681: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 2709: FND_LOG.STRING(G_PROC_LEVEL,

2705: Okc_Debug.Log('8900: Locking _B row', 2);
2706: END IF;*/
2707:
2708: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2709: FND_LOG.STRING(G_PROC_LEVEL,
2710: G_PKG_NAME, '8800: Entered Delete_Row');
2711: FND_LOG.STRING(G_PROC_LEVEL,
2712: G_PKG_NAME, '8900: Locking _B row');
2713: END IF;

Line 2711: FND_LOG.STRING(G_PROC_LEVEL,

2707:
2708: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2709: FND_LOG.STRING(G_PROC_LEVEL,
2710: G_PKG_NAME, '8800: Entered Delete_Row');
2711: FND_LOG.STRING(G_PROC_LEVEL,
2712: G_PKG_NAME, '8900: Locking _B row');
2713: END IF;
2714:
2715: x_return_status := Lock_row(

Line 2730: FND_LOG.STRING(G_PROC_LEVEL,

2726: Okc_Debug.Log('9100: Removing _B row', 2);
2727: END IF;*/
2728:
2729: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2730: FND_LOG.STRING(G_PROC_LEVEL,
2731: G_PKG_NAME, '9100: Removing _B row');
2732: END IF;
2733: x_return_status := Delete_Row( p_id => p_id );
2734: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 2745: FND_LOG.STRING(G_PROC_LEVEL,

2741: Okc_Debug.Log('9300: Leaving Delete_Row', 2);
2742: END IF;*/
2743:
2744: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2745: FND_LOG.STRING(G_PROC_LEVEL,
2746: G_PKG_NAME, '9300: Leaving Delete_Row');
2747: END IF;
2748:
2749: EXCEPTION

Line 2756: FND_LOG.STRING(G_EXCP_LEVEL,

2752: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
2753: END IF;*/
2754:
2755: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2756: FND_LOG.STRING(G_EXCP_LEVEL,
2757: G_PKG_NAME, '9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception' );
2758: END IF;
2759: x_return_status := G_RET_STS_ERROR;
2760:

Line 2768: FND_LOG.STRING(G_EXCP_LEVEL,

2764: END IF;*/
2765: x_return_status := G_RET_STS_UNEXP_ERROR;
2766:
2767: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2768: FND_LOG.STRING(G_EXCP_LEVEL,
2769: G_PKG_NAME, '9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
2770: END IF;
2771:
2772: WHEN OTHERS THEN

Line 2778: FND_LOG.STRING(G_EXCP_LEVEL,

2774: Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
2775: END IF;*/
2776:
2777: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2778: FND_LOG.STRING(G_EXCP_LEVEL,
2779: G_PKG_NAME, '9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm);
2780: END IF;
2781: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2782: p_msg_name => G_UNEXPECTED_ERROR,

Line 2813: FND_LOG.STRING(G_PROC_LEVEL,

2809: Okc_Debug.Log('9700: Entered Delete_Set', 2);
2810: END IF;*/
2811:
2812: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2813: FND_LOG.STRING(G_PROC_LEVEL,
2814: G_PKG_NAME, '9700: Entered Delete_Set');
2815: FND_LOG.STRING(G_PROC_LEVEL,
2816: G_PKG_NAME, '9705: p_retain_lock_terms_yn : ' || p_retain_lock_terms_yn);
2817:

Line 2815: FND_LOG.STRING(G_PROC_LEVEL,

2811:
2812: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2813: FND_LOG.STRING(G_PROC_LEVEL,
2814: G_PKG_NAME, '9700: Entered Delete_Set');
2815: FND_LOG.STRING(G_PROC_LEVEL,
2816: G_PKG_NAME, '9705: p_retain_lock_terms_yn : ' || p_retain_lock_terms_yn);
2817:
2818: END IF;
2819:

Line 2839: FND_LOG.STRING(G_PROC_LEVEL,

2835: Okc_Debug.Log('11000: Leaving Delete_set', 2);
2836: END IF;*/
2837:
2838: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2839: FND_LOG.STRING(G_PROC_LEVEL,
2840: G_PKG_NAME, '11000: Leaving Delete_set');
2841: END IF;
2842:
2843: EXCEPTION

Line 2850: FND_LOG.STRING(G_EXCP_LEVEL,

2846: Okc_Debug.Log('000: Leaving Delete_set:E_Resource_Busy Exception', 2);
2847: END IF;*/
2848:
2849: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2850: FND_LOG.STRING(G_EXCP_LEVEL,
2851: G_PKG_NAME, '000: Leaving Delete_set:E_Resource_Busy Exception' );
2852: END IF;
2853:
2854: IF (lock_csr%ISOPEN) THEN

Line 2866: FND_LOG.STRING(G_EXCP_LEVEL,

2862: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
2863: END IF;*/
2864:
2865: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2866: FND_LOG.STRING(G_EXCP_LEVEL,
2867: G_PKG_NAME, '11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception' );
2868: END IF;
2869:
2870: IF (lock_csr%ISOPEN) THEN

Line 2881: FND_LOG.STRING(G_EXCP_LEVEL,

2877: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2878: END IF;*/
2879:
2880: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2881: FND_LOG.STRING(G_EXCP_LEVEL,
2882: G_PKG_NAME, '11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
2883: END IF;
2884:
2885: IF (lock_csr%ISOPEN) THEN

Line 2896: FND_LOG.STRING(G_EXCP_LEVEL,

2892: Okc_Debug.Log('11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm, 2);
2893: END IF;*/
2894:
2895: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2896: FND_LOG.STRING(G_EXCP_LEVEL,
2897: G_PKG_NAME, '11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm );
2898: END IF;
2899:
2900: IF (lock_csr%ISOPEN) THEN

Line 2928: FND_LOG.STRING(G_PROC_LEVEL,

2924: Okc_Debug.Log('9800: Saving Base Table', 2);
2925: END IF;*/
2926:
2927: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2928: FND_LOG.STRING(G_PROC_LEVEL,
2929: G_PKG_NAME, '9700: Entered create_version' );
2930: FND_LOG.STRING(G_PROC_LEVEL,
2931: G_PKG_NAME, '9800: Saving Base Table' );
2932: END IF;

Line 2930: FND_LOG.STRING(G_PROC_LEVEL,

2926:
2927: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2928: FND_LOG.STRING(G_PROC_LEVEL,
2929: G_PKG_NAME, '9700: Entered create_version' );
2930: FND_LOG.STRING(G_PROC_LEVEL,
2931: G_PKG_NAME, '9800: Saving Base Table' );
2932: END IF;
2933:
2934: -----------------------------------------

Line 3036: FND_LOG.STRING(G_PROC_LEVEL,

3032: Okc_Debug.Log('10000: Leaving create_version', 2);
3033: END IF;*/
3034:
3035: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3036: FND_LOG.STRING(G_PROC_LEVEL,
3037: G_PKG_NAME, '10000: Leaving create_version' );
3038: END IF;
3039:
3040: RETURN( G_RET_STS_SUCCESS );

Line 3050: FND_LOG.STRING(G_EXCP_LEVEL,

3046: Okc_Debug.Log('10100: Leaving create_version because of EXCEPTION: '||sqlerrm, 2);
3047: END IF;*/
3048:
3049: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
3050: FND_LOG.STRING(G_EXCP_LEVEL,
3051: G_PKG_NAME, '10100: Leaving create_version because of EXCEPTION: '||sqlerrm );
3052: END IF;
3053:
3054: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 3081: FND_LOG.STRING(G_PROC_LEVEL,

3077: Okc_Debug.Log('10300: Restoring Base Table', 2);
3078: END IF;*/
3079:
3080: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3081: FND_LOG.STRING(G_PROC_LEVEL,
3082: G_PKG_NAME, '10200: Entered restore_version' );
3083: FND_LOG.STRING(G_PROC_LEVEL,
3084: G_PKG_NAME, '10300: Restoring Base Table' );
3085: END IF;

Line 3083: FND_LOG.STRING(G_PROC_LEVEL,

3079:
3080: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3081: FND_LOG.STRING(G_PROC_LEVEL,
3082: G_PKG_NAME, '10200: Entered restore_version' );
3083: FND_LOG.STRING(G_PROC_LEVEL,
3084: G_PKG_NAME, '10300: Restoring Base Table' );
3085: END IF;
3086:
3087: -----------------------------------------

Line 3186: FND_LOG.STRING(G_PROC_LEVEL,

3182: Okc_Debug.Log('10500: Leaving restore_version', 2);
3183: END IF;*/
3184:
3185: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3186: FND_LOG.STRING(G_PROC_LEVEL,
3187: G_PKG_NAME, '10500: Leaving restore_version' );
3188: END IF;
3189:
3190: RETURN( G_RET_STS_SUCCESS );

Line 3200: FND_LOG.STRING(G_EXCP_LEVEL,

3196: Okc_Debug.Log('10600: Leaving restore_version because of EXCEPTION: '||sqlerrm, 2);
3197: END IF;*/
3198:
3199: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
3200: FND_LOG.STRING(G_EXCP_LEVEL,
3201: G_PKG_NAME, '10600: Leaving restore_version because of EXCEPTION: '||sqlerrm);
3202: END IF;
3203:
3204: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 3231: FND_LOG.STRING(G_PROC_LEVEL,

3227: Okc_Debug.Log('7200: Entered Delete_Version', 2);
3228: END IF;*/
3229:
3230: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3231: FND_LOG.STRING(G_PROC_LEVEL,
3232: G_PKG_NAME, '7200: Entered Delete_Version' );
3233: END IF;
3234:
3235: -----------------------------------------

Line 3247: FND_LOG.STRING(G_PROC_LEVEL,

3243: Okc_Debug.Log('7300: Leaving Delete_Version', 2);
3244: END IF;*/
3245:
3246: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3247: FND_LOG.STRING(G_PROC_LEVEL,
3248: G_PKG_NAME, '7300: Leaving Delete_Version' );
3249: END IF;
3250:
3251: RETURN( G_RET_STS_SUCCESS );

Line 3261: FND_LOG.STRING(G_EXCP_LEVEL,

3257: Okc_Debug.Log('7400: Leaving Delete_Version because of EXCEPTION: '||sqlerrm, 2);
3258: END IF;*/
3259:
3260: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
3261: FND_LOG.STRING(G_EXCP_LEVEL,
3262: G_PKG_NAME, '7400: Leaving Delete_Version because of EXCEPTION: '||sqlerrm );
3263: END IF;
3264:
3265: Okc_Api.Set_Message(p_app_name => G_APP_NAME,