APPS.OZF_CHECK_DUP_PROD_PVT dependencies on FND_MSG_PUB

Line 186: FND_MSG_PUB.initialize;

182: SAVEPOINT denorm_vo_products;
183: ozf_utility_pvt.debug_message(l_full_name || ': start denorm_vo_products');
184:
185: IF FND_API.to_boolean(p_init_msg_list) THEN
186: FND_MSG_PUB.initialize;
187: END IF;
188:
189: IF NOT FND_API.compatible_api_call(l_api_version,
190: p_api_version,

Line 278: FND_MSG_PUB.add;

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));
282: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));

Line 286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

282: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));
283: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 501, 250));
284: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 751, 250));
285:
286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
287: THEN
288: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
289: END IF;
290:

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

284: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 751, 250));
285:
286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
287: THEN
288: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
289: END IF;
290:
291: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
292: p_count => x_msg_count,

Line 291: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

287: THEN
288: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
289: END IF;
290:
291: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
292: p_count => x_msg_count,
293: p_data => x_msg_data);
294: END denorm_vo_products;
295:

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

382: FETCH c_duplicate_prod_exists INTO l_duplicate_prod_exists;
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;

Line 388: FND_MSG_PUB.add;

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

Line 413: FND_MSG_PUB.count_and_get(

409: */
410: WHEN FND_API.G_EXC_ERROR THEN
411: ROLLBACK TO check_dup_prod;
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MSG_PUB.count_and_get(
414: p_encoded => FND_API.g_false
415: ,p_count => x_msg_count
416: ,p_data => x_msg_data);
417:

Line 421: FND_MSG_PUB.count_and_get(

417:
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: ROLLBACK TO check_dup_prod;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: FND_MSG_PUB.count_and_get(
422: p_encoded => FND_API.g_false
423: ,p_count => x_msg_count
424: ,p_data => x_msg_data);
425:

Line 429: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

425:
426: WHEN OTHERS THEN
427: ROLLBACK TO check_dup_prod;
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
430: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name);
431: END IF;
432: FND_MSG_PUB.count_and_get(
433: p_encoded => FND_API.g_false

Line 430: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name);

426: WHEN OTHERS THEN
427: ROLLBACK TO check_dup_prod;
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
430: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name);
431: END IF;
432: FND_MSG_PUB.count_and_get(
433: p_encoded => FND_API.g_false
434: ,p_count => x_msg_count

Line 432: FND_MSG_PUB.count_and_get(

428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
430: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name);
431: END IF;
432: FND_MSG_PUB.count_and_get(
433: p_encoded => FND_API.g_false
434: ,p_count => x_msg_count
435: ,p_data => x_msg_data);
436: END check_dup_prod;