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.AS_SCORECARD_RULES_PUB dependencies on FND_API

Line 35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

31:
32:
33: Procedure Create_ScoreCard (
34: p_api_version IN NUMBER := 2.0,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,

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

32:
33: Procedure Create_ScoreCard (
34: p_api_version IN NUMBER := 2.0,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,

Line 56: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

52: -- Standard Start of API savepoint
53: SAVEPOINT CREATE_SCORECARD_PUB;
54:
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
57: p_api_version,
58: l_api_name,
59: G_PKG_NAME)
60: THEN

Line 61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

57: p_api_version,
58: l_api_name,
59: G_PKG_NAME)
60: THEN
61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
62: END IF;
63:
64:
65: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 66: IF FND_API.to_Boolean( p_init_msg_list )

62: END IF;
63:
64:
65: -- Initialize message list if p_init_msg_list is set to TRUE.
66: IF FND_API.to_Boolean( p_init_msg_list )
67: THEN
68: FND_MSG_PUB.initialize;
69: END IF;
70:

Line 80: x_return_status := FND_API.G_RET_STS_SUCCESS;

76: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
77:
78:
79: -- Initialize API return status to SUCCESS
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: --
83: -- API body
84: --

Line 92: , p_init_msg_list => FND_API.G_FALSE

88: 'Public API: Calling AS_SCORECARD_RULES_PVT.Create_Scorecard');
89:
90: AS_SCORECARD_RULES_PVT.Create_ScoreCard(
91: p_api_version => p_api_version
92: , p_init_msg_list => FND_API.G_FALSE
93: , p_commit => p_commit
94: , p_validation_level => p_validation_level
95: , p_scorecard_rec => p_scorecard_rec
96: , x_scorecard_id => x_scorecard_id

Line 103: IF x_return_status = FND_API.G_RET_STS_ERROR then

99: , x_msg_data => x_msg_data
100: );
101:
102:
103: IF x_return_status = FND_API.G_RET_STS_ERROR then
104: raise FND_API.G_EXC_ERROR;
105: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
106: raise FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;

Line 104: raise FND_API.G_EXC_ERROR;

100: );
101:
102:
103: IF x_return_status = FND_API.G_RET_STS_ERROR then
104: raise FND_API.G_EXC_ERROR;
105: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
106: raise FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:

Line 105: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

101:
102:
103: IF x_return_status = FND_API.G_RET_STS_ERROR then
104: raise FND_API.G_EXC_ERROR;
105: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
106: raise FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109: --

Line 106: raise FND_API.G_EXC_UNEXPECTED_ERROR;

102:
103: IF x_return_status = FND_API.G_RET_STS_ERROR then
104: raise FND_API.G_EXC_ERROR;
105: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
106: raise FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109: --
110: -- End of API body

Line 114: IF FND_API.to_Boolean( p_commit )

110: -- End of API body
111: --
112:
113: -- Standard check for p_commit
114: IF FND_API.to_Boolean( p_commit )
115: THEN
116: COMMIT WORK;
117: END IF;
118:

Line 132: WHEN FND_API.G_EXC_ERROR THEN

128: p_data => x_msg_data
129: );
130:
131: EXCEPTION
132: WHEN FND_API.G_EXC_ERROR THEN
133: as_utility_pvt.HANDLE_EXCEPTIONS(
134: P_API_NAME => L_API_NAME
135: ,P_PKG_NAME => G_PKG_NAME
136: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

138: ,X_MSG_COUNT => X_MSG_COUNT
139: ,X_MSG_DATA => X_MSG_DATA
140: ,X_RETURN_STATUS => X_RETURN_STATUS);
141:
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143: as_utility_pvt.HANDLE_EXCEPTIONS(
144: P_API_NAME => L_API_NAME
145: ,P_PKG_NAME => G_PKG_NAME
146: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

165:
166:
167: Procedure Update_ScoreCard (
168: p_api_version IN NUMBER := 2.0,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,

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

166:
167: Procedure Update_ScoreCard (
168: p_api_version IN NUMBER := 2.0,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,

Line 190: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

186: -- Standard Start of API savepoint
187: SAVEPOINT UPDATE_SCORECARD_PUB;
188:
189: -- Standard call to check for call compatibility.
190: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
191: p_api_version,
192: l_api_name,
193: G_PKG_NAME)
194: THEN

Line 195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

191: p_api_version,
192: l_api_name,
193: G_PKG_NAME)
194: THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
197:
198: -- Initialize message list if p_init_msg_list is set to TRUE.
199: IF FND_API.to_Boolean( p_init_msg_list )

Line 199: IF FND_API.to_Boolean( p_init_msg_list )

195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
197:
198: -- Initialize message list if p_init_msg_list is set to TRUE.
199: IF FND_API.to_Boolean( p_init_msg_list )
200: THEN
201: FND_MSG_PUB.initialize;
202: END IF;
203:

Line 212: x_return_status := FND_API.G_RET_STS_SUCCESS;

208: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
209:
210:
211: -- Initialize API return status to SUCCESS
212: x_return_status := FND_API.G_RET_STS_SUCCESS;
213:
214: --
215: -- Api body
216: --

Line 233: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

229: , x_msg_count => x_msg_count
230: , x_msg_data => x_msg_data
231: );
232:
233: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
234: RAISE FND_API.G_EXC_ERROR;
235: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
236: raise FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;

Line 234: RAISE FND_API.G_EXC_ERROR;

230: , x_msg_data => x_msg_data
231: );
232:
233: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
234: RAISE FND_API.G_EXC_ERROR;
235: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
236: raise FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:

Line 235: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

231: );
232:
233: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
234: RAISE FND_API.G_EXC_ERROR;
235: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
236: raise FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:
239: --

Line 236: raise FND_API.G_EXC_UNEXPECTED_ERROR;

232:
233: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
234: RAISE FND_API.G_EXC_ERROR;
235: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
236: raise FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:
239: --
240: -- End of API body.

Line 244: IF FND_API.to_Boolean( p_commit )

240: -- End of API body.
241: --
242:
243: -- Standard check for p_commit
244: IF FND_API.to_Boolean( p_commit )
245: THEN
246: COMMIT WORK;
247: END IF;
248:

Line 261: WHEN FND_API.G_EXC_ERROR THEN

257: ( p_count => x_msg_count,
258: p_data => x_msg_data );
259:
260: EXCEPTION
261: WHEN FND_API.G_EXC_ERROR THEN
262: as_utility_pvt.HANDLE_EXCEPTIONS(
263: P_API_NAME => L_API_NAME
264: ,P_PKG_NAME => G_PKG_NAME
265: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

267: ,X_MSG_COUNT => X_MSG_COUNT
268: ,X_MSG_DATA => X_MSG_DATA
269: ,X_RETURN_STATUS => X_RETURN_STATUS);
270:
271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: as_utility_pvt.HANDLE_EXCEPTIONS(
273: P_API_NAME => L_API_NAME
274: ,P_PKG_NAME => G_PKG_NAME
275: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 297: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

293:
294:
295: Procedure Delete_ScoreCard (
296: p_api_version IN NUMBER := 2.0,
297: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
298: p_commit IN VARCHAR2 := FND_API.G_FALSE,
299: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_count OUT NOCOPY NUMBER,

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

294:
295: Procedure Delete_ScoreCard (
296: p_api_version IN NUMBER := 2.0,
297: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
298: p_commit IN VARCHAR2 := FND_API.G_FALSE,
299: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_count OUT NOCOPY NUMBER,
302: x_msg_data OUT NOCOPY VARCHAR2,

Line 318: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

314: -- Standard Start of API savepoint
315: SAVEPOINT DELETE_SCORECARD_PUB;
316:
317: -- Standard call to check for call compatibility.
318: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
319: p_api_version,
320: l_api_name,
321: G_PKG_NAME)
322: THEN

Line 323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

319: p_api_version,
320: l_api_name,
321: G_PKG_NAME)
322: THEN
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;
325:
326: -- Initialize message list if p_init_msg_list is set to TRUE.
327: IF FND_API.to_Boolean( p_init_msg_list )

Line 327: IF FND_API.to_Boolean( p_init_msg_list )

323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;
325:
326: -- Initialize message list if p_init_msg_list is set to TRUE.
327: IF FND_API.to_Boolean( p_init_msg_list )
328: THEN
329: FND_MSG_PUB.initialize;
330: END IF;
331:

Line 340: x_return_status := FND_API.G_RET_STS_SUCCESS;

336: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
337:
338:
339: -- Initialize API return status to SUCCESS
340: x_return_status := FND_API.G_RET_STS_SUCCESS;
341:
342: --
343: -- Api body
344: --

Line 362: IF x_return_status = FND_API.G_RET_STS_ERROR then

358: );
359: --shdeshpa
360: -- delete from as_scorecard_qual_rules where scorecard_id = p_scorecard_id
361:
362: IF x_return_status = FND_API.G_RET_STS_ERROR then
363: raise FND_API.G_EXC_ERROR;
364: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
365: raise FND_API.G_EXC_UNEXPECTED_ERROR;
366: END IF;

Line 363: raise FND_API.G_EXC_ERROR;

359: --shdeshpa
360: -- delete from as_scorecard_qual_rules where scorecard_id = p_scorecard_id
361:
362: IF x_return_status = FND_API.G_RET_STS_ERROR then
363: raise FND_API.G_EXC_ERROR;
364: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
365: raise FND_API.G_EXC_UNEXPECTED_ERROR;
366: END IF;
367:

Line 364: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

360: -- delete from as_scorecard_qual_rules where scorecard_id = p_scorecard_id
361:
362: IF x_return_status = FND_API.G_RET_STS_ERROR then
363: raise FND_API.G_EXC_ERROR;
364: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
365: raise FND_API.G_EXC_UNEXPECTED_ERROR;
366: END IF;
367:
368: --

Line 365: raise FND_API.G_EXC_UNEXPECTED_ERROR;

361:
362: IF x_return_status = FND_API.G_RET_STS_ERROR then
363: raise FND_API.G_EXC_ERROR;
364: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
365: raise FND_API.G_EXC_UNEXPECTED_ERROR;
366: END IF;
367:
368: --
369: -- End of API body

Line 373: IF FND_API.to_Boolean( p_commit )

369: -- End of API body
370: --
371:
372: -- Standard check for p_commit
373: IF FND_API.to_Boolean( p_commit )
374: THEN
375: COMMIT WORK;
376: END IF;
377:

Line 389: WHEN FND_API.G_EXC_ERROR THEN

385: ( p_count => x_msg_count,
386: p_data => x_msg_data );
387:
388: EXCEPTION
389: WHEN FND_API.G_EXC_ERROR THEN
390: as_utility_pvt.HANDLE_EXCEPTIONS(
391: P_API_NAME => L_API_NAME
392: ,P_PKG_NAME => G_PKG_NAME
393: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

395: ,X_MSG_COUNT => X_MSG_COUNT
396: ,X_MSG_DATA => X_MSG_DATA
397: ,X_RETURN_STATUS => X_RETURN_STATUS);
398:
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400: as_utility_pvt.HANDLE_EXCEPTIONS(
401: P_API_NAME => L_API_NAME
402: ,P_PKG_NAME => G_PKG_NAME
403: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

420:
421:
422: Procedure Create_CardRule_QUAL (
423: p_api_version IN NUMBER := 2.0,
424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
426: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
427: x_return_status OUT NOCOPY VARCHAR2,
428: x_msg_count OUT NOCOPY NUMBER,

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

421:
422: Procedure Create_CardRule_QUAL (
423: p_api_version IN NUMBER := 2.0,
424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
426: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
427: x_return_status OUT NOCOPY VARCHAR2,
428: x_msg_count OUT NOCOPY NUMBER,
429: x_msg_data OUT NOCOPY VARCHAR2,

Line 444: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

440: -- Standard Start of API savepoint
441: SAVEPOINT CREATE_CARD_RULE_PUB;
442:
443: -- Standard call to check for call compatibility.
444: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
445: p_api_version,
446: l_api_name,
447: G_PKG_NAME)
448: THEN

Line 449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

445: p_api_version,
446: l_api_name,
447: G_PKG_NAME)
448: THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:
452:
453: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 454: IF FND_API.to_Boolean( p_init_msg_list )

450: END IF;
451:
452:
453: -- Initialize message list if p_init_msg_list is set to TRUE.
454: IF FND_API.to_Boolean( p_init_msg_list )
455: THEN
456: FND_MSG_PUB.initialize;
457: END IF;
458:

Line 467: x_return_status := FND_API.G_RET_STS_SUCCESS;

463: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
464:
465:
466: -- Initialize API return status to SUCCESS
467: x_return_status := FND_API.G_RET_STS_SUCCESS;
468:
469: --
470: -- API body
471: --

Line 479: , p_init_msg_list => FND_API.G_FALSE

475: 'Public API: Calling AS_SCORECARD_RULES_PVT.Create_CardRule_Qual');
476:
477: AS_SCORECARD_RULES_PVT.Create_CardRule_Qual(
478: p_api_version => p_api_version
479: , p_init_msg_list => FND_API.G_FALSE
480: , p_commit => p_commit
481: , p_validation_level => p_validation_level
482: , p_cardrule_qual_rec => p_cardrule_qual_rec
483: , x_qual_value_id => x_qual_value_id

Line 489: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

485: , x_msg_count => x_msg_count
486: , x_msg_data => x_msg_data
487: );
488:
489: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
490: RAISE FND_API.G_EXC_ERROR;
491: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
492: raise FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;

Line 490: RAISE FND_API.G_EXC_ERROR;

486: , x_msg_data => x_msg_data
487: );
488:
489: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
490: RAISE FND_API.G_EXC_ERROR;
491: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
492: raise FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;
494:

Line 491: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

487: );
488:
489: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
490: RAISE FND_API.G_EXC_ERROR;
491: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
492: raise FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;
494:
495: --

Line 492: raise FND_API.G_EXC_UNEXPECTED_ERROR;

488:
489: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
490: RAISE FND_API.G_EXC_ERROR;
491: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
492: raise FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;
494:
495: --
496: -- End of API body

Line 500: IF FND_API.to_Boolean( p_commit )

496: -- End of API body
497: --
498:
499: -- Standard check for p_commit
500: IF FND_API.to_Boolean( p_commit )
501: THEN
502: COMMIT WORK;
503: END IF;
504:

Line 518: WHEN FND_API.G_EXC_ERROR THEN

514: p_data => x_msg_data
515: );
516:
517: EXCEPTION
518: WHEN FND_API.G_EXC_ERROR THEN
519: as_utility_pvt.HANDLE_EXCEPTIONS(
520: P_API_NAME => L_API_NAME
521: ,P_PKG_NAME => G_PKG_NAME
522: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

524: ,X_MSG_COUNT => X_MSG_COUNT
525: ,X_MSG_DATA => X_MSG_DATA
526: ,X_RETURN_STATUS => X_RETURN_STATUS);
527:
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: as_utility_pvt.HANDLE_EXCEPTIONS(
530: P_API_NAME => L_API_NAME
531: ,P_PKG_NAME => G_PKG_NAME
532: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 554: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

550:
551:
552: Procedure Update_CardRule_QUAL (
553: p_api_version IN NUMBER := 2.0,
554: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
555: p_commit IN VARCHAR2 := FND_API.G_FALSE,
556: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
557: x_return_status OUT NOCOPY VARCHAR2,
558: x_msg_count OUT NOCOPY NUMBER,

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

551:
552: Procedure Update_CardRule_QUAL (
553: p_api_version IN NUMBER := 2.0,
554: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
555: p_commit IN VARCHAR2 := FND_API.G_FALSE,
556: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
557: x_return_status OUT NOCOPY VARCHAR2,
558: x_msg_count OUT NOCOPY NUMBER,
559: x_msg_data OUT NOCOPY VARCHAR2,

Line 574: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

570: -- Standard Start of API savepoint
571: SAVEPOINT UPDATE_CARDRULE_QUAL_PUB;
572:
573: -- Standard call to check for call compatibility.
574: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
575: p_api_version,
576: l_api_name,
577: G_PKG_NAME)
578: THEN

Line 579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

575: p_api_version,
576: l_api_name,
577: G_PKG_NAME)
578: THEN
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
580: END IF;
581:
582: -- Initialize message list if p_init_msg_list is set to TRUE.
583: IF FND_API.to_Boolean( p_init_msg_list )

Line 583: IF FND_API.to_Boolean( p_init_msg_list )

579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
580: END IF;
581:
582: -- Initialize message list if p_init_msg_list is set to TRUE.
583: IF FND_API.to_Boolean( p_init_msg_list )
584: THEN
585: FND_MSG_PUB.initialize;
586: END IF;
587:

Line 596: x_return_status := FND_API.G_RET_STS_SUCCESS;

592: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
593:
594:
595: -- Initialize API return status to SUCCESS
596: x_return_status := FND_API.G_RET_STS_SUCCESS;
597:
598: --
599: -- Api body
600: --

Line 609: , p_init_msg_list => FND_API.G_FALSE

605:
606:
607: AS_SCORECARD_RULES_PVT.Update_CardRule_Qual(
608: p_api_version => p_api_version
609: , p_init_msg_list => FND_API.G_FALSE
610: , p_commit => p_commit
611: , p_validation_level => p_validation_level
612: , p_cardrule_qual_rec => p_cardrule_qual_rec
613: , x_return_status => x_return_status

Line 618: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

614: , x_msg_count => x_msg_count
615: , x_msg_data => x_msg_data
616: );
617:
618: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
619: RAISE FND_API.G_EXC_ERROR;
620: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
621: raise FND_API.G_EXC_UNEXPECTED_ERROR;
622: END IF;

Line 619: RAISE FND_API.G_EXC_ERROR;

615: , x_msg_data => x_msg_data
616: );
617:
618: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
619: RAISE FND_API.G_EXC_ERROR;
620: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
621: raise FND_API.G_EXC_UNEXPECTED_ERROR;
622: END IF;
623:

Line 620: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

616: );
617:
618: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
619: RAISE FND_API.G_EXC_ERROR;
620: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
621: raise FND_API.G_EXC_UNEXPECTED_ERROR;
622: END IF;
623:
624: --

Line 621: raise FND_API.G_EXC_UNEXPECTED_ERROR;

617:
618: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
619: RAISE FND_API.G_EXC_ERROR;
620: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
621: raise FND_API.G_EXC_UNEXPECTED_ERROR;
622: END IF;
623:
624: --
625: -- End of API body.

Line 629: IF FND_API.to_Boolean( p_commit )

625: -- End of API body.
626: --
627:
628: -- Standard check for p_commit
629: IF FND_API.to_Boolean( p_commit )
630: THEN
631: COMMIT WORK;
632: END IF;
633:

Line 646: WHEN FND_API.G_EXC_ERROR THEN

642: ( p_count => x_msg_count,
643: p_data => x_msg_data );
644:
645: EXCEPTION
646: WHEN FND_API.G_EXC_ERROR THEN
647: as_utility_pvt.HANDLE_EXCEPTIONS(
648: P_API_NAME => L_API_NAME
649: ,P_PKG_NAME => G_PKG_NAME
650: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

652: ,X_MSG_COUNT => X_MSG_COUNT
653: ,X_MSG_DATA => X_MSG_DATA
654: ,X_RETURN_STATUS => X_RETURN_STATUS);
655:
656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: as_utility_pvt.HANDLE_EXCEPTIONS(
658: P_API_NAME => L_API_NAME
659: ,P_PKG_NAME => G_PKG_NAME
660: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 682: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

678:
679: -- pass in the qual value Id
680: Procedure Delete_CardRule_QUAL (
681: p_api_version IN NUMBER := 2.0,
682: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
683: p_commit IN VARCHAR2 := FND_API.G_FALSE,
684: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
685: x_return_status OUT NOCOPY VARCHAR2,
686: x_msg_count OUT NOCOPY NUMBER,

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

679: -- pass in the qual value Id
680: Procedure Delete_CardRule_QUAL (
681: p_api_version IN NUMBER := 2.0,
682: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
683: p_commit IN VARCHAR2 := FND_API.G_FALSE,
684: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
685: x_return_status OUT NOCOPY VARCHAR2,
686: x_msg_count OUT NOCOPY NUMBER,
687: x_msg_data OUT NOCOPY VARCHAR2,

Line 701: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

697: -- Standard Start of API savepoint
698: SAVEPOINT DELETE_CARD_RULE_PUB;
699:
700: -- Standard call to check for call compatibility.
701: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
702: p_api_version,
703: l_api_name,
704: G_PKG_NAME)
705: THEN

Line 706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

702: p_api_version,
703: l_api_name,
704: G_PKG_NAME)
705: THEN
706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: END IF;
708:
709: -- Initialize message list if p_init_msg_list is set to TRUE.
710: IF FND_API.to_Boolean( p_init_msg_list )

Line 710: IF FND_API.to_Boolean( p_init_msg_list )

706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: END IF;
708:
709: -- Initialize message list if p_init_msg_list is set to TRUE.
710: IF FND_API.to_Boolean( p_init_msg_list )
711: THEN
712: FND_MSG_PUB.initialize;
713: END IF;
714:

Line 723: x_return_status := FND_API.G_RET_STS_SUCCESS;

719: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
720:
721:
722: -- Initialize API return status to SUCCESS
723: x_return_status := FND_API.G_RET_STS_SUCCESS;
724:
725: --
726: -- Api body
727: --

Line 734: , p_init_msg_list => FND_API.G_FALSE

730: 'Public API: Calling AS_SCORECARD_RULES_PVT.Delete_CardRule_Qual');
731:
732: AS_SCORECARD_RULES_PVT.Delete_CardRule_Qual(
733: p_api_version => p_api_version
734: , p_init_msg_list => FND_API.G_FALSE
735: , p_commit => p_commit
736: , p_validation_level => p_validation_level
737: , p_qual_value_id => p_qual_value_id
738: , x_return_status => x_return_status

Line 743: IF x_return_status = FND_API.G_RET_STS_ERROR then

739: , x_msg_count => x_msg_count
740: , x_msg_data => x_msg_data
741: );
742:
743: IF x_return_status = FND_API.G_RET_STS_ERROR then
744: raise FND_API.G_EXC_ERROR;
745: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
746: raise FND_API.G_EXC_UNEXPECTED_ERROR;
747: END IF;

Line 744: raise FND_API.G_EXC_ERROR;

740: , x_msg_data => x_msg_data
741: );
742:
743: IF x_return_status = FND_API.G_RET_STS_ERROR then
744: raise FND_API.G_EXC_ERROR;
745: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
746: raise FND_API.G_EXC_UNEXPECTED_ERROR;
747: END IF;
748:

Line 745: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

741: );
742:
743: IF x_return_status = FND_API.G_RET_STS_ERROR then
744: raise FND_API.G_EXC_ERROR;
745: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
746: raise FND_API.G_EXC_UNEXPECTED_ERROR;
747: END IF;
748:
749: --

Line 746: raise FND_API.G_EXC_UNEXPECTED_ERROR;

742:
743: IF x_return_status = FND_API.G_RET_STS_ERROR then
744: raise FND_API.G_EXC_ERROR;
745: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
746: raise FND_API.G_EXC_UNEXPECTED_ERROR;
747: END IF;
748:
749: --
750: -- End of API body

Line 754: IF FND_API.to_Boolean( p_commit )

750: -- End of API body
751: --
752:
753: -- Standard check for p_commit
754: IF FND_API.to_Boolean( p_commit )
755: THEN
756: COMMIT WORK;
757: END IF;
758:

Line 770: WHEN FND_API.G_EXC_ERROR THEN

766: ( p_count => x_msg_count,
767: p_data => x_msg_data );
768:
769: EXCEPTION
770: WHEN FND_API.G_EXC_ERROR THEN
771: as_utility_pvt.HANDLE_EXCEPTIONS(
772: P_API_NAME => L_API_NAME
773: ,P_PKG_NAME => G_PKG_NAME
774: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

776: ,X_MSG_COUNT => X_MSG_COUNT
777: ,X_MSG_DATA => X_MSG_DATA
778: ,X_RETURN_STATUS => X_RETURN_STATUS);
779:
780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
781: as_utility_pvt.HANDLE_EXCEPTIONS(
782: P_API_NAME => L_API_NAME
783: ,P_PKG_NAME => G_PKG_NAME
784: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR