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_PERSON_CUST_BO_PUB dependencies on HZ_PERSON_CUST_BO

Line 1: PACKAGE BODY HZ_PERSON_CUST_BO_PUB AS

1: PACKAGE BODY HZ_PERSON_CUST_BO_PUB AS
2: /*$Header: ARHBPABB.pls 120.20 2008/02/06 10:14:13 vsegu ship $ */
3: PROCEDURE do_create_person_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_person_cust_obj IN OUT NOCOPY HZ_PERSON_CUST_BO,

2: /*$Header: ARHBPABB.pls 120.20 2008/02/06 10:14:13 vsegu ship $ */
3: PROCEDURE do_create_person_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_person_cust_obj IN OUT NOCOPY HZ_PERSON_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_person_cust_obj IN OUT NOCOPY HZ_PERSON_CUST_BO,

13: );
14:
15: PROCEDURE do_update_person_cust_bo(
16: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
17: p_person_cust_obj IN OUT NOCOPY HZ_PERSON_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_person_cust_obj IN OUT NOCOPY HZ_PERSON_CUST_BO,

25:
26: PROCEDURE do_save_person_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_person_cust_obj IN OUT NOCOPY HZ_PERSON_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_person_cust_obj IN OUT NOCOPY HZ_PERSON_CUST_BO,

41: -- Create person customer account.
42: PROCEDURE do_create_person_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_person_cust_obj IN OUT NOCOPY HZ_PERSON_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 304: p_person_cust_obj IN HZ_PERSON_CUST_BO,

300:
301: PROCEDURE create_person_cust_bo(
302: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
303: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
304: p_person_cust_obj IN HZ_PERSON_CUST_BO,
305: p_created_by_module IN VARCHAR2,
306: x_return_status OUT NOCOPY VARCHAR2,
307: x_msg_count OUT NOCOPY NUMBER,
308: x_msg_data OUT NOCOPY VARCHAR2,

Line 311: l_pc_obj HZ_PERSON_CUST_BO;

307: x_msg_count OUT NOCOPY NUMBER,
308: x_msg_data OUT NOCOPY VARCHAR2,
309: x_person_id OUT NOCOPY NUMBER
310: ) IS
311: l_pc_obj HZ_PERSON_CUST_BO;
312: BEGIN
313: l_pc_obj := p_person_cust_obj;
314: do_create_person_cust_bo(
315: p_init_msg_list => p_init_msg_list,

Line 329: p_person_cust_obj IN HZ_PERSON_CUST_BO,

325: END create_person_cust_bo;
326:
327: PROCEDURE create_person_cust_bo(
328: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
329: p_person_cust_obj IN HZ_PERSON_CUST_BO,
330: p_created_by_module IN VARCHAR2,
331: p_obj_source IN VARCHAR2 := null,
332: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
333: x_return_status OUT NOCOPY VARCHAR2,

Line 335: x_return_obj OUT NOCOPY HZ_PERSON_CUST_BO,

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

Line 340: l_pc_obj HZ_PERSON_CUST_BO;

336: x_person_id OUT NOCOPY NUMBER
337: ) IS
338: l_msg_data VARCHAR2(2000);
339: l_msg_count NUMBER;
340: l_pc_obj HZ_PERSON_CUST_BO;
341: BEGIN
342: l_pc_obj := p_person_cust_obj;
343: do_create_person_cust_bo(
344: p_init_msg_list => fnd_api.g_true,

Line 369: p_person_cust_obj IN OUT NOCOPY HZ_PERSON_CUST_BO,

365: -- DESCRIPTION
366: -- Update person customer account.
367: PROCEDURE do_update_person_cust_bo(
368: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
369: p_person_cust_obj IN OUT NOCOPY HZ_PERSON_CUST_BO,
370: p_created_by_module IN VARCHAR2,
371: p_obj_source IN VARCHAR2 := null,
372: x_return_status OUT NOCOPY VARCHAR2,
373: x_msg_count OUT NOCOPY NUMBER,

Line 641: p_person_cust_obj IN HZ_PERSON_CUST_BO,

637: END do_update_person_cust_bo;
638:
639: PROCEDURE update_person_cust_bo(
640: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
641: p_person_cust_obj IN HZ_PERSON_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_pc_obj HZ_PERSON_CUST_BO;

644: x_msg_count OUT NOCOPY NUMBER,
645: x_msg_data OUT NOCOPY VARCHAR2,
646: x_person_id OUT NOCOPY NUMBER
647: ) IS
648: l_pc_obj HZ_PERSON_CUST_BO;
649: BEGIN
650: l_pc_obj := p_person_cust_obj;
651: do_update_person_cust_bo(
652: p_init_msg_list => p_init_msg_list,

Line 664: p_person_cust_obj IN HZ_PERSON_CUST_BO,

660: );
661: END update_person_cust_bo;
662:
663: PROCEDURE update_person_cust_bo(
664: p_person_cust_obj IN HZ_PERSON_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_PERSON_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_PERSON_CUST_BO,
671: x_person_id OUT NOCOPY NUMBER
672: ) IS
673: l_msg_data VARCHAR2(2000);
674: l_msg_count NUMBER;

Line 675: l_pc_obj HZ_PERSON_CUST_BO;

671: x_person_id OUT NOCOPY NUMBER
672: ) IS
673: l_msg_data VARCHAR2(2000);
674: l_msg_count NUMBER;
675: l_pc_obj HZ_PERSON_CUST_BO;
676: BEGIN
677: l_pc_obj := p_person_cust_obj;
678: do_update_person_cust_bo(
679: p_init_msg_list => fnd_api.g_true,

Line 704: p_person_cust_obj IN OUT NOCOPY HZ_PERSON_CUST_BO,

700: -- Create or update person customer account.
701: PROCEDURE do_save_person_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_person_cust_obj IN OUT NOCOPY HZ_PERSON_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 863: p_person_cust_obj IN HZ_PERSON_CUST_BO,

859:
860: PROCEDURE save_person_cust_bo(
861: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
862: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
863: p_person_cust_obj IN HZ_PERSON_CUST_BO,
864: p_created_by_module IN VARCHAR2,
865: x_return_status OUT NOCOPY VARCHAR2,
866: x_msg_count OUT NOCOPY NUMBER,
867: x_msg_data OUT NOCOPY VARCHAR2,

Line 870: l_pc_obj HZ_PERSON_CUST_BO;

866: x_msg_count OUT NOCOPY NUMBER,
867: x_msg_data OUT NOCOPY VARCHAR2,
868: x_person_id OUT NOCOPY NUMBER
869: ) IS
870: l_pc_obj HZ_PERSON_CUST_BO;
871: BEGIN
872: l_pc_obj := p_person_cust_obj;
873: do_save_person_cust_bo(
874: p_init_msg_list => p_init_msg_list,

Line 888: p_person_cust_obj IN HZ_PERSON_CUST_BO,

884: END save_person_cust_bo;
885:
886: PROCEDURE save_person_cust_bo(
887: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
888: p_person_cust_obj IN HZ_PERSON_CUST_BO,
889: p_created_by_module IN VARCHAR2,
890: p_obj_source IN VARCHAR2 := null,
891: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
892: x_return_status OUT NOCOPY VARCHAR2,

Line 894: x_return_obj OUT NOCOPY HZ_PERSON_CUST_BO,

890: p_obj_source IN VARCHAR2 := null,
891: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
892: x_return_status OUT NOCOPY VARCHAR2,
893: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
894: x_return_obj OUT NOCOPY HZ_PERSON_CUST_BO,
895: x_person_id OUT NOCOPY NUMBER
896: ) IS
897: l_msg_data VARCHAR2(2000);
898: l_msg_count NUMBER;

Line 899: l_pc_obj HZ_PERSON_CUST_BO;

895: x_person_id OUT NOCOPY NUMBER
896: ) IS
897: l_msg_data VARCHAR2(2000);
898: l_msg_count NUMBER;
899: l_pc_obj HZ_PERSON_CUST_BO;
900: BEGIN
901: l_pc_obj := p_person_cust_obj;
902: do_save_person_cust_bo(
903: p_init_msg_list => fnd_api.g_true,

Line 980: x_person_cust_obj OUT NOCOPY HZ_PERSON_CUST_BO,

976: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
977: p_person_id IN NUMBER,
978: p_person_os IN VARCHAR2,
979: p_person_osr IN VARCHAR2,
980: x_person_cust_obj OUT NOCOPY HZ_PERSON_CUST_BO,
981: x_return_status OUT NOCOPY VARCHAR2,
982: x_msg_count OUT NOCOPY NUMBER,
983: x_msg_data OUT NOCOPY VARCHAR2
984: ) is

Line 1003: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo(+)',

999:
1000:
1001: -- Debug info.
1002: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1003: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo(+)',
1004: p_prefix=>l_debug_prefix,
1005: p_msg_level=>fnd_log.level_procedure);
1006: END IF;
1007:

Line 1052: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',

1048: END IF;
1049:
1050: -- Debug info.
1051: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1052: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',
1053: p_prefix=>l_debug_prefix,
1054: p_msg_level=>fnd_log.level_procedure);
1055: END IF;
1056:

Line 1075: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',

1071: p_msg_type=>'ERROR',
1072: p_msg_level=>fnd_log.level_error);
1073: END IF;
1074: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1075: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',
1076: p_prefix=>l_debug_prefix,
1077: p_msg_level=>fnd_log.level_procedure);
1078: END IF;
1079: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1094: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',

1090: p_msg_type=>'UNEXPECTED ERROR',
1091: p_msg_level=>fnd_log.level_error);
1092: END IF;
1093: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1094: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',
1095: p_prefix=>l_debug_prefix,
1096: p_msg_level=>fnd_log.level_procedure);
1097: END IF;
1098: WHEN OTHERS THEN

Line 1117: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',

1113: p_msg_type=>'SQL ERROR',
1114: p_msg_level=>fnd_log.level_error);
1115: END IF;
1116: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1117: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',
1118: p_prefix=>l_debug_prefix,
1119: p_msg_level=>fnd_log.level_procedure);
1120: END IF;
1121:

Line 1128: x_person_cust_obj OUT NOCOPY HZ_PERSON_CUST_BO,

1124: PROCEDURE get_person_cust_bo(
1125: p_person_id IN NUMBER,
1126: p_person_os IN VARCHAR2,
1127: p_person_osr IN VARCHAR2,
1128: x_person_cust_obj OUT NOCOPY HZ_PERSON_CUST_BO,
1129: x_return_status OUT NOCOPY VARCHAR2,
1130: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1131: ) IS
1132: l_msg_data VARCHAR2(2000);

Line 1193: HZ_PERSON_CUST_BO_PVT.get_person_cust_bo

1189: business event signifies that one or more Person Customer business objects have been created.
1190: The caller provides an identifier for the Person Customers Created business event and the procedure
1191: returns all of the Person Customer business objects from the business event. For each business object
1192: creation captured in the business event, the procedure calls the generic Get operation:
1193: HZ_PERSON_CUST_BO_PVT.get_person_cust_bo
1194:
1195: Gathering all of the returned business objects from those API calls, the procedure packages
1196: them in a table structure and returns them to the caller.
1197: */

Line 1203: x_person_cust_objs OUT NOCOPY HZ_PERSON_CUST_BO_TBL,

1199:
1200: PROCEDURE get_person_custs_created(
1201: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1202: p_event_id IN NUMBER,
1203: x_person_cust_objs OUT NOCOPY HZ_PERSON_CUST_BO_TBL,
1204: x_return_status OUT NOCOPY VARCHAR2,
1205: x_msg_count OUT NOCOPY NUMBER,
1206: x_msg_data OUT NOCOPY VARCHAR2
1207: ) is

Line 1222: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(+)',

1218:
1219:
1220: -- Debug info.
1221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1222: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(+)',
1223: p_prefix=>l_debug_prefix,
1224: p_msg_level=>fnd_log.level_procedure);
1225: END IF;
1226:

Line 1261: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created (-)',

1257: END IF;
1258:
1259: -- Debug info.
1260: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1261: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created (-)',
1262: p_prefix=>l_debug_prefix,
1263: p_msg_level=>fnd_log.level_procedure);
1264: END IF;
1265:

Line 1284: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(-)',

1280: p_msg_type=>'ERROR',
1281: p_msg_level=>fnd_log.level_error);
1282: END IF;
1283: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1284: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(-)',
1285: p_prefix=>l_debug_prefix,
1286: p_msg_level=>fnd_log.level_procedure);
1287: END IF;
1288: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1303: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(-)',

1299: p_msg_type=>'UNEXPECTED ERROR',
1300: p_msg_level=>fnd_log.level_error);
1301: END IF;
1302: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1303: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(-)',
1304: p_prefix=>l_debug_prefix,
1305: p_msg_level=>fnd_log.level_procedure);
1306: END IF;
1307: WHEN OTHERS THEN

Line 1326: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(-)',

1322: p_msg_type=>'SQL ERROR',
1323: p_msg_level=>fnd_log.level_error);
1324: END IF;
1325: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1326: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(-)',
1327: p_prefix=>l_debug_prefix,
1328: p_msg_level=>fnd_log.level_procedure);
1329: END IF;
1330:

Line 1335: x_person_cust_objs OUT NOCOPY HZ_PERSON_CUST_BO_TBL,

1331: end;
1332:
1333: PROCEDURE get_person_custs_created(
1334: p_event_id IN NUMBER,
1335: x_person_cust_objs OUT NOCOPY HZ_PERSON_CUST_BO_TBL,
1336: x_return_status OUT NOCOPY VARCHAR2,
1337: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1338: ) IS
1339: l_msg_data VARCHAR2(2000);

Line 1365: --the procedure returns database objects of the type HZ_PERSON_CUST_BO for all of

1361: -- PROCEDURE get_person_custs_updated
1362: --
1363: -- DESCRIPTION
1364: --The caller provides an identifier for the Person Customers update business event and
1365: --the procedure returns database objects of the type HZ_PERSON_CUST_BO for all of
1366: --the Person Customer business objects from the business event.
1367:
1368: --
1369: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 1399: the type HZ_PERSON_CUST_BO for all of the Person Customer business objects from the business event.

1395: The Get Person Customers Updated procedure is a service to retrieve all of the Person Customer business objects whose updates
1396: have been captured by the logical business event. Each Person Customers Updated business event signifies that one or more Person
1397: Customer business objects have been updated.
1398: The caller provides an identifier for the Person Customers Update business event and the procedure returns database objects of
1399: the type HZ_PERSON_CUST_BO for all of the Person Customer business objects from the business event.
1400: Gathering all of the returned database objects from those API calls, the procedure packages them in a table structure and returns
1401: them to the caller.
1402: */
1403:

Line 1407: x_person_cust_objs OUT NOCOPY HZ_PERSON_CUST_BO_TBL,

1403:
1404: PROCEDURE get_person_custs_updated(
1405: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1406: p_event_id IN NUMBER,
1407: x_person_cust_objs OUT NOCOPY HZ_PERSON_CUST_BO_TBL,
1408: x_return_status OUT NOCOPY VARCHAR2,
1409: x_msg_count OUT NOCOPY NUMBER,
1410: x_msg_data OUT NOCOPY VARCHAR2
1411: ) is

Line 1427: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(+)',

1423:
1424:
1425: -- Debug info.
1426: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1427: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(+)',
1428: p_prefix=>l_debug_prefix,
1429: p_msg_level=>fnd_log.level_procedure);
1430: END IF;
1431:

Line 1466: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated (-)',

1462: END IF;
1463:
1464: -- Debug info.
1465: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1466: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated (-)',
1467: p_prefix=>l_debug_prefix,
1468: p_msg_level=>fnd_log.level_procedure);
1469: END IF;
1470:

Line 1489: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',

1485: p_msg_type=>'ERROR',
1486: p_msg_level=>fnd_log.level_error);
1487: END IF;
1488: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1489: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
1490: p_prefix=>l_debug_prefix,
1491: p_msg_level=>fnd_log.level_procedure);
1492: END IF;
1493: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1508: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',

1504: p_msg_type=>'UNEXPECTED ERROR',
1505: p_msg_level=>fnd_log.level_error);
1506: END IF;
1507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1508: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
1509: p_prefix=>l_debug_prefix,
1510: p_msg_level=>fnd_log.level_procedure);
1511: END IF;
1512: WHEN OTHERS THEN

Line 1531: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',

1527: p_msg_type=>'SQL ERROR',
1528: p_msg_level=>fnd_log.level_error);
1529: END IF;
1530: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1531: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
1532: p_prefix=>l_debug_prefix,
1533: p_msg_level=>fnd_log.level_procedure);
1534: END IF;
1535:

Line 1540: x_person_cust_objs OUT NOCOPY HZ_PERSON_CUST_BO_TBL,

1536: end;
1537:
1538: PROCEDURE get_person_custs_updated(
1539: p_event_id IN NUMBER,
1540: x_person_cust_objs OUT NOCOPY HZ_PERSON_CUST_BO_TBL,
1541: x_return_status OUT NOCOPY VARCHAR2,
1542: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1543: )IS
1544: l_msg_data VARCHAR2(2000);

Line 1567: --the procedure returns one database object of the type HZ_PERSON_CUST_BO

1563: -- PROCEDURE get_person_cust_updated
1564: --
1565: -- DESCRIPTION
1566: --The caller provides an identifier for the Person customer update business event and person id
1567: --the procedure returns one database object of the type HZ_PERSON_CUST_BO
1568: --
1569: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1570: --
1571: -- ARGUMENTS

Line 1597: x_person_cust_obj OUT NOCOPY HZ_PERSON_CUST_BO,

1593: PROCEDURE get_person_cust_updated(
1594: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1595: p_event_id IN NUMBER,
1596: p_person_cust_id IN NUMBER,
1597: x_person_cust_obj OUT NOCOPY HZ_PERSON_CUST_BO,
1598: x_return_status OUT NOCOPY VARCHAR2,
1599: x_msg_count OUT NOCOPY NUMBER,
1600: x_msg_data OUT NOCOPY VARCHAR2
1601: ) is

Line 1616: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(+)',

1612:
1613:
1614: -- Debug info.
1615: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1616: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(+)',
1617: p_prefix=>l_debug_prefix,
1618: p_msg_level=>fnd_log.level_procedure);
1619: END IF;
1620:

Line 1656: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated (-)',

1652: END IF;
1653:
1654: -- Debug info.
1655: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1656: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated (-)',
1657: p_prefix=>l_debug_prefix,
1658: p_msg_level=>fnd_log.level_procedure);
1659: END IF;
1660:

Line 1679: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',

1675: p_msg_type=>'ERROR',
1676: p_msg_level=>fnd_log.level_error);
1677: END IF;
1678: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1679: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
1680: p_prefix=>l_debug_prefix,
1681: p_msg_level=>fnd_log.level_procedure);
1682: END IF;
1683: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1698: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',

1694: p_msg_type=>'UNEXPECTED 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_person_cust_bo_pub.get_person_cust_updated(-)',
1699: p_prefix=>l_debug_prefix,
1700: p_msg_level=>fnd_log.level_procedure);
1701: END IF;
1702: WHEN OTHERS THEN

Line 1721: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',

1717: p_msg_type=>'SQL ERROR',
1718: p_msg_level=>fnd_log.level_error);
1719: END IF;
1720: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1721: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
1722: p_prefix=>l_debug_prefix,
1723: p_msg_level=>fnd_log.level_procedure);
1724: END IF;
1725:

Line 1731: x_person_cust_obj OUT NOCOPY HZ_PERSON_CUST_BO,

1727:
1728: PROCEDURE get_person_cust_updated(
1729: p_event_id IN NUMBER,
1730: p_person_cust_id IN NUMBER,
1731: x_person_cust_obj OUT NOCOPY HZ_PERSON_CUST_BO,
1732: x_return_status OUT NOCOPY VARCHAR2,
1733: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1734: ) IS
1735: l_msg_data VARCHAR2(2000);

Line 2911: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo(+)',

2907:
2908:
2909: -- Debug info.
2910: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2911: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo(+)',
2912: p_prefix=>l_debug_prefix,
2913: p_msg_level=>fnd_log.level_procedure);
2914: END IF;
2915:

Line 2960: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',

2956: END IF;
2957:
2958: -- Debug info.
2959: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2960: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',
2961: p_prefix=>l_debug_prefix,
2962: p_msg_level=>fnd_log.level_procedure);
2963: END IF;
2964:

Line 2983: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',

2979: p_msg_type=>'ERROR',
2980: p_msg_level=>fnd_log.level_error);
2981: END IF;
2982: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2983: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',
2984: p_prefix=>l_debug_prefix,
2985: p_msg_level=>fnd_log.level_procedure);
2986: END IF;
2987: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3002: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',

2998: p_msg_type=>'UNEXPECTED ERROR',
2999: p_msg_level=>fnd_log.level_error);
3000: END IF;
3001: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3002: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',
3003: p_prefix=>l_debug_prefix,
3004: p_msg_level=>fnd_log.level_procedure);
3005: END IF;
3006: WHEN OTHERS THEN

Line 3025: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',

3021: p_msg_type=>'SQL ERROR',
3022: p_msg_level=>fnd_log.level_error);
3023: END IF;
3024: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3025: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',
3026: p_prefix=>l_debug_prefix,
3027: p_msg_level=>fnd_log.level_procedure);
3028: END IF;
3029:

Line 3101: HZ_PERSON_CUST_BO_PVT.get_person_cust_v2_bo

3097: business event signifies that one or more Person Customer business objects have been created.
3098: The caller provides an identifier for the Person Customers Created business event and the procedure
3099: returns all of the Person Customer business objects from the business event. For each business object
3100: creation captured in the business event, the procedure calls the generic Get operation:
3101: HZ_PERSON_CUST_BO_PVT.get_person_cust_v2_bo
3102:
3103: Gathering all of the returned business objects from those API calls, the procedure packages
3104: them in a table structure and returns them to the caller.
3105: */

Line 3130: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(+)',

3126:
3127:
3128: -- Debug info.
3129: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3130: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(+)',
3131: p_prefix=>l_debug_prefix,
3132: p_msg_level=>fnd_log.level_procedure);
3133: END IF;
3134:

Line 3169: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created (-)',

3165: END IF;
3166:
3167: -- Debug info.
3168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3169: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created (-)',
3170: p_prefix=>l_debug_prefix,
3171: p_msg_level=>fnd_log.level_procedure);
3172: END IF;
3173:

Line 3192: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(-)',

3188: p_msg_type=>'ERROR',
3189: p_msg_level=>fnd_log.level_error);
3190: END IF;
3191: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3192: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(-)',
3193: p_prefix=>l_debug_prefix,
3194: p_msg_level=>fnd_log.level_procedure);
3195: END IF;
3196: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3211: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(-)',

3207: p_msg_type=>'UNEXPECTED ERROR',
3208: p_msg_level=>fnd_log.level_error);
3209: END IF;
3210: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3211: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(-)',
3212: p_prefix=>l_debug_prefix,
3213: p_msg_level=>fnd_log.level_procedure);
3214: END IF;
3215: WHEN OTHERS THEN

Line 3234: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(-)',

3230: p_msg_type=>'SQL ERROR',
3231: p_msg_level=>fnd_log.level_error);
3232: END IF;
3233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3234: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(-)',
3235: p_prefix=>l_debug_prefix,
3236: p_msg_level=>fnd_log.level_procedure);
3237: END IF;
3238:

Line 3333: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(+)',

3329:
3330:
3331: -- Debug info.
3332: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3333: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(+)',
3334: p_prefix=>l_debug_prefix,
3335: p_msg_level=>fnd_log.level_procedure);
3336: END IF;
3337:

Line 3372: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated (-)',

3368: END IF;
3369:
3370: -- Debug info.
3371: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3372: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated (-)',
3373: p_prefix=>l_debug_prefix,
3374: p_msg_level=>fnd_log.level_procedure);
3375: END IF;
3376:

Line 3395: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',

3391: p_msg_type=>'ERROR',
3392: p_msg_level=>fnd_log.level_error);
3393: END IF;
3394: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3395: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
3396: p_prefix=>l_debug_prefix,
3397: p_msg_level=>fnd_log.level_procedure);
3398: END IF;
3399: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3414: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',

3410: p_msg_type=>'UNEXPECTED ERROR',
3411: p_msg_level=>fnd_log.level_error);
3412: END IF;
3413: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3414: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
3415: p_prefix=>l_debug_prefix,
3416: p_msg_level=>fnd_log.level_procedure);
3417: END IF;
3418: WHEN OTHERS THEN

Line 3437: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',

3433: p_msg_type=>'SQL ERROR',
3434: p_msg_level=>fnd_log.level_error);
3435: END IF;
3436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3437: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
3438: p_prefix=>l_debug_prefix,
3439: p_msg_level=>fnd_log.level_procedure);
3440: END IF;
3441:

Line 3522: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(+)',

3518:
3519:
3520: -- Debug info.
3521: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3522: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(+)',
3523: p_prefix=>l_debug_prefix,
3524: p_msg_level=>fnd_log.level_procedure);
3525: END IF;
3526:

Line 3562: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated (-)',

3558: END IF;
3559:
3560: -- Debug info.
3561: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3562: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated (-)',
3563: p_prefix=>l_debug_prefix,
3564: p_msg_level=>fnd_log.level_procedure);
3565: END IF;
3566:

Line 3585: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',

3581: p_msg_type=>'ERROR',
3582: p_msg_level=>fnd_log.level_error);
3583: END IF;
3584: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3585: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
3586: p_prefix=>l_debug_prefix,
3587: p_msg_level=>fnd_log.level_procedure);
3588: END IF;
3589: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3604: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',

3600: p_msg_type=>'UNEXPECTED ERROR',
3601: p_msg_level=>fnd_log.level_error);
3602: END IF;
3603: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3604: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
3605: p_prefix=>l_debug_prefix,
3606: p_msg_level=>fnd_log.level_procedure);
3607: END IF;
3608: WHEN OTHERS THEN

Line 3627: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',

3623: p_msg_type=>'SQL ERROR',
3624: p_msg_level=>fnd_log.level_error);
3625: END IF;
3626: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3627: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
3628: p_prefix=>l_debug_prefix,
3629: p_msg_level=>fnd_log.level_procedure);
3630: END IF;
3631:

Line 3659: END hz_person_cust_bo_pub;

3655: x_msg_count => l_msg_count,
3656: x_msg_data => l_msg_data);
3657: END get_v2_person_cust_updated;
3658:
3659: END hz_person_cust_bo_pub;