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 4892: FND_MSG_PUB.initialize;

4888: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4890: END IF;
4891: IF FND_API.to_boolean(p_init_msg_list ) THEN
4892: FND_MSG_PUB.initialize;
4893: END IF;
4894: x_return_status := FND_API.G_RET_STS_SUCCESS;
4895:
4896: OPEN c_get_line_type(p_line_id);

Line 4928: FND_MSG_PUB.ADD;

4924: FND_MESSAGE.set_NAME(G_OKS_APP_NAME, 'OKS_TRANSFER_LINE_NO_DELETE');
4925: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4926: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.transfer_check', FALSE);
4927: END IF;
4928: FND_MSG_PUB.ADD;
4929: RAISE FND_API.g_exc_error;
4930: END IF;
4931:
4932:

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

4985: END IF;
4986:
4987: --also check the pmt api result code
4988: IF (l_response.result_code <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS) THEN
4989: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_response.result_message||'('||l_response.result_code||':'||l_response.result_category||')');
4990: RAISE FND_API.g_exc_error;
4991: END IF;
4992:
4993: END IF;

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

5294: END IF;
5295: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
5296: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', ' x_return_status='|| x_return_status);
5297: END IF;
5298: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5299:
5300: EXCEPTION
5301: WHEN FND_API.g_exc_error THEN
5302: ROLLBACK TO delete_top_sub_line_PUB;

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

5304:
5305: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5306: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
5307: END IF;
5308: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5309:
5310: IF (c_get_line_type%isopen) THEN
5311: CLOSE c_get_line_type;
5312: END IF;

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

5335:
5336: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
5337: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
5338: END IF;
5339: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5340:
5341: IF (c_get_line_type%isopen) THEN
5342: CLOSE c_get_line_type;
5343: END IF;

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

5368: --first log the sqlerrm
5369: l_error_text := substr (SQLERRM, 1, 240);
5370: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
5371: --then add it to the message api list
5372: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
5373: END IF;
5374: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5375:
5376: IF (c_get_line_type%isopen) THEN

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

5370: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
5371: --then add it to the message api list
5372: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
5373: END IF;
5374: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5375:
5376: IF (c_get_line_type%isopen) THEN
5377: CLOSE c_get_line_type;
5378: END IF;