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

77:
78: -- Standard Start of API savepoint
79: SAVEPOINT g_Validate_Allowed_Usages_GRP;
80: -- Standard call to check for call compatibility.
81: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84: -- Initialize message list if p_init_msg_list is set to TRUE.
85: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

78: -- Standard Start of API savepoint
79: SAVEPOINT g_Validate_Allowed_Usages_GRP;
80: -- Standard call to check for call compatibility.
81: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84: -- Initialize message list if p_init_msg_list is set to TRUE.
85: IF FND_API.to_Boolean( p_init_msg_list ) THEN
86: FND_MSG_PUB.initialize;

Line 85: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 89: x_return_status := FND_API.G_RET_STS_SUCCESS;

85: IF FND_API.to_Boolean( p_init_msg_list ) THEN
86: FND_MSG_PUB.initialize;
87: END IF;
88: -- Initialize API return status to success
89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90:
91: --------------------------------------------
92: -- Calling Simple API for Validation
93: --------------------------------------------

Line 121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

117: p_object_version_number => p_object_version_number
118: );
119: --------------------------------------------
120: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
122: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
123: RAISE FND_API.G_EXC_ERROR ;
124: END IF;
125: --------------------------------------------

Line 123: RAISE FND_API.G_EXC_ERROR ;

119: --------------------------------------------
120: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
122: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
123: RAISE FND_API.G_EXC_ERROR ;
124: END IF;
125: --------------------------------------------
126:
127: -- Standard call to get message count and if count is 1, get message info.

Line 135: WHEN FND_API.G_EXC_ERROR THEN

131: okc_debug.log('200: Leaving Validate_Allowed_Tmpl_Usages', 2);
132: END IF;
133:
134: EXCEPTION
135: WHEN FND_API.G_EXC_ERROR THEN
136: IF (l_debug = 'Y') THEN
137: okc_debug.log('300: Leaving Validate_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
138: END IF;
139: ROLLBACK TO g_Validate_Allowed_Usages_GRP;

Line 143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

139: ROLLBACK TO g_Validate_Allowed_Usages_GRP;
140: x_return_status := G_RET_STS_ERROR ;
141: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
142:
143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
144: IF (l_debug = 'Y') THEN
145: okc_debug.log('400: Leaving Validate_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
146: END IF;
147: ROLLBACK TO g_Validate_Allowed_Usages_GRP;

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

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

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

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

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

217:
218: -- Standard Start of API savepoint
219: SAVEPOINT g_Create_Allowed_Usages_GRP;
220: -- Standard call to check for call compatibility.
221: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224: -- Initialize message list if p_init_msg_list is set to TRUE.
225: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

218: -- Standard Start of API savepoint
219: SAVEPOINT g_Create_Allowed_Usages_GRP;
220: -- Standard call to check for call compatibility.
221: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224: -- Initialize message list if p_init_msg_list is set to TRUE.
225: IF FND_API.to_Boolean( p_init_msg_list ) THEN
226: FND_MSG_PUB.initialize;

Line 225: IF FND_API.to_Boolean( p_init_msg_list ) THEN

221: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224: -- Initialize message list if p_init_msg_list is set to TRUE.
225: IF FND_API.to_Boolean( p_init_msg_list ) THEN
226: FND_MSG_PUB.initialize;
227: END IF;
228: -- Initialize API return status to success
229: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 229: x_return_status := FND_API.G_RET_STS_SUCCESS;

225: IF FND_API.to_Boolean( p_init_msg_list ) THEN
226: FND_MSG_PUB.initialize;
227: END IF;
228: -- Initialize API return status to success
229: x_return_status := FND_API.G_RET_STS_SUCCESS;
230:
231: --------------------------------------------
232: -- Calling Simple API for Creating A Row
233: --------------------------------------------

Line 261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

257: x_allowed_tmpl_usages_id => x_allowed_tmpl_usages_id
258: );
259: --------------------------------------------
260: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
262: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
263: RAISE FND_API.G_EXC_ERROR ;
264: END IF;
265: --------------------------------------------

Line 263: RAISE FND_API.G_EXC_ERROR ;

259: --------------------------------------------
260: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
262: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
263: RAISE FND_API.G_EXC_ERROR ;
264: END IF;
265: --------------------------------------------
266:
267: -- Standard check of p_commit

Line 268: IF FND_API.To_Boolean( p_commit ) THEN

264: END IF;
265: --------------------------------------------
266:
267: -- Standard check of p_commit
268: IF FND_API.To_Boolean( p_commit ) THEN
269: COMMIT WORK;
270: END IF;
271: -- Standard call to get message count and if count is 1, get message info.
272: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 279: WHEN FND_API.G_EXC_ERROR THEN

275: okc_debug.log('700: Leaving Create_Allowed_Tmpl_Usages', 2);
276: END IF;
277:
278: EXCEPTION
279: WHEN FND_API.G_EXC_ERROR THEN
280: IF (l_debug = 'Y') THEN
281: okc_debug.log('800: Leaving Create_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
282: END IF;
283: ROLLBACK TO g_Create_Allowed_Usages_GRP;

Line 287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

283: ROLLBACK TO g_Create_Allowed_Usages_GRP;
284: x_return_status := G_RET_STS_ERROR ;
285: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
286:
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288: IF (l_debug = 'Y') THEN
289: okc_debug.log('900: Leaving Create_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
290: END IF;
291: ROLLBACK TO g_Create_Allowed_Usages_GRP;

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

329:
330: -- Standard Start of API savepoint
331: SAVEPOINT g_Lock_Allowed_Usages_GRP;
332: -- Standard call to check for call compatibility.
333: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336: -- Initialize message list if p_init_msg_list is set to TRUE.
337: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

330: -- Standard Start of API savepoint
331: SAVEPOINT g_Lock_Allowed_Usages_GRP;
332: -- Standard call to check for call compatibility.
333: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336: -- Initialize message list if p_init_msg_list is set to TRUE.
337: IF FND_API.to_Boolean( p_init_msg_list ) THEN
338: FND_MSG_PUB.initialize;

Line 337: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 341: x_return_status := FND_API.G_RET_STS_SUCCESS;

337: IF FND_API.to_Boolean( p_init_msg_list ) THEN
338: FND_MSG_PUB.initialize;
339: END IF;
340: -- Initialize API return status to success
341: x_return_status := FND_API.G_RET_STS_SUCCESS;
342:
343: --------------------------------------------
344: -- Calling Simple API for Locking A Row
345: --------------------------------------------

Line 353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 355: RAISE FND_API.G_EXC_ERROR ;

351: --------------------------------------------
352: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
354: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
355: RAISE FND_API.G_EXC_ERROR ;
356: END IF;
357: --------------------------------------------
358:
359: -- Standard call to get message count and if count is 1, get message info.

Line 367: WHEN FND_API.G_EXC_ERROR THEN

363: okc_debug.log('1200: Leaving Lock_Allowed_Tmpl_Usages', 2);
364: END IF;
365:
366: EXCEPTION
367: WHEN FND_API.G_EXC_ERROR THEN
368: IF (l_debug = 'Y') THEN
369: okc_debug.log('1300: Leaving Lock_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
370: END IF;
371: ROLLBACK TO g_Lock_Allowed_Usages_GRP;

Line 375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

371: ROLLBACK TO g_Lock_Allowed_Usages_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 (l_debug = 'Y') THEN
377: okc_debug.log('1400: Leaving Lock_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
378: END IF;
379: ROLLBACK TO g_Lock_Allowed_Usages_GRP;

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

398: ---------------------------------------------------------------------------
399: PROCEDURE Update_Allowed_Tmpl_Usages(
400: p_api_version IN NUMBER,
401: p_init_msg_list IN VARCHAR2 ,
402: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404:
405: x_return_status OUT NOCOPY VARCHAR2,
406: x_msg_count OUT NOCOPY NUMBER,

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

399: PROCEDURE Update_Allowed_Tmpl_Usages(
400: p_api_version IN NUMBER,
401: p_init_msg_list IN VARCHAR2 ,
402: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404:
405: x_return_status OUT NOCOPY VARCHAR2,
406: x_msg_count OUT NOCOPY NUMBER,
407: x_msg_data OUT NOCOPY VARCHAR2,

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

444:
445: -- Standard Start of API savepoint
446: SAVEPOINT g_Update_Allowed_Usages_GRP;
447: -- Standard call to check for call compatibility.
448: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

445: -- Standard Start of API savepoint
446: SAVEPOINT g_Update_Allowed_Usages_GRP;
447: -- Standard call to check for call compatibility.
448: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.to_Boolean( p_init_msg_list ) THEN
453: FND_MSG_PUB.initialize;

Line 452: IF FND_API.to_Boolean( p_init_msg_list ) THEN

448: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.to_Boolean( p_init_msg_list ) THEN
453: FND_MSG_PUB.initialize;
454: END IF;
455: -- Initialize API return status to success
456: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 456: x_return_status := FND_API.G_RET_STS_SUCCESS;

452: IF FND_API.to_Boolean( p_init_msg_list ) THEN
453: FND_MSG_PUB.initialize;
454: END IF;
455: -- Initialize API return status to success
456: x_return_status := FND_API.G_RET_STS_SUCCESS;
457:
458: --------------------------------------------
459: -- Calling Simple API for Updating A Row
460: --------------------------------------------

Line 488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

484: p_object_version_number => p_object_version_number
485: );
486: --------------------------------------------
487: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
489: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
490: RAISE FND_API.G_EXC_ERROR ;
491: END IF;
492: --------------------------------------------

Line 490: RAISE FND_API.G_EXC_ERROR ;

486: --------------------------------------------
487: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
489: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
490: RAISE FND_API.G_EXC_ERROR ;
491: END IF;
492: --------------------------------------------
493:
494: -- Standard check of p_commit

Line 495: IF FND_API.To_Boolean( p_commit ) THEN

491: END IF;
492: --------------------------------------------
493:
494: -- Standard check of p_commit
495: IF FND_API.To_Boolean( p_commit ) THEN
496: COMMIT WORK;
497: END IF;
498: -- Standard call to get message count and if count is 1, get message info.
499: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 506: WHEN FND_API.G_EXC_ERROR THEN

502: okc_debug.log('1800: Leaving Update_Allowed_Tmpl_Usages', 2);
503: END IF;
504:
505: EXCEPTION
506: WHEN FND_API.G_EXC_ERROR THEN
507: IF (l_debug = 'Y') THEN
508: okc_debug.log('1900: Leaving Update_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
509: END IF;
510: ROLLBACK TO g_Update_Allowed_Usages_GRP;

Line 514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

510: ROLLBACK TO g_Update_Allowed_Usages_GRP;
511: x_return_status := G_RET_STS_ERROR ;
512: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: IF (l_debug = 'Y') THEN
516: okc_debug.log('2000: Leaving Update_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
517: END IF;
518: ROLLBACK TO g_Update_Allowed_Usages_GRP;

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

538: ---------------------------------------------------------------------------
539: PROCEDURE Delete_Allowed_Tmpl_Usages(
540: p_api_version IN NUMBER,
541: p_init_msg_list IN VARCHAR2 ,
542: p_commit IN VARCHAR2 := FND_API.G_FALSE,
543:
544: x_return_status OUT NOCOPY VARCHAR2,
545: x_msg_count OUT NOCOPY NUMBER,
546: 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_Delete_Allowed_Usages_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_Delete_Allowed_Usages_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 Deleting A Row
574: --------------------------------------------

Line 582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

578: p_object_version_number => p_object_version_number
579: );
580: --------------------------------------------
581: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
583: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
584: RAISE FND_API.G_EXC_ERROR ;
585: END IF;
586: --------------------------------------------

Line 584: RAISE FND_API.G_EXC_ERROR ;

580: --------------------------------------------
581: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
583: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
584: RAISE FND_API.G_EXC_ERROR ;
585: END IF;
586: --------------------------------------------
587:
588: -- Standard check of p_commit

Line 589: IF FND_API.To_Boolean( p_commit ) THEN

585: END IF;
586: --------------------------------------------
587:
588: -- Standard check of p_commit
589: IF FND_API.To_Boolean( p_commit ) THEN
590: COMMIT WORK;
591: END IF;
592: -- Standard call to get message count and if count is 1, get message info.
593: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 600: WHEN FND_API.G_EXC_ERROR THEN

596: okc_debug.log('2300: Leaving Delete_Allowed_Tmpl_Usages', 2);
597: END IF;
598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: IF (l_debug = 'Y') THEN
602: okc_debug.log('2400: Leaving Delete_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
603: END IF;
604: ROLLBACK TO g_Delete_Allowed_Usages_GRP;

Line 608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

604: ROLLBACK TO g_Delete_Allowed_Usages_GRP;
605: x_return_status := G_RET_STS_ERROR ;
606: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
607:
608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
609: IF (l_debug = 'Y') THEN
610: okc_debug.log('2500: Leaving Delete_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
611: END IF;
612: ROLLBACK TO g_Delete_Allowed_Usages_GRP;