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 639: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco');

635: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
636: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
637: ,NULL,NULL,NULL,NULL
638: );
639: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco');
640: INV_EBI_CHANGE_ORDER_HELPER.get_eco (
641: p_change_id => p_change_id
642: ,p_last_update_status => p_last_update_status
643: ,p_revised_item_sequence_id => p_revised_item_sequence_id

Line 640: INV_EBI_CHANGE_ORDER_HELPER.get_eco (

636: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
637: ,NULL,NULL,NULL,NULL
638: );
639: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco');
640: INV_EBI_CHANGE_ORDER_HELPER.get_eco (
641: p_change_id => p_change_id
642: ,p_last_update_status => p_last_update_status
643: ,p_revised_item_sequence_id => p_revised_item_sequence_id
644: ,p_name_val_list => p_name_val_list

Line 650: INV_EBI_UTIL.debug_line('STEP 40: END CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco RETURN STATUS: '||l_return_status);

646: ,x_return_status => l_return_status
647: ,x_msg_count => l_msg_count
648: ,x_msg_data => l_msg_data
649: );
650: INV_EBI_UTIL.debug_line('STEP 40: END CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco RETURN STATUS: '||l_return_status);
651: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
652: RAISE FND_API.g_exc_unexpected_error;
653: END IF;
654: IF p_name_val_list.name_value_table IS NOT NULL THEN

Line 1117: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco ');

1113: END IF;
1114: INV_EBI_UTIL.debug_line( 'Size of Change id table ' || l_eco_output_tbl_lst.COUNT);
1115:
1116: IF (l_eco_output_tbl_lst IS NOT NULL) THEN
1117: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco ');
1118: FOR l_cnt_cid IN 1..l_eco_output_tbl_lst.COUNT LOOP
1119: INV_EBI_CHANGE_ORDER_HELPER.get_eco (
1120: p_change_id => l_eco_output_tbl_lst(l_cnt_cid).change_id
1121: ,p_last_update_status => l_eco_output_tbl_lst(l_cnt_cid).last_update_status

Line 1119: INV_EBI_CHANGE_ORDER_HELPER.get_eco (

1115:
1116: IF (l_eco_output_tbl_lst IS NOT NULL) THEN
1117: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco ');
1118: FOR l_cnt_cid IN 1..l_eco_output_tbl_lst.COUNT LOOP
1119: INV_EBI_CHANGE_ORDER_HELPER.get_eco (
1120: p_change_id => l_eco_output_tbl_lst(l_cnt_cid).change_id
1121: ,p_last_update_status => l_eco_output_tbl_lst(l_cnt_cid).last_update_status
1122: ,p_revised_item_sequence_id => NULL
1123: ,p_name_val_list => l_name_val_list

Line 1150: INV_EBI_UTIL.debug_line('STEP 30: END CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco STATUS: '|| l_return_status);

1146: END LOOP;
1147: IF (l_ovrflw_msg='Y') AND SUBSTR(x_msg_data,length(x_msg_data)-2) <> '...' THEN
1148: x_msg_data :=x_msg_data||' , '||'...';
1149: END IF;
1150: INV_EBI_UTIL.debug_line('STEP 30: END CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco STATUS: '|| l_return_status);
1151: END IF;
1152:
1153: IF (l_eco_obj_tbl IS NOT NULL AND l_eco_obj_tbl.COUNT > 0) THEN
1154: x_eco_lst_obj := l_eco_obj_tbl;

Line 1314: IF(INV_EBI_CHANGE_ORDER_HELPER.is_child_org (

1310: /* Bug 7132835 After subsequent release of ecos in master org ,If Change order is released in Child Org
1311: then we should create initial rev,current rev of the item in master org through process_item API
1312: and incoming revision through process_eco API */
1313:
1314: IF(INV_EBI_CHANGE_ORDER_HELPER.is_child_org (
1315: p_organization_id => l_eco_obj.eco_revised_item_type(i).item.main_obj_type.organization_id
1316: ) = fnd_api.g_true) THEN
1317:
1318: l_master_org := INV_EBI_UTIL.get_master_organization(

Line 1327: l_current_revision := INV_EBI_CHANGE_ORDER_HELPER.get_current_item_revision(

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:
1327: l_current_revision := INV_EBI_CHANGE_ORDER_HELPER.get_current_item_revision(
1328: p_inventory_item_id => l_inventory_item_id,
1329: p_organization_id => l_master_org,
1330: p_date => sysdate
1331: );

Line 1677: l_is_bom_exists := INV_EBI_CHANGE_ORDER_HELPER.is_bom_exists(

1673: AND l_eco_obj.eco_revised_item_type(j).orignal_bom_reference.ORGANIZATION_CODE IS NOT NULL
1674: AND l_eco_obj.eco_revised_item_type(j).orignal_bom_reference.ORGANIZATION_CODE <> fnd_api.g_miss_char
1675: ) THEN
1676:
1677: l_is_bom_exists := INV_EBI_CHANGE_ORDER_HELPER.is_bom_exists(
1678: p_item_number => l_eco_obj.eco_revised_item_type(j).revised_item_name,
1679: p_organization_code => l_eco_obj.eco_change_order_type.organization_code,
1680: p_alternate_bom_code => l_eco_obj.eco_revised_item_type(j).alternate_bom_code
1681: );

Line 1693: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info');

1689:
1690: l_replicate_bom_org_tbl(l_replicate_bom_cnt) := l_eco_obj.eco_change_order_type.organization_code;
1691: l_replicate_bom_eco_tbl(l_replicate_bom_cnt) := l_eco_obj.eco_change_order_type.eco_name;
1692:
1693: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info');
1694: INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info(
1695: p_eco_obj_list => p_eco_obj_list
1696: ,p_revised_item_obj => l_eco_obj.eco_revised_item_type(j)
1697: ,x_revised_item_obj => l_eco_obj.eco_revised_item_type(j)

Line 1694: INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info(

1690: l_replicate_bom_org_tbl(l_replicate_bom_cnt) := l_eco_obj.eco_change_order_type.organization_code;
1691: l_replicate_bom_eco_tbl(l_replicate_bom_cnt) := l_eco_obj.eco_change_order_type.eco_name;
1692:
1693: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info');
1694: INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info(
1695: p_eco_obj_list => p_eco_obj_list
1696: ,p_revised_item_obj => l_eco_obj.eco_revised_item_type(j)
1697: ,x_revised_item_obj => l_eco_obj.eco_revised_item_type(j)
1698: ,x_out => l_out

Line 1700: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info STATUS: '|| l_out.output_status.return_status);

1696: ,p_revised_item_obj => l_eco_obj.eco_revised_item_type(j)
1697: ,x_revised_item_obj => l_eco_obj.eco_revised_item_type(j)
1698: ,x_out => l_out
1699: );
1700: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info STATUS: '|| l_out.output_status.return_status);
1701: IF(l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1702: x_out.change_notice := l_eco_obj.eco_change_order_type.eco_name;
1703: x_out.organization_code := l_eco_obj.eco_change_order_type.organization_code;
1704: x_out.output_status.msg_data := l_out.output_status.msg_data;

Line 1721: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header ' ||

1717: IF( l_common_bom_found = FND_API.g_false
1718: AND l_replicate_bom_found = FND_API.g_false
1719: AND l_eco_obj.eco_revised_item_type(j).structure_header IS NOT NULL) THEN
1720:
1721: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header ' ||
1722: ' FOR Normal BOM '||' REVISED ITEM NAME: '|| l_eco_obj.eco_revised_item_type(j).revised_item_name);
1723: INV_EBI_CHANGE_ORDER_HELPER.process_structure_header(
1724: p_commit => FND_API.g_false
1725: ,p_organization_code => l_eco_obj.eco_change_order_type.organization_code

Line 1723: INV_EBI_CHANGE_ORDER_HELPER.process_structure_header(

1719: AND l_eco_obj.eco_revised_item_type(j).structure_header IS NOT NULL) THEN
1720:
1721: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header ' ||
1722: ' FOR Normal BOM '||' REVISED ITEM NAME: '|| l_eco_obj.eco_revised_item_type(j).revised_item_name);
1723: INV_EBI_CHANGE_ORDER_HELPER.process_structure_header(
1724: p_commit => FND_API.g_false
1725: ,p_organization_code => l_eco_obj.eco_change_order_type.organization_code
1726: ,p_assembly_item_name => l_eco_obj.eco_revised_item_type(j).revised_item_name
1727: ,p_alternate_bom_code => l_eco_obj.eco_revised_item_type(j).alternate_bom_code

Line 1733: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header STATUS: '|| l_out.output_status.return_status);

1729: ,p_component_item_tbl => l_eco_obj.eco_revised_item_type(j).component_item_tbl -- Bug 7192021
1730: ,p_name_val_list => inv_ebi_name_value_list(l_eco_obj.name_value_tbl)
1731: ,x_out => l_out
1732: );
1733: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header STATUS: '|| l_out.output_status.return_status);
1734: IF(l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1735: x_out.change_notice := l_eco_obj.eco_change_order_type.eco_name;
1736: x_out.organization_code := l_eco_obj.eco_change_order_type.organization_code;
1737: x_out.output_status.msg_data := l_out.output_status.msg_data;

Line 1760: INV_EBI_UTIL.debug_line('STEP 80: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header '|| 'FOR COMMON BOM '||

1756:
1757: END IF;
1758:
1759: END LOOP;
1760: INV_EBI_UTIL.debug_line('STEP 80: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header '|| 'FOR COMMON BOM '||
1761: ' REVISED ITEM NAME: '|| l_common_assy_item_tbl(l_common_assy_item_cnt).revised_item_name ||
1762: ' COMMON ORG CODE: '|| l_common_assy_item_tbl(l_common_assy_item_cnt).structure_header.common_organization_code ||
1763: ' COMMON ASSY ITEM NAME: '|| l_common_assy_item_tbl(l_common_assy_item_cnt).structure_header.common_assembly_item_name);
1764: INV_EBI_CHANGE_ORDER_HELPER.process_structure_header(

Line 1764: INV_EBI_CHANGE_ORDER_HELPER.process_structure_header(

1760: INV_EBI_UTIL.debug_line('STEP 80: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header '|| 'FOR COMMON BOM '||
1761: ' REVISED ITEM NAME: '|| l_common_assy_item_tbl(l_common_assy_item_cnt).revised_item_name ||
1762: ' COMMON ORG CODE: '|| l_common_assy_item_tbl(l_common_assy_item_cnt).structure_header.common_organization_code ||
1763: ' COMMON ASSY ITEM NAME: '|| l_common_assy_item_tbl(l_common_assy_item_cnt).structure_header.common_assembly_item_name);
1764: INV_EBI_CHANGE_ORDER_HELPER.process_structure_header(
1765: p_commit => FND_API.g_false
1766: ,p_organization_code => l_common_org_tbl(l_common_assy_item_cnt)
1767: ,p_assembly_item_name => l_common_assy_item_tbl(l_common_assy_item_cnt).revised_item_name
1768: ,p_alternate_bom_code => l_common_assy_item_tbl(l_common_assy_item_cnt).alternate_bom_code

Line 1774: INV_EBI_UTIL.debug_line('STEP 90: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header '

1770: ,p_component_item_tbl => l_common_assy_item_tbl(l_common_assy_item_cnt).component_item_tbl -- Bug 7192021
1771: ,p_name_val_list => inv_ebi_name_value_list(l_name_value_tbl)
1772: ,x_out => l_out
1773: );
1774: INV_EBI_UTIL.debug_line('STEP 90: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header '
1775: || 'FOR COMMON BOM STATUS: '|| l_out.output_status.return_status);
1776: IF(l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1777: x_out.change_notice := l_common_eco_tbl(l_common_assy_item_cnt);
1778: x_out.organization_code := l_common_org_tbl(l_common_assy_item_cnt);

Line 1806: INV_EBI_UTIL.debug_line('STEP 100: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom '

1802: END LOOP;
1803: END IF;
1804: END LOOP;
1805:
1806: INV_EBI_UTIL.debug_line('STEP 100: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom '
1807: || 'FOR REPLICATE BOM ');
1808: INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom(
1809: p_organization_code => l_replicate_bom_org_tbl(l_replicate_bom_cnt)
1810: ,p_revised_item_obj => l_replicate_bom_tbl(l_replicate_bom_cnt)

Line 1808: INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom(

1804: END LOOP;
1805:
1806: INV_EBI_UTIL.debug_line('STEP 100: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom '
1807: || 'FOR REPLICATE BOM ');
1808: INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom(
1809: p_organization_code => l_replicate_bom_org_tbl(l_replicate_bom_cnt)
1810: ,p_revised_item_obj => l_replicate_bom_tbl(l_replicate_bom_cnt)
1811: ,p_name_value_tbl => l_name_value_tbl
1812: ,x_revised_item_obj => l_replicate_bom_item_obj

Line 1815: INV_EBI_UTIL.debug_line('STEP 110: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom ' ||

1811: ,p_name_value_tbl => l_name_value_tbl
1812: ,x_revised_item_obj => l_replicate_bom_item_obj
1813: ,x_out => l_out
1814: );
1815: INV_EBI_UTIL.debug_line('STEP 110: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom ' ||
1816: ' FOR REPLICATE BOM STATUS: '|| l_out.output_status.return_status);
1817:
1818: x_eco_obj_list(l_eco_idx).eco_revised_item_type(l_item_idx) := l_replicate_bom_item_obj;
1819:

Line 1832: INV_EBI_UTIL.debug_line('STEP 120: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header ' ||

1828: RAISE FND_API.g_exc_unexpected_error;
1829: END IF;
1830:
1831: IF(l_replicate_bom_tbl(l_replicate_bom_cnt).structure_header IS NOT NULL) THEN
1832: INV_EBI_UTIL.debug_line('STEP 120: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header ' ||
1833: ' FOR REPLICATE BOM '||' REVISED ITEM NAME: '|| l_replicate_bom_tbl(l_replicate_bom_cnt).revised_item_name ||
1834: ' COMMON ASSY ITEM NAME: '|| l_replicate_bom_tbl(l_replicate_bom_cnt).structure_header.common_assembly_item_name ||
1835: ' COMMON ORG CODE: '|| l_replicate_bom_tbl(l_replicate_bom_cnt).structure_header.common_organization_code);
1836: INV_EBI_CHANGE_ORDER_HELPER.process_structure_header(

Line 1836: INV_EBI_CHANGE_ORDER_HELPER.process_structure_header(

1832: INV_EBI_UTIL.debug_line('STEP 120: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header ' ||
1833: ' FOR REPLICATE BOM '||' REVISED ITEM NAME: '|| l_replicate_bom_tbl(l_replicate_bom_cnt).revised_item_name ||
1834: ' COMMON ASSY ITEM NAME: '|| l_replicate_bom_tbl(l_replicate_bom_cnt).structure_header.common_assembly_item_name ||
1835: ' COMMON ORG CODE: '|| l_replicate_bom_tbl(l_replicate_bom_cnt).structure_header.common_organization_code);
1836: INV_EBI_CHANGE_ORDER_HELPER.process_structure_header(
1837: p_commit => FND_API.g_false
1838: ,p_organization_code => l_replicate_bom_org_tbl(l_replicate_bom_cnt)
1839: ,p_assembly_item_name => l_replicate_bom_tbl(l_replicate_bom_cnt).revised_item_name
1840: ,p_alternate_bom_code => l_replicate_bom_tbl(l_replicate_bom_cnt).alternate_bom_code

Line 1847: INV_EBI_UTIL.debug_line('STEP 130: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header STATUS: '|| l_out.output_status.return_status);

1843: ,p_name_val_list => inv_ebi_name_value_list(l_name_value_tbl)
1844: ,x_out => l_out
1845: );
1846:
1847: INV_EBI_UTIL.debug_line('STEP 130: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header STATUS: '|| l_out.output_status.return_status);
1848:
1849: IF(l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1850:
1851: x_out.change_notice := l_replicate_bom_eco_tbl(l_replicate_bom_cnt);

Line 1962: INV_EBI_UTIL.debug_line('STEP 30: START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco');

1958: l_revitem_output_tbl := inv_ebi_revitem_output_obj_tbl();
1959:
1960: bom_globals.set_bo_identifier(bom_globals.g_eco_bo);
1961:
1962: INV_EBI_UTIL.debug_line('STEP 30: START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco');
1963: INV_EBI_CHANGE_ORDER_HELPER.process_eco(
1964: p_commit => FND_API.g_false
1965: ,p_change_order => p_eco_obj.eco_change_order_type
1966: ,p_revision_type_tbl => p_eco_obj.eco_revision_type

Line 1963: INV_EBI_CHANGE_ORDER_HELPER.process_eco(

1959:
1960: bom_globals.set_bo_identifier(bom_globals.g_eco_bo);
1961:
1962: INV_EBI_UTIL.debug_line('STEP 30: START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco');
1963: INV_EBI_CHANGE_ORDER_HELPER.process_eco(
1964: p_commit => FND_API.g_false
1965: ,p_change_order => p_eco_obj.eco_change_order_type
1966: ,p_revision_type_tbl => p_eco_obj.eco_revision_type
1967: ,p_revised_item_type_tbl => p_eco_obj.eco_revised_item_type

Line 1971: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco STATUS: '|| l_out.output_status.return_status);

1967: ,p_revised_item_type_tbl => p_eco_obj.eco_revised_item_type
1968: ,p_name_val_list => inv_ebi_name_value_list(p_eco_obj.name_value_tbl)
1969: ,x_out => l_out
1970: );
1971: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco STATUS: '|| l_out.output_status.return_status);
1972: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1973: x_out.output_status.msg_data := l_out.output_status.msg_data;
1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975: END IF;

Line 1982: l_is_wf_Set := INV_EBI_CHANGE_ORDER_HELPER.Check_Workflow_Process(p_change_order_type_id => p_eco_obj.eco_change_order_type.change_type_id

1978: l_change_notice := l_out.change_notice;
1979: l_organization_id := l_out.organization_id;
1980: l_organization_code := l_out.organization_code;
1981:
1982: l_is_wf_Set := INV_EBI_CHANGE_ORDER_HELPER.Check_Workflow_Process(p_change_order_type_id => p_eco_obj.eco_change_order_type.change_type_id
1983: ,p_priority_code => p_eco_obj.eco_change_order_type.priority_code
1984: );
1985:
1986: --added for bug 13893810

Line 1987: l_is_plmwf_Set := INV_EBI_CHANGE_ORDER_HELPER.Check_Workflow_In_PLM(p_change_id => l_change_id

1983: ,p_priority_code => p_eco_obj.eco_change_order_type.priority_code
1984: );
1985:
1986: --added for bug 13893810
1987: l_is_plmwf_Set := INV_EBI_CHANGE_ORDER_HELPER.Check_Workflow_In_PLM(p_change_id => l_change_id
1988: );
1989:
1990: SELECT status_code
1991: INTO l_curr_status_code

Line 2000: l_status_name := INV_EBI_CHANGE_ORDER_HELPER.get_eco_status_name(p_eco_obj.eco_change_order_type.status_code);

1996:
1997: IF( p_eco_obj.eco_change_order_type.status_code IS NOT NULL AND
1998: p_eco_obj.eco_change_order_type.status_code <> fnd_api.g_miss_num) THEN
1999:
2000: l_status_name := INV_EBI_CHANGE_ORDER_HELPER.get_eco_status_name(p_eco_obj.eco_change_order_type.status_code);
2001:
2002: END IF;
2003:
2004: IF (LOWER(l_status_name) = 'implemented' ) THEN

Line 2016: l_is_task_template_set := INV_EBI_CHANGE_ORDER_HELPER.is_task_template_set(

2012:
2013: /*Bug 7218542:If some task is associated at organization level for the change order type
2014: we cannot promote it to scheduled status.*/
2015:
2016: l_is_task_template_set := INV_EBI_CHANGE_ORDER_HELPER.is_task_template_set(
2017: p_change_order_type_id => p_eco_obj.eco_change_order_type.change_type_id
2018: ,p_organization_id => l_organization_id
2019: ,p_status_code => l_status_code
2020: );

Line 2070: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda');

2066: l_pkcode.extend();
2067: l_pkcode(1) := ego_col_name_value_pair_obj('CHANGE_TYPE_ID',l_change_order_type_id);
2068:
2069: --To process Change order header udas
2070: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda');
2071: INV_EBI_CHANGE_ORDER_HELPER.process_uda(
2072: p_uda_input_obj => p_eco_obj.eco_change_order_type.change_order_uda
2073: ,p_commit => fnd_api.g_false
2074: ,p_object_name => 'ENG_CHANGE'

Line 2071: INV_EBI_CHANGE_ORDER_HELPER.process_uda(

2067: l_pkcode(1) := ego_col_name_value_pair_obj('CHANGE_TYPE_ID',l_change_order_type_id);
2068:
2069: --To process Change order header udas
2070: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda');
2071: INV_EBI_CHANGE_ORDER_HELPER.process_uda(
2072: p_uda_input_obj => p_eco_obj.eco_change_order_type.change_order_uda
2073: ,p_commit => fnd_api.g_false
2074: ,p_object_name => 'ENG_CHANGE'
2075: ,p_data_level => 'CHANGE_LEVEL'

Line 2080: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda STATUS: '|| l_out.output_status.return_status);

2076: ,p_pk_column_name_value_pairs => l_pkdata
2077: ,p_class_code_name_value_pairs => l_pkcode
2078: ,x_uda_output_obj => l_out
2079: );
2080: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda STATUS: '|| l_out.output_status.return_status);
2081: END IF;
2082: IF(l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2083: x_out.output_status.msg_data := l_out.output_status.msg_data;
2084: RAISE fnd_api.g_exc_unexpected_error;

Line 2128: INV_EBI_UTIL.debug_line('STEP 90: START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda');

2124:
2125: l_uda_output := inv_ebi_uda_output_obj(l_item_output.uda_output.failed_row_id_list,l_item_output.uda_output.errorcode);*/
2126:
2127: -- To process Component level udas and structure header level udas
2128: INV_EBI_UTIL.debug_line('STEP 90: START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda');
2129: INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda(
2130: p_commit => FND_API.g_false
2131: ,p_organization_code => p_eco_obj.eco_change_order_type.organization_code
2132: ,p_eco_name => p_eco_obj.eco_change_order_type.eco_name

Line 2129: INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda(

2125: l_uda_output := inv_ebi_uda_output_obj(l_item_output.uda_output.failed_row_id_list,l_item_output.uda_output.errorcode);*/
2126:
2127: -- To process Component level udas and structure header level udas
2128: INV_EBI_UTIL.debug_line('STEP 90: START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda');
2129: INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda(
2130: p_commit => FND_API.g_false
2131: ,p_organization_code => p_eco_obj.eco_change_order_type.organization_code
2132: ,p_eco_name => p_eco_obj.eco_change_order_type.eco_name
2133: ,p_alternate_bom_code => p_eco_obj.eco_revised_item_type(i).alternate_bom_code

Line 2139: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda STATUS: '|| l_out.output_status.return_status);

2135: ,p_component_tbl => p_eco_obj.eco_revised_item_type(i).component_item_tbl
2136: ,p_structure_header => p_eco_obj.eco_revised_item_type(i).structure_header
2137: ,x_out => l_out
2138: );
2139: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda STATUS: '|| l_out.output_status.return_status);
2140: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2141: x_out.output_status.msg_data := l_out.output_status.msg_data;
2142: RAISE FND_API.g_exc_unexpected_error;
2143: END IF;

Line 2395: IF (UPPER(l_inv_ebi_eco_obj.name_value_tbl(i).param_name) = INV_EBI_CHANGE_ORDER_HELPER.G_ASSIGN_ITEM_TO_CHILD_ORG) THEN

2391: END LOOP;
2392:
2393: IF l_inv_ebi_eco_obj.name_value_tbl IS NOT NULL THEN
2394: FOR i in l_inv_ebi_eco_obj.name_value_tbl.FIRST..l_inv_ebi_eco_obj.name_value_tbl.LAST LOOP
2395: IF (UPPER(l_inv_ebi_eco_obj.name_value_tbl(i).param_name) = INV_EBI_CHANGE_ORDER_HELPER.G_ASSIGN_ITEM_TO_CHILD_ORG) THEN
2396: l_assign_item_to_child_org := l_inv_ebi_eco_obj.name_value_tbl(i).param_value;
2397: INV_EBI_CHANGE_ORDER_HELPER.set_assign_item(
2398: p_assign_item => l_assign_item_to_child_org
2399: );

Line 2397: INV_EBI_CHANGE_ORDER_HELPER.set_assign_item(

2393: IF l_inv_ebi_eco_obj.name_value_tbl IS NOT NULL THEN
2394: FOR i in l_inv_ebi_eco_obj.name_value_tbl.FIRST..l_inv_ebi_eco_obj.name_value_tbl.LAST LOOP
2395: IF (UPPER(l_inv_ebi_eco_obj.name_value_tbl(i).param_name) = INV_EBI_CHANGE_ORDER_HELPER.G_ASSIGN_ITEM_TO_CHILD_ORG) THEN
2396: l_assign_item_to_child_org := l_inv_ebi_eco_obj.name_value_tbl(i).param_value;
2397: INV_EBI_CHANGE_ORDER_HELPER.set_assign_item(
2398: p_assign_item => l_assign_item_to_child_org
2399: );
2400: END IF;
2401: END LOOP;