DBA Data[Home] [Help]

APPS.OKS_SETUP_UTIL_PUB dependencies on FND_MSG_PUB

Line 17: For i in 1..fnd_msg_pub.count_msg

13: l_msg_index NUMBER;
14: l_msg_data VARCHAR2(32000);
15: Begin
16: l_msg_index := 1;
17: For i in 1..fnd_msg_pub.count_msg
18: loop
19: fnd_msg_pub.get
20: (
21: p_msg_index => i,

Line 19: fnd_msg_pub.get

15: Begin
16: l_msg_index := 1;
17: For i in 1..fnd_msg_pub.count_msg
18: loop
19: fnd_msg_pub.get
20: (
21: p_msg_index => i,
22: p_encoded => 'F',
23: p_data => l_msg_data,

Line 4883: FND_MSG_PUB.initialize;

4879: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4881: END IF;
4882: IF FND_API.to_boolean(p_init_msg_list ) THEN
4883: FND_MSG_PUB.initialize;
4884: END IF;
4885: x_return_status := FND_API.G_RET_STS_SUCCESS;
4886:
4887: OPEN c_get_line_type(p_line_id);

Line 4919: FND_MSG_PUB.ADD;

4915: FND_MESSAGE.set_NAME(G_OKS_APP_NAME, 'OKS_TRANSFER_LINE_NO_DELETE');
4916: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4917: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.transfer_check', FALSE);
4918: END IF;
4919: FND_MSG_PUB.ADD;
4920: RAISE FND_API.g_exc_error;
4921: END IF;
4922:
4923:

Line 4980: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_response.result_message||'('||l_response.result_code||':'||l_response.result_category||')');

4976: END IF;
4977:
4978: --also check the pmt api result code
4979: IF (l_response.result_code <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS) THEN
4980: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_response.result_message||'('||l_response.result_code||':'||l_response.result_category||')');
4981: RAISE FND_API.g_exc_error;
4982: END IF;
4983:
4984: END IF;

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

5285: END IF;
5286: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
5287: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', ' x_return_status='|| x_return_status);
5288: END IF;
5289: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5290:
5291: EXCEPTION
5292: WHEN FND_API.g_exc_error THEN
5293: ROLLBACK TO delete_top_sub_line_PUB;

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

5295:
5296: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5297: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
5298: END IF;
5299: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5300:
5301: IF (c_get_line_type%isopen) THEN
5302: CLOSE c_get_line_type;
5303: END IF;

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

5326:
5327: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
5328: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
5329: END IF;
5330: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5331:
5332: IF (c_get_line_type%isopen) THEN
5333: CLOSE c_get_line_type;
5334: END IF;

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

5359: --first log the sqlerrm
5360: l_error_text := substr (SQLERRM, 1, 240);
5361: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
5362: --then add it to the message api list
5363: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
5364: END IF;
5365: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5366:
5367: IF (c_get_line_type%isopen) THEN

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

5361: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
5362: --then add it to the message api list
5363: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
5364: END IF;
5365: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5366:
5367: IF (c_get_line_type%isopen) THEN
5368: CLOSE c_get_line_type;
5369: END IF;