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_OKS_INT_GRP dependencies on FND_API

Line 19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;
23: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;
23: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
24: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';

Line 21: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;

17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;
23: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
24: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
25: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';

Line 22: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;

18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;
23: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
24: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
25: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
26: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';

Line 23: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;
23: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
24: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
25: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
26: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
27:

Line 31: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

27:
28:
29: Procedure get_article_variable_values(
30: p_api_version IN Number,
31: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
32: p_doc_id IN Number,
33: p_sys_var_value_tbl IN OUT NOCOPY sys_var_value_tbl_type,
34: x_return_status OUT NOCOPY Varchar2,
35: x_msg_data OUT NOCOPY Varchar2,

Line 41: x_return_status := FND_API.G_RET_STS_SUCCESS;

37: )IS
38: l_api_version CONSTANT NUMBER := 1;
39: l_api_name CONSTANT VARCHAR2(30) := 'g_get_article_variable_values';
40: BEGIN
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42:
43: IF l_debug='Y' THEN
44: okc_util.print_trace(1,' Calling OKS_AUTH_INT_PUB.Get_PO_Attribute_values');
45: END IF;

Line 53: WHEN FND_API.G_EXC_ERROR THEN

49: END IF;
50: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
51:
52: EXCEPTION
53: WHEN FND_API.G_EXC_ERROR THEN
54:
55: IF (l_debug = 'Y') THEN
56: okc_debug.log('2400: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);
57: END IF;

Line 62: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

58:
59: x_return_status := G_RET_STS_ERROR ;
60: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
61:
62: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
63: IF (l_debug = 'Y') THEN
64: okc_debug.log('2500: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
65: END IF;
66:

Line 84: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

80: END get_article_variable_values;
81:
82: Procedure get_item_dtl_for_expert(
83: p_api_version IN Number,
84: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
85: p_doc_id IN Number,
86: x_category_tbl OUT NOCOPY item_tbl_type,
87: x_item_tbl OUT NOCOPY item_tbl_type,
88: x_return_status OUT NOCOPY Varchar2,

Line 95: x_return_status := FND_API.G_RET_STS_SUCCESS;

91: )IS
92: l_api_version CONSTANT NUMBER := 1;
93: l_api_name CONSTANT VARCHAR2(30) := 'g_get_item_dtl_for_expert';
94: BEGIN
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96:
97: IF l_debug='Y' THEN
98: okc_util.print_trace(1,' Calling OKS_AUTH_INT_PUB.get_item_dtl_for_expert');
99: END IF;

Line 109: WHEN FND_API.G_EXC_ERROR THEN

105: END IF;
106: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
107:
108: EXCEPTION
109: WHEN FND_API.G_EXC_ERROR THEN
110:
111: IF (l_debug = 'Y') THEN
112: okc_debug.log('2400: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_ERROR Exception', 2);
113: END IF;

Line 118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

114:
115: x_return_status := G_RET_STS_ERROR ;
116: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
117:
118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
119: IF (l_debug = 'Y') THEN
120: okc_debug.log('2500: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
121: END IF;
122:

Line 140: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

136: END get_item_dtl_for_expert;
137:
138: Function ok_to_commit (
139: p_api_version IN Number,
140: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
141: p_doc_id IN Number,
142: p_validation_string IN Varchar2 default NULL,
143: x_return_status OUT NOCOPY Varchar2,
144: x_msg_data OUT NOCOPY Varchar2,

Line 155: x_return_status := FND_API.G_RET_STS_SUCCESS;

151: l_update_allowed Boolean;
152: l_return_value varchar2(1);
153: BEGIN
154:
155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156:
157: l_update_allowed :=OKS_AUTH_INT_PUB.ok_to_commit(
158: p_api_version => l_api_version,
159: p_init_msg_list => FND_API.G_FALSE,

Line 159: p_init_msg_list => FND_API.G_FALSE,

155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156:
157: l_update_allowed :=OKS_AUTH_INT_PUB.ok_to_commit(
158: p_api_version => l_api_version,
159: p_init_msg_list => FND_API.G_FALSE,
160: p_doc_id => p_doc_id,
161: p_doc_validation_string=> p_validation_string,
162: x_return_status => x_return_status,
163: x_msg_data => x_msg_data,

Line 168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

164: x_msg_count => x_msg_count);
165:
166: --------------------------------------------
167: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
169: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
170: RAISE FND_API.G_EXC_ERROR ;
171: END IF;
172: --------------------------------------------

Line 170: RAISE FND_API.G_EXC_ERROR ;

166: --------------------------------------------
167: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
169: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
170: RAISE FND_API.G_EXC_ERROR ;
171: END IF;
172: --------------------------------------------
173:
174: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 177: l_return_value :=FND_API.G_TRUE;

173:
174: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
175:
176: IF l_update_allowed then
177: l_return_value :=FND_API.G_TRUE;
178: ELSE
179: l_return_value :=FND_API.G_FALSE;
180: END IF;
181:

Line 179: l_return_value :=FND_API.G_FALSE;

175:
176: IF l_update_allowed then
177: l_return_value :=FND_API.G_TRUE;
178: ELSE
179: l_return_value :=FND_API.G_FALSE;
180: END IF;
181:
182: return l_return_value;
183:

Line 185: WHEN FND_API.G_EXC_ERROR THEN

181:
182: return l_return_value;
183:
184: EXCEPTION
185: WHEN FND_API.G_EXC_ERROR THEN
186: IF (l_debug = 'Y') THEN
187: okc_debug.log('2400: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception', 2);
188: END IF;
189:

Line 192: return FND_API.G_FALSE;

188: END IF;
189:
190: x_return_status := G_RET_STS_ERROR ;
191: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
192: return FND_API.G_FALSE;
193:
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: IF (l_debug = 'Y') THEN
196: okc_debug.log('2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

190: x_return_status := G_RET_STS_ERROR ;
191: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
192: return FND_API.G_FALSE;
193:
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: IF (l_debug = 'Y') THEN
196: okc_debug.log('2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
197: END IF;
198:

Line 201: return FND_API.G_FALSE;

197: END IF;
198:
199: x_return_status := G_RET_STS_UNEXP_ERROR ;
200: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
201: return FND_API.G_FALSE;
202: WHEN OTHERS THEN
203: IF (l_debug = 'Y') THEN
204: okc_debug.log('2600: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm, 2);
205: END IF;

Line 213: return FND_API.G_FALSE;

209: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
211: END IF;
212: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
213: return FND_API.G_FALSE;
214:
215: END ok_to_commit;
216: END OKC_OKS_INT_GRP;