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_MSG_PUB

Line 49: FND_MSG_PUB.initialize;

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

Line 181: FND_MSG_PUB.count_and_get

177: IF FND_API.to_boolean(p_commit) THEN
178: COMMIT;
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

Line 195: FND_MSG_PUB.count_and_get

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

Line 205: FND_MSG_PUB.count_and_get

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

Line 215: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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
219: (

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

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
219: (
220: p_encoded => FND_API.g_false,

Line 218: FND_MSG_PUB.count_and_get

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
219: (
220: p_encoded => FND_API.g_false,
221: p_count => x_msg_count,
222: p_data => x_msg_data

Line 261: FND_MSG_PUB.initialize;

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

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

352: WHERE location_hierarchy_id = l_loc_hier_rec.location_hierarchy_id
353: AND object_version_number = l_loc_hier_rec.object_version_number;
354:
355: IF (SQL%NOTFOUND) THEN
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;

Line 358: FND_MSG_PUB.add;

354:
355: IF (SQL%NOTFOUND) THEN
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:

Line 368: FND_MSG_PUB.count_and_get

364: IF FND_API.to_boolean(p_commit) THEN
365: COMMIT;
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

Line 382: FND_MSG_PUB.count_and_get

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

Line 392: FND_MSG_PUB.count_and_get

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

Line 402: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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
406: (

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

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
406: (
407: p_encoded => FND_API.g_false,

Line 405: FND_MSG_PUB.count_and_get

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
406: (
407: p_encoded => FND_API.g_false,
408: p_count => x_msg_count,
409: p_data => x_msg_data

Line 447: FND_MSG_PUB.initialize;

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
451: (

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

467: WHERE location_hierarchy_id = p_hier_id
468: AND object_version_number = p_object_version;
469:
470: IF (SQL%NOTFOUND) THEN
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;

Line 473: FND_MSG_PUB.add;

469:
470: IF (SQL%NOTFOUND) THEN
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:

Line 483: FND_MSG_PUB.count_and_get

479: IF FND_API.to_boolean(p_commit) THEN
480: COMMIT;
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

Line 497: FND_MSG_PUB.count_and_get

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

Line 507: FND_MSG_PUB.count_and_get

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

Line 517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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
521: (

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

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
521: (
522: p_encoded => FND_API.g_false,

Line 520: FND_MSG_PUB.count_and_get

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
521: (
522: p_encoded => FND_API.g_false,
523: p_count => x_msg_count,
524: p_data => x_msg_data

Line 567: FND_MSG_PUB.initialize;

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
571: (

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

586: OPEN c_hier;
587: FETCH c_hier INTO l_hier_id;
588: IF (c_hier%NOTFOUND) THEN
589: CLOSE c_hier;
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;

Line 592: FND_MSG_PUB.add;

588: IF (c_hier%NOTFOUND) THEN
589: CLOSE c_hier;
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;

Line 599: FND_MSG_PUB.count_and_get

595: END IF;
596: CLOSE c_hier;
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

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

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;
616: FND_MSG_PUB.count_and_get

Line 614: FND_MSG_PUB.add;

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;
616: FND_MSG_PUB.count_and_get
617: (
618: p_encoded => FND_API.g_false,

Line 616: FND_MSG_PUB.count_and_get

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;
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

Line 625: FND_MSG_PUB.count_and_get

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

Line 634: FND_MSG_PUB.count_and_get

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

Line 643: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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
647: (

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

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
647: (
648: p_encoded => FND_API.g_false,

Line 646: FND_MSG_PUB.count_and_get

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
647: (
648: p_encoded => FND_API.g_false,
649: p_count => x_msg_count,
650: p_data => x_msg_data

Line 737: FND_MSG_PUB.count_and_get

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

Line 749: FND_MSG_PUB.count_and_get

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

Line 758: FND_MSG_PUB.count_and_get

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

Line 767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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:
771: FND_MSG_PUB.count_and_get

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

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:
771: FND_MSG_PUB.count_and_get
772: (

Line 771: FND_MSG_PUB.count_and_get

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

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

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
866: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
867: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_NO_LOC_HIER_ID');
868: FND_MSG_PUB.add;
869: END IF;
870:

Line 868: FND_MSG_PUB.add;

864: IF p_loc_hier_rec.location_hierarchy_id IS NULL
865: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
866: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

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

875: -- check object_version_number
876: IF p_loc_hier_rec.object_version_number IS NULL
877: AND p_validation_mode = JTF_PLSQL_API.g_update
878: THEN
879: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
880: FND_MESSAGE.set_name('JTF', 'JTF_NO_OBJ_VER_NUM');
881: FND_MSG_PUB.add;
882: END IF;
883:

Line 881: FND_MSG_PUB.add;

877: AND p_validation_mode = JTF_PLSQL_API.g_update
878: THEN
879: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

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

886: END IF;
887:
888: -- check created_by_application_id
889: IF p_loc_hier_rec.created_by_application_id IS NULL THEN
890: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
891: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_NO_CR_BY_APP_ID');
892: FND_MSG_PUB.add;
893: END IF;
894:

Line 892: FND_MSG_PUB.add;

888: -- check created_by_application_id
889: IF p_loc_hier_rec.created_by_application_id IS NULL THEN
890: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

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

897: END IF;
898:
899: -- check location_type_code
900: IF p_loc_hier_rec.location_type_code IS NULL THEN
901: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
902: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_NO_LOC_TYPE_CODE');
903: FND_MSG_PUB.add;
904: END IF;
905:

Line 903: FND_MSG_PUB.add;

899: -- check location_type_code
900: IF p_loc_hier_rec.location_type_code IS NULL THEN
901: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

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

908: END IF;
909:
910: -- check start_date_active
911: IF p_loc_hier_rec.start_date_active IS NULL THEN
912: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
913: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_NO_STAT_DATE');
914: FND_MSG_PUB.add;
915: END IF;
916:

Line 914: FND_MSG_PUB.add;

910: -- check start_date_active
911: IF p_loc_hier_rec.start_date_active IS NULL THEN
912: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

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

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;
960:

Line 958: FND_MSG_PUB.add;

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;
960:
961: x_return_status := FND_API.g_ret_sts_error;
962: RETURN;

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

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;
1002:

Line 1000: FND_MSG_PUB.add;

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;
1002:
1003: x_return_status := FND_API.g_ret_sts_error;
1004: RETURN;

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

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;
1022:

Line 1020: FND_MSG_PUB.add;

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;
1022:
1023: x_return_status := FND_API.g_ret_sts_error;
1024: RETURN;

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

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;
1044:

Line 1042: FND_MSG_PUB.add;

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;
1044:
1045: x_return_status := FND_API.g_ret_sts_error;
1046: RETURN;

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

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;
1066:

Line 1064: FND_MSG_PUB.add;

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;
1066:
1067: x_return_status := FND_API.g_ret_sts_error;
1068: RETURN;

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

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;
1088:

Line 1086: FND_MSG_PUB.add;

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;
1088:
1089: x_return_status := FND_API.g_ret_sts_error;
1090: RETURN;

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

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;
1110:

Line 1108: FND_MSG_PUB.add;

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;
1110:
1111: x_return_status := FND_API.g_ret_sts_error;
1112: RETURN;

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

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;
1132:

Line 1130: FND_MSG_PUB.add;

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;
1132:
1133: x_return_status := FND_API.g_ret_sts_error;
1134: RETURN;

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

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;
1154:

Line 1152: FND_MSG_PUB.add;

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;
1154:
1155: x_return_status := FND_API.g_ret_sts_error;
1156: RETURN;

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

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;
1177:

Line 1175: FND_MSG_PUB.add;

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;
1177:
1178: x_return_status := FND_API.g_ret_sts_error;
1179: RETURN;

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

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;
1197:

Line 1195: FND_MSG_PUB.add;

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;
1197:
1198: x_return_status := FND_API.g_ret_sts_error;
1199: RETURN;

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

1232: THEN
1233: l_start_date := p_complete_rec.start_date_active;
1234: l_end_date := p_complete_rec.end_date_active;
1235: IF l_start_date > l_end_date THEN
1236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1237: FND_MESSAGE.set_name('JTF', 'JTF_START_DATE_AFTER_END_DATE');
1238: FND_MSG_PUB.add;
1239: END IF;
1240:

Line 1238: FND_MSG_PUB.add;

1234: l_end_date := p_complete_rec.end_date_active;
1235: IF l_start_date > l_end_date THEN
1236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

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

1272: OPEN c_hier;
1273: FETCH c_hier INTO l_loc_hier_rec;
1274: IF (c_hier%NOTFOUND) THEN
1275: CLOSE c_hier;
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;

Line 1278: FND_MSG_PUB.add;

1274: IF (c_hier%NOTFOUND) THEN
1275: CLOSE c_hier;
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;