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 256: Okc_Debug.Log('400: Entered get_rec', 2);

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

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

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

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

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

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

380: CLOSE OKC_K_ARTICLES_BH_pk_csr;
381: END IF;
382:
383: IF (l_debug = 'Y') THEN
384: Okc_Debug.Log('500: Leaving get_rec ', 2);
385: END IF;
386:
387: RETURN G_RET_STS_SUCCESS ;
388:

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

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

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

411:
412: WHEN OTHERS THEN
413:
414: IF (l_debug = 'Y') THEN
415: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);
416: END IF;
417:
418: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
419: p_msg_name => G_UNEXPECTED_ERROR,

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

897:
898: BEGIN
899:
900: IF (l_debug = 'Y') THEN
901: Okc_Debug.Log('700: Entered Validate_Attributes', 2);
902: END IF;
903:
904: IF p_validation_level > G_REQUIRED_VALUE_VALID_LVL THEN
905: IF (l_debug = 'Y') THEN

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

902: END IF;
903:
904: IF p_validation_level > G_REQUIRED_VALUE_VALID_LVL THEN
905: IF (l_debug = 'Y') THEN
906: Okc_Debug.Log('800: required values validation', 2);
907: END IF;
908:
909: IF (l_debug = 'Y') THEN
910: Okc_Debug.Log('900: - attribute ID ', 2);

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

906: Okc_Debug.Log('800: required values validation', 2);
907: END IF;
908:
909: IF (l_debug = 'Y') THEN
910: Okc_Debug.Log('900: - attribute ID ', 2);
911: END IF;
912: IF ( p_id IS NULL) THEN
913: IF (l_debug = 'Y') THEN
914: Okc_Debug.Log('1000: - attribute ID is invalid', 2);

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

910: Okc_Debug.Log('900: - attribute ID ', 2);
911: END IF;
912: IF ( p_id IS NULL) THEN
913: IF (l_debug = 'Y') THEN
914: Okc_Debug.Log('1000: - attribute ID is invalid', 2);
915: END IF;
916: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ID');
917: l_return_status := G_RET_STS_ERROR;
918: END IF;

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

917: l_return_status := G_RET_STS_ERROR;
918: END IF;
919:
920: IF (l_debug = 'Y') THEN
921: Okc_Debug.Log('1400: - attribute DOCUMENT_TYPE ', 2);
922: END IF;
923: IF ( p_document_type IS NULL) THEN
924: IF (l_debug = 'Y') THEN
925: Okc_Debug.Log('1500: - attribute DOCUMENT_TYPE is invalid', 2);

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

921: Okc_Debug.Log('1400: - attribute DOCUMENT_TYPE ', 2);
922: END IF;
923: IF ( p_document_type IS NULL) THEN
924: IF (l_debug = 'Y') THEN
925: Okc_Debug.Log('1500: - attribute DOCUMENT_TYPE is invalid', 2);
926: END IF;
927: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DOCUMENT_TYPE');
928: l_return_status := G_RET_STS_ERROR;
929: END IF;

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

928: l_return_status := G_RET_STS_ERROR;
929: END IF;
930:
931: IF (l_debug = 'Y') THEN
932: Okc_Debug.Log('1400: - attribute DOCUMENT_ID ', 2);
933: END IF;
934: IF ( p_document_id IS NULL) THEN
935: IF (l_debug = 'Y') THEN
936: Okc_Debug.Log('1500: - attribute DOCUMENT_ID is invalid', 2);

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

932: Okc_Debug.Log('1400: - attribute DOCUMENT_ID ', 2);
933: END IF;
934: IF ( p_document_id IS NULL) THEN
935: IF (l_debug = 'Y') THEN
936: Okc_Debug.Log('1500: - attribute DOCUMENT_ID is invalid', 2);
937: END IF;
938: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DOCUMENT_ID');
939: l_return_status := G_RET_STS_ERROR;
940: END IF;

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

939: l_return_status := G_RET_STS_ERROR;
940: END IF;
941:
942: IF (l_debug = 'Y') THEN
943: Okc_Debug.Log('1400: - attribute SCN_ID ', 2);
944: END IF;
945: IF ( p_scn_id IS NULL) THEN
946: IF (l_debug = 'Y') THEN
947: Okc_Debug.Log('1500: - attribute SCN_ID is invalid', 2);

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

943: Okc_Debug.Log('1400: - attribute SCN_ID ', 2);
944: END IF;
945: IF ( p_scn_id IS NULL) THEN
946: IF (l_debug = 'Y') THEN
947: Okc_Debug.Log('1500: - attribute SCN_ID is invalid', 2);
948: END IF;
949: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'SCN_ID');
950: l_return_status := G_RET_STS_ERROR;
951: END IF;

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

950: l_return_status := G_RET_STS_ERROR;
951: END IF;
952:
953: IF (l_debug = 'Y') THEN
954: Okc_Debug.Log('1400: - attribute DISPLAY_SEQUENCE ', 2);
955: END IF;
956: IF ( p_display_sequence IS NULL) THEN
957: IF (l_debug = 'Y') THEN
958: Okc_Debug.Log('1500: - attribute DISPLAY_SEQUENCE is invalid', 2);

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

954: Okc_Debug.Log('1400: - attribute DISPLAY_SEQUENCE ', 2);
955: END IF;
956: IF ( p_display_sequence IS NULL) THEN
957: IF (l_debug = 'Y') THEN
958: Okc_Debug.Log('1500: - attribute DISPLAY_SEQUENCE is invalid', 2);
959: END IF;
960: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DISPLAY_SEQUENCE');
961: l_return_status := G_RET_STS_ERROR;
962: END IF;

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

961: l_return_status := G_RET_STS_ERROR;
962: END IF;
963:
964: IF (l_debug = 'Y') THEN
965: Okc_Debug.Log('1400: - attribute SAV_SAE_ID', 2);
966: END IF;
967: IF ( p_sav_sae_id IS NULL) THEN
968: IF (l_debug = 'Y') THEN
969: Okc_Debug.Log('1500: - attribute SAV_SAE_ID is invalid', 2);

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

965: Okc_Debug.Log('1400: - attribute SAV_SAE_ID', 2);
966: END IF;
967: IF ( p_sav_sae_id IS NULL) THEN
968: IF (l_debug = 'Y') THEN
969: Okc_Debug.Log('1500: - attribute SAV_SAE_ID is invalid', 2);
970: END IF;
971: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'SAV_SAE_ID');
972: l_return_status := G_RET_STS_ERROR;
973: END IF;

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

974: END IF;
975:
976: IF p_validation_level > G_VALID_VALUE_VALID_LVL THEN
977: IF (l_debug = 'Y') THEN
978: Okc_Debug.Log('1100: static values and range validation', 2);
979: END IF;
980:
981:
982: IF (l_debug = 'Y') THEN

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

979: END IF;
980:
981:
982: IF (l_debug = 'Y') THEN
983: Okc_Debug.Log('1200: - attribute MANDATORY_YN ', 2);
984: END IF;
985:
986: IF ( p_mandatory_yn NOT IN ('Y','N') AND p_mandatory_yn IS NOT NULL) THEN
987: IF (l_debug = 'Y') THEN

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

984: END IF;
985:
986: IF ( p_mandatory_yn NOT IN ('Y','N') AND p_mandatory_yn IS NOT NULL) THEN
987: IF (l_debug = 'Y') THEN
988: Okc_Debug.Log('1300: - attribute MANDATORY_YN is invalid', 2);
989: END IF;
990: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'MANDATORY_YN');
991: l_return_status := G_RET_STS_ERROR;
992: END IF;

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

991: l_return_status := G_RET_STS_ERROR;
992: END IF;
993:
994: IF (l_debug = 'Y') THEN
995: Okc_Debug.Log('1200: - attribute PRINT_TEXT_YN ', 2);
996: END IF;
997:
998: IF ( p_print_text_yn NOT IN ('Y','N') AND p_print_text_yn IS NOT NULL) THEN
999: IF (l_debug = 'Y') THEN

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

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

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

1003: l_return_status := G_RET_STS_ERROR;
1004: END IF;
1005:
1006: IF (l_debug = 'Y') THEN
1007: Okc_Debug.Log('1200: - attribute CHANGE_NONSTD_YN ', 2);
1008: END IF;
1009: IF ( p_change_nonstd_yn NOT IN ('Y','N') AND p_change_nonstd_yn IS NOT NULL) THEN
1010: IF (l_debug = 'Y') THEN
1011: Okc_Debug.Log('1300: - attribute CHANGE_NONSTD_YN is invalid', 2);

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

1007: Okc_Debug.Log('1200: - attribute CHANGE_NONSTD_YN ', 2);
1008: END IF;
1009: IF ( p_change_nonstd_yn NOT IN ('Y','N') AND p_change_nonstd_yn IS NOT NULL) THEN
1010: IF (l_debug = 'Y') THEN
1011: Okc_Debug.Log('1300: - attribute CHANGE_NONSTD_YN is invalid', 2);
1012: END IF;
1013: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'CHANGE_NONSTD_YN');
1014: l_return_status := G_RET_STS_ERROR;
1015: END IF;

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

1017: END IF;
1018:
1019: IF p_validation_level > G_LOOKUP_CODE_VALID_LVL THEN
1020: IF (l_debug = 'Y') THEN
1021: Okc_Debug.Log('1400: lookup codes validation', 2);
1022: END IF;
1023:
1024: IF p_amendment_operation_code is not null THEN
1025: IF (l_debug = 'Y') THEN

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

1022: END IF;
1023:
1024: IF p_amendment_operation_code is not null THEN
1025: IF (l_debug = 'Y') THEN
1026: Okc_Debug.Log('1500: - attribute AMENDMENT_OPERATION_CODE ', 2);
1027: END IF;
1028:
1029: l_return_status := Okc_Util.Check_Lookup_Code('OKC_AMEND_OPN_CODE',p_amendment_operation_code);
1030:

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

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

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

1065: END IF;
1066:
1067: IF p_validation_level > G_FOREIGN_KEY_VALID_LVL THEN
1068: IF (l_debug = 'Y') THEN
1069: Okc_Debug.Log('1600: foreigh keys validation ', 2);
1070: END IF;
1071:
1072: IF p_document_type IS NOT NULL THEN
1073: l_dummy_var := '?';

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

1075: FETCH l_doc_type_csr INTO l_dummy_var;
1076: CLOSE l_doc_type_csr;
1077: IF (l_dummy_var = '?') THEN
1078: IF (l_debug = 'Y') THEN
1079: Okc_Debug.Log('2300: - attribute DOCUMENT_TYPE is invalid', 2);
1080: END IF;
1081: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DOCUMENT_TYPE');
1082: l_return_status := G_RET_STS_ERROR;
1083: END IF;

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

1083: END IF;
1084: END IF;
1085:
1086: IF (l_debug = 'Y') THEN
1087: Okc_Debug.Log('1700: - attribute SAV_SAE_ID ', 2);
1088: END IF;
1089: IF p_sav_sae_id IS NOT NULL THEN
1090: l_dummy_var := '?';
1091: OPEN lc_sav_sae_id;

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

1092: FETCH lc_sav_sae_id INTO l_dummy_var;
1093: CLOSE lc_sav_sae_id;
1094: IF (l_dummy_var = '?') THEN
1095: IF (l_debug = 'Y') THEN
1096: Okc_Debug.Log('1800: - attribute SAV_SAE_ID is invalid', 2);
1097: END IF;
1098: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SAV_SAE_ID');
1099: l_return_status := G_RET_STS_ERROR;
1100: END IF;

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

1101: END IF;
1102:
1103:
1104: IF (l_debug = 'Y') THEN
1105: Okc_Debug.Log('1700: - attribute SCN_ID ', 2);
1106: END IF;
1107: IF p_scn_id IS NOT NULL THEN
1108: l_dummy_var := '?';
1109: OPEN lc_scn_id;

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

1110: FETCH lc_scn_id INTO l_dummy_var;
1111: CLOSE lc_scn_id;
1112: IF (l_dummy_var = '?') THEN
1113: IF (l_debug = 'Y') THEN
1114: Okc_Debug.Log('1800: - attribute SCN_ID is invalid', 2);
1115: END IF;
1116: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SCN_ID');
1117: l_return_status := G_RET_STS_ERROR;
1118: END IF;

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

1118: END IF;
1119: END IF;
1120:
1121: IF (l_debug = 'Y') THEN
1122: Okc_Debug.Log('1700: - attribute ARTICLE_VERSION_ID ', 2);
1123: END IF;
1124: IF p_article_version_id IS NOT NULL THEN
1125: l_dummy_var := '?';
1126: OPEN lc_article_version_id;

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

1127: FETCH lc_article_version_id INTO l_dummy_var;
1128: CLOSE lc_article_version_id;
1129: IF (l_dummy_var = '?') THEN
1130: IF (l_debug = 'Y') THEN
1131: Okc_Debug.Log('1800: - attribute ARTICLE_VERSION_ID is invalid', 2);
1132: END IF;
1133: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ARTICLE_VERSION_ID');
1134: l_return_status := G_RET_STS_ERROR;
1135: END IF;

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

1138: END IF;
1139:
1140:
1141: IF (l_debug = 'Y') THEN
1142: Okc_Debug.Log('1900: Leaving Validate_Attributes ', 2);
1143: END IF;
1144:
1145: RETURN l_return_status;
1146:

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

1145: RETURN l_return_status;
1146:
1147: EXCEPTION
1148: WHEN OTHERS THEN
1149: Okc_Debug.Log('2000: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
1150: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1151: p_msg_name => G_UNEXPECTED_ERROR,
1152: p_token1 => G_SQLCODE_TOKEN,
1153: p_token1_value => sqlcode,

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

1240:
1241: BEGIN
1242:
1243: IF (l_debug = 'Y') THEN
1244: Okc_Debug.Log('2100: Entered Validate_Record', 2);
1245: END IF;
1246:
1247: --- Validate all non-missing attributes (Item Level Validation)
1248: l_return_status := Validate_Attributes(

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

1288: );
1289:
1290: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1291: IF (l_debug = 'Y') THEN
1292: Okc_Debug.Log('2200: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm, 2);
1293: END IF;
1294: RETURN G_RET_STS_UNEXP_ERROR;
1295: END IF;
1296:

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

1296:
1297: --- Record Level Validation
1298: IF p_validation_level > G_RECORD_VALID_LVL THEN
1299: IF (l_debug = 'Y') THEN
1300: Okc_Debug.Log('2300: Entered Record Level Validations', 2);
1301: END IF;
1302:
1303: -- this validation is not required for templates
1304: IF p_sav_sae_id IS NOT NULL AND p_article_version_id IS NOT NULL

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

1310: CLOSE L_validate_article_csr;
1311: If l_dummy_var='?' THEN
1312:
1313: IF (l_debug = 'Y') THEN
1314: Okc_Debug.Log('1500: - Wrong Combination of Article_version_id and sav_sae_id', 2);
1315: END IF;
1316: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_VERSION_ID');
1317: l_return_status := G_RET_STS_ERROR;
1318: END IF;

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

1319: END IF;
1320: END IF;
1321:
1322: IF (l_debug = 'Y') THEN
1323: Okc_Debug.Log('2400: Leaving Validate_Record : '||sqlerrm, 2);
1324: END IF;
1325: RETURN l_return_status ;
1326:
1327: EXCEPTION

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

1327: EXCEPTION
1328: WHEN OTHERS THEN
1329:
1330: IF (l_debug = 'Y') THEN
1331: Okc_Debug.Log('2500: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
1332: END IF;
1333:
1334: IF l_validate_article_csr%ISOPEN THEN
1335: CLOSE l_validate_article_csr;

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

1439: l_last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE;
1440: BEGIN
1441:
1442: IF (l_debug = 'Y') THEN
1443: Okc_Debug.Log('2600: Entered validate_row', 2);
1444: END IF;
1445:
1446: -- Setting attributes
1447: x_return_status := Set_Attributes(

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

1573: p_ref_article_version_id => l_ref_article_version_id
1574: );
1575:
1576: IF (l_debug = 'Y') THEN
1577: Okc_Debug.Log('2700: Leaving validate_row', 2);
1578: END IF;
1579:
1580: EXCEPTION
1581: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1580: EXCEPTION
1581: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1582:
1583: IF (l_debug = 'Y') THEN
1584: Okc_Debug.Log('2800: Leaving Validate_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1585: END IF;
1586:
1587: x_return_status := G_RET_STS_ERROR;
1588:

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

1588:
1589: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1590:
1591: IF (l_debug = 'Y') THEN
1592: Okc_Debug.Log('2900: Leaving Validate_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1593: END IF;
1594:
1595: x_return_status := G_RET_STS_UNEXP_ERROR;
1596: WHEN OTHERS THEN

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

1595: x_return_status := G_RET_STS_UNEXP_ERROR;
1596: WHEN OTHERS THEN
1597:
1598: IF (l_debug = 'Y') THEN
1599: Okc_Debug.Log('3000: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
1600: END IF;
1601:
1602: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1603: p_msg_name => G_UNEXPECTED_ERROR,

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

1668:
1669: BEGIN
1670:
1671: IF (l_debug = 'Y') THEN
1672: Okc_Debug.Log('3100: Entered Insert_Row function', 2);
1673: END IF;
1674:
1675: IF p_document_type IN ('OKC_SELL','OKC_BUY','OKO','OKS','OKE_SELL','OKE_BUY','OKL') THEN
1676: l_chr_id := okc_terms_util_pvt.get_chr_id_for_doc_id(p_document_id);

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

1785: p_last_amended_by,
1786: p_last_amendment_date);
1787:
1788: IF (l_debug = 'Y') THEN
1789: Okc_Debug.Log('3200: Leaving Insert_Row', 2);
1790: END IF;
1791:
1792: RETURN( G_RET_STS_SUCCESS );
1793:

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

1794: EXCEPTION
1795: WHEN OTHERS THEN
1796:
1797: IF (l_debug = 'Y') THEN
1798: Okc_Debug.Log('3300: Leaving Insert_Row:OTHERS Exception', 2);
1799: END IF;
1800:
1801: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1802: p_msg_name => G_UNEXPECTED_ERROR,

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

1869:
1870: x_return_status := G_RET_STS_SUCCESS;
1871:
1872: IF (l_debug = 'Y') THEN
1873: Okc_Debug.Log('3400: Entered Insert_Row', 2);
1874: END IF;
1875:
1876: --- Setting item attributes
1877: -- Set primary key value

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

2006: RAISE OKC_API.G_EXCEPTION_ERROR;
2007: END IF;
2008:
2009: IF (l_debug = 'Y') THEN
2010: Okc_Debug.Log('3500: Leaving Insert_Row', 2);
2011: END IF;
2012:
2013: EXCEPTION
2014: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2013: EXCEPTION
2014: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2015:
2016: IF (l_debug = 'Y') THEN
2017: Okc_Debug.Log('3600: Leaving Insert_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2018: END IF;
2019:
2020: x_return_status := G_RET_STS_ERROR;
2021:

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

2021:
2022: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2023:
2024: IF (l_debug = 'Y') THEN
2025: Okc_Debug.Log('3700: Leaving Insert_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2026: END IF;
2027:
2028: x_return_status := G_RET_STS_UNEXP_ERROR;
2029: WHEN OTHERS THEN

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

2028: x_return_status := G_RET_STS_UNEXP_ERROR;
2029: WHEN OTHERS THEN
2030:
2031: IF (l_debug = 'Y') THEN
2032: Okc_Debug.Log('3800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
2033: END IF;
2034:
2035: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2036: p_msg_name => G_UNEXPECTED_ERROR,

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

2072: l_row_notfound BOOLEAN := FALSE;
2073: BEGIN
2074:
2075: IF (l_debug = 'Y') THEN
2076: Okc_Debug.Log('3900: Entered Lock_Row', 2);
2077: END IF;
2078:
2079:
2080: BEGIN

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

2087: EXCEPTION
2088: WHEN E_Resource_Busy THEN
2089:
2090: IF (l_debug = 'Y') THEN
2091: Okc_Debug.Log('4000: Leaving Lock_Row:E_Resource_Busy Exception', 2);
2092: END IF;
2093:
2094: IF (lock_csr%ISOPEN) THEN
2095: CLOSE lock_csr;

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

2123: l_return_status := G_RET_STS_SUCCESS;
2124: END IF;
2125:
2126: IF (l_debug = 'Y') THEN
2127: Okc_Debug.Log('4100: Leaving Lock_Row', 2);
2128: END IF;
2129:
2130: RETURN( l_return_status );
2131:

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

2139: CLOSE lchk_csr;
2140: END IF;
2141:
2142: IF (l_debug = 'Y') THEN
2143: Okc_Debug.Log('4200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
2144: END IF;
2145:
2146: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2147: p_msg_name => G_UNEXPECTED_ERROR,

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

2162: ) IS
2163: BEGIN
2164:
2165: IF (l_debug = 'Y') THEN
2166: Okc_Debug.Log('4300: Entered Lock_Row', 2);
2167: END IF;
2168:
2169: --------------------------------------------
2170: -- Call the LOCK_ROW for each child record

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

2179: RAISE OKC_API.G_EXCEPTION_ERROR;
2180: END IF;
2181:
2182: IF (l_debug = 'Y') THEN
2183: Okc_Debug.Log('4400: Leaving Lock_Row', 2);
2184: END IF;
2185:
2186: EXCEPTION
2187: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2186: EXCEPTION
2187: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2188:
2189: IF (l_debug = 'Y') THEN
2190: Okc_Debug.Log('4500: Leaving Lock_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2191: END IF;
2192:
2193: x_return_status := G_RET_STS_ERROR;
2194: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

2193: x_return_status := G_RET_STS_ERROR;
2194: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2195:
2196: IF (l_debug = 'Y') THEN
2197: Okc_Debug.Log('4600: Leaving Lock_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2198: END IF;
2199:
2200: x_return_status := G_RET_STS_UNEXP_ERROR;
2201: WHEN OTHERS THEN

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

2200: x_return_status := G_RET_STS_UNEXP_ERROR;
2201: WHEN OTHERS THEN
2202:
2203: IF (l_debug = 'Y') THEN
2204: Okc_Debug.Log('4700: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
2205: END IF;
2206:
2207: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2208: p_msg_name => G_UNEXPECTED_ERROR,

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

2272:
2273: BEGIN
2274:
2275: IF (l_debug = 'Y') THEN
2276: Okc_Debug.Log('4800: Entered Update_Row', 2);
2277: END IF;
2278: IF p_document_type IN ('OKC_SELL','OKC_BUY','OKO','OKS','OKE_SELL','OKE_BUY','OKL') THEN
2279: l_chr_id := okc_terms_util_pvt.get_chr_id_for_doc_id(p_document_id);
2280: END IF;

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

2326: LAST_AMENDMENT_DATE = p_last_amendment_date
2327: WHERE ID = p_id;
2328:
2329: IF (l_debug = 'Y') THEN
2330: Okc_Debug.Log('4900: Leaving Update_Row', 2);
2331: END IF;
2332:
2333: RETURN G_RET_STS_SUCCESS ;
2334:

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

2335: EXCEPTION
2336: WHEN OTHERS THEN
2337:
2338: IF (l_debug = 'Y') THEN
2339: Okc_Debug.Log('5000: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
2340: END IF;
2341:
2342: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2343: p_msg_name => G_UNEXPECTED_ERROR,

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

2445:
2446: BEGIN
2447:
2448: IF (l_debug = 'Y') THEN
2449: Okc_Debug.Log('5100: Entered Update_Row', 2);
2450: Okc_Debug.Log('5200: Locking row', 2);
2451: END IF;
2452:
2453: x_return_status := Lock_row(

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

2446: BEGIN
2447:
2448: IF (l_debug = 'Y') THEN
2449: Okc_Debug.Log('5100: Entered Update_Row', 2);
2450: Okc_Debug.Log('5200: Locking row', 2);
2451: END IF;
2452:
2453: x_return_status := Lock_row(
2454: p_id => p_id,

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

2460: RAISE OKC_API.G_EXCEPTION_ERROR;
2461: END IF;
2462:
2463: IF (l_debug = 'Y') THEN
2464: Okc_Debug.Log('5300: Setting attributes', 2);
2465: END IF;
2466:
2467: x_return_status := Set_Attributes(
2468: p_id => p_id,

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

2552: RAISE OKC_API.G_EXCEPTION_ERROR;
2553: END IF;
2554:
2555: IF (l_debug = 'Y') THEN
2556: Okc_Debug.Log('5400: Record Validation', 2);
2557: END IF;
2558:
2559: --- Validate all non-missing attributes
2560: x_return_status := Validate_Record(

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

2604: RAISE OKC_API.G_EXCEPTION_ERROR;
2605: END IF;
2606:
2607: IF (l_debug = 'Y') THEN
2608: Okc_Debug.Log('5500: Filling WHO columns', 2);
2609: END IF;
2610:
2611: -- Filling who columns
2612: l_last_update_date := SYSDATE;

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

2618: l_object_version_number := Nvl(l_object_version_number, 0) + 1;
2619: END IF;
2620:
2621: IF (l_debug = 'Y') THEN
2622: Okc_Debug.Log('5600: Updating Row', 2);
2623: END IF;
2624:
2625: --------------------------------------------
2626: -- Call the Update_Row for each child record

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

2678: RAISE OKC_API.G_EXCEPTION_ERROR;
2679: END IF;
2680:
2681: IF (l_debug = 'Y') THEN
2682: Okc_Debug.Log('5700: Leaving Update_Row', 2);
2683: END IF;
2684:
2685: EXCEPTION
2686: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2685: EXCEPTION
2686: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2687:
2688: IF (l_debug = 'Y') THEN
2689: Okc_Debug.Log('5800: Leaving Update_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2690: END IF;
2691:
2692: x_return_status := G_RET_STS_ERROR;
2693: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

2692: x_return_status := G_RET_STS_ERROR;
2693: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2694:
2695: IF (l_debug = 'Y') THEN
2696: Okc_Debug.Log('5900: Leaving Update_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2697: END IF;
2698:
2699: x_return_status := G_RET_STS_UNEXP_ERROR;
2700: WHEN OTHERS THEN

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

2699: x_return_status := G_RET_STS_UNEXP_ERROR;
2700: WHEN OTHERS THEN
2701:
2702: IF (l_debug = 'Y') THEN
2703: Okc_Debug.Log('6000: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
2704: END IF;
2705:
2706: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2707: p_msg_name => G_UNEXPECTED_ERROR,

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

2726:
2727: BEGIN
2728:
2729: IF (l_debug = 'Y') THEN
2730: Okc_Debug.Log('6100: Entered Delete_Row', 2);
2731: END IF;
2732:
2733: DELETE FROM OKC_K_ARTICLES_B WHERE ID = p_ID;
2734:

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

2732:
2733: DELETE FROM OKC_K_ARTICLES_B WHERE ID = p_ID;
2734:
2735: IF (l_debug = 'Y') THEN
2736: Okc_Debug.Log('6200: Leaving Delete_Row', 2);
2737: END IF;
2738:
2739: RETURN( G_RET_STS_SUCCESS );
2740:

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

2741: EXCEPTION
2742: WHEN OTHERS THEN
2743:
2744: IF (l_debug = 'Y') THEN
2745: Okc_Debug.Log('6300: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
2746: END IF;
2747:
2748: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2749: p_msg_name => G_UNEXPECTED_ERROR,

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

2792:
2793: BEGIN
2794:
2795: IF (l_debug = 'Y') THEN
2796: Okc_Debug.Log('6400: Entered Delete_Row', 2);
2797: END IF;
2798:
2799: OPEN l_art_csr(p_id);
2800: FETCH l_art_csr INTO l_standard_yn,l_article_id,l_article_version_id;

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

2844:
2845: END IF;
2846:
2847: IF (l_debug = 'Y') THEN
2848: Okc_Debug.Log('6500: Leaving Delete_Row', 2);
2849: END IF;
2850:
2851: EXCEPTION
2852: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2851: EXCEPTION
2852: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2853:
2854: IF (l_debug = 'Y') THEN
2855: Okc_Debug.Log('6600: Leaving Delete_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2856: END IF;
2857:
2858: x_return_status := G_RET_STS_ERROR;
2859:

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

2859:
2860: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2861:
2862: IF (l_debug = 'Y') THEN
2863: Okc_Debug.Log('6700: Leaving Delete_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2864: END IF;
2865:
2866: x_return_status := G_RET_STS_UNEXP_ERROR;
2867:

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

2867:
2868: WHEN OTHERS THEN
2869:
2870: IF (l_debug = 'Y') THEN
2871: Okc_Debug.Log('6800: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
2872: END IF;
2873:
2874: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2875: p_msg_name => G_UNEXPECTED_ERROR,

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

2892: WHERE SCN_ID=P_SCN_ID
2893: FOR UPDATE NOWAIT;
2894: BEGIN
2895: IF (l_debug = 'Y') THEN
2896: Okc_Debug.Log('9700: Entered Delete_Set', 2);
2897: Okc_Debug.Log('9710: Locking Record', 2);
2898: END IF;
2899: -- making OPEN/CLOSE cursor to lock records
2900: OPEN lock_csr;

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

2893: FOR UPDATE NOWAIT;
2894: BEGIN
2895: IF (l_debug = 'Y') THEN
2896: Okc_Debug.Log('9700: Entered Delete_Set', 2);
2897: Okc_Debug.Log('9710: Locking Record', 2);
2898: END IF;
2899: -- making OPEN/CLOSE cursor to lock records
2900: OPEN lock_csr;
2901: CLOSE lock_csr;

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

2903: DELETE FROM OKC_K_ARTICLES_B
2904: WHERE SCN_ID=P_SCN_ID;
2905:
2906: IF (l_debug = 'Y') THEN
2907: Okc_Debug.Log('11000: Leaving Delete_set', 2);
2908: END IF;
2909:
2910: EXCEPTION
2911: WHEN E_Resource_Busy THEN

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

2909:
2910: EXCEPTION
2911: WHEN E_Resource_Busy THEN
2912: IF (l_debug = 'Y') THEN
2913: Okc_Debug.Log('000: Leaving Delete_set:E_Resource_Busy Exception', 2);
2914: END IF;
2915:
2916: IF (lock_csr%ISOPEN) THEN
2917: CLOSE lock_csr;

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

2920: x_return_status := G_RET_STS_ERROR ;
2921:
2922: WHEN FND_API.G_EXC_ERROR THEN
2923: IF (l_debug = 'Y') THEN
2924: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
2925: END IF;
2926:
2927: IF (lock_csr%ISOPEN) THEN
2928: CLOSE lock_csr;

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

2930: x_return_status := G_RET_STS_ERROR;
2931:
2932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2933: IF (l_debug = 'Y') THEN
2934: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2935: END IF;
2936:
2937: IF (lock_csr%ISOPEN) THEN
2938: CLOSE lock_csr;

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

2940: x_return_status := G_RET_STS_UNEXP_ERROR;
2941:
2942: WHEN OTHERS THEN
2943: IF (l_debug = 'Y') THEN
2944: Okc_Debug.Log('11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm, 2);
2945: END IF;
2946:
2947: IF (lock_csr%ISOPEN) THEN
2948: CLOSE lock_csr;

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

2970: FOR UPDATE NOWAIT;
2971:
2972: BEGIN
2973: IF (l_debug = 'Y') THEN
2974: Okc_Debug.Log('9700: Entered Delete_Set', 2);
2975: Okc_Debug.Log('9710: Locking Records', 2);
2976: END IF;
2977:
2978:

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

2971:
2972: BEGIN
2973: IF (l_debug = 'Y') THEN
2974: Okc_Debug.Log('9700: Entered Delete_Set', 2);
2975: Okc_Debug.Log('9710: Locking Records', 2);
2976: END IF;
2977:
2978:
2979: -- making OPEN/CLOSE cursor to lock records

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

2984: WHERE DOCUMENT_TYPE=p_doc_type
2985: AND DOCUMENT_ID = p_doc_id;
2986:
2987: IF (l_debug = 'Y') THEN
2988: Okc_Debug.Log('11000: Leaving Delete_set', 2);
2989: END IF;
2990:
2991: EXCEPTION
2992: WHEN E_Resource_Busy THEN

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

2990:
2991: EXCEPTION
2992: WHEN E_Resource_Busy THEN
2993: IF (l_debug = 'Y') THEN
2994: Okc_Debug.Log('000: Leaving Delete_set:E_Resource_Busy Exception', 2);
2995: END IF;
2996:
2997: IF (lock_csr%ISOPEN) THEN
2998: CLOSE lock_csr;

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

3001: x_return_status := G_RET_STS_ERROR ;
3002:
3003: WHEN FND_API.G_EXC_ERROR THEN
3004: IF (l_debug = 'Y') THEN
3005: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
3006: END IF;
3007:
3008: IF (lock_csr%ISOPEN) THEN
3009: CLOSE lock_csr;

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

3011: x_return_status := G_RET_STS_ERROR;
3012:
3013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3014: IF (l_debug = 'Y') THEN
3015: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3016: END IF;
3017:
3018: IF (lock_csr%ISOPEN) THEN
3019: CLOSE lock_csr;

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

3021: x_return_status := G_RET_STS_UNEXP_ERROR;
3022:
3023: WHEN OTHERS THEN
3024: IF (l_debug = 'Y') THEN
3025: Okc_Debug.Log('11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm, 2);
3026: END IF;
3027:
3028: IF (lock_csr%ISOPEN) THEN
3029: CLOSE lock_csr;

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

3066:
3067: BEGIN
3068:
3069: IF (l_debug = 'Y') THEN
3070: Okc_Debug.Log('6900: Entered create_version', 2);
3071: END IF;
3072:
3073: -----------------------------------------
3074: -- Saving Base Table

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

3187: WHERE document_type = p_doc_type
3188: AND document_id = p_doc_id;
3189:
3190: IF (l_debug = 'Y') THEN
3191: Okc_Debug.Log('6910: Before Opening Non_std_csr', 2);
3192: END IF;
3193:
3194: FOR rec in non_std_csr LOOP
3195:

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

3193:
3194: FOR rec in non_std_csr LOOP
3195:
3196: IF (l_debug = 'Y') THEN
3197: Okc_Debug.Log('6920: Before calling OKC_ARTICLES_GRP.copy_article()', 2);
3198: END IF;
3199: OKC_ARTICLES_GRP.copy_article( p_api_version => 1,
3200: p_init_msg_list => FND_API.G_FALSE,
3201: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

3216: RAISE FND_API.G_EXC_ERROR;
3217: END IF;
3218:
3219: IF (l_debug = 'Y') THEN
3220: Okc_Debug.Log('6920: Before updating new Non-Std in the OKC_K_ARTICLES_B', 2);
3221: END IF;
3222:
3223:
3224: -----------------------------------------

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

3229: ARTICLE_VERSION_ID = l_article_version_id
3230: WHERE ID = rec.id;
3231:
3232: IF (l_debug = 'Y') THEN
3233: Okc_Debug.Log('6930: After Updating Non-Std in OKC_K_ARTICLES_B', 2);
3234: END IF;
3235:
3236: END LOOP;
3237:

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

3235:
3236: END LOOP;
3237:
3238: IF (l_debug = 'Y') THEN
3239: Okc_Debug.Log('7000: Leaving create_version', 2);
3240: END IF;
3241:
3242: RETURN( G_RET_STS_SUCCESS );
3243:

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

3244: EXCEPTION
3245:
3246: WHEN FND_API.G_EXC_ERROR THEN
3247: IF (l_debug = 'Y') THEN
3248: Okc_Debug.Log('7100: Leaving Create_Version:FND_API.G_EXC_ERROR Exception', 2);
3249: END IF;
3250:
3251: IF (non_std_csr%ISOPEN) THEN
3252: CLOSE non_std_csr;

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

3254: RETURN G_RET_STS_ERROR;
3255:
3256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3257: IF (l_debug = 'Y') THEN
3258: Okc_Debug.Log('7200: Leaving Create_Version:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3259: END IF;
3260:
3261: IF (non_std_csr%ISOPEN) THEN
3262: CLOSE non_std_csr;

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

3265:
3266: WHEN OTHERS THEN
3267:
3268: IF (l_debug = 'Y') THEN
3269: Okc_Debug.Log('7300: Leaving create_version because of EXCEPTION: '||sqlerrm, 2);
3270: END IF;
3271:
3272: IF (non_std_csr%ISOPEN) THEN
3273: CLOSE non_std_csr;

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

3295:
3296: BEGIN
3297:
3298: IF (l_debug = 'Y') THEN
3299: Okc_Debug.Log('7200: Entered restore_version', 2);
3300: END IF;
3301:
3302: -----------------------------------------
3303: -- Restoring Base Table

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

3415: AND document_id = p_doc_id
3416: AND major_version = p_major_version;
3417:
3418: IF (l_debug = 'Y') THEN
3419: Okc_Debug.Log('7300: Leaving restore_version', 2);
3420: END IF;
3421:
3422: RETURN( G_RET_STS_SUCCESS );
3423:

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

3424: EXCEPTION
3425: WHEN OTHERS THEN
3426:
3427: IF (l_debug = 'Y') THEN
3428: Okc_Debug.Log('7400: Leaving restore_version because of EXCEPTION: '||sqlerrm, 2);
3429: END IF;
3430:
3431: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3432: p_msg_name => G_UNEXPECTED_ERROR,

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

3450:
3451: BEGIN
3452:
3453: IF (l_debug = 'Y') THEN
3454: Okc_Debug.Log('7200: Entered Delete_Version', 2);
3455: END IF;
3456:
3457: -----------------------------------------
3458: -- Restoring Base Table

Line 3467: Okc_Debug.Log('7300: Leaving Delete_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 Delete_Version', 2);
3468: END IF;
3469:
3470: RETURN( G_RET_STS_SUCCESS );
3471:

Line 3476: Okc_Debug.Log('7400: Leaving Delete_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 Delete_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,