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

Line 9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

5:
6: ------------------------------------
7: -- Common constants and variables --
8: ------------------------------------
9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
10: l_log_statement NUMBER := fnd_log.level_statement;
11: l_log_procedure NUMBER := fnd_log.level_procedure;
12: l_log_error NUMBER := fnd_log.level_error;
13: l_log_unexpected NUMBER := fnd_log.level_unexpected;

Line 10: l_log_statement NUMBER := fnd_log.level_statement;

6: ------------------------------------
7: -- Common constants and variables --
8: ------------------------------------
9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
10: l_log_statement NUMBER := fnd_log.level_statement;
11: l_log_procedure NUMBER := fnd_log.level_procedure;
12: l_log_error NUMBER := fnd_log.level_error;
13: l_log_unexpected NUMBER := fnd_log.level_unexpected;
14: l_remaining_counter NUMBER := 3;

Line 11: l_log_procedure NUMBER := fnd_log.level_procedure;

7: -- Common constants and variables --
8: ------------------------------------
9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
10: l_log_statement NUMBER := fnd_log.level_statement;
11: l_log_procedure NUMBER := fnd_log.level_procedure;
12: l_log_error NUMBER := fnd_log.level_error;
13: l_log_unexpected NUMBER := fnd_log.level_unexpected;
14: l_remaining_counter NUMBER := 3;
15: l_since_repair_counter NUMBER := 3;

Line 12: l_log_error NUMBER := fnd_log.level_error;

8: ------------------------------------
9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
10: l_log_statement NUMBER := fnd_log.level_statement;
11: l_log_procedure NUMBER := fnd_log.level_procedure;
12: l_log_error NUMBER := fnd_log.level_error;
13: l_log_unexpected NUMBER := fnd_log.level_unexpected;
14: l_remaining_counter NUMBER := 3;
15: l_since_repair_counter NUMBER := 3;
16: l_spec_limit_counter NUMBER := 3;

Line 13: l_log_unexpected NUMBER := fnd_log.level_unexpected;

9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
10: l_log_statement NUMBER := fnd_log.level_statement;
11: l_log_procedure NUMBER := fnd_log.level_procedure;
12: l_log_error NUMBER := fnd_log.level_error;
13: l_log_unexpected NUMBER := fnd_log.level_unexpected;
14: l_remaining_counter NUMBER := 3;
15: l_since_repair_counter NUMBER := 3;
16: l_spec_limit_counter NUMBER := 3;
17: l_program_subtype NUMBER := 10;

Line 58: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

54:
55:
56:
57: BEGIN
58: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
59: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');
60: END IF;
61:
62: IF (l_log_statement >= l_log_current_level) THEN

Line 59: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');

55:
56:
57: BEGIN
58: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
59: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');
60: END IF;
61:
62: IF (l_log_statement >= l_log_current_level) THEN
63: fnd_log.string(l_log_statement,

Line 63: fnd_log.string(l_log_statement,

59: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');
60: END IF;
61:
62: IF (l_log_statement >= l_log_current_level) THEN
63: fnd_log.string(l_log_statement,
64: L_DEBUG,
65: 'Instance Id = ' || P_INSTANCE_ID ||'Program subtype = ' || P_MR_PGM_SUB_TYPE);
66: END IF;
67: OPEN c_get_ue_id(p_instance_id, p_mr_pgm_sub_type);

Line 71: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

67: OPEN c_get_ue_id(p_instance_id, p_mr_pgm_sub_type);
68: FETCH c_get_ue_id INTO l_get_ue_id;
69: CLOSE c_get_ue_id;
70:
71: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
72: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
73: END IF;
74:
75: RETURN l_get_ue_id;

Line 72: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');

68: FETCH c_get_ue_id INTO l_get_ue_id;
69: CLOSE c_get_ue_id;
70:
71: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
72: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
73: END IF;
74:
75: RETURN l_get_ue_id;
76: END Get_Restrictive_UE;

Line 117: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

113: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
114: L_DEBUG CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;
115:
116: BEGIN
117: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
118: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');
119: END IF;
120:
121: IF (l_log_statement >= l_log_current_level) THEN

Line 118: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');

114: L_DEBUG CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;
115:
116: BEGIN
117: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
118: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');
119: END IF;
120:
121: IF (l_log_statement >= l_log_current_level) THEN
122: fnd_log.string(l_log_statement,

Line 122: fnd_log.string(l_log_statement,

118: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');
119: END IF;
120:
121: IF (l_log_statement >= l_log_current_level) THEN
122: fnd_log.string(l_log_statement,
123: L_DEBUG,'Instance Id = ' || P_INSTANCE_ID);
124: END IF;
125:
126: OPEN c_get_ue_id(p_instance_id);

Line 130: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

126: OPEN c_get_ue_id(p_instance_id);
127: FETCH c_get_ue_id INTO l_get_ue_id;
128: CLOSE c_get_ue_id;
129:
130: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
131: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
132: END IF;
133:
134: RETURN l_get_ue_id;

Line 131: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');

127: FETCH c_get_ue_id INTO l_get_ue_id;
128: CLOSE c_get_ue_id;
129:
130: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
131: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
132: END IF;
133:
134: RETURN l_get_ue_id;
135: END Get_Restrictive_UE_CRF;

Line 186: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

182: L_DEBUG CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;
183:
184:
185: BEGIN
186: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
187: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function' || 'UE id is:'||P_UE_ID || 'counter_index is: '||p_counter_index);
188: END IF;
189:
190: OPEN c_get_counter_id(p_counter_index, p_report_name);

Line 187: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function' || 'UE id is:'||P_UE_ID || 'counter_index is: '||p_counter_index);

183:
184:
185: BEGIN
186: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
187: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function' || 'UE id is:'||P_UE_ID || 'counter_index is: '||p_counter_index);
188: END IF;
189:
190: OPEN c_get_counter_id(p_counter_index, p_report_name);
191: FETCH c_get_counter_id INTO l_counter_id;

Line 215: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

211: --When fetched uom matches with passed uom, get the difference of due counter value and net reading
212: l_get_rem_uom := l_due_counter_value - l_net_reading;
213: END IF;
214:
215: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
216: fnd_log.string(fnd_log.level_procedure,L_DEBUG,'Remaining UOM is '||l_get_rem_uom);
217: END IF;
218:
219: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 216: fnd_log.string(fnd_log.level_procedure,L_DEBUG,'Remaining UOM is '||l_get_rem_uom);

212: l_get_rem_uom := l_due_counter_value - l_net_reading;
213: END IF;
214:
215: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
216: fnd_log.string(fnd_log.level_procedure,L_DEBUG,'Remaining UOM is '||l_get_rem_uom);
217: END IF;
218:
219: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
220: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');

Line 219: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

215: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
216: fnd_log.string(fnd_log.level_procedure,L_DEBUG,'Remaining UOM is '||l_get_rem_uom);
217: END IF;
218:
219: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
220: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
221: END IF;
222: RETURN l_get_rem_uom;
223:

Line 220: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');

216: fnd_log.string(fnd_log.level_procedure,L_DEBUG,'Remaining UOM is '||l_get_rem_uom);
217: END IF;
218:
219: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
220: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
221: END IF;
222: RETURN l_get_rem_uom;
223:
224: END Get_Remaining_Counter_UOM;

Line 276: IF( fnd_log.level_procedure >= fnd_log.g_current_runtime_level ) THEN

272: l_speclimit_counter_value NUMBER;
273: --
274: BEGIN
275:
276: IF( fnd_log.level_procedure >= fnd_log.g_current_runtime_level ) THEN
277: fnd_log.string(fnd_log.level_procedure, l_debug || '.begin', 'At the start of function');
278: fnd_log.string(fnd_log.level_procedure, l_debug, 'UE id is:' || p_ue_id || ' Counter_index is: ' || p_counter_index);
279: END IF;
280:

Line 277: fnd_log.string(fnd_log.level_procedure, l_debug || '.begin', 'At the start of function');

273: --
274: BEGIN
275:
276: IF( fnd_log.level_procedure >= fnd_log.g_current_runtime_level ) THEN
277: fnd_log.string(fnd_log.level_procedure, l_debug || '.begin', 'At the start of function');
278: fnd_log.string(fnd_log.level_procedure, l_debug, 'UE id is:' || p_ue_id || ' Counter_index is: ' || p_counter_index);
279: END IF;
280:
281: -- get the counter id from AHL_PARAMETERS

Line 278: fnd_log.string(fnd_log.level_procedure, l_debug, 'UE id is:' || p_ue_id || ' Counter_index is: ' || p_counter_index);

274: BEGIN
275:
276: IF( fnd_log.level_procedure >= fnd_log.g_current_runtime_level ) THEN
277: fnd_log.string(fnd_log.level_procedure, l_debug || '.begin', 'At the start of function');
278: fnd_log.string(fnd_log.level_procedure, l_debug, 'UE id is:' || p_ue_id || ' Counter_index is: ' || p_counter_index);
279: END IF;
280:
281: -- get the counter id from AHL_PARAMETERS
282: OPEN c_get_counter_id (p_counter_index);

Line 301: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

297: ELSE
298: CLOSE c_get_speclimit_counter_value;
299: END IF;
300:
301: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
302: fnd_log.string(fnd_log.level_procedure, l_debug, 'Spec Limit Counter value is ' || l_speclimit_counter_value);
303: END IF;
304:
305: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 302: fnd_log.string(fnd_log.level_procedure, l_debug, 'Spec Limit Counter value is ' || l_speclimit_counter_value);

298: CLOSE c_get_speclimit_counter_value;
299: END IF;
300:
301: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
302: fnd_log.string(fnd_log.level_procedure, l_debug, 'Spec Limit Counter value is ' || l_speclimit_counter_value);
303: END IF;
304:
305: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
306: fnd_log.string(fnd_log.level_procedure, l_debug || '.end', 'At the end of function');

Line 305: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

301: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
302: fnd_log.string(fnd_log.level_procedure, l_debug, 'Spec Limit Counter value is ' || l_speclimit_counter_value);
303: END IF;
304:
305: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
306: fnd_log.string(fnd_log.level_procedure, l_debug || '.end', 'At the end of function');
307: END IF;
308:
309: RETURN l_speclimit_counter_value;

Line 306: fnd_log.string(fnd_log.level_procedure, l_debug || '.end', 'At the end of function');

302: fnd_log.string(fnd_log.level_procedure, l_debug, 'Spec Limit Counter value is ' || l_speclimit_counter_value);
303: END IF;
304:
305: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
306: fnd_log.string(fnd_log.level_procedure, l_debug || '.end', 'At the end of function');
307: END IF;
308:
309: RETURN l_speclimit_counter_value;
310: END Get_SpecLimit_Counter_Value;

Line 388: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

384: L_DEBUG CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;
385:
386:
387: BEGIN
388: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
389: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function' || 'Instance id:'||p_item_instance_id ||'counter_index is:' ||p_counter_index);
390: END IF;
391:
392: OPEN c_get_counter_id(p_counter_index);

Line 389: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function' || 'Instance id:'||p_item_instance_id ||'counter_index is:' ||p_counter_index);

385:
386:
387: BEGIN
388: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
389: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function' || 'Instance id:'||p_item_instance_id ||'counter_index is:' ||p_counter_index);
390: END IF;
391:
392: OPEN c_get_counter_id(p_counter_index);
393: FETCH c_get_counter_id INTO l_counter_id;

Line 428: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

424: --When fetched uom matches with passed uom, get the difference of accomplished counter value and net reading
425: l_get_since_repair_reading := l_current_reading - l_last_reading;
426: END IF;
427:
428: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
429: fnd_log.string(fnd_log.level_procedure,L_DEBUG,'Since Repair Reading is '|| l_get_since_repair_reading);
430: END IF;
431:
432: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 429: fnd_log.string(fnd_log.level_procedure,L_DEBUG,'Since Repair Reading is '|| l_get_since_repair_reading);

425: l_get_since_repair_reading := l_current_reading - l_last_reading;
426: END IF;
427:
428: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
429: fnd_log.string(fnd_log.level_procedure,L_DEBUG,'Since Repair Reading is '|| l_get_since_repair_reading);
430: END IF;
431:
432: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
433: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');

Line 432: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

428: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
429: fnd_log.string(fnd_log.level_procedure,L_DEBUG,'Since Repair Reading is '|| l_get_since_repair_reading);
430: END IF;
431:
432: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
433: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
434: END IF;
435: RETURN l_get_since_repair_reading;
436:

Line 433: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');

429: fnd_log.string(fnd_log.level_procedure,L_DEBUG,'Since Repair Reading is '|| l_get_since_repair_reading);
430: END IF;
431:
432: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
433: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
434: END IF;
435: RETURN l_get_since_repair_reading;
436:
437: END Get_Since_Repair_Reading;

Line 468: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

464: L_DEBUG CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;
465:
466:
467: BEGIN
468: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
469: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');
470: END IF;
471:
472: IF (l_log_statement >= l_log_current_level) THEN

Line 469: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');

465:
466:
467: BEGIN
468: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
469: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');
470: END IF;
471:
472: IF (l_log_statement >= l_log_current_level) THEN
473: fnd_log.string(l_log_statement,

Line 473: fnd_log.string(l_log_statement,

469: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');
470: END IF;
471:
472: IF (l_log_statement >= l_log_current_level) THEN
473: fnd_log.string(l_log_statement,
474: L_DEBUG,
475: 'Instance Id = ' || P_INSTANCE_ID);
476: END IF;
477: OPEN c_get_count(p_instance_id);

Line 482: fnd_log.string(l_log_statement,L_DEBUG,'Count is = ' || l_get_count);

478: FETCH c_get_count INTO l_get_count;
479: CLOSE c_get_count;
480:
481: IF (l_log_statement >= l_log_current_level) THEN
482: fnd_log.string(l_log_statement,L_DEBUG,'Count is = ' || l_get_count);
483: END IF;
484: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
485: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
486: END IF;

Line 484: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

480:
481: IF (l_log_statement >= l_log_current_level) THEN
482: fnd_log.string(l_log_statement,L_DEBUG,'Count is = ' || l_get_count);
483: END IF;
484: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
485: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
486: END IF;
487:
488: RETURN l_get_count;

Line 485: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');

481: IF (l_log_statement >= l_log_current_level) THEN
482: fnd_log.string(l_log_statement,L_DEBUG,'Count is = ' || l_get_count);
483: END IF;
484: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
485: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
486: END IF;
487:
488: RETURN l_get_count;
489: END Get_Item_Group_Count;

Line 536: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

532: L_DEBUG CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;
533:
534:
535: BEGIN
536: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
537: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');
538: END IF;
539:
540: IF (l_log_statement >= l_log_current_level) THEN

Line 537: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');

533:
534:
535: BEGIN
536: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
537: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');
538: END IF;
539:
540: IF (l_log_statement >= l_log_current_level) THEN
541: fnd_log.string(l_log_statement,

Line 541: fnd_log.string(l_log_statement,

537: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');
538: END IF;
539:
540: IF (l_log_statement >= l_log_current_level) THEN
541: fnd_log.string(l_log_statement,
542: L_DEBUG,
543: 'Instance Id = ' || P_INSTANCE_ID);
544: END IF;
545: OPEN c_get_first_instance(p_instance_id);

Line 550: fnd_log.string(l_log_statement,L_DEBUG,'instance id is = ' || l_get_first_instance);

546: FETCH c_get_first_instance INTO l_get_first_instance;
547: CLOSE c_get_first_instance;
548:
549: IF (l_log_statement >= l_log_current_level) THEN
550: fnd_log.string(l_log_statement,L_DEBUG,'instance id is = ' || l_get_first_instance);
551: END IF;
552: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
553: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
554: END IF;

Line 552: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

548:
549: IF (l_log_statement >= l_log_current_level) THEN
550: fnd_log.string(l_log_statement,L_DEBUG,'instance id is = ' || l_get_first_instance);
551: END IF;
552: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
553: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
554: END IF;
555:
556: RETURN l_get_first_instance;

Line 553: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');

549: IF (l_log_statement >= l_log_current_level) THEN
550: fnd_log.string(l_log_statement,L_DEBUG,'instance id is = ' || l_get_first_instance);
551: END IF;
552: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
553: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
554: END IF;
555:
556: RETURN l_get_first_instance;
557: END Get_First_Instance;

Line 592: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

588: L_DEBUG CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;
589:
590:
591: BEGIN
592: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
593: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');
594: END IF;
595:
596: IF (l_log_statement >= l_log_current_level) THEN

Line 593: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');

589:
590:
591: BEGIN
592: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
593: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');
594: END IF;
595:
596: IF (l_log_statement >= l_log_current_level) THEN
597: fnd_log.string(l_log_statement,

Line 597: fnd_log.string(l_log_statement,

593: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of function');
594: END IF;
595:
596: IF (l_log_statement >= l_log_current_level) THEN
597: fnd_log.string(l_log_statement,
598: L_DEBUG,
599: 'Instance Id = ' || P_INSTANCE_ID);
600: END IF;
601: OPEN c_get_root_instance(p_instance_id);

Line 606: fnd_log.string(l_log_statement,L_DEBUG,'Instance id returned is = ' || l_get_root_instance);

602: FETCH c_get_root_instance INTO l_get_root_instance;
603: CLOSE c_get_root_instance;
604:
605: IF (l_log_statement >= l_log_current_level) THEN
606: fnd_log.string(l_log_statement,L_DEBUG,'Instance id returned is = ' || l_get_root_instance);
607: END IF;
608: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
609: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
610: END IF;

Line 608: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

604:
605: IF (l_log_statement >= l_log_current_level) THEN
606: fnd_log.string(l_log_statement,L_DEBUG,'Instance id returned is = ' || l_get_root_instance);
607: END IF;
608: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
609: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
610: END IF;
611:
612: RETURN l_get_root_instance;

Line 609: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');

605: IF (l_log_statement >= l_log_current_level) THEN
606: fnd_log.string(l_log_statement,L_DEBUG,'Instance id returned is = ' || l_get_root_instance);
607: END IF;
608: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
609: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of function');
610: END IF;
611:
612: RETURN l_get_root_instance;
613: END Get_Root_Instance;

Line 682: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

678:
679: --------------------- Initialize -----------------------
680: SAVEPOINT Insert_Rem_Counters;
681:
682: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
683: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');
684: END IF;
685:
686: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 683: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');

679: --------------------- Initialize -----------------------
680: SAVEPOINT Insert_Rem_Counters;
681:
682: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
683: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');
684: END IF;
685:
686: -- Initialize message list if p_init_msg_list is set to TRUE.
687: IF Fnd_Api.to_boolean(p_init_msg_list) THEN

Line 707: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

703:
704: IF p_rem_counter_tbl.COUNT > 0 THEN
705: FOR i IN p_rem_counter_tbl.first..p_rem_counter_tbl.LAST
706: LOOP
707: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
708: fnd_log.string(fnd_log.level_statement,L_DEBUG,'p_rem_counter_tbl(i).PARAMETER_ID : '||p_rem_counter_tbl(i).PARAMETER_ID);
709: fnd_log.string(fnd_log.level_statement,L_DEBUG,'p_rem_counter_tbl(i).counter_parameter_value : '||p_rem_counter_tbl(i).counter_parameter_value);
710: END IF;
711:

Line 708: fnd_log.string(fnd_log.level_statement,L_DEBUG,'p_rem_counter_tbl(i).PARAMETER_ID : '||p_rem_counter_tbl(i).PARAMETER_ID);

704: IF p_rem_counter_tbl.COUNT > 0 THEN
705: FOR i IN p_rem_counter_tbl.first..p_rem_counter_tbl.LAST
706: LOOP
707: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
708: fnd_log.string(fnd_log.level_statement,L_DEBUG,'p_rem_counter_tbl(i).PARAMETER_ID : '||p_rem_counter_tbl(i).PARAMETER_ID);
709: fnd_log.string(fnd_log.level_statement,L_DEBUG,'p_rem_counter_tbl(i).counter_parameter_value : '||p_rem_counter_tbl(i).counter_parameter_value);
710: END IF;
711:
712: IF p_rem_counter_tbl(i).PARAMETER_ID IS NOT NULL THEN

Line 709: fnd_log.string(fnd_log.level_statement,L_DEBUG,'p_rem_counter_tbl(i).counter_parameter_value : '||p_rem_counter_tbl(i).counter_parameter_value);

705: FOR i IN p_rem_counter_tbl.first..p_rem_counter_tbl.LAST
706: LOOP
707: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
708: fnd_log.string(fnd_log.level_statement,L_DEBUG,'p_rem_counter_tbl(i).PARAMETER_ID : '||p_rem_counter_tbl(i).PARAMETER_ID);
709: fnd_log.string(fnd_log.level_statement,L_DEBUG,'p_rem_counter_tbl(i).counter_parameter_value : '||p_rem_counter_tbl(i).counter_parameter_value);
710: END IF;
711:
712: IF p_rem_counter_tbl(i).PARAMETER_ID IS NOT NULL THEN
713:

Line 786: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

782: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
783: COMMIT;
784: END IF;
785:
786: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
787: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of PLSQL procedure');
788: END IF;
789: EXCEPTION
790: WHEN Fnd_Api.g_exc_error THEN

Line 787: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of PLSQL procedure');

783: COMMIT;
784: END IF;
785:
786: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
787: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of PLSQL procedure');
788: END IF;
789: EXCEPTION
790: WHEN Fnd_Api.g_exc_error THEN
791: ROLLBACK TO Insert_Rem_Counters;

Line 879: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

875:
876: BEGIN
877: --------------------- Initialize -----------------------
878:
879: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
880: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');
881: END IF;
882:
883: OPEN c_record_exists('CRF','SINCE_REP_COUNTER_%');

Line 880: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');

876: BEGIN
877: --------------------- Initialize -----------------------
878:
879: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
880: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');
881: END IF;
882:
883: OPEN c_record_exists('CRF','SINCE_REP_COUNTER_%');
884: FETCH c_record_exists INTO l_get_count;