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_CHANGE_ORDER_HELPER

Line 620: IF(INV_EBI_CHANGE_ORDER_HELPER.is_child_org (

616: /* Bug 7197943 After subsequent release of ecos in master org ,If Chnage Order is released in Child Org
617: then we should create initial rev,current rev of the item in master org through process_item API
618: and incoming revision through process_eco API */
619:
620: IF(INV_EBI_CHANGE_ORDER_HELPER.is_child_org (
621: p_organization_id => l_eco_obj_validate_eco.eco_revised_item_type(i).item.main_obj_type.organization_id
622: ) = fnd_api.g_true) THEN
623:
624: l_master_org := INV_EBI_UTIL.get_master_organization(

Line 633: l_current_revision := INV_EBI_CHANGE_ORDER_HELPER.get_current_item_revision(

629: p_organization_id => l_master_org
630: ,p_item_number => l_eco_obj_validate_eco.eco_revised_item_type(i).item.main_obj_type.item_number
631: );
632:
633: l_current_revision := INV_EBI_CHANGE_ORDER_HELPER.get_current_item_revision(
634: p_inventory_item_id => l_inventory_item_id,
635: p_organization_id => l_master_org,
636: p_date => sysdate
637: );

Line 734: IF (UPPER(l_eco_obj_validate_eco.name_value_tbl(i).param_name) = INV_EBI_CHANGE_ORDER_HELPER.G_ASSIGN_ITEM_TO_CHILD_ORG) THEN

730: END IF;
731:
732: IF l_eco_obj_validate_eco.name_value_tbl IS NOT NULL THEN
733: FOR i in l_eco_obj_validate_eco.name_value_tbl.FIRST..l_eco_obj_validate_eco.name_value_tbl.LAST LOOP
734: IF (UPPER(l_eco_obj_validate_eco.name_value_tbl(i).param_name) = INV_EBI_CHANGE_ORDER_HELPER.G_ASSIGN_ITEM_TO_CHILD_ORG) THEN
735: l_assign_item_to_child_org := l_eco_obj_validate_eco.name_value_tbl(i).param_value;
736: INV_EBI_CHANGE_ORDER_HELPER.set_assign_item(
737: p_assign_item => l_assign_item_to_child_org
738: );

Line 736: INV_EBI_CHANGE_ORDER_HELPER.set_assign_item(

732: IF l_eco_obj_validate_eco.name_value_tbl IS NOT NULL THEN
733: FOR i in l_eco_obj_validate_eco.name_value_tbl.FIRST..l_eco_obj_validate_eco.name_value_tbl.LAST LOOP
734: IF (UPPER(l_eco_obj_validate_eco.name_value_tbl(i).param_name) = INV_EBI_CHANGE_ORDER_HELPER.G_ASSIGN_ITEM_TO_CHILD_ORG) THEN
735: l_assign_item_to_child_org := l_eco_obj_validate_eco.name_value_tbl(i).param_value;
736: INV_EBI_CHANGE_ORDER_HELPER.set_assign_item(
737: p_assign_item => l_assign_item_to_child_org
738: );
739: END IF;
740: END LOOP;

Line 742: INV_EBI_UTIL.debug_line('STEP: 100 START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom');

738: );
739: END IF;
740: END LOOP;
741: END IF;
742: INV_EBI_UTIL.debug_line('STEP: 100 START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom');
743: --Processing of Replicate Bom
744: INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom(
745: p_eco_obj => l_eco_obj_validate_eco
746: ,x_eco_obj => l_eco_obj

Line 744: INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom(

740: END LOOP;
741: END IF;
742: INV_EBI_UTIL.debug_line('STEP: 100 START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom');
743: --Processing of Replicate Bom
744: INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom(
745: p_eco_obj => l_eco_obj_validate_eco
746: ,x_eco_obj => l_eco_obj
747: ,x_out => l_out
748: );

Line 749: INV_EBI_UTIL.debug_line('STEP: 110 END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom');

745: p_eco_obj => l_eco_obj_validate_eco
746: ,x_eco_obj => l_eco_obj
747: ,x_out => l_out
748: );
749: INV_EBI_UTIL.debug_line('STEP: 110 END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom');
750: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
751: x_out.output_status.msg_data := l_out.output_status.msg_data;
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: END IF;

Line 760: INV_EBI_UTIL.debug_line('STEP: 120 START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header'||

756: FOR i IN 1 .. l_eco_obj.eco_revised_item_type.COUNT
757: LOOP
758: IF(l_eco_obj.eco_revised_item_type(i).structure_header IS NOT NULL) THEN
759: --Structure Header creation and Common Bom processing
760: INV_EBI_UTIL.debug_line('STEP: 120 START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header'||
761: ' For Revised Item Name: '||l_eco_obj.eco_revised_item_type(i).revised_item_name);
762:
763: INV_EBI_CHANGE_ORDER_HELPER.process_structure_header(
764: p_commit => FND_API.g_false

Line 763: INV_EBI_CHANGE_ORDER_HELPER.process_structure_header(

759: --Structure Header creation and Common Bom processing
760: INV_EBI_UTIL.debug_line('STEP: 120 START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header'||
761: ' For Revised Item Name: '||l_eco_obj.eco_revised_item_type(i).revised_item_name);
762:
763: INV_EBI_CHANGE_ORDER_HELPER.process_structure_header(
764: p_commit => FND_API.g_false
765: ,p_organization_code => l_eco_obj.eco_change_order_type.organization_code
766: ,p_assembly_item_name => l_eco_obj.eco_revised_item_type(i).revised_item_name
767: ,p_alternate_bom_code => l_eco_obj.eco_revised_item_type(i).alternate_bom_code

Line 773: INV_EBI_UTIL.debug_line('STEP: 130 END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header'||

769: ,p_component_item_tbl => l_eco_obj.eco_revised_item_type(i).component_item_tbl -- Bug 7196996
770: ,p_name_val_list => inv_ebi_name_value_list(l_eco_obj.name_value_tbl)
771: ,x_out => l_out
772: );
773: INV_EBI_UTIL.debug_line('STEP: 130 END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header'||
774: ' For Revised Item Name: '||l_eco_obj.eco_revised_item_type(i).revised_item_name);
775: END IF;
776: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
777: x_out.output_status.msg_data := l_out.output_status.msg_data;

Line 784: INV_EBI_UTIL.debug_line('STEP: 140 START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco');

780: END LOOP;
781: END IF;
782: bom_globals.set_bo_identifier(bom_globals.g_eco_bo);
783: --Change Order Creation
784: INV_EBI_UTIL.debug_line('STEP: 140 START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco');
785: INV_EBI_CHANGE_ORDER_HELPER.process_eco(
786: p_commit => FND_API.g_false
787: ,p_change_order => l_eco_obj.eco_change_order_type
788: ,p_revision_type_tbl => l_eco_obj.eco_revision_type

Line 785: INV_EBI_CHANGE_ORDER_HELPER.process_eco(

781: END IF;
782: bom_globals.set_bo_identifier(bom_globals.g_eco_bo);
783: --Change Order Creation
784: INV_EBI_UTIL.debug_line('STEP: 140 START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco');
785: INV_EBI_CHANGE_ORDER_HELPER.process_eco(
786: p_commit => FND_API.g_false
787: ,p_change_order => l_eco_obj.eco_change_order_type
788: ,p_revision_type_tbl => l_eco_obj.eco_revision_type
789: ,p_revised_item_type_tbl => l_eco_obj.eco_revised_item_type

Line 793: INV_EBI_UTIL.debug_line('STEP: 150 END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco');

789: ,p_revised_item_type_tbl => l_eco_obj.eco_revised_item_type
790: ,p_name_val_list => inv_ebi_name_value_list(l_eco_obj.name_value_tbl)
791: ,x_out => l_out
792: );
793: INV_EBI_UTIL.debug_line('STEP: 150 END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco');
794: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
795: x_out.output_status.msg_data := l_out.output_status.msg_data;
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
797: END IF;

Line 804: l_is_wf_Set := INV_EBI_CHANGE_ORDER_HELPER.Check_Workflow_Process(p_change_order_type_id => l_eco_obj.eco_change_order_type.change_type_id

800: l_change_notice := l_out.change_notice;
801: l_organization_id := l_out.organization_id;
802: l_organization_code := l_out.organization_code;
803:
804: l_is_wf_Set := INV_EBI_CHANGE_ORDER_HELPER.Check_Workflow_Process(p_change_order_type_id => l_eco_obj.eco_change_order_type.change_type_id
805: ,p_priority_code => l_eco_obj.eco_change_order_type.priority_code
806: );
807: SELECT status_code
808: INTO l_curr_status_code

Line 812: l_status_name := INV_EBI_CHANGE_ORDER_HELPER.get_eco_status_name(l_eco_obj.eco_change_order_type.status_code);

808: INTO l_curr_status_code
809: FROM eng_engineering_changes
810: WHERE change_id = l_change_id;
811:
812: l_status_name := INV_EBI_CHANGE_ORDER_HELPER.get_eco_status_name(l_eco_obj.eco_change_order_type.status_code);
813:
814: IF (LOWER(l_status_name) = 'implemented' ) THEN
815: SELECT status_code
816: INTO l_status_code

Line 826: l_is_task_template_set := INV_EBI_CHANGE_ORDER_HELPER.is_task_template_set(

822:
823: /*Bug 7218542:If some task is associated at organization level for the change order type
824: we cannot promote it to scheduled status.*/
825:
826: l_is_task_template_set := INV_EBI_CHANGE_ORDER_HELPER.is_task_template_set(
827: p_change_order_type_id => l_eco_obj.eco_change_order_type.change_type_id
828: ,p_organization_id => l_organization_id
829: ,p_status_code => l_status_code
830: );

Line 878: INV_EBI_CHANGE_ORDER_HELPER.process_uda(

874: l_pkcode.extend();
875: l_pkcode(1) := ego_col_name_value_pair_obj('CHANGE_TYPE_ID',l_change_order_type_id);
876:
877: --To process Change order header udas
878: INV_EBI_CHANGE_ORDER_HELPER.process_uda(
879: p_uda_input_obj => l_eco_obj.eco_change_order_type.change_order_uda
880: ,p_commit => fnd_api.g_false
881: ,p_object_name => 'ENG_CHANGE'
882: ,p_data_level => 'CHANGE_LEVEL'

Line 927: INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda(

923: END IF;
924:
925: l_uda_output := inv_ebi_uda_output_obj(l_item_output.uda_output.failed_row_id_list,l_item_output.uda_output.errorcode);
926: -- To process Component level udas and structure header level udas
927: INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda(
928: p_commit => FND_API.g_false
929: ,p_organization_code => l_eco_obj.eco_change_order_type.organization_code
930: ,p_eco_name => l_eco_obj.eco_change_order_type.eco_name
931: ,p_alternate_bom_code => l_eco_obj.eco_revised_item_type(i).alternate_bom_code

Line 1067: INV_EBI_CHANGE_ORDER_HELPER.get_eco (

1063: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
1064: ,NULL,NULL,NULL,NULL
1065: );
1066:
1067: INV_EBI_CHANGE_ORDER_HELPER.get_eco (
1068: p_change_id => p_change_id
1069: ,p_last_update_status => p_last_update_status
1070: ,p_revised_item_sequence_id => p_revised_item_sequence_id
1071: ,p_name_val_list => p_name_val_list

Line 1505: INV_EBI_CHANGE_ORDER_HELPER.get_eco (

1501: FETCH c_get_final_eco_list BULK COLLECT INTO l_eco_output_tbl_lst;
1502: CLOSE c_get_final_eco_list;
1503: IF (l_eco_output_tbl_lst IS NOT NULL) THEN
1504: FOR l_cnt_cid IN 1..l_eco_output_tbl_lst.COUNT LOOP
1505: INV_EBI_CHANGE_ORDER_HELPER.get_eco (
1506: p_change_id => l_eco_output_tbl_lst(l_cnt_cid).change_id
1507: ,p_last_update_status => l_eco_output_tbl_lst(l_cnt_cid).last_update_status
1508: ,p_revised_item_sequence_id => NULL
1509: ,p_name_val_list => l_name_val_list