APPS.PON_LARGE_AUCTION_UTIL_PKG dependencies on PON_LARGE_AUCTION_UTIL_PKG

Line 1: PACKAGE BODY PON_LARGE_AUCTION_UTIL_PKG AS

1: PACKAGE BODY PON_LARGE_AUCTION_UTIL_PKG AS
2: -- $Header: PONLGUTB.pls 120.16 2011/10/04 09:09:58 hvutukur ship $
3:
4: g_debug_mode CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: g_module_prefix CONSTANT VARCHAR2(35) := 'pon.plsql.concRequestsPkg.';

Line 145: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN

141: WHERE ah.auction_header_id = p_auc_header_id;
142:
143: -- Define the initial batch range (line numbers are indexed from 1)
144: l_batch_start := 1;
145: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
146: l_batch_end := l_max_line_number;
147: ELSE
148: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
149: END IF;

Line 148: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;

144: l_batch_start := 1;
145: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
146: l_batch_end := l_max_line_number;
147: ELSE
148: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
149: END IF;
150:
151: -- Unsolicited Lines Project : Delete unsolicited lines
152: PON_UNSOL_UTIL_PKG.DELETE_ALL_LINES(p_auction_header_id => p_auc_header_id,

Line 216: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN

212: END IF;
213:
214: -- Find the new batch range
215: l_batch_start := l_batch_end + 1;
216: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
217: l_batch_end := l_max_line_number;
218: ELSE
219: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
220: END IF;

Line 219: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;

215: l_batch_start := l_batch_end + 1;
216: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
217: l_batch_end := l_max_line_number;
218: ELSE
219: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
220: END IF;
221:
222: END LOOP;
223:

Line 992: pon_large_auction_util_pkg.delete_bid( p_auc_header_id, p_bid_number);

988: -- Initialize API return status to SUCCESS
989: x_return_status := FND_API.G_RET_STS_SUCCESS;
990:
991: -- Delete related records from tables for this bid
992: pon_large_auction_util_pkg.delete_bid( p_auc_header_id, p_bid_number);
993:
994:
995: -- Delete contract terms
996: select conterms_exist_flag into l_conterms_exist_flag

Line 1021: PON_LARGE_AUCTION_UTIL_PKG.delete_bid_header_attachment

1017: end if;
1018: end if;
1019:
1020: -- Delete bid header attachment
1021: PON_LARGE_AUCTION_UTIL_PKG.delete_bid_header_attachment
1022: (
1023: p_auc_header_id => p_auc_header_id,
1024: p_bid_number => p_bid_number
1025: );

Line 1035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'PON_FAIL_CALL_DEL_DOC');

1031: WHEN PON_FAIL_CALL_DEL_DOC THEN
1032: x_return_status := FND_API.G_RET_STS_ERROR ;
1033:
1034: if FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'PON_FAIL_CALL_DEL_DOC');
1036: end if;
1037: WHEN OTHERS THEN
1038:
1039: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1042: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'Others:' || substr(1, 255, sqlerrm) );

1038:
1039: x_return_status := FND_API.G_RET_STS_ERROR;
1040:
1041: if FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1042: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'Others:' || substr(1, 255, sqlerrm) );
1043: end if;
1044: END delete_bid_by_header;
1045:
1046: -- Delete bid header attachment

Line 1067: END PON_LARGE_AUCTION_UTIL_PKG;

1063: WHEN OTHERS THEN
1064: null;
1065: END;
1066:
1067: END PON_LARGE_AUCTION_UTIL_PKG;