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.IEM_AMV_PVT dependencies on FND_API

Line 24: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

20: l_cat_ids_tbl jtf_number_table:=jtf_number_table();
21: l_cat_names_tbl jtf_varchar2_Table_100:=jtf_varchar2_Table_100();
22:
23:
24: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
25: l_msg_count NUMBER := 0;
26: l_msg_data VARCHAR2(2000);
27:
28: IEM_ERROR_GET_SUB_CATEGORIES EXCEPTION;

Line 33: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

29:
30: BEGIN
31: SAVEPOINT search_message_pvt;
32: -- Standard call to check for call compatibility.
33: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
34: p_api_version_number,
35: l_api_name,
36: G_PKG_NAME)
37: THEN

Line 38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

34: p_api_version_number,
35: l_api_name,
36: G_PKG_NAME)
37: THEN
38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
39: END IF;
40: -- Initialize message list if p_init_msg_list is set to TRUE.
41: IF FND_API.to_Boolean( p_init_msg_list )
42: THEN

Line 41: IF FND_API.to_Boolean( p_init_msg_list )

37: THEN
38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
39: END IF;
40: -- Initialize message list if p_init_msg_list is set to TRUE.
41: IF FND_API.to_Boolean( p_init_msg_list )
42: THEN
43: FND_MSG_PUB.initialize;
44: END IF;
45:

Line 47: x_return_status := FND_API.G_RET_STS_SUCCESS;

43: FND_MSG_PUB.initialize;
44: END IF;
45:
46: -- Initialize API return status to SUCCESS
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48:
49: l_cat_ids_tbl.extend;
50: l_cat_names_tbl.extend;
51:

Line 88: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

84: x_return_status => l_return_status,
85: x_msg_count => l_msg_count,
86: x_msg_data => l_msg_data);
87:
88: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
89: raise IEM_ERROR_GET_SUB_CATEGORIES;
90: end if;
91:
92: l_index := l_out_index;

Line 106: IF FND_API.To_Boolean(p_commit) THEN

102:
103: END LOOP;
104:
105: -- Standard Check Of p_commit.
106: IF FND_API.To_Boolean(p_commit) THEN
107: COMMIT WORK;
108: END IF;
109: -- Standard callto get message count and if count is 1, get message info.
110: FND_MSG_PUB.Count_And_Get

Line 119: x_return_status := FND_API.G_RET_STS_ERROR ;

115: WHEN IEM_ERROR_GET_SUB_CATEGORIES THEN
116: ROLLBACK TO create_item_wrap_pvt;
117: FND_MESSAGE.SET_NAME('IEM','IEM_ERROR_GET_SUBCAT');
118: FND_MSG_PUB.Add;
119: x_return_status := FND_API.G_RET_STS_ERROR ;
120: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
121:
122: WHEN FND_API.G_EXC_ERROR THEN
123: ROLLBACK TO search_message_pvt;

Line 122: WHEN FND_API.G_EXC_ERROR THEN

118: FND_MSG_PUB.Add;
119: x_return_status := FND_API.G_RET_STS_ERROR ;
120: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
121:
122: WHEN FND_API.G_EXC_ERROR THEN
123: ROLLBACK TO search_message_pvt;
124: x_return_status := FND_API.G_RET_STS_ERROR ;
125: FND_MSG_PUB.Count_And_Get
126: ( p_count => x_msg_count,

Line 124: x_return_status := FND_API.G_RET_STS_ERROR ;

120: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
121:
122: WHEN FND_API.G_EXC_ERROR THEN
123: ROLLBACK TO search_message_pvt;
124: x_return_status := FND_API.G_RET_STS_ERROR ;
125: FND_MSG_PUB.Count_And_Get
126: ( p_count => x_msg_count,
127: p_data => x_msg_data
128: );

Line 129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

125: FND_MSG_PUB.Count_And_Get
126: ( p_count => x_msg_count,
127: p_data => x_msg_data
128: );
129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
130: ROLLBACK TO search_message_pvt;
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,

Line 131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

127: p_data => x_msg_data
128: );
129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
130: ROLLBACK TO search_message_pvt;
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,
134: p_data => x_msg_data
135: );

Line 138: x_return_status := FND_API.G_RET_STS_ERROR;

134: p_data => x_msg_data
135: );
136: WHEN OTHERS THEN
137: ROLLBACK TO search_message_pvt;
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: IF FND_MSG_PUB.Check_Msg_Level
140: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
141: THEN
142: FND_MSG_PUB.Add_Exc_Msg

Line 178: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

174:
175: l_cat_ids_tbl jtf_number_table:=jtf_number_table();
176: l_cat_names_tbl jtf_varchar2_Table_100:=jtf_varchar2_Table_100();
177:
178: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
179: l_msg_count NUMBER := 0;
180: l_msg_data VARCHAR2(2000);
181:
182:

Line 187: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

183: IEM_ERROR_GET_SUB_CATEGORIES EXCEPTION;
184: BEGIN
185: SAVEPOINT search_message_pvt;
186: -- Standard call to check for call compatibility.
187: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
188: p_api_version_number,
189: l_api_name,
190: G_PKG_NAME)
191: THEN

Line 192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

188: p_api_version_number,
189: l_api_name,
190: G_PKG_NAME)
191: THEN
192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
193: END IF;
194: -- Initialize message list if p_init_msg_list is set to TRUE.
195: IF FND_API.to_Boolean( p_init_msg_list )
196: THEN

Line 195: IF FND_API.to_Boolean( p_init_msg_list )

191: THEN
192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
193: END IF;
194: -- Initialize message list if p_init_msg_list is set to TRUE.
195: IF FND_API.to_Boolean( p_init_msg_list )
196: THEN
197: FND_MSG_PUB.initialize;
198: END IF;
199:

Line 201: x_return_status := FND_API.G_RET_STS_SUCCESS;

197: FND_MSG_PUB.initialize;
198: END IF;
199:
200: -- Initialize API return status to SUCCESS
201: x_return_status := FND_API.G_RET_STS_SUCCESS;
202:
203: l_cat_ids_tbl.extend;
204: l_cat_names_tbl.extend;
205:

Line 246: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

242: x_return_status => l_return_status,
243: x_msg_count => l_msg_count,
244: x_msg_data => l_msg_data);
245:
246: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
247: raise IEM_ERROR_GET_SUB_CATEGORIES;
248: end if;
249:
250: x_index := l_out_index;

Line 259: IF FND_API.To_Boolean(p_commit) THEN

255: end if;
256:
257:
258: -- Standard Check Of p_commit.
259: IF FND_API.To_Boolean(p_commit) THEN
260: COMMIT WORK;
261: END IF;
262: -- Standard callto get message count and if count is 1, get message info.
263: FND_MSG_PUB.Count_And_Get

Line 273: x_return_status := FND_API.G_RET_STS_ERROR ;

269: WHEN IEM_ERROR_GET_SUB_CATEGORIES THEN
270: ROLLBACK TO create_item_wrap_pvt;
271: FND_MESSAGE.SET_NAME('IEM','IEM_ERROR_GET_SUBCAT');
272: FND_MSG_PUB.Add;
273: x_return_status := FND_API.G_RET_STS_ERROR ;
274: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
275:
276: WHEN FND_API.G_EXC_ERROR THEN
277: ROLLBACK TO search_message_pvt;

Line 276: WHEN FND_API.G_EXC_ERROR THEN

272: FND_MSG_PUB.Add;
273: x_return_status := FND_API.G_RET_STS_ERROR ;
274: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
275:
276: WHEN FND_API.G_EXC_ERROR THEN
277: ROLLBACK TO search_message_pvt;
278: x_return_status := FND_API.G_RET_STS_ERROR ;
279: FND_MSG_PUB.Count_And_Get
280: ( p_count => x_msg_count,

Line 278: x_return_status := FND_API.G_RET_STS_ERROR ;

274: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
275:
276: WHEN FND_API.G_EXC_ERROR THEN
277: ROLLBACK TO search_message_pvt;
278: x_return_status := FND_API.G_RET_STS_ERROR ;
279: FND_MSG_PUB.Count_And_Get
280: ( p_count => x_msg_count,
281: p_data => x_msg_data
282: );

Line 283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

279: FND_MSG_PUB.Count_And_Get
280: ( p_count => x_msg_count,
281: p_data => x_msg_data
282: );
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: ROLLBACK TO search_message_pvt;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
286: FND_MSG_PUB.Count_And_Get
287: ( p_count => x_msg_count,

Line 285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

281: p_data => x_msg_data
282: );
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: ROLLBACK TO search_message_pvt;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
286: FND_MSG_PUB.Count_And_Get
287: ( p_count => x_msg_count,
288: p_data => x_msg_data
289: );

Line 292: x_return_status := FND_API.G_RET_STS_ERROR;

288: p_data => x_msg_data
289: );
290: WHEN OTHERS THEN
291: ROLLBACK TO search_message_pvt;
292: x_return_status := FND_API.G_RET_STS_ERROR;
293: IF FND_MSG_PUB.Check_Msg_Level
294: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
295: THEN
296: FND_MSG_PUB.Add_Exc_Msg