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_TERMS_SECTIONS_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: G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;

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: G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;
20: ---------------------------------------------------------------------------

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: G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;
20: ---------------------------------------------------------------------------
21: -- VALIDATION LEVELS

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: G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;
20: ---------------------------------------------------------------------------
21: -- VALIDATION LEVELS
22: ---------------------------------------------------------------------------

Line 19: G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;

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: G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;
20: ---------------------------------------------------------------------------
21: -- VALIDATION LEVELS
22: ---------------------------------------------------------------------------
23: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;

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

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

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

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

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

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

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

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

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

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

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

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

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

101: FND_LOG.STRING(G_EXCP_LEVEL,
102: G_PKG_NAME, '300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm );
103: END IF;
104:
105: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
106: p_msg_name => G_UNEXPECTED_ERROR,
107: p_token1 => G_SQLCODE_TOKEN,
108: p_token1_value => sqlcode,
109: p_token2 => G_SQLERRM_TOKEN,

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

287: FND_LOG.STRING(G_EXCP_LEVEL,
288: G_PKG_NAME, '600: Leaving get_rec because of EXCEPTION: '||sqlerrm);
289: END IF;
290:
291: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
292: p_msg_name => G_UNEXPECTED_ERROR,
293: p_token1 => G_SQLCODE_TOKEN,
294: p_token1_value => sqlcode,
295: p_token2 => G_SQLERRM_TOKEN,

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

691: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
692: FND_LOG.STRING(G_EXCP_LEVEL,
693: G_PKG_NAME, '1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm);
694: END IF;
695: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
696: p_msg_name => G_UNEXPECTED_ERROR,
697: p_token1 => G_SQLCODE_TOKEN,
698: p_token1_value => sqlcode,
699: p_token2 => G_SQLERRM_TOKEN,

Line 796: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ID');

792: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
793: FND_LOG.STRING(G_PROC_LEVEL,
794: G_PKG_NAME, '1500: - attribute ID is invalid' );
795: END IF;
796: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ID');
797: l_return_status := G_RET_STS_ERROR;
798: END IF;
799:
800: /*IF (l_debug = 'Y') THEN

Line 817: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DOCUMENT_TYPE');

813: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
814: FND_LOG.STRING(G_PROC_LEVEL,
815: G_PKG_NAME, '1500: - attribute DOCUMENT_TYPE is invalid' );
816: END IF;
817: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DOCUMENT_TYPE');
818: l_return_status := G_RET_STS_ERROR;
819: END IF;
820:
821: /*IF (l_debug = 'Y') THEN

Line 838: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DOCUMENT_ID');

834: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
835: FND_LOG.STRING(G_PROC_LEVEL,
836: G_PKG_NAME, '1500: - attribute DOCUMENT_ID is invalid' );
837: END IF;
838: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DOCUMENT_ID');
839: l_return_status := G_RET_STS_ERROR;
840: END IF;
841:
842: /*IF (l_debug = 'Y') THEN

Line 859: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'SECTION_SEQUENCE');

855: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
856: FND_LOG.STRING(G_PROC_LEVEL,
857: G_PKG_NAME, '1500: - attribute SECTION_SEQUENCE is invalid' );
858: END IF;
859: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'SECTION_SEQUENCE');
860: l_return_status := G_RET_STS_ERROR;
861: END IF;
862:
863: END IF;

Line 892: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'PRINT_YN');

888: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
889: FND_LOG.STRING(G_PROC_LEVEL,
890: G_PKG_NAME, '1800: - attribute PRINT_YN is invalid' );
891: END IF;
892: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'PRINT_YN');
893: l_return_status := G_RET_STS_ERROR;
894: END IF;
895:
896: END IF;

Line 923: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'SCN_CODE');

919:
920: IF p_scn_code IS NOT NULL THEN
921: l_return_status := Okc_Util.Check_Lookup_Code('OKC_ARTICLE_SECTION',p_scn_code);
922: IF (l_return_status <> G_RET_STS_SUCCESS) THEN
923: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'SCN_CODE');
924: l_return_status := G_RET_STS_ERROR;
925: END IF;
926: END IF;
927: */

Line 940: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'AMENDMENT_OPERATION_CODE');

936: END IF;
937: IF p_amendment_operation_code IS NOT NULL THEN
938: l_return_status := Okc_Util.Check_Lookup_Code('OKC_AMEND_OPN_CODE',p_amendment_operation_code);
939: IF (l_return_status <> G_RET_STS_SUCCESS) THEN
940: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'AMENDMENT_OPERATION_CODE');
941: l_return_status := G_RET_STS_ERROR;
942: END IF;
943: END IF;
944:

Line 981: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DOCUMENT_TYPE');

977: FND_LOG.STRING(G_PROC_LEVEL,
978: G_PKG_NAME, '2300: - attribute DOCUMENT_TYPE is invalid' );
979: END IF;
980:
981: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DOCUMENT_TYPE');
982: l_return_status := G_RET_STS_ERROR;
983: END IF;
984: END IF;
985:

Line 1009: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SCN_ID');

1005: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1006: FND_LOG.STRING(G_PROC_LEVEL,
1007: G_PKG_NAME, '2300: - attribute SCN_ID is invalid' );
1008: END IF;
1009: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SCN_ID');
1010: l_return_status := G_RET_STS_ERROR;
1011: END IF;
1012: END IF;
1013:

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

1031: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1032: FND_LOG.STRING(G_EXCP_LEVEL,
1033: G_PKG_NAME, '2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm);
1034: END IF;
1035: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1036: p_msg_name => G_UNEXPECTED_ERROR,
1037: p_token1 => G_SQLCODE_TOKEN,
1038: p_token1_value => sqlcode,
1039: p_token2 => G_SQLERRM_TOKEN,

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

1192: FND_LOG.STRING(G_EXCP_LEVEL,
1193: G_PKG_NAME, '3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm );
1194: END IF;
1195:
1196: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1197: p_msg_name => G_UNEXPECTED_ERROR,
1198: p_token1 => G_SQLCODE_TOKEN,
1199: p_token1_value => sqlcode,
1200: p_token2 => G_SQLERRM_TOKEN,

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

1451: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1452: FND_LOG.STRING(G_EXCP_LEVEL,
1453: G_PKG_NAME, '3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm);
1454: END IF;
1455: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1456: p_msg_name => G_UNEXPECTED_ERROR,
1457: p_token1 => G_SQLCODE_TOKEN,
1458: p_token1_value => sqlcode,
1459: p_token2 => G_SQLERRM_TOKEN,

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

1638: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1639: FND_LOG.STRING(G_EXCP_LEVEL,
1640: G_PKG_NAME, '3800: Leaving Insert_Row:OTHERS Exception' );
1641: END IF;
1642: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1643: p_msg_name => G_UNEXPECTED_ERROR,
1644: p_token1 => G_SQLCODE_TOKEN,
1645: p_token1_value => sqlcode,
1646: p_token2 => G_SQLERRM_TOKEN,

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

1888: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1889: FND_LOG.STRING(G_EXCP_LEVEL,
1890: G_PKG_NAME, '4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm);
1891: END IF;
1892: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1893: p_msg_name => G_UNEXPECTED_ERROR,
1894: p_token1 => G_SQLCODE_TOKEN,
1895: p_token1_value => sqlcode,
1896: p_token2 => G_SQLERRM_TOKEN,

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

1959:
1960: IF (lock_csr%ISOPEN) THEN
1961: CLOSE lock_csr;
1962: END IF;
1963: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
1964: RETURN( G_RET_STS_ERROR );
1965: END;
1966:
1967: IF ( l_row_notfound ) THEN

Line 1976: Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,

1972: l_row_notfound := lchk_csr%NOTFOUND;
1973: CLOSE lchk_csr;
1974:
1975: IF (l_row_notfound) THEN
1976: Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
1977: 'ENTITYNAME','OKC_SECTIONS_B',
1978: 'PKEY',p_id,
1979: 'OVN',p_object_version_number
1980: );

Line 1982: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);

1978: 'PKEY',p_id,
1979: 'OVN',p_object_version_number
1980: );
1981: ELSIF l_object_version_number > p_object_version_number THEN
1982: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1983: ELSIF l_object_version_number = -1 THEN
1984: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1985: ELSE -- it can be the only above condition. It can happen after restore version
1986: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);

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

1980: );
1981: ELSIF l_object_version_number > p_object_version_number THEN
1982: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1983: ELSIF l_object_version_number = -1 THEN
1984: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1985: ELSE -- it can be the only above condition. It can happen after restore version
1986: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1987: END IF;
1988: ELSE

Line 1986: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);

1982: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1983: ELSIF l_object_version_number = -1 THEN
1984: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1985: ELSE -- it can be the only above condition. It can happen after restore version
1986: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1987: END IF;
1988: ELSE
1989: l_return_status := G_RET_STS_SUCCESS;
1990: END IF;

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

2018: FND_LOG.STRING(G_PROC_LEVEL,
2019: G_PKG_NAME, '5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm);
2020: END IF;
2021:
2022: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2023: p_msg_name => G_UNEXPECTED_ERROR,
2024: p_token1 => G_SQLCODE_TOKEN,
2025: p_token1_value => sqlcode,
2026: p_token2 => G_SQLERRM_TOKEN,

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

2104: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2105: FND_LOG.STRING(G_EXCP_LEVEL,
2106: G_PKG_NAME, '6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm );
2107: END IF;
2108: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2109: p_msg_name => G_UNEXPECTED_ERROR,
2110: p_token1 => G_SQLCODE_TOKEN,
2111: p_token1_value => sqlcode,
2112: p_token2 => G_SQLERRM_TOKEN,

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

2242: FND_LOG.STRING(G_EXCP_LEVEL,
2243: G_PKG_NAME, '6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm);
2244: END IF;
2245:
2246: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2247: p_msg_name => G_UNEXPECTED_ERROR,
2248: p_token1 => G_SQLCODE_TOKEN,
2249: p_token1_value => sqlcode,
2250: p_token2 => G_SQLERRM_TOKEN,

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

2621: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2622: FND_LOG.STRING(G_EXCP_LEVEL,
2623: G_PKG_NAME, '8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm);
2624: END IF;
2625: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2626: p_msg_name => G_UNEXPECTED_ERROR,
2627: p_token1 => G_SQLCODE_TOKEN,
2628: p_token1_value => sqlcode,
2629: p_token2 => G_SQLERRM_TOKEN,

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

2677: FND_LOG.STRING(G_EXCP_LEVEL,
2678: G_PKG_NAME, '8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );
2679: END IF;
2680:
2681: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2682: p_msg_name => G_UNEXPECTED_ERROR,
2683: p_token1 => G_SQLCODE_TOKEN,
2684: p_token1_value => sqlcode,
2685: p_token2 => G_SQLERRM_TOKEN,

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

2777: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2778: FND_LOG.STRING(G_EXCP_LEVEL,
2779: G_PKG_NAME, '9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm);
2780: END IF;
2781: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2782: p_msg_name => G_UNEXPECTED_ERROR,
2783: p_token1 => G_SQLCODE_TOKEN,
2784: p_token1_value => sqlcode,
2785: p_token2 => G_SQLERRM_TOKEN,

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

2853:
2854: IF (lock_csr%ISOPEN) THEN
2855: CLOSE lock_csr;
2856: END IF;
2857: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
2858: x_return_status := G_RET_STS_ERROR ;
2859:
2860: WHEN FND_API.G_EXC_ERROR THEN
2861: /*IF (l_debug = 'Y') THEN

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

2899:
2900: IF (lock_csr%ISOPEN) THEN
2901: CLOSE lock_csr;
2902: END IF;
2903: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2904: p_msg_name => G_UNEXPECTED_ERROR,
2905: p_token1 => G_SQLCODE_TOKEN,
2906: p_token1_value => sqlcode,
2907: p_token2 => G_SQLERRM_TOKEN,

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

3050: FND_LOG.STRING(G_EXCP_LEVEL,
3051: G_PKG_NAME, '10100: Leaving create_version because of EXCEPTION: '||sqlerrm );
3052: END IF;
3053:
3054: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3055: p_msg_name => G_UNEXPECTED_ERROR,
3056: p_token1 => G_SQLCODE_TOKEN,
3057: p_token1_value => sqlcode,
3058: p_token2 => G_SQLERRM_TOKEN,

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

3200: FND_LOG.STRING(G_EXCP_LEVEL,
3201: G_PKG_NAME, '10600: Leaving restore_version because of EXCEPTION: '||sqlerrm);
3202: END IF;
3203:
3204: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3205: p_msg_name => G_UNEXPECTED_ERROR,
3206: p_token1 => G_SQLCODE_TOKEN,
3207: p_token1_value => sqlcode,
3208: p_token2 => G_SQLERRM_TOKEN,

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

3261: FND_LOG.STRING(G_EXCP_LEVEL,
3262: G_PKG_NAME, '7400: Leaving Delete_Version because of EXCEPTION: '||sqlerrm );
3263: END IF;
3264:
3265: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3266: p_msg_name => G_UNEXPECTED_ERROR,
3267: p_token1 => G_SQLCODE_TOKEN,
3268: p_token1_value => sqlcode,
3269: p_token2 => G_SQLERRM_TOKEN,