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 191: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

187: IF FND_API.to_Boolean(p_init_msg_list) THEN
188: FND_MSG_PUB.initialize();
189: END IF;
190:
191: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
192: fnd_log.string(fnd_log.level_statement,
193: l_api_name,
194: 'called ' || l_api_name);
195: end if;

Line 192: fnd_log.string(fnd_log.level_statement,

188: FND_MSG_PUB.initialize();
189: END IF;
190:
191: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
192: fnd_log.string(fnd_log.level_statement,
193: l_api_name,
194: 'called ' || l_api_name);
195: end if;
196:

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

446: nvl(ou.date_from(+),sysdate-1) < sysdate and
447: nvl(ou.date_to(+),sysdate+1) > sysdate ;
448: exception
449: when no_data_found then
450: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
451: fnd_log.string(fnd_log.level_exception,
452: l_api_name,
453: 'no data found for ' || p_doc_id);
454: end if;

Line 451: fnd_log.string(fnd_log.level_exception,

447: nvl(ou.date_to(+),sysdate+1) > sysdate ;
448: exception
449: when no_data_found then
450: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
451: fnd_log.string(fnd_log.level_exception,
452: l_api_name,
453: 'no data found for ' || p_doc_id);
454: end if;
455:

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

698: nvl(ou.date_from(+),sysdate-1) < sysdate and
699: nvl(ou.date_to(+),sysdate+1) > sysdate ;
700: exception
701: when no_data_found then
702: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
703: fnd_log.string(fnd_log.level_exception,
704: l_api_name,
705: 'no data found for ' || p_doc_id);
706: end if;

Line 703: fnd_log.string(fnd_log.level_exception,

699: nvl(ou.date_to(+),sysdate+1) > sysdate ;
700: exception
701: when no_data_found then
702: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
703: fnd_log.string(fnd_log.level_exception,
704: l_api_name,
705: 'no data found for ' || p_doc_id);
706: end if;
707:

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

709: x_return_status := fnd_api.g_ret_sts_error;
710: return;
711: end ;
712: else
713: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
714: fnd_log.string(fnd_log.level_exception,
715: l_api_name,
716: 'unknown doctype ' || p_doctype_id);
717: end if;

Line 714: fnd_log.string(fnd_log.level_exception,

710: return;
711: end ;
712: else
713: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
714: fnd_log.string(fnd_log.level_exception,
715: l_api_name,
716: 'unknown doctype ' || p_doctype_id);
717: end if;
718:

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

733: p_sys_var_value_tbl(l_sys_var_index).variable_value_id := l_dummy_value;
734:
735: l_progress := 220;
736:
737: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
738: fnd_log.string(fnd_log.level_statement,
739: l_api_name,
740: 'searching for ' || p_sys_var_value_tbl(l_sys_var_index).variable_code);
741: end if;

Line 738: fnd_log.string(fnd_log.level_statement,

734:
735: l_progress := 220;
736:
737: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
738: fnd_log.string(fnd_log.level_statement,
739: l_api_name,
740: 'searching for ' || p_sys_var_value_tbl(l_sys_var_index).variable_code);
741: end if;
742:

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

749: l_pon_sys_vars(l_pon_var_index).variable_code) then
750:
751: l_progress := 260;
752:
753: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
754: fnd_log.string(fnd_log.level_statement,
755: l_api_name,
756: '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);
757: end if;

Line 754: fnd_log.string(fnd_log.level_statement,

750:
751: l_progress := 260;
752:
753: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
754: fnd_log.string(fnd_log.level_statement,
755: l_api_name,
756: '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);
757: end if;
758:

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

769: x_msg_data := null;
770: x_msg_count := 0;
771:
772: EXCEPTION when others then
773: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
774: fnd_log.string(fnd_log.level_exception,
775: l_api_name,
776: 'unknown exception for ' || p_doc_id || ' - progress=' || l_progress);
777: end if;

Line 774: fnd_log.string(fnd_log.level_exception,

770: x_msg_count := 0;
771:
772: EXCEPTION when others then
773: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
774: fnd_log.string(fnd_log.level_exception,
775: l_api_name,
776: 'unknown exception for ' || p_doc_id || ' - progress=' || l_progress);
777: end if;
778:

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

860: IF FND_API.to_Boolean(p_init_msg_list) THEN
861: FND_MSG_PUB.initialize();
862: END IF;
863:
864: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
865: fnd_log.string(fnd_log.level_statement,
866: l_api_name,
867: 'called ' || l_api_name);
868: end if;

Line 865: fnd_log.string(fnd_log.level_statement,

861: FND_MSG_PUB.initialize();
862: END IF;
863:
864: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
865: fnd_log.string(fnd_log.level_statement,
866: l_api_name,
867: 'called ' || l_api_name);
868: end if;
869:

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

883: p_doctype_id = PON_CONTERMS_UTL_PVT.RESPONSE) then
884:
885: l_progress := 101;
886:
887: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
888: fnd_log.string(fnd_log.level_exception,
889: l_api_name,
890: 'unexpected call for changes to ' || p_doctype_id || ' ' || p_doc_id);
891: end if;

Line 888: fnd_log.string(fnd_log.level_exception,

884:
885: l_progress := 101;
886:
887: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
888: fnd_log.string(fnd_log.level_exception,
889: l_api_name,
890: 'unexpected call for changes to ' || p_doctype_id || ' ' || p_doc_id);
891: end if;
892:

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

922: where
923: auction_header_id = p_doc_id;
924: exception
925: when no_data_found then
926: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
927: fnd_log.string(fnd_log.level_exception,
928: l_api_name,
929: 'no data found for ' || p_doc_id);
930: end if;

Line 927: fnd_log.string(fnd_log.level_exception,

923: auction_header_id = p_doc_id;
924: exception
925: when no_data_found then
926: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
927: fnd_log.string(fnd_log.level_exception,
928: l_api_name,
929: 'no data found for ' || p_doc_id);
930: end if;
931:

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

942: elsif (l_prev_round_id is not NULL) then
943: l_prev_header_id := l_prev_round_id;
944: else
945: -- no previous revision... so there can be no changes
946: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
947: fnd_log.string(fnd_log.level_statement,
948: l_api_name,
949: 'no changes possible for document without revision');
950: end if;

Line 947: fnd_log.string(fnd_log.level_statement,

943: l_prev_header_id := l_prev_round_id;
944: else
945: -- no previous revision... so there can be no changes
946: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
947: fnd_log.string(fnd_log.level_statement,
948: l_api_name,
949: 'no changes possible for document without revision');
950: end if;
951:

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

1071: nvl(ou2.date_to(+),sysdate+1) > sysdate ;
1072: else
1073: -- this is an unknown doctype
1074:
1075: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
1076: fnd_log.string(fnd_log.level_exception,
1077: l_api_name,
1078: 'unknown doctype ' || p_doctype_id);
1079: end if;

Line 1076: fnd_log.string(fnd_log.level_exception,

1072: else
1073: -- this is an unknown doctype
1074:
1075: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
1076: fnd_log.string(fnd_log.level_exception,
1077: l_api_name,
1078: 'unknown doctype ' || p_doctype_id);
1079: end if;
1080:

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

1089: -- filter p_sys_var_tbl variable
1090: -- while pruning the 'N' entries from l_pon_sys_vars for performance
1091: l_sys_var_index := p_sys_var_tbl.first;
1092: while (l_sys_var_index <= p_sys_var_tbl.last) loop
1093: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1094: fnd_log.string(fnd_log.level_statement,
1095: l_api_name,
1096: 'searching for ' || p_sys_var_tbl(l_sys_var_index));
1097: end if;

Line 1094: fnd_log.string(fnd_log.level_statement,

1090: -- while pruning the 'N' entries from l_pon_sys_vars for performance
1091: l_sys_var_index := p_sys_var_tbl.first;
1092: while (l_sys_var_index <= p_sys_var_tbl.last) loop
1093: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1094: fnd_log.string(fnd_log.level_statement,
1095: l_api_name,
1096: 'searching for ' || p_sys_var_tbl(l_sys_var_index));
1097: end if;
1098:

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

1104: if (l_pon_sys_vars(l_pon_var_index)= 'N') then
1105: -- a value did not change, remove it from the array for performance
1106: l_progress := 230;
1107:
1108: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1109: fnd_log.string(fnd_log.level_statement,
1110: l_api_name,
1111: 'removing ' || l_pon_var_index);
1112: end if;

Line 1109: fnd_log.string(fnd_log.level_statement,

1105: -- a value did not change, remove it from the array for performance
1106: l_progress := 230;
1107:
1108: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1109: fnd_log.string(fnd_log.level_statement,
1110: l_api_name,
1111: 'removing ' || l_pon_var_index);
1112: end if;
1113:

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

1117: p_sys_var_tbl(l_sys_var_index)) then
1118: -- this value has changed, set found and break the loop
1119: l_progress := 240;
1120:
1121: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1122: fnd_log.string(fnd_log.level_statement,
1123: l_api_name,
1124: p_sys_var_tbl(l_sys_var_index) || ' changed');
1125: end if;

Line 1122: fnd_log.string(fnd_log.level_statement,

1118: -- this value has changed, set found and break the loop
1119: l_progress := 240;
1120:
1121: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1122: fnd_log.string(fnd_log.level_statement,
1123: l_api_name,
1124: p_sys_var_tbl(l_sys_var_index) || ' changed');
1125: end if;
1126:

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

1134: l_progress := 250;
1135:
1136: if (not l_found) then
1137: -- this variable did not change, remove it from p_sys_var_tbl
1138: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1139: fnd_log.string(fnd_log.level_statement,
1140: l_api_name,
1141: p_sys_var_tbl(l_sys_var_index) || ' did not change');
1142: end if;

Line 1139: fnd_log.string(fnd_log.level_statement,

1135:
1136: if (not l_found) then
1137: -- this variable did not change, remove it from p_sys_var_tbl
1138: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1139: fnd_log.string(fnd_log.level_statement,
1140: l_api_name,
1141: p_sys_var_tbl(l_sys_var_index) || ' did not change');
1142: end if;
1143:

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

1153: x_msg_data := null;
1154: x_msg_count := 0;
1155:
1156: EXCEPTION when others then
1157: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
1158: fnd_log.string(fnd_log.level_exception,
1159: l_api_name,
1160: 'unknown exception for ' || p_doc_id || ' - progress=' || l_progress);
1161: end if;

Line 1158: fnd_log.string(fnd_log.level_exception,

1154: x_msg_count := 0;
1155:
1156: EXCEPTION when others then
1157: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then
1158: fnd_log.string(fnd_log.level_exception,
1159: l_api_name,
1160: 'unknown exception for ' || p_doc_id || ' - progress=' || l_progress);
1161: end if;
1162:

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

1234: paip.auction_header_id = l_auction_header_id
1235: and paip.category_name is not null;
1236: exception
1237: when others then
1238: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1239: fnd_log.string(fnd_log.level_statement,
1240: 'pon_conterms_utl_grp.get_item_category',
1241: 'category query returned no rows');
1242: end if;

Line 1239: fnd_log.string(fnd_log.level_statement,

1235: and paip.category_name is not null;
1236: exception
1237: when others then
1238: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1239: fnd_log.string(fnd_log.level_statement,
1240: 'pon_conterms_utl_grp.get_item_category',
1241: 'category query returned no rows');
1242: end if;
1243: end ;

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

1262: paip.auction_header_id = l_auction_header_id
1263: and paip.item_number is not null;
1264: exception
1265: when others then
1266: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1267: fnd_log.string(fnd_log.level_statement,
1268: 'pon_conterms_utl_grp.get_item_category',
1269: 'item query returned no rows');
1270: end if;

Line 1267: fnd_log.string(fnd_log.level_statement,

1263: and paip.item_number is not null;
1264: exception
1265: when others then
1266: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1267: fnd_log.string(fnd_log.level_statement,
1268: 'pon_conterms_utl_grp.get_item_category',
1269: 'item query returned no rows');
1270: end if;
1271: end ;