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_K_ARTICLES_PVT dependencies on OKC_DEBUG

Line 67: Okc_Debug.Log('100: Entered get_seq_id', 2);

63: CURSOR c_seq IS
64: SELECT OKC_K_ARTICLES_B_S.NEXTVAL FROM DUAL;
65: BEGIN
66: IF (l_debug = 'Y') THEN
67: Okc_Debug.Log('100: Entered get_seq_id', 2);
68: END IF;
69:
70: IF( p_id IS NULL ) THEN
71: OPEN c_seq;

Line 80: Okc_Debug.Log('200: Leaving get_seq_id', 2);

76: CLOSE c_seq;
77: END IF;
78:
79: IF (l_debug = 'Y') THEN
80: Okc_Debug.Log('200: Leaving get_seq_id', 2);
81: END IF;
82: RETURN G_RET_STS_SUCCESS;
83: EXCEPTION
84: WHEN OTHERS THEN

Line 87: Okc_Debug.Log('300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm, 2);

83: EXCEPTION
84: WHEN OTHERS THEN
85:
86: IF (l_debug = 'Y') THEN
87: Okc_Debug.Log('300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm, 2);
88: END IF;
89:
90: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
91: p_msg_name => G_UNEXPECTED_ERROR,

Line 258: Okc_Debug.Log('400: Entered get_rec', 2);

254: WHERE t.ID = cp_id and major_version=cp_major_version;
255: BEGIN
256:
257: IF (l_debug = 'Y') THEN
258: Okc_Debug.Log('400: Entered get_rec', 2);
259: END IF;
260:
261: IF p_major_version IS NULL THEN
262: IF (l_debug = 'Y') THEN

Line 263: Okc_Debug.Log('401: Get current database values', 2);

259: END IF;
260:
261: IF p_major_version IS NULL THEN
262: IF (l_debug = 'Y') THEN
263: Okc_Debug.Log('401: Get current database values', 2);
264: END IF;
265:
266: -- Get current database values
267: OPEN OKC_K_ARTICLES_B_pk_csr (p_id);

Line 325: Okc_Debug.Log('402: Get history database values', 2);

321: END IF;
322: CLOSE OKC_K_ARTICLES_B_pk_csr;
323: ELSE
324: IF (l_debug = 'Y') THEN
325: Okc_Debug.Log('402: Get history database values', 2);
326: END IF;
327:
328: -- Get history database values
329: OPEN OKC_K_ARTICLES_BH_pk_csr (p_id, p_major_version);

Line 389: Okc_Debug.Log('500: Leaving get_rec ', 2);

385: CLOSE OKC_K_ARTICLES_BH_pk_csr;
386: END IF;
387:
388: IF (l_debug = 'Y') THEN
389: Okc_Debug.Log('500: Leaving get_rec ', 2);
390: END IF;
391:
392: RETURN G_RET_STS_SUCCESS ;
393:

Line 397: Okc_Debug.Log('600: Leaving get_rec because of NO_DATA_FOUND EXCEPTION.', 2);

393:
394: EXCEPTION
395: WHEN NO_DATA_FOUND THEN
396: IF (l_debug = 'Y') THEN
397: Okc_Debug.Log('600: Leaving get_rec because of NO_DATA_FOUND EXCEPTION.', 2);
398: END IF;
399:
400: -- moved upper where an exception is raised
401: -- Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,

Line 420: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);

416:
417: WHEN OTHERS THEN
418:
419: IF (l_debug = 'Y') THEN
420: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);
421: END IF;
422:
423: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
424: p_msg_name => G_UNEXPECTED_ERROR,

Line 915: Okc_Debug.Log('700: Entered Validate_Attributes', 2);

911:
912: BEGIN
913:
914: IF (l_debug = 'Y') THEN
915: Okc_Debug.Log('700: Entered Validate_Attributes', 2);
916: END IF;
917:
918: IF p_validation_level > G_REQUIRED_VALUE_VALID_LVL THEN
919: IF (l_debug = 'Y') THEN

Line 920: Okc_Debug.Log('800: required values validation', 2);

916: END IF;
917:
918: IF p_validation_level > G_REQUIRED_VALUE_VALID_LVL THEN
919: IF (l_debug = 'Y') THEN
920: Okc_Debug.Log('800: required values validation', 2);
921: END IF;
922:
923: IF (l_debug = 'Y') THEN
924: Okc_Debug.Log('900: - attribute ID ', 2);

Line 924: Okc_Debug.Log('900: - attribute ID ', 2);

920: Okc_Debug.Log('800: required values validation', 2);
921: END IF;
922:
923: IF (l_debug = 'Y') THEN
924: Okc_Debug.Log('900: - attribute ID ', 2);
925: END IF;
926: IF ( p_id IS NULL) THEN
927: IF (l_debug = 'Y') THEN
928: Okc_Debug.Log('1000: - attribute ID is invalid', 2);

Line 928: Okc_Debug.Log('1000: - attribute ID is invalid', 2);

924: Okc_Debug.Log('900: - attribute ID ', 2);
925: END IF;
926: IF ( p_id IS NULL) THEN
927: IF (l_debug = 'Y') THEN
928: Okc_Debug.Log('1000: - attribute ID is invalid', 2);
929: END IF;
930: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ID');
931: l_return_status := G_RET_STS_ERROR;
932: END IF;

Line 935: Okc_Debug.Log('1400: - attribute DOCUMENT_TYPE ', 2);

931: l_return_status := G_RET_STS_ERROR;
932: END IF;
933:
934: IF (l_debug = 'Y') THEN
935: Okc_Debug.Log('1400: - attribute DOCUMENT_TYPE ', 2);
936: END IF;
937: IF ( p_document_type IS NULL) THEN
938: IF (l_debug = 'Y') THEN
939: Okc_Debug.Log('1500: - attribute DOCUMENT_TYPE is invalid', 2);

Line 939: Okc_Debug.Log('1500: - attribute DOCUMENT_TYPE is invalid', 2);

935: Okc_Debug.Log('1400: - attribute DOCUMENT_TYPE ', 2);
936: END IF;
937: IF ( p_document_type IS NULL) THEN
938: IF (l_debug = 'Y') THEN
939: Okc_Debug.Log('1500: - attribute DOCUMENT_TYPE is invalid', 2);
940: END IF;
941: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DOCUMENT_TYPE');
942: l_return_status := G_RET_STS_ERROR;
943: END IF;

Line 946: Okc_Debug.Log('1400: - attribute DOCUMENT_ID ', 2);

942: l_return_status := G_RET_STS_ERROR;
943: END IF;
944:
945: IF (l_debug = 'Y') THEN
946: Okc_Debug.Log('1400: - attribute DOCUMENT_ID ', 2);
947: END IF;
948: IF ( p_document_id IS NULL) THEN
949: IF (l_debug = 'Y') THEN
950: Okc_Debug.Log('1500: - attribute DOCUMENT_ID is invalid', 2);

Line 950: Okc_Debug.Log('1500: - attribute DOCUMENT_ID is invalid', 2);

946: Okc_Debug.Log('1400: - attribute DOCUMENT_ID ', 2);
947: END IF;
948: IF ( p_document_id IS NULL) THEN
949: IF (l_debug = 'Y') THEN
950: Okc_Debug.Log('1500: - attribute DOCUMENT_ID is invalid', 2);
951: END IF;
952: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DOCUMENT_ID');
953: l_return_status := G_RET_STS_ERROR;
954: END IF;

Line 957: Okc_Debug.Log('1400: - attribute SCN_ID ', 2);

953: l_return_status := G_RET_STS_ERROR;
954: END IF;
955:
956: IF (l_debug = 'Y') THEN
957: Okc_Debug.Log('1400: - attribute SCN_ID ', 2);
958: END IF;
959: IF ( p_scn_id IS NULL) THEN
960: IF (l_debug = 'Y') THEN
961: Okc_Debug.Log('1500: - attribute SCN_ID is invalid', 2);

Line 961: Okc_Debug.Log('1500: - attribute SCN_ID is invalid', 2);

957: Okc_Debug.Log('1400: - attribute SCN_ID ', 2);
958: END IF;
959: IF ( p_scn_id IS NULL) THEN
960: IF (l_debug = 'Y') THEN
961: Okc_Debug.Log('1500: - attribute SCN_ID is invalid', 2);
962: END IF;
963: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'SCN_ID');
964: l_return_status := G_RET_STS_ERROR;
965: END IF;

Line 968: Okc_Debug.Log('1400: - attribute DISPLAY_SEQUENCE ', 2);

964: l_return_status := G_RET_STS_ERROR;
965: END IF;
966:
967: IF (l_debug = 'Y') THEN
968: Okc_Debug.Log('1400: - attribute DISPLAY_SEQUENCE ', 2);
969: END IF;
970: IF ( p_display_sequence IS NULL) THEN
971: IF (l_debug = 'Y') THEN
972: Okc_Debug.Log('1500: - attribute DISPLAY_SEQUENCE is invalid', 2);

Line 972: Okc_Debug.Log('1500: - attribute DISPLAY_SEQUENCE is invalid', 2);

968: Okc_Debug.Log('1400: - attribute DISPLAY_SEQUENCE ', 2);
969: END IF;
970: IF ( p_display_sequence IS NULL) THEN
971: IF (l_debug = 'Y') THEN
972: Okc_Debug.Log('1500: - attribute DISPLAY_SEQUENCE is invalid', 2);
973: END IF;
974: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DISPLAY_SEQUENCE');
975: l_return_status := G_RET_STS_ERROR;
976: END IF;

Line 979: Okc_Debug.Log('1400: - attribute SAV_SAE_ID', 2);

975: l_return_status := G_RET_STS_ERROR;
976: END IF;
977:
978: IF (l_debug = 'Y') THEN
979: Okc_Debug.Log('1400: - attribute SAV_SAE_ID', 2);
980: END IF;
981: IF ( p_sav_sae_id IS NULL) THEN
982: IF (l_debug = 'Y') THEN
983: Okc_Debug.Log('1500: - attribute SAV_SAE_ID is invalid', 2);

Line 983: Okc_Debug.Log('1500: - attribute SAV_SAE_ID is invalid', 2);

979: Okc_Debug.Log('1400: - attribute SAV_SAE_ID', 2);
980: END IF;
981: IF ( p_sav_sae_id IS NULL) THEN
982: IF (l_debug = 'Y') THEN
983: Okc_Debug.Log('1500: - attribute SAV_SAE_ID is invalid', 2);
984: END IF;
985: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'SAV_SAE_ID');
986: l_return_status := G_RET_STS_ERROR;
987: END IF;

Line 992: Okc_Debug.Log('1100: static values and range validation', 2);

988: END IF;
989:
990: IF p_validation_level > G_VALID_VALUE_VALID_LVL THEN
991: IF (l_debug = 'Y') THEN
992: Okc_Debug.Log('1100: static values and range validation', 2);
993: END IF;
994:
995:
996: IF (l_debug = 'Y') THEN

Line 997: Okc_Debug.Log('1200: - attribute MANDATORY_YN ', 2);

993: END IF;
994:
995:
996: IF (l_debug = 'Y') THEN
997: Okc_Debug.Log('1200: - attribute MANDATORY_YN ', 2);
998: END IF;
999:
1000: IF ( p_mandatory_yn NOT IN ('Y','N') AND p_mandatory_yn IS NOT NULL) THEN
1001: IF (l_debug = 'Y') THEN

Line 1002: Okc_Debug.Log('1300: - attribute MANDATORY_YN is invalid', 2);

998: END IF;
999:
1000: IF ( p_mandatory_yn NOT IN ('Y','N') AND p_mandatory_yn IS NOT NULL) THEN
1001: IF (l_debug = 'Y') THEN
1002: Okc_Debug.Log('1300: - attribute MANDATORY_YN is invalid', 2);
1003: END IF;
1004: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'MANDATORY_YN');
1005: l_return_status := G_RET_STS_ERROR;
1006: END IF;

Line 1009: Okc_Debug.Log('1200: - attribute PRINT_TEXT_YN ', 2);

1005: l_return_status := G_RET_STS_ERROR;
1006: END IF;
1007:
1008: IF (l_debug = 'Y') THEN
1009: Okc_Debug.Log('1200: - attribute PRINT_TEXT_YN ', 2);
1010: END IF;
1011:
1012: IF ( p_print_text_yn NOT IN ('Y','N') AND p_print_text_yn IS NOT NULL) THEN
1013: IF (l_debug = 'Y') THEN

Line 1014: Okc_Debug.Log('1300: - attribute PRINT_TEXT_YN is invalid', 2);

1010: END IF;
1011:
1012: IF ( p_print_text_yn NOT IN ('Y','N') AND p_print_text_yn IS NOT NULL) THEN
1013: IF (l_debug = 'Y') THEN
1014: Okc_Debug.Log('1300: - attribute PRINT_TEXT_YN is invalid', 2);
1015: END IF;
1016: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'PRINT_TEXT_YN');
1017: l_return_status := G_RET_STS_ERROR;
1018: END IF;

Line 1021: Okc_Debug.Log('1200: - attribute CHANGE_NONSTD_YN ', 2);

1017: l_return_status := G_RET_STS_ERROR;
1018: END IF;
1019:
1020: IF (l_debug = 'Y') THEN
1021: Okc_Debug.Log('1200: - attribute CHANGE_NONSTD_YN ', 2);
1022: END IF;
1023: IF ( p_change_nonstd_yn NOT IN ('Y','N') AND p_change_nonstd_yn IS NOT NULL) THEN
1024: IF (l_debug = 'Y') THEN
1025: Okc_Debug.Log('1300: - attribute CHANGE_NONSTD_YN is invalid', 2);

Line 1025: Okc_Debug.Log('1300: - attribute CHANGE_NONSTD_YN is invalid', 2);

1021: Okc_Debug.Log('1200: - attribute CHANGE_NONSTD_YN ', 2);
1022: END IF;
1023: IF ( p_change_nonstd_yn NOT IN ('Y','N') AND p_change_nonstd_yn IS NOT NULL) THEN
1024: IF (l_debug = 'Y') THEN
1025: Okc_Debug.Log('1300: - attribute CHANGE_NONSTD_YN is invalid', 2);
1026: END IF;
1027: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'CHANGE_NONSTD_YN');
1028: l_return_status := G_RET_STS_ERROR;
1029: END IF;

Line 1035: Okc_Debug.Log('1400: lookup codes validation', 2);

1031: END IF;
1032:
1033: IF p_validation_level > G_LOOKUP_CODE_VALID_LVL THEN
1034: IF (l_debug = 'Y') THEN
1035: Okc_Debug.Log('1400: lookup codes validation', 2);
1036: END IF;
1037:
1038: IF p_amendment_operation_code is not null THEN
1039: IF (l_debug = 'Y') THEN

Line 1040: Okc_Debug.Log('1500: - attribute AMENDMENT_OPERATION_CODE ', 2);

1036: END IF;
1037:
1038: IF p_amendment_operation_code is not null THEN
1039: IF (l_debug = 'Y') THEN
1040: Okc_Debug.Log('1500: - attribute AMENDMENT_OPERATION_CODE ', 2);
1041: END IF;
1042:
1043: l_return_status := Okc_Util.Check_Lookup_Code('OKC_AMEND_OPN_CODE',p_amendment_operation_code);
1044:

Line 1052: Okc_Debug.Log('1500: - attribute SUMMARY_AMEND_OPERATION_CODE ', 2);

1048: END IF;
1049:
1050: IF p_summary_amend_operation_code is not null THEN
1051: IF (l_debug = 'Y') THEN
1052: Okc_Debug.Log('1500: - attribute SUMMARY_AMEND_OPERATION_CODE ', 2);
1053: END IF;
1054:
1055: l_return_status := Okc_Util.Check_Lookup_Code('OKC_AMEND_OPN_CODE',p_summary_amend_operation_code);
1056:

Line 1083: Okc_Debug.Log('1600: foreigh keys validation ', 2);

1079: END IF;
1080:
1081: IF p_validation_level > G_FOREIGN_KEY_VALID_LVL THEN
1082: IF (l_debug = 'Y') THEN
1083: Okc_Debug.Log('1600: foreigh keys validation ', 2);
1084: END IF;
1085:
1086: IF p_document_type IS NOT NULL THEN
1087: l_dummy_var := '?';

Line 1093: Okc_Debug.Log('2300: - attribute DOCUMENT_TYPE is invalid', 2);

1089: FETCH l_doc_type_csr INTO l_dummy_var;
1090: CLOSE l_doc_type_csr;
1091: IF (l_dummy_var = '?') THEN
1092: IF (l_debug = 'Y') THEN
1093: Okc_Debug.Log('2300: - attribute DOCUMENT_TYPE is invalid', 2);
1094: END IF;
1095: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DOCUMENT_TYPE');
1096: l_return_status := G_RET_STS_ERROR;
1097: END IF;

Line 1101: Okc_Debug.Log('1700: - attribute SAV_SAE_ID ', 2);

1097: END IF;
1098: END IF;
1099:
1100: IF (l_debug = 'Y') THEN
1101: Okc_Debug.Log('1700: - attribute SAV_SAE_ID ', 2);
1102: END IF;
1103: IF p_sav_sae_id IS NOT NULL THEN
1104: l_dummy_var := '?';
1105: OPEN lc_sav_sae_id;

Line 1110: Okc_Debug.Log('1800: - attribute SAV_SAE_ID is invalid', 2);

1106: FETCH lc_sav_sae_id INTO l_dummy_var;
1107: CLOSE lc_sav_sae_id;
1108: IF (l_dummy_var = '?') THEN
1109: IF (l_debug = 'Y') THEN
1110: Okc_Debug.Log('1800: - attribute SAV_SAE_ID is invalid', 2);
1111: END IF;
1112: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SAV_SAE_ID');
1113: l_return_status := G_RET_STS_ERROR;
1114: END IF;

Line 1119: Okc_Debug.Log('1700: - attribute SCN_ID ', 2);

1115: END IF;
1116:
1117:
1118: IF (l_debug = 'Y') THEN
1119: Okc_Debug.Log('1700: - attribute SCN_ID ', 2);
1120: END IF;
1121: IF p_scn_id IS NOT NULL THEN
1122: l_dummy_var := '?';
1123: OPEN lc_scn_id;

Line 1128: Okc_Debug.Log('1800: - attribute SCN_ID is invalid', 2);

1124: FETCH lc_scn_id INTO l_dummy_var;
1125: CLOSE lc_scn_id;
1126: IF (l_dummy_var = '?') THEN
1127: IF (l_debug = 'Y') THEN
1128: Okc_Debug.Log('1800: - attribute SCN_ID is invalid', 2);
1129: END IF;
1130: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SCN_ID');
1131: l_return_status := G_RET_STS_ERROR;
1132: END IF;

Line 1136: Okc_Debug.Log('1700: - attribute ARTICLE_VERSION_ID ', 2);

1132: END IF;
1133: END IF;
1134:
1135: IF (l_debug = 'Y') THEN
1136: Okc_Debug.Log('1700: - attribute ARTICLE_VERSION_ID ', 2);
1137: END IF;
1138: IF p_article_version_id IS NOT NULL THEN
1139: l_dummy_var := '?';
1140: OPEN lc_article_version_id;

Line 1145: Okc_Debug.Log('1800: - attribute ARTICLE_VERSION_ID is invalid', 2);

1141: FETCH lc_article_version_id INTO l_dummy_var;
1142: CLOSE lc_article_version_id;
1143: IF (l_dummy_var = '?') THEN
1144: IF (l_debug = 'Y') THEN
1145: Okc_Debug.Log('1800: - attribute ARTICLE_VERSION_ID is invalid', 2);
1146: END IF;
1147: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ARTICLE_VERSION_ID');
1148: l_return_status := G_RET_STS_ERROR;
1149: END IF;

Line 1156: Okc_Debug.Log('1900: Leaving Validate_Attributes ', 2);

1152: END IF;
1153:
1154:
1155: IF (l_debug = 'Y') THEN
1156: Okc_Debug.Log('1900: Leaving Validate_Attributes ', 2);
1157: END IF;
1158:
1159: RETURN l_return_status;
1160:

Line 1163: Okc_Debug.Log('2000: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);

1159: RETURN l_return_status;
1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: Okc_Debug.Log('2000: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
1164: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1165: p_msg_name => G_UNEXPECTED_ERROR,
1166: p_token1 => G_SQLCODE_TOKEN,
1167: p_token1_value => sqlcode,

Line 1259: Okc_Debug.Log('2100: Entered Validate_Record', 2);

1255:
1256: BEGIN
1257:
1258: IF (l_debug = 'Y') THEN
1259: Okc_Debug.Log('2100: Entered Validate_Record', 2);
1260: END IF;
1261:
1262: --- Validate all non-missing attributes (Item Level Validation)
1263: l_return_status := Validate_Attributes(

Line 1307: Okc_Debug.Log('2200: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm, 2);

1303: );
1304:
1305: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1306: IF (l_debug = 'Y') THEN
1307: Okc_Debug.Log('2200: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm, 2);
1308: END IF;
1309: RETURN G_RET_STS_UNEXP_ERROR;
1310: END IF;
1311:

Line 1315: Okc_Debug.Log('2300: Entered Record Level Validations', 2);

1311:
1312: --- Record Level Validation
1313: IF p_validation_level > G_RECORD_VALID_LVL THEN
1314: IF (l_debug = 'Y') THEN
1315: Okc_Debug.Log('2300: Entered Record Level Validations', 2);
1316: END IF;
1317:
1318: -- this validation is not required for templates
1319: IF p_sav_sae_id IS NOT NULL AND p_article_version_id IS NOT NULL

Line 1329: Okc_Debug.Log('1500: - Wrong Combination of Article_version_id and sav_sae_id', 2);

1325: CLOSE L_validate_article_csr;
1326: If l_dummy_var='?' THEN
1327:
1328: IF (l_debug = 'Y') THEN
1329: Okc_Debug.Log('1500: - Wrong Combination of Article_version_id and sav_sae_id', 2);
1330: END IF;
1331: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_VERSION_ID');
1332: l_return_status := G_RET_STS_ERROR;
1333: END IF;

Line 1338: Okc_Debug.Log('2400: Leaving Validate_Record : '||sqlerrm, 2);

1334: END IF;
1335: END IF;
1336:
1337: IF (l_debug = 'Y') THEN
1338: Okc_Debug.Log('2400: Leaving Validate_Record : '||sqlerrm, 2);
1339: END IF;
1340: RETURN l_return_status ;
1341:
1342: EXCEPTION

Line 1346: Okc_Debug.Log('2500: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);

1342: EXCEPTION
1343: WHEN OTHERS THEN
1344:
1345: IF (l_debug = 'Y') THEN
1346: Okc_Debug.Log('2500: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
1347: END IF;
1348:
1349: IF l_validate_article_csr%ISOPEN THEN
1350: CLOSE l_validate_article_csr;

Line 1460: Okc_Debug.Log('2600: Entered validate_row', 2);

1456: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1457: BEGIN
1458:
1459: IF (l_debug = 'Y') THEN
1460: Okc_Debug.Log('2600: Entered validate_row', 2);
1461: END IF;
1462:
1463: -- Setting attributes
1464: x_return_status := Set_Attributes(

Line 1597: Okc_Debug.Log('2700: Leaving validate_row', 2);

1593: p_mandatory_rwa => l_mandatory_rwa
1594: );
1595:
1596: IF (l_debug = 'Y') THEN
1597: Okc_Debug.Log('2700: Leaving validate_row', 2);
1598: END IF;
1599:
1600: EXCEPTION
1601: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1604: Okc_Debug.Log('2800: Leaving Validate_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

1600: EXCEPTION
1601: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1602:
1603: IF (l_debug = 'Y') THEN
1604: Okc_Debug.Log('2800: Leaving Validate_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1605: END IF;
1606:
1607: x_return_status := G_RET_STS_ERROR;
1608:

Line 1612: Okc_Debug.Log('2900: Leaving Validate_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1608:
1609: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1610:
1611: IF (l_debug = 'Y') THEN
1612: Okc_Debug.Log('2900: Leaving Validate_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1613: END IF;
1614:
1615: x_return_status := G_RET_STS_UNEXP_ERROR;
1616: WHEN OTHERS THEN

Line 1619: Okc_Debug.Log('3000: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);

1615: x_return_status := G_RET_STS_UNEXP_ERROR;
1616: WHEN OTHERS THEN
1617:
1618: IF (l_debug = 'Y') THEN
1619: Okc_Debug.Log('3000: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
1620: END IF;
1621:
1622: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1623: p_msg_name => G_UNEXPECTED_ERROR,

Line 1692: Okc_Debug.Log('3100: Entered Insert_Row function', 2);

1688: l_chr_id NUMBER;
1689: BEGIN
1690:
1691: IF (l_debug = 'Y') THEN
1692: Okc_Debug.Log('3100: Entered Insert_Row function', 2);
1693: END IF;
1694:
1695: IF p_document_type IN ('OKC_SELL','OKC_BUY','OKO','OKS','OKE_SELL','OKE_BUY','OKL') THEN
1696: l_chr_id := okc_terms_util_pvt.get_chr_id_for_doc_id(p_document_id);

Line 1811: Okc_Debug.Log('3200: Leaving Insert_Row', 2);

1807: p_last_amendment_date,
1808: p_mandatory_rwa);
1809:
1810: IF (l_debug = 'Y') THEN
1811: Okc_Debug.Log('3200: Leaving Insert_Row', 2);
1812: END IF;
1813:
1814: RETURN( G_RET_STS_SUCCESS );
1815:

Line 1820: Okc_Debug.Log('3300: Leaving Insert_Row:OTHERS Exception', 2);

1816: EXCEPTION
1817: WHEN OTHERS THEN
1818:
1819: IF (l_debug = 'Y') THEN
1820: Okc_Debug.Log('3300: Leaving Insert_Row:OTHERS Exception', 2);
1821: END IF;
1822:
1823: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1824: p_msg_name => G_UNEXPECTED_ERROR,

Line 1897: Okc_Debug.Log('3400: Entered Insert_Row', 2);

1893:
1894: x_return_status := G_RET_STS_SUCCESS;
1895:
1896: IF (l_debug = 'Y') THEN
1897: Okc_Debug.Log('3400: Entered Insert_Row', 2);
1898: END IF;
1899:
1900: --- Setting item attributes
1901: -- Set primary key value

Line 2036: Okc_Debug.Log('3500: Leaving Insert_Row', 2);

2032: RAISE OKC_API.G_EXCEPTION_ERROR;
2033: END IF;
2034:
2035: IF (l_debug = 'Y') THEN
2036: Okc_Debug.Log('3500: Leaving Insert_Row', 2);
2037: END IF;
2038:
2039: EXCEPTION
2040: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2043: Okc_Debug.Log('3600: Leaving Insert_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

2039: EXCEPTION
2040: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2041:
2042: IF (l_debug = 'Y') THEN
2043: Okc_Debug.Log('3600: Leaving Insert_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2044: END IF;
2045:
2046: x_return_status := G_RET_STS_ERROR;
2047:

Line 2051: Okc_Debug.Log('3700: Leaving Insert_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2047:
2048: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2049:
2050: IF (l_debug = 'Y') THEN
2051: Okc_Debug.Log('3700: Leaving Insert_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2052: END IF;
2053:
2054: x_return_status := G_RET_STS_UNEXP_ERROR;
2055: WHEN OTHERS THEN

Line 2058: Okc_Debug.Log('3800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);

2054: x_return_status := G_RET_STS_UNEXP_ERROR;
2055: WHEN OTHERS THEN
2056:
2057: IF (l_debug = 'Y') THEN
2058: Okc_Debug.Log('3800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
2059: END IF;
2060:
2061: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2062: p_msg_name => G_UNEXPECTED_ERROR,

Line 2102: Okc_Debug.Log('3900: Entered Lock_Row', 2);

2098: l_row_notfound BOOLEAN := FALSE;
2099: BEGIN
2100:
2101: IF (l_debug = 'Y') THEN
2102: Okc_Debug.Log('3900: Entered Lock_Row', 2);
2103: END IF;
2104:
2105:
2106: BEGIN

Line 2117: Okc_Debug.Log('4000: Leaving Lock_Row:E_Resource_Busy Exception', 2);

2113: EXCEPTION
2114: WHEN E_Resource_Busy THEN
2115:
2116: IF (l_debug = 'Y') THEN
2117: Okc_Debug.Log('4000: Leaving Lock_Row:E_Resource_Busy Exception', 2);
2118: END IF;
2119:
2120: IF (lock_csr%ISOPEN) THEN
2121: CLOSE lock_csr;

Line 2153: Okc_Debug.Log('4100: Leaving Lock_Row', 2);

2149: l_return_status := G_RET_STS_SUCCESS;
2150: END IF;
2151:
2152: IF (l_debug = 'Y') THEN
2153: Okc_Debug.Log('4100: Leaving Lock_Row', 2);
2154: END IF;
2155:
2156: RETURN( l_return_status );
2157:

Line 2169: Okc_Debug.Log('4200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);

2165: CLOSE lchk_csr;
2166: END IF;
2167:
2168: IF (l_debug = 'Y') THEN
2169: Okc_Debug.Log('4200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
2170: END IF;
2171:
2172: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2173: p_msg_name => G_UNEXPECTED_ERROR,

Line 2192: Okc_Debug.Log('4300: Entered Lock_Row', 2);

2188: ) IS
2189: BEGIN
2190:
2191: IF (l_debug = 'Y') THEN
2192: Okc_Debug.Log('4300: Entered Lock_Row', 2);
2193: END IF;
2194:
2195: --------------------------------------------
2196: -- Call the LOCK_ROW for each child record

Line 2209: Okc_Debug.Log('4400: Leaving Lock_Row', 2);

2205: RAISE OKC_API.G_EXCEPTION_ERROR;
2206: END IF;
2207:
2208: IF (l_debug = 'Y') THEN
2209: Okc_Debug.Log('4400: Leaving Lock_Row', 2);
2210: END IF;
2211:
2212: EXCEPTION
2213: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2216: Okc_Debug.Log('4500: Leaving Lock_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

2212: EXCEPTION
2213: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2214:
2215: IF (l_debug = 'Y') THEN
2216: Okc_Debug.Log('4500: Leaving Lock_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2217: END IF;
2218:
2219: x_return_status := G_RET_STS_ERROR;
2220: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2223: Okc_Debug.Log('4600: Leaving Lock_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2219: x_return_status := G_RET_STS_ERROR;
2220: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2221:
2222: IF (l_debug = 'Y') THEN
2223: Okc_Debug.Log('4600: Leaving Lock_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2224: END IF;
2225:
2226: x_return_status := G_RET_STS_UNEXP_ERROR;
2227: WHEN OTHERS THEN

Line 2230: Okc_Debug.Log('4700: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);

2226: x_return_status := G_RET_STS_UNEXP_ERROR;
2227: WHEN OTHERS THEN
2228:
2229: IF (l_debug = 'Y') THEN
2230: Okc_Debug.Log('4700: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
2231: END IF;
2232:
2233: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2234: p_msg_name => G_UNEXPECTED_ERROR,

Line 2303: Okc_Debug.Log('4800: Entered Update_Row', 2);

2299:
2300: BEGIN
2301:
2302: IF (l_debug = 'Y') THEN
2303: Okc_Debug.Log('4800: Entered Update_Row', 2);
2304: END IF;
2305: IF p_document_type IN ('OKC_SELL','OKC_BUY','OKO','OKS','OKE_SELL','OKE_BUY','OKL') THEN
2306: l_chr_id := okc_terms_util_pvt.get_chr_id_for_doc_id(p_document_id);
2307: END IF;

Line 2358: Okc_Debug.Log('4900: Leaving Update_Row', 2);

2354: LAST_AMENDMENT_DATE = p_last_amendment_date
2355: WHERE ID = p_id;
2356:
2357: IF (l_debug = 'Y') THEN
2358: Okc_Debug.Log('4900: Leaving Update_Row', 2);
2359: END IF;
2360:
2361: RETURN G_RET_STS_SUCCESS ;
2362:

Line 2367: Okc_Debug.Log('5000: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);

2363: EXCEPTION
2364: WHEN OTHERS THEN
2365:
2366: IF (l_debug = 'Y') THEN
2367: Okc_Debug.Log('5000: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
2368: END IF;
2369:
2370: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2371: p_msg_name => G_UNEXPECTED_ERROR,

Line 2479: Okc_Debug.Log('5100: Entered Update_Row', 2);

2475:
2476: BEGIN
2477:
2478: IF (l_debug = 'Y') THEN
2479: Okc_Debug.Log('5100: Entered Update_Row', 2);
2480: Okc_Debug.Log('5200: Locking row', 2);
2481: END IF;
2482:
2483: x_return_status := Lock_row(

Line 2480: Okc_Debug.Log('5200: Locking row', 2);

2476: BEGIN
2477:
2478: IF (l_debug = 'Y') THEN
2479: Okc_Debug.Log('5100: Entered Update_Row', 2);
2480: Okc_Debug.Log('5200: Locking row', 2);
2481: END IF;
2482:
2483: x_return_status := Lock_row(
2484: p_id => p_id,

Line 2494: Okc_Debug.Log('5300: Setting attributes', 2);

2490: RAISE OKC_API.G_EXCEPTION_ERROR;
2491: END IF;
2492:
2493: IF (l_debug = 'Y') THEN
2494: Okc_Debug.Log('5300: Setting attributes', 2);
2495: END IF;
2496:
2497: x_return_status := Set_Attributes(
2498: p_id => p_id,

Line 2588: Okc_Debug.Log('5400: Record Validation', 2);

2584: RAISE OKC_API.G_EXCEPTION_ERROR;
2585: END IF;
2586:
2587: IF (l_debug = 'Y') THEN
2588: Okc_Debug.Log('5400: Record Validation', 2);
2589: END IF;
2590:
2591: --- Validate all non-missing attributes
2592: x_return_status := Validate_Record(

Line 2641: Okc_Debug.Log('5500: Filling WHO columns', 2);

2637: RAISE OKC_API.G_EXCEPTION_ERROR;
2638: END IF;
2639:
2640: IF (l_debug = 'Y') THEN
2641: Okc_Debug.Log('5500: Filling WHO columns', 2);
2642: END IF;
2643:
2644: -- Filling who columns
2645: l_last_update_date := SYSDATE;

Line 2655: Okc_Debug.Log('5600: Updating Row', 2);

2651: l_object_version_number := Nvl(l_object_version_number, 0) + 1;
2652: END IF;
2653:
2654: IF (l_debug = 'Y') THEN
2655: Okc_Debug.Log('5600: Updating Row', 2);
2656: END IF;
2657:
2658: --------------------------------------------
2659: -- Call the Update_Row for each child record

Line 2716: Okc_Debug.Log('5700: Leaving Update_Row', 2);

2712: RAISE OKC_API.G_EXCEPTION_ERROR;
2713: END IF;
2714:
2715: IF (l_debug = 'Y') THEN
2716: Okc_Debug.Log('5700: Leaving Update_Row', 2);
2717: END IF;
2718:
2719: EXCEPTION
2720: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2723: Okc_Debug.Log('5800: Leaving Update_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

2719: EXCEPTION
2720: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2721:
2722: IF (l_debug = 'Y') THEN
2723: Okc_Debug.Log('5800: Leaving Update_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2724: END IF;
2725:
2726: x_return_status := G_RET_STS_ERROR;
2727: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2730: Okc_Debug.Log('5900: Leaving Update_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2726: x_return_status := G_RET_STS_ERROR;
2727: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2728:
2729: IF (l_debug = 'Y') THEN
2730: Okc_Debug.Log('5900: Leaving Update_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2731: END IF;
2732:
2733: x_return_status := G_RET_STS_UNEXP_ERROR;
2734: WHEN OTHERS THEN

Line 2737: Okc_Debug.Log('6000: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);

2733: x_return_status := G_RET_STS_UNEXP_ERROR;
2734: WHEN OTHERS THEN
2735:
2736: IF (l_debug = 'Y') THEN
2737: Okc_Debug.Log('6000: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
2738: END IF;
2739:
2740: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2741: p_msg_name => G_UNEXPECTED_ERROR,

Line 2764: Okc_Debug.Log('6100: Entered Delete_Row', 2);

2760:
2761: BEGIN
2762:
2763: IF (l_debug = 'Y') THEN
2764: Okc_Debug.Log('6100: Entered Delete_Row', 2);
2765: END IF;
2766:
2767: DELETE FROM OKC_K_ARTICLES_B WHERE ID = p_ID;
2768:

Line 2770: Okc_Debug.Log('6200: Leaving Delete_Row', 2);

2766:
2767: DELETE FROM OKC_K_ARTICLES_B WHERE ID = p_ID;
2768:
2769: IF (l_debug = 'Y') THEN
2770: Okc_Debug.Log('6200: Leaving Delete_Row', 2);
2771: END IF;
2772:
2773: RETURN( G_RET_STS_SUCCESS );
2774:

Line 2779: Okc_Debug.Log('6300: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);

2775: EXCEPTION
2776: WHEN OTHERS THEN
2777:
2778: IF (l_debug = 'Y') THEN
2779: Okc_Debug.Log('6300: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
2780: END IF;
2781:
2782: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2783: p_msg_name => G_UNEXPECTED_ERROR,

Line 2830: Okc_Debug.Log('6400: Entered Delete_Row', 2);

2826:
2827: BEGIN
2828:
2829: IF (l_debug = 'Y') THEN
2830: Okc_Debug.Log('6400: Entered Delete_Row', 2);
2831: END IF;
2832:
2833: OPEN l_art_csr(p_id);
2834: FETCH l_art_csr INTO l_standard_yn,l_article_id,l_article_version_id;

Line 2882: Okc_Debug.Log('6500: Leaving Delete_Row', 2);

2878:
2879: END IF;
2880:
2881: IF (l_debug = 'Y') THEN
2882: Okc_Debug.Log('6500: Leaving Delete_Row', 2);
2883: END IF;
2884:
2885: EXCEPTION
2886: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2889: Okc_Debug.Log('6600: Leaving Delete_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

2885: EXCEPTION
2886: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2887:
2888: IF (l_debug = 'Y') THEN
2889: Okc_Debug.Log('6600: Leaving Delete_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2890: END IF;
2891:
2892: x_return_status := G_RET_STS_ERROR;
2893:

Line 2897: Okc_Debug.Log('6700: Leaving Delete_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2893:
2894: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2895:
2896: IF (l_debug = 'Y') THEN
2897: Okc_Debug.Log('6700: Leaving Delete_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2898: END IF;
2899:
2900: x_return_status := G_RET_STS_UNEXP_ERROR;
2901:

Line 2905: Okc_Debug.Log('6800: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);

2901:
2902: WHEN OTHERS THEN
2903:
2904: IF (l_debug = 'Y') THEN
2905: Okc_Debug.Log('6800: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
2906: END IF;
2907:
2908: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2909: p_msg_name => G_UNEXPECTED_ERROR,

Line 2930: Okc_Debug.Log('9700: Entered Delete_Set', 2);

2926: WHERE SCN_ID=P_SCN_ID
2927: FOR UPDATE NOWAIT;
2928: BEGIN
2929: IF (l_debug = 'Y') THEN
2930: Okc_Debug.Log('9700: Entered Delete_Set', 2);
2931: Okc_Debug.Log('9710: Locking Record', 2);
2932: END IF;
2933: -- making OPEN/CLOSE cursor to lock records
2934: OPEN lock_csr;

Line 2931: Okc_Debug.Log('9710: Locking Record', 2);

2927: FOR UPDATE NOWAIT;
2928: BEGIN
2929: IF (l_debug = 'Y') THEN
2930: Okc_Debug.Log('9700: Entered Delete_Set', 2);
2931: Okc_Debug.Log('9710: Locking Record', 2);
2932: END IF;
2933: -- making OPEN/CLOSE cursor to lock records
2934: OPEN lock_csr;
2935: CLOSE lock_csr;

Line 2941: Okc_Debug.Log('11000: Leaving Delete_set', 2);

2937: DELETE FROM OKC_K_ARTICLES_B
2938: WHERE SCN_ID=P_SCN_ID;
2939:
2940: IF (l_debug = 'Y') THEN
2941: Okc_Debug.Log('11000: Leaving Delete_set', 2);
2942: END IF;
2943:
2944: EXCEPTION
2945: WHEN E_Resource_Busy THEN

Line 2947: Okc_Debug.Log('000: Leaving Delete_set:E_Resource_Busy Exception', 2);

2943:
2944: EXCEPTION
2945: WHEN E_Resource_Busy THEN
2946: IF (l_debug = 'Y') THEN
2947: Okc_Debug.Log('000: Leaving Delete_set:E_Resource_Busy Exception', 2);
2948: END IF;
2949:
2950: IF (lock_csr%ISOPEN) THEN
2951: CLOSE lock_csr;

Line 2958: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);

2954: x_return_status := G_RET_STS_ERROR ;
2955:
2956: WHEN FND_API.G_EXC_ERROR THEN
2957: IF (l_debug = 'Y') THEN
2958: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
2959: END IF;
2960:
2961: IF (lock_csr%ISOPEN) THEN
2962: CLOSE lock_csr;

Line 2968: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

2964: x_return_status := G_RET_STS_ERROR;
2965:
2966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2967: IF (l_debug = 'Y') THEN
2968: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2969: END IF;
2970:
2971: IF (lock_csr%ISOPEN) THEN
2972: CLOSE lock_csr;

Line 2978: Okc_Debug.Log('11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm, 2);

2974: x_return_status := G_RET_STS_UNEXP_ERROR;
2975:
2976: WHEN OTHERS THEN
2977: IF (l_debug = 'Y') THEN
2978: Okc_Debug.Log('11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm, 2);
2979: END IF;
2980:
2981: IF (lock_csr%ISOPEN) THEN
2982: CLOSE lock_csr;

Line 3013: Okc_Debug.Log('9700: Entered Delete_Set', 2);

3009: FOR UPDATE NOWAIT;
3010:
3011: BEGIN
3012: IF (l_debug = 'Y') THEN
3013: Okc_Debug.Log('9700: Entered Delete_Set', 2);
3014: Okc_Debug.Log('9710: Locking Records', 2);
3015: END IF;
3016:
3017:

Line 3014: Okc_Debug.Log('9710: Locking Records', 2);

3010:
3011: BEGIN
3012: IF (l_debug = 'Y') THEN
3013: Okc_Debug.Log('9700: Entered Delete_Set', 2);
3014: Okc_Debug.Log('9710: Locking Records', 2);
3015: END IF;
3016:
3017:
3018: -- making OPEN/CLOSE cursor to lock records

Line 3032: Okc_Debug.Log('11000: Leaving Delete_set', 2);

3028: );
3029:
3030:
3031: IF (l_debug = 'Y') THEN
3032: Okc_Debug.Log('11000: Leaving Delete_set', 2);
3033: END IF;
3034:
3035: EXCEPTION
3036: WHEN E_Resource_Busy THEN

Line 3038: Okc_Debug.Log('000: Leaving Delete_set:E_Resource_Busy Exception', 2);

3034:
3035: EXCEPTION
3036: WHEN E_Resource_Busy THEN
3037: IF (l_debug = 'Y') THEN
3038: Okc_Debug.Log('000: Leaving Delete_set:E_Resource_Busy Exception', 2);
3039: END IF;
3040:
3041: IF (lock_csr%ISOPEN) THEN
3042: CLOSE lock_csr;

Line 3049: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);

3045: x_return_status := G_RET_STS_ERROR ;
3046:
3047: WHEN FND_API.G_EXC_ERROR THEN
3048: IF (l_debug = 'Y') THEN
3049: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
3050: END IF;
3051:
3052: IF (lock_csr%ISOPEN) THEN
3053: CLOSE lock_csr;

Line 3059: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

3055: x_return_status := G_RET_STS_ERROR;
3056:
3057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3058: IF (l_debug = 'Y') THEN
3059: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3060: END IF;
3061:
3062: IF (lock_csr%ISOPEN) THEN
3063: CLOSE lock_csr;

Line 3069: Okc_Debug.Log('11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm, 2);

3065: x_return_status := G_RET_STS_UNEXP_ERROR;
3066:
3067: WHEN OTHERS THEN
3068: IF (l_debug = 'Y') THEN
3069: Okc_Debug.Log('11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm, 2);
3070: END IF;
3071:
3072: IF (lock_csr%ISOPEN) THEN
3073: CLOSE lock_csr;

Line 3114: Okc_Debug.Log('6900: Entered create_version', 2);

3110:
3111: BEGIN
3112:
3113: IF (l_debug = 'Y') THEN
3114: Okc_Debug.Log('6900: Entered create_version', 2);
3115: END IF;
3116:
3117: -----------------------------------------
3118: -- Saving Base Table

Line 3237: Okc_Debug.Log('6910: Before Opening Non_std_csr', 2);

3233: WHERE document_type = p_doc_type
3234: AND document_id = p_doc_id;
3235:
3236: IF (l_debug = 'Y') THEN
3237: Okc_Debug.Log('6910: Before Opening Non_std_csr', 2);
3238: END IF;
3239:
3240: FOR rec in non_std_csr LOOP
3241:

Line 3243: Okc_Debug.Log('6920: Before calling OKC_ARTICLES_GRP.copy_article()', 2);

3239:
3240: FOR rec in non_std_csr LOOP
3241:
3242: IF (l_debug = 'Y') THEN
3243: Okc_Debug.Log('6920: Before calling OKC_ARTICLES_GRP.copy_article()', 2);
3244: END IF;
3245: OKC_ARTICLES_GRP.copy_article( p_api_version => 1,
3246: p_init_msg_list => FND_API.G_FALSE,
3247: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3266: Okc_Debug.Log('6920: Before updating new Non-Std in the OKC_K_ARTICLES_B', 2);

3262: RAISE FND_API.G_EXC_ERROR;
3263: END IF;
3264:
3265: IF (l_debug = 'Y') THEN
3266: Okc_Debug.Log('6920: Before updating new Non-Std in the OKC_K_ARTICLES_B', 2);
3267: END IF;
3268:
3269:
3270: -----------------------------------------

Line 3279: Okc_Debug.Log('6930: After Updating Non-Std in OKC_K_ARTICLES_B', 2);

3275: ARTICLE_VERSION_ID = l_article_version_id
3276: WHERE ID = rec.id;
3277:
3278: IF (l_debug = 'Y') THEN
3279: Okc_Debug.Log('6930: After Updating Non-Std in OKC_K_ARTICLES_B', 2);
3280: END IF;
3281:
3282: END LOOP;
3283:

Line 3285: Okc_Debug.Log('7000: Leaving create_version', 2);

3281:
3282: END LOOP;
3283:
3284: IF (l_debug = 'Y') THEN
3285: Okc_Debug.Log('7000: Leaving create_version', 2);
3286: END IF;
3287:
3288: RETURN( G_RET_STS_SUCCESS );
3289:

Line 3294: Okc_Debug.Log('7100: Leaving Create_Version:FND_API.G_EXC_ERROR Exception', 2);

3290: EXCEPTION
3291:
3292: WHEN FND_API.G_EXC_ERROR THEN
3293: IF (l_debug = 'Y') THEN
3294: Okc_Debug.Log('7100: Leaving Create_Version:FND_API.G_EXC_ERROR Exception', 2);
3295: END IF;
3296:
3297: IF (non_std_csr%ISOPEN) THEN
3298: CLOSE non_std_csr;

Line 3304: Okc_Debug.Log('7200: Leaving Create_Version:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

3300: RETURN G_RET_STS_ERROR;
3301:
3302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3303: IF (l_debug = 'Y') THEN
3304: Okc_Debug.Log('7200: Leaving Create_Version:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3305: END IF;
3306:
3307: IF (non_std_csr%ISOPEN) THEN
3308: CLOSE non_std_csr;

Line 3315: Okc_Debug.Log('7300: Leaving create_version because of EXCEPTION: '||sqlerrm, 2);

3311:
3312: WHEN OTHERS THEN
3313:
3314: IF (l_debug = 'Y') THEN
3315: Okc_Debug.Log('7300: Leaving create_version because of EXCEPTION: '||sqlerrm, 2);
3316: END IF;
3317:
3318: IF (non_std_csr%ISOPEN) THEN
3319: CLOSE non_std_csr;

Line 3345: Okc_Debug.Log('7200: Entered restore_version', 2);

3341:
3342: BEGIN
3343:
3344: IF (l_debug = 'Y') THEN
3345: Okc_Debug.Log('7200: Entered restore_version', 2);
3346: END IF;
3347:
3348: -----------------------------------------
3349: -- Restoring Base Table

Line 3467: Okc_Debug.Log('7300: Leaving restore_version', 2);

3463: AND document_id = p_doc_id
3464: AND major_version = p_major_version;
3465:
3466: IF (l_debug = 'Y') THEN
3467: Okc_Debug.Log('7300: Leaving restore_version', 2);
3468: END IF;
3469:
3470: RETURN( G_RET_STS_SUCCESS );
3471:

Line 3476: Okc_Debug.Log('7400: Leaving restore_version because of EXCEPTION: '||sqlerrm, 2);

3472: EXCEPTION
3473: WHEN OTHERS THEN
3474:
3475: IF (l_debug = 'Y') THEN
3476: Okc_Debug.Log('7400: Leaving restore_version because of EXCEPTION: '||sqlerrm, 2);
3477: END IF;
3478:
3479: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3480: p_msg_name => G_UNEXPECTED_ERROR,

Line 3502: Okc_Debug.Log('7200: Entered Delete_Version', 2);

3498:
3499: BEGIN
3500:
3501: IF (l_debug = 'Y') THEN
3502: Okc_Debug.Log('7200: Entered Delete_Version', 2);
3503: END IF;
3504:
3505: -----------------------------------------
3506: -- Restoring Base Table

Line 3515: Okc_Debug.Log('7300: Leaving Delete_Version', 2);

3511: AND document_id = p_doc_id
3512: AND major_version = p_major_version;
3513:
3514: IF (l_debug = 'Y') THEN
3515: Okc_Debug.Log('7300: Leaving Delete_Version', 2);
3516: END IF;
3517:
3518: RETURN( G_RET_STS_SUCCESS );
3519:

Line 3524: Okc_Debug.Log('7400: Leaving Delete_Version because of EXCEPTION: '||sqlerrm, 2);

3520: EXCEPTION
3521: WHEN OTHERS THEN
3522:
3523: IF (l_debug = 'Y') THEN
3524: Okc_Debug.Log('7400: Leaving Delete_Version because of EXCEPTION: '||sqlerrm, 2);
3525: END IF;
3526:
3527: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3528: p_msg_name => G_UNEXPECTED_ERROR,