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

Line 1: PACKAGE BODY OE_CUSTOMER_INFO_PVT AS

1: PACKAGE BODY OE_CUSTOMER_INFO_PVT AS
2: /* $Header: OEXVCUSB.pls 120.1 2009/02/27 08:30:38 smanian noship $ */
3:
4: G_PKG_NAME VARCHAR2(100) := 'OE_CUSTOMER_INFO_PVT';
5: G_CREATED_BY_MODULE VARCHAR2(100) := 'ONT_OI_ADD_CUSTOMER';

Line 4: G_PKG_NAME VARCHAR2(100) := 'OE_CUSTOMER_INFO_PVT';

1: PACKAGE BODY OE_CUSTOMER_INFO_PVT AS
2: /* $Header: OEXVCUSB.pls 120.1 2009/02/27 08:30:38 smanian noship $ */
3:
4: G_PKG_NAME VARCHAR2(100) := 'OE_CUSTOMER_INFO_PVT';
5: G_CREATED_BY_MODULE VARCHAR2(100) := 'ONT_OI_ADD_CUSTOMER';
6: G_EMAIL_REQUIRED VARCHAR2(1);
7: G_AUTO_PARTY_NUMBERING VARCHAR2(1);
8: G_AUTO_CUST_NUMBERING VARCHAR2(1);

Line 200: oe_debug_pub.add(' Entering OE_CUSTOMER_INFO_PVT.get_customer_info_ids'||p_customer_info_tbl.count);

196: l_customer_id NUMBER;
197: BEGIN
198:
199: IF l_debug_level > 0 THEN
200: oe_debug_pub.add(' Entering OE_CUSTOMER_INFO_PVT.get_customer_info_ids'||p_customer_info_tbl.count);
201: END IF;
202:
203:
204: Initialize_Global(x_return_status);

Line 1426: oe_debug_pub.add(' Entering OE_CUSTOMER_INFO_PVT.get_customer_info_ids');

1422:
1423:
1424:
1425: IF l_debug_level > 0 THEN
1426: oe_debug_pub.add(' Entering OE_CUSTOMER_INFO_PVT.get_customer_info_ids');
1427: END IF;
1428:
1429:
1430: EXCEPTION

Line 1435: oe_debug_pub.add('OE_CUSTOMER_INFO_PVT.get_customer_info_ids : Other Errors :'||SQLERRM);

1431:
1432: WHEN OTHERS THEN
1433:
1434: IF l_debug_level > 0 THEN
1435: oe_debug_pub.add('OE_CUSTOMER_INFO_PVT.get_customer_info_ids : Other Errors :'||SQLERRM);
1436: END IF;
1437:
1438: x_return_status := FND_API.G_RET_STS_ERROR;
1439:

Line 1484: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Create_account');

1480:
1481: BEGIN
1482:
1483: IF l_debug_level > 0 THEN
1484: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Create_account');
1485: END IF;
1486:
1487: x_return_status := FND_API.G_RET_STS_SUCCESS;
1488: l_customer_info_rec := p_header_customer_info_rec;

Line 1715: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Create_relationships ');

1711: l_rel_flag VARCHAR2(1);
1712: BEGIN
1713:
1714: IF l_debug_level > 0 THEN
1715: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Create_relationships ');
1716: END IF;
1717:
1718: x_return_status := FND_API.G_RET_STS_SUCCESS;
1719:

Line 1811: oe_debug_pub.add('Exiting OE_CUSTOMER_INFO_PVT.Create_relationships ');

1807:
1808: END IF;
1809:
1810: IF l_debug_level > 0 THEN
1811: oe_debug_pub.add('Exiting OE_CUSTOMER_INFO_PVT.Create_relationships ');
1812: END IF;
1813:
1814: Exception
1815: WHEN OTHERS THEN

Line 1827: oe_debug_pub.add('Unexpected error in OE_CUSTOMER_INFO_PVT.Create_relationships '||SQLERRM);

1823: );
1824: END IF;
1825:
1826: IF l_debug_level > 0 THEN
1827: oe_debug_pub.add('Unexpected error in OE_CUSTOMER_INFO_PVT.Create_relationships '||SQLERRM);
1828: END IF;
1829:
1830: End Create_relationships;
1831:

Line 1859: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Create_Party_Site');

1855:
1856: x_return_status := FND_API.G_RET_STS_SUCCESS;
1857:
1858: IF l_debug_level > 0 THEN
1859: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Create_Party_Site');
1860: END IF;
1861:
1862:
1863: IF l_debug_level > 0 then

Line 1973: oe_debug_pub.add('Exiting OE_CUSTOMER_INFO_PVT.Create_Party_Site');

1969: END IF;
1970:
1971:
1972: IF l_debug_level > 0 THEN
1973: oe_debug_pub.add('Exiting OE_CUSTOMER_INFO_PVT.Create_Party_Site');
1974: END IF;
1975:
1976:
1977: EXCEPTION

Line 1982: oe_debug_pub.add('Unexpected error in OE_CUSTOMER_INFO_PVT.Create_Party_Site '||SQLERRM);

1978: WHEN OTHERS THEN
1979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1980:
1981: IF l_debug_level > 0 THEN
1982: oe_debug_pub.add('Unexpected error in OE_CUSTOMER_INFO_PVT.Create_Party_Site '||SQLERRM);
1983: END IF;
1984:
1985: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1986: THEN

Line 2021: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Create_Cust_Account_Site');

2017:
2018: x_return_status := FND_API.G_RET_STS_SUCCESS;
2019:
2020: IF l_debug_level > 0 THEN
2021: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Create_Cust_Account_Site');
2022: END IF;
2023:
2024: IF l_debug_level > 0 THEN
2025: oe_debug_pub.add('Step 3:Create Account Site');

Line 2067: oe_debug_pub.add('Exiting OE_CUSTOMER_INFO_PVT.Create_Cust_Account_Site');

2063: oe_debug_pub.add('End of Step 3:Create Account_Site :x_cust_account_site_id:'||x_cust_account_site_id);
2064: END IF;
2065:
2066: IF l_debug_level > 0 THEN
2067: oe_debug_pub.add('Exiting OE_CUSTOMER_INFO_PVT.Create_Cust_Account_Site');
2068: END IF;
2069:
2070:
2071: EXCEPTION

Line 2076: oe_debug_pub.add('Unexpected error in OE_CUSTOMER_INFO_PVT.Create_Cust_Account_Site '||SQLERRM);

2072: WHEN OTHERS THEN
2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2074:
2075: IF l_debug_level > 0 THEN
2076: oe_debug_pub.add('Unexpected error in OE_CUSTOMER_INFO_PVT.Create_Cust_Account_Site '||SQLERRM);
2077: END IF;
2078:
2079: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2080: THEN

Line 2108: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Create_Acct_Site_Uses');

2104: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2105:
2106: BEGIN
2107: IF l_debug_level > 0 THEN
2108: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Create_Acct_Site_Uses');
2109: END IF;
2110:
2111:
2112: l_acct_site_uses.cust_acct_site_id := p_cust_acct_site_id;

Line 2143: oe_debug_pub.add('Exiting OE_CUSTOMER_INFO_PVT.Create_Acct_Site_Uses');

2139: END IF;
2140:
2141:
2142: IF l_debug_level > 0 THEN
2143: oe_debug_pub.add('Exiting OE_CUSTOMER_INFO_PVT.Create_Acct_Site_Uses');
2144: END IF;
2145:
2146: EXCEPTION
2147: WHEN OTHERS THEN

Line 2151: oe_debug_pub.add('Unexpected error in OE_CUSTOMER_INFO_PVT.Create_Acct_Site_Uses '||SQLERRM);

2147: WHEN OTHERS THEN
2148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2149:
2150: IF l_debug_level > 0 THEN
2151: oe_debug_pub.add('Unexpected error in OE_CUSTOMER_INFO_PVT.Create_Acct_Site_Uses '||SQLERRM);
2152: END IF;
2153:
2154: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2155: THEN

Line 2188: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Check_Party_Site_Exists : p_party_id'||p_party_id);

2184:
2185: x_party_site_id := FND_API.G_MISS_NUM;
2186:
2187: IF l_debug_level > 0 THEN
2188: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Check_Party_Site_Exists : p_party_id'||p_party_id);
2189: END IF;
2190:
2191:
2192: FOR i in party_location LOOP

Line 2248: oe_debug_pub.add('Exiting OE_CUSTOMER_INFO_PVT.Check_Party_Site_Exists');

2244:
2245:
2246: IF l_debug_level > 0 THEN
2247: oe_debug_pub.add(' No Match found :x_party_site_id :'||x_party_site_id);
2248: oe_debug_pub.add('Exiting OE_CUSTOMER_INFO_PVT.Check_Party_Site_Exists');
2249: END IF;
2250:
2251: EXCEPTION
2252: WHEN OTHERS THEN

Line 2272: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Check_Cust_Site_Exists');

2268: BEGIN
2269:
2270:
2271: IF l_debug_level > 0 THEN
2272: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Check_Cust_Site_Exists');
2273: END IF;
2274:
2275: x_cust_acct_site_id := FND_API.G_MISS_NUM;
2276:

Line 2288: oe_debug_pub.add('Exiting OE_CUSTOMER_INFO_PVT.Check_Cust_Site_Exists');

2284:
2285:
2286: IF l_debug_level > 0 THEN
2287: oe_debug_pub.add('x_cust_acct_site_id :'||x_cust_acct_site_id);
2288: oe_debug_pub.add('Exiting OE_CUSTOMER_INFO_PVT.Check_Cust_Site_Exists');
2289: END IF;
2290:
2291: EXCEPTION
2292: WHEN OTHERS THEN

Line 2308: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Get_Location_id');

2304: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2305: BEGIN
2306:
2307: IF l_debug_level > 0 THEN
2308: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Get_Location_id');
2309: END IF;
2310:
2311:
2312: SELECT loc.location_id

Line 2331: oe_debug_pub.add(' OTHER ERROERS IN OE_CUSTOMER_INFO_PVT.Get_Location_id'|| SQLERRM);

2327:
2328: EXCEPTION
2329: WHEN OTHERS THEN
2330: IF l_debug_level > 0 THEN
2331: oe_debug_pub.add(' OTHER ERROERS IN OE_CUSTOMER_INFO_PVT.Get_Location_id'|| SQLERRM);
2332: END IF;
2333:
2334: RETURN NULL;
2335: END Get_Location_id;

Line 2392: oe_debug_pub.add('Entering procedure OE_CUSTOMER_INFO_PVT.Create_Addresses');

2388:
2389: x_return_status := FND_API.G_RET_STS_SUCCESS;
2390:
2391: IF l_debug_level > 0 THEN
2392: oe_debug_pub.add('Entering procedure OE_CUSTOMER_INFO_PVT.Create_Addresses');
2393: oe_debug_pub.add('p_address_usage:'||p_address_usage);
2394: END IF;
2395:
2396: l_addr_rec := p_customer_info_tbl(p_address_rec_index);

Line 2666: oe_debug_pub.add('Exiting procedure OE_CUSTOMER_INFO_PVT.Create_Addresses');

2662:
2663:
2664:
2665: IF l_debug_level > 0 THEN
2666: oe_debug_pub.add('Exiting procedure OE_CUSTOMER_INFO_PVT.Create_Addresses');
2667: END IF;
2668:
2669: EXCEPTION
2670: WHEN OTHERS THEN

Line 2819: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Check_Duplicate_Customer');

2815: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2816: BEGIN
2817:
2818: IF l_debug_level >0 THEN
2819: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Check_Duplicate_Customer');
2820: END IF;
2821: x_customer_id := FND_API.G_MISS_NUM;
2822:
2823: IF p_customer_record.customer_type = 'ORGANIZATION' THEN

Line 2853: oe_debug_pub.add('Exiting OE_CUSTOMER_INFO_PVT.Check_Duplicate_Customer :'||x_customer_id);

2849: END IF;
2850:
2851:
2852: IF l_debug_level >0 THEN
2853: oe_debug_pub.add('Exiting OE_CUSTOMER_INFO_PVT.Check_Duplicate_Customer :'||x_customer_id);
2854: END IF;
2855:
2856: EXCEPTION
2857: WHEN OTHERS THEN

Line 2859: oe_debug_pub.add('Other errors in OE_CUSTOMER_INFO_PVT.Check_Duplicate_Customer :'||SQLERRM);

2855:
2856: EXCEPTION
2857: WHEN OTHERS THEN
2858: IF l_debug_level >0 THEN
2859: oe_debug_pub.add('Other errors in OE_CUSTOMER_INFO_PVT.Check_Duplicate_Customer :'||SQLERRM);
2860: END IF;
2861:
2862: END Check_Duplicate_Customer;
2863:

Line 3280: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Update_Customer ');

3276:
3277: x_return_status := FND_API.G_RET_STS_SUCCESS;
3278:
3279: IF l_debug_level > 0 THEN
3280: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Update_Customer ');
3281: END IF;
3282:
3283: IF NOT IS_VALID_ID ( p_customer_id => p_customer_rec.customer_id ) THEN
3284: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3411: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Update_Customer ');

3407: IF l_debug_level > 0 THEN
3408: oe_debug_pub.add('Update_Customer :x_return_status:'||x_return_status);
3409: oe_debug_pub.add('Update_Customer:x_msg_count:'||x_msg_count);
3410: oe_debug_pub.add('Update_Customer :x_msg_data:'||x_msg_data);
3411: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Update_Customer ');
3412: END IF;
3413:
3414: EXCEPTION
3415: WHEN OTHERS THEN

Line 3886: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Update_Contact ');

3882: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3883: BEGIN
3884:
3885: IF l_debug_level > 0 THEN
3886: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Update_Contact ');
3887: END IF;
3888: begin
3889:
3890: SELECT party.party_id,REL_PARTY.party_id

Line 3995: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Update_Contact ');

3991: IF l_debug_level > 0 THEN
3992: oe_debug_pub.add('Update_Contact :x_return_status:'||x_return_status);
3993: oe_debug_pub.add('Update_Contact :x_msg_count:'||x_msg_count);
3994: oe_debug_pub.add('Update_Contact :x_msg_data:'||x_msg_data);
3995: oe_debug_pub.add('Entering OE_CUSTOMER_INFO_PVT.Update_Contact ');
3996: END IF;
3997:
3998: EXCEPTION
3999: WHEN OTHERS THEN

Line 4017: END OE_CUSTOMER_INFO_PVT;

4013:
4014:
4015: END Update_Contact;
4016:
4017: END OE_CUSTOMER_INFO_PVT;