APPS.HZ_ORG_CUST_BO_PUB dependencies on HZ_ORG_CUST_BO

Line 1: PACKAGE BODY HZ_ORG_CUST_BO_PUB AS

1: PACKAGE BODY HZ_ORG_CUST_BO_PUB AS
2: /*$Header: ARHBOABB.pls 120.19 2008/02/06 10:31:34 vsegu ship $ */
3: PROCEDURE do_create_org_cust_bo(
4: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

Line 6: p_org_cust_obj IN OUT NOCOPY HZ_ORG_CUST_BO,

2: /*$Header: ARHBOABB.pls 120.19 2008/02/06 10:31:34 vsegu ship $ */
3: PROCEDURE do_create_org_cust_bo(
4: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
6: p_org_cust_obj IN OUT NOCOPY HZ_ORG_CUST_BO,
7: p_created_by_module IN VARCHAR2,
8: p_obj_source IN VARCHAR2 := null,
9: x_return_status OUT NOCOPY VARCHAR2,
10: x_msg_count OUT NOCOPY NUMBER,

Line 17: p_org_cust_obj IN OUT NOCOPY HZ_ORG_CUST_BO,

13: );
14:
15: PROCEDURE do_update_org_cust_bo(
16: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
17: p_org_cust_obj IN OUT NOCOPY HZ_ORG_CUST_BO,
18: p_created_by_module IN VARCHAR2,
19: p_obj_source IN VARCHAR2 := null,
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,

Line 29: p_org_cust_obj IN OUT NOCOPY HZ_ORG_CUST_BO,

25:
26: PROCEDURE do_save_org_cust_bo(
27: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
28: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
29: p_org_cust_obj IN OUT NOCOPY HZ_ORG_CUST_BO,
30: p_created_by_module IN VARCHAR2,
31: p_obj_source IN VARCHAR2 := null,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,

Line 45: p_org_cust_obj IN OUT NOCOPY HZ_ORG_CUST_BO,

41: -- Create org customer account.
42: PROCEDURE do_create_org_cust_bo(
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
44: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
45: p_org_cust_obj IN OUT NOCOPY HZ_ORG_CUST_BO,
46: p_created_by_module IN VARCHAR2,
47: p_obj_source IN VARCHAR2 := null,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,

Line 303: p_org_cust_obj IN HZ_ORG_CUST_BO,

299:
300: PROCEDURE create_org_cust_bo(
301: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
302: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
303: p_org_cust_obj IN HZ_ORG_CUST_BO,
304: p_created_by_module IN VARCHAR2,
305: x_return_status OUT NOCOPY VARCHAR2,
306: x_msg_count OUT NOCOPY NUMBER,
307: x_msg_data OUT NOCOPY VARCHAR2,

Line 310: l_oc_obj HZ_ORG_CUST_BO;

306: x_msg_count OUT NOCOPY NUMBER,
307: x_msg_data OUT NOCOPY VARCHAR2,
308: x_organization_id OUT NOCOPY NUMBER
309: ) IS
310: l_oc_obj HZ_ORG_CUST_BO;
311: BEGIN
312: l_oc_obj := p_org_cust_obj;
313: do_create_org_cust_bo(
314: p_init_msg_list => p_init_msg_list,

Line 328: p_org_cust_obj IN HZ_ORG_CUST_BO,

324: END create_org_cust_bo;
325:
326: PROCEDURE create_org_cust_bo(
327: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
328: p_org_cust_obj IN HZ_ORG_CUST_BO,
329: p_created_by_module IN VARCHAR2,
330: p_obj_source IN VARCHAR2 := null,
331: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
332: x_return_status OUT NOCOPY VARCHAR2,

Line 334: x_return_obj OUT NOCOPY HZ_ORG_CUST_BO,

330: p_obj_source IN VARCHAR2 := null,
331: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
332: x_return_status OUT NOCOPY VARCHAR2,
333: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
334: x_return_obj OUT NOCOPY HZ_ORG_CUST_BO,
335: x_organization_id OUT NOCOPY NUMBER
336: ) IS
337: l_msg_count NUMBER;
338: l_msg_data VARCHAR2(2000);

Line 339: l_oc_obj HZ_ORG_CUST_BO;

335: x_organization_id OUT NOCOPY NUMBER
336: ) IS
337: l_msg_count NUMBER;
338: l_msg_data VARCHAR2(2000);
339: l_oc_obj HZ_ORG_CUST_BO;
340: BEGIN
341: l_oc_obj := p_org_cust_obj;
342: do_create_org_cust_bo(
343: p_init_msg_list => fnd_api.g_true,

Line 368: p_org_cust_obj IN OUT NOCOPY HZ_ORG_CUST_BO,

364: -- DESCRIPTION
365: -- Update org customer account.
366: PROCEDURE do_update_org_cust_bo(
367: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
368: p_org_cust_obj IN OUT NOCOPY HZ_ORG_CUST_BO,
369: p_created_by_module IN VARCHAR2,
370: p_obj_source IN VARCHAR2 := null,
371: x_return_status OUT NOCOPY VARCHAR2,
372: x_msg_count OUT NOCOPY NUMBER,

Line 641: p_org_cust_obj IN HZ_ORG_CUST_BO,

637: END do_update_org_cust_bo;
638:
639: PROCEDURE update_org_cust_bo(
640: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
641: p_org_cust_obj IN HZ_ORG_CUST_BO,
642: p_created_by_module IN VARCHAR2,
643: x_return_status OUT NOCOPY VARCHAR2,
644: x_msg_count OUT NOCOPY NUMBER,
645: x_msg_data OUT NOCOPY VARCHAR2,

Line 648: l_oc_obj HZ_ORG_CUST_BO;

644: x_msg_count OUT NOCOPY NUMBER,
645: x_msg_data OUT NOCOPY VARCHAR2,
646: x_organization_id OUT NOCOPY NUMBER
647: ) IS
648: l_oc_obj HZ_ORG_CUST_BO;
649: BEGIN
650: l_oc_obj := p_org_cust_obj;
651: do_update_org_cust_bo(
652: p_init_msg_list => p_init_msg_list,

Line 664: p_org_cust_obj IN HZ_ORG_CUST_BO,

660: );
661: END update_org_cust_bo;
662:
663: PROCEDURE update_org_cust_bo(
664: p_org_cust_obj IN HZ_ORG_CUST_BO,
665: p_created_by_module IN VARCHAR2,
666: p_obj_source IN VARCHAR2 := null,
667: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
668: x_return_status OUT NOCOPY VARCHAR2,

Line 670: x_return_obj OUT NOCOPY HZ_ORG_CUST_BO,

666: p_obj_source IN VARCHAR2 := null,
667: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
668: x_return_status OUT NOCOPY VARCHAR2,
669: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
670: x_return_obj OUT NOCOPY HZ_ORG_CUST_BO,
671: x_organization_id OUT NOCOPY NUMBER
672: ) IS
673: l_msg_count NUMBER;
674: l_msg_data VARCHAR2(2000);

Line 675: l_oc_obj HZ_ORG_CUST_BO;

671: x_organization_id OUT NOCOPY NUMBER
672: ) IS
673: l_msg_count NUMBER;
674: l_msg_data VARCHAR2(2000);
675: l_oc_obj HZ_ORG_CUST_BO;
676: BEGIN
677: l_oc_obj := p_org_cust_obj;
678: do_update_org_cust_bo(
679: p_init_msg_list => fnd_api.g_true,

Line 704: p_org_cust_obj IN OUT NOCOPY HZ_ORG_CUST_BO,

700: -- Create or update org customer account.
701: PROCEDURE do_save_org_cust_bo(
702: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
703: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
704: p_org_cust_obj IN OUT NOCOPY HZ_ORG_CUST_BO,
705: p_created_by_module IN VARCHAR2,
706: p_obj_source IN VARCHAR2 := null,
707: x_return_status OUT NOCOPY VARCHAR2,
708: x_msg_count OUT NOCOPY NUMBER,

Line 866: p_org_cust_obj IN HZ_ORG_CUST_BO,

862:
863: PROCEDURE save_org_cust_bo(
864: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
865: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
866: p_org_cust_obj IN HZ_ORG_CUST_BO,
867: p_created_by_module IN VARCHAR2,
868: x_return_status OUT NOCOPY VARCHAR2,
869: x_msg_count OUT NOCOPY NUMBER,
870: x_msg_data OUT NOCOPY VARCHAR2,

Line 873: l_oc_obj HZ_ORG_CUST_BO;

869: x_msg_count OUT NOCOPY NUMBER,
870: x_msg_data OUT NOCOPY VARCHAR2,
871: x_organization_id OUT NOCOPY NUMBER
872: ) IS
873: l_oc_obj HZ_ORG_CUST_BO;
874: BEGIN
875: l_oc_obj := p_org_cust_obj;
876: do_save_org_cust_bo(
877: p_init_msg_list => p_init_msg_list,

Line 891: p_org_cust_obj IN HZ_ORG_CUST_BO,

887: END save_org_cust_bo;
888:
889: PROCEDURE save_org_cust_bo(
890: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
891: p_org_cust_obj IN HZ_ORG_CUST_BO,
892: p_created_by_module IN VARCHAR2,
893: p_obj_source IN VARCHAR2 := null,
894: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
895: x_return_status OUT NOCOPY VARCHAR2,

Line 897: x_return_obj OUT NOCOPY HZ_ORG_CUST_BO,

893: p_obj_source IN VARCHAR2 := null,
894: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
895: x_return_status OUT NOCOPY VARCHAR2,
896: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
897: x_return_obj OUT NOCOPY HZ_ORG_CUST_BO,
898: x_organization_id OUT NOCOPY NUMBER
899: ) IS
900: l_msg_count NUMBER;
901: l_msg_data VARCHAR2(2000);

Line 902: l_oc_obj HZ_ORG_CUST_BO;

898: x_organization_id OUT NOCOPY NUMBER
899: ) IS
900: l_msg_count NUMBER;
901: l_msg_data VARCHAR2(2000);
902: l_oc_obj HZ_ORG_CUST_BO;
903: BEGIN
904: l_oc_obj := p_org_cust_obj;
905: do_save_org_cust_bo(
906: p_init_msg_list => fnd_api.g_true,

Line 983: x_org_cust_obj OUT NOCOPY HZ_ORG_CUST_BO,

979: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
980: p_organization_id IN NUMBER,
981: p_organization_os IN VARCHAR2,
982: p_organization_osr IN VARCHAR2,
983: x_org_cust_obj OUT NOCOPY HZ_ORG_CUST_BO,
984: x_return_status OUT NOCOPY VARCHAR2,
985: x_msg_count OUT NOCOPY NUMBER,
986: x_msg_data OUT NOCOPY VARCHAR2
987: ) is

Line 1006: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo(+)',

1002:
1003:
1004: -- Debug info.
1005: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1006: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo(+)',
1007: p_prefix=>l_debug_prefix,
1008: p_msg_level=>fnd_log.level_procedure);
1009: END IF;
1010:

Line 1055: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',

1051: END IF;
1052:
1053: -- Debug info.
1054: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1055: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1056: p_prefix=>l_debug_prefix,
1057: p_msg_level=>fnd_log.level_procedure);
1058: END IF;
1059:

Line 1078: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',

1074: p_msg_type=>'ERROR',
1075: p_msg_level=>fnd_log.level_error);
1076: END IF;
1077: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1078: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1079: p_prefix=>l_debug_prefix,
1080: p_msg_level=>fnd_log.level_procedure);
1081: END IF;
1082: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1097: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',

1093: p_msg_type=>'UNEXPECTED ERROR',
1094: p_msg_level=>fnd_log.level_error);
1095: END IF;
1096: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1097: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1098: p_prefix=>l_debug_prefix,
1099: p_msg_level=>fnd_log.level_procedure);
1100: END IF;
1101: WHEN OTHERS THEN

Line 1120: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',

1116: p_msg_type=>'SQL ERROR',
1117: p_msg_level=>fnd_log.level_error);
1118: END IF;
1119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1120: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1121: p_prefix=>l_debug_prefix,
1122: p_msg_level=>fnd_log.level_procedure);
1123: END IF;
1124:

Line 1131: x_org_cust_obj OUT NOCOPY HZ_ORG_CUST_BO,

1127: PROCEDURE get_org_cust_bo(
1128: p_organization_id IN NUMBER,
1129: p_organization_os IN VARCHAR2,
1130: p_organization_osr IN VARCHAR2,
1131: x_org_cust_obj OUT NOCOPY HZ_ORG_CUST_BO,
1132: x_return_status OUT NOCOPY VARCHAR2,
1133: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1134: ) IS
1135: l_msg_data VARCHAR2(2000);

Line 1207: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL,

1203:
1204: PROCEDURE get_org_custs_created(
1205: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1206: p_event_id IN NUMBER,
1207: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL,
1208: x_return_status OUT NOCOPY VARCHAR2,
1209: x_msg_count OUT NOCOPY NUMBER,
1210: x_msg_data OUT NOCOPY VARCHAR2
1211: ) is

Line 1226: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(+)',

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

Line 1265: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created (-)',

1261: END IF;
1262:
1263: -- Debug info.
1264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1265: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created (-)',
1266: p_prefix=>l_debug_prefix,
1267: p_msg_level=>fnd_log.level_procedure);
1268: END IF;
1269:

Line 1288: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',

1284: p_msg_type=>'ERROR',
1285: p_msg_level=>fnd_log.level_error);
1286: END IF;
1287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1288: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',
1289: p_prefix=>l_debug_prefix,
1290: p_msg_level=>fnd_log.level_procedure);
1291: END IF;
1292: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1307: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',

1303: p_msg_type=>'UNEXPECTED ERROR',
1304: p_msg_level=>fnd_log.level_error);
1305: END IF;
1306: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1307: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',
1308: p_prefix=>l_debug_prefix,
1309: p_msg_level=>fnd_log.level_procedure);
1310: END IF;
1311: WHEN OTHERS THEN

Line 1330: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',

1326: p_msg_type=>'SQL ERROR',
1327: p_msg_level=>fnd_log.level_error);
1328: END IF;
1329: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1330: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',
1331: p_prefix=>l_debug_prefix,
1332: p_msg_level=>fnd_log.level_procedure);
1333: END IF;
1334:

Line 1339: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL,

1335: end;
1336:
1337: PROCEDURE get_org_custs_created(
1338: p_event_id IN NUMBER,
1339: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL,
1340: x_return_status OUT NOCOPY VARCHAR2,
1341: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1342: ) IS
1343: l_msg_data VARCHAR2(2000);

Line 1371: --the procedure returns database objects of the type HZ_ORG_CUST_BO for all of

1367: -- PROCEDURE get_org_custs_updated
1368: --
1369: -- DESCRIPTION
1370: --The caller provides an identifier for the Organization Customers update business event and
1371: --the procedure returns database objects of the type HZ_ORG_CUST_BO for all of
1372: --the Organization Customer business objects from the business event.
1373:
1374: --
1375: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 1405: of the type HZ_ORG_CUST_BO for all of the Organization Customer business objects from the business event.

1401: The Get Organization Customers Updated procedure is a service to retrieve all of the Organization Customer business objects whose
1402: updates have been captured by the logical business event. Each Organization Customers Updated business event signifies that one or
1403: more Organization Customer business objects have been updated.
1404: The caller provides an identifier for the Organization Customers Update business event and the procedure returns database objects
1405: of the type HZ_ORG_CUST_BO for all of the Organization Customer business objects from the business event.
1406: Gathering all of the returned database objects from those API calls, the procedure packages them in a table structure and returns
1407: them to the caller.
1408: */
1409:

Line 1413: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL,

1409:
1410: PROCEDURE get_org_custs_updated(
1411: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1412: p_event_id IN NUMBER,
1413: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL,
1414: x_return_status OUT NOCOPY VARCHAR2,
1415: x_msg_count OUT NOCOPY NUMBER,
1416: x_msg_data OUT NOCOPY VARCHAR2
1417: ) is

Line 1433: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(+)',

1429:
1430:
1431: -- Debug info.
1432: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1433: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(+)',
1434: p_prefix=>l_debug_prefix,
1435: p_msg_level=>fnd_log.level_procedure);
1436: END IF;
1437:

Line 1472: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated (-)',

1468: END IF;
1469:
1470: -- Debug info.
1471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1472: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated (-)',
1473: p_prefix=>l_debug_prefix,
1474: p_msg_level=>fnd_log.level_procedure);
1475: END IF;
1476:

Line 1495: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',

1491: p_msg_type=>'ERROR',
1492: p_msg_level=>fnd_log.level_error);
1493: END IF;
1494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1495: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
1496: p_prefix=>l_debug_prefix,
1497: p_msg_level=>fnd_log.level_procedure);
1498: END IF;
1499: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1514: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',

1510: p_msg_type=>'UNEXPECTED ERROR',
1511: p_msg_level=>fnd_log.level_error);
1512: END IF;
1513: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1514: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
1515: p_prefix=>l_debug_prefix,
1516: p_msg_level=>fnd_log.level_procedure);
1517: END IF;
1518: WHEN OTHERS THEN

Line 1537: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',

1533: p_msg_type=>'SQL ERROR',
1534: p_msg_level=>fnd_log.level_error);
1535: END IF;
1536: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1537: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
1538: p_prefix=>l_debug_prefix,
1539: p_msg_level=>fnd_log.level_procedure);
1540: END IF;
1541:

Line 1546: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL,

1542: end;
1543:
1544: PROCEDURE get_org_custs_updated(
1545: p_event_id IN NUMBER,
1546: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL,
1547: x_return_status OUT NOCOPY VARCHAR2,
1548: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1549: ) IS
1550: l_msg_data VARCHAR2(2000);

Line 1573: x_org_cust_obj OUT NOCOPY HZ_ORG_CUST_BO,

1569: PROCEDURE get_org_cust_updated(
1570: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1571: p_event_id IN NUMBER,
1572: p_org_cust_id IN NUMBER,
1573: x_org_cust_obj OUT NOCOPY HZ_ORG_CUST_BO,
1574: x_return_status OUT NOCOPY VARCHAR2,
1575: x_msg_count OUT NOCOPY NUMBER,
1576: x_msg_data OUT NOCOPY VARCHAR2
1577: ) is

Line 1592: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(+)',

1588:
1589:
1590: -- Debug info.
1591: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1592: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(+)',
1593: p_prefix=>l_debug_prefix,
1594: p_msg_level=>fnd_log.level_procedure);
1595: END IF;
1596:

Line 1632: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated (-)',

1628: END IF;
1629:
1630: -- Debug info.
1631: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1632: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated (-)',
1633: p_prefix=>l_debug_prefix,
1634: p_msg_level=>fnd_log.level_procedure);
1635: END IF;
1636:

Line 1655: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',

1651: p_msg_type=>'ERROR',
1652: p_msg_level=>fnd_log.level_error);
1653: END IF;
1654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1655: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
1656: p_prefix=>l_debug_prefix,
1657: p_msg_level=>fnd_log.level_procedure);
1658: END IF;
1659: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1674: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',

1670: p_msg_type=>'UNEXPECTED ERROR',
1671: p_msg_level=>fnd_log.level_error);
1672: END IF;
1673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1674: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
1675: p_prefix=>l_debug_prefix,
1676: p_msg_level=>fnd_log.level_procedure);
1677: END IF;
1678: WHEN OTHERS THEN

Line 1697: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',

1693: p_msg_type=>'SQL ERROR',
1694: p_msg_level=>fnd_log.level_error);
1695: END IF;
1696: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1697: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
1698: p_prefix=>l_debug_prefix,
1699: p_msg_level=>fnd_log.level_procedure);
1700: END IF;
1701:

Line 1707: x_org_cust_obj OUT NOCOPY HZ_ORG_CUST_BO,

1703:
1704: PROCEDURE get_org_cust_updated(
1705: p_event_id IN NUMBER,
1706: p_org_cust_id IN NUMBER,
1707: x_org_cust_obj OUT NOCOPY HZ_ORG_CUST_BO,
1708: x_return_status OUT NOCOPY VARCHAR2,
1709: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1710: ) IS
1711: l_msg_data VARCHAR2(2000);

Line 2894: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo(+)',

2890:
2891:
2892: -- Debug info.
2893: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2894: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo(+)',
2895: p_prefix=>l_debug_prefix,
2896: p_msg_level=>fnd_log.level_procedure);
2897: END IF;
2898:

Line 2943: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',

2939: END IF;
2940:
2941: -- Debug info.
2942: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2943: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
2944: p_prefix=>l_debug_prefix,
2945: p_msg_level=>fnd_log.level_procedure);
2946: END IF;
2947:

Line 2966: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',

2962: p_msg_type=>'ERROR',
2963: p_msg_level=>fnd_log.level_error);
2964: END IF;
2965: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2966: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
2967: p_prefix=>l_debug_prefix,
2968: p_msg_level=>fnd_log.level_procedure);
2969: END IF;
2970: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2985: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',

2981: p_msg_type=>'UNEXPECTED ERROR',
2982: p_msg_level=>fnd_log.level_error);
2983: END IF;
2984: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2985: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
2986: p_prefix=>l_debug_prefix,
2987: p_msg_level=>fnd_log.level_procedure);
2988: END IF;
2989: WHEN OTHERS THEN

Line 3008: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',

3004: p_msg_type=>'SQL ERROR',
3005: p_msg_level=>fnd_log.level_error);
3006: END IF;
3007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3008: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
3009: p_prefix=>l_debug_prefix,
3010: p_msg_level=>fnd_log.level_procedure);
3011: END IF;
3012:

Line 3113: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(+)',

3109:
3110:
3111: -- Debug info.
3112: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3113: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(+)',
3114: p_prefix=>l_debug_prefix,
3115: p_msg_level=>fnd_log.level_procedure);
3116: END IF;
3117:

Line 3152: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created (-)',

3148: END IF;
3149:
3150: -- Debug info.
3151: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3152: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created (-)',
3153: p_prefix=>l_debug_prefix,
3154: p_msg_level=>fnd_log.level_procedure);
3155: END IF;
3156:

Line 3175: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',

3171: p_msg_type=>'ERROR',
3172: p_msg_level=>fnd_log.level_error);
3173: END IF;
3174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3175: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',
3176: p_prefix=>l_debug_prefix,
3177: p_msg_level=>fnd_log.level_procedure);
3178: END IF;
3179: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3194: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',

3190: p_msg_type=>'UNEXPECTED ERROR',
3191: p_msg_level=>fnd_log.level_error);
3192: END IF;
3193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3194: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',
3195: p_prefix=>l_debug_prefix,
3196: p_msg_level=>fnd_log.level_procedure);
3197: END IF;
3198: WHEN OTHERS THEN

Line 3217: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',

3213: p_msg_type=>'SQL ERROR',
3214: p_msg_level=>fnd_log.level_error);
3215: END IF;
3216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3217: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',
3218: p_prefix=>l_debug_prefix,
3219: p_msg_level=>fnd_log.level_procedure);
3220: END IF;
3221:

Line 3315: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(+)',

3311:
3312:
3313: -- Debug info.
3314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3315: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(+)',
3316: p_prefix=>l_debug_prefix,
3317: p_msg_level=>fnd_log.level_procedure);
3318: END IF;
3319:

Line 3354: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated (-)',

3350: END IF;
3351:
3352: -- Debug info.
3353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3354: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated (-)',
3355: p_prefix=>l_debug_prefix,
3356: p_msg_level=>fnd_log.level_procedure);
3357: END IF;
3358:

Line 3377: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',

3373: p_msg_type=>'ERROR',
3374: p_msg_level=>fnd_log.level_error);
3375: END IF;
3376: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3377: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
3378: p_prefix=>l_debug_prefix,
3379: p_msg_level=>fnd_log.level_procedure);
3380: END IF;
3381: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3396: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',

3392: p_msg_type=>'UNEXPECTED ERROR',
3393: p_msg_level=>fnd_log.level_error);
3394: END IF;
3395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3396: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
3397: p_prefix=>l_debug_prefix,
3398: p_msg_level=>fnd_log.level_procedure);
3399: END IF;
3400: WHEN OTHERS THEN

Line 3419: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',

3415: p_msg_type=>'SQL ERROR',
3416: p_msg_level=>fnd_log.level_error);
3417: END IF;
3418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3419: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
3420: p_prefix=>l_debug_prefix,
3421: p_msg_level=>fnd_log.level_procedure);
3422: END IF;
3423:

Line 3473: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(+)',

3469:
3470:
3471: -- Debug info.
3472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3473: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(+)',
3474: p_prefix=>l_debug_prefix,
3475: p_msg_level=>fnd_log.level_procedure);
3476: END IF;
3477:

Line 3513: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated (-)',

3509: END IF;
3510:
3511: -- Debug info.
3512: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3513: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated (-)',
3514: p_prefix=>l_debug_prefix,
3515: p_msg_level=>fnd_log.level_procedure);
3516: END IF;
3517:

Line 3536: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',

3532: p_msg_type=>'ERROR',
3533: p_msg_level=>fnd_log.level_error);
3534: END IF;
3535: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3536: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
3537: p_prefix=>l_debug_prefix,
3538: p_msg_level=>fnd_log.level_procedure);
3539: END IF;
3540: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3555: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',

3551: p_msg_type=>'UNEXPECTED ERROR',
3552: p_msg_level=>fnd_log.level_error);
3553: END IF;
3554: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3555: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
3556: p_prefix=>l_debug_prefix,
3557: p_msg_level=>fnd_log.level_procedure);
3558: END IF;
3559: WHEN OTHERS THEN

Line 3578: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',

3574: p_msg_type=>'SQL ERROR',
3575: p_msg_level=>fnd_log.level_error);
3576: END IF;
3577: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3578: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
3579: p_prefix=>l_debug_prefix,
3580: p_msg_level=>fnd_log.level_procedure);
3581: END IF;
3582:

Line 3610: END hz_org_cust_bo_pub;

3606: x_msg_count => l_msg_count,
3607: x_msg_data => l_msg_data);
3608: END get_v2_org_cust_updated;
3609:
3610: END hz_org_cust_bo_pub;