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

Line 39: IF fnd_api.compatible_api_call(

35:
36: -- Check for API comptability
37: l_stage := '10: API check';
38:
39: IF fnd_api.compatible_api_call(
40: p_current_version_number => l_api_version
41: ,p_caller_version_number => p_api_version
42: ,p_api_name => l_api_name
43: ,p_pkg_name => g_pkg_name)

Line 47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

43: ,p_pkg_name => g_pkg_name)
44: THEN
45: NULL;
46: ELSE
47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
48: END IF;
49:
50: -- update auction header if input parameters are not null
51: l_stage := '20: updates begin here';

Line 54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

50: -- update auction header if input parameters are not null
51: l_stage := '20: updates begin here';
52:
53: IF (p_auction_header_id IS NULL) OR (p_tpc_id IS NULL) THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
57: -- update auction header
58: l_stage := '30: update auction header';

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: WHERE auction_header_id = p_auction_header_id
66: AND scoring_lock_date IS NULL;
67:
68: IF SQL%NOTFOUND THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71:
72: l_stage := '35: update the pon bid attribute values table';
73: MERGE

Line 194: x_return_status := fnd_api.G_RET_STS_SUCCESS;

190: ,null
191: );
192:
193:
194: x_return_status := fnd_api.G_RET_STS_SUCCESS;
195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

194: x_return_status := fnd_api.G_RET_STS_SUCCESS;
195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
200: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,SQLERRM);
201: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
202: fnd_log.string(log_level => fnd_log.level_unexpected

Line 249: IF fnd_api.compatible_api_call(

245:
246: -- Check for API comptability
247: l_stage := '10: API check';
248:
249: IF fnd_api.compatible_api_call(
250: p_current_version_number => l_api_version
251: ,p_caller_version_number => p_api_version
252: ,p_api_name => l_api_name
253: ,p_pkg_name => g_pkg_name)

Line 257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

253: ,p_pkg_name => g_pkg_name)
254: THEN
255: NULL;
256: ELSE
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: END IF;
259:
260: -- delete scores if input parameters are not null
261: l_stage := '20: deletes begin here';

Line 266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

262:
263: IF (p_auction_header_id IS NULL)
264: OR (p_user_id IS NULL)
265: OR (p_team_id IS NULL) THEN
266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
267: END IF;
268:
269:
270: -- delete child record

Line 299: x_return_status := fnd_api.G_RET_STS_SUCCESS;

295: FROM pon_team_member_attr_scores ptmas
296: WHERE ptmas.auction_header_id = ptmbs.auction_header_id
297: AND ptmas.user_id = ptmbs.user_id);
298:
299: x_return_status := fnd_api.G_RET_STS_SUCCESS;
300:
301: EXCEPTION
302: WHEN OTHERS THEN
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

299: x_return_status := fnd_api.G_RET_STS_SUCCESS;
300:
301: EXCEPTION
302: WHEN OTHERS THEN
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
305: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,SQLERRM);
306: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
307: fnd_log.string(log_level => fnd_log.level_unexpected

Line 354: IF fnd_api.compatible_api_call(

350:
351: -- Check for API comptability
352: l_stage := '10: API check';
353:
354: IF fnd_api.compatible_api_call(
355: p_current_version_number => l_api_version
356: ,p_caller_version_number => p_api_version
357: ,p_api_name => l_api_name
358: ,p_pkg_name => g_pkg_name)

Line 362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

358: ,p_pkg_name => g_pkg_name)
359: THEN
360: NULL;
361: ELSE
362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
363: END IF;
364:
365: -- delete scores if input parameters are not null
366: l_stage := '20: deletes begin here';

Line 369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

365: -- delete scores if input parameters are not null
366: l_stage := '20: deletes begin here';
367:
368: IF (p_auction_header_id IS NULL) OR (p_team_id IS NULL) THEN
369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
370: END IF;
371:
372: -- delete child record
373: DELETE FROM pon_team_member_attr_scores ptmas

Line 418: x_return_status := fnd_api.G_RET_STS_SUCCESS;

414: AND ptmas.bid_number = ptmbs.bid_number
415: AND ptmas.user_id = ptmbs.user_id
416: );
417:
418: x_return_status := fnd_api.G_RET_STS_SUCCESS;
419:
420: EXCEPTION
421: WHEN OTHERS THEN
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

418: x_return_status := fnd_api.G_RET_STS_SUCCESS;
419:
420: EXCEPTION
421: WHEN OTHERS THEN
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
424: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,SQLERRM);
425: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
426: fnd_log.string(log_level => fnd_log.level_unexpected

Line 472: IF fnd_api.compatible_api_call(

468:
469: -- Check for API comptability
470: l_stage := '10: API check';
471:
472: IF fnd_api.compatible_api_call(
473: p_current_version_number => l_api_version
474: ,p_caller_version_number => p_api_version
475: ,p_api_name => l_api_name
476: ,p_pkg_name => g_pkg_name)

Line 480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

476: ,p_pkg_name => g_pkg_name)
477: THEN
478: NULL;
479: ELSE
480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
481: END IF;
482:
483: -- delete scores if input parameters are not null
484: l_stage := '20: deletes begin here';

Line 487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

483: -- delete scores if input parameters are not null
484: l_stage := '20: deletes begin here';
485:
486: IF (p_auction_header_id IS NULL) THEN
487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: END IF;
489:
490: -- if scores exist for manually scored attributes
491: -- update them to zero for this auction for all active bids

Line 515: x_return_status := fnd_api.G_RET_STS_SUCCESS;

511: AND pbh.bid_status = 'ACTIVE');
512:
513:
514:
515: x_return_status := fnd_api.G_RET_STS_SUCCESS;
516:
517: EXCEPTION
518: WHEN OTHERS THEN
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

515: x_return_status := fnd_api.G_RET_STS_SUCCESS;
516:
517: EXCEPTION
518: WHEN OTHERS THEN
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
521: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,SQLERRM);
522: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
523: fnd_log.string(log_level => fnd_log.level_unexpected

Line 565: IF fnd_api.compatible_api_call(

561:
562: -- Check for API comptability
563: l_stage := '10: API check';
564:
565: IF fnd_api.compatible_api_call(
566: p_current_version_number => l_api_version
567: ,p_caller_version_number => p_api_version
568: ,p_api_name => l_api_name
569: ,p_pkg_name => g_pkg_name)

Line 573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

569: ,p_pkg_name => g_pkg_name)
570: THEN
571: NULL;
572: ELSE
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: END IF;
575:
576: -- delete scores if input parameters are not null
577: l_stage := '20: delete begins here';

Line 580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

576: -- delete scores if input parameters are not null
577: l_stage := '20: delete begins here';
578:
579: IF (p_auction_header_id IS NULL) OR (p_section_id IS NULL) THEN
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;
582:
583: -- delete the section assignment row
584: DELETE FROM pon_scoring_team_sections

Line 589: x_return_status := fnd_api.G_RET_STS_SUCCESS;

585: WHERE auction_header_id = p_auction_header_id
586: AND section_id = p_section_id;
587:
588:
589: x_return_status := fnd_api.G_RET_STS_SUCCESS;
590:
591: EXCEPTION
592: WHEN OTHERS THEN
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

589: x_return_status := fnd_api.G_RET_STS_SUCCESS;
590:
591: EXCEPTION
592: WHEN OTHERS THEN
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
594: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
595: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,SQLERRM);
596: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
597: fnd_log.string(log_level => fnd_log.level_unexpected

Line 643: IF fnd_api.compatible_api_call(

639:
640: -- Check for API comptability
641: l_stage := '10: API check';
642:
643: IF fnd_api.compatible_api_call(
644: p_current_version_number => l_api_version
645: ,p_caller_version_number => p_api_version
646: ,p_api_name => l_api_name
647: ,p_pkg_name => g_pkg_name)

Line 651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

647: ,p_pkg_name => g_pkg_name)
648: THEN
649: NULL;
650: ELSE
651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
652: END IF;
653:
654: -- update auction header if input parameters are not null
655: l_stage := '20: updates begin here';

Line 658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

654: -- update auction header if input parameters are not null
655: l_stage := '20: updates begin here';
656:
657: IF (p_auction_header_id IS NULL) OR (p_tpc_id IS NULL) THEN
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END IF;
660:
661: -- update auction header
662: l_stage := '30: update auction header';

Line 673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

669: WHERE auction_header_id = p_auction_header_id
670: AND scoring_lock_date IS NOT NULL;
671:
672: IF SQL%NOTFOUND THEN
673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675:
676: l_stage := '35: update the pon bid attribute values table';
677:

Line 715: x_return_status := fnd_api.G_RET_STS_SUCCESS;

711: ,last_update_date = SYSDATE
712: ,last_updated_by = fnd_global.user_id
713: WHERE auction_header_id = p_auction_header_id;
714:
715: x_return_status := fnd_api.G_RET_STS_SUCCESS;
716:
717: EXCEPTION
718: WHEN OTHERS THEN
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

715: x_return_status := fnd_api.G_RET_STS_SUCCESS;
716:
717: EXCEPTION
718: WHEN OTHERS THEN
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
721: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,SQLERRM);
722: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
723: fnd_log.string(log_level => fnd_log.level_unexpected