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;
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
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;
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:
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);
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,
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;
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;
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);
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,
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;
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');
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);
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,
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;
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;
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);
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,
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;
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
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;
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
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;
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');
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;
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;
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);
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,
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;
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;
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);
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,
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;
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');
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);
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,
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;
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;
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);
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,
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;
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
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;
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;
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;
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:
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;
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:
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);
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,
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;
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
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);
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,
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;
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:
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);
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,
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;
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;
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);
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,
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;
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;