eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AWARD_PKG dependencies on FND_LOG

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

551: IF (p_scoring_lock_tpc_id = -1) THEN
552: NULL;
553: ELSE
554: -- call pvt API to lock scoring
555: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
556: fnd_log.string(log_level => fnd_log.level_unexpected
557: ,module => 'pon_award_pkg.complete_award'
558: ,message => 'before calling private API to lock team scoring');
559: END IF;

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

552: NULL;
553: ELSE
554: -- call pvt API to lock scoring
555: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
556: fnd_log.string(log_level => fnd_log.level_unexpected
557: ,module => 'pon_award_pkg.complete_award'
558: ,message => 'before calling private API to lock team scoring');
559: END IF;
560:

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

565: ,x_msg_data => x_msg_data
566: ,x_msg_count => x_msg_count);
567:
568: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
569: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
570: fnd_log.string(log_level => fnd_log.level_unexpected
571: ,module => 'pon_award_pkg.complete_award'
572: ,message => 'Error while locking team scoring');
573: END IF;

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

566: ,x_msg_count => x_msg_count);
567:
568: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
569: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
570: fnd_log.string(log_level => fnd_log.level_unexpected
571: ,module => 'pon_award_pkg.complete_award'
572: ,message => 'Error while locking team scoring');
573: END IF;
574: END IF;

Line 789: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

785: BEGIN
786: --
787: --
788: IF (g_debug_mode = 'Y') THEN
789: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
790: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'Entering procedure with p_auctioneer_id: ' || p_auctioneer_id );
791: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION',' p_last_update_date : '|| p_last_update_date || ' ,p_mode : '|| p_mode || ' ,p_line_num : '|| p_line_num);
792: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION',' p_batch_id : '|| p_batch_id || ' ,p_auction_header_id : ' || p_auction_header_id );
793: END IF;

Line 790: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'Entering procedure with p_auctioneer_id: ' || p_auctioneer_id );

786: --
787: --
788: IF (g_debug_mode = 'Y') THEN
789: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
790: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'Entering procedure with p_auctioneer_id: ' || p_auctioneer_id );
791: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION',' p_last_update_date : '|| p_last_update_date || ' ,p_mode : '|| p_mode || ' ,p_line_num : '|| p_line_num);
792: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION',' p_batch_id : '|| p_batch_id || ' ,p_auction_header_id : ' || p_auction_header_id );
793: END IF;
794: END IF;

Line 791: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION',' p_last_update_date : '|| p_last_update_date || ' ,p_mode : '|| p_mode || ' ,p_line_num : '|| p_line_num);

787: --
788: IF (g_debug_mode = 'Y') THEN
789: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
790: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'Entering procedure with p_auctioneer_id: ' || p_auctioneer_id );
791: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION',' p_last_update_date : '|| p_last_update_date || ' ,p_mode : '|| p_mode || ' ,p_line_num : '|| p_line_num);
792: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION',' p_batch_id : '|| p_batch_id || ' ,p_auction_header_id : ' || p_auction_header_id );
793: END IF;
794: END IF;
795:

Line 792: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION',' p_batch_id : '|| p_batch_id || ' ,p_auction_header_id : ' || p_auction_header_id );

788: IF (g_debug_mode = 'Y') THEN
789: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
790: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'Entering procedure with p_auctioneer_id: ' || p_auctioneer_id );
791: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION',' p_last_update_date : '|| p_last_update_date || ' ,p_mode : '|| p_mode || ' ,p_line_num : '|| p_line_num);
792: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION',' p_batch_id : '|| p_batch_id || ' ,p_auction_header_id : ' || p_auction_header_id );
793: END IF;
794: END IF;
795:
796: l_neg_has_lines := PON_AUCTION_PKG.neg_has_lines(p_auction_header_id);

Line 804: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

800: from pon_auction_headers_all
801: where auction_header_id = p_auction_header_id
802: and rownum =1;
803:
804: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
805: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'START');
806: END IF;
807: --
808: l_matrix_index := 0;

Line 805: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'START');

801: where auction_header_id = p_auction_header_id
802: and rownum =1;
803:
804: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
805: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'START');
806: END IF;
807: --
808: l_matrix_index := 0;
809: l_award_date := SYSDATE;

Line 949: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

945: where bid_number = l_rec.bid_number
946: and line_number = p_line_num;
947:
948: IF (g_debug_mode = 'Y') THEN
949: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
950: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'bid_number ' || l_rec.bid_number ||' ; line number ' ||p_line_num|| ' ; has_quantity_tiers ' || l_has_quantity_tiers);
951: END IF;
952: END IF;
953:

Line 950: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'bid_number ' || l_rec.bid_number ||' ; line number ' ||p_line_num|| ' ; has_quantity_tiers ' || l_has_quantity_tiers);

946: and line_number = p_line_num;
947:
948: IF (g_debug_mode = 'Y') THEN
949: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
950: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'bid_number ' || l_rec.bid_number ||' ; line number ' ||p_line_num|| ' ; has_quantity_tiers ' || l_has_quantity_tiers);
951: END IF;
952: END IF;
953:
954: -- Construct Matrix in any case (WIN/LOSR)

Line 986: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

982: AND paip.line_number = pbs.line_number ),-1)
983: into l_award_shipment_number from dual;
984:
985: IF (g_debug_mode = 'Y') THEN
986: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
987: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'award_shipment_number ' || l_award_shipment_number);
988: END IF;
989: END IF;
990:

Line 987: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'award_shipment_number ' || l_award_shipment_number);

983: into l_award_shipment_number from dual;
984:
985: IF (g_debug_mode = 'Y') THEN
986: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
987: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'award_shipment_number ' || l_award_shipment_number);
988: END IF;
989: END IF;
990:
991: IF ( l_award_shipment_number = -1) THEN --{

Line 1028: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1024:
1025: x_status := 'FAILURE';
1026:
1027: IF (g_debug_mode = 'Y') THEN
1028: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1029: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id||' bid_number : '||l_rec.bid_number||' line_num: '||p_line_num, 'Quantity Tier Violation');
1030: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT,' award_quantity: '||l_rec.award_quantity,'Quantity Tier Violation');
1031: END IF;
1032: END IF;

Line 1029: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id||' bid_number : '||l_rec.bid_number||' line_num: '||p_line_num, 'Quantity Tier Violation');

1025: x_status := 'FAILURE';
1026:
1027: IF (g_debug_mode = 'Y') THEN
1028: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1029: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id||' bid_number : '||l_rec.bid_number||' line_num: '||p_line_num, 'Quantity Tier Violation');
1030: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT,' award_quantity: '||l_rec.award_quantity,'Quantity Tier Violation');
1031: END IF;
1032: END IF;
1033: --} End of l_shipment_number = -1

Line 1030: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT,' award_quantity: '||l_rec.award_quantity,'Quantity Tier Violation');

1026:
1027: IF (g_debug_mode = 'Y') THEN
1028: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1029: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id||' bid_number : '||l_rec.bid_number||' line_num: '||p_line_num, 'Quantity Tier Violation');
1030: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT,' award_quantity: '||l_rec.award_quantity,'Quantity Tier Violation');
1031: END IF;
1032: END IF;
1033: --} End of l_shipment_number = -1
1034: ELSE --{ START of l_award_shipment_number != -1,

Line 1077: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1073: --
1074: END LOOP;
1075: END IF; --}
1076: --
1077: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1078: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'MATRIX BUILT');
1079: END IF;
1080: --
1081: -- Clears the award history in case any for this auction

Line 1078: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'MATRIX BUILT');

1074: END LOOP;
1075: END IF; --}
1076: --
1077: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1078: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'MATRIX BUILT');
1079: END IF;
1080: --
1081: -- Clears the award history in case any for this auction
1082: IF (p_mode = g_AWARD_QUOTE) or (p_mode = g_AWARD_MULTIPLE_LINES) THEN --{

Line 1124: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1120: End IF; --}
1121: --
1122: --
1123: --
1124: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1125: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'READY_TO_COMMIT');
1126: END IF;
1127: --
1128:

Line 1125: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'READY_TO_COMMIT');

1121: --
1122: --
1123: --
1124: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1125: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'READY_TO_COMMIT');
1126: END IF;
1127: --
1128:
1129: /* check if the auction has been modified by some other user

Line 1141: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1137: UPDATE pon_Auction_headers_all
1138: SET last_update_date = SYSDATE
1139: WHERE auction_header_id = p_auction_header_id;
1140: --
1141: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1142: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'SUCCEEDED');
1143: END IF;
1144: --
1145: ELSE

Line 1142: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'SUCCEEDED');

1138: SET last_update_date = SYSDATE
1139: WHERE auction_header_id = p_auction_header_id;
1140: --
1141: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1142: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'SUCCEEDED');
1143: END IF;
1144: --
1145: ELSE
1146: x_status := 'FAILURE';

Line 1148: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1144: --
1145: ELSE
1146: x_status := 'FAILURE';
1147: --
1148: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1149: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'FAILED');
1150: END IF;
1151: --
1152: END IF;

Line 1149: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'FAILED');

1145: ELSE
1146: x_status := 'FAILURE';
1147: --
1148: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1149: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'FAILED');
1150: END IF;
1151: --
1152: END IF;
1153: --

Line 1186: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1182: --
1183: BEGIN
1184:
1185: IF (g_debug_mode = 'Y') THEN
1186: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1187: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'Entering procedure with p_mode: ' || p_mode || ' ,p_auction_id : ' || p_auction_id || ' ,p_auctioneer_id : '|| p_auctioneer_id);
1188: END IF;
1189: END IF;
1190:

Line 1187: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'Entering procedure with p_mode: ' || p_mode || ' ,p_auction_id : ' || p_auction_id || ' ,p_auctioneer_id : '|| p_auctioneer_id);

1183: BEGIN
1184:
1185: IF (g_debug_mode = 'Y') THEN
1186: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1187: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'Entering procedure with p_mode: ' || p_mode || ' ,p_auction_id : ' || p_auction_id || ' ,p_auctioneer_id : '|| p_auctioneer_id);
1188: END IF;
1189: END IF;
1190:
1191: l_size := p_award_lines.COUNT;

Line 1203: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1199: l_award_shipment_number := p_award_lines(l_index).award_shipment_number;
1200: END IF;
1201:
1202: IF (g_debug_mode = 'Y') THEN
1203: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1204: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'l_index : ' || l_index || ' ; award shipment number : ' || l_award_shipment_number || ' ; award quantity : ' || l_award_quantity);
1205: END IF;
1206: END IF;
1207:

Line 1204: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'l_index : ' || l_index || ' ; award shipment number : ' || l_award_shipment_number || ' ; award quantity : ' || l_award_quantity);

1200: END IF;
1201:
1202: IF (g_debug_mode = 'Y') THEN
1203: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1204: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'l_index : ' || l_index || ' ; award shipment number : ' || l_award_shipment_number || ' ; award quantity : ' || l_award_quantity);
1205: END IF;
1206: END IF;
1207:
1208: --

Line 1288: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1284: l_bid_line_key := l_bid_group_map.NEXT(l_bid_line_key);
1285: END LOOP;
1286:
1287: IF (g_debug_mode = 'Y') THEN
1288: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1289: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'Returning to the caller.....');
1290: END IF;
1291: END IF;
1292:

Line 1289: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'Returning to the caller.....');

1285: END LOOP;
1286:
1287: IF (g_debug_mode = 'Y') THEN
1288: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1289: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'Returning to the caller.....');
1290: END IF;
1291: END IF;
1292:
1293: EXCEPTION

Line 1296: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1292:
1293: EXCEPTION
1294: WHEN OTHERS THEN
1295: IF (g_debug_mode = 'Y') THEN
1296: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1297: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'An exception occurred during the execution. Raising the exception.....');
1298: END IF;
1299: END IF;
1300: RAISE;

Line 1297: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'An exception occurred during the execution. Raising the exception.....');

1293: EXCEPTION
1294: WHEN OTHERS THEN
1295: IF (g_debug_mode = 'Y') THEN
1296: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1297: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'An exception occurred during the execution. Raising the exception.....');
1298: END IF;
1299: END IF;
1300: RAISE;
1301: --

Line 1319: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1315: l_award_price NUMBER;
1316: BEGIN
1317:
1318: IF (g_debug_mode = 'Y') THEN
1319: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1320:
1321: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'Entering the procedure for p_bid_number : ' || p_bid_number || ' ; p_line_number : ' || p_line_number);
1322:
1323: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'p_award_quantity : ' || p_award_quantity || ' ;p_award_date : ' || p_award_date || ' ;p_auctioneer_id : ' || p_auctioneer_id);

Line 1321: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'Entering the procedure for p_bid_number : ' || p_bid_number || ' ; p_line_number : ' || p_line_number);

1317:
1318: IF (g_debug_mode = 'Y') THEN
1319: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1320:
1321: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'Entering the procedure for p_bid_number : ' || p_bid_number || ' ; p_line_number : ' || p_line_number);
1322:
1323: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'p_award_quantity : ' || p_award_quantity || ' ;p_award_date : ' || p_award_date || ' ;p_auctioneer_id : ' || p_auctioneer_id);
1324:
1325: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES',' ;p_award_status : ' || p_award_status);

Line 1323: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'p_award_quantity : ' || p_award_quantity || ' ;p_award_date : ' || p_award_date || ' ;p_auctioneer_id : ' || p_auctioneer_id);

1319: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1320:
1321: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'Entering the procedure for p_bid_number : ' || p_bid_number || ' ; p_line_number : ' || p_line_number);
1322:
1323: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'p_award_quantity : ' || p_award_quantity || ' ;p_award_date : ' || p_award_date || ' ;p_auctioneer_id : ' || p_auctioneer_id);
1324:
1325: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES',' ;p_award_status : ' || p_award_status);
1326:
1327: END IF;

Line 1325: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES',' ;p_award_status : ' || p_award_status);

1321: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'Entering the procedure for p_bid_number : ' || p_bid_number || ' ; p_line_number : ' || p_line_number);
1322:
1323: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'p_award_quantity : ' || p_award_quantity || ' ;p_award_date : ' || p_award_date || ' ;p_auctioneer_id : ' || p_auctioneer_id);
1324:
1325: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES',' ;p_award_status : ' || p_award_status);
1326:
1327: END IF;
1328: END IF;
1329:

Line 1347: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1343: AND paip.auction_header_id = pbip.auction_header_id
1344: AND paip.line_number = pbip.line_number;
1345:
1346: IF (g_debug_mode = 'Y') THEN
1347: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1348: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'award_price: ' || l_award_price);
1349: END IF;
1350: END IF;
1351:

Line 1348: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'award_price: ' || l_award_price);

1344: AND paip.line_number = pbip.line_number;
1345:
1346: IF (g_debug_mode = 'Y') THEN
1347: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1348: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'award_price: ' || l_award_price);
1349: END IF;
1350: END IF;
1351:
1352: --

Line 1367: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1363: WHERE Bid_number = p_bid_number AND
1364: Line_Number = p_line_number;
1365:
1366: IF (g_debug_mode = 'Y') THEN
1367: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1368: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'PON_BID_ITEM_PRICES has been updated. Returning to the caller....');
1369: END IF;
1370: END IF;
1371:

Line 1368: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'PON_BID_ITEM_PRICES has been updated. Returning to the caller....');

1364: Line_Number = p_line_number;
1365:
1366: IF (g_debug_mode = 'Y') THEN
1367: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1368: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'PON_BID_ITEM_PRICES has been updated. Returning to the caller....');
1369: END IF;
1370: END IF;
1371:
1372: END update_single_bid_item_prices;

Line 1401: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1397: l_award_price NUMBER;
1398: BEGIN
1399:
1400: IF (g_debug_mode = 'Y') THEN
1401: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1402: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'Entering the procedure for p_bid_number : ' || p_bid_number || ' ; p_line_number : ' || p_line_number);
1403: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'p_award_status : ' || p_award_status || ' ;p_award_quantity : ' || p_award_quantity || ' ;p_award_date : ' || p_award_date);
1404: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT',' p_auctioneer_id : ' || p_auctioneer_id || ' ;p_award_shipment_number : ' || p_award_shipment_number);
1405: END IF;

Line 1402: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'Entering the procedure for p_bid_number : ' || p_bid_number || ' ; p_line_number : ' || p_line_number);

1398: BEGIN
1399:
1400: IF (g_debug_mode = 'Y') THEN
1401: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1402: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'Entering the procedure for p_bid_number : ' || p_bid_number || ' ; p_line_number : ' || p_line_number);
1403: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'p_award_status : ' || p_award_status || ' ;p_award_quantity : ' || p_award_quantity || ' ;p_award_date : ' || p_award_date);
1404: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT',' p_auctioneer_id : ' || p_auctioneer_id || ' ;p_award_shipment_number : ' || p_award_shipment_number);
1405: END IF;
1406: END IF;

Line 1403: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'p_award_status : ' || p_award_status || ' ;p_award_quantity : ' || p_award_quantity || ' ;p_award_date : ' || p_award_date);

1399:
1400: IF (g_debug_mode = 'Y') THEN
1401: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1402: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'Entering the procedure for p_bid_number : ' || p_bid_number || ' ; p_line_number : ' || p_line_number);
1403: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'p_award_status : ' || p_award_status || ' ;p_award_quantity : ' || p_award_quantity || ' ;p_award_date : ' || p_award_date);
1404: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT',' p_auctioneer_id : ' || p_auctioneer_id || ' ;p_award_shipment_number : ' || p_award_shipment_number);
1405: END IF;
1406: END IF;
1407:

Line 1404: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT',' p_auctioneer_id : ' || p_auctioneer_id || ' ;p_award_shipment_number : ' || p_award_shipment_number);

1400: IF (g_debug_mode = 'Y') THEN
1401: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1402: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'Entering the procedure for p_bid_number : ' || p_bid_number || ' ; p_line_number : ' || p_line_number);
1403: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'p_award_status : ' || p_award_status || ' ;p_award_quantity : ' || p_award_quantity || ' ;p_award_date : ' || p_award_date);
1404: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT',' p_auctioneer_id : ' || p_auctioneer_id || ' ;p_award_shipment_number : ' || p_award_shipment_number);
1405: END IF;
1406: END IF;
1407:
1408: --

Line 1430: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN --}

1426: AND pbs.line_number = pbip.line_number
1427: AND pbs.shipment_number = p_award_shipment_number;
1428:
1429: IF (g_debug_mode = 'Y') THEN --{
1430: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN --}
1431: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'award_price: ' || l_award_price);
1432: END IF; --}
1433: END IF; --}
1434:

Line 1431: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'award_price: ' || l_award_price);

1427: AND pbs.shipment_number = p_award_shipment_number;
1428:
1429: IF (g_debug_mode = 'Y') THEN --{
1430: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN --}
1431: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'award_price: ' || l_award_price);
1432: END IF; --}
1433: END IF; --}
1434:
1435: UPDATE PON_BID_ITEM_PRICES

Line 1447: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1443: WHERE Bid_number = p_bid_number AND
1444: Line_Number = p_line_number;
1445:
1446: IF (g_debug_mode = 'Y') THEN
1447: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1448: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'PON_BID_ITEM_PRICES has been updated. Returning to the caller....');
1449: END IF;
1450: END IF;
1451:

Line 1448: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'PON_BID_ITEM_PRICES has been updated. Returning to the caller....');

1444: Line_Number = p_line_number;
1445:
1446: IF (g_debug_mode = 'Y') THEN
1447: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1448: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'PON_BID_ITEM_PRICES has been updated. Returning to the caller....');
1449: END IF;
1450: END IF;
1451:
1452: END upd_single_bid_item_prices_qt;

Line 2506: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

2502: AND NVL(END_DATE,SYSDATE+1) > SYSDATE;
2503: EXCEPTION
2504: WHEN TOO_MANY_ROWS THEN
2505: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
2506: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2507: FND_LOG.string(log_level => FND_LOG.level_unexpected,
2508: module => 'pon.plsql.pon_award_pkg.copy_award_scenario',
2509: message => 'Multiple Users found for person_party_id:'||p_user_id);
2510: END IF;

Line 2507: FND_LOG.string(log_level => FND_LOG.level_unexpected,

2503: EXCEPTION
2504: WHEN TOO_MANY_ROWS THEN
2505: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
2506: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2507: FND_LOG.string(log_level => FND_LOG.level_unexpected,
2508: module => 'pon.plsql.pon_award_pkg.copy_award_scenario',
2509: message => 'Multiple Users found for person_party_id:'||p_user_id);
2510: END IF;
2511: END IF;

Line 2797: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2793: UPDATE pon_Auction_headers_all
2794: SET last_update_date = SYSDATE
2795: WHERE auction_header_id = p_auction_header_id;
2796: --
2797: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2798: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.BATCH_AWARD_SPREADSHEET.AUCTION_ID:'
2799: || p_auction_header_id,'SUCCEEDED.');
2800: END IF;
2801: --

Line 2798: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.BATCH_AWARD_SPREADSHEET.AUCTION_ID:'

2794: SET last_update_date = SYSDATE
2795: WHERE auction_header_id = p_auction_header_id;
2796: --
2797: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2798: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.BATCH_AWARD_SPREADSHEET.AUCTION_ID:'
2799: || p_auction_header_id,'SUCCEEDED.');
2800: END IF;
2801: --
2802: ELSE

Line 2805: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2801: --
2802: ELSE
2803: x_status := 'FAILURE';
2804: --
2805: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2806: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.BATCH_AWARD_SPREADSHEET.AUCTION_ID:'
2807: || p_auction_header_id,'FAILED.');
2808: END IF;
2809: --

Line 2806: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.BATCH_AWARD_SPREADSHEET.AUCTION_ID:'

2802: ELSE
2803: x_status := 'FAILURE';
2804: --
2805: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2806: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.BATCH_AWARD_SPREADSHEET.AUCTION_ID:'
2807: || p_auction_header_id,'FAILED.');
2808: END IF;
2809: --
2810: END IF;

Line 3001: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2997: UPDATE pon_Auction_headers_all
2998: SET last_update_date = SYSDATE
2999: WHERE auction_header_id = p_auction_header_id;
3000: --
3001: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3002: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.SAVE_AWARD_SPREADSHEET.AUCTION_ID:'
3003: || p_auction_header_id,'SUCCEEDED.');
3004: END IF;
3005: --

Line 3002: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.SAVE_AWARD_SPREADSHEET.AUCTION_ID:'

2998: SET last_update_date = SYSDATE
2999: WHERE auction_header_id = p_auction_header_id;
3000: --
3001: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3002: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.SAVE_AWARD_SPREADSHEET.AUCTION_ID:'
3003: || p_auction_header_id,'SUCCEEDED.');
3004: END IF;
3005: --
3006: ELSE

Line 3009: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3005: --
3006: ELSE
3007: x_status := 'FAILURE';
3008: --
3009: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3010: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.SAVE_AWARD_SPREADSHEET.AUCTION_ID:'
3011: || p_auction_header_id,'FAILED.');
3012: END IF;
3013: --

Line 3010: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.SAVE_AWARD_SPREADSHEET.AUCTION_ID:'

3006: ELSE
3007: x_status := 'FAILURE';
3008: --
3009: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3010: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.SAVE_AWARD_SPREADSHEET.AUCTION_ID:'
3011: || p_auction_header_id,'FAILED.');
3012: END IF;
3013: --
3014: END IF;

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

3315: EXCEPTION
3316:
3317: WHEN OTHERS THEN
3318:
3319: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3320: fnd_log.string(log_level => fnd_log.level_unexpected
3321: ,module => 'pon_award_pkg.get_award_totals'
3322: ,message => 'exception occurred while calculating totals ' || SUBSTR(SQLERRM, 1, 200));
3323: END IF;

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

3316:
3317: WHEN OTHERS THEN
3318:
3319: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3320: fnd_log.string(log_level => fnd_log.level_unexpected
3321: ,module => 'pon_award_pkg.get_award_totals'
3322: ,message => 'exception occurred while calculating totals ' || SUBSTR(SQLERRM, 1, 200));
3323: END IF;
3324:

Line 3414: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3410:
3411: l_new_scenario_id := -9999;
3412:
3413: IF (g_debug_mode = 'Y') THEN
3414: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3415: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );
3416: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_cost_constraint_flag : '|| p_cost_constraint_flag || ' ,p_constraint_type : '|| p_constraint_type || ' ,p_internal_type : '|| p_internal_type);
3417: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );
3418: END IF;

Line 3415: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );

3411: l_new_scenario_id := -9999;
3412:
3413: IF (g_debug_mode = 'Y') THEN
3414: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3415: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );
3416: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_cost_constraint_flag : '|| p_cost_constraint_flag || ' ,p_constraint_type : '|| p_constraint_type || ' ,p_internal_type : '|| p_internal_type);
3417: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );
3418: END IF;
3419: END IF;

Line 3416: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_cost_constraint_flag : '|| p_cost_constraint_flag || ' ,p_constraint_type : '|| p_constraint_type || ' ,p_internal_type : '|| p_internal_type);

3412:
3413: IF (g_debug_mode = 'Y') THEN
3414: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3415: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );
3416: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_cost_constraint_flag : '|| p_cost_constraint_flag || ' ,p_constraint_type : '|| p_constraint_type || ' ,p_internal_type : '|| p_internal_type);
3417: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );
3418: END IF;
3419: END IF;
3420:

Line 3417: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );

3413: IF (g_debug_mode = 'Y') THEN
3414: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3415: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );
3416: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_cost_constraint_flag : '|| p_cost_constraint_flag || ' ,p_constraint_type : '|| p_constraint_type || ' ,p_internal_type : '|| p_internal_type);
3417: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );
3418: END IF;
3419: END IF;
3420:
3421: copy_award_scenario(p_scenario_id => p_scenario_id,

Line 3429: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3425: x_status => l_status);
3426:
3427:
3428: IF (g_debug_mode = 'Y') THEN
3429: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3430: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'After copy_award_scenario is called. New scenario id is' || l_new_scenario_id ||' ; Status ' ||l_status);
3431: END IF;
3432: END IF;
3433:

Line 3430: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'After copy_award_scenario is called. New scenario id is' || l_new_scenario_id ||' ; Status ' ||l_status);

3426:
3427:
3428: IF (g_debug_mode = 'Y') THEN
3429: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3430: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'After copy_award_scenario is called. New scenario id is' || l_new_scenario_id ||' ; Status ' ||l_status);
3431: END IF;
3432: END IF;
3433:
3434: IF (l_status <> 'FAILURE') THEN

Line 3445: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3441:
3442: IF (p_internal_type = 'LINE_SPLIT_AWARD') THEN
3443:
3444: IF (g_debug_mode = 'Y') THEN
3445: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3446: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SPLIT_AWARD internal type constraint');
3447: END IF;
3448: END IF;
3449:

Line 3446: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SPLIT_AWARD internal type constraint');

3442: IF (p_internal_type = 'LINE_SPLIT_AWARD') THEN
3443:
3444: IF (g_debug_mode = 'Y') THEN
3445: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3446: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SPLIT_AWARD internal type constraint');
3447: END IF;
3448: END IF;
3449:
3450: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3462: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3458:
3459: ELSIF (p_internal_type = 'LINE_INTEGER_QUANTITY') THEN
3460:
3461: IF (g_debug_mode = 'Y') THEN
3462: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3463: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_INTEGER_QUANTITY internal type constraint');
3464: END IF;
3465: END IF;
3466:

Line 3463: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_INTEGER_QUANTITY internal type constraint');

3459: ELSIF (p_internal_type = 'LINE_INTEGER_QUANTITY') THEN
3460:
3461: IF (g_debug_mode = 'Y') THEN
3462: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3463: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_INTEGER_QUANTITY internal type constraint');
3464: END IF;
3465: END IF;
3466:
3467: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3496: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3492: AND pos.scenario_id = l_new_scenario_id;
3493: EXCEPTION
3494: WHEN OTHERS THEN
3495: IF (g_debug_mode = 'Y') THEN
3496: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3497: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED, l_module, 'Selecting auction info in LINE_AWARD_QTY internal type constraint if condition caused error');
3498: END IF;
3499: END IF;
3500:

Line 3497: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED, l_module, 'Selecting auction info in LINE_AWARD_QTY internal type constraint if condition caused error');

3493: EXCEPTION
3494: WHEN OTHERS THEN
3495: IF (g_debug_mode = 'Y') THEN
3496: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3497: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED, l_module, 'Selecting auction info in LINE_AWARD_QTY internal type constraint if condition caused error');
3498: END IF;
3499: END IF;
3500:
3501: END;

Line 3511: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3507: -- In the above sql for selecting the auction qty as we use nvl to set auction qty to 1,
3508: -- all the above conditions should be satisfied
3509:
3510: IF (g_debug_mode = 'Y') THEN
3511: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3512: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_QTY internal type constraint');
3513: END IF;
3514: END IF;
3515:

Line 3512: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_QTY internal type constraint');

3508: -- all the above conditions should be satisfied
3509:
3510: IF (g_debug_mode = 'Y') THEN
3511: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3512: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_QTY internal type constraint');
3513: END IF;
3514: END IF;
3515:
3516: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3529: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3525:
3526: ELSIF (p_internal_type = 'LINE_AWARD_AMOUNT') THEN
3527:
3528: IF (g_debug_mode = 'Y') THEN
3529: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3530: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_AMOUNT internal type constraint');
3531: END IF;
3532: END IF;
3533:

Line 3530: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_AMOUNT internal type constraint');

3526: ELSIF (p_internal_type = 'LINE_AWARD_AMOUNT') THEN
3527:
3528: IF (g_debug_mode = 'Y') THEN
3529: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3530: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_AMOUNT internal type constraint');
3531: END IF;
3532: END IF;
3533:
3534: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3548: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3544:
3545: ELSIF (p_internal_type = 'LINE_MIN_QTY') THEN
3546:
3547: IF (g_debug_mode = 'Y') THEN
3548: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3549: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_QTY internal type constraint');
3550: END IF;
3551: END IF;
3552:

Line 3549: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_QTY internal type constraint');

3545: ELSIF (p_internal_type = 'LINE_MIN_QTY') THEN
3546:
3547: IF (g_debug_mode = 'Y') THEN
3548: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3549: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_QTY internal type constraint');
3550: END IF;
3551: END IF;
3552:
3553: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3567: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3563:
3564: ELSIF (p_internal_type = 'LINE_MAX_PRICE') THEN
3565:
3566: IF (g_debug_mode = 'Y') THEN
3567: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3568: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MAX_PRICE internal type constraint');
3569: END IF;
3570: END IF;
3571:

Line 3568: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MAX_PRICE internal type constraint');

3564: ELSIF (p_internal_type = 'LINE_MAX_PRICE') THEN
3565:
3566: IF (g_debug_mode = 'Y') THEN
3567: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3568: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MAX_PRICE internal type constraint');
3569: END IF;
3570: END IF;
3571:
3572: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3586: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3582:
3583: ELSIF (p_internal_type = 'LINE_MIN_SCORE') THEN
3584:
3585: IF (g_debug_mode = 'Y') THEN
3586: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3587: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_SCORE internal type constraint');
3588: END IF;
3589: END IF;
3590: -- XYZ - SIMILAR CONDITION NEEDED FOR

Line 3587: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_SCORE internal type constraint');

3583: ELSIF (p_internal_type = 'LINE_MIN_SCORE') THEN
3584:
3585: IF (g_debug_mode = 'Y') THEN
3586: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3587: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_SCORE internal type constraint');
3588: END IF;
3589: END IF;
3590: -- XYZ - SIMILAR CONDITION NEEDED FOR
3591: -- AwardOptConstraint.SINGLE_HEADER_ATTR_CUTOFF

Line 3606: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3602:
3603: ELSIF (p_internal_type = 'LINE_PROMISED_DATE') THEN
3604:
3605: IF (g_debug_mode = 'Y') THEN
3606: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3607: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_PROMISED_DATE internal type constraint');
3608: END IF;
3609: END IF;
3610:

Line 3607: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_PROMISED_DATE internal type constraint');

3603: ELSIF (p_internal_type = 'LINE_PROMISED_DATE') THEN
3604:
3605: IF (g_debug_mode = 'Y') THEN
3606: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3607: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_PROMISED_DATE internal type constraint');
3608: END IF;
3609: END IF;
3610:
3611: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3634: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3630:
3631: IF (p_internal_type = 'LINE_NUM_SUPP') THEN
3632:
3633: IF (g_debug_mode = 'Y') THEN
3634: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3635: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_NUM_SUPP internal type constraint');
3636: END IF;
3637: END IF;
3638:

Line 3635: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_NUM_SUPP internal type constraint');

3631: IF (p_internal_type = 'LINE_NUM_SUPP') THEN
3632:
3633: IF (g_debug_mode = 'Y') THEN
3634: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3635: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_NUM_SUPP internal type constraint');
3636: END IF;
3637: END IF;
3638:
3639: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3653: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3649:
3650: ELSIF (p_internal_type = 'LINE_ANY_ONE_SUPP') THEN
3651:
3652: IF (g_debug_mode = 'Y') THEN
3653: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3654: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_ANY_ONE_SUPP internal type constraint');
3655: END IF;
3656: END IF;
3657:

Line 3654: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_ANY_ONE_SUPP internal type constraint');

3650: ELSIF (p_internal_type = 'LINE_ANY_ONE_SUPP') THEN
3651:
3652: IF (g_debug_mode = 'Y') THEN
3653: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3654: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_ANY_ONE_SUPP internal type constraint');
3655: END IF;
3656: END IF;
3657:
3658: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3683: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3679:
3680: ELSIF (p_constraint_type = 'SUPP_BIZ_CONST') THEN --{
3681:
3682: IF (g_debug_mode = 'Y') THEN
3683: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3684: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating SUPP_BIZ_CONST constraint type');
3685: END IF;
3686: END IF;
3687:

Line 3684: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating SUPP_BIZ_CONST constraint type');

3680: ELSIF (p_constraint_type = 'SUPP_BIZ_CONST') THEN --{
3681:
3682: IF (g_debug_mode = 'Y') THEN
3683: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3684: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating SUPP_BIZ_CONST constraint type');
3685: END IF;
3686: END IF;
3687:
3688: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3704: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3700: ELSIF (p_constraint_type = 'BID_LINE_CONST') THEN --{
3701: IF (p_internal_type = 'LINE_SUPP_SITE_AMT') THEN
3702:
3703: IF (g_debug_mode = 'Y') THEN
3704: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3705: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_AMT internal type constraint');
3706: END IF;
3707: END IF;
3708:

Line 3705: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_AMT internal type constraint');

3701: IF (p_internal_type = 'LINE_SUPP_SITE_AMT') THEN
3702:
3703: IF (g_debug_mode = 'Y') THEN
3704: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3705: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_AMT internal type constraint');
3706: END IF;
3707: END IF;
3708:
3709: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3722: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3718:
3719: ELSIF (p_internal_type = 'LINE_SUPP_SITE_QTT') THEN
3720:
3721: IF (g_debug_mode = 'Y') THEN
3722: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3723: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_QTT internal type constraint');
3724: END IF;
3725: END IF;
3726:

Line 3723: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_QTT internal type constraint');

3719: ELSIF (p_internal_type = 'LINE_SUPP_SITE_QTT') THEN
3720:
3721: IF (g_debug_mode = 'Y') THEN
3722: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3723: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_QTT internal type constraint');
3724: END IF;
3725: END IF;
3726:
3727: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3741: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3737: END IF;
3738: ELSE
3739:
3740: IF (g_debug_mode = 'Y') THEN
3741: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3742: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting constraint from pon_optimize_constraints');
3743: END IF;
3744: END IF;
3745: -- INCLUDES LINE-LEVEL INDIVIDUAL SUPPLIER CONSTRAINTS AS WELL

Line 3742: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting constraint from pon_optimize_constraints');

3738: ELSE
3739:
3740: IF (g_debug_mode = 'Y') THEN
3741: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3742: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting constraint from pon_optimize_constraints');
3743: END IF;
3744: END IF;
3745: -- INCLUDES LINE-LEVEL INDIVIDUAL SUPPLIER CONSTRAINTS AS WELL
3746:

Line 3800: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3796: BEGIN
3797:
3798: l_module := 'pon.plsql.PON_AWARD_PKG.postprocess_cost_of_constraint';
3799: IF (g_debug_mode = 'Y') THEN
3800: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3801: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );
3802: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_constraint_type : '|| p_constraint_type || ' ,p_internal_type : '|| p_internal_type);
3803: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );
3804: END IF;

Line 3801: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );

3797:
3798: l_module := 'pon.plsql.PON_AWARD_PKG.postprocess_cost_of_constraint';
3799: IF (g_debug_mode = 'Y') THEN
3800: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3801: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );
3802: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_constraint_type : '|| p_constraint_type || ' ,p_internal_type : '|| p_internal_type);
3803: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );
3804: END IF;
3805: END IF;

Line 3802: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_constraint_type : '|| p_constraint_type || ' ,p_internal_type : '|| p_internal_type);

3798: l_module := 'pon.plsql.PON_AWARD_PKG.postprocess_cost_of_constraint';
3799: IF (g_debug_mode = 'Y') THEN
3800: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3801: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );
3802: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_constraint_type : '|| p_constraint_type || ' ,p_internal_type : '|| p_internal_type);
3803: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );
3804: END IF;
3805: END IF;
3806:

Line 3803: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );

3799: IF (g_debug_mode = 'Y') THEN
3800: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3801: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );
3802: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_constraint_type : '|| p_constraint_type || ' ,p_internal_type : '|| p_internal_type);
3803: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );
3804: END IF;
3805: END IF;
3806:
3807: -- USE PARENT_SCENARIO_ID TO JOIN TO MAIN SCENARIO

Line 3820: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3816: WHERE COST_SCENARIO.SCENARIO_ID = p_scenario_id
3817: AND PARENT_SCENARIO.SCENARIO_ID = COST_SCENARIO.PARENT_SCENARIO_ID;
3818:
3819: IF (g_debug_mode = 'Y') THEN
3820: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3821: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'After selecting cost: L_COST_OF_CONSTRAINT: ' || L_COST_OF_CONSTRAINT || ' , L_PARENT_SCENARIO_ID: '||L_PARENT_SCENARIO_ID );
3822: END IF;
3823: END IF;
3824:

Line 3821: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'After selecting cost: L_COST_OF_CONSTRAINT: ' || L_COST_OF_CONSTRAINT || ' , L_PARENT_SCENARIO_ID: '||L_PARENT_SCENARIO_ID );

3817: AND PARENT_SCENARIO.SCENARIO_ID = COST_SCENARIO.PARENT_SCENARIO_ID;
3818:
3819: IF (g_debug_mode = 'Y') THEN
3820: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3821: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'After selecting cost: L_COST_OF_CONSTRAINT: ' || L_COST_OF_CONSTRAINT || ' , L_PARENT_SCENARIO_ID: '||L_PARENT_SCENARIO_ID );
3822: END IF;
3823: END IF;
3824:
3825: -- UPDATE THE CORRESPONDING ROW IN CONSTRAINTS TABLE

Line 3833: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3829:
3830: IF (p_internal_type = 'LINE_SPLIT_AWARD') THEN
3831:
3832: IF (g_debug_mode = 'Y') THEN
3833: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3834: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SPLIT_AWARD internal type constraint');
3835: END IF;
3836: END IF;
3837:

Line 3834: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SPLIT_AWARD internal type constraint');

3830: IF (p_internal_type = 'LINE_SPLIT_AWARD') THEN
3831:
3832: IF (g_debug_mode = 'Y') THEN
3833: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3834: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SPLIT_AWARD internal type constraint');
3835: END IF;
3836: END IF;
3837:
3838: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3847: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3843:
3844: ELSIF (p_internal_type = 'LINE_INTEGER_QUANTITY') THEN
3845:
3846: IF (g_debug_mode = 'Y') THEN
3847: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3848: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_INTEGER_QUANTITY internal type constraint');
3849: END IF;
3850: END IF;
3851:

Line 3848: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_INTEGER_QUANTITY internal type constraint');

3844: ELSIF (p_internal_type = 'LINE_INTEGER_QUANTITY') THEN
3845:
3846: IF (g_debug_mode = 'Y') THEN
3847: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3848: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_INTEGER_QUANTITY internal type constraint');
3849: END IF;
3850: END IF;
3851:
3852: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3862: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3858:
3859: ELSIF (p_internal_type = 'LINE_AWARD_QTY') THEN
3860:
3861: IF (g_debug_mode = 'Y') THEN
3862: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3863: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_QTY internal type constraint');
3864: END IF;
3865: END IF;
3866:

Line 3863: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_QTY internal type constraint');

3859: ELSIF (p_internal_type = 'LINE_AWARD_QTY') THEN
3860:
3861: IF (g_debug_mode = 'Y') THEN
3862: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3863: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_QTY internal type constraint');
3864: END IF;
3865: END IF;
3866:
3867: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3877: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3873:
3874: ELSIF (p_internal_type = 'LINE_AWARD_AMOUNT') THEN
3875:
3876: IF (g_debug_mode = 'Y') THEN
3877: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3878: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_AMOUNT internal type constraint');
3879: END IF;
3880: END IF;
3881:

Line 3878: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_AMOUNT internal type constraint');

3874: ELSIF (p_internal_type = 'LINE_AWARD_AMOUNT') THEN
3875:
3876: IF (g_debug_mode = 'Y') THEN
3877: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3878: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_AMOUNT internal type constraint');
3879: END IF;
3880: END IF;
3881:
3882: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3892: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3888:
3889: ELSIF (p_internal_type = 'LINE_MIN_QTY') THEN
3890:
3891: IF (g_debug_mode = 'Y') THEN
3892: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3893: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_QTY internal type constraint');
3894: END IF;
3895: END IF;
3896:

Line 3893: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_QTY internal type constraint');

3889: ELSIF (p_internal_type = 'LINE_MIN_QTY') THEN
3890:
3891: IF (g_debug_mode = 'Y') THEN
3892: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3893: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_QTY internal type constraint');
3894: END IF;
3895: END IF;
3896:
3897: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3908: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3904:
3905: ELSIF (p_internal_type = 'LINE_MAX_PRICE') THEN
3906:
3907: IF (g_debug_mode = 'Y') THEN
3908: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3909: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MAX_PRICE internal type constraint');
3910: END IF;
3911: END IF;
3912:

Line 3909: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MAX_PRICE internal type constraint');

3905: ELSIF (p_internal_type = 'LINE_MAX_PRICE') THEN
3906:
3907: IF (g_debug_mode = 'Y') THEN
3908: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3909: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MAX_PRICE internal type constraint');
3910: END IF;
3911: END IF;
3912:
3913: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3924: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3920:
3921: ELSIF (p_internal_type = 'LINE_MIN_SCORE') THEN
3922:
3923: IF (g_debug_mode = 'Y') THEN
3924: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3925: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_SCORE internal type constraint');
3926: END IF;
3927: END IF;
3928:

Line 3925: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_SCORE internal type constraint');

3921: ELSIF (p_internal_type = 'LINE_MIN_SCORE') THEN
3922:
3923: IF (g_debug_mode = 'Y') THEN
3924: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3925: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_SCORE internal type constraint');
3926: END IF;
3927: END IF;
3928:
3929: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3938: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3934:
3935: ELSIF (p_internal_type = 'LINE_PROMISED_DATE') THEN
3936:
3937: IF (g_debug_mode = 'Y') THEN
3938: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3939: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_PROMISED_DATE internal type constraint');
3940: END IF;
3941: END IF;
3942:

Line 3939: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_PROMISED_DATE internal type constraint');

3935: ELSIF (p_internal_type = 'LINE_PROMISED_DATE') THEN
3936:
3937: IF (g_debug_mode = 'Y') THEN
3938: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3939: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_PROMISED_DATE internal type constraint');
3940: END IF;
3941: END IF;
3942:
3943: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3964: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3960:
3961: IF (p_internal_type = 'LINE_NUM_SUPP') THEN
3962:
3963: IF (g_debug_mode = 'Y') THEN
3964: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3965: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_NUM_SUPP internal type constraint');
3966: END IF;
3967: END IF;
3968:

Line 3965: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_NUM_SUPP internal type constraint');

3961: IF (p_internal_type = 'LINE_NUM_SUPP') THEN
3962:
3963: IF (g_debug_mode = 'Y') THEN
3964: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3965: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_NUM_SUPP internal type constraint');
3966: END IF;
3967: END IF;
3968:
3969: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3979: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3975:
3976: ELSIF (p_internal_type = 'LINE_ANY_ONE_SUPP') THEN
3977:
3978: IF (g_debug_mode = 'Y') THEN
3979: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3980: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_ANY_ONE_SUPP internal type constraint');
3981: END IF;
3982: END IF;
3983:

Line 3980: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_ANY_ONE_SUPP internal type constraint');

3976: ELSIF (p_internal_type = 'LINE_ANY_ONE_SUPP') THEN
3977:
3978: IF (g_debug_mode = 'Y') THEN
3979: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3980: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_ANY_ONE_SUPP internal type constraint');
3981: END IF;
3982: END IF;
3983:
3984: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 3997: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3993:
3994: IF (p_internal_type = 'LINE_SUPP_SITE_AMT') THEN
3995:
3996: IF (g_debug_mode = 'Y') THEN
3997: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3998: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_AMT internal type constraint');
3999: END IF;
4000: END IF;
4001:

Line 3998: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_AMT internal type constraint');

3994: IF (p_internal_type = 'LINE_SUPP_SITE_AMT') THEN
3995:
3996: IF (g_debug_mode = 'Y') THEN
3997: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3998: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_AMT internal type constraint');
3999: END IF;
4000: END IF;
4001:
4002: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 4011: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

4007:
4008: ELSIF (p_internal_type = 'LINE_SUPP_SITE_QTT') THEN
4009:
4010: IF (g_debug_mode = 'Y') THEN
4011: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4012: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_QTT internal type constraint');
4013: END IF;
4014: END IF;
4015:

Line 4012: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_QTT internal type constraint');

4008: ELSIF (p_internal_type = 'LINE_SUPP_SITE_QTT') THEN
4009:
4010: IF (g_debug_mode = 'Y') THEN
4011: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4012: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_QTT internal type constraint');
4013: END IF;
4014: END IF;
4015:
4016: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 4026: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

4022: END IF;
4023: ELSIF (p_constraint_type = 'SUPP_BIZ_CONST') THEN
4024:
4025: IF (g_debug_mode = 'Y') THEN
4026: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4027: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating SUPP_BIZ_CONST constraint type');
4028: END IF;
4029: END IF;
4030:

Line 4027: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating SUPP_BIZ_CONST constraint type');

4023: ELSIF (p_constraint_type = 'SUPP_BIZ_CONST') THEN
4024:
4025: IF (g_debug_mode = 'Y') THEN
4026: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4027: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating SUPP_BIZ_CONST constraint type');
4028: END IF;
4029: END IF;
4030:
4031: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 4045: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

4041: p_constraint_type = 'SUPPLIER_CONST' ) THEN
4042:
4043:
4044: IF (g_debug_mode = 'Y') THEN
4045: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4046: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating BUDGET_AMT_CONST, INCUMBENT_SUPP_CONST, ANY_SUPP_CONST, ');
4047: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'SUPP_ASL_CONST, SUPPLIER_CONST constraint types');
4048: END IF;
4049: END IF;

Line 4046: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating BUDGET_AMT_CONST, INCUMBENT_SUPP_CONST, ANY_SUPP_CONST, ');

4042:
4043:
4044: IF (g_debug_mode = 'Y') THEN
4045: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4046: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating BUDGET_AMT_CONST, INCUMBENT_SUPP_CONST, ANY_SUPP_CONST, ');
4047: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'SUPP_ASL_CONST, SUPPLIER_CONST constraint types');
4048: END IF;
4049: END IF;
4050:

Line 4047: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'SUPP_ASL_CONST, SUPPLIER_CONST constraint types');

4043:
4044: IF (g_debug_mode = 'Y') THEN
4045: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4046: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating BUDGET_AMT_CONST, INCUMBENT_SUPP_CONST, ANY_SUPP_CONST, ');
4047: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'SUPP_ASL_CONST, SUPPLIER_CONST constraint types');
4048: END IF;
4049: END IF;
4050:
4051: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 4060: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

4056:
4057: ELSIF (p_constraint_type = 'NUM_OF_SUPP_CONST') THEN
4058:
4059: IF (g_debug_mode = 'Y') THEN
4060: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4061: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating NUM_OF_SUPP_CONST constraint type');
4062: END IF;
4063: END IF;
4064:

Line 4061: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating NUM_OF_SUPP_CONST constraint type');

4057: ELSIF (p_constraint_type = 'NUM_OF_SUPP_CONST') THEN
4058:
4059: IF (g_debug_mode = 'Y') THEN
4060: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4061: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating NUM_OF_SUPP_CONST constraint type');
4062: END IF;
4063: END IF;
4064:
4065: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 4075: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

4071: ELSIF ( p_constraint_type = 'TOTAL_HDR_ATTR_CONST' OR
4072: p_constraint_type = 'HDR_ATTR_CONST' ) THEN
4073:
4074: IF (g_debug_mode = 'Y') THEN
4075: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4076: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating TOTAL_HDR_ATTR_CONST, HDR_ATTR_CONST constraint types');
4077: END IF;
4078: END IF;
4079:

Line 4076: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating TOTAL_HDR_ATTR_CONST, HDR_ATTR_CONST constraint types');

4072: p_constraint_type = 'HDR_ATTR_CONST' ) THEN
4073:
4074: IF (g_debug_mode = 'Y') THEN
4075: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4076: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating TOTAL_HDR_ATTR_CONST, HDR_ATTR_CONST constraint types');
4077: END IF;
4078: END IF;
4079:
4080: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 4089: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

4085:
4086: ELSIF (p_constraint_type = 'INCL_HOLD_SUPP_CONST') THEN
4087:
4088: IF (g_debug_mode = 'Y') THEN
4089: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4090: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating INCL_HOLD_SUPP_CONST constraint type');
4091: END IF;
4092: END IF;
4093:

Line 4090: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating INCL_HOLD_SUPP_CONST constraint type');

4086: ELSIF (p_constraint_type = 'INCL_HOLD_SUPP_CONST') THEN
4087:
4088: IF (g_debug_mode = 'Y') THEN
4089: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4090: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating INCL_HOLD_SUPP_CONST constraint type');
4091: END IF;
4092: END IF;
4093:
4094: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 4103: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

4099:
4100: ELSIF (p_constraint_type = 'NO_SPLIT_GROUP_CONST') THEN
4101:
4102: IF (g_debug_mode = 'Y') THEN
4103: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4104: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating NO_SPLIT_GROUP_CONST constraint type');
4105: END IF;
4106: END IF;
4107:

Line 4104: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating NO_SPLIT_GROUP_CONST constraint type');

4100: ELSIF (p_constraint_type = 'NO_SPLIT_GROUP_CONST') THEN
4101:
4102: IF (g_debug_mode = 'Y') THEN
4103: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4104: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating NO_SPLIT_GROUP_CONST constraint type');
4105: END IF;
4106: END IF;
4107:
4108: UPDATE PON_OPTIMIZE_CONSTRAINTS

Line 4116: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

4112: AND CONSTRAINT_TYPE = p_constraint_type;
4113: END IF;
4114:
4115: IF (g_debug_mode = 'Y') THEN
4116: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4117: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scneario with p_scenario_id: ' || p_scenario_id );
4118: END IF;
4119: END IF;
4120:

Line 4117: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scneario with p_scenario_id: ' || p_scenario_id );

4113: END IF;
4114:
4115: IF (g_debug_mode = 'Y') THEN
4116: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4117: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scneario with p_scenario_id: ' || p_scenario_id );
4118: END IF;
4119: END IF;
4120:
4121: DELETE FROM PON_OPTIMIZE_SCENARIOS WHERE SCENARIO_ID = P_SCENARIO_ID;

Line 4137: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

4133: where scenario_id = p_scenario_id;
4134:
4135: IF (l_num_constraints > 0) THEN
4136: IF (g_debug_mode = 'Y') THEN
4137: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4138: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario constraints from PON_OPTIMIZE_CONSTRAINTS for p_scenario_id: ' || p_scenario_id );
4139: END IF;
4140: END IF;
4141:

Line 4138: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario constraints from PON_OPTIMIZE_CONSTRAINTS for p_scenario_id: ' || p_scenario_id );

4134:
4135: IF (l_num_constraints > 0) THEN
4136: IF (g_debug_mode = 'Y') THEN
4137: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4138: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario constraints from PON_OPTIMIZE_CONSTRAINTS for p_scenario_id: ' || p_scenario_id );
4139: END IF;
4140: END IF;
4141:
4142: DELETE FROM PON_OPTIMIZE_CONSTRAINTS WHERE SCENARIO_ID = P_SCENARIO_ID;

Line 4152: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

4148: where scenario_id = p_scenario_id;
4149:
4150: IF (l_num_bid_classes > 0) THEN
4151: IF (g_debug_mode = 'Y') THEN
4152: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4153: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario details from PON_OPTIMIZE_BID_CLASS for p_scenario_id: ' || p_scenario_id );
4154: END IF;
4155: END IF;
4156:

Line 4153: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario details from PON_OPTIMIZE_BID_CLASS for p_scenario_id: ' || p_scenario_id );

4149:
4150: IF (l_num_bid_classes > 0) THEN
4151: IF (g_debug_mode = 'Y') THEN
4152: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4153: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario details from PON_OPTIMIZE_BID_CLASS for p_scenario_id: ' || p_scenario_id );
4154: END IF;
4155: END IF;
4156:
4157: DELETE FROM PON_OPTIMIZE_BID_CLASS WHERE SCENARIO_ID = P_SCENARIO_ID;

Line 4166: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

4162: where scenario_id = p_scenario_id;
4163:
4164: IF(l_num_results > 0) THEN
4165: IF (g_debug_mode = 'Y') THEN
4166: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4167: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario results from PON_OPTIMIZE_RESULTS for p_scenario_id: ' || p_scenario_id );
4168: END IF;
4169: END IF;
4170:

Line 4167: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario results from PON_OPTIMIZE_RESULTS for p_scenario_id: ' || p_scenario_id );

4163:
4164: IF(l_num_results > 0) THEN
4165: IF (g_debug_mode = 'Y') THEN
4166: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4167: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario results from PON_OPTIMIZE_RESULTS for p_scenario_id: ' || p_scenario_id );
4168: END IF;
4169: END IF;
4170:
4171: DELETE FROM PON_OPTIMIZE_RESULTS WHERE SCENARIO_ID = P_SCENARIO_ID;

Line 4180: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4176:
4177: EXCEPTION
4178: WHEN OTHERS THEN
4179: X_STATUS := 'FAILURE';
4180: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4181: FND_LOG.STRING(log_level => fnd_log.LEVEL_UNEXPECTED
4182: ,module => l_module
4183: ,message => 'When others exception raised in postprocess_cost_of_constraint');
4184: END IF;

Line 4181: FND_LOG.STRING(log_level => fnd_log.LEVEL_UNEXPECTED

4177: EXCEPTION
4178: WHEN OTHERS THEN
4179: X_STATUS := 'FAILURE';
4180: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4181: FND_LOG.STRING(log_level => fnd_log.LEVEL_UNEXPECTED
4182: ,module => l_module
4183: ,message => 'When others exception raised in postprocess_cost_of_constraint');
4184: END IF;
4185: