APPS.JTF_LOC_TYPES_PVT dependencies on JTF_UTILITY_PVT

Line 56: JTF_Utility_PVT.debug_message(l_full_name||': start');

52: IF FND_API.to_boolean(p_init_msg_list) THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55:
56: JTF_Utility_PVT.debug_message(l_full_name||': start');
57:
58: IF NOT FND_API.compatible_api_call(
59: l_api_version,
60: p_api_version,

Line 70: JTF_Utility_PVT.debug_message(l_full_name||': lock');

66:
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: ------------------------ lock -------------------------
70: JTF_Utility_PVT.debug_message(l_full_name||': lock');
71:
72: OPEN c_loc_type_b;
73: FETCH c_loc_type_b INTO l_loc_type_id;
74: IF (c_loc_type_b%NOTFOUND) THEN

Line 103: JTF_Utility_PVT.debug_message(l_full_name ||': end');

99: p_count => x_msg_count,
100: p_data => x_msg_data
101: );
102:
103: JTF_Utility_PVT.debug_message(l_full_name ||': end');
104:
105: EXCEPTION
106:
107: WHEN JTF_Utility_PVT.resource_locked THEN

Line 107: WHEN JTF_Utility_PVT.resource_locked THEN

103: JTF_Utility_PVT.debug_message(l_full_name ||': end');
104:
105: EXCEPTION
106:
107: WHEN JTF_Utility_PVT.resource_locked THEN
108: x_return_status := FND_API.g_ret_sts_error;
109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
110: FND_MESSAGE.set_name('JTF', 'JTF_API_RESOURCE_LOCKED');
111: FND_MSG_PUB.add;

Line 190: JTF_Utility_PVT.debug_message(l_full_name||': start');

186: IF FND_API.to_boolean(p_init_msg_list) THEN
187: FND_MSG_PUB.initialize;
188: END IF;
189:
190: JTF_Utility_PVT.debug_message(l_full_name||': start');
191:
192: IF NOT FND_API.compatible_api_call
193: (
194: l_api_version,

Line 207: JTF_Utility_PVT.debug_message(l_full_name || ': check items');

203: x_return_status := FND_API.G_RET_STS_SUCCESS;
204:
205: ----------------------- validate ----------------------
206: -- validate
207: JTF_Utility_PVT.debug_message(l_full_name || ': check items');
208:
209: check_items
210: (
211: p_validation_mode => JTF_PLSQL_API.g_update,

Line 223: JTF_Utility_PVT.debug_message(l_full_name ||': update');

219: RAISE FND_API.g_exc_error;
220: END IF;
221:
222: -------------------------- update --------------------
223: JTF_Utility_PVT.debug_message(l_full_name ||': update');
224:
225: UPDATE JTF_LOC_TYPES_B SET
226: last_update_date = SYSDATE,
227: last_updated_by = FND_GLOBAL.user_id,

Line 273: JTF_Utility_PVT.debug_message(l_full_name ||': end');

269: p_count => x_msg_count,
270: p_data => x_msg_data
271: );
272:
273: JTF_Utility_PVT.debug_message(l_full_name ||': end');
274:
275: EXCEPTION
276:
277: WHEN FND_API.g_exc_error THEN

Line 334: JTF_Utility_PVT.debug_message(l_full_name || ': start');

330: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
331:
332: BEGIN
333: -- initialize
334: JTF_Utility_PVT.debug_message(l_full_name || ': start');
335:
336: x_return_status := FND_API.g_ret_sts_success;
337:
338: -- check required items

Line 339: JTF_Utility_PVT.debug_message(l_full_name || ': check required items');

335:
336: x_return_status := FND_API.g_ret_sts_success;
337:
338: -- check required items
339: JTF_Utility_PVT.debug_message(l_full_name || ': check required items');
340:
341: check_loc_type_req_items
342: (
343: p_validation_mode => p_validation_mode,

Line 353: JTF_Utility_PVT.debug_message(l_full_name || ': check uk items');

349: RETURN;
350: END IF;
351:
352: -- check unique key items
353: JTF_Utility_PVT.debug_message(l_full_name || ': check uk items');
354: check_loc_type_uk_items
355: (
356: p_validation_mode => p_validation_mode,
357: p_loc_type_rec => p_loc_type_rec,

Line 458: l_uk_flag := JTF_Utility_PVT.check_uniqueness

454: BEGIN
455:
456: x_return_status := FND_API.g_ret_sts_success;
457:
458: l_uk_flag := JTF_Utility_PVT.check_uniqueness
459: (
460: 'JTF_LOC_TYPES_TL',
461: 'location_type_id <> ' || p_loc_type_rec.location_type_id
462: || ' AND location_type_name = ''' || p_loc_type_rec.location_type_name