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_PO_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_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;

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_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;

Line 21: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;

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_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
25: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;

Line 22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;

18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
25: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;
26: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;

19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
25: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;
26: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
27: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';

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

20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
25: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;
26: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
27: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
28: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';

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

21: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
25: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;
26: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
27: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
28: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
29: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';

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

22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
25: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;
26: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
27: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
28: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
29: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
30:

Line 38: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

34:
35:
36: Procedure get_article_variable_values(
37: p_api_version IN Number,
38: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
39: p_doc_id IN Number,
40: p_sys_var_value_tbl IN OUT NOCOPY sys_var_value_tbl_type,
41: x_return_status OUT NOCOPY Varchar2,
42: x_msg_data OUT NOCOPY Varchar2,

Line 48: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 56: p_init_msg_list => FND_API.G_FALSE,

52: END IF;
53:
54: PO_CONTERMS_UTL_GRP.Get_PO_Attribute_values(
55: p_api_version => l_api_version,
56: p_init_msg_list => FND_API.G_FALSE,
57: p_doc_id => p_doc_id,
58: p_sys_var_value_tbl => p_sys_var_value_tbl,
59: x_return_status => x_return_status,
60: x_msg_data => x_msg_data,

Line 65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 67: RAISE FND_API.G_EXC_ERROR ;

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

Line 76: WHEN FND_API.G_EXC_ERROR THEN

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

Line 90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 122: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

118: END;
119:
120: Procedure get_changed_variables(
121: p_api_version IN Number,
122: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
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,
126: x_msg_data 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 PO_CONTERMS_UTL_GRP.attribute_value_changed');
136: END IF;

Line 140: p_init_msg_list => FND_API.G_FALSE,

136: END IF;
137:
138: PO_CONTERMS_UTL_GRP.attribute_value_changed(
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_sys_var_tbl => p_sys_var_tbl,
143: x_return_status => x_return_status,
144: x_msg_data => x_msg_data,

Line 149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 151: RAISE FND_API.G_EXC_ERROR ;

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

Line 160: WHEN FND_API.G_EXC_ERROR THEN

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

Line 174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 206: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

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

Line 218: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 226: p_init_msg_list => FND_API.G_FALSE,

222: END IF;
223:
224: PO_CONTERMS_UTL_GRP.get_item_categorylist(
225: p_api_version => l_api_version,
226: p_init_msg_list => FND_API.G_FALSE,
227: p_document_id => p_doc_id,
228: x_category_tbl => l_category_tbl,
229: x_item_tbl => x_item_tbl,
230: x_return_status => x_return_status,

Line 236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 238: RAISE FND_API.G_EXC_ERROR ;

234: --------------------------------------------
235: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
237: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
238: RAISE FND_API.G_EXC_ERROR ;
239: END IF;
240: --------------------------------------------
241: IF l_category_tbl.count > 0 THEN
242: FOR i in l_category_tbl.FIRST..l_category_tbl.LAST LOOP

Line 253: WHEN FND_API.G_EXC_ERROR THEN

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

Line 267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 299: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

295: END get_item_dtl_for_expert;
296:
297: Function ok_to_commit (
298: p_api_version IN Number,
299: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
300: p_doc_id IN Number,
301: p_tmpl_change IN Varchar2 default NULL,
302: p_validation_string IN Varchar2 default NULL,
303: x_return_status OUT NOCOPY Varchar2,

Line 314: x_return_status := FND_API.G_RET_STS_SUCCESS;

310: l_api_name CONSTANT VARCHAR2(30) := 'g_ok_to_commit';
311: l_update_allowed VARCHAR2(1) :='N';
312: BEGIN
313:
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:
316: IF p_tmpl_change IS NULL THEN
317:
318: PO_CONTERMS_UTL_GRP.is_po_update_allowed(

Line 320: p_init_msg_list => FND_API.G_FALSE,

316: IF p_tmpl_change IS NULL THEN
317:
318: PO_CONTERMS_UTL_GRP.is_po_update_allowed(
319: p_api_version => l_api_version,
320: p_init_msg_list => FND_API.G_FALSE,
321: p_header_id => p_doc_id,
322: p_callout_string => p_validation_string,
323: p_lock_flag => 'N',
324: x_update_allowed => l_update_allowed,

Line 330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

326: x_msg_data => x_msg_data,
327: x_msg_count => x_msg_count);
328: --------------------------------------------
329: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
331: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
332: RAISE FND_API.G_EXC_ERROR ;
333: END IF;
334: --------------------------------------------

Line 332: RAISE FND_API.G_EXC_ERROR ;

328: --------------------------------------------
329: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
331: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
332: RAISE FND_API.G_EXC_ERROR ;
333: END IF;
334: --------------------------------------------
335: ELSE
336: PO_CONTERMS_UTL_GRP.Apply_Template_Change(

Line 338: p_init_msg_list => FND_API.G_FALSE,

334: --------------------------------------------
335: ELSE
336: PO_CONTERMS_UTL_GRP.Apply_Template_Change(
337: p_api_version => l_api_version,
338: p_init_msg_list => FND_API.G_FALSE,
339: p_header_id => p_doc_id,
340: p_callout_string => p_validation_string,
341: p_template_changed => p_tmpl_change,
342: p_commit => FND_API.G_FALSE,

Line 342: p_commit => FND_API.G_FALSE,

338: p_init_msg_list => FND_API.G_FALSE,
339: p_header_id => p_doc_id,
340: p_callout_string => p_validation_string,
341: p_template_changed => p_tmpl_change,
342: p_commit => FND_API.G_FALSE,
343: x_update_allowed => l_update_allowed,
344: x_return_status => x_return_status,
345: x_msg_data => x_msg_data,
346: x_msg_count => x_msg_count);

Line 349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

345: x_msg_data => x_msg_data,
346: x_msg_count => x_msg_count);
347: --------------------------------------------
348: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
350: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
351: RAISE FND_API.G_EXC_ERROR ;
352: END IF;
353: --------------------------------------------

Line 351: RAISE FND_API.G_EXC_ERROR ;

347: --------------------------------------------
348: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
350: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
351: RAISE FND_API.G_EXC_ERROR ;
352: END IF;
353: --------------------------------------------
354: END IF;
355:

Line 359: return FND_API.G_TRUE;

355:
356: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
357:
358: IF l_update_allowed='Y' THEN
359: return FND_API.G_TRUE;
360: ELSE
361: return FND_API.G_FALSE;
362: END IF;
363:

Line 361: return FND_API.G_FALSE;

357:
358: IF l_update_allowed='Y' THEN
359: return FND_API.G_TRUE;
360: ELSE
361: return FND_API.G_FALSE;
362: END IF;
363:
364: EXCEPTION
365: WHEN FND_API.G_EXC_ERROR THEN

Line 365: WHEN FND_API.G_EXC_ERROR THEN

361: return FND_API.G_FALSE;
362: END IF;
363:
364: EXCEPTION
365: WHEN FND_API.G_EXC_ERROR THEN
366: /*IF (l_debug = 'Y') THEN
367: okc_debug.log('2400: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception', 2);
368: END IF;*/
369:

Line 377: return FND_API.G_FALSE;

373: END IF;
374:
375: x_return_status := G_RET_STS_ERROR ;
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: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: /*IF (l_debug = 'Y') THEN
381: okc_debug.log('2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

375: x_return_status := G_RET_STS_ERROR ;
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: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: /*IF (l_debug = 'Y') THEN
381: okc_debug.log('2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
382: END IF;*/
383:

Line 391: return FND_API.G_FALSE;

387: END IF;
388:
389: x_return_status := G_RET_STS_UNEXP_ERROR ;
390: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
391: return FND_API.G_FALSE;
392: WHEN OTHERS THEN
393: /*IF (l_debug = 'Y') THEN
394: okc_debug.log('2600: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm, 2);
395: END IF;*/

Line 408: return FND_API.G_FALSE;

404: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
405: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
406: END IF;
407: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
408: return FND_API.G_FALSE;
409:
410:
411: END ok_to_commit;
412:

Line 415: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

411: END ok_to_commit;
412:
413: PROCEDURE Get_Last_Signed_Revision (
414: p_api_version IN NUMBER,
415: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
416: p_doc_id IN NUMBER,
417: p_revision_num IN NUMBER,
418: x_signed_revision_num OUT NOCOPY NUMBER,
419: x_return_status OUT NOCOPY VARCHAR2,

Line 427: x_return_status := FND_API.G_RET_STS_SUCCESS;

423: l_api_version CONSTANT NUMBER := 1;
424: l_api_name CONSTANT VARCHAR2(30) := 'Get_Last_Signed_Revision';
425: l_signed_record Varchar2(1);
426: BEGIN
427: x_return_status := FND_API.G_RET_STS_SUCCESS;
428:
429: IF l_debug='Y' THEN
430: okc_util.print_trace(1,' Calling PO_CONTERMS_UTL_GRP.Get_Last_Signed_Revision');
431: END IF;

Line 435: p_init_msg_list => FND_API.G_FALSE,

431: END IF;
432:
433: PO_CONTERMS_UTL_GRP.Get_Last_Signed_Revision(
434: p_api_version => l_api_version,
435: p_init_msg_list => FND_API.G_FALSE,
436: p_header_id => p_doc_id,
437: p_revision_num => p_revision_num,
438: x_signed_revision_num => x_signed_revision_num,
439: x_signed_records => l_signed_record,

Line 446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

442: x_msg_count => x_msg_count);
443:
444: --------------------------------------------
445: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
447: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
448: RAISE FND_API.G_EXC_ERROR ;
449: END IF;
450: --------------------------------------------

Line 448: RAISE FND_API.G_EXC_ERROR ;

444: --------------------------------------------
445: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
447: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
448: RAISE FND_API.G_EXC_ERROR ;
449: END IF;
450: --------------------------------------------
451: IF l_signed_record <>'Y' THEN
452: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

449: END IF;
450: --------------------------------------------
451: IF l_signed_record <>'Y' THEN
452: x_return_status := G_RET_STS_UNEXP_ERROR;
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
454: END IF;
455:
456: IF l_debug='Y' THEN
457: okc_util.print_trace(1,' Leaving OKC_PO_INT_GRP.Get_Last_Signed_Revision');

Line 462: WHEN FND_API.G_EXC_ERROR THEN

458: END IF;
459: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
460:
461: EXCEPTION
462: WHEN FND_API.G_EXC_ERROR THEN
463:
464: /*IF (l_debug = 'Y') THEN
465: okc_debug.log('2400: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_ERROR Exception', 2);
466: END IF;*/

Line 476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

472:
473: x_return_status := G_RET_STS_ERROR ;
474: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
475:
476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
477: /*IF (l_debug = 'Y') THEN
478: okc_debug.log('2500: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
479: END IF;*/
480: