eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_OBJECT_GENEALOGY dependencies on INV_TRX_UTIL_PUB

Line 62: inv_trx_util_pub.TRACE('in the procedure getObjectInfo', 'INV_OBJECT_GENEALOGY', 9);

58: l_status_id NUMBER;
59: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
60: BEGIN
61: IF (l_debug = 1) THEN
62: inv_trx_util_pub.TRACE('in the procedure getObjectInfo', 'INV_OBJECT_GENEALOGY', 9);
63: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
64: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
65: END IF;
66:

Line 63: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);

59: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
60: BEGIN
61: IF (l_debug = 1) THEN
62: inv_trx_util_pub.TRACE('in the procedure getObjectInfo', 'INV_OBJECT_GENEALOGY', 9);
63: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
64: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
65: END IF;
66:
67: IF p_object_type = 1 THEN

Line 64: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);

60: BEGIN
61: IF (l_debug = 1) THEN
62: inv_trx_util_pub.TRACE('in the procedure getObjectInfo', 'INV_OBJECT_GENEALOGY', 9);
63: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
64: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
65: END IF;
66:
67: IF p_object_type = 1 THEN
68: IF (l_debug = 1) THEN

Line 69: inv_trx_util_pub.TRACE('object_type is 1', 'INV_OBJECT_GENEALOGY', 9);

65: END IF;
66:
67: IF p_object_type = 1 THEN
68: IF (l_debug = 1) THEN
69: inv_trx_util_pub.TRACE('object_type is 1', 'INV_OBJECT_GENEALOGY', 9);
70: END IF;
71:
72: BEGIN
73: SELECT concatenated_segments

Line 93: inv_trx_util_pub.TRACE(

89: AND mln.inventory_item_id = msivl.inventory_item_id
90: AND mln.organization_id = msivl.organization_id;
91:
92: IF (l_debug = 1) THEN
93: inv_trx_util_pub.TRACE(
94: 'p_object_name: '
95: || p_object_name
96: || ' p_object_description: '
97: || p_object_description

Line 103: inv_trx_util_pub.TRACE(

99: || p_expiration_date
100: , 'INV_OBJECT_GENEALOGY'
101: , 9
102: );
103: inv_trx_util_pub.TRACE(
104: 'p_primary_uom : '
105: || p_primary_uom
106: || ' p_inventory_item_id : '
107: || p_inventory_item_id

Line 123: inv_trx_util_pub.TRACE('object type is 1 and status id is not null ', 'INV_OBJECT_GENEALOGY', 9);

119: END;
120:
121: IF l_status_id IS NOT NULL THEN
122: IF (l_debug = 1) THEN
123: inv_trx_util_pub.TRACE('object type is 1 and status id is not null ', 'INV_OBJECT_GENEALOGY', 9);
124: END IF;
125:
126: BEGIN
127: SELECT status_code

Line 133: inv_trx_util_pub.TRACE('object type is 1 and status code is ' || p_material_status, 'INV_OBJECT_GENEALOGY', 9);

129: FROM mtl_material_statuses_vl
130: WHERE status_id = l_status_id;
131:
132: IF (l_debug = 1) THEN
133: inv_trx_util_pub.TRACE('object type is 1 and status code is ' || p_material_status, 'INV_OBJECT_GENEALOGY', 9);
134: END IF;
135: EXCEPTION
136: WHEN OTHERS THEN
137: NULL;

Line 142: inv_trx_util_pub.TRACE('object type is 2 ', 'INV_OBJECT_GENEALOGY', 9);

138: END;
139: END IF;
140: ELSIF p_object_type = 2 THEN
141: IF (l_debug = 1) THEN
142: inv_trx_util_pub.TRACE('object type is 2 ', 'INV_OBJECT_GENEALOGY', 9);
143: END IF;
144:
145: SELECT concatenated_segments
146: , msivl.description

Line 163: inv_trx_util_pub.TRACE('object type is 2 and values retrieved from MSN, MSIK are ', 'INV_OBJECT_GENEALOGY', 9);

159: AND msn.inventory_item_id = msivl.inventory_item_id
160: AND msn.current_organization_id = msivl.organization_id;
161:
162: IF (l_debug = 1) THEN
163: inv_trx_util_pub.TRACE('object type is 2 and values retrieved from MSN, MSIK are ', 'INV_OBJECT_GENEALOGY', 9);
164: inv_trx_util_pub.TRACE(
165: 'p_object_name : ' || p_object_name || ' p_object_description : ' || p_object_description || ' p_unit_number ' || p_unit_number
166: , 'INV_OBJECT_GENEALOGY'
167: , 9

Line 164: inv_trx_util_pub.TRACE(

160: AND msn.current_organization_id = msivl.organization_id;
161:
162: IF (l_debug = 1) THEN
163: inv_trx_util_pub.TRACE('object type is 2 and values retrieved from MSN, MSIK are ', 'INV_OBJECT_GENEALOGY', 9);
164: inv_trx_util_pub.TRACE(
165: 'p_object_name : ' || p_object_name || ' p_object_description : ' || p_object_description || ' p_unit_number ' || p_unit_number
166: , 'INV_OBJECT_GENEALOGY'
167: , 9
168: );

Line 169: inv_trx_util_pub.TRACE('p_object_number : ' || p_object_number || ' l_status_id ' || l_status_id, 'INV_OBJECT_GENEALOGY', 9);

165: 'p_object_name : ' || p_object_name || ' p_object_description : ' || p_object_description || ' p_unit_number ' || p_unit_number
166: , 'INV_OBJECT_GENEALOGY'
167: , 9
168: );
169: inv_trx_util_pub.TRACE('p_object_number : ' || p_object_number || ' l_status_id ' || l_status_id, 'INV_OBJECT_GENEALOGY', 9);
170: END IF;
171:
172: IF l_status_id IS NOT NULL THEN
173: BEGIN

Line 180: inv_trx_util_pub.TRACE(

176: FROM mtl_material_statuses_vl
177: WHERE status_id = l_status_id;
178:
179: IF (l_debug = 1) THEN
180: inv_trx_util_pub.TRACE(
181: 'object type is 2 and status code from mtl_material_statuses_vl for status_id ' || l_status_id || ' : ' || p_material_status
182: , 'INV_OBJECT_GENEALOGY'
183: , 9
184: );

Line 199: inv_trx_util_pub.TRACE(

195: WHERE lookup_code = p_object_type
196: AND lookup_type = 'INV_GENEALOGY_OBJECT_TYPE';
197:
198: IF (l_debug = 1) THEN
199: inv_trx_util_pub.TRACE(
200: 'meaning from mfg_lookups for lookup_type = inv_genealogy_object_type and lookup_code = '
201: || p_object_type
202: || ' : '
203: || p_object_type_name

Line 231: inv_trx_util_pub.TRACE('in the procedure getObjectInfo', 'INV_OBJECT_GENEALOGY', 9);

227: l_status_id NUMBER;
228: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
229: BEGIN
230: IF (l_debug = 1) THEN
231: inv_trx_util_pub.TRACE('in the procedure getObjectInfo', 'INV_OBJECT_GENEALOGY', 9);
232: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
233: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
234: END IF;
235:

Line 232: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);

228: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
229: BEGIN
230: IF (l_debug = 1) THEN
231: inv_trx_util_pub.TRACE('in the procedure getObjectInfo', 'INV_OBJECT_GENEALOGY', 9);
232: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
233: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
234: END IF;
235:
236: x_wip_entity_id := NULL;

Line 233: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);

229: BEGIN
230: IF (l_debug = 1) THEN
231: inv_trx_util_pub.TRACE('in the procedure getObjectInfo', 'INV_OBJECT_GENEALOGY', 9);
232: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
233: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
234: END IF;
235:
236: x_wip_entity_id := NULL;
237: x_operation_seq_num := NULL;

Line 242: inv_trx_util_pub.TRACE('object_type is 1', 'INV_OBJECT_GENEALOGY', 9);

238: x_intraoperation_step_type := NULL;
239:
240: IF p_object_type = 1 THEN
241: IF (l_debug = 1) THEN
242: inv_trx_util_pub.TRACE('object_type is 1', 'INV_OBJECT_GENEALOGY', 9);
243: END IF;
244:
245: BEGIN
246: SELECT concatenated_segments

Line 266: inv_trx_util_pub.TRACE(

262: AND mln.inventory_item_id = msivl.inventory_item_id
263: AND mln.organization_id = msivl.organization_id;
264:
265: IF (l_debug = 1) THEN
266: inv_trx_util_pub.TRACE(
267: 'p_object_name: '
268: || p_object_name
269: || ' p_object_description: '
270: || p_object_description

Line 276: inv_trx_util_pub.TRACE(

272: || p_expiration_date
273: , 'INV_OBJECT_GENEALOGY'
274: , 9
275: );
276: inv_trx_util_pub.TRACE(
277: 'p_primary_uom : '
278: || p_primary_uom
279: || ' p_inventory_item_id : '
280: || p_inventory_item_id

Line 296: inv_trx_util_pub.TRACE('object type is 1 and status id is not null ', 'INV_OBJECT_GENEALOGY', 9);

292: END;
293:
294: IF l_status_id IS NOT NULL THEN
295: IF (l_debug = 1) THEN
296: inv_trx_util_pub.TRACE('object type is 1 and status id is not null ', 'INV_OBJECT_GENEALOGY', 9);
297: END IF;
298:
299: BEGIN
300: SELECT status_code

Line 306: inv_trx_util_pub.TRACE('object type is 1 and status code is ' || p_material_status, 'INV_OBJECT_GENEALOGY', 9);

302: FROM mtl_material_statuses_vl
303: WHERE status_id = l_status_id;
304:
305: IF (l_debug = 1) THEN
306: inv_trx_util_pub.TRACE('object type is 1 and status code is ' || p_material_status, 'INV_OBJECT_GENEALOGY', 9);
307: END IF;
308: EXCEPTION
309: WHEN OTHERS THEN
310: NULL;

Line 315: inv_trx_util_pub.TRACE('object type is 2 ', 'INV_OBJECT_GENEALOGY', 9);

311: END;
312: END IF;
313: ELSIF p_object_type = 2 THEN
314: IF (l_debug = 1) THEN
315: inv_trx_util_pub.TRACE('object type is 2 ', 'INV_OBJECT_GENEALOGY', 9);
316: END IF;
317:
318: SELECT concatenated_segments
319: , msivl.description

Line 346: inv_trx_util_pub.TRACE('object type is 2 and values retrieved from MSN, MSIK are ', 'INV_OBJECT_GENEALOGY', 9);

342: AND msn.inventory_item_id = msivl.inventory_item_id
343: AND msn.current_organization_id = msivl.organization_id;
344:
345: IF (l_debug = 1) THEN
346: inv_trx_util_pub.TRACE('object type is 2 and values retrieved from MSN, MSIK are ', 'INV_OBJECT_GENEALOGY', 9);
347: inv_trx_util_pub.TRACE(
348: 'p_object_name : ' || p_object_name || ' p_object_description : ' || p_object_description || ' p_unit_number ' || p_unit_number
349: , 'INV_OBJECT_GENEALOGY'
350: , 9

Line 347: inv_trx_util_pub.TRACE(

343: AND msn.current_organization_id = msivl.organization_id;
344:
345: IF (l_debug = 1) THEN
346: inv_trx_util_pub.TRACE('object type is 2 and values retrieved from MSN, MSIK are ', 'INV_OBJECT_GENEALOGY', 9);
347: inv_trx_util_pub.TRACE(
348: 'p_object_name : ' || p_object_name || ' p_object_description : ' || p_object_description || ' p_unit_number ' || p_unit_number
349: , 'INV_OBJECT_GENEALOGY'
350: , 9
351: );

Line 352: inv_trx_util_pub.TRACE('p_object_number : ' || p_object_number || ' l_status_id ' || l_status_id, 'INV_OBJECT_GENEALOGY', 9);

348: 'p_object_name : ' || p_object_name || ' p_object_description : ' || p_object_description || ' p_unit_number ' || p_unit_number
349: , 'INV_OBJECT_GENEALOGY'
350: , 9
351: );
352: inv_trx_util_pub.TRACE('p_object_number : ' || p_object_number || ' l_status_id ' || l_status_id, 'INV_OBJECT_GENEALOGY', 9);
353: inv_trx_util_pub.TRACE(
354: 'x_wip_entity_id : '
355: || x_wip_entity_id
356: || ' x_operation_seq_num : '

Line 353: inv_trx_util_pub.TRACE(

349: , 'INV_OBJECT_GENEALOGY'
350: , 9
351: );
352: inv_trx_util_pub.TRACE('p_object_number : ' || p_object_number || ' l_status_id ' || l_status_id, 'INV_OBJECT_GENEALOGY', 9);
353: inv_trx_util_pub.TRACE(
354: 'x_wip_entity_id : '
355: || x_wip_entity_id
356: || ' x_operation_seq_num : '
357: || x_operation_seq_num

Line 373: inv_trx_util_pub.TRACE(

369: FROM mtl_material_statuses_vl
370: WHERE status_id = l_status_id;
371:
372: IF (l_debug = 1) THEN
373: inv_trx_util_pub.TRACE(
374: 'object type is 2 and status code from mtl_material_statuses_vl for status_id ' || l_status_id || ' : ' || p_material_status
375: , 'INV_OBJECT_GENEALOGY'
376: , 9
377: );

Line 392: inv_trx_util_pub.TRACE(

388: WHERE lookup_code = p_object_type
389: AND lookup_type = 'INV_GENEALOGY_OBJECT_TYPE';
390:
391: IF (l_debug = 1) THEN
392: inv_trx_util_pub.TRACE(
393: 'meaning from mfg_lookups for lookup_type = inv_genealogy_object_type and lookup_code = '
394: || p_object_type
395: || ' : '
396: || p_object_type_name

Line 559: inv_trx_util_pub.TRACE('gjData'||g_jData, 'INV_OBJECT_GENEALOGY', 9);

555: jRec jRecord%ROWTYPE;
556:
557:
558: BEGIN
559: inv_trx_util_pub.TRACE('gjData'||g_jData, 'INV_OBJECT_GENEALOGY', 9);
560: OPEN jRecord;
561: FETCH jRecord INTO jRec;
562: IF jRecord%found THEN
563: g_jData:=1;

Line 933: inv_trx_util_pub.TRACE('in the procedure inv_populate_child', 'INV_OBJECT_GENEALOGY', 9);

929: -- ===============
930: -- Check if the p_object_id is the first node of the tree
931: -- if yes, then no need to check other trees or nodes
932: IF (l_debug = 1) THEN
933: inv_trx_util_pub.TRACE('in the procedure inv_populate_child', 'INV_OBJECT_GENEALOGY', 9);
934: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
935: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
936: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
937: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);

Line 934: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);

930: -- Check if the p_object_id is the first node of the tree
931: -- if yes, then no need to check other trees or nodes
932: IF (l_debug = 1) THEN
933: inv_trx_util_pub.TRACE('in the procedure inv_populate_child', 'INV_OBJECT_GENEALOGY', 9);
934: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
935: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
936: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
937: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
938: Inv_Trx_Util_Pub.Trace('GENEALOGY_ORDER is ' || P_Genealogy_Order, 'INV_OBJECT_GENEALOGY', 9);

Line 935: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);

931: -- if yes, then no need to check other trees or nodes
932: IF (l_debug = 1) THEN
933: inv_trx_util_pub.TRACE('in the procedure inv_populate_child', 'INV_OBJECT_GENEALOGY', 9);
934: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
935: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
936: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
937: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
938: Inv_Trx_Util_Pub.Trace('GENEALOGY_ORDER is ' || P_Genealogy_Order, 'INV_OBJECT_GENEALOGY', 9);
939: END IF;

Line 936: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);

932: IF (l_debug = 1) THEN
933: inv_trx_util_pub.TRACE('in the procedure inv_populate_child', 'INV_OBJECT_GENEALOGY', 9);
934: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
935: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
936: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
937: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
938: Inv_Trx_Util_Pub.Trace('GENEALOGY_ORDER is ' || P_Genealogy_Order, 'INV_OBJECT_GENEALOGY', 9);
939: END IF;
940:

Line 937: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);

933: inv_trx_util_pub.TRACE('in the procedure inv_populate_child', 'INV_OBJECT_GENEALOGY', 9);
934: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
935: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
936: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
937: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
938: Inv_Trx_Util_Pub.Trace('GENEALOGY_ORDER is ' || P_Genealogy_Order, 'INV_OBJECT_GENEALOGY', 9);
939: END IF;
940:
941: IF g_ind > 1 THEN

Line 938: Inv_Trx_Util_Pub.Trace('GENEALOGY_ORDER is ' || P_Genealogy_Order, 'INV_OBJECT_GENEALOGY', 9);

934: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
935: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
936: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
937: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
938: Inv_Trx_Util_Pub.Trace('GENEALOGY_ORDER is ' || P_Genealogy_Order, 'INV_OBJECT_GENEALOGY', 9);
939: END IF;
940:
941: IF g_ind > 1 THEN
942: BEGIN

Line 956: inv_trx_util_pub.TRACE('insert1, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);

952: get_hierc := 'N';
953: g_ind := g_ind + 1;
954:
955: IF l_debug =1 THEN
956: inv_trx_util_pub.TRACE('insert1, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
957: END IF;
958:
959: INSERT INTO mtl_gen_temp
960: (

Line 985: inv_trx_util_pub.TRACE('exception 1', 'INV_OBJECT_GENEALOGY', 9);

981: EXCEPTION
982: WHEN NO_DATA_FOUND THEN
983: l_count := 0;
984: IF l_debug = 1 THEN
985: inv_trx_util_pub.TRACE('exception 1', 'INV_OBJECT_GENEALOGY', 9);
986: END IF;
987:
988: END;
989: END IF;

Line 1009: inv_trx_util_pub.TRACE('insert2 g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);

1005: IF l_count > 0 THEN
1006: get_hierc := 'N';
1007: g_ind := g_ind + 1;
1008: IF l_debug=1 THEN
1009: inv_trx_util_pub.TRACE('insert2 g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1010: END IF;
1011:
1012: INSERT INTO mtl_gen_temp
1013: (

Line 1038: inv_trx_util_pub.TRACE('exception 2', 'INV_OBJECT_GENEALOGY', 9);

1034: EXCEPTION
1035: WHEN NO_DATA_FOUND THEN
1036: l_count := 0;
1037: IF l_debug=1 THEN
1038: inv_trx_util_pub.TRACE('exception 2', 'INV_OBJECT_GENEALOGY', 9);
1039: END IF;
1040:
1041: END;
1042: END IF;

Line 1057: inv_trx_util_pub.TRACE('insert3 g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);

1053: AND cur_var.label = l_previous_parent THEN
1054: get_hierc := 'N';
1055: g_ind := g_ind + 1;
1056: IF l_debug=1 THEN
1057: inv_trx_util_pub.TRACE('insert3 g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1058: END IF;
1059:
1060: INSERT INTO mtl_gen_temp
1061: (

Line 1092: inv_trx_util_pub.TRACE('insert4 g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);

1088:
1089: IF (get_hierc = 'Y') THEN
1090: g_ind := g_ind + 1;
1091: IF l_debug=1 THEN
1092: inv_trx_util_pub.TRACE('insert4 g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1093: END IF;
1094:
1095: INSERT INTO mtl_gen_temp
1096: (

Line 1249: inv_trx_util_pub.TRACE('in the procedure inv_populate_child_tree', 'INV_OBJECT_GENEALOGY', 9);

1245: /*End of R12 Genealogy Lot serial Project*/
1246:
1247: BEGIN
1248: IF (l_debug = 1) THEN
1249: inv_trx_util_pub.TRACE('in the procedure inv_populate_child_tree', 'INV_OBJECT_GENEALOGY', 9);
1250: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
1251: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
1252: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
1253: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);

Line 1250: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);

1246:
1247: BEGIN
1248: IF (l_debug = 1) THEN
1249: inv_trx_util_pub.TRACE('in the procedure inv_populate_child_tree', 'INV_OBJECT_GENEALOGY', 9);
1250: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
1251: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
1252: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
1253: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
1254: inv_trx_util_pub.TRACE('GENEALOGY_ORDER== '||p_GENEALOGY_ORDER, 'INV_OBJECT_GENEALOGY', 9);

Line 1251: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);

1247: BEGIN
1248: IF (l_debug = 1) THEN
1249: inv_trx_util_pub.TRACE('in the procedure inv_populate_child_tree', 'INV_OBJECT_GENEALOGY', 9);
1250: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
1251: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
1252: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
1253: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
1254: inv_trx_util_pub.TRACE('GENEALOGY_ORDER== '||p_GENEALOGY_ORDER, 'INV_OBJECT_GENEALOGY', 9);
1255: END IF;

Line 1252: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);

1248: IF (l_debug = 1) THEN
1249: inv_trx_util_pub.TRACE('in the procedure inv_populate_child_tree', 'INV_OBJECT_GENEALOGY', 9);
1250: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
1251: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
1252: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
1253: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
1254: inv_trx_util_pub.TRACE('GENEALOGY_ORDER== '||p_GENEALOGY_ORDER, 'INV_OBJECT_GENEALOGY', 9);
1255: END IF;
1256:

Line 1253: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);

1249: inv_trx_util_pub.TRACE('in the procedure inv_populate_child_tree', 'INV_OBJECT_GENEALOGY', 9);
1250: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
1251: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
1252: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
1253: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
1254: inv_trx_util_pub.TRACE('GENEALOGY_ORDER== '||p_GENEALOGY_ORDER, 'INV_OBJECT_GENEALOGY', 9);
1255: END IF;
1256:
1257: inv_object_genealogy.init;

Line 1254: inv_trx_util_pub.TRACE('GENEALOGY_ORDER== '||p_GENEALOGY_ORDER, 'INV_OBJECT_GENEALOGY', 9);

1250: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
1251: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
1252: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
1253: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
1254: inv_trx_util_pub.TRACE('GENEALOGY_ORDER== '||p_GENEALOGY_ORDER, 'INV_OBJECT_GENEALOGY', 9);
1255: END IF;
1256:
1257: inv_object_genealogy.init;
1258: /*

Line 1364: inv_trx_util_pub.TRACE('Fetching child_cur2 for level='||(n_level-1), 'INV_OBJECT_GENEALOGY', 9);

1360: n_level := n_level + 1;
1361: END LOOP;
1362:
1363: IF (l_debug = 1) THEN
1364: inv_trx_util_pub.TRACE('Fetching child_cur2 for level='||(n_level-1), 'INV_OBJECT_GENEALOGY', 9);
1365: END IF;
1366:
1367: --open r12 cursor
1368: FOR child_rec IN child_cur2(n_level-1)

Line 1464: inv_trx_util_pub.TRACE('in the procedure inv_populate_parent', 'INV_OBJECT_GENEALOGY', 9);

1460: -- ===============
1461: -- Check if the p_object_id is the first node of the tree
1462: -- if yes, then no need to check other trees or nodes
1463: IF (l_debug = 1) THEN
1464: inv_trx_util_pub.TRACE('in the procedure inv_populate_parent', 'INV_OBJECT_GENEALOGY', 9);
1465: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
1466: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
1467: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
1468: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);

Line 1465: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);

1461: -- Check if the p_object_id is the first node of the tree
1462: -- if yes, then no need to check other trees or nodes
1463: IF (l_debug = 1) THEN
1464: inv_trx_util_pub.TRACE('in the procedure inv_populate_parent', 'INV_OBJECT_GENEALOGY', 9);
1465: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
1466: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
1467: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
1468: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
1469: END IF;

Line 1466: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);

1462: -- if yes, then no need to check other trees or nodes
1463: IF (l_debug = 1) THEN
1464: inv_trx_util_pub.TRACE('in the procedure inv_populate_parent', 'INV_OBJECT_GENEALOGY', 9);
1465: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
1466: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
1467: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
1468: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
1469: END IF;
1470: IF g_ind > 0 THEN

Line 1467: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);

1463: IF (l_debug = 1) THEN
1464: inv_trx_util_pub.TRACE('in the procedure inv_populate_parent', 'INV_OBJECT_GENEALOGY', 9);
1465: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
1466: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
1467: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
1468: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
1469: END IF;
1470: IF g_ind > 0 THEN
1471: BEGIN

Line 1468: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);

1464: inv_trx_util_pub.TRACE('in the procedure inv_populate_parent', 'INV_OBJECT_GENEALOGY', 9);
1465: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
1466: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
1467: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
1468: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
1469: END IF;
1470: IF g_ind > 0 THEN
1471: BEGIN
1472: SELECT 1

Line 1485: inv_trx_util_pub.TRACE('insert1, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);

1481: get_hierc := 'N';
1482: g_ind := g_ind + 1;
1483:
1484: IF l_debug =1 THEN
1485: inv_trx_util_pub.TRACE('insert1, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1486: END IF;
1487:
1488:
1489: INSERT INTO mtl_gen_temp

Line 1515: inv_trx_util_pub.TRACE('exception 1', 'INV_OBJECT_GENEALOGY', 9);

1511: EXCEPTION
1512: WHEN NO_DATA_FOUND THEN
1513: l_count := 0;
1514: IF l_debug = 1 THEN
1515: inv_trx_util_pub.TRACE('exception 1', 'INV_OBJECT_GENEALOGY', 9);
1516: END IF;
1517:
1518: END;
1519: END IF;

Line 1540: inv_trx_util_pub.TRACE('insert2, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);

1536: get_hierc := 'N';
1537: g_ind := g_ind + 1;
1538:
1539: IF l_debug = 2 THEN
1540: inv_trx_util_pub.TRACE('insert2, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1541: END IF;
1542:
1543:
1544: INSERT INTO mtl_gen_temp

Line 1570: inv_trx_util_pub.TRACE('exception 2', 'INV_OBJECT_GENEALOGY', 9);

1566: EXCEPTION
1567: WHEN NO_DATA_FOUND THEN
1568: l_count := 0;
1569: IF l_debug = 1 THEN
1570: inv_trx_util_pub.TRACE('exception 2', 'INV_OBJECT_GENEALOGY', 9);
1571: END IF;
1572:
1573: END;
1574: END IF;

Line 1588: inv_trx_util_pub.TRACE('insert3, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);

1584: get_hierc := 'N';
1585: g_ind := g_ind + 1;
1586:
1587: IF l_debug = 3 THEN
1588: inv_trx_util_pub.TRACE('insert3, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1589: END IF;
1590:
1591:
1592: INSERT INTO mtl_gen_temp

Line 1625: inv_trx_util_pub.TRACE('insert4, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);

1621: IF (get_hierc = 'Y') THEN
1622: g_ind := g_ind + 1;
1623:
1624: IF l_debug =1 THEN
1625: inv_trx_util_pub.TRACE('insert4, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1626: END IF;
1627:
1628:
1629: INSERT INTO mtl_gen_temp

Line 1719: inv_trx_util_pub.TRACE('in the procedure inv_populate_parent_tree', 'INV_OBJECT_GENEALOGY', 9);

1715:
1716:
1717: BEGIN
1718: IF (l_debug = 1) THEN
1719: inv_trx_util_pub.TRACE('in the procedure inv_populate_parent_tree', 'INV_OBJECT_GENEALOGY', 9);
1720: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
1721: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
1722: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
1723: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);

Line 1720: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);

1716:
1717: BEGIN
1718: IF (l_debug = 1) THEN
1719: inv_trx_util_pub.TRACE('in the procedure inv_populate_parent_tree', 'INV_OBJECT_GENEALOGY', 9);
1720: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
1721: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
1722: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
1723: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
1724: END IF;

Line 1721: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);

1717: BEGIN
1718: IF (l_debug = 1) THEN
1719: inv_trx_util_pub.TRACE('in the procedure inv_populate_parent_tree', 'INV_OBJECT_GENEALOGY', 9);
1720: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
1721: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
1722: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
1723: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
1724: END IF;
1725:

Line 1722: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);

1718: IF (l_debug = 1) THEN
1719: inv_trx_util_pub.TRACE('in the procedure inv_populate_parent_tree', 'INV_OBJECT_GENEALOGY', 9);
1720: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
1721: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
1722: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
1723: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
1724: END IF;
1725:
1726: inv_object_genealogy.init;

Line 1723: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);

1719: inv_trx_util_pub.TRACE('in the procedure inv_populate_parent_tree', 'INV_OBJECT_GENEALOGY', 9);
1720: inv_trx_util_pub.TRACE('input param values to this proc are:', 'INV_OBJECT_GENEALOGY', 9);
1721: inv_trx_util_pub.TRACE('p_object_id is ' || p_object_id || 'p_object_type ' || p_object_type, 'INV_OBJECT_GENEALOGY', 9);
1722: inv_trx_util_pub.TRACE('p_object_id2 is ' || p_object_id2 || 'p_object_type2 ' || p_object_type2, 'INV_OBJECT_GENEALOGY', 9);
1723: inv_trx_util_pub.TRACE('p_related_object_id is ' || p_related_object_id, 'INV_OBJECT_GENEALOGY', 9);
1724: END IF;
1725:
1726: inv_object_genealogy.init;
1727: g_ind := g_ind + 1;

Line 1778: inv_trx_util_pub.TRACE('Fetching parent_cur for level='||(n_level-1), 'INV_OBJECT_GENEALOGY', 9);

1774: n_level := n_level + 1;
1775: END LOOP;
1776:
1777: IF (l_debug = 1) THEN
1778: inv_trx_util_pub.TRACE('Fetching parent_cur for level='||(n_level-1), 'INV_OBJECT_GENEALOGY', 9);
1779: END IF;
1780:
1781: FOR parent_rec IN parent_cur(n_level-1) LOOP
1782: IF parent_rec.parent_object_id = l_prev_parent THEN

Line 1839: inv_trx_util_pub.TRACE('g_rowlimit='||g_rowlimit, 'INV_OBJECT_GENEALOGY', 9);

1835: IF g_rowlimit <> p_numrows THEN
1836: g_rowlimit := p_numrows;
1837: END IF;
1838: IF l_debug=1 THEN
1839: inv_trx_util_pub.TRACE('g_rowlimit='||g_rowlimit, 'INV_OBJECT_GENEALOGY', 9);
1840: END IF;
1841: END;
1842:
1843: END inv_object_genealogy;