DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on HZ_UTILITY_V2PUB

Line 186: X_CREATION_DATE => HZ_UTILITY_V2PUB.creation_date,

182: X_OBJECT_ID => l_object_id,
183: X_PREDICATE => l_predicate,
184: X_DISPLAY_NAME => l_geography_type,
185: X_DESCRIPTION => l_geography_type,
186: X_CREATION_DATE => HZ_UTILITY_V2PUB.creation_date,
187: X_CREATED_BY => HZ_UTILITY_V2PUB.created_by,
188: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.last_update_date,
189: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.last_updated_by,
190: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.last_update_login

Line 187: X_CREATED_BY => HZ_UTILITY_V2PUB.created_by,

183: X_PREDICATE => l_predicate,
184: X_DISPLAY_NAME => l_geography_type,
185: X_DESCRIPTION => l_geography_type,
186: X_CREATION_DATE => HZ_UTILITY_V2PUB.creation_date,
187: X_CREATED_BY => HZ_UTILITY_V2PUB.created_by,
188: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.last_update_date,
189: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.last_updated_by,
190: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.last_update_login
191: ) ;

Line 188: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.last_update_date,

184: X_DISPLAY_NAME => l_geography_type,
185: X_DESCRIPTION => l_geography_type,
186: X_CREATION_DATE => HZ_UTILITY_V2PUB.creation_date,
187: X_CREATED_BY => HZ_UTILITY_V2PUB.created_by,
188: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.last_update_date,
189: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.last_updated_by,
190: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.last_update_login
191: ) ;
192:

Line 189: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.last_updated_by,

185: X_DESCRIPTION => l_geography_type,
186: X_CREATION_DATE => HZ_UTILITY_V2PUB.creation_date,
187: X_CREATED_BY => HZ_UTILITY_V2PUB.created_by,
188: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.last_update_date,
189: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.last_updated_by,
190: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.last_update_login
191: ) ;
192:
193:

Line 190: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.last_update_login

186: X_CREATION_DATE => HZ_UTILITY_V2PUB.creation_date,
187: X_CREATED_BY => HZ_UTILITY_V2PUB.created_by,
188: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.last_update_date,
189: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.last_updated_by,
190: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.last_update_login
191: ) ;
192:
193:
194: END IF;

Line 336: hz_utility_v2pub.validate_mandatory(

332: FND_MSG_PUB.ADD;
333: RAISE FND_API.G_EXC_ERROR;
334: END;
335:
336: hz_utility_v2pub.validate_mandatory(
337: p_create_update_flag => 'U',
338: p_column => 'object_version_number',
339: p_column_value => p_object_version_number,
340: x_return_status => x_return_status

Line 633: hz_utility_v2pub.validate_mandatory(

629: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
630: RAISE FND_API.G_EXC_ERROR;
631: END IF;
632:
633: hz_utility_v2pub.validate_mandatory(
634: p_create_update_flag => 'U',
635: p_column => 'object_version_number',
636: p_column_value => p_object_version_number,
637: x_return_status => x_return_status

Line 1325: X_CREATION_DATE => HZ_UTILITY_V2PUB.creation_date,

1321: X_OBJECT_ID => l_object_id,
1322: X_PREDICATE => l_predicate,
1323: X_DISPLAY_NAME => p_zone_type_rec.geography_type,
1324: X_DESCRIPTION => p_zone_type_rec.geography_type,
1325: X_CREATION_DATE => HZ_UTILITY_V2PUB.creation_date,
1326: X_CREATED_BY => HZ_UTILITY_V2PUB.created_by,
1327: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.last_update_date,
1328: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.last_updated_by,
1329: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.last_update_login

Line 1326: X_CREATED_BY => HZ_UTILITY_V2PUB.created_by,

1322: X_PREDICATE => l_predicate,
1323: X_DISPLAY_NAME => p_zone_type_rec.geography_type,
1324: X_DESCRIPTION => p_zone_type_rec.geography_type,
1325: X_CREATION_DATE => HZ_UTILITY_V2PUB.creation_date,
1326: X_CREATED_BY => HZ_UTILITY_V2PUB.created_by,
1327: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.last_update_date,
1328: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.last_updated_by,
1329: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.last_update_login
1330: ) ;

Line 1327: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.last_update_date,

1323: X_DISPLAY_NAME => p_zone_type_rec.geography_type,
1324: X_DESCRIPTION => p_zone_type_rec.geography_type,
1325: X_CREATION_DATE => HZ_UTILITY_V2PUB.creation_date,
1326: X_CREATED_BY => HZ_UTILITY_V2PUB.created_by,
1327: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.last_update_date,
1328: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.last_updated_by,
1329: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.last_update_login
1330: ) ;
1331:

Line 1328: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.last_updated_by,

1324: X_DESCRIPTION => p_zone_type_rec.geography_type,
1325: X_CREATION_DATE => HZ_UTILITY_V2PUB.creation_date,
1326: X_CREATED_BY => HZ_UTILITY_V2PUB.created_by,
1327: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.last_update_date,
1328: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.last_updated_by,
1329: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.last_update_login
1330: ) ;
1331:
1332: END IF;

Line 1329: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.last_update_login

1325: X_CREATION_DATE => HZ_UTILITY_V2PUB.creation_date,
1326: X_CREATED_BY => HZ_UTILITY_V2PUB.created_by,
1327: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.last_update_date,
1328: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.last_updated_by,
1329: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.last_update_login
1330: ) ;
1331:
1332: END IF;
1333: END;

Line 1470: hz_utility_v2pub.validate_mandatory(

1466:
1467:
1468: BEGIN
1469:
1470: hz_utility_v2pub.validate_mandatory(
1471: p_create_update_flag => 'U',
1472: p_column => 'object_version_number',
1473: p_column_value => p_object_version_number,
1474: x_return_status => x_return_status

Line 1780: HZ_UTILITY_V2PUB.find_index_name(p_index_name);

1776:
1777: WHEN DUP_VAL_ON_INDEX THEN
1778: ROLLBACK TO create_geography_type;
1779: x_return_status := FND_API.G_RET_STS_ERROR;
1780: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
1781: IF p_index_name = 'HZ_GEOGRAPHY_TYPES_B_U1' THEN
1782: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1783: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');
1784: FND_MSG_PUB.ADD;

Line 2100: HZ_UTILITY_V2PUB.find_index_name(p_index_name);

2096: p_data => x_msg_data);
2097:
2098: WHEN DUP_VAL_ON_INDEX THEN
2099: ROLLBACK TO create_geo_structure;
2100: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
2101: IF p_index_name = 'HZ_GEO_STRUCTURE_LEVELS_U1' THEN
2102: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2103: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,geography_type and parent_geography_type');
2104: FND_MSG_PUB.ADD;

Line 2431: HZ_UTILITY_V2PUB.find_index_name(p_index_name);

2427:
2428: WHEN DUP_VAL_ON_INDEX THEN
2429: ROLLBACK TO create_zone_type;
2430: x_return_status := FND_API.G_RET_STS_ERROR;
2431: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
2432: IF p_index_name = 'HZ_GEOGRAPHY_TYPES_B_U1' THEN
2433: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2434: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');
2435: FND_MSG_PUB.ADD;