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.

[Home] [Help]

APPS.CSF_ACCESS_HOURS_PVT dependencies on FND_API

Line 90: x_return_status := fnd_api.g_ret_sts_success;

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

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

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

Line 237: IF fnd_api.to_boolean(p_commit) THEN

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

Line 244: WHEN fnd_api.g_exc_error then

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

Line 246: x_return_status :=fnd_api.g_ret_sts_error;

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

Line 251: When fnd_api.g_exc_unexpected_error then

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

Line 253: x_return_status:= fnd_api.g_ret_sts_unexp_error;

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

Line 258: x_return_status:= fnd_api.g_ret_sts_unexp_error;

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

Line 320: x_return_status := fnd_api.g_ret_sts_success;

316: l_msg_count NUMBER;
317: l_msg_data varchar2(1000);
318: BEGIN
319:
320: x_return_status := fnd_api.g_ret_sts_success;
321: px_object_version_number:=px_object_version_number+1;
322: Update CSF_ACCESS_HOURS_B
323: SET
324:

Line 365: Raise fnd_api.g_exc_unexpected_error;

361: and TASK_ID=p_TASK_ID;
362:
363: If (SQL%NOTFOUND) then
364: -- RAISE NO_DATA_FOUND;
365: Raise fnd_api.g_exc_unexpected_error;
366: end if;
367:
368:
369: update CSF_ACCESS_HOURS_TL set

Line 380: Raise fnd_api.g_exc_unexpected_error;

376: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
377:
378: If (SQL%NOTFOUND) then
379: -- RAISE NO_DATA_FOUND;
380: Raise fnd_api.g_exc_unexpected_error;
381: end if;
382:
383:
384: -- Standard check of p_commit

Line 385: IF fnd_api.to_boolean(p_commit) THEN

381: end if;
382:
383:
384: -- Standard check of p_commit
385: IF fnd_api.to_boolean(p_commit) THEN
386: commit work;
387: END IF;
388: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
389:

Line 392: WHEN fnd_api.g_exc_error then

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

Line 394: x_return_status :=fnd_api.g_ret_sts_error;

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

Line 399: WHEN fnd_api.g_exc_unexpected_error then

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

Line 401: x_return_status :=fnd_api.g_ret_sts_unexp_error;

397: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
398:
399: WHEN fnd_api.g_exc_unexpected_error then
400: --ROLLBACK TO delete_access_hours_pub;
401: x_return_status :=fnd_api.g_ret_sts_unexp_error;
402: /*x_msg_count := l_msg_count;
403: x_msg_data := l_msg_data;*/
404: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
405:

Line 408: x_return_status := fnd_api.g_ret_sts_unexp_error;

404: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
405:
406: WHEN OTHERS then
407: --ROLLBACK TO delete_access_hours_pub;
408: x_return_status := fnd_api.g_ret_sts_unexp_error;
409: /*x_msg_count := l_msg_count;
410: x_msg_data := l_msg_data;*/
411: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
412:

Line 430: x_return_status := fnd_api.g_ret_sts_success;

426: l_msg_count NUMBER;
427: l_msg_data varchar2(1000);
428: l_api_name_full constant varchar2(50) := 'CSF_ACCESS_HOURS_PVT.DELETE_ACCESS_HOURS';
429: BEGIN
430: x_return_status := fnd_api.g_ret_sts_success;
431: DELETE FROM CSF_ACCESS_HOURS_TL
432: WHERE ACCESS_HOUR_ID=p_ACCESS_HOUR_ID;
433: If (SQL%NOTFOUND) then
434: -- RAISE NO_DATA_FOUND;

Line 435: Raise fnd_api.g_exc_unexpected_error;

431: DELETE FROM CSF_ACCESS_HOURS_TL
432: WHERE ACCESS_HOUR_ID=p_ACCESS_HOUR_ID;
433: If (SQL%NOTFOUND) then
434: -- RAISE NO_DATA_FOUND;
435: Raise fnd_api.g_exc_unexpected_error;
436: end if;
437:
438: DELETE FROM CSF_ACCESS_HOURS_B
439: WHERE ACCESS_HOUR_ID=p_ACCESS_HOUR_ID;

Line 442: Raise fnd_api.g_exc_unexpected_error;

438: DELETE FROM CSF_ACCESS_HOURS_B
439: WHERE ACCESS_HOUR_ID=p_ACCESS_HOUR_ID;
440: If (SQL%NOTFOUND) then
441: -- RAISE NO_DATA_FOUND;
442: Raise fnd_api.g_exc_unexpected_error;
443: end if;
444:
445: -- Standard check of p_commit
446: IF fnd_api.to_boolean(p_commit) THEN

Line 446: IF fnd_api.to_boolean(p_commit) THEN

442: Raise fnd_api.g_exc_unexpected_error;
443: end if;
444:
445: -- Standard check of p_commit
446: IF fnd_api.to_boolean(p_commit) THEN
447: commit work;
448: END IF;
449:
450: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

Line 454: WHEN fnd_api.g_exc_error then

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

Line 456: x_return_status := fnd_api.g_ret_sts_error;

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

Line 461: WHEN fnd_api.g_exc_unexpected_error then

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

Line 463: x_return_status :=fnd_api.g_ret_sts_unexp_error;

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

Line 470: x_return_status := fnd_api.g_ret_sts_unexp_error;

466: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
467:
468: WHEN OTHERS then
469: --ROLLBACK TO delete_access_hours_pub;
470: x_return_status := fnd_api.g_ret_sts_unexp_error;
471: /*x_msg_count := l_msg_count;
472: x_msg_data := l_msg_data;*/
473: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
474:

Line 505: x_return_status := fnd_api.g_ret_sts_success;

501:
502:
503: BEGIN
504:
505: x_return_status := fnd_api.g_ret_sts_success;
506: open c_ovn;
507: fetch c_ovn into l_rec;
508: if c_ovn%notfound
509: then

Line 528: WHEN fnd_api.g_exc_error then

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

Line 530: x_return_status :=fnd_api.g_ret_sts_error;

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

Line 535: WHEN fnd_api.g_exc_unexpected_error then

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

Line 537: x_return_status :=fnd_api.g_ret_sts_unexp_error;

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

Line 544: x_return_status := fnd_api.g_ret_sts_unexp_error;

540: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
541:
542: WHEN OTHERS then
543: --ROLLBACK TO delete_access_hours_pub;
544: x_return_status := fnd_api.g_ret_sts_unexp_error;
545: /*x_msg_count := l_msg_count;
546: x_msg_data := l_msg_data;*/
547: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
548: END lock_Access_Hours;