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.

[Home] [Help]

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_type IN Varchar2,
40: p_doc_id IN Number,
41: p_sys_var_value_tbl IN OUT NOCOPY sys_var_value_tbl_type,
42: x_return_status OUT NOCOPY Varchar2,

Line 49: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 57: p_init_msg_list => FND_API.G_FALSE,

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

Line 67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 69: RAISE FND_API.G_EXC_ERROR ;

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

Line 78: WHEN FND_API.G_EXC_ERROR THEN

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

Line 92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 124: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

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

Line 135: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 143: p_init_msg_list => FND_API.G_FALSE,

139: END IF;
140:
141: PO_CONTERMS_UTL_GRP.attribute_value_changed(
142: p_api_version => l_api_version,
143: p_init_msg_list => FND_API.G_FALSE,
144: p_doc_type => p_doc_type,
145: p_doc_id => p_doc_id,
146: p_sys_var_tbl => p_sys_var_tbl,
147: x_return_status => x_return_status,

Line 153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 155: RAISE FND_API.G_EXC_ERROR ;

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

Line 164: WHEN FND_API.G_EXC_ERROR THEN

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

Line 178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 210: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

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

Line 223: x_return_status := FND_API.G_RET_STS_SUCCESS;

219: l_api_version CONSTANT NUMBER := 1;
220: l_api_name CONSTANT VARCHAR2(30) := 'g_get_item_dtl_for_expert';
221: l_category_tbl category_tbl_type;
222: BEGIN
223: x_return_status := FND_API.G_RET_STS_SUCCESS;
224:
225: IF l_debug='Y' THEN
226: okc_util.print_trace(1,' Calling PO_CONTERMS_UTL_GRP.get_item_categorylist');
227: END IF;

Line 231: p_init_msg_list => FND_API.G_FALSE,

227: END IF;
228:
229: PO_CONTERMS_UTL_GRP.get_item_categorylist(
230: p_api_version => l_api_version,
231: p_init_msg_list => FND_API.G_FALSE,
232: p_doc_type => p_doc_type,
233: p_document_id => p_doc_id,
234: x_category_tbl => l_category_tbl,
235: x_item_tbl => x_item_tbl,

Line 242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

238: x_msg_count => x_msg_count);
239:
240: --------------------------------------------
241: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
243: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
244: RAISE FND_API.G_EXC_ERROR ;
245: END IF;
246: --------------------------------------------

Line 244: RAISE FND_API.G_EXC_ERROR ;

240: --------------------------------------------
241: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
243: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
244: RAISE FND_API.G_EXC_ERROR ;
245: END IF;
246: --------------------------------------------
247: IF l_category_tbl.count > 0 THEN
248: FOR i in l_category_tbl.FIRST..l_category_tbl.LAST LOOP

Line 259: WHEN FND_API.G_EXC_ERROR THEN

255: END IF;
256: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
257:
258: EXCEPTION
259: WHEN FND_API.G_EXC_ERROR THEN
260:
261: /*IF (l_debug = 'Y') THEN
262: okc_debug.log('2400: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_ERROR Exception', 2);
263: END IF;*/

Line 273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

269:
270: x_return_status := G_RET_STS_ERROR ;
271: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
272:
273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
274: /*IF (l_debug = 'Y') THEN
275: okc_debug.log('2500: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
276: END IF;*/
277:

Line 305: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

301: END get_item_dtl_for_expert;
302:
303: Function ok_to_commit (
304: p_api_version IN Number,
305: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
306: p_doc_type IN Varchar2,
307: p_doc_id IN Number,
308: p_tmpl_change IN Varchar2 default NULL,
309: p_validation_string IN Varchar2 default NULL,

Line 323: x_return_status := FND_API.G_RET_STS_SUCCESS;

319: l_update_allowed VARCHAR2(1) :='N';
320: l_tmpl_change VARCHAR2(20) := p_tmpl_change;
321: BEGIN
322:
323: x_return_status := FND_API.G_RET_STS_SUCCESS;
324:
325: -- If p_tmpl_change is null and template usage does not exists and the deliverable count is 1
326: -- then make p_tmpl_change
327: IF p_del_commit_mode = 'C' -- Deliverable is being created.

Line 381: p_init_msg_list => FND_API.G_FALSE,

377: IF l_tmpl_change IS NULL THEN
378:
379: PO_CONTERMS_UTL_GRP.is_po_update_allowed(
380: p_api_version => l_api_version,
381: p_init_msg_list => FND_API.G_FALSE,
382: p_doc_type => p_doc_type ,
383: p_header_id => p_doc_id,
384: p_callout_string => p_validation_string,
385: p_lock_flag => 'N',

Line 392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

388: x_msg_data => x_msg_data,
389: x_msg_count => x_msg_count);
390: --------------------------------------------
391: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
393: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
394: RAISE FND_API.G_EXC_ERROR ;
395: END IF;
396: --------------------------------------------

Line 394: RAISE FND_API.G_EXC_ERROR ;

390: --------------------------------------------
391: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
393: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
394: RAISE FND_API.G_EXC_ERROR ;
395: END IF;
396: --------------------------------------------
397: ELSE
398: PO_CONTERMS_UTL_GRP.Apply_Template_Change(

Line 400: p_init_msg_list => FND_API.G_FALSE,

396: --------------------------------------------
397: ELSE
398: PO_CONTERMS_UTL_GRP.Apply_Template_Change(
399: p_api_version => l_api_version,
400: p_init_msg_list => FND_API.G_FALSE,
401: p_doc_type => p_doc_type,
402: p_header_id => p_doc_id,
403: p_callout_string => p_validation_string,
404: p_template_changed => l_tmpl_change,

Line 405: p_commit => FND_API.G_FALSE,

401: p_doc_type => p_doc_type,
402: p_header_id => p_doc_id,
403: p_callout_string => p_validation_string,
404: p_template_changed => l_tmpl_change,
405: p_commit => FND_API.G_FALSE,
406: x_update_allowed => l_update_allowed,
407: x_return_status => x_return_status,
408: x_msg_data => x_msg_data,
409: x_msg_count => x_msg_count);

Line 412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

408: x_msg_data => x_msg_data,
409: x_msg_count => x_msg_count);
410: --------------------------------------------
411: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
413: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
414: RAISE FND_API.G_EXC_ERROR ;
415: END IF;
416: --------------------------------------------

Line 414: RAISE FND_API.G_EXC_ERROR ;

410: --------------------------------------------
411: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
413: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
414: RAISE FND_API.G_EXC_ERROR ;
415: END IF;
416: --------------------------------------------
417: END IF;
418:

Line 422: return FND_API.G_TRUE;

418:
419: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
420:
421: IF l_update_allowed='Y' THEN
422: return FND_API.G_TRUE;
423: ELSE
424: return FND_API.G_FALSE;
425: END IF;
426:

Line 424: return FND_API.G_FALSE;

420:
421: IF l_update_allowed='Y' THEN
422: return FND_API.G_TRUE;
423: ELSE
424: return FND_API.G_FALSE;
425: END IF;
426:
427: EXCEPTION
428: WHEN FND_API.G_EXC_ERROR THEN

Line 428: WHEN FND_API.G_EXC_ERROR THEN

424: return FND_API.G_FALSE;
425: END IF;
426:
427: EXCEPTION
428: WHEN FND_API.G_EXC_ERROR THEN
429: /*IF (l_debug = 'Y') THEN
430: okc_debug.log('2400: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception', 2);
431: END IF;*/
432:

Line 440: return FND_API.G_FALSE;

436: END IF;
437:
438: x_return_status := G_RET_STS_ERROR ;
439: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
440: return FND_API.G_FALSE;
441:
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443: /*IF (l_debug = 'Y') THEN
444: okc_debug.log('2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

438: x_return_status := G_RET_STS_ERROR ;
439: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
440: return FND_API.G_FALSE;
441:
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443: /*IF (l_debug = 'Y') THEN
444: okc_debug.log('2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
445: END IF;*/
446:

Line 454: return FND_API.G_FALSE;

450: END IF;
451:
452: x_return_status := G_RET_STS_UNEXP_ERROR ;
453: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
454: return FND_API.G_FALSE;
455: WHEN OTHERS THEN
456: /*IF (l_debug = 'Y') THEN
457: okc_debug.log('2600: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm, 2);
458: END IF;*/

Line 471: return FND_API.G_FALSE;

467: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
468: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
469: END IF;
470: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
471: return FND_API.G_FALSE;
472:
473:
474: END ok_to_commit;
475:

Line 478: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

474: END ok_to_commit;
475:
476: PROCEDURE Get_Last_Signed_Revision (
477: p_api_version IN NUMBER,
478: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
479: p_doc_type IN VARCHAR2,
480: p_doc_id IN NUMBER,
481: p_revision_num IN NUMBER,
482: x_signed_revision_num OUT NOCOPY NUMBER,

Line 491: x_return_status := FND_API.G_RET_STS_SUCCESS;

487: l_api_version CONSTANT NUMBER := 1;
488: l_api_name CONSTANT VARCHAR2(30) := 'Get_Last_Signed_Revision';
489: l_signed_record Varchar2(1);
490: BEGIN
491: x_return_status := FND_API.G_RET_STS_SUCCESS;
492:
493: IF l_debug='Y' THEN
494: okc_util.print_trace(1,' Calling PO_CONTERMS_UTL_GRP.Get_Last_Signed_Revision');
495: END IF;

Line 499: p_init_msg_list => FND_API.G_FALSE,

495: END IF;
496:
497: PO_CONTERMS_UTL_GRP.Get_Last_Signed_Revision(
498: p_api_version => l_api_version,
499: p_init_msg_list => FND_API.G_FALSE,
500: p_doc_type => p_doc_type,
501: p_header_id => p_doc_id,
502: p_revision_num => p_revision_num,
503: x_signed_revision_num => x_signed_revision_num,

Line 511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

507: x_msg_count => x_msg_count);
508:
509: --------------------------------------------
510: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
512: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
513: RAISE FND_API.G_EXC_ERROR ;
514: END IF;
515: --------------------------------------------

Line 513: RAISE FND_API.G_EXC_ERROR ;

509: --------------------------------------------
510: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
512: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
513: RAISE FND_API.G_EXC_ERROR ;
514: END IF;
515: --------------------------------------------
516: IF l_signed_record <>'Y' THEN
517: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

514: END IF;
515: --------------------------------------------
516: IF l_signed_record <>'Y' THEN
517: x_return_status := G_RET_STS_UNEXP_ERROR;
518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
519: END IF;
520:
521: IF l_debug='Y' THEN
522: okc_util.print_trace(1,' Leaving OKC_PO_INT_GRP.Get_Last_Signed_Revision');

Line 527: WHEN FND_API.G_EXC_ERROR THEN

523: END IF;
524: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
525:
526: EXCEPTION
527: WHEN FND_API.G_EXC_ERROR THEN
528:
529: /*IF (l_debug = 'Y') THEN
530: okc_debug.log('2400: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_ERROR Exception', 2);
531: END IF;*/

Line 541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

537:
538: x_return_status := G_RET_STS_ERROR ;
539: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
540:
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: /*IF (l_debug = 'Y') THEN
543: okc_debug.log('2500: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
544: END IF;*/
545: