DBA Data[Home] [Help]

APPS.HZ_PARTY_SITE_BO_PVT dependencies on FND_LOG

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

111: -- initialize API return status to success.
112: x_return_status := FND_API.G_RET_STS_SUCCESS;
113:
114: -- Debug info.
115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
116: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(+)',
117: p_prefix=>l_debug_prefix,
118: p_msg_level=>fnd_log.level_procedure);
119: END IF;

Line 118: p_msg_level=>fnd_log.level_procedure);

114: -- Debug info.
115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
116: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(+)',
117: p_prefix=>l_debug_prefix,
118: p_msg_level=>fnd_log.level_procedure);
119: END IF;
120:
121: -- Create contact preferences
122: FOR i IN 1..p_psu_objs.COUNT LOOP

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

134: x_msg_data => x_msg_data
135: );
136:
137: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
139: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.create_party_site_uses: party_site_id: '||p_ps_id,
140: p_prefix=>l_debug_prefix,
141: p_msg_level=>fnd_log.level_procedure);
142: END IF;

Line 141: p_msg_level=>fnd_log.level_procedure);

137: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
139: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.create_party_site_uses: party_site_id: '||p_ps_id,
140: p_prefix=>l_debug_prefix,
141: p_msg_level=>fnd_log.level_procedure);
142: END IF;
143: RAISE fnd_api.g_exc_error;
144: END IF;
145:

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

147: p_psu_objs(i).party_site_use_id := l_psu_id;
148: END LOOP;
149:
150: -- Debug info.
151: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
152: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
153: p_msg_data=>x_msg_data,
154: p_msg_type=>'WARNING',
155: p_msg_level=>fnd_log.level_exception);

Line 155: p_msg_level=>fnd_log.level_exception);

151: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
152: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
153: p_msg_data=>x_msg_data,
154: p_msg_type=>'WARNING',
155: p_msg_level=>fnd_log.level_exception);
156: END IF;
157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
158: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
159: p_prefix=>l_debug_prefix,

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

153: p_msg_data=>x_msg_data,
154: p_msg_type=>'WARNING',
155: p_msg_level=>fnd_log.level_exception);
156: END IF;
157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
158: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
159: p_prefix=>l_debug_prefix,
160: p_msg_level=>fnd_log.level_procedure);
161: END IF;

Line 160: p_msg_level=>fnd_log.level_procedure);

156: END IF;
157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
158: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
159: p_prefix=>l_debug_prefix,
160: p_msg_level=>fnd_log.level_procedure);
161: END IF;
162: EXCEPTION
163: WHEN fnd_api.g_exc_error THEN
164: ROLLBACK TO create_party_site_uses_pvt;

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

172: p_count => x_msg_count,
173: p_data => x_msg_data);
174:
175: -- Debug info.
176: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
177: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
178: p_msg_data=>x_msg_data,
179: p_msg_type=>'ERROR',
180: p_msg_level=>fnd_log.level_error);

Line 180: p_msg_level=>fnd_log.level_error);

176: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
177: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
178: p_msg_data=>x_msg_data,
179: p_msg_type=>'ERROR',
180: p_msg_level=>fnd_log.level_error);
181: END IF;
182: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
183: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
184: p_prefix=>l_debug_prefix,

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

178: p_msg_data=>x_msg_data,
179: p_msg_type=>'ERROR',
180: p_msg_level=>fnd_log.level_error);
181: END IF;
182: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
183: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
184: p_prefix=>l_debug_prefix,
185: p_msg_level=>fnd_log.level_procedure);
186: END IF;

Line 185: p_msg_level=>fnd_log.level_procedure);

181: END IF;
182: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
183: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
184: p_prefix=>l_debug_prefix,
185: p_msg_level=>fnd_log.level_procedure);
186: END IF;
187: WHEN fnd_api.g_exc_unexpected_error THEN
188: ROLLBACK TO create_party_site_uses_pvt;
189: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

196: p_count => x_msg_count,
197: p_data => x_msg_data);
198:
199: -- Debug info.
200: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
201: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
202: p_msg_data=>x_msg_data,
203: p_msg_type=>'UNEXPECTED ERROR',
204: p_msg_level=>fnd_log.level_error);

Line 204: p_msg_level=>fnd_log.level_error);

200: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
201: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
202: p_msg_data=>x_msg_data,
203: p_msg_type=>'UNEXPECTED ERROR',
204: p_msg_level=>fnd_log.level_error);
205: END IF;
206: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
207: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
208: p_prefix=>l_debug_prefix,

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

202: p_msg_data=>x_msg_data,
203: p_msg_type=>'UNEXPECTED ERROR',
204: p_msg_level=>fnd_log.level_error);
205: END IF;
206: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
207: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
208: p_prefix=>l_debug_prefix,
209: p_msg_level=>fnd_log.level_procedure);
210: END IF;

Line 209: p_msg_level=>fnd_log.level_procedure);

205: END IF;
206: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
207: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
208: p_prefix=>l_debug_prefix,
209: p_msg_level=>fnd_log.level_procedure);
210: END IF;
211:
212: WHEN OTHERS THEN
213: ROLLBACK TO create_party_site_uses_pvt;

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

225: p_count => x_msg_count,
226: p_data => x_msg_data);
227:
228: -- Debug info.
229: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
230: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
231: p_msg_data=>x_msg_data,
232: p_msg_type=>'SQL ERROR',
233: p_msg_level=>fnd_log.level_error);

Line 233: p_msg_level=>fnd_log.level_error);

229: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
230: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
231: p_msg_data=>x_msg_data,
232: p_msg_type=>'SQL ERROR',
233: p_msg_level=>fnd_log.level_error);
234: END IF;
235: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
236: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
237: p_prefix=>l_debug_prefix,

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

231: p_msg_data=>x_msg_data,
232: p_msg_type=>'SQL ERROR',
233: p_msg_level=>fnd_log.level_error);
234: END IF;
235: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
236: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
237: p_prefix=>l_debug_prefix,
238: p_msg_level=>fnd_log.level_procedure);
239: END IF;

Line 238: p_msg_level=>fnd_log.level_procedure);

234: END IF;
235: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
236: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
237: p_prefix=>l_debug_prefix,
238: p_msg_level=>fnd_log.level_procedure);
239: END IF;
240: END create_party_site_uses;
241:
242: -- PROCEDURE save_party_site_uses

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

283: -- initialize API return status to success.
284: x_return_status := FND_API.G_RET_STS_SUCCESS;
285:
286: -- Debug info.
287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
288: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(+)',
289: p_prefix=>l_debug_prefix,
290: p_msg_level=>fnd_log.level_procedure);
291: END IF;

Line 290: p_msg_level=>fnd_log.level_procedure);

286: -- Debug info.
287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
288: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(+)',
289: p_prefix=>l_debug_prefix,
290: p_msg_level=>fnd_log.level_procedure);
291: END IF;
292:
293: -- Create/Update party site use
294: FOR i IN 1..p_psu_objs.COUNT LOOP

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

306: x_object_version_number => l_ovn
307: );
308:
309: IF(l_ovn = -1) THEN
310: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
311: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.check_party_site_use_op: party_site_id: '||p_ps_id,
312: p_prefix=>l_debug_prefix,
313: p_msg_level=>fnd_log.level_procedure);
314: END IF;

Line 313: p_msg_level=>fnd_log.level_procedure);

309: IF(l_ovn = -1) THEN
310: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
311: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.check_party_site_use_op: party_site_id: '||p_ps_id,
312: p_prefix=>l_debug_prefix,
313: p_msg_level=>fnd_log.level_procedure);
314: END IF;
315: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
316: FND_MSG_PUB.ADD;
317: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

346: p_psu_objs(i).party_site_use_id := l_psu_rec.party_site_use_id;
347: END IF;
348:
349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
350: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
351: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_site_uses: party_site_id: '||p_ps_id,
352: p_prefix=>l_debug_prefix,
353: p_msg_level=>fnd_log.level_procedure);
354: END IF;

Line 353: p_msg_level=>fnd_log.level_procedure);

349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
350: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
351: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_site_uses: party_site_id: '||p_ps_id,
352: p_prefix=>l_debug_prefix,
353: p_msg_level=>fnd_log.level_procedure);
354: END IF;
355: RAISE fnd_api.g_exc_error;
356: END IF;
357: END LOOP;

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

356: END IF;
357: END LOOP;
358:
359: -- Debug info.
360: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
361: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
362: p_msg_data=>x_msg_data,
363: p_msg_type=>'WARNING',
364: p_msg_level=>fnd_log.level_exception);

Line 364: p_msg_level=>fnd_log.level_exception);

360: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
361: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
362: p_msg_data=>x_msg_data,
363: p_msg_type=>'WARNING',
364: p_msg_level=>fnd_log.level_exception);
365: END IF;
366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
367: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
368: p_prefix=>l_debug_prefix,

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

362: p_msg_data=>x_msg_data,
363: p_msg_type=>'WARNING',
364: p_msg_level=>fnd_log.level_exception);
365: END IF;
366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
367: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
368: p_prefix=>l_debug_prefix,
369: p_msg_level=>fnd_log.level_procedure);
370: END IF;

Line 369: p_msg_level=>fnd_log.level_procedure);

365: END IF;
366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
367: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
368: p_prefix=>l_debug_prefix,
369: p_msg_level=>fnd_log.level_procedure);
370: END IF;
371: EXCEPTION
372: WHEN fnd_api.g_exc_error THEN
373: ROLLBACK TO save_party_site_uses_pvt;

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

381: p_count => x_msg_count,
382: p_data => x_msg_data);
383:
384: -- Debug info.
385: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
386: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
387: p_msg_data=>x_msg_data,
388: p_msg_type=>'ERROR',
389: p_msg_level=>fnd_log.level_error);

Line 389: p_msg_level=>fnd_log.level_error);

385: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
386: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
387: p_msg_data=>x_msg_data,
388: p_msg_type=>'ERROR',
389: p_msg_level=>fnd_log.level_error);
390: END IF;
391: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
392: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
393: p_prefix=>l_debug_prefix,

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

387: p_msg_data=>x_msg_data,
388: p_msg_type=>'ERROR',
389: p_msg_level=>fnd_log.level_error);
390: END IF;
391: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
392: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
393: p_prefix=>l_debug_prefix,
394: p_msg_level=>fnd_log.level_procedure);
395: END IF;

Line 394: p_msg_level=>fnd_log.level_procedure);

390: END IF;
391: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
392: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
393: p_prefix=>l_debug_prefix,
394: p_msg_level=>fnd_log.level_procedure);
395: END IF;
396: WHEN fnd_api.g_exc_unexpected_error THEN
397: ROLLBACK TO save_party_site_uses_pvt;
398: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

405: p_count => x_msg_count,
406: p_data => x_msg_data);
407:
408: -- Debug info.
409: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
410: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
411: p_msg_data=>x_msg_data,
412: p_msg_type=>'UNEXPECTED ERROR',
413: p_msg_level=>fnd_log.level_error);

Line 413: p_msg_level=>fnd_log.level_error);

409: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
410: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
411: p_msg_data=>x_msg_data,
412: p_msg_type=>'UNEXPECTED ERROR',
413: p_msg_level=>fnd_log.level_error);
414: END IF;
415: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
416: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
417: p_prefix=>l_debug_prefix,

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

411: p_msg_data=>x_msg_data,
412: p_msg_type=>'UNEXPECTED ERROR',
413: p_msg_level=>fnd_log.level_error);
414: END IF;
415: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
416: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
417: p_prefix=>l_debug_prefix,
418: p_msg_level=>fnd_log.level_procedure);
419: END IF;

Line 418: p_msg_level=>fnd_log.level_procedure);

414: END IF;
415: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
416: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
417: p_prefix=>l_debug_prefix,
418: p_msg_level=>fnd_log.level_procedure);
419: END IF;
420:
421: WHEN OTHERS THEN
422: ROLLBACK TO save_party_site_uses_pvt;

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

434: p_count => x_msg_count,
435: p_data => x_msg_data);
436:
437: -- Debug info.
438: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
439: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
440: p_msg_data=>x_msg_data,
441: p_msg_type=>'SQL ERROR',
442: p_msg_level=>fnd_log.level_error);

Line 442: p_msg_level=>fnd_log.level_error);

438: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
439: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
440: p_msg_data=>x_msg_data,
441: p_msg_type=>'SQL ERROR',
442: p_msg_level=>fnd_log.level_error);
443: END IF;
444: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
445: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
446: p_prefix=>l_debug_prefix,

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

440: p_msg_data=>x_msg_data,
441: p_msg_type=>'SQL ERROR',
442: p_msg_level=>fnd_log.level_error);
443: END IF;
444: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
445: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
446: p_prefix=>l_debug_prefix,
447: p_msg_level=>fnd_log.level_procedure);
448: END IF;

Line 447: p_msg_level=>fnd_log.level_procedure);

443: END IF;
444: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
445: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
446: p_prefix=>l_debug_prefix,
447: p_msg_level=>fnd_log.level_procedure);
448: END IF;
449: END save_party_site_uses;
450:
451: -- PROCEDURE save_party_sites

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

503: -- initialize API return status to success.
504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505:
506: -- Debug info.
507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
508: hz_utility_v2pub.debug(p_message=>'save_party_sites(+)',
509: p_prefix=>l_debug_prefix,
510: p_msg_level=>fnd_log.level_procedure);
511: END IF;

Line 510: p_msg_level=>fnd_log.level_procedure);

506: -- Debug info.
507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
508: hz_utility_v2pub.debug(p_message=>'save_party_sites(+)',
509: p_prefix=>l_debug_prefix,
510: p_msg_level=>fnd_log.level_procedure);
511: END IF;
512:
513: l_parent_id := p_parent_id;
514: l_parent_os := p_parent_os;

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

540: px_parent_obj_type => l_parent_obj_type
541: );
542:
543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
545: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_sites_bo, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
546: p_prefix=>l_debug_prefix,
547: p_msg_level=>fnd_log.level_procedure);
548: END IF;

Line 547: p_msg_level=>fnd_log.level_procedure);

543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
545: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_sites_bo, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
546: p_prefix=>l_debug_prefix,
547: p_msg_level=>fnd_log.level_procedure);
548: END IF;
549: RAISE fnd_api.g_exc_error;
550: END IF;
551:

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

574: px_parent_obj_type => l_parent_obj_type
575: );
576:
577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
578: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
579: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_sites_bo, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
580: p_prefix=>l_debug_prefix,
581: p_msg_level=>fnd_log.level_procedure);
582: END IF;

Line 581: p_msg_level=>fnd_log.level_procedure);

577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
578: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
579: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_sites_bo, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
580: p_prefix=>l_debug_prefix,
581: p_msg_level=>fnd_log.level_procedure);
582: END IF;
583: RAISE fnd_api.g_exc_error;
584: END IF;
585:

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

587: END LOOP;
588: END IF;
589:
590: -- Debug info.
591: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
592: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
593: p_msg_data=>x_msg_data,
594: p_msg_type=>'WARNING',
595: p_msg_level=>fnd_log.level_exception);

Line 595: p_msg_level=>fnd_log.level_exception);

591: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
592: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
593: p_msg_data=>x_msg_data,
594: p_msg_type=>'WARNING',
595: p_msg_level=>fnd_log.level_exception);
596: END IF;
597: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
598: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
599: p_prefix=>l_debug_prefix,

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

593: p_msg_data=>x_msg_data,
594: p_msg_type=>'WARNING',
595: p_msg_level=>fnd_log.level_exception);
596: END IF;
597: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
598: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
599: p_prefix=>l_debug_prefix,
600: p_msg_level=>fnd_log.level_procedure);
601: END IF;

Line 600: p_msg_level=>fnd_log.level_procedure);

596: END IF;
597: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
598: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
599: p_prefix=>l_debug_prefix,
600: p_msg_level=>fnd_log.level_procedure);
601: END IF;
602:
603: EXCEPTION
604: WHEN fnd_api.g_exc_error THEN

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

608: p_count => x_msg_count,
609: p_data => x_msg_data);
610:
611: -- Debug info.
612: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
613: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
614: p_msg_data=>x_msg_data,
615: p_msg_type=>'ERROR',
616: p_msg_level=>fnd_log.level_error);

Line 616: p_msg_level=>fnd_log.level_error);

612: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
613: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
614: p_msg_data=>x_msg_data,
615: p_msg_type=>'ERROR',
616: p_msg_level=>fnd_log.level_error);
617: END IF;
618: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
619: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
620: p_prefix=>l_debug_prefix,

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

614: p_msg_data=>x_msg_data,
615: p_msg_type=>'ERROR',
616: p_msg_level=>fnd_log.level_error);
617: END IF;
618: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
619: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
620: p_prefix=>l_debug_prefix,
621: p_msg_level=>fnd_log.level_procedure);
622: END IF;

Line 621: p_msg_level=>fnd_log.level_procedure);

617: END IF;
618: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
619: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
620: p_prefix=>l_debug_prefix,
621: p_msg_level=>fnd_log.level_procedure);
622: END IF;
623: WHEN fnd_api.g_exc_unexpected_error THEN
624: x_return_status := fnd_api.g_ret_sts_unexp_error;
625:

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

627: p_count => x_msg_count,
628: p_data => x_msg_data);
629:
630: -- Debug info.
631: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
632: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
633: p_msg_data=>x_msg_data,
634: p_msg_type=>'UNEXPECTED ERROR',
635: p_msg_level=>fnd_log.level_error);

Line 635: p_msg_level=>fnd_log.level_error);

631: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
632: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
633: p_msg_data=>x_msg_data,
634: p_msg_type=>'UNEXPECTED ERROR',
635: p_msg_level=>fnd_log.level_error);
636: END IF;
637: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
638: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
639: p_prefix=>l_debug_prefix,

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

633: p_msg_data=>x_msg_data,
634: p_msg_type=>'UNEXPECTED ERROR',
635: p_msg_level=>fnd_log.level_error);
636: END IF;
637: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
638: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
639: p_prefix=>l_debug_prefix,
640: p_msg_level=>fnd_log.level_procedure);
641: END IF;

Line 640: p_msg_level=>fnd_log.level_procedure);

636: END IF;
637: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
638: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
639: p_prefix=>l_debug_prefix,
640: p_msg_level=>fnd_log.level_procedure);
641: END IF;
642:
643: WHEN OTHERS THEN
644: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

651: p_count => x_msg_count,
652: p_data => x_msg_data);
653:
654: -- Debug info.
655: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
656: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
657: p_msg_data=>x_msg_data,
658: p_msg_type=>'SQL ERROR',
659: p_msg_level=>fnd_log.level_error);

Line 659: p_msg_level=>fnd_log.level_error);

655: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
656: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
657: p_msg_data=>x_msg_data,
658: p_msg_type=>'SQL ERROR',
659: p_msg_level=>fnd_log.level_error);
660: END IF;
661: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
662: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
663: p_prefix=>l_debug_prefix,

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

657: p_msg_data=>x_msg_data,
658: p_msg_type=>'SQL ERROR',
659: p_msg_level=>fnd_log.level_error);
660: END IF;
661: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
662: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
663: p_prefix=>l_debug_prefix,
664: p_msg_level=>fnd_log.level_procedure);
665: END IF;

Line 664: p_msg_level=>fnd_log.level_procedure);

660: END IF;
661: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
662: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
663: p_prefix=>l_debug_prefix,
664: p_msg_level=>fnd_log.level_procedure);
665: END IF;
666: END save_party_sites;
667:
668: END hz_party_site_bo_pvt;