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_TEMPLATES_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: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;

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: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24:

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

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: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24:
25: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;

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

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

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

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

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

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

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

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

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

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

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

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

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

98:
99: -- Standard Start of API savepoint
100: SAVEPOINT g_validate_row_GRP;
101: -- Standard call to check for call compatibility.
102: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END IF;
105: -- Initialize message list if p_init_msg_list is set to TRUE.
106: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

99: -- Standard Start of API savepoint
100: SAVEPOINT g_validate_row_GRP;
101: -- Standard call to check for call compatibility.
102: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END IF;
105: -- Initialize message list if p_init_msg_list is set to TRUE.
106: IF FND_API.to_Boolean( p_init_msg_list ) THEN
107: FND_MSG_PUB.initialize;

Line 106: IF FND_API.to_Boolean( p_init_msg_list ) THEN

102: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END IF;
105: -- Initialize message list if p_init_msg_list is set to TRUE.
106: IF FND_API.to_Boolean( p_init_msg_list ) THEN
107: FND_MSG_PUB.initialize;
108: END IF;
109: -- Initialize API return status to success
110: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 110: x_return_status := FND_API.G_RET_STS_SUCCESS;

106: IF FND_API.to_Boolean( p_init_msg_list ) THEN
107: FND_MSG_PUB.initialize;
108: END IF;
109: -- Initialize API return status to success
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111:
112: --------------------------------------------
113: -- Calling Simple API for Validation
114: --------------------------------------------

Line 164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 166: RAISE FND_API.G_EXC_ERROR ;

162: --------------------------------------------
163: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
165: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
166: RAISE FND_API.G_EXC_ERROR ;
167: END IF;
168: --------------------------------------------
169:
170: -- Standard call to get message count and if count is 1, get message info.

Line 178: WHEN FND_API.G_EXC_ERROR THEN

174: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving validate_row');
175: END IF;
176:
177: EXCEPTION
178: WHEN FND_API.G_EXC_ERROR THEN
179: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
180: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception');
181: END IF;
182: ROLLBACK TO g_validate_row_GRP;

Line 186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

182: ROLLBACK TO g_validate_row_GRP;
183: x_return_status := G_RET_STS_ERROR ;
184: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
185:
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
188: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
189: END IF;
190: ROLLBACK TO g_validate_row_GRP;

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

210: -------------------------------------
211: PROCEDURE create_template(
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 ,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_commit IN VARCHAR2 := FND_API.G_FALSE,
216:
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,

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

211: PROCEDURE create_template(
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 ,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_commit IN VARCHAR2 := FND_API.G_FALSE,
216:
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,

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

284:
285: -- Standard Start of API savepoint
286: SAVEPOINT g_insert_row_GRP;
287: -- Standard call to check for call compatibility.
288: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291: -- Initialize message list if p_init_msg_list is set to TRUE.
292: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

285: -- Standard Start of API savepoint
286: SAVEPOINT g_insert_row_GRP;
287: -- Standard call to check for call compatibility.
288: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291: -- Initialize message list if p_init_msg_list is set to TRUE.
292: IF FND_API.to_Boolean( p_init_msg_list ) THEN
293: FND_MSG_PUB.initialize;

Line 292: IF FND_API.to_Boolean( p_init_msg_list ) THEN

288: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291: -- Initialize message list if p_init_msg_list is set to TRUE.
292: IF FND_API.to_Boolean( p_init_msg_list ) THEN
293: FND_MSG_PUB.initialize;
294: END IF;
295: -- Initialize API return status to success
296: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 296: x_return_status := FND_API.G_RET_STS_SUCCESS;

292: IF FND_API.to_Boolean( p_init_msg_list ) THEN
293: FND_MSG_PUB.initialize;
294: END IF;
295: -- Initialize API return status to success
296: x_return_status := FND_API.G_RET_STS_SUCCESS;
297:
298: --------------------------------------------
299: -- Calling Simple API for Creating A Row
300: --------------------------------------------

Line 351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

347: x_template_id => x_template_id
348: );
349: --------------------------------------------
350: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
352: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
353: RAISE FND_API.G_EXC_ERROR ;
354: END IF;
355: --------------------------------------------

Line 353: RAISE FND_API.G_EXC_ERROR ;

349: --------------------------------------------
350: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
352: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
353: RAISE FND_API.G_EXC_ERROR ;
354: END IF;
355: --------------------------------------------
356:
357: -- Standard check of p_commit

Line 358: IF FND_API.To_Boolean( p_commit ) THEN

354: END IF;
355: --------------------------------------------
356:
357: -- Standard check of p_commit
358: IF FND_API.To_Boolean( p_commit ) THEN
359: COMMIT WORK;
360: END IF;
361: -- Standard call to get message count and if count is 1, get message info.
362: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 369: WHEN FND_API.G_EXC_ERROR THEN

365: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Leaving create_template');
366: END IF;
367:
368: EXCEPTION
369: WHEN FND_API.G_EXC_ERROR THEN
370: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving create_template: OKC_API.G_EXCEPTION_ERROR Exception');
372: END IF;
373: ROLLBACK TO g_insert_row_GRP;

Line 377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

373: ROLLBACK TO g_insert_row_GRP;
374: x_return_status := G_RET_STS_ERROR ;
375: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
376:
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
379: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving create_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
380: END IF;
381: ROLLBACK TO g_insert_row_GRP;

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

419:
420: -- Standard Start of API savepoint
421: SAVEPOINT g_lock_row_GRP;
422: -- Standard call to check for call compatibility.
423: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: END IF;
426: -- Initialize message list if p_init_msg_list is set to TRUE.
427: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

420: -- Standard Start of API savepoint
421: SAVEPOINT g_lock_row_GRP;
422: -- Standard call to check for call compatibility.
423: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: END IF;
426: -- Initialize message list if p_init_msg_list is set to TRUE.
427: IF FND_API.to_Boolean( p_init_msg_list ) THEN
428: FND_MSG_PUB.initialize;

Line 427: IF FND_API.to_Boolean( p_init_msg_list ) THEN

423: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: END IF;
426: -- Initialize message list if p_init_msg_list is set to TRUE.
427: IF FND_API.to_Boolean( p_init_msg_list ) THEN
428: FND_MSG_PUB.initialize;
429: END IF;
430: -- Initialize API return status to success
431: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 431: x_return_status := FND_API.G_RET_STS_SUCCESS;

427: IF FND_API.to_Boolean( p_init_msg_list ) THEN
428: FND_MSG_PUB.initialize;
429: END IF;
430: -- Initialize API return status to success
431: x_return_status := FND_API.G_RET_STS_SUCCESS;
432:
433: --------------------------------------------
434: -- Calling Simple API for Locking A Row
435: --------------------------------------------

Line 443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 445: RAISE FND_API.G_EXC_ERROR ;

441: --------------------------------------------
442: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
444: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
445: RAISE FND_API.G_EXC_ERROR ;
446: END IF;
447: --------------------------------------------
448:
449: -- 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,'1200: Leaving lock_row');
454: END IF;
455:
456: EXCEPTION
457: WHEN FND_API.G_EXC_ERROR THEN
458: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
459: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception');
460: END IF;
461: ROLLBACK TO g_lock_row_GRP;

Line 465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

488: ---------------------------------------------------------------------------
489: PROCEDURE update_template(
490: p_api_version IN NUMBER,
491: p_init_msg_list IN VARCHAR2 ,
492: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
493: p_commit IN VARCHAR2 := FND_API.G_FALSE,
494:
495: x_return_status OUT NOCOPY VARCHAR2,
496: x_msg_count OUT NOCOPY NUMBER,

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

489: PROCEDURE update_template(
490: p_api_version IN NUMBER,
491: p_init_msg_list IN VARCHAR2 ,
492: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
493: p_commit IN VARCHAR2 := FND_API.G_FALSE,
494:
495: x_return_status OUT NOCOPY VARCHAR2,
496: x_msg_count OUT NOCOPY NUMBER,
497: x_msg_data OUT NOCOPY VARCHAR2,

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

558:
559: -- Standard Start of API savepoint
560: SAVEPOINT g_update_row_GRP;
561: -- Standard call to check for call compatibility.
562: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564: END IF;
565: -- Initialize message list if p_init_msg_list is set to TRUE.
566: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

559: -- Standard Start of API savepoint
560: SAVEPOINT g_update_row_GRP;
561: -- Standard call to check for call compatibility.
562: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564: END IF;
565: -- Initialize message list if p_init_msg_list is set to TRUE.
566: IF FND_API.to_Boolean( p_init_msg_list ) THEN
567: FND_MSG_PUB.initialize;

Line 566: IF FND_API.to_Boolean( p_init_msg_list ) THEN

562: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564: END IF;
565: -- Initialize message list if p_init_msg_list is set to TRUE.
566: IF FND_API.to_Boolean( p_init_msg_list ) THEN
567: FND_MSG_PUB.initialize;
568: END IF;
569: -- Initialize API return status to success
570: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 570: x_return_status := FND_API.G_RET_STS_SUCCESS;

566: IF FND_API.to_Boolean( p_init_msg_list ) THEN
567: FND_MSG_PUB.initialize;
568: END IF;
569: -- Initialize API return status to success
570: x_return_status := FND_API.G_RET_STS_SUCCESS;
571:
572: --------------------------------------------
573: -- Calling Simple API for Updating A Row
574: --------------------------------------------

Line 625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

621: p_object_version_number => p_object_version_number
622: );
623: --------------------------------------------
624: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
626: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
627: RAISE FND_API.G_EXC_ERROR ;
628: END IF;
629: --------------------------------------------

Line 627: RAISE FND_API.G_EXC_ERROR ;

623: --------------------------------------------
624: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
626: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
627: RAISE FND_API.G_EXC_ERROR ;
628: END IF;
629: --------------------------------------------
630:
631:

Line 633: IF FND_API.To_Boolean( p_commit ) THEN

629: --------------------------------------------
630:
631:
632: -- Standard check of p_commit
633: IF FND_API.To_Boolean( p_commit ) THEN
634: COMMIT WORK;
635: END IF;
636: -- Standard call to get message count and if count is 1, get message info.
637: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 644: WHEN FND_API.G_EXC_ERROR THEN

640: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Leaving update_template');
641: END IF;
642:
643: EXCEPTION
644: WHEN FND_API.G_EXC_ERROR THEN
645: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
646: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1900: Leaving update_template: OKC_API.G_EXCEPTION_ERROR Exception');
647: END IF;
648: ROLLBACK TO g_update_row_GRP;

Line 652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

648: ROLLBACK TO g_update_row_GRP;
649: x_return_status := G_RET_STS_ERROR ;
650: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
651:
652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
653: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
654: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving update_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
655: END IF;
656: ROLLBACK TO g_update_row_GRP;

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

676: ---------------------------------------------------------------------------
677: PROCEDURE delete_template(
678: p_api_version IN NUMBER,
679: p_init_msg_list IN VARCHAR2 ,
680: p_commit IN VARCHAR2 := FND_API.G_FALSE,
681:
682: x_return_status OUT NOCOPY VARCHAR2,
683: x_msg_count OUT NOCOPY NUMBER,
684: x_msg_data OUT NOCOPY VARCHAR2,

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

696:
697: -- Standard Start of API savepoint
698: SAVEPOINT g_delete_row_GRP;
699: -- Standard call to check for call compatibility.
700: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END IF;
703: -- Initialize message list if p_init_msg_list is set to TRUE.
704: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

697: -- Standard Start of API savepoint
698: SAVEPOINT g_delete_row_GRP;
699: -- Standard call to check for call compatibility.
700: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END IF;
703: -- Initialize message list if p_init_msg_list is set to TRUE.
704: IF FND_API.to_Boolean( p_init_msg_list ) THEN
705: FND_MSG_PUB.initialize;

Line 704: IF FND_API.to_Boolean( p_init_msg_list ) THEN

700: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END IF;
703: -- Initialize message list if p_init_msg_list is set to TRUE.
704: IF FND_API.to_Boolean( p_init_msg_list ) THEN
705: FND_MSG_PUB.initialize;
706: END IF;
707: -- Initialize API return status to success
708: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 708: x_return_status := FND_API.G_RET_STS_SUCCESS;

704: IF FND_API.to_Boolean( p_init_msg_list ) THEN
705: FND_MSG_PUB.initialize;
706: END IF;
707: -- Initialize API return status to success
708: x_return_status := FND_API.G_RET_STS_SUCCESS;
709:
710: --------------------------------------------
711: -- Calling Simple API for Deleting A Row
712: --------------------------------------------

Line 720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

716: p_object_version_number => p_object_version_number
717: );
718: --------------------------------------------
719: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
721: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
722: RAISE FND_API.G_EXC_ERROR ;
723: END IF;
724: --------------------------------------------

Line 722: RAISE FND_API.G_EXC_ERROR ;

718: --------------------------------------------
719: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
721: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
722: RAISE FND_API.G_EXC_ERROR ;
723: END IF;
724: --------------------------------------------
725:
726: -- Standard check of p_commit

Line 727: IF FND_API.To_Boolean( p_commit ) THEN

723: END IF;
724: --------------------------------------------
725:
726: -- Standard check of p_commit
727: IF FND_API.To_Boolean( p_commit ) THEN
728: COMMIT WORK;
729: END IF;
730: -- Standard call to get message count and if count is 1, get message info.
731: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 738: WHEN FND_API.G_EXC_ERROR THEN

734: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving delete_template');
735: END IF;
736:
737: EXCEPTION
738: WHEN FND_API.G_EXC_ERROR THEN
739: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
740: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving delete_template: OKC_API.G_EXCEPTION_ERROR Exception');
741: END IF;
742: ROLLBACK TO g_delete_row_GRP;

Line 746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

742: ROLLBACK TO g_delete_row_GRP;
743: x_return_status := G_RET_STS_ERROR ;
744: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
745:
746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
747: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
748: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving delete_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
749: END IF;
750: ROLLBACK TO g_delete_row_GRP;