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

Line 136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

132:
133: END user_id;
134:
135: PROCEDURE Validate_any_id(p_api_version IN NUMBER := 1.0,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: x_return_status OUT NOCOPY VARCHAR2,
140: p_col_id IN NUMBER,

Line 160: x_return_status := FND_API.G_RET_STS_SUCCESS;

156: -- Standard Start of API savepoint
157: SAVEPOINT Validate_any_id_PVT;
158:
159: -- Initialize API return status to SUCCESS
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161:
162:
163: -- Standard call to check for call compatibility.
164: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 164: IF NOT FND_API.Compatible_API_Call (l_api_version,

160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161:
162:
163: -- Standard call to check for call compatibility.
164: IF NOT FND_API.Compatible_API_Call (l_api_version,
165: p_api_version,
166: l_api_name,
167: G_PKG_NAME)
168: THEN

Line 169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

165: p_api_version,
166: l_api_name,
167: G_PKG_NAME)
168: THEN
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: END IF;
171:
172: -- Initialize message list if p_init_msg_list is set to TRUE.
173: IF FND_API.to_Boolean(p_init_msg_list)

Line 173: IF FND_API.to_Boolean(p_init_msg_list)

169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: END IF;
171:
172: -- Initialize message list if p_init_msg_list is set to TRUE.
173: IF FND_API.to_Boolean(p_init_msg_list)
174: THEN
175: FND_MSG_PUB.initialize;
176: END IF;
177:

Line 194: l_return_status := FND_API.G_RET_STS_SUCCESS;

190: FETCH valid_id INTO count_id;
191:
192: if valid_id%FOUND then
193: --dbms_output.put_line('FOUND!!');
194: l_return_status := FND_API.G_RET_STS_SUCCESS;
195: else
196: --dbms_output.put_line('NOT FOUND!!');
197: l_return_status := FND_API.G_RET_STS_ERROR;
198: end if;

Line 197: l_return_status := FND_API.G_RET_STS_ERROR;

193: --dbms_output.put_line('FOUND!!');
194: l_return_status := FND_API.G_RET_STS_SUCCESS;
195: else
196: --dbms_output.put_line('NOT FOUND!!');
197: l_return_status := FND_API.G_RET_STS_ERROR;
198: end if;
199: CLOSE valid_id;
200:
201: x_return_status := l_return_status;

Line 204: WHEN FND_API.G_EXC_ERROR THEN

200:
201: x_return_status := l_return_status;
202:
203: EXCEPTION
204: WHEN FND_API.G_EXC_ERROR THEN
205: ROLLBACK TO Validate_any_id_PVT;
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
208:

Line 206: x_return_status := FND_API.G_RET_STS_ERROR;

202:
203: EXCEPTION
204: WHEN FND_API.G_EXC_ERROR THEN
205: ROLLBACK TO Validate_any_id_PVT;
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: ROLLBACK TO Validate_any_id_PVT;

Line 209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

205: ROLLBACK TO Validate_any_id_PVT;
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: ROLLBACK TO Validate_any_id_PVT;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
213:

Line 211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

207: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: ROLLBACK TO Validate_any_id_PVT;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
213:
214: WHEN OTHERS THEN
215: ROLLBACK TO Validate_any_id_PVT;

Line 216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

212: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
213:
214: WHEN OTHERS THEN
215: ROLLBACK TO Validate_any_id_PVT;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
218: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
219: END IF;
220: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

221:
222: END Validate_any_id;
223:
224: PROCEDURE Validate_any_varchar(p_api_version IN NUMBER := 1.0,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: x_return_status OUT NOCOPY VARCHAR2,
229: p_col_value IN VARCHAR2,

Line 252: x_return_status := FND_API.G_RET_STS_SUCCESS;

248: -- Standard Start of API savepoint
249: SAVEPOINT Validate_any_varchar_PVT;
250:
251: -- Initialize API return status to SUCCESS
252: x_return_status := FND_API.G_RET_STS_SUCCESS;
253:
254:
255: -- Standard call to check for call compatibility.
256: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 256: IF NOT FND_API.Compatible_API_Call (l_api_version,

252: x_return_status := FND_API.G_RET_STS_SUCCESS;
253:
254:
255: -- Standard call to check for call compatibility.
256: IF NOT FND_API.Compatible_API_Call (l_api_version,
257: p_api_version,
258: l_api_name,
259: G_PKG_NAME)
260: THEN

Line 261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

257: p_api_version,
258: l_api_name,
259: G_PKG_NAME)
260: THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263:
264: -- Initialize message list if p_init_msg_list is set to TRUE.
265: IF FND_API.to_Boolean(p_init_msg_list)

Line 265: IF FND_API.to_Boolean(p_init_msg_list)

261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263:
264: -- Initialize message list if p_init_msg_list is set to TRUE.
265: IF FND_API.to_Boolean(p_init_msg_list)
266: THEN
267: FND_MSG_PUB.initialize;
268: END IF;
269:

Line 288: l_return_status := FND_API.G_RET_STS_SUCCESS;

284: FETCH valid_id INTO count_id;
285:
286: if valid_id%FOUND then
287: --dbms_output.put_line('FOUND!!');
288: l_return_status := FND_API.G_RET_STS_SUCCESS;
289: else
290: --dbms_output.put_line('NOT FOUND!!');
291: l_return_status := FND_API.G_RET_STS_ERROR;
292: end if;

Line 291: l_return_status := FND_API.G_RET_STS_ERROR;

287: --dbms_output.put_line('FOUND!!');
288: l_return_status := FND_API.G_RET_STS_SUCCESS;
289: else
290: --dbms_output.put_line('NOT FOUND!!');
291: l_return_status := FND_API.G_RET_STS_ERROR;
292: end if;
293: CLOSE valid_id;
294:
295: x_return_status := l_return_status;

Line 298: WHEN FND_API.G_EXC_ERROR THEN

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

Line 300: x_return_status := FND_API.G_RET_STS_ERROR;

296:
297: EXCEPTION
298: WHEN FND_API.G_EXC_ERROR THEN
299: ROLLBACK TO Validate_any_varchar_PVT;
300: x_return_status := FND_API.G_RET_STS_ERROR;
301: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
302:
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304: ROLLBACK TO Validate_any_varchar_PVT;

Line 303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

306: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
307:
308: WHEN OTHERS THEN
309: ROLLBACK TO Validate_any_varchar_PVT;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
312: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
313: END IF;
314: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 319: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

315:
316: END Validate_any_varchar;
317:
318: PROCEDURE Validate_Lookup_CODE(p_api_version IN NUMBER := 1.0,
319: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2,
322: x_return_status OUT NOCOPY VARCHAR2,
323: p_lookup_type IN VARCHAR2,

Line 347: x_return_status := FND_API.G_RET_STS_SUCCESS;

343: -- Standard Start of API savepoint
344: SAVEPOINT Validate_any_varchar_PVT;
345:
346: -- Initialize API return status to SUCCESS
347: x_return_status := FND_API.G_RET_STS_SUCCESS;
348:
349: -- Standard call to check for call compatibility.
350: IF NOT FND_API.Compatible_API_Call (l_api_version,
351: p_api_version,

Line 350: IF NOT FND_API.Compatible_API_Call (l_api_version,

346: -- Initialize API return status to SUCCESS
347: x_return_status := FND_API.G_RET_STS_SUCCESS;
348:
349: -- Standard call to check for call compatibility.
350: IF NOT FND_API.Compatible_API_Call (l_api_version,
351: p_api_version,
352: l_api_name,
353: G_PKG_NAME)
354: THEN

Line 355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

351: p_api_version,
352: l_api_name,
353: G_PKG_NAME)
354: THEN
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: END IF;
357:
358: -- Initialize message list if p_init_msg_list is set to TRUE.
359: IF FND_API.to_Boolean(p_init_msg_list)

Line 359: IF FND_API.to_Boolean(p_init_msg_list)

355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: END IF;
357:
358: -- Initialize message list if p_init_msg_list is set to TRUE.
359: IF FND_API.to_Boolean(p_init_msg_list)
360: THEN
361: FND_MSG_PUB.initialize;
362: END IF;
363:

Line 384: l_return_status := FND_API.G_RET_STS_SUCCESS;

380:
381: CLOSE valid_id ;
382:
383: IF (count_id > 0) then
384: l_return_status := FND_API.G_RET_STS_SUCCESS;
385: ELSE
386: l_return_status := FND_API.G_RET_STS_ERROR;
387: END IF ;
388: x_return_status := l_return_status;

Line 386: l_return_status := FND_API.G_RET_STS_ERROR;

382:
383: IF (count_id > 0) then
384: l_return_status := FND_API.G_RET_STS_SUCCESS;
385: ELSE
386: l_return_status := FND_API.G_RET_STS_ERROR;
387: END IF ;
388: x_return_status := l_return_status;
389:
390: EXCEPTION

Line 391: WHEN FND_API.G_EXC_ERROR THEN

387: END IF ;
388: x_return_status := l_return_status;
389:
390: EXCEPTION
391: WHEN FND_API.G_EXC_ERROR THEN
392: ROLLBACK TO Validate_any_varchar_PVT;
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
395:

Line 393: x_return_status := FND_API.G_RET_STS_ERROR;

389:
390: EXCEPTION
391: WHEN FND_API.G_EXC_ERROR THEN
392: ROLLBACK TO Validate_any_varchar_PVT;
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
395:
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO Validate_any_varchar_PVT;

Line 396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

392: ROLLBACK TO Validate_any_varchar_PVT;
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
395:
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO Validate_any_varchar_PVT;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
400:

Line 398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

394: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
395:
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO Validate_any_varchar_PVT;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
400:
401: WHEN OTHERS THEN
402: ROLLBACK TO Validate_any_varchar_PVT;

Line 403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

399: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
400:
401: WHEN OTHERS THEN
402: ROLLBACK TO Validate_any_varchar_PVT;
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
405: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
406: END IF;
407: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 446: RAISE FND_API.G_EXC_ERROR;

442: THEN
443: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
444: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);
445: FND_MSG_PUB.ADD;
446: RAISE FND_API.G_EXC_ERROR;
447: END IF;
448:
449: x_object_version_number := nvl(l_object_version_number, 1) + 1;
450:

Line 457: x_return_status := FND_API.G_RET_STS_ERROR;

453: FND_MESSAGE.SET_TOKEN('RECORD', p_primary_key_name);
454: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_primary_key_value), 'null'));
455: FND_MSG_PUB.ADD;
456: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: --RAISE FND_API.G_EXC_ERROR;
459: END getObjectVersion;
460:
461:

Line 458: --RAISE FND_API.G_EXC_ERROR;

454: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_primary_key_value), 'null'));
455: FND_MSG_PUB.ADD;
456: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: --RAISE FND_API.G_EXC_ERROR;
459: END getObjectVersion;
460:
461:
462: FUNCTION get_lookup_meaning (p_lookup_type IN VARCHAR2,