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_ARTICLES_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:
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:
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 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:
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:
26: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';

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:
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:
26: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
27: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';

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:
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:
26: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
27: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
28: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';

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

120:
121: -- Standard Start of API savepoint
122: SAVEPOINT g_create_article_GRP;
123: -- Standard call to check for call compatibility.
124: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127: -- Initialize message list if p_init_msg_list is set to TRUE.
128: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

121: -- Standard Start of API savepoint
122: SAVEPOINT g_create_article_GRP;
123: -- Standard call to check for call compatibility.
124: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127: -- Initialize message list if p_init_msg_list is set to TRUE.
128: IF FND_API.to_Boolean( p_init_msg_list ) THEN
129: FND_MSG_PUB.initialize;

Line 128: IF FND_API.to_Boolean( p_init_msg_list ) THEN

124: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127: -- Initialize message list if p_init_msg_list is set to TRUE.
128: IF FND_API.to_Boolean( p_init_msg_list ) THEN
129: FND_MSG_PUB.initialize;
130: END IF;
131: -- Initialize API return status to success
132: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 132: x_return_status := FND_API.G_RET_STS_SUCCESS;

128: IF FND_API.to_Boolean( p_init_msg_list ) THEN
129: FND_MSG_PUB.initialize;
130: END IF;
131: -- Initialize API return status to success
132: x_return_status := FND_API.G_RET_STS_SUCCESS;
133:
134: IF p_mode='AMEND' THEN
135:
136: OPEN l_get_deleted_rec_csr;

Line 161: p_init_msg_list => FND_API.G_FALSE,

157:
158: IF l_del_cat_id IS NOT NULL THEN
159: OKC_K_ARTICLES_GRP.delete_article(
160: p_api_version => 1,
161: p_init_msg_list => FND_API.G_FALSE,
162: p_validate_commit => FND_API.G_FALSE,
163: p_validation_string => NULL,
164: p_commit => FND_API.G_FALSE,
165: p_mode => 'NORMAL',

Line 162: p_validate_commit => FND_API.G_FALSE,

158: IF l_del_cat_id IS NOT NULL THEN
159: OKC_K_ARTICLES_GRP.delete_article(
160: p_api_version => 1,
161: p_init_msg_list => FND_API.G_FALSE,
162: p_validate_commit => FND_API.G_FALSE,
163: p_validation_string => NULL,
164: p_commit => FND_API.G_FALSE,
165: p_mode => 'NORMAL',
166: x_return_status => x_return_status,

Line 164: p_commit => FND_API.G_FALSE,

160: p_api_version => 1,
161: p_init_msg_list => FND_API.G_FALSE,
162: p_validate_commit => FND_API.G_FALSE,
163: p_validation_string => NULL,
164: p_commit => FND_API.G_FALSE,
165: p_mode => 'NORMAL',
166: x_return_status => x_return_status,
167: x_msg_count => x_msg_count,
168: x_msg_data => x_msg_data,

Line 176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

172: p_object_version_number => NULL
173: );
174: --------------------------------------------
175: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
177: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
178: RAISE FND_API.G_EXC_ERROR ;
179: END IF;
180: --------------------------------------------

Line 178: RAISE FND_API.G_EXC_ERROR ;

174: --------------------------------------------
175: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
177: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
178: RAISE FND_API.G_EXC_ERROR ;
179: END IF;
180: --------------------------------------------
181: END IF;
182:

Line 232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

228: x_id => x_id
229: );
230: --------------------------------------------
231: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
233: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
234: RAISE FND_API.G_EXC_ERROR ;
235: END IF;
236: --------------------------------------------

Line 234: RAISE FND_API.G_EXC_ERROR ;

230: --------------------------------------------
231: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
233: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
234: RAISE FND_API.G_EXC_ERROR ;
235: END IF;
236: --------------------------------------------
237: IF p_document_type <> 'TEMPLATE' THEN
238:

Line 259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

255: x_variable_code => l_variable_code
256: );
257: --------------------------------------------
258: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
260: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
261: RAISE FND_API.G_EXC_ERROR ;
262: END IF;
263: --------------------------------------------

Line 261: RAISE FND_API.G_EXC_ERROR ;

257: --------------------------------------------
258: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
260: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
261: RAISE FND_API.G_EXC_ERROR ;
262: END IF;
263: --------------------------------------------
264: IF (l_debug = 'Y') THEN
265: okc_debug.log('130: Variables '||l_variable_code||' for cat_id '||l_cat_id||' is created',2);

Line 271: IF FND_API.To_Boolean( p_commit ) THEN

267: END LOOP;
268: END IF;
269:
270: -- Standard check of p_commit
271: IF FND_API.To_Boolean( p_commit ) THEN
272: COMMIT WORK;
273: END IF;
274: -- Standard call to get message count and if count is 1, get message info.
275: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 282: WHEN FND_API.G_EXC_ERROR THEN

278: okc_debug.log('700: Leaving create_article', 2);
279: END IF;
280:
281: EXCEPTION
282: WHEN FND_API.G_EXC_ERROR THEN
283: IF (l_debug = 'Y') THEN
284: okc_debug.log('800: Leaving create_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
285: END IF;
286:

Line 295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

291: ROLLBACK TO g_create_article_GRP;
292: x_return_status := G_RET_STS_ERROR ;
293: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
294:
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: IF (l_debug = 'Y') THEN
297: okc_debug.log('900: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
298: END IF;
299:

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

383:
384: -- Standard Start of API savepoint
385: SAVEPOINT g_validate_row_GRP;
386: -- Standard call to check for call compatibility.
387: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: END IF;
390: -- Initialize message list if p_init_msg_list is set to TRUE.
391: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

384: -- Standard Start of API savepoint
385: SAVEPOINT g_validate_row_GRP;
386: -- Standard call to check for call compatibility.
387: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: END IF;
390: -- Initialize message list if p_init_msg_list is set to TRUE.
391: IF FND_API.to_Boolean( p_init_msg_list ) THEN
392: FND_MSG_PUB.initialize;

Line 391: IF FND_API.to_Boolean( p_init_msg_list ) THEN

387: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: END IF;
390: -- Initialize message list if p_init_msg_list is set to TRUE.
391: IF FND_API.to_Boolean( p_init_msg_list ) THEN
392: FND_MSG_PUB.initialize;
393: END IF;
394: -- Initialize API return status to success
395: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 395: x_return_status := FND_API.G_RET_STS_SUCCESS;

391: IF FND_API.to_Boolean( p_init_msg_list ) THEN
392: FND_MSG_PUB.initialize;
393: END IF;
394: -- Initialize API return status to success
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396:
397: --------------------------------------------
398: -- Calling Simple API for Validation
399: --------------------------------------------

Line 444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 446: RAISE FND_API.G_EXC_ERROR ;

442: --------------------------------------------
443: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
445: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
446: RAISE FND_API.G_EXC_ERROR ;
447: END IF;
448: --------------------------------------------
449:
450: -- Standard call to get message count and if count is 1, get message info.

Line 458: WHEN FND_API.G_EXC_ERROR THEN

454: okc_debug.log('200: Leaving validate_row', 2);
455: END IF;
456:
457: EXCEPTION
458: WHEN FND_API.G_EXC_ERROR THEN
459: IF (l_debug = 'Y') THEN
460: okc_debug.log('300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
461: END IF;
462: ROLLBACK TO g_validate_row_GRP;

Line 466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

462: ROLLBACK TO g_validate_row_GRP;
463: x_return_status := G_RET_STS_ERROR ;
464: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467: IF (l_debug = 'Y') THEN
468: okc_debug.log('400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
469: END IF;
470: ROLLBACK TO g_validate_row_GRP;

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

507:
508: -- Standard Start of API savepoint
509: SAVEPOINT g_lock_row_GRP;
510: -- Standard call to check for call compatibility.
511: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514: -- Initialize message list if p_init_msg_list is set to TRUE.
515: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

508: -- Standard Start of API savepoint
509: SAVEPOINT g_lock_row_GRP;
510: -- Standard call to check for call compatibility.
511: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514: -- Initialize message list if p_init_msg_list is set to TRUE.
515: IF FND_API.to_Boolean( p_init_msg_list ) THEN
516: FND_MSG_PUB.initialize;

Line 515: IF FND_API.to_Boolean( p_init_msg_list ) THEN

511: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514: -- Initialize message list if p_init_msg_list is set to TRUE.
515: IF FND_API.to_Boolean( p_init_msg_list ) THEN
516: FND_MSG_PUB.initialize;
517: END IF;
518: -- Initialize API return status to success
519: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 519: x_return_status := FND_API.G_RET_STS_SUCCESS;

515: IF FND_API.to_Boolean( p_init_msg_list ) THEN
516: FND_MSG_PUB.initialize;
517: END IF;
518: -- Initialize API return status to success
519: x_return_status := FND_API.G_RET_STS_SUCCESS;
520:
521: --------------------------------------------
522: -- Calling Simple API for Locking A Row
523: --------------------------------------------

Line 531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

527: p_object_version_number => p_object_version_number
528: );
529: --------------------------------------------
530: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
532: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
533: RAISE FND_API.G_EXC_ERROR ;
534: END IF;
535: --------------------------------------------

Line 533: RAISE FND_API.G_EXC_ERROR ;

529: --------------------------------------------
530: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
532: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
533: RAISE FND_API.G_EXC_ERROR ;
534: END IF;
535: --------------------------------------------
536:
537: -- Standard call to get message count and if count is 1, get message info.

Line 545: WHEN FND_API.G_EXC_ERROR THEN

541: okc_debug.log('1200: Leaving lock_row', 2);
542: END IF;
543:
544: EXCEPTION
545: WHEN FND_API.G_EXC_ERROR THEN
546: IF (l_debug = 'Y') THEN
547: okc_debug.log('1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
548: END IF;
549: ROLLBACK TO g_lock_row_GRP;

Line 553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

549: ROLLBACK TO g_lock_row_GRP;
550: x_return_status := G_RET_STS_ERROR ;
551: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
552:
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: IF (l_debug = 'Y') THEN
555: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
556: END IF;
557: ROLLBACK TO g_lock_row_GRP;

Line 635: l_sync_variable VARCHAR2(1) := FND_API.G_FALSE;

631: l_cle_id NUMBER;
632: l_document_type VARCHAR2(30);
633: l_article_version_id NUMBER;
634: l_standard_yn VARCHAR2(1);
635: l_sync_variable VARCHAR2(1) := FND_API.G_FALSE;
636: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
637: l_summary_amend_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
638: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
639: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

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

716:
717: -- Standard Start of API savepoint
718: SAVEPOINT g_update_article_grp;
719: -- Standard call to check for call compatibility.
720: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723: -- Initialize message list if p_init_msg_list is set to TRUE.
724: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

717: -- Standard Start of API savepoint
718: SAVEPOINT g_update_article_grp;
719: -- Standard call to check for call compatibility.
720: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723: -- Initialize message list if p_init_msg_list is set to TRUE.
724: IF FND_API.to_Boolean( p_init_msg_list ) THEN
725: FND_MSG_PUB.initialize;

Line 724: IF FND_API.to_Boolean( p_init_msg_list ) THEN

720: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723: -- Initialize message list if p_init_msg_list is set to TRUE.
724: IF FND_API.to_Boolean( p_init_msg_list ) THEN
725: FND_MSG_PUB.initialize;
726: END IF;
727:
728: IF FND_API.To_Boolean( p_validate_commit ) THEN

Line 728: IF FND_API.To_Boolean( p_validate_commit ) THEN

724: IF FND_API.to_Boolean( p_init_msg_list ) THEN
725: FND_MSG_PUB.initialize;
726: END IF;
727:
728: IF FND_API.To_Boolean( p_validate_commit ) THEN
729:
730: IF p_document_id IS NULL OR p_document_type IS NULL THEN
731: OPEN l_document_id_csr;
732: FETCH l_document_id_csr into l_document_id,l_document_type;

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

732: FETCH l_document_id_csr into l_document_id,l_document_type;
733: CLOSE l_document_id_csr;
734: END IF;
735:
736: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
737: p_api_version => l_api_version,
738: p_init_msg_list => FND_API.G_FALSE,
739: p_doc_type => l_document_type,
740: p_doc_id => l_document_id,

Line 738: p_init_msg_list => FND_API.G_FALSE,

734: END IF;
735:
736: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
737: p_api_version => l_api_version,
738: p_init_msg_list => FND_API.G_FALSE,
739: p_doc_type => l_document_type,
740: p_doc_id => l_document_id,
741: p_validation_string => p_validation_string,
742: x_return_status => x_return_status,

Line 749: RAISE FND_API.G_EXC_ERROR ;

745:
746: IF (l_debug = 'Y') THEN
747: okc_debug.log('700: Issue with document header Record.Cannot commit', 2);
748: END IF;
749: RAISE FND_API.G_EXC_ERROR ;
750: END IF;
751: END IF;
752: -- Initialize API return status to success
753: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 753: x_return_status := FND_API.G_RET_STS_SUCCESS;

749: RAISE FND_API.G_EXC_ERROR ;
750: END IF;
751: END IF;
752: -- Initialize API return status to success
753: x_return_status := FND_API.G_RET_STS_SUCCESS;
754:
755: -- Check if this update going to update article version also.If yes then article variables will be created.
756:
757: OPEN l_art_version_csr;

Line 762: p_article_version_id <>FND_API.G_MISS_NUM AND

758: FETCH l_art_version_csr into l_article_version_id,l_standard_yn;
759: CLOSE l_art_version_csr;
760:
761: IF (p_article_version_id IS NOT NULL AND
762: p_article_version_id <>FND_API.G_MISS_NUM AND
763: l_article_version_id <> p_article_version_id ) OR l_standard_yn='N' THEN
764:
765: l_sync_variable := FND_API.G_TRUE;
766:

Line 765: l_sync_variable := FND_API.G_TRUE;

761: IF (p_article_version_id IS NOT NULL AND
762: p_article_version_id <>FND_API.G_MISS_NUM AND
763: l_article_version_id <> p_article_version_id ) OR l_standard_yn='N' THEN
764:
765: l_sync_variable := FND_API.G_TRUE;
766:
767: END IF;
768:
769: IF p_mode='AMEND' THEN

Line 833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

829: p_object_version_number => p_object_version_number
830: );
831: --------------------------------------------
832: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
834: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
835: RAISE FND_API.G_EXC_ERROR ;
836: END IF;
837: --------------------------------------------

Line 835: RAISE FND_API.G_EXC_ERROR ;

831: --------------------------------------------
832: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
834: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
835: RAISE FND_API.G_EXC_ERROR ;
836: END IF;
837: --------------------------------------------
838: IF FND_API.To_Boolean(l_sync_variable) THEN
839:

Line 838: IF FND_API.To_Boolean(l_sync_variable) THEN

834: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
835: RAISE FND_API.G_EXC_ERROR ;
836: END IF;
837: --------------------------------------------
838: IF FND_API.To_Boolean(l_sync_variable) THEN
839:
840: -- If Article is changed then
841: -- 1.Create record in okc_k_art_variables for those variables which are present in new article version but were absent in old article version.
842: -- 2.Delete record in okc_k_art_variables for those variables which are present in old article version but absent in new article version.

Line 866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

862: x_variable_code => x_variable_code
863: );
864:
865: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
867: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
868: RAISE FND_API.G_EXC_ERROR ;
869: END IF;
870: END LOOP;

Line 868: RAISE FND_API.G_EXC_ERROR ;

864:
865: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
867: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
868: RAISE FND_API.G_EXC_ERROR ;
869: END IF;
870: END LOOP;
871:
872: -- deleting old article variables

Line 886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

882: p_object_version_number => l_delete_variable_rec.object_version_number
883: );
884:
885: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
887: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
888: RAISE FND_API.G_EXC_ERROR ;
889: END IF;
890: END LOOP;

Line 888: RAISE FND_API.G_EXC_ERROR ;

884:
885: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
887: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
888: RAISE FND_API.G_EXC_ERROR ;
889: END IF;
890: END LOOP;
891:
892:

Line 913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

909: p_object_version_number => l_update_variable_rec.object_version_number
910: );
911:
912: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
914: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
915: RAISE FND_API.G_EXC_ERROR ;
916: END IF;
917: END LOOP;

Line 915: RAISE FND_API.G_EXC_ERROR ;

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

Line 922: IF FND_API.To_Boolean( p_commit ) THEN

918:
919: END IF;
920:
921: -- Standard check of p_commit
922: IF FND_API.To_Boolean( p_commit ) THEN
923: COMMIT WORK;
924: END IF;
925: -- Standard call to get message count and if count is 1, get message info.
926: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 933: WHEN FND_API.G_EXC_ERROR THEN

929: okc_debug.log('1800: Leaving update_article', 2);
930: END IF;
931:
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: IF (l_debug = 'Y') THEN
935: okc_debug.log('1900: Leaving update_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
936: END IF;
937:

Line 962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

958: ROLLBACK TO g_update_article_grp;
959: x_return_status := G_RET_STS_ERROR ;
960: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
961:
962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
963: IF (l_debug = 'Y') THEN
964: okc_debug.log('2000: Leaving update_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
965: END IF;
966:

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

1079:
1080: -- Standard Start of API savepoint
1081: SAVEPOINT g_delete_article_grp;
1082: -- Standard call to check for call compatibility.
1083: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;
1086: -- Initialize message list if p_init_msg_list is set to TRUE.
1087: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1080: -- Standard Start of API savepoint
1081: SAVEPOINT g_delete_article_grp;
1082: -- Standard call to check for call compatibility.
1083: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;
1086: -- Initialize message list if p_init_msg_list is set to TRUE.
1087: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1088: FND_MSG_PUB.initialize;

Line 1087: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1083: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;
1086: -- Initialize message list if p_init_msg_list is set to TRUE.
1087: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1088: FND_MSG_PUB.initialize;
1089: END IF;
1090:
1091: -- Initialize API return status to success

Line 1092: x_return_status := FND_API.G_RET_STS_SUCCESS;

1088: FND_MSG_PUB.initialize;
1089: END IF;
1090:
1091: -- Initialize API return status to success
1092: x_return_status := FND_API.G_RET_STS_SUCCESS;
1093:
1094:
1095: OPEN l_document_id_csr;
1096: FETCH l_document_id_csr INTO l_document_id,l_document_type,l_mandatory_yn, l_standard_yn;

Line 1104: raise FND_API.G_EXC_ERROR;

1100:
1101: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1102: p_msg_name => 'OKC_DEL_MAND_ARTICLE');
1103:
1104: raise FND_API.G_EXC_ERROR;
1105:
1106: END IF;
1107:
1108: -- if user does NOT have non-std access, don't allow delete of non-std articles

Line 1114: raise FND_API.G_EXC_ERROR;

1110: l_standard_yn ='N' THEN
1111: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1112: p_msg_name => 'OKC_DEL_NON_STD_ARTICLE');
1113:
1114: raise FND_API.G_EXC_ERROR;
1115: END IF;
1116:
1117:
1118: IF FND_API.To_Boolean( p_validate_commit ) THEN

Line 1118: IF FND_API.To_Boolean( p_validate_commit ) THEN

1114: raise FND_API.G_EXC_ERROR;
1115: END IF;
1116:
1117:
1118: IF FND_API.To_Boolean( p_validate_commit ) THEN
1119:
1120:
1121: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1122: p_api_version => l_api_version,

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

1117:
1118: IF FND_API.To_Boolean( p_validate_commit ) THEN
1119:
1120:
1121: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1122: p_api_version => l_api_version,
1123: p_init_msg_list => FND_API.G_FALSE,
1124: p_doc_type => l_document_type,
1125: p_doc_id => l_document_id,

Line 1123: p_init_msg_list => FND_API.G_FALSE,

1119:
1120:
1121: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1122: p_api_version => l_api_version,
1123: p_init_msg_list => FND_API.G_FALSE,
1124: p_doc_type => l_document_type,
1125: p_doc_id => l_document_id,
1126: p_validation_string => p_validation_string,
1127: x_return_status => x_return_status,

Line 1135: RAISE FND_API.G_EXC_ERROR ;

1131:
1132: IF (l_debug = 'Y') THEN
1133: okc_debug.log('2250: Issue with document header Record.Cannot commit', 2) ;
1134: END IF;
1135: RAISE FND_API.G_EXC_ERROR ;
1136: END IF;
1137: END IF;
1138:
1139:

Line 1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1162: p_object_version_number => NULL
1163: );
1164:
1165: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1167: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1168: RAISE FND_API.G_EXC_ERROR ;
1169: END IF;
1170: ELSE

Line 1168: RAISE FND_API.G_EXC_ERROR ;

1164:
1165: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1167: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1168: RAISE FND_API.G_EXC_ERROR ;
1169: END IF;
1170: ELSE
1171: l_delete_rec := TRUE;
1172: END IF;

Line 1187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1183: p_cat_id => p_id
1184: );
1185:
1186: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1188: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1189: RAISE FND_API.G_EXC_ERROR ;
1190: END IF;
1191:

Line 1189: RAISE FND_API.G_EXC_ERROR ;

1185:
1186: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1188: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1189: RAISE FND_API.G_EXC_ERROR ;
1190: END IF;
1191:
1192: IF (l_debug = 'Y') THEN
1193: okc_debug.log('760: Deleting Record from okc_k_articles', 2) ;

Line 1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1201: p_object_version_number => p_object_version_number
1202: );
1203: --------------------------------------------
1204: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1206: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1207: RAISE FND_API.G_EXC_ERROR ;
1208: END IF;
1209: --------------------------------------------

Line 1207: RAISE FND_API.G_EXC_ERROR ;

1203: --------------------------------------------
1204: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1206: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1207: RAISE FND_API.G_EXC_ERROR ;
1208: END IF;
1209: --------------------------------------------
1210: END IF;
1211: -- Standard check of p_commit

Line 1212: IF FND_API.To_Boolean( p_commit ) THEN

1208: END IF;
1209: --------------------------------------------
1210: END IF;
1211: -- Standard check of p_commit
1212: IF FND_API.To_Boolean( p_commit ) THEN
1213: COMMIT WORK;
1214: END IF;
1215: -- Standard call to get message count and if count is 1, get message info.
1216: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1223: WHEN FND_API.G_EXC_ERROR THEN

1219: okc_debug.log('2300: Leaving delete_article', 2);
1220: END IF;
1221:
1222: EXCEPTION
1223: WHEN FND_API.G_EXC_ERROR THEN
1224: IF (l_debug = 'Y') THEN
1225: okc_debug.log('2400: Leaving delete_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1226: END IF;
1227:

Line 1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1233: ROLLBACK TO g_delete_article_grp;
1234: x_return_status := G_RET_STS_ERROR ;
1235: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1236:
1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1238: IF (l_debug = 'Y') THEN
1239: okc_debug.log('2500: Leaving delete_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1240: END IF;
1241: