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.WSH_OPSM_ASN_BE_PKG dependencies on FND_LOG

Line 155: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

151: get_genealogy_called get_genealogy_called_type;
152: --bug 10357152 - opsmperf end
153: BEGIN
154:
155: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
156: --DECLARE
157: --l_start_time TIMESTAMP;
158: BEGIN
159: SELECT SYSTIMESTAMP INTO l_start_time FROM dual;

Line 162: FND_LOG.String(

158: BEGIN
159: SELECT SYSTIMESTAMP INTO l_start_time FROM dual;
160: l_start_timec := TO_CHAR(l_start_time, 'DD-MON-YYYY HH24:MI:SSxFF');
161:
162: FND_LOG.String(
163: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
164: MESSAGE => 'start time= '||TO_CHAR(l_start_time, 'DD-MON-YYYY HH24:MI:SSxFF'),
165: MODULE => 'opsmperf.begin');
166: END;

Line 163: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

159: SELECT SYSTIMESTAMP INTO l_start_time FROM dual;
160: l_start_timec := TO_CHAR(l_start_time, 'DD-MON-YYYY HH24:MI:SSxFF');
161:
162: FND_LOG.String(
163: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
164: MESSAGE => 'start time= '||TO_CHAR(l_start_time, 'DD-MON-YYYY HH24:MI:SSxFF'),
165: MODULE => 'opsmperf.begin');
166: END;
167: END IF;

Line 407: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

403: );
404: --l_get_genealogy := false;
405: --idx1 := rslt_tab.count;
406:
407: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
408: FND_LOG.String(
409: LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
410: MESSAGE => 'Rows in rslt_tab_tmp',
411: MODULE => 'wsh.plsql.wsh_opsm_asn_be_pkg.get_asn_data');

Line 408: FND_LOG.String(

404: --l_get_genealogy := false;
405: --idx1 := rslt_tab.count;
406:
407: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
408: FND_LOG.String(
409: LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
410: MESSAGE => 'Rows in rslt_tab_tmp',
411: MODULE => 'wsh.plsql.wsh_opsm_asn_be_pkg.get_asn_data');
412: END IF;

Line 409: LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

405: --idx1 := rslt_tab.count;
406:
407: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
408: FND_LOG.String(
409: LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
410: MESSAGE => 'Rows in rslt_tab_tmp',
411: MODULE => 'wsh.plsql.wsh_opsm_asn_be_pkg.get_asn_data');
412: END IF;
413: IF (rslt_tab_tmp.COUNT > 0) THEN

Line 1035: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1031: p_out_itemgenealogy :=v_itemgenealogy_tab;
1032: IF l_debug_on THEN
1033: WSH_DEBUG_SV.pop(l_module_name);
1034: END IF;
1035: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1036: DECLARE
1037: --l_end_time DATE;
1038: --l_end_time TIMESTAMP;
1039: l_time_diff INTERVAL DAY TO SECOND;

Line 1045: FND_LOG.String(

1041: BEGIN
1042: SELECT SYSTIMESTAMP INTO l_end_time FROM dual;
1043: l_end_timec := TO_CHAR(l_end_time, 'DD-MON-YYYY HH24:MI:SSxFF');
1044:
1045: FND_LOG.String(
1046: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1047: MESSAGE => 'end time= '||TO_CHAR(l_end_time, 'DD-MON-YYYY HH24:MI:SSxFF'),
1048: MODULE => 'opsmperf.end');
1049:

Line 1046: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

1042: SELECT SYSTIMESTAMP INTO l_end_time FROM dual;
1043: l_end_timec := TO_CHAR(l_end_time, 'DD-MON-YYYY HH24:MI:SSxFF');
1044:
1045: FND_LOG.String(
1046: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1047: MESSAGE => 'end time= '||TO_CHAR(l_end_time, 'DD-MON-YYYY HH24:MI:SSxFF'),
1048: MODULE => 'opsmperf.end');
1049:
1050: SELECT (l_end_time-l_start_time) INTO l_time_diff FROM dual;

Line 1057: FND_LOG.String(

1053: to_number(extract(minute from l_time_diff)) * 60 +
1054: to_number(extract(hour from l_time_diff)) * 60 * 60 +
1055: to_number(extract(day from l_time_diff)) * 60 * 60* 24;
1056:
1057: FND_LOG.String(
1058: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1059: MESSAGE => 'time difference= '||l_time_diff_secs,
1060: MODULE => 'opsmperf.end');
1061:

Line 1058: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

1054: to_number(extract(hour from l_time_diff)) * 60 * 60 +
1055: to_number(extract(day from l_time_diff)) * 60 * 60* 24;
1056:
1057: FND_LOG.String(
1058: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1059: MESSAGE => 'time difference= '||l_time_diff_secs,
1060: MODULE => 'opsmperf.end');
1061:
1062: END;

Line 1222: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1218: get_genealogy_called get_genealogy_called_type;
1219: --bug 10357152 - opsmperf end
1220: BEGIN
1221:
1222: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1223: --DECLARE
1224: --l_start_time TIMESTAMP;
1225: BEGIN
1226: SELECT SYSTIMESTAMP INTO l_start_time FROM dual;

Line 1229: FND_LOG.String(

1225: BEGIN
1226: SELECT SYSTIMESTAMP INTO l_start_time FROM dual;
1227: l_start_timec := TO_CHAR(l_start_time, 'DD-MON-YYYY HH24:MI:SSxFF');
1228:
1229: FND_LOG.String(
1230: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1231: MESSAGE => 'start time= '||TO_CHAR(l_start_time, 'DD-MON-YYYY HH24:MI:SSxFF'),
1232: MODULE => 'opsmperf.begin');
1233: END;

Line 1230: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

1226: SELECT SYSTIMESTAMP INTO l_start_time FROM dual;
1227: l_start_timec := TO_CHAR(l_start_time, 'DD-MON-YYYY HH24:MI:SSxFF');
1228:
1229: FND_LOG.String(
1230: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1231: MESSAGE => 'start time= '||TO_CHAR(l_start_time, 'DD-MON-YYYY HH24:MI:SSxFF'),
1232: MODULE => 'opsmperf.begin');
1233: END;
1234: END IF;

Line 1472: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1468: );
1469: --l_get_genealogy := false;
1470: --idx1 := rslt_tab.count;
1471:
1472: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1473: FND_LOG.String(
1474: LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
1475: MESSAGE => 'Rows in rslt_tab_tmp',
1476: MODULE => 'wsh.plsql.wsh_opsm_asn_be_pkg.get_asn_data');

Line 1473: FND_LOG.String(

1469: --l_get_genealogy := false;
1470: --idx1 := rslt_tab.count;
1471:
1472: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1473: FND_LOG.String(
1474: LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
1475: MESSAGE => 'Rows in rslt_tab_tmp',
1476: MODULE => 'wsh.plsql.wsh_opsm_asn_be_pkg.get_asn_data');
1477: END IF;

Line 1474: LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

1470: --idx1 := rslt_tab.count;
1471:
1472: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1473: FND_LOG.String(
1474: LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
1475: MESSAGE => 'Rows in rslt_tab_tmp',
1476: MODULE => 'wsh.plsql.wsh_opsm_asn_be_pkg.get_asn_data');
1477: END IF;
1478: IF (rslt_tab_tmp.COUNT > 0) THEN

Line 2098: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2094: p_out_itemgenealogy :=v_itemgenealogy_tab;
2095: IF l_debug_on THEN
2096: WSH_DEBUG_SV.pop(l_module_name);
2097: END IF;
2098: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2099: DECLARE
2100: --l_end_time DATE;
2101: --l_end_time TIMESTAMP;
2102: l_time_diff INTERVAL DAY TO SECOND;

Line 2108: FND_LOG.String(

2104: BEGIN
2105: SELECT SYSTIMESTAMP INTO l_end_time FROM dual;
2106: l_end_timec := TO_CHAR(l_end_time, 'DD-MON-YYYY HH24:MI:SSxFF');
2107:
2108: FND_LOG.String(
2109: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
2110: MESSAGE => 'end time= '||TO_CHAR(l_end_time, 'DD-MON-YYYY HH24:MI:SSxFF'),
2111: MODULE => 'opsmperf.end');
2112:

Line 2109: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

2105: SELECT SYSTIMESTAMP INTO l_end_time FROM dual;
2106: l_end_timec := TO_CHAR(l_end_time, 'DD-MON-YYYY HH24:MI:SSxFF');
2107:
2108: FND_LOG.String(
2109: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
2110: MESSAGE => 'end time= '||TO_CHAR(l_end_time, 'DD-MON-YYYY HH24:MI:SSxFF'),
2111: MODULE => 'opsmperf.end');
2112:
2113: SELECT (l_end_time-l_start_time) INTO l_time_diff FROM dual;

Line 2120: FND_LOG.String(

2116: to_number(extract(minute from l_time_diff)) * 60 +
2117: to_number(extract(hour from l_time_diff)) * 60 * 60 +
2118: to_number(extract(day from l_time_diff)) * 60 * 60* 24;
2119:
2120: FND_LOG.String(
2121: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
2122: MESSAGE => 'time difference= '||l_time_diff_secs,
2123: MODULE => 'opsmperf.end');
2124:

Line 2121: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

2117: to_number(extract(hour from l_time_diff)) * 60 * 60 +
2118: to_number(extract(day from l_time_diff)) * 60 * 60* 24;
2119:
2120: FND_LOG.String(
2121: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
2122: MESSAGE => 'time difference= '||l_time_diff_secs,
2123: MODULE => 'opsmperf.end');
2124:
2125: END;