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_UTIL

Line 298: l_is_master_org := INV_EBI_UTIL.is_master_org(l_organization_id);

294: FND_MESSAGE.set_token('COL_VALUE',p_organization_code);
295: FND_MSG_PUB.add;
296: RAISE FND_API.g_exc_error;
297: END IF;
298: l_is_master_org := INV_EBI_UTIL.is_master_org(l_organization_id);
299: IF(p_component_item_tbl IS NOT NULL AND p_component_item_tbl.COUNT > 0) THEN
300: FOR i IN 1.. p_component_item_tbl.COUNT LOOP
301: IF(p_component_item_tbl(i).transaction_type = INV_EBI_ITEM_PUB.g_otype_create ) THEN
302: l_component_item_name := p_component_item_tbl(i).component_item_name;

Line 548: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order');

544: SAVEPOINT inv_ebi_chg_order_save_pnt;
545: FND_MSG_PUB.initialize;
546: --fnd_global.apps_initialize(1068,56229,724,0);
547: l_uda_output := inv_ebi_uda_output_obj(NULL,NULL);
548: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order');
549: l_category_output := inv_ebi_category_output_obj(NULL);
550: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
551: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
552: l_item_output_tbl := inv_ebi_item_output_tbl();

Line 583: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING INV_EBI_CHANGE_ORDER_PUB.validate_eco');

579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
580: END IF;
581: END LOOP;
582: END IF;
583: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING INV_EBI_CHANGE_ORDER_PUB.validate_eco');
584:
585: validate_eco(
586: p_eco_obj => l_eco_obj_validate_eco
587: ,x_out => l_out

Line 589: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING INV_EBI_CHANGE_ORDER_PUB.validate_eco');

585: validate_eco(
586: p_eco_obj => l_eco_obj_validate_eco
587: ,x_out => l_out
588: );
589: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING INV_EBI_CHANGE_ORDER_PUB.validate_eco');
590: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
591: x_out.output_status.msg_data := l_out.output_Status.msg_data;
592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
593: END IF;

Line 624: l_master_org := INV_EBI_UTIL.get_master_organization(

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(
625: p_organization_id => l_eco_obj_validate_eco.eco_revised_item_type(i).item.main_obj_type.organization_id
626: );
627:
628: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

Line 654: INV_EBI_UTIL.debug_line('STEP: 40 START CALLING INV_EBI_ITEM_HELPER.sync_item');

650: END IF;
651: END IF;
652:
653: --call Create New Production Item API .This will also process existing item information.
654: INV_EBI_UTIL.debug_line('STEP: 40 START CALLING INV_EBI_ITEM_HELPER.sync_item');
655: INV_EBI_ITEM_HELPER.sync_item(
656: p_commit => FND_API.g_false
657: ,p_operation => INV_EBI_ITEM_PUB.g_otype_create
658: ,p_item => l_eco_obj_validate_eco.eco_revised_item_type(i).item

Line 661: INV_EBI_UTIL.debug_line('STEP: 50 END CALLING INV_EBI_ITEM_HELPER.sync_item');

657: ,p_operation => INV_EBI_ITEM_PUB.g_otype_create
658: ,p_item => l_eco_obj_validate_eco.eco_revised_item_type(i).item
659: ,x_out => l_item_output
660: );
661: INV_EBI_UTIL.debug_line('STEP: 50 END CALLING INV_EBI_ITEM_HELPER.sync_item');
662: l_item_count := l_item_count + 1;
663: l_item_output_tbl.EXTEND(1);
664: l_item_output_tbl(l_item_count) := l_item_output;
665:

Line 688: INV_EBI_UTIL.debug_line('STEP: 60 START update mtl_item_revisions_b');

684: p_inventory_item_id => l_item_output.inventory_item_id
685: );
686: FETCH c_effectivity_date INTO l_revision;
687: CLOSE c_effectivity_date;
688: INV_EBI_UTIL.debug_line('STEP: 60 START update mtl_item_revisions_b');
689: UPDATE mtl_item_revisions_b
690: SET
691: implementation_date = sysdate,
692: effectivity_date = sysdate,

Line 701: INV_EBI_UTIL.debug_line('STEP: 70 END update mtl_item_revisions_b');

697: WHERE
698: inventory_item_id = l_item_output.inventory_item_id AND
699: organization_id = l_item_output.organization_id AND
700: revision = l_revision;
701: INV_EBI_UTIL.debug_line('STEP: 70 END update mtl_item_revisions_b');
702: END IF;
703:
704: ELSE
705:

Line 716: INV_EBI_UTIL.debug_line('STEP: 80 START CALLING transfer_engg_item_mfg');

712: l_update_item_tab(l_update_item_count) := l_item_count;
713: l_item_output_tbl.EXTEND(1);
714:
715: --Transfer Engg Item to Manufacturing
716: INV_EBI_UTIL.debug_line('STEP: 80 START CALLING transfer_engg_item_mfg');
717: transfer_engg_item_mfg(
718: p_item => l_eco_obj_validate_eco.eco_revised_item_type(i).item
719: ,p_alt_bom_designator => l_eco_obj_validate_eco.eco_revised_item_type(i).alternate_bom_code
720: ,x_out => l_out

Line 722: INV_EBI_UTIL.debug_line('STEP: 90 END CALLING transfer_engg_item_mfg');

718: p_item => l_eco_obj_validate_eco.eco_revised_item_type(i).item
719: ,p_alt_bom_designator => l_eco_obj_validate_eco.eco_revised_item_type(i).alternate_bom_code
720: ,x_out => l_out
721: );
722: INV_EBI_UTIL.debug_line('STEP: 90 END CALLING transfer_engg_item_mfg');
723: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
724: x_out.output_status.msg_data := l_out.output_status.msg_data;
725: RAISE fnd_api.g_exc_unexpected_error;
726: END IF;

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 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 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 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 836: INV_EBI_UTIL.debug_line('STEP: 160 START CALLING ENG_CHANGE_LIFECYCLE_UTIL.Change_Phase');

832: IF ( (NOT l_is_wf_Set) AND
833: (NOT l_is_task_template_set) AND
834: (l_status_code > l_curr_status_code) ) THEN
835: --Bug 6833363
836: INV_EBI_UTIL.debug_line('STEP: 160 START CALLING ENG_CHANGE_LIFECYCLE_UTIL.Change_Phase');
837:
838: ENG_CHANGE_LIFECYCLE_UTIL.Change_Phase(
839: p_api_version => 1.0
840: ,p_commit => FND_API.g_false

Line 849: INV_EBI_UTIL.debug_line('STEP: 170 END CALLING ENG_CHANGE_LIFECYCLE_UTIL.Change_Phase');

845: ,x_return_status => l_out.output_status.return_status
846: ,x_msg_count => l_out.output_status.msg_count
847: ,x_msg_data => l_out.output_status.msg_data
848: );
849: INV_EBI_UTIL.debug_line('STEP: 170 END CALLING ENG_CHANGE_LIFECYCLE_UTIL.Change_Phase');
850: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
851: x_out.output_status.msg_data := l_out.output_status.msg_data;
852: RAISE FND_API.g_exc_unexpected_error;
853: END IF;

Line 857: IF (INV_EBI_UTIL.is_pim_installed) THEN

853: END IF;
854: END IF;
855:
856: --Processing of Udas
857: IF (INV_EBI_UTIL.is_pim_installed) THEN
858: IF ((l_eco_obj.eco_change_order_type IS NOT NULL AND l_eco_obj.eco_change_order_type.change_order_uda IS NOT NULL)
859: AND l_eco_obj.eco_change_order_type.change_order_uda.attribute_group_tbl.COUNT > 0) THEN
860: IF ((l_eco_obj.eco_change_order_type.eco_name IS NOT NULL)
861: AND (l_eco_obj.eco_change_order_type.organization_id IS NULL OR l_eco_obj.eco_change_order_type.organization_id =FND_API.g_miss_num)

Line 950: INV_EBI_UTIL.debug_line('STEP: 180 START CALLING INV_EBI_ITEM_HELPER.sync_item');

946:
947: --Revised Item updation should be done after eco creation Bug 7025686
948: FOR j in 1..l_item_obj_tbl.COUNT LOOP
949: l_update_item_index := l_update_item_tab(j);
950: INV_EBI_UTIL.debug_line('STEP: 180 START CALLING INV_EBI_ITEM_HELPER.sync_item');
951: INV_EBI_ITEM_HELPER.sync_item(
952: p_commit => FND_API.g_false
953: ,p_operation => INV_EBI_ITEM_PUB.g_otype_update
954: ,p_item => l_item_obj_tbl(j).item_obj

Line 957: INV_EBI_UTIL.debug_line('STEP: 190 END CALLING INV_EBI_ITEM_HELPER.sync_item');

953: ,p_operation => INV_EBI_ITEM_PUB.g_otype_update
954: ,p_item => l_item_obj_tbl(j).item_obj
955: ,x_out => l_item_output
956: );
957: INV_EBI_UTIL.debug_line('STEP: 190 END CALLING INV_EBI_ITEM_HELPER.sync_item');
958: l_item_output_tbl(l_update_item_index) := l_item_output;
959:
960: IF (l_item_output.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
961: x_out.output_status.msg_data := l_item_output.output_status.msg_data;

Line 965: INV_EBI_UTIL.debug_line('STEP: 200 START CALLING populate_revised_items_out');

961: x_out.output_status.msg_data := l_item_output.output_status.msg_data;
962: RAISE fnd_api.g_exc_unexpected_error;
963: END IF;
964: END LOOP;
965: INV_EBI_UTIL.debug_line('STEP: 200 START CALLING populate_revised_items_out');
966:
967: --To populate revised item,componnet item,substitute components ids
968: populate_revised_items_out(
969: p_change_order => p_eco_obj.eco_change_order_type

Line 976: INV_EBI_UTIL.debug_line('STEP: 200 END CALLING populate_revised_items_out');

972: );
973:
974: x_out := inv_ebi_eco_output_obj(l_change_notice,l_change_id,l_organization_id,l_organization_code,
975: l_item_output.output_status,l_revitem_output_tbl,l_uda_output);
976: INV_EBI_UTIL.debug_line('STEP: 200 END CALLING populate_revised_items_out');
977: IF FND_API.to_boolean(p_commit) THEN
978: COMMIT;
979: END IF;
980: INV_EBI_UTIL.debug_line('STEP: 210 END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order');

Line 980: INV_EBI_UTIL.debug_line('STEP: 210 END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order');

976: INV_EBI_UTIL.debug_line('STEP: 200 END CALLING populate_revised_items_out');
977: IF FND_API.to_boolean(p_commit) THEN
978: COMMIT;
979: END IF;
980: INV_EBI_UTIL.debug_line('STEP: 210 END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order');
981: EXCEPTION
982: WHEN FND_API.g_exc_unexpected_error THEN
983: ROLLBACK TO inv_ebi_chg_order_save_pnt;
984: IF c_effectivity_date%ISOPEN THEN

Line 988: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();

984: IF c_effectivity_date%ISOPEN THEN
985: CLOSE c_effectivity_date;
986: END IF;
987: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
988: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
989: IF (x_out.output_status.error_table IS NOT NULL AND x_out.output_status.error_table.COUNT > 0) THEN
990: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
991: IF(x_out.output_status.msg_data IS NULL) THEN
992: FND_MSG_PUB.count_and_get(

Line 990: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);

986: END IF;
987: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
988: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
989: IF (x_out.output_status.error_table IS NOT NULL AND x_out.output_status.error_table.COUNT > 0) THEN
990: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
991: IF(x_out.output_status.msg_data IS NULL) THEN
992: FND_MSG_PUB.count_and_get(
993: p_encoded => FND_API.g_false
994: ,p_count => x_out.output_status.msg_count

Line 1005: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();

1001: IF c_effectivity_date%ISOPEN THEN
1002: CLOSE c_effectivity_date;
1003: END IF;
1004:
1005: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
1006: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1007: IF (x_out.output_status.error_table IS NOT NULL AND x_out.output_status.error_table.COUNT > 0) THEN
1008: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
1009: END IF;

Line 1008: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);

1004:
1005: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
1006: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1007: IF (x_out.output_status.error_table IS NOT NULL AND x_out.output_status.error_table.COUNT > 0) THEN
1008: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
1009: END IF;
1010: IF (x_out.output_status.msg_data IS NOT NULL) THEN
1011: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_PUB.process_change_order ';
1012: ELSE

Line 1581: INV_EBI_UTIL.setup();

1577: BEGIN
1578: SAVEPOINT inv_ebi_prc_chg_ord_save_pnt;
1579: ERROR_HANDLER.Initialize;
1580: FND_MSG_PUB.initialize;
1581: INV_EBI_UTIL.setup();
1582: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list');
1583: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1584: x_out := inv_ebi_eco_output_obj_tbl();
1585: IF (p_eco_obj_list IS NOT NULL AND p_eco_obj_list.count > 0) THEN

Line 1582: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list');

1578: SAVEPOINT inv_ebi_prc_chg_ord_save_pnt;
1579: ERROR_HANDLER.Initialize;
1580: FND_MSG_PUB.initialize;
1581: INV_EBI_UTIL.setup();
1582: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list');
1583: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1584: x_out := inv_ebi_eco_output_obj_tbl();
1585: IF (p_eco_obj_list IS NOT NULL AND p_eco_obj_list.count > 0) THEN
1586: x_out.extend(p_eco_obj_list.count);

Line 1592: l_is_master_org := INV_EBI_UTIL.is_master_org(l_org_code);

1588: LOOP
1589: l_inv_ebi_eco_obj := p_eco_obj_list(i);
1590: l_eco_name := p_eco_obj_list(i).eco_change_order_type.eco_name;
1591: l_org_code := p_eco_obj_list(i).eco_change_order_type.organization_code;
1592: l_is_master_org := INV_EBI_UTIL.is_master_org(l_org_code);
1593: IF( l_is_master_org = fnd_api.g_true ) THEN
1594: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Master ORG'||
1595: ' Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1596: ' ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);

Line 1594: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Master ORG'||

1590: l_eco_name := p_eco_obj_list(i).eco_change_order_type.eco_name;
1591: l_org_code := p_eco_obj_list(i).eco_change_order_type.organization_code;
1592: l_is_master_org := INV_EBI_UTIL.is_master_org(l_org_code);
1593: IF( l_is_master_org = fnd_api.g_true ) THEN
1594: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Master ORG'||
1595: ' Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1596: ' ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);
1597:
1598: INV_EBI_CHANGE_ORDER_PUB.process_change_order( p_commit => p_commit

Line 1602: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Master ORG'||

1598: INV_EBI_CHANGE_ORDER_PUB.process_change_order( p_commit => p_commit
1599: ,p_eco_obj => l_inv_ebi_eco_obj
1600: ,x_out => l_inv_ebi_eco_output_obj
1601: );
1602: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Master ORG'||
1603: 'Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1604: 'ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);
1605: x_out(i) := l_inv_ebi_eco_output_obj;
1606: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1618: l_is_master_org := INV_EBI_UTIL.is_master_org(l_org_code);

1614: LOOP
1615: l_inv_ebi_eco_obj := p_eco_obj_list(i);
1616: l_eco_name := p_eco_obj_list(i).eco_change_order_type.eco_name;
1617: l_org_code := p_eco_obj_list(i).eco_change_order_type.organization_code;
1618: l_is_master_org := INV_EBI_UTIL.is_master_org(l_org_code);
1619: IF( l_is_master_org = fnd_api.g_false ) THEN
1620: INV_EBI_UTIL.debug_line('STEP: 40 START CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Child ORG'||
1621: ' Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1622: ' ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);

Line 1620: INV_EBI_UTIL.debug_line('STEP: 40 START CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Child ORG'||

1616: l_eco_name := p_eco_obj_list(i).eco_change_order_type.eco_name;
1617: l_org_code := p_eco_obj_list(i).eco_change_order_type.organization_code;
1618: l_is_master_org := INV_EBI_UTIL.is_master_org(l_org_code);
1619: IF( l_is_master_org = fnd_api.g_false ) THEN
1620: INV_EBI_UTIL.debug_line('STEP: 40 START CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Child ORG'||
1621: ' Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1622: ' ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);
1623: INV_EBI_CHANGE_ORDER_PUB.process_change_order( p_commit => p_commit
1624: ,p_eco_obj => l_inv_ebi_eco_obj

Line 1627: INV_EBI_UTIL.debug_line('STEP: 50 END CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Child ORG'||

1623: INV_EBI_CHANGE_ORDER_PUB.process_change_order( p_commit => p_commit
1624: ,p_eco_obj => l_inv_ebi_eco_obj
1625: ,x_out => l_inv_ebi_eco_output_obj
1626: );
1627: INV_EBI_UTIL.debug_line('STEP: 50 END CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Child ORG'||
1628: ' Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1629: ' ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);
1630: x_out(i) := l_inv_ebi_eco_output_obj;
1631: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1638: INV_EBI_UTIL.debug_line('STEP: 60 END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list');

1634: END IF;
1635: END LOOP;
1636: END IF;
1637:
1638: INV_EBI_UTIL.debug_line('STEP: 60 END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list');
1639: INV_EBI_UTIL.wrapup;
1640: EXCEPTION
1641: WHEN FND_API.g_exc_unexpected_error THEN
1642: ROLLBACK TO inv_ebi_prc_chg_ord_save_pnt;

Line 1639: INV_EBI_UTIL.wrapup;

1635: END LOOP;
1636: END IF;
1637:
1638: INV_EBI_UTIL.debug_line('STEP: 60 END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list');
1639: INV_EBI_UTIL.wrapup;
1640: EXCEPTION
1641: WHEN FND_API.g_exc_unexpected_error THEN
1642: ROLLBACK TO inv_ebi_prc_chg_ord_save_pnt;
1643: x_return_status := FND_API.G_RET_STS_ERROR;