[Home] [Help]
PACKAGE BODY: APPS.CSI_CTR_GEN_UTILITY_PVT
Source
1 PACKAGE BODY CSI_CTR_GEN_UTILITY_PVT AS
2 /* $Header: csivctub.pls 120.7.12010000.2 2008/10/31 21:28:21 rsinn ship $ */
3
4 -- G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_CTR_GEN_UTILITY_PVT';
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);
59 --
60 g_sid := l_sid;
61 g_osuser := l_os_user;
62 END IF;
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
222 p_desc_flex.attribute7 := p_desc_flex.attribute7;
223 END IF;
224
225 IF p_desc_flex.attribute8 = FND_API.G_MISS_CHAR THEN
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';
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';
382 p_desc_col_name7 VARCHAR2(30) := p_seg_partial_name||'7';
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,
522 p_column_name23 IN VARCHAR2,
523 p_column_name24 IN VARCHAR2,
524 p_column_name25 IN VARCHAR2,
525 p_column_name26 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.
647 IF NOT FND_API.Compatible_API_Call (l_api_version,
648 p_api_version,
649 l_api_name,
650 G_PKG_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
807 FROM csi_counters_bc_v ctr
808 WHERE ctr.counter_id = p_counter_id;
809
810 CURSOR der_filters(b_counter_id number) IS
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
917 l_sqlwhere := l_sqlwhere ||' and '||nvl(filts.left_parent,' ')||' nvl(pv';
918 else
919 l_sqlwhere := l_sqlwhere ||' '||nvl(filts.left_parent,' ')||' nvl(pv';
920 end if;
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
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))||' )';
946 l_sqlwhere := l_sqlwhere || 'to_date( '||':x_right_value'||ltrim(rtrim(filts.seq_no))||','||'''YYYY/MM/DD'''||')';
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,' ');
952 l_sqlwhere := l_sqlwhere || ' '|| filts.logical_operator;
953 if filts.seq_no > 1 then
954 l_sqlwhere := l_sqlwhere || ' and pv'||ltrim(rtrim(filts.seq_no)) ;
955 else
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;
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 END LOOP;
974
975 l_sqlstr := l_sqlstr || l_sqlfrom || ' where '||l_sqlwhere||')';
976
977 csi_ctr_gen_utility_pvt.put_line('l_sqlstr = '||l_sqlstr);
978
979 l_cursor_handle := dbms_sql.open_cursor;
980 DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
981 DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
982
983 BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
984 DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
985
986 while lj < i+1
987 loop
988 l_bind_varname := t2(lj).BINDNAME_DEFVAL;
989 l_bind_varvalc := t2(lj).BINDVAL_DEFVAL;
990 DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
991 l_bind_varname := t2(lj).BINDNAME_RIGHTVAL;
992 l_bind_varvalc := t2(lj).BINDVAL_RIGHTVAL;
993 DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
994 l_bind_varname := t2(lj).BINDNAME_CTRPROPID;
995 l_bind_varvaln := t2(lj).BINDVAL_CTRPROPID;
996 DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvaln);
997 lj:= lj+1;
998 end loop;
999
1000 /* l_n_temp := dbms_sql.execute(l_cursor_handle);
1001 IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
1002 dbms_sql.column_value(l_cursor_handle,1,l_ctr_value);
1003 END IF;
1004 DBMS_SQL.close_cursor(l_cursor_handle);
1005 */
1006 x_valid_flag := 'Y';
1007 END LOOP;
1008 EXCEPTION
1009 WHEN OTHERS THEN
1010 IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN
1011 DBMS_SQL.CLOSE_cursor(l_cursor_handle);
1012 END IF;
1013 RAISE;
1014 END;
1015
1016 IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1017 RAISE FND_API.G_EXC_ERROR;
1018 END IF;
1019 --
1020 -- End of API body
1021 --
1022 -- Standard check for p_commit
1023 IF FND_API.to_Boolean( p_commit )
1024 THEN
1025 COMMIT WORK;
1026 END IF;
1027 -- Standard call to get message count and if count is 1, get message info.
1028 FND_MSG_PUB.Count_And_Get
1029 ( p_count => x_msg_count,
1030 p_data => x_msg_data
1031 );
1032 EXCEPTION
1033 WHEN FND_API.G_EXC_ERROR THEN
1034 ROLLBACK TO VALIDATE_GRPOP;
1035 x_return_status := FND_API.G_RET_STS_ERROR ;
1036 FND_MSG_PUB.Count_And_Get
1037 (p_count => x_msg_count,
1038 p_data => x_msg_data
1039 );
1040 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1041 ROLLBACK TO VALIDATE_GRPOP;
1042 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1043 FND_MSG_PUB.Count_And_Get
1044 (
1045 p_count => x_msg_count,
1046 p_data => x_msg_data
1047 );
1048 WHEN OTHERS THEN
1049 ROLLBACK TO VALIDATE_GRPOP;
1050 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1051 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1052 FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1053 END IF;
1054 FND_MSG_PUB.Count_And_Get
1055 (p_count => x_msg_count ,
1056 p_data => x_msg_data
1057 );
1058 End VALIDATE_GRPOP_CTR;
1059
1060 FUNCTION Is_StartEndDate_Valid
1061 (
1062 p_st_dt IN DATE,
1063 p_end_dt IN DATE,
1064 p_stack_err_msg IN BOOLEAN := TRUE
1065 ) RETURN BOOLEAN IS
1066
1067 l_return_value BOOLEAN := TRUE;
1068 BEGIN
1069 IF (p_st_dt > p_end_dt) THEN
1070 l_return_value := FALSE;
1071 IF ( p_stack_err_msg = TRUE ) THEN
1072 ExitWithErrMsg('CSI_ALL_START_DATE_AFTER_END','START_DATE',p_st_dt,'END_DATE',p_end_dt);
1073 FND_MSG_PUB.Add;
1074 END IF;
1075 END IF;
1076 RETURN l_return_value;
1077 END Is_StartEndDate_Valid;
1078
1079 PROCEDURE Initialize_Desc_Flex_For_Upd
1080 (
1081 l_ctr_derived_filters_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec,
1082 l_old_ctr_derived_filters_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec
1083 ) IS
1084 BEGIN
1085 IF l_ctr_derived_filters_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1086 l_ctr_derived_filters_rec.attribute1 := l_old_ctr_derived_filters_rec.attribute1;
1087 END IF;
1088
1089 IF l_ctr_derived_filters_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1090 l_ctr_derived_filters_rec.attribute2 := l_old_ctr_derived_filters_rec.attribute2;
1091 END IF;
1092
1093 IF l_ctr_derived_filters_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1094 l_ctr_derived_filters_rec.attribute3 := l_old_ctr_derived_filters_rec.attribute3;
1095 END IF;
1096
1097 IF l_ctr_derived_filters_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1098 l_ctr_derived_filters_rec.attribute4 := l_old_ctr_derived_filters_rec.attribute4;
1099 END IF;
1100
1101 IF l_ctr_derived_filters_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1102 l_ctr_derived_filters_rec.attribute5 := l_old_ctr_derived_filters_rec.attribute5;
1103 END IF;
1104
1105 IF l_ctr_derived_filters_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1106 l_ctr_derived_filters_rec.attribute6 := l_old_ctr_derived_filters_rec.attribute6;
1107 END IF;
1108
1109 IF l_ctr_derived_filters_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1110 l_ctr_derived_filters_rec.attribute7 := l_old_ctr_derived_filters_rec.attribute7;
1111 END IF;
1112
1113 IF l_ctr_derived_filters_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1114 l_ctr_derived_filters_rec.attribute8 := l_old_ctr_derived_filters_rec.attribute8;
1115 END IF;
1116
1117 IF l_ctr_derived_filters_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1118 l_ctr_derived_filters_rec.attribute9 := l_old_ctr_derived_filters_rec.attribute9;
1119 END IF;
1120
1121 IF l_ctr_derived_filters_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1122 l_ctr_derived_filters_rec.attribute10 := l_old_ctr_derived_filters_rec.attribute10;
1123 END IF;
1124
1125 IF l_ctr_derived_filters_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1126 l_ctr_derived_filters_rec.attribute11 := l_old_ctr_derived_filters_rec.attribute11;
1127 END IF;
1128
1129 IF l_ctr_derived_filters_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1130 l_ctr_derived_filters_rec.attribute12 := l_old_ctr_derived_filters_rec.attribute12;
1131 END IF;
1132
1133 IF l_ctr_derived_filters_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1134 l_ctr_derived_filters_rec.attribute13 := l_old_ctr_derived_filters_rec.attribute13;
1135 END IF;
1136
1137 IF l_ctr_derived_filters_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1138 l_ctr_derived_filters_rec.attribute14 := l_old_ctr_derived_filters_rec.attribute14;
1139 END IF;
1140
1141 IF l_ctr_derived_filters_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1142 l_ctr_derived_filters_rec.attribute15 := l_old_ctr_derived_filters_rec.attribute15;
1143 END IF;
1144
1145 IF l_ctr_derived_filters_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1146 l_ctr_derived_filters_rec.attribute_category := l_old_ctr_derived_filters_rec.attribute_category;
1147 END IF;
1148 END Initialize_Desc_Flex_For_Upd;
1149
1150
1151 PROCEDURE check_ib_active IS
1152 BEGIN
1153 /* IF NOT csi_gen_utility_pvt.IB_ACTIVE THEN
1154 FND_MESSAGE.Set_Name('CSI', 'CSI_IB_NOT_ACTIVE');
1155 FND_MSG_PUB.Add;
1156 RAISE FND_API.G_Exc_Error;
1157 END IF
1158 */
1159 null;
1160 EXCEPTION
1161 WHEN fnd_api.g_exc_error THEN
1162 RAISE fnd_api.g_exc_error;
1163 WHEN others THEN
1164 FND_MESSAGE.Set_Name('CSI', 'CSI_UNEXP_SQL_ERROR');
1165 FND_MESSAGE.Set_Token('API_NAME', 'Check_IB_Active');
1166 FND_MESSAGE.Set_Token('SQL_ERROR', sqlerrm);
1167 FND_MSG_PUB.Add;
1168 RAISE fnd_api.g_exc_error;
1169 END check_ib_active;
1170
1171 PROCEDURE dump_ctr_grp_rec
1172 (p_counter_groups_rec IN csi_ctr_datastructures_pub.counter_groups_rec) IS
1173
1174 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_grp_rec';
1175 l_api_version CONSTANT NUMBER := 1.0;
1176 BEGIN
1177 SAVEPOINT dump_ctr_grp_rec;
1178
1179 -- Read the debug profiles values in to global variable 7197402
1180 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1181
1182 PUT_LINE (' ');
1183 PUT_LINE ('Dumping the values for Counter Groups Record:');
1184 PUT_LINE (' ');
1185
1186 PUT_LINE ('COUNTER_GROUP_ID :'||p_counter_groups_rec.COUNTER_GROUP_ID);
1187 PUT_LINE ('NAME :'||p_counter_groups_rec.NAME);
1188 PUT_LINE ('DESCRIPTION :'||p_counter_groups_rec.DESCRIPTION);
1189 PUT_LINE ('TEMPLATE_FLAG :'||p_counter_groups_rec.TEMPLATE_FLAG);
1190 -- PUT_LINE ('CP_SERVICE_ID :'||p_counter_groups_rec.CP_SERVICE_ID);
1191 -- PUT_LINE ('CUSTOMER_PRODUCT_ID :'||p_counter_groups_rec.CUSTOMER_PRODUCT_ID);
1192 PUT_LINE ('START_DATE_ACTIVE :'||p_counter_groups_rec.START_DATE_ACTIVE);
1193 PUT_LINE ('END_DATE_ACTIVE :'||p_counter_groups_rec.END_DATE_ACTIVE);
1194 PUT_LINE ('ATTRIBUTE1 :'||p_counter_groups_rec.ATTRIBUTE1);
1195 PUT_LINE ('ATTRIBUTE2 :'||p_counter_groups_rec.ATTRIBUTE2);
1196 PUT_LINE ('ATTRIBUTE3 :'||p_counter_groups_rec.ATTRIBUTE3);
1197 PUT_LINE ('ATTRIBUTE4 :'||p_counter_groups_rec.ATTRIBUTE4);
1198 PUT_LINE ('ATTRIBUTE5 :'||p_counter_groups_rec.ATTRIBUTE5);
1199 PUT_LINE ('ATTRIBUTE6 :'||p_counter_groups_rec.ATTRIBUTE6);
1200 PUT_LINE ('ATTRIBUTE7 :'||p_counter_groups_rec.ATTRIBUTE7);
1201 PUT_LINE ('ATTRIBUTE8 :'||p_counter_groups_rec.ATTRIBUTE8);
1202 PUT_LINE ('ATTRIBUTE9 :'||p_counter_groups_rec.ATTRIBUTE9);
1203 PUT_LINE ('ATTRIBUTE10 :'||p_counter_groups_rec.ATTRIBUTE10);
1204 PUT_LINE ('ATTRIBUTE11 :'||p_counter_groups_rec.ATTRIBUTE11);
1205 PUT_LINE ('ATTRIBUTE12 :'||p_counter_groups_rec.ATTRIBUTE12);
1206 PUT_LINE ('ATTRIBUTE13 :'||p_counter_groups_rec.ATTRIBUTE13);
1207 PUT_LINE ('ATTRIBUTE14 :'||p_counter_groups_rec.ATTRIBUTE14);
1208 PUT_LINE ('ATTRIBUTE15 :'||p_counter_groups_rec.ATTRIBUTE15);
1209 PUT_LINE ('CONTEXT :'||p_counter_groups_rec.CONTEXT);
1210 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_groups_rec.OBJECT_VERSION_NUMBER);
1211 PUT_LINE ('CREATED_FROM_CTR_GRP_TMPL_ID :'||p_counter_groups_rec.CREATED_FROM_CTR_GRP_TMPL_ID);
1212 PUT_LINE ('ASSOCIATION_TYPE :'||p_counter_groups_rec.ASSOCIATION_TYPE);
1213 PUT_LINE ('SOURCE_OBJECT_CODE :'||p_counter_groups_rec.SOURCE_OBJECT_CODE);
1214 PUT_LINE ('SOURCE_OBJECT_ID :'||p_counter_groups_rec.SOURCE_OBJECT_ID);
1215 PUT_LINE ('SOURCE_COUNTER_GROUP_ID :'||p_counter_groups_rec.SOURCE_COUNTER_GROUP_ID);
1216 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_groups_rec.SECURITY_GROUP_ID);
1217 EXCEPTION
1218 WHEN OTHERS THEN
1219 ROLLBACK TO dump_ctr_grp_rec;
1220 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1221 THEN
1222 FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);
1223 END IF;
1224 END dump_ctr_grp_rec;
1225
1226 PROCEDURE dump_ctr_grp_tbl
1227 (p_counter_groups_tbl IN csi_ctr_datastructures_pub.counter_groups_tbl) IS
1228
1229 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_grp_tbl';
1230 l_api_version CONSTANT NUMBER := 1.0;
1231 BEGIN
1232 SAVEPOINT dump_ctr_grp_tbl;
1233
1234 -- Read the debug profiles values in to global variable 7197402
1235 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1236
1237 IF p_counter_groups_tbl.COUNT > 0 THEN
1238 FOR tab_row IN p_counter_groups_tbl.FIRST .. p_counter_groups_tbl.LAST
1239 LOOP
1240 IF p_counter_groups_tbl.EXISTS(tab_row) THEN
1241
1242 PUT_LINE (' ');
1243 PUT_LINE ('Dumping the values for Counter Groups Table Record # : '||tab_row);
1244 PUT_LINE (' ');
1245
1246 PUT_LINE ('COUNTER_GROUP_ID :'||p_counter_groups_tbl(tab_row).COUNTER_GROUP_ID);
1247 PUT_LINE ('NAME :'||p_counter_groups_tbl(tab_row).NAME);
1248 PUT_LINE ('DESCRIPTION :'||p_counter_groups_tbl(tab_row).DESCRIPTION);
1249 PUT_LINE ('TEMPLATE_FLAG :'||p_counter_groups_tbl(tab_row).TEMPLATE_FLAG);
1250 -- PUT_LINE ('CP_SERVICE_ID :'||p_counter_groups_tbl(tab_row).CP_SERVICE_ID);
1251 -- PUT_LINE ('CUSTOMER_PRODUCT_ID :'||p_counter_groups_tbl(tab_row).CUSTOMER_PRODUCT_ID);
1252 PUT_LINE ('START_DATE_ACTIVE :'||p_counter_groups_tbl(tab_row).START_DATE_ACTIVE);
1253 PUT_LINE ('END_DATE_ACTIVE :'||p_counter_groups_tbl(tab_row).END_DATE_ACTIVE);
1254 PUT_LINE ('ATTRIBUTE1 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE1);
1255 PUT_LINE ('ATTRIBUTE2 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE2);
1256 PUT_LINE ('ATTRIBUTE3 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE3);
1257 PUT_LINE ('ATTRIBUTE4 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE4);
1258 PUT_LINE ('ATTRIBUTE5 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE5);
1259 PUT_LINE ('ATTRIBUTE6 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE6);
1260 PUT_LINE ('ATTRIBUTE7 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE7);
1261 PUT_LINE ('ATTRIBUTE8 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE8);
1262 PUT_LINE ('ATTRIBUTE9 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE9);
1263 PUT_LINE ('ATTRIBUTE10 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE10);
1264 PUT_LINE ('ATTRIBUTE11 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE11);
1265 PUT_LINE ('ATTRIBUTE12 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE12);
1266 PUT_LINE ('ATTRIBUTE13 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE13);
1267 PUT_LINE ('ATTRIBUTE14 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE14);
1268 PUT_LINE ('ATTRIBUTE15 :'||p_counter_groups_tbl(tab_row).ATTRIBUTE15);
1269 PUT_LINE ('CONTEXT :'||p_counter_groups_tbl(tab_row).CONTEXT);
1270 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_groups_tbl(tab_row).OBJECT_VERSION_NUMBER);
1271 PUT_LINE ('CREATED_FROM_CTR_GRP_TMPL_ID :'||p_counter_groups_tbl(tab_row).CREATED_FROM_CTR_GRP_TMPL_ID);
1272 PUT_LINE ('ASSOCIATION_TYPE :'||p_counter_groups_tbl(tab_row).ASSOCIATION_TYPE);
1273 PUT_LINE ('SOURCE_OBJECT_CODE :'||p_counter_groups_tbl(tab_row).SOURCE_OBJECT_CODE);
1274 PUT_LINE ('SOURCE_OBJECT_ID :'||p_counter_groups_tbl(tab_row).SOURCE_OBJECT_ID);
1275 PUT_LINE ('SOURCE_COUNTER_GROUP_ID :'||p_counter_groups_tbl(tab_row).SOURCE_COUNTER_GROUP_ID);
1276 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_groups_tbl(tab_row).SECURITY_GROUP_ID);
1277 END IF;
1278 END LOOP;
1279 END IF;
1280 EXCEPTION
1281 WHEN OTHERS THEN
1282 ROLLBACK TO dump_ctr_grp_tbl;
1283 IF FND_MSG_PUB.Check_Msg_Level
1284 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1285 THEN
1286 FND_MSG_PUB.Add_Exc_Msg
1287 (g_pkg_name,
1288 l_api_name);
1289 END IF;
1290 END dump_ctr_grp_tbl;
1291
1292 PROCEDURE dump_ctr_template_rec
1293 (p_counter_template_rec IN csi_ctr_datastructures_pub.counter_template_rec) IS
1294
1295
1296 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_template_rec';
1297 l_api_version CONSTANT NUMBER := 1.0;
1298 BEGIN
1299 SAVEPOINT dump_ctr_template_rec;
1300
1301 -- Read the debug profiles values in to global variable 7197402
1302 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1303
1304 PUT_LINE (' ');
1305 PUT_LINE ('Dumping the values for Counter Template Record:');
1306 PUT_LINE (' ');
1307
1308 PUT_LINE ('COUNTER_ID :'||p_counter_template_rec.COUNTER_ID);
1309 PUT_LINE ('GROUP_ID :'||p_counter_template_rec.GROUP_ID);
1310 PUT_LINE ('DESCRIPTION :'||p_counter_template_rec.DESCRIPTION);
1311 PUT_LINE ('COUNTER_TYPE :'||p_counter_template_rec.COUNTER_TYPE);
1312 PUT_LINE ('INITIAL_READING :'||p_counter_template_rec.INITIAL_READING);
1313 PUT_LINE ('INITIAL_READING_DATE :'||p_counter_template_rec.INITIAL_READING_DATE);
1314 PUT_LINE ('TOLERANCE_PLUS :'||p_counter_template_rec.TOLERANCE_PLUS);
1315 PUT_LINE ('TOLERANCE_MINUS :'||p_counter_template_rec.TOLERANCE_MINUS);
1316 PUT_LINE ('UOM_CODE :'||p_counter_template_rec.UOM_CODE);
1317 PUT_LINE ('DERIVE_COUNTER_ID :'||p_counter_template_rec.DERIVE_COUNTER_ID);
1318 PUT_LINE ('DERIVE_FUNCTION :'||p_counter_template_rec.DERIVE_FUNCTION);
1319 PUT_LINE ('DERIVE_PROPERTY_ID :'||p_counter_template_rec.DERIVE_PROPERTY_ID);
1320 PUT_LINE ('VALID_FLAG :'||p_counter_template_rec.VALID_FLAG);
1321 PUT_LINE ('FORMULA_INCOMPLETE_FLAG :'||p_counter_template_rec.FORMULA_INCOMPLETE_FLAG);
1322 PUT_LINE ('FORMULA_TEXT :'||p_counter_template_rec.FORMULA_TEXT);
1323 PUT_LINE ('ROLLOVER_LAST_READING :'||p_counter_template_rec.ROLLOVER_LAST_READING);
1324 PUT_LINE ('ROLLOVER_FIRST_READING :'||p_counter_template_rec.ROLLOVER_FIRST_READING);
1325 PUT_LINE ('USAGE_ITEM_ID :'||p_counter_template_rec.USAGE_ITEM_ID);
1326 PUT_LINE ('CTR_VAL_MAX_SEQ_NO :'||p_counter_template_rec.CTR_VAL_MAX_SEQ_NO);
1327 PUT_LINE ('START_DATE_ACTIVE :'||p_counter_template_rec.START_DATE_ACTIVE);
1328 PUT_LINE ('END_DATE_ACTIVE :'||p_counter_template_rec.END_DATE_ACTIVE);
1329 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_template_rec.OBJECT_VERSION_NUMBER);
1330 PUT_LINE ('ATTRIBUTE1 :'||p_counter_template_rec.ATTRIBUTE1);
1331 PUT_LINE ('ATTRIBUTE2 :'||p_counter_template_rec.ATTRIBUTE2);
1332 PUT_LINE ('ATTRIBUTE3 :'||p_counter_template_rec.ATTRIBUTE3);
1333 PUT_LINE ('ATTRIBUTE4 :'||p_counter_template_rec.ATTRIBUTE4);
1334 PUT_LINE ('ATTRIBUTE5 :'||p_counter_template_rec.ATTRIBUTE5);
1335 PUT_LINE ('ATTRIBUTE6 :'||p_counter_template_rec.ATTRIBUTE6);
1336 PUT_LINE ('ATTRIBUTE7 :'||p_counter_template_rec.ATTRIBUTE7);
1337 PUT_LINE ('ATTRIBUTE8 :'||p_counter_template_rec.ATTRIBUTE8);
1338 PUT_LINE ('ATTRIBUTE9 :'||p_counter_template_rec.ATTRIBUTE9);
1339 PUT_LINE ('ATTRIBUTE10 :'||p_counter_template_rec.ATTRIBUTE10);
1340 PUT_LINE ('ATTRIBUTE11 :'||p_counter_template_rec.ATTRIBUTE11);
1341 PUT_LINE ('ATTRIBUTE12 :'||p_counter_template_rec.ATTRIBUTE12);
1342 PUT_LINE ('ATTRIBUTE13 :'||p_counter_template_rec.ATTRIBUTE13);
1343 PUT_LINE ('ATTRIBUTE14 :'||p_counter_template_rec.ATTRIBUTE14);
1344 PUT_LINE ('ATTRIBUTE15 :'||p_counter_template_rec.ATTRIBUTE15);
1345 PUT_LINE ('ATTRIBUTE16 :'||p_counter_template_rec.ATTRIBUTE16);
1346 PUT_LINE ('ATTRIBUTE17 :'||p_counter_template_rec.ATTRIBUTE17);
1347 PUT_LINE ('ATTRIBUTE18 :'||p_counter_template_rec.ATTRIBUTE18);
1348 PUT_LINE ('ATTRIBUTE19 :'||p_counter_template_rec.ATTRIBUTE19);
1349 PUT_LINE ('ATTRIBUTE20 :'||p_counter_template_rec.ATTRIBUTE20);
1350 PUT_LINE ('ATTRIBUTE21 :'||p_counter_template_rec.ATTRIBUTE21);
1351 PUT_LINE ('ATTRIBUTE22 :'||p_counter_template_rec.ATTRIBUTE22);
1352 PUT_LINE ('ATTRIBUTE23 :'||p_counter_template_rec.ATTRIBUTE23);
1353 PUT_LINE ('ATTRIBUTE24 :'||p_counter_template_rec.ATTRIBUTE24);
1354 PUT_LINE ('ATTRIBUTE25 :'||p_counter_template_rec.ATTRIBUTE25);
1355 PUT_LINE ('ATTRIBUTE26 :'||p_counter_template_rec.ATTRIBUTE26);
1356 PUT_LINE ('ATTRIBUTE27 :'||p_counter_template_rec.ATTRIBUTE27);
1357 PUT_LINE ('ATTRIBUTE28 :'||p_counter_template_rec.ATTRIBUTE28);
1358 PUT_LINE ('ATTRIBUTE29 :'||p_counter_template_rec.ATTRIBUTE29);
1359 PUT_LINE ('ATTRIBUTE30 :'||p_counter_template_rec.ATTRIBUTE30);
1360 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_template_rec.ATTRIBUTE_CATEGORY);
1361 PUT_LINE ('DIRECTION :'||p_counter_template_rec.DIRECTION);
1362 PUT_LINE ('FILTER_TYPE :'||p_counter_template_rec.FILTER_TYPE);
1363 PUT_LINE ('FILTER_READING_COUNT :'||p_counter_template_rec.FILTER_READING_COUNT);
1364 PUT_LINE ('FILTER_TIME_UOM :'||p_counter_template_rec.FILTER_TIME_UOM);
1365 PUT_LINE ('ESTIMATION_ID :'||p_counter_template_rec.ESTIMATION_ID);
1366 PUT_LINE ('READING_TYPE :'||p_counter_template_rec.READING_TYPE);
1367 PUT_LINE ('AUTOMATIC_ROLLOVER :'||p_counter_template_rec.AUTOMATIC_ROLLOVER);
1368 PUT_LINE ('DEFAULT_USAGE_RATE :'||p_counter_template_rec.DEFAULT_USAGE_RATE);
1369 PUT_LINE ('USE_PAST_READING :'||p_counter_template_rec.USE_PAST_READING);
1370 PUT_LINE ('USED_IN_SCHEDULING :'||p_counter_template_rec.USED_IN_SCHEDULING);
1371 PUT_LINE ('DEFAULTED_GROUP_ID :'||p_counter_template_rec.DEFAULTED_GROUP_ID);
1372 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_template_rec.SECURITY_GROUP_ID);
1373 PUT_LINE ('NAME :'||p_counter_template_rec.NAME);
1374 PUT_LINE ('DESCRIPTION :'||p_counter_template_rec.DESCRIPTION);
1375 PUT_LINE ('COMMENTS :'||p_counter_template_rec.COMMENTS);
1376 PUT_LINE ('ASSOCIATION_TYPE :'||p_counter_template_rec.ASSOCIATION_TYPE);
1377 PUT_LINE ('STEP_VALUE :'||p_counter_template_rec.STEP_VALUE);
1378 PUT_LINE ('TIME_BASED_MANUAL_ENTRY :'||p_counter_template_rec.TIME_BASED_MANUAL_ENTRY);
1379 PUT_LINE ('EAM_REQUIRED_FLAG :'||p_counter_template_rec.EAM_REQUIRED_FLAG);
1380 EXCEPTION
1381 WHEN OTHERS THEN
1382 ROLLBACK TO dump_ctr_template_rec;
1383 IF FND_MSG_PUB.Check_Msg_Level
1384 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1385 THEN
1386 FND_MSG_PUB.Add_Exc_Msg
1387 (g_pkg_name,
1388 l_api_name);
1389 END IF;
1390 END dump_ctr_template_rec;
1391
1392 PROCEDURE dump_ctr_template_tbl
1393 (p_counter_template_tbl IN csi_ctr_datastructures_pub.counter_template_tbl) IS
1394
1395 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_template_tbl';
1396 l_api_version CONSTANT NUMBER := 1.0;
1397
1398 BEGIN
1399 SAVEPOINT dump_ctr_template_tbl;
1400
1401 -- Read the debug profiles values in to global variable 7197402
1402 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1403
1404 IF p_counter_template_tbl.COUNT > 0 THEN
1405 FOR tab_row IN p_counter_template_tbl.FIRST .. p_counter_template_tbl.LAST
1406 LOOP
1407 IF p_counter_template_tbl.EXISTS(tab_row) THEN
1408
1409 PUT_LINE (' ');
1410 PUT_LINE ('Dumping the values for Counter Template Table Record # : '||tab_row);
1411 PUT_LINE (' ');
1412 PUT_LINE ('COUNTER_ID :'||p_counter_template_tbl(tab_row).COUNTER_ID);
1413 PUT_LINE ('GROUP_ID :'||p_counter_template_tbl(tab_row).GROUP_ID);
1414 PUT_LINE ('DESCRIPTION :'||p_counter_template_tbl(tab_row).DESCRIPTION);
1415 PUT_LINE ('COUNTER_TYPE :'||p_counter_template_tbl(tab_row).COUNTER_TYPE);
1416 PUT_LINE ('INITIAL_READING :'||p_counter_template_tbl(tab_row).INITIAL_READING);
1417 PUT_LINE ('INITIAL_READING_DATE :'||p_counter_template_tbl(tab_row).INITIAL_READING_DATE);
1418 PUT_LINE ('TOLERANCE_PLUS :'||p_counter_template_tbl(tab_row).TOLERANCE_PLUS);
1419 PUT_LINE ('TOLERANCE_MINUS :'||p_counter_template_tbl(tab_row).TOLERANCE_MINUS);
1420 PUT_LINE ('UOM_CODE :'||p_counter_template_tbl(tab_row).UOM_CODE);
1421 PUT_LINE ('DERIVE_COUNTER_ID :'||p_counter_template_tbl(tab_row).DERIVE_COUNTER_ID);
1422 PUT_LINE ('DERIVE_FUNCTION :'||p_counter_template_tbl(tab_row).DERIVE_FUNCTION);
1423 PUT_LINE ('DERIVE_PROPERTY_ID :'||p_counter_template_tbl(tab_row).DERIVE_PROPERTY_ID);
1424 PUT_LINE ('VALID_FLAG :'||p_counter_template_tbl(tab_row).VALID_FLAG);
1425 PUT_LINE ('FORMULA_INCOMPLETE_FLAG :'||p_counter_template_tbl(tab_row).FORMULA_INCOMPLETE_FLAG);
1426 PUT_LINE ('FORMULA_TEXT :'||p_counter_template_tbl(tab_row).FORMULA_TEXT);
1427 PUT_LINE ('ROLLOVER_LAST_READING :'||p_counter_template_tbl(tab_row).ROLLOVER_LAST_READING);
1428 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);
1429 PUT_LINE ('CTR_VAL_MAX_SEQ_NO :'||p_counter_template_tbl(tab_row).CTR_VAL_MAX_SEQ_NO);
1430 PUT_LINE ('START_DATE_ACTIVE :'||p_counter_template_tbl(tab_row).START_DATE_ACTIVE);
1431 PUT_LINE ('END_DATE_ACTIVE :'||p_counter_template_tbl(tab_row).END_DATE_ACTIVE);
1432 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_template_tbl(tab_row).OBJECT_VERSION_NUMBER);
1433 PUT_LINE ('ATTRIBUTE1 :'||p_counter_template_tbl(tab_row).ATTRIBUTE1);
1434 PUT_LINE ('ATTRIBUTE2 :'||p_counter_template_tbl(tab_row).ATTRIBUTE2);
1435 PUT_LINE ('ATTRIBUTE3 :'||p_counter_template_tbl(tab_row).ATTRIBUTE3);
1436 PUT_LINE ('ATTRIBUTE4 :'||p_counter_template_tbl(tab_row).ATTRIBUTE4);
1437 PUT_LINE ('ATTRIBUTE5 :'||p_counter_template_tbl(tab_row).ATTRIBUTE5);
1438 PUT_LINE ('ATTRIBUTE6 :'||p_counter_template_tbl(tab_row).ATTRIBUTE6);
1439 PUT_LINE ('ATTRIBUTE7 :'||p_counter_template_tbl(tab_row).ATTRIBUTE7);
1440 PUT_LINE ('ATTRIBUTE8 :'||p_counter_template_tbl(tab_row).ATTRIBUTE8);
1441 PUT_LINE ('ATTRIBUTE9 :'||p_counter_template_tbl(tab_row).ATTRIBUTE9);
1442 PUT_LINE ('ATTRIBUTE10 :'||p_counter_template_tbl(tab_row).ATTRIBUTE10);
1443 PUT_LINE ('ATTRIBUTE11 :'||p_counter_template_tbl(tab_row).ATTRIBUTE11);
1444 PUT_LINE ('ATTRIBUTE12 :'||p_counter_template_tbl(tab_row).ATTRIBUTE12);
1445 PUT_LINE ('ATTRIBUTE13 :'||p_counter_template_tbl(tab_row).ATTRIBUTE13);
1446 PUT_LINE ('ATTRIBUTE14 :'||p_counter_template_tbl(tab_row).ATTRIBUTE14);
1447 PUT_LINE ('ATTRIBUTE15 :'||p_counter_template_tbl(tab_row).ATTRIBUTE15);
1448 PUT_LINE ('ATTRIBUTE16 :'||p_counter_template_tbl(tab_row).ATTRIBUTE16);
1449 PUT_LINE ('ATTRIBUTE17 :'||p_counter_template_tbl(tab_row).ATTRIBUTE17);
1450 PUT_LINE ('ATTRIBUTE18 :'||p_counter_template_tbl(tab_row).ATTRIBUTE18);
1451 PUT_LINE ('ATTRIBUTE19 :'||p_counter_template_tbl(tab_row).ATTRIBUTE19);
1452 PUT_LINE ('ATTRIBUTE20 :'||p_counter_template_tbl(tab_row).ATTRIBUTE20);
1453 PUT_LINE ('ATTRIBUTE21 :'||p_counter_template_tbl(tab_row).ATTRIBUTE21);
1454 PUT_LINE ('ATTRIBUTE22 :'||p_counter_template_tbl(tab_row).ATTRIBUTE22);
1455 PUT_LINE ('ATTRIBUTE23 :'||p_counter_template_tbl(tab_row).ATTRIBUTE23);
1456 PUT_LINE ('ATTRIBUTE24 :'||p_counter_template_tbl(tab_row).ATTRIBUTE24);
1457 PUT_LINE ('ATTRIBUTE25 :'||p_counter_template_tbl(tab_row).ATTRIBUTE25);
1458 PUT_LINE ('ATTRIBUTE26 :'||p_counter_template_tbl(tab_row).ATTRIBUTE26);
1459 PUT_LINE ('ATTRIBUTE27 :'||p_counter_template_tbl(tab_row).ATTRIBUTE27);
1460 PUT_LINE ('ATTRIBUTE28 :'||p_counter_template_tbl(tab_row).ATTRIBUTE28);
1461 PUT_LINE ('ATTRIBUTE29 :'||p_counter_template_tbl(tab_row).ATTRIBUTE29);
1462 PUT_LINE ('ATTRIBUTE30 :'||p_counter_template_tbl(tab_row).ATTRIBUTE30);
1463 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_template_tbl(tab_row).ATTRIBUTE_CATEGORY);
1464 PUT_LINE ('DIRECTION :'||p_counter_template_tbl(tab_row).DIRECTION);
1465 PUT_LINE ('FILTER_TYPE :'||p_counter_template_tbl(tab_row).FILTER_TYPE);
1466 PUT_LINE ('FILTER_READING_COUNT :'||p_counter_template_tbl(tab_row).FILTER_READING_COUNT);
1467 PUT_LINE ('FILTER_TIME_UOM :'||p_counter_template_tbl(tab_row).FILTER_TIME_UOM);
1468 PUT_LINE ('ESTIMATION_ID :'||p_counter_template_tbl(tab_row).ESTIMATION_ID);
1469 PUT_LINE ('READING_TYPE :'||p_counter_template_tbl(tab_row).READING_TYPE);
1470 PUT_LINE ('AUTOMATIC_ROLLOVER :'||p_counter_template_tbl(tab_row).AUTOMATIC_ROLLOVER);
1471 PUT_LINE ('DEFAULT_USAGE_RATE :'||p_counter_template_tbl(tab_row).DEFAULT_USAGE_RATE);
1472 PUT_LINE ('USE_PAST_READING :'||p_counter_template_tbl(tab_row).USE_PAST_READING);
1473 PUT_LINE ('USED_IN_SCHEDULING :'||p_counter_template_tbl(tab_row).USED_IN_SCHEDULING);
1474 PUT_LINE ('DEFAULTED_GROUP_ID :'||p_counter_template_tbl(tab_row).DEFAULTED_GROUP_ID);
1475 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_template_tbl(tab_row).SECURITY_GROUP_ID);
1476 PUT_LINE ('NAME :'||p_counter_template_tbl(tab_row).NAME);
1477 PUT_LINE ('DESCRIPTION :'||p_counter_template_tbl(tab_row).DESCRIPTION);
1478 PUT_LINE ('COMMENTS :'||p_counter_template_tbl(tab_row).COMMENTS);
1479 PUT_LINE ('ASSOCIATION_TYPE :'||p_counter_template_tbl(tab_row).ASSOCIATION_TYPE);
1480 PUT_LINE ('STEP_VALUE :'||p_counter_template_tbl(tab_row).STEP_VALUE);
1481 PUT_LINE ('TIME_BASED_MANUAL_ENTRY :'||p_counter_template_tbl(tab_row).TIME_BASED_MANUAL_ENTRY);
1482 PUT_LINE ('EAM_REQUIRED_FLAG :'||p_counter_template_tbl(tab_row).EAM_REQUIRED_FLAG);
1483
1484 END IF;
1485 END LOOP;
1486 END IF;
1487 EXCEPTION
1488 WHEN OTHERS THEN
1489 ROLLBACK TO dump_ctr_template_tbl;
1490 IF FND_MSG_PUB.Check_Msg_Level
1491 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1492 THEN
1493 FND_MSG_PUB.Add_Exc_Msg
1494 (g_pkg_name,
1495 l_api_name);
1496 END IF;
1497 END dump_ctr_template_tbl;
1498
1499
1500 PROCEDURE dump_ctr_item_assoc_rec
1501 (p_ctr_item_associations_rec IN csi_ctr_datastructures_pub.ctr_item_associations_rec) IS
1502
1503 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_item_assoc_rec';
1504 l_api_version CONSTANT NUMBER := 1.0;
1505 BEGIN
1506 SAVEPOINT dump_ctr_item_assoc_rec;
1507
1508 -- Read the debug profiles values in to global variable 7197402
1509 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1510
1511 PUT_LINE (' ');
1512 PUT_LINE ('Dumping the values for Counter Item Association Record:');
1513 PUT_LINE (' ');
1514
1515 PUT_LINE ('CTR_ASSOCIATION_ID :'||p_ctr_item_associations_rec.CTR_ASSOCIATION_ID);
1516 PUT_LINE ('GROUP_ID :'||p_ctr_item_associations_rec.GROUP_ID);
1517 PUT_LINE ('INVENTORY_ITEM_ID :'||p_ctr_item_associations_rec.INVENTORY_ITEM_ID);
1518 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_item_associations_rec.OBJECT_VERSION_NUMBER);
1519 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_item_associations_rec.ATTRIBUTE1);
1520 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_item_associations_rec.ATTRIBUTE2);
1521 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_item_associations_rec.ATTRIBUTE3);
1522 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_item_associations_rec.ATTRIBUTE4);
1523 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_item_associations_rec.ATTRIBUTE5);
1524 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_item_associations_rec.ATTRIBUTE6);
1525 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_item_associations_rec.ATTRIBUTE7);
1526 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_item_associations_rec.ATTRIBUTE8);
1527 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_item_associations_rec.ATTRIBUTE9);
1528 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_item_associations_rec.ATTRIBUTE10);
1529 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_item_associations_rec.ATTRIBUTE11);
1530 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_item_associations_rec.ATTRIBUTE12);
1531 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_item_associations_rec.ATTRIBUTE13);
1532 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_item_associations_rec.ATTRIBUTE14);
1533 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_item_associations_rec.ATTRIBUTE15);
1534 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_item_associations_rec.ATTRIBUTE_CATEGORY);
1535 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_item_associations_rec.SECURITY_GROUP_ID);
1536 PUT_LINE ('COUNTER_ID :'||p_ctr_item_associations_rec.COUNTER_ID);
1537 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_item_associations_rec.START_DATE_ACTIVE);
1538 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_item_associations_rec.END_DATE_ACTIVE);
1539 PUT_LINE ('USAGE_RATE :'||p_ctr_item_associations_rec.USAGE_RATE);
1540 -- PUT_LINE ('ASSOCIATION_TYPE :'||p_ctr_item_associations_rec.ASSOCIATION_TYPE);
1541 PUT_LINE ('USE_PAST_READING :'||p_ctr_item_associations_rec.USE_PAST_READING);
1542 PUT_LINE ('ASSOCIATED_TO_GROUP :'||p_ctr_item_associations_rec.ASSOCIATED_TO_GROUP);
1543 PUT_LINE ('MAINT_ORGANIZATION_ID :'||p_ctr_item_associations_rec.MAINT_ORGANIZATION_ID);
1544 PUT_LINE ('PRIMARY_FAILURE_FLAG :'||p_ctr_item_associations_rec.PRIMARY_FAILURE_FLAG);
1545
1546 EXCEPTION
1547 WHEN OTHERS THEN
1548 ROLLBACK TO dump_ctr_item_assoc_rec;
1549 IF FND_MSG_PUB.Check_Msg_Level
1550 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1551 THEN
1552 FND_MSG_PUB.Add_Exc_Msg
1553 (g_pkg_name,
1554 l_api_name);
1555 END IF;
1556 END dump_ctr_item_assoc_rec;
1557
1558 PROCEDURE dump_ctr_item_assoc_tbl
1559 (p_ctr_item_associations_tbl IN csi_ctr_datastructures_pub.ctr_item_associations_tbl) IS
1560
1561
1562 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_item_assoc_tbl';
1563 l_api_version CONSTANT NUMBER := 1.0;
1564 BEGIN
1565 SAVEPOINT dump_ctr_item_assoc_tbl;
1566
1567 -- Read the debug profiles values in to global variable 7197402
1568 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1569
1570 IF p_ctr_item_associations_tbl.COUNT > 0 THEN
1571 FOR tab_row IN p_ctr_item_associations_tbl.FIRST .. p_ctr_item_associations_tbl.LAST
1572 LOOP
1573 IF p_ctr_item_associations_tbl.EXISTS(tab_row) THEN
1574
1575 PUT_LINE (' ');
1576 PUT_LINE ('Dumping the values for Counter Item Association Table Record # : '||tab_row);
1577 PUT_LINE (' ');
1578
1579 PUT_LINE ('CTR_ASSOCIATION_ID :'||p_ctr_item_associations_tbl(tab_row).CTR_ASSOCIATION_ID);
1580 PUT_LINE ('GROUP_ID :'||p_ctr_item_associations_tbl(tab_row).GROUP_ID);
1581 PUT_LINE ('INVENTORY_ITEM_ID :'||p_ctr_item_associations_tbl(tab_row).INVENTORY_ITEM_ID);
1582 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_item_associations_tbl(tab_row).OBJECT_VERSION_NUMBER);
1583 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE1);
1584 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE2);
1585 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE3);
1586 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE4);
1587 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE5);
1588 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE6);
1589 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE7);
1590 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE8);
1591 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE9);
1592 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE10);
1593 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE11);
1594 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE12);
1595 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE13);
1596 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE14);
1597 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE15);
1598 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_item_associations_tbl(tab_row).ATTRIBUTE_CATEGORY);
1599 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_item_associations_tbl(tab_row).SECURITY_GROUP_ID);
1600 PUT_LINE ('COUNTER_ID :'||p_ctr_item_associations_tbl(tab_row).COUNTER_ID);
1601 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_item_associations_tbl(tab_row).START_DATE_ACTIVE);
1602 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_item_associations_tbl(tab_row).END_DATE_ACTIVE);
1603 PUT_LINE ('USAGE_RATE :'||p_ctr_item_associations_tbl(tab_row).USAGE_RATE);
1604 -- PUT_LINE ('ASSOCIATION_TYPE :'||p_ctr_item_associations_tbl(tab_row).ASSOCIATION_TYPE);
1605 PUT_LINE ('USE_PAST_READING :'||p_ctr_item_associations_tbl(tab_row).USE_PAST_READING);
1606 PUT_LINE ('ASSOCIATED_TO_GROUP :'||p_ctr_item_associations_tbl(tab_row).ASSOCIATED_TO_GROUP);
1607 PUT_LINE ('MAINT_ORGANIZATION_ID :'||p_ctr_item_associations_tbl(tab_row).MAINT_ORGANIZATION_ID);
1608 PUT_LINE ('PRIMARY_FAILURE_FLAG :'||p_ctr_item_associations_tbl(tab_row).PRIMARY_FAILURE_FLAG);
1609
1610 END IF;
1611 END LOOP;
1612 END IF;
1613 EXCEPTION
1614 WHEN OTHERS THEN
1615 ROLLBACK TO dump_ctr_item_assoc_tbl;
1616 IF FND_MSG_PUB.Check_Msg_Level
1617 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1618 THEN
1619 FND_MSG_PUB.Add_Exc_Msg
1620 (g_pkg_name,
1621 l_api_name);
1622 END IF;
1623 END dump_ctr_item_assoc_tbl;
1624
1625 PROCEDURE dump_ctr_relationship_rec
1626 (p_counter_relationships_rec IN csi_ctr_datastructures_pub.counter_relationships_rec) IS
1627
1628 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_relationship_rec';
1629 l_api_version CONSTANT NUMBER := 1.0;
1630
1631 BEGIN
1632 SAVEPOINT dump_ctr_relationship_rec;
1633
1634 -- Read the debug profiles values in to global variable 7197402
1635 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1636
1637 PUT_LINE (' ');
1638 PUT_LINE ('Dumping the values for Counter Relationships Record:');
1639 PUT_LINE (' ');
1640
1641 PUT_LINE ('RELATIONSHIP_ID :'||p_counter_relationships_rec.RELATIONSHIP_ID);
1642 PUT_LINE ('CTR_ASSOCIATION_ID :'||p_counter_relationships_rec.CTR_ASSOCIATION_ID);
1643 PUT_LINE ('RELATIONSHIP_TYPE_CODE :'||p_counter_relationships_rec.RELATIONSHIP_TYPE_CODE);
1644 PUT_LINE ('SOURCE_COUNTER_ID :'||p_counter_relationships_rec.SOURCE_COUNTER_ID);
1645 PUT_LINE ('OBJECT_COUNTER_ID :'||p_counter_relationships_rec.OBJECT_COUNTER_ID);
1646 PUT_LINE ('ACTIVE_START_DATE :'||p_counter_relationships_rec.ACTIVE_START_DATE);
1647 PUT_LINE ('ACTIVE_END_DATE :'||p_counter_relationships_rec.ACTIVE_END_DATE);
1648 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_relationships_rec.OBJECT_VERSION_NUMBER);
1649 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_relationships_rec.ATTRIBUTE_CATEGORY);
1650 PUT_LINE ('ATTRIBUTE1 :'||p_counter_relationships_rec.ATTRIBUTE1);
1651 PUT_LINE ('ATTRIBUTE2 :'||p_counter_relationships_rec.ATTRIBUTE2);
1652 PUT_LINE ('ATTRIBUTE3 :'||p_counter_relationships_rec.ATTRIBUTE3);
1653 PUT_LINE ('ATTRIBUTE4 :'||p_counter_relationships_rec.ATTRIBUTE4);
1654 PUT_LINE ('ATTRIBUTE5 :'||p_counter_relationships_rec.ATTRIBUTE5);
1655 PUT_LINE ('ATTRIBUTE6 :'||p_counter_relationships_rec.ATTRIBUTE6);
1656 PUT_LINE ('ATTRIBUTE7 :'||p_counter_relationships_rec.ATTRIBUTE7);
1657 PUT_LINE ('ATTRIBUTE8 :'||p_counter_relationships_rec.ATTRIBUTE8);
1658 PUT_LINE ('ATTRIBUTE9 :'||p_counter_relationships_rec.ATTRIBUTE9);
1659 PUT_LINE ('ATTRIBUTE10 :'||p_counter_relationships_rec.ATTRIBUTE10);
1660 PUT_LINE ('ATTRIBUTE11 :'||p_counter_relationships_rec.ATTRIBUTE11);
1661 PUT_LINE ('ATTRIBUTE12 :'||p_counter_relationships_rec.ATTRIBUTE12);
1662 PUT_LINE ('ATTRIBUTE13 :'||p_counter_relationships_rec.ATTRIBUTE13);
1663 PUT_LINE ('ATTRIBUTE14 :'||p_counter_relationships_rec.ATTRIBUTE14);
1664 PUT_LINE ('ATTRIBUTE15 :'||p_counter_relationships_rec.ATTRIBUTE15);
1665 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_relationships_rec.SECURITY_GROUP_ID);
1666 PUT_LINE ('BIND_VARIABLE_NAME :'||p_counter_relationships_rec.BIND_VARIABLE_NAME);
1667 PUT_LINE ('FACTOR :'||p_counter_relationships_rec.FACTOR);
1668 EXCEPTION
1669 WHEN OTHERS THEN
1670 ROLLBACK TO dump_ctr_relationship_rec;
1671 IF FND_MSG_PUB.Check_Msg_Level
1672 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1673 THEN
1674 FND_MSG_PUB.Add_Exc_Msg
1675 (g_pkg_name,
1676 l_api_name);
1677 END IF;
1678 END dump_ctr_relationship_rec;
1679
1680 PROCEDURE dump_ctr_relationship_tbl
1681 (p_counter_relationships_tbl IN csi_ctr_datastructures_pub.counter_relationships_tbl) IS
1682
1683
1684 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_relationship_tbl';
1685 l_api_version CONSTANT NUMBER := 1.0;
1686
1687 BEGIN
1688 SAVEPOINT dump_ctr_relationship_tbl;
1689
1690 -- Read the debug profiles values in to global variable 7197402
1691 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1692
1693 IF p_counter_relationships_tbl.COUNT > 0 THEN
1694 FOR tab_row IN p_counter_relationships_tbl.FIRST .. p_counter_relationships_tbl.LAST
1695 LOOP
1696 IF p_counter_relationships_tbl.EXISTS(tab_row) THEN
1697
1698 PUT_LINE (' ');
1699 PUT_LINE ('Dumping the values for Counter Relationship Table Record # : '||tab_row);
1700 PUT_LINE (' ');
1701
1702 PUT_LINE ('RELATIONSHIP_ID :'||p_counter_relationships_tbl(tab_row).RELATIONSHIP_ID);
1703 PUT_LINE ('CTR_ASSOCIATION_ID :'||p_counter_relationships_tbl(tab_row).CTR_ASSOCIATION_ID);
1704 PUT_LINE ('RELATIONSHIP_TYPE_CODE :'||p_counter_relationships_tbl(tab_row).RELATIONSHIP_TYPE_CODE);
1705 PUT_LINE ('SOURCE_COUNTER_ID :'||p_counter_relationships_tbl(tab_row).SOURCE_COUNTER_ID);
1706 PUT_LINE ('OBJECT_COUNTER_ID :'||p_counter_relationships_tbl(tab_row).OBJECT_COUNTER_ID);
1707 PUT_LINE ('ACTIVE_START_DATE :'||p_counter_relationships_tbl(tab_row).ACTIVE_START_DATE);
1708 PUT_LINE ('ACTIVE_END_DATE :'||p_counter_relationships_tbl(tab_row).ACTIVE_END_DATE);
1709 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_relationships_tbl(tab_row).OBJECT_VERSION_NUMBER);
1710 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE_CATEGORY);
1711 PUT_LINE ('ATTRIBUTE1 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE1);
1712 PUT_LINE ('ATTRIBUTE2 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE2);
1713 PUT_LINE ('ATTRIBUTE3 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE3);
1714 PUT_LINE ('ATTRIBUTE4 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE4);
1715 PUT_LINE ('ATTRIBUTE5 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE5);
1716 PUT_LINE ('ATTRIBUTE6 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE6);
1717 PUT_LINE ('ATTRIBUTE7 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE7);
1718 PUT_LINE ('ATTRIBUTE8 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE8);
1719 PUT_LINE ('ATTRIBUTE9 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE9);
1720 PUT_LINE ('ATTRIBUTE10 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE10);
1721 PUT_LINE ('ATTRIBUTE11 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE11);
1722 PUT_LINE ('ATTRIBUTE12 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE12);
1723 PUT_LINE ('ATTRIBUTE13 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE13);
1724 PUT_LINE ('ATTRIBUTE14 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE14);
1725 PUT_LINE ('ATTRIBUTE15 :'||p_counter_relationships_tbl(tab_row).ATTRIBUTE15);
1726 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_relationships_tbl(tab_row).SECURITY_GROUP_ID);
1727 PUT_LINE ('BIND_VARIABLE_NAME :'||p_counter_relationships_tbl(tab_row).BIND_VARIABLE_NAME);
1728 PUT_LINE ('FACTOR :'||p_counter_relationships_tbl(tab_row).FACTOR);
1729
1730 END IF;
1731 END LOOP;
1732 END IF;
1733 EXCEPTION
1734 WHEN OTHERS THEN
1735 ROLLBACK TO dump_ctr_relationship_tbl;
1736 IF FND_MSG_PUB.Check_Msg_Level
1737 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1738 THEN
1739 FND_MSG_PUB.Add_Exc_Msg
1740 (g_pkg_name,
1741 l_api_name);
1742 END IF;
1743 END dump_ctr_relationship_tbl;
1744
1745 PROCEDURE dump_ctr_property_template_rec
1746 (p_ctr_property_template_rec IN csi_ctr_datastructures_pub.ctr_property_template_rec) IS
1747 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_property_template_rec';
1748 l_api_version CONSTANT NUMBER := 1.0;
1749
1750 BEGIN
1751 SAVEPOINT dump_ctr_property_template_rec;
1752
1753 -- Read the debug profiles values in to global variable 7197402
1754 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1755
1756 PUT_LINE (' ');
1757 PUT_LINE ('Dumping the values for Counter Property Template Record:');
1758 PUT_LINE (' ');
1759
1760 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_property_template_rec.COUNTER_PROPERTY_ID);
1761 PUT_LINE ('COUNTER_ID :'||p_ctr_property_template_rec.COUNTER_ID);
1762 PUT_LINE ('PROPERTY_DATA_TYPE :'||p_ctr_property_template_rec.PROPERTY_DATA_TYPE);
1763 PUT_LINE ('IS_NULLABLE :'||p_ctr_property_template_rec.IS_NULLABLE);
1764 PUT_LINE ('DEFAULT_VALUE :'||p_ctr_property_template_rec.DEFAULT_VALUE);
1765 PUT_LINE ('MINIMUM_VALUE :'||p_ctr_property_template_rec.MINIMUM_VALUE);
1766 PUT_LINE ('MAXIMUM_VALUE :'||p_ctr_property_template_rec.MAXIMUM_VALUE);
1767 PUT_LINE ('UOM_CODE :'||p_ctr_property_template_rec.UOM_CODE);
1768 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_property_template_rec.START_DATE_ACTIVE);
1769 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_property_template_rec.END_DATE_ACTIVE);
1770 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_property_template_rec.OBJECT_VERSION_NUMBER);
1771 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_property_template_rec.ATTRIBUTE1);
1772 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_property_template_rec.ATTRIBUTE2);
1773 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_property_template_rec.ATTRIBUTE3);
1774 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_property_template_rec.ATTRIBUTE4);
1775 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_property_template_rec.ATTRIBUTE5);
1776 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_property_template_rec.ATTRIBUTE6);
1777 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_property_template_rec.ATTRIBUTE7);
1778 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_property_template_rec.ATTRIBUTE8);
1779 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_property_template_rec.ATTRIBUTE9);
1780 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_property_template_rec.ATTRIBUTE10);
1781 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_property_template_rec.ATTRIBUTE11);
1782 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_property_template_rec.ATTRIBUTE12);
1783 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_property_template_rec.ATTRIBUTE13);
1784 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_property_template_rec.ATTRIBUTE14);
1785 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_property_template_rec.ATTRIBUTE15);
1786 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_property_template_rec.ATTRIBUTE_CATEGORY);
1787 PUT_LINE ('PROPERTY_LOV_TYPE :'||p_ctr_property_template_rec.PROPERTY_LOV_TYPE);
1788 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_property_template_rec.SECURITY_GROUP_ID);
1789 PUT_LINE ('NAME :'||p_ctr_property_template_rec.NAME);
1790 PUT_LINE ('DESCRIPTION :'||p_ctr_property_template_rec.DESCRIPTION);
1791
1792 EXCEPTION
1793 WHEN OTHERS THEN
1794 ROLLBACK TO dump_ctr_property_template_rec;
1795 IF FND_MSG_PUB.Check_Msg_Level
1796 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1797 THEN
1798 FND_MSG_PUB.Add_Exc_Msg
1799 (g_pkg_name,
1800 l_api_name);
1801 END IF;
1802 END dump_ctr_property_template_rec;
1803
1804 PROCEDURE dump_ctr_property_template_tbl
1805 (p_ctr_property_template_tbl IN csi_ctr_datastructures_pub.ctr_property_template_tbl) IS
1806
1807 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_property_template_tbl';
1808 l_api_version CONSTANT NUMBER := 1.0;
1809
1810 BEGIN
1811 SAVEPOINT dump_ctr_property_template_tbl;
1812
1813 -- Read the debug profiles values in to global variable 7197402
1814 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1815
1816 IF p_ctr_property_template_tbl.COUNT > 0 THEN
1817 FOR tab_row IN p_ctr_property_template_tbl.FIRST .. p_ctr_property_template_tbl.LAST
1818 LOOP
1819 IF p_ctr_property_template_tbl.EXISTS(tab_row) THEN
1820
1821 PUT_LINE (' ');
1822 PUT_LINE ('Dumping the values for Counter Property Template Table Record # : '||tab_row);
1823 PUT_LINE (' ');
1824
1825 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_property_template_tbl(tab_row).COUNTER_PROPERTY_ID);
1826 PUT_LINE ('COUNTER_ID :'||p_ctr_property_template_tbl(tab_row).COUNTER_ID);
1827 PUT_LINE ('PROPERTY_DATA_TYPE :'||p_ctr_property_template_tbl(tab_row).PROPERTY_DATA_TYPE);
1828 PUT_LINE ('IS_NULLABLE :'||p_ctr_property_template_tbl(tab_row).IS_NULLABLE);
1829 PUT_LINE ('DEFAULT_VALUE :'||p_ctr_property_template_tbl(tab_row).DEFAULT_VALUE);
1830 PUT_LINE ('MINIMUM_VALUE :'||p_ctr_property_template_tbl(tab_row).MINIMUM_VALUE);
1831 PUT_LINE ('MAXIMUM_VALUE :'||p_ctr_property_template_tbl(tab_row).MAXIMUM_VALUE);
1832 PUT_LINE ('UOM_CODE :'||p_ctr_property_template_tbl(tab_row).UOM_CODE);
1833 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_property_template_tbl(tab_row).START_DATE_ACTIVE);
1834 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_property_template_tbl(tab_row).END_DATE_ACTIVE);
1835 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_property_template_tbl(tab_row).OBJECT_VERSION_NUMBER);
1836 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE1);
1837 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE2);
1838 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE3);
1839 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE4);
1840 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE5);
1841 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE6);
1842 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE7);
1843 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE8);
1844 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE9);
1845 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE10);
1846 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE11);
1847 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE12);
1848 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE13);
1849 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE14);
1850 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE15);
1851 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_property_template_tbl(tab_row).ATTRIBUTE_CATEGORY);
1852 PUT_LINE ('PROPERTY_LOV_TYPE :'||p_ctr_property_template_tbl(tab_row).PROPERTY_LOV_TYPE);
1853 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_property_template_tbl(tab_row).SECURITY_GROUP_ID);
1854 PUT_LINE ('NAME :'||p_ctr_property_template_tbl(tab_row).NAME);
1855 PUT_LINE ('DESCRIPTION :'||p_ctr_property_template_tbl(tab_row).DESCRIPTION);
1856
1857 END IF;
1858 END LOOP;
1859 END IF;
1860 EXCEPTION
1861 WHEN OTHERS THEN
1862 ROLLBACK TO dump_ctr_property_template_tbl;
1863 IF FND_MSG_PUB.Check_Msg_Level
1864 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1865 THEN
1866 FND_MSG_PUB.Add_Exc_Msg
1867 (g_pkg_name,
1868 l_api_name);
1869 END IF;
1870 END dump_ctr_property_template_tbl;
1871
1872 PROCEDURE dm_ctr_estimation_methods_rec
1873 (p_ctr_estimation_methods_rec IN csi_ctr_datastructures_pub.ctr_estimation_methods_rec) IS
1874 l_api_name CONSTANT VARCHAR2(30) := 'dm_ctr_estimation_methods_rec';
1875 l_api_version CONSTANT NUMBER := 1.0;
1876 BEGIN
1877 SAVEPOINT dm_ctr_estimation_methods_rec;
1878
1879 -- Read the debug profiles values in to global variable 7197402
1880 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1881
1882 PUT_LINE (' ');
1883 PUT_LINE ('Dumping the values for Counter Estimation Methods Record:');
1884 PUT_LINE (' ');
1885
1886 PUT_LINE ('ESTIMATION_ID :'||p_ctr_estimation_methods_rec.ESTIMATION_ID);
1887 PUT_LINE ('ESTIMATION_TYPE :'||p_ctr_estimation_methods_rec.ESTIMATION_TYPE);
1888 PUT_LINE ('FIXED_VALUE :'||p_ctr_estimation_methods_rec.FIXED_VALUE);
1889 PUT_LINE ('USAGE_MARKUP :'||p_ctr_estimation_methods_rec.USAGE_MARKUP);
1890 PUT_LINE ('DEFAULT_VALUE :'||p_ctr_estimation_methods_rec.DEFAULT_VALUE);
1891 PUT_LINE ('ESTIMATION_AVG_TYPE :'||p_ctr_estimation_methods_rec.ESTIMATION_AVG_TYPE);
1892 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_estimation_methods_rec.START_DATE_ACTIVE);
1893 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_estimation_methods_rec.END_DATE_ACTIVE);
1894 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_estimation_methods_rec.ATTRIBUTE1);
1895 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_estimation_methods_rec.ATTRIBUTE2);
1896 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_estimation_methods_rec.ATTRIBUTE3);
1897 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_estimation_methods_rec.ATTRIBUTE4);
1898 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_estimation_methods_rec.ATTRIBUTE5);
1899 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_estimation_methods_rec.ATTRIBUTE6);
1900 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_estimation_methods_rec.ATTRIBUTE7);
1901 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_estimation_methods_rec.ATTRIBUTE8);
1902 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_estimation_methods_rec.ATTRIBUTE9);
1903 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_estimation_methods_rec.ATTRIBUTE10);
1904 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_estimation_methods_rec.ATTRIBUTE11);
1905 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_estimation_methods_rec.ATTRIBUTE12);
1906 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_estimation_methods_rec.ATTRIBUTE13);
1907 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_estimation_methods_rec.ATTRIBUTE14);
1908 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_estimation_methods_rec.ATTRIBUTE15);
1909 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_estimation_methods_rec.ATTRIBUTE_CATEGORY);
1910 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_estimation_methods_rec.OBJECT_VERSION_NUMBER);
1911 PUT_LINE ('NAME :'||p_ctr_estimation_methods_rec.NAME);
1912 PUT_LINE ('DESCRIPTION :'||p_ctr_estimation_methods_rec.DESCRIPTION);
1913 EXCEPTION
1914 WHEN OTHERS THEN
1915 ROLLBACK TO dm_ctr_estimation_methods_rec;
1916 IF FND_MSG_PUB.Check_Msg_Level
1917 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1918 THEN
1919 FND_MSG_PUB.Add_Exc_Msg
1920 (g_pkg_name,
1921 l_api_name);
1922 END IF;
1923 END dm_ctr_estimation_methods_rec;
1924
1925 PROCEDURE dm_ctr_estimation_methods_tbl
1926 (p_ctr_estimation_methods_tbl IN csi_ctr_datastructures_pub.ctr_estimation_methods_tbl) IS
1927 l_api_name CONSTANT VARCHAR2(30) := 'dm_ctr_estimation_methods_tbl';
1928 l_api_version CONSTANT NUMBER := 1.0;
1929
1930 BEGIN
1931 SAVEPOINT dm_ctr_estimation_methods_tbl;
1932
1933 -- Read the debug profiles values in to global variable 7197402
1934 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1935
1936 IF p_ctr_estimation_methods_tbl.COUNT > 0 THEN
1937 FOR tab_row IN p_ctr_estimation_methods_tbl.FIRST .. p_ctr_estimation_methods_tbl.LAST
1938 LOOP
1939 IF p_ctr_estimation_methods_tbl.EXISTS(tab_row) THEN
1940
1941 PUT_LINE (' ');
1942 PUT_LINE ('Dumping the values for Counter Estimation Methods Table Record # : '||tab_row);
1943 PUT_LINE (' ');
1944
1945 PUT_LINE ('ESTIMATION_ID :'||p_ctr_estimation_methods_tbl(tab_row).ESTIMATION_ID);
1946 PUT_LINE ('ESTIMATION_TYPE :'||p_ctr_estimation_methods_tbl(tab_row).ESTIMATION_TYPE);
1947 PUT_LINE ('FIXED_VALUE :'||p_ctr_estimation_methods_tbl(tab_row).FIXED_VALUE);
1948 PUT_LINE ('USAGE_MARKUP :'||p_ctr_estimation_methods_tbl(tab_row).USAGE_MARKUP);
1949 PUT_LINE ('DEFAULT_VALUE :'||p_ctr_estimation_methods_tbl(tab_row).DEFAULT_VALUE);
1950 PUT_LINE ('ESTIMATION_AVG_TYPE :'||p_ctr_estimation_methods_tbl(tab_row).ESTIMATION_AVG_TYPE);
1951 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_estimation_methods_tbl(tab_row).START_DATE_ACTIVE);
1952 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_estimation_methods_tbl(tab_row).END_DATE_ACTIVE);
1953 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE1);
1954 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE2);
1955 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE3);
1956 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE4);
1957 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE5);
1958 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE6);
1959 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE7);
1960 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE8);
1961 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE9);
1962 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE10);
1963 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE11);
1964 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE12);
1965 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE13);
1966 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE14);
1967 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE15);
1968 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_estimation_methods_tbl(tab_row).ATTRIBUTE_CATEGORY);
1969 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_estimation_methods_tbl(tab_row).OBJECT_VERSION_NUMBER);
1970 PUT_LINE ('NAME :'||p_ctr_estimation_methods_tbl(tab_row).NAME);
1971 PUT_LINE ('DESCRIPTION :'||p_ctr_estimation_methods_tbl(tab_row).DESCRIPTION);
1972
1973 END IF;
1974 END LOOP;
1975 END IF;
1976 EXCEPTION
1977 WHEN OTHERS THEN
1978 ROLLBACK TO dm_ctr_estimation_methods_tbl;
1979 IF FND_MSG_PUB.Check_Msg_Level
1980 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1981 THEN
1982 FND_MSG_PUB.Add_Exc_Msg
1983 (g_pkg_name,
1984 l_api_name);
1985 END IF;
1986 END dm_ctr_estimation_methods_tbl;
1987
1988 PROCEDURE dump_ctr_derived_filters_rec
1989 (p_ctr_derived_filters_rec IN csi_ctr_datastructures_pub.ctr_derived_filters_rec) IS
1990 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_derived_filters_rec';
1991 l_api_version CONSTANT NUMBER := 1.0;
1992 BEGIN
1993 SAVEPOINT dump_ctr_derived_filters_rec;
1994
1995 -- Read the debug profiles values in to global variable 7197402
1996 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1997
1998 PUT_LINE (' ');
1999 PUT_LINE ('Dumping the values for Counter Derived Filters Record:');
2000 PUT_LINE (' ');
2001
2002 PUT_LINE ('COUNTER_DERIVED_FILTER_ID :'||p_ctr_derived_filters_rec.COUNTER_DERIVED_FILTER_ID);
2003 PUT_LINE ('COUNTER_ID :'||p_ctr_derived_filters_rec.COUNTER_ID);
2004 PUT_LINE ('SEQ_NO :'||p_ctr_derived_filters_rec.SEQ_NO);
2005 PUT_LINE ('LEFT_PARENT :'||p_ctr_derived_filters_rec.LEFT_PARENT);
2006 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_derived_filters_rec.COUNTER_PROPERTY_ID);
2007 PUT_LINE ('RELATIONAL_OPERATOR :'||p_ctr_derived_filters_rec.RELATIONAL_OPERATOR);
2008 PUT_LINE ('RIGHT_VALUE :'||p_ctr_derived_filters_rec.RIGHT_VALUE);
2009 PUT_LINE ('RIGHT_PARENT :'||p_ctr_derived_filters_rec.RIGHT_PARENT);
2010 PUT_LINE ('LOGICAL_OPERATOR :'||p_ctr_derived_filters_rec.LOGICAL_OPERATOR );
2011 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_derived_filters_rec.START_DATE_ACTIVE);
2012 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_derived_filters_rec.END_DATE_ACTIVE);
2013 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_derived_filters_rec.OBJECT_VERSION_NUMBER);
2014 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_derived_filters_rec.ATTRIBUTE1);
2015 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_derived_filters_rec.ATTRIBUTE2);
2016 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_derived_filters_rec.ATTRIBUTE3);
2017 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_derived_filters_rec.ATTRIBUTE4);
2018 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_derived_filters_rec.ATTRIBUTE5);
2019 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_derived_filters_rec.ATTRIBUTE6);
2020 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_derived_filters_rec.ATTRIBUTE7);
2021 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_derived_filters_rec.ATTRIBUTE8);
2022 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_derived_filters_rec.ATTRIBUTE9);
2023 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_derived_filters_rec.ATTRIBUTE10);
2024 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_derived_filters_rec.ATTRIBUTE11);
2025 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_derived_filters_rec.ATTRIBUTE12);
2026 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_derived_filters_rec.ATTRIBUTE13);
2027 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_derived_filters_rec.ATTRIBUTE14);
2028 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_derived_filters_rec.ATTRIBUTE15);
2029 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_derived_filters_rec.ATTRIBUTE_CATEGORY);
2030 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_derived_filters_rec.SECURITY_GROUP_ID);
2031 EXCEPTION
2032 WHEN OTHERS THEN
2033 ROLLBACK TO dump_ctr_derived_filters_rec;
2034 IF FND_MSG_PUB.Check_Msg_Level
2035 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2036 THEN
2037 FND_MSG_PUB.Add_Exc_Msg
2038 (g_pkg_name,
2039 l_api_name);
2040 END IF;
2041 END dump_ctr_derived_filters_rec;
2042
2043 PROCEDURE dump_ctr_derived_filters_tbl
2044 (p_ctr_derived_filters_tbl IN csi_ctr_datastructures_pub.ctr_derived_filters_tbl) IS
2045 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_derived_filters_tbl';
2046 l_api_version CONSTANT NUMBER := 1.0;
2047
2048 BEGIN
2049 SAVEPOINT dump_ctr_derived_filters_tbl;
2050
2051 -- Read the debug profiles values in to global variable 7197402
2052 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2053
2054 IF p_ctr_derived_filters_tbl.COUNT > 0 THEN
2055 FOR tab_row IN p_ctr_derived_filters_tbl.FIRST .. p_ctr_derived_filters_tbl.LAST
2056 LOOP
2057 IF p_ctr_derived_filters_tbl.EXISTS(tab_row) THEN
2058
2059 PUT_LINE (' ');
2060 PUT_LINE ('Dumping the values for Counter Derived Filters Table Record # : '||tab_row);
2061 PUT_LINE (' ');
2062
2063 PUT_LINE ('COUNTER_DERIVED_FILTER_ID :'||p_ctr_derived_filters_tbl(tab_row).COUNTER_DERIVED_FILTER_ID);
2064 PUT_LINE ('COUNTER_ID :'||p_ctr_derived_filters_tbl(tab_row).COUNTER_ID);
2065 PUT_LINE ('SEQ_NO :'||p_ctr_derived_filters_tbl(tab_row).SEQ_NO);
2066 PUT_LINE ('LEFT_PARENT :'||p_ctr_derived_filters_tbl(tab_row).LEFT_PARENT);
2067 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_derived_filters_tbl(tab_row).COUNTER_PROPERTY_ID);
2068 PUT_LINE ('RELATIONAL_OPERATOR :'||p_ctr_derived_filters_tbl(tab_row).RELATIONAL_OPERATOR);
2069 PUT_LINE ('RIGHT_VALUE :'||p_ctr_derived_filters_tbl(tab_row).RIGHT_VALUE);
2070 PUT_LINE ('RIGHT_PARENT :'||p_ctr_derived_filters_tbl(tab_row).RIGHT_PARENT);
2071 PUT_LINE ('LOGICAL_OPERATOR :'||p_ctr_derived_filters_tbl(tab_row).LOGICAL_OPERATOR );
2072 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_derived_filters_tbl(tab_row).START_DATE_ACTIVE);
2073 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_derived_filters_tbl(tab_row).END_DATE_ACTIVE);
2074 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_derived_filters_tbl(tab_row).OBJECT_VERSION_NUMBER);
2075 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE1);
2076 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE2);
2077 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE3);
2078 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE4);
2079 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE5);
2080 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE6);
2081 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE7);
2082 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE8);
2083 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE9);
2084 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE10);
2085 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE11);
2086 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE12);
2087 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE13);
2088 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE14);
2089 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE15);
2090 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE_CATEGORY);
2091 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_derived_filters_tbl(tab_row).SECURITY_GROUP_ID);
2092
2093 END IF;
2094 END LOOP;
2095 END IF;
2096 EXCEPTION
2097 WHEN OTHERS THEN
2098 ROLLBACK TO dump_ctr_derived_filters_tbl;
2099 IF FND_MSG_PUB.Check_Msg_Level
2100 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2101 THEN
2102 FND_MSG_PUB.Add_Exc_Msg
2103 (g_pkg_name,
2104 l_api_name);
2105 END IF;
2106 END dump_ctr_derived_filters_tbl;
2107
2108 PROCEDURE dump_counter_instance_rec
2109 (p_counter_instance_rec IN csi_ctr_datastructures_pub.counter_instance_rec) IS
2110 l_api_name CONSTANT VARCHAR2(30) := 'dump_counter_instance_rec';
2111 l_api_version CONSTANT NUMBER := 1.0;
2112 BEGIN
2113 SAVEPOINT dump_counter_instance_rec;
2114
2115 -- Read the debug profiles values in to global variable 7197402
2116 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2117
2118 PUT_LINE (' ');
2119 PUT_LINE ('Dumping the values for Counter Instance Record:');
2120 PUT_LINE (' ');
2121
2122 PUT_LINE ('COUNTER_ID :'||p_counter_instance_rec.COUNTER_ID);
2123 PUT_LINE ('GROUP_ID :'||p_counter_instance_rec.GROUP_ID);
2124 PUT_LINE ('DESCRIPTION :'||p_counter_instance_rec.DESCRIPTION);
2125 PUT_LINE ('COUNTER_TYPE :'||p_counter_instance_rec.COUNTER_TYPE);
2126 PUT_LINE ('INITIAL_READING :'||p_counter_instance_rec.INITIAL_READING);
2127 PUT_LINE ('INITIAL_READING_DATE :'||p_counter_instance_rec.INITIAL_READING_DATE);
2128 PUT_LINE ('TOLERANCE_PLUS :'||p_counter_instance_rec.TOLERANCE_PLUS);
2129 PUT_LINE ('TOLERANCE_MINUS :'||p_counter_instance_rec.TOLERANCE_MINUS);
2130 PUT_LINE ('UOM_CODE :'||p_counter_instance_rec.UOM_CODE);
2131 PUT_LINE ('DERIVE_COUNTER_ID :'||p_counter_instance_rec.DERIVE_COUNTER_ID);
2132 PUT_LINE ('DERIVE_FUNCTION :'||p_counter_instance_rec.DERIVE_FUNCTION);
2133 PUT_LINE ('DERIVE_PROPERTY_ID :'||p_counter_instance_rec.DERIVE_PROPERTY_ID);
2134 PUT_LINE ('VALID_FLAG :'||p_counter_instance_rec.VALID_FLAG);
2135 PUT_LINE ('FORMULA_INCOMPLETE_FLAG :'||p_counter_instance_rec.FORMULA_INCOMPLETE_FLAG);
2136 PUT_LINE ('FORMULA_TEXT :'||p_counter_instance_rec.FORMULA_TEXT);
2137 PUT_LINE ('ROLLOVER_LAST_READING :'||p_counter_instance_rec.ROLLOVER_LAST_READING);
2138 PUT_LINE ('ROLLOVER_FIRST_READING :'||p_counter_instance_rec.ROLLOVER_FIRST_READING);
2139 PUT_LINE ('USAGE_ITEM_ID :'||p_counter_instance_rec.USAGE_ITEM_ID);
2140 PUT_LINE ('CTR_VAL_MAX_SEQ_NO :'||p_counter_instance_rec.CTR_VAL_MAX_SEQ_NO);
2141 PUT_LINE ('START_DATE_ACTIVE :'||p_counter_instance_rec.START_DATE_ACTIVE);
2142 PUT_LINE ('END_DATE_ACTIVE :'||p_counter_instance_rec.END_DATE_ACTIVE);
2143 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_instance_rec.OBJECT_VERSION_NUMBER);
2144 PUT_LINE ('ATTRIBUTE1 :'||p_counter_instance_rec.ATTRIBUTE1);
2145 PUT_LINE ('ATTRIBUTE2 :'||p_counter_instance_rec.ATTRIBUTE2);
2146 PUT_LINE ('ATTRIBUTE3 :'||p_counter_instance_rec.ATTRIBUTE3);
2147 PUT_LINE ('ATTRIBUTE4 :'||p_counter_instance_rec.ATTRIBUTE4);
2148 PUT_LINE ('ATTRIBUTE5 :'||p_counter_instance_rec.ATTRIBUTE5);
2149 PUT_LINE ('ATTRIBUTE6 :'||p_counter_instance_rec.ATTRIBUTE6);
2150 PUT_LINE ('ATTRIBUTE7 :'||p_counter_instance_rec.ATTRIBUTE7);
2151 PUT_LINE ('ATTRIBUTE8 :'||p_counter_instance_rec.ATTRIBUTE8);
2152 PUT_LINE ('ATTRIBUTE9 :'||p_counter_instance_rec.ATTRIBUTE9);
2153 PUT_LINE ('ATTRIBUTE10 :'||p_counter_instance_rec.ATTRIBUTE10);
2154 PUT_LINE ('ATTRIBUTE11 :'||p_counter_instance_rec.ATTRIBUTE11);
2155 PUT_LINE ('ATTRIBUTE12 :'||p_counter_instance_rec.ATTRIBUTE12);
2156 PUT_LINE ('ATTRIBUTE13 :'||p_counter_instance_rec.ATTRIBUTE13);
2157 PUT_LINE ('ATTRIBUTE14 :'||p_counter_instance_rec.ATTRIBUTE14);
2158 PUT_LINE ('ATTRIBUTE15 :'||p_counter_instance_rec.ATTRIBUTE15);
2159 PUT_LINE ('ATTRIBUTE16 :'||p_counter_instance_rec.ATTRIBUTE16);
2160 PUT_LINE ('ATTRIBUTE17 :'||p_counter_instance_rec.ATTRIBUTE17);
2161 PUT_LINE ('ATTRIBUTE18 :'||p_counter_instance_rec.ATTRIBUTE18);
2162 PUT_LINE ('ATTRIBUTE19 :'||p_counter_instance_rec.ATTRIBUTE19);
2163 PUT_LINE ('ATTRIBUTE20 :'||p_counter_instance_rec.ATTRIBUTE20);
2164 PUT_LINE ('ATTRIBUTE21 :'||p_counter_instance_rec.ATTRIBUTE21);
2165 PUT_LINE ('ATTRIBUTE22 :'||p_counter_instance_rec.ATTRIBUTE22);
2166 PUT_LINE ('ATTRIBUTE23 :'||p_counter_instance_rec.ATTRIBUTE23);
2167 PUT_LINE ('ATTRIBUTE24 :'||p_counter_instance_rec.ATTRIBUTE24);
2168 PUT_LINE ('ATTRIBUTE25 :'||p_counter_instance_rec.ATTRIBUTE25);
2169 PUT_LINE ('ATTRIBUTE26 :'||p_counter_instance_rec.ATTRIBUTE26);
2170 PUT_LINE ('ATTRIBUTE27 :'||p_counter_instance_rec.ATTRIBUTE27);
2171 PUT_LINE ('ATTRIBUTE28 :'||p_counter_instance_rec.ATTRIBUTE28);
2172 PUT_LINE ('ATTRIBUTE29 :'||p_counter_instance_rec.ATTRIBUTE29);
2173 PUT_LINE ('ATTRIBUTE30 :'||p_counter_instance_rec.ATTRIBUTE30);
2174 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_instance_rec.ATTRIBUTE_CATEGORY);
2175 PUT_LINE ('DIRECTION :'||p_counter_instance_rec.DIRECTION);
2176 PUT_LINE ('FILTER_TYPE :'||p_counter_instance_rec.FILTER_TYPE);
2177 PUT_LINE ('FILTER_READING_COUNT :'||p_counter_instance_rec.FILTER_READING_COUNT);
2178 PUT_LINE ('FILTER_TIME_UOM :'||p_counter_instance_rec.FILTER_TIME_UOM);
2179 PUT_LINE ('ESTIMATION_ID :'||p_counter_instance_rec.ESTIMATION_ID);
2180 PUT_LINE ('READING_TYPE :'||p_counter_instance_rec.READING_TYPE);
2181 PUT_LINE ('AUTOMATIC_ROLLOVER :'||p_counter_instance_rec.AUTOMATIC_ROLLOVER);
2182 PUT_LINE ('DEFAULT_USAGE_RATE :'||p_counter_instance_rec.DEFAULT_USAGE_RATE);
2183 PUT_LINE ('USE_PAST_READING :'||p_counter_instance_rec.USE_PAST_READING);
2184 PUT_LINE ('USED_IN_SCHEDULING :'||p_counter_instance_rec.USED_IN_SCHEDULING);
2185 PUT_LINE ('DEFAULTED_GROUP_ID :'||p_counter_instance_rec.DEFAULTED_GROUP_ID);
2186 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_instance_rec.SECURITY_GROUP_ID);
2187 PUT_LINE ('CREATED_FROM_COUNTER_TMPL_ID :'||p_counter_instance_rec.CREATED_FROM_COUNTER_TMPL_ID);
2188 PUT_LINE ('NAME :'||p_counter_instance_rec.NAME);
2189 PUT_LINE ('DESCRIPTION :'||p_counter_instance_rec.DESCRIPTION);
2190 PUT_LINE ('COMMENTS :'||p_counter_instance_rec.COMMENTS);
2191 PUT_LINE ('STEP_VALUE :'||p_counter_instance_rec.STEP_VALUE);
2192 PUT_LINE ('TIME_BASED_MANUAL_ENTRY :'||p_counter_instance_rec.TIME_BASED_MANUAL_ENTRY);
2193 PUT_LINE ('EAM_REQUIRED_FLAG :'||p_counter_instance_rec.EAM_REQUIRED_FLAG);
2194 EXCEPTION
2195 WHEN OTHERS THEN
2196 ROLLBACK TO dump_counter_instance_rec;
2197 IF FND_MSG_PUB.Check_Msg_Level
2198 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2199 THEN
2200 FND_MSG_PUB.Add_Exc_Msg
2201 (g_pkg_name,
2202 l_api_name);
2203 END IF;
2204 END dump_counter_instance_rec;
2205
2206 PROCEDURE dump_counter_instance_tbl
2207 (p_counter_instance_tbl IN csi_ctr_datastructures_pub.counter_instance_tbl) IS
2208 l_api_name CONSTANT VARCHAR2(30) := 'dump_counter_instance_tbl';
2209 l_api_version CONSTANT NUMBER := 1.0;
2210
2211 BEGIN
2212 SAVEPOINT dump_counter_instance_tbl;
2213
2214 -- Read the debug profiles values in to global variable 7197402
2215 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2216
2217 IF p_counter_instance_tbl.COUNT > 0 THEN
2218 FOR tab_row IN p_counter_instance_tbl.FIRST .. p_counter_instance_tbl.LAST
2219 LOOP
2220 IF p_counter_instance_tbl.EXISTS(tab_row) THEN
2221
2222 PUT_LINE (' ');
2223 PUT_LINE ('Dumping the values for Counter Instance Table Record # : '||tab_row);
2224 PUT_LINE (' ');
2225 PUT_LINE ('COUNTER_ID :'||p_counter_instance_tbl(tab_row).COUNTER_ID);
2226 PUT_LINE ('GROUP_ID :'||p_counter_instance_tbl(tab_row).GROUP_ID);
2227 PUT_LINE ('DESCRIPTION :'||p_counter_instance_tbl(tab_row).DESCRIPTION);
2228 PUT_LINE ('COUNTER_TYPE :'||p_counter_instance_tbl(tab_row).COUNTER_TYPE);
2229 PUT_LINE ('INITIAL_READING :'||p_counter_instance_tbl(tab_row).INITIAL_READING);
2230 PUT_LINE ('INITIAL_READING_DATE :'||p_counter_instance_tbl(tab_row).INITIAL_READING_DATE);
2231 PUT_LINE ('TOLERANCE_PLUS :'||p_counter_instance_tbl(tab_row).TOLERANCE_PLUS);
2232 PUT_LINE ('TOLERANCE_MINUS :'||p_counter_instance_tbl(tab_row).TOLERANCE_MINUS);
2233 PUT_LINE ('UOM_CODE :'||p_counter_instance_tbl(tab_row).UOM_CODE);
2234 PUT_LINE ('DERIVE_COUNTER_ID :'||p_counter_instance_tbl(tab_row).DERIVE_COUNTER_ID);
2235 PUT_LINE ('DERIVE_FUNCTION :'||p_counter_instance_tbl(tab_row).DERIVE_FUNCTION);
2236 PUT_LINE ('DERIVE_PROPERTY_ID :'||p_counter_instance_tbl(tab_row).DERIVE_PROPERTY_ID);
2237 PUT_LINE ('VALID_FLAG :'||p_counter_instance_tbl(tab_row).VALID_FLAG);
2238 PUT_LINE ('FORMULA_INCOMPLETE_FLAG :'||p_counter_instance_tbl(tab_row).FORMULA_INCOMPLETE_FLAG);
2239 PUT_LINE ('FORMULA_TEXT :'||p_counter_instance_tbl(tab_row).FORMULA_TEXT);
2240 PUT_LINE ('ROLLOVER_LAST_READING :'||p_counter_instance_tbl(tab_row).ROLLOVER_LAST_READING);
2241 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);
2242 PUT_LINE ('CTR_VAL_MAX_SEQ_NO :'||p_counter_instance_tbl(tab_row).CTR_VAL_MAX_SEQ_NO);
2243 PUT_LINE ('START_DATE_ACTIVE :'||p_counter_instance_tbl(tab_row).START_DATE_ACTIVE);
2244 PUT_LINE ('END_DATE_ACTIVE :'||p_counter_instance_tbl(tab_row).END_DATE_ACTIVE);
2245 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_instance_tbl(tab_row).OBJECT_VERSION_NUMBER);
2246 PUT_LINE ('ATTRIBUTE1 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE1);
2247 PUT_LINE ('ATTRIBUTE2 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE2);
2248 PUT_LINE ('ATTRIBUTE3 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE3);
2249 PUT_LINE ('ATTRIBUTE4 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE4);
2250 PUT_LINE ('ATTRIBUTE5 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE5);
2251 PUT_LINE ('ATTRIBUTE6 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE6);
2252 PUT_LINE ('ATTRIBUTE7 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE7);
2253 PUT_LINE ('ATTRIBUTE8 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE8);
2254 PUT_LINE ('ATTRIBUTE9 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE9);
2255 PUT_LINE ('ATTRIBUTE10 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE10);
2256 PUT_LINE ('ATTRIBUTE11 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE11);
2257 PUT_LINE ('ATTRIBUTE12 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE12);
2258 PUT_LINE ('ATTRIBUTE13 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE13);
2259 PUT_LINE ('ATTRIBUTE14 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE14);
2260 PUT_LINE ('ATTRIBUTE15 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE15);
2261 PUT_LINE ('ATTRIBUTE16 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE16);
2262 PUT_LINE ('ATTRIBUTE17 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE17);
2263 PUT_LINE ('ATTRIBUTE18 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE18);
2264 PUT_LINE ('ATTRIBUTE19 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE19);
2265 PUT_LINE ('ATTRIBUTE20 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE20);
2266 PUT_LINE ('ATTRIBUTE21 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE21);
2267 PUT_LINE ('ATTRIBUTE22 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE22);
2268 PUT_LINE ('ATTRIBUTE23 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE23);
2269 PUT_LINE ('ATTRIBUTE24 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE24);
2270 PUT_LINE ('ATTRIBUTE25 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE25);
2271 PUT_LINE ('ATTRIBUTE26 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE26);
2272 PUT_LINE ('ATTRIBUTE27 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE27);
2273 PUT_LINE ('ATTRIBUTE28 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE28);
2274 PUT_LINE ('ATTRIBUTE29 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE29);
2275 PUT_LINE ('ATTRIBUTE30 :'||p_counter_instance_tbl(tab_row).ATTRIBUTE30);
2276 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_instance_tbl(tab_row).ATTRIBUTE_CATEGORY);
2277 PUT_LINE ('DIRECTION :'||p_counter_instance_tbl(tab_row).DIRECTION);
2278 PUT_LINE ('FILTER_TYPE :'||p_counter_instance_tbl(tab_row).FILTER_TYPE);
2279 PUT_LINE ('FILTER_READING_COUNT :'||p_counter_instance_tbl(tab_row).FILTER_READING_COUNT);
2280 PUT_LINE ('FILTER_TIME_UOM :'||p_counter_instance_tbl(tab_row).FILTER_TIME_UOM);
2281 PUT_LINE ('ESTIMATION_ID :'||p_counter_instance_tbl(tab_row).ESTIMATION_ID);
2282 PUT_LINE ('READING_TYPE :'||p_counter_instance_tbl(tab_row).READING_TYPE);
2283 PUT_LINE ('AUTOMATIC_ROLLOVER :'||p_counter_instance_tbl(tab_row).AUTOMATIC_ROLLOVER);
2284 PUT_LINE ('DEFAULT_USAGE_RATE :'||p_counter_instance_tbl(tab_row).DEFAULT_USAGE_RATE);
2285 PUT_LINE ('USE_PAST_READING :'||p_counter_instance_tbl(tab_row).USE_PAST_READING);
2286 PUT_LINE ('USED_IN_SCHEDULING :'||p_counter_instance_tbl(tab_row).USED_IN_SCHEDULING);
2287 PUT_LINE ('DEFAULTED_GROUP_ID :'||p_counter_instance_tbl(tab_row).DEFAULTED_GROUP_ID);
2288 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_instance_tbl(tab_row).SECURITY_GROUP_ID);
2289 PUT_LINE ('CREATED_FROM_COUNTER_TMPL_ID :'||p_counter_instance_tbl(tab_row).CREATED_FROM_COUNTER_TMPL_ID);
2290 PUT_LINE ('NAME :'||p_counter_instance_tbl(tab_row).NAME);
2291 PUT_LINE ('DESCRIPTION :'||p_counter_instance_tbl(tab_row).DESCRIPTION);
2292 PUT_LINE ('COMMENTS :'||p_counter_instance_tbl(tab_row).COMMENTS);
2293 PUT_LINE ('STEP_VALUE :'||p_counter_instance_tbl(tab_row).STEP_VALUE);
2294 PUT_LINE ('TIME_BASED_MANUAL_ENTRY :'||p_counter_instance_tbl(tab_row).TIME_BASED_MANUAL_ENTRY);
2295 PUT_LINE ('EAM_REQUIRED_FLAG :'||p_counter_instance_tbl(tab_row).EAM_REQUIRED_FLAG);
2296
2297 END IF;
2298 END LOOP;
2299 END IF;
2300 EXCEPTION
2301 WHEN OTHERS THEN
2302 ROLLBACK TO dump_counter_instance_tbl;
2303 IF FND_MSG_PUB.Check_Msg_Level
2304 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2305 THEN
2306 FND_MSG_PUB.Add_Exc_Msg
2307 (g_pkg_name,
2308 l_api_name);
2309 END IF;
2310 END dump_counter_instance_tbl;
2311
2312 PROCEDURE dump_ctr_properties_rec
2313 (p_ctr_properties_rec IN csi_ctr_datastructures_pub.ctr_properties_rec) IS
2314 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_properties_rec';
2315 l_api_version CONSTANT NUMBER := 1.0;
2316 BEGIN
2317 SAVEPOINT dump_ctr_properties_rec;
2318
2319 -- Read the debug profiles values in to global variable 7197402
2320 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2321
2322 PUT_LINE (' ');
2323 PUT_LINE ('Dumping the values for Counter Properties Record:');
2324 PUT_LINE (' ');
2325
2326 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_properties_rec.COUNTER_PROPERTY_ID);
2327 PUT_LINE ('COUNTER_ID :'||p_ctr_properties_rec.COUNTER_ID);
2328 PUT_LINE ('PROPERTY_DATA_TYPE :'||p_ctr_properties_rec.PROPERTY_DATA_TYPE);
2329 PUT_LINE ('IS_NULLABLE :'||p_ctr_properties_rec.IS_NULLABLE);
2330 PUT_LINE ('DEFAULT_VALUE :'||p_ctr_properties_rec.DEFAULT_VALUE);
2331 PUT_LINE ('MINIMUM_VALUE :'||p_ctr_properties_rec.MINIMUM_VALUE);
2332 PUT_LINE ('MAXIMUM_VALUE :'||p_ctr_properties_rec.MAXIMUM_VALUE);
2333 PUT_LINE ('UOM_CODE :'||p_ctr_properties_rec.UOM_CODE);
2334 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_properties_rec.START_DATE_ACTIVE);
2335 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_properties_rec.END_DATE_ACTIVE);
2336 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_properties_rec.OBJECT_VERSION_NUMBER);
2337 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_properties_rec.ATTRIBUTE1);
2338 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_properties_rec.ATTRIBUTE2);
2339 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_properties_rec.ATTRIBUTE3);
2340 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_properties_rec.ATTRIBUTE4);
2341 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_properties_rec.ATTRIBUTE5);
2342 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_properties_rec.ATTRIBUTE6);
2343 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_properties_rec.ATTRIBUTE7);
2344 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_properties_rec.ATTRIBUTE8);
2345 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_properties_rec.ATTRIBUTE9);
2346 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_properties_rec.ATTRIBUTE10);
2347 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_properties_rec.ATTRIBUTE11);
2348 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_properties_rec.ATTRIBUTE12);
2349 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_properties_rec.ATTRIBUTE13);
2350 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_properties_rec.ATTRIBUTE14);
2351 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_properties_rec.ATTRIBUTE15);
2352 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_properties_rec.ATTRIBUTE_CATEGORY);
2353 PUT_LINE ('PROPERTY_LOV_TYPE :'||p_ctr_properties_rec.PROPERTY_LOV_TYPE);
2354 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_properties_rec.SECURITY_GROUP_ID);
2355 PUT_LINE ('CREATED_FROM_CTR_PROP_TMPL_ID :'||p_ctr_properties_rec.CREATED_FROM_CTR_PROP_TMPL_ID);
2356 PUT_LINE ('NAME :'||p_ctr_properties_rec.NAME);
2357 PUT_LINE ('DESCRIPTION :'||p_ctr_properties_rec.DESCRIPTION);
2358 EXCEPTION
2359 WHEN OTHERS THEN
2360 ROLLBACK TO dump_ctr_properties_rec;
2361 IF FND_MSG_PUB.Check_Msg_Level
2362 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2363 THEN
2364 FND_MSG_PUB.Add_Exc_Msg
2365 (g_pkg_name,
2366 l_api_name);
2367 END IF;
2368 END dump_ctr_properties_rec;
2369
2370 PROCEDURE dump_ctr_properties_tbl
2371 (p_ctr_properties_tbl IN csi_ctr_datastructures_pub.ctr_properties_tbl) IS
2372 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_properties_tbl';
2373 l_api_version CONSTANT NUMBER := 1.0;
2374
2375 BEGIN
2376 SAVEPOINT dump_ctr_properties_tbl;
2377
2378 -- Read the debug profiles values in to global variable 7197402
2379 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2380
2381 IF p_ctr_properties_tbl.COUNT > 0 THEN
2382 FOR tab_row IN p_ctr_properties_tbl.FIRST .. p_ctr_properties_tbl.LAST
2383 LOOP
2384 IF p_ctr_properties_tbl.EXISTS(tab_row) THEN
2385
2386 PUT_LINE (' ');
2387 PUT_LINE ('Dumping the values for Counter Properties Table Record # : '||tab_row);
2388 PUT_LINE (' ');
2389
2390 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_properties_tbl(tab_row).COUNTER_PROPERTY_ID);
2391 PUT_LINE ('COUNTER_ID :'||p_ctr_properties_tbl(tab_row).COUNTER_ID);
2392 PUT_LINE ('PROPERTY_DATA_TYPE :'||p_ctr_properties_tbl(tab_row).PROPERTY_DATA_TYPE);
2393 PUT_LINE ('IS_NULLABLE :'||p_ctr_properties_tbl(tab_row).IS_NULLABLE);
2394 PUT_LINE ('DEFAULT_VALUE :'||p_ctr_properties_tbl(tab_row).DEFAULT_VALUE);
2395 PUT_LINE ('MINIMUM_VALUE :'||p_ctr_properties_tbl(tab_row).MINIMUM_VALUE);
2396 PUT_LINE ('MAXIMUM_VALUE :'||p_ctr_properties_tbl(tab_row).MAXIMUM_VALUE);
2397 PUT_LINE ('UOM_CODE :'||p_ctr_properties_tbl(tab_row).UOM_CODE);
2398 PUT_LINE ('START_DATE_ACTIVE :'||p_ctr_properties_tbl(tab_row).START_DATE_ACTIVE);
2399 PUT_LINE ('END_DATE_ACTIVE :'||p_ctr_properties_tbl(tab_row).END_DATE_ACTIVE);
2400 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_properties_tbl(tab_row).OBJECT_VERSION_NUMBER);
2401 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE1);
2402 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE2);
2403 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE3);
2404 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE4);
2405 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE5);
2406 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE6);
2407 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE7);
2408 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE8);
2409 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE9);
2410 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE10);
2411 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE11);
2412 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE12);
2413 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE13);
2414 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE14);
2415 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE15);
2416 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_properties_tbl(tab_row).ATTRIBUTE_CATEGORY);
2417 PUT_LINE ('PROPERTY_LOV_TYPE :'||p_ctr_properties_tbl(tab_row).PROPERTY_LOV_TYPE);
2418 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_properties_tbl(tab_row).SECURITY_GROUP_ID);
2419 PUT_LINE ('CREATED_FROM_CTR_PROP_TMPL_ID :'||p_ctr_properties_tbl(tab_row).CREATED_FROM_CTR_PROP_TMPL_ID);
2420 PUT_LINE ('NAME :'||p_ctr_properties_tbl(tab_row).NAME);
2421 PUT_LINE ('DESCRIPTION :'||p_ctr_properties_tbl(tab_row).DESCRIPTION);
2422
2423 END IF;
2424 END LOOP;
2425 END IF;
2426 EXCEPTION
2427 WHEN OTHERS THEN
2428 ROLLBACK TO dump_ctr_properties_tbl;
2429 IF FND_MSG_PUB.Check_Msg_Level
2430 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2431 THEN
2432 FND_MSG_PUB.Add_Exc_Msg
2433 (g_pkg_name,
2434 l_api_name);
2435 END IF;
2436 END dump_ctr_properties_tbl;
2437
2438 PROCEDURE dump_counter_associations_rec
2439 (p_counter_associations_rec IN csi_ctr_datastructures_pub.counter_associations_rec) IS
2440 l_api_name CONSTANT VARCHAR2(30) := 'dump_counter_associations_rec';
2441 l_api_version CONSTANT NUMBER := 1.0;
2442 BEGIN
2443 SAVEPOINT dump_counter_associations_rec;
2444
2445 -- Read the debug profiles values in to global variable 7197402
2446 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2447
2448 PUT_LINE (' ');
2449 PUT_LINE ('Dumping the values for Counter Instance Association Record:');
2450 PUT_LINE (' ');
2451
2452 PUT_LINE ('INSTANCE_ASSOCIATION_ID :'||p_counter_associations_rec.INSTANCE_ASSOCIATION_ID);
2453 PUT_LINE ('SOURCE_OBJECT_CODE :'||p_counter_associations_rec.SOURCE_OBJECT_CODE);
2454 PUT_LINE ('SOURCE_OBJECT_ID :'||p_counter_associations_rec.SOURCE_OBJECT_ID);
2455 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_associations_rec.OBJECT_VERSION_NUMBER);
2456 PUT_LINE ('ATTRIBUTE1 :'||p_counter_associations_rec.ATTRIBUTE1);
2457 PUT_LINE ('ATTRIBUTE2 :'||p_counter_associations_rec.ATTRIBUTE2);
2458 PUT_LINE ('ATTRIBUTE3 :'||p_counter_associations_rec.ATTRIBUTE3);
2459 PUT_LINE ('ATTRIBUTE4 :'||p_counter_associations_rec.ATTRIBUTE4);
2460 PUT_LINE ('ATTRIBUTE5 :'||p_counter_associations_rec.ATTRIBUTE5);
2461 PUT_LINE ('ATTRIBUTE6 :'||p_counter_associations_rec.ATTRIBUTE6);
2462 PUT_LINE ('ATTRIBUTE7 :'||p_counter_associations_rec.ATTRIBUTE7);
2463 PUT_LINE ('ATTRIBUTE8 :'||p_counter_associations_rec.ATTRIBUTE8);
2464 PUT_LINE ('ATTRIBUTE9 :'||p_counter_associations_rec.ATTRIBUTE9);
2465 PUT_LINE ('ATTRIBUTE10 :'||p_counter_associations_rec.ATTRIBUTE10);
2466 PUT_LINE ('ATTRIBUTE11 :'||p_counter_associations_rec.ATTRIBUTE11);
2467 PUT_LINE ('ATTRIBUTE12 :'||p_counter_associations_rec.ATTRIBUTE12);
2468 PUT_LINE ('ATTRIBUTE13 :'||p_counter_associations_rec.ATTRIBUTE13);
2469 PUT_LINE ('ATTRIBUTE14 :'||p_counter_associations_rec.ATTRIBUTE14);
2470 PUT_LINE ('ATTRIBUTE15 :'||p_counter_associations_rec.ATTRIBUTE15);
2471 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_associations_rec.ATTRIBUTE_CATEGORY);
2472 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_associations_rec.SECURITY_GROUP_ID);
2473 PUT_LINE ('COUNTER_ID :'||p_counter_associations_rec.COUNTER_ID);
2474 PUT_LINE ('START_DATE_ACTIVE :'||p_counter_associations_rec.START_DATE_ACTIVE);
2475 PUT_LINE ('END_DATE_ACTIVE :'||p_counter_associations_rec.END_DATE_ACTIVE);
2476 PUT_LINE ('MAINT_ORGANIZATION_ID :'||p_counter_associations_rec.MAINT_ORGANIZATION_ID);
2477 PUT_LINE ('PRIMARY_FAILURE_FLAG :'||p_counter_associations_rec.PRIMARY_FAILURE_FLAG);
2478
2479 EXCEPTION
2480 WHEN OTHERS THEN
2481 ROLLBACK TO dump_counter_associations_rec;
2482 IF FND_MSG_PUB.Check_Msg_Level
2483 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2484 THEN
2485 FND_MSG_PUB.Add_Exc_Msg
2486 (g_pkg_name,
2487 l_api_name);
2488 END IF;
2489 END dump_counter_associations_rec;
2490
2491 PROCEDURE dump_counter_associations_tbl
2492 (p_counter_associations_tbl IN csi_ctr_datastructures_pub.counter_associations_tbl) IS
2493 l_api_name CONSTANT VARCHAR2(30) := 'dump_counter_associations_tbl';
2494 l_api_version CONSTANT NUMBER := 1.0;
2495
2496 BEGIN
2497 SAVEPOINT dump_counter_associations_tbl;
2498
2499 -- Read the debug profiles values in to global variable 7197402
2500 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2501
2502 IF p_counter_associations_tbl.COUNT > 0 THEN
2503 FOR tab_row IN p_counter_associations_tbl.FIRST .. p_counter_associations_tbl.LAST
2504 LOOP
2505 IF p_counter_associations_tbl.EXISTS(tab_row) THEN
2506
2507 PUT_LINE (' ');
2508 PUT_LINE ('Dumping the values for Counter Instance Association Table Record # : '||tab_row);
2509 PUT_LINE (' ');
2510
2511 PUT_LINE ('INSTANCE_ASSOCIATION_ID :'||p_counter_associations_tbl(tab_row).INSTANCE_ASSOCIATION_ID);
2512 PUT_LINE ('SOURCE_OBJECT_CODE :'||p_counter_associations_tbl(tab_row).SOURCE_OBJECT_CODE);
2513 PUT_LINE ('SOURCE_OBJECT_ID :'||p_counter_associations_tbl(tab_row).SOURCE_OBJECT_ID);
2514 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_associations_tbl(tab_row).OBJECT_VERSION_NUMBER);
2515 PUT_LINE ('ATTRIBUTE1 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE1);
2516 PUT_LINE ('ATTRIBUTE2 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE2);
2517 PUT_LINE ('ATTRIBUTE3 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE3);
2518 PUT_LINE ('ATTRIBUTE4 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE4);
2519 PUT_LINE ('ATTRIBUTE5 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE5);
2520 PUT_LINE ('ATTRIBUTE6 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE6);
2521 PUT_LINE ('ATTRIBUTE7 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE7);
2522 PUT_LINE ('ATTRIBUTE8 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE8);
2523 PUT_LINE ('ATTRIBUTE9 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE9);
2524 PUT_LINE ('ATTRIBUTE10 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE10);
2525 PUT_LINE ('ATTRIBUTE11 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE11);
2526 PUT_LINE ('ATTRIBUTE12 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE12);
2527 PUT_LINE ('ATTRIBUTE13 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE13);
2528 PUT_LINE ('ATTRIBUTE14 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE14);
2529 PUT_LINE ('ATTRIBUTE15 :'||p_counter_associations_tbl(tab_row).ATTRIBUTE15);
2530 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_associations_tbl(tab_row).ATTRIBUTE_CATEGORY);
2531 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_associations_tbl(tab_row).SECURITY_GROUP_ID);
2532 PUT_LINE ('COUNTER_ID :'||p_counter_associations_tbl(tab_row).COUNTER_ID);
2533 PUT_LINE ('START_DATE_ACTIVE :'||p_counter_associations_tbl(tab_row).START_DATE_ACTIVE);
2534 PUT_LINE ('END_DATE_ACTIVE :'||p_counter_associations_tbl(tab_row).END_DATE_ACTIVE);
2535 PUT_LINE ('MAINT_ORGANIZATION_ID :'||p_counter_associations_tbl(tab_row).MAINT_ORGANIZATION_ID);
2536 PUT_LINE ('PRIMARY_FAILURE_FLAG :'||p_counter_associations_tbl(tab_row).PRIMARY_FAILURE_FLAG);
2537
2538 END IF;
2539 END LOOP;
2540 END IF;
2541 EXCEPTION
2542 WHEN OTHERS THEN
2543 ROLLBACK TO dump_counter_associations_tbl;
2544 IF FND_MSG_PUB.Check_Msg_Level
2545 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2546 THEN
2547 FND_MSG_PUB.Add_Exc_Msg
2548 (g_pkg_name,
2549 l_api_name);
2550 END IF;
2551 END dump_counter_associations_tbl;
2552
2553 PROCEDURE dump_counter_readings_rec
2554 (p_counter_readings_rec IN csi_ctr_datastructures_pub.counter_readings_rec) IS
2555 l_api_name CONSTANT VARCHAR2(30) := 'dump_counter_readings_rec';
2556 l_api_version CONSTANT NUMBER := 1.0;
2557 BEGIN
2558 SAVEPOINT dump_counter_readings_rec;
2559
2560 -- Read the debug profiles values in to global variable 7197402
2561 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2562
2563 PUT_LINE (' ');
2564 PUT_LINE ('Dumping the values for Counter Readings Record:');
2565 PUT_LINE (' ');
2566
2567 PUT_LINE ('COUNTER_VALUE_ID :'||p_counter_readings_rec.COUNTER_VALUE_ID);
2568 PUT_LINE ('COUNTER_ID :'||p_counter_readings_rec.COUNTER_ID);
2569 PUT_LINE ('VALUE_TIMESTAMP :'||p_counter_readings_rec.VALUE_TIMESTAMP);
2570 -- PUT_LINE ('SEQ_NO :'||p_counter_readings_rec.SEQ_NO);
2571 PUT_LINE ('COUNTER_READING :'||p_counter_readings_rec.COUNTER_READING);
2572 PUT_LINE ('RESET_MODE :'||p_counter_readings_rec.RESET_MODE);
2573 PUT_LINE ('RESET_REASON :'||p_counter_readings_rec.RESET_REASON);
2574 -- PUT_LINE ('READING_BEFORE_RESET :'||p_counter_readings_rec.READING_BEFORE_RESET);
2575 -- PUT_LINE ('READING_AFTER_RESET :'||p_counter_readings_rec.READING_AFTER_RESET);
2576 PUT_LINE ('ADJUSTMENT_TYPE :'||p_counter_readings_rec.ADJUSTMENT_TYPE);
2577 PUT_LINE ('ADJUSTMENT_READING :'||p_counter_readings_rec.ADJUSTMENT_READING);
2578 -- PUT_LINE ('CUMULATIVE_ADJUSTMENT :'||p_counter_readings_rec.CUMULATIVE_ADJUSTMENT);
2579 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_readings_rec.OBJECT_VERSION_NUMBER);
2580 PUT_LINE ('ATTRIBUTE1 :'||p_counter_readings_rec.ATTRIBUTE1);
2581 PUT_LINE ('ATTRIBUTE2 :'||p_counter_readings_rec.ATTRIBUTE2);
2582 PUT_LINE ('ATTRIBUTE3 :'||p_counter_readings_rec.ATTRIBUTE3);
2583 PUT_LINE ('ATTRIBUTE4 :'||p_counter_readings_rec.ATTRIBUTE4);
2584 PUT_LINE ('ATTRIBUTE5 :'||p_counter_readings_rec.ATTRIBUTE5);
2585 PUT_LINE ('ATTRIBUTE6 :'||p_counter_readings_rec.ATTRIBUTE6);
2586 PUT_LINE ('ATTRIBUTE7 :'||p_counter_readings_rec.ATTRIBUTE7);
2587 PUT_LINE ('ATTRIBUTE8 :'||p_counter_readings_rec.ATTRIBUTE8);
2588 PUT_LINE ('ATTRIBUTE9 :'||p_counter_readings_rec.ATTRIBUTE9);
2589 PUT_LINE ('ATTRIBUTE10 :'||p_counter_readings_rec.ATTRIBUTE10);
2590 PUT_LINE ('ATTRIBUTE11 :'||p_counter_readings_rec.ATTRIBUTE11);
2591 PUT_LINE ('ATTRIBUTE12 :'||p_counter_readings_rec.ATTRIBUTE12);
2592 PUT_LINE ('ATTRIBUTE13 :'||p_counter_readings_rec.ATTRIBUTE13);
2593 PUT_LINE ('ATTRIBUTE14 :'||p_counter_readings_rec.ATTRIBUTE14);
2594 PUT_LINE ('ATTRIBUTE15 :'||p_counter_readings_rec.ATTRIBUTE15);
2595 PUT_LINE ('ATTRIBUTE16 :'||p_counter_readings_rec.ATTRIBUTE16);
2596 PUT_LINE ('ATTRIBUTE17 :'||p_counter_readings_rec.ATTRIBUTE17);
2597 PUT_LINE ('ATTRIBUTE18 :'||p_counter_readings_rec.ATTRIBUTE18);
2598 PUT_LINE ('ATTRIBUTE19 :'||p_counter_readings_rec.ATTRIBUTE19);
2599 PUT_LINE ('ATTRIBUTE20 :'||p_counter_readings_rec.ATTRIBUTE20);
2600 PUT_LINE ('ATTRIBUTE21 :'||p_counter_readings_rec.ATTRIBUTE21);
2601 PUT_LINE ('ATTRIBUTE22 :'||p_counter_readings_rec.ATTRIBUTE22);
2602 PUT_LINE ('ATTRIBUTE23 :'||p_counter_readings_rec.ATTRIBUTE23);
2603 PUT_LINE ('ATTRIBUTE24 :'||p_counter_readings_rec.ATTRIBUTE24);
2604 PUT_LINE ('ATTRIBUTE25 :'||p_counter_readings_rec.ATTRIBUTE25);
2605 PUT_LINE ('ATTRIBUTE26 :'||p_counter_readings_rec.ATTRIBUTE26);
2606 PUT_LINE ('ATTRIBUTE27 :'||p_counter_readings_rec.ATTRIBUTE27);
2607 PUT_LINE ('ATTRIBUTE28 :'||p_counter_readings_rec.ATTRIBUTE28);
2608 PUT_LINE ('ATTRIBUTE29 :'||p_counter_readings_rec.ATTRIBUTE29);
2609 PUT_LINE ('ATTRIBUTE30 :'||p_counter_readings_rec.ATTRIBUTE30);
2610 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_readings_rec.ATTRIBUTE_CATEGORY);
2611 PUT_LINE ('COMMENTS :'||p_counter_readings_rec.COMMENTS);
2612 PUT_LINE ('LIFE_TO_DATE_READING :'||p_counter_readings_rec.LIFE_TO_DATE_READING);
2613 PUT_LINE ('TRANSACTION_ID :'||p_counter_readings_rec.TRANSACTION_ID);
2614 PUT_LINE ('AUTOMATIC_ROLLOVER_FLAG :'||p_counter_readings_rec.AUTOMATIC_ROLLOVER_FLAG);
2615 PUT_LINE ('INCLUDE_TARGET_RESETS :'||p_counter_readings_rec.INCLUDE_TARGET_RESETS);
2616 PUT_LINE ('SOURCE_COUNTER_VALUE_ID :'||p_counter_readings_rec.SOURCE_COUNTER_VALUE_ID);
2617 PUT_LINE ('NET_READING :'||p_counter_readings_rec.NET_READING);
2618 PUT_LINE ('DISABLED_FLAG :'||p_counter_readings_rec.DISABLED_FLAG);
2619 PUT_LINE ('SOURCE_CODE :'||p_counter_readings_rec.SOURCE_CODE);
2620 PUT_LINE ('SOURCE_LINE_ID :'||p_counter_readings_rec.SOURCE_LINE_ID);
2621 PUT_LINE ('RESET_COUNTER_READING :'||p_counter_readings_rec.RESET_COUNTER_READING);
2622 PUT_LINE ('PARENT_TBL_INDEX :'||p_counter_readings_rec.PARENT_TBL_INDEX);
2623 PUT_LINE ('INITIAL_READING_FLAG :'||p_counter_readings_rec.INITIAL_READING_FLAG);
2624 EXCEPTION
2625 WHEN OTHERS THEN
2626 ROLLBACK TO dump_counter_readings_rec;
2627 IF FND_MSG_PUB.Check_Msg_Level
2628 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2629 THEN
2630 FND_MSG_PUB.Add_Exc_Msg
2631 (g_pkg_name,
2632 l_api_name);
2633 END IF;
2634 END dump_counter_readings_rec;
2635
2636 PROCEDURE dump_counter_readings_tbl
2637 (p_counter_readings_tbl IN csi_ctr_datastructures_pub.counter_readings_tbl) IS
2638 l_api_name CONSTANT VARCHAR2(30) := 'dump_counter_readings_tbl';
2639 l_api_version CONSTANT NUMBER := 1.0;
2640
2641 BEGIN
2642 SAVEPOINT dump_counter_readings_tbl;
2643
2644 -- Read the debug profiles values in to global variable 7197402
2645 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2646
2647 IF p_counter_readings_tbl.COUNT > 0 THEN
2648 FOR tab_row IN p_counter_readings_tbl.FIRST .. p_counter_readings_tbl.LAST
2649 LOOP
2650 IF p_counter_readings_tbl.EXISTS(tab_row) THEN
2651
2652 PUT_LINE (' ');
2653 PUT_LINE ('Dumping the values for Counter Readings Table Record # : '||tab_row);
2654 PUT_LINE (' ');
2655
2656 PUT_LINE ('COUNTER_VALUE_ID :'||p_counter_readings_tbl(tab_row).COUNTER_VALUE_ID);
2657 PUT_LINE ('COUNTER_ID :'||p_counter_readings_tbl(tab_row).COUNTER_ID);
2658 PUT_LINE ('VALUE_TIMESTAMP :'||p_counter_readings_tbl(tab_row).VALUE_TIMESTAMP);
2659 -- PUT_LINE ('SEQ_NO :'||p_counter_readings_tbl(tab_row).SEQ_NO);
2660 PUT_LINE ('COUNTER_READING :'||p_counter_readings_tbl(tab_row).COUNTER_READING);
2661 PUT_LINE ('RESET_MODE :'||p_counter_readings_tbl(tab_row).RESET_MODE);
2662 PUT_LINE ('RESET_REASON :'||p_counter_readings_tbl(tab_row).RESET_REASON);
2663 -- PUT_LINE ('READING_BEFORE_RESET :'||p_counter_readings_tbl(tab_row).READING_BEFORE_RESET);
2664 -- PUT_LINE ('READING_AFTER_RESET :'||p_counter_readings_tbl(tab_row).READING_AFTER_RESET);
2665 PUT_LINE ('ADJUSTMENT_TYPE :'||p_counter_readings_tbl(tab_row).ADJUSTMENT_TYPE);
2666 PUT_LINE ('ADJUSTMENT_READING :'||p_counter_readings_tbl(tab_row).ADJUSTMENT_READING);
2667 -- PUT_LINE ('CUMULATIVE_ADJUSTMENT :'||p_counter_readings_tbl(tab_row).CUMULATIVE_ADJUSTMENT);
2668 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_counter_readings_tbl(tab_row).OBJECT_VERSION_NUMBER);
2669 PUT_LINE ('ATTRIBUTE1 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE1);
2670 PUT_LINE ('ATTRIBUTE2 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE2);
2671 PUT_LINE ('ATTRIBUTE3 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE3);
2672 PUT_LINE ('ATTRIBUTE4 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE4);
2673 PUT_LINE ('ATTRIBUTE5 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE5);
2674 PUT_LINE ('ATTRIBUTE6 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE6);
2675 PUT_LINE ('ATTRIBUTE7 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE7);
2676 PUT_LINE ('ATTRIBUTE8 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE8);
2677 PUT_LINE ('ATTRIBUTE9 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE9);
2678 PUT_LINE ('ATTRIBUTE10 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE10);
2679 PUT_LINE ('ATTRIBUTE11 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE11);
2680 PUT_LINE ('ATTRIBUTE12 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE12);
2681 PUT_LINE ('ATTRIBUTE13 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE13);
2682 PUT_LINE ('ATTRIBUTE14 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE14);
2683 PUT_LINE ('ATTRIBUTE15 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE15);
2684 PUT_LINE ('ATTRIBUTE16 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE16);
2685 PUT_LINE ('ATTRIBUTE17 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE17);
2686 PUT_LINE ('ATTRIBUTE18 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE18);
2687 PUT_LINE ('ATTRIBUTE19 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE19);
2688 PUT_LINE ('ATTRIBUTE20 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE20);
2689 PUT_LINE ('ATTRIBUTE21 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE21);
2690 PUT_LINE ('ATTRIBUTE22 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE22);
2691 PUT_LINE ('ATTRIBUTE23 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE23);
2692 PUT_LINE ('ATTRIBUTE24 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE24);
2693 PUT_LINE ('ATTRIBUTE25 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE25);
2694 PUT_LINE ('ATTRIBUTE26 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE26);
2695 PUT_LINE ('ATTRIBUTE27 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE27);
2696 PUT_LINE ('ATTRIBUTE28 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE28);
2697 PUT_LINE ('ATTRIBUTE29 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE29);
2698 PUT_LINE ('ATTRIBUTE30 :'||p_counter_readings_tbl(tab_row).ATTRIBUTE30);
2699 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_counter_readings_tbl(tab_row).ATTRIBUTE_CATEGORY);
2700 PUT_LINE ('COMMENTS :'||p_counter_readings_tbl(tab_row).COMMENTS);
2701 PUT_LINE ('LIFE_TO_DATE_READING :'||p_counter_readings_tbl(tab_row).LIFE_TO_DATE_READING);
2702 PUT_LINE ('TRANSACTION_ID :'||p_counter_readings_tbl(tab_row).TRANSACTION_ID);
2703 PUT_LINE ('AUTOMATIC_ROLLOVER_FLAG :'||p_counter_readings_tbl(tab_row).AUTOMATIC_ROLLOVER_FLAG);
2704 PUT_LINE ('INCLUDE_TARGET_RESETS :'||p_counter_readings_tbl(tab_row).INCLUDE_TARGET_RESETS);
2705 PUT_LINE ('SOURCE_COUNTER_VALUE_ID :'||p_counter_readings_tbl(tab_row).SOURCE_COUNTER_VALUE_ID);
2706 PUT_LINE ('NET_READING :'||p_counter_readings_tbl(tab_row).NET_READING);
2707 PUT_LINE ('DISABLED_FLAG :'||p_counter_readings_tbl(tab_row).DISABLED_FLAG);
2708 PUT_LINE ('SOURCE_CODE :'||p_counter_readings_tbl(tab_row).SOURCE_CODE);
2709 PUT_LINE ('SOURCE_LINE_ID :'||p_counter_readings_tbl(tab_row).SOURCE_LINE_ID);
2710 PUT_LINE ('SECURITY_GROUP_ID :'||p_counter_readings_tbl(tab_row).SECURITY_GROUP_ID);
2711 -- PUT_LINE ('SOURCE_TRANSACTION_TYPE_ID :'||p_counter_readings_tbl(tab_row).SOURCE_TRANSACTION_TYPE_ID);
2712 -- PUT_LINE ('SOURCE_TRANSACTION_ID :'||p_counter_readings_tbl(tab_row).SOURCE_TRANSACTION_ID);
2713 PUT_LINE ('NET_READING :'||p_counter_readings_tbl(tab_row).NET_READING);
2714 PUT_LINE ('DISABLED_FLAG :'||p_counter_readings_tbl(tab_row).DISABLED_FLAG);
2715 PUT_LINE ('RESET_COUNTER_READING :'||p_counter_readings_tbl(tab_row).RESET_COUNTER_READING);
2716 PUT_LINE ('PARENT_TBL_INDEX :'||p_counter_readings_tbl(tab_row).PARENT_TBL_INDEX);
2717 PUT_LINE ('INITIAL_READING_FLAG :'||p_counter_readings_tbl(tab_row).INITIAL_READING_FLAG);
2718
2719 END IF;
2720 END LOOP;
2721 END IF;
2722 EXCEPTION
2723 WHEN OTHERS THEN
2724 ROLLBACK TO dump_counter_readings_tbl;
2725 IF FND_MSG_PUB.Check_Msg_Level
2726 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2727 THEN
2728 FND_MSG_PUB.Add_Exc_Msg
2729 (g_pkg_name,
2730 l_api_name);
2731 END IF;
2732 END dump_counter_readings_tbl;
2733
2734 PROCEDURE dump_ctr_property_readings_rec
2735 (p_ctr_property_readings_rec IN csi_ctr_datastructures_pub.ctr_property_readings_rec) IS
2736 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_property_readings_rec';
2737 l_api_version CONSTANT NUMBER := 1.0;
2738 BEGIN
2739 SAVEPOINT dump_ctr_property_readings_rec;
2740
2741 -- Read the debug profiles values in to global variable 7197402
2742 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2743
2744 PUT_LINE (' ');
2745 PUT_LINE ('Dumping the values for Counter Property Readings Record:');
2746 PUT_LINE (' ');
2747
2748 PUT_LINE ('COUNTER_PROP_VALUE_ID :'||p_ctr_property_readings_rec.COUNTER_PROP_VALUE_ID);
2749 PUT_LINE ('COUNTER_VALUE_ID :'||p_ctr_property_readings_rec.COUNTER_VALUE_ID);
2750 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_property_readings_rec.COUNTER_PROPERTY_ID);
2751 PUT_LINE ('PROPERTY_VALUE :'||p_ctr_property_readings_rec.PROPERTY_VALUE);
2752 PUT_LINE ('VALUE_TIMESTAMP :'||p_ctr_property_readings_rec.VALUE_TIMESTAMP);
2753 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_property_readings_rec.OBJECT_VERSION_NUMBER);
2754 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_property_readings_rec.ATTRIBUTE1);
2755 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_property_readings_rec.ATTRIBUTE2);
2756 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_property_readings_rec.ATTRIBUTE3);
2757 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_property_readings_rec.ATTRIBUTE4);
2758 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_property_readings_rec.ATTRIBUTE5);
2759 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_property_readings_rec.ATTRIBUTE6);
2760 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_property_readings_rec.ATTRIBUTE7);
2761 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_property_readings_rec.ATTRIBUTE8);
2762 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_property_readings_rec.ATTRIBUTE9);
2763 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_property_readings_rec.ATTRIBUTE10);
2764 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_property_readings_rec.ATTRIBUTE11);
2765 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_property_readings_rec.ATTRIBUTE12);
2766 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_property_readings_rec.ATTRIBUTE13);
2767 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_property_readings_rec.ATTRIBUTE14);
2768 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_property_readings_rec.ATTRIBUTE15);
2769 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_property_readings_rec.ATTRIBUTE_CATEGORY);
2770 PUT_LINE ('SECURITY_GROUP_ID :'||p_ctr_property_readings_rec.SECURITY_GROUP_ID);
2771 PUT_LINE ('PARENT_TBL_INDEX :'||p_ctr_property_readings_rec.PARENT_TBL_INDEX);
2772
2773
2774 EXCEPTION
2775 WHEN OTHERS THEN
2776 ROLLBACK TO dump_ctr_property_readings_rec;
2777 IF FND_MSG_PUB.Check_Msg_Level
2778 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2779 THEN
2780 FND_MSG_PUB.Add_Exc_Msg
2781 (g_pkg_name,
2782 l_api_name);
2783 END IF;
2784 END dump_ctr_property_readings_rec;
2785
2786 PROCEDURE dump_ctr_property_readings_tbl
2787 (p_ctr_property_readings_tbl IN csi_ctr_datastructures_pub.ctr_property_readings_tbl) IS
2788 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_property_readings_tbl';
2789 l_api_version CONSTANT NUMBER := 1.0;
2790
2791 BEGIN
2792 SAVEPOINT dump_ctr_property_readings_tbl;
2793
2794 -- Read the debug profiles values in to global variable 7197402
2795 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2796
2797 IF p_ctr_property_readings_tbl.COUNT > 0 THEN
2798 FOR tab_row IN p_ctr_property_readings_tbl.FIRST .. p_ctr_property_readings_tbl.LAST
2799 LOOP
2800 IF p_ctr_property_readings_tbl.EXISTS(tab_row) THEN
2801
2802 PUT_LINE (' ');
2803 PUT_LINE ('Dumping the values for Counter Property Readings Table Record # : '||tab_row);
2804 PUT_LINE (' ');
2805
2806 PUT_LINE ('COUNTER_PROP_VALUE_ID :'||p_ctr_property_readings_tbl(tab_row).COUNTER_PROP_VALUE_ID);
2807 PUT_LINE ('COUNTER_VALUE_ID :'||p_ctr_property_readings_tbl(tab_row).COUNTER_VALUE_ID);
2808 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_property_readings_tbl(tab_row).COUNTER_PROPERTY_ID);
2809 PUT_LINE ('PROPERTY_VALUE :'||p_ctr_property_readings_tbl(tab_row).PROPERTY_VALUE);
2810 PUT_LINE ('VALUE_TIMESTAMP :'||p_ctr_property_readings_tbl(tab_row).VALUE_TIMESTAMP);
2811 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_property_readings_tbl(tab_row).OBJECT_VERSION_NUMBER);
2812 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE1);
2813 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE2);
2814 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE3);
2815 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE4);
2816 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE5);
2817 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE6);
2818 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE7);
2819 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE8);
2820 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE9);
2821 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE10);
2822 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE11);
2823 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE12);
2824 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE13);
2825 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE14);
2826 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE15);
2827 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_property_readings_tbl(tab_row).ATTRIBUTE_CATEGORY);
2828 PUT_LINE ('PARENT_TBL_INDEX :'||p_ctr_property_readings_tbl(tab_row).PARENT_TBL_INDEX);
2829
2830 END IF;
2831 END LOOP;
2832 END IF;
2833 EXCEPTION
2834 WHEN OTHERS THEN
2835 ROLLBACK TO dump_ctr_property_readings_tbl;
2836 IF FND_MSG_PUB.Check_Msg_Level
2837 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2838 THEN
2839 FND_MSG_PUB.Add_Exc_Msg
2840 (g_pkg_name,
2841 l_api_name);
2842 END IF;
2843 END dump_ctr_property_readings_tbl;
2844
2845 PROCEDURE dump_ctr_usage_forecast_rec
2846 (p_ctr_usage_forecast_rec IN csi_ctr_datastructures_pub.ctr_usage_forecast_rec) IS
2847 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_usage_forecast_rec';
2848 l_api_version CONSTANT NUMBER := 1.0;
2849 BEGIN
2850 SAVEPOINT dump_ctr_usage_forecast_rec;
2851
2852 -- Read the debug profiles values in to global variable 7197402
2853 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2854
2855 PUT_LINE (' ');
2856 PUT_LINE ('Dumping the values for Counter Usage Forecast Record:');
2857 PUT_LINE (' ');
2858
2859 PUT_LINE ('INSTANCE_FORECAST_ID :'||p_ctr_usage_forecast_rec.INSTANCE_FORECAST_ID);
2860 PUT_LINE ('COUNTER_ID :'||p_ctr_usage_forecast_rec.COUNTER_ID);
2861 PUT_LINE ('USAGE_RATE :'||p_ctr_usage_forecast_rec.USAGE_RATE);
2862 PUT_LINE ('USE_PAST_READING :'||p_ctr_usage_forecast_rec.USE_PAST_READING);
2863 PUT_LINE ('ACTIVE_START_DATE :'||p_ctr_usage_forecast_rec.ACTIVE_START_DATE);
2864 PUT_LINE ('ACTIVE_END_DATE :'||p_ctr_usage_forecast_rec.ACTIVE_END_DATE);
2865 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_usage_forecast_rec.OBJECT_VERSION_NUMBER);
2866 EXCEPTION
2867 WHEN OTHERS THEN
2868 ROLLBACK TO dump_ctr_usage_forecast_rec;
2869 IF FND_MSG_PUB.Check_Msg_Level
2870 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2871 THEN
2872 FND_MSG_PUB.Add_Exc_Msg
2873 (g_pkg_name,
2874 l_api_name);
2875 END IF;
2876 END dump_ctr_usage_forecast_rec;
2877
2878 PROCEDURE dump_ctr_usage_forecast_tbl
2879 (p_ctr_usage_forecast_tbl IN csi_ctr_datastructures_pub.ctr_usage_forecast_tbl) IS
2880 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_usage_forecast_tbl';
2881 l_api_version CONSTANT NUMBER := 1.0;
2882
2883 BEGIN
2884 SAVEPOINT dump_ctr_usage_forecast_tbl;
2885
2886 -- Read the debug profiles values in to global variable 7197402
2887 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2888
2889 IF p_ctr_usage_forecast_tbl.COUNT > 0 THEN
2890 FOR tab_row IN p_ctr_usage_forecast_tbl.FIRST .. p_ctr_usage_forecast_tbl.LAST
2891 LOOP
2892 IF p_ctr_usage_forecast_tbl.EXISTS(tab_row) THEN
2893
2894 PUT_LINE (' ');
2895 PUT_LINE ('Dumping the values for Counter Usage Forecast Table Record # : '||tab_row);
2896 PUT_LINE (' ');
2897
2898 PUT_LINE ('INSTANCE_FORECAST_ID :'||p_ctr_usage_forecast_tbl(tab_row).INSTANCE_FORECAST_ID);
2899 PUT_LINE ('COUNTER_ID :'||p_ctr_usage_forecast_tbl(tab_row).COUNTER_ID);
2900 PUT_LINE ('USAGE_RATE :'||p_ctr_usage_forecast_tbl(tab_row).USAGE_RATE);
2901 PUT_LINE ('USE_PAST_READING :'||p_ctr_usage_forecast_tbl(tab_row).USE_PAST_READING);
2902 PUT_LINE ('ACTIVE_START_DATE :'||p_ctr_usage_forecast_tbl(tab_row).ACTIVE_START_DATE);
2903 PUT_LINE ('ACTIVE_END_DATE :'||p_ctr_usage_forecast_tbl(tab_row).ACTIVE_END_DATE);
2904 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_usage_forecast_tbl(tab_row).OBJECT_VERSION_NUMBER);
2905
2906 END IF;
2907 END LOOP;
2908 END IF;
2909 EXCEPTION
2910 WHEN OTHERS THEN
2911 ROLLBACK TO dump_ctr_usage_forecast_tbl;
2912 IF FND_MSG_PUB.Check_Msg_Level
2913 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2914 THEN
2915 FND_MSG_PUB.Add_Exc_Msg
2916 (g_pkg_name,
2917 l_api_name);
2918 END IF;
2919 END dump_ctr_usage_forecast_tbl;
2920
2921 PROCEDURE dump_ctr_reading_lock_rec
2922 (p_ctr_reading_lock_rec IN csi_ctr_datastructures_pub.ctr_reading_lock_rec) IS
2923 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_reading_lock_rec';
2924 l_api_version CONSTANT NUMBER := 1.0;
2925
2926 BEGIN
2927 SAVEPOINT dump_ctr_reading_lock_rec;
2928
2929 -- Read the debug profiles values in to global variable 7197402
2930 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2931
2932 PUT_LINE (' ');
2933 PUT_LINE ('Dumping the values for Counter Reading Lock Record:');
2934 PUT_LINE (' ');
2935
2936 PUT_LINE ('READING_LOCK_ID :'||p_ctr_reading_lock_rec.READING_LOCK_ID);
2937 PUT_LINE ('READING_LOCK_DATE :'||p_ctr_reading_lock_rec.READING_LOCK_DATE);
2938 PUT_LINE ('ACTIVE_START_DATE :'||p_ctr_reading_lock_rec.ACTIVE_START_DATE);
2939 PUT_LINE ('ACTIVE_END_DATE :'||p_ctr_reading_lock_rec.ACTIVE_END_DATE);
2940 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_reading_lock_rec.OBJECT_VERSION_NUMBER);
2941 EXCEPTION
2942 WHEN OTHERS THEN
2943 ROLLBACK TO dump_ctr_reading_lock_rec;
2944 IF FND_MSG_PUB.Check_Msg_Level
2945 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2946 THEN
2947 FND_MSG_PUB.Add_Exc_Msg
2948 (g_pkg_name,
2949 l_api_name);
2950 END IF;
2951 END dump_ctr_reading_lock_rec;
2952
2953 PROCEDURE dump_ctr_reading_lock_tbl
2954 (p_ctr_reading_lock_tbl IN csi_ctr_datastructures_pub.ctr_reading_lock_tbl) IS
2955 l_api_name CONSTANT VARCHAR2(30) := 'dump_ctr_reading_lock_tbl';
2956 l_api_version CONSTANT NUMBER := 1.0;
2957
2958 BEGIN
2959 SAVEPOINT dump_ctr_reading_lock_tbl;
2960
2961 -- Read the debug profiles values in to global variable 7197402
2962 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2963
2964 IF p_ctr_reading_lock_tbl.COUNT > 0 THEN
2965 FOR tab_row IN p_ctr_reading_lock_tbl.FIRST .. p_ctr_reading_lock_tbl.LAST
2966 LOOP
2967 IF p_ctr_reading_lock_tbl.EXISTS(tab_row) THEN
2968
2969 PUT_LINE (' ');
2970 PUT_LINE ('Dumping the values for Counter Reading Lock Table Record # : '||tab_row);
2971 PUT_LINE (' ');
2972
2973 PUT_LINE ('READING_LOCK_ID :'||p_ctr_reading_lock_tbl(tab_row).READING_LOCK_ID);
2974 PUT_LINE ('READING_LOCK_DATE :'||p_ctr_reading_lock_tbl(tab_row).READING_LOCK_DATE);
2975 PUT_LINE ('ACTIVE_START_DATE :'||p_ctr_reading_lock_tbl(tab_row).ACTIVE_START_DATE);
2976 PUT_LINE ('ACTIVE_END_DATE :'||p_ctr_reading_lock_tbl(tab_row).ACTIVE_END_DATE);
2977 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_reading_lock_tbl(tab_row).OBJECT_VERSION_NUMBER);
2978
2979 END IF;
2980 END LOOP;
2981 END IF;
2982 EXCEPTION
2983 WHEN OTHERS THEN
2984 ROLLBACK TO dump_ctr_reading_lock_tbl;
2985 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2986 THEN
2987 FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);
2988 END IF;
2989 END dump_ctr_reading_lock_tbl;
2990
2991 PROCEDURE dm_ctr_estimated_readings_rec
2992 (p_ctr_estimated_readings_rec IN csi_ctr_datastructures_pub.ctr_estimated_readings_rec) IS
2993 l_api_name CONSTANT VARCHAR2(30) := 'dm_ctr_estimated_readings_rec';
2994 l_api_version CONSTANT NUMBER := 1.0;
2995 BEGIN
2996 SAVEPOINT dm_ctr_estimated_readings_rec;
2997
2998 -- Read the debug profiles values in to global variable 7197402
2999 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3000
3001 PUT_LINE (' ');
3002 PUT_LINE ('Dumping the values for Counter Estimated Readings Record:');
3003 PUT_LINE (' ');
3004
3005 PUT_LINE ('ESTIMATED_READING_ID :'||p_ctr_estimated_readings_rec.ESTIMATED_READING_ID);
3006 PUT_LINE ('COUNTER_ID :'||p_ctr_estimated_readings_rec.COUNTER_ID);
3007 PUT_LINE ('ESTIMATION_ID :'||p_ctr_estimated_readings_rec.ESTIMATION_ID);
3008 PUT_LINE ('VALUE_TIMESTAMP :'||p_ctr_estimated_readings_rec.VALUE_TIMESTAMP);
3009 PUT_LINE ('ESTIMATED_METER_READING :'||p_ctr_estimated_readings_rec.ESTIMATED_METER_READING);
3010 PUT_LINE ('NUM_OF_READINGS :'||p_ctr_estimated_readings_rec.NUM_OF_READINGS);
3011 PUT_LINE ('PERIOD_START_DATE :'||p_ctr_estimated_readings_rec.PERIOD_START_DATE);
3012 PUT_LINE ('PERIOD_END_DATE :'||p_ctr_estimated_readings_rec.PERIOD_END_DATE);
3013 PUT_LINE ('AVG_CALCULATION_START_DATE :'||p_ctr_estimated_readings_rec.AVG_CALCULATION_START_DATE);
3014 PUT_LINE ('ESTIMATED_USAGE :'||p_ctr_estimated_readings_rec.ESTIMATED_USAGE);
3015 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_estimated_readings_rec.ATTRIBUTE1);
3016 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_estimated_readings_rec.ATTRIBUTE2);
3017 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_estimated_readings_rec.ATTRIBUTE3);
3018 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_estimated_readings_rec.ATTRIBUTE4);
3019 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_estimated_readings_rec.ATTRIBUTE5);
3020 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_estimated_readings_rec.ATTRIBUTE6);
3021 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_estimated_readings_rec.ATTRIBUTE7);
3022 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_estimated_readings_rec.ATTRIBUTE8);
3023 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_estimated_readings_rec.ATTRIBUTE9);
3024 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_estimated_readings_rec.ATTRIBUTE10);
3025 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_estimated_readings_rec.ATTRIBUTE11);
3026 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_estimated_readings_rec.ATTRIBUTE12);
3027 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_estimated_readings_rec.ATTRIBUTE13);
3028 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_estimated_readings_rec.ATTRIBUTE14);
3029 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_estimated_readings_rec.ATTRIBUTE15);
3030 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_estimated_readings_rec.ATTRIBUTE_CATEGORY);
3031 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_estimated_readings_rec.OBJECT_VERSION_NUMBER);
3032 EXCEPTION
3033 WHEN OTHERS THEN
3034 ROLLBACK TO dm_ctr_estimated_readings_rec;
3035 IF FND_MSG_PUB.Check_Msg_Level
3036 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3037 THEN
3038 FND_MSG_PUB.Add_Exc_Msg
3039 (g_pkg_name,
3040 l_api_name);
3041 END IF;
3042 END dm_ctr_estimated_readings_rec;
3043
3044 PROCEDURE dm_ctr_estimated_readings_tbl
3045 (p_ctr_estimated_readings_tbl IN csi_ctr_datastructures_pub.ctr_estimated_readings_tbl) IS
3046 l_api_name CONSTANT VARCHAR2(30) := 'dm_ctr_estimated_readings_tbl';
3047 l_api_version CONSTANT NUMBER := 1.0;
3048
3049 BEGIN
3050 SAVEPOINT dm_ctr_estimated_readings_tbl;
3051
3052 -- Read the debug profiles values in to global variable 7197402
3053 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3054
3055 IF p_ctr_estimated_readings_tbl.COUNT > 0 THEN
3056 FOR tab_row IN p_ctr_estimated_readings_tbl.FIRST .. p_ctr_estimated_readings_tbl.LAST
3057 LOOP
3058 IF p_ctr_estimated_readings_tbl.EXISTS(tab_row) THEN
3059
3060 PUT_LINE (' ');
3061 PUT_LINE ('Dumping the values for Counter Estimated Readings Table Record # : '||tab_row);
3062 PUT_LINE (' ');
3063
3064 PUT_LINE ('ESTIMATED_READING_ID :'||p_ctr_estimated_readings_tbl(tab_row).ESTIMATED_READING_ID);
3065 PUT_LINE ('COUNTER_ID :'||p_ctr_estimated_readings_tbl(tab_row).COUNTER_ID);
3066 PUT_LINE ('ESTIMATION_ID :'||p_ctr_estimated_readings_tbl(tab_row).ESTIMATION_ID);
3067 PUT_LINE ('VALUE_TIMESTAMP :'||p_ctr_estimated_readings_tbl(tab_row).VALUE_TIMESTAMP);
3068 PUT_LINE ('ESTIMATED_METER_READING :'||p_ctr_estimated_readings_tbl(tab_row).ESTIMATED_METER_READING);
3069 PUT_LINE ('NUM_OF_READINGS :'||p_ctr_estimated_readings_tbl(tab_row).NUM_OF_READINGS);
3070 PUT_LINE ('PERIOD_START_DATE :'||p_ctr_estimated_readings_tbl(tab_row).PERIOD_START_DATE);
3071 PUT_LINE ('PERIOD_END_DATE :'||p_ctr_estimated_readings_tbl(tab_row).PERIOD_END_DATE);
3072 PUT_LINE ('AVG_CALCULATION_START_DATE :'||p_ctr_estimated_readings_tbl(tab_row).AVG_CALCULATION_START_DATE);
3073 PUT_LINE ('ESTIMATED_USAGE :'||p_ctr_estimated_readings_tbl(tab_row).ESTIMATED_USAGE);
3074 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE1);
3075 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE2);
3076 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE3);
3077 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE4);
3078 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE5);
3079 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE6);
3080 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE7);
3081 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE8);
3082 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE9);
3083 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE10);
3084 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE11);
3085 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE12);
3086 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE13);
3087 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE14);
3088 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE15);
3089 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_estimated_readings_tbl(tab_row).ATTRIBUTE_CATEGORY);
3090 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_estimated_readings_tbl(tab_row).OBJECT_VERSION_NUMBER);
3091
3092 END IF;
3093 END LOOP;
3094 END IF;
3095 EXCEPTION
3096 WHEN OTHERS THEN
3097 ROLLBACK TO dm_ctr_estimated_readings_tbl;
3098 IF FND_MSG_PUB.Check_Msg_Level
3099 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3100 THEN
3101 FND_MSG_PUB.Add_Exc_Msg
3102 (g_pkg_name, l_api_name);
3103 END IF;
3104 END dm_ctr_estimated_readings_tbl;
3105
3106 PROCEDURE dm_ctr_readings_interface_rec
3107 (p_ctr_readings_interface_rec IN csi_ctr_datastructures_pub.ctr_readings_interface_rec) IS
3108 l_api_name CONSTANT VARCHAR2(30) := 'dm_ctr_readings_interface_rec';
3109 l_api_version CONSTANT NUMBER := 1.0;
3110 BEGIN
3111 SAVEPOINT dm_ctr_readings_interface_rec;
3112
3113 -- Read the debug profiles values in to global variable 7197402
3114 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3115
3116 PUT_LINE (' ');
3117 PUT_LINE ('Dumping the values for Counter Readings Open Interface Record:');
3118 PUT_LINE (' ');
3119
3120 PUT_LINE ('COUNTER_INTERFACE_ID :'||p_ctr_readings_interface_rec.COUNTER_INTERFACE_ID);
3121 PUT_LINE ('PARALLEL_WORKER_ID :'||p_ctr_readings_interface_rec.PARALLEL_WORKER_ID);
3122 PUT_LINE ('BATCH_NAME :'||p_ctr_readings_interface_rec.BATCH_NAME);
3123 PUT_LINE ('SOURCE_TRANSACTION_DATE :'||p_ctr_readings_interface_rec.SOURCE_TRANSACTION_DATE);
3124 PUT_LINE ('PROCESS_STATUS :'||p_ctr_readings_interface_rec.PROCESS_STATUS);
3125 PUT_LINE ('ERROR_TEXT :'||p_ctr_readings_interface_rec.ERROR_TEXT);
3126 PUT_LINE ('COUNTER_VALUE_ID :'||p_ctr_readings_interface_rec.COUNTER_VALUE_ID);
3127 PUT_LINE ('COUNTER_ID :'||p_ctr_readings_interface_rec.COUNTER_ID);
3128 PUT_LINE ('VALUE_TIMESTAMP :'||p_ctr_readings_interface_rec.VALUE_TIMESTAMP);
3129 PUT_LINE ('COUNTER_READING :'||p_ctr_readings_interface_rec.COUNTER_READING);
3130 PUT_LINE ('RESET_MODE :'||p_ctr_readings_interface_rec.RESET_MODE);
3131 PUT_LINE ('RESET_REASON :'||p_ctr_readings_interface_rec.RESET_REASON);
3132 PUT_LINE ('ADJUSTMENT_TYPE :'||p_ctr_readings_interface_rec.ADJUSTMENT_TYPE);
3133 PUT_LINE ('ADJUSTMENT_READING :'||p_ctr_readings_interface_rec.ADJUSTMENT_READING);
3134 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_readings_interface_rec.OBJECT_VERSION_NUMBER);
3135 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_readings_interface_rec.ATTRIBUTE1);
3136 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_readings_interface_rec.ATTRIBUTE2);
3137 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_readings_interface_rec.ATTRIBUTE3);
3138 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_readings_interface_rec.ATTRIBUTE4);
3139 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_readings_interface_rec.ATTRIBUTE5);
3140 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_readings_interface_rec.ATTRIBUTE6);
3141 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_readings_interface_rec.ATTRIBUTE7);
3142 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_readings_interface_rec.ATTRIBUTE8);
3143 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_readings_interface_rec.ATTRIBUTE9);
3144 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_readings_interface_rec.ATTRIBUTE10);
3145 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_readings_interface_rec.ATTRIBUTE11);
3146 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_readings_interface_rec.ATTRIBUTE12);
3147 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_readings_interface_rec.ATTRIBUTE13);
3148 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_readings_interface_rec.ATTRIBUTE14);
3149 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_readings_interface_rec.ATTRIBUTE15);
3150 PUT_LINE ('ATTRIBUTE16 :'||p_ctr_readings_interface_rec.ATTRIBUTE16);
3151 PUT_LINE ('ATTRIBUTE17 :'||p_ctr_readings_interface_rec.ATTRIBUTE17);
3152 PUT_LINE ('ATTRIBUTE18 :'||p_ctr_readings_interface_rec.ATTRIBUTE18);
3153 PUT_LINE ('ATTRIBUTE19 :'||p_ctr_readings_interface_rec.ATTRIBUTE19);
3154 PUT_LINE ('ATTRIBUTE20 :'||p_ctr_readings_interface_rec.ATTRIBUTE20);
3155 PUT_LINE ('ATTRIBUTE21 :'||p_ctr_readings_interface_rec.ATTRIBUTE21);
3156 PUT_LINE ('ATTRIBUTE22 :'||p_ctr_readings_interface_rec.ATTRIBUTE22);
3157 PUT_LINE ('ATTRIBUTE23 :'||p_ctr_readings_interface_rec.ATTRIBUTE23);
3158 PUT_LINE ('ATTRIBUTE24 :'||p_ctr_readings_interface_rec.ATTRIBUTE24);
3159 PUT_LINE ('ATTRIBUTE25 :'||p_ctr_readings_interface_rec.ATTRIBUTE25);
3160 PUT_LINE ('ATTRIBUTE26 :'||p_ctr_readings_interface_rec.ATTRIBUTE26);
3161 PUT_LINE ('ATTRIBUTE27 :'||p_ctr_readings_interface_rec.ATTRIBUTE27);
3162 PUT_LINE ('ATTRIBUTE28 :'||p_ctr_readings_interface_rec.ATTRIBUTE28);
3163 PUT_LINE ('ATTRIBUTE29 :'||p_ctr_readings_interface_rec.ATTRIBUTE29);
3164 PUT_LINE ('ATTRIBUTE30 :'||p_ctr_readings_interface_rec.ATTRIBUTE30);
3165 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_readings_interface_rec.ATTRIBUTE_CATEGORY);
3166 PUT_LINE ('COMMENTS :'||p_ctr_readings_interface_rec.COMMENTS);
3167 PUT_LINE ('LIFE_TO_DATE_READING :'||p_ctr_readings_interface_rec.LIFE_TO_DATE_READING);
3168 PUT_LINE ('NET_READING :'||p_ctr_readings_interface_rec.NET_READING);
3169 PUT_LINE ('DISABLED_FLAG :'||p_ctr_readings_interface_rec.DISABLED_FLAG);
3170 PUT_LINE ('SOURCE_CODE :'||p_ctr_readings_interface_rec.SOURCE_CODE);
3171 PUT_LINE ('SOURCE_LINE_ID :'||p_ctr_readings_interface_rec.SOURCE_LINE_ID);
3172 PUT_LINE ('COUNTER_NAME :'||p_ctr_readings_interface_rec.COUNTER_NAME);
3173 PUT_LINE ('INCLUDE_TARGET_RESETS :'||p_ctr_readings_interface_rec.INCLUDE_TARGET_RESETS);
3174 PUT_LINE ('AUTOMATIC_ROLLOVER_FLAG :'||p_ctr_readings_interface_rec.AUTOMATIC_ROLLOVER_FLAG);
3175 PUT_LINE ('SOURCE_COUNTER_VALUE_ID :'||p_ctr_readings_interface_rec.SOURCE_COUNTER_VALUE_ID);
3176 EXCEPTION
3177 WHEN OTHERS THEN
3178 ROLLBACK TO dm_ctr_readings_interface_rec;
3179 IF FND_MSG_PUB.Check_Msg_Level
3180 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3181 THEN
3182 FND_MSG_PUB.Add_Exc_Msg
3183 (g_pkg_name,
3184 l_api_name);
3185 END IF;
3186 END dm_ctr_readings_interface_rec;
3187
3188 PROCEDURE dm_ctr_readings_interface_tbl
3189 (p_ctr_readings_interface_tbl IN csi_ctr_datastructures_pub.ctr_readings_interface_tbl) IS
3190 l_api_name CONSTANT VARCHAR2(30) := 'dm_ctr_readings_interface_tbl';
3191 l_api_version CONSTANT NUMBER := 1.0;
3192
3193 BEGIN
3194 SAVEPOINT dm_ctr_readings_interface_tbl;
3195
3196 -- Read the debug profiles values in to global variable 7197402
3197 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3198
3199 IF p_ctr_readings_interface_tbl.COUNT > 0 THEN
3200 FOR tab_row IN p_ctr_readings_interface_tbl.FIRST .. p_ctr_readings_interface_tbl.LAST
3201 LOOP
3202 IF p_ctr_readings_interface_tbl.EXISTS(tab_row) THEN
3203
3204 PUT_LINE (' ');
3205 PUT_LINE ('Dumping the values for Counter Readings Open Interface Table Record # : '||tab_row);
3206 PUT_LINE (' ');
3207
3208 PUT_LINE ('COUNTER_INTERFACE_ID :'||p_ctr_readings_interface_tbl(tab_row).COUNTER_INTERFACE_ID);
3209 PUT_LINE ('PARALLEL_WORKER_ID :'||p_ctr_readings_interface_tbl(tab_row).PARALLEL_WORKER_ID);
3210 PUT_LINE ('BATCH_NAME :'||p_ctr_readings_interface_tbl(tab_row).BATCH_NAME);
3211 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);
3212 PUT_LINE ('ERROR_TEXT :'||p_ctr_readings_interface_tbl(tab_row).ERROR_TEXT);
3213 PUT_LINE ('COUNTER_VALUE_ID :'||p_ctr_readings_interface_tbl(tab_row).COUNTER_VALUE_ID);
3214 PUT_LINE ('COUNTER_ID :'||p_ctr_readings_interface_tbl(tab_row).COUNTER_ID);
3215 PUT_LINE ('VALUE_TIMESTAMP :'||p_ctr_readings_interface_tbl(tab_row).VALUE_TIMESTAMP);
3216 PUT_LINE ('COUNTER_READING :'||p_ctr_readings_interface_tbl(tab_row).COUNTER_READING);
3217 PUT_LINE ('RESET_MODE :'||p_ctr_readings_interface_tbl(tab_row).RESET_MODE);
3218 PUT_LINE ('RESET_REASON :'||p_ctr_readings_interface_tbl(tab_row).RESET_REASON);
3219 PUT_LINE ('ADJUSTMENT_TYPE :'||p_ctr_readings_interface_tbl(tab_row).ADJUSTMENT_TYPE);
3220 PUT_LINE ('ADJUSTMENT_READING :'||p_ctr_readings_interface_tbl(tab_row).ADJUSTMENT_READING);
3221 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_readings_interface_tbl(tab_row).OBJECT_VERSION_NUMBER);
3222 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE1);
3223 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE2);
3224 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE3);
3225 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE4);
3226 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE5);
3227 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE6);
3228 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE7);
3229 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE8);
3230 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE9);
3231 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE10);
3232 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE11);
3233 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE12);
3234 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE13);
3235 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE14);
3236 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE15);
3237 PUT_LINE ('ATTRIBUTE16 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE16);
3238 PUT_LINE ('ATTRIBUTE17 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE17);
3239 PUT_LINE ('ATTRIBUTE18 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE18);
3240 PUT_LINE ('ATTRIBUTE19 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE19);
3241 PUT_LINE ('ATTRIBUTE20 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE20);
3242 PUT_LINE ('ATTRIBUTE21 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE21);
3243 PUT_LINE ('ATTRIBUTE22 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE22);
3244 PUT_LINE ('ATTRIBUTE23 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE23);
3245 PUT_LINE ('ATTRIBUTE24 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE24);
3246 PUT_LINE ('ATTRIBUTE25 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE25);
3247 PUT_LINE ('ATTRIBUTE26 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE26);
3248 PUT_LINE ('ATTRIBUTE27 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE27);
3249 PUT_LINE ('ATTRIBUTE28 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE28);
3250 PUT_LINE ('ATTRIBUTE29 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE29);
3251 PUT_LINE ('ATTRIBUTE30 :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE30);
3252 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_readings_interface_tbl(tab_row).ATTRIBUTE_CATEGORY);
3253 PUT_LINE ('COMMENTS :'||p_ctr_readings_interface_tbl(tab_row).COMMENTS);
3254 PUT_LINE ('LIFE_TO_DATE_READING :'||p_ctr_readings_interface_tbl(tab_row).LIFE_TO_DATE_READING);
3255 PUT_LINE ('NET_READING :'||p_ctr_readings_interface_tbl(tab_row).NET_READING);
3256 PUT_LINE ('DISABLED_FLAG :'||p_ctr_readings_interface_tbl(tab_row).DISABLED_FLAG);
3257 PUT_LINE ('SOURCE_CODE :'||p_ctr_readings_interface_tbl(tab_row).SOURCE_CODE);
3258 PUT_LINE ('SOURCE_LINE_ID :'||p_ctr_readings_interface_tbl(tab_row).SOURCE_LINE_ID);
3259 PUT_LINE ('COUNTER_NAME :'||p_ctr_readings_interface_tbl(tab_row).COUNTER_NAME);
3260 PUT_LINE ('INCLUDE_TARGET_RESETS :'||p_ctr_readings_interface_tbl(tab_row).INCLUDE_TARGET_RESETS);
3261 PUT_LINE ('AUTOMATIC_ROLLOVER_FLAG :'||p_ctr_readings_interface_tbl(tab_row).AUTOMATIC_ROLLOVER_FLAG);
3262 PUT_LINE ('SOURCE_COUNTER_VALUE_ID :'||p_ctr_readings_interface_tbl(tab_row).SOURCE_COUNTER_VALUE_ID);
3263 END IF;
3264 END LOOP;
3265 END IF;
3266 EXCEPTION
3267 WHEN OTHERS THEN
3268 ROLLBACK TO dm_ctr_readings_interface_tbl;
3269 IF FND_MSG_PUB.Check_Msg_Level
3270 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3271 THEN
3272 FND_MSG_PUB.Add_Exc_Msg
3273 (g_pkg_name, l_api_name);
3274 END IF;
3275 END dm_ctr_readings_interface_tbl;
3276
3277 PROCEDURE dm_ctr_read_prop_interface_rec
3278 (p_ctr_read_prop_interface_rec IN csi_ctr_datastructures_pub.ctr_read_prop_interface_rec) IS
3279 l_api_name CONSTANT VARCHAR2(30) := 'dm_ctr_read_prop_interface_rec';
3280 l_api_version CONSTANT NUMBER := 1.0;
3281 BEGIN
3282 SAVEPOINT dm_ctr_read_prop_interface_rec;
3283
3284 -- Read the debug profiles values in to global variable 7197402
3285 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3286
3287 PUT_LINE (' ');
3288 PUT_LINE ('Dumping the values for Counter Readings Properties Interface Record:');
3289 PUT_LINE (' ');
3290
3291 PUT_LINE ('COUNTER_INTERFACE_ID :'||p_ctr_read_prop_interface_rec.COUNTER_INTERFACE_ID);
3292 PUT_LINE ('PARALLEL_WORKER_ID :'||p_ctr_read_prop_interface_rec.PARALLEL_WORKER_ID);
3293 PUT_LINE ('ERROR_TEXT :'||p_ctr_read_prop_interface_rec.ERROR_TEXT);
3294 PUT_LINE ('COUNTER_PROP_VALUE_ID :'||p_ctr_read_prop_interface_rec.COUNTER_PROP_VALUE_ID);
3295 PUT_LINE ('COUNTER_VALUE_ID :'||p_ctr_read_prop_interface_rec.COUNTER_VALUE_ID);
3296 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_read_prop_interface_rec.COUNTER_PROPERTY_ID);
3297 PUT_LINE ('PROPERTY_VALUE :'||p_ctr_read_prop_interface_rec.PROPERTY_VALUE);
3298 PUT_LINE ('VALUE_TIMESTAMP :'||p_ctr_read_prop_interface_rec.VALUE_TIMESTAMP);
3299 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_read_prop_interface_rec.OBJECT_VERSION_NUMBER);
3300 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE1);
3301 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE2);
3302 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE3);
3303 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE4);
3304 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE5);
3305 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE6);
3306 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE7);
3307 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE8);
3308 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE9);
3309 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE10);
3310 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE11);
3311 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE12);
3312 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE13);
3313 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE14);
3314 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_read_prop_interface_rec.ATTRIBUTE15);
3315 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_read_prop_interface_rec.ATTRIBUTE_CATEGORY);
3316 EXCEPTION
3317 WHEN OTHERS THEN
3318 ROLLBACK TO dm_ctr_read_prop_interface_rec;
3319 IF FND_MSG_PUB.Check_Msg_Level
3320 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3321 THEN
3322 FND_MSG_PUB.Add_Exc_Msg
3323 (g_pkg_name,
3324 l_api_name);
3325 END IF;
3326 END dm_ctr_read_prop_interface_rec;
3327
3328 PROCEDURE dm_ctr_read_prop_interface_tbl
3329 (p_ctr_read_prop_interface_tbl IN csi_ctr_datastructures_pub.ctr_read_prop_interface_tbl) IS
3330 l_api_name CONSTANT VARCHAR2(30) := 'dm_ctr_read_prop_interface_tbl';
3331 l_api_version CONSTANT NUMBER := 1.0;
3332
3333 BEGIN
3334 SAVEPOINT dm_ctr_read_prop_interface_tbl;
3335
3336 -- Read the debug profiles values in to global variable 7197402
3337 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3338
3339 IF p_ctr_read_prop_interface_tbl.COUNT > 0 THEN
3340 FOR tab_row IN p_ctr_read_prop_interface_tbl.FIRST .. p_ctr_read_prop_interface_tbl.LAST
3341 LOOP
3342 IF p_ctr_read_prop_interface_tbl.EXISTS(tab_row) THEN
3343
3344 PUT_LINE (' ');
3345 PUT_LINE ('Dumping the values for Counter Readings Property Interface Table Record # : '||tab_row);
3346 PUT_LINE (' ');
3347
3348 PUT_LINE ('COUNTER_INTERFACE_ID :'||p_ctr_read_prop_interface_tbl(tab_row).COUNTER_INTERFACE_ID);
3349 PUT_LINE ('PARALLEL_WORKER_ID :'||p_ctr_read_prop_interface_tbl(tab_row).PARALLEL_WORKER_ID);
3350 PUT_LINE ('ERROR_TEXT :'||p_ctr_read_prop_interface_tbl(tab_row).ERROR_TEXT);
3351 PUT_LINE ('COUNTER_PROP_VALUE_ID :'||p_ctr_read_prop_interface_tbl(tab_row).COUNTER_PROP_VALUE_ID);
3352 PUT_LINE ('COUNTER_VALUE_ID :'||p_ctr_read_prop_interface_tbl(tab_row).COUNTER_VALUE_ID);
3353 PUT_LINE ('COUNTER_PROPERTY_ID :'||p_ctr_read_prop_interface_tbl(tab_row).COUNTER_PROPERTY_ID);
3354 PUT_LINE ('PROPERTY_VALUE :'||p_ctr_read_prop_interface_tbl(tab_row).PROPERTY_VALUE);
3355 PUT_LINE ('VALUE_TIMESTAMP :'||p_ctr_read_prop_interface_tbl(tab_row).VALUE_TIMESTAMP);
3356 PUT_LINE ('OBJECT_VERSION_NUMBER :'||p_ctr_read_prop_interface_tbl(tab_row).OBJECT_VERSION_NUMBER);
3357 PUT_LINE ('ATTRIBUTE1 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE1);
3358 PUT_LINE ('ATTRIBUTE2 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE2);
3359 PUT_LINE ('ATTRIBUTE3 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE3);
3360 PUT_LINE ('ATTRIBUTE4 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE4);
3361 PUT_LINE ('ATTRIBUTE5 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE5);
3362 PUT_LINE ('ATTRIBUTE6 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE6);
3363 PUT_LINE ('ATTRIBUTE7 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE7);
3364 PUT_LINE ('ATTRIBUTE8 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE8);
3365 PUT_LINE ('ATTRIBUTE9 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE9);
3366 PUT_LINE ('ATTRIBUTE10 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE10);
3367 PUT_LINE ('ATTRIBUTE11 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE11);
3368 PUT_LINE ('ATTRIBUTE12 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE12);
3369 PUT_LINE ('ATTRIBUTE13 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE13);
3370 PUT_LINE ('ATTRIBUTE14 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE14);
3371 PUT_LINE ('ATTRIBUTE15 :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE15);
3372 PUT_LINE ('ATTRIBUTE_CATEGORY :'||p_ctr_read_prop_interface_tbl(tab_row).ATTRIBUTE_CATEGORY);
3373 END IF;
3374 END LOOP;
3375 END IF;
3376 EXCEPTION
3377 WHEN OTHERS THEN
3378 ROLLBACK TO dm_ctr_read_prop_interface_tbl;
3379 IF FND_MSG_PUB.Check_Msg_Level
3380 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3381 THEN
3382 FND_MSG_PUB.Add_Exc_Msg
3383 (g_pkg_name, l_api_name);
3384 END IF;
3385 END dm_ctr_read_prop_interface_tbl;
3386
3387
3388 PROCEDURE dump_txn_rec
3389 (p_txn_rec IN csi_datastructures_pub.transaction_rec) IS
3390
3391 l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_rec';
3392 l_api_version CONSTANT NUMBER := 1.0;
3393 BEGIN
3394 -- Standard Start of API savepoint
3395 -- SAVEPOINT dump_txn_rec;
3396
3397 -- Read the debug profiles values in to global variable 7197402
3398 CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3399
3400 put_line(' ');
3401 put_line('Dumping the values for Transaction Record:');
3402 put_line(' ');
3403 put_line('transaction_id : '|| p_txn_rec.transaction_id );
3404 put_line('transaction_date : '|| p_txn_rec.transaction_date );
3405 put_line('source_transaction_date : '|| p_txn_rec.source_transaction_date );
3406 put_line('transaction_type_id : '|| p_txn_rec.transaction_type_id );
3407 put_line('txn_sub_type_id : '|| p_txn_rec.txn_sub_type_id );
3408 put_line('source_group_ref_id : '|| p_txn_rec.source_group_ref_id );
3409 put_line('source_group_ref : '|| p_txn_rec.source_group_ref );
3410 put_line('source_header_ref_id : '|| p_txn_rec.source_header_ref_id );
3411 put_line('source_header_ref : '|| p_txn_rec.source_header_ref );
3412 put_line('source_line_ref_id : '|| p_txn_rec.source_line_ref_id );
3413 put_line('source_line_ref : '|| p_txn_rec.source_line_ref );
3414 put_line('source_dist_ref_id1 : '|| p_txn_rec.source_dist_ref_id1 );
3415 put_line('source_dist_ref_id2 : '|| p_txn_rec.source_dist_ref_id2 );
3416 put_line('inv_material_transaction_id : '|| p_txn_rec.inv_material_transaction_id );
3417 put_line('transaction_quantity : '|| p_txn_rec.transaction_quantity );
3418 put_line('transaction_uom_code : '|| p_txn_rec.transaction_uom_code );
3419 put_line('transacted_by : '|| p_txn_rec.transacted_by );
3420 put_line('transaction_status_code : '|| p_txn_rec.transaction_status_code );
3421 put_line('transaction_action_code : '|| p_txn_rec.transaction_action_code );
3422 put_line('message_id : '|| p_txn_rec.message_id );
3423 put_line('context : '|| p_txn_rec.context );
3424 put_line('attribute1 : '|| p_txn_rec.attribute1 );
3425 put_line('attribute2 : '|| p_txn_rec.attribute2 );
3426 put_line('attribute3 : '|| p_txn_rec.attribute3 );
3427 put_line('attribute4 : '|| p_txn_rec.attribute4 );
3428 put_line('attribute5 : '|| p_txn_rec.attribute5 );
3429 put_line('attribute6 : '|| p_txn_rec.attribute6 );
3430 put_line('attribute7 : '|| p_txn_rec.attribute7 );
3431 put_line('attribute8 : '|| p_txn_rec.attribute8 );
3432 put_line('attribute9 : '|| p_txn_rec.attribute9 );
3433 put_line('attribute10 : '|| p_txn_rec.attribute10 );
3434 put_line('attribute11 : '|| p_txn_rec.attribute11 );
3435 put_line('attribute12 : '|| p_txn_rec.attribute12 );
3436 put_line('attribute13 : '|| p_txn_rec.attribute13 );
3437 put_line('attribute14 : '|| p_txn_rec.attribute14 );
3438 put_line('attribute15 : '|| p_txn_rec.attribute15 );
3439 put_line('object_version_number : '|| p_txn_rec.object_version_number);
3440 put_line('split_reason_code : '|| p_txn_rec.split_reason_code);
3441 EXCEPTION
3442 WHEN OTHERS THEN
3443 -- ROLLBACK TO dump_txn_rec;
3444
3445 IF FND_MSG_PUB.Check_Msg_Level
3446 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3447 THEN
3448 FND_MSG_PUB.Add_Exc_Msg
3449 ( G_PKG_NAME ,
3450 l_api_name
3451 );
3452 END IF;
3453 END dump_txn_rec;
3454
3455 PROCEDURE dump_txn_tbl
3456 (p_txn_tbl IN csi_datastructures_pub.transaction_tbl) IS
3457 l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_tbl';
3458 l_api_version CONSTANT NUMBER := 1.0;
3459 BEGIN
3460 -- Standard Start of API savepoint
3461 SAVEPOINT dump_txn_tbl;
3462 IF p_txn_tbl.COUNT > 0 THEN
3463 FOR tab_row IN p_txn_tbl.FIRST .. p_txn_tbl.LAST
3464 LOOP
3465 IF p_txn_tbl.EXISTS(tab_row) THEN
3466 dump_txn_rec(p_txn_rec => p_txn_tbl(tab_row));
3467 END IF;
3468 END LOOP;
3469 END IF;
3470 EXCEPTION
3471 WHEN OTHERS THEN
3472 ROLLBACK TO dump_txn_tbl;
3473 IF FND_MSG_PUB.Check_Msg_Level
3474 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3475 THEN
3476 FND_MSG_PUB.Add_Exc_Msg
3477 ( G_PKG_NAME ,
3478 l_api_name
3479 );
3480 END IF;
3481 END dump_txn_tbl;
3482 END;