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 955: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

951: END IF;
952: --------------------------------------------------
953:
954: -- (1) perform line-level validation.
955: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
956: print_log(l_api_name, p_bid_number || ' - performing pre-publish validation for draft bid ' || p_bid_number);
957: END IF;
958:
959: pon_bid_validations_pkg.validate_bid(p_auction_header_id, p_bid_number, 'PUBLISHBID', p_user_id, p_batch_id, p_request_id,

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

963: IF v_subroutine_return_status = g_return_error THEN
964: x_return_status := g_return_error;
965: x_return_code := 'VALIDATION_ERROR';
966:
967: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
968: print_log(l_api_name, p_bid_number || ' - validation returned with errors; exiting publish');
969: END IF;
970: RETURN;
971: END IF;

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

977: -- is set to 0 if no line-level validations are found; set to 1 if found (see above).
978: IF p_hdr_validation_failed = 'Y' THEN
979: x_return_status := g_return_success;
980:
981: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
982: print_log(l_api_name, p_bid_number || ' - validation returned with no errors, but exiting publish because there are header-level validation errors');
983: END IF;
984: RETURN;
985: END IF;

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

1000: WHERE bid_number = p_bid_number;
1001:
1002: -- (woojin) first do the validations to make sure that this
1003: -- bid is allowed to go through.
1004: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1005: print_log(l_api_name, p_bid_number || ' - checking is bid valid ');
1006: END IF;
1007: PON_AUCTION_HEADERS_PKG.check_is_bid_valid(p_auction_header_id,
1008: p_bid_number,

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

1020: IF v_subroutine_return_status = g_return_error THEN
1021: x_return_status := g_return_error;
1022: x_return_code := v_subroutine_return_code;
1023:
1024: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1025: print_log(l_api_name, p_bid_number || ' - check_is_bid_valid failed with error: ' || v_subroutine_return_code || '; exiting publish.');
1026: END IF;
1027: RETURN;
1028: END IF;

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

1026: END IF;
1027: RETURN;
1028: END IF;
1029:
1030: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1031: print_log(l_api_name, p_bid_number || ' - after check is bid valid ');
1032: END IF;
1033:
1034:

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

1037: --------------------------------------------------------------------------------
1038:
1039: v_batchSize := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
1040: v_batchingRequired := (v_maxLineNumber > v_batchSize);
1041: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1042: print_log(l_api_name, p_bid_number || ' - batching required? batch size=' || v_batchSize || '; numOfLines=' || v_maxLineNumber);
1043: END IF;
1044:
1045: -- (2) remove empty rows (lines, children)

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

1042: print_log(l_api_name, p_bid_number || ' - batching required? batch size=' || v_batchSize || '; numOfLines=' || v_maxLineNumber);
1043: END IF;
1044:
1045: -- (2) remove empty rows (lines, children)
1046: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1047: print_log(l_api_name, p_bid_number || ' - remove empty rows');
1048: END IF;
1049: -- modified by Allen Yang for surrogate bid bug 7702461 2009/01/22
1050: --------------------------------------------------------------------

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

1066: */
1067: ---------------------------------------------------------------------
1068:
1069: -- (3) calculate group amounts
1070: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1071: print_log(l_api_name, p_bid_number || ' - calculate group amounts? ' || v_group_enabled_flag);
1072: END IF;
1073:
1074: -- (woojin) commented out this portion because group amount

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

1102: ELSE
1103: v_publish_date := p_publish_date;
1104: END IF;
1105:
1106: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1107: print_log(l_api_name, p_bid_number || ' - set header-level attributes');
1108: END IF;
1109: IF (v_batchingRequired) THEN
1110: 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 1116: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1112: 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);
1113: END IF;
1114:
1115: -- (5) set miscellaneous line-level attributes
1116: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1117: print_log(l_api_name, p_bid_number || ' - publish lines');
1118: END IF;
1119: IF (v_batchingRequired) THEN
1120: publish_lines_auto(p_auction_header_id, p_bid_number, v_publish_date,

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

1125: END IF;
1126:
1127: -- (7) perform the things that used to be in BidHeadersEO.beforeCommit()
1128: -- check_auction_bidder
1129: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1130: print_log(l_api_name, p_bid_number || ' - check auction bidder');
1131: END IF;
1132: PON_AUCTION_PKG.CHECK_AUCTION_BIDDER(p_tpc_id, p_auction_header_id, v_subroutine_return_status);
1133: IF v_subroutine_return_status = 1 THEN

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

1130: print_log(l_api_name, p_bid_number || ' - check auction bidder');
1131: END IF;
1132: PON_AUCTION_PKG.CHECK_AUCTION_BIDDER(p_tpc_id, p_auction_header_id, v_subroutine_return_status);
1133: IF v_subroutine_return_status = 1 THEN
1134: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1135: print_log(l_api_name, p_bid_number || ' - check auction bidder; user not added to role');
1136: END IF;
1137: v_user_added_to_role := 'N';
1138: END IF;

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

1138: END IF;
1139:
1140:
1141: -- update_auction_info
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 || ' - update auction info');
1144: END IF;
1145: 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);
1146:

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

1146:
1147: IF v_subroutine_return_status = g_return_error THEN
1148: x_return_code := v_subroutine_return_code;
1149: x_return_status := g_return_error;
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 || ' - update auction info; error code=' || x_return_code);
1152: END IF;
1153: RETURN;
1154: ELSIF v_subroutine_return_status = g_return_warning THEN

Line 1155: 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 || ' - update auction info; error code=' || x_return_code);
1152: END IF;
1153: RETURN;
1154: ELSIF v_subroutine_return_status = g_return_warning THEN
1155: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1156: print_log(l_api_name, p_bid_number || ' - update auction info; price changed');
1157: END IF;
1158: v_price_changed := 'Y';
1159: END IF;

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

1173: v_wf_item_key := NULL;
1174: END;
1175:
1176: IF v_wf_item_key IS NOT NULL THEN
1177: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1178: print_log(l_api_name, p_bid_number || ' - ack notif response');
1179: END IF;
1180: PON_AUCTION_PKG.ACK_NOTIF_RESPONSE(v_wf_item_key, v_tpc_name, 'Y','', v_subroutine_return_status);
1181:

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

1180: PON_AUCTION_PKG.ACK_NOTIF_RESPONSE(v_wf_item_key, v_tpc_name, 'Y','', v_subroutine_return_status);
1181:
1182: IF v_subroutine_return_status = 1 THEN
1183: IF (g_fnd_debug = 'Y') THEN
1184: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1185: FND_LOG.string(log_level => FND_LOG.level_exception,
1186: module => g_module_prefix || l_api_name,
1187: message => 'Response acknowledge notification cannot be sent for bid ' || p_bid_number);
1188: END IF;

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

1181:
1182: IF v_subroutine_return_status = 1 THEN
1183: IF (g_fnd_debug = 'Y') THEN
1184: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1185: FND_LOG.string(log_level => FND_LOG.level_exception,
1186: module => g_module_prefix || l_api_name,
1187: message => 'Response acknowledge notification cannot be sent for bid ' || p_bid_number);
1188: END IF;
1189: END IF;

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

1205: ELSE
1206: x_return_status := g_return_success;
1207: END IF;
1208:
1209: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1210: print_log(l_api_name, p_bid_number || ' - return status: ' || x_return_status || '; return code: ' || x_return_code);
1211: print_log(l_api_name, p_bid_number || ' - call send_resp_notif');
1212: END IF;
1213:

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

1215: PON_AUCTION_PKG.SEND_RESP_NOTIF(p_bid_number => p_bid_number,
1216: x_return_status =>v_subroutine_return_code);
1217:
1218: -- raise response publish business event (uday's code)
1219: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1220: print_log(l_api_name, p_bid_number || ' - call raise response publish business event');
1221: END IF;
1222: 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);
1223:

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

1220: print_log(l_api_name, p_bid_number || ' - call raise response publish business event');
1221: END IF;
1222: 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);
1223:
1224: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1225: print_log(l_api_name, 'v_biz_return_status=' || v_biz_return_status);
1226: print_log(l_api_name, 'v_biz_msg_count=' || v_biz_msg_count);
1227: print_log(l_api_name, 'v_biz_msg_data_value=' || v_biz_msg_data_value);
1228: print_log(l_api_name, p_bid_number || ' - finally PUBLISH the bid by setting bid_status to ACTIVE!!');

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

1241: , submit_stage = l_submit_stage
1242: --------------------------------------------------
1243: WHERE bid_number = p_bid_number;
1244:
1245: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1246: print_log(l_api_name, p_bid_number || ' - exiting publish successfully');
1247: END IF;
1248:
1249:

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

1270: l_api_name CONSTANT VARCHAR2(30) := 'remove_empty_rows';
1271:
1272: BEGIN
1273:
1274: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1275: print_log(l_api_name, p_bid_number || ' - begin remove empty rows for batch range ' || p_batch_start || ' ~ ' || p_batch_end || ' inclusive');
1276: END IF;
1277:
1278: -- 1) empty attributes (including header attributes)

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

1352: AND has_bid_flag = 'N'
1353: AND line_number >= p_batch_start
1354: AND line_number <= p_batch_end;
1355:
1356: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1357: print_log(l_api_name, p_bid_number || ' - end remove empty rows for batch range ' || p_batch_start || ' ~ ' || p_batch_end || ' inclusive');
1358: END IF;
1359: END remove_empty_rows;
1360:

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

1371: v_batch_end NUMBER;
1372:
1373: BEGIN
1374:
1375: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1376: print_log(l_api_name, p_bid_number || ' - BEGIN remove empty rows AUTONOMOUS');
1377: END IF;
1378:
1379: v_batch_start := 1;

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

1387:
1388: remove_empty_rows(p_bid_number, v_batch_start, v_batch_end);
1389: commit;
1390:
1391: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1392: print_log(l_api_name, p_bid_number || ' - remove empty rows: batch committed');
1393: END IF;
1394:
1395: v_batch_start := v_batch_end + 1;

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

1399: v_batch_end := v_batch_end + p_batch_size;
1400: END IF;
1401: END LOOP;
1402:
1403: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1404: print_log(l_api_name, p_bid_number || ' - END remove empty rows AUTONOMOUS');
1405: END IF;
1406: END remove_empty_rows_auto;
1407:

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

1427: l_tech_shortlist_flag VARCHAR2(1) := null;
1428:
1429: BEGIN
1430:
1431: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1432: print_log(l_api_name, p_bid_number || ' - begin update bid header fields');
1433: print_log(l_api_name, p_bid_number || ' - update bid header fields: p_publish_date=' || p_publish_date);
1434: END IF;
1435:

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

1445: technical_shortlist_flag = l_tech_shortlist_flag
1446: --,bid_status = 'ACTIVE'
1447: WHERE bid_number = p_bid_number;
1448:
1449: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1450: print_log(l_api_name, p_bid_number || ' - end update bid header fields');
1451: END IF;
1452: END update_bid_header_fields;
1453:

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

1463: PRAGMA AUTONOMOUS_TRANSACTION;
1464:
1465: l_api_name CONSTANT VARCHAR2(30) := 'update_bid_header_fields_auto';
1466: BEGIN
1467: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1468: print_log(l_api_name, p_bid_number || ' - BEGIN update bid header fields AUTONOMOUS');
1469: END IF;
1470:
1471: 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 1474: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

1470:
1471: 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);
1472: commit;
1473:
1474: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1475: print_log(l_api_name, p_bid_number || ' - update bid header fields: committed!');
1476: print_log(l_api_name, p_bid_number || ' - END update bid header fields AUTONOMOUS');
1477: END IF;
1478:

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

1506: l_api_name CONSTANT VARCHAR2(30) := 'publish_lines';
1507:
1508: BEGIN
1509:
1510: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1511: print_log(l_api_name, p_bid_number || ' - begin publish lines for batch range: ' || p_batch_start || ' ~ ' || p_batch_end || ' inclusive');
1512: END IF;
1513:
1514: IF p_rebid_flag = 'N' THEN

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

1545: AND line_number <= p_batch_end;
1546:
1547: END IF;
1548:
1549: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1550: print_log(l_api_name, p_bid_number || ' - end publish lines for batch range: ' || p_batch_start || ' ~ ' || p_batch_end || ' inclusive');
1551: END IF;
1552:
1553: END;

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

1571: l_api_name CONSTANT VARCHAR2(30) := 'publish_lines_auto';
1572:
1573: BEGIN
1574:
1575: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1576: print_log(l_api_name, p_bid_number || ' - BEGIN publish lines AUTONOMOUS');
1577: END IF;
1578:
1579: v_batch_start := 1;

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

1588: publish_lines(p_auction_header_id, p_bid_number, p_publish_date, p_tp_id,
1589: p_auc_tp_id, p_surrog_bid_flag, p_rebid_flag, v_batch_start, v_batch_end);
1590: commit;
1591:
1592: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1593: print_log(l_api_name, p_bid_number || ' - publish lines: batch committed!');
1594: END IF;
1595:
1596: v_batch_start := v_batch_end + 1;

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

1600: v_batch_end := v_batch_end + p_batch_size;
1601: END IF;
1602: END LOOP;
1603:
1604: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1605: print_log(l_api_name, p_bid_number || ' - END publish lines AUTONOMOUS');
1606: END IF;
1607:
1608: END publish_lines_auto;

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

1717:
1718: EXCEPTION
1719: WHEN others THEN
1720:
1721: -- insert an error into the FND LOG as well
1722: IF (g_fnd_debug = 'Y') THEN
1723: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1724: FND_LOG.string(log_level => FND_LOG.level_exception,
1725: module => g_module_prefix || l_api_name,

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

1719: WHEN others THEN
1720:
1721: -- insert an error into the FND LOG as well
1722: IF (g_fnd_debug = 'Y') THEN
1723: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1724: FND_LOG.string(log_level => FND_LOG.level_exception,
1725: module => g_module_prefix || l_api_name,
1726: message => 'SQL error code: ' || sqlcode || ', error message: ' || substr(sqlerrm,1,512));
1727: END IF;

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

1720:
1721: -- insert an error into the FND LOG as well
1722: IF (g_fnd_debug = 'Y') THEN
1723: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1724: FND_LOG.string(log_level => FND_LOG.level_exception,
1725: module => g_module_prefix || l_api_name,
1726: message => 'SQL error code: ' || sqlcode || ', error message: ' || substr(sqlerrm,1,512));
1727: END IF;
1728: END IF;

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

1740: p_ProgramTypeCode => 'BID_PUBLISH',
1741: p_DestinationPageCode => 'PON_CONCURRENT_ERRORS',
1742: p_bid_number => p_bid_number);
1743:
1744: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1745: print_log(l_api_name, 'Generating WF notif: ' || v_request_id || ' ' || v_user_name || ' ' || p_user_type || ' '||p_auction_header_id|| ' ' );
1746: END IF;
1747:
1748: -- insert an error indicating that a fatal error in the

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

1755: VALUES
1756: (p_bid_number, p_auction_header_id, 'PUBLISHBID', v_request_id,
1757: v_error_msg_name, sysdate+7);
1758:
1759: -- insert an error into the FND LOG as well
1760: IF (g_fnd_debug = 'Y') THEN
1761: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1762: FND_LOG.string(log_level => FND_LOG.level_exception,
1763: module => g_module_prefix || l_api_name,

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

1757: v_error_msg_name, sysdate+7);
1758:
1759: -- insert an error into the FND LOG as well
1760: IF (g_fnd_debug = 'Y') THEN
1761: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1762: FND_LOG.string(log_level => FND_LOG.level_exception,
1763: module => g_module_prefix || l_api_name,
1764: message => 'A fatal error has occurred during the concurrent processing of response publish for response number ' || p_bid_number);
1765: END IF;

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

1758:
1759: -- insert an error into the FND LOG as well
1760: IF (g_fnd_debug = 'Y') THEN
1761: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1762: FND_LOG.string(log_level => FND_LOG.level_exception,
1763: module => g_module_prefix || l_api_name,
1764: message => 'A fatal error has occurred during the concurrent processing of response publish for response number ' || p_bid_number);
1765: END IF;
1766: END IF;

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

1859:
1860: EXCEPTION
1861: WHEN others THEN
1862:
1863: -- insert an error into the FND LOG as well
1864: IF (g_fnd_debug = 'Y') THEN
1865: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1866: FND_LOG.string(log_level => FND_LOG.level_exception,
1867: module => g_module_prefix || l_api_name,

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

1861: WHEN others THEN
1862:
1863: -- insert an error into the FND LOG as well
1864: IF (g_fnd_debug = 'Y') THEN
1865: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1866: FND_LOG.string(log_level => FND_LOG.level_exception,
1867: module => g_module_prefix || l_api_name,
1868: message => 'SQL error code: ' || sqlcode || ', error message: ' || substr(sqlerrm,1,512));
1869: END IF;

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

1862:
1863: -- insert an error into the FND LOG as well
1864: IF (g_fnd_debug = 'Y') THEN
1865: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1866: FND_LOG.string(log_level => FND_LOG.level_exception,
1867: module => g_module_prefix || l_api_name,
1868: message => 'SQL error code: ' || sqlcode || ', error message: ' || substr(sqlerrm,1,512));
1869: END IF;
1870: END IF;

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

1883: p_ProgramTypeCode => 'BID_VALIDATE',
1884: p_DestinationPageCode => 'PON_CONCURRENT_ERRORS',
1885: p_bid_number => p_bid_number);
1886:
1887: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN
1888: print_log(l_api_name, 'Generating WF notif: ' || v_request_id || ' ' || v_user_name || ' ' || p_user_type || ' '||p_auction_header_id|| ' ' );
1889: END IF;
1890:
1891: -- insert an error indicating that a fatal error in the

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

1898: VALUES
1899: (p_bid_number, p_auction_header_id, 'VALIDATEBID', v_request_id,
1900: v_error_msg_name, sysdate+7);
1901:
1902: -- insert an error into the FND LOG as well
1903: IF (g_fnd_debug = 'Y') THEN
1904: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1905: FND_LOG.string(log_level => FND_LOG.level_exception,
1906: module => g_module_prefix || l_api_name,

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

1900: v_error_msg_name, sysdate+7);
1901:
1902: -- insert an error into the FND LOG as well
1903: IF (g_fnd_debug = 'Y') THEN
1904: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1905: FND_LOG.string(log_level => FND_LOG.level_exception,
1906: module => g_module_prefix || l_api_name,
1907: message => 'A fatal error has occurred during the concurrent processing of response validation for response number ' || p_bid_number || '. See above for error details');
1908: END IF;

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

1901:
1902: -- insert an error into the FND LOG as well
1903: IF (g_fnd_debug = 'Y') THEN
1904: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1905: FND_LOG.string(log_level => FND_LOG.level_exception,
1906: module => g_module_prefix || l_api_name,
1907: message => 'A fatal error has occurred during the concurrent processing of response validation for response number ' || p_bid_number || '. See above for error details');
1908: END IF;
1909: END IF;

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

1975: l_api_name CONSTANT VARCHAR2(30) := 'get_user_lang_message';
1976: l_user_id FND_USER.USER_ID%TYPE;
1977: BEGIN
1978:
1979: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1980: FND_LOG.string(log_level => FND_LOG.level_procedure,
1981: module => g_module_prefix || l_api_name,
1982: message => 'Entered with p_tpc_id = ' || p_tpc_id ||
1983: ', p_message_name = ' || p_message_name ||

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

1976: l_user_id FND_USER.USER_ID%TYPE;
1977: BEGIN
1978:
1979: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1980: FND_LOG.string(log_level => FND_LOG.level_procedure,
1981: module => g_module_prefix || l_api_name,
1982: message => 'Entered with p_tpc_id = ' || p_tpc_id ||
1983: ', p_message_name = ' || p_message_name ||
1984: ', p_message_token1_name = ' || p_message_token1_name ||

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

1996: WHERE
1997: FND_USER.PERSON_PARTY_ID = p_tpc_id
1998: AND ROWNUM=1;
1999:
2000: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2001: FND_LOG.string(log_level => FND_LOG.level_statement,
2002: module => g_module_prefix || l_api_name,
2003: message => 'l_user_id = ' || l_user_id);
2004: END IF;

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

1997: FND_USER.PERSON_PARTY_ID = p_tpc_id
1998: AND ROWNUM=1;
1999:
2000: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2001: FND_LOG.string(log_level => FND_LOG.level_statement,
2002: module => g_module_prefix || l_api_name,
2003: message => 'l_user_id = ' || l_user_id);
2004: END IF;
2005:

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

2004: END IF;
2005:
2006: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE (l_user_id, l_language_code);
2007:
2008: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2009: FND_LOG.string(log_level => FND_LOG.level_statement,
2010: module => g_module_prefix || l_api_name,
2011: message => 'l_language_code = ' || l_language_code);
2012: END IF;

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

2005:
2006: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE (l_user_id, l_language_code);
2007:
2008: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2009: FND_LOG.string(log_level => FND_LOG.level_statement,
2010: module => g_module_prefix || l_api_name,
2011: message => 'l_language_code = ' || l_language_code);
2012: END IF;
2013:

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

2019: token1_value => p_message_token1_value,
2020: token2 => p_message_token2_name,
2021: token2_value => p_message_token2_value);
2022:
2023: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2024: FND_LOG.string(log_level => FND_LOG.level_statement,
2025: module => g_module_prefix || l_api_name,
2026: message => 'x_message_text = ' || x_message_text);
2027: END IF;

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

2020: token2 => p_message_token2_name,
2021: token2_value => p_message_token2_value);
2022:
2023: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2024: FND_LOG.string(log_level => FND_LOG.level_statement,
2025: module => g_module_prefix || l_api_name,
2026: message => 'x_message_text = ' || x_message_text);
2027: END IF;
2028: