DBA Data[Home] [Help]

APPS.OZF_CHECK_DUP_PROD_PVT dependencies on FND_MESSAGE

Line 276: FND_MESSAGE.set_name('OZF', 'OZF_VO_PROD_STMT_FAILED');

272: WHEN OTHERS THEN
273: ROLLBACK TO denorm_vo_products;
274: x_return_status := FND_API.g_ret_sts_unexp_error;
275:
276: FND_MESSAGE.set_name('OZF', 'OZF_VO_PROD_STMT_FAILED');
277: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
278: FND_MSG_PUB.add;
279:
280: l_stmt_denorm := FND_DSQL.get_text(TRUE);

Line 277: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

273: ROLLBACK TO denorm_vo_products;
274: x_return_status := FND_API.g_ret_sts_unexp_error;
275:
276: FND_MESSAGE.set_name('OZF', 'OZF_VO_PROD_STMT_FAILED');
277: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
278: FND_MSG_PUB.add;
279:
280: l_stmt_denorm := FND_DSQL.get_text(TRUE);
281: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));

Line 387: FND_MESSAGE.set_name('OZF', 'OZF_DUP_PROD_FOUND');

383: CLOSE c_duplicate_prod_exists;
384:
385: IF l_duplicate_prod_exists = 'Y' THEN
386: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
387: FND_MESSAGE.set_name('OZF', 'OZF_DUP_PROD_FOUND');
388: FND_MSG_PUB.add;
389: END IF;
390: RAISE FND_API.g_exc_error;
391: END IF;