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

714: WHEN OTHERS THEN
715: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
716: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm);
717: END IF;
718: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
719: p_msg_name => G_UNEXPECTED_ERROR,
720: p_token1 => G_SQLCODE_TOKEN,
721: p_token1_value => sqlcode,
722: p_token2 => G_SQLERRM_TOKEN,

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

845: IF ( p_template_name IS NULL) THEN
846: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
847: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: - attribute TEMPLATE_NAME is invalid');
848: END IF;
849: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'TEMPLATE_NAME');
850: l_return_status := G_RET_STS_ERROR;
851: END IF;
852:
853:

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

870: END IF;
871: IF p_status_code IS NOT NULL THEN
872: l_return_status := Okc_Util.Check_Lookup_Code('OKC_TERMS_TMPL_STATUS',p_status_code);
873: IF (l_return_status <> G_RET_STS_SUCCESS) THEN
874: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'STATUS_CODE');
875: l_return_status := G_RET_STS_ERROR;
876: END IF;
877: END IF;
878:

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

895: IF (l_dummy_var = '?') THEN
896: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
897: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: - attribute TEMPLATE_ID is invalid');
898: END IF;
899: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TEMPLATE_ID');
900: l_return_status := G_RET_STS_ERROR;
901: END IF;
902: END IF;
903: */

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

913: IF (l_dummy_var = '?') THEN
914: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
915: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: - attribute PARENT_TEMPLATE_ID is invalid');
916: END IF;
917: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PARENT_TEMPLATE_ID');
918: l_return_status := G_RET_STS_ERROR;
919: END IF;
920: END IF;
921:

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

952: IF (l_dummy_var = '?') THEN
953: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
954: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: - attribute PRINT_TEMPLATE_ID is invalid');
955: END IF;
956: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PRINT_TEMPLATE_ID');
957: l_return_status := G_RET_STS_ERROR;
958: END IF;
959: END IF;
960:

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

989: IF l_layout_start_date > l_eff_date OR nvl(l_layout_end_date,l_eff_date) < l_eff_date THEN
990: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
991: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: - LAYOUT_TEMPLATE is invalid or end_dated');
992: END IF;
993: Okc_Api.Set_Message(G_APP_NAME,'OKC_LAYOUT_TMPL_INVALID');
994: l_return_status := G_RET_STS_ERROR;
995: END IF;
996: END IF;
997:

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

1007: IF (l_dummy_var = '?') THEN
1008: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1009: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: - attribute TEMPLATE_MODEL_ID is invalid');
1010: END IF;
1011: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TEMPLATE_MODEL_ID');
1012: l_return_status := G_RET_STS_ERROR;
1013: END IF;
1014: END IF;
1015: *****************/

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

1026: IF (l_dummy_var = '?') THEN
1027: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1028: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: - attribute ORG_ID is invalid');
1029: END IF;
1030: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ORG_ID');
1031: l_return_status := G_RET_STS_ERROR;
1032: END IF;
1033: END IF;
1034:

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

1046: WHEN OTHERS THEN
1047: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1048: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm);
1049: END IF;
1050: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1051: p_msg_name => G_UNEXPECTED_ERROR,
1052: p_token1 => G_SQLCODE_TOKEN,
1053: p_token1_value => sqlcode,
1054: p_token2 => G_SQLERRM_TOKEN,

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

1265: IF nvl(TRUNC(p_end_date),TRUNC(p_start_date)) < TRUNC(p_start_date) THEN
1266: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1267: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2810: Start Date > End Date');
1268: END IF;
1269: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_SDATE_GREATER');
1270: l_return_status := G_RET_STS_ERROR;
1271: END IF;
1272:
1273: IF (nvl(p_working_copy_flag,'N') = 'Y' AND p_parent_template_id IS NULL) THEN

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

1273: IF (nvl(p_working_copy_flag,'N') = 'Y' AND p_parent_template_id IS NULL) 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,'2820: Working Copy Flag is Y and Parent_Template_Id is Null');
1276: END IF;
1277: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'PARENT_TEMPALTE_ID');
1278: l_return_status := G_RET_STS_ERROR;
1279: END IF;
1280:
1281: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1288: IF (l_dummy_var = '!') THEN
1289: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1290: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2840: - Template Name Not Unique in the Org');
1291: END IF;
1292: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_DUP_NAME');
1293: l_return_status := G_RET_STS_ERROR;
1294: END IF;
1295: ----MLS for templates
1296:

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

1300: IF (p_translated_from_tmpl_id IS NOT NULL) AND (p_language IS NULL) THEN
1301: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1302: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2860: - Error:Template Language is null when tft is specified');
1303: END IF;
1304: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_LANG_REQUIRED');
1305: l_return_status := G_RET_STS_ERROR;
1306: END IF;
1307:
1308:

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

1317: IF (l_dummy_var = '!') THEN
1318: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1319: 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');
1320: END IF;
1321: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_ALREADY_TRANSLATED');
1322: l_return_status := G_RET_STS_ERROR;
1323: END IF;
1324: END IF;
1325:

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

1335: IF (l_dummy_var = '!') THEN
1336: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1337: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2880: - Error:Template Language removed in a priamry template');
1338: END IF;
1339: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_ALREADY_REFERENCED', 'TMPL1', p_template_name);
1340: l_return_status := G_RET_STS_ERROR;
1341: END IF;
1342: END IF;
1343:

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

1370: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2900: - Error:Template with specified language already exists in the group');
1371: END IF;
1372:
1373: /* Fix for te bug# 4646417. Removed TMPL2 parameter from the set_message call */
1374: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_LANG_EXISTS','TMPL1' , p_template_name);
1375: l_return_status := G_RET_STS_ERROR;
1376: END IF;
1377: END IF;
1378:

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

1401: IF l_tmpl_name_csr%ISOPEN THEN
1402: CLOSE l_tmpl_name_csr;
1403: END IF;
1404:
1405: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1406: p_msg_name => G_UNEXPECTED_ERROR,
1407: p_token1 => G_SQLCODE_TOKEN,
1408: p_token1_value => sqlcode,
1409: p_token2 => G_SQLERRM_TOKEN,

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

1679: WHEN OTHERS THEN
1680: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1681: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm);
1682: END IF;
1683: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1684: p_msg_name => G_UNEXPECTED_ERROR,
1685: p_token1 => G_SQLCODE_TOKEN,
1686: p_token1_value => sqlcode,
1687: p_token2 => G_SQLERRM_TOKEN,

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

1864: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1865: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3800: Leaving Insert_Row:OTHERS Exception');
1866: END IF;
1867:
1868: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1869: p_msg_name => G_UNEXPECTED_ERROR,
1870: p_token1 => G_SQLCODE_TOKEN,
1871: p_token1_value => sqlcode,
1872: p_token2 => G_SQLERRM_TOKEN,

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

2106: WHEN OTHERS THEN
2107: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2108: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm);
2109: END IF;
2110: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2111: p_msg_name => G_UNEXPECTED_ERROR,
2112: p_token1 => G_SQLCODE_TOKEN,
2113: p_token1_value => sqlcode,
2114: p_token2 => G_SQLERRM_TOKEN,

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

2171:
2172: IF (lock_csr%ISOPEN) THEN
2173: CLOSE lock_csr;
2174: END IF;
2175: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
2176: RETURN( G_RET_STS_ERROR );
2177: END;
2178:
2179: IF ( l_row_notfound ) THEN

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

2184: l_row_notfound := lchk_csr%NOTFOUND;
2185: CLOSE lchk_csr;
2186:
2187: IF (l_row_notfound) THEN
2188: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
2189: ELSIF l_object_version_number > p_object_version_number THEN
2190: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2191: ELSIF l_object_version_number = -1 THEN
2192: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

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

2186:
2187: IF (l_row_notfound) THEN
2188: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
2189: ELSIF l_object_version_number > p_object_version_number THEN
2190: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2191: ELSIF l_object_version_number = -1 THEN
2192: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2193: ELSE -- it can be the only above condition. It can happen after restore version
2194: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

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

2188: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
2189: ELSIF l_object_version_number > p_object_version_number THEN
2190: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2191: ELSIF l_object_version_number = -1 THEN
2192: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2193: ELSE -- it can be the only above condition. It can happen after restore version
2194: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2195: END IF;
2196: ELSE

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

2190: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2191: ELSIF l_object_version_number = -1 THEN
2192: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2193: ELSE -- it can be the only above condition. It can happen after restore version
2194: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
2195: END IF;
2196: ELSE
2197: l_return_status := G_RET_STS_SUCCESS;
2198: END IF;

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

2216: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2217: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm);
2218: END IF;
2219:
2220: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2221: p_msg_name => G_UNEXPECTED_ERROR,
2222: p_token1 => G_SQLCODE_TOKEN,
2223: p_token1_value => sqlcode,
2224: p_token2 => G_SQLERRM_TOKEN,

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

2279: WHEN OTHERS THEN
2280: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2281: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm);
2282: END IF;
2283: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2284: p_msg_name => G_UNEXPECTED_ERROR,
2285: p_token1 => G_SQLCODE_TOKEN,
2286: p_token1_value => sqlcode,
2287: p_token2 => G_SQLERRM_TOKEN,

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

2412: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2413: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm);
2414: END IF;
2415:
2416: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2417: p_msg_name => G_UNEXPECTED_ERROR,
2418: p_token1 => G_SQLCODE_TOKEN,
2419: p_token1_value => sqlcode,
2420: p_token2 => G_SQLERRM_TOKEN,

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

2834: WHEN OTHERS THEN
2835: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2836: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm);
2837: END IF;
2838: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2839: p_msg_name => G_UNEXPECTED_ERROR,
2840: p_token1 => G_SQLCODE_TOKEN,
2841: p_token1_value => sqlcode,
2842: p_token2 => G_SQLERRM_TOKEN,

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

2875: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2876: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm);
2877: END IF;
2878:
2879: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2880: p_msg_name => G_UNEXPECTED_ERROR,
2881: p_token1 => G_SQLCODE_TOKEN,
2882: p_token1_value => sqlcode,
2883: p_token2 => G_SQLERRM_TOKEN,

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

2938: IF (l_dummy_var = '!' AND p_delete_parent_yn = 'N') THEN
2939: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2940: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8910: - Error:Template has translated references and cannot be deleted');
2941: END IF;
2942: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_REF_DEL','TMPL1' , l_template_name);
2943: x_return_status := G_RET_STS_ERROR;
2944: RETURN ;
2945: END IF;
2946:

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

3039: WHEN OTHERS THEN
3040: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3041: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm);
3042: END IF;
3043: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3044: p_msg_name => G_UNEXPECTED_ERROR,
3045: p_token1 => G_SQLCODE_TOKEN,
3046: p_token1_value => sqlcode,
3047: p_token2 => G_SQLERRM_TOKEN,