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

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

150: FND_LOG.STRING(G_PROC_LEVEL,
151: G_PKG_NAME, '600: Leaving get_rec because of EXCEPTION: '||sqlerrm );
152: END IF;
153:
154: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
155: p_msg_name => G_UNEXPECTED_ERROR,
156: p_token1 => G_SQLCODE_TOKEN,
157: p_token1_value => sqlcode,
158: p_token2 => G_SQLERRM_TOKEN,

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

313: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
314: FND_LOG.STRING(G_PROC_LEVEL,
315: G_PKG_NAME, '1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm );
316: END IF;
317: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
318: p_msg_name => G_UNEXPECTED_ERROR,
319: p_token1 => G_SQLCODE_TOKEN,
320: p_token1_value => sqlcode,
321: p_token2 => G_SQLERRM_TOKEN,

Line 397: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'CAT_ID');

393: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
394: FND_LOG.STRING(G_PROC_LEVEL,
395: G_PKG_NAME, '1500: - attribute CAT_ID is invalid' );
396: END IF;
397: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'CAT_ID');
398: l_return_status := G_RET_STS_ERROR;
399: END IF;
400:
401: /*IF (l_debug = 'Y') THEN

Line 418: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'VARIABLE_CODE');

414: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
415: FND_LOG.STRING(G_PROC_LEVEL,
416: G_PKG_NAME, '1500: - attribute VARIABLE_CODE is invalid' );
417: END IF;
418: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'VARIABLE_CODE');
419: l_return_status := G_RET_STS_ERROR;
420: END IF;
421:
422: /*IF (l_debug = 'Y') THEN

Line 439: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'VARIABLE_TYPE');

435: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
436: FND_LOG.STRING(G_PROC_LEVEL,
437: G_PKG_NAME, '1500: - attribute VARIABLE_TYPE is invalid' );
438: END IF;
439: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'VARIABLE_TYPE');
440: l_return_status := G_RET_STS_ERROR;
441: END IF;
442:
443: /*IF (l_debug = 'Y') THEN

Line 460: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'EXTERNAL_YN');

456: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
457: FND_LOG.STRING(G_PROC_LEVEL,
458: G_PKG_NAME, '1500: - attribute EXTERNAL_YN is invalid' );
459: END IF;
460: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'EXTERNAL_YN');
461: l_return_status := G_RET_STS_ERROR;
462: END IF;
463:
464: END IF;

Line 494: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'EXTERNAL_YN');

490: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
491: FND_LOG.STRING(G_PROC_LEVEL,
492: G_PKG_NAME, '1800: - attribute EXTERNAL_YN is invalid' );
493: END IF;
494: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'EXTERNAL_YN');
495: l_return_status := G_RET_STS_ERROR;
496: END IF;
497:
498:

Line 518: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'OVERRIDE_GLOBAL_YN');

514: FND_LOG.STRING(G_PROC_LEVEL,
515: G_PKG_NAME, '1800: - attribute OVERRIDE_GLOBAL_YN is invalid' );
516: END IF;
517:
518: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'OVERRIDE_GLOBAL_YN');
519: l_return_status := G_RET_STS_ERROR;
520: END IF;
521: END IF;
522:

Line 567: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CAT_ID');

563: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
564: FND_LOG.STRING(G_PROC_LEVEL,
565: G_PKG_NAME, '2300: - attribute CAT_ID is invalid' );
566: END IF;
567: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CAT_ID');
568: l_return_status := G_RET_STS_ERROR;
569: END IF;
570: END IF;
571: /*

Line 584: -- Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'VARIABLE_VALUE_ID');

580: -- IF (l_dummy_var = '?') THEN
581: -- IF (l_debug = 'Y') THEN
582: -- Okc_Debug.Log('2300: - attribute VARIABLE_VALUE_ID is invalid', 2);
583: -- END IF;
584: -- Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'VARIABLE_VALUE_ID');
585: -- l_return_status := G_RET_STS_ERROR;
586: -- END IF;
587: -- END IF;
588: */

Line 611: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ATTRIBUTE_VALUE_SET_ID');

607: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
608: FND_LOG.STRING(G_PROC_LEVEL,
609: G_PKG_NAME, '2300: - attribute ATTRIBUTE_VALUE_SET_ID is invalid' );
610: END IF;
611: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ATTRIBUTE_VALUE_SET_ID');
612: l_return_status := G_RET_STS_ERROR;
613: END IF;
614: END IF;
615:

Line 638: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'VARIABLE_CODE');

634: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
635: FND_LOG.STRING(G_PROC_LEVEL,
636: G_PKG_NAME, '2300: - attribute VARIABLE_CODE is invalid' );
637: END IF;
638: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'VARIABLE_CODE');
639: l_return_status := G_RET_STS_ERROR;
640: END IF;
641: END IF;
642: END IF;

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

658: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
659: FND_LOG.STRING(G_EXCP_LEVEL,
660: G_PKG_NAME, '2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm );
661: END IF;
662: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
663: p_msg_name => G_UNEXPECTED_ERROR,
664: p_token1 => G_SQLCODE_TOKEN,
665: p_token1_value => sqlcode,
666: p_token2 => G_SQLERRM_TOKEN,

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

781: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
782: FND_LOG.STRING(G_EXCP_LEVEL,
783: G_PKG_NAME, '3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm );
784: END IF;
785: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
786: p_msg_name => G_UNEXPECTED_ERROR,
787: p_token1 => G_SQLCODE_TOKEN,
788: p_token1_value => sqlcode,
789: p_token2 => G_SQLERRM_TOKEN,

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

913: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
914: FND_LOG.STRING(G_EXCP_LEVEL,
915: G_PKG_NAME, '3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm );
916: END IF;
917: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
918: p_msg_name => G_UNEXPECTED_ERROR,
919: p_token1 => G_SQLCODE_TOKEN,
920: p_token1_value => sqlcode,
921: p_token2 => G_SQLERRM_TOKEN,

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

1017: FND_LOG.STRING(G_EXCP_LEVEL,
1018: G_PKG_NAME, '3800: Leaving Insert_Row:OTHERS Exception' );
1019: END IF;
1020:
1021: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1022: p_msg_name => G_UNEXPECTED_ERROR,
1023: p_token1 => G_SQLCODE_TOKEN,
1024: p_token1_value => sqlcode,
1025: p_token2 => G_SQLERRM_TOKEN,

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

1176: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1177: FND_LOG.STRING(G_EXCP_LEVEL,
1178: G_PKG_NAME, '4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm );
1179: END IF;
1180: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1181: p_msg_name => G_UNEXPECTED_ERROR,
1182: p_token1 => G_SQLCODE_TOKEN,
1183: p_token1_value => sqlcode,
1184: p_token2 => G_SQLERRM_TOKEN,

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

1248:
1249: IF (lock_csr%ISOPEN) THEN
1250: CLOSE lock_csr;
1251: END IF;
1252: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
1253: RETURN( G_RET_STS_ERROR );
1254: END;
1255:
1256: IF ( l_row_notfound ) THEN

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

1261: l_row_notfound := lchk_csr%NOTFOUND;
1262: CLOSE lchk_csr;
1263:
1264: IF (l_row_notfound) THEN
1265: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
1266: ELSIF l_object_version_number > p_object_version_number THEN
1267: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1268: ELSIF l_object_version_number = -1 THEN
1269: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

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

1263:
1264: IF (l_row_notfound) THEN
1265: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
1266: ELSIF l_object_version_number > p_object_version_number THEN
1267: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1268: ELSIF l_object_version_number = -1 THEN
1269: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1270: ELSE -- it can be the only above condition. It can happen after restore version
1271: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

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

1265: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
1266: ELSIF l_object_version_number > p_object_version_number THEN
1267: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1268: ELSIF l_object_version_number = -1 THEN
1269: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1270: ELSE -- it can be the only above condition. It can happen after restore version
1271: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1272: END IF;
1273: ELSE

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

1267: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1268: ELSIF l_object_version_number = -1 THEN
1269: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1270: ELSE -- it can be the only above condition. It can happen after restore version
1271: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1272: END IF;
1273: ELSE
1274: l_return_status := G_RET_STS_SUCCESS;
1275: END IF;

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

1303: FND_LOG.STRING(G_EXCP_LEVEL,
1304: G_PKG_NAME, '5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm );
1305: END IF;
1306:
1307: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1308: p_msg_name => G_UNEXPECTED_ERROR,
1309: p_token1 => G_SQLCODE_TOKEN,
1310: p_token1_value => sqlcode,
1311: p_token2 => G_SQLERRM_TOKEN,

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

1394: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1395: FND_LOG.STRING(G_EXCP_LEVEL,
1396: G_PKG_NAME, '6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm );
1397: END IF;
1398: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1399: p_msg_name => G_UNEXPECTED_ERROR,
1400: p_token1 => G_SQLCODE_TOKEN,
1401: p_token1_value => sqlcode,
1402: p_token2 => G_SQLERRM_TOKEN,

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

1474: FND_LOG.STRING(G_EXCP_LEVEL,
1475: G_PKG_NAME, '6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm );
1476: END IF;
1477:
1478: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1479: p_msg_name => G_UNEXPECTED_ERROR,
1480: p_token1 => G_SQLCODE_TOKEN,
1481: p_token1_value => sqlcode,
1482: p_token2 => G_SQLERRM_TOKEN,

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

1702: FND_LOG.STRING(G_EXCP_LEVEL,
1703: G_PKG_NAME, '8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm );
1704: END IF;
1705:
1706: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1707: p_msg_name => G_UNEXPECTED_ERROR,
1708: p_token1 => G_SQLCODE_TOKEN,
1709: p_token1_value => sqlcode,
1710: p_token2 => G_SQLERRM_TOKEN,

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

1763: FND_LOG.STRING(G_EXCP_LEVEL,
1764: G_PKG_NAME, '8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );
1765: END IF;
1766:
1767: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1768: p_msg_name => G_UNEXPECTED_ERROR,
1769: p_token1 => G_SQLCODE_TOKEN,
1770: p_token1_value => sqlcode,
1771: p_token2 => G_SQLERRM_TOKEN,

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

1866: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1867: FND_LOG.STRING(G_EXCP_LEVEL,
1868: G_PKG_NAME, '9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );
1869: END IF;
1870: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1871: p_msg_name => G_UNEXPECTED_ERROR,
1872: p_token1 => G_SQLCODE_TOKEN,
1873: p_token1_value => sqlcode,
1874: p_token2 => G_SQLERRM_TOKEN,

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

1935:
1936: IF (lock_csr%ISOPEN) THEN
1937: CLOSE lock_csr;
1938: END IF;
1939: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
1940: x_return_status := G_RET_STS_ERROR ;
1941:
1942: WHEN FND_API.G_EXC_ERROR THEN
1943: /*IF (l_debug = 'Y') THEN

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

1982:
1983: IF (lock_csr%ISOPEN) THEN
1984: CLOSE lock_csr;
1985: END IF;
1986: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1987: p_msg_name => G_UNEXPECTED_ERROR,
1988: p_token1 => G_SQLCODE_TOKEN,
1989: p_token1_value => sqlcode,
1990: p_token2 => G_SQLERRM_TOKEN,

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

2065:
2066: IF (lock_csr%ISOPEN) THEN
2067: CLOSE lock_csr;
2068: END IF;
2069: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
2070: x_return_status := G_RET_STS_ERROR ;
2071:
2072: WHEN FND_API.G_EXC_ERROR THEN
2073: /*IF (l_debug = 'Y') THEN

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

2111:
2112: IF (lock_csr%ISOPEN) THEN
2113: CLOSE lock_csr;
2114: END IF;
2115: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2116: p_msg_name => G_UNEXPECTED_ERROR,
2117: p_token1 => G_SQLCODE_TOKEN,
2118: p_token1_value => sqlcode,
2119: p_token2 => G_SQLERRM_TOKEN,

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

2216:
2217: IF (lock_csr%ISOPEN) THEN
2218: CLOSE lock_csr;
2219: END IF;
2220: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
2221:
2222: x_return_status := G_RET_STS_ERROR ;
2223: WHEN FND_API.G_EXC_ERROR THEN
2224: /*IF (l_debug = 'Y') THEN

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

2232:
2233: IF (lock_csr%ISOPEN) THEN
2234: CLOSE lock_csr;
2235: END IF;
2236: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
2237: x_return_status := G_RET_STS_ERROR;
2238:
2239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2240: /*IF (l_debug = 'Y') THEN

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

2248:
2249: IF (lock_csr%ISOPEN) THEN
2250: CLOSE lock_csr;
2251: END IF;
2252: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
2253: x_return_status := G_RET_STS_UNEXP_ERROR;
2254:
2255: WHEN OTHERS THEN
2256: /*IF (l_debug = 'Y') THEN

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

2264:
2265: IF (lock_csr%ISOPEN) THEN
2266: CLOSE lock_csr;
2267: END IF;
2268: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
2269: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2270: p_msg_name => G_UNEXPECTED_ERROR,
2271: p_token1 => G_SQLCODE_TOKEN,
2272: p_token1_value => sqlcode,

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

2265: IF (lock_csr%ISOPEN) THEN
2266: CLOSE lock_csr;
2267: END IF;
2268: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
2269: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2270: p_msg_name => G_UNEXPECTED_ERROR,
2271: p_token1 => G_SQLCODE_TOKEN,
2272: p_token1_value => sqlcode,
2273: p_token2 => G_SQLERRM_TOKEN,

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

2380: FND_LOG.STRING(G_EXCP_LEVEL,
2381: G_PKG_NAME, '10100: Leaving create_version because of EXCEPTION: '||sqlerrm );
2382: END IF;
2383:
2384: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2385: p_msg_name => G_UNEXPECTED_ERROR,
2386: p_token1 => G_SQLCODE_TOKEN,
2387: p_token1_value => sqlcode,
2388: p_token2 => G_SQLERRM_TOKEN,

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

2499: FND_LOG.STRING(G_EXCP_LEVEL,
2500: G_PKG_NAME, '10600: Leaving restore_version because of EXCEPTION: '||sqlerrm );
2501: END IF;
2502:
2503: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2504: p_msg_name => G_UNEXPECTED_ERROR,
2505: p_token1 => G_SQLCODE_TOKEN,
2506: p_token1_value => sqlcode,
2507: p_token2 => G_SQLERRM_TOKEN,

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

2576: FND_LOG.STRING(G_EXCP_LEVEL,
2577: G_PKG_NAME, '7400: Leaving Delete_Version because of EXCEPTION: '||sqlerrm );
2578: END IF;
2579:
2580: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2581: p_msg_name => G_UNEXPECTED_ERROR,
2582: p_token1 => G_SQLCODE_TOKEN,
2583: p_token1_value => sqlcode,
2584: 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, ' Leaving delete_mrv_uda_data 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,