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_ARTICLE_VERSIONS_PVT dependencies on OKC_API

Line 9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

5:
6: ---------------------------------------------------------------------------
7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
11: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
12: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
13: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 10: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;

6: ---------------------------------------------------------------------------
7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
11: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
12: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
13: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
14: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 11: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;

7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
11: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
12: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
13: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
14: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
15: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 12: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;

8: ---------------------------------------------------------------------------
9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
11: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
12: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
13: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
14: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
15: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
16: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 13: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
11: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
12: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
13: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
14: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
15: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
16: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
17: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 14: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

10: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
11: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
12: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
13: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
14: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
15: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
16: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
17: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
18: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 15: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

11: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
12: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
13: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
14: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
15: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
16: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
17: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
18: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
19: ---------------------------------------------------------------------------

Line 16: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

12: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
13: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
14: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
15: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
16: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
17: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
18: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
19: ---------------------------------------------------------------------------
20: -- VALIDATION LEVELS

Line 17: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

13: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
14: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
15: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
16: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
17: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
18: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
19: ---------------------------------------------------------------------------
20: -- VALIDATION LEVELS
21: ---------------------------------------------------------------------------

Line 18: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

14: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
15: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
16: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
17: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
18: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
19: ---------------------------------------------------------------------------
20: -- VALIDATION LEVELS
21: ---------------------------------------------------------------------------
22: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;

Line 22: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;

18: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
19: ---------------------------------------------------------------------------
20: -- VALIDATION LEVELS
21: ---------------------------------------------------------------------------
22: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
23: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
24: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
25: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
26: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;

Line 23: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;

19: ---------------------------------------------------------------------------
20: -- VALIDATION LEVELS
21: ---------------------------------------------------------------------------
22: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
23: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
24: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
25: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
26: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
27: ---------------------------------------------------------------------------

Line 24: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;

20: -- VALIDATION LEVELS
21: ---------------------------------------------------------------------------
22: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
23: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
24: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
25: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
26: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
27: ---------------------------------------------------------------------------
28: -- GLOBAL VARIABLES

Line 25: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;

21: ---------------------------------------------------------------------------
22: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
23: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
24: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
25: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
26: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
27: ---------------------------------------------------------------------------
28: -- GLOBAL VARIABLES
29: ---------------------------------------------------------------------------

Line 26: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;

22: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
23: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
24: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
25: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
26: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
27: ---------------------------------------------------------------------------
28: -- GLOBAL VARIABLES
29: ---------------------------------------------------------------------------
30: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ARTICLE_VERSIONS_PVT';

Line 31: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

27: ---------------------------------------------------------------------------
28: -- GLOBAL VARIABLES
29: ---------------------------------------------------------------------------
30: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ARTICLE_VERSIONS_PVT';
31: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
32:
33: ------------------------------------------------------------------------------
34: -- GLOBAL CONSTANTS
35: ------------------------------------------------------------------------------

Line 97: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

93: IF (l_debug = 'Y') THEN
94: Okc_Debug.Log('300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm, 2);
95: END IF;
96:
97: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
98: p_msg_name => G_UNEXPECTED_ERROR,
99: p_token1 => G_SQLCODE_TOKEN,
100: p_token1_value => sqlcode,
101: p_token2 => G_SQLERRM_TOKEN,

Line 316: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

312: IF (l_debug = 'Y') THEN
313: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);
314: END IF;
315:
316: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
317: p_msg_name => G_UNEXPECTED_ERROR,
318: p_token1 => G_SQLCODE_TOKEN,
319: p_token1_value => sqlcode,
320: p_token2 => G_SQLERRM_TOKEN,

Line 897: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

893: WHEN OTHERS THEN
894: IF (l_debug = 'Y') THEN
895: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);
896: END IF;
897: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
898: p_msg_name => G_UNEXPECTED_ERROR,
899: p_token1 => G_SQLCODE_TOKEN,
900: p_token1_value => sqlcode,
901: p_token2 => G_SQLERRM_TOKEN,

Line 1013: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_ID');

1009: IF ( p_article_id IS NULL) THEN
1010: IF (l_debug = 'Y') THEN
1011: Okc_Debug.Log('1500: - attribute ARTICLE_ID is invalid', 2);
1012: END IF;
1013: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_ID');
1014: l_return_status := G_RET_STS_ERROR;
1015: END IF;
1016: END IF;
1017:

Line 1027: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_VERSION_NUMBER');

1023: IF ( p_article_version_number IS NULL) THEN
1024: IF (l_debug = 'Y') THEN
1025: Okc_Debug.Log('1500: - attribute ARTICLE_VERSION_NUMBER is invalid', 2);
1026: END IF;
1027: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_VERSION_NUMBER');
1028: l_return_status := G_RET_STS_ERROR;
1029: END IF;
1030: */
1031:

Line 1039: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ARTICLE_TEXT_REQD');

1035: IF ( p_article_text IS NULL) THEN
1036: IF (l_debug = 'Y') THEN
1037: Okc_Debug.Log('1500: - attribute ARTICLE_TEXT is invalid', 2);
1038: END IF;
1039: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ARTICLE_TEXT_REQD');
1040: --Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_TEXT');
1041: l_return_status := G_RET_STS_ERROR;
1042: END IF;
1043:

Line 1040: --Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_TEXT');

1036: IF (l_debug = 'Y') THEN
1037: Okc_Debug.Log('1500: - attribute ARTICLE_TEXT is invalid', 2);
1038: END IF;
1039: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ARTICLE_TEXT_REQD');
1040: --Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_TEXT');
1041: l_return_status := G_RET_STS_ERROR;
1042: END IF;
1043:
1044: IF (l_debug = 'Y') THEN

Line 1051: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'PROVISION_YN');

1047: IF ( p_provision_yn IS NULL) THEN
1048: IF (l_debug = 'Y') THEN
1049: Okc_Debug.Log('1500: - attribute PROVISION_YN is invalid', 2);
1050: END IF;
1051: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'PROVISION_YN');
1052: l_return_status := G_RET_STS_ERROR;
1053: END IF;
1054:
1055: IF (l_debug = 'Y') THEN

Line 1062: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'INSERT_BY_REFERENCE');

1058: IF ( p_insert_by_reference IS NULL) THEN
1059: IF (l_debug = 'Y') THEN
1060: Okc_Debug.Log('1500: - attribute INSERT_BY_REFERENCE is invalid', 2);
1061: END IF;
1062: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'INSERT_BY_REFERENCE');
1063: l_return_status := G_RET_STS_ERROR;
1064: END IF;
1065:
1066: IF (l_debug = 'Y') THEN

Line 1073: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'LOCK_TEXT');

1069: IF ( p_lock_text IS NULL) THEN
1070: IF (l_debug = 'Y') THEN
1071: Okc_Debug.Log('1500: - attribute LOCK_TEXT is invalid', 2);
1072: END IF;
1073: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'LOCK_TEXT');
1074: l_return_status := G_RET_STS_ERROR;
1075: END IF;
1076:
1077: IF (l_debug = 'Y') THEN

Line 1084: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'GLOBAL_YN');

1080: IF ( p_global_yn IS NULL) THEN
1081: IF (l_debug = 'Y') THEN
1082: Okc_Debug.Log('1500: - attribute GLOBAL_YN is invalid', 2);
1083: END IF;
1084: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'GLOBAL_YN');
1085: l_return_status := G_RET_STS_ERROR;
1086: END IF;
1087:
1088: IF (l_debug = 'Y') THEN

Line 1095: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_LANGUAGE');

1091: IF ( p_article_language IS NULL) THEN
1092: IF (l_debug = 'Y') THEN
1093: Okc_Debug.Log('1500: - attribute ARTICLE_LANGUAGE is invalid', 2);
1094: END IF;
1095: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_LANGUAGE');
1096: l_return_status := G_RET_STS_ERROR;
1097: END IF;
1098:
1099: IF p_standard_yn = 'Y' OR p_import_action IS NOT NULL Then

Line 1107: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'START_DATE');

1103: IF ( p_start_date IS NULL) THEN
1104: IF (l_debug = 'Y') THEN
1105: Okc_Debug.Log('1500: - attribute START_DATE is invalid', 2);
1106: END IF;
1107: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'START_DATE');
1108: l_return_status := G_RET_STS_ERROR;
1109: END IF;
1110: END IF;
1111:

Line 1119: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'EDITED_IN_WORD');

1115: IF ( p_edited_in_word IS NULL) THEN
1116: IF (l_debug = 'Y') THEN
1117: Okc_Debug.Log('1500: - attribute EDITED_IN_WORD is invalid', 2);
1118: END IF;
1119: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'EDITED_IN_WORD');
1120: l_return_status := G_RET_STS_ERROR;
1121: END IF; */
1122:
1123: IF p_edited_in_word = 'Y' Then

Line 1131: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_ERROR_IMPORT_WORD');

1127: IF ( p_article_text_in_word IS NULL OR Dbms_Lob.SubStr(p_article_text_in_word,1,1) = '00') THEN
1128: IF (l_debug = 'Y') THEN
1129: Okc_Debug.Log('1500: - attribute ARTICLE_TEXT_IN_WORD is invalid', 2);
1130: END IF;
1131: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_ERROR_IMPORT_WORD');
1132: l_return_status := G_RET_STS_ERROR;
1133: ELSE
1134:
1135: BEGIN

Line 1145: Okc_Api.Set_Message(G_APP_NAME, 'OKC_INV_ART_TXT_WML');

1141:
1142: IF (l_debug = 'Y') THEN
1143: Okc_Debug.Log('3000: - attribute ARTICLE_TEXT_IN_WORD is not a valid XML', 2);
1144: END IF;
1145: Okc_Api.Set_Message(G_APP_NAME, 'OKC_INV_ART_TXT_WML');
1146: l_return_status := G_RET_STS_ERROR;
1147:
1148: END;
1149:

Line 1166: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'PROVISION_YN');

1162: IF p_provision_yn NOT IN ('Y','N') THEN
1163: IF (l_debug = 'Y') THEN
1164: Okc_Debug.Log('1800: - attribute PROVISION_YN is invalid', 2);
1165: END IF;
1166: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'PROVISION_YN');
1167: l_return_status := G_RET_STS_ERROR;
1168: END IF;
1169:
1170: IF p_insert_by_reference NOT IN ('Y','N') THEN

Line 1174: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'INSERT_BY_REFERENCE');

1170: IF p_insert_by_reference NOT IN ('Y','N') THEN
1171: IF (l_debug = 'Y') THEN
1172: Okc_Debug.Log('1800: - attribute INSERT_BY_REFERENCE is invalid', 2);
1173: END IF;
1174: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'INSERT_BY_REFERENCE');
1175: l_return_status := G_RET_STS_ERROR;
1176: END IF;
1177:
1178: IF p_lock_text NOT IN ('Y','N') THEN

Line 1182: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'LOCK_TEXT');

1178: IF p_lock_text NOT IN ('Y','N') THEN
1179: IF (l_debug = 'Y') THEN
1180: Okc_Debug.Log('1800: - attribute LOCK_TEXT is invalid', 2);
1181: END IF;
1182: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'LOCK_TEXT');
1183: l_return_status := G_RET_STS_ERROR;
1184: END IF;
1185:
1186: IF (l_debug = 'Y') THEN

Line 1193: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'GLOBAL_YN');

1189: IF p_global_yn NOT IN ('Y','N') THEN
1190: IF (l_debug = 'Y') THEN
1191: Okc_Debug.Log('1800: - attribute GLOBAL_YN is invalid', 2);
1192: END IF;
1193: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'GLOBAL_YN');
1194: l_return_status := G_RET_STS_ERROR;
1195: END IF;
1196:
1197: IF (l_debug = 'Y') THEN

Line 1204: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'TRANSLATED_YN');

1200: IF p_translated_yn NOT IN ('Y','N') THEN
1201: IF (l_debug = 'Y') THEN
1202: Okc_Debug.Log('1800: - attribute TRANSLATED_YN is invalid', 2);
1203: END IF;
1204: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'TRANSLATED_YN');
1205: l_return_status := G_RET_STS_ERROR;
1206: END IF;
1207:
1208: END IF;

Line 1223: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_STATUS');

1219: END IF;
1220: IF p_article_status IS NOT NULL THEN
1221: l_tmp_return_status := Okc_Util.Check_Lookup_Code('OKC_ARTICLE_STATUS',p_article_status);
1222: IF (l_tmp_return_status <> G_RET_STS_SUCCESS) THEN
1223: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_STATUS');
1224: l_return_status := G_RET_STS_ERROR;
1225: END IF;
1226: END IF;
1227: */

Line 1235: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INVALID_SECTION');

1231: END IF;
1232: IF p_default_section IS NOT NULL THEN
1233: l_tmp_return_status := Okc_Util.Check_Lookup_Code('OKC_ARTICLE_SECTION',p_default_section);
1234: IF (l_tmp_return_status <> G_RET_STS_SUCCESS) THEN
1235: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INVALID_SECTION');
1236: l_return_status := G_RET_STS_ERROR;
1237: END IF;
1238: END IF;
1239:

Line 1262: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ARTICLE_LANGAUGE');

1258: IF (l_dummy_var = '?') THEN
1259: IF (l_debug = 'Y') THEN
1260: Okc_Debug.Log('2300: - attribute ARTICLE_LANGAUGE is invalid', 2);
1261: END IF;
1262: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ARTICLE_LANGAUGE');
1263: l_return_status := G_RET_STS_ERROR;
1264: END IF;
1265: END IF;
1266: */

Line 1279: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'STD_ARTICLE_VERSION_ID');

1275: IF (l_dummy_var = '?') THEN
1276: IF (l_debug = 'Y') THEN
1277: Okc_Debug.Log('2300: - attribute STD_ARTICLE_VERSION_ID is invalid', 2);
1278: END IF;
1279: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'STD_ARTICLE_VERSION_ID');
1280: l_return_status := G_RET_STS_ERROR;
1281: END IF;
1282: END IF;
1283:

Line 1296: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DATE_PUBLISHED');

1292: IF (l_dummy_date >= p_date_published) THEN
1293: IF (l_debug = 'Y') THEN
1294: Okc_Debug.Log('2300: - attribute DATE_PUBLISHED is invalid', 2);
1295: END IF;
1296: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DATE_PUBLISHED');
1297: l_return_status := G_RET_STS_ERROR;
1298: END IF;
1299: END IF;
1300: */

Line 1313: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1309:
1310: EXCEPTION
1311: WHEN OTHERS THEN
1312: Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
1313: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1314: p_msg_name => G_UNEXPECTED_ERROR,
1315: p_token1 => G_SQLCODE_TOKEN,
1316: p_token1_value => sqlcode,
1317: p_token2 => G_SQLERRM_TOKEN,

Line 1542: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');

1538: if G_CURRENT_ORG_ID IS NULL Then
1539: IF (l_debug = 'Y') THEN
1540: Okc_Debug.Log('2300: - attribute G_CURRENT_ORG_ID is invalid', 2);
1541: END IF;
1542: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');
1543: l_return_status := G_RET_STS_ERROR;
1544: RETURN l_return_status ;
1545: end if;
1546:

Line 1570: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ARTICLE_ID');

1566: IF (l_standard_yn = '?') THEN
1567: IF (l_debug = 'Y') THEN
1568: Okc_Debug.Log('2300: - attribute ARTICLE_ID is invalid', 2);
1569: END IF;
1570: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ARTICLE_ID');
1571: l_return_status := G_RET_STS_ERROR;
1572: RETURN l_return_status ;
1573: END IF;
1574: END IF;

Line 1687: OKC_API.Set_Message(G_APP_NAME, 'OKC_ART_START_GT_END_DATE');

1683: IF ( p_end_date < p_start_date ) THEN
1684: IF (l_debug = 'Y') THEN
1685: Okc_Debug.Log('1300: attribute START_DATE IS greater then end date for standard article', 2);
1686: END IF;
1687: OKC_API.Set_Message(G_APP_NAME, 'OKC_ART_START_GT_END_DATE');
1688: l_return_status := G_RET_STS_ERROR;
1689: ELSIF p_article_status in ('DRAFT','REJECTED','PENDING_APPROVAL') AND
1690: p_end_date < trunc(sysdate) THEN -- Added for Bug 3517002
1691: IF (l_debug = 'Y') THEN

Line 1694: OKC_API.Set_Message(G_APP_NAME, 'OKC_ART_END_LT_SYS_DATE');

1690: p_end_date < trunc(sysdate) THEN -- Added for Bug 3517002
1691: IF (l_debug = 'Y') THEN
1692: Okc_Debug.Log('1300: attribute END_DATE IS less then system date for standard article', 2);
1693: END IF;
1694: OKC_API.Set_Message(G_APP_NAME, 'OKC_ART_END_LT_SYS_DATE');
1695: l_return_status := G_RET_STS_ERROR;
1696: END IF;
1697: END IF;
1698:

Line 1706: OKC_API.Set_Message(G_APP_NAME, 'OKC_ART_REF_TEXT_NULL');

1702: IF ( p_reference_text IS NULL ) THEN
1703: IF (l_debug = 'Y') THEN
1704: Okc_Debug.Log('1300: attribute REFERENCE_TEXT cannot be null if INSERT_BY_REFERENCE is YES', 2);
1705: END IF;
1706: OKC_API.Set_Message(G_APP_NAME, 'OKC_ART_REF_TEXT_NULL');
1707: l_return_status := G_RET_STS_ERROR;
1708: END IF;
1709: END IF;
1710:

Line 1719: OKC_API.Set_Message(G_APP_NAME, 'OKC_ART_APPROVED_GT_END_DATE');

1715: IF ( p_date_approved > nvl(p_end_date,p_date_approved + 1) ) THEN
1716: IF (l_debug = 'Y') THEN
1717: Okc_Debug.Log('1300: attribute END_DATE IS less then approved date for standard article', 2);
1718: END IF;
1719: OKC_API.Set_Message(G_APP_NAME, 'OKC_ART_APPROVED_GT_END_DATE');
1720: l_return_status := G_RET_STS_ERROR;
1721: END IF;
1722: END IF;
1723: */

Line 1737: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_GLOBAL_ART_LOCAL_ORG' );

1733: p_global_yn = 'Y') Then
1734: IF (l_debug = 'Y') THEN
1735: Okc_Debug.Log('2300: - attribute Global Article cannot be created at a local org', 2);
1736: END IF;
1737: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_GLOBAL_ART_LOCAL_ORG' );
1738: l_return_status := G_RET_STS_ERROR;
1739: END IF;
1740: -- Only first version exists or first version is imported
1741: -- skip comparison part with previous version

Line 1767: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_EARLIER_VER_PROVISION' );

1763: IF nvl(l_highest_version_rec.provision_yn, 'N') <> nvl(p_provision_yn, 'N') THEN
1764: IF (l_debug = 'Y') THEN
1765: Okc_Debug.Log('1800: - Earlier version is of Provison/Clause is different from current one.', 2);
1766: END IF;
1767: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_EARLIER_VER_PROVISION' );
1768: l_return_status := G_RET_STS_ERROR;
1769: END IF;
1770: -- End MSENGUPT 05/24
1771: -- Begin MSENGUPT 06/24 Global flag check is needed only for draft status clauses and import of a NEW VERSION.

Line 1781: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_EARLIER_VER_GLOBAL' );

1777: IF (l_highest_version_rec.global_yn = 'Y' and p_global_yn = 'N') THEN
1778: IF (l_debug = 'Y') THEN
1779: Okc_Debug.Log('1800: - Earlier version is GLOBAL this version cannot be LOCAL', 2);
1780: END IF;
1781: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_EARLIER_VER_GLOBAL' );
1782: l_return_status := G_RET_STS_ERROR;
1783: END IF;
1784: END IF;
1785: -- End MSENGUPT 06/25

Line 1794: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_EXIST_DRAFT_REJ');

1790:
1791: IF (l_debug = 'Y') THEN
1792: Okc_Debug.Log('1800: - Already have one version available in DRAFT,REJECTED OR PENDING_APPROVAL', 2);
1793: END IF;
1794: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_EXIST_DRAFT_REJ');
1795: l_return_status := G_RET_STS_ERROR;
1796: END IF;
1797:
1798: -- Date Published Check

Line 1803: --Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DATE_PUBLISHED');

1799: IF (l_highest_version_rec.date_published) >= p_date_published AND p_import_action IS NOT NULL THEN
1800: IF (l_debug = 'Y') THEN
1801: Okc_Debug.Log('1800: - Date Published of existing version is greater than date published provided for new version',2);
1802: END IF;
1803: --Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DATE_PUBLISHED');
1804: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_EXIST_DATE_PUBLISHED');
1805: l_return_status := G_RET_STS_ERROR;
1806: END IF;
1807:

Line 1804: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_EXIST_DATE_PUBLISHED');

1800: IF (l_debug = 'Y') THEN
1801: Okc_Debug.Log('1800: - Date Published of existing version is greater than date published provided for new version',2);
1802: END IF;
1803: --Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DATE_PUBLISHED');
1804: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_EXIST_DATE_PUBLISHED');
1805: l_return_status := G_RET_STS_ERROR;
1806: END IF;
1807:
1808: -- Bug#3722445: Overlapping check - not required if later versions are APPROVED. UI will take care of that.

Line 1820: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_END_DATE_NULL');

1816: -- if subsequent version is approved or on hold, then the end date of the current version cannot be set to NULL: UI will enforce too
1817: -- if subsequent version is in draft/rejected or pending approval status, the end date should not overlap.
1818:
1819: if p_end_date IS NULL AND l_highest_version_rec.article_status in ('APPROVED', 'HOLD') THEN
1820: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_END_DATE_NULL');
1821: l_return_status := G_RET_STS_ERROR;
1822: elsif nvl(p_end_date, l_highest_version_rec.start_date-1) >= l_highest_version_rec.start_date then
1823: IF (l_debug = 'Y') THEN
1824: Okc_Debug.Log('1800: - Date overlap with earlier version', 2);

Line 1826: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_DATE_OVRLP_EARLR_VER');

1822: elsif nvl(p_end_date, l_highest_version_rec.start_date-1) >= l_highest_version_rec.start_date then
1823: IF (l_debug = 'Y') THEN
1824: Okc_Debug.Log('1800: - Date overlap with earlier version', 2);
1825: END IF;
1826: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_DATE_OVRLP_EARLR_VER');
1827: l_return_status := G_RET_STS_ERROR;
1828: end if;
1829: ELSIF (l_highest_version_rec.start_date >= p_start_date) OR
1830: (nvl(l_highest_version_rec.end_date, p_start_date-1) >= p_start_date) THEN

Line 1834: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_DATE_OVRLP_EARLR_VER');

1830: (nvl(l_highest_version_rec.end_date, p_start_date-1) >= p_start_date) THEN
1831: IF (l_debug = 'Y') THEN
1832: Okc_Debug.Log('1800: - Date overlap with earlier version', 2);
1833: END IF;
1834: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_DATE_OVRLP_EARLR_VER');
1835: l_return_status := G_RET_STS_ERROR;
1836: END IF; -- (l_highest_version_rec.start_date >= p_start_date) OR..
1837: END IF; -- IF (l_highest_version_rec.global_yn = 'Y' and p_global_yn = 'N')
1838: --END IF; --IF l_highest_version_rec.article_version_number IS NULL

Line 1844: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DATE_APPROVED');

1840: END IF; --IF p_import_action = 'N', l_highest_version_rec.article_version_number IS NULL
1841:
1842: IF p_article_status IN ('HOLD', 'APPROVED') AND
1843: p_date_approved IS NULL THEN
1844: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DATE_APPROVED');
1845: l_return_status := G_RET_STS_ERROR;
1846: END IF;
1847:
1848: -- Bug#3672511: Validation of start date of a localized clause should be >= start date of global clause.

Line 1868: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_CMP_START_DATE');

1864: ELSIF (l_global_start_date > p_start_date) THEN
1865: IF (l_debug = 'Y') THEN
1866: Okc_Debug.Log('2300: - Start Date is greater than Global Start Date', 2);
1867: END IF;
1868: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_CMP_START_DATE');
1869: l_return_status := G_RET_STS_ERROR;
1870: RETURN l_return_status ;
1871: END IF;
1872: END IF; -- end of if current org id <> global org id

Line 1879: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INV_RELATION_PROVISION');

1875:
1876: -- fix for bug#4006749 start
1877: -- muteshev
1878: if provision_flag_in_relations(p_article_id, G_CURRENT_ORG_ID, p_provision_yn)='E' then
1879: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INV_RELATION_PROVISION');
1880: l_return_status := G_RET_STS_ERROR;
1881: RETURN l_return_status ;
1882: end if;
1883: -- fix for bug#4006749 end

Line 1905: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1901: IF (l_debug = 'Y') THEN
1902: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
1903: END IF;
1904:
1905: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1906: p_msg_name => G_UNEXPECTED_ERROR,
1907: p_token1 => G_SQLCODE_TOKEN,
1908: p_token1_value => sqlcode,
1909: p_token2 => G_SQLERRM_TOKEN,

Line 2231: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');

2227: if G_CURRENT_ORG_ID IS NULL Then
2228: IF (l_debug = 'Y') THEN
2229: Okc_Debug.Log('2300: - attribute G_CURRENT_ORG_ID is invalid', 2);
2230: END IF;
2231: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');
2232: x_return_status := G_RET_STS_ERROR;
2233: RAISE FND_API.G_EXC_ERROR;
2234: end if;
2235:

Line 2328: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2324: WHEN OTHERS THEN
2325: IF (l_debug = 'Y') THEN
2326: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
2327: END IF;
2328: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2329: p_msg_name => G_UNEXPECTED_ERROR,
2330: p_token1 => G_SQLCODE_TOKEN,
2331: p_token1_value => sqlcode,
2332: p_token2 => G_SQLERRM_TOKEN,

Line 2567: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2563: IF (l_debug = 'Y') THEN
2564: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
2565: END IF;
2566:
2567: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2568: p_msg_name => G_UNEXPECTED_ERROR,
2569: p_token1 => G_SQLCODE_TOKEN,
2570: p_token1_value => sqlcode,
2571: p_token2 => G_SQLERRM_TOKEN,

Line 2695: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');

2691: if G_CURRENT_ORG_ID IS NULL Then
2692: IF (l_debug = 'Y') THEN
2693: Okc_Debug.Log('2300: - attribute G_CURRENT_ORG_ID is invalid', 2);
2694: END IF;
2695: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');
2696: x_return_status := G_RET_STS_ERROR;
2697: RAISE FND_API.G_EXC_ERROR;
2698: end if;
2699:

Line 2879: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2875: WHEN OTHERS THEN
2876: IF (l_debug = 'Y') THEN
2877: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
2878: END IF;
2879: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2880: p_msg_name => G_UNEXPECTED_ERROR,
2881: p_token1 => G_SQLCODE_TOKEN,
2882: p_token1_value => sqlcode,
2883: p_token2 => G_SQLERRM_TOKEN,

Line 2942: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);

2938:
2939: IF (lock_csr%ISOPEN) THEN
2940: CLOSE lock_csr;
2941: END IF;
2942: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
2943: RETURN( G_RET_STS_ERROR );
2944: END;
2945:
2946: IF ( l_row_notfound ) THEN

Line 2955: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);

2951: l_row_notfound := lchk_csr%NOTFOUND;
2952: CLOSE lchk_csr;
2953:
2954: IF (l_row_notfound) THEN
2955: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
2956: ELSIF l_object_version_number > p_object_version_number THEN
2957: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2958: ELSIF l_object_version_number = -1 THEN
2959: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line 2957: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

2953:
2954: IF (l_row_notfound) THEN
2955: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
2956: ELSIF l_object_version_number > p_object_version_number THEN
2957: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2958: ELSIF l_object_version_number = -1 THEN
2959: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2960: ELSE -- it can be the only above condition. It can happen after restore version
2961: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

Line 2959: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

2955: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
2956: ELSIF l_object_version_number > p_object_version_number THEN
2957: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2958: ELSIF l_object_version_number = -1 THEN
2959: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2960: ELSE -- it can be the only above condition. It can happen after restore version
2961: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2962: END IF;
2963: ELSE

Line 2961: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

2957: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2958: ELSIF l_object_version_number = -1 THEN
2959: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2960: ELSE -- it can be the only above condition. It can happen after restore version
2961: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2962: END IF;
2963: ELSE
2964: l_return_status := G_RET_STS_SUCCESS;
2965: END IF;

Line 2987: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2983: IF (l_debug = 'Y') THEN
2984: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
2985: END IF;
2986:
2987: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2988: p_msg_name => G_UNEXPECTED_ERROR,
2989: p_token1 => G_SQLCODE_TOKEN,
2990: p_token1_value => sqlcode,
2991: p_token2 => G_SQLERRM_TOKEN,

Line 3049: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3045: WHEN OTHERS THEN
3046: IF (l_debug = 'Y') THEN
3047: Okc_Debug.Log('6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
3048: END IF;
3049: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3050: p_msg_name => G_UNEXPECTED_ERROR,
3051: p_token1 => G_SQLCODE_TOKEN,
3052: p_token1_value => sqlcode,
3053: p_token2 => G_SQLERRM_TOKEN,

Line 3225: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3221: IF (l_debug = 'Y') THEN
3222: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
3223: END IF;
3224:
3225: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3226: p_msg_name => G_UNEXPECTED_ERROR,
3227: p_token1 => G_SQLCODE_TOKEN,
3228: p_token1_value => sqlcode,
3229: p_token2 => G_SQLERRM_TOKEN,

Line 3504: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');

3500: if G_CURRENT_ORG_ID IS NULL Then
3501: IF (l_debug = 'Y') THEN
3502: Okc_Debug.Log('2300: - attribute G_CURRENT_ORG_ID is invalid', 2);
3503: END IF;
3504: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');
3505: x_return_status := G_RET_STS_ERROR;
3506: RAISE FND_API.G_EXC_ERROR;
3507: end if;
3508:

Line 3692: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3688: WHEN OTHERS THEN
3689: IF (l_debug = 'Y') THEN
3690: Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
3691: END IF;
3692: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3693: p_msg_name => G_UNEXPECTED_ERROR,
3694: p_token1 => G_SQLCODE_TOKEN,
3695: p_token1_value => sqlcode,
3696: p_token2 => G_SQLERRM_TOKEN,

Line 3733: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3729: IF (l_debug = 'Y') THEN
3730: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
3731: END IF;
3732:
3733: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3734: p_msg_name => G_UNEXPECTED_ERROR,
3735: p_token1 => G_SQLCODE_TOKEN,
3736: p_token1_value => sqlcode,
3737: p_token2 => G_SQLERRM_TOKEN,

Line 3803: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3799: WHEN OTHERS THEN
3800: IF (l_debug = 'Y') THEN
3801: Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
3802: END IF;
3803: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3804: p_msg_name => G_UNEXPECTED_ERROR,
3805: p_token1 => G_SQLCODE_TOKEN,
3806: p_token1_value => sqlcode,
3807: p_token2 => G_SQLERRM_TOKEN,