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.

[Home] [Help]

APPS.EGO_ITEM_ASSOCIATIONS_PUB dependencies on FND_API

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

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

Line 1543: x_return_status := fnd_api.G_RET_STS_SUCCESS;

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

Line 1726: WHEN fnd_api.G_EXC_ERROR THEN

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

Line 1728: x_return_status := fnd_api.G_RET_STS_ERROR ;

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 ;
1729: FND_MSG_PUB.Count_And_Get
1730: ( p_count => x_msg_count ,
1731: p_data => x_msg_data
1732: );

Line 1736: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1743: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

1739: UPDATE ego_item_associations_intf
1740: SET process_flag = G_REC_UNEXPECTED_ERROR
1741: WHERE batch_id = p_batch_id
1742: AND process_flag = G_REC_TO_BE_PROCESSED;
1743: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
1744: FND_MSG_PUB.Count_And_Get
1745: ( p_count => x_msg_count ,
1746: p_data => x_msg_data
1747: );

Line 1758: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

1754: UPDATE ego_item_associations_intf
1755: SET process_flag = G_REC_UNEXPECTED_ERROR
1756: WHERE batch_id = p_batch_id
1757: AND process_flag = G_REC_TO_BE_PROCESSED;
1758: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
1759: IF FND_MSG_PUB.Check_Msg_Level
1760: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1761: THEN
1762: FND_MSG_PUB.Add_Exc_Msg

Line 1818: IF NOT fnd_api.Compatible_API_Call ( l_api_version,

1814: set_globals();
1815: -- Standard Start of API savepoint
1816: SAVEPOINT import_item_associations_pub;
1817: -- Standard call to check for call compatibility.
1818: IF NOT fnd_api.Compatible_API_Call ( l_api_version,
1819: p_api_version,
1820: l_api_name,
1821: G_PKG_NAME )
1822: THEN

Line 1823: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

1819: p_api_version,
1820: l_api_name,
1821: G_PKG_NAME )
1822: THEN
1823: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
1824: END IF;
1825: -- Initialize message list if p_init_msg_list is set to TRUE.
1826: /*
1827: IF fnd_api.to_Boolean( p_init_msg_list ) THEN

Line 1827: IF fnd_api.to_Boolean( p_init_msg_list ) THEN

1823: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
1824: END IF;
1825: -- Initialize message list if p_init_msg_list is set to TRUE.
1826: /*
1827: IF fnd_api.to_Boolean( p_init_msg_list ) THEN
1828: FND_MSG_PUB.initialize;
1829: END IF;
1830: */
1831: FND_MSG_PUB.initialize;

Line 1833: x_return_status := fnd_api.G_RET_STS_SUCCESS;

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

Line 1864: WHEN fnd_api.G_EXC_ERROR THEN

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

Line 1866: x_return_status := fnd_api.G_RET_STS_ERROR ;

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 ;
1867: FND_MSG_PUB.Count_And_Get
1868: ( p_count => x_msg_count ,
1869: p_data => x_msg_data
1870: );

Line 1874: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1880: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

1876: UPDATE ego_item_associations_intf
1877: SET process_flag = G_REC_UNEXPECTED_ERROR
1878: WHERE batch_id = x_batch_id
1879: AND process_flag = G_REC_TO_BE_PROCESSED;
1880: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
1881: FND_MSG_PUB.Count_And_Get
1882: ( p_count => x_msg_count ,
1883: p_data => x_msg_data
1884: );

Line 1894: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

1890: UPDATE ego_item_associations_intf
1891: SET process_flag = G_REC_UNEXPECTED_ERROR
1892: WHERE batch_id = x_batch_id
1893: AND process_flag = G_REC_TO_BE_PROCESSED;
1894: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
1895: IF FND_MSG_PUB.Check_Msg_Level
1896: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1897: THEN
1898: FND_MSG_PUB.Add_Exc_Msg

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

1947: ,x_return_status =>l_return_status
1948: ,x_msg_count => l_msg_count
1949: ,x_msg_data => x_errbuf
1950: );
1951: IF ( l_return_status = fnd_api.G_RET_STS_SUCCESS ) THEN
1952: x_retcode := '0';
1953: ELSIF ( l_return_status = fnd_api.G_RET_STS_ERROR ) THEN
1954: x_retcode := '2';
1955: END IF;

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

1949: ,x_msg_data => x_errbuf
1950: );
1951: IF ( l_return_status = fnd_api.G_RET_STS_SUCCESS ) THEN
1952: x_retcode := '0';
1953: ELSIF ( l_return_status = fnd_api.G_RET_STS_ERROR ) THEN
1954: x_retcode := '2';
1955: END IF;
1956: END import_item_associations;
1957:

Line 2004: x_return_status := fnd_api.G_RET_STS_ERROR;

2000: FROM mtl_parameters
2001: WHERE organization_id = p_from_org_id;
2002: EXCEPTION
2003: WHEN NO_DATA_FOUND THEN
2004: x_return_status := fnd_api.G_RET_STS_ERROR;
2005: RETURN;
2006: END;
2007: */
2008: -- Initialize API return status to success

Line 2009: x_return_status := fnd_api.G_RET_STS_SUCCESS;

2005: RETURN;
2006: END;
2007: */
2008: -- Initialize API return status to success
2009: x_return_status := fnd_api.G_RET_STS_SUCCESS;
2010: SAVEPOINT copy_associations_to_items_pub;
2011: write_log_message(' Before looping data levels ');
2012: FOR I IN p_data_level_names.FIRST..p_data_level_names.LAST
2013: LOOP

Line 2080: WHEN fnd_api.G_EXC_ERROR THEN

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

Line 2082: x_return_status := fnd_api.G_RET_STS_ERROR ;

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 ;
2083: FND_MSG_PUB.Count_And_Get
2084: ( p_count => x_msg_count ,
2085: p_data => x_msg_data
2086: );

Line 2090: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2096: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

2092: UPDATE ego_item_associations_intf
2093: SET process_flag = G_REC_UNEXPECTED_ERROR
2094: WHERE batch_id = p_batch_id
2095: AND process_flag = G_REC_TO_BE_PROCESSED;
2096: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2097: FND_MSG_PUB.Count_And_Get
2098: ( p_count => x_msg_count ,
2099: p_data => x_msg_data
2100: );

Line 2110: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

2106: UPDATE ego_item_associations_intf
2107: SET process_flag = G_REC_UNEXPECTED_ERROR
2108: WHERE batch_id = p_batch_id
2109: AND process_flag = G_REC_TO_BE_PROCESSED;
2110: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2111: IF FND_MSG_PUB.Check_Msg_Level
2112: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2113: THEN
2114: FND_MSG_PUB.Add_Exc_Msg

Line 2162: x_return_status := fnd_api.G_RET_STS_SUCCESS;

2158: BEGIN
2159: -- Set the Global Variables
2160: set_globals();
2161: -- Initialize API return status to success
2162: x_return_status := fnd_api.G_RET_STS_SUCCESS;
2163: SAVEPOINT copy_from_style_to_SKUs_pub;
2164: FOR I IN G_DATA_LEVEL_NAMES.FIRST..G_DATA_LEVEL_NAMES.LAST
2165: LOOP
2166: IF ( G_DATA_LEVEL_NAMES(I) = G_ITEM_SUP_LEVEL_NAME ) THEN

Line 2411: WHEN fnd_api.G_EXC_ERROR THEN

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

Line 2413: x_return_status := fnd_api.G_RET_STS_ERROR ;

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 ;
2414: FND_MSG_PUB.Count_And_Get
2415: ( p_count => x_msg_count ,
2416: p_data => x_msg_data
2417: );

Line 2421: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2428: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

2424: UPDATE ego_item_associations_intf
2425: SET process_flag = G_REC_UNEXPECTED_ERROR
2426: WHERE batch_id = p_batch_id
2427: AND process_flag = G_REC_TO_BE_PROCESSED;
2428: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2429: FND_MSG_PUB.Count_And_Get
2430: ( p_count => x_msg_count ,
2431: p_data => x_msg_data
2432: );

Line 2443: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

2439: UPDATE ego_item_associations_intf
2440: SET process_flag = G_REC_UNEXPECTED_ERROR
2441: WHERE batch_id = p_batch_id
2442: AND process_flag = G_REC_TO_BE_PROCESSED;
2443: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2444: IF FND_MSG_PUB.Check_Msg_Level
2445: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2446: THEN
2447: FND_MSG_PUB.Add_Exc_Msg

Line 2518: x_return_status := fnd_api.G_RET_STS_SUCCESS;

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
2520: set_globals();
2521: -- Initialize API return status to success
2522: SAVEPOINT copy_to_packs_pub;

Line 2655: WHEN fnd_api.G_EXC_ERROR THEN

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

Line 2657: x_return_status := fnd_api.G_RET_STS_ERROR ;

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 ;
2658: FND_MSG_PUB.Count_And_Get
2659: ( p_count => x_msg_count ,
2660: p_data => x_msg_data
2661: );

Line 2665: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2672: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

2668: UPDATE ego_item_associations_intf
2669: SET process_flag = G_REC_UNEXPECTED_ERROR
2670: WHERE batch_id = p_batch_id
2671: AND process_flag = G_REC_TO_BE_PROCESSED;
2672: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2673: FND_MSG_PUB.Count_And_Get
2674: ( p_count => x_msg_count ,
2675: p_data => x_msg_data
2676: );

Line 2687: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

2683: UPDATE ego_item_associations_intf
2684: SET process_flag = G_REC_UNEXPECTED_ERROR
2685: WHERE batch_id = p_batch_id
2686: AND process_flag = G_REC_TO_BE_PROCESSED;
2687: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2688: IF FND_MSG_PUB.Check_Msg_Level
2689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2690: THEN
2691: FND_MSG_PUB.Add_Exc_Msg