[Home] [Help]
TYPE BODY: APPS.CSI_ITEM_INSTANCE_OBJ
Source
1 TYPE BODY CSI_ITEM_INSTANCE_OBJ AS
2 CONSTRUCTOR FUNCTION CSI_ITEM_INSTANCE_OBJ(p_instance_id NUMBER)
3 RETURN SELF AS RESULT
4 AS
5 l_debug_level NUMBER := 0;
6 BEGIN
7 -- Check the profile option debug_level for debug message reporting
8 l_debug_level := fnd_profile.value('CSI_DEBUG_LEVEL');
9
10 IF (l_debug_level > 0) THEN
11 csi_gen_utility_pvt.put_line('Inside constructor for CSI_ITEM_INSTANCE_OBJ');
12 csi_gen_utility_pvt.put_line(' Instance Id: '||p_instance_id);
13 END IF;
14
15 IF p_instance_id IS NOT NULL THEN
16 BEGIN
17 SELECT CII.INSTANCE_ID,
18 CII.INSTANCE_NUMBER,
19 CII.INSTANCE_DESCRIPTION,
20 CII.SERIAL_NUMBER,
21 CII.MFG_SERIAL_NUMBER_FLAG,
22 CII.INV_MASTER_ORGANIZATION_ID,
23 HAOU.NAME,
24 MP.ORGANIZATION_CODE,
25 CII.LAST_VLD_ORGANIZATION_ID,
26 CII.INVENTORY_ITEM_ID,
27 MSI.CONCATENATED_SEGMENTS,
28 MSI.DESCRIPTION,
29 CII.INVENTORY_REVISION,
30 CII.SYSTEM_ID,
31 CII.OWNER_PARTY_SOURCE_TABLE,
32 CII.OWNER_PARTY_ID,
33 CII.OWNER_PARTY_ACCOUNT_ID,
34 CII.EXTERNAL_REFERENCE,
35 CII.LOT_NUMBER,
36 CII.QUANTITY,
37 CII.UNIT_OF_MEASURE,
38 CII.ACCOUNTING_CLASS_CODE,
39 CII.INSTANCE_CONDITION_ID,
40 CII.INSTANCE_USAGE_CODE,
41 CII.INSTANCE_TYPE_CODE,
42 CII.INSTANCE_STATUS_ID,
43 CIS.NAME,
44 CIS.DESCRIPTION,
45 CII.CUSTOMER_VIEW_FLAG,
46 CII.MERCHANT_VIEW_FLAG,
47 CII.SELLABLE_FLAG,
48 CII.LOCATION_TYPE_CODE,
49 CII.LOCATION_ID,
50 CII.INV_ORGANIZATION_ID,
51 CII.INV_SUBINVENTORY_NAME,
52 CII.INV_LOCATOR_ID,
53 CII.PA_PROJECT_ID,
54 CII.PA_PROJECT_TASK_ID,
55 CII.IN_TRANSIT_ORDER_LINE_ID,
56 CII.WIP_JOB_ID,
57 CII.PO_ORDER_LINE_ID,
58 CII.LAST_OE_ORDER_LINE_ID,
59 CII.LAST_OE_RMA_LINE_ID,
60 CII.LAST_PO_PO_LINE_ID,
61 CII.LAST_OE_PO_NUMBER,
62 CII.LAST_WIP_JOB_ID,
63 CII.LAST_PA_PROJECT_ID,
64 CII.LAST_PA_TASK_ID,
65 CII.LAST_OE_AGREEMENT_ID,
66 CII.LAST_TXN_LINE_DETAIL_ID,
67 CII.MANUALLY_CREATED_FLAG,
68 CII.INSTALL_DATE,
69 CII.INSTALL_LOCATION_TYPE_CODE,
70 CII.INSTALL_LOCATION_ID,
71 CII.RETURN_BY_DATE,
72 CII.ACTUAL_RETURN_DATE,
73 CII.ACTIVE_START_DATE,
74 CII.ACTIVE_END_DATE,
75 CII.CREATION_COMPLETE_FLAG,
76 CII.COMPLETENESS_FLAG,
77 CII.SECURITY_GROUP_ID,
78 CII.MIGRATED_FLAG,
79 CII.REQUEST_ID,
80 CII.PROGRAM_APPLICATION_ID,
81 CII.PROGRAM_ID,
82 CII.PROGRAM_UPDATE_DATE,
83 CII.CONFIG_INST_HDR_ID,
84 CII.CONFIG_INST_REV_NUM,
85 CII.CONFIG_INST_ITEM_ID,
86 CII.CONFIG_VALID_STATUS,
87 CII.LAST_PURGE_DATE,
88 CII.NETWORK_ASSET_FLAG,
89 CII.MAINTAINABLE_FLAG,
90 CII.PN_LOCATION_ID,
91 CII.ASSET_CRITICALITY_CODE,
92 CII.CATEGORY_ID,
93 CII.EQUIPMENT_GEN_OBJECT_ID,
94 CII.INSTANTIATION_FLAG,
95 CII.LINEAR_LOCATION_ID,
96 CII.OPERATIONAL_LOG_FLAG,
97 CII.CHECKIN_STATUS,
98 CII.SUPPLIER_WARRANTY_EXP_DATE,
99 CII.PURCHASE_UNIT_PRICE,
100 CII.PURCHASE_CURRENCY_CODE,
101 CII.PAYABLES_UNIT_PRICE,
102 CII.PAYABLES_CURRENCY_CODE,
103 CII.SALES_UNIT_PRICE,
104 CII.SALES_CURRENCY_CODE,
105 CII.OPERATIONAL_STATUS_CODE,
106 CII.SOURCE_CODE,
107 CII.CONTEXT,
108 CII.ATTRIBUTE1,
109 CII.ATTRIBUTE2,
110 CII.ATTRIBUTE3,
111 CII.ATTRIBUTE4,
112 CII.ATTRIBUTE5,
113 CII.ATTRIBUTE6,
114 CII.ATTRIBUTE7,
115 CII.ATTRIBUTE8,
116 CII.ATTRIBUTE9,
117 CII.ATTRIBUTE10,
118 CII.ATTRIBUTE11,
119 CII.ATTRIBUTE12,
120 CII.ATTRIBUTE13,
121 CII.ATTRIBUTE14,
122 CII.ATTRIBUTE15,
123 CII.ATTRIBUTE16,
124 CII.ATTRIBUTE17,
125 CII.ATTRIBUTE18,
126 CII.ATTRIBUTE19,
127 CII.ATTRIBUTE20,
128 CII.ATTRIBUTE21,
129 CII.ATTRIBUTE22,
130 CII.ATTRIBUTE23,
131 CII.ATTRIBUTE24,
132 CII.ATTRIBUTE25,
136 CII.ATTRIBUTE29,
133 CII.ATTRIBUTE26,
134 CII.ATTRIBUTE27,
135 CII.ATTRIBUTE28,
137 CII.ATTRIBUTE30,
138 CII.CREATED_BY,
139 CII.CREATION_DATE,
140 CII.LAST_UPDATED_BY,
141 CII.LAST_UPDATE_DATE,
142 CII.LAST_UPDATE_LOGIN,
143 CII.OBJECT_VERSION_NUMBER
144 INTO SELF.INSTANCE_ID,
145 SELF.INSTANCE_NUMBER,
146 SELF.INSTANCE_DESCRIPTION,
147 SELF.SERIAL_NUMBER,
148 SELF.MFG_SERIAL_NUMBER_FLAG,
149 SELF.INV_MASTER_ORGANIZATION_ID,
150 SELF.INV_MASTER_ORGANIZATION_NAME,
151 SELF.INV_MASTER_ORGANIZATION_CODE,
152 SELF.LAST_VLD_ORGANIZATION_ID,
153 SELF.INVENTORY_ITEM_ID,
154 SELF.INVENTORY_ITEM_NAME,
155 SELF.INVENTORY_ITEM_DESCRIPTION,
156 SELF.INVENTORY_REVISION,
157 SELF.SYSTEM_ID,
158 SELF.OWNER_PARTY_SOURCE_TABLE,
159 SELF.OWNER_PARTY_ID,
160 SELF.OWNER_PARTY_ACCOUNT_ID,
161 SELF.EXTERNAL_REFERENCE,
162 SELF.LOT_NUMBER,
163 SELF.QUANTITY,
164 SELF.UNIT_OF_MEASURE,
165 SELF.ACCOUNTING_CLASS_CODE,
166 SELF.INSTANCE_CONDITION_ID,
167 SELF.INSTANCE_USAGE_CODE,
168 SELF.INSTANCE_TYPE_CODE,
169 SELF.INSTANCE_STATUS_ID,
170 SELF.INSTANCE_STATUS_NAME,
171 SELF.INSTANCE_STATUS_DESCRIPTION,
172 SELF.CUSTOMER_VIEW_FLAG,
173 SELF.MERCHANT_VIEW_FLAG,
174 SELF.SELLABLE_FLAG,
175 SELF.LOCATION_TYPE_CODE,
176 SELF.LOCATION_ID,
177 SELF.INV_ORGANIZATION_ID,
178 SELF.INV_SUBINVENTORY_NAME,
179 SELF.INV_LOCATOR_ID,
180 SELF.PA_PROJECT_ID,
181 SELF.PA_PROJECT_TASK_ID,
182 SELF.IN_TRANSIT_ORDER_LINE_ID,
183 SELF.WIP_JOB_ID,
184 SELF.PO_ORDER_LINE_ID,
185 SELF.LAST_OE_ORDER_LINE_ID,
186 SELF.LAST_OE_RMA_LINE_ID,
187 SELF.LAST_PO_PO_LINE_ID,
188 SELF.LAST_OE_PO_NUMBER,
189 SELF.LAST_WIP_JOB_ID,
190 SELF.LAST_PA_PROJECT_ID,
191 SELF.LAST_PA_TASK_ID,
192 SELF.LAST_OE_AGREEMENT_ID,
193 SELF.LAST_TXN_LINE_DETAIL_ID,
194 SELF.MANUALLY_CREATED_FLAG,
195 SELF.INSTALL_DATE,
196 SELF.INSTALL_LOCATION_TYPE_CODE,
197 SELF.INSTALL_LOCATION_ID,
198 SELF.RETURN_BY_DATE,
199 SELF.ACTUAL_RETURN_DATE,
200 SELF.ACTIVE_START_DATE,
201 SELF.ACTIVE_END_DATE,
202 SELF.CREATION_COMPLETE_FLAG,
203 SELF.COMPLETENESS_FLAG,
204 SELF.SECURITY_GROUP_ID,
205 SELF.MIGRATED_FLAG,
206 SELF.REQUEST_ID,
207 SELF.PROGRAM_APPLICATION_ID,
208 SELF.PROGRAM_ID,
209 SELF.PROGRAM_UPDATE_DATE,
210 SELF.CONFIG_INST_HDR_ID,
211 SELF.CONFIG_INST_REV_NUM,
212 SELF.CONFIG_INST_ITEM_ID,
213 SELF.CONFIG_VALID_STATUS,
214 SELF.LAST_PURGE_DATE,
215 SELF.NETWORK_ASSET_FLAG,
216 SELF.MAINTAINABLE_FLAG,
217 SELF.PN_LOCATION_ID,
218 SELF.ASSET_CRITICALITY_CODE,
219 SELF.CATEGORY_ID,
220 SELF.EQUIPMENT_GEN_OBJECT_ID,
221 SELF.INSTANTIATION_FLAG,
222 SELF.LINEAR_LOCATION_ID,
223 SELF.OPERATIONAL_LOG_FLAG,
224 SELF.CHECKIN_STATUS,
225 SELF.SUPPLIER_WARRANTY_EXP_DATE,
226 SELF.PURCHASE_UNIT_PRICE,
227 SELF.PURCHASE_CURRENCY_CODE,
228 SELF.PAYABLES_UNIT_PRICE,
229 SELF.PAYABLES_CURRENCY_CODE,
230 SELF.SALES_UNIT_PRICE,
231 SELF.SALES_CURRENCY_CODE,
232 SELF.OPERATIONAL_STATUS_CODE,
233 SELF.SOURCE_CODE,
234 SELF.CONTEXT,
235 SELF.ATTRIBUTE1,
236 SELF.ATTRIBUTE2,
237 SELF.ATTRIBUTE3,
238 SELF.ATTRIBUTE4,
239 SELF.ATTRIBUTE5,
240 SELF.ATTRIBUTE6,
241 SELF.ATTRIBUTE7,
242 SELF.ATTRIBUTE8,
243 SELF.ATTRIBUTE9,
244 SELF.ATTRIBUTE10,
245 SELF.ATTRIBUTE11,
246 SELF.ATTRIBUTE12,
247 SELF.ATTRIBUTE13,
248 SELF.ATTRIBUTE14,
249 SELF.ATTRIBUTE15,
250 SELF.ATTRIBUTE16,
251 SELF.ATTRIBUTE17,
252 SELF.ATTRIBUTE18,
253 SELF.ATTRIBUTE19,
254 SELF.ATTRIBUTE20,
255 SELF.ATTRIBUTE21,
256 SELF.ATTRIBUTE22,
257 SELF.ATTRIBUTE23,
258 SELF.ATTRIBUTE24,
259 SELF.ATTRIBUTE25,
260 SELF.ATTRIBUTE26,
261 SELF.ATTRIBUTE27,
262 SELF.ATTRIBUTE28,
266 SELF.CREATION_DATE,
263 SELF.ATTRIBUTE29,
264 SELF.ATTRIBUTE30,
265 SELF.CREATED_BY,
267 SELF.LAST_UPDATED_BY,
268 SELF.LAST_UPDATE_DATE,
269 SELF.LAST_UPDATE_LOGIN,
270 SELF.OBJECT_VERSION_NUMBER
271 FROM CSI_ITEM_INSTANCES CII,
272 HR_ALL_ORGANIZATION_UNITS HAOU,
273 MTL_PARAMETERS MP,
274 MTL_SYSTEM_ITEMS_KFV MSI,
275 CSI_INSTANCE_STATUSES CIS
276 WHERE CII.INSTANCE_ID = p_instance_id
277 AND CII.INV_MASTER_ORGANIZATION_ID = HAOU.ORGANIZATION_ID
278 AND CII.INV_MASTER_ORGANIZATION_ID = MP.ORGANIZATION_ID
279 AND CII.LAST_VLD_ORGANIZATION_ID = MSI.ORGANIZATION_ID
280 AND CII.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
281 AND CII.INSTANCE_STATUS_ID = CIS.INSTANCE_STATUS_ID;
282 EXCEPTION
283 WHEN NO_DATA_FOUND THEN
284 IF (l_debug_level > 1) THEN
285 csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '
286 ||'No item found with instance id '||p_instance_id);
287 END IF;
288 FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');
289 FND_MESSAGE.SET_TOKEN('ERROR','No item found with instance id '||p_instance_id);
290 FND_MSG_PUB.Add;
291 RAISE FND_API.G_EXC_ERROR;
292 END;
293
294 -- Fill the other fields
295 IF SELF.LAST_VLD_ORGANIZATION_ID IS NOT NULL THEN
296 IF (l_debug_level > 1) THEN
297 csi_gen_utility_pvt.put_line(' LAST_VLD_ORGANIZATION_ID is not null.');
298 END IF;
299 SELECT HAOU.NAME,
300 MP.ORGANIZATION_CODE
301 INTO SELF.LAST_VLD_ORGANIZATION_NAME,
302 SELF.LAST_VLD_ORGANIZATION_CODE
303 FROM HR_ALL_ORGANIZATION_UNITS HAOU,
304 MTL_PARAMETERS MP
305 WHERE HAOU.ORGANIZATION_ID = SELF.LAST_VLD_ORGANIZATION_ID
306 AND MP.ORGANIZATION_ID = SELF.LAST_VLD_ORGANIZATION_ID;
307 END IF;
308
309 IF SELF.SYSTEM_ID IS NOT NULL THEN
310 IF (l_debug_level > 1) THEN
311 csi_gen_utility_pvt.put_line(' SYSTEM_ID is not null.');
312 END IF;
313 SELECT CSV.NAME,
314 CSV.DESCRIPTION,
315 CSV.SYSTEM_TYPE_CODE,
316 CSV.SYSTEM_NUMBER,
317 CSV.CUSTOMER_ID,
318 HCA.ACCOUNT_NAME,
319 HCA.ACCOUNT_NUMBER
320 INTO SELF.SYSTEM_NAME,
321 SELF.SYSTEM_DESCRIPTION,
322 SELF.SYSTEM_TYPE_CODE,
323 SELF.SYSTEM_NUMBER,
324 SELF.CUSTOMER_ID,
325 SELF.CUSTOMER_NAME,
326 SELF.CUSTOMER_NUMBER
327 FROM CSI_SYSTEMS_VL CSV,
328 HZ_CUST_ACCOUNTS HCA
329 WHERE CSV.SYSTEM_ID = SELF.SYSTEM_ID
330 AND CSV.CUSTOMER_ID = HCA.CUST_ACCOUNT_ID;
331 END IF;
332
333 IF SELF.OWNER_PARTY_ACCOUNT_ID IS NOT NULL THEN
334 IF (l_debug_level > 1) THEN
335 csi_gen_utility_pvt.put_line(' OWNER_PARTY_ACCOUNT_ID is not null.');
336 END IF;
337 SELECT ACCOUNT_NAME,
338 ACCOUNT_NUMBER
339 INTO SELF.OWNER_PARTY_ACCOUNT_NAME,
340 SELF.OWNER_PARTY_ACCOUNT_NUMBER
341 FROM HZ_CUST_ACCOUNTS
342 WHERE CUST_ACCOUNT_ID = SELF.OWNER_PARTY_ACCOUNT_ID;
343 END IF;
344
345 IF SELF.INV_ORGANIZATION_ID IS NOT NULL THEN
346 IF (l_debug_level > 1) THEN
347 csi_gen_utility_pvt.put_line(' INV_ORGANIZATION_ID is not null.');
348 END IF;
349 SELECT HAOU.NAME,
350 MP.ORGANIZATION_CODE
351 INTO SELF.INV_ORGANIZATION_NAME,
352 SELF.INV_ORGANIZATION_CODE
353 FROM HR_ALL_ORGANIZATION_UNITS HAOU,
354 MTL_PARAMETERS MP
355 WHERE HAOU.ORGANIZATION_ID = SELF.INV_ORGANIZATION_ID
356 AND MP.ORGANIZATION_ID = SELF.INV_ORGANIZATION_ID;
357 END IF;
358
359 -- Get relationship type, parent and root parent if any
360 -- We only care about 'COMPONENT-OF' relationship for now
361 BEGIN
362 SELECT CIR.RELATIONSHIP_TYPE_CODE,
363 CIR.OBJECT_ID
364 INTO SELF.RELATIONSHIP_TYPE_CODE,
365 SELF.PARENT_INSTANCE_ID
366 FROM CSI_II_RELATIONSHIPS CIR
367 WHERE CIR.SUBJECT_ID = SELF.INSTANCE_ID
368 AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
369 AND CIR.ACTIVE_END_DATE IS NULL;
370 EXCEPTION
371 WHEN NO_DATA_FOUND THEN
372 -- The instance is not in a relationship
373 IF (l_debug_level > 1) THEN
374 csi_gen_utility_pvt.put_line(' Instance with Id: '||SELF.INSTANCE_ID
375 ||' is not a child instance in a COMPONENT-OF relationship');
376 END IF;
377 END;
378
379 BEGIN
380 -- If the instance is not in a 'COMPONET-OF' relationship, its root parent is itself
381 SELF.ROOT_PARENT_INSTANCE_ID := NVL(CSI_II_RELATIONSHIPS_PVT.GET_ROOT_PARENT(
385 IF (l_debug_level > 1) THEN
382 SELF.INSTANCE_ID, 'COMPONENT-OF',SELF.PARENT_INSTANCE_ID), SELF.INSTANCE_ID);
383 EXCEPTION
384 WHEN OTHERS THEN
386 csi_gen_utility_pvt.put_line(' Unable to get root parent instance id.');
387 END IF;
388 RAISE FND_API.G_EXC_ERROR;
389 END;
390 END IF;
391
392 -- Dump content in debug log
393 IF (l_debug_level > 1) THEN
394 csi_gen_utility_pvt.put_line('Dumping CSI_ITEM_INSTANCE_OBJ Content');
395 csi_gen_utility_pvt.put_line(' INSTANCE_ID : '||SELF.INSTANCE_ID);
396 csi_gen_utility_pvt.put_line(' INSTANCE_NUMBER : '||SELF.INSTANCE_NUMBER);
397 csi_gen_utility_pvt.put_line(' INSTANCE_DESCRIPTION : '||SELF.INSTANCE_DESCRIPTION);
398 csi_gen_utility_pvt.put_line(' SERIAL_NUMBER : '||SELF.SERIAL_NUMBER);
399 csi_gen_utility_pvt.put_line(' MFG_SERIAL_NUMBER_FLAG : '||SELF.MFG_SERIAL_NUMBER_FLAG);
400 csi_gen_utility_pvt.put_line(' INV_MASTER_ORGANIZATION_ID : '||SELF.INV_MASTER_ORGANIZATION_ID);
401 csi_gen_utility_pvt.put_line(' INV_MASTER_ORGANIZATION_NAME : '||SELF.INV_MASTER_ORGANIZATION_NAME);
402 csi_gen_utility_pvt.put_line(' INV_MASTER_ORGANIZATION_CODE : '||SELF.INV_MASTER_ORGANIZATION_CODE);
403 csi_gen_utility_pvt.put_line(' LAST_VLD_ORGANIZATION_ID : '||SELF.LAST_VLD_ORGANIZATION_ID);
404 csi_gen_utility_pvt.put_line(' LAST_VLD_ORGANIZATION_NAME : '||SELF.LAST_VLD_ORGANIZATION_NAME);
405 csi_gen_utility_pvt.put_line(' LAST_VLD_ORGANIZATION_CODE : '||SELF.LAST_VLD_ORGANIZATION_CODE);
406 csi_gen_utility_pvt.put_line(' INVENTORY_ITEM_ID : '||SELF.INVENTORY_ITEM_ID);
407 csi_gen_utility_pvt.put_line(' INVENTORY_ITEM_NAME : '||SELF.INVENTORY_ITEM_NAME);
408 csi_gen_utility_pvt.put_line(' INVENTORY_ITEM_DESCRIPTION : '||SELF.INVENTORY_ITEM_DESCRIPTION);
409 csi_gen_utility_pvt.put_line(' INVENTORY_REVISION : '||SELF.INVENTORY_REVISION);
410 csi_gen_utility_pvt.put_line(' SYSTEM_ID : '||SELF.SYSTEM_ID);
411 csi_gen_utility_pvt.put_line(' SYSTEM_NAME : '||SELF.SYSTEM_NAME);
412 csi_gen_utility_pvt.put_line(' SYSTEM_DESCRIPTION : '||SELF.SYSTEM_DESCRIPTION);
413 csi_gen_utility_pvt.put_line(' SYSTEM_TYPE_CODE : '||SELF.SYSTEM_TYPE_CODE);
414 csi_gen_utility_pvt.put_line(' SYSTEM_NUMBER : '||SELF.SYSTEM_NUMBER);
415 csi_gen_utility_pvt.put_line(' OWNER_PARTY_SOURCE_TABLE : '||SELF.OWNER_PARTY_SOURCE_TABLE);
416 csi_gen_utility_pvt.put_line(' OWNER_PARTY_ID : '||SELF.OWNER_PARTY_ID);
417 csi_gen_utility_pvt.put_line(' OWNER_PARTY_ACCOUNT_ID : '||SELF.OWNER_PARTY_ACCOUNT_ID);
418 csi_gen_utility_pvt.put_line(' OWNER_PARTY_ACCOUNT_NAME : '||SELF.OWNER_PARTY_ACCOUNT_NAME);
419 csi_gen_utility_pvt.put_line(' OWNER_PARTY_ACCOUNT_NUMBER : '||SELF.OWNER_PARTY_ACCOUNT_NUMBER);
420 csi_gen_utility_pvt.put_line(' CUSTOMER_ID : '||SELF.CUSTOMER_ID);
421 csi_gen_utility_pvt.put_line(' CUSTOMER_NAME : '||SELF.CUSTOMER_NAME);
422 csi_gen_utility_pvt.put_line(' CUSTOMER_NUMBER : '||SELF.CUSTOMER_NUMBER);
423 csi_gen_utility_pvt.put_line(' EXTERNAL_REFERENCE : '||SELF.EXTERNAL_REFERENCE);
424 csi_gen_utility_pvt.put_line(' LOT_NUMBER : '||SELF.LOT_NUMBER);
425 csi_gen_utility_pvt.put_line(' QUANTITY : '||SELF.QUANTITY);
426 csi_gen_utility_pvt.put_line(' UNIT_OF_MEASURE : '||SELF.UNIT_OF_MEASURE);
427 csi_gen_utility_pvt.put_line(' ACCOUNTING_CLASS_CODE : '||SELF.ACCOUNTING_CLASS_CODE);
428 csi_gen_utility_pvt.put_line(' INSTANCE_CONDITION_ID : '||SELF.INSTANCE_CONDITION_ID);
429 csi_gen_utility_pvt.put_line(' INSTANCE_USAGE_CODE : '||SELF.INSTANCE_USAGE_CODE);
430 csi_gen_utility_pvt.put_line(' INSTANCE_TYPE_CODE : '||SELF.INSTANCE_TYPE_CODE);
431 csi_gen_utility_pvt.put_line(' INSTANCE_STATUS_ID : '||SELF.INSTANCE_STATUS_ID);
432 csi_gen_utility_pvt.put_line(' INSTANCE_STATUS_NAME : '||SELF.INSTANCE_STATUS_NAME);
433 csi_gen_utility_pvt.put_line(' INSTANCE_STATUS_DESCRIPTION : '||SELF.INSTANCE_STATUS_DESCRIPTION);
434 csi_gen_utility_pvt.put_line(' CUSTOMER_VIEW_FLAG : '||SELF.CUSTOMER_VIEW_FLAG);
435 csi_gen_utility_pvt.put_line(' MERCHANT_VIEW_FLAG : '||SELF.MERCHANT_VIEW_FLAG);
436 csi_gen_utility_pvt.put_line(' SELLABLE_FLAG : '||SELF.SELLABLE_FLAG);
437 csi_gen_utility_pvt.put_line(' LOCATION_TYPE_CODE : '||SELF.LOCATION_TYPE_CODE);
438 csi_gen_utility_pvt.put_line(' LOCATION_ID : '||SELF.LOCATION_ID);
439 csi_gen_utility_pvt.put_line(' INV_ORGANIZATION_ID : '||SELF.INV_ORGANIZATION_ID);
440 csi_gen_utility_pvt.put_line(' INV_ORGANIZATION_NAME : '||SELF.INV_ORGANIZATION_NAME);
441 csi_gen_utility_pvt.put_line(' INV_ORGANIZATION_CODE : '||SELF.INV_ORGANIZATION_CODE);
442 csi_gen_utility_pvt.put_line(' INV_SUBINVENTORY_NAME : '||SELF.INV_SUBINVENTORY_NAME);
443 csi_gen_utility_pvt.put_line(' INV_LOCATOR_ID : '||SELF.INV_LOCATOR_ID);
444 csi_gen_utility_pvt.put_line(' PA_PROJECT_ID : '||SELF.PA_PROJECT_ID);
445 csi_gen_utility_pvt.put_line(' PA_PROJECT_TASK_ID : '||SELF.PA_PROJECT_TASK_ID);
446 csi_gen_utility_pvt.put_line(' IN_TRANSIT_ORDER_LINE_ID : '||SELF.IN_TRANSIT_ORDER_LINE_ID);
450 csi_gen_utility_pvt.put_line(' LAST_OE_RMA_LINE_ID : '||SELF.LAST_OE_RMA_LINE_ID);
447 csi_gen_utility_pvt.put_line(' WIP_JOB_ID : '||SELF.WIP_JOB_ID);
448 csi_gen_utility_pvt.put_line(' PO_ORDER_LINE_ID : '||SELF.PO_ORDER_LINE_ID);
449 csi_gen_utility_pvt.put_line(' LAST_OE_ORDER_LINE_ID : '||SELF.LAST_OE_ORDER_LINE_ID);
451 csi_gen_utility_pvt.put_line(' LAST_PO_PO_LINE_ID : '||SELF.LAST_PO_PO_LINE_ID);
452 csi_gen_utility_pvt.put_line(' LAST_OE_PO_NUMBER : '||SELF.LAST_OE_PO_NUMBER);
453 csi_gen_utility_pvt.put_line(' LAST_WIP_JOB_ID : '||SELF.LAST_WIP_JOB_ID);
454 csi_gen_utility_pvt.put_line(' LAST_PA_PROJECT_ID : '||SELF.LAST_PA_PROJECT_ID);
455 csi_gen_utility_pvt.put_line(' LAST_PA_TASK_ID : '||SELF.LAST_PA_TASK_ID);
456 csi_gen_utility_pvt.put_line(' LAST_OE_AGREEMENT_ID : '||SELF.LAST_OE_AGREEMENT_ID);
457 csi_gen_utility_pvt.put_line(' LAST_TXN_LINE_DETAIL_ID : '||SELF.LAST_TXN_LINE_DETAIL_ID);
458 csi_gen_utility_pvt.put_line(' MANUALLY_CREATED_FLAG : '||SELF.MANUALLY_CREATED_FLAG);
459 csi_gen_utility_pvt.put_line(' INSTALL_DATE : '||SELF.INSTALL_DATE);
460 csi_gen_utility_pvt.put_line(' INSTALL_LOCATION_TYPE_CODE : '||SELF.INSTALL_LOCATION_TYPE_CODE);
461 csi_gen_utility_pvt.put_line(' INSTALL_LOCATION_ID : '||SELF.INSTALL_LOCATION_ID);
462 csi_gen_utility_pvt.put_line(' RETURN_BY_DATE : '||SELF.RETURN_BY_DATE);
463 csi_gen_utility_pvt.put_line(' ACTUAL_RETURN_DATE : '||SELF.ACTUAL_RETURN_DATE);
464 csi_gen_utility_pvt.put_line(' ACTIVE_START_DATE : '||SELF.ACTIVE_START_DATE);
465 csi_gen_utility_pvt.put_line(' ACTIVE_END_DATE : '||SELF.ACTIVE_END_DATE);
466 csi_gen_utility_pvt.put_line(' CREATION_COMPLETE_FLAG : '||SELF.CREATION_COMPLETE_FLAG);
467 csi_gen_utility_pvt.put_line(' COMPLETENESS_FLAG : '||SELF.COMPLETENESS_FLAG);
468 csi_gen_utility_pvt.put_line(' RELATIONSHIP_TYPE_CODE : '||SELF.RELATIONSHIP_TYPE_CODE);
469 csi_gen_utility_pvt.put_line(' PARENT_INSTANCE_ID : '||SELF.PARENT_INSTANCE_ID);
470 csi_gen_utility_pvt.put_line(' ROOT_PARENT_INSTANCE_ID : '||SELF.ROOT_PARENT_INSTANCE_ID);
471 csi_gen_utility_pvt.put_line(' SECURITY_GROUP_ID : '||SELF.SECURITY_GROUP_ID);
472 csi_gen_utility_pvt.put_line(' MIGRATED_FLAG : '||SELF.MIGRATED_FLAG);
473 csi_gen_utility_pvt.put_line(' REQUEST_ID : '||SELF.REQUEST_ID);
474 csi_gen_utility_pvt.put_line(' PROGRAM_APPLICATION_ID : '||SELF.PROGRAM_APPLICATION_ID);
475 csi_gen_utility_pvt.put_line(' PROGRAM_ID : '||SELF.PROGRAM_ID);
476 csi_gen_utility_pvt.put_line(' PROGRAM_UPDATE_DATE : '||SELF.PROGRAM_UPDATE_DATE);
477 csi_gen_utility_pvt.put_line(' CONFIG_INST_HDR_ID : '||SELF.CONFIG_INST_HDR_ID);
478 csi_gen_utility_pvt.put_line(' CONFIG_INST_REV_NUM : '||SELF.CONFIG_INST_REV_NUM);
479 csi_gen_utility_pvt.put_line(' CONFIG_INST_ITEM_ID : '||SELF.CONFIG_INST_ITEM_ID);
480 csi_gen_utility_pvt.put_line(' CONFIG_VALID_STATUS : '||SELF.CONFIG_VALID_STATUS);
481 csi_gen_utility_pvt.put_line(' LAST_PURGE_DATE : '||SELF.LAST_PURGE_DATE);
482 csi_gen_utility_pvt.put_line(' NETWORK_ASSET_FLAG : '||SELF.NETWORK_ASSET_FLAG);
483 csi_gen_utility_pvt.put_line(' MAINTAINABLE_FLAG : '||SELF.MAINTAINABLE_FLAG);
484 csi_gen_utility_pvt.put_line(' PN_LOCATION_ID : '||SELF.PN_LOCATION_ID);
485 csi_gen_utility_pvt.put_line(' ASSET_CRITICALITY_CODE : '||SELF.ASSET_CRITICALITY_CODE);
486 csi_gen_utility_pvt.put_line(' CATEGORY_ID : '||SELF.CATEGORY_ID);
487 csi_gen_utility_pvt.put_line(' EQUIPMENT_GEN_OBJECT_ID : '||SELF.EQUIPMENT_GEN_OBJECT_ID);
488 csi_gen_utility_pvt.put_line(' INSTANTIATION_FLAG : '||SELF.INSTANTIATION_FLAG);
489 csi_gen_utility_pvt.put_line(' LINEAR_LOCATION_ID : '||SELF.LINEAR_LOCATION_ID);
490 csi_gen_utility_pvt.put_line(' OPERATIONAL_LOG_FLAG : '||SELF.OPERATIONAL_LOG_FLAG);
491 csi_gen_utility_pvt.put_line(' CHECKIN_STATUS : '||SELF.CHECKIN_STATUS);
492 csi_gen_utility_pvt.put_line(' SUPPLIER_WARRANTY_EXP_DATE : '||SELF.SUPPLIER_WARRANTY_EXP_DATE);
493 csi_gen_utility_pvt.put_line(' PURCHASE_UNIT_PRICE : '||SELF.PURCHASE_UNIT_PRICE);
494 csi_gen_utility_pvt.put_line(' PURCHASE_CURRENCY_CODE : '||SELF.PURCHASE_CURRENCY_CODE);
495 csi_gen_utility_pvt.put_line(' PAYABLES_UNIT_PRICE : '||SELF.PAYABLES_UNIT_PRICE);
496 csi_gen_utility_pvt.put_line(' PAYABLES_CURRENCY_CODE : '||SELF.PAYABLES_CURRENCY_CODE);
497 csi_gen_utility_pvt.put_line(' SALES_UNIT_PRICE : '||SELF.SALES_UNIT_PRICE);
498 csi_gen_utility_pvt.put_line(' SALES_CURRENCY_CODE : '||SELF.SALES_CURRENCY_CODE);
499 csi_gen_utility_pvt.put_line(' OPERATIONAL_STATUS_CODE : '||SELF.OPERATIONAL_STATUS_CODE);
500 csi_gen_utility_pvt.put_line(' SOURCE_CODE : '||SELF.SOURCE_CODE);
501 csi_gen_utility_pvt.put_line(' CONTEXT : '||SELF.CONTEXT);
502 csi_gen_utility_pvt.put_line(' ATTRIBUTE1 : '||SELF.ATTRIBUTE1);
503 csi_gen_utility_pvt.put_line(' ATTRIBUTE2 : '||SELF.ATTRIBUTE2);
504 csi_gen_utility_pvt.put_line(' ATTRIBUTE3 : '||SELF.ATTRIBUTE3);
505 csi_gen_utility_pvt.put_line(' ATTRIBUTE4 : '||SELF.ATTRIBUTE4);
506 csi_gen_utility_pvt.put_line(' ATTRIBUTE5 : '||SELF.ATTRIBUTE5);
507 csi_gen_utility_pvt.put_line(' ATTRIBUTE6 : '||SELF.ATTRIBUTE6);
508 csi_gen_utility_pvt.put_line(' ATTRIBUTE7 : '||SELF.ATTRIBUTE7);
509 csi_gen_utility_pvt.put_line(' ATTRIBUTE8 : '||SELF.ATTRIBUTE8);
510 csi_gen_utility_pvt.put_line(' ATTRIBUTE9 : '||SELF.ATTRIBUTE9);
511 csi_gen_utility_pvt.put_line(' ATTRIBUTE10 : '||SELF.ATTRIBUTE10);
515 csi_gen_utility_pvt.put_line(' ATTRIBUTE14 : '||SELF.ATTRIBUTE14);
512 csi_gen_utility_pvt.put_line(' ATTRIBUTE11 : '||SELF.ATTRIBUTE11);
513 csi_gen_utility_pvt.put_line(' ATTRIBUTE12 : '||SELF.ATTRIBUTE12);
514 csi_gen_utility_pvt.put_line(' ATTRIBUTE13 : '||SELF.ATTRIBUTE13);
516 csi_gen_utility_pvt.put_line(' ATTRIBUTE15 : '||SELF.ATTRIBUTE15);
517 csi_gen_utility_pvt.put_line(' ATTRIBUTE16 : '||SELF.ATTRIBUTE16);
518 csi_gen_utility_pvt.put_line(' ATTRIBUTE17 : '||SELF.ATTRIBUTE17);
519 csi_gen_utility_pvt.put_line(' ATTRIBUTE18 : '||SELF.ATTRIBUTE18);
520 csi_gen_utility_pvt.put_line(' ATTRIBUTE19 : '||SELF.ATTRIBUTE19);
521 csi_gen_utility_pvt.put_line(' ATTRIBUTE20 : '||SELF.ATTRIBUTE20);
522 csi_gen_utility_pvt.put_line(' ATTRIBUTE21 : '||SELF.ATTRIBUTE21);
523 csi_gen_utility_pvt.put_line(' ATTRIBUTE22 : '||SELF.ATTRIBUTE22);
524 csi_gen_utility_pvt.put_line(' ATTRIBUTE23 : '||SELF.ATTRIBUTE23);
525 csi_gen_utility_pvt.put_line(' ATTRIBUTE24 : '||SELF.ATTRIBUTE24);
526 csi_gen_utility_pvt.put_line(' ATTRIBUTE25 : '||SELF.ATTRIBUTE25);
527 csi_gen_utility_pvt.put_line(' ATTRIBUTE26 : '||SELF.ATTRIBUTE26);
528 csi_gen_utility_pvt.put_line(' ATTRIBUTE27 : '||SELF.ATTRIBUTE27);
529 csi_gen_utility_pvt.put_line(' ATTRIBUTE28 : '||SELF.ATTRIBUTE28);
530 csi_gen_utility_pvt.put_line(' ATTRIBUTE29 : '||SELF.ATTRIBUTE29);
531 csi_gen_utility_pvt.put_line(' ATTRIBUTE30 : '||SELF.ATTRIBUTE30);
532 csi_gen_utility_pvt.put_line(' CREATED_BY : '||SELF.CREATED_BY);
533 csi_gen_utility_pvt.put_line(' CREATION_DATE : '||SELF.CREATION_DATE);
534 csi_gen_utility_pvt.put_line(' LAST_UPDATED_BY : '||SELF.LAST_UPDATED_BY);
535 csi_gen_utility_pvt.put_line(' LAST_UPDATE_DATE : '||SELF.LAST_UPDATE_DATE);
536 csi_gen_utility_pvt.put_line(' LAST_UPDATE_LOGIN : '||SELF.LAST_UPDATE_LOGIN);
537 csi_gen_utility_pvt.put_line(' OBJECT_VERSION_NUMBER : '||SELF.OBJECT_VERSION_NUMBER);
538 END IF;
539
540 RETURN;
541 EXCEPTION
542 WHEN OTHERS THEN
543 IF (l_debug_level > 1) THEN
544 csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '
545 ||SQLERRM);
546 END IF;
547 FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');
548 FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
549 FND_MSG_PUB.Add;
550 RAISE FND_API.G_EXC_ERROR;
551 END;
552
553 END;