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.

[Home] [Help]

APPS.OKC_TERMS_UTIL_GRP dependencies on FND_API

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

15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_AMEND_CODE_DELETED CONSTANT VARCHAR2(30) := 'DELETED';
23: G_ATTACHED_CONTRACT_SOURCE CONSTANT VARCHAR2(30) := 'ATTACHED';

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

16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_AMEND_CODE_DELETED CONSTANT VARCHAR2(30) := 'DELETED';
23: G_ATTACHED_CONTRACT_SOURCE CONSTANT VARCHAR2(30) := 'ATTACHED';
24: G_STRUCT_CONTRACT_SOURCE CONSTANT VARCHAR2(30) := 'STRUCTURED';

Line 30: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;

26:
27: -- Validation string for repository.
28: G_REP_CHECK_STATUS CONSTANT VARCHAR2(30) := 'OKC_REP_CHECK_STATUS';
29:
30: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
31: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
32: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
33:
34: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';

Line 31: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;

27: -- Validation string for repository.
28: G_REP_CHECK_STATUS CONSTANT VARCHAR2(30) := 'OKC_REP_CHECK_STATUS';
29:
30: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
31: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
32: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
33:
34: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
35: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';

Line 32: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

28: G_REP_CHECK_STATUS CONSTANT VARCHAR2(30) := 'OKC_REP_CHECK_STATUS';
29:
30: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
31: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
32: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
33:
34: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
35: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
36: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';

Line 44: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

40: -- To be used to delete Terms whenever a document is deleted.
41: */
42: PROCEDURE Delete_Doc (
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
45: p_commit IN VARCHAR2 := FND_API.G_FALSE,
46:
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_data OUT NOCOPY VARCHAR2,

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

41: */
42: PROCEDURE Delete_Doc (
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
45: p_commit IN VARCHAR2 := FND_API.G_FALSE,
46:
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,

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

47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
50:
51: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
52: p_validation_string IN VARCHAR2 := NULL,
53:
54: p_doc_type IN VARCHAR2,
55: p_doc_id IN NUMBER

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

87: END IF;
88: -- Standard Start of API savepoint
89: SAVEPOINT g_Delete_Doc;
90: -- Standard call to check for call compatibility.
91: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94: -- Initialize message list if p_init_msg_list is set to TRUE.
95: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

88: -- Standard Start of API savepoint
89: SAVEPOINT g_Delete_Doc;
90: -- Standard call to check for call compatibility.
91: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94: -- Initialize message list if p_init_msg_list is set to TRUE.
95: IF FND_API.to_Boolean( p_init_msg_list ) THEN
96: FND_MSG_PUB.initialize;

Line 95: IF FND_API.to_Boolean( p_init_msg_list ) THEN

91: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94: -- Initialize message list if p_init_msg_list is set to TRUE.
95: IF FND_API.to_Boolean( p_init_msg_list ) THEN
96: FND_MSG_PUB.initialize;
97: END IF;
98: -- Initialize API return status to success
99: x_return_status := G_RET_STS_SUCCESS;

Line 116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

112: p_doc_type => p_doc_type
113: );
114: --------------------------------------------
115: IF (l_dummy = G_FALSE OR x_return_status = G_RET_STS_UNEXP_ERROR) THEN
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
117: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
118: RAISE FND_API.G_EXC_ERROR ;
119: END IF;
120: --------------------------------------------

Line 118: RAISE FND_API.G_EXC_ERROR ;

114: --------------------------------------------
115: IF (l_dummy = G_FALSE OR x_return_status = G_RET_STS_UNEXP_ERROR) THEN
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
117: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
118: RAISE FND_API.G_EXC_ERROR ;
119: END IF;
120: --------------------------------------------
121: END IF;
122:

Line 138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

134: ,p_retain_lock_xprt_yn => p_retain_lock_xprt_yn
135: );
136: --------------------------------------------
137: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
139: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
140: RAISE FND_API.G_EXC_ERROR ;
141: END IF;
142: --------------------------------------------

Line 140: RAISE FND_API.G_EXC_ERROR ;

136: --------------------------------------------
137: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
139: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
140: RAISE FND_API.G_EXC_ERROR ;
141: END IF;
142: --------------------------------------------
143:
144: --IF p_retain_deliverables_yn = 'N' THEN

Line 151: p_init_msg_list => FND_API.G_FALSE,

147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1100: Delete delevirable for the doc');
148: END IF;
149: OKC_DELIVERABLE_PROCESS_PVT.Delete_Deliverables(
150: p_api_version => l_api_version,
151: p_init_msg_list => FND_API.G_FALSE,
152: p_doc_type => p_doc_type,
153: p_doc_id => p_doc_id,
154: p_doc_version => -99,
155: x_msg_data => x_msg_data,

Line 163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

159: , p_retain_exhibits => p_retain_exhibits
160: );
161: --------------------------------------------
162: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
164: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
165: RAISE FND_API.G_EXC_ERROR ;
166: END IF;
167: --------------------------------------------

Line 165: RAISE FND_API.G_EXC_ERROR ;

161: --------------------------------------------
162: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
164: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
165: RAISE FND_API.G_EXC_ERROR ;
166: END IF;
167: --------------------------------------------
168: --END IF; -- p_retain_deliverables_yn = 'N'
169:

Line 176: p_init_msg_list => FND_API.G_FALSE,

172: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1200: Delete attachments for the doc');
173: END IF;
174: OKC_CONTRACT_DOCS_GRP.Delete_Ver_Attachments(
175: p_api_version => l_api_version,
176: p_init_msg_list => FND_API.G_FALSE,
177: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
178: p_commit => FND_API.G_FALSE,
179: p_business_document_type => p_doc_type,
180: p_business_document_id => p_doc_id,

Line 177: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,

173: END IF;
174: OKC_CONTRACT_DOCS_GRP.Delete_Ver_Attachments(
175: p_api_version => l_api_version,
176: p_init_msg_list => FND_API.G_FALSE,
177: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
178: p_commit => FND_API.G_FALSE,
179: p_business_document_type => p_doc_type,
180: p_business_document_id => p_doc_id,
181: p_business_document_version=> -99,

Line 178: p_commit => FND_API.G_FALSE,

174: OKC_CONTRACT_DOCS_GRP.Delete_Ver_Attachments(
175: p_api_version => l_api_version,
176: p_init_msg_list => FND_API.G_FALSE,
177: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
178: p_commit => FND_API.G_FALSE,
179: p_business_document_type => p_doc_type,
180: p_business_document_id => p_doc_id,
181: p_business_document_version=> -99,
182: x_msg_data => x_msg_data,

Line 188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

184: x_return_status => x_return_status
185: );
186: --------------------------------------------
187: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
189: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
190: RAISE FND_API.G_EXC_ERROR ;
191: END IF;
192: --------------------------------------------

Line 190: RAISE FND_API.G_EXC_ERROR ;

186: --------------------------------------------
187: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
189: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
190: RAISE FND_API.G_EXC_ERROR ;
191: END IF;
192: --------------------------------------------
193:
194: IF P_RELEASE_LOCKS_YN = 'Y' THEN

Line 204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

200: X_MSG_DATA => X_MSG_DATA
201: );
202: --------------------------------------------
203: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
205: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
206: RAISE FND_API.G_EXC_ERROR ;
207: END IF;
208: --------------------------------------------

Line 206: RAISE FND_API.G_EXC_ERROR ;

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

Line 211: IF FND_API.To_Boolean( p_commit ) THEN

207: END IF;
208: --------------------------------------------
209: END IF;
210:
211: IF FND_API.To_Boolean( p_commit ) THEN
212: COMMIT WORK;
213: END IF;
214: -- Standard call to get message count and if count is 1, get message info.
215: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 221: WHEN FND_API.G_EXC_ERROR THEN

217: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1300: Leaving Delete_Doc');
218: END IF;
219:
220: EXCEPTION
221: WHEN FND_API.G_EXC_ERROR THEN
222: ROLLBACK TO g_Delete_Doc;
223: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
224: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1400: Leaving Delete_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
225: END IF;

Line 229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

225: END IF;
226: x_return_status := G_RET_STS_ERROR ;
227: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
228:
229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
230: ROLLBACK TO g_Delete_Doc;
231: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1500: Leaving Delete_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
233: END IF;

Line 258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

254: */
255:
256: PROCEDURE Purge_Doc (
257: p_api_version IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_commit IN VARCHAR2 := FND_API.G_FALSE,
260:
261: x_return_status OUT NOCOPY VARCHAR2,
262: x_msg_data OUT NOCOPY VARCHAR2,

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

255:
256: PROCEDURE Purge_Doc (
257: p_api_version IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_commit IN VARCHAR2 := FND_API.G_FALSE,
260:
261: x_return_status OUT NOCOPY VARCHAR2,
262: x_msg_data OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,

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

278: END IF;
279: -- Standard Start of API savepoint
280: SAVEPOINT g_Purge_Doc;
281: -- Standard call to check for call compatibility.
282: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285: -- Initialize message list if p_init_msg_list is set to TRUE.
286: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

279: -- Standard Start of API savepoint
280: SAVEPOINT g_Purge_Doc;
281: -- Standard call to check for call compatibility.
282: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285: -- Initialize message list if p_init_msg_list is set to TRUE.
286: IF FND_API.to_Boolean( p_init_msg_list ) THEN
287: FND_MSG_PUB.initialize;

Line 286: IF FND_API.to_Boolean( p_init_msg_list ) THEN

282: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285: -- Initialize message list if p_init_msg_list is set to TRUE.
286: IF FND_API.to_Boolean( p_init_msg_list ) THEN
287: FND_MSG_PUB.initialize;
288: END IF;
289: -- Initialize API return status to success
290: x_return_status := G_RET_STS_SUCCESS;

Line 406: p_init_msg_list => FND_API.G_FALSE,

402: END IF;
403:
404: OKC_DELIVERABLE_PROCESS_PVT.Purge_Doc_Deliverables(
405: p_api_version => l_api_version,
406: p_init_msg_list => FND_API.G_FALSE,
407: p_doc_table => p_doc_tbl,
408: x_msg_data => x_msg_data,
409: x_msg_count => x_msg_count,
410: x_return_status => x_return_status

Line 414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

410: x_return_status => x_return_status
411: );
412: --------------------------------------------
413: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
415: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
416: RAISE FND_API.G_EXC_ERROR ;
417: END IF;
418: --------------------------------------------

Line 416: RAISE FND_API.G_EXC_ERROR ;

412: --------------------------------------------
413: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
415: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
416: RAISE FND_API.G_EXC_ERROR ;
417: END IF;
418: --------------------------------------------
419: -- Call attachement API to delete attachements from the document.
420: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 428: p_init_msg_list => FND_API.G_FALSE,

424: FOR i in p_doc_tbl.FIRST..p_doc_tbl.LAST LOOP
425:
426: OKC_CONTRACT_DOCS_GRP.Delete_doc_Attachments(
427: p_api_version => l_api_version,
428: p_init_msg_list => FND_API.G_FALSE,
429: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
430: p_commit => FND_API.G_FALSE,
431: p_business_document_type => p_doc_tbl(i).doc_type,
432: p_business_document_id => p_doc_tbl(i).doc_id,

Line 429: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,

425:
426: OKC_CONTRACT_DOCS_GRP.Delete_doc_Attachments(
427: p_api_version => l_api_version,
428: p_init_msg_list => FND_API.G_FALSE,
429: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
430: p_commit => FND_API.G_FALSE,
431: p_business_document_type => p_doc_tbl(i).doc_type,
432: p_business_document_id => p_doc_tbl(i).doc_id,
433: x_msg_data => x_msg_data,

Line 430: p_commit => FND_API.G_FALSE,

426: OKC_CONTRACT_DOCS_GRP.Delete_doc_Attachments(
427: p_api_version => l_api_version,
428: p_init_msg_list => FND_API.G_FALSE,
429: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
430: p_commit => FND_API.G_FALSE,
431: p_business_document_type => p_doc_tbl(i).doc_type,
432: p_business_document_id => p_doc_tbl(i).doc_id,
433: x_msg_data => x_msg_data,
434: x_msg_count => x_msg_count,

Line 439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

435: x_return_status => x_return_status
436: );
437: --------------------------------------------
438: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
440: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
441: RAISE FND_API.G_EXC_ERROR ;
442: END IF;
443: END LOOP;

Line 441: RAISE FND_API.G_EXC_ERROR ;

437: --------------------------------------------
438: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
440: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
441: RAISE FND_API.G_EXC_ERROR ;
442: END IF;
443: END LOOP;
444: END IF;
445:

Line 446: IF FND_API.To_Boolean( p_commit ) THEN

442: END IF;
443: END LOOP;
444: END IF;
445:
446: IF FND_API.To_Boolean( p_commit ) THEN
447: COMMIT WORK;
448: END IF;
449:
450: -- Standard call to get message count and if count is 1, get message info.

Line 457: WHEN FND_API.G_EXC_ERROR THEN

453: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2100: Leaving Purge_Doc');
454: END IF;
455:
456: EXCEPTION
457: WHEN FND_API.G_EXC_ERROR THEN
458: ROLLBACK TO g_Purge_Doc;
459: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
460: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2200: Leaving Purge_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
461: END IF;

Line 465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

461: END IF;
462: x_return_status := G_RET_STS_ERROR ;
463: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: ROLLBACK TO g_Purge_Doc;
467: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
468: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2300: Leaving Purge_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
469: END IF;

Line 493: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

489: -- variables used in article has been changed in source document during amendment.
490: */
491: PROCEDURE Mark_Variable_Based_Amendment (
492: p_api_version IN NUMBER,
493: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
494: p_commit IN VARCHAR2 := FND_API.G_FALSE,
495:
496: x_return_status OUT NOCOPY VARCHAR2,
497: x_msg_data OUT NOCOPY VARCHAR2,

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

490: */
491: PROCEDURE Mark_Variable_Based_Amendment (
492: p_api_version IN NUMBER,
493: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
494: p_commit IN VARCHAR2 := FND_API.G_FALSE,
495:
496: x_return_status OUT NOCOPY VARCHAR2,
497: x_msg_data OUT NOCOPY VARCHAR2,
498: x_msg_count OUT NOCOPY NUMBER,

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

526: END IF;
527: -- Standard Start of API savepoint
528: SAVEPOINT g_Get_System_Variables;
529: -- Standard call to check for call compatibility.
530: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533: -- Initialize message list if p_init_msg_list is set to TRUE.
534: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

527: -- Standard Start of API savepoint
528: SAVEPOINT g_Get_System_Variables;
529: -- Standard call to check for call compatibility.
530: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533: -- Initialize message list if p_init_msg_list is set to TRUE.
534: IF FND_API.to_Boolean( p_init_msg_list ) THEN
535: FND_MSG_PUB.initialize;

Line 534: IF FND_API.to_Boolean( p_init_msg_list ) THEN

530: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533: -- Initialize message list if p_init_msg_list is set to TRUE.
534: IF FND_API.to_Boolean( p_init_msg_list ) THEN
535: FND_MSG_PUB.initialize;
536: END IF;
537: -- Initialize API return status to success
538: x_return_status := G_RET_STS_SUCCESS;

Line 574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

570: p_sys_var_tbl => l_var_codes_tbl );
571:
572: --------------------------------------------
573: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
575: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
576: RAISE FND_API.G_EXC_ERROR ;
577: END IF;
578: --------------------------------------------

Line 576: RAISE FND_API.G_EXC_ERROR ;

572: --------------------------------------------
573: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
575: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
576: RAISE FND_API.G_EXC_ERROR ;
577: END IF;
578: --------------------------------------------
579: ELSIF l_doc_class = 'SOURCING' THEN
580:

Line 609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

605:
606:
607: --------------------------------------------
608: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
610: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
611: RAISE FND_API.G_EXC_ERROR ;
612: END IF;
613: --------------------------------------------

Line 611: RAISE FND_API.G_EXC_ERROR ;

607: --------------------------------------------
608: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
610: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
611: RAISE FND_API.G_EXC_ERROR ;
612: END IF;
613: --------------------------------------------
614: ELSE
615: NULL;

Line 639: p_init_msg_list => FND_API.G_FALSE,

635: END IF;
636:
637: OKC_TERMS_UTIL_PVT.Mark_Amendment(
638: p_api_version => l_api_version,
639: p_init_msg_list => FND_API.G_FALSE,
640: x_return_status => x_return_status,
641: x_msg_data => x_msg_data,
642: x_msg_count => x_msg_count,
643: p_doc_type => p_doc_type,

Line 655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

651: END IF;
652:
653: --------------------------------------------
654: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
656: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
657: RAISE FND_API.G_EXC_ERROR ;
658: END IF;
659: --------------------------------------------

Line 657: RAISE FND_API.G_EXC_ERROR ;

653: --------------------------------------------
654: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
656: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
657: RAISE FND_API.G_EXC_ERROR ;
658: END IF;
659: --------------------------------------------
660:
661: i := l_var_codes_tbl.NEXT(i);

Line 673: WHEN FND_API.G_EXC_ERROR THEN

669: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2700: Leaving Mark_Variable_Based_Amendment');
670: END IF;
671:
672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: ROLLBACK TO g_Get_System_Variables;
675: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
676: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2800: Leaving Mark_Variable_Based_Amendment : OKC_API.G_EXCEPTION_ERROR Exception');
677: END IF;

Line 681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

677: END IF;
678: x_return_status := G_RET_STS_ERROR ;
679: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
680:
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: ROLLBACK TO g_Get_System_Variables;
683: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
684: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2900: Leaving Mark_Variable_Based_Amendment : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
685: END IF;

Line 710: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

706: */
707:
708: FUNCTION Is_Article_Exist(
709: p_api_version IN NUMBER,
710: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
711:
712: x_return_status OUT NOCOPY VARCHAR2,
713: x_msg_data OUT NOCOPY VARCHAR2,
714: x_msg_count OUT NOCOPY NUMBER,

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

734: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
735: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3100: Entered Is_Article_exist');
736: END IF;
737: -- Standard call to check for call compatibility.
738: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END IF;
741: -- Initialize message list if p_init_msg_list is set to TRUE.
742: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

735: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3100: Entered Is_Article_exist');
736: END IF;
737: -- Standard call to check for call compatibility.
738: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END IF;
741: -- Initialize message list if p_init_msg_list is set to TRUE.
742: IF FND_API.to_Boolean( p_init_msg_list ) THEN
743: FND_MSG_PUB.initialize;

Line 742: IF FND_API.to_Boolean( p_init_msg_list ) THEN

738: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END IF;
741: -- Initialize message list if p_init_msg_list is set to TRUE.
742: IF FND_API.to_Boolean( p_init_msg_list ) THEN
743: FND_MSG_PUB.initialize;
744: END IF;
745: -- Initialize API return status to success
746: x_return_status := G_RET_STS_SUCCESS;

Line 770: WHEN FND_API.G_EXC_ERROR THEN

766: END IF;
767: RETURN l_return_value ;
768:
769: EXCEPTION
770: WHEN FND_API.G_EXC_ERROR THEN
771: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
772: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3400: Leaving Is_Article_exist : OKC_API.G_EXCEPTION_ERROR Exception');
773: END IF;
774: x_return_status := G_RET_STS_ERROR ;

Line 776: RETURN FND_API.G_FALSE ;

772: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3400: Leaving Is_Article_exist : OKC_API.G_EXCEPTION_ERROR Exception');
773: END IF;
774: x_return_status := G_RET_STS_ERROR ;
775: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
776: RETURN FND_API.G_FALSE ;
777:
778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
779: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
780: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3500: Leaving Is_Article_exist : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

Line 778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

774: x_return_status := G_RET_STS_ERROR ;
775: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
776: RETURN FND_API.G_FALSE ;
777:
778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
779: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
780: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3500: Leaving Is_Article_exist : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
781: END IF;
782: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 784: RETURN FND_API.G_FALSE ;

780: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3500: Leaving Is_Article_exist : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
781: END IF;
782: x_return_status := G_RET_STS_UNEXP_ERROR ;
783: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
784: RETURN FND_API.G_FALSE ;
785:
786: WHEN OTHERS THEN
787: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
788: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3600: Leaving Is_Article_exist because of EXCEPTION: '||sqlerrm);

Line 799: RETURN FND_API.G_FALSE ;

795: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
796: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
797: END IF;
798: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
799: RETURN FND_API.G_FALSE ;
800: END Is_Article_exist ;
801:
802: FUNCTION Is_Article_Exist(
803:

Line 814: p_init_msg_list => FND_API.G_FALSE,

810: l_msg_count NUMBER;
811: l_return_value Varchar2(30);
812: BEGIN
813: l_return_value:=Is_Article_Exist(P_api_version => 1,
814: p_init_msg_list => FND_API.G_FALSE,
815: p_doc_type => p_doc_type,
816: p_doc_id => p_doc_id,
817: x_return_status => l_return_status,
818: x_msg_data => l_msg_data,

Line 923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

919: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3654: l_msg_count : '||l_msg_count);
920: END IF;
921:
922: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
924: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
925: RAISE FND_API.G_EXC_ERROR ;
926: END IF;
927: --11.5.10+ code changes for COntract Repository end

Line 925: RAISE FND_API.G_EXC_ERROR ;

921:
922: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
924: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
925: RAISE FND_API.G_EXC_ERROR ;
926: END IF;
927: --11.5.10+ code changes for COntract Repository end
928:
929: ELSE

Line 962: p_init_msg_list => FND_API.G_FALSE,

958: l_return_value Varchar2(30);
959: BEGIN
960:
961: l_return_value:=Deviation_From_Standard(p_api_version => 1,
962: p_init_msg_list => FND_API.G_FALSE,
963: p_doc_type => p_doc_type,
964: p_doc_id => p_doc_id,
965: x_return_status => l_return_status,
966: x_msg_data => l_msg_data,

Line 983: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

979: -- ARTICLES_AND_DELIVERABLES_CHANGED
980: */
981: FUNCTION Deviation_From_Standard(
982: p_api_version IN NUMBER,
983: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
984:
985: x_return_status OUT NOCOPY VARCHAR2,
986: x_msg_data OUT NOCOPY VARCHAR2,
987: x_msg_count OUT NOCOPY NUMBER,

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

1016: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1017: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3700: Entered Deviation_From_Standard');
1018: END IF;
1019: -- Standard call to check for call compatibility.
1020: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: END IF;
1023: -- Initialize message list if p_init_msg_list is set to TRUE.
1024: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1017: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3700: Entered Deviation_From_Standard');
1018: END IF;
1019: -- Standard call to check for call compatibility.
1020: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: END IF;
1023: -- Initialize message list if p_init_msg_list is set to TRUE.
1024: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1025: FND_MSG_PUB.initialize;

Line 1024: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1020: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: END IF;
1023: -- Initialize message list if p_init_msg_list is set to TRUE.
1024: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1025: FND_MSG_PUB.initialize;
1026: END IF;
1027: -- Initialize API return status to success
1028: x_return_status := G_RET_STS_SUCCESS;

Line 1056: WHEN FND_API.G_EXC_ERROR THEN

1052: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3900: Leaving Deviation_From_Standard');
1053: END IF;
1054: RETURN l_return_value ;
1055: EXCEPTION
1056: WHEN FND_API.G_EXC_ERROR THEN
1057: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1058: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4000: Leaving Deviation_From_Standard : OKC_API.G_EXCEPTION_ERROR Exception');
1059: END IF;
1060: x_return_status := G_RET_STS_ERROR ;

Line 1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1060: x_return_status := G_RET_STS_ERROR ;
1061: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1062: RETURN NULL ;
1063:
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1066: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4100: Leaving Deviation_From_Standard : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1067: END IF;
1068: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1091: -- FND_API.G_TRUE = Template expired

1087:
1088: /*
1089: --To be used to find out if template used in document has expired.Possible return values Y,N.
1090: -- Possible return values are
1091: -- FND_API.G_TRUE = Template expired
1092: -- FND_API.G_FALSE = Template not expired.
1093: */
1094: FUNCTION Is_Template_Expired(
1095: p_api_version IN NUMBER,

Line 1092: -- FND_API.G_FALSE = Template not expired.

1088: /*
1089: --To be used to find out if template used in document has expired.Possible return values Y,N.
1090: -- Possible return values are
1091: -- FND_API.G_TRUE = Template expired
1092: -- FND_API.G_FALSE = Template not expired.
1093: */
1094: FUNCTION Is_Template_Expired(
1095: p_api_version IN NUMBER,
1096: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 1096: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1092: -- FND_API.G_FALSE = Template not expired.
1093: */
1094: FUNCTION Is_Template_Expired(
1095: p_api_version IN NUMBER,
1096: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1097:
1098: x_return_status OUT NOCOPY VARCHAR2,
1099: x_msg_data OUT NOCOPY VARCHAR2,
1100: x_msg_count OUT NOCOPY NUMBER,

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

1122: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4300: Entered Is_Template_Expired');
1123: END IF;
1124:
1125: -- Standard call to check for call compatibility.
1126: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1128: END IF;
1129:
1130: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1123: END IF;
1124:
1125: -- Standard call to check for call compatibility.
1126: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1128: END IF;
1129:
1130: -- Initialize message list if p_init_msg_list is set to TRUE.
1131: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1131: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1128: END IF;
1129:
1130: -- Initialize message list if p_init_msg_list is set to TRUE.
1131: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1132: FND_MSG_PUB.initialize;
1133: END IF;
1134:
1135: -- Initialize API return status to success

Line 1157: WHEN FND_API.G_EXC_ERROR THEN

1153:
1154: RETURN l_return_value ;
1155:
1156: EXCEPTION
1157: WHEN FND_API.G_EXC_ERROR THEN
1158: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1159: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4700: Leaving Is_Template_Expired : OKC_API.G_EXCEPTION_ERROR Exception');
1160: END IF;
1161:

Line 1166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1162: x_return_status := G_RET_STS_ERROR ;
1163: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1164: RETURN NULL ;
1165:
1166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1167: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1168: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4800: Leaving Is_Template_Expired : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1169: END IF;
1170:

Line 1202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1198:
1199:
1200: FUNCTION Is_Deliverable_Exist(
1201: p_api_version IN NUMBER,
1202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1203:
1204: x_return_status OUT NOCOPY VARCHAR2,
1205: x_msg_data OUT NOCOPY VARCHAR2,
1206: x_msg_count OUT NOCOPY NUMBER,

Line 1257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1253: */
1254:
1255: FUNCTION Is_Article_Amended(
1256: p_api_version IN NUMBER,
1257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1258:
1259: x_return_status OUT NOCOPY VARCHAR2,
1260: x_msg_data OUT NOCOPY VARCHAR2,
1261: x_msg_count OUT NOCOPY NUMBER,

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

1279: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1280: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5700: Entered Is_Article_AMENDED');
1281: END IF;
1282: -- Standard call to check for call compatibility.
1283: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285: END IF;
1286: -- Initialize message list if p_init_msg_list is set to TRUE.
1287: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1280: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5700: Entered Is_Article_AMENDED');
1281: END IF;
1282: -- Standard call to check for call compatibility.
1283: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285: END IF;
1286: -- Initialize message list if p_init_msg_list is set to TRUE.
1287: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1288: FND_MSG_PUB.initialize;

Line 1287: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1283: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285: END IF;
1286: -- Initialize message list if p_init_msg_list is set to TRUE.
1287: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1288: FND_MSG_PUB.initialize;
1289: END IF;
1290: -- Initialize API return status to success
1291: x_return_status := G_RET_STS_SUCCESS;

Line 1315: WHEN FND_API.G_EXC_ERROR THEN

1311:
1312: RETURN l_return_value ;
1313:
1314: EXCEPTION
1315: WHEN FND_API.G_EXC_ERROR THEN
1316: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1317: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6000: Leaving Is_Article_AMENDED : OKC_API.G_EXCEPTION_ERROR Exception');
1318: END IF;
1319: x_return_status := G_RET_STS_ERROR ;

Line 1323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1319: x_return_status := G_RET_STS_ERROR ;
1320: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1321: RETURN NULL ;
1322:
1323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1324:
1325: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1326: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6100: Leaving Is_Article_AMENDED : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1327: END IF;

Line 1359: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1355: */
1356:
1357: FUNCTION Is_Deliverable_Amended(
1358: p_api_version IN NUMBER,
1359: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1360:
1361: x_return_status OUT NOCOPY VARCHAR2,
1362: x_msg_data OUT NOCOPY VARCHAR2,
1363: x_msg_count OUT NOCOPY NUMBER,

Line 1404: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1400:
1401: --This API is deprecated. Use GET_CONTRACT_DETAILS() instead.
1402: PROCEDURE Get_Terms_Template(
1403: p_api_version IN NUMBER,
1404: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1405:
1406: x_return_status OUT NOCOPY VARCHAR2,
1407: x_msg_data OUT NOCOPY VARCHAR2,
1408: x_msg_count OUT NOCOPY NUMBER,

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

1430: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6900: Entered Get_Terms_Template');
1431: END IF;
1432:
1433: -- Standard call to check for call compatibility.
1434: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1436: END IF;
1437:
1438: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1431: END IF;
1432:
1433: -- Standard call to check for call compatibility.
1434: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1436: END IF;
1437:
1438: -- Initialize message list if p_init_msg_list is set to TRUE.
1439: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1439: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1436: END IF;
1437:
1438: -- Initialize message list if p_init_msg_list is set to TRUE.
1439: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1440: FND_MSG_PUB.initialize;
1441: END IF;
1442:
1443: -- Initialize API return status to success

Line 1459: WHEN FND_API.G_EXC_ERROR THEN

1455: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7100: Leaving Get_Terms_Template');
1456: END IF;
1457:
1458: EXCEPTION
1459: WHEN FND_API.G_EXC_ERROR THEN
1460:
1461: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1462: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7200: Leaving Get_Terms_Template : OKC_API.G_EXCEPTION_ERROR Exception');
1463: END IF;

Line 1468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1464:
1465: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1466: x_return_status := G_RET_STS_ERROR ;
1467:
1468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1469: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7300: Leaving Get_Terms_Template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1471: END IF;
1472:

Line 1497: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1493: -- To be used to find out document type when document is of contract family.
1494: */
1495: FUNCTION Get_Contract_Document_Type(
1496: p_api_version IN NUMBER,
1497: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1498:
1499: x_return_status OUT NOCOPY VARCHAR2,
1500: x_msg_data OUT NOCOPY VARCHAR2,
1501: x_msg_count OUT NOCOPY NUMBER,

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

1514: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1515: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Get_Contract_Document_Type');
1516: END IF;
1517: -- Standard call to check for call compatibility.
1518: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1520: END IF;
1521: -- Initialize message list if p_init_msg_list is set to TRUE.
1522: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1515: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Get_Contract_Document_Type');
1516: END IF;
1517: -- Standard call to check for call compatibility.
1518: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1520: END IF;
1521: -- Initialize message list if p_init_msg_list is set to TRUE.
1522: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1523: FND_MSG_PUB.initialize;

Line 1522: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1518: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1520: END IF;
1521: -- Initialize message list if p_init_msg_list is set to TRUE.
1522: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1523: FND_MSG_PUB.initialize;
1524: END IF;
1525: -- Initialize API return status to success
1526: x_return_status := G_RET_STS_SUCCESS;

Line 1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1529: FETCH find_chrtype_crs INTO l_return_value;
1530: CLOSE find_chrtype_crs;
1531:
1532: IF l_return_value IS NULL THEN
1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1534: END IF;
1535:
1536: -- Standard call to get message count and if count is 1, get message info.
1537: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1544: WHEN FND_API.G_EXC_ERROR THEN

1540: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving Get_Contract_Document_Type');
1541: END IF;
1542: RETURN l_return_value ;
1543: EXCEPTION
1544: WHEN FND_API.G_EXC_ERROR THEN
1545: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1546: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Get_Contract_Document_Type : OKC_API.G_EXCEPTION_ERROR Exception');
1547: END IF;
1548: x_return_status := G_RET_STS_ERROR ;

Line 1552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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: RETURN NULL ;
1551:
1552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1553: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1554: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Get_Contract_Document_Type : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1555: END IF;
1556: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1576: -- To be used to find out document type/ID when document is of contract family.
1577: */
1578: PROCEDURE Get_Contract_Document_Type_ID(
1579: p_api_version IN NUMBER,
1580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1581:
1582: x_return_status OUT NOCOPY VARCHAR2,
1583: x_msg_data OUT NOCOPY VARCHAR2,
1584: x_msg_count OUT NOCOPY NUMBER,

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

1603: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1604: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8100: Entered Get_Contract_Document_Type_id');
1605: END IF;
1606: -- Standard call to check for call compatibility.
1607: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1609: END IF;
1610: -- Initialize message list if p_init_msg_list is set to TRUE.
1611: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1604: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8100: Entered Get_Contract_Document_Type_id');
1605: END IF;
1606: -- Standard call to check for call compatibility.
1607: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1609: END IF;
1610: -- Initialize message list if p_init_msg_list is set to TRUE.
1611: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1612: FND_MSG_PUB.initialize;

Line 1611: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1607: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1609: END IF;
1610: -- Initialize message list if p_init_msg_list is set to TRUE.
1611: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1612: FND_MSG_PUB.initialize;
1613: END IF;
1614: -- Initialize API return status to success
1615: x_return_status := G_RET_STS_SUCCESS;

Line 1623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1619: l_notfound := find_chrtype_crs%NOTFOUND;
1620: CLOSE find_chrtype_crs;
1621:
1622: IF l_notfound THEN
1623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1624: END IF;
1625:
1626: -- Standard call to get message count and if count is 1, get message info.
1627: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1634: WHEN FND_API.G_EXC_ERROR THEN

1630: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8300: Result Document_ID : ['||x_doc_id||']');
1631: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8400: Leaving Get_Contract_Document_Type');
1632: END IF;
1633: EXCEPTION
1634: WHEN FND_API.G_EXC_ERROR THEN
1635: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1636: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8500: Leaving Get_Contract_Document_Type_id : OKC_API.G_EXCEPTION_ERROR Exception');
1637: END IF;
1638: x_return_status := G_RET_STS_ERROR ;

Line 1641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1637: END IF;
1638: x_return_status := G_RET_STS_ERROR ;
1639: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1640:
1641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1642: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1643: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8600: Leaving Get_Contract_Document_Type_id : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1644: END IF;
1645: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1667: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1663: -- To be used to find out document type when document is of contract family.
1664: */
1665: PROCEDURE Get_Last_Update_Date (
1666: p_api_version IN NUMBER,
1667: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1668:
1669: x_return_status OUT NOCOPY VARCHAR2,
1670: x_msg_data OUT NOCOPY VARCHAR2,
1671: x_msg_count OUT NOCOPY NUMBER,

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

1731: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9300: p_doc_id : '||p_doc_id);
1732: END IF;
1733:
1734: -- Standard call to check for call compatibility.
1735: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name , G_PKG_NAME) THEN
1736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1737: END IF;
1738:
1739: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1732: END IF;
1733:
1734: -- Standard call to check for call compatibility.
1735: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name , G_PKG_NAME) THEN
1736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1737: END IF;
1738:
1739: -- Initialize message list if p_init_msg_list is set to TRUE.
1740: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1740: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1737: END IF;
1738:
1739: -- Initialize message list if p_init_msg_list is set to TRUE.
1740: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1741: FND_MSG_PUB.initialize;
1742: END IF;
1743: -- Initialize API return status to success
1744: x_return_status := G_RET_STS_SUCCESS;

Line 1825: WHEN FND_API.G_EXC_ERROR THEN

1821: END IF;
1822:
1823:
1824: EXCEPTION
1825: WHEN FND_API.G_EXC_ERROR THEN
1826: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1827: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'10100: Leaving get_last_update_date : OKC_API.G_EXCEPTION_ERROR Exception');
1828: END IF;
1829:

Line 1837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1833:
1834: x_return_status := G_RET_STS_ERROR ;
1835: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1836:
1837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1838: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1839: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'10200: Leaving get_last_update_date : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1840: END IF;
1841:

Line 1868: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1864: END get_last_update_date;
1865:
1866: FUNCTION Ok_To_Commit (
1867: p_api_version IN NUMBER,
1868: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1869:
1870: x_return_status OUT NOCOPY VARCHAR2,
1871: x_msg_data OUT NOCOPY VARCHAR2,
1872: x_msg_count OUT NOCOPY NUMBER,

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

1905: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11100: p_doc_id : '||p_doc_id);
1906: END IF;
1907:
1908: -- Standard call to check for call compatibility.
1909: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1911: END IF;
1912:
1913: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1906: END IF;
1907:
1908: -- Standard call to check for call compatibility.
1909: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1911: END IF;
1912:
1913: -- Initialize message list if p_init_msg_list is set to TRUE.
1914: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1914: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1911: END IF;
1912:
1913: -- Initialize message list if p_init_msg_list is set to TRUE.
1914: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1915: FND_MSG_PUB.initialize;
1916: END IF;
1917:
1918: IF p_doc_type = G_TMPL_DOC_TYPE THEN

Line 1966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1962: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11700: x_msg_count : '||x_msg_count);
1963: END IF;
1964:
1965: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1967: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1968: RAISE FND_API.G_EXC_ERROR ;
1969: END IF;
1970:

Line 1968: RAISE FND_API.G_EXC_ERROR ;

1964:
1965: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1967: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1968: RAISE FND_API.G_EXC_ERROR ;
1969: END IF;
1970:
1971: ELSIF l_doc_class = 'SOURCING' THEN
1972:

Line 1996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1992: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12200: x_msg_count : '||x_msg_count);
1993: END IF;
1994:
1995: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1997: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1998: RAISE FND_API.G_EXC_ERROR ;
1999: END IF;
2000:

Line 1998: RAISE FND_API.G_EXC_ERROR ;

1994:
1995: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1997: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1998: RAISE FND_API.G_EXC_ERROR ;
1999: END IF;
2000:
2001: ELSIF l_doc_class in ('BSA','SO') THEN
2002: -- ELSIF l_doc_class = 'OM' THEN

Line 2027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2023: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12700: x_msg_count : '||x_msg_count);
2024: END IF;
2025:
2026: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2028: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2029: RAISE FND_API.G_EXC_ERROR ;
2030: END IF;
2031:

Line 2029: RAISE FND_API.G_EXC_ERROR ;

2025:
2026: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2028: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2029: RAISE FND_API.G_EXC_ERROR ;
2030: END IF;
2031:
2032: ELSIF l_doc_class = 'OKS' THEN
2033:

Line 2056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2052: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13200: x_msg_count : '||x_msg_count);
2053: END IF;
2054:
2055: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2057: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2058: RAISE FND_API.G_EXC_ERROR ;
2059: END IF;
2060: --

Line 2058: RAISE FND_API.G_EXC_ERROR ;

2054:
2055: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2057: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2058: RAISE FND_API.G_EXC_ERROR ;
2059: END IF;
2060: --
2061: ELSIF l_doc_class = 'QUOTE' THEN
2062:

Line 2086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2082: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13700: x_msg_count : '||x_msg_count);
2083: END IF;
2084:
2085: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2087: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2088: RAISE FND_API.G_EXC_ERROR ;
2089: END IF;
2090:

Line 2088: RAISE FND_API.G_EXC_ERROR ;

2084:
2085: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2087: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2088: RAISE FND_API.G_EXC_ERROR ;
2089: END IF;
2090:
2091: --
2092:

Line 2116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2112: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14200: x_msg_count : '||x_msg_count);
2113: END IF;
2114:
2115: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2117: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2118: RAISE FND_API.G_EXC_ERROR ;
2119: END IF;
2120:

Line 2118: RAISE FND_API.G_EXC_ERROR ;

2114:
2115: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2117: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2118: RAISE FND_API.G_EXC_ERROR ;
2119: END IF;
2120:
2121: ELSE
2122: l_ok_to_commit := G_TRUE;

Line 2129: IF l_ok_to_commit=FND_API.G_FALSE THEN

2125: l_ok_to_commit := G_TRUE;
2126: END IF;
2127: END IF;
2128:
2129: IF l_ok_to_commit=FND_API.G_FALSE THEN
2130:
2131: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2132: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13800: Issue with document header Record.Cannot commit');
2133: END IF;

Line 2142: WHEN FND_API.G_EXC_ERROR THEN

2138:
2139: RETURN l_ok_to_commit;
2140:
2141: EXCEPTION
2142: WHEN FND_API.G_EXC_ERROR THEN
2143: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2144: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'13900: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception');
2145: END IF;
2146: x_return_status := G_RET_STS_ERROR ;

Line 2148: RETURN FND_API.G_FALSE;

2144: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'13900: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception');
2145: END IF;
2146: x_return_status := G_RET_STS_ERROR ;
2147: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2148: RETURN FND_API.G_FALSE;
2149:
2150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2151: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2152: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'14000: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

Line 2150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2146: x_return_status := G_RET_STS_ERROR ;
2147: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2148: RETURN FND_API.G_FALSE;
2149:
2150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2151: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2152: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'14000: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2153: END IF;
2154: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2156: RETURN FND_API.G_FALSE;

2152: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'14000: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2153: END IF;
2154: x_return_status := G_RET_STS_UNEXP_ERROR ;
2155: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2156: RETURN FND_API.G_FALSE;
2157:
2158: WHEN OTHERS THEN
2159: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2160: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'14100: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm);

Line 2168: RETURN FND_API.G_FALSE;

2164: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2165: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2166: END IF;
2167: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2168: RETURN FND_API.G_FALSE;
2169:
2170: END ok_to_commit;
2171:
2172: /*

Line 2174: Returns FND_API.G_TRUE => If atleast 1 article is manually added.

2170: END ok_to_commit;
2171:
2172: /*
2173: --To be used to find out if a document has any manually added articles.
2174: Returns FND_API.G_TRUE => If atleast 1 article is manually added.
2175: FND_API.G_FALSE => If no manually added article exists.
2176: */
2177:
2178: FUNCTION is_manual_article_exist(

Line 2175: FND_API.G_FALSE => If no manually added article exists.

2171:
2172: /*
2173: --To be used to find out if a document has any manually added articles.
2174: Returns FND_API.G_TRUE => If atleast 1 article is manually added.
2175: FND_API.G_FALSE => If no manually added article exists.
2176: */
2177:
2178: FUNCTION is_manual_article_exist(
2179: p_api_version IN NUMBER,

Line 2180: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2176: */
2177:
2178: FUNCTION is_manual_article_exist(
2179: p_api_version IN NUMBER,
2180: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2181:
2182: x_return_status OUT NOCOPY VARCHAR2,
2183: x_msg_data OUT NOCOPY VARCHAR2,
2184: x_msg_count OUT NOCOPY NUMBER,

Line 2192: l_return_value VARCHAR2(1) := FND_API.G_FALSE;

2188: ) RETURN VARCHAR2 IS
2189: l_api_version CONSTANT NUMBER := 1;
2190: l_api_name CONSTANT VARCHAR2(30) := 'is_manual_article_exist';
2191: l_dummy VARCHAR2(1) := '?';
2192: l_return_value VARCHAR2(1) := FND_API.G_FALSE;
2193:
2194: CURSOR find_art_crs IS
2195: SELECT '!'
2196: FROM okc_k_articles_b kart

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

2204: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2205: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14200: Entered is_manual_article_exist');
2206: END IF;
2207: -- Standard call to check for call compatibility.
2208: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2210: END IF;
2211: -- Initialize message list if p_init_msg_list is set to TRUE.
2212: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2205: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14200: Entered is_manual_article_exist');
2206: END IF;
2207: -- Standard call to check for call compatibility.
2208: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2210: END IF;
2211: -- Initialize message list if p_init_msg_list is set to TRUE.
2212: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2213: FND_MSG_PUB.initialize;

Line 2212: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2208: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2210: END IF;
2211: -- Initialize message list if p_init_msg_list is set to TRUE.
2212: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2213: FND_MSG_PUB.initialize;
2214: END IF;
2215: -- Initialize API return status to success
2216: x_return_status := G_RET_STS_SUCCESS;

Line 2223: l_return_value := FND_API.G_FALSE;

2219: FETCH find_art_crs INTO l_dummy;
2220: CLOSE find_art_crs;
2221:
2222: IF l_dummy='?' THEN
2223: l_return_value := FND_API.G_FALSE;
2224: ELSE
2225: l_return_value := FND_API.G_TRUE;
2226: END IF;
2227:

Line 2225: l_return_value := FND_API.G_TRUE;

2221:
2222: IF l_dummy='?' THEN
2223: l_return_value := FND_API.G_FALSE;
2224: ELSE
2225: l_return_value := FND_API.G_TRUE;
2226: END IF;
2227:
2228: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2229: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14300: Leaving is_manual_article_exist');

Line 2237: WHEN FND_API.G_EXC_ERROR THEN

2233: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2234: RETURN l_return_value ;
2235:
2236: EXCEPTION
2237: WHEN FND_API.G_EXC_ERROR THEN
2238: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2239: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'14400: Leaving is_manual_article_exist : OKC_API.G_EXCEPTION_ERROR Exception');
2240: END IF;
2241: x_return_status := G_RET_STS_ERROR ;

Line 2245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2241: x_return_status := G_RET_STS_ERROR ;
2242: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2243: RETURN NULL ;
2244:
2245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2246: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2247: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'14500: Leaving is_manual_article_exist : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2248: END IF;
2249: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2272: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2268:
2269:
2270: FUNCTION Get_Template_Name(
2271: p_api_version IN NUMBER,
2272: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2273: p_template_id IN NUMBER,
2274:
2275: x_return_status OUT NOCOPY VARCHAR2,
2276: x_msg_data OUT NOCOPY VARCHAR2,

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

2290: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14700: Get_Template_Name');
2291: END IF;
2292:
2293: -- Standard call to check for call compatibility.
2294: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2296: END IF;
2297:
2298: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2291: END IF;
2292:
2293: -- Standard call to check for call compatibility.
2294: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2296: END IF;
2297:
2298: -- Initialize message list if p_init_msg_list is set to TRUE.
2299: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2299: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2296: END IF;
2297:
2298: -- Initialize message list if p_init_msg_list is set to TRUE.
2299: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2300: FND_MSG_PUB.initialize;
2301: END IF;
2302:
2303: -- Initialize API return status to success

Line 2330: WHEN FND_API.G_EXC_ERROR THEN

2326:
2327: RETURN l_return_value ;
2328:
2329: EXCEPTION
2330: WHEN FND_API.G_EXC_ERROR THEN
2331: IF c_get_template_name%ISOPEN THEN
2332: CLOSE c_get_template_name;
2333: END IF;
2334: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2337: x_return_status := G_RET_STS_ERROR ;
2338: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2339: RETURN NULL ;
2340:
2341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2342: IF c_get_template_name%ISOPEN THEN
2343: CLOSE c_get_template_name;
2344: END IF;
2345: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2383: p_init_msg_list => FND_API.G_FALSE,

2379: l_msg_count NUMBER;
2380: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2381: BEGIN
2382: Get_Terms_Template(p_api_version =>1,
2383: p_init_msg_list => FND_API.G_FALSE,
2384: x_return_status => l_return_status,
2385: x_msg_count => l_msg_count,
2386: x_msg_data => l_msg_data,
2387: p_doc_type => p_doc_type,

Line 2400: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2396: END Get_Terms_Template;
2397:
2398: PROCEDURE get_item_dtl_for_expert(
2399: p_api_version IN NUMBER,
2400: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2401:
2402: x_return_status OUT NOCOPY VARCHAR2,
2403: x_msg_data OUT NOCOPY VARCHAR2,
2404: x_msg_count OUT NOCOPY NUMBER,

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

2420: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15400: Entered get_item_dtl_for_expert');
2421: END IF;
2422:
2423: -- Standard call to check for call compatibility.
2424: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2426: END IF;
2427: -- Initialize message list if p_init_msg_list is set to TRUE.
2428: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2421: END IF;
2422:
2423: -- Standard call to check for call compatibility.
2424: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2426: END IF;
2427: -- Initialize message list if p_init_msg_list is set to TRUE.
2428: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2429: FND_MSG_PUB.initialize;

Line 2428: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2424: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2426: END IF;
2427: -- Initialize message list if p_init_msg_list is set to TRUE.
2428: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2429: FND_MSG_PUB.initialize;
2430: END IF;
2431: -- Initialize API return status to success
2432: x_return_status := G_RET_STS_SUCCESS;

Line 2461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2457: );
2458:
2459: --------------------------------------------
2460: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2462: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2463: RAISE FND_API.G_EXC_ERROR ;
2464: END IF;
2465: --------------------------------------------

Line 2463: RAISE FND_API.G_EXC_ERROR ;

2459: --------------------------------------------
2460: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2462: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2463: RAISE FND_API.G_EXC_ERROR ;
2464: END IF;
2465: --------------------------------------------
2466:
2467: ELSIF l_doc_class = 'PO' THEN

Line 2483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2479: x_category_tbl => x_category_tbl);
2480:
2481: --------------------------------------------
2482: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2484: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2485: RAISE FND_API.G_EXC_ERROR ;
2486: END IF;
2487: --------------------------------------------

Line 2485: RAISE FND_API.G_EXC_ERROR ;

2481: --------------------------------------------
2482: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2484: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2485: RAISE FND_API.G_EXC_ERROR ;
2486: END IF;
2487: --------------------------------------------
2488:
2489: ELSIF l_doc_class = 'SOURCING' THEN

Line 2504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2500: x_category_tbl => x_category_tbl);
2501:
2502: --------------------------------------------
2503: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2505: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2506: RAISE FND_API.G_EXC_ERROR ;
2507: END IF;
2508: --------------------------------------------

Line 2506: RAISE FND_API.G_EXC_ERROR ;

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

Line 2524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2520: x_category_tbl => x_category_tbl);
2521:
2522: --------------------------------------------
2523: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2525: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2526: RAISE FND_API.G_EXC_ERROR ;
2527: END IF;
2528: --------------------------------------------

Line 2526: RAISE FND_API.G_EXC_ERROR ;

2522: --------------------------------------------
2523: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2525: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2526: RAISE FND_API.G_EXC_ERROR ;
2527: END IF;
2528: --------------------------------------------
2529: ELSE
2530: NULL;

Line 2539: WHEN FND_API.G_EXC_ERROR THEN

2535: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2536: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15500: Leaving get_item_dtl_for_expert');
2537: END IF;
2538: EXCEPTION
2539: WHEN FND_API.G_EXC_ERROR THEN
2540:
2541: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2542: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15600: Leaving get_item_dtl_for_expert : OKC_API.G_EXCEPTION_ERROR Exception');
2543: END IF;

Line 2547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2543: END IF;
2544: x_return_status := G_RET_STS_ERROR ;
2545: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2546:
2547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2548:
2549: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2550: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15700: Leaving get_item_dtl_for_expert : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2551: END IF;

Line 2607: p_init_msg_list => FND_API.G_FALSE,

2603:
2604:
2605: OKC_PO_INT_GRP.get_last_signed_revision(
2606: p_api_version => 1 ,
2607: p_init_msg_list => FND_API.G_FALSE,
2608: x_msg_data => l_msg_data ,
2609: x_msg_count => l_msg_count ,
2610: x_return_status => l_return_status,
2611:

Line 2619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2615: x_signed_revision_num => l_signed_version);
2616:
2617: --------------------------------------------
2618: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2620: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2621: RAISE FND_API.G_EXC_ERROR ;
2622: END IF;
2623: --------------------------------------------

Line 2621: RAISE FND_API.G_EXC_ERROR ;

2617: --------------------------------------------
2618: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2620: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2621: RAISE FND_API.G_EXC_ERROR ;
2622: END IF;
2623: --------------------------------------------
2624:
2625: ELSE

Line 2635: WHEN FND_API.G_EXC_ERROR THEN

2631: END IF;
2632: RETURN l_signed_version;
2633:
2634: EXCEPTION
2635: WHEN FND_API.G_EXC_ERROR THEN
2636:
2637: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2638: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'16100: Leaving get_last_signed_revision : OKC_API.G_EXCEPTION_ERROR Exception');
2639: END IF;

Line 2642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2638: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'16100: Leaving get_last_signed_revision : OKC_API.G_EXCEPTION_ERROR Exception');
2639: END IF;
2640: return NULL;
2641:
2642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2643:
2644: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2645: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'16200: Leaving get_last_signed_revision : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2646: END IF;

Line 2701: Raise FND_API.G_EXC_ERROR;

2697: IF l_get_template_dtl%NOTFOUND THEN
2698: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2699: p_msg_name => 'OKC_WRONG_TEMPLATE'
2700: );
2701: Raise FND_API.G_EXC_ERROR;
2702: END IF;
2703: CLOSE l_get_template_dtl;
2704:
2705: -- Standard call to get message count and if count is 1, get message info.

Line 2711: WHEN FND_API.G_EXC_ERROR THEN

2707: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2708: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'16500: Leaving Get_Terms_Template_dtl');
2709: END IF;
2710: EXCEPTION
2711: WHEN FND_API.G_EXC_ERROR THEN
2712:
2713: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2714: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'16600: Leaving Get_Terms_Template_dtl : OKC_API.G_EXCEPTION_ERROR Exception');
2715: END IF;

Line 2722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2718: END IF;
2719: x_return_status := G_RET_STS_ERROR ;
2720: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2721:
2722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2723:
2724: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2725: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'16700: Leaving Get_Terms_Template_dtl : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2726: END IF;

Line 2816: WHEN FND_API.G_EXC_ERROR THEN

2812: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2813: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'17000: Leaving Get_Terms_Template_dtl');
2814: END IF;
2815: EXCEPTION
2816: WHEN FND_API.G_EXC_ERROR THEN
2817:
2818: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2819: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'17100: Leaving Get_Terms_Template_dtl : OKC_API.G_EXCEPTION_ERROR Exception');
2820: END IF;

Line 2827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2823: END IF;
2824: x_return_status := G_RET_STS_ERROR ;
2825: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2826:
2827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2828:
2829: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2830: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'17200: Leaving Get_Terms_Template_dtl : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2831: END IF;

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

3133: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15400: Entered Get_Contract_Details');
3134: END IF;
3135:
3136: -- Standard call to check for call compatibility.
3137: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3139: END IF;
3140: -- Initialize message list if p_init_msg_list is set to TRUE.
3141: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3134: END IF;
3135:
3136: -- Standard call to check for call compatibility.
3137: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3139: END IF;
3140: -- Initialize message list if p_init_msg_list is set to TRUE.
3141: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3142: FND_MSG_PUB.initialize;

Line 3141: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3137: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3139: END IF;
3140: -- Initialize message list if p_init_msg_list is set to TRUE.
3141: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3142: FND_MSG_PUB.initialize;
3143: END IF;
3144: -- Initialize API return status to success
3145: x_return_status := G_RET_STS_SUCCESS;

Line 3190: WHEN FND_API.G_EXC_ERROR THEN

3186: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3187: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'17000: Leaving Get_Contract_Details');
3188: END IF;
3189: EXCEPTION
3190: WHEN FND_API.G_EXC_ERROR THEN
3191:
3192: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3193: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'17100: Leaving Get_Contract_Details : OKC_API.G_EXCEPTION_ERROR Exception');
3194: END IF;

Line 3198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3194: END IF;
3195: x_return_status := G_RET_STS_ERROR ;
3196: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3197:
3198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3199:
3200: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3201: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'17200: Leaving Get_Contract_Details : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3202: END IF;

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

3339: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15400: Entered Get_Contract_Details_All');
3340: END IF;
3341:
3342: -- Standard call to check for call compatibility.
3343: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3345: END IF;
3346: -- Initialize message list if p_init_msg_list is set to TRUE.
3347: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3340: END IF;
3341:
3342: -- Standard call to check for call compatibility.
3343: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3345: END IF;
3346: -- Initialize message list if p_init_msg_list is set to TRUE.
3347: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3348: FND_MSG_PUB.initialize;

Line 3347: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3343: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3345: END IF;
3346: -- Initialize message list if p_init_msg_list is set to TRUE.
3347: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3348: FND_MSG_PUB.initialize;
3349: END IF;
3350: -- Initialize API return status to success
3351: x_return_status := G_RET_STS_SUCCESS;

Line 3465: WHEN FND_API.G_EXC_ERROR THEN

3461: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3462: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'17000: Leaving Get_Contract_Details_All');
3463: END IF;
3464: EXCEPTION
3465: WHEN FND_API.G_EXC_ERROR THEN
3466:
3467: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3468: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'17100: Leaving Get_Contract_Details_All : OKC_API.G_EXCEPTION_ERROR Exception');
3469: END IF;

Line 3473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3469: END IF;
3470: x_return_status := G_RET_STS_ERROR ;
3471: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3472:
3473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3474:
3475: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3476: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'17200: Leaving Get_Contract_Details_All : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3477: END IF;

Line 3566: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3562: --document type and org id.
3563: --Else returns 'N'.
3564: FUNCTION Is_Terms_Template_Valid(
3565: p_api_version IN NUMBER,
3566: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3567:
3568: x_return_status OUT NOCOPY VARCHAR2,
3569: x_msg_data OUT NOCOPY VARCHAR2,
3570: x_msg_count OUT NOCOPY NUMBER,

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

3599: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6900: Entered Is_Terms_Template_Valid');
3600: END IF;
3601:
3602: -- Standard call to check for call compatibility.
3603: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3605: END IF;
3606:
3607: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3600: END IF;
3601:
3602: -- Standard call to check for call compatibility.
3603: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3605: END IF;
3606:
3607: -- Initialize message list if p_init_msg_list is set to TRUE.
3608: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3608: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3605: END IF;
3606:
3607: -- Initialize message list if p_init_msg_list is set to TRUE.
3608: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3609: FND_MSG_PUB.initialize;
3610: END IF;
3611:
3612: x_return_status := G_RET_STS_SUCCESS;

Line 3633: WHEN FND_API.G_EXC_ERROR THEN

3629: RETURN 'N';
3630: END IF;
3631:
3632: EXCEPTION
3633: WHEN FND_API.G_EXC_ERROR THEN
3634:
3635: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3636: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7200: Leaving Is_Terms_Template_Valid : OKC_API.G_EXCEPTION_ERROR Exception');
3637: END IF;

Line 3642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3638:
3639: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3640: x_return_status := G_RET_STS_ERROR ;
3641:
3642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3643: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3644: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7300: Leaving Is_Terms_Template_Valid : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3645: END IF;
3646:

Line 3670: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3666: --Returns values used for defaulting Contract Terms Details for authoring_party,contract_source,
3667: --template_name,template_description in OM.
3668: PROCEDURE Get_Contract_Defaults(
3669: p_api_version IN NUMBER,
3670: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3671:
3672: x_return_status OUT NOCOPY VARCHAR2,
3673: x_msg_data OUT NOCOPY VARCHAR2,
3674: x_msg_count OUT NOCOPY NUMBER,

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

3705: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6900: Entered Get_Contract_Defaults');
3706: END IF;
3707:
3708: -- Standard call to check for call compatibility.
3709: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3711: END IF;
3712:
3713: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3706: END IF;
3707:
3708: -- Standard call to check for call compatibility.
3709: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3711: END IF;
3712:
3713: -- Initialize message list if p_init_msg_list is set to TRUE.
3714: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3714: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3711: END IF;
3712:
3713: -- Initialize message list if p_init_msg_list is set to TRUE.
3714: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3715: FND_MSG_PUB.initialize;
3716: END IF;
3717:
3718: x_return_status := G_RET_STS_SUCCESS;

Line 3754: WHEN FND_API.G_EXC_ERROR THEN

3750: END IF;
3751:
3752:
3753: EXCEPTION
3754: WHEN FND_API.G_EXC_ERROR THEN
3755:
3756: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3757: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7200: Leaving Get_Contract_Defaults : OKC_API.G_EXCEPTION_ERROR Exception');
3758: END IF;

Line 3763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3759:
3760: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3761: x_return_status := G_RET_STS_ERROR ;
3762:
3763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3764: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3765: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7300: Leaving Get_Contract_Defaults : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3766: END IF;
3767:

Line 3788: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3784: END Get_Contract_Defaults;
3785:
3786: PROCEDURE Get_Default_Template(
3787: p_api_version IN NUMBER,
3788: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3789:
3790: x_return_status OUT NOCOPY VARCHAR2,
3791: x_msg_data OUT NOCOPY VARCHAR2,
3792: x_msg_count OUT NOCOPY NUMBER,

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

3828: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6930: p_valid_date='||p_valid_date);
3829: END IF;
3830:
3831: -- Standard call to check for call compatibility.
3832: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3834: END IF;
3835:
3836: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3829: END IF;
3830:
3831: -- Standard call to check for call compatibility.
3832: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3834: END IF;
3835:
3836: -- Initialize message list if p_init_msg_list is set to TRUE.
3837: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3837: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3834: END IF;
3835:
3836: -- Initialize message list if p_init_msg_list is set to TRUE.
3837: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3838: FND_MSG_PUB.initialize;
3839: END IF;
3840:
3841: x_return_status := G_RET_STS_SUCCESS;

Line 3859: WHEN FND_API.G_EXC_ERROR THEN

3855: END IF;
3856:
3857:
3858: EXCEPTION
3859: WHEN FND_API.G_EXC_ERROR THEN
3860:
3861: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3862: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7200: Leaving Get_Default_Template : OKC_API.G_EXCEPTION_ERROR Exception');
3863: END IF;

Line 3867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3863: END IF;
3864: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3865: x_return_status := G_RET_STS_ERROR ;
3866:
3867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3868: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3869: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7300: Leaving Get_Default_Template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3870: END IF;
3871:

Line 3985: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3981:
3982:
3983: PROCEDURE Has_Uploaded_Deviations_Doc(
3984: p_api_version IN NUMBER,
3985: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3986:
3987: x_return_status OUT NOCOPY VARCHAR2,
3988: x_msg_data OUT NOCOPY VARCHAR2,
3989: x_msg_count OUT NOCOPY NUMBER,

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

4003: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6900: Entered Has_Uploaded_Deviations_Doc');
4004: END IF;
4005:
4006: -- Standard call to check for call compatibility.
4007: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4009: END IF;
4010:
4011: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4004: END IF;
4005:
4006: -- Standard call to check for call compatibility.
4007: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4009: END IF;
4010:
4011: -- Initialize message list if p_init_msg_list is set to TRUE.
4012: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4012: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4009: END IF;
4010:
4011: -- Initialize message list if p_init_msg_list is set to TRUE.
4012: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4013: FND_MSG_PUB.initialize;
4014: END IF;
4015:
4016: x_return_status := G_RET_STS_SUCCESS;

Line 4039: WHEN FND_API.G_EXC_ERROR THEN

4035: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7100: Leaving Has_Uploaded_Deviations_Doc');
4036: END IF;
4037:
4038: EXCEPTION
4039: WHEN FND_API.G_EXC_ERROR THEN
4040:
4041: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4042: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7200: Leaving Has_Uploaded_Deviations_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
4043: END IF;

Line 4048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4044:
4045: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4046: x_return_status := G_RET_STS_ERROR ;
4047:
4048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4049: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4050: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7300: Leaving Has_Uploaded_Deviations_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4051: END IF;
4052:

Line 4120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4116: END is_Deviations_enabled;
4117:
4118: FUNCTION Contract_Terms_Amended(
4119: p_api_version IN NUMBER,
4120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4121:
4122: x_return_status OUT NOCOPY VARCHAR2,
4123: x_msg_data OUT NOCOPY VARCHAR2,
4124: x_msg_count OUT NOCOPY NUMBER,

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

4159: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4160: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered Contract_Terms_Amended');
4161: END IF;
4162: -- Standard call to check for call compatibility.
4163: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4165: END IF;
4166: -- Initialize message list if p_init_msg_list is set to TRUE.
4167: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4160: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered Contract_Terms_Amended');
4161: END IF;
4162: -- Standard call to check for call compatibility.
4163: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4165: END IF;
4166: -- Initialize message list if p_init_msg_list is set to TRUE.
4167: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4168: FND_MSG_PUB.initialize;

Line 4167: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4163: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4165: END IF;
4166: -- Initialize message list if p_init_msg_list is set to TRUE.
4167: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4168: FND_MSG_PUB.initialize;
4169: END IF;
4170: -- Initialize API return status to success
4171: x_return_status := G_RET_STS_SUCCESS;

Line 4209: WHEN FND_API.G_EXC_ERROR THEN

4205:
4206: RETURN l_return_value ;
4207:
4208: EXCEPTION
4209: WHEN FND_API.G_EXC_ERROR THEN
4210: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4211: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Contract_Terms_Amended : OKC_API.G_EXCEPTION_ERROR Exception');
4212: END IF;
4213: x_return_status := G_RET_STS_ERROR ;

Line 4217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4213: x_return_status := G_RET_STS_ERROR ;
4214: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4215: RETURN NULL ;
4216:
4217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4218:
4219: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4220: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Contract_Terms_Amended : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4221: END IF;

Line 4252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4248:
4249: ----MLS for templates
4250: PROCEDURE get_translated_template(
4251: p_api_version IN NUMBER,
4252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4253:
4254: p_template_id IN NUMBER,
4255: p_language IN VARCHAR2,
4256: p_document_type IN VARCHAR2,

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

4295: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6900: Entered get_translated_template');
4296: END IF;
4297:
4298: -- Standard call to check for call compatibility.
4299: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4301: END IF;
4302:
4303: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4296: END IF;
4297:
4298: -- Standard call to check for call compatibility.
4299: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4301: END IF;
4302:
4303: -- Initialize message list if p_init_msg_list is set to TRUE.
4304: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4304: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4301: END IF;
4302:
4303: -- Initialize message list if p_init_msg_list is set to TRUE.
4304: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4305: FND_MSG_PUB.initialize;
4306: END IF;
4307:
4308: x_return_status := G_RET_STS_SUCCESS;

Line 4315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4311: OPEN l_tmpl_csr;
4312: FETCH l_tmpl_csr INTO l_translated_from_tmpl_id, l_language, l_org_id, l_parent_template_id;
4313: IF l_tmpl_csr%NOTFOUND THEN
4314: CLOSE l_tmpl_csr;
4315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4316: END IF;
4317: CLOSE l_tmpl_csr;
4318:
4319: IF l_language = p_language THEN

Line 4365: WHEN FND_API.G_EXC_ERROR THEN

4361: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7300: Leaving get_translated_template');
4362: END IF;
4363:
4364: EXCEPTION
4365: WHEN FND_API.G_EXC_ERROR THEN
4366: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4367: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7400: Leaving Contract_Terms_Amended : OKC_API.G_EXCEPTION_ERROR Exception');
4368: END IF;
4369: x_return_status := G_RET_STS_ERROR ;

Line 4373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4369: x_return_status := G_RET_STS_ERROR ;
4370: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4371: RETURN ;
4372:
4373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4374:
4375: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4376: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7500: Leaving Contract_Terms_Amended : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4377: END IF;