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_NEG_UPDATE_PKG dependencies on FND_LOG

Line 345: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

341: where auction_header_id = p_auction_header_id_prev_doc;
342:
343: if v_is_paused <> 'Y' then
344:
345: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
346: FND_LOG.string (log_level => FND_LOG.level_procedure,
347: module => g_module_prefix || l_module_name,
348: message => 'The auction is not paused.');
349: END IF;

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

342:
343: if v_is_paused <> 'Y' then
344:
345: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
346: FND_LOG.string (log_level => FND_LOG.level_procedure,
347: module => g_module_prefix || l_module_name,
348: message => 'The auction is not paused.');
349: END IF;
350:

Line 1066: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1062: BEGIN
1063:
1064: l_module_name := 'PROPAGATE_BACK_UNLOCK';
1065:
1066: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1067: FND_LOG.string (log_level => FND_LOG.level_procedure,
1068: module => g_module_prefix || l_module_name,
1069: message => 'Entered procedure = ' || l_module_name || '.' ||
1070: ' Parameters: p_currAuctionHeaderId = ' || p_currAuctionHeaderId || ', ' ||

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

1063:
1064: l_module_name := 'PROPAGATE_BACK_UNLOCK';
1065:
1066: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1067: FND_LOG.string (log_level => FND_LOG.level_procedure,
1068: module => g_module_prefix || l_module_name,
1069: message => 'Entered procedure = ' || l_module_name || '.' ||
1070: ' Parameters: p_currAuctionHeaderId = ' || p_currAuctionHeaderId || ', ' ||
1071: ' p_userId = ' || p_userId || ', ' || ' p_unlock_date = ' || p_unlock_date || ', ' ||

Line 1096: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1092: where auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and
1093: amendment_number < v_currAmendmentNumber;
1094: END IF;
1095:
1096: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1097: FND_LOG.string (log_level => FND_LOG.level_procedure,
1098: module => g_module_prefix || l_module_name,
1099: message => 'Leaving procedure = ' || l_module_name);
1100: END IF;

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

1093: amendment_number < v_currAmendmentNumber;
1094: END IF;
1095:
1096: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1097: FND_LOG.string (log_level => FND_LOG.level_procedure,
1098: module => g_module_prefix || l_module_name,
1099: message => 'Leaving procedure = ' || l_module_name);
1100: END IF;
1101:

Line 1118: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1114: BEGIN
1115:
1116: l_module_name := 'PROPAGATE_BACK_UNSEAL';
1117:
1118: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1119: FND_LOG.string (log_level => FND_LOG.level_procedure,
1120: module => g_module_prefix || l_module_name,
1121: message => 'Entered procedure = ' || l_module_name || '.' ||
1122: ' Parameters: p_currAuctionHeaderId = ' || p_currAuctionHeaderId || ', ' ||

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

1115:
1116: l_module_name := 'PROPAGATE_BACK_UNSEAL';
1117:
1118: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1119: FND_LOG.string (log_level => FND_LOG.level_procedure,
1120: module => g_module_prefix || l_module_name,
1121: message => 'Entered procedure = ' || l_module_name || '.' ||
1122: ' Parameters: p_currAuctionHeaderId = ' || p_currAuctionHeaderId || ', ' ||
1123: ' p_userId = ' || p_userId || ', ' || ' p_unseal_date = ' || p_unseal_date || ', ' ||

Line 1168: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1164: where auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and
1165: amendment_number < v_currAmendmentNumber;
1166: END IF;
1167:
1168: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1169: FND_LOG.string (log_level => FND_LOG.level_procedure,
1170: module => g_module_prefix || l_module_name,
1171: message => 'Leaving procedure = ' || l_module_name);
1172: END IF;

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

1165: amendment_number < v_currAmendmentNumber;
1166: END IF;
1167:
1168: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1169: FND_LOG.string (log_level => FND_LOG.level_procedure,
1170: module => g_module_prefix || l_module_name,
1171: message => 'Leaving procedure = ' || l_module_name);
1172: END IF;
1173:

Line 1288: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1284:
1285: l_module_name := 'MANUAL_CLOSE_LINE';
1286: x_result := FND_API.g_ret_sts_success;
1287:
1288: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1289: FND_LOG.string (log_level => FND_LOG.level_procedure,
1290: module => g_module_prefix || l_module_name,
1291: message => 'Entered procedure = ' || l_module_name || '.' ||
1292: ' Parameters: p_auction_header_id = ' || p_auction_header_id || ', ' ||

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

1285: l_module_name := 'MANUAL_CLOSE_LINE';
1286: x_result := FND_API.g_ret_sts_success;
1287:
1288: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1289: FND_LOG.string (log_level => FND_LOG.level_procedure,
1290: module => g_module_prefix || l_module_name,
1291: message => 'Entered procedure = ' || l_module_name || '.' ||
1292: ' Parameters: p_auction_header_id = ' || p_auction_header_id || ', ' ||
1293: ' p_user_id = ' || p_user_id);

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

1299: FROM PON_AUCTION_HEADERS_ALL
1300: WHERE AUCTION_HEADER_ID = p_auction_header_id
1301: FOR UPDATE;
1302:
1303: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1304: FND_LOG.string (log_level => FND_LOG.level_statement,
1305: module => g_module_prefix || l_module_name,
1306: message => 'Locked the negotiation header');
1307: END IF;

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

1300: WHERE AUCTION_HEADER_ID = p_auction_header_id
1301: FOR UPDATE;
1302:
1303: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1304: FND_LOG.string (log_level => FND_LOG.level_statement,
1305: module => g_module_prefix || l_module_name,
1306: message => 'Locked the negotiation header');
1307: END IF;
1308:

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

1322: where auction_header_id = p_auction_header_id
1323: and (line_number = p_line_number
1324: or parent_line_number = p_line_number);
1325:
1326: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1327: FND_LOG.string (log_level => FND_LOG.level_statement,
1328: module => g_module_prefix || l_module_name,
1329: message => 'Update header and the line.');
1330: END IF;

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

1323: and (line_number = p_line_number
1324: or parent_line_number = p_line_number);
1325:
1326: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1327: FND_LOG.string (log_level => FND_LOG.level_statement,
1328: module => g_module_prefix || l_module_name,
1329: message => 'Update header and the line.');
1330: END IF;
1331:

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

1338: from pon_auction_item_prices_all
1339: where auction_header_id=p_auction_header_id
1340: and group_type in ('LINE', 'LOT', 'GROUP'));
1341:
1342: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1343: FND_LOG.string (log_level => FND_LOG.level_statement,
1344: module => g_module_prefix || l_module_name,
1345: message => 'The last line in the auction is = ' || v_auction_last_line_number);
1346: END IF;

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

1339: where auction_header_id=p_auction_header_id
1340: and group_type in ('LINE', 'LOT', 'GROUP'));
1341:
1342: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1343: FND_LOG.string (log_level => FND_LOG.level_statement,
1344: module => g_module_prefix || l_module_name,
1345: message => 'The last line in the auction is = ' || v_auction_last_line_number);
1346: END IF;
1347:

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

1346: END IF;
1347:
1348: if (p_line_number = v_auction_last_line_number) then
1349:
1350: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1351: FND_LOG.string (log_level => FND_LOG.level_statement,
1352: module => g_module_prefix || l_module_name,
1353: message => 'The last line number in the auction matches with p_line_number, closing the negotiation');
1354: END IF;

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

1347:
1348: if (p_line_number = v_auction_last_line_number) then
1349:
1350: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1351: FND_LOG.string (log_level => FND_LOG.level_statement,
1352: module => g_module_prefix || l_module_name,
1353: message => 'The last line number in the auction matches with p_line_number, closing the negotiation');
1354: END IF;
1355:

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

1356: update pon_auction_headers_all set close_bidding_date = p_new_close_date
1357: where auction_header_id = p_auction_header_id;
1358: x_is_auction_closed := 'Y';
1359:
1360: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1361: FND_LOG.string (log_level => FND_LOG.level_statement,
1362: module => g_module_prefix || l_module_name,
1363: message => 'Updated header sending notification.');
1364: END IF;

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

1357: where auction_header_id = p_auction_header_id;
1358: x_is_auction_closed := 'Y';
1359:
1360: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1361: FND_LOG.string (log_level => FND_LOG.level_statement,
1362: module => g_module_prefix || l_module_name,
1363: message => 'Updated header sending notification.');
1364: END IF;
1365:

Line 1371: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1367: p_new_close_date,
1368: null);
1369: end if;
1370:
1371: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1372: FND_LOG.string (log_level => FND_LOG.level_procedure,
1373: module => g_module_prefix || l_module_name,
1374: message => 'Leaving procedure = ' || l_module_name);
1375: END IF;

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

1368: null);
1369: end if;
1370:
1371: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1372: FND_LOG.string (log_level => FND_LOG.level_procedure,
1373: module => g_module_prefix || l_module_name,
1374: message => 'Leaving procedure = ' || l_module_name);
1375: END IF;
1376:

Line 1383: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

1379: x_result := FND_API.g_ret_sts_unexp_error;
1380: x_error_code := SQLCODE;
1381: x_error_message := SUBSTR(SQLERRM, 1, 100);
1382:
1383: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1384: FND_LOG.string (log_level => FND_LOG.level_exception,
1385: module => g_module_prefix || l_module_name,
1386: message => 'Unexpected exception occured error_code = ' ||
1387: x_error_code || ', error_message = ' || x_error_message);

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

1380: x_error_code := SQLCODE;
1381: x_error_message := SUBSTR(SQLERRM, 1, 100);
1382:
1383: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1384: FND_LOG.string (log_level => FND_LOG.level_exception,
1385: module => g_module_prefix || l_module_name,
1386: message => 'Unexpected exception occured error_code = ' ||
1387: x_error_code || ', error_message = ' || x_error_message);
1388: END IF;

Line 1403: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1399: BEGIN
1400:
1401: l_module_name := 'PROPAGATE_BACK_TECH_EVAL';
1402:
1403: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1404: FND_LOG.string (log_level => FND_LOG.level_procedure,
1405: module => g_module_prefix || l_module_name,
1406: message => 'Entered procedure = ' || l_module_name || '.' ||
1407: ' Parameters: p_currAuctionHeaderId = ' || p_currAuctionHeaderId || ', ' ||

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

1400:
1401: l_module_name := 'PROPAGATE_BACK_TECH_EVAL';
1402:
1403: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1404: FND_LOG.string (log_level => FND_LOG.level_procedure,
1405: module => g_module_prefix || l_module_name,
1406: message => 'Entered procedure = ' || l_module_name || '.' ||
1407: ' Parameters: p_currAuctionHeaderId = ' || p_currAuctionHeaderId || ', ' ||
1408: ' p_tech_eval_status = ' || p_tech_eval_status);

Line 1421: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1417: set technical_evaluation_status = p_tech_eval_status
1418: where auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and
1419: amendment_number < v_currAmendmentNumber;
1420:
1421: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1422: FND_LOG.string (log_level => FND_LOG.level_procedure,
1423: module => g_module_prefix || l_module_name,
1424: message => 'Leaving procedure = ' || l_module_name);
1425: END IF;

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

1418: where auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and
1419: amendment_number < v_currAmendmentNumber;
1420:
1421: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1422: FND_LOG.string (log_level => FND_LOG.level_procedure,
1423: module => g_module_prefix || l_module_name,
1424: message => 'Leaving procedure = ' || l_module_name);
1425: END IF;
1426:

Line 1511: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1507: AND AUCTION_HEADER_ID = p_auction_header_id;
1508:
1509: EXCEPTION
1510: WHEN OTHERS THEN
1511: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1512: FND_LOG.string (log_level => FND_LOG.level_procedure,
1513: module => g_module_prefix || l_module_name,
1514: message => 'Exception when updating new docuemnt_number in po_requistion_lines_all for auction_header_id : ' || p_auction_header_id);
1515: END IF;

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

1508:
1509: EXCEPTION
1510: WHEN OTHERS THEN
1511: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1512: FND_LOG.string (log_level => FND_LOG.level_procedure,
1513: module => g_module_prefix || l_module_name,
1514: message => 'Exception when updating new docuemnt_number in po_requistion_lines_all for auction_header_id : ' || p_auction_header_id);
1515: END IF;
1516:

Line 1517: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1513: module => g_module_prefix || l_module_name,
1514: message => 'Exception when updating new docuemnt_number in po_requistion_lines_all for auction_header_id : ' || p_auction_header_id);
1515: END IF;
1516:
1517: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1518: FND_LOG.string (log_level => FND_LOG.level_procedure,
1519: module => g_module_prefix || l_module_name,
1520: message => 'Updated po_requistion_lines_all with new docuemnt_number for auction_header_id : ' || p_auction_header_id);
1521: END IF;

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

1514: message => 'Exception when updating new docuemnt_number in po_requistion_lines_all for auction_header_id : ' || p_auction_header_id);
1515: END IF;
1516:
1517: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1518: FND_LOG.string (log_level => FND_LOG.level_procedure,
1519: module => g_module_prefix || l_module_name,
1520: message => 'Updated po_requistion_lines_all with new docuemnt_number for auction_header_id : ' || p_auction_header_id);
1521: END IF;
1522: