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

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

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

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

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

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

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

Line 21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

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

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

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

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

25: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
26: G_AMEND_CODE_ADDED CONSTANT VARCHAR2(30) := 'ADDED';
27: G_AMEND_CODE_UPDATED CONSTANT VARCHAR2(30) := 'UPDATED';
28:
29: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
30: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
31: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
32:
33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

26: G_AMEND_CODE_ADDED CONSTANT VARCHAR2(30) := 'ADDED';
27: G_AMEND_CODE_UPDATED CONSTANT VARCHAR2(30) := 'UPDATED';
28:
29: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
30: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
31: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
32:
33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

27: G_AMEND_CODE_UPDATED CONSTANT VARCHAR2(30) := 'UPDATED';
28:
29: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
30: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
31: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
32:
33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 113: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

109:
110: -- Standard Start of API savepoint
111: SAVEPOINT g_create_non_std_article_GRP;
112: -- Standard call to check for call compatibility.
113: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116: -- Initialize message list if p_init_msg_list is set to TRUE.
117: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

110: -- Standard Start of API savepoint
111: SAVEPOINT g_create_non_std_article_GRP;
112: -- Standard call to check for call compatibility.
113: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116: -- Initialize message list if p_init_msg_list is set to TRUE.
117: IF FND_API.to_Boolean( p_init_msg_list ) THEN
118: FND_MSG_PUB.initialize;

Line 117: IF FND_API.to_Boolean( p_init_msg_list ) THEN

113: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116: -- Initialize message list if p_init_msg_list is set to TRUE.
117: IF FND_API.to_Boolean( p_init_msg_list ) THEN
118: FND_MSG_PUB.initialize;
119: END IF;
120:
121: IF FND_API.To_Boolean( p_validate_commit ) THEN

Line 121: IF FND_API.To_Boolean( p_validate_commit ) THEN

117: IF FND_API.to_Boolean( p_init_msg_list ) THEN
118: FND_MSG_PUB.initialize;
119: END IF;
120:
121: IF FND_API.To_Boolean( p_validate_commit ) THEN
122:
123: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
124: p_api_version => l_api_version,
125: p_init_msg_list => FND_API.G_FALSE,

Line 123: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

119: END IF;
120:
121: IF FND_API.To_Boolean( p_validate_commit ) THEN
122:
123: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
124: p_api_version => l_api_version,
125: p_init_msg_list => FND_API.G_FALSE,
126: p_doc_type => p_doc_type,
127: p_doc_id => p_doc_id,

Line 125: p_init_msg_list => FND_API.G_FALSE,

121: IF FND_API.To_Boolean( p_validate_commit ) THEN
122:
123: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
124: p_api_version => l_api_version,
125: p_init_msg_list => FND_API.G_FALSE,
126: p_doc_type => p_doc_type,
127: p_doc_id => p_doc_id,
128: p_validation_string => p_validation_string,
129: x_return_status => x_return_status,

Line 141: RAISE FND_API.G_EXC_ERROR ;

137: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
138: FND_LOG.STRING(G_PROC_LEVEL,
139: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
140: END IF;
141: RAISE FND_API.G_EXC_ERROR ;
142: END IF;
143: END IF;
144:
145: -- Initialize API return status to success

Line 146: x_return_status := FND_API.G_RET_STS_SUCCESS;

142: END IF;
143: END IF;
144:
145: -- Initialize API return status to success
146: x_return_status := FND_API.G_RET_STS_SUCCESS;
147:
148: /*IF (l_debug = 'Y') THEN
149: okc_debug.log('200: Creating non-std article', 2);
150: END IF;*/

Line 168: p_init_msg_list => FND_API.G_FALSE,

164:
165:
166: OKC_ARTICLES_GRP.create_article(
167: p_api_version => 1,
168: p_init_msg_list => FND_API.G_FALSE,
169: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
170: p_commit => FND_API.G_FALSE,
171: x_return_status => x_return_status,
172: x_msg_count => x_msg_count,

Line 169: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

165:
166: OKC_ARTICLES_GRP.create_article(
167: p_api_version => 1,
168: p_init_msg_list => FND_API.G_FALSE,
169: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
170: p_commit => FND_API.G_FALSE,
171: x_return_status => x_return_status,
172: x_msg_count => x_msg_count,
173: x_msg_data => x_msg_data,

Line 170: p_commit => FND_API.G_FALSE,

166: OKC_ARTICLES_GRP.create_article(
167: p_api_version => 1,
168: p_init_msg_list => FND_API.G_FALSE,
169: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
170: p_commit => FND_API.G_FALSE,
171: x_return_status => x_return_status,
172: x_msg_count => x_msg_count,
173: x_msg_data => x_msg_data,
174: p_article_title => p_article_title,

Line 217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

213: );
214:
215: --------------------------------------------
216: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
218: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
219: RAISE FND_API.G_EXC_ERROR ;
220: END IF;
221: --------------------------------------------

Line 219: RAISE FND_API.G_EXC_ERROR ;

215: --------------------------------------------
216: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
218: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
219: RAISE FND_API.G_EXC_ERROR ;
220: END IF;
221: --------------------------------------------
222:
223:

Line 246: p_init_msg_list => FND_API.G_FALSE,

242: END IF;
243:
244: OKC_K_ARTICLES_GRP.update_article(
245: p_api_version =>1,
246: p_init_msg_list => FND_API.G_FALSE,
247: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
248: p_validate_commit => FND_API.G_FALSE,
249: p_validation_string => NULL,
250: p_commit => FND_API.G_FALSE,

Line 247: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

243:
244: OKC_K_ARTICLES_GRP.update_article(
245: p_api_version =>1,
246: p_init_msg_list => FND_API.G_FALSE,
247: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
248: p_validate_commit => FND_API.G_FALSE,
249: p_validation_string => NULL,
250: p_commit => FND_API.G_FALSE,
251: p_mode => p_mode,

Line 248: p_validate_commit => FND_API.G_FALSE,

244: OKC_K_ARTICLES_GRP.update_article(
245: p_api_version =>1,
246: p_init_msg_list => FND_API.G_FALSE,
247: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
248: p_validate_commit => FND_API.G_FALSE,
249: p_validation_string => NULL,
250: p_commit => FND_API.G_FALSE,
251: p_mode => p_mode,
252: x_return_status => x_return_status,

Line 250: p_commit => FND_API.G_FALSE,

246: p_init_msg_list => FND_API.G_FALSE,
247: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
248: p_validate_commit => FND_API.G_FALSE,
249: p_validation_string => NULL,
250: p_commit => FND_API.G_FALSE,
251: p_mode => p_mode,
252: x_return_status => x_return_status,
253: x_msg_count => x_msg_count,
254: x_msg_data => x_msg_data,

Line 268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

264: p_lock_terms_yn => p_lock_terms_yn
265: );
266: --------------------------------------------
267: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
269: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
270: RAISE FND_API.G_EXC_ERROR ;
271: END IF;
272: --------------------------------------------

Line 270: RAISE FND_API.G_EXC_ERROR ;

266: --------------------------------------------
267: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
269: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
270: RAISE FND_API.G_EXC_ERROR ;
271: END IF;
272: --------------------------------------------
273:
274: x_cat_id := p_cat_id;

Line 296: p_init_msg_list => FND_API.G_FALSE,

292: END IF;
293:
294: OKC_TERMS_MULTIREC_GRP.create_article(
295: p_api_version =>1,
296: p_init_msg_list => FND_API.G_FALSE,
297: p_mode => p_mode,
298: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
299: p_validate_commit => FND_API.G_FALSE,
300: p_validation_string => NULL,

Line 298: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

294: OKC_TERMS_MULTIREC_GRP.create_article(
295: p_api_version =>1,
296: p_init_msg_list => FND_API.G_FALSE,
297: p_mode => p_mode,
298: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
299: p_validate_commit => FND_API.G_FALSE,
300: p_validation_string => NULL,
301: p_commit => FND_API.G_FALSE,
302: p_ref_type => p_ref_type,

Line 299: p_validate_commit => FND_API.G_FALSE,

295: p_api_version =>1,
296: p_init_msg_list => FND_API.G_FALSE,
297: p_mode => p_mode,
298: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
299: p_validate_commit => FND_API.G_FALSE,
300: p_validation_string => NULL,
301: p_commit => FND_API.G_FALSE,
302: p_ref_type => p_ref_type,
303: p_ref_id => p_ref_id,

Line 301: p_commit => FND_API.G_FALSE,

297: p_mode => p_mode,
298: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
299: p_validate_commit => FND_API.G_FALSE,
300: p_validation_string => NULL,
301: p_commit => FND_API.G_FALSE,
302: p_ref_type => p_ref_type,
303: p_ref_id => p_ref_id,
304: p_doc_type => p_doc_type,
305: p_doc_id => p_doc_id,

Line 315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

311: );
312:
313: --------------------------------------------
314: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
316: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
317: RAISE FND_API.G_EXC_ERROR ;
318: END IF;
319: --------------------------------------------

Line 317: RAISE FND_API.G_EXC_ERROR ;

313: --------------------------------------------
314: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
316: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
317: RAISE FND_API.G_EXC_ERROR ;
318: END IF;
319: --------------------------------------------
320:
321: x_cat_id := lx_kart_tbl(0).id;

Line 327: IF FND_API.To_Boolean( p_commit ) THEN

323: END IF;
324:
325:
326: -- Standard check of p_commit
327: IF FND_API.To_Boolean( p_commit ) THEN
328: COMMIT WORK;
329: END IF;
330:
331: -- Standard call to get message count and if count is 1, get message info.

Line 344: WHEN FND_API.G_EXC_ERROR THEN

340: G_PKG_NAME, '900: Leaving create_non_std_article' );
341: END IF;
342:
343: EXCEPTION
344: WHEN FND_API.G_EXC_ERROR THEN
345: /*IF (l_debug = 'Y') THEN
346: okc_debug.log('300: Leaving create_non_std_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
347: END IF;*/
348:

Line 362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

358: ROLLBACK TO g_create_non_std_article_GRP;
359: x_return_status := G_RET_STS_ERROR ;
360: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
361:
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363: /*IF (l_debug = 'Y') THEN
364: okc_debug.log('400: Leaving create_non_std_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
365: END IF;*/
366:

Line 471: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

467:
468: -- Standard Start of API savepoint
469: SAVEPOINT g_update_non_std_article_GRP;
470: -- Standard call to check for call compatibility.
471: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: END IF;
474: -- Initialize message list if p_init_msg_list is set to TRUE.
475: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

468: -- Standard Start of API savepoint
469: SAVEPOINT g_update_non_std_article_GRP;
470: -- Standard call to check for call compatibility.
471: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: END IF;
474: -- Initialize message list if p_init_msg_list is set to TRUE.
475: IF FND_API.to_Boolean( p_init_msg_list ) THEN
476: FND_MSG_PUB.initialize;

Line 475: IF FND_API.to_Boolean( p_init_msg_list ) THEN

471: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: END IF;
474: -- Initialize message list if p_init_msg_list is set to TRUE.
475: IF FND_API.to_Boolean( p_init_msg_list ) THEN
476: FND_MSG_PUB.initialize;
477: END IF;
478:
479: IF FND_API.To_Boolean( p_validate_commit ) THEN

Line 479: IF FND_API.To_Boolean( p_validate_commit ) THEN

475: IF FND_API.to_Boolean( p_init_msg_list ) THEN
476: FND_MSG_PUB.initialize;
477: END IF;
478:
479: IF FND_API.To_Boolean( p_validate_commit ) THEN
480:
481: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
482: p_api_version => l_api_version,
483: p_init_msg_list => FND_API.G_FALSE,

Line 481: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

477: END IF;
478:
479: IF FND_API.To_Boolean( p_validate_commit ) THEN
480:
481: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
482: p_api_version => l_api_version,
483: p_init_msg_list => FND_API.G_FALSE,
484: p_doc_type => p_doc_type,
485: p_doc_id => p_doc_id,

Line 483: p_init_msg_list => FND_API.G_FALSE,

479: IF FND_API.To_Boolean( p_validate_commit ) THEN
480:
481: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
482: p_api_version => l_api_version,
483: p_init_msg_list => FND_API.G_FALSE,
484: p_doc_type => p_doc_type,
485: p_doc_id => p_doc_id,
486: p_validation_string => p_validation_string,
487: x_return_status => x_return_status,

Line 499: RAISE FND_API.G_EXC_ERROR ;

495: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
496: FND_LOG.STRING(G_PROC_LEVEL,
497: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
498: END IF;
499: RAISE FND_API.G_EXC_ERROR ;
500: END IF;
501: END IF;
502:
503: -- Initialize API return status to success

Line 504: x_return_status := FND_API.G_RET_STS_SUCCESS;

500: END IF;
501: END IF;
502:
503: -- Initialize API return status to success
504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505:
506: /*IF (l_debug = 'Y') THEN
507: okc_debug.log('200: Updating non-std article', 2);
508: END IF;*/

Line 535: p_init_msg_list => FND_API.G_FALSE,

531: END IF;
532:
533: create_non_std_article(
534: p_api_version =>1,
535: p_init_msg_list => FND_API.G_FALSE,
536: p_validate_commit => FND_API.G_FALSE,
537: p_validation_string => NULL,
538: p_commit => FND_API.G_FALSE,
539: p_mode => p_mode,

Line 536: p_validate_commit => FND_API.G_FALSE,

532:
533: create_non_std_article(
534: p_api_version =>1,
535: p_init_msg_list => FND_API.G_FALSE,
536: p_validate_commit => FND_API.G_FALSE,
537: p_validation_string => NULL,
538: p_commit => FND_API.G_FALSE,
539: p_mode => p_mode,
540: x_return_status => x_return_status,

Line 538: p_commit => FND_API.G_FALSE,

534: p_api_version =>1,
535: p_init_msg_list => FND_API.G_FALSE,
536: p_validate_commit => FND_API.G_FALSE,
537: p_validation_string => NULL,
538: p_commit => FND_API.G_FALSE,
539: p_mode => p_mode,
540: x_return_status => x_return_status,
541: x_msg_count => x_msg_count,
542: x_msg_data => x_msg_data,

Line 566: p_init_msg_list => FND_API.G_FALSE,

562: );
563: ELSE
564: OKC_ARTICLES_GRP.update_article(
565: p_api_version => 1,
566: p_init_msg_list => FND_API.G_FALSE,
567: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
568: p_commit => FND_API.G_FALSE,
569: x_return_status => x_return_status,
570: x_msg_count => x_msg_count,

Line 567: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

563: ELSE
564: OKC_ARTICLES_GRP.update_article(
565: p_api_version => 1,
566: p_init_msg_list => FND_API.G_FALSE,
567: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
568: p_commit => FND_API.G_FALSE,
569: x_return_status => x_return_status,
570: x_msg_count => x_msg_count,
571: x_msg_data => x_msg_data,

Line 568: p_commit => FND_API.G_FALSE,

564: OKC_ARTICLES_GRP.update_article(
565: p_api_version => 1,
566: p_init_msg_list => FND_API.G_FALSE,
567: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
568: p_commit => FND_API.G_FALSE,
569: x_return_status => x_return_status,
570: x_msg_count => x_msg_count,
571: x_msg_data => x_msg_data,
572: p_article_id => l_article_id,

Line 616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

612:
613:
614: --------------------------------------------
615: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
617: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
618: RAISE FND_API.G_EXC_ERROR ;
619: END IF;
620: --------------------------------------------

Line 618: RAISE FND_API.G_EXC_ERROR ;

614: --------------------------------------------
615: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
617: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
618: RAISE FND_API.G_EXC_ERROR ;
619: END IF;
620: --------------------------------------------
621:
622:

Line 643: p_init_msg_list => FND_API.G_FALSE,

639: END IF;
640:
641: OKC_K_ARTICLES_GRP.update_article(
642: p_api_version =>1,
643: p_init_msg_list => FND_API.G_FALSE,
644: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
645: p_validate_commit => FND_API.G_FALSE,
646: p_validation_string => NULL,
647: p_commit => FND_API.G_FALSE,

Line 644: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

640:
641: OKC_K_ARTICLES_GRP.update_article(
642: p_api_version =>1,
643: p_init_msg_list => FND_API.G_FALSE,
644: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
645: p_validate_commit => FND_API.G_FALSE,
646: p_validation_string => NULL,
647: p_commit => FND_API.G_FALSE,
648: p_mode => p_mode,

Line 645: p_validate_commit => FND_API.G_FALSE,

641: OKC_K_ARTICLES_GRP.update_article(
642: p_api_version =>1,
643: p_init_msg_list => FND_API.G_FALSE,
644: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
645: p_validate_commit => FND_API.G_FALSE,
646: p_validation_string => NULL,
647: p_commit => FND_API.G_FALSE,
648: p_mode => p_mode,
649: x_return_status => x_return_status,

Line 647: p_commit => FND_API.G_FALSE,

643: p_init_msg_list => FND_API.G_FALSE,
644: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
645: p_validate_commit => FND_API.G_FALSE,
646: p_validation_string => NULL,
647: p_commit => FND_API.G_FALSE,
648: p_mode => p_mode,
649: x_return_status => x_return_status,
650: x_msg_count => x_msg_count,
651: x_msg_data => x_msg_data,

Line 662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

658: p_lock_terms_yn => p_lock_terms_yn
659: );
660: --------------------------------------------
661: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
663: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
664: RAISE FND_API.G_EXC_ERROR ;
665: END IF;
666: --------------------------------------------

Line 664: RAISE FND_API.G_EXC_ERROR ;

660: --------------------------------------------
661: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
663: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
664: RAISE FND_API.G_EXC_ERROR ;
665: END IF;
666: --------------------------------------------
667: END IF; -- IF change_nonstd_yn='Y' THEN
668:

Line 670: IF FND_API.To_Boolean( p_commit ) THEN

666: --------------------------------------------
667: END IF; -- IF change_nonstd_yn='Y' THEN
668:
669: -- Standard check of p_commit
670: IF FND_API.To_Boolean( p_commit ) THEN
671: COMMIT WORK;
672: END IF;
673:
674: -- Standard call to get message count and if count is 1, get message info.

Line 687: WHEN FND_API.G_EXC_ERROR THEN

683: G_PKG_NAME, '900: Leavingupdate_non_std_article' );
684: END IF;
685:
686: EXCEPTION
687: WHEN FND_API.G_EXC_ERROR THEN
688: /*IF (l_debug = 'Y') THEN
689: okc_debug.log('300: Leaving update_non_std_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
690: END IF;*/
691:

Line 706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

702: ROLLBACK TO g_update_non_std_article_GRP;
703: x_return_status := G_RET_STS_ERROR ;
704: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
705:
706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
707: /*IF (l_debug = 'Y') THEN
708: okc_debug.log('400: Leavingupdate_non_std_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
709: END IF;*/
710:

Line 826: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

822:
823: -- Standard Start of API savepoint
824: SAVEPOINT g_revert_to_standard_GRP;
825: -- Standard call to check for call compatibility.
826: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
828: END IF;
829: -- Initialize message list if p_init_msg_list is set to TRUE.
830: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

823: -- Standard Start of API savepoint
824: SAVEPOINT g_revert_to_standard_GRP;
825: -- Standard call to check for call compatibility.
826: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
828: END IF;
829: -- Initialize message list if p_init_msg_list is set to TRUE.
830: IF FND_API.to_Boolean( p_init_msg_list ) THEN
831: FND_MSG_PUB.initialize;

Line 830: IF FND_API.to_Boolean( p_init_msg_list ) THEN

826: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
828: END IF;
829: -- Initialize message list if p_init_msg_list is set to TRUE.
830: IF FND_API.to_Boolean( p_init_msg_list ) THEN
831: FND_MSG_PUB.initialize;
832: END IF;
833:
834: IF FND_API.To_Boolean( p_validate_commit ) THEN

Line 834: IF FND_API.To_Boolean( p_validate_commit ) THEN

830: IF FND_API.to_Boolean( p_init_msg_list ) THEN
831: FND_MSG_PUB.initialize;
832: END IF;
833:
834: IF FND_API.To_Boolean( p_validate_commit ) THEN
835:
836: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
837: p_api_version => l_api_version,
838: p_init_msg_list => FND_API.G_FALSE,

Line 836: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

832: END IF;
833:
834: IF FND_API.To_Boolean( p_validate_commit ) THEN
835:
836: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
837: p_api_version => l_api_version,
838: p_init_msg_list => FND_API.G_FALSE,
839: p_doc_type => p_doc_type,
840: p_doc_id => p_doc_id,

Line 838: p_init_msg_list => FND_API.G_FALSE,

834: IF FND_API.To_Boolean( p_validate_commit ) THEN
835:
836: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
837: p_api_version => l_api_version,
838: p_init_msg_list => FND_API.G_FALSE,
839: p_doc_type => p_doc_type,
840: p_doc_id => p_doc_id,
841: p_validation_string => p_validation_string,
842: x_return_status => x_return_status,

Line 854: RAISE FND_API.G_EXC_ERROR ;

850: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
851: FND_LOG.STRING(G_PROC_LEVEL,
852: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
853: END IF;
854: RAISE FND_API.G_EXC_ERROR ;
855: END IF;
856: END IF;
857:
858: -- Initialize API return status to success

Line 859: x_return_status := FND_API.G_RET_STS_SUCCESS;

855: END IF;
856: END IF;
857:
858: -- Initialize API return status to success
859: x_return_status := FND_API.G_RET_STS_SUCCESS;
860:
861: /*IF (l_debug = 'Y') THEN
862: okc_debug.log('200: revert_to_standard', 2);
863: END IF;*/

Line 894: p_init_msg_list => FND_API.G_FALSE,

890:
891: /*
892: OKC_K_ARTICLES_GRP.delete_article(
893: p_api_version =>1,
894: p_init_msg_list => FND_API.G_FALSE,
895: p_validate_commit => FND_API.G_FALSE,
896: p_validation_string => NULL,
897: p_commit => FND_API.G_FALSE,
898: p_mode => p_mode, -- Other value 'AMEND'

Line 895: p_validate_commit => FND_API.G_FALSE,

891: /*
892: OKC_K_ARTICLES_GRP.delete_article(
893: p_api_version =>1,
894: p_init_msg_list => FND_API.G_FALSE,
895: p_validate_commit => FND_API.G_FALSE,
896: p_validation_string => NULL,
897: p_commit => FND_API.G_FALSE,
898: p_mode => p_mode, -- Other value 'AMEND'
899: x_return_status => x_return_status,

Line 897: p_commit => FND_API.G_FALSE,

893: p_api_version =>1,
894: p_init_msg_list => FND_API.G_FALSE,
895: p_validate_commit => FND_API.G_FALSE,
896: p_validation_string => NULL,
897: p_commit => FND_API.G_FALSE,
898: p_mode => p_mode, -- Other value 'AMEND'
899: x_return_status => x_return_status,
900: x_msg_count => x_msg_count,
901: x_msg_data => x_msg_data,

Line 916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

912: END IF;
913:
914: --------------------------------------------
915: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
917: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
918: RAISE FND_API.G_EXC_ERROR ;
919: END IF;
920: --------------------------------------------

Line 918: RAISE FND_API.G_EXC_ERROR ;

914: --------------------------------------------
915: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
917: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
918: RAISE FND_API.G_EXC_ERROR ;
919: END IF;
920: --------------------------------------------
921:
922:

Line 934: p_init_msg_list => FND_API.G_FALSE,

930: END IF;
931: /*
932: OKC_K_ARTICLES_GRP.create_article(
933: p_api_version =>1,
934: p_init_msg_list => FND_API.G_FALSE,
935: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
936: p_mode => p_mode,
937: x_return_status => x_return_status,
938: x_msg_count => x_msg_count,

Line 935: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

931: /*
932: OKC_K_ARTICLES_GRP.create_article(
933: p_api_version =>1,
934: p_init_msg_list => FND_API.G_FALSE,
935: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
936: p_mode => p_mode,
937: x_return_status => x_return_status,
938: x_msg_count => x_msg_count,
939: x_msg_data => x_msg_data,

Line 976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

972: p_lock_terms_yn => p_lock_terms_yn);
973:
974: --------------------------------------------
975: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
977: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
978: RAISE FND_API.G_EXC_ERROR ;
979: END IF;
980: --------------------------------------------

Line 978: RAISE FND_API.G_EXC_ERROR ;

974: --------------------------------------------
975: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
977: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
978: RAISE FND_API.G_EXC_ERROR ;
979: END IF;
980: --------------------------------------------
981:
982:

Line 1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

999: p_variable_code => del_var_csr.variable_code,
1000: p_object_version_number => del_var_csr.object_version_number);
1001: --------------------------------------------
1002: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1004: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1005: RAISE FND_API.G_EXC_ERROR ;
1006: END IF;
1007: --------------------------------------------

Line 1005: RAISE FND_API.G_EXC_ERROR ;

1001: --------------------------------------------
1002: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1004: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1005: RAISE FND_API.G_EXC_ERROR ;
1006: END IF;
1007: --------------------------------------------
1008: end loop;
1009:

Line 1031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1027: x_cat_id => l_x_cat_id,
1028: x_variable_code => l_x_variable_code);
1029: --------------------------------------------
1030: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1032: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1033: RAISE FND_API.G_EXC_ERROR ;
1034: END IF;
1035: --------------------------------------------

Line 1033: RAISE FND_API.G_EXC_ERROR ;

1029: --------------------------------------------
1030: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1032: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1033: RAISE FND_API.G_EXC_ERROR ;
1034: END IF;
1035: --------------------------------------------
1036:
1037:

Line 1041: IF FND_API.To_Boolean( p_commit ) THEN

1037:
1038: end loop;
1039:
1040: -- Standard check of p_commit
1041: IF FND_API.To_Boolean( p_commit ) THEN
1042: COMMIT WORK;
1043: END IF;
1044:
1045: -- Standard call to get message count and if count is 1, get message info.

Line 1058: WHEN FND_API.G_EXC_ERROR THEN

1054: G_PKG_NAME, '900: Leaving revert_to_standard' );
1055: END IF;
1056:
1057: EXCEPTION
1058: WHEN FND_API.G_EXC_ERROR THEN
1059: /*IF (l_debug = 'Y') THEN
1060: okc_debug.log('300: Leaving revert_to_standard: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1061: END IF;*/
1062:

Line 1077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1073: ROLLBACK TO g_revert_to_standard_GRP;
1074: x_return_status := G_RET_STS_ERROR ;
1075: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1076:
1077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1078: /*IF (l_debug = 'Y') THEN
1079: okc_debug.log('400: Leaving revert_to_standard: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1080: END IF;*/
1081: