eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FLM_SEQ_ID2NAME dependencies on FND_API

Line 25: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

21: l_return_status VARCHAR2(2);
22: l_msg_count NUMBER;
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:

Line 30: x_return_status := FND_API.G_RET_STS_SUCCESS;

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';
32:
33: select
34: attribute_type, attribute_source

Line 59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

55: return;
56:
57: EXCEPTION
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');

Line 92: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

88: l_return_status VARCHAR2(2);
89: l_msg_count NUMBER;
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:

Line 97: x_return_status := FND_API.G_RET_STS_SUCCESS;

93: THEN
94: FND_MSG_PUB.initialize;
95: END IF;
96:
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: select
100: attribute_type, attribute_source
101: into l_type, l_col

Line 125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

121: return;
122:
123: EXCEPTION
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');

Line 150: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

146: x_msg_data OUT NOCOPY VARCHAR2
147: ) IS
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:

Line 155: x_return_status := FND_API.G_RET_STS_SUCCESS;

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';
157:
158: if (ID2Name_Table is null OR ID2Name_Table.COUNT <= 0) then
159: ID2NameInit;

Line 180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

176: END LOOP;
177:
178: EXCEPTION
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');

Line 204: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

200: x_msg_data OUT NOCOPY VARCHAR2)
201: IS
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:

Line 209: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
211:
212: if (ID2Name_Table is null OR ID2Name_Table.COUNT <= 0) then
213: ID2NameInit;

Line 234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

230: END LOOP;
231:
232: EXCEPTION
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');

Line 268: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

264: l_cursor INTEGER;
265: l_dummy INTEGER;
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:

Line 273: x_return_status := FND_API.G_RET_STS_SUCCESS;

269: THEN
270: FND_MSG_PUB.initialize;
271: END IF;
272:
273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274:
275: ID2NameLovQuery(p_table, p_column, p_init_msg_list, l_query,
276: l_return_status, l_msg_count, l_msg_data);
277:

Line 278: if (l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_query is null) then

274:
275: ID2NameLovQuery(p_table, p_column, p_init_msg_list, l_query,
276: l_return_status, l_msg_count, l_msg_data);
277:
278: if (l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_query is null) then
279: x_return_status := l_return_status;
280: x_msg_count := l_msg_count;
281: x_msg_data := l_msg_data;
282: x_name := null;

Line 308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

304: x_name := l_name;
305:
306: EXCEPTION
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');