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 307: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

303: IF (l_debug = 'Y') THEN
304: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);
305: END IF;
306:
307: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
308: p_msg_name => G_UNEXPECTED_ERROR,
309: p_token1 => G_SQLCODE_TOKEN,
310: p_token1_value => sqlcode,
311: p_token2 => G_SQLERRM_TOKEN,

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

850: WHEN OTHERS THEN
851: IF (l_debug = 'Y') THEN
852: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);
853: END IF;
854: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
855: p_msg_name => G_UNEXPECTED_ERROR,
856: p_token1 => G_SQLCODE_TOKEN,
857: p_token1_value => sqlcode,
858: p_token2 => G_SQLERRM_TOKEN,

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

962: IF ( p_article_id IS NULL) THEN
963: IF (l_debug = 'Y') THEN
964: Okc_Debug.Log('1500: - attribute ARTICLE_ID is invalid', 2);
965: END IF;
966: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_ID');
967: l_return_status := G_RET_STS_ERROR;
968: END IF;
969: END IF;
970:

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

976: IF ( p_article_version_number IS NULL) THEN
977: IF (l_debug = 'Y') THEN
978: Okc_Debug.Log('1500: - attribute ARTICLE_VERSION_NUMBER is invalid', 2);
979: END IF;
980: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_VERSION_NUMBER');
981: l_return_status := G_RET_STS_ERROR;
982: END IF;
983: */
984:

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

988: IF ( p_article_text IS NULL) THEN
989: IF (l_debug = 'Y') THEN
990: Okc_Debug.Log('1500: - attribute ARTICLE_TEXT is invalid', 2);
991: END IF;
992: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ARTICLE_TEXT_REQD');
993: --Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_TEXT');
994: l_return_status := G_RET_STS_ERROR;
995: END IF;
996:

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

989: IF (l_debug = 'Y') THEN
990: Okc_Debug.Log('1500: - attribute ARTICLE_TEXT is invalid', 2);
991: END IF;
992: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ARTICLE_TEXT_REQD');
993: --Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_TEXT');
994: l_return_status := G_RET_STS_ERROR;
995: END IF;
996:
997: IF (l_debug = 'Y') THEN

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

1000: IF ( p_provision_yn IS NULL) THEN
1001: IF (l_debug = 'Y') THEN
1002: Okc_Debug.Log('1500: - attribute PROVISION_YN is invalid', 2);
1003: END IF;
1004: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'PROVISION_YN');
1005: l_return_status := G_RET_STS_ERROR;
1006: END IF;
1007:
1008: IF (l_debug = 'Y') THEN

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

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

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

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

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

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

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

1044: IF ( p_article_language IS NULL) THEN
1045: IF (l_debug = 'Y') THEN
1046: Okc_Debug.Log('1500: - attribute ARTICLE_LANGUAGE is invalid', 2);
1047: END IF;
1048: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_LANGUAGE');
1049: l_return_status := G_RET_STS_ERROR;
1050: END IF;
1051:
1052: IF p_standard_yn = 'Y' OR p_import_action IS NOT NULL Then

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

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

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

1075: IF p_provision_yn NOT IN ('Y','N') THEN
1076: IF (l_debug = 'Y') THEN
1077: Okc_Debug.Log('1800: - attribute PROVISION_YN is invalid', 2);
1078: END IF;
1079: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'PROVISION_YN');
1080: l_return_status := G_RET_STS_ERROR;
1081: END IF;
1082:
1083: IF p_insert_by_reference NOT IN ('Y','N') THEN

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

1083: IF p_insert_by_reference NOT IN ('Y','N') THEN
1084: IF (l_debug = 'Y') THEN
1085: Okc_Debug.Log('1800: - attribute INSERT_BY_REFERENCE is invalid', 2);
1086: END IF;
1087: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'INSERT_BY_REFERENCE');
1088: l_return_status := G_RET_STS_ERROR;
1089: END IF;
1090:
1091: IF p_lock_text NOT IN ('Y','N') THEN

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

1091: IF p_lock_text NOT IN ('Y','N') THEN
1092: IF (l_debug = 'Y') THEN
1093: Okc_Debug.Log('1800: - attribute LOCK_TEXT is invalid', 2);
1094: END IF;
1095: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'LOCK_TEXT');
1096: l_return_status := G_RET_STS_ERROR;
1097: END IF;
1098:
1099: IF (l_debug = 'Y') THEN

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

1102: IF p_global_yn NOT IN ('Y','N') THEN
1103: IF (l_debug = 'Y') THEN
1104: Okc_Debug.Log('1800: - attribute GLOBAL_YN is invalid', 2);
1105: END IF;
1106: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'GLOBAL_YN');
1107: l_return_status := G_RET_STS_ERROR;
1108: END IF;
1109:
1110: IF (l_debug = 'Y') THEN

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

1113: IF p_translated_yn NOT IN ('Y','N') THEN
1114: IF (l_debug = 'Y') THEN
1115: Okc_Debug.Log('1800: - attribute TRANSLATED_YN is invalid', 2);
1116: END IF;
1117: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'TRANSLATED_YN');
1118: l_return_status := G_RET_STS_ERROR;
1119: END IF;
1120:
1121: END IF;

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

1132: END IF;
1133: IF p_article_status IS NOT NULL THEN
1134: l_tmp_return_status := Okc_Util.Check_Lookup_Code('OKC_ARTICLE_STATUS',p_article_status);
1135: IF (l_tmp_return_status <> G_RET_STS_SUCCESS) THEN
1136: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_STATUS');
1137: l_return_status := G_RET_STS_ERROR;
1138: END IF;
1139: END IF;
1140: */

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

1144: END IF;
1145: IF p_default_section IS NOT NULL THEN
1146: l_tmp_return_status := Okc_Util.Check_Lookup_Code('OKC_ARTICLE_SECTION',p_default_section);
1147: IF (l_tmp_return_status <> G_RET_STS_SUCCESS) THEN
1148: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INVALID_SECTION');
1149: l_return_status := G_RET_STS_ERROR;
1150: END IF;
1151: END IF;
1152:

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

1171: IF (l_dummy_var = '?') THEN
1172: IF (l_debug = 'Y') THEN
1173: Okc_Debug.Log('2300: - attribute ARTICLE_LANGAUGE is invalid', 2);
1174: END IF;
1175: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ARTICLE_LANGAUGE');
1176: l_return_status := G_RET_STS_ERROR;
1177: END IF;
1178: END IF;
1179: */

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

1188: IF (l_dummy_var = '?') THEN
1189: IF (l_debug = 'Y') THEN
1190: Okc_Debug.Log('2300: - attribute STD_ARTICLE_VERSION_ID is invalid', 2);
1191: END IF;
1192: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'STD_ARTICLE_VERSION_ID');
1193: l_return_status := G_RET_STS_ERROR;
1194: END IF;
1195: END IF;
1196:

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

1205: IF (l_dummy_date >= p_date_published) THEN
1206: IF (l_debug = 'Y') THEN
1207: Okc_Debug.Log('2300: - attribute DATE_PUBLISHED is invalid', 2);
1208: END IF;
1209: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DATE_PUBLISHED');
1210: l_return_status := G_RET_STS_ERROR;
1211: END IF;
1212: END IF;
1213: */

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

1222:
1223: EXCEPTION
1224: WHEN OTHERS THEN
1225: Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
1226: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1227: p_msg_name => G_UNEXPECTED_ERROR,
1228: p_token1 => G_SQLCODE_TOKEN,
1229: p_token1_value => sqlcode,
1230: p_token2 => G_SQLERRM_TOKEN,

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

1448: if G_CURRENT_ORG_ID IS NULL Then
1449: IF (l_debug = 'Y') THEN
1450: Okc_Debug.Log('2300: - attribute G_CURRENT_ORG_ID is invalid', 2);
1451: END IF;
1452: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');
1453: l_return_status := G_RET_STS_ERROR;
1454: RETURN l_return_status ;
1455: end if;
1456:

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

1476: IF (l_standard_yn = '?') THEN
1477: IF (l_debug = 'Y') THEN
1478: Okc_Debug.Log('2300: - attribute ARTICLE_ID is invalid', 2);
1479: END IF;
1480: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ARTICLE_ID');
1481: l_return_status := G_RET_STS_ERROR;
1482: RETURN l_return_status ;
1483: END IF;
1484: END IF;

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

1590: IF ( p_end_date < p_start_date ) THEN
1591: IF (l_debug = 'Y') THEN
1592: Okc_Debug.Log('1300: attribute START_DATE IS greater then end date for standard article', 2);
1593: END IF;
1594: OKC_API.Set_Message(G_APP_NAME, 'OKC_ART_START_GT_END_DATE');
1595: l_return_status := G_RET_STS_ERROR;
1596: ELSIF p_article_status in ('DRAFT','REJECTED','PENDING_APPROVAL') AND
1597: p_end_date < trunc(sysdate) THEN -- Added for Bug 3517002
1598: IF (l_debug = 'Y') THEN

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

1597: p_end_date < trunc(sysdate) THEN -- Added for Bug 3517002
1598: IF (l_debug = 'Y') THEN
1599: Okc_Debug.Log('1300: attribute END_DATE IS less then system date for standard article', 2);
1600: END IF;
1601: OKC_API.Set_Message(G_APP_NAME, 'OKC_ART_END_LT_SYS_DATE');
1602: l_return_status := G_RET_STS_ERROR;
1603: END IF;
1604: END IF;
1605:

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

1609: IF ( p_reference_text IS NULL ) THEN
1610: IF (l_debug = 'Y') THEN
1611: Okc_Debug.Log('1300: attribute REFERENCE_TEXT cannot be null if INSERT_BY_REFERENCE is YES', 2);
1612: END IF;
1613: OKC_API.Set_Message(G_APP_NAME, 'OKC_ART_REF_TEXT_NULL');
1614: l_return_status := G_RET_STS_ERROR;
1615: END IF;
1616: END IF;
1617:

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

1622: IF ( p_date_approved > nvl(p_end_date,p_date_approved + 1) ) THEN
1623: IF (l_debug = 'Y') THEN
1624: Okc_Debug.Log('1300: attribute END_DATE IS less then approved date for standard article', 2);
1625: END IF;
1626: OKC_API.Set_Message(G_APP_NAME, 'OKC_ART_APPROVED_GT_END_DATE');
1627: l_return_status := G_RET_STS_ERROR;
1628: END IF;
1629: END IF;
1630: */

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

1640: p_global_yn = 'Y') Then
1641: IF (l_debug = 'Y') THEN
1642: Okc_Debug.Log('2300: - attribute Global Article cannot be created at a local org', 2);
1643: END IF;
1644: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_GLOBAL_ART_LOCAL_ORG' );
1645: l_return_status := G_RET_STS_ERROR;
1646: END IF;
1647: -- Only first version exists or first version is imported
1648: -- skip comparison part with previous version

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

1670: IF nvl(l_highest_version_rec.provision_yn, 'N') <> nvl(p_provision_yn, 'N') THEN
1671: IF (l_debug = 'Y') THEN
1672: Okc_Debug.Log('1800: - Earlier version is of Provison/Clause is different from current one.', 2);
1673: END IF;
1674: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_EARLIER_VER_PROVISION' );
1675: l_return_status := G_RET_STS_ERROR;
1676: END IF;
1677: -- End MSENGUPT 05/24
1678: -- Begin MSENGUPT 06/24 Global flag check is needed only for draft status clauses and import of a NEW VERSION.

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

1684: IF (l_highest_version_rec.global_yn = 'Y' and p_global_yn = 'N') THEN
1685: IF (l_debug = 'Y') THEN
1686: Okc_Debug.Log('1800: - Earlier version is GLOBAL this version cannot be LOCAL', 2);
1687: END IF;
1688: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_EARLIER_VER_GLOBAL' );
1689: l_return_status := G_RET_STS_ERROR;
1690: END IF;
1691: END IF;
1692: -- End MSENGUPT 06/25

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

1697:
1698: IF (l_debug = 'Y') THEN
1699: Okc_Debug.Log('1800: - Already have one version available in DRAFT,REJECTED OR PENDING_APPROVAL', 2);
1700: END IF;
1701: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_EXIST_DRAFT_REJ');
1702: l_return_status := G_RET_STS_ERROR;
1703: END IF;
1704:
1705: -- Date Published Check

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

1706: IF (l_highest_version_rec.date_published) >= p_date_published AND p_import_action IS NOT NULL THEN
1707: IF (l_debug = 'Y') THEN
1708: Okc_Debug.Log('1800: - Date Published of existing version is greater than date published provided for new version',2);
1709: END IF;
1710: --Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DATE_PUBLISHED');
1711: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_EXIST_DATE_PUBLISHED');
1712: l_return_status := G_RET_STS_ERROR;
1713: END IF;
1714:

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

1707: IF (l_debug = 'Y') THEN
1708: Okc_Debug.Log('1800: - Date Published of existing version is greater than date published provided for new version',2);
1709: END IF;
1710: --Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DATE_PUBLISHED');
1711: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_EXIST_DATE_PUBLISHED');
1712: l_return_status := G_RET_STS_ERROR;
1713: END IF;
1714:
1715: -- Bug#3722445: Overlapping check - not required if later versions are APPROVED. UI will take care of that.

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

1723: -- 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
1724: -- if subsequent version is in draft/rejected or pending approval status, the end date should not overlap.
1725:
1726: if p_end_date IS NULL AND l_highest_version_rec.article_status in ('APPROVED', 'HOLD') THEN
1727: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_END_DATE_NULL');
1728: l_return_status := G_RET_STS_ERROR;
1729: elsif nvl(p_end_date, l_highest_version_rec.start_date-1) >= l_highest_version_rec.start_date then
1730: IF (l_debug = 'Y') THEN
1731: Okc_Debug.Log('1800: - Date overlap with earlier version', 2);

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

1729: elsif nvl(p_end_date, l_highest_version_rec.start_date-1) >= l_highest_version_rec.start_date then
1730: IF (l_debug = 'Y') THEN
1731: Okc_Debug.Log('1800: - Date overlap with earlier version', 2);
1732: END IF;
1733: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_DATE_OVRLP_EARLR_VER');
1734: l_return_status := G_RET_STS_ERROR;
1735: end if;
1736: ELSIF (l_highest_version_rec.start_date >= p_start_date) OR
1737: (nvl(l_highest_version_rec.end_date, p_start_date-1) >= p_start_date) THEN

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

1737: (nvl(l_highest_version_rec.end_date, p_start_date-1) >= p_start_date) THEN
1738: IF (l_debug = 'Y') THEN
1739: Okc_Debug.Log('1800: - Date overlap with earlier version', 2);
1740: END IF;
1741: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_DATE_OVRLP_EARLR_VER');
1742: l_return_status := G_RET_STS_ERROR;
1743: END IF; -- (l_highest_version_rec.start_date >= p_start_date) OR..
1744: END IF; -- IF (l_highest_version_rec.global_yn = 'Y' and p_global_yn = 'N')
1745: --END IF; --IF l_highest_version_rec.article_version_number IS NULL

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

1747: END IF; --IF p_import_action = 'N', l_highest_version_rec.article_version_number IS NULL
1748:
1749: IF p_article_status IN ('HOLD', 'APPROVED') AND
1750: p_date_approved IS NULL THEN
1751: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DATE_APPROVED');
1752: l_return_status := G_RET_STS_ERROR;
1753: END IF;
1754:
1755: -- Bug#3672511: Validation of start date of a localized clause should be >= start date of global clause.

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

1771: ELSIF (l_global_start_date > p_start_date) THEN
1772: IF (l_debug = 'Y') THEN
1773: Okc_Debug.Log('2300: - Start Date is greater than Global Start Date', 2);
1774: END IF;
1775: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_CMP_START_DATE');
1776: l_return_status := G_RET_STS_ERROR;
1777: RETURN l_return_status ;
1778: END IF;
1779: END IF; -- end of if current org id <> global org id

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

1782:
1783: -- fix for bug#4006749 start
1784: -- muteshev
1785: if provision_flag_in_relations(p_article_id, G_CURRENT_ORG_ID, p_provision_yn)='E' then
1786: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INV_RELATION_PROVISION');
1787: l_return_status := G_RET_STS_ERROR;
1788: RETURN l_return_status ;
1789: end if;
1790: -- fix for bug#4006749 end

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

1808: IF (l_debug = 'Y') THEN
1809: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
1810: END IF;
1811:
1812: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1813: p_msg_name => G_UNEXPECTED_ERROR,
1814: p_token1 => G_SQLCODE_TOKEN,
1815: p_token1_value => sqlcode,
1816: p_token2 => G_SQLERRM_TOKEN,

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

2118: if G_CURRENT_ORG_ID IS NULL Then
2119: IF (l_debug = 'Y') THEN
2120: Okc_Debug.Log('2300: - attribute G_CURRENT_ORG_ID is invalid', 2);
2121: END IF;
2122: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');
2123: x_return_status := G_RET_STS_ERROR;
2124: RAISE FND_API.G_EXC_ERROR;
2125: end if;
2126:

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

2212: WHEN OTHERS THEN
2213: IF (l_debug = 'Y') THEN
2214: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
2215: END IF;
2216: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2217: p_msg_name => G_UNEXPECTED_ERROR,
2218: p_token1 => G_SQLCODE_TOKEN,
2219: p_token1_value => sqlcode,
2220: p_token2 => G_SQLERRM_TOKEN,

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

2442: IF (l_debug = 'Y') THEN
2443: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
2444: END IF;
2445:
2446: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2447: p_msg_name => G_UNEXPECTED_ERROR,
2448: p_token1 => G_SQLCODE_TOKEN,
2449: p_token1_value => sqlcode,
2450: p_token2 => G_SQLERRM_TOKEN,

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

2567: if G_CURRENT_ORG_ID IS NULL Then
2568: IF (l_debug = 'Y') THEN
2569: Okc_Debug.Log('2300: - attribute G_CURRENT_ORG_ID is invalid', 2);
2570: END IF;
2571: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');
2572: x_return_status := G_RET_STS_ERROR;
2573: RAISE FND_API.G_EXC_ERROR;
2574: end if;
2575:

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

2745: WHEN OTHERS THEN
2746: IF (l_debug = 'Y') THEN
2747: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
2748: END IF;
2749: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2750: p_msg_name => G_UNEXPECTED_ERROR,
2751: p_token1 => G_SQLCODE_TOKEN,
2752: p_token1_value => sqlcode,
2753: p_token2 => G_SQLERRM_TOKEN,

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

2808:
2809: IF (lock_csr%ISOPEN) THEN
2810: CLOSE lock_csr;
2811: END IF;
2812: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
2813: RETURN( G_RET_STS_ERROR );
2814: END;
2815:
2816: IF ( l_row_notfound ) THEN

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

2821: l_row_notfound := lchk_csr%NOTFOUND;
2822: CLOSE lchk_csr;
2823:
2824: IF (l_row_notfound) THEN
2825: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
2826: ELSIF l_object_version_number > p_object_version_number THEN
2827: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2828: ELSIF l_object_version_number = -1 THEN
2829: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

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

2823:
2824: IF (l_row_notfound) THEN
2825: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
2826: ELSIF l_object_version_number > p_object_version_number THEN
2827: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2828: ELSIF l_object_version_number = -1 THEN
2829: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2830: ELSE -- it can be the only above condition. It can happen after restore version
2831: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

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

2825: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
2826: ELSIF l_object_version_number > p_object_version_number THEN
2827: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2828: ELSIF l_object_version_number = -1 THEN
2829: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2830: ELSE -- it can be the only above condition. It can happen after restore version
2831: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2832: END IF;
2833: ELSE

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

2827: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2828: ELSIF l_object_version_number = -1 THEN
2829: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2830: ELSE -- it can be the only above condition. It can happen after restore version
2831: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2832: END IF;
2833: ELSE
2834: l_return_status := G_RET_STS_SUCCESS;
2835: END IF;

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

2853: IF (l_debug = 'Y') THEN
2854: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
2855: END IF;
2856:
2857: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2858: p_msg_name => G_UNEXPECTED_ERROR,
2859: p_token1 => G_SQLCODE_TOKEN,
2860: p_token1_value => sqlcode,
2861: p_token2 => G_SQLERRM_TOKEN,

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

2915: WHEN OTHERS THEN
2916: IF (l_debug = 'Y') THEN
2917: Okc_Debug.Log('6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
2918: END IF;
2919: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2920: p_msg_name => G_UNEXPECTED_ERROR,
2921: p_token1 => G_SQLCODE_TOKEN,
2922: p_token1_value => sqlcode,
2923: p_token2 => G_SQLERRM_TOKEN,

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

3084: IF (l_debug = 'Y') THEN
3085: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
3086: END IF;
3087:
3088: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3089: p_msg_name => G_UNEXPECTED_ERROR,
3090: p_token1 => G_SQLCODE_TOKEN,
3091: p_token1_value => sqlcode,
3092: p_token2 => G_SQLERRM_TOKEN,

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

3351: if G_CURRENT_ORG_ID IS NULL Then
3352: IF (l_debug = 'Y') THEN
3353: Okc_Debug.Log('2300: - attribute G_CURRENT_ORG_ID is invalid', 2);
3354: END IF;
3355: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');
3356: x_return_status := G_RET_STS_ERROR;
3357: RAISE FND_API.G_EXC_ERROR;
3358: end if;
3359:

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

3533: WHEN OTHERS THEN
3534: IF (l_debug = 'Y') THEN
3535: Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
3536: END IF;
3537: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3538: p_msg_name => G_UNEXPECTED_ERROR,
3539: p_token1 => G_SQLCODE_TOKEN,
3540: p_token1_value => sqlcode,
3541: p_token2 => G_SQLERRM_TOKEN,

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

3574: IF (l_debug = 'Y') THEN
3575: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
3576: END IF;
3577:
3578: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3579: p_msg_name => G_UNEXPECTED_ERROR,
3580: p_token1 => G_SQLCODE_TOKEN,
3581: p_token1_value => sqlcode,
3582: p_token2 => G_SQLERRM_TOKEN,

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

3644: WHEN OTHERS THEN
3645: IF (l_debug = 'Y') THEN
3646: Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
3647: END IF;
3648: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3649: p_msg_name => G_UNEXPECTED_ERROR,
3650: p_token1 => G_SQLCODE_TOKEN,
3651: p_token1_value => sqlcode,
3652: p_token2 => G_SQLERRM_TOKEN,