eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_TERMS_VERSION_GRP dependencies on FND_API

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

9: G_MODULE CONSTANT VARCHAR2(200) := 'okc.plsql.'||G_PKG_NAME||'.';
10: ------------------------------------------------------------------------------
11: -- GLOBAL CONSTANTS
12: ------------------------------------------------------------------------------
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;

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

10: ------------------------------------------------------------------------------
11: -- GLOBAL CONSTANTS
12: ------------------------------------------------------------------------------
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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

12: ------------------------------------------------------------------------------
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
19:
20: --<<<<<<<<<<<<<<<<<<<<<<<<<<< EXTERNAL PROCEDURES <<<<<<<<<<<<<<<<<<<<<<<<<<<

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

13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
19:
20: --<<<<<<<<<<<<<<<<<<<<<<<<<<< EXTERNAL PROCEDURES <<<<<<<<<<<<<<<<<<<<<<<<<<<
21: /*

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

14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
19:
20: --<<<<<<<<<<<<<<<<<<<<<<<<<<< EXTERNAL PROCEDURES <<<<<<<<<<<<<<<<<<<<<<<<<<<
21: /*
22: -- This API will be used to version terms whenever a document is versioned.

Line 26: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

22: -- This API will be used to version terms whenever a document is versioned.
23: */
24: PROCEDURE Version_Doc (
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28:
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_data OUT NOCOPY VARCHAR2,

Line 27: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

23: */
24: PROCEDURE Version_Doc (
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28:
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_data OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,

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

53: END IF;
54: -- Standard Start of API savepoint
55: SAVEPOINT g_Version_Doc;
56: -- Standard call to check for call compatibility.
57: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60: -- Initialize message list if p_init_msg_list is set to TRUE.
61: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

54: -- Standard Start of API savepoint
55: SAVEPOINT g_Version_Doc;
56: -- Standard call to check for call compatibility.
57: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60: -- Initialize message list if p_init_msg_list is set to TRUE.
61: IF FND_API.to_Boolean( p_init_msg_list ) THEN
62: FND_MSG_PUB.initialize;

Line 61: IF FND_API.to_Boolean( p_init_msg_list ) THEN

57: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60: -- Initialize message list if p_init_msg_list is set to TRUE.
61: IF FND_API.to_Boolean( p_init_msg_list ) THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64: -- Initialize API return status to success
65: x_return_status := G_RET_STS_SUCCESS;

Line 91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

87: p_version_number => p_version_number
88: );
89: --------------------------------------------
90: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
92: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
93: RAISE FND_API.G_EXC_ERROR ;
94: END IF;
95:

Line 93: RAISE FND_API.G_EXC_ERROR ;

89: --------------------------------------------
90: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
92: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
93: RAISE FND_API.G_EXC_ERROR ;
94: END IF;
95:
96: ELSIF l_contract_source = 'ATTACHED' THEN
97:

Line 113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

109: p_major_version => p_version_number
110: );
111: --------------------------------------------
112: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
114: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
115: RAISE FND_API.G_EXC_ERROR ;
116: END IF;
117:

Line 115: RAISE FND_API.G_EXC_ERROR ;

111: --------------------------------------------
112: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
114: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
115: RAISE FND_API.G_EXC_ERROR ;
116: END IF;
117:
118: END IF;
119:

Line 139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 141: RAISE FND_API.G_EXC_ERROR ;

137: --------------------------------------------
138: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
140: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
141: RAISE FND_API.G_EXC_ERROR ;
142: END IF;
143: --------------------------------------------
144: --------------------------------------------
145: -- Call private version_attachements

Line 153: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

149: END IF;
150: OKC_CONTRACT_DOCS_GRP.version_Attachments (
151: p_api_version => p_api_version,
152: p_init_msg_list => p_init_msg_list,
153: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
154: p_commit => FND_API.G_FALSE,
155: x_return_status => x_return_status,
156: x_msg_data => x_msg_data,
157: x_msg_count => x_msg_count,

Line 154: p_commit => FND_API.G_FALSE,

150: OKC_CONTRACT_DOCS_GRP.version_Attachments (
151: p_api_version => p_api_version,
152: p_init_msg_list => p_init_msg_list,
153: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
154: p_commit => FND_API.G_FALSE,
155: x_return_status => x_return_status,
156: x_msg_data => x_msg_data,
157: x_msg_count => x_msg_count,
158:

Line 166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

162: p_include_gen_attach => p_include_gen_attach
163: );
164: --------------------------------------------
165: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
167: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
168: RAISE FND_API.G_EXC_ERROR ;
169: END IF;
170:

Line 168: RAISE FND_API.G_EXC_ERROR ;

164: --------------------------------------------
165: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
167: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
168: RAISE FND_API.G_EXC_ERROR ;
169: END IF;
170:
171:
172: IF p_clear_amendment='Y' THEN

Line 175: p_commit => FND_API.G_FALSE,

171:
172: IF p_clear_amendment='Y' THEN
173: clear_amendment (
174: p_api_version =>1,
175: p_commit => FND_API.G_FALSE,
176: x_return_status => x_return_status,
177: x_msg_data => x_msg_data,
178: x_msg_count => x_msg_count,
179: p_doc_type => p_doc_type,

Line 183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

179: p_doc_type => p_doc_type,
180: p_doc_id => p_doc_id
181: );
182: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
184: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
185: RAISE FND_API.G_EXC_ERROR ;
186: END IF;
187: END IF;

Line 185: RAISE FND_API.G_EXC_ERROR ;

181: );
182: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
184: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
185: RAISE FND_API.G_EXC_ERROR ;
186: END IF;
187: END IF;
188:
189: -- commit changes if asked

Line 190: IF FND_API.to_Boolean( p_commit ) THEN

186: END IF;
187: END IF;
188:
189: -- commit changes if asked
190: IF FND_API.to_Boolean( p_commit ) THEN
191: COMMIT;
192: END IF;
193: -- Standard call to get message count and if count is 1, get message info.
194: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 200: WHEN FND_API.G_EXC_ERROR THEN

196: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving Version_Doc');
197: END IF;
198:
199: EXCEPTION
200: WHEN FND_API.G_EXC_ERROR THEN
201: ROLLBACK TO g_Version_Doc;
202: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
203: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Version_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
204: END IF;

Line 208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

204: END IF;
205: x_return_status := G_RET_STS_ERROR ;
206: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
207:
208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
209: ROLLBACK TO g_Version_Doc;
210: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
211: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Version_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
212: END IF;

Line 235: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

231: -- document is restored.It is a very OKS/OKC/OKO specific functionality
232: */
233: PROCEDURE Restore_Doc_Version (
234: p_api_version IN NUMBER,
235: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
236: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
237:
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_data OUT NOCOPY VARCHAR2,

Line 236: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

232: */
233: PROCEDURE Restore_Doc_Version (
234: p_api_version IN NUMBER,
235: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
236: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
237:
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_data OUT NOCOPY VARCHAR2,
240: x_msg_count OUT NOCOPY NUMBER,

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

251: END IF;
252: -- Standard Start of API savepoint
253: SAVEPOINT g_Restore_Doc_Version;
254: -- Standard call to check for call compatibility.
255: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258: -- Initialize message list if p_init_msg_list is set to TRUE.
259: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

252: -- Standard Start of API savepoint
253: SAVEPOINT g_Restore_Doc_Version;
254: -- Standard call to check for call compatibility.
255: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258: -- Initialize message list if p_init_msg_list is set to TRUE.
259: IF FND_API.to_Boolean( p_init_msg_list ) THEN
260: FND_MSG_PUB.initialize;

Line 259: IF FND_API.to_Boolean( p_init_msg_list ) THEN

255: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258: -- Initialize message list if p_init_msg_list is set to TRUE.
259: IF FND_API.to_Boolean( p_init_msg_list ) THEN
260: FND_MSG_PUB.initialize;
261: END IF;
262: -- Initialize API return status to success
263: x_return_status := G_RET_STS_SUCCESS;

Line 279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

275: p_doc_id => p_doc_id
276: );
277: --------------------------------------------
278: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
280: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
281: RAISE FND_API.G_EXC_ERROR ;
282: END IF;
283: --------------------------------------------

Line 281: RAISE FND_API.G_EXC_ERROR ;

277: --------------------------------------------
278: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
280: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
281: RAISE FND_API.G_EXC_ERROR ;
282: END IF;
283: --------------------------------------------
284:
285: --------------------------------------------

Line 301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

297: p_version_number => p_version_number
298: );
299: --------------------------------------------
300: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
302: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
303: RAISE FND_API.G_EXC_ERROR ;
304: END IF;
305: --------------------------------------------

Line 303: RAISE FND_API.G_EXC_ERROR ;

299: --------------------------------------------
300: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
302: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
303: RAISE FND_API.G_EXC_ERROR ;
304: END IF;
305: --------------------------------------------
306:
307: -- commit changes if asked

Line 308: IF FND_API.to_Boolean( p_commit ) THEN

304: END IF;
305: --------------------------------------------
306:
307: -- commit changes if asked
308: IF FND_API.to_Boolean( p_commit ) THEN
309: COMMIT;
310: END IF;
311: -- Standard call to get message count and if count is 1, get message info.
312: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 317: WHEN FND_API.G_EXC_ERROR THEN

313: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
314: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving Restore_Doc_Version');
315: END IF;
316: EXCEPTION
317: WHEN FND_API.G_EXC_ERROR THEN
318: ROLLBACK TO g_Restore_Doc_Version;
319: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
320: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Restore_Doc_Version : OKC_API.G_EXCEPTION_ERROR Exception');
321: END IF;

Line 325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

321: END IF;
322: x_return_status := G_RET_STS_ERROR ;
323: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
324:
325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
326: ROLLBACK TO g_Restore_Doc_Version;
327: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
328: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Restore_Doc_Version : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
329: END IF;

Line 351: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

347: --This API will be used to delete terms whenever a version of document is deleted.
348: */
349: Procedure Delete_Doc_Version (
350: p_api_version IN NUMBER,
351: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
352: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
353:
354: x_return_status OUT NOCOPY VARCHAR2,
355: x_msg_data OUT NOCOPY VARCHAR2,

Line 352: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

348: */
349: Procedure Delete_Doc_Version (
350: p_api_version IN NUMBER,
351: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
352: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
353:
354: x_return_status OUT NOCOPY VARCHAR2,
355: x_msg_data OUT NOCOPY VARCHAR2,
356: x_msg_count OUT NOCOPY NUMBER,

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

367: END IF;
368: -- Standard Start of API savepoint
369: SAVEPOINT g_Delete_Doc_Version;
370: -- Standard call to check for call compatibility.
371: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;
374: -- Initialize message list if p_init_msg_list is set to TRUE.
375: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

368: -- Standard Start of API savepoint
369: SAVEPOINT g_Delete_Doc_Version;
370: -- Standard call to check for call compatibility.
371: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;
374: -- Initialize message list if p_init_msg_list is set to TRUE.
375: IF FND_API.to_Boolean( p_init_msg_list ) THEN
376: FND_MSG_PUB.initialize;

Line 375: IF FND_API.to_Boolean( p_init_msg_list ) THEN

371: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;
374: -- Initialize message list if p_init_msg_list is set to TRUE.
375: IF FND_API.to_Boolean( p_init_msg_list ) THEN
376: FND_MSG_PUB.initialize;
377: END IF;
378: -- Initialize API return status to success
379: x_return_status := G_RET_STS_SUCCESS;

Line 397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

393: p_version_number => p_version_number
394: );
395: --------------------------------------------
396: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
398: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
399: RAISE FND_API.G_EXC_ERROR ;
400: END IF;
401: --------------------------------------------

Line 399: RAISE FND_API.G_EXC_ERROR ;

395: --------------------------------------------
396: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
398: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
399: RAISE FND_API.G_EXC_ERROR ;
400: END IF;
401: --------------------------------------------
402: -- Call Deliverable API to delete delevirable from the document.
403: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 408: p_init_msg_list => FND_API.G_FALSE,

404: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3900: Delete delevirable for the doc version');
405: END IF;
406: OKC_DELIVERABLE_PROCESS_PVT.Delete_Deliverables(
407: p_api_version => l_api_version,
408: p_init_msg_list => FND_API.G_FALSE,
409: p_doc_type => p_doc_type,
410: p_doc_id => p_doc_id,
411: p_doc_version => p_version_number,
412: x_msg_data => x_msg_data,

Line 418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

414: x_return_status => x_return_status
415: );
416: --------------------------------------------
417: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
419: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
420: RAISE FND_API.G_EXC_ERROR ;
421: END IF;
422: --------------------------------------------

Line 420: RAISE FND_API.G_EXC_ERROR ;

416: --------------------------------------------
417: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
419: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
420: RAISE FND_API.G_EXC_ERROR ;
421: END IF;
422: --------------------------------------------
423: --------------------------------------------
424: -- Call private Delete_All_Version_Attach

Line 432: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

428: END IF;
429: OKC_CONTRACT_DOCS_GRP.Delete_Ver_Attachments(
430: p_api_version => p_api_version,
431: p_init_msg_list => p_init_msg_list,
432: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
433: p_commit => FND_API.G_FALSE,
434: x_return_status => x_return_status,
435: x_msg_data => x_msg_data,
436: x_msg_count => x_msg_count,

Line 433: p_commit => FND_API.G_FALSE,

429: OKC_CONTRACT_DOCS_GRP.Delete_Ver_Attachments(
430: p_api_version => p_api_version,
431: p_init_msg_list => p_init_msg_list,
432: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
433: p_commit => FND_API.G_FALSE,
434: x_return_status => x_return_status,
435: x_msg_data => x_msg_data,
436: x_msg_count => x_msg_count,
437:

Line 444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 446: RAISE FND_API.G_EXC_ERROR ;

442: --------------------------------------------
443: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
445: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
446: RAISE FND_API.G_EXC_ERROR ;
447: END IF;
448:
449: -- commit changes if asked
450: IF FND_API.to_Boolean( p_commit ) THEN

Line 450: IF FND_API.to_Boolean( p_commit ) THEN

446: RAISE FND_API.G_EXC_ERROR ;
447: END IF;
448:
449: -- commit changes if asked
450: IF FND_API.to_Boolean( p_commit ) THEN
451: COMMIT;
452: END IF;
453: -- Standard call to get message count and if count is 1, get message info.
454: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 459: WHEN FND_API.G_EXC_ERROR THEN

455: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
456: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving Delete_Doc_Version');
457: END IF;
458: EXCEPTION
459: WHEN FND_API.G_EXC_ERROR THEN
460: ROLLBACK TO g_Delete_Doc_Version;
461: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
462: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Delete_Doc_Version : OKC_API.G_EXCEPTION_ERROR Exception');
463: END IF;

Line 467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 491: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

487: /* This API will be used to clear amendment related columns */
488:
489: Procedure clear_amendment (
490: p_api_version IN NUMBER,
491: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
492: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
493:
494: x_return_status OUT NOCOPY VARCHAR2,
495: x_msg_data OUT NOCOPY VARCHAR2,

Line 492: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

488:
489: Procedure clear_amendment (
490: p_api_version IN NUMBER,
491: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
492: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
493:
494: x_return_status OUT NOCOPY VARCHAR2,
495: x_msg_data OUT NOCOPY VARCHAR2,
496: x_msg_count OUT NOCOPY NUMBER,

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

512: END IF;
513: -- Standard Start of API savepoint
514: SAVEPOINT g_clear_amendment;
515: -- Standard call to check for call compatibility.
516: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;
519: -- Initialize message list if p_init_msg_list is set to TRUE.
520: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

513: -- Standard Start of API savepoint
514: SAVEPOINT g_clear_amendment;
515: -- Standard call to check for call compatibility.
516: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;
519: -- Initialize message list if p_init_msg_list is set to TRUE.
520: IF FND_API.to_Boolean( p_init_msg_list ) THEN
521: FND_MSG_PUB.initialize;

Line 520: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

537: );
538:
539: --------------------------------------------
540: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
542: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
543: RAISE FND_API.G_EXC_ERROR ;
544: END IF;
545: --------------------------------------------

Line 543: RAISE FND_API.G_EXC_ERROR ;

539: --------------------------------------------
540: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
542: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
543: RAISE FND_API.G_EXC_ERROR ;
544: END IF;
545: --------------------------------------------
546: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
547: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: calling deliverables clear_amendment_operation');

Line 552: p_init_msg_list => FND_API.G_FALSE,

548: END IF;
549:
550: OKC_DELIVERABLE_PROCESS_PVT.clear_amendment_operation (
551: p_api_version => 1,
552: p_init_msg_list => FND_API.G_FALSE,
553: p_doc_id => p_doc_id,
554: p_doc_type => p_doc_type,
555: p_keep_summary => p_keep_summary,
556: x_msg_data => x_msg_data,

Line 562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 564: RAISE FND_API.G_EXC_ERROR ;

560: --------------------------------------------
561: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
563: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
564: RAISE FND_API.G_EXC_ERROR ;
565: END IF;
566: --------------------------------------------
567: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
568: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: leaving deliverables clear_amendment_operation');

Line 572: IF FND_API.to_Boolean( p_commit ) THEN

568: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: leaving deliverables clear_amendment_operation');
569: END IF;
570:
571: -- commit changes if asked
572: IF FND_API.to_Boolean( p_commit ) THEN
573: COMMIT;
574: END IF;
575: -- Standard call to get message count and if count is 1, get message info.
576: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 583: WHEN FND_API.G_EXC_ERROR THEN

579: END IF;
580:
581:
582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN
584: ROLLBACK TO g_clear_amendment;
585: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
586: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving clear_amendment : OKC_API.G_EXCEPTION_ERROR Exception');
587: END IF;

Line 591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

587: END IF;
588: x_return_status := G_RET_STS_ERROR ;
589: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
590:
591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
592: ROLLBACK TO g_clear_amendment;
593: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
594: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving clear_amendment : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
595: END IF;