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

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

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

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

200: FND_LOG.STRING(G_EXCP_LEVEL,
201: G_PKG_NAME, '600: Leaving get_rec because of EXCEPTION: '||sqlerrm );
202: END IF;
203:
204: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
205: p_msg_name => G_UNEXPECTED_ERROR,
206: p_token1 => G_SQLCODE_TOKEN,
207: p_token1_value => sqlcode,
208: p_token2 => G_SQLERRM_TOKEN,

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

335: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
336: FND_LOG.STRING(G_EXCP_LEVEL,
337: G_PKG_NAME, '1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm );
338: END IF;
339: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
340: p_msg_name => G_UNEXPECTED_ERROR,
341: p_token1 => G_SQLCODE_TOKEN,
342: p_token1_value => sqlcode,
343: p_token2 => G_SQLERRM_TOKEN,

Line 401: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'NUM_SCHEME_ID');

397: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
398: FND_LOG.STRING(G_PROC_LEVEL,
399: G_PKG_NAME, '1500: - attribute NUM_SCHEME_ID is invalid' );
400: END IF;
401: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'NUM_SCHEME_ID');
402: l_return_status := G_RET_STS_ERROR;
403: END IF;
404:
405: /*IF (l_debug = 'Y') THEN

Line 422: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'NUMBER_ARTICLE_YN');

418: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
419: FND_LOG.STRING(G_PROC_LEVEL,
420: G_PKG_NAME, '1500: - attribute NUMBER_ARTICLE_YN is invalid' );
421: END IF;
422: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'NUMBER_ARTICLE_YN');
423: l_return_status := G_RET_STS_ERROR;
424: END IF;
425:
426: /*IF (l_debug = 'Y') THEN

Line 443: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'SCHEME_NAME');

439: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
440: FND_LOG.STRING(G_PROC_LEVEL,
441: G_PKG_NAME, '1500: - attribute SCHEME_NAME is invalid' );
442: END IF;
443: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'SCHEME_NAME');
444: l_return_status := G_RET_STS_ERROR;
445: END IF;
446:
447: END IF;

Line 477: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'NUMBER_ARTICLE_YN');

473: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
474: FND_LOG.STRING(G_PROC_LEVEL,
475: G_PKG_NAME, '1800: - attribute NUMBER_ARTICLE_YN is invalid' );
476: END IF;
477: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'NUMBER_ARTICLE_YN');
478: l_return_status := G_RET_STS_ERROR;
479: END IF;
480:
481: END IF;

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

521: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
522: FND_LOG.STRING(G_EXCP_LEVEL,
523: G_PKG_NAME, '2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm );
524: END IF;
525: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
526: p_msg_name => G_UNEXPECTED_ERROR,
527: p_token1 => G_SQLCODE_TOKEN,
528: p_token1_value => sqlcode,
529: p_token2 => G_SQLERRM_TOKEN,

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

619: FND_LOG.STRING(G_EXCP_LEVEL,
620: G_PKG_NAME, '3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm );
621: END IF;
622:
623: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
624: p_msg_name => G_UNEXPECTED_ERROR,
625: p_token1 => G_SQLCODE_TOKEN,
626: p_token1_value => sqlcode,
627: p_token2 => G_SQLERRM_TOKEN,

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

734: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
735: FND_LOG.STRING(G_EXCP_LEVEL,
736: G_PKG_NAME, '3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm );
737: END IF;
738: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
739: p_msg_name => G_UNEXPECTED_ERROR,
740: p_token1 => G_SQLCODE_TOKEN,
741: p_token1_value => sqlcode,
742: p_token2 => G_SQLERRM_TOKEN,

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

818: FND_LOG.STRING(G_EXCP_LEVEL,
819: G_PKG_NAME, '3800: Leaving Insert_Row:OTHERS Exception' );
820: END IF;
821:
822: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
823: p_msg_name => G_UNEXPECTED_ERROR,
824: p_token1 => G_SQLCODE_TOKEN,
825: p_token1_value => sqlcode,
826: p_token2 => G_SQLERRM_TOKEN,

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

906: FND_LOG.STRING(G_EXCP_LEVEL,
907: G_PKG_NAME, '4100: Leaving Insert_Row:OTHERS Exception' );
908: END IF;
909:
910: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
911: p_msg_name => G_UNEXPECTED_ERROR,
912: p_token1 => G_SQLCODE_TOKEN,
913: p_token1_value => sqlcode,
914: p_token2 => G_SQLERRM_TOKEN,

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

1093: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1094: FND_LOG.STRING(G_EXCP_LEVEL,
1095: G_PKG_NAME, '4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm );
1096: END IF;
1097: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1098: p_msg_name => G_UNEXPECTED_ERROR,
1099: p_token1 => G_SQLCODE_TOKEN,
1100: p_token1_value => sqlcode,
1101: p_token2 => G_SQLERRM_TOKEN,

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

1166:
1167: IF (lock_csr%ISOPEN) THEN
1168: CLOSE lock_csr;
1169: END IF;
1170: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
1171: RETURN( G_RET_STS_ERROR );
1172: END;
1173:
1174: IF ( l_row_notfound ) THEN

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

1179: l_row_notfound := lchk_csr%NOTFOUND;
1180: CLOSE lchk_csr;
1181:
1182: IF (l_row_notfound) THEN
1183: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
1184: ELSIF l_object_version_number > p_object_version_number THEN
1185: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1186: ELSIF l_object_version_number = -1 THEN
1187: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

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

1181:
1182: IF (l_row_notfound) THEN
1183: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
1184: ELSIF l_object_version_number > p_object_version_number THEN
1185: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1186: ELSIF l_object_version_number = -1 THEN
1187: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1188: ELSE -- it can be the only above condition. It can happen after restore version
1189: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

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

1183: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
1184: ELSIF l_object_version_number > p_object_version_number THEN
1185: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1186: ELSIF l_object_version_number = -1 THEN
1187: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1188: ELSE -- it can be the only above condition. It can happen after restore version
1189: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1190: END IF;
1191: ELSE

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

1185: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1186: ELSIF l_object_version_number = -1 THEN
1187: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1188: ELSE -- it can be the only above condition. It can happen after restore version
1189: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1190: END IF;
1191: ELSE
1192: l_return_status := G_RET_STS_SUCCESS;
1193: END IF;

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

1221: FND_LOG.STRING(G_EXCP_LEVEL,
1222: G_PKG_NAME, '5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm );
1223: END IF;
1224:
1225: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1226: p_msg_name => G_UNEXPECTED_ERROR,
1227: p_token1 => G_SQLCODE_TOKEN,
1228: p_token1_value => sqlcode,
1229: p_token2 => G_SQLERRM_TOKEN,

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

1283:
1284: IF (lock_csr%ISOPEN) THEN
1285: CLOSE lock_csr;
1286: END IF;
1287: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
1288: RETURN( G_RET_STS_ERROR );
1289: END;
1290:
1291: IF ( l_row_notfound ) THEN

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

1289: END;
1290:
1291: IF ( l_row_notfound ) THEN
1292: l_return_status := G_RET_STS_ERROR;
1293: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
1294: ELSE
1295: l_return_status := G_RET_STS_SUCCESS;
1296: END IF;
1297:

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

1321: FND_LOG.STRING(G_PROC_LEVEL,
1322: G_PKG_NAME, '5600: Leaving Lock_Row because of EXCEPTION: '||sqlerrm );
1323: END IF;
1324:
1325: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1326: p_msg_name => G_UNEXPECTED_ERROR,
1327: p_token1 => G_SQLCODE_TOKEN,
1328: p_token1_value => sqlcode,
1329: p_token2 => G_SQLERRM_TOKEN,

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

1431: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1432: FND_LOG.STRING(G_EXCP_LEVEL,
1433: G_PKG_NAME, '6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm );
1434: END IF;
1435: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1436: p_msg_name => G_UNEXPECTED_ERROR,
1437: p_token1 => G_SQLCODE_TOKEN,
1438: p_token1_value => sqlcode,
1439: p_token2 => G_SQLERRM_TOKEN,

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

1499: FND_LOG.STRING(G_EXCP_LEVEL,
1500: G_PKG_NAME, '6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm );
1501: END IF;
1502:
1503: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1504: p_msg_name => G_UNEXPECTED_ERROR,
1505: p_token1 => G_SQLCODE_TOKEN,
1506: p_token1_value => sqlcode,
1507: p_token2 => G_SQLERRM_TOKEN,

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

1565: FND_LOG.STRING(G_EXCP_LEVEL,
1566: G_PKG_NAME, '6900: Leaving Update_Row because of EXCEPTION: '||sqlerrm );
1567: END IF;
1568:
1569: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1570: p_msg_name => G_UNEXPECTED_ERROR,
1571: p_token1 => G_SQLCODE_TOKEN,
1572: p_token1_value => sqlcode,
1573: p_token2 => G_SQLERRM_TOKEN,

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

1805: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1806: FND_LOG.STRING(G_EXCP_LEVEL,
1807: G_PKG_NAME, '8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm );
1808: END IF;
1809: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1810: p_msg_name => G_UNEXPECTED_ERROR,
1811: p_token1 => G_SQLCODE_TOKEN,
1812: p_token1_value => sqlcode,
1813: p_token2 => G_SQLERRM_TOKEN,

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

1862: FND_LOG.STRING(G_EXCP_LEVEL,
1863: G_PKG_NAME, '8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );
1864: END IF;
1865:
1866: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1867: p_msg_name => G_UNEXPECTED_ERROR,
1868: p_token1 => G_SQLCODE_TOKEN,
1869: p_token1_value => sqlcode,
1870: p_token2 => G_SQLERRM_TOKEN,

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

1918: FND_LOG.STRING(G_EXCP_LEVEL,
1919: G_PKG_NAME, '8700: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );
1920: END IF;
1921:
1922: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1923: p_msg_name => G_UNEXPECTED_ERROR,
1924: p_token1 => G_SQLCODE_TOKEN,
1925: p_token1_value => sqlcode,
1926: p_token2 => G_SQLERRM_TOKEN,

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

2055: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2056: FND_LOG.STRING(G_EXCP_LEVEL,
2057: G_PKG_NAME, '9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );
2058: END IF;
2059: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2060: p_msg_name => G_UNEXPECTED_ERROR,
2061: p_token1 => G_SQLCODE_TOKEN,
2062: p_token1_value => sqlcode,
2063: p_token2 => G_SQLERRM_TOKEN,