23: l_msg_data VARCHAR2(1000);
24: BEGIN
25: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
26: THEN
27: FND_MSG_PUB.initialize;
28: END IF;
29:
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31: x_id2name := 'N';
58: WHEN OTHERS THEN
59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
60: x_id2name := 'N';
61:
62: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
63: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_id2name' ,'ID2Name');
64: END IF;
65:
66: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
60: x_id2name := 'N';
61:
62: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
63: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_id2name' ,'ID2Name');
64: END IF;
65:
66: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
67:
62: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
63: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_id2name' ,'ID2Name');
64: END IF;
65:
66: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
67:
68: END Id2Name;
69:
70:
90: l_msg_data VARCHAR2(1000);
91: BEGIN
92: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
93: THEN
94: FND_MSG_PUB.initialize;
95: END IF;
96:
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
124: WHEN OTHERS THEN
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: x_query := null;
127:
128: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
129: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_id2name' ,'ID2NameLovQuery');
130: END IF;
131:
132: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: x_query := null;
127:
128: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
129: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_id2name' ,'ID2NameLovQuery');
130: END IF;
131:
132: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
133:
128: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
129: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_id2name' ,'ID2NameLovQuery');
130: END IF;
131:
132: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
133:
134: END Id2NameLovQuery;
135:
136:
148: i NUMBER;
149: BEGIN
150: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
151: THEN
152: FND_MSG_PUB.initialize;
153: END IF;
154:
155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156: x_id2name := 'N';
179: WHEN OTHERS THEN
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: x_id2name := 'N';
182:
183: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
184: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_id2name' ,'ID2Name');
185: END IF;
186:
187: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: x_id2name := 'N';
182:
183: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
184: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_id2name' ,'ID2Name');
185: END IF;
186:
187: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
188:
183: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
184: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_id2name' ,'ID2Name');
185: END IF;
186:
187: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
188:
189: END Id2Name;
190:
191: /*****************************************************
202: i NUMBER;
203: BEGIN
204: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
205: THEN
206: FND_MSG_PUB.initialize;
207: END IF;
208:
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210: x_query := null;
233: WHEN OTHERS THEN
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: x_query := null;
236:
237: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
238: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_id2name' ,'ID2NameLovQuery');
239: END IF;
240:
241: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: x_query := null;
236:
237: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
238: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_id2name' ,'ID2NameLovQuery');
239: END IF;
240:
241: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
242:
237: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
238: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_id2name' ,'ID2NameLovQuery');
239: END IF;
240:
241: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
242:
243: END Id2NameLovQuery;
244:
245:
266: l_name VARCHAR2(240) := null;
267: BEGIN
268: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
269: THEN
270: FND_MSG_PUB.initialize;
271: END IF;
272:
273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274:
307: WHEN OTHERS THEN
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: x_name := null;
310:
311: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
312: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_id2name' ,'ID2NameAttributeValue');
313: END IF;
314:
315: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: x_name := null;
310:
311: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
312: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_id2name' ,'ID2NameAttributeValue');
313: END IF;
314:
315: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
316:
311: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
312: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_id2name' ,'ID2NameAttributeValue');
313: END IF;
314:
315: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
316:
317: END Id2NameAttributeValue;
318:
319: