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_CUST_ACCT_CONTACT_BO_PUB dependencies on HZ_CUST_ACCT_CONTACT_BO

Line 1: PACKAGE BODY hz_cust_acct_contact_bo_pub AS

1: PACKAGE BODY hz_cust_acct_contact_bo_pub AS
2: /*$Header: ARHBCRBB.pls 120.17 2008/02/20 19:27:26 awu ship $ */
3:
4: -- PRIVATE PROCEDURE assign_cust_acct_role_rec
5: --

Line 32: p_cust_acct_role_obj IN HZ_CUST_ACCT_CONTACT_BO,

28: -- 14-DEC-2004 Arnold Ng Created.
29: --
30:
31: PROCEDURE assign_cust_acct_role_rec(
32: p_cust_acct_role_obj IN HZ_CUST_ACCT_CONTACT_BO,
33: p_party_id IN NUMBER,
34: p_cust_acct_id IN NUMBER,
35: p_cust_acct_site_id IN NUMBER,
36: p_cust_acct_contact_id IN NUMBER,

Line 71: p_cust_acct_role_obj IN HZ_CUST_ACCT_CONTACT_BO,

67: -- 14-DEC-2004 Arnold Ng Created.
68: --
69:
70: PROCEDURE assign_cust_acct_role_rec(
71: p_cust_acct_role_obj IN HZ_CUST_ACCT_CONTACT_BO,
72: p_party_id IN NUMBER,
73: p_cust_acct_id IN NUMBER,
74: p_cust_acct_site_id IN NUMBER,
75: p_cust_acct_contact_id IN NUMBER,

Line 134: p_cust_acct_contact_obj IN OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,

130: -- Create customer account contact business object.
131: PROCEDURE do_create_cac_bo(
132: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
133: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
134: p_cust_acct_contact_obj IN OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,
135: p_created_by_module IN VARCHAR2,
136: p_obj_source IN VARCHAR2 := null,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,

Line 235: p_cac_objs => HZ_CUST_ACCT_CONTACT_BO_TBL(p_cust_acct_contact_obj),

231: p_bus_object_code => 'CUST_ACCT_CONTACT',
232: x_bus_object => l_bus_object
233: );
234: l_valid_obj := HZ_REGISTRY_VALIDATE_BO_PVT.is_cac_bo_comp(
235: p_cac_objs => HZ_CUST_ACCT_CONTACT_BO_TBL(p_cust_acct_contact_obj),
236: p_bus_object => l_bus_object
237: );
238: IF NOT(l_valid_obj) THEN
239: RAISE fnd_api.g_exc_error;

Line 351: HZ_CUST_ACCT_CONTACT_BO_PVT.create_role_responsibilities(

347: -- Call role responsibility v2pub api
348: -------------------------------------
349: IF((p_cust_acct_contact_obj.contact_role_objs IS NOT NULL) AND
350: (p_cust_acct_contact_obj.contact_role_objs.COUNT > 0)) THEN
351: HZ_CUST_ACCT_CONTACT_BO_PVT.create_role_responsibilities(
352: p_rr_objs => p_cust_acct_contact_obj.contact_role_objs,
353: p_cac_id => x_cust_acct_contact_id,
354: x_return_status => x_return_status,
355: x_msg_count => x_msg_count,

Line 480: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,

476:
477: PROCEDURE create_cust_acct_contact_bo(
478: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
479: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
480: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,
481: p_created_by_module IN VARCHAR2,
482: x_return_status OUT NOCOPY VARCHAR2,
483: x_msg_count OUT NOCOPY NUMBER,
484: x_msg_data OUT NOCOPY VARCHAR2,

Line 493: l_cac_obj HZ_CUST_ACCT_CONTACT_BO;

489: px_parent_os IN OUT NOCOPY VARCHAR2,
490: px_parent_osr IN OUT NOCOPY VARCHAR2,
491: px_parent_obj_type IN OUT NOCOPY VARCHAR2
492: ) IS
493: l_cac_obj HZ_CUST_ACCT_CONTACT_BO;
494: BEGIN
495: l_cac_obj := p_cust_acct_contact_obj;
496: do_create_cac_bo(
497: p_init_msg_list => p_init_msg_list,

Line 517: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,

513: END create_cust_acct_contact_bo;
514:
515: PROCEDURE create_cust_acct_contact_bo(
516: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
517: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,
518: p_created_by_module IN VARCHAR2,
519: p_obj_source IN VARCHAR2 := null,
520: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
521: x_return_status OUT NOCOPY VARCHAR2,

Line 523: x_return_obj OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,

519: p_obj_source IN VARCHAR2 := null,
520: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
521: x_return_status OUT NOCOPY VARCHAR2,
522: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
523: x_return_obj OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,
524: x_cust_acct_contact_id OUT NOCOPY NUMBER,
525: x_cust_acct_contact_os OUT NOCOPY VARCHAR2,
526: x_cust_acct_contact_osr OUT NOCOPY VARCHAR2,
527: px_parent_id IN OUT NOCOPY NUMBER,

Line 534: l_cac_obj HZ_CUST_ACCT_CONTACT_BO;

530: px_parent_obj_type IN OUT NOCOPY VARCHAR2
531: ) IS
532: l_msg_data VARCHAR2(2000);
533: l_msg_count NUMBER;
534: l_cac_obj HZ_CUST_ACCT_CONTACT_BO;
535: BEGIN
536: l_cac_obj := p_cust_acct_contact_obj;
537: do_create_cac_bo(
538: p_init_msg_list => fnd_api.g_true,

Line 569: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,

565: -- DESCRIPTION
566: -- Update customer account contact business object.
567: PROCEDURE update_cust_acct_contact_bo(
568: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
569: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,
570: p_created_by_module IN VARCHAR2,
571: x_return_status OUT NOCOPY VARCHAR2,
572: x_msg_count OUT NOCOPY NUMBER,
573: x_msg_data OUT NOCOPY VARCHAR2,

Line 578: l_cac_obj HZ_CUST_ACCT_CONTACT_BO;

574: x_cust_acct_contact_id OUT NOCOPY NUMBER,
575: x_cust_acct_contact_os OUT NOCOPY VARCHAR2,
576: x_cust_acct_contact_osr OUT NOCOPY VARCHAR2
577: )IS
578: l_cac_obj HZ_CUST_ACCT_CONTACT_BO;
579: BEGIN
580: l_cac_obj := p_cust_acct_contact_obj;
581: do_update_cac_bo(
582: p_init_msg_list => p_init_msg_list,

Line 597: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,

593: );
594: END update_cust_acct_contact_bo;
595:
596: PROCEDURE update_cust_acct_contact_bo(
597: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,
598: p_created_by_module IN VARCHAR2,
599: p_obj_source IN VARCHAR2 := null,
600: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
601: x_return_status OUT NOCOPY VARCHAR2,

Line 603: x_return_obj OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,

599: p_obj_source IN VARCHAR2 := null,
600: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
601: x_return_status OUT NOCOPY VARCHAR2,
602: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
603: x_return_obj OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,
604: x_cust_acct_contact_id OUT NOCOPY NUMBER,
605: x_cust_acct_contact_os OUT NOCOPY VARCHAR2,
606: x_cust_acct_contact_osr OUT NOCOPY VARCHAR2
607: )IS

Line 610: l_cac_obj HZ_CUST_ACCT_CONTACT_BO;

606: x_cust_acct_contact_osr OUT NOCOPY VARCHAR2
607: )IS
608: l_msg_data VARCHAR2(2000);
609: l_msg_count NUMBER;
610: l_cac_obj HZ_CUST_ACCT_CONTACT_BO;
611: BEGIN
612: l_cac_obj := p_cust_acct_contact_obj;
613: do_update_cac_bo(
614: p_init_msg_list => fnd_api.g_true,

Line 637: p_cust_acct_contact_obj IN OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,

633: END update_cust_acct_contact_bo;
634:
635: PROCEDURE do_update_cac_bo(
636: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
637: p_cust_acct_contact_obj IN OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,
638: p_created_by_module IN VARCHAR2,
639: p_obj_source IN VARCHAR2 := null,
640: x_return_status OUT NOCOPY VARCHAR2,
641: x_msg_count OUT NOCOPY NUMBER,

Line 751: HZ_CUST_ACCT_CONTACT_BO_PVT.save_role_responsibilities(

747: -- For Role Responsibilities
748: ----------------------------
749: IF((p_cust_acct_contact_obj.contact_role_objs IS NOT NULL) AND
750: (p_cust_acct_contact_obj.contact_role_objs.COUNT > 0)) THEN
751: HZ_CUST_ACCT_CONTACT_BO_PVT.save_role_responsibilities(
752: p_rr_objs => p_cust_acct_contact_obj.contact_role_objs,
753: p_cac_id => x_cust_acct_contact_id,
754: x_return_status => x_return_status,
755: x_msg_count => x_msg_count,

Line 883: p_cust_acct_contact_obj IN OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,

879: -- Create or update customer account contact business object.
880: PROCEDURE do_save_cac_bo(
881: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
882: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
883: p_cust_acct_contact_obj IN OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,
884: p_created_by_module IN VARCHAR2,
885: p_obj_source IN VARCHAR2 := null,
886: x_return_status OUT NOCOPY VARCHAR2,
887: x_msg_count OUT NOCOPY NUMBER,

Line 1058: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,

1054:
1055: PROCEDURE save_cust_acct_contact_bo(
1056: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1057: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1058: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,
1059: p_created_by_module IN VARCHAR2,
1060: x_return_status OUT NOCOPY VARCHAR2,
1061: x_msg_count OUT NOCOPY NUMBER,
1062: x_msg_data OUT NOCOPY VARCHAR2,

Line 1071: l_cac_obj HZ_CUST_ACCT_CONTACT_BO;

1067: px_parent_os IN OUT NOCOPY VARCHAR2,
1068: px_parent_osr IN OUT NOCOPY VARCHAR2,
1069: px_parent_obj_type IN OUT NOCOPY VARCHAR2
1070: ) IS
1071: l_cac_obj HZ_CUST_ACCT_CONTACT_BO;
1072: BEGIN
1073: l_cac_obj := p_cust_acct_contact_obj;
1074: do_save_cac_bo(
1075: p_init_msg_list => p_init_msg_list,

Line 1094: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,

1090: END save_cust_acct_contact_bo;
1091:
1092: PROCEDURE save_cust_acct_contact_bo(
1093: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1094: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,
1095: p_created_by_module IN VARCHAR2,
1096: p_obj_source IN VARCHAR2 := null,
1097: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1098: x_return_status OUT NOCOPY VARCHAR2,

Line 1100: x_return_obj OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,

1096: p_obj_source IN VARCHAR2 := null,
1097: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1098: x_return_status OUT NOCOPY VARCHAR2,
1099: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1100: x_return_obj OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,
1101: x_cust_acct_contact_id OUT NOCOPY NUMBER,
1102: x_cust_acct_contact_os OUT NOCOPY VARCHAR2,
1103: x_cust_acct_contact_osr OUT NOCOPY VARCHAR2,
1104: px_parent_id IN OUT NOCOPY NUMBER,

Line 1111: l_cac_obj HZ_CUST_ACCT_CONTACT_BO;

1107: px_parent_obj_type IN OUT NOCOPY VARCHAR2
1108: ) IS
1109: l_msg_data VARCHAR2(2000);
1110: l_msg_count NUMBER;
1111: l_cac_obj HZ_CUST_ACCT_CONTACT_BO;
1112: BEGIN
1113: l_cac_obj := p_cust_acct_contact_obj;
1114: do_save_cac_bo(
1115: p_init_msg_list => fnd_api.g_true,

Line 1201: x_cust_acct_contact_obj OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,

1197: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
1198: p_cust_acct_contact_id IN NUMBER,
1199: p_cust_acct_contact_os IN VARCHAR2,
1200: p_cust_acct_contact_osr IN VARCHAR2,
1201: x_cust_acct_contact_obj OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,
1202: x_return_status OUT NOCOPY VARCHAR2,
1203: x_msg_count OUT NOCOPY NUMBER,
1204: x_msg_data OUT NOCOPY VARCHAR2
1205: ) is

Line 1211: l_cust_acct_contact_objs HZ_CUST_ACCT_CONTACT_BO_TBL;

1207:
1208: l_cust_acct_contact_id number;
1209: l_cust_acct_contact_os varchar2(30);
1210: l_cust_acct_contact_osr varchar2(255);
1211: l_cust_acct_contact_objs HZ_CUST_ACCT_CONTACT_BO_TBL;
1212: BEGIN
1213:
1214: -- initialize API return status to success.
1215: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1225: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo(+)',

1221:
1222:
1223: -- Debug info.
1224: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1225: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo(+)',
1226: p_prefix=>l_debug_prefix,
1227: p_msg_level=>fnd_log.level_procedure);
1228: END IF;
1229:

Line 1277: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',

1273: END IF;
1274:
1275: -- Debug info.
1276: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1277: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',
1278: p_prefix=>l_debug_prefix,
1279: p_msg_level=>fnd_log.level_procedure);
1280: END IF;
1281:

Line 1300: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',

1296: p_msg_type=>'ERROR',
1297: p_msg_level=>fnd_log.level_error);
1298: END IF;
1299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1300: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',
1301: p_prefix=>l_debug_prefix,
1302: p_msg_level=>fnd_log.level_procedure);
1303: END IF;
1304: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1319: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',

1315: p_msg_type=>'UNEXPECTED ERROR',
1316: p_msg_level=>fnd_log.level_error);
1317: END IF;
1318: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1319: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',
1320: p_prefix=>l_debug_prefix,
1321: p_msg_level=>fnd_log.level_procedure);
1322: END IF;
1323: WHEN OTHERS THEN

Line 1342: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',

1338: p_msg_type=>'SQL ERROR',
1339: p_msg_level=>fnd_log.level_error);
1340: END IF;
1341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1342: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',
1343: p_prefix=>l_debug_prefix,
1344: p_msg_level=>fnd_log.level_procedure);
1345: END IF;
1346:

Line 1353: x_cust_acct_contact_obj OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,

1349: PROCEDURE get_cust_acct_contact_bo (
1350: p_cust_acct_contact_id IN NUMBER,
1351: p_cust_acct_contact_os IN VARCHAR2,
1352: p_cust_acct_contact_osr IN VARCHAR2,
1353: x_cust_acct_contact_obj OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,
1354: x_return_status OUT NOCOPY VARCHAR2,
1355: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1356: ) IS
1357: l_msg_data VARCHAR2(2000);

Line 1376: END hz_cust_acct_contact_bo_pub;

1372: x_msg_count => l_msg_count,
1373: x_msg_data => l_msg_data);
1374: END get_cust_acct_contact_bo;
1375:
1376: END hz_cust_acct_contact_bo_pub;