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_CUSTOMER_ACCT_PVT dependencies on IBE_CUSTOMER_ACCT_PVT

Line 1: PACKAGE BODY IBE_CUSTOMER_ACCT_PVT AS

1: PACKAGE BODY IBE_CUSTOMER_ACCT_PVT AS
2: /* $Header: IBEVCACB.pls 120.4 2006/01/24 23:21:26 susinha ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_CUSTOMER_ACCT_PVT';
5: l_true VARCHAR2(1) := FND_API.G_TRUE;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_CUSTOMER_ACCT_PVT';

1: PACKAGE BODY IBE_CUSTOMER_ACCT_PVT AS
2: /* $Header: IBEVCACB.pls 120.4 2006/01/24 23:21:26 susinha ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_CUSTOMER_ACCT_PVT';
5: l_true VARCHAR2(1) := FND_API.G_TRUE;
6:
7: PROCEDURE GetPartySiteId(
8: p_api_version_number IN NUMBER,

Line 108: Ibe_Util.debug('Begin IBE_CUSTOMER_ACCT_PVT:GetPartySiteId');

104:
105: BEGIN
106:
107: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
108: Ibe_Util.debug('Begin IBE_CUSTOMER_ACCT_PVT:GetPartySiteId');
109: END IF;
110:
111: -- Standard Start of API savepoint
112: SAVEPOINT CUSTACCT_GETPARTYSITEID;

Line 170: Ibe_Util.debug('End IBE_CUSTOMER_ACCT_PVT:GetPartySiteId');

166: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
167: p_data => x_msg_data);
168:
169: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
170: Ibe_Util.debug('End IBE_CUSTOMER_ACCT_PVT:GetPartySiteId');
171: END IF;
172:
173: EXCEPTION
174: WHEN FND_API.G_EXC_ERROR THEN

Line 181: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:GetPartySiteId()'|| sqlerrm);

177: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
178: p_count => x_msg_count ,
179: p_data => x_msg_data);
180: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
181: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:GetPartySiteId()'|| sqlerrm);
182: END IF;
183:
184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
185: ROLLBACK TO CUSTACCT_GETPARTYSITEID;

Line 191: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:GetPartySiteId()' || sqlerrm);

187: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
188: p_count => x_msg_count ,
189: p_data => x_msg_data);
190: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
191: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:GetPartySiteId()' || sqlerrm);
192: END IF;
193:
194: WHEN OTHERS THEN
195: ROLLBACK TO CUSTACCT_GETPARTYSITEID;

Line 205: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:GetPartySiteId' || sqlerrm);

201: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
202: p_count => x_msg_count ,
203: p_data => x_msg_data);
204: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
205: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:GetPartySiteId' || sqlerrm);
206: END IF;
207:
208: END GetPartySiteId;
209:

Line 236: Ibe_Util.debug('Begin IBE_CUSTOMER_ACCT_PVT:Create_Party_Site_Use');

232:
233: BEGIN
234:
235: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
236: Ibe_Util.debug('Begin IBE_CUSTOMER_ACCT_PVT:Create_Party_Site_Use');
237: Ibe_Util.debug('create_pty_site_use:before create_pty_site_use:p_party_site_id: ' || p_party_site_id);
238: Ibe_Util.debug('create_pty_site_use:before create_pty_site_use:p_party_site_use_type: ' || p_party_site_use_type);
239: END IF;
240:

Line 290: Ibe_Util.debug('End IBE_CUSTOMER_ACCT_PVT:Create_Party_Site_Use');

286: RAISE FND_API.G_EXC_ERROR;
287: END IF;
288:
289: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
290: Ibe_Util.debug('End IBE_CUSTOMER_ACCT_PVT:Create_Party_Site_Use');
291: ENd IF;
292:
293: --
294: -- End of API body

Line 315: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:Create_Party_Site_Use'|| sqlerrm);

311: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
312: p_count => x_msg_count ,
313: p_data => x_msg_data);
314: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
315: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:Create_Party_Site_Use'|| sqlerrm);
316: END IF;
317:
318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
319: ROLLBACK TO CUSTACCT_CREATEPARTYSITEUSE;

Line 325: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:Create_Party_Site_Use' || sqlerrm);

321: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
322: p_count => x_msg_count ,
323: p_data => x_msg_data);
324: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
325: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:Create_Party_Site_Use' || sqlerrm);
326: END IF;
327:
328: WHEN OTHERS THEN
329: ROLLBACK TO CUSTACCT_CREATEPARTYSITEUSE;

Line 339: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:Create_Party_Site_Use' || sqlerrm);

335: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
336: p_count => x_msg_count ,
337: p_data => x_msg_data);
338: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
339: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:Create_Party_Site_Use' || sqlerrm);
340: END IF;
341: END Create_Party_Site_Use;
342: */
343:

Line 384: Ibe_Util.debug('BEgin IBE_CUSTOMER_ACCT_PVT:create_cust_account_role');

380:
381: BEGIN
382:
383: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
384: Ibe_Util.debug('BEgin IBE_CUSTOMER_ACCT_PVT:create_cust_account_role');
385: END IF;
386:
387: -- Standard Start of API savepoint
388: SAVEPOINT CUSTACCT_CREATCUSTACCTROLE;

Line 507: IBE_Util.debug('End IBE_CUSTOMER_ACCT_PVT:create_cust_account_role');

503: COMMIT WORK;
504: END IF;
505:
506: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
507: IBE_Util.debug('End IBE_CUSTOMER_ACCT_PVT:create_cust_account_role');
508: END IF;
509:
510: -- Standard call to get message count and if count is 1, get message info.
511: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 523: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:create_cust_account_role()'|| sqlerrm);

519: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
520: p_count => x_msg_count ,
521: p_data => x_msg_data);
522: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
523: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:create_cust_account_role()'|| sqlerrm);
524: END IF;
525:
526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
527: ROLLBACK TO CUSTACCT_CREATCUSTACCTROLE;

Line 533: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:create_cust_account_role' || sqlerrm);

529: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
530: p_count => x_msg_count ,
531: p_data => x_msg_data);
532: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
533: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:create_cust_account_role' || sqlerrm);
534: END IF;
535:
536: WHEN OTHERS THEN
537: ROLLBACK TO CUSTACCT_CREATCUSTACCTROLE;

Line 548: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:create_cust_account_role)' || sqlerrm);

544: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
545: p_count => x_msg_count ,
546: p_data => x_msg_data);
547: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
548: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:create_cust_account_role)' || sqlerrm);
549: END IF;
550:
551: ENd create_cust_account_role;
552:

Line 587: IBE_Util.debug('Begin IBE_CUSTOMER_ACCT_PVT:Create_Cust_Acct_Site ');

583:
584: BEGIN
585:
586: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
587: IBE_Util.debug('Begin IBE_CUSTOMER_ACCT_PVT:Create_Cust_Acct_Site ');
588: IBE_Util.debug('Create_Cust_Acct_Site: '||p_custacct_type||' : ' ||p_partysite_id);
589: END IF;
590:
591: -- Standard Start of API savepoint

Line 670: IBE_Util.debug('End IBE_CUSTOMER_ACCT_PVT: Create_Cust_Acct_Site custacct_site_id: '||x_custacct_site_id);

666: p_data => x_msg_data);
667:
668:
669: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
670: IBE_Util.debug('End IBE_CUSTOMER_ACCT_PVT: Create_Cust_Acct_Site custacct_site_id: '||x_custacct_site_id);
671: END IF;
672:
673: EXCEPTION
674: WHEN FND_API.G_EXC_ERROR THEN

Line 681: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT: Create_Cust_Acct_Site()'|| sqlerrm);

677: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
678: p_count => x_msg_count ,
679: p_data => x_msg_data);
680: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
681: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT: Create_Cust_Acct_Site()'|| sqlerrm);
682: END IF;
683:
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: ROLLBACK TO CUSTACCT_CREATCUSTACCTSITE;

Line 691: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT: Create_Cust_Acct_Site()' || sqlerrm);

687: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
688: p_count => x_msg_count ,
689: p_data => x_msg_data);
690: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
691: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT: Create_Cust_Acct_Site()' || sqlerrm);
692: END IF;
693:
694: WHEN OTHERS THEN
695: ROLLBACK TO CUSTACCT_CREATCUSTACCTSITE;

Line 706: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT: Create_Cust_Acct_Site()' || sqlerrm);

702: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
703: p_count => x_msg_count ,
704: p_data => x_msg_data);
705: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
706: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT: Create_Cust_Acct_Site()' || sqlerrm);
707: END IF;
708:
709: END Create_Cust_Acct_Site;
710:

Line 767: Ibe_util.Debug('Begin IBE_CUSTOMER_ACCT_PVT:Create_Cust_Acct_Site_Use ' );

763:
764: BEGIN
765:
766: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
767: Ibe_util.Debug('Begin IBE_CUSTOMER_ACCT_PVT:Create_Cust_Acct_Site_Use ' );
768: Ibe_util.Debug('p_acct_site_type: ' || p_acct_site_type);
769: END IF;
770:
771:

Line 919: Ibe_util.Debug('End IBE_CUSTOMER_ACCT_PVT:Create_Cust_Acct_Site_Use');

915: p_data => x_msg_data);
916:
917:
918: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
919: Ibe_util.Debug('End IBE_CUSTOMER_ACCT_PVT:Create_Cust_Acct_Site_Use');
920: END IF;
921:
922: EXCEPTION
923: WHEN FND_API.G_EXC_ERROR THEN

Line 930: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:Create_Cust_Acct_Site_Use()'|| sqlerrm);

926: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
927: p_count => x_msg_count,
928: p_data => x_msg_data);
929: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
930: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:Create_Cust_Acct_Site_Use()'|| sqlerrm);
931: END IF;
932:
933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
934: ROLLBACK TO CUSTACCT_CREATCUSTACCTSITEUSE;

Line 940: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:Create_Cust_Acct_Site_Use()' || sqlerrm);

936: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
937: p_count => x_msg_count ,
938: p_data => x_msg_data);
939: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
940: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:Create_Cust_Acct_Site_Use()' || sqlerrm);
941: END IF;
942:
943: WHEN OTHERS THEN
944: ROLLBACK TO CUSTACCT_CREATCUSTACCTSITEUSE;

Line 955: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:Create_Cust_Acct_Site_Use()' || sqlerrm);

951: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
952: p_count => x_msg_count ,
953: p_data => x_msg_data);
954: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
955: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:Create_Cust_Acct_Site_Use()' || sqlerrm);
956: END IF;
957:
958: END Create_Cust_Acct_Site_Use ;
959:

Line 1014: Ibe_util.Debug('Begin IBE_CUSTOMER_ACCT_PVT:Get_Cust_Account_Site_Use: ' || p_partysite_id );

1010:
1011: BEGIN
1012:
1013: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1014: Ibe_util.Debug('Begin IBE_CUSTOMER_ACCT_PVT:Get_Cust_Account_Site_Use: ' || p_partysite_id );
1015: END IF;
1016:
1017: -- Standard Start of API savepoint
1018: SAVEPOINT CUSTACCT_CUSTACCTSITEUSE;

Line 1224: Ibe_util.Debug('End IBE_CUSTOMER_ACCT_PVT:Get_Cust_Account_Site_Use');

1220: p_data => x_msg_data);
1221:
1222:
1223: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1224: Ibe_util.Debug('End IBE_CUSTOMER_ACCT_PVT:Get_Cust_Account_Site_Use');
1225: END IF;
1226:
1227: EXCEPTION
1228: WHEN FND_API.G_EXC_ERROR THEN

Line 1234: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:Get_Cust_Account_Site_Use()'|| sqlerrm);

1230: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1231: p_count => x_msg_count,
1232: p_data => x_msg_data);
1233: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1234: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:Get_Cust_Account_Site_Use()'|| sqlerrm);
1235: END IF;
1236:
1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1243: IBE_Util.Debug('UnexError IBE_CUSTOMER_ACCT_PVT:Get_Cust_Account_Site_Use()'|| sqlerrm);

1239: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1240: p_count => x_msg_count,
1241: p_data => x_msg_data);
1242: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1243: IBE_Util.Debug('UnexError IBE_CUSTOMER_ACCT_PVT:Get_Cust_Account_Site_Use()'|| sqlerrm);
1244: END IF;
1245:
1246: WHEN OTHERS THEN
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1252: IBE_Util.Debug('Others IBE_CUSTOMER_ACCT_PVT:Get_Cust_Account_Site_Use()'|| sqlerrm);

1248: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1249: p_count => x_msg_count,
1250: p_data => x_msg_data);
1251: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1252: IBE_Util.Debug('Others IBE_CUSTOMER_ACCT_PVT:Get_Cust_Account_Site_Use()'|| sqlerrm);
1253: END IF;
1254:
1255: END Get_Cust_Account_Site_Use;
1256:

Line 1308: Ibe_util.Debug('Begin IBE_CUSTOMER_ACCT_PVT:Get_Cust_Acct_Role');

1304:
1305: BEGIN
1306:
1307: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1308: Ibe_util.Debug('Begin IBE_CUSTOMER_ACCT_PVT:Get_Cust_Acct_Role');
1309: Ibe_util.Debug('Get_Cust_Acct_Role partyId, soldtoorgid: '||p_party_id||' : '|| p_sold_to_orgid);
1310: Ibe_util.Debug('Get_Cust_Acct_Role custacct siteuse id: '||p_custacct_siteuse_id);
1311: END IF;
1312:

Line 1383: Ibe_util.Debug('End IBE_CUSTOMER_ACCT_PVT:Get_Cust_Acct_Role: '||x_cust_acct_role_id);

1379: -- end if;
1380: x_cust_acct_role_id := l_cust_acct_role_id;
1381:
1382: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1383: Ibe_util.Debug('End IBE_CUSTOMER_ACCT_PVT:Get_Cust_Acct_Role: '||x_cust_acct_role_id);
1384: end if;
1385:
1386: --
1387: -- End of API body

Line 1409: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:Get_Cust_Acct_Role()'|| sqlerrm);

1405: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1406: p_count => x_msg_count ,
1407: p_data => x_msg_data);
1408: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1409: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:Get_Cust_Acct_Role()'|| sqlerrm);
1410: END IF;
1411:
1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1413: ROLLBACK TO CUSTACCT_CUSTACCTSITEUSE;

Line 1419: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:Get_Cust_Acct_Role()' || sqlerrm);

1415: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1416: p_count => x_msg_count ,
1417: p_data => x_msg_data);
1418: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1419: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:Get_Cust_Acct_Role()' || sqlerrm);
1420: END IF;
1421:
1422: WHEN OTHERS THEN
1423: ROLLBACK TO CUSTACCT_CUSTACCTSITEUSE;

Line 1434: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:Get_Cust_Acct_Role()' || sqlerrm);

1430: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1431: p_count => x_msg_count ,
1432: p_data => x_msg_data);
1433: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1434: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:Get_Cust_Acct_Role()' || sqlerrm);
1435: END IF;
1436:
1437: END Get_Cust_Acct_Role;
1438:

Line 1554: IBE_Util.Debug('IBE_CUSTOMER_ACCT_PVT:GetCustomerAcctData() -Begin');

1550: -- CustomerName, CutsAcctId,PartySiteId would be sent back.
1551: -- If CustAcctId is coming IN then PartySiteId would not be sent back.
1552:
1553: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1554: IBE_Util.Debug('IBE_CUSTOMER_ACCT_PVT:GetCustomerAcctData() -Begin');
1555: IBE_Util.Debug('p_invoice_to_org_id: ' || p_invoice_to_org_id);
1556: IBE_Util.Debug('p_invoice_to_contact_id: '||p_invoice_to_contact_id);
1557: IBE_Util.Debug('p_contact_party_id: '|| p_contact_party_id);
1558: IBE_Util.Debug('p_cust_account_id: '|| p_cust_account_id);

Line 1684: IBE_Util.Debug('IBE_CUSTOMER_ACCT_PVT:GetCustomerAcctData() -END');

1680: IBE_Util.Debug('l_cntct_email: '|| l_cntct_email);
1681: END IF;
1682:
1683: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1684: IBE_Util.Debug('IBE_CUSTOMER_ACCT_PVT:GetCustomerAcctData() -END');
1685: END If;
1686:
1687: EXCEPTION
1688: WHEN FND_API.G_EXC_ERROR THEN

Line 1695: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:GetCustomerAcctData()'|| sqlerrm);

1691: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1692: p_count => x_msg_count ,
1693: p_data => x_msg_data);
1694: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1695: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:GetCustomerAcctData()'|| sqlerrm);
1696: END IF;
1697:
1698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1699: ROLLBACK TO CUSTACCT_CUSTOMERDATA;

Line 1705: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:GetCustomerAcctData()' || sqlerrm);

1701: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1702: p_count => x_msg_count ,
1703: p_data => x_msg_data);
1704: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1705: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:GetCustomerAcctData()' || sqlerrm);
1706: END IF;
1707:
1708: WHEN OTHERS THEN
1709: ROLLBACK TO CUSTACCT_CUSTOMERDATA;

Line 1720: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:GetCustomerAcctData()' || sqlerrm);

1716: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1717: p_count => x_msg_count ,
1718: p_data => x_msg_data);
1719: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1720: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:GetCustomerAcctData()' || sqlerrm);
1721: END IF;
1722:
1723: END GetCustomerAcctData;
1724:

Line 1726: END IBE_CUSTOMER_ACCT_PVT;

1722:
1723: END GetCustomerAcctData;
1724:
1725:
1726: END IBE_CUSTOMER_ACCT_PVT;