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

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

111: IF (l_debug = 'Y') THEN
112: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);
113: END IF;
114:
115: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
116: p_msg_name => G_UNEXPECTED_ERROR,
117: p_token1 => G_SQLCODE_TOKEN,
118: p_token1_value => sqlcode,
119: p_token2 => G_SQLERRM_TOKEN,

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

212: WHEN OTHERS THEN
213: IF (l_debug = 'Y') THEN
214: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);
215: END IF;
216: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
217: p_msg_name => G_UNEXPECTED_ERROR,
218: p_token1 => G_SQLCODE_TOKEN,
219: p_token1_value => sqlcode,
220: p_token2 => G_SQLERRM_TOKEN,

Line 261: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'QA_CODE');

257: IF ( p_qa_code IS NULL) THEN
258: IF (l_debug = 'Y') THEN
259: Okc_Debug.Log('1500: - attribute QA_CODE is invalid', 2);
260: END IF;
261: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'QA_CODE');
262: l_return_status := G_RET_STS_ERROR;
263: END IF;
264:
265: IF (l_debug = 'Y') THEN

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

268: IF ( p_document_type IS NULL) THEN
269: IF (l_debug = 'Y') THEN
270: Okc_Debug.Log('1500: - attribute DOCUMENT_TYPE is invalid', 2);
271: END IF;
272: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DOCUMENT_TYPE');
273: l_return_status := G_RET_STS_ERROR;
274: END IF;
275:
276: IF (l_debug = 'Y') THEN

Line 283: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'SEVERITY_FLAG');

279: IF ( p_severity_flag IS NULL) THEN
280: IF (l_debug = 'Y') THEN
281: Okc_Debug.Log('1500: - attribute SEVERITY_FLAG is invalid', 2);
282: END IF;
283: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'SEVERITY_FLAG');
284: l_return_status := G_RET_STS_ERROR;
285: END IF;
286:
287: IF (l_debug = 'Y') THEN

Line 294: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ENABLE_QA_YN');

290: IF ( p_enable_qa_yn IS NULL) THEN
291: IF (l_debug = 'Y') THEN
292: Okc_Debug.Log('1500: - attribute ENABLE_QA_YN is invalid', 2);
293: END IF;
294: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ENABLE_QA_YN');
295: l_return_status := G_RET_STS_ERROR;
296: END IF;
297: END IF;
298:

Line 311: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'SEVERITY_FLAG');

307: IF ( p_severity_flag NOT IN ('E','W') AND p_severity_flag IS NOT NULL) THEN
308: IF (l_debug = 'Y') THEN
309: Okc_Debug.Log('1800: - attribute SEVERITY_FLAG is invalid', 2);
310: END IF;
311: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'SEVERITY_FLAG');
312: l_return_status := G_RET_STS_ERROR;
313: END IF;
314:
315:

Line 323: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ENABLE_QA_YN');

319: IF ( p_ENABLE_QA_YN NOT IN ('Y','N') AND p_ENABLE_QA_YN IS NOT NULL) THEN
320: IF (l_debug = 'Y') THEN
321: Okc_Debug.Log('1800: - attribute ENABLE_QA_YN is invalid', 2);
322: END IF;
323: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ENABLE_QA_YN');
324: l_return_status := G_RET_STS_ERROR;
325: END IF;
326: END IF;
327:

Line 338: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'QA_CODE');

334: END IF;
335: IF p_qa_code IS NOT NULL THEN
336: l_return_status := Okc_Util.Check_Lookup_Code('OKC_TERM_QA_LIST',p_qa_code);
337: IF (l_return_status <> G_RET_STS_SUCCESS) THEN
338: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'QA_CODE');
339: l_return_status := G_RET_STS_ERROR;
340: END IF;
341: END IF;
342: END IF;

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

357: IF (l_dummy_var = '?') THEN
358: IF (l_debug = 'Y') THEN
359: Okc_Debug.Log('2300: - attribute DOCUMENT_TYPE is invalid', 2);
360: END IF;
361: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DOCUMENT_TYPE');
362: l_return_status := G_RET_STS_ERROR;
363: END IF;
364: END IF;
365:

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

374:
375: EXCEPTION
376: WHEN OTHERS THEN
377: Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
378: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
379: p_msg_name => G_UNEXPECTED_ERROR,
380: p_token1 => G_SQLCODE_TOKEN,
381: p_token1_value => sqlcode,
382: p_token2 => G_SQLERRM_TOKEN,

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

450: IF (l_debug = 'Y') THEN
451: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
452: END IF;
453:
454: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
455: p_msg_name => G_UNEXPECTED_ERROR,
456: p_token1 => G_SQLCODE_TOKEN,
457: p_token1_value => sqlcode,
458: p_token2 => G_SQLERRM_TOKEN,

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

541: WHEN OTHERS THEN
542: IF (l_debug = 'Y') THEN
543: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
544: END IF;
545: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
546: p_msg_name => G_UNEXPECTED_ERROR,
547: p_token1 => G_SQLCODE_TOKEN,
548: p_token1_value => sqlcode,
549: p_token2 => G_SQLERRM_TOKEN,

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

613: IF (l_debug = 'Y') THEN
614: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
615: END IF;
616:
617: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
618: p_msg_name => G_UNEXPECTED_ERROR,
619: p_token1 => G_SQLCODE_TOKEN,
620: p_token1_value => sqlcode,
621: p_token2 => G_SQLERRM_TOKEN,

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

734: WHEN OTHERS THEN
735: IF (l_debug = 'Y') THEN
736: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
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 803: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);

799:
800: IF (lock_csr%ISOPEN) THEN
801: CLOSE lock_csr;
802: END IF;
803: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
804: RETURN( G_RET_STS_ERROR );
805: END;
806:
807: IF ( l_row_notfound ) THEN

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

812: l_row_notfound := lchk_csr%NOTFOUND;
813: CLOSE lchk_csr;
814:
815: IF (l_row_notfound) THEN
816: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
817: ELSIF l_object_version_number > p_object_version_number THEN
818: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
819: ELSIF l_object_version_number = -1 THEN
820: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

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

814:
815: IF (l_row_notfound) THEN
816: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
817: ELSIF l_object_version_number > p_object_version_number THEN
818: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
819: ELSIF l_object_version_number = -1 THEN
820: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
821: ELSE -- it can be the only above condition. It can happen after restore version
822: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

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

816: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
817: ELSIF l_object_version_number > p_object_version_number THEN
818: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
819: ELSIF l_object_version_number = -1 THEN
820: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
821: ELSE -- it can be the only above condition. It can happen after restore version
822: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
823: END IF;
824: ELSE

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

818: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
819: ELSIF l_object_version_number = -1 THEN
820: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
821: ELSE -- it can be the only above condition. It can happen after restore version
822: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
823: END IF;
824: ELSE
825: l_return_status := G_RET_STS_SUCCESS;
826: END IF;

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

844: IF (l_debug = 'Y') THEN
845: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
846: END IF;
847:
848: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
849: p_msg_name => G_UNEXPECTED_ERROR,
850: p_token1 => G_SQLCODE_TOKEN,
851: p_token1_value => sqlcode,
852: p_token2 => G_SQLERRM_TOKEN,

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

908: WHEN OTHERS THEN
909: IF (l_debug = 'Y') THEN
910: Okc_Debug.Log('6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
911: END IF;
912: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
913: p_msg_name => G_UNEXPECTED_ERROR,
914: p_token1 => G_SQLCODE_TOKEN,
915: p_token1_value => sqlcode,
916: p_token2 => G_SQLERRM_TOKEN,

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

962: IF (l_debug = 'Y') THEN
963: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
964: END IF;
965:
966: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
967: p_msg_name => G_UNEXPECTED_ERROR,
968: p_token1 => G_SQLCODE_TOKEN,
969: p_token1_value => sqlcode,
970: p_token2 => G_SQLERRM_TOKEN,

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

1114: WHEN OTHERS THEN
1115: IF (l_debug = 'Y') THEN
1116: Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1117: END IF;
1118: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1119: p_msg_name => G_UNEXPECTED_ERROR,
1120: p_token1 => G_SQLCODE_TOKEN,
1121: p_token1_value => sqlcode,
1122: p_token2 => G_SQLERRM_TOKEN,

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

1157: IF (l_debug = 'Y') THEN
1158: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1159: END IF;
1160:
1161: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1162: p_msg_name => G_UNEXPECTED_ERROR,
1163: p_token1 => G_SQLCODE_TOKEN,
1164: p_token1_value => sqlcode,
1165: p_token2 => G_SQLERRM_TOKEN,

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

1229: WHEN OTHERS THEN
1230: IF (l_debug = 'Y') THEN
1231: Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1232: END IF;
1233: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1234: p_msg_name => G_UNEXPECTED_ERROR,
1235: p_token1 => G_SQLCODE_TOKEN,
1236: p_token1_value => sqlcode,
1237: p_token2 => G_SQLERRM_TOKEN,