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_TERMS_MULTIREC_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_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_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_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

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

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_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
26: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

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

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_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
26: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
27: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

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

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

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

141:
142: -- Standard Start of API savepoint
143: SAVEPOINT g_create_article_GRP;
144: -- Standard call to check for call compatibility.
145: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148: -- Initialize message list if p_init_msg_list is set to TRUE.
149: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

142: -- Standard Start of API savepoint
143: SAVEPOINT g_create_article_GRP;
144: -- Standard call to check for call compatibility.
145: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148: -- Initialize message list if p_init_msg_list is set to TRUE.
149: IF FND_API.to_Boolean( p_init_msg_list ) THEN
150: FND_MSG_PUB.initialize;

Line 149: IF FND_API.to_Boolean( p_init_msg_list ) THEN

145: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148: -- Initialize message list if p_init_msg_list is set to TRUE.
149: IF FND_API.to_Boolean( p_init_msg_list ) THEN
150: FND_MSG_PUB.initialize;
151: END IF;
152:
153: IF p_kart_tbl.COUNT >0

Line 154: AND FND_API.To_Boolean( p_validate_commit ) THEN

150: FND_MSG_PUB.initialize;
151: END IF;
152:
153: IF p_kart_tbl.COUNT >0
154: AND FND_API.To_Boolean( p_validate_commit ) THEN
155:
156: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
157: p_api_version => l_api_version,
158: p_init_msg_list => FND_API.G_FALSE,

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

152:
153: IF p_kart_tbl.COUNT >0
154: AND FND_API.To_Boolean( p_validate_commit ) THEN
155:
156: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
157: p_api_version => l_api_version,
158: p_init_msg_list => FND_API.G_FALSE,
159: p_doc_type => p_doc_type,
160: p_doc_id => p_doc_id,

Line 158: p_init_msg_list => FND_API.G_FALSE,

154: AND FND_API.To_Boolean( p_validate_commit ) THEN
155:
156: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
157: p_api_version => l_api_version,
158: p_init_msg_list => FND_API.G_FALSE,
159: p_doc_type => p_doc_type,
160: p_doc_id => p_doc_id,
161: p_validation_string => p_validation_string,
162: x_return_status => x_return_status,

Line 174: RAISE FND_API.G_EXC_ERROR ;

170: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
171: FND_LOG.STRING(G_PROC_LEVEL,
172: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
173: END IF;
174: RAISE FND_API.G_EXC_ERROR ;
175: END IF;
176: END IF;
177:
178: -- Initialize API return status to success

Line 179: x_return_status := FND_API.G_RET_STS_SUCCESS;

175: END IF;
176: END IF;
177:
178: -- Initialize API return status to success
179: x_return_status := FND_API.G_RET_STS_SUCCESS;
180:
181: IF p_kart_tbl.COUNT > 0 THEN
182:
183: IF p_ref_type='ARTICLE' THEN

Line 192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

188:
189: ELSIF p_ref_type='SECTION' THEN
190: l_scn_id := p_ref_id;
191: ELSE
192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
193:
194: END IF;
195:
196: OPEN l_get_scn_child_csr(l_scn_id);

Line 246: p_init_msg_list => FND_API.G_FALSE,

242: END IF;
243:
244: OKC_K_ARTICLES_GRP.create_article(
245: p_api_version => 1,
246: p_init_msg_list => FND_API.G_FALSE,
247: p_validation_level => 0,
248: p_mode => p_mode,
249: x_return_status => x_return_status,
250: x_msg_count => x_msg_count,

Line 268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

264: );
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: x_kart_tbl(i).id := l_id;
274: END LOOP;

Line 305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

301: p_object_version_number => Null
302: );
303: --------------------------------------------
304: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
306: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
307: RAISE FND_API.G_EXC_ERROR ;
308: END IF;
309: --------------------------------------------

Line 307: RAISE FND_API.G_EXC_ERROR ;

303: --------------------------------------------
304: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
306: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
307: RAISE FND_API.G_EXC_ERROR ;
308: END IF;
309: --------------------------------------------
310: ELSIF scn_child_tbl(k).object_type='SECTION' THEN
311:

Line 333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

329: p_object_version_number =>Null
330: );
331: --------------------------------------------
332: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
334: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
335: RAISE FND_API.G_EXC_ERROR ;
336: END IF;
337:

Line 335: RAISE FND_API.G_EXC_ERROR ;

331: --------------------------------------------
332: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
334: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
335: RAISE FND_API.G_EXC_ERROR ;
336: END IF;
337:
338: END IF; -- IF scn_child_tbl(k).object_type='ARTICLE' THEN
339: END IF;

Line 344: IF FND_API.To_Boolean( p_commit ) THEN

340: END LOOP;
341: END IF;
342:
343: -- Standard check of p_commit
344: IF FND_API.To_Boolean( p_commit ) THEN
345: COMMIT WORK;
346: END IF;
347:
348: -- Standard call to get message count and if count is 1, get message info.

Line 361: WHEN FND_API.G_EXC_ERROR THEN

357: G_PKG_NAME, '200: Leaving create_article' );
358: END IF;
359:
360: EXCEPTION
361: WHEN FND_API.G_EXC_ERROR THEN
362: /*IF (l_debug = 'Y') THEN
363: okc_debug.log('300: Leaving create_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
364: END IF;*/
365:

Line 383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

379: ROLLBACK TO g_create_article_GRP;
380: x_return_status := G_RET_STS_ERROR ;
381: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
382:
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: /*IF (l_debug = 'Y') THEN
385: okc_debug.log('400: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
386: END IF;*/
387:

Line 450: l_dummy NUMBER := FND_API.G_MISS_NUM;

446: l_api_version CONSTANT NUMBER := 1;
447: l_api_name CONSTANT VARCHAR2(30) := 'update_article_variable';
448: l_doc_type VARCHAR2(30);
449: l_doc_id NUMBER;
450: l_dummy NUMBER := FND_API.G_MISS_NUM;
451:
452: CURSOR l_doc_csr(b_cat_id NUMBER) IS
453: SELECT DOCUMENT_TYPE,DOCUMENT_ID
454: FROM OKC_K_ARTICLES_B

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

497:
498: -- Standard Start of API savepoint
499: SAVEPOINT g_update_article_variable_GRP;
500: -- Standard call to check for call compatibility.
501: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504: -- Initialize message list if p_init_msg_list is set to TRUE.
505: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

498: -- Standard Start of API savepoint
499: SAVEPOINT g_update_article_variable_GRP;
500: -- Standard call to check for call compatibility.
501: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504: -- Initialize message list if p_init_msg_list is set to TRUE.
505: IF FND_API.to_Boolean( p_init_msg_list ) THEN
506: FND_MSG_PUB.initialize;

Line 505: IF FND_API.to_Boolean( p_init_msg_list ) THEN

501: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504: -- Initialize message list if p_init_msg_list is set to TRUE.
505: IF FND_API.to_Boolean( p_init_msg_list ) THEN
506: FND_MSG_PUB.initialize;
507: END IF;
508:
509: IF p_art_var_tbl.FIRST IS NOT NULL

Line 510: AND FND_API.To_Boolean( p_validate_commit ) THEN

506: FND_MSG_PUB.initialize;
507: END IF;
508:
509: IF p_art_var_tbl.FIRST IS NOT NULL
510: AND FND_API.To_Boolean( p_validate_commit ) THEN
511:
512: OPEN l_doc_csr(p_art_var_tbl(1).cat_id);
513: FETCH l_doc_csr INTO l_doc_type,l_doc_id;
514: CLOSE l_doc_csr;

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

511:
512: OPEN l_doc_csr(p_art_var_tbl(1).cat_id);
513: FETCH l_doc_csr INTO l_doc_type,l_doc_id;
514: CLOSE l_doc_csr;
515: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
516: p_api_version => l_api_version,
517: p_init_msg_list => FND_API.G_FALSE,
518: p_doc_type => l_doc_type,
519: p_doc_id => l_doc_id,

Line 517: p_init_msg_list => FND_API.G_FALSE,

513: FETCH l_doc_csr INTO l_doc_type,l_doc_id;
514: CLOSE l_doc_csr;
515: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
516: p_api_version => l_api_version,
517: p_init_msg_list => FND_API.G_FALSE,
518: p_doc_type => l_doc_type,
519: p_doc_id => l_doc_id,
520: p_validation_string => p_validation_string,
521: x_return_status => x_return_status,

Line 533: RAISE FND_API.G_EXC_ERROR ;

529: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
530: FND_LOG.STRING(G_PROC_LEVEL,
531: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
532: END IF;
533: RAISE FND_API.G_EXC_ERROR ;
534: END IF;
535: END IF;
536:
537: -- Initialize API return status to success

Line 538: x_return_status := FND_API.G_RET_STS_SUCCESS;

534: END IF;
535: END IF;
536:
537: -- Initialize API return status to success
538: x_return_status := FND_API.G_RET_STS_SUCCESS;
539:
540: IF p_art_var_tbl.FIRST IS NOT NULL THEN
541: FOR i IN p_art_var_tbl.FIRST..p_art_var_tbl.LAST LOOP
542: /*IF (l_debug = 'Y') THEN

Line 566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

562: );
563:
564: --------------------------------------------
565: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
567: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
568: RAISE FND_API.G_EXC_ERROR ;
569: END IF;
570: --------------------------------------------

Line 568: RAISE FND_API.G_EXC_ERROR ;

564: --------------------------------------------
565: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
567: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
568: RAISE FND_API.G_EXC_ERROR ;
569: END IF;
570: --------------------------------------------
571: IF p_mode ='AMEND' THEN
572: l_dummy := FND_API.G_MISS_NUM;

Line 572: l_dummy := FND_API.G_MISS_NUM;

568: RAISE FND_API.G_EXC_ERROR ;
569: END IF;
570: --------------------------------------------
571: IF p_mode ='AMEND' THEN
572: l_dummy := FND_API.G_MISS_NUM;
573: OPEN l_amend_art_csr(p_art_var_tbl(i).cat_id);
574: FETCH l_amend_art_csr into l_dummy;
575: CLOSE l_amend_art_csr;
576: IF l_dummy <> FND_API.G_MISS_NUM THEN

Line 576: IF l_dummy <> FND_API.G_MISS_NUM THEN

572: l_dummy := FND_API.G_MISS_NUM;
573: OPEN l_amend_art_csr(p_art_var_tbl(i).cat_id);
574: FETCH l_amend_art_csr into l_dummy;
575: CLOSE l_amend_art_csr;
576: IF l_dummy <> FND_API.G_MISS_NUM THEN
577:
578: /*IF (l_debug = 'Y') THEN
579: okc_debug.log('125: Updating Amend Operation Code for cat_id '||p_art_var_tbl(i).cat_id, 2);
580: END IF;*/

Line 588: p_init_msg_list => FND_API.G_FALSE,

584: G_PKG_NAME, '125: Updating Amend Operation Code for cat_id '||p_art_var_tbl(i).cat_id );
585: END IF;
586: OKC_K_ARTICLES_GRP.Update_article(
587: p_api_version => 1,
588: p_init_msg_list => FND_API.G_FALSE,
589: p_validation_level => 0,
590: p_mode => p_mode,
591: x_msg_count => x_msg_count,
592: x_msg_data => x_msg_data,

Line 600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

596: );
597:
598: --------------------------------------------
599: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
601: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
602: RAISE FND_API.G_EXC_ERROR ;
603: END IF;
604: --------------------------------------------

Line 602: RAISE FND_API.G_EXC_ERROR ;

598: --------------------------------------------
599: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
601: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
602: RAISE FND_API.G_EXC_ERROR ;
603: END IF;
604: --------------------------------------------
605: END IF;
606: END IF;

Line 611: IF FND_API.To_Boolean( p_commit ) THEN

607: END LOOP;
608: END IF;
609:
610: -- Standard check of p_commit
611: IF FND_API.To_Boolean( p_commit ) THEN
612: COMMIT WORK;
613: END IF;
614:
615: -- Standard call to get message count and if count is 1, get message info.

Line 628: WHEN FND_API.G_EXC_ERROR THEN

624: G_PKG_NAME, '200: Leaving update_article_variable' );
625: END IF;
626:
627: EXCEPTION
628: WHEN FND_API.G_EXC_ERROR THEN
629: /*IF (l_debug = 'Y') THEN
630: okc_debug.log('300: Leaving update_article_variable: OKC_API.G_EXCEPTION_ERROR Exception', 2);
631: END IF;*/
632:

Line 646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

642: ROLLBACK TO g_update_article_variable_GRP;
643: x_return_status := G_RET_STS_ERROR ;
644: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
645:
646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
647: /*IF (l_debug = 'Y') THEN
648: okc_debug.log('400: Leaving update_article_variable: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
649: END IF;*/
650:

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

746:
747: -- Standard Start of API savepoint
748: SAVEPOINT g_update_structure_GRP;
749: -- Standard call to check for call compatibility.
750: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: END IF;
753:
754: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

747: -- Standard Start of API savepoint
748: SAVEPOINT g_update_structure_GRP;
749: -- Standard call to check for call compatibility.
750: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: END IF;
753:
754: -- Initialize message list if p_init_msg_list is set to TRUE.
755: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 755: IF FND_API.to_Boolean( p_init_msg_list ) THEN

751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: END IF;
753:
754: -- Initialize message list if p_init_msg_list is set to TRUE.
755: IF FND_API.to_Boolean( p_init_msg_list ) THEN
756: FND_MSG_PUB.initialize;
757: END IF;
758:
759: -- Initialize API return status to success

Line 760: x_return_status := FND_API.G_RET_STS_SUCCESS;

756: FND_MSG_PUB.initialize;
757: END IF;
758:
759: -- Initialize API return status to success
760: x_return_status := FND_API.G_RET_STS_SUCCESS;
761:
762: IF p_structure_tbl.FIRST IS NOT NULL
763: AND FND_API.To_Boolean( p_validate_commit ) THEN
764:

Line 763: AND FND_API.To_Boolean( p_validate_commit ) THEN

759: -- Initialize API return status to success
760: x_return_status := FND_API.G_RET_STS_SUCCESS;
761:
762: IF p_structure_tbl.FIRST IS NOT NULL
763: AND FND_API.To_Boolean( p_validate_commit ) THEN
764:
765: IF p_structure_tbl(1).type ='ARTICLE' THEN
766: OPEN l_doc_art_csr(p_structure_tbl(1).id);
767: FETCH l_doc_art_csr INTO l_doc_type,l_doc_id;

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

773: FETCH l_doc_scn_csr INTO l_doc_type,l_doc_id;
774: CLOSE l_doc_scn_csr;
775: END IF;
776:
777: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
778: p_api_version => l_api_version,
779: p_init_msg_list => FND_API.G_FALSE,
780: p_doc_type => l_doc_type,
781: p_doc_id => l_doc_id,

Line 779: p_init_msg_list => FND_API.G_FALSE,

775: END IF;
776:
777: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
778: p_api_version => l_api_version,
779: p_init_msg_list => FND_API.G_FALSE,
780: p_doc_type => l_doc_type,
781: p_doc_id => l_doc_id,
782: x_return_status => x_return_status,
783: x_msg_data => x_msg_data,

Line 794: RAISE FND_API.G_EXC_ERROR ;

790: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
791: FND_LOG.STRING(G_PROC_LEVEL,
792: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
793: END IF;
794: RAISE FND_API.G_EXC_ERROR ;
795: END IF;
796: END IF;
797:
798:

Line 807: p_init_msg_list => FND_API.G_FALSE,

803: IF p_structure_tbl(i).type = 'SECTION' THEN
804:
805: OKC_TERMS_SECTIONS_GRP.update_section(
806: p_api_version => 1,
807: p_init_msg_list => FND_API.G_FALSE,
808: x_msg_count => x_msg_count,
809: x_msg_data => x_msg_data,
810: p_validation_level => 0,
811: x_return_status => x_return_status,

Line 821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

817: );
818:
819: --------------------------------------------
820: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
822: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
823: RAISE FND_API.G_EXC_ERROR ;
824: END IF;
825: --------------------------------------------

Line 823: RAISE FND_API.G_EXC_ERROR ;

819: --------------------------------------------
820: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
822: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
823: RAISE FND_API.G_EXC_ERROR ;
824: END IF;
825: --------------------------------------------
826:
827: END IF;

Line 833: p_init_msg_list => FND_API.G_FALSE,

829: IF p_structure_tbl(i).type = 'ARTICLE' THEN
830:
831: OKC_K_ARTICLES_GRP.Update_article(
832: p_api_version => 1,
833: p_init_msg_list => FND_API.G_FALSE,
834: p_validation_level => 0,
835: x_msg_count => x_msg_count,
836: x_msg_data => x_msg_data,
837: x_return_status => x_return_status,

Line 848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

844: );
845:
846: --------------------------------------------
847: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
849: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
850: RAISE FND_API.G_EXC_ERROR ;
851: END IF;
852: --------------------------------------------

Line 850: RAISE FND_API.G_EXC_ERROR ;

846: --------------------------------------------
847: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
849: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
850: RAISE FND_API.G_EXC_ERROR ;
851: END IF;
852: --------------------------------------------
853: END IF;
854: END LOOP;

Line 858: IF FND_API.To_Boolean( p_commit ) THEN

854: END LOOP;
855:
856: END IF;
857: -- Standard check of p_commit
858: IF FND_API.To_Boolean( p_commit ) THEN
859: COMMIT WORK;
860: END IF;
861:
862: -- Standard call to get message count and if count is 1, get message info.

Line 875: WHEN FND_API.G_EXC_ERROR THEN

871: G_PKG_NAME, '200: Leaving update_structure' );
872: END IF;
873:
874: EXCEPTION
875: WHEN FND_API.G_EXC_ERROR THEN
876: /*IF (l_debug = 'Y') THEN
877: okc_debug.log('300: Leaving update_structure: OKC_API.G_EXCEPTION_ERROR Exception', 2);
878: END IF;*/
879:

Line 897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

893: ROLLBACK TO g_update_structure_GRP;
894: x_return_status := G_RET_STS_ERROR ;
895: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
896:
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: /*IF (l_debug = 'Y') THEN
899: okc_debug.log('400: Leaving update_structure: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
900: END IF;*/
901:

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

1165:
1166: -- Standard Start of API savepoint
1167: SAVEPOINT g_sync_doc_with_expert_GRP;
1168: -- Standard call to check for call compatibility.
1169: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1171: END IF;
1172: -- Initialize message list if p_init_msg_list is set to TRUE.
1173: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1166: -- Standard Start of API savepoint
1167: SAVEPOINT g_sync_doc_with_expert_GRP;
1168: -- Standard call to check for call compatibility.
1169: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1171: END IF;
1172: -- Initialize message list if p_init_msg_list is set to TRUE.
1173: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1174: FND_MSG_PUB.initialize;

Line 1173: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1169: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1171: END IF;
1172: -- Initialize message list if p_init_msg_list is set to TRUE.
1173: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1174: FND_MSG_PUB.initialize;
1175: END IF;
1176:
1177: -- Initialize API return status to success

Line 1178: x_return_status := FND_API.G_RET_STS_SUCCESS;

1174: FND_MSG_PUB.initialize;
1175: END IF;
1176:
1177: -- Initialize API return status to success
1178: x_return_status := FND_API.G_RET_STS_SUCCESS;
1179:
1180: -- Begin: Added code for bug 5406515
1181: l_current_org_id := OKC_TERMS_UTIL_PVT.get_current_org_id(p_doc_type, p_doc_id);
1182: MO_GLOBAL.set_policy_context('S',l_current_org_id);

Line 1185: IF FND_API.To_Boolean( p_validate_commit )

1181: l_current_org_id := OKC_TERMS_UTIL_PVT.get_current_org_id(p_doc_type, p_doc_id);
1182: MO_GLOBAL.set_policy_context('S',l_current_org_id);
1183: -- End: Added code for bug 5406515
1184:
1185: IF FND_API.To_Boolean( p_validate_commit )
1186: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1187: p_api_version => l_api_version,
1188: p_init_msg_list => FND_API.G_FALSE,
1189: p_doc_type => p_doc_type,

Line 1186: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

1182: MO_GLOBAL.set_policy_context('S',l_current_org_id);
1183: -- End: Added code for bug 5406515
1184:
1185: IF FND_API.To_Boolean( p_validate_commit )
1186: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1187: p_api_version => l_api_version,
1188: p_init_msg_list => FND_API.G_FALSE,
1189: p_doc_type => p_doc_type,
1190: p_doc_id => p_doc_id,

Line 1188: p_init_msg_list => FND_API.G_FALSE,

1184:
1185: IF FND_API.To_Boolean( p_validate_commit )
1186: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1187: p_api_version => l_api_version,
1188: p_init_msg_list => FND_API.G_FALSE,
1189: p_doc_type => p_doc_type,
1190: p_doc_id => p_doc_id,
1191: p_validation_string => p_validation_string,
1192: x_return_status => x_return_status,

Line 1204: RAISE FND_API.G_EXC_ERROR ;

1200: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1201: FND_LOG.STRING(G_PROC_LEVEL,
1202: G_PKG_NAME, '200: Issue with document header Record.Cannot commit' );
1203: END IF;
1204: RAISE FND_API.G_EXC_ERROR ;
1205: END IF;
1206:
1207: OPEN l_get_prov_csr;
1208: FETCH l_get_prov_csr into l_bus_doc_name, l_prov_allowed;

Line 1299: p_init_msg_list => FND_API.G_FALSE,

1295: l_renumber_flag :='Y';
1296:
1297: OKC_K_ARTICLES_GRP.delete_article(
1298: p_api_version => l_api_version,
1299: p_init_msg_list => FND_API.G_FALSE,
1300: p_validate_commit => FND_API.G_FALSE,
1301: p_validation_string => Null,
1302: p_commit => FND_API.G_FALSE,
1303: p_mode => p_mode,

Line 1300: p_validate_commit => FND_API.G_FALSE,

1296:
1297: OKC_K_ARTICLES_GRP.delete_article(
1298: p_api_version => l_api_version,
1299: p_init_msg_list => FND_API.G_FALSE,
1300: p_validate_commit => FND_API.G_FALSE,
1301: p_validation_string => Null,
1302: p_commit => FND_API.G_FALSE,
1303: p_mode => p_mode,
1304: p_id => l_article_id,

Line 1302: p_commit => FND_API.G_FALSE,

1298: p_api_version => l_api_version,
1299: p_init_msg_list => FND_API.G_FALSE,
1300: p_validate_commit => FND_API.G_FALSE,
1301: p_validation_string => Null,
1302: p_commit => FND_API.G_FALSE,
1303: p_mode => p_mode,
1304: p_id => l_article_id,
1305: p_object_version_number => l_ovn,
1306: p_mandatory_clause_delete => 'Y',

Line 1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1309: x_msg_data => x_msg_data
1310: );
1311: --------------------------------------------
1312: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1314: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1315: RAISE FND_API.G_EXC_ERROR ;
1316: END IF;
1317: --------------------------------------------

Line 1315: RAISE FND_API.G_EXC_ERROR ;

1311: --------------------------------------------
1312: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1314: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1315: RAISE FND_API.G_EXC_ERROR ;
1316: END IF;
1317: --------------------------------------------
1318:
1319: END LOOP;

Line 1344: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1340: OPEN l_get_effective_date_csr;
1341: FETCH l_get_effective_date_csr INTO l_article_effective_date;
1342:
1343: IF l_get_effective_date_csr%NOTFOUND THEN
1344: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1345: END IF;
1346: CLOSE l_get_effective_date_csr;
1347:
1348: FOR i IN l_insert_tbl.FIRST..l_insert_tbl.LAST LOOP

Line 1374: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1370: OPEN l_get_max_article_csr(l_insert_tbl(i));
1371: FETCH l_get_max_article_csr INTO l_max_article_rec;
1372:
1373: IF l_get_max_article_csr%NOTFOUND THEN
1374: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1375: END IF;
1376:
1377: l_article_rec.article_id := l_max_article_rec.article_id;
1378: l_article_rec.article_version_id := l_max_article_rec.article_version_id;

Line 1404: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1400:
1401: IF l_get_max_local_article_csr%NOTFOUND THEN
1402: CLOSE l_get_max_local_article_csr;
1403: CLOSE l_get_local_article_csr;
1404: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1405: END IF;
1406:
1407: l_article_rec.article_id := l_max_local_article_rec.article_id;
1408: l_article_rec.article_version_id := l_max_local_article_rec.article_version_id;

Line 1488: p_init_msg_list => FND_API.G_FALSE,

1484: END IF;
1485:
1486: OKC_TERMS_SECTIONS_GRP.create_section(
1487: p_api_version => l_api_version,
1488: p_init_msg_list => FND_API.G_FALSE,
1489: p_commit => FND_API.G_FALSE,
1490: x_return_status => x_return_status,
1491: x_msg_count => x_msg_count,
1492: x_msg_data => x_msg_data,

Line 1489: p_commit => FND_API.G_FALSE,

1485:
1486: OKC_TERMS_SECTIONS_GRP.create_section(
1487: p_api_version => l_api_version,
1488: p_init_msg_list => FND_API.G_FALSE,
1489: p_commit => FND_API.G_FALSE,
1490: x_return_status => x_return_status,
1491: x_msg_count => x_msg_count,
1492: x_msg_data => x_msg_data,
1493: p_id => NULL,

Line 1506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1502: x_id => l_scn_id
1503: );
1504: --------------------------------------------
1505: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1507: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1508: RAISE FND_API.G_EXC_ERROR ;
1509: END IF;
1510: --------------------------------------------

Line 1508: RAISE FND_API.G_EXC_ERROR ;

1504: --------------------------------------------
1505: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1507: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1508: RAISE FND_API.G_EXC_ERROR ;
1509: END IF;
1510: --------------------------------------------
1511: /*IF (l_debug = 'Y') THEN
1512: okc_debug.log('800: section created');

Line 1547: p_init_msg_list => FND_API.G_FALSE,

1543: --END:Bug#5160892
1544:
1545: OKC_K_ARTICLES_GRP.create_article(
1546: p_api_version => l_api_version,
1547: p_init_msg_list => FND_API.G_FALSE,
1548: p_commit => FND_API.G_FALSE,
1549: x_return_status => x_return_status,
1550: x_msg_count => x_msg_count,
1551: x_msg_data => x_msg_data,

Line 1548: p_commit => FND_API.G_FALSE,

1544:
1545: OKC_K_ARTICLES_GRP.create_article(
1546: p_api_version => l_api_version,
1547: p_init_msg_list => FND_API.G_FALSE,
1548: p_commit => FND_API.G_FALSE,
1549: x_return_status => x_return_status,
1550: x_msg_count => x_msg_count,
1551: x_msg_data => x_msg_data,
1552: p_id => NULL,

Line 1566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1562: x_id => l_art_id
1563: );
1564: --------------------------------------------
1565: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1567: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1568: RAISE FND_API.G_EXC_ERROR ;
1569: END IF;
1570: --------------------------------------------

Line 1568: RAISE FND_API.G_EXC_ERROR ;

1564: --------------------------------------------
1565: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1567: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1568: RAISE FND_API.G_EXC_ERROR ;
1569: END IF;
1570: --------------------------------------------
1571:
1572: END IF; -- l_article_rec.provision_yn='Y' and l_prov_allowed='N'

Line 1616: p_init_msg_list => FND_API.G_FALSE,

1612: END IF;
1613:
1614: OKC_NUMBER_SCHEME_GRP.apply_numbering_scheme(
1615: p_api_version => p_api_version,
1616: p_init_msg_list => FND_API.G_FALSE,
1617: x_return_status => x_return_status,
1618: x_msg_count => l_msg_count,
1619: x_msg_data => l_msg_data,
1620: p_validate_commit => p_validate_commit,

Line 1622: p_commit => FND_API.G_FALSE,

1618: x_msg_count => l_msg_count,
1619: x_msg_data => l_msg_data,
1620: p_validate_commit => p_validate_commit,
1621: p_validation_string => p_validation_string,
1622: p_commit => FND_API.G_FALSE,
1623: p_doc_type => p_doc_type,
1624: p_doc_id => p_doc_id,
1625: p_num_scheme_id => l_num_scheme_id
1626: );

Line 1654: IF FND_API.To_Boolean( p_commit ) THEN

1650: -- set the OUT parameter to indicate the number of provisional articles dropped
1651: x_articles_dropped := l_articles_dropped;
1652:
1653: -- Standard check of p_commit
1654: IF FND_API.To_Boolean( p_commit ) THEN
1655: COMMIT WORK;
1656: END IF;
1657:
1658: -- Standard call to get message count and if count is 1, get message info.

Line 1671: WHEN FND_API.G_EXC_ERROR THEN

1667: G_PKG_NAME, '200: Leaving sync_doc_with_expert' );
1668: END IF;
1669:
1670: EXCEPTION
1671: WHEN FND_API.G_EXC_ERROR THEN
1672: /*IF (l_debug = 'Y') THEN
1673: okc_debug.log('300: Leaving sync_doc_with_expert: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1674: END IF;*/
1675:

Line 1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1725: ROLLBACK TO g_sync_doc_with_expert_GRP;
1726: x_return_status := G_RET_STS_ERROR ;
1727: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1728:
1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1730: /*IF (l_debug = 'Y') THEN
1731: okc_debug.log('400: Leaving sync_doc_with_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1732: END IF;*/
1733:

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

1923: -- Standard Start of API savepoint
1924: SAVEPOINT g_refresh_articles_GRP;
1925: -- Standard call to check for call compatibility.
1926:
1927: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1929: END IF;
1930: -- Initialize message list if p_init_msg_list is set to TRUE.
1931: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1924: SAVEPOINT g_refresh_articles_GRP;
1925: -- Standard call to check for call compatibility.
1926:
1927: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1929: END IF;
1930: -- Initialize message list if p_init_msg_list is set to TRUE.
1931: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1932: FND_MSG_PUB.initialize;

Line 1931: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1927: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1929: END IF;
1930: -- Initialize message list if p_init_msg_list is set to TRUE.
1931: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1932: FND_MSG_PUB.initialize;
1933: END IF;
1934:
1935: -- Initialize API return status to success

Line 1936: x_return_status := FND_API.G_RET_STS_SUCCESS;

1932: FND_MSG_PUB.initialize;
1933: END IF;
1934:
1935: -- Initialize API return status to success
1936: x_return_status := FND_API.G_RET_STS_SUCCESS;
1937:
1938: IF FND_API.To_Boolean( p_validate_commit )
1939: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1940: p_api_version => l_api_version,

Line 1938: IF FND_API.To_Boolean( p_validate_commit )

1934:
1935: -- Initialize API return status to success
1936: x_return_status := FND_API.G_RET_STS_SUCCESS;
1937:
1938: IF FND_API.To_Boolean( p_validate_commit )
1939: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1940: p_api_version => l_api_version,
1941: p_init_msg_list => FND_API.G_FALSE,
1942: p_doc_type => p_doc_type,

Line 1939: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

1935: -- Initialize API return status to success
1936: x_return_status := FND_API.G_RET_STS_SUCCESS;
1937:
1938: IF FND_API.To_Boolean( p_validate_commit )
1939: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1940: p_api_version => l_api_version,
1941: p_init_msg_list => FND_API.G_FALSE,
1942: p_doc_type => p_doc_type,
1943: p_doc_id => p_doc_id,

Line 1941: p_init_msg_list => FND_API.G_FALSE,

1937:
1938: IF FND_API.To_Boolean( p_validate_commit )
1939: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1940: p_api_version => l_api_version,
1941: p_init_msg_list => FND_API.G_FALSE,
1942: p_doc_type => p_doc_type,
1943: p_doc_id => p_doc_id,
1944: p_validation_string => p_validation_string,
1945: x_return_status => x_return_status,

Line 1957: RAISE FND_API.G_EXC_ERROR ;

1953: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1954: FND_LOG.STRING(G_PROC_LEVEL,
1955: G_PKG_NAME, '200: Issue with document header Record.Cannot commit' );
1956: END IF;
1957: RAISE FND_API.G_EXC_ERROR ;
1958: END IF;
1959:
1960: FOR i IN p_article_tbl.FIRST..p_article_tbl.LAST LOOP
1961:

Line 1982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1978: p_object_version_number => p_article_tbl(i).ovn
1979: );
1980: --------------------------------------------
1981: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1983: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1984: RAISE FND_API.G_EXC_ERROR ;
1985: END IF;
1986: --------------------------------------------

Line 1984: RAISE FND_API.G_EXC_ERROR ;

1980: --------------------------------------------
1981: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1983: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1984: RAISE FND_API.G_EXC_ERROR ;
1985: END IF;
1986: --------------------------------------------
1987: END IF;
1988:

Line 1992: IF FND_API.To_Boolean( p_commit ) THEN

1988:
1989: END LOOP;
1990:
1991: -- Standard check of p_commit
1992: IF FND_API.To_Boolean( p_commit ) THEN
1993: COMMIT WORK;
1994: END IF;
1995:
1996: -- Standard call to get message count and if count is 1, get message info.

Line 2009: WHEN FND_API.G_EXC_ERROR THEN

2005: G_PKG_NAME, '200: Leaving refresh_articles' );
2006: END IF;
2007:
2008: EXCEPTION
2009: WHEN FND_API.G_EXC_ERROR THEN
2010: /*IF (l_debug = 'Y') THEN
2011: okc_debug.log('300: Leaving refresh_articles: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2012: END IF;*/
2013:

Line 2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2023: ROLLBACK TO g_refresh_articles_GRP;
2024: x_return_status := G_RET_STS_ERROR ;
2025: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2026:
2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2028: /*IF (l_debug = 'Y') THEN
2029: okc_debug.log('400: Leaving refresh_articles: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2030: END IF;*/
2031:

Line 2081: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2077:
2078: PROCEDURE organize_layout(
2079: p_api_version IN NUMBER,
2080: p_init_msg_list IN VARCHAR2 ,
2081: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2082: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
2083: p_validation_string IN VARCHAR2,
2084: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2085: p_organize_tbl IN ORGANIZE_TBL_TYPE,

Line 2082: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,

2078: PROCEDURE organize_layout(
2079: p_api_version IN NUMBER,
2080: p_init_msg_list IN VARCHAR2 ,
2081: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2082: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
2083: p_validation_string IN VARCHAR2,
2084: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2085: p_organize_tbl IN ORGANIZE_TBL_TYPE,
2086: p_ref_point IN VARCHAR2 := 'A', -- Possible values

Line 2084: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2080: p_init_msg_list IN VARCHAR2 ,
2081: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2082: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
2083: p_validation_string IN VARCHAR2,
2084: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2085: p_organize_tbl IN ORGANIZE_TBL_TYPE,
2086: p_ref_point IN VARCHAR2 := 'A', -- Possible values
2087: -- 'A'=After,'B'=Before,'S' = Subsection
2088: p_doc_type IN VARCHAR2,

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

2208: -- Standard Start of API savepoint
2209: SAVEPOINT g_organize_layout_GRP;
2210: -- Standard call to check for call compatibility.
2211:
2212: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2214: END IF;
2215: -- Initialize message list if p_init_msg_list is set to TRUE.
2216: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2209: SAVEPOINT g_organize_layout_GRP;
2210: -- Standard call to check for call compatibility.
2211:
2212: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2214: END IF;
2215: -- Initialize message list if p_init_msg_list is set to TRUE.
2216: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2217: FND_MSG_PUB.initialize;

Line 2216: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2212: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2214: END IF;
2215: -- Initialize message list if p_init_msg_list is set to TRUE.
2216: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2217: FND_MSG_PUB.initialize;
2218: END IF;
2219:
2220: -- Initialize API return status to success

Line 2221: x_return_status := FND_API.G_RET_STS_SUCCESS;

2217: FND_MSG_PUB.initialize;
2218: END IF;
2219:
2220: -- Initialize API return status to success
2221: x_return_status := FND_API.G_RET_STS_SUCCESS;
2222:
2223: IF FND_API.To_Boolean( p_validate_commit )
2224: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
2225: p_api_version => l_api_version,

Line 2223: IF FND_API.To_Boolean( p_validate_commit )

2219:
2220: -- Initialize API return status to success
2221: x_return_status := FND_API.G_RET_STS_SUCCESS;
2222:
2223: IF FND_API.To_Boolean( p_validate_commit )
2224: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
2225: p_api_version => l_api_version,
2226: p_init_msg_list => FND_API.G_FALSE,
2227: p_doc_type => p_doc_type,

Line 2224: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

2220: -- Initialize API return status to success
2221: x_return_status := FND_API.G_RET_STS_SUCCESS;
2222:
2223: IF FND_API.To_Boolean( p_validate_commit )
2224: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
2225: p_api_version => l_api_version,
2226: p_init_msg_list => FND_API.G_FALSE,
2227: p_doc_type => p_doc_type,
2228: p_doc_id => p_doc_id,

Line 2226: p_init_msg_list => FND_API.G_FALSE,

2222:
2223: IF FND_API.To_Boolean( p_validate_commit )
2224: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
2225: p_api_version => l_api_version,
2226: p_init_msg_list => FND_API.G_FALSE,
2227: p_doc_type => p_doc_type,
2228: p_doc_id => p_doc_id,
2229: p_validation_string => p_validation_string,
2230: x_return_status => x_return_status,

Line 2242: RAISE FND_API.G_EXC_ERROR ;

2238: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2239: FND_LOG.STRING(G_PROC_LEVEL,
2240: G_PKG_NAME, '200: Issue with document header Record.Cannot commit' );
2241: END IF;
2242: RAISE FND_API.G_EXC_ERROR ;
2243: END IF;
2244:
2245: IF p_ref_point NOT IN ('A','B','S') THEN
2246: /*IF (l_debug = 'Y') THEN

Line 2256: RAISE FND_API.G_EXC_ERROR ;

2252: G_PKG_NAME, '800: Error: Ref point should be either A,B or S' );
2253: END IF;
2254:
2255: Okc_Api.Set_Message( G_FND_APP, 'OKC_WRONG_REF_POINT');
2256: RAISE FND_API.G_EXC_ERROR ;
2257:
2258: END IF;
2259:
2260: IF p_to_object_type = p_doc_type AND p_ref_point <>'S' THEN

Line 2274: RAISE FND_API.G_EXC_ERROR ;

2270: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2271: p_msg_name => 'OKC_WRONG_ITEM_LOCATION'
2272: );
2273:
2274: RAISE FND_API.G_EXC_ERROR ;
2275: END IF;
2276:
2277: IF p_to_object_type = 'ARTICLE' AND p_ref_point ='S' THEN
2278: /*IF (l_debug = 'Y') THEN

Line 2291: RAISE FND_API.G_EXC_ERROR ;

2287: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2288: p_msg_name => 'OKC_WRONG_ITEM_LOCATION1'
2289: );
2290:
2291: RAISE FND_API.G_EXC_ERROR ;
2292: END IF;
2293:
2294: l_organize_tbl := p_organize_tbl;
2295:

Line 2311: RAISE FND_API.G_EXC_ERROR ;

2307:
2308: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2309: p_msg_name => 'OKC_WRONG_SELECTION'
2310: );
2311: RAISE FND_API.G_EXC_ERROR ;
2312: END IF;
2313: -- Finding out those records whose parents are already in Table.
2314: -- These records will be deleted.If parents are moved there is no need to move children.
2315: IF p_organize_tbl(i).object_type='ARTICLE' THEN

Line 2365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2361: l_ref_is_set := TRUE;
2362: l_parent_scn_id := NULL;
2363:
2364: ELSE
2365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2366: END IF;
2367:
2368:
2369: IF NOT l_ref_is_set THEN

Line 2393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2389: l_ref_sequence := 0;
2390: ELSIF l_ref_count > 0 THEN
2391: l_ref_sequence := scn_child_tbl(l_ref_count).display_sequence;
2392: ELSE
2393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2394: END IF;
2395: ELSIF p_ref_point ='A' THEN
2396: IF l_ref_count > 0 THEN
2397: l_ref_sequence := scn_child_tbl(l_ref_count).display_sequence;

Line 2399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2395: ELSIF p_ref_point ='A' THEN
2396: IF l_ref_count > 0 THEN
2397: l_ref_sequence := scn_child_tbl(l_ref_count).display_sequence;
2398: ELSE
2399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2400: END IF;
2401: ELSE
2402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2403: END IF;

Line 2402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2398: ELSE
2399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2400: END IF;
2401: ELSE
2402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2403: END IF;
2404: l_ref_is_set := TRUE;
2405:
2406: ELSIF p_ref_point='S' THEN

Line 2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2420: END IF;
2421: l_ref_is_set := TRUE;
2422:
2423: ELSE
2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2425: END IF;
2426: ELSE
2427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2428: END IF;

Line 2427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2423: ELSE
2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2425: END IF;
2426: ELSE
2427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2428: END IF;
2429:
2430: END IF;
2431:

Line 2459: RAISE FND_API.G_EXC_ERROR ;

2455: IF l_parent_scn_id IS NULL THEN
2456: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2457: p_msg_name => 'OKC_ART_MOVE_TO_DOC'
2458: );
2459: RAISE FND_API.G_EXC_ERROR ;
2460: END IF;
2461: l_ref_sequence := l_ref_sequence+10;
2462:
2463: OKC_K_ARTICLES_GRP.update_article(

Line 2476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2472: p_object_version_number => Null
2473: );
2474: --------------------------------------------
2475: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2477: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2478: RAISE FND_API.G_EXC_ERROR ;
2479: END IF;
2480: --------------------------------------------

Line 2478: RAISE FND_API.G_EXC_ERROR ;

2474: --------------------------------------------
2475: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2477: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2478: RAISE FND_API.G_EXC_ERROR ;
2479: END IF;
2480: --------------------------------------------
2481: ELSIF p_organize_tbl(i).object_type='SECTION' THEN
2482:

Line 2506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2502: p_object_version_number =>Null
2503: );
2504: --------------------------------------------
2505: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2507: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2508: RAISE FND_API.G_EXC_ERROR ;
2509: END IF;
2510:

Line 2508: RAISE FND_API.G_EXC_ERROR ;

2504: --------------------------------------------
2505: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2507: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2508: RAISE FND_API.G_EXC_ERROR ;
2509: END IF;
2510:
2511: END IF; -- IF p_organize_tbl(i).object_type='ARTICLE' THEN
2512:

Line 2556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2552: p_object_version_number => Null
2553: );
2554: --------------------------------------------
2555: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2557: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2558: RAISE FND_API.G_EXC_ERROR ;
2559: END IF;
2560: --------------------------------------------

Line 2558: RAISE FND_API.G_EXC_ERROR ;

2554: --------------------------------------------
2555: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2557: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2558: RAISE FND_API.G_EXC_ERROR ;
2559: END IF;
2560: --------------------------------------------
2561: ELSIF scn_child_tbl(k).object_type='SECTION' THEN
2562:

Line 2584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2580: p_object_version_number =>Null
2581: );
2582: --------------------------------------------
2583: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2585: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2586: RAISE FND_API.G_EXC_ERROR ;
2587: END IF;
2588:

Line 2586: RAISE FND_API.G_EXC_ERROR ;

2582: --------------------------------------------
2583: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2585: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2586: RAISE FND_API.G_EXC_ERROR ;
2587: END IF;
2588:
2589: END IF; -- IF scn_child_tbl(k).object_type='ARTICLE' THEN
2590: END IF;

Line 2596: IF FND_API.To_Boolean( p_commit ) THEN

2592: END LOOP;
2593: END IF;
2594:
2595: -- Standard check of p_commit
2596: IF FND_API.To_Boolean( p_commit ) THEN
2597: COMMIT WORK;
2598: END IF;
2599:
2600: -- Standard call to get message count and if count is 1, get message info.

Line 2613: WHEN FND_API.G_EXC_ERROR THEN

2609: G_PKG_NAME, '1000: Leaving organize_layout' );
2610: END IF;
2611:
2612: EXCEPTION
2613: WHEN FND_API.G_EXC_ERROR THEN
2614: /*IF (l_debug = 'Y') THEN
2615: okc_debug.log('1100: Leaving organize_layout: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2616: END IF;*/
2617:

Line 2647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2643: ROLLBACK TO g_organize_layout_GRP;
2644: x_return_status := G_RET_STS_ERROR ;
2645: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2646:
2647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2648: /*IF (l_debug = 'Y') THEN
2649: okc_debug.log('1200: Leaving organize_layout: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2650: END IF;*/
2651:

Line 2734: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2730:
2731: PROCEDURE merge_review_clauses(
2732: p_api_version IN NUMBER,
2733: p_init_msg_list IN VARCHAR2 ,
2734: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2735: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
2736: p_validation_string IN VARCHAR2,
2737: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2738: p_merge_review_tbl IN MERGE_REVIEW_TBL_TYPE,

Line 2735: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,

2731: PROCEDURE merge_review_clauses(
2732: p_api_version IN NUMBER,
2733: p_init_msg_list IN VARCHAR2 ,
2734: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2735: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
2736: p_validation_string IN VARCHAR2,
2737: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2738: p_merge_review_tbl IN MERGE_REVIEW_TBL_TYPE,
2739: p_doc_type IN VARCHAR2,

Line 2737: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2733: p_init_msg_list IN VARCHAR2 ,
2734: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2735: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
2736: p_validation_string IN VARCHAR2,
2737: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2738: p_merge_review_tbl IN MERGE_REVIEW_TBL_TYPE,
2739: p_doc_type IN VARCHAR2,
2740: p_doc_id IN NUMBER,
2741: x_return_status OUT NOCOPY VARCHAR2,

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

2819: -- Standard Start of API savepoint
2820: SAVEPOINT g_merge_review_clauses_GRP;
2821: -- Standard call to check for call compatibility.
2822:
2823: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2825: END IF;
2826: -- Initialize message list if p_init_msg_list is set to TRUE.
2827: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2820: SAVEPOINT g_merge_review_clauses_GRP;
2821: -- Standard call to check for call compatibility.
2822:
2823: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2825: END IF;
2826: -- Initialize message list if p_init_msg_list is set to TRUE.
2827: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2828: FND_MSG_PUB.initialize;

Line 2827: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2823: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2825: END IF;
2826: -- Initialize message list if p_init_msg_list is set to TRUE.
2827: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2828: FND_MSG_PUB.initialize;
2829: END IF;
2830:
2831: -- Initialize API return status to success

Line 2832: x_return_status := FND_API.G_RET_STS_SUCCESS;

2828: FND_MSG_PUB.initialize;
2829: END IF;
2830:
2831: -- Initialize API return status to success
2832: x_return_status := FND_API.G_RET_STS_SUCCESS;
2833:
2834: IF FND_FUNCTION.TEST('OKC_TERMS_AUTHOR_STD','N') THEN
2835: l_user_access := 'STD_AUTHOR';
2836: IF FND_FUNCTION.TEST('OKC_TERMS_AUTHOR_NON_STD','N') THEN

Line 2846: IF FND_API.To_Boolean( p_validate_commit )

2842: ELSE
2843: l_user_access := 'NO_ACCESS';
2844: END IF;
2845:
2846: IF FND_API.To_Boolean( p_validate_commit )
2847: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
2848: p_api_version => l_api_version,
2849: p_init_msg_list => FND_API.G_FALSE,
2850: p_doc_type => p_doc_type,

Line 2847: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

2843: l_user_access := 'NO_ACCESS';
2844: END IF;
2845:
2846: IF FND_API.To_Boolean( p_validate_commit )
2847: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
2848: p_api_version => l_api_version,
2849: p_init_msg_list => FND_API.G_FALSE,
2850: p_doc_type => p_doc_type,
2851: p_doc_id => p_doc_id,

Line 2849: p_init_msg_list => FND_API.G_FALSE,

2845:
2846: IF FND_API.To_Boolean( p_validate_commit )
2847: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
2848: p_api_version => l_api_version,
2849: p_init_msg_list => FND_API.G_FALSE,
2850: p_doc_type => p_doc_type,
2851: p_doc_id => p_doc_id,
2852: p_validation_string => p_validation_string,
2853: x_return_status => x_return_status,

Line 2862: RAISE FND_API.G_EXC_ERROR ;

2858: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2859: FND_LOG.STRING(G_PROC_LEVEL,
2860: G_PKG_NAME, '200: Issue with document header Record.Cannot commit' );
2861: END IF;
2862: RAISE FND_API.G_EXC_ERROR ;
2863: END IF;
2864:
2865: /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
2866: Process the records to update the first clause text with the clause text

Line 2893: RAISE FND_API.G_EXC_ERROR ;

2889: END IF;
2890: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2891: p_msg_name => 'OKC_WRONG_SELECTION'
2892: );
2893: RAISE FND_API.G_EXC_ERROR ;
2894: END IF;
2895:
2896: OPEN article_properties(p_merge_review_tbl(1).review_upld_terms_id);
2897: FETCH article_properties INTO

Line 2912: RAISE FND_API.G_EXC_ERROR ;

2908: END IF;
2909: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2910: p_msg_name => 'OKC_ARTICLE_IS_IBR'
2911: );
2912: RAISE FND_API.G_EXC_ERROR ;
2913: END IF;
2914:
2915: IF l_article_text_locked = 'Y' AND (l_user_access <> 'SUPER_USER') THEN
2916:

Line 2923: RAISE FND_API.G_EXC_ERROR ;

2919: G_PKG_NAME, '500: Article is Text Locked ' );
2920: END IF;
2921: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2922: p_msg_name => 'OKC_ARTICLE_IS_LOCK_TEXT');
2923: RAISE FND_API.G_EXC_ERROR ;
2924: END IF;
2925:
2926: FOR i IN 2 ..p_merge_review_tbl.LAST LOOP
2927: l_article_ibr := 'N';

Line 2938: RAISE FND_API.G_EXC_ERROR ;

2934: G_PKG_NAME, '500: Wrong Selection ' );
2935: END IF;
2936: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2937: p_msg_name => 'OKC_WRONG_SELECTION');
2938: RAISE FND_API.G_EXC_ERROR ;
2939: END IF;
2940: OPEN article_properties(p_merge_review_tbl(i).review_upld_terms_id);
2941: FETCH article_properties into l_article_ibr, l_article_mandatory, l_article_text_locked;
2942: CLOSE article_properties;

Line 2954: RAISE FND_API.G_EXC_ERROR ;

2950: END IF;
2951: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2952: p_msg_name => 'OKC_REVIEW_MERGE_MANDATORY'
2953: );
2954: RAISE FND_API.G_EXC_ERROR ;
2955: END IF;
2956:
2957: IF p_merge_review_tbl(i).object_type='ARTICLE' THEN
2958: OPEN l_get_article_text_csr(p_merge_review_tbl(i).review_upld_terms_id);

Line 2997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2993: p_new_parent_id => G_MISS_NUM
2994: );
2995: ----------------------------------------------------------------------
2996: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2998: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2999: RAISE FND_API.G_EXC_ERROR ;
3000: END IF;
3001: ----------------------------------------------------------------------

Line 2999: RAISE FND_API.G_EXC_ERROR ;

2995: ----------------------------------------------------------------------
2996: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2998: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2999: RAISE FND_API.G_EXC_ERROR ;
3000: END IF;
3001: ----------------------------------------------------------------------
3002:
3003: -- Added for Bug 5339759

Line 3049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3045: p_error_message_count => l_final_err_msg_count,
3046: p_warning_message_count => l_final_wrn_msg_count );
3047: ----------------------------------------------------------------------
3048: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3050: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3051: RAISE FND_API.G_EXC_ERROR ;
3052: END IF;
3053: ----------------------------------------------------------------------

Line 3051: RAISE FND_API.G_EXC_ERROR ;

3047: ----------------------------------------------------------------------
3048: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3050: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3051: RAISE FND_API.G_EXC_ERROR ;
3052: END IF;
3053: ----------------------------------------------------------------------
3054:
3055:

Line 3077: IF FND_API.To_Boolean( p_commit ) THEN

3073:
3074: END IF; -- IF p_merge_review_tbl.COUNT>0
3075:
3076: -- Standard check of p_commit
3077: IF FND_API.To_Boolean( p_commit ) THEN
3078: COMMIT WORK;
3079: END IF;
3080:
3081: -- Standard call to get message count and if count is 1, get message info.

Line 3091: WHEN FND_API.G_EXC_ERROR THEN

3087: G_PKG_NAME, '1000: Leaving merge_review_clauses' );
3088: END IF;
3089:
3090: EXCEPTION
3091: WHEN FND_API.G_EXC_ERROR THEN
3092:
3093: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
3094: FND_LOG.STRING(G_EXCP_LEVEL,
3095: G_PKG_NAME, '1100: Leaving merge_review_clauses: OKC_API.G_EXCEPTION_ERROR Exception' );

Line 3108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3104: ROLLBACK TO g_merge_review_clauses_GRP;
3105: x_return_status := G_RET_STS_ERROR ;
3106: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3107:
3108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3109:
3110: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
3111: FND_LOG.STRING(G_EXCP_LEVEL,
3112: G_PKG_NAME, '1200: Leaving organize_layout: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );