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

Line 60: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

56: -- Standard Start of API savepoint
57: SAVEPOINT CREATE_SCORE_PUB;
58:
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
61: p_api_version,
62: l_api_name,
63: G_PKG_NAME)
64: THEN

Line 65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

61: p_api_version,
62: l_api_name,
63: G_PKG_NAME)
64: THEN
65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66: END IF;
67:
68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 70: IF FND_API.to_Boolean( p_init_msg_list )

66: END IF;
67:
68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.to_Boolean( p_init_msg_list )
71: THEN
72: FND_MSG_PUB.initialize;
73: END IF;
74:

Line 79: x_return_status := FND_API.G_RET_STS_SUCCESS;

75: -- Debug Message
76: iex_score_pvt.WriteLog('iexpscrb:CreateScore:Start');
77:
78: -- Initialize API return status to SUCCESS
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80:
81: --
82: -- API body
83: --

Line 97: IF x_return_status = FND_API.G_RET_STS_ERROR then

93: , x_return_status => x_return_status
94: , x_msg_count => x_msg_count
95: , x_msg_data => x_msg_data);
96:
97: IF x_return_status = FND_API.G_RET_STS_ERROR then
98: raise FND_API.G_EXC_ERROR;
99: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
100: raise FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;

Line 98: raise FND_API.G_EXC_ERROR;

94: , x_msg_count => x_msg_count
95: , x_msg_data => x_msg_data);
96:
97: IF x_return_status = FND_API.G_RET_STS_ERROR then
98: raise FND_API.G_EXC_ERROR;
99: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
100: raise FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:

Line 99: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

95: , x_msg_data => x_msg_data);
96:
97: IF x_return_status = FND_API.G_RET_STS_ERROR then
98: raise FND_API.G_EXC_ERROR;
99: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
100: raise FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:
103: --

Line 100: raise FND_API.G_EXC_UNEXPECTED_ERROR;

96:
97: IF x_return_status = FND_API.G_RET_STS_ERROR then
98: raise FND_API.G_EXC_ERROR;
99: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
100: raise FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:
103: --
104: -- End of API body

Line 108: IF FND_API.to_Boolean( p_commit )

104: -- End of API body
105: --
106:
107: -- Standard check for p_commit
108: IF FND_API.to_Boolean( p_commit )
109: THEN
110: COMMIT WORK;
111: END IF;
112:

Line 123: WHEN FND_API.G_EXC_ERROR THEN

119: p_data => x_msg_data
120: );
121:
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: ROLLBACK TO CREATE_SCORE_PUB;
125: x_return_status := FND_API.G_RET_STS_ERROR ;
126: FND_MSG_PUB.Count_And_Get
127: ( p_count => x_msg_count,

Line 125: x_return_status := FND_API.G_RET_STS_ERROR ;

121:
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: ROLLBACK TO CREATE_SCORE_PUB;
125: x_return_status := FND_API.G_RET_STS_ERROR ;
126: FND_MSG_PUB.Count_And_Get
127: ( p_count => x_msg_count,
128: p_data => x_msg_data
129: );

Line 131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

127: ( p_count => x_msg_count,
128: p_data => x_msg_data
129: );
130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: ROLLBACK TO CREATE_SCORE_PUB;
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
134: FND_MSG_PUB.Count_And_Get
135: ( p_count => x_msg_count,

Line 133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

129: );
130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: ROLLBACK TO CREATE_SCORE_PUB;
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
134: FND_MSG_PUB.Count_And_Get
135: ( p_count => x_msg_count,
136: p_data => x_msg_data
137: );

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

137: );
138:
139: WHEN OTHERS THEN
140: ROLLBACK TO CREATE_SCORE_PUB;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
142: FND_MSG_PUB.Count_And_Get
143: ( p_count => x_msg_count,
144: p_data => x_msg_data
145: );

Line 176: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

172: -- Standard Start of API savepoint
173: SAVEPOINT UPDATE_SCORE_PUB;
174:
175: -- Standard call to check for call compatibility.
176: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
177: p_api_version,
178: l_api_name,
179: G_PKG_NAME)
180: THEN

Line 181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

177: p_api_version,
178: l_api_name,
179: G_PKG_NAME)
180: THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:
184: -- Initialize message list if p_init_msg_list is set to TRUE.
185: IF FND_API.to_Boolean( p_init_msg_list )

Line 185: IF FND_API.to_Boolean( p_init_msg_list )

181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:
184: -- Initialize message list if p_init_msg_list is set to TRUE.
185: IF FND_API.to_Boolean( p_init_msg_list )
186: THEN
187: FND_MSG_PUB.initialize;
188: END IF;
189:

Line 195: x_return_status := FND_API.G_RET_STS_SUCCESS;

191: iex_score_pvt.WriteLog('iexpscrb:UpdateScore:Start');
192:
193:
194: -- Initialize API return status to SUCCESS
195: x_return_status := FND_API.G_RET_STS_SUCCESS;
196:
197: --
198: -- Api body
199: --

Line 217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

213: , x_msg_count => x_msg_count
214: , x_msg_data => x_msg_data
215: );
216:
217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
218: RAISE FND_API.G_EXC_ERROR;
219: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
220: raise FND_API.G_EXC_UNEXPECTED_ERROR;
221: END IF;

Line 218: RAISE FND_API.G_EXC_ERROR;

214: , x_msg_data => x_msg_data
215: );
216:
217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
218: RAISE FND_API.G_EXC_ERROR;
219: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
220: raise FND_API.G_EXC_UNEXPECTED_ERROR;
221: END IF;
222:

Line 219: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

215: );
216:
217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
218: RAISE FND_API.G_EXC_ERROR;
219: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
220: raise FND_API.G_EXC_UNEXPECTED_ERROR;
221: END IF;
222:
223: END LOOP;

Line 220: raise FND_API.G_EXC_UNEXPECTED_ERROR;

216:
217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
218: RAISE FND_API.G_EXC_ERROR;
219: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
220: raise FND_API.G_EXC_UNEXPECTED_ERROR;
221: END IF;
222:
223: END LOOP;
224: --

Line 229: IF FND_API.to_Boolean( p_commit )

225: -- End of API body.
226: --
227:
228: -- Standard check for p_commit
229: IF FND_API.to_Boolean( p_commit )
230: THEN
231: COMMIT WORK;
232: END IF;
233:

Line 243: WHEN FND_API.G_EXC_ERROR THEN

239: ( p_count => x_msg_count,
240: p_data => x_msg_data );
241:
242: EXCEPTION
243: WHEN FND_API.G_EXC_ERROR THEN
244: ROLLBACK TO UPDATE_SCORE_PUB;
245: x_return_status := FND_API.G_RET_STS_ERROR ;
246: FND_MSG_PUB.Count_And_Get
247: ( p_count => x_msg_count,

Line 245: x_return_status := FND_API.G_RET_STS_ERROR ;

241:
242: EXCEPTION
243: WHEN FND_API.G_EXC_ERROR THEN
244: ROLLBACK TO UPDATE_SCORE_PUB;
245: x_return_status := FND_API.G_RET_STS_ERROR ;
246: FND_MSG_PUB.Count_And_Get
247: ( p_count => x_msg_count,
248: p_data => x_msg_data
249: );

Line 251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

247: ( p_count => x_msg_count,
248: p_data => x_msg_data
249: );
250:
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: ROLLBACK TO UPDATE_SCORE_PUB;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: FND_MSG_PUB.Count_And_Get
255: ( p_count => x_msg_count,

Line 253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

249: );
250:
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: ROLLBACK TO UPDATE_SCORE_PUB;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: FND_MSG_PUB.Count_And_Get
255: ( p_count => x_msg_count,
256: p_data => x_msg_data
257: );

Line 261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

257: );
258:
259: WHEN OTHERS THEN
260: ROLLBACK TO UPDATE_SCORE_PUB;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
262: FND_MSG_PUB.Count_And_Get
263: ( p_count => x_msg_count,
264: p_data => x_msg_data
265: );

Line 294: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

290: -- Standard Start of API savepoint
291: SAVEPOINT DELETE_SCORE_PUB;
292:
293: -- Standard call to check for call compatibility.
294: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
295: p_api_version,
296: l_api_name,
297: G_PKG_NAME)
298: THEN

Line 299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

295: p_api_version,
296: l_api_name,
297: G_PKG_NAME)
298: THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: END IF;
301:
302: -- Initialize message list if p_init_msg_list is set to TRUE.
303: IF FND_API.to_Boolean( p_init_msg_list )

Line 303: IF FND_API.to_Boolean( p_init_msg_list )

299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: END IF;
301:
302: -- Initialize message list if p_init_msg_list is set to TRUE.
303: IF FND_API.to_Boolean( p_init_msg_list )
304: THEN
305: FND_MSG_PUB.initialize;
306: END IF;
307:

Line 313: x_return_status := FND_API.G_RET_STS_SUCCESS;

309: iex_score_pvt.WriteLog('iexpscrb:DeleteScore:Start');
310:
311:
312: -- Initialize API return status to SUCCESS
313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314:
315: --
316: -- Api body
317: --

Line 335: IF x_return_status = FND_API.G_RET_STS_ERROR then

331: , x_msg_count => x_msg_count
332: , x_msg_data => x_msg_data
333: );
334:
335: IF x_return_status = FND_API.G_RET_STS_ERROR then
336: raise FND_API.G_EXC_ERROR;
337: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
338: raise FND_API.G_EXC_UNEXPECTED_ERROR;
339: END IF;

Line 336: raise FND_API.G_EXC_ERROR;

332: , x_msg_data => x_msg_data
333: );
334:
335: IF x_return_status = FND_API.G_RET_STS_ERROR then
336: raise FND_API.G_EXC_ERROR;
337: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
338: raise FND_API.G_EXC_UNEXPECTED_ERROR;
339: END IF;
340:

Line 337: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

333: );
334:
335: IF x_return_status = FND_API.G_RET_STS_ERROR then
336: raise FND_API.G_EXC_ERROR;
337: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
338: raise FND_API.G_EXC_UNEXPECTED_ERROR;
339: END IF;
340:
341: END loop;

Line 338: raise FND_API.G_EXC_UNEXPECTED_ERROR;

334:
335: IF x_return_status = FND_API.G_RET_STS_ERROR then
336: raise FND_API.G_EXC_ERROR;
337: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
338: raise FND_API.G_EXC_UNEXPECTED_ERROR;
339: END IF;
340:
341: END loop;
342:

Line 348: IF FND_API.to_Boolean( p_commit )

344: -- End of API body
345: --
346:
347: -- Standard check for p_commit
348: IF FND_API.to_Boolean( p_commit )
349: THEN
350: COMMIT WORK;
351: END IF;
352:

Line 361: WHEN FND_API.G_EXC_ERROR THEN

357: ( p_count => x_msg_count,
358: p_data => x_msg_data );
359:
360: EXCEPTION
361: WHEN FND_API.G_EXC_ERROR THEN
362: ROLLBACK TO DELETE_SCORE_PUB;
363: x_return_status := FND_API.G_RET_STS_ERROR ;
364: FND_MSG_PUB.Count_And_Get
365: ( p_count => x_msg_count,

Line 363: x_return_status := FND_API.G_RET_STS_ERROR ;

359:
360: EXCEPTION
361: WHEN FND_API.G_EXC_ERROR THEN
362: ROLLBACK TO DELETE_SCORE_PUB;
363: x_return_status := FND_API.G_RET_STS_ERROR ;
364: FND_MSG_PUB.Count_And_Get
365: ( p_count => x_msg_count,
366: p_data => x_msg_data
367: );

Line 368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

364: FND_MSG_PUB.Count_And_Get
365: ( p_count => x_msg_count,
366: p_data => x_msg_data
367: );
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
369: ROLLBACK TO DELETE_SCORE_PUB;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
371: FND_MSG_PUB.Count_And_Get
372: ( p_count => x_msg_count,

Line 370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

366: p_data => x_msg_data
367: );
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
369: ROLLBACK TO DELETE_SCORE_PUB;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
371: FND_MSG_PUB.Count_And_Get
372: ( p_count => x_msg_count,
373: p_data => x_msg_data
374: );

Line 377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

373: p_data => x_msg_data
374: );
375: WHEN OTHERS THEN
376: ROLLBACK TO DELETE_SCORE_PUB;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
378: FND_MSG_PUB.Count_And_Get
379: ( p_count => x_msg_count,
380: p_data => x_msg_data
381: );

Line 409: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

405: -- Standard Start of API savepoint
406: SAVEPOINT CREATE_Score_Comp_PUB;
407:
408: -- Standard call to check for call compatibility.
409: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
410: p_api_version,
411: l_api_name,
412: G_PKG_NAME)
413: THEN

Line 414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

410: p_api_version,
411: l_api_name,
412: G_PKG_NAME)
413: THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: END IF;
416:
417:
418: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 419: IF FND_API.to_Boolean( p_init_msg_list )

415: END IF;
416:
417:
418: -- Initialize message list if p_init_msg_list is set to TRUE.
419: IF FND_API.to_Boolean( p_init_msg_list )
420: THEN
421: FND_MSG_PUB.initialize;
422: END IF;
423:

Line 429: x_return_status := FND_API.G_RET_STS_SUCCESS;

425: iex_score_pvt.WriteLog('iexpscrb:CreateScoreComp: Start');
426:
427:
428: -- Initialize API return status to SUCCESS
429: x_return_status := FND_API.G_RET_STS_SUCCESS;
430:
431: --
432: -- API body
433: --

Line 447: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

443: , x_msg_count => x_msg_count
444: , x_msg_data => x_msg_data
445: );
446:
447: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
448: RAISE FND_API.G_EXC_ERROR;
449: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
450: raise FND_API.G_EXC_UNEXPECTED_ERROR;
451: END IF;

Line 448: RAISE FND_API.G_EXC_ERROR;

444: , x_msg_data => x_msg_data
445: );
446:
447: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
448: RAISE FND_API.G_EXC_ERROR;
449: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
450: raise FND_API.G_EXC_UNEXPECTED_ERROR;
451: END IF;
452:

Line 449: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

445: );
446:
447: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
448: RAISE FND_API.G_EXC_ERROR;
449: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
450: raise FND_API.G_EXC_UNEXPECTED_ERROR;
451: END IF;
452:
453:

Line 450: raise FND_API.G_EXC_UNEXPECTED_ERROR;

446:
447: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
448: RAISE FND_API.G_EXC_ERROR;
449: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
450: raise FND_API.G_EXC_UNEXPECTED_ERROR;
451: END IF;
452:
453:
454: --

Line 459: IF FND_API.to_Boolean( p_commit )

455: -- End of API body
456: --
457:
458: -- Standard check for p_commit
459: IF FND_API.to_Boolean( p_commit )
460: THEN
461: COMMIT WORK;
462: END IF;
463:

Line 475: WHEN FND_API.G_EXC_ERROR THEN

471: p_data => x_msg_data
472: );
473:
474: EXCEPTION
475: WHEN FND_API.G_EXC_ERROR THEN
476: ROLLBACK TO CREATE_SCORE_COMP_PUB;
477: x_return_status := FND_API.G_RET_STS_ERROR ;
478: FND_MSG_PUB.Count_And_Get
479: ( p_count => x_msg_count,

Line 477: x_return_status := FND_API.G_RET_STS_ERROR ;

473:
474: EXCEPTION
475: WHEN FND_API.G_EXC_ERROR THEN
476: ROLLBACK TO CREATE_SCORE_COMP_PUB;
477: x_return_status := FND_API.G_RET_STS_ERROR ;
478: FND_MSG_PUB.Count_And_Get
479: ( p_count => x_msg_count,
480: p_data => x_msg_data
481: );

Line 483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

479: ( p_count => x_msg_count,
480: p_data => x_msg_data
481: );
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO CREATE_SCORE_COMP_PUB;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
486: FND_MSG_PUB.Count_And_Get
487: ( p_count => x_msg_count,

Line 485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

481: );
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO CREATE_SCORE_COMP_PUB;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
486: FND_MSG_PUB.Count_And_Get
487: ( p_count => x_msg_count,
488: p_data => x_msg_data
489: );

Line 493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

489: );
490:
491: WHEN OTHERS THEN
492: ROLLBACK TO CREATE_SCORE_COMP_PUB;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
494: FND_MSG_PUB.Count_And_Get
495: ( p_count => x_msg_count,
496: p_data => x_msg_data
497: );

Line 527: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

523: -- Standard Start of API savepoint
524: SAVEPOINT UPDATE_Score_Comp_PUB;
525:
526: -- Standard call to check for call compatibility.
527: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
528: p_api_version,
529: l_api_name,
530: G_PKG_NAME)
531: THEN

Line 532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

528: p_api_version,
529: l_api_name,
530: G_PKG_NAME)
531: THEN
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: END IF;
534:
535: -- Initialize message list if p_init_msg_list is set to TRUE.
536: IF FND_API.to_Boolean( p_init_msg_list )

Line 536: IF FND_API.to_Boolean( p_init_msg_list )

532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: END IF;
534:
535: -- Initialize message list if p_init_msg_list is set to TRUE.
536: IF FND_API.to_Boolean( p_init_msg_list )
537: THEN
538: FND_MSG_PUB.initialize;
539: END IF;
540:

Line 546: x_return_status := FND_API.G_RET_STS_SUCCESS;

542: iex_score_pvt.WriteLog('iexpscrb:UpdateScoreComp: Start');
543:
544:
545: -- Initialize API return status to SUCCESS
546: x_return_status := FND_API.G_RET_STS_SUCCESS;
547:
548: --
549: -- Api body
550: --

Line 569: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

565: , x_msg_count => x_msg_count
566: , x_msg_data => x_msg_data
567: );
568:
569: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
570: RAISE FND_API.G_EXC_ERROR;
571: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
572: raise FND_API.G_EXC_UNEXPECTED_ERROR;
573: END IF;

Line 570: RAISE FND_API.G_EXC_ERROR;

566: , x_msg_data => x_msg_data
567: );
568:
569: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
570: RAISE FND_API.G_EXC_ERROR;
571: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
572: raise FND_API.G_EXC_UNEXPECTED_ERROR;
573: END IF;
574:

Line 571: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

567: );
568:
569: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
570: RAISE FND_API.G_EXC_ERROR;
571: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
572: raise FND_API.G_EXC_UNEXPECTED_ERROR;
573: END IF;
574:
575: END LOOP;

Line 572: raise FND_API.G_EXC_UNEXPECTED_ERROR;

568:
569: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
570: RAISE FND_API.G_EXC_ERROR;
571: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
572: raise FND_API.G_EXC_UNEXPECTED_ERROR;
573: END IF;
574:
575: END LOOP;
576: --

Line 581: IF FND_API.to_Boolean( p_commit )

577: -- End of API body.
578: --
579:
580: -- Standard check for p_commit
581: IF FND_API.to_Boolean( p_commit )
582: THEN
583: COMMIT WORK;
584: END IF;
585:

Line 596: WHEN FND_API.G_EXC_ERROR THEN

592: ( p_count => x_msg_count,
593: p_data => x_msg_data );
594:
595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR THEN
597: ROLLBACK TO UPDATE_SCORE_COMP_PUB;
598: x_return_status := FND_API.G_RET_STS_ERROR ;
599: FND_MSG_PUB.Count_And_Get
600: ( p_count => x_msg_count,

Line 598: x_return_status := FND_API.G_RET_STS_ERROR ;

594:
595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR THEN
597: ROLLBACK TO UPDATE_SCORE_COMP_PUB;
598: x_return_status := FND_API.G_RET_STS_ERROR ;
599: FND_MSG_PUB.Count_And_Get
600: ( p_count => x_msg_count,
601: p_data => x_msg_data
602: );

Line 604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

600: ( p_count => x_msg_count,
601: p_data => x_msg_data
602: );
603:
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: ROLLBACK TO UPDATE_SCORE_COMP_PUB;
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: FND_MSG_PUB.Count_And_Get
608: ( p_count => x_msg_count,

Line 606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

602: );
603:
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: ROLLBACK TO UPDATE_SCORE_COMP_PUB;
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: FND_MSG_PUB.Count_And_Get
608: ( p_count => x_msg_count,
609: p_data => x_msg_data
610: );

Line 614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

610: );
611:
612: WHEN OTHERS THEN
613: ROLLBACK TO UPDATE_SCORE_COMP_PUB;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
615: FND_MSG_PUB.Count_And_Get
616: ( p_count => x_msg_count,
617: p_data => x_msg_data
618: );

Line 647: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

643: -- Standard Start of API savepoint
644: SAVEPOINT DELETE_SCORE_COMP_PUB;
645:
646: -- Standard call to check for call compatibility.
647: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
648: p_api_version,
649: l_api_name,
650: G_PKG_NAME)
651: THEN

Line 652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

648: p_api_version,
649: l_api_name,
650: G_PKG_NAME)
651: THEN
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654:
655: -- Initialize message list if p_init_msg_list is set to TRUE.
656: IF FND_API.to_Boolean( p_init_msg_list )

Line 656: IF FND_API.to_Boolean( p_init_msg_list )

652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654:
655: -- Initialize message list if p_init_msg_list is set to TRUE.
656: IF FND_API.to_Boolean( p_init_msg_list )
657: THEN
658: FND_MSG_PUB.initialize;
659: END IF;
660:

Line 666: x_return_status := FND_API.G_RET_STS_SUCCESS;

662: iex_score_pvt.WriteLog('iexpscrb:DeleteScoreComp: Start');
663:
664:
665: -- Initialize API return status to SUCCESS
666: x_return_status := FND_API.G_RET_STS_SUCCESS;
667:
668: --
669: -- Api body
670: --

Line 689: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

685: , x_msg_count => x_msg_count
686: , x_msg_data => x_msg_data
687: );
688:
689: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
690: RAISE FND_API.G_EXC_ERROR;
691: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
693: END IF;

Line 690: RAISE FND_API.G_EXC_ERROR;

686: , x_msg_data => x_msg_data
687: );
688:
689: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
690: RAISE FND_API.G_EXC_ERROR;
691: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
693: END IF;
694:

Line 691: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

687: );
688:
689: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
690: RAISE FND_API.G_EXC_ERROR;
691: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
693: END IF;
694:
695: end loop;

Line 692: raise FND_API.G_EXC_UNEXPECTED_ERROR;

688:
689: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
690: RAISE FND_API.G_EXC_ERROR;
691: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
693: END IF;
694:
695: end loop;
696: --

Line 701: IF FND_API.to_Boolean( p_commit )

697: -- End of API body
698: --
699:
700: -- Standard check for p_commit
701: IF FND_API.to_Boolean( p_commit )
702: THEN
703: COMMIT WORK;
704: END IF;
705:

Line 714: WHEN FND_API.G_EXC_ERROR THEN

710: ( p_count => x_msg_count,
711: p_data => x_msg_data );
712:
713: EXCEPTION
714: WHEN FND_API.G_EXC_ERROR THEN
715: ROLLBACK TO DELETE_SCORE_COMP_PUB;
716: x_return_status := FND_API.G_RET_STS_ERROR ;
717: FND_MSG_PUB.Count_And_Get
718: ( p_count => x_msg_count,

Line 716: x_return_status := FND_API.G_RET_STS_ERROR ;

712:
713: EXCEPTION
714: WHEN FND_API.G_EXC_ERROR THEN
715: ROLLBACK TO DELETE_SCORE_COMP_PUB;
716: x_return_status := FND_API.G_RET_STS_ERROR ;
717: FND_MSG_PUB.Count_And_Get
718: ( p_count => x_msg_count,
719: p_data => x_msg_data
720: );

Line 722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

718: ( p_count => x_msg_count,
719: p_data => x_msg_data
720: );
721:
722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
723: ROLLBACK TO DELETE_SCORE_COMP_PUB;
724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
725: FND_MSG_PUB.Count_And_Get
726: ( p_count => x_msg_count,

Line 724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

720: );
721:
722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
723: ROLLBACK TO DELETE_SCORE_COMP_PUB;
724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
725: FND_MSG_PUB.Count_And_Get
726: ( p_count => x_msg_count,
727: p_data => x_msg_data
728: );

Line 732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

728: );
729:
730: WHEN OTHERS THEN
731: ROLLBACK TO DELETE_SCORE_COMP_PUB;
732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
733: FND_MSG_PUB.Count_And_Get
734: ( p_count => x_msg_count,
735: p_data => x_msg_data
736: );

Line 766: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

762: -- Standard Start of API savepoint
763: SAVEPOINT CREATE_Score_Comp_Type_PUB;
764:
765: -- Standard call to check for call compatibility.
766: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
767: p_api_version,
768: l_api_name,
769: G_PKG_NAME)
770: THEN

Line 771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

767: p_api_version,
768: l_api_name,
769: G_PKG_NAME)
770: THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END IF;
773:
774:
775: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 776: IF FND_API.to_Boolean( p_init_msg_list )

772: END IF;
773:
774:
775: -- Initialize message list if p_init_msg_list is set to TRUE.
776: IF FND_API.to_Boolean( p_init_msg_list )
777: THEN
778: FND_MSG_PUB.initialize;
779: END IF;
780:

Line 786: x_return_status := FND_API.G_RET_STS_SUCCESS;

782: iex_score_pvt.WriteLog('iexpscrb:CreateScrCompType: Start');
783:
784:
785: -- Initialize API return status to SUCCESS
786: x_return_status := FND_API.G_RET_STS_SUCCESS;
787:
788: --
789: -- API body
790: --

Line 795: , p_init_msg_list => FND_API.G_FALSE

791:
792:
793: IEX_SCORE_PVT.Create_Score_Comp_Type(
794: p_api_version => p_api_version
795: , p_init_msg_list => FND_API.G_FALSE
796: , p_commit => p_Commit
797: , p_score_comp_type_rec => p_score_comp_type_rec
798: , x_score_comp_type_id => x_score_comp_type_id
799: , x_dup_status => x_dup_status

Line 805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

801: , x_msg_count => x_msg_count
802: , x_msg_data => x_msg_data
803: );
804:
805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
806: RAISE FND_API.G_EXC_ERROR;
807: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
808: raise FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;

Line 806: RAISE FND_API.G_EXC_ERROR;

802: , x_msg_data => x_msg_data
803: );
804:
805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
806: RAISE FND_API.G_EXC_ERROR;
807: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
808: raise FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:

Line 807: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

803: );
804:
805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
806: RAISE FND_API.G_EXC_ERROR;
807: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
808: raise FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:
811:

Line 808: raise FND_API.G_EXC_UNEXPECTED_ERROR;

804:
805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
806: RAISE FND_API.G_EXC_ERROR;
807: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
808: raise FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:
811:
812: --

Line 817: IF FND_API.to_Boolean( p_commit )

813: -- End of API body
814: --
815:
816: -- Standard check for p_commit
817: IF FND_API.to_Boolean( p_commit )
818: THEN
819: COMMIT WORK;
820: END IF;
821:

Line 833: WHEN FND_API.G_EXC_ERROR THEN

829: p_data => x_msg_data
830: );
831:
832: EXCEPTION
833: WHEN FND_API.G_EXC_ERROR THEN
834: ROLLBACK TO CREATE_SCORE_COMP_TYPE_PUB;
835: x_return_status := FND_API.G_RET_STS_ERROR ;
836: FND_MSG_PUB.Count_And_Get
837: ( p_count => x_msg_count,

Line 835: x_return_status := FND_API.G_RET_STS_ERROR ;

831:
832: EXCEPTION
833: WHEN FND_API.G_EXC_ERROR THEN
834: ROLLBACK TO CREATE_SCORE_COMP_TYPE_PUB;
835: x_return_status := FND_API.G_RET_STS_ERROR ;
836: FND_MSG_PUB.Count_And_Get
837: ( p_count => x_msg_count,
838: p_data => x_msg_data
839: );

Line 841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

837: ( p_count => x_msg_count,
838: p_data => x_msg_data
839: );
840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: ROLLBACK TO CREATE_SCORE_COMP_TYPE_PUB;
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
844: FND_MSG_PUB.Count_And_Get
845: ( p_count => x_msg_count,

Line 843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

839: );
840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: ROLLBACK TO CREATE_SCORE_COMP_TYPE_PUB;
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
844: FND_MSG_PUB.Count_And_Get
845: ( p_count => x_msg_count,
846: p_data => x_msg_data
847: );

Line 851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

847: );
848:
849: WHEN OTHERS THEN
850: ROLLBACK TO CREATE_SCORE_COMP_TYPE_PUB;
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
852: FND_MSG_PUB.Count_And_Get
853: ( p_count => x_msg_count,
854: p_data => x_msg_data
855: );

Line 886: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

882: -- Standard Start of API savepoint
883: SAVEPOINT UPDATE_Score_Comp_TYPE_PUB;
884:
885: -- Standard call to check for call compatibility.
886: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
887: p_api_version,
888: l_api_name,
889: G_PKG_NAME)
890: THEN

Line 891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

887: p_api_version,
888: l_api_name,
889: G_PKG_NAME)
890: THEN
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892: END IF;
893:
894: -- Initialize message list if p_init_msg_list is set to TRUE.
895: IF FND_API.to_Boolean( p_init_msg_list )

Line 895: IF FND_API.to_Boolean( p_init_msg_list )

891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892: END IF;
893:
894: -- Initialize message list if p_init_msg_list is set to TRUE.
895: IF FND_API.to_Boolean( p_init_msg_list )
896: THEN
897: FND_MSG_PUB.initialize;
898: END IF;
899:

Line 905: x_return_status := FND_API.G_RET_STS_SUCCESS;

901: iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: Start');
902:
903:
904: -- Initialize API return status to SUCCESS
905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906:
907: --
908: -- Api body
909: --

Line 928: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

924: , x_msg_count => x_msg_count
925: , x_msg_data => x_msg_data
926: );
927:
928: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
929: RAISE FND_API.G_EXC_ERROR;
930: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
931: raise FND_API.G_EXC_UNEXPECTED_ERROR;
932: END IF;

Line 929: RAISE FND_API.G_EXC_ERROR;

925: , x_msg_data => x_msg_data
926: );
927:
928: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
929: RAISE FND_API.G_EXC_ERROR;
930: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
931: raise FND_API.G_EXC_UNEXPECTED_ERROR;
932: END IF;
933:

Line 930: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

926: );
927:
928: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
929: RAISE FND_API.G_EXC_ERROR;
930: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
931: raise FND_API.G_EXC_UNEXPECTED_ERROR;
932: END IF;
933:
934: END LOOP;

Line 931: raise FND_API.G_EXC_UNEXPECTED_ERROR;

927:
928: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
929: RAISE FND_API.G_EXC_ERROR;
930: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
931: raise FND_API.G_EXC_UNEXPECTED_ERROR;
932: END IF;
933:
934: END LOOP;
935: --

Line 940: IF FND_API.to_Boolean( p_commit )

936: -- End of API body.
937: --
938:
939: -- Standard check for p_commit
940: IF FND_API.to_Boolean( p_commit )
941: THEN
942: COMMIT WORK;
943: END IF;
944:

Line 955: WHEN FND_API.G_EXC_ERROR THEN

951: ( p_count => x_msg_count,
952: p_data => x_msg_data );
953:
954: EXCEPTION
955: WHEN FND_API.G_EXC_ERROR THEN
956: ROLLBACK To UPDATE_Score_Comp_TYPE_PUB;
957: x_return_status := FND_API.G_RET_STS_ERROR ;
958: FND_MSG_PUB.Count_And_Get
959: ( p_count => x_msg_count,

Line 957: x_return_status := FND_API.G_RET_STS_ERROR ;

953:
954: EXCEPTION
955: WHEN FND_API.G_EXC_ERROR THEN
956: ROLLBACK To UPDATE_Score_Comp_TYPE_PUB;
957: x_return_status := FND_API.G_RET_STS_ERROR ;
958: FND_MSG_PUB.Count_And_Get
959: ( p_count => x_msg_count,
960: p_data => x_msg_data
961: );

Line 963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

959: ( p_count => x_msg_count,
960: p_data => x_msg_data
961: );
962:
963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
964: ROLLBACK To UPDATE_Score_Comp_TYPE_PUB;
965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
966: FND_MSG_PUB.Count_And_Get
967: ( p_count => x_msg_count,

Line 965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

961: );
962:
963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
964: ROLLBACK To UPDATE_Score_Comp_TYPE_PUB;
965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
966: FND_MSG_PUB.Count_And_Get
967: ( p_count => x_msg_count,
968: p_data => x_msg_data
969: );

Line 973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

969: );
970:
971: WHEN OTHERS THEN
972: ROLLBACK To UPDATE_Score_Comp_TYPE_PUB;
973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
974: FND_MSG_PUB.Count_And_Get
975: ( p_count => x_msg_count,
976: p_data => x_msg_data
977: );

Line 1007: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1003: -- Standard Start of API savepoint
1004: SAVEPOINT DELETE_SCORE_COMP_TYPE_PUB;
1005:
1006: -- Standard call to check for call compatibility.
1007: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1008: p_api_version,
1009: l_api_name,
1010: G_PKG_NAME)
1011: THEN

Line 1012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1008: p_api_version,
1009: l_api_name,
1010: G_PKG_NAME)
1011: THEN
1012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1013: END IF;
1014:
1015: -- Initialize message list if p_init_msg_list is set to TRUE.
1016: IF FND_API.to_Boolean( p_init_msg_list )

Line 1016: IF FND_API.to_Boolean( p_init_msg_list )

1012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1013: END IF;
1014:
1015: -- Initialize message list if p_init_msg_list is set to TRUE.
1016: IF FND_API.to_Boolean( p_init_msg_list )
1017: THEN
1018: FND_MSG_PUB.initialize;
1019: END IF;
1020:

Line 1026: x_return_status := FND_API.G_RET_STS_SUCCESS;

1022: iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: Start');
1023:
1024:
1025: -- Initialize API return status to SUCCESS
1026: x_return_status := FND_API.G_RET_STS_SUCCESS;
1027:
1028: --
1029: -- Api body
1030: --

Line 1049: IF x_return_status = FND_API.G_RET_STS_ERROR then

1045: , x_msg_count => x_msg_count
1046: , x_msg_data => x_msg_data
1047: );
1048:
1049: IF x_return_status = FND_API.G_RET_STS_ERROR then
1050: raise FND_API.G_EXC_ERROR;
1051: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1052: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1053: END IF;

Line 1050: raise FND_API.G_EXC_ERROR;

1046: , x_msg_data => x_msg_data
1047: );
1048:
1049: IF x_return_status = FND_API.G_RET_STS_ERROR then
1050: raise FND_API.G_EXC_ERROR;
1051: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1052: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1053: END IF;
1054:

Line 1051: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1047: );
1048:
1049: IF x_return_status = FND_API.G_RET_STS_ERROR then
1050: raise FND_API.G_EXC_ERROR;
1051: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1052: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1053: END IF;
1054:
1055: END loop;

Line 1052: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1048:
1049: IF x_return_status = FND_API.G_RET_STS_ERROR then
1050: raise FND_API.G_EXC_ERROR;
1051: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1052: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1053: END IF;
1054:
1055: END loop;
1056:

Line 1062: IF FND_API.to_Boolean( p_commit )

1058: -- End of API body
1059: --
1060:
1061: -- Standard check for p_commit
1062: IF FND_API.to_Boolean( p_commit )
1063: THEN
1064: COMMIT WORK;
1065: END IF;
1066:

Line 1075: WHEN FND_API.G_EXC_ERROR THEN

1071: ( p_count => x_msg_count,
1072: p_data => x_msg_data );
1073:
1074: EXCEPTION
1075: WHEN FND_API.G_EXC_ERROR THEN
1076: ROLLBACK To DELETE_Score_Comp_TYPE_PUB;
1077: x_return_status := FND_API.G_RET_STS_ERROR ;
1078: FND_MSG_PUB.Count_And_Get
1079: ( p_count => x_msg_count,

Line 1077: x_return_status := FND_API.G_RET_STS_ERROR ;

1073:
1074: EXCEPTION
1075: WHEN FND_API.G_EXC_ERROR THEN
1076: ROLLBACK To DELETE_Score_Comp_TYPE_PUB;
1077: x_return_status := FND_API.G_RET_STS_ERROR ;
1078: FND_MSG_PUB.Count_And_Get
1079: ( p_count => x_msg_count,
1080: p_data => x_msg_data
1081: );

Line 1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1079: ( p_count => x_msg_count,
1080: p_data => x_msg_data
1081: );
1082:
1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1084: ROLLBACK TO DELETE_SCORE_COMP_TYPE_PUB;
1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1086: FND_MSG_PUB.Count_And_Get
1087: ( p_count => x_msg_count,

Line 1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1081: );
1082:
1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1084: ROLLBACK TO DELETE_SCORE_COMP_TYPE_PUB;
1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1086: FND_MSG_PUB.Count_And_Get
1087: ( p_count => x_msg_count,
1088: p_data => x_msg_data
1089: );

Line 1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1089: );
1090:
1091: WHEN OTHERS THEN
1092: ROLLBACK TO DELETE_SCORE_COMP_TYPE_PUB;
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1094: FND_MSG_PUB.Count_And_Get
1095: ( p_count => x_msg_count,
1096: p_data => x_msg_data
1097: );

Line 1129: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1125: SAVEPOINT CREATE_Score_Comp_DET_PUB;
1126:
1127:
1128: -- Standard call to check for call compatibility.
1129: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1130: p_api_version,
1131: l_api_name,
1132: G_PKG_NAME)
1133: THEN

Line 1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1130: p_api_version,
1131: l_api_name,
1132: G_PKG_NAME)
1133: THEN
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: END IF;
1136:
1137:
1138: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1139: IF FND_API.to_Boolean( p_init_msg_list )

1135: END IF;
1136:
1137:
1138: -- Initialize message list if p_init_msg_list is set to TRUE.
1139: IF FND_API.to_Boolean( p_init_msg_list )
1140: THEN
1141: FND_MSG_PUB.initialize;
1142: END IF;
1143:

Line 1149: x_return_status := FND_API.G_RET_STS_SUCCESS;

1145: iex_score_pvt.WriteLog('iexpscrb:CreateScrCompDet: Start');
1146:
1147:
1148: -- Initialize API return status to SUCCESS
1149: x_return_status := FND_API.G_RET_STS_SUCCESS;
1150:
1151: --
1152: -- API body
1153: --

Line 1175: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1171: , x_msg_data => x_msg_data
1172: , x_score_Comp_det_id => x_score_comp_det_id
1173: );
1174:
1175: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1176: RAISE FND_API.G_EXC_ERROR;
1177: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1178: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1179: END IF;

Line 1176: RAISE FND_API.G_EXC_ERROR;

1172: , x_score_Comp_det_id => x_score_comp_det_id
1173: );
1174:
1175: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1176: RAISE FND_API.G_EXC_ERROR;
1177: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1178: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1179: END IF;
1180:

Line 1177: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1173: );
1174:
1175: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1176: RAISE FND_API.G_EXC_ERROR;
1177: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1178: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1179: END IF;
1180:
1181: l_score_comp_Det_rec.score_comp_det_id := x_score_comp_Det_id;

Line 1178: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1174:
1175: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1176: RAISE FND_API.G_EXC_ERROR;
1177: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1178: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1179: END IF;
1180:
1181: l_score_comp_Det_rec.score_comp_det_id := x_score_comp_Det_id;
1182: px_score_comp_Det_tbl(i) := l_score_comp_det_rec;

Line 1192: IF FND_API.to_Boolean( p_commit )

1188: -- End of API body
1189: --
1190:
1191: -- Standard check for p_commit
1192: IF FND_API.to_Boolean( p_commit )
1193: THEN
1194: COMMIT WORK;
1195: END IF;
1196:

Line 1208: WHEN FND_API.G_EXC_ERROR THEN

1204: p_data => x_msg_data
1205: );
1206:
1207: EXCEPTION
1208: WHEN FND_API.G_EXC_ERROR THEN
1209: ROLLBACK To DELETE_Score_Comp_DET_PUB;
1210: x_return_status := FND_API.G_RET_STS_ERROR ;
1211: FND_MSG_PUB.Count_And_Get
1212: ( p_count => x_msg_count,

Line 1210: x_return_status := FND_API.G_RET_STS_ERROR ;

1206:
1207: EXCEPTION
1208: WHEN FND_API.G_EXC_ERROR THEN
1209: ROLLBACK To DELETE_Score_Comp_DET_PUB;
1210: x_return_status := FND_API.G_RET_STS_ERROR ;
1211: FND_MSG_PUB.Count_And_Get
1212: ( p_count => x_msg_count,
1213: p_data => x_msg_data
1214: );

Line 1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1212: ( p_count => x_msg_count,
1213: p_data => x_msg_data
1214: );
1215:
1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1217: ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;
1218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1219: FND_MSG_PUB.Count_And_Get
1220: ( p_count => x_msg_count,

Line 1218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1214: );
1215:
1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1217: ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;
1218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1219: FND_MSG_PUB.Count_And_Get
1220: ( p_count => x_msg_count,
1221: p_data => x_msg_data
1222: );

Line 1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1222: );
1223:
1224: WHEN OTHERS THEN
1225: ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1227: FND_MSG_PUB.Count_And_Get
1228: ( p_count => x_msg_count,
1229: p_data => x_msg_data
1230: );

Line 1259: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1255: -- Standard Start of API savepoint
1256: SAVEPOINT UPDATE_Score_Comp_PUB_DET;
1257:
1258: -- Standard call to check for call compatibility.
1259: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1260: p_api_version,
1261: l_api_name,
1262: G_PKG_NAME)
1263: THEN

Line 1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1260: p_api_version,
1261: l_api_name,
1262: G_PKG_NAME)
1263: THEN
1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265: END IF;
1266:
1267: -- Initialize message list if p_init_msg_list is set to TRUE.
1268: IF FND_API.to_Boolean( p_init_msg_list )

Line 1268: IF FND_API.to_Boolean( p_init_msg_list )

1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265: END IF;
1266:
1267: -- Initialize message list if p_init_msg_list is set to TRUE.
1268: IF FND_API.to_Boolean( p_init_msg_list )
1269: THEN
1270: FND_MSG_PUB.initialize;
1271: END IF;
1272:

Line 1278: x_return_status := FND_API.G_RET_STS_SUCCESS;

1274: iex_score_pvt.WriteLog('iexpscrb:UpdScrCompDet: Start');
1275:
1276:
1277: -- Initialize API return status to SUCCESS
1278: x_return_status := FND_API.G_RET_STS_SUCCESS;
1279:
1280: --
1281: -- Api body
1282: --

Line 1300: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1296: , x_msg_count => x_msg_count
1297: , x_msg_data => x_msg_data
1298: );
1299:
1300: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1303: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;

Line 1301: RAISE FND_API.G_EXC_ERROR;

1297: , x_msg_data => x_msg_data
1298: );
1299:
1300: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1303: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305: END LOOP;

Line 1302: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1298: );
1299:
1300: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1303: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305: END LOOP;
1306: --

Line 1303: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1299:
1300: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1303: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305: END LOOP;
1306: --
1307: -- End of API body.

Line 1311: IF FND_API.to_Boolean( p_commit )

1307: -- End of API body.
1308: --
1309:
1310: -- Standard check for p_commit
1311: IF FND_API.to_Boolean( p_commit )
1312: THEN
1313: COMMIT WORK;
1314: END IF;
1315:

Line 1326: WHEN FND_API.G_EXC_ERROR THEN

1322: ( p_count => x_msg_count,
1323: p_data => x_msg_data );
1324:
1325: EXCEPTION
1326: WHEN FND_API.G_EXC_ERROR THEN
1327: ROLLBACK To UPDATE_Score_Comp_DET_PUB;
1328: x_return_status := FND_API.G_RET_STS_ERROR ;
1329: FND_MSG_PUB.Count_And_Get
1330: ( p_count => x_msg_count,

Line 1328: x_return_status := FND_API.G_RET_STS_ERROR ;

1324:
1325: EXCEPTION
1326: WHEN FND_API.G_EXC_ERROR THEN
1327: ROLLBACK To UPDATE_Score_Comp_DET_PUB;
1328: x_return_status := FND_API.G_RET_STS_ERROR ;
1329: FND_MSG_PUB.Count_And_Get
1330: ( p_count => x_msg_count,
1331: p_data => x_msg_data
1332: );

Line 1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1330: ( p_count => x_msg_count,
1331: p_data => x_msg_data
1332: );
1333:
1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1335: ROLLBACK TO UPDATE_SCORE_COMP_DET_PUB;
1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1337: FND_MSG_PUB.Count_And_Get
1338: ( p_count => x_msg_count,

Line 1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1332: );
1333:
1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1335: ROLLBACK TO UPDATE_SCORE_COMP_DET_PUB;
1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1337: FND_MSG_PUB.Count_And_Get
1338: ( p_count => x_msg_count,
1339: p_data => x_msg_data
1340: );

Line 1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1340: );
1341:
1342: WHEN OTHERS THEN
1343: ROLLBACK TO UPDATE_SCORE_COMP_DET_PUB;
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1345: FND_MSG_PUB.Count_And_Get
1346: ( p_count => x_msg_count,
1347: p_data => x_msg_data
1348: );

Line 1377: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1373: -- Standard Start of API savepoint
1374: SAVEPOINT DELETE_SCORE_COMP_DET_PUB;
1375:
1376: -- Standard call to check for call compatibility.
1377: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1378: p_api_version,
1379: l_api_name,
1380: G_PKG_NAME)
1381: THEN

Line 1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1378: p_api_version,
1379: l_api_name,
1380: G_PKG_NAME)
1381: THEN
1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1383: END IF;
1384:
1385: -- Initialize message list if p_init_msg_list is set to TRUE.
1386: IF FND_API.to_Boolean( p_init_msg_list )

Line 1386: IF FND_API.to_Boolean( p_init_msg_list )

1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1383: END IF;
1384:
1385: -- Initialize message list if p_init_msg_list is set to TRUE.
1386: IF FND_API.to_Boolean( p_init_msg_list )
1387: THEN
1388: FND_MSG_PUB.initialize;
1389: END IF;
1390:

Line 1396: x_return_status := FND_API.G_RET_STS_SUCCESS;

1392: iex_score_pvt.WriteLog('iexpscrb:DelScrCompDet: Start');
1393:
1394:
1395: -- Initialize API return status to SUCCESS
1396: x_return_status := FND_API.G_RET_STS_SUCCESS;
1397:
1398: --
1399: -- Api body
1400: --

Line 1419: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1415: , x_msg_count => x_msg_count
1416: , x_msg_data => x_msg_data
1417: );
1418:
1419: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1420: RAISE FND_API.G_EXC_ERROR;
1421: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1422: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1423: END IF;

Line 1420: RAISE FND_API.G_EXC_ERROR;

1416: , x_msg_data => x_msg_data
1417: );
1418:
1419: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1420: RAISE FND_API.G_EXC_ERROR;
1421: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1422: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1423: END IF;
1424: end loop;

Line 1421: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1417: );
1418:
1419: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1420: RAISE FND_API.G_EXC_ERROR;
1421: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1422: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1423: END IF;
1424: end loop;
1425: --

Line 1422: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1418:
1419: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1420: RAISE FND_API.G_EXC_ERROR;
1421: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1422: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1423: END IF;
1424: end loop;
1425: --
1426: -- End of API body

Line 1430: IF FND_API.to_Boolean( p_commit )

1426: -- End of API body
1427: --
1428:
1429: -- Standard check for p_commit
1430: IF FND_API.to_Boolean( p_commit )
1431: THEN
1432: COMMIT WORK;
1433: END IF;
1434:

Line 1443: WHEN FND_API.G_EXC_ERROR THEN

1439: ( p_count => x_msg_count,
1440: p_data => x_msg_data );
1441:
1442: EXCEPTION
1443: WHEN FND_API.G_EXC_ERROR THEN
1444: ROLLBACK To DELETE_Score_Comp_DET_PUB;
1445: x_return_status := FND_API.G_RET_STS_ERROR ;
1446: FND_MSG_PUB.Count_And_Get
1447: ( p_count => x_msg_count,

Line 1445: x_return_status := FND_API.G_RET_STS_ERROR ;

1441:
1442: EXCEPTION
1443: WHEN FND_API.G_EXC_ERROR THEN
1444: ROLLBACK To DELETE_Score_Comp_DET_PUB;
1445: x_return_status := FND_API.G_RET_STS_ERROR ;
1446: FND_MSG_PUB.Count_And_Get
1447: ( p_count => x_msg_count,
1448: p_data => x_msg_data
1449: );

Line 1451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1447: ( p_count => x_msg_count,
1448: p_data => x_msg_data
1449: );
1450:
1451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1452: ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;
1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1454: FND_MSG_PUB.Count_And_Get
1455: ( p_count => x_msg_count,

Line 1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1449: );
1450:
1451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1452: ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;
1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1454: FND_MSG_PUB.Count_And_Get
1455: ( p_count => x_msg_count,
1456: p_data => x_msg_data
1457: );

Line 1461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1457: );
1458:
1459: WHEN OTHERS THEN
1460: ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;
1461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1462: FND_MSG_PUB.Count_And_Get
1463: ( p_count => x_msg_count,
1464: p_data => x_msg_data
1465: );

Line 1497: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1493: -- Standard Start of API savepoint
1494: SAVEPOINT COPY_SCORINGENGINE_PUB;
1495:
1496: -- Standard call to check for call compatibility.
1497: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1498: p_api_version,
1499: l_api_name,
1500: G_PKG_NAME)
1501: THEN

Line 1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1498: p_api_version,
1499: l_api_name,
1500: G_PKG_NAME)
1501: THEN
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: END IF;
1504:
1505: -- Initialize message list if p_init_msg_list is set to TRUE.
1506: IF FND_API.to_Boolean( p_init_msg_list )

Line 1506: IF FND_API.to_Boolean( p_init_msg_list )

1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: END IF;
1504:
1505: -- Initialize message list if p_init_msg_list is set to TRUE.
1506: IF FND_API.to_Boolean( p_init_msg_list )
1507: THEN
1508: FND_MSG_PUB.initialize;
1509: END IF;
1510:

Line 1512: x_return_status := FND_API.G_RET_STS_SUCCESS;

1508: FND_MSG_PUB.initialize;
1509: END IF;
1510:
1511: -- Initialize API return status to SUCCESS
1512: x_return_status := FND_API.G_RET_STS_SUCCESS;
1513:
1514: l_msg := 'iexpscrb.pls=>Copy_SE:';
1515:
1516: IEX_SCORE_PVT.WriteLog(l_msg ||'START');

Line 1541: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1537:
1538: IEX_SCORE_PVT.WriteLog(l_msg ||'return_status='||x_return_status);
1539:
1540:
1541: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1542: RAISE FND_API.G_EXC_ERROR;
1543: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1544: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1545: END IF;

Line 1542: RAISE FND_API.G_EXC_ERROR;

1538: IEX_SCORE_PVT.WriteLog(l_msg ||'return_status='||x_return_status);
1539:
1540:
1541: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1542: RAISE FND_API.G_EXC_ERROR;
1543: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1544: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1545: END IF;
1546:

Line 1543: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1539:
1540:
1541: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1542: RAISE FND_API.G_EXC_ERROR;
1543: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1544: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1545: END IF;
1546:
1547:

Line 1544: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1540:
1541: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1542: RAISE FND_API.G_EXC_ERROR;
1543: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1544: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1545: END IF;
1546:
1547:
1548: --

Line 1553: IF FND_API.to_Boolean( p_commit )

1549: -- End of API body
1550: --
1551:
1552: -- Standard check for p_commit
1553: IF FND_API.to_Boolean( p_commit )
1554: THEN
1555: COMMIT WORK;
1556: END IF;
1557:

Line 1567: WHEN FND_API.G_EXC_ERROR THEN

1563: ( p_count => x_msg_count,
1564: p_data => x_msg_data );
1565:
1566: EXCEPTION
1567: WHEN FND_API.G_EXC_ERROR THEN
1568: ROLLBACK To COPY_SCORINGENGINE_PUB;
1569: x_return_status := FND_API.G_RET_STS_ERROR ;
1570: FND_MSG_PUB.Count_And_Get
1571: ( p_count => x_msg_count,

Line 1569: x_return_status := FND_API.G_RET_STS_ERROR ;

1565:
1566: EXCEPTION
1567: WHEN FND_API.G_EXC_ERROR THEN
1568: ROLLBACK To COPY_SCORINGENGINE_PUB;
1569: x_return_status := FND_API.G_RET_STS_ERROR ;
1570: FND_MSG_PUB.Count_And_Get
1571: ( p_count => x_msg_count,
1572: p_data => x_msg_data
1573: );

Line 1575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1571: ( p_count => x_msg_count,
1572: p_data => x_msg_data
1573: );
1574:
1575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1576: ROLLBACK TO COPY_SCORINGENGINE_PUB;
1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1578: FND_MSG_PUB.Count_And_Get
1579: ( p_count => x_msg_count,

Line 1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1573: );
1574:
1575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1576: ROLLBACK TO COPY_SCORINGENGINE_PUB;
1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1578: FND_MSG_PUB.Count_And_Get
1579: ( p_count => x_msg_count,
1580: p_data => x_msg_data
1581: );

Line 1584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1580: p_data => x_msg_data
1581: );
1582: WHEN OTHERS THEN
1583: ROLLBACK TO COPY_SCORINGENGINE_PUB;
1584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1585: FND_MSG_PUB.Count_And_Get
1586: ( p_count => x_msg_count,
1587: p_data => x_msg_data
1588: );

Line 1614: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1610: -- Standard Start of API savepoint
1611: SAVEPOINT GET_SCORE_PUB;
1612:
1613: -- Standard call to check for call compatibility.
1614: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1615: p_api_version,
1616: l_api_name,
1617: G_PKG_NAME)
1618: THEN

Line 1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1615: p_api_version,
1616: l_api_name,
1617: G_PKG_NAME)
1618: THEN
1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1620: END IF;
1621:
1622: -- Initialize message list if p_init_msg_list is set to TRUE.
1623: IF FND_API.to_Boolean( p_init_msg_list )

Line 1623: IF FND_API.to_Boolean( p_init_msg_list )

1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1620: END IF;
1621:
1622: -- Initialize message list if p_init_msg_list is set to TRUE.
1623: IF FND_API.to_Boolean( p_init_msg_list )
1624: THEN
1625: FND_MSG_PUB.initialize;
1626: END IF;
1627:

Line 1631: x_return_status := FND_API.G_RET_STS_SUCCESS;

1627:
1628: -- Debug Message
1629:
1630: -- Initialize API return status to SUCCESS
1631: x_return_status := FND_API.G_RET_STS_SUCCESS;
1632:
1633: --
1634: -- Api body
1635: --

Line 1646: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1642: x_return_status => x_return_status,
1643: x_msg_count => x_msg_count ,
1644: x_msg_data => x_msg_data );
1645:
1646: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1647: RAISE FND_API.G_EXC_ERROR;
1648: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1649: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1650: END IF;

Line 1647: RAISE FND_API.G_EXC_ERROR;

1643: x_msg_count => x_msg_count ,
1644: x_msg_data => x_msg_data );
1645:
1646: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1647: RAISE FND_API.G_EXC_ERROR;
1648: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1649: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1650: END IF;
1651: --

Line 1648: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1644: x_msg_data => x_msg_data );
1645:
1646: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1647: RAISE FND_API.G_EXC_ERROR;
1648: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1649: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1650: END IF;
1651: --
1652: -- End of API body

Line 1649: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1645:
1646: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1647: RAISE FND_API.G_EXC_ERROR;
1648: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1649: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1650: END IF;
1651: --
1652: -- End of API body
1653: --

Line 1656: IF FND_API.to_Boolean( p_commit )

1652: -- End of API body
1653: --
1654:
1655: -- Standard check for p_commit
1656: IF FND_API.to_Boolean( p_commit )
1657: THEN
1658: COMMIT WORK;
1659: END IF;
1660:

Line 1668: WHEN FND_API.G_EXC_ERROR THEN

1664: ( p_count => x_msg_count,
1665: p_data => x_msg_data );
1666:
1667: EXCEPTION
1668: WHEN FND_API.G_EXC_ERROR THEN
1669: ROLLBACK To GET_SCORE_PUB;
1670: x_return_status := FND_API.G_RET_STS_ERROR ;
1671: FND_MSG_PUB.Count_And_Get
1672: ( p_count => x_msg_count,

Line 1670: x_return_status := FND_API.G_RET_STS_ERROR ;

1666:
1667: EXCEPTION
1668: WHEN FND_API.G_EXC_ERROR THEN
1669: ROLLBACK To GET_SCORE_PUB;
1670: x_return_status := FND_API.G_RET_STS_ERROR ;
1671: FND_MSG_PUB.Count_And_Get
1672: ( p_count => x_msg_count,
1673: p_data => x_msg_data
1674: );

Line 1676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1672: ( p_count => x_msg_count,
1673: p_data => x_msg_data
1674: );
1675:
1676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1677: ROLLBACK To GET_SCORE_PUB;
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1679: FND_MSG_PUB.Count_And_Get
1680: ( p_count => x_msg_count,

Line 1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1674: );
1675:
1676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1677: ROLLBACK To GET_SCORE_PUB;
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1679: FND_MSG_PUB.Count_And_Get
1680: ( p_count => x_msg_count,
1681: p_data => x_msg_data
1682: );

Line 1685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1681: p_data => x_msg_data
1682: );
1683: WHEN OTHERS THEN
1684: ROLLBACK To GET_SCORE_PUB;
1685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1686: FND_MSG_PUB.Count_And_Get
1687: ( p_count => x_msg_count,
1688: p_data => x_msg_data
1689: );