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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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);
1559:
1560: END IF;

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

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);
1559:
1560: END IF;
1561:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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: