DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PVT dependencies on FND_MSG_PUB

Line 6595: fnd_msg_pub.get

6591:
6592: IF x_msg_count > 0
6593: THEN
6594: FOR j IN 1 .. x_msg_count LOOP
6595: fnd_msg_pub.get
6596: (j
6597: , FND_API.G_FALSE
6598: , x_msg_data
6599: , t_msg_dummy

Line 6850: fnd_msg_pub.initialize;

6846:
6847: BEGIN
6848:
6849: x_return_status := G_RET_STS_SUCCESS;
6850: fnd_msg_pub.initialize;
6851:
6852: IF p_pradj_rec.chr_id IS NOT NULL THEN
6853: OPEN price_adj_cur_hdr(p_pradj_rec.list_line_id, p_pradj_rec.chr_id);
6854: FETCH price_adj_cur_hdr INTO l_pradj_exists;

Line 8727: FND_MSG_PUB.initialize;

8723: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
8724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8725: END IF;
8726: IF FND_API.to_boolean(p_init_msg_list ) THEN
8727: FND_MSG_PUB.initialize;
8728: END IF;
8729: x_return_status := FND_API.G_RET_STS_SUCCESS;
8730:
8731: --get all toplines that are out of sync with sublines

Line 8773: FND_MSG_PUB.ADD;

8769:
8770: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8771: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_line_fail', FALSE);
8772: END IF;
8773: FND_MSG_PUB.ADD;
8774:
8775: l_tl_id_tbl.delete;
8776: l_tl_amt_tbl.delete;
8777: l_sl_amt_tbl.delete;

Line 8856: FND_MSG_PUB.ADD;

8852:
8853: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8854: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_line_fail', FALSE);
8855: END IF;
8856: FND_MSG_PUB.ADD;
8857:
8858: l_tl_id_tbl.delete;
8859: l_tl_amt_tbl.delete;
8860: l_sl_amt_tbl.delete;

Line 8945: FND_MSG_PUB.ADD;

8941:
8942: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8943: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
8944: END IF;
8945: FND_MSG_PUB.ADD;
8946:
8947: RAISE FND_API.g_exc_error;
8948:
8949: END; --of anonymous block checking header lock

Line 9002: FND_MSG_PUB.ADD;

8998:
8999: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
9000: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
9001: END IF;
9002: FND_MSG_PUB.ADD;
9003:
9004: RAISE FND_API.g_exc_error;
9005:
9006: END; --of anonymous block checking header lock

Line 9052: FND_MSG_PUB.ADD;

9048:
9049: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
9050: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_line_fail', FALSE);
9051: END IF;
9052: FND_MSG_PUB.ADD;
9053:
9054: l_tl_id_tbl.delete;
9055: l_tl_amt_tbl.delete;
9056: l_sl_amt_tbl.delete;

Line 9125: FND_MSG_PUB.ADD;

9121:
9122: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
9123: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
9124: END IF;
9125: FND_MSG_PUB.ADD;
9126:
9127: RAISE FND_API.g_exc_error;
9128:
9129: END; --of anonymous block checking header lock

Line 9141: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

9137: --exit
9138: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9139: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9140: END IF;
9141: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9142:
9143: EXCEPTION
9144: WHEN FND_API.g_exc_error THEN
9145: ROLLBACK TO check_update_amounts_PVT;

Line 9151: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

9147:
9148: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
9149: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
9150: END IF;
9151: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9152: IF (c_k_toplines%isopen) THEN
9153: CLOSE c_k_toplines;
9154: END IF;
9155: IF (c_lock_tl%isopen) THEN

Line 9176: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

9172:
9173: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
9174: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
9175: END IF;
9176: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9177: IF (c_k_toplines%isopen) THEN
9178: CLOSE c_k_toplines;
9179: END IF;
9180: IF (c_lock_tl%isopen) THEN

Line 9202: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

9198: --first log the sqlerrm
9199: l_error_text := substr (SQLERRM, 1, 240);
9200: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
9201: --then add it to the message api list
9202: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
9203: END IF;
9204: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9205: IF (c_k_toplines%isopen) THEN
9206: CLOSE c_k_toplines;

Line 9204: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

9200: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
9201: --then add it to the message api list
9202: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
9203: END IF;
9204: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9205: IF (c_k_toplines%isopen) THEN
9206: CLOSE c_k_toplines;
9207: END IF;
9208: IF (c_lock_tl%isopen) THEN