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
203: ,module => g_pkg_name ||'.'||l_api_name
204: ,message => l_stage || ': ' || SQLERRM);
205: fnd_log.string(log_level=>fnd_log.level_unexpected
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
203: ,module => g_pkg_name ||'.'||l_api_name
204: ,message => l_stage || ': ' || SQLERRM);
205: fnd_log.string(log_level=>fnd_log.level_unexpected
206: ,module =>g_pkg_name ||'.'||l_api_name
201: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
202: fnd_log.string(log_level => fnd_log.level_unexpected
203: ,module => g_pkg_name ||'.'||l_api_name
204: ,message => l_stage || ': ' || SQLERRM);
205: fnd_log.string(log_level=>fnd_log.level_unexpected
206: ,module =>g_pkg_name ||'.'||l_api_name
207: ,message => 'Input parameter list: ' );
208: fnd_log.string(log_level=>fnd_log.level_unexpected
209: ,module =>g_pkg_name ||'.'||l_api_name
204: ,message => l_stage || ': ' || SQLERRM);
205: fnd_log.string(log_level=>fnd_log.level_unexpected
206: ,module =>g_pkg_name ||'.'||l_api_name
207: ,message => 'Input parameter list: ' );
208: fnd_log.string(log_level=>fnd_log.level_unexpected
209: ,module =>g_pkg_name ||'.'||l_api_name
210: ,message => 'Auction Header Id :'||p_auction_header_id);
211: fnd_log.string(log_level=>fnd_log.level_unexpected
212: ,module =>g_pkg_name ||'.'||l_api_name
207: ,message => 'Input parameter list: ' );
208: fnd_log.string(log_level=>fnd_log.level_unexpected
209: ,module =>g_pkg_name ||'.'||l_api_name
210: ,message => 'Auction Header Id :'||p_auction_header_id);
211: fnd_log.string(log_level=>fnd_log.level_unexpected
212: ,module =>g_pkg_name ||'.'||l_api_name
213: ,message => 'Trading Partner Contact Id'|| p_tpc_id );
214: fnd_log.string(log_level=>fnd_log.level_unexpected
215: ,module =>g_pkg_name ||'.'||l_api_name
210: ,message => 'Auction Header Id :'||p_auction_header_id);
211: fnd_log.string(log_level=>fnd_log.level_unexpected
212: ,module =>g_pkg_name ||'.'||l_api_name
213: ,message => 'Trading Partner Contact Id'|| p_tpc_id );
214: fnd_log.string(log_level=>fnd_log.level_unexpected
215: ,module =>g_pkg_name ||'.'||l_api_name
216: ,message => 'p_api_version: '||p_api_version );
217: END IF;
218: END IF;
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
308: ,module => g_pkg_name ||'.'||l_api_name
309: ,message => l_stage || ': ' || SQLERRM);
310: fnd_log.string(log_level=>fnd_log.level_unexpected
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
308: ,module => g_pkg_name ||'.'||l_api_name
309: ,message => l_stage || ': ' || SQLERRM);
310: fnd_log.string(log_level=>fnd_log.level_unexpected
311: ,module =>g_pkg_name ||'.'||l_api_name
306: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
307: fnd_log.string(log_level => fnd_log.level_unexpected
308: ,module => g_pkg_name ||'.'||l_api_name
309: ,message => l_stage || ': ' || SQLERRM);
310: fnd_log.string(log_level=>fnd_log.level_unexpected
311: ,module =>g_pkg_name ||'.'||l_api_name
312: ,message => 'Input parameter list: ' );
313: fnd_log.string(log_level=>fnd_log.level_unexpected
314: ,module =>g_pkg_name ||'.'||l_api_name
309: ,message => l_stage || ': ' || SQLERRM);
310: fnd_log.string(log_level=>fnd_log.level_unexpected
311: ,module =>g_pkg_name ||'.'||l_api_name
312: ,message => 'Input parameter list: ' );
313: fnd_log.string(log_level=>fnd_log.level_unexpected
314: ,module =>g_pkg_name ||'.'||l_api_name
315: ,message => 'Auction Header Id :'||p_auction_header_id);
316: fnd_log.string(log_level=>fnd_log.level_unexpected
317: ,module =>g_pkg_name ||'.'||l_api_name
312: ,message => 'Input parameter list: ' );
313: fnd_log.string(log_level=>fnd_log.level_unexpected
314: ,module =>g_pkg_name ||'.'||l_api_name
315: ,message => 'Auction Header Id :'||p_auction_header_id);
316: fnd_log.string(log_level=>fnd_log.level_unexpected
317: ,module =>g_pkg_name ||'.'||l_api_name
318: ,message => 'user_id'|| p_user_id );
319: fnd_log.string(log_level=>fnd_log.level_unexpected
320: ,module =>g_pkg_name ||'.'||l_api_name
315: ,message => 'Auction Header Id :'||p_auction_header_id);
316: fnd_log.string(log_level=>fnd_log.level_unexpected
317: ,module =>g_pkg_name ||'.'||l_api_name
318: ,message => 'user_id'|| p_user_id );
319: fnd_log.string(log_level=>fnd_log.level_unexpected
320: ,module =>g_pkg_name ||'.'||l_api_name
321: ,message => 'p_api_version: '||p_api_version );
322: END IF;
323: END IF;
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
427: ,module => g_pkg_name ||'.'||l_api_name
428: ,message => l_stage || ': ' || SQLERRM);
429: fnd_log.string(log_level=>fnd_log.level_unexpected
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
427: ,module => g_pkg_name ||'.'||l_api_name
428: ,message => l_stage || ': ' || SQLERRM);
429: fnd_log.string(log_level=>fnd_log.level_unexpected
430: ,module =>g_pkg_name ||'.'||l_api_name
425: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
426: fnd_log.string(log_level => fnd_log.level_unexpected
427: ,module => g_pkg_name ||'.'||l_api_name
428: ,message => l_stage || ': ' || SQLERRM);
429: fnd_log.string(log_level=>fnd_log.level_unexpected
430: ,module =>g_pkg_name ||'.'||l_api_name
431: ,message => 'Input parameter list: ' );
432: fnd_log.string(log_level=>fnd_log.level_unexpected
433: ,module =>g_pkg_name ||'.'||l_api_name
428: ,message => l_stage || ': ' || SQLERRM);
429: fnd_log.string(log_level=>fnd_log.level_unexpected
430: ,module =>g_pkg_name ||'.'||l_api_name
431: ,message => 'Input parameter list: ' );
432: fnd_log.string(log_level=>fnd_log.level_unexpected
433: ,module =>g_pkg_name ||'.'||l_api_name
434: ,message => 'Auction Header Id :'||p_auction_header_id);
435: fnd_log.string(log_level=>fnd_log.level_unexpected
436: ,module =>g_pkg_name ||'.'||l_api_name
431: ,message => 'Input parameter list: ' );
432: fnd_log.string(log_level=>fnd_log.level_unexpected
433: ,module =>g_pkg_name ||'.'||l_api_name
434: ,message => 'Auction Header Id :'||p_auction_header_id);
435: fnd_log.string(log_level=>fnd_log.level_unexpected
436: ,module =>g_pkg_name ||'.'||l_api_name
437: ,message => 'team_id'|| p_team_id );
438: fnd_log.string(log_level=>fnd_log.level_unexpected
439: ,module =>g_pkg_name ||'.'||l_api_name
434: ,message => 'Auction Header Id :'||p_auction_header_id);
435: fnd_log.string(log_level=>fnd_log.level_unexpected
436: ,module =>g_pkg_name ||'.'||l_api_name
437: ,message => 'team_id'|| p_team_id );
438: fnd_log.string(log_level=>fnd_log.level_unexpected
439: ,module =>g_pkg_name ||'.'||l_api_name
440: ,message => 'p_api_version: '||p_api_version );
441: END IF;
442: END IF;
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
524: ,module => g_pkg_name ||'.'||l_api_name
525: ,message => l_stage || ': ' || SQLERRM);
526: fnd_log.string(log_level=>fnd_log.level_unexpected
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
524: ,module => g_pkg_name ||'.'||l_api_name
525: ,message => l_stage || ': ' || SQLERRM);
526: fnd_log.string(log_level=>fnd_log.level_unexpected
527: ,module =>g_pkg_name ||'.'||l_api_name
522: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
523: fnd_log.string(log_level => fnd_log.level_unexpected
524: ,module => g_pkg_name ||'.'||l_api_name
525: ,message => l_stage || ': ' || SQLERRM);
526: fnd_log.string(log_level=>fnd_log.level_unexpected
527: ,module =>g_pkg_name ||'.'||l_api_name
528: ,message => 'Input parameter list: ' );
529: fnd_log.string(log_level=>fnd_log.level_unexpected
530: ,module =>g_pkg_name ||'.'||l_api_name
525: ,message => l_stage || ': ' || SQLERRM);
526: fnd_log.string(log_level=>fnd_log.level_unexpected
527: ,module =>g_pkg_name ||'.'||l_api_name
528: ,message => 'Input parameter list: ' );
529: fnd_log.string(log_level=>fnd_log.level_unexpected
530: ,module =>g_pkg_name ||'.'||l_api_name
531: ,message => 'Auction Header Id :'||p_auction_header_id);
532: fnd_log.string(log_level=>fnd_log.level_unexpected
533: ,module =>g_pkg_name ||'.'||l_api_name
528: ,message => 'Input parameter list: ' );
529: fnd_log.string(log_level=>fnd_log.level_unexpected
530: ,module =>g_pkg_name ||'.'||l_api_name
531: ,message => 'Auction Header Id :'||p_auction_header_id);
532: fnd_log.string(log_level=>fnd_log.level_unexpected
533: ,module =>g_pkg_name ||'.'||l_api_name
534: ,message => 'p_api_version: '||p_api_version );
535: END IF;
536: END IF;
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
598: ,module => g_pkg_name ||'.'||l_api_name
599: ,message => l_stage || ': ' || SQLERRM);
600: fnd_log.string(log_level=>fnd_log.level_unexpected
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
598: ,module => g_pkg_name ||'.'||l_api_name
599: ,message => l_stage || ': ' || SQLERRM);
600: fnd_log.string(log_level=>fnd_log.level_unexpected
601: ,module =>g_pkg_name ||'.'||l_api_name
596: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
597: fnd_log.string(log_level => fnd_log.level_unexpected
598: ,module => g_pkg_name ||'.'||l_api_name
599: ,message => l_stage || ': ' || SQLERRM);
600: fnd_log.string(log_level=>fnd_log.level_unexpected
601: ,module =>g_pkg_name ||'.'||l_api_name
602: ,message => 'Input parameter list: ' );
603: fnd_log.string(log_level=>fnd_log.level_unexpected
604: ,module =>g_pkg_name ||'.'||l_api_name
599: ,message => l_stage || ': ' || SQLERRM);
600: fnd_log.string(log_level=>fnd_log.level_unexpected
601: ,module =>g_pkg_name ||'.'||l_api_name
602: ,message => 'Input parameter list: ' );
603: fnd_log.string(log_level=>fnd_log.level_unexpected
604: ,module =>g_pkg_name ||'.'||l_api_name
605: ,message => 'Auction Header Id :'||p_auction_header_id);
606: fnd_log.string(log_level=>fnd_log.level_unexpected
607: ,module =>g_pkg_name ||'.'||l_api_name
602: ,message => 'Input parameter list: ' );
603: fnd_log.string(log_level=>fnd_log.level_unexpected
604: ,module =>g_pkg_name ||'.'||l_api_name
605: ,message => 'Auction Header Id :'||p_auction_header_id);
606: fnd_log.string(log_level=>fnd_log.level_unexpected
607: ,module =>g_pkg_name ||'.'||l_api_name
608: ,message => 'Section Id :'||p_section_id);
609: fnd_log.string(log_level=>fnd_log.level_unexpected
610: ,module =>g_pkg_name ||'.'||l_api_name
605: ,message => 'Auction Header Id :'||p_auction_header_id);
606: fnd_log.string(log_level=>fnd_log.level_unexpected
607: ,module =>g_pkg_name ||'.'||l_api_name
608: ,message => 'Section Id :'||p_section_id);
609: fnd_log.string(log_level=>fnd_log.level_unexpected
610: ,module =>g_pkg_name ||'.'||l_api_name
611: ,message => 'p_api_version: '||p_api_version );
612: END IF;
613: END IF;
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
724: ,module => g_pkg_name ||'.'||l_api_name
725: ,message => l_stage || ': ' || SQLERRM);
726: fnd_log.string(log_level=>fnd_log.level_unexpected
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
724: ,module => g_pkg_name ||'.'||l_api_name
725: ,message => l_stage || ': ' || SQLERRM);
726: fnd_log.string(log_level=>fnd_log.level_unexpected
727: ,module =>g_pkg_name ||'.'||l_api_name
722: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
723: fnd_log.string(log_level => fnd_log.level_unexpected
724: ,module => g_pkg_name ||'.'||l_api_name
725: ,message => l_stage || ': ' || SQLERRM);
726: fnd_log.string(log_level=>fnd_log.level_unexpected
727: ,module =>g_pkg_name ||'.'||l_api_name
728: ,message => 'Input parameter list: ' );
729: fnd_log.string(log_level=>fnd_log.level_unexpected
730: ,module =>g_pkg_name ||'.'||l_api_name
725: ,message => l_stage || ': ' || SQLERRM);
726: fnd_log.string(log_level=>fnd_log.level_unexpected
727: ,module =>g_pkg_name ||'.'||l_api_name
728: ,message => 'Input parameter list: ' );
729: fnd_log.string(log_level=>fnd_log.level_unexpected
730: ,module =>g_pkg_name ||'.'||l_api_name
731: ,message => 'Auction Header Id :'||p_auction_header_id);
732: fnd_log.string(log_level=>fnd_log.level_unexpected
733: ,module =>g_pkg_name ||'.'||l_api_name
728: ,message => 'Input parameter list: ' );
729: fnd_log.string(log_level=>fnd_log.level_unexpected
730: ,module =>g_pkg_name ||'.'||l_api_name
731: ,message => 'Auction Header Id :'||p_auction_header_id);
732: fnd_log.string(log_level=>fnd_log.level_unexpected
733: ,module =>g_pkg_name ||'.'||l_api_name
734: ,message => 'Trading Partner Contact Id'|| p_tpc_id );
735: fnd_log.string(log_level=>fnd_log.level_unexpected
736: ,module =>g_pkg_name ||'.'||l_api_name
731: ,message => 'Auction Header Id :'||p_auction_header_id);
732: fnd_log.string(log_level=>fnd_log.level_unexpected
733: ,module =>g_pkg_name ||'.'||l_api_name
734: ,message => 'Trading Partner Contact Id'|| p_tpc_id );
735: fnd_log.string(log_level=>fnd_log.level_unexpected
736: ,module =>g_pkg_name ||'.'||l_api_name
737: ,message => 'p_api_version: '||p_api_version );
738: END IF;
739: END IF;