DBA Data[Home] [Help]

APPS.HZ_CUST_ACCT_CONTACT_BO_PVT dependencies on FND_LOG

Line 124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

120: -- initialize API return status to success.
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122:
123: -- Debug info.
124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
125: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(+)',
126: p_prefix=>l_debug_prefix,
127: p_msg_level=>fnd_log.level_procedure);
128: END IF;

Line 127: p_msg_level=>fnd_log.level_procedure);

123: -- Debug info.
124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
125: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(+)',
126: p_prefix=>l_debug_prefix,
127: p_msg_level=>fnd_log.level_procedure);
128: END IF;
129:
130: -- Create role responsibilities
131: FOR i IN 1..p_rr_objs.COUNT LOOP

Line 147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

143: x_msg_data => x_msg_data
144: );
145:
146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
148: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.create_role_responsibilities, cust acct contact id: '||p_cac_id,
149: p_prefix=>l_debug_prefix,
150: p_msg_level=>fnd_log.level_procedure);
151: END IF;

Line 150: p_msg_level=>fnd_log.level_procedure);

146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
148: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.create_role_responsibilities, cust acct contact id: '||p_cac_id,
149: p_prefix=>l_debug_prefix,
150: p_msg_level=>fnd_log.level_procedure);
151: END IF;
152: RAISE fnd_api.g_exc_error;
153: END IF;
154:

Line 160: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

156: p_rr_objs(i).responsibility_id := l_rr_id;
157: END LOOP;
158:
159: -- Debug info.
160: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
161: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
162: p_msg_data=>x_msg_data,
163: p_msg_type=>'WARNING',
164: p_msg_level=>fnd_log.level_exception);

Line 164: p_msg_level=>fnd_log.level_exception);

160: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
161: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
162: p_msg_data=>x_msg_data,
163: p_msg_type=>'WARNING',
164: p_msg_level=>fnd_log.level_exception);
165: END IF;
166: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
167: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(-)',
168: p_prefix=>l_debug_prefix,

Line 166: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

162: p_msg_data=>x_msg_data,
163: p_msg_type=>'WARNING',
164: p_msg_level=>fnd_log.level_exception);
165: END IF;
166: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
167: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(-)',
168: p_prefix=>l_debug_prefix,
169: p_msg_level=>fnd_log.level_procedure);
170: END IF;

Line 169: p_msg_level=>fnd_log.level_procedure);

165: END IF;
166: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
167: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(-)',
168: p_prefix=>l_debug_prefix,
169: p_msg_level=>fnd_log.level_procedure);
170: END IF;
171:
172: EXCEPTION
173: WHEN fnd_api.g_exc_error THEN

Line 186: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

182: p_count => x_msg_count,
183: p_data => x_msg_data);
184:
185: -- Debug info.
186: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
187: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
188: p_msg_data=>x_msg_data,
189: p_msg_type=>'ERROR',
190: p_msg_level=>fnd_log.level_error);

Line 190: p_msg_level=>fnd_log.level_error);

186: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
187: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
188: p_msg_data=>x_msg_data,
189: p_msg_type=>'ERROR',
190: p_msg_level=>fnd_log.level_error);
191: END IF;
192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
193: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(-)',
194: p_prefix=>l_debug_prefix,

Line 192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

188: p_msg_data=>x_msg_data,
189: p_msg_type=>'ERROR',
190: p_msg_level=>fnd_log.level_error);
191: END IF;
192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
193: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(-)',
194: p_prefix=>l_debug_prefix,
195: p_msg_level=>fnd_log.level_procedure);
196: END IF;

Line 195: p_msg_level=>fnd_log.level_procedure);

191: END IF;
192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
193: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(-)',
194: p_prefix=>l_debug_prefix,
195: p_msg_level=>fnd_log.level_procedure);
196: END IF;
197:
198: WHEN fnd_api.g_exc_unexpected_error THEN
199: ROLLBACK TO create_rr_pvt;

Line 211: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

207: p_count => x_msg_count,
208: p_data => x_msg_data);
209:
210: -- Debug info.
211: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
212: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
213: p_msg_data=>x_msg_data,
214: p_msg_type=>'UNEXPECTED ERROR',
215: p_msg_level=>fnd_log.level_error);

Line 215: p_msg_level=>fnd_log.level_error);

211: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
212: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
213: p_msg_data=>x_msg_data,
214: p_msg_type=>'UNEXPECTED ERROR',
215: p_msg_level=>fnd_log.level_error);
216: END IF;
217: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
218: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(-)',
219: p_prefix=>l_debug_prefix,

Line 217: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

213: p_msg_data=>x_msg_data,
214: p_msg_type=>'UNEXPECTED ERROR',
215: p_msg_level=>fnd_log.level_error);
216: END IF;
217: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
218: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(-)',
219: p_prefix=>l_debug_prefix,
220: p_msg_level=>fnd_log.level_procedure);
221: END IF;

Line 220: p_msg_level=>fnd_log.level_procedure);

216: END IF;
217: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
218: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(-)',
219: p_prefix=>l_debug_prefix,
220: p_msg_level=>fnd_log.level_procedure);
221: END IF;
222:
223: WHEN OTHERS THEN
224: ROLLBACK TO create_rr_pvt;

Line 240: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

236: p_count => x_msg_count,
237: p_data => x_msg_data);
238:
239: -- Debug info.
240: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
241: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
242: p_msg_data=>x_msg_data,
243: p_msg_type=>'SQL ERROR',
244: p_msg_level=>fnd_log.level_error);

Line 244: p_msg_level=>fnd_log.level_error);

240: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
241: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
242: p_msg_data=>x_msg_data,
243: p_msg_type=>'SQL ERROR',
244: p_msg_level=>fnd_log.level_error);
245: END IF;
246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
247: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(-)',
248: p_prefix=>l_debug_prefix,

Line 246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

242: p_msg_data=>x_msg_data,
243: p_msg_type=>'SQL ERROR',
244: p_msg_level=>fnd_log.level_error);
245: END IF;
246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
247: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(-)',
248: p_prefix=>l_debug_prefix,
249: p_msg_level=>fnd_log.level_procedure);
250: END IF;

Line 249: p_msg_level=>fnd_log.level_procedure);

245: END IF;
246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
247: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(-)',
248: p_prefix=>l_debug_prefix,
249: p_msg_level=>fnd_log.level_procedure);
250: END IF;
251: END create_role_responsibilities;
252:
253: -- PROCEDURE save_role_responsbilities

Line 297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

293: -- initialize API return status to success.
294: x_return_status := FND_API.G_RET_STS_SUCCESS;
295:
296: -- Debug info.
297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
298: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(+)',
299: p_prefix=>l_debug_prefix,
300: p_msg_level=>fnd_log.level_procedure);
301: END IF;

Line 300: p_msg_level=>fnd_log.level_procedure);

296: -- Debug info.
297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
298: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(+)',
299: p_prefix=>l_debug_prefix,
300: p_msg_level=>fnd_log.level_procedure);
301: END IF;
302:
303: -- Create/Update role responsibilities
304: FOR i IN 1..p_rr_objs.COUNT LOOP

Line 320: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

316: x_object_version_number => l_ovn
317: );
318:
319: IF (l_ovn = -1) THEN
320: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
321: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.check_role_resp_op, cust acct contact id: '||p_cac_id,
322: p_prefix=>l_debug_prefix,
323: p_msg_level=>fnd_log.level_procedure);
324: END IF;

Line 323: p_msg_level=>fnd_log.level_procedure);

319: IF (l_ovn = -1) THEN
320: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
321: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.check_role_resp_op, cust acct contact id: '||p_cac_id,
322: p_prefix=>l_debug_prefix,
323: p_msg_level=>fnd_log.level_procedure);
324: END IF;
325: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
326: FND_MSG_PUB.ADD;
327: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 360: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

356: p_rr_objs(i).responsibility_id := l_rr_rec.responsibility_id;
357: END IF;
358:
359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
360: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
361: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_role_responsibilities, cust acct contact id: '||p_cac_id,
362: p_prefix=>l_debug_prefix,
363: p_msg_level=>fnd_log.level_procedure);
364: END IF;

Line 363: p_msg_level=>fnd_log.level_procedure);

359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
360: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
361: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_role_responsibilities, cust acct contact id: '||p_cac_id,
362: p_prefix=>l_debug_prefix,
363: p_msg_level=>fnd_log.level_procedure);
364: END IF;
365: RAISE fnd_api.g_exc_error;
366: END IF;
367:

Line 371: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

367:
368: END LOOP;
369:
370: -- Debug info.
371: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
372: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
373: p_msg_data=>x_msg_data,
374: p_msg_type=>'WARNING',
375: p_msg_level=>fnd_log.level_exception);

Line 375: p_msg_level=>fnd_log.level_exception);

371: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
372: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
373: p_msg_data=>x_msg_data,
374: p_msg_type=>'WARNING',
375: p_msg_level=>fnd_log.level_exception);
376: END IF;
377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
378: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',
379: p_prefix=>l_debug_prefix,

Line 377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

373: p_msg_data=>x_msg_data,
374: p_msg_type=>'WARNING',
375: p_msg_level=>fnd_log.level_exception);
376: END IF;
377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
378: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',
379: p_prefix=>l_debug_prefix,
380: p_msg_level=>fnd_log.level_procedure);
381: END IF;

Line 380: p_msg_level=>fnd_log.level_procedure);

376: END IF;
377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
378: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',
379: p_prefix=>l_debug_prefix,
380: p_msg_level=>fnd_log.level_procedure);
381: END IF;
382: EXCEPTION
383: WHEN fnd_api.g_exc_error THEN
384: ROLLBACK TO save_rr_pvt;

Line 396: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

392: p_count => x_msg_count,
393: p_data => x_msg_data);
394:
395: -- Debug info.
396: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
397: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
398: p_msg_data=>x_msg_data,
399: p_msg_type=>'ERROR',
400: p_msg_level=>fnd_log.level_error);

Line 400: p_msg_level=>fnd_log.level_error);

396: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
397: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
398: p_msg_data=>x_msg_data,
399: p_msg_type=>'ERROR',
400: p_msg_level=>fnd_log.level_error);
401: END IF;
402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
403: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',
404: p_prefix=>l_debug_prefix,

Line 402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

398: p_msg_data=>x_msg_data,
399: p_msg_type=>'ERROR',
400: p_msg_level=>fnd_log.level_error);
401: END IF;
402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
403: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',
404: p_prefix=>l_debug_prefix,
405: p_msg_level=>fnd_log.level_procedure);
406: END IF;

Line 405: p_msg_level=>fnd_log.level_procedure);

401: END IF;
402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
403: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',
404: p_prefix=>l_debug_prefix,
405: p_msg_level=>fnd_log.level_procedure);
406: END IF;
407:
408: WHEN fnd_api.g_exc_unexpected_error THEN
409: ROLLBACK TO save_rr_pvt;

Line 421: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

417: p_count => x_msg_count,
418: p_data => x_msg_data);
419:
420: -- Debug info.
421: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
422: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
423: p_msg_data=>x_msg_data,
424: p_msg_type=>'UNEXPECTED ERROR',
425: p_msg_level=>fnd_log.level_error);

Line 425: p_msg_level=>fnd_log.level_error);

421: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
422: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
423: p_msg_data=>x_msg_data,
424: p_msg_type=>'UNEXPECTED ERROR',
425: p_msg_level=>fnd_log.level_error);
426: END IF;
427: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
428: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',
429: p_prefix=>l_debug_prefix,

Line 427: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

423: p_msg_data=>x_msg_data,
424: p_msg_type=>'UNEXPECTED ERROR',
425: p_msg_level=>fnd_log.level_error);
426: END IF;
427: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
428: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',
429: p_prefix=>l_debug_prefix,
430: p_msg_level=>fnd_log.level_procedure);
431: END IF;

Line 430: p_msg_level=>fnd_log.level_procedure);

426: END IF;
427: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
428: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',
429: p_prefix=>l_debug_prefix,
430: p_msg_level=>fnd_log.level_procedure);
431: END IF;
432:
433: WHEN OTHERS THEN
434: ROLLBACK TO save_rr_pvt;

Line 450: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

446: p_count => x_msg_count,
447: p_data => x_msg_data);
448:
449: -- Debug info.
450: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
451: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
452: p_msg_data=>x_msg_data,
453: p_msg_type=>'SQL ERROR',
454: p_msg_level=>fnd_log.level_error);

Line 454: p_msg_level=>fnd_log.level_error);

450: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
451: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
452: p_msg_data=>x_msg_data,
453: p_msg_type=>'SQL ERROR',
454: p_msg_level=>fnd_log.level_error);
455: END IF;
456: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
457: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',
458: p_prefix=>l_debug_prefix,

Line 456: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

452: p_msg_data=>x_msg_data,
453: p_msg_type=>'SQL ERROR',
454: p_msg_level=>fnd_log.level_error);
455: END IF;
456: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
457: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',
458: p_prefix=>l_debug_prefix,
459: p_msg_level=>fnd_log.level_procedure);
460: END IF;

Line 459: p_msg_level=>fnd_log.level_procedure);

455: END IF;
456: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
457: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',
458: p_prefix=>l_debug_prefix,
459: p_msg_level=>fnd_log.level_procedure);
460: END IF;
461: END save_role_responsibilities;
462:
463: -- PROCEDURE save_cust_acct_contacts

Line 518: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

514: -- initialize API return status to success
515: x_return_status := FND_API.G_RET_STS_SUCCESS;
516:
517: -- Debug info.
518: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
519: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(+)',
520: p_prefix=>l_debug_prefix,
521: p_msg_level=>fnd_log.level_procedure);
522: END IF;

Line 521: p_msg_level=>fnd_log.level_procedure);

517: -- Debug info.
518: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
519: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(+)',
520: p_prefix=>l_debug_prefix,
521: p_msg_level=>fnd_log.level_procedure);
522: END IF;
523:
524: l_parent_id := p_parent_id;
525: l_parent_os := p_parent_os;

Line 553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

549: px_parent_obj_type => l_parent_obj_type
550: );
551:
552: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
554: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_cust_acct_contacts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
555: p_prefix=>l_debug_prefix,
556: p_msg_level=>fnd_log.level_procedure);
557: END IF;

Line 556: p_msg_level=>fnd_log.level_procedure);

552: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
554: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_cust_acct_contacts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
555: p_prefix=>l_debug_prefix,
556: p_msg_level=>fnd_log.level_procedure);
557: END IF;
558: RAISE fnd_api.g_exc_error;
559: END IF;
560:

Line 585: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

581: px_parent_obj_type => l_parent_obj_type
582: );
583:
584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
585: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
586: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_cust_acct_contacts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
587: p_prefix=>l_debug_prefix,
588: p_msg_level=>fnd_log.level_procedure);
589: END IF;

Line 588: p_msg_level=>fnd_log.level_procedure);

584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
585: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
586: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_cust_acct_contacts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
587: p_prefix=>l_debug_prefix,
588: p_msg_level=>fnd_log.level_procedure);
589: END IF;
590: RAISE fnd_api.g_exc_error;
591: END IF;
592:

Line 598: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

594: END LOOP;
595: END IF;
596:
597: -- Debug info.
598: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
599: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
600: p_msg_data=>x_msg_data,
601: p_msg_type=>'WARNING',
602: p_msg_level=>fnd_log.level_exception);

Line 602: p_msg_level=>fnd_log.level_exception);

598: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
599: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
600: p_msg_data=>x_msg_data,
601: p_msg_type=>'WARNING',
602: p_msg_level=>fnd_log.level_exception);
603: END IF;
604: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
605: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',
606: p_prefix=>l_debug_prefix,

Line 604: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

600: p_msg_data=>x_msg_data,
601: p_msg_type=>'WARNING',
602: p_msg_level=>fnd_log.level_exception);
603: END IF;
604: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
605: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',
606: p_prefix=>l_debug_prefix,
607: p_msg_level=>fnd_log.level_procedure);
608: END IF;

Line 607: p_msg_level=>fnd_log.level_procedure);

603: END IF;
604: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
605: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',
606: p_prefix=>l_debug_prefix,
607: p_msg_level=>fnd_log.level_procedure);
608: END IF;
609: EXCEPTION
610: WHEN fnd_api.g_exc_error THEN
611: x_return_status := fnd_api.g_ret_sts_error;

Line 618: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

614: p_count => x_msg_count,
615: p_data => x_msg_data);
616:
617: -- Debug info.
618: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
619: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
620: p_msg_data=>x_msg_data,
621: p_msg_type=>'ERROR',
622: p_msg_level=>fnd_log.level_error);

Line 622: p_msg_level=>fnd_log.level_error);

618: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
619: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
620: p_msg_data=>x_msg_data,
621: p_msg_type=>'ERROR',
622: p_msg_level=>fnd_log.level_error);
623: END IF;
624: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
625: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',
626: p_prefix=>l_debug_prefix,

Line 624: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

620: p_msg_data=>x_msg_data,
621: p_msg_type=>'ERROR',
622: p_msg_level=>fnd_log.level_error);
623: END IF;
624: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
625: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',
626: p_prefix=>l_debug_prefix,
627: p_msg_level=>fnd_log.level_procedure);
628: END IF;

Line 627: p_msg_level=>fnd_log.level_procedure);

623: END IF;
624: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
625: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',
626: p_prefix=>l_debug_prefix,
627: p_msg_level=>fnd_log.level_procedure);
628: END IF;
629: WHEN fnd_api.g_exc_unexpected_error THEN
630: x_return_status := fnd_api.g_ret_sts_unexp_error;
631:

Line 637: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

633: p_count => x_msg_count,
634: p_data => x_msg_data);
635:
636: -- Debug info.
637: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
638: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
639: p_msg_data=>x_msg_data,
640: p_msg_type=>'UNEXPECTED ERROR',
641: p_msg_level=>fnd_log.level_error);

Line 641: p_msg_level=>fnd_log.level_error);

637: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
638: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
639: p_msg_data=>x_msg_data,
640: p_msg_type=>'UNEXPECTED ERROR',
641: p_msg_level=>fnd_log.level_error);
642: END IF;
643: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
644: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',
645: p_prefix=>l_debug_prefix,

Line 643: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

639: p_msg_data=>x_msg_data,
640: p_msg_type=>'UNEXPECTED ERROR',
641: p_msg_level=>fnd_log.level_error);
642: END IF;
643: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
644: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',
645: p_prefix=>l_debug_prefix,
646: p_msg_level=>fnd_log.level_procedure);
647: END IF;

Line 646: p_msg_level=>fnd_log.level_procedure);

642: END IF;
643: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
644: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',
645: p_prefix=>l_debug_prefix,
646: p_msg_level=>fnd_log.level_procedure);
647: END IF;
648: WHEN OTHERS THEN
649: x_return_status := fnd_api.g_ret_sts_unexp_error;
650:

Line 660: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

656: p_count => x_msg_count,
657: p_data => x_msg_data);
658:
659: -- Debug info.
660: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
661: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
662: p_msg_data=>x_msg_data,
663: p_msg_type=>'SQL ERROR',
664: p_msg_level=>fnd_log.level_error);

Line 664: p_msg_level=>fnd_log.level_error);

660: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
661: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
662: p_msg_data=>x_msg_data,
663: p_msg_type=>'SQL ERROR',
664: p_msg_level=>fnd_log.level_error);
665: END IF;
666: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
667: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',
668: p_prefix=>l_debug_prefix,

Line 666: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

662: p_msg_data=>x_msg_data,
663: p_msg_type=>'SQL ERROR',
664: p_msg_level=>fnd_log.level_error);
665: END IF;
666: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
667: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',
668: p_prefix=>l_debug_prefix,
669: p_msg_level=>fnd_log.level_procedure);
670: END IF;

Line 669: p_msg_level=>fnd_log.level_procedure);

665: END IF;
666: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
667: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',
668: p_prefix=>l_debug_prefix,
669: p_msg_level=>fnd_log.level_procedure);
670: END IF;
671: END save_cust_acct_contacts;
672:
673: END hz_cust_acct_contact_bo_pvt;