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

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

85: IF (l_debug = 'Y') THEN
86: Okc_Debug.Log('300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm, 2);
87: END IF;
88:
89: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
90: p_msg_name => G_UNEXPECTED_ERROR,
91: p_token1 => G_SQLCODE_TOKEN,
92: p_token1_value => sqlcode,
93: p_token2 => G_SQLERRM_TOKEN,

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

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

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

465: WHEN OTHERS THEN
466: IF (l_debug = 'Y') THEN
467: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);
468: END IF;
469: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
470: p_msg_name => G_UNEXPECTED_ERROR,
471: p_token1 => G_SQLCODE_TOKEN,
472: p_token1_value => sqlcode,
473: p_token2 => G_SQLERRM_TOKEN,

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

548: IF ( p_document_type IS NULL) THEN
549: IF (l_debug = 'Y') THEN
550: Okc_Debug.Log('1210: - attribute DOCUMENT_TYPE is null', 2);
551: END IF;
552: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'DOCUMENT_TYPE');
553: l_return_status := G_RET_STS_ERROR;
554: END IF;
555:
556: END IF;

Line 570: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'DEFAULT_YN');

566: IF ( p_default_yn NOT IN ('Y','N') AND p_default_yn IS NOT NULL) THEN
567: IF (l_debug = 'Y') THEN
568: Okc_Debug.Log('1800: - attribute DEFAULT_YN is invalid', 2);
569: END IF;
570: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'DEFAULT_YN');
571: l_return_status := G_RET_STS_ERROR;
572: END IF;
573:
574: END IF;

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

595: IF (l_dummy_var = '?') THEN
596: IF (l_debug = 'Y') THEN
597: Okc_Debug.Log('2300: - attribute TEMPLATE_ID is invalid', 2);
598: END IF;
599: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TEMPLATE_ID');
600: l_return_status := G_RET_STS_ERROR;
601: END IF;
602: END IF;
603:

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

612: IF (l_dummy_var = '?') THEN
613: IF (l_debug = 'Y') THEN
614: Okc_Debug.Log('2300: - attribute DOCUMENT_TYPE is invalid', 2);
615: END IF;
616: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DOCUMENT_TYPE');
617: l_return_status := G_RET_STS_ERROR;
618: END IF;
619: END IF;
620:

Line 641: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_ALWD_USG_WRONG_INTENT',

637:
638: IF l_doc_type_name IS NULL THEN
639: l_doc_type_name := p_document_type;
640: END IF;
641: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_ALWD_USG_WRONG_INTENT',
642: 'DOCUMENT_TYPE',l_doc_type_name);
643: l_return_status := G_RET_STS_ERROR;
644: END IF;
645: END IF;

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

655:
656: EXCEPTION
657: WHEN OTHERS THEN
658: Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
659: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
660: p_msg_name => G_UNEXPECTED_ERROR,
661: p_token1 => G_SQLCODE_TOKEN,
662: p_token1_value => sqlcode,
663: p_token2 => G_SQLERRM_TOKEN,

Line 809: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_MLTPL_DEF_USG',

805:
806: IF l_doc_type_name IS NULL THEN
807: l_doc_type_name := p_document_type;
808: END IF;
809: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_MLTPL_DEF_USG',
810: 'DOCUMENT_TYPE',l_doc_type_name,
811: 'TEMPLATE_NAME',l_def_tmpl_name);
812: l_return_status := G_RET_STS_ERROR;
813: END IF;

Line 832: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ALLOWED_TMPL_USG_DUP',

828: IF l_doc_type_name IS NULL THEN
829: l_doc_type_name := p_document_type;
830: END IF;
831:
832: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ALLOWED_TMPL_USG_DUP',
833: 'DOCUMENT_TYPE',l_doc_type_name);
834: l_return_status := G_RET_STS_ERROR;
835: END IF;
836: CLOSE l_allowed_doc_exists_csr;

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

848: IF (l_debug = 'Y') THEN
849: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
850: END IF;
851:
852: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
853: p_msg_name => G_UNEXPECTED_ERROR,
854: p_token1 => G_SQLCODE_TOKEN,
855: p_token1_value => sqlcode,
856: p_token2 => G_SQLERRM_TOKEN,

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

1019: WHEN OTHERS THEN
1020: IF (l_debug = 'Y') THEN
1021: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
1022: END IF;
1023: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1024: p_msg_name => G_UNEXPECTED_ERROR,
1025: p_token1 => G_SQLCODE_TOKEN,
1026: p_token1_value => sqlcode,
1027: p_token2 => G_SQLERRM_TOKEN,

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

1139: IF (l_debug = 'Y') THEN
1140: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
1141: END IF;
1142:
1143: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1144: p_msg_name => G_UNEXPECTED_ERROR,
1145: p_token1 => G_SQLCODE_TOKEN,
1146: p_token1_value => sqlcode,
1147: p_token2 => G_SQLERRM_TOKEN,

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

1318: WHEN OTHERS THEN
1319: IF (l_debug = 'Y') THEN
1320: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
1321: END IF;
1322: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1323: p_msg_name => G_UNEXPECTED_ERROR,
1324: p_token1 => G_SQLCODE_TOKEN,
1325: p_token1_value => sqlcode,
1326: p_token2 => G_SQLERRM_TOKEN,

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

1377:
1378: IF (lock_csr%ISOPEN) THEN
1379: CLOSE lock_csr;
1380: END IF;
1381: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
1382: RETURN( G_RET_STS_ERROR );
1383: END;
1384:
1385: IF ( l_row_notfound ) THEN

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

1390: l_row_notfound := lchk_csr%NOTFOUND;
1391: CLOSE lchk_csr;
1392:
1393: IF (l_row_notfound) THEN
1394: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
1395: ELSIF l_object_version_number > p_object_version_number THEN
1396: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1397: ELSIF l_object_version_number = -1 THEN
1398: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

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

1392:
1393: IF (l_row_notfound) THEN
1394: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
1395: ELSIF l_object_version_number > p_object_version_number THEN
1396: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1397: ELSIF l_object_version_number = -1 THEN
1398: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1399: ELSE -- it can be the only above condition. It can happen after restore version
1400: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

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

1394: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
1395: ELSIF l_object_version_number > p_object_version_number THEN
1396: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1397: ELSIF l_object_version_number = -1 THEN
1398: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1399: ELSE -- it can be the only above condition. It can happen after restore version
1400: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1401: END IF;
1402: ELSE

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

1396: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1397: ELSIF l_object_version_number = -1 THEN
1398: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1399: ELSE -- it can be the only above condition. It can happen after restore version
1400: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1401: END IF;
1402: ELSE
1403: l_return_status := G_RET_STS_SUCCESS;
1404: END IF;

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

1422: IF (l_debug = 'Y') THEN
1423: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1424: END IF;
1425:
1426: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1427: p_msg_name => G_UNEXPECTED_ERROR,
1428: p_token1 => G_SQLCODE_TOKEN,
1429: p_token1_value => sqlcode,
1430: p_token2 => G_SQLERRM_TOKEN,

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

1484: WHEN OTHERS THEN
1485: IF (l_debug = 'Y') THEN
1486: Okc_Debug.Log('6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1487: END IF;
1488: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1489: p_msg_name => G_UNEXPECTED_ERROR,
1490: p_token1 => G_SQLCODE_TOKEN,
1491: p_token1_value => sqlcode,
1492: p_token2 => G_SQLERRM_TOKEN,

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

1571: IF (l_debug = 'Y') THEN
1572: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1573: END IF;
1574:
1575: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1576: p_msg_name => G_UNEXPECTED_ERROR,
1577: p_token1 => G_SQLCODE_TOKEN,
1578: p_token1_value => sqlcode,
1579: p_token2 => G_SQLERRM_TOKEN,

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

1820: WHEN OTHERS THEN
1821: IF (l_debug = 'Y') THEN
1822: Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1823: END IF;
1824: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1825: p_msg_name => G_UNEXPECTED_ERROR,
1826: p_token1 => G_SQLCODE_TOKEN,
1827: p_token1_value => sqlcode,
1828: p_token2 => G_SQLERRM_TOKEN,

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

1862: IF (l_debug = 'Y') THEN
1863: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
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 1936: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1932: WHEN OTHERS THEN
1933: IF (l_debug = 'Y') THEN
1934: Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1935: END IF;
1936: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1937: p_msg_name => G_UNEXPECTED_ERROR,
1938: p_token1 => G_SQLCODE_TOKEN,
1939: p_token1_value => sqlcode,
1940: p_token2 => G_SQLERRM_TOKEN,