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_CLASSIFICATION_V2PUB dependencies on HZ_UTILITY_V2PUB

Line 132: * HZ_UTILITY_V2PUB.enable_debug

128: * DESCRIPTION
129: * Turn on debug mode.
130: *
131: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
132: * HZ_UTILITY_V2PUB.enable_debug
133: *
134: * MODIFICATION HISTORY
135: *
136: * 07-23-2001 Jianying Huang o Created.

Line 147: HZ_UTILITY_V2PUB.enable_debug;

143:
144: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
145: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
146: THEN
147: HZ_UTILITY_V2PUB.enable_debug;
148: G_DEBUG := TRUE;
149: END IF;
150:
151: END enable_debug;

Line 160: * HZ_UTILITY_V2PUB.disable_debug

156: * DESCRIPTION
157: * Turn off debug mode.
158: *
159: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
160: * HZ_UTILITY_V2PUB.disable_debug
161: *
162: * MODIFICATION HISTORY
163: *
164: * 07-23-2001 Jianying Huang o Created.

Line 173: HZ_UTILITY_V2PUB.disable_debug;

169:
170: BEGIN
171:
172: IF G_DEBUG THEN
173: HZ_UTILITY_V2PUB.disable_debug;
174: G_DEBUG := FALSE;
175: END IF;
176:
177: END disable_debug;

Line 798: last_update_date = hz_utility_v2pub.last_update_date,

794: )
795: THEN
796: update hz_parties
797: set category_code = p_code_assignment_rec.class_code,
798: last_update_date = hz_utility_v2pub.last_update_date,
799: last_updated_by = hz_utility_v2pub.last_updated_by,
800: last_update_login = hz_utility_v2pub.last_update_login
801: where party_id = p_code_assignment_rec.owner_table_id;
802: END IF;

Line 799: last_updated_by = hz_utility_v2pub.last_updated_by,

795: THEN
796: update hz_parties
797: set category_code = p_code_assignment_rec.class_code,
798: last_update_date = hz_utility_v2pub.last_update_date,
799: last_updated_by = hz_utility_v2pub.last_updated_by,
800: last_update_login = hz_utility_v2pub.last_update_login
801: where party_id = p_code_assignment_rec.owner_table_id;
802: END IF;
803: END IF;

Line 800: last_update_login = hz_utility_v2pub.last_update_login

796: update hz_parties
797: set category_code = p_code_assignment_rec.class_code,
798: last_update_date = hz_utility_v2pub.last_update_date,
799: last_updated_by = hz_utility_v2pub.last_updated_by,
800: last_update_login = hz_utility_v2pub.last_update_login
801: where party_id = p_code_assignment_rec.owner_table_id;
802: END IF;
803: END IF;
804:

Line 1002: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN

998:
999: --End of :3216842
1000: */
1001: -- Bug 4693719 : pass NULL if secure data is not updated
1002: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN
1003: l_acs := nvl(p_code_assignment_rec.actual_content_source, 'USER_ENTERED');
1004: ELSE
1005: l_acs := NULL;
1006: END IF;

Line 1178: last_update_date = hz_utility_v2pub.last_update_date,

1174: THEN
1175: -- terminating
1176: UPDATE HZ_PARTIES
1177: SET CATEGORY_CODE = NULL,
1178: last_update_date = hz_utility_v2pub.last_update_date,
1179: last_updated_by = hz_utility_v2pub.last_updated_by,
1180: last_update_login = hz_utility_v2pub.last_update_login
1181: WHERE PARTY_ID = nvl(p_code_assignment_rec.owner_table_id,l_owner_table_id)
1182: AND CATEGORY_CODE = nvl(p_code_assignment_rec.class_code,l_class_code);

Line 1179: last_updated_by = hz_utility_v2pub.last_updated_by,

1175: -- terminating
1176: UPDATE HZ_PARTIES
1177: SET CATEGORY_CODE = NULL,
1178: last_update_date = hz_utility_v2pub.last_update_date,
1179: last_updated_by = hz_utility_v2pub.last_updated_by,
1180: last_update_login = hz_utility_v2pub.last_update_login
1181: WHERE PARTY_ID = nvl(p_code_assignment_rec.owner_table_id,l_owner_table_id)
1182: AND CATEGORY_CODE = nvl(p_code_assignment_rec.class_code,l_class_code);
1183: ELSIF

Line 1180: last_update_login = hz_utility_v2pub.last_update_login

1176: UPDATE HZ_PARTIES
1177: SET CATEGORY_CODE = NULL,
1178: last_update_date = hz_utility_v2pub.last_update_date,
1179: last_updated_by = hz_utility_v2pub.last_updated_by,
1180: last_update_login = hz_utility_v2pub.last_update_login
1181: WHERE PARTY_ID = nvl(p_code_assignment_rec.owner_table_id,l_owner_table_id)
1182: AND CATEGORY_CODE = nvl(p_code_assignment_rec.class_code,l_class_code);
1183: ELSIF
1184: nvl(p_code_assignment_rec.primary_flag,l_primary_flag)='Y'

Line 1196: last_update_date = hz_utility_v2pub.last_update_date,

1192: )
1193: THEN
1194: update hz_parties
1195: set category_code = nvl(p_code_assignment_rec.class_code,l_class_code),
1196: last_update_date = hz_utility_v2pub.last_update_date,
1197: last_updated_by = hz_utility_v2pub.last_updated_by,
1198: last_update_login = hz_utility_v2pub.last_update_login
1199: where party_id = l_owner_table_id;
1200: END IF;

Line 1197: last_updated_by = hz_utility_v2pub.last_updated_by,

1193: THEN
1194: update hz_parties
1195: set category_code = nvl(p_code_assignment_rec.class_code,l_class_code),
1196: last_update_date = hz_utility_v2pub.last_update_date,
1197: last_updated_by = hz_utility_v2pub.last_updated_by,
1198: last_update_login = hz_utility_v2pub.last_update_login
1199: where party_id = l_owner_table_id;
1200: END IF;
1201: END IF;

Line 1198: last_update_login = hz_utility_v2pub.last_update_login

1194: update hz_parties
1195: set category_code = nvl(p_code_assignment_rec.class_code,l_class_code),
1196: last_update_date = hz_utility_v2pub.last_update_date,
1197: last_updated_by = hz_utility_v2pub.last_updated_by,
1198: last_update_login = hz_utility_v2pub.last_update_login
1199: where party_id = l_owner_table_id;
1200: END IF;
1201: END IF;
1202:

Line 1422: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

1418: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1419:
1420: -- Invoke business event system.
1421: --Bug 4743141.
1422: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
1423: HZ_BUSINESS_EVENT_V2PVT.create_class_category_event (
1424: l_class_cat_rec );
1425: END IF;
1426:

Line 1545: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

1541: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1542:
1543: -- Invoke business event system.
1544: --Bug 4743141.
1545: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
1546: HZ_BUSINESS_EVENT_V2PVT.update_class_category_event (
1547: l_class_cat_rec,
1548: l_old_class_cat_rec );
1549: END IF;

Line 1651: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

1647: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1648:
1649: -- Invoke business event system.
1650: --Bug 4743141.
1651: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
1652: HZ_BUSINESS_EVENT_V2PVT.create_class_code_rel_event (
1653: l_class_code_rel_rec );
1654: END IF;
1655:

Line 1777: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

1773: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1774:
1775: -- Invoke business event system.
1776: --Bug 4743141.
1777: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
1778: HZ_BUSINESS_EVENT_V2PVT.update_class_code_rel_event (
1779: l_class_code_rel_rec,
1780: l_old_class_code_rel_rec );
1781: END IF;

Line 1910: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

1906: -- assign out NOCOPY param
1907: x_code_assignment_id := l_code_assignment_rec.code_assignment_id;
1908:
1909: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1910: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
1911: -- Invoke business event system.
1912: HZ_BUSINESS_EVENT_V2PVT.create_code_assignment_event (
1913: l_code_assignment_rec );
1914: END IF;

Line 1916: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

1912: HZ_BUSINESS_EVENT_V2PVT.create_code_assignment_event (
1913: l_code_assignment_rec );
1914: END IF;
1915:
1916: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1917: HZ_POPULATE_BOT_PKG.pop_hz_code_assignments(
1918: p_operation => 'I',
1919: p_code_assignment_id => x_code_assignment_id);
1920: END IF;

Line 2083: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

2079: p_object_version_number,
2080: x_return_status);
2081:
2082: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2083: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2084: -- Invoke business event system.
2085: HZ_BUSINESS_EVENT_V2PVT.update_code_assignment_event (
2086: l_code_assignment_rec,
2087: l_old_code_assignment_rec );

Line 2090: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

2086: l_code_assignment_rec,
2087: l_old_code_assignment_rec );
2088: END IF;
2089:
2090: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2091: HZ_POPULATE_BOT_PKG.pop_hz_code_assignments(
2092: p_operation => 'U',
2093: p_code_assignment_id => l_code_assignment_rec.code_assignment_id);
2094: END IF;

Line 2097: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

2093: p_code_assignment_id => l_code_assignment_rec.code_assignment_id);
2094: END IF;
2095: END IF;
2096:
2097: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
2098: -- standard call to get message count and if count is 1, get message info.
2099: FND_MSG_PUB.Count_And_Get(
2100: p_encoded => FND_API.G_FALSE,
2101: p_count => x_msg_count,

Line 2107: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

2103:
2104: EXCEPTION
2105: WHEN FND_API.G_EXC_ERROR THEN
2106: ROLLBACK TO update_code_assignment;
2107: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
2108: x_return_status := FND_API.G_RET_STS_ERROR;
2109: FND_MSG_PUB.Count_And_Get(
2110: p_encoded => FND_API.G_FALSE,
2111: p_count => x_msg_count,

Line 2116: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

2112: p_data => x_msg_data);
2113:
2114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2115: ROLLBACK TO update_code_assignment;
2116: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
2117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2118: FND_MSG_PUB.Count_And_Get(
2119: p_encoded => FND_API.G_FALSE,
2120: p_count => x_msg_count,

Line 2125: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

2121: p_data => x_msg_data);
2122:
2123: WHEN OTHERS THEN
2124: ROLLBACK TO update_code_assignment;
2125: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2127: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2129: FND_MSG_PUB.ADD;

Line 2401: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

2397: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2398:
2399: -- Invoke business event system.
2400: --Bug 4743141.
2401: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2402: HZ_BUSINESS_EVENT_V2PVT.create_class_cat_use_event (
2403: l_class_category_use_rec );
2404: END IF;
2405:

Line 2525: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

2521: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2522:
2523: -- Invoke business event system.
2524: --Bug 4743141.
2525: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2526: HZ_BUSINESS_EVENT_V2PVT.update_class_cat_use_event (
2527: l_class_cat_use_rec,
2528: l_old_class_cat_use_rec );
2529: END IF;

Line 3639: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,

3635: X_ATTRIBUTE14 => l_class_code_rec.attribute14,
3636: X_ATTRIBUTE15 => l_class_code_rec.attribute15,
3637: X_MEANING => l_class_code_rec.meaning,
3638: X_DESCRIPTION => l_class_code_rec.description,
3639: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
3640: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
3641: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3642: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3643: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);

Line 3640: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,

3636: X_ATTRIBUTE15 => l_class_code_rec.attribute15,
3637: X_MEANING => l_class_code_rec.meaning,
3638: X_DESCRIPTION => l_class_code_rec.description,
3639: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
3640: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
3641: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3642: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3643: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
3644:

Line 3641: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

3637: X_MEANING => l_class_code_rec.meaning,
3638: X_DESCRIPTION => l_class_code_rec.description,
3639: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
3640: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
3641: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3642: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3643: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
3644:
3645: set_frozen_flag(l_class_code_rec.type);

Line 3642: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

3638: X_DESCRIPTION => l_class_code_rec.description,
3639: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
3640: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
3641: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3642: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3643: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
3644:
3645: set_frozen_flag(l_class_code_rec.type);
3646:

Line 3643: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);

3639: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
3640: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
3641: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3642: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3643: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
3644:
3645: set_frozen_flag(l_class_code_rec.type);
3646:
3647: -- Bug 5053099: Raise business events.

Line 3650: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

3646:
3647: -- Bug 5053099: Raise business events.
3648: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3649: -- Invoke business event system.
3650: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
3651: HZ_BUSINESS_EVENT_V2PVT.create_class_code_event (
3652: l_class_code_rec );
3653: END IF;
3654: END IF;

Line 3804: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

3800: X_ATTRIBUTE14 => l_class_code_rec.attribute14,
3801: X_ATTRIBUTE15 => l_class_code_rec.attribute15,
3802: X_MEANING => l_class_code_rec.meaning,
3803: X_DESCRIPTION => l_class_code_rec.description,
3804: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3805: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3806: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
3807:
3808: set_frozen_flag(l_class_code_rec.type);

Line 3805: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

3801: X_ATTRIBUTE15 => l_class_code_rec.attribute15,
3802: X_MEANING => l_class_code_rec.meaning,
3803: X_DESCRIPTION => l_class_code_rec.description,
3804: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3805: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3806: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
3807:
3808: set_frozen_flag(l_class_code_rec.type);
3809:

Line 3806: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);

3802: X_MEANING => l_class_code_rec.meaning,
3803: X_DESCRIPTION => l_class_code_rec.description,
3804: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3805: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3806: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
3807:
3808: set_frozen_flag(l_class_code_rec.type);
3809:
3810: -- Bug 5053099: Raise businss events.

Line 3813: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

3809:
3810: -- Bug 5053099: Raise businss events.
3811: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3812: -- Invoke business event system.
3813: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
3814: HZ_BUSINESS_EVENT_V2PVT.update_class_code_event (
3815: p_class_code_rec => l_class_code_rec,
3816: p_old_class_code_rec => NULL );
3817: END IF;