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

Line 158: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

154: -- Standard Start of API savepoint
155: SAVEPOINT CREATE_CHECK_RATINGS_PUB;
156:
157: -- Standard call to check for call compatibility.
158: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
159: p_api_version_number,
160: l_api_name,
161: G_PKG_NAME)
162: THEN

Line 163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

159: p_api_version_number,
160: l_api_name,
161: G_PKG_NAME)
162: THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165:
166:
167: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 168: IF FND_API.to_Boolean( p_init_msg_list )

164: END IF;
165:
166:
167: -- Initialize message list if p_init_msg_list is set to TRUE.
168: IF FND_API.to_Boolean( p_init_msg_list )
169: THEN
170: FND_MSG_PUB.initialize;
171: END IF;
172:

Line 175: x_return_status := FND_API.G_RET_STS_SUCCESS;

171: END IF;
172:
173:
174: -- Initialize API return status to SUCCESS
175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176:
177: --
178: -- API body
179: --

Line 199: IF x_return_status = FND_API.G_RET_STS_ERROR then

195: );
196:
197:
198: -- Check return status from the above procedure call
199: IF x_return_status = FND_API.G_RET_STS_ERROR then
200: raise FND_API.G_EXC_ERROR;
201: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
202: raise FND_API.G_EXC_UNEXPECTED_ERROR;
203: END IF;

Line 200: raise FND_API.G_EXC_ERROR;

196:
197:
198: -- Check return status from the above procedure call
199: IF x_return_status = FND_API.G_RET_STS_ERROR then
200: raise FND_API.G_EXC_ERROR;
201: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
202: raise FND_API.G_EXC_UNEXPECTED_ERROR;
203: END IF;
204:

Line 201: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

197:
198: -- Check return status from the above procedure call
199: IF x_return_status = FND_API.G_RET_STS_ERROR then
200: raise FND_API.G_EXC_ERROR;
201: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
202: raise FND_API.G_EXC_UNEXPECTED_ERROR;
203: END IF;
204:
205: --

Line 202: raise FND_API.G_EXC_UNEXPECTED_ERROR;

198: -- Check return status from the above procedure call
199: IF x_return_status = FND_API.G_RET_STS_ERROR then
200: raise FND_API.G_EXC_ERROR;
201: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
202: raise FND_API.G_EXC_UNEXPECTED_ERROR;
203: END IF;
204:
205: --
206: -- End of API body.

Line 210: IF FND_API.to_Boolean( p_commit )

206: -- End of API body.
207: --
208:
209: -- Standard check for p_commit
210: IF FND_API.to_Boolean( p_commit )
211: THEN
212: COMMIT WORK;
213: END IF;
214:

Line 223: WHEN FND_API.G_EXC_ERROR THEN

219: p_data => x_msg_data
220: );
221:
222: EXCEPTION
223: WHEN FND_API.G_EXC_ERROR THEN
224: ROLLBACK TO Create_check_ratings_PUB;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MSG_PUB.Count_And_Get
227: ( p_count => x_msg_count,

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

221:
222: EXCEPTION
223: WHEN FND_API.G_EXC_ERROR THEN
224: ROLLBACK TO Create_check_ratings_PUB;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MSG_PUB.Count_And_Get
227: ( p_count => x_msg_count,
228: p_data => x_msg_data
229: );

Line 230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

226: FND_MSG_PUB.Count_And_Get
227: ( p_count => x_msg_count,
228: p_data => x_msg_data
229: );
230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
231: ROLLBACK TO Create_check_ratings_PUB;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: FND_MSG_PUB.Count_And_Get
234: ( p_count => x_msg_count,

Line 232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

228: p_data => x_msg_data
229: );
230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
231: ROLLBACK TO Create_check_ratings_PUB;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: FND_MSG_PUB.Count_And_Get
234: ( p_count => x_msg_count,
235: p_data => x_msg_data
236: );

Line 239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

235: p_data => x_msg_data
236: );
237: WHEN OTHERS THEN
238: ROLLBACK TO Create_check_ratings_PUB;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
241: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
242: END IF;
243: FND_MSG_PUB.Count_And_Get

Line 328: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

324: -- Standard Start of API savepoint
325: SAVEPOINT UPDATE_CHECK_RATINGS_PUB;
326:
327: -- Standard call to check for call compatibility.
328: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
329: p_api_version_number,
330: l_api_name,
331: G_PKG_NAME)
332: THEN

Line 333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

329: p_api_version_number,
330: l_api_name,
331: G_PKG_NAME)
332: THEN
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
334: END IF;
335:
336:
337: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 338: IF FND_API.to_Boolean( p_init_msg_list )

334: END IF;
335:
336:
337: -- Initialize message list if p_init_msg_list is set to TRUE.
338: IF FND_API.to_Boolean( p_init_msg_list )
339: THEN
340: FND_MSG_PUB.initialize;
341: END IF;
342:

Line 345: x_return_status := FND_API.G_RET_STS_SUCCESS;

341: END IF;
342:
343:
344: -- Initialize API return status to SUCCESS
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346:
347: --
348: -- API body
349: --

Line 368: IF x_return_status = FND_API.G_RET_STS_ERROR then

364: );
365:
366:
367: -- Check return status from the above procedure call
368: IF x_return_status = FND_API.G_RET_STS_ERROR then
369: raise FND_API.G_EXC_ERROR;
370: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
371: raise FND_API.G_EXC_UNEXPECTED_ERROR;
372: END IF;

Line 369: raise FND_API.G_EXC_ERROR;

365:
366:
367: -- Check return status from the above procedure call
368: IF x_return_status = FND_API.G_RET_STS_ERROR then
369: raise FND_API.G_EXC_ERROR;
370: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
371: raise FND_API.G_EXC_UNEXPECTED_ERROR;
372: END IF;
373:

Line 370: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

366:
367: -- Check return status from the above procedure call
368: IF x_return_status = FND_API.G_RET_STS_ERROR then
369: raise FND_API.G_EXC_ERROR;
370: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
371: raise FND_API.G_EXC_UNEXPECTED_ERROR;
372: END IF;
373:
374: --

Line 371: raise FND_API.G_EXC_UNEXPECTED_ERROR;

367: -- Check return status from the above procedure call
368: IF x_return_status = FND_API.G_RET_STS_ERROR then
369: raise FND_API.G_EXC_ERROR;
370: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
371: raise FND_API.G_EXC_UNEXPECTED_ERROR;
372: END IF;
373:
374: --
375: -- End of API body

Line 379: IF FND_API.to_Boolean( p_commit )

375: -- End of API body
376: --
377:
378: -- Standard check for p_commit
379: IF FND_API.to_Boolean( p_commit )
380: THEN
381: COMMIT WORK;
382: END IF;
383:

Line 392: WHEN FND_API.G_EXC_ERROR THEN

388: p_data => x_msg_data
389: );
390:
391: EXCEPTION
392: WHEN FND_API.G_EXC_ERROR THEN
393: ROLLBACK TO Update_check_ratings_PUB;
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: FND_MSG_PUB.Count_And_Get
396: ( p_count => x_msg_count,

Line 394: x_return_status := FND_API.G_RET_STS_ERROR;

390:
391: EXCEPTION
392: WHEN FND_API.G_EXC_ERROR THEN
393: ROLLBACK TO Update_check_ratings_PUB;
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: FND_MSG_PUB.Count_And_Get
396: ( p_count => x_msg_count,
397: p_data => x_msg_data
398: );

Line 399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

395: FND_MSG_PUB.Count_And_Get
396: ( p_count => x_msg_count,
397: p_data => x_msg_data
398: );
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400: ROLLBACK TO Update_check_ratings_PUB;
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
402: FND_MSG_PUB.Count_And_Get
403: ( p_count => x_msg_count,

Line 401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

397: p_data => x_msg_data
398: );
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400: ROLLBACK TO Update_check_ratings_PUB;
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
402: FND_MSG_PUB.Count_And_Get
403: ( p_count => x_msg_count,
404: p_data => x_msg_data
405: );

Line 408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

404: p_data => x_msg_data
405: );
406: WHEN OTHERS THEN
407: ROLLBACK TO Update_check_ratings_PUB;
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
410: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
411: END IF;
412: FND_MSG_PUB.Count_And_Get

Line 438: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

434: -- Standard Start of API savepoint
435: SAVEPOINT DELETE_CHECK_RATINGS_PUB;
436:
437: -- Standard call to check for call compatibility.
438: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
439: p_api_version_number,
440: l_api_name,
441: G_PKG_NAME)
442: THEN

Line 443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

439: p_api_version_number,
440: l_api_name,
441: G_PKG_NAME)
442: THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: END IF;
445:
446:
447: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 448: IF FND_API.to_Boolean( p_init_msg_list )

444: END IF;
445:
446:
447: -- Initialize message list if p_init_msg_list is set to TRUE.
448: IF FND_API.to_Boolean( p_init_msg_list )
449: THEN
450: FND_MSG_PUB.initialize;
451: END IF;
452:

Line 455: x_return_status := FND_API.G_RET_STS_SUCCESS;

451: END IF;
452:
453:
454: -- Initialize API return status to SUCCESS
455: x_return_status := FND_API.G_RET_STS_SUCCESS;
456:
457: --
458: -- API body
459: --

Line 475: IF x_return_status = FND_API.G_RET_STS_ERROR then

471:
472:
473:
474: -- Check return status from the above procedure call
475: IF x_return_status = FND_API.G_RET_STS_ERROR then
476: raise FND_API.G_EXC_ERROR;
477: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
478: raise FND_API.G_EXC_UNEXPECTED_ERROR;
479: END IF;

Line 476: raise FND_API.G_EXC_ERROR;

472:
473:
474: -- Check return status from the above procedure call
475: IF x_return_status = FND_API.G_RET_STS_ERROR then
476: raise FND_API.G_EXC_ERROR;
477: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
478: raise FND_API.G_EXC_UNEXPECTED_ERROR;
479: END IF;
480:

Line 477: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

473:
474: -- Check return status from the above procedure call
475: IF x_return_status = FND_API.G_RET_STS_ERROR then
476: raise FND_API.G_EXC_ERROR;
477: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
478: raise FND_API.G_EXC_UNEXPECTED_ERROR;
479: END IF;
480:
481: --

Line 478: raise FND_API.G_EXC_UNEXPECTED_ERROR;

474: -- Check return status from the above procedure call
475: IF x_return_status = FND_API.G_RET_STS_ERROR then
476: raise FND_API.G_EXC_ERROR;
477: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
478: raise FND_API.G_EXC_UNEXPECTED_ERROR;
479: END IF;
480:
481: --
482: -- End of API body

Line 486: IF FND_API.to_Boolean( p_commit )

482: -- End of API body
483: --
484:
485: -- Standard check for p_commit
486: IF FND_API.to_Boolean( p_commit )
487: THEN
488: COMMIT WORK;
489: END IF;
490:

Line 499: WHEN FND_API.G_EXC_ERROR THEN

495: p_data => x_msg_data
496: );
497:
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO Delete_check_ratings_PUB;
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MSG_PUB.Count_And_Get
503: ( p_count => x_msg_count,

Line 501: x_return_status := FND_API.G_RET_STS_ERROR;

497:
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO Delete_check_ratings_PUB;
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MSG_PUB.Count_And_Get
503: ( p_count => x_msg_count,
504: p_data => x_msg_data
505: );

Line 506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

502: FND_MSG_PUB.Count_And_Get
503: ( p_count => x_msg_count,
504: p_data => x_msg_data
505: );
506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
507: ROLLBACK TO Delete_check_ratings_PUB;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: FND_MSG_PUB.Count_And_Get
510: ( p_count => x_msg_count,

Line 508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

504: p_data => x_msg_data
505: );
506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
507: ROLLBACK TO Delete_check_ratings_PUB;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: FND_MSG_PUB.Count_And_Get
510: ( p_count => x_msg_count,
511: p_data => x_msg_data
512: );

Line 515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

511: p_data => x_msg_data
512: );
513: WHEN OTHERS THEN
514: ROLLBACK TO Delete_check_ratings_PUB;
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
517: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
518: END IF;
519: FND_MSG_PUB.Count_And_Get