APPS.PON_AUCTION_HEADERS_PKG dependencies on FND_LOG

Line 27: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

23: p_message IN VARCHAR2)
24: IS
25: BEGIN
26:
27: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
28: FND_LOG.string(log_level => FND_LOG.level_statement,
29: module => g_module_prefix || p_module,
30: message => p_message);
31: END IF;

Line 28: FND_LOG.string(log_level => FND_LOG.level_statement,

24: IS
25: BEGIN
26:
27: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
28: FND_LOG.string(log_level => FND_LOG.level_statement,
29: module => g_module_prefix || p_module,
30: message => p_message);
31: END IF;
32:

Line 1183: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1179: l_msg_data,
1180: l_msg_count,
1181: l_return_status);
1182:
1183: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1184: fnd_log.string(fnd_log.level_statement,
1185: 'pon_auction_headers_pkg',
1186: 'clone_update_bid failed for auction_id=' || p_auctionHeaderId || ':' || v_nextBid || ':' || p_bidNumber || ', msg_data=' || l_msg_data);
1187: end if;

Line 1184: fnd_log.string(fnd_log.level_statement,

1180: l_msg_count,
1181: l_return_status);
1182:
1183: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1184: fnd_log.string(fnd_log.level_statement,
1185: 'pon_auction_headers_pkg',
1186: 'clone_update_bid failed for auction_id=' || p_auctionHeaderId || ':' || v_nextBid || ':' || p_bidNumber || ', msg_data=' || l_msg_data);
1187: end if;
1188: end if;

Line 6045: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

6041:
6042: WHEN OTHERS THEN
6043: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)THEN
6044: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
6045: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
6046: fnd_log.string(log_level => fnd_log.level_unexpected
6047: ,module => g_pkg_name||'.'||l_api_name
6048: ,message => l_progress || ': ' || SQLERRM);
6049: fnd_log.string(log_level=>fnd_log.level_unexpected,

Line 6046: fnd_log.string(log_level => fnd_log.level_unexpected

6042: WHEN OTHERS THEN
6043: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)THEN
6044: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
6045: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
6046: fnd_log.string(log_level => fnd_log.level_unexpected
6047: ,module => g_pkg_name||'.'||l_api_name
6048: ,message => l_progress || ': ' || SQLERRM);
6049: fnd_log.string(log_level=>fnd_log.level_unexpected,
6050: module =>g_pkg_name ||'.'||l_api_name,

Line 6049: fnd_log.string(log_level=>fnd_log.level_unexpected,

6045: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
6046: fnd_log.string(log_level => fnd_log.level_unexpected
6047: ,module => g_pkg_name||'.'||l_api_name
6048: ,message => l_progress || ': ' || SQLERRM);
6049: fnd_log.string(log_level=>fnd_log.level_unexpected,
6050: module =>g_pkg_name ||'.'||l_api_name,
6051: message => 'Input parameter list: ' );
6052: fnd_log.string(log_level=>fnd_log.level_unexpected,
6053: module =>g_pkg_name ||'.'||l_api_name,

Line 6052: fnd_log.string(log_level=>fnd_log.level_unexpected,

6048: ,message => l_progress || ': ' || SQLERRM);
6049: fnd_log.string(log_level=>fnd_log.level_unexpected,
6050: module =>g_pkg_name ||'.'||l_api_name,
6051: message => 'Input parameter list: ' );
6052: fnd_log.string(log_level=>fnd_log.level_unexpected,
6053: module =>g_pkg_name ||'.'||l_api_name,
6054: message => 'Auction Header Id = ' || p_auction_header_id);
6055: fnd_log.string(log_level=>fnd_log.level_unexpected,
6056: module =>g_pkg_name ||'.'||l_api_name,

Line 6055: fnd_log.string(log_level=>fnd_log.level_unexpected,

6051: message => 'Input parameter list: ' );
6052: fnd_log.string(log_level=>fnd_log.level_unexpected,
6053: module =>g_pkg_name ||'.'||l_api_name,
6054: message => 'Auction Header Id = ' || p_auction_header_id);
6055: fnd_log.string(log_level=>fnd_log.level_unexpected,
6056: module =>g_pkg_name ||'.'||l_api_name,
6057: message => 'Previous Round Active Bid Number = ' || p_prev_auc_active_bid_number);
6058: fnd_log.string(log_level=>fnd_log.level_unexpected,
6059: module =>g_pkg_name ||'.'||l_api_name,

Line 6058: fnd_log.string(log_level=>fnd_log.level_unexpected,

6054: message => 'Auction Header Id = ' || p_auction_header_id);
6055: fnd_log.string(log_level=>fnd_log.level_unexpected,
6056: module =>g_pkg_name ||'.'||l_api_name,
6057: message => 'Previous Round Active Bid Number = ' || p_prev_auc_active_bid_number);
6058: fnd_log.string(log_level=>fnd_log.level_unexpected,
6059: module =>g_pkg_name ||'.'||l_api_name,
6060: message => 'Line Number = ' || p_line_number);
6061: fnd_log.string(log_level=>fnd_log.level_unexpected,
6062: module =>g_pkg_name ||'.'||l_api_name,

Line 6061: fnd_log.string(log_level=>fnd_log.level_unexpected,

6057: message => 'Previous Round Active Bid Number = ' || p_prev_auc_active_bid_number);
6058: fnd_log.string(log_level=>fnd_log.level_unexpected,
6059: module =>g_pkg_name ||'.'||l_api_name,
6060: message => 'Line Number = ' || p_line_number);
6061: fnd_log.string(log_level=>fnd_log.level_unexpected,
6062: module =>g_pkg_name ||'.'||l_api_name,
6063: message => 'contract type = ' || p_contract_type);
6064: fnd_log.string(log_level=>fnd_log.level_unexpected,
6065: module =>g_pkg_name ||'.'||l_api_name,

Line 6064: fnd_log.string(log_level=>fnd_log.level_unexpected,

6060: message => 'Line Number = ' || p_line_number);
6061: fnd_log.string(log_level=>fnd_log.level_unexpected,
6062: module =>g_pkg_name ||'.'||l_api_name,
6063: message => 'contract type = ' || p_contract_type);
6064: fnd_log.string(log_level=>fnd_log.level_unexpected,
6065: module =>g_pkg_name ||'.'||l_api_name,
6066: message => 'supplier view type = ' || p_supplier_view_type);
6067: fnd_log.string(log_level=>fnd_log.level_unexpected,
6068: module =>g_pkg_name ||'.'||l_api_name,

Line 6067: fnd_log.string(log_level=>fnd_log.level_unexpected,

6063: message => 'contract type = ' || p_contract_type);
6064: fnd_log.string(log_level=>fnd_log.level_unexpected,
6065: module =>g_pkg_name ||'.'||l_api_name,
6066: message => 'supplier view type = ' || p_supplier_view_type);
6067: fnd_log.string(log_level=>fnd_log.level_unexpected,
6068: module =>g_pkg_name ||'.'||l_api_name,
6069: message => 'pf type allowed = ' || p_pf_type_allowed);
6070: fnd_log.string(log_level=>fnd_log.level_unexpected,
6071: module =>g_pkg_name ||'.'||l_api_name,

Line 6070: fnd_log.string(log_level=>fnd_log.level_unexpected,

6066: message => 'supplier view type = ' || p_supplier_view_type);
6067: fnd_log.string(log_level=>fnd_log.level_unexpected,
6068: module =>g_pkg_name ||'.'||l_api_name,
6069: message => 'pf type allowed = ' || p_pf_type_allowed);
6070: fnd_log.string(log_level=>fnd_log.level_unexpected,
6071: module =>g_pkg_name ||'.'||l_api_name,
6072: message => 'reverse tranform flag = ' || p_reverse_transform_flag);
6073: END IF;
6074: END IF;

Line 6149: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6145:
6146: -- For each line do the following
6147: FOR auction_item_record IN all_lines_cursor LOOP -- {
6148:
6149: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6150: FND_LOG.string(log_level => FND_LOG.level_statement,
6151: module => g_module_prefix || l_module_name,
6152: message => 'Processing line: ' || auction_item_record.line_number);
6153: END IF; --}

Line 6150: FND_LOG.string(log_level => FND_LOG.level_statement,

6146: -- For each line do the following
6147: FOR auction_item_record IN all_lines_cursor LOOP -- {
6148:
6149: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6150: FND_LOG.string(log_level => FND_LOG.level_statement,
6151: module => g_module_prefix || l_module_name,
6152: message => 'Processing line: ' || auction_item_record.line_number);
6153: END IF; --}
6154:

Line 6172: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6168: AND pbh.bid_status = 'ACTIVE'
6169: AND pbip.line_number = auction_item_record.line_number
6170: AND ROWNUM = 1;
6171:
6172: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6173: FND_LOG.string(log_level => FND_LOG.level_statement,
6174: module => g_module_prefix || l_module_name,
6175: message => 'Got a bid ' || v_bid_number || ' that was removed from the shortlist.');
6176: END IF; --}

Line 6173: FND_LOG.string(log_level => FND_LOG.level_statement,

6169: AND pbip.line_number = auction_item_record.line_number
6170: AND ROWNUM = 1;
6171:
6172: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6173: FND_LOG.string(log_level => FND_LOG.level_statement,
6174: module => g_module_prefix || l_module_name,
6175: message => 'Got a bid ' || v_bid_number || ' that was removed from the shortlist.');
6176: END IF; --}
6177:

Line 6182: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6178: EXCEPTION WHEN NO_DATA_FOUND THEN
6179:
6180: v_bid_number := null;
6181:
6182: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6183: FND_LOG.string(log_level => FND_LOG.level_statement,
6184: module => g_module_prefix || l_module_name,
6185: message => 'Could not find any bid that was removed from the shortlist.');
6186: END IF; --}

Line 6183: FND_LOG.string(log_level => FND_LOG.level_statement,

6179:
6180: v_bid_number := null;
6181:
6182: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6183: FND_LOG.string(log_level => FND_LOG.level_statement,
6184: module => g_module_prefix || l_module_name,
6185: message => 'Could not find any bid that was removed from the shortlist.');
6186: END IF; --}
6187:

Line 6193: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6189:
6190: -- If all are shortlisted then nothing to do for this line
6191: IF (v_bid_number IS NOT null) THEN -- {
6192:
6193: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6194: FND_LOG.string(log_level => FND_LOG.level_statement,
6195: module => g_module_prefix || l_module_name,
6196: message => 'v_bid_number is not null, there is one bid to be removed.');
6197: END IF; --}

Line 6194: FND_LOG.string(log_level => FND_LOG.level_statement,

6190: -- If all are shortlisted then nothing to do for this line
6191: IF (v_bid_number IS NOT null) THEN -- {
6192:
6193: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6194: FND_LOG.string(log_level => FND_LOG.level_statement,
6195: module => g_module_prefix || l_module_name,
6196: message => 'v_bid_number is not null, there is one bid to be removed.');
6197: END IF; --}
6198:

Line 6214: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6210: WHERE
6211: paip.auction_header_id = p_auction_header_id
6212: AND paip.line_number = auction_item_record.line_number;
6213:
6214: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6215: FND_LOG.string(log_level => FND_LOG.level_statement,
6216: module => g_module_prefix || l_module_name,
6217: message => 'Got the best bid_number. v_best_bid_number = ' ||
6218: v_best_bid_number || ', v_best_bid_bid_number = ' ||

Line 6215: FND_LOG.string(log_level => FND_LOG.level_statement,

6211: paip.auction_header_id = p_auction_header_id
6212: AND paip.line_number = auction_item_record.line_number;
6213:
6214: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6215: FND_LOG.string(log_level => FND_LOG.level_statement,
6216: module => g_module_prefix || l_module_name,
6217: message => 'Got the best bid_number. v_best_bid_number = ' ||
6218: v_best_bid_number || ', v_best_bid_bid_number = ' ||
6219: v_best_bid_bid_number || ', v_currentline_group_type = ' ||

Line 6235: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6231: pon_bid_headers pbh
6232: WHERE
6233: pbh.bid_number = v_best_bid_number;
6234:
6235: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6236: FND_LOG.string(log_level => FND_LOG.level_statement,
6237: module => g_module_prefix || l_module_name,
6238: message => 'Got the best bid_number. ' || ', v_bestbid_shortlist_flag = ' ||
6239: v_bestbid_shortlist_flag);

Line 6236: FND_LOG.string(log_level => FND_LOG.level_statement,

6232: WHERE
6233: pbh.bid_number = v_best_bid_number;
6234:
6235: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6236: FND_LOG.string(log_level => FND_LOG.level_statement,
6237: module => g_module_prefix || l_module_name,
6238: message => 'Got the best bid_number. ' || ', v_bestbid_shortlist_flag = ' ||
6239: v_bestbid_shortlist_flag);
6240: END IF; --}

Line 6245: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6241:
6242: IF (v_bestbid_shortlist_flag = 'Y' AND p_bid_ranking =
6243: 'MULTI_ATTRIBUTE_SCORING') THEN -- {
6244:
6245: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6246: FND_LOG.string(log_level => FND_LOG.level_statement,
6247: module => g_module_prefix || l_module_name,
6248: message => 'This is an MAS and the best_bid_number has been shortlisted');
6249: END IF; --}

Line 6246: FND_LOG.string(log_level => FND_LOG.level_statement,

6242: IF (v_bestbid_shortlist_flag = 'Y' AND p_bid_ranking =
6243: 'MULTI_ATTRIBUTE_SCORING') THEN -- {
6244:
6245: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6246: FND_LOG.string(log_level => FND_LOG.level_statement,
6247: module => g_module_prefix || l_module_name,
6248: message => 'This is an MAS and the best_bid_number has been shortlisted');
6249: END IF; --}
6250:

Line 6262: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6258: pbh.bid_number = v_best_bid_bid_number;
6259:
6260: END IF; -- }
6261:
6262: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6263: FND_LOG.string(log_level => FND_LOG.level_statement,
6264: module => g_module_prefix || l_module_name,
6265: message => 'After MAS check. Got the best bid_number. ' || ', v_bestbid_shortlist_flag = ' ||
6266: v_bestbid_shortlist_flag);

Line 6263: FND_LOG.string(log_level => FND_LOG.level_statement,

6259:
6260: END IF; -- }
6261:
6262: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6263: FND_LOG.string(log_level => FND_LOG.level_statement,
6264: module => g_module_prefix || l_module_name,
6265: message => 'After MAS check. Got the best bid_number. ' || ', v_bestbid_shortlist_flag = ' ||
6266: v_bestbid_shortlist_flag);
6267: END IF; --}

Line 6272: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6268:
6269: -- If this bid has not been shortlisted then
6270: IF (v_bestbid_shortlist_flag = 'N') THEN -- {
6271:
6272: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6273: FND_LOG.string(log_level => FND_LOG.level_statement,
6274: module => g_module_prefix || l_module_name,
6275: message => 'The best bid has not been shortlisted.');
6276: END IF; --}

Line 6273: FND_LOG.string(log_level => FND_LOG.level_statement,

6269: -- If this bid has not been shortlisted then
6270: IF (v_bestbid_shortlist_flag = 'N') THEN -- {
6271:
6272: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6273: FND_LOG.string(log_level => FND_LOG.level_statement,
6274: module => g_module_prefix || l_module_name,
6275: message => 'The best bid has not been shortlisted.');
6276: END IF; --}
6277:

Line 6326: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6322: bidline.publish_date asc)
6323: WHERE
6324: rownum = 1;
6325:
6326: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6327: FND_LOG.string(log_level => FND_LOG.level_statement,
6328: module => g_module_prefix || l_module_name,
6329: message => 'Found another best bid.');
6330: END IF; --}

Line 6327: FND_LOG.string(log_level => FND_LOG.level_statement,

6323: WHERE
6324: rownum = 1;
6325:
6326: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6327: FND_LOG.string(log_level => FND_LOG.level_statement,
6328: module => g_module_prefix || l_module_name,
6329: message => 'Found another best bid.');
6330: END IF; --}
6331:

Line 6334: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6330: END IF; --}
6331:
6332: EXCEPTION WHEN NO_DATA_FOUND THEN
6333:
6334: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6335: FND_LOG.string(log_level => FND_LOG.level_statement,
6336: module => g_module_prefix || l_module_name,
6337: message => 'Could not find another best bid.');
6338: END IF; --}

Line 6335: FND_LOG.string(log_level => FND_LOG.level_statement,

6331:
6332: EXCEPTION WHEN NO_DATA_FOUND THEN
6333:
6334: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6335: FND_LOG.string(log_level => FND_LOG.level_statement,
6336: module => g_module_prefix || l_module_name,
6337: message => 'Could not find another best bid.');
6338: END IF; --}
6339:

Line 6350: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6346: t_first_bid_price := null;
6347: t_proxy_bid_limit_price := null;
6348: END; -- }
6349:
6350: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6351: FND_LOG.string(log_level => FND_LOG.level_statement,
6352: module => g_module_prefix || l_module_name,
6353: message => 'Queries values from best bid: t_price = ' || t_price
6354: || ', t_quantity = ' || t_quantity || ', t_promised_date = ' ||

Line 6351: FND_LOG.string(log_level => FND_LOG.level_statement,

6347: t_proxy_bid_limit_price := null;
6348: END; -- }
6349:
6350: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6351: FND_LOG.string(log_level => FND_LOG.level_statement,
6352: module => g_module_prefix || l_module_name,
6353: message => 'Queries values from best bid: t_price = ' || t_price
6354: || ', t_quantity = ' || t_quantity || ', t_promised_date = ' ||
6355: t_promised_date || ', t_bid_number = ' || t_bid_number

Line 6364: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6360: END IF; --}
6361:
6362: IF (v_currentline_group_type = 'GROUP') THEN -- {
6363:
6364: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6365: FND_LOG.string(log_level => FND_LOG.level_statement,
6366: module => g_module_prefix || l_module_name,
6367: message => 'Current line is a group no need to set all columns, '
6368: || 'just best_bid_number and best_bid_bid_number');

Line 6365: FND_LOG.string(log_level => FND_LOG.level_statement,

6361:
6362: IF (v_currentline_group_type = 'GROUP') THEN -- {
6363:
6364: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6365: FND_LOG.string(log_level => FND_LOG.level_statement,
6366: module => g_module_prefix || l_module_name,
6367: message => 'Current line is a group no need to set all columns, '
6368: || 'just best_bid_number and best_bid_bid_number');
6369: END IF; --}

Line 6381: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6377: AND line_number = auction_item_record.line_number;
6378:
6379: ELSE -- } {
6380:
6381: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6382: FND_LOG.string(log_level => FND_LOG.level_statement,
6383: module => g_module_prefix || l_module_name,
6384: message => 'This is not a GROUP line.');
6385: END IF; --}

Line 6382: FND_LOG.string(log_level => FND_LOG.level_statement,

6378:
6379: ELSE -- } {
6380:
6381: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6382: FND_LOG.string(log_level => FND_LOG.level_statement,
6383: module => g_module_prefix || l_module_name,
6384: message => 'This is not a GROUP line.');
6385: END IF; --}
6386:

Line 6404: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6400: AND line_number = auction_item_record.line_number;
6401:
6402: END IF; -- }
6403:
6404: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6405: FND_LOG.string(log_level => FND_LOG.level_statement,
6406: module => g_module_prefix || l_module_name,
6407: message => 'Updated pon_auction_item_prices_all');
6408: END IF; --}

Line 6405: FND_LOG.string(log_level => FND_LOG.level_statement,

6401:
6402: END IF; -- }
6403:
6404: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6405: FND_LOG.string(log_level => FND_LOG.level_statement,
6406: module => g_module_prefix || l_module_name,
6407: message => 'Updated pon_auction_item_prices_all');
6408: END IF; --}
6409:

Line 6412: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6408: END IF; --}
6409:
6410: IF (p_bid_ranking = 'MULTI_ATTRIBUTE_SCORING') THEN -- {
6411:
6412: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6413: FND_LOG.string(log_level => FND_LOG.level_statement,
6414: module => g_module_prefix || l_module_name,
6415: message => 'This is an MAS auction.');
6416: END IF; --}

Line 6413: FND_LOG.string(log_level => FND_LOG.level_statement,

6409:
6410: IF (p_bid_ranking = 'MULTI_ATTRIBUTE_SCORING') THEN -- {
6411:
6412: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6413: FND_LOG.string(log_level => FND_LOG.level_statement,
6414: module => g_module_prefix || l_module_name,
6415: message => 'This is an MAS auction.');
6416: END IF; --}
6417:

Line 6476: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6472: t_bid_currency_price := null;
6473: t_bid_currency_code := null;
6474: END; -- }
6475:
6476: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6477: FND_LOG.string(log_level => FND_LOG.level_statement,
6478: module => g_module_prefix || l_module_name,
6479: message => 'Queries best MAS bid values: t_price = ' || t_price
6480: || 't_score = ' || t_score || ', t_bid_number = ' ||

Line 6477: FND_LOG.string(log_level => FND_LOG.level_statement,

6473: t_bid_currency_code := null;
6474: END; -- }
6475:
6476: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6477: FND_LOG.string(log_level => FND_LOG.level_statement,
6478: module => g_module_prefix || l_module_name,
6479: message => 'Queries best MAS bid values: t_price = ' || t_price
6480: || 't_score = ' || t_score || ', t_bid_number = ' ||
6481: t_bid_number || ', t_bid_currency_price = ' ||

Line 6498: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6494: WHERE
6495: auction_header_id = p_auction_header_id
6496: AND line_number = auction_item_record.line_number;
6497:
6498: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6499: FND_LOG.string(log_level => FND_LOG.level_statement,
6500: module => g_module_prefix || l_module_name,
6501: message => 'Updated pon_auction_item_prices_all');
6502: END IF; --}

Line 6499: FND_LOG.string(log_level => FND_LOG.level_statement,

6495: auction_header_id = p_auction_header_id
6496: AND line_number = auction_item_record.line_number;
6497:
6498: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6499: FND_LOG.string(log_level => FND_LOG.level_statement,
6500: module => g_module_prefix || l_module_name,
6501: message => 'Updated pon_auction_item_prices_all');
6502: END IF; --}
6503:

Line 6513: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6509:
6510: -- Do the resetting of ranks only if the rank indicator is numbering
6511: IF (p_rank_indicator = 'NUMBERING') THEN -- {
6512:
6513: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6514: FND_LOG.string(log_level => FND_LOG.level_statement,
6515: module => g_module_prefix || l_module_name,
6516: message => 'The rank indicator for this auction is NUMBERING.');
6517: END IF; --}

Line 6514: FND_LOG.string(log_level => FND_LOG.level_statement,

6510: -- Do the resetting of ranks only if the rank indicator is numbering
6511: IF (p_rank_indicator = 'NUMBERING') THEN -- {
6512:
6513: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6514: FND_LOG.string(log_level => FND_LOG.level_statement,
6515: module => g_module_prefix || l_module_name,
6516: message => 'The rank indicator for this auction is NUMBERING.');
6517: END IF; --}
6518:

Line 6543: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6539: AND nvl (pbh.shortlist_flag, 'Y') = 'Y'
6540: ORDER BY
6541: pbip.rank;
6542:
6543: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6544: FND_LOG.string(log_level => FND_LOG.level_statement,
6545: module => g_module_prefix || l_module_name,
6546: message => 'Bulk collected the ranks and bid numbers.');
6547: END IF; --}

Line 6544: FND_LOG.string(log_level => FND_LOG.level_statement,

6540: ORDER BY
6541: pbip.rank;
6542:
6543: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6544: FND_LOG.string(log_level => FND_LOG.level_statement,
6545: module => g_module_prefix || l_module_name,
6546: message => 'Bulk collected the ranks and bid numbers.');
6547: END IF; --}
6548:

Line 6553: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6549: -- Loop over and set the rank starting from 1
6550: FOR x IN 1..v_bid_numbers_bulk.COUNT LOOP -- {
6551: v_rank_bulk (x) := x;
6552:
6553: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6554: FND_LOG.string(log_level => FND_LOG.level_statement,
6555: module => g_module_prefix || l_module_name,
6556: message => 'Setting rank as ' || v_rank_bulk (x) || ' for bid '
6557: || v_bid_numbers_bulk (x));

Line 6554: FND_LOG.string(log_level => FND_LOG.level_statement,

6550: FOR x IN 1..v_bid_numbers_bulk.COUNT LOOP -- {
6551: v_rank_bulk (x) := x;
6552:
6553: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6554: FND_LOG.string(log_level => FND_LOG.level_statement,
6555: module => g_module_prefix || l_module_name,
6556: message => 'Setting rank as ' || v_rank_bulk (x) || ' for bid '
6557: || v_bid_numbers_bulk (x));
6558: END IF; --}

Line 6568: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6564: SET rank = v_rank_bulk (x)
6565: WHERE bid_number = v_bid_numbers_bulk (x)
6566: AND line_number = auction_item_record.line_number;
6567:
6568: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6569: FND_LOG.string(log_level => FND_LOG.level_statement,
6570: module => g_module_prefix || l_module_name,
6571: message => 'Done updating the ranks for all the bid items.');
6572: END IF; --}

Line 6569: FND_LOG.string(log_level => FND_LOG.level_statement,

6565: WHERE bid_number = v_bid_numbers_bulk (x)
6566: AND line_number = auction_item_record.line_number;
6567:
6568: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6569: FND_LOG.string(log_level => FND_LOG.level_statement,
6570: module => g_module_prefix || l_module_name,
6571: message => 'Done updating the ranks for all the bid items.');
6572: END IF; --}
6573:

Line 6588: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

6584: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
6585: x_error_code := SQLCODE;
6586: x_error_msg := SUBSTR(SQLERRM, 1, 100);
6587:
6588: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
6589: FND_LOG.string (log_level => FND_LOG.level_exception,
6590: module => g_module_prefix || l_module_name,
6591: message => 'Unexpected exception occured error_code = ' || x_error_code ||
6592: ', error_message = ' || x_error_msg);

Line 6589: FND_LOG.string (log_level => FND_LOG.level_exception,

6585: x_error_code := SQLCODE;
6586: x_error_msg := SUBSTR(SQLERRM, 1, 100);
6587:
6588: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
6589: FND_LOG.string (log_level => FND_LOG.level_exception,
6590: module => g_module_prefix || l_module_name,
6591: message => 'Unexpected exception occured error_code = ' || x_error_code ||
6592: ', error_message = ' || x_error_msg);
6593: END IF;

Line 6631: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{

6627: l_module_name CONSTANT VARCHAR2 (40) := 'updt_tech_short_lines_batched';
6628:
6629: BEGIN
6630:
6631: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
6632: FND_LOG.string(log_level => FND_LOG.level_procedure,
6633: module => g_module_prefix || l_module_name,
6634: message => 'Entering procedure with p_auction_header_id: ' || p_auction_header_id || '; p_bid_ranking: ' || p_bid_ranking || '; p_max_line_number: '
6635: || p_max_line_number || '; p_batch_size: ' || p_batch_size);

Line 6632: FND_LOG.string(log_level => FND_LOG.level_procedure,

6628:
6629: BEGIN
6630:
6631: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
6632: FND_LOG.string(log_level => FND_LOG.level_procedure,
6633: module => g_module_prefix || l_module_name,
6634: message => 'Entering procedure with p_auction_header_id: ' || p_auction_header_id || '; p_bid_ranking: ' || p_bid_ranking || '; p_max_line_number: '
6635: || p_max_line_number || '; p_batch_size: ' || p_batch_size);
6636: END IF; --}

Line 6658: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{

6654: v_batch_end := v_batch_end + p_batch_size;
6655: END IF; -- }
6656:
6657: END LOOP; -- }
6658: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
6659: FND_LOG.string(log_level => FND_LOG.level_procedure,
6660: module => g_module_prefix || l_module_name,
6661: message => 'Leaving procedure');
6662: END IF; --}

Line 6659: FND_LOG.string(log_level => FND_LOG.level_procedure,

6655: END IF; -- }
6656:
6657: END LOOP; -- }
6658: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
6659: FND_LOG.string(log_level => FND_LOG.level_procedure,
6660: module => g_module_prefix || l_module_name,
6661: message => 'Leaving procedure');
6662: END IF; --}
6663:

Line 6670: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

6666: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
6667: x_error_code := SQLCODE;
6668: x_error_msg := SUBSTR(SQLERRM, 1, 100);
6669:
6670: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
6671: FND_LOG.string (log_level => FND_LOG.level_exception,
6672: module => g_module_prefix || l_module_name,
6673: message => 'Unexpected exception occured error_code = ' || x_error_code ||
6674: ', error_message = ' || x_error_msg);

Line 6671: FND_LOG.string (log_level => FND_LOG.level_exception,

6667: x_error_code := SQLCODE;
6668: x_error_msg := SUBSTR(SQLERRM, 1, 100);
6669:
6670: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
6671: FND_LOG.string (log_level => FND_LOG.level_exception,
6672: module => g_module_prefix || l_module_name,
6673: message => 'Unexpected exception occured error_code = ' || x_error_code ||
6674: ', error_message = ' || x_error_msg);
6675: END IF;

Line 6715: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{

6711: BEGIN
6712:
6713: x_result := FND_API.G_RET_STS_SUCCESS;
6714:
6715: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
6716: FND_LOG.string(log_level => FND_LOG.level_procedure,
6717: module => g_module_prefix || l_module_name,
6718: message => 'Entered procedure with p_auction_header_id = ' ||
6719: p_auction_header_id || ', p_user_id = ' ||

Line 6716: FND_LOG.string(log_level => FND_LOG.level_procedure,

6712:
6713: x_result := FND_API.G_RET_STS_SUCCESS;
6714:
6715: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
6716: FND_LOG.string(log_level => FND_LOG.level_procedure,
6717: module => g_module_prefix || l_module_name,
6718: message => 'Entered procedure with p_auction_header_id = ' ||
6719: p_auction_header_id || ', p_user_id = ' ||
6720: p_user_id);

Line 6740: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6736: AND ROWNUM = 1;
6737:
6738: l_reranking_required := 'Y';
6739:
6740: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6741: FND_LOG.string(log_level => FND_LOG.level_statement,
6742: module => g_module_prefix || l_module_name,
6743: message => 'Found a bid that was not shortlisted.');
6744: END IF; --}

Line 6741: FND_LOG.string(log_level => FND_LOG.level_statement,

6737:
6738: l_reranking_required := 'Y';
6739:
6740: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6741: FND_LOG.string(log_level => FND_LOG.level_statement,
6742: module => g_module_prefix || l_module_name,
6743: message => 'Found a bid that was not shortlisted.');
6744: END IF; --}
6745:

Line 6749: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6745:
6746: EXCEPTION WHEN NO_DATA_FOUND THEN
6747: l_reranking_required := 'N';
6748:
6749: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6750: FND_LOG.string(log_level => FND_LOG.level_statement,
6751: module => g_module_prefix || l_module_name,
6752: message => 'Could not find a bid that was not shortlisted.');
6753: END IF; --}

Line 6750: FND_LOG.string(log_level => FND_LOG.level_statement,

6746: EXCEPTION WHEN NO_DATA_FOUND THEN
6747: l_reranking_required := 'N';
6748:
6749: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6750: FND_LOG.string(log_level => FND_LOG.level_statement,
6751: module => g_module_prefix || l_module_name,
6752: message => 'Could not find a bid that was not shortlisted.');
6753: END IF; --}
6754:

Line 6773: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6769: auction_header_id = p_auction_header_id
6770: FOR
6771: UPDATE OF close_bidding_date;
6772:
6773: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6774: FND_LOG.string(log_level => FND_LOG.level_statement,
6775: module => g_module_prefix || l_module_name,
6776: message => 'rank_indicator = ' || v_rank_indicator ||
6777: ', bid_ranking = ' || v_bid_ranking ||

Line 6774: FND_LOG.string(log_level => FND_LOG.level_statement,

6770: FOR
6771: UPDATE OF close_bidding_date;
6772:
6773: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6774: FND_LOG.string(log_level => FND_LOG.level_statement,
6775: module => g_module_prefix || l_module_name,
6776: message => 'rank_indicator = ' || v_rank_indicator ||
6777: ', bid_ranking = ' || v_bid_ranking ||
6778: ', max_internal_line_num = ' || v_max_internal_line_num);

Line 6791: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

6787: pbh.technical_shortlist_flag = decode (pbh.bid_status, 'ACTIVE', nvl (pbh.shortlist_flag, 'Y'), 'N')
6788: WHERE
6789: pbh.auction_header_id = p_auction_header_id;
6790:
6791: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6792: FND_LOG.string(log_level => FND_LOG.level_statement,
6793: module => g_module_prefix || l_module_name,
6794: message => 'Done with updating pon_bid_headers.');
6795: END IF; --}

Line 6792: FND_LOG.string(log_level => FND_LOG.level_statement,

6788: WHERE
6789: pbh.auction_header_id = p_auction_header_id;
6790:
6791: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6792: FND_LOG.string(log_level => FND_LOG.level_statement,
6793: module => g_module_prefix || l_module_name,
6794: message => 'Done with updating pon_bid_headers.');
6795: END IF; --}
6796:

Line 6851: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{

6847: AND Nvl(bh.surrog_bid_flag, 'N') = 'Y'
6848: AND bh.bid_status = 'DRAFT'
6849: AND bh.submit_stage IS NULL);
6850:
6851: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
6852: FND_LOG.string(log_level => FND_LOG.level_procedure,
6853: module => g_module_prefix || l_module_name,
6854: message => 'Leaving procedure');
6855: END IF; --}

Line 6852: FND_LOG.string(log_level => FND_LOG.level_procedure,

6848: AND bh.bid_status = 'DRAFT'
6849: AND bh.submit_stage IS NULL);
6850:
6851: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
6852: FND_LOG.string(log_level => FND_LOG.level_procedure,
6853: module => g_module_prefix || l_module_name,
6854: message => 'Leaving procedure');
6855: END IF; --}
6856:

Line 6863: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

6859: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
6860: x_error_code := SQLCODE;
6861: x_error_msg := SUBSTR(SQLERRM, 1, 100);
6862:
6863: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
6864: FND_LOG.string (log_level => FND_LOG.level_exception,
6865: module => g_module_prefix || l_module_name,
6866: message => 'Unexpected exception occured error_code = ' || x_error_code ||
6867: ', error_message = ' || x_error_msg);

Line 6864: FND_LOG.string (log_level => FND_LOG.level_exception,

6860: x_error_code := SQLCODE;
6861: x_error_msg := SUBSTR(SQLERRM, 1, 100);
6862:
6863: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
6864: FND_LOG.string (log_level => FND_LOG.level_exception,
6865: module => g_module_prefix || l_module_name,
6866: message => 'Unexpected exception occured error_code = ' || x_error_code ||
6867: ', error_message = ' || x_error_msg);
6868: END IF;