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:

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:
803: --Bug9058492

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:
803: --Bug9058492
804: OPEN c_party_type(p_code_assignment_rec.owner_table_id);

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

1010:
1011: --End of :3216842
1012: */
1013: -- Bug 4693719 : pass NULL if secure data is not updated
1014: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN
1015: l_acs := nvl(p_code_assignment_rec.actual_content_source, 'USER_ENTERED');
1016: ELSE
1017: l_acs := NULL;
1018: END IF;

Line 1190: last_update_date = hz_utility_v2pub.last_update_date,

1186: THEN
1187: -- terminating
1188: UPDATE HZ_PARTIES
1189: SET CATEGORY_CODE = NULL,
1190: last_update_date = hz_utility_v2pub.last_update_date,
1191: last_updated_by = hz_utility_v2pub.last_updated_by,
1192: last_update_login = hz_utility_v2pub.last_update_login
1193: WHERE PARTY_ID = nvl(p_code_assignment_rec.owner_table_id,l_owner_table_id)
1194: AND CATEGORY_CODE = nvl(p_code_assignment_rec.class_code,l_class_code);

Line 1191: last_updated_by = hz_utility_v2pub.last_updated_by,

1187: -- terminating
1188: UPDATE HZ_PARTIES
1189: SET CATEGORY_CODE = NULL,
1190: last_update_date = hz_utility_v2pub.last_update_date,
1191: last_updated_by = hz_utility_v2pub.last_updated_by,
1192: last_update_login = hz_utility_v2pub.last_update_login
1193: WHERE PARTY_ID = nvl(p_code_assignment_rec.owner_table_id,l_owner_table_id)
1194: AND CATEGORY_CODE = nvl(p_code_assignment_rec.class_code,l_class_code);
1195: ELSIF

Line 1192: last_update_login = hz_utility_v2pub.last_update_login

1188: UPDATE HZ_PARTIES
1189: SET CATEGORY_CODE = NULL,
1190: last_update_date = hz_utility_v2pub.last_update_date,
1191: last_updated_by = hz_utility_v2pub.last_updated_by,
1192: last_update_login = hz_utility_v2pub.last_update_login
1193: WHERE PARTY_ID = nvl(p_code_assignment_rec.owner_table_id,l_owner_table_id)
1194: AND CATEGORY_CODE = nvl(p_code_assignment_rec.class_code,l_class_code);
1195: ELSIF
1196: nvl(p_code_assignment_rec.primary_flag,l_primary_flag)='Y'

Line 1208: last_update_date = hz_utility_v2pub.last_update_date,

1204: )
1205: THEN
1206: update hz_parties
1207: set category_code = nvl(p_code_assignment_rec.class_code,l_class_code),
1208: last_update_date = hz_utility_v2pub.last_update_date,
1209: last_updated_by = hz_utility_v2pub.last_updated_by,
1210: last_update_login = hz_utility_v2pub.last_update_login
1211: where party_id = l_owner_table_id;
1212:

Line 1209: last_updated_by = hz_utility_v2pub.last_updated_by,

1205: THEN
1206: update hz_parties
1207: set category_code = nvl(p_code_assignment_rec.class_code,l_class_code),
1208: last_update_date = hz_utility_v2pub.last_update_date,
1209: last_updated_by = hz_utility_v2pub.last_updated_by,
1210: last_update_login = hz_utility_v2pub.last_update_login
1211: where party_id = l_owner_table_id;
1212:
1213: --Bug9058492

Line 1210: last_update_login = hz_utility_v2pub.last_update_login

1206: update hz_parties
1207: set category_code = nvl(p_code_assignment_rec.class_code,l_class_code),
1208: last_update_date = hz_utility_v2pub.last_update_date,
1209: last_updated_by = hz_utility_v2pub.last_updated_by,
1210: last_update_login = hz_utility_v2pub.last_update_login
1211: where party_id = l_owner_table_id;
1212:
1213: --Bug9058492
1214: OPEN c_party_type(nvl(p_code_assignment_rec.owner_table_id,l_owner_table_id));

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

1444: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1445:
1446: -- Invoke business event system.
1447: --Bug 4743141.
1448: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
1449: HZ_BUSINESS_EVENT_V2PVT.create_class_category_event (
1450: l_class_cat_rec );
1451: END IF;
1452:

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

1567: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1568:
1569: -- Invoke business event system.
1570: --Bug 4743141.
1571: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
1572: HZ_BUSINESS_EVENT_V2PVT.update_class_category_event (
1573: l_class_cat_rec,
1574: l_old_class_cat_rec );
1575: END IF;

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

1673: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1674:
1675: -- Invoke business event system.
1676: --Bug 4743141.
1677: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
1678: HZ_BUSINESS_EVENT_V2PVT.create_class_code_rel_event (
1679: l_class_code_rel_rec );
1680: END IF;
1681:

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

1799: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1800:
1801: -- Invoke business event system.
1802: --Bug 4743141.
1803: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
1804: HZ_BUSINESS_EVENT_V2PVT.update_class_code_rel_event (
1805: l_class_code_rel_rec,
1806: l_old_class_code_rel_rec );
1807: END IF;

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

1932: -- assign out NOCOPY param
1933: x_code_assignment_id := l_code_assignment_rec.code_assignment_id;
1934:
1935: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1936: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
1937: -- Invoke business event system.
1938: HZ_BUSINESS_EVENT_V2PVT.create_code_assignment_event (
1939: l_code_assignment_rec );
1940: END IF;

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

1938: HZ_BUSINESS_EVENT_V2PVT.create_code_assignment_event (
1939: l_code_assignment_rec );
1940: END IF;
1941:
1942: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1943: HZ_POPULATE_BOT_PKG.pop_hz_code_assignments(
1944: p_operation => 'I',
1945: p_code_assignment_id => x_code_assignment_id);
1946: END IF;

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

2105: p_object_version_number,
2106: x_return_status);
2107:
2108: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2109: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2110: -- Invoke business event system.
2111: HZ_BUSINESS_EVENT_V2PVT.update_code_assignment_event (
2112: l_code_assignment_rec,
2113: l_old_code_assignment_rec );

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

2112: l_code_assignment_rec,
2113: l_old_code_assignment_rec );
2114: END IF;
2115:
2116: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2117: HZ_POPULATE_BOT_PKG.pop_hz_code_assignments(
2118: p_operation => 'U',
2119: p_code_assignment_id => l_code_assignment_rec.code_assignment_id);
2120: END IF;

Line 2123: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

2119: p_code_assignment_id => l_code_assignment_rec.code_assignment_id);
2120: END IF;
2121: END IF;
2122:
2123: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
2124: -- standard call to get message count and if count is 1, get message info.
2125: FND_MSG_PUB.Count_And_Get(
2126: p_encoded => FND_API.G_FALSE,
2127: p_count => x_msg_count,

Line 2133: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

2129:
2130: EXCEPTION
2131: WHEN FND_API.G_EXC_ERROR THEN
2132: ROLLBACK TO update_code_assignment;
2133: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
2134: x_return_status := FND_API.G_RET_STS_ERROR;
2135: FND_MSG_PUB.Count_And_Get(
2136: p_encoded => FND_API.G_FALSE,
2137: p_count => x_msg_count,

Line 2142: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

2138: p_data => x_msg_data);
2139:
2140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2141: ROLLBACK TO update_code_assignment;
2142: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
2143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2144: FND_MSG_PUB.Count_And_Get(
2145: p_encoded => FND_API.G_FALSE,
2146: p_count => x_msg_count,

Line 2151: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

2147: p_data => x_msg_data);
2148:
2149: WHEN OTHERS THEN
2150: ROLLBACK TO update_code_assignment;
2151: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
2152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2153: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2154: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2155: FND_MSG_PUB.ADD;

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

2423: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2424:
2425: -- Invoke business event system.
2426: --Bug 4743141.
2427: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2428: HZ_BUSINESS_EVENT_V2PVT.create_class_cat_use_event (
2429: l_class_category_use_rec );
2430: END IF;
2431:

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

2547: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2548:
2549: -- Invoke business event system.
2550: --Bug 4743141.
2551: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2552: HZ_BUSINESS_EVENT_V2PVT.update_class_cat_use_event (
2553: l_class_cat_use_rec,
2554: l_old_class_cat_use_rec );
2555: END IF;

Line 3665: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,

3661: X_ATTRIBUTE14 => l_class_code_rec.attribute14,
3662: X_ATTRIBUTE15 => l_class_code_rec.attribute15,
3663: X_MEANING => l_class_code_rec.meaning,
3664: X_DESCRIPTION => l_class_code_rec.description,
3665: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
3666: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
3667: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3668: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3669: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);

Line 3666: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,

3662: X_ATTRIBUTE15 => l_class_code_rec.attribute15,
3663: X_MEANING => l_class_code_rec.meaning,
3664: X_DESCRIPTION => l_class_code_rec.description,
3665: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
3666: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
3667: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3668: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3669: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
3670:

Line 3667: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

3663: X_MEANING => l_class_code_rec.meaning,
3664: X_DESCRIPTION => l_class_code_rec.description,
3665: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
3666: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
3667: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3668: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3669: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
3670:
3671: set_frozen_flag(l_class_code_rec.type);

Line 3668: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

3664: X_DESCRIPTION => l_class_code_rec.description,
3665: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
3666: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
3667: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3668: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3669: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
3670:
3671: set_frozen_flag(l_class_code_rec.type);
3672:

Line 3669: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);

3665: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
3666: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
3667: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3668: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3669: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
3670:
3671: set_frozen_flag(l_class_code_rec.type);
3672:
3673: -- Bug 5053099: Raise business events.

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

3672:
3673: -- Bug 5053099: Raise business events.
3674: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3675: -- Invoke business event system.
3676: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
3677: HZ_BUSINESS_EVENT_V2PVT.create_class_code_event (
3678: l_class_code_rec );
3679: END IF;
3680: END IF;

Line 3830: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

3826: X_ATTRIBUTE14 => l_class_code_rec.attribute14,
3827: X_ATTRIBUTE15 => l_class_code_rec.attribute15,
3828: X_MEANING => l_class_code_rec.meaning,
3829: X_DESCRIPTION => l_class_code_rec.description,
3830: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3831: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3832: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
3833:
3834: set_frozen_flag(l_class_code_rec.type);

Line 3831: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

3827: X_ATTRIBUTE15 => l_class_code_rec.attribute15,
3828: X_MEANING => l_class_code_rec.meaning,
3829: X_DESCRIPTION => l_class_code_rec.description,
3830: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3831: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3832: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
3833:
3834: set_frozen_flag(l_class_code_rec.type);
3835:

Line 3832: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);

3828: X_MEANING => l_class_code_rec.meaning,
3829: X_DESCRIPTION => l_class_code_rec.description,
3830: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3831: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3832: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
3833:
3834: set_frozen_flag(l_class_code_rec.type);
3835:
3836: -- Bug 5053099: Raise businss events.

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

3835:
3836: -- Bug 5053099: Raise businss events.
3837: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3838: -- Invoke business event system.
3839: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
3840: HZ_BUSINESS_EVENT_V2PVT.update_class_code_event (
3841: p_class_code_rec => l_class_code_rec,
3842: p_old_class_code_rec => NULL );
3843: END IF;