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_REVIEW_VAR_VALUES_PVT dependencies on OKC_API

Line 8: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: ---------------------------------------------------------------------------
6: -- GLOBAL MESSAGE CONSTANTS
7: ---------------------------------------------------------------------------
8: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
9: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
10: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
11: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
12: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 9: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;

5: ---------------------------------------------------------------------------
6: -- GLOBAL MESSAGE CONSTANTS
7: ---------------------------------------------------------------------------
8: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
9: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
10: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
11: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
12: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
13: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 10: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;

6: -- GLOBAL MESSAGE CONSTANTS
7: ---------------------------------------------------------------------------
8: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
9: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
10: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
11: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
12: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
13: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
14: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 11: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;

7: ---------------------------------------------------------------------------
8: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
9: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
10: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
11: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
12: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
13: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
14: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 12: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

8: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
9: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
10: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
11: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
12: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
13: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
14: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 13: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

9: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
10: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
11: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
12: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
13: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
14: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 14: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

10: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
11: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
12: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
13: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
14: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
18: ---------------------------------------------------------------------------

Line 15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

11: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
12: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
13: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
14: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
18: ---------------------------------------------------------------------------
19: -- VALIDATION LEVELS

Line 16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

12: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
13: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
14: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
18: ---------------------------------------------------------------------------
19: -- VALIDATION LEVELS
20: ---------------------------------------------------------------------------

Line 17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

13: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
14: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
18: ---------------------------------------------------------------------------
19: -- VALIDATION LEVELS
20: ---------------------------------------------------------------------------
21: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;

Line 21: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;

17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
18: ---------------------------------------------------------------------------
19: -- VALIDATION LEVELS
20: ---------------------------------------------------------------------------
21: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
22: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
23: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
24: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
25: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;

Line 22: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;

18: ---------------------------------------------------------------------------
19: -- VALIDATION LEVELS
20: ---------------------------------------------------------------------------
21: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
22: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
23: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
24: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
25: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
26: ---------------------------------------------------------------------------

Line 23: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;

19: -- VALIDATION LEVELS
20: ---------------------------------------------------------------------------
21: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
22: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
23: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
24: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
25: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
26: ---------------------------------------------------------------------------
27: -- GLOBAL VARIABLES

Line 24: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;

20: ---------------------------------------------------------------------------
21: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
22: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
23: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
24: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
25: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
26: ---------------------------------------------------------------------------
27: -- GLOBAL VARIABLES
28: ---------------------------------------------------------------------------

Line 25: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;

21: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
22: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
23: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
24: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
25: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
26: ---------------------------------------------------------------------------
27: -- GLOBAL VARIABLES
28: ---------------------------------------------------------------------------
29: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_REVIEW_VAR_VALUES_PVT';

Line 30: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

26: ---------------------------------------------------------------------------
27: -- GLOBAL VARIABLES
28: ---------------------------------------------------------------------------
29: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_REVIEW_VAR_VALUES_PVT';
30: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
31:
32: ------------------------------------------------------------------------------
33: -- GLOBAL CONSTANTS
34: ------------------------------------------------------------------------------

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

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

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

180: IF (l_debug = 'Y') THEN
181: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);
182: END IF;
183:
184: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
185: p_msg_name => G_UNEXPECTED_ERROR,
186: p_token1 => G_SQLCODE_TOKEN,
187: p_token1_value => sqlcode,
188: p_token2 => G_SQLERRM_TOKEN,

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

330: WHEN OTHERS THEN
331: IF (l_debug = 'Y') THEN
332: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);
333: END IF;
334: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
335: p_msg_name => G_UNEXPECTED_ERROR,
336: p_token1 => G_SQLCODE_TOKEN,
337: p_token1_value => sqlcode,
338: p_token2 => G_SQLERRM_TOKEN,

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

412: END IF;
413: IF p_variable_code IS NOT NULL THEN
414: l_return_status := Okc_Util.Check_Lookup_Code(??'lookup_code_type'??,p_variable_code);
415: IF (l_return_status <> G_RET_STS_SUCCESS) THEN
416: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'VARIABLE_CODE');
417: l_return_status := G_RET_STS_ERROR;
418: END IF;
419: END IF;
420:

Line 442: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'REVIEW_VAR_VALUES_ID');

438: IF (l_dummy_var = '?') THEN
439: IF (l_debug = 'Y') THEN
440: Okc_Debug.Log('2300: - attribute REVIEW_VAR_VALUES_ID is invalid', 2);
441: END IF;
442: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'REVIEW_VAR_VALUES_ID');
443: l_return_status := G_RET_STS_ERROR;
444: END IF;
445: END IF;
446:

Line 459: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'REVIEW_UPLD_TERMS_ID');

455: IF (l_dummy_var = '?') THEN
456: IF (l_debug = 'Y') THEN
457: Okc_Debug.Log('2300: - attribute REVIEW_UPLD_TERMS_ID is invalid', 2);
458: END IF;
459: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'REVIEW_UPLD_TERMS_ID');
460: l_return_status := G_RET_STS_ERROR;
461: END IF;
462: END IF;
463:

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

472: IF (l_dummy_var = '?') THEN
473: IF (l_debug = 'Y') THEN
474: Okc_Debug.Log('2300: - attribute VARIABLE_VALUE_ID is invalid', 2);
475: END IF;
476: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'VARIABLE_VALUE_ID');
477: l_return_status := G_RET_STS_ERROR;
478: END IF;
479: END IF;
480:

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

489: IF (l_dummy_var = '?') THEN
490: IF (l_debug = 'Y') THEN
491: Okc_Debug.Log('2300: - attribute ATTRIBUTE_VALUE_SET_ID is invalid', 2);
492: END IF;
493: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ATTRIBUTE_VALUE_SET_ID');
494: l_return_status := G_RET_STS_ERROR;
495: END IF;
496: END IF;
497:

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

507:
508: EXCEPTION
509: WHEN OTHERS THEN
510: Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
511: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
512: p_msg_name => G_UNEXPECTED_ERROR,
513: p_token1 => G_SQLCODE_TOKEN,
514: p_token1_value => sqlcode,
515: p_token2 => G_SQLERRM_TOKEN,

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

606: IF (l_debug = 'Y') THEN
607: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
608: END IF;
609:
610: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
611: p_msg_name => G_UNEXPECTED_ERROR,
612: p_token1 => G_SQLCODE_TOKEN,
613: p_token1_value => sqlcode,
614: p_token2 => G_SQLERRM_TOKEN,

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

719: WHEN OTHERS THEN
720: IF (l_debug = 'Y') THEN
721: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
722: END IF;
723: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
724: p_msg_name => G_UNEXPECTED_ERROR,
725: p_token1 => G_SQLCODE_TOKEN,
726: p_token1_value => sqlcode,
727: p_token2 => G_SQLERRM_TOKEN,

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

804: IF (l_debug = 'Y') THEN
805: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
806: END IF;
807:
808: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
809: p_msg_name => G_UNEXPECTED_ERROR,
810: p_token1 => G_SQLCODE_TOKEN,
811: p_token1_value => sqlcode,
812: p_token2 => G_SQLERRM_TOKEN,

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

950: WHEN OTHERS THEN
951: IF (l_debug = 'Y') THEN
952: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
953: END IF;
954: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
955: p_msg_name => G_UNEXPECTED_ERROR,
956: p_token1 => G_SQLCODE_TOKEN,
957: p_token1_value => sqlcode,
958: p_token2 => G_SQLERRM_TOKEN,

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

1009:
1010: IF (lock_csr%ISOPEN) THEN
1011: CLOSE lock_csr;
1012: END IF;
1013: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
1014: RETURN( G_RET_STS_ERROR );
1015: END;
1016:
1017: IF ( l_row_notfound ) THEN

Line 1026: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_DELETED);

1022: l_row_notfound := lchk_csr%NOTFOUND;
1023: CLOSE lchk_csr;
1024:
1025: IF (l_row_notfound) THEN
1026: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_DELETED);
1027: ELSIF l_object_version_number > p_object_version_number THEN
1028: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1029: ELSIF l_object_version_number = -1 THEN
1030: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line 1028: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);

1024:
1025: IF (l_row_notfound) THEN
1026: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_DELETED);
1027: ELSIF l_object_version_number > p_object_version_number THEN
1028: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1029: ELSIF l_object_version_number = -1 THEN
1030: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1031: ELSE -- it can be the only above condition. It can happen after restore version
1032: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);

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

1026: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_DELETED);
1027: ELSIF l_object_version_number > p_object_version_number THEN
1028: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1029: ELSIF l_object_version_number = -1 THEN
1030: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1031: ELSE -- it can be the only above condition. It can happen after restore version
1032: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1033: END IF;
1034: ELSE

Line 1032: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);

1028: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1029: ELSIF l_object_version_number = -1 THEN
1030: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1031: ELSE -- it can be the only above condition. It can happen after restore version
1032: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1033: END IF;
1034: ELSE
1035: l_return_status := G_RET_STS_SUCCESS;
1036: END IF;

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

1054: IF (l_debug = 'Y') THEN
1055: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1056: END IF;
1057:
1058: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1059: p_msg_name => G_UNEXPECTED_ERROR,
1060: p_token1 => G_SQLCODE_TOKEN,
1061: p_token1_value => sqlcode,
1062: p_token2 => G_SQLERRM_TOKEN,

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

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

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

1179: IF (l_debug = 'Y') THEN
1180: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1181: END IF;
1182:
1183: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1184: p_msg_name => G_UNEXPECTED_ERROR,
1185: p_token1 => G_SQLCODE_TOKEN,
1186: p_token1_value => sqlcode,
1187: p_token2 => G_SQLERRM_TOKEN,

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

1358: WHEN OTHERS THEN
1359: IF (l_debug = 'Y') THEN
1360: Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1361: END IF;
1362: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1363: p_msg_name => G_UNEXPECTED_ERROR,
1364: p_token1 => G_SQLCODE_TOKEN,
1365: p_token1_value => sqlcode,
1366: p_token2 => G_SQLERRM_TOKEN,

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

1401: IF (l_debug = 'Y') THEN
1402: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1403: END IF;
1404:
1405: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1406: p_msg_name => G_UNEXPECTED_ERROR,
1407: p_token1 => G_SQLCODE_TOKEN,
1408: p_token1_value => sqlcode,
1409: p_token2 => G_SQLERRM_TOKEN,

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

1471: WHEN OTHERS THEN
1472: IF (l_debug = 'Y') THEN
1473: Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1474: END IF;
1475: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1476: p_msg_name => G_UNEXPECTED_ERROR,
1477: p_token1 => G_SQLCODE_TOKEN,
1478: p_token1_value => sqlcode,
1479: p_token2 => G_SQLERRM_TOKEN,