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_UTIL

Line 110: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

106: l_address C_address%ROWTYPE;
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

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 143: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

139: IF (p_site_use_type = 'BILL_TO') THEN
140: l_hr_type := 'BILL_TO_COUNTRY';
141: END IF;
142:
143: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
144: Ibe_Util.debug('before calling c_address p_site_use_type:' || p_site_use_type);
145: Ibe_Util.debug('p_party_id:' || p_party_id);
146: Ibe_Util.debug('l_hr_type:' || l_hr_type);
147: Ibe_Util.debug('l_orgId:' || l_orgId);

Line 144: Ibe_Util.debug('before calling c_address p_site_use_type:' || p_site_use_type);

140: l_hr_type := 'BILL_TO_COUNTRY';
141: END IF;
142:
143: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
144: Ibe_Util.debug('before calling c_address p_site_use_type:' || p_site_use_type);
145: Ibe_Util.debug('p_party_id:' || p_party_id);
146: Ibe_Util.debug('l_hr_type:' || l_hr_type);
147: Ibe_Util.debug('l_orgId:' || l_orgId);
148: END IF;

Line 145: Ibe_Util.debug('p_party_id:' || p_party_id);

141: END IF;
142:
143: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
144: Ibe_Util.debug('before calling c_address p_site_use_type:' || p_site_use_type);
145: Ibe_Util.debug('p_party_id:' || p_party_id);
146: Ibe_Util.debug('l_hr_type:' || l_hr_type);
147: Ibe_Util.debug('l_orgId:' || l_orgId);
148: END IF;
149:

Line 146: Ibe_Util.debug('l_hr_type:' || l_hr_type);

142:
143: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
144: Ibe_Util.debug('before calling c_address p_site_use_type:' || p_site_use_type);
145: Ibe_Util.debug('p_party_id:' || p_party_id);
146: Ibe_Util.debug('l_hr_type:' || l_hr_type);
147: Ibe_Util.debug('l_orgId:' || l_orgId);
148: END IF;
149:
150: OPEN C_address(p_party_id, p_site_use_type, l_hr_type, l_orgId);

Line 147: Ibe_Util.debug('l_orgId:' || l_orgId);

143: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
144: Ibe_Util.debug('before calling c_address p_site_use_type:' || p_site_use_type);
145: Ibe_Util.debug('p_party_id:' || p_party_id);
146: Ibe_Util.debug('l_hr_type:' || l_hr_type);
147: Ibe_Util.debug('l_orgId:' || l_orgId);
148: END IF;
149:
150: OPEN C_address(p_party_id, p_site_use_type, l_hr_type, l_orgId);
151: FETCH C_address INTO l_address;

Line 172: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

168: -- Standard call to get message count and if count is 1, get message info.
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

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 183: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

179: x_return_status := FND_API.G_RET_STS_ERROR;
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

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 193: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

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 207: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

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 238: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

234: l_api_name VARCHAR2(30) := 'CUSTACCT_CREATEPARTYSITEUSE';
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;

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 240: Ibe_Util.debug('create_pty_site_use:before create_pty_site_use:p_party_site_id: ' || p_party_site_id);

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:
244: -- Standard Start of API savepoint

Line 241: Ibe_Util.debug('create_pty_site_use:before create_pty_site_use:p_party_site_use_type: ' || p_party_site_use_type);

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:
244: -- Standard Start of API savepoint
245: SAVEPOINT CUSTACCT_CREATEPARTYSITEUSE;

Line 278: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

274: x_msg_count => x_msg_count,
275: x_msg_data => x_msg_data );
276:
277:
278: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
279: Ibe_Util.debug('create_pty_site_use:after create_pty_site_use:x_party_site_use_id: ' || x_party_site_use_id);
280: Ibe_Util.debug('create_pty_site_use:after create_pty_site_use:x_return_status: ' || x_return_status);
281: END IF;
282:

Line 279: Ibe_Util.debug('create_pty_site_use:after create_pty_site_use:x_party_site_use_id: ' || x_party_site_use_id);

275: x_msg_data => x_msg_data );
276:
277:
278: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
279: Ibe_Util.debug('create_pty_site_use:after create_pty_site_use:x_party_site_use_id: ' || x_party_site_use_id);
280: Ibe_Util.debug('create_pty_site_use:after create_pty_site_use:x_return_status: ' || x_return_status);
281: END IF;
282:
283: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 280: Ibe_Util.debug('create_pty_site_use:after create_pty_site_use:x_return_status: ' || x_return_status);

276:
277:
278: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
279: Ibe_Util.debug('create_pty_site_use:after create_pty_site_use:x_party_site_use_id: ' || x_party_site_use_id);
280: Ibe_Util.debug('create_pty_site_use:after create_pty_site_use:x_return_status: ' || x_return_status);
281: END IF;
282:
283: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
284: x_party_site_use_id := l_party_site_use_id;

Line 286: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

282:
283: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
284: x_party_site_use_id := l_party_site_use_id;
285: ELSE
286: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
287: Ibe_Util.debug('Exception in Hz Create_Party_Site_Use: '|| x_msg_data);
288: ENd IF;
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;

Line 287: Ibe_Util.debug('Exception in Hz Create_Party_Site_Use: '|| x_msg_data);

283: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
284: x_party_site_use_id := l_party_site_use_id;
285: ELSE
286: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
287: Ibe_Util.debug('Exception in Hz Create_Party_Site_Use: '|| x_msg_data);
288: ENd IF;
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291:

Line 292: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

288: ENd IF;
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: --

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 317: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

313: x_return_status := FND_API.G_RET_STS_ERROR;
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

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 327: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

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 341: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

337: END IF;
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: */

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 386: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

382:
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

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 420: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

416: -- Initializing the created_by_module column for all the records as per
417: -- changes in version 2 api's.
418: p_cust_acct_roles_rec.Created_by_Module := 'IBE_CUSTOMER_DATA';
419:
420: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
421: IBE_Util.debug('before create cust acct roles');
422: END IF;
423:
424:

Line 421: IBE_Util.debug('before create cust acct roles');

417: -- changes in version 2 api's.
418: p_cust_acct_roles_rec.Created_by_Module := 'IBE_CUSTOMER_DATA';
419:
420: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
421: IBE_Util.debug('before create cust acct roles');
422: END IF;
423:
424:
425: -- old TCA API call

Line 438: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

434: x_msg_count => l_msg_count,
435: x_msg_data => l_msg_data );
436:
437:
438: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
439: IBE_Util.debug('create_contact_role:after create_cust_acct_role: x_return_status: '||l_return_status);
440: END IF;
441:
442: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 439: IBE_Util.debug('create_contact_role:after create_cust_acct_role: x_return_status: '||l_return_status);

435: x_msg_data => l_msg_data );
436:
437:
438: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
439: IBE_Util.debug('create_contact_role:after create_cust_acct_role: x_return_status: '||l_return_status);
440: END IF;
441:
442: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
443: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 443: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

439: IBE_Util.debug('create_contact_role:after create_cust_acct_role: x_return_status: '||l_return_status);
440: END IF;
441:
442: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
443: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
444: IBE_Util.debug('Exception in HZ create_cust_account_role: '||l_msg_data);
445: END IF;
446: RAISE FND_API.G_EXC_ERROR;
447: END IF;

Line 444: IBE_Util.debug('Exception in HZ create_cust_account_role: '||l_msg_data);

440: END IF;
441:
442: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
443: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
444: IBE_Util.debug('Exception in HZ create_cust_account_role: '||l_msg_data);
445: END IF;
446: RAISE FND_API.G_EXC_ERROR;
447: END IF;
448:

Line 457: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

453: THEN
454:
455: OPEN C_Get_Resp(x_cust_acct_role_id, p_role_type);
456: FETCH C_Get_Resp INTO l_responsibility_id;
457: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
458: IBE_Util.debug('create_contact_role l_responsibility_id: '||l_responsibility_id);
459: END IF;
460: IF C_Get_Resp%NOTFOUND THEN
461:

Line 458: IBE_Util.debug('create_contact_role l_responsibility_id: '||l_responsibility_id);

454:
455: OPEN C_Get_Resp(x_cust_acct_role_id, p_role_type);
456: FETCH C_Get_Resp INTO l_responsibility_id;
457: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
458: IBE_Util.debug('create_contact_role l_responsibility_id: '||l_responsibility_id);
459: END IF;
460: IF C_Get_Resp%NOTFOUND THEN
461:
462: IF p_cust_acct_site_id is not NULL AND

Line 483: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

479: x_msg_data => l_msg_data );
480:
481:
482:
483: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
484: IBE_Util.debug('create_contact_role:after create_role_resp: x_return_status: '||l_return_status);
485: END IF;
486:
487: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 484: IBE_Util.debug('create_contact_role:after create_role_resp: x_return_status: '||l_return_status);

480:
481:
482:
483: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
484: IBE_Util.debug('create_contact_role:after create_role_resp: x_return_status: '||l_return_status);
485: END IF;
486:
487: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
488: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 488: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

484: IBE_Util.debug('create_contact_role:after create_role_resp: x_return_status: '||l_return_status);
485: END IF;
486:
487: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
488: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
489: IBE_Util.debug('Exception in HZ create_role_responsibility: '||l_msg_data);
490: END IF;
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;

Line 489: IBE_Util.debug('Exception in HZ create_role_responsibility: '||l_msg_data);

485: END IF;
486:
487: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
488: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
489: IBE_Util.debug('Exception in HZ create_role_responsibility: '||l_msg_data);
490: END IF;
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:

Line 509: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

505: THEN
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.

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 525: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

521: x_return_status := FND_API.G_RET_STS_ERROR;
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

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 535: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

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 550: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

546:
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;

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 589: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

585:
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:

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 591: IBE_Util.debug('Create_Cust_Acct_Site: '||p_custacct_type||' : ' ||p_partysite_id);

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
595: SAVEPOINT CUSTACCT_CREATCUSTACCTSITE;

Line 621: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

617: Fetch c_acct_site into l_customer_site_id;
618: IF (c_acct_site%NOTFOUND) THEN
619: l_customer_site_id := null;
620: END IF;
621: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
622: IBE_Util.debug('Create_Cust_Acct_Site l_customer_site_id: '||l_customer_site_id);
623: END IF;
624: Close c_acct_site;
625:

Line 622: IBE_Util.debug('Create_Cust_Acct_Site l_customer_site_id: '||l_customer_site_id);

618: IF (c_acct_site%NOTFOUND) THEN
619: l_customer_site_id := null;
620: END IF;
621: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
622: IBE_Util.debug('Create_Cust_Acct_Site l_customer_site_id: '||l_customer_site_id);
623: END IF;
624: Close c_acct_site;
625:
626: IF l_customer_site_id is not NULL THEN

Line 650: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

646:
647: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
648: x_custacct_site_id := l_customer_site_id ;
649: else
650: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
651: IBE_Util.debug('Exception in HZ create_cust_acct_site: '||l_msg_data);
652: END IF;
653: RAISE FND_API.G_EXC_ERROR;
654: end if;

Line 651: IBE_Util.debug('Exception in HZ create_cust_acct_site: '||l_msg_data);

647: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
648: x_custacct_site_id := l_customer_site_id ;
649: else
650: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
651: IBE_Util.debug('Exception in HZ create_cust_acct_site: '||l_msg_data);
652: END IF;
653: RAISE FND_API.G_EXC_ERROR;
654: end if;
655:

Line 672: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

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 683: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

679: x_return_status := FND_API.G_RET_STS_ERROR;
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

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 693: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

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 708: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

704:
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;

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 769: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

765:
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:

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 771: Ibe_util.Debug('p_acct_site_type: ' || p_acct_site_type);

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:
775: -- Standard Start of API savepoint

Line 812: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

808: Close c_site_use;
809:
810: IF l_custacct_site_use_id is not NULL then
811: x_custacct_site_use_id := l_custacct_site_use_id ;
812: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
813: Ibe_util.Debug('x_custacct_site_use_id: ' || x_custacct_site_use_id);
814: END IF;
815: ELSE
816:

Line 813: Ibe_util.Debug('x_custacct_site_use_id: ' || x_custacct_site_use_id);

809:
810: IF l_custacct_site_use_id is not NULL then
811: x_custacct_site_use_id := l_custacct_site_use_id ;
812: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
813: Ibe_util.Debug('x_custacct_site_use_id: ' || x_custacct_site_use_id);
814: END IF;
815: ELSE
816:
817: OPEN c_location(p_party_site_id);

Line 822: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

818: FETCH c_location into l_location;
819: IF (c_location%NOTFOUND) THEN
820: l_location := 'NO_LOCATION';
821: END IF;
822: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
823: Ibe_util.Debug('l_location: ' || l_location);
824: END IF;
825: CLOSE c_location;
826:

Line 823: Ibe_util.Debug('l_location: ' || l_location);

819: IF (c_location%NOTFOUND) THEN
820: l_location := 'NO_LOCATION';
821: END IF;
822: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
823: Ibe_util.Debug('l_location: ' || l_location);
824: END IF;
825: CLOSE c_location;
826:
827: L_profile := HZ_MO_GLOBAL_CACHE.get_auto_site_numbering(MO_GLOBAL.get_current_org_id());

Line 858: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

854: x_msg_count => x_msg_count,
855: x_msg_data => x_msg_data );
856:
857:
858: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
859: Ibe_Util.debug('create_acct_site_use: x_return_status: '|| l_return_status);
860: Ibe_Util.debug('create_acct_site_use: l_custacct_site_use_id: '||l_custacct_site_use_id);
861: END IF;
862:

Line 859: Ibe_Util.debug('create_acct_site_use: x_return_status: '|| l_return_status);

855: x_msg_data => x_msg_data );
856:
857:
858: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
859: Ibe_Util.debug('create_acct_site_use: x_return_status: '|| l_return_status);
860: Ibe_Util.debug('create_acct_site_use: l_custacct_site_use_id: '||l_custacct_site_use_id);
861: END IF;
862:
863: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS THEN

Line 860: Ibe_Util.debug('create_acct_site_use: l_custacct_site_use_id: '||l_custacct_site_use_id);

856:
857:
858: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
859: Ibe_Util.debug('create_acct_site_use: x_return_status: '|| l_return_status);
860: Ibe_Util.debug('create_acct_site_use: l_custacct_site_use_id: '||l_custacct_site_use_id);
861: END IF;
862:
863: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS THEN
864: x_custacct_site_use_id := l_custacct_site_use_id;

Line 866: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

862:
863: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS THEN
864: x_custacct_site_use_id := l_custacct_site_use_id;
865: ELSE
866: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
867: Ibe_util.Debug('Exception in HZ create_cust_site_use: '|| x_msg_data);
868: END IF;
869: RAISE FND_API.G_EXC_ERROR;
870: END IF;

Line 867: Ibe_util.Debug('Exception in HZ create_cust_site_use: '|| x_msg_data);

863: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS THEN
864: x_custacct_site_use_id := l_custacct_site_use_id;
865: ELSE
866: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
867: Ibe_util.Debug('Exception in HZ create_cust_site_use: '|| x_msg_data);
868: END IF;
869: RAISE FND_API.G_EXC_ERROR;
870: END IF;
871:

Line 896: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

892: x_msg_data => x_msg_data
893: );
894:
895: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
896: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
897: Ibe_util.Debug('Exception in HZ Create_Party_Site_Use: '|| x_msg_data);
898: END IF;
899: RAISE FND_API.G_EXC_ERROR;
900: END IF;

Line 897: Ibe_util.Debug('Exception in HZ Create_Party_Site_Use: '|| x_msg_data);

893: );
894:
895: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
896: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
897: Ibe_util.Debug('Exception in HZ Create_Party_Site_Use: '|| x_msg_data);
898: END IF;
899: RAISE FND_API.G_EXC_ERROR;
900: END IF;
901: END IF;

Line 921: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

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 932: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

928: x_return_status := FND_API.G_RET_STS_ERROR;
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

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 942: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

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 957: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

953:
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 ;

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 1016: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1012: l_api_name VARCHAR2(30) := 'CUSTACCT_CUSTACCTSITEUSE';
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

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 1054: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1050: ,x_return_status => x_return_status
1051: ,x_msg_count => x_msg_count
1052: ,x_msg_data => x_msg_data);
1053:
1054: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1055: Ibe_util.Debug('Get_Cust_Account_Site_Use p_party_id: ' || p_party_id );
1056: Ibe_util.Debug('Get_Cust_Account_Site_Use p_siteuse_type: ' || p_siteuse_type );
1057: Ibe_util.Debug('Get_Cust_Account_Site_Use lx_party_site_id: ' || lx_party_site_id );
1058: END IF;

Line 1055: Ibe_util.Debug('Get_Cust_Account_Site_Use p_party_id: ' || p_party_id );

1051: ,x_msg_count => x_msg_count
1052: ,x_msg_data => x_msg_data);
1053:
1054: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1055: Ibe_util.Debug('Get_Cust_Account_Site_Use p_party_id: ' || p_party_id );
1056: Ibe_util.Debug('Get_Cust_Account_Site_Use p_siteuse_type: ' || p_siteuse_type );
1057: Ibe_util.Debug('Get_Cust_Account_Site_Use lx_party_site_id: ' || lx_party_site_id );
1058: END IF;
1059:

Line 1056: Ibe_util.Debug('Get_Cust_Account_Site_Use p_siteuse_type: ' || p_siteuse_type );

1052: ,x_msg_data => x_msg_data);
1053:
1054: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1055: Ibe_util.Debug('Get_Cust_Account_Site_Use p_party_id: ' || p_party_id );
1056: Ibe_util.Debug('Get_Cust_Account_Site_Use p_siteuse_type: ' || p_siteuse_type );
1057: Ibe_util.Debug('Get_Cust_Account_Site_Use lx_party_site_id: ' || lx_party_site_id );
1058: END IF;
1059:
1060: ELSE

Line 1057: Ibe_util.Debug('Get_Cust_Account_Site_Use lx_party_site_id: ' || lx_party_site_id );

1053:
1054: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1055: Ibe_util.Debug('Get_Cust_Account_Site_Use p_party_id: ' || p_party_id );
1056: Ibe_util.Debug('Get_Cust_Account_Site_Use p_siteuse_type: ' || p_siteuse_type );
1057: Ibe_util.Debug('Get_Cust_Account_Site_Use lx_party_site_id: ' || lx_party_site_id );
1058: END IF;
1059:
1060: ELSE
1061:

Line 1075: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1071: -- ** cust acct site id fetching **
1072: -- Use the party Site ID returned above
1073: -- and find the cust_acct_site_id
1074:
1075: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1076: Ibe_util.Debug('retrieved val: ' || p_cust_acct_id||'::'||lx_party_site_id);
1077: END IF;
1078:
1079: OPEN c_get_cust_site(p_cust_acct_id, lx_party_site_id);

Line 1076: Ibe_util.Debug('retrieved val: ' || p_cust_acct_id||'::'||lx_party_site_id);

1072: -- Use the party Site ID returned above
1073: -- and find the cust_acct_site_id
1074:
1075: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1076: Ibe_util.Debug('retrieved val: ' || p_cust_acct_id||'::'||lx_party_site_id);
1077: END IF;
1078:
1079: OPEN c_get_cust_site(p_cust_acct_id, lx_party_site_id);
1080: FETCH c_get_cust_site INTO l_cust_acct_site_id, l_cust_acct_site_status;

Line 1086: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1082: l_cust_siteid_notavl := FND_API.G_TRUE;
1083: END IF;
1084: CLOSE c_get_cust_site;
1085:
1086: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1087: Ibe_util.Debug('cust_acct_site_id: ' || l_cust_acct_site_id);
1088: Ibe_util.Debug('cust_acct_site_status: ' || l_cust_acct_site_status||' : '||l_cust_siteid_notavl);
1089: END IF;
1090:

Line 1087: Ibe_util.Debug('cust_acct_site_id: ' || l_cust_acct_site_id);

1083: END IF;
1084: CLOSE c_get_cust_site;
1085:
1086: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1087: Ibe_util.Debug('cust_acct_site_id: ' || l_cust_acct_site_id);
1088: Ibe_util.Debug('cust_acct_site_status: ' || l_cust_acct_site_status||' : '||l_cust_siteid_notavl);
1089: END IF;
1090:
1091: IF FND_API.to_Boolean(l_cust_siteid_notavl) THEN

Line 1088: Ibe_util.Debug('cust_acct_site_status: ' || l_cust_acct_site_status||' : '||l_cust_siteid_notavl);

1084: CLOSE c_get_cust_site;
1085:
1086: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1087: Ibe_util.Debug('cust_acct_site_id: ' || l_cust_acct_site_id);
1088: Ibe_util.Debug('cust_acct_site_status: ' || l_cust_acct_site_status||' : '||l_cust_siteid_notavl);
1089: END IF;
1090:
1091: IF FND_API.to_Boolean(l_cust_siteid_notavl) THEN
1092:

Line 1095: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1091: IF FND_API.to_Boolean(l_cust_siteid_notavl) THEN
1092:
1093: -- No Valid Cust Acct Site Id is present
1094: -- so try to create one
1095: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1096: Ibe_util.Debug('Trying to create custacctsiteId');
1097: END IF;
1098: Create_Cust_Acct_Site(p_partysite_id => lx_party_site_Id
1099: ,p_custacct_id => p_cust_acct_Id

Line 1096: Ibe_util.Debug('Trying to create custacctsiteId');

1092:
1093: -- No Valid Cust Acct Site Id is present
1094: -- so try to create one
1095: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1096: Ibe_util.Debug('Trying to create custacctsiteId');
1097: END IF;
1098: Create_Cust_Acct_Site(p_partysite_id => lx_party_site_Id
1099: ,p_custacct_id => p_cust_acct_Id
1100: ,p_custacct_type => p_siteuse_type

Line 1107: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1103: ,x_msg_count => x_msg_count
1104: ,x_msg_data => x_msg_data
1105: );
1106:
1107: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1108: Ibe_util.Debug('Create_Cust_Acct_Site returned id : ' || l_cust_acct_site_id);
1109: END IF;
1110: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS OR
1111: (l_cust_acct_site_id is null OR l_cust_acct_site_id = FND_API.G_MISS_NUM))

Line 1108: Ibe_util.Debug('Create_Cust_Acct_Site returned id : ' || l_cust_acct_site_id);

1104: ,x_msg_data => x_msg_data
1105: );
1106:
1107: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1108: Ibe_util.Debug('Create_Cust_Acct_Site returned id : ' || l_cust_acct_site_id);
1109: END IF;
1110: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS OR
1111: (l_cust_acct_site_id is null OR l_cust_acct_site_id = FND_API.G_MISS_NUM))
1112: THEN

Line 1122: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1118:
1119: ELSIF (l_cust_acct_site_status <> 'A') THEN -- IF c_get_cust_site%NOTFOUND
1120:
1121: -- cust acct site id presents but invalid
1122: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1123: Ibe_util.Debug('Inside Invalid CustAcctSiteId Flow - Raise Exception');
1124: END IF;
1125:
1126: IF p_siteuse_type = 'BILL_TO' THEN

Line 1123: Ibe_util.Debug('Inside Invalid CustAcctSiteId Flow - Raise Exception');

1119: ELSIF (l_cust_acct_site_status <> 'A') THEN -- IF c_get_cust_site%NOTFOUND
1120:
1121: -- cust acct site id presents but invalid
1122: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1123: Ibe_util.Debug('Inside Invalid CustAcctSiteId Flow - Raise Exception');
1124: END IF;
1125:
1126: IF p_siteuse_type = 'BILL_TO' THEN
1127: FND_MESSAGE.Set_Name('IBE','IBE_ERR_OT_INVALID_BILLTO_ADDR'); -- need error message

Line 1148: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1144: l_cust_siteuseid_flow := FND_API.G_TRUE; -- custacctsiteuseid not present.
1145: END IF;
1146: CLOSE c_get_custsite_use;
1147:
1148: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1149: Ibe_util.Debug('In l_site_use_id :' || l_site_use_id);
1150: Ibe_util.Debug('In l_custsite_use_status :' || l_custsite_use_status );
1151: END IF;
1152:

Line 1149: Ibe_util.Debug('In l_site_use_id :' || l_site_use_id);

1145: END IF;
1146: CLOSE c_get_custsite_use;
1147:
1148: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1149: Ibe_util.Debug('In l_site_use_id :' || l_site_use_id);
1150: Ibe_util.Debug('In l_custsite_use_status :' || l_custsite_use_status );
1151: END IF;
1152:
1153: IF (FND_API.to_Boolean(l_cust_siteuseid_flow)) THEN

Line 1150: Ibe_util.Debug('In l_custsite_use_status :' || l_custsite_use_status );

1146: CLOSE c_get_custsite_use;
1147:
1148: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1149: Ibe_util.Debug('In l_site_use_id :' || l_site_use_id);
1150: Ibe_util.Debug('In l_custsite_use_status :' || l_custsite_use_status );
1151: END IF;
1152:
1153: IF (FND_API.to_Boolean(l_cust_siteuseid_flow)) THEN
1154:

Line 1183: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1179:
1180: ELSIF (l_custsite_use_status <> 'A') THEN
1181:
1182: -- cust acct siteuse id present but invalid, so raise exception
1183: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1184: Ibe_util.Debug('Inside Invalid CustAcctSiteUseId Flow - Raise Exception');
1185: Ibe_util.Debug('nproc1 Inside Invalid CustAcctSiteUseId Flow - Raise Exception;' || l_site_use_id);
1186: Ibe_util.Debug('nproc1 Inside Invalid CustAcctSiteUseId Flow - Raise Exception:' || l_custsite_use_status);
1187: END IF;

Line 1184: Ibe_util.Debug('Inside Invalid CustAcctSiteUseId Flow - Raise Exception');

1180: ELSIF (l_custsite_use_status <> 'A') THEN
1181:
1182: -- cust acct siteuse id present but invalid, so raise exception
1183: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1184: Ibe_util.Debug('Inside Invalid CustAcctSiteUseId Flow - Raise Exception');
1185: Ibe_util.Debug('nproc1 Inside Invalid CustAcctSiteUseId Flow - Raise Exception;' || l_site_use_id);
1186: Ibe_util.Debug('nproc1 Inside Invalid CustAcctSiteUseId Flow - Raise Exception:' || l_custsite_use_status);
1187: END IF;
1188:

Line 1185: Ibe_util.Debug('nproc1 Inside Invalid CustAcctSiteUseId Flow - Raise Exception;' || l_site_use_id);

1181:
1182: -- cust acct siteuse id present but invalid, so raise exception
1183: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1184: Ibe_util.Debug('Inside Invalid CustAcctSiteUseId Flow - Raise Exception');
1185: Ibe_util.Debug('nproc1 Inside Invalid CustAcctSiteUseId Flow - Raise Exception;' || l_site_use_id);
1186: Ibe_util.Debug('nproc1 Inside Invalid CustAcctSiteUseId Flow - Raise Exception:' || l_custsite_use_status);
1187: END IF;
1188:
1189: IF p_siteuse_type = 'BILL_TO' THEN

Line 1186: Ibe_util.Debug('nproc1 Inside Invalid CustAcctSiteUseId Flow - Raise Exception:' || l_custsite_use_status);

1182: -- cust acct siteuse id present but invalid, so raise exception
1183: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1184: Ibe_util.Debug('Inside Invalid CustAcctSiteUseId Flow - Raise Exception');
1185: Ibe_util.Debug('nproc1 Inside Invalid CustAcctSiteUseId Flow - Raise Exception;' || l_site_use_id);
1186: Ibe_util.Debug('nproc1 Inside Invalid CustAcctSiteUseId Flow - Raise Exception:' || l_custsite_use_status);
1187: END IF;
1188:
1189: IF p_siteuse_type = 'BILL_TO' THEN
1190: FND_MESSAGE.Set_Name('IBE','IBE_ERR_OT_INVALID_BILLTO_ADDR'); -- need error message

Line 1202: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1198: -- valid cust_acct_site_use_id available, so use it
1199: x_siteuse_id := l_site_use_id;
1200: END IF; --l_cust_siteuseid_flow
1201:
1202: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1203: Ibe_util.Debug('x_siteuse_id: ' || x_siteuse_id);
1204: END IF;
1205:
1206: ELSE --party_site_id =-1

Line 1203: Ibe_util.Debug('x_siteuse_id: ' || x_siteuse_id);

1199: x_siteuse_id := l_site_use_id;
1200: END IF; --l_cust_siteuseid_flow
1201:
1202: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1203: Ibe_util.Debug('x_siteuse_id: ' || x_siteuse_id);
1204: END IF;
1205:
1206: ELSE --party_site_id =-1
1207: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1226: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

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 1236: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1232: x_return_status := FND_API.G_RET_STS_ERROR;
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

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 1245: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

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 1254: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;

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 1310: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1306:
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;

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 1312: Ibe_util.Debug('Get_Cust_Acct_Role partyId, soldtoorgid: '||p_party_id||' : '|| p_sold_to_orgid);

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:
1316: -- Standard Start of API savepoint

Line 1313: Ibe_util.Debug('Get_Cust_Acct_Role custacct siteuse id: '||p_custacct_siteuse_id);

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:
1316: -- Standard Start of API savepoint
1317: SAVEPOINT CUSTACCT_GETCUSTACCTRLE;

Line 1344: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1340: open c_cust_acct_id(p_custacct_siteuse_id,p_acctsite_type);
1341: fetch c_cust_acct_id into l_custacct_site_id,l_cust_acct_id,l_party_id;
1342: close c_cust_acct_id;
1343:
1344: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1345: Ibe_util.Debug('db cust_acct_id: '||l_cust_acct_id);
1346: END IF;
1347:
1348: -- if(l_cust_acct_id = p_sold_to_orgid AND l_party_id = p_party_id) then

Line 1345: Ibe_util.Debug('db cust_acct_id: '||l_cust_acct_id);

1341: fetch c_cust_acct_id into l_custacct_site_id,l_cust_acct_id,l_party_id;
1342: close c_cust_acct_id;
1343:
1344: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1345: Ibe_util.Debug('db cust_acct_id: '||l_cust_acct_id);
1346: END IF;
1347:
1348: -- if(l_cust_acct_id = p_sold_to_orgid AND l_party_id = p_party_id) then
1349:

Line 1363: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1359: else
1360: l_cust_acct_role_id := l_cust_role.cust_account_role_id;
1361: end if;
1362:
1363: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1364: Ibe_util.Debug('Get_Cust_Acct_Role cust_acct_role_id: '||l_cust_acct_role_id);
1365: end if;
1366:
1367: IF (l_cust_acct_role_id IS NULL or l_cust_acct_role_id = FND_API.G_MISS_NUM)

Line 1364: Ibe_util.Debug('Get_Cust_Acct_Role cust_acct_role_id: '||l_cust_acct_role_id);

1360: l_cust_acct_role_id := l_cust_role.cust_account_role_id;
1361: end if;
1362:
1363: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1364: Ibe_util.Debug('Get_Cust_Acct_Role cust_acct_role_id: '||l_cust_acct_role_id);
1365: end if;
1366:
1367: IF (l_cust_acct_role_id IS NULL or l_cust_acct_role_id = FND_API.G_MISS_NUM)
1368: THEN

Line 1385: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1381: -- l_cust_acct_role_id := NULL;
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: --

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 1411: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1407: x_return_status := FND_API.G_RET_STS_ERROR;
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

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 1421: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

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 1436: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1432:
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;

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 1503: IBE_UTIL.format_phone(phone_country_code,phone_area_code,phone_number,phone_extension)phone_number,

1499: lc_contact_partyname c_contact_partyname%rowtype;
1500:
1501: CURSOR c_contact_details(lc_cntct_prtyId number) IS
1502: select contact_point_type, primary_flag,phone_line_type,
1503: IBE_UTIL.format_phone(phone_country_code,phone_area_code,phone_number,phone_extension)phone_number,
1504: email_address
1505: from hz_contact_points
1506: where contact_point_type in ('PHONE','EMAIL') and
1507: NVL(status, 'A') = 'A' and owner_table_name = 'HZ_PARTIES'

Line 1556: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1552: -- Else if cust_acct_id is passed from UI the fetch the details directly
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);

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 1558: IBE_Util.Debug('p_invoice_to_org_id: ' || p_invoice_to_org_id);

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);
1562:

Line 1559: IBE_Util.Debug('p_invoice_to_contact_id: '||p_invoice_to_contact_id);

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);
1562:
1563: END IF;

Line 1560: IBE_Util.Debug('p_contact_party_id: '|| p_contact_party_id);

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);
1562:
1563: END IF;
1564:

Line 1561: IBE_Util.Debug('p_cust_account_id: '|| p_cust_account_id);

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);
1562:
1563: END IF;
1564:
1565: if(p_invoice_to_org_id is not null AND p_invoice_to_org_id <> FND_API.G_MISS_NUM) then

Line 1566: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1562:
1563: END IF;
1564:
1565: if(p_invoice_to_org_id is not null AND p_invoice_to_org_id <> FND_API.G_MISS_NUM) then
1566: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1567: IBE_Util.Debug('Inside invoiceToorg id IF loop');
1568: END IF;
1569: open c_cust_acct_det(p_invoice_to_org_id);
1570: fetch c_cust_acct_det into lc_cust_acct_det;

Line 1567: IBE_Util.Debug('Inside invoiceToorg id IF loop');

1563: END IF;
1564:
1565: if(p_invoice_to_org_id is not null AND p_invoice_to_org_id <> FND_API.G_MISS_NUM) then
1566: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1567: IBE_Util.Debug('Inside invoiceToorg id IF loop');
1568: END IF;
1569: open c_cust_acct_det(p_invoice_to_org_id);
1570: fetch c_cust_acct_det into lc_cust_acct_det;
1571: if(c_cust_acct_det%notfound) then

Line 1576: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1572: FND_Message.Set_Name('IBE', 'IBE_ERR_OT_INVALID_CUST'); --need err msg
1573: FND_Msg_Pub.Add;
1574: RAISE FND_API.G_EXC_ERROR;
1575: else
1576: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1577: IBE_Util.Debug('Customer details available');
1578: END IF;
1579: l_cust_account_id := lc_cust_acct_det.cust_account_id;
1580: l_partysite_id := lc_cust_acct_det.party_site_id;

Line 1577: IBE_Util.Debug('Customer details available');

1573: FND_Msg_Pub.Add;
1574: RAISE FND_API.G_EXC_ERROR;
1575: else
1576: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1577: IBE_Util.Debug('Customer details available');
1578: END IF;
1579: l_cust_account_id := lc_cust_acct_det.cust_account_id;
1580: l_partysite_id := lc_cust_acct_det.party_site_id;
1581: l_partysite_stat := lc_cust_acct_det.status;

Line 1591: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1587: l_partysite_id := null;
1588: l_partysite_stat := '';
1589: end if;
1590:
1591: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1592: IBE_Util.Debug('l_cust_account_id: '||l_cust_account_id);
1593: IBE_Util.Debug('l_partysite_id: '|| l_partysite_id);
1594: IBE_Util.Debug('l_partysite_stat: '|| l_partysite_stat);
1595:

Line 1592: IBE_Util.Debug('l_cust_account_id: '||l_cust_account_id);

1588: l_partysite_stat := '';
1589: end if;
1590:
1591: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1592: IBE_Util.Debug('l_cust_account_id: '||l_cust_account_id);
1593: IBE_Util.Debug('l_partysite_id: '|| l_partysite_id);
1594: IBE_Util.Debug('l_partysite_stat: '|| l_partysite_stat);
1595:
1596: END IF;

Line 1593: IBE_Util.Debug('l_partysite_id: '|| l_partysite_id);

1589: end if;
1590:
1591: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1592: IBE_Util.Debug('l_cust_account_id: '||l_cust_account_id);
1593: IBE_Util.Debug('l_partysite_id: '|| l_partysite_id);
1594: IBE_Util.Debug('l_partysite_stat: '|| l_partysite_stat);
1595:
1596: END IF;
1597: x_cust_account_id := l_cust_account_id;

Line 1594: IBE_Util.Debug('l_partysite_stat: '|| l_partysite_stat);

1590:
1591: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1592: IBE_Util.Debug('l_cust_account_id: '||l_cust_account_id);
1593: IBE_Util.Debug('l_partysite_id: '|| l_partysite_id);
1594: IBE_Util.Debug('l_partysite_stat: '|| l_partysite_stat);
1595:
1596: END IF;
1597: x_cust_account_id := l_cust_account_id;
1598: x_party_site_id := l_partysite_id;

Line 1615: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1611: end if;
1612:
1613: close c_customer_details;
1614:
1615: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1616: IBE_Util.Debug('x_cust_party_id: '|| x_cust_party_id);
1617: IBE_Util.Debug('x_cust_party_name: '|| x_cust_party_name);
1618: END IF;
1619: -- PART II

Line 1616: IBE_Util.Debug('x_cust_party_id: '|| x_cust_party_id);

1612:
1613: close c_customer_details;
1614:
1615: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1616: IBE_Util.Debug('x_cust_party_id: '|| x_cust_party_id);
1617: IBE_Util.Debug('x_cust_party_name: '|| x_cust_party_name);
1618: END IF;
1619: -- PART II
1620: -- Send the Party_site_Id and its status fetched above.

Line 1617: IBE_Util.Debug('x_cust_party_name: '|| x_cust_party_name);

1613: close c_customer_details;
1614:
1615: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1616: IBE_Util.Debug('x_cust_party_id: '|| x_cust_party_id);
1617: IBE_Util.Debug('x_cust_party_name: '|| x_cust_party_name);
1618: END IF;
1619: -- PART II
1620: -- Send the Party_site_Id and its status fetched above.
1621:

Line 1637: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1633: elsif(p_contact_party_id is not null AND p_contact_party_id <> FND_API.G_MISS_NUM) then
1634: l_cntct_partyid := p_contact_party_id;
1635: end if; -- (p_invoice_to_contact_id <> FND_API.G_MISS_NUM
1636:
1637: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1638: IBE_Util.Debug('l_cntct_partyid: '|| l_cntct_partyid);
1639: END IF;
1640:
1641:

Line 1638: IBE_Util.Debug('l_cntct_partyid: '|| l_cntct_partyid);

1634: l_cntct_partyid := p_contact_party_id;
1635: end if; -- (p_invoice_to_contact_id <> FND_API.G_MISS_NUM
1636:
1637: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1638: IBE_Util.Debug('l_cntct_partyid: '|| l_cntct_partyid);
1639: END IF;
1640:
1641:
1642: if (l_cntct_partyid is null OR l_cntct_partyid = FND_API.G_MISS_NUM) then

Line 1680: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1676: x_contact_phone := l_cntct_phone;
1677: x_contact_email := l_cntct_email;
1678: end if;
1679:
1680: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1681: IBE_Util.Debug('l_cntct_party_name: '|| l_cntct_party_name);
1682: IBE_Util.Debug('l_cntct_phone: '|| l_cntct_phone);
1683: IBE_Util.Debug('l_cntct_email: '|| l_cntct_email);
1684: END IF;

Line 1681: IBE_Util.Debug('l_cntct_party_name: '|| l_cntct_party_name);

1677: x_contact_email := l_cntct_email;
1678: end if;
1679:
1680: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1681: IBE_Util.Debug('l_cntct_party_name: '|| l_cntct_party_name);
1682: IBE_Util.Debug('l_cntct_phone: '|| l_cntct_phone);
1683: IBE_Util.Debug('l_cntct_email: '|| l_cntct_email);
1684: END IF;
1685:

Line 1682: IBE_Util.Debug('l_cntct_phone: '|| l_cntct_phone);

1678: end if;
1679:
1680: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1681: IBE_Util.Debug('l_cntct_party_name: '|| l_cntct_party_name);
1682: IBE_Util.Debug('l_cntct_phone: '|| l_cntct_phone);
1683: IBE_Util.Debug('l_cntct_email: '|| l_cntct_email);
1684: END IF;
1685:
1686: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1683: IBE_Util.Debug('l_cntct_email: '|| l_cntct_email);

1679:
1680: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1681: IBE_Util.Debug('l_cntct_party_name: '|| l_cntct_party_name);
1682: IBE_Util.Debug('l_cntct_phone: '|| l_cntct_phone);
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');

Line 1686: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1682: IBE_Util.Debug('l_cntct_phone: '|| l_cntct_phone);
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

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 1697: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1693: x_return_status := FND_API.G_RET_STS_ERROR;
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

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 1707: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

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 1722: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1718:
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;

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: