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_HIERARCHIES_PVT dependencies on FND_API

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

11: -------------------------------------------------------------------------------
12: PROCEDURE create_hierarchy
13: (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
16: p_commit IN VARCHAR2 := FND_API.g_false,
17: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
18:
19: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

12: PROCEDURE create_hierarchy
13: (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
16: p_commit IN VARCHAR2 := FND_API.g_false,
17: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
18:
19: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

13: (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
16: p_commit IN VARCHAR2 := FND_API.g_false,
17: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
18:
19: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
21: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 48: IF FND_API.to_boolean(p_init_msg_list) THEN

44: BEGIN
45: -- initialize
46: SAVEPOINT create_hierarchy;
47:
48: IF FND_API.to_boolean(p_init_msg_list) THEN
49: FND_MSG_PUB.initialize;
50: END IF;
51:
52: JTF_Utility_PVT.debug_message(l_full_name || ': start');

Line 54: IF NOT FND_API.compatible_api_call

50: END IF;
51:
52: JTF_Utility_PVT.debug_message(l_full_name || ': start');
53:
54: IF NOT FND_API.compatible_api_call
55: (
56: l_api_version,
57: p_api_version,
58: l_api_name,

Line 62: RAISE FND_API.g_exc_unexpected_error;

58: l_api_name,
59: g_pkg_name
60: )
61: THEN
62: RAISE FND_API.g_exc_unexpected_error;
63: END IF;
64:
65: x_return_status := FND_API.g_ret_sts_success;
66:

Line 65: x_return_status := FND_API.g_ret_sts_success;

61: THEN
62: RAISE FND_API.g_exc_unexpected_error;
63: END IF;
64:
65: x_return_status := FND_API.g_ret_sts_success;
66:
67: -- validate
68: -- IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
69: JTF_Utility_PVT.debug_message(l_full_name || ': validate');

Line 82: IF l_return_status = FND_API.g_ret_sts_error THEN

78: x_msg_data => x_msg_data,
79: p_loc_hier_rec => l_loc_hier_rec
80: );
81:
82: IF l_return_status = FND_API.g_ret_sts_error THEN
83: RAISE FND_API.g_exc_error;
84: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
85: RAISE FND_API.g_exc_unexpected_error;
86: END IF;

Line 83: RAISE FND_API.g_exc_error;

79: p_loc_hier_rec => l_loc_hier_rec
80: );
81:
82: IF l_return_status = FND_API.g_ret_sts_error THEN
83: RAISE FND_API.g_exc_error;
84: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
85: RAISE FND_API.g_exc_unexpected_error;
86: END IF;
87: --END IF;

Line 84: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

80: );
81:
82: IF l_return_status = FND_API.g_ret_sts_error THEN
83: RAISE FND_API.g_exc_error;
84: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
85: RAISE FND_API.g_exc_unexpected_error;
86: END IF;
87: --END IF;
88:

Line 85: RAISE FND_API.g_exc_unexpected_error;

81:
82: IF l_return_status = FND_API.g_ret_sts_error THEN
83: RAISE FND_API.g_exc_error;
84: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
85: RAISE FND_API.g_exc_unexpected_error;
86: END IF;
87: --END IF;
88:
89: -- generate an unique ID if it is not parsed in

Line 177: IF FND_API.to_boolean(p_commit) THEN

173:
174: -- finish
175: x_hier_id := l_loc_hier_rec.location_hierarchy_id;
176:
177: IF FND_API.to_boolean(p_commit) THEN
178: COMMIT;
179: END IF;
180:
181: FND_MSG_PUB.count_and_get

Line 183: p_encoded => FND_API.g_false,

179: END IF;
180:
181: FND_MSG_PUB.count_and_get
182: (
183: p_encoded => FND_API.g_false,
184: p_count => x_msg_count,
185: p_data => x_msg_data
186: );
187:

Line 192: WHEN FND_API.g_exc_error THEN

188: JTF_Utility_PVT.debug_message(l_full_name||': end');
189:
190: EXCEPTION
191:
192: WHEN FND_API.g_exc_error THEN
193: ROLLBACK TO create_hierarchy;
194: x_return_status := FND_API.g_ret_sts_error;
195: FND_MSG_PUB.count_and_get
196: (

Line 194: x_return_status := FND_API.g_ret_sts_error;

190: EXCEPTION
191:
192: WHEN FND_API.g_exc_error THEN
193: ROLLBACK TO create_hierarchy;
194: x_return_status := FND_API.g_ret_sts_error;
195: FND_MSG_PUB.count_and_get
196: (
197: p_encoded => FND_API.g_false,
198: p_count => x_msg_count,

Line 197: p_encoded => FND_API.g_false,

193: ROLLBACK TO create_hierarchy;
194: x_return_status := FND_API.g_ret_sts_error;
195: FND_MSG_PUB.count_and_get
196: (
197: p_encoded => FND_API.g_false,
198: p_count => x_msg_count,
199: p_data => x_msg_data
200: );
201:

Line 202: WHEN FND_API.g_exc_unexpected_error THEN

198: p_count => x_msg_count,
199: p_data => x_msg_data
200: );
201:
202: WHEN FND_API.g_exc_unexpected_error THEN
203: ROLLBACK TO create_hierarchy;
204: x_return_status := FND_API.g_ret_sts_unexp_error;
205: FND_MSG_PUB.count_and_get
206: (

Line 204: x_return_status := FND_API.g_ret_sts_unexp_error;

200: );
201:
202: WHEN FND_API.g_exc_unexpected_error THEN
203: ROLLBACK TO create_hierarchy;
204: x_return_status := FND_API.g_ret_sts_unexp_error;
205: FND_MSG_PUB.count_and_get
206: (
207: p_encoded => FND_API.g_false,
208: p_count => x_msg_count,

Line 207: p_encoded => FND_API.g_false,

203: ROLLBACK TO create_hierarchy;
204: x_return_status := FND_API.g_ret_sts_unexp_error;
205: FND_MSG_PUB.count_and_get
206: (
207: p_encoded => FND_API.g_false,
208: p_count => x_msg_count,
209: p_data => x_msg_data
210: );
211:

Line 214: x_return_status :=FND_API.g_ret_sts_unexp_error;

210: );
211:
212: WHEN OTHERS THEN
213: ROLLBACK TO create_hierarchy;
214: x_return_status :=FND_API.g_ret_sts_unexp_error;
215: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
216: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
217: END IF;
218: FND_MSG_PUB.count_and_get

Line 220: p_encoded => FND_API.g_false,

216: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
217: END IF;
218: FND_MSG_PUB.count_and_get
219: (
220: p_encoded => FND_API.g_false,
221: p_count => x_msg_count,
222: p_data => x_msg_data
223: );
224:

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

233: -------------------------------------------------------------------------------
234: PROCEDURE update_hierarchy
235: (
236: p_api_version IN NUMBER,
237: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
238: p_commit IN VARCHAR2 := FND_API.g_false,
239: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
240:
241: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

234: PROCEDURE update_hierarchy
235: (
236: p_api_version IN NUMBER,
237: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
238: p_commit IN VARCHAR2 := FND_API.g_false,
239: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
240:
241: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
242: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

235: (
236: p_api_version IN NUMBER,
237: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
238: p_commit IN VARCHAR2 := FND_API.g_false,
239: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
240:
241: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
242: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
243: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 260: IF FND_API.to_boolean(p_init_msg_list) THEN

256:
257: -- initialize
258: SAVEPOINT update_hierarchy;
259:
260: IF FND_API.to_boolean(p_init_msg_list) THEN
261: FND_MSG_PUB.initialize;
262: END IF;
263:
264: JTF_Utility_PVT.debug_message(l_full_name || ': start');

Line 266: IF NOT FND_API.compatible_api_call

262: END IF;
263:
264: JTF_Utility_PVT.debug_message(l_full_name || ': start');
265:
266: IF NOT FND_API.compatible_api_call
267: (
268: l_api_version,
269: p_api_version,
270: l_api_name,

Line 274: RAISE FND_API.g_exc_unexpected_error;

270: l_api_name,
271: g_pkg_name
272: )
273: THEN
274: RAISE FND_API.g_exc_unexpected_error;
275: END IF;
276:
277: x_return_status := FND_API.g_ret_sts_success;
278:

Line 277: x_return_status := FND_API.g_ret_sts_success;

273: THEN
274: RAISE FND_API.g_exc_unexpected_error;
275: END IF;
276:
277: x_return_status := FND_API.g_ret_sts_success;
278:
279: -- validate
280: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
281: JTF_Utility_PVT.debug_message(l_full_name || ': validate');

Line 290: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

286: x_return_status => l_return_status,
287: p_loc_hier_rec => l_loc_hier_rec
288: );
289:
290: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
291: RAISE FND_API.g_exc_unexpected_error;
292: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
293: RAISE FND_API.g_exc_error;
294: END IF;

Line 291: RAISE FND_API.g_exc_unexpected_error;

287: p_loc_hier_rec => l_loc_hier_rec
288: );
289:
290: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
291: RAISE FND_API.g_exc_unexpected_error;
292: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
293: RAISE FND_API.g_exc_error;
294: END IF;
295: END IF;

Line 292: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

288: );
289:
290: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
291: RAISE FND_API.g_exc_unexpected_error;
292: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
293: RAISE FND_API.g_exc_error;
294: END IF;
295: END IF;
296:

Line 293: RAISE FND_API.g_exc_error;

289:
290: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
291: RAISE FND_API.g_exc_unexpected_error;
292: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
293: RAISE FND_API.g_exc_error;
294: END IF;
295: END IF;
296:
297: -- complete record

Line 314: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

310: p_complete_rec => l_loc_hier_rec,
311: x_return_status => l_return_status
312: );
313:
314: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
315: RAISE FND_API.g_exc_unexpected_error;
316: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
317: RAISE FND_API.g_exc_error;
318: END IF;

Line 315: RAISE FND_API.g_exc_unexpected_error;

311: x_return_status => l_return_status
312: );
313:
314: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
315: RAISE FND_API.g_exc_unexpected_error;
316: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
317: RAISE FND_API.g_exc_error;
318: END IF;
319: END IF;

Line 316: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

312: );
313:
314: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
315: RAISE FND_API.g_exc_unexpected_error;
316: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
317: RAISE FND_API.g_exc_error;
318: END IF;
319: END IF;
320:

Line 317: RAISE FND_API.g_exc_error;

313:
314: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
315: RAISE FND_API.g_exc_unexpected_error;
316: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
317: RAISE FND_API.g_exc_error;
318: END IF;
319: END IF;
320:
321: -- update

Line 360: RAISE FND_API.g_exc_error;

356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
357: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
358: FND_MSG_PUB.add;
359: END IF;
360: RAISE FND_API.g_exc_error;
361: END IF;
362:
363: -- finish
364: IF FND_API.to_boolean(p_commit) THEN

Line 364: IF FND_API.to_boolean(p_commit) THEN

360: RAISE FND_API.g_exc_error;
361: END IF;
362:
363: -- finish
364: IF FND_API.to_boolean(p_commit) THEN
365: COMMIT;
366: END IF;
367:
368: FND_MSG_PUB.count_and_get

Line 370: P_ENCODED => FND_API.g_false,

366: END IF;
367:
368: FND_MSG_PUB.count_and_get
369: (
370: P_ENCODED => FND_API.g_false,
371: p_count => x_msg_count,
372: p_data => x_msg_data
373: );
374:

Line 379: WHEN FND_API.g_exc_error THEN

375: JTF_Utility_PVT.debug_message(l_full_name || ': end');
376:
377: EXCEPTION
378:
379: WHEN FND_API.g_exc_error THEN
380: ROLLBACK TO update_hierarchy;
381: x_return_status := FND_API.g_ret_sts_error;
382: FND_MSG_PUB.count_and_get
383: (

Line 381: x_return_status := FND_API.g_ret_sts_error;

377: EXCEPTION
378:
379: WHEN FND_API.g_exc_error THEN
380: ROLLBACK TO update_hierarchy;
381: x_return_status := FND_API.g_ret_sts_error;
382: FND_MSG_PUB.count_and_get
383: (
384: p_encoded => FND_API.g_false,
385: p_count => x_msg_count,

Line 384: p_encoded => FND_API.g_false,

380: ROLLBACK TO update_hierarchy;
381: x_return_status := FND_API.g_ret_sts_error;
382: FND_MSG_PUB.count_and_get
383: (
384: p_encoded => FND_API.g_false,
385: p_count => x_msg_count,
386: p_data => x_msg_data
387: );
388:

Line 389: WHEN FND_API.g_exc_unexpected_error THEN

385: p_count => x_msg_count,
386: p_data => x_msg_data
387: );
388:
389: WHEN FND_API.g_exc_unexpected_error THEN
390: ROLLBACK TO update_hierarchy;
391: x_return_status := FND_API.g_ret_sts_unexp_error;
392: FND_MSG_PUB.count_and_get
393: (

Line 391: x_return_status := FND_API.g_ret_sts_unexp_error;

387: );
388:
389: WHEN FND_API.g_exc_unexpected_error THEN
390: ROLLBACK TO update_hierarchy;
391: x_return_status := FND_API.g_ret_sts_unexp_error;
392: FND_MSG_PUB.count_and_get
393: (
394: p_encoded => FND_API.g_false,
395: p_count => x_msg_count,

Line 394: p_encoded => FND_API.g_false,

390: ROLLBACK TO update_hierarchy;
391: x_return_status := FND_API.g_ret_sts_unexp_error;
392: FND_MSG_PUB.count_and_get
393: (
394: p_encoded => FND_API.g_false,
395: p_count => x_msg_count,
396: p_data => x_msg_data
397: );
398:

Line 401: x_return_status :=FND_API.g_ret_sts_unexp_error;

397: );
398:
399: WHEN OTHERS THEN
400: ROLLBACK TO update_hierarchy;
401: x_return_status :=FND_API.g_ret_sts_unexp_error;
402: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
403: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
404: END IF;
405: FND_MSG_PUB.count_and_get

Line 407: p_encoded => FND_API.g_false,

403: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
404: END IF;
405: FND_MSG_PUB.count_and_get
406: (
407: p_encoded => FND_API.g_false,
408: p_count => x_msg_count,
409: p_data => x_msg_data
410: );
411:

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

420: -------------------------------------------------------------------------------
421: PROCEDURE delete_hierarchy
422: (
423: p_api_version IN NUMBER,
424: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
425: p_commit IN VARCHAR2 := FND_API.g_false,
426:
427: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
428: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

421: PROCEDURE delete_hierarchy
422: (
423: p_api_version IN NUMBER,
424: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
425: p_commit IN VARCHAR2 := FND_API.g_false,
426:
427: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
428: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
429: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 446: IF FND_API.to_boolean(p_init_msg_list) THEN

442: SAVEPOINT delete_hierarchy;
443:
444: JTF_Utility_PVT.debug_message(l_full_name || ': start');
445:
446: IF FND_API.to_boolean(p_init_msg_list) THEN
447: FND_MSG_PUB.initialize;
448: END IF;
449:
450: IF NOT FND_API.compatible_api_call

Line 450: IF NOT FND_API.compatible_api_call

446: IF FND_API.to_boolean(p_init_msg_list) THEN
447: FND_MSG_PUB.initialize;
448: END IF;
449:
450: IF NOT FND_API.compatible_api_call
451: (
452: l_api_version,
453: p_api_version,
454: l_api_name,

Line 458: RAISE FND_API.g_exc_unexpected_error;

454: l_api_name,
455: g_pkg_name
456: )
457: THEN
458: RAISE FND_API.g_exc_unexpected_error;
459: END IF;
460:
461: x_return_status := FND_API.g_ret_sts_success;
462:

Line 461: x_return_status := FND_API.g_ret_sts_success;

457: THEN
458: RAISE FND_API.g_exc_unexpected_error;
459: END IF;
460:
461: x_return_status := FND_API.g_ret_sts_success;
462:
463: -- delete
464: JTF_Utility_PVT.debug_message(l_full_name || ': delete');
465:

Line 475: RAISE FND_API.g_exc_error;

471: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
472: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
473: FND_MSG_PUB.add;
474: END IF;
475: RAISE FND_API.g_exc_error;
476: END IF;
477:
478: -- finish
479: IF FND_API.to_boolean(p_commit) THEN

Line 479: IF FND_API.to_boolean(p_commit) THEN

475: RAISE FND_API.g_exc_error;
476: END IF;
477:
478: -- finish
479: IF FND_API.to_boolean(p_commit) THEN
480: COMMIT;
481: END IF;
482:
483: FND_MSG_PUB.count_and_get

Line 485: P_ENCODED => FND_API.g_false,

481: END IF;
482:
483: FND_MSG_PUB.count_and_get
484: (
485: P_ENCODED => FND_API.g_false,
486: p_count => x_msg_count,
487: p_data => x_msg_data
488: );
489:

Line 494: WHEN FND_API.g_exc_error THEN

490: JTF_Utility_PVT.debug_message(l_full_name || ': end');
491:
492: EXCEPTION
493:
494: WHEN FND_API.g_exc_error THEN
495: ROLLBACK TO delete_hierarchy;
496: x_return_status := FND_API.g_ret_sts_error;
497: FND_MSG_PUB.count_and_get
498: (

Line 496: x_return_status := FND_API.g_ret_sts_error;

492: EXCEPTION
493:
494: WHEN FND_API.g_exc_error THEN
495: ROLLBACK TO delete_hierarchy;
496: x_return_status := FND_API.g_ret_sts_error;
497: FND_MSG_PUB.count_and_get
498: (
499: p_encoded => FND_API.g_false,
500: p_count => x_msg_count,

Line 499: p_encoded => FND_API.g_false,

495: ROLLBACK TO delete_hierarchy;
496: x_return_status := FND_API.g_ret_sts_error;
497: FND_MSG_PUB.count_and_get
498: (
499: p_encoded => FND_API.g_false,
500: p_count => x_msg_count,
501: p_data => x_msg_data
502: );
503:

Line 504: WHEN FND_API.g_exc_unexpected_error THEN

500: p_count => x_msg_count,
501: p_data => x_msg_data
502: );
503:
504: WHEN FND_API.g_exc_unexpected_error THEN
505: ROLLBACK TO delete_hierarchy;
506: x_return_status := FND_API.g_ret_sts_unexp_error;
507: FND_MSG_PUB.count_and_get
508: (

Line 506: x_return_status := FND_API.g_ret_sts_unexp_error;

502: );
503:
504: WHEN FND_API.g_exc_unexpected_error THEN
505: ROLLBACK TO delete_hierarchy;
506: x_return_status := FND_API.g_ret_sts_unexp_error;
507: FND_MSG_PUB.count_and_get
508: (
509: p_encoded => FND_API.g_false,
510: p_count => x_msg_count,

Line 509: p_encoded => FND_API.g_false,

505: ROLLBACK TO delete_hierarchy;
506: x_return_status := FND_API.g_ret_sts_unexp_error;
507: FND_MSG_PUB.count_and_get
508: (
509: p_encoded => FND_API.g_false,
510: p_count => x_msg_count,
511: p_data => x_msg_data
512: );
513:

Line 516: x_return_status :=FND_API.g_ret_sts_unexp_error;

512: );
513:
514: WHEN OTHERS THEN
515: ROLLBACK TO delete_hierarchy;
516: x_return_status :=FND_API.g_ret_sts_unexp_error;
517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
518: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
519: END IF;
520: FND_MSG_PUB.count_and_get

Line 522: p_encoded => FND_API.g_false,

518: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
519: END IF;
520: FND_MSG_PUB.count_and_get
521: (
522: p_encoded => FND_API.g_false,
523: p_count => x_msg_count,
524: p_data => x_msg_data
525: );
526:

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

535: -------------------------------------------------------------------------------
536: PROCEDURE lock_hierarchy
537: (
538: p_api_version IN NUMBER,
539: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
540:
541: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
542: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
543: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 566: IF FND_API.to_boolean(p_init_msg_list) THEN

562: BEGIN
563: -- initialize
564: JTF_Utility_PVT.debug_message(l_full_name || ': start');
565:
566: IF FND_API.to_boolean(p_init_msg_list) THEN
567: FND_MSG_PUB.initialize;
568: END IF;
569:
570: IF NOT FND_API.compatible_api_call

Line 570: IF NOT FND_API.compatible_api_call

566: IF FND_API.to_boolean(p_init_msg_list) THEN
567: FND_MSG_PUB.initialize;
568: END IF;
569:
570: IF NOT FND_API.compatible_api_call
571: (
572: l_api_version,
573: p_api_version,
574: l_api_name,

Line 578: RAISE FND_API.g_exc_unexpected_error;

574: l_api_name,
575: g_pkg_name
576: )
577: THEN
578: RAISE FND_API.g_exc_unexpected_error;
579: END IF;
580:
581: x_return_status := FND_API.g_ret_sts_success;
582:

Line 581: x_return_status := FND_API.g_ret_sts_success;

577: THEN
578: RAISE FND_API.g_exc_unexpected_error;
579: END IF;
580:
581: x_return_status := FND_API.g_ret_sts_success;
582:
583: -- lock
584: JTF_Utility_PVT.debug_message(l_full_name || ': lock');
585:

Line 594: RAISE FND_API.g_exc_error;

590: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
591: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
592: FND_MSG_PUB.add;
593: END IF;
594: RAISE FND_API.g_exc_error;
595: END IF;
596: CLOSE c_hier;
597:
598: -- finish

Line 601: p_encoded => FND_API.g_false,

597:
598: -- finish
599: FND_MSG_PUB.count_and_get
600: (
601: p_encoded => FND_API.g_false,
602: p_count => x_msg_count,
603: p_data => x_msg_data
604: );
605:

Line 611: x_return_status := FND_API.g_ret_sts_error;

607:
608: EXCEPTION
609:
610: WHEN JTF_Utility_PVT.resource_locked THEN
611: x_return_status := FND_API.g_ret_sts_error;
612: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
613: FND_MESSAGE.set_name('JTF', 'JTF_API_RESOURCE_LOCKED');
614: FND_MSG_PUB.add;
615: END IF;

Line 618: p_encoded => FND_API.g_false,

614: FND_MSG_PUB.add;
615: END IF;
616: FND_MSG_PUB.count_and_get
617: (
618: p_encoded => FND_API.g_false,
619: p_count => x_msg_count,
620: p_data => x_msg_data
621: );
622:

Line 623: WHEN FND_API.g_exc_error THEN

619: p_count => x_msg_count,
620: p_data => x_msg_data
621: );
622:
623: WHEN FND_API.g_exc_error THEN
624: x_return_status := FND_API.g_ret_sts_error;
625: FND_MSG_PUB.count_and_get
626: (
627: p_encoded => FND_API.g_false,

Line 624: x_return_status := FND_API.g_ret_sts_error;

620: p_data => x_msg_data
621: );
622:
623: WHEN FND_API.g_exc_error THEN
624: x_return_status := FND_API.g_ret_sts_error;
625: FND_MSG_PUB.count_and_get
626: (
627: p_encoded => FND_API.g_false,
628: p_count => x_msg_count,

Line 627: p_encoded => FND_API.g_false,

623: WHEN FND_API.g_exc_error THEN
624: x_return_status := FND_API.g_ret_sts_error;
625: FND_MSG_PUB.count_and_get
626: (
627: p_encoded => FND_API.g_false,
628: p_count => x_msg_count,
629: p_data => x_msg_data
630: );
631:

Line 632: WHEN FND_API.g_exc_unexpected_error THEN

628: p_count => x_msg_count,
629: p_data => x_msg_data
630: );
631:
632: WHEN FND_API.g_exc_unexpected_error THEN
633: x_return_status := FND_API.g_ret_sts_unexp_error;
634: FND_MSG_PUB.count_and_get
635: (
636: p_encoded => FND_API.g_false,

Line 633: x_return_status := FND_API.g_ret_sts_unexp_error;

629: p_data => x_msg_data
630: );
631:
632: WHEN FND_API.g_exc_unexpected_error THEN
633: x_return_status := FND_API.g_ret_sts_unexp_error;
634: FND_MSG_PUB.count_and_get
635: (
636: p_encoded => FND_API.g_false,
637: p_count => x_msg_count,

Line 636: p_encoded => FND_API.g_false,

632: WHEN FND_API.g_exc_unexpected_error THEN
633: x_return_status := FND_API.g_ret_sts_unexp_error;
634: FND_MSG_PUB.count_and_get
635: (
636: p_encoded => FND_API.g_false,
637: p_count => x_msg_count,
638: p_data => x_msg_data
639: );
640:

Line 642: x_return_status :=FND_API.g_ret_sts_unexp_error;

638: p_data => x_msg_data
639: );
640:
641: WHEN OTHERS THEN
642: x_return_status :=FND_API.g_ret_sts_unexp_error;
643: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
644: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
645: END IF;
646: FND_MSG_PUB.count_and_get

Line 648: p_encoded => FND_API.g_false,

644: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
645: END IF;
646: FND_MSG_PUB.count_and_get
647: (
648: p_encoded => FND_API.g_false,
649: p_count => x_msg_count,
650: p_data => x_msg_data
651: );
652:

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

662: --------------------------------------------------------------------
663: PROCEDURE validate_hierarchy
664: (
665: p_api_version IN NUMBER,
666: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
667: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
668:
669: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
670: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

663: PROCEDURE validate_hierarchy
664: (
665: p_api_version IN NUMBER,
666: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
667: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
668:
669: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
670: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
671: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 688: IF NOT FND_API.compatible_api_call

684:
685: ----------------------- initialize --------------------
686: JTF_Utility_PVT.debug_message(l_full_name||': start');
687:
688: IF NOT FND_API.compatible_api_call
689: (
690: l_api_version,
691: p_api_version,
692: l_api_name,

Line 696: RAISE FND_API.g_exc_unexpected_error;

692: l_api_name,
693: g_pkg_name
694: )
695: THEN
696: RAISE FND_API.g_exc_unexpected_error;
697: END IF;
698:
699: x_return_status := FND_API.g_ret_sts_success;
700:

Line 699: x_return_status := FND_API.g_ret_sts_success;

695: THEN
696: RAISE FND_API.g_exc_unexpected_error;
697: END IF;
698:
699: x_return_status := FND_API.g_ret_sts_success;
700:
701: ---------------------- validate ------------------------
702: -- item level
703: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 712: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

708: x_return_status => l_return_status,
709: p_loc_hier_rec => p_loc_hier_rec
710: );
711:
712: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
713: RAISE FND_API.g_exc_unexpected_error;
714: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
715: RAISE FND_API.g_exc_error;
716: END IF;

Line 713: RAISE FND_API.g_exc_unexpected_error;

709: p_loc_hier_rec => p_loc_hier_rec
710: );
711:
712: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
713: RAISE FND_API.g_exc_unexpected_error;
714: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
715: RAISE FND_API.g_exc_error;
716: END IF;
717: END IF;

Line 714: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

710: );
711:
712: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
713: RAISE FND_API.g_exc_unexpected_error;
714: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
715: RAISE FND_API.g_exc_error;
716: END IF;
717: END IF;
718:

Line 715: RAISE FND_API.g_exc_error;

711:
712: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
713: RAISE FND_API.g_exc_unexpected_error;
714: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
715: RAISE FND_API.g_exc_error;
716: END IF;
717: END IF;
718:
719: -- record level

Line 729: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

725: p_complete_rec => p_loc_hier_rec,
726: x_return_status => l_return_status
727: );
728:
729: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
730: RAISE FND_API.g_exc_unexpected_error;
731: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
732: RAISE FND_API.g_exc_error;
733: END IF;

Line 730: RAISE FND_API.g_exc_unexpected_error;

726: x_return_status => l_return_status
727: );
728:
729: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
730: RAISE FND_API.g_exc_unexpected_error;
731: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
732: RAISE FND_API.g_exc_error;
733: END IF;
734: END IF;

Line 731: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

727: );
728:
729: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
730: RAISE FND_API.g_exc_unexpected_error;
731: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
732: RAISE FND_API.g_exc_error;
733: END IF;
734: END IF;
735:

Line 732: RAISE FND_API.g_exc_error;

728:
729: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
730: RAISE FND_API.g_exc_unexpected_error;
731: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
732: RAISE FND_API.g_exc_error;
733: END IF;
734: END IF;
735:
736: -------------------- finish --------------------------

Line 739: p_encoded => FND_API.g_false,

735:
736: -------------------- finish --------------------------
737: FND_MSG_PUB.count_and_get
738: (
739: p_encoded => FND_API.g_false,
740: p_count => x_msg_count,
741: p_data => x_msg_data
742: );
743:

Line 747: WHEN FND_API.g_exc_error THEN

743:
744: JTF_Utility_PVT.debug_message(l_full_name ||': end');
745:
746: EXCEPTION
747: WHEN FND_API.g_exc_error THEN
748: x_return_status := FND_API.g_ret_sts_error;
749: FND_MSG_PUB.count_and_get
750: (
751: p_encoded => FND_API.g_false,

Line 748: x_return_status := FND_API.g_ret_sts_error;

744: JTF_Utility_PVT.debug_message(l_full_name ||': end');
745:
746: EXCEPTION
747: WHEN FND_API.g_exc_error THEN
748: x_return_status := FND_API.g_ret_sts_error;
749: FND_MSG_PUB.count_and_get
750: (
751: p_encoded => FND_API.g_false,
752: p_count => x_msg_count,

Line 751: p_encoded => FND_API.g_false,

747: WHEN FND_API.g_exc_error THEN
748: x_return_status := FND_API.g_ret_sts_error;
749: FND_MSG_PUB.count_and_get
750: (
751: p_encoded => FND_API.g_false,
752: p_count => x_msg_count,
753: p_data => x_msg_data
754: );
755:

Line 756: WHEN FND_API.g_exc_unexpected_error THEN

752: p_count => x_msg_count,
753: p_data => x_msg_data
754: );
755:
756: WHEN FND_API.g_exc_unexpected_error THEN
757: x_return_status := FND_API.g_ret_sts_unexp_error ;
758: FND_MSG_PUB.count_and_get
759: (
760: p_encoded => FND_API.g_false,

Line 757: x_return_status := FND_API.g_ret_sts_unexp_error ;

753: p_data => x_msg_data
754: );
755:
756: WHEN FND_API.g_exc_unexpected_error THEN
757: x_return_status := FND_API.g_ret_sts_unexp_error ;
758: FND_MSG_PUB.count_and_get
759: (
760: p_encoded => FND_API.g_false,
761: p_count => x_msg_count,

Line 760: p_encoded => FND_API.g_false,

756: WHEN FND_API.g_exc_unexpected_error THEN
757: x_return_status := FND_API.g_ret_sts_unexp_error ;
758: FND_MSG_PUB.count_and_get
759: (
760: p_encoded => FND_API.g_false,
761: p_count => x_msg_count,
762: p_data => x_msg_data
763: );
764:

Line 766: x_return_status := FND_API.g_ret_sts_unexp_error;

762: p_data => x_msg_data
763: );
764:
765: WHEN OTHERS THEN
766: x_return_status := FND_API.g_ret_sts_unexp_error;
767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
768: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
769: END IF;
770:

Line 773: p_encoded => FND_API.g_false,

769: END IF;
770:
771: FND_MSG_PUB.count_and_get
772: (
773: p_encoded => FND_API.g_false,
774: p_count => x_msg_count,
775: p_data => x_msg_data
776: );
777:

Line 802: x_return_status := FND_API.g_ret_sts_success;

798: BEGIN
799: -- initialize
800: JTF_Utility_PVT.debug_message(l_full_name || ': start');
801:
802: x_return_status := FND_API.g_ret_sts_success;
803:
804: -- check required items
805: JTF_Utility_PVT.debug_message(l_full_name || ': check required items');
806: check_req_items

Line 813: IF x_return_status <> FND_API.g_ret_sts_success THEN

809: p_loc_hier_rec => p_loc_hier_rec,
810: x_return_status => x_return_status
811: );
812:
813: IF x_return_status <> FND_API.g_ret_sts_success THEN
814: RETURN;
815: END IF;
816:
817: -- check unique key items

Line 826: IF x_return_status <> FND_API.g_ret_sts_success THEN

822: p_loc_hier_rec => p_loc_hier_rec,
823: x_return_status => x_return_status
824: );
825:
826: IF x_return_status <> FND_API.g_ret_sts_success THEN
827: RETURN;
828: END IF;
829:
830: -- check foreign key items

Line 838: IF x_return_status <> FND_API.g_ret_sts_success THEN

834: p_loc_hier_rec => p_loc_hier_rec,
835: x_return_status => x_return_status
836: );
837:
838: IF x_return_status <> FND_API.g_ret_sts_success THEN
839: RETURN;
840: END IF;
841:
842: END check_items;

Line 861: x_return_status := FND_API.g_ret_sts_success;

857: IS
858:
859: BEGIN
860:
861: x_return_status := FND_API.g_ret_sts_success;
862:
863: -- check location_hierarchy_id
864: IF p_loc_hier_rec.location_hierarchy_id IS NULL
865: AND p_validation_mode = JTF_PLSQL_API.g_update THEN

Line 871: x_return_status := FND_API.g_ret_sts_error;

867: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_NO_LOC_HIER_ID');
868: FND_MSG_PUB.add;
869: END IF;
870:
871: x_return_status := FND_API.g_ret_sts_error;
872: RETURN;
873: END IF;
874:
875: -- check object_version_number

Line 884: x_return_status := FND_API.g_ret_sts_error;

880: FND_MESSAGE.set_name('JTF', 'JTF_NO_OBJ_VER_NUM');
881: FND_MSG_PUB.add;
882: END IF;
883:
884: x_return_status := FND_API.g_ret_sts_error;
885: RETURN;
886: END IF;
887:
888: -- check created_by_application_id

Line 895: x_return_status := FND_API.g_ret_sts_error;

891: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_NO_CR_BY_APP_ID');
892: FND_MSG_PUB.add;
893: END IF;
894:
895: x_return_status := FND_API.g_ret_sts_error;
896: RETURN;
897: END IF;
898:
899: -- check location_type_code

Line 906: x_return_status := FND_API.g_ret_sts_error;

902: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_NO_LOC_TYPE_CODE');
903: FND_MSG_PUB.add;
904: END IF;
905:
906: x_return_status := FND_API.g_ret_sts_error;
907: RETURN;
908: END IF;
909:
910: -- check start_date_active

Line 917: x_return_status := FND_API.g_ret_sts_error;

913: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_NO_STAT_DATE');
914: FND_MSG_PUB.add;
915: END IF;
916:
917: x_return_status := FND_API.g_ret_sts_error;
918: RETURN;
919: END IF;
920:
921: END check_req_items;

Line 942: x_return_status := FND_API.g_ret_sts_success;

938: l_uk_flag VARCHAR2(1);
939:
940: BEGIN
941:
942: x_return_status := FND_API.g_ret_sts_success;
943:
944: -- check PK, if location_hierarchy_id is parsed in, must check if it is duplicate
945: IF p_validation_mode = JTF_PLSQL_API.g_create
946: AND p_loc_hier_rec.location_hierarchy_id IS NOT NULL

Line 955: IF l_uk_flag = FND_API.g_false THEN

951: 'location_hierarchy_id = ' || p_loc_hier_rec.location_hierarchy_id
952: );
953: END IF;
954:
955: IF l_uk_flag = FND_API.g_false THEN
956: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
957: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIERARCHY_DUPLICATE_ID');
958: FND_MSG_PUB.add;
959: END IF;

Line 961: x_return_status := FND_API.g_ret_sts_error;

957: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIERARCHY_DUPLICATE_ID');
958: FND_MSG_PUB.add;
959: END IF;
960:
961: x_return_status := FND_API.g_ret_sts_error;
962: RETURN;
963: END IF;
964:
965: END check_uk_items;

Line 985: x_return_status := FND_API.g_ret_sts_success;

981: l_fk_flag VARCHAR2(1);
982:
983: BEGIN
984:
985: x_return_status := FND_API.g_ret_sts_success;
986:
987: -- check FK1 location_type_code
988: IF p_loc_hier_rec.location_type_code IS NOT NULL THEN
989: l_fk_flag := JTF_Utility_PVT.check_fk_exists

Line 997: IF l_fk_flag = FND_API.g_false THEN

993: p_loc_hier_rec.location_type_code,
994: 2 -- varchar2 type
995: );
996:
997: IF l_fk_flag = FND_API.g_false THEN
998: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
999: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_LOC_TYPE_CODE');
1000: FND_MSG_PUB.add;
1001: END IF;

Line 1003: x_return_status := FND_API.g_ret_sts_error;

999: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_LOC_TYPE_CODE');
1000: FND_MSG_PUB.add;
1001: END IF;
1002:
1003: x_return_status := FND_API.g_ret_sts_error;
1004: RETURN;
1005: END IF;
1006: END IF;
1007:

Line 1017: IF l_fk_flag = FND_API.g_false THEN

1013: 'application_id',
1014: p_loc_hier_rec.created_by_application_id
1015: );
1016:
1017: IF l_fk_flag = FND_API.g_false THEN
1018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1019: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_APP_ID');
1020: FND_MSG_PUB.add;
1021: END IF;

Line 1023: x_return_status := FND_API.g_ret_sts_error;

1019: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_APP_ID');
1020: FND_MSG_PUB.add;
1021: END IF;
1022:
1023: x_return_status := FND_API.g_ret_sts_error;
1024: RETURN;
1025: END IF;
1026: END IF;
1027:

Line 1039: IF l_fk_flag = FND_API.g_false THEN

1035: 1,
1036: 'location_area_code = ''' || p_loc_hier_rec.area1_code || ''''
1037: );
1038:
1039: IF l_fk_flag = FND_API.g_false THEN
1040: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1041: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_AREA1');
1042: FND_MSG_PUB.add;
1043: END IF;

Line 1045: x_return_status := FND_API.g_ret_sts_error;

1041: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_AREA1');
1042: FND_MSG_PUB.add;
1043: END IF;
1044:
1045: x_return_status := FND_API.g_ret_sts_error;
1046: RETURN;
1047: END IF;
1048: END IF;
1049:

Line 1061: IF l_fk_flag = FND_API.g_false THEN

1057: 1,
1058: 'location_area_code = ''' || p_loc_hier_rec.area2_code || ''''
1059: );
1060:
1061: IF l_fk_flag = FND_API.g_false THEN
1062: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1063: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_AREA2');
1064: FND_MSG_PUB.add;
1065: END IF;

Line 1067: x_return_status := FND_API.g_ret_sts_error;

1063: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_AREA2');
1064: FND_MSG_PUB.add;
1065: END IF;
1066:
1067: x_return_status := FND_API.g_ret_sts_error;
1068: RETURN;
1069: END IF;
1070: END IF;
1071:

Line 1083: IF l_fk_flag = FND_API.g_false THEN

1079: 1,
1080: 'location_area_code = ''' || p_loc_hier_rec.country_code || ''''
1081: );
1082:
1083: IF l_fk_flag = FND_API.g_false THEN
1084: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1085: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_COUNTRY');
1086: FND_MSG_PUB.add;
1087: END IF;

Line 1089: x_return_status := FND_API.g_ret_sts_error;

1085: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_COUNTRY');
1086: FND_MSG_PUB.add;
1087: END IF;
1088:
1089: x_return_status := FND_API.g_ret_sts_error;
1090: RETURN;
1091: END IF;
1092: END IF;
1093:

Line 1105: IF l_fk_flag = FND_API.g_false THEN

1101: 1,
1102: 'location_area_code = ''' || p_loc_hier_rec.country_region_code || ''''
1103: );
1104:
1105: IF l_fk_flag = FND_API.g_false THEN
1106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1107: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_COUNTRY_REGN');
1108: FND_MSG_PUB.add;
1109: END IF;

Line 1111: x_return_status := FND_API.g_ret_sts_error;

1107: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_COUNTRY_REGN');
1108: FND_MSG_PUB.add;
1109: END IF;
1110:
1111: x_return_status := FND_API.g_ret_sts_error;
1112: RETURN;
1113: END IF;
1114: END IF;
1115:

Line 1127: IF l_fk_flag = FND_API.g_false THEN

1123: 1,
1124: 'location_area_code = ''' || p_loc_hier_rec.state_code || ''''
1125: );
1126:
1127: IF l_fk_flag = FND_API.g_false THEN
1128: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1129: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_STATE');
1130: FND_MSG_PUB.add;
1131: END IF;

Line 1133: x_return_status := FND_API.g_ret_sts_error;

1129: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_STATE');
1130: FND_MSG_PUB.add;
1131: END IF;
1132:
1133: x_return_status := FND_API.g_ret_sts_error;
1134: RETURN;
1135: END IF;
1136: END IF;
1137:

Line 1149: IF l_fk_flag = FND_API.g_false THEN

1145: 1,
1146: 'location_area_code = ''' || p_loc_hier_rec.state_region_code || ''''
1147: );
1148:
1149: IF l_fk_flag = FND_API.g_false THEN
1150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1151: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_STATE_REGN');
1152: FND_MSG_PUB.add;
1153: END IF;

Line 1155: x_return_status := FND_API.g_ret_sts_error;

1151: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_STATE_REGN');
1152: FND_MSG_PUB.add;
1153: END IF;
1154:
1155: x_return_status := FND_API.g_ret_sts_error;
1156: RETURN;
1157: END IF;
1158: END IF;
1159:

Line 1172: IF l_fk_flag = FND_API.g_false THEN

1168: 1,
1169: 'location_area_code = ''' || p_loc_hier_rec.city_code || ''''
1170: );
1171:
1172: IF l_fk_flag = FND_API.g_false THEN
1173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1174: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_CITY');
1175: FND_MSG_PUB.add;
1176: END IF;

Line 1178: x_return_status := FND_API.g_ret_sts_error;

1174: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_CITY');
1175: FND_MSG_PUB.add;
1176: END IF;
1177:
1178: x_return_status := FND_API.g_ret_sts_error;
1179: RETURN;
1180: END IF;
1181: END IF;
1182:

Line 1192: IF l_fk_flag = FND_API.g_false THEN

1188: 'location_area_id',
1189: p_loc_hier_rec.postal_code_id
1190: );
1191:
1192: IF l_fk_flag = FND_API.g_false THEN
1193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1194: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_POSTAL_CODE');
1195: FND_MSG_PUB.add;
1196: END IF;

Line 1198: x_return_status := FND_API.g_ret_sts_error;

1194: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_POSTAL_CODE');
1195: FND_MSG_PUB.add;
1196: END IF;
1197:
1198: x_return_status := FND_API.g_ret_sts_error;
1199: RETURN;
1200: END IF;
1201: END IF;
1202:

Line 1226: x_return_status := FND_API.g_ret_sts_success;

1222: l_end_date DATE;
1223:
1224: BEGIN
1225:
1226: x_return_status := FND_API.g_ret_sts_success;
1227:
1228: -- check that start_date_active <= end_date_active
1229: IF p_complete_rec.start_date_active <> FND_API.g_miss_date
1230: AND p_complete_rec.end_date_active <> FND_API.g_miss_date

Line 1229: IF p_complete_rec.start_date_active <> FND_API.g_miss_date

1225:
1226: x_return_status := FND_API.g_ret_sts_success;
1227:
1228: -- check that start_date_active <= end_date_active
1229: IF p_complete_rec.start_date_active <> FND_API.g_miss_date
1230: AND p_complete_rec.end_date_active <> FND_API.g_miss_date
1231: AND p_complete_rec.end_date_active IS NOT NULL
1232: THEN
1233: l_start_date := p_complete_rec.start_date_active;

Line 1230: AND p_complete_rec.end_date_active <> FND_API.g_miss_date

1226: x_return_status := FND_API.g_ret_sts_success;
1227:
1228: -- check that start_date_active <= end_date_active
1229: IF p_complete_rec.start_date_active <> FND_API.g_miss_date
1230: AND p_complete_rec.end_date_active <> FND_API.g_miss_date
1231: AND p_complete_rec.end_date_active IS NOT NULL
1232: THEN
1233: l_start_date := p_complete_rec.start_date_active;
1234: l_end_date := p_complete_rec.end_date_active;

Line 1241: x_return_status := FND_API.g_ret_sts_error;

1237: FND_MESSAGE.set_name('JTF', 'JTF_START_DATE_AFTER_END_DATE');
1238: FND_MSG_PUB.add;
1239: END IF;
1240:
1241: x_return_status := FND_API.g_ret_sts_error;
1242: RETURN;
1243: END IF;
1244: END IF;
1245:

Line 1280: RAISE FND_API.g_exc_error;

1276: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1277: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
1278: FND_MSG_PUB.add;
1279: END IF;
1280: RAISE FND_API.g_exc_error;
1281: END IF;
1282: CLOSE c_hier;
1283:
1284:

Line 1285: IF p_loc_hier_rec.request_id = FND_API.g_miss_num THEN

1281: END IF;
1282: CLOSE c_hier;
1283:
1284:
1285: IF p_loc_hier_rec.request_id = FND_API.g_miss_num THEN
1286: x_complete_rec.request_id := l_loc_hier_rec.request_id;
1287: END IF;
1288:
1289: IF p_loc_hier_rec.program_application_id = FND_API.g_miss_char THEN

Line 1289: IF p_loc_hier_rec.program_application_id = FND_API.g_miss_char THEN

1285: IF p_loc_hier_rec.request_id = FND_API.g_miss_num THEN
1286: x_complete_rec.request_id := l_loc_hier_rec.request_id;
1287: END IF;
1288:
1289: IF p_loc_hier_rec.program_application_id = FND_API.g_miss_char THEN
1290: x_complete_rec.program_application_id := l_loc_hier_rec.program_application_id;
1291: END IF;
1292:
1293: IF p_loc_hier_rec.program_id = FND_API.g_miss_char THEN

Line 1293: IF p_loc_hier_rec.program_id = FND_API.g_miss_char THEN

1289: IF p_loc_hier_rec.program_application_id = FND_API.g_miss_char THEN
1290: x_complete_rec.program_application_id := l_loc_hier_rec.program_application_id;
1291: END IF;
1292:
1293: IF p_loc_hier_rec.program_id = FND_API.g_miss_char THEN
1294: x_complete_rec.program_id := l_loc_hier_rec.program_id;
1295: END IF;
1296:
1297: IF p_loc_hier_rec.program_update_date = FND_API.g_miss_char THEN

Line 1297: IF p_loc_hier_rec.program_update_date = FND_API.g_miss_char THEN

1293: IF p_loc_hier_rec.program_id = FND_API.g_miss_char THEN
1294: x_complete_rec.program_id := l_loc_hier_rec.program_id;
1295: END IF;
1296:
1297: IF p_loc_hier_rec.program_update_date = FND_API.g_miss_char THEN
1298: x_complete_rec.program_update_date := l_loc_hier_rec.program_update_date;
1299: END IF;
1300:
1301: IF p_loc_hier_rec.created_by_application_id = FND_API.g_miss_char THEN

Line 1301: IF p_loc_hier_rec.created_by_application_id = FND_API.g_miss_char THEN

1297: IF p_loc_hier_rec.program_update_date = FND_API.g_miss_char THEN
1298: x_complete_rec.program_update_date := l_loc_hier_rec.program_update_date;
1299: END IF;
1300:
1301: IF p_loc_hier_rec.created_by_application_id = FND_API.g_miss_char THEN
1302: x_complete_rec.created_by_application_id := l_loc_hier_rec.created_by_application_id;
1303: END IF;
1304:
1305: IF p_loc_hier_rec.location_type_code = FND_API.g_miss_char THEN

Line 1305: IF p_loc_hier_rec.location_type_code = FND_API.g_miss_char THEN

1301: IF p_loc_hier_rec.created_by_application_id = FND_API.g_miss_char THEN
1302: x_complete_rec.created_by_application_id := l_loc_hier_rec.created_by_application_id;
1303: END IF;
1304:
1305: IF p_loc_hier_rec.location_type_code = FND_API.g_miss_char THEN
1306: x_complete_rec.location_type_code := l_loc_hier_rec.location_type_code;
1307: END IF;
1308:
1309: IF p_loc_hier_rec.start_date_active = FND_API.g_miss_char THEN

Line 1309: IF p_loc_hier_rec.start_date_active = FND_API.g_miss_char THEN

1305: IF p_loc_hier_rec.location_type_code = FND_API.g_miss_char THEN
1306: x_complete_rec.location_type_code := l_loc_hier_rec.location_type_code;
1307: END IF;
1308:
1309: IF p_loc_hier_rec.start_date_active = FND_API.g_miss_char THEN
1310: x_complete_rec.start_date_active := l_loc_hier_rec.start_date_active;
1311: END IF;
1312:
1313: IF p_loc_hier_rec.end_date_active = FND_API.g_miss_char THEN

Line 1313: IF p_loc_hier_rec.end_date_active = FND_API.g_miss_char THEN

1309: IF p_loc_hier_rec.start_date_active = FND_API.g_miss_char THEN
1310: x_complete_rec.start_date_active := l_loc_hier_rec.start_date_active;
1311: END IF;
1312:
1313: IF p_loc_hier_rec.end_date_active = FND_API.g_miss_char THEN
1314: x_complete_rec.end_date_active := l_loc_hier_rec.end_date_active;
1315: END IF;
1316:
1317: IF p_loc_hier_rec.area1_id = FND_API.g_miss_char THEN

Line 1317: IF p_loc_hier_rec.area1_id = FND_API.g_miss_char THEN

1313: IF p_loc_hier_rec.end_date_active = FND_API.g_miss_char THEN
1314: x_complete_rec.end_date_active := l_loc_hier_rec.end_date_active;
1315: END IF;
1316:
1317: IF p_loc_hier_rec.area1_id = FND_API.g_miss_char THEN
1318: x_complete_rec.area1_id := l_loc_hier_rec.area1_id;
1319: END IF;
1320:
1321: IF p_loc_hier_rec.area1_code = FND_API.g_miss_char THEN

Line 1321: IF p_loc_hier_rec.area1_code = FND_API.g_miss_char THEN

1317: IF p_loc_hier_rec.area1_id = FND_API.g_miss_char THEN
1318: x_complete_rec.area1_id := l_loc_hier_rec.area1_id;
1319: END IF;
1320:
1321: IF p_loc_hier_rec.area1_code = FND_API.g_miss_char THEN
1322: x_complete_rec.area1_code := l_loc_hier_rec.area1_code;
1323: END IF;
1324:
1325: IF p_loc_hier_rec.area2_id = FND_API.g_miss_char THEN

Line 1325: IF p_loc_hier_rec.area2_id = FND_API.g_miss_char THEN

1321: IF p_loc_hier_rec.area1_code = FND_API.g_miss_char THEN
1322: x_complete_rec.area1_code := l_loc_hier_rec.area1_code;
1323: END IF;
1324:
1325: IF p_loc_hier_rec.area2_id = FND_API.g_miss_char THEN
1326: x_complete_rec.area2_id := l_loc_hier_rec.area2_id;
1327: END IF;
1328:
1329: IF p_loc_hier_rec.area2_code = FND_API.g_miss_char THEN

Line 1329: IF p_loc_hier_rec.area2_code = FND_API.g_miss_char THEN

1325: IF p_loc_hier_rec.area2_id = FND_API.g_miss_char THEN
1326: x_complete_rec.area2_id := l_loc_hier_rec.area2_id;
1327: END IF;
1328:
1329: IF p_loc_hier_rec.area2_code = FND_API.g_miss_char THEN
1330: x_complete_rec.area2_code := l_loc_hier_rec.area2_code;
1331: END IF;
1332:
1333: IF p_loc_hier_rec.country_id = FND_API.g_miss_char THEN

Line 1333: IF p_loc_hier_rec.country_id = FND_API.g_miss_char THEN

1329: IF p_loc_hier_rec.area2_code = FND_API.g_miss_char THEN
1330: x_complete_rec.area2_code := l_loc_hier_rec.area2_code;
1331: END IF;
1332:
1333: IF p_loc_hier_rec.country_id = FND_API.g_miss_char THEN
1334: x_complete_rec.country_id := l_loc_hier_rec.country_id;
1335: END IF;
1336:
1337: IF p_loc_hier_rec.country_code = FND_API.g_miss_char THEN

Line 1337: IF p_loc_hier_rec.country_code = FND_API.g_miss_char THEN

1333: IF p_loc_hier_rec.country_id = FND_API.g_miss_char THEN
1334: x_complete_rec.country_id := l_loc_hier_rec.country_id;
1335: END IF;
1336:
1337: IF p_loc_hier_rec.country_code = FND_API.g_miss_char THEN
1338: x_complete_rec.country_code := l_loc_hier_rec.country_code;
1339: END IF;
1340:
1341: IF p_loc_hier_rec.country_region_id = FND_API.g_miss_char THEN

Line 1341: IF p_loc_hier_rec.country_region_id = FND_API.g_miss_char THEN

1337: IF p_loc_hier_rec.country_code = FND_API.g_miss_char THEN
1338: x_complete_rec.country_code := l_loc_hier_rec.country_code;
1339: END IF;
1340:
1341: IF p_loc_hier_rec.country_region_id = FND_API.g_miss_char THEN
1342: x_complete_rec.country_region_id := l_loc_hier_rec.country_region_id;
1343: END IF;
1344:
1345: IF p_loc_hier_rec.country_region_code = FND_API.g_miss_char THEN

Line 1345: IF p_loc_hier_rec.country_region_code = FND_API.g_miss_char THEN

1341: IF p_loc_hier_rec.country_region_id = FND_API.g_miss_char THEN
1342: x_complete_rec.country_region_id := l_loc_hier_rec.country_region_id;
1343: END IF;
1344:
1345: IF p_loc_hier_rec.country_region_code = FND_API.g_miss_char THEN
1346: x_complete_rec.country_region_code := l_loc_hier_rec.country_region_code;
1347: END IF;
1348:
1349: IF p_loc_hier_rec.state_id = FND_API.g_miss_char THEN

Line 1349: IF p_loc_hier_rec.state_id = FND_API.g_miss_char THEN

1345: IF p_loc_hier_rec.country_region_code = FND_API.g_miss_char THEN
1346: x_complete_rec.country_region_code := l_loc_hier_rec.country_region_code;
1347: END IF;
1348:
1349: IF p_loc_hier_rec.state_id = FND_API.g_miss_char THEN
1350: x_complete_rec.state_id := l_loc_hier_rec.state_id;
1351: END IF;
1352:
1353: IF p_loc_hier_rec.state_code = FND_API.g_miss_char THEN

Line 1353: IF p_loc_hier_rec.state_code = FND_API.g_miss_char THEN

1349: IF p_loc_hier_rec.state_id = FND_API.g_miss_char THEN
1350: x_complete_rec.state_id := l_loc_hier_rec.state_id;
1351: END IF;
1352:
1353: IF p_loc_hier_rec.state_code = FND_API.g_miss_char THEN
1354: x_complete_rec.state_code := l_loc_hier_rec.state_code;
1355: END IF;
1356:
1357: IF p_loc_hier_rec.state_region_id = FND_API.g_miss_char THEN

Line 1357: IF p_loc_hier_rec.state_region_id = FND_API.g_miss_char THEN

1353: IF p_loc_hier_rec.state_code = FND_API.g_miss_char THEN
1354: x_complete_rec.state_code := l_loc_hier_rec.state_code;
1355: END IF;
1356:
1357: IF p_loc_hier_rec.state_region_id = FND_API.g_miss_char THEN
1358: x_complete_rec.state_region_id := l_loc_hier_rec.state_region_id;
1359: END IF;
1360:
1361: IF p_loc_hier_rec.state_region_code = FND_API.g_miss_char THEN

Line 1361: IF p_loc_hier_rec.state_region_code = FND_API.g_miss_char THEN

1357: IF p_loc_hier_rec.state_region_id = FND_API.g_miss_char THEN
1358: x_complete_rec.state_region_id := l_loc_hier_rec.state_region_id;
1359: END IF;
1360:
1361: IF p_loc_hier_rec.state_region_code = FND_API.g_miss_char THEN
1362: x_complete_rec.state_region_code := l_loc_hier_rec.state_region_code;
1363: END IF;
1364:
1365: IF p_loc_hier_rec.city_id = FND_API.g_miss_char THEN

Line 1365: IF p_loc_hier_rec.city_id = FND_API.g_miss_char THEN

1361: IF p_loc_hier_rec.state_region_code = FND_API.g_miss_char THEN
1362: x_complete_rec.state_region_code := l_loc_hier_rec.state_region_code;
1363: END IF;
1364:
1365: IF p_loc_hier_rec.city_id = FND_API.g_miss_char THEN
1366: x_complete_rec.city_id := l_loc_hier_rec.city_id;
1367: END IF;
1368:
1369: IF p_loc_hier_rec.city_code = FND_API.g_miss_char THEN

Line 1369: IF p_loc_hier_rec.city_code = FND_API.g_miss_char THEN

1365: IF p_loc_hier_rec.city_id = FND_API.g_miss_char THEN
1366: x_complete_rec.city_id := l_loc_hier_rec.city_id;
1367: END IF;
1368:
1369: IF p_loc_hier_rec.city_code = FND_API.g_miss_char THEN
1370: x_complete_rec.city_code := l_loc_hier_rec.city_code;
1371: END IF;
1372:
1373: IF p_loc_hier_rec.postal_code_id = FND_API.g_miss_char THEN

Line 1373: IF p_loc_hier_rec.postal_code_id = FND_API.g_miss_char THEN

1369: IF p_loc_hier_rec.city_code = FND_API.g_miss_char THEN
1370: x_complete_rec.city_code := l_loc_hier_rec.city_code;
1371: END IF;
1372:
1373: IF p_loc_hier_rec.postal_code_id = FND_API.g_miss_char THEN
1374: x_complete_rec.postal_code_id := l_loc_hier_rec.postal_code_id;
1375: END IF;
1376:
1377: END complete_rec;

Line 1395: x_loc_hier_rec.location_hierarchy_id := FND_API.g_miss_num;

1391: IS
1392:
1393: BEGIN
1394:
1395: x_loc_hier_rec.location_hierarchy_id := FND_API.g_miss_num;
1396: x_loc_hier_rec.last_update_date := FND_API.g_miss_date;
1397: x_loc_hier_rec.last_updated_by := FND_API.g_miss_num;
1398: x_loc_hier_rec.creation_date := FND_API.g_miss_date;
1399: x_loc_hier_rec.created_by := FND_API.g_miss_num;

Line 1396: x_loc_hier_rec.last_update_date := FND_API.g_miss_date;

1392:
1393: BEGIN
1394:
1395: x_loc_hier_rec.location_hierarchy_id := FND_API.g_miss_num;
1396: x_loc_hier_rec.last_update_date := FND_API.g_miss_date;
1397: x_loc_hier_rec.last_updated_by := FND_API.g_miss_num;
1398: x_loc_hier_rec.creation_date := FND_API.g_miss_date;
1399: x_loc_hier_rec.created_by := FND_API.g_miss_num;
1400: x_loc_hier_rec.last_update_login := FND_API.g_miss_num;

Line 1397: x_loc_hier_rec.last_updated_by := FND_API.g_miss_num;

1393: BEGIN
1394:
1395: x_loc_hier_rec.location_hierarchy_id := FND_API.g_miss_num;
1396: x_loc_hier_rec.last_update_date := FND_API.g_miss_date;
1397: x_loc_hier_rec.last_updated_by := FND_API.g_miss_num;
1398: x_loc_hier_rec.creation_date := FND_API.g_miss_date;
1399: x_loc_hier_rec.created_by := FND_API.g_miss_num;
1400: x_loc_hier_rec.last_update_login := FND_API.g_miss_num;
1401: x_loc_hier_rec.object_version_number := FND_API.g_miss_num;

Line 1398: x_loc_hier_rec.creation_date := FND_API.g_miss_date;

1394:
1395: x_loc_hier_rec.location_hierarchy_id := FND_API.g_miss_num;
1396: x_loc_hier_rec.last_update_date := FND_API.g_miss_date;
1397: x_loc_hier_rec.last_updated_by := FND_API.g_miss_num;
1398: x_loc_hier_rec.creation_date := FND_API.g_miss_date;
1399: x_loc_hier_rec.created_by := FND_API.g_miss_num;
1400: x_loc_hier_rec.last_update_login := FND_API.g_miss_num;
1401: x_loc_hier_rec.object_version_number := FND_API.g_miss_num;
1402: x_loc_hier_rec.request_id := FND_API.g_miss_num;

Line 1399: x_loc_hier_rec.created_by := FND_API.g_miss_num;

1395: x_loc_hier_rec.location_hierarchy_id := FND_API.g_miss_num;
1396: x_loc_hier_rec.last_update_date := FND_API.g_miss_date;
1397: x_loc_hier_rec.last_updated_by := FND_API.g_miss_num;
1398: x_loc_hier_rec.creation_date := FND_API.g_miss_date;
1399: x_loc_hier_rec.created_by := FND_API.g_miss_num;
1400: x_loc_hier_rec.last_update_login := FND_API.g_miss_num;
1401: x_loc_hier_rec.object_version_number := FND_API.g_miss_num;
1402: x_loc_hier_rec.request_id := FND_API.g_miss_num;
1403: x_loc_hier_rec.program_application_id := FND_API.g_miss_num;

Line 1400: x_loc_hier_rec.last_update_login := FND_API.g_miss_num;

1396: x_loc_hier_rec.last_update_date := FND_API.g_miss_date;
1397: x_loc_hier_rec.last_updated_by := FND_API.g_miss_num;
1398: x_loc_hier_rec.creation_date := FND_API.g_miss_date;
1399: x_loc_hier_rec.created_by := FND_API.g_miss_num;
1400: x_loc_hier_rec.last_update_login := FND_API.g_miss_num;
1401: x_loc_hier_rec.object_version_number := FND_API.g_miss_num;
1402: x_loc_hier_rec.request_id := FND_API.g_miss_num;
1403: x_loc_hier_rec.program_application_id := FND_API.g_miss_num;
1404: x_loc_hier_rec.program_id := FND_API.g_miss_num;

Line 1401: x_loc_hier_rec.object_version_number := FND_API.g_miss_num;

1397: x_loc_hier_rec.last_updated_by := FND_API.g_miss_num;
1398: x_loc_hier_rec.creation_date := FND_API.g_miss_date;
1399: x_loc_hier_rec.created_by := FND_API.g_miss_num;
1400: x_loc_hier_rec.last_update_login := FND_API.g_miss_num;
1401: x_loc_hier_rec.object_version_number := FND_API.g_miss_num;
1402: x_loc_hier_rec.request_id := FND_API.g_miss_num;
1403: x_loc_hier_rec.program_application_id := FND_API.g_miss_num;
1404: x_loc_hier_rec.program_id := FND_API.g_miss_num;
1405: x_loc_hier_rec.program_update_date := FND_API.g_miss_date;

Line 1402: x_loc_hier_rec.request_id := FND_API.g_miss_num;

1398: x_loc_hier_rec.creation_date := FND_API.g_miss_date;
1399: x_loc_hier_rec.created_by := FND_API.g_miss_num;
1400: x_loc_hier_rec.last_update_login := FND_API.g_miss_num;
1401: x_loc_hier_rec.object_version_number := FND_API.g_miss_num;
1402: x_loc_hier_rec.request_id := FND_API.g_miss_num;
1403: x_loc_hier_rec.program_application_id := FND_API.g_miss_num;
1404: x_loc_hier_rec.program_id := FND_API.g_miss_num;
1405: x_loc_hier_rec.program_update_date := FND_API.g_miss_date;
1406: x_loc_hier_rec.created_by_application_id := FND_API.g_miss_num;

Line 1403: x_loc_hier_rec.program_application_id := FND_API.g_miss_num;

1399: x_loc_hier_rec.created_by := FND_API.g_miss_num;
1400: x_loc_hier_rec.last_update_login := FND_API.g_miss_num;
1401: x_loc_hier_rec.object_version_number := FND_API.g_miss_num;
1402: x_loc_hier_rec.request_id := FND_API.g_miss_num;
1403: x_loc_hier_rec.program_application_id := FND_API.g_miss_num;
1404: x_loc_hier_rec.program_id := FND_API.g_miss_num;
1405: x_loc_hier_rec.program_update_date := FND_API.g_miss_date;
1406: x_loc_hier_rec.created_by_application_id := FND_API.g_miss_num;
1407: x_loc_hier_rec.location_type_code := FND_API.g_miss_char;

Line 1404: x_loc_hier_rec.program_id := FND_API.g_miss_num;

1400: x_loc_hier_rec.last_update_login := FND_API.g_miss_num;
1401: x_loc_hier_rec.object_version_number := FND_API.g_miss_num;
1402: x_loc_hier_rec.request_id := FND_API.g_miss_num;
1403: x_loc_hier_rec.program_application_id := FND_API.g_miss_num;
1404: x_loc_hier_rec.program_id := FND_API.g_miss_num;
1405: x_loc_hier_rec.program_update_date := FND_API.g_miss_date;
1406: x_loc_hier_rec.created_by_application_id := FND_API.g_miss_num;
1407: x_loc_hier_rec.location_type_code := FND_API.g_miss_char;
1408: x_loc_hier_rec.start_date_active := FND_API.g_miss_date;

Line 1405: x_loc_hier_rec.program_update_date := FND_API.g_miss_date;

1401: x_loc_hier_rec.object_version_number := FND_API.g_miss_num;
1402: x_loc_hier_rec.request_id := FND_API.g_miss_num;
1403: x_loc_hier_rec.program_application_id := FND_API.g_miss_num;
1404: x_loc_hier_rec.program_id := FND_API.g_miss_num;
1405: x_loc_hier_rec.program_update_date := FND_API.g_miss_date;
1406: x_loc_hier_rec.created_by_application_id := FND_API.g_miss_num;
1407: x_loc_hier_rec.location_type_code := FND_API.g_miss_char;
1408: x_loc_hier_rec.start_date_active := FND_API.g_miss_date;
1409: x_loc_hier_rec.end_date_active := FND_API.g_miss_date;

Line 1406: x_loc_hier_rec.created_by_application_id := FND_API.g_miss_num;

1402: x_loc_hier_rec.request_id := FND_API.g_miss_num;
1403: x_loc_hier_rec.program_application_id := FND_API.g_miss_num;
1404: x_loc_hier_rec.program_id := FND_API.g_miss_num;
1405: x_loc_hier_rec.program_update_date := FND_API.g_miss_date;
1406: x_loc_hier_rec.created_by_application_id := FND_API.g_miss_num;
1407: x_loc_hier_rec.location_type_code := FND_API.g_miss_char;
1408: x_loc_hier_rec.start_date_active := FND_API.g_miss_date;
1409: x_loc_hier_rec.end_date_active := FND_API.g_miss_date;
1410: x_loc_hier_rec.area1_id := FND_API.g_miss_num;

Line 1407: x_loc_hier_rec.location_type_code := FND_API.g_miss_char;

1403: x_loc_hier_rec.program_application_id := FND_API.g_miss_num;
1404: x_loc_hier_rec.program_id := FND_API.g_miss_num;
1405: x_loc_hier_rec.program_update_date := FND_API.g_miss_date;
1406: x_loc_hier_rec.created_by_application_id := FND_API.g_miss_num;
1407: x_loc_hier_rec.location_type_code := FND_API.g_miss_char;
1408: x_loc_hier_rec.start_date_active := FND_API.g_miss_date;
1409: x_loc_hier_rec.end_date_active := FND_API.g_miss_date;
1410: x_loc_hier_rec.area1_id := FND_API.g_miss_num;
1411: x_loc_hier_rec.area1_code := FND_API.g_miss_char;

Line 1408: x_loc_hier_rec.start_date_active := FND_API.g_miss_date;

1404: x_loc_hier_rec.program_id := FND_API.g_miss_num;
1405: x_loc_hier_rec.program_update_date := FND_API.g_miss_date;
1406: x_loc_hier_rec.created_by_application_id := FND_API.g_miss_num;
1407: x_loc_hier_rec.location_type_code := FND_API.g_miss_char;
1408: x_loc_hier_rec.start_date_active := FND_API.g_miss_date;
1409: x_loc_hier_rec.end_date_active := FND_API.g_miss_date;
1410: x_loc_hier_rec.area1_id := FND_API.g_miss_num;
1411: x_loc_hier_rec.area1_code := FND_API.g_miss_char;
1412: x_loc_hier_rec.area2_id := FND_API.g_miss_num;

Line 1409: x_loc_hier_rec.end_date_active := FND_API.g_miss_date;

1405: x_loc_hier_rec.program_update_date := FND_API.g_miss_date;
1406: x_loc_hier_rec.created_by_application_id := FND_API.g_miss_num;
1407: x_loc_hier_rec.location_type_code := FND_API.g_miss_char;
1408: x_loc_hier_rec.start_date_active := FND_API.g_miss_date;
1409: x_loc_hier_rec.end_date_active := FND_API.g_miss_date;
1410: x_loc_hier_rec.area1_id := FND_API.g_miss_num;
1411: x_loc_hier_rec.area1_code := FND_API.g_miss_char;
1412: x_loc_hier_rec.area2_id := FND_API.g_miss_num;
1413: x_loc_hier_rec.area2_code := FND_API.g_miss_char;

Line 1410: x_loc_hier_rec.area1_id := FND_API.g_miss_num;

1406: x_loc_hier_rec.created_by_application_id := FND_API.g_miss_num;
1407: x_loc_hier_rec.location_type_code := FND_API.g_miss_char;
1408: x_loc_hier_rec.start_date_active := FND_API.g_miss_date;
1409: x_loc_hier_rec.end_date_active := FND_API.g_miss_date;
1410: x_loc_hier_rec.area1_id := FND_API.g_miss_num;
1411: x_loc_hier_rec.area1_code := FND_API.g_miss_char;
1412: x_loc_hier_rec.area2_id := FND_API.g_miss_num;
1413: x_loc_hier_rec.area2_code := FND_API.g_miss_char;
1414: x_loc_hier_rec.country_id := FND_API.g_miss_num;

Line 1411: x_loc_hier_rec.area1_code := FND_API.g_miss_char;

1407: x_loc_hier_rec.location_type_code := FND_API.g_miss_char;
1408: x_loc_hier_rec.start_date_active := FND_API.g_miss_date;
1409: x_loc_hier_rec.end_date_active := FND_API.g_miss_date;
1410: x_loc_hier_rec.area1_id := FND_API.g_miss_num;
1411: x_loc_hier_rec.area1_code := FND_API.g_miss_char;
1412: x_loc_hier_rec.area2_id := FND_API.g_miss_num;
1413: x_loc_hier_rec.area2_code := FND_API.g_miss_char;
1414: x_loc_hier_rec.country_id := FND_API.g_miss_num;
1415: x_loc_hier_rec.country_code := FND_API.g_miss_char;

Line 1412: x_loc_hier_rec.area2_id := FND_API.g_miss_num;

1408: x_loc_hier_rec.start_date_active := FND_API.g_miss_date;
1409: x_loc_hier_rec.end_date_active := FND_API.g_miss_date;
1410: x_loc_hier_rec.area1_id := FND_API.g_miss_num;
1411: x_loc_hier_rec.area1_code := FND_API.g_miss_char;
1412: x_loc_hier_rec.area2_id := FND_API.g_miss_num;
1413: x_loc_hier_rec.area2_code := FND_API.g_miss_char;
1414: x_loc_hier_rec.country_id := FND_API.g_miss_num;
1415: x_loc_hier_rec.country_code := FND_API.g_miss_char;
1416: x_loc_hier_rec.country_region_id := FND_API.g_miss_num;

Line 1413: x_loc_hier_rec.area2_code := FND_API.g_miss_char;

1409: x_loc_hier_rec.end_date_active := FND_API.g_miss_date;
1410: x_loc_hier_rec.area1_id := FND_API.g_miss_num;
1411: x_loc_hier_rec.area1_code := FND_API.g_miss_char;
1412: x_loc_hier_rec.area2_id := FND_API.g_miss_num;
1413: x_loc_hier_rec.area2_code := FND_API.g_miss_char;
1414: x_loc_hier_rec.country_id := FND_API.g_miss_num;
1415: x_loc_hier_rec.country_code := FND_API.g_miss_char;
1416: x_loc_hier_rec.country_region_id := FND_API.g_miss_num;
1417: x_loc_hier_rec.country_region_code := FND_API.g_miss_char;

Line 1414: x_loc_hier_rec.country_id := FND_API.g_miss_num;

1410: x_loc_hier_rec.area1_id := FND_API.g_miss_num;
1411: x_loc_hier_rec.area1_code := FND_API.g_miss_char;
1412: x_loc_hier_rec.area2_id := FND_API.g_miss_num;
1413: x_loc_hier_rec.area2_code := FND_API.g_miss_char;
1414: x_loc_hier_rec.country_id := FND_API.g_miss_num;
1415: x_loc_hier_rec.country_code := FND_API.g_miss_char;
1416: x_loc_hier_rec.country_region_id := FND_API.g_miss_num;
1417: x_loc_hier_rec.country_region_code := FND_API.g_miss_char;
1418: x_loc_hier_rec.state_id := FND_API.g_miss_num;

Line 1415: x_loc_hier_rec.country_code := FND_API.g_miss_char;

1411: x_loc_hier_rec.area1_code := FND_API.g_miss_char;
1412: x_loc_hier_rec.area2_id := FND_API.g_miss_num;
1413: x_loc_hier_rec.area2_code := FND_API.g_miss_char;
1414: x_loc_hier_rec.country_id := FND_API.g_miss_num;
1415: x_loc_hier_rec.country_code := FND_API.g_miss_char;
1416: x_loc_hier_rec.country_region_id := FND_API.g_miss_num;
1417: x_loc_hier_rec.country_region_code := FND_API.g_miss_char;
1418: x_loc_hier_rec.state_id := FND_API.g_miss_num;
1419: x_loc_hier_rec.state_code := FND_API.g_miss_char;

Line 1416: x_loc_hier_rec.country_region_id := FND_API.g_miss_num;

1412: x_loc_hier_rec.area2_id := FND_API.g_miss_num;
1413: x_loc_hier_rec.area2_code := FND_API.g_miss_char;
1414: x_loc_hier_rec.country_id := FND_API.g_miss_num;
1415: x_loc_hier_rec.country_code := FND_API.g_miss_char;
1416: x_loc_hier_rec.country_region_id := FND_API.g_miss_num;
1417: x_loc_hier_rec.country_region_code := FND_API.g_miss_char;
1418: x_loc_hier_rec.state_id := FND_API.g_miss_num;
1419: x_loc_hier_rec.state_code := FND_API.g_miss_char;
1420: x_loc_hier_rec.state_region_id := FND_API.g_miss_num;

Line 1417: x_loc_hier_rec.country_region_code := FND_API.g_miss_char;

1413: x_loc_hier_rec.area2_code := FND_API.g_miss_char;
1414: x_loc_hier_rec.country_id := FND_API.g_miss_num;
1415: x_loc_hier_rec.country_code := FND_API.g_miss_char;
1416: x_loc_hier_rec.country_region_id := FND_API.g_miss_num;
1417: x_loc_hier_rec.country_region_code := FND_API.g_miss_char;
1418: x_loc_hier_rec.state_id := FND_API.g_miss_num;
1419: x_loc_hier_rec.state_code := FND_API.g_miss_char;
1420: x_loc_hier_rec.state_region_id := FND_API.g_miss_num;
1421: x_loc_hier_rec.state_region_code := FND_API.g_miss_char;

Line 1418: x_loc_hier_rec.state_id := FND_API.g_miss_num;

1414: x_loc_hier_rec.country_id := FND_API.g_miss_num;
1415: x_loc_hier_rec.country_code := FND_API.g_miss_char;
1416: x_loc_hier_rec.country_region_id := FND_API.g_miss_num;
1417: x_loc_hier_rec.country_region_code := FND_API.g_miss_char;
1418: x_loc_hier_rec.state_id := FND_API.g_miss_num;
1419: x_loc_hier_rec.state_code := FND_API.g_miss_char;
1420: x_loc_hier_rec.state_region_id := FND_API.g_miss_num;
1421: x_loc_hier_rec.state_region_code := FND_API.g_miss_char;
1422: x_loc_hier_rec.city_id := FND_API.g_miss_num;

Line 1419: x_loc_hier_rec.state_code := FND_API.g_miss_char;

1415: x_loc_hier_rec.country_code := FND_API.g_miss_char;
1416: x_loc_hier_rec.country_region_id := FND_API.g_miss_num;
1417: x_loc_hier_rec.country_region_code := FND_API.g_miss_char;
1418: x_loc_hier_rec.state_id := FND_API.g_miss_num;
1419: x_loc_hier_rec.state_code := FND_API.g_miss_char;
1420: x_loc_hier_rec.state_region_id := FND_API.g_miss_num;
1421: x_loc_hier_rec.state_region_code := FND_API.g_miss_char;
1422: x_loc_hier_rec.city_id := FND_API.g_miss_num;
1423: x_loc_hier_rec.city_code := FND_API.g_miss_char;

Line 1420: x_loc_hier_rec.state_region_id := FND_API.g_miss_num;

1416: x_loc_hier_rec.country_region_id := FND_API.g_miss_num;
1417: x_loc_hier_rec.country_region_code := FND_API.g_miss_char;
1418: x_loc_hier_rec.state_id := FND_API.g_miss_num;
1419: x_loc_hier_rec.state_code := FND_API.g_miss_char;
1420: x_loc_hier_rec.state_region_id := FND_API.g_miss_num;
1421: x_loc_hier_rec.state_region_code := FND_API.g_miss_char;
1422: x_loc_hier_rec.city_id := FND_API.g_miss_num;
1423: x_loc_hier_rec.city_code := FND_API.g_miss_char;
1424: x_loc_hier_rec.postal_code_id := FND_API.g_miss_num;

Line 1421: x_loc_hier_rec.state_region_code := FND_API.g_miss_char;

1417: x_loc_hier_rec.country_region_code := FND_API.g_miss_char;
1418: x_loc_hier_rec.state_id := FND_API.g_miss_num;
1419: x_loc_hier_rec.state_code := FND_API.g_miss_char;
1420: x_loc_hier_rec.state_region_id := FND_API.g_miss_num;
1421: x_loc_hier_rec.state_region_code := FND_API.g_miss_char;
1422: x_loc_hier_rec.city_id := FND_API.g_miss_num;
1423: x_loc_hier_rec.city_code := FND_API.g_miss_char;
1424: x_loc_hier_rec.postal_code_id := FND_API.g_miss_num;
1425:

Line 1422: x_loc_hier_rec.city_id := FND_API.g_miss_num;

1418: x_loc_hier_rec.state_id := FND_API.g_miss_num;
1419: x_loc_hier_rec.state_code := FND_API.g_miss_char;
1420: x_loc_hier_rec.state_region_id := FND_API.g_miss_num;
1421: x_loc_hier_rec.state_region_code := FND_API.g_miss_char;
1422: x_loc_hier_rec.city_id := FND_API.g_miss_num;
1423: x_loc_hier_rec.city_code := FND_API.g_miss_char;
1424: x_loc_hier_rec.postal_code_id := FND_API.g_miss_num;
1425:
1426: END init_rec;

Line 1423: x_loc_hier_rec.city_code := FND_API.g_miss_char;

1419: x_loc_hier_rec.state_code := FND_API.g_miss_char;
1420: x_loc_hier_rec.state_region_id := FND_API.g_miss_num;
1421: x_loc_hier_rec.state_region_code := FND_API.g_miss_char;
1422: x_loc_hier_rec.city_id := FND_API.g_miss_num;
1423: x_loc_hier_rec.city_code := FND_API.g_miss_char;
1424: x_loc_hier_rec.postal_code_id := FND_API.g_miss_num;
1425:
1426: END init_rec;
1427:

Line 1424: x_loc_hier_rec.postal_code_id := FND_API.g_miss_num;

1420: x_loc_hier_rec.state_region_id := FND_API.g_miss_num;
1421: x_loc_hier_rec.state_region_code := FND_API.g_miss_char;
1422: x_loc_hier_rec.city_id := FND_API.g_miss_num;
1423: x_loc_hier_rec.city_code := FND_API.g_miss_char;
1424: x_loc_hier_rec.postal_code_id := FND_API.g_miss_num;
1425:
1426: END init_rec;
1427:
1428: END JTF_Loc_Hierarchies_PVT;