DBA Data[Home] [Help]

APPS.HZ_CUST_ACCT_BO_PUB dependencies on HZ_CUST_ACCT_BO

Line 1: PACKAGE BODY hz_cust_acct_bo_pub AS

1: PACKAGE BODY hz_cust_acct_bo_pub AS
2: /*$Header: ARHBCABB.pls 120.17.12020000.2 2012/07/23 22:31:27 awu ship $ */
3:
4: -- PRIVATE PROCEDURE assign_cust_acct_rec
5: --

Line 28: p_cust_acct_obj IN HZ_CUST_ACCT_BO,

24: --
25: -- 14-DEC-2004 Arnold Ng Created.
26:
27: PROCEDURE assign_cust_acct_rec(
28: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
29: p_cust_acct_id IN NUMBER,
30: p_cust_acct_os IN VARCHAR2,
31: p_cust_acct_osr IN VARCHAR2,
32: p_create_or_update IN VARCHAR2 := 'C',

Line 60: p_cust_acct_obj IN HZ_CUST_ACCT_BO,

56: --
57: -- 14-DEC-2004 Arnold Ng Created.
58:
59: PROCEDURE assign_cust_acct_rec(
60: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
61: p_cust_acct_id IN NUMBER,
62: p_cust_acct_os IN VARCHAR2,
63: p_cust_acct_osr IN VARCHAR2,
64: p_create_or_update IN VARCHAR2 := 'C',

Line 317: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,

313: -- Create customer account business object.
314: PROCEDURE do_create_cust_acct_bo(
315: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
316: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
317: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,
318: p_created_by_module IN VARCHAR2,
319: p_obj_source IN VARCHAR2 := null,
320: x_return_status OUT NOCOPY VARCHAR2,
321: x_msg_count OUT NOCOPY NUMBER,

Line 384: p_ca_objs => HZ_CUST_ACCT_BO_TBL(p_cust_acct_obj),

380: p_bus_object_code => 'CUST_ACCT',
381: x_bus_object => l_bus_object
382: );
383: l_valid_obj := HZ_REGISTRY_VALIDATE_BO_PVT.is_ca_bo_comp(
384: p_ca_objs => HZ_CUST_ACCT_BO_TBL(p_cust_acct_obj),
385: p_bus_object => l_bus_object
386: );
387: IF NOT(l_valid_obj) THEN
388: RAISE fnd_api.g_exc_error;

Line 440: HZ_CUST_ACCT_BO_PVT.assign_cust_profile_rec(

436: fnd_msg_pub.add;
437: RAISE FND_API.G_EXC_ERROR;
438: END IF;
439:
440: HZ_CUST_ACCT_BO_PVT.assign_cust_profile_rec(
441: p_cust_profile_obj => p_cust_acct_obj.cust_profile_obj,
442: p_cust_acct_id => x_cust_acct_id,
443: p_site_use_id => NULL,
444: px_cust_profile_rec => l_profile_rec

Line 510: HZ_CUST_ACCT_BO_PVT.create_cust_profile_amts(

506: -- Create cust profile amount
507: -----------------------------
508: IF((p_cust_acct_obj.cust_profile_obj.cust_profile_amt_objs IS NOT NULL) AND
509: (p_cust_acct_obj.cust_profile_obj.cust_profile_amt_objs.COUNT > 0)) THEN
510: HZ_CUST_ACCT_BO_PVT.create_cust_profile_amts(
511: p_cpa_objs => p_cust_acct_obj.cust_profile_obj.cust_profile_amt_objs,
512: p_cp_id => l_cust_acct_profile_id,
513: p_ca_id => x_cust_acct_id,
514: p_casu_id => NULL,

Line 530: HZ_CUST_ACCT_BO_PVT.create_cust_acct_relates(

526: -- Create cust acct relate
527: -------------------------------------
528: IF((p_cust_acct_obj.acct_relate_objs IS NOT NULL) AND
529: (p_cust_acct_obj.acct_relate_objs.COUNT > 0)) THEN
530: HZ_CUST_ACCT_BO_PVT.create_cust_acct_relates(
531: p_car_objs => p_cust_acct_obj.acct_relate_objs,
532: p_ca_id => x_cust_acct_id,
533: x_return_status => x_return_status,
534: x_msg_count => x_msg_count,

Line 603: HZ_CUST_ACCT_BO_PVT.save_bank_acct_uses(

599: -- Call bank account use
600: ------------------------
601: IF((p_cust_acct_obj.bank_acct_use_objs IS NOT NULL) AND
602: (p_cust_acct_obj.bank_acct_use_objs.COUNT > 0)) THEN
603: HZ_CUST_ACCT_BO_PVT.save_bank_acct_uses(
604: p_bank_acct_use_objs => p_cust_acct_obj.bank_acct_use_objs,
605: p_party_id => l_party_id,
606: p_ca_id => x_cust_acct_id,
607: p_casu_id => NULL,

Line 622: HZ_CUST_ACCT_BO_PVT.create_payment_method(

618: ------------------------
619: -- Call payment method
620: ------------------------
621: IF(p_cust_acct_obj.payment_method_obj IS NOT NULL) THEN
622: HZ_CUST_ACCT_BO_PVT.create_payment_method(
623: p_payment_method_obj => p_cust_acct_obj.payment_method_obj,
624: p_ca_id => x_cust_acct_id,
625: p_casu_id => NULL,
626: x_return_status => x_return_status,

Line 753: p_cust_acct_obj IN HZ_CUST_ACCT_BO,

749:
750: PROCEDURE create_cust_acct_bo(
751: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
752: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
753: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
754: p_created_by_module IN VARCHAR2,
755: x_return_status OUT NOCOPY VARCHAR2,
756: x_msg_count OUT NOCOPY NUMBER,
757: x_msg_data OUT NOCOPY VARCHAR2,

Line 766: l_ca_obj HZ_CUST_ACCT_BO;

762: px_parent_os IN OUT NOCOPY VARCHAR2,
763: px_parent_osr IN OUT NOCOPY VARCHAR2,
764: px_parent_obj_type IN OUT NOCOPY VARCHAR2
765: ) IS
766: l_ca_obj HZ_CUST_ACCT_BO;
767: BEGIN
768: l_ca_obj := p_cust_acct_obj;
769: do_create_cust_acct_bo(
770: p_init_msg_list => p_init_msg_list,

Line 790: p_cust_acct_obj IN HZ_CUST_ACCT_BO,

786: END create_cust_acct_bo;
787:
788: PROCEDURE create_cust_acct_bo(
789: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
790: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
791: p_created_by_module IN VARCHAR2,
792: p_obj_source IN VARCHAR2 := null,
793: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
794: x_return_status OUT NOCOPY VARCHAR2,

Line 796: x_return_obj OUT NOCOPY HZ_CUST_ACCT_BO,

792: p_obj_source IN VARCHAR2 := null,
793: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
794: x_return_status OUT NOCOPY VARCHAR2,
795: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
796: x_return_obj OUT NOCOPY HZ_CUST_ACCT_BO,
797: x_cust_acct_id OUT NOCOPY NUMBER,
798: x_cust_acct_os OUT NOCOPY VARCHAR2,
799: x_cust_acct_osr OUT NOCOPY VARCHAR2,
800: px_parent_id IN OUT NOCOPY NUMBER,

Line 807: l_ca_obj HZ_CUST_ACCT_BO;

803: px_parent_obj_type IN OUT NOCOPY VARCHAR2
804: ) IS
805: l_msg_data VARCHAR2(2000);
806: l_msg_count NUMBER;
807: l_ca_obj HZ_CUST_ACCT_BO;
808: BEGIN
809: l_ca_obj := p_cust_acct_obj;
810: do_create_cust_acct_bo(
811: p_init_msg_list => fnd_api.g_true,

Line 838: p_cust_acct_obj IN HZ_CUST_ACCT_BO,

834: END create_cust_acct_bo;
835:
836: PROCEDURE update_cust_acct_bo(
837: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
838: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
839: p_created_by_module IN VARCHAR2,
840: x_return_status OUT NOCOPY VARCHAR2,
841: x_msg_count OUT NOCOPY NUMBER,
842: x_msg_data OUT NOCOPY VARCHAR2,

Line 847: l_ca_obj HZ_CUST_ACCT_BO;

843: x_cust_acct_id OUT NOCOPY NUMBER,
844: x_cust_acct_os OUT NOCOPY VARCHAR2,
845: x_cust_acct_osr OUT NOCOPY VARCHAR2
846: )IS
847: l_ca_obj HZ_CUST_ACCT_BO;
848: BEGIN
849: l_ca_obj := p_cust_acct_obj;
850: do_update_cust_acct_bo(
851: p_init_msg_list => p_init_msg_list,

Line 866: p_cust_acct_obj IN HZ_CUST_ACCT_BO,

862: );
863: END update_cust_acct_bo;
864:
865: PROCEDURE update_cust_acct_bo(
866: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
867: p_created_by_module IN VARCHAR2,
868: p_obj_source IN VARCHAR2 := null,
869: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
870: x_return_status OUT NOCOPY VARCHAR2,

Line 872: x_return_obj OUT NOCOPY HZ_CUST_ACCT_BO,

868: p_obj_source IN VARCHAR2 := null,
869: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
870: x_return_status OUT NOCOPY VARCHAR2,
871: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
872: x_return_obj OUT NOCOPY HZ_CUST_ACCT_BO,
873: x_cust_acct_id OUT NOCOPY NUMBER,
874: x_cust_acct_os OUT NOCOPY VARCHAR2,
875: x_cust_acct_osr OUT NOCOPY VARCHAR2
876: )IS

Line 879: l_ca_obj HZ_CUST_ACCT_BO;

875: x_cust_acct_osr OUT NOCOPY VARCHAR2
876: )IS
877: l_msg_data VARCHAR2(2000);
878: l_msg_count NUMBER;
879: l_ca_obj HZ_CUST_ACCT_BO;
880: BEGIN
881: l_ca_obj := p_cust_acct_obj;
882: do_update_cust_acct_bo(
883: p_init_msg_list => fnd_api.g_true,

Line 911: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,

907: -- Update customer account business object.
908: PROCEDURE do_update_cust_acct_bo(
909: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
910: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
911: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,
912: p_created_by_module IN VARCHAR2,
913: p_obj_source IN VARCHAR2 := null,
914: x_return_status OUT NOCOPY VARCHAR2,
915: x_msg_count OUT NOCOPY NUMBER,

Line 1016: HZ_CUST_ACCT_BO_PVT.update_cust_profile(

1012: -----------------------------
1013: -- For Update account profile
1014: -----------------------------
1015: IF(p_cust_acct_obj.cust_profile_obj IS NOT NULL) THEN
1016: HZ_CUST_ACCT_BO_PVT.update_cust_profile(
1017: p_cp_obj => p_cust_acct_obj.cust_profile_obj,
1018: p_ca_id => x_cust_acct_id,
1019: p_casu_id => NULL,
1020: x_cp_id => l_cust_acct_profile_id,

Line 1037: HZ_CUST_ACCT_BO_PVT.save_cust_profile_amts(

1033: -- For Update account profile amt
1034: ---------------------------------
1035: IF((p_cust_acct_obj.cust_profile_obj.cust_profile_amt_objs IS NOT NULL) AND
1036: (p_cust_acct_obj.cust_profile_obj.cust_profile_amt_objs.COUNT > 0)) THEN
1037: HZ_CUST_ACCT_BO_PVT.save_cust_profile_amts(
1038: p_cpa_objs => p_cust_acct_obj.cust_profile_obj.cust_profile_amt_objs,
1039: p_cp_id => l_cust_acct_profile_id,
1040: p_ca_id => x_cust_acct_id,
1041: p_casu_id => NULL,

Line 1085: HZ_CUST_ACCT_BO_PVT.save_cust_acct_relates(

1081: -- For Update account acct relate
1082: -------------------------------
1083: IF((p_cust_acct_obj.acct_relate_objs IS NOT NULL) AND
1084: (p_cust_acct_obj.acct_relate_objs.COUNT > 0)) THEN
1085: HZ_CUST_ACCT_BO_PVT.save_cust_acct_relates(
1086: p_car_objs => p_cust_acct_obj.acct_relate_objs,
1087: p_ca_id => x_cust_acct_id,
1088: x_return_status => x_return_status,
1089: x_msg_count => x_msg_count,

Line 1129: HZ_CUST_ACCT_BO_PVT.save_bank_acct_uses(

1125: -- Call bank account use
1126: ------------------------
1127: IF((p_cust_acct_obj.bank_acct_use_objs IS NOT NULL) AND
1128: (p_cust_acct_obj.bank_acct_use_objs.COUNT > 0)) THEN
1129: HZ_CUST_ACCT_BO_PVT.save_bank_acct_uses(
1130: p_bank_acct_use_objs => p_cust_acct_obj.bank_acct_use_objs,
1131: p_party_id => l_party_id,
1132: p_ca_id => x_cust_acct_id,
1133: p_casu_id => NULL,

Line 1148: HZ_CUST_ACCT_BO_PVT.save_payment_method(

1144: ------------------------
1145: -- Call payment method
1146: ------------------------
1147: IF(p_cust_acct_obj.payment_method_obj IS NOT NULL) THEN
1148: HZ_CUST_ACCT_BO_PVT.save_payment_method(
1149: p_payment_method_obj => p_cust_acct_obj.payment_method_obj,
1150: p_ca_id => x_cust_acct_id,
1151: p_casu_id => NULL,
1152: x_return_status => x_return_status,

Line 1281: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,

1277: -- Create or update customer account business object.
1278: PROCEDURE do_save_cust_acct_bo(
1279: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1280: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1281: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,
1282: p_created_by_module IN VARCHAR2,
1283: p_obj_source IN VARCHAR2 := null,
1284: x_return_status OUT NOCOPY VARCHAR2,
1285: x_msg_count OUT NOCOPY NUMBER,

Line 1454: p_cust_acct_obj IN HZ_CUST_ACCT_BO,

1450:
1451: PROCEDURE save_cust_acct_bo(
1452: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1453: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1454: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
1455: p_created_by_module IN VARCHAR2,
1456: x_return_status OUT NOCOPY VARCHAR2,
1457: x_msg_count OUT NOCOPY NUMBER,
1458: x_msg_data OUT NOCOPY VARCHAR2,

Line 1467: l_ca_obj HZ_CUST_ACCT_BO;

1463: px_parent_os IN OUT NOCOPY VARCHAR2,
1464: px_parent_osr IN OUT NOCOPY VARCHAR2,
1465: px_parent_obj_type IN OUT NOCOPY VARCHAR2
1466: ) IS
1467: l_ca_obj HZ_CUST_ACCT_BO;
1468: BEGIN
1469: l_ca_obj := p_cust_acct_obj;
1470: do_save_cust_acct_bo(
1471: p_init_msg_list => p_init_msg_list,

Line 1490: p_cust_acct_obj IN HZ_CUST_ACCT_BO,

1486: END save_cust_acct_bo;
1487:
1488: PROCEDURE save_cust_acct_bo(
1489: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1490: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
1491: p_created_by_module IN VARCHAR2,
1492: p_obj_source IN VARCHAR2 := null,
1493: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1494: x_return_status OUT NOCOPY VARCHAR2,

Line 1496: x_return_obj OUT NOCOPY HZ_CUST_ACCT_BO,

1492: p_obj_source IN VARCHAR2 := null,
1493: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1494: x_return_status OUT NOCOPY VARCHAR2,
1495: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1496: x_return_obj OUT NOCOPY HZ_CUST_ACCT_BO,
1497: x_cust_acct_id OUT NOCOPY NUMBER,
1498: x_cust_acct_os OUT NOCOPY VARCHAR2,
1499: x_cust_acct_osr OUT NOCOPY VARCHAR2,
1500: px_parent_id IN OUT NOCOPY NUMBER,

Line 1507: l_ca_obj HZ_CUST_ACCT_BO;

1503: px_parent_obj_type IN OUT NOCOPY VARCHAR2
1504: ) IS
1505: l_msg_data VARCHAR2(2000);
1506: l_msg_count NUMBER;
1507: l_ca_obj HZ_CUST_ACCT_BO;
1508: BEGIN
1509: l_ca_obj := p_cust_acct_obj;
1510: do_save_cust_acct_bo(
1511: p_init_msg_list => fnd_api.g_true,

Line 1599: x_cust_acct_obj OUT NOCOPY HZ_CUST_ACCT_BO,

1595: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1596: p_cust_acct_id IN NUMBER,
1597: p_cust_acct_os IN VARCHAR2,
1598: p_cust_acct_osr IN VARCHAR2,
1599: x_cust_acct_obj OUT NOCOPY HZ_CUST_ACCT_BO,
1600: x_return_status OUT NOCOPY VARCHAR2,
1601: x_msg_count OUT NOCOPY NUMBER,
1602: x_msg_data OUT NOCOPY VARCHAR2
1603: ) is

Line 1609: l_cust_acct_objs HZ_CUST_ACCT_BO_TBL;

1605:
1606: l_cust_acct_id number;
1607: l_cust_acct_os varchar2(30);
1608: l_cust_acct_osr varchar2(255);
1609: l_cust_acct_objs HZ_CUST_ACCT_BO_TBL;
1610: BEGIN
1611:
1612: -- initialize API return status to success.
1613: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1623: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo(+)',

1619:
1620:
1621: -- Debug info.
1622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1623: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo(+)',
1624: p_prefix=>l_debug_prefix,
1625: p_msg_level=>fnd_log.level_procedure);
1626: END IF;
1627:

Line 1675: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',

1671: END IF;
1672:
1673: -- Debug info.
1674: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1675: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1676: p_prefix=>l_debug_prefix,
1677: p_msg_level=>fnd_log.level_procedure);
1678: END IF;
1679:

Line 1698: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',

1694: p_msg_type=>'ERROR',
1695: p_msg_level=>fnd_log.level_error);
1696: END IF;
1697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1698: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1699: p_prefix=>l_debug_prefix,
1700: p_msg_level=>fnd_log.level_procedure);
1701: END IF;
1702: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1717: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',

1713: p_msg_type=>'UNEXPECTED ERROR',
1714: p_msg_level=>fnd_log.level_error);
1715: END IF;
1716: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1717: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1718: p_prefix=>l_debug_prefix,
1719: p_msg_level=>fnd_log.level_procedure);
1720: END IF;
1721: WHEN OTHERS THEN

Line 1740: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',

1736: p_msg_type=>'SQL ERROR',
1737: p_msg_level=>fnd_log.level_error);
1738: END IF;
1739: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1740: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1741: p_prefix=>l_debug_prefix,
1742: p_msg_level=>fnd_log.level_procedure);
1743: END IF;
1744:

Line 1751: x_cust_acct_obj OUT NOCOPY HZ_CUST_ACCT_BO,

1747: PROCEDURE get_cust_acct_bo(
1748: p_cust_acct_id IN NUMBER,
1749: p_cust_acct_os IN VARCHAR2,
1750: p_cust_acct_osr IN VARCHAR2,
1751: x_cust_acct_obj OUT NOCOPY HZ_CUST_ACCT_BO,
1752: x_return_status OUT NOCOPY VARCHAR2,
1753: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1754: ) IS
1755: l_msg_data VARCHAR2(2000);

Line 2093: HZ_CUST_ACCT_BO_PVT.assign_cust_profile_rec(

2089: fnd_msg_pub.add;
2090: RAISE FND_API.G_EXC_ERROR;
2091: END IF;
2092:
2093: HZ_CUST_ACCT_BO_PVT.assign_cust_profile_rec(
2094: p_cust_profile_obj => p_cust_acct_v2_obj.cust_profile_obj,
2095: p_cust_acct_id => x_cust_acct_id,
2096: p_site_use_id => NULL,
2097: px_cust_profile_rec => l_profile_rec

Line 2155: HZ_CUST_ACCT_BO_PVT.create_cust_profile_amts(

2151: -- Create cust profile amount
2152: -----------------------------
2153: IF((p_cust_acct_v2_obj.cust_profile_obj.cust_profile_amt_objs IS NOT NULL) AND
2154: (p_cust_acct_v2_obj.cust_profile_obj.cust_profile_amt_objs.COUNT > 0)) THEN
2155: HZ_CUST_ACCT_BO_PVT.create_cust_profile_amts(
2156: p_cpa_objs => p_cust_acct_v2_obj.cust_profile_obj.cust_profile_amt_objs,
2157: p_cp_id => l_cust_acct_profile_id,
2158: p_ca_id => x_cust_acct_id,
2159: p_casu_id => NULL,

Line 2175: HZ_CUST_ACCT_BO_PVT.create_cust_acct_relates(

2171: -- Create cust acct relate
2172: -------------------------------------
2173: IF((p_cust_acct_v2_obj.acct_relate_objs IS NOT NULL) AND
2174: (p_cust_acct_v2_obj.acct_relate_objs.COUNT > 0)) THEN
2175: HZ_CUST_ACCT_BO_PVT.create_cust_acct_relates(
2176: p_car_objs => p_cust_acct_v2_obj.acct_relate_objs,
2177: p_ca_id => x_cust_acct_id,
2178: x_return_status => x_return_status,
2179: x_msg_count => x_msg_count,

Line 2248: HZ_CUST_ACCT_BO_PVT.save_bank_acct_uses(

2244: -- Call bank account use
2245: ------------------------
2246: IF((p_cust_acct_v2_obj.bank_acct_use_objs IS NOT NULL) AND
2247: (p_cust_acct_v2_obj.bank_acct_use_objs.COUNT > 0)) THEN
2248: HZ_CUST_ACCT_BO_PVT.save_bank_acct_uses(
2249: p_bank_acct_use_objs => p_cust_acct_v2_obj.bank_acct_use_objs,
2250: p_party_id => l_party_id,
2251: p_ca_id => x_cust_acct_id,
2252: p_casu_id => NULL,

Line 2268: HZ_CUST_ACCT_BO_PVT.create_payment_methods(

2264: -- Call payment method
2265: ------------------------
2266: IF((p_cust_acct_v2_obj.payment_method_objs IS NOT NULL) AND
2267: (p_cust_acct_v2_obj.payment_method_objs.COUNT>0)) THEN
2268: HZ_CUST_ACCT_BO_PVT.create_payment_methods(
2269: p_payment_method_objs => p_cust_acct_v2_obj.payment_method_objs,
2270: p_ca_id => x_cust_acct_id,
2271: p_casu_id => NULL,
2272: x_return_status => x_return_status,

Line 2594: HZ_CUST_ACCT_BO_PVT.update_cust_profile(

2590: -----------------------------
2591: -- For Update account profile
2592: -----------------------------
2593: IF(p_cust_acct_v2_obj.cust_profile_obj IS NOT NULL) THEN
2594: HZ_CUST_ACCT_BO_PVT.update_cust_profile(
2595: p_cp_obj => p_cust_acct_v2_obj.cust_profile_obj,
2596: p_ca_id => x_cust_acct_id,
2597: p_casu_id => NULL,
2598: x_cp_id => l_cust_acct_profile_id,

Line 2615: HZ_CUST_ACCT_BO_PVT.save_cust_profile_amts(

2611: -- For Update account profile amt
2612: ---------------------------------
2613: IF((p_cust_acct_v2_obj.cust_profile_obj.cust_profile_amt_objs IS NOT NULL) AND
2614: (p_cust_acct_v2_obj.cust_profile_obj.cust_profile_amt_objs.COUNT > 0)) THEN
2615: HZ_CUST_ACCT_BO_PVT.save_cust_profile_amts(
2616: p_cpa_objs => p_cust_acct_v2_obj.cust_profile_obj.cust_profile_amt_objs,
2617: p_cp_id => l_cust_acct_profile_id,
2618: p_ca_id => x_cust_acct_id,
2619: p_casu_id => NULL,

Line 2663: HZ_CUST_ACCT_BO_PVT.save_cust_acct_relates(

2659: -- For Update account acct relate
2660: -------------------------------
2661: IF((p_cust_acct_v2_obj.acct_relate_objs IS NOT NULL) AND
2662: (p_cust_acct_v2_obj.acct_relate_objs.COUNT > 0)) THEN
2663: HZ_CUST_ACCT_BO_PVT.save_cust_acct_relates(
2664: p_car_objs => p_cust_acct_v2_obj.acct_relate_objs,
2665: p_ca_id => x_cust_acct_id,
2666: x_return_status => x_return_status,
2667: x_msg_count => x_msg_count,

Line 2707: HZ_CUST_ACCT_BO_PVT.save_bank_acct_uses(

2703: -- Call bank account use
2704: ------------------------
2705: IF((p_cust_acct_v2_obj.bank_acct_use_objs IS NOT NULL) AND
2706: (p_cust_acct_v2_obj.bank_acct_use_objs.COUNT > 0)) THEN
2707: HZ_CUST_ACCT_BO_PVT.save_bank_acct_uses(
2708: p_bank_acct_use_objs => p_cust_acct_v2_obj.bank_acct_use_objs,
2709: p_party_id => l_party_id,
2710: p_ca_id => x_cust_acct_id,
2711: p_casu_id => NULL,

Line 2727: HZ_CUST_ACCT_BO_PVT.save_payment_methods(

2723: -- Call payment method
2724: ------------------------
2725: IF((p_cust_acct_v2_obj.payment_method_objs IS NOT NULL) AND
2726: (p_cust_acct_v2_obj.payment_method_objs.COUNT > 0 )) THEN
2727: HZ_CUST_ACCT_BO_PVT.save_payment_methods(
2728: p_payment_method_objs => p_cust_acct_v2_obj.payment_method_objs,
2729: p_ca_id => x_cust_acct_id,
2730: p_casu_id => NULL,
2731: x_return_status => x_return_status,

Line 3165: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo(+)',

3161:
3162:
3163: -- Debug info.
3164: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3165: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo(+)',
3166: p_prefix=>l_debug_prefix,
3167: p_msg_level=>fnd_log.level_procedure);
3168: END IF;
3169:

Line 3217: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',

3213: END IF;
3214:
3215: -- Debug info.
3216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3217: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3218: p_prefix=>l_debug_prefix,
3219: p_msg_level=>fnd_log.level_procedure);
3220: END IF;
3221:

Line 3240: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',

3236: p_msg_type=>'ERROR',
3237: p_msg_level=>fnd_log.level_error);
3238: END IF;
3239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3240: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3241: p_prefix=>l_debug_prefix,
3242: p_msg_level=>fnd_log.level_procedure);
3243: END IF;
3244: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3259: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',

3255: p_msg_type=>'UNEXPECTED ERROR',
3256: p_msg_level=>fnd_log.level_error);
3257: END IF;
3258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3259: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3260: p_prefix=>l_debug_prefix,
3261: p_msg_level=>fnd_log.level_procedure);
3262: END IF;
3263: WHEN OTHERS THEN

Line 3282: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',

3278: p_msg_type=>'SQL ERROR',
3279: p_msg_level=>fnd_log.level_error);
3280: END IF;
3281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3282: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3283: p_prefix=>l_debug_prefix,
3284: p_msg_level=>fnd_log.level_procedure);
3285: END IF;
3286:

Line 3316: END hz_cust_acct_bo_pub;

3312: x_msg_count => l_msg_count,
3313: x_msg_data => l_msg_data);
3314: END get_cust_acct_v2_bo;
3315:
3316: END hz_cust_acct_bo_pub;