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 FND_API

Line 543: IF ego_item_associations_util.is_supplier_contact(G_PARTY_ID) = FND_API.G_TRUE THEN

539: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);
540: APP_EXCEPTION.RAISE_EXCEPTION();
541: END IF;
542:
543: IF ego_item_associations_util.is_supplier_contact(G_PARTY_ID) = FND_API.G_TRUE THEN
544: UPDATE ego_item_associations_intf eiai
545: SET process_flag = G_REC_NO_SUPPL_ACCESS_PRIV
546: WHERE eiai.batch_id = p_batch_id
547: AND eiai.process_flag = G_REC_IN_PROCESS

Line 1607: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1603: l_data_level_id NUMBER := NULL;
1604: l_default_option_code VARCHAR2(50) := NULL;
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

Line 1793: WHEN fnd_api.G_EXC_ERROR THEN

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 ;
1796: FND_MSG_PUB.Count_And_Get
1797: ( p_count => x_msg_count ,

Line 1795: x_return_status := fnd_api.G_RET_STS_ERROR ;

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 ;
1796: FND_MSG_PUB.Count_And_Get
1797: ( p_count => x_msg_count ,
1798: p_data => x_msg_data
1799: );

Line 1803: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

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
1807: SET process_flag = G_REC_UNEXPECTED_ERROR

Line 1810: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

1806: UPDATE ego_item_associations_intf
1807: SET process_flag = G_REC_UNEXPECTED_ERROR
1808: WHERE batch_id = p_batch_id
1809: AND process_flag = G_REC_TO_BE_PROCESSED;
1810: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
1811: FND_MSG_PUB.Count_And_Get
1812: ( p_count => x_msg_count ,
1813: p_data => x_msg_data
1814: );

Line 1825: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

1821: UPDATE ego_item_associations_intf
1822: SET process_flag = G_REC_UNEXPECTED_ERROR
1823: WHERE batch_id = p_batch_id
1824: AND process_flag = G_REC_TO_BE_PROCESSED;
1825: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
1826: IF FND_MSG_PUB.Check_Msg_Level
1827: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1828: THEN
1829: FND_MSG_PUB.Add_Exc_Msg

Line 1885: IF NOT fnd_api.Compatible_API_Call ( l_api_version,

1881: set_globals();
1882: -- Standard Start of API savepoint
1883: SAVEPOINT import_item_associations_pub;
1884: -- Standard call to check for call compatibility.
1885: IF NOT fnd_api.Compatible_API_Call ( l_api_version,
1886: p_api_version,
1887: l_api_name,
1888: G_PKG_NAME )
1889: THEN

Line 1890: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

1886: p_api_version,
1887: l_api_name,
1888: G_PKG_NAME )
1889: THEN
1890: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
1891: END IF;
1892: -- Initialize message list if p_init_msg_list is set to TRUE.
1893: /*
1894: IF fnd_api.to_Boolean( p_init_msg_list ) THEN

Line 1894: IF fnd_api.to_Boolean( p_init_msg_list ) THEN

1890: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
1891: END IF;
1892: -- Initialize message list if p_init_msg_list is set to TRUE.
1893: /*
1894: IF fnd_api.to_Boolean( p_init_msg_list ) THEN
1895: FND_MSG_PUB.initialize;
1896: END IF;
1897: */
1898: FND_MSG_PUB.initialize;

Line 1900: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1896: END IF;
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

Line 1931: WHEN fnd_api.G_EXC_ERROR THEN

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 ;
1934: FND_MSG_PUB.Count_And_Get
1935: ( p_count => x_msg_count ,

Line 1933: x_return_status := fnd_api.G_RET_STS_ERROR ;

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 ;
1934: FND_MSG_PUB.Count_And_Get
1935: ( p_count => x_msg_count ,
1936: p_data => x_msg_data
1937: );

Line 1941: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

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
1945: WHERE batch_id = x_batch_id

Line 1947: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

1943: UPDATE ego_item_associations_intf
1944: SET process_flag = G_REC_UNEXPECTED_ERROR
1945: WHERE batch_id = x_batch_id
1946: AND process_flag = G_REC_TO_BE_PROCESSED;
1947: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
1948: FND_MSG_PUB.Count_And_Get
1949: ( p_count => x_msg_count ,
1950: p_data => x_msg_data
1951: );

Line 1961: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

1957: UPDATE ego_item_associations_intf
1958: SET process_flag = G_REC_UNEXPECTED_ERROR
1959: WHERE batch_id = x_batch_id
1960: AND process_flag = G_REC_TO_BE_PROCESSED;
1961: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
1962: IF FND_MSG_PUB.Check_Msg_Level
1963: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1964: THEN
1965: FND_MSG_PUB.Add_Exc_Msg

Line 2018: IF ( l_return_status = fnd_api.G_RET_STS_SUCCESS ) THEN

2014: ,x_return_status =>l_return_status
2015: ,x_msg_count => l_msg_count
2016: ,x_msg_data => x_errbuf
2017: );
2018: IF ( l_return_status = fnd_api.G_RET_STS_SUCCESS ) THEN
2019: x_retcode := '0';
2020: ELSIF ( l_return_status = fnd_api.G_RET_STS_ERROR ) THEN
2021: x_retcode := '2';
2022: END IF;

Line 2020: ELSIF ( l_return_status = fnd_api.G_RET_STS_ERROR ) THEN

2016: ,x_msg_data => x_errbuf
2017: );
2018: IF ( l_return_status = fnd_api.G_RET_STS_SUCCESS ) THEN
2019: x_retcode := '0';
2020: ELSIF ( l_return_status = fnd_api.G_RET_STS_ERROR ) THEN
2021: x_retcode := '2';
2022: END IF;
2023: END import_item_associations;
2024:

Line 2071: x_return_status := fnd_api.G_RET_STS_ERROR;

2067: FROM mtl_parameters
2068: WHERE organization_id = p_from_org_id;
2069: EXCEPTION
2070: WHEN NO_DATA_FOUND THEN
2071: x_return_status := fnd_api.G_RET_STS_ERROR;
2072: RETURN;
2073: END;
2074: */
2075: -- Initialize API return status to success

Line 2076: x_return_status := fnd_api.G_RET_STS_SUCCESS;

2072: RETURN;
2073: END;
2074: */
2075: -- Initialize API return status to success
2076: x_return_status := fnd_api.G_RET_STS_SUCCESS;
2077: SAVEPOINT copy_associations_to_items_pub;
2078: write_log_message(' Before looping data levels ');
2079: FOR I IN p_data_level_names.FIRST..p_data_level_names.LAST
2080: LOOP

Line 2147: WHEN fnd_api.G_EXC_ERROR THEN

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 ;
2150: FND_MSG_PUB.Count_And_Get
2151: ( p_count => x_msg_count ,

Line 2149: x_return_status := fnd_api.G_RET_STS_ERROR ;

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 ;
2150: FND_MSG_PUB.Count_And_Get
2151: ( p_count => x_msg_count ,
2152: p_data => x_msg_data
2153: );

Line 2157: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

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
2161: WHERE batch_id = p_batch_id

Line 2163: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

2159: UPDATE ego_item_associations_intf
2160: SET process_flag = G_REC_UNEXPECTED_ERROR
2161: WHERE batch_id = p_batch_id
2162: AND process_flag = G_REC_TO_BE_PROCESSED;
2163: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2164: FND_MSG_PUB.Count_And_Get
2165: ( p_count => x_msg_count ,
2166: p_data => x_msg_data
2167: );

Line 2177: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

2173: UPDATE ego_item_associations_intf
2174: SET process_flag = G_REC_UNEXPECTED_ERROR
2175: WHERE batch_id = p_batch_id
2176: AND process_flag = G_REC_TO_BE_PROCESSED;
2177: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2178: IF FND_MSG_PUB.Check_Msg_Level
2179: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2180: THEN
2181: FND_MSG_PUB.Add_Exc_Msg

Line 2230: x_return_status := fnd_api.G_RET_STS_SUCCESS;

2226: BEGIN
2227: -- Set the Global Variables
2228: set_globals();
2229: -- Initialize API return status to success
2230: x_return_status := fnd_api.G_RET_STS_SUCCESS;
2231: SAVEPOINT copy_from_style_to_SKUs_pub;
2232: FOR I IN G_DATA_LEVEL_NAMES.FIRST..G_DATA_LEVEL_NAMES.LAST
2233: LOOP
2234: IF ( G_DATA_LEVEL_NAMES(I) = G_ITEM_SUP_LEVEL_NAME ) THEN

Line 2479: WHEN fnd_api.G_EXC_ERROR THEN

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 ;
2482: FND_MSG_PUB.Count_And_Get
2483: ( p_count => x_msg_count ,

Line 2481: x_return_status := fnd_api.G_RET_STS_ERROR ;

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 ;
2482: FND_MSG_PUB.Count_And_Get
2483: ( p_count => x_msg_count ,
2484: p_data => x_msg_data
2485: );

Line 2489: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

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
2493: SET process_flag = G_REC_UNEXPECTED_ERROR

Line 2496: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

2492: UPDATE ego_item_associations_intf
2493: SET process_flag = G_REC_UNEXPECTED_ERROR
2494: WHERE batch_id = p_batch_id
2495: AND process_flag = G_REC_TO_BE_PROCESSED;
2496: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2497: FND_MSG_PUB.Count_And_Get
2498: ( p_count => x_msg_count ,
2499: p_data => x_msg_data
2500: );

Line 2511: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

2507: UPDATE ego_item_associations_intf
2508: SET process_flag = G_REC_UNEXPECTED_ERROR
2509: WHERE batch_id = p_batch_id
2510: AND process_flag = G_REC_TO_BE_PROCESSED;
2511: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2512: IF FND_MSG_PUB.Check_Msg_Level
2513: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2514: THEN
2515: FND_MSG_PUB.Add_Exc_Msg

Line 2586: x_return_status := fnd_api.G_RET_STS_SUCCESS;

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
2588: set_globals();
2589: -- Initialize API return status to success
2590: SAVEPOINT copy_to_packs_pub;

Line 2723: WHEN fnd_api.G_EXC_ERROR THEN

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 ;
2726: FND_MSG_PUB.Count_And_Get
2727: ( p_count => x_msg_count ,

Line 2725: x_return_status := fnd_api.G_RET_STS_ERROR ;

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 ;
2726: FND_MSG_PUB.Count_And_Get
2727: ( p_count => x_msg_count ,
2728: p_data => x_msg_data
2729: );

Line 2733: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

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
2737: SET process_flag = G_REC_UNEXPECTED_ERROR

Line 2740: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

2736: UPDATE ego_item_associations_intf
2737: SET process_flag = G_REC_UNEXPECTED_ERROR
2738: WHERE batch_id = p_batch_id
2739: AND process_flag = G_REC_TO_BE_PROCESSED;
2740: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2741: FND_MSG_PUB.Count_And_Get
2742: ( p_count => x_msg_count ,
2743: p_data => x_msg_data
2744: );

Line 2755: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

2751: UPDATE ego_item_associations_intf
2752: SET process_flag = G_REC_UNEXPECTED_ERROR
2753: WHERE batch_id = p_batch_id
2754: AND process_flag = G_REC_TO_BE_PROCESSED;
2755: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2756: IF FND_MSG_PUB.Check_Msg_Level
2757: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2758: THEN
2759: FND_MSG_PUB.Add_Exc_Msg