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

Line 23: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

19: IS
20: l_count number := 0;
21: l_api_name CONSTANT VARCHAR2(30) := 'isTimezoneAlreadyProcessed';
22: BEGIN
23: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
24: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
25: ,'100: Entered isTimezoneAlreadyProcessed');
26: END IF;
27:

Line 24: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

20: l_count number := 0;
21: l_api_name CONSTANT VARCHAR2(30) := 'isTimezoneAlreadyProcessed';
22: BEGIN
23: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
24: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
25: ,'100: Entered isTimezoneAlreadyProcessed');
26: END IF;
27:
28: -- check if the Coverage Times for given timezone id has already been inserted into

Line 38: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

34: where COV_TZE_LINE_ID = cov_timezone_id;
35:
36: -- If Count is greater then 0, return Y
37: IF l_count > 0 THEN
38: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
39: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
40: ,'110: Returning Y');
41: END IF;
42: return 'Y';

Line 39: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

35:
36: -- If Count is greater then 0, return Y
37: IF l_count > 0 THEN
38: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
39: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
40: ,'110: Returning Y');
41: END IF;
42: return 'Y';
43: ELSE

Line 44: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

40: ,'110: Returning Y');
41: END IF;
42: return 'Y';
43: ELSE
44: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
45: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
46: ,'120: Returning N');
47: END IF;
48: return 'N';

Line 45: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

41: END IF;
42: return 'Y';
43: ELSE
44: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
45: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
46: ,'120: Returning N');
47: END IF;
48: return 'N';
49: END IF;

Line 51: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

47: END IF;
48: return 'N';
49: END IF;
50:
51: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
52: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
53: ,'200: Leaving isTimezoneAlreadyProcessed');
54: END IF;
55: END; -- End of isTimezoneAlreadyProcessed

Line 52: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

48: return 'N';
49: END IF;
50:
51: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
52: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
53: ,'200: Leaving isTimezoneAlreadyProcessed');
54: END IF;
55: END; -- End of isTimezoneAlreadyProcessed
56:

Line 70: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

66: ) RETURN VARCHAR2
67: IS
68: l_api_name CONSTANT VARCHAR2(30) := 'intervals_match';
69: BEGIN
70: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
71: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
72: ,'100: Entering intervals_match');
73: END IF;
74:

Line 71: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

67: IS
68: l_api_name CONSTANT VARCHAR2(30) := 'intervals_match';
69: BEGIN
70: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
71: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
72: ,'100: Entering intervals_match');
73: END IF;
74:
75: IF start_time >= cov_start_time AND end_time <= cov_end_time THEN

Line 80: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

76: return 'Y';
77: ELSE
78: return 'N';
79: END IF;
80: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
81: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
82: ,'200: Leaving intervals_match');
83: END IF;
84: END; -- End of intervals_match

Line 81: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

77: ELSE
78: return 'N';
79: END IF;
80: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
81: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
82: ,'200: Leaving intervals_match');
83: END IF;
84: END; -- End of intervals_match
85:

Line 109: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

105: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
106: l_intervals_match_flag VARCHAR2(1) := 'N';
107:
108: BEGIN
109: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
110: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
111: ,'100: Entered process_new_coverage_times');
112: END IF;
113:

Line 110: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

106: l_intervals_match_flag VARCHAR2(1) := 'N';
107:
108: BEGIN
109: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
110: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
111: ,'100: Entered process_new_coverage_times');
112: END IF;
113:
114: -- Loop thru Flattened Start and End Times PL/SQL Table structure

Line 140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

136: -- loop thru coverage_times_recs, identify if the new Start-End Time interval
137: -- exists in the given Coverage Time Interval, If found, process new Coverage
138: -- Times as per the Covered Days in the given Coverage time interval
139: IF coverage_times_recs.COUNT > 0 THEN
140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
141: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,
142: '103: Number of records in coverage_times_recs :'||
143: to_char(coverage_times_recs.COUNT));
144: END IF;

Line 141: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,

137: -- exists in the given Coverage Time Interval, If found, process new Coverage
138: -- Times as per the Covered Days in the given Coverage time interval
139: IF coverage_times_recs.COUNT > 0 THEN
140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
141: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,
142: '103: Number of records in coverage_times_recs :'||
143: to_char(coverage_times_recs.COUNT));
144: END IF;
145: FOR i IN coverage_times_recs.FIRST..coverage_times_recs.LAST LOOP

Line 190: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

186: END IF;
187: -- set return status as success
188: x_return_status := l_return_status;
189:
190: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
191: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
192: ,'200: Leaving process_new_coverage_times');
193: END IF;
194: END; -- END OF process_new_coverage_times

Line 191: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

187: -- set return status as success
188: x_return_status := l_return_status;
189:
190: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
191: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
192: ,'200: Leaving process_new_coverage_times');
193: END IF;
194: END; -- END OF process_new_coverage_times
195:

Line 248: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

244: j PLS_INTEGER := 0;
245: is_timezone_exists VARCHAR2(1) := 'N';
246:
247: BEGIN
248: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
249: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
250: ,'100: Entered init_coverage_times_view');
251: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
252: ,'101: Coverage Time Zone Id'||cov_timezone_id);

Line 249: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

245: is_timezone_exists VARCHAR2(1) := 'N';
246:
247: BEGIN
248: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
249: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
250: ,'100: Entered init_coverage_times_view');
251: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
252: ,'101: Coverage Time Zone Id'||cov_timezone_id);
253: END IF;

Line 251: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

247: BEGIN
248: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
249: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
250: ,'100: Entered init_coverage_times_view');
251: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
252: ,'101: Coverage Time Zone Id'||cov_timezone_id);
253: END IF;
254:
255: -- check if coverage times for the given timezone id is already been

Line 261: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

257: IF isTimezoneAlreadyProcessed(cov_timezone_id) = 'Y' THEN
258: -- set return status as success
259: x_return_status := l_return_status;
260:
261: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
262: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
263: ,'200: Leaving init_coverage_times_view');
264: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
265: ,'201: Coverage Time Zone Id'||cov_timezone_id);

Line 262: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

258: -- set return status as success
259: x_return_status := l_return_status;
260:
261: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
262: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
263: ,'200: Leaving init_coverage_times_view');
264: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
265: ,'201: Coverage Time Zone Id'||cov_timezone_id);
266: END IF;

Line 264: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

260:
261: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
262: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
263: ,'200: Leaving init_coverage_times_view');
264: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
265: ,'201: Coverage Time Zone Id'||cov_timezone_id);
266: END IF;
267: return;
268: END IF;

Line 301: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

297:
298: -- Loop Through Flattened time limits
299: IF flattened_time_limits_recs.COUNT > 0 THEN
300:
301: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
302: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,
303: '103: Number of records in flattened_time_limits_recs :'||to_char(flattened_time_limits_recs.COUNT));
304: END IF;
305:

Line 302: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,

298: -- Loop Through Flattened time limits
299: IF flattened_time_limits_recs.COUNT > 0 THEN
300:
301: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
302: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,
303: '103: Number of records in flattened_time_limits_recs :'||to_char(flattened_time_limits_recs.COUNT));
304: END IF;
305:
306: j := 0;

Line 360: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

356:
357: -- set return status as success
358: x_return_status := l_return_status;
359:
360: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
361: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
362: ,'200: Leaving init_coverage_times_view');
363: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
364: ,'201: Coverage Time Zone Id'||cov_timezone_id);

Line 361: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

357: -- set return status as success
358: x_return_status := l_return_status;
359:
360: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
361: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
362: ,'200: Leaving init_coverage_times_view');
363: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
364: ,'201: Coverage Time Zone Id'||cov_timezone_id);
365: END IF;

Line 363: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

359:
360: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
361: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
362: ,'200: Leaving init_coverage_times_view');
363: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
364: ,'201: Coverage Time Zone Id'||cov_timezone_id);
365: END IF;
366:
367: EXCEPTION

Line 369: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

365: END IF;
366:
367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
370: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'1000: Leaving init_coverage_times_view with G_EXC_ERROR: '||
371: substr(sqlerrm,1,200));
372: END IF;
373: IF flattened_time_limits_cur %ISOPEN THEN

Line 370: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'1000: Leaving init_coverage_times_view with G_EXC_ERROR: '||

366:
367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
370: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'1000: Leaving init_coverage_times_view with G_EXC_ERROR: '||
371: substr(sqlerrm,1,200));
372: END IF;
373: IF flattened_time_limits_cur %ISOPEN THEN
374: CLOSE flattened_time_limits_cur ;

Line 383: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

379: p_data => x_msg_data
380: );
381:
382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
383: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
384: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name
385: ,'1000: Leaving init_coverage_times_view with G_EXC_UNEXPECTED_ERROR :'||substr(sqlerrm,1,200));
386: END IF;
387: IF flattened_time_limits_cur %ISOPEN THEN

Line 384: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name

380: );
381:
382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
383: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
384: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name
385: ,'1000: Leaving init_coverage_times_view with G_EXC_UNEXPECTED_ERROR :'||substr(sqlerrm,1,200));
386: END IF;
387: IF flattened_time_limits_cur %ISOPEN THEN
388: CLOSE flattened_time_limits_cur ;

Line 397: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

393: p_data => x_msg_data
394: );
395:
396: WHEN OTHERS THEN
397: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
398: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,
399: '1000: Leaving init_coverage_times_view with OTHER ERRORS :'||substr(sqlerrm,1,200));
400: END IF;
401: IF flattened_time_limits_cur %ISOPEN THEN

Line 398: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,

394: );
395:
396: WHEN OTHERS THEN
397: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
398: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,
399: '1000: Leaving init_coverage_times_view with OTHER ERRORS :'||substr(sqlerrm,1,200));
400: END IF;
401: IF flattened_time_limits_cur %ISOPEN THEN
402: CLOSE flattened_time_limits_cur ;