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

Line 53: RAISE fnd_api.g_exc_unexpected_error;

49: THEN
50: CLOSE c_lock;
51: fnd_message.set_name ('JTF', 'JTF_CAL_RECORD_DELETED');
52: fnd_msg_pub.add;
53: RAISE fnd_api.g_exc_unexpected_error;
54: END IF;
55:
56: /***************************************************************************
57: ** If the object version number has changed, the record has changed:

Line 65: RAISE fnd_api.g_exc_unexpected_error;

61: IF (l_object_version_number <> p_object_version_number)
62: THEN
63: fnd_message.set_name ('JTF', 'JTF_CAL_RECORD_CHANGED');
64: fnd_msg_pub.add;
65: RAISE fnd_api.g_exc_unexpected_error;
66: END IF;
67: END Lock_Row;
68:
69: PROCEDURE Insert_Row

Line 98: IF NOT FND_API.Compatible_API_Call( l_api_version

94: SAVEPOINT create_calitems_pvt;
95: /***************************************************************************
96: ** Standard call to check for call compatibility
97: ***************************************************************************/
98: IF NOT FND_API.Compatible_API_Call( l_api_version
99: , p_api_version
100: , l_api_name
101: , G_PKG_NAME
102: )

Line 104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

100: , l_api_name
101: , G_PKG_NAME
102: )
103: THEN
104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
105: END IF;
106: /***************************************************************************
107: ** Initialize message list if p_init_msg_list is set to TRUE
108: ***************************************************************************/

Line 110: IF FND_API.To_Boolean(p_init_msg_list)

106: /***************************************************************************
107: ** Initialize message list if p_init_msg_list is set to TRUE
108: ***************************************************************************/
109:
110: IF FND_API.To_Boolean(p_init_msg_list)
111: THEN
112: FND_MSG_PUB.Initialize;
113: END IF;
114: /***************************************************************************

Line 117: x_return_status := FND_API.G_RET_STS_SUCCESS;

113: END IF;
114: /***************************************************************************
115: ** Initialize API return status to success
116: ***************************************************************************/
117: x_return_status := FND_API.G_RET_STS_SUCCESS;
118: /***************************************************************************
119: ** Insert into table. Generate the ID from the
120: ** sequence and return it
121: ***************************************************************************/

Line 221: IF FND_API.To_Boolean(p_commit)

217: x_cal_item_id := l_cal_item_id;
218: /***************************************************************************
219: ** Standard check of p_commit
220: ***************************************************************************/
221: IF FND_API.To_Boolean(p_commit)
222: THEN
223: COMMIT WORK;
224: END IF;
225: /***************************************************************************

Line 232: WHEN FND_API.G_EXC_ERROR THEN

228: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
229: , p_data => x_msg_data
230: );
231: EXCEPTION
232: WHEN FND_API.G_EXC_ERROR THEN
233: IF (c_record_exists%ISOPEN)THEN
234: CLOSE c_record_exists;
235: END IF;
236: ROLLBACK TO create_calitems_pvt;

Line 237: x_return_status := FND_API.G_RET_STS_ERROR;

233: IF (c_record_exists%ISOPEN)THEN
234: CLOSE c_record_exists;
235: END IF;
236: ROLLBACK TO create_calitems_pvt;
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
239: , p_data => x_msg_data
240: );
241:

Line 242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

238: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
239: , p_data => x_msg_data
240: );
241:
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: IF (c_record_exists%ISOPEN) THEN
244: CLOSE c_record_exists;
245: END IF;
246: ROLLBACK TO create_calitems_pvt;

Line 247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

243: IF (c_record_exists%ISOPEN) THEN
244: CLOSE c_record_exists;
245: END IF;
246: ROLLBACK TO create_calitems_pvt;
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
249: , p_data => x_msg_data
250: );
251: WHEN OTHERS THEN

Line 256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

252: IF (c_record_exists%ISOPEN) THEN
253: CLOSE c_record_exists;
254: END IF;
255: ROLLBACK TO create_calitems_pvt;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
258: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
259: , l_api_name
260: );

Line 270: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

266: END Insert_Row;
267:
268: PROCEDURE Update_Row
269: ( p_api_version IN NUMBER
270: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
271: , p_commit IN VARCHAR2 := fnd_api.g_false
272: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
273: , x_return_status OUT NOCOPY VARCHAR2
274: , x_msg_count OUT NOCOPY NUMBER

Line 271: , p_commit IN VARCHAR2 := fnd_api.g_false

267:
268: PROCEDURE Update_Row
269: ( p_api_version IN NUMBER
270: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
271: , p_commit IN VARCHAR2 := fnd_api.g_false
272: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
273: , x_return_status OUT NOCOPY VARCHAR2
274: , x_msg_count OUT NOCOPY NUMBER
275: , x_msg_data OUT NOCOPY VARCHAR2

Line 272: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full

268: PROCEDURE Update_Row
269: ( p_api_version IN NUMBER
270: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
271: , p_commit IN VARCHAR2 := fnd_api.g_false
272: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
273: , x_return_status OUT NOCOPY VARCHAR2
274: , x_msg_count OUT NOCOPY NUMBER
275: , x_msg_data OUT NOCOPY VARCHAR2
276: , p_itm_rec IN cal_item_rec_type

Line 283: fnd_api.g_miss_num, resource_id,

279: CURSOR c_item (l_cal_item_id IN NUMBER)
280: IS
281: SELECT DECODE (
282: p_itm_rec.resource_id,
283: fnd_api.g_miss_num, resource_id,
284: p_itm_rec.resource_id
285: ) resource_id,
286: DECODE (
287: p_itm_rec.resource_type,

Line 288: fnd_api.g_miss_char, resource_type,

284: p_itm_rec.resource_id
285: ) resource_id,
286: DECODE (
287: p_itm_rec.resource_type,
288: fnd_api.g_miss_char, resource_type,
289: p_itm_rec.resource_type
290: ) resource_type,
291: DECODE (
292: p_itm_rec.source_code,

Line 293: fnd_api.g_miss_char, source_code,

289: p_itm_rec.resource_type
290: ) resource_type,
291: DECODE (
292: p_itm_rec.source_code,
293: fnd_api.g_miss_char, source_code,
294: p_itm_rec.source_code
295: ) source_code,
296: DECODE (
297: p_itm_rec.source_id,

Line 298: fnd_api.g_miss_num, source_id,

294: p_itm_rec.source_code
295: ) source_code,
296: DECODE (
297: p_itm_rec.source_id,
298: fnd_api.g_miss_num, source_id,
299: p_itm_rec.source_id
300: ) source_id,
301: DECODE (
302: p_itm_rec.start_date,

Line 303: fnd_api.g_miss_date, start_date,

299: p_itm_rec.source_id
300: ) source_id,
301: DECODE (
302: p_itm_rec.start_date,
303: fnd_api.g_miss_date, start_date,
304: p_itm_rec.start_date
305: ) start_date,
306: DECODE (
307: p_itm_rec.end_date,

Line 308: fnd_api.g_miss_date, end_date,

304: p_itm_rec.start_date
305: ) start_date,
306: DECODE (
307: p_itm_rec.end_date,
308: fnd_api.g_miss_date, end_date,
309: p_itm_rec.end_date
310: ) end_date,
311: DECODE (
312: p_itm_rec.timezone_id,

Line 313: fnd_api.g_miss_num, timezone_id,

309: p_itm_rec.end_date
310: ) end_date,
311: DECODE (
312: p_itm_rec.timezone_id,
313: fnd_api.g_miss_num, timezone_id,
314: p_itm_rec.timezone_id
315: ) timezone_id,
316: DECODE (
317: p_itm_rec.url,

Line 318: fnd_api.g_miss_char, url,

314: p_itm_rec.timezone_id
315: ) timezone_id,
316: DECODE (
317: p_itm_rec.url,
318: fnd_api.g_miss_char, url,
319: p_itm_rec.url
320: ) url,
321: DECODE (
322: p_itm_rec.created_by,

Line 323: fnd_api.g_miss_num, jtf_cal_items_b.created_by,

319: p_itm_rec.url
320: ) url,
321: DECODE (
322: p_itm_rec.created_by,
323: fnd_api.g_miss_num, jtf_cal_items_b.created_by,
324: p_itm_rec.created_by
325: ) created_by,
326: DECODE (
327: p_itm_rec.creation_date,

Line 328: fnd_api.g_miss_date, jtf_cal_items_b.creation_date,

324: p_itm_rec.created_by
325: ) created_by,
326: DECODE (
327: p_itm_rec.creation_date,
328: fnd_api.g_miss_date, jtf_cal_items_b.creation_date,
329: p_itm_rec.creation_date
330: ) creation_date,
331: DECODE (
332: p_itm_rec.last_updated_by,

Line 333: fnd_api.g_miss_num, jtf_cal_items_b.last_updated_by,

329: p_itm_rec.creation_date
330: ) creation_date,
331: DECODE (
332: p_itm_rec.last_updated_by,
333: fnd_api.g_miss_num, jtf_cal_items_b.last_updated_by,
334: p_itm_rec.last_updated_by
335: ) last_updated_by,
336: DECODE (
337: p_itm_rec.last_update_date,

Line 338: fnd_api.g_miss_date, jtf_cal_items_b.last_update_date,

334: p_itm_rec.last_updated_by
335: ) last_updated_by,
336: DECODE (
337: p_itm_rec.last_update_date,
338: fnd_api.g_miss_date, jtf_cal_items_b.last_update_date,
339: p_itm_rec.last_update_date
340: ) last_update_date,
341: DECODE (
342: p_itm_rec.last_update_login,

Line 343: fnd_api.g_miss_num, jtf_cal_items_b.last_update_login,

339: p_itm_rec.last_update_date
340: ) last_update_date,
341: DECODE (
342: p_itm_rec.last_update_login,
343: fnd_api.g_miss_num, jtf_cal_items_b.last_update_login,
344: p_itm_rec.last_update_login
345: ) last_update_login,
346: DECODE (
347: p_itm_rec.application_id,

Line 348: fnd_api.g_miss_num, jtf_cal_items_b.application_id,

344: p_itm_rec.last_update_login
345: ) last_update_login,
346: DECODE (
347: p_itm_rec.application_id,
348: fnd_api.g_miss_num, jtf_cal_items_b.application_id,
349: p_itm_rec.application_id
350: ) application_id,
351: DECODE (
352: p_itm_rec.item_name,

Line 353: fnd_api.g_miss_char, item_name,

349: p_itm_rec.application_id
350: ) application_id,
351: DECODE (
352: p_itm_rec.item_name,
353: fnd_api.g_miss_char, item_name,
354: p_itm_rec.item_name
355: ) item_name
356: FROM jtf_cal_items_b, jtf_cal_items_tl
357: WHERE jtf_cal_items_b.cal_item_id = l_cal_item_id

Line 364: l_url VARCHAR2(4000) := fnd_api.g_miss_char;

360:
361: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
362: l_api_version CONSTANT NUMBER := 1.0;
363: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
364: l_url VARCHAR2(4000) := fnd_api.g_miss_char;
365: l_item_rec c_item%ROWTYPE;
366:
367: BEGIN
368:

Line 374: IF NOT FND_API.Compatible_API_Call( l_api_version

370:
371: /***************************************************************************
372: ** Standard call to check for call compatibility
373: ***************************************************************************/
374: IF NOT FND_API.Compatible_API_Call( l_api_version
375: , p_api_version
376: , l_api_name
377: , G_PKG_NAME
378: )

Line 380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

376: , l_api_name
377: , G_PKG_NAME
378: )
379: THEN
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: END IF;
382: /***************************************************************************
383: ** Initialize message list if p_init_msg_list is set to TRUE
384: ***************************************************************************/

Line 385: IF FND_API.To_Boolean(p_init_msg_list)

381: END IF;
382: /***************************************************************************
383: ** Initialize message list if p_init_msg_list is set to TRUE
384: ***************************************************************************/
385: IF FND_API.To_Boolean(p_init_msg_list)
386: THEN
387: FND_MSG_PUB.initialize;
388: END IF;
389: /***************************************************************************

Line 392: x_return_status := FND_API.G_RET_STS_SUCCESS;

388: END IF;
389: /***************************************************************************
390: ** Initialize API return status to success
391: ***************************************************************************/
392: x_return_status := FND_API.G_RET_STS_SUCCESS;
393: IF (c_item%ISOPEN) THEN
394: CLOSE c_item;
395: END IF;
396: OPEN c_item(p_itm_rec.cal_item_id);

Line 420: RAISE FND_API.g_exc_unexpected_error;

416: FND_MESSAGE.set_name('JTF', 'JTF_CAL_END_DATE');
417: FND_MESSAGE.set_token('P_START_DATE', to_char(l_item_rec.START_DATE, 'YYYYMMDDHH24MISS'));
418: FND_MESSAGE.set_token('P_END_DATE', to_char(l_item_rec.END_DATE, 'YYYYMMDDHH24MISS'));
419: FND_MSG_pub.ADD;
420: RAISE FND_API.g_exc_unexpected_error;
421: END IF;
422: /***************************************************************************
423: ** Try to lock the row before updating it
424: ***************************************************************************/

Line 472: IF FND_API.To_Boolean(p_commit) THEN

468: END IF;
469: /***************************************************************************
470: ** Standard check of p_commit
471: ***************************************************************************/
472: IF FND_API.To_Boolean(p_commit) THEN
473: COMMIT WORK;
474: END IF;
475: /***************************************************************************
476: ** Standard call to get message count and if count is 1, get message info

Line 483: WHEN FND_API.G_EXC_ERROR THEN

479: , p_data => x_msg_data
480: );
481:
482: EXCEPTION
483: WHEN FND_API.G_EXC_ERROR THEN
484: IF (c_item%ISOPEN)THEN
485: CLOSE c_item;
486: END IF;
487: ROLLBACK TO update_calitems_pvt;

Line 488: x_return_status := FND_API.G_RET_STS_ERROR;

484: IF (c_item%ISOPEN)THEN
485: CLOSE c_item;
486: END IF;
487: ROLLBACK TO update_calitems_pvt;
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
490: , p_data => x_msg_data
491: );
492:

Line 493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

489: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
490: , p_data => x_msg_data
491: );
492:
493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
494: IF (c_item%ISOPEN) THEN
495: CLOSE c_item;
496: END IF;
497: ROLLBACK TO update_calitems_pvt;

Line 498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

494: IF (c_item%ISOPEN) THEN
495: CLOSE c_item;
496: END IF;
497: ROLLBACK TO update_calitems_pvt;
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
500: , p_data => x_msg_data
501: );
502: WHEN OTHERS THEN

Line 507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

503: IF (c_item%ISOPEN) THEN
504: CLOSE c_item;
505: END IF;
506: ROLLBACK TO update_calitems_pvt;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
509: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
510: , l_api_name
511: );

Line 541: IF NOT FND_API.Compatible_API_Call( l_api_version

537:
538: /***************************************************************************
539: ** Standard call to check for call compatibility
540: ***************************************************************************/
541: IF NOT FND_API.Compatible_API_Call( l_api_version
542: , p_api_version
543: , l_api_name
544: , G_PKG_NAME
545: )

Line 547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

543: , l_api_name
544: , G_PKG_NAME
545: )
546: THEN
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: END IF;
549: /***************************************************************************
550: ** Initialize message list if requested
551: ***************************************************************************/

Line 552: IF FND_API.to_Boolean( p_init_msg_list )

548: END IF;
549: /***************************************************************************
550: ** Initialize message list if requested
551: ***************************************************************************/
552: IF FND_API.to_Boolean( p_init_msg_list )
553: THEN
554: FND_MSG_PUB.initialize;
555: END IF;
556: /***************************************************************************

Line 559: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

555: END IF;
556: /***************************************************************************
557: ** Initialize return status to SUCCESS
558: ***************************************************************************/
559: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
560:
561: DELETE FROM JTF_CAL_ITEMS_TL
562: WHERE CAL_ITEM_ID = p_cal_item_id;
563: /***************************************************************************

Line 586: IF FND_API.To_Boolean(p_commit) THEN

582: IF (SQL%NOTFOUND)THEN
583: RAISE no_data_found;
584: END IF;
585:
586: IF FND_API.To_Boolean(p_commit) THEN
587: COMMIT WORK;
588: END IF;
589:
590: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

Line 594: WHEN FND_API.G_EXC_ERROR

590: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
591: , p_data => X_MSG_DATA
592: );
593: EXCEPTION
594: WHEN FND_API.G_EXC_ERROR
595: THEN
596: ROLLBACK TO delete_calitems_pvt;
597: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
598: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

Line 597: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

593: EXCEPTION
594: WHEN FND_API.G_EXC_ERROR
595: THEN
596: ROLLBACK TO delete_calitems_pvt;
597: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
598: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
599: , p_data => X_MSG_DATA
600: );
601:

Line 602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

598: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
599: , p_data => X_MSG_DATA
600: );
601:
602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
603: THEN
604: ROLLBACK TO delete_calitems_pvt;
605: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
606: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

Line 605: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

601:
602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
603: THEN
604: ROLLBACK TO delete_calitems_pvt;
605: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
606: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
607: , p_data => X_MSG_DATA
608: );
609: WHEN OTHERS THEN

Line 611: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

607: , p_data => X_MSG_DATA
608: );
609: WHEN OTHERS THEN
610: ROLLBACK TO delete_calitems_pvt;
611: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
612: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
613: THEN
614: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
615: , l_api_name

Line 649: IF NOT FND_API.Compatible_API_Call( l_api_version

645: BEGIN
646: /***************************************************************************
647: ** Standard call to check for call compatibility
648: ***************************************************************************/
649: IF NOT FND_API.Compatible_API_Call( l_api_version
650: , p_api_version
651: , l_api_name
652: , G_PKG_NAME
653: )

Line 655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

651: , l_api_name
652: , G_PKG_NAME
653: )
654: THEN
655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: END IF;
657: /***************************************************************************
658: ** Initialize message list if p_init_msg_list is set to TRUE
659: ***************************************************************************/

Line 660: IF FND_API.To_Boolean(p_init_msg_list)

656: END IF;
657: /***************************************************************************
658: ** Initialize message list if p_init_msg_list is set to TRUE
659: ***************************************************************************/
660: IF FND_API.To_Boolean(p_init_msg_list)
661: THEN
662: FND_MSG_PUB.Initialize;
663: END IF;
664: /***************************************************************************

Line 667: x_return_status := FND_API.G_RET_STS_SUCCESS;

663: END IF;
664: /***************************************************************************
665: ** Initialize API return status to success
666: ***************************************************************************/
667: x_return_status := FND_API.G_RET_STS_SUCCESS;
668: /***************************************************************************
669: ** Get the object_version_number
670: ***************************************************************************/
671: IF (c_cal_item%ISOPEN)