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.EGO_ITEM_ASSOCIATIONS_PUB dependencies on EGO_ITEM_ASSOCIATIONS_PUB

Line 1: PACKAGE BODY ego_item_associations_pub AS

1: PACKAGE BODY ego_item_associations_pub AS
2: /* $Header: EGOPIASB.pls 120.30 2007/10/05 12:37:01 earumuga noship $ */
3:
4: G_FILE_NAME VARCHAR2(12);
5: G_PKG_NAME VARCHAR2(30);

Line 64: G_PKG_NAME := NVL(G_PKG_NAME,'EGO_ITEM_ASSOCIATIONS_PUB');

60: --
61: -- file names
62: --
63: G_FILE_NAME := NVL(G_FILE_NAME,'EGOPIASB.pls');
64: G_PKG_NAME := NVL(G_PKG_NAME,'EGO_ITEM_ASSOCIATIONS_PUB');
65: --
66: -- user values
67: --
68: G_USER_ID := FND_GLOBAL.user_id;

Line 1545: write_log_message(' ego_item_associations_pub.pre_process Batch Id ' || p_batch_id);

1541: BEGIN
1542: SAVEPOINT pre_process_pub;
1543: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1544: set_globals();
1545: write_log_message(' ego_item_associations_pub.pre_process Batch Id ' || p_batch_id);
1546: -- Set the transaction type to UPPER case..
1547: UPDATE ego_item_associations_intf
1548: SET transaction_type = UPPER(transaction_type)
1549: WHERE batch_id = p_batch_id

Line 1722: write_log_message(' ego_item_associations_pub.pre_process Msg Count ' || x_msg_count);

1718: FND_MSG_PUB.Count_And_Get
1719: ( p_count => x_msg_count,
1720: p_data => x_msg_data
1721: );
1722: write_log_message(' ego_item_associations_pub.pre_process Msg Count ' || x_msg_count);
1723: write_log_message(' ego_item_associations_pub.pre_process Msg Data ' || x_msg_data);
1724: write_log_message(' ego_item_associations_pub.pre_process Return Status ' || x_return_status);
1725: EXCEPTION
1726: WHEN fnd_api.G_EXC_ERROR THEN

Line 1723: write_log_message(' ego_item_associations_pub.pre_process Msg Data ' || x_msg_data);

1719: ( p_count => x_msg_count,
1720: p_data => x_msg_data
1721: );
1722: write_log_message(' ego_item_associations_pub.pre_process Msg Count ' || x_msg_count);
1723: write_log_message(' ego_item_associations_pub.pre_process Msg Data ' || x_msg_data);
1724: write_log_message(' ego_item_associations_pub.pre_process Return Status ' || x_return_status);
1725: EXCEPTION
1726: WHEN fnd_api.G_EXC_ERROR THEN
1727: ROLLBACK TO pre_process_pub;

Line 1724: write_log_message(' ego_item_associations_pub.pre_process Return Status ' || x_return_status);

1720: p_data => x_msg_data
1721: );
1722: write_log_message(' ego_item_associations_pub.pre_process Msg Count ' || x_msg_count);
1723: write_log_message(' ego_item_associations_pub.pre_process Msg Data ' || x_msg_data);
1724: write_log_message(' ego_item_associations_pub.pre_process Return Status ' || x_return_status);
1725: EXCEPTION
1726: WHEN fnd_api.G_EXC_ERROR THEN
1727: ROLLBACK TO pre_process_pub;
1728: x_return_status := fnd_api.G_RET_STS_ERROR ;

Line 1733: write_log_message(' ego_item_associations_pub.pre_process Error Msg Count ' || x_msg_count);

1729: FND_MSG_PUB.Count_And_Get
1730: ( p_count => x_msg_count ,
1731: p_data => x_msg_data
1732: );
1733: write_log_message(' ego_item_associations_pub.pre_process Error Msg Count ' || x_msg_count);
1734: write_log_message(' ego_item_associations_pub.pre_process Error Msg Data ' || x_msg_data);
1735: write_log_message(' ego_item_associations_pub.pre_process Error Return Status ' || x_return_status);
1736: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1737: --dbms_output.put_line(' SQLERRM ' || SQLERRM);

Line 1734: write_log_message(' ego_item_associations_pub.pre_process Error Msg Data ' || x_msg_data);

1730: ( p_count => x_msg_count ,
1731: p_data => x_msg_data
1732: );
1733: write_log_message(' ego_item_associations_pub.pre_process Error Msg Count ' || x_msg_count);
1734: write_log_message(' ego_item_associations_pub.pre_process Error Msg Data ' || x_msg_data);
1735: write_log_message(' ego_item_associations_pub.pre_process Error Return Status ' || x_return_status);
1736: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1737: --dbms_output.put_line(' SQLERRM ' || SQLERRM);
1738: ROLLBACK TO pre_process_pub;

Line 1735: write_log_message(' ego_item_associations_pub.pre_process Error Return Status ' || x_return_status);

1731: p_data => x_msg_data
1732: );
1733: write_log_message(' ego_item_associations_pub.pre_process Error Msg Count ' || x_msg_count);
1734: write_log_message(' ego_item_associations_pub.pre_process Error Msg Data ' || x_msg_data);
1735: write_log_message(' ego_item_associations_pub.pre_process Error Return Status ' || x_return_status);
1736: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1737: --dbms_output.put_line(' SQLERRM ' || SQLERRM);
1738: ROLLBACK TO pre_process_pub;
1739: UPDATE ego_item_associations_intf

Line 1748: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Msg Count ' || x_msg_count);

1744: FND_MSG_PUB.Count_And_Get
1745: ( p_count => x_msg_count ,
1746: p_data => x_msg_data
1747: );
1748: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Msg Count ' || x_msg_count);
1749: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Msg Data ' || x_msg_data);
1750: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Return Status ' || x_return_status);
1751: WHEN OTHERS THEN
1752: --dbms_output.put_line(' SQLERRM ' || SQLERRM);

Line 1749: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Msg Data ' || x_msg_data);

1745: ( p_count => x_msg_count ,
1746: p_data => x_msg_data
1747: );
1748: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Msg Count ' || x_msg_count);
1749: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Msg Data ' || x_msg_data);
1750: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Return Status ' || x_return_status);
1751: WHEN OTHERS THEN
1752: --dbms_output.put_line(' SQLERRM ' || SQLERRM);
1753: ROLLBACK TO pre_process_pub;

Line 1750: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Return Status ' || x_return_status);

1746: p_data => x_msg_data
1747: );
1748: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Msg Count ' || x_msg_count);
1749: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Msg Data ' || x_msg_data);
1750: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Return Status ' || x_return_status);
1751: WHEN OTHERS THEN
1752: --dbms_output.put_line(' SQLERRM ' || SQLERRM);
1753: ROLLBACK TO pre_process_pub;
1754: UPDATE ego_item_associations_intf

Line 1771: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Count ' || x_msg_count);

1767: FND_MSG_PUB.Count_And_Get
1768: ( p_count => x_msg_count,
1769: p_data => x_msg_data
1770: );
1771: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Count ' || x_msg_count);
1772: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Data ' || x_msg_data);
1773: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Return Status ' || x_return_status);
1774: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS SQLERRM ' || SQLERRM);
1775: END pre_process;

Line 1772: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Data ' || x_msg_data);

1768: ( p_count => x_msg_count,
1769: p_data => x_msg_data
1770: );
1771: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Count ' || x_msg_count);
1772: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Data ' || x_msg_data);
1773: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Return Status ' || x_return_status);
1774: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS SQLERRM ' || SQLERRM);
1775: END pre_process;
1776:

Line 1773: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Return Status ' || x_return_status);

1769: p_data => x_msg_data
1770: );
1771: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Count ' || x_msg_count);
1772: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Data ' || x_msg_data);
1773: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Return Status ' || x_return_status);
1774: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS SQLERRM ' || SQLERRM);
1775: END pre_process;
1776:
1777: -- Start of comments

Line 1774: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS SQLERRM ' || SQLERRM);

1770: );
1771: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Count ' || x_msg_count);
1772: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Data ' || x_msg_data);
1773: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Return Status ' || x_return_status);
1774: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS SQLERRM ' || SQLERRM);
1775: END pre_process;
1776:
1777: -- Start of comments
1778: -- API name : import_item_associations

Line 1834: write_log_message(' ego_item_associations_pub.import_item_associations Batch Id ' || x_batch_id);

1830: */
1831: FND_MSG_PUB.initialize;
1832: -- Initialize API return status to success
1833: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1834: write_log_message(' ego_item_associations_pub.import_item_associations Batch Id ' || x_batch_id);
1835: -- API body
1836:
1837: -- Set records status as in process
1838: initialize(x_batch_id);

Line 1860: write_log_message(' ego_item_associations_pub.import_item_associations Msg Count ' || x_msg_count);

1856: FND_MSG_PUB.Count_And_Get
1857: ( p_count => x_msg_count,
1858: p_data => x_msg_data
1859: );
1860: write_log_message(' ego_item_associations_pub.import_item_associations Msg Count ' || x_msg_count);
1861: write_log_message(' ego_item_associations_pub.import_item_associations Msg Data ' || x_msg_data);
1862: write_log_message(' ego_item_associations_pub.import_item_associations Return Status ' || x_return_status);
1863: EXCEPTION
1864: WHEN fnd_api.G_EXC_ERROR THEN

Line 1861: write_log_message(' ego_item_associations_pub.import_item_associations Msg Data ' || x_msg_data);

1857: ( p_count => x_msg_count,
1858: p_data => x_msg_data
1859: );
1860: write_log_message(' ego_item_associations_pub.import_item_associations Msg Count ' || x_msg_count);
1861: write_log_message(' ego_item_associations_pub.import_item_associations Msg Data ' || x_msg_data);
1862: write_log_message(' ego_item_associations_pub.import_item_associations Return Status ' || x_return_status);
1863: EXCEPTION
1864: WHEN fnd_api.G_EXC_ERROR THEN
1865: ROLLBACK TO import_item_associations_pub;

Line 1862: write_log_message(' ego_item_associations_pub.import_item_associations Return Status ' || x_return_status);

1858: p_data => x_msg_data
1859: );
1860: write_log_message(' ego_item_associations_pub.import_item_associations Msg Count ' || x_msg_count);
1861: write_log_message(' ego_item_associations_pub.import_item_associations Msg Data ' || x_msg_data);
1862: write_log_message(' ego_item_associations_pub.import_item_associations Return Status ' || x_return_status);
1863: EXCEPTION
1864: WHEN fnd_api.G_EXC_ERROR THEN
1865: ROLLBACK TO import_item_associations_pub;
1866: x_return_status := fnd_api.G_RET_STS_ERROR ;

Line 1871: write_log_message(' ego_item_associations_pub.import_item_associations Error Msg Count ' || x_msg_count);

1867: FND_MSG_PUB.Count_And_Get
1868: ( p_count => x_msg_count ,
1869: p_data => x_msg_data
1870: );
1871: write_log_message(' ego_item_associations_pub.import_item_associations Error Msg Count ' || x_msg_count);
1872: write_log_message(' ego_item_associations_pub.import_item_associations Error Msg Data ' || x_msg_data);
1873: write_log_message(' ego_item_associations_pub.import_item_associations Error Return Status ' || x_return_status);
1874: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1875: ROLLBACK TO import_item_associations_pub;

Line 1872: write_log_message(' ego_item_associations_pub.import_item_associations Error Msg Data ' || x_msg_data);

1868: ( p_count => x_msg_count ,
1869: p_data => x_msg_data
1870: );
1871: write_log_message(' ego_item_associations_pub.import_item_associations Error Msg Count ' || x_msg_count);
1872: write_log_message(' ego_item_associations_pub.import_item_associations Error Msg Data ' || x_msg_data);
1873: write_log_message(' ego_item_associations_pub.import_item_associations Error Return Status ' || x_return_status);
1874: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1875: ROLLBACK TO import_item_associations_pub;
1876: UPDATE ego_item_associations_intf

Line 1873: write_log_message(' ego_item_associations_pub.import_item_associations Error Return Status ' || x_return_status);

1869: p_data => x_msg_data
1870: );
1871: write_log_message(' ego_item_associations_pub.import_item_associations Error Msg Count ' || x_msg_count);
1872: write_log_message(' ego_item_associations_pub.import_item_associations Error Msg Data ' || x_msg_data);
1873: write_log_message(' ego_item_associations_pub.import_item_associations Error Return Status ' || x_return_status);
1874: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1875: ROLLBACK TO import_item_associations_pub;
1876: UPDATE ego_item_associations_intf
1877: SET process_flag = G_REC_UNEXPECTED_ERROR

Line 1885: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Msg Count ' || x_msg_count);

1881: FND_MSG_PUB.Count_And_Get
1882: ( p_count => x_msg_count ,
1883: p_data => x_msg_data
1884: );
1885: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Msg Count ' || x_msg_count);
1886: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Msg Data ' || x_msg_data);
1887: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Return Status ' || x_return_status);
1888: WHEN OTHERS THEN
1889: ROLLBACK TO import_item_associations_pub;

Line 1886: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Msg Data ' || x_msg_data);

1882: ( p_count => x_msg_count ,
1883: p_data => x_msg_data
1884: );
1885: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Msg Count ' || x_msg_count);
1886: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Msg Data ' || x_msg_data);
1887: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Return Status ' || x_return_status);
1888: WHEN OTHERS THEN
1889: ROLLBACK TO import_item_associations_pub;
1890: UPDATE ego_item_associations_intf

Line 1887: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Return Status ' || x_return_status);

1883: p_data => x_msg_data
1884: );
1885: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Msg Count ' || x_msg_count);
1886: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Msg Data ' || x_msg_data);
1887: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Return Status ' || x_return_status);
1888: WHEN OTHERS THEN
1889: ROLLBACK TO import_item_associations_pub;
1890: UPDATE ego_item_associations_intf
1891: SET process_flag = G_REC_UNEXPECTED_ERROR

Line 1907: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS SQLERRM ' || SQLERRM);

1903: FND_MSG_PUB.Count_And_Get
1904: ( p_count => x_msg_count,
1905: p_data => x_msg_data
1906: );
1907: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS SQLERRM ' || SQLERRM);
1908: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Count ' || x_msg_count);
1909: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msggggg Data ' || x_msg_data);
1910: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Data ' || x_msg_data);
1911: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Return Status ' || x_return_status);

Line 1908: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Count ' || x_msg_count);

1904: ( p_count => x_msg_count,
1905: p_data => x_msg_data
1906: );
1907: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS SQLERRM ' || SQLERRM);
1908: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Count ' || x_msg_count);
1909: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msggggg Data ' || x_msg_data);
1910: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Data ' || x_msg_data);
1911: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Return Status ' || x_return_status);
1912: END import_item_associations;

Line 1909: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msggggg Data ' || x_msg_data);

1905: p_data => x_msg_data
1906: );
1907: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS SQLERRM ' || SQLERRM);
1908: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Count ' || x_msg_count);
1909: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msggggg Data ' || x_msg_data);
1910: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Data ' || x_msg_data);
1911: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Return Status ' || x_return_status);
1912: END import_item_associations;
1913:

Line 1910: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Data ' || x_msg_data);

1906: );
1907: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS SQLERRM ' || SQLERRM);
1908: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Count ' || x_msg_count);
1909: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msggggg Data ' || x_msg_data);
1910: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Data ' || x_msg_data);
1911: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Return Status ' || x_return_status);
1912: END import_item_associations;
1913:
1914: -- Start of comments

Line 1911: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Return Status ' || x_return_status);

1907: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS SQLERRM ' || SQLERRM);
1908: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Count ' || x_msg_count);
1909: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msggggg Data ' || x_msg_data);
1910: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Data ' || x_msg_data);
1911: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Return Status ' || x_return_status);
1912: END import_item_associations;
1913:
1914: -- Start of comments
1915: -- API name : import_item_associations

Line 2070: write_log_message(' ego_item_associations_pub.copy_associations_to_items after insert ');

2066: AND eia.data_level_id = l_data_level_id
2067: AND msii.process_flag = G_REC_TO_BE_PROCESSED
2068: AND eia.organization_id = msii.organization_id
2069: AND msii.organization_id = mp.organization_id;
2070: write_log_message(' ego_item_associations_pub.copy_associations_to_items after insert ');
2071: END LOOP;
2072: FND_MSG_PUB.Count_And_Get
2073: ( p_count => x_msg_count,
2074: p_data => x_msg_data

Line 2076: write_log_message(' ego_item_associations_pub.copy_associations_to_items Msg Count ' || x_msg_count);

2072: FND_MSG_PUB.Count_And_Get
2073: ( p_count => x_msg_count,
2074: p_data => x_msg_data
2075: );
2076: write_log_message(' ego_item_associations_pub.copy_associations_to_items Msg Count ' || x_msg_count);
2077: write_log_message(' ego_item_associations_pub.copy_associations_to_items Msg Data ' || x_msg_data);
2078: write_log_message(' ego_item_associations_pub.copy_associations_to_items Return Status ' || x_return_status);
2079: EXCEPTION
2080: WHEN fnd_api.G_EXC_ERROR THEN

Line 2077: write_log_message(' ego_item_associations_pub.copy_associations_to_items Msg Data ' || x_msg_data);

2073: ( p_count => x_msg_count,
2074: p_data => x_msg_data
2075: );
2076: write_log_message(' ego_item_associations_pub.copy_associations_to_items Msg Count ' || x_msg_count);
2077: write_log_message(' ego_item_associations_pub.copy_associations_to_items Msg Data ' || x_msg_data);
2078: write_log_message(' ego_item_associations_pub.copy_associations_to_items Return Status ' || x_return_status);
2079: EXCEPTION
2080: WHEN fnd_api.G_EXC_ERROR THEN
2081: ROLLBACK TO copy_associations_to_items_pub;

Line 2078: write_log_message(' ego_item_associations_pub.copy_associations_to_items Return Status ' || x_return_status);

2074: p_data => x_msg_data
2075: );
2076: write_log_message(' ego_item_associations_pub.copy_associations_to_items Msg Count ' || x_msg_count);
2077: write_log_message(' ego_item_associations_pub.copy_associations_to_items Msg Data ' || x_msg_data);
2078: write_log_message(' ego_item_associations_pub.copy_associations_to_items Return Status ' || x_return_status);
2079: EXCEPTION
2080: WHEN fnd_api.G_EXC_ERROR THEN
2081: ROLLBACK TO copy_associations_to_items_pub;
2082: x_return_status := fnd_api.G_RET_STS_ERROR ;

Line 2087: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Msg Count ' || x_msg_count);

2083: FND_MSG_PUB.Count_And_Get
2084: ( p_count => x_msg_count ,
2085: p_data => x_msg_data
2086: );
2087: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Msg Count ' || x_msg_count);
2088: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Msg Data ' || x_msg_data);
2089: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Return Status ' || x_return_status);
2090: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2091: ROLLBACK TO copy_associations_to_items_pub;

Line 2088: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Msg Data ' || x_msg_data);

2084: ( p_count => x_msg_count ,
2085: p_data => x_msg_data
2086: );
2087: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Msg Count ' || x_msg_count);
2088: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Msg Data ' || x_msg_data);
2089: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Return Status ' || x_return_status);
2090: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2091: ROLLBACK TO copy_associations_to_items_pub;
2092: UPDATE ego_item_associations_intf

Line 2089: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Return Status ' || x_return_status);

2085: p_data => x_msg_data
2086: );
2087: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Msg Count ' || x_msg_count);
2088: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Msg Data ' || x_msg_data);
2089: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Return Status ' || x_return_status);
2090: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2091: ROLLBACK TO copy_associations_to_items_pub;
2092: UPDATE ego_item_associations_intf
2093: SET process_flag = G_REC_UNEXPECTED_ERROR

Line 2101: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Msg Count ' || x_msg_count);

2097: FND_MSG_PUB.Count_And_Get
2098: ( p_count => x_msg_count ,
2099: p_data => x_msg_data
2100: );
2101: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Msg Count ' || x_msg_count);
2102: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Msg Data ' || x_msg_data);
2103: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Return Status ' || x_return_status);
2104: WHEN OTHERS THEN
2105: ROLLBACK TO copy_associations_to_items_pub;

Line 2102: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Msg Data ' || x_msg_data);

2098: ( p_count => x_msg_count ,
2099: p_data => x_msg_data
2100: );
2101: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Msg Count ' || x_msg_count);
2102: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Msg Data ' || x_msg_data);
2103: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Return Status ' || x_return_status);
2104: WHEN OTHERS THEN
2105: ROLLBACK TO copy_associations_to_items_pub;
2106: UPDATE ego_item_associations_intf

Line 2103: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Return Status ' || x_return_status);

2099: p_data => x_msg_data
2100: );
2101: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Msg Count ' || x_msg_count);
2102: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Msg Data ' || x_msg_data);
2103: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Return Status ' || x_return_status);
2104: WHEN OTHERS THEN
2105: ROLLBACK TO copy_associations_to_items_pub;
2106: UPDATE ego_item_associations_intf
2107: SET process_flag = G_REC_UNEXPECTED_ERROR

Line 2123: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Count ' || x_msg_count);

2119: FND_MSG_PUB.Count_And_Get
2120: ( p_count => x_msg_count,
2121: p_data => x_msg_data
2122: );
2123: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Count ' || x_msg_count);
2124: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Data ' || x_msg_data);
2125: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Return Status ' || x_return_status);
2126: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS SQLERRM ' || SQLERRM);
2127: END copy_associations_to_items;

Line 2124: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Data ' || x_msg_data);

2120: ( p_count => x_msg_count,
2121: p_data => x_msg_data
2122: );
2123: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Count ' || x_msg_count);
2124: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Data ' || x_msg_data);
2125: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Return Status ' || x_return_status);
2126: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS SQLERRM ' || SQLERRM);
2127: END copy_associations_to_items;
2128:

Line 2125: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Return Status ' || x_return_status);

2121: p_data => x_msg_data
2122: );
2123: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Count ' || x_msg_count);
2124: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Data ' || x_msg_data);
2125: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Return Status ' || x_return_status);
2126: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS SQLERRM ' || SQLERRM);
2127: END copy_associations_to_items;
2128:
2129: -- Start of comments

Line 2126: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS SQLERRM ' || SQLERRM);

2122: );
2123: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Count ' || x_msg_count);
2124: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Data ' || x_msg_data);
2125: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Return Status ' || x_return_status);
2126: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS SQLERRM ' || SQLERRM);
2127: END copy_associations_to_items;
2128:
2129: -- Start of comments
2130: -- API name : copy_from_style_to_SKUs

Line 2407: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Msg Count ' || x_msg_count);

2403: FND_MSG_PUB.Count_And_Get
2404: ( p_count => x_msg_count,
2405: p_data => x_msg_data
2406: );
2407: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Msg Count ' || x_msg_count);
2408: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Msg Data ' || x_msg_data);
2409: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Return Status ' || x_return_status);
2410: EXCEPTION
2411: WHEN fnd_api.G_EXC_ERROR THEN

Line 2408: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Msg Data ' || x_msg_data);

2404: ( p_count => x_msg_count,
2405: p_data => x_msg_data
2406: );
2407: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Msg Count ' || x_msg_count);
2408: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Msg Data ' || x_msg_data);
2409: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Return Status ' || x_return_status);
2410: EXCEPTION
2411: WHEN fnd_api.G_EXC_ERROR THEN
2412: ROLLBACK TO copy_from_style_to_SKUs_pub;

Line 2409: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Return Status ' || x_return_status);

2405: p_data => x_msg_data
2406: );
2407: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Msg Count ' || x_msg_count);
2408: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Msg Data ' || x_msg_data);
2409: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Return Status ' || x_return_status);
2410: EXCEPTION
2411: WHEN fnd_api.G_EXC_ERROR THEN
2412: ROLLBACK TO copy_from_style_to_SKUs_pub;
2413: x_return_status := fnd_api.G_RET_STS_ERROR ;

Line 2418: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Msg Count ' || x_msg_count);

2414: FND_MSG_PUB.Count_And_Get
2415: ( p_count => x_msg_count ,
2416: p_data => x_msg_data
2417: );
2418: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Msg Count ' || x_msg_count);
2419: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Msg Data ' || x_msg_data);
2420: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Return Status ' || x_return_status);
2421: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2422: --dbms_output.put_line(' Error Msg ' || SQLERRM);

Line 2419: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Msg Data ' || x_msg_data);

2415: ( p_count => x_msg_count ,
2416: p_data => x_msg_data
2417: );
2418: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Msg Count ' || x_msg_count);
2419: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Msg Data ' || x_msg_data);
2420: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Return Status ' || x_return_status);
2421: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2422: --dbms_output.put_line(' Error Msg ' || SQLERRM);
2423: ROLLBACK TO copy_from_style_to_SKUs_pub;

Line 2420: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Return Status ' || x_return_status);

2416: p_data => x_msg_data
2417: );
2418: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Msg Count ' || x_msg_count);
2419: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Msg Data ' || x_msg_data);
2420: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Return Status ' || x_return_status);
2421: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2422: --dbms_output.put_line(' Error Msg ' || SQLERRM);
2423: ROLLBACK TO copy_from_style_to_SKUs_pub;
2424: UPDATE ego_item_associations_intf

Line 2433: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Msg Count ' || x_msg_count);

2429: FND_MSG_PUB.Count_And_Get
2430: ( p_count => x_msg_count ,
2431: p_data => x_msg_data
2432: );
2433: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Msg Count ' || x_msg_count);
2434: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Msg Data ' || x_msg_data);
2435: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Return Status ' || x_return_status);
2436: WHEN OTHERS THEN
2437: --dbms_output.put_line(' Error Msg ' || SQLERRM);

Line 2434: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Msg Data ' || x_msg_data);

2430: ( p_count => x_msg_count ,
2431: p_data => x_msg_data
2432: );
2433: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Msg Count ' || x_msg_count);
2434: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Msg Data ' || x_msg_data);
2435: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Return Status ' || x_return_status);
2436: WHEN OTHERS THEN
2437: --dbms_output.put_line(' Error Msg ' || SQLERRM);
2438: ROLLBACK TO copy_from_style_to_SKUs_pub;

Line 2435: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Return Status ' || x_return_status);

2431: p_data => x_msg_data
2432: );
2433: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Msg Count ' || x_msg_count);
2434: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Msg Data ' || x_msg_data);
2435: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Return Status ' || x_return_status);
2436: WHEN OTHERS THEN
2437: --dbms_output.put_line(' Error Msg ' || SQLERRM);
2438: ROLLBACK TO copy_from_style_to_SKUs_pub;
2439: UPDATE ego_item_associations_intf

Line 2456: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Count ' || x_msg_count);

2452: FND_MSG_PUB.Count_And_Get
2453: ( p_count => x_msg_count,
2454: p_data => x_msg_data
2455: );
2456: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Count ' || x_msg_count);
2457: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Data ' || x_msg_data);
2458: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Return Status ' || x_return_status);
2459: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS SQLERRM ' || SQLERRM);
2460: END copy_from_style_to_SKUs;

Line 2457: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Data ' || x_msg_data);

2453: ( p_count => x_msg_count,
2454: p_data => x_msg_data
2455: );
2456: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Count ' || x_msg_count);
2457: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Data ' || x_msg_data);
2458: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Return Status ' || x_return_status);
2459: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS SQLERRM ' || SQLERRM);
2460: END copy_from_style_to_SKUs;
2461:

Line 2458: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Return Status ' || x_return_status);

2454: p_data => x_msg_data
2455: );
2456: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Count ' || x_msg_count);
2457: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Data ' || x_msg_data);
2458: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Return Status ' || x_return_status);
2459: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS SQLERRM ' || SQLERRM);
2460: END copy_from_style_to_SKUs;
2461:
2462: -- Start of comments

Line 2459: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS SQLERRM ' || SQLERRM);

2455: );
2456: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Count ' || x_msg_count);
2457: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Data ' || x_msg_data);
2458: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Return Status ' || x_return_status);
2459: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS SQLERRM ' || SQLERRM);
2460: END copy_from_style_to_SKUs;
2461:
2462: -- Start of comments
2463: -- API name : copy_to_packs

Line 2515: AND bsb.alternate_bom_designator = ego_item_associations_pub.G_PACK_STR_NAME

2511: WHERE bsb.assembly_item_id = msibk.inventory_item_id
2512: AND bsb.assembly_item_id = msibk.inventory_item_id
2513: AND bsb.organization_id = eiai.organization_id
2514: AND bsb.bill_sequence_id = bsb.common_bill_sequence_id
2515: AND bsb.alternate_bom_designator = ego_item_associations_pub.G_PACK_STR_NAME
2516: );
2517: BEGIN
2518: x_return_status := fnd_api.G_RET_STS_SUCCESS;
2519: -- Set the Global Variables

Line 2651: write_log_message(' ego_item_associations_pub.copy_to_packs Msg Count ' || x_msg_count);

2647: FND_MSG_PUB.Count_And_Get
2648: ( p_count => x_msg_count,
2649: p_data => x_msg_data
2650: );
2651: write_log_message(' ego_item_associations_pub.copy_to_packs Msg Count ' || x_msg_count);
2652: write_log_message(' ego_item_associations_pub.copy_to_packs Msg Data ' || x_msg_data);
2653: write_log_message(' ego_item_associations_pub.copy_to_packs Return Status ' || x_return_status);
2654: EXCEPTION
2655: WHEN fnd_api.G_EXC_ERROR THEN

Line 2652: write_log_message(' ego_item_associations_pub.copy_to_packs Msg Data ' || x_msg_data);

2648: ( p_count => x_msg_count,
2649: p_data => x_msg_data
2650: );
2651: write_log_message(' ego_item_associations_pub.copy_to_packs Msg Count ' || x_msg_count);
2652: write_log_message(' ego_item_associations_pub.copy_to_packs Msg Data ' || x_msg_data);
2653: write_log_message(' ego_item_associations_pub.copy_to_packs Return Status ' || x_return_status);
2654: EXCEPTION
2655: WHEN fnd_api.G_EXC_ERROR THEN
2656: ROLLBACK TO copy_to_packs_pub;

Line 2653: write_log_message(' ego_item_associations_pub.copy_to_packs Return Status ' || x_return_status);

2649: p_data => x_msg_data
2650: );
2651: write_log_message(' ego_item_associations_pub.copy_to_packs Msg Count ' || x_msg_count);
2652: write_log_message(' ego_item_associations_pub.copy_to_packs Msg Data ' || x_msg_data);
2653: write_log_message(' ego_item_associations_pub.copy_to_packs Return Status ' || x_return_status);
2654: EXCEPTION
2655: WHEN fnd_api.G_EXC_ERROR THEN
2656: ROLLBACK TO copy_to_packs_pub;
2657: x_return_status := fnd_api.G_RET_STS_ERROR ;

Line 2662: write_log_message(' ego_item_associations_pub.copy_to_packs Error Msg Count ' || x_msg_count);

2658: FND_MSG_PUB.Count_And_Get
2659: ( p_count => x_msg_count ,
2660: p_data => x_msg_data
2661: );
2662: write_log_message(' ego_item_associations_pub.copy_to_packs Error Msg Count ' || x_msg_count);
2663: write_log_message(' ego_item_associations_pub.copy_to_packs Error Msg Data ' || x_msg_data);
2664: write_log_message(' ego_item_associations_pub.copy_to_packs Error Return Status ' || x_return_status);
2665: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2666: --dbms_output.put_line(' Error Msg ' || SQLERRM);

Line 2663: write_log_message(' ego_item_associations_pub.copy_to_packs Error Msg Data ' || x_msg_data);

2659: ( p_count => x_msg_count ,
2660: p_data => x_msg_data
2661: );
2662: write_log_message(' ego_item_associations_pub.copy_to_packs Error Msg Count ' || x_msg_count);
2663: write_log_message(' ego_item_associations_pub.copy_to_packs Error Msg Data ' || x_msg_data);
2664: write_log_message(' ego_item_associations_pub.copy_to_packs Error Return Status ' || x_return_status);
2665: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2666: --dbms_output.put_line(' Error Msg ' || SQLERRM);
2667: ROLLBACK TO copy_to_packs_pub;

Line 2664: write_log_message(' ego_item_associations_pub.copy_to_packs Error Return Status ' || x_return_status);

2660: p_data => x_msg_data
2661: );
2662: write_log_message(' ego_item_associations_pub.copy_to_packs Error Msg Count ' || x_msg_count);
2663: write_log_message(' ego_item_associations_pub.copy_to_packs Error Msg Data ' || x_msg_data);
2664: write_log_message(' ego_item_associations_pub.copy_to_packs Error Return Status ' || x_return_status);
2665: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2666: --dbms_output.put_line(' Error Msg ' || SQLERRM);
2667: ROLLBACK TO copy_to_packs_pub;
2668: UPDATE ego_item_associations_intf

Line 2677: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Msg Count ' || x_msg_count);

2673: FND_MSG_PUB.Count_And_Get
2674: ( p_count => x_msg_count ,
2675: p_data => x_msg_data
2676: );
2677: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Msg Count ' || x_msg_count);
2678: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Msg Data ' || x_msg_data);
2679: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Return Status ' || x_return_status);
2680: WHEN OTHERS THEN
2681: --dbms_output.put_line(' Error Msg ' || SQLERRM);

Line 2678: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Msg Data ' || x_msg_data);

2674: ( p_count => x_msg_count ,
2675: p_data => x_msg_data
2676: );
2677: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Msg Count ' || x_msg_count);
2678: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Msg Data ' || x_msg_data);
2679: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Return Status ' || x_return_status);
2680: WHEN OTHERS THEN
2681: --dbms_output.put_line(' Error Msg ' || SQLERRM);
2682: ROLLBACK TO copy_to_packs_pub;

Line 2679: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Return Status ' || x_return_status);

2675: p_data => x_msg_data
2676: );
2677: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Msg Count ' || x_msg_count);
2678: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Msg Data ' || x_msg_data);
2679: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Return Status ' || x_return_status);
2680: WHEN OTHERS THEN
2681: --dbms_output.put_line(' Error Msg ' || SQLERRM);
2682: ROLLBACK TO copy_to_packs_pub;
2683: UPDATE ego_item_associations_intf

Line 2700: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Count ' || x_msg_count);

2696: FND_MSG_PUB.Count_And_Get
2697: ( p_count => x_msg_count,
2698: p_data => x_msg_data
2699: );
2700: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Count ' || x_msg_count);
2701: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Data ' || x_msg_data);
2702: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Return Status ' || x_return_status);
2703: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS SQLERRM ' || SQLERRM);
2704: END copy_to_packs;

Line 2701: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Data ' || x_msg_data);

2697: ( p_count => x_msg_count,
2698: p_data => x_msg_data
2699: );
2700: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Count ' || x_msg_count);
2701: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Data ' || x_msg_data);
2702: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Return Status ' || x_return_status);
2703: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS SQLERRM ' || SQLERRM);
2704: END copy_to_packs;
2705:

Line 2702: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Return Status ' || x_return_status);

2698: p_data => x_msg_data
2699: );
2700: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Count ' || x_msg_count);
2701: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Data ' || x_msg_data);
2702: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Return Status ' || x_return_status);
2703: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS SQLERRM ' || SQLERRM);
2704: END copy_to_packs;
2705:
2706: END ego_item_associations_pub;

Line 2703: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS SQLERRM ' || SQLERRM);

2699: );
2700: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Count ' || x_msg_count);
2701: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Data ' || x_msg_data);
2702: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Return Status ' || x_return_status);
2703: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS SQLERRM ' || SQLERRM);
2704: END copy_to_packs;
2705:
2706: END ego_item_associations_pub;

Line 2706: END ego_item_associations_pub;

2702: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Return Status ' || x_return_status);
2703: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS SQLERRM ' || SQLERRM);
2704: END copy_to_packs;
2705:
2706: END ego_item_associations_pub;