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.37 2011/07/18 09:40:34 nendrapu ship $ */
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 1609: write_log_message(' ego_item_associations_pub.pre_process Batch Id ' || p_batch_id);

1605: BEGIN
1606: SAVEPOINT pre_process_pub;
1607: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1608: set_globals();
1609: write_log_message(' ego_item_associations_pub.pre_process Batch Id ' || p_batch_id);
1610: -- Set the transaction type to UPPER case..
1611: UPDATE ego_item_associations_intf
1612: SET transaction_type = UPPER(transaction_type)
1613: WHERE batch_id = p_batch_id

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

1785: FND_MSG_PUB.Count_And_Get
1786: ( p_count => x_msg_count,
1787: p_data => x_msg_data
1788: );
1789: write_log_message(' ego_item_associations_pub.pre_process Msg Count ' || x_msg_count);
1790: write_log_message(' ego_item_associations_pub.pre_process Msg Data ' || x_msg_data);
1791: write_log_message(' ego_item_associations_pub.pre_process Return Status ' || x_return_status);
1792: EXCEPTION
1793: WHEN fnd_api.G_EXC_ERROR THEN

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

1786: ( p_count => x_msg_count,
1787: p_data => x_msg_data
1788: );
1789: write_log_message(' ego_item_associations_pub.pre_process Msg Count ' || x_msg_count);
1790: write_log_message(' ego_item_associations_pub.pre_process Msg Data ' || x_msg_data);
1791: write_log_message(' ego_item_associations_pub.pre_process Return Status ' || x_return_status);
1792: EXCEPTION
1793: WHEN fnd_api.G_EXC_ERROR THEN
1794: ROLLBACK TO pre_process_pub;

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

1787: p_data => x_msg_data
1788: );
1789: write_log_message(' ego_item_associations_pub.pre_process Msg Count ' || x_msg_count);
1790: write_log_message(' ego_item_associations_pub.pre_process Msg Data ' || x_msg_data);
1791: write_log_message(' ego_item_associations_pub.pre_process Return Status ' || x_return_status);
1792: EXCEPTION
1793: WHEN fnd_api.G_EXC_ERROR THEN
1794: ROLLBACK TO pre_process_pub;
1795: x_return_status := fnd_api.G_RET_STS_ERROR ;

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

1796: FND_MSG_PUB.Count_And_Get
1797: ( p_count => x_msg_count ,
1798: p_data => x_msg_data
1799: );
1800: write_log_message(' ego_item_associations_pub.pre_process Error Msg Count ' || x_msg_count);
1801: write_log_message(' ego_item_associations_pub.pre_process Error Msg Data ' || x_msg_data);
1802: write_log_message(' ego_item_associations_pub.pre_process Error Return Status ' || x_return_status);
1803: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1804: --dbms_output.put_line(' SQLERRM ' || SQLERRM);

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

1797: ( p_count => x_msg_count ,
1798: p_data => x_msg_data
1799: );
1800: write_log_message(' ego_item_associations_pub.pre_process Error Msg Count ' || x_msg_count);
1801: write_log_message(' ego_item_associations_pub.pre_process Error Msg Data ' || x_msg_data);
1802: write_log_message(' ego_item_associations_pub.pre_process Error Return Status ' || x_return_status);
1803: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1804: --dbms_output.put_line(' SQLERRM ' || SQLERRM);
1805: ROLLBACK TO pre_process_pub;

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

1798: p_data => x_msg_data
1799: );
1800: write_log_message(' ego_item_associations_pub.pre_process Error Msg Count ' || x_msg_count);
1801: write_log_message(' ego_item_associations_pub.pre_process Error Msg Data ' || x_msg_data);
1802: write_log_message(' ego_item_associations_pub.pre_process Error Return Status ' || x_return_status);
1803: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1804: --dbms_output.put_line(' SQLERRM ' || SQLERRM);
1805: ROLLBACK TO pre_process_pub;
1806: UPDATE ego_item_associations_intf

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

1811: FND_MSG_PUB.Count_And_Get
1812: ( p_count => x_msg_count ,
1813: p_data => x_msg_data
1814: );
1815: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Msg Count ' || x_msg_count);
1816: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Msg Data ' || x_msg_data);
1817: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Return Status ' || x_return_status);
1818: WHEN OTHERS THEN
1819: --dbms_output.put_line(' SQLERRM ' || SQLERRM);

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

1812: ( p_count => x_msg_count ,
1813: p_data => x_msg_data
1814: );
1815: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Msg Count ' || x_msg_count);
1816: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Msg Data ' || x_msg_data);
1817: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Return Status ' || x_return_status);
1818: WHEN OTHERS THEN
1819: --dbms_output.put_line(' SQLERRM ' || SQLERRM);
1820: ROLLBACK TO pre_process_pub;

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

1813: p_data => x_msg_data
1814: );
1815: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Msg Count ' || x_msg_count);
1816: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Msg Data ' || x_msg_data);
1817: write_log_message(' ego_item_associations_pub.pre_process Unexpected Error Return Status ' || x_return_status);
1818: WHEN OTHERS THEN
1819: --dbms_output.put_line(' SQLERRM ' || SQLERRM);
1820: ROLLBACK TO pre_process_pub;
1821: UPDATE ego_item_associations_intf

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

1834: FND_MSG_PUB.Count_And_Get
1835: ( p_count => x_msg_count,
1836: p_data => x_msg_data
1837: );
1838: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Count ' || x_msg_count);
1839: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Data ' || x_msg_data);
1840: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Return Status ' || x_return_status);
1841: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS SQLERRM ' || SQLERRM);
1842: END pre_process;

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

1835: ( p_count => x_msg_count,
1836: p_data => x_msg_data
1837: );
1838: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Count ' || x_msg_count);
1839: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Data ' || x_msg_data);
1840: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Return Status ' || x_return_status);
1841: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS SQLERRM ' || SQLERRM);
1842: END pre_process;
1843:

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

1836: p_data => x_msg_data
1837: );
1838: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Count ' || x_msg_count);
1839: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Data ' || x_msg_data);
1840: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Return Status ' || x_return_status);
1841: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS SQLERRM ' || SQLERRM);
1842: END pre_process;
1843:
1844: -- Start of comments

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

1837: );
1838: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Count ' || x_msg_count);
1839: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Msg Data ' || x_msg_data);
1840: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS Return Status ' || x_return_status);
1841: write_log_message(' ego_item_associations_pub.pre_process WHEN OTHERS SQLERRM ' || SQLERRM);
1842: END pre_process;
1843:
1844: -- Start of comments
1845: -- API name : import_item_associations

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

1897: */
1898: FND_MSG_PUB.initialize;
1899: -- Initialize API return status to success
1900: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1901: write_log_message(' ego_item_associations_pub.import_item_associations Batch Id ' || x_batch_id);
1902: -- API body
1903:
1904: -- Set records status as in process
1905: initialize(x_batch_id);

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

1923: FND_MSG_PUB.Count_And_Get
1924: ( p_count => x_msg_count,
1925: p_data => x_msg_data
1926: );
1927: write_log_message(' ego_item_associations_pub.import_item_associations Msg Count ' || x_msg_count);
1928: write_log_message(' ego_item_associations_pub.import_item_associations Msg Data ' || x_msg_data);
1929: write_log_message(' ego_item_associations_pub.import_item_associations Return Status ' || x_return_status);
1930: EXCEPTION
1931: WHEN fnd_api.G_EXC_ERROR THEN

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

1924: ( p_count => x_msg_count,
1925: p_data => x_msg_data
1926: );
1927: write_log_message(' ego_item_associations_pub.import_item_associations Msg Count ' || x_msg_count);
1928: write_log_message(' ego_item_associations_pub.import_item_associations Msg Data ' || x_msg_data);
1929: write_log_message(' ego_item_associations_pub.import_item_associations Return Status ' || x_return_status);
1930: EXCEPTION
1931: WHEN fnd_api.G_EXC_ERROR THEN
1932: ROLLBACK TO import_item_associations_pub;

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

1925: p_data => x_msg_data
1926: );
1927: write_log_message(' ego_item_associations_pub.import_item_associations Msg Count ' || x_msg_count);
1928: write_log_message(' ego_item_associations_pub.import_item_associations Msg Data ' || x_msg_data);
1929: write_log_message(' ego_item_associations_pub.import_item_associations Return Status ' || x_return_status);
1930: EXCEPTION
1931: WHEN fnd_api.G_EXC_ERROR THEN
1932: ROLLBACK TO import_item_associations_pub;
1933: x_return_status := fnd_api.G_RET_STS_ERROR ;

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

1934: FND_MSG_PUB.Count_And_Get
1935: ( p_count => x_msg_count ,
1936: p_data => x_msg_data
1937: );
1938: write_log_message(' ego_item_associations_pub.import_item_associations Error Msg Count ' || x_msg_count);
1939: write_log_message(' ego_item_associations_pub.import_item_associations Error Msg Data ' || x_msg_data);
1940: write_log_message(' ego_item_associations_pub.import_item_associations Error Return Status ' || x_return_status);
1941: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1942: ROLLBACK TO import_item_associations_pub;

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

1935: ( p_count => x_msg_count ,
1936: p_data => x_msg_data
1937: );
1938: write_log_message(' ego_item_associations_pub.import_item_associations Error Msg Count ' || x_msg_count);
1939: write_log_message(' ego_item_associations_pub.import_item_associations Error Msg Data ' || x_msg_data);
1940: write_log_message(' ego_item_associations_pub.import_item_associations Error Return Status ' || x_return_status);
1941: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1942: ROLLBACK TO import_item_associations_pub;
1943: UPDATE ego_item_associations_intf

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

1936: p_data => x_msg_data
1937: );
1938: write_log_message(' ego_item_associations_pub.import_item_associations Error Msg Count ' || x_msg_count);
1939: write_log_message(' ego_item_associations_pub.import_item_associations Error Msg Data ' || x_msg_data);
1940: write_log_message(' ego_item_associations_pub.import_item_associations Error Return Status ' || x_return_status);
1941: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1942: ROLLBACK TO import_item_associations_pub;
1943: UPDATE ego_item_associations_intf
1944: SET process_flag = G_REC_UNEXPECTED_ERROR

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

1948: FND_MSG_PUB.Count_And_Get
1949: ( p_count => x_msg_count ,
1950: p_data => x_msg_data
1951: );
1952: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Msg Count ' || x_msg_count);
1953: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Msg Data ' || x_msg_data);
1954: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Return Status ' || x_return_status);
1955: WHEN OTHERS THEN
1956: ROLLBACK TO import_item_associations_pub;

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

1949: ( p_count => x_msg_count ,
1950: p_data => x_msg_data
1951: );
1952: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Msg Count ' || x_msg_count);
1953: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Msg Data ' || x_msg_data);
1954: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Return Status ' || x_return_status);
1955: WHEN OTHERS THEN
1956: ROLLBACK TO import_item_associations_pub;
1957: UPDATE ego_item_associations_intf

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

1950: p_data => x_msg_data
1951: );
1952: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Msg Count ' || x_msg_count);
1953: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Msg Data ' || x_msg_data);
1954: write_log_message(' ego_item_associations_pub.import_item_associations Unexpected Error Return Status ' || x_return_status);
1955: WHEN OTHERS THEN
1956: ROLLBACK TO import_item_associations_pub;
1957: UPDATE ego_item_associations_intf
1958: SET process_flag = G_REC_UNEXPECTED_ERROR

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

1970: FND_MSG_PUB.Count_And_Get
1971: ( p_count => x_msg_count,
1972: p_data => x_msg_data
1973: );
1974: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS SQLERRM ' || SQLERRM);
1975: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Count ' || x_msg_count);
1976: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msggggg Data ' || x_msg_data);
1977: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Data ' || x_msg_data);
1978: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Return Status ' || x_return_status);

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

1971: ( p_count => x_msg_count,
1972: p_data => x_msg_data
1973: );
1974: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS SQLERRM ' || SQLERRM);
1975: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Count ' || x_msg_count);
1976: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msggggg Data ' || x_msg_data);
1977: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Data ' || x_msg_data);
1978: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Return Status ' || x_return_status);
1979: END import_item_associations;

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

1972: p_data => x_msg_data
1973: );
1974: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS SQLERRM ' || SQLERRM);
1975: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Count ' || x_msg_count);
1976: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msggggg Data ' || x_msg_data);
1977: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Data ' || x_msg_data);
1978: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Return Status ' || x_return_status);
1979: END import_item_associations;
1980:

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

1973: );
1974: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS SQLERRM ' || SQLERRM);
1975: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Count ' || x_msg_count);
1976: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msggggg Data ' || x_msg_data);
1977: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Data ' || x_msg_data);
1978: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Return Status ' || x_return_status);
1979: END import_item_associations;
1980:
1981: -- Start of comments

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

1974: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS SQLERRM ' || SQLERRM);
1975: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Count ' || x_msg_count);
1976: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msggggg Data ' || x_msg_data);
1977: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Msg Data ' || x_msg_data);
1978: write_log_message(' ego_item_associations_pub.import_item_associations WHEN OTHERS Return Status ' || x_return_status);
1979: END import_item_associations;
1980:
1981: -- Start of comments
1982: -- API name : import_item_associations

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

2133: AND eia.data_level_id = l_data_level_id
2134: AND msii.process_flag = G_REC_TO_BE_PROCESSED
2135: AND eia.organization_id = msii.organization_id
2136: AND msii.organization_id = mp.organization_id;
2137: write_log_message(' ego_item_associations_pub.copy_associations_to_items after insert ');
2138: END LOOP;
2139: FND_MSG_PUB.Count_And_Get
2140: ( p_count => x_msg_count,
2141: p_data => x_msg_data

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

2139: FND_MSG_PUB.Count_And_Get
2140: ( p_count => x_msg_count,
2141: p_data => x_msg_data
2142: );
2143: write_log_message(' ego_item_associations_pub.copy_associations_to_items Msg Count ' || x_msg_count);
2144: write_log_message(' ego_item_associations_pub.copy_associations_to_items Msg Data ' || x_msg_data);
2145: write_log_message(' ego_item_associations_pub.copy_associations_to_items Return Status ' || x_return_status);
2146: EXCEPTION
2147: WHEN fnd_api.G_EXC_ERROR THEN

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

2140: ( p_count => x_msg_count,
2141: p_data => x_msg_data
2142: );
2143: write_log_message(' ego_item_associations_pub.copy_associations_to_items Msg Count ' || x_msg_count);
2144: write_log_message(' ego_item_associations_pub.copy_associations_to_items Msg Data ' || x_msg_data);
2145: write_log_message(' ego_item_associations_pub.copy_associations_to_items Return Status ' || x_return_status);
2146: EXCEPTION
2147: WHEN fnd_api.G_EXC_ERROR THEN
2148: ROLLBACK TO copy_associations_to_items_pub;

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

2141: p_data => x_msg_data
2142: );
2143: write_log_message(' ego_item_associations_pub.copy_associations_to_items Msg Count ' || x_msg_count);
2144: write_log_message(' ego_item_associations_pub.copy_associations_to_items Msg Data ' || x_msg_data);
2145: write_log_message(' ego_item_associations_pub.copy_associations_to_items Return Status ' || x_return_status);
2146: EXCEPTION
2147: WHEN fnd_api.G_EXC_ERROR THEN
2148: ROLLBACK TO copy_associations_to_items_pub;
2149: x_return_status := fnd_api.G_RET_STS_ERROR ;

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

2150: FND_MSG_PUB.Count_And_Get
2151: ( p_count => x_msg_count ,
2152: p_data => x_msg_data
2153: );
2154: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Msg Count ' || x_msg_count);
2155: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Msg Data ' || x_msg_data);
2156: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Return Status ' || x_return_status);
2157: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2158: ROLLBACK TO copy_associations_to_items_pub;

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

2151: ( p_count => x_msg_count ,
2152: p_data => x_msg_data
2153: );
2154: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Msg Count ' || x_msg_count);
2155: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Msg Data ' || x_msg_data);
2156: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Return Status ' || x_return_status);
2157: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2158: ROLLBACK TO copy_associations_to_items_pub;
2159: UPDATE ego_item_associations_intf

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

2152: p_data => x_msg_data
2153: );
2154: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Msg Count ' || x_msg_count);
2155: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Msg Data ' || x_msg_data);
2156: write_log_message(' ego_item_associations_pub.copy_associations_to_items Error Return Status ' || x_return_status);
2157: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2158: ROLLBACK TO copy_associations_to_items_pub;
2159: UPDATE ego_item_associations_intf
2160: SET process_flag = G_REC_UNEXPECTED_ERROR

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

2164: FND_MSG_PUB.Count_And_Get
2165: ( p_count => x_msg_count ,
2166: p_data => x_msg_data
2167: );
2168: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Msg Count ' || x_msg_count);
2169: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Msg Data ' || x_msg_data);
2170: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Return Status ' || x_return_status);
2171: WHEN OTHERS THEN
2172: ROLLBACK TO copy_associations_to_items_pub;

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

2165: ( p_count => x_msg_count ,
2166: p_data => x_msg_data
2167: );
2168: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Msg Count ' || x_msg_count);
2169: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Msg Data ' || x_msg_data);
2170: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Return Status ' || x_return_status);
2171: WHEN OTHERS THEN
2172: ROLLBACK TO copy_associations_to_items_pub;
2173: UPDATE ego_item_associations_intf

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

2166: p_data => x_msg_data
2167: );
2168: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Msg Count ' || x_msg_count);
2169: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Msg Data ' || x_msg_data);
2170: write_log_message(' ego_item_associations_pub.copy_associations_to_items Unexpected Error Return Status ' || x_return_status);
2171: WHEN OTHERS THEN
2172: ROLLBACK TO copy_associations_to_items_pub;
2173: UPDATE ego_item_associations_intf
2174: SET process_flag = G_REC_UNEXPECTED_ERROR

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

2186: FND_MSG_PUB.Count_And_Get
2187: ( p_count => x_msg_count,
2188: p_data => x_msg_data
2189: );
2190: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Count ' || x_msg_count);
2191: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Data ' || x_msg_data);
2192: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Return Status ' || x_return_status);
2193: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS SQLERRM ' || SQLERRM);
2194: END copy_associations_to_items;

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

2187: ( p_count => x_msg_count,
2188: p_data => x_msg_data
2189: );
2190: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Count ' || x_msg_count);
2191: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Data ' || x_msg_data);
2192: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Return Status ' || x_return_status);
2193: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS SQLERRM ' || SQLERRM);
2194: END copy_associations_to_items;
2195:

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

2188: p_data => x_msg_data
2189: );
2190: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Count ' || x_msg_count);
2191: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Data ' || x_msg_data);
2192: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Return Status ' || x_return_status);
2193: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS SQLERRM ' || SQLERRM);
2194: END copy_associations_to_items;
2195:
2196: -- Start of comments

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

2189: );
2190: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Count ' || x_msg_count);
2191: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Msg Data ' || x_msg_data);
2192: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS Return Status ' || x_return_status);
2193: write_log_message(' ego_item_associations_pub.copy_associations_to_items WHEN OTHERS SQLERRM ' || SQLERRM);
2194: END copy_associations_to_items;
2195:
2196: -- Start of comments
2197: -- API name : copy_from_style_to_SKUs

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

2471: FND_MSG_PUB.Count_And_Get
2472: ( p_count => x_msg_count,
2473: p_data => x_msg_data
2474: );
2475: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Msg Count ' || x_msg_count);
2476: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Msg Data ' || x_msg_data);
2477: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Return Status ' || x_return_status);
2478: EXCEPTION
2479: WHEN fnd_api.G_EXC_ERROR THEN

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

2472: ( p_count => x_msg_count,
2473: p_data => x_msg_data
2474: );
2475: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Msg Count ' || x_msg_count);
2476: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Msg Data ' || x_msg_data);
2477: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Return Status ' || x_return_status);
2478: EXCEPTION
2479: WHEN fnd_api.G_EXC_ERROR THEN
2480: ROLLBACK TO copy_from_style_to_SKUs_pub;

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

2473: p_data => x_msg_data
2474: );
2475: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Msg Count ' || x_msg_count);
2476: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Msg Data ' || x_msg_data);
2477: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Return Status ' || x_return_status);
2478: EXCEPTION
2479: WHEN fnd_api.G_EXC_ERROR THEN
2480: ROLLBACK TO copy_from_style_to_SKUs_pub;
2481: x_return_status := fnd_api.G_RET_STS_ERROR ;

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

2482: FND_MSG_PUB.Count_And_Get
2483: ( p_count => x_msg_count ,
2484: p_data => x_msg_data
2485: );
2486: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Msg Count ' || x_msg_count);
2487: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Msg Data ' || x_msg_data);
2488: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Return Status ' || x_return_status);
2489: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2490: --dbms_output.put_line(' Error Msg ' || SQLERRM);

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

2483: ( p_count => x_msg_count ,
2484: p_data => x_msg_data
2485: );
2486: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Msg Count ' || x_msg_count);
2487: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Msg Data ' || x_msg_data);
2488: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Return Status ' || x_return_status);
2489: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2490: --dbms_output.put_line(' Error Msg ' || SQLERRM);
2491: ROLLBACK TO copy_from_style_to_SKUs_pub;

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

2484: p_data => x_msg_data
2485: );
2486: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Msg Count ' || x_msg_count);
2487: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Msg Data ' || x_msg_data);
2488: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Error Return Status ' || x_return_status);
2489: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2490: --dbms_output.put_line(' Error Msg ' || SQLERRM);
2491: ROLLBACK TO copy_from_style_to_SKUs_pub;
2492: UPDATE ego_item_associations_intf

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

2497: FND_MSG_PUB.Count_And_Get
2498: ( p_count => x_msg_count ,
2499: p_data => x_msg_data
2500: );
2501: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Msg Count ' || x_msg_count);
2502: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Msg Data ' || x_msg_data);
2503: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Return Status ' || x_return_status);
2504: WHEN OTHERS THEN
2505: --dbms_output.put_line(' Error Msg ' || SQLERRM);

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

2498: ( p_count => x_msg_count ,
2499: p_data => x_msg_data
2500: );
2501: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Msg Count ' || x_msg_count);
2502: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Msg Data ' || x_msg_data);
2503: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Return Status ' || x_return_status);
2504: WHEN OTHERS THEN
2505: --dbms_output.put_line(' Error Msg ' || SQLERRM);
2506: ROLLBACK TO copy_from_style_to_SKUs_pub;

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

2499: p_data => x_msg_data
2500: );
2501: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Msg Count ' || x_msg_count);
2502: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Msg Data ' || x_msg_data);
2503: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs Unexpected Error Return Status ' || x_return_status);
2504: WHEN OTHERS THEN
2505: --dbms_output.put_line(' Error Msg ' || SQLERRM);
2506: ROLLBACK TO copy_from_style_to_SKUs_pub;
2507: UPDATE ego_item_associations_intf

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

2520: FND_MSG_PUB.Count_And_Get
2521: ( p_count => x_msg_count,
2522: p_data => x_msg_data
2523: );
2524: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Count ' || x_msg_count);
2525: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Data ' || x_msg_data);
2526: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Return Status ' || x_return_status);
2527: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS SQLERRM ' || SQLERRM);
2528: END copy_from_style_to_SKUs;

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

2521: ( p_count => x_msg_count,
2522: p_data => x_msg_data
2523: );
2524: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Count ' || x_msg_count);
2525: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Data ' || x_msg_data);
2526: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Return Status ' || x_return_status);
2527: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS SQLERRM ' || SQLERRM);
2528: END copy_from_style_to_SKUs;
2529:

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

2522: p_data => x_msg_data
2523: );
2524: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Count ' || x_msg_count);
2525: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Data ' || x_msg_data);
2526: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Return Status ' || x_return_status);
2527: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS SQLERRM ' || SQLERRM);
2528: END copy_from_style_to_SKUs;
2529:
2530: -- Start of comments

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

2523: );
2524: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Count ' || x_msg_count);
2525: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Msg Data ' || x_msg_data);
2526: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS Return Status ' || x_return_status);
2527: write_log_message(' ego_item_associations_pub.copy_from_style_to_SKUs WHEN OTHERS SQLERRM ' || SQLERRM);
2528: END copy_from_style_to_SKUs;
2529:
2530: -- Start of comments
2531: -- API name : copy_to_packs

Line 2583: AND bsb.alternate_bom_designator = ego_item_associations_pub.G_PACK_STR_NAME

2579: WHERE bsb.assembly_item_id = msibk.inventory_item_id
2580: AND bsb.assembly_item_id = msibk.inventory_item_id
2581: AND bsb.organization_id = eiai.organization_id
2582: AND bsb.bill_sequence_id = bsb.common_bill_sequence_id
2583: AND bsb.alternate_bom_designator = ego_item_associations_pub.G_PACK_STR_NAME
2584: );
2585: BEGIN
2586: x_return_status := fnd_api.G_RET_STS_SUCCESS;
2587: -- Set the Global Variables

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

2715: FND_MSG_PUB.Count_And_Get
2716: ( p_count => x_msg_count,
2717: p_data => x_msg_data
2718: );
2719: write_log_message(' ego_item_associations_pub.copy_to_packs Msg Count ' || x_msg_count);
2720: write_log_message(' ego_item_associations_pub.copy_to_packs Msg Data ' || x_msg_data);
2721: write_log_message(' ego_item_associations_pub.copy_to_packs Return Status ' || x_return_status);
2722: EXCEPTION
2723: WHEN fnd_api.G_EXC_ERROR THEN

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

2716: ( p_count => x_msg_count,
2717: p_data => x_msg_data
2718: );
2719: write_log_message(' ego_item_associations_pub.copy_to_packs Msg Count ' || x_msg_count);
2720: write_log_message(' ego_item_associations_pub.copy_to_packs Msg Data ' || x_msg_data);
2721: write_log_message(' ego_item_associations_pub.copy_to_packs Return Status ' || x_return_status);
2722: EXCEPTION
2723: WHEN fnd_api.G_EXC_ERROR THEN
2724: ROLLBACK TO copy_to_packs_pub;

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

2717: p_data => x_msg_data
2718: );
2719: write_log_message(' ego_item_associations_pub.copy_to_packs Msg Count ' || x_msg_count);
2720: write_log_message(' ego_item_associations_pub.copy_to_packs Msg Data ' || x_msg_data);
2721: write_log_message(' ego_item_associations_pub.copy_to_packs Return Status ' || x_return_status);
2722: EXCEPTION
2723: WHEN fnd_api.G_EXC_ERROR THEN
2724: ROLLBACK TO copy_to_packs_pub;
2725: x_return_status := fnd_api.G_RET_STS_ERROR ;

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

2726: FND_MSG_PUB.Count_And_Get
2727: ( p_count => x_msg_count ,
2728: p_data => x_msg_data
2729: );
2730: write_log_message(' ego_item_associations_pub.copy_to_packs Error Msg Count ' || x_msg_count);
2731: write_log_message(' ego_item_associations_pub.copy_to_packs Error Msg Data ' || x_msg_data);
2732: write_log_message(' ego_item_associations_pub.copy_to_packs Error Return Status ' || x_return_status);
2733: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2734: --dbms_output.put_line(' Error Msg ' || SQLERRM);

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

2727: ( p_count => x_msg_count ,
2728: p_data => x_msg_data
2729: );
2730: write_log_message(' ego_item_associations_pub.copy_to_packs Error Msg Count ' || x_msg_count);
2731: write_log_message(' ego_item_associations_pub.copy_to_packs Error Msg Data ' || x_msg_data);
2732: write_log_message(' ego_item_associations_pub.copy_to_packs Error Return Status ' || x_return_status);
2733: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2734: --dbms_output.put_line(' Error Msg ' || SQLERRM);
2735: ROLLBACK TO copy_to_packs_pub;

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

2728: p_data => x_msg_data
2729: );
2730: write_log_message(' ego_item_associations_pub.copy_to_packs Error Msg Count ' || x_msg_count);
2731: write_log_message(' ego_item_associations_pub.copy_to_packs Error Msg Data ' || x_msg_data);
2732: write_log_message(' ego_item_associations_pub.copy_to_packs Error Return Status ' || x_return_status);
2733: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2734: --dbms_output.put_line(' Error Msg ' || SQLERRM);
2735: ROLLBACK TO copy_to_packs_pub;
2736: UPDATE ego_item_associations_intf

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

2741: FND_MSG_PUB.Count_And_Get
2742: ( p_count => x_msg_count ,
2743: p_data => x_msg_data
2744: );
2745: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Msg Count ' || x_msg_count);
2746: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Msg Data ' || x_msg_data);
2747: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Return Status ' || x_return_status);
2748: WHEN OTHERS THEN
2749: --dbms_output.put_line(' Error Msg ' || SQLERRM);

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

2742: ( p_count => x_msg_count ,
2743: p_data => x_msg_data
2744: );
2745: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Msg Count ' || x_msg_count);
2746: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Msg Data ' || x_msg_data);
2747: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Return Status ' || x_return_status);
2748: WHEN OTHERS THEN
2749: --dbms_output.put_line(' Error Msg ' || SQLERRM);
2750: ROLLBACK TO copy_to_packs_pub;

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

2743: p_data => x_msg_data
2744: );
2745: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Msg Count ' || x_msg_count);
2746: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Msg Data ' || x_msg_data);
2747: write_log_message(' ego_item_associations_pub.copy_to_packs Unexpected Error Return Status ' || x_return_status);
2748: WHEN OTHERS THEN
2749: --dbms_output.put_line(' Error Msg ' || SQLERRM);
2750: ROLLBACK TO copy_to_packs_pub;
2751: UPDATE ego_item_associations_intf

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

2764: FND_MSG_PUB.Count_And_Get
2765: ( p_count => x_msg_count,
2766: p_data => x_msg_data
2767: );
2768: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Count ' || x_msg_count);
2769: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Data ' || x_msg_data);
2770: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Return Status ' || x_return_status);
2771: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS SQLERRM ' || SQLERRM);
2772: END copy_to_packs;

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

2765: ( p_count => x_msg_count,
2766: p_data => x_msg_data
2767: );
2768: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Count ' || x_msg_count);
2769: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Data ' || x_msg_data);
2770: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Return Status ' || x_return_status);
2771: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS SQLERRM ' || SQLERRM);
2772: END copy_to_packs;
2773:

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

2766: p_data => x_msg_data
2767: );
2768: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Count ' || x_msg_count);
2769: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Data ' || x_msg_data);
2770: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Return Status ' || x_return_status);
2771: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS SQLERRM ' || SQLERRM);
2772: END copy_to_packs;
2773:
2774: END ego_item_associations_pub;

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

2767: );
2768: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Count ' || x_msg_count);
2769: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Msg Data ' || x_msg_data);
2770: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Return Status ' || x_return_status);
2771: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS SQLERRM ' || SQLERRM);
2772: END copy_to_packs;
2773:
2774: END ego_item_associations_pub;

Line 2774: END ego_item_associations_pub;

2770: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS Return Status ' || x_return_status);
2771: write_log_message(' ego_item_associations_pub.copy_to_packs WHEN OTHERS SQLERRM ' || SQLERRM);
2772: END copy_to_packs;
2773:
2774: END ego_item_associations_pub;