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

Line 207: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

203: IF FND_API.to_Boolean(p_init_msg_list) THEN
204: FND_MSG_PUB.initialize();
205: END IF;
206:
207: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
208: fnd_log.string(fnd_log.level_statement,
209: l_api_name,
210: 'called ' || l_api_name);
211: end if;

Line 208: fnd_log.string(fnd_log.level_statement,

204: FND_MSG_PUB.initialize();
205: END IF;
206:
207: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
208: fnd_log.string(fnd_log.level_statement,
209: l_api_name,
210: 'called ' || l_api_name);
211: end if;
212:

Line 468: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then

464: nvl(ou.date_from(+),sysdate-1) < sysdate and
465: nvl(ou.date_to(+),sysdate+1) > sysdate ;
466: exception
467: when no_data_found then
468: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
469: fnd_log.string(fnd_log.level_exception,
470: l_api_name,
471: 'no data found for ' || p_doc_id);
472: end if;

Line 469: fnd_log.string(fnd_log.level_exception,

465: nvl(ou.date_to(+),sysdate+1) > sysdate ;
466: exception
467: when no_data_found then
468: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
469: fnd_log.string(fnd_log.level_exception,
470: l_api_name,
471: 'no data found for ' || p_doc_id);
472: end if;
473:

Line 722: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then

718: nvl(ou.date_from(+),sysdate-1) < sysdate and
719: nvl(ou.date_to(+),sysdate+1) > sysdate ;
720: exception
721: when no_data_found then
722: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
723: fnd_log.string(fnd_log.level_exception,
724: l_api_name,
725: 'no data found for ' || p_doc_id);
726: end if;

Line 723: fnd_log.string(fnd_log.level_exception,

719: nvl(ou.date_to(+),sysdate+1) > sysdate ;
720: exception
721: when no_data_found then
722: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
723: fnd_log.string(fnd_log.level_exception,
724: l_api_name,
725: 'no data found for ' || p_doc_id);
726: end if;
727:

Line 733: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then

729: x_return_status := fnd_api.g_ret_sts_error;
730: return;
731: end ;
732: else
733: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
734: fnd_log.string(fnd_log.level_exception,
735: l_api_name,
736: 'unknown doctype ' || p_doctype_id);
737: end if;

Line 734: fnd_log.string(fnd_log.level_exception,

730: return;
731: end ;
732: else
733: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
734: fnd_log.string(fnd_log.level_exception,
735: l_api_name,
736: 'unknown doctype ' || p_doctype_id);
737: end if;
738:

Line 757: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

753: p_sys_var_value_tbl(l_sys_var_index).variable_value_id := l_dummy_value;
754:
755: l_progress := 220;
756:
757: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
758: fnd_log.string(fnd_log.level_statement,
759: l_api_name,
760: 'searching for ' || p_sys_var_value_tbl(l_sys_var_index).variable_code);
761: end if;

Line 758: fnd_log.string(fnd_log.level_statement,

754:
755: l_progress := 220;
756:
757: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
758: fnd_log.string(fnd_log.level_statement,
759: l_api_name,
760: 'searching for ' || p_sys_var_value_tbl(l_sys_var_index).variable_code);
761: end if;
762:

Line 773: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

769: l_pon_sys_vars(l_pon_var_index).variable_code) then
770:
771: l_progress := 260;
772:
773: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
774: fnd_log.string(fnd_log.level_statement,
775: l_api_name,
776: 'found ' || p_sys_var_value_tbl(l_sys_var_index).variable_code || ' at l_pon_var_index=' || l_pon_var_index || ' value=' || l_pon_sys_vars(l_pon_var_index).variable_value_id);
777: end if;

Line 774: fnd_log.string(fnd_log.level_statement,

770:
771: l_progress := 260;
772:
773: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
774: fnd_log.string(fnd_log.level_statement,
775: l_api_name,
776: 'found ' || p_sys_var_value_tbl(l_sys_var_index).variable_code || ' at l_pon_var_index=' || l_pon_var_index || ' value=' || l_pon_sys_vars(l_pon_var_index).variable_value_id);
777: end if;
778:

Line 793: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then

789: x_msg_data := null;
790: x_msg_count := 0;
791:
792: EXCEPTION when others then
793: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
794: fnd_log.string(fnd_log.level_exception,
795: l_api_name,
796: 'unknown exception for ' || p_doc_id || ' - progress=' || l_progress);
797: end if;

Line 794: fnd_log.string(fnd_log.level_exception,

790: x_msg_count := 0;
791:
792: EXCEPTION when others then
793: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
794: fnd_log.string(fnd_log.level_exception,
795: l_api_name,
796: 'unknown exception for ' || p_doc_id || ' - progress=' || l_progress);
797: end if;
798:

Line 884: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

880: IF FND_API.to_Boolean(p_init_msg_list) THEN
881: FND_MSG_PUB.initialize();
882: END IF;
883:
884: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
885: fnd_log.string(fnd_log.level_statement,
886: l_api_name,
887: 'called ' || l_api_name);
888: end if;

Line 885: fnd_log.string(fnd_log.level_statement,

881: FND_MSG_PUB.initialize();
882: END IF;
883:
884: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
885: fnd_log.string(fnd_log.level_statement,
886: l_api_name,
887: 'called ' || l_api_name);
888: end if;
889:

Line 908: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then

904: p_doctype_id = PON_CONTERMS_UTL_PVT.RESPONSE) then
905:
906: l_progress := 101;
907:
908: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
909: fnd_log.string(fnd_log.level_exception,
910: l_api_name,
911: 'unexpected call for changes to ' || p_doctype_id || ' ' || p_doc_id);
912: end if;

Line 909: fnd_log.string(fnd_log.level_exception,

905:
906: l_progress := 101;
907:
908: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
909: fnd_log.string(fnd_log.level_exception,
910: l_api_name,
911: 'unexpected call for changes to ' || p_doctype_id || ' ' || p_doc_id);
912: end if;
913:

Line 948: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then

944: where
945: auction_header_id = p_doc_id;
946: exception
947: when no_data_found then
948: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
949: fnd_log.string(fnd_log.level_exception,
950: l_api_name,
951: 'no data found for ' || p_doc_id);
952: end if;

Line 949: fnd_log.string(fnd_log.level_exception,

945: auction_header_id = p_doc_id;
946: exception
947: when no_data_found then
948: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
949: fnd_log.string(fnd_log.level_exception,
950: l_api_name,
951: 'no data found for ' || p_doc_id);
952: end if;
953:

Line 968: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

964: elsif (l_prev_round_id is not NULL) then
965: l_prev_header_id := l_prev_round_id;
966: else
967: -- no previous revision... so there can be no changes
968: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
969: fnd_log.string(fnd_log.level_statement,
970: l_api_name,
971: 'no changes possible for document without revision');
972: end if;

Line 969: fnd_log.string(fnd_log.level_statement,

965: l_prev_header_id := l_prev_round_id;
966: else
967: -- no previous revision... so there can be no changes
968: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
969: fnd_log.string(fnd_log.level_statement,
970: l_api_name,
971: 'no changes possible for document without revision');
972: end if;
973:

Line 1097: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then

1093: nvl(ou2.date_to(+),sysdate+1) > sysdate ;
1094: else
1095: -- this is an unknown doctype
1096:
1097: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
1098: fnd_log.string(fnd_log.level_exception,
1099: l_api_name,
1100: 'unknown doctype ' || p_doctype_id);
1101: end if;

Line 1098: fnd_log.string(fnd_log.level_exception,

1094: else
1095: -- this is an unknown doctype
1096:
1097: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
1098: fnd_log.string(fnd_log.level_exception,
1099: l_api_name,
1100: 'unknown doctype ' || p_doctype_id);
1101: end if;
1102:

Line 1115: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1111: -- filter p_sys_var_tbl variable
1112: -- while pruning the 'N' entries from l_pon_sys_vars for performance
1113: l_sys_var_index := p_sys_var_tbl.first;
1114: while (l_sys_var_index <= p_sys_var_tbl.last) loop
1115: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1116: fnd_log.string(fnd_log.level_statement,
1117: l_api_name,
1118: 'searching for ' || p_sys_var_tbl(l_sys_var_index));
1119: end if;

Line 1116: fnd_log.string(fnd_log.level_statement,

1112: -- while pruning the 'N' entries from l_pon_sys_vars for performance
1113: l_sys_var_index := p_sys_var_tbl.first;
1114: while (l_sys_var_index <= p_sys_var_tbl.last) loop
1115: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1116: fnd_log.string(fnd_log.level_statement,
1117: l_api_name,
1118: 'searching for ' || p_sys_var_tbl(l_sys_var_index));
1119: end if;
1120:

Line 1130: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1126: if (l_pon_sys_vars(l_pon_var_index)= 'N') then
1127: -- a value did not change, remove it from the array for performance
1128: l_progress := 230;
1129:
1130: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1131: fnd_log.string(fnd_log.level_statement,
1132: l_api_name,
1133: 'removing ' || l_pon_var_index);
1134: end if;

Line 1131: fnd_log.string(fnd_log.level_statement,

1127: -- a value did not change, remove it from the array for performance
1128: l_progress := 230;
1129:
1130: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1131: fnd_log.string(fnd_log.level_statement,
1132: l_api_name,
1133: 'removing ' || l_pon_var_index);
1134: end if;
1135:

Line 1143: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1139: p_sys_var_tbl(l_sys_var_index)) then
1140: -- this value has changed, set found and break the loop
1141: l_progress := 240;
1142:
1143: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1144: fnd_log.string(fnd_log.level_statement,
1145: l_api_name,
1146: p_sys_var_tbl(l_sys_var_index) || ' changed');
1147: end if;

Line 1144: fnd_log.string(fnd_log.level_statement,

1140: -- this value has changed, set found and break the loop
1141: l_progress := 240;
1142:
1143: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1144: fnd_log.string(fnd_log.level_statement,
1145: l_api_name,
1146: p_sys_var_tbl(l_sys_var_index) || ' changed');
1147: end if;
1148:

Line 1160: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1156: l_progress := 250;
1157:
1158: if (not l_found) then
1159: -- this variable did not change, remove it from p_sys_var_tbl
1160: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1161: fnd_log.string(fnd_log.level_statement,
1162: l_api_name,
1163: p_sys_var_tbl(l_sys_var_index) || ' did not change');
1164: end if;

Line 1161: fnd_log.string(fnd_log.level_statement,

1157:
1158: if (not l_found) then
1159: -- this variable did not change, remove it from p_sys_var_tbl
1160: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1161: fnd_log.string(fnd_log.level_statement,
1162: l_api_name,
1163: p_sys_var_tbl(l_sys_var_index) || ' did not change');
1164: end if;
1165:

Line 1179: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then

1175: x_msg_data := null;
1176: x_msg_count := 0;
1177:
1178: EXCEPTION when others then
1179: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
1180: fnd_log.string(fnd_log.level_exception,
1181: l_api_name,
1182: 'unknown exception for ' || p_doc_id || ' - progress=' || l_progress);
1183: end if;

Line 1180: fnd_log.string(fnd_log.level_exception,

1176: x_msg_count := 0;
1177:
1178: EXCEPTION when others then
1179: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
1180: fnd_log.string(fnd_log.level_exception,
1181: l_api_name,
1182: 'unknown exception for ' || p_doc_id || ' - progress=' || l_progress);
1183: end if;
1184:

Line 1260: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1256: paip.auction_header_id = l_auction_header_id
1257: and paip.category_name is not null;
1258: exception
1259: when others then
1260: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1261: fnd_log.string(fnd_log.level_statement,
1262: 'pon_conterms_utl_grp.get_item_category',
1263: 'category query returned no rows');
1264: end if;

Line 1261: fnd_log.string(fnd_log.level_statement,

1257: and paip.category_name is not null;
1258: exception
1259: when others then
1260: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1261: fnd_log.string(fnd_log.level_statement,
1262: 'pon_conterms_utl_grp.get_item_category',
1263: 'category query returned no rows');
1264: end if;
1265: end ;

Line 1288: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1284: paip.auction_header_id = l_auction_header_id
1285: and paip.item_number is not null;
1286: exception
1287: when others then
1288: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1289: fnd_log.string(fnd_log.level_statement,
1290: 'pon_conterms_utl_grp.get_item_category',
1291: 'item query returned no rows');
1292: end if;

Line 1289: fnd_log.string(fnd_log.level_statement,

1285: and paip.item_number is not null;
1286: exception
1287: when others then
1288: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1289: fnd_log.string(fnd_log.level_statement,
1290: 'pon_conterms_utl_grp.get_item_category',
1291: 'item query returned no rows');
1292: end if;
1293: end ;