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

Line 14: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

10: G_FILE_NAME CONSTANT VARCHAR2(12) := 'IBEVCNUB.pls';
11:
12: PROCEDURE Get_sales_assist_hdr_tokens(
13: p_api_version IN NUMBER := 1.0 ,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: x_return_status OUT NOCOPY VARCHAR2 ,
17: x_msg_count OUT NOCOPY NUMBER ,
18: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 15: p_commit IN VARCHAR2 := FND_API.G_FALSE,

11:
12: PROCEDURE Get_sales_assist_hdr_tokens(
13: p_api_version IN NUMBER := 1.0 ,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: x_return_status OUT NOCOPY VARCHAR2 ,
17: x_msg_count OUT NOCOPY NUMBER ,
18: x_msg_data OUT NOCOPY VARCHAR2 ,
19: p_quote_header_id IN NUMBER ,

Line 133: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,

129: -- Standard Start of API savepoint
130: SAVEPOINT Get_sales_assist_tokens_pvt;
131:
132: -- Standard call to check for call compatibility.
133: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
134: p_api_version,
135: L_API_NAME ,
136: G_PKG_NAME )
137: THEN

Line 138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

134: p_api_version,
135: L_API_NAME ,
136: G_PKG_NAME )
137: THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
141: -- Initialize message list if p_init_msg_list is set to TRUE.
142: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 142: IF FND_API.To_Boolean(p_init_msg_list) THEN

138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
141: -- Initialize message list if p_init_msg_list is set to TRUE.
142: IF FND_API.To_Boolean(p_init_msg_list) THEN
143: FND_Msg_Pub.initialize;
144: END IF;
145:
146: -- Initialize API return status to success

Line 147: x_return_status := FND_API.G_RET_STS_SUCCESS;

143: FND_Msg_Pub.initialize;
144: END IF;
145:
146: -- Initialize API return status to success
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149: --Start of API Body
150: l_inv_org_id := fnd_profile.value_specific('IBE_ITEM_VALIDATION_ORGANIZATION',null,null,671);
151: --671 is the application_id for iStore

Line 219: IF FND_API.To_Boolean(p_commit) THEN

215:
216: x_contact_phone := l_contact_phone;
217:
218: -- Standard check of p_commit.
219: IF FND_API.To_Boolean(p_commit) THEN
220: COMMIT WORK;
221: END IF;
222:
223: -- Standard call to get message count and if count is 1, get message info.

Line 224: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

220: COMMIT WORK;
221: END IF;
222:
223: -- Standard call to get message count and if count is 1, get message info.
224: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count ,
226: p_data => x_msg_data);
227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN

Line 228: WHEN FND_API.G_EXC_ERROR THEN

224: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count ,
226: p_data => x_msg_data);
227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: ROLLBACK TO Get_sales_assist_tokens_pvt;
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
232: p_count => x_msg_count ,

Line 230: x_return_status := FND_API.G_RET_STS_ERROR;

226: p_data => x_msg_data);
227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: ROLLBACK TO Get_sales_assist_tokens_pvt;
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
232: p_count => x_msg_count ,
233: p_data => x_msg_data);
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 231: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: ROLLBACK TO Get_sales_assist_tokens_pvt;
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
232: p_count => x_msg_count ,
233: p_data => x_msg_data);
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO Get_sales_assist_tokens_pvt;

Line 234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

230: x_return_status := FND_API.G_RET_STS_ERROR;
231: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
232: p_count => x_msg_count ,
233: p_data => x_msg_data);
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO Get_sales_assist_tokens_pvt;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count ,

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

232: p_count => x_msg_count ,
233: p_data => x_msg_data);
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO Get_sales_assist_tokens_pvt;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count ,
239: p_data => x_msg_data);
240: WHEN OTHERS THEN

Line 237: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

233: p_data => x_msg_data);
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO Get_sales_assist_tokens_pvt;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count ,
239: p_data => x_msg_data);
240: WHEN OTHERS THEN
241: ROLLBACK TO Get_sales_assist_tokens_pvt;

Line 242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

238: p_count => x_msg_count ,
239: p_data => x_msg_data);
240: WHEN OTHERS THEN
241: ROLLBACK TO Get_sales_assist_tokens_pvt;
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
243: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
244: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
245: L_API_NAME);
246: END IF;

Line 248: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

244: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
245: L_API_NAME);
246: END IF;
247:
248: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
249: p_count => x_msg_count ,
250: p_data => x_msg_data);
251:
252: END Get_sales_assist_hdr_tokens;

Line 256: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

252: END Get_sales_assist_hdr_tokens;
253:
254: PROCEDURE Get_sales_assist_line_tokens(
255: p_api_version IN NUMBER := 1.0 ,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
257: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
258: x_return_status OUT NOCOPY VARCHAR2 ,
259: x_msg_count OUT NOCOPY NUMBER ,
260: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 257: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

253:
254: PROCEDURE Get_sales_assist_line_tokens(
255: p_api_version IN NUMBER := 1.0 ,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
257: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
258: x_return_status OUT NOCOPY VARCHAR2 ,
259: x_msg_count OUT NOCOPY NUMBER ,
260: x_msg_data OUT NOCOPY VARCHAR2 ,
261: P_quote_header_id IN NUMBER ,

Line 293: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,

289: -- Standard Start of API savepoint
290: SAVEPOINT Create_New_Version_Pvt;
291:
292: -- Standard call to check for call compatibility.
293: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
294: p_api_version,
295: L_API_NAME ,
296: G_PKG_NAME )
297: THEN

Line 298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

294: p_api_version,
295: L_API_NAME ,
296: G_PKG_NAME )
297: THEN
298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
299: END IF;
300:
301: -- Initialize message list if p_init_msg_list is set to TRUE.
302: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 302: IF FND_API.To_Boolean(p_init_msg_list) THEN

298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
299: END IF;
300:
301: -- Initialize message list if p_init_msg_list is set to TRUE.
302: IF FND_API.To_Boolean(p_init_msg_list) THEN
303: FND_Msg_Pub.initialize;
304: END IF;
305:
306: -- Initialize API return status to success

Line 307: x_return_status := FND_API.G_RET_STS_SUCCESS;

303: FND_Msg_Pub.initialize;
304: END IF;
305:
306: -- Initialize API return status to success
307: x_return_status := FND_API.G_RET_STS_SUCCESS;
308:
309: --Start of API Body
310: for rec_get_notify_line_tokens in c_get_notify_line_tokens(p_quote_header_id) loop
311: l_notify_line_tokens(loop_counter).Quote_line_id := rec_get_notify_line_tokens.quote_line_id;

Line 322: IF FND_API.To_Boolean(p_commit) THEN

318: EXIT when c_get_notify_line_tokens%NOTFOUND;
319: END LOOP;
320: x_notify_line_tokens := l_notify_line_tokens;
321: -- Standard check of p_commit.
322: IF FND_API.To_Boolean(p_commit) THEN
323: COMMIT WORK;
324: END IF;
325:
326: -- Standard call to get message count and if count is 1, get message info.

Line 327: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

323: COMMIT WORK;
324: END IF;
325:
326: -- Standard call to get message count and if count is 1, get message info.
327: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count ,
329: p_data => x_msg_data);
330: EXCEPTION
331: WHEN FND_API.G_EXC_ERROR THEN

Line 331: WHEN FND_API.G_EXC_ERROR THEN

327: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count ,
329: p_data => x_msg_data);
330: EXCEPTION
331: WHEN FND_API.G_EXC_ERROR THEN
332: ROLLBACK TO Create_New_Version_Pvt;
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
335: p_count => x_msg_count ,

Line 333: x_return_status := FND_API.G_RET_STS_ERROR;

329: p_data => x_msg_data);
330: EXCEPTION
331: WHEN FND_API.G_EXC_ERROR THEN
332: ROLLBACK TO Create_New_Version_Pvt;
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
335: p_count => x_msg_count ,
336: p_data => x_msg_data);
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 334: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

330: EXCEPTION
331: WHEN FND_API.G_EXC_ERROR THEN
332: ROLLBACK TO Create_New_Version_Pvt;
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
335: p_count => x_msg_count ,
336: p_data => x_msg_data);
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: ROLLBACK TO Create_New_Version_Pvt;

Line 337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

333: x_return_status := FND_API.G_RET_STS_ERROR;
334: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
335: p_count => x_msg_count ,
336: p_data => x_msg_data);
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: ROLLBACK TO Create_New_Version_Pvt;
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
340: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
341: p_count => x_msg_count ,

Line 339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

335: p_count => x_msg_count ,
336: p_data => x_msg_data);
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: ROLLBACK TO Create_New_Version_Pvt;
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
340: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
341: p_count => x_msg_count ,
342: p_data => x_msg_data);
343: WHEN OTHERS THEN

Line 340: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

336: p_data => x_msg_data);
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: ROLLBACK TO Create_New_Version_Pvt;
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
340: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
341: p_count => x_msg_count ,
342: p_data => x_msg_data);
343: WHEN OTHERS THEN
344: ROLLBACK TO Create_New_Version_Pvt;

Line 345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

341: p_count => x_msg_count ,
342: p_data => x_msg_data);
343: WHEN OTHERS THEN
344: ROLLBACK TO Create_New_Version_Pvt;
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
346: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
347: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
348: L_API_NAME);
349: END IF;

Line 351: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

347: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
348: L_API_NAME);
349: END IF;
350:
351: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
352: p_count => x_msg_count ,
353: p_data => x_msg_data);
354:
355: END Get_sales_assist_line_tokens;