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_ACT_CATG_PVT dependencies on FND_API

Line 41: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

37: l_acct_cat_seq number;
38:
39: BEGIN
40: -- Standard call to check for call compatibility.
41: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
42: p_api_version_number,
43: l_api_name,
44: G_PKG_NAME)
45: THEN

Line 46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

42: p_api_version_number,
43: l_api_name,
44: G_PKG_NAME)
45: THEN
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49: delete from iem_account_categories
50: where email_account_id=p_email_account_id;

Line 48: x_return_status := FND_API.G_RET_STS_SUCCESS;

44: G_PKG_NAME)
45: THEN
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49: delete from iem_account_categories
50: where email_account_id=p_email_account_id;
51: IF p_cat_tbl.count>0 THEN
52: FOR i in p_cat_tbl.FIRST..p_cat_tbl.LAST LOOP

Line 111: IF FND_API.To_Boolean(p_commit) THEN

107: );
108: END LOOP;
109: END IF;
110: -- Standard Check Of p_commit.
111: IF FND_API.To_Boolean(p_commit) THEN
112: COMMIT WORK;
113: END IF;
114: -- Standard callto get message count and if count is 1, get message info.
115: FND_MSG_PUB.Count_And_Get

Line 120: WHEN FND_API.G_EXC_ERROR THEN

116: ( p_count => x_msg_count,
117: p_data => x_msg_data
118: );
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: FND_MSG_PUB.Count_And_Get
123: ( p_count => x_msg_count,
124: p_data => x_msg_data

Line 121: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

122: FND_MSG_PUB.Count_And_Get
123: ( p_count => x_msg_count,
124: p_data => x_msg_data
125: );
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: FND_MSG_PUB.Count_And_Get
129: ( p_count => x_msg_count,
130: p_data => x_msg_data

Line 127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

123: ( p_count => x_msg_count,
124: p_data => x_msg_data
125: );
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: FND_MSG_PUB.Count_And_Get
129: ( p_count => x_msg_count,
130: p_data => x_msg_data
131: );

Line 133: x_return_status := FND_API.G_RET_STS_ERROR;

129: ( p_count => x_msg_count,
130: p_data => x_msg_data
131: );
132: WHEN OTHERS THEN
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: IF FND_MSG_PUB.Check_Msg_Level
135: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: FND_MSG_PUB.Add_Exc_Msg

Line 164: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

160: cursor c1 is select category_id from iem_account_categories
161: where email_account_id=p_email_account_id;
162: BEGIN
163: -- Standard call to check for call compatibility.
164: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
165: p_api_version_number,
166: l_api_name,
167: G_PKG_NAME)
168: THEN

Line 169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

165: p_api_version_number,
166: l_api_name,
167: G_PKG_NAME)
168: THEN
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: END IF;
171: SAVEPOINT select_item_pvt;
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173: open c1;

Line 172: x_return_status := FND_API.G_RET_STS_SUCCESS;

168: THEN
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: END IF;
171: SAVEPOINT select_item_pvt;
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173: open c1;
174: fetch c1 bulk collect into x_category_tbl;
175: close c1;
176:

Line 178: IF FND_API.To_Boolean(p_commit) THEN

174: fetch c1 bulk collect into x_category_tbl;
175: close c1;
176:
177: -- Standard Check Of p_commit.
178: IF FND_API.To_Boolean(p_commit) THEN
179: COMMIT WORK;
180: END IF;
181: -- Standard callto get message count and if count is 1, get message info.
182: FND_MSG_PUB.Count_And_Get

Line 187: WHEN FND_API.G_EXC_ERROR THEN

183: ( p_count => x_msg_count,
184: p_data => x_msg_data
185: );
186: EXCEPTION
187: WHEN FND_API.G_EXC_ERROR THEN
188: ROLLBACK TO select_item_pvt;
189: x_return_status := FND_API.G_RET_STS_ERROR ;
190: FND_MSG_PUB.Count_And_Get
191: ( p_count => x_msg_count,

Line 189: x_return_status := FND_API.G_RET_STS_ERROR ;

185: );
186: EXCEPTION
187: WHEN FND_API.G_EXC_ERROR THEN
188: ROLLBACK TO select_item_pvt;
189: x_return_status := FND_API.G_RET_STS_ERROR ;
190: FND_MSG_PUB.Count_And_Get
191: ( p_count => x_msg_count,
192: p_data => x_msg_data
193: );

Line 194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

190: FND_MSG_PUB.Count_And_Get
191: ( p_count => x_msg_count,
192: p_data => x_msg_data
193: );
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: ROLLBACK TO select_item_pvt;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197: FND_MSG_PUB.Count_And_Get
198: ( p_count => x_msg_count,

Line 196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

192: p_data => x_msg_data
193: );
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: ROLLBACK TO select_item_pvt;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197: FND_MSG_PUB.Count_And_Get
198: ( p_count => x_msg_count,
199: p_data => x_msg_data
200: );

Line 203: x_return_status := FND_API.G_RET_STS_ERROR;

199: p_data => x_msg_data
200: );
201: WHEN OTHERS THEN
202: ROLLBACK TO select_item_pvt;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: IF FND_MSG_PUB.Check_Msg_Level
205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: FND_MSG_PUB.Add_Exc_Msg

Line 238: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

234: -- Standard Start of API savepoint
235: SAVEPOINT create_item_wrap_PVT;
236:
237: -- Standard call to check for call compatibility.
238: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
239: p_api_version_number,
240: l_api_name,
241: G_PKG_NAME)
242: THEN

Line 243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

239: p_api_version_number,
240: l_api_name,
241: G_PKG_NAME)
242: THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245:
246: -- Initialize message list if p_init_msg_list is set to TRUE.
247: IF FND_API.to_Boolean( p_init_msg_list )

Line 247: IF FND_API.to_Boolean( p_init_msg_list )

243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245:
246: -- Initialize message list if p_init_msg_list is set to TRUE.
247: IF FND_API.to_Boolean( p_init_msg_list )
248: THEN
249: FND_MSG_PUB.initialize;
250: END IF;
251:

Line 253: x_return_status := FND_API.G_RET_STS_SUCCESS;

249: FND_MSG_PUB.initialize;
250: END IF;
251:
252: -- Initialize API return status to SUCCESS
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254: IEM_ACT_CATG_PVT.create_item (p_api_version_number=>1.0,
255: p_init_msg_list=>'F' ,
256: p_commit=>'F' ,
257: p_email_account_id=>p_email_account_id,

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

278: p_ATTRIBUTE15 =>null,
279: x_return_status=>l_return_status,
280: x_msg_count=>l_msg_count,
281: x_msg_data=>l_msg_data);
282: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
283: raise CREATE_ITEM_EXCP;
284: x_return_status:=FND_API.G_RET_STS_SUCCESS;
285: end if;
286: -- Standard Check Of p_commit.

Line 284: x_return_status:=FND_API.G_RET_STS_SUCCESS;

280: x_msg_count=>l_msg_count,
281: x_msg_data=>l_msg_data);
282: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
283: raise CREATE_ITEM_EXCP;
284: x_return_status:=FND_API.G_RET_STS_SUCCESS;
285: end if;
286: -- Standard Check Of p_commit.
287: IF FND_API.To_Boolean(p_commit) THEN
288: COMMIT WORK;

Line 287: IF FND_API.To_Boolean(p_commit) THEN

283: raise CREATE_ITEM_EXCP;
284: x_return_status:=FND_API.G_RET_STS_SUCCESS;
285: end if;
286: -- Standard Check Of p_commit.
287: IF FND_API.To_Boolean(p_commit) THEN
288: COMMIT WORK;
289: END IF;
290: EXCEPTION
291: WHEN CREATE_ITEM_EXCP THEN

Line 293: x_return_status := FND_API.G_RET_STS_ERROR ;

289: END IF;
290: EXCEPTION
291: WHEN CREATE_ITEM_EXCP THEN
292: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
293: x_return_status := FND_API.G_RET_STS_ERROR ;
294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
297: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 295: WHEN FND_API.G_EXC_ERROR THEN

291: WHEN CREATE_ITEM_EXCP THEN
292: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
293: x_return_status := FND_API.G_RET_STS_ERROR ;
294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
297: x_return_status := FND_API.G_RET_STS_ERROR ;
298: FND_MSG_PUB.Count_And_Get
299: ( p_count => x_msg_count,

Line 297: x_return_status := FND_API.G_RET_STS_ERROR ;

293: x_return_status := FND_API.G_RET_STS_ERROR ;
294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
297: x_return_status := FND_API.G_RET_STS_ERROR ;
298: FND_MSG_PUB.Count_And_Get
299: ( p_count => x_msg_count,
300: p_data => x_msg_data
301: );

Line 302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

298: FND_MSG_PUB.Count_And_Get
299: ( p_count => x_msg_count,
300: p_data => x_msg_data
301: );
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
303: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
305: FND_MSG_PUB.Count_And_Get
306: ( p_count => x_msg_count,

Line 304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

300: p_data => x_msg_data
301: );
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
303: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
305: FND_MSG_PUB.Count_And_Get
306: ( p_count => x_msg_count,
307: p_data => x_msg_data
308: );

Line 311: x_return_status := FND_API.G_RET_STS_ERROR;

307: p_data => x_msg_data
308: );
309: WHEN OTHERS THEN
310: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: IF FND_MSG_PUB.Check_Msg_Level
313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
314: THEN
315: FND_MSG_PUB.Add_Exc_Msg