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

Line 89: x_return_status := fnd_api.g_ret_sts_success;

85:
86:
87: BEGIN
88: SAVEPOINT create_access_hours_pvt;
89: x_return_status := fnd_api.g_ret_sts_success;
90:
91: /* If (px_ACCESS_HOUR_ID IS NULL) OR (px_ACCESS_HOUR_ID = FND_API.G_MISS_NUM) then*/
92: OPEN c_next_seq;
93: FETCH c_next_seq INTO x_ACCESS_HOUR_ID;

Line 91: /* If (px_ACCESS_HOUR_ID IS NULL) OR (px_ACCESS_HOUR_ID = FND_API.G_MISS_NUM) then*/

87: BEGIN
88: SAVEPOINT create_access_hours_pvt;
89: x_return_status := fnd_api.g_ret_sts_success;
90:
91: /* If (px_ACCESS_HOUR_ID IS NULL) OR (px_ACCESS_HOUR_ID = FND_API.G_MISS_NUM) then*/
92: OPEN c_next_seq;
93: FETCH c_next_seq INTO x_ACCESS_HOUR_ID;
94: CLOSE c_next_seq;
95: /* End If;*/

Line 234: IF fnd_api.to_boolean(p_commit) THEN

230:
231:
232:
233: -- Standard check of p_commit
234: IF fnd_api.to_boolean(p_commit) THEN
235: commit work;
236: END IF;
237:
238: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

Line 241: WHEN fnd_api.g_exc_error then

237:
238: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
239: EXCEPTION
240:
241: WHEN fnd_api.g_exc_error then
242: ROLLBACK TO create_access_hours_pub;
243: x_return_status :=fnd_api.g_ret_sts_error;
244: /*x_msg_count := l_msg_count;
245: x_msg_data := l_msg_data;*/

Line 243: x_return_status :=fnd_api.g_ret_sts_error;

239: EXCEPTION
240:
241: WHEN fnd_api.g_exc_error then
242: ROLLBACK TO create_access_hours_pub;
243: x_return_status :=fnd_api.g_ret_sts_error;
244: /*x_msg_count := l_msg_count;
245: x_msg_data := l_msg_data;*/
246: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
247:

Line 248: When fnd_api.g_exc_unexpected_error then

244: /*x_msg_count := l_msg_count;
245: x_msg_data := l_msg_data;*/
246: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
247:
248: When fnd_api.g_exc_unexpected_error then
249: Rollback TO create_access_hours_pvt;
250: x_return_status:= fnd_api.g_ret_sts_unexp_error;
251: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
252:

Line 250: x_return_status:= fnd_api.g_ret_sts_unexp_error;

246: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
247:
248: When fnd_api.g_exc_unexpected_error then
249: Rollback TO create_access_hours_pvt;
250: x_return_status:= fnd_api.g_ret_sts_unexp_error;
251: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
252:
253: When others then
254: Rollback TO create_access_hours_pvt;

Line 255: x_return_status:= fnd_api.g_ret_sts_unexp_error;

251: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
252:
253: When others then
254: Rollback TO create_access_hours_pvt;
255: x_return_status:= fnd_api.g_ret_sts_unexp_error;
256: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
257:
258: End CREATE_ACCESS_HOURS;
259:

Line 316: x_return_status := fnd_api.g_ret_sts_success;

312: l_msg_count NUMBER;
313: l_msg_data varchar2(1000);
314: BEGIN
315:
316: x_return_status := fnd_api.g_ret_sts_success;
317: px_object_version_number:=px_object_version_number+1;
318: Update CSF_ACCESS_HOURS_B
319: SET
320:

Line 360: Raise fnd_api.g_exc_unexpected_error;

356: and TASK_ID=p_TASK_ID;
357:
358: If (SQL%NOTFOUND) then
359: -- RAISE NO_DATA_FOUND;
360: Raise fnd_api.g_exc_unexpected_error;
361: end if;
362:
363:
364: update CSF_ACCESS_HOURS_TL set

Line 375: Raise fnd_api.g_exc_unexpected_error;

371: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
372:
373: If (SQL%NOTFOUND) then
374: -- RAISE NO_DATA_FOUND;
375: Raise fnd_api.g_exc_unexpected_error;
376: end if;
377:
378:
379: -- Standard check of p_commit

Line 380: IF fnd_api.to_boolean(p_commit) THEN

376: end if;
377:
378:
379: -- Standard check of p_commit
380: IF fnd_api.to_boolean(p_commit) THEN
381: commit work;
382: END IF;
383: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
384:

Line 387: WHEN fnd_api.g_exc_error then

383: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
384:
385: EXCEPTION
386:
387: WHEN fnd_api.g_exc_error then
388: --ROLLBACK TO delete_access_hours_pub;
389: x_return_status :=fnd_api.g_ret_sts_error;
390: /*x_msg_count := l_msg_count;
391: x_msg_data := l_msg_data;*/

Line 389: x_return_status :=fnd_api.g_ret_sts_error;

385: EXCEPTION
386:
387: WHEN fnd_api.g_exc_error then
388: --ROLLBACK TO delete_access_hours_pub;
389: x_return_status :=fnd_api.g_ret_sts_error;
390: /*x_msg_count := l_msg_count;
391: x_msg_data := l_msg_data;*/
392: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
393:

Line 394: WHEN fnd_api.g_exc_unexpected_error then

390: /*x_msg_count := l_msg_count;
391: x_msg_data := l_msg_data;*/
392: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
393:
394: WHEN fnd_api.g_exc_unexpected_error then
395: --ROLLBACK TO delete_access_hours_pub;
396: x_return_status :=fnd_api.g_ret_sts_unexp_error;
397: /*x_msg_count := l_msg_count;
398: x_msg_data := l_msg_data;*/

Line 396: x_return_status :=fnd_api.g_ret_sts_unexp_error;

392: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
393:
394: WHEN fnd_api.g_exc_unexpected_error then
395: --ROLLBACK TO delete_access_hours_pub;
396: x_return_status :=fnd_api.g_ret_sts_unexp_error;
397: /*x_msg_count := l_msg_count;
398: x_msg_data := l_msg_data;*/
399: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
400:

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 delete_access_hours_pub;
403: x_return_status := fnd_api.g_ret_sts_unexp_error;
404: /*x_msg_count := l_msg_count;
405: x_msg_data := l_msg_data;*/
406: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
407:

Line 425: x_return_status := fnd_api.g_ret_sts_success;

421: l_msg_count NUMBER;
422: l_msg_data varchar2(1000);
423: l_api_name_full constant varchar2(50) := 'CSF_ACCESS_HOURS_PVT.DELETE_ACCESS_HOURS';
424: BEGIN
425: x_return_status := fnd_api.g_ret_sts_success;
426: DELETE FROM CSF_ACCESS_HOURS_TL
427: WHERE ACCESS_HOUR_ID=p_ACCESS_HOUR_ID;
428: If (SQL%NOTFOUND) then
429: -- RAISE NO_DATA_FOUND;

Line 430: Raise fnd_api.g_exc_unexpected_error;

426: DELETE FROM CSF_ACCESS_HOURS_TL
427: WHERE ACCESS_HOUR_ID=p_ACCESS_HOUR_ID;
428: If (SQL%NOTFOUND) then
429: -- RAISE NO_DATA_FOUND;
430: Raise fnd_api.g_exc_unexpected_error;
431: end if;
432:
433: DELETE FROM CSF_ACCESS_HOURS_B
434: WHERE ACCESS_HOUR_ID=p_ACCESS_HOUR_ID;

Line 437: Raise fnd_api.g_exc_unexpected_error;

433: DELETE FROM CSF_ACCESS_HOURS_B
434: WHERE ACCESS_HOUR_ID=p_ACCESS_HOUR_ID;
435: If (SQL%NOTFOUND) then
436: -- RAISE NO_DATA_FOUND;
437: Raise fnd_api.g_exc_unexpected_error;
438: end if;
439:
440: -- Standard check of p_commit
441: IF fnd_api.to_boolean(p_commit) THEN

Line 441: IF fnd_api.to_boolean(p_commit) THEN

437: Raise fnd_api.g_exc_unexpected_error;
438: end if;
439:
440: -- Standard check of p_commit
441: IF fnd_api.to_boolean(p_commit) THEN
442: commit work;
443: END IF;
444:
445: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

Line 449: WHEN fnd_api.g_exc_error then

445: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
446:
447: EXCEPTION
448:
449: WHEN fnd_api.g_exc_error then
450: --ROLLBACK TO delete_access_hours_pub;
451: x_return_status := fnd_api.g_ret_sts_error;
452: /*x_msg_count := l_msg_count;
453: x_msg_data := l_msg_data;*/

Line 451: x_return_status := fnd_api.g_ret_sts_error;

447: EXCEPTION
448:
449: WHEN fnd_api.g_exc_error then
450: --ROLLBACK TO delete_access_hours_pub;
451: x_return_status := fnd_api.g_ret_sts_error;
452: /*x_msg_count := l_msg_count;
453: x_msg_data := l_msg_data;*/
454: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
455:

Line 456: WHEN fnd_api.g_exc_unexpected_error then

452: /*x_msg_count := l_msg_count;
453: x_msg_data := l_msg_data;*/
454: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
455:
456: WHEN fnd_api.g_exc_unexpected_error then
457: --ROLLBACK TO delete_access_hours_pub;
458: x_return_status :=fnd_api.g_ret_sts_unexp_error;
459: /*x_msg_count := l_msg_count;
460: x_msg_data := l_msg_data;*/

Line 458: x_return_status :=fnd_api.g_ret_sts_unexp_error;

454: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
455:
456: WHEN fnd_api.g_exc_unexpected_error then
457: --ROLLBACK TO delete_access_hours_pub;
458: x_return_status :=fnd_api.g_ret_sts_unexp_error;
459: /*x_msg_count := l_msg_count;
460: x_msg_data := l_msg_data;*/
461: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
462:

Line 465: x_return_status := fnd_api.g_ret_sts_unexp_error;

461: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
462:
463: WHEN OTHERS then
464: --ROLLBACK TO delete_access_hours_pub;
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
466: /*x_msg_count := l_msg_count;
467: x_msg_data := l_msg_data;*/
468: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
469:

Line 500: x_return_status := fnd_api.g_ret_sts_success;

496:
497:
498: BEGIN
499:
500: x_return_status := fnd_api.g_ret_sts_success;
501: open c_ovn;
502: fetch c_ovn into l_rec;
503: if c_ovn%notfound
504: then

Line 523: WHEN fnd_api.g_exc_error then

519: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
520:
521: EXCEPTION
522:
523: WHEN fnd_api.g_exc_error then
524: --ROLLBACK TO delete_access_hours_pub;
525: x_return_status :=fnd_api.g_ret_sts_error;
526: /*x_msg_count := l_msg_count;
527: x_msg_data := l_msg_data;*/

Line 525: x_return_status :=fnd_api.g_ret_sts_error;

521: EXCEPTION
522:
523: WHEN fnd_api.g_exc_error then
524: --ROLLBACK TO delete_access_hours_pub;
525: x_return_status :=fnd_api.g_ret_sts_error;
526: /*x_msg_count := l_msg_count;
527: x_msg_data := l_msg_data;*/
528: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
529:

Line 530: WHEN fnd_api.g_exc_unexpected_error then

526: /*x_msg_count := l_msg_count;
527: x_msg_data := l_msg_data;*/
528: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
529:
530: WHEN fnd_api.g_exc_unexpected_error then
531: --ROLLBACK TO delete_access_hours_pub;
532: x_return_status :=fnd_api.g_ret_sts_unexp_error;
533: /*x_msg_count := l_msg_count;
534: x_msg_data := l_msg_data;*/

Line 532: x_return_status :=fnd_api.g_ret_sts_unexp_error;

528: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
529:
530: WHEN fnd_api.g_exc_unexpected_error then
531: --ROLLBACK TO delete_access_hours_pub;
532: x_return_status :=fnd_api.g_ret_sts_unexp_error;
533: /*x_msg_count := l_msg_count;
534: x_msg_data := l_msg_data;*/
535: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
536:

Line 539: x_return_status := fnd_api.g_ret_sts_unexp_error;

535: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
536:
537: WHEN OTHERS then
538: --ROLLBACK TO delete_access_hours_pub;
539: x_return_status := fnd_api.g_ret_sts_unexp_error;
540: /*x_msg_count := l_msg_count;
541: x_msg_data := l_msg_data;*/
542: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
543: END lock_Access_Hours;