[Home] [Help]
PACKAGE BODY: APPS.CSI_GEN_UTILITY_PVT
Source
4 PROCEDURE read_debug_profiles IS
1 PACKAGE BODY CSI_GEN_UTILITY_PVT AS
2 /* $Header: csivgub.pls 120.13.12020000.3 2012/09/06 04:49:43 jrkumar ship $ */
3
5 BEGIN
6 g_debug_level := fnd_profile.value('CSI_DEBUG_LEVEL');
7 g_debug_file := fnd_profile.value('CSI_LOGFILE_NAME');
8 g_debug_file_path := fnd_profile.value('CSI_LOGFILE_PATH');
9 END read_debug_profiles;
10
11 PROCEDURE put_line(p_message IN VARCHAR2)
12 IS
13 l_message VARCHAR2(4000);
14
15 l_sid NUMBER;
16 l_serial number;
17 l_audsid number;
18 l_user varchar2(30);
19 l_schema varchar2(30);
20 l_os_user VARCHAR2(30);
21 l_logon_time date;
22 l_module varchar2(48);
23
24 l_file_handle utl_file.file_type;
25
26 BEGIN
27
28 IF g_debug_level is null THEN
29 read_debug_profiles;
30 END IF;
31
32 IF g_debug_level > 0 THEN
33 IF g_audsid is NULL THEN
34
35 SELECT sid, serial#, audsid, username, schemaname, osuser, logon_time, module
36 INTO l_sid, l_serial, l_audsid, l_user, l_schema, l_os_user, l_logon_time, l_module
37 FROM v$session
38 WHERE audsid = (SELECT userenv('SESSIONID') FROM sys.dual);
39
40 --
41 g_audsid := l_audsid;
42
43 l_message := '***-new sql session'||l_audsid||'-'||l_sid||'-'||l_serial||'-'||l_user||'-'||l_schema||'-'||
44 l_os_user||l_module||'-'||to_char(l_logon_time, 'DD-MON-YYYY HH24:MI:SS')||'-***';
45 l_file_handle := UTL_FILE.FOPEN(g_debug_file_path, g_debug_file, 'a');
46 UTL_FILE.PUT_LINE (l_file_handle, l_message);
47 END IF;
48
49 l_message := g_audsid||'-'||to_char(sysdate, 'ddmmyyyy hh24:mi:ss')||'-'||p_message;
50 l_file_handle := UTL_FILE.FOPEN(g_debug_file_path, g_debug_file, 'a');
51 UTL_FILE.PUT_LINE (l_file_handle, l_message);
52 UTL_FILE.FFLUSH(l_file_handle);
53 UTL_FILE.FCLOSE(l_file_handle);
54 END IF;
55
56 EXCEPTION
57 WHEN OTHERS THEN
58 null;
59 END put_line;
60
61
62 FUNCTION enable_trace (l_trace_flag IN VARCHAR2)
63 RETURN VARCHAR2
64 is
65 event_on BINARY_INTEGER;
66 event_num BINARY_INTEGER := 10046; -- Trace event
67 l_flag VARCHAR2(1):=l_trace_flag;
68 begin
69 /***** srramakr Commented for Bug 3304439
70 DBMS_SYSTEM.READ_EV(event_num,event_on);
71 IF event_on <> 1 THEN
72 IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
73 dbms_session.set_sql_trace(TRUE);
74 l_flag:='Y';
75 Else
76 l_flag:='N';
77 END IF;
78 ELSE
79 l_flag:='N';
80 END IF;
81 *****/
82 l_flag := 'N';
83 RETURN l_flag;
84 END enable_trace;
85
86 FUNCTION dump_error_stack RETURN varchar2
87 IS
88 l_msg_count number;
89 l_msg_data varchar2(2000);
90 l_msg_index_out number;
91 x_msg_data varchar2(4000);
92 BEGIN
93
94 x_msg_data := null;
95
96 fnd_msg_pub.count_and_get(
97 p_count => l_msg_count,
98 p_data => l_msg_data);
99
100 FOR l_ind IN 1..l_msg_count
101 LOOP
102
103 fnd_msg_pub.get(
104 p_msg_index => l_ind,
105 p_encoded => fnd_api.g_false,
106 p_data => l_msg_data,
107 p_msg_index_out => l_msg_index_out);
108
109 x_msg_data := ltrim(x_msg_data||' '||l_msg_data);
110
111 IF length(x_msg_data) > 1999 THEN
112 x_msg_data := substr(x_msg_data, 1, 1999);
113 exit;
114 END IF;
115
116 END LOOP;
117
118 RETURN x_msg_data;
119
120 EXCEPTION
121 WHEN others THEN
122 RETURN null;
123 END dump_error_stack;
124
125 PROCEDURE dump_ext_attrib_values_rec
126 (p_ext_attrib_values_rec IN csi_datastructures_pub.extend_attrib_values_rec)
127 IS
128 l_api_name CONSTANT VARCHAR2(30) := 'dump_ext_attrib_values_rec';
129 l_api_version CONSTANT NUMBER := 1.0;
130 BEGIN
131
132 -- Standard Start of API savepoint
133 -- SAVEPOINT dump_ext_attrib_values_rec;
134
135 PUT_LINE (' ');
136 PUT_LINE ('Dumping the values for Extended Attribs Record:');
137 PUT_LINE (' ');
138 PUT_LINE ('attribute_value_id :'||p_ext_attrib_values_rec.attribute_value_id);
139 PUT_LINE ('instance_id :'||p_ext_attrib_values_rec.instance_id);
140 PUT_LINE ('attribute_id :'||p_ext_attrib_values_rec.attribute_id);
141 PUT_LINE ('attribute_value :'||p_ext_attrib_values_rec.attribute_value);
142 PUT_LINE ('active_start_date :'||p_ext_attrib_values_rec.active_start_date);
143 PUT_LINE ('active_end_date :'||p_ext_attrib_values_rec.active_end_date);
144 PUT_LINE ('context :'||p_ext_attrib_values_rec.context);
145 PUT_LINE ('attribute1 :'||p_ext_attrib_values_rec.attribute1);
146 PUT_LINE ('attribute2 :'||p_ext_attrib_values_rec.attribute2);
147 PUT_LINE ('attribute3 :'||p_ext_attrib_values_rec.attribute3);
148 PUT_LINE ('attribute4 :'||p_ext_attrib_values_rec.attribute4);
152 PUT_LINE ('attribute8 :'||p_ext_attrib_values_rec.attribute8);
149 PUT_LINE ('attribute5 :'||p_ext_attrib_values_rec.attribute5);
150 PUT_LINE ('attribute6 :'||p_ext_attrib_values_rec.attribute6);
151 PUT_LINE ('attribute7 :'||p_ext_attrib_values_rec.attribute7);
153 PUT_LINE ('attribute9 :'||p_ext_attrib_values_rec.attribute9);
154 PUT_LINE ('attribute10 :'||p_ext_attrib_values_rec.attribute10);
155 PUT_LINE ('attribute11 :'||p_ext_attrib_values_rec.attribute11);
156 PUT_LINE ('attribute12 :'||p_ext_attrib_values_rec.attribute12);
157 PUT_LINE ('attribute13 :'||p_ext_attrib_values_rec.attribute13);
158 PUT_LINE ('attribute14 :'||p_ext_attrib_values_rec.attribute14);
159 PUT_LINE ('attribute15 :'||p_ext_attrib_values_rec.attribute15);
160 PUT_LINE ('object_version_number :'||p_ext_attrib_values_rec.object_version_number);
161
162
163 EXCEPTION
164 WHEN OTHERS THEN
165 -- ROLLBACK TO dump_ext_attrib_values_rec;
166
167 IF FND_MSG_PUB.Check_Msg_Level
168 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
169 THEN
170 FND_MSG_PUB.Add_Exc_Msg
171 ( g_pkg_name ,
172 l_api_name
173 );
174 END IF;
175
176 END dump_ext_attrib_values_rec;
177
178
179 PROCEDURE dump_ext_attrib_values_tbl
180 (p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl)
181 IS
182 l_api_name CONSTANT VARCHAR2(30) := 'dump_ext_attrib_values_tbl';
183 l_api_version CONSTANT NUMBER := 1.0;
184 BEGIN
185
186 -- Standard Start of API savepoint
187 -- SAVEPOINT dump_ext_attrib_values_tbl;
188
189 IF p_ext_attrib_values_tbl.COUNT > 0 THEN
190 FOR tab_row IN p_ext_attrib_values_tbl.FIRST .. p_ext_attrib_values_tbl.LAST
191 LOOP
192 IF p_ext_attrib_values_tbl.EXISTS(tab_row) THEN
193
194 PUT_LINE (' ');
195 PUT_LINE ('Dumping the values for Extended Attribs Table Record # :'||tab_row);
196 PUT_LINE (' ');
197 PUT_LINE ('attribute_value_id :'||p_ext_attrib_values_tbl(tab_row).attribute_value_id);
198 PUT_LINE ('instance_id :'||p_ext_attrib_values_tbl(tab_row).instance_id);
199 PUT_LINE ('attribute_id :'||p_ext_attrib_values_tbl(tab_row).attribute_id);
200 PUT_LINE ('attribute_value :'||p_ext_attrib_values_tbl(tab_row).attribute_value);
201 PUT_LINE ('active_start_date :'||p_ext_attrib_values_tbl(tab_row).active_start_date);
202 PUT_LINE ('active_end_date :'||p_ext_attrib_values_tbl(tab_row).active_end_date);
203 PUT_LINE ('context :'||p_ext_attrib_values_tbl(tab_row).context);
204 PUT_LINE ('attribute1 :'||p_ext_attrib_values_tbl(tab_row).attribute1);
205 PUT_LINE ('attribute2 :'||p_ext_attrib_values_tbl(tab_row).attribute2);
206 PUT_LINE ('attribute3 :'||p_ext_attrib_values_tbl(tab_row).attribute3);
207 PUT_LINE ('attribute4 :'||p_ext_attrib_values_tbl(tab_row).attribute4);
208 PUT_LINE ('attribute5 :'||p_ext_attrib_values_tbl(tab_row).attribute5);
209 PUT_LINE ('attribute6 :'||p_ext_attrib_values_tbl(tab_row).attribute6);
210 PUT_LINE ('attribute7 :'||p_ext_attrib_values_tbl(tab_row).attribute7);
211 PUT_LINE ('attribute8 :'||p_ext_attrib_values_tbl(tab_row).attribute8);
212 PUT_LINE ('attribute9 :'||p_ext_attrib_values_tbl(tab_row).attribute9);
213 PUT_LINE ('attribute10 :'||p_ext_attrib_values_tbl(tab_row).attribute10);
214 PUT_LINE ('attribute11 :'||p_ext_attrib_values_tbl(tab_row).attribute11);
215 PUT_LINE ('attribute12 :'||p_ext_attrib_values_tbl(tab_row).attribute12);
216 PUT_LINE ('attribute13 :'||p_ext_attrib_values_tbl(tab_row).attribute13);
217 PUT_LINE ('attribute14 :'||p_ext_attrib_values_tbl(tab_row).attribute14);
218 PUT_LINE ('attribute15 :'||p_ext_attrib_values_tbl(tab_row).attribute15);
219 PUT_LINE ('object_version_number :'||p_ext_attrib_values_tbl(tab_row).object_version_number);
220 END IF;
221 END LOOP;
222 END IF;
223
224 EXCEPTION
225 WHEN OTHERS THEN
226 -- ROLLBACK TO dump_ext_attrib_values_tbl;
227
228 IF FND_MSG_PUB.Check_Msg_Level
229 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
230 THEN
231 FND_MSG_PUB.Add_Exc_Msg
232 ( g_pkg_name ,
233 l_api_name
234 );
235 END IF;
236
237 END dump_ext_attrib_values_tbl;
238
239
240
241 PROCEDURE dump_ext_attrib_query_rec
242 (p_ext_attrib_query_rec IN csi_datastructures_pub.extend_attrib_query_rec)
243 IS
244 l_api_name CONSTANT VARCHAR2(30) := 'dump_ou_query_rec';
245 l_api_version CONSTANT NUMBER := 1.0;
246 BEGIN
247
248 -- Standard Start of API savepoint
249 -- SAVEPOINT dump_ext_attrib_query_rec;
250
251 PUT_LINE (' ');
252 PUT_LINE ('Dumping the values for Extended Attribs Query Record:');
253 PUT_LINE (' ');
254 PUT_LINE ('attribute_value_id :'||p_ext_attrib_query_rec.attribute_value_id);
255 PUT_LINE ('instance_id :'||p_ext_attrib_query_rec.instance_id);
256 PUT_LINE ('attribute_id :'||p_ext_attrib_query_rec.attribute_id);
257
258 EXCEPTION
259 WHEN OTHERS THEN
263 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
260 -- ROLLBACK TO dump_ext_attrib_query_rec;
261
262 IF FND_MSG_PUB.Check_Msg_Level
264 THEN
265 FND_MSG_PUB.Add_Exc_Msg
266 ( g_pkg_name ,
267 l_api_name
268 );
269 END IF;
270 END dump_ext_attrib_query_rec;
271
272
273 PROCEDURE dump_ou_query_rec
274 (p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec)
275 IS
276 l_api_name CONSTANT VARCHAR2(30) := 'dump_ou_query_rec';
277 l_api_version CONSTANT NUMBER := 1.0;
278 BEGIN
279
280 -- Standard Start of API savepoint
281 -- SAVEPOINT dump_ou_qurey_rec;
282
283 PUT_LINE (' ');
284 PUT_LINE ('Dumping the values for Org. Assignments Query Record:');
285 PUT_LINE (' ');
286 PUT_LINE ('instance_ou_id :'||p_ou_query_rec.instance_ou_id);
287 PUT_LINE ('instance_id :'||p_ou_query_rec.instance_id);
288 PUT_LINE ('operating_unit_id :'||p_ou_query_rec.operating_unit_id);
289 PUT_LINE ('relationship_type_code :'||p_ou_query_rec.relationship_type_code);
290
291 EXCEPTION
292 WHEN OTHERS THEN
293 -- ROLLBACK TO dump_ou_qurey_rec;
294
295 IF FND_MSG_PUB.Check_Msg_Level
296 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
297 THEN
298 FND_MSG_PUB.Add_Exc_Msg
299 ( g_pkg_name ,
300 l_api_name
301 );
302 END IF;
303
304 END dump_ou_query_rec;
305
306 PROCEDURE dump_instance_rec
307 (p_instance_rec IN csi_datastructures_pub.instance_rec)
308 IS
309 l_api_name CONSTANT VARCHAR2(30) := 'dump_instance_rec';
310 l_api_version CONSTANT NUMBER := 1.0;
311 BEGIN
312
313 -- Standard Start of API savepoint
314 --SAVEPOINT dump_instance_rec;
315
316 PUT_LINE (' ');
317 PUT_LINE ('Dumping the values for Instance Record:');
318 PUT_LINE (' ');
319 PUT_LINE ('instance_id :'||p_instance_rec.instance_id);
320 PUT_LINE ('instance_number :'||p_instance_rec.instance_number);
321 PUT_LINE ('external_reference :'||p_instance_rec.external_reference);
322 PUT_LINE ('inventory_item_id :'||p_instance_rec.inventory_item_id);
323 PUT_LINE ('vld_organization_id :'||p_instance_rec.vld_organization_id);
324 PUT_LINE ('inventory_revision :'||p_instance_rec.inventory_revision);
325 PUT_LINE ('inv_master_organization_id :'||p_instance_rec.inv_master_organization_id);
326 PUT_LINE ('serial_number :'||p_instance_rec.serial_number);
327 PUT_LINE ('mfg_serial_number_flag :'||p_instance_rec.mfg_serial_number_flag);
328 PUT_LINE ('lot_number :'||p_instance_rec.lot_number);
329 PUT_LINE ('quantity :'||p_instance_rec.quantity);
330 PUT_LINE ('unit_of_measure :'||p_instance_rec.unit_of_measure);
331 PUT_LINE ('accounting_class_code :'||p_instance_rec.accounting_class_code );
332 PUT_LINE ('instance_condition_id :'||p_instance_rec.instance_condition_id);
333 PUT_LINE ('instance_status_id :'||p_instance_rec.instance_status_id);
334 PUT_LINE ('customer_view_flag :'||p_instance_rec.customer_view_flag);
335 PUT_LINE ('merchant_view_flag :'||p_instance_rec.merchant_view_flag);
336 PUT_LINE ('sellable_flag :'||p_instance_rec.sellable_flag);
337 PUT_LINE ('system_id :'||p_instance_rec.system_id);
338 PUT_LINE ('instance_type_code :'||p_instance_rec.instance_type_code );
339 PUT_LINE ('active_start_date :'||p_instance_rec.active_start_date);
340 PUT_LINE ('active_end_date :'||p_instance_rec.active_end_date);
341 PUT_LINE ('location_type_code :'||p_instance_rec.location_type_code );
342 PUT_LINE ('location_id :'||p_instance_rec.location_id );
343 PUT_LINE ('inv_organization_id :'||p_instance_rec.inv_organization_id);
344 PUT_LINE ('inv_subinventory_name :'||p_instance_rec.inv_subinventory_name);
345 PUT_LINE ('inv_locator_id :'||p_instance_rec.inv_locator_id);
346 PUT_LINE ('pa_project_id :'||p_instance_rec.pa_project_id);
347 PUT_LINE ('pa_project_task_id :'||p_instance_rec.pa_project_task_id );
348 PUT_LINE ('in_transit_order_line_id :'||p_instance_rec.in_transit_order_line_id);
349 PUT_LINE ('wip_job_id :'||p_instance_rec.wip_job_id);
350 PUT_LINE ('po_order_line_id :'||p_instance_rec.po_order_line_id);
351 PUT_LINE ('last_oe_order_line_id :'||p_instance_rec.last_oe_order_line_id );
352 PUT_LINE ('last_oe_rma_line_id :'||p_instance_rec.last_oe_rma_line_id);
353 PUT_LINE ('last_po_po_line_id :'||p_instance_rec.last_po_po_line_id);
354 PUT_LINE ('last_oe_po_number :'||p_instance_rec.last_oe_po_number);
355 PUT_LINE ('last_wip_job_id :'||p_instance_rec.last_wip_job_id );
356 PUT_LINE ('last_pa_project_id :'||p_instance_rec.last_pa_project_id);
357 PUT_LINE ('last_pa_task_id :'||p_instance_rec.last_pa_task_id);
358 PUT_LINE ('last_oe_agreement_id :'||p_instance_rec.last_oe_agreement_id);
359 PUT_LINE ('install_date :'||p_instance_rec.install_date);
360 PUT_LINE ('manually_created_flag :'||p_instance_rec.manually_created_flag);
361 PUT_LINE ('return_by_date :'||p_instance_rec.return_by_date);
362 PUT_LINE ('actual_return_date :'||p_instance_rec.actual_return_date);
363 PUT_LINE ('creation_complete_flag :'||p_instance_rec.creation_complete_flag);
367 PUT_LINE ('context :'||p_instance_rec.context );
364 PUT_LINE ('completeness_flag :'||p_instance_rec.completeness_flag);
365 PUT_LINE ('version_label :'||p_instance_rec.version_label);
366 PUT_LINE ('version_label_description :'||p_instance_rec.version_label_description);
368 PUT_LINE ('attribute1 :'||p_instance_rec.attribute1);
369 PUT_LINE ('attribute2 :'||p_instance_rec.attribute2);
370 PUT_LINE ('attribute3 :'||p_instance_rec.attribute3);
371 PUT_LINE ('attribute4 :'||p_instance_rec.attribute4);
372 PUT_LINE ('attribute5 :'||p_instance_rec.attribute5);
373 PUT_LINE ('attribute6 :'||p_instance_rec.attribute6);
374 PUT_LINE ('attribute7 :'||p_instance_rec.attribute7);
375 PUT_LINE ('attribute8 :'||p_instance_rec.attribute8);
376 PUT_LINE ('attribute9 :'||p_instance_rec.attribute9);
377 PUT_LINE ('attribute10 :'||p_instance_rec.attribute10);
378 PUT_LINE ('attribute11 :'||p_instance_rec.attribute11);
379 PUT_LINE ('attribute12 :'||p_instance_rec.attribute12);
380 PUT_LINE ('attribute13 :'||p_instance_rec.attribute13);
381 PUT_LINE ('attribute14 :'||p_instance_rec.attribute14);
382 PUT_LINE ('attribute15 :'||p_instance_rec.attribute15);
383 PUT_LINE ('attribute16 :'||p_instance_rec.attribute16);
384 PUT_LINE ('attribute17 :'||p_instance_rec.attribute17);
385 PUT_LINE ('attribute18 :'||p_instance_rec.attribute18);
386 PUT_LINE ('attribute19 :'||p_instance_rec.attribute19);
387 PUT_LINE ('attribute20 :'||p_instance_rec.attribute20);
388 PUT_LINE ('attribute21 :'||p_instance_rec.attribute21);
389 PUT_LINE ('attribute22 :'||p_instance_rec.attribute22);
390 PUT_LINE ('attribute23 :'||p_instance_rec.attribute23);
391 PUT_LINE ('attribute24 :'||p_instance_rec.attribute24);
392 PUT_LINE ('attribute25 :'||p_instance_rec.attribute25);
393 PUT_LINE ('attribute26 :'||p_instance_rec.attribute26);
394 PUT_LINE ('attribute27 :'||p_instance_rec.attribute27);
395 PUT_LINE ('attribute28 :'||p_instance_rec.attribute28);
396 PUT_LINE ('attribute29 :'||p_instance_rec.attribute29);
397 PUT_LINE ('attribute30 :'||p_instance_rec.attribute30);
398 PUT_LINE ('object_version_number :'||p_instance_rec.object_version_number);
399 PUT_LINE ('last_txn_line_detail_id :'||p_instance_rec.last_txn_line_detail_id);
400 PUT_LINE ('install_location_type_code :'||p_instance_rec.install_location_type_code);
401 PUT_LINE ('install_location_id :'||p_instance_rec.install_location_id);
402 PUT_LINE ('instance_usage_code :'||p_instance_rec.instance_usage_code);
403 PUT_LINE ('config_inst_hdr_id :'||p_instance_rec.config_inst_hdr_id);
404 PUT_LINE ('config_inst_rev_num :'||p_instance_rec.config_inst_rev_num);
405 PUT_LINE ('config_inst_item_id :'||p_instance_rec.config_inst_item_id);
406 PUT_LINE ('config_valid_status :'||p_instance_rec.config_valid_status);
407 PUT_LINE ('instance_description :'||p_instance_rec.instance_description);
408 PUT_LINE ('call_contracts :'||p_instance_rec.call_contracts);
409 PUT_LINE ('network_asset_flag :'||p_instance_rec.network_asset_flag);
410 PUT_LINE ('maintainable_flag :'||p_instance_rec.maintainable_flag);
411 PUT_LINE ('pn_location_id :'||p_instance_rec.pn_location_id);
412 PUT_LINE ('asset_criticality_code :'||p_instance_rec.asset_criticality_code);
413 PUT_LINE ('category_id :'||p_instance_rec.category_id);
414 PUT_LINE ('equipment_gen_object_id :'||p_instance_rec.equipment_gen_object_id);
415 PUT_LINE ('instantiation_flag :'||p_instance_rec.instantiation_flag);
416 PUT_LINE ('linear_location_id :'||p_instance_rec.linear_location_id);
417 PUT_LINE ('operational_log_flag :'||p_instance_rec.operational_log_flag);
418 PUT_LINE ('checkin_status :'||p_instance_rec.checkin_status);
419 PUT_LINE ('supplier_warranty_exp_date :'||p_instance_rec.supplier_warranty_exp_date);
420 PUT_LINE ('purchase_unit_price :'||p_instance_rec.purchase_unit_price);
421 PUT_LINE ('purchase_currency_code :'||p_instance_rec.purchase_currency_code);
422 PUT_LINE ('payables_unit_price :'||p_instance_rec.payables_unit_price);
423 PUT_LINE ('payables_currency_code :'||p_instance_rec.payables_currency_code);
424 PUT_LINE ('sales_unit_price :'||p_instance_rec.sales_unit_price);
425 PUT_LINE ('sales_currency_code :'||p_instance_rec.sales_currency_code);
426 PUT_LINE ('operational_status_code :'||p_instance_rec.operational_status_code);
427 EXCEPTION
428 WHEN OTHERS THEN
429 -- ROLLBACK TO dump_instance_rec;
430
431 IF FND_MSG_PUB.Check_Msg_Level
432 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
433 THEN
434 FND_MSG_PUB.Add_Exc_Msg
435 ( g_pkg_name ,
436 l_api_name
437 );
438 END IF;
439
440 END dump_instance_rec;
441
442
443 PROCEDURE dump_instance_query_rec
444 (p_instance_query_rec IN csi_datastructures_pub.instance_query_rec)
445 IS
446 l_api_name CONSTANT VARCHAR2(30) := 'dump_instance_query_rec';
447 l_api_version CONSTANT NUMBER := 1.0;
448 BEGIN
449
450 -- Standard Start of API savepoint
451 -- SAVEPOINT dump_instance_query_rec;
452
453 PUT_LINE (' ');
454 PUT_LINE ('Dumping the values for Instance Query Record ');
455 PUT_LINE (' ');
459 PUT_LINE ('inv_master_organization_id :'||p_instance_query_rec.inv_master_organization_id);
456 PUT_LINE ('instance_id :'||p_instance_query_rec.instance_id );
457 PUT_LINE ('inventory_item_id :'||p_instance_query_rec.inventory_item_id);
458 PUT_LINE ('inventory_revision :'||p_instance_query_rec.inventory_revision);
460 PUT_LINE ('serial_number :'||p_instance_query_rec.serial_number);
461 PUT_LINE ('lot_number :'||p_instance_query_rec.lot_number);
462 PUT_LINE ('unit_of_measure :'||p_instance_query_rec.unit_of_measure);
463 PUT_LINE ('instance_condition_id :'||p_instance_query_rec.instance_condition_id);
464 PUT_LINE ('instance_status_id :'||p_instance_query_rec.instance_status_id);
465 PUT_LINE ('system_id :'||p_instance_query_rec.system_id);
466 PUT_LINE ('instance_type_code :'||p_instance_query_rec.instance_type_code );
467 PUT_LINE ('location_type_code :'||p_instance_query_rec.location_type_code );
468 PUT_LINE ('location_id :'||p_instance_query_rec.location_id );
469 PUT_LINE ('inv_organization_id :'||p_instance_query_rec.inv_organization_id);
470 PUT_LINE ('inv_subinventory_name :'||p_instance_query_rec.inv_subinventory_name);
471 PUT_LINE ('inv_locator_id :'||p_instance_query_rec.inv_locator_id);
472 PUT_LINE ('pa_project_id :'||p_instance_query_rec.pa_project_id);
473 PUT_LINE ('pa_project_task_id :'||p_instance_query_rec.pa_project_task_id );
474 PUT_LINE ('in_transit_order_line_id :'||p_instance_query_rec.in_transit_order_line_id);
475 PUT_LINE ('wip_job_id :'||p_instance_query_rec.wip_job_id);
476 PUT_LINE ('po_order_line_id :'||p_instance_query_rec.po_order_line_id);
477 PUT_LINE ('last_oe_order_line_id :'||p_instance_query_rec.last_oe_order_line_id );
478 PUT_LINE ('last_oe_rma_line_id :'||p_instance_query_rec.last_oe_rma_line_id);
479 PUT_LINE ('last_po_po_line_id :'||p_instance_query_rec.last_po_po_line_id);
480 PUT_LINE ('last_oe_po_number :'||p_instance_query_rec.last_oe_po_number);
481 PUT_LINE ('last_wip_job_id :'||p_instance_query_rec.last_wip_job_id );
482 PUT_LINE ('last_pa_project_id :'||p_instance_query_rec.last_pa_project_id);
483 PUT_LINE ('last_pa_task_id :'||p_instance_query_rec.last_pa_task_id);
484 PUT_LINE ('last_oe_agreement_id :'||p_instance_query_rec.last_oe_agreement_id);
485 PUT_LINE ('install_date :'||p_instance_query_rec.install_date);
486 PUT_LINE ('manually_created_flag :'||p_instance_query_rec.manually_created_flag);
487 PUT_LINE ('return_by_date :'||p_instance_query_rec.return_by_date);
488 PUT_LINE ('actual_return_date :'||p_instance_query_rec.actual_return_date);
489 PUT_LINE ('instance_usage_code :'||p_instance_query_rec.instance_usage_code);
490 PUT_LINE ('config_inst_hdr_id :'||p_instance_query_rec.config_inst_hdr_id);
491 PUT_LINE ('config_inst_rev_num :'||p_instance_query_rec.config_inst_rev_num);
492 PUT_LINE ('config_inst_item_id :'||p_instance_query_rec.config_inst_item_id);
493 PUT_LINE ('instance_description :'||p_instance_query_rec.instance_description);
494 PUT_LINE ('operational_status_code :'||p_instance_query_rec.operational_status_code);
495 EXCEPTION
496 WHEN OTHERS THEN
497 -- ROLLBACK TO dump_instance_query_rec;
498
499 IF FND_MSG_PUB.Check_Msg_Level
500 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
501 THEN
502 FND_MSG_PUB.Add_Exc_Msg
503 ( g_pkg_name ,
504 l_api_name
505 );
506 END IF;
507
508 END dump_instance_query_rec;
509
510
511 PROCEDURE dump_instance_header_rec
512 (p_instance_header_rec IN csi_datastructures_pub.instance_header_rec)
513 IS
514 l_api_name CONSTANT VARCHAR2(30) := 'dump_instance_header_rec';
515 l_api_version CONSTANT NUMBER := 1.0;
516 BEGIN
517
518 -- Standard Start of API savepoint
519 -- SAVEPOINT dump_instance_header_rec;
520
521 PUT_LINE (' ');
522 PUT_LINE ('Dumping the values for Instance Header Record:');
523 PUT_LINE (' ');
524 PUT_LINE ('instance_id :'||p_instance_header_rec.instance_id );
525 PUT_LINE ('instance_number :'||p_instance_header_rec.instance_number);
526 PUT_LINE ('external_reference :'||p_instance_header_rec.external_reference);
527 --PUT_LINE ('item_description :'||p_instance_header_rec.item_description);
528 PUT_LINE ('inventory_item_id :'||p_instance_header_rec.inventory_item_id);
529 PUT_LINE ('inventory_revision :'||p_instance_header_rec.inventory_revision);
530 PUT_LINE ('inv_master_organization_id :'||p_instance_header_rec.inv_master_organization_id);
531 PUT_LINE ('serial_number :'||p_instance_header_rec.serial_number);
532 PUT_LINE ('mfg_serial_number_flag :'||p_instance_header_rec.mfg_serial_number_flag);
533 PUT_LINE ('lot_number :'||p_instance_header_rec.lot_number);
534 PUT_LINE ('quantity :'||p_instance_header_rec.quantity);
535 --PUT_LINE ('unit_of_measure_name :'||p_instance_header_rec.unit_of_measure_name);
536 PUT_LINE ('unit_of_measure :'||p_instance_header_rec.unit_of_measure);
537 PUT_LINE ('accounting_class :'||p_instance_header_rec.accounting_class);
538 PUT_LINE ('accounting_class_code :'||p_instance_header_rec.accounting_class_code );
539 PUT_LINE ('instance_condition :'||p_instance_header_rec.instance_condition);
540 PUT_LINE ('instance_condition_id :'||p_instance_header_rec.instance_condition_id);
541 PUT_LINE ('instance_status :'||p_instance_header_rec.instance_status);
545 PUT_LINE ('sellable_flag :'||p_instance_header_rec.sellable_flag);
542 PUT_LINE ('instance_status_id :'||p_instance_header_rec.instance_status_id);
543 PUT_LINE ('customer_view_flag :'||p_instance_header_rec.customer_view_flag);
544 PUT_LINE ('merchant_view_flag :'||p_instance_header_rec.merchant_view_flag);
546 PUT_LINE ('system_id :'||p_instance_header_rec.system_id);
547 PUT_LINE ('system_name :'||p_instance_header_rec.system_name);
548 PUT_LINE ('instance_type_code :'||p_instance_header_rec.instance_type_code );
549 PUT_LINE ('instance_type_name :'||p_instance_header_rec.instance_type_name);
550 PUT_LINE ('active_start_date :'||p_instance_header_rec.active_start_date);
551 PUT_LINE ('active_end_date :'||p_instance_header_rec.active_end_date);
552 PUT_LINE ('location_type_code :'||p_instance_header_rec.location_type_code );
553 --PUT_LINE ('location_description :'||p_instance_header_rec.location_description);
554 PUT_LINE ('location_id :'||p_instance_header_rec.location_id );
555 PUT_LINE ('inv_organization_id :'||p_instance_header_rec.inv_organization_id);
556 PUT_LINE ('inv_organization_name :'||p_instance_header_rec.inv_organization_name);
557 --PUT_LINE ('inv_description :'||p_instance_header_rec.inv_description);
558 PUT_LINE ('inv_subinventory_name :'||p_instance_header_rec.inv_subinventory_name);
559 PUT_LINE ('inv_locator_id :'||p_instance_header_rec.inv_locator_id);
560 --PUT_LINE ('pa_task_description :'||p_instance_header_rec.pa_task_description);
561 PUT_LINE ('pa_project_id :'||p_instance_header_rec.pa_project_id);
562 PUT_LINE ('pa_project_task_id :'||p_instance_header_rec.pa_project_task_id );
563 PUT_LINE ('pa_project_name :'||p_instance_header_rec.pa_project_name );
564 PUT_LINE ('pa_project_number :'||p_instance_header_rec.pa_project_number );
565 PUT_LINE ('pa_task_name :'||p_instance_header_rec.pa_task_name );
566 PUT_LINE ('pa_task_number :'||p_instance_header_rec.pa_task_number );
567 --PUT_LINE ('oe_line_item_input :'||p_instance_header_rec.oe_line_item_input);
568 PUT_LINE ('in_transit_order_line_id :'||p_instance_header_rec.in_transit_order_line_id);
569 PUT_LINE ('in_transit_order_line_number:'||p_instance_header_rec.in_transit_order_line_number);
570 PUT_LINE ('in_transit_order_number :'||p_instance_header_rec.in_transit_order_number);
571 PUT_LINE ('wip_entity_name :'||p_instance_header_rec.wip_entity_name);
572 PUT_LINE ('wip_job_id :'||p_instance_header_rec.wip_job_id);
573 --PUT_LINE ('wip_entity_description :'||p_instance_header_rec.wip_entity_description);
574 --PUT_LINE ('po_item_description :'||p_instance_header_rec.po_item_description);
575 PUT_LINE ('po_order_line_id :'||p_instance_header_rec.po_order_line_id);
576 PUT_LINE ('last_oe_order_line_id :'||p_instance_header_rec.last_oe_order_line_id );
577 PUT_LINE ('last_oe_rma_line_id :'||p_instance_header_rec.last_oe_rma_line_id);
578 PUT_LINE ('last_po_po_line_id :'||p_instance_header_rec.last_po_po_line_id);
579 PUT_LINE ('last_oe_po_number :'||p_instance_header_rec.last_oe_po_number);
580 PUT_LINE ('last_wip_job_id :'||p_instance_header_rec.last_wip_job_id );
581 PUT_LINE ('last_pa_project_id :'||p_instance_header_rec.last_pa_project_id);
582 PUT_LINE ('last_pa_task_id :'||p_instance_header_rec.last_pa_task_id);
583 PUT_LINE ('last_oe_agreement_id :'||p_instance_header_rec.last_oe_agreement_id);
584 PUT_LINE ('install_date :'||p_instance_header_rec.install_date);
585 PUT_LINE ('manually_created_flag :'||p_instance_header_rec.manually_created_flag);
586 PUT_LINE ('return_by_date :'||p_instance_header_rec.return_by_date);
587 PUT_LINE ('actual_return_date :'||p_instance_header_rec.actual_return_date);
588 PUT_LINE ('creation_complete_flag :'||p_instance_header_rec.creation_complete_flag);
589 PUT_LINE ('completeness_flag :'||p_instance_header_rec.completeness_flag);
590 PUT_LINE ('context :'||p_instance_header_rec.context );
591 PUT_LINE ('attribute1 :'||p_instance_header_rec.attribute1);
592 PUT_LINE ('attribute2 :'||p_instance_header_rec.attribute2);
593 PUT_LINE ('attribute3 :'||p_instance_header_rec.attribute3);
594 PUT_LINE ('attribute4 :'||p_instance_header_rec.attribute4);
595 PUT_LINE ('attribute5 :'||p_instance_header_rec.attribute5);
596 PUT_LINE ('attribute6 :'||p_instance_header_rec.attribute6);
597 PUT_LINE ('attribute7 :'||p_instance_header_rec.attribute7);
598 PUT_LINE ('attribute8 :'||p_instance_header_rec.attribute8);
599 PUT_LINE ('attribute9 :'||p_instance_header_rec.attribute9);
600 PUT_LINE ('attribute10 :'||p_instance_header_rec.attribute10);
601 PUT_LINE ('attribute11 :'||p_instance_header_rec.attribute11);
602 PUT_LINE ('attribute12 :'||p_instance_header_rec.attribute12);
603 PUT_LINE ('attribute13 :'||p_instance_header_rec.attribute13);
604 PUT_LINE ('attribute14 :'||p_instance_header_rec.attribute14);
605 PUT_LINE ('attribute15 :'||p_instance_header_rec.attribute15);
606 PUT_LINE ('attribute16 :'||p_instance_header_rec.attribute16);
607 PUT_LINE ('attribute17 :'||p_instance_header_rec.attribute17);
608 PUT_LINE ('attribute18 :'||p_instance_header_rec.attribute18);
609 PUT_LINE ('attribute19 :'||p_instance_header_rec.attribute19);
610 PUT_LINE ('attribute20 :'||p_instance_header_rec.attribute20);
611 PUT_LINE ('attribute21 :'||p_instance_header_rec.attribute21);
612 PUT_LINE ('attribute22 :'||p_instance_header_rec.attribute22);
616 PUT_LINE ('attribute26 :'||p_instance_header_rec.attribute26);
613 PUT_LINE ('attribute23 :'||p_instance_header_rec.attribute23);
614 PUT_LINE ('attribute24 :'||p_instance_header_rec.attribute24);
615 PUT_LINE ('attribute25 :'||p_instance_header_rec.attribute25);
617 PUT_LINE ('attribute27 :'||p_instance_header_rec.attribute27);
618 PUT_LINE ('attribute28 :'||p_instance_header_rec.attribute28);
619 PUT_LINE ('attribute29 :'||p_instance_header_rec.attribute29);
620 PUT_LINE ('attribute30 :'||p_instance_header_rec.attribute30);
621 PUT_LINE ('object_version_number :'||p_instance_header_rec.object_version_number);
622 PUT_LINE ('last_txn_line_detail_id :'||p_instance_header_rec.last_txn_line_detail_id);
623 PUT_LINE ('install_location_type_code :'||p_instance_header_rec.install_location_type_code);
624 PUT_LINE ('install_location_id :'||p_instance_header_rec.install_location_id);
625 PUT_LINE ('instance_usage_code :'||p_instance_header_rec.instance_usage_code);
626 PUT_LINE ('current_loc_address1 :'||p_instance_header_rec.current_loc_address1);
627 PUT_LINE ('current_loc_address2 :'||p_instance_header_rec.current_loc_address2);
628 PUT_LINE ('current_loc_address3 :'||p_instance_header_rec.current_loc_address3);
629 PUT_LINE ('current_loc_address4 :'||p_instance_header_rec.current_loc_address4);
630 PUT_LINE ('current_loc_city :'||p_instance_header_rec.current_loc_city);
631 PUT_LINE ('current_loc_state :'||p_instance_header_rec.current_loc_state);
632 PUT_LINE ('current_loc_postal_code :'||p_instance_header_rec.current_loc_postal_code);
633 PUT_LINE ('current_loc_country :'||p_instance_header_rec.current_loc_country);
634 PUT_LINE ('sales_order_number :'||p_instance_header_rec.sales_order_number);
635 PUT_LINE ('sales_order_line_number :'||p_instance_header_rec.sales_order_line_number);
636 PUT_LINE ('sales_order_date :'||p_instance_header_rec.sales_order_date);
637 PUT_LINE ('purchase_order_number :'||p_instance_header_rec.purchase_order_number);
638 PUT_LINE ('instance_usage_name :'||p_instance_header_rec.instance_usage_name);
639 PUT_LINE ('install_loc_address1 :'||p_instance_header_rec.install_loc_address1);
640 PUT_LINE ('install_loc_address2 :'||p_instance_header_rec.install_loc_address2);
641 PUT_LINE ('install_loc_address3 :'||p_instance_header_rec.install_loc_address3);
642 PUT_LINE ('install_loc_address4 :'||p_instance_header_rec.install_loc_address4);
643 PUT_LINE ('install_loc_city :'||p_instance_header_rec.install_loc_city);
644 PUT_LINE ('install_loc_state :'||p_instance_header_rec.install_loc_state);
645 PUT_LINE ('install_loc_postal_code :'||p_instance_header_rec.install_loc_postal_code);
646 PUT_LINE ('install_loc_country :'||p_instance_header_rec.install_loc_country);
647 PUT_LINE ('vld_organization_id :'||p_instance_header_rec.vld_organization_id);
648 PUT_LINE ('current_loc_number :'||p_instance_header_rec.current_loc_number);
649 PUT_LINE ('install_loc_number :'||p_instance_header_rec.install_loc_number);
650 PUT_LINE ('config_inst_hdr_id :'||p_instance_header_rec.config_inst_hdr_id);
651 PUT_LINE ('config_inst_rev_num :'||p_instance_header_rec.config_inst_rev_num);
652 PUT_LINE ('config_inst_item_id :'||p_instance_header_rec.config_inst_item_id);
653 PUT_LINE ('config_valid_status :'||p_instance_header_rec.config_valid_status);
654 PUT_LINE ('instance_description :'||p_instance_header_rec.instance_description);
655 PUT_LINE ('start_loc_address1 :'||p_instance_header_rec.start_loc_address1);
656 PUT_LINE ('start_loc_address2 :'||p_instance_header_rec.start_loc_address2);
657 PUT_LINE ('start_loc_address3 :'||p_instance_header_rec.start_loc_address3);
658 PUT_LINE ('start_loc_address4 :'||p_instance_header_rec.start_loc_address4);
659 PUT_LINE ('start_loc_city :'||p_instance_header_rec.start_loc_city);
660 PUT_LINE ('start_loc_state :'||p_instance_header_rec.start_loc_state);
661 PUT_LINE ('start_loc_postal_code :'||p_instance_header_rec.start_loc_postal_code);
662 PUT_LINE ('start_loc_country :'||p_instance_header_rec.start_loc_country);
663 PUT_LINE ('end_loc_address1 :'||p_instance_header_rec.end_loc_address1);
664 PUT_LINE ('end_loc_address2 :'||p_instance_header_rec.end_loc_address2);
665 PUT_LINE ('end_loc_address3 :'||p_instance_header_rec.end_loc_address3);
666 PUT_LINE ('end_loc_address4 :'||p_instance_header_rec.end_loc_address4);
667 PUT_LINE ('end_loc_city :'||p_instance_header_rec.end_loc_city);
668 PUT_LINE ('end_loc_state :'||p_instance_header_rec.end_loc_state);
669 PUT_LINE ('end_loc_postal_code :'||p_instance_header_rec.end_loc_postal_code);
670 PUT_LINE ('end_loc_country :'||p_instance_header_rec.end_loc_country);
671 PUT_LINE ('network_asset_flag :'||p_instance_header_rec.network_asset_flag);
672 PUT_LINE ('maintainable_flag :'||p_instance_header_rec.maintainable_flag);
673 PUT_LINE ('pn_location_id :'||p_instance_header_rec.pn_location_id);
674 PUT_LINE ('asset_criticality_code :'||p_instance_header_rec.asset_criticality_code);
675 PUT_LINE ('category_id :'||p_instance_header_rec.category_id);
676 PUT_LINE ('equipment_gen_object_id :'||p_instance_header_rec.equipment_gen_object_id);
677 PUT_LINE ('instantiation_flag :'||p_instance_header_rec.instantiation_flag);
678 PUT_LINE ('linear_location_id :'||p_instance_header_rec.linear_location_id);
679 PUT_LINE ('operational_log_flag :'||p_instance_header_rec.operational_log_flag);
680 PUT_LINE ('checkin_status :'||p_instance_header_rec.checkin_status);
681 PUT_LINE ('supplier_warranty_exp_date :'||p_instance_header_rec.supplier_warranty_exp_date);
682 PUT_LINE ('purchase_unit_price :'||p_instance_header_rec.purchase_unit_price);
686 PUT_LINE ('sales_unit_price :'||p_instance_header_rec.sales_unit_price);
683 PUT_LINE ('purchase_currency_code :'||p_instance_header_rec.purchase_currency_code);
684 PUT_LINE ('payables_unit_price :'||p_instance_header_rec.payables_unit_price);
685 PUT_LINE ('payables_currency_code :'||p_instance_header_rec.payables_currency_code);
687 PUT_LINE ('sales_currency_code :'||p_instance_header_rec.sales_currency_code);
688 PUT_LINE ('operational_status_code :'||p_instance_header_rec.operational_status_code);
689 EXCEPTION
690 WHEN OTHERS THEN
691 -- ROLLBACK TO dump_instance_header_rec;
692
693 IF FND_MSG_PUB.Check_Msg_Level
694 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
695 THEN
696 FND_MSG_PUB.Add_Exc_Msg
697 ( g_pkg_name ,
698 l_api_name
699 );
700 END IF;
701
702 END dump_instance_header_rec;
703
704
705
706 PROCEDURE dump_txn_rec
707 (p_txn_rec IN csi_datastructures_pub.transaction_rec)
708 IS
709 l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_rec';
710 l_api_version CONSTANT NUMBER := 1.0;
711 BEGIN
712
713 -- Standard Start of API savepoint
714 -- SAVEPOINT dump_txn_rec;
715
716 put_line(' ');
717 put_line('Dumping the values for Transaction Record:');
718 put_line(' ');
719 put_line('transaction_id : '|| p_txn_rec.transaction_id );
720 put_line('transaction_date : '|| p_txn_rec.transaction_date );
721 put_line('source_transaction_date : '|| p_txn_rec.source_transaction_date );
722 put_line('transaction_type_id : '|| p_txn_rec.transaction_type_id );
723 put_line('txn_sub_type_id : '|| p_txn_rec.txn_sub_type_id );
724 put_line('source_group_ref_id : '|| p_txn_rec.source_group_ref_id );
725 put_line('source_group_ref : '|| p_txn_rec.source_group_ref );
726 put_line('source_header_ref_id : '|| p_txn_rec.source_header_ref_id );
727 put_line('source_header_ref : '|| p_txn_rec.source_header_ref );
728 put_line('source_line_ref_id : '|| p_txn_rec.source_line_ref_id );
729 put_line('source_line_ref : '|| p_txn_rec.source_line_ref );
730 put_line('source_dist_ref_id1 : '|| p_txn_rec.source_dist_ref_id1 );
731 put_line('source_dist_ref_id2 : '|| p_txn_rec.source_dist_ref_id2 );
732 put_line('inv_material_transaction_id : '|| p_txn_rec.inv_material_transaction_id );
733 put_line('transaction_quantity : '|| p_txn_rec.transaction_quantity );
734 put_line('transaction_uom_code : '|| p_txn_rec.transaction_uom_code );
735 put_line('transacted_by : '|| p_txn_rec.transacted_by );
736 put_line('transaction_status_code : '|| p_txn_rec.transaction_status_code );
737 put_line('transaction_action_code : '|| p_txn_rec.transaction_action_code );
738 put_line('message_id : '|| p_txn_rec.message_id );
739 put_line('context : '|| p_txn_rec.context );
740 put_line('attribute1 : '|| p_txn_rec.attribute1 );
741 put_line('attribute2 : '|| p_txn_rec.attribute2 );
742 put_line('attribute3 : '|| p_txn_rec.attribute3 );
743 put_line('attribute4 : '|| p_txn_rec.attribute4 );
744 put_line('attribute5 : '|| p_txn_rec.attribute5 );
745 put_line('attribute6 : '|| p_txn_rec.attribute6 );
746 put_line('attribute7 : '|| p_txn_rec.attribute7 );
747 put_line('attribute8 : '|| p_txn_rec.attribute8 );
748 put_line('attribute9 : '|| p_txn_rec.attribute9 );
749 put_line('attribute10 : '|| p_txn_rec.attribute10 );
750 put_line('attribute11 : '|| p_txn_rec.attribute11 );
751 put_line('attribute12 : '|| p_txn_rec.attribute12 );
752 put_line('attribute13 : '|| p_txn_rec.attribute13 );
753 put_line('attribute14 : '|| p_txn_rec.attribute14 );
754 put_line('attribute15 : '|| p_txn_rec.attribute15 );
755 put_line('object_version_number : '|| p_txn_rec.object_version_number);
756 put_line('split_reason_code : '|| p_txn_rec.split_reason_code);
757 put_line('gl_interface_status_code : '|| p_txn_rec.gl_interface_status_code);
758
759 EXCEPTION
760 WHEN OTHERS THEN
761 -- ROLLBACK TO dump_txn_rec;
762
763 IF FND_MSG_PUB.Check_Msg_Level
764 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
765 THEN
766 FND_MSG_PUB.Add_Exc_Msg
767 ( G_PKG_NAME ,
768 l_api_name
769 );
770 END IF;
771
772 END dump_txn_rec;
773
774 PROCEDURE dump_txn_tbl
775 (p_txn_tbl IN csi_datastructures_pub.transaction_tbl)
776 IS
777 l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_tbl';
778 l_api_version CONSTANT NUMBER := 1.0;
779 BEGIN
780
781 -- Standard Start of API savepoint
782 -- SAVEPOINT dump_txn_tbl;
783 IF p_txn_tbl.COUNT > 0 THEN
784 FOR tab_row IN p_txn_tbl.FIRST .. p_txn_tbl.LAST
785 LOOP
786 IF p_txn_tbl.EXISTS(tab_row) THEN
787 dump_txn_rec(p_txn_rec => p_txn_tbl(tab_row));
788 END IF;
789 END LOOP;
790 END IF;
791
792
793
794 EXCEPTION
795 WHEN OTHERS THEN
796 -- ROLLBACK TO dump_txn_tbl;
797
798 IF FND_MSG_PUB.Check_Msg_Level
799 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
803 l_api_name
800 THEN
801 FND_MSG_PUB.Add_Exc_Msg
802 ( G_PKG_NAME ,
804 );
805 END IF;
806
807 END dump_txn_tbl;
808
809 PROCEDURE dump_txn_query_rec
810 (p_txn_query_rec IN csi_datastructures_pub.transaction_query_rec)
811 IS
812 l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_query_rec';
813 l_api_version CONSTANT NUMBER := 1.0;
814 BEGIN
815
816 -- Standard Start of API savepoint
817 -- SAVEPOINT dump_txn_query_rec;
818
819 put_line(' ');
820 put_line('Dumping the values for Transaction query Record:');
821 put_line(' ');
822 put_line('transaction_id : '|| p_txn_query_rec.transaction_id );
823 put_line('transaction_type_id : '|| p_txn_query_rec.transaction_type_id );
824 put_line('source_group_ref_id : '|| p_txn_query_rec.source_group_ref_id );
825 put_line('source_group_ref : '|| p_txn_query_rec.source_group_ref );
826 put_line('source_header_ref_id : '|| p_txn_query_rec.source_header_ref_id );
827 put_line('source_header_ref : '|| p_txn_query_rec.source_header_ref );
828 put_line('source_line_ref_id : '|| p_txn_query_rec.source_line_ref_id );
829 put_line('source_line_ref : '|| p_txn_query_rec.source_line_ref );
830 put_line('source_transaction_date : '|| p_txn_query_rec.source_transaction_date );
831 put_line('inv_material_transaction_id : '|| p_txn_query_rec.inv_material_transaction_id );
832 put_line('message_id : '|| p_txn_query_rec.message_id );
833 put_line('transaction_start_date : '|| p_txn_query_rec.transaction_start_date );
834 put_line('transaction_end_date : '|| p_txn_query_rec.transaction_end_date );
835 put_line('instance_id : '|| p_txn_query_rec.instance_id );
836 put_line('txn_sub_type_id : '|| p_txn_query_rec.txn_sub_type_id );
837 put_line('transaction_status_code : '|| p_txn_query_rec.transaction_status_code );
838
839
840 EXCEPTION
841 WHEN OTHERS THEN
842 -- ROLLBACK TO dump_txn_query_rec;
843
844 IF FND_MSG_PUB.Check_Msg_Level
845 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
846 THEN
847 FND_MSG_PUB.Add_Exc_Msg
848 ( G_PKG_NAME ,
849 l_api_name
850 );
851 END IF;
852
853 END dump_txn_query_rec;
854
855 PROCEDURE dump_txn_sort_rec
856 (p_txn_sort_rec IN csi_datastructures_pub.transaction_sort_rec)
857 IS
858 l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_query_rec';
859 l_api_version CONSTANT NUMBER := 1.0;
860 BEGIN
861
862 -- Standard Start of API savepoint
863 -- SAVEPOINT dump_txn_sort_rec;
864
865 put_line(' ');
866 put_line('Dumping the values for Transaction sort Record:');
867 put_line(' ');
868 put_line('transaction_date : '||p_txn_sort_rec.transaction_date );
869 put_line('transaction_type_id : '||p_txn_sort_rec.transaction_type_id );
870
871 EXCEPTION
872 WHEN OTHERS THEN
873 -- ROLLBACK TO dump_txn_sort_rec;
874
875 IF FND_MSG_PUB.Check_Msg_Level
876 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
877 THEN
878 FND_MSG_PUB.Add_Exc_Msg
879 ( G_PKG_NAME ,
880 l_api_name
881 );
882 END IF;
883
884 END dump_txn_sort_rec;
885
886 PROCEDURE dump_txn_error_rec
887 (p_txn_error_rec IN csi_datastructures_pub.transaction_error_rec)
888 IS
889 l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_error_rec';
890 l_api_version CONSTANT NUMBER := 1.0;
891 BEGIN
892
893 -- Standard Start of API savepoint
894 -- SAVEPOINT dump_txn_error_rec;
895
896 put_line(' ');
897 put_line('Dumping the values for Transaction Error Record:');
898 put_line(' ');
899 put_line('transaction_error_id : '|| p_txn_error_rec.transaction_error_id );
900 put_line('transaction_id : '|| p_txn_error_rec.transaction_id );
901 put_line('message_id : '|| p_txn_error_rec.message_id );
902 put_line('error_text : '|| p_txn_error_rec.error_text );
903 put_line('source_type : '|| p_txn_error_rec.source_type );
904 put_line('source_id : '|| p_txn_error_rec.source_id );
905 put_line('processed_flag : '|| p_txn_error_rec.processed_flag );
906 put_line('object_version_number : '|| p_txn_error_rec.object_version_number );
907 put_line('transaction_type_id : '|| p_txn_error_rec.transaction_type_id );
908 put_line('source_group_ref : '|| p_txn_error_rec.source_group_ref );
909 put_line('source_group_ref_id : '|| p_txn_error_rec.source_group_ref_id );
910 put_line('source_header_ref : '|| p_txn_error_rec.source_header_ref );
911 put_line('source_header_ref_id : '|| p_txn_error_rec.source_header_ref_id );
912 put_line('source_line_ref : '|| p_txn_error_rec.source_line_ref );
913 put_line('source_line_ref_id : '|| p_txn_error_rec.source_line_ref_id );
914 put_line('source_dist_ref_id1 : '|| p_txn_error_rec.source_dist_ref_id1 );
915 put_line('source_dist_ref_id2 : '|| p_txn_error_rec.source_dist_ref_id2 );
919 EXCEPTION
916 put_line('inv_material_transaction_id : '|| p_txn_error_rec.inv_material_transaction_id );
917 put_line('error_stage : '|| p_txn_error_rec.error_stage );
918 put_line('message_string : '|| p_txn_error_rec.message_string );
920 WHEN OTHERS THEN
921 -- ROLLBACK TO dump_txn_error_rec;
922
923 IF FND_MSG_PUB.Check_Msg_Level
924 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
925 THEN
926 FND_MSG_PUB.Add_Exc_Msg
927 ( G_PKG_NAME ,
928 l_api_name
929 );
930 END IF;
931
932 END dump_txn_error_rec;
933
934 PROCEDURE dump_rel_rec
935 (p_rel_rec IN csi_datastructures_pub.ii_relationship_rec)
936 IS
937 l_api_name CONSTANT VARCHAR2(30) := 'dump_rel_rec';
938 l_api_version CONSTANT NUMBER := 1.0;
939 BEGIN
940
941 -- Standard Start of API savepoint
942 -- SAVEPOINT dump_rel_rec;
943
944 put_line(' ');
945 put_line('Dumping the values for Instance-Instance relationship Record:');
946 put_line(' ');
947 put_line('relationship_id : '|| p_rel_rec.relationship_id );
948 put_line('relationship_type_code : '|| p_rel_rec.relationship_type_code );
949 put_line('object_id : '|| p_rel_rec.object_id );
950 put_line('subject_id : '|| p_rel_rec.subject_id );
951 put_line('subject_has_child : '|| p_rel_rec.subject_has_child ); -- Added for bug 5655955 FP bug 10273728 to give more info
952 put_line('position_reference : '|| p_rel_rec.position_reference );
953 put_line('active_start_date : '|| p_rel_rec.active_start_date );
954 put_line('active_end_date : '|| p_rel_rec.active_end_date );
955 put_line('display_order : '|| p_rel_rec.display_order );
956 put_line('mandatory_flag : '|| p_rel_rec.mandatory_flag );
957 put_line('context : '|| p_rel_rec.context );
958 put_line('attribute1 : '|| p_rel_rec.attribute1 );
959 put_line('attribute2 : '|| p_rel_rec.attribute2 );
960 put_line('attribute3 : '|| p_rel_rec.attribute3 );
961 put_line('attribute4 : '|| p_rel_rec.attribute4 );
962 put_line('attribute5 : '|| p_rel_rec.attribute5 );
963 put_line('attribute6 : '|| p_rel_rec.attribute6 );
964 put_line('attribute7 : '|| p_rel_rec.attribute7 );
965 put_line('attribute8 : '|| p_rel_rec.attribute8 );
966 put_line('attribute9 : '|| p_rel_rec.attribute9 );
967 put_line('attribute10 : '|| p_rel_rec.attribute10 );
968 put_line('attribute11 : '|| p_rel_rec.attribute11 );
969 put_line('attribute12 : '|| p_rel_rec.attribute12 );
970 put_line('attribute13 : '|| p_rel_rec.attribute13 );
971 put_line('attribute14 : '|| p_rel_rec.attribute14 );
972 put_line('attribute15 : '|| p_rel_rec.attribute15 );
973 put_line('object_version_number : '|| p_rel_rec.object_version_number );
974 -- Begin add code for bug 5655955 FP bug 10273728 to give more info
975 put_line('parent_tbl_index : '|| p_rel_rec.parent_tbl_index );
976 put_line('processed_flag : '|| p_rel_rec.processed_flag );
977 put_line('interface_id : '|| p_rel_rec.interface_id );
978 put_line('cascade_ownership_flag : '|| p_rel_rec.cascade_ownership_flag );
979 -- End add code for bug 5655955 FP bug 10273728 to give more info
980
981
982
983
984 EXCEPTION
985 WHEN OTHERS THEN
986 -- ROLLBACK TO dump_rel_rec;
987
988 IF FND_MSG_PUB.Check_Msg_Level
989 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
990 THEN
991 FND_MSG_PUB.Add_Exc_Msg
992 ( G_PKG_NAME ,
993 l_api_name
994 );
995 END IF;
996
997 END dump_rel_rec;
998
999
1000 PROCEDURE dump_rel_tbl
1001 (p_rel_tbl IN csi_datastructures_pub.ii_relationship_tbl)
1002 IS
1003 l_api_name CONSTANT VARCHAR2(30) := 'dump_rel_tbl';
1004 l_api_version CONSTANT NUMBER := 1.0;
1005 BEGIN
1006
1007 -- Standard Start of API savepoint
1008 -- SAVEPOINT dump_rel_tbl;
1009 IF p_rel_tbl.COUNT > 0 THEN
1010 FOR tab_row IN p_rel_tbl.FIRST .. p_rel_tbl.LAST
1011 LOOP
1012 IF p_rel_tbl.EXISTS(tab_row) THEN
1013 dump_rel_rec(p_rel_rec => p_rel_tbl(tab_row));
1014 END IF;
1015 END LOOP;
1016 END IF;
1017
1018
1019
1020 EXCEPTION
1021 WHEN OTHERS THEN
1022 -- ROLLBACK TO dump_rel_tbl;
1023
1024 IF FND_MSG_PUB.Check_Msg_Level
1025 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1026 THEN
1027 FND_MSG_PUB.Add_Exc_Msg
1028 ( G_PKG_NAME ,
1029 l_api_name
1030 );
1031 END IF;
1032
1033 END dump_rel_tbl;
1034
1035 PROCEDURE dump_rel_query_rec
1036 (p_rel_query_rec IN csi_datastructures_pub.relationship_query_rec)
1037 IS
1038 l_api_name CONSTANT VARCHAR2(30) := 'dump_rel_query_rec';
1039 l_api_version CONSTANT NUMBER := 1.0;
1040 BEGIN
1041
1042 -- Standard Start of API savepoint
1043 -- SAVEPOINT dump_rel_query_rec;
1047 put_line(' ');
1044
1045 put_line(' ');
1046 put_line('Dumping the values for Instance-Instance relationship query Record:');
1048 put_line('relationship_id : '|| p_rel_query_rec.relationship_id );
1049 put_line('relationship_type_code : '|| p_rel_query_rec.relationship_type_code );
1050 put_line('object_id : '|| p_rel_query_rec.object_id );
1051 put_line('subject_id : '|| p_rel_query_rec.subject_id );
1052
1053
1054 EXCEPTION
1055 WHEN OTHERS THEN
1056 -- ROLLBACK TO dump_rel_query_rec;
1057
1058 IF FND_MSG_PUB.Check_Msg_Level
1059 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1060 THEN
1061 FND_MSG_PUB.Add_Exc_Msg
1062 ( G_PKG_NAME ,
1063 l_api_name
1064 );
1065 END IF;
1066
1067 END dump_rel_query_rec;
1068
1069 PROCEDURE dump_sys_rec
1070 (P_system_rec IN csi_datastructures_pub.system_rec)
1071 IS
1072 l_api_name CONSTANT VARCHAR2(30) := 'dump_sys_rec';
1073 l_api_version CONSTANT NUMBER := 1.0;
1074 BEGIN
1075
1076 -- Standard Start of API savepoint
1077 -- SAVEPOINT dump_sys_rec;
1078
1079 put_line(' ');
1080 put_line('Dumping the values for System Record:');
1081 put_line(' ');
1082 put_line('system_id : '|| p_system_rec.system_id );
1083 put_line('customer_id : '|| p_system_rec.customer_id );
1084 put_line('system_type_code : '|| p_system_rec.system_type_code );
1085 put_line('system_number : '|| p_system_rec.system_number );
1086 put_line('parent_system_id : '|| p_system_rec.parent_system_id );
1087 put_line('ship_to_contact_id : '|| p_system_rec.ship_to_contact_id );
1088 put_line('bill_to_contact_id : '|| p_system_rec.bill_to_contact_id );
1089 put_line('technical_contact_id : '|| p_system_rec.technical_contact_id );
1090 put_line('service_admin_contact_id : '|| p_system_rec.service_admin_contact_id );
1091 put_line('ship_to_site_use_id : '|| p_system_rec.ship_to_site_use_id );
1092 put_line('bill_to_site_use_id : '|| p_system_rec.bill_to_site_use_id );
1093 put_line('install_site_use_id : '|| p_system_rec.install_site_use_id );
1094 put_line('coterminate_day_month : '|| p_system_rec.coterminate_day_month );
1095 put_line('autocreated_from_system_id : '|| p_system_rec.autocreated_from_system_id );
1096 put_line('config_system_type : '|| p_system_rec.config_system_type );
1097 put_line('start_date_active : '|| p_system_rec.start_date_active );
1098 put_line('end_date_active : '|| p_system_rec.end_date_active );
1099 put_line('context : '|| p_system_rec.context );
1100 put_line('attribute1 : '|| p_system_rec.attribute1 );
1101 put_line('attribute2 : '|| p_system_rec.attribute2 );
1102 put_line('attribute3 : '|| p_system_rec.attribute3 );
1103 put_line('attribute4 : '|| p_system_rec.attribute4 );
1104 put_line('attribute5 : '|| p_system_rec.attribute5 );
1105 put_line('attribute6 : '|| p_system_rec.attribute6 );
1106 put_line('attribute7 : '|| p_system_rec.attribute7 );
1107 put_line('attribute8 : '|| p_system_rec.attribute8 );
1108 put_line('attribute9 : '|| p_system_rec.attribute9 );
1109 put_line('attribute10 : '|| p_system_rec.attribute10 );
1110 put_line('attribute11 : '|| p_system_rec.attribute11 );
1111 put_line('attribute12 : '|| p_system_rec.attribute12 );
1112 put_line('attribute13 : '|| p_system_rec.attribute13 );
1113 put_line('attribute14 : '|| p_system_rec.attribute14 );
1114 put_line('attribute15 : '|| p_system_rec.attribute15 );
1115 put_line('object_version_number : '|| p_system_rec.object_version_number );
1116 put_line('name : '|| p_system_rec.name );
1117 put_line('description : '|| p_system_rec.description );
1118 put_line('tech_cont_change_flag : '|| p_system_rec.tech_cont_change_flag );
1119 put_line('bill_to_cont_change_flag : '|| p_system_rec.bill_to_cont_change_flag );
1120 put_line('ship_to_cont_change_flag : '|| p_system_rec.ship_to_cont_change_flag );
1121 put_line('serv_admin_cont_change_flag : '|| p_system_rec.serv_admin_cont_change_flag );
1122 put_line('bill_to_site_change_flag : '|| p_system_rec.bill_to_site_change_flag );
1123 put_line('ship_to_site_change_flag : '|| p_system_rec.ship_to_site_change_flag );
1124 put_line('install_to_site_change_flag : '|| p_system_rec.install_to_site_change_flag );
1125
1126
1127 EXCEPTION
1128 WHEN OTHERS THEN
1129 -- ROLLBACK TO dump_sys_rec;
1130
1131 IF FND_MSG_PUB.Check_Msg_Level
1132 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1133 THEN
1134 FND_MSG_PUB.Add_Exc_Msg
1135 ( G_PKG_NAME ,
1136 l_api_name
1137 );
1138 END IF;
1139
1140 END dump_sys_rec;
1141
1142
1143
1144 PROCEDURE dump_sys_tbl
1145 (p_systems_tbl IN csi_datastructures_pub.systems_tbl)
1146 IS
1147 l_api_name CONSTANT VARCHAR2(30) := 'dump_sys_tbl';
1148 l_api_version CONSTANT NUMBER := 1.0;
1149 BEGIN
1150
1151 -- Standard Start of API savepoint
1152 -- SAVEPOINT dump_sys_tbl;
1156 IF p_systems_tbl.EXISTS(tab_row) THEN
1153 IF p_systems_tbl.COUNT > 0 THEN
1154 FOR tab_row IN p_systems_tbl.FIRST .. p_systems_tbl.LAST
1155 LOOP
1157 dump_sys_rec(p_system_rec => p_systems_tbl(tab_row));
1158 END IF;
1159 END LOOP;
1160 END IF;
1161
1162
1163
1164 EXCEPTION
1165 WHEN OTHERS THEN
1166 -- ROLLBACK TO dump_sys_tbl;
1167
1168 IF FND_MSG_PUB.Check_Msg_Level
1169 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1170 THEN
1171 FND_MSG_PUB.Add_Exc_Msg
1172 ( G_PKG_NAME ,
1173 l_api_name
1174 );
1175 END IF;
1176
1177 END dump_sys_tbl;
1178
1179
1180 PROCEDURE dump_sys_query_rec
1181 (p_system_query_rec IN csi_datastructures_pub.system_query_rec)
1182 IS
1183 l_api_name CONSTANT VARCHAR2(30) := 'dump_sys_query_rec';
1184 l_api_version CONSTANT NUMBER := 1.0;
1185 BEGIN
1186
1187 -- Standard Start of API savepoint
1188 -- SAVEPOINT dump_sys_query_rec;
1189
1190 put_line(' ');
1191 put_line('Dumping the values for System query Record:');
1192 put_line(' ');
1193 put_line('system_id : '|| p_system_query_rec.system_id );
1194 put_line('system_type_code : '|| p_system_query_rec.system_type_code );
1195 put_line('system_number : '|| p_system_query_rec.system_number );
1196
1197
1198
1199 EXCEPTION
1200 WHEN OTHERS THEN
1201 -- ROLLBACK TO dump_sys_query_rec;
1202
1203 IF FND_MSG_PUB.Check_Msg_Level
1204 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1205 THEN
1206 FND_MSG_PUB.Add_Exc_Msg
1207 ( G_PKG_NAME ,
1208 l_api_name
1209 );
1210 END IF;
1211
1212 END dump_sys_query_rec;
1213
1214 PROCEDURE dump_ext_attrib_rec
1215 (p_ext_attrib_rec IN csi_datastructures_pub.ext_attrib_rec)
1216 IS
1217 l_api_name CONSTANT VARCHAR2(30) := 'dump_ext_attrib_rec';
1218 l_api_version CONSTANT NUMBER := 1.0;
1219 BEGIN
1220
1221 -- Standard Start of API savepoint
1222 -- SAVEPOINT dump_ext_attrib_pvt;
1223
1224 put_line(' ');
1225 put_line('Dumping the values for Extended attribs Record:');
1226 put_line(' ');
1227 put_line('attribute_id : '|| p_ext_attrib_rec.attribute_id );
1228 put_line('attribute_level : '|| p_ext_attrib_rec.attribute_level );
1229 put_line('master_organization_id : '|| p_ext_attrib_rec.master_organization_id );
1230 put_line('inventory_item_id : '|| p_ext_attrib_rec.inventory_item_id );
1231 put_line('item_category_id : '|| p_ext_attrib_rec.item_category_id );
1232 put_line('instance_id : '|| p_ext_attrib_rec.instance_id );
1233 put_line('attribute_code : '|| p_ext_attrib_rec.attribute_code );
1234 put_line('attribute_name : '|| p_ext_attrib_rec.attribute_name );
1235 put_line('attribute_category : '|| p_ext_attrib_rec.attribute_category );
1236 put_line('description : '|| p_ext_attrib_rec.description );
1237 put_line('active_start_date : '|| p_ext_attrib_rec.active_start_date );
1238 put_line('active_end_date : '|| p_ext_attrib_rec.active_end_date );
1239 put_line('context : '|| p_ext_attrib_rec.context );
1240 put_line('attribute1 : '|| p_ext_attrib_rec.attribute1 );
1241 put_line('attribute2 : '|| p_ext_attrib_rec.attribute2 );
1242 put_line('attribute3 : '|| p_ext_attrib_rec.attribute3 );
1243 put_line('attribute4 : '|| p_ext_attrib_rec.attribute4 );
1244 put_line('attribute5 : '|| p_ext_attrib_rec.attribute5 );
1245 put_line('attribute6 : '|| p_ext_attrib_rec.attribute6 );
1246 put_line('attribute7 : '|| p_ext_attrib_rec.attribute7 );
1247 put_line('attribute8 : '|| p_ext_attrib_rec.attribute8 );
1248 put_line('attribute9 : '|| p_ext_attrib_rec.attribute9 );
1249 put_line('attribute10 : '|| p_ext_attrib_rec.attribute10 );
1250 put_line('attribute11 : '|| p_ext_attrib_rec.attribute11 );
1251 put_line('attribute12 : '|| p_ext_attrib_rec.attribute12 );
1252 put_line('attribute13 : '|| p_ext_attrib_rec.attribute13 );
1253 put_line('attribute14 : '|| p_ext_attrib_rec.attribute14 );
1254 put_line('attribute15 : '|| p_ext_attrib_rec.attribute15 );
1255 put_line('object_version_number : '|| p_ext_attrib_rec.object_version_number );
1256
1257 EXCEPTION
1258 WHEN OTHERS THEN
1259 -- ROLLBACK TO dump_ext_attrib_pvt;
1260 IF FND_MSG_PUB.Check_Msg_Level
1261 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1262 THEN
1263 FND_MSG_PUB.Add_Exc_Msg
1264 ( G_PKG_NAME ,
1265 l_api_name
1266 );
1267 END IF;
1268 END dump_ext_attrib_rec;
1269
1270
1271 PROCEDURE dump_inst_party_id
1272 (p_instance_party_id_lst IN csi_datastructures_pub.id_tbl
1273 ) IS
1274 l_api_name CONSTANT VARCHAR2(30) := 'dump_inst_party_id';
1278 -- Standard Start of API savepoint
1275 l_api_version CONSTANT NUMBER := 1.0;
1276
1277 BEGIN
1279 -- SAVEPOINT dump_inst_party_id;
1280
1281 FOR i IN p_instance_party_id_lst.FIRST..p_instance_party_id_lst.LAST LOOP
1282
1283 PUT_LINE ('Instance Party id :'||p_instance_party_id_lst(i));
1284 END LOOP;
1285
1286 EXCEPTION
1287 WHEN OTHERS THEN
1288 -- ROLLBACK TO dump_inst_party_id;
1289 IF FND_MSG_PUB.Check_Msg_Level
1290 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1291 THEN
1292 FND_MSG_PUB.Add_Exc_Msg
1293 ( g_pkg_name ,
1294 l_api_name );
1295 END IF;
1296 END dump_inst_party_id ;
1297
1298
1299 PROCEDURE dump_instance_asset_rec
1300 ( p_instance_asset_rec IN csi_datastructures_pub.instance_asset_rec
1301 ) IS
1302 l_api_name CONSTANT VARCHAR2(30) := 'dump_instance_asset_rec';
1303 l_api_version CONSTANT NUMBER := 1.0;
1304 BEGIN
1305
1306 -- Standard Start of API savepoint
1307 -- SAVEPOINT dump_instance_asset_rec;
1308
1309 PUT_LINE (' ');
1310 PUT_LINE ('Dumping the values for Instance Asset Record:');
1311 PUT_LINE (' ');
1312 PUT_LINE ('instance_asset_id :'||p_instance_asset_rec.instance_asset_id);
1313 PUT_LINE ('instance_id :'||p_instance_asset_rec.instance_id);
1314 PUT_LINE ('fa_asset_id :'||p_instance_asset_rec.fa_asset_id);
1315 PUT_LINE ('fa_book_type_code :'||p_instance_asset_rec.fa_book_type_code);
1316 PUT_LINE ('fa_location_id :'||p_instance_asset_rec.fa_location_id);
1317 PUT_LINE ('asset_quantity :'||p_instance_asset_rec.asset_quantity);
1318 PUT_LINE ('update_status :'||p_instance_asset_rec.update_status);
1319 PUT_LINE ('active_start_date :'||p_instance_asset_rec.active_start_date);
1320 PUT_LINE ('active_end_date :'||p_instance_asset_rec.active_end_date);
1321 PUT_LINE ('fa_sync_flag :'||p_instance_asset_rec.fa_sync_flag);
1322 PUT_LINE ('fa_sync_validation_reqd :'||p_instance_asset_rec.fa_sync_validation_reqd);
1323 PUT_LINE ('object_version_number :'||p_instance_asset_rec.object_version_number);
1324
1325 EXCEPTION
1326 WHEN OTHERS THEN
1327 -- ROLLBACK TO dump_instance_asset_rec;
1328 IF FND_MSG_PUB.Check_Msg_Level
1329 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1330 THEN
1331 FND_MSG_PUB.Add_Exc_Msg
1332 ( g_pkg_name ,
1333 l_api_name );
1334 END IF;
1335 END dump_instance_asset_rec;
1336
1337
1338 PROCEDURE dump_party_query_rec
1339 (p_party_query_rec IN csi_datastructures_pub.party_query_rec
1340 ) IS
1341 l_api_name CONSTANT VARCHAR2(30) := 'dump_party_query_rec';
1342 l_api_version CONSTANT NUMBER := 1.0;
1343 BEGIN
1344
1345 -- Standard Start of API savepoint
1346 -- SAVEPOINT dump_party_query_rec;
1347
1348 PUT_LINE (' ');
1349 PUT_LINE ('Dumping the values for Instance Party Query Record:');
1350 PUT_LINE (' ');
1351 PUT_LINE ('instance_party_id :'||p_party_query_rec.instance_party_id);
1352 PUT_LINE ('instance_id :'||p_party_query_rec.instance_id);
1353 PUT_LINE ('party_id :'||p_party_query_rec.party_id);
1354 PUT_LINE ('relationship_type_code :'||p_party_query_rec.relationship_type_code);
1355
1356 EXCEPTION
1357 WHEN OTHERS THEN
1358 -- ROLLBACK TO dump_party_query_rec;
1359 IF FND_MSG_PUB.Check_Msg_Level
1360 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1361 THEN
1362 FND_MSG_PUB.Add_Exc_Msg
1363 ( g_pkg_name ,
1364 l_api_name
1365 );
1366 END IF;
1367 END dump_party_query_rec;
1368
1369
1370 PROCEDURE dump_organization_unit_rec
1371 (p_org_unit_rec IN csi_datastructures_pub.organization_units_rec)
1372 IS
1373 l_api_name CONSTANT VARCHAR2(30) := 'dump_organization_unit_rec';
1374 l_api_version CONSTANT NUMBER := 1.0;
1375 BEGIN
1376
1377 -- Standard Start of API savepoint
1378 -- SAVEPOINT dump_organization_unit_rec;
1379 PUT_LINE (' ');
1380 PUT_LINE ('Dumping the values for Org. Assignments Record:');
1381 PUT_LINE (' ');
1382 PUT_LINE ('instance_ou_id :'||p_org_unit_rec.instance_ou_id);
1383 PUT_LINE ('instance_id :'||p_org_unit_rec.instance_id);
1384 PUT_LINE ('operating_unit_id :'||p_org_unit_rec.operating_unit_id);
1385 PUT_LINE ('relationship_type_code :'||p_org_unit_rec.relationship_type_code);
1386 PUT_LINE ('active_start_date :'||p_org_unit_rec.active_start_date);
1387 PUT_LINE ('active_end_date :'||p_org_unit_rec.active_end_date);
1388 PUT_LINE ('context :'||p_org_unit_rec.context);
1389 PUT_LINE ('attribute1 :'||p_org_unit_rec.attribute1);
1390 PUT_LINE ('attribute2 :'||p_org_unit_rec.attribute2);
1391 PUT_LINE ('attribute3 :'||p_org_unit_rec.attribute3);
1392 PUT_LINE ('attribute4 :'||p_org_unit_rec.attribute4);
1393 PUT_LINE ('attribute5 :'||p_org_unit_rec.attribute5);
1394 PUT_LINE ('attribute6 :'||p_org_unit_rec.attribute6);
1398 PUT_LINE ('attribute10 :'||p_org_unit_rec.attribute10);
1395 PUT_LINE ('attribute7 :'||p_org_unit_rec.attribute7);
1396 PUT_LINE ('attribute8 :'||p_org_unit_rec.attribute8);
1397 PUT_LINE ('attribute9 :'||p_org_unit_rec.attribute9);
1399 PUT_LINE ('attribute11 :'||p_org_unit_rec.attribute11);
1400 PUT_LINE ('attribute12 :'||p_org_unit_rec.attribute12);
1401 PUT_LINE ('attribute13 :'||p_org_unit_rec.attribute13);
1402 PUT_LINE ('attribute14 :'||p_org_unit_rec.attribute14);
1403 PUT_LINE ('attribute15 :'||p_org_unit_rec.attribute15);
1404 PUT_LINE ('object_version_number :'||p_org_unit_rec.object_version_number);
1405
1406 EXCEPTION
1407 WHEN OTHERS THEN
1408 -- ROLLBACK TO dump_organization_unit_rec;
1409
1410 IF FND_MSG_PUB.Check_Msg_Level
1411 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1412 THEN
1413 FND_MSG_PUB.Add_Exc_Msg
1414 ( g_pkg_name ,
1415 l_api_name
1416 );
1417 END IF;
1418
1419 END dump_organization_unit_rec;
1420
1421
1422 PROCEDURE dump_organization_unit_tbl
1423 (p_org_unit_tbl IN csi_datastructures_pub.organization_units_tbl)
1424 IS
1425 l_api_name CONSTANT VARCHAR2(30) := 'DUMP_ORGANIZATION_UNIT_TBL';
1426 l_api_version CONSTANT NUMBER := 1.0;
1427 BEGIN
1428
1429 -- Standard Start of API savepoint
1430 -- SAVEPOINT dump_organization_unit_tbl;
1431
1432 IF p_org_unit_tbl.COUNT > 0 THEN
1433 FOR tab_row IN p_org_unit_tbl.FIRST .. p_org_unit_tbl.LAST
1434 LOOP
1435 IF p_org_unit_tbl.EXISTS(tab_row) THEN
1436
1437 PUT_LINE (' ');
1438 PUT_LINE ('Dumping the values for Org. Assignments Table Record # :'||tab_row);
1439 PUT_LINE (' ');
1440 PUT_LINE ('instance_ou_id :'||p_org_unit_tbl(tab_row).instance_ou_id);
1441 PUT_LINE ('instance_id :'||p_org_unit_tbl(tab_row).instance_id);
1442 PUT_LINE ('operating_unit_id :'||p_org_unit_tbl(tab_row).operating_unit_id);
1443 PUT_LINE ('relationship_type_code :'||p_org_unit_tbl(tab_row).relationship_type_code);
1444 PUT_LINE ('active_start_date :'||p_org_unit_tbl(tab_row).active_start_date);
1445 PUT_LINE ('active_end_date :'||p_org_unit_tbl(tab_row).active_end_date);
1446 PUT_LINE ('context :'||p_org_unit_tbl(tab_row).context);
1447 PUT_LINE ('attribute1 :'||p_org_unit_tbl(tab_row).attribute1);
1448 PUT_LINE ('attribute2 :'||p_org_unit_tbl(tab_row).attribute2);
1449 PUT_LINE ('attribute3 :'||p_org_unit_tbl(tab_row).attribute3);
1450 PUT_LINE ('attribute4 :'||p_org_unit_tbl(tab_row).attribute4);
1451 PUT_LINE ('attribute5 :'||p_org_unit_tbl(tab_row).attribute5);
1452 PUT_LINE ('attribute6 :'||p_org_unit_tbl(tab_row).attribute6);
1453 PUT_LINE ('attribute7 :'||p_org_unit_tbl(tab_row).attribute7);
1454 PUT_LINE ('attribute8 :'||p_org_unit_tbl(tab_row).attribute8);
1455 PUT_LINE ('attribute9 :'||p_org_unit_tbl(tab_row).attribute9);
1456 PUT_LINE ('attribute10 :'||p_org_unit_tbl(tab_row).attribute10);
1457 PUT_LINE ('attribute11 :'||p_org_unit_tbl(tab_row).attribute11);
1458 PUT_LINE ('attribute12 :'||p_org_unit_tbl(tab_row).attribute12);
1459 PUT_LINE ('attribute13 :'||p_org_unit_tbl(tab_row).attribute13);
1460 PUT_LINE ('attribute14 :'||p_org_unit_tbl(tab_row).attribute14);
1461 PUT_LINE ('attribute15 :'||p_org_unit_tbl(tab_row).attribute15);
1462 PUT_LINE ('object_version_number :'||p_org_unit_tbl(tab_row).object_version_number);
1463
1464 END IF;
1465 END LOOP;
1466 END IF;
1467
1468 EXCEPTION
1469 WHEN OTHERS THEN
1470 -- ROLLBACK TO dump_organization_unit_tbl;
1471
1472 IF FND_MSG_PUB.Check_Msg_Level
1473 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1474 THEN
1475 FND_MSG_PUB.Add_Exc_Msg
1476 ( g_pkg_name,
1477 l_api_name
1478 );
1479 END IF;
1480
1481 END dump_organization_unit_tbl;
1482
1483
1484 PROCEDURE dump_pricing_attribs_query_rec
1485 (pricing_attribs_query_rec IN csi_datastructures_pub.pricing_attribs_query_rec)
1486 IS
1487 l_api_name CONSTANT VARCHAR2(30) := 'dump_pricing_attribs_query_rec';
1488 l_api_version CONSTANT NUMBER := 1.0;
1489 BEGIN
1490
1491 -- Standard Start of API savepoint
1492 -- SAVEPOINT dump_pricing_attribs_query_rec;
1493
1494 PUT_LINE (' ');
1495 PUT_LINE ('Dumping the values for Pricing Attribs Query Record:');
1496 PUT_LINE (' ');
1497 PUT_LINE ('pricing_attribute_id :'||pricing_attribs_query_rec.pricing_attribute_id);
1498 PUT_LINE ('instance_id :'||pricing_attribs_query_rec.instance_id);
1499
1500 EXCEPTION
1501 WHEN OTHERS THEN
1502 -- ROLLBACK TO dump_pricing_attribs_query_rec;
1503
1504 IF FND_MSG_PUB.Check_Msg_Level
1505 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1506 THEN
1507 FND_MSG_PUB.Add_Exc_Msg
1508 ( g_pkg_name ,
1509 l_api_name
1510 );
1511 END IF;
1512
1516 PROCEDURE dump_pricing_attribs_rec
1513 END dump_pricing_attribs_query_rec;
1514
1515
1517 (p_pricing_attribs_rec IN csi_datastructures_pub.pricing_attribs_rec)
1518 IS
1519 l_api_name CONSTANT VARCHAR2(30) := 'dump_pricing_attribs_rec';
1520 l_api_version CONSTANT NUMBER := 1.0;
1521 BEGIN
1522
1523 -- Standard Start of API savepoint
1524 -- SAVEPOINT dump_pricing_attribs_rec;
1525
1526 PUT_LINE (' ');
1527 PUT_LINE ('Dumping the values for Pricing Attribs Record:');
1528 PUT_LINE (' ');
1529 PUT_LINE ('pricing_attribute_id :'||p_pricing_attribs_rec.pricing_attribute_id);
1530 PUT_LINE ('instance_id :'||p_pricing_attribs_rec.instance_id);
1531 PUT_LINE ('active_start_date :'||p_pricing_attribs_rec.active_start_date);
1532 PUT_LINE ('active_end_date :'||p_pricing_attribs_rec.active_end_date);
1533 PUT_LINE ('pricing_context :'||p_pricing_attribs_rec.pricing_context);
1534 PUT_LINE ('pricing_attribute1 :'||p_pricing_attribs_rec.pricing_attribute1);
1535 PUT_LINE ('pricing_attribute2 :'||p_pricing_attribs_rec.pricing_attribute2);
1536 PUT_LINE ('pricing_attribute3 :'||p_pricing_attribs_rec.pricing_attribute3);
1537 PUT_LINE ('pricing_attribute4 :'||p_pricing_attribs_rec.pricing_attribute4);
1538 PUT_LINE ('pricing_attribute5 :'||p_pricing_attribs_rec.pricing_attribute5);
1539 PUT_LINE ('pricing_attribute6 :'||p_pricing_attribs_rec.pricing_attribute6);
1540 PUT_LINE ('pricing_attribute7 :'||p_pricing_attribs_rec.pricing_attribute7);
1541 PUT_LINE ('pricing_attribute8 :'||p_pricing_attribs_rec.pricing_attribute8);
1542 PUT_LINE ('pricing_attribute9 :'||p_pricing_attribs_rec.pricing_attribute9);
1543 PUT_LINE ('pricing_attribute10 :'||p_pricing_attribs_rec.pricing_attribute10);
1544 PUT_LINE ('pricing_attribute11 :'||p_pricing_attribs_rec.pricing_attribute11);
1545 PUT_LINE ('pricing_attribute12 :'||p_pricing_attribs_rec.pricing_attribute12);
1546 PUT_LINE ('pricing_attribute13 :'||p_pricing_attribs_rec.pricing_attribute13);
1547 PUT_LINE ('pricing_attribute14 :'||p_pricing_attribs_rec.pricing_attribute14);
1548 PUT_LINE ('pricing_attribute15 :'||p_pricing_attribs_rec.pricing_attribute15);
1549 PUT_LINE ('pricing_attribute16 :'||p_pricing_attribs_rec.pricing_attribute16);
1550 PUT_LINE ('pricing_attribute17 :'||p_pricing_attribs_rec.pricing_attribute17);
1551 PUT_LINE ('pricing_attribute18 :'||p_pricing_attribs_rec.pricing_attribute18);
1552 PUT_LINE ('pricing_attribute19 :'||p_pricing_attribs_rec.pricing_attribute19);
1553 PUT_LINE ('pricing_attribute20 :'||p_pricing_attribs_rec.pricing_attribute20);
1554 PUT_LINE ('pricing_attribute21 :'||p_pricing_attribs_rec.pricing_attribute21);
1555 PUT_LINE ('pricing_attribute22 :'||p_pricing_attribs_rec.pricing_attribute22);
1556 PUT_LINE ('pricing_attribute23 :'||p_pricing_attribs_rec.pricing_attribute23);
1557 PUT_LINE ('pricing_attribute24 :'||p_pricing_attribs_rec.pricing_attribute24);
1558 PUT_LINE ('pricing_attribute25 :'||p_pricing_attribs_rec.pricing_attribute25);
1559 PUT_LINE ('pricing_attribute26 :'||p_pricing_attribs_rec.pricing_attribute26);
1560 PUT_LINE ('pricing_attribute27 :'||p_pricing_attribs_rec.pricing_attribute27);
1561 PUT_LINE ('pricing_attribute28 :'||p_pricing_attribs_rec.pricing_attribute28);
1562 PUT_LINE ('pricing_attribute29 :'||p_pricing_attribs_rec.pricing_attribute29);
1563 PUT_LINE ('pricing_attribute30 :'||p_pricing_attribs_rec.pricing_attribute30);
1564 PUT_LINE ('pricing_attribute31 :'||p_pricing_attribs_rec.pricing_attribute31);
1565 PUT_LINE ('pricing_attribute32 :'||p_pricing_attribs_rec.pricing_attribute32);
1566 PUT_LINE ('pricing_attribute33 :'||p_pricing_attribs_rec.pricing_attribute33);
1567 PUT_LINE ('pricing_attribute34 :'||p_pricing_attribs_rec.pricing_attribute34);
1568 PUT_LINE ('pricing_attribute35 :'||p_pricing_attribs_rec.pricing_attribute35);
1569 PUT_LINE ('pricing_attribute36 :'||p_pricing_attribs_rec.pricing_attribute36);
1570 PUT_LINE ('pricing_attribute37 :'||p_pricing_attribs_rec.pricing_attribute37);
1571 PUT_LINE ('pricing_attribute38 :'||p_pricing_attribs_rec.pricing_attribute38);
1572 PUT_LINE ('pricing_attribute39 :'||p_pricing_attribs_rec.pricing_attribute39);
1573 PUT_LINE ('pricing_attribute40 :'||p_pricing_attribs_rec.pricing_attribute40);
1574 PUT_LINE ('pricing_attribute41 :'||p_pricing_attribs_rec.pricing_attribute41);
1575 PUT_LINE ('pricing_attribute42 :'||p_pricing_attribs_rec.pricing_attribute42);
1576 PUT_LINE ('pricing_attribute43 :'||p_pricing_attribs_rec.pricing_attribute43);
1577 PUT_LINE ('pricing_attribute44 :'||p_pricing_attribs_rec.pricing_attribute44);
1578 PUT_LINE ('pricing_attribute45 :'||p_pricing_attribs_rec.pricing_attribute45);
1579 PUT_LINE ('pricing_attribute46 :'||p_pricing_attribs_rec.pricing_attribute46);
1580 PUT_LINE ('pricing_attribute47 :'||p_pricing_attribs_rec.pricing_attribute47);
1581 PUT_LINE ('pricing_attribute48 :'||p_pricing_attribs_rec.pricing_attribute48);
1582 PUT_LINE ('pricing_attribute49 :'||p_pricing_attribs_rec.pricing_attribute49);
1583 PUT_LINE ('pricing_attribute50 :'||p_pricing_attribs_rec.pricing_attribute50);
1584 PUT_LINE ('pricing_attribute51 :'||p_pricing_attribs_rec.pricing_attribute51);
1585 PUT_LINE ('pricing_attribute52 :'||p_pricing_attribs_rec.pricing_attribute52);
1586 PUT_LINE ('pricing_attribute53 :'||p_pricing_attribs_rec.pricing_attribute53);
1587 PUT_LINE ('pricing_attribute54 :'||p_pricing_attribs_rec.pricing_attribute54);
1588 PUT_LINE ('pricing_attribute55 :'||p_pricing_attribs_rec.pricing_attribute55);
1589 PUT_LINE ('pricing_attribute56 :'||p_pricing_attribs_rec.pricing_attribute56);
1590 PUT_LINE ('pricing_attribute57 :'||p_pricing_attribs_rec.pricing_attribute57);
1591 PUT_LINE ('pricing_attribute58 :'||p_pricing_attribs_rec.pricing_attribute58);
1592 PUT_LINE ('pricing_attribute59 :'||p_pricing_attribs_rec.pricing_attribute59);
1593 PUT_LINE ('pricing_attribute60 :'||p_pricing_attribs_rec.pricing_attribute60);
1594 PUT_LINE ('pricing_attribute61 :'||p_pricing_attribs_rec.pricing_attribute61);
1595 PUT_LINE ('pricing_attribute62 :'||p_pricing_attribs_rec.pricing_attribute62);
1596 PUT_LINE ('pricing_attribute63 :'||p_pricing_attribs_rec.pricing_attribute63);
1597 PUT_LINE ('pricing_attribute64 :'||p_pricing_attribs_rec.pricing_attribute64);
1598 PUT_LINE ('pricing_attribute65 :'||p_pricing_attribs_rec.pricing_attribute65);
1599 PUT_LINE ('pricing_attribute66 :'||p_pricing_attribs_rec.pricing_attribute66);
1600 PUT_LINE ('pricing_attribute67 :'||p_pricing_attribs_rec.pricing_attribute67);
1601 PUT_LINE ('pricing_attribute68 :'||p_pricing_attribs_rec.pricing_attribute68);
1602 PUT_LINE ('pricing_attribute69 :'||p_pricing_attribs_rec.pricing_attribute69);
1603 PUT_LINE ('pricing_attribute70 :'||p_pricing_attribs_rec.pricing_attribute70);
1604 PUT_LINE ('pricing_attribute71 :'||p_pricing_attribs_rec.pricing_attribute71);
1605 PUT_LINE ('pricing_attribute72 :'||p_pricing_attribs_rec.pricing_attribute72);
1606 PUT_LINE ('pricing_attribute73 :'||p_pricing_attribs_rec.pricing_attribute73);
1607 PUT_LINE ('pricing_attribute74 :'||p_pricing_attribs_rec.pricing_attribute74);
1608 PUT_LINE ('pricing_attribute75 :'||p_pricing_attribs_rec.pricing_attribute75);
1609 PUT_LINE ('pricing_attribute76 :'||p_pricing_attribs_rec.pricing_attribute76);
1610 PUT_LINE ('pricing_attribute77 :'||p_pricing_attribs_rec.pricing_attribute77);
1611 PUT_LINE ('pricing_attribute78 :'||p_pricing_attribs_rec.pricing_attribute78);
1612 PUT_LINE ('pricing_attribute79 :'||p_pricing_attribs_rec.pricing_attribute79);
1613 PUT_LINE ('pricing_attribute80 :'||p_pricing_attribs_rec.pricing_attribute80);
1614 PUT_LINE ('pricing_attribute81 :'||p_pricing_attribs_rec.pricing_attribute81);
1615 PUT_LINE ('pricing_attribute82 :'||p_pricing_attribs_rec.pricing_attribute82);
1616 PUT_LINE ('pricing_attribute83 :'||p_pricing_attribs_rec.pricing_attribute83);
1617 PUT_LINE ('pricing_attribute84 :'||p_pricing_attribs_rec.pricing_attribute84);
1618 PUT_LINE ('pricing_attribute85 :'||p_pricing_attribs_rec.pricing_attribute85);
1619 PUT_LINE ('pricing_attribute86 :'||p_pricing_attribs_rec.pricing_attribute86);
1620 PUT_LINE ('pricing_attribute87 :'||p_pricing_attribs_rec.pricing_attribute87);
1621 PUT_LINE ('pricing_attribute88 :'||p_pricing_attribs_rec.pricing_attribute88);
1622 PUT_LINE ('pricing_attribute89 :'||p_pricing_attribs_rec.pricing_attribute89);
1623 PUT_LINE ('pricing_attribute90 :'||p_pricing_attribs_rec.pricing_attribute90);
1624 PUT_LINE ('pricing_attribute91 :'||p_pricing_attribs_rec.pricing_attribute91);
1625 PUT_LINE ('pricing_attribute92 :'||p_pricing_attribs_rec.pricing_attribute92);
1626 PUT_LINE ('pricing_attribute93 :'||p_pricing_attribs_rec.pricing_attribute93);
1627 PUT_LINE ('pricing_attribute94 :'||p_pricing_attribs_rec.pricing_attribute94);
1628 PUT_LINE ('pricing_attribute95 :'||p_pricing_attribs_rec.pricing_attribute95);
1629 PUT_LINE ('pricing_attribute96 :'||p_pricing_attribs_rec.pricing_attribute96);
1630 PUT_LINE ('pricing_attribute97 :'||p_pricing_attribs_rec.pricing_attribute97);
1631 PUT_LINE ('pricing_attribute98 :'||p_pricing_attribs_rec.pricing_attribute98);
1632 PUT_LINE ('pricing_attribute99 :'||p_pricing_attribs_rec.pricing_attribute99);
1633 PUT_LINE ('pricing_attribute100 :'||p_pricing_attribs_rec.pricing_attribute100);
1634 PUT_LINE ('context :'||p_pricing_attribs_rec.context);
1635 PUT_LINE ('attribute1 :'||p_pricing_attribs_rec.attribute1);
1636 PUT_LINE ('attribute2 :'||p_pricing_attribs_rec.attribute2);
1637 PUT_LINE ('attribute3 :'||p_pricing_attribs_rec.attribute3);
1638 PUT_LINE ('attribute4 :'||p_pricing_attribs_rec.attribute4);
1639 PUT_LINE ('attribute5 :'||p_pricing_attribs_rec.attribute5);
1640 PUT_LINE ('attribute6 :'||p_pricing_attribs_rec.attribute6);
1641 PUT_LINE ('attribute7 :'||p_pricing_attribs_rec.attribute7);
1642 PUT_LINE ('attribute8 :'||p_pricing_attribs_rec.attribute8);
1643 PUT_LINE ('attribute9 :'||p_pricing_attribs_rec.attribute9);
1644 PUT_LINE ('attribute10 :'||p_pricing_attribs_rec.attribute10);
1645 PUT_LINE ('attribute11 :'||p_pricing_attribs_rec.attribute11);
1646 PUT_LINE ('attribute12 :'||p_pricing_attribs_rec.attribute12);
1647 PUT_LINE ('attribute13 :'||p_pricing_attribs_rec.attribute13);
1648 PUT_LINE ('attribute14 :'||p_pricing_attribs_rec.attribute14);
1649 PUT_LINE ('attribute15 :'||p_pricing_attribs_rec.attribute15);
1650 PUT_LINE ('object_version_number :'||p_pricing_attribs_rec.object_version_number);
1651
1652 EXCEPTION
1653 WHEN OTHERS THEN
1654 -- ROLLBACK TO dump_pricing_attribs_rec;
1655
1656 IF FND_MSG_PUB.Check_Msg_Level
1657 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1658 THEN
1659 FND_MSG_PUB.Add_Exc_Msg
1660 ( g_pkg_name ,
1661 l_api_name
1662 );
1663 END IF;
1664
1665 END dump_pricing_attribs_rec;
1666
1667 PROCEDURE dump_pricing_attribs_tbl
1668 (p_pricing_attribs_tbl IN csi_datastructures_pub.pricing_attribs_tbl)
1669 IS
1670 l_api_name CONSTANT VARCHAR2(30) := 'dump_pricing_attribs_tbl';
1671 l_api_version CONSTANT NUMBER := 1.0;
1672 BEGIN
1673
1674 -- Standard Start of API savepoint
1675 -- SAVEPOINT dump_pricing_attribs_tbl;
1676
1677 IF p_pricing_attribs_tbl.COUNT > 0 THEN
1678 FOR tab_row IN p_pricing_attribs_tbl.FIRST .. p_pricing_attribs_tbl.LAST
1679 LOOP
1680 IF p_pricing_attribs_tbl.EXISTS(tab_row) THEN
1681
1682 PUT_LINE (' ');
1683 PUT_LINE ('Dumping the values for Pricing Attribs Table Record # :'||tab_row);
1684 PUT_LINE (' ');
1685 PUT_LINE ('pricing_attribute_id :'||p_pricing_attribs_tbl(tab_row).pricing_attribute_id);
1686 PUT_LINE ('instance_id :'||p_pricing_attribs_tbl(tab_row).instance_id);
1687 PUT_LINE ('active_start_date :'||p_pricing_attribs_tbl(tab_row).active_start_date);
1688 PUT_LINE ('active_end_date :'||p_pricing_attribs_tbl(tab_row).active_end_date);
1689 PUT_LINE ('pricing_context :'||p_pricing_attribs_tbl(tab_row).pricing_context);
1690 PUT_LINE ('pricing_attribute1 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute1);
1691 PUT_LINE ('pricing_attribute2 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute2);
1692 PUT_LINE ('pricing_attribute3 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute3);
1693 PUT_LINE ('pricing_attribute4 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute4);
1694 PUT_LINE ('pricing_attribute5 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute5);
1695 PUT_LINE ('pricing_attribute6 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute6);
1696 PUT_LINE ('pricing_attribute7 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute7);
1697 PUT_LINE ('pricing_attribute8 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute8);
1698 PUT_LINE ('pricing_attribute9 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute9);
1699 PUT_LINE ('pricing_attribute10 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute10);
1700 PUT_LINE ('pricing_attribute11 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute11);
1701 PUT_LINE ('pricing_attribute12 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute12);
1702 PUT_LINE ('pricing_attribute13 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute13);
1703 PUT_LINE ('pricing_attribute14 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute14);
1704 PUT_LINE ('pricing_attribute15 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute15);
1705 PUT_LINE ('pricing_attribute16 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute16);
1706 PUT_LINE ('pricing_attribute17 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute17);
1707 PUT_LINE ('pricing_attribute18 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute18);
1708 PUT_LINE ('pricing_attribute19 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute19);
1709 PUT_LINE ('pricing_attribute20 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute20);
1710 PUT_LINE ('pricing_attribute21 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute21);
1711 PUT_LINE ('pricing_attribute22 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute22);
1712 PUT_LINE ('pricing_attribute23 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute23);
1713 PUT_LINE ('pricing_attribute24 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute24);
1714 PUT_LINE ('pricing_attribute25 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute25);
1715 PUT_LINE ('pricing_attribute26 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute26);
1716 PUT_LINE ('pricing_attribute27 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute27);
1717 PUT_LINE ('pricing_attribute28 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute28);
1718 PUT_LINE ('pricing_attribute29 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute29);
1722 PUT_LINE ('pricing_attribute33 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute33);
1719 PUT_LINE ('pricing_attribute30 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute30);
1720 PUT_LINE ('pricing_attribute31 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute31);
1721 PUT_LINE ('pricing_attribute32 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute32);
1723 PUT_LINE ('pricing_attribute34 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute34);
1724 PUT_LINE ('pricing_attribute35 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute35);
1725 PUT_LINE ('pricing_attribute36 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute36);
1726 PUT_LINE ('pricing_attribute37 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute37);
1727 PUT_LINE ('pricing_attribute38 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute38);
1728 PUT_LINE ('pricing_attribute39 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute39);
1729 PUT_LINE ('pricing_attribute40 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute40);
1730 PUT_LINE ('pricing_attribute41 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute41);
1731 PUT_LINE ('pricing_attribute42 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute42);
1732 PUT_LINE ('pricing_attribute43 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute43);
1733 PUT_LINE ('pricing_attribute44 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute44);
1734 PUT_LINE ('pricing_attribute45 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute45);
1735 PUT_LINE ('pricing_attribute46 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute46);
1736 PUT_LINE ('pricing_attribute47 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute47);
1737 PUT_LINE ('pricing_attribute48 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute48);
1738 PUT_LINE ('pricing_attribute49 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute49);
1739 PUT_LINE ('pricing_attribute50 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute50);
1740 PUT_LINE ('pricing_attribute51 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute51);
1741 PUT_LINE ('pricing_attribute52 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute52);
1742 PUT_LINE ('pricing_attribute53 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute53);
1743 PUT_LINE ('pricing_attribute54 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute54);
1744 PUT_LINE ('pricing_attribute55 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute55);
1745 PUT_LINE ('pricing_attribute56 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute56);
1746 PUT_LINE ('pricing_attribute57 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute57);
1747 PUT_LINE ('pricing_attribute58 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute58);
1748 PUT_LINE ('pricing_attribute59 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute59);
1749 PUT_LINE ('pricing_attribute60 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute60);
1750 PUT_LINE ('pricing_attribute61 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute61);
1751 PUT_LINE ('pricing_attribute62 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute62);
1752 PUT_LINE ('pricing_attribute63 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute63);
1753 PUT_LINE ('pricing_attribute64 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute64);
1754 PUT_LINE ('pricing_attribute65 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute65);
1755 PUT_LINE ('pricing_attribute66 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute66);
1756 PUT_LINE ('pricing_attribute67 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute67);
1757 PUT_LINE ('pricing_attribute68 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute68);
1758 PUT_LINE ('pricing_attribute69 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute69);
1759 PUT_LINE ('pricing_attribute70 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute70);
1760 PUT_LINE ('pricing_attribute71 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute71);
1761 PUT_LINE ('pricing_attribute72 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute72);
1762 PUT_LINE ('pricing_attribute73 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute73);
1763 PUT_LINE ('pricing_attribute74 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute74);
1764 PUT_LINE ('pricing_attribute75 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute75);
1765 PUT_LINE ('pricing_attribute76 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute76);
1766 PUT_LINE ('pricing_attribute77 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute77);
1767 PUT_LINE ('pricing_attribute78 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute78);
1768 PUT_LINE ('pricing_attribute79 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute79);
1769 PUT_LINE ('pricing_attribute80 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute80);
1770 PUT_LINE ('pricing_attribute81 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute81);
1771 PUT_LINE ('pricing_attribute82 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute82);
1772 PUT_LINE ('pricing_attribute83 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute83);
1773 PUT_LINE ('pricing_attribute84 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute84);
1774 PUT_LINE ('pricing_attribute85 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute85);
1775 PUT_LINE ('pricing_attribute86 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute86);
1776 PUT_LINE ('pricing_attribute87 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute87);
1777 PUT_LINE ('pricing_attribute88 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute88);
1778 PUT_LINE ('pricing_attribute89 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute89);
1779 PUT_LINE ('pricing_attribute90 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute90);
1780 PUT_LINE ('pricing_attribute91 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute91);
1781 PUT_LINE ('pricing_attribute92 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute92);
1782 PUT_LINE ('pricing_attribute93 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute93);
1783 PUT_LINE ('pricing_attribute94 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute94);
1784 PUT_LINE ('pricing_attribute95 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute95);
1785 PUT_LINE ('pricing_attribute96 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute96);
1786 PUT_LINE ('pricing_attribute97 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute97);
1787 PUT_LINE ('pricing_attribute98 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute98);
1788 PUT_LINE ('pricing_attribute99 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute99);
1789 PUT_LINE ('pricing_attribute100 :'||p_pricing_attribs_tbl(tab_row).pricing_attribute100);
1790 PUT_LINE ('context :'||p_pricing_attribs_tbl(tab_row).context);
1791 PUT_LINE ('attribute1 :'||p_pricing_attribs_tbl(tab_row).attribute1);
1792 PUT_LINE ('attribute2 :'||p_pricing_attribs_tbl(tab_row).attribute2);
1793 PUT_LINE ('attribute3 :'||p_pricing_attribs_tbl(tab_row).attribute3);
1794 PUT_LINE ('attribute4 :'||p_pricing_attribs_tbl(tab_row).attribute4);
1795 PUT_LINE ('attribute5 :'||p_pricing_attribs_tbl(tab_row).attribute5);
1796 PUT_LINE ('attribute6 :'||p_pricing_attribs_tbl(tab_row).attribute6);
1797 PUT_LINE ('attribute7 :'||p_pricing_attribs_tbl(tab_row).attribute7);
1798 PUT_LINE ('attribute8 :'||p_pricing_attribs_tbl(tab_row).attribute8);
1799 PUT_LINE ('attribute9 :'||p_pricing_attribs_tbl(tab_row).attribute9);
1800 PUT_LINE ('attribute10 :'||p_pricing_attribs_tbl(tab_row).attribute10);
1801 PUT_LINE ('attribute11 :'||p_pricing_attribs_tbl(tab_row).attribute11);
1802 PUT_LINE ('attribute12 :'||p_pricing_attribs_tbl(tab_row).attribute12);
1803 PUT_LINE ('attribute13 :'||p_pricing_attribs_tbl(tab_row).attribute13);
1804 PUT_LINE ('attribute14 :'||p_pricing_attribs_tbl(tab_row).attribute14);
1805 PUT_LINE ('attribute15 :'||p_pricing_attribs_tbl(tab_row).attribute15);
1806 PUT_LINE ('object_version_number :'||p_pricing_attribs_tbl(tab_row).object_version_number);
1807
1808 END IF;
1809 END LOOP;
1810 END IF;
1811
1812 EXCEPTION
1813 WHEN OTHERS THEN
1814 -- ROLLBACK TO dump_pricing_attribs_tbl;
1815
1816 IF FND_MSG_PUB.Check_Msg_Level
1817 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1818 THEN
1819 FND_MSG_PUB.Add_Exc_Msg
1820 ( g_pkg_name ,
1821 l_api_name
1822 );
1823 END IF;
1824
1825 END dump_pricing_attribs_tbl;
1826
1827
1828 PROCEDURE dump_party_rec
1829 ( p_party_rec IN csi_datastructures_pub.party_rec
1830 ) IS
1831 l_api_name CONSTANT VARCHAR2(30) := 'dump_party_rec';
1832 l_api_version CONSTANT NUMBER := 1.0;
1833 BEGIN
1834 -- Standard Start of API savepoint
1835 -- SAVEPOINT dump_party_rec;
1836
1837 PUT_LINE (' ');
1838 PUT_LINE ('Dumping the values for Instance Party Record:');
1839 PUT_LINE (' ');
1840 PUT_LINE ('instance_party_id :'||p_party_rec.instance_party_id);
1841 PUT_LINE ('instance_id :'||p_party_rec.instance_id);
1842 PUT_LINE ('party_source_table :'||p_party_rec.party_source_table);
1843 PUT_LINE ('party_id :'||p_party_rec.party_id);
1844 PUT_LINE ('relationship_type_code :'||p_party_rec.relationship_type_code);
1845 PUT_LINE ('contact_flag :'||p_party_rec.contact_flag);
1846 PUT_LINE ('contact_ip_id :'||p_party_rec.contact_ip_id);
1847 PUT_LINE ('active_start_date :'||p_party_rec.active_start_date);
1848 PUT_LINE ('active_end_date :'||p_party_rec.active_end_date);
1849 PUT_LINE ('context :'||p_party_rec.context);
1850 PUT_LINE ('attribute1 :'||p_party_rec.attribute1);
1851 PUT_LINE ('attribute2 :'||p_party_rec.attribute2);
1852 PUT_LINE ('attribute3 :'||p_party_rec.attribute3);
1853 PUT_LINE ('attribute4 :'||p_party_rec.attribute4);
1854 PUT_LINE ('attribute5 :'||p_party_rec.attribute5);
1855 PUT_LINE ('attribute6 :'||p_party_rec.attribute6);
1856 PUT_LINE ('attribute7 :'||p_party_rec.attribute7);
1857 PUT_LINE ('attribute8 :'||p_party_rec.attribute8);
1858 PUT_LINE ('attribute9 :'||p_party_rec.attribute9);
1859 PUT_LINE ('attribute10 :'||p_party_rec.attribute10);
1860 PUT_LINE ('attribute11 :'||p_party_rec.attribute11);
1861 PUT_LINE ('attribute12 :'||p_party_rec.attribute12);
1862 PUT_LINE ('attribute13 :'||p_party_rec.attribute13);
1863 PUT_LINE ('attribute14 :'||p_party_rec.attribute14);
1864 PUT_LINE ('attribute15 :'||p_party_rec.attribute15);
1865 PUT_LINE ('object_version_number :'||p_party_rec.object_version_number);
1866
1867
1868 EXCEPTION
1869 WHEN OTHERS THEN
1870 -- ROLLBACK TO dump_party_rec;
1871 IF FND_MSG_PUB.Check_Msg_Level
1872 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1873 THEN
1874 FND_MSG_PUB.Add_Exc_Msg
1875 ( g_pkg_name ,
1876 l_api_name );
1877 END IF;
1878 END dump_party_rec;
1879
1880
1881 PROCEDURE dump_party_tbl
1882 (p_party_tbl IN csi_datastructures_pub.party_tbl)
1883 IS
1884 l_api_name CONSTANT VARCHAR2(30) := 'DUMP_PARTY_TBL';
1885 l_api_version CONSTANT NUMBER := 1.0;
1886 BEGIN
1887 -- Standard Start of API savepoint
1888 -- SAVEPOINT dump_party_tbl;
1889
1890 IF p_party_tbl.COUNT > 0 THEN
1891 FOR tab_row IN p_party_tbl.FIRST .. p_party_tbl.LAST LOOP
1892 IF p_party_tbl.EXISTS(tab_row) THEN
1893
1894 PUT_LINE (' ');
1895 PUT_LINE ('Dumping the values for Instance Party Table Record # :'||tab_row);
1896 PUT_LINE (' ');
1897 PUT_LINE ('instance_party_id :'||p_party_tbl(tab_row).instance_party_id);
1898 PUT_LINE ('instance_id :'||p_party_tbl(tab_row).instance_id);
1899 PUT_LINE ('party_source_table :'||p_party_tbl(tab_row).party_source_table);
1900 PUT_LINE ('party_id :'||p_party_tbl(tab_row).party_id);
1901 PUT_LINE ('relationship_type_code :'||p_party_tbl(tab_row).relationship_type_code);
1902 PUT_LINE ('contact_flag :'||p_party_tbl(tab_row).contact_flag);
1903 PUT_LINE ('contact_ip_id :'||p_party_tbl(tab_row).contact_ip_id);
1904 PUT_LINE ('active_start_date :'||p_party_tbl(tab_row).active_start_date);
1905 PUT_LINE ('active_end_date :'||p_party_tbl(tab_row).active_end_date);
1906 PUT_LINE ('context :'||p_party_tbl(tab_row).context);
1907 PUT_LINE ('attribute1 :'||p_party_tbl(tab_row).attribute1);
1908 PUT_LINE ('attribute2 :'||p_party_tbl(tab_row).attribute2);
1909 PUT_LINE ('attribute3 :'||p_party_tbl(tab_row).attribute3);
1910 PUT_LINE ('attribute4 :'||p_party_tbl(tab_row).attribute4);
1911 PUT_LINE ('attribute5 :'||p_party_tbl(tab_row).attribute5);
1912 PUT_LINE ('attribute6 :'||p_party_tbl(tab_row).attribute6);
1913 PUT_LINE ('attribute7 :'||p_party_tbl(tab_row).attribute7);
1914 PUT_LINE ('attribute8 :'||p_party_tbl(tab_row).attribute8);
1915 PUT_LINE ('attribute9 :'||p_party_tbl(tab_row).attribute9);
1916 PUT_LINE ('attribute10 :'||p_party_tbl(tab_row).attribute10);
1917 PUT_LINE ('attribute11 :'||p_party_tbl(tab_row).attribute11);
1918 PUT_LINE ('attribute12 :'||p_party_tbl(tab_row).attribute12);
1919 PUT_LINE ('attribute13 :'||p_party_tbl(tab_row).attribute13);
1920 PUT_LINE ('attribute14 :'||p_party_tbl(tab_row).attribute14);
1921 PUT_LINE ('attribute15 :'||p_party_tbl(tab_row).attribute15);
1922 PUT_LINE ('object_version_number :'||p_party_tbl(tab_row).object_version_number);
1923 PUT_LINE ('contact_parent_tbl_index :'||p_party_tbl(tab_row).contact_parent_tbl_index);
1924 END IF;
1925 END LOOP;
1926 END IF;
1927 EXCEPTION
1928 WHEN OTHERS THEN
1929 -- ROLLBACK TO dump_party_tbl;
1930 IF FND_MSG_PUB.Check_Msg_Level
1931 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1932 THEN
1933 FND_MSG_PUB.Add_Exc_Msg
1934 ( g_pkg_name ,
1935 l_api_name );
1936 END IF;
1937 END dump_party_tbl;
1938
1939 PROCEDURE dump_version_label_rec
1940 ( p_version_label_rec IN csi_datastructures_pub.version_label_rec
1941 ) IS
1942
1943 l_api_name CONSTANT VARCHAR2(30) := 'dump_version_label_rec';
1944 l_api_version CONSTANT NUMBER := 1.0;
1945 BEGIN
1946
1947 -- Standard Start of API savepoint
1948 -- SAVEPOINT dump_version_label_rec;
1949
1950 PUT_LINE (' ');
1951 PUT_LINE ('Dumping the values for Version Labels Record:');
1952 PUT_LINE (' ');
1953 PUT_LINE ('version_label_id :'||p_version_label_rec.version_label_id);
1954 PUT_LINE ('instance_id :'||p_version_label_rec.instance_id);
1955 PUT_LINE ('version_label :'||p_version_label_rec.version_label);
1956 PUT_LINE ('description :'||p_version_label_rec.description);
1957 PUT_LINE ('date_time_stamp :'||p_version_label_rec.date_time_stamp);
1958 PUT_LINE ('active_start_date :'||p_version_label_rec.active_start_date);
1959 PUT_LINE ('active_end_date :'||p_version_label_rec.active_end_date);
1960 PUT_LINE ('context :'||p_version_label_rec.context);
1961 PUT_LINE ('attribute1 :'||p_version_label_rec.attribute1);
1962 PUT_LINE ('attribute2 :'||p_version_label_rec.attribute2);
1963 PUT_LINE ('attribute3 :'||p_version_label_rec.attribute3);
1967 PUT_LINE ('attribute7 :'||p_version_label_rec.attribute7);
1964 PUT_LINE ('attribute4 :'||p_version_label_rec.attribute4);
1965 PUT_LINE ('attribute5 :'||p_version_label_rec.attribute5);
1966 PUT_LINE ('attribute6 :'||p_version_label_rec.attribute6);
1968 PUT_LINE ('attribute8 :'||p_version_label_rec.attribute8);
1969 PUT_LINE ('attribute9 :'||p_version_label_rec.attribute9);
1970 PUT_LINE ('attribute10 :'||p_version_label_rec.attribute10);
1971 PUT_LINE ('attribute11 :'||p_version_label_rec.attribute11);
1972 PUT_LINE ('attribute12 :'||p_version_label_rec.attribute12);
1973 PUT_LINE ('attribute13 :'||p_version_label_rec.attribute13);
1974 PUT_LINE ('attribute14 :'||p_version_label_rec.attribute14);
1975 PUT_LINE ('attribute15 :'||p_version_label_rec.attribute15);
1976 PUT_LINE ('object_version_number :'||p_version_label_rec.object_version_number);
1977
1978 EXCEPTION
1979 WHEN OTHERS THEN
1980 -- ROLLBACK TO dump_version_label_rec;
1981 IF FND_MSG_PUB.Check_Msg_Level
1982 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1983 THEN
1984 FND_MSG_PUB.Add_Exc_Msg
1985 ( g_pkg_name ,
1986 l_api_name );
1987 END IF;
1988 END dump_version_label_rec;
1989
1990 PROCEDURE dump_version_label_tbl
1991 ( p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
1992 ) IS
1993
1994 l_api_name CONSTANT VARCHAR2(30) := 'dump_version_label_tbl';
1995 l_api_version CONSTANT NUMBER := 1.0;
1996 BEGIN
1997
1998 -- Standard Start of API savepoint
1999 -- SAVEPOINT dump_version_label_tbl;
2000
2001 IF p_version_label_tbl.COUNT > 0 THEN
2002 FOR tab_row IN p_version_label_tbl.FIRST .. p_version_label_tbl.LAST LOOP
2003
2004 PUT_LINE (' ');
2005 PUT_LINE ('Dumping the values for Version Labels Table Record # :'||tab_row);
2006 PUT_LINE (' ');
2007 PUT_LINE ('version_label_id :'||p_version_label_tbl(tab_row).version_label_id);
2008 PUT_LINE ('instance_id :'||p_version_label_tbl(tab_row).instance_id);
2009 PUT_LINE ('version_label :'||p_version_label_tbl(tab_row).version_label);
2010 PUT_LINE ('description :'||p_version_label_tbl(tab_row).description);
2011 PUT_LINE ('date_time_stamp :'||p_version_label_tbl(tab_row).date_time_stamp);
2012 PUT_LINE ('active_start_date :'||p_version_label_tbl(tab_row).active_start_date);
2013 PUT_LINE ('active_end_date :'||p_version_label_tbl(tab_row).active_end_date);
2014 PUT_LINE ('context :'||p_version_label_tbl(tab_row).context);
2015 PUT_LINE ('attribute1 :'||p_version_label_tbl(tab_row).attribute1);
2016 PUT_LINE ('attribute2 :'||p_version_label_tbl(tab_row).attribute2);
2017 PUT_LINE ('attribute3 :'||p_version_label_tbl(tab_row).attribute3);
2018 PUT_LINE ('attribute4 :'||p_version_label_tbl(tab_row).attribute4);
2019 PUT_LINE ('attribute5 :'||p_version_label_tbl(tab_row).attribute5);
2020 PUT_LINE ('attribute6 :'||p_version_label_tbl(tab_row).attribute6);
2021 PUT_LINE ('attribute7 :'||p_version_label_tbl(tab_row).attribute7);
2022 PUT_LINE ('attribute8 :'||p_version_label_tbl(tab_row).attribute8);
2023 PUT_LINE ('attribute9 :'||p_version_label_tbl(tab_row).attribute9);
2024 PUT_LINE ('attribute10 :'||p_version_label_tbl(tab_row).attribute10);
2025 PUT_LINE ('attribute11 :'||p_version_label_tbl(tab_row).attribute11);
2026 PUT_LINE ('attribute12 :'||p_version_label_tbl(tab_row).attribute12);
2027 PUT_LINE ('attribute13 :'||p_version_label_tbl(tab_row).attribute13);
2028 PUT_LINE ('attribute14 :'||p_version_label_tbl(tab_row).attribute14);
2029 PUT_LINE ('attribute15 :'||p_version_label_tbl(tab_row).attribute15);
2030 PUT_LINE ('object_version_number :'||p_version_label_tbl(tab_row).object_version_number);
2031 END LOOP;
2032 END IF;
2033 EXCEPTION
2034 WHEN OTHERS THEN
2035 -- ROLLBACK TO dump_version_label_tbl;
2036 IF FND_MSG_PUB.Check_Msg_Level
2037 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2038 THEN
2039 FND_MSG_PUB.Add_Exc_Msg
2040 ( g_pkg_name ,
2041 l_api_name );
2042 END IF;
2043 END dump_version_label_tbl;
2044
2045
2046 PROCEDURE dump_party_account_tbl
2047 (p_party_account_tbl IN csi_datastructures_pub.party_account_tbl
2048 ) IS
2049 l_api_name CONSTANT VARCHAR2(30) := 'DUMP_PARTY_ACCOUNT_TBL';
2050 l_api_version CONSTANT NUMBER := 1.0;
2051
2052 BEGIN
2053
2054 -- Standard Start of API savepoint
2055 -- SAVEPOINT dump_party_account_tbl;
2056
2057 IF p_party_account_tbl.COUNT > 0 THEN
2058 FOR tab_row IN p_party_account_tbl.FIRST .. p_party_account_tbl.LAST LOOP
2059
2060 PUT_LINE (' ');
2061 PUT_LINE ('Dumping the values for Instance Party Account Table Record # :'||tab_row);
2062 PUT_LINE (' ');
2063 PUT_LINE ('ip_account_id :'||p_party_account_tbl(tab_row).ip_account_id);
2064 PUT_LINE ('parent_tbl_index :'||p_party_account_tbl(tab_row).parent_tbl_index);
2065 PUT_LINE ('instance_party_id :'||p_party_account_tbl(tab_row).instance_party_id);
2066 PUT_LINE ('party_account_id :'||p_party_account_tbl(tab_row).party_account_id);
2070 PUT_LINE ('context :'||p_party_account_tbl(tab_row).context);
2067 PUT_LINE ('relationship_type_code :'||p_party_account_tbl(tab_row).relationship_type_code);
2068 PUT_LINE ('active_start_date :'||p_party_account_tbl(tab_row).active_start_date);
2069 PUT_LINE ('active_end_date :'||p_party_account_tbl(tab_row).active_end_date);
2071 PUT_LINE ('attribute1 :'||p_party_account_tbl(tab_row).attribute1);
2072 PUT_LINE ('attribute2 :'||p_party_account_tbl(tab_row).attribute2);
2073 PUT_LINE ('attribute3 :'||p_party_account_tbl(tab_row).attribute3);
2074 PUT_LINE ('attribute4 :'||p_party_account_tbl(tab_row).attribute4);
2075 PUT_LINE ('attribute5 :'||p_party_account_tbl(tab_row).attribute5);
2076 PUT_LINE ('attribute6 :'||p_party_account_tbl(tab_row).attribute6);
2077 PUT_LINE ('attribute7 :'||p_party_account_tbl(tab_row).attribute7);
2078 PUT_LINE ('attribute8 :'||p_party_account_tbl(tab_row).attribute8);
2079 PUT_LINE ('attribute9 :'||p_party_account_tbl(tab_row).attribute9);
2080 PUT_LINE ('attribute10 :'||p_party_account_tbl(tab_row).attribute10);
2081 PUT_LINE ('attribute11 :'||p_party_account_tbl(tab_row).attribute11);
2082 PUT_LINE ('attribute12 :'||p_party_account_tbl(tab_row).attribute12);
2083 PUT_LINE ('attribute13 :'||p_party_account_tbl(tab_row).attribute13);
2084 PUT_LINE ('attribute14 :'||p_party_account_tbl(tab_row).attribute14);
2085 PUT_LINE ('attribute15 :'||p_party_account_tbl(tab_row).attribute15);
2086 PUT_LINE ('object_version_number :'||p_party_account_tbl(tab_row).object_version_number);
2087 PUT_LINE ('call_contracts :'||p_party_account_tbl(tab_row).call_contracts);
2088
2089 END LOOP;
2090 END IF;
2091 EXCEPTION
2092 WHEN OTHERS THEN
2093 -- ROLLBACK TO dump_party_account_tbl;
2094 IF FND_MSG_PUB.Check_Msg_Level
2095 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2096 THEN
2097 FND_MSG_PUB.Add_Exc_Msg
2098 ( g_pkg_name ,
2099 l_api_name );
2100 END IF;
2101 END dump_party_account_tbl;
2102
2103 PROCEDURE dump_party_account_rec
2104 ( p_party_account_rec IN csi_datastructures_pub.party_account_rec
2105 ) IS
2106 l_api_name CONSTANT VARCHAR2(30) := 'dump_party_account_rec';
2107 l_api_version CONSTANT NUMBER := 1.0;
2108 BEGIN
2109 -- Standard Start of API savepoint
2110 -- SAVEPOINT dump_party_account_rec;
2111
2112 PUT_LINE (' ');
2113 PUT_LINE ('Dumping the values for Instance Party Account Record:');
2114 PUT_LINE (' ');
2115 PUT_LINE ('ip_account_id :'||p_party_account_rec.ip_account_id);
2116 PUT_LINE ('parent_tbl_index :'||p_party_account_rec.parent_tbl_index);
2117 PUT_LINE ('instance_party_id :'||p_party_account_rec.instance_party_id);
2118 PUT_LINE ('party_account_id :'||p_party_account_rec.party_account_id);
2119 PUT_LINE ('relationship_type_code :'||p_party_account_rec.relationship_type_code);
2120 PUT_LINE ('bill_to_address :'||p_party_account_rec.bill_to_address);
2121 PUT_LINE ('ship_to_address :'||p_party_account_rec.ship_to_address);
2122 PUT_LINE ('active_start_date :'||p_party_account_rec.active_start_date);
2123 PUT_LINE ('active_end_date :'||p_party_account_rec.active_end_date);
2124 PUT_LINE ('context :'||p_party_account_rec.context);
2125 PUT_LINE ('attribute1 :'||p_party_account_rec.attribute1);
2126 PUT_LINE ('attribute2 :'||p_party_account_rec.attribute2);
2127 PUT_LINE ('attribute3 :'||p_party_account_rec.attribute3);
2128 PUT_LINE ('attribute4 :'||p_party_account_rec.attribute4);
2129 PUT_LINE ('attribute5 :'||p_party_account_rec.attribute5);
2130 PUT_LINE ('attribute6 :'||p_party_account_rec.attribute6);
2131 PUT_LINE ('attribute7 :'||p_party_account_rec.attribute7);
2132 PUT_LINE ('attribute8 :'||p_party_account_rec.attribute8);
2133 PUT_LINE ('attribute9 :'||p_party_account_rec.attribute9);
2134 PUT_LINE ('attribute10 :'||p_party_account_rec.attribute10);
2135 PUT_LINE ('attribute11 :'||p_party_account_rec.attribute11);
2136 PUT_LINE ('attribute12 :'||p_party_account_rec.attribute12);
2137 PUT_LINE ('attribute13 :'||p_party_account_rec.attribute13);
2138 PUT_LINE ('attribute14 :'||p_party_account_rec.attribute14);
2139 PUT_LINE ('attribute15 :'||p_party_account_rec.attribute15);
2140 PUT_LINE ('object_version_number :'||p_party_account_rec.object_version_number);
2141 PUT_LINE ('call_contracts :'||p_party_account_rec.call_contracts);
2142
2143 EXCEPTION
2144 WHEN OTHERS THEN
2145 -- ROLLBACK TO dump_party_account_rec;
2146 IF FND_MSG_PUB.Check_Msg_Level
2147 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2148 THEN
2149 FND_MSG_PUB.Add_Exc_Msg
2150 ( g_pkg_name ,
2151 l_api_name );
2152 END IF;
2153 END dump_party_account_rec;
2154
2155
2156 PROCEDURE dump_account_query_rec
2157 (p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
2158 ) IS
2159
2160 l_api_name CONSTANT VARCHAR2(30) := 'dump_account_query_rec';
2161 l_api_version CONSTANT NUMBER := 1.0;
2162 BEGIN
2163 -- Standard Start of API savepoint
2167 PUT_LINE ('Dumping the values for Instance Party Account Query Record:');
2164 -- SAVEPOINT dump_account_query_rec;
2165
2166 PUT_LINE (' ');
2168 PUT_LINE (' ');
2169 PUT_LINE ('ip_account_id :'||p_account_query_rec.ip_account_id);
2170 PUT_LINE ('instance_party_id :'||p_account_query_rec.instance_party_id);
2171 PUT_LINE ('party_account_id :'||p_account_query_rec.party_account_id);
2172 PUT_LINE ('relationship_type_code :'||p_account_query_rec.relationship_type_code);
2173
2174 EXCEPTION
2175 WHEN OTHERS THEN
2176 -- ROLLBACK TO dump_account_query_rec;
2177 IF FND_MSG_PUB.Check_Msg_Level
2178 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2179 THEN
2180 FND_MSG_PUB.Add_Exc_Msg
2181 ( g_pkg_name ,
2182 l_api_name );
2183 END IF;
2184 END dump_account_query_rec ;
2185
2186 PROCEDURE dump_asset_query_rec
2187 ( p_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec
2188 ) IS
2189
2190 l_api_name CONSTANT VARCHAR2(30) := 'dump_asset_query_rec';
2191 l_api_version CONSTANT NUMBER := 1.0;
2192 BEGIN
2193 -- Standard Start of API savepoint
2194 -- SAVEPOINT dump_asset_query_rec;
2195
2196 PUT_LINE (' ');
2197 PUT_LINE ('Dumping the values for Instance Assets Query Record:');
2198 PUT_LINE (' ');
2199 PUT_LINE ('instance_asset_id :'||p_asset_query_rec.instance_asset_id);
2200 PUT_LINE ('instance_id :'||p_asset_query_rec.instance_id);
2201 PUT_LINE ('fa_asset_id :'||p_asset_query_rec.fa_asset_id);
2202 PUT_LINE ('fa_book_type_code :'||p_asset_query_rec.fa_book_type_code);
2203 PUT_LINE ('fa_location_id :'||p_asset_query_rec.fa_location_id);
2204 PUT_LINE ('update_status :'||p_asset_query_rec.update_status);
2205
2206 EXCEPTION
2207 WHEN OTHERS THEN
2208 -- ROLLBACK TO dump_asset_query_rec;
2209 IF FND_MSG_PUB.Check_Msg_Level
2210 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2211 THEN
2212 FND_MSG_PUB.Add_Exc_Msg
2213 ( g_pkg_name ,
2214 l_api_name );
2215 END IF;
2216 END dump_asset_query_rec ;
2217
2218 PROCEDURE dump_ver_label_query_rec
2219 ( p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec
2220 )IS
2221
2222 l_api_name CONSTANT VARCHAR2(30) := 'dump_ver_label_query_rec';
2223 l_api_version CONSTANT NUMBER := 1.0;
2224 BEGIN
2225 -- Standard Start of API savepoint
2226 -- SAVEPOINT dump_ver_label_query_rec;
2227
2228 PUT_LINE (' ');
2229 PUT_LINE ('Dumping the values for Version Labels Query Record:');
2230 PUT_LINE (' ');
2231 PUT_LINE ('version_label_id :'||p_version_label_query_rec.version_label_id);
2232 PUT_LINE ('instance_id :'||p_version_label_query_rec.instance_id);
2233 PUT_LINE ('version_label :'||p_version_label_query_rec.version_label);
2234 PUT_LINE ('date_time_stamp :'||p_version_label_query_rec.date_time_stamp);
2235
2236 EXCEPTION
2237 WHEN OTHERS THEN
2238 -- ROLLBACK TO dump_ver_label_query_rec;
2239 IF FND_MSG_PUB.Check_Msg_Level
2240 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2241 THEN
2242 FND_MSG_PUB.Add_Exc_Msg
2243 ( g_pkg_name ,
2244 l_api_name );
2245 END IF;
2246 END dump_ver_label_query_rec ;
2247
2248
2249 PROCEDURE dump_id_tbl
2250 (id_tbl IN csi_datastructures_pub.id_tbl)
2251 IS
2252 l_api_name CONSTANT VARCHAR2(30) := 'dump_id_tbl';
2253 l_api_version CONSTANT NUMBER := 1.0;
2254 BEGIN
2255
2256 -- Standard Start of API savepoint
2257 -- SAVEPOINT dump_id_tbl;
2258
2259 IF id_tbl.COUNT > 0 THEN
2260 FOR tab_row IN id_tbl.FIRST .. id_tbl.LAST LOOP
2261 PUT_LINE (
2262 id_tbl(tab_row));
2263 END LOOP;
2264 END IF;
2265
2266 EXCEPTION
2267 WHEN OTHERS THEN
2268 -- ROLLBACK TO dump_id_tbl;
2269
2270 IF FND_MSG_PUB.Check_Msg_Level
2271 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2272 THEN
2273 FND_MSG_PUB.Add_Exc_Msg
2274 ( g_pkg_name ,
2275 l_api_name
2276 );
2277 END IF;
2278
2279 END dump_id_tbl;
2280
2281 PROCEDURE dump_x_msg_data
2282 (p_msg_count IN NUMBER, x_msg_data OUT NOCOPY VARCHAR2)
2283 IS
2284 l_msg_index NUMBER:=0;
2285 l_msg_data VARCHAR2(2000):=NULL;
2286 l_msg_count NUMBER:=0;
2287 l_msg_dummy NUMBER:=0;
2288 BEGIN
2289 fnd_msg_pub.count_and_get
2290 ( p_count => l_msg_count,
2291 p_data => l_msg_data
2292 );
2293
2294 FOR l_msg_index IN 1..l_msg_count
2295 LOOP
2296 fnd_msg_pub.get ( l_msg_index
2297 , fnd_api.g_false
2298 , l_msg_data
2299 , l_msg_dummy );
2300 x_msg_data := ltrim(x_msg_data||' '||l_msg_data);
2301 END LOOP;
2302
2303 END dump_x_msg_data;
2304 --
2305 PROCEDURE dump_oks_txn_inst_tbl(p_oks_txn_inst_tbl IN oks_ibint_pub.txn_instance_tbl)
2306 IS
2307 BEGIN
2308 PUT_LINE('OKS_TXN_INST_TBL count is '||p_oks_txn_inst_tbl.count);
2309 IF p_oks_txn_inst_tbl.count > 0 THEN
2310 PUT_LINE ('Dumping the values passed to contracts ib_interface:');
2311 FOR J IN p_oks_txn_inst_tbl.FIRST .. p_oks_txn_inst_tbl.LAST LOOP
2312 IF p_oks_txn_inst_tbl.EXISTS(J) THEN
2313 PUT_LINE('Old_Customer_product_id : '||p_oks_txn_inst_tbl(J).Old_Customer_product_id);
2314 PUT_LINE('Old_Quantity : '||p_oks_txn_inst_tbl(J).Old_Quantity);
2315 PUT_LINE('Old_Unit_of_measur : '||p_oks_txn_inst_tbl(J).Old_Unit_of_measure);
2316 PUT_LINE('Old_Inventory_item_id : '||p_oks_txn_inst_tbl(J).Old_Inventory_item_id);
2317 PUT_LINE('Old_Customer_acct_id : '||p_oks_txn_inst_tbl(J).Old_Customer_acct_id);
2318 PUT_LINE('New_Customer_product_id : '||p_oks_txn_inst_tbl(J).New_Customer_product_id);
2319 PUT_LINE('New_Quantity : '||p_oks_txn_inst_tbl(J).New_Quantity);
2320 PUT_LINE('New_Customer_acct_id : '||p_oks_txn_inst_tbl(J).New_Customer_acct_id);
2321 PUT_LINE('New_inventory_item_id : '||p_oks_txn_inst_tbl(J).New_inventory_item_id);
2322 PUT_LINE('New_Unit_of_measure : '||p_oks_txn_inst_tbl(J).New_Unit_of_measure);
2323 PUT_LINE('Org_id : '||p_oks_txn_inst_tbl(J).Org_id);
2324 PUT_LINE('Order_line_id : '||p_oks_txn_inst_tbl(J).Order_line_id);
2325 PUT_LINE('Shipped_date : '||p_oks_txn_inst_tbl(J).Shipped_date);
2326 PUT_LINE('Installation_date : '||p_oks_txn_inst_tbl(J).Installation_date);
2327 PUT_LINE('Bill_to_site_use_id : '||p_oks_txn_inst_tbl(J).Bill_to_site_use_id);
2328 PUT_LINE('Ship_to_site_use_id : '||p_oks_txn_inst_tbl(J).Ship_to_site_use_id);
2329 PUT_LINE('Organization_id : '||p_oks_txn_inst_tbl(J).Organization_id);
2330 PUT_LINE('System_id : '||p_oks_txn_inst_tbl(J).System_id);
2331 PUT_LINE('Bom_explosion_flag : '||p_oks_txn_inst_tbl(J).Bom_explosion_flag);
2332 PUT_LINE('Return_reason_code : '||p_oks_txn_inst_tbl(J).Return_reason_code);
2333 PUT_LINE('Raise_credit : '||p_oks_txn_inst_tbl(J).Raise_credit);
2334 PUT_LINE('Transaction_date : '||p_oks_txn_inst_tbl(J).Transaction_date);
2335 PUT_LINE('Transfer_date : '||p_oks_txn_inst_tbl(J).Transfer_date);
2336 PUT_LINE('Termination_date : '||p_oks_txn_inst_tbl(J).Termination_date);
2337 PUT_LINE('TRM : '||p_oks_txn_inst_tbl(J).TRM);
2338 PUT_LINE('TRF : '||p_oks_txn_inst_tbl(J).TRF);
2339 PUT_LINE('RET : '||p_oks_txn_inst_tbl(J).RET);
2340 PUT_LINE('RPL : '||p_oks_txn_inst_tbl(J).RPL);
2341 PUT_LINE('IDC : '||p_oks_txn_inst_tbl(J).IDC);
2342 PUT_LINE('UPD : '||p_oks_txn_inst_tbl(J).UPD);
2343 PUT_LINE('SPL : '||p_oks_txn_inst_tbl(J).SPL);
2344 PUT_LINE('NEW : '||p_oks_txn_inst_tbl(J).NEW);
2345 PUT_LINE('RIN : '||p_oks_txn_inst_tbl(J).RIN);
2346 PUT_LINE('--------------------------------------------------------------------------');
2347 END IF;
2348 END LOOP;
2349 END IF;
2350 END dump_oks_txn_inst_tbl;
2351
2352 PROCEDURE dump_call_batch_val
2353 ( p_api_version IN NUMBER
2354 ,p_init_msg_list IN VARCHAR2
2355 ,p_parameter_name IN csi_datastructures_pub.parameter_name
2356 ,p_parameter_value IN csi_datastructures_pub.parameter_value
2357 )
2358 IS
2359 l_api_name CONSTANT VARCHAR2(30) := 'dump_call_batch_val';
2360 l_api_version CONSTANT NUMBER := 1.0;
2361 BEGIN
2362 -- Standard Start of API savepoint
2363 -- SAVEPOINT dump_call_batch_val;
2364 PUT_LINE ('Api_version :'||p_api_version);
2365 PUT_LINE ('Init_msg_list :'||p_init_msg_list);
2366 FOR tab_row IN p_parameter_name.FIRST..p_parameter_name.LAST
2367 LOOP
2368 PUT_LINE ('parameter_name :'||p_parameter_name(tab_row));
2369 PUT_LINE ('parameter_value :'||p_parameter_value(tab_row));
2370 END LOOP;
2371 EXCEPTION
2372 WHEN OTHERS THEN
2373 -- ROLLBACK TO dump_call_batch_val;
2374 IF FND_MSG_PUB.Check_Msg_Level
2375 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2376 THEN
2377 FND_MSG_PUB.Add_Exc_Msg
2378 ( g_pkg_name ,
2379 l_api_name
2380 );
2381 END IF;
2382 END dump_call_batch_val;
2383
2384 PROCEDURE Populate_Install_Param_Rec IS
2385 BEGIN
2386 SELECT INTERNAL_PARTY_ID
2387 ,NULL -- PROJECT_LOCATION_ID
2388 ,NULL -- WIP_LOCATION_ID
2389 ,NULL -- IN_TRANSIT_LOCATION_ID
2390 ,NULL -- PO_LOCATION_ID
2391 ,CATEGORY_SET_ID
2392 ,nvl(HISTORY_FULL_DUMP_FREQUENCY,10)
2393 ,nvl(FREEZE_FLAG,'N')
2394 ,FREEZE_DATE
2395 ,nvl(SHOW_ALL_PARTY_LOCATION,'N')
2396 ,nvl(OWNERSHIP_OVERRIDE_AT_TXN,'N')
2397 ,nvl(SFM_QUEUE_BYPASS_FLAG,'N')
2398 ,nvl(AUTO_ALLOCATE_COMP_AT_WIP,'N')
2399 ,TXN_SEQ_START_DATE
2400 ,nvl(OWNERSHIP_CASCADE_AT_TXN,'N')
2401 ,'Y'
2402 ,FA_CREATION_GROUP_BY
2403 INTO csi_datastructures_pub.G_INSTALL_PARAM_REC.INTERNAL_PARTY_ID
2404 ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PROJECT_LOCATION_ID
2405 ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID
2406 ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2407 ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2408 ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2409 ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2410 ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2411 ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2412 ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2413 ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2414 ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2415 ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2416 ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE
2417 ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN
2418 ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG
2419 ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FA_CREATION_GROUP_BY
2420 FROM CSI_INSTALL_PARAMETERS;
2421 EXCEPTION
2422 WHEN OTHERS THEN
2423 csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG := 'N';
2424 END Populate_Install_Param_Rec;
2425 --
2426 FUNCTION IB_ACTIVE RETURN BOOLEAN IS
2427 l_freeze_flag VARCHAR2(1) := 'N';
2428 BEGIN
2429 IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
2430 csi_gen_utility_pvt.populate_install_param_rec;
2431 END IF;
2432 --
2433 l_freeze_flag := csi_datastructures_pub.g_install_param_rec.freeze_flag;
2434 --
2435 IF nvl(l_freeze_flag,'N') = 'Y' THEN
2436 return TRUE;
2437 ELSE
2438 return FALSE;
2439 END IF;
2440 END IB_ACTIVE;
2441
2442 FUNCTION is_eib_installed RETURN VARCHAR2
2443 IS
2444 l_eib_installed VARCHAR2(1) := 'N' ;
2445 l_temp VARCHAR2(40);
2446 l_app_info BOOLEAN;
2447 BEGIN
2448 IF (CSI_GEN_UTILITY_PVT.g_cse_install is NULL)
2449 THEN
2450 l_app_info := fnd_installation.get_app_info('CSE',
2451 CSI_GEN_UTILITY_PVT.g_cse_install, l_temp, l_temp);
2452 END IF;
2453
2454 IF (CSI_GEN_UTILITY_PVT.g_cse_install = 'I')
2455 THEN
2456 l_eib_installed := 'Y';
2457 ELSE
2458 l_eib_installed := 'N';
2459 END IF;
2460 RETURN l_eib_installed ;
2461
2462 END is_eib_installed ;
2463
2464 END CSI_GEN_UTILITY_PVT;