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_AIA_CUSTOM_PKG dependencies on FND_API

Line 9: IF(px_org_cust.organization_obj.duns_number_c = FND_API.G_MISS_CHAR) THEN

5:
6: PROCEDURE remove_gmiss(
7: px_org_cust IN OUT NOCOPY HZ_ORG_CUST_BO) IS
8: BEGIN
9: IF(px_org_cust.organization_obj.duns_number_c = FND_API.G_MISS_CHAR) THEN
10: px_org_cust.organization_obj.duns_number_c := NULL;
11: END IF;
12: IF(px_org_cust.organization_obj.contact_objs IS NOT NULL AND
13: px_org_cust.organization_obj.contact_objs.COUNT > 0) THEN

Line 15: IF(px_org_cust.organization_obj.contact_objs(i).job_title = FND_API.G_MISS_CHAR) THEN

11: END IF;
12: IF(px_org_cust.organization_obj.contact_objs IS NOT NULL AND
13: px_org_cust.organization_obj.contact_objs.COUNT > 0) THEN
14: FOR i IN 1..px_org_cust.organization_obj.contact_objs.COUNT LOOP
15: IF(px_org_cust.organization_obj.contact_objs(i).job_title = FND_API.G_MISS_CHAR) THEN
16: px_org_cust.organization_obj.contact_objs(i).job_title := null;
17: END IF;
18: -- clear g_miss_char in person profile object
19: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj IS NOT NULL) THEN

Line 20: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_pre_name_adjunct = FND_API.G_MISS_CHAR) THEN

16: px_org_cust.organization_obj.contact_objs(i).job_title := null;
17: END IF;
18: -- clear g_miss_char in person profile object
19: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj IS NOT NULL) THEN
20: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_pre_name_adjunct = FND_API.G_MISS_CHAR) THEN
21: px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_pre_name_adjunct:= null;
22: END IF;
23: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_middle_name = FND_API.G_MISS_CHAR) THEN
24: px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_middle_name := null;

Line 23: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_middle_name = FND_API.G_MISS_CHAR) THEN

19: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj IS NOT NULL) THEN
20: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_pre_name_adjunct = FND_API.G_MISS_CHAR) THEN
21: px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_pre_name_adjunct:= null;
22: END IF;
23: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_middle_name = FND_API.G_MISS_CHAR) THEN
24: px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_middle_name := null;
25: END IF;
26: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_title = FND_API.G_MISS_CHAR) THEN
27: px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_title := null;

Line 26: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_title = FND_API.G_MISS_CHAR) THEN

22: END IF;
23: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_middle_name = FND_API.G_MISS_CHAR) THEN
24: px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_middle_name := null;
25: END IF;
26: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_title = FND_API.G_MISS_CHAR) THEN
27: px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_title := null;
28: END IF;
29: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.known_as = FND_API.G_MISS_CHAR) THEN
30: px_org_cust.organization_obj.contact_objs(i).person_profile_obj.known_as := null;

Line 29: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.known_as = FND_API.G_MISS_CHAR) THEN

25: END IF;
26: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_title = FND_API.G_MISS_CHAR) THEN
27: px_org_cust.organization_obj.contact_objs(i).person_profile_obj.person_title := null;
28: END IF;
29: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.known_as = FND_API.G_MISS_CHAR) THEN
30: px_org_cust.organization_obj.contact_objs(i).person_profile_obj.known_as := null;
31: END IF;
32: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.gender = FND_API.G_MISS_CHAR) THEN
33: px_org_cust.organization_obj.contact_objs(i).person_profile_obj.gender := null;

Line 32: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.gender = FND_API.G_MISS_CHAR) THEN

28: END IF;
29: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.known_as = FND_API.G_MISS_CHAR) THEN
30: px_org_cust.organization_obj.contact_objs(i).person_profile_obj.known_as := null;
31: END IF;
32: IF(px_org_cust.organization_obj.contact_objs(i).person_profile_obj.gender = FND_API.G_MISS_CHAR) THEN
33: px_org_cust.organization_obj.contact_objs(i).person_profile_obj.gender := null;
34: END IF;
35: END IF;
36: -- clear g_miss_char in contact's email

Line 40: IF(px_org_cust.organization_obj.contact_objs(i).email_objs(j).email_address = FND_API.G_MISS_CHAR) THEN

36: -- clear g_miss_char in contact's email
37: IF(px_org_cust.organization_obj.contact_objs(i).email_objs IS NOT NULL AND
38: px_org_cust.organization_obj.contact_objs(i).email_objs.COUNT > 0) THEN
39: FOR j IN 1..px_org_cust.organization_obj.contact_objs(i).email_objs.COUNT LOOP
40: IF(px_org_cust.organization_obj.contact_objs(i).email_objs(j).email_address = FND_API.G_MISS_CHAR) THEN
41: px_org_cust.organization_obj.contact_objs(i).email_objs(j).email_address := NULL;
42: END IF;
43: END LOOP;
44: END IF;

Line 49: IF(px_org_cust.organization_obj.contact_objs(i).web_objs(j).url = FND_API.G_MISS_CHAR) THEN

45: -- clear g_miss_char in contact's web
46: IF(px_org_cust.organization_obj.contact_objs(i).web_objs IS NOT NULL AND
47: px_org_cust.organization_obj.contact_objs(i).web_objs.COUNT > 0) THEN
48: FOR j IN 1..px_org_cust.organization_obj.contact_objs(i).web_objs.COUNT LOOP
49: IF(px_org_cust.organization_obj.contact_objs(i).web_objs(j).url = FND_API.G_MISS_CHAR) THEN
50: px_org_cust.organization_obj.contact_objs(i).web_objs(j).url := NULL;
51: END IF;
52: END LOOP;
53: END IF;

Line 60: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.address2 = FND_API.G_MISS_CHAR) THEN

56: IF(px_org_cust.organization_obj.party_site_objs IS NOT NULL AND
57: px_org_cust.organization_obj.party_site_objs.COUNT > 0) THEN
58: FOR i IN 1..px_org_cust.organization_obj.party_site_objs.COUNT LOOP
59: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj IS NOT NULL) THEN
60: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.address2 = FND_API.G_MISS_CHAR) THEN
61: px_org_cust.organization_obj.party_site_objs(i).location_obj.address2 := NULL;
62: END IF;
63: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.address3 = FND_API.G_MISS_CHAR) THEN
64: px_org_cust.organization_obj.party_site_objs(i).location_obj.address3 := NULL;

Line 63: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.address3 = FND_API.G_MISS_CHAR) THEN

59: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj IS NOT NULL) THEN
60: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.address2 = FND_API.G_MISS_CHAR) THEN
61: px_org_cust.organization_obj.party_site_objs(i).location_obj.address2 := NULL;
62: END IF;
63: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.address3 = FND_API.G_MISS_CHAR) THEN
64: px_org_cust.organization_obj.party_site_objs(i).location_obj.address3 := NULL;
65: END IF;
66: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.address4 = FND_API.G_MISS_CHAR) THEN
67: px_org_cust.organization_obj.party_site_objs(i).location_obj.address4 := NULL;

Line 66: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.address4 = FND_API.G_MISS_CHAR) THEN

62: END IF;
63: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.address3 = FND_API.G_MISS_CHAR) THEN
64: px_org_cust.organization_obj.party_site_objs(i).location_obj.address3 := NULL;
65: END IF;
66: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.address4 = FND_API.G_MISS_CHAR) THEN
67: px_org_cust.organization_obj.party_site_objs(i).location_obj.address4 := NULL;
68: END IF;
69: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.city = FND_API.G_MISS_CHAR) THEN
70: px_org_cust.organization_obj.party_site_objs(i).location_obj.city := NULL;

Line 69: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.city = FND_API.G_MISS_CHAR) THEN

65: END IF;
66: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.address4 = FND_API.G_MISS_CHAR) THEN
67: px_org_cust.organization_obj.party_site_objs(i).location_obj.address4 := NULL;
68: END IF;
69: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.city = FND_API.G_MISS_CHAR) THEN
70: px_org_cust.organization_obj.party_site_objs(i).location_obj.city := NULL;
71: END IF;
72: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.county = FND_API.G_MISS_CHAR) THEN
73: px_org_cust.organization_obj.party_site_objs(i).location_obj.county := NULL;

Line 72: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.county = FND_API.G_MISS_CHAR) THEN

68: END IF;
69: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.city = FND_API.G_MISS_CHAR) THEN
70: px_org_cust.organization_obj.party_site_objs(i).location_obj.city := NULL;
71: END IF;
72: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.county = FND_API.G_MISS_CHAR) THEN
73: px_org_cust.organization_obj.party_site_objs(i).location_obj.county := NULL;
74: END IF;
75: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.postal_code = FND_API.G_MISS_CHAR) THEN
76: px_org_cust.organization_obj.party_site_objs(i).location_obj.postal_code := NULL;

Line 75: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.postal_code = FND_API.G_MISS_CHAR) THEN

71: END IF;
72: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.county = FND_API.G_MISS_CHAR) THEN
73: px_org_cust.organization_obj.party_site_objs(i).location_obj.county := NULL;
74: END IF;
75: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.postal_code = FND_API.G_MISS_CHAR) THEN
76: px_org_cust.organization_obj.party_site_objs(i).location_obj.postal_code := NULL;
77: END IF;
78: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.state = FND_API.G_MISS_CHAR) THEN
79: px_org_cust.organization_obj.party_site_objs(i).location_obj.state := NULL;

Line 78: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.state = FND_API.G_MISS_CHAR) THEN

74: END IF;
75: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.postal_code = FND_API.G_MISS_CHAR) THEN
76: px_org_cust.organization_obj.party_site_objs(i).location_obj.postal_code := NULL;
77: END IF;
78: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.state = FND_API.G_MISS_CHAR) THEN
79: px_org_cust.organization_obj.party_site_objs(i).location_obj.state := NULL;
80: END IF;
81: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.province = FND_API.G_MISS_CHAR) THEN
82: px_org_cust.organization_obj.party_site_objs(i).location_obj.province := NULL;

Line 81: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.province = FND_API.G_MISS_CHAR) THEN

77: END IF;
78: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.state = FND_API.G_MISS_CHAR) THEN
79: px_org_cust.organization_obj.party_site_objs(i).location_obj.state := NULL;
80: END IF;
81: IF(px_org_cust.organization_obj.party_site_objs(i).location_obj.province = FND_API.G_MISS_CHAR) THEN
82: px_org_cust.organization_obj.party_site_objs(i).location_obj.province := NULL;
83: END IF;
84: END IF;
85: END LOOP;

Line 90: IF(px_org_cust.organization_obj.email_objs(i).email_address = FND_API.G_MISS_CHAR) THEN

86: END IF;
87: IF(px_org_cust.organization_obj.email_objs IS NOT NULL AND
88: px_org_cust.organization_obj.email_objs.COUNT > 0) THEN
89: FOR i IN 1..px_org_cust.organization_obj.email_objs.COUNT LOOP
90: IF(px_org_cust.organization_obj.email_objs(i).email_address = FND_API.G_MISS_CHAR) THEN
91: px_org_cust.organization_obj.email_objs(i).email_address := NULL;
92: END IF;
93: END LOOP;
94: END IF;

Line 98: IF(px_org_cust.organization_obj.web_objs(i).url = FND_API.G_MISS_CHAR) THEN

94: END IF;
95: IF(px_org_cust.organization_obj.web_objs IS NOT NULL AND
96: px_org_cust.organization_obj.web_objs.COUNT > 0) THEN
97: FOR i IN 1..px_org_cust.organization_obj.web_objs.COUNT LOOP
98: IF(px_org_cust.organization_obj.web_objs(i).url = FND_API.G_MISS_CHAR) THEN
99: px_org_cust.organization_obj.web_objs(i).url := NULL;
100: END IF;
101: END LOOP;
102: END IF;

Line 103: IF(px_org_cust.organization_obj.duns_number_c = FND_API.G_MISS_CHAR) THEN

99: px_org_cust.organization_obj.web_objs(i).url := NULL;
100: END IF;
101: END LOOP;
102: END IF;
103: IF(px_org_cust.organization_obj.duns_number_c = FND_API.G_MISS_CHAR) THEN
104: px_org_cust.organization_obj.duns_number_c := NULL;
105: END IF;
106: END remove_gmiss;
107:

Line 262: WHEN fnd_api.g_exc_error THEN

258: CLOSE other_ou;
259: END LOOP;
260: END IF;
261: EXCEPTION
262: WHEN fnd_api.g_exc_error THEN
263: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
264: hz_utility_v2pub.debug(p_message=>'get_acct_merge_obj(-)',
265: p_prefix=>l_debug_prefix,
266: p_msg_level=>fnd_log.level_procedure);

Line 268: WHEN fnd_api.g_exc_unexpected_error THEN

264: hz_utility_v2pub.debug(p_message=>'get_acct_merge_obj(-)',
265: p_prefix=>l_debug_prefix,
266: p_msg_level=>fnd_log.level_procedure);
267: END IF;
268: WHEN fnd_api.g_exc_unexpected_error THEN
269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
270: hz_utility_v2pub.debug(p_message=>'get_acct_merge_obj(-)',
271: p_prefix=>l_debug_prefix,
272: p_msg_level=>fnd_log.level_procedure);

Line 329: p_init_msg_list => fnd_api.g_false,

325: x_org_cust_objs.EXTEND;
326: x_org_cust_objs(i) := HZ_ORG_CUST_BO(null, null, null);
327:
328: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_bo(
329: p_init_msg_list => fnd_api.g_false,
330: p_organization_id => l_org_id,
331: p_action_type => null,
332: x_organization_obj => x_org_cust_objs(i).organization_obj,
333: x_return_status => l_return_status,

Line 337: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

333: x_return_status => l_return_status,
334: x_msg_count => l_msg_count,
335: x_msg_data => l_msg_data);
336:
337: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
338: RAISE FND_API.G_EXC_ERROR;
339: END IF;
340:
341: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_bos(

Line 338: RAISE FND_API.G_EXC_ERROR;

334: x_msg_count => l_msg_count,
335: x_msg_data => l_msg_data);
336:
337: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
338: RAISE FND_API.G_EXC_ERROR;
339: END IF;
340:
341: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_bos(
342: p_init_msg_list => fnd_api.g_false,

Line 342: p_init_msg_list => fnd_api.g_false,

338: RAISE FND_API.G_EXC_ERROR;
339: END IF;
340:
341: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_bos(
342: p_init_msg_list => fnd_api.g_false,
343: p_parent_id => l_org_id,
344: p_cust_acct_id => l_ca_id,
345: p_action_type => null,
346: x_cust_acct_objs => x_org_cust_objs(i).account_objs,

Line 351: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

347: x_return_status => l_return_status,
348: x_msg_count => l_msg_count,
349: x_msg_data => l_msg_data);
350:
351: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
352: RAISE FND_API.G_EXC_ERROR;
353: END IF;
354: i := i + 1;
355: END LOOP;

Line 352: RAISE FND_API.G_EXC_ERROR;

348: x_msg_count => l_msg_count,
349: x_msg_data => l_msg_data);
350:
351: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
352: RAISE FND_API.G_EXC_ERROR;
353: END IF;
354: i := i + 1;
355: END LOOP;
356: CLOSE get_related_org_cust;

Line 358: WHEN fnd_api.g_exc_error THEN

354: i := i + 1;
355: END LOOP;
356: CLOSE get_related_org_cust;
357: EXCEPTION
358: WHEN fnd_api.g_exc_error THEN
359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
360: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',
361: p_prefix=>l_debug_prefix,
362: p_msg_level=>fnd_log.level_procedure);

Line 364: WHEN fnd_api.g_exc_unexpected_error THEN

360: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',
361: p_prefix=>l_debug_prefix,
362: p_msg_level=>fnd_log.level_procedure);
363: END IF;
364: WHEN fnd_api.g_exc_unexpected_error THEN
365: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
366: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',
367: p_prefix=>l_debug_prefix,
368: p_msg_level=>fnd_log.level_procedure);

Line 535: WHEN fnd_api.g_exc_error THEN

531: END LOOP;
532: CLOSE get_merge_parties;
533: END IF;
534: EXCEPTION
535: WHEN fnd_api.g_exc_error THEN
536: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
537: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',
538: p_prefix=>l_debug_prefix,
539: p_msg_level=>fnd_log.level_procedure);

Line 541: WHEN fnd_api.g_exc_unexpected_error THEN

537: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',
538: p_prefix=>l_debug_prefix,
539: p_msg_level=>fnd_log.level_procedure);
540: END IF;
541: WHEN fnd_api.g_exc_unexpected_error THEN
542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
543: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',
544: p_prefix=>l_debug_prefix,
545: p_msg_level=>fnd_log.level_procedure);

Line 560: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

556: END IF;
557: END get_party_merge_objs;
558:
559: PROCEDURE sync_acct_update(
560: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
561: p_org_cust_obj IN HZ_ORG_CUST_BO,
562: p_created_by_module IN VARCHAR2,
563: p_obj_source IN VARCHAR2 := null,
564: x_return_status OUT NOCOPY VARCHAR2,

Line 617: x_return_status := FND_API.G_RET_STS_SUCCESS;

613: BEGIN
614: SAVEPOINT do_sync_acct_update;
615:
616: -- initialize API return status to success.
617: x_return_status := FND_API.G_RET_STS_SUCCESS;
618:
619: -- Debug info.
620: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
621: hz_utility_v2pub.debug(p_message=>'sync_acct_update(+)',

Line 635: p_return_obj_flag => fnd_api.g_true,

631: HZ_ORGANIZATION_BO_PUB.update_organization_bo(
632: p_organization_obj => l_org_obj,
633: p_created_by_module => p_created_by_module,
634: p_obj_source => p_obj_source,
635: p_return_obj_flag => fnd_api.g_true,
636: x_return_status => x_return_status,
637: x_messages => x_messages,
638: x_return_obj => l_return_org_obj,
639: x_organization_id => l_organization_id,

Line 644: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

640: x_organization_os => l_organization_os,
641: x_organization_osr => l_organization_osr
642: );
643:
644: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
645: RAISE fnd_api.g_exc_error;
646: END IF;
647:
648: l_input_acct_obj := p_org_cust_obj.account_objs(1);

Line 645: RAISE fnd_api.g_exc_error;

641: x_organization_osr => l_organization_osr
642: );
643:
644: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
645: RAISE fnd_api.g_exc_error;
646: END IF;
647:
648: l_input_acct_obj := p_org_cust_obj.account_objs(1);
649:

Line 684: p_return_obj_flag => fnd_api.g_true,

680: HZ_ORG_CUST_BO_PUB.update_org_cust_bo(
681: p_org_cust_obj => l_org_cust_bo,
682: p_created_by_module => p_created_by_module,
683: p_obj_source => p_obj_source,
684: p_return_obj_flag => fnd_api.g_true,
685: x_return_status => x_return_status,
686: x_messages => x_messages,
687: x_return_obj => l_return_obj,
688: x_organization_id => l_organization_id

Line 691: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

687: x_return_obj => l_return_obj,
688: x_organization_id => l_organization_id
689: );
690:
691: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
692: RAISE fnd_api.g_exc_error;
693: END IF;
694:
695: x_return_obj := l_return_obj;

Line 692: RAISE fnd_api.g_exc_error;

688: x_organization_id => l_organization_id
689: );
690:
691: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
692: RAISE fnd_api.g_exc_error;
693: END IF;
694:
695: x_return_obj := l_return_obj;
696: x_return_obj.organization_obj := l_return_org_obj;

Line 706: WHEN fnd_api.g_exc_error THEN

702: p_prefix=>l_debug_prefix,
703: p_msg_level=>fnd_log.level_procedure);
704: END IF;
705: EXCEPTION
706: WHEN fnd_api.g_exc_error THEN
707: ROLLBACK TO do_sync_acct_update;
708:
709: x_return_status := fnd_api.g_ret_sts_error;
710:

Line 709: x_return_status := fnd_api.g_ret_sts_error;

705: EXCEPTION
706: WHEN fnd_api.g_exc_error THEN
707: ROLLBACK TO do_sync_acct_update;
708:
709: x_return_status := fnd_api.g_ret_sts_error;
710:
711: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
712: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
713: p_prefix=>l_debug_prefix,

Line 716: WHEN fnd_api.g_exc_unexpected_error THEN

712: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
713: p_prefix=>l_debug_prefix,
714: p_msg_level=>fnd_log.level_procedure);
715: END IF;
716: WHEN fnd_api.g_exc_unexpected_error THEN
717: ROLLBACK TO do_sync_acct_update;
718:
719: x_return_status := fnd_api.g_ret_sts_error;
720:

Line 719: x_return_status := fnd_api.g_ret_sts_error;

715: END IF;
716: WHEN fnd_api.g_exc_unexpected_error THEN
717: ROLLBACK TO do_sync_acct_update;
718:
719: x_return_status := fnd_api.g_ret_sts_error;
720:
721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
722: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
723: p_prefix=>l_debug_prefix,

Line 729: x_return_status := fnd_api.g_ret_sts_unexp_error;

725: END IF;
726: WHEN OTHERS THEN
727: ROLLBACK TO do_sync_acct_update;
728:
729: x_return_status := fnd_api.g_ret_sts_unexp_error;
730:
731: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
732: fnd_message.set_token('ERROR' ,SQLERRM);
733: fnd_msg_pub.add;

Line 743: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

739: END IF;
740: END sync_acct_update;
741:
742: PROCEDURE sync_acct_order(
743: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
744: p_org_cust_obj IN HZ_ORG_CUST_BO,
745: p_created_by_module IN VARCHAR2,
746: p_obj_source IN VARCHAR2 := null,
747: x_return_status OUT NOCOPY VARCHAR2,

Line 820: x_return_status := FND_API.G_RET_STS_SUCCESS;

816: BEGIN
817: SAVEPOINT do_sync_acct_order;
818:
819: -- initialize API return status to success.
820: x_return_status := FND_API.G_RET_STS_SUCCESS;
821:
822: -- Debug info.
823: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
824: hz_utility_v2pub.debug(p_message=>'sync_acct_order(+)',

Line 838: p_return_obj_flag => fnd_api.g_true,

834: p_validate_bo_flag => p_validate_bo_flag,
835: p_organization_obj => l_org_obj,
836: p_created_by_module => p_created_by_module,
837: p_obj_source => p_obj_source,
838: p_return_obj_flag => fnd_api.g_true,
839: x_return_status => x_return_status,
840: x_messages => x_messages,
841: x_return_obj => l_return_org_obj,
842: x_organization_id => l_organization_id,

Line 847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

843: x_organization_os => l_organization_os,
844: x_organization_osr => l_organization_osr
845: );
846:
847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
848: RAISE fnd_api.g_exc_error;
849: END IF;
850:
851: x_return_obj.organization_obj := l_return_org_obj;

Line 848: RAISE fnd_api.g_exc_error;

844: x_organization_osr => l_organization_osr
845: );
846:
847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
848: RAISE fnd_api.g_exc_error;
849: END IF;
850:
851: x_return_obj.organization_obj := l_return_org_obj;
852:

Line 935: p_return_obj_flag => fnd_api.g_true,

931: p_validate_bo_flag => p_validate_bo_flag,
932: p_org_cust_obj => l_org_cust_bo,
933: p_created_by_module => p_created_by_module,
934: p_obj_source => p_obj_source,
935: p_return_obj_flag => fnd_api.g_true,
936: x_return_status => x_return_status,
937: x_messages => x_messages,
938: x_return_obj => l_return_obj,
939: x_organization_id => l_organization_id

Line 953: p_return_obj_flag => fnd_api.g_true,

949: p_validate_bo_flag => p_validate_bo_flag,
950: p_cust_acct_obj => l_input_acct_obj,
951: p_created_by_module => p_created_by_module,
952: p_obj_source => p_obj_source,
953: p_return_obj_flag => fnd_api.g_true,
954: x_return_status => x_return_status,
955: x_messages => x_messages,
956: x_return_obj => l_return_acct_obj,
957: x_cust_acct_id => l_cust_acct_id,

Line 966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

962: px_parent_osr => l_organization_osr,
963: px_parent_obj_type => l_obj_type
964: );
965: */
966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
967: RAISE fnd_api.g_exc_error;
968: END IF;
969: /*
970: x_return_obj.account_objs.EXTEND;

Line 967: RAISE fnd_api.g_exc_error;

963: px_parent_obj_type => l_obj_type
964: );
965: */
966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
967: RAISE fnd_api.g_exc_error;
968: END IF;
969: /*
970: x_return_obj.account_objs.EXTEND;
971: x_return_obj.account_objs(1) := l_return_acct_obj;

Line 982: WHEN fnd_api.g_exc_error THEN

978: p_prefix=>l_debug_prefix,
979: p_msg_level=>fnd_log.level_procedure);
980: END IF;
981: EXCEPTION
982: WHEN fnd_api.g_exc_error THEN
983: ROLLBACK TO do_sync_acct_order;
984:
985: x_return_status := fnd_api.g_ret_sts_error;
986:

Line 985: x_return_status := fnd_api.g_ret_sts_error;

981: EXCEPTION
982: WHEN fnd_api.g_exc_error THEN
983: ROLLBACK TO do_sync_acct_order;
984:
985: x_return_status := fnd_api.g_ret_sts_error;
986:
987: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
988: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
989: p_prefix=>l_debug_prefix,

Line 992: WHEN fnd_api.g_exc_unexpected_error THEN

988: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
989: p_prefix=>l_debug_prefix,
990: p_msg_level=>fnd_log.level_procedure);
991: END IF;
992: WHEN fnd_api.g_exc_unexpected_error THEN
993: ROLLBACK TO do_sync_acct_order;
994:
995: x_return_status := fnd_api.g_ret_sts_error;
996:

Line 995: x_return_status := fnd_api.g_ret_sts_error;

991: END IF;
992: WHEN fnd_api.g_exc_unexpected_error THEN
993: ROLLBACK TO do_sync_acct_order;
994:
995: x_return_status := fnd_api.g_ret_sts_error;
996:
997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
998: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
999: p_prefix=>l_debug_prefix,

Line 1005: x_return_status := fnd_api.g_ret_sts_unexp_error;

1001: END IF;
1002: WHEN OTHERS THEN
1003: ROLLBACK TO do_sync_acct_order;
1004:
1005: x_return_status := fnd_api.g_ret_sts_unexp_error;
1006:
1007: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1008: fnd_message.set_token('ERROR' ,SQLERRM);
1009: fnd_msg_pub.add;

Line 1020: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1016: END sync_acct_order;
1017:
1018:
1019: PROCEDURE get_merge_org_custs(
1020: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1021: p_from_org_id IN NUMBER,
1022: p_to_org_id IN NUMBER,
1023: p_from_acct_id IN NUMBER,
1024: p_to_acct_id IN NUMBER,

Line 1036: x_return_status := FND_API.G_RET_STS_SUCCESS;

1032: l_org_id NUMBER;
1033: l_acct_id NUMBER;
1034: BEGIN
1035: -- initialize API return status to success.
1036: x_return_status := FND_API.G_RET_STS_SUCCESS;
1037:
1038: -- Initialize message list if p_init_msg_list is set to TRUE
1039: IF FND_API.to_Boolean(p_init_msg_list) THEN
1040: FND_MSG_PUB.initialize;

Line 1039: IF FND_API.to_Boolean(p_init_msg_list) THEN

1035: -- initialize API return status to success.
1036: x_return_status := FND_API.G_RET_STS_SUCCESS;
1037:
1038: -- Initialize message list if p_init_msg_list is set to TRUE
1039: IF FND_API.to_Boolean(p_init_msg_list) THEN
1040: FND_MSG_PUB.initialize;
1041: END IF;
1042:
1043: -- Debug info.

Line 1070: p_init_msg_list => fnd_api.g_false,

1066: l_acct_id := p_to_acct_id;
1067: END IF;
1068:
1069: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_bo(
1070: p_init_msg_list => fnd_api.g_false,
1071: p_organization_id => l_org_id,
1072: p_action_type => NULL,
1073: x_organization_obj => x_org_cust_objs(i).organization_obj,
1074: x_return_status => x_return_status,

Line 1078: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1074: x_return_status => x_return_status,
1075: x_msg_count => l_msg_count,
1076: x_msg_data => l_msg_data);
1077:
1078: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081: /*
1082: IF(x_org_cust_obj.organization_obj IS NULL OR x_org_cust_obj.organization_obj.organization_id IS NULL)THEN

Line 1079: RAISE FND_API.G_EXC_ERROR;

1075: x_msg_count => l_msg_count,
1076: x_msg_data => l_msg_data);
1077:
1078: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081: /*
1082: IF(x_org_cust_obj.organization_obj IS NULL OR x_org_cust_obj.organization_obj.organization_id IS NULL)THEN
1083: fnd_message.set_name('AR', 'HZ_API_INVALID_TCA_ID');

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

1081: /*
1082: IF(x_org_cust_obj.organization_obj IS NULL OR x_org_cust_obj.organization_obj.organization_id IS NULL)THEN
1083: fnd_message.set_name('AR', 'HZ_API_INVALID_TCA_ID');
1084: fnd_msg_pub.add;
1085: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1086: p_count => l_msg_count,
1087: p_data => l_msg_data);
1088: RAISE FND_API.G_EXC_ERROR;
1089: END IF;

Line 1088: RAISE FND_API.G_EXC_ERROR;

1084: fnd_msg_pub.add;
1085: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1086: p_count => l_msg_count,
1087: p_data => l_msg_data);
1088: RAISE FND_API.G_EXC_ERROR;
1089: END IF;
1090: */
1091: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_bos(
1092: p_init_msg_list => fnd_api.g_false,

Line 1092: p_init_msg_list => fnd_api.g_false,

1088: RAISE FND_API.G_EXC_ERROR;
1089: END IF;
1090: */
1091: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_bos(
1092: p_init_msg_list => fnd_api.g_false,
1093: p_parent_id => l_org_id,
1094: p_cust_acct_id => l_acct_id,
1095: p_action_type => NULL,
1096: x_cust_acct_objs => x_org_cust_objs(i).account_objs,

Line 1101: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1097: x_return_status => x_return_status,
1098: x_msg_count => l_msg_count,
1099: x_msg_data => l_msg_data);
1100:
1101: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104: END LOOP;
1105: /*

Line 1102: RAISE FND_API.G_EXC_ERROR;

1098: x_msg_count => l_msg_count,
1099: x_msg_data => l_msg_data);
1100:
1101: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104: END LOOP;
1105: /*
1106: IF(x_org_cust_obj.account_objs IS NULL OR x_org_cust_obj.account_objs.COUNT < 1)THEN

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

1105: /*
1106: IF(x_org_cust_obj.account_objs IS NULL OR x_org_cust_obj.account_objs.COUNT < 1)THEN
1107: fnd_message.set_name('AR', 'HZ_API_INVALID_TCA_ID');
1108: fnd_msg_pub.add;
1109: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1110: p_count => l_msg_count,
1111: p_data => l_msg_data);
1112: RAISE FND_API.G_EXC_ERROR;
1113: END IF;

Line 1112: RAISE FND_API.G_EXC_ERROR;

1108: fnd_msg_pub.add;
1109: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1110: p_count => l_msg_count,
1111: p_data => l_msg_data);
1112: RAISE FND_API.G_EXC_ERROR;
1113: END IF;
1114: */
1115: -- Debug info.
1116: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 1130: WHEN fnd_api.g_exc_error THEN

1126: p_prefix=>l_debug_prefix,
1127: p_msg_level=>fnd_log.level_procedure);
1128: END IF;
1129: EXCEPTION
1130: WHEN fnd_api.g_exc_error THEN
1131: x_return_status := fnd_api.g_ret_sts_error;
1132: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
1133: x_return_status => x_return_status,
1134: x_msg_count => l_msg_count,

Line 1131: x_return_status := fnd_api.g_ret_sts_error;

1127: p_msg_level=>fnd_log.level_procedure);
1128: END IF;
1129: EXCEPTION
1130: WHEN fnd_api.g_exc_error THEN
1131: x_return_status := fnd_api.g_ret_sts_error;
1132: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
1133: x_return_status => x_return_status,
1134: x_msg_count => l_msg_count,
1135: x_msg_data => l_msg_data);

Line 1149: WHEN fnd_api.g_exc_unexpected_error THEN

1145: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1146: p_prefix=>l_debug_prefix,
1147: p_msg_level=>fnd_log.level_procedure);
1148: END IF;
1149: WHEN fnd_api.g_exc_unexpected_error THEN
1150: x_return_status := fnd_api.g_ret_sts_unexp_error;
1151: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
1152: x_return_status => x_return_status,
1153: x_msg_count => l_msg_count,

Line 1150: x_return_status := fnd_api.g_ret_sts_unexp_error;

1146: p_prefix=>l_debug_prefix,
1147: p_msg_level=>fnd_log.level_procedure);
1148: END IF;
1149: WHEN fnd_api.g_exc_unexpected_error THEN
1150: x_return_status := fnd_api.g_ret_sts_unexp_error;
1151: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
1152: x_return_status => x_return_status,
1153: x_msg_count => l_msg_count,
1154: x_msg_data => l_msg_data);

Line 1169: x_return_status := fnd_api.g_ret_sts_unexp_error;

1165: p_prefix=>l_debug_prefix,
1166: p_msg_level=>fnd_log.level_procedure);
1167: END IF;
1168: WHEN OTHERS THEN
1169: x_return_status := fnd_api.g_ret_sts_unexp_error;
1170: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1171: fnd_message.set_token('ERROR' ,SQLERRM);
1172: fnd_msg_pub.add;
1173: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

1169: x_return_status := fnd_api.g_ret_sts_unexp_error;
1170: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1171: fnd_message.set_token('ERROR' ,SQLERRM);
1172: fnd_msg_pub.add;
1173: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1174: p_count => l_msg_count,
1175: p_data => l_msg_data);
1176: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
1177: x_return_status => x_return_status,