DBA Data[Home] [Help]

APPS.HZ_CONTACT_POINT_BO_PVT dependencies on HZ_UTILITY_V2PUB

Line 74: hz_utility_v2pub.debug(p_message=>'save_contact_points(+)',

70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: -- Debug info.
73: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
74: hz_utility_v2pub.debug(p_message=>'save_contact_points(+)',
75: p_prefix=>l_debug_prefix,
76: p_msg_level=>fnd_log.level_procedure);
77: END IF;
78:

Line 84: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

80: l_owner_table_os := p_owner_table_os;
81: l_owner_table_osr := p_owner_table_osr;
82: l_parent_obj_type := p_parent_obj_type;
83:
84: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
85:
86: IF(p_create_update_flag = 'C') THEN
87: -----------------------------
88: -- Create phone contact point

Line 109: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

105: p_eft_obj => NULL,
106: p_sms_obj => NULL,
107: p_cp_pref_objs => p_phone_objs(i).contact_pref_objs,
108: p_cp_type => l_current_cp_type,
109: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
110: p_obj_source => p_obj_source,
111: x_return_status => x_return_status,
112: x_msg_count => x_msg_count,
113: x_msg_data => x_msg_data,

Line 124: hz_utility_v2pub.debug(p_message=>'Create PHONE - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,

120: px_parent_obj_type => l_parent_obj_type
121: );
122: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
123: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
124: hz_utility_v2pub.debug(p_message=>'Create PHONE - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
125: p_prefix=>l_debug_prefix,
126: p_msg_level=>fnd_log.level_procedure);
127: END IF;
128: RAISE FND_API.G_EXC_ERROR;

Line 131: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

127: END IF;
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;
130:
131: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
132: p_phone_objs(i).phone_id := l_cp_id;
133: END LOOP;
134: END IF;
135:

Line 158: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

154: p_eft_obj => NULL,
155: p_sms_obj => NULL,
156: p_cp_pref_objs => p_telex_objs(i).contact_pref_objs,
157: p_cp_type => l_current_cp_type,
158: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
159: p_obj_source => p_obj_source,
160: x_return_status => x_return_status,
161: x_msg_count => x_msg_count,
162: x_msg_data => x_msg_data,

Line 173: hz_utility_v2pub.debug(p_message=>'Create TLX - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,

169: px_parent_obj_type => l_parent_obj_type
170: );
171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
172: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
173: hz_utility_v2pub.debug(p_message=>'Create TLX - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
174: p_prefix=>l_debug_prefix,
175: p_msg_level=>fnd_log.level_procedure);
176: END IF;
177: RAISE FND_API.G_EXC_ERROR;

Line 180: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

176: END IF;
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
179:
180: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
181: p_telex_objs(i).telex_id := l_cp_id;
182: END LOOP;
183: END IF;
184:

Line 207: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

203: p_eft_obj => NULL,
204: p_sms_obj => NULL,
205: p_cp_pref_objs => p_email_objs(i).contact_pref_objs,
206: p_cp_type => l_current_cp_type,
207: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
208: p_obj_source => p_obj_source,
209: x_return_status => x_return_status,
210: x_msg_count => x_msg_count,
211: x_msg_data => x_msg_data,

Line 222: hz_utility_v2pub.debug(p_message=>'Create EMAIL - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,

218: px_parent_obj_type => l_parent_obj_type
219: );
220: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
222: hz_utility_v2pub.debug(p_message=>'Create EMAIL - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
223: p_prefix=>l_debug_prefix,
224: p_msg_level=>fnd_log.level_procedure);
225: END IF;
226: RAISE FND_API.G_EXC_ERROR;

Line 229: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

225: END IF;
226: RAISE FND_API.G_EXC_ERROR;
227: END IF;
228:
229: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
230: p_email_objs(i).email_id := l_cp_id;
231: END LOOP;
232: END IF;
233:

Line 256: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

252: p_eft_obj => NULL,
253: p_sms_obj => NULL,
254: p_cp_pref_objs => p_web_objs(i).contact_pref_objs,
255: p_cp_type => l_current_cp_type,
256: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
257: p_obj_source => p_obj_source,
258: x_return_status => x_return_status,
259: x_msg_count => x_msg_count,
260: x_msg_data => x_msg_data,

Line 271: hz_utility_v2pub.debug(p_message=>'Create WEB - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,

267: px_parent_obj_type => l_parent_obj_type
268: );
269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
271: hz_utility_v2pub.debug(p_message=>'Create WEB - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
272: p_prefix=>l_debug_prefix,
273: p_msg_level=>fnd_log.level_procedure);
274: END IF;
275: RAISE FND_API.G_EXC_ERROR;

Line 278: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

274: END IF;
275: RAISE FND_API.G_EXC_ERROR;
276: END IF;
277:
278: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
279: p_web_objs(i).web_id := l_cp_id;
280: END LOOP;
281: END IF;
282:

Line 305: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

301: p_eft_obj => NULL,
302: p_sms_obj => NULL,
303: p_cp_pref_objs => p_edi_objs(i).contact_pref_objs,
304: p_cp_type => l_current_cp_type,
305: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
306: p_obj_source => p_obj_source,
307: x_return_status => x_return_status,
308: x_msg_count => x_msg_count,
309: x_msg_data => x_msg_data,

Line 320: hz_utility_v2pub.debug(p_message=>'Create EDI - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,

316: px_parent_obj_type => l_parent_obj_type
317: );
318: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
319: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
320: hz_utility_v2pub.debug(p_message=>'Create EDI - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
321: p_prefix=>l_debug_prefix,
322: p_msg_level=>fnd_log.level_procedure);
323: END IF;
324: RAISE FND_API.G_EXC_ERROR;

Line 327: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

323: END IF;
324: RAISE FND_API.G_EXC_ERROR;
325: END IF;
326:
327: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
328: p_edi_objs(i).edi_id := l_cp_id;
329: END LOOP;
330: END IF;
331:

Line 354: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

350: p_eft_obj => p_eft_objs(i),
351: p_sms_obj => NULL,
352: p_cp_pref_objs => p_eft_objs(i).contact_pref_objs,
353: p_cp_type => l_current_cp_type,
354: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
355: p_obj_source => p_obj_source,
356: x_return_status => x_return_status,
357: x_msg_count => x_msg_count,
358: x_msg_data => x_msg_data,

Line 369: hz_utility_v2pub.debug(p_message=>'Create EFT - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,

365: px_parent_obj_type => l_parent_obj_type
366: );
367: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
368: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
369: hz_utility_v2pub.debug(p_message=>'Create EFT - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
370: p_prefix=>l_debug_prefix,
371: p_msg_level=>fnd_log.level_procedure);
372: END IF;
373: RAISE FND_API.G_EXC_ERROR;

Line 376: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

372: END IF;
373: RAISE FND_API.G_EXC_ERROR;
374: END IF;
375:
376: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
377: p_eft_objs(i).eft_id := l_cp_id;
378: END LOOP;
379: END IF;
380:

Line 403: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

399: p_eft_obj => NULL,
400: p_sms_obj => p_sms_objs(i),
401: p_cp_pref_objs => p_sms_objs(i).contact_pref_objs,
402: p_cp_type => l_current_cp_type,
403: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
404: p_obj_source => p_obj_source,
405: x_return_status => x_return_status,
406: x_msg_count => x_msg_count,
407: x_msg_data => x_msg_data,

Line 418: hz_utility_v2pub.debug(p_message=>'Create SMS - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,

414: px_parent_obj_type => l_parent_obj_type
415: );
416: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
417: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
418: hz_utility_v2pub.debug(p_message=>'Create SMS - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
419: p_prefix=>l_debug_prefix,
420: p_msg_level=>fnd_log.level_procedure);
421: END IF;
422: RAISE FND_API.G_EXC_ERROR;

Line 425: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

421: END IF;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424:
425: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
426: p_sms_objs(i).sms_id := l_cp_id;
427: END LOOP;
428: END IF;
429: ELSE

Line 452: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

448: p_eft_obj => NULL,
449: p_sms_obj => NULL,
450: p_cp_pref_objs => p_phone_objs(i).contact_pref_objs,
451: p_cp_type => l_current_cp_type,
452: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
453: p_obj_source => p_obj_source,
454: x_return_status => x_return_status,
455: x_msg_count => x_msg_count,
456: x_msg_data => x_msg_data,

Line 467: hz_utility_v2pub.debug(p_message=>'Save PHONE - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,

463: px_parent_obj_type => l_parent_obj_type
464: );
465: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
466: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
467: hz_utility_v2pub.debug(p_message=>'Save PHONE - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
468: p_prefix=>l_debug_prefix,
469: p_msg_level=>fnd_log.level_procedure);
470: END IF;
471: RAISE FND_API.G_EXC_ERROR;

Line 474: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

470: END IF;
471: RAISE FND_API.G_EXC_ERROR;
472: END IF;
473:
474: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
475: p_phone_objs(i).phone_id := l_cp_id;
476: END LOOP;
477: END IF;
478:

Line 501: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

497: p_eft_obj => NULL,
498: p_sms_obj => NULL,
499: p_cp_pref_objs => p_telex_objs(i).contact_pref_objs,
500: p_cp_type => l_current_cp_type,
501: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
502: p_obj_source => p_obj_source,
503: x_return_status => x_return_status,
504: x_msg_count => x_msg_count,
505: x_msg_data => x_msg_data,

Line 516: hz_utility_v2pub.debug(p_message=>'Save TLX - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,

512: px_parent_obj_type => l_parent_obj_type
513: );
514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
515: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
516: hz_utility_v2pub.debug(p_message=>'Save TLX - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
517: p_prefix=>l_debug_prefix,
518: p_msg_level=>fnd_log.level_procedure);
519: END IF;
520: RAISE FND_API.G_EXC_ERROR;

Line 523: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

519: END IF;
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;
522:
523: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
524: p_telex_objs(i).telex_id := l_cp_id;
525: END LOOP;
526: END IF;
527:

Line 550: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

546: p_eft_obj => NULL,
547: p_sms_obj => NULL,
548: p_cp_pref_objs => p_email_objs(i).contact_pref_objs,
549: p_cp_type => l_current_cp_type,
550: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
551: p_obj_source => p_obj_source,
552: x_return_status => x_return_status,
553: x_msg_count => x_msg_count,
554: x_msg_data => x_msg_data,

Line 565: hz_utility_v2pub.debug(p_message=>'Save EMAIL - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,

561: px_parent_obj_type => l_parent_obj_type
562: );
563: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
564: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
565: hz_utility_v2pub.debug(p_message=>'Save EMAIL - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
566: p_prefix=>l_debug_prefix,
567: p_msg_level=>fnd_log.level_procedure);
568: END IF;
569: RAISE FND_API.G_EXC_ERROR;

Line 572: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

568: END IF;
569: RAISE FND_API.G_EXC_ERROR;
570: END IF;
571:
572: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
573: p_email_objs(i).email_id := l_cp_id;
574: END LOOP;
575: END IF;
576:

Line 599: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

595: p_eft_obj => NULL,
596: p_sms_obj => NULL,
597: p_cp_pref_objs => p_web_objs(i).contact_pref_objs,
598: p_cp_type => l_current_cp_type,
599: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
600: p_obj_source => p_obj_source,
601: x_return_status => x_return_status,
602: x_msg_count => x_msg_count,
603: x_msg_data => x_msg_data,

Line 614: hz_utility_v2pub.debug(p_message=>'Save WEB - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,

610: px_parent_obj_type => l_parent_obj_type
611: );
612: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
613: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
614: hz_utility_v2pub.debug(p_message=>'Save WEB - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
615: p_prefix=>l_debug_prefix,
616: p_msg_level=>fnd_log.level_procedure);
617: END IF;
618: RAISE FND_API.G_EXC_ERROR;

Line 621: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

617: END IF;
618: RAISE FND_API.G_EXC_ERROR;
619: END IF;
620:
621: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
622: p_web_objs(i).web_id := l_cp_id;
623: END LOOP;
624: END IF;
625:

Line 648: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

644: p_eft_obj => NULL,
645: p_sms_obj => NULL,
646: p_cp_pref_objs => p_edi_objs(i).contact_pref_objs,
647: p_cp_type => l_current_cp_type,
648: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
649: p_obj_source => p_obj_source,
650: x_return_status => x_return_status,
651: x_msg_count => x_msg_count,
652: x_msg_data => x_msg_data,

Line 663: hz_utility_v2pub.debug(p_message=>'Save EDI - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,

659: px_parent_obj_type => l_parent_obj_type
660: );
661: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
662: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
663: hz_utility_v2pub.debug(p_message=>'Save EDI - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
664: p_prefix=>l_debug_prefix,
665: p_msg_level=>fnd_log.level_procedure);
666: END IF;
667: RAISE FND_API.G_EXC_ERROR;

Line 670: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

666: END IF;
667: RAISE FND_API.G_EXC_ERROR;
668: END IF;
669:
670: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
671: p_edi_objs(i).edi_id := l_cp_id;
672: END LOOP;
673: END IF;
674:

Line 697: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

693: p_eft_obj => p_eft_objs(i),
694: p_sms_obj => NULL,
695: p_cp_pref_objs => p_eft_objs(i).contact_pref_objs,
696: p_cp_type => l_current_cp_type,
697: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
698: p_obj_source => p_obj_source,
699: x_return_status => x_return_status,
700: x_msg_count => x_msg_count,
701: x_msg_data => x_msg_data,

Line 712: hz_utility_v2pub.debug(p_message=>'Save EFT - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,

708: px_parent_obj_type => l_parent_obj_type
709: );
710: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
711: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
712: hz_utility_v2pub.debug(p_message=>'Save EFT - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
713: p_prefix=>l_debug_prefix,
714: p_msg_level=>fnd_log.level_procedure);
715: END IF;
716: RAISE FND_API.G_EXC_ERROR;

Line 719: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

715: END IF;
716: RAISE FND_API.G_EXC_ERROR;
717: END IF;
718:
719: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
720: p_eft_objs(i).eft_id := l_cp_id;
721: END LOOP;
722: END IF;
723:

Line 746: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

742: p_eft_obj => NULL,
743: p_sms_obj => p_sms_objs(i),
744: p_cp_pref_objs => p_sms_objs(i).contact_pref_objs,
745: p_cp_type => l_current_cp_type,
746: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
747: p_obj_source => p_obj_source,
748: x_return_status => x_return_status,
749: x_msg_count => x_msg_count,
750: x_msg_data => x_msg_data,

Line 761: hz_utility_v2pub.debug(p_message=>'Save SMS - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,

757: px_parent_obj_type => l_parent_obj_type
758: );
759: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
760: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
761: hz_utility_v2pub.debug(p_message=>'Save SMS - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
762: p_prefix=>l_debug_prefix,
763: p_msg_level=>fnd_log.level_procedure);
764: END IF;
765: RAISE FND_API.G_EXC_ERROR;

Line 768: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

764: END IF;
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
767:
768: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
769: p_sms_objs(i).sms_id := l_cp_id;
770: END LOOP;
771: END IF;
772: END IF;

Line 776: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

772: END IF;
773:
774: -- Debug info.
775: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
776: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
777: p_msg_data=>x_msg_data,
778: p_msg_type=>'WARNING',
779: p_msg_level=>fnd_log.level_exception);
780: END IF;

Line 782: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',

778: p_msg_type=>'WARNING',
779: p_msg_level=>fnd_log.level_exception);
780: END IF;
781: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
782: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',
783: p_prefix=>l_debug_prefix,
784: p_msg_level=>fnd_log.level_procedure);
785: END IF;
786: EXCEPTION

Line 795: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

791: p_data => x_msg_data);
792:
793: -- Debug info.
794: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
795: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
796: p_msg_data=>x_msg_data,
797: p_msg_type=>'ERROR',
798: p_msg_level=>fnd_log.level_error);
799: END IF;

Line 801: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',

797: p_msg_type=>'ERROR',
798: p_msg_level=>fnd_log.level_error);
799: END IF;
800: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
801: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',
802: p_prefix=>l_debug_prefix,
803: p_msg_level=>fnd_log.level_procedure);
804: END IF;
805:

Line 815: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

811: p_data => x_msg_data);
812:
813: -- Debug info.
814: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
815: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
816: p_msg_data=>x_msg_data,
817: p_msg_type=>'UNEXPECTED ERROR',
818: p_msg_level=>fnd_log.level_error);
819: END IF;

Line 821: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',

817: p_msg_type=>'UNEXPECTED ERROR',
818: p_msg_level=>fnd_log.level_error);
819: END IF;
820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
821: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',
822: p_prefix=>l_debug_prefix,
823: p_msg_level=>fnd_log.level_procedure);
824: END IF;
825: WHEN OTHERS THEN

Line 838: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

834: p_data => x_msg_data);
835:
836: -- Debug info.
837: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
838: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
839: p_msg_data=>x_msg_data,
840: p_msg_type=>'SQL ERROR',
841: p_msg_level=>fnd_log.level_error);
842: END IF;

Line 844: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',

840: p_msg_type=>'SQL ERROR',
841: p_msg_level=>fnd_log.level_error);
842: END IF;
843: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
844: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',
845: p_prefix=>l_debug_prefix,
846: p_msg_level=>fnd_log.level_procedure);
847: END IF;
848: END save_contact_points;