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_POSTAL_CODES_PVT dependencies on FND_MSG_PUB

Line 49: FND_MSG_PUB.initialize;

45: -- initialize
46: SAVEPOINT create_postal_code;
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 147: FND_MSG_PUB.count_and_get

143: IF FND_API.to_boolean(p_commit) THEN
144: COMMIT;
145: END IF;
146:
147: FND_MSG_PUB.count_and_get
148: (
149: p_encoded => FND_API.g_false,
150: p_count => x_msg_count,
151: p_data => x_msg_data

Line 161: FND_MSG_PUB.count_and_get

157:
158: WHEN FND_API.g_exc_error THEN
159: ROLLBACK TO create_postal_code;
160: x_return_status := FND_API.g_ret_sts_error;
161: FND_MSG_PUB.count_and_get
162: (
163: p_encoded => FND_API.g_false,
164: p_count => x_msg_count,
165: p_data => x_msg_data

Line 171: FND_MSG_PUB.count_and_get

167:
168: WHEN FND_API.g_exc_unexpected_error THEN
169: ROLLBACK TO create_postal_code;
170: x_return_status := FND_API.g_ret_sts_unexp_error;
171: FND_MSG_PUB.count_and_get
172: (
173: p_encoded => FND_API.g_false,
174: p_count => x_msg_count,
175: p_data => x_msg_data

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

177:
178: WHEN OTHERS THEN
179: ROLLBACK TO create_postal_code;
180: x_return_status :=FND_API.g_ret_sts_unexp_error;
181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
182: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
183: END IF;
184: FND_MSG_PUB.count_and_get
185: (

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

178: WHEN OTHERS THEN
179: ROLLBACK TO create_postal_code;
180: x_return_status :=FND_API.g_ret_sts_unexp_error;
181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
182: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
183: END IF;
184: FND_MSG_PUB.count_and_get
185: (
186: p_encoded => FND_API.g_false,

Line 184: FND_MSG_PUB.count_and_get

180: x_return_status :=FND_API.g_ret_sts_unexp_error;
181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
182: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
183: END IF;
184: FND_MSG_PUB.count_and_get
185: (
186: p_encoded => FND_API.g_false,
187: p_count => x_msg_count,
188: p_data => x_msg_data

Line 228: FND_MSG_PUB.initialize;

224: -- initialize
225: SAVEPOINT update_postal_code;
226:
227: IF FND_API.to_boolean(p_init_msg_list) THEN
228: FND_MSG_PUB.initialize;
229: END IF;
230:
231: JTF_Utility_PVT.debug_message(l_full_name || ': start');
232:

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

312: AND object_version_number = l_postal_code_rec.object_version_number;
313: END IF;
314:
315: IF (SQL%NOTFOUND) THEN
316: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
317: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
318: FND_MSG_PUB.add;
319: END IF;
320: RAISE FND_API.g_exc_error;

Line 318: FND_MSG_PUB.add;

314:
315: IF (SQL%NOTFOUND) THEN
316: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
317: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
318: FND_MSG_PUB.add;
319: END IF;
320: RAISE FND_API.g_exc_error;
321: END IF;
322:

Line 328: FND_MSG_PUB.count_and_get

324: IF FND_API.to_boolean(p_commit) THEN
325: COMMIT;
326: END IF;
327:
328: FND_MSG_PUB.count_and_get
329: (
330: P_ENCODED => FND_API.g_false,
331: p_count => x_msg_count,
332: p_data => x_msg_data

Line 342: FND_MSG_PUB.count_and_get

338:
339: WHEN FND_API.g_exc_error THEN
340: ROLLBACK TO update_postal_code;
341: x_return_status := FND_API.g_ret_sts_error;
342: FND_MSG_PUB.count_and_get
343: (
344: p_encoded => FND_API.g_false,
345: p_count => x_msg_count,
346: p_data => x_msg_data

Line 352: FND_MSG_PUB.count_and_get

348:
349: WHEN FND_API.g_exc_unexpected_error THEN
350: ROLLBACK TO update_postal_code;
351: x_return_status := FND_API.g_ret_sts_unexp_error;
352: FND_MSG_PUB.count_and_get
353: (
354: p_encoded => FND_API.g_false,
355: p_count => x_msg_count,
356: p_data => x_msg_data

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

358:
359: WHEN OTHERS THEN
360: ROLLBACK TO update_postal_code;
361: x_return_status :=FND_API.g_ret_sts_unexp_error;
362: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
363: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
364: END IF;
365: FND_MSG_PUB.count_and_get
366: (

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

359: WHEN OTHERS THEN
360: ROLLBACK TO update_postal_code;
361: x_return_status :=FND_API.g_ret_sts_unexp_error;
362: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
363: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
364: END IF;
365: FND_MSG_PUB.count_and_get
366: (
367: p_encoded => FND_API.g_false,

Line 365: FND_MSG_PUB.count_and_get

361: x_return_status :=FND_API.g_ret_sts_unexp_error;
362: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
363: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
364: END IF;
365: FND_MSG_PUB.count_and_get
366: (
367: p_encoded => FND_API.g_false,
368: p_count => x_msg_count,
369: p_data => x_msg_data

Line 405: FND_MSG_PUB.initialize;

401: -- initialize
402: SAVEPOINT delete_postal_code;
403:
404: IF FND_API.to_boolean(p_init_msg_list) THEN
405: FND_MSG_PUB.initialize;
406: END IF;
407:
408: JTF_Utility_PVT.debug_message(l_full_name || ': start');
409:

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

427: WHERE location_postal_code_id = p_postal_code_id
428: AND object_version_number = p_object_version;
429:
430: IF (SQL%NOTFOUND) THEN
431: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
432: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
433: FND_MSG_PUB.add;
434: END IF;
435: RAISE FND_API.g_exc_error;

Line 433: FND_MSG_PUB.add;

429:
430: IF (SQL%NOTFOUND) THEN
431: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
432: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
433: FND_MSG_PUB.add;
434: END IF;
435: RAISE FND_API.g_exc_error;
436: END IF;
437:

Line 443: FND_MSG_PUB.count_and_get

439: IF FND_API.to_boolean(p_commit) THEN
440: COMMIT;
441: END IF;
442:
443: FND_MSG_PUB.count_and_get
444: (
445: P_ENCODED => FND_API.g_false,
446: p_count => x_msg_count,
447: p_data => x_msg_data

Line 457: FND_MSG_PUB.count_and_get

453:
454: WHEN FND_API.g_exc_error THEN
455: ROLLBACK TO delete_postal_code;
456: x_return_status := FND_API.g_ret_sts_error;
457: FND_MSG_PUB.count_and_get
458: (
459: p_encoded => FND_API.g_false,
460: p_count => x_msg_count,
461: p_data => x_msg_data

Line 467: FND_MSG_PUB.count_and_get

463:
464: WHEN FND_API.g_exc_unexpected_error THEN
465: ROLLBACK TO delete_postal_code;
466: x_return_status := FND_API.g_ret_sts_unexp_error;
467: FND_MSG_PUB.count_and_get
468: (
469: p_encoded => FND_API.g_false,
470: p_count => x_msg_count,
471: p_data => x_msg_data

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

473:
474: WHEN OTHERS THEN
475: ROLLBACK TO delete_postal_code;
476: x_return_status :=FND_API.g_ret_sts_unexp_error;
477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
478: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
479: END IF;
480: FND_MSG_PUB.count_and_get
481: (

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

474: WHEN OTHERS THEN
475: ROLLBACK TO delete_postal_code;
476: x_return_status :=FND_API.g_ret_sts_unexp_error;
477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
478: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
479: END IF;
480: FND_MSG_PUB.count_and_get
481: (
482: p_encoded => FND_API.g_false,

Line 480: FND_MSG_PUB.count_and_get

476: x_return_status :=FND_API.g_ret_sts_unexp_error;
477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
478: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
479: END IF;
480: FND_MSG_PUB.count_and_get
481: (
482: p_encoded => FND_API.g_false,
483: p_count => x_msg_count,
484: p_data => x_msg_data

Line 527: FND_MSG_PUB.initialize;

523: -- initialize
524: JTF_Utility_PVT.debug_message(l_full_name || ': start');
525:
526: IF FND_API.to_boolean(p_init_msg_list) THEN
527: FND_MSG_PUB.initialize;
528: END IF;
529:
530: IF NOT FND_API.compatible_api_call
531: (

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

546: OPEN c_postal_code;
547: FETCH c_postal_code INTO l_postal_code_id;
548: IF (c_postal_code%NOTFOUND) THEN
549: CLOSE c_postal_code;
550: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
551: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
552: FND_MSG_PUB.add;
553: END IF;
554: RAISE FND_API.g_exc_error;

Line 552: FND_MSG_PUB.add;

548: IF (c_postal_code%NOTFOUND) THEN
549: CLOSE c_postal_code;
550: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
551: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
552: FND_MSG_PUB.add;
553: END IF;
554: RAISE FND_API.g_exc_error;
555: END IF;
556: CLOSE c_postal_code;

Line 559: FND_MSG_PUB.count_and_get

555: END IF;
556: CLOSE c_postal_code;
557:
558: -- finish
559: FND_MSG_PUB.count_and_get
560: (
561: p_encoded => FND_API.g_false,
562: p_count => x_msg_count,
563: p_data => x_msg_data

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

568: EXCEPTION
569:
570: WHEN JTF_Utility_PVT.resource_locked THEN
571: x_return_status := FND_API.g_ret_sts_error;
572: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
573: FND_MESSAGE.set_name('JTF', 'JTF_API_RESOURCE_LOCKED');
574: FND_MSG_PUB.add;
575: END IF;
576: FND_MSG_PUB.count_and_get

Line 574: FND_MSG_PUB.add;

570: WHEN JTF_Utility_PVT.resource_locked THEN
571: x_return_status := FND_API.g_ret_sts_error;
572: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
573: FND_MESSAGE.set_name('JTF', 'JTF_API_RESOURCE_LOCKED');
574: FND_MSG_PUB.add;
575: END IF;
576: FND_MSG_PUB.count_and_get
577: (
578: p_encoded => FND_API.g_false,

Line 576: FND_MSG_PUB.count_and_get

572: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
573: FND_MESSAGE.set_name('JTF', 'JTF_API_RESOURCE_LOCKED');
574: FND_MSG_PUB.add;
575: END IF;
576: FND_MSG_PUB.count_and_get
577: (
578: p_encoded => FND_API.g_false,
579: p_count => x_msg_count,
580: p_data => x_msg_data

Line 585: FND_MSG_PUB.count_and_get

581: );
582:
583: WHEN FND_API.g_exc_error THEN
584: x_return_status := FND_API.g_ret_sts_error;
585: FND_MSG_PUB.count_and_get
586: (
587: p_encoded => FND_API.g_false,
588: p_count => x_msg_count,
589: p_data => x_msg_data

Line 594: FND_MSG_PUB.count_and_get

590: );
591:
592: WHEN FND_API.g_exc_unexpected_error THEN
593: x_return_status := FND_API.g_ret_sts_unexp_error;
594: FND_MSG_PUB.count_and_get
595: (
596: p_encoded => FND_API.g_false,
597: p_count => x_msg_count,
598: p_data => x_msg_data

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

599: );
600:
601: WHEN OTHERS THEN
602: x_return_status :=FND_API.g_ret_sts_unexp_error;
603: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
604: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
605: END IF;
606: FND_MSG_PUB.count_and_get
607: (

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

600:
601: WHEN OTHERS THEN
602: x_return_status :=FND_API.g_ret_sts_unexp_error;
603: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
604: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
605: END IF;
606: FND_MSG_PUB.count_and_get
607: (
608: p_encoded => FND_API.g_false,

Line 606: FND_MSG_PUB.count_and_get

602: x_return_status :=FND_API.g_ret_sts_unexp_error;
603: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
604: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
605: END IF;
606: FND_MSG_PUB.count_and_get
607: (
608: p_encoded => FND_API.g_false,
609: p_count => x_msg_count,
610: p_data => x_msg_data

Line 697: FND_MSG_PUB.count_and_get

693: END IF;
694: END IF;
695:
696: -------------------- finish --------------------------
697: FND_MSG_PUB.count_and_get
698: (
699: p_encoded => FND_API.g_false,
700: p_count => x_msg_count,
701: p_data => x_msg_data

Line 709: FND_MSG_PUB.count_and_get

705:
706: EXCEPTION
707: WHEN FND_API.g_exc_error THEN
708: x_return_status := FND_API.g_ret_sts_error;
709: FND_MSG_PUB.count_and_get
710: (
711: p_encoded => FND_API.g_false,
712: p_count => x_msg_count,
713: p_data => x_msg_data

Line 718: FND_MSG_PUB.count_and_get

714: );
715:
716: WHEN FND_API.g_exc_unexpected_error THEN
717: x_return_status := FND_API.g_ret_sts_unexp_error ;
718: FND_MSG_PUB.count_and_get
719: (
720: p_encoded => FND_API.g_false,
721: p_count => x_msg_count,
722: p_data => x_msg_data

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

723: );
724:
725: WHEN OTHERS THEN
726: x_return_status := FND_API.g_ret_sts_unexp_error;
727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
728: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
729: END IF;
730:
731: FND_MSG_PUB.count_and_get

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

724:
725: WHEN OTHERS THEN
726: x_return_status := FND_API.g_ret_sts_unexp_error;
727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
728: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
729: END IF;
730:
731: FND_MSG_PUB.count_and_get
732: (

Line 731: FND_MSG_PUB.count_and_get

727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
728: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
729: END IF;
730:
731: FND_MSG_PUB.count_and_get
732: (
733: p_encoded => FND_API.g_false,
734: p_count => x_msg_count,
735: p_data => x_msg_data

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

811: -- check location_postal_code_id
812: IF p_postal_code_rec.location_postal_code_id IS NULL
813: AND p_validation_mode = JTF_PLSQL_API.g_update
814: THEN
815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
816: FND_MESSAGE.set_name('JTF', 'JTF_LOC_POS_NO_LOC_POS_CODE_ID');
817: FND_MSG_PUB.add;
818: END IF;
819:

Line 817: FND_MSG_PUB.add;

813: AND p_validation_mode = JTF_PLSQL_API.g_update
814: THEN
815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
816: FND_MESSAGE.set_name('JTF', 'JTF_LOC_POS_NO_LOC_POS_CODE_ID');
817: FND_MSG_PUB.add;
818: END IF;
819:
820: x_return_status := FND_API.g_ret_sts_error;
821: RETURN;

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

824: -- check object_version_number
825: IF p_postal_code_rec.object_version_number IS NULL
826: AND p_validation_mode = JTF_PLSQL_API.g_update
827: THEN
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
829: FND_MESSAGE.set_name('JTF', 'JTF_API_NO_OBJ_VER_NUM');
830: FND_MSG_PUB.add;
831: END IF;
832:

Line 830: FND_MSG_PUB.add;

826: AND p_validation_mode = JTF_PLSQL_API.g_update
827: THEN
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
829: FND_MESSAGE.set_name('JTF', 'JTF_API_NO_OBJ_VER_NUM');
830: FND_MSG_PUB.add;
831: END IF;
832:
833: x_return_status := FND_API.g_ret_sts_error;
834: RETURN;

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

835: END IF;
836:
837: -- check location_area_id
838: IF p_postal_code_rec.location_area_id IS NULL THEN
839: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
840: FND_MESSAGE.set_name('JTF', 'JTF_LOC_POS_NO_LOC_AREA_ID');
841: FND_MSG_PUB.add;
842: END IF;
843:

Line 841: FND_MSG_PUB.add;

837: -- check location_area_id
838: IF p_postal_code_rec.location_area_id IS NULL THEN
839: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
840: FND_MESSAGE.set_name('JTF', 'JTF_LOC_POS_NO_LOC_AREA_ID');
841: FND_MSG_PUB.add;
842: END IF;
843:
844: x_return_status := FND_API.g_ret_sts_error;
845: RETURN;

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

846: END IF;
847:
848: -- check start_date_active
849: IF p_postal_code_rec.start_date_active IS NULL THEN
850: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
851: FND_MESSAGE.set_name('JTF', 'JTF_LOC_POS_NO_START_DATES');
852: FND_MSG_PUB.add;
853: END IF;
854:

Line 852: FND_MSG_PUB.add;

848: -- check start_date_active
849: IF p_postal_code_rec.start_date_active IS NULL THEN
850: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
851: FND_MESSAGE.set_name('JTF', 'JTF_LOC_POS_NO_START_DATES');
852: FND_MSG_PUB.add;
853: END IF;
854:
855: x_return_status := FND_API.g_ret_sts_error;
856: RETURN;

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

886: p_postal_code_rec.location_area_id
887: );
888:
889: IF l_fk_flag = FND_API.g_false 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_POS_BAD_LOC_AREA_ID');
892: FND_MSG_PUB.add;
893: END IF;
894:

Line 892: FND_MSG_PUB.add;

888:
889: IF l_fk_flag = FND_API.g_false 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_POS_BAD_LOC_AREA_ID');
892: FND_MSG_PUB.add;
893: END IF;
894:
895: x_return_status := FND_API.g_ret_sts_error;
896: RETURN;

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

929: THEN
930: l_start_date := p_complete_rec.start_date_active;
931: l_end_date := p_complete_rec.end_date_active;
932: IF l_start_date > l_end_date THEN
933: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
934: FND_MESSAGE.set_name('JTF', 'JTF_START_DATE_AFTER_END_DATE');
935: FND_MSG_PUB.add;
936: END IF;
937:

Line 935: FND_MSG_PUB.add;

931: l_end_date := p_complete_rec.end_date_active;
932: IF l_start_date > l_end_date THEN
933: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
934: FND_MESSAGE.set_name('JTF', 'JTF_START_DATE_AFTER_END_DATE');
935: FND_MSG_PUB.add;
936: END IF;
937:
938: x_return_status := FND_API.g_ret_sts_error;
939: RETURN;

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

969: OPEN c_postal_code;
970: FETCH c_postal_code INTO l_postal_code_rec;
971: IF (c_postal_code%NOTFOUND) THEN
972: CLOSE c_postal_code;
973: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
974: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
975: FND_MSG_PUB.add;
976: END IF;
977: RAISE FND_API.g_exc_error;

Line 975: FND_MSG_PUB.add;

971: IF (c_postal_code%NOTFOUND) THEN
972: CLOSE c_postal_code;
973: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
974: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
975: FND_MSG_PUB.add;
976: END IF;
977: RAISE FND_API.g_exc_error;
978: END IF;
979: CLOSE c_postal_code;