DBA Data[Home] [Help]

APPS.HZ_BES_BO_DEFINITION_PVT dependencies on HZ_UTILITY_V2PUB

Line 56: hz_utility_v2pub.debug(p_message=>'update_bod (+)',

52: SAVEPOINT update_bod_pvt;
53:
54: -- Debug info.
55: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
56: hz_utility_v2pub.debug(p_message=>'update_bod (+)',
57: p_prefix=>l_debug_prefix,
58: p_msg_level=>fnd_log.level_procedure);
59: END IF;
60:

Line 119: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

115: IF NOT(l_umf = p_user_mandated_flag) THEN
116: UPDATE HZ_BUS_OBJ_DEFINITIONS
117: SET object_version_number = p_object_version_number,
118: user_mandated_flag = p_user_mandated_flag,
119: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
120: last_updated_by = HZ_UTILITY_V2PUB.last_updated_by,
121: last_update_login = HZ_UTILITY_V2PUB.last_update_login
122: WHERE business_object_code = p_business_object_code
123: AND entity_name = p_entity_name

Line 120: last_updated_by = HZ_UTILITY_V2PUB.last_updated_by,

116: UPDATE HZ_BUS_OBJ_DEFINITIONS
117: SET object_version_number = p_object_version_number,
118: user_mandated_flag = p_user_mandated_flag,
119: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
120: last_updated_by = HZ_UTILITY_V2PUB.last_updated_by,
121: last_update_login = HZ_UTILITY_V2PUB.last_update_login
122: WHERE business_object_code = p_business_object_code
123: AND entity_name = p_entity_name
124: AND nvl(child_bo_code, 'X') = nvl(p_child_bo_code, 'X');

Line 121: last_update_login = HZ_UTILITY_V2PUB.last_update_login

117: SET object_version_number = p_object_version_number,
118: user_mandated_flag = p_user_mandated_flag,
119: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
120: last_updated_by = HZ_UTILITY_V2PUB.last_updated_by,
121: last_update_login = HZ_UTILITY_V2PUB.last_update_login
122: WHERE business_object_code = p_business_object_code
123: AND entity_name = p_entity_name
124: AND nvl(child_bo_code, 'X') = nvl(p_child_bo_code, 'X');
125:

Line 145: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

141:
142: IF(l_bo_found) THEN
143: UPDATE HZ_BUS_OBJ_DEFINITIONS
144: SET bo_version_number = nvl(bo_version_number,1) + 1,
145: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
146: last_updated_by = HZ_UTILITY_V2PUB.last_updated_by,
147: last_update_login = HZ_UTILITY_V2PUB.last_update_login
148: WHERE business_object_code = l_top_bo
149: AND root_node_flag = 'Y'

Line 146: last_updated_by = HZ_UTILITY_V2PUB.last_updated_by,

142: IF(l_bo_found) THEN
143: UPDATE HZ_BUS_OBJ_DEFINITIONS
144: SET bo_version_number = nvl(bo_version_number,1) + 1,
145: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
146: last_updated_by = HZ_UTILITY_V2PUB.last_updated_by,
147: last_update_login = HZ_UTILITY_V2PUB.last_update_login
148: WHERE business_object_code = l_top_bo
149: AND root_node_flag = 'Y'
150: AND child_bo_code IS NULL;

Line 147: last_update_login = HZ_UTILITY_V2PUB.last_update_login

143: UPDATE HZ_BUS_OBJ_DEFINITIONS
144: SET bo_version_number = nvl(bo_version_number,1) + 1,
145: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
146: last_updated_by = HZ_UTILITY_V2PUB.last_updated_by,
147: last_update_login = HZ_UTILITY_V2PUB.last_update_login
148: WHERE business_object_code = l_top_bo
149: AND root_node_flag = 'Y'
150: AND child_bo_code IS NULL;
151: END IF;

Line 175: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

171: p_data => x_msg_data);
172:
173: -- Debug info.
174: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
175: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
176: p_msg_data=>x_msg_data,
177: p_msg_type=>'WARNING',
178: p_msg_level=>fnd_log.level_exception);
179: END IF;

Line 182: hz_utility_v2pub.debug(p_message=>'update_bod (-)',

178: p_msg_level=>fnd_log.level_exception);
179: END IF;
180:
181: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
182: hz_utility_v2pub.debug(p_message=>'update_bod (-)',
183: p_prefix=>l_debug_prefix,
184: p_msg_level=>fnd_log.level_procedure);
185: END IF;
186:

Line 198: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

194: p_data => x_msg_data);
195:
196: -- Debug info.
197: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
198: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
199: p_msg_data=>x_msg_data,
200: p_msg_type=>'ERROR',
201: p_msg_level=>fnd_log.level_error);
202: END IF;

Line 205: hz_utility_v2pub.debug(p_message=>'update_bod (-)',

201: p_msg_level=>fnd_log.level_error);
202: END IF;
203:
204: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
205: hz_utility_v2pub.debug(p_message=>'update_bod (-)',
206: p_prefix=>l_debug_prefix,
207: p_msg_level=>fnd_log.level_procedure);
208: END IF;
209:

Line 220: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

216: p_data => x_msg_data);
217:
218: -- Debug info.
219: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
220: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
221: p_msg_data=>x_msg_data,
222: p_msg_type=>'UNEXPECTED ERROR',
223: p_msg_level=>fnd_log.level_error);
224: END IF;

Line 227: hz_utility_v2pub.debug(p_message=>'update_bod (-)',

223: p_msg_level=>fnd_log.level_error);
224: END IF;
225:
226: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
227: hz_utility_v2pub.debug(p_message=>'update_bod (-)',
228: p_prefix=>l_debug_prefix,
229: p_msg_level=>fnd_log.level_procedure);
230: END IF;
231:

Line 245: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

241: p_data => x_msg_data);
242:
243: -- Debug info.
244: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
245: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
246: p_msg_data=>x_msg_data,
247: p_msg_type=>'SQL ERROR',
248: p_msg_level=>fnd_log.level_error);
249: END IF;

Line 252: hz_utility_v2pub.debug(p_message=>'update_bod (-)',

248: p_msg_level=>fnd_log.level_error);
249: END IF;
250:
251: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
252: hz_utility_v2pub.debug(p_message=>'update_bod (-)',
253: p_prefix=>l_debug_prefix,
254: p_msg_level=>fnd_log.level_procedure);
255: END IF;
256: END update_bod;