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 127: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

Line 128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 131: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 135: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 164: p_init_msg_list => FND_API.G_FALSE,

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

Line 165: p_validate_commit => FND_API.G_FALSE,

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

Line 167: p_commit => FND_API.G_FALSE,

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

Line 179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 181: RAISE FND_API.G_EXC_ERROR ;

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

Line 207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

203: x_msg_data => x_msg_data);
204: END IF;
205:
206: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
208: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
209: RAISE FND_API.G_EXC_ERROR ;
210: END IF;
211:

Line 209: RAISE FND_API.G_EXC_ERROR ;

205:
206: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
208: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
209: RAISE FND_API.G_EXC_ERROR ;
210: END IF;
211:
212: END IF;
213:

Line 263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

259: p_mandatory_rwa => p_mandatory_rwa
260: );
261: --------------------------------------------
262: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
264: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
265: RAISE FND_API.G_EXC_ERROR ;
266: END IF;
267: --------------------------------------------

Line 265: RAISE FND_API.G_EXC_ERROR ;

261: --------------------------------------------
262: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
264: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
265: RAISE FND_API.G_EXC_ERROR ;
266: END IF;
267: --------------------------------------------
268: IF p_document_type <> 'TEMPLATE' THEN
269:

Line 290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

286: x_variable_code => l_variable_code
287: );
288: --------------------------------------------
289: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
291: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
292: RAISE FND_API.G_EXC_ERROR ;
293: END IF;
294: --------------------------------------------

Line 292: RAISE FND_API.G_EXC_ERROR ;

288: --------------------------------------------
289: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
291: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
292: RAISE FND_API.G_EXC_ERROR ;
293: END IF;
294: --------------------------------------------
295: IF (l_debug = 'Y') THEN
296: okc_debug.log('130: Variables '||l_variable_code||' for cat_id '||l_cat_id||' is created',2);

Line 302: IF FND_API.To_Boolean( p_commit ) THEN

298: END LOOP;
299: END IF;
300:
301: -- Standard check of p_commit
302: IF FND_API.To_Boolean( p_commit ) THEN
303: COMMIT WORK;
304: END IF;
305: -- Standard call to get message count and if count is 1, get message info.
306: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 313: WHEN FND_API.G_EXC_ERROR THEN

309: okc_debug.log('700: Leaving create_article', 2);
310: END IF;
311:
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: IF (l_debug = 'Y') THEN
315: okc_debug.log('800: Leaving create_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
316: END IF;
317:

Line 326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

322: ROLLBACK TO g_create_article_GRP;
323: x_return_status := G_RET_STS_ERROR ;
324: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
325:
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: IF (l_debug = 'Y') THEN
328: okc_debug.log('900: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
329: END IF;
330:

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

415:
416: -- Standard Start of API savepoint
417: SAVEPOINT g_validate_row_GRP;
418: -- Standard call to check for call compatibility.
419: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
422: -- Initialize message list if p_init_msg_list is set to TRUE.
423: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

416: -- Standard Start of API savepoint
417: SAVEPOINT g_validate_row_GRP;
418: -- Standard call to check for call compatibility.
419: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
422: -- Initialize message list if p_init_msg_list is set to TRUE.
423: IF FND_API.to_Boolean( p_init_msg_list ) THEN
424: FND_MSG_PUB.initialize;

Line 423: IF FND_API.to_Boolean( p_init_msg_list ) THEN

419: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
422: -- Initialize message list if p_init_msg_list is set to TRUE.
423: IF FND_API.to_Boolean( p_init_msg_list ) THEN
424: FND_MSG_PUB.initialize;
425: END IF;
426: -- Initialize API return status to success
427: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 427: x_return_status := FND_API.G_RET_STS_SUCCESS;

423: IF FND_API.to_Boolean( p_init_msg_list ) THEN
424: FND_MSG_PUB.initialize;
425: END IF;
426: -- Initialize API return status to success
427: x_return_status := FND_API.G_RET_STS_SUCCESS;
428:
429: --------------------------------------------
430: -- Calling Simple API for Validation
431: --------------------------------------------

Line 477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

473: p_mandatory_rwa => p_mandatory_rwa
474: );
475: --------------------------------------------
476: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
478: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
479: RAISE FND_API.G_EXC_ERROR ;
480: END IF;
481: --------------------------------------------

Line 479: RAISE FND_API.G_EXC_ERROR ;

475: --------------------------------------------
476: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
478: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
479: RAISE FND_API.G_EXC_ERROR ;
480: END IF;
481: --------------------------------------------
482:
483: -- Standard call to get message count and if count is 1, get message info.

Line 491: WHEN FND_API.G_EXC_ERROR THEN

487: okc_debug.log('200: Leaving validate_row', 2);
488: END IF;
489:
490: EXCEPTION
491: WHEN FND_API.G_EXC_ERROR THEN
492: IF (l_debug = 'Y') THEN
493: okc_debug.log('300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
494: END IF;
495: ROLLBACK TO g_validate_row_GRP;

Line 499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

495: ROLLBACK TO g_validate_row_GRP;
496: x_return_status := G_RET_STS_ERROR ;
497: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
498:
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: IF (l_debug = 'Y') THEN
501: okc_debug.log('400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
502: END IF;
503: ROLLBACK TO g_validate_row_GRP;

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

540:
541: -- Standard Start of API savepoint
542: SAVEPOINT g_lock_row_GRP;
543: -- Standard call to check for call compatibility.
544: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: END IF;
547: -- Initialize message list if p_init_msg_list is set to TRUE.
548: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

541: -- Standard Start of API savepoint
542: SAVEPOINT g_lock_row_GRP;
543: -- Standard call to check for call compatibility.
544: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: END IF;
547: -- Initialize message list if p_init_msg_list is set to TRUE.
548: IF FND_API.to_Boolean( p_init_msg_list ) THEN
549: FND_MSG_PUB.initialize;

Line 548: IF FND_API.to_Boolean( p_init_msg_list ) THEN

544: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: END IF;
547: -- Initialize message list if p_init_msg_list is set to TRUE.
548: IF FND_API.to_Boolean( p_init_msg_list ) THEN
549: FND_MSG_PUB.initialize;
550: END IF;
551: -- Initialize API return status to success
552: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 552: x_return_status := FND_API.G_RET_STS_SUCCESS;

548: IF FND_API.to_Boolean( p_init_msg_list ) THEN
549: FND_MSG_PUB.initialize;
550: END IF;
551: -- Initialize API return status to success
552: x_return_status := FND_API.G_RET_STS_SUCCESS;
553:
554: --------------------------------------------
555: -- Calling Simple API for Locking A Row
556: --------------------------------------------

Line 564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 566: RAISE FND_API.G_EXC_ERROR ;

562: --------------------------------------------
563: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
565: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
566: RAISE FND_API.G_EXC_ERROR ;
567: END IF;
568: --------------------------------------------
569:
570: -- Standard call to get message count and if count is 1, get message info.

Line 578: WHEN FND_API.G_EXC_ERROR THEN

574: okc_debug.log('1200: Leaving lock_row', 2);
575: END IF;
576:
577: EXCEPTION
578: WHEN FND_API.G_EXC_ERROR THEN
579: IF (l_debug = 'Y') THEN
580: okc_debug.log('1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
581: END IF;
582: ROLLBACK TO g_lock_row_GRP;

Line 586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

582: ROLLBACK TO g_lock_row_GRP;
583: x_return_status := G_RET_STS_ERROR ;
584: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
585:
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: IF (l_debug = 'Y') THEN
588: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
589: END IF;
590: ROLLBACK TO g_lock_row_GRP;

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

666: l_cle_id NUMBER;
667: l_document_type VARCHAR2(30);
668: l_article_version_id NUMBER;
669: l_standard_yn VARCHAR2(1);
670: l_sync_variable VARCHAR2(1) := FND_API.G_FALSE;
671: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
672: l_summary_amend_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
673: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
674: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

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

752:
753: -- Standard Start of API savepoint
754: SAVEPOINT g_update_article_grp;
755: -- Standard call to check for call compatibility.
756: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END IF;
759: -- Initialize message list if p_init_msg_list is set to TRUE.
760: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

753: -- Standard Start of API savepoint
754: SAVEPOINT g_update_article_grp;
755: -- Standard call to check for call compatibility.
756: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END IF;
759: -- Initialize message list if p_init_msg_list is set to TRUE.
760: IF FND_API.to_Boolean( p_init_msg_list ) THEN
761: FND_MSG_PUB.initialize;

Line 760: IF FND_API.to_Boolean( p_init_msg_list ) THEN

756: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END IF;
759: -- Initialize message list if p_init_msg_list is set to TRUE.
760: IF FND_API.to_Boolean( p_init_msg_list ) THEN
761: FND_MSG_PUB.initialize;
762: END IF;
763:
764: IF p_document_id IS NULL OR p_document_type IS NULL OR p_orig_system_reference_id1 IS NULL THEN

Line 775: IF FND_API.To_Boolean( p_validate_commit ) THEN

771: l_orig_system_reference_id1 := p_orig_system_reference_id1;
772: END IF;
773:
774:
775: IF FND_API.To_Boolean( p_validate_commit ) THEN
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,

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

773:
774:
775: IF FND_API.To_Boolean( p_validate_commit ) THEN
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_document_type,
781: p_doc_id => l_document_id,

Line 779: p_init_msg_list => FND_API.G_FALSE,

775: IF FND_API.To_Boolean( p_validate_commit ) THEN
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_document_type,
781: p_doc_id => l_document_id,
782: p_validation_string => p_validation_string,
783: x_return_status => x_return_status,

Line 790: RAISE FND_API.G_EXC_ERROR ;

786:
787: IF (l_debug = 'Y') THEN
788: okc_debug.log('700: Issue with document header Record.Cannot commit', 2);
789: END IF;
790: RAISE FND_API.G_EXC_ERROR ;
791: END IF;
792: END IF;
793: -- Initialize API return status to success
794: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 794: x_return_status := FND_API.G_RET_STS_SUCCESS;

790: RAISE FND_API.G_EXC_ERROR ;
791: END IF;
792: END IF;
793: -- Initialize API return status to success
794: x_return_status := FND_API.G_RET_STS_SUCCESS;
795:
796: -- Check if this update going to update article version also.If yes then article variables will be created.
797:
798: OPEN l_art_version_csr;

Line 803: p_article_version_id <>FND_API.G_MISS_NUM AND

799: FETCH l_art_version_csr into l_article_version_id,l_standard_yn;
800: CLOSE l_art_version_csr;
801:
802: IF (p_article_version_id IS NOT NULL AND
803: p_article_version_id <>FND_API.G_MISS_NUM AND
804: l_article_version_id <> p_article_version_id ) OR l_standard_yn='N' THEN
805:
806: l_sync_variable := FND_API.G_TRUE;
807:

Line 806: l_sync_variable := FND_API.G_TRUE;

802: IF (p_article_version_id IS NOT NULL AND
803: p_article_version_id <>FND_API.G_MISS_NUM AND
804: l_article_version_id <> p_article_version_id ) OR l_standard_yn='N' THEN
805:
806: l_sync_variable := FND_API.G_TRUE;
807:
808: END IF;
809:
810: IF p_mode='AMEND' THEN

Line 846: p_init_msg_list => FND_API.G_FALSE,

842:
843: -- Try to lock the base record. for real time concurrency:
844: lock_row(
845: p_api_version => 1,
846: p_init_msg_list => FND_API.G_FALSE,
847: x_return_status => x_return_status,
848: x_msg_count => x_msg_count,
849: x_msg_data => x_msg_data,
850: p_id => l_orig_system_reference_id1,

Line 856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

852: );
853:
854: --------------------------------------------
855: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
857: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
858: RAISE FND_API.G_EXC_ERROR ;
859: END IF;
860: --------------------------------------------

Line 858: RAISE FND_API.G_EXC_ERROR ;

854: --------------------------------------------
855: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
857: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
858: RAISE FND_API.G_EXC_ERROR ;
859: END IF;
860: --------------------------------------------
861:
862: IF (l_debug = 'Y') THEN

Line 869: p_init_msg_list => FND_API.G_FALSE ,

865:
866:
867: okc_k_entity_locks_grp.lock_entity
868: ( p_api_version => 1,
869: p_init_msg_list => FND_API.G_FALSE ,
870: p_commit => FND_API.G_FALSE,
871: p_entity_name => okc_k_entity_locks_grp.G_CLAUSE_ENTITY,
872: p_entity_pk1 => To_Char(l_orig_system_reference_id1),
873: P_LOCK_BY_ENTITY_ID => p_id,

Line 870: p_commit => FND_API.G_FALSE,

866:
867: okc_k_entity_locks_grp.lock_entity
868: ( p_api_version => 1,
869: p_init_msg_list => FND_API.G_FALSE ,
870: p_commit => FND_API.G_FALSE,
871: p_entity_name => okc_k_entity_locks_grp.G_CLAUSE_ENTITY,
872: p_entity_pk1 => To_Char(l_orig_system_reference_id1),
873: P_LOCK_BY_ENTITY_ID => p_id,
874: p_LOCK_BY_DOCUMENT_TYPE => l_document_type,

Line 882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

878: X_MSG_DATA => X_MSG_DATA
879: );
880: --------------------------------------------
881: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
883: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
884: RAISE FND_API.G_EXC_ERROR ;
885: END IF;
886: --------------------------------------------

Line 884: RAISE FND_API.G_EXC_ERROR ;

880: --------------------------------------------
881: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
883: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
884: RAISE FND_API.G_EXC_ERROR ;
885: END IF;
886: --------------------------------------------
887: END IF;
888:

Line 939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

935: p_object_version_number => p_object_version_number
936: );
937: --------------------------------------------
938: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
940: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
941: RAISE FND_API.G_EXC_ERROR ;
942: END IF;
943: --------------------------------------------

Line 941: RAISE FND_API.G_EXC_ERROR ;

937: --------------------------------------------
938: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
940: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
941: RAISE FND_API.G_EXC_ERROR ;
942: END IF;
943: --------------------------------------------
944: IF FND_API.To_Boolean(l_sync_variable) THEN
945:

Line 944: IF FND_API.To_Boolean(l_sync_variable) THEN

940: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
941: RAISE FND_API.G_EXC_ERROR ;
942: END IF;
943: --------------------------------------------
944: IF FND_API.To_Boolean(l_sync_variable) THEN
945:
946: -- If Article is changed then
947: -- 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.
948: -- 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 972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

968: x_variable_code => x_variable_code
969: );
970:
971: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
973: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
974: RAISE FND_API.G_EXC_ERROR ;
975: END IF;
976: END LOOP;

Line 974: RAISE FND_API.G_EXC_ERROR ;

970:
971: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
973: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
974: RAISE FND_API.G_EXC_ERROR ;
975: END IF;
976: END LOOP;
977:
978: -- deleting old article variables

Line 992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

988: p_object_version_number => l_delete_variable_rec.object_version_number
989: );
990:
991: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
993: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
994: RAISE FND_API.G_EXC_ERROR ;
995: END IF;
996: END LOOP;

Line 994: RAISE FND_API.G_EXC_ERROR ;

990:
991: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
993: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
994: RAISE FND_API.G_EXC_ERROR ;
995: END IF;
996: END LOOP;
997:
998:

Line 1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1015: p_object_version_number => l_update_variable_rec.object_version_number
1016: );
1017:
1018: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1020: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1021: RAISE FND_API.G_EXC_ERROR ;
1022: END IF;
1023: END LOOP;

Line 1021: RAISE FND_API.G_EXC_ERROR ;

1017:
1018: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1020: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1021: RAISE FND_API.G_EXC_ERROR ;
1022: END IF;
1023: END LOOP;
1024:
1025: END IF;

Line 1028: IF FND_API.To_Boolean( p_commit ) THEN

1024:
1025: END IF;
1026:
1027: -- Standard check of p_commit
1028: IF FND_API.To_Boolean( p_commit ) THEN
1029: COMMIT WORK;
1030: END IF;
1031: -- Standard call to get message count and if count is 1, get message info.
1032: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1039: WHEN FND_API.G_EXC_ERROR THEN

1035: okc_debug.log('1800: Leaving update_article', 2);
1036: END IF;
1037:
1038: EXCEPTION
1039: WHEN FND_API.G_EXC_ERROR THEN
1040: IF (l_debug = 'Y') THEN
1041: okc_debug.log('1900: Leaving update_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1042: END IF;
1043:

Line 1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1064: ROLLBACK TO g_update_article_grp;
1065: x_return_status := G_RET_STS_ERROR ;
1066: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1067:
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: IF (l_debug = 'Y') THEN
1070: okc_debug.log('2000: Leaving update_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1071: END IF;
1072:

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

1187:
1188: -- Standard Start of API savepoint
1189: SAVEPOINT g_delete_article_grp;
1190: -- Standard call to check for call compatibility.
1191: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1193: END IF;
1194: -- Initialize message list if p_init_msg_list is set to TRUE.
1195: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1188: -- Standard Start of API savepoint
1189: SAVEPOINT g_delete_article_grp;
1190: -- Standard call to check for call compatibility.
1191: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1193: END IF;
1194: -- Initialize message list if p_init_msg_list is set to TRUE.
1195: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1196: FND_MSG_PUB.initialize;

Line 1195: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1191: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1193: END IF;
1194: -- Initialize message list if p_init_msg_list is set to TRUE.
1195: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1196: FND_MSG_PUB.initialize;
1197: END IF;
1198:
1199: -- Initialize API return status to success

Line 1200: x_return_status := FND_API.G_RET_STS_SUCCESS;

1196: FND_MSG_PUB.initialize;
1197: END IF;
1198:
1199: -- Initialize API return status to success
1200: x_return_status := FND_API.G_RET_STS_SUCCESS;
1201:
1202:
1203: OPEN l_document_id_csr;
1204: FETCH l_document_id_csr INTO l_document_id,l_document_type,l_mandatory_yn, l_standard_yn;

Line 1212: raise FND_API.G_EXC_ERROR;

1208:
1209: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1210: p_msg_name => 'OKC_DEL_MAND_ARTICLE');
1211:
1212: raise FND_API.G_EXC_ERROR;
1213:
1214: END IF;
1215:
1216: -- if user does NOT have non-std access, don't allow delete of non-std articles

Line 1222: raise FND_API.G_EXC_ERROR;

1218: l_standard_yn ='N' THEN
1219: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1220: p_msg_name => 'OKC_DEL_NON_STD_ARTICLE');
1221:
1222: raise FND_API.G_EXC_ERROR;
1223: END IF;
1224:
1225:
1226: IF FND_API.To_Boolean( p_validate_commit ) THEN

Line 1226: IF FND_API.To_Boolean( p_validate_commit ) THEN

1222: raise FND_API.G_EXC_ERROR;
1223: END IF;
1224:
1225:
1226: IF FND_API.To_Boolean( p_validate_commit ) THEN
1227:
1228:
1229: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1230: p_api_version => l_api_version,

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

1225:
1226: IF FND_API.To_Boolean( p_validate_commit ) THEN
1227:
1228:
1229: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1230: p_api_version => l_api_version,
1231: p_init_msg_list => FND_API.G_FALSE,
1232: p_doc_type => l_document_type,
1233: p_doc_id => l_document_id,

Line 1231: p_init_msg_list => FND_API.G_FALSE,

1227:
1228:
1229: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1230: p_api_version => l_api_version,
1231: p_init_msg_list => FND_API.G_FALSE,
1232: p_doc_type => l_document_type,
1233: p_doc_id => l_document_id,
1234: p_validation_string => p_validation_string,
1235: x_return_status => x_return_status,

Line 1243: RAISE FND_API.G_EXC_ERROR ;

1239:
1240: IF (l_debug = 'Y') THEN
1241: okc_debug.log('2250: Issue with document header Record.Cannot commit', 2) ;
1242: END IF;
1243: RAISE FND_API.G_EXC_ERROR ;
1244: END IF;
1245: END IF;
1246:
1247:

Line 1278: p_init_msg_list => FND_API.G_FALSE,

1274:
1275: -- Try to lock the base record. for real time concurrency:
1276: lock_row(
1277: p_api_version => 1,
1278: p_init_msg_list => FND_API.G_FALSE,
1279: x_return_status => x_return_status,
1280: x_msg_count => x_msg_count,
1281: x_msg_data => x_msg_data,
1282: p_id => l_orig_system_reference_id1,

Line 1288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1284: );
1285:
1286: --------------------------------------------
1287: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1289: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1290: RAISE FND_API.G_EXC_ERROR ;
1291: END IF;
1292: --------------------------------------------

Line 1290: RAISE FND_API.G_EXC_ERROR ;

1286: --------------------------------------------
1287: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1289: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1290: RAISE FND_API.G_EXC_ERROR ;
1291: END IF;
1292: --------------------------------------------
1293:
1294: okc_k_entity_locks_grp.lock_entity

Line 1296: p_init_msg_list => FND_API.G_FALSE ,

1292: --------------------------------------------
1293:
1294: okc_k_entity_locks_grp.lock_entity
1295: ( p_api_version => 1,
1296: p_init_msg_list => FND_API.G_FALSE ,
1297: p_commit => FND_API.G_FALSE,
1298: p_entity_name => okc_k_entity_locks_grp.G_CLAUSE_ENTITY,
1299: p_entity_pk1 => To_Char(l_orig_system_reference_id1),
1300: P_LOCK_BY_ENTITY_ID => p_id,

Line 1297: p_commit => FND_API.G_FALSE,

1293:
1294: okc_k_entity_locks_grp.lock_entity
1295: ( p_api_version => 1,
1296: p_init_msg_list => FND_API.G_FALSE ,
1297: p_commit => FND_API.G_FALSE,
1298: p_entity_name => okc_k_entity_locks_grp.G_CLAUSE_ENTITY,
1299: p_entity_pk1 => To_Char(l_orig_system_reference_id1),
1300: P_LOCK_BY_ENTITY_ID => p_id,
1301: p_LOCK_BY_DOCUMENT_TYPE => l_document_type,

Line 1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1305: X_MSG_DATA => X_MSG_DATA
1306: );
1307: --------------------------------------------
1308: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1310: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1311: RAISE FND_API.G_EXC_ERROR ;
1312: END IF;
1313: --------------------------------------------

Line 1311: RAISE FND_API.G_EXC_ERROR ;

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

Line 1328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1324: p_object_version_number => NULL
1325: );
1326:
1327: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1329: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1330: RAISE FND_API.G_EXC_ERROR ;
1331: END IF;
1332: ELSE

Line 1330: RAISE FND_API.G_EXC_ERROR ;

1326:
1327: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1329: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1330: RAISE FND_API.G_EXC_ERROR ;
1331: END IF;
1332: ELSE
1333: l_delete_rec := TRUE;
1334: END IF;

Line 1349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1345: p_cat_id => p_id
1346: );
1347:
1348: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1350: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1351: RAISE FND_API.G_EXC_ERROR ;
1352: END IF;
1353:

Line 1351: RAISE FND_API.G_EXC_ERROR ;

1347:
1348: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1350: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1351: RAISE FND_API.G_EXC_ERROR ;
1352: END IF;
1353:
1354: IF (l_debug = 'Y') THEN
1355: okc_debug.log('760: Deleting Record from okc_k_articles', 2) ;

Line 1367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1363: p_object_version_number => p_object_version_number
1364: );
1365: --------------------------------------------
1366: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1368: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1369: RAISE FND_API.G_EXC_ERROR ;
1370: END IF;
1371: --------------------------------------------

Line 1369: RAISE FND_API.G_EXC_ERROR ;

1365: --------------------------------------------
1366: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1368: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1369: RAISE FND_API.G_EXC_ERROR ;
1370: END IF;
1371: --------------------------------------------
1372: END IF;
1373: -- Standard check of p_commit

Line 1374: IF FND_API.To_Boolean( p_commit ) THEN

1370: END IF;
1371: --------------------------------------------
1372: END IF;
1373: -- Standard check of p_commit
1374: IF FND_API.To_Boolean( p_commit ) THEN
1375: COMMIT WORK;
1376: END IF;
1377: -- Standard call to get message count and if count is 1, get message info.
1378: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1385: WHEN FND_API.G_EXC_ERROR THEN

1381: okc_debug.log('2300: Leaving delete_article', 2);
1382: END IF;
1383:
1384: EXCEPTION
1385: WHEN FND_API.G_EXC_ERROR THEN
1386: IF (l_debug = 'Y') THEN
1387: okc_debug.log('2400: Leaving delete_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1388: END IF;
1389:

Line 1399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1395: ROLLBACK TO g_delete_article_grp;
1396: x_return_status := G_RET_STS_ERROR ;
1397: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1398:
1399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1400: IF (l_debug = 'Y') THEN
1401: okc_debug.log('2500: Leaving delete_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1402: END IF;
1403: