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

Line 27: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

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

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

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

Line 127: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

123: v_doctype VARCHAR2(7);
124:
125: BEGIN
126:
127: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
128: print_log(l_api_name, p_bid_number || ' - BEGIN calculate_group_amounts');
129: print_log(l_api_name, p_bid_number || ' - p_is_supplier='||p_is_supplier);
130: print_log(l_api_name, p_bid_number || ' - p_do_all_lines='||p_do_all_lines);
131: print_log(l_api_name, p_bid_number || ' - p_batch_id='||p_batch_id);

Line 154: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

150: v_doctype = 'RFI') THEN
151: RETURN;
152: END IF;
153:
154: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
155: print_log(l_api_name, p_bid_number || ' - v_supplier_view_type=' || v_supplier_view_type);
156: print_log(l_api_name, p_bid_number || ' - v_doctype=' || v_doctype);
157: print_log(l_api_name, p_bid_number || ' - v_contract_type=' || v_contract_type);
158: END IF;

Line 184: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

180: FROM pon_auction_item_prices_all a2
181: WHERE a2.auction_header_id = p1.auction_header_id
182: AND a2.line_number = p1.line_number) = 'GROUP';
183:
184: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
185: print_log(l_api_name, p_bid_number || ' - END calculate_group_amounts');
186: END IF;
187:
188: END calculate_group_amounts;

Line 203: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

199: v_doctype VARCHAR2(7);
200:
201: BEGIN
202:
203: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
204: print_log(l_api_name, p_bid_number || ' - BEGIN calculate_group_amounts');
205: print_log(l_api_name, p_bid_number || ' - p_line_number='||p_line_number);
206: print_log(l_api_name, p_bid_number || ' - p_is_supplier='||p_is_supplier);
207: END IF;

Line 229: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

225: v_doctype = 'RFI') THEN
226: RETURN;
227: END IF;
228:
229: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
230: print_log(l_api_name, p_bid_number || ' - v_supplier_view_type=' || v_supplier_view_type);
231: print_log(l_api_name, p_bid_number || ' - v_doctype=' || v_doctype);
232: print_log(l_api_name, p_bid_number || ' - v_contract_type=' || v_contract_type);
233: END IF;

Line 257: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

253: AND group_line.auction_header_id = auc_line.auction_header_id
254: AND group_line.line_number = auc_line.line_number
255: AND auc_line.parent_line_number = groups.line_number;
256:
257: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
258: print_log(l_api_name, p_bid_number || ' - END calculate_group_amounts');
259: END IF;
260:
261: END calculate_group_amounts;

Line 272: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

268: l_api_name CONSTANT VARCHAR2(30) := 'calculate_group_amounts_auto';
269:
270: BEGIN
271:
272: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
273: print_log(l_api_name, p_bid_number || ' - BEGIN calculate_group_amount AUTONOMOUS');
274: END IF;
275:
276: calculate_group_amounts(p_bid_number, p_is_supplier);

Line 279: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

275:
276: calculate_group_amounts(p_bid_number, p_is_supplier);
277: commit;
278:
279: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
280: print_log(l_api_name, p_bid_number || ' - calculate_group_amount: committed!');
281: print_log(l_api_name, p_bid_number || ' - END calculate_group_amount AUTONOMOUS');
282: END IF;
283: END calculate_group_amounts_auto;

Line 907: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

903: p_rebid_flag IN VARCHAR)
904: IS
905: l_api_name CONSTANT VARCHAR2(30) := 'publish_unsol_lines';
906: BEGIN
907: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
908: print_log(l_api_name, p_bid_number);
909: END IF;
910:
911: IF p_rebid_flag = 'N' THEN

Line 945: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

941: AND auction_line_number = -1; --Unsolicited Lines Project : Update unsol lines.
942:
943: END IF;
944:
945: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
946: print_log(l_api_name, p_bid_number);
947: END IF;
948:
949: END publish_unsol_lines;

Line 1056: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1052: END IF;
1053: --------------------------------------------------
1054:
1055: -- (1) perform line-level validation.
1056: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1057: print_log(l_api_name, p_bid_number || ' - performing pre-publish validation for draft bid ' || p_bid_number);
1058: END IF;
1059:
1060: pon_bid_validations_pkg.validate_bid(p_auction_header_id, p_bid_number, 'PUBLISHBID', p_user_id, p_batch_id, p_request_id,

Line 1068: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1064: IF v_subroutine_return_status = g_return_error THEN
1065: x_return_status := g_return_error;
1066: x_return_code := 'VALIDATION_ERROR';
1067:
1068: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1069: print_log(l_api_name, p_bid_number || ' - validation returned with errors; exiting publish');
1070: END IF;
1071: RETURN;
1072: END IF;

Line 1082: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1078: -- is set to 0 if no line-level validations are found; set to 1 if found (see above).
1079: IF p_hdr_validation_failed = 'Y' THEN
1080: x_return_status := g_return_success;
1081:
1082: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1083: print_log(l_api_name, p_bid_number || ' - validation returned with no errors, but exiting publish because there are header-level validation errors');
1084: END IF;
1085: RETURN;
1086: END IF;

Line 1105: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1101: WHERE bid_number = p_bid_number;
1102:
1103: -- (woojin) first do the validations to make sure that this
1104: -- bid is allowed to go through.
1105: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1106: print_log(l_api_name, p_bid_number || ' - checking is bid valid ');
1107: END IF;
1108: PON_AUCTION_HEADERS_PKG.check_is_bid_valid(p_auction_header_id,
1109: p_bid_number,

Line 1125: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1121: IF v_subroutine_return_status = g_return_error THEN
1122: x_return_status := g_return_error;
1123: x_return_code := v_subroutine_return_code;
1124:
1125: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1126: print_log(l_api_name, p_bid_number || ' - check_is_bid_valid failed with error: ' || v_subroutine_return_code || '; exiting publish.');
1127: END IF;
1128: RETURN;
1129: END IF;

Line 1131: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1127: END IF;
1128: RETURN;
1129: END IF;
1130:
1131: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1132: print_log(l_api_name, p_bid_number || ' - after check is bid valid ');
1133: END IF;
1134:
1135:

Line 1142: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1138: --------------------------------------------------------------------------------
1139:
1140: v_batchSize := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
1141: v_batchingRequired := (v_maxLineNumber > v_batchSize);
1142: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1143: print_log(l_api_name, p_bid_number || ' - batching required? batch size=' || v_batchSize || '; numOfLines=' || v_maxLineNumber);
1144: END IF;
1145:
1146: --

Line 1150: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1146: --
1147: --Mark Info Lines as bidded if parent priced line is Bidded
1148: --if SLINs are bidded Parent Info CLIN should be marked as bidded
1149: IF ( PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(p_auction_header_id) = 1 ) THEN
1150: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1151: print_log(l_api_name, p_bid_number || ' - CLM Mark Info Lines and option lines ');
1152: END IF;
1153: mark_info_lines(p_bid_number);
1154:

Line 1165: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1161: END IF;
1162:
1163:
1164: -- (2) remove empty rows (lines, children)
1165: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1166: print_log(l_api_name, p_bid_number || ' - remove empty rows');
1167: END IF;
1168: -- modified by Allen Yang for surrogate bid bug 7702461 2009/01/22
1169: --------------------------------------------------------------------

Line 1189: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1185: */
1186: ---------------------------------------------------------------------
1187:
1188: -- (3) calculate group amounts
1189: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1190: print_log(l_api_name, p_bid_number || ' - calculate group amounts? ' || v_group_enabled_flag);
1191: END IF;
1192:
1193: -- (woojin) commented out this portion because group amount

Line 1225: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1221: ELSE
1222: v_publish_date := p_publish_date;
1223: END IF;
1224:
1225: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1226: print_log(l_api_name, p_bid_number || ' - set header-level attributes');
1227: END IF;
1228: IF (v_batchingRequired) THEN
1229: update_bid_header_fields_auto(p_bid_number, v_publish_date, p_publish_date, v_surrog_bid_flag, v_two_part_flag, v_sealed_auction_status);

Line 1235: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1231: update_bid_header_fields(p_bid_number, v_publish_date, p_publish_date, v_surrog_bid_flag, v_two_part_flag, v_sealed_auction_status);
1232: END IF;
1233:
1234: -- (5) set miscellaneous line-level attributes
1235: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1236: print_log(l_api_name, p_bid_number || ' - publish lines');
1237: END IF;
1238: IF (v_batchingRequired) THEN
1239: publish_lines_auto(p_auction_header_id, p_bid_number, v_publish_date,

Line 1254: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1250: END IF;
1251:
1252: -- (7) perform the things that used to be in BidHeadersEO.beforeCommit()
1253: -- check_auction_bidder
1254: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1255: print_log(l_api_name, p_bid_number || ' - check auction bidder');
1256: END IF;
1257: PON_AUCTION_PKG.CHECK_AUCTION_BIDDER(p_tpc_id, p_auction_header_id, v_subroutine_return_status);
1258: IF v_subroutine_return_status = 1 THEN

Line 1259: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1255: print_log(l_api_name, p_bid_number || ' - check auction bidder');
1256: END IF;
1257: PON_AUCTION_PKG.CHECK_AUCTION_BIDDER(p_tpc_id, p_auction_header_id, v_subroutine_return_status);
1258: IF v_subroutine_return_status = 1 THEN
1259: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1260: print_log(l_api_name, p_bid_number || ' - check auction bidder; user not added to role');
1261: END IF;
1262: v_user_added_to_role := 'N';
1263: END IF;

Line 1267: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1263: END IF;
1264:
1265:
1266: -- update_auction_info
1267: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1268: print_log(l_api_name, p_bid_number || ' - update auction info');
1269: END IF;
1270: PON_AUCTION_HEADERS_PKG.UPDATE_AUCTION_INFO(p_auction_header_id, p_bid_number, v_vendor_site_id, p_rebid_flag, v_prev_bid_number, 'N', v_surrog_bid_flag, p_user_id, v_subroutine_return_status, v_subroutine_return_code);
1271:

Line 1275: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1271:
1272: IF v_subroutine_return_status = g_return_error THEN
1273: x_return_code := v_subroutine_return_code;
1274: x_return_status := g_return_error;
1275: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1276: print_log(l_api_name, p_bid_number || ' - update auction info; error code=' || x_return_code);
1277: END IF;
1278: RETURN;
1279: ELSIF v_subroutine_return_status = g_return_warning THEN

Line 1280: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1276: print_log(l_api_name, p_bid_number || ' - update auction info; error code=' || x_return_code);
1277: END IF;
1278: RETURN;
1279: ELSIF v_subroutine_return_status = g_return_warning THEN
1280: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1281: print_log(l_api_name, p_bid_number || ' - update auction info; price changed');
1282: END IF;
1283: v_price_changed := 'Y';
1284: END IF;

Line 1302: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1298: v_wf_item_key := NULL;
1299: END;
1300:
1301: IF v_wf_item_key IS NOT NULL THEN
1302: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1303: print_log(l_api_name, p_bid_number || ' - ack notif response');
1304: END IF;
1305: PON_AUCTION_PKG.ACK_NOTIF_RESPONSE(v_wf_item_key, v_tpc_name, 'Y','', v_subroutine_return_status);
1306:

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

1305: PON_AUCTION_PKG.ACK_NOTIF_RESPONSE(v_wf_item_key, v_tpc_name, 'Y','', v_subroutine_return_status);
1306:
1307: IF v_subroutine_return_status = 1 THEN
1308: IF (g_fnd_debug = 'Y') THEN
1309: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1310: FND_LOG.string(log_level => FND_LOG.level_exception,
1311: module => g_module_prefix || l_api_name,
1312: message => 'Response acknowledge notification cannot be sent for bid ' || p_bid_number);
1313: END IF;

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

1306:
1307: IF v_subroutine_return_status = 1 THEN
1308: IF (g_fnd_debug = 'Y') THEN
1309: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1310: FND_LOG.string(log_level => FND_LOG.level_exception,
1311: module => g_module_prefix || l_api_name,
1312: message => 'Response acknowledge notification cannot be sent for bid ' || p_bid_number);
1313: END IF;
1314: END IF;

Line 1334: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1330: ELSE
1331: x_return_status := g_return_success;
1332: END IF;
1333:
1334: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1335: print_log(l_api_name, p_bid_number || ' - return status: ' || x_return_status || '; return code: ' || x_return_code);
1336: print_log(l_api_name, p_bid_number || ' - call send_resp_notif');
1337: END IF;
1338:

Line 1344: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1340: PON_AUCTION_PKG.SEND_RESP_NOTIF(p_bid_number => p_bid_number,
1341: x_return_status =>v_subroutine_return_code);
1342:
1343: -- raise response publish business event (uday's code)
1344: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1345: print_log(l_api_name, p_bid_number || ' - call raise response publish business event');
1346: END IF;
1347: PON_BIZ_EVENTS_PVT.RAISE_RESPNSE_PUB_EVENT(1.0, 'F', 'F', p_bid_number, v_biz_return_status, v_biz_msg_count, v_biz_msg_data_value);
1348:

Line 1349: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1345: print_log(l_api_name, p_bid_number || ' - call raise response publish business event');
1346: END IF;
1347: PON_BIZ_EVENTS_PVT.RAISE_RESPNSE_PUB_EVENT(1.0, 'F', 'F', p_bid_number, v_biz_return_status, v_biz_msg_count, v_biz_msg_data_value);
1348:
1349: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1350: print_log(l_api_name, 'v_biz_return_status=' || v_biz_return_status);
1351: print_log(l_api_name, 'v_biz_msg_count=' || v_biz_msg_count);
1352: print_log(l_api_name, 'v_biz_msg_data_value=' || v_biz_msg_data_value);
1353: print_log(l_api_name, p_bid_number || ' - finally PUBLISH the bid by setting bid_status to ACTIVE!!');

Line 1376: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1372: , submit_stage = l_submit_stage
1373: --------------------------------------------------
1374: WHERE bid_number = p_bid_number;
1375:
1376: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1377: print_log(l_api_name, p_bid_number || ' - exiting publish successfully');
1378: END IF;
1379:
1380:

Line 1455: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1451: l_api_name CONSTANT VARCHAR2(30) := 'remove_empty_rows';
1452:
1453: BEGIN
1454:
1455: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1456: print_log(l_api_name, p_bid_number || ' - begin remove empty rows for batch range ' || p_batch_start || ' ~ ' || p_batch_end || ' inclusive');
1457: END IF;
1458:
1459: -- 1) empty attributes (including header attributes)

Line 1537: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1533: AND has_bid_flag = 'N'
1534: AND line_number >= p_batch_start
1535: AND line_number <= p_batch_end;
1536:
1537: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1538: print_log(l_api_name, p_bid_number || ' - end remove empty rows for batch range ' || p_batch_start || ' ~ ' || p_batch_end || ' inclusive');
1539: END IF;
1540: END remove_empty_rows;
1541:

Line 1556: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1552: v_batch_end NUMBER;
1553:
1554: BEGIN
1555:
1556: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1557: print_log(l_api_name, p_bid_number || ' - BEGIN remove empty rows AUTONOMOUS');
1558: END IF;
1559:
1560: v_batch_start := 1;

Line 1572: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1568:
1569: remove_empty_rows(p_bid_number, v_batch_start, v_batch_end);
1570: commit;
1571:
1572: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1573: print_log(l_api_name, p_bid_number || ' - remove empty rows: batch committed');
1574: END IF;
1575:
1576: v_batch_start := v_batch_end + 1;

Line 1584: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1580: v_batch_end := v_batch_end + p_batch_size;
1581: END IF;
1582: END LOOP;
1583:
1584: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1585: print_log(l_api_name, p_bid_number || ' - END remove empty rows AUTONOMOUS');
1586: END IF;
1587: END remove_empty_rows_auto;
1588:

Line 1612: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1608: l_tech_shortlist_flag VARCHAR2(1) := null;
1609:
1610: BEGIN
1611:
1612: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1613: print_log(l_api_name, p_bid_number || ' - begin update bid header fields');
1614: print_log(l_api_name, p_bid_number || ' - update bid header fields: p_publish_date=' || p_publish_date);
1615: END IF;
1616:

Line 1630: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1626: technical_shortlist_flag = l_tech_shortlist_flag
1627: --,bid_status = 'ACTIVE'
1628: WHERE bid_number = p_bid_number;
1629:
1630: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1631: print_log(l_api_name, p_bid_number || ' - end update bid header fields');
1632: END IF;
1633: END update_bid_header_fields;
1634:

Line 1648: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1644: PRAGMA AUTONOMOUS_TRANSACTION;
1645:
1646: l_api_name CONSTANT VARCHAR2(30) := 'update_bid_header_fields_auto';
1647: BEGIN
1648: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1649: print_log(l_api_name, p_bid_number || ' - BEGIN update bid header fields AUTONOMOUS');
1650: END IF;
1651:
1652: update_bid_header_fields(p_bid_number, p_publish_date, p_bid_entry_date, p_surrog_bid_flag, p_two_part_flag, p_sealed_auction_status);

Line 1655: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1651:
1652: update_bid_header_fields(p_bid_number, p_publish_date, p_bid_entry_date, p_surrog_bid_flag, p_two_part_flag, p_sealed_auction_status);
1653: commit;
1654:
1655: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1656: print_log(l_api_name, p_bid_number || ' - update bid header fields: committed!');
1657: print_log(l_api_name, p_bid_number || ' - END update bid header fields AUTONOMOUS');
1658: END IF;
1659:

Line 1691: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1687: l_api_name CONSTANT VARCHAR2(30) := 'publish_lines';
1688:
1689: BEGIN
1690:
1691: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1692: print_log(l_api_name, p_bid_number || ' - begin publish lines for batch range: ' || p_batch_start || ' ~ ' || p_batch_end || ' inclusive');
1693: END IF;
1694:
1695: IF p_rebid_flag = 'N' THEN

Line 1741: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1737: AND auction_line_number <> -1; --Unsolicited Lines Project : Update unsol lines seperately.
1738:
1739: END IF;
1740:
1741: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1742: print_log(l_api_name, p_bid_number || ' - end publish lines for batch range: ' || p_batch_start || ' ~ ' || p_batch_end || ' inclusive');
1743: END IF;
1744:
1745: END;

Line 1767: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1763: l_api_name CONSTANT VARCHAR2(30) := 'publish_lines_auto';
1764:
1765: BEGIN
1766:
1767: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1768: print_log(l_api_name, p_bid_number || ' - BEGIN publish lines AUTONOMOUS');
1769: END IF;
1770:
1771: v_batch_start := 1;

Line 1784: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1780: publish_lines(p_auction_header_id, p_bid_number, p_publish_date, p_tp_id,
1781: p_auc_tp_id, p_surrog_bid_flag, p_rebid_flag, v_batch_start, v_batch_end);
1782: commit;
1783:
1784: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1785: print_log(l_api_name, p_bid_number || ' - publish lines: batch committed!');
1786: END IF;
1787:
1788: v_batch_start := v_batch_end + 1;

Line 1796: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1792: v_batch_end := v_batch_end + p_batch_size;
1793: END IF;
1794: END LOOP;
1795:
1796: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1797: print_log(l_api_name, p_bid_number || ' - END publish lines AUTONOMOUS');
1798: END IF;
1799:
1800: END publish_lines_auto;

Line 1913: -- insert an error into the FND LOG as well

1909:
1910: EXCEPTION
1911: WHEN others THEN
1912:
1913: -- insert an error into the FND LOG as well
1914: IF (g_fnd_debug = 'Y') THEN
1915: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1916: FND_LOG.string(log_level => FND_LOG.level_exception,
1917: module => g_module_prefix || l_api_name,

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

1911: WHEN others THEN
1912:
1913: -- insert an error into the FND LOG as well
1914: IF (g_fnd_debug = 'Y') THEN
1915: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1916: FND_LOG.string(log_level => FND_LOG.level_exception,
1917: module => g_module_prefix || l_api_name,
1918: message => 'SQL error code: ' || sqlcode || ', error message: ' || substr(sqlerrm,1,512));
1919: END IF;

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

1912:
1913: -- insert an error into the FND LOG as well
1914: IF (g_fnd_debug = 'Y') THEN
1915: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1916: FND_LOG.string(log_level => FND_LOG.level_exception,
1917: module => g_module_prefix || l_api_name,
1918: message => 'SQL error code: ' || sqlcode || ', error message: ' || substr(sqlerrm,1,512));
1919: END IF;
1920: END IF;

Line 1936: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1932: p_ProgramTypeCode => 'BID_PUBLISH',
1933: p_DestinationPageCode => 'PON_CONCURRENT_ERRORS',
1934: p_bid_number => p_bid_number);
1935:
1936: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1937: print_log(l_api_name, 'Generating WF notif: ' || v_request_id || ' ' || v_user_name || ' ' || p_user_type || ' '||p_auction_header_id|| ' ' );
1938: END IF;
1939:
1940: -- insert an error indicating that a fatal error in the

Line 1951: -- insert an error into the FND LOG as well

1947: VALUES
1948: (p_bid_number, p_auction_header_id, 'PUBLISHBID', v_request_id,
1949: v_error_msg_name, sysdate+7);
1950:
1951: -- insert an error into the FND LOG as well
1952: IF (g_fnd_debug = 'Y') THEN
1953: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1954: FND_LOG.string(log_level => FND_LOG.level_exception,
1955: module => g_module_prefix || l_api_name,

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

1949: v_error_msg_name, sysdate+7);
1950:
1951: -- insert an error into the FND LOG as well
1952: IF (g_fnd_debug = 'Y') THEN
1953: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1954: FND_LOG.string(log_level => FND_LOG.level_exception,
1955: module => g_module_prefix || l_api_name,
1956: message => 'A fatal error has occurred during the concurrent processing of response publish for response number ' || p_bid_number);
1957: END IF;

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

1950:
1951: -- insert an error into the FND LOG as well
1952: IF (g_fnd_debug = 'Y') THEN
1953: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1954: FND_LOG.string(log_level => FND_LOG.level_exception,
1955: module => g_module_prefix || l_api_name,
1956: message => 'A fatal error has occurred during the concurrent processing of response publish for response number ' || p_bid_number);
1957: END IF;
1958: END IF;

Line 2055: -- insert an error into the FND LOG as well

2051:
2052: EXCEPTION
2053: WHEN others THEN
2054:
2055: -- insert an error into the FND LOG as well
2056: IF (g_fnd_debug = 'Y') THEN
2057: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
2058: FND_LOG.string(log_level => FND_LOG.level_exception,
2059: module => g_module_prefix || l_api_name,

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

2053: WHEN others THEN
2054:
2055: -- insert an error into the FND LOG as well
2056: IF (g_fnd_debug = 'Y') THEN
2057: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
2058: FND_LOG.string(log_level => FND_LOG.level_exception,
2059: module => g_module_prefix || l_api_name,
2060: message => 'SQL error code: ' || sqlcode || ', error message: ' || substr(sqlerrm,1,512));
2061: END IF;

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

2054:
2055: -- insert an error into the FND LOG as well
2056: IF (g_fnd_debug = 'Y') THEN
2057: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
2058: FND_LOG.string(log_level => FND_LOG.level_exception,
2059: module => g_module_prefix || l_api_name,
2060: message => 'SQL error code: ' || sqlcode || ', error message: ' || substr(sqlerrm,1,512));
2061: END IF;
2062: END IF;

Line 2079: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

2075: p_ProgramTypeCode => 'BID_VALIDATE',
2076: p_DestinationPageCode => 'PON_CONCURRENT_ERRORS',
2077: p_bid_number => p_bid_number);
2078:
2079: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
2080: print_log(l_api_name, 'Generating WF notif: ' || v_request_id || ' ' || v_user_name || ' ' || p_user_type || ' '||p_auction_header_id|| ' ' );
2081: END IF;
2082:
2083: -- insert an error indicating that a fatal error in the

Line 2094: -- insert an error into the FND LOG as well

2090: VALUES
2091: (p_bid_number, p_auction_header_id, 'VALIDATEBID', v_request_id,
2092: v_error_msg_name, sysdate+7);
2093:
2094: -- insert an error into the FND LOG as well
2095: IF (g_fnd_debug = 'Y') THEN
2096: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
2097: FND_LOG.string(log_level => FND_LOG.level_exception,
2098: module => g_module_prefix || l_api_name,

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

2092: v_error_msg_name, sysdate+7);
2093:
2094: -- insert an error into the FND LOG as well
2095: IF (g_fnd_debug = 'Y') THEN
2096: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
2097: FND_LOG.string(log_level => FND_LOG.level_exception,
2098: module => g_module_prefix || l_api_name,
2099: message => 'A fatal error has occurred during the concurrent processing of response validation for response number ' || p_bid_number || '. See above for error details');
2100: END IF;

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

2093:
2094: -- insert an error into the FND LOG as well
2095: IF (g_fnd_debug = 'Y') THEN
2096: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
2097: FND_LOG.string(log_level => FND_LOG.level_exception,
2098: module => g_module_prefix || l_api_name,
2099: message => 'A fatal error has occurred during the concurrent processing of response validation for response number ' || p_bid_number || '. See above for error details');
2100: END IF;
2101: END IF;

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

2167: l_api_name CONSTANT VARCHAR2(30) := 'get_user_lang_message';
2168: l_user_id FND_USER.USER_ID%TYPE;
2169: BEGIN
2170:
2171: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2172: FND_LOG.string(log_level => FND_LOG.level_procedure,
2173: module => g_module_prefix || l_api_name,
2174: message => 'Entered with p_tpc_id = ' || p_tpc_id ||
2175: ', p_message_name = ' || p_message_name ||

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

2168: l_user_id FND_USER.USER_ID%TYPE;
2169: BEGIN
2170:
2171: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2172: FND_LOG.string(log_level => FND_LOG.level_procedure,
2173: module => g_module_prefix || l_api_name,
2174: message => 'Entered with p_tpc_id = ' || p_tpc_id ||
2175: ', p_message_name = ' || p_message_name ||
2176: ', p_message_token1_name = ' || p_message_token1_name ||

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

2188: WHERE
2189: FND_USER.PERSON_PARTY_ID = p_tpc_id
2190: AND ROWNUM=1;
2191:
2192: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2193: FND_LOG.string(log_level => FND_LOG.level_statement,
2194: module => g_module_prefix || l_api_name,
2195: message => 'l_user_id = ' || l_user_id);
2196: END IF;

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

2189: FND_USER.PERSON_PARTY_ID = p_tpc_id
2190: AND ROWNUM=1;
2191:
2192: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2193: FND_LOG.string(log_level => FND_LOG.level_statement,
2194: module => g_module_prefix || l_api_name,
2195: message => 'l_user_id = ' || l_user_id);
2196: END IF;
2197:

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

2196: END IF;
2197:
2198: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE (l_user_id, l_language_code);
2199:
2200: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2201: FND_LOG.string(log_level => FND_LOG.level_statement,
2202: module => g_module_prefix || l_api_name,
2203: message => 'l_language_code = ' || l_language_code);
2204: END IF;

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

2197:
2198: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE (l_user_id, l_language_code);
2199:
2200: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2201: FND_LOG.string(log_level => FND_LOG.level_statement,
2202: module => g_module_prefix || l_api_name,
2203: message => 'l_language_code = ' || l_language_code);
2204: END IF;
2205:

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

2211: token1_value => p_message_token1_value,
2212: token2 => p_message_token2_name,
2213: token2_value => p_message_token2_value);
2214:
2215: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2216: FND_LOG.string(log_level => FND_LOG.level_statement,
2217: module => g_module_prefix || l_api_name,
2218: message => 'x_message_text = ' || x_message_text);
2219: END IF;

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

2212: token2 => p_message_token2_name,
2213: token2_value => p_message_token2_value);
2214:
2215: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2216: FND_LOG.string(log_level => FND_LOG.level_statement,
2217: module => g_module_prefix || l_api_name,
2218: message => 'x_message_text = ' || x_message_text);
2219: END IF;
2220: