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

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

14: ------------------------------------------------------------------------------
15: -- GLOBAL CONSTANTS
16: ------------------------------------------------------------------------------
17: g_module CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
18: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
20:
21: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

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

15: -- GLOBAL CONSTANTS
16: ------------------------------------------------------------------------------
17: g_module CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
18: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
20:
21: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
23: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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

17: g_module CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
18: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
20:
21: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
23: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
24:
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

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

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

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

19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
20:
21: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
23: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
24:
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 161: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

157: -- Standard Start of API savepoint
158: SAVEPOINT g_copy_doc_GRP;
159:
160: -- Standard call to check for call compatibility.
161: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: END IF;
164:
165: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

158: SAVEPOINT g_copy_doc_GRP;
159:
160: -- Standard call to check for call compatibility.
161: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: END IF;
164:
165: -- Initialize message list if p_init_msg_list is set to TRUE.
166: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 166: IF FND_API.to_Boolean( p_init_msg_list ) THEN

162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: END IF;
164:
165: -- Initialize message list if p_init_msg_list is set to TRUE.
166: IF FND_API.to_Boolean( p_init_msg_list ) THEN
167: FND_MSG_PUB.initialize;
168: END IF;
169:
170: -- Initialize API return status to success

Line 171: x_return_status := FND_API.G_RET_STS_SUCCESS;

167: FND_MSG_PUB.initialize;
168: END IF;
169:
170: -- Initialize API return status to success
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172:
173:
174: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
175: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: calling OKC_TERMS_COPY_PVT.copy_tc');

Line 180: p_init_msg_list => FND_API.G_FALSE,

176: END IF;
177:
178: OKC_TERMS_COPY_PVT.copy_tc(
179: p_api_version => 1,
180: p_init_msg_list => FND_API.G_FALSE,
181: p_commit => FND_API.G_FALSE,
182: p_source_doc_type => p_source_doc_type,
183: p_source_doc_id => p_source_doc_id ,
184: p_target_doc_type => p_target_doc_type,

Line 181: p_commit => FND_API.G_FALSE,

177:
178: OKC_TERMS_COPY_PVT.copy_tc(
179: p_api_version => 1,
180: p_init_msg_list => FND_API.G_FALSE,
181: p_commit => FND_API.G_FALSE,
182: p_source_doc_type => p_source_doc_type,
183: p_source_doc_id => p_source_doc_id ,
184: p_target_doc_type => p_target_doc_type,
185: p_target_doc_id => p_target_doc_id,

Line 208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

204: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished OKC_TERMS_COPY_PVT.copy_tc, return status'||x_return_status);
205: END IF;
206:
207: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
209: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
210: RAISE FND_API.G_EXC_ERROR ;
211: END IF;
212:

Line 210: RAISE FND_API.G_EXC_ERROR ;

206:
207: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
209: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
210: RAISE FND_API.G_EXC_ERROR ;
211: END IF;
212:
213: IF p_rebuild_locks = 'Y' THEN
214: /*

Line 238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

234: END IF;
235:
236:
237: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
239: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
240: RAISE FND_API.G_EXC_ERROR ;
241: END IF;
242:

Line 240: RAISE FND_API.G_EXC_ERROR ;

236:
237: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
239: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
240: RAISE FND_API.G_EXC_ERROR ;
241: END IF;
242:
243:
244: END IF;

Line 290: p_init_msg_list => FND_API.G_FALSE,

286:
287:
288: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables (
289: p_api_version => 1,
290: p_init_msg_list => FND_API.G_FALSE,
291: p_source_doc_id => p_source_doc_id,
292: p_source_doc_type => p_source_doc_type,
293: p_target_doc_id => p_target_doc_id,
294: p_target_doc_type => p_target_doc_type,

Line 319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

315: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables x_return_status : '||x_return_status);
316: END IF;
317:
318: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
320: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
321: RAISE FND_API.G_EXC_ERROR ;
322: END IF;
323:

Line 321: RAISE FND_API.G_EXC_ERROR ;

317:
318: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
320: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
321: RAISE FND_API.G_EXC_ERROR ;
322: END IF;
323:
324: END IF;
325: -------------------------------------------------------

Line 336: p_init_msg_list => FND_API.G_FALSE,

332:
333:
334: OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment (
335: p_api_version => 1,
336: p_init_msg_list => FND_API.G_FALSE,
337: p_source_doc_id => p_source_doc_id,
338: p_source_doc_type => p_source_doc_type,
339: p_target_doc_id => p_target_doc_id,
340: p_target_doc_type => p_target_doc_type,

Line 355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

351: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment x_return_status : '||x_return_status);
352: END IF;
353:
354: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
356: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
357: RAISE FND_API.G_EXC_ERROR ;
358: END IF;
359:

Line 357: RAISE FND_API.G_EXC_ERROR ;

353:
354: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
356: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
357: RAISE FND_API.G_EXC_ERROR ;
358: END IF;
359:
360: END IF;
361:

Line 369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

365: p_document_type => p_source_doc_type,
366: p_document_id => p_source_doc_id
367: );
368: IF (l_contract_source = 'E') THEN
369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
370: END IF;
371:
372: ---------------------------------------------------------
373:

Line 382: p_init_msg_list =>FND_API.G_FALSE,

378: END IF;
379:
380: OKC_CONTRACT_DOCS_GRP.Copy_Attachments (
381: p_api_version =>1,
382: p_init_msg_list =>FND_API.G_FALSE,
383: x_msg_data => x_msg_data,
384: x_msg_count => x_msg_count,
385: x_return_status => x_return_status,
386: p_from_bus_doc_type => p_source_doc_type ,

Line 401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

397: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1151:OKC_CONTRACT_DOCS_GRP.Copy_Attachments x_return_status : '||x_return_status);
398: END IF;
399:
400: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
402: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
403: RAISE FND_API.G_EXC_ERROR ;
404: END IF;
405: ELSIF (p_copy_doc_attachments ='Y' ) THEN

Line 403: RAISE FND_API.G_EXC_ERROR ;

399:
400: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
402: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
403: RAISE FND_API.G_EXC_ERROR ;
404: END IF;
405: ELSIF (p_copy_doc_attachments ='Y' ) THEN
406: /* Copy all attachments*/
407: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 413: p_init_msg_list =>FND_API.G_FALSE,

409: END IF;
410:
411: OKC_CONTRACT_DOCS_GRP.Copy_Attachments (
412: p_api_version =>1,
413: p_init_msg_list =>FND_API.G_FALSE,
414: x_msg_data => x_msg_data,
415: x_msg_count => x_msg_count,
416: x_return_status => x_return_status,
417: p_from_bus_doc_type => p_source_doc_type ,

Line 433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

429: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1158:OKC_CONTRACT_DOCS_GRP.Copy_Attachments x_return_status : '||x_return_status);
430: END IF;
431:
432: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
434: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
435: RAISE FND_API.G_EXC_ERROR ;
436: END IF;
437: END IF;

Line 435: RAISE FND_API.G_EXC_ERROR ;

431:
432: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
434: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
435: RAISE FND_API.G_EXC_ERROR ;
436: END IF;
437: END IF;
438:
439: -------------------------------------------------------------

Line 461: p_init_msg_list => FND_API.G_FALSE,

457: END IF;
458:
459: OKC_NUMBER_SCHEME_GRP.apply_numbering_scheme(
460: p_api_version => p_api_version,
461: p_init_msg_list => FND_API.G_FALSE,
462: x_return_status => x_return_status,
463: x_msg_count => x_msg_count,
464: x_msg_data => x_msg_data,
465: p_validate_commit => FND_API.G_FALSE,

Line 465: p_validate_commit => FND_API.G_FALSE,

461: p_init_msg_list => FND_API.G_FALSE,
462: x_return_status => x_return_status,
463: x_msg_count => x_msg_count,
464: x_msg_data => x_msg_data,
465: p_validate_commit => FND_API.G_FALSE,
466: p_validation_string => null,
467: p_commit => FND_API.G_FALSE,
468: p_doc_type => p_target_doc_type,
469: p_doc_id => p_target_doc_id,

Line 467: p_commit => FND_API.G_FALSE,

463: x_msg_count => x_msg_count,
464: x_msg_data => x_msg_data,
465: p_validate_commit => FND_API.G_FALSE,
466: p_validation_string => null,
467: p_commit => FND_API.G_FALSE,
468: p_doc_type => p_target_doc_type,
469: p_doc_id => p_target_doc_id,
470: p_num_scheme_id => l_num_scheme_id
471: );

Line 479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

475: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: returned from OKC_NUMBER_SCHEME_GRP.apply_numbering_scheme , return status : '||x_return_status);
476: END IF;
477:
478: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
480: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
481: RAISE FND_API.G_EXC_ERROR ;
482: END IF;
483:

Line 481: RAISE FND_API.G_EXC_ERROR ;

477:
478: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
480: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
481: RAISE FND_API.G_EXC_ERROR ;
482: END IF;
483:
484:
485: END IF; --l_num_scheme_id is not 0

Line 489: IF FND_API.To_Boolean( p_commit ) THEN

485: END IF; --l_num_scheme_id is not 0
486:
487: -- CLM changes Ends
488:
489: IF FND_API.To_Boolean( p_commit ) THEN
490: COMMIT WORK;
491: END IF;
492:
493: -- Standard call to get message count and if count is 1, get message info.

Line 502: WHEN FND_API.G_EXC_ERROR THEN

498: END IF;
499:
500: EXCEPTION
501:
502: WHEN FND_API.G_EXC_ERROR THEN
503:
504: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
505: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_doc: OKC_API.G_EXCEPTION_ERROR Exception');
506: END IF;

Line 512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

508: ROLLBACK TO g_copy_doc_grp;
509: x_return_status := G_RET_STS_ERROR ;
510: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
511:
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
514: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
515: END IF;
516:

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

622: -- Standard Start of API savepoint
623: SAVEPOINT g_copy_terms_template_GRP;
624:
625: -- Standard call to check for call compatibility.
626: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
628: END IF;
629:
630: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

623: SAVEPOINT g_copy_terms_template_GRP;
624:
625: -- Standard call to check for call compatibility.
626: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
628: END IF;
629:
630: -- Initialize message list if p_init_msg_list is set to TRUE.
631: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 631: IF FND_API.to_Boolean( p_init_msg_list ) THEN

627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
628: END IF;
629:
630: -- Initialize message list if p_init_msg_list is set to TRUE.
631: IF FND_API.to_Boolean( p_init_msg_list ) THEN
632: FND_MSG_PUB.initialize;
633: END IF;
634:
635: -- Initialize API return status to success

Line 636: x_return_status := FND_API.G_RET_STS_SUCCESS;

632: FND_MSG_PUB.initialize;
633: END IF;
634:
635: -- Initialize API return status to success
636: x_return_status := FND_API.G_RET_STS_SUCCESS;
637:
638: OPEN l_get_tmpl_csr;
639: FETCH l_get_tmpl_csr INTO l_tmpl_rec;
640: CLOSE l_get_tmpl_csr;

Line 668: RAISE FND_API.G_EXC_ERROR ;

664: IF l_check_tmpl_name_csr%FOUND THEN
665:
666: okc_Api.Set_Message(p_app_name => G_APP_NAME,
667: p_msg_name => 'OKC_SAME_TMPL_NAME');
668: RAISE FND_API.G_EXC_ERROR ;
669:
670: END IF;
671:
672: CLOSE l_check_tmpl_name_csr;

Line 735: p_init_msg_list => FND_API.G_FALSE,

731:
732:
733: OKC_TERMS_COPY_PVT.copy_tc(
734: p_api_version => 1,
735: p_init_msg_list => FND_API.G_FALSE,
736: p_commit => FND_API.G_FALSE,
737: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
738: p_source_doc_id => p_template_id,
739: p_target_doc_type => l_document_type,

Line 736: p_commit => FND_API.G_FALSE,

732:
733: OKC_TERMS_COPY_PVT.copy_tc(
734: p_api_version => 1,
735: p_init_msg_list => FND_API.G_FALSE,
736: p_commit => FND_API.G_FALSE,
737: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
738: p_source_doc_id => p_template_id,
739: p_target_doc_type => l_document_type,
740: p_target_doc_id => x_template_id,

Line 752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

748: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished OKC_TERMS_COPY_PVT.copy_tc, return status : '||x_return_status);
749: END IF;
750:
751: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
753: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
754: RAISE FND_API.G_EXC_ERROR ;
755: END IF;
756: -----------------------------------

Line 754: RAISE FND_API.G_EXC_ERROR ;

750:
751: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
753: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
754: RAISE FND_API.G_EXC_ERROR ;
755: END IF;
756: -----------------------------------
757: /* Fix for the Bug# 4113678, check whether if the deliverables exist before copying deliverables */
758:

Line 765: p_init_msg_list => FND_API.G_FALSE,

761: END IF;
762:
763: l_deliverables_exist := okc_terms_util_grp.Is_Deliverable_Exist(
764: p_api_version => 1,
765: p_init_msg_list => FND_API.G_FALSE,
766: x_return_status => x_return_status,
767: x_msg_data => x_msg_data,
768: x_msg_count => x_msg_count,
769: p_doc_type => 'TEMPLATE',

Line 793: p_init_msg_list => FND_API.G_FALSE,

789:
790:
791: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables (
792: p_api_version => 1,
793: p_init_msg_list => FND_API.G_FALSE,
794: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
795: p_source_doc_id => p_template_id,
796: p_target_doc_type => l_document_type,
797: p_target_doc_id => x_template_id,

Line 814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

810: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables x_return_status : '||x_return_status);
811: END IF;
812:
813: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
815: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
816: RAISE FND_API.G_EXC_ERROR ;
817: END IF;
818:

Line 816: RAISE FND_API.G_EXC_ERROR ;

812:
813: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
815: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
816: RAISE FND_API.G_EXC_ERROR ;
817: END IF;
818:
819: END IF;
820:

Line 825: IF FND_API.To_Boolean( p_commit ) THEN

821:
822:
823:
824: -----------------------------------
825: IF FND_API.To_Boolean( p_commit ) THEN
826: COMMIT WORK;
827: END IF;
828:
829: -- Standard call to get message count and if count is 1, get message info.

Line 838: WHEN FND_API.G_EXC_ERROR THEN

834: END IF;
835:
836: EXCEPTION
837:
838: WHEN FND_API.G_EXC_ERROR THEN
839:
840: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
841: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_terms_template: OKC_API.G_EXCEPTION_ERROR Exception');
842: END IF;

Line 856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

852: ROLLBACK TO g_copy_terms_template_grp;
853: x_return_status := G_RET_STS_ERROR ;
854: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
855:
856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
857: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
858: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_terms_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
859: END IF;
860:

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

974: -- Standard Start of API savepoint
975: SAVEPOINT g_copy_terms_GRP;
976:
977: -- Standard call to check for call compatibility.
978: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981:
982: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

975: SAVEPOINT g_copy_terms_GRP;
976:
977: -- Standard call to check for call compatibility.
978: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981:
982: -- Initialize message list if p_init_msg_list is set to TRUE.
983: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 983: IF FND_API.to_Boolean( p_init_msg_list ) THEN

979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981:
982: -- Initialize message list if p_init_msg_list is set to TRUE.
983: IF FND_API.to_Boolean( p_init_msg_list ) THEN
984: FND_MSG_PUB.initialize;
985: END IF;
986:
987: IF FND_API.To_Boolean( p_validate_commit ) AND

Line 987: IF FND_API.To_Boolean( p_validate_commit ) AND

983: IF FND_API.to_Boolean( p_init_msg_list ) THEN
984: FND_MSG_PUB.initialize;
985: END IF;
986:
987: IF FND_API.To_Boolean( p_validate_commit ) AND
988: NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
989: p_api_version => l_api_version,
990: p_init_msg_list => FND_API.G_FALSE,
991: p_doc_type => p_target_doc_type,

Line 988: NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

984: FND_MSG_PUB.initialize;
985: END IF;
986:
987: IF FND_API.To_Boolean( p_validate_commit ) AND
988: NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
989: p_api_version => l_api_version,
990: p_init_msg_list => FND_API.G_FALSE,
991: p_doc_type => p_target_doc_type,
992: p_doc_id => p_target_doc_id,

Line 990: p_init_msg_list => FND_API.G_FALSE,

986:
987: IF FND_API.To_Boolean( p_validate_commit ) AND
988: NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
989: p_api_version => l_api_version,
990: p_init_msg_list => FND_API.G_FALSE,
991: p_doc_type => p_target_doc_type,
992: p_doc_id => p_target_doc_id,
993: p_validation_string =>p_validation_string,
994: p_tmpl_change => 'Y',

Line 1002: RAISE FND_API.G_EXC_ERROR ;

998:
999: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1000: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'700: Issue with document header Record.Cannot commit');
1001: END IF;
1002: RAISE FND_API.G_EXC_ERROR ;
1003: END IF;
1004:
1005: /*Clm Changes : Donot apply multiple templates if the template is already applied on the doc. */
1006: IF (p_retain_clauses = 'Y') THEN

Line 1014: RAISE FND_API.G_EXC_ERROR ;

1010:
1011: IF l_template_exists = 'Y' THEN
1012: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1013: p_msg_name => 'OKC_SAME_TMPL_NAME');
1014: RAISE FND_API.G_EXC_ERROR ;
1015: END IF;
1016: END IF;
1017: -- end CLM Changes
1018:

Line 1020: x_return_status := FND_API.G_RET_STS_SUCCESS;

1016: END IF;
1017: -- end CLM Changes
1018:
1019: -- Initialize API return status to success
1020: x_return_status := FND_API.G_RET_STS_SUCCESS;
1021:
1022: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1023: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: calling OKC_TERMS_COPY_PVT.copy_tc');
1024: END IF;

Line 1028: p_init_msg_list => FND_API.G_FALSE,

1024: END IF;
1025:
1026: OKC_TERMS_COPY_PVT.copy_tc(
1027: p_api_version => 1,
1028: p_init_msg_list => FND_API.G_FALSE,
1029: p_commit => FND_API.G_FALSE,
1030: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
1031: p_source_doc_id => p_template_id,
1032: p_target_doc_type => l_document_type,

Line 1029: p_commit => FND_API.G_FALSE,

1025:
1026: OKC_TERMS_COPY_PVT.copy_tc(
1027: p_api_version => 1,
1028: p_init_msg_list => FND_API.G_FALSE,
1029: p_commit => FND_API.G_FALSE,
1030: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
1031: p_source_doc_id => p_template_id,
1032: p_target_doc_type => l_document_type,
1033: p_target_doc_id => l_document_id,

Line 1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1047: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: returned from OKC_TERMS_COPY_PVT.copy_tc, return status : '||x_return_status);
1048: END IF;
1049:
1050: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1052: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1053: RAISE FND_API.G_EXC_ERROR ;
1054: END IF;
1055:

Line 1053: RAISE FND_API.G_EXC_ERROR ;

1049:
1050: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1052: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1053: RAISE FND_API.G_EXC_ERROR ;
1054: END IF;
1055:
1056:
1057: ----------------------------------

Line 1080: p_init_msg_list => FND_API.G_FALSE,

1076:
1077:
1078: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables (
1079: p_api_version => 1,
1080: p_init_msg_list => FND_API.G_FALSE,
1081: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
1082: p_source_doc_id => p_template_id,
1083: p_target_doc_type => l_document_type,
1084: p_target_doc_id => l_document_id,

Line 1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1100: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables x_return_status : '||x_return_status);
1101: END IF;
1102:
1103: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1105: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1106: RAISE FND_API.G_EXC_ERROR ;
1107: END IF;
1108:

Line 1106: RAISE FND_API.G_EXC_ERROR ;

1102:
1103: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1105: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1106: RAISE FND_API.G_EXC_ERROR ;
1107: END IF;
1108:
1109: END IF; -- l_enable_deliverables = 'Y' THEN
1110:

Line 1130: p_init_msg_list => FND_API.G_FALSE,

1126: END IF;
1127:
1128: OKC_NUMBER_SCHEME_GRP.apply_numbering_scheme(
1129: p_api_version => p_api_version,
1130: p_init_msg_list => FND_API.G_FALSE,
1131: x_return_status => x_return_status,
1132: x_msg_count => x_msg_count,
1133: x_msg_data => x_msg_data,
1134: p_validate_commit => FND_API.G_FALSE,

Line 1134: p_validate_commit => FND_API.G_FALSE,

1130: p_init_msg_list => FND_API.G_FALSE,
1131: x_return_status => x_return_status,
1132: x_msg_count => x_msg_count,
1133: x_msg_data => x_msg_data,
1134: p_validate_commit => FND_API.G_FALSE,
1135: p_validation_string => p_validation_string,
1136: p_commit => FND_API.G_FALSE,
1137: p_doc_type => l_document_type,
1138: p_doc_id => l_document_id,

Line 1136: p_commit => FND_API.G_FALSE,

1132: x_msg_count => x_msg_count,
1133: x_msg_data => x_msg_data,
1134: p_validate_commit => FND_API.G_FALSE,
1135: p_validation_string => p_validation_string,
1136: p_commit => FND_API.G_FALSE,
1137: p_doc_type => l_document_type,
1138: p_doc_id => l_document_id,
1139: p_num_scheme_id => l_num_scheme_id
1140: );

Line 1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1144: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: returned from OKC_NUMBER_SCHEME_GRP.apply_numbering_scheme , return status : '||x_return_status);
1145: END IF;
1146:
1147: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1149: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1150: RAISE FND_API.G_EXC_ERROR ;
1151: END IF;
1152:

Line 1150: RAISE FND_API.G_EXC_ERROR ;

1146:
1147: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1149: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1150: RAISE FND_API.G_EXC_ERROR ;
1151: END IF;
1152:
1153:
1154: END IF; --l_num_scheme_id is not 0

Line 1162: IF FND_API.To_Boolean( p_commit ) THEN

1158: -- End Bug 3674173
1159:
1160:
1161: ------------------------------------
1162: IF FND_API.To_Boolean( p_commit ) THEN
1163: COMMIT WORK;
1164: END IF;
1165:
1166: -- Standard call to get message count and if count is 1, get message info.

Line 1177: WHEN FND_API.G_EXC_ERROR THEN

1173:
1174:
1175: EXCEPTION
1176:
1177: WHEN FND_API.G_EXC_ERROR THEN
1178:
1179: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1180: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_terms: OKC_API.G_EXCEPTION_ERROR Exception');
1181: END IF;

Line 1187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1183: ROLLBACK TO g_copy_terms_grp;
1184: x_return_status := G_RET_STS_ERROR ;
1185: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1186:
1187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1188: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1189: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1190: END IF;
1191:

Line 1216: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

1212: /* To be used to create Revision of a Template */
1213:
1214: Procedure create_template_revision (
1215: p_api_version IN Number,
1216: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
1217: p_commit IN Varchar2 default FND_API.G_FALSE,
1218: p_template_id IN Number,
1219: p_copy_deliverables IN Varchar2 default 'Y',
1220: x_template_id OUT NOCOPY Number,

Line 1217: p_commit IN Varchar2 default FND_API.G_FALSE,

1213:
1214: Procedure create_template_revision (
1215: p_api_version IN Number,
1216: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
1217: p_commit IN Varchar2 default FND_API.G_FALSE,
1218: p_template_id IN Number,
1219: p_copy_deliverables IN Varchar2 default 'Y',
1220: x_template_id OUT NOCOPY Number,
1221: x_return_status OUT NOCOPY Varchar2,

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

1249: -- Standard Start of API savepoint
1250: SAVEPOINT g_create_template_revision_GRP;
1251:
1252: -- Standard call to check for call compatibility.
1253: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1255: END IF;
1256:
1257: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1250: SAVEPOINT g_create_template_revision_GRP;
1251:
1252: -- Standard call to check for call compatibility.
1253: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1255: END IF;
1256:
1257: -- Initialize message list if p_init_msg_list is set to TRUE.
1258: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1258: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1255: END IF;
1256:
1257: -- Initialize message list if p_init_msg_list is set to TRUE.
1258: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1259: FND_MSG_PUB.initialize;
1260: END IF;
1261:
1262: -- Initialize API return status to success

Line 1263: x_return_status := FND_API.G_RET_STS_SUCCESS;

1259: FND_MSG_PUB.initialize;
1260: END IF;
1261:
1262: -- Initialize API return status to success
1263: x_return_status := FND_API.G_RET_STS_SUCCESS;
1264:
1265: OPEN l_get_tmpl_csr;
1266: FETCH l_get_tmpl_csr INTO l_tmpl_rec;
1267: CLOSE l_get_tmpl_csr;

Line 1318: p_init_msg_list => FND_API.G_FALSE,

1314: END IF;
1315:
1316: OKC_TERMS_COPY_PVT.copy_tc(
1317: p_api_version => 1,
1318: p_init_msg_list => FND_API.G_FALSE,
1319: p_commit => FND_API.G_FALSE,
1320: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
1321: p_source_doc_id => p_template_id,
1322: p_target_doc_type => l_document_type,

Line 1319: p_commit => FND_API.G_FALSE,

1315:
1316: OKC_TERMS_COPY_PVT.copy_tc(
1317: p_api_version => 1,
1318: p_init_msg_list => FND_API.G_FALSE,
1319: p_commit => FND_API.G_FALSE,
1320: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
1321: p_source_doc_id => p_template_id,
1322: p_target_doc_type => l_document_type,
1323: p_target_doc_id => x_template_id,

Line 1335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1331: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: returned from OKC_TERMS_COPY_PVT.copy_tc, return status : '||x_return_status);
1332: END IF;
1333:
1334: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1336: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1337: RAISE FND_API.G_EXC_ERROR ;
1338: END IF;
1339: ----------------------------------------------

Line 1337: RAISE FND_API.G_EXC_ERROR ;

1333:
1334: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1336: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1337: RAISE FND_API.G_EXC_ERROR ;
1338: END IF;
1339: ----------------------------------------------
1340: -- bug#4083525 do not invoke deliverables API for sell side
1341: -- to be removed when sell side deliverables are enabled.

Line 1359: p_init_msg_list => FND_API.G_FALSE,

1355: -- bug#4075168 New API for Template Revision replacing copy_deliverables
1356:
1357: OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision(
1358: p_api_version => 1,
1359: p_init_msg_list => FND_API.G_FALSE,
1360: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
1361: p_source_doc_id => p_template_id,
1362: p_target_doc_type => l_document_type,
1363: p_target_doc_id => x_template_id,

Line 1377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1373: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision x_return_status : '||x_return_status);
1374: END IF;
1375:
1376: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1378: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1379: RAISE FND_API.G_EXC_ERROR ;
1380: END IF;
1381:

Line 1379: RAISE FND_API.G_EXC_ERROR ;

1375:
1376: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1378: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1379: RAISE FND_API.G_EXC_ERROR ;
1380: END IF;
1381:
1382: END IF;-- l_copy_deliverables='Y'
1383:

Line 1385: IF FND_API.To_Boolean( p_commit ) THEN

1381:
1382: END IF;-- l_copy_deliverables='Y'
1383:
1384: -----------------------------------------------
1385: IF FND_API.To_Boolean( p_commit ) THEN
1386: COMMIT WORK;
1387: END IF;
1388:
1389: -- Standard call to get message count and if count is 1, get message info.

Line 1398: WHEN FND_API.G_EXC_ERROR THEN

1394: END IF;
1395:
1396: EXCEPTION
1397:
1398: WHEN FND_API.G_EXC_ERROR THEN
1399:
1400: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1401: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving create_template_revision: OKC_API.G_EXCEPTION_ERROR Exception');
1402: END IF;

Line 1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1408: ROLLBACK TO g_create_template_revision_grp;
1409: x_return_status := G_RET_STS_ERROR ;
1410: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1411:
1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1413: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1414: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving create_template_revision: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1415: END IF;
1416:

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

1483: -- Standard Start of API savepoint
1484: SAVEPOINT g_copy_archived_doc_GRP;
1485:
1486: -- Standard call to check for call compatibility.
1487: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1489: END IF;
1490:
1491: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1484: SAVEPOINT g_copy_archived_doc_GRP;
1485:
1486: -- Standard call to check for call compatibility.
1487: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1489: END IF;
1490:
1491: -- Initialize message list if p_init_msg_list is set to TRUE.
1492: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1492: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1489: END IF;
1490:
1491: -- Initialize message list if p_init_msg_list is set to TRUE.
1492: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1493: FND_MSG_PUB.initialize;
1494: END IF;
1495:
1496: -- Initialize API return status to success

Line 1497: x_return_status := FND_API.G_RET_STS_SUCCESS;

1493: FND_MSG_PUB.initialize;
1494: END IF;
1495:
1496: -- Initialize API return status to success
1497: x_return_status := FND_API.G_RET_STS_SUCCESS;
1498:
1499:
1500: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1501: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: calling OKC_TERMS_COPY_PVT.copy_archived_doc');

Line 1506: p_init_msg_list => FND_API.G_FALSE,

1502: END IF;
1503:
1504: OKC_TERMS_COPY_PVT.copy_archived_doc(
1505: p_api_version => 1,
1506: p_init_msg_list => FND_API.G_FALSE,
1507: p_commit => FND_API.G_FALSE,
1508: p_source_doc_type => p_source_doc_type,
1509: p_source_doc_id => p_source_doc_id,
1510: p_target_doc_type => p_target_doc_type,

Line 1507: p_commit => FND_API.G_FALSE,

1503:
1504: OKC_TERMS_COPY_PVT.copy_archived_doc(
1505: p_api_version => 1,
1506: p_init_msg_list => FND_API.G_FALSE,
1507: p_commit => FND_API.G_FALSE,
1508: p_source_doc_type => p_source_doc_type,
1509: p_source_doc_id => p_source_doc_id,
1510: p_target_doc_type => p_target_doc_type,
1511: p_target_doc_id => p_target_doc_id,

Line 1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1519: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: returned from OKC_TERMS_COPY_PVT.copy_archived_doc return status : '||x_return_status);
1520: END IF;
1521:
1522: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1524: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1525: RAISE FND_API.G_EXC_ERROR ;
1526: END IF;
1527:

Line 1525: RAISE FND_API.G_EXC_ERROR ;

1521:
1522: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1524: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1525: RAISE FND_API.G_EXC_ERROR ;
1526: END IF;
1527:
1528: IF FND_API.To_Boolean( p_commit ) THEN
1529: COMMIT WORK;

Line 1528: IF FND_API.To_Boolean( p_commit ) THEN

1524: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1525: RAISE FND_API.G_EXC_ERROR ;
1526: END IF;
1527:
1528: IF FND_API.To_Boolean( p_commit ) THEN
1529: COMMIT WORK;
1530: END IF;
1531:
1532: -- Standard call to get message count and if count is 1, get message info.

Line 1541: WHEN FND_API.G_EXC_ERROR THEN

1537: END IF;
1538:
1539: EXCEPTION
1540:
1541: WHEN FND_API.G_EXC_ERROR THEN
1542:
1543: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1544: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_ERROR Exception');
1545: END IF;

Line 1551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1547: ROLLBACK TO g_copy_archived_doc_grp;
1548: x_return_status := G_RET_STS_ERROR ;
1549: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1550:
1551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1552: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1553: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1554: END IF;
1555:

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

1638: -- Standard Start of API savepoint
1639: SAVEPOINT g_copy_doc_GRP;
1640:
1641: -- Standard call to check for call compatibility.
1642: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1644: END IF;
1645:
1646: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1639: SAVEPOINT g_copy_doc_GRP;
1640:
1641: -- Standard call to check for call compatibility.
1642: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1644: END IF;
1645:
1646: -- Initialize message list if p_init_msg_list is set to TRUE.
1647: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1647: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1644: END IF;
1645:
1646: -- Initialize message list if p_init_msg_list is set to TRUE.
1647: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1648: FND_MSG_PUB.initialize;
1649: END IF;
1650:
1651: -- Initialize API return status to success

Line 1652: x_return_status := FND_API.G_RET_STS_SUCCESS;

1648: FND_MSG_PUB.initialize;
1649: END IF;
1650:
1651: -- Initialize API return status to success
1652: x_return_status := FND_API.G_RET_STS_SUCCESS;
1653:
1654:
1655: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1656: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: calling OKC_TERMS_COPY_PVT.copy_tc');

Line 1661: p_init_msg_list => FND_API.G_FALSE,

1657: END IF;
1658: -- copy contract terms
1659: OKC_TERMS_COPY_PVT.copy_tc(
1660: p_api_version => 1,
1661: p_init_msg_list => FND_API.G_FALSE,
1662: p_commit => FND_API.G_FALSE,
1663: p_source_doc_type => p_source_doc_type,
1664: p_source_doc_id => p_source_doc_id ,
1665: p_target_doc_type => p_target_doc_type,

Line 1662: p_commit => FND_API.G_FALSE,

1658: -- copy contract terms
1659: OKC_TERMS_COPY_PVT.copy_tc(
1660: p_api_version => 1,
1661: p_init_msg_list => FND_API.G_FALSE,
1662: p_commit => FND_API.G_FALSE,
1663: p_source_doc_type => p_source_doc_type,
1664: p_source_doc_id => p_source_doc_id ,
1665: p_target_doc_type => p_target_doc_type,
1666: p_target_doc_id => p_target_doc_id,

Line 1681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1677: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished OKC_TERMS_COPY_PVT.copy_tc, return status'||x_return_status);
1678: END IF;
1679:
1680: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1682: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1683: RAISE FND_API.G_EXC_ERROR ;
1684: END IF;
1685: -----------------------------------------------------

Line 1683: RAISE FND_API.G_EXC_ERROR ;

1679:
1680: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1682: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1683: RAISE FND_API.G_EXC_ERROR ;
1684: END IF;
1685: -----------------------------------------------------
1686:
1687:

Line 1700: p_init_msg_list => FND_API.G_FALSE,

1696:
1697:
1698: OKC_DELIVERABLE_PROCESS_PVT.copy_response_deliverables (
1699: p_api_version => 1,
1700: p_init_msg_list => FND_API.G_FALSE,
1701: p_source_doc_id => p_source_doc_id,
1702: p_source_doc_type => p_source_doc_type,
1703: p_target_doc_id => p_target_doc_id,
1704: p_target_doc_type => p_target_doc_type,

Line 1716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1712: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables x_return_status : '||x_return_status);
1713: END IF;
1714:
1715: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1717: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1718: RAISE FND_API.G_EXC_ERROR ;
1719: END IF;
1720:

Line 1718: RAISE FND_API.G_EXC_ERROR ;

1714:
1715: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1717: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1718: RAISE FND_API.G_EXC_ERROR ;
1719: END IF;
1720:
1721: -- copy doc attachments if the flag is set to Y
1722: IF p_copy_doc_attachments ='Y' THEN

Line 1730: p_init_msg_list =>FND_API.G_FALSE,

1726: END IF;
1727:
1728: OKC_CONTRACT_DOCS_GRP.Copy_Attachments (
1729: p_api_version =>1,
1730: p_init_msg_list =>FND_API.G_FALSE,
1731: x_msg_data => x_msg_data,
1732: x_msg_count => x_msg_count,
1733: x_return_status => x_return_status,
1734: p_from_bus_doc_type => p_source_doc_type ,

Line 1748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1744: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1151:OKC_CONTRACT_DOCS_GRP.Copy_Attachments x_return_status : '||x_return_status);
1745: END IF;
1746:
1747: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1749: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1750: RAISE FND_API.G_EXC_ERROR ;
1751: END IF;
1752: END IF;

Line 1750: RAISE FND_API.G_EXC_ERROR ;

1746:
1747: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1749: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1750: RAISE FND_API.G_EXC_ERROR ;
1751: END IF;
1752: END IF;
1753:
1754: -------------------------------------------------------------

Line 1756: IF FND_API.To_Boolean( p_commit ) THEN

1752: END IF;
1753:
1754: -------------------------------------------------------------
1755:
1756: IF FND_API.To_Boolean( p_commit ) THEN
1757: COMMIT WORK;
1758: END IF;
1759:
1760: -- Standard call to get message count and if count is 1, get message info.

Line 1769: WHEN FND_API.G_EXC_ERROR THEN

1765: END IF;
1766:
1767: EXCEPTION
1768:
1769: WHEN FND_API.G_EXC_ERROR THEN
1770:
1771: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1772: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_response_doc: OKC_API.G_EXCEPTION_ERROR Exception');
1773: END IF;

Line 1779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1775: ROLLBACK TO g_copy_doc_grp;
1776: x_return_status := G_RET_STS_ERROR ;
1777: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1778:
1779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1780: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1781: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_response_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1782: END IF;
1783:

Line 1804: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

1800:
1801:
1802: PROCEDURE process_mod_terms (
1803: p_api_version IN Number,
1804: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
1805: p_commit IN Varchar2 default fnd_api.g_false,
1806:
1807: p_process IN VARCHAR2,
1808:

Line 1805: p_commit IN Varchar2 default fnd_api.g_false,

1801:
1802: PROCEDURE process_mod_terms (
1803: p_api_version IN Number,
1804: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
1805: p_commit IN Varchar2 default fnd_api.g_false,
1806:
1807: p_process IN VARCHAR2,
1808:
1809: p_source_doc_type IN Varchar2,

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

1871: -- Standard Start of API savepoint
1872: SAVEPOINT g_process_mod_terms_GRP;
1873:
1874: -- Standard call to check for call compatibility.
1875: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1877: END IF;
1878:
1879: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1872: SAVEPOINT g_process_mod_terms_GRP;
1873:
1874: -- Standard call to check for call compatibility.
1875: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1877: END IF;
1878:
1879: -- Initialize message list if p_init_msg_list is set to TRUE.
1880: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1880: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1877: END IF;
1878:
1879: -- Initialize message list if p_init_msg_list is set to TRUE.
1880: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1881: FND_MSG_PUB.initialize;
1882: END IF;
1883:
1884: -- Initialize API return status to success

Line 1885: x_return_status := FND_API.G_RET_STS_SUCCESS;

1881: FND_MSG_PUB.initialize;
1882: END IF;
1883:
1884: -- Initialize API return status to success
1885: x_return_status := FND_API.G_RET_STS_SUCCESS;
1886:
1887: IF p_process = 'CREATE' THEN
1888:
1889: l_retain_lock_terms_yn := 'N';

Line 1923: RAISE fnd_api.g_exc_error;

1919: (p_app_name => g_app_name,
1920: p_msg_name => 'OKC_PAR_CONFLICT_LOCKS'
1921: );
1922: x_return_status := g_ret_sts_error;
1923: RAISE fnd_api.g_exc_error;
1924: END IF;
1925: okc_k_entity_locks_grp.merge_changes( p_api_version => 1.0,
1926: p_init_msg_list => p_init_msg_list,
1927: p_commit => p_commit,

Line 1941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1937: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: okc_k_entity_locks_grp.merge_changes l_return_status : '||x_return_status);
1938: END IF;
1939:
1940: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1942: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1943: RAISE FND_API.G_EXC_ERROR ;
1944: END IF;
1945: END IF;

Line 1943: RAISE FND_API.G_EXC_ERROR ;

1939:
1940: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1942: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1943: RAISE FND_API.G_EXC_ERROR ;
1944: END IF;
1945: END IF;
1946:
1947: IF FND_API.To_Boolean( p_commit ) THEN

Line 1947: IF FND_API.To_Boolean( p_commit ) THEN

1943: RAISE FND_API.G_EXC_ERROR ;
1944: END IF;
1945: END IF;
1946:
1947: IF FND_API.To_Boolean( p_commit ) THEN
1948: COMMIT WORK;
1949: END IF;
1950:
1951: -- Standard call to get message count and if count is 1, get message info.

Line 1966: RAISE FND_API.G_EXC_ERROR;

1962: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Invalid mode is passed ');
1963: END IF;
1964:
1965: OKC_API.set_message(G_APP_NAME, OKC_API.G_INVALID_VALUE,OKC_API.G_COL_NAME_TOKEN,'p_process');
1966: RAISE FND_API.G_EXC_ERROR;
1967: END IF;
1968:
1969:
1970: -- Mod creation no need to copy terms.

Line 1981: , p_init_msg_list => FND_API.G_TRUE

1977:
1978: OKC_TERMS_UTIL_GRP.delete_doc
1979: (
1980: p_api_version => 1.0
1981: , p_init_msg_list => FND_API.G_TRUE
1982: , p_commit => FND_API.G_FALSE
1983: , p_doc_id => p_target_doc_id
1984: , p_doc_type => p_target_doc_type
1985: , p_validate_commit => FND_API.G_FALSE

Line 1982: , p_commit => FND_API.G_FALSE

1978: OKC_TERMS_UTIL_GRP.delete_doc
1979: (
1980: p_api_version => 1.0
1981: , p_init_msg_list => FND_API.G_TRUE
1982: , p_commit => FND_API.G_FALSE
1983: , p_doc_id => p_target_doc_id
1984: , p_doc_type => p_target_doc_type
1985: , p_validate_commit => FND_API.G_FALSE
1986:

Line 1985: , p_validate_commit => FND_API.G_FALSE

1981: , p_init_msg_list => FND_API.G_TRUE
1982: , p_commit => FND_API.G_FALSE
1983: , p_doc_id => p_target_doc_id
1984: , p_doc_type => p_target_doc_type
1985: , p_validate_commit => FND_API.G_FALSE
1986:
1987:
1988:
1989: , p_retain_lock_terms_yn => l_retain_lock_terms_yn

Line 2007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2003:
2004: END IF;
2005:
2006: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2008: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2009: RAISE FND_API.G_EXC_ERROR ;
2010: END IF;
2011:

Line 2009: RAISE FND_API.G_EXC_ERROR ;

2005:
2006: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2008: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2009: RAISE FND_API.G_EXC_ERROR ;
2010: END IF;
2011:
2012:
2013: END IF;

Line 2053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2049:
2050: END IF;
2051:
2052: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2054: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2055: RAISE FND_API.G_EXC_ERROR ;
2056: END IF;
2057:

Line 2055: RAISE FND_API.G_EXC_ERROR ;

2051:
2052: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2054: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2055: RAISE FND_API.G_EXC_ERROR ;
2056: END IF;
2057:
2058:
2059: IF FND_API.To_Boolean( p_commit ) THEN

Line 2059: IF FND_API.To_Boolean( p_commit ) THEN

2055: RAISE FND_API.G_EXC_ERROR ;
2056: END IF;
2057:
2058:
2059: IF FND_API.To_Boolean( p_commit ) THEN
2060: COMMIT WORK;
2061: END IF;
2062:
2063: -- Standard call to get message count and if count is 1, get message info.

Line 2072: WHEN FND_API.G_EXC_ERROR THEN

2068: END IF;
2069:
2070:
2071: EXCEPTION
2072: WHEN FND_API.G_EXC_ERROR THEN
2073:
2074: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2075: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving process_mod_terms: OKC_API.G_EXCEPTION_ERROR Exception');
2076: END IF;

Line 2082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2078: ROLLBACK TO g_process_mod_terms_GRP;
2079: x_return_status := G_RET_STS_ERROR ;
2080: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2081:
2082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2083: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2084: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving process_mod_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2085: END IF;
2086: