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

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

Line 288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 291: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 295: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 351: RAISE FND_API.G_EXC_ERROR ;

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

Line 356: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 367: WHEN FND_API.G_EXC_ERROR THEN

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

Line 375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

Line 422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 425: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 429: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 443: RAISE FND_API.G_EXC_ERROR ;

439: --------------------------------------------
440: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
442: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
443: RAISE FND_API.G_EXC_ERROR ;
444: END IF;
445: --------------------------------------------
446:
447: -- Standard call to get message count and if count is 1, get message info.

Line 455: WHEN FND_API.G_EXC_ERROR THEN

451: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1200: Leaving lock_row');
452: END IF;
453:
454: EXCEPTION
455: WHEN FND_API.G_EXC_ERROR THEN
456: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
457: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception');
458: END IF;
459: ROLLBACK TO g_lock_row_GRP;

Line 463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

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

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

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

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

Line 560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 563: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 567: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

617: p_object_version_number => p_object_version_number
618: );
619: --------------------------------------------
620: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
622: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
623: RAISE FND_API.G_EXC_ERROR ;
624: END IF;
625: --------------------------------------------

Line 623: RAISE FND_API.G_EXC_ERROR ;

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

Line 629: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 640: WHEN FND_API.G_EXC_ERROR THEN

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

Line 648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

672: ---------------------------------------------------------------------------
673: PROCEDURE delete_template(
674: p_api_version IN NUMBER,
675: p_init_msg_list IN VARCHAR2 ,
676: p_commit IN VARCHAR2 := FND_API.G_FALSE,
677:
678: x_return_status OUT NOCOPY VARCHAR2,
679: x_msg_count OUT NOCOPY NUMBER,
680: x_msg_data OUT NOCOPY VARCHAR2,

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

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

Line 697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 700: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 704: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

712: p_object_version_number => p_object_version_number
713: );
714: --------------------------------------------
715: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
717: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
718: RAISE FND_API.G_EXC_ERROR ;
719: END IF;
720: --------------------------------------------

Line 718: RAISE FND_API.G_EXC_ERROR ;

714: --------------------------------------------
715: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
717: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
718: RAISE FND_API.G_EXC_ERROR ;
719: END IF;
720: --------------------------------------------
721:
722: -- Standard check of p_commit

Line 723: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 734: WHEN FND_API.G_EXC_ERROR THEN

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

Line 742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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