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_EBI_CHANGE_ORDER_PUB dependencies on INV_EBI_ITEM_HELPER

Line 16: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

12: ,p_revised_item IN inv_ebi_revised_item_obj
13: ,x_item OUT NOCOPY inv_ebi_item_obj
14: ,x_out OUT NOCOPY inv_ebi_item_output_obj
15: ) IS
16: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
17: l_main_item_obj inv_ebi_item_main_obj;
18: l_output_status inv_ebi_output_status;
19: BEGIN
20: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

Line 82: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

78: IF((p_change_order_obj.organization_id IS NULL
79: OR p_change_order_obj.organization_id = fnd_api.g_miss_num)
80: AND (p_change_order_obj.organization_code IS NOT NULL
81: OR p_change_order_obj.organization_code <> fnd_api.g_miss_char)) THEN
82: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
83: l_pk_col_name_val_pairs.EXTEND(1);
84: l_pk_col_name_val_pairs(1).name := 'organization_code';
85: l_pk_col_name_val_pairs(1).value := p_change_order_obj.organization_code;
86: x_item.main_obj_type.organization_id := INV_EBI_ITEM_HELPER.value_to_id(

Line 86: x_item.main_obj_type.organization_id := INV_EBI_ITEM_HELPER.value_to_id(

82: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
83: l_pk_col_name_val_pairs.EXTEND(1);
84: l_pk_col_name_val_pairs(1).name := 'organization_code';
85: l_pk_col_name_val_pairs(1).value := p_change_order_obj.organization_code;
86: x_item.main_obj_type.organization_id := INV_EBI_ITEM_HELPER.value_to_id(
87: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
88: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
89: );
90: INV_EBI_UTIL.debug_line('STEP 30: ORG ID: '|| x_item.main_obj_type.organization_id);

Line 88: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION

84: l_pk_col_name_val_pairs(1).name := 'organization_code';
85: l_pk_col_name_val_pairs(1).value := p_change_order_obj.organization_code;
86: x_item.main_obj_type.organization_id := INV_EBI_ITEM_HELPER.value_to_id(
87: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
88: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
89: );
90: INV_EBI_UTIL.debug_line('STEP 30: ORG ID: '|| x_item.main_obj_type.organization_id);
91: l_pk_col_name_val_pairs.TRIM(1);
92: IF (x_item.main_obj_type.organization_id IS NULL) THEN

Line 145: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

141: l_output_status inv_ebi_output_status;
142: l_designator_option NUMBER;
143: l_alt_bom_designator VARCHAR2(10);
144: l_inventory_item_id NUMBER;
145: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
146:
147: BEGIN
148: SAVEPOINT inv_ebi_engg_item_save_pnt;
149: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.transfer_engg_item_mfg');

Line 156: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

152:
153: IF(p_item.main_obj_type.inventory_item_id IS NULL OR
154: p_item.main_obj_type.inventory_item_id = fnd_api.g_miss_num) THEN
155:
156: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
157: l_pk_col_name_val_pairs.EXTEND(2);
158: l_pk_col_name_val_pairs(1).name := 'concatenated_segments';
159: l_pk_col_name_val_pairs(1).value := p_item.main_obj_type.item_number;
160: l_pk_col_name_val_pairs(2).name := 'organization_id';

Line 163: l_inventory_item_id := INV_EBI_ITEM_HELPER.value_to_id(

159: l_pk_col_name_val_pairs(1).value := p_item.main_obj_type.item_number;
160: l_pk_col_name_val_pairs(2).name := 'organization_id';
161: l_pk_col_name_val_pairs(2).value := p_item.main_obj_type.organization_id;
162: INV_EBI_UTIL.debug_line('STEP 20: ITEM NUMBER: '|| p_item.main_obj_type.item_number || ' ORG ID: '|| p_item.main_obj_type.organization_id);
163: l_inventory_item_id := INV_EBI_ITEM_HELPER.value_to_id(
164: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
165: ,p_entity_name => INV_EBI_ITEM_HELPER.G_INVENTORY_ITEM
166: );
167: INV_EBI_UTIL.debug_line('STEP 30: INV ITEM ID '|| l_inventory_item_id);

Line 165: ,p_entity_name => INV_EBI_ITEM_HELPER.G_INVENTORY_ITEM

161: l_pk_col_name_val_pairs(2).value := p_item.main_obj_type.organization_id;
162: INV_EBI_UTIL.debug_line('STEP 20: ITEM NUMBER: '|| p_item.main_obj_type.item_number || ' ORG ID: '|| p_item.main_obj_type.organization_id);
163: l_inventory_item_id := INV_EBI_ITEM_HELPER.value_to_id(
164: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
165: ,p_entity_name => INV_EBI_ITEM_HELPER.G_INVENTORY_ITEM
166: );
167: INV_EBI_UTIL.debug_line('STEP 30: INV ITEM ID '|| l_inventory_item_id);
168: l_pk_col_name_val_pairs.TRIM(2);
169: IF (l_inventory_item_id IS NULL ) THEN

Line 204: l_is_engineering_item := INV_EBI_ITEM_HELPER.is_engineering_item(

200: RAISE FND_API.g_exc_error;
201:
202: ELSE --End of Bug 8299853
203:
204: l_is_engineering_item := INV_EBI_ITEM_HELPER.is_engineering_item(
205: p_organization_id => p_item.main_obj_type.organization_id
206: ,p_item_number => p_item.main_obj_type.item_number
207: );
208:

Line 320: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

316: l_is_master_org VARCHAR2(3);
317: l_organization_id NUMBER;
318: l_component_item_name VARCHAR2(240);
319: l_is_component_item_exists VARCHAR2(3);
320: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
321: l_output_status inv_ebi_output_status;
322: BEGIN
323: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
324: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

Line 326: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

322: BEGIN
323: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
324: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
325: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.validate_component_items ORG CODE: '|| p_organization_code);
326: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
327: l_pk_col_name_val_pairs.EXTEND(1);
328: l_pk_col_name_val_pairs(1).name := 'organization_code';
329: l_pk_col_name_val_pairs(1).value := p_organization_code;
330: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(

Line 330: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(

326: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
327: l_pk_col_name_val_pairs.EXTEND(1);
328: l_pk_col_name_val_pairs(1).name := 'organization_code';
329: l_pk_col_name_val_pairs(1).value := p_organization_code;
330: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(
331: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
332: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
333: );
334: INV_EBI_UTIL.debug_line('STEP 20: ORG ID: '|| l_organization_id);

Line 332: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION

328: l_pk_col_name_val_pairs(1).name := 'organization_code';
329: l_pk_col_name_val_pairs(1).value := p_organization_code;
330: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(
331: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
332: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
333: );
334: INV_EBI_UTIL.debug_line('STEP 20: ORG ID: '|| l_organization_id);
335: IF (l_organization_id IS NULL) THEN
336: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');

Line 347: l_is_component_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(

343: FOR i IN 1.. p_component_item_tbl.COUNT LOOP
344: IF(p_component_item_tbl(i).transaction_type = INV_EBI_ITEM_PUB.g_otype_create ) THEN
345: l_component_item_name := p_component_item_tbl(i).component_item_name;
346: INV_EBI_UTIL.debug_line('STEP 30: COMP ITEM NAME: '|| l_component_item_name);
347: l_is_component_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(
348: p_organization_id => l_organization_id
349: ,p_item_number => l_component_item_name
350: );
351: IF(l_is_master_org = fnd_api.g_true AND l_is_component_item_exists = fnd_api.g_false) THEN

Line 395: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

391:
392: l_output_status inv_ebi_output_status;
393: l_transaction_type VARCHAR2(20);
394: l_item_catalog_group_code VARCHAR2(40);
395: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
396: l_item_output inv_ebi_item_output_obj;
397:
398: BEGIN
399: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.validate_item');

Line 404: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

400: INV_EBI_UTIL.debug_line('STEP 20: ITEM NUMBER TO VALIDATE : '|| p_item.main_obj_type.item_number ||
401: ' ORGANIZATION ID : '|| p_item.main_obj_type.organization_id);
402: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
403: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
404: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
405: FND_MSG_PUB.initialize;
406:
407: IF(INV_EBI_ITEM_HELPER.is_item_exists (
408: p_organization_id => p_item.main_obj_type.organization_id

Line 407: IF(INV_EBI_ITEM_HELPER.is_item_exists (

403: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
404: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
405: FND_MSG_PUB.initialize;
406:
407: IF(INV_EBI_ITEM_HELPER.is_item_exists (
408: p_organization_id => p_item.main_obj_type.organization_id
409: ,p_item_number => p_item.main_obj_type.item_number
410: ) = FND_API.g_false ) THEN
411:

Line 424: IF(INV_EBI_ITEM_HELPER.is_new_item_request_reqd(

420:
421: IF( p_item.main_obj_type.item_catalog_group_id IS NOT NULL
422: AND p_item.main_obj_type.item_catalog_group_id <> fnd_api.g_miss_num) THEN
423:
424: IF(INV_EBI_ITEM_HELPER.is_new_item_request_reqd(
425: p_item_catalog_group_id => p_item.main_obj_type.item_catalog_group_id
426: ) = FND_API.g_true AND
427: p_item.bom_obj_type.eng_item_flag = 'N') THEN
428:

Line 437: l_item_catalog_group_code := INV_EBI_ITEM_HELPER.id_to_value(

433:
434: l_pk_col_name_val_pairs.EXTEND(1);
435: l_pk_col_name_val_pairs(1).name := 'item_catalog_group_id';
436: l_pk_col_name_val_pairs(1).value := p_item.main_obj_type.item_catalog_group_id;
437: l_item_catalog_group_code := INV_EBI_ITEM_HELPER.id_to_value(
438: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
439: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ITEM_CATALOG_GROUP
440: );
441: l_pk_col_name_val_pairs.TRIM(1);

Line 439: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ITEM_CATALOG_GROUP

435: l_pk_col_name_val_pairs(1).name := 'item_catalog_group_id';
436: l_pk_col_name_val_pairs(1).value := p_item.main_obj_type.item_catalog_group_id;
437: l_item_catalog_group_code := INV_EBI_ITEM_HELPER.id_to_value(
438: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
439: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ITEM_CATALOG_GROUP
440: );
441: l_pk_col_name_val_pairs.TRIM(1);
442:
443: ELSE

Line 509: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

505: ,p_revised_item_type_tbl IN inv_ebi_revised_item_tbl
506: ,x_revised_item_type_tbl OUT NOCOPY inv_ebi_revitem_output_obj_tbl
507: )IS
508: l_organization_id NUMBER;
509: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
510: l_revised_item_type_tbl inv_ebi_revitem_output_obj_tbl;
511: l_ouid NUMBER;
512: l_operating_unit VARCHAR2(240);
513: BEGIN

Line 516: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

512: l_operating_unit VARCHAR2(240);
513: BEGIN
514: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.populate_revised_items_out');
515: INV_EBI_UTIL.debug_line('STEP 20: ECO: '|| p_change_order.eco_name || ' ORG CODE: '|| p_change_order.organization_code);
516: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
517: l_revised_item_type_tbl := inv_ebi_revitem_output_obj_tbl();
518: l_pk_col_name_val_pairs.EXTEND(1);
519: l_pk_col_name_val_pairs(1).name := 'organization_code';
520: l_pk_col_name_val_pairs(1).value := p_change_order.organization_code;

Line 522: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(

518: l_pk_col_name_val_pairs.EXTEND(1);
519: l_pk_col_name_val_pairs(1).name := 'organization_code';
520: l_pk_col_name_val_pairs(1).value := p_change_order.organization_code;
521:
522: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(
523: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
524: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
525: );
526: l_pk_col_name_val_pairs.TRIM(1);

Line 524: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION

520: l_pk_col_name_val_pairs(1).value := p_change_order.organization_code;
521:
522: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(
523: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
524: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
525: );
526: l_pk_col_name_val_pairs.TRIM(1);
527: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_ITEM_HELPER.get_Operating_unit ORG ID: '|| l_organization_id);
528: INV_EBI_ITEM_HELPER.get_Operating_unit

Line 527: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_ITEM_HELPER.get_Operating_unit ORG ID: '|| l_organization_id);

523: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
524: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
525: );
526: l_pk_col_name_val_pairs.TRIM(1);
527: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_ITEM_HELPER.get_Operating_unit ORG ID: '|| l_organization_id);
528: INV_EBI_ITEM_HELPER.get_Operating_unit
529: (p_oranization_id => l_organization_id
530: ,x_operating_unit => l_operating_unit
531: ,x_ouid => l_ouid

Line 528: INV_EBI_ITEM_HELPER.get_Operating_unit

524: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
525: );
526: l_pk_col_name_val_pairs.TRIM(1);
527: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_ITEM_HELPER.get_Operating_unit ORG ID: '|| l_organization_id);
528: INV_EBI_ITEM_HELPER.get_Operating_unit
529: (p_oranization_id => l_organization_id
530: ,x_operating_unit => l_operating_unit
531: ,x_ouid => l_ouid
532: );

Line 533: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING INV_EBI_ITEM_HELPER.get_Operating_unit OPERATING UNIT: '|| l_operating_unit);

529: (p_oranization_id => l_organization_id
530: ,x_operating_unit => l_operating_unit
531: ,x_ouid => l_ouid
532: );
533: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING INV_EBI_ITEM_HELPER.get_Operating_unit OPERATING UNIT: '|| l_operating_unit);
534: IF(p_revised_item_type_tbl IS NOT NULL AND p_revised_item_type_tbl.COUNT > 0) THEN
535: FOR i IN 1..p_revised_item_type_tbl.COUNT
536: LOOP
537: l_revised_item_type_tbl.extend();

Line 543: l_revised_item_type_tbl(i).revised_item.INVENTORY_ITEM_ID := INV_EBI_ITEM_HELPER.get_inventory_item_id

539: l_revised_item_type_tbl(i).revised_item := INV_EBI_ITEM_OUTPUT_OBJ(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
540: l_revised_item_type_tbl(i).revised_item.ORGANIZATION_CODE := p_change_order.organization_code ;
541: l_revised_item_type_tbl(i).revised_item.ORGANIZATION_ID := l_organization_id;
542: l_revised_item_type_tbl(i).revised_item.ITEM_NUMBER := p_revised_item_type_tbl(i).revised_item_name;
543: l_revised_item_type_tbl(i).revised_item.INVENTORY_ITEM_ID := INV_EBI_ITEM_HELPER.get_inventory_item_id
544: ( p_organization_id => l_organization_id
545: ,p_item_number => p_revised_item_type_tbl(i).revised_item_name);
546: l_revised_item_type_tbl(i).revised_item.operating_unit := l_operating_unit;
547: l_revised_item_type_tbl(i).revised_item.operating_unit_id := l_ouid;

Line 558: l_revised_item_type_tbl(i).rev_component(j).component.INVENTORY_ITEM_ID := INV_EBI_ITEM_HELPER.get_inventory_item_id

554: l_revised_item_type_tbl(i).rev_component(j).component := INV_EBI_ITEM_OUTPUT_OBJ(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
555: l_revised_item_type_tbl(i).rev_component(j).component.ORGANIZATION_CODE := p_change_order.organization_code ;
556: l_revised_item_type_tbl(i).rev_component(j).component.ORGANIZATION_ID := l_organization_id;
557: l_revised_item_type_tbl(i).rev_component(j).component.ITEM_NUMBER := p_revised_item_type_tbl(i).component_item_tbl(j).component_item_name;
558: l_revised_item_type_tbl(i).rev_component(j).component.INVENTORY_ITEM_ID := INV_EBI_ITEM_HELPER.get_inventory_item_id
559: ( p_organization_id => l_organization_id
560: ,p_item_number => p_revised_item_type_tbl(i).component_item_tbl(j).component_item_name);
561: l_revised_item_type_tbl(i).rev_component(j).component.operating_unit := l_operating_unit;
562: l_revised_item_type_tbl(i).rev_component(j).component.operating_unit_id := l_ouid;

Line 573: l_revised_item_type_tbl(i).rev_component(j).subcomponent(k).INVENTORY_ITEM_ID :=INV_EBI_ITEM_HELPER.get_inventory_item_id

569: l_revised_item_type_tbl(i).rev_component(j).subcomponent(k) :=INV_EBI_ITEM_OUTPUT_OBJ(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
570: l_revised_item_type_tbl(i).rev_component(j).subcomponent(k).ORGANIZATION_CODE := p_change_order.organization_code ;
571: l_revised_item_type_tbl(i).rev_component(j).subcomponent(k).ORGANIZATION_ID := l_organization_id;
572: l_revised_item_type_tbl(i).rev_component(j).subcomponent(k).ITEM_NUMBER := p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl(k).substitute_component_name;
573: l_revised_item_type_tbl(i).rev_component(j).subcomponent(k).INVENTORY_ITEM_ID :=INV_EBI_ITEM_HELPER.get_inventory_item_id
574: ( p_organization_id => l_organization_id
575: ,p_item_number => p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl(k).substitute_component_name);
576: l_revised_item_type_tbl(i).rev_component(j).subcomponent(k).operating_unit := l_operating_unit;
577: l_revised_item_type_tbl(i).rev_component(j).subcomponent(k).operating_unit_id := l_ouid;

Line 720: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_date);

716: ------------------------------------------------------------------------------
717: -- To Convert Date Fields in eco_change_order_type (INV_EBI_CHANGE_ORDER_OBJ)
718: ------------------------------------------------------------------------------
719: x_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_date_str :=
720: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_date);
721:
722: x_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_request_date_str :=
723: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_request_date);
724:

Line 723: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_request_date);

719: x_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_date_str :=
720: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_date);
721:
722: x_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_request_date_str :=
723: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_request_date);
724:
725: x_eco_lst_obj(i).eco_attr.eco_change_order_type.need_by_date_str :=
726: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.need_by_date);
727:

Line 726: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.need_by_date);

722: x_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_request_date_str :=
723: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_request_date);
724:
725: x_eco_lst_obj(i).eco_attr.eco_change_order_type.need_by_date_str :=
726: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.need_by_date);
727:
728: x_eco_lst_obj(i).eco_attr.eco_change_order_type.implementation_date_str :=
729: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.implementation_date);
730:

Line 729: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.implementation_date);

725: x_eco_lst_obj(i).eco_attr.eco_change_order_type.need_by_date_str :=
726: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.need_by_date);
727:
728: x_eco_lst_obj(i).eco_attr.eco_change_order_type.implementation_date_str :=
729: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.implementation_date);
730:
731: x_eco_lst_obj(i).eco_attr.eco_change_order_type.cancellation_date_str :=
732: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.cancellation_date);
733: ------------------------------------------------------------------------------

Line 732: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.cancellation_date);

728: x_eco_lst_obj(i).eco_attr.eco_change_order_type.implementation_date_str :=
729: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.implementation_date);
730:
731: x_eco_lst_obj(i).eco_attr.eco_change_order_type.cancellation_date_str :=
732: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.cancellation_date);
733: ------------------------------------------------------------------------------
734: -- To Convert Date Fields in eco_change_order_type (INV_EBI_UDA_ATTR_OBJ)
735: ------------------------------------------------------------------------------
736:

Line 746: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.change_order_uda.attribute_group_tbl(j).attributes_tbl(k).attr_value_date);

742: AND p_eco_lst_obj(i).eco_attr.eco_change_order_type.change_order_uda.attribute_group_tbl(j).attributes_tbl.COUNT>0) THEN
743: FOR k IN p_eco_lst_obj(i).eco_attr.eco_change_order_type.change_order_uda.attribute_group_tbl(j).attributes_tbl.FIRST..
744: p_eco_lst_obj(i).eco_attr.eco_change_order_type.change_order_uda.attribute_group_tbl(j).attributes_tbl.LAST LOOP
745: x_eco_lst_obj(i).eco_attr.eco_change_order_type.change_order_uda.attribute_group_tbl(j).attributes_tbl(k).attr_value_date_str :=
746: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.change_order_uda.attribute_group_tbl(j).attributes_tbl(k).attr_value_date);
747: END LOOP;
748: END IF;
749: END LOOP;
750: END IF;

Line 758: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).start_effective_date);

754: ----------------------------------------------------------------------------
755: IF(p_eco_lst_obj(i).eco_attr.eco_revised_item_type IS NOT NULL AND p_eco_lst_obj(i).eco_attr.eco_revised_item_type.COUNT>0) THEN
756: FOR j IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type.FIRST..p_eco_lst_obj(i).eco_attr.eco_revised_item_type.LAST LOOP
757: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).start_effective_date_str :=
758: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).start_effective_date);
759:
760: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).new_effective_date_str :=
761: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).new_effective_date);
762:

Line 761: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).new_effective_date);

757: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).start_effective_date_str :=
758: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).start_effective_date);
759:
760: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).new_effective_date_str :=
761: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).new_effective_date);
762:
763: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).earliest_effective_date_str :=
764: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).earliest_effective_date);
765:

Line 764: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).earliest_effective_date);

760: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).new_effective_date_str :=
761: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).new_effective_date);
762:
763: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).earliest_effective_date_str :=
764: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).earliest_effective_date);
765:
766: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).selection_date_str :=
767: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).selection_date);
768:

Line 767: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).selection_date);

763: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).earliest_effective_date_str :=
764: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).earliest_effective_date);
765:
766: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).selection_date_str :=
767: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).selection_date);
768:
769:
770: -------------------------------------------------------
771: -- Converting Dates For ORIGNAL_BOM_REFERENCE

Line 776: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).orignal_bom_reference.as_of_date);

772: -------------------------------------------------------
773:
774: IF(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).orignal_bom_reference IS NOT NULL) THEN
775: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).orignal_bom_reference.as_of_date_str :=
776: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).orignal_bom_reference.as_of_date);
777: END IF;
778:
779:
780: -------------------------------------------------------

Line 793: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item_revision_uda.attribute_group_tbl(k).attributes_tbl(l).attr_value_date);

789: IF(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item_revision_uda.attribute_group_tbl(k).attributes_tbl IS NOT NULL) THEN
790: FOR l IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item_revision_uda.attribute_group_tbl(k).attributes_tbl.FIRST..
791: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item_revision_uda.attribute_group_tbl(k).attributes_tbl.LAST LOOP
792: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item_revision_uda.attribute_group_tbl(k).attributes_tbl(l).attr_value_date_str :=
793: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item_revision_uda.attribute_group_tbl(k).attributes_tbl(l).attr_value_date);
794: END LOOP;
795: END IF;
796: END LOOP;
797: END IF;

Line 808: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.start_date_active);

804:
805: IF(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type IS NOT NULL) THEN
806:
807: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.start_date_active_str :=
808: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.start_date_active);
809:
810: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.end_date_active_str :=
811: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.end_date_active);
812:

Line 811: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.end_date_active);

807: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.start_date_active_str :=
808: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.start_date_active);
809:
810: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.end_date_active_str :=
811: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.end_date_active);
812:
813: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.creation_date_str :=
814: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.creation_date);
815:

Line 814: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.creation_date);

810: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.end_date_active_str :=
811: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.end_date_active);
812:
813: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.creation_date_str :=
814: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.creation_date);
815:
816: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.last_update_date_str :=
817: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.last_update_date);
818:

Line 817: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.last_update_date);

813: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.creation_date_str :=
814: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.creation_date);
815:
816: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.last_update_date_str :=
817: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.last_update_date);
818:
819: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.program_update_date_str :=
820: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.program_update_date);
821:

Line 820: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.program_update_date);

816: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.last_update_date_str :=
817: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.last_update_date);
818:
819: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.program_update_date_str :=
820: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.program_update_date);
821:
822: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.effectivity_date_str :=
823: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.effectivity_date);
824:

Line 823: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.effectivity_date);

819: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.program_update_date_str :=
820: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.program_update_date);
821:
822: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.effectivity_date_str :=
823: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.effectivity_date);
824:
825: END IF;
826:
827: ------------------------------------------------------

Line 834: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.engineering_date);

830:
831: IF(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type IS NOT NULL) THEN
832:
833: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.engineering_date_str :=
834: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.engineering_date);
835:
836: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.wh_update_date_str :=
837: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.wh_update_date_str);
838:

Line 837: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.wh_update_date_str);

833: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.engineering_date_str :=
834: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.engineering_date);
835:
836: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.wh_update_date_str :=
837: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.wh_update_date_str);
838:
839: END IF;
840:
841: --------------------------------------------------------

Line 854: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.uda_type.attribute_group_tbl(k).attributes_tbl(l).attr_value_date);

850: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.uda_type.attribute_group_tbl(k).attributes_tbl.COUNT>0) THEN
851: FOR l IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.uda_type.attribute_group_tbl(k).attributes_tbl.FIRST..
852: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.uda_type.attribute_group_tbl(k).attributes_tbl.LAST LOOP
853: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.uda_type.attribute_group_tbl(k).attributes_tbl(l).attr_value_date_str :=
854: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.uda_type.attribute_group_tbl(k).attributes_tbl(l).attr_value_date);
855: END LOOP;
856: END IF;
857: END LOOP;
858: END IF;

Line 874: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).structure_header.structure_header_uda.attribute_group_tbl(k).attributes_tbl(l).attr_value_date);

870: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).structure_header.structure_header_uda.attribute_group_tbl(k).attributes_tbl.COUNT>0) THEN
871: FOR l IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).structure_header.structure_header_uda.attribute_group_tbl(k).attributes_tbl.FIRST..
872: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).structure_header.structure_header_uda.attribute_group_tbl(k).attributes_tbl.LAST LOOP
873: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).structure_header.structure_header_uda.attribute_group_tbl(k).attributes_tbl(l).attr_value_date_str :=
874: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).structure_header.structure_header_uda.attribute_group_tbl(k).attributes_tbl(l).attr_value_date);
875: END LOOP;
876: END IF;
877: END LOOP;
878: END IF;

Line 890: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).start_effective_date);

886: FOR k IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl.FIRST..
887: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl.LAST LOOP
888:
889: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).start_effective_date_str :=
890: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).start_effective_date);
891:
892: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).new_effectivity_date_str :=
893: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).new_effectivity_date);
894:

Line 893: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).new_effectivity_date);

889: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).start_effective_date_str :=
890: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).start_effective_date);
891:
892: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).new_effectivity_date_str :=
893: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).new_effectivity_date);
894:
895: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).disable_date_str :=
896: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).disable_date);
897:

Line 896: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).disable_date);

892: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).new_effectivity_date_str :=
893: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).new_effectivity_date);
894:
895: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).disable_date_str :=
896: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).disable_date);
897:
898: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).old_effectivity_date_str :=
899: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).old_effectivity_date);
900:

Line 899: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).old_effectivity_date);

895: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).disable_date_str :=
896: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).disable_date);
897:
898: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).old_effectivity_date_str :=
899: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).old_effectivity_date);
900:
901: --------------------------------------------------------------------------
902: -- Converting Dates For substitute_component_tbl( INV_EBI_SUB_COMP_TBL )
903: --------------------------------------------------------------------------

Line 910: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).substitute_component_tbl(l).start_effective_date);

906: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).substitute_component_tbl.COUNT>0) THEN
907: FOR l IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).substitute_component_tbl.FIRST..
908: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).substitute_component_tbl.LAST LOOP
909: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).substitute_component_tbl(l).start_effective_date_str :=
910: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).substitute_component_tbl(l).start_effective_date);
911: END LOOP;
912: END IF;
913:
914: ----------------------------------------------------------------------------

Line 923: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).reference_designator_tbl(l).start_effective_date);

919: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).reference_designator_tbl.COUNT>0) THEN
920: FOR l IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).reference_designator_tbl.FIRST..
921: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).reference_designator_tbl.LAST LOOP
922: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).reference_designator_tbl(l).start_effective_date_str :=
923: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).reference_designator_tbl(l).start_effective_date);
924: END LOOP;
925: END IF;
926:
927: ----------------------------------------------------------------------------

Line 940: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).component_revision_uda.attribute_group_tbl(l).attributes_tbl(m).attr_value_date);

936: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).component_revision_uda.attribute_group_tbl(l).attributes_tbl.COUNT>0) THEN
937: FOR m IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).component_revision_uda.attribute_group_tbl(l).attributes_tbl.FIRST..
938: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).component_revision_uda.attribute_group_tbl(l).attributes_tbl.LAST LOOP
939: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).component_revision_uda.attribute_group_tbl(l).attributes_tbl(m).attr_value_date_str :=
940: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).component_revision_uda.attribute_group_tbl(l).attributes_tbl(m).attr_value_date);
941: END LOOP;
942: END IF;
943: END LOOP;
944: END IF;

Line 956: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).start_effective_date);

952: FOR k IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl.FIRST..
953: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl.LAST LOOP
954:
955: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).start_effective_date_str :=
956: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).start_effective_date);
957:
958: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).old_start_effective_number_str :=
959: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).old_start_effective_number);
960:

Line 959: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).old_start_effective_number);

955: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).start_effective_date_str :=
956: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).start_effective_date);
957:
958: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).old_start_effective_number_str :=
959: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).old_start_effective_number);
960:
961: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).disable_number_str :=
962: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).disable_number);
963: END LOOP;

Line 962: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).disable_number);

958: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).old_start_effective_number_str :=
959: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).old_start_effective_number);
960:
961: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).disable_number_str :=
962: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).disable_number);
963: END LOOP;
964: END IF;
965:
966: ----------------------------------------------------------------------------------

Line 975: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_op_resource_tbl(k).op_start_effective_date);

971: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_op_resource_tbl.COUNT>0) THEN
972: FOR k IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_op_resource_tbl.FIRST..
973: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_op_resource_tbl.LAST LOOP
974: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_op_resource_tbl(k).op_start_effective_date_str :=
975: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_op_resource_tbl(k).op_start_effective_date);
976: END LOOP;
977: END IF;
978:
979: ----------------------------------------------------------------------------------------------------------------

Line 988: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_sub_resource_tbl(k).op_start_effective_date);

984: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_sub_resource_tbl.COUNT>0) THEN
985: FOR k IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_sub_resource_tbl.FIRST..
986: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_sub_resource_tbl.LAST LOOP
987: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_sub_resource_tbl(k).op_start_effective_date_str :=
988: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_sub_resource_tbl(k).op_start_effective_date);
989: END LOOP;
990: END IF;
991: END LOOP;
992: END IF;

Line 1065: INV_EBI_ITEM_HELPER.set_server_time_zone;

1061: x_return_status := FND_API.G_RET_STS_SUCCESS;
1062: l_mult_org_chg_id_tbl := inv_ebi_change_id_obj_tbl();
1063: l_mult_org_chg_id_temp := inv_ebi_change_id_obj_tbl();
1064:
1065: INV_EBI_ITEM_HELPER.set_server_time_zone;
1066:
1067: INV_EBI_UTIL.setup();
1068:
1069: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.get_eco_list_attr');

Line 1256: INV_EBI_ITEM_HELPER.populate_item_ids(

1252:
1253: END IF;
1254: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_CHANGE_ORDER_PUB.populate_item_ids');
1255:
1256: INV_EBI_ITEM_HELPER.populate_item_ids(
1257: p_item => l_item
1258: ,x_out => l_item_output_obj
1259: ,x_item => l_eco_obj.eco_revised_item_type(i).item
1260: );

Line 1305: IF( INV_EBI_ITEM_HELPER.is_item_exists (

1301: END IF;
1302:
1303: l_revision_set := FALSE;
1304:
1305: IF( INV_EBI_ITEM_HELPER.is_item_exists (
1306: p_organization_id => l_eco_obj.eco_revised_item_type(i).item.main_obj_type.organization_id
1307: ,p_item_number => l_eco_obj.eco_revised_item_type(i).item.main_obj_type.item_number
1308: ) = FND_API.g_false ) THEN
1309:

Line 1322: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

1318: l_master_org := INV_EBI_UTIL.get_master_organization(
1319: p_organization_id => l_eco_obj.eco_revised_item_type(i).item.main_obj_type.organization_id
1320: );
1321:
1322: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
1323: p_organization_id => l_master_org
1324: ,p_item_number => l_eco_obj.eco_revised_item_type(i).item.main_obj_type.item_number
1325: );
1326:

Line 1353: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING INV_EBI_ITEM_HELPER.sync_item');

1349: END IF;
1350:
1351: --call Create New Production Item API .This will also process existing item information.
1352:
1353: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING INV_EBI_ITEM_HELPER.sync_item');
1354: INV_EBI_ITEM_HELPER.sync_item(
1355: p_commit => FND_API.g_false
1356: ,p_operation => INV_EBI_ITEM_PUB.g_otype_create
1357: ,p_item => l_eco_obj.eco_revised_item_type(i).item

Line 1354: INV_EBI_ITEM_HELPER.sync_item(

1350:
1351: --call Create New Production Item API .This will also process existing item information.
1352:
1353: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING INV_EBI_ITEM_HELPER.sync_item');
1354: INV_EBI_ITEM_HELPER.sync_item(
1355: p_commit => FND_API.g_false
1356: ,p_operation => INV_EBI_ITEM_PUB.g_otype_create
1357: ,p_item => l_eco_obj.eco_revised_item_type(i).item
1358: ,x_out => l_item_output_obj

Line 1361: INV_EBI_UTIL.debug_line('STEP 100: END CALLING INV_EBI_ITEM_HELPER.sync_item STATUS: '|| l_item_output_obj.output_status.return_status);

1357: ,p_item => l_eco_obj.eco_revised_item_type(i).item
1358: ,x_out => l_item_output_obj
1359: );
1360:
1361: INV_EBI_UTIL.debug_line('STEP 100: END CALLING INV_EBI_ITEM_HELPER.sync_item STATUS: '|| l_item_output_obj.output_status.return_status);
1362:
1363: l_item_count := l_item_count + 1;
1364:
1365: IF (l_item_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1522: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_ITEM_HELPER.sync_item');

1518: IF(p_update_item_tbl IS NOT NULL AND p_update_item_tbl.COUNT > 0) THEN
1519:
1520: FOR i IN 1..p_update_item_tbl.COUNT LOOP
1521:
1522: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_ITEM_HELPER.sync_item');
1523:
1524: INV_EBI_ITEM_HELPER.sync_item(
1525: p_commit => FND_API.g_false
1526: ,p_operation => INV_EBI_ITEM_PUB.g_otype_update

Line 1524: INV_EBI_ITEM_HELPER.sync_item(

1520: FOR i IN 1..p_update_item_tbl.COUNT LOOP
1521:
1522: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_ITEM_HELPER.sync_item');
1523:
1524: INV_EBI_ITEM_HELPER.sync_item(
1525: p_commit => FND_API.g_false
1526: ,p_operation => INV_EBI_ITEM_PUB.g_otype_update
1527: ,p_item => p_update_item_tbl(i).item_obj
1528: ,x_out => x_out

Line 1530: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_ITEM_HELPER.sync_item for item updation STATUS: '|| x_out.output_status.return_status);

1526: ,p_operation => INV_EBI_ITEM_PUB.g_otype_update
1527: ,p_item => p_update_item_tbl(i).item_obj
1528: ,x_out => x_out
1529: );
1530: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_ITEM_HELPER.sync_item for item updation STATUS: '|| x_out.output_status.return_status);
1531: IF (x_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
1532: x_out.item_number := p_update_item_tbl(i).item_obj.main_obj_type.item_number;
1533: x_out.organization_code := p_update_item_tbl(i).item_obj.main_obj_type.organization_code;
1534: RAISE fnd_api.g_exc_unexpected_error;

Line 2099: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

2095: p_eco_obj.eco_revised_item_type(i).item.uda_type.attribute_group_tbl.COUNT > 0) THEN
2096:
2097: -- To process Revised Item udas
2098:
2099: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
2100: p_organization_id => l_organization_id
2101: ,p_item_number => p_eco_obj.eco_revised_item_type(i).revised_item_name
2102: );
2103: INV_EBI_UTIL.debug_line('STEP 90: START CALLING INV_EBI_ITEM_HELPER.process_item_uda'||'INV ITEM ID: '||l_inventory_item_id ||

Line 2103: INV_EBI_UTIL.debug_line('STEP 90: START CALLING INV_EBI_ITEM_HELPER.process_item_uda'||'INV ITEM ID: '||l_inventory_item_id ||

2099: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
2100: p_organization_id => l_organization_id
2101: ,p_item_number => p_eco_obj.eco_revised_item_type(i).revised_item_name
2102: );
2103: INV_EBI_UTIL.debug_line('STEP 90: START CALLING INV_EBI_ITEM_HELPER.process_item_uda'||'INV ITEM ID: '||l_inventory_item_id ||
2104: 'ORG ID: '||l_organization_id|| 'CATALOG GROUP ID: '||p_eco_obj.eco_revised_item_type(i).item.main_obj_type.item_catalog_group_id ||
2105: 'REVISED ITEM REVISION: '||p_eco_obj.eco_revised_item_type(i).new_revised_item_revision);
2106: INV_EBI_ITEM_HELPER.process_item_uda(
2107: p_api_version => l_api_version

Line 2106: INV_EBI_ITEM_HELPER.process_item_uda(

2102: );
2103: INV_EBI_UTIL.debug_line('STEP 90: START CALLING INV_EBI_ITEM_HELPER.process_item_uda'||'INV ITEM ID: '||l_inventory_item_id ||
2104: 'ORG ID: '||l_organization_id|| 'CATALOG GROUP ID: '||p_eco_obj.eco_revised_item_type(i).item.main_obj_type.item_catalog_group_id ||
2105: 'REVISED ITEM REVISION: '||p_eco_obj.eco_revised_item_type(i).new_revised_item_revision);
2106: INV_EBI_ITEM_HELPER.process_item_uda(
2107: p_api_version => l_api_version
2108: ,p_inventory_item_id => l_inventory_item_id
2109: ,p_organization_id => l_organization_id
2110: ,p_item_catalog_group_id => p_eco_obj.eco_revised_item_type(i).item.main_obj_type.item_catalog_group_id

Line 2117: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING INV_EBI_ITEM_HELPER.process_item_uda STATUS: '|| l_item_output.output_status.return_status);

2113: ,p_uda_input_obj => p_eco_obj.eco_revised_item_type(i).item.uda_type
2114: ,p_commit => fnd_api.g_false
2115: ,x_uda_output_obj => l_item_output
2116: );
2117: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING INV_EBI_ITEM_HELPER.process_item_uda STATUS: '|| l_item_output.output_status.return_status);
2118: END IF;
2119:
2120: IF (l_item_output.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2121: x_out.output_status.return_status := l_item_output.output_status.msg_data;

Line 2413: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_EBI_ITEM_HELPER.process_update_item_lifecycle');

2409: -- be a pending CO while trying to update the item,as it is not possible to update lc/lcp/status when there are pending
2410: -- CO's,so callout to process_update_item_lifecycle api is made to update these 3 attributes before CO is created.
2411: -- If user wants to update these values again,all the pending CO's should be implemented/cancelled.
2412:
2413: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_EBI_ITEM_HELPER.process_update_item_lifecycle');
2414: INV_EBI_ITEM_HELPER.process_update_item_lifecycle(
2415: p_commit => FND_API.g_false
2416: ,p_update_item_tbl => l_updated_item_tbl
2417: ,x_out => l_item_output_obj

Line 2414: INV_EBI_ITEM_HELPER.process_update_item_lifecycle(

2410: -- CO's,so callout to process_update_item_lifecycle api is made to update these 3 attributes before CO is created.
2411: -- If user wants to update these values again,all the pending CO's should be implemented/cancelled.
2412:
2413: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_EBI_ITEM_HELPER.process_update_item_lifecycle');
2414: INV_EBI_ITEM_HELPER.process_update_item_lifecycle(
2415: p_commit => FND_API.g_false
2416: ,p_update_item_tbl => l_updated_item_tbl
2417: ,x_out => l_item_output_obj
2418: );

Line 2419: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING INV_EBI_ITEM_HELPER.process_update_item_lifecycle for item updation STATUS: '|| l_item_output_obj.output_status.return_status);

2415: p_commit => FND_API.g_false
2416: ,p_update_item_tbl => l_updated_item_tbl
2417: ,x_out => l_item_output_obj
2418: );
2419: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING INV_EBI_ITEM_HELPER.process_update_item_lifecycle for item updation STATUS: '|| l_item_output_obj.output_status.return_status);
2420:
2421: --End of bug 10416391
2422:
2423: IF (l_item_output_obj.output_status.return_status <> fnd_api.g_ret_sts_success) THEN

Line 2530: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(

2526: l_eco_obj_list(i).eco_revised_item_type(j).item.uda_type.attribute_group_tbl.COUNT > 0) THEN
2527:
2528: -- To process Revised Item udas
2529:
2530: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
2531: p_organization_code => l_eco_obj_list(i).eco_change_order_type.organization_code
2532: );
2533:
2534: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

Line 2534: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

2530: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
2531: p_organization_code => l_eco_obj_list(i).eco_change_order_type.organization_code
2532: );
2533:
2534: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
2535: p_organization_id => l_organization_id
2536: ,p_item_number => l_eco_obj_list(i).eco_revised_item_type(j).revised_item_name
2537: );
2538:

Line 2540: INV_EBI_UTIL.debug_line('STEP 150: START CALLING INV_EBI_ITEM_HELPER.process_item_uda'||'INV ITEM ID: '||l_inventory_item_id ||

2536: ,p_item_number => l_eco_obj_list(i).eco_revised_item_type(j).revised_item_name
2537: );
2538:
2539:
2540: INV_EBI_UTIL.debug_line('STEP 150: START CALLING INV_EBI_ITEM_HELPER.process_item_uda'||'INV ITEM ID: '||l_inventory_item_id ||
2541: 'ORG ID: '||l_organization_id|| 'CATALOG GROUP ID: '||l_eco_obj_list(i).eco_revised_item_type(j).item.main_obj_type.item_catalog_group_id ||
2542: 'REVISED ITEM REVISION: '||l_eco_obj_list(i).eco_revised_item_type(j).new_revised_item_revision);
2543: INV_EBI_ITEM_HELPER.process_item_uda(
2544: p_api_version => l_api_version

Line 2543: INV_EBI_ITEM_HELPER.process_item_uda(

2539:
2540: INV_EBI_UTIL.debug_line('STEP 150: START CALLING INV_EBI_ITEM_HELPER.process_item_uda'||'INV ITEM ID: '||l_inventory_item_id ||
2541: 'ORG ID: '||l_organization_id|| 'CATALOG GROUP ID: '||l_eco_obj_list(i).eco_revised_item_type(j).item.main_obj_type.item_catalog_group_id ||
2542: 'REVISED ITEM REVISION: '||l_eco_obj_list(i).eco_revised_item_type(j).new_revised_item_revision);
2543: INV_EBI_ITEM_HELPER.process_item_uda(
2544: p_api_version => l_api_version
2545: ,p_inventory_item_id => l_inventory_item_id
2546: ,p_organization_id => l_organization_id
2547: ,p_item_catalog_group_id => l_eco_obj_list(i).eco_revised_item_type(j).item.main_obj_type.item_catalog_group_id

Line 2555: INV_EBI_UTIL.debug_line('STEP 160: AFTER CALLING INV_EBI_ITEM_HELPER.process_item_uda STATUS: '|| l_item_output_obj.output_status.return_status);

2551: ,p_commit => fnd_api.g_false
2552: ,x_uda_output_obj => l_item_output_obj
2553: );
2554:
2555: INV_EBI_UTIL.debug_line('STEP 160: AFTER CALLING INV_EBI_ITEM_HELPER.process_item_uda STATUS: '|| l_item_output_obj.output_status.return_status);
2556: END IF;
2557:
2558: IF (l_item_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2559: x_out(i) := inv_ebi_eco_output_obj( l_eco_obj_list(i).eco_change_order_type.eco_name,NULL,NULL,l_eco_obj_list(i).eco_change_order_type.organization_code