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_ARTICLES_ALL_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_ARTICLES_ALL_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_ARTICLES_ALL_PVT';
31: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
32:
33: ------------------------------------------------------------------------------
34: -- GLOBAL CONSTANTS
35: ------------------------------------------------------------------------------

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

82: IF (l_debug = 'Y') THEN
83: Okc_Debug.Log('300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm, 2);
84: END IF;
85:
86: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
87: p_msg_name => G_UNEXPECTED_ERROR,
88: p_token1 => G_SQLCODE_TOKEN,
89: p_token1_value => sqlcode,
90: p_token2 => G_SQLERRM_TOKEN,

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

247: IF (l_debug = 'Y') THEN
248: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);
249: END IF;
250:
251: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
252: p_msg_name => G_UNEXPECTED_ERROR,
253: p_token1 => G_SQLCODE_TOKEN,
254: p_token1_value => sqlcode,
255: p_token2 => G_SQLERRM_TOKEN,

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

648: WHEN OTHERS THEN
649: IF (l_debug = 'Y') THEN
650: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);
651: END IF;
652: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
653: p_msg_name => G_UNEXPECTED_ERROR,
654: p_token1 => G_SQLCODE_TOKEN,
655: p_token1_value => sqlcode,
656: p_token2 => G_SQLERRM_TOKEN,

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

741: IF ( p_article_id IS NULL) THEN
742: IF (l_debug = 'Y') THEN
743: Okc_Debug.Log('1500: - attribute ARTICLE_ID is invalid', 2);
744: END IF;
745: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_ID');
746: l_return_status := G_RET_STS_ERROR;
747: END IF;
748: ELSIF p_import_action = 'N' AND p_standard_yn = 'Y' AND p_article_number IS NULL THEN
749: -- Check Sequence is defined or not

Line 759: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NUMBER_NOT_PROVIDED');

755: x_doc_sequence_type => l_doc_sequence_type,
756: x_return_status => l_return_status);
757:
758: IF l_return_status <> G_RET_STS_SUCCESS THEN
759: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NUMBER_NOT_PROVIDED');
760: l_return_status := G_RET_STS_ERROR;
761: ELSIF l_doc_sequence_type <> 'A' THEN
762: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NUMBER_NOT_PROVIDED');
763: l_return_status := G_RET_STS_ERROR;

Line 762: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NUMBER_NOT_PROVIDED');

758: IF l_return_status <> G_RET_STS_SUCCESS THEN
759: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NUMBER_NOT_PROVIDED');
760: l_return_status := G_RET_STS_ERROR;
761: ELSIF l_doc_sequence_type <> 'A' THEN
762: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NUMBER_NOT_PROVIDED');
763: l_return_status := G_RET_STS_ERROR;
764: END IF;
765: END IF;
766:

Line 774: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_TITLE');

770: IF ( p_article_title IS NULL) THEN
771: IF (l_debug = 'Y') THEN
772: Okc_Debug.Log('1500: - attribute ARTICLE_TITLE is invalid', 2);
773: END IF;
774: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_TITLE');
775: l_return_status := G_RET_STS_ERROR;
776: END IF;
777:
778: IF (l_debug = 'Y') THEN

Line 785: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ORG_ID');

781: IF ( p_org_id IS NULL) THEN
782: IF (l_debug = 'Y') THEN
783: Okc_Debug.Log('1500: - attribute ORG_ID is invalid', 2);
784: END IF;
785: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ORG_ID');
786: l_return_status := G_RET_STS_ERROR;
787: END IF;
788:
789: IF (l_debug = 'Y') THEN

Line 797: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_NUMBER');

793: IF ( p_article_number IS NULL) THEN
794: IF (l_debug = 'Y') THEN
795: Okc_Debug.Log('1500: - attribute ARTICLE_NUMBER is invalid', 2);
796: END IF;
797: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_NUMBER');
798: l_return_status := G_RET_STS_ERROR;
799: END IF;
800: END IF;
801:

Line 809: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'STANDARD_YN');

805: IF ( p_standard_yn IS NULL) THEN
806: IF (l_debug = 'Y') THEN
807: Okc_Debug.Log('1500: - attribute STANDARD_YN is invalid', 2);
808: END IF;
809: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'STANDARD_YN');
810: l_return_status := G_RET_STS_ERROR;
811: END IF;
812:
813: IF (l_debug = 'Y') THEN

Line 820: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_INTENT');

816: IF ( p_article_intent IS NULL) THEN
817: IF (l_debug = 'Y') THEN
818: Okc_Debug.Log('1500: - attribute ARTICLE_INTENT is invalid', 2);
819: END IF;
820: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_INTENT');
821: l_return_status := G_RET_STS_ERROR;
822: END IF;
823:
824: IF (l_debug = 'Y') THEN

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

827: IF ( p_article_language IS NULL) THEN
828: IF (l_debug = 'Y') THEN
829: Okc_Debug.Log('1500: - attribute ARTICLE_LANGUAGE is invalid', 2);
830: END IF;
831: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_LANGUAGE');
832: l_return_status := G_RET_STS_ERROR;
833: END IF;
834:
835: END IF;

Line 849: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'STANDARD_YN');

845: IF p_standard_yn NOT IN ('Y','N') THEN
846: IF (l_debug = 'Y') THEN
847: Okc_Debug.Log('1800: - attribute STANDARD_YN is invalid', 2);
848: END IF;
849: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'STANDARD_YN');
850: l_return_status := G_RET_STS_ERROR;
851: END IF;
852:
853: IF (l_debug = 'Y') THEN

Line 860: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_INTENT');

856: IF p_article_intent NOT IN ('B','S') THEN
857: IF (l_debug = 'Y') THEN
858: Okc_Debug.Log('1800: - attribute ARTICLE_INTENT is invalid', 2);
859: END IF;
860: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_INTENT');
861: l_return_status := G_RET_STS_ERROR;
862: END IF;
863:
864: -- Modified

Line 892: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INVALID_TYPE');

888: IF (l_dummy_var = '?') THEN
889: IF (l_debug = 'Y') THEN
890: Okc_Debug.Log('2300: - attribute ARTICLE_TYPE is invalid for non-std clause', 2);
891: END IF;
892: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INVALID_TYPE');
893: l_return_status := G_RET_STS_ERROR;
894: END IF;
895: ELSIF p_standard_yn = 'Y' THEN
896: l_tmp_return_status := Okc_Util.Check_Lookup_Code('OKC_SUBJECT',p_article_type);

Line 901: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INVALID_TYPE');

897: IF (l_tmp_return_status <> G_RET_STS_SUCCESS) THEN
898: IF (l_debug = 'Y') THEN
899: Okc_Debug.Log('2300: - attribute ARTICLE_TYPE is invalid for std clause', 2);
900: END IF;
901: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INVALID_TYPE');
902: l_return_status := G_RET_STS_ERROR;
903: END IF;
904: END IF;
905:

Line 930: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ORG_ID');

926: IF (l_dummy_var = '?') THEN
927: IF (l_debug = 'Y') THEN
928: Okc_Debug.Log('2300: - attribute ORG_ID is invalid', 2);
929: END IF;
930: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ORG_ID');
931: l_return_status := G_RET_STS_ERROR;
932: END IF;
933: END IF;
934: IF (l_debug = 'Y') THEN

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

943: IF (l_dummy_var = '?') THEN
944: IF (l_debug = 'Y') THEN
945: Okc_Debug.Log('2300: - attribute ARTICLE_LANGAUGE is invalid', 2);
946: END IF;
947: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ARTICLE_LANGAUGE');
948: l_return_status := G_RET_STS_ERROR;
949: END IF;
950: END IF;
951:

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

961:
962: EXCEPTION
963: WHEN OTHERS THEN
964: Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
965: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
966: p_msg_name => G_UNEXPECTED_ERROR,
967: p_token1 => G_SQLCODE_TOKEN,
968: p_token1_value => sqlcode,
969: p_token2 => G_SQLERRM_TOKEN,

Line 1121: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_TYPE');

1117: IF (l_debug = 'Y') THEN
1118: Okc_Debug.Log('1300: - attribute ARTICLE_TYPE is null for standard article', 2);
1119: END IF;
1120: --dbms_output.put_line('attribute ARTICLE_TYPE is null for standard article');
1121: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_TYPE');
1122: l_return_status := G_RET_STS_ERROR;
1123: END IF;
1124: l_dummy_var := '?';
1125:

Line 1138: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_DUP_TITLE_ORG');

1134: IF (l_row_found) THEN -- Duplicates exist
1135: IF (l_debug = 'Y') THEN
1136: Okc_Debug.Log('1300: - attribute ARTICLE_TITLE is not unique for org ', 2);
1137: END IF;
1138: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_DUP_TITLE_ORG');
1139: l_return_status := G_RET_STS_ERROR;
1140: END IF;
1141: END IF;
1142: END IF;

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

1155: IF (l_debug = 'Y') THEN
1156: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
1157: END IF;
1158:
1159: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1160: p_msg_name => G_UNEXPECTED_ERROR,
1161: p_token1 => G_SQLCODE_TOKEN,
1162: p_token1_value => sqlcode,
1163: p_token2 => G_SQLERRM_TOKEN,

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

1427: WHEN OTHERS THEN
1428: IF (l_debug = 'Y') THEN
1429: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
1430: END IF;
1431: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1432: p_msg_name => G_UNEXPECTED_ERROR,
1433: p_token1 => G_SQLCODE_TOKEN,
1434: p_token1_value => sqlcode,
1435: p_token2 => G_SQLERRM_TOKEN,

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

1609: IF (l_debug = 'Y') THEN
1610: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
1611: END IF;
1612:
1613: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1614: p_msg_name => G_UNEXPECTED_ERROR,
1615: p_token1 => G_SQLCODE_TOKEN,
1616: p_token1_value => sqlcode,
1617: p_token2 => G_SQLERRM_TOKEN,

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

1827: WHEN OTHERS THEN
1828: IF (l_debug = 'Y') THEN
1829: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
1830: END IF;
1831: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1832: p_msg_name => G_UNEXPECTED_ERROR,
1833: p_token1 => G_SQLCODE_TOKEN,
1834: p_token1_value => sqlcode,
1835: p_token2 => G_SQLERRM_TOKEN,

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

1891:
1892: IF (lock_csr%ISOPEN) THEN
1893: CLOSE lock_csr;
1894: END IF;
1895: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
1896: RETURN( G_RET_STS_ERROR );
1897: END;
1898:
1899: IF ( l_row_notfound ) THEN

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

1904: l_row_notfound := lchk_csr%NOTFOUND;
1905: CLOSE lchk_csr;
1906:
1907: IF (l_row_notfound) THEN
1908: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
1909: ELSIF l_object_version_number > p_object_version_number THEN
1910: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1911: ELSIF l_object_version_number = -1 THEN
1912: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

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

1906:
1907: IF (l_row_notfound) THEN
1908: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
1909: ELSIF l_object_version_number > p_object_version_number THEN
1910: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1911: ELSIF l_object_version_number = -1 THEN
1912: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1913: ELSE -- it can be the only above condition. It can happen after restore version
1914: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

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

1908: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
1909: ELSIF l_object_version_number > p_object_version_number THEN
1910: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1911: ELSIF l_object_version_number = -1 THEN
1912: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1913: ELSE -- it can be the only above condition. It can happen after restore version
1914: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1915: END IF;
1916: ELSE

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

1910: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1911: ELSIF l_object_version_number = -1 THEN
1912: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1913: ELSE -- it can be the only above condition. It can happen after restore version
1914: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1915: END IF;
1916: ELSE
1917: l_return_status := G_RET_STS_SUCCESS;
1918: END IF;

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

1936: IF (l_debug = 'Y') THEN
1937: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1938: END IF;
1939:
1940: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1941: p_msg_name => G_UNEXPECTED_ERROR,
1942: p_token1 => G_SQLCODE_TOKEN,
1943: p_token1_value => sqlcode,
1944: p_token2 => G_SQLERRM_TOKEN,

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

1998: WHEN OTHERS THEN
1999: IF (l_debug = 'Y') THEN
2000: Okc_Debug.Log('6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
2001: END IF;
2002: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2003: p_msg_name => G_UNEXPECTED_ERROR,
2004: p_token1 => G_SQLCODE_TOKEN,
2005: p_token1_value => sqlcode,
2006: p_token2 => G_SQLERRM_TOKEN,

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

2143: IF (l_debug = 'Y') THEN
2144: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
2145: END IF;
2146:
2147: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2148: p_msg_name => G_UNEXPECTED_ERROR,
2149: p_token1 => G_SQLCODE_TOKEN,
2150: p_token1_value => sqlcode,
2151: p_token2 => G_SQLERRM_TOKEN,

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

2470: WHEN OTHERS THEN
2471: IF (l_debug = 'Y') THEN
2472: Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
2473: END IF;
2474: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2475: p_msg_name => G_UNEXPECTED_ERROR,
2476: p_token1 => G_SQLCODE_TOKEN,
2477: p_token1_value => sqlcode,
2478: p_token2 => G_SQLERRM_TOKEN,

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

2511: IF (l_debug = 'Y') THEN
2512: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
2513: END IF;
2514:
2515: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2516: p_msg_name => G_UNEXPECTED_ERROR,
2517: p_token1 => G_SQLCODE_TOKEN,
2518: p_token1_value => sqlcode,
2519: p_token2 => G_SQLERRM_TOKEN,

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

2581: WHEN OTHERS THEN
2582: IF (l_debug = 'Y') THEN
2583: Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
2584: END IF;
2585: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2586: p_msg_name => G_UNEXPECTED_ERROR,
2587: p_token1 => G_SQLCODE_TOKEN,
2588: p_token1_value => sqlcode,
2589: p_token2 => G_SQLERRM_TOKEN,