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

133: -- Standard Start of API savepoint
134: SAVEPOINT g_copy_doc_GRP;
135:
136: -- Standard call to check for call compatibility.
137: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
141: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

134: SAVEPOINT g_copy_doc_GRP;
135:
136: -- Standard call to check for call compatibility.
137: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
141: -- Initialize message list if p_init_msg_list is set to TRUE.
142: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 142: IF FND_API.to_Boolean( p_init_msg_list ) THEN

138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
141: -- Initialize message list if p_init_msg_list is set to TRUE.
142: IF FND_API.to_Boolean( p_init_msg_list ) THEN
143: FND_MSG_PUB.initialize;
144: END IF;
145:
146: -- Initialize API return status to success

Line 147: x_return_status := FND_API.G_RET_STS_SUCCESS;

143: FND_MSG_PUB.initialize;
144: END IF;
145:
146: -- Initialize API return status to success
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149:
150: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: calling OKC_TERMS_COPY_PVT.copy_tc');

Line 156: p_init_msg_list => FND_API.G_FALSE,

152: END IF;
153:
154: OKC_TERMS_COPY_PVT.copy_tc(
155: p_api_version => 1,
156: p_init_msg_list => FND_API.G_FALSE,
157: p_commit => FND_API.G_FALSE,
158: p_source_doc_type => p_source_doc_type,
159: p_source_doc_id => p_source_doc_id ,
160: p_target_doc_type => p_target_doc_type,

Line 157: p_commit => FND_API.G_FALSE,

153:
154: OKC_TERMS_COPY_PVT.copy_tc(
155: p_api_version => 1,
156: p_init_msg_list => FND_API.G_FALSE,
157: p_commit => FND_API.G_FALSE,
158: p_source_doc_type => p_source_doc_type,
159: p_source_doc_id => p_source_doc_id ,
160: p_target_doc_type => p_target_doc_type,
161: p_target_doc_id => p_target_doc_id,

Line 179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

175: 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);
176: END IF;
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:
185: /* get the deliverables_enabled_yn flag before calling copy_deliverables bug#3984339 */

Line 224: p_init_msg_list => FND_API.G_FALSE,

220:
221:
222: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables (
223: p_api_version => 1,
224: p_init_msg_list => FND_API.G_FALSE,
225: p_source_doc_id => p_source_doc_id,
226: p_source_doc_type => p_source_doc_type,
227: p_target_doc_id => p_target_doc_id,
228: p_target_doc_type => p_target_doc_type,

Line 250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

246: 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);
247: END IF;
248:
249: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
251: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
252: RAISE FND_API.G_EXC_ERROR ;
253: END IF;
254:

Line 252: RAISE FND_API.G_EXC_ERROR ;

248:
249: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
251: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
252: RAISE FND_API.G_EXC_ERROR ;
253: END IF;
254:
255: END IF;
256: -------------------------------------------------------

Line 267: p_init_msg_list => FND_API.G_FALSE,

263:
264:
265: OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment (
266: p_api_version => 1,
267: p_init_msg_list => FND_API.G_FALSE,
268: p_source_doc_id => p_source_doc_id,
269: p_source_doc_type => p_source_doc_type,
270: p_target_doc_id => p_target_doc_id,
271: p_target_doc_type => p_target_doc_type,

Line 286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

282: 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);
283: END IF;
284:
285: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
287: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
288: RAISE FND_API.G_EXC_ERROR ;
289: END IF;
290:

Line 288: RAISE FND_API.G_EXC_ERROR ;

284:
285: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
287: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
288: RAISE FND_API.G_EXC_ERROR ;
289: END IF;
290:
291: END IF;
292:

Line 300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

296: p_document_type => p_source_doc_type,
297: p_document_id => p_source_doc_id
298: );
299: IF (l_contract_source = 'E') THEN
300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
301: END IF;
302:
303: ---------------------------------------------------------
304:

Line 313: p_init_msg_list =>FND_API.G_FALSE,

309: END IF;
310:
311: OKC_CONTRACT_DOCS_GRP.Copy_Attachments (
312: p_api_version =>1,
313: p_init_msg_list =>FND_API.G_FALSE,
314: x_msg_data => x_msg_data,
315: x_msg_count => x_msg_count,
316: x_return_status => x_return_status,
317: p_from_bus_doc_type => p_source_doc_type ,

Line 332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

328: 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);
329: END IF;
330:
331: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
333: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
334: RAISE FND_API.G_EXC_ERROR ;
335: END IF;
336: ELSIF (p_copy_doc_attachments ='Y' ) THEN

Line 334: RAISE FND_API.G_EXC_ERROR ;

330:
331: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
333: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
334: RAISE FND_API.G_EXC_ERROR ;
335: END IF;
336: ELSIF (p_copy_doc_attachments ='Y' ) THEN
337: /* Copy all attachments*/
338: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 344: p_init_msg_list =>FND_API.G_FALSE,

340: END IF;
341:
342: OKC_CONTRACT_DOCS_GRP.Copy_Attachments (
343: p_api_version =>1,
344: p_init_msg_list =>FND_API.G_FALSE,
345: x_msg_data => x_msg_data,
346: x_msg_count => x_msg_count,
347: x_return_status => x_return_status,
348: p_from_bus_doc_type => p_source_doc_type ,

Line 364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

360: 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);
361: END IF;
362:
363: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
365: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
366: RAISE FND_API.G_EXC_ERROR ;
367: END IF;
368: END IF;

Line 366: RAISE FND_API.G_EXC_ERROR ;

362:
363: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
365: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
366: RAISE FND_API.G_EXC_ERROR ;
367: END IF;
368: END IF;
369:
370: -------------------------------------------------------------

Line 372: IF FND_API.To_Boolean( p_commit ) THEN

368: END IF;
369:
370: -------------------------------------------------------------
371:
372: IF FND_API.To_Boolean( p_commit ) THEN
373: COMMIT WORK;
374: END IF;
375:
376: -- Standard call to get message count and if count is 1, get message info.

Line 385: WHEN FND_API.G_EXC_ERROR THEN

381: END IF;
382:
383: EXCEPTION
384:
385: WHEN FND_API.G_EXC_ERROR THEN
386:
387: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_doc: OKC_API.G_EXCEPTION_ERROR Exception');
389: END IF;

Line 395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

391: ROLLBACK TO g_copy_doc_grp;
392: x_return_status := G_RET_STS_ERROR ;
393: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
394:
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
397: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
398: END IF;
399:

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

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

Line 509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 513: IF FND_API.to_Boolean( p_init_msg_list ) THEN

509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
512: -- Initialize message list if p_init_msg_list is set to TRUE.
513: IF FND_API.to_Boolean( p_init_msg_list ) THEN
514: FND_MSG_PUB.initialize;
515: END IF;
516:
517: -- Initialize API return status to success

Line 518: x_return_status := FND_API.G_RET_STS_SUCCESS;

514: FND_MSG_PUB.initialize;
515: END IF;
516:
517: -- Initialize API return status to success
518: x_return_status := FND_API.G_RET_STS_SUCCESS;
519:
520: OPEN l_get_tmpl_csr;
521: FETCH l_get_tmpl_csr INTO l_tmpl_rec;
522: CLOSE l_get_tmpl_csr;

Line 550: RAISE FND_API.G_EXC_ERROR ;

546: IF l_check_tmpl_name_csr%FOUND THEN
547:
548: okc_Api.Set_Message(p_app_name => G_APP_NAME,
549: p_msg_name => 'OKC_SAME_TMPL_NAME');
550: RAISE FND_API.G_EXC_ERROR ;
551:
552: END IF;
553:
554: CLOSE l_check_tmpl_name_csr;

Line 617: p_init_msg_list => FND_API.G_FALSE,

613:
614:
615: OKC_TERMS_COPY_PVT.copy_tc(
616: p_api_version => 1,
617: p_init_msg_list => FND_API.G_FALSE,
618: p_commit => FND_API.G_FALSE,
619: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
620: p_source_doc_id => p_template_id,
621: p_target_doc_type => l_document_type,

Line 618: p_commit => FND_API.G_FALSE,

614:
615: OKC_TERMS_COPY_PVT.copy_tc(
616: p_api_version => 1,
617: p_init_msg_list => FND_API.G_FALSE,
618: p_commit => FND_API.G_FALSE,
619: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
620: p_source_doc_id => p_template_id,
621: p_target_doc_type => l_document_type,
622: p_target_doc_id => x_template_id,

Line 634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

630: 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);
631: END IF;
632:
633: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
635: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
636: RAISE FND_API.G_EXC_ERROR ;
637: END IF;
638: -----------------------------------

Line 636: RAISE FND_API.G_EXC_ERROR ;

632:
633: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
635: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
636: RAISE FND_API.G_EXC_ERROR ;
637: END IF;
638: -----------------------------------
639: /* Fix for the Bug# 4113678, check whether if the deliverables exist before copying deliverables */
640:

Line 647: p_init_msg_list => FND_API.G_FALSE,

643: END IF;
644:
645: l_deliverables_exist := okc_terms_util_grp.Is_Deliverable_Exist(
646: p_api_version => 1,
647: p_init_msg_list => FND_API.G_FALSE,
648: x_return_status => x_return_status,
649: x_msg_data => x_msg_data,
650: x_msg_count => x_msg_count,
651: p_doc_type => 'TEMPLATE',

Line 675: p_init_msg_list => FND_API.G_FALSE,

671:
672:
673: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables (
674: p_api_version => 1,
675: p_init_msg_list => FND_API.G_FALSE,
676: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
677: p_source_doc_id => p_template_id,
678: p_target_doc_type => l_document_type,
679: p_target_doc_id => x_template_id,

Line 696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

692: 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);
693: END IF;
694:
695: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
697: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
698: RAISE FND_API.G_EXC_ERROR ;
699: END IF;
700:

Line 698: RAISE FND_API.G_EXC_ERROR ;

694:
695: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
697: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
698: RAISE FND_API.G_EXC_ERROR ;
699: END IF;
700:
701: END IF;
702:

Line 707: IF FND_API.To_Boolean( p_commit ) THEN

703:
704:
705:
706: -----------------------------------
707: IF FND_API.To_Boolean( p_commit ) THEN
708: COMMIT WORK;
709: END IF;
710:
711: -- Standard call to get message count and if count is 1, get message info.

Line 720: WHEN FND_API.G_EXC_ERROR THEN

716: END IF;
717:
718: EXCEPTION
719:
720: WHEN FND_API.G_EXC_ERROR THEN
721:
722: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
723: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_terms_template: OKC_API.G_EXCEPTION_ERROR Exception');
724: END IF;

Line 738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

734: ROLLBACK TO g_copy_terms_template_grp;
735: x_return_status := G_RET_STS_ERROR ;
736: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
737:
738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
739: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
740: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_terms_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
741: END IF;
742:

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

854: -- Standard Start of API savepoint
855: SAVEPOINT g_copy_terms_GRP;
856:
857: -- Standard call to check for call compatibility.
858: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
860: END IF;
861:
862: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

855: SAVEPOINT g_copy_terms_GRP;
856:
857: -- Standard call to check for call compatibility.
858: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
860: END IF;
861:
862: -- Initialize message list if p_init_msg_list is set to TRUE.
863: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 863: IF FND_API.to_Boolean( p_init_msg_list ) THEN

859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
860: END IF;
861:
862: -- Initialize message list if p_init_msg_list is set to TRUE.
863: IF FND_API.to_Boolean( p_init_msg_list ) THEN
864: FND_MSG_PUB.initialize;
865: END IF;
866:
867: IF FND_API.To_Boolean( p_validate_commit ) AND

Line 867: IF FND_API.To_Boolean( p_validate_commit ) AND

863: IF FND_API.to_Boolean( p_init_msg_list ) THEN
864: FND_MSG_PUB.initialize;
865: END IF;
866:
867: IF FND_API.To_Boolean( p_validate_commit ) AND
868: NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
869: p_api_version => l_api_version,
870: p_init_msg_list => FND_API.G_FALSE,
871: p_doc_type => p_target_doc_type,

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

864: FND_MSG_PUB.initialize;
865: END IF;
866:
867: IF FND_API.To_Boolean( p_validate_commit ) AND
868: NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
869: p_api_version => l_api_version,
870: p_init_msg_list => FND_API.G_FALSE,
871: p_doc_type => p_target_doc_type,
872: p_doc_id => p_target_doc_id,

Line 870: p_init_msg_list => FND_API.G_FALSE,

866:
867: IF FND_API.To_Boolean( p_validate_commit ) AND
868: NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
869: p_api_version => l_api_version,
870: p_init_msg_list => FND_API.G_FALSE,
871: p_doc_type => p_target_doc_type,
872: p_doc_id => p_target_doc_id,
873: p_validation_string =>p_validation_string,
874: p_tmpl_change => 'Y',

Line 882: RAISE FND_API.G_EXC_ERROR ;

878:
879: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
880: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'700: Issue with document header Record.Cannot commit');
881: END IF;
882: RAISE FND_API.G_EXC_ERROR ;
883: END IF;
884:
885: -- Initialize API return status to success
886: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 886: x_return_status := FND_API.G_RET_STS_SUCCESS;

882: RAISE FND_API.G_EXC_ERROR ;
883: END IF;
884:
885: -- Initialize API return status to success
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887:
888: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
889: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: calling OKC_TERMS_COPY_PVT.copy_tc');
890: END IF;

Line 894: p_init_msg_list => FND_API.G_FALSE,

890: END IF;
891:
892: OKC_TERMS_COPY_PVT.copy_tc(
893: p_api_version => 1,
894: p_init_msg_list => FND_API.G_FALSE,
895: p_commit => FND_API.G_FALSE,
896: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
897: p_source_doc_id => p_template_id,
898: p_target_doc_type => l_document_type,

Line 895: p_commit => FND_API.G_FALSE,

891:
892: OKC_TERMS_COPY_PVT.copy_tc(
893: p_api_version => 1,
894: p_init_msg_list => FND_API.G_FALSE,
895: p_commit => FND_API.G_FALSE,
896: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
897: p_source_doc_id => p_template_id,
898: p_target_doc_type => l_document_type,
899: p_target_doc_id => l_document_id,

Line 916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

912: 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);
913: END IF;
914:
915: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
917: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
918: RAISE FND_API.G_EXC_ERROR ;
919: END IF;
920:

Line 918: RAISE FND_API.G_EXC_ERROR ;

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

Line 945: p_init_msg_list => FND_API.G_FALSE,

941:
942:
943: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables (
944: p_api_version => 1,
945: p_init_msg_list => FND_API.G_FALSE,
946: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
947: p_source_doc_id => p_template_id,
948: p_target_doc_type => l_document_type,
949: p_target_doc_id => l_document_id,

Line 969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

965: 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);
966: END IF;
967:
968: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
970: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
971: RAISE FND_API.G_EXC_ERROR ;
972: END IF;
973:

Line 971: RAISE FND_API.G_EXC_ERROR ;

967:
968: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
970: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
971: RAISE FND_API.G_EXC_ERROR ;
972: END IF;
973:
974: END IF; -- l_enable_deliverables = 'Y' THEN
975:

Line 995: p_init_msg_list => FND_API.G_FALSE,

991: END IF;
992:
993: OKC_NUMBER_SCHEME_GRP.apply_numbering_scheme(
994: p_api_version => p_api_version,
995: p_init_msg_list => FND_API.G_FALSE,
996: x_return_status => x_return_status,
997: x_msg_count => x_msg_count,
998: x_msg_data => x_msg_data,
999: p_validate_commit => FND_API.G_FALSE,

Line 999: p_validate_commit => FND_API.G_FALSE,

995: p_init_msg_list => FND_API.G_FALSE,
996: x_return_status => x_return_status,
997: x_msg_count => x_msg_count,
998: x_msg_data => x_msg_data,
999: p_validate_commit => FND_API.G_FALSE,
1000: p_validation_string => p_validation_string,
1001: p_commit => FND_API.G_FALSE,
1002: p_doc_type => l_document_type,
1003: p_doc_id => l_document_id,

Line 1001: p_commit => FND_API.G_FALSE,

997: x_msg_count => x_msg_count,
998: x_msg_data => x_msg_data,
999: p_validate_commit => FND_API.G_FALSE,
1000: p_validation_string => p_validation_string,
1001: p_commit => FND_API.G_FALSE,
1002: p_doc_type => l_document_type,
1003: p_doc_id => l_document_id,
1004: p_num_scheme_id => l_num_scheme_id
1005: );

Line 1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1009: 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);
1010: END IF;
1011:
1012: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1014: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1015: RAISE FND_API.G_EXC_ERROR ;
1016: END IF;
1017:

Line 1015: RAISE FND_API.G_EXC_ERROR ;

1011:
1012: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1014: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1015: RAISE FND_API.G_EXC_ERROR ;
1016: END IF;
1017:
1018:
1019: END IF; --l_num_scheme_id is not 0

Line 1027: IF FND_API.To_Boolean( p_commit ) THEN

1023: -- End Bug 3674173
1024:
1025:
1026: ------------------------------------
1027: IF FND_API.To_Boolean( p_commit ) THEN
1028: COMMIT WORK;
1029: END IF;
1030:
1031: -- Standard call to get message count and if count is 1, get message info.

Line 1042: WHEN FND_API.G_EXC_ERROR THEN

1038:
1039:
1040: EXCEPTION
1041:
1042: WHEN FND_API.G_EXC_ERROR THEN
1043:
1044: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1045: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_terms: OKC_API.G_EXCEPTION_ERROR Exception');
1046: END IF;

Line 1052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1048: ROLLBACK TO g_copy_terms_grp;
1049: x_return_status := G_RET_STS_ERROR ;
1050: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1051:
1052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1053: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1054: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1055: END IF;
1056:

Line 1081: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

1077: /* To be used to create Revision of a Template */
1078:
1079: Procedure create_template_revision (
1080: p_api_version IN Number,
1081: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
1082: p_commit IN Varchar2 default FND_API.G_FALSE,
1083: p_template_id IN Number,
1084: p_copy_deliverables IN Varchar2 default 'Y',
1085: x_template_id OUT NOCOPY Number,

Line 1082: p_commit IN Varchar2 default FND_API.G_FALSE,

1078:
1079: Procedure create_template_revision (
1080: p_api_version IN Number,
1081: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
1082: p_commit IN Varchar2 default FND_API.G_FALSE,
1083: p_template_id IN Number,
1084: p_copy_deliverables IN Varchar2 default 'Y',
1085: x_template_id OUT NOCOPY Number,
1086: x_return_status OUT NOCOPY Varchar2,

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

1114: -- Standard Start of API savepoint
1115: SAVEPOINT g_create_template_revision_GRP;
1116:
1117: -- Standard call to check for call compatibility.
1118: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: END IF;
1121:
1122: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1115: SAVEPOINT g_create_template_revision_GRP;
1116:
1117: -- Standard call to check for call compatibility.
1118: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: END IF;
1121:
1122: -- Initialize message list if p_init_msg_list is set to TRUE.
1123: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1123: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: END IF;
1121:
1122: -- Initialize message list if p_init_msg_list is set to TRUE.
1123: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1124: FND_MSG_PUB.initialize;
1125: END IF;
1126:
1127: -- Initialize API return status to success

Line 1128: x_return_status := FND_API.G_RET_STS_SUCCESS;

1124: FND_MSG_PUB.initialize;
1125: END IF;
1126:
1127: -- Initialize API return status to success
1128: x_return_status := FND_API.G_RET_STS_SUCCESS;
1129:
1130: OPEN l_get_tmpl_csr;
1131: FETCH l_get_tmpl_csr INTO l_tmpl_rec;
1132: CLOSE l_get_tmpl_csr;

Line 1182: p_init_msg_list => FND_API.G_FALSE,

1178: END IF;
1179:
1180: OKC_TERMS_COPY_PVT.copy_tc(
1181: p_api_version => 1,
1182: p_init_msg_list => FND_API.G_FALSE,
1183: p_commit => FND_API.G_FALSE,
1184: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
1185: p_source_doc_id => p_template_id,
1186: p_target_doc_type => l_document_type,

Line 1183: p_commit => FND_API.G_FALSE,

1179:
1180: OKC_TERMS_COPY_PVT.copy_tc(
1181: p_api_version => 1,
1182: p_init_msg_list => FND_API.G_FALSE,
1183: p_commit => FND_API.G_FALSE,
1184: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
1185: p_source_doc_id => p_template_id,
1186: p_target_doc_type => l_document_type,
1187: p_target_doc_id => x_template_id,

Line 1199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1195: 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);
1196: END IF;
1197:
1198: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1200: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1201: RAISE FND_API.G_EXC_ERROR ;
1202: END IF;
1203: ----------------------------------------------

Line 1201: RAISE FND_API.G_EXC_ERROR ;

1197:
1198: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1200: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1201: RAISE FND_API.G_EXC_ERROR ;
1202: END IF;
1203: ----------------------------------------------
1204: -- bug#4083525 do not invoke deliverables API for sell side
1205: -- to be removed when sell side deliverables are enabled.

Line 1223: p_init_msg_list => FND_API.G_FALSE,

1219: -- bug#4075168 New API for Template Revision replacing copy_deliverables
1220:
1221: OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision(
1222: p_api_version => 1,
1223: p_init_msg_list => FND_API.G_FALSE,
1224: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
1225: p_source_doc_id => p_template_id,
1226: p_target_doc_type => l_document_type,
1227: p_target_doc_id => x_template_id,

Line 1241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1237: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision x_return_status : '||x_return_status);
1238: END IF;
1239:
1240: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1242: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1243: RAISE FND_API.G_EXC_ERROR ;
1244: END IF;
1245:

Line 1243: RAISE FND_API.G_EXC_ERROR ;

1239:
1240: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1242: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1243: RAISE FND_API.G_EXC_ERROR ;
1244: END IF;
1245:
1246: END IF;-- l_copy_deliverables='Y'
1247:

Line 1249: IF FND_API.To_Boolean( p_commit ) THEN

1245:
1246: END IF;-- l_copy_deliverables='Y'
1247:
1248: -----------------------------------------------
1249: IF FND_API.To_Boolean( p_commit ) THEN
1250: COMMIT WORK;
1251: END IF;
1252:
1253: -- Standard call to get message count and if count is 1, get message info.

Line 1262: WHEN FND_API.G_EXC_ERROR THEN

1258: END IF;
1259:
1260: EXCEPTION
1261:
1262: WHEN FND_API.G_EXC_ERROR THEN
1263:
1264: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1265: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving create_template_revision: OKC_API.G_EXCEPTION_ERROR Exception');
1266: END IF;

Line 1276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1272: ROLLBACK TO g_create_template_revision_grp;
1273: x_return_status := G_RET_STS_ERROR ;
1274: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1275:
1276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1277: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1278: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving create_template_revision: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1279: END IF;
1280:

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

1347: -- Standard Start of API savepoint
1348: SAVEPOINT g_copy_archived_doc_GRP;
1349:
1350: -- Standard call to check for call compatibility.
1351: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1353: END IF;
1354:
1355: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1348: SAVEPOINT g_copy_archived_doc_GRP;
1349:
1350: -- Standard call to check for call compatibility.
1351: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1353: END IF;
1354:
1355: -- Initialize message list if p_init_msg_list is set to TRUE.
1356: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1356: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1353: END IF;
1354:
1355: -- Initialize message list if p_init_msg_list is set to TRUE.
1356: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1357: FND_MSG_PUB.initialize;
1358: END IF;
1359:
1360: -- Initialize API return status to success

Line 1361: x_return_status := FND_API.G_RET_STS_SUCCESS;

1357: FND_MSG_PUB.initialize;
1358: END IF;
1359:
1360: -- Initialize API return status to success
1361: x_return_status := FND_API.G_RET_STS_SUCCESS;
1362:
1363:
1364: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1365: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: calling OKC_TERMS_COPY_PVT.copy_archived_doc');

Line 1370: p_init_msg_list => FND_API.G_FALSE,

1366: END IF;
1367:
1368: OKC_TERMS_COPY_PVT.copy_archived_doc(
1369: p_api_version => 1,
1370: p_init_msg_list => FND_API.G_FALSE,
1371: p_commit => FND_API.G_FALSE,
1372: p_source_doc_type => p_source_doc_type,
1373: p_source_doc_id => p_source_doc_id,
1374: p_target_doc_type => p_target_doc_type,

Line 1371: p_commit => FND_API.G_FALSE,

1367:
1368: OKC_TERMS_COPY_PVT.copy_archived_doc(
1369: p_api_version => 1,
1370: p_init_msg_list => FND_API.G_FALSE,
1371: p_commit => FND_API.G_FALSE,
1372: p_source_doc_type => p_source_doc_type,
1373: p_source_doc_id => p_source_doc_id,
1374: p_target_doc_type => p_target_doc_type,
1375: p_target_doc_id => p_target_doc_id,

Line 1387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1383: 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);
1384: END IF;
1385:
1386: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1388: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1389: RAISE FND_API.G_EXC_ERROR ;
1390: END IF;
1391:

Line 1389: RAISE FND_API.G_EXC_ERROR ;

1385:
1386: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1388: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1389: RAISE FND_API.G_EXC_ERROR ;
1390: END IF;
1391:
1392: IF FND_API.To_Boolean( p_commit ) THEN
1393: COMMIT WORK;

Line 1392: IF FND_API.To_Boolean( p_commit ) THEN

1388: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1389: RAISE FND_API.G_EXC_ERROR ;
1390: END IF;
1391:
1392: IF FND_API.To_Boolean( p_commit ) THEN
1393: COMMIT WORK;
1394: END IF;
1395:
1396: -- Standard call to get message count and if count is 1, get message info.

Line 1405: WHEN FND_API.G_EXC_ERROR THEN

1401: END IF;
1402:
1403: EXCEPTION
1404:
1405: WHEN FND_API.G_EXC_ERROR THEN
1406:
1407: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1408: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_ERROR Exception');
1409: END IF;

Line 1415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

1502: -- Standard Start of API savepoint
1503: SAVEPOINT g_copy_doc_GRP;
1504:
1505: -- Standard call to check for call compatibility.
1506: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1508: END IF;
1509:
1510: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1503: SAVEPOINT g_copy_doc_GRP;
1504:
1505: -- Standard call to check for call compatibility.
1506: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1508: END IF;
1509:
1510: -- Initialize message list if p_init_msg_list is set to TRUE.
1511: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1511: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1508: END IF;
1509:
1510: -- Initialize message list if p_init_msg_list is set to TRUE.
1511: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1512: FND_MSG_PUB.initialize;
1513: END IF;
1514:
1515: -- Initialize API return status to success

Line 1516: x_return_status := FND_API.G_RET_STS_SUCCESS;

1512: FND_MSG_PUB.initialize;
1513: END IF;
1514:
1515: -- Initialize API return status to success
1516: x_return_status := FND_API.G_RET_STS_SUCCESS;
1517:
1518:
1519: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1520: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: calling OKC_TERMS_COPY_PVT.copy_tc');

Line 1525: p_init_msg_list => FND_API.G_FALSE,

1521: END IF;
1522: -- copy contract terms
1523: OKC_TERMS_COPY_PVT.copy_tc(
1524: p_api_version => 1,
1525: p_init_msg_list => FND_API.G_FALSE,
1526: p_commit => FND_API.G_FALSE,
1527: p_source_doc_type => p_source_doc_type,
1528: p_source_doc_id => p_source_doc_id ,
1529: p_target_doc_type => p_target_doc_type,

Line 1526: p_commit => FND_API.G_FALSE,

1522: -- copy contract terms
1523: OKC_TERMS_COPY_PVT.copy_tc(
1524: p_api_version => 1,
1525: p_init_msg_list => FND_API.G_FALSE,
1526: p_commit => FND_API.G_FALSE,
1527: p_source_doc_type => p_source_doc_type,
1528: p_source_doc_id => p_source_doc_id ,
1529: p_target_doc_type => p_target_doc_type,
1530: p_target_doc_id => p_target_doc_id,

Line 1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1541: 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);
1542: END IF;
1543:
1544: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1546: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1547: RAISE FND_API.G_EXC_ERROR ;
1548: END IF;
1549: -----------------------------------------------------

Line 1547: RAISE FND_API.G_EXC_ERROR ;

1543:
1544: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1546: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1547: RAISE FND_API.G_EXC_ERROR ;
1548: END IF;
1549: -----------------------------------------------------
1550:
1551:

Line 1564: p_init_msg_list => FND_API.G_FALSE,

1560:
1561:
1562: OKC_DELIVERABLE_PROCESS_PVT.copy_response_deliverables (
1563: p_api_version => 1,
1564: p_init_msg_list => FND_API.G_FALSE,
1565: p_source_doc_id => p_source_doc_id,
1566: p_source_doc_type => p_source_doc_type,
1567: p_target_doc_id => p_target_doc_id,
1568: p_target_doc_type => p_target_doc_type,

Line 1580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1576: 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);
1577: END IF;
1578:
1579: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1581: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1582: RAISE FND_API.G_EXC_ERROR ;
1583: END IF;
1584:

Line 1582: RAISE FND_API.G_EXC_ERROR ;

1578:
1579: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1581: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1582: RAISE FND_API.G_EXC_ERROR ;
1583: END IF;
1584:
1585: -- copy doc attachments if the flag is set to Y
1586: IF p_copy_doc_attachments ='Y' THEN

Line 1594: p_init_msg_list =>FND_API.G_FALSE,

1590: END IF;
1591:
1592: OKC_CONTRACT_DOCS_GRP.Copy_Attachments (
1593: p_api_version =>1,
1594: p_init_msg_list =>FND_API.G_FALSE,
1595: x_msg_data => x_msg_data,
1596: x_msg_count => x_msg_count,
1597: x_return_status => x_return_status,
1598: p_from_bus_doc_type => p_source_doc_type ,

Line 1612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1608: 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);
1609: END IF;
1610:
1611: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1613: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1614: RAISE FND_API.G_EXC_ERROR ;
1615: END IF;
1616: END IF;

Line 1614: RAISE FND_API.G_EXC_ERROR ;

1610:
1611: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1613: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1614: RAISE FND_API.G_EXC_ERROR ;
1615: END IF;
1616: END IF;
1617:
1618: -------------------------------------------------------------

Line 1620: IF FND_API.To_Boolean( p_commit ) THEN

1616: END IF;
1617:
1618: -------------------------------------------------------------
1619:
1620: IF FND_API.To_Boolean( p_commit ) THEN
1621: COMMIT WORK;
1622: END IF;
1623:
1624: -- Standard call to get message count and if count is 1, get message info.

Line 1633: WHEN FND_API.G_EXC_ERROR THEN

1629: END IF;
1630:
1631: EXCEPTION
1632:
1633: WHEN FND_API.G_EXC_ERROR THEN
1634:
1635: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1636: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_response_doc: OKC_API.G_EXCEPTION_ERROR Exception');
1637: END IF;

Line 1643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1639: ROLLBACK TO g_copy_doc_grp;
1640: x_return_status := G_RET_STS_ERROR ;
1641: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1642:
1643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1644: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1645: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_response_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1646: END IF;
1647: