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 1160: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1156: l_msg_data,
1157: l_msg_count,
1158: l_return_status);
1159:
1160: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1161: fnd_log.string(fnd_log.level_statement,
1162: 'pon_auction_headers_pkg',
1163: 'clone_update_bid failed for auction_id=' || p_auctionHeaderId || ':' || v_nextBid || ':' || p_bidNumber || ', msg_data=' || l_msg_data);
1164: end if;

Line 1161: fnd_log.string(fnd_log.level_statement,

1157: l_msg_count,
1158: l_return_status);
1159:
1160: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1161: fnd_log.string(fnd_log.level_statement,
1162: 'pon_auction_headers_pkg',
1163: 'clone_update_bid failed for auction_id=' || p_auctionHeaderId || ':' || v_nextBid || ':' || p_bidNumber || ', msg_data=' || l_msg_data);
1164: end if;
1165: end if;

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

5873:
5874: WHEN OTHERS THEN
5875: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)THEN
5876: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
5877: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
5878: fnd_log.string(log_level => fnd_log.level_unexpected
5879: ,module => g_pkg_name||'.'||l_api_name
5880: ,message => l_progress || ': ' || SQLERRM);
5881: fnd_log.string(log_level=>fnd_log.level_unexpected,

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

5874: WHEN OTHERS THEN
5875: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)THEN
5876: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
5877: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
5878: fnd_log.string(log_level => fnd_log.level_unexpected
5879: ,module => g_pkg_name||'.'||l_api_name
5880: ,message => l_progress || ': ' || SQLERRM);
5881: fnd_log.string(log_level=>fnd_log.level_unexpected,
5882: module =>g_pkg_name ||'.'||l_api_name,

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

5877: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
5878: fnd_log.string(log_level => fnd_log.level_unexpected
5879: ,module => g_pkg_name||'.'||l_api_name
5880: ,message => l_progress || ': ' || SQLERRM);
5881: fnd_log.string(log_level=>fnd_log.level_unexpected,
5882: module =>g_pkg_name ||'.'||l_api_name,
5883: message => 'Input parameter list: ' );
5884: fnd_log.string(log_level=>fnd_log.level_unexpected,
5885: module =>g_pkg_name ||'.'||l_api_name,

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

5880: ,message => l_progress || ': ' || SQLERRM);
5881: fnd_log.string(log_level=>fnd_log.level_unexpected,
5882: module =>g_pkg_name ||'.'||l_api_name,
5883: message => 'Input parameter list: ' );
5884: fnd_log.string(log_level=>fnd_log.level_unexpected,
5885: module =>g_pkg_name ||'.'||l_api_name,
5886: message => 'Auction Header Id = ' || p_auction_header_id);
5887: fnd_log.string(log_level=>fnd_log.level_unexpected,
5888: module =>g_pkg_name ||'.'||l_api_name,

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

5883: message => 'Input parameter list: ' );
5884: fnd_log.string(log_level=>fnd_log.level_unexpected,
5885: module =>g_pkg_name ||'.'||l_api_name,
5886: message => 'Auction Header Id = ' || p_auction_header_id);
5887: fnd_log.string(log_level=>fnd_log.level_unexpected,
5888: module =>g_pkg_name ||'.'||l_api_name,
5889: message => 'Previous Round Active Bid Number = ' || p_prev_auc_active_bid_number);
5890: fnd_log.string(log_level=>fnd_log.level_unexpected,
5891: module =>g_pkg_name ||'.'||l_api_name,

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

5886: message => 'Auction Header Id = ' || p_auction_header_id);
5887: fnd_log.string(log_level=>fnd_log.level_unexpected,
5888: module =>g_pkg_name ||'.'||l_api_name,
5889: message => 'Previous Round Active Bid Number = ' || p_prev_auc_active_bid_number);
5890: fnd_log.string(log_level=>fnd_log.level_unexpected,
5891: module =>g_pkg_name ||'.'||l_api_name,
5892: message => 'Line Number = ' || p_line_number);
5893: fnd_log.string(log_level=>fnd_log.level_unexpected,
5894: module =>g_pkg_name ||'.'||l_api_name,

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

5889: message => 'Previous Round Active Bid Number = ' || p_prev_auc_active_bid_number);
5890: fnd_log.string(log_level=>fnd_log.level_unexpected,
5891: module =>g_pkg_name ||'.'||l_api_name,
5892: message => 'Line Number = ' || p_line_number);
5893: fnd_log.string(log_level=>fnd_log.level_unexpected,
5894: module =>g_pkg_name ||'.'||l_api_name,
5895: message => 'contract type = ' || p_contract_type);
5896: fnd_log.string(log_level=>fnd_log.level_unexpected,
5897: module =>g_pkg_name ||'.'||l_api_name,

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

5892: message => 'Line Number = ' || p_line_number);
5893: fnd_log.string(log_level=>fnd_log.level_unexpected,
5894: module =>g_pkg_name ||'.'||l_api_name,
5895: message => 'contract type = ' || p_contract_type);
5896: fnd_log.string(log_level=>fnd_log.level_unexpected,
5897: module =>g_pkg_name ||'.'||l_api_name,
5898: message => 'supplier view type = ' || p_supplier_view_type);
5899: fnd_log.string(log_level=>fnd_log.level_unexpected,
5900: module =>g_pkg_name ||'.'||l_api_name,

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

5895: message => 'contract type = ' || p_contract_type);
5896: fnd_log.string(log_level=>fnd_log.level_unexpected,
5897: module =>g_pkg_name ||'.'||l_api_name,
5898: message => 'supplier view type = ' || p_supplier_view_type);
5899: fnd_log.string(log_level=>fnd_log.level_unexpected,
5900: module =>g_pkg_name ||'.'||l_api_name,
5901: message => 'pf type allowed = ' || p_pf_type_allowed);
5902: fnd_log.string(log_level=>fnd_log.level_unexpected,
5903: module =>g_pkg_name ||'.'||l_api_name,

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

5898: message => 'supplier view type = ' || p_supplier_view_type);
5899: fnd_log.string(log_level=>fnd_log.level_unexpected,
5900: module =>g_pkg_name ||'.'||l_api_name,
5901: message => 'pf type allowed = ' || p_pf_type_allowed);
5902: fnd_log.string(log_level=>fnd_log.level_unexpected,
5903: module =>g_pkg_name ||'.'||l_api_name,
5904: message => 'reverse tranform flag = ' || p_reverse_transform_flag);
5905: END IF;
5906: END IF;

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

5977:
5978: -- For each line do the following
5979: FOR auction_item_record IN all_lines_cursor LOOP -- {
5980:
5981: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5982: FND_LOG.string(log_level => FND_LOG.level_statement,
5983: module => g_module_prefix || l_module_name,
5984: message => 'Processing line: ' || auction_item_record.line_number);
5985: END IF; --}

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

5978: -- For each line do the following
5979: FOR auction_item_record IN all_lines_cursor LOOP -- {
5980:
5981: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5982: FND_LOG.string(log_level => FND_LOG.level_statement,
5983: module => g_module_prefix || l_module_name,
5984: message => 'Processing line: ' || auction_item_record.line_number);
5985: END IF; --}
5986:

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

6000: AND pbh.bid_status = 'ACTIVE'
6001: AND pbip.line_number = auction_item_record.line_number
6002: AND ROWNUM = 1;
6003:
6004: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6005: FND_LOG.string(log_level => FND_LOG.level_statement,
6006: module => g_module_prefix || l_module_name,
6007: message => 'Got a bid ' || v_bid_number || ' that was removed from the shortlist.');
6008: END IF; --}

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

6001: AND pbip.line_number = auction_item_record.line_number
6002: AND ROWNUM = 1;
6003:
6004: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6005: FND_LOG.string(log_level => FND_LOG.level_statement,
6006: module => g_module_prefix || l_module_name,
6007: message => 'Got a bid ' || v_bid_number || ' that was removed from the shortlist.');
6008: END IF; --}
6009:

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

6010: EXCEPTION WHEN NO_DATA_FOUND THEN
6011:
6012: v_bid_number := null;
6013:
6014: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6015: FND_LOG.string(log_level => FND_LOG.level_statement,
6016: module => g_module_prefix || l_module_name,
6017: message => 'Could not find any bid that was removed from the shortlist.');
6018: END IF; --}

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

6011:
6012: v_bid_number := null;
6013:
6014: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6015: FND_LOG.string(log_level => FND_LOG.level_statement,
6016: module => g_module_prefix || l_module_name,
6017: message => 'Could not find any bid that was removed from the shortlist.');
6018: END IF; --}
6019:

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

6021:
6022: -- If all are shortlisted then nothing to do for this line
6023: IF (v_bid_number IS NOT null) THEN -- {
6024:
6025: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6026: FND_LOG.string(log_level => FND_LOG.level_statement,
6027: module => g_module_prefix || l_module_name,
6028: message => 'v_bid_number is not null, there is one bid to be removed.');
6029: END IF; --}

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

6022: -- If all are shortlisted then nothing to do for this line
6023: IF (v_bid_number IS NOT null) THEN -- {
6024:
6025: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6026: FND_LOG.string(log_level => FND_LOG.level_statement,
6027: module => g_module_prefix || l_module_name,
6028: message => 'v_bid_number is not null, there is one bid to be removed.');
6029: END IF; --}
6030:

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

6042: WHERE
6043: paip.auction_header_id = p_auction_header_id
6044: AND paip.line_number = auction_item_record.line_number;
6045:
6046: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6047: FND_LOG.string(log_level => FND_LOG.level_statement,
6048: module => g_module_prefix || l_module_name,
6049: message => 'Got the best bid_number. v_best_bid_number = ' ||
6050: v_best_bid_number || ', v_best_bid_bid_number = ' ||

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

6043: paip.auction_header_id = p_auction_header_id
6044: AND paip.line_number = auction_item_record.line_number;
6045:
6046: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6047: FND_LOG.string(log_level => FND_LOG.level_statement,
6048: module => g_module_prefix || l_module_name,
6049: message => 'Got the best bid_number. v_best_bid_number = ' ||
6050: v_best_bid_number || ', v_best_bid_bid_number = ' ||
6051: v_best_bid_bid_number || ', v_currentline_group_type = ' ||

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

6063: pon_bid_headers pbh
6064: WHERE
6065: pbh.bid_number = v_best_bid_number;
6066:
6067: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6068: FND_LOG.string(log_level => FND_LOG.level_statement,
6069: module => g_module_prefix || l_module_name,
6070: message => 'Got the best bid_number. ' || ', v_bestbid_shortlist_flag = ' ||
6071: v_bestbid_shortlist_flag);

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

6064: WHERE
6065: pbh.bid_number = v_best_bid_number;
6066:
6067: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6068: FND_LOG.string(log_level => FND_LOG.level_statement,
6069: module => g_module_prefix || l_module_name,
6070: message => 'Got the best bid_number. ' || ', v_bestbid_shortlist_flag = ' ||
6071: v_bestbid_shortlist_flag);
6072: END IF; --}

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

6073:
6074: IF (v_bestbid_shortlist_flag = 'Y' AND p_bid_ranking =
6075: 'MULTI_ATTRIBUTE_SCORING') THEN -- {
6076:
6077: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6078: FND_LOG.string(log_level => FND_LOG.level_statement,
6079: module => g_module_prefix || l_module_name,
6080: message => 'This is an MAS and the best_bid_number has been shortlisted');
6081: END IF; --}

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

6074: IF (v_bestbid_shortlist_flag = 'Y' AND p_bid_ranking =
6075: 'MULTI_ATTRIBUTE_SCORING') THEN -- {
6076:
6077: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6078: FND_LOG.string(log_level => FND_LOG.level_statement,
6079: module => g_module_prefix || l_module_name,
6080: message => 'This is an MAS and the best_bid_number has been shortlisted');
6081: END IF; --}
6082:

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

6090: pbh.bid_number = v_best_bid_bid_number;
6091:
6092: END IF; -- }
6093:
6094: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6095: FND_LOG.string(log_level => FND_LOG.level_statement,
6096: module => g_module_prefix || l_module_name,
6097: message => 'After MAS check. Got the best bid_number. ' || ', v_bestbid_shortlist_flag = ' ||
6098: v_bestbid_shortlist_flag);

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

6091:
6092: END IF; -- }
6093:
6094: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6095: FND_LOG.string(log_level => FND_LOG.level_statement,
6096: module => g_module_prefix || l_module_name,
6097: message => 'After MAS check. Got the best bid_number. ' || ', v_bestbid_shortlist_flag = ' ||
6098: v_bestbid_shortlist_flag);
6099: END IF; --}

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

6100:
6101: -- If this bid has not been shortlisted then
6102: IF (v_bestbid_shortlist_flag = 'N') THEN -- {
6103:
6104: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6105: FND_LOG.string(log_level => FND_LOG.level_statement,
6106: module => g_module_prefix || l_module_name,
6107: message => 'The best bid has not been shortlisted.');
6108: END IF; --}

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

6101: -- If this bid has not been shortlisted then
6102: IF (v_bestbid_shortlist_flag = 'N') THEN -- {
6103:
6104: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6105: FND_LOG.string(log_level => FND_LOG.level_statement,
6106: module => g_module_prefix || l_module_name,
6107: message => 'The best bid has not been shortlisted.');
6108: END IF; --}
6109:

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

6154: bidline.publish_date asc)
6155: WHERE
6156: rownum = 1;
6157:
6158: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6159: FND_LOG.string(log_level => FND_LOG.level_statement,
6160: module => g_module_prefix || l_module_name,
6161: message => 'Found another best bid.');
6162: END IF; --}

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

6155: WHERE
6156: rownum = 1;
6157:
6158: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6159: FND_LOG.string(log_level => FND_LOG.level_statement,
6160: module => g_module_prefix || l_module_name,
6161: message => 'Found another best bid.');
6162: END IF; --}
6163:

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

6162: END IF; --}
6163:
6164: EXCEPTION WHEN NO_DATA_FOUND THEN
6165:
6166: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6167: FND_LOG.string(log_level => FND_LOG.level_statement,
6168: module => g_module_prefix || l_module_name,
6169: message => 'Could not find another best bid.');
6170: END IF; --}

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

6163:
6164: EXCEPTION WHEN NO_DATA_FOUND THEN
6165:
6166: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6167: FND_LOG.string(log_level => FND_LOG.level_statement,
6168: module => g_module_prefix || l_module_name,
6169: message => 'Could not find another best bid.');
6170: END IF; --}
6171:

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

6178: t_first_bid_price := null;
6179: t_proxy_bid_limit_price := null;
6180: END; -- }
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 => 'Queries values from best bid: t_price = ' || t_price
6186: || ', t_quantity = ' || t_quantity || ', t_promised_date = ' ||

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

6179: t_proxy_bid_limit_price := null;
6180: END; -- }
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 => 'Queries values from best bid: t_price = ' || t_price
6186: || ', t_quantity = ' || t_quantity || ', t_promised_date = ' ||
6187: t_promised_date || ', t_bid_number = ' || t_bid_number

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

6192: END IF; --}
6193:
6194: IF (v_currentline_group_type = 'GROUP') THEN -- {
6195:
6196: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6197: FND_LOG.string(log_level => FND_LOG.level_statement,
6198: module => g_module_prefix || l_module_name,
6199: message => 'Current line is a group no need to set all columns, '
6200: || 'just best_bid_number and best_bid_bid_number');

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

6193:
6194: IF (v_currentline_group_type = 'GROUP') THEN -- {
6195:
6196: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6197: FND_LOG.string(log_level => FND_LOG.level_statement,
6198: module => g_module_prefix || l_module_name,
6199: message => 'Current line is a group no need to set all columns, '
6200: || 'just best_bid_number and best_bid_bid_number');
6201: END IF; --}

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

6209: AND line_number = auction_item_record.line_number;
6210:
6211: ELSE -- } {
6212:
6213: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6214: FND_LOG.string(log_level => FND_LOG.level_statement,
6215: module => g_module_prefix || l_module_name,
6216: message => 'This is not a GROUP line.');
6217: END IF; --}

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

6210:
6211: ELSE -- } {
6212:
6213: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6214: FND_LOG.string(log_level => FND_LOG.level_statement,
6215: module => g_module_prefix || l_module_name,
6216: message => 'This is not a GROUP line.');
6217: END IF; --}
6218:

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

6232: AND line_number = auction_item_record.line_number;
6233:
6234: END IF; -- }
6235:
6236: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6237: FND_LOG.string(log_level => FND_LOG.level_statement,
6238: module => g_module_prefix || l_module_name,
6239: message => 'Updated pon_auction_item_prices_all');
6240: END IF; --}

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

6233:
6234: END IF; -- }
6235:
6236: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6237: FND_LOG.string(log_level => FND_LOG.level_statement,
6238: module => g_module_prefix || l_module_name,
6239: message => 'Updated pon_auction_item_prices_all');
6240: END IF; --}
6241:

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

6240: END IF; --}
6241:
6242: IF (p_bid_ranking = 'MULTI_ATTRIBUTE_SCORING') THEN -- {
6243:
6244: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6245: FND_LOG.string(log_level => FND_LOG.level_statement,
6246: module => g_module_prefix || l_module_name,
6247: message => 'This is an MAS auction.');
6248: END IF; --}

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

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

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

6304: t_bid_currency_price := null;
6305: t_bid_currency_code := null;
6306: END; -- }
6307:
6308: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6309: FND_LOG.string(log_level => FND_LOG.level_statement,
6310: module => g_module_prefix || l_module_name,
6311: message => 'Queries best MAS bid values: t_price = ' || t_price
6312: || 't_score = ' || t_score || ', t_bid_number = ' ||

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

6305: t_bid_currency_code := null;
6306: END; -- }
6307:
6308: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6309: FND_LOG.string(log_level => FND_LOG.level_statement,
6310: module => g_module_prefix || l_module_name,
6311: message => 'Queries best MAS bid values: t_price = ' || t_price
6312: || 't_score = ' || t_score || ', t_bid_number = ' ||
6313: t_bid_number || ', t_bid_currency_price = ' ||

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

6326: WHERE
6327: auction_header_id = p_auction_header_id
6328: AND line_number = auction_item_record.line_number;
6329:
6330: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6331: FND_LOG.string(log_level => FND_LOG.level_statement,
6332: module => g_module_prefix || l_module_name,
6333: message => 'Updated pon_auction_item_prices_all');
6334: END IF; --}

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

6327: auction_header_id = p_auction_header_id
6328: AND line_number = auction_item_record.line_number;
6329:
6330: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6331: FND_LOG.string(log_level => FND_LOG.level_statement,
6332: module => g_module_prefix || l_module_name,
6333: message => 'Updated pon_auction_item_prices_all');
6334: END IF; --}
6335:

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

6341:
6342: -- Do the resetting of ranks only if the rank indicator is numbering
6343: IF (p_rank_indicator = 'NUMBERING') THEN -- {
6344:
6345: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6346: FND_LOG.string(log_level => FND_LOG.level_statement,
6347: module => g_module_prefix || l_module_name,
6348: message => 'The rank indicator for this auction is NUMBERING.');
6349: END IF; --}

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

6342: -- Do the resetting of ranks only if the rank indicator is numbering
6343: IF (p_rank_indicator = 'NUMBERING') THEN -- {
6344:
6345: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6346: FND_LOG.string(log_level => FND_LOG.level_statement,
6347: module => g_module_prefix || l_module_name,
6348: message => 'The rank indicator for this auction is NUMBERING.');
6349: END IF; --}
6350:

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

6371: AND nvl (pbh.shortlist_flag, 'Y') = 'Y'
6372: ORDER BY
6373: pbip.rank;
6374:
6375: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6376: FND_LOG.string(log_level => FND_LOG.level_statement,
6377: module => g_module_prefix || l_module_name,
6378: message => 'Bulk collected the ranks and bid numbers.');
6379: END IF; --}

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

6372: ORDER BY
6373: pbip.rank;
6374:
6375: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6376: FND_LOG.string(log_level => FND_LOG.level_statement,
6377: module => g_module_prefix || l_module_name,
6378: message => 'Bulk collected the ranks and bid numbers.');
6379: END IF; --}
6380:

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

6381: -- Loop over and set the rank starting from 1
6382: FOR x IN 1..v_bid_numbers_bulk.COUNT LOOP -- {
6383: v_rank_bulk (x) := x;
6384:
6385: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6386: FND_LOG.string(log_level => FND_LOG.level_statement,
6387: module => g_module_prefix || l_module_name,
6388: message => 'Setting rank as ' || v_rank_bulk (x) || ' for bid '
6389: || v_bid_numbers_bulk (x));

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

6382: FOR x IN 1..v_bid_numbers_bulk.COUNT LOOP -- {
6383: v_rank_bulk (x) := x;
6384:
6385: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6386: FND_LOG.string(log_level => FND_LOG.level_statement,
6387: module => g_module_prefix || l_module_name,
6388: message => 'Setting rank as ' || v_rank_bulk (x) || ' for bid '
6389: || v_bid_numbers_bulk (x));
6390: END IF; --}

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

6396: SET rank = v_rank_bulk (x)
6397: WHERE bid_number = v_bid_numbers_bulk (x)
6398: AND line_number = auction_item_record.line_number;
6399:
6400: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6401: FND_LOG.string(log_level => FND_LOG.level_statement,
6402: module => g_module_prefix || l_module_name,
6403: message => 'Done updating the ranks for all the bid items.');
6404: END IF; --}

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

6397: WHERE bid_number = v_bid_numbers_bulk (x)
6398: AND line_number = auction_item_record.line_number;
6399:
6400: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6401: FND_LOG.string(log_level => FND_LOG.level_statement,
6402: module => g_module_prefix || l_module_name,
6403: message => 'Done updating the ranks for all the bid items.');
6404: END IF; --}
6405:

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

6416: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
6417: x_error_code := SQLCODE;
6418: x_error_msg := SUBSTR(SQLERRM, 1, 100);
6419:
6420: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
6421: FND_LOG.string (log_level => FND_LOG.level_exception,
6422: module => g_module_prefix || l_module_name,
6423: message => 'Unexpected exception occured error_code = ' || x_error_code ||
6424: ', error_message = ' || x_error_msg);

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

6417: x_error_code := SQLCODE;
6418: x_error_msg := SUBSTR(SQLERRM, 1, 100);
6419:
6420: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
6421: FND_LOG.string (log_level => FND_LOG.level_exception,
6422: module => g_module_prefix || l_module_name,
6423: message => 'Unexpected exception occured error_code = ' || x_error_code ||
6424: ', error_message = ' || x_error_msg);
6425: END IF;

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

6459: l_module_name CONSTANT VARCHAR2 (40) := 'updt_tech_short_lines_batched';
6460:
6461: BEGIN
6462:
6463: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
6464: FND_LOG.string(log_level => FND_LOG.level_procedure,
6465: module => g_module_prefix || l_module_name,
6466: message => 'Entering procedure with p_auction_header_id: ' || p_auction_header_id || '; p_bid_ranking: ' || p_bid_ranking || '; p_max_line_number: '
6467: || p_max_line_number || '; p_batch_size: ' || p_batch_size);

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

6460:
6461: BEGIN
6462:
6463: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
6464: FND_LOG.string(log_level => FND_LOG.level_procedure,
6465: module => g_module_prefix || l_module_name,
6466: message => 'Entering procedure with p_auction_header_id: ' || p_auction_header_id || '; p_bid_ranking: ' || p_bid_ranking || '; p_max_line_number: '
6467: || p_max_line_number || '; p_batch_size: ' || p_batch_size);
6468: END IF; --}

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

6486: v_batch_end := v_batch_end + p_batch_size;
6487: END IF; -- }
6488:
6489: END LOOP; -- }
6490: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
6491: FND_LOG.string(log_level => FND_LOG.level_procedure,
6492: module => g_module_prefix || l_module_name,
6493: message => 'Leaving procedure');
6494: END IF; --}

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

6487: END IF; -- }
6488:
6489: END LOOP; -- }
6490: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
6491: FND_LOG.string(log_level => FND_LOG.level_procedure,
6492: module => g_module_prefix || l_module_name,
6493: message => 'Leaving procedure');
6494: END IF; --}
6495:

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

6498: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
6499: x_error_code := SQLCODE;
6500: x_error_msg := SUBSTR(SQLERRM, 1, 100);
6501:
6502: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
6503: FND_LOG.string (log_level => FND_LOG.level_exception,
6504: module => g_module_prefix || l_module_name,
6505: message => 'Unexpected exception occured error_code = ' || x_error_code ||
6506: ', error_message = ' || x_error_msg);

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

6499: x_error_code := SQLCODE;
6500: x_error_msg := SUBSTR(SQLERRM, 1, 100);
6501:
6502: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
6503: FND_LOG.string (log_level => FND_LOG.level_exception,
6504: module => g_module_prefix || l_module_name,
6505: message => 'Unexpected exception occured error_code = ' || x_error_code ||
6506: ', error_message = ' || x_error_msg);
6507: END IF;

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

6543: BEGIN
6544:
6545: x_result := FND_API.G_RET_STS_SUCCESS;
6546:
6547: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
6548: FND_LOG.string(log_level => FND_LOG.level_procedure,
6549: module => g_module_prefix || l_module_name,
6550: message => 'Entered procedure with p_auction_header_id = ' ||
6551: p_auction_header_id || ', p_user_id = ' ||

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

6544:
6545: x_result := FND_API.G_RET_STS_SUCCESS;
6546:
6547: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
6548: FND_LOG.string(log_level => FND_LOG.level_procedure,
6549: module => g_module_prefix || l_module_name,
6550: message => 'Entered procedure with p_auction_header_id = ' ||
6551: p_auction_header_id || ', p_user_id = ' ||
6552: p_user_id);

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

6568: AND ROWNUM = 1;
6569:
6570: l_reranking_required := 'Y';
6571:
6572: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6573: FND_LOG.string(log_level => FND_LOG.level_statement,
6574: module => g_module_prefix || l_module_name,
6575: message => 'Found a bid that was not shortlisted.');
6576: END IF; --}

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

6569:
6570: l_reranking_required := 'Y';
6571:
6572: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6573: FND_LOG.string(log_level => FND_LOG.level_statement,
6574: module => g_module_prefix || l_module_name,
6575: message => 'Found a bid that was not shortlisted.');
6576: END IF; --}
6577:

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

6577:
6578: EXCEPTION WHEN NO_DATA_FOUND THEN
6579: l_reranking_required := 'N';
6580:
6581: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6582: FND_LOG.string(log_level => FND_LOG.level_statement,
6583: module => g_module_prefix || l_module_name,
6584: message => 'Could not find a bid that was not shortlisted.');
6585: END IF; --}

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

6578: EXCEPTION WHEN NO_DATA_FOUND THEN
6579: l_reranking_required := 'N';
6580:
6581: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6582: FND_LOG.string(log_level => FND_LOG.level_statement,
6583: module => g_module_prefix || l_module_name,
6584: message => 'Could not find a bid that was not shortlisted.');
6585: END IF; --}
6586:

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

6601: auction_header_id = p_auction_header_id
6602: FOR
6603: UPDATE OF close_bidding_date;
6604:
6605: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6606: FND_LOG.string(log_level => FND_LOG.level_statement,
6607: module => g_module_prefix || l_module_name,
6608: message => 'rank_indicator = ' || v_rank_indicator ||
6609: ', bid_ranking = ' || v_bid_ranking ||

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

6602: FOR
6603: UPDATE OF close_bidding_date;
6604:
6605: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6606: FND_LOG.string(log_level => FND_LOG.level_statement,
6607: module => g_module_prefix || l_module_name,
6608: message => 'rank_indicator = ' || v_rank_indicator ||
6609: ', bid_ranking = ' || v_bid_ranking ||
6610: ', max_internal_line_num = ' || v_max_internal_line_num);

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

6619: pbh.technical_shortlist_flag = decode (pbh.bid_status, 'ACTIVE', nvl (pbh.shortlist_flag, 'Y'), 'N')
6620: WHERE
6621: pbh.auction_header_id = p_auction_header_id;
6622:
6623: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6624: FND_LOG.string(log_level => FND_LOG.level_statement,
6625: module => g_module_prefix || l_module_name,
6626: message => 'Done with updating pon_bid_headers.');
6627: END IF; --}

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

6620: WHERE
6621: pbh.auction_header_id = p_auction_header_id;
6622:
6623: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6624: FND_LOG.string(log_level => FND_LOG.level_statement,
6625: module => g_module_prefix || l_module_name,
6626: message => 'Done with updating pon_bid_headers.');
6627: END IF; --}
6628:

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

6667: paha.sealed_unlock_tp_contact_id = p_user_id
6668: WHERE
6669: paha.auction_header_id = p_auction_header_id;
6670:
6671: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
6672: FND_LOG.string(log_level => FND_LOG.level_procedure,
6673: module => g_module_prefix || l_module_name,
6674: message => 'Leaving procedure');
6675: END IF; --}

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

6668: WHERE
6669: paha.auction_header_id = p_auction_header_id;
6670:
6671: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
6672: FND_LOG.string(log_level => FND_LOG.level_procedure,
6673: module => g_module_prefix || l_module_name,
6674: message => 'Leaving procedure');
6675: END IF; --}
6676:

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

6679: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
6680: x_error_code := SQLCODE;
6681: x_error_msg := SUBSTR(SQLERRM, 1, 100);
6682:
6683: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
6684: FND_LOG.string (log_level => FND_LOG.level_exception,
6685: module => g_module_prefix || l_module_name,
6686: message => 'Unexpected exception occured error_code = ' || x_error_code ||
6687: ', error_message = ' || x_error_msg);

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

6680: x_error_code := SQLCODE;
6681: x_error_msg := SUBSTR(SQLERRM, 1, 100);
6682:
6683: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
6684: FND_LOG.string (log_level => FND_LOG.level_exception,
6685: module => g_module_prefix || l_module_name,
6686: message => 'Unexpected exception occured error_code = ' || x_error_code ||
6687: ', error_message = ' || x_error_msg);
6688: END IF;