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.12020000.2 2012/11/12 06:32:18 nsatyava 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.12020000.2 2012/11/12 06:32:18 nsatyava 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 111: Ibe_Util.debug('Begin IBE_CUSTOMER_ACCT_PVT:GetPartySiteId');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1729: END IBE_CUSTOMER_ACCT_PVT;

1725:
1726: END GetCustomerAcctData;
1727:
1728:
1729: END IBE_CUSTOMER_ACCT_PVT;