78: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
79: 'jtf.plsql.JTF_TERR_NAMEACC_PUB.Set_Winners_tbl.begin',
80: 'Start of the procedure JTF_TERR_NAMEACC_PUB.Set_Winners_tbl');
81: END IF;
82: FND_MSG_PUB.initialize;
83: -- Standard call to check for call compatibility.
84: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
85: p_api_version_number,
86: l_api_name,
90: END IF;
91: -- Initialize message list if p_init_msg_list is set to TRUE.
92: IF FND_API.to_Boolean( p_init_msg_list )
93: THEN
94: FND_MSG_PUB.initialize;
95: END IF;
96: -- Debug Message
97: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
98: THEN
93: THEN
94: FND_MSG_PUB.initialize;
95: END IF;
96: -- Debug Message
97: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
98: THEN
99: FND_MESSAGE.Set_Name('JTF', G_PKG_NAME || '_START');
100: FND_MSG_PUB.Add;
101: END IF;
96: -- Debug Message
97: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
98: THEN
99: FND_MESSAGE.Set_Name('JTF', G_PKG_NAME || '_START');
100: FND_MSG_PUB.Add;
101: END IF;
102: -- API body
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104: lx_return_status := FND_API.G_RET_STS_SUCCESS;
302: 'jtf.plsql.JTF_TERR_NAMEACC_PUB.Set_Winners_tbl',
303: 'Number of winning resources : ' || l_num_res_rows);
304: END IF;
305: -- Debug Message
306: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
307: THEN
308: FND_MESSAGE.Set_Name('JTF', G_PKG_NAME || '_END');
309: FND_MSG_PUB.Add;
310: END IF;
305: -- Debug Message
306: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
307: THEN
308: FND_MESSAGE.Set_Name('JTF', G_PKG_NAME || '_END');
309: FND_MSG_PUB.Add;
310: END IF;
311: -- Standard call to get message count and if count is 1, get message info.
312: FND_MSG_PUB.Count_And_Get
313: ( p_count => x_msg_count,
308: FND_MESSAGE.Set_Name('JTF', G_PKG_NAME || '_END');
309: FND_MSG_PUB.Add;
310: END IF;
311: -- Standard call to get message count and if count is 1, get message info.
312: FND_MSG_PUB.Count_And_Get
313: ( p_count => x_msg_count,
314: p_data => x_msg_data
315: );
316: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: End ');