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.14 2008/02/06 09:44:55 vsegu 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 199: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,

195: -- Create customer account business object.
196: PROCEDURE do_create_cust_acct_bo(
197: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
198: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
199: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,
200: p_created_by_module IN VARCHAR2,
201: p_obj_source IN VARCHAR2 := null,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,

Line 266: p_ca_objs => HZ_CUST_ACCT_BO_TBL(p_cust_acct_obj),

262: p_bus_object_code => 'CUST_ACCT',
263: x_bus_object => l_bus_object
264: );
265: l_valid_obj := HZ_REGISTRY_VALIDATE_BO_PVT.is_ca_bo_comp(
266: p_ca_objs => HZ_CUST_ACCT_BO_TBL(p_cust_acct_obj),
267: p_bus_object => l_bus_object
268: );
269: IF NOT(l_valid_obj) THEN
270: RAISE fnd_api.g_exc_error;

Line 322: HZ_CUST_ACCT_BO_PVT.assign_cust_profile_rec(

318: fnd_msg_pub.add;
319: RAISE FND_API.G_EXC_ERROR;
320: END IF;
321:
322: HZ_CUST_ACCT_BO_PVT.assign_cust_profile_rec(
323: p_cust_profile_obj => p_cust_acct_obj.cust_profile_obj,
324: p_cust_acct_id => x_cust_acct_id,
325: p_site_use_id => NULL,
326: px_cust_profile_rec => l_profile_rec

Line 382: HZ_CUST_ACCT_BO_PVT.create_cust_profile_amts(

378: -- Create cust profile amount
379: -----------------------------
380: IF((p_cust_acct_obj.cust_profile_obj.cust_profile_amt_objs IS NOT NULL) AND
381: (p_cust_acct_obj.cust_profile_obj.cust_profile_amt_objs.COUNT > 0)) THEN
382: HZ_CUST_ACCT_BO_PVT.create_cust_profile_amts(
383: p_cpa_objs => p_cust_acct_obj.cust_profile_obj.cust_profile_amt_objs,
384: p_cp_id => l_cust_acct_profile_id,
385: p_ca_id => x_cust_acct_id,
386: p_casu_id => NULL,

Line 402: HZ_CUST_ACCT_BO_PVT.create_cust_acct_relates(

398: -- Create cust acct relate
399: -------------------------------------
400: IF((p_cust_acct_obj.acct_relate_objs IS NOT NULL) AND
401: (p_cust_acct_obj.acct_relate_objs.COUNT > 0)) THEN
402: HZ_CUST_ACCT_BO_PVT.create_cust_acct_relates(
403: p_car_objs => p_cust_acct_obj.acct_relate_objs,
404: p_ca_id => x_cust_acct_id,
405: x_return_status => x_return_status,
406: x_msg_count => x_msg_count,

Line 475: HZ_CUST_ACCT_BO_PVT.save_bank_acct_uses(

471: -- Call bank account use
472: ------------------------
473: IF((p_cust_acct_obj.bank_acct_use_objs IS NOT NULL) AND
474: (p_cust_acct_obj.bank_acct_use_objs.COUNT > 0)) THEN
475: HZ_CUST_ACCT_BO_PVT.save_bank_acct_uses(
476: p_bank_acct_use_objs => p_cust_acct_obj.bank_acct_use_objs,
477: p_party_id => l_party_id,
478: p_ca_id => x_cust_acct_id,
479: p_casu_id => NULL,

Line 494: HZ_CUST_ACCT_BO_PVT.create_payment_method(

490: ------------------------
491: -- Call payment method
492: ------------------------
493: IF(p_cust_acct_obj.payment_method_obj IS NOT NULL) THEN
494: HZ_CUST_ACCT_BO_PVT.create_payment_method(
495: p_payment_method_obj => p_cust_acct_obj.payment_method_obj,
496: p_ca_id => x_cust_acct_id,
497: p_casu_id => NULL,
498: x_return_status => x_return_status,

Line 624: p_cust_acct_obj IN HZ_CUST_ACCT_BO,

620:
621: PROCEDURE create_cust_acct_bo(
622: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
623: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
624: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
625: p_created_by_module IN VARCHAR2,
626: x_return_status OUT NOCOPY VARCHAR2,
627: x_msg_count OUT NOCOPY NUMBER,
628: x_msg_data OUT NOCOPY VARCHAR2,

Line 637: l_ca_obj HZ_CUST_ACCT_BO;

633: px_parent_os IN OUT NOCOPY VARCHAR2,
634: px_parent_osr IN OUT NOCOPY VARCHAR2,
635: px_parent_obj_type IN OUT NOCOPY VARCHAR2
636: ) IS
637: l_ca_obj HZ_CUST_ACCT_BO;
638: BEGIN
639: l_ca_obj := p_cust_acct_obj;
640: do_create_cust_acct_bo(
641: p_init_msg_list => p_init_msg_list,

Line 661: p_cust_acct_obj IN HZ_CUST_ACCT_BO,

657: END create_cust_acct_bo;
658:
659: PROCEDURE create_cust_acct_bo(
660: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
661: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
662: p_created_by_module IN VARCHAR2,
663: p_obj_source IN VARCHAR2 := null,
664: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
665: x_return_status OUT NOCOPY VARCHAR2,

Line 667: x_return_obj OUT NOCOPY HZ_CUST_ACCT_BO,

663: p_obj_source IN VARCHAR2 := null,
664: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
665: x_return_status OUT NOCOPY VARCHAR2,
666: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
667: x_return_obj OUT NOCOPY HZ_CUST_ACCT_BO,
668: x_cust_acct_id OUT NOCOPY NUMBER,
669: x_cust_acct_os OUT NOCOPY VARCHAR2,
670: x_cust_acct_osr OUT NOCOPY VARCHAR2,
671: px_parent_id IN OUT NOCOPY NUMBER,

Line 678: l_ca_obj HZ_CUST_ACCT_BO;

674: px_parent_obj_type IN OUT NOCOPY VARCHAR2
675: ) IS
676: l_msg_data VARCHAR2(2000);
677: l_msg_count NUMBER;
678: l_ca_obj HZ_CUST_ACCT_BO;
679: BEGIN
680: l_ca_obj := p_cust_acct_obj;
681: do_create_cust_acct_bo(
682: p_init_msg_list => fnd_api.g_true,

Line 709: p_cust_acct_obj IN HZ_CUST_ACCT_BO,

705: END create_cust_acct_bo;
706:
707: PROCEDURE update_cust_acct_bo(
708: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
709: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
710: p_created_by_module IN VARCHAR2,
711: x_return_status OUT NOCOPY VARCHAR2,
712: x_msg_count OUT NOCOPY NUMBER,
713: x_msg_data OUT NOCOPY VARCHAR2,

Line 718: l_ca_obj HZ_CUST_ACCT_BO;

714: x_cust_acct_id OUT NOCOPY NUMBER,
715: x_cust_acct_os OUT NOCOPY VARCHAR2,
716: x_cust_acct_osr OUT NOCOPY VARCHAR2
717: )IS
718: l_ca_obj HZ_CUST_ACCT_BO;
719: BEGIN
720: l_ca_obj := p_cust_acct_obj;
721: do_update_cust_acct_bo(
722: p_init_msg_list => p_init_msg_list,

Line 737: p_cust_acct_obj IN HZ_CUST_ACCT_BO,

733: );
734: END update_cust_acct_bo;
735:
736: PROCEDURE update_cust_acct_bo(
737: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
738: p_created_by_module IN VARCHAR2,
739: p_obj_source IN VARCHAR2 := null,
740: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
741: x_return_status OUT NOCOPY VARCHAR2,

Line 743: x_return_obj OUT NOCOPY HZ_CUST_ACCT_BO,

739: p_obj_source IN VARCHAR2 := null,
740: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
741: x_return_status OUT NOCOPY VARCHAR2,
742: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
743: x_return_obj OUT NOCOPY HZ_CUST_ACCT_BO,
744: x_cust_acct_id OUT NOCOPY NUMBER,
745: x_cust_acct_os OUT NOCOPY VARCHAR2,
746: x_cust_acct_osr OUT NOCOPY VARCHAR2
747: )IS

Line 750: l_ca_obj HZ_CUST_ACCT_BO;

746: x_cust_acct_osr OUT NOCOPY VARCHAR2
747: )IS
748: l_msg_data VARCHAR2(2000);
749: l_msg_count NUMBER;
750: l_ca_obj HZ_CUST_ACCT_BO;
751: BEGIN
752: l_ca_obj := p_cust_acct_obj;
753: do_update_cust_acct_bo(
754: p_init_msg_list => fnd_api.g_true,

Line 782: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,

778: -- Update customer account business object.
779: PROCEDURE do_update_cust_acct_bo(
780: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
781: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
782: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,
783: p_created_by_module IN VARCHAR2,
784: p_obj_source IN VARCHAR2 := null,
785: x_return_status OUT NOCOPY VARCHAR2,
786: x_msg_count OUT NOCOPY NUMBER,

Line 887: HZ_CUST_ACCT_BO_PVT.update_cust_profile(

883: -----------------------------
884: -- For Update account profile
885: -----------------------------
886: IF(p_cust_acct_obj.cust_profile_obj IS NOT NULL) THEN
887: HZ_CUST_ACCT_BO_PVT.update_cust_profile(
888: p_cp_obj => p_cust_acct_obj.cust_profile_obj,
889: p_ca_id => x_cust_acct_id,
890: p_casu_id => NULL,
891: x_cp_id => l_cust_acct_profile_id,

Line 908: HZ_CUST_ACCT_BO_PVT.save_cust_profile_amts(

904: -- For Update account profile amt
905: ---------------------------------
906: IF((p_cust_acct_obj.cust_profile_obj.cust_profile_amt_objs IS NOT NULL) AND
907: (p_cust_acct_obj.cust_profile_obj.cust_profile_amt_objs.COUNT > 0)) THEN
908: HZ_CUST_ACCT_BO_PVT.save_cust_profile_amts(
909: p_cpa_objs => p_cust_acct_obj.cust_profile_obj.cust_profile_amt_objs,
910: p_cp_id => l_cust_acct_profile_id,
911: p_ca_id => x_cust_acct_id,
912: p_casu_id => NULL,

Line 956: HZ_CUST_ACCT_BO_PVT.save_cust_acct_relates(

952: -- For Update account acct relate
953: -------------------------------
954: IF((p_cust_acct_obj.acct_relate_objs IS NOT NULL) AND
955: (p_cust_acct_obj.acct_relate_objs.COUNT > 0)) THEN
956: HZ_CUST_ACCT_BO_PVT.save_cust_acct_relates(
957: p_car_objs => p_cust_acct_obj.acct_relate_objs,
958: p_ca_id => x_cust_acct_id,
959: x_return_status => x_return_status,
960: x_msg_count => x_msg_count,

Line 1000: HZ_CUST_ACCT_BO_PVT.save_bank_acct_uses(

996: -- Call bank account use
997: ------------------------
998: IF((p_cust_acct_obj.bank_acct_use_objs IS NOT NULL) AND
999: (p_cust_acct_obj.bank_acct_use_objs.COUNT > 0)) THEN
1000: HZ_CUST_ACCT_BO_PVT.save_bank_acct_uses(
1001: p_bank_acct_use_objs => p_cust_acct_obj.bank_acct_use_objs,
1002: p_party_id => l_party_id,
1003: p_ca_id => x_cust_acct_id,
1004: p_casu_id => NULL,

Line 1019: HZ_CUST_ACCT_BO_PVT.save_payment_method(

1015: ------------------------
1016: -- Call payment method
1017: ------------------------
1018: IF(p_cust_acct_obj.payment_method_obj IS NOT NULL) THEN
1019: HZ_CUST_ACCT_BO_PVT.save_payment_method(
1020: p_payment_method_obj => p_cust_acct_obj.payment_method_obj,
1021: p_ca_id => x_cust_acct_id,
1022: p_casu_id => NULL,
1023: x_return_status => x_return_status,

Line 1152: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,

1148: -- Create or update customer account business object.
1149: PROCEDURE do_save_cust_acct_bo(
1150: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1151: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1152: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,
1153: p_created_by_module IN VARCHAR2,
1154: p_obj_source IN VARCHAR2 := null,
1155: x_return_status OUT NOCOPY VARCHAR2,
1156: x_msg_count OUT NOCOPY NUMBER,

Line 1325: p_cust_acct_obj IN HZ_CUST_ACCT_BO,

1321:
1322: PROCEDURE save_cust_acct_bo(
1323: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1324: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1325: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
1326: p_created_by_module IN VARCHAR2,
1327: x_return_status OUT NOCOPY VARCHAR2,
1328: x_msg_count OUT NOCOPY NUMBER,
1329: x_msg_data OUT NOCOPY VARCHAR2,

Line 1338: l_ca_obj HZ_CUST_ACCT_BO;

1334: px_parent_os IN OUT NOCOPY VARCHAR2,
1335: px_parent_osr IN OUT NOCOPY VARCHAR2,
1336: px_parent_obj_type IN OUT NOCOPY VARCHAR2
1337: ) IS
1338: l_ca_obj HZ_CUST_ACCT_BO;
1339: BEGIN
1340: l_ca_obj := p_cust_acct_obj;
1341: do_save_cust_acct_bo(
1342: p_init_msg_list => p_init_msg_list,

Line 1361: p_cust_acct_obj IN HZ_CUST_ACCT_BO,

1357: END save_cust_acct_bo;
1358:
1359: PROCEDURE save_cust_acct_bo(
1360: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1361: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
1362: p_created_by_module IN VARCHAR2,
1363: p_obj_source IN VARCHAR2 := null,
1364: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1365: x_return_status OUT NOCOPY VARCHAR2,

Line 1367: x_return_obj OUT NOCOPY HZ_CUST_ACCT_BO,

1363: p_obj_source IN VARCHAR2 := null,
1364: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1365: x_return_status OUT NOCOPY VARCHAR2,
1366: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1367: x_return_obj OUT NOCOPY HZ_CUST_ACCT_BO,
1368: x_cust_acct_id OUT NOCOPY NUMBER,
1369: x_cust_acct_os OUT NOCOPY VARCHAR2,
1370: x_cust_acct_osr OUT NOCOPY VARCHAR2,
1371: px_parent_id IN OUT NOCOPY NUMBER,

Line 1378: l_ca_obj HZ_CUST_ACCT_BO;

1374: px_parent_obj_type IN OUT NOCOPY VARCHAR2
1375: ) IS
1376: l_msg_data VARCHAR2(2000);
1377: l_msg_count NUMBER;
1378: l_ca_obj HZ_CUST_ACCT_BO;
1379: BEGIN
1380: l_ca_obj := p_cust_acct_obj;
1381: do_save_cust_acct_bo(
1382: p_init_msg_list => fnd_api.g_true,

Line 1470: x_cust_acct_obj OUT NOCOPY HZ_CUST_ACCT_BO,

1466: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1467: p_cust_acct_id IN NUMBER,
1468: p_cust_acct_os IN VARCHAR2,
1469: p_cust_acct_osr IN VARCHAR2,
1470: x_cust_acct_obj OUT NOCOPY HZ_CUST_ACCT_BO,
1471: x_return_status OUT NOCOPY VARCHAR2,
1472: x_msg_count OUT NOCOPY NUMBER,
1473: x_msg_data OUT NOCOPY VARCHAR2
1474: ) is

Line 1480: l_cust_acct_objs HZ_CUST_ACCT_BO_TBL;

1476:
1477: l_cust_acct_id number;
1478: l_cust_acct_os varchar2(30);
1479: l_cust_acct_osr varchar2(255);
1480: l_cust_acct_objs HZ_CUST_ACCT_BO_TBL;
1481: BEGIN
1482:
1483: -- initialize API return status to success.
1484: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1490:
1491:
1492: -- Debug info.
1493: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1494: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo(+)',
1495: p_prefix=>l_debug_prefix,
1496: p_msg_level=>fnd_log.level_procedure);
1497: END IF;
1498:

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

1542: END IF;
1543:
1544: -- Debug info.
1545: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1546: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1547: p_prefix=>l_debug_prefix,
1548: p_msg_level=>fnd_log.level_procedure);
1549: END IF;
1550:

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

1565: p_msg_type=>'ERROR',
1566: p_msg_level=>fnd_log.level_error);
1567: END IF;
1568: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1569: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1570: p_prefix=>l_debug_prefix,
1571: p_msg_level=>fnd_log.level_procedure);
1572: END IF;
1573: WHEN fnd_api.g_exc_unexpected_error THEN

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

1584: p_msg_type=>'UNEXPECTED ERROR',
1585: p_msg_level=>fnd_log.level_error);
1586: END IF;
1587: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1588: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1589: p_prefix=>l_debug_prefix,
1590: p_msg_level=>fnd_log.level_procedure);
1591: END IF;
1592: WHEN OTHERS THEN

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

1607: p_msg_type=>'SQL ERROR',
1608: p_msg_level=>fnd_log.level_error);
1609: END IF;
1610: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1611: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1612: p_prefix=>l_debug_prefix,
1613: p_msg_level=>fnd_log.level_procedure);
1614: END IF;
1615:

Line 1622: x_cust_acct_obj OUT NOCOPY HZ_CUST_ACCT_BO,

1618: PROCEDURE get_cust_acct_bo(
1619: p_cust_acct_id IN NUMBER,
1620: p_cust_acct_os IN VARCHAR2,
1621: p_cust_acct_osr IN VARCHAR2,
1622: x_cust_acct_obj OUT NOCOPY HZ_CUST_ACCT_BO,
1623: x_return_status OUT NOCOPY VARCHAR2,
1624: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1625: ) IS
1626: l_msg_data VARCHAR2(2000);

Line 1964: HZ_CUST_ACCT_BO_PVT.assign_cust_profile_rec(

1960: fnd_msg_pub.add;
1961: RAISE FND_API.G_EXC_ERROR;
1962: END IF;
1963:
1964: HZ_CUST_ACCT_BO_PVT.assign_cust_profile_rec(
1965: p_cust_profile_obj => p_cust_acct_v2_obj.cust_profile_obj,
1966: p_cust_acct_id => x_cust_acct_id,
1967: p_site_use_id => NULL,
1968: px_cust_profile_rec => l_profile_rec

Line 2024: HZ_CUST_ACCT_BO_PVT.create_cust_profile_amts(

2020: -- Create cust profile amount
2021: -----------------------------
2022: IF((p_cust_acct_v2_obj.cust_profile_obj.cust_profile_amt_objs IS NOT NULL) AND
2023: (p_cust_acct_v2_obj.cust_profile_obj.cust_profile_amt_objs.COUNT > 0)) THEN
2024: HZ_CUST_ACCT_BO_PVT.create_cust_profile_amts(
2025: p_cpa_objs => p_cust_acct_v2_obj.cust_profile_obj.cust_profile_amt_objs,
2026: p_cp_id => l_cust_acct_profile_id,
2027: p_ca_id => x_cust_acct_id,
2028: p_casu_id => NULL,

Line 2044: HZ_CUST_ACCT_BO_PVT.create_cust_acct_relates(

2040: -- Create cust acct relate
2041: -------------------------------------
2042: IF((p_cust_acct_v2_obj.acct_relate_objs IS NOT NULL) AND
2043: (p_cust_acct_v2_obj.acct_relate_objs.COUNT > 0)) THEN
2044: HZ_CUST_ACCT_BO_PVT.create_cust_acct_relates(
2045: p_car_objs => p_cust_acct_v2_obj.acct_relate_objs,
2046: p_ca_id => x_cust_acct_id,
2047: x_return_status => x_return_status,
2048: x_msg_count => x_msg_count,

Line 2117: HZ_CUST_ACCT_BO_PVT.save_bank_acct_uses(

2113: -- Call bank account use
2114: ------------------------
2115: IF((p_cust_acct_v2_obj.bank_acct_use_objs IS NOT NULL) AND
2116: (p_cust_acct_v2_obj.bank_acct_use_objs.COUNT > 0)) THEN
2117: HZ_CUST_ACCT_BO_PVT.save_bank_acct_uses(
2118: p_bank_acct_use_objs => p_cust_acct_v2_obj.bank_acct_use_objs,
2119: p_party_id => l_party_id,
2120: p_ca_id => x_cust_acct_id,
2121: p_casu_id => NULL,

Line 2137: HZ_CUST_ACCT_BO_PVT.create_payment_methods(

2133: -- Call payment method
2134: ------------------------
2135: IF((p_cust_acct_v2_obj.payment_method_objs IS NOT NULL) AND
2136: (p_cust_acct_v2_obj.payment_method_objs.COUNT>0)) THEN
2137: HZ_CUST_ACCT_BO_PVT.create_payment_methods(
2138: p_payment_method_objs => p_cust_acct_v2_obj.payment_method_objs,
2139: p_ca_id => x_cust_acct_id,
2140: p_casu_id => NULL,
2141: x_return_status => x_return_status,

Line 2463: HZ_CUST_ACCT_BO_PVT.update_cust_profile(

2459: -----------------------------
2460: -- For Update account profile
2461: -----------------------------
2462: IF(p_cust_acct_v2_obj.cust_profile_obj IS NOT NULL) THEN
2463: HZ_CUST_ACCT_BO_PVT.update_cust_profile(
2464: p_cp_obj => p_cust_acct_v2_obj.cust_profile_obj,
2465: p_ca_id => x_cust_acct_id,
2466: p_casu_id => NULL,
2467: x_cp_id => l_cust_acct_profile_id,

Line 2484: HZ_CUST_ACCT_BO_PVT.save_cust_profile_amts(

2480: -- For Update account profile amt
2481: ---------------------------------
2482: IF((p_cust_acct_v2_obj.cust_profile_obj.cust_profile_amt_objs IS NOT NULL) AND
2483: (p_cust_acct_v2_obj.cust_profile_obj.cust_profile_amt_objs.COUNT > 0)) THEN
2484: HZ_CUST_ACCT_BO_PVT.save_cust_profile_amts(
2485: p_cpa_objs => p_cust_acct_v2_obj.cust_profile_obj.cust_profile_amt_objs,
2486: p_cp_id => l_cust_acct_profile_id,
2487: p_ca_id => x_cust_acct_id,
2488: p_casu_id => NULL,

Line 2532: HZ_CUST_ACCT_BO_PVT.save_cust_acct_relates(

2528: -- For Update account acct relate
2529: -------------------------------
2530: IF((p_cust_acct_v2_obj.acct_relate_objs IS NOT NULL) AND
2531: (p_cust_acct_v2_obj.acct_relate_objs.COUNT > 0)) THEN
2532: HZ_CUST_ACCT_BO_PVT.save_cust_acct_relates(
2533: p_car_objs => p_cust_acct_v2_obj.acct_relate_objs,
2534: p_ca_id => x_cust_acct_id,
2535: x_return_status => x_return_status,
2536: x_msg_count => x_msg_count,

Line 2576: HZ_CUST_ACCT_BO_PVT.save_bank_acct_uses(

2572: -- Call bank account use
2573: ------------------------
2574: IF((p_cust_acct_v2_obj.bank_acct_use_objs IS NOT NULL) AND
2575: (p_cust_acct_v2_obj.bank_acct_use_objs.COUNT > 0)) THEN
2576: HZ_CUST_ACCT_BO_PVT.save_bank_acct_uses(
2577: p_bank_acct_use_objs => p_cust_acct_v2_obj.bank_acct_use_objs,
2578: p_party_id => l_party_id,
2579: p_ca_id => x_cust_acct_id,
2580: p_casu_id => NULL,

Line 2596: HZ_CUST_ACCT_BO_PVT.save_payment_methods(

2592: -- Call payment method
2593: ------------------------
2594: IF((p_cust_acct_v2_obj.payment_method_objs IS NOT NULL) AND
2595: (p_cust_acct_v2_obj.payment_method_objs.COUNT > 0 )) THEN
2596: HZ_CUST_ACCT_BO_PVT.save_payment_methods(
2597: p_payment_method_objs => p_cust_acct_v2_obj.payment_method_objs,
2598: p_ca_id => x_cust_acct_id,
2599: p_casu_id => NULL,
2600: x_return_status => x_return_status,

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

3030:
3031:
3032: -- Debug info.
3033: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3034: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo(+)',
3035: p_prefix=>l_debug_prefix,
3036: p_msg_level=>fnd_log.level_procedure);
3037: END IF;
3038:

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

3082: END IF;
3083:
3084: -- Debug info.
3085: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3086: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3087: p_prefix=>l_debug_prefix,
3088: p_msg_level=>fnd_log.level_procedure);
3089: END IF;
3090:

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

3105: p_msg_type=>'ERROR',
3106: p_msg_level=>fnd_log.level_error);
3107: END IF;
3108: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3109: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3110: p_prefix=>l_debug_prefix,
3111: p_msg_level=>fnd_log.level_procedure);
3112: END IF;
3113: WHEN fnd_api.g_exc_unexpected_error THEN

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

3124: p_msg_type=>'UNEXPECTED ERROR',
3125: p_msg_level=>fnd_log.level_error);
3126: END IF;
3127: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3128: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3129: p_prefix=>l_debug_prefix,
3130: p_msg_level=>fnd_log.level_procedure);
3131: END IF;
3132: WHEN OTHERS THEN

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

3147: p_msg_type=>'SQL ERROR',
3148: p_msg_level=>fnd_log.level_error);
3149: END IF;
3150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3151: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3152: p_prefix=>l_debug_prefix,
3153: p_msg_level=>fnd_log.level_procedure);
3154: END IF;
3155:

Line 3185: END hz_cust_acct_bo_pub;

3181: x_msg_count => l_msg_count,
3182: x_msg_data => l_msg_data);
3183: END get_cust_acct_v2_bo;
3184:
3185: END hz_cust_acct_bo_pub;