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_NUMBER_SCHEME_DTL_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 43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

39: ---------------------------------------
40: PROCEDURE Validate_Number_Scheme_Dtl(
41: p_api_version IN NUMBER,
42: p_init_msg_list IN VARCHAR2 ,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44:
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2,

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

72:
73: -- Standard Start of API savepoint
74: SAVEPOINT g_Validate_Num_Scheme_Dtl_GRP;
75: -- Standard call to check for call compatibility.
76: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END IF;
79: -- Initialize message list if p_init_msg_list is set to TRUE.
80: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

73: -- Standard Start of API savepoint
74: SAVEPOINT g_Validate_Num_Scheme_Dtl_GRP;
75: -- Standard call to check for call compatibility.
76: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END IF;
79: -- Initialize message list if p_init_msg_list is set to TRUE.
80: IF FND_API.to_Boolean( p_init_msg_list ) THEN
81: FND_MSG_PUB.initialize;

Line 80: IF FND_API.to_Boolean( p_init_msg_list ) THEN

76: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END IF;
79: -- Initialize message list if p_init_msg_list is set to TRUE.
80: IF FND_API.to_Boolean( p_init_msg_list ) THEN
81: FND_MSG_PUB.initialize;
82: END IF;
83: -- Initialize API return status to success
84: x_return_status := G_RET_STS_SUCCESS;

Line 101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

97: p_object_version_number => p_object_version_number
98: );
99: --------------------------------------------
100: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
102: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
103: RAISE FND_API.G_EXC_ERROR ;
104: END IF;
105: --------------------------------------------

Line 103: RAISE FND_API.G_EXC_ERROR ;

99: --------------------------------------------
100: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
102: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
103: RAISE FND_API.G_EXC_ERROR ;
104: END IF;
105: --------------------------------------------
106:
107: -- Standard call to get message count and if count is 1, get message info.

Line 120: WHEN FND_API.G_EXC_ERROR THEN

116: G_PKG_NAME, '200: Leaving Validate_Number_Scheme_Dtl' );
117: END IF;
118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN
121: /*IF (l_debug = 'Y') THEN
122: okc_debug.log('300: Leaving Validate_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception', 2);
123: END IF;*/
124:

Line 133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

129: ROLLBACK TO g_Validate_Num_Scheme_Dtl_GRP;
130: x_return_status := G_RET_STS_ERROR ;
131: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
132:
133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
134: /*IF (l_debug = 'Y') THEN
135: okc_debug.log('400: Leaving Validate_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
136: END IF;*/
137:

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

166: -------------------------------------
167: PROCEDURE Insert_Number_Scheme_Dtl(
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 ,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172:
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,

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

167: PROCEDURE Insert_Number_Scheme_Dtl(
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 ,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172:
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,

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

209:
210: -- Standard Start of API savepoint
211: SAVEPOINT g_Insert_Number_Scheme_Dtl_GRP;
212: -- Standard call to check for call compatibility.
213: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: END IF;
216: -- Initialize message list if p_init_msg_list is set to TRUE.
217: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

210: -- Standard Start of API savepoint
211: SAVEPOINT g_Insert_Number_Scheme_Dtl_GRP;
212: -- Standard call to check for call compatibility.
213: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: END IF;
216: -- Initialize message list if p_init_msg_list is set to TRUE.
217: IF FND_API.to_Boolean( p_init_msg_list ) THEN
218: FND_MSG_PUB.initialize;

Line 217: IF FND_API.to_Boolean( p_init_msg_list ) THEN

213: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: END IF;
216: -- Initialize message list if p_init_msg_list is set to TRUE.
217: IF FND_API.to_Boolean( p_init_msg_list ) THEN
218: FND_MSG_PUB.initialize;
219: END IF;
220: -- Initialize API return status to success
221: x_return_status := G_RET_STS_SUCCESS;

Line 240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

236: x_sequence_level => x_sequence_level
237: );
238: --------------------------------------------
239: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
241: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
242: RAISE FND_API.G_EXC_ERROR ;
243: END IF;
244: --------------------------------------------

Line 242: RAISE FND_API.G_EXC_ERROR ;

238: --------------------------------------------
239: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
241: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
242: RAISE FND_API.G_EXC_ERROR ;
243: END IF;
244: --------------------------------------------
245:
246: -- Standard check of p_commit

Line 247: IF FND_API.To_Boolean( p_commit ) THEN

243: END IF;
244: --------------------------------------------
245:
246: -- Standard check of p_commit
247: IF FND_API.To_Boolean( p_commit ) THEN
248: COMMIT WORK;
249: END IF;
250: -- Standard call to get message count and if count is 1, get message info.
251: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 263: WHEN FND_API.G_EXC_ERROR THEN

259: G_PKG_NAME, '700: Leaving Insert_Number_Scheme_Dtl' );
260: END IF;
261:
262: EXCEPTION
263: WHEN FND_API.G_EXC_ERROR THEN
264: /*IF (l_debug = 'Y') THEN
265: okc_debug.log('800: Leaving Insert_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception', 2);
266: END IF;*/
267:

Line 276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

272: ROLLBACK TO g_Insert_Number_Scheme_Dtl_GRP;
273: x_return_status := G_RET_STS_ERROR ;
274: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
275:
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: /*IF (l_debug = 'Y') THEN
278: okc_debug.log('900: Leaving Insert_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
279: END IF;*/
280:

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

334:
335: -- Standard Start of API savepoint
336: SAVEPOINT g_Lock_Number_Scheme_Dtl_GRP;
337: -- Standard call to check for call compatibility.
338: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;
341: -- Initialize message list if p_init_msg_list is set to TRUE.
342: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

335: -- Standard Start of API savepoint
336: SAVEPOINT g_Lock_Number_Scheme_Dtl_GRP;
337: -- Standard call to check for call compatibility.
338: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;
341: -- Initialize message list if p_init_msg_list is set to TRUE.
342: IF FND_API.to_Boolean( p_init_msg_list ) THEN
343: FND_MSG_PUB.initialize;

Line 342: IF FND_API.to_Boolean( p_init_msg_list ) THEN

338: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;
341: -- Initialize message list if p_init_msg_list is set to TRUE.
342: IF FND_API.to_Boolean( p_init_msg_list ) THEN
343: FND_MSG_PUB.initialize;
344: END IF;
345: -- Initialize API return status to success
346: x_return_status := G_RET_STS_SUCCESS;

Line 360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

356: p_object_version_number => p_object_version_number
357: );
358: --------------------------------------------
359: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
361: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
362: RAISE FND_API.G_EXC_ERROR ;
363: END IF;
364: --------------------------------------------

Line 362: RAISE FND_API.G_EXC_ERROR ;

358: --------------------------------------------
359: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
361: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
362: RAISE FND_API.G_EXC_ERROR ;
363: END IF;
364: --------------------------------------------
365:
366: -- Standard call to get message count and if count is 1, get message info.

Line 379: WHEN FND_API.G_EXC_ERROR THEN

375: G_PKG_NAME, '1200: Leaving Lock_Number_Scheme_Dtl' );
376: END IF;
377:
378: EXCEPTION
379: WHEN FND_API.G_EXC_ERROR THEN
380: /*IF (l_debug = 'Y') THEN
381: okc_debug.log('1300: Leaving Lock_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception', 2);
382: END IF;*/
383:

Line 392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

388: ROLLBACK TO g_Lock_Number_Scheme_Dtl_GRP;
389: x_return_status := G_RET_STS_ERROR ;
390: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393: /*IF (l_debug = 'Y') THEN
394: okc_debug.log('1400: Leaving Lock_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
395: END IF;*/
396:

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

424: ---------------------------------------------------------------------------
425: PROCEDURE Update_Number_Scheme_Dtl(
426: p_api_version IN NUMBER,
427: p_init_msg_list IN VARCHAR2 ,
428: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
429: p_commit IN VARCHAR2 := FND_API.G_FALSE,
430:
431: x_return_status OUT NOCOPY VARCHAR2,
432: x_msg_count OUT NOCOPY NUMBER,

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

425: PROCEDURE Update_Number_Scheme_Dtl(
426: p_api_version IN NUMBER,
427: p_init_msg_list IN VARCHAR2 ,
428: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
429: p_commit IN VARCHAR2 := FND_API.G_FALSE,
430:
431: x_return_status OUT NOCOPY VARCHAR2,
432: x_msg_count OUT NOCOPY NUMBER,
433: x_msg_data OUT NOCOPY VARCHAR2,

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

463:
464: -- Standard Start of API savepoint
465: SAVEPOINT g_Update_Number_Scheme_Dtl_GRP;
466: -- Standard call to check for call compatibility.
467: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
469: END IF;
470: -- Initialize message list if p_init_msg_list is set to TRUE.
471: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

464: -- Standard Start of API savepoint
465: SAVEPOINT g_Update_Number_Scheme_Dtl_GRP;
466: -- Standard call to check for call compatibility.
467: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
469: END IF;
470: -- Initialize message list if p_init_msg_list is set to TRUE.
471: IF FND_API.to_Boolean( p_init_msg_list ) THEN
472: FND_MSG_PUB.initialize;

Line 471: IF FND_API.to_Boolean( p_init_msg_list ) THEN

467: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
469: END IF;
470: -- Initialize message list if p_init_msg_list is set to TRUE.
471: IF FND_API.to_Boolean( p_init_msg_list ) THEN
472: FND_MSG_PUB.initialize;
473: END IF;
474: -- Initialize API return status to success
475: x_return_status := G_RET_STS_SUCCESS;

Line 492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

488: p_object_version_number => p_object_version_number
489: );
490: --------------------------------------------
491: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
493: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
494: RAISE FND_API.G_EXC_ERROR ;
495: END IF;
496: --------------------------------------------

Line 494: RAISE FND_API.G_EXC_ERROR ;

490: --------------------------------------------
491: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
493: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
494: RAISE FND_API.G_EXC_ERROR ;
495: END IF;
496: --------------------------------------------
497:
498: -- Standard check of p_commit

Line 499: IF FND_API.To_Boolean( p_commit ) THEN

495: END IF;
496: --------------------------------------------
497:
498: -- Standard check of p_commit
499: IF FND_API.To_Boolean( p_commit ) THEN
500: COMMIT WORK;
501: END IF;
502: -- Standard call to get message count and if count is 1, get message info.
503: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 515: WHEN FND_API.G_EXC_ERROR THEN

511: G_PKG_NAME, '1800: Leaving Update_Number_Scheme_Dtl' );
512: END IF;
513:
514: EXCEPTION
515: WHEN FND_API.G_EXC_ERROR THEN
516: /*IF (l_debug = 'Y') THEN
517: okc_debug.log('1900: Leaving Update_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception', 2);
518: END IF;*/
519:

Line 528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

524: ROLLBACK TO g_Update_Number_Scheme_Dtl_GRP;
525: x_return_status := G_RET_STS_ERROR ;
526: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
527:
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: /*IF (l_debug = 'Y') THEN
530: okc_debug.log('2000: Leaving Update_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
531: END IF;*/
532:

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

561: ---------------------------------------------------------------------------
562: PROCEDURE Delete_Number_Scheme_Dtl(
563: p_api_version IN NUMBER,
564: p_init_msg_list IN VARCHAR2 ,
565: p_commit IN VARCHAR2 := FND_API.G_FALSE,
566:
567: x_return_status OUT NOCOPY VARCHAR2,
568: x_msg_count OUT NOCOPY NUMBER,
569: x_msg_data OUT NOCOPY VARCHAR2,

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

588:
589: -- Standard Start of API savepoint
590: SAVEPOINT g_Delete_Number_Scheme_Dtl_GRP;
591: -- Standard call to check for call compatibility.
592: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
595: -- Initialize message list if p_init_msg_list is set to TRUE.
596: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

589: -- Standard Start of API savepoint
590: SAVEPOINT g_Delete_Number_Scheme_Dtl_GRP;
591: -- Standard call to check for call compatibility.
592: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
595: -- Initialize message list if p_init_msg_list is set to TRUE.
596: IF FND_API.to_Boolean( p_init_msg_list ) THEN
597: FND_MSG_PUB.initialize;

Line 596: IF FND_API.to_Boolean( p_init_msg_list ) THEN

592: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
595: -- Initialize message list if p_init_msg_list is set to TRUE.
596: IF FND_API.to_Boolean( p_init_msg_list ) THEN
597: FND_MSG_PUB.initialize;
598: END IF;
599: -- Initialize API return status to success
600: x_return_status := G_RET_STS_SUCCESS;

Line 614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

610: p_object_version_number => p_object_version_number
611: );
612: --------------------------------------------
613: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
615: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
616: RAISE FND_API.G_EXC_ERROR ;
617: END IF;
618: --------------------------------------------

Line 616: RAISE FND_API.G_EXC_ERROR ;

612: --------------------------------------------
613: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
615: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
616: RAISE FND_API.G_EXC_ERROR ;
617: END IF;
618: --------------------------------------------
619:
620: -- Standard check of p_commit

Line 621: IF FND_API.To_Boolean( p_commit ) THEN

617: END IF;
618: --------------------------------------------
619:
620: -- Standard check of p_commit
621: IF FND_API.To_Boolean( p_commit ) THEN
622: COMMIT WORK;
623: END IF;
624: -- Standard call to get message count and if count is 1, get message info.
625: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 637: WHEN FND_API.G_EXC_ERROR THEN

633: G_PKG_NAME, '2300: Leaving Delete_Number_Scheme_Dtl' );
634: END IF;
635:
636: EXCEPTION
637: WHEN FND_API.G_EXC_ERROR THEN
638: /*IF (l_debug = 'Y') THEN
639: okc_debug.log('2400: Leaving Delete_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception', 2);
640: END IF;*/
641:

Line 650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

646: ROLLBACK TO g_Delete_Number_Scheme_Dtl_GRP;
647: x_return_status := G_RET_STS_ERROR ;
648: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
649:
650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
651: /*IF (l_debug = 'Y') THEN
652: okc_debug.log('2500: Leaving Delete_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
653: END IF;*/
654: