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

Line 1: PACKAGE BODY IBE_ADDRESS_V2PVT AS

1: PACKAGE BODY IBE_ADDRESS_V2PVT AS
2: /* $Header: IBEVADB.pls 120.9 2006/01/09 00:59:56 banatara ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_ADDRESS_V2PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_ADDRESS_V2PVT';

1: PACKAGE BODY IBE_ADDRESS_V2PVT AS
2: /* $Header: IBEVADB.pls 120.9 2006/01/09 00:59:56 banatara ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_ADDRESS_V2PVT';
6: l_true VARCHAR2(1) := FND_API.G_TRUE;
7:
8:
9: ----------------- private procedures -----------------------------------------

Line 91: IBE_UTIL.debug('enter IBE_ADDRESS_V2PVT.create_address');

87:
88: --IBE_UTIL.enable_debug();
89:
90: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
91: IBE_UTIL.debug('enter IBE_ADDRESS_V2PVT.create_address');
92: END IF;
93:
94: -- standard start of API savepoint
95: SAVEPOINT create_address_pvt;

Line 167: IBE_UTIL.debug('exit IBE_ADDRESS_V2PVT.create_address');

163: p_data => x_msg_data
164: );
165:
166: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
167: IBE_UTIL.debug('exit IBE_ADDRESS_V2PVT.create_address');
168: END IF;
169:
170: --IBE_UTIL.disable_debug();
171:

Line 287: IBE_UTIL.debug('enter IBE_ADDRESS_V2PVT.update_address');

283:
284: --IBE_UTIL.enable_debug();
285:
286: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
287: IBE_UTIL.debug('enter IBE_ADDRESS_V2PVT.update_address');
288: END IF;
289:
290: -- standard start of API savepoint
291: SAVEPOINT update_address_pvt;

Line 484: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.update_address, location changed but no PS change');

480:
481: ELSIF l_loc_changed = true and l_ps_changed = false THEN
482:
483: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
484: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.update_address, location changed but no PS change');
485: END IF;
486:
487: Open c_get_location_ovn(p_location.location_id);
488: FETCH c_get_location_ovn INTO l_loc_object_version_number;

Line 638: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.delete_address(+)');

634: -- delete an existing party site
635: --
636:
637: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
638: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.delete_address(+)');
639: END IF;
640:
641: do_delete_address(
642: p_api_version,

Line 662: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.delete_address(-)');

658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END IF;
660:
661: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
662: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.delete_address(-)');
663: IBE_UTIL.debug('party_site_id: ' || to_char(p_party_site_id) || ' deleted');
664: END IF;
665:
666:

Line 672: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.do_create_address(+)');

668: -- create a new location and party site
669: --
670:
671: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
672: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.do_create_address(+)');
673: END IF;
674: if l_chk_ps.created_by_module is NULL then
675: l_chk_ps.created_by_module := 'USER MANAGEMENT';
676: end if;

Line 701: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.do_create_address(-)');

697: x_party_site_id
698: );
699:
700: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
701: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.do_create_address(-)');
702: IBE_UTIL.debug('location_id = ' || to_char(x_location_id));
703: IBE_UTIL.debug('party_site_id = ' || to_char(x_party_site_id));
704: END IF;
705:

Line 742: IBE_UTIL.debug('exit IBE_ADDRESS_V2PVT.update_address');

738: p_data => x_msg_data
739: );
740:
741: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
742: IBE_UTIL.debug('exit IBE_ADDRESS_V2PVT.update_address');
743: END IF;
744:
745: --IBE_UTIL.disable_debug();
746:

Line 836: IBE_UTIL.debug('enter IBE_ADDRESS_V2PVT.delete_address');

832:
833: --IBE_UTIL.enable_debug();
834:
835: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
836: IBE_UTIL.debug('enter IBE_ADDRESS_V2PVT.delete_address');
837: END IF;
838:
839: -- standard start of API savepoint
840: SAVEPOINT delete_address_pvt;

Line 861: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.delete_address(+)');

857: -- delete the address
858: --
859:
860: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
861: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.delete_address(+)');
862: END IF;
863:
864: do_delete_address(
865: p_api_version,

Line 885: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.do_delete_address(-)');

881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
882: END IF;
883:
884: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
885: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.do_delete_address(-)');
886: IBE_UTIL.debug('party_site_id: ' || to_char(p_party_site_id) || ' deleted');
887: END IF;
888:
889:

Line 927: IBE_UTIL.debug('exit IBE_ADDRESS_V2PVT.delete_address');

923: p_data => x_msg_data
924: );
925:
926: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
927: IBE_UTIL.debug('exit IBE_ADDRESS_V2PVT.delete_address');
928: END IF;
929:
930: --IBE_UTIL.disable_debug();
931:

Line 1034: IBE_UTIL.debug('enter IBE_ADDRESS_V2PVT.set_primary_address');

1030:
1031: --IBE_UTIL.enable_debug();
1032:
1033: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1034: IBE_UTIL.debug('enter IBE_ADDRESS_V2PVT.set_primary_address');
1035: END IF;
1036:
1037: -- standard start of API savepoint
1038: SAVEPOINT set_address__usage_pvt;

Line 1135: IBE_UTIL.debug('exit IBE_ADDRESS_V2PVT.set_primary_address');

1131: p_data => x_msg_data
1132: );
1133:
1134: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1135: IBE_UTIL.debug('exit IBE_ADDRESS_V2PVT.set_primary_address');
1136: END IF;
1137:
1138: --IBE_UTIL.disable_debug();
1139:

Line 1374: IBE_UTIL.debug('enter IBE_ADDRESS_V2PVT.get_primary_addr_id for party_id'||p_party_id);

1370:
1371: --IBE_UTIL.enable_debug();
1372:
1373: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1374: IBE_UTIL.debug('enter IBE_ADDRESS_V2PVT.get_primary_addr_id for party_id'||p_party_id);
1375: END IF;
1376:
1377:
1378:

Line 1478: IBE_UTIL.debug('exit IBE_ADDRESS_V2PVT.get_primary_address');

1474: );
1475:
1476: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1477: IBE_UTIL.debug('Ending getPrimary Addr with party_site_id '||x_party_site_id);
1478: IBE_UTIL.debug('exit IBE_ADDRESS_V2PVT.get_primary_address');
1479: END IF;
1480:
1481: --IBE_UTIL.disable_debug();
1482:

Line 1527: IBE_UTIL.debug('enter IBE_ADDRESS_V2PVT.get_primary_address');

1523:
1524: --IBE_UTIL.enable_debug();
1525:
1526: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1527: IBE_UTIL.debug('enter IBE_ADDRESS_V2PVT.get_primary_address');
1528: END IF;
1529:
1530: -- standard start of API savepoint
1531: SAVEPOINT get_primary_address_pvt;

Line 1588: IBE_UTIL.debug('exit IBE_ADDRESS_V2PVT.get_primary_address');

1584: p_data => x_msg_data
1585: );
1586:
1587: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1588: IBE_UTIL.debug('exit IBE_ADDRESS_V2PVT.get_primary_address');
1589: END IF;
1590:
1591: --IBE_UTIL.disable_debug();
1592:

Line 1655: IBE_UTIL.debug('enter IBE_ADDRESS_V2PVT.do_create_address');

1651:
1652: BEGIN
1653:
1654: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1655: IBE_UTIL.debug('enter IBE_ADDRESS_V2PVT.do_create_address');
1656: END IF;
1657:
1658: --
1659: -- create a location

Line 1804: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.get_primary_address(+)');

1800:
1801: -- check primary billing address
1802:
1803: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1804: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.get_primary_address(+)');
1805: END IF;
1806:
1807: IBE_ADDRESS_V2PVT.get_primary_address(
1808: p_api_version,

Line 1807: IBE_ADDRESS_V2PVT.get_primary_address(

1803: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1804: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.get_primary_address(+)');
1805: END IF;
1806:
1807: IBE_ADDRESS_V2PVT.get_primary_address(
1808: p_api_version,
1809: p_init_msg_list,
1810: p_commit,
1811: l_party_site.party_id,

Line 1827: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.get_primary_address(-)');

1823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1824: END IF;
1825:
1826: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1827: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.get_primary_address(-)');
1828: IBE_UTIL.debug('l_prim_site_id = ' || l_prim_site_id);
1829: END IF;
1830:
1831: IF (l_prim_site_id = -1) THEN

Line 1839: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.get_primary_address(+)');

1835:
1836: -- check primary shipping address
1837:
1838: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1839: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.get_primary_address(+)');
1840: END IF;
1841:
1842: IBE_ADDRESS_V2PVT.get_primary_address(
1843: p_api_version,

Line 1842: IBE_ADDRESS_V2PVT.get_primary_address(

1838: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1839: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.get_primary_address(+)');
1840: END IF;
1841:
1842: IBE_ADDRESS_V2PVT.get_primary_address(
1843: p_api_version,
1844: p_init_msg_list,
1845: p_commit,
1846: l_party_site.party_id,

Line 1862: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.get_primary_address(-)');

1858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1859: END IF;
1860:
1861: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1862: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.get_primary_address(-)');
1863: IBE_UTIL.debug('l_prim_site_id = ' || l_prim_site_id);
1864: END IF;
1865:
1866: IF (l_prim_site_id = -1) THEN

Line 1881: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.set_primary_address(+) for BILL_TO');

1877:
1878: IF (l_primary_billto = FND_API.G_TRUE OR p_billto = FND_API.G_TRUE)THEN
1879:
1880: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1881: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.set_primary_address(+) for BILL_TO');
1882: END IF;
1883: l_createdby := l_location.created_by_module;
1884: IBE_ADDRESS_V2PVT.set_address_usage(
1885: p_api_version,

Line 1884: IBE_ADDRESS_V2PVT.set_address_usage(

1880: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1881: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.set_primary_address(+) for BILL_TO');
1882: END IF;
1883: l_createdby := l_location.created_by_module;
1884: IBE_ADDRESS_V2PVT.set_address_usage(
1885: p_api_version,
1886: p_init_msg_list,
1887: P_commit,
1888: x_party_site_id,

Line 1905: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.set_primary_address(-)');

1901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1902: END IF;
1903:
1904: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1905: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.set_primary_address(-)');
1906: IBE_UTIL.debug('party_site_use_id = ' || l_party_site_use_id);
1907: END IF;
1908:
1909: END IF;

Line 1914: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.set_primary_address(+) for SHIP_TO');

1910:
1911: IF (l_primary_shipto = FND_API.G_TRUE OR p_shipto = FND_API.G_TRUE) THEN
1912: l_createdby := l_location.created_by_module;
1913: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1914: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.set_primary_address(+) for SHIP_TO');
1915: END IF;
1916: IBE_ADDRESS_V2PVT.set_address_usage(
1917: p_api_version,
1918: p_init_msg_list,

Line 1916: IBE_ADDRESS_V2PVT.set_address_usage(

1912: l_createdby := l_location.created_by_module;
1913: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1914: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.set_primary_address(+) for SHIP_TO');
1915: END IF;
1916: IBE_ADDRESS_V2PVT.set_address_usage(
1917: p_api_version,
1918: p_init_msg_list,
1919: P_commit,
1920: x_party_site_id,

Line 1937: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.set_address_usage(-)');

1933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1934: END IF;
1935:
1936: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1937: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.set_address_usage(-)');
1938: IBE_UTIL.debug('party_site_use_id = ' || l_party_site_use_id);
1939: END IF;
1940:
1941: END IF;

Line 2005: IBE_UTIL.debug('exit IBE_ADDRESS_V2PVT.do_create_address');

2001: IBE_UTIL.debug('loc_id = ' || to_char(l_loc_id));
2002: END IF;
2003:
2004: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2005: IBE_UTIL.debug('exit IBE_ADDRESS_V2PVT.do_create_address');
2006: END IF;
2007:
2008: END;
2009:

Line 2042: IBE_UTIL.debug('enter IBE_ADDRESS_V2PVT.do_delete_address');

2038:
2039: BEGIN
2040:
2041: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2042: IBE_UTIL.debug('enter IBE_ADDRESS_V2PVT.do_delete_address');
2043: END IF;
2044:
2045: --
2046: -- update party site

Line 2106: IBE_UTIL.debug('exit IBE_ADDRESS_V2PVT.do_delete_address');

2102: END IF;
2103:
2104: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2105: IBE_UTIL.debug('hz_party_v2pub.update_party_site(-)');
2106: IBE_UTIL.debug('exit IBE_ADDRESS_V2PVT.do_delete_address');
2107: END IF;
2108:
2109: END;
2110:

Line 2476: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.copy_pary_site:Begin ');

2472:
2473: BEGIN
2474:
2475: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2476: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.copy_pary_site:Begin ');
2477: END IF;
2478: /*PROCEDURE create_party_site (
2479: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2480: p_party_site_rec IN PARTY_SITE_REC_TYPE,

Line 2500: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.copy_pary_site:Expected error ');

2496: x_msg_data => x_msg_data );
2497:
2498: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2499: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2500: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.copy_pary_site:Expected error ');
2501: END IF;
2502:
2503: RAISE FND_API.G_EXC_ERROR;
2504: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2506: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.copy_pary_site:Unexpected error ');

2502:
2503: RAISE FND_API.G_EXC_ERROR;
2504: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2505: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2506: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.copy_pary_site:Unexpected error ');
2507: END IF;
2508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2509: END IF;
2510:

Line 2512: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.copy_pary_site:Done ');

2508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2509: END IF;
2510:
2511: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2512: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.copy_pary_site:Done ');
2513: IBE_UTIL.debug('party_site_id = ' || x_party_site_id);
2514: END IF;
2515:
2516: x_party_site_id := l_party_site_id;

Line 2522: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.copy_pary_site:In the expected exception block ');

2518: EXCEPTION
2519:
2520: WHEN FND_API.G_EXC_ERROR THEN
2521: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2522: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.copy_pary_site:In the expected exception block ');
2523: END IF;
2524:
2525: x_return_status := FND_API.G_RET_STS_ERROR;
2526: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 2540: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.copy_pary_site:In the unexpected exception block ');

2536:
2537:
2538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2539: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2540: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.copy_pary_site:In the unexpected exception block ');
2541: END IF;
2542:
2543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2544: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 2558: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.copy_pary_site:In the others exception block ');

2554:
2555:
2556: WHEN OTHERS THEN
2557: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2558: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.copy_pary_site:In the others exception block ');
2559: END IF;
2560:
2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2562:

Line 2582: END IBE_ADDRESS_V2PVT;

2578:
2579: END;
2580:
2581:
2582: END IBE_ADDRESS_V2PVT;