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_BES_BO_UTIL_PKG dependencies on HZ_BES_BO_UTIL_PKG

Line 1: PACKAGE BODY HZ_BES_BO_UTIL_PKG AS

1: PACKAGE BODY HZ_BES_BO_UTIL_PKG AS
2: /*$Header: ARHBESUB.pls 120.9.12000000.2 2007/07/13 23:43:24 awu ship $ */
3: ----------------------------------------------------------------------------
4: ----------------------------------------------------------------------------
5:

Line 29: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

25: hz_utility_v2pub.DEBUG
26: (p_message=> message,
27: p_prefix=>p_prefix,
28: p_msg_level=>fnd_log.level_procedure,
29: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
30: p_module => p_module);
31: END IF;
32: IF newline THEN
33: FND_FILE.put_line(FND_FILE.LOG,message);

Line 63: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

59: hz_utility_v2pub.DEBUG
60: (p_message=>'ei_HZ_CONTACT_PREFERENCES()+',
61: p_prefix=>l_debug_prefix,
62: p_msg_level=>fnd_log.level_procedure,
63: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
64: p_module =>'ei_cpp');
65: END IF;
66: /*
67: Following entities are parents of HZ_CONTACT_PREFERENCE

Line 340: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

336: hz_utility_v2pub.DEBUG
337: (p_message=>'ei_HZ_CONTACT_PREFERENCES()-',
338: p_prefix=>l_debug_prefix,
339: p_msg_level=>fnd_log.level_procedure,
340: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
341: p_module =>'ei_cpp');
342: END IF;
343: EXCEPTION
344: WHEN OTHERS THEN

Line 369: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

365: hz_utility_v2pub.DEBUG
366: (p_message=>'ei_HZ_PARTY_SITES_EXT_VL()+',
367: p_prefix=>l_debug_prefix,
368: p_msg_level=>fnd_log.level_procedure,
369: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
370: p_module =>'ei_psext');
371: END IF;
372: /*
373: Following entities are parents of HZ_PARTY_SITES_EXT_VL

Line 522: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

518: hz_utility_v2pub.DEBUG
519: (p_message=>'ei_HZ_PARTY_SITES_EXT_VL()-',
520: p_prefix=>l_debug_prefix,
521: p_msg_level=>fnd_log.level_procedure,
522: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
523: p_module =>'ei_psext');
524: END IF;
525: EXCEPTION
526: WHEN OTHERS THEN

Line 551: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

547: hz_utility_v2pub.DEBUG
548: (p_message=>'ei_HZ_ORG_PROFILES_EXT_VL()+',
549: p_prefix=>l_debug_prefix,
550: p_msg_level=>fnd_log.level_procedure,
551: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
552: p_module =>'ei_oext');
553: END IF;
554: /*
555: Following entities are parents of HZ_ORG_PROFILES_EXT_VL

Line 638: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

634: hz_utility_v2pub.DEBUG
635: (p_message=>'ei_HZ_ORG_PROFILES_EXT_VL()-',
636: p_prefix=>l_debug_prefix,
637: p_msg_level=>fnd_log.level_procedure,
638: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
639: p_module =>'ei_oext');
640: END IF;
641: EXCEPTION
642: WHEN OTHERS THEN

Line 667: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

663: hz_utility_v2pub.DEBUG
664: (p_message=>'ei_HZ_PER_PROFILES_EXT_VL()+',
665: p_prefix=>l_debug_prefix,
666: p_msg_level=>fnd_log.level_procedure,
667: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
668: p_module =>'ei_pext');
669: hz_utility_v2pub.DEBUG
670: (p_message=>'pop per prof ext for person sharing',
671: p_prefix=>l_debug_prefix,

Line 673: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

669: hz_utility_v2pub.DEBUG
670: (p_message=>'pop per prof ext for person sharing',
671: p_prefix=>l_debug_prefix,
672: p_msg_level=>fnd_log.level_procedure,
673: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
674: p_module =>'ei_pext');
675: END IF;
676: /*
677: The Person extenstion EO/API will write

Line 857: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

853: hz_utility_v2pub.DEBUG
854: (p_message=>'pop missing lnks for per prof ext',
855: p_prefix=>l_debug_prefix,
856: p_msg_level=>fnd_log.level_procedure,
857: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
858: p_module =>'ei_pext');
859: END IF;
860: INSERT INTO HZ_BUS_OBJ_TRACKING
861: (CHILD_ENTITY_NAME, CHILD_ID,

Line 950: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

946: hz_utility_v2pub.DEBUG
947: (p_message=>'ei_HZ_PER_PROFILES_EXT_VL()-',
948: p_prefix=>l_debug_prefix,
949: p_msg_level=>fnd_log.level_procedure,
950: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
951: p_module =>'ei_pext');
952: END IF;
953: EXCEPTION
954: WHEN OTHERS THEN

Line 982: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

978: hz_utility_v2pub.DEBUG
979: (p_message=>'ei_HZ_PERSON_PROFILES+',
980: p_prefix=>l_debug_prefix,
981: p_msg_level=>fnd_log.level_procedure,
982: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
983: p_module =>'ei_pp');
984: hz_utility_v2pub.DEBUG
985: (p_message=>'pop per prof ext for person sharing',
986: p_prefix=>l_debug_prefix,

Line 988: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

984: hz_utility_v2pub.DEBUG
985: (p_message=>'pop per prof ext for person sharing',
986: p_prefix=>l_debug_prefix,
987: p_msg_level=>fnd_log.level_procedure,
988: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
989: p_module =>'ei_pp');
990: END IF;
991: /*
992: The Person Profile V2 API will write

Line 1148: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

1144: hz_utility_v2pub.DEBUG
1145: (p_message=>'pop missing lnks for per prof',
1146: p_prefix=>l_debug_prefix,
1147: p_msg_level=>fnd_log.level_procedure,
1148: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
1149: p_module =>'ei_pp');
1150: END IF;
1151: INSERT INTO HZ_BUS_OBJ_TRACKING
1152: (CHILD_ENTITY_NAME, CHILD_ID,

Line 1242: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

1238: hz_utility_v2pub.DEBUG
1239: (p_message=>'ei_HZ_PERSON_PROFILES-',
1240: p_prefix=>l_debug_prefix,
1241: p_msg_level=>fnd_log.level_procedure,
1242: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
1243: p_module =>'ei_pp');
1244: END IF;
1245: EXCEPTION
1246: WHEN OTHERS THEN

Line 1274: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

1270: hz_utility_v2pub.DEBUG
1271: (p_message=>'ei_HZ_PARTY_SITE_USES+',
1272: p_prefix=>l_debug_prefix,
1273: p_msg_level=>fnd_log.level_procedure,
1274: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
1275: p_module =>'ei_psu');
1276: END IF;
1277: /*
1278: Following entities are parents of HZ_PARTY_SITE_USES

Line 1448: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

1444: hz_utility_v2pub.DEBUG
1445: (p_message=>'ei_HZ_PARTY_SITE_USES-',
1446: p_prefix=>l_debug_prefix,
1447: p_msg_level=>fnd_log.level_procedure,
1448: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
1449: p_module =>'ei_psu');
1450: END IF;
1451: EXCEPTION
1452: WHEN OTHERS THEN

Line 1480: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

1476: hz_utility_v2pub.DEBUG
1477: (p_message=>'ei_HZ_PARTY_SITES+',
1478: p_prefix=>l_debug_prefix,
1479: p_msg_level=>fnd_log.level_procedure,
1480: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
1481: p_module =>'ei_ps');
1482: END IF;
1483: /*
1484: Party Site has following parents

Line 1623: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

1619: hz_utility_v2pub.DEBUG
1620: (p_message=>'ei_HZ_PARTY_SITES-',
1621: p_prefix=>l_debug_prefix,
1622: p_msg_level=>fnd_log.level_procedure,
1623: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
1624: p_module =>'ei_ps');
1625: END IF;
1626: EXCEPTION
1627: WHEN OTHERS THEN

Line 1655: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

1651: hz_utility_v2pub.DEBUG
1652: (p_message=>'ei_HZ_ORG_CONTACTS+',
1653: p_prefix=>l_debug_prefix,
1654: p_msg_level=>fnd_log.level_procedure,
1655: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
1656: p_module =>'ei_oc');
1657: END IF;
1658: /*
1659: Party Site has following parents

Line 1733: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

1729: hz_utility_v2pub.DEBUG
1730: (p_message=>'ei_HZ_ORG_CONTACTS-',
1731: p_prefix=>l_debug_prefix,
1732: p_msg_level=>fnd_log.level_procedure,
1733: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
1734: p_module =>'ei_oc');
1735: END IF;
1736: EXCEPTION
1737: WHEN OTHERS THEN

Line 1765: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

1761: hz_utility_v2pub.DEBUG
1762: (p_message=>'ei_HZ_LOCATIONS_ext+',
1763: p_prefix=>l_debug_prefix,
1764: p_msg_level=>fnd_log.level_procedure,
1765: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
1766: p_module =>'ei_locext');
1767: END IF;
1768: /*
1769: Following entities are parents of HZ_LOCATIONS_EXT_VL

Line 1859: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

1855: hz_utility_v2pub.DEBUG
1856: (p_message=>'ei_HZ_LOCATIONS_ext-',
1857: p_prefix=>l_debug_prefix,
1858: p_msg_level=>fnd_log.level_procedure,
1859: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
1860: p_module =>'ei_locext');
1861: END IF;
1862: EXCEPTION
1863: WHEN OTHERS THEN

Line 1891: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

1887: hz_utility_v2pub.DEBUG
1888: (p_message=>'ei_HZ_LOCATIONS+',
1889: p_prefix=>l_debug_prefix,
1890: p_msg_level=>fnd_log.level_procedure,
1891: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
1892: p_module =>'ei_loc');
1893: END IF;
1894: /*
1895: Following entities are parents of HZ_LOCATIONS

Line 2066: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

2062: hz_utility_v2pub.DEBUG
2063: (p_message=>'ei_HZ_LOCATIONS-',
2064: p_prefix=>l_debug_prefix,
2065: p_msg_level=>fnd_log.level_procedure,
2066: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
2067: p_module =>'ei_loc');
2068: END IF;
2069: EXCEPTION
2070: WHEN OTHERS THEN

Line 2098: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

2094: hz_utility_v2pub.DEBUG
2095: (p_message=>'ei_HZ_CUST_SITE_USES_ALL+',
2096: p_prefix=>l_debug_prefix,
2097: p_msg_level=>fnd_log.level_procedure,
2098: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
2099: p_module =>'ei_actsiteuse');
2100: END IF;
2101: /*
2102: HZ_CUST_SITE_USES_ALL has following parent

Line 2223: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

2219: hz_utility_v2pub.DEBUG
2220: (p_message=>'ei_HZ_CUST_SITE_USES_ALL-',
2221: p_prefix=>l_debug_prefix,
2222: p_msg_level=>fnd_log.level_procedure,
2223: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
2224: p_module =>'ei_actsiteuse');
2225: END IF;
2226: EXCEPTION
2227: WHEN OTHERS THEN

Line 2255: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

2251: hz_utility_v2pub.DEBUG
2252: (p_message=>'ei_HZ_CUST_ACCT_SITES_ALL+',
2253: p_prefix=>l_debug_prefix,
2254: p_msg_level=>fnd_log.level_procedure,
2255: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
2256: p_module =>'ei_actsite');
2257: END IF;
2258: /*
2259: HZ_CUST_ACCT_SITES_ALL has following parent

Line 2372: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

2368: hz_utility_v2pub.DEBUG
2369: (p_message=>'ei_HZ_CUST_ACCT_SITES_ALL-',
2370: p_prefix=>l_debug_prefix,
2371: p_msg_level=>fnd_log.level_procedure,
2372: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
2373: p_module =>'ei_actsite');
2374: END IF;
2375: EXCEPTION
2376: WHEN OTHERS THEN

Line 2404: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

2400: hz_utility_v2pub.DEBUG
2401: (p_message=>'ei_HZ_CUST_ACCOUNT_ROLES+',
2402: p_prefix=>l_debug_prefix,
2403: p_msg_level=>fnd_log.level_procedure,
2404: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
2405: p_module =>'ei_actroles');
2406: END IF;
2407: /*
2408: Party Site has following parents

Line 2556: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

2552: hz_utility_v2pub.DEBUG
2553: (p_message=>'ei_HZ_CUST_ACCOUNT_ROLES-',
2554: p_prefix=>l_debug_prefix,
2555: p_msg_level=>fnd_log.level_procedure,
2556: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
2557: p_module =>'ei_actroles');
2558: END IF;
2559: EXCEPTION
2560: WHEN OTHERS THEN

Line 2588: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

2584: hz_utility_v2pub.DEBUG
2585: (p_message=>'ei_HZ_CUST_ACCOUNTS+',
2586: p_prefix=>l_debug_prefix,
2587: p_msg_level=>fnd_log.level_procedure,
2588: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
2589: p_module =>'ei_act');
2590: END IF;
2591: /*
2592: HZ_CUST_ACCOUNTS has following parents

Line 2704: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

2700: hz_utility_v2pub.DEBUG
2701: (p_message=>'ei_HZ_CUST_ACCOUNTS-',
2702: p_prefix=>l_debug_prefix,
2703: p_msg_level=>fnd_log.level_procedure,
2704: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
2705: p_module =>'ei_act');
2706: END IF;
2707: EXCEPTION
2708: WHEN OTHERS THEN

Line 2736: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

2732: hz_utility_v2pub.DEBUG
2733: (p_message=>'ei_HZ_CUSTOMER_PROFILES+',
2734: p_prefix=>l_debug_prefix,
2735: p_msg_level=>fnd_log.level_procedure,
2736: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
2737: p_module =>'ei_custprof');
2738: END IF;
2739: /*
2740: Party Site has following parents

Line 2891: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

2887: hz_utility_v2pub.DEBUG
2888: (p_message=>'ei_HZ_CUSTOMER_PROFILES-',
2889: p_prefix=>l_debug_prefix,
2890: p_msg_level=>fnd_log.level_procedure,
2891: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
2892: p_module =>'ei_custprof');
2893: END IF;
2894: EXCEPTION
2895: WHEN OTHERS THEN

Line 2923: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

2919: hz_utility_v2pub.DEBUG
2920: (p_message=>'ei_HZ_CONTACT_POINTS+',
2921: p_prefix=>l_debug_prefix,
2922: p_msg_level=>fnd_log.level_procedure,
2923: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
2924: p_module =>'ei_cp');
2925: END IF;
2926:
2927: /*

Line 3120: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3116: hz_utility_v2pub.DEBUG
3117: (p_message=>'ei_HZ_CONTACT_POINTS-',
3118: p_prefix=>l_debug_prefix,
3119: p_msg_level=>fnd_log.level_procedure,
3120: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3121: p_module =>'ei_cp');
3122: END IF;
3123:
3124: EXCEPTION

Line 3237: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3233: hz_utility_v2pub.DEBUG
3234: (p_message=>'entity_in_bo()+',
3235: p_prefix=>l_debug_prefix,
3236: p_msg_level=>fnd_log.level_procedure,
3237: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3238: p_module =>l_module);
3239: hz_utility_v2pub.DEBUG
3240: (p_message=>'bfr validating parameters',
3241: p_prefix=>l_debug_prefix,

Line 3243: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3239: hz_utility_v2pub.DEBUG
3240: (p_message=>'bfr validating parameters',
3241: p_prefix=>l_debug_prefix,
3242: p_msg_level=>fnd_log.level_procedure,
3243: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3244: p_module =>l_module);
3245: END IF;
3246: -- P_BO_CODE, p_ebo_code, p_entity_name must be not null
3247: IF (p_bo_code IS NULL) THEN

Line 3253: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3249: hz_utility_v2pub.DEBUG
3250: (p_message=>'p_bo_code mandatory param is null',
3251: p_prefix=>l_debug_prefix,
3252: p_msg_level=>fnd_log.level_procedure,
3253: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3254: p_module =>l_module);
3255: hz_utility_v2pub.DEBUG
3256: (p_message=>'entity_in_bo()-',
3257: p_prefix=>l_debug_prefix,

Line 3259: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3255: hz_utility_v2pub.DEBUG
3256: (p_message=>'entity_in_bo()-',
3257: p_prefix=>l_debug_prefix,
3258: p_msg_level=>fnd_log.level_procedure,
3259: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3260: p_module =>l_module);
3261: END IF;
3262: RAISE FND_API.G_EXC_ERROR;
3263: END IF;

Line 3270: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3266: hz_utility_v2pub.DEBUG
3267: (p_message=>'p_ebo_code mandatory param is null',
3268: p_prefix=>l_debug_prefix,
3269: p_msg_level=>fnd_log.level_procedure,
3270: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3271: p_module =>l_module);
3272: hz_utility_v2pub.DEBUG
3273: (p_message=>'entity_in_bo()-',
3274: p_prefix=>l_debug_prefix,

Line 3276: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3272: hz_utility_v2pub.DEBUG
3273: (p_message=>'entity_in_bo()-',
3274: p_prefix=>l_debug_prefix,
3275: p_msg_level=>fnd_log.level_procedure,
3276: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3277: p_module =>l_module);
3278: END IF;
3279: RAISE FND_API.G_EXC_ERROR;
3280: END IF;

Line 3287: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3283: hz_utility_v2pub.DEBUG
3284: (p_message=>'p_entity_name mandatory param is null',
3285: p_prefix=>l_debug_prefix,
3286: p_msg_level=>fnd_log.level_procedure,
3287: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3288: p_module =>l_module);
3289: hz_utility_v2pub.DEBUG
3290: (p_message=>'entity_in_bo()-',
3291: p_prefix=>l_debug_prefix,

Line 3293: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3289: hz_utility_v2pub.DEBUG
3290: (p_message=>'entity_in_bo()-',
3291: p_prefix=>l_debug_prefix,
3292: p_msg_level=>fnd_log.level_procedure,
3293: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3294: p_module =>l_module);
3295: END IF;
3296: RAISE FND_API.G_EXC_ERROR;
3297: END IF;

Line 3333: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3329: hz_utility_v2pub.DEBUG
3330: (p_message=>'node path is:'||l_node,
3331: p_prefix=>l_debug_prefix,
3332: p_msg_level=>fnd_log.level_procedure,
3333: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3334: p_module =>l_module);
3335: END IF;
3336: -- OPEN c_chk_entity (p_bo_code, p_ebo_code, p_child_bo_code, p_entity_name);
3337: OPEN c_chk_entity (p_bo_code, p_entity_name, l_node);

Line 3354: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3350: hz_utility_v2pub.DEBUG
3351: (p_message=>sqlerrm,
3352: p_prefix=>l_debug_prefix,
3353: p_msg_level=>fnd_log.level_procedure,
3354: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3355: p_module =>l_module);
3356: hz_utility_v2pub.DEBUG
3357: (p_message=>'entity_in_bo()-',
3358: p_prefix=>l_debug_prefix,

Line 3360: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3356: hz_utility_v2pub.DEBUG
3357: (p_message=>'entity_in_bo()-',
3358: p_prefix=>l_debug_prefix,
3359: p_msg_level=>fnd_log.level_procedure,
3360: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3361: p_module =>l_module);
3362: END IF;
3363: END entity_in_bo;
3364: -----------------------------------------------------------------

Line 3452: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3448: hz_utility_v2pub.DEBUG
3449: (p_message=>'bfr calling ei_HZ_CONTACT_PREFERENCES()',
3450: p_prefix=>l_debug_prefix,
3451: p_msg_level=>fnd_log.level_procedure,
3452: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3453: p_module =>'pop_missing_lnks');
3454: END IF;
3455:
3456: ei_HZ_CONTACT_PREFERENCES;

Line 3468: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3464: hz_utility_v2pub.DEBUG
3465: (p_message=>'bfr calling ei_HZ_PER_PROFILES_EXT_VL()',
3466: p_prefix=>l_debug_prefix,
3467: p_msg_level=>fnd_log.level_procedure,
3468: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3469: p_module =>'pop_missing_lnks');
3470: END IF;
3471:
3472: ei_HZ_PER_PROFILES_EXT_VL;

Line 3484: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3480: hz_utility_v2pub.DEBUG
3481: (p_message=>'bfr calling ei_HZ_PERSON_PROFILES()',
3482: p_prefix=>l_debug_prefix,
3483: p_msg_level=>fnd_log.level_procedure,
3484: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3485: p_module =>'pop_missing_lnks');
3486: END IF;
3487:
3488: ei_HZ_PERSON_PROFILES;

Line 3500: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3496: hz_utility_v2pub.DEBUG
3497: (p_message=>'bfr calling ei_HZ_PARTY_SITE_USES()',
3498: p_prefix=>l_debug_prefix,
3499: p_msg_level=>fnd_log.level_procedure,
3500: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3501: p_module =>'pop_missing_lnks');
3502: END IF;
3503:
3504: ei_HZ_PARTY_SITE_USES;

Line 3516: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3512: hz_utility_v2pub.DEBUG
3513: (p_message=>'bfr calling ei_HZ_CONTACT_POINTS()',
3514: p_prefix=>l_debug_prefix,
3515: p_msg_level=>fnd_log.level_procedure,
3516: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3517: p_module =>'pop_missing_lnks');
3518: END IF;
3519:
3520: ei_HZ_CONTACT_POINTS;

Line 3532: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3528: hz_utility_v2pub.DEBUG
3529: (p_message=>'bfr calling ei_HZ_PARTY_SITES_EXT_VL()',
3530: p_prefix=>l_debug_prefix,
3531: p_msg_level=>fnd_log.level_procedure,
3532: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3533: p_module =>'pop_missing_lnks');
3534: END IF;
3535:
3536: ei_HZ_PARTY_SITES_EXT_VL;

Line 3548: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3544: hz_utility_v2pub.DEBUG
3545: (p_message=>'bfr calling ei_HZ_LOCATIONS_EXT()',
3546: p_prefix=>l_debug_prefix,
3547: p_msg_level=>fnd_log.level_procedure,
3548: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3549: p_module =>'pop_missing_lnks');
3550: END IF;
3551:
3552: ei_HZ_LOCATIONS_EXT;

Line 3564: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3560: hz_utility_v2pub.DEBUG
3561: (p_message=>'bfr calling ei_HZ_LOCATIONS()',
3562: p_prefix=>l_debug_prefix,
3563: p_msg_level=>fnd_log.level_procedure,
3564: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3565: p_module =>'pop_missing_lnks');
3566: END IF;
3567:
3568: ei_HZ_LOCATIONS;

Line 3580: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3576: hz_utility_v2pub.DEBUG
3577: (p_message=>'bfr calling ei_HZ_PARTY_SITES()',
3578: p_prefix=>l_debug_prefix,
3579: p_msg_level=>fnd_log.level_procedure,
3580: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3581: p_module =>'pop_missing_lnks');
3582: END IF;
3583:
3584: ei_HZ_PARTY_SITES;

Line 3596: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3592: hz_utility_v2pub.DEBUG
3593: (p_message=>'bfr calling ei_HZ_ORG_CONTACTS()',
3594: p_prefix=>l_debug_prefix,
3595: p_msg_level=>fnd_log.level_procedure,
3596: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3597: p_module =>'pop_missing_lnks');
3598: END IF;
3599:
3600: ei_HZ_ORG_CONTACTS;

Line 3612: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3608: hz_utility_v2pub.DEBUG
3609: (p_message=>'bfr calling ei_HZ_ORG_PROFILES_EXT_VL()',
3610: p_prefix=>l_debug_prefix,
3611: p_msg_level=>fnd_log.level_procedure,
3612: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3613: p_module =>'pop_missing_lnks');
3614: END IF;
3615:
3616: ei_HZ_ORG_PROFILES_EXT_VL;

Line 3628: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3624: hz_utility_v2pub.DEBUG
3625: (p_message=>'bfr calling ei_HZ_CUST_ACCOUNT_ROLES()',
3626: p_prefix=>l_debug_prefix,
3627: p_msg_level=>fnd_log.level_procedure,
3628: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3629: p_module =>'pop_missing_lnks');
3630: END IF;
3631:
3632: ei_HZ_CUST_ACCOUNT_ROLES;

Line 3644: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3640: hz_utility_v2pub.DEBUG
3641: (p_message=>'bfr calling ei_HZ_CUSTOMER_PROFILES()',
3642: p_prefix=>l_debug_prefix,
3643: p_msg_level=>fnd_log.level_procedure,
3644: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3645: p_module =>'pop_missing_lnks');
3646: END IF;
3647:
3648: ei_HZ_CUSTOMER_PROFILES;

Line 3660: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3656: hz_utility_v2pub.DEBUG
3657: (p_message=>'bfr calling ei_HZ_CUST_SITE_USES_ALL()',
3658: p_prefix=>l_debug_prefix,
3659: p_msg_level=>fnd_log.level_procedure,
3660: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3661: p_module =>'pop_missing_lnks');
3662: END IF;
3663:
3664: ei_HZ_CUST_SITE_USES_ALL;

Line 3677: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3673: hz_utility_v2pub.DEBUG
3674: (p_message=>'bfr calling ei_HZ_CUST_ACCT_SITES_ALL()',
3675: p_prefix=>l_debug_prefix,
3676: p_msg_level=>fnd_log.level_procedure,
3677: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3678: p_module =>'pop_missing_lnks');
3679: END IF;
3680:
3681: ei_HZ_CUST_ACCT_SITES_ALL;

Line 3694: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3690: hz_utility_v2pub.DEBUG
3691: (p_message=>'bfr calling ei_HZ_CUST_ACCOUNTS()',
3692: p_prefix=>l_debug_prefix,
3693: p_msg_level=>fnd_log.level_procedure,
3694: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3695: p_module =>'pop_missing_lnks');
3696: END IF;
3697:
3698: ei_HZ_CUST_ACCOUNTS;

Line 3914: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3910: hz_utility_v2pub.DEBUG
3911: (p_message=>'upd_bot_evtid_dt()+',
3912: p_prefix=>l_debug_prefix,
3913: p_msg_level=>fnd_log.level_procedure,
3914: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3915: p_module =>'updbot');
3916: END IF;
3917:
3918: IF p_bulk_evt THEN

Line 3924: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3920: hz_utility_v2pub.DEBUG
3921: (p_message=>'for bulk event',
3922: p_prefix=>l_debug_prefix,
3923: p_msg_level=>fnd_log.level_procedure,
3924: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3925: p_module =>'updbot');
3926: END IF;
3927: -- The event was raised in bulk i.e., One event was raised for a set of
3928: -- Business Objects of the same type with same operation.

Line 3962: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

3958: hz_utility_v2pub.DEBUG
3959: (p_message=>'for one event per object instance',
3960: p_prefix=>l_debug_prefix,
3961: p_msg_level=>fnd_log.level_procedure,
3962: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3963: p_module =>'updbot');
3964: END IF;
3965: UPDATE HZ_BUS_OBJ_TRACKING
3966: SET event_id = p_evt_id,

Line 4004: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4000: hz_utility_v2pub.DEBUG
4001: (p_message=>'upd_bot_evtid_dt()-',
4002: p_prefix=>l_debug_prefix,
4003: p_msg_level=>fnd_log.level_procedure,
4004: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4005: p_module =>'updbot');
4006: END IF;
4007: EXCEPTION
4008: WHEN OTHERS THEN

Line 4053: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4049: hz_utility_v2pub.DEBUG
4050: (p_message=>'upd_hzp_bo_ver()+',
4051: p_prefix=>l_debug_prefix,
4052: p_msg_level=>fnd_log.level_procedure,
4053: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4054: p_module =>'updp');
4055: END IF;
4056:
4057: UPDATE HZ_PARTIES

Line 4100: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4096: hz_utility_v2pub.DEBUG
4097: (p_message=>'upd_hzp_bo_ver()-',
4098: p_prefix=>l_debug_prefix,
4099: p_msg_level=>fnd_log.level_procedure,
4100: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4101: p_module =>'updp');
4102: END IF;
4103: EXCEPTION
4104: WHEN OTHERS THEN

Line 4139: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4135: hz_utility_v2pub.DEBUG
4136: (p_message=>'del_bot()+',
4137: p_prefix=>l_debug_prefix,
4138: p_msg_level=>fnd_log.level_procedure,
4139: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4140: p_module =>'del_bot');
4141: hz_utility_v2pub.DEBUG
4142: (p_message=>'cutoff date is:'||TO_CHAR(p_cutoff_dt),
4143: p_prefix=>l_debug_prefix,

Line 4145: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4141: hz_utility_v2pub.DEBUG
4142: (p_message=>'cutoff date is:'||TO_CHAR(p_cutoff_dt),
4143: p_prefix=>l_debug_prefix,
4144: p_msg_level=>fnd_log.level_procedure,
4145: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4146: p_module =>'del_bot');
4147: END IF;
4148:
4149: DELETE FROM HZ_BUS_OBJ_TRACKING

Line 4191: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4187: hz_utility_v2pub.DEBUG
4188: (p_message=>'del_bot()-',
4189: p_prefix=>l_debug_prefix,
4190: p_msg_level=>fnd_log.level_procedure,
4191: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4192: p_module =>'del_bot');
4193: END IF;
4194:
4195: EXCEPTION

Line 4225: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4221: hz_utility_v2pub.DEBUG
4222: (p_message=>'del_duplicate_rows2+',
4223: p_prefix=>l_debug_prefix,
4224: p_msg_level=>fnd_log.level_procedure,
4225: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4226: p_module =>'del_dup');
4227: END IF;
4228:
4229: DELETE FROM HZ_BUS_OBJ_TRACKING

Line 4246: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4242: hz_utility_v2pub.DEBUG
4243: (p_message=>'del_duplicate_rows2-',
4244: p_prefix=>l_debug_prefix,
4245: p_msg_level=>fnd_log.level_procedure,
4246: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4247: p_module =>'del_dup');
4248: END IF;
4249:
4250:

Line 4321: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4317: hz_utility_v2pub.DEBUG
4318: (p_message=>'del_obj_hierarchy+',
4319: p_prefix=>l_debug_prefix,
4320: p_msg_level=>fnd_log.level_procedure,
4321: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4322: p_module =>l_module);
4323: END IF;
4324:
4325: OPEN c1_ptype (P_OBJ_ID );

Line 4335: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4331: hz_utility_v2pub.DEBUG
4332: (p_message=>'deleting '||l_BO_CODE||' HIERARCHY corresponds to partyId:'||P_OBJ_ID,
4333: p_prefix=>l_debug_prefix,
4334: p_msg_level=>fnd_log.level_procedure,
4335: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4336: p_module =>l_module);
4337: END IF;
4338: DELETE FROM HZ_BUS_OBJ_TRACKING
4339: WHERE ROWID IN (

Line 4353: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4349: hz_utility_v2pub.DEBUG
4350: (p_message=>'deleting '||l_bo_code||' Customer HIERARCHY corresponds to partyId:'||P_OBJ_ID,
4351: p_prefix=>l_debug_prefix,
4352: p_msg_level=>fnd_log.level_procedure,
4353: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4354: p_module =>l_module);
4355: END IF;
4356: DELETE FROM HZ_BUS_OBJ_TRACKING
4357: WHERE ROWID IN (

Line 4372: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4368: hz_utility_v2pub.DEBUG
4369: (p_message=>'deleting '||l_bo_code||' HIERARCHY corresponds to partyId:'||P_OBJ_ID,
4370: p_prefix=>l_debug_prefix,
4371: p_msg_level=>fnd_log.level_procedure,
4372: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4373: p_module =>l_module);
4374: END IF;
4375: DELETE FROM HZ_BUS_OBJ_TRACKING
4376: WHERE ROWID IN (

Line 4390: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4386: hz_utility_v2pub.DEBUG
4387: (p_message=>'deleting '||l_bo_code||' Customer HIERARCHY corresponds to partyId:'||P_OBJ_ID,
4388: p_prefix=>l_debug_prefix,
4389: p_msg_level=>fnd_log.level_procedure,
4390: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4391: p_module =>l_module);
4392: END IF;
4393: DELETE FROM HZ_BUS_OBJ_TRACKING
4394: WHERE ROWID IN (

Line 4408: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4404: hz_utility_v2pub.DEBUG
4405: (p_message=>'incorrect BO Code:'||l_bo_code,
4406: p_prefix=>l_debug_prefix,
4407: p_msg_level=>fnd_log.level_procedure,
4408: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4409: p_module =>l_module);
4410: END IF;
4411: END IF;
4412: /*

Line 4421: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4417: hz_utility_v2pub.DEBUG
4418: (p_message=>'del_obj_hierarchy-',
4419: p_prefix=>l_debug_prefix,
4420: p_msg_level=>fnd_log.level_procedure,
4421: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4422: p_module =>l_module);
4423: END IF;
4424: EXCEPTION
4425: WHEN NO_DATA_FOUND THEN

Line 4432: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4428: hz_utility_v2pub.DEBUG
4429: (p_message=>'No data to delete',
4430: p_prefix=>l_debug_prefix,
4431: p_msg_level=>fnd_log.level_procedure,
4432: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4433: p_module =>l_module);
4434: END IF;
4435: END del_obj_hierarchy;
4436: ----------------------------------------------------------------------------

Line 4490: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4486: hz_utility_v2pub.DEBUG
4487: (p_message=>'upd_entity_ids+',
4488: p_prefix=>l_debug_prefix,
4489: p_msg_level=>fnd_log.level_procedure,
4490: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4491: p_module =>l_module);
4492: END IF;
4493:
4494: /* Flow

Line 4522: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',

4518: hz_utility_v2pub.DEBUG
4519: (p_message=>'upd_entity_ids-',
4520: p_prefix=>l_debug_prefix,
4521: p_msg_level=>fnd_log.level_procedure,
4522: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
4523: p_module =>l_module);
4524: END IF;
4525: END upd_entity_ids;
4526: ----------------------------------------------------------------------------

Line 4528: END HZ_BES_BO_UTIL_PKG; -- pkg

4524: END IF;
4525: END upd_entity_ids;
4526: ----------------------------------------------------------------------------
4527: ----------------------------------------------------------------------------
4528: END HZ_BES_BO_UTIL_PKG; -- pkg