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_PON_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 35: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

31:
32:
33: Procedure get_article_variable_values(
34: p_api_version IN Number,
35: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
36: p_doc_type IN Varchar2,
37: p_doc_id IN Number,
38: p_sys_var_value_tbl IN OUT NOCOPY sys_var_value_tbl_type,
39: x_return_status OUT NOCOPY Varchar2,

Line 46: x_return_status := FND_API.G_RET_STS_SUCCESS;

42: )IS
43: l_api_version CONSTANT NUMBER := 1;
44: l_api_name CONSTANT VARCHAR2(30) := 'g_get_article_variable_values';
45: BEGIN
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47:
48: IF l_debug='Y' THEN
49: okc_util.print_trace(1,' Calling PON_CONTERMS_UTL_GRP.Get_PO_Attribute_values');
50: END IF;

Line 54: p_init_msg_list => FND_API.G_FALSE,

50: END IF;
51:
52: PON_CONTERMS_UTL_GRP.get_article_variable_values(
53: p_api_version => l_api_version,
54: p_init_msg_list => FND_API.G_FALSE,
55: p_doctype_id => p_doc_type,
56: p_doc_id => p_doc_id,
57: p_sys_var_value_tbl => p_sys_var_value_tbl,
58: x_return_status => x_return_status,

Line 64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

60: x_msg_count => x_msg_count);
61:
62: --------------------------------------------
63: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
65: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
66: RAISE FND_API.G_EXC_ERROR ;
67: END IF;
68: --------------------------------------------

Line 66: RAISE FND_API.G_EXC_ERROR ;

62: --------------------------------------------
63: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
65: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
66: RAISE FND_API.G_EXC_ERROR ;
67: END IF;
68: --------------------------------------------
69: IF l_debug='Y' THEN
70: okc_util.print_trace(1,' Leaving PON_CONTERMS_UTL_GRP.Get_PO_Attribute_values');

Line 75: WHEN FND_API.G_EXC_ERROR THEN

71: END IF;
72: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
73:
74: EXCEPTION
75: WHEN FND_API.G_EXC_ERROR THEN
76:
77: /*IF (l_debug = 'Y') THEN
78: okc_debug.log('2400: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);
79: END IF;*/

Line 89: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

85:
86: x_return_status := G_RET_STS_ERROR ;
87: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
88:
89: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
90: /*IF (l_debug = 'Y') THEN
91: okc_debug.log('2500: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
92: END IF;*/
93:

Line 121: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

117: END get_article_variable_values;
118:
119: Procedure get_changed_variables(
120: p_api_version IN Number,
121: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
122: p_doc_type IN Varchar2,
123: p_doc_id IN Number,
124: p_sys_var_tbl IN OUT NOCOPY sys_var_tbl_type,
125: x_return_status OUT NOCOPY Varchar2,

Line 132: x_return_status := FND_API.G_RET_STS_SUCCESS;

128: ) IS
129: l_api_version CONSTANT NUMBER := 1;
130: l_api_name CONSTANT VARCHAR2(30) := 'g_get_changed_variables';
131: BEGIN
132: x_return_status := FND_API.G_RET_STS_SUCCESS;
133:
134: IF l_debug='Y' THEN
135: okc_util.print_trace(1,' Calling PON_CONTERMS_UTL_GRP.attribute_value_changed');
136: END IF;

Line 140: p_init_msg_list => FND_API.G_FALSE,

136: END IF;
137:
138: PON_CONTERMS_UTL_GRP.get_changed_variables(
139: p_api_version => l_api_version,
140: p_init_msg_list => FND_API.G_FALSE,
141: p_doc_id => p_doc_id,
142: p_doctype_id => p_doc_type,
143: p_sys_var_tbl => p_sys_var_tbl,
144: x_return_status => x_return_status,

Line 150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

146: x_msg_count => x_msg_count);
147:
148: --------------------------------------------
149: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
151: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
152: RAISE FND_API.G_EXC_ERROR ;
153: END IF;
154: --------------------------------------------

Line 152: RAISE FND_API.G_EXC_ERROR ;

148: --------------------------------------------
149: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
151: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
152: RAISE FND_API.G_EXC_ERROR ;
153: END IF;
154: --------------------------------------------
155: IF l_debug='Y' THEN
156: okc_util.print_trace(1,' Leaving PON_CONTERMS_UTL_GRP.attribute_value_changed');

Line 161: WHEN FND_API.G_EXC_ERROR THEN

157: END IF;
158: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
159:
160: EXCEPTION
161: WHEN FND_API.G_EXC_ERROR THEN
162:
163: /*IF (l_debug = 'Y') THEN
164: okc_debug.log('2400: Leaving get_changed_variables: OKC_API.G_EXCEPTION_ERROR Exception', 2);
165: END IF;*/

Line 175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

171:
172: x_return_status := G_RET_STS_ERROR ;
173: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
174:
175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
176: /*IF (l_debug = 'Y') THEN
177: okc_debug.log('2500: Leaving get_changed_variables: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
178: END IF;*/
179:

Line 207: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

203: END get_changed_variables;
204:
205: Procedure get_item_dtl_for_expert(
206: p_api_version IN Number,
207: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
208: p_doc_type IN Varchar2,
209: p_doc_id IN Number,
210: x_category_tbl OUT NOCOPY item_tbl_type,
211: x_item_tbl OUT NOCOPY item_tbl_type,

Line 219: x_return_status := FND_API.G_RET_STS_SUCCESS;

215: )IS
216: l_api_version CONSTANT NUMBER := 1;
217: l_api_name CONSTANT VARCHAR2(30) := 'g_get_item_dtl_for_expert';
218: BEGIN
219: x_return_status := FND_API.G_RET_STS_SUCCESS;
220:
221: IF l_debug='Y' THEN
222: okc_util.print_trace(1,' Calling PON_CONTERMS_UTL_GRP.get_item_dtl_for_expert');
223: END IF;

Line 227: p_init_msg_list => FND_API.G_FALSE,

223: END IF;
224:
225: PON_CONTERMS_UTL_GRP.get_item_category(
226: p_api_version => l_api_version,
227: p_init_msg_list => FND_API.G_FALSE,
228: p_doctype_id => p_doc_type,
229: p_doc_id => p_doc_id,
230: x_category_tbl => x_category_tbl,
231: x_item_tbl => x_item_tbl,

Line 238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

234: x_msg_count => x_msg_count);
235:
236: --------------------------------------------
237: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
239: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
240: RAISE FND_API.G_EXC_ERROR ;
241: END IF;
242: --------------------------------------------

Line 240: RAISE FND_API.G_EXC_ERROR ;

236: --------------------------------------------
237: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
239: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
240: RAISE FND_API.G_EXC_ERROR ;
241: END IF;
242: --------------------------------------------
243: IF l_debug='Y' THEN
244: okc_util.print_trace(1,' Leaving PON_CONTERMS_UTL_GRP.get_item_dtl_for_expert');

Line 249: WHEN FND_API.G_EXC_ERROR THEN

245: END IF;
246: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
247:
248: EXCEPTION
249: WHEN FND_API.G_EXC_ERROR THEN
250:
251: /*IF (l_debug = 'Y') THEN
252: okc_debug.log('2400: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_ERROR Exception', 2);
253: END IF;*/

Line 263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

259:
260: x_return_status := G_RET_STS_ERROR ;
261: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
262:
263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
264: /*IF (l_debug = 'Y') THEN
265: okc_debug.log('2500: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
266: END IF;*/
267:

Line 295: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

291: END get_item_dtl_for_expert;
292:
293: Function ok_to_commit (
294: p_api_version IN Number,
295: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
296: p_doc_type IN Varchar2,
297: p_doc_id IN Number,
298: p_validation_string IN Varchar2 default NULL,
299: x_return_status OUT NOCOPY Varchar2,

Line 310: x_return_status := FND_API.G_RET_STS_SUCCESS;

306: l_api_name CONSTANT VARCHAR2(30) := 'g_ok_to_commit';
307: l_update_allowed Varchar2(10);
308: BEGIN
309:
310: x_return_status := FND_API.G_RET_STS_SUCCESS;
311:
312: PON_CONTERMS_UTL_GRP.ok_to_commit(
313: p_api_version => l_api_version,
314: p_init_msg_list => FND_API.G_FALSE,

Line 314: p_init_msg_list => FND_API.G_FALSE,

310: x_return_status := FND_API.G_RET_STS_SUCCESS;
311:
312: PON_CONTERMS_UTL_GRP.ok_to_commit(
313: p_api_version => l_api_version,
314: p_init_msg_list => FND_API.G_FALSE,
315: p_doc_id => p_doc_id,
316: p_doctype_id => p_doc_type,
317: x_update_allowed => l_update_allowed,
318: x_return_status => x_return_status,

Line 323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

319: x_msg_data => x_msg_data,
320: x_msg_count => x_msg_count);
321: --------------------------------------------
322: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
324: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
325: RAISE FND_API.G_EXC_ERROR ;
326: END IF;
327: --------------------------------------------

Line 325: RAISE FND_API.G_EXC_ERROR ;

321: --------------------------------------------
322: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
324: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
325: RAISE FND_API.G_EXC_ERROR ;
326: END IF;
327: --------------------------------------------
328:
329: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 331: return nvl(l_update_allowed, FND_API.G_FALSE);

327: --------------------------------------------
328:
329: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
330:
331: return nvl(l_update_allowed, FND_API.G_FALSE);
332:
333: EXCEPTION
334: WHEN FND_API.G_EXC_ERROR THEN
335: /*IF (l_debug = 'Y') THEN

Line 334: WHEN FND_API.G_EXC_ERROR THEN

330:
331: return nvl(l_update_allowed, FND_API.G_FALSE);
332:
333: EXCEPTION
334: WHEN FND_API.G_EXC_ERROR THEN
335: /*IF (l_debug = 'Y') THEN
336: okc_debug.log('2400: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception', 2);
337: END IF;*/
338:

Line 346: return FND_API.G_FALSE;

342: END IF;
343:
344: x_return_status := G_RET_STS_ERROR ;
345: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
346: return FND_API.G_FALSE;
347:
348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
349: /*IF (l_debug = 'Y') THEN
350: okc_debug.log('2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

344: x_return_status := G_RET_STS_ERROR ;
345: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
346: return FND_API.G_FALSE;
347:
348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
349: /*IF (l_debug = 'Y') THEN
350: okc_debug.log('2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
351: END IF;*/
352:

Line 360: return FND_API.G_FALSE;

356: END IF;
357:
358: x_return_status := G_RET_STS_UNEXP_ERROR ;
359: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
360: return FND_API.G_FALSE;
361: WHEN OTHERS THEN
362: /*IF (l_debug = 'Y') THEN
363: okc_debug.log('2600: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm, 2);
364: END IF;*/

Line 377: return FND_API.G_FALSE;

373: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
374: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
375: END IF;
376: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
377: return FND_API.G_FALSE;
378:
379: END ok_to_commit;
380: END OKC_PON_INT_GRP;