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_BO_PUB dependencies on HZ_PERSON_BO

Line 1: PACKAGE BODY hz_person_bo_pub AS

1: PACKAGE BODY hz_person_bo_pub AS
2: /*$Header: ARHBPPBB.pls 120.25 2006/07/22 00:20:35 acng noship $ */
3:
4: -- PRIVATE PROCEDURE assign_person_rec
5: --

Line 29: p_person_obj IN HZ_PERSON_BO,

25: -- 14-DEC-2004 Arnold Ng Created.
26: --
27:
28: PROCEDURE assign_person_rec(
29: p_person_obj IN HZ_PERSON_BO,
30: p_person_id IN NUMBER,
31: p_person_os IN VARCHAR2,
32: p_person_osr IN VARCHAR2,
33: p_create_or_update IN VARCHAR2 := 'C',

Line 309: p_person_obj IN HZ_PERSON_BO,

305: --
306: -- 14-DEC-2004 Arnold Ng Created.
307:
308: PROCEDURE assign_person_rec(
309: p_person_obj IN HZ_PERSON_BO,
310: p_person_id IN NUMBER,
311: p_person_os IN VARCHAR2,
312: p_person_osr IN VARCHAR2,
313: p_create_or_update IN VARCHAR2 := 'C',

Line 674: p_person_obj IN OUT NOCOPY HZ_PERSON_BO,

670: -- Create a person business object.
671: PROCEDURE do_create_person_bo(
672: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
673: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
674: p_person_obj IN OUT NOCOPY HZ_PERSON_BO,
675: p_created_by_module IN VARCHAR2,
676: p_obj_source IN VARCHAR2 := null,
677: x_return_status OUT NOCOPY VARCHAR2,
678: x_msg_count OUT NOCOPY NUMBER,

Line 1164: p_person_obj IN HZ_PERSON_BO,

1160:
1161: PROCEDURE create_person_bo(
1162: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1163: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1164: p_person_obj IN HZ_PERSON_BO,
1165: p_created_by_module IN VARCHAR2,
1166: x_return_status OUT NOCOPY VARCHAR2,
1167: x_msg_count OUT NOCOPY NUMBER,
1168: x_msg_data OUT NOCOPY VARCHAR2,

Line 1173: l_per_obj HZ_PERSON_BO;

1169: x_person_id OUT NOCOPY NUMBER,
1170: x_person_os OUT NOCOPY VARCHAR2,
1171: x_person_osr OUT NOCOPY VARCHAR2
1172: ) IS
1173: l_per_obj HZ_PERSON_BO;
1174: BEGIN
1175: l_per_obj := p_person_obj;
1176: do_create_person_bo(
1177: p_init_msg_list => p_init_msg_list,

Line 1193: p_person_obj IN HZ_PERSON_BO,

1189: END create_person_bo;
1190:
1191: PROCEDURE create_person_bo(
1192: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1193: p_person_obj IN HZ_PERSON_BO,
1194: p_created_by_module IN VARCHAR2,
1195: p_obj_source IN VARCHAR2 := NULL,
1196: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1197: x_return_status OUT NOCOPY VARCHAR2,

Line 1199: x_return_obj OUT NOCOPY HZ_PERSON_BO,

1195: p_obj_source IN VARCHAR2 := NULL,
1196: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1197: x_return_status OUT NOCOPY VARCHAR2,
1198: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1199: x_return_obj OUT NOCOPY HZ_PERSON_BO,
1200: x_person_id OUT NOCOPY NUMBER,
1201: x_person_os OUT NOCOPY VARCHAR2,
1202: x_person_osr OUT NOCOPY VARCHAR2
1203: ) IS

Line 1206: l_per_obj HZ_PERSON_BO;

1202: x_person_osr OUT NOCOPY VARCHAR2
1203: ) IS
1204: l_msg_count NUMBER;
1205: l_msg_data VARCHAR2(2000);
1206: l_per_obj HZ_PERSON_BO;
1207: BEGIN
1208: l_per_obj := p_person_obj;
1209: do_create_person_bo(
1210: p_init_msg_list => FND_API.G_TRUE,

Line 1237: p_person_obj IN OUT NOCOPY HZ_PERSON_BO,

1233: -- DESCRIPTION
1234: -- Update a person business object.
1235: PROCEDURE do_update_person_bo(
1236: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1237: p_person_obj IN OUT NOCOPY HZ_PERSON_BO,
1238: p_created_by_module IN VARCHAR2,
1239: p_obj_source IN VARCHAR2 := NULL,
1240: x_return_status OUT NOCOPY VARCHAR2,
1241: x_msg_count OUT NOCOPY NUMBER,

Line 1756: p_person_obj IN HZ_PERSON_BO,

1752: END do_update_person_bo;
1753:
1754: PROCEDURE update_person_bo(
1755: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1756: p_person_obj IN HZ_PERSON_BO,
1757: p_created_by_module IN VARCHAR2,
1758: x_return_status OUT NOCOPY VARCHAR2,
1759: x_msg_count OUT NOCOPY NUMBER,
1760: x_msg_data OUT NOCOPY VARCHAR2,

Line 1765: l_per_obj HZ_PERSON_BO;

1761: x_person_id OUT NOCOPY NUMBER,
1762: x_person_os OUT NOCOPY VARCHAR2,
1763: x_person_osr OUT NOCOPY VARCHAR2
1764: ) IS
1765: l_per_obj HZ_PERSON_BO;
1766: BEGIN
1767: l_per_obj := p_person_obj;
1768: do_update_person_bo(
1769: p_init_msg_list => p_init_msg_list,

Line 1783: p_person_obj IN HZ_PERSON_BO,

1779: );
1780: END update_person_bo;
1781:
1782: PROCEDURE update_person_bo(
1783: p_person_obj IN HZ_PERSON_BO,
1784: p_created_by_module IN VARCHAR2,
1785: p_obj_source IN VARCHAR2 := null,
1786: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1787: x_return_status OUT NOCOPY VARCHAR2,

Line 1789: x_return_obj OUT NOCOPY HZ_PERSON_BO,

1785: p_obj_source IN VARCHAR2 := null,
1786: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1787: x_return_status OUT NOCOPY VARCHAR2,
1788: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1789: x_return_obj OUT NOCOPY HZ_PERSON_BO,
1790: x_person_id OUT NOCOPY NUMBER,
1791: x_person_os OUT NOCOPY VARCHAR2,
1792: x_person_osr OUT NOCOPY VARCHAR2
1793: )IS

Line 1796: l_per_obj HZ_PERSON_BO;

1792: x_person_osr OUT NOCOPY VARCHAR2
1793: )IS
1794: l_msg_count NUMBER;
1795: l_msg_data VARCHAR2(2000);
1796: l_per_obj HZ_PERSON_BO;
1797: BEGIN
1798: l_per_obj := p_person_obj;
1799: do_update_person_bo(
1800: p_init_msg_list => FND_API.G_TRUE,

Line 1827: p_person_obj IN OUT NOCOPY HZ_PERSON_BO,

1823: -- Create or update a person business object.
1824: PROCEDURE do_save_person_bo(
1825: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1826: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1827: p_person_obj IN OUT NOCOPY HZ_PERSON_BO,
1828: p_created_by_module IN VARCHAR2,
1829: p_obj_source IN VARCHAR2 := null,
1830: x_return_status OUT NOCOPY VARCHAR2,
1831: x_msg_count OUT NOCOPY NUMBER,

Line 1996: p_person_obj IN HZ_PERSON_BO,

1992:
1993: PROCEDURE save_person_bo(
1994: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1995: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1996: p_person_obj IN HZ_PERSON_BO,
1997: p_created_by_module IN VARCHAR2,
1998: x_return_status OUT NOCOPY VARCHAR2,
1999: x_msg_count OUT NOCOPY NUMBER,
2000: x_msg_data OUT NOCOPY VARCHAR2,

Line 2005: l_per_obj HZ_PERSON_BO;

2001: x_person_id OUT NOCOPY NUMBER,
2002: x_person_os OUT NOCOPY VARCHAR2,
2003: x_person_osr OUT NOCOPY VARCHAR2
2004: ) IS
2005: l_per_obj HZ_PERSON_BO;
2006: BEGIN
2007: l_per_obj := p_person_obj;
2008: do_save_person_bo(
2009: p_init_msg_list => p_init_msg_list,

Line 2025: p_person_obj IN HZ_PERSON_BO,

2021: END save_person_bo;
2022:
2023: PROCEDURE save_person_bo(
2024: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2025: p_person_obj IN HZ_PERSON_BO,
2026: p_created_by_module IN VARCHAR2,
2027: p_obj_source IN VARCHAR2 := NULL,
2028: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2029: x_return_status OUT NOCOPY VARCHAR2,

Line 2031: x_return_obj OUT NOCOPY HZ_PERSON_BO,

2027: p_obj_source IN VARCHAR2 := NULL,
2028: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2029: x_return_status OUT NOCOPY VARCHAR2,
2030: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
2031: x_return_obj OUT NOCOPY HZ_PERSON_BO,
2032: x_person_id OUT NOCOPY NUMBER,
2033: x_person_os OUT NOCOPY VARCHAR2,
2034: x_person_osr OUT NOCOPY VARCHAR2
2035: ) IS

Line 2038: l_per_obj HZ_PERSON_BO;

2034: x_person_osr OUT NOCOPY VARCHAR2
2035: ) IS
2036: l_msg_count NUMBER;
2037: l_msg_data VARCHAR2(2000);
2038: l_per_obj HZ_PERSON_BO;
2039: BEGIN
2040: l_per_obj := p_person_obj;
2041: do_save_person_bo(
2042: p_init_msg_list => FND_API.G_TRUE,

Line 2148: hz_utility_v2pub.debug(p_message=>'Create Person Language - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,

2144: );
2145:
2146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2148: hz_utility_v2pub.debug(p_message=>'Create Person Language - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2149: p_prefix=>l_debug_prefix,
2150: p_msg_level=>fnd_log.level_procedure);
2151: END IF;
2152: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 2184: hz_utility_v2pub.debug(p_message=>'Create Education - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,

2180: );
2181:
2182: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2183: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2184: hz_utility_v2pub.debug(p_message=>'Create Education - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2185: p_prefix=>l_debug_prefix,
2186: p_msg_level=>fnd_log.level_procedure);
2187: END IF;
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 2220: hz_utility_v2pub.debug(p_message=>'Create Citizenship - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,

2216: );
2217:
2218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2219: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2220: hz_utility_v2pub.debug(p_message=>'Create Citizenship - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2221: p_prefix=>l_debug_prefix,
2222: p_msg_level=>fnd_log.level_procedure);
2223: END IF;
2224: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 2256: hz_utility_v2pub.debug(p_message=>'Create Employment History - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,

2252: );
2253:
2254: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2255: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2256: hz_utility_v2pub.debug(p_message=>'Create Employment History - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2257: p_prefix=>l_debug_prefix,
2258: p_msg_level=>fnd_log.level_procedure);
2259: END IF;
2260: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');

Line 2291: hz_utility_v2pub.debug(p_message=>'Create Work Class - Error occurred at hz_person_bo_pub.create_person_info, employ_hist_id: '||l_dummy_id,

2287: );
2288:
2289: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2290: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2291: hz_utility_v2pub.debug(p_message=>'Create Work Class - Error occurred at hz_person_bo_pub.create_person_info, employ_hist_id: '||l_dummy_id,
2292: p_prefix=>l_debug_prefix,
2293: p_msg_level=>fnd_log.level_procedure);
2294: END IF;
2295: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 2330: hz_utility_v2pub.debug(p_message=>'Create Person Interest - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,

2326: );
2327:
2328: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2329: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2330: hz_utility_v2pub.debug(p_message=>'Create Person Interest - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2331: p_prefix=>l_debug_prefix,
2332: p_msg_level=>fnd_log.level_procedure);
2333: END IF;
2334: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 2510: hz_utility_v2pub.debug(p_message=>'Save Person Language - Error occurred at hz_person_bo_pub.check_language_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,

2506: );
2507:
2508: IF(l_ovn = -1) THEN
2509: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2510: hz_utility_v2pub.debug(p_message=>'Save Person Language - Error occurred at hz_person_bo_pub.check_language_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2511: p_prefix=>l_debug_prefix,
2512: p_msg_level=>fnd_log.level_procedure);
2513: END IF;
2514: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 2549: hz_utility_v2pub.debug(p_message=>'Save Person Language - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,

2545: p_language_obj(i).language_use_reference_id := l_person_lang_rec.language_use_reference_id;
2546: END IF;
2547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2548: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2549: hz_utility_v2pub.debug(p_message=>'Save Person Language - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2550: p_prefix=>l_debug_prefix,
2551: p_msg_level=>fnd_log.level_procedure);
2552: END IF;
2553: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 2583: hz_utility_v2pub.debug(p_message=>'Save Education - Error occurred at hz_person_bo_pub.check_education_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,

2579: );
2580:
2581: IF(l_ovn = -1) THEN
2582: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2583: hz_utility_v2pub.debug(p_message=>'Save Education - Error occurred at hz_person_bo_pub.check_education_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2584: p_prefix=>l_debug_prefix,
2585: p_msg_level=>fnd_log.level_procedure);
2586: END IF;
2587: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 2622: hz_utility_v2pub.debug(p_message=>'Save Education - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,

2618: p_education_obj(i).education_id := l_education_rec.education_id;
2619: END IF;
2620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2622: hz_utility_v2pub.debug(p_message=>'Save Education - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2623: p_prefix=>l_debug_prefix,
2624: p_msg_level=>fnd_log.level_procedure);
2625: END IF;
2626: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 2654: hz_utility_v2pub.debug(p_message=>'Save Citizenship - Error occurred at hz_person_bo_pub.check_citizenship_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,

2650: );
2651:
2652: IF(l_ovn = -1) THEN
2653: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2654: hz_utility_v2pub.debug(p_message=>'Save Citizenship - Error occurred at hz_person_bo_pub.check_citizenship_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2655: p_prefix=>l_debug_prefix,
2656: p_msg_level=>fnd_log.level_procedure);
2657: END IF;
2658: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 2693: hz_utility_v2pub.debug(p_message=>'Save Citizenship - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,

2689: p_citizenship_obj(i).citizenship_id := l_citizenship_rec.citizenship_id;
2690: END IF;
2691: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2692: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2693: hz_utility_v2pub.debug(p_message=>'Save Citizenship - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2694: p_prefix=>l_debug_prefix,
2695: p_msg_level=>fnd_log.level_procedure);
2696: END IF;
2697: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 2727: hz_utility_v2pub.debug(p_message=>'Save Employment History - Error occurred at hz_person_bo_pub.check_employ_hist_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,

2723: );
2724:
2725: IF(l_ovn = -1) THEN
2726: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2727: hz_utility_v2pub.debug(p_message=>'Save Employment History - Error occurred at hz_person_bo_pub.check_employ_hist_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2728: p_prefix=>l_debug_prefix,
2729: p_msg_level=>fnd_log.level_procedure);
2730: END IF;
2731: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 2767: hz_utility_v2pub.debug(p_message=>'Save Employment History - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,

2763: p_employ_hist_obj(i).employment_history_id := l_dummy_id;
2764: END IF;
2765: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2766: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2767: hz_utility_v2pub.debug(p_message=>'Save Employment History - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2768: p_prefix=>l_debug_prefix,
2769: p_msg_level=>fnd_log.level_procedure);
2770: END IF;
2771: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');

Line 2796: hz_utility_v2pub.debug(p_message=>'Save Work Class - Error occurred at hz_person_bo_pub.check_work_class_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,

2792: );
2793:
2794: IF(l_ovn = -1) THEN
2795: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2796: hz_utility_v2pub.debug(p_message=>'Save Work Class - Error occurred at hz_person_bo_pub.check_work_class_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2797: p_prefix=>l_debug_prefix,
2798: p_msg_level=>fnd_log.level_procedure);
2799: END IF;
2800: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 2835: hz_utility_v2pub.debug(p_message=>'Save Work Class - Error occurred at hz_person_bo_pub.save_person_info, employ_hist_id: '||l_dummy_id||' '||' ovn:'||l_ovn,

2831: p_employ_hist_obj(i).work_class_objs(j).work_class_id := l_work_class_rec.work_class_id;
2832: END IF;
2833: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2834: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2835: hz_utility_v2pub.debug(p_message=>'Save Work Class - Error occurred at hz_person_bo_pub.save_person_info, employ_hist_id: '||l_dummy_id||' '||' ovn:'||l_ovn,
2836: p_prefix=>l_debug_prefix,
2837: p_msg_level=>fnd_log.level_procedure);
2838: END IF;
2839: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 2872: hz_utility_v2pub.debug(p_message=>'Save Person Interest - Error occurred at hz_person_bo_pub.check_interest_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,

2868: );
2869:
2870: IF(l_ovn = -1) THEN
2871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2872: hz_utility_v2pub.debug(p_message=>'Save Person Interest - Error occurred at hz_person_bo_pub.check_interest_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2873: p_prefix=>l_debug_prefix,
2874: p_msg_level=>fnd_log.level_procedure);
2875: END IF;
2876: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 2911: hz_utility_v2pub.debug(p_message=>'Save Person Interest - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,

2907: p_interest_obj(i).person_interest_id := l_interest_rec.person_interest_id;
2908: END IF;
2909: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2910: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2911: hz_utility_v2pub.debug(p_message=>'Save Person Interest - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2912: p_prefix=>l_debug_prefix,
2913: p_msg_level=>fnd_log.level_procedure);
2914: END IF;
2915: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 3077: x_person_obj OUT NOCOPY HZ_PERSON_BO,

3073: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3074: p_person_id IN NUMBER,
3075: p_person_os IN VARCHAR2,
3076: p_person_osr IN VARCHAR2,
3077: x_person_obj OUT NOCOPY HZ_PERSON_BO,
3078: x_return_status OUT NOCOPY VARCHAR2,
3079: x_msg_count OUT NOCOPY NUMBER,
3080: x_msg_data OUT NOCOPY VARCHAR2
3081: ) is

Line 3100: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo(+)',

3096:
3097:
3098: -- Debug info.
3099: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3100: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo(+)',
3101: p_prefix=>l_debug_prefix,
3102: p_msg_level=>fnd_log.level_procedure);
3103: END IF;
3104:

Line 3149: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',

3145: END IF;
3146:
3147: -- Debug info.
3148: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3149: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3150: p_prefix=>l_debug_prefix,
3151: p_msg_level=>fnd_log.level_procedure);
3152: END IF;
3153:

Line 3172: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',

3168: p_msg_type=>'ERROR',
3169: p_msg_level=>fnd_log.level_error);
3170: END IF;
3171: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3172: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3173: p_prefix=>l_debug_prefix,
3174: p_msg_level=>fnd_log.level_procedure);
3175: END IF;
3176: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3191: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',

3187: p_msg_type=>'UNEXPECTED ERROR',
3188: p_msg_level=>fnd_log.level_error);
3189: END IF;
3190: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3191: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3192: p_prefix=>l_debug_prefix,
3193: p_msg_level=>fnd_log.level_procedure);
3194: END IF;
3195: WHEN OTHERS THEN

Line 3214: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',

3210: p_msg_type=>'SQL ERROR',
3211: p_msg_level=>fnd_log.level_error);
3212: END IF;
3213: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3214: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3215: p_prefix=>l_debug_prefix,
3216: p_msg_level=>fnd_log.level_procedure);
3217: END IF;
3218:

Line 3225: x_person_obj OUT NOCOPY HZ_PERSON_BO,

3221: PROCEDURE get_person_bo (
3222: p_person_id IN NUMBER,
3223: p_person_os IN VARCHAR2,
3224: p_person_osr IN VARCHAR2,
3225: x_person_obj OUT NOCOPY HZ_PERSON_BO,
3226: x_return_status OUT NOCOPY VARCHAR2,
3227: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
3228: ) is
3229: l_msg_count NUMBER;

Line 3254: --the procedure returns database objects of the type HZ_PERSON_BO for all of

3250: -- PROCEDURE get_persons_created
3251: --
3252: -- DESCRIPTION
3253: --The caller provides an identifier for the Persons created business event and
3254: --the procedure returns database objects of the type HZ_PERSON_BO for all of
3255: --the Person business objects from the business event.
3256:
3257: --
3258: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 3290: HZ_PERSON_BO_PVT.get_person_bo

3286: business event signifies that one or more Person business objects have been created.
3287: The caller provides an identifier for the Persons Created business event and the procedure
3288: returns all of the Person business objects from the business event. For each business object
3289: creation captured in the business event, the procedure calls the generic Get operation:
3290: HZ_PERSON_BO_PVT.get_person_bo
3291:
3292: Gathering all of the returned business objects from those API calls, the procedure packages
3293: them in a table structure and returns them to the caller.
3294: */

Line 3300: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,

3296:
3297: PROCEDURE get_persons_created(
3298: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3299: p_event_id IN NUMBER,
3300: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,
3301: x_return_status OUT NOCOPY VARCHAR2,
3302: x_msg_count OUT NOCOPY NUMBER,
3303: x_msg_data OUT NOCOPY VARCHAR2
3304: ) is

Line 3319: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(+)',

3315:
3316:
3317: -- Debug info.
3318: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3319: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(+)',
3320: p_prefix=>l_debug_prefix,
3321: p_msg_level=>fnd_log.level_procedure);
3322: END IF;
3323:

Line 3359: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created (-)',

3355: END IF;
3356:
3357: -- Debug info.
3358: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3359: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created (-)',
3360: p_prefix=>l_debug_prefix,
3361: p_msg_level=>fnd_log.level_procedure);
3362: END IF;
3363:

Line 3382: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',

3378: p_msg_type=>'ERROR',
3379: p_msg_level=>fnd_log.level_error);
3380: END IF;
3381: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3382: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3383: p_prefix=>l_debug_prefix,
3384: p_msg_level=>fnd_log.level_procedure);
3385: END IF;
3386: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3401: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',

3397: p_msg_type=>'UNEXPECTED ERROR',
3398: p_msg_level=>fnd_log.level_error);
3399: END IF;
3400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3401: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3402: p_prefix=>l_debug_prefix,
3403: p_msg_level=>fnd_log.level_procedure);
3404: END IF;
3405: WHEN OTHERS THEN

Line 3424: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',

3420: p_msg_type=>'SQL ERROR',
3421: p_msg_level=>fnd_log.level_error);
3422: END IF;
3423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3424: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3425: p_prefix=>l_debug_prefix,
3426: p_msg_level=>fnd_log.level_procedure);
3427: END IF;
3428:

Line 3433: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,

3429: end;
3430:
3431: PROCEDURE get_persons_created(
3432: p_event_id IN NUMBER,
3433: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,
3434: x_return_status OUT NOCOPY VARCHAR2,
3435: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
3436: ) IS
3437: l_msg_count NUMBER;

Line 3460: --the procedure returns database objects of the type HZ_PERSON_BO for all of

3456: -- PROCEDURE get_persons_updated
3457: --
3458: -- DESCRIPTION
3459: --The caller provides an identifier for the Persons update business event and
3460: --the procedure returns database objects of the type HZ_PERSON_BO for all of
3461: --the Person business objects from the business event.
3462:
3463: --
3464: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 3494: type HZ_PERSON_BO for all of the Person business objects from the business event.

3490: The Get Persons Updated procedure is a service to retrieve all of the Person business objects whose updates have been
3491: captured by the logical business event. Each Persons Updated business event signifies that one or more Person business
3492: objects have been updated.
3493: The caller provides an identifier for the Persons Update business event and the procedure returns database objects of the
3494: type HZ_PERSON_BO for all of the Person business objects from the business event.
3495: Gathering all of the returned database objects from those API calls, the procedure packages them in a table structure and
3496: returns them to the caller.
3497: */
3498:

Line 3502: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,

3498:
3499: PROCEDURE get_persons_updated(
3500: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3501: p_event_id IN NUMBER,
3502: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,
3503: x_return_status OUT NOCOPY VARCHAR2,
3504: x_msg_count OUT NOCOPY NUMBER,
3505: x_msg_data OUT NOCOPY VARCHAR2
3506: ) is

Line 3522: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_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_bo_pub.get_persons_updated(+)',
3523: p_prefix=>l_debug_prefix,
3524: p_msg_level=>fnd_log.level_procedure);
3525: END IF;
3526:

Line 3561: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated (-)',

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

Line 3584: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',

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

Line 3603: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',

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

Line 3626: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',

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

Line 3635: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,

3631: end;
3632:
3633: PROCEDURE get_persons_updated(
3634: p_event_id IN NUMBER,
3635: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,
3636: x_return_status OUT NOCOPY VARCHAR2,
3637: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
3638: ) IS
3639: l_msg_count NUMBER;

Line 3662: --the procedure returns one database object of the type HZ_PERSON_BO

3658: -- PROCEDURE get_person_updated
3659: --
3660: -- DESCRIPTION
3661: --The caller provides an identifier for the Persons update business event and person_id
3662: --the procedure returns one database object of the type HZ_PERSON_BO
3663:
3664: --
3665: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3666: --

Line 3697: x_person_obj OUT NOCOPY HZ_PERSON_BO,

3693: PROCEDURE get_person_updated(
3694: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3695: p_event_id IN NUMBER,
3696: p_person_id IN NUMBER,
3697: x_person_obj OUT NOCOPY HZ_PERSON_BO,
3698: x_return_status OUT NOCOPY VARCHAR2,
3699: x_msg_count OUT NOCOPY NUMBER,
3700: x_msg_data OUT NOCOPY VARCHAR2
3701: ) is

Line 3716: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(+)',

3712:
3713:
3714: -- Debug info.
3715: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3716: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(+)',
3717: p_prefix=>l_debug_prefix,
3718: p_msg_level=>fnd_log.level_procedure);
3719: END IF;
3720:

Line 3757: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated (-)',

3753: END IF;
3754:
3755: -- Debug info.
3756: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3757: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated (-)',
3758: p_prefix=>l_debug_prefix,
3759: p_msg_level=>fnd_log.level_procedure);
3760: END IF;
3761:

Line 3780: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',

3776: p_msg_type=>'ERROR',
3777: p_msg_level=>fnd_log.level_error);
3778: END IF;
3779: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3780: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
3781: p_prefix=>l_debug_prefix,
3782: p_msg_level=>fnd_log.level_procedure);
3783: END IF;
3784: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3799: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',

3795: p_msg_type=>'UNEXPECTED ERROR',
3796: p_msg_level=>fnd_log.level_error);
3797: END IF;
3798: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3799: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
3800: p_prefix=>l_debug_prefix,
3801: p_msg_level=>fnd_log.level_procedure);
3802: END IF;
3803: WHEN OTHERS THEN

Line 3822: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',

3818: p_msg_type=>'SQL ERROR',
3819: p_msg_level=>fnd_log.level_error);
3820: END IF;
3821: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3822: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
3823: p_prefix=>l_debug_prefix,
3824: p_msg_level=>fnd_log.level_procedure);
3825: END IF;
3826:

Line 3832: x_person_obj OUT NOCOPY HZ_PERSON_BO,

3828:
3829: PROCEDURE get_person_updated(
3830: p_event_id IN NUMBER,
3831: p_person_id IN NUMBER,
3832: x_person_obj OUT NOCOPY HZ_PERSON_BO,
3833: x_return_status OUT NOCOPY VARCHAR2,
3834: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
3835: ) IS
3836: l_msg_count NUMBER;

Line 4123: END hz_person_bo_pub;

4119: END IF;
4120:
4121: end;
4122:
4123: END hz_person_bo_pub;