[Home] [Help]
PACKAGE BODY: APPS.CSI_CTR_GEN_UTILITY_PVT
Source
4 -- G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_CTR_GEN_UTILITY_PVT';
1 PACKAGE BODY CSI_CTR_GEN_UTILITY_PVT AS
2 /* $Header: csivctub.pls 120.9.12020000.2 2012/10/16 05:00:12 dsingire ship $ */
3
5 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csivctub.pls';
6
7 FUNCTION G_MISS_NUM RETURN NUMBER IS
8 BEGIN
9 RETURN FND_API.G_MISS_NUM ;
10 END G_MISS_NUM ;
11
12
13 FUNCTION G_MISS_CHAR RETURN VARCHAR2 IS
14 BEGIN
15 RETURN FND_API.G_MISS_CHAR ;
16 END G_MISS_CHAR ;
17
18
19 FUNCTION G_MISS_DATE RETURN DATE IS
20 BEGIN
21 RETURN FND_API.G_MISS_DATE ;
22 END G_MISS_DATE ;
23
24
25 PROCEDURE read_debug_profiles IS
26 BEGIN
27 g_debug_level := fnd_profile.value('CSI_DEBUG_LEVEL');
28 g_debug_file := fnd_profile.value('CSI_LOGFILE_NAME');
29 g_debug_file_path := fnd_profile.value('CSI_LOGFILE_PATH');
30 g_stop_on_debug_error := fnd_profile.value('CSI_STOP_AT_DEBUG_ERROR');
31 END read_debug_profiles;
32
33 PROCEDURE put_line(p_message IN VARCHAR2)
34 IS
35 l_message VARCHAR2(4000);
36 l_sid NUMBER;
37 l_os_user VARCHAR2(30);
38 l_file_handle utl_file.file_type;
39
40 -- l_log_file VARCHAR2(30) := fnd_profile.value('CSI_LOGFILE_NAME'); -- Bug 7197402
41 -- l_log_file_path VARCHAR2(240) := fnd_profile.value('CSI_LOGFILE_PATH'); -- Bug 7197402
42 -- l_stop_on_debug_error VARCHAR2(10) := fnd_profile.value('CSI_STOP_AT_DEBUG_ERROR'); -- Bug 7197402
43
44 -- l_debug_level NUMBER := fnd_profile.value('CSI_DEBUG_LEVEL'); -- Bug 7197402
45 l_log_file VARCHAR2(30);
46 l_instr NUMBER;
47 BEGIN
48 -- Added for the bug 7197402
49 IF (g_debug_level is null) THEN
50 read_debug_profiles;
51 END IF;
52
53 IF (g_debug_level > 0) THEN
54 IF g_sid is NULL THEN
55 SELECT sid, osuser
56 INTO l_sid, l_os_user
57 FROM v$session
58 WHERE audsid = (SELECT userenv('SESSIONID') FROM dual);
62 END IF;
59 --
60 g_sid := l_sid;
61 g_osuser := l_os_user;
63
64 l_message := g_osuser||'-'||g_sid||'-'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'-'||p_message;
65
66 BEGIN
67 SELECT instr(g_debug_file,'.')
68 INTO l_instr
69 FROM dual;
70 EXCEPTION
71 WHEN OTHERS THEN
72 l_instr := 0;
73 END;
74
75 IF l_instr = 0 THEN
76 l_log_file := g_debug_file||'-counter';
77 ELSE
78 BEGIN
79 SELECT substr(g_debug_file,1,l_instr-1)||'-counter'||substr(g_debug_file,l_instr)
80 INTO l_log_file
81 FROM dual;
82 EXCEPTION
83 WHEN OTHERS THEN
84 null;
85 END;
86 END IF;
87
88 l_file_handle := UTL_FILE.FOPEN(g_debug_file_path, l_log_file, 'a');
89 UTL_FILE.PUT_LINE (l_file_handle, l_message);
90 UTL_FILE.FFLUSH(l_file_handle);
91 UTL_FILE.FCLOSE(l_file_handle);
92 END IF;
93 EXCEPTION
94 WHEN UTL_FILE.INVALID_PATH THEN
95 FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_INVALID_PATH');
96 FND_MSG_PUB.ADD;
97
98 IF (g_stop_on_debug_error = 'Y') THEN
99 RAISE FND_API.G_EXC_ERROR;
100 END IF;
101
102 WHEN UTL_FILE.INVALID_MODE THEN
103 FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_INVALID_MODE');
104 FND_MSG_PUB.ADD;
105 IF (g_stop_on_debug_error = 'Y') THEN
106 RAISE FND_API.G_EXC_ERROR;
107 END IF;
108
109 WHEN UTL_FILE.INVALID_FILEHANDLE THEN
110 FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_INVALID_FILEHANDLE');
111 FND_MSG_PUB.ADD;
112 IF (g_stop_on_debug_error = 'Y') THEN
113 RAISE FND_API.G_EXC_ERROR;
114 END IF;
115
116 WHEN UTL_FILE.INVALID_OPERATION THEN
117 FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_INVALID_OPERATION');
118 FND_MSG_PUB.ADD;
119 IF (g_stop_on_debug_error = 'Y') THEN
120 RAISE FND_API.G_EXC_ERROR;
121 END IF;
122
123 WHEN UTL_FILE.WRITE_ERROR THEN
124 FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_WRITE_ERROR');
125 FND_MSG_PUB.ADD;
126 IF (g_stop_on_debug_error = 'Y') THEN
127 RAISE FND_API.G_EXC_ERROR;
128 END IF;
129
130 WHEN OTHERS THEN
131 FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_PUT_LINE_ERROR');
132 FND_MSG_PUB.ADD;
133 IF (g_stop_on_debug_error = 'Y') THEN
134 RAISE FND_API.G_EXC_ERROR;
135 END IF;
136 END put_line;
137
138 Procedure ExitWithErrMsg
139 ( p_msg_name in varchar2,
140 p_token1_name in varchar2 := null,
141 p_token1_val in varchar2 := null,
142 p_token2_name in varchar2 := null,
143 p_token2_val in varchar2 := null,
144 p_token3_name in varchar2 := null,
145 p_token3_val in varchar2 := null,
146 p_token4_name in varchar2 := null,
147 p_token4_val in varchar2 := null
148 ) IS
149 BEGIN
150 FND_MESSAGE.SET_NAME('CSI',p_msg_name);
151 IF p_token1_name is not null then
152 FND_MESSAGE.SET_TOKEN(p_token1_name, p_token1_val);
153 END IF;
154
155 IF p_token2_name is not null then
156 FND_MESSAGE.SET_TOKEN(p_token2_name, p_token2_val);
157 END IF;
158
159 IF p_token3_name is not null then
160 FND_MESSAGE.SET_TOKEN(p_token3_name, p_token3_val);
161 END IF;
162
163 IF p_token4_name is not null then
164 FND_MESSAGE.SET_TOKEN(p_token4_name, p_token4_val);
165 END IF;
166 --
167
168 FND_MSG_PUB.Add;
169 RAISE FND_API.G_EXC_ERROR;
170 END ExitWithErrMsg;
171
172 PROCEDURE Initialize_Desc_Flex
173 ( p_desc_flex IN OUT NOCOPY csi_ctr_datastructures_pub.dff_rec_type
174 ) IS
175
176 BEGIN
177 IF p_desc_flex.attribute_category = FND_API.G_MISS_CHAR THEN
178 p_desc_flex.attribute_category := NULL;
179 ELSE
180 p_desc_flex.attribute_category := p_desc_flex.attribute_category;
181 END IF;
182
183 IF p_desc_flex.attribute1 = FND_API.G_MISS_CHAR THEN
184 p_desc_flex.attribute1 := NULL;
185 ELSE
186 p_desc_flex.attribute1 := p_desc_flex.attribute1;
187 END IF;
188
189 IF p_desc_flex.attribute2 = FND_API.G_MISS_CHAR THEN
190 p_desc_flex.attribute2 := NULL;
191 ELSE
192 p_desc_flex.attribute2 := p_desc_flex.attribute2;
193 END IF;
194
195 IF p_desc_flex.attribute3 = FND_API.G_MISS_CHAR THEN
196 p_desc_flex.attribute3 := NULL;
197 ELSE
198 p_desc_flex.attribute3 := p_desc_flex.attribute3;
199 END IF;
200
201 IF p_desc_flex.attribute4 = FND_API.G_MISS_CHAR THEN
202 p_desc_flex.attribute4 := NULL;
203 ELSE
204 p_desc_flex.attribute4 := p_desc_flex.attribute4;
205 END IF;
206
207 IF p_desc_flex.attribute5 = FND_API.G_MISS_CHAR THEN
208 p_desc_flex.attribute5 := NULL;
209 ELSE
210 p_desc_flex.attribute5 := p_desc_flex.attribute5;
211 END IF;
212
213 IF p_desc_flex.attribute6 = FND_API.G_MISS_CHAR THEN
214 p_desc_flex.attribute6 := NULL;
215 ELSE
216 p_desc_flex.attribute6 := p_desc_flex.attribute6;
217 END IF;
218
219 IF p_desc_flex.attribute7 = FND_API.G_MISS_CHAR THEN
220 p_desc_flex.attribute7 := NULL;
221 ELSE
225 IF p_desc_flex.attribute8 = FND_API.G_MISS_CHAR THEN
222 p_desc_flex.attribute7 := p_desc_flex.attribute7;
223 END IF;
224
226 p_desc_flex.attribute8 := NULL;
227 ELSE
228 p_desc_flex.attribute8 := p_desc_flex.attribute8;
229 END IF;
230
231 IF p_desc_flex.attribute9 = FND_API.G_MISS_CHAR THEN
232 p_desc_flex.attribute9 := NULL;
233 ELSE
234 p_desc_flex.attribute9 := p_desc_flex.attribute9;
235 END IF;
236
237 IF p_desc_flex.attribute10 = FND_API.G_MISS_CHAR THEN
238 p_desc_flex.attribute10 := NULL;
239 ELSE
240 p_desc_flex.attribute10 := p_desc_flex.attribute10;
241 END IF;
242
243 IF p_desc_flex.attribute11 = FND_API.G_MISS_CHAR THEN
244 p_desc_flex.attribute11 := NULL;
245 ELSE
246 p_desc_flex.attribute11 := p_desc_flex.attribute11;
247 END IF;
248
249 IF p_desc_flex.attribute12 = FND_API.G_MISS_CHAR THEN
250 p_desc_flex.attribute12 := NULL;
251 ELSE
252 p_desc_flex.attribute12 := p_desc_flex.attribute12;
253 END IF;
254
255 IF p_desc_flex.attribute13 = FND_API.G_MISS_CHAR THEN
256 p_desc_flex.attribute13 := NULL;
257 ELSE
258 p_desc_flex.attribute13 := p_desc_flex.attribute13;
259 END IF;
260
261 IF p_desc_flex.attribute14 = FND_API.G_MISS_CHAR THEN
262 p_desc_flex.attribute14 := NULL;
263 ELSE
264 p_desc_flex.attribute14 := p_desc_flex.attribute14;
265 END IF;
266
267 IF p_desc_flex.attribute15 = FND_API.G_MISS_CHAR THEN
268 p_desc_flex.attribute15 := NULL;
269 ELSE
270 p_desc_flex.attribute15 := p_desc_flex.attribute15;
271 END IF;
272
273 IF p_desc_flex.attribute16 = FND_API.G_MISS_CHAR THEN
274 p_desc_flex.attribute16 := NULL;
275 ELSE
276 p_desc_flex.attribute16 := p_desc_flex.attribute16;
277 END IF;
278
279 IF p_desc_flex.attribute17 = FND_API.G_MISS_CHAR THEN
280 p_desc_flex.attribute17 := NULL;
281 ELSE
282 p_desc_flex.attribute17 := p_desc_flex.attribute17;
283 END IF;
284
285 IF p_desc_flex.attribute18 = FND_API.G_MISS_CHAR THEN
286 p_desc_flex.attribute18 := NULL;
287 ELSE
288 p_desc_flex.attribute18 := p_desc_flex.attribute18;
289 END IF;
290
291 IF p_desc_flex.attribute19 = FND_API.G_MISS_CHAR THEN
292 p_desc_flex.attribute19 := NULL;
293 ELSE
294 p_desc_flex.attribute19 := p_desc_flex.attribute19;
295 END IF;
296
297 IF p_desc_flex.attribute20 = FND_API.G_MISS_CHAR THEN
298 p_desc_flex.attribute20 := NULL;
299 ELSE
300 p_desc_flex.attribute20 := p_desc_flex.attribute20;
301 END IF;
302
303 IF p_desc_flex.attribute21 = FND_API.G_MISS_CHAR THEN
304 p_desc_flex.attribute21 := NULL;
305 ELSE
306 p_desc_flex.attribute21 := p_desc_flex.attribute21;
307 END IF;
308
309 IF p_desc_flex.attribute22 = FND_API.G_MISS_CHAR THEN
310 p_desc_flex.attribute22 := NULL;
311 ELSE
312 p_desc_flex.attribute22 := p_desc_flex.attribute22;
313 END IF;
314
315 IF p_desc_flex.attribute23 = FND_API.G_MISS_CHAR THEN
316 p_desc_flex.attribute23 := NULL;
317 ELSE
318 p_desc_flex.attribute23 := p_desc_flex.attribute23;
319 END IF;
320
321 IF p_desc_flex.attribute24 = FND_API.G_MISS_CHAR THEN
322 p_desc_flex.attribute24 := NULL;
323 ELSE
324 p_desc_flex.attribute24 := p_desc_flex.attribute24;
325 END IF;
326
327 IF p_desc_flex.attribute25 = FND_API.G_MISS_CHAR THEN
328 p_desc_flex.attribute25 := NULL;
329 ELSE
330 p_desc_flex.attribute25 := p_desc_flex.attribute25;
331 END IF;
332
333 IF p_desc_flex.attribute26 = FND_API.G_MISS_CHAR THEN
334 p_desc_flex.attribute26 := NULL;
335 ELSE
336 p_desc_flex.attribute26 := p_desc_flex.attribute26;
337 END IF;
338
339 IF p_desc_flex.attribute27 = FND_API.G_MISS_CHAR THEN
340 p_desc_flex.attribute27 := NULL;
341 ELSE
342 p_desc_flex.attribute27 := p_desc_flex.attribute27;
343 END IF;
344
345 IF p_desc_flex.attribute28 = FND_API.G_MISS_CHAR THEN
346 p_desc_flex.attribute28 := NULL;
347 ELSE
348 p_desc_flex.attribute28 := p_desc_flex.attribute28;
349 END IF;
350
351 IF p_desc_flex.attribute29 = FND_API.G_MISS_CHAR THEN
352 p_desc_flex.attribute29 := NULL;
353 ELSE
354 p_desc_flex.attribute29 := p_desc_flex.attribute29;
355 END IF;
356
357 IF p_desc_flex.attribute30 = FND_API.G_MISS_CHAR THEN
358 p_desc_flex.attribute30 := NULL;
359 ELSE
360 p_desc_flex.attribute30 := p_desc_flex.attribute30;
361 END IF;
362 END Initialize_Desc_Flex;
363
364 PROCEDURE Is_DescFlex_Valid
365 (
366 p_api_name IN VARCHAR2,
367 p_appl_short_name IN VARCHAR2 := 'CSI',
368 p_desc_flex_name IN VARCHAR2,
369 p_seg_partial_name IN VARCHAR2,
370 p_num_of_attributes IN NUMBER,
371 p_seg_values IN csi_ctr_datastructures_pub.dff_rec_type,
372 p_stack_err_msg IN BOOLEAN := TRUE
373 ) IS
374
375 p_desc_context VARCHAR2(30);
376 p_desc_col_name1 VARCHAR2(30) := p_seg_partial_name||'1';
377 p_desc_col_name2 VARCHAR2(30) := p_seg_partial_name||'2';
378 p_desc_col_name3 VARCHAR2(30) := p_seg_partial_name||'3';
382 p_desc_col_name7 VARCHAR2(30) := p_seg_partial_name||'7';
379 p_desc_col_name4 VARCHAR2(30) := p_seg_partial_name||'4';
380 p_desc_col_name5 VARCHAR2(30) := p_seg_partial_name||'5';
381 p_desc_col_name6 VARCHAR2(30) := p_seg_partial_name||'6';
383 p_desc_col_name8 VARCHAR2(30) := p_seg_partial_name||'8';
384 p_desc_col_name9 VARCHAR2(30) := p_seg_partial_name||'9';
385 p_desc_col_name10 VARCHAR2(30) := p_seg_partial_name||'10';
386 p_desc_col_name11 VARCHAR2(30) := p_seg_partial_name||'11';
387 p_desc_col_name12 VARCHAR2(30) := p_seg_partial_name||'12';
388 p_desc_col_name13 VARCHAR2(30) := p_seg_partial_name||'13';
389 p_desc_col_name14 VARCHAR2(30) := p_seg_partial_name||'14';
390 p_desc_col_name15 VARCHAR2(30) := p_seg_partial_name||'15';
391 p_desc_col_name16 VARCHAR2(30) := p_seg_partial_name||'16';
392 p_desc_col_name17 VARCHAR2(30) := p_seg_partial_name||'17';
393 p_desc_col_name18 VARCHAR2(30) := p_seg_partial_name||'18';
394 p_desc_col_name19 VARCHAR2(30) := p_seg_partial_name||'19';
395 p_desc_col_name20 VARCHAR2(30) := p_seg_partial_name||'20';
396 p_desc_col_name21 VARCHAR2(30) := p_seg_partial_name||'21';
397 p_desc_col_name22 VARCHAR2(30) := p_seg_partial_name||'22';
398 p_desc_col_name23 VARCHAR2(30) := p_seg_partial_name||'23';
399 p_desc_col_name24 VARCHAR2(30) := p_seg_partial_name||'24';
400 p_desc_col_name25 VARCHAR2(30) := p_seg_partial_name||'25';
401 p_desc_col_name26 VARCHAR2(30) := p_seg_partial_name||'26';
402 p_desc_col_name27 VARCHAR2(30) := p_seg_partial_name||'27';
403 p_desc_col_name28 VARCHAR2(30) := p_seg_partial_name||'28';
404 p_desc_col_name29 VARCHAR2(30) := p_seg_partial_name||'29';
405 p_desc_col_name30 VARCHAR2(30) := p_seg_partial_name||'30';
406 l_return_status VARCHAR2(1);
407 l_resp_appl_id NUMBER;
408 l_resp_id NUMBER;
409 l_return_value BOOLEAN := TRUE;
410
411 BEGIN
412 IF p_num_of_attributes > 30 THEN
413 /* More than 15 attributes not currently supported. Please contact developer. */
414 ExitWithErrMsg('CSI_API_NUM_OF_DESCFLEX_GT_MAX');
415 END IF;
416
417 Validate_Desc_Flex
418 ( p_api_name,
419 p_appl_short_name,
420 p_desc_flex_name,
421 p_desc_col_name1,
422 p_desc_col_name2,
423 p_desc_col_name3,
424 p_desc_col_name4,
425 p_desc_col_name5,
426 p_desc_col_name6,
427 p_desc_col_name7,
428 p_desc_col_name8,
429 p_desc_col_name9,
430 p_desc_col_name10,
431 p_desc_col_name11,
432 p_desc_col_name12,
433 p_desc_col_name13,
434 p_desc_col_name14,
435 p_desc_col_name15,
436 p_desc_col_name16,
437 p_desc_col_name17,
438 p_desc_col_name18,
439 p_desc_col_name19,
440 p_desc_col_name20,
441 p_desc_col_name21,
442 p_desc_col_name22,
443 p_desc_col_name23,
444 p_desc_col_name24,
445 p_desc_col_name25,
446 p_desc_col_name26,
447 p_desc_col_name27,
448 p_desc_col_name28,
449 p_desc_col_name29,
450 p_desc_col_name30,
451 p_seg_values.attribute1,
452 p_seg_values.attribute2,
453 p_seg_values.attribute3,
454 p_seg_values.attribute4,
455 p_seg_values.attribute5,
456 p_seg_values.attribute6,
457 p_seg_values.attribute7,
458 p_seg_values.attribute8,
459 p_seg_values.attribute9,
460 p_seg_values.attribute10,
461 p_seg_values.attribute11,
462 p_seg_values.attribute12,
463 p_seg_values.attribute13,
464 p_seg_values.attribute14,
465 p_seg_values.attribute15,
466 p_seg_values.attribute16,
467 p_seg_values.attribute17,
468 p_seg_values.attribute18,
469 p_seg_values.attribute19,
470 p_seg_values.attribute20,
471 p_seg_values.attribute21,
472 p_seg_values.attribute22,
473 p_seg_values.attribute23,
474 p_seg_values.attribute24,
475 p_seg_values.attribute25,
476 p_seg_values.attribute26,
477 p_seg_values.attribute27,
478 p_seg_values.attribute28,
479 p_seg_values.attribute29,
480 p_seg_values.attribute30,
481 p_seg_values.attribute_category,
482 l_resp_appl_id,
483 l_resp_id,
484 l_return_status );
485
486 if l_return_status <> FND_API.G_RET_STS_SUCCESS then
487 RAISE FND_API.G_EXC_ERROR;
488 end if;
489 END Is_DescFlex_Valid;
490
491 ------------------------------------------------------------------------------
492 -- Procedure : Validate_Desc_Flex
493 ------------------------------------------------------------------------------
494
495
496 PROCEDURE Validate_Desc_Flex
497 ( p_api_name IN VARCHAR2,
498 p_appl_short_name IN VARCHAR2,
499 p_desc_flex_name IN VARCHAR2,
500 p_column_name1 IN VARCHAR2,
501 p_column_name2 IN VARCHAR2,
502 p_column_name3 IN VARCHAR2,
503 p_column_name4 IN VARCHAR2,
504 p_column_name5 IN VARCHAR2,
505 p_column_name6 IN VARCHAR2,
506 p_column_name7 IN VARCHAR2,
507 p_column_name8 IN VARCHAR2,
508 p_column_name9 IN VARCHAR2,
509 p_column_name10 IN VARCHAR2,
510 p_column_name11 IN VARCHAR2,
511 p_column_name12 IN VARCHAR2,
512 p_column_name13 IN VARCHAR2,
513 p_column_name14 IN VARCHAR2,
514 p_column_name15 IN VARCHAR2,
515 p_column_name16 IN VARCHAR2,
516 p_column_name17 IN VARCHAR2,
517 p_column_name18 IN VARCHAR2,
518 p_column_name19 IN VARCHAR2,
519 p_column_name20 IN VARCHAR2,
520 p_column_name21 IN VARCHAR2,
521 p_column_name22 IN VARCHAR2,
525 p_column_name26 IN VARCHAR2,
522 p_column_name23 IN VARCHAR2,
523 p_column_name24 IN VARCHAR2,
524 p_column_name25 IN VARCHAR2,
526 p_column_name27 IN VARCHAR2,
527 p_column_name28 IN VARCHAR2,
528 p_column_name29 IN VARCHAR2,
529 p_column_name30 IN VARCHAR2,
530 p_column_value1 IN VARCHAR2,
531 p_column_value2 IN VARCHAR2,
532 p_column_value3 IN VARCHAR2,
533 p_column_value4 IN VARCHAR2,
534 p_column_value5 IN VARCHAR2,
535 p_column_value6 IN VARCHAR2,
536 p_column_value7 IN VARCHAR2,
537 p_column_value8 IN VARCHAR2,
538 p_column_value9 IN VARCHAR2,
539 p_column_value10 IN VARCHAR2,
540 p_column_value11 IN VARCHAR2,
541 p_column_value12 IN VARCHAR2,
542 p_column_value13 IN VARCHAR2,
543 p_column_value14 IN VARCHAR2,
544 p_column_value15 IN VARCHAR2,
545 p_column_value16 IN VARCHAR2,
546 p_column_value17 IN VARCHAR2,
547 p_column_value18 IN VARCHAR2,
548 p_column_value19 IN VARCHAR2,
549 p_column_value20 IN VARCHAR2,
550 p_column_value21 IN VARCHAR2,
551 p_column_value22 IN VARCHAR2,
552 p_column_value23 IN VARCHAR2,
553 p_column_value24 IN VARCHAR2,
554 p_column_value25 IN VARCHAR2,
555 p_column_value26 IN VARCHAR2,
556 p_column_value27 IN VARCHAR2,
557 p_column_value28 IN VARCHAR2,
558 p_column_value29 IN VARCHAR2,
559 p_column_value30 IN VARCHAR2,
560 p_context_value IN VARCHAR2,
561 p_resp_appl_id IN NUMBER,
562 p_resp_id IN NUMBER,
563 x_return_status OUT NOCOPY VARCHAR2 ) IS
564
565 l_error_message VARCHAR2(2000);
566 BEGIN
567 x_return_status := fnd_api.g_ret_sts_success;
568
569 fnd_flex_descval.set_column_value(p_column_name1, p_column_value1);
570 fnd_flex_descval.set_column_value(p_column_name2, p_column_value2);
571 fnd_flex_descval.set_column_value(p_column_name3, p_column_value3);
572 fnd_flex_descval.set_column_value(p_column_name4, p_column_value4);
573 fnd_flex_descval.set_column_value(p_column_name5, p_column_value5);
574 fnd_flex_descval.set_column_value(p_column_name6, p_column_value6);
575 fnd_flex_descval.set_column_value(p_column_name7, p_column_value7);
576 fnd_flex_descval.set_column_value(p_column_name8, p_column_value8);
577 fnd_flex_descval.set_column_value(p_column_name9, p_column_value9);
578 fnd_flex_descval.set_column_value(p_column_name10, p_column_value10);
579 fnd_flex_descval.set_column_value(p_column_name11, p_column_value11);
580 fnd_flex_descval.set_column_value(p_column_name12, p_column_value12);
581 fnd_flex_descval.set_column_value(p_column_name13, p_column_value13);
582 fnd_flex_descval.set_column_value(p_column_name14, p_column_value14);
583 fnd_flex_descval.set_column_value(p_column_name15, p_column_value15);
584 fnd_flex_descval.set_column_value(p_column_name16, p_column_value16);
585 fnd_flex_descval.set_column_value(p_column_name17, p_column_value17);
586 fnd_flex_descval.set_column_value(p_column_name18, p_column_value18);
587 fnd_flex_descval.set_column_value(p_column_name19, p_column_value19);
588 fnd_flex_descval.set_column_value(p_column_name20, p_column_value20);
589 fnd_flex_descval.set_column_value(p_column_name21, p_column_value21);
590 fnd_flex_descval.set_column_value(p_column_name22, p_column_value22);
591 fnd_flex_descval.set_column_value(p_column_name23, p_column_value23);
592 fnd_flex_descval.set_column_value(p_column_name24, p_column_value24);
593 fnd_flex_descval.set_column_value(p_column_name25, p_column_value25);
594 fnd_flex_descval.set_column_value(p_column_name26, p_column_value26);
595 fnd_flex_descval.set_column_value(p_column_name27, p_column_value27);
596 fnd_flex_descval.set_column_value(p_column_name28, p_column_value28);
597 fnd_flex_descval.set_column_value(p_column_name29, p_column_value29);
598 fnd_flex_descval.set_column_value(p_column_name30, p_column_value30);
599 fnd_flex_descval.set_context_value(p_context_value);
600
601 IF NOT fnd_flex_descval.validate_desccols
602 ( appl_short_name => p_appl_short_name,
603 desc_flex_name => p_desc_flex_name,
604 resp_appl_id => p_resp_appl_id,
605 resp_id => p_resp_id ) THEN
606 l_error_message := fnd_flex_descval.error_message;
607 -- add_desc_flex_msg(p_api_name, l_error_message);
608 x_return_status := fnd_api.g_ret_sts_error;
609 END IF;
610 END Validate_Desc_Flex;
611
612 PROCEDURE VALIDATE_FORMULA_CTR
613 (
614 p_api_version IN NUMBER,
615 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
616 p_commit IN VARCHAR2 := FND_API.G_FALSE,
617 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
618 x_return_status OUT NOCOPY VARCHAR2,
619 x_msg_count OUT NOCOPY NUMBER,
620 x_msg_data OUT NOCOPY VARCHAR2,
621 p_counter_id IN NUMBER,
622 x_valid_flag OUT NOCOPY VARCHAR2
623 ) is
624
625 l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_FORMULA_CTR';
626 l_api_version CONSTANT NUMBER := 1.0;
627 l_return_status_full VARCHAR2(1);
628 l_s_temp VARCHAR2(100);
629
630 -- Cursor to select all bind variables in bvars table for passed counter
631 CURSOR ctr_bvars IS
632 SELECT bind_variable_name
633 FROM csi_counter_relationships
634 WHERE object_counter_id = p_counter_id;
635
636 l_cursor_handle INTEGER;
637 l_n_temp INTEGER;
638 l_formula varchar2(255);
639 l_counter_reading NUMBER;
640 l_bind_var_value NUMBER;
641 l_bind_var_name VARCHAR2(255);
642 BEGIN
643 -- Standard Start of API savepoint
644 SAVEPOINT VALIDATE_FORMULA;
645
646 -- Standard call to check for call compatibility.
650 G_PKG_NAME)
647 IF NOT FND_API.Compatible_API_Call (l_api_version,
648 p_api_version,
649 l_api_name,
651 THEN
652 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653 END IF;
654
655 -- Initialize message list if p_init_msg_list is set to TRUE.
656 IF FND_API.to_Boolean( p_init_msg_list )
657 THEN
658 FND_MSG_PUB.initialize;
659 END IF;
660
661 -- Initialize API return status to SUCCESS
662 x_return_status := FND_API.G_RET_STS_SUCCESS;
663
664 -- API body
665
666 -- ******************************************************************
667 -- Validate Environment
668 -- ******************************************************************
669
670 IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL)
671 THEN
672 -- Debug message
673 -- Invoke validation procedures
674 null;
675 END IF;
676
677 --Validate counter group id only when validation level is not none
678 IF ( p_validation_level > FND_API.G_VALID_LEVEL_NONE)
679 THEN
680 null;
681 END IF;
682
683 IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
684 RAISE FND_API.G_EXC_ERROR;
685 END IF;
686
687 --Parameter Validations and initialization
688
689 x_valid_flag := 'N';
690
691 BEGIN
692 SELECT formula_text
693 INTO l_formula
694 FROM csi_counters_v
695 WHERE counter_id = p_counter_id;
696 EXCEPTION
697 WHEN NO_DATA_FOUND THEN
698 ExitWithErrMsg('CSI_API_CTR_INVALID');
699 END;
700
701 -- Debug Message
702 --Start Process
703 BEGIN
704 --Open the cursor
705 l_cursor_handle := dbms_sql.open_cursor;
706 l_formula := 'SELECT '||l_formula||' FROM DUAL';
707
708 -- parse the formula using dual table
709 -- if formula is :a/2, in a sql statement it will become 'select :a/2 from dual'
710
711 DBMS_SQL.PARSE(l_cursor_handle, l_formula, dbms_sql.native);
712
713 --define column to select value
714
715 DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_counter_reading);
716
717 FOR bvars IN ctr_bvars LOOP
718 l_bind_var_value := 100;
719 l_bind_var_name := ':'||ltrim(bvars.bind_variable_name);
720 DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_var_name, l_bind_var_value);
721 END LOOP bvars;
722
723 l_n_temp := dbms_sql.execute(l_cursor_handle);
724
725 IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
726 dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
727 x_valid_flag := 'Y';
728 END IF;
729
730 DBMS_SQL.close_cursor(l_cursor_handle);
731 EXCEPTION
732 WHEN OTHERS THEN
733 IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN
734 DBMS_SQL.CLOSE_cursor(l_cursor_handle);
735 END IF;
736
737 if sqlcode <> -1008 then
738 RAISE;
739 else
740 x_valid_flag := 'N';
741 end if;
742 END;
743 x_return_status := FND_API.G_RET_STS_SUCCESS;
744 --
745 -- End of API body
746 --
747 -- Standard check for p_commit
748 IF FND_API.to_Boolean( p_commit )
749 THEN
750 COMMIT WORK;
751 END IF;
752 -- Standard call to get message count and if count is 1, get message info.
753 FND_MSG_PUB.Count_And_Get
754 ( p_count => x_msg_count,
755 p_data => x_msg_data
756 );
757 EXCEPTION
758 WHEN FND_API.G_EXC_ERROR THEN
759 ROLLBACK TO VALIDATE_FORMULA;
760 x_return_status := FND_API.G_RET_STS_ERROR ;
761 FND_MSG_PUB.Count_And_Get
762 (p_count => x_msg_count,
763 p_data => x_msg_data
764 );
765 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
766 ROLLBACK TO VALIDATE_FORMULA;
767 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
768 FND_MSG_PUB.Count_And_Get
769 (
770 p_count => x_msg_count,
771 p_data => x_msg_data
772 );
773 WHEN OTHERS THEN
774 ROLLBACK TO VALIDATE_FORMULA;
775 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
776
777 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
778 FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
779 END IF;
780 FND_MSG_PUB.Count_And_Get
781 (p_count => x_msg_count ,
782 p_data => x_msg_data
783 );
784 END VALIDATE_FORMULA_CTR;
785
786 PROCEDURE VALIDATE_GRPOP_CTR
787 (
788 p_api_version IN NUMBER,
789 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
790 p_commit IN VARCHAR2 := FND_API.G_FALSE,
791 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
792 x_return_status OUT NOCOPY VARCHAR2,
793 x_msg_count OUT NOCOPY NUMBER,
794 x_msg_data OUT NOCOPY VARCHAR2,
795 p_counter_id IN NUMBER,
796 x_valid_flag OUT NOCOPY VARCHAR2
797 ) IS
798
799 l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_GRPOP_CTR';
800 l_api_version CONSTANT NUMBER := 1.0;
801 l_return_status_full VARCHAR2(1);
802 l_s_temp VARCHAR2(100);
803
804 CURSOR ctrs_to_be_calc IS
805 SELECT distinct ctr.counter_id, ctr.derive_function,
806 ctr.derive_counter_id, ctr.derive_property_id
810 CURSOR der_filters(b_counter_id number) IS
807 FROM csi_counters_bc_v ctr
808 WHERE ctr.counter_id = p_counter_id;
809
811 SELECT filt.counter_property_id, filt.seq_no,filt.left_parent,
812 filt.right_parent, filt.relational_operator,
813 filt.logical_operator, filt.right_value,
814 nvl(pro.default_value, 'NULL') as default_value,
815 pro.property_data_type
816 FROM csi_counter_derived_filters filt, csi_ctr_properties_bc_v pro
817 WHERE filt.counter_id = b_counter_id
818 AND pro.counter_property_id(+) = filt.counter_property_id;
819
820 l_sqlstr varchar2(2000);
821 l_sqlwhere varchar2(1000);
822 l_sqlfrom varchar2(1000);
823 l_cursor_handle NUMBER;
824 l_ctr_value NUMBER;
825 l_n_temp NUMBER;
826
827 --variable and arrays for binding dbmssql
828 TYPE FILTS IS RECORD(
829 BINDNAME_DEFVAL VARCHAR2(240),
830 BINDVAL_DEFVAL VARCHAR2(240),
831 BINDNAME_RIGHTVAL VARCHAR2(240),
832 BINDVAL_RIGHTVAL VARCHAR2(240),
833 BINDNAME_CTRPROPID VARCHAR2(240),
834 BINDVAL_CTRPROPID NUMBER);
835
836 TYPE T1 is TABLE OF FILTS index by binary_integer;
837 T2 T1;
838 i NUMBER := 1;
839 lj NUMBER := 1;
840
841 BINDVAL_DERIVECTRID NUMBER;
842 l_bind_varname VARCHAR2(240);
843 l_bind_varvalc VARCHAR2(240);
844 l_bind_varvaln NUMBER;
845
846 BEGIN
847 -- Standard Start of API savepoint
848 SAVEPOINT VALIDATE_GRPOP;
849
850 -- Standard call to check for call compatibility.
851 IF NOT FND_API.Compatible_API_Call ( l_api_version,
852 p_api_version,
853 l_api_name,
854 G_PKG_NAME)
855 THEN
856 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857 END IF;
858
859 -- Read the debug profiles values in to global variable 7197402
860 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
861
862 -- Initialize message list if p_init_msg_list is set to TRUE.
863
864 IF FND_API.to_Boolean( p_init_msg_list )
865 THEN
866 FND_MSG_PUB.initialize;
867 END IF;
868
869 -- Initialize API return status to SUCCESS
870 x_return_status := FND_API.G_RET_STS_SUCCESS;
871
872 --
873 -- API body
874 --
875 -- ******************************************************************
876 -- Validate Environment
877 -- ******************************************************************
878
879 IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
880 THEN
881 -- Debug message
882 -- Invoke validation procedures
883 null;
884 END IF;
885
886 --Validate counter group id only when validation level is not none
887 IF ( P_validation_level > FND_API.G_VALID_LEVEL_NONE)
888 THEN
889 null;
890 END IF;
891
892 IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
893 RAISE FND_API.G_EXC_ERROR;
894 END IF;
895
896 --Parameter Validations and initialization
897 x_valid_flag := 'N';
898
899 -- Debug Message
900 begin
901 FOR ctrs IN ctrs_to_be_calc LOOP
902 i := 1;
903 lj := 1;
904
905 l_sqlstr := 'select '||ctrs.derive_function||'( counter_reading )';
906 l_sqlstr := l_sqlstr || ' from csi_counter_readings cv';
907 l_sqlstr := l_sqlstr || ' where counter_value_id in (';
908 l_sqlstr := l_sqlstr || ' select distinct cv.counter_value_id from ';
909 l_sqlfrom := ' csi_counter_readings cv';
910 l_sqlwhere := '';
911
912 FOR filts IN der_filters(ctrs.counter_id) LOOP
913 l_sqlfrom := l_sqlfrom ||', csi_ctr_property_readings pv';
914 l_sqlfrom := l_sqlfrom ||ltrim(rtrim(filts.seq_no));
915
916 --if filts.seq_no > 1 then -- Bugs 12641096 & 12614962
917 -- l_sqlwhere := l_sqlwhere ||' and '||nvl(filts.left_parent,' ')||' nvl(pv'; -- Bugs 12641096 & 12614962
918 --else -- Bugs 12641096 & 12614962
919 l_sqlwhere := l_sqlwhere ||' '||nvl(filts.left_parent,' ')||' nvl(pv';
920 -- end if; -- Bugs 12641096 & 12614962
921
922 l_sqlwhere := l_sqlwhere || ltrim(rtrim(filts.seq_no));
923 l_sqlwhere := l_sqlwhere || '.property_value, '; --||filts.default_value;
924
925 T2(i).BINDVAL_DEFVAL := filts.default_value;
926 T2(i).BINDNAME_DEFVAL := ':x_default_value'||ltrim(rtrim(filts.seq_no));
927
928 if filts.property_data_type = 'NUMBER' then
929 l_sqlwhere := l_sqlwhere ||':x_default_value'||ltrim(rtrim(filts.seq_no));
930 elsif filts.property_data_type = 'DATE' then
931 -- l_sqlwhere := l_sqlwhere || 'to_date( '||':x_default_value'||ltrim(rtrim(filts.seq_no))||' )';
932 l_sqlwhere := l_sqlwhere || 'to_date( '||':x_default_value'||ltrim(rtrim(filts.seq_no))||','||'''YYYY/MM/DD'''||')';
933 else
934 l_sqlwhere := l_sqlwhere || ':x_default_value'||ltrim(rtrim(filts.seq_no));
935 end if;
936
937 l_sqlwhere := l_sqlwhere ||')'||' '||filts.relational_operator;
938
939 T2(i).BINDVAL_RIGHTVAL := filts.right_value;
940 T2(i).BINDNAME_RIGHTVAL := ':x_right_value'||ltrim(rtrim(filts.seq_no));
941
942 if filts.property_data_type = 'NUMBER' then
946 l_sqlwhere := l_sqlwhere || 'to_date( '||':x_right_value'||ltrim(rtrim(filts.seq_no))||','||'''YYYY/MM/DD'''||')';
943 l_sqlwhere := l_sqlwhere || ':x_right_value'||ltrim(rtrim(filts.seq_no));
944 elsif filts.property_data_type = 'DATE' then
945 -- l_sqlwhere := l_sqlwhere || 'to_date( '||':x_right_value'||ltrim(rtrim(filts.seq_no))||' )';
947 else
948 l_sqlwhere := l_sqlwhere || ':x_right_value'||ltrim(rtrim(filts.seq_no));
949 end if;
950
951 -- l_sqlwhere := l_sqlwhere || nvl(filts.right_parent,' '); -- Bugs 12641096 & 12614962
952 -- l_sqlwhere := l_sqlwhere || ' '|| filts.logical_operator; -- Bugs 12641096 & 12614962
953 -- if filts.seq_no > 1 then -- dsingire demo
954 l_sqlwhere := l_sqlwhere || ' and pv'||ltrim(rtrim(filts.seq_no)) ;
955 /* else -- Bugs 12641096 & 12614962
956 if filts.logical_operator IS NULL THEN
957 l_sqlwhere := l_sqlwhere || ' and pv'||ltrim(rtrim(filts.seq_no)) ;
958 else
959 l_sqlwhere := l_sqlwhere || ' pv'||ltrim(rtrim(filts.seq_no)) ;
960 end if;
961 end if;*/ -- Bugs 12641096 & 12614962
962
963 l_sqlwhere := l_sqlwhere || '.counter_value_id = cv.counter_value_id ';
964 l_sqlwhere := l_sqlwhere || ' and pv'||ltrim(rtrim(filts.seq_no)) ;
965 l_sqlwhere := l_sqlwhere || '.counter_property_id = ';
966
967 T2(i).BINDVAL_CTRPROPID := filts.counter_property_id;
968 T2(i).BINDNAME_CTRPROPID := ':x_ctr_prop_id'||ltrim(rtrim(filts.seq_no));
969 l_sqlwhere := l_sqlwhere ||':x_ctr_prop_id'||ltrim(rtrim(filts.seq_no));
970
971 l_sqlwhere := l_sqlwhere || ' and cv.counter_id = ';
972 l_sqlwhere := l_sqlwhere || ':x_derive_counter_id';
973
974 l_sqlwhere := l_sqlwhere || nvl(filts.right_parent,' '); -- Bugs 12641096 & 12614962
975 l_sqlwhere := l_sqlwhere || ' '|| filts.logical_operator; -- Bugs 12641096 & 12614962
976
977 END LOOP;
978
979 l_sqlstr := l_sqlstr || l_sqlfrom || ' where '||l_sqlwhere||')';
980
981 csi_ctr_gen_utility_pvt.put_line('l_sqlstr = '||l_sqlstr);
982
983 l_cursor_handle := dbms_sql.open_cursor;
984 DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
985 DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
986
987 BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
988 DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
989
990 while lj < i+1
991 loop
992 l_bind_varname := t2(lj).BINDNAME_DEFVAL;
993 l_bind_varvalc := t2(lj).BINDVAL_DEFVAL;
994 DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
995 l_bind_varname := t2(lj).BINDNAME_RIGHTVAL;
996 l_bind_varvalc := t2(lj).BINDVAL_RIGHTVAL;
997 DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
998 l_bind_varname := t2(lj).BINDNAME_CTRPROPID;
999 l_bind_varvaln := t2(lj).BINDVAL_CTRPROPID;
1000 DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvaln);
1001 lj:= lj+1;
1002 end loop;
1003
1004 /* l_n_temp := dbms_sql.execute(l_cursor_handle);
1005 IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
1006 dbms_sql.column_value(l_cursor_handle,1,l_ctr_value);
1007 END IF;
1008 DBMS_SQL.close_cursor(l_cursor_handle);
1009 */
1010 x_valid_flag := 'Y';
1011 END LOOP;
1012 EXCEPTION
1013 WHEN OTHERS THEN
1014 IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN
1015 DBMS_SQL.CLOSE_cursor(l_cursor_handle);
1016 END IF;
1017 RAISE;
1018 END;
1019
1020 IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1021 RAISE FND_API.G_EXC_ERROR;
1022 END IF;
1023 --
1024 -- End of API body
1025 --
1026 -- Standard check for p_commit
1027 IF FND_API.to_Boolean( p_commit )
1028 THEN
1029 COMMIT WORK;
1030 END IF;
1031 -- Standard call to get message count and if count is 1, get message info.
1032 FND_MSG_PUB.Count_And_Get
1033 ( p_count => x_msg_count,
1034 p_data => x_msg_data
1035 );
1036 EXCEPTION
1037 WHEN FND_API.G_EXC_ERROR THEN
1038 ROLLBACK TO VALIDATE_GRPOP;
1039 x_return_status := FND_API.G_RET_STS_ERROR ;
1040 FND_MSG_PUB.Count_And_Get
1041 (p_count => x_msg_count,
1042 p_data => x_msg_data
1043 );
1044 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1045 ROLLBACK TO VALIDATE_GRPOP;
1046 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1047 FND_MSG_PUB.Count_And_Get
1048 (
1049 p_count => x_msg_count,
1050 p_data => x_msg_data
1051 );
1052 WHEN OTHERS THEN
1053 ROLLBACK TO VALIDATE_GRPOP;
1054 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1055 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1056 FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1057 END IF;
1058 FND_MSG_PUB.Count_And_Get
1059 (p_count => x_msg_count ,
1060 p_data => x_msg_data
1061 );
1062 End VALIDATE_GRPOP_CTR;
1063
1064 FUNCTION Is_StartEndDate_Valid
1065 (
1066 p_st_dt IN DATE,
1067 p_end_dt IN DATE,
1071 l_return_value BOOLEAN := TRUE;
1068 p_stack_err_msg IN BOOLEAN := TRUE
1069 ) RETURN BOOLEAN IS
1070
1072 BEGIN
1073 IF (p_st_dt > p_end_dt) THEN
1074 l_return_value := FALSE;
1075 IF ( p_stack_err_msg = TRUE ) THEN
1076 ExitWithErrMsg('CSI_ALL_START_DATE_AFTER_END','START_DATE',p_st_dt,'END_DATE',p_end_dt);
1077 FND_MSG_PUB.Add;
1078 END IF;
1079 END IF;
1080 RETURN l_return_value;
1081 END Is_StartEndDate_Valid;
1082
1083 PROCEDURE Initialize_Desc_Flex_For_Upd
1084 (
1085 l_ctr_derived_filters_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec,
1086 l_old_ctr_derived_filters_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec
1087 ) IS
1088 BEGIN
1089 IF l_ctr_derived_filters_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1090 l_ctr_derived_filters_rec.attribute1 := l_old_ctr_derived_filters_rec.attribute1;
1091 END IF;
1092
1093 IF l_ctr_derived_filters_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1094 l_ctr_derived_filters_rec.attribute2 := l_old_ctr_derived_filters_rec.attribute2;
1095 END IF;
1096
1097 IF l_ctr_derived_filters_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1098 l_ctr_derived_filters_rec.attribute3 := l_old_ctr_derived_filters_rec.attribute3;
1099 END IF;
1100
1101 IF l_ctr_derived_filters_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1102 l_ctr_derived_filters_rec.attribute4 := l_old_ctr_derived_filters_rec.attribute4;
1103 END IF;
1104
1105 IF l_ctr_derived_filters_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1106 l_ctr_derived_filters_rec.attribute5 := l_old_ctr_derived_filters_rec.attribute5;
1107 END IF;
1108
1109 IF l_ctr_derived_filters_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1110 l_ctr_derived_filters_rec.attribute6 := l_old_ctr_derived_filters_rec.attribute6;
1111 END IF;
1112
1113 IF l_ctr_derived_filters_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1114 l_ctr_derived_filters_rec.attribute7 := l_old_ctr_derived_filters_rec.attribute7;
1115 END IF;
1116
1117 IF l_ctr_derived_filters_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1118 l_ctr_derived_filters_rec.attribute8 := l_old_ctr_derived_filters_rec.attribute8;
1119 END IF;
1120
1121 IF l_ctr_derived_filters_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1122 l_ctr_derived_filters_rec.attribute9 := l_old_ctr_derived_filters_rec.attribute9;
1123 END IF;
1124
1125 IF l_ctr_derived_filters_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1126 l_ctr_derived_filters_rec.attribute10 := l_old_ctr_derived_filters_rec.attribute10;
1127 END IF;
1128
1129 IF l_ctr_derived_filters_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1130 l_ctr_derived_filters_rec.attribute11 := l_old_ctr_derived_filters_rec.attribute11;
1131 END IF;
1132
1133 IF l_ctr_derived_filters_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1134 l_ctr_derived_filters_rec.attribute12 := l_old_ctr_derived_filters_rec.attribute12;
1135 END IF;
1136
1137 IF l_ctr_derived_filters_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1138 l_ctr_derived_filters_rec.attribute13 := l_old_ctr_derived_filters_rec.attribute13;
1139 END IF;
1140
1141 IF l_ctr_derived_filters_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1142 l_ctr_derived_filters_rec.attribute14 := l_old_ctr_derived_filters_rec.attribute14;
1143 END IF;
1144
1145 IF l_ctr_derived_filters_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1146 l_ctr_derived_filters_rec.attribute15 := l_old_ctr_derived_filters_rec.attribute15;
1147 END IF;
1148
1149 IF l_ctr_derived_filters_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1150 l_ctr_derived_filters_rec.attribute_category := l_old_ctr_derived_filters_rec.attribute_category;
1151 END IF;
1152 END Initialize_Desc_Flex_For_Upd;
1153
1154
1155 PROCEDURE check_ib_active IS
1156 BEGIN
1157 /* IF NOT csi_gen_utility_pvt.IB_ACTIVE THEN
1158 FND_MESSAGE.Set_Name('CSI', 'CSI_IB_NOT_ACTIVE');
1159 FND_MSG_PUB.Add;
1160 RAISE FND_API.G_Exc_Error;
1161 END IF
1162 */
1163 null;
1164 EXCEPTION
1165 WHEN fnd_api.g_exc_error THEN
1166 RAISE fnd_api.g_exc_error;
1167 WHEN others THEN
1168 FND_MESSAGE.Set_Name('CSI', 'CSI_UNEXP_SQL_ERROR');
1169 FND_MESSAGE.Set_Token('API_NAME', 'Check_IB_Active');
1170 FND_MESSAGE.Set_Token('SQL_ERROR', sqlerrm);
1171 FND_MSG_PUB.Add;
1172 RAISE fnd_api.g_exc_error;
1173 END check_ib_active;
1174
1175 PROCEDURE dump_ctr_grp_rec
1176 (p_counter_groups_rec IN csi_ctr_datastructures_pub.counter_groups_rec) IS
1177
1178 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_grp_rec';
1179 l_api_version CONSTANT NUMBER := 1.0;
1180 BEGIN
1181 SAVEPOINT dump_ctr_grp_rec;
1182
1183 -- Read the debug profiles values in to global variable 7197402
1184 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1185
1186 PUT_LINE (' ');
1187 PUT_LINE ('Dumping the values for Counter Groups Record:');
1188 PUT_LINE (' ');
1189
1190 PUT_LINE ('COUNTER_GROUP_ID :'||p_counter_groups_rec.COUNTER_GROUP_ID);
1191 PUT_LINE ('NAME :'||p_counter_groups_rec.NAME);
1192 PUT_LINE ('DESCRIPTION :'||p_counter_groups_rec.DESCRIPTION);
1193 PUT_LINE ('TEMPLATE_FLAG :'||p_counter_groups_rec.TEMPLATE_FLAG);
1194 -- PUT_LINE ('CP_SERVICE_ID :'||p_counter_groups_rec.CP_SERVICE_ID);
1195 -- PUT_LINE ('CUSTOMER_PRODUCT_ID :'||p_counter_groups_rec.CUSTOMER_PRODUCT_ID);
1196 PUT_LINE ('START_DATE_ACTIVE :'||p_counter_groups_rec.START_DATE_ACTIVE);
1200 PUT_LINE ('ATTRIBUTE3 :'||p_counter_groups_rec.ATTRIBUTE3);
1197 PUT_LINE ('END_DATE_ACTIVE :'||p_counter_groups_rec.END_DATE_ACTIVE);
1198 PUT_LINE ('ATTRIBUTE1 :'||p_counter_groups_rec.ATTRIBUTE1);
1199 PUT_LINE ('ATTRIBUTE2 :'||p_counter_groups_rec.ATTRIBUTE2);
1201 PUT_LINE ('ATTRIBUTE4 :'||p_counter_groups_rec.ATTRIBUTE4);
1202 PUT_LINE ('ATTRIBUTE5 :'||p_counter_groups_rec.ATTRIBUTE5);
1203 PUT_LINE ('ATTRIBUTE6 :'||p_counter_groups_rec.ATTRIBUTE6);
1204 PUT_LINE ('ATTRIBUTE7 :'||p_counter_groups_rec.ATTRIBUTE7);
1205 PUT_LINE ('ATTRIBUTE8 :'||p_counter_groups_rec.ATTRIBUTE8);
1206 PUT_LINE ('ATTRIBUTE9 :'||p_counter_groups_rec.ATTRIBUTE9);
1207 PUT_LINE ('ATTRIBUTE10 :'||p_counter_groups_rec.ATTRIBUTE10);
1208 PUT_LINE ('ATTRIBUTE11 :'||p_counter_groups_rec.ATTRIBUTE11);
1209 PUT_LINE ('ATTRIBUTE12 :'||p_counter_groups_rec.ATTRIBUTE12);
1210 PUT_LINE ('ATTRIBUTE13 :'||p_counter_groups_rec.ATTRIBUTE13);
1211 PUT_LINE ('ATTRIBUTE14 :'||p_counter_groups_rec.ATTRIBUTE14);
1212 PUT_LINE ('ATTRIBUTE15 :'||p_counter_groups_rec.ATTRIBUTE15);
1213 PUT_LINE ('CONTEXT :'||p_counter_groups_rec.CONTEXT);
1214 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_groups_rec.OBJECT_VERSION_NUMBER);
1215 PUT_LINE ('CREATED_FROM_CTR_GRP_TMPL_ID :'||p_counter_groups_rec.CREATED_FROM_CTR_GRP_TMPL_ID);
1216 PUT_LINE ('ASSOCIATION_TYPE :'||p_counter_groups_rec.ASSOCIATION_TYPE);
1217 PUT_LINE ('SOURCE_OBJECT_CODE :'||p_counter_groups_rec.SOURCE_OBJECT_CODE);
1218 PUT_LINE ('SOURCE_OBJECT_ID :'||p_counter_groups_rec.SOURCE_OBJECT_ID);
1219 PUT_LINE ('SOURCE_COUNTER_GROUP_ID :'||p_counter_groups_rec.SOURCE_COUNTER_GROUP_ID);
1220 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_groups_rec.SECURITY_GROUP_ID);
1221 EXCEPTION
1222 WHEN OTHERS THEN
1223 ROLLBACK TO dump_ctr_grp_rec;
1224 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1225 THEN
1226 FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);
1227 END IF;
1228 END dump_ctr_grp_rec;
1229
1230 PROCEDURE dump_ctr_grp_tbl
1231 (p_counter_groups_tbl IN csi_ctr_datastructures_pub.counter_groups_tbl) IS
1232
1233 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_grp_tbl';
1234 l_api_version CONSTANT NUMBER := 1.0;
1235 BEGIN
1236 SAVEPOINT dump_ctr_grp_tbl;
1237
1238 -- Read the debug profiles values in to global variable 7197402
1239 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1240
1241 IF p_counter_groups_tbl.COUNT > 0 THEN
1242 FOR tab_row IN p_counter_groups_tbl.FIRST .. p_counter_groups_tbl.LAST
1243 LOOP
1244 IF p_counter_groups_tbl.EXISTS(tab_row) THEN
1245
1246 PUT_LINE (' ');
1247 PUT_LINE ('Dumping the values for Counter Groups Table Record # : '||tab_row);
1248 PUT_LINE (' ');
1249
1250 PUT_LINE ('COUNTER_GROUP_ID :'||p_counter_groups_tbl(tab_row).COUNTER_GROUP_ID);
1251 PUT_LINE ('NAME :'||p_counter_groups_tbl(tab_row).NAME);
1252 PUT_LINE ('DESCRIPTION :'||p_counter_groups_tbl(tab_row).DESCRIPTION);
1253 PUT_LINE ('TEMPLATE_FLAG :'||p_counter_groups_tbl(tab_row).TEMPLATE_FLAG);
1254 -- PUT_LINE ('CP_SERVICE_ID :'||p_counter_groups_tbl(tab_row).CP_SERVICE_ID);
1255 -- PUT_LINE ('CUSTOMER_PRODUCT_ID :'||p_counter_groups_tbl(tab_row).CUSTOMER_PRODUCT_ID);
1256 PUT_LINE ('START_DATE_ACTIVE :'||p_counter_groups_tbl(tab_row).START_DATE_ACTIVE);
1257 PUT_LINE ('END_DATE_ACTIVE :'||p_counter_groups_tbl(tab_row).END_DATE_ACTIVE);
1258 PUT_LINE ('ATTRIBUTE1 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE1);
1259 PUT_LINE ('ATTRIBUTE2 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE2);
1260 PUT_LINE ('ATTRIBUTE3 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE3);
1261 PUT_LINE ('ATTRIBUTE4 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE4);
1262 PUT_LINE ('ATTRIBUTE5 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE5);
1263 PUT_LINE ('ATTRIBUTE6 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE6);
1264 PUT_LINE ('ATTRIBUTE7 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE7);
1265 PUT_LINE ('ATTRIBUTE8 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE8);
1266 PUT_LINE ('ATTRIBUTE9 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE9);
1267 PUT_LINE ('ATTRIBUTE10 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE10);
1268 PUT_LINE ('ATTRIBUTE11 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE11);
1269 PUT_LINE ('ATTRIBUTE12 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE12);
1270 PUT_LINE ('ATTRIBUTE13 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE13);
1271 PUT_LINE ('ATTRIBUTE14 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE14);
1272 PUT_LINE ('ATTRIBUTE15 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE15);
1273 PUT_LINE ('CONTEXT :'||p_counter_groups_tbl(tab_row).CONTEXT);
1274 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_groups_tbl(tab_row).OBJECT_VERSION_NUMBER);
1275 PUT_LINE ('CREATED_FROM_CTR_GRP_TMPL_ID :'||p_counter_groups_tbl(tab_row).CREATED_FROM_CTR_GRP_TMPL_ID);
1279 PUT_LINE ('SOURCE_COUNTER_GROUP_ID :'||p_counter_groups_tbl(tab_row).SOURCE_COUNTER_GROUP_ID);
1276 PUT_LINE ('ASSOCIATION_TYPE :'||p_counter_groups_tbl(tab_row).ASSOCIATION_TYPE);
1277 PUT_LINE ('SOURCE_OBJECT_CODE :'||p_counter_groups_tbl(tab_row).SOURCE_OBJECT_CODE);
1278 PUT_LINE ('SOURCE_OBJECT_ID :'||p_counter_groups_tbl(tab_row).SOURCE_OBJECT_ID);
1280 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_groups_tbl(tab_row).SECURITY_GROUP_ID);
1281 END IF;
1282 END LOOP;
1283 END IF;
1284 EXCEPTION
1285 WHEN OTHERS THEN
1286 ROLLBACK TO dump_ctr_grp_tbl;
1287 IF FND_MSG_PUB.Check_Msg_Level
1288 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1289 THEN
1290 FND_MSG_PUB.Add_Exc_Msg
1291 (g_pkg_name,
1292 l_api_name);
1293 END IF;
1294 END dump_ctr_grp_tbl;
1295
1296 PROCEDURE dump_ctr_template_rec
1297 (p_counter_template_rec IN csi_ctr_datastructures_pub.counter_template_rec) IS
1298
1299
1300 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_template_rec';
1301 l_api_version CONSTANT NUMBER := 1.0;
1302 BEGIN
1303 SAVEPOINT dump_ctr_template_rec;
1304
1305 -- Read the debug profiles values in to global variable 7197402
1306 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1307
1308 PUT_LINE (' ');
1309 PUT_LINE ('Dumping the values for Counter Template Record:');
1310 PUT_LINE (' ');
1311
1312 PUT_LINE ('COUNTER_ID :'||p_counter_template_rec.COUNTER_ID);
1313 PUT_LINE ('GROUP_ID :'||p_counter_template_rec.GROUP_ID);
1314 PUT_LINE ('DESCRIPTION :'||p_counter_template_rec.DESCRIPTION);
1315 PUT_LINE ('COUNTER_TYPE :'||p_counter_template_rec.COUNTER_TYPE);
1316 PUT_LINE ('INITIAL_READING :'||p_counter_template_rec.INITIAL_READING);
1317 PUT_LINE ('INITIAL_READING_DATE :'||p_counter_template_rec.INITIAL_READING_DATE);
1318 PUT_LINE ('TOLERANCE_PLUS :'||p_counter_template_rec.TOLERANCE_PLUS);
1319 PUT_LINE ('TOLERANCE_MINUS :'||p_counter_template_rec.TOLERANCE_MINUS);
1320 PUT_LINE ('UOM_CODE :'||p_counter_template_rec.UOM_CODE);
1321 PUT_LINE ('DERIVE_COUNTER_ID :'||p_counter_template_rec.DERIVE_COUNTER_ID);
1322 PUT_LINE ('DERIVE_FUNCTION :'||p_counter_template_rec.DERIVE_FUNCTION);
1323 PUT_LINE ('DERIVE_PROPERTY_ID :'||p_counter_template_rec.DERIVE_PROPERTY_ID);
1324 PUT_LINE ('VALID_FLAG :'||p_counter_template_rec.VALID_FLAG);
1325 PUT_LINE ('FORMULA_INCOMPLETE_FLAG :'||p_counter_template_rec.FORMULA_INCOMPLETE_FLAG);
1326 PUT_LINE ('FORMULA_TEXT :'||p_counter_template_rec.FORMULA_TEXT);
1327 PUT_LINE ('ROLLOVER_LAST_READING :'||p_counter_template_rec.ROLLOVER_LAST_READING);
1328 PUT_LINE ('ROLLOVER_FIRST_READING :'||p_counter_template_rec.ROLLOVER_FIRST_READING);
1329 PUT_LINE ('USAGE_ITEM_ID :'||p_counter_template_rec.USAGE_ITEM_ID);
1330 PUT_LINE ('CTR_VAL_MAX_SEQ_NO :'||p_counter_template_rec.CTR_VAL_MAX_SEQ_NO);
1331 PUT_LINE ('START_DATE_ACTIVE :'||p_counter_template_rec.START_DATE_ACTIVE);
1332 PUT_LINE ('END_DATE_ACTIVE :'||p_counter_template_rec.END_DATE_ACTIVE);
1333 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_template_rec.OBJECT_VERSION_NUMBER);
1334 PUT_LINE ('ATTRIBUTE1 :'||p_counter_template_rec.ATTRIBUTE1);
1335 PUT_LINE ('ATTRIBUTE2 :'||p_counter_template_rec.ATTRIBUTE2);
1336 PUT_LINE ('ATTRIBUTE3 :'||p_counter_template_rec.ATTRIBUTE3);
1337 PUT_LINE ('ATTRIBUTE4 :'||p_counter_template_rec.ATTRIBUTE4);
1338 PUT_LINE ('ATTRIBUTE5 :'||p_counter_template_rec.ATTRIBUTE5);
1339 PUT_LINE ('ATTRIBUTE6 :'||p_counter_template_rec.ATTRIBUTE6);
1340 PUT_LINE ('ATTRIBUTE7 :'||p_counter_template_rec.ATTRIBUTE7);
1341 PUT_LINE ('ATTRIBUTE8 :'||p_counter_template_rec.ATTRIBUTE8);
1342 PUT_LINE ('ATTRIBUTE9 :'||p_counter_template_rec.ATTRIBUTE9);
1343 PUT_LINE ('ATTRIBUTE10 :'||p_counter_template_rec.ATTRIBUTE10);
1344 PUT_LINE ('ATTRIBUTE11 :'||p_counter_template_rec.ATTRIBUTE11);
1345 PUT_LINE ('ATTRIBUTE12 :'||p_counter_template_rec.ATTRIBUTE12);
1346 PUT_LINE ('ATTRIBUTE13 :'||p_counter_template_rec.ATTRIBUTE13);
1347 PUT_LINE ('ATTRIBUTE14 :'||p_counter_template_rec.ATTRIBUTE14);
1348 PUT_LINE ('ATTRIBUTE15 :'||p_counter_template_rec.ATTRIBUTE15);
1349 PUT_LINE ('ATTRIBUTE16 :'||p_counter_template_rec.ATTRIBUTE16);
1350 PUT_LINE ('ATTRIBUTE17 :'||p_counter_template_rec.ATTRIBUTE17);
1351 PUT_LINE ('ATTRIBUTE18 :'||p_counter_template_rec.ATTRIBUTE18);
1352 PUT_LINE ('ATTRIBUTE19 :'||p_counter_template_rec.ATTRIBUTE19);
1353 PUT_LINE ('ATTRIBUTE20 :'||p_counter_template_rec.ATTRIBUTE20);
1354 PUT_LINE ('ATTRIBUTE21 :'||p_counter_template_rec.ATTRIBUTE21);
1355 PUT_LINE ('ATTRIBUTE22 :'||p_counter_template_rec.ATTRIBUTE22);
1356 PUT_LINE ('ATTRIBUTE23 :'||p_counter_template_rec.ATTRIBUTE23);
1357 PUT_LINE ('ATTRIBUTE24 :'||p_counter_template_rec.ATTRIBUTE24);
1358 PUT_LINE ('ATTRIBUTE25 :'||p_counter_template_rec.ATTRIBUTE25);
1359 PUT_LINE ('ATTRIBUTE26 :'||p_counter_template_rec.ATTRIBUTE26);
1363 PUT_LINE ('ATTRIBUTE30 :'||p_counter_template_rec.ATTRIBUTE30);
1360 PUT_LINE ('ATTRIBUTE27 :'||p_counter_template_rec.ATTRIBUTE27);
1361 PUT_LINE ('ATTRIBUTE28 :'||p_counter_template_rec.ATTRIBUTE28);
1362 PUT_LINE ('ATTRIBUTE29 :'||p_counter_template_rec.ATTRIBUTE29);
1364 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_template_rec.ATTRIBUTE_CATEGORY);
1365 PUT_LINE ('DIRECTION :'||p_counter_template_rec.DIRECTION);
1366 PUT_LINE ('FILTER_TYPE :'||p_counter_template_rec.FILTER_TYPE);
1367 PUT_LINE ('FILTER_READING_COUNT :'||p_counter_template_rec.FILTER_READING_COUNT);
1368 PUT_LINE ('FILTER_TIME_UOM :'||p_counter_template_rec.FILTER_TIME_UOM);
1369 PUT_LINE ('ESTIMATION_ID :'||p_counter_template_rec.ESTIMATION_ID);
1370 PUT_LINE ('READING_TYPE :'||p_counter_template_rec.READING_TYPE);
1371 PUT_LINE ('AUTOMATIC_ROLLOVER :'||p_counter_template_rec.AUTOMATIC_ROLLOVER);
1372 PUT_LINE ('DEFAULT_USAGE_RATE :'||p_counter_template_rec.DEFAULT_USAGE_RATE);
1373 PUT_LINE ('USE_PAST_READING :'||p_counter_template_rec.USE_PAST_READING);
1374 PUT_LINE ('USED_IN_SCHEDULING :'||p_counter_template_rec.USED_IN_SCHEDULING);
1375 PUT_LINE ('DEFAULTED_GROUP_ID :'||p_counter_template_rec.DEFAULTED_GROUP_ID);
1376 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_template_rec.SECURITY_GROUP_ID);
1377 PUT_LINE ('NAME :'||p_counter_template_rec.NAME);
1378 PUT_LINE ('DESCRIPTION :'||p_counter_template_rec.DESCRIPTION);
1379 PUT_LINE ('COMMENTS :'||p_counter_template_rec.COMMENTS);
1380 PUT_LINE ('ASSOCIATION_TYPE :'||p_counter_template_rec.ASSOCIATION_TYPE);
1381 PUT_LINE ('STEP_VALUE :'||p_counter_template_rec.STEP_VALUE);
1382 PUT_LINE ('TIME_BASED_MANUAL_ENTRY :'||p_counter_template_rec.TIME_BASED_MANUAL_ENTRY);
1383 PUT_LINE ('EAM_REQUIRED_FLAG :'||p_counter_template_rec.EAM_REQUIRED_FLAG);
1384 EXCEPTION
1385 WHEN OTHERS THEN
1386 ROLLBACK TO dump_ctr_template_rec;
1387 IF FND_MSG_PUB.Check_Msg_Level
1388 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1389 THEN
1390 FND_MSG_PUB.Add_Exc_Msg
1391 (g_pkg_name,
1392 l_api_name);
1393 END IF;
1394 END dump_ctr_template_rec;
1395
1396 PROCEDURE dump_ctr_template_tbl
1397 (p_counter_template_tbl IN csi_ctr_datastructures_pub.counter_template_tbl) IS
1398
1399 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_template_tbl';
1400 l_api_version CONSTANT NUMBER := 1.0;
1401
1402 BEGIN
1403 SAVEPOINT dump_ctr_template_tbl;
1404
1405 -- Read the debug profiles values in to global variable 7197402
1406 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1407
1408 IF p_counter_template_tbl.COUNT > 0 THEN
1409 FOR tab_row IN p_counter_template_tbl.FIRST .. p_counter_template_tbl.LAST
1410 LOOP
1411 IF p_counter_template_tbl.EXISTS(tab_row) THEN
1412
1413 PUT_LINE (' ');
1414 PUT_LINE ('Dumping the values for Counter Template Table Record # : '||tab_row);
1415 PUT_LINE (' ');
1416 PUT_LINE ('COUNTER_ID :'||p_counter_template_tbl(tab_row).COUNTER_ID);
1417 PUT_LINE ('GROUP_ID :'||p_counter_template_tbl(tab_row).GROUP_ID);
1418 PUT_LINE ('DESCRIPTION :'||p_counter_template_tbl(tab_row).DESCRIPTION);
1419 PUT_LINE ('COUNTER_TYPE :'||p_counter_template_tbl(tab_row).COUNTER_TYPE);
1420 PUT_LINE ('INITIAL_READING :'||p_counter_template_tbl(tab_row).INITIAL_READING);
1421 PUT_LINE ('INITIAL_READING_DATE :'||p_counter_template_tbl(tab_row).INITIAL_READING_DATE);
1422 PUT_LINE ('TOLERANCE_PLUS :'||p_counter_template_tbl(tab_row).TOLERANCE_PLUS);
1423 PUT_LINE ('TOLERANCE_MINUS :'||p_counter_template_tbl(tab_row).TOLERANCE_MINUS);
1424 PUT_LINE ('UOM_CODE :'||p_counter_template_tbl(tab_row).UOM_CODE);
1425 PUT_LINE ('DERIVE_COUNTER_ID :'||p_counter_template_tbl(tab_row).DERIVE_COUNTER_ID);
1426 PUT_LINE ('DERIVE_FUNCTION :'||p_counter_template_tbl(tab_row).DERIVE_FUNCTION);
1427 PUT_LINE ('DERIVE_PROPERTY_ID :'||p_counter_template_tbl(tab_row).DERIVE_PROPERTY_ID);
1428 PUT_LINE ('VALID_FLAG :'||p_counter_template_tbl(tab_row).VALID_FLAG);
1429 PUT_LINE ('FORMULA_INCOMPLETE_FLAG :'||p_counter_template_tbl(tab_row).FORMULA_INCOMPLETE_FLAG);
1430 PUT_LINE ('FORMULA_TEXT :'||p_counter_template_tbl(tab_row).FORMULA_TEXT);
1431 PUT_LINE ('ROLLOVER_LAST_READING :'||p_counter_template_tbl(tab_row).ROLLOVER_LAST_READING);
1432 PUT_LINE ('ROLLOVER_FIRST_READING :'||p_counter_template_tbl(tab_row).ROLLOVER_FIRST_READING); PUT_LINE ('USAGE_ITEM_ID :'||p_counter_template_tbl(tab_row).USAGE_ITEM_ID);
1433 PUT_LINE ('CTR_VAL_MAX_SEQ_NO :'||p_counter_template_tbl(tab_row).CTR_VAL_MAX_SEQ_NO);
1434 PUT_LINE ('START_DATE_ACTIVE :'||p_counter_template_tbl(tab_row).START_DATE_ACTIVE);
1435 PUT_LINE ('END_DATE_ACTIVE :'||p_counter_template_tbl(tab_row).END_DATE_ACTIVE);
1436 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_template_tbl(tab_row).OBJECT_VERSION_NUMBER);
1437 PUT_LINE ('ATTRIBUTE1 :'||p_counter_template_tbl(tab_row).ATTRIBUTE1);
1438 PUT_LINE ('ATTRIBUTE2 :'||p_counter_template_tbl(tab_row).ATTRIBUTE2);
1442 PUT_LINE ('ATTRIBUTE6 :'||p_counter_template_tbl(tab_row).ATTRIBUTE6);
1439 PUT_LINE ('ATTRIBUTE3 :'||p_counter_template_tbl(tab_row).ATTRIBUTE3);
1440 PUT_LINE ('ATTRIBUTE4 :'||p_counter_template_tbl(tab_row).ATTRIBUTE4);
1441 PUT_LINE ('ATTRIBUTE5 :'||p_counter_template_tbl(tab_row).ATTRIBUTE5);
1443 PUT_LINE ('ATTRIBUTE7 :'||p_counter_template_tbl(tab_row).ATTRIBUTE7);
1444 PUT_LINE ('ATTRIBUTE8 :'||p_counter_template_tbl(tab_row).ATTRIBUTE8);
1445 PUT_LINE ('ATTRIBUTE9 :'||p_counter_template_tbl(tab_row).ATTRIBUTE9);
1446 PUT_LINE ('ATTRIBUTE10 :'||p_counter_template_tbl(tab_row).ATTRIBUTE10);
1447 PUT_LINE ('ATTRIBUTE11 :'||p_counter_template_tbl(tab_row).ATTRIBUTE11);
1448 PUT_LINE ('ATTRIBUTE12 :'||p_counter_template_tbl(tab_row).ATTRIBUTE12);
1449 PUT_LINE ('ATTRIBUTE13 :'||p_counter_template_tbl(tab_row).ATTRIBUTE13);
1450 PUT_LINE ('ATTRIBUTE14 :'||p_counter_template_tbl(tab_row).ATTRIBUTE14);
1451 PUT_LINE ('ATTRIBUTE15 :'||p_counter_template_tbl(tab_row).ATTRIBUTE15);
1452 PUT_LINE ('ATTRIBUTE16 :'||p_counter_template_tbl(tab_row).ATTRIBUTE16);
1453 PUT_LINE ('ATTRIBUTE17 :'||p_counter_template_tbl(tab_row).ATTRIBUTE17);
1454 PUT_LINE ('ATTRIBUTE18 :'||p_counter_template_tbl(tab_row).ATTRIBUTE18);
1455 PUT_LINE ('ATTRIBUTE19 :'||p_counter_template_tbl(tab_row).ATTRIBUTE19);
1456 PUT_LINE ('ATTRIBUTE20 :'||p_counter_template_tbl(tab_row).ATTRIBUTE20);
1457 PUT_LINE ('ATTRIBUTE21 :'||p_counter_template_tbl(tab_row).ATTRIBUTE21);
1458 PUT_LINE ('ATTRIBUTE22 :'||p_counter_template_tbl(tab_row).ATTRIBUTE22);
1459 PUT_LINE ('ATTRIBUTE23 :'||p_counter_template_tbl(tab_row).ATTRIBUTE23);
1460 PUT_LINE ('ATTRIBUTE24 :'||p_counter_template_tbl(tab_row).ATTRIBUTE24);
1461 PUT_LINE ('ATTRIBUTE25 :'||p_counter_template_tbl(tab_row).ATTRIBUTE25);
1462 PUT_LINE ('ATTRIBUTE26 :'||p_counter_template_tbl(tab_row).ATTRIBUTE26);
1463 PUT_LINE ('ATTRIBUTE27 :'||p_counter_template_tbl(tab_row).ATTRIBUTE27);
1464 PUT_LINE ('ATTRIBUTE28 :'||p_counter_template_tbl(tab_row).ATTRIBUTE28);
1465 PUT_LINE ('ATTRIBUTE29 :'||p_counter_template_tbl(tab_row).ATTRIBUTE29);
1466 PUT_LINE ('ATTRIBUTE30 :'||p_counter_template_tbl(tab_row).ATTRIBUTE30);
1467 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_template_tbl(tab_row).ATTRIBUTE_CATEGORY);
1468 PUT_LINE ('DIRECTION :'||p_counter_template_tbl(tab_row).DIRECTION);
1469 PUT_LINE ('FILTER_TYPE :'||p_counter_template_tbl(tab_row).FILTER_TYPE);
1470 PUT_LINE ('FILTER_READING_COUNT :'||p_counter_template_tbl(tab_row).FILTER_READING_COUNT);
1471 PUT_LINE ('FILTER_TIME_UOM :'||p_counter_template_tbl(tab_row).FILTER_TIME_UOM);
1472 PUT_LINE ('ESTIMATION_ID :'||p_counter_template_tbl(tab_row).ESTIMATION_ID);
1473 PUT_LINE ('READING_TYPE :'||p_counter_template_tbl(tab_row).READING_TYPE);
1474 PUT_LINE ('AUTOMATIC_ROLLOVER :'||p_counter_template_tbl(tab_row).AUTOMATIC_ROLLOVER);
1475 PUT_LINE ('DEFAULT_USAGE_RATE :'||p_counter_template_tbl(tab_row).DEFAULT_USAGE_RATE);
1476 PUT_LINE ('USE_PAST_READING :'||p_counter_template_tbl(tab_row).USE_PAST_READING);
1477 PUT_LINE ('USED_IN_SCHEDULING :'||p_counter_template_tbl(tab_row).USED_IN_SCHEDULING);
1478 PUT_LINE ('DEFAULTED_GROUP_ID :'||p_counter_template_tbl(tab_row).DEFAULTED_GROUP_ID);
1479 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_template_tbl(tab_row).SECURITY_GROUP_ID);
1480 PUT_LINE ('NAME :'||p_counter_template_tbl(tab_row).NAME);
1481 PUT_LINE ('DESCRIPTION :'||p_counter_template_tbl(tab_row).DESCRIPTION);
1482 PUT_LINE ('COMMENTS :'||p_counter_template_tbl(tab_row).COMMENTS);
1483 PUT_LINE ('ASSOCIATION_TYPE :'||p_counter_template_tbl(tab_row).ASSOCIATION_TYPE);
1484 PUT_LINE ('STEP_VALUE :'||p_counter_template_tbl(tab_row).STEP_VALUE);
1485 PUT_LINE ('TIME_BASED_MANUAL_ENTRY :'||p_counter_template_tbl(tab_row).TIME_BASED_MANUAL_ENTRY);
1486 PUT_LINE ('EAM_REQUIRED_FLAG :'||p_counter_template_tbl(tab_row).EAM_REQUIRED_FLAG);
1487
1488 END IF;
1489 END LOOP;
1490 END IF;
1491 EXCEPTION
1492 WHEN OTHERS THEN
1493 ROLLBACK TO dump_ctr_template_tbl;
1494 IF FND_MSG_PUB.Check_Msg_Level
1495 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1496 THEN
1497 FND_MSG_PUB.Add_Exc_Msg
1498 (g_pkg_name,
1499 l_api_name);
1500 END IF;
1501 END dump_ctr_template_tbl;
1502
1503
1504 PROCEDURE dump_ctr_item_assoc_rec
1505 (p_ctr_item_associations_rec IN csi_ctr_datastructures_pub.ctr_item_associations_rec) IS
1506
1507 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_item_assoc_rec';
1508 l_api_version CONSTANT NUMBER := 1.0;
1509 BEGIN
1510 SAVEPOINT dump_ctr_item_assoc_rec;
1511
1512 -- Read the debug profiles values in to global variable 7197402
1513 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1514
1515 PUT_LINE (' ');
1516 PUT_LINE ('Dumping the values for Counter Item Association Record:');
1517 PUT_LINE (' ');
1518
1519 PUT_LINE ('CTR_ASSOCIATION_ID :'||p_ctr_item_associations_rec.CTR_ASSOCIATION_ID);
1523 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_item_associations_rec.ATTRIBUTE1);
1520 PUT_LINE ('GROUP_ID :'||p_ctr_item_associations_rec.GROUP_ID);
1521 PUT_LINE ('INVENTORY_ITEM_ID :'||p_ctr_item_associations_rec.INVENTORY_ITEM_ID);
1522 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_item_associations_rec.OBJECT_VERSION_NUMBER);
1524 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_item_associations_rec.ATTRIBUTE2);
1525 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_item_associations_rec.ATTRIBUTE3);
1526 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_item_associations_rec.ATTRIBUTE4);
1527 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_item_associations_rec.ATTRIBUTE5);
1528 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_item_associations_rec.ATTRIBUTE6);
1529 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_item_associations_rec.ATTRIBUTE7);
1530 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_item_associations_rec.ATTRIBUTE8);
1531 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_item_associations_rec.ATTRIBUTE9);
1532 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_item_associations_rec.ATTRIBUTE10);
1533 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_item_associations_rec.ATTRIBUTE11);
1534 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_item_associations_rec.ATTRIBUTE12);
1535 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_item_associations_rec.ATTRIBUTE13);
1536 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_item_associations_rec.ATTRIBUTE14);
1537 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_item_associations_rec.ATTRIBUTE15);
1538 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_item_associations_rec.ATTRIBUTE_CATEGORY);
1539 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_item_associations_rec.SECURITY_GROUP_ID);
1540 PUT_LINE ('COUNTER_ID :'||p_ctr_item_associations_rec.COUNTER_ID);
1541 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_item_associations_rec.START_DATE_ACTIVE);
1542 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_item_associations_rec.END_DATE_ACTIVE);
1543 PUT_LINE ('USAGE_RATE :'||p_ctr_item_associations_rec.USAGE_RATE);
1544 -- PUT_LINE ('ASSOCIATION_TYPE :'||p_ctr_item_associations_rec.ASSOCIATION_TYPE);
1545 PUT_LINE ('USE_PAST_READING :'||p_ctr_item_associations_rec.USE_PAST_READING);
1546 PUT_LINE ('ASSOCIATED_TO_GROUP :'||p_ctr_item_associations_rec.ASSOCIATED_TO_GROUP);
1547 PUT_LINE ('MAINT_ORGANIZATION_ID :'||p_ctr_item_associations_rec.MAINT_ORGANIZATION_ID);
1548 PUT_LINE ('PRIMARY_FAILURE_FLAG :'||p_ctr_item_associations_rec.PRIMARY_FAILURE_FLAG);
1549
1550 EXCEPTION
1551 WHEN OTHERS THEN
1552 ROLLBACK TO dump_ctr_item_assoc_rec;
1553 IF FND_MSG_PUB.Check_Msg_Level
1554 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1555 THEN
1556 FND_MSG_PUB.Add_Exc_Msg
1557 (g_pkg_name,
1558 l_api_name);
1559 END IF;
1560 END dump_ctr_item_assoc_rec;
1561
1562 PROCEDURE dump_ctr_item_assoc_tbl
1563 (p_ctr_item_associations_tbl IN csi_ctr_datastructures_pub.ctr_item_associations_tbl) IS
1564
1565
1566 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_item_assoc_tbl';
1567 l_api_version CONSTANT NUMBER := 1.0;
1568 BEGIN
1569 SAVEPOINT dump_ctr_item_assoc_tbl;
1570
1571 -- Read the debug profiles values in to global variable 7197402
1572 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1573
1574 IF p_ctr_item_associations_tbl.COUNT > 0 THEN
1575 FOR tab_row IN p_ctr_item_associations_tbl.FIRST .. p_ctr_item_associations_tbl.LAST
1576 LOOP
1577 IF p_ctr_item_associations_tbl.EXISTS(tab_row) THEN
1578
1579 PUT_LINE (' ');
1580 PUT_LINE ('Dumping the values for Counter Item Association Table Record # : '||tab_row);
1581 PUT_LINE (' ');
1582
1583 PUT_LINE ('CTR_ASSOCIATION_ID :'||p_ctr_item_associations_tbl(tab_row).CTR_ASSOCIATION_ID);
1584 PUT_LINE ('GROUP_ID :'||p_ctr_item_associations_tbl(tab_row).GROUP_ID);
1585 PUT_LINE ('INVENTORY_ITEM_ID :'||p_ctr_item_associations_tbl(tab_row).INVENTORY_ITEM_ID);
1586 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_item_associations_tbl(tab_row).OBJECT_VERSION_NUMBER);
1587 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE1);
1588 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE2);
1589 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE3);
1590 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE4);
1591 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE5);
1592 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE6);
1593 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE7);
1594 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE8);
1595 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE9);
1596 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE10);
1597 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE11);
1598 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE12);
1599 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE13);
1600 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE14);
1601 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE15);
1602 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE_CATEGORY);
1603 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_item_associations_tbl(tab_row).SECURITY_GROUP_ID);
1607 PUT_LINE ('USAGE_RATE :'||p_ctr_item_associations_tbl(tab_row).USAGE_RATE);
1604 PUT_LINE ('COUNTER_ID :'||p_ctr_item_associations_tbl(tab_row).COUNTER_ID);
1605 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_item_associations_tbl(tab_row).START_DATE_ACTIVE);
1606 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_item_associations_tbl(tab_row).END_DATE_ACTIVE);
1608 -- PUT_LINE ('ASSOCIATION_TYPE :'||p_ctr_item_associations_tbl(tab_row).ASSOCIATION_TYPE);
1609 PUT_LINE ('USE_PAST_READING :'||p_ctr_item_associations_tbl(tab_row).USE_PAST_READING);
1610 PUT_LINE ('ASSOCIATED_TO_GROUP :'||p_ctr_item_associations_tbl(tab_row).ASSOCIATED_TO_GROUP);
1611 PUT_LINE ('MAINT_ORGANIZATION_ID :'||p_ctr_item_associations_tbl(tab_row).MAINT_ORGANIZATION_ID);
1612 PUT_LINE ('PRIMARY_FAILURE_FLAG :'||p_ctr_item_associations_tbl(tab_row).PRIMARY_FAILURE_FLAG);
1613
1614 END IF;
1615 END LOOP;
1616 END IF;
1617 EXCEPTION
1618 WHEN OTHERS THEN
1619 ROLLBACK TO dump_ctr_item_assoc_tbl;
1620 IF FND_MSG_PUB.Check_Msg_Level
1621 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1622 THEN
1623 FND_MSG_PUB.Add_Exc_Msg
1624 (g_pkg_name,
1625 l_api_name);
1626 END IF;
1627 END dump_ctr_item_assoc_tbl;
1628
1629 PROCEDURE dump_ctr_relationship_rec
1630 (p_counter_relationships_rec IN csi_ctr_datastructures_pub.counter_relationships_rec) IS
1631
1632 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_relationship_rec';
1633 l_api_version CONSTANT NUMBER := 1.0;
1634
1635 BEGIN
1636 SAVEPOINT dump_ctr_relationship_rec;
1637
1638 -- Read the debug profiles values in to global variable 7197402
1639 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1640
1641 PUT_LINE (' ');
1642 PUT_LINE ('Dumping the values for Counter Relationships Record:');
1643 PUT_LINE (' ');
1644
1645 PUT_LINE ('RELATIONSHIP_ID :'||p_counter_relationships_rec.RELATIONSHIP_ID);
1646 PUT_LINE ('CTR_ASSOCIATION_ID :'||p_counter_relationships_rec.CTR_ASSOCIATION_ID);
1647 PUT_LINE ('RELATIONSHIP_TYPE_CODE :'||p_counter_relationships_rec.RELATIONSHIP_TYPE_CODE);
1648 PUT_LINE ('SOURCE_COUNTER_ID :'||p_counter_relationships_rec.SOURCE_COUNTER_ID);
1649 PUT_LINE ('OBJECT_COUNTER_ID :'||p_counter_relationships_rec.OBJECT_COUNTER_ID);
1650 PUT_LINE ('ACTIVE_START_DATE :'||p_counter_relationships_rec.ACTIVE_START_DATE);
1651 PUT_LINE ('ACTIVE_END_DATE :'||p_counter_relationships_rec.ACTIVE_END_DATE);
1652 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_relationships_rec.OBJECT_VERSION_NUMBER);
1653 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_relationships_rec.ATTRIBUTE_CATEGORY);
1654 PUT_LINE ('ATTRIBUTE1 :'||p_counter_relationships_rec.ATTRIBUTE1);
1655 PUT_LINE ('ATTRIBUTE2 :'||p_counter_relationships_rec.ATTRIBUTE2);
1656 PUT_LINE ('ATTRIBUTE3 :'||p_counter_relationships_rec.ATTRIBUTE3);
1657 PUT_LINE ('ATTRIBUTE4 :'||p_counter_relationships_rec.ATTRIBUTE4);
1658 PUT_LINE ('ATTRIBUTE5 :'||p_counter_relationships_rec.ATTRIBUTE5);
1659 PUT_LINE ('ATTRIBUTE6 :'||p_counter_relationships_rec.ATTRIBUTE6);
1660 PUT_LINE ('ATTRIBUTE7 :'||p_counter_relationships_rec.ATTRIBUTE7);
1661 PUT_LINE ('ATTRIBUTE8 :'||p_counter_relationships_rec.ATTRIBUTE8);
1662 PUT_LINE ('ATTRIBUTE9 :'||p_counter_relationships_rec.ATTRIBUTE9);
1663 PUT_LINE ('ATTRIBUTE10 :'||p_counter_relationships_rec.ATTRIBUTE10);
1664 PUT_LINE ('ATTRIBUTE11 :'||p_counter_relationships_rec.ATTRIBUTE11);
1665 PUT_LINE ('ATTRIBUTE12 :'||p_counter_relationships_rec.ATTRIBUTE12);
1666 PUT_LINE ('ATTRIBUTE13 :'||p_counter_relationships_rec.ATTRIBUTE13);
1667 PUT_LINE ('ATTRIBUTE14 :'||p_counter_relationships_rec.ATTRIBUTE14);
1668 PUT_LINE ('ATTRIBUTE15 :'||p_counter_relationships_rec.ATTRIBUTE15);
1669 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_relationships_rec.SECURITY_GROUP_ID);
1670 PUT_LINE ('BIND_VARIABLE_NAME :'||p_counter_relationships_rec.BIND_VARIABLE_NAME);
1671 PUT_LINE ('FACTOR :'||p_counter_relationships_rec.FACTOR);
1672 EXCEPTION
1673 WHEN OTHERS THEN
1674 ROLLBACK TO dump_ctr_relationship_rec;
1675 IF FND_MSG_PUB.Check_Msg_Level
1676 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1677 THEN
1678 FND_MSG_PUB.Add_Exc_Msg
1679 (g_pkg_name,
1680 l_api_name);
1681 END IF;
1682 END dump_ctr_relationship_rec;
1683
1684 PROCEDURE dump_ctr_relationship_tbl
1685 (p_counter_relationships_tbl IN csi_ctr_datastructures_pub.counter_relationships_tbl) IS
1686
1687
1688 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_relationship_tbl';
1689 l_api_version CONSTANT NUMBER := 1.0;
1690
1691 BEGIN
1692 SAVEPOINT dump_ctr_relationship_tbl;
1693
1694 -- Read the debug profiles values in to global variable 7197402
1695 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1696
1697 IF p_counter_relationships_tbl.COUNT > 0 THEN
1698 FOR tab_row IN p_counter_relationships_tbl.FIRST .. p_counter_relationships_tbl.LAST
1699 LOOP
1700 IF p_counter_relationships_tbl.EXISTS(tab_row) THEN
1701
1702 PUT_LINE (' ');
1703 PUT_LINE ('Dumping the values for Counter Relationship Table Record # : '||tab_row);
1704 PUT_LINE (' ');
1705
1706 PUT_LINE ('RELATIONSHIP_ID :'||p_counter_relationships_tbl(tab_row).RELATIONSHIP_ID);
1710 PUT_LINE ('OBJECT_COUNTER_ID :'||p_counter_relationships_tbl(tab_row).OBJECT_COUNTER_ID);
1707 PUT_LINE ('CTR_ASSOCIATION_ID :'||p_counter_relationships_tbl(tab_row).CTR_ASSOCIATION_ID);
1708 PUT_LINE ('RELATIONSHIP_TYPE_CODE :'||p_counter_relationships_tbl(tab_row).RELATIONSHIP_TYPE_CODE);
1709 PUT_LINE ('SOURCE_COUNTER_ID :'||p_counter_relationships_tbl(tab_row).SOURCE_COUNTER_ID);
1711 PUT_LINE ('ACTIVE_START_DATE :'||p_counter_relationships_tbl(tab_row).ACTIVE_START_DATE);
1712 PUT_LINE ('ACTIVE_END_DATE :'||p_counter_relationships_tbl(tab_row).ACTIVE_END_DATE);
1713 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_relationships_tbl(tab_row).OBJECT_VERSION_NUMBER);
1714 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE_CATEGORY);
1715 PUT_LINE ('ATTRIBUTE1 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE1);
1716 PUT_LINE ('ATTRIBUTE2 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE2);
1717 PUT_LINE ('ATTRIBUTE3 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE3);
1718 PUT_LINE ('ATTRIBUTE4 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE4);
1719 PUT_LINE ('ATTRIBUTE5 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE5);
1720 PUT_LINE ('ATTRIBUTE6 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE6);
1721 PUT_LINE ('ATTRIBUTE7 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE7);
1722 PUT_LINE ('ATTRIBUTE8 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE8);
1723 PUT_LINE ('ATTRIBUTE9 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE9);
1724 PUT_LINE ('ATTRIBUTE10 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE10);
1725 PUT_LINE ('ATTRIBUTE11 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE11);
1726 PUT_LINE ('ATTRIBUTE12 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE12);
1727 PUT_LINE ('ATTRIBUTE13 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE13);
1728 PUT_LINE ('ATTRIBUTE14 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE14);
1729 PUT_LINE ('ATTRIBUTE15 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE15);
1730 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_relationships_tbl(tab_row).SECURITY_GROUP_ID);
1731 PUT_LINE ('BIND_VARIABLE_NAME :'||p_counter_relationships_tbl(tab_row).BIND_VARIABLE_NAME);
1732 PUT_LINE ('FACTOR :'||p_counter_relationships_tbl(tab_row).FACTOR);
1733
1734 END IF;
1735 END LOOP;
1736 END IF;
1737 EXCEPTION
1738 WHEN OTHERS THEN
1739 ROLLBACK TO dump_ctr_relationship_tbl;
1740 IF FND_MSG_PUB.Check_Msg_Level
1741 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1742 THEN
1743 FND_MSG_PUB.Add_Exc_Msg
1744 (g_pkg_name,
1745 l_api_name);
1746 END IF;
1747 END dump_ctr_relationship_tbl;
1748
1749 PROCEDURE dump_ctr_property_template_rec
1750 (p_ctr_property_template_rec IN csi_ctr_datastructures_pub.ctr_property_template_rec) IS
1751 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_property_template_rec';
1752 l_api_version CONSTANT NUMBER := 1.0;
1753
1754 BEGIN
1755 SAVEPOINT dump_ctr_property_template_rec;
1756
1757 -- Read the debug profiles values in to global variable 7197402
1758 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1759
1760 PUT_LINE (' ');
1761 PUT_LINE ('Dumping the values for Counter Property Template Record:');
1762 PUT_LINE (' ');
1763
1764 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_property_template_rec.COUNTER_PROPERTY_ID);
1765 PUT_LINE ('COUNTER_ID :'||p_ctr_property_template_rec.COUNTER_ID);
1766 PUT_LINE ('PROPERTY_DATA_TYPE :'||p_ctr_property_template_rec.PROPERTY_DATA_TYPE);
1767 PUT_LINE ('IS_NULLABLE :'||p_ctr_property_template_rec.IS_NULLABLE);
1768 PUT_LINE ('DEFAULT_VALUE :'||p_ctr_property_template_rec.DEFAULT_VALUE);
1769 PUT_LINE ('MINIMUM_VALUE :'||p_ctr_property_template_rec.MINIMUM_VALUE);
1770 PUT_LINE ('MAXIMUM_VALUE :'||p_ctr_property_template_rec.MAXIMUM_VALUE);
1771 PUT_LINE ('UOM_CODE :'||p_ctr_property_template_rec.UOM_CODE);
1772 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_property_template_rec.START_DATE_ACTIVE);
1773 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_property_template_rec.END_DATE_ACTIVE);
1774 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_property_template_rec.OBJECT_VERSION_NUMBER);
1775 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_property_template_rec.ATTRIBUTE1);
1776 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_property_template_rec.ATTRIBUTE2);
1777 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_property_template_rec.ATTRIBUTE3);
1778 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_property_template_rec.ATTRIBUTE4);
1779 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_property_template_rec.ATTRIBUTE5);
1780 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_property_template_rec.ATTRIBUTE6);
1781 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_property_template_rec.ATTRIBUTE7);
1782 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_property_template_rec.ATTRIBUTE8);
1783 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_property_template_rec.ATTRIBUTE9);
1784 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_property_template_rec.ATTRIBUTE10);
1785 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_property_template_rec.ATTRIBUTE11);
1786 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_property_template_rec.ATTRIBUTE12);
1787 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_property_template_rec.ATTRIBUTE13);
1788 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_property_template_rec.ATTRIBUTE14);
1789 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_property_template_rec.ATTRIBUTE15);
1793 PUT_LINE ('NAME :'||p_ctr_property_template_rec.NAME);
1790 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_property_template_rec.ATTRIBUTE_CATEGORY);
1791 PUT_LINE ('PROPERTY_LOV_TYPE :'||p_ctr_property_template_rec.PROPERTY_LOV_TYPE);
1792 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_property_template_rec.SECURITY_GROUP_ID);
1794 PUT_LINE ('DESCRIPTION :'||p_ctr_property_template_rec.DESCRIPTION);
1795
1796 EXCEPTION
1797 WHEN OTHERS THEN
1798 ROLLBACK TO dump_ctr_property_template_rec;
1799 IF FND_MSG_PUB.Check_Msg_Level
1800 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1801 THEN
1802 FND_MSG_PUB.Add_Exc_Msg
1803 (g_pkg_name,
1804 l_api_name);
1805 END IF;
1806 END dump_ctr_property_template_rec;
1807
1808 PROCEDURE dump_ctr_property_template_tbl
1809 (p_ctr_property_template_tbl IN csi_ctr_datastructures_pub.ctr_property_template_tbl) IS
1810
1811 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_property_template_tbl';
1812 l_api_version CONSTANT NUMBER := 1.0;
1813
1814 BEGIN
1815 SAVEPOINT dump_ctr_property_template_tbl;
1816
1817 -- Read the debug profiles values in to global variable 7197402
1818 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1819
1820 IF p_ctr_property_template_tbl.COUNT > 0 THEN
1821 FOR tab_row IN p_ctr_property_template_tbl.FIRST .. p_ctr_property_template_tbl.LAST
1822 LOOP
1823 IF p_ctr_property_template_tbl.EXISTS(tab_row) THEN
1824
1825 PUT_LINE (' ');
1826 PUT_LINE ('Dumping the values for Counter Property Template Table Record # : '||tab_row);
1827 PUT_LINE (' ');
1828
1829 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_property_template_tbl(tab_row).COUNTER_PROPERTY_ID);
1830 PUT_LINE ('COUNTER_ID :'||p_ctr_property_template_tbl(tab_row).COUNTER_ID);
1831 PUT_LINE ('PROPERTY_DATA_TYPE :'||p_ctr_property_template_tbl(tab_row).PROPERTY_DATA_TYPE);
1832 PUT_LINE ('IS_NULLABLE :'||p_ctr_property_template_tbl(tab_row).IS_NULLABLE);
1833 PUT_LINE ('DEFAULT_VALUE :'||p_ctr_property_template_tbl(tab_row).DEFAULT_VALUE);
1834 PUT_LINE ('MINIMUM_VALUE :'||p_ctr_property_template_tbl(tab_row).MINIMUM_VALUE);
1835 PUT_LINE ('MAXIMUM_VALUE :'||p_ctr_property_template_tbl(tab_row).MAXIMUM_VALUE);
1836 PUT_LINE ('UOM_CODE :'||p_ctr_property_template_tbl(tab_row).UOM_CODE);
1837 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_property_template_tbl(tab_row).START_DATE_ACTIVE);
1838 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_property_template_tbl(tab_row).END_DATE_ACTIVE);
1839 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_property_template_tbl(tab_row).OBJECT_VERSION_NUMBER);
1840 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE1);
1841 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE2);
1842 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE3);
1843 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE4);
1844 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE5);
1845 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE6);
1846 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE7);
1847 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE8);
1848 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE9);
1849 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE10);
1850 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE11);
1851 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE12);
1852 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE13);
1853 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE14);
1854 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE15);
1855 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE_CATEGORY);
1856 PUT_LINE ('PROPERTY_LOV_TYPE :'||p_ctr_property_template_tbl(tab_row).PROPERTY_LOV_TYPE);
1857 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_property_template_tbl(tab_row).SECURITY_GROUP_ID);
1858 PUT_LINE ('NAME :'||p_ctr_property_template_tbl(tab_row).NAME);
1859 PUT_LINE ('DESCRIPTION :'||p_ctr_property_template_tbl(tab_row).DESCRIPTION);
1860
1861 END IF;
1862 END LOOP;
1863 END IF;
1864 EXCEPTION
1865 WHEN OTHERS THEN
1866 ROLLBACK TO dump_ctr_property_template_tbl;
1867 IF FND_MSG_PUB.Check_Msg_Level
1868 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1869 THEN
1870 FND_MSG_PUB.Add_Exc_Msg
1871 (g_pkg_name,
1872 l_api_name);
1873 END IF;
1874 END dump_ctr_property_template_tbl;
1875
1876 PROCEDURE dm_ctr_estimation_methods_rec
1877 (p_ctr_estimation_methods_rec IN csi_ctr_datastructures_pub.ctr_estimation_methods_rec) IS
1878 l_api_name CONSTANT VARCHAR2(30) := 'dm_ctr_estimation_methods_rec';
1879 l_api_version CONSTANT NUMBER := 1.0;
1880 BEGIN
1881 SAVEPOINT dm_ctr_estimation_methods_rec;
1882
1883 -- Read the debug profiles values in to global variable 7197402
1884 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1885
1886 PUT_LINE (' ');
1887 PUT_LINE ('Dumping the values for Counter Estimation Methods Record:');
1888 PUT_LINE (' ');
1889
1890 PUT_LINE ('ESTIMATION_ID :'||p_ctr_estimation_methods_rec.ESTIMATION_ID);
1894 PUT_LINE ('DEFAULT_VALUE :'||p_ctr_estimation_methods_rec.DEFAULT_VALUE);
1891 PUT_LINE ('ESTIMATION_TYPE :'||p_ctr_estimation_methods_rec.ESTIMATION_TYPE);
1892 PUT_LINE ('FIXED_VALUE :'||p_ctr_estimation_methods_rec.FIXED_VALUE);
1893 PUT_LINE ('USAGE_MARKUP :'||p_ctr_estimation_methods_rec.USAGE_MARKUP);
1895 PUT_LINE ('ESTIMATION_AVG_TYPE :'||p_ctr_estimation_methods_rec.ESTIMATION_AVG_TYPE);
1896 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_estimation_methods_rec.START_DATE_ACTIVE);
1897 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_estimation_methods_rec.END_DATE_ACTIVE);
1898 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_estimation_methods_rec.ATTRIBUTE1);
1899 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_estimation_methods_rec.ATTRIBUTE2);
1900 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_estimation_methods_rec.ATTRIBUTE3);
1901 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_estimation_methods_rec.ATTRIBUTE4);
1902 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_estimation_methods_rec.ATTRIBUTE5);
1903 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_estimation_methods_rec.ATTRIBUTE6);
1904 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_estimation_methods_rec.ATTRIBUTE7);
1905 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_estimation_methods_rec.ATTRIBUTE8);
1906 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_estimation_methods_rec.ATTRIBUTE9);
1907 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_estimation_methods_rec.ATTRIBUTE10);
1908 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_estimation_methods_rec.ATTRIBUTE11);
1909 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_estimation_methods_rec.ATTRIBUTE12);
1910 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_estimation_methods_rec.ATTRIBUTE13);
1911 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_estimation_methods_rec.ATTRIBUTE14);
1912 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_estimation_methods_rec.ATTRIBUTE15);
1913 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_estimation_methods_rec.ATTRIBUTE_CATEGORY);
1914 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_estimation_methods_rec.OBJECT_VERSION_NUMBER);
1915 PUT_LINE ('NAME :'||p_ctr_estimation_methods_rec.NAME);
1916 PUT_LINE ('DESCRIPTION :'||p_ctr_estimation_methods_rec.DESCRIPTION);
1917 EXCEPTION
1918 WHEN OTHERS THEN
1919 ROLLBACK TO dm_ctr_estimation_methods_rec;
1920 IF FND_MSG_PUB.Check_Msg_Level
1921 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1922 THEN
1923 FND_MSG_PUB.Add_Exc_Msg
1924 (g_pkg_name,
1925 l_api_name);
1926 END IF;
1927 END dm_ctr_estimation_methods_rec;
1928
1929 PROCEDURE dm_ctr_estimation_methods_tbl
1930 (p_ctr_estimation_methods_tbl IN csi_ctr_datastructures_pub.ctr_estimation_methods_tbl) IS
1931 l_api_name CONSTANT VARCHAR2(30) := 'dm_ctr_estimation_methods_tbl';
1932 l_api_version CONSTANT NUMBER := 1.0;
1933
1934 BEGIN
1935 SAVEPOINT dm_ctr_estimation_methods_tbl;
1936
1937 -- Read the debug profiles values in to global variable 7197402
1938 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1939
1940 IF p_ctr_estimation_methods_tbl.COUNT > 0 THEN
1941 FOR tab_row IN p_ctr_estimation_methods_tbl.FIRST .. p_ctr_estimation_methods_tbl.LAST
1942 LOOP
1943 IF p_ctr_estimation_methods_tbl.EXISTS(tab_row) THEN
1944
1945 PUT_LINE (' ');
1946 PUT_LINE ('Dumping the values for Counter Estimation Methods Table Record # : '||tab_row);
1947 PUT_LINE (' ');
1948
1949 PUT_LINE ('ESTIMATION_ID :'||p_ctr_estimation_methods_tbl(tab_row).ESTIMATION_ID);
1950 PUT_LINE ('ESTIMATION_TYPE :'||p_ctr_estimation_methods_tbl(tab_row).ESTIMATION_TYPE);
1951 PUT_LINE ('FIXED_VALUE :'||p_ctr_estimation_methods_tbl(tab_row).FIXED_VALUE);
1952 PUT_LINE ('USAGE_MARKUP :'||p_ctr_estimation_methods_tbl(tab_row).USAGE_MARKUP);
1953 PUT_LINE ('DEFAULT_VALUE :'||p_ctr_estimation_methods_tbl(tab_row).DEFAULT_VALUE);
1954 PUT_LINE ('ESTIMATION_AVG_TYPE :'||p_ctr_estimation_methods_tbl(tab_row).ESTIMATION_AVG_TYPE);
1955 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_estimation_methods_tbl(tab_row).START_DATE_ACTIVE);
1956 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_estimation_methods_tbl(tab_row).END_DATE_ACTIVE);
1957 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE1);
1958 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE2);
1959 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE3);
1960 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE4);
1961 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE5);
1962 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE6);
1963 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE7);
1964 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE8);
1965 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE9);
1966 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE10);
1967 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE11);
1968 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE12);
1969 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE13);
1970 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE14);
1971 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE15);
1972 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE_CATEGORY);
1976
1973 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_estimation_methods_tbl(tab_row).OBJECT_VERSION_NUMBER);
1974 PUT_LINE ('NAME :'||p_ctr_estimation_methods_tbl(tab_row).NAME);
1975 PUT_LINE ('DESCRIPTION :'||p_ctr_estimation_methods_tbl(tab_row).DESCRIPTION);
1977 END IF;
1978 END LOOP;
1979 END IF;
1980 EXCEPTION
1981 WHEN OTHERS THEN
1982 ROLLBACK TO dm_ctr_estimation_methods_tbl;
1983 IF FND_MSG_PUB.Check_Msg_Level
1984 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1985 THEN
1986 FND_MSG_PUB.Add_Exc_Msg
1987 (g_pkg_name,
1988 l_api_name);
1989 END IF;
1990 END dm_ctr_estimation_methods_tbl;
1991
1992 PROCEDURE dump_ctr_derived_filters_rec
1993 (p_ctr_derived_filters_rec IN csi_ctr_datastructures_pub.ctr_derived_filters_rec) IS
1994 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_derived_filters_rec';
1995 l_api_version CONSTANT NUMBER := 1.0;
1996 BEGIN
1997 SAVEPOINT dump_ctr_derived_filters_rec;
1998
1999 -- Read the debug profiles values in to global variable 7197402
2000 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2001
2002 PUT_LINE (' ');
2003 PUT_LINE ('Dumping the values for Counter Derived Filters Record:');
2004 PUT_LINE (' ');
2005
2006 PUT_LINE ('COUNTER_DERIVED_FILTER_ID :'||p_ctr_derived_filters_rec.COUNTER_DERIVED_FILTER_ID);
2007 PUT_LINE ('COUNTER_ID :'||p_ctr_derived_filters_rec.COUNTER_ID);
2008 PUT_LINE ('SEQ_NO :'||p_ctr_derived_filters_rec.SEQ_NO);
2009 PUT_LINE ('LEFT_PARENT :'||p_ctr_derived_filters_rec.LEFT_PARENT);
2010 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_derived_filters_rec.COUNTER_PROPERTY_ID);
2011 PUT_LINE ('RELATIONAL_OPERATOR :'||p_ctr_derived_filters_rec.RELATIONAL_OPERATOR);
2012 PUT_LINE ('RIGHT_VALUE :'||p_ctr_derived_filters_rec.RIGHT_VALUE);
2013 PUT_LINE ('RIGHT_PARENT :'||p_ctr_derived_filters_rec.RIGHT_PARENT);
2014 PUT_LINE ('LOGICAL_OPERATOR :'||p_ctr_derived_filters_rec.LOGICAL_OPERATOR );
2015 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_derived_filters_rec.START_DATE_ACTIVE);
2016 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_derived_filters_rec.END_DATE_ACTIVE);
2017 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_derived_filters_rec.OBJECT_VERSION_NUMBER);
2018 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_derived_filters_rec.ATTRIBUTE1);
2019 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_derived_filters_rec.ATTRIBUTE2);
2020 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_derived_filters_rec.ATTRIBUTE3);
2021 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_derived_filters_rec.ATTRIBUTE4);
2022 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_derived_filters_rec.ATTRIBUTE5);
2023 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_derived_filters_rec.ATTRIBUTE6);
2024 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_derived_filters_rec.ATTRIBUTE7);
2025 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_derived_filters_rec.ATTRIBUTE8);
2026 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_derived_filters_rec.ATTRIBUTE9);
2027 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_derived_filters_rec.ATTRIBUTE10);
2028 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_derived_filters_rec.ATTRIBUTE11);
2029 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_derived_filters_rec.ATTRIBUTE12);
2030 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_derived_filters_rec.ATTRIBUTE13);
2031 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_derived_filters_rec.ATTRIBUTE14);
2032 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_derived_filters_rec.ATTRIBUTE15);
2033 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_derived_filters_rec.ATTRIBUTE_CATEGORY);
2034 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_derived_filters_rec.SECURITY_GROUP_ID);
2035 EXCEPTION
2036 WHEN OTHERS THEN
2037 ROLLBACK TO dump_ctr_derived_filters_rec;
2038 IF FND_MSG_PUB.Check_Msg_Level
2039 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2040 THEN
2041 FND_MSG_PUB.Add_Exc_Msg
2042 (g_pkg_name,
2043 l_api_name);
2044 END IF;
2045 END dump_ctr_derived_filters_rec;
2046
2047 PROCEDURE dump_ctr_derived_filters_tbl
2048 (p_ctr_derived_filters_tbl IN csi_ctr_datastructures_pub.ctr_derived_filters_tbl) IS
2049 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_derived_filters_tbl';
2050 l_api_version CONSTANT NUMBER := 1.0;
2051
2052 BEGIN
2053 SAVEPOINT dump_ctr_derived_filters_tbl;
2054
2055 -- Read the debug profiles values in to global variable 7197402
2056 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2057
2058 IF p_ctr_derived_filters_tbl.COUNT > 0 THEN
2059 FOR tab_row IN p_ctr_derived_filters_tbl.FIRST .. p_ctr_derived_filters_tbl.LAST
2060 LOOP
2061 IF p_ctr_derived_filters_tbl.EXISTS(tab_row) THEN
2062
2063 PUT_LINE (' ');
2064 PUT_LINE ('Dumping the values for Counter Derived Filters Table Record # : '||tab_row);
2065 PUT_LINE (' ');
2066
2067 PUT_LINE ('COUNTER_DERIVED_FILTER_ID :'||p_ctr_derived_filters_tbl(tab_row).COUNTER_DERIVED_FILTER_ID);
2068 PUT_LINE ('COUNTER_ID :'||p_ctr_derived_filters_tbl(tab_row).COUNTER_ID);
2069 PUT_LINE ('SEQ_NO :'||p_ctr_derived_filters_tbl(tab_row).SEQ_NO);
2070 PUT_LINE ('LEFT_PARENT :'||p_ctr_derived_filters_tbl(tab_row).LEFT_PARENT);
2071 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_derived_filters_tbl(tab_row).COUNTER_PROPERTY_ID);
2072 PUT_LINE ('RELATIONAL_OPERATOR :'||p_ctr_derived_filters_tbl(tab_row).RELATIONAL_OPERATOR);
2076 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_derived_filters_tbl(tab_row).START_DATE_ACTIVE);
2073 PUT_LINE ('RIGHT_VALUE :'||p_ctr_derived_filters_tbl(tab_row).RIGHT_VALUE);
2074 PUT_LINE ('RIGHT_PARENT :'||p_ctr_derived_filters_tbl(tab_row).RIGHT_PARENT);
2075 PUT_LINE ('LOGICAL_OPERATOR :'||p_ctr_derived_filters_tbl(tab_row).LOGICAL_OPERATOR );
2077 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_derived_filters_tbl(tab_row).END_DATE_ACTIVE);
2078 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_derived_filters_tbl(tab_row).OBJECT_VERSION_NUMBER);
2079 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE1);
2080 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE2);
2081 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE3);
2082 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE4);
2083 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE5);
2084 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE6);
2085 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE7);
2086 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE8);
2087 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE9);
2088 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE10);
2089 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE11);
2090 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE12);
2091 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE13);
2092 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE14);
2093 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE15);
2094 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE_CATEGORY);
2095 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_derived_filters_tbl(tab_row).SECURITY_GROUP_ID);
2096
2097 END IF;
2098 END LOOP;
2099 END IF;
2100 EXCEPTION
2101 WHEN OTHERS THEN
2102 ROLLBACK TO dump_ctr_derived_filters_tbl;
2103 IF FND_MSG_PUB.Check_Msg_Level
2104 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2105 THEN
2106 FND_MSG_PUB.Add_Exc_Msg
2107 (g_pkg_name,
2108 l_api_name);
2109 END IF;
2110 END dump_ctr_derived_filters_tbl;
2111
2112 PROCEDURE dump_counter_instance_rec
2113 (p_counter_instance_rec IN csi_ctr_datastructures_pub.counter_instance_rec) IS
2114 l_api_name CONSTANT VARCHAR2(30) := 'dump_counter_instance_rec';
2115 l_api_version CONSTANT NUMBER := 1.0;
2116 BEGIN
2117 SAVEPOINT dump_counter_instance_rec;
2118
2119 -- Read the debug profiles values in to global variable 7197402
2120 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2121
2122 PUT_LINE (' ');
2123 PUT_LINE ('Dumping the values for Counter Instance Record:');
2124 PUT_LINE (' ');
2125
2126 PUT_LINE ('COUNTER_ID :'||p_counter_instance_rec.COUNTER_ID);
2127 PUT_LINE ('GROUP_ID :'||p_counter_instance_rec.GROUP_ID);
2128 PUT_LINE ('DESCRIPTION :'||p_counter_instance_rec.DESCRIPTION);
2129 PUT_LINE ('COUNTER_TYPE :'||p_counter_instance_rec.COUNTER_TYPE);
2130 PUT_LINE ('INITIAL_READING :'||p_counter_instance_rec.INITIAL_READING);
2131 PUT_LINE ('INITIAL_READING_DATE :'||p_counter_instance_rec.INITIAL_READING_DATE);
2132 PUT_LINE ('TOLERANCE_PLUS :'||p_counter_instance_rec.TOLERANCE_PLUS);
2133 PUT_LINE ('TOLERANCE_MINUS :'||p_counter_instance_rec.TOLERANCE_MINUS);
2134 PUT_LINE ('UOM_CODE :'||p_counter_instance_rec.UOM_CODE);
2135 PUT_LINE ('DERIVE_COUNTER_ID :'||p_counter_instance_rec.DERIVE_COUNTER_ID);
2136 PUT_LINE ('DERIVE_FUNCTION :'||p_counter_instance_rec.DERIVE_FUNCTION);
2137 PUT_LINE ('DERIVE_PROPERTY_ID :'||p_counter_instance_rec.DERIVE_PROPERTY_ID);
2138 PUT_LINE ('VALID_FLAG :'||p_counter_instance_rec.VALID_FLAG);
2139 PUT_LINE ('FORMULA_INCOMPLETE_FLAG :'||p_counter_instance_rec.FORMULA_INCOMPLETE_FLAG);
2140 PUT_LINE ('FORMULA_TEXT :'||p_counter_instance_rec.FORMULA_TEXT);
2141 PUT_LINE ('ROLLOVER_LAST_READING :'||p_counter_instance_rec.ROLLOVER_LAST_READING);
2142 PUT_LINE ('ROLLOVER_FIRST_READING :'||p_counter_instance_rec.ROLLOVER_FIRST_READING);
2143 PUT_LINE ('USAGE_ITEM_ID :'||p_counter_instance_rec.USAGE_ITEM_ID);
2144 PUT_LINE ('CTR_VAL_MAX_SEQ_NO :'||p_counter_instance_rec.CTR_VAL_MAX_SEQ_NO);
2145 PUT_LINE ('START_DATE_ACTIVE :'||p_counter_instance_rec.START_DATE_ACTIVE);
2146 PUT_LINE ('END_DATE_ACTIVE :'||p_counter_instance_rec.END_DATE_ACTIVE);
2147 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_instance_rec.OBJECT_VERSION_NUMBER);
2148 PUT_LINE ('ATTRIBUTE1 :'||p_counter_instance_rec.ATTRIBUTE1);
2149 PUT_LINE ('ATTRIBUTE2 :'||p_counter_instance_rec.ATTRIBUTE2);
2150 PUT_LINE ('ATTRIBUTE3 :'||p_counter_instance_rec.ATTRIBUTE3);
2151 PUT_LINE ('ATTRIBUTE4 :'||p_counter_instance_rec.ATTRIBUTE4);
2152 PUT_LINE ('ATTRIBUTE5 :'||p_counter_instance_rec.ATTRIBUTE5);
2153 PUT_LINE ('ATTRIBUTE6 :'||p_counter_instance_rec.ATTRIBUTE6);
2154 PUT_LINE ('ATTRIBUTE7 :'||p_counter_instance_rec.ATTRIBUTE7);
2158 PUT_LINE ('ATTRIBUTE11 :'||p_counter_instance_rec.ATTRIBUTE11);
2155 PUT_LINE ('ATTRIBUTE8 :'||p_counter_instance_rec.ATTRIBUTE8);
2156 PUT_LINE ('ATTRIBUTE9 :'||p_counter_instance_rec.ATTRIBUTE9);
2157 PUT_LINE ('ATTRIBUTE10 :'||p_counter_instance_rec.ATTRIBUTE10);
2159 PUT_LINE ('ATTRIBUTE12 :'||p_counter_instance_rec.ATTRIBUTE12);
2160 PUT_LINE ('ATTRIBUTE13 :'||p_counter_instance_rec.ATTRIBUTE13);
2161 PUT_LINE ('ATTRIBUTE14 :'||p_counter_instance_rec.ATTRIBUTE14);
2162 PUT_LINE ('ATTRIBUTE15 :'||p_counter_instance_rec.ATTRIBUTE15);
2163 PUT_LINE ('ATTRIBUTE16 :'||p_counter_instance_rec.ATTRIBUTE16);
2164 PUT_LINE ('ATTRIBUTE17 :'||p_counter_instance_rec.ATTRIBUTE17);
2165 PUT_LINE ('ATTRIBUTE18 :'||p_counter_instance_rec.ATTRIBUTE18);
2166 PUT_LINE ('ATTRIBUTE19 :'||p_counter_instance_rec.ATTRIBUTE19);
2167 PUT_LINE ('ATTRIBUTE20 :'||p_counter_instance_rec.ATTRIBUTE20);
2168 PUT_LINE ('ATTRIBUTE21 :'||p_counter_instance_rec.ATTRIBUTE21);
2169 PUT_LINE ('ATTRIBUTE22 :'||p_counter_instance_rec.ATTRIBUTE22);
2170 PUT_LINE ('ATTRIBUTE23 :'||p_counter_instance_rec.ATTRIBUTE23);
2171 PUT_LINE ('ATTRIBUTE24 :'||p_counter_instance_rec.ATTRIBUTE24);
2172 PUT_LINE ('ATTRIBUTE25 :'||p_counter_instance_rec.ATTRIBUTE25);
2173 PUT_LINE ('ATTRIBUTE26 :'||p_counter_instance_rec.ATTRIBUTE26);
2174 PUT_LINE ('ATTRIBUTE27 :'||p_counter_instance_rec.ATTRIBUTE27);
2175 PUT_LINE ('ATTRIBUTE28 :'||p_counter_instance_rec.ATTRIBUTE28);
2176 PUT_LINE ('ATTRIBUTE29 :'||p_counter_instance_rec.ATTRIBUTE29);
2177 PUT_LINE ('ATTRIBUTE30 :'||p_counter_instance_rec.ATTRIBUTE30);
2178 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_instance_rec.ATTRIBUTE_CATEGORY);
2179 PUT_LINE ('DIRECTION :'||p_counter_instance_rec.DIRECTION);
2180 PUT_LINE ('FILTER_TYPE :'||p_counter_instance_rec.FILTER_TYPE);
2181 PUT_LINE ('FILTER_READING_COUNT :'||p_counter_instance_rec.FILTER_READING_COUNT);
2182 PUT_LINE ('FILTER_TIME_UOM :'||p_counter_instance_rec.FILTER_TIME_UOM);
2183 PUT_LINE ('ESTIMATION_ID :'||p_counter_instance_rec.ESTIMATION_ID);
2184 PUT_LINE ('READING_TYPE :'||p_counter_instance_rec.READING_TYPE);
2185 PUT_LINE ('AUTOMATIC_ROLLOVER :'||p_counter_instance_rec.AUTOMATIC_ROLLOVER);
2186 PUT_LINE ('DEFAULT_USAGE_RATE :'||p_counter_instance_rec.DEFAULT_USAGE_RATE);
2187 PUT_LINE ('USE_PAST_READING :'||p_counter_instance_rec.USE_PAST_READING);
2188 PUT_LINE ('USED_IN_SCHEDULING :'||p_counter_instance_rec.USED_IN_SCHEDULING);
2189 PUT_LINE ('DEFAULTED_GROUP_ID :'||p_counter_instance_rec.DEFAULTED_GROUP_ID);
2190 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_instance_rec.SECURITY_GROUP_ID);
2191 PUT_LINE ('CREATED_FROM_COUNTER_TMPL_ID :'||p_counter_instance_rec.CREATED_FROM_COUNTER_TMPL_ID);
2192 PUT_LINE ('NAME :'||p_counter_instance_rec.NAME);
2193 PUT_LINE ('DESCRIPTION :'||p_counter_instance_rec.DESCRIPTION);
2194 PUT_LINE ('COMMENTS :'||p_counter_instance_rec.COMMENTS);
2195 PUT_LINE ('STEP_VALUE :'||p_counter_instance_rec.STEP_VALUE);
2196 PUT_LINE ('TIME_BASED_MANUAL_ENTRY :'||p_counter_instance_rec.TIME_BASED_MANUAL_ENTRY);
2197 PUT_LINE ('EAM_REQUIRED_FLAG :'||p_counter_instance_rec.EAM_REQUIRED_FLAG);
2198 EXCEPTION
2199 WHEN OTHERS THEN
2200 ROLLBACK TO dump_counter_instance_rec;
2201 IF FND_MSG_PUB.Check_Msg_Level
2202 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2203 THEN
2204 FND_MSG_PUB.Add_Exc_Msg
2205 (g_pkg_name,
2206 l_api_name);
2207 END IF;
2208 END dump_counter_instance_rec;
2209
2210 PROCEDURE dump_counter_instance_tbl
2211 (p_counter_instance_tbl IN csi_ctr_datastructures_pub.counter_instance_tbl) IS
2212 l_api_name CONSTANT VARCHAR2(30) := 'dump_counter_instance_tbl';
2213 l_api_version CONSTANT NUMBER := 1.0;
2214
2215 BEGIN
2216 SAVEPOINT dump_counter_instance_tbl;
2217
2218 -- Read the debug profiles values in to global variable 7197402
2219 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2220
2221 IF p_counter_instance_tbl.COUNT > 0 THEN
2222 FOR tab_row IN p_counter_instance_tbl.FIRST .. p_counter_instance_tbl.LAST
2223 LOOP
2224 IF p_counter_instance_tbl.EXISTS(tab_row) THEN
2225
2226 PUT_LINE (' ');
2227 PUT_LINE ('Dumping the values for Counter Instance Table Record # : '||tab_row);
2228 PUT_LINE (' ');
2229 PUT_LINE ('COUNTER_ID :'||p_counter_instance_tbl(tab_row).COUNTER_ID);
2230 PUT_LINE ('GROUP_ID :'||p_counter_instance_tbl(tab_row).GROUP_ID);
2231 PUT_LINE ('DESCRIPTION :'||p_counter_instance_tbl(tab_row).DESCRIPTION);
2232 PUT_LINE ('COUNTER_TYPE :'||p_counter_instance_tbl(tab_row).COUNTER_TYPE);
2233 PUT_LINE ('INITIAL_READING :'||p_counter_instance_tbl(tab_row).INITIAL_READING);
2234 PUT_LINE ('INITIAL_READING_DATE :'||p_counter_instance_tbl(tab_row).INITIAL_READING_DATE);
2235 PUT_LINE ('TOLERANCE_PLUS :'||p_counter_instance_tbl(tab_row).TOLERANCE_PLUS);
2239 PUT_LINE ('DERIVE_FUNCTION :'||p_counter_instance_tbl(tab_row).DERIVE_FUNCTION);
2236 PUT_LINE ('TOLERANCE_MINUS :'||p_counter_instance_tbl(tab_row).TOLERANCE_MINUS);
2237 PUT_LINE ('UOM_CODE :'||p_counter_instance_tbl(tab_row).UOM_CODE);
2238 PUT_LINE ('DERIVE_COUNTER_ID :'||p_counter_instance_tbl(tab_row).DERIVE_COUNTER_ID);
2240 PUT_LINE ('DERIVE_PROPERTY_ID :'||p_counter_instance_tbl(tab_row).DERIVE_PROPERTY_ID);
2241 PUT_LINE ('VALID_FLAG :'||p_counter_instance_tbl(tab_row).VALID_FLAG);
2242 PUT_LINE ('FORMULA_INCOMPLETE_FLAG :'||p_counter_instance_tbl(tab_row).FORMULA_INCOMPLETE_FLAG);
2243 PUT_LINE ('FORMULA_TEXT :'||p_counter_instance_tbl(tab_row).FORMULA_TEXT);
2244 PUT_LINE ('ROLLOVER_LAST_READING :'||p_counter_instance_tbl(tab_row).ROLLOVER_LAST_READING);
2245 PUT_LINE ('ROLLOVER_FIRST_READING :'||p_counter_instance_tbl(tab_row).ROLLOVER_FIRST_READING); PUT_LINE ('USAGE_ITEM_ID :'||p_counter_instance_tbl(tab_row).USAGE_ITEM_ID);
2246 PUT_LINE ('CTR_VAL_MAX_SEQ_NO :'||p_counter_instance_tbl(tab_row).CTR_VAL_MAX_SEQ_NO);
2247 PUT_LINE ('START_DATE_ACTIVE :'||p_counter_instance_tbl(tab_row).START_DATE_ACTIVE);
2248 PUT_LINE ('END_DATE_ACTIVE :'||p_counter_instance_tbl(tab_row).END_DATE_ACTIVE);
2249 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_instance_tbl(tab_row).OBJECT_VERSION_NUMBER);
2250 PUT_LINE ('ATTRIBUTE1 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE1);
2251 PUT_LINE ('ATTRIBUTE2 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE2);
2252 PUT_LINE ('ATTRIBUTE3 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE3);
2253 PUT_LINE ('ATTRIBUTE4 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE4);
2254 PUT_LINE ('ATTRIBUTE5 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE5);
2255 PUT_LINE ('ATTRIBUTE6 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE6);
2256 PUT_LINE ('ATTRIBUTE7 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE7);
2257 PUT_LINE ('ATTRIBUTE8 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE8);
2258 PUT_LINE ('ATTRIBUTE9 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE9);
2259 PUT_LINE ('ATTRIBUTE10 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE10);
2260 PUT_LINE ('ATTRIBUTE11 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE11);
2261 PUT_LINE ('ATTRIBUTE12 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE12);
2262 PUT_LINE ('ATTRIBUTE13 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE13);
2263 PUT_LINE ('ATTRIBUTE14 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE14);
2264 PUT_LINE ('ATTRIBUTE15 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE15);
2265 PUT_LINE ('ATTRIBUTE16 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE16);
2266 PUT_LINE ('ATTRIBUTE17 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE17);
2267 PUT_LINE ('ATTRIBUTE18 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE18);
2268 PUT_LINE ('ATTRIBUTE19 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE19);
2269 PUT_LINE ('ATTRIBUTE20 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE20);
2270 PUT_LINE ('ATTRIBUTE21 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE21);
2271 PUT_LINE ('ATTRIBUTE22 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE22);
2272 PUT_LINE ('ATTRIBUTE23 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE23);
2273 PUT_LINE ('ATTRIBUTE24 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE24);
2274 PUT_LINE ('ATTRIBUTE25 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE25);
2275 PUT_LINE ('ATTRIBUTE26 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE26);
2276 PUT_LINE ('ATTRIBUTE27 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE27);
2277 PUT_LINE ('ATTRIBUTE28 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE28);
2278 PUT_LINE ('ATTRIBUTE29 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE29);
2279 PUT_LINE ('ATTRIBUTE30 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE30);
2280 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_instance_tbl(tab_row).ATTRIBUTE_CATEGORY);
2281 PUT_LINE ('DIRECTION :'||p_counter_instance_tbl(tab_row).DIRECTION);
2282 PUT_LINE ('FILTER_TYPE :'||p_counter_instance_tbl(tab_row).FILTER_TYPE);
2283 PUT_LINE ('FILTER_READING_COUNT :'||p_counter_instance_tbl(tab_row).FILTER_READING_COUNT);
2284 PUT_LINE ('FILTER_TIME_UOM :'||p_counter_instance_tbl(tab_row).FILTER_TIME_UOM);
2285 PUT_LINE ('ESTIMATION_ID :'||p_counter_instance_tbl(tab_row).ESTIMATION_ID);
2286 PUT_LINE ('READING_TYPE :'||p_counter_instance_tbl(tab_row).READING_TYPE);
2287 PUT_LINE ('AUTOMATIC_ROLLOVER :'||p_counter_instance_tbl(tab_row).AUTOMATIC_ROLLOVER);
2288 PUT_LINE ('DEFAULT_USAGE_RATE :'||p_counter_instance_tbl(tab_row).DEFAULT_USAGE_RATE);
2289 PUT_LINE ('USE_PAST_READING :'||p_counter_instance_tbl(tab_row).USE_PAST_READING);
2290 PUT_LINE ('USED_IN_SCHEDULING :'||p_counter_instance_tbl(tab_row).USED_IN_SCHEDULING);
2291 PUT_LINE ('DEFAULTED_GROUP_ID :'||p_counter_instance_tbl(tab_row).DEFAULTED_GROUP_ID);
2292 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_instance_tbl(tab_row).SECURITY_GROUP_ID);
2293 PUT_LINE ('CREATED_FROM_COUNTER_TMPL_ID :'||p_counter_instance_tbl(tab_row).CREATED_FROM_COUNTER_TMPL_ID);
2294 PUT_LINE ('NAME :'||p_counter_instance_tbl(tab_row).NAME);
2298 PUT_LINE ('TIME_BASED_MANUAL_ENTRY :'||p_counter_instance_tbl(tab_row).TIME_BASED_MANUAL_ENTRY);
2295 PUT_LINE ('DESCRIPTION :'||p_counter_instance_tbl(tab_row).DESCRIPTION);
2296 PUT_LINE ('COMMENTS :'||p_counter_instance_tbl(tab_row).COMMENTS);
2297 PUT_LINE ('STEP_VALUE :'||p_counter_instance_tbl(tab_row).STEP_VALUE);
2299 PUT_LINE ('EAM_REQUIRED_FLAG :'||p_counter_instance_tbl(tab_row).EAM_REQUIRED_FLAG);
2300
2301 END IF;
2302 END LOOP;
2303 END IF;
2304 EXCEPTION
2305 WHEN OTHERS THEN
2306 ROLLBACK TO dump_counter_instance_tbl;
2307 IF FND_MSG_PUB.Check_Msg_Level
2308 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2309 THEN
2310 FND_MSG_PUB.Add_Exc_Msg
2311 (g_pkg_name,
2312 l_api_name);
2313 END IF;
2314 END dump_counter_instance_tbl;
2315
2316 PROCEDURE dump_ctr_properties_rec
2317 (p_ctr_properties_rec IN csi_ctr_datastructures_pub.ctr_properties_rec) IS
2318 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_properties_rec';
2319 l_api_version CONSTANT NUMBER := 1.0;
2320 BEGIN
2321 SAVEPOINT dump_ctr_properties_rec;
2322
2323 -- Read the debug profiles values in to global variable 7197402
2324 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2325
2326 PUT_LINE (' ');
2327 PUT_LINE ('Dumping the values for Counter Properties Record:');
2328 PUT_LINE (' ');
2329
2330 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_properties_rec.COUNTER_PROPERTY_ID);
2331 PUT_LINE ('COUNTER_ID :'||p_ctr_properties_rec.COUNTER_ID);
2332 PUT_LINE ('PROPERTY_DATA_TYPE :'||p_ctr_properties_rec.PROPERTY_DATA_TYPE);
2333 PUT_LINE ('IS_NULLABLE :'||p_ctr_properties_rec.IS_NULLABLE);
2334 PUT_LINE ('DEFAULT_VALUE :'||p_ctr_properties_rec.DEFAULT_VALUE);
2335 PUT_LINE ('MINIMUM_VALUE :'||p_ctr_properties_rec.MINIMUM_VALUE);
2336 PUT_LINE ('MAXIMUM_VALUE :'||p_ctr_properties_rec.MAXIMUM_VALUE);
2337 PUT_LINE ('UOM_CODE :'||p_ctr_properties_rec.UOM_CODE);
2338 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_properties_rec.START_DATE_ACTIVE);
2339 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_properties_rec.END_DATE_ACTIVE);
2340 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_properties_rec.OBJECT_VERSION_NUMBER);
2341 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_properties_rec.ATTRIBUTE1);
2342 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_properties_rec.ATTRIBUTE2);
2343 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_properties_rec.ATTRIBUTE3);
2344 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_properties_rec.ATTRIBUTE4);
2345 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_properties_rec.ATTRIBUTE5);
2346 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_properties_rec.ATTRIBUTE6);
2347 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_properties_rec.ATTRIBUTE7);
2348 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_properties_rec.ATTRIBUTE8);
2349 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_properties_rec.ATTRIBUTE9);
2350 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_properties_rec.ATTRIBUTE10);
2351 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_properties_rec.ATTRIBUTE11);
2352 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_properties_rec.ATTRIBUTE12);
2353 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_properties_rec.ATTRIBUTE13);
2354 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_properties_rec.ATTRIBUTE14);
2355 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_properties_rec.ATTRIBUTE15);
2356 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_properties_rec.ATTRIBUTE_CATEGORY);
2357 PUT_LINE ('PROPERTY_LOV_TYPE :'||p_ctr_properties_rec.PROPERTY_LOV_TYPE);
2358 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_properties_rec.SECURITY_GROUP_ID);
2359 PUT_LINE ('CREATED_FROM_CTR_PROP_TMPL_ID :'||p_ctr_properties_rec.CREATED_FROM_CTR_PROP_TMPL_ID);
2360 PUT_LINE ('NAME :'||p_ctr_properties_rec.NAME);
2361 PUT_LINE ('DESCRIPTION :'||p_ctr_properties_rec.DESCRIPTION);
2362 EXCEPTION
2363 WHEN OTHERS THEN
2364 ROLLBACK TO dump_ctr_properties_rec;
2365 IF FND_MSG_PUB.Check_Msg_Level
2366 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2367 THEN
2368 FND_MSG_PUB.Add_Exc_Msg
2369 (g_pkg_name,
2370 l_api_name);
2371 END IF;
2372 END dump_ctr_properties_rec;
2373
2374 PROCEDURE dump_ctr_properties_tbl
2375 (p_ctr_properties_tbl IN csi_ctr_datastructures_pub.ctr_properties_tbl) IS
2376 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_properties_tbl';
2377 l_api_version CONSTANT NUMBER := 1.0;
2378
2379 BEGIN
2380 SAVEPOINT dump_ctr_properties_tbl;
2381
2382 -- Read the debug profiles values in to global variable 7197402
2383 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2384
2385 IF p_ctr_properties_tbl.COUNT > 0 THEN
2386 FOR tab_row IN p_ctr_properties_tbl.FIRST .. p_ctr_properties_tbl.LAST
2387 LOOP
2388 IF p_ctr_properties_tbl.EXISTS(tab_row) THEN
2389
2390 PUT_LINE (' ');
2391 PUT_LINE ('Dumping the values for Counter Properties Table Record # : '||tab_row);
2392 PUT_LINE (' ');
2393
2394 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_properties_tbl(tab_row).COUNTER_PROPERTY_ID);
2395 PUT_LINE ('COUNTER_ID :'||p_ctr_properties_tbl(tab_row).COUNTER_ID);
2396 PUT_LINE ('PROPERTY_DATA_TYPE :'||p_ctr_properties_tbl(tab_row).PROPERTY_DATA_TYPE);
2397 PUT_LINE ('IS_NULLABLE :'||p_ctr_properties_tbl(tab_row).IS_NULLABLE);
2401 PUT_LINE ('UOM_CODE :'||p_ctr_properties_tbl(tab_row).UOM_CODE);
2398 PUT_LINE ('DEFAULT_VALUE :'||p_ctr_properties_tbl(tab_row).DEFAULT_VALUE);
2399 PUT_LINE ('MINIMUM_VALUE :'||p_ctr_properties_tbl(tab_row).MINIMUM_VALUE);
2400 PUT_LINE ('MAXIMUM_VALUE :'||p_ctr_properties_tbl(tab_row).MAXIMUM_VALUE);
2402 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_properties_tbl(tab_row).START_DATE_ACTIVE);
2403 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_properties_tbl(tab_row).END_DATE_ACTIVE);
2404 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_properties_tbl(tab_row).OBJECT_VERSION_NUMBER);
2405 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE1);
2406 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE2);
2407 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE3);
2408 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE4);
2409 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE5);
2410 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE6);
2411 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE7);
2412 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE8);
2413 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE9);
2414 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE10);
2415 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE11);
2416 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE12);
2417 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE13);
2418 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE14);
2419 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE15);
2420 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE_CATEGORY);
2421 PUT_LINE ('PROPERTY_LOV_TYPE :'||p_ctr_properties_tbl(tab_row).PROPERTY_LOV_TYPE);
2422 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_properties_tbl(tab_row).SECURITY_GROUP_ID);
2423 PUT_LINE ('CREATED_FROM_CTR_PROP_TMPL_ID :'||p_ctr_properties_tbl(tab_row).CREATED_FROM_CTR_PROP_TMPL_ID);
2424 PUT_LINE ('NAME :'||p_ctr_properties_tbl(tab_row).NAME);
2425 PUT_LINE ('DESCRIPTION :'||p_ctr_properties_tbl(tab_row).DESCRIPTION);
2426
2427 END IF;
2428 END LOOP;
2429 END IF;
2430 EXCEPTION
2431 WHEN OTHERS THEN
2432 ROLLBACK TO dump_ctr_properties_tbl;
2433 IF FND_MSG_PUB.Check_Msg_Level
2434 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2435 THEN
2436 FND_MSG_PUB.Add_Exc_Msg
2437 (g_pkg_name,
2438 l_api_name);
2439 END IF;
2440 END dump_ctr_properties_tbl;
2441
2442 PROCEDURE dump_counter_associations_rec
2443 (p_counter_associations_rec IN csi_ctr_datastructures_pub.counter_associations_rec) IS
2444 l_api_name CONSTANT VARCHAR2(30) := 'dump_counter_associations_rec';
2445 l_api_version CONSTANT NUMBER := 1.0;
2446 BEGIN
2447 SAVEPOINT dump_counter_associations_rec;
2448
2449 -- Read the debug profiles values in to global variable 7197402
2450 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2451
2452 PUT_LINE (' ');
2453 PUT_LINE ('Dumping the values for Counter Instance Association Record:');
2454 PUT_LINE (' ');
2455
2456 PUT_LINE ('INSTANCE_ASSOCIATION_ID :'||p_counter_associations_rec.INSTANCE_ASSOCIATION_ID);
2457 PUT_LINE ('SOURCE_OBJECT_CODE :'||p_counter_associations_rec.SOURCE_OBJECT_CODE);
2458 PUT_LINE ('SOURCE_OBJECT_ID :'||p_counter_associations_rec.SOURCE_OBJECT_ID);
2459 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_associations_rec.OBJECT_VERSION_NUMBER);
2460 PUT_LINE ('ATTRIBUTE1 :'||p_counter_associations_rec.ATTRIBUTE1);
2461 PUT_LINE ('ATTRIBUTE2 :'||p_counter_associations_rec.ATTRIBUTE2);
2462 PUT_LINE ('ATTRIBUTE3 :'||p_counter_associations_rec.ATTRIBUTE3);
2463 PUT_LINE ('ATTRIBUTE4 :'||p_counter_associations_rec.ATTRIBUTE4);
2464 PUT_LINE ('ATTRIBUTE5 :'||p_counter_associations_rec.ATTRIBUTE5);
2465 PUT_LINE ('ATTRIBUTE6 :'||p_counter_associations_rec.ATTRIBUTE6);
2466 PUT_LINE ('ATTRIBUTE7 :'||p_counter_associations_rec.ATTRIBUTE7);
2467 PUT_LINE ('ATTRIBUTE8 :'||p_counter_associations_rec.ATTRIBUTE8);
2468 PUT_LINE ('ATTRIBUTE9 :'||p_counter_associations_rec.ATTRIBUTE9);
2469 PUT_LINE ('ATTRIBUTE10 :'||p_counter_associations_rec.ATTRIBUTE10);
2470 PUT_LINE ('ATTRIBUTE11 :'||p_counter_associations_rec.ATTRIBUTE11);
2471 PUT_LINE ('ATTRIBUTE12 :'||p_counter_associations_rec.ATTRIBUTE12);
2472 PUT_LINE ('ATTRIBUTE13 :'||p_counter_associations_rec.ATTRIBUTE13);
2473 PUT_LINE ('ATTRIBUTE14 :'||p_counter_associations_rec.ATTRIBUTE14);
2474 PUT_LINE ('ATTRIBUTE15 :'||p_counter_associations_rec.ATTRIBUTE15);
2475 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_associations_rec.ATTRIBUTE_CATEGORY);
2476 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_associations_rec.SECURITY_GROUP_ID);
2477 PUT_LINE ('COUNTER_ID :'||p_counter_associations_rec.COUNTER_ID);
2478 PUT_LINE ('START_DATE_ACTIVE :'||p_counter_associations_rec.START_DATE_ACTIVE);
2479 PUT_LINE ('END_DATE_ACTIVE :'||p_counter_associations_rec.END_DATE_ACTIVE);
2480 PUT_LINE ('MAINT_ORGANIZATION_ID :'||p_counter_associations_rec.MAINT_ORGANIZATION_ID);
2481 PUT_LINE ('PRIMARY_FAILURE_FLAG :'||p_counter_associations_rec.PRIMARY_FAILURE_FLAG);
2482
2483 EXCEPTION
2484 WHEN OTHERS THEN
2485 ROLLBACK TO dump_counter_associations_rec;
2489 FND_MSG_PUB.Add_Exc_Msg
2486 IF FND_MSG_PUB.Check_Msg_Level
2487 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2488 THEN
2490 (g_pkg_name,
2491 l_api_name);
2492 END IF;
2493 END dump_counter_associations_rec;
2494
2495 PROCEDURE dump_counter_associations_tbl
2496 (p_counter_associations_tbl IN csi_ctr_datastructures_pub.counter_associations_tbl) IS
2497 l_api_name CONSTANT VARCHAR2(30) := 'dump_counter_associations_tbl';
2498 l_api_version CONSTANT NUMBER := 1.0;
2499
2500 BEGIN
2501 SAVEPOINT dump_counter_associations_tbl;
2502
2503 -- Read the debug profiles values in to global variable 7197402
2504 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2505
2506 IF p_counter_associations_tbl.COUNT > 0 THEN
2507 FOR tab_row IN p_counter_associations_tbl.FIRST .. p_counter_associations_tbl.LAST
2508 LOOP
2509 IF p_counter_associations_tbl.EXISTS(tab_row) THEN
2510
2511 PUT_LINE (' ');
2512 PUT_LINE ('Dumping the values for Counter Instance Association Table Record # : '||tab_row);
2513 PUT_LINE (' ');
2514
2515 PUT_LINE ('INSTANCE_ASSOCIATION_ID :'||p_counter_associations_tbl(tab_row).INSTANCE_ASSOCIATION_ID);
2516 PUT_LINE ('SOURCE_OBJECT_CODE :'||p_counter_associations_tbl(tab_row).SOURCE_OBJECT_CODE);
2517 PUT_LINE ('SOURCE_OBJECT_ID :'||p_counter_associations_tbl(tab_row).SOURCE_OBJECT_ID);
2518 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_associations_tbl(tab_row).OBJECT_VERSION_NUMBER);
2519 PUT_LINE ('ATTRIBUTE1 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE1);
2520 PUT_LINE ('ATTRIBUTE2 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE2);
2521 PUT_LINE ('ATTRIBUTE3 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE3);
2522 PUT_LINE ('ATTRIBUTE4 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE4);
2523 PUT_LINE ('ATTRIBUTE5 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE5);
2524 PUT_LINE ('ATTRIBUTE6 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE6);
2525 PUT_LINE ('ATTRIBUTE7 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE7);
2526 PUT_LINE ('ATTRIBUTE8 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE8);
2527 PUT_LINE ('ATTRIBUTE9 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE9);
2528 PUT_LINE ('ATTRIBUTE10 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE10);
2529 PUT_LINE ('ATTRIBUTE11 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE11);
2530 PUT_LINE ('ATTRIBUTE12 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE12);
2531 PUT_LINE ('ATTRIBUTE13 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE13);
2532 PUT_LINE ('ATTRIBUTE14 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE14);
2533 PUT_LINE ('ATTRIBUTE15 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE15);
2534 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_associations_tbl(tab_row).ATTRIBUTE_CATEGORY);
2535 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_associations_tbl(tab_row).SECURITY_GROUP_ID);
2536 PUT_LINE ('COUNTER_ID :'||p_counter_associations_tbl(tab_row).COUNTER_ID);
2537 PUT_LINE ('START_DATE_ACTIVE :'||p_counter_associations_tbl(tab_row).START_DATE_ACTIVE);
2538 PUT_LINE ('END_DATE_ACTIVE :'||p_counter_associations_tbl(tab_row).END_DATE_ACTIVE);
2539 PUT_LINE ('MAINT_ORGANIZATION_ID :'||p_counter_associations_tbl(tab_row).MAINT_ORGANIZATION_ID);
2540 PUT_LINE ('PRIMARY_FAILURE_FLAG :'||p_counter_associations_tbl(tab_row).PRIMARY_FAILURE_FLAG);
2541
2542 END IF;
2543 END LOOP;
2544 END IF;
2545 EXCEPTION
2546 WHEN OTHERS THEN
2547 ROLLBACK TO dump_counter_associations_tbl;
2548 IF FND_MSG_PUB.Check_Msg_Level
2549 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2550 THEN
2551 FND_MSG_PUB.Add_Exc_Msg
2552 (g_pkg_name,
2553 l_api_name);
2554 END IF;
2555 END dump_counter_associations_tbl;
2556
2557 PROCEDURE dump_counter_readings_rec
2558 (p_counter_readings_rec IN csi_ctr_datastructures_pub.counter_readings_rec) IS
2559 l_api_name CONSTANT VARCHAR2(30) := 'dump_counter_readings_rec';
2560 l_api_version CONSTANT NUMBER := 1.0;
2561 BEGIN
2562 SAVEPOINT dump_counter_readings_rec;
2563
2564 -- Read the debug profiles values in to global variable 7197402
2565 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2566
2567 PUT_LINE (' ');
2568 PUT_LINE ('Dumping the values for Counter Readings Record:');
2569 PUT_LINE (' ');
2570
2571 PUT_LINE ('COUNTER_VALUE_ID :'||p_counter_readings_rec.COUNTER_VALUE_ID);
2572 PUT_LINE ('COUNTER_ID :'||p_counter_readings_rec.COUNTER_ID);
2573 PUT_LINE ('VALUE_TIMESTAMP :'||p_counter_readings_rec.VALUE_TIMESTAMP);
2574 -- PUT_LINE ('SEQ_NO :'||p_counter_readings_rec.SEQ_NO);
2575 PUT_LINE ('COUNTER_READING :'||p_counter_readings_rec.COUNTER_READING);
2576 PUT_LINE ('RESET_MODE :'||p_counter_readings_rec.RESET_MODE);
2577 PUT_LINE ('RESET_REASON :'||p_counter_readings_rec.RESET_REASON);
2578 -- PUT_LINE ('READING_BEFORE_RESET :'||p_counter_readings_rec.READING_BEFORE_RESET);
2579 -- PUT_LINE ('READING_AFTER_RESET :'||p_counter_readings_rec.READING_AFTER_RESET);
2580 PUT_LINE ('ADJUSTMENT_TYPE :'||p_counter_readings_rec.ADJUSTMENT_TYPE);
2581 PUT_LINE ('ADJUSTMENT_READING :'||p_counter_readings_rec.ADJUSTMENT_READING);
2582 -- PUT_LINE ('CUMULATIVE_ADJUSTMENT :'||p_counter_readings_rec.CUMULATIVE_ADJUSTMENT);
2586 PUT_LINE ('ATTRIBUTE3 :'||p_counter_readings_rec.ATTRIBUTE3);
2583 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_readings_rec.OBJECT_VERSION_NUMBER);
2584 PUT_LINE ('ATTRIBUTE1 :'||p_counter_readings_rec.ATTRIBUTE1);
2585 PUT_LINE ('ATTRIBUTE2 :'||p_counter_readings_rec.ATTRIBUTE2);
2587 PUT_LINE ('ATTRIBUTE4 :'||p_counter_readings_rec.ATTRIBUTE4);
2588 PUT_LINE ('ATTRIBUTE5 :'||p_counter_readings_rec.ATTRIBUTE5);
2589 PUT_LINE ('ATTRIBUTE6 :'||p_counter_readings_rec.ATTRIBUTE6);
2590 PUT_LINE ('ATTRIBUTE7 :'||p_counter_readings_rec.ATTRIBUTE7);
2591 PUT_LINE ('ATTRIBUTE8 :'||p_counter_readings_rec.ATTRIBUTE8);
2592 PUT_LINE ('ATTRIBUTE9 :'||p_counter_readings_rec.ATTRIBUTE9);
2593 PUT_LINE ('ATTRIBUTE10 :'||p_counter_readings_rec.ATTRIBUTE10);
2594 PUT_LINE ('ATTRIBUTE11 :'||p_counter_readings_rec.ATTRIBUTE11);
2595 PUT_LINE ('ATTRIBUTE12 :'||p_counter_readings_rec.ATTRIBUTE12);
2596 PUT_LINE ('ATTRIBUTE13 :'||p_counter_readings_rec.ATTRIBUTE13);
2597 PUT_LINE ('ATTRIBUTE14 :'||p_counter_readings_rec.ATTRIBUTE14);
2598 PUT_LINE ('ATTRIBUTE15 :'||p_counter_readings_rec.ATTRIBUTE15);
2599 PUT_LINE ('ATTRIBUTE16 :'||p_counter_readings_rec.ATTRIBUTE16);
2600 PUT_LINE ('ATTRIBUTE17 :'||p_counter_readings_rec.ATTRIBUTE17);
2601 PUT_LINE ('ATTRIBUTE18 :'||p_counter_readings_rec.ATTRIBUTE18);
2602 PUT_LINE ('ATTRIBUTE19 :'||p_counter_readings_rec.ATTRIBUTE19);
2603 PUT_LINE ('ATTRIBUTE20 :'||p_counter_readings_rec.ATTRIBUTE20);
2604 PUT_LINE ('ATTRIBUTE21 :'||p_counter_readings_rec.ATTRIBUTE21);
2605 PUT_LINE ('ATTRIBUTE22 :'||p_counter_readings_rec.ATTRIBUTE22);
2606 PUT_LINE ('ATTRIBUTE23 :'||p_counter_readings_rec.ATTRIBUTE23);
2607 PUT_LINE ('ATTRIBUTE24 :'||p_counter_readings_rec.ATTRIBUTE24);
2608 PUT_LINE ('ATTRIBUTE25 :'||p_counter_readings_rec.ATTRIBUTE25);
2609 PUT_LINE ('ATTRIBUTE26 :'||p_counter_readings_rec.ATTRIBUTE26);
2610 PUT_LINE ('ATTRIBUTE27 :'||p_counter_readings_rec.ATTRIBUTE27);
2611 PUT_LINE ('ATTRIBUTE28 :'||p_counter_readings_rec.ATTRIBUTE28);
2612 PUT_LINE ('ATTRIBUTE29 :'||p_counter_readings_rec.ATTRIBUTE29);
2613 PUT_LINE ('ATTRIBUTE30 :'||p_counter_readings_rec.ATTRIBUTE30);
2614 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_readings_rec.ATTRIBUTE_CATEGORY);
2615 PUT_LINE ('COMMENTS :'||p_counter_readings_rec.COMMENTS);
2616 PUT_LINE ('LIFE_TO_DATE_READING :'||p_counter_readings_rec.LIFE_TO_DATE_READING);
2617 PUT_LINE ('TRANSACTION_ID :'||p_counter_readings_rec.TRANSACTION_ID);
2618 PUT_LINE ('AUTOMATIC_ROLLOVER_FLAG :'||p_counter_readings_rec.AUTOMATIC_ROLLOVER_FLAG);
2619 PUT_LINE ('INCLUDE_TARGET_RESETS :'||p_counter_readings_rec.INCLUDE_TARGET_RESETS);
2620 PUT_LINE ('SOURCE_COUNTER_VALUE_ID :'||p_counter_readings_rec.SOURCE_COUNTER_VALUE_ID);
2621 PUT_LINE ('NET_READING :'||p_counter_readings_rec.NET_READING);
2622 PUT_LINE ('DISABLED_FLAG :'||p_counter_readings_rec.DISABLED_FLAG);
2623 PUT_LINE ('SOURCE_CODE :'||p_counter_readings_rec.SOURCE_CODE);
2624 PUT_LINE ('SOURCE_LINE_ID :'||p_counter_readings_rec.SOURCE_LINE_ID);
2625 PUT_LINE ('RESET_COUNTER_READING :'||p_counter_readings_rec.RESET_COUNTER_READING);
2626 PUT_LINE ('PARENT_TBL_INDEX :'||p_counter_readings_rec.PARENT_TBL_INDEX);
2627 PUT_LINE ('INITIAL_READING_FLAG :'||p_counter_readings_rec.INITIAL_READING_FLAG);
2628 EXCEPTION
2629 WHEN OTHERS THEN
2630 ROLLBACK TO dump_counter_readings_rec;
2631 IF FND_MSG_PUB.Check_Msg_Level
2632 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2633 THEN
2634 FND_MSG_PUB.Add_Exc_Msg
2635 (g_pkg_name,
2636 l_api_name);
2637 END IF;
2638 END dump_counter_readings_rec;
2639
2640 PROCEDURE dump_counter_readings_tbl
2641 (p_counter_readings_tbl IN csi_ctr_datastructures_pub.counter_readings_tbl) IS
2642 l_api_name CONSTANT VARCHAR2(30) := 'dump_counter_readings_tbl';
2643 l_api_version CONSTANT NUMBER := 1.0;
2644
2645 BEGIN
2646 SAVEPOINT dump_counter_readings_tbl;
2647
2648 -- Read the debug profiles values in to global variable 7197402
2649 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2650
2651 IF p_counter_readings_tbl.COUNT > 0 THEN
2652 FOR tab_row IN p_counter_readings_tbl.FIRST .. p_counter_readings_tbl.LAST
2653 LOOP
2654 IF p_counter_readings_tbl.EXISTS(tab_row) THEN
2655
2656 PUT_LINE (' ');
2657 PUT_LINE ('Dumping the values for Counter Readings Table Record # : '||tab_row);
2658 PUT_LINE (' ');
2659
2660 PUT_LINE ('COUNTER_VALUE_ID :'||p_counter_readings_tbl(tab_row).COUNTER_VALUE_ID);
2661 PUT_LINE ('COUNTER_ID :'||p_counter_readings_tbl(tab_row).COUNTER_ID);
2662 PUT_LINE ('VALUE_TIMESTAMP :'||p_counter_readings_tbl(tab_row).VALUE_TIMESTAMP);
2663 -- PUT_LINE ('SEQ_NO :'||p_counter_readings_tbl(tab_row).SEQ_NO);
2664 PUT_LINE ('COUNTER_READING :'||p_counter_readings_tbl(tab_row).COUNTER_READING);
2665 PUT_LINE ('RESET_MODE :'||p_counter_readings_tbl(tab_row).RESET_MODE);
2666 PUT_LINE ('RESET_REASON :'||p_counter_readings_tbl(tab_row).RESET_REASON);
2667 -- PUT_LINE ('READING_BEFORE_RESET :'||p_counter_readings_tbl(tab_row).READING_BEFORE_RESET);
2668 -- PUT_LINE ('READING_AFTER_RESET :'||p_counter_readings_tbl(tab_row).READING_AFTER_RESET);
2672 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_readings_tbl(tab_row).OBJECT_VERSION_NUMBER);
2669 PUT_LINE ('ADJUSTMENT_TYPE :'||p_counter_readings_tbl(tab_row).ADJUSTMENT_TYPE);
2670 PUT_LINE ('ADJUSTMENT_READING :'||p_counter_readings_tbl(tab_row).ADJUSTMENT_READING);
2671 -- PUT_LINE ('CUMULATIVE_ADJUSTMENT :'||p_counter_readings_tbl(tab_row).CUMULATIVE_ADJUSTMENT);
2673 PUT_LINE ('ATTRIBUTE1 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE1);
2674 PUT_LINE ('ATTRIBUTE2 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE2);
2675 PUT_LINE ('ATTRIBUTE3 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE3);
2676 PUT_LINE ('ATTRIBUTE4 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE4);
2677 PUT_LINE ('ATTRIBUTE5 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE5);
2678 PUT_LINE ('ATTRIBUTE6 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE6);
2679 PUT_LINE ('ATTRIBUTE7 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE7);
2680 PUT_LINE ('ATTRIBUTE8 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE8);
2681 PUT_LINE ('ATTRIBUTE9 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE9);
2682 PUT_LINE ('ATTRIBUTE10 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE10);
2683 PUT_LINE ('ATTRIBUTE11 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE11);
2684 PUT_LINE ('ATTRIBUTE12 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE12);
2685 PUT_LINE ('ATTRIBUTE13 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE13);
2686 PUT_LINE ('ATTRIBUTE14 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE14);
2687 PUT_LINE ('ATTRIBUTE15 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE15);
2688 PUT_LINE ('ATTRIBUTE16 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE16);
2689 PUT_LINE ('ATTRIBUTE17 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE17);
2690 PUT_LINE ('ATTRIBUTE18 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE18);
2691 PUT_LINE ('ATTRIBUTE19 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE19);
2692 PUT_LINE ('ATTRIBUTE20 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE20);
2693 PUT_LINE ('ATTRIBUTE21 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE21);
2694 PUT_LINE ('ATTRIBUTE22 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE22);
2695 PUT_LINE ('ATTRIBUTE23 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE23);
2696 PUT_LINE ('ATTRIBUTE24 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE24);
2697 PUT_LINE ('ATTRIBUTE25 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE25);
2698 PUT_LINE ('ATTRIBUTE26 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE26);
2699 PUT_LINE ('ATTRIBUTE27 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE27);
2700 PUT_LINE ('ATTRIBUTE28 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE28);
2701 PUT_LINE ('ATTRIBUTE29 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE29);
2702 PUT_LINE ('ATTRIBUTE30 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE30);
2703 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_readings_tbl(tab_row).ATTRIBUTE_CATEGORY);
2704 PUT_LINE ('COMMENTS :'||p_counter_readings_tbl(tab_row).COMMENTS);
2705 PUT_LINE ('LIFE_TO_DATE_READING :'||p_counter_readings_tbl(tab_row).LIFE_TO_DATE_READING);
2706 PUT_LINE ('TRANSACTION_ID :'||p_counter_readings_tbl(tab_row).TRANSACTION_ID);
2707 PUT_LINE ('AUTOMATIC_ROLLOVER_FLAG :'||p_counter_readings_tbl(tab_row).AUTOMATIC_ROLLOVER_FLAG);
2708 PUT_LINE ('INCLUDE_TARGET_RESETS :'||p_counter_readings_tbl(tab_row).INCLUDE_TARGET_RESETS);
2709 PUT_LINE ('SOURCE_COUNTER_VALUE_ID :'||p_counter_readings_tbl(tab_row).SOURCE_COUNTER_VALUE_ID);
2710 PUT_LINE ('NET_READING :'||p_counter_readings_tbl(tab_row).NET_READING);
2711 PUT_LINE ('DISABLED_FLAG :'||p_counter_readings_tbl(tab_row).DISABLED_FLAG);
2712 PUT_LINE ('SOURCE_CODE :'||p_counter_readings_tbl(tab_row).SOURCE_CODE);
2713 PUT_LINE ('SOURCE_LINE_ID :'||p_counter_readings_tbl(tab_row).SOURCE_LINE_ID);
2714 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_readings_tbl(tab_row).SECURITY_GROUP_ID);
2715 -- PUT_LINE ('SOURCE_TRANSACTION_TYPE_ID :'||p_counter_readings_tbl(tab_row).SOURCE_TRANSACTION_TYPE_ID);
2716 -- PUT_LINE ('SOURCE_TRANSACTION_ID :'||p_counter_readings_tbl(tab_row).SOURCE_TRANSACTION_ID);
2717 PUT_LINE ('NET_READING :'||p_counter_readings_tbl(tab_row).NET_READING);
2718 PUT_LINE ('DISABLED_FLAG :'||p_counter_readings_tbl(tab_row).DISABLED_FLAG);
2719 PUT_LINE ('RESET_COUNTER_READING :'||p_counter_readings_tbl(tab_row).RESET_COUNTER_READING);
2720 PUT_LINE ('PARENT_TBL_INDEX :'||p_counter_readings_tbl(tab_row).PARENT_TBL_INDEX);
2721 PUT_LINE ('INITIAL_READING_FLAG :'||p_counter_readings_tbl(tab_row).INITIAL_READING_FLAG);
2722
2723 END IF;
2724 END LOOP;
2725 END IF;
2726 EXCEPTION
2727 WHEN OTHERS THEN
2728 ROLLBACK TO dump_counter_readings_tbl;
2729 IF FND_MSG_PUB.Check_Msg_Level
2730 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2731 THEN
2732 FND_MSG_PUB.Add_Exc_Msg
2733 (g_pkg_name,
2734 l_api_name);
2735 END IF;
2736 END dump_counter_readings_tbl;
2737
2738 PROCEDURE dump_ctr_property_readings_rec
2739 (p_ctr_property_readings_rec IN csi_ctr_datastructures_pub.ctr_property_readings_rec) IS
2740 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_property_readings_rec';
2741 l_api_version CONSTANT NUMBER := 1.0;
2742 BEGIN
2743 SAVEPOINT dump_ctr_property_readings_rec;
2744
2745 -- Read the debug profiles values in to global variable 7197402
2746 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2747
2751
2748 PUT_LINE (' ');
2749 PUT_LINE ('Dumping the values for Counter Property Readings Record:');
2750 PUT_LINE (' ');
2752 PUT_LINE ('COUNTER_PROP_VALUE_ID :'||p_ctr_property_readings_rec.COUNTER_PROP_VALUE_ID);
2753 PUT_LINE ('COUNTER_VALUE_ID :'||p_ctr_property_readings_rec.COUNTER_VALUE_ID);
2754 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_property_readings_rec.COUNTER_PROPERTY_ID);
2755 PUT_LINE ('PROPERTY_VALUE :'||p_ctr_property_readings_rec.PROPERTY_VALUE);
2756 PUT_LINE ('VALUE_TIMESTAMP :'||p_ctr_property_readings_rec.VALUE_TIMESTAMP);
2757 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_property_readings_rec.OBJECT_VERSION_NUMBER);
2758 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_property_readings_rec.ATTRIBUTE1);
2759 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_property_readings_rec.ATTRIBUTE2);
2760 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_property_readings_rec.ATTRIBUTE3);
2761 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_property_readings_rec.ATTRIBUTE4);
2762 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_property_readings_rec.ATTRIBUTE5);
2763 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_property_readings_rec.ATTRIBUTE6);
2764 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_property_readings_rec.ATTRIBUTE7);
2765 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_property_readings_rec.ATTRIBUTE8);
2766 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_property_readings_rec.ATTRIBUTE9);
2767 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_property_readings_rec.ATTRIBUTE10);
2768 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_property_readings_rec.ATTRIBUTE11);
2769 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_property_readings_rec.ATTRIBUTE12);
2770 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_property_readings_rec.ATTRIBUTE13);
2771 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_property_readings_rec.ATTRIBUTE14);
2772 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_property_readings_rec.ATTRIBUTE15);
2773 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_property_readings_rec.ATTRIBUTE_CATEGORY);
2774 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_property_readings_rec.SECURITY_GROUP_ID);
2775 PUT_LINE ('PARENT_TBL_INDEX :'||p_ctr_property_readings_rec.PARENT_TBL_INDEX);
2776
2777
2778 EXCEPTION
2779 WHEN OTHERS THEN
2780 ROLLBACK TO dump_ctr_property_readings_rec;
2781 IF FND_MSG_PUB.Check_Msg_Level
2782 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2783 THEN
2784 FND_MSG_PUB.Add_Exc_Msg
2785 (g_pkg_name,
2786 l_api_name);
2787 END IF;
2788 END dump_ctr_property_readings_rec;
2789
2790 PROCEDURE dump_ctr_property_readings_tbl
2791 (p_ctr_property_readings_tbl IN csi_ctr_datastructures_pub.ctr_property_readings_tbl) IS
2792 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_property_readings_tbl';
2793 l_api_version CONSTANT NUMBER := 1.0;
2794
2795 BEGIN
2796 SAVEPOINT dump_ctr_property_readings_tbl;
2797
2798 -- Read the debug profiles values in to global variable 7197402
2799 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2800
2801 IF p_ctr_property_readings_tbl.COUNT > 0 THEN
2802 FOR tab_row IN p_ctr_property_readings_tbl.FIRST .. p_ctr_property_readings_tbl.LAST
2803 LOOP
2804 IF p_ctr_property_readings_tbl.EXISTS(tab_row) THEN
2805
2806 PUT_LINE (' ');
2807 PUT_LINE ('Dumping the values for Counter Property Readings Table Record # : '||tab_row);
2808 PUT_LINE (' ');
2809
2810 PUT_LINE ('COUNTER_PROP_VALUE_ID :'||p_ctr_property_readings_tbl(tab_row).COUNTER_PROP_VALUE_ID);
2811 PUT_LINE ('COUNTER_VALUE_ID :'||p_ctr_property_readings_tbl(tab_row).COUNTER_VALUE_ID);
2812 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_property_readings_tbl(tab_row).COUNTER_PROPERTY_ID);
2813 PUT_LINE ('PROPERTY_VALUE :'||p_ctr_property_readings_tbl(tab_row).PROPERTY_VALUE);
2814 PUT_LINE ('VALUE_TIMESTAMP :'||p_ctr_property_readings_tbl(tab_row).VALUE_TIMESTAMP);
2815 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_property_readings_tbl(tab_row).OBJECT_VERSION_NUMBER);
2816 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE1);
2817 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE2);
2818 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE3);
2819 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE4);
2820 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE5);
2821 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE6);
2822 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE7);
2823 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE8);
2824 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE9);
2825 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE10);
2826 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE11);
2827 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE12);
2828 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE13);
2829 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE14);
2830 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE15);
2831 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE_CATEGORY);
2835 END LOOP;
2832 PUT_LINE ('PARENT_TBL_INDEX :'||p_ctr_property_readings_tbl(tab_row).PARENT_TBL_INDEX);
2833
2834 END IF;
2836 END IF;
2837 EXCEPTION
2838 WHEN OTHERS THEN
2839 ROLLBACK TO dump_ctr_property_readings_tbl;
2840 IF FND_MSG_PUB.Check_Msg_Level
2841 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2842 THEN
2843 FND_MSG_PUB.Add_Exc_Msg
2844 (g_pkg_name,
2845 l_api_name);
2846 END IF;
2847 END dump_ctr_property_readings_tbl;
2848
2849 PROCEDURE dump_ctr_usage_forecast_rec
2850 (p_ctr_usage_forecast_rec IN csi_ctr_datastructures_pub.ctr_usage_forecast_rec) IS
2851 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_usage_forecast_rec';
2852 l_api_version CONSTANT NUMBER := 1.0;
2853 BEGIN
2854 SAVEPOINT dump_ctr_usage_forecast_rec;
2855
2856 -- Read the debug profiles values in to global variable 7197402
2857 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2858
2859 PUT_LINE (' ');
2860 PUT_LINE ('Dumping the values for Counter Usage Forecast Record:');
2861 PUT_LINE (' ');
2862
2863 PUT_LINE ('INSTANCE_FORECAST_ID :'||p_ctr_usage_forecast_rec.INSTANCE_FORECAST_ID);
2864 PUT_LINE ('COUNTER_ID :'||p_ctr_usage_forecast_rec.COUNTER_ID);
2865 PUT_LINE ('USAGE_RATE :'||p_ctr_usage_forecast_rec.USAGE_RATE);
2866 PUT_LINE ('USE_PAST_READING :'||p_ctr_usage_forecast_rec.USE_PAST_READING);
2867 PUT_LINE ('ACTIVE_START_DATE :'||p_ctr_usage_forecast_rec.ACTIVE_START_DATE);
2868 PUT_LINE ('ACTIVE_END_DATE :'||p_ctr_usage_forecast_rec.ACTIVE_END_DATE);
2869 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_usage_forecast_rec.OBJECT_VERSION_NUMBER);
2870 EXCEPTION
2871 WHEN OTHERS THEN
2872 ROLLBACK TO dump_ctr_usage_forecast_rec;
2873 IF FND_MSG_PUB.Check_Msg_Level
2874 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2875 THEN
2876 FND_MSG_PUB.Add_Exc_Msg
2877 (g_pkg_name,
2878 l_api_name);
2879 END IF;
2880 END dump_ctr_usage_forecast_rec;
2881
2882 PROCEDURE dump_ctr_usage_forecast_tbl
2883 (p_ctr_usage_forecast_tbl IN csi_ctr_datastructures_pub.ctr_usage_forecast_tbl) IS
2884 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_usage_forecast_tbl';
2885 l_api_version CONSTANT NUMBER := 1.0;
2886
2887 BEGIN
2888 SAVEPOINT dump_ctr_usage_forecast_tbl;
2889
2890 -- Read the debug profiles values in to global variable 7197402
2891 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2892
2893 IF p_ctr_usage_forecast_tbl.COUNT > 0 THEN
2894 FOR tab_row IN p_ctr_usage_forecast_tbl.FIRST .. p_ctr_usage_forecast_tbl.LAST
2895 LOOP
2896 IF p_ctr_usage_forecast_tbl.EXISTS(tab_row) THEN
2897
2898 PUT_LINE (' ');
2899 PUT_LINE ('Dumping the values for Counter Usage Forecast Table Record # : '||tab_row);
2900 PUT_LINE (' ');
2901
2902 PUT_LINE ('INSTANCE_FORECAST_ID :'||p_ctr_usage_forecast_tbl(tab_row).INSTANCE_FORECAST_ID);
2903 PUT_LINE ('COUNTER_ID :'||p_ctr_usage_forecast_tbl(tab_row).COUNTER_ID);
2904 PUT_LINE ('USAGE_RATE :'||p_ctr_usage_forecast_tbl(tab_row).USAGE_RATE);
2905 PUT_LINE ('USE_PAST_READING :'||p_ctr_usage_forecast_tbl(tab_row).USE_PAST_READING);
2906 PUT_LINE ('ACTIVE_START_DATE :'||p_ctr_usage_forecast_tbl(tab_row).ACTIVE_START_DATE);
2907 PUT_LINE ('ACTIVE_END_DATE :'||p_ctr_usage_forecast_tbl(tab_row).ACTIVE_END_DATE);
2908 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_usage_forecast_tbl(tab_row).OBJECT_VERSION_NUMBER);
2909
2910 END IF;
2911 END LOOP;
2912 END IF;
2913 EXCEPTION
2914 WHEN OTHERS THEN
2915 ROLLBACK TO dump_ctr_usage_forecast_tbl;
2916 IF FND_MSG_PUB.Check_Msg_Level
2917 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2918 THEN
2919 FND_MSG_PUB.Add_Exc_Msg
2920 (g_pkg_name,
2921 l_api_name);
2922 END IF;
2923 END dump_ctr_usage_forecast_tbl;
2924
2925 PROCEDURE dump_ctr_reading_lock_rec
2926 (p_ctr_reading_lock_rec IN csi_ctr_datastructures_pub.ctr_reading_lock_rec) IS
2927 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_reading_lock_rec';
2928 l_api_version CONSTANT NUMBER := 1.0;
2929
2930 BEGIN
2931 SAVEPOINT dump_ctr_reading_lock_rec;
2932
2933 -- Read the debug profiles values in to global variable 7197402
2934 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2935
2936 PUT_LINE (' ');
2937 PUT_LINE ('Dumping the values for Counter Reading Lock Record:');
2938 PUT_LINE (' ');
2939
2940 PUT_LINE ('READING_LOCK_ID :'||p_ctr_reading_lock_rec.READING_LOCK_ID);
2941 PUT_LINE ('READING_LOCK_DATE :'||p_ctr_reading_lock_rec.READING_LOCK_DATE);
2942 PUT_LINE ('ACTIVE_START_DATE :'||p_ctr_reading_lock_rec.ACTIVE_START_DATE);
2943 PUT_LINE ('ACTIVE_END_DATE :'||p_ctr_reading_lock_rec.ACTIVE_END_DATE);
2944 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_reading_lock_rec.OBJECT_VERSION_NUMBER);
2945 EXCEPTION
2946 WHEN OTHERS THEN
2947 ROLLBACK TO dump_ctr_reading_lock_rec;
2948 IF FND_MSG_PUB.Check_Msg_Level
2949 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2950 THEN
2951 FND_MSG_PUB.Add_Exc_Msg
2952 (g_pkg_name,
2953 l_api_name);
2954 END IF;
2955 END dump_ctr_reading_lock_rec;
2956
2960 l_api_version CONSTANT NUMBER := 1.0;
2957 PROCEDURE dump_ctr_reading_lock_tbl
2958 (p_ctr_reading_lock_tbl IN csi_ctr_datastructures_pub.ctr_reading_lock_tbl) IS
2959 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_reading_lock_tbl';
2961
2962 BEGIN
2963 SAVEPOINT dump_ctr_reading_lock_tbl;
2964
2965 -- Read the debug profiles values in to global variable 7197402
2966 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2967
2968 IF p_ctr_reading_lock_tbl.COUNT > 0 THEN
2969 FOR tab_row IN p_ctr_reading_lock_tbl.FIRST .. p_ctr_reading_lock_tbl.LAST
2970 LOOP
2971 IF p_ctr_reading_lock_tbl.EXISTS(tab_row) THEN
2972
2973 PUT_LINE (' ');
2974 PUT_LINE ('Dumping the values for Counter Reading Lock Table Record # : '||tab_row);
2975 PUT_LINE (' ');
2976
2977 PUT_LINE ('READING_LOCK_ID :'||p_ctr_reading_lock_tbl(tab_row).READING_LOCK_ID);
2978 PUT_LINE ('READING_LOCK_DATE :'||p_ctr_reading_lock_tbl(tab_row).READING_LOCK_DATE);
2979 PUT_LINE ('ACTIVE_START_DATE :'||p_ctr_reading_lock_tbl(tab_row).ACTIVE_START_DATE);
2980 PUT_LINE ('ACTIVE_END_DATE :'||p_ctr_reading_lock_tbl(tab_row).ACTIVE_END_DATE);
2981 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_reading_lock_tbl(tab_row).OBJECT_VERSION_NUMBER);
2982
2983 END IF;
2984 END LOOP;
2985 END IF;
2986 EXCEPTION
2987 WHEN OTHERS THEN
2988 ROLLBACK TO dump_ctr_reading_lock_tbl;
2989 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2990 THEN
2991 FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);
2992 END IF;
2993 END dump_ctr_reading_lock_tbl;
2994
2995 PROCEDURE dm_ctr_estimated_readings_rec
2996 (p_ctr_estimated_readings_rec IN csi_ctr_datastructures_pub.ctr_estimated_readings_rec) IS
2997 l_api_name CONSTANT VARCHAR2(30) := 'dm_ctr_estimated_readings_rec';
2998 l_api_version CONSTANT NUMBER := 1.0;
2999 BEGIN
3000 SAVEPOINT dm_ctr_estimated_readings_rec;
3001
3002 -- Read the debug profiles values in to global variable 7197402
3003 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3004
3005 PUT_LINE (' ');
3006 PUT_LINE ('Dumping the values for Counter Estimated Readings Record:');
3007 PUT_LINE (' ');
3008
3009 PUT_LINE ('ESTIMATED_READING_ID :'||p_ctr_estimated_readings_rec.ESTIMATED_READING_ID);
3010 PUT_LINE ('COUNTER_ID :'||p_ctr_estimated_readings_rec.COUNTER_ID);
3011 PUT_LINE ('ESTIMATION_ID :'||p_ctr_estimated_readings_rec.ESTIMATION_ID);
3012 PUT_LINE ('VALUE_TIMESTAMP :'||p_ctr_estimated_readings_rec.VALUE_TIMESTAMP);
3013 PUT_LINE ('ESTIMATED_METER_READING :'||p_ctr_estimated_readings_rec.ESTIMATED_METER_READING);
3014 PUT_LINE ('NUM_OF_READINGS :'||p_ctr_estimated_readings_rec.NUM_OF_READINGS);
3015 PUT_LINE ('PERIOD_START_DATE :'||p_ctr_estimated_readings_rec.PERIOD_START_DATE);
3016 PUT_LINE ('PERIOD_END_DATE :'||p_ctr_estimated_readings_rec.PERIOD_END_DATE);
3017 PUT_LINE ('AVG_CALCULATION_START_DATE :'||p_ctr_estimated_readings_rec.AVG_CALCULATION_START_DATE);
3018 PUT_LINE ('ESTIMATED_USAGE :'||p_ctr_estimated_readings_rec.ESTIMATED_USAGE);
3019 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_estimated_readings_rec.ATTRIBUTE1);
3020 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_estimated_readings_rec.ATTRIBUTE2);
3021 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_estimated_readings_rec.ATTRIBUTE3);
3022 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_estimated_readings_rec.ATTRIBUTE4);
3023 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_estimated_readings_rec.ATTRIBUTE5);
3024 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_estimated_readings_rec.ATTRIBUTE6);
3025 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_estimated_readings_rec.ATTRIBUTE7);
3026 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_estimated_readings_rec.ATTRIBUTE8);
3027 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_estimated_readings_rec.ATTRIBUTE9);
3028 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_estimated_readings_rec.ATTRIBUTE10);
3029 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_estimated_readings_rec.ATTRIBUTE11);
3030 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_estimated_readings_rec.ATTRIBUTE12);
3031 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_estimated_readings_rec.ATTRIBUTE13);
3032 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_estimated_readings_rec.ATTRIBUTE14);
3033 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_estimated_readings_rec.ATTRIBUTE15);
3034 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_estimated_readings_rec.ATTRIBUTE_CATEGORY);
3035 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_estimated_readings_rec.OBJECT_VERSION_NUMBER);
3036 EXCEPTION
3037 WHEN OTHERS THEN
3038 ROLLBACK TO dm_ctr_estimated_readings_rec;
3039 IF FND_MSG_PUB.Check_Msg_Level
3040 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3041 THEN
3042 FND_MSG_PUB.Add_Exc_Msg
3043 (g_pkg_name,
3044 l_api_name);
3045 END IF;
3046 END dm_ctr_estimated_readings_rec;
3047
3048 PROCEDURE dm_ctr_estimated_readings_tbl
3049 (p_ctr_estimated_readings_tbl IN csi_ctr_datastructures_pub.ctr_estimated_readings_tbl) IS
3050 l_api_name CONSTANT VARCHAR2(30) := 'dm_ctr_estimated_readings_tbl';
3051 l_api_version CONSTANT NUMBER := 1.0;
3052
3053 BEGIN
3054 SAVEPOINT dm_ctr_estimated_readings_tbl;
3055
3056 -- Read the debug profiles values in to global variable 7197402
3057 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3058
3059 IF p_ctr_estimated_readings_tbl.COUNT > 0 THEN
3060 FOR tab_row IN p_ctr_estimated_readings_tbl.FIRST .. p_ctr_estimated_readings_tbl.LAST
3061 LOOP
3065 PUT_LINE ('Dumping the values for Counter Estimated Readings Table Record # : '||tab_row);
3062 IF p_ctr_estimated_readings_tbl.EXISTS(tab_row) THEN
3063
3064 PUT_LINE (' ');
3066 PUT_LINE (' ');
3067
3068 PUT_LINE ('ESTIMATED_READING_ID :'||p_ctr_estimated_readings_tbl(tab_row).ESTIMATED_READING_ID);
3069 PUT_LINE ('COUNTER_ID :'||p_ctr_estimated_readings_tbl(tab_row).COUNTER_ID);
3070 PUT_LINE ('ESTIMATION_ID :'||p_ctr_estimated_readings_tbl(tab_row).ESTIMATION_ID);
3071 PUT_LINE ('VALUE_TIMESTAMP :'||p_ctr_estimated_readings_tbl(tab_row).VALUE_TIMESTAMP);
3072 PUT_LINE ('ESTIMATED_METER_READING :'||p_ctr_estimated_readings_tbl(tab_row).ESTIMATED_METER_READING);
3073 PUT_LINE ('NUM_OF_READINGS :'||p_ctr_estimated_readings_tbl(tab_row).NUM_OF_READINGS);
3074 PUT_LINE ('PERIOD_START_DATE :'||p_ctr_estimated_readings_tbl(tab_row).PERIOD_START_DATE);
3075 PUT_LINE ('PERIOD_END_DATE :'||p_ctr_estimated_readings_tbl(tab_row).PERIOD_END_DATE);
3076 PUT_LINE ('AVG_CALCULATION_START_DATE :'||p_ctr_estimated_readings_tbl(tab_row).AVG_CALCULATION_START_DATE);
3077 PUT_LINE ('ESTIMATED_USAGE :'||p_ctr_estimated_readings_tbl(tab_row).ESTIMATED_USAGE);
3078 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE1);
3079 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE2);
3080 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE3);
3081 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE4);
3082 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE5);
3083 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE6);
3084 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE7);
3085 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE8);
3086 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE9);
3087 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE10);
3088 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE11);
3089 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE12);
3090 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE13);
3091 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE14);
3092 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE15);
3093 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE_CATEGORY);
3094 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_estimated_readings_tbl(tab_row).OBJECT_VERSION_NUMBER);
3095
3096 END IF;
3097 END LOOP;
3098 END IF;
3099 EXCEPTION
3100 WHEN OTHERS THEN
3101 ROLLBACK TO dm_ctr_estimated_readings_tbl;
3102 IF FND_MSG_PUB.Check_Msg_Level
3103 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3104 THEN
3105 FND_MSG_PUB.Add_Exc_Msg
3106 (g_pkg_name, l_api_name);
3107 END IF;
3108 END dm_ctr_estimated_readings_tbl;
3109
3110 PROCEDURE dm_ctr_readings_interface_rec
3111 (p_ctr_readings_interface_rec IN csi_ctr_datastructures_pub.ctr_readings_interface_rec) IS
3112 l_api_name CONSTANT VARCHAR2(30) := 'dm_ctr_readings_interface_rec';
3113 l_api_version CONSTANT NUMBER := 1.0;
3114 BEGIN
3115 SAVEPOINT dm_ctr_readings_interface_rec;
3116
3117 -- Read the debug profiles values in to global variable 7197402
3118 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3119
3120 PUT_LINE (' ');
3121 PUT_LINE ('Dumping the values for Counter Readings Open Interface Record:');
3122 PUT_LINE (' ');
3123
3124 PUT_LINE ('COUNTER_INTERFACE_ID :'||p_ctr_readings_interface_rec.COUNTER_INTERFACE_ID);
3125 PUT_LINE ('PARALLEL_WORKER_ID :'||p_ctr_readings_interface_rec.PARALLEL_WORKER_ID);
3126 PUT_LINE ('BATCH_NAME :'||p_ctr_readings_interface_rec.BATCH_NAME);
3127 PUT_LINE ('SOURCE_TRANSACTION_DATE :'||p_ctr_readings_interface_rec.SOURCE_TRANSACTION_DATE);
3128 PUT_LINE ('PROCESS_STATUS :'||p_ctr_readings_interface_rec.PROCESS_STATUS);
3129 PUT_LINE ('ERROR_TEXT :'||p_ctr_readings_interface_rec.ERROR_TEXT);
3130 PUT_LINE ('COUNTER_VALUE_ID :'||p_ctr_readings_interface_rec.COUNTER_VALUE_ID);
3131 PUT_LINE ('COUNTER_ID :'||p_ctr_readings_interface_rec.COUNTER_ID);
3132 PUT_LINE ('VALUE_TIMESTAMP :'||p_ctr_readings_interface_rec.VALUE_TIMESTAMP);
3133 PUT_LINE ('COUNTER_READING :'||p_ctr_readings_interface_rec.COUNTER_READING);
3134 PUT_LINE ('RESET_MODE :'||p_ctr_readings_interface_rec.RESET_MODE);
3135 PUT_LINE ('RESET_REASON :'||p_ctr_readings_interface_rec.RESET_REASON);
3136 PUT_LINE ('ADJUSTMENT_TYPE :'||p_ctr_readings_interface_rec.ADJUSTMENT_TYPE);
3137 PUT_LINE ('ADJUSTMENT_READING :'||p_ctr_readings_interface_rec.ADJUSTMENT_READING);
3138 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_readings_interface_rec.OBJECT_VERSION_NUMBER);
3139 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_readings_interface_rec.ATTRIBUTE1);
3140 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_readings_interface_rec.ATTRIBUTE2);
3141 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_readings_interface_rec.ATTRIBUTE3);
3142 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_readings_interface_rec.ATTRIBUTE4);
3143 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_readings_interface_rec.ATTRIBUTE5);
3144 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_readings_interface_rec.ATTRIBUTE6);
3148 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_readings_interface_rec.ATTRIBUTE10);
3145 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_readings_interface_rec.ATTRIBUTE7);
3146 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_readings_interface_rec.ATTRIBUTE8);
3147 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_readings_interface_rec.ATTRIBUTE9);
3149 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_readings_interface_rec.ATTRIBUTE11);
3150 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_readings_interface_rec.ATTRIBUTE12);
3151 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_readings_interface_rec.ATTRIBUTE13);
3152 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_readings_interface_rec.ATTRIBUTE14);
3153 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_readings_interface_rec.ATTRIBUTE15);
3154 PUT_LINE ('ATTRIBUTE16 :'||p_ctr_readings_interface_rec.ATTRIBUTE16);
3155 PUT_LINE ('ATTRIBUTE17 :'||p_ctr_readings_interface_rec.ATTRIBUTE17);
3156 PUT_LINE ('ATTRIBUTE18 :'||p_ctr_readings_interface_rec.ATTRIBUTE18);
3157 PUT_LINE ('ATTRIBUTE19 :'||p_ctr_readings_interface_rec.ATTRIBUTE19);
3158 PUT_LINE ('ATTRIBUTE20 :'||p_ctr_readings_interface_rec.ATTRIBUTE20);
3159 PUT_LINE ('ATTRIBUTE21 :'||p_ctr_readings_interface_rec.ATTRIBUTE21);
3160 PUT_LINE ('ATTRIBUTE22 :'||p_ctr_readings_interface_rec.ATTRIBUTE22);
3161 PUT_LINE ('ATTRIBUTE23 :'||p_ctr_readings_interface_rec.ATTRIBUTE23);
3162 PUT_LINE ('ATTRIBUTE24 :'||p_ctr_readings_interface_rec.ATTRIBUTE24);
3163 PUT_LINE ('ATTRIBUTE25 :'||p_ctr_readings_interface_rec.ATTRIBUTE25);
3164 PUT_LINE ('ATTRIBUTE26 :'||p_ctr_readings_interface_rec.ATTRIBUTE26);
3165 PUT_LINE ('ATTRIBUTE27 :'||p_ctr_readings_interface_rec.ATTRIBUTE27);
3166 PUT_LINE ('ATTRIBUTE28 :'||p_ctr_readings_interface_rec.ATTRIBUTE28);
3167 PUT_LINE ('ATTRIBUTE29 :'||p_ctr_readings_interface_rec.ATTRIBUTE29);
3168 PUT_LINE ('ATTRIBUTE30 :'||p_ctr_readings_interface_rec.ATTRIBUTE30);
3169 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_readings_interface_rec.ATTRIBUTE_CATEGORY);
3170 PUT_LINE ('COMMENTS :'||p_ctr_readings_interface_rec.COMMENTS);
3171 PUT_LINE ('LIFE_TO_DATE_READING :'||p_ctr_readings_interface_rec.LIFE_TO_DATE_READING);
3172 PUT_LINE ('NET_READING :'||p_ctr_readings_interface_rec.NET_READING);
3173 PUT_LINE ('DISABLED_FLAG :'||p_ctr_readings_interface_rec.DISABLED_FLAG);
3174 PUT_LINE ('SOURCE_CODE :'||p_ctr_readings_interface_rec.SOURCE_CODE);
3175 PUT_LINE ('SOURCE_LINE_ID :'||p_ctr_readings_interface_rec.SOURCE_LINE_ID);
3176 PUT_LINE ('COUNTER_NAME :'||p_ctr_readings_interface_rec.COUNTER_NAME);
3177 PUT_LINE ('INCLUDE_TARGET_RESETS :'||p_ctr_readings_interface_rec.INCLUDE_TARGET_RESETS);
3178 PUT_LINE ('AUTOMATIC_ROLLOVER_FLAG :'||p_ctr_readings_interface_rec.AUTOMATIC_ROLLOVER_FLAG);
3179 PUT_LINE ('SOURCE_COUNTER_VALUE_ID :'||p_ctr_readings_interface_rec.SOURCE_COUNTER_VALUE_ID);
3180 EXCEPTION
3181 WHEN OTHERS THEN
3182 ROLLBACK TO dm_ctr_readings_interface_rec;
3183 IF FND_MSG_PUB.Check_Msg_Level
3184 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3185 THEN
3186 FND_MSG_PUB.Add_Exc_Msg
3187 (g_pkg_name,
3188 l_api_name);
3189 END IF;
3190 END dm_ctr_readings_interface_rec;
3191
3192 PROCEDURE dm_ctr_readings_interface_tbl
3193 (p_ctr_readings_interface_tbl IN csi_ctr_datastructures_pub.ctr_readings_interface_tbl) IS
3194 l_api_name CONSTANT VARCHAR2(30) := 'dm_ctr_readings_interface_tbl';
3195 l_api_version CONSTANT NUMBER := 1.0;
3196
3197 BEGIN
3198 SAVEPOINT dm_ctr_readings_interface_tbl;
3199
3200 -- Read the debug profiles values in to global variable 7197402
3201 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3202
3203 IF p_ctr_readings_interface_tbl.COUNT > 0 THEN
3204 FOR tab_row IN p_ctr_readings_interface_tbl.FIRST .. p_ctr_readings_interface_tbl.LAST
3205 LOOP
3206 IF p_ctr_readings_interface_tbl.EXISTS(tab_row) THEN
3207
3208 PUT_LINE (' ');
3209 PUT_LINE ('Dumping the values for Counter Readings Open Interface Table Record # : '||tab_row);
3210 PUT_LINE (' ');
3211
3212 PUT_LINE ('COUNTER_INTERFACE_ID :'||p_ctr_readings_interface_tbl(tab_row).COUNTER_INTERFACE_ID);
3213 PUT_LINE ('PARALLEL_WORKER_ID :'||p_ctr_readings_interface_tbl(tab_row).PARALLEL_WORKER_ID);
3214 PUT_LINE ('BATCH_NAME :'||p_ctr_readings_interface_tbl(tab_row).BATCH_NAME);
3215 PUT_LINE ('SOURCE_TRANSACTION_DATE :'||p_ctr_readings_interface_tbl(tab_row).SOURCE_TRANSACTION_DATE); PUT_LINE ('PROCESS_STATUS :'||p_ctr_readings_interface_tbl(tab_row).PROCESS_STATUS);
3216 PUT_LINE ('ERROR_TEXT :'||p_ctr_readings_interface_tbl(tab_row).ERROR_TEXT);
3217 PUT_LINE ('COUNTER_VALUE_ID :'||p_ctr_readings_interface_tbl(tab_row).COUNTER_VALUE_ID);
3218 PUT_LINE ('COUNTER_ID :'||p_ctr_readings_interface_tbl(tab_row).COUNTER_ID);
3219 PUT_LINE ('VALUE_TIMESTAMP :'||p_ctr_readings_interface_tbl(tab_row).VALUE_TIMESTAMP);
3220 PUT_LINE ('COUNTER_READING :'||p_ctr_readings_interface_tbl(tab_row).COUNTER_READING);
3221 PUT_LINE ('RESET_MODE :'||p_ctr_readings_interface_tbl(tab_row).RESET_MODE);
3222 PUT_LINE ('RESET_REASON :'||p_ctr_readings_interface_tbl(tab_row).RESET_REASON);
3223 PUT_LINE ('ADJUSTMENT_TYPE :'||p_ctr_readings_interface_tbl(tab_row).ADJUSTMENT_TYPE);
3224 PUT_LINE ('ADJUSTMENT_READING :'||p_ctr_readings_interface_tbl(tab_row).ADJUSTMENT_READING);
3225 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_readings_interface_tbl(tab_row).OBJECT_VERSION_NUMBER);
3229 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE4);
3226 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE1);
3227 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE2);
3228 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE3);
3230 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE5);
3231 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE6);
3232 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE7);
3233 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE8);
3234 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE9);
3235 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE10);
3236 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE11);
3237 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE12);
3238 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE13);
3239 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE14);
3240 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE15);
3241 PUT_LINE ('ATTRIBUTE16 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE16);
3242 PUT_LINE ('ATTRIBUTE17 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE17);
3243 PUT_LINE ('ATTRIBUTE18 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE18);
3244 PUT_LINE ('ATTRIBUTE19 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE19);
3245 PUT_LINE ('ATTRIBUTE20 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE20);
3246 PUT_LINE ('ATTRIBUTE21 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE21);
3247 PUT_LINE ('ATTRIBUTE22 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE22);
3248 PUT_LINE ('ATTRIBUTE23 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE23);
3249 PUT_LINE ('ATTRIBUTE24 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE24);
3250 PUT_LINE ('ATTRIBUTE25 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE25);
3251 PUT_LINE ('ATTRIBUTE26 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE26);
3252 PUT_LINE ('ATTRIBUTE27 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE27);
3253 PUT_LINE ('ATTRIBUTE28 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE28);
3254 PUT_LINE ('ATTRIBUTE29 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE29);
3255 PUT_LINE ('ATTRIBUTE30 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE30);
3256 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE_CATEGORY);
3257 PUT_LINE ('COMMENTS :'||p_ctr_readings_interface_tbl(tab_row).COMMENTS);
3258 PUT_LINE ('LIFE_TO_DATE_READING :'||p_ctr_readings_interface_tbl(tab_row).LIFE_TO_DATE_READING);
3259 PUT_LINE ('NET_READING :'||p_ctr_readings_interface_tbl(tab_row).NET_READING);
3260 PUT_LINE ('DISABLED_FLAG :'||p_ctr_readings_interface_tbl(tab_row).DISABLED_FLAG);
3261 PUT_LINE ('SOURCE_CODE :'||p_ctr_readings_interface_tbl(tab_row).SOURCE_CODE);
3262 PUT_LINE ('SOURCE_LINE_ID :'||p_ctr_readings_interface_tbl(tab_row).SOURCE_LINE_ID);
3263 PUT_LINE ('COUNTER_NAME :'||p_ctr_readings_interface_tbl(tab_row).COUNTER_NAME);
3264 PUT_LINE ('INCLUDE_TARGET_RESETS :'||p_ctr_readings_interface_tbl(tab_row).INCLUDE_TARGET_RESETS);
3265 PUT_LINE ('AUTOMATIC_ROLLOVER_FLAG :'||p_ctr_readings_interface_tbl(tab_row).AUTOMATIC_ROLLOVER_FLAG);
3266 PUT_LINE ('SOURCE_COUNTER_VALUE_ID :'||p_ctr_readings_interface_tbl(tab_row).SOURCE_COUNTER_VALUE_ID);
3267 END IF;
3268 END LOOP;
3269 END IF;
3270 EXCEPTION
3271 WHEN OTHERS THEN
3272 ROLLBACK TO dm_ctr_readings_interface_tbl;
3273 IF FND_MSG_PUB.Check_Msg_Level
3274 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3275 THEN
3276 FND_MSG_PUB.Add_Exc_Msg
3277 (g_pkg_name, l_api_name);
3278 END IF;
3279 END dm_ctr_readings_interface_tbl;
3280
3281 PROCEDURE dm_ctr_read_prop_interface_rec
3282 (p_ctr_read_prop_interface_rec IN csi_ctr_datastructures_pub.ctr_read_prop_interface_rec) IS
3283 l_api_name CONSTANT VARCHAR2(30) := 'dm_ctr_read_prop_interface_rec';
3284 l_api_version CONSTANT NUMBER := 1.0;
3285 BEGIN
3286 SAVEPOINT dm_ctr_read_prop_interface_rec;
3287
3288 -- Read the debug profiles values in to global variable 7197402
3289 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3290
3291 PUT_LINE (' ');
3292 PUT_LINE ('Dumping the values for Counter Readings Properties Interface Record:');
3293 PUT_LINE (' ');
3294
3295 PUT_LINE ('COUNTER_INTERFACE_ID :'||p_ctr_read_prop_interface_rec.COUNTER_INTERFACE_ID);
3296 PUT_LINE ('PARALLEL_WORKER_ID :'||p_ctr_read_prop_interface_rec.PARALLEL_WORKER_ID);
3297 PUT_LINE ('ERROR_TEXT :'||p_ctr_read_prop_interface_rec.ERROR_TEXT);
3298 PUT_LINE ('COUNTER_PROP_VALUE_ID :'||p_ctr_read_prop_interface_rec.COUNTER_PROP_VALUE_ID);
3299 PUT_LINE ('COUNTER_VALUE_ID :'||p_ctr_read_prop_interface_rec.COUNTER_VALUE_ID);
3300 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_read_prop_interface_rec.COUNTER_PROPERTY_ID);
3301 PUT_LINE ('PROPERTY_VALUE :'||p_ctr_read_prop_interface_rec.PROPERTY_VALUE);
3302 PUT_LINE ('VALUE_TIMESTAMP :'||p_ctr_read_prop_interface_rec.VALUE_TIMESTAMP);
3306 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE3);
3303 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_read_prop_interface_rec.OBJECT_VERSION_NUMBER);
3304 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE1);
3305 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE2);
3307 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE4);
3308 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE5);
3309 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE6);
3310 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE7);
3311 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE8);
3312 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE9);
3313 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE10);
3314 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE11);
3315 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE12);
3316 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE13);
3317 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE14);
3318 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE15);
3319 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_read_prop_interface_rec.ATTRIBUTE_CATEGORY);
3320 EXCEPTION
3321 WHEN OTHERS THEN
3322 ROLLBACK TO dm_ctr_read_prop_interface_rec;
3323 IF FND_MSG_PUB.Check_Msg_Level
3324 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3325 THEN
3326 FND_MSG_PUB.Add_Exc_Msg
3327 (g_pkg_name,
3328 l_api_name);
3329 END IF;
3330 END dm_ctr_read_prop_interface_rec;
3331
3332 PROCEDURE dm_ctr_read_prop_interface_tbl
3333 (p_ctr_read_prop_interface_tbl IN csi_ctr_datastructures_pub.ctr_read_prop_interface_tbl) IS
3334 l_api_name CONSTANT VARCHAR2(30) := 'dm_ctr_read_prop_interface_tbl';
3335 l_api_version CONSTANT NUMBER := 1.0;
3336
3337 BEGIN
3338 SAVEPOINT dm_ctr_read_prop_interface_tbl;
3339
3340 -- Read the debug profiles values in to global variable 7197402
3341 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3342
3343 IF p_ctr_read_prop_interface_tbl.COUNT > 0 THEN
3344 FOR tab_row IN p_ctr_read_prop_interface_tbl.FIRST .. p_ctr_read_prop_interface_tbl.LAST
3345 LOOP
3346 IF p_ctr_read_prop_interface_tbl.EXISTS(tab_row) THEN
3347
3348 PUT_LINE (' ');
3349 PUT_LINE ('Dumping the values for Counter Readings Property Interface Table Record # : '||tab_row);
3350 PUT_LINE (' ');
3351
3352 PUT_LINE ('COUNTER_INTERFACE_ID :'||p_ctr_read_prop_interface_tbl(tab_row).COUNTER_INTERFACE_ID);
3353 PUT_LINE ('PARALLEL_WORKER_ID :'||p_ctr_read_prop_interface_tbl(tab_row).PARALLEL_WORKER_ID);
3354 PUT_LINE ('ERROR_TEXT :'||p_ctr_read_prop_interface_tbl(tab_row).ERROR_TEXT);
3355 PUT_LINE ('COUNTER_PROP_VALUE_ID :'||p_ctr_read_prop_interface_tbl(tab_row).COUNTER_PROP_VALUE_ID);
3356 PUT_LINE ('COUNTER_VALUE_ID :'||p_ctr_read_prop_interface_tbl(tab_row).COUNTER_VALUE_ID);
3357 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_read_prop_interface_tbl(tab_row).COUNTER_PROPERTY_ID);
3358 PUT_LINE ('PROPERTY_VALUE :'||p_ctr_read_prop_interface_tbl(tab_row).PROPERTY_VALUE);
3359 PUT_LINE ('VALUE_TIMESTAMP :'||p_ctr_read_prop_interface_tbl(tab_row).VALUE_TIMESTAMP);
3360 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_read_prop_interface_tbl(tab_row).OBJECT_VERSION_NUMBER);
3361 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE1);
3362 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE2);
3363 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE3);
3364 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE4);
3365 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE5);
3366 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE6);
3367 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE7);
3368 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE8);
3369 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE9);
3370 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE10);
3371 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE11);
3372 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE12);
3373 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE13);
3374 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE14);
3375 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE15);
3376 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE_CATEGORY);
3377 END IF;
3378 END LOOP;
3379 END IF;
3380 EXCEPTION
3381 WHEN OTHERS THEN
3382 ROLLBACK TO dm_ctr_read_prop_interface_tbl;
3383 IF FND_MSG_PUB.Check_Msg_Level
3384 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3385 THEN
3386 FND_MSG_PUB.Add_Exc_Msg
3387 (g_pkg_name, l_api_name);
3388 END IF;
3389 END dm_ctr_read_prop_interface_tbl;
3390
3391
3392 PROCEDURE dump_txn_rec
3393 (p_txn_rec IN csi_datastructures_pub.transaction_rec) IS
3394
3395 l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_rec';
3396 l_api_version CONSTANT NUMBER := 1.0;
3397 BEGIN
3398 -- Standard Start of API savepoint
3399 -- SAVEPOINT dump_txn_rec;
3400
3401 -- Read the debug profiles values in to global variable 7197402
3402 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3403
3404 put_line(' ');
3405 put_line('Dumping the values for Transaction Record:');
3406 put_line(' ');
3407 put_line('transaction_id : '|| p_txn_rec.transaction_id );
3408 put_line('transaction_date : '|| p_txn_rec.transaction_date );
3409 put_line('source_transaction_date : '|| p_txn_rec.source_transaction_date );
3410 put_line('transaction_type_id : '|| p_txn_rec.transaction_type_id );
3411 put_line('txn_sub_type_id : '|| p_txn_rec.txn_sub_type_id );
3412 put_line('source_group_ref_id : '|| p_txn_rec.source_group_ref_id );
3413 put_line('source_group_ref : '|| p_txn_rec.source_group_ref );
3414 put_line('source_header_ref_id : '|| p_txn_rec.source_header_ref_id );
3415 put_line('source_header_ref : '|| p_txn_rec.source_header_ref );
3416 put_line('source_line_ref_id : '|| p_txn_rec.source_line_ref_id );
3417 put_line('source_line_ref : '|| p_txn_rec.source_line_ref );
3418 put_line('source_dist_ref_id1 : '|| p_txn_rec.source_dist_ref_id1 );
3419 put_line('source_dist_ref_id2 : '|| p_txn_rec.source_dist_ref_id2 );
3420 put_line('inv_material_transaction_id : '|| p_txn_rec.inv_material_transaction_id );
3421 put_line('transaction_quantity : '|| p_txn_rec.transaction_quantity );
3422 put_line('transaction_uom_code : '|| p_txn_rec.transaction_uom_code );
3423 put_line('transacted_by : '|| p_txn_rec.transacted_by );
3424 put_line('transaction_status_code : '|| p_txn_rec.transaction_status_code );
3425 put_line('transaction_action_code : '|| p_txn_rec.transaction_action_code );
3426 put_line('message_id : '|| p_txn_rec.message_id );
3427 put_line('context : '|| p_txn_rec.context );
3428 put_line('attribute1 : '|| p_txn_rec.attribute1 );
3429 put_line('attribute2 : '|| p_txn_rec.attribute2 );
3430 put_line('attribute3 : '|| p_txn_rec.attribute3 );
3431 put_line('attribute4 : '|| p_txn_rec.attribute4 );
3432 put_line('attribute5 : '|| p_txn_rec.attribute5 );
3433 put_line('attribute6 : '|| p_txn_rec.attribute6 );
3434 put_line('attribute7 : '|| p_txn_rec.attribute7 );
3435 put_line('attribute8 : '|| p_txn_rec.attribute8 );
3436 put_line('attribute9 : '|| p_txn_rec.attribute9 );
3437 put_line('attribute10 : '|| p_txn_rec.attribute10 );
3438 put_line('attribute11 : '|| p_txn_rec.attribute11 );
3439 put_line('attribute12 : '|| p_txn_rec.attribute12 );
3440 put_line('attribute13 : '|| p_txn_rec.attribute13 );
3441 put_line('attribute14 : '|| p_txn_rec.attribute14 );
3442 put_line('attribute15 : '|| p_txn_rec.attribute15 );
3443 put_line('object_version_number : '|| p_txn_rec.object_version_number);
3444 put_line('split_reason_code : '|| p_txn_rec.split_reason_code);
3445 EXCEPTION
3446 WHEN OTHERS THEN
3447 -- ROLLBACK TO dump_txn_rec;
3448
3449 IF FND_MSG_PUB.Check_Msg_Level
3450 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3451 THEN
3452 FND_MSG_PUB.Add_Exc_Msg
3453 ( G_PKG_NAME ,
3454 l_api_name
3455 );
3456 END IF;
3457 END dump_txn_rec;
3458
3459 PROCEDURE dump_txn_tbl
3460 (p_txn_tbl IN csi_datastructures_pub.transaction_tbl) IS
3461 l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_tbl';
3462 l_api_version CONSTANT NUMBER := 1.0;
3463 BEGIN
3464 -- Standard Start of API savepoint
3465 SAVEPOINT dump_txn_tbl;
3466 IF p_txn_tbl.COUNT > 0 THEN
3467 FOR tab_row IN p_txn_tbl.FIRST .. p_txn_tbl.LAST
3468 LOOP
3469 IF p_txn_tbl.EXISTS(tab_row) THEN
3470 dump_txn_rec(p_txn_rec => p_txn_tbl(tab_row));
3471 END IF;
3472 END LOOP;
3473 END IF;
3474 EXCEPTION
3475 WHEN OTHERS THEN
3476 ROLLBACK TO dump_txn_tbl;
3477 IF FND_MSG_PUB.Check_Msg_Level
3478 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3479 THEN
3480 FND_MSG_PUB.Add_Exc_Msg
3481 ( G_PKG_NAME ,
3482 l_api_name
3483 );
3484 END IF;
3485 END dump_txn_tbl;
3486 END;