DBA Data[Home] [Help]

APPS.OZF_DENORM_QUERIES_PVT dependencies on FND_MESSAGE

Line 332: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

328:
329:
330: IF (SQL%NOTFOUND) THEN
331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
332: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
333: FND_MSG_PUB.add;
334: END IF;
335: RAISE FND_API.g_exc_error;
336: END IF;

Line 647: FND_MESSAGE.set_name('OZF', 'OZF_DENORM_QUERIES_EXISTS');

643: ELSE
644: IF(l_denorm_query_id<>p_denorm_queries_rec.denorm_query_id)THEN
645: OZF_Utility_PVT.debug_message('This record already exists');
646: x_return_status:='E';
647: FND_MESSAGE.set_name('OZF', 'OZF_DENORM_QUERIES_EXISTS');
648: FND_MSG_PUB.add;
649: END IF;
650: END IF;
651: */

Line 676: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUERY_FOR_TYPE');

672:
673: x_return_status := FND_API.g_ret_sts_success;
674: IF (p_denorm_queries_rec.query_for IS NULL OR p_denorm_queries_rec.query_for = FND_API.g_miss_char) THEN
675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
676: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUERY_FOR_TYPE');
677: FND_MSG_PUB.add;
678: END IF;
679: x_return_status := FND_API.g_ret_sts_error;
680: RETURN;

Line 684: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUALIFIER_CONTEXT');

680: RETURN;
681: END IF;
682: IF (p_denorm_queries_rec.context IS NULL OR p_denorm_queries_rec.context = FND_API.g_miss_char) THEN
683: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
684: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUALIFIER_CONTEXT');
685: FND_MSG_PUB.add;
686: END IF;
687: x_return_status := FND_API.g_ret_sts_error;
688: RETURN;

Line 693: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUALIFIER_CONTEXT_ATTR');

689: END IF;
690: ------------------------ qualifier_context_attribute --------------------------
691: IF (p_denorm_queries_rec.attribute IS NULL OR p_denorm_queries_rec.attribute = FND_API.g_miss_char) THEN
692: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
693: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUALIFIER_CONTEXT_ATTR');
694: FND_MSG_PUB.add;
695: END IF;
696: x_return_status := FND_API.g_ret_sts_error;
697: RETURN;

Line 707: FND_MESSAGE.set_name('OZF', 'OZF_NO_SQLSTATEMENT');

703:
704:
705: IF (p_denorm_queries_rec.SQL_STATEMENT IS NULL ) OR (p_denorm_queries_rec.SQL_STATEMENT = FND_API.g_miss_char) THEN
706: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
707: FND_MESSAGE.set_name('OZF', 'OZF_NO_SQLSTATEMENT');
708: FND_MSG_PUB.add;
709: END IF;
710: x_return_status := FND_API.g_ret_sts_error;
711: RETURN;

Line 757: FND_MESSAGE.set_name('OZF','OZF_NO_SQLSTATEMENT');

753: END IF;
754: EXCEPTION
755: when others then
756: x_return_status := FND_API.g_ret_sts_error;
757: FND_MESSAGE.set_name('OZF','OZF_NO_SQLSTATEMENT');
758: FND_MSG_PUB.add;
759: FND_MESSAGE.SET_NAME('OZF','OZF_API_DEBUG_MESSAGE');
760: FND_MESSAGE.SET_TOKEN('TEXT',SQLERRM);
761: FND_MSG_PUB.add;

Line 759: FND_MESSAGE.SET_NAME('OZF','OZF_API_DEBUG_MESSAGE');

755: when others then
756: x_return_status := FND_API.g_ret_sts_error;
757: FND_MESSAGE.set_name('OZF','OZF_NO_SQLSTATEMENT');
758: FND_MSG_PUB.add;
759: FND_MESSAGE.SET_NAME('OZF','OZF_API_DEBUG_MESSAGE');
760: FND_MESSAGE.SET_TOKEN('TEXT',SQLERRM);
761: FND_MSG_PUB.add;
762: END check_denorm_queries_req_items;
763:

Line 760: FND_MESSAGE.SET_TOKEN('TEXT',SQLERRM);

756: x_return_status := FND_API.g_ret_sts_error;
757: FND_MESSAGE.set_name('OZF','OZF_NO_SQLSTATEMENT');
758: FND_MSG_PUB.add;
759: FND_MESSAGE.SET_NAME('OZF','OZF_API_DEBUG_MESSAGE');
760: FND_MESSAGE.SET_TOKEN('TEXT',SQLERRM);
761: FND_MSG_PUB.add;
762: END check_denorm_queries_req_items;
763:
764:

Line 864: FND_MESSAGE.set_name('OZF', 'OZF_DENORM_QUERIES_EXISTS');

860: X_RETURN_STATUS:='S';
861: ELSE
862: OZF_Utility_PVT.debug_message('This record already exists');
863: x_return_status:='E';
864: FND_MESSAGE.set_name('OZF', 'OZF_DENORM_QUERIES_EXISTS');
865: FND_MSG_PUB.add;
866: END IF;
867: */
868: NULL;

Line 920: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

916: FETCH c_denorm_queries INTO l_denorm_queries_rec;
917: IF c_denorm_queries%NOTFOUND THEN
918: CLOSE c_denorm_queries;
919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
920: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
921: FND_MSG_PUB.add;
922: END IF;
923: RAISE FND_API.g_exc_error;
924: END IF;