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 97: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

93:
94:
95: BEGIN
96:
97: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
98: fnd_log.string(log_level => fnd_log.level_unexpected
99: ,module => 'pon_award_pkg.NotifyEmdAdmin'
100: ,message => 'Start calling NotifyEmdAdmin');
101: END IF;

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

94:
95: BEGIN
96:
97: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
98: fnd_log.string(log_level => fnd_log.level_unexpected
99: ,module => 'pon_award_pkg.NotifyEmdAdmin'
100: ,message => 'Start calling NotifyEmdAdmin');
101: END IF;
102: x_progress := '010';

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

200: itemkey => x_itemkey );
201: pon_auction_pkg.UNSET_SESSION_LANGUAGE;
202:
203: x_progress := '029';
204: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
205: fnd_log.string(log_level => fnd_log.level_unexpected
206: ,module => 'pon_award_pkg.NotifyEmdAdmin'
207: ,message => 'End calling NotifyEmdAdmin');
208: END IF;

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

201: pon_auction_pkg.UNSET_SESSION_LANGUAGE;
202:
203: x_progress := '029';
204: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
205: fnd_log.string(log_level => fnd_log.level_unexpected
206: ,module => 'pon_award_pkg.NotifyEmdAdmin'
207: ,message => 'End calling NotifyEmdAdmin');
208: END IF;
209:

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

886: IF (p_scoring_lock_tpc_id = -1) THEN
887: NULL;
888: ELSE
889: -- call pvt API to lock scoring
890: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
891: fnd_log.string(log_level => fnd_log.level_unexpected
892: ,module => 'pon_award_pkg.complete_award'
893: ,message => 'before calling private API to lock team scoring');
894: END IF;

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

887: NULL;
888: ELSE
889: -- call pvt API to lock scoring
890: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
891: fnd_log.string(log_level => fnd_log.level_unexpected
892: ,module => 'pon_award_pkg.complete_award'
893: ,message => 'before calling private API to lock team scoring');
894: END IF;
895:

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

900: ,x_msg_data => x_msg_data
901: ,x_msg_count => x_msg_count);
902:
903: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
904: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
905: fnd_log.string(log_level => fnd_log.level_unexpected
906: ,module => 'pon_award_pkg.complete_award'
907: ,message => 'Error while locking team scoring');
908: END IF;

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

901: ,x_msg_count => x_msg_count);
902:
903: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
904: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
905: fnd_log.string(log_level => fnd_log.level_unexpected
906: ,module => 'pon_award_pkg.complete_award'
907: ,message => 'Error while locking team scoring');
908: END IF;
909: END IF;

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

1152: l_auction_award_qty NUMBER;
1153:
1154: BEGIN
1155: IF (g_debug_mode = 'Y') THEN
1156: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1157: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.award_exhibit_lines', 'Entering procedure with p_auction_header_id : ' || p_auction_header_id || ' p_line_num : ' || p_line_num || ' ,p_auctioneer_id : '|| p_auctioneer_id);
1158: END IF;
1159: END IF;
1160:

Line 1157: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.award_exhibit_lines', 'Entering procedure with p_auction_header_id : ' || p_auction_header_id || ' p_line_num : ' || p_line_num || ' ,p_auctioneer_id : '|| p_auctioneer_id);

1153:
1154: BEGIN
1155: IF (g_debug_mode = 'Y') THEN
1156: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1157: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.award_exhibit_lines', 'Entering procedure with p_auction_header_id : ' || p_auction_header_id || ' p_line_num : ' || p_line_num || ' ,p_auctioneer_id : '|| p_auctioneer_id);
1158: END IF;
1159: END IF;
1160:
1161: FOR elin IN exhibitsCursor LOOP

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

1416: BEGIN
1417: --
1418: --
1419: IF (g_debug_mode = 'Y') THEN
1420: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1421: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'Entering procedure with p_auctioneer_id: ' || p_auctioneer_id );
1422: 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);
1423: 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 );
1424: END IF;

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

1417: --
1418: --
1419: IF (g_debug_mode = 'Y') THEN
1420: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1421: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'Entering procedure with p_auctioneer_id: ' || p_auctioneer_id );
1422: 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);
1423: 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 );
1424: END IF;
1425: END IF;

Line 1422: 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);

1418: --
1419: IF (g_debug_mode = 'Y') THEN
1420: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1421: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'Entering procedure with p_auctioneer_id: ' || p_auctioneer_id );
1422: 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);
1423: 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 );
1424: END IF;
1425: END IF;
1426:

Line 1423: 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 );

1419: IF (g_debug_mode = 'Y') THEN
1420: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1421: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'Entering procedure with p_auctioneer_id: ' || p_auctioneer_id );
1422: 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);
1423: 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 );
1424: END IF;
1425: END IF;
1426:
1427: l_neg_has_lines := PON_AUCTION_PKG.neg_has_lines(p_auction_header_id);

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

1436:
1437: --ELINs project
1438: l_are_exhibits_enabled := PON_EXHIBITS_PKG.IS_EXHIBITS_ENABLED(l_org_id, l_doctype_id);
1439:
1440: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1441: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'START');
1442: END IF;
1443:
1444: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

1437: --ELINs project
1438: l_are_exhibits_enabled := PON_EXHIBITS_PKG.IS_EXHIBITS_ENABLED(l_org_id, l_doctype_id);
1439:
1440: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1441: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'START');
1442: END IF;
1443:
1444: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1445: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.l_are_exhibits_enabled:' || l_are_exhibits_enabled,'');

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

1440: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1441: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'START');
1442: END IF;
1443:
1444: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1445: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.l_are_exhibits_enabled:' || l_are_exhibits_enabled,'');
1446: END IF;
1447: --
1448: l_matrix_index := 0;

Line 1445: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.l_are_exhibits_enabled:' || l_are_exhibits_enabled,'');

1441: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'START');
1442: END IF;
1443:
1444: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1445: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.l_are_exhibits_enabled:' || l_are_exhibits_enabled,'');
1446: END IF;
1447: --
1448: l_matrix_index := 0;
1449: l_award_date := SYSDATE;

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

1634: where bid_number = l_rec.bid_number
1635: and line_number = p_line_num;
1636:
1637: IF (g_debug_mode = 'Y') THEN
1638: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1639: 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);
1640: END IF;
1641: END IF;
1642:

Line 1639: 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);

1635: and line_number = p_line_num;
1636:
1637: IF (g_debug_mode = 'Y') THEN
1638: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1639: 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);
1640: END IF;
1641: END IF;
1642:
1643: -- Construct Matrix in any case (WIN/LOSR)

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

1671: AND paip.line_number = pbs.line_number ),-1)
1672: into l_award_shipment_number from dual;
1673:
1674: IF (g_debug_mode = 'Y') THEN
1675: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1676: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'award_shipment_number ' || l_award_shipment_number);
1677: END IF;
1678: END IF;
1679:

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

1672: into l_award_shipment_number from dual;
1673:
1674: IF (g_debug_mode = 'Y') THEN
1675: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1676: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_AUCTION', 'award_shipment_number ' || l_award_shipment_number);
1677: END IF;
1678: END IF;
1679:
1680: IF ( l_award_shipment_number = -1) THEN --{

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

1713:
1714: x_status := 'FAILURE';
1715:
1716: IF (g_debug_mode = 'Y') THEN
1717: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1718: 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');
1719: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT,' award_quantity: '||l_rec.award_quantity,'Quantity Tier Violation');
1720: END IF;
1721: END IF;

Line 1718: 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');

1714: x_status := 'FAILURE';
1715:
1716: IF (g_debug_mode = 'Y') THEN
1717: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1718: 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');
1719: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT,' award_quantity: '||l_rec.award_quantity,'Quantity Tier Violation');
1720: END IF;
1721: END IF;
1722: --} End of l_shipment_number = -1

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

1715:
1716: IF (g_debug_mode = 'Y') THEN
1717: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1718: 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');
1719: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT,' award_quantity: '||l_rec.award_quantity,'Quantity Tier Violation');
1720: END IF;
1721: END IF;
1722: --} End of l_shipment_number = -1
1723: ELSE --{ START of l_award_shipment_number != -1,

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

1762: --
1763: END LOOP;
1764: END IF; --}
1765: --
1766: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1767: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'MATRIX BUILT');
1768: END IF;
1769: --
1770: -- Clears the award history in case any for this auction

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

1763: END LOOP;
1764: END IF; --}
1765: --
1766: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1767: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'MATRIX BUILT');
1768: END IF;
1769: --
1770: -- Clears the award history in case any for this auction
1771: IF (p_mode = g_AWARD_QUOTE) or (p_mode = g_AWARD_MULTIPLE_LINES) THEN --{

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

1845: End IF; --}
1846: --
1847: --
1848: --
1849: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1850: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'READY_TO_COMMIT');
1851: END IF;
1852: --
1853:

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

1846: --
1847: --
1848: --
1849: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1850: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'READY_TO_COMMIT');
1851: END IF;
1852: --
1853:
1854: /* check if the auction has been modified by some other user

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

1862: UPDATE pon_Auction_headers_all
1863: SET last_update_date = SYSDATE
1864: WHERE auction_header_id = p_auction_header_id;
1865: --
1866: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1867: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'SUCCEEDED');
1868: END IF;
1869: --
1870: ELSE

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

1863: SET last_update_date = SYSDATE
1864: WHERE auction_header_id = p_auction_header_id;
1865: --
1866: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1867: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'SUCCEEDED');
1868: END IF;
1869: --
1870: ELSE
1871: x_status := 'FAILURE';

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

1869: --
1870: ELSE
1871: x_status := 'FAILURE';
1872: --
1873: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1874: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'FAILED');
1875: END IF;
1876: --
1877: END IF;

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

1870: ELSE
1871: x_status := 'FAILURE';
1872: --
1873: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1874: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.AWARD_AUCTION.AUCTION_ID:' || p_auction_header_id,'FAILED');
1875: END IF;
1876: --
1877: END IF;
1878: --

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

1979:
1980: Begin
1981:
1982: IF (g_debug_mode = 'Y') THEN
1983: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1984: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_option_LINES', 'p_auction_header_id ' ||p_auction_header_id || ' p_line_num ' ||p_line_num );
1985: END IF;
1986: END IF;
1987:

Line 1984: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_option_LINES', 'p_auction_header_id ' ||p_auction_header_id || ' p_line_num ' ||p_line_num );

1980: Begin
1981:
1982: IF (g_debug_mode = 'Y') THEN
1983: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1984: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.AWARD_option_LINES', 'p_auction_header_id ' ||p_auction_header_id || ' p_line_num ' ||p_line_num );
1985: END IF;
1986: END IF;
1987:
1988: --ELINs project

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

2159:
2160: l_tmp_award_quantity NUMBER;
2161: BEGIN
2162: IF (g_debug_mode = 'Y') THEN
2163: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2164: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines', 'Entering procedure with p_auction_id: ' || p_auction_id );
2165: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines',' p_bid_number : '|| p_bid_number || ' ,p_mode : '|| p_mode || ' ,p_line_number : '|| p_line_number);
2166: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines',' p_award_status : ' || p_award_status );
2167: END IF;

Line 2164: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines', 'Entering procedure with p_auction_id: ' || p_auction_id );

2160: l_tmp_award_quantity NUMBER;
2161: BEGIN
2162: IF (g_debug_mode = 'Y') THEN
2163: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2164: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines', 'Entering procedure with p_auction_id: ' || p_auction_id );
2165: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines',' p_bid_number : '|| p_bid_number || ' ,p_mode : '|| p_mode || ' ,p_line_number : '|| p_line_number);
2166: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines',' p_award_status : ' || p_award_status );
2167: END IF;
2168: END IF;

Line 2165: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines',' p_bid_number : '|| p_bid_number || ' ,p_mode : '|| p_mode || ' ,p_line_number : '|| p_line_number);

2161: BEGIN
2162: IF (g_debug_mode = 'Y') THEN
2163: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2164: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines', 'Entering procedure with p_auction_id: ' || p_auction_id );
2165: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines',' p_bid_number : '|| p_bid_number || ' ,p_mode : '|| p_mode || ' ,p_line_number : '|| p_line_number);
2166: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines',' p_award_status : ' || p_award_status );
2167: END IF;
2168: END IF;
2169:

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

2162: IF (g_debug_mode = 'Y') THEN
2163: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2164: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines', 'Entering procedure with p_auction_id: ' || p_auction_id );
2165: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines',' p_bid_number : '|| p_bid_number || ' ,p_mode : '|| p_mode || ' ,p_line_number : '|| p_line_number);
2166: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines',' p_award_status : ' || p_award_status );
2167: END IF;
2168: END IF;
2169:
2170: FOR elin IN get_elins_for_line LOOP

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

2168: END IF;
2169:
2170: FOR elin IN get_elins_for_line LOOP
2171: IF (g_debug_mode = 'Y') THEN
2172: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2173: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines', 'Updating line : ' || elin.line_number );
2174: END IF;
2175: END IF;
2176: IF Nvl(p_award_status, 'REJECTED') = 'AWARDED' THEN

Line 2173: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines', 'Updating line : ' || elin.line_number );

2169:
2170: FOR elin IN get_elins_for_line LOOP
2171: IF (g_debug_mode = 'Y') THEN
2172: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2173: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines', 'Updating line : ' || elin.line_number );
2174: END IF;
2175: END IF;
2176: IF Nvl(p_award_status, 'REJECTED') = 'AWARDED' THEN
2177: IF ( p_contract_type IN ('BLANKET','CONTRACT') ) THEN --Get Award Qty FROM Response Qty

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

2190: AND ai.line_number = bi.line_number;
2191: END IF;
2192: END IF;
2193: IF (g_debug_mode = 'Y') THEN
2194: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2195: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines', 'Updating line : ' || elin.line_number || ' Quantity : ' ||l_tmp_award_quantity);
2196: END IF;
2197: END IF;
2198:

Line 2195: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines', 'Updating line : ' || elin.line_number || ' Quantity : ' ||l_tmp_award_quantity);

2191: END IF;
2192: END IF;
2193: IF (g_debug_mode = 'Y') THEN
2194: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2195: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines', 'Updating line : ' || elin.line_number || ' Quantity : ' ||l_tmp_award_quantity);
2196: END IF;
2197: END IF;
2198:
2199: UPDATE PON_BID_ITEM_PRICES pbip

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

2209: WHERE bid_number = p_bid_number
2210: AND line_Number = elin.line_number;
2211:
2212: IF (g_debug_mode = 'Y') THEN
2213: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2214: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines', 'Line Updated : ' || elin.line_number );
2215: END IF;
2216: END IF;
2217:

Line 2214: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines', 'Line Updated : ' || elin.line_number );

2210: AND line_Number = elin.line_number;
2211:
2212: IF (g_debug_mode = 'Y') THEN
2213: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2214: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines', 'Line Updated : ' || elin.line_number );
2215: END IF;
2216: END IF;
2217:
2218: END LOOP;

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

2253: --
2254: BEGIN
2255:
2256: IF (g_debug_mode = 'Y') THEN
2257: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2258: 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);
2259: END IF;
2260: END IF;
2261:

Line 2258: 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);

2254: BEGIN
2255:
2256: IF (g_debug_mode = 'Y') THEN
2257: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2258: 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);
2259: END IF;
2260: END IF;
2261:
2262: --ELINs project

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

2265: WHERE auction_header_id = p_auction_id;
2266:
2267: l_are_exhibits_enabled := PON_EXHIBITS_PKG.IS_EXHIBITS_ENABLED(l_org_id, l_doctype_id);
2268: IF (g_debug_mode = 'Y') THEN
2269: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2270: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'Are Exhibits enabled? ' || l_are_exhibits_enabled);
2271: END IF;
2272: END IF;
2273: --End ELINs project

Line 2270: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'Are Exhibits enabled? ' || l_are_exhibits_enabled);

2266:
2267: l_are_exhibits_enabled := PON_EXHIBITS_PKG.IS_EXHIBITS_ENABLED(l_org_id, l_doctype_id);
2268: IF (g_debug_mode = 'Y') THEN
2269: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2270: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'Are Exhibits enabled? ' || l_are_exhibits_enabled);
2271: END IF;
2272: END IF;
2273: --End ELINs project
2274:

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

2285: l_award_shipment_number := p_award_lines(l_index).award_shipment_number;
2286: END IF;
2287:
2288: IF (g_debug_mode = 'Y') THEN
2289: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2290: 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);
2291: END IF;
2292: END IF;
2293:

Line 2290: 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);

2286: END IF;
2287:
2288: IF (g_debug_mode = 'Y') THEN
2289: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2290: 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);
2291: END IF;
2292: END IF;
2293:
2294: --

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

2384: l_bid_line_key := l_bid_group_map.NEXT(l_bid_line_key);
2385: END LOOP;
2386:
2387: IF (g_debug_mode = 'Y') THEN
2388: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2389: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'Returning to the caller.....');
2390: END IF;
2391: END IF;
2392:

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

2385: END LOOP;
2386:
2387: IF (g_debug_mode = 'Y') THEN
2388: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2389: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_BID_ITEM_PRICES', 'Returning to the caller.....');
2390: END IF;
2391: END IF;
2392:
2393: EXCEPTION

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

2392:
2393: EXCEPTION
2394: WHEN OTHERS THEN
2395: IF (g_debug_mode = 'Y') THEN
2396: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2397: 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.....');
2398: END IF;
2399: END IF;
2400: RAISE;

Line 2397: 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.....');

2393: EXCEPTION
2394: WHEN OTHERS THEN
2395: IF (g_debug_mode = 'Y') THEN
2396: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2397: 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.....');
2398: END IF;
2399: END IF;
2400: RAISE;
2401: --

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

2415: l_award_price NUMBER;
2416: BEGIN
2417:
2418: IF (g_debug_mode = 'Y') THEN
2419: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2420:
2421: 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);
2422:
2423: 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 2421: 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);

2417:
2418: IF (g_debug_mode = 'Y') THEN
2419: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2420:
2421: 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);
2422:
2423: 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);
2424:
2425: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES',' ;p_award_status : ' || p_award_status);

Line 2423: 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);

2419: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2420:
2421: 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);
2422:
2423: 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);
2424:
2425: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES',' ;p_award_status : ' || p_award_status);
2426:
2427: END IF;

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

2421: 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);
2422:
2423: 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);
2424:
2425: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES',' ;p_award_status : ' || p_award_status);
2426:
2427: END IF;
2428: END IF;
2429:

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

2443: AND paip.auction_header_id = pbip.auction_header_id
2444: AND paip.line_number = pbip.line_number;
2445:
2446: IF (g_debug_mode = 'Y') THEN
2447: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2448: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'award_price: ' || l_award_price);
2449: END IF;
2450: END IF;
2451:

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

2444: AND paip.line_number = pbip.line_number;
2445:
2446: IF (g_debug_mode = 'Y') THEN
2447: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2448: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'award_price: ' || l_award_price);
2449: END IF;
2450: END IF;
2451:
2452: --

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

2463: WHERE Bid_number = p_bid_number AND
2464: Line_Number = p_line_number;
2465:
2466: IF (g_debug_mode = 'Y') THEN
2467: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2468: 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....');
2469: END IF;
2470: END IF;
2471:

Line 2468: 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....');

2464: Line_Number = p_line_number;
2465:
2466: IF (g_debug_mode = 'Y') THEN
2467: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2468: 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....');
2469: END IF;
2470: END IF;
2471:
2472: END update_single_bid_item_prices;

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

2497: l_award_price NUMBER;
2498: BEGIN
2499:
2500: IF (g_debug_mode = 'Y') THEN
2501: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2502: 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);
2503: 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);
2504: 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);
2505: END IF;

Line 2502: 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);

2498: BEGIN
2499:
2500: IF (g_debug_mode = 'Y') THEN
2501: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2502: 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);
2503: 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);
2504: 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);
2505: END IF;
2506: END IF;

Line 2503: 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);

2499:
2500: IF (g_debug_mode = 'Y') THEN
2501: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2502: 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);
2503: 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);
2504: 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);
2505: END IF;
2506: END IF;
2507:

Line 2504: 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);

2500: IF (g_debug_mode = 'Y') THEN
2501: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2502: 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);
2503: 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);
2504: 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);
2505: END IF;
2506: END IF;
2507:
2508: --

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

2526: AND pbs.line_number = pbip.line_number
2527: AND pbs.shipment_number = p_award_shipment_number;
2528:
2529: IF (g_debug_mode = 'Y') THEN --{
2530: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN --}
2531: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'award_price: ' || l_award_price);
2532: END IF; --}
2533: END IF; --}
2534:

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

2527: AND pbs.shipment_number = p_award_shipment_number;
2528:
2529: IF (g_debug_mode = 'Y') THEN --{
2530: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN --}
2531: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'award_price: ' || l_award_price);
2532: END IF; --}
2533: END IF; --}
2534:
2535: UPDATE PON_BID_ITEM_PRICES

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

2543: WHERE Bid_number = p_bid_number AND
2544: Line_Number = p_line_number;
2545:
2546: IF (g_debug_mode = 'Y') THEN
2547: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2548: 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....');
2549: END IF;
2550: END IF;
2551:

Line 2548: 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....');

2544: Line_Number = p_line_number;
2545:
2546: IF (g_debug_mode = 'Y') THEN
2547: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2548: 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....');
2549: END IF;
2550: END IF;
2551:
2552: END upd_single_bid_item_prices_qt;

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

3699: AND NVL(END_DATE,SYSDATE+1) > SYSDATE;
3700: EXCEPTION
3701: WHEN TOO_MANY_ROWS THEN
3702: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
3703: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
3704: FND_LOG.string(log_level => FND_LOG.level_unexpected,
3705: module => 'pon.plsql.pon_award_pkg.copy_award_scenario',
3706: message => 'Multiple Users found for person_party_id:'||p_user_id);
3707: END IF;

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

3700: EXCEPTION
3701: WHEN TOO_MANY_ROWS THEN
3702: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
3703: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
3704: FND_LOG.string(log_level => FND_LOG.level_unexpected,
3705: module => 'pon.plsql.pon_award_pkg.copy_award_scenario',
3706: message => 'Multiple Users found for person_party_id:'||p_user_id);
3707: END IF;
3708: END IF;

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

3990: UPDATE pon_Auction_headers_all
3991: SET last_update_date = SYSDATE
3992: WHERE auction_header_id = p_auction_header_id;
3993: --
3994: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3995: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.BATCH_AWARD_SPREADSHEET.AUCTION_ID:'
3996: || p_auction_header_id,'SUCCEEDED.');
3997: END IF;
3998: --

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

3991: SET last_update_date = SYSDATE
3992: WHERE auction_header_id = p_auction_header_id;
3993: --
3994: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3995: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.BATCH_AWARD_SPREADSHEET.AUCTION_ID:'
3996: || p_auction_header_id,'SUCCEEDED.');
3997: END IF;
3998: --
3999: ELSE

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

3998: --
3999: ELSE
4000: x_status := 'FAILURE';
4001: --
4002: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4003: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.BATCH_AWARD_SPREADSHEET.AUCTION_ID:'
4004: || p_auction_header_id,'FAILED.');
4005: END IF;
4006: --

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

3999: ELSE
4000: x_status := 'FAILURE';
4001: --
4002: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4003: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.BATCH_AWARD_SPREADSHEET.AUCTION_ID:'
4004: || p_auction_header_id,'FAILED.');
4005: END IF;
4006: --
4007: END IF;

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

4194: UPDATE pon_Auction_headers_all
4195: SET last_update_date = SYSDATE
4196: WHERE auction_header_id = p_auction_header_id;
4197: --
4198: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4199: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.SAVE_AWARD_SPREADSHEET.AUCTION_ID:'
4200: || p_auction_header_id,'SUCCEEDED.');
4201: END IF;
4202: --

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

4195: SET last_update_date = SYSDATE
4196: WHERE auction_header_id = p_auction_header_id;
4197: --
4198: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4199: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.SAVE_AWARD_SPREADSHEET.AUCTION_ID:'
4200: || p_auction_header_id,'SUCCEEDED.');
4201: END IF;
4202: --
4203: ELSE

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

4202: --
4203: ELSE
4204: x_status := 'FAILURE';
4205: --
4206: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4207: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.SAVE_AWARD_SPREADSHEET.AUCTION_ID:'
4208: || p_auction_header_id,'FAILED.');
4209: END IF;
4210: --

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

4203: ELSE
4204: x_status := 'FAILURE';
4205: --
4206: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4207: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'PON_AWARD_PKG.SAVE_AWARD_SPREADSHEET.AUCTION_ID:'
4208: || p_auction_header_id,'FAILED.');
4209: END IF;
4210: --
4211: END IF;

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

4531: EXCEPTION
4532:
4533: WHEN OTHERS THEN
4534:
4535: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4536: fnd_log.string(log_level => fnd_log.level_unexpected
4537: ,module => 'pon_award_pkg.get_award_totals'
4538: ,message => 'exception occurred while calculating totals ' || SUBSTR(SQLERRM, 1, 200));
4539: END IF;

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

4532:
4533: WHEN OTHERS THEN
4534:
4535: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4536: fnd_log.string(log_level => fnd_log.level_unexpected
4537: ,module => 'pon_award_pkg.get_award_totals'
4538: ,message => 'exception occurred while calculating totals ' || SUBSTR(SQLERRM, 1, 200));
4539: END IF;
4540:

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

4626:
4627: l_new_scenario_id := -9999;
4628:
4629: IF (g_debug_mode = 'Y') THEN
4630: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4631: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );
4632: 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);
4633: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );
4634: END IF;

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

4627: l_new_scenario_id := -9999;
4628:
4629: IF (g_debug_mode = 'Y') THEN
4630: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4631: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );
4632: 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);
4633: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );
4634: END IF;
4635: END IF;

Line 4632: 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);

4628:
4629: IF (g_debug_mode = 'Y') THEN
4630: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4631: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );
4632: 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);
4633: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );
4634: END IF;
4635: END IF;
4636:

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

4629: IF (g_debug_mode = 'Y') THEN
4630: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4631: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );
4632: 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);
4633: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );
4634: END IF;
4635: END IF;
4636:
4637: copy_award_scenario(p_scenario_id => p_scenario_id,

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

4641: x_status => l_status);
4642:
4643:
4644: IF (g_debug_mode = 'Y') THEN
4645: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4646: 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);
4647: END IF;
4648: END IF;
4649:

Line 4646: 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);

4642:
4643:
4644: IF (g_debug_mode = 'Y') THEN
4645: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4646: 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);
4647: END IF;
4648: END IF;
4649:
4650: IF (l_status <> 'FAILURE') THEN

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

4657:
4658: IF (p_internal_type = 'LINE_SPLIT_AWARD') THEN
4659:
4660: IF (g_debug_mode = 'Y') THEN
4661: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4662: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SPLIT_AWARD internal type constraint');
4663: END IF;
4664: END IF;
4665:

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

4658: IF (p_internal_type = 'LINE_SPLIT_AWARD') THEN
4659:
4660: IF (g_debug_mode = 'Y') THEN
4661: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4662: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SPLIT_AWARD internal type constraint');
4663: END IF;
4664: END IF;
4665:
4666: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

4674:
4675: ELSIF (p_internal_type = 'LINE_INTEGER_QUANTITY') THEN
4676:
4677: IF (g_debug_mode = 'Y') THEN
4678: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4679: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_INTEGER_QUANTITY internal type constraint');
4680: END IF;
4681: END IF;
4682:

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

4675: ELSIF (p_internal_type = 'LINE_INTEGER_QUANTITY') THEN
4676:
4677: IF (g_debug_mode = 'Y') THEN
4678: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4679: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_INTEGER_QUANTITY internal type constraint');
4680: END IF;
4681: END IF;
4682:
4683: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

4708: AND pos.scenario_id = l_new_scenario_id;
4709: EXCEPTION
4710: WHEN OTHERS THEN
4711: IF (g_debug_mode = 'Y') THEN
4712: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4713: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED, l_module, 'Selecting auction info in LINE_AWARD_QTY internal type constraint if condition caused error');
4714: END IF;
4715: END IF;
4716:

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

4709: EXCEPTION
4710: WHEN OTHERS THEN
4711: IF (g_debug_mode = 'Y') THEN
4712: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4713: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED, l_module, 'Selecting auction info in LINE_AWARD_QTY internal type constraint if condition caused error');
4714: END IF;
4715: END IF;
4716:
4717: END;

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

4723: -- In the above sql for selecting the auction qty as we use nvl to set auction qty to 1,
4724: -- all the above conditions should be satisfied
4725:
4726: IF (g_debug_mode = 'Y') THEN
4727: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4728: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_QTY internal type constraint');
4729: END IF;
4730: END IF;
4731:

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

4724: -- all the above conditions should be satisfied
4725:
4726: IF (g_debug_mode = 'Y') THEN
4727: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4728: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_QTY internal type constraint');
4729: END IF;
4730: END IF;
4731:
4732: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

4741:
4742: ELSIF (p_internal_type = 'LINE_AWARD_AMOUNT') THEN
4743:
4744: IF (g_debug_mode = 'Y') THEN
4745: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4746: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_AMOUNT internal type constraint');
4747: END IF;
4748: END IF;
4749:

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

4742: ELSIF (p_internal_type = 'LINE_AWARD_AMOUNT') THEN
4743:
4744: IF (g_debug_mode = 'Y') THEN
4745: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4746: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_AMOUNT internal type constraint');
4747: END IF;
4748: END IF;
4749:
4750: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

4760:
4761: ELSIF (p_internal_type = 'LINE_MIN_QTY') THEN
4762:
4763: IF (g_debug_mode = 'Y') THEN
4764: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4765: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_QTY internal type constraint');
4766: END IF;
4767: END IF;
4768:

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

4761: ELSIF (p_internal_type = 'LINE_MIN_QTY') THEN
4762:
4763: IF (g_debug_mode = 'Y') THEN
4764: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4765: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_QTY internal type constraint');
4766: END IF;
4767: END IF;
4768:
4769: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

4779:
4780: ELSIF (p_internal_type = 'LINE_MAX_PRICE') THEN
4781:
4782: IF (g_debug_mode = 'Y') THEN
4783: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4784: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MAX_PRICE internal type constraint');
4785: END IF;
4786: END IF;
4787:

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

4780: ELSIF (p_internal_type = 'LINE_MAX_PRICE') THEN
4781:
4782: IF (g_debug_mode = 'Y') THEN
4783: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4784: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MAX_PRICE internal type constraint');
4785: END IF;
4786: END IF;
4787:
4788: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

4798:
4799: ELSIF (p_internal_type = 'LINE_MIN_SCORE') THEN
4800:
4801: IF (g_debug_mode = 'Y') THEN
4802: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4803: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_SCORE internal type constraint');
4804: END IF;
4805: END IF;
4806: -- XYZ - SIMILAR CONDITION NEEDED FOR

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

4799: ELSIF (p_internal_type = 'LINE_MIN_SCORE') THEN
4800:
4801: IF (g_debug_mode = 'Y') THEN
4802: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4803: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_SCORE internal type constraint');
4804: END IF;
4805: END IF;
4806: -- XYZ - SIMILAR CONDITION NEEDED FOR
4807: -- AwardOptConstraint.SINGLE_HEADER_ATTR_CUTOFF

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

4818:
4819: ELSIF (p_internal_type = 'LINE_PROMISED_DATE') THEN
4820:
4821: IF (g_debug_mode = 'Y') THEN
4822: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4823: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_PROMISED_DATE internal type constraint');
4824: END IF;
4825: END IF;
4826:

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

4819: ELSIF (p_internal_type = 'LINE_PROMISED_DATE') THEN
4820:
4821: IF (g_debug_mode = 'Y') THEN
4822: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4823: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_PROMISED_DATE internal type constraint');
4824: END IF;
4825: END IF;
4826:
4827: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

4846:
4847: IF (p_internal_type = 'LINE_NUM_SUPP') THEN
4848:
4849: IF (g_debug_mode = 'Y') THEN
4850: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4851: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_NUM_SUPP internal type constraint');
4852: END IF;
4853: END IF;
4854:

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

4847: IF (p_internal_type = 'LINE_NUM_SUPP') THEN
4848:
4849: IF (g_debug_mode = 'Y') THEN
4850: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4851: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_NUM_SUPP internal type constraint');
4852: END IF;
4853: END IF;
4854:
4855: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

4865:
4866: ELSIF (p_internal_type = 'LINE_ANY_ONE_SUPP') THEN
4867:
4868: IF (g_debug_mode = 'Y') THEN
4869: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4870: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_ANY_ONE_SUPP internal type constraint');
4871: END IF;
4872: END IF;
4873:

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

4866: ELSIF (p_internal_type = 'LINE_ANY_ONE_SUPP') THEN
4867:
4868: IF (g_debug_mode = 'Y') THEN
4869: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4870: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_ANY_ONE_SUPP internal type constraint');
4871: END IF;
4872: END IF;
4873:
4874: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

4895:
4896: ELSIF (p_constraint_type = 'SUPP_BIZ_CONST') THEN --{
4897:
4898: IF (g_debug_mode = 'Y') THEN
4899: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4900: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating SUPP_BIZ_CONST constraint type');
4901: END IF;
4902: END IF;
4903:

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

4896: ELSIF (p_constraint_type = 'SUPP_BIZ_CONST') THEN --{
4897:
4898: IF (g_debug_mode = 'Y') THEN
4899: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4900: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating SUPP_BIZ_CONST constraint type');
4901: END IF;
4902: END IF;
4903:
4904: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

4916: ELSIF (p_constraint_type = 'BID_LINE_CONST') THEN --{
4917: IF (p_internal_type = 'LINE_SUPP_SITE_AMT') THEN
4918:
4919: IF (g_debug_mode = 'Y') THEN
4920: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4921: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_AMT internal type constraint');
4922: END IF;
4923: END IF;
4924:

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

4917: IF (p_internal_type = 'LINE_SUPP_SITE_AMT') THEN
4918:
4919: IF (g_debug_mode = 'Y') THEN
4920: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4921: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_AMT internal type constraint');
4922: END IF;
4923: END IF;
4924:
4925: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

4934:
4935: ELSIF (p_internal_type = 'LINE_SUPP_SITE_QTT') THEN
4936:
4937: IF (g_debug_mode = 'Y') THEN
4938: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4939: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_QTT internal type constraint');
4940: END IF;
4941: END IF;
4942:

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

4935: ELSIF (p_internal_type = 'LINE_SUPP_SITE_QTT') THEN
4936:
4937: IF (g_debug_mode = 'Y') THEN
4938: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4939: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_QTT internal type constraint');
4940: END IF;
4941: END IF;
4942:
4943: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

4953: END IF;
4954: ELSE
4955:
4956: IF (g_debug_mode = 'Y') THEN
4957: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4958: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting constraint from pon_optimize_constraints');
4959: END IF;
4960: END IF;
4961: -- INCLUDES LINE-LEVEL INDIVIDUAL SUPPLIER CONSTRAINTS AS WELL

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

4954: ELSE
4955:
4956: IF (g_debug_mode = 'Y') THEN
4957: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4958: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting constraint from pon_optimize_constraints');
4959: END IF;
4960: END IF;
4961: -- INCLUDES LINE-LEVEL INDIVIDUAL SUPPLIER CONSTRAINTS AS WELL
4962:

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

5012: BEGIN
5013:
5014: l_module := 'pon.plsql.PON_AWARD_PKG.postprocess_cost_of_constraint';
5015: IF (g_debug_mode = 'Y') THEN
5016: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5017: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );
5018: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_constraint_type : '|| p_constraint_type || ' ,p_internal_type : '|| p_internal_type);
5019: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );
5020: END IF;

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

5013:
5014: l_module := 'pon.plsql.PON_AWARD_PKG.postprocess_cost_of_constraint';
5015: IF (g_debug_mode = 'Y') THEN
5016: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5017: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );
5018: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_constraint_type : '|| p_constraint_type || ' ,p_internal_type : '|| p_internal_type);
5019: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );
5020: END IF;
5021: END IF;

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

5014: l_module := 'pon.plsql.PON_AWARD_PKG.postprocess_cost_of_constraint';
5015: IF (g_debug_mode = 'Y') THEN
5016: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5017: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );
5018: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_constraint_type : '|| p_constraint_type || ' ,p_internal_type : '|| p_internal_type);
5019: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );
5020: END IF;
5021: END IF;
5022:

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

5015: IF (g_debug_mode = 'Y') THEN
5016: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5017: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Entering procedure with p_scenario_id: ' || p_scenario_id );
5018: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_constraint_type : '|| p_constraint_type || ' ,p_internal_type : '|| p_internal_type);
5019: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module,' p_line_number : '|| p_line_number || ' ,p_sequence_number : ' || p_sequence_number );
5020: END IF;
5021: END IF;
5022:
5023: -- USE PARENT_SCENARIO_ID TO JOIN TO MAIN SCENARIO

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

5032: WHERE COST_SCENARIO.SCENARIO_ID = p_scenario_id
5033: AND PARENT_SCENARIO.SCENARIO_ID = COST_SCENARIO.PARENT_SCENARIO_ID;
5034:
5035: IF (g_debug_mode = 'Y') THEN
5036: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5037: 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 );
5038: END IF;
5039: END IF;
5040:

Line 5037: 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 );

5033: AND PARENT_SCENARIO.SCENARIO_ID = COST_SCENARIO.PARENT_SCENARIO_ID;
5034:
5035: IF (g_debug_mode = 'Y') THEN
5036: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5037: 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 );
5038: END IF;
5039: END IF;
5040:
5041: -- UPDATE THE CORRESPONDING ROW IN CONSTRAINTS TABLE

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

5045:
5046: IF (p_internal_type = 'LINE_SPLIT_AWARD') THEN
5047:
5048: IF (g_debug_mode = 'Y') THEN
5049: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5050: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SPLIT_AWARD internal type constraint');
5051: END IF;
5052: END IF;
5053:

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

5046: IF (p_internal_type = 'LINE_SPLIT_AWARD') THEN
5047:
5048: IF (g_debug_mode = 'Y') THEN
5049: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5050: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SPLIT_AWARD internal type constraint');
5051: END IF;
5052: END IF;
5053:
5054: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5059:
5060: ELSIF (p_internal_type = 'LINE_INTEGER_QUANTITY') THEN
5061:
5062: IF (g_debug_mode = 'Y') THEN
5063: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5064: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_INTEGER_QUANTITY internal type constraint');
5065: END IF;
5066: END IF;
5067:

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

5060: ELSIF (p_internal_type = 'LINE_INTEGER_QUANTITY') THEN
5061:
5062: IF (g_debug_mode = 'Y') THEN
5063: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5064: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_INTEGER_QUANTITY internal type constraint');
5065: END IF;
5066: END IF;
5067:
5068: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5074:
5075: ELSIF (p_internal_type = 'LINE_AWARD_QTY') THEN
5076:
5077: IF (g_debug_mode = 'Y') THEN
5078: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5079: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_QTY internal type constraint');
5080: END IF;
5081: END IF;
5082:

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

5075: ELSIF (p_internal_type = 'LINE_AWARD_QTY') THEN
5076:
5077: IF (g_debug_mode = 'Y') THEN
5078: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5079: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_QTY internal type constraint');
5080: END IF;
5081: END IF;
5082:
5083: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5089:
5090: ELSIF (p_internal_type = 'LINE_AWARD_AMOUNT') THEN
5091:
5092: IF (g_debug_mode = 'Y') THEN
5093: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5094: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_AMOUNT internal type constraint');
5095: END IF;
5096: END IF;
5097:

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

5090: ELSIF (p_internal_type = 'LINE_AWARD_AMOUNT') THEN
5091:
5092: IF (g_debug_mode = 'Y') THEN
5093: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5094: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_AMOUNT internal type constraint');
5095: END IF;
5096: END IF;
5097:
5098: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5104:
5105: ELSIF (p_internal_type = 'LINE_MIN_QTY') THEN
5106:
5107: IF (g_debug_mode = 'Y') THEN
5108: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5109: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_QTY internal type constraint');
5110: END IF;
5111: END IF;
5112:

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

5105: ELSIF (p_internal_type = 'LINE_MIN_QTY') THEN
5106:
5107: IF (g_debug_mode = 'Y') THEN
5108: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5109: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_QTY internal type constraint');
5110: END IF;
5111: END IF;
5112:
5113: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5120:
5121: ELSIF (p_internal_type = 'LINE_MAX_PRICE') THEN
5122:
5123: IF (g_debug_mode = 'Y') THEN
5124: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5125: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MAX_PRICE internal type constraint');
5126: END IF;
5127: END IF;
5128:

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

5121: ELSIF (p_internal_type = 'LINE_MAX_PRICE') THEN
5122:
5123: IF (g_debug_mode = 'Y') THEN
5124: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5125: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MAX_PRICE internal type constraint');
5126: END IF;
5127: END IF;
5128:
5129: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5136:
5137: ELSIF (p_internal_type = 'LINE_MIN_SCORE') THEN
5138:
5139: IF (g_debug_mode = 'Y') THEN
5140: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5141: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_SCORE internal type constraint');
5142: END IF;
5143: END IF;
5144:

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

5137: ELSIF (p_internal_type = 'LINE_MIN_SCORE') THEN
5138:
5139: IF (g_debug_mode = 'Y') THEN
5140: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5141: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_SCORE internal type constraint');
5142: END IF;
5143: END IF;
5144:
5145: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5150:
5151: ELSIF (p_internal_type = 'LINE_PROMISED_DATE') THEN
5152:
5153: IF (g_debug_mode = 'Y') THEN
5154: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5155: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_PROMISED_DATE internal type constraint');
5156: END IF;
5157: END IF;
5158:

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

5151: ELSIF (p_internal_type = 'LINE_PROMISED_DATE') THEN
5152:
5153: IF (g_debug_mode = 'Y') THEN
5154: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5155: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_PROMISED_DATE internal type constraint');
5156: END IF;
5157: END IF;
5158:
5159: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5176:
5177: IF (p_internal_type = 'LINE_NUM_SUPP') THEN
5178:
5179: IF (g_debug_mode = 'Y') THEN
5180: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5181: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_NUM_SUPP internal type constraint');
5182: END IF;
5183: END IF;
5184:

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

5177: IF (p_internal_type = 'LINE_NUM_SUPP') THEN
5178:
5179: IF (g_debug_mode = 'Y') THEN
5180: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5181: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_NUM_SUPP internal type constraint');
5182: END IF;
5183: END IF;
5184:
5185: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5191:
5192: ELSIF (p_internal_type = 'LINE_ANY_ONE_SUPP') THEN
5193:
5194: IF (g_debug_mode = 'Y') THEN
5195: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5196: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_ANY_ONE_SUPP internal type constraint');
5197: END IF;
5198: END IF;
5199:

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

5192: ELSIF (p_internal_type = 'LINE_ANY_ONE_SUPP') THEN
5193:
5194: IF (g_debug_mode = 'Y') THEN
5195: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5196: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_ANY_ONE_SUPP internal type constraint');
5197: END IF;
5198: END IF;
5199:
5200: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5209:
5210: IF (p_internal_type = 'LINE_SUPP_SITE_AMT') THEN
5211:
5212: IF (g_debug_mode = 'Y') THEN
5213: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5214: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_AMT internal type constraint');
5215: END IF;
5216: END IF;
5217:

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

5210: IF (p_internal_type = 'LINE_SUPP_SITE_AMT') THEN
5211:
5212: IF (g_debug_mode = 'Y') THEN
5213: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5214: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_AMT internal type constraint');
5215: END IF;
5216: END IF;
5217:
5218: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5223:
5224: ELSIF (p_internal_type = 'LINE_SUPP_SITE_QTT') THEN
5225:
5226: IF (g_debug_mode = 'Y') THEN
5227: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5228: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_QTT internal type constraint');
5229: END IF;
5230: END IF;
5231:

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

5224: ELSIF (p_internal_type = 'LINE_SUPP_SITE_QTT') THEN
5225:
5226: IF (g_debug_mode = 'Y') THEN
5227: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5228: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_QTT internal type constraint');
5229: END IF;
5230: END IF;
5231:
5232: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5238: END IF;
5239: ELSIF (p_constraint_type = 'SUPP_BIZ_CONST') THEN
5240:
5241: IF (g_debug_mode = 'Y') THEN
5242: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5243: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating SUPP_BIZ_CONST constraint type');
5244: END IF;
5245: END IF;
5246:

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

5239: ELSIF (p_constraint_type = 'SUPP_BIZ_CONST') THEN
5240:
5241: IF (g_debug_mode = 'Y') THEN
5242: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5243: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating SUPP_BIZ_CONST constraint type');
5244: END IF;
5245: END IF;
5246:
5247: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5257: p_constraint_type = 'SUPPLIER_CONST' ) THEN
5258:
5259:
5260: IF (g_debug_mode = 'Y') THEN
5261: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5262: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating BUDGET_AMT_CONST, INCUMBENT_SUPP_CONST, ANY_SUPP_CONST, ');
5263: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'SUPP_ASL_CONST, SUPPLIER_CONST constraint types');
5264: END IF;
5265: END IF;

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

5258:
5259:
5260: IF (g_debug_mode = 'Y') THEN
5261: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5262: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating BUDGET_AMT_CONST, INCUMBENT_SUPP_CONST, ANY_SUPP_CONST, ');
5263: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'SUPP_ASL_CONST, SUPPLIER_CONST constraint types');
5264: END IF;
5265: END IF;
5266:

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

5259:
5260: IF (g_debug_mode = 'Y') THEN
5261: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5262: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating BUDGET_AMT_CONST, INCUMBENT_SUPP_CONST, ANY_SUPP_CONST, ');
5263: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'SUPP_ASL_CONST, SUPPLIER_CONST constraint types');
5264: END IF;
5265: END IF;
5266:
5267: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5272:
5273: ELSIF (p_constraint_type = 'NUM_OF_SUPP_CONST') THEN
5274:
5275: IF (g_debug_mode = 'Y') THEN
5276: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5277: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating NUM_OF_SUPP_CONST constraint type');
5278: END IF;
5279: END IF;
5280:

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

5273: ELSIF (p_constraint_type = 'NUM_OF_SUPP_CONST') THEN
5274:
5275: IF (g_debug_mode = 'Y') THEN
5276: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5277: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating NUM_OF_SUPP_CONST constraint type');
5278: END IF;
5279: END IF;
5280:
5281: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5287: ELSIF ( p_constraint_type = 'TOTAL_HDR_ATTR_CONST' OR
5288: p_constraint_type = 'HDR_ATTR_CONST' ) THEN
5289:
5290: IF (g_debug_mode = 'Y') THEN
5291: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5292: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating TOTAL_HDR_ATTR_CONST, HDR_ATTR_CONST constraint types');
5293: END IF;
5294: END IF;
5295:

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

5288: p_constraint_type = 'HDR_ATTR_CONST' ) THEN
5289:
5290: IF (g_debug_mode = 'Y') THEN
5291: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5292: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating TOTAL_HDR_ATTR_CONST, HDR_ATTR_CONST constraint types');
5293: END IF;
5294: END IF;
5295:
5296: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5301:
5302: ELSIF (p_constraint_type = 'INCL_HOLD_SUPP_CONST') THEN
5303:
5304: IF (g_debug_mode = 'Y') THEN
5305: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5306: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating INCL_HOLD_SUPP_CONST constraint type');
5307: END IF;
5308: END IF;
5309:

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

5302: ELSIF (p_constraint_type = 'INCL_HOLD_SUPP_CONST') THEN
5303:
5304: IF (g_debug_mode = 'Y') THEN
5305: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5306: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating INCL_HOLD_SUPP_CONST constraint type');
5307: END IF;
5308: END IF;
5309:
5310: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5315:
5316: ELSIF (p_constraint_type = 'NO_SPLIT_GROUP_CONST') THEN
5317:
5318: IF (g_debug_mode = 'Y') THEN
5319: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5320: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating NO_SPLIT_GROUP_CONST constraint type');
5321: END IF;
5322: END IF;
5323:

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

5316: ELSIF (p_constraint_type = 'NO_SPLIT_GROUP_CONST') THEN
5317:
5318: IF (g_debug_mode = 'Y') THEN
5319: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5320: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating NO_SPLIT_GROUP_CONST constraint type');
5321: END IF;
5322: END IF;
5323:
5324: UPDATE PON_OPTIMIZE_CONSTRAINTS

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

5328: AND CONSTRAINT_TYPE = p_constraint_type;
5329: END IF;
5330:
5331: IF (g_debug_mode = 'Y') THEN
5332: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5333: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scneario with p_scenario_id: ' || p_scenario_id );
5334: END IF;
5335: END IF;
5336:

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

5329: END IF;
5330:
5331: IF (g_debug_mode = 'Y') THEN
5332: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5333: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scneario with p_scenario_id: ' || p_scenario_id );
5334: END IF;
5335: END IF;
5336:
5337: DELETE FROM PON_OPTIMIZE_SCENARIOS WHERE SCENARIO_ID = P_SCENARIO_ID;

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

5349: where scenario_id = p_scenario_id;
5350:
5351: IF (l_num_constraints > 0) THEN
5352: IF (g_debug_mode = 'Y') THEN
5353: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5354: 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 );
5355: END IF;
5356: END IF;
5357:

Line 5354: 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 );

5350:
5351: IF (l_num_constraints > 0) THEN
5352: IF (g_debug_mode = 'Y') THEN
5353: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5354: 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 );
5355: END IF;
5356: END IF;
5357:
5358: DELETE FROM PON_OPTIMIZE_CONSTRAINTS WHERE SCENARIO_ID = P_SCENARIO_ID;

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

5364: where scenario_id = p_scenario_id;
5365:
5366: IF (l_num_bid_classes > 0) THEN
5367: IF (g_debug_mode = 'Y') THEN
5368: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5369: 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 );
5370: END IF;
5371: END IF;
5372:

Line 5369: 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 );

5365:
5366: IF (l_num_bid_classes > 0) THEN
5367: IF (g_debug_mode = 'Y') THEN
5368: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5369: 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 );
5370: END IF;
5371: END IF;
5372:
5373: DELETE FROM PON_OPTIMIZE_BID_CLASS WHERE SCENARIO_ID = P_SCENARIO_ID;

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

5378: where scenario_id = p_scenario_id;
5379:
5380: IF(l_num_results > 0) THEN
5381: IF (g_debug_mode = 'Y') THEN
5382: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5383: 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 );
5384: END IF;
5385: END IF;
5386:

Line 5383: 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 );

5379:
5380: IF(l_num_results > 0) THEN
5381: IF (g_debug_mode = 'Y') THEN
5382: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5383: 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 );
5384: END IF;
5385: END IF;
5386:
5387: DELETE FROM PON_OPTIMIZE_RESULTS WHERE SCENARIO_ID = P_SCENARIO_ID;

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

5392:
5393: EXCEPTION
5394: WHEN OTHERS THEN
5395: X_STATUS := 'FAILURE';
5396: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5397: FND_LOG.STRING(log_level => fnd_log.LEVEL_UNEXPECTED
5398: ,module => l_module
5399: ,message => 'When others exception raised in postprocess_cost_of_constraint');
5400: END IF;

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

5393: EXCEPTION
5394: WHEN OTHERS THEN
5395: X_STATUS := 'FAILURE';
5396: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5397: FND_LOG.STRING(log_level => fnd_log.LEVEL_UNEXPECTED
5398: ,module => l_module
5399: ,message => 'When others exception raised in postprocess_cost_of_constraint');
5400: END IF;
5401:

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

5576:
5577: BEGIN
5578:
5579: IF (g_debug_mode = 'Y') THEN
5580: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5581: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Begin: ');
5582: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Param: p_auction_header_id '|| p_auction_header_id);
5583: END IF;
5584: END IF;

Line 5581: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Begin: ');

5577: BEGIN
5578:
5579: IF (g_debug_mode = 'Y') THEN
5580: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5581: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Begin: ');
5582: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Param: p_auction_header_id '|| p_auction_header_id);
5583: END IF;
5584: END IF;
5585:

Line 5582: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Param: p_auction_header_id '|| p_auction_header_id);

5578:
5579: IF (g_debug_mode = 'Y') THEN
5580: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5581: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Begin: ');
5582: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Param: p_auction_header_id '|| p_auction_header_id);
5583: END IF;
5584: END IF;
5585:
5586: l_user_id := fnd_global.user_id;

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

5617: WHERE pbr.auction_header_id = p_auction_header_id
5618: AND paip.auction_header_id = pbr.auction_header_id
5619: AND paip.line_number = pbr.line_number);
5620:
5621: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5622: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'END: ');
5623: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Insert into pon_bid_backing_requisitions Succesful');
5624: END IF;
5625:

Line 5622: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'END: ');

5618: AND paip.auction_header_id = pbr.auction_header_id
5619: AND paip.line_number = pbr.line_number);
5620:
5621: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5622: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'END: ');
5623: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Insert into pon_bid_backing_requisitions Succesful');
5624: END IF;
5625:
5626: EXCEPTION

Line 5623: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Insert into pon_bid_backing_requisitions Succesful');

5619: AND paip.line_number = pbr.line_number);
5620:
5621: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5622: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'END: ');
5623: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Insert into pon_bid_backing_requisitions Succesful');
5624: END IF;
5625:
5626: EXCEPTION
5627: WHEN OTHERS THEN

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

5625:
5626: EXCEPTION
5627: WHEN OTHERS THEN
5628: IF (g_debug_mode = 'Y') THEN
5629: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5630: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'An exception occurred during the INSERT INTO pon_bid_backing_requisitions.
5631: Raising the exception.....');
5632: END IF;
5633: END IF;

Line 5630: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'An exception occurred during the INSERT INTO pon_bid_backing_requisitions.

5626: EXCEPTION
5627: WHEN OTHERS THEN
5628: IF (g_debug_mode = 'Y') THEN
5629: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5630: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'An exception occurred during the INSERT INTO pon_bid_backing_requisitions.
5631: Raising the exception.....');
5632: END IF;
5633: END IF;
5634: RAISE;