eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CONTACT_POINT_BO_PVT dependencies on FND_API

Line 27: -- be fnd_api.g_ret_sts_success (success),

23: -- p_parent_obj_type Parent object type.
24: -- p_create_update_flag Create or update flag.
25: -- OUT:
26: -- x_return_status Return status after the call. The status can
27: -- be fnd_api.g_ret_sts_success (success),
28: -- fnd_api.g_ret_sts_error (error),
29: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
30: -- x_msg_count Number of messages in message stack.
31: -- x_msg_data Message text if x_msg_count is 1.

Line 28: -- fnd_api.g_ret_sts_error (error),

24: -- p_create_update_flag Create or update flag.
25: -- OUT:
26: -- x_return_status Return status after the call. The status can
27: -- be fnd_api.g_ret_sts_success (success),
28: -- fnd_api.g_ret_sts_error (error),
29: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
30: -- x_msg_count Number of messages in message stack.
31: -- x_msg_data Message text if x_msg_count is 1.
32: --

Line 29: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

25: -- OUT:
26: -- x_return_status Return status after the call. The status can
27: -- be fnd_api.g_ret_sts_success (success),
28: -- fnd_api.g_ret_sts_error (error),
29: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
30: -- x_msg_count Number of messages in message stack.
31: -- x_msg_data Message text if x_msg_count is 1.
32: --
33: -- NOTES

Line 70: x_return_status := FND_API.G_RET_STS_SUCCESS;

66: l_current_cp_type VARCHAR2(30);
67: l_cbm VARCHAR2(30);
68: BEGIN
69: -- initialize API return status to success.
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(+)',

Line 95: p_init_msg_list => FND_API.G_FALSE,

91: l_current_cp_type := 'PHONE';
92:
93: FOR i IN 1..p_phone_objs.COUNT LOOP
94: HZ_CONTACT_POINT_BO_PUB.do_create_contact_point(
95: p_init_msg_list => FND_API.G_FALSE,
96: p_validate_bo_flag => FND_API.G_FALSE,
97: p_cp_id => p_phone_objs(i).phone_id,
98: p_cp_os => p_phone_objs(i).orig_system,
99: p_cp_osr => p_phone_objs(i).orig_system_reference,

Line 96: p_validate_bo_flag => FND_API.G_FALSE,

92:
93: FOR i IN 1..p_phone_objs.COUNT LOOP
94: HZ_CONTACT_POINT_BO_PUB.do_create_contact_point(
95: p_init_msg_list => FND_API.G_FALSE,
96: p_validate_bo_flag => FND_API.G_FALSE,
97: p_cp_id => p_phone_objs(i).phone_id,
98: p_cp_os => p_phone_objs(i).orig_system,
99: p_cp_osr => p_phone_objs(i).orig_system_reference,
100: p_phone_obj => p_phone_objs(i),

Line 122: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

118: px_parent_os => l_owner_table_os,
119: px_parent_osr => 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);

Line 128: RAISE FND_API.G_EXC_ERROR;

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;
129: END IF;
130:
131: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
132: p_phone_objs(i).phone_id := l_cp_id;

Line 144: p_init_msg_list => FND_API.G_FALSE,

140: l_current_cp_type := 'TLX';
141:
142: FOR i IN 1..p_telex_objs.COUNT LOOP
143: HZ_CONTACT_POINT_BO_PUB.do_create_contact_point(
144: p_init_msg_list => FND_API.G_FALSE,
145: p_validate_bo_flag => FND_API.G_FALSE,
146: p_cp_id => p_telex_objs(i).telex_id,
147: p_cp_os => p_telex_objs(i).orig_system,
148: p_cp_osr => p_telex_objs(i).orig_system_reference,

Line 145: p_validate_bo_flag => FND_API.G_FALSE,

141:
142: FOR i IN 1..p_telex_objs.COUNT LOOP
143: HZ_CONTACT_POINT_BO_PUB.do_create_contact_point(
144: p_init_msg_list => FND_API.G_FALSE,
145: p_validate_bo_flag => FND_API.G_FALSE,
146: p_cp_id => p_telex_objs(i).telex_id,
147: p_cp_os => p_telex_objs(i).orig_system,
148: p_cp_osr => p_telex_objs(i).orig_system_reference,
149: p_phone_obj => NULL,

Line 171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

167: px_parent_os => l_owner_table_os,
168: px_parent_osr => 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);

Line 177: RAISE FND_API.G_EXC_ERROR;

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;
178: END IF;
179:
180: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
181: p_telex_objs(i).telex_id := l_cp_id;

Line 193: p_init_msg_list => FND_API.G_FALSE,

189: l_current_cp_type := 'EMAIL';
190:
191: FOR i IN 1..p_email_objs.COUNT LOOP
192: HZ_CONTACT_POINT_BO_PUB.do_create_contact_point(
193: p_init_msg_list => FND_API.G_FALSE,
194: p_validate_bo_flag => FND_API.G_FALSE,
195: p_cp_id => p_email_objs(i).email_id,
196: p_cp_os => p_email_objs(i).orig_system,
197: p_cp_osr => p_email_objs(i).orig_system_reference,

Line 194: p_validate_bo_flag => FND_API.G_FALSE,

190:
191: FOR i IN 1..p_email_objs.COUNT LOOP
192: HZ_CONTACT_POINT_BO_PUB.do_create_contact_point(
193: p_init_msg_list => FND_API.G_FALSE,
194: p_validate_bo_flag => FND_API.G_FALSE,
195: p_cp_id => p_email_objs(i).email_id,
196: p_cp_os => p_email_objs(i).orig_system,
197: p_cp_osr => p_email_objs(i).orig_system_reference,
198: p_phone_obj => NULL,

Line 220: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

216: px_parent_os => l_owner_table_os,
217: px_parent_osr => 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);

Line 226: RAISE FND_API.G_EXC_ERROR;

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;
227: END IF;
228:
229: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
230: p_email_objs(i).email_id := l_cp_id;

Line 242: p_init_msg_list => FND_API.G_FALSE,

238: l_current_cp_type := 'WEB';
239:
240: FOR i IN 1..p_web_objs.COUNT LOOP
241: HZ_CONTACT_POINT_BO_PUB.do_create_contact_point(
242: p_init_msg_list => FND_API.G_FALSE,
243: p_validate_bo_flag => FND_API.G_FALSE,
244: p_cp_id => p_web_objs(i).web_id,
245: p_cp_os => p_web_objs(i).orig_system,
246: p_cp_osr => p_web_objs(i).orig_system_reference,

Line 243: p_validate_bo_flag => FND_API.G_FALSE,

239:
240: FOR i IN 1..p_web_objs.COUNT LOOP
241: HZ_CONTACT_POINT_BO_PUB.do_create_contact_point(
242: p_init_msg_list => FND_API.G_FALSE,
243: p_validate_bo_flag => FND_API.G_FALSE,
244: p_cp_id => p_web_objs(i).web_id,
245: p_cp_os => p_web_objs(i).orig_system,
246: p_cp_osr => p_web_objs(i).orig_system_reference,
247: p_phone_obj => NULL,

Line 269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

265: px_parent_os => l_owner_table_os,
266: px_parent_osr => 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);

Line 275: RAISE FND_API.G_EXC_ERROR;

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;
276: END IF;
277:
278: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
279: p_web_objs(i).web_id := l_cp_id;

Line 291: p_init_msg_list => FND_API.G_FALSE,

287: l_current_cp_type := 'EDI';
288:
289: FOR i IN 1..p_edi_objs.COUNT LOOP
290: HZ_CONTACT_POINT_BO_PUB.do_create_contact_point(
291: p_init_msg_list => FND_API.G_FALSE,
292: p_validate_bo_flag => FND_API.G_FALSE,
293: p_cp_id => p_edi_objs(i).edi_id,
294: p_cp_os => p_edi_objs(i).orig_system,
295: p_cp_osr => p_edi_objs(i).orig_system_reference,

Line 292: p_validate_bo_flag => FND_API.G_FALSE,

288:
289: FOR i IN 1..p_edi_objs.COUNT LOOP
290: HZ_CONTACT_POINT_BO_PUB.do_create_contact_point(
291: p_init_msg_list => FND_API.G_FALSE,
292: p_validate_bo_flag => FND_API.G_FALSE,
293: p_cp_id => p_edi_objs(i).edi_id,
294: p_cp_os => p_edi_objs(i).orig_system,
295: p_cp_osr => p_edi_objs(i).orig_system_reference,
296: p_phone_obj => NULL,

Line 318: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

314: px_parent_os => l_owner_table_os,
315: px_parent_osr => 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);

Line 324: RAISE FND_API.G_EXC_ERROR;

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;
325: END IF;
326:
327: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
328: p_edi_objs(i).edi_id := l_cp_id;

Line 340: p_init_msg_list => FND_API.G_FALSE,

336: l_current_cp_type := 'EFT';
337:
338: FOR i IN 1..p_eft_objs.COUNT LOOP
339: HZ_CONTACT_POINT_BO_PUB.do_create_contact_point(
340: p_init_msg_list => FND_API.G_FALSE,
341: p_validate_bo_flag => FND_API.G_FALSE,
342: p_cp_id => p_eft_objs(i).eft_id,
343: p_cp_os => p_eft_objs(i).orig_system,
344: p_cp_osr => p_eft_objs(i).orig_system_reference,

Line 341: p_validate_bo_flag => FND_API.G_FALSE,

337:
338: FOR i IN 1..p_eft_objs.COUNT LOOP
339: HZ_CONTACT_POINT_BO_PUB.do_create_contact_point(
340: p_init_msg_list => FND_API.G_FALSE,
341: p_validate_bo_flag => FND_API.G_FALSE,
342: p_cp_id => p_eft_objs(i).eft_id,
343: p_cp_os => p_eft_objs(i).orig_system,
344: p_cp_osr => p_eft_objs(i).orig_system_reference,
345: p_phone_obj => NULL,

Line 367: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

363: px_parent_os => l_owner_table_os,
364: px_parent_osr => 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);

Line 373: RAISE FND_API.G_EXC_ERROR;

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;
374: END IF;
375:
376: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
377: p_eft_objs(i).eft_id := l_cp_id;

Line 389: p_init_msg_list => FND_API.G_FALSE,

385: l_current_cp_type := 'SMS';
386:
387: FOR i IN 1..p_sms_objs.COUNT LOOP
388: HZ_CONTACT_POINT_BO_PUB.do_create_contact_point(
389: p_init_msg_list => FND_API.G_FALSE,
390: p_validate_bo_flag => FND_API.G_FALSE,
391: p_cp_id => p_sms_objs(i).sms_id,
392: p_cp_os => p_sms_objs(i).orig_system,
393: p_cp_osr => p_sms_objs(i).orig_system_reference,

Line 390: p_validate_bo_flag => FND_API.G_FALSE,

386:
387: FOR i IN 1..p_sms_objs.COUNT LOOP
388: HZ_CONTACT_POINT_BO_PUB.do_create_contact_point(
389: p_init_msg_list => FND_API.G_FALSE,
390: p_validate_bo_flag => FND_API.G_FALSE,
391: p_cp_id => p_sms_objs(i).sms_id,
392: p_cp_os => p_sms_objs(i).orig_system,
393: p_cp_osr => p_sms_objs(i).orig_system_reference,
394: p_phone_obj => NULL,

Line 416: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

412: px_parent_os => l_owner_table_os,
413: px_parent_osr => 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);

Line 422: RAISE FND_API.G_EXC_ERROR;

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;
423: END IF;
424:
425: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
426: p_sms_objs(i).sms_id := l_cp_id;

Line 438: p_init_msg_list => FND_API.G_FALSE,

434: l_current_cp_type := 'PHONE';
435:
436: FOR i IN 1..p_phone_objs.COUNT LOOP
437: HZ_CONTACT_POINT_BO_PUB.do_save_contact_point(
438: p_init_msg_list => FND_API.G_FALSE,
439: p_validate_bo_flag => FND_API.G_FALSE,
440: p_cp_id => p_phone_objs(i).phone_id,
441: p_cp_os => p_phone_objs(i).orig_system,
442: p_cp_osr => p_phone_objs(i).orig_system_reference,

Line 439: p_validate_bo_flag => FND_API.G_FALSE,

435:
436: FOR i IN 1..p_phone_objs.COUNT LOOP
437: HZ_CONTACT_POINT_BO_PUB.do_save_contact_point(
438: p_init_msg_list => FND_API.G_FALSE,
439: p_validate_bo_flag => FND_API.G_FALSE,
440: p_cp_id => p_phone_objs(i).phone_id,
441: p_cp_os => p_phone_objs(i).orig_system,
442: p_cp_osr => p_phone_objs(i).orig_system_reference,
443: p_phone_obj => p_phone_objs(i),

Line 465: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

461: px_parent_os => l_owner_table_os,
462: px_parent_osr => 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);

Line 471: RAISE FND_API.G_EXC_ERROR;

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;
472: END IF;
473:
474: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
475: p_phone_objs(i).phone_id := l_cp_id;

Line 487: p_init_msg_list => FND_API.G_FALSE,

483: l_current_cp_type := 'TLX';
484:
485: FOR i IN 1..p_telex_objs.COUNT LOOP
486: HZ_CONTACT_POINT_BO_PUB.do_save_contact_point(
487: p_init_msg_list => FND_API.G_FALSE,
488: p_validate_bo_flag => FND_API.G_FALSE,
489: p_cp_id => p_telex_objs(i).telex_id,
490: p_cp_os => p_telex_objs(i).orig_system,
491: p_cp_osr => p_telex_objs(i).orig_system_reference,

Line 488: p_validate_bo_flag => FND_API.G_FALSE,

484:
485: FOR i IN 1..p_telex_objs.COUNT LOOP
486: HZ_CONTACT_POINT_BO_PUB.do_save_contact_point(
487: p_init_msg_list => FND_API.G_FALSE,
488: p_validate_bo_flag => FND_API.G_FALSE,
489: p_cp_id => p_telex_objs(i).telex_id,
490: p_cp_os => p_telex_objs(i).orig_system,
491: p_cp_osr => p_telex_objs(i).orig_system_reference,
492: p_phone_obj => NULL,

Line 514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

510: px_parent_os => l_owner_table_os,
511: px_parent_osr => 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);

Line 520: RAISE FND_API.G_EXC_ERROR;

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;
521: END IF;
522:
523: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
524: p_telex_objs(i).telex_id := l_cp_id;

Line 536: p_init_msg_list => FND_API.G_FALSE,

532: l_current_cp_type := 'EMAIL';
533:
534: FOR i IN 1..p_email_objs.COUNT LOOP
535: HZ_CONTACT_POINT_BO_PUB.do_save_contact_point(
536: p_init_msg_list => FND_API.G_FALSE,
537: p_validate_bo_flag => FND_API.G_FALSE,
538: p_cp_id => p_email_objs(i).email_id,
539: p_cp_os => p_email_objs(i).orig_system,
540: p_cp_osr => p_email_objs(i).orig_system_reference,

Line 537: p_validate_bo_flag => FND_API.G_FALSE,

533:
534: FOR i IN 1..p_email_objs.COUNT LOOP
535: HZ_CONTACT_POINT_BO_PUB.do_save_contact_point(
536: p_init_msg_list => FND_API.G_FALSE,
537: p_validate_bo_flag => FND_API.G_FALSE,
538: p_cp_id => p_email_objs(i).email_id,
539: p_cp_os => p_email_objs(i).orig_system,
540: p_cp_osr => p_email_objs(i).orig_system_reference,
541: p_phone_obj => NULL,

Line 563: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

559: px_parent_os => l_owner_table_os,
560: px_parent_osr => 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);

Line 569: RAISE FND_API.G_EXC_ERROR;

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;
570: END IF;
571:
572: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
573: p_email_objs(i).email_id := l_cp_id;

Line 585: p_init_msg_list => FND_API.G_FALSE,

581: l_current_cp_type := 'WEB';
582:
583: FOR i IN 1..p_web_objs.COUNT LOOP
584: HZ_CONTACT_POINT_BO_PUB.do_save_contact_point(
585: p_init_msg_list => FND_API.G_FALSE,
586: p_validate_bo_flag => FND_API.G_FALSE,
587: p_cp_id => p_web_objs(i).web_id,
588: p_cp_os => p_web_objs(i).orig_system,
589: p_cp_osr => p_web_objs(i).orig_system_reference,

Line 586: p_validate_bo_flag => FND_API.G_FALSE,

582:
583: FOR i IN 1..p_web_objs.COUNT LOOP
584: HZ_CONTACT_POINT_BO_PUB.do_save_contact_point(
585: p_init_msg_list => FND_API.G_FALSE,
586: p_validate_bo_flag => FND_API.G_FALSE,
587: p_cp_id => p_web_objs(i).web_id,
588: p_cp_os => p_web_objs(i).orig_system,
589: p_cp_osr => p_web_objs(i).orig_system_reference,
590: p_phone_obj => NULL,

Line 612: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

608: px_parent_os => l_owner_table_os,
609: px_parent_osr => 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);

Line 618: RAISE FND_API.G_EXC_ERROR;

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;
619: END IF;
620:
621: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
622: p_web_objs(i).web_id := l_cp_id;

Line 634: p_init_msg_list => FND_API.G_FALSE,

630: l_current_cp_type := 'EDI';
631:
632: FOR i IN 1..p_edi_objs.COUNT LOOP
633: HZ_CONTACT_POINT_BO_PUB.do_save_contact_point(
634: p_init_msg_list => FND_API.G_FALSE,
635: p_validate_bo_flag => FND_API.G_FALSE,
636: p_cp_id => p_edi_objs(i).edi_id,
637: p_cp_os => p_edi_objs(i).orig_system,
638: p_cp_osr => p_edi_objs(i).orig_system_reference,

Line 635: p_validate_bo_flag => FND_API.G_FALSE,

631:
632: FOR i IN 1..p_edi_objs.COUNT LOOP
633: HZ_CONTACT_POINT_BO_PUB.do_save_contact_point(
634: p_init_msg_list => FND_API.G_FALSE,
635: p_validate_bo_flag => FND_API.G_FALSE,
636: p_cp_id => p_edi_objs(i).edi_id,
637: p_cp_os => p_edi_objs(i).orig_system,
638: p_cp_osr => p_edi_objs(i).orig_system_reference,
639: p_phone_obj => NULL,

Line 661: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

657: px_parent_os => l_owner_table_os,
658: px_parent_osr => 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);

Line 667: RAISE FND_API.G_EXC_ERROR;

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;
668: END IF;
669:
670: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
671: p_edi_objs(i).edi_id := l_cp_id;

Line 683: p_init_msg_list => FND_API.G_FALSE,

679: l_current_cp_type := 'EFT';
680:
681: FOR i IN 1..p_eft_objs.COUNT LOOP
682: HZ_CONTACT_POINT_BO_PUB.do_save_contact_point(
683: p_init_msg_list => FND_API.G_FALSE,
684: p_validate_bo_flag => FND_API.G_FALSE,
685: p_cp_id => p_eft_objs(i).eft_id,
686: p_cp_os => p_eft_objs(i).orig_system,
687: p_cp_osr => p_eft_objs(i).orig_system_reference,

Line 684: p_validate_bo_flag => FND_API.G_FALSE,

680:
681: FOR i IN 1..p_eft_objs.COUNT LOOP
682: HZ_CONTACT_POINT_BO_PUB.do_save_contact_point(
683: p_init_msg_list => FND_API.G_FALSE,
684: p_validate_bo_flag => FND_API.G_FALSE,
685: p_cp_id => p_eft_objs(i).eft_id,
686: p_cp_os => p_eft_objs(i).orig_system,
687: p_cp_osr => p_eft_objs(i).orig_system_reference,
688: p_phone_obj => NULL,

Line 710: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

706: px_parent_os => l_owner_table_os,
707: px_parent_osr => 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);

Line 716: RAISE FND_API.G_EXC_ERROR;

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;
717: END IF;
718:
719: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
720: p_eft_objs(i).eft_id := l_cp_id;

Line 732: p_init_msg_list => FND_API.G_FALSE,

728: l_current_cp_type := 'SMS';
729:
730: FOR i IN 1..p_sms_objs.COUNT LOOP
731: HZ_CONTACT_POINT_BO_PUB.do_save_contact_point(
732: p_init_msg_list => FND_API.G_FALSE,
733: p_validate_bo_flag => FND_API.G_FALSE,
734: p_cp_id => p_sms_objs(i).sms_id,
735: p_cp_os => p_sms_objs(i).orig_system,
736: p_cp_osr => p_sms_objs(i).orig_system_reference,

Line 733: p_validate_bo_flag => FND_API.G_FALSE,

729:
730: FOR i IN 1..p_sms_objs.COUNT LOOP
731: HZ_CONTACT_POINT_BO_PUB.do_save_contact_point(
732: p_init_msg_list => FND_API.G_FALSE,
733: p_validate_bo_flag => FND_API.G_FALSE,
734: p_cp_id => p_sms_objs(i).sms_id,
735: p_cp_os => p_sms_objs(i).orig_system,
736: p_cp_osr => p_sms_objs(i).orig_system_reference,
737: p_phone_obj => NULL,

Line 759: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

755: px_parent_os => l_owner_table_os,
756: px_parent_osr => 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);

Line 765: RAISE FND_API.G_EXC_ERROR;

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;
766: END IF;
767:
768: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
769: p_sms_objs(i).sms_id := l_cp_id;

Line 787: WHEN fnd_api.g_exc_error THEN

783: p_prefix=>l_debug_prefix,
784: p_msg_level=>fnd_log.level_procedure);
785: END IF;
786: EXCEPTION
787: WHEN fnd_api.g_exc_error THEN
788: x_return_status := fnd_api.g_ret_sts_error;
789: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
790: p_count => x_msg_count,
791: p_data => x_msg_data);

Line 788: x_return_status := fnd_api.g_ret_sts_error;

784: p_msg_level=>fnd_log.level_procedure);
785: END IF;
786: EXCEPTION
787: WHEN fnd_api.g_exc_error THEN
788: x_return_status := fnd_api.g_ret_sts_error;
789: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
790: p_count => x_msg_count,
791: p_data => x_msg_data);
792:

Line 789: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

785: END IF;
786: EXCEPTION
787: WHEN fnd_api.g_exc_error THEN
788: x_return_status := fnd_api.g_ret_sts_error;
789: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
790: p_count => x_msg_count,
791: p_data => x_msg_data);
792:
793: -- Debug info.

Line 806: WHEN fnd_api.g_exc_unexpected_error THEN

802: p_prefix=>l_debug_prefix,
803: p_msg_level=>fnd_log.level_procedure);
804: END IF;
805:
806: WHEN fnd_api.g_exc_unexpected_error THEN
807: x_return_status := fnd_api.g_ret_sts_unexp_error;
808:
809: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
810: p_count => x_msg_count,

Line 807: x_return_status := fnd_api.g_ret_sts_unexp_error;

803: p_msg_level=>fnd_log.level_procedure);
804: END IF;
805:
806: WHEN fnd_api.g_exc_unexpected_error THEN
807: x_return_status := fnd_api.g_ret_sts_unexp_error;
808:
809: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
810: p_count => x_msg_count,
811: p_data => x_msg_data);

Line 809: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

805:
806: WHEN fnd_api.g_exc_unexpected_error THEN
807: x_return_status := fnd_api.g_ret_sts_unexp_error;
808:
809: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
810: p_count => x_msg_count,
811: p_data => x_msg_data);
812:
813: -- Debug info.

Line 826: x_return_status := fnd_api.g_ret_sts_unexp_error;

822: p_prefix=>l_debug_prefix,
823: p_msg_level=>fnd_log.level_procedure);
824: END IF;
825: WHEN OTHERS THEN
826: x_return_status := fnd_api.g_ret_sts_unexp_error;
827:
828: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
829: fnd_message.set_token('ERROR', SQLERRM);
830: fnd_msg_pub.add;

Line 832: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

828: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
829: fnd_message.set_token('ERROR', SQLERRM);
830: fnd_msg_pub.add;
831:
832: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
833: p_count => x_msg_count,
834: p_data => x_msg_data);
835:
836: -- Debug info.