81:
82: -- Initialize message list if p_init_msg_list is set to TRUE.
83: IF FND_API.to_Boolean( p_init_msg_list )
84: THEN
85: FND_MSG_PUB.initialize;
86: END IF;
87:
88: -- Debug Message
89: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
85: FND_MSG_PUB.initialize;
86: END IF;
87:
88: -- Debug Message
89: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
90: THEN
91: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MEMBERS_KREN_START');
92: FND_MSG_PUB.Add;
93: END IF;
88: -- Debug Message
89: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
90: THEN
91: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MEMBERS_KREN_START');
92: FND_MSG_PUB.Add;
93: END IF;
94:
95: -------------------
96: ----- API body ----
146: END IF;
147:
148: --
149: -- Debug Message
150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
151: THEN
152: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MEMBERS_KREN_END');
153: FND_MSG_PUB.Add;
154: END IF;
149: -- Debug Message
150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
151: THEN
152: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MEMBERS_KREN_END');
153: FND_MSG_PUB.Add;
154: END IF;
155:
156: -- Standard call to get message count and if count is 1, get message info.
157: FND_MSG_PUB.Count_And_Get
153: FND_MSG_PUB.Add;
154: END IF;
155:
156: -- Standard call to get message count and if count is 1, get message info.
157: FND_MSG_PUB.Count_And_Get
158: ( p_count => x_msg_count,
159: p_data => x_msg_data
160: );
161: --dbms_output.put_line('Get_Escalation_TerrMembers: Exiting the API');
162: EXCEPTION
163: --
164: WHEN OTHERS THEN
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
166: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
167: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
168: END IF;
169: FND_MSG_PUB.Count_And_Get
170: ( p_count => x_msg_count,
163: --
164: WHEN OTHERS THEN
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
166: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
167: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
168: END IF;
169: FND_MSG_PUB.Count_And_Get
170: ( p_count => x_msg_count,
171: p_data => x_msg_data
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
166: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
167: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
168: END IF;
169: FND_MSG_PUB.Count_And_Get
170: ( p_count => x_msg_count,
171: p_data => x_msg_data
172: );
173: --