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

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

16:
17: ------------------------------------------------------------------------------
18: -- GLOBAL CONSTANTS
19: ------------------------------------------------------------------------------
20: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
21: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
22: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
23: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
24: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;

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

17: ------------------------------------------------------------------------------
18: -- GLOBAL CONSTANTS
19: ------------------------------------------------------------------------------
20: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
21: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
22: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
23: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
24: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
25:

Line 22: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;

18: -- GLOBAL CONSTANTS
19: ------------------------------------------------------------------------------
20: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
21: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
22: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
23: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
24: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
25:
26: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;

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

19: ------------------------------------------------------------------------------
20: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
21: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
22: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
23: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
24: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
25:
26: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
27: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;

Line 24: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;

20: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
21: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
22: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
23: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
24: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
25:
26: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
27: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
28: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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

22: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
23: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
24: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
25:
26: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
27: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
28: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
29:
30: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';

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

23: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
24: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
25:
26: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
27: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
28: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
29:
30: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
31: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';

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

24: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
25:
26: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
27: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
28: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
29:
30: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
31: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
32: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';

Line 40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

36: ---------------------------------------
37: PROCEDURE validate_row(
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 ,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41:
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2,

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

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

Line 88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 91: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 95: x_return_status := FND_API.G_RET_STS_SUCCESS;

91: IF FND_API.to_Boolean( p_init_msg_list ) THEN
92: FND_MSG_PUB.initialize;
93: END IF;
94: -- Initialize API return status to success
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96:
97: --added for 10+ word integration and deviations report
98: --Set default value for p_authoring_party_code
99: l_authoring_party_code := p_authoring_party_code;

Line 140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 142: RAISE FND_API.G_EXC_ERROR ;

138: --------------------------------------------
139: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
141: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
142: RAISE FND_API.G_EXC_ERROR ;
143: END IF;
144: --------------------------------------------
145:
146: -- Standard call to get message count and if count is 1, get message info.

Line 154: WHEN FND_API.G_EXC_ERROR THEN

150: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving validate_row');
151: END IF;
152:
153: EXCEPTION
154: WHEN FND_API.G_EXC_ERROR THEN
155: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
156: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception');
157: END IF;
158: ROLLBACK TO g_validate_row_GRP;

Line 162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

158: ROLLBACK TO g_validate_row_GRP;
159: x_return_status := G_RET_STS_ERROR ;
160: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
161:
162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
163: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
164: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
165: END IF;
166: ROLLBACK TO g_validate_row_GRP;

Line 190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

186: -------------------------------------
187: PROCEDURE create_template_usages(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 ,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE,
192:
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,

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

187: PROCEDURE create_template_usages(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 ,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE,
192:
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,

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

242:
243: -- Standard Start of API savepoint
244: SAVEPOINT g_insert_row_GRP;
245: -- Standard call to check for call compatibility.
246: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249: -- Initialize message list if p_init_msg_list is set to TRUE.
250: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

243: -- Standard Start of API savepoint
244: SAVEPOINT g_insert_row_GRP;
245: -- Standard call to check for call compatibility.
246: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249: -- Initialize message list if p_init_msg_list is set to TRUE.
250: IF FND_API.to_Boolean( p_init_msg_list ) THEN
251: FND_MSG_PUB.initialize;

Line 250: IF FND_API.to_Boolean( p_init_msg_list ) THEN

246: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249: -- Initialize message list if p_init_msg_list is set to TRUE.
250: IF FND_API.to_Boolean( p_init_msg_list ) THEN
251: FND_MSG_PUB.initialize;
252: END IF;
253: -- Initialize API return status to success
254: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 254: x_return_status := FND_API.G_RET_STS_SUCCESS;

250: IF FND_API.to_Boolean( p_init_msg_list ) THEN
251: FND_MSG_PUB.initialize;
252: END IF;
253: -- Initialize API return status to success
254: x_return_status := FND_API.G_RET_STS_SUCCESS;
255: --added for 10+ word integration and deviations report
256: --Set default value for p_authoring_party_code
257:
258: -- Fix for bug# 4116433. l_authoring_party_code is to be initialized with the value from p_authoring_party_code

Line 303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 305: RAISE FND_API.G_EXC_ERROR ;

301: --------------------------------------------
302: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
304: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
305: RAISE FND_API.G_EXC_ERROR ;
306: END IF;
307: --------------------------------------------
308:
309: -- Standard check of p_commit

Line 310: IF FND_API.To_Boolean( p_commit ) THEN

306: END IF;
307: --------------------------------------------
308:
309: -- Standard check of p_commit
310: IF FND_API.To_Boolean( p_commit ) THEN
311: COMMIT WORK;
312: END IF;
313: -- Standard call to get message count and if count is 1, get message info.
314: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 321: WHEN FND_API.G_EXC_ERROR THEN

317: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Leaving create_template_usages');
318: END IF;
319:
320: EXCEPTION
321: WHEN FND_API.G_EXC_ERROR THEN
322: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
323: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving create_template_usages: OKC_API.G_EXCEPTION_ERROR Exception');
324: END IF;
325: ROLLBACK TO g_insert_row_GRP;

Line 329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

325: ROLLBACK TO g_insert_row_GRP;
326: x_return_status := G_RET_STS_ERROR ;
327: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
328:
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
330: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
331: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving insert_row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
332: END IF;
333: ROLLBACK TO g_insert_row_GRP;

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

372:
373: -- Standard Start of API savepoint
374: SAVEPOINT g_lock_row_GRP;
375: -- Standard call to check for call compatibility.
376: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: END IF;
379: -- Initialize message list if p_init_msg_list is set to TRUE.
380: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

373: -- Standard Start of API savepoint
374: SAVEPOINT g_lock_row_GRP;
375: -- Standard call to check for call compatibility.
376: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: END IF;
379: -- Initialize message list if p_init_msg_list is set to TRUE.
380: IF FND_API.to_Boolean( p_init_msg_list ) THEN
381: FND_MSG_PUB.initialize;

Line 380: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 384: x_return_status := FND_API.G_RET_STS_SUCCESS;

380: IF FND_API.to_Boolean( p_init_msg_list ) THEN
381: FND_MSG_PUB.initialize;
382: END IF;
383: -- Initialize API return status to success
384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385:
386: --------------------------------------------
387: -- Calling Simple API for Locking A Row
388: --------------------------------------------

Line 397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

393: p_object_version_number => p_object_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:
403: -- Standard call to get message count and if count is 1, get message info.

Line 411: WHEN FND_API.G_EXC_ERROR THEN

407: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1200: Leaving lock_row');
408: END IF;
409:
410: EXCEPTION
411: WHEN FND_API.G_EXC_ERROR THEN
412: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
413: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception');
414: END IF;
415: ROLLBACK TO g_lock_row_GRP;

Line 419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

415: ROLLBACK TO g_lock_row_GRP;
416: x_return_status := G_RET_STS_ERROR ;
417: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
418:
419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
420: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
421: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
422: END IF;
423: ROLLBACK TO g_lock_row_GRP;

Line 446: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

442: ---------------------------------------------------------------------------
443: PROCEDURE update_template_usages(
444: p_api_version IN NUMBER,
445: p_init_msg_list IN VARCHAR2 ,
446: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
447: p_commit IN VARCHAR2 := FND_API.G_FALSE,
448:
449: x_return_status OUT NOCOPY VARCHAR2,
450: x_msg_count OUT NOCOPY NUMBER,

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

443: PROCEDURE update_template_usages(
444: p_api_version IN NUMBER,
445: p_init_msg_list IN VARCHAR2 ,
446: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
447: p_commit IN VARCHAR2 := FND_API.G_FALSE,
448:
449: x_return_status OUT NOCOPY VARCHAR2,
450: x_msg_count OUT NOCOPY NUMBER,
451: x_msg_data OUT NOCOPY VARCHAR2,

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

491:
492: -- Standard Start of API savepoint
493: SAVEPOINT g_update_row_GRP;
494: -- Standard call to check for call compatibility.
495: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498: -- Initialize message list if p_init_msg_list is set to TRUE.
499: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

492: -- Standard Start of API savepoint
493: SAVEPOINT g_update_row_GRP;
494: -- Standard call to check for call compatibility.
495: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498: -- Initialize message list if p_init_msg_list is set to TRUE.
499: IF FND_API.to_Boolean( p_init_msg_list ) THEN
500: FND_MSG_PUB.initialize;

Line 499: IF FND_API.to_Boolean( p_init_msg_list ) THEN

495: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498: -- Initialize message list if p_init_msg_list is set to TRUE.
499: IF FND_API.to_Boolean( p_init_msg_list ) THEN
500: FND_MSG_PUB.initialize;
501: END IF;
502: -- Initialize API return status to success
503: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 503: x_return_status := FND_API.G_RET_STS_SUCCESS;

499: IF FND_API.to_Boolean( p_init_msg_list ) THEN
500: FND_MSG_PUB.initialize;
501: END IF;
502: -- Initialize API return status to success
503: x_return_status := FND_API.G_RET_STS_SUCCESS;
504:
505: --------------------------------------------
506: -- Calling Simple API for Updating A Row
507: --------------------------------------------

Line 537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

533: p_locked_by_user_id => p_locked_by_user_id
534: );
535: --------------------------------------------
536: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
538: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
539: RAISE FND_API.G_EXC_ERROR ;
540: END IF;
541: --------------------------------------------

Line 539: RAISE FND_API.G_EXC_ERROR ;

535: --------------------------------------------
536: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
538: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
539: RAISE FND_API.G_EXC_ERROR ;
540: END IF;
541: --------------------------------------------
542:
543: -- Standard check of p_commit

Line 544: IF FND_API.To_Boolean( p_commit ) THEN

540: END IF;
541: --------------------------------------------
542:
543: -- Standard check of p_commit
544: IF FND_API.To_Boolean( p_commit ) THEN
545: COMMIT WORK;
546: END IF;
547: -- Standard call to get message count and if count is 1, get message info.
548: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 555: WHEN FND_API.G_EXC_ERROR THEN

551: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Leaving update_template_usages');
552: END IF;
553:
554: EXCEPTION
555: WHEN FND_API.G_EXC_ERROR THEN
556: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
557: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1900: Leaving update_template_usages: OKC_API.G_EXCEPTION_ERROR Exception');
558: END IF;
559: ROLLBACK TO g_update_row_GRP;

Line 563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

559: ROLLBACK TO g_update_row_GRP;
560: x_return_status := G_RET_STS_ERROR ;
561: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
562:
563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
564: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
565: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving update_template_usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
566: END IF;
567: ROLLBACK TO g_update_row_GRP;

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

587: ---------------------------------------------------------------------------
588: PROCEDURE delete_template_usages(
589: p_api_version IN NUMBER,
590: p_init_msg_list IN VARCHAR2 ,
591: p_commit IN VARCHAR2 := FND_API.G_FALSE,
592:
593: x_return_status OUT NOCOPY VARCHAR2,
594: x_msg_count OUT NOCOPY NUMBER,
595: x_msg_data OUT NOCOPY VARCHAR2,

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

608:
609: -- Standard Start of API savepoint
610: SAVEPOINT g_delete_row_GRP;
611: -- Standard call to check for call compatibility.
612: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END IF;
615: -- Initialize message list if p_init_msg_list is set to TRUE.
616: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

609: -- Standard Start of API savepoint
610: SAVEPOINT g_delete_row_GRP;
611: -- Standard call to check for call compatibility.
612: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END IF;
615: -- Initialize message list if p_init_msg_list is set to TRUE.
616: IF FND_API.to_Boolean( p_init_msg_list ) THEN
617: FND_MSG_PUB.initialize;

Line 616: IF FND_API.to_Boolean( p_init_msg_list ) THEN

612: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END IF;
615: -- Initialize message list if p_init_msg_list is set to TRUE.
616: IF FND_API.to_Boolean( p_init_msg_list ) THEN
617: FND_MSG_PUB.initialize;
618: END IF;
619: -- Initialize API return status to success
620: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 620: x_return_status := FND_API.G_RET_STS_SUCCESS;

616: IF FND_API.to_Boolean( p_init_msg_list ) THEN
617: FND_MSG_PUB.initialize;
618: END IF;
619: -- Initialize API return status to success
620: x_return_status := FND_API.G_RET_STS_SUCCESS;
621:
622: --------------------------------------------
623: -- Calling Simple API for Deleting A Row
624: --------------------------------------------

Line 633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

629: p_object_version_number => p_object_version_number
630: );
631: --------------------------------------------
632: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
634: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
635: RAISE FND_API.G_EXC_ERROR ;
636: END IF;
637: --------------------------------------------

Line 635: RAISE FND_API.G_EXC_ERROR ;

631: --------------------------------------------
632: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
634: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
635: RAISE FND_API.G_EXC_ERROR ;
636: END IF;
637: --------------------------------------------
638:
639: -- Standard check of p_commit

Line 640: IF FND_API.To_Boolean( p_commit ) THEN

636: END IF;
637: --------------------------------------------
638:
639: -- Standard check of p_commit
640: IF FND_API.To_Boolean( p_commit ) THEN
641: COMMIT WORK;
642: END IF;
643: -- Standard call to get message count and if count is 1, get message info.
644: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 651: WHEN FND_API.G_EXC_ERROR THEN

647: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving delete_template_usages');
648: END IF;
649:
650: EXCEPTION
651: WHEN FND_API.G_EXC_ERROR THEN
652: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
653: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving delete_template_usages: OKC_API.G_EXCEPTION_ERROR Exception');
654: END IF;
655: ROLLBACK TO g_delete_row_GRP;

Line 659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

655: ROLLBACK TO g_delete_row_GRP;
656: x_return_status := G_RET_STS_ERROR ;
657: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
658:
659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
660: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
661: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving delete_template_usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
662: END IF;
663: ROLLBACK TO g_delete_row_GRP;

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

680:
681: PROCEDURE Set_Contract_Source(
682: p_api_version IN NUMBER,
683: p_init_msg_list IN VARCHAR2 ,
684: p_commit IN VARCHAR2 := FND_API.G_FALSE,
685:
686: x_return_status OUT NOCOPY VARCHAR2,
687: x_msg_count OUT NOCOPY NUMBER,
688: x_msg_data OUT NOCOPY VARCHAR2,

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

725: -- Standard Start of API savepoint
726: SAVEPOINT g_set_contract_source_GRP;
727:
728: -- Standard call to check for call compatibility.
729: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732:
733: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

726: SAVEPOINT g_set_contract_source_GRP;
727:
728: -- Standard call to check for call compatibility.
729: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732:
733: -- Initialize message list if p_init_msg_list is set to TRUE.
734: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 734: IF FND_API.to_Boolean( p_init_msg_list ) THEN

730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732:
733: -- Initialize message list if p_init_msg_list is set to TRUE.
734: IF FND_API.to_Boolean( p_init_msg_list ) THEN
735: FND_MSG_PUB.initialize;
736: END IF;
737:
738: -- Check if anything changed. If no change, then nothing to update, return.

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

751: END IF;
752: END IF;
753:
754: -- Bug 4003064. Added call to check if ok_to_commit()
755: IF NOT FND_API.To_Boolean( OKC_TERMS_UTIL_GRP.ok_to_commit (
756: p_api_version => l_api_version,
757: p_init_msg_list => FND_API.G_FALSE,
758: p_doc_type => p_document_type,
759: p_doc_id => p_document_id,

Line 757: p_init_msg_list => FND_API.G_FALSE,

753:
754: -- Bug 4003064. Added call to check if ok_to_commit()
755: IF NOT FND_API.To_Boolean( OKC_TERMS_UTIL_GRP.ok_to_commit (
756: p_api_version => l_api_version,
757: p_init_msg_list => FND_API.G_FALSE,
758: p_doc_type => p_document_type,
759: p_doc_id => p_document_id,
760: p_validation_string => p_validation_string,
761: p_tmpl_change => 'Y',

Line 769: RAISE FND_API.G_EXC_ERROR;

765: ) THEN
766: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
767: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'700: Issue with document header Record.Cannot commit');
768: END IF;
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771:
772: -- Initialize API return status to success
773: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 773: x_return_status := FND_API.G_RET_STS_SUCCESS;

769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771:
772: -- Initialize API return status to success
773: x_return_status := FND_API.G_RET_STS_SUCCESS;
774:
775: OPEN l_template_usages_csr;
776: FETCH l_template_usages_csr into l_value;
777: CLOSE l_template_usages_csr;

Line 821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

817: END IF;
818:
819: --------------------------------------------
820: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
822: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
823: RAISE FND_API.G_EXC_ERROR ;
824: END IF;
825: --------------------------------------------

Line 823: RAISE FND_API.G_EXC_ERROR ;

819: --------------------------------------------
820: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
822: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
823: RAISE FND_API.G_EXC_ERROR ;
824: END IF;
825: --------------------------------------------
826:
827: -- Standard check of p_commit

Line 828: IF FND_API.To_Boolean( p_commit ) THEN

824: END IF;
825: --------------------------------------------
826:
827: -- Standard check of p_commit
828: IF FND_API.To_Boolean( p_commit ) THEN
829: COMMIT WORK;
830: END IF;
831: -- Standard call to get message count and if count is 1, get message info.
832: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 839: WHEN FND_API.G_EXC_ERROR THEN

835: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving Set_Contract_Source');
836: END IF;
837:
838: EXCEPTION
839: WHEN FND_API.G_EXC_ERROR THEN
840: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
841: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving Set_Contract_Source: OKC_API.G_EXCEPTION_ERROR Exception');
842: END IF;
843: ROLLBACK TO g_set_contract_source_GRP;

Line 847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

843: ROLLBACK TO g_set_contract_source_GRP;
844: x_return_status := G_RET_STS_ERROR ;
845: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
846:
847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
848: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
849: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving Set_Contract_Source: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
850: END IF;
851: ROLLBACK TO g_set_contract_source_GRP;

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

868:
869: PROCEDURE Set_Contract_Source_details(
870: p_api_version IN NUMBER,
871: p_init_msg_list IN VARCHAR2 ,
872: p_commit IN VARCHAR2 := FND_API.G_FALSE,
873:
874: x_return_status OUT NOCOPY VARCHAR2,
875: x_msg_count OUT NOCOPY NUMBER,
876: x_msg_data OUT NOCOPY VARCHAR2,

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

919: -- Standard Start of API savepoint
920: SAVEPOINT g_set_contract_src_dtls_GRP;
921:
922: -- Standard call to check for call compatibility.
923: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
925: END IF;
926:
927: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

920: SAVEPOINT g_set_contract_src_dtls_GRP;
921:
922: -- Standard call to check for call compatibility.
923: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
925: END IF;
926:
927: -- Initialize message list if p_init_msg_list is set to TRUE.
928: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 928: IF FND_API.to_Boolean( p_init_msg_list ) THEN

924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
925: END IF;
926:
927: -- Initialize message list if p_init_msg_list is set to TRUE.
928: IF FND_API.to_Boolean( p_init_msg_list ) THEN
929: FND_MSG_PUB.initialize;
930: END IF;
931:
932: -- Check if anything changed. If no change, then nothing to update, return.

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

936:
937:
938:
939: -- Bug 4003064. Added call to check if ok_to_commit()
940: IF NOT FND_API.To_Boolean( OKC_TERMS_UTIL_GRP.ok_to_commit (
941: p_api_version => l_api_version,
942: p_init_msg_list => FND_API.G_FALSE,
943: p_doc_type => p_document_type,
944: p_doc_id => p_document_id,

Line 942: p_init_msg_list => FND_API.G_FALSE,

938:
939: -- Bug 4003064. Added call to check if ok_to_commit()
940: IF NOT FND_API.To_Boolean( OKC_TERMS_UTIL_GRP.ok_to_commit (
941: p_api_version => l_api_version,
942: p_init_msg_list => FND_API.G_FALSE,
943: p_doc_type => p_document_type,
944: p_doc_id => p_document_id,
945: p_validation_string => p_validation_string,
946: p_tmpl_change => 'Y',

Line 954: RAISE FND_API.G_EXC_ERROR;

950: ) THEN
951: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
952: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'700: Issue with document header Record.Cannot commit');
953: END IF;
954: RAISE FND_API.G_EXC_ERROR;
955: END IF;
956:
957: -- Initialize API return status to success
958: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 958: x_return_status := FND_API.G_RET_STS_SUCCESS;

954: RAISE FND_API.G_EXC_ERROR;
955: END IF;
956:
957: -- Initialize API return status to success
958: x_return_status := FND_API.G_RET_STS_SUCCESS;
959:
960: OPEN l_template_usages_csr;
961: FETCH l_template_usages_csr into l_value;
962: CLOSE l_template_usages_csr;

Line 1026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1022: END IF;
1023:
1024: --------------------------------------------
1025: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1027: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1028: RAISE FND_API.G_EXC_ERROR ;
1029: END IF;
1030: --------------------------------------------

Line 1028: RAISE FND_API.G_EXC_ERROR ;

1024: --------------------------------------------
1025: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1027: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1028: RAISE FND_API.G_EXC_ERROR ;
1029: END IF;
1030: --------------------------------------------
1031:
1032: -- Standard check of p_commit

Line 1033: IF FND_API.To_Boolean( p_commit ) THEN

1029: END IF;
1030: --------------------------------------------
1031:
1032: -- Standard check of p_commit
1033: IF FND_API.To_Boolean( p_commit ) THEN
1034: COMMIT WORK;
1035: END IF;
1036: -- Standard call to get message count and if count is 1, get message info.
1037: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 1044: WHEN FND_API.G_EXC_ERROR THEN

1040: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving Set_Contract_Source_details');
1041: END IF;
1042:
1043: EXCEPTION
1044: WHEN FND_API.G_EXC_ERROR THEN
1045: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1046: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving Set_Contract_Source_details: OKC_API.G_EXCEPTION_ERROR Exception');
1047: END IF;
1048: ROLLBACK TO g_set_contract_src_dtls_GRP;

Line 1052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1048: ROLLBACK TO g_set_contract_src_dtls_GRP;
1049: x_return_status := G_RET_STS_ERROR ;
1050: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1051:
1052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1053: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1054: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving Set_Contract_Source_details: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1055: END IF;
1056: ROLLBACK TO g_set_contract_src_dtls_GRP;