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.JTF_LOC_TYPES_PVT dependencies on FND_API

Line 18: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

14: --------------------------------------------------------------------
15: PROCEDURE lock_loc_type
16: (
17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
19:
20: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
21: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
22: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 52: IF FND_API.to_boolean(p_init_msg_list) THEN

48:
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');

Line 58: IF NOT FND_API.compatible_api_call(

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,
61: l_api_name,
62: g_pkg_name

Line 64: RAISE FND_API.g_exc_unexpected_error;

60: p_api_version,
61: l_api_name,
62: g_pkg_name
63: ) THEN
64: RAISE FND_API.g_exc_unexpected_error;
65: END IF;
66:
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:

Line 67: x_return_status := FND_API.G_RET_STS_SUCCESS;

63: ) THEN
64: RAISE FND_API.g_exc_unexpected_error;
65: END IF;
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:

Line 80: RAISE FND_API.g_exc_error;

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;
83:
84: OPEN c_loc_type_tl;

Line 92: RAISE FND_API.g_exc_error;

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;
95:
96: -------------------- finish --------------------------

Line 98: p_encoded => FND_API.g_false,

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: );
102:

Line 108: x_return_status := FND_API.g_ret_sts_error;

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

Line 115: p_encoded => FND_API.g_false,

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: );
119:

Line 120: WHEN FND_API.g_exc_error THEN

116: p_count => x_msg_count,
117: p_data => x_msg_data
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,

Line 121: x_return_status := FND_API.g_ret_sts_error;

117: p_data => x_msg_data
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

Line 123: p_encoded => FND_API.g_false,

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: );
127:

Line 128: WHEN FND_API.g_exc_unexpected_error THEN

124: p_count => x_msg_count,
125: p_data => x_msg_data
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,

Line 129: x_return_status := FND_API.g_ret_sts_unexp_error ;

125: p_data => x_msg_data
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

Line 131: p_encoded => FND_API.g_false,

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: );
135:

Line 137: x_return_status := FND_API.g_ret_sts_unexp_error ;

133: p_data => x_msg_data
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;

Line 144: p_encoded => FND_API.g_false,

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: );
148:

Line 162: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

158: ----------------------------------------------------------------------
159: PROCEDURE update_loc_type
160: (
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
163: p_commit IN VARCHAR2 := FND_API.g_false,
164: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
165:
166: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 163: p_commit IN VARCHAR2 := FND_API.g_false,

159: PROCEDURE update_loc_type
160: (
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
163: p_commit IN VARCHAR2 := FND_API.g_false,
164: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
165:
166: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
167: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 164: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

160: (
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
163: p_commit IN VARCHAR2 := FND_API.g_false,
164: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
165:
166: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
167: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
168: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 186: IF FND_API.to_boolean(p_init_msg_list) THEN

182:
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');

Line 192: IF NOT FND_API.compatible_api_call

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,
195: p_api_version,
196: l_api_name,

Line 200: RAISE FND_API.g_exc_unexpected_error;

196: l_api_name,
197: g_pkg_name
198: )
199: THEN
200: RAISE FND_API.g_exc_unexpected_error;
201: END IF;
202:
203: x_return_status := FND_API.G_RET_STS_SUCCESS;
204:

Line 203: x_return_status := FND_API.G_RET_STS_SUCCESS;

199: THEN
200: RAISE FND_API.g_exc_unexpected_error;
201: END IF;
202:
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');

Line 216: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

212: x_return_status => l_return_status,
213: p_loc_type_rec => p_loc_type_rec
214: );
215:
216: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
217: RAISE FND_API.g_exc_unexpected_error;
218: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
219: RAISE FND_API.g_exc_error;
220: END IF;

Line 217: RAISE FND_API.g_exc_unexpected_error;

213: p_loc_type_rec => p_loc_type_rec
214: );
215:
216: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
217: RAISE FND_API.g_exc_unexpected_error;
218: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
219: RAISE FND_API.g_exc_error;
220: END IF;
221:

Line 218: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

214: );
215:
216: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
217: RAISE FND_API.g_exc_unexpected_error;
218: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
219: RAISE FND_API.g_exc_error;
220: END IF;
221:
222: -------------------------- update --------------------

Line 219: RAISE FND_API.g_exc_error;

215:
216: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
217: RAISE FND_API.g_exc_unexpected_error;
218: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
219: RAISE FND_API.g_exc_error;
220: END IF;
221:
222: -------------------------- update --------------------
223: JTF_Utility_PVT.debug_message(l_full_name ||': update');

Line 240: RAISE FND_API.g_exc_error;

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:
243: UPDATE JTF_LOC_TYPES_TL SET
244: last_update_date = SYSDATE,

Line 259: RAISE FND_API.g_exc_error;

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:
262: -------------------- finish --------------------------
263: IF FND_API.to_boolean(p_commit) THEN

Line 263: IF FND_API.to_boolean(p_commit) THEN

259: RAISE FND_API.g_exc_error;
260: END IF;
261:
262: -------------------- finish --------------------------
263: IF FND_API.to_boolean(p_commit) THEN
264: COMMIT;
265: END IF;
266:
267: FND_MSG_PUB.count_and_get(

Line 268: p_encoded => FND_API.g_false,

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: );
272:

Line 277: WHEN FND_API.g_exc_error THEN

273: JTF_Utility_PVT.debug_message(l_full_name ||': end');
274:
275: EXCEPTION
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,

Line 279: x_return_status := FND_API.g_ret_sts_error;

275: EXCEPTION
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

Line 281: p_encoded => FND_API.g_false,

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: );
285:

Line 286: WHEN FND_API.g_exc_unexpected_error THEN

282: p_count => x_msg_count,
283: p_data => x_msg_data
284: );
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,

Line 288: x_return_status := FND_API.g_ret_sts_unexp_error ;

284: );
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

Line 290: p_encoded => FND_API.g_false,

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: );
294:

Line 297: x_return_status := FND_API.g_ret_sts_unexp_error ;

293: );
294:
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);

Line 305: p_encoded => FND_API.g_false,

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: );
309:

Line 336: x_return_status := FND_API.g_ret_sts_success;

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
339: JTF_Utility_PVT.debug_message(l_full_name || ': check required items');
340:

Line 348: IF x_return_status <> FND_API.g_ret_sts_success THEN

344: p_loc_type_rec => p_loc_type_rec,
345: x_return_status => x_return_status
346: );
347:
348: IF x_return_status <> FND_API.g_ret_sts_success THEN
349: RETURN;
350: END IF;
351:
352: -- check unique key items

Line 361: IF x_return_status <> FND_API.g_ret_sts_success THEN

357: p_loc_type_rec => p_loc_type_rec,
358: x_return_status => x_return_status
359: );
360:
361: IF x_return_status <> FND_API.g_ret_sts_success THEN
362: RETURN;
363: END IF;
364:
365: END check_items;

Line 385: x_return_status := FND_API.g_ret_sts_success;

381: IS
382:
383: BEGIN
384:
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

Line 394: x_return_status := FND_API.g_ret_sts_error;

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;
396:
397: END IF;
398:

Line 406: x_return_status := FND_API.g_ret_sts_error;

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;
408: END IF;
409:
410: -- check location_type_code

Line 417: x_return_status := FND_API.g_ret_sts_error;

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;
419:
420: END IF;
421:

Line 429: x_return_status := FND_API.g_ret_sts_error;

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;
431:
432: END IF;
433:

Line 456: x_return_status := FND_API.g_ret_sts_success;

452: l_uk_flag VARCHAR2(1);
453:
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',

Line 466: IF l_uk_flag = FND_API.g_false THEN

462: || ' AND location_type_name = ''' || p_loc_type_rec.location_type_name
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;

Line 472: x_return_status := FND_API.g_ret_sts_error;

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;
474: END IF;
475:
476: END check_loc_type_uk_items;