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.

[Home] [Help]

APPS.OKC_TERMS_TEMPLATES_PVT dependencies on OKC_API

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

27: -- GLOBAL VARIABLES
28: ---------------------------------------------------------------------------
29: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMTMPL_PVT';
30: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||G_PKG_NAME||'.';
31: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
32:
33: ------------------------------------------------------------------------------
34: -- GLOBAL CONSTANTS
35: ------------------------------------------------------------------------------

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

81: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
82: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm);
83: END IF;
84:
85: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
86: p_msg_name => G_UNEXPECTED_ERROR,
87: p_token1 => G_SQLCODE_TOKEN,
88: p_token1_value => sqlcode,
89: p_token2 => G_SQLERRM_TOKEN,

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

276: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
277: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving get_rec because of EXCEPTION: '||sqlerrm);
278: END IF;
279:
280: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
281: p_msg_name => G_UNEXPECTED_ERROR,
282: p_token1 => G_SQLCODE_TOKEN,
283: p_token1_value => sqlcode,
284: p_token2 => G_SQLERRM_TOKEN,

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

722: WHEN OTHERS THEN
723: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
724: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm);
725: END IF;
726: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
727: p_msg_name => G_UNEXPECTED_ERROR,
728: p_token1 => G_SQLCODE_TOKEN,
729: p_token1_value => sqlcode,
730: p_token2 => G_SQLERRM_TOKEN,

Line 857: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'TEMPLATE_NAME');

853: IF ( p_template_name IS NULL) THEN
854: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
855: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: - attribute TEMPLATE_NAME is invalid');
856: END IF;
857: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'TEMPLATE_NAME');
858: l_return_status := G_RET_STS_ERROR;
859: END IF;
860:
861:

Line 882: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'STATUS_CODE');

878: END IF;
879: IF p_status_code IS NOT NULL THEN
880: l_return_status := Okc_Util.Check_Lookup_Code('OKC_TERMS_TMPL_STATUS',p_status_code);
881: IF (l_return_status <> G_RET_STS_SUCCESS) THEN
882: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'STATUS_CODE');
883: l_return_status := G_RET_STS_ERROR;
884: END IF;
885: END IF;
886:

Line 907: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TEMPLATE_ID');

903: IF (l_dummy_var = '?') THEN
904: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
905: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: - attribute TEMPLATE_ID is invalid');
906: END IF;
907: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TEMPLATE_ID');
908: l_return_status := G_RET_STS_ERROR;
909: END IF;
910: END IF;
911: */

Line 925: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PARENT_TEMPLATE_ID');

921: IF (l_dummy_var = '?') THEN
922: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
923: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: - attribute PARENT_TEMPLATE_ID is invalid');
924: END IF;
925: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PARENT_TEMPLATE_ID');
926: l_return_status := G_RET_STS_ERROR;
927: END IF;
928: END IF;
929:

Line 964: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PRINT_TEMPLATE_ID');

960: IF (l_dummy_var = '?') THEN
961: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
962: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: - attribute PRINT_TEMPLATE_ID is invalid');
963: END IF;
964: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PRINT_TEMPLATE_ID');
965: l_return_status := G_RET_STS_ERROR;
966: END IF;
967: END IF;
968:

Line 1001: Okc_Api.Set_Message(G_APP_NAME,'OKC_LAYOUT_TMPL_INVALID');

997: IF l_layout_start_date > l_eff_date OR nvl(l_layout_end_date,l_eff_date) < l_eff_date THEN
998: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
999: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: - LAYOUT_TEMPLATE is invalid or end_dated');
1000: END IF;
1001: Okc_Api.Set_Message(G_APP_NAME,'OKC_LAYOUT_TMPL_INVALID');
1002: l_return_status := G_RET_STS_ERROR;
1003: END IF;
1004: END IF;
1005:

Line 1019: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TEMPLATE_MODEL_ID');

1015: IF (l_dummy_var = '?') THEN
1016: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1017: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: - attribute TEMPLATE_MODEL_ID is invalid');
1018: END IF;
1019: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TEMPLATE_MODEL_ID');
1020: l_return_status := G_RET_STS_ERROR;
1021: END IF;
1022: END IF;
1023: *****************/

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

1034: IF (l_dummy_var = '?') THEN
1035: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1036: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: - attribute ORG_ID is invalid');
1037: END IF;
1038: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ORG_ID');
1039: l_return_status := G_RET_STS_ERROR;
1040: END IF;
1041: END IF;
1042:

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

1054: WHEN OTHERS THEN
1055: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1056: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm);
1057: END IF;
1058: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1059: p_msg_name => G_UNEXPECTED_ERROR,
1060: p_token1 => G_SQLCODE_TOKEN,
1061: p_token1_value => sqlcode,
1062: p_token2 => G_SQLERRM_TOKEN,

Line 1277: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_SDATE_GREATER');

1273: IF nvl(TRUNC(p_end_date),TRUNC(p_start_date)) < TRUNC(p_start_date) THEN
1274: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1275: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2810: Start Date > End Date');
1276: END IF;
1277: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_SDATE_GREATER');
1278: l_return_status := G_RET_STS_ERROR;
1279: END IF;
1280:
1281: IF (nvl(p_working_copy_flag,'N') = 'Y' AND p_parent_template_id IS NULL) THEN

Line 1285: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'PARENT_TEMPALTE_ID');

1281: IF (nvl(p_working_copy_flag,'N') = 'Y' AND p_parent_template_id IS NULL) THEN
1282: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1283: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2820: Working Copy Flag is Y and Parent_Template_Id is Null');
1284: END IF;
1285: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'PARENT_TEMPALTE_ID');
1286: l_return_status := G_RET_STS_ERROR;
1287: END IF;
1288:
1289: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1300: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_DUP_NAME');

1296: IF (l_dummy_var = '!') THEN
1297: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1298: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2840: - Template Name Not Unique in the Org');
1299: END IF;
1300: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_DUP_NAME');
1301: l_return_status := G_RET_STS_ERROR;
1302: END IF;
1303: ----MLS for templates
1304:

Line 1312: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_LANG_REQUIRED');

1308: IF (p_translated_from_tmpl_id IS NOT NULL) AND (p_language IS NULL) THEN
1309: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1310: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2860: - Error:Template Language is null when tft is specified');
1311: END IF;
1312: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_LANG_REQUIRED');
1313: l_return_status := G_RET_STS_ERROR;
1314: END IF;
1315:
1316:

Line 1329: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_ALREADY_TRANSLATED');

1325: IF (l_dummy_var = '!') THEN
1326: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1327: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2868: - Error:User adding tft for a template which alreay has children pointing to it');
1328: END IF;
1329: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_ALREADY_TRANSLATED');
1330: l_return_status := G_RET_STS_ERROR;
1331: END IF;
1332: END IF;
1333:

Line 1347: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_ALREADY_REFERENCED', 'TMPL1', p_template_name);

1343: IF (l_dummy_var = '!') THEN
1344: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1345: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2880: - Error:Template Language removed in a priamry template');
1346: END IF;
1347: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_ALREADY_REFERENCED', 'TMPL1', p_template_name);
1348: l_return_status := G_RET_STS_ERROR;
1349: END IF;
1350: END IF;
1351:

Line 1382: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_LANG_EXISTS','TMPL1' , p_template_name);

1378: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2900: - Error:Template with specified language already exists in the group');
1379: END IF;
1380:
1381: /* Fix for te bug# 4646417. Removed TMPL2 parameter from the set_message call */
1382: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_LANG_EXISTS','TMPL1' , p_template_name);
1383: l_return_status := G_RET_STS_ERROR;
1384: END IF;
1385: END IF;
1386:

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

1409: IF l_tmpl_name_csr%ISOPEN THEN
1410: CLOSE l_tmpl_name_csr;
1411: END IF;
1412:
1413: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1414: p_msg_name => G_UNEXPECTED_ERROR,
1415: p_token1 => G_SQLCODE_TOKEN,
1416: p_token1_value => sqlcode,
1417: p_token2 => G_SQLERRM_TOKEN,

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

1691: WHEN OTHERS THEN
1692: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1693: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm);
1694: END IF;
1695: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1696: p_msg_name => G_UNEXPECTED_ERROR,
1697: p_token1 => G_SQLCODE_TOKEN,
1698: p_token1_value => sqlcode,
1699: p_token2 => G_SQLERRM_TOKEN,

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

1880: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1881: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3800: Leaving Insert_Row:OTHERS Exception');
1882: END IF;
1883:
1884: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1885: p_msg_name => G_UNEXPECTED_ERROR,
1886: p_token1 => G_SQLCODE_TOKEN,
1887: p_token1_value => sqlcode,
1888: p_token2 => G_SQLERRM_TOKEN,

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

2123: WHEN OTHERS THEN
2124: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2125: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm);
2126: END IF;
2127: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2128: p_msg_name => G_UNEXPECTED_ERROR,
2129: p_token1 => G_SQLCODE_TOKEN,
2130: p_token1_value => sqlcode,
2131: p_token2 => G_SQLERRM_TOKEN,

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

2188:
2189: IF (lock_csr%ISOPEN) THEN
2190: CLOSE lock_csr;
2191: END IF;
2192: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
2193: RETURN( G_RET_STS_ERROR );
2194: END;
2195:
2196: IF ( l_row_notfound ) THEN

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

2201: l_row_notfound := lchk_csr%NOTFOUND;
2202: CLOSE lchk_csr;
2203:
2204: IF (l_row_notfound) THEN
2205: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
2206: ELSIF l_object_version_number > p_object_version_number THEN
2207: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2208: ELSIF l_object_version_number = -1 THEN
2209: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

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

2203:
2204: IF (l_row_notfound) THEN
2205: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
2206: ELSIF l_object_version_number > p_object_version_number THEN
2207: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2208: ELSIF l_object_version_number = -1 THEN
2209: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2210: ELSE -- it can be the only above condition. It can happen after restore version
2211: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

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

2205: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
2206: ELSIF l_object_version_number > p_object_version_number THEN
2207: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2208: ELSIF l_object_version_number = -1 THEN
2209: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2210: ELSE -- it can be the only above condition. It can happen after restore version
2211: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2212: END IF;
2213: ELSE

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

2207: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2208: ELSIF l_object_version_number = -1 THEN
2209: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2210: ELSE -- it can be the only above condition. It can happen after restore version
2211: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2212: END IF;
2213: ELSE
2214: l_return_status := G_RET_STS_SUCCESS;
2215: END IF;

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

2233: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2234: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm);
2235: END IF;
2236:
2237: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2238: p_msg_name => G_UNEXPECTED_ERROR,
2239: p_token1 => G_SQLCODE_TOKEN,
2240: p_token1_value => sqlcode,
2241: p_token2 => G_SQLERRM_TOKEN,

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

2296: WHEN OTHERS THEN
2297: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2298: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm);
2299: END IF;
2300: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2301: p_msg_name => G_UNEXPECTED_ERROR,
2302: p_token1 => G_SQLCODE_TOKEN,
2303: p_token1_value => sqlcode,
2304: p_token2 => G_SQLERRM_TOKEN,

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

2431: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2432: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm);
2433: END IF;
2434:
2435: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2436: p_msg_name => G_UNEXPECTED_ERROR,
2437: p_token1 => G_SQLCODE_TOKEN,
2438: p_token1_value => sqlcode,
2439: p_token2 => G_SQLERRM_TOKEN,

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

2857: WHEN OTHERS THEN
2858: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2859: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm);
2860: END IF;
2861: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2862: p_msg_name => G_UNEXPECTED_ERROR,
2863: p_token1 => G_SQLCODE_TOKEN,
2864: p_token1_value => sqlcode,
2865: p_token2 => G_SQLERRM_TOKEN,

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

2898: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2899: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm);
2900: END IF;
2901:
2902: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2903: p_msg_name => G_UNEXPECTED_ERROR,
2904: p_token1 => G_SQLCODE_TOKEN,
2905: p_token1_value => sqlcode,
2906: p_token2 => G_SQLERRM_TOKEN,

Line 2965: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_REF_DEL','TMPL1' , l_template_name);

2961: IF (l_dummy_var = '!' AND p_delete_parent_yn = 'N') THEN
2962: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2963: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8910: - Error:Template has translated references and cannot be deleted');
2964: END IF;
2965: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_REF_DEL','TMPL1' , l_template_name);
2966: x_return_status := G_RET_STS_ERROR;
2967: RETURN ;
2968: END IF;
2969:

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

3062: WHEN OTHERS THEN
3063: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3064: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm);
3065: END IF;
3066: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3067: p_msg_name => G_UNEXPECTED_ERROR,
3068: p_token1 => G_SQLCODE_TOKEN,
3069: p_token1_value => sqlcode,
3070: p_token2 => G_SQLERRM_TOKEN,