DBA Data[Home] [Help]

APPS.JTF_LOC_POSTAL_CODES_PVT dependencies on FND_MESSAGE

Line 317: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');

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

Line 432: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');

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

Line 551: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');

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

Line 573: FND_MESSAGE.set_name('JTF', 'JTF_API_RESOURCE_LOCKED');

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

Line 816: FND_MESSAGE.set_name('JTF', 'JTF_LOC_POS_NO_LOC_POS_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:
820: x_return_status := FND_API.g_ret_sts_error;

Line 829: FND_MESSAGE.set_name('JTF', 'JTF_API_NO_OBJ_VER_NUM');

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:
833: x_return_status := FND_API.g_ret_sts_error;

Line 840: FND_MESSAGE.set_name('JTF', 'JTF_LOC_POS_NO_LOC_AREA_ID');

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:
844: x_return_status := FND_API.g_ret_sts_error;

Line 851: FND_MESSAGE.set_name('JTF', 'JTF_LOC_POS_NO_START_DATES');

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:
855: x_return_status := FND_API.g_ret_sts_error;

Line 891: FND_MESSAGE.set_name('JTF', 'JTF_LOC_POS_BAD_LOC_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:
895: x_return_status := FND_API.g_ret_sts_error;

Line 934: FND_MESSAGE.set_name('JTF', 'JTF_START_DATE_AFTER_END_DATE');

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:
938: x_return_status := FND_API.g_ret_sts_error;

Line 974: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');

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