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_ORGANIZATION_BO_PUB dependencies on HZ_ORGANIZATION_BO

Line 1: PACKAGE BODY hz_organization_bo_pub AS

1: PACKAGE BODY hz_organization_bo_pub AS
2: /*$Header: ARHBPOBB.pls 120.21 2007/12/26 06:34:30 kguggila ship $ */
3:
4: -- PRIVATE PROCEDURE assign_organization_rec
5: --

Line 28: p_organization_obj IN HZ_ORGANIZATION_BO,

24: --
25: -- 02-MAR-2005 Arnold Ng Created.
26:
27: PROCEDURE assign_organization_rec(
28: p_organization_obj IN HZ_ORGANIZATION_BO,
29: p_organization_id IN NUMBER,
30: p_organization_os IN VARCHAR2,
31: p_organization_osr IN VARCHAR2,
32: p_create_or_update IN VARCHAR2 := 'C',

Line 186: p_organization_obj IN HZ_ORGANIZATION_BO,

182: --
183: -- 02-MAR-2005 Arnold Ng Created.
184:
185: PROCEDURE assign_organization_rec(
186: p_organization_obj IN HZ_ORGANIZATION_BO,
187: p_organization_id IN NUMBER,
188: p_organization_os IN VARCHAR2,
189: p_organization_osr IN VARCHAR2,
190: p_create_or_update IN VARCHAR2 := 'C',

Line 699: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,

695: );
696:
697: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
698: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
699: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,
700: p_prefix=>l_debug_prefix,
701: p_msg_level=>fnd_log.level_procedure);
702: END IF;
703: RAISE FND_API.G_EXC_ERROR;

Line 870: hz_utility_v2pub.debug(p_message=>'Save Credit Ratings - Error occurred at hz_organization_bo_pub.check_credit_rating_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,

866: );
867:
868: IF(l_ovn = -1) THEN
869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
870: hz_utility_v2pub.debug(p_message=>'Save Credit Ratings - Error occurred at hz_organization_bo_pub.check_credit_rating_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,
871: p_prefix=>l_debug_prefix,
872: p_msg_level=>fnd_log.level_procedure);
873: END IF;
874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 907: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,

903: END IF;
904:
905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
906: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
907: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,
908: p_prefix=>l_debug_prefix,
909: p_msg_level=>fnd_log.level_procedure);
910: END IF;
911: RAISE FND_API.G_EXC_ERROR;

Line 1056: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_financial_reports, org id: '||p_organization_id,

1052: );
1053:
1054: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1055: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1056: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_financial_reports, org id: '||p_organization_id,
1057: p_prefix=>l_debug_prefix,
1058: p_msg_level=>fnd_log.level_procedure);
1059: END IF;
1060: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');

Line 1091: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_financial_reports, fin_number_id: '||l_dummy_id,

1087: );
1088:
1089: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1090: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1091: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_financial_reports, fin_number_id: '||l_dummy_id,
1092: p_prefix=>l_debug_prefix,
1093: p_msg_level=>fnd_log.level_procedure);
1094: END IF;
1095: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 1240: hz_utility_v2pub.debug(p_message=>'Save Financial Report - Error occurred at hz_organization_bo_pub.check_fin_report_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,

1236: );
1237:
1238: IF(l_ovn = -1) THEN
1239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1240: hz_utility_v2pub.debug(p_message=>'Save Financial Report - Error occurred at hz_organization_bo_pub.check_fin_report_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,
1241: p_prefix=>l_debug_prefix,
1242: p_msg_level=>fnd_log.level_procedure);
1243: END IF;
1244: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 1281: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.save_financial_reports, org id: '||p_organization_id,

1277: END IF;
1278:
1279: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1281: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.save_financial_reports, org id: '||p_organization_id,
1282: p_prefix=>l_debug_prefix,
1283: p_msg_level=>fnd_log.level_procedure);
1284: END IF;
1285: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');

Line 1311: hz_utility_v2pub.debug(p_message=>'Save Financial Number - Error occurred at hz_organization_bo_pub.check_fin_number_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,

1307: );
1308:
1309: IF(l_ovn = -1) THEN
1310: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1311: hz_utility_v2pub.debug(p_message=>'Save Financial Number - Error occurred at hz_organization_bo_pub.check_fin_number_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,
1312: p_prefix=>l_debug_prefix,
1313: p_msg_level=>fnd_log.level_procedure);
1314: END IF;
1315: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 1350: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.save_financial_reports, fin_number_id: '||l_dummy_id,

1346: p_fin_objs(i).financial_number_objs(j).financial_number_id := l_fin_number_rec.financial_number_id;
1347: END IF;
1348: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1349: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1350: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.save_financial_reports, fin_number_id: '||l_dummy_id,
1351: p_prefix=>l_debug_prefix,
1352: p_msg_level=>fnd_log.level_procedure);
1353: END IF;
1354: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 1450: p_organization_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,

1446: -- Create organization business object.
1447: PROCEDURE do_create_organization_bo(
1448: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1449: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1450: p_organization_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,
1451: p_created_by_module IN VARCHAR2,
1452: p_obj_source IN VARCHAR2 := null,
1453: x_return_status OUT NOCOPY VARCHAR2,
1454: x_msg_count OUT NOCOPY NUMBER,

Line 1974: p_organization_obj IN HZ_ORGANIZATION_BO,

1970:
1971: PROCEDURE create_organization_bo(
1972: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1973: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1974: p_organization_obj IN HZ_ORGANIZATION_BO,
1975: p_created_by_module IN VARCHAR2,
1976: x_return_status OUT NOCOPY VARCHAR2,
1977: x_msg_count OUT NOCOPY NUMBER,
1978: x_msg_data OUT NOCOPY VARCHAR2,

Line 1983: l_org_obj HZ_ORGANIZATION_BO;

1979: x_organization_id OUT NOCOPY NUMBER,
1980: x_organization_os OUT NOCOPY VARCHAR2,
1981: x_organization_osr OUT NOCOPY VARCHAR2
1982: ) IS
1983: l_org_obj HZ_ORGANIZATION_BO;
1984: BEGIN
1985: l_org_obj := p_organization_obj;
1986: do_create_organization_bo(
1987: p_init_msg_list => p_init_msg_list,

Line 2003: p_organization_obj IN HZ_ORGANIZATION_BO,

1999: END create_organization_bo;
2000:
2001: PROCEDURE create_organization_bo(
2002: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2003: p_organization_obj IN HZ_ORGANIZATION_BO,
2004: p_created_by_module IN VARCHAR2,
2005: p_obj_source IN VARCHAR2 := null,
2006: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2007: x_return_status OUT NOCOPY VARCHAR2,

Line 2009: x_return_obj OUT NOCOPY HZ_ORGANIZATION_BO,

2005: p_obj_source IN VARCHAR2 := null,
2006: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2007: x_return_status OUT NOCOPY VARCHAR2,
2008: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
2009: x_return_obj OUT NOCOPY HZ_ORGANIZATION_BO,
2010: x_organization_id OUT NOCOPY NUMBER,
2011: x_organization_os OUT NOCOPY VARCHAR2,
2012: x_organization_osr OUT NOCOPY VARCHAR2
2013: ) IS

Line 2016: l_org_obj HZ_ORGANIZATION_BO;

2012: x_organization_osr OUT NOCOPY VARCHAR2
2013: ) IS
2014: l_msg_data VARCHAR2(2000);
2015: l_msg_count NUMBER;
2016: l_org_obj HZ_ORGANIZATION_BO;
2017: BEGIN
2018: l_org_obj := p_organization_obj;
2019: do_create_organization_bo(
2020: p_init_msg_list => fnd_api.g_true,

Line 2047: p_organization_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,

2043: -- DESCRIPTION
2044: -- Update organization business object.
2045: PROCEDURE do_update_organization_bo(
2046: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2047: p_organization_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,
2048: p_created_by_module IN VARCHAR2,
2049: p_obj_source IN VARCHAR2 := null,
2050: x_return_status OUT NOCOPY VARCHAR2,
2051: x_msg_count OUT NOCOPY NUMBER,

Line 2602: p_organization_obj IN HZ_ORGANIZATION_BO,

2598: END do_update_organization_bo;
2599:
2600: PROCEDURE update_organization_bo(
2601: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2602: p_organization_obj IN HZ_ORGANIZATION_BO,
2603: p_created_by_module IN VARCHAR2,
2604: x_return_status OUT NOCOPY VARCHAR2,
2605: x_msg_count OUT NOCOPY NUMBER,
2606: x_msg_data OUT NOCOPY VARCHAR2,

Line 2611: l_org_obj HZ_ORGANIZATION_BO;

2607: x_organization_id OUT NOCOPY NUMBER,
2608: x_organization_os OUT NOCOPY VARCHAR2,
2609: x_organization_osr OUT NOCOPY VARCHAR2
2610: ) IS
2611: l_org_obj HZ_ORGANIZATION_BO;
2612: BEGIN
2613: l_org_obj := p_organization_obj;
2614: do_update_organization_bo(
2615: p_init_msg_list => p_init_msg_list,

Line 2629: p_organization_obj IN HZ_ORGANIZATION_BO,

2625: );
2626: END update_organization_bo;
2627:
2628: PROCEDURE update_organization_bo(
2629: p_organization_obj IN HZ_ORGANIZATION_BO,
2630: p_created_by_module IN VARCHAR2,
2631: p_obj_source IN VARCHAR2 := null,
2632: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2633: x_return_status OUT NOCOPY VARCHAR2,

Line 2635: x_return_obj OUT NOCOPY HZ_ORGANIZATION_BO,

2631: p_obj_source IN VARCHAR2 := null,
2632: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2633: x_return_status OUT NOCOPY VARCHAR2,
2634: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
2635: x_return_obj OUT NOCOPY HZ_ORGANIZATION_BO,
2636: x_organization_id OUT NOCOPY NUMBER,
2637: x_organization_os OUT NOCOPY VARCHAR2,
2638: x_organization_osr OUT NOCOPY VARCHAR2
2639: )IS

Line 2642: l_org_obj HZ_ORGANIZATION_BO;

2638: x_organization_osr OUT NOCOPY VARCHAR2
2639: )IS
2640: l_msg_data VARCHAR2(2000);
2641: l_msg_count NUMBER;
2642: l_org_obj HZ_ORGANIZATION_BO;
2643: BEGIN
2644: l_org_obj := p_organization_obj;
2645: do_update_organization_bo(
2646: p_init_msg_list => fnd_api.g_true,

Line 2673: p_organization_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,

2669: -- Create or update organization business object.
2670: PROCEDURE do_save_organization_bo(
2671: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2672: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2673: p_organization_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,
2674: p_created_by_module IN VARCHAR2,
2675: p_obj_source IN VARCHAR2 := null,
2676: x_return_status OUT NOCOPY VARCHAR2,
2677: x_msg_count OUT NOCOPY NUMBER,

Line 2842: p_organization_obj IN HZ_ORGANIZATION_BO,

2838:
2839: PROCEDURE save_organization_bo(
2840: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2841: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2842: p_organization_obj IN HZ_ORGANIZATION_BO,
2843: p_created_by_module IN VARCHAR2,
2844: x_return_status OUT NOCOPY VARCHAR2,
2845: x_msg_count OUT NOCOPY NUMBER,
2846: x_msg_data OUT NOCOPY VARCHAR2,

Line 2851: l_org_obj HZ_ORGANIZATION_BO;

2847: x_organization_id OUT NOCOPY NUMBER,
2848: x_organization_os OUT NOCOPY VARCHAR2,
2849: x_organization_osr OUT NOCOPY VARCHAR2
2850: ) IS
2851: l_org_obj HZ_ORGANIZATION_BO;
2852: BEGIN
2853: l_org_obj := p_organization_obj;
2854: do_save_organization_bo(
2855: p_init_msg_list => p_init_msg_list,

Line 2871: p_organization_obj IN HZ_ORGANIZATION_BO,

2867: END save_organization_bo;
2868:
2869: PROCEDURE save_organization_bo(
2870: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2871: p_organization_obj IN HZ_ORGANIZATION_BO,
2872: p_created_by_module IN VARCHAR2,
2873: p_obj_source IN VARCHAR2 := null,
2874: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2875: x_return_status OUT NOCOPY VARCHAR2,

Line 2877: x_return_obj OUT NOCOPY HZ_ORGANIZATION_BO,

2873: p_obj_source IN VARCHAR2 := null,
2874: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2875: x_return_status OUT NOCOPY VARCHAR2,
2876: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
2877: x_return_obj OUT NOCOPY HZ_ORGANIZATION_BO,
2878: x_organization_id OUT NOCOPY NUMBER,
2879: x_organization_os OUT NOCOPY VARCHAR2,
2880: x_organization_osr OUT NOCOPY VARCHAR2
2881: ) IS

Line 2884: l_org_obj HZ_ORGANIZATION_BO;

2880: x_organization_osr OUT NOCOPY VARCHAR2
2881: ) IS
2882: l_msg_data VARCHAR2(2000);
2883: l_msg_count NUMBER;
2884: l_org_obj HZ_ORGANIZATION_BO;
2885: BEGIN
2886: l_org_obj := p_organization_obj;
2887: do_save_organization_bo(
2888: p_init_msg_list => fnd_api.g_true,

Line 2985: x_organization_obj OUT NOCOPY HZ_ORGANIZATION_BO,

2981: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2982: p_organization_id IN NUMBER,
2983: p_organization_os IN VARCHAR2,
2984: p_organization_osr IN VARCHAR2,
2985: x_organization_obj OUT NOCOPY HZ_ORGANIZATION_BO,
2986: x_return_status OUT NOCOPY VARCHAR2,
2987: x_msg_count OUT NOCOPY NUMBER,
2988: x_msg_data OUT NOCOPY VARCHAR2
2989: ) is

Line 3008: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo(+)',

3004:
3005:
3006: -- Debug info.
3007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3008: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo(+)',
3009: p_prefix=>l_debug_prefix,
3010: p_msg_level=>fnd_log.level_procedure);
3011: END IF;
3012:

Line 3057: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',

3053: END IF;
3054:
3055: -- Debug info.
3056: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3057: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3058: p_prefix=>l_debug_prefix,
3059: p_msg_level=>fnd_log.level_procedure);
3060: END IF;
3061:

Line 3080: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',

3076: p_msg_type=>'ERROR',
3077: p_msg_level=>fnd_log.level_error);
3078: END IF;
3079: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3080: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3081: p_prefix=>l_debug_prefix,
3082: p_msg_level=>fnd_log.level_procedure);
3083: END IF;
3084: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3099: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',

3095: p_msg_type=>'UNEXPECTED ERROR',
3096: p_msg_level=>fnd_log.level_error);
3097: END IF;
3098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3099: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3100: p_prefix=>l_debug_prefix,
3101: p_msg_level=>fnd_log.level_procedure);
3102: END IF;
3103: WHEN OTHERS THEN

Line 3122: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',

3118: p_msg_type=>'SQL ERROR',
3119: p_msg_level=>fnd_log.level_error);
3120: END IF;
3121: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3122: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3123: p_prefix=>l_debug_prefix,
3124: p_msg_level=>fnd_log.level_procedure);
3125: END IF;
3126:

Line 3133: x_organization_obj OUT NOCOPY HZ_ORGANIZATION_BO,

3129: PROCEDURE get_organization_bo(
3130: p_organization_id IN NUMBER,
3131: p_organization_os IN VARCHAR2,
3132: p_organization_osr IN VARCHAR2,
3133: x_organization_obj OUT NOCOPY HZ_ORGANIZATION_BO,
3134: x_return_status OUT NOCOPY VARCHAR2,
3135: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
3136: ) IS
3137: l_msg_data VARCHAR2(2000);

Line 3162: --the procedure returns database objects of the type HZ_ORGANIZATION_BO for all of

3158: -- PROCEDURE get_organizations_created
3159: --
3160: -- DESCRIPTION
3161: --The caller provides an identifier for the Organizations created business event and
3162: --the procedure returns database objects of the type HZ_ORGANIZATION_BO for all of
3163: --the Organization business objects from the business event.
3164:
3165: --
3166: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 3198: HZ_ORGANIZATION_BO_PVT.get_organization_bo

3194: business event signifies that one or more Organization business objects have been created.
3195: The caller provides an identifier for the Organizations Created business event and the procedure
3196: returns all of the Organization business objects from the business event. For each business object
3197: creation captured in the business event, the procedure calls the generic Get operation:
3198: HZ_ORGANIZATION_BO_PVT.get_organization_bo
3199:
3200: Gathering all of the returned business objects from those API calls, the procedure packages
3201: them in a table structure and returns them to the caller.
3202: */

Line 3208: x_organization_objs OUT NOCOPY HZ_ORGANIZATION_BO_TBL,

3204:
3205: PROCEDURE get_organizations_created(
3206: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3207: p_event_id IN NUMBER,
3208: x_organization_objs OUT NOCOPY HZ_ORGANIZATION_BO_TBL,
3209: x_return_status OUT NOCOPY VARCHAR2,
3210: x_msg_count OUT NOCOPY NUMBER,
3211: x_msg_data OUT NOCOPY VARCHAR2
3212: ) is

Line 3227: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(+)',

3223:
3224:
3225: -- Debug info.
3226: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3227: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(+)',
3228: p_prefix=>l_debug_prefix,
3229: p_msg_level=>fnd_log.level_procedure);
3230: END IF;
3231:

Line 3266: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created (-)',

3262: END IF;
3263:
3264: -- Debug info.
3265: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3266: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created (-)',
3267: p_prefix=>l_debug_prefix,
3268: p_msg_level=>fnd_log.level_procedure);
3269: END IF;
3270:

Line 3289: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',

3285: p_msg_type=>'ERROR',
3286: p_msg_level=>fnd_log.level_error);
3287: END IF;
3288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3289: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',
3290: p_prefix=>l_debug_prefix,
3291: p_msg_level=>fnd_log.level_procedure);
3292: END IF;
3293: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3308: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',

3304: p_msg_type=>'UNEXPECTED ERROR',
3305: p_msg_level=>fnd_log.level_error);
3306: END IF;
3307: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3308: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',
3309: p_prefix=>l_debug_prefix,
3310: p_msg_level=>fnd_log.level_procedure);
3311: END IF;
3312: WHEN OTHERS THEN

Line 3331: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',

3327: p_msg_type=>'SQL ERROR',
3328: p_msg_level=>fnd_log.level_error);
3329: END IF;
3330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3331: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',
3332: p_prefix=>l_debug_prefix,
3333: p_msg_level=>fnd_log.level_procedure);
3334: END IF;
3335:

Line 3340: x_organization_objs OUT NOCOPY HZ_ORGANIZATION_BO_TBL,

3336: end;
3337:
3338: PROCEDURE get_organizations_created(
3339: p_event_id IN NUMBER,
3340: x_organization_objs OUT NOCOPY HZ_ORGANIZATION_BO_TBL,
3341: x_return_status OUT NOCOPY VARCHAR2,
3342: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
3343: ) is
3344: l_msg_data VARCHAR2(2000);

Line 3368: --the procedure returns database objects of the type HZ_ORGANIZATION_BO for all of

3364: -- PROCEDURE get_organizations_updated
3365: --
3366: -- DESCRIPTION
3367: --The caller provides an identifier for the Organizations update business event and
3368: --the procedure returns database objects of the type HZ_ORGANIZATION_BO for all of
3369: --the Organization business objects from the business event.
3370:
3371: --
3372: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 3402: database objects of the type HZ_ORGANIZATION_BO for all of the Organization business objects from the

3398: The Get Organizations Updated procedure is a service to retrieve all of the Organization business objects
3399: whose updates have been captured by the logical business event. Each Organizations Updated business event
3400: signifies that one or more Organization business objects have been updated.
3401: The caller provides an identifier for the Organizations Update business event and the procedure returns
3402: database objects of the type HZ_ORGANIZATION_BO for all of the Organization business objects from the
3403: business event.
3404: Gathering all of the returned database objects from those API calls, the procedure packages them in a table
3405: structure and returns them to the caller.
3406: */

Line 3411: x_organization_objs OUT NOCOPY HZ_ORGANIZATION_BO_TBL,

3407:
3408: PROCEDURE get_organizations_updated(
3409: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3410: p_event_id IN NUMBER,
3411: x_organization_objs OUT NOCOPY HZ_ORGANIZATION_BO_TBL,
3412: x_return_status OUT NOCOPY VARCHAR2,
3413: x_msg_count OUT NOCOPY NUMBER,
3414: x_msg_data OUT NOCOPY VARCHAR2
3415: ) is

Line 3431: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(+)',

3427:
3428:
3429: -- Debug info.
3430: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3431: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(+)',
3432: p_prefix=>l_debug_prefix,
3433: p_msg_level=>fnd_log.level_procedure);
3434: END IF;
3435:

Line 3470: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated (-)',

3466: END IF;
3467:
3468: -- Debug info.
3469: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3470: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated (-)',
3471: p_prefix=>l_debug_prefix,
3472: p_msg_level=>fnd_log.level_procedure);
3473: END IF;
3474:

Line 3493: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',

3489: p_msg_type=>'ERROR',
3490: p_msg_level=>fnd_log.level_error);
3491: END IF;
3492: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3493: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
3494: p_prefix=>l_debug_prefix,
3495: p_msg_level=>fnd_log.level_procedure);
3496: END IF;
3497: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3512: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',

3508: p_msg_type=>'UNEXPECTED ERROR',
3509: p_msg_level=>fnd_log.level_error);
3510: END IF;
3511: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3512: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
3513: p_prefix=>l_debug_prefix,
3514: p_msg_level=>fnd_log.level_procedure);
3515: END IF;
3516: WHEN OTHERS THEN

Line 3535: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',

3531: p_msg_type=>'SQL ERROR',
3532: p_msg_level=>fnd_log.level_error);
3533: END IF;
3534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3535: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
3536: p_prefix=>l_debug_prefix,
3537: p_msg_level=>fnd_log.level_procedure);
3538: END IF;
3539:

Line 3544: x_organization_objs OUT NOCOPY HZ_ORGANIZATION_BO_TBL,

3540: end;
3541:
3542: PROCEDURE get_organizations_updated(
3543: p_event_id IN NUMBER,
3544: x_organization_objs OUT NOCOPY HZ_ORGANIZATION_BO_TBL,
3545: x_return_status OUT NOCOPY VARCHAR2,
3546: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
3547: ) IS
3548: l_msg_data VARCHAR2(2000);

Line 3572: --the procedure returns one database object of the type HZ_ORGANIZATION_BO

3568: -- PROCEDURE get_organization_updated
3569: --
3570: -- DESCRIPTION
3571: --The caller provides an identifier for the Organizations update business event and organization id
3572: --the procedure returns one database object of the type HZ_ORGANIZATION_BO
3573: --
3574: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3575: --
3576: -- ARGUMENTS

Line 3601: x_organization_obj OUT NOCOPY HZ_ORGANIZATION_BO,

3597: PROCEDURE get_organization_updated(
3598: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3599: p_event_id IN NUMBER,
3600: p_organization_id IN NUMBER,
3601: x_organization_obj OUT NOCOPY HZ_ORGANIZATION_BO,
3602: x_return_status OUT NOCOPY VARCHAR2,
3603: x_msg_count OUT NOCOPY NUMBER,
3604: x_msg_data OUT NOCOPY VARCHAR2
3605: ) is

Line 3620: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(+)',

3616:
3617:
3618: -- Debug info.
3619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3620: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(+)',
3621: p_prefix=>l_debug_prefix,
3622: p_msg_level=>fnd_log.level_procedure);
3623: END IF;
3624:

Line 3660: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated (-)',

3656: END IF;
3657:
3658: -- Debug info.
3659: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3660: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated (-)',
3661: p_prefix=>l_debug_prefix,
3662: p_msg_level=>fnd_log.level_procedure);
3663: END IF;
3664:

Line 3683: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',

3679: p_msg_type=>'ERROR',
3680: p_msg_level=>fnd_log.level_error);
3681: END IF;
3682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3683: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
3684: p_prefix=>l_debug_prefix,
3685: p_msg_level=>fnd_log.level_procedure);
3686: END IF;
3687: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3702: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',

3698: p_msg_type=>'UNEXPECTED ERROR',
3699: p_msg_level=>fnd_log.level_error);
3700: END IF;
3701: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3702: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
3703: p_prefix=>l_debug_prefix,
3704: p_msg_level=>fnd_log.level_procedure);
3705: END IF;
3706: WHEN OTHERS THEN

Line 3725: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',

3721: p_msg_type=>'SQL ERROR',
3722: p_msg_level=>fnd_log.level_error);
3723: END IF;
3724: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3725: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
3726: p_prefix=>l_debug_prefix,
3727: p_msg_level=>fnd_log.level_procedure);
3728: END IF;
3729:

Line 3735: x_organization_obj OUT NOCOPY HZ_ORGANIZATION_BO,

3731:
3732: PROCEDURE get_organization_updated(
3733: p_event_id IN NUMBER,
3734: p_organization_id IN NUMBER,
3735: x_organization_obj OUT NOCOPY HZ_ORGANIZATION_BO,
3736: x_return_status OUT NOCOPY VARCHAR2,
3737: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
3738: ) IS
3739: l_msg_data VARCHAR2(2000);

Line 4029: END hz_organization_bo_pub;

4025:
4026:
4027:
4028:
4029: END hz_organization_bo_pub;