APPS.JTF_LOC_TYPES_PVT dependencies on FND_MSG_PUB

Line 53: FND_MSG_PUB.initialize;

49: BEGIN
50:
51: -------------------- initialize ------------------------
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:

Line 76: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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
75: CLOSE c_loc_type_b;
76: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
77: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
78: FND_MSG_PUB.add;
79: END IF;
80: RAISE FND_API.g_exc_error;

Line 78: FND_MSG_PUB.add;

74: IF (c_loc_type_b%NOTFOUND) THEN
75: CLOSE c_loc_type_b;
76: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
77: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
78: FND_MSG_PUB.add;
79: END IF;
80: RAISE FND_API.g_exc_error;
81: END IF;
82: CLOSE c_loc_type_b;

Line 88: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

84: OPEN c_loc_type_tl;
85: FETCH c_loc_type_tl INTO l_loc_type_id;
86: IF (c_loc_type_tl%NOTFOUND) THEN
87: CLOSE c_loc_type_tl;
88: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
89: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
90: FND_MSG_PUB.add;
91: END IF;
92: RAISE FND_API.g_exc_error;

Line 90: FND_MSG_PUB.add;

86: IF (c_loc_type_tl%NOTFOUND) THEN
87: CLOSE c_loc_type_tl;
88: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
89: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
90: FND_MSG_PUB.add;
91: END IF;
92: RAISE FND_API.g_exc_error;
93: END IF;
94: CLOSE c_loc_type_tl;

Line 97: FND_MSG_PUB.count_and_get(

93: END IF;
94: CLOSE c_loc_type_tl;
95:
96: -------------------- finish --------------------------
97: FND_MSG_PUB.count_and_get(
98: p_encoded => FND_API.g_false,
99: p_count => x_msg_count,
100: p_data => x_msg_data
101: );

Line 109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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;
112: END IF;
113:

Line 111: FND_MSG_PUB.add;

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;
112: END IF;
113:
114: FND_MSG_PUB.count_and_get(
115: p_encoded => FND_API.g_false,

Line 114: FND_MSG_PUB.count_and_get(

110: FND_MESSAGE.set_name('JTF', 'JTF_API_RESOURCE_LOCKED');
111: FND_MSG_PUB.add;
112: END IF;
113:
114: FND_MSG_PUB.count_and_get(
115: p_encoded => FND_API.g_false,
116: p_count => x_msg_count,
117: p_data => x_msg_data
118: );

Line 122: FND_MSG_PUB.count_and_get(

118: );
119:
120: WHEN FND_API.g_exc_error THEN
121: x_return_status := FND_API.g_ret_sts_error;
122: FND_MSG_PUB.count_and_get(
123: p_encoded => FND_API.g_false,
124: p_count => x_msg_count,
125: p_data => x_msg_data
126: );

Line 130: FND_MSG_PUB.count_and_get(

126: );
127:
128: WHEN FND_API.g_exc_unexpected_error THEN
129: x_return_status := FND_API.g_ret_sts_unexp_error ;
130: FND_MSG_PUB.count_and_get(
131: p_encoded => FND_API.g_false,
132: p_count => x_msg_count,
133: p_data => x_msg_data
134: );

Line 138: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

134: );
135:
136: WHEN OTHERS THEN
137: x_return_status := FND_API.g_ret_sts_unexp_error ;
138: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
139: THEN
140: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
141: END IF;
142:

Line 140: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

136: WHEN OTHERS THEN
137: x_return_status := FND_API.g_ret_sts_unexp_error ;
138: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
139: THEN
140: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
141: END IF;
142:
143: FND_MSG_PUB.count_and_get(
144: p_encoded => FND_API.g_false,

Line 143: FND_MSG_PUB.count_and_get(

139: THEN
140: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
141: END IF;
142:
143: FND_MSG_PUB.count_and_get(
144: p_encoded => FND_API.g_false,
145: p_count => x_msg_count,
146: p_data => x_msg_data
147: );

Line 187: FND_MSG_PUB.initialize;

183: -------------------- initialize -------------------------
184: SAVEPOINT update_loc_type;
185:
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:

Line 236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

232: WHERE location_type_id = p_loc_type_rec.location_type_id
233: AND object_version_number = p_loc_type_rec.object_version_number;
234:
235: IF (SQL%NOTFOUND) THEN
236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
237: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
238: FND_MSG_PUB.add;
239: END IF;
240: RAISE FND_API.g_exc_error;

Line 238: FND_MSG_PUB.add;

234:
235: IF (SQL%NOTFOUND) THEN
236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
237: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
238: FND_MSG_PUB.add;
239: END IF;
240: RAISE FND_API.g_exc_error;
241: END IF;
242:

Line 255: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

251: WHERE location_type_id = p_loc_type_rec.location_type_id
252: AND USERENV('LANG') IN (language, source_lang);
253:
254: IF (SQL%NOTFOUND) THEN
255: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
256: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
257: FND_MSG_PUB.add;
258: END IF;
259: RAISE FND_API.g_exc_error;

Line 257: FND_MSG_PUB.add;

253:
254: IF (SQL%NOTFOUND) THEN
255: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
256: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
257: FND_MSG_PUB.add;
258: END IF;
259: RAISE FND_API.g_exc_error;
260: END IF;
261:

Line 267: FND_MSG_PUB.count_and_get(

263: IF FND_API.to_boolean(p_commit) THEN
264: COMMIT;
265: END IF;
266:
267: FND_MSG_PUB.count_and_get(
268: p_encoded => FND_API.g_false,
269: p_count => x_msg_count,
270: p_data => x_msg_data
271: );

Line 280: FND_MSG_PUB.count_and_get(

276:
277: WHEN FND_API.g_exc_error THEN
278: ROLLBACK TO update_loc_type;
279: x_return_status := FND_API.g_ret_sts_error;
280: FND_MSG_PUB.count_and_get(
281: p_encoded => FND_API.g_false,
282: p_count => x_msg_count,
283: p_data => x_msg_data
284: );

Line 289: FND_MSG_PUB.count_and_get(

285:
286: WHEN FND_API.g_exc_unexpected_error THEN
287: ROLLBACK TO update_loc_type;
288: x_return_status := FND_API.g_ret_sts_unexp_error ;
289: FND_MSG_PUB.count_and_get(
290: p_encoded => FND_API.g_false,
291: p_count => x_msg_count,
292: p_data => x_msg_data
293: );

Line 299: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

295: WHEN OTHERS THEN
296: ROLLBACK TO update_loc_type;
297: x_return_status := FND_API.g_ret_sts_unexp_error ;
298:
299: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
300: THEN
301: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
302: END IF;
303:

Line 301: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

297: x_return_status := FND_API.g_ret_sts_unexp_error ;
298:
299: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
300: THEN
301: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
302: END IF;
303:
304: FND_MSG_PUB.count_and_get(
305: p_encoded => FND_API.g_false,

Line 304: FND_MSG_PUB.count_and_get(

300: THEN
301: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
302: END IF;
303:
304: FND_MSG_PUB.count_and_get(
305: p_encoded => FND_API.g_false,
306: p_count => x_msg_count,
307: p_data => x_msg_data
308: );

Line 389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

385: x_return_status := FND_API.g_ret_sts_success;
386:
387: -- check location_type_id
388: IF p_loc_type_rec.location_type_id IS NULL THEN
389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
390: FND_MESSAGE.set_name('JTF', 'JTF_LOC_TYPE_NO_TYPE_ID');
391: FND_MSG_PUB.add;
392: END IF;
393:

Line 391: FND_MSG_PUB.add;

387: -- check location_type_id
388: IF p_loc_type_rec.location_type_id IS NULL THEN
389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
390: FND_MESSAGE.set_name('JTF', 'JTF_LOC_TYPE_NO_TYPE_ID');
391: FND_MSG_PUB.add;
392: END IF;
393:
394: x_return_status := FND_API.g_ret_sts_error;
395: RETURN;

Line 401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

397: END IF;
398:
399: -- check object_version_number
400: IF p_loc_type_rec.object_version_number IS NULL THEN
401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
402: FND_MESSAGE.set_name('JTF', 'JTF_API_NO_OBJ_VER_NUM');
403: FND_MSG_PUB.add;
404: END IF;
405:

Line 403: FND_MSG_PUB.add;

399: -- check object_version_number
400: IF p_loc_type_rec.object_version_number IS NULL THEN
401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
402: FND_MESSAGE.set_name('JTF', 'JTF_API_NO_OBJ_VER_NUM');
403: FND_MSG_PUB.add;
404: END IF;
405:
406: x_return_status := FND_API.g_ret_sts_error;
407: RETURN;

Line 412: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

408: END IF;
409:
410: -- check location_type_code
411: IF p_loc_type_rec.location_type_code IS NULL THEN
412: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
413: FND_MESSAGE.set_name('JTF', 'JTF_LOC_TYPE_NO_TYPE_CODE');
414: FND_MSG_PUB.add;
415: END IF;
416:

Line 414: FND_MSG_PUB.add;

410: -- check location_type_code
411: IF p_loc_type_rec.location_type_code IS NULL THEN
412: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
413: FND_MESSAGE.set_name('JTF', 'JTF_LOC_TYPE_NO_TYPE_CODE');
414: FND_MSG_PUB.add;
415: END IF;
416:
417: x_return_status := FND_API.g_ret_sts_error;
418: RETURN;

Line 424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

420: END IF;
421:
422: -- check location_type_name
423: IF p_loc_type_rec.location_type_name IS NULL THEN
424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
425: FND_MESSAGE.set_name('JTF', 'JTF_LOC_TYPE_NO_TYPE_NAME');
426: FND_MSG_PUB.add;
427: END IF;
428:

Line 426: FND_MSG_PUB.add;

422: -- check location_type_name
423: IF p_loc_type_rec.location_type_name IS NULL THEN
424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
425: FND_MESSAGE.set_name('JTF', 'JTF_LOC_TYPE_NO_TYPE_NAME');
426: FND_MSG_PUB.add;
427: END IF;
428:
429: x_return_status := FND_API.g_ret_sts_error;
430: RETURN;

Line 467: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

463: || ''' AND language = ''' || USERENV('LANG') ||''''
464: );
465:
466: IF l_uk_flag = FND_API.g_false THEN
467: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
468: FND_MESSAGE.set_name('JTF', 'JTF_LOC_TYPE_DUP_NAME_LANG');
469: FND_MSG_PUB.add;
470: END IF;
471:

Line 469: FND_MSG_PUB.add;

465:
466: IF l_uk_flag = FND_API.g_false THEN
467: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
468: FND_MESSAGE.set_name('JTF', 'JTF_LOC_TYPE_DUP_NAME_LANG');
469: FND_MSG_PUB.add;
470: END IF;
471:
472: x_return_status := FND_API.g_ret_sts_error;
473: RETURN;