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_PUB

Line 1: PACKAGE BODY INV_EBI_CHANGE_ORDER_PUB AS

1: PACKAGE BODY INV_EBI_CHANGE_ORDER_PUB AS
2: /* $Header: INVEIPCOB.pls 120.34.12010000.11 2009/02/23 16:25:43 prepatel ship $ */
3: /************************************************************************************
4: -- API name : populate_item_attributes
5: -- Type : Private

Line 114: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes ';

110: END IF;
111: WHEN OTHERS THEN
112: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
113: IF (x_out.output_status.msg_data IS NOT NULL) THEN
114: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes ';
115: ELSE
116: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes ';
117: END IF;
118: END populate_item_attributes;

Line 116: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes ';

112: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
113: IF (x_out.output_status.msg_data IS NOT NULL) THEN
114: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes ';
115: ELSE
116: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes ';
117: END IF;
118: END populate_item_attributes;
119: /************************************************************************************
120: -- API name : transfer_engg_item_mfg

Line 258: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.transfer_engg_item_manufacturing ';

254: WHEN OTHERS THEN
255: ROLLBACK TO inv_ebi_engg_item_save_pnt;
256: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
257: IF (x_out.output_status.msg_data IS NOT NULL) THEN
258: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.transfer_engg_item_manufacturing ';
259: ELSE
260: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.transfer_engg_item_manufacturing ';
261: END IF;
262: END transfer_engg_item_mfg;

Line 260: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.transfer_engg_item_manufacturing ';

256: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
257: IF (x_out.output_status.msg_data IS NOT NULL) THEN
258: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.transfer_engg_item_manufacturing ';
259: ELSE
260: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.transfer_engg_item_manufacturing ';
261: END IF;
262: END transfer_engg_item_mfg;
263: /************************************************************************************
264: -- API name : validate_component_items

Line 329: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.validate_component_items ';

325: END IF;
326: WHEN OTHERS THEN
327: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
328: IF (x_out.output_status.msg_data IS NOT NULL) THEN
329: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.validate_component_items ';
330: ELSE
331: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.validate_component_items ';
332: END IF;
333: END validate_component_items;

Line 331: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.validate_component_items ';

327: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
328: IF (x_out.output_status.msg_data IS NOT NULL) THEN
329: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.validate_component_items ';
330: ELSE
331: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.validate_component_items ';
332: END IF;
333: END validate_component_items;
334:
335: /************************************************************************************

Line 390: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.validate_eco ';

386: END IF;
387: WHEN OTHERS THEN
388: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
389: IF (x_out.output_status.msg_data IS NOT NULL) THEN
390: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.validate_eco ';
391: ELSE
392: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.validate_eco ';
393: END IF;
394: END validate_eco;

Line 392: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.validate_eco ';

388: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
389: IF (x_out.output_status.msg_data IS NOT NULL) THEN
390: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.validate_eco ';
391: ELSE
392: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.validate_eco ';
393: END IF;
394: END validate_eco;
395: /************************************************************************************
396: -- API name : populate_revised_items_out

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 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 1011: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_PUB.process_change_order ';

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
1013: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.process_change_order ';
1014: END IF;
1015:

Line 1013: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.process_change_order ';

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
1013: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.process_change_order ';
1014: END IF;
1015:
1016: END process_change_order;
1017: /************************************************************************************

Line 1114: x_msg_data := x_msg_data ||' -> at inv_ebi_change_order_pub.get_eco';

1110: END IF;
1111: WHEN OTHERS THEN
1112: x_return_status := FND_API.g_ret_sts_error;
1113: IF (x_msg_data IS NOT NULL) THEN
1114: x_msg_data := x_msg_data ||' -> at inv_ebi_change_order_pub.get_eco';
1115: ELSE
1116: x_msg_data := SQLERRM||' at inv_ebi_change_order_pub.get_eco ';
1117: END IF;
1118: END get_eco;

Line 1116: x_msg_data := SQLERRM||' at inv_ebi_change_order_pub.get_eco ';

1112: x_return_status := FND_API.g_ret_sts_error;
1113: IF (x_msg_data IS NOT NULL) THEN
1114: x_msg_data := x_msg_data ||' -> at inv_ebi_change_order_pub.get_eco';
1115: ELSE
1116: x_msg_data := SQLERRM||' at inv_ebi_change_order_pub.get_eco ';
1117: END IF;
1118: END get_eco;
1119:
1120: /************************************************************************************

Line 1548: x_msg_data := x_msg_data ||' -> at INV_EBI_CHANGE_ORDER_PUB.get_eco_list_attr';

1544: EXCEPTION
1545: WHEN OTHERS THEN
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547: IF (x_msg_data IS NOT NULL) THEN
1548: x_msg_data := x_msg_data ||' -> at INV_EBI_CHANGE_ORDER_PUB.get_eco_list_attr';
1549: ELSE
1550: x_msg_data := SQLERRM||' at INV_EBI_CHANGE_ORDER_PUB.get_eco_list_attr ';
1551: END IF;
1552: END get_eco_list_attr;

Line 1550: x_msg_data := SQLERRM||' at INV_EBI_CHANGE_ORDER_PUB.get_eco_list_attr ';

1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547: IF (x_msg_data IS NOT NULL) THEN
1548: x_msg_data := x_msg_data ||' -> at INV_EBI_CHANGE_ORDER_PUB.get_eco_list_attr';
1549: ELSE
1550: x_msg_data := SQLERRM||' at INV_EBI_CHANGE_ORDER_PUB.get_eco_list_attr ';
1551: END IF;
1552: END get_eco_list_attr;
1553:
1554: /************************************************************************************

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 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 1598: INV_EBI_CHANGE_ORDER_PUB.process_change_order( p_commit => p_commit

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
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'||

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 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 1623: INV_EBI_CHANGE_ORDER_PUB.process_change_order( p_commit => p_commit

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
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'||

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 1657: x_out(1).output_status.msg_data := x_out(1).output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_PUB.process_change_order_list';

1653: WHEN OTHERS THEN
1654: x_out.EXTEND();
1655: x_out(1).output_status.return_status := FND_API.g_ret_sts_unexp_error;
1656: IF (x_out(1).output_status.msg_data IS NOT NULL) THEN
1657: x_out(1).output_status.msg_data := x_out(1).output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_PUB.process_change_order_list';
1658: ELSE
1659: x_out(1).output_status.msg_data := SQLERRM|| 'INV_EBI_CHANGE_ORDER_PUB.process_change_order_list';
1660: END IF;
1661: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1659: x_out(1).output_status.msg_data := SQLERRM|| 'INV_EBI_CHANGE_ORDER_PUB.process_change_order_list';

1655: x_out(1).output_status.return_status := FND_API.g_ret_sts_unexp_error;
1656: IF (x_out(1).output_status.msg_data IS NOT NULL) THEN
1657: x_out(1).output_status.msg_data := x_out(1).output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_PUB.process_change_order_list';
1658: ELSE
1659: x_out(1).output_status.msg_data := SQLERRM|| 'INV_EBI_CHANGE_ORDER_PUB.process_change_order_list';
1660: END IF;
1661: x_return_status := FND_API.G_RET_STS_ERROR;
1662: x_msg_count := x_out(1).output_status.msg_count;
1663: IF (x_out IS NOT NULL AND x_out.COUNT > 0) THEN

Line 1673: END INV_EBI_CHANGE_ORDER_PUB;

1669: END LOOP;
1670: END IF;
1671: END process_change_order_list;
1672:
1673: END INV_EBI_CHANGE_ORDER_PUB;