[Home] [Help]
107: raise fnd_Api.g_exc_unexpected_error;
108: end if;
109:
110: IF fnd_api.to_boolean( nvl(p_init_msg_list,fnd_api.g_false)) then
111: fnd_msg_pub.initialize;
112: end if;
113:
114:
115:
114:
115:
116: If p_ACCESS_HOUR_ID is NULL then
117: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required
118: fnd_msg_pub.add;
119: raise fnd_api.g_exc_error;
120: end if;
121:
122: CSF_ACCESS_HOURS_PVT.LOCK_ACCESS_HOURS(
137: If l_return_status = fnd_api.g_ret_sts_unexp_error then
138: raise fnd_Api.g_exc_unexpected_error;
139: end if;
140:
141: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
142:
143: EXCEPTION
144:
145: WHEN fnd_api.g_exc_error then
146: ROLLBACK TO lock_access_hours_pub;
147: x_return_status :=fnd_api.g_ret_sts_error;
148: /*x_msg_count := l_msg_count;
149: x_msg_data := l_msg_data;*/
150: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
151:
152: WHEN fnd_api.g_exc_unexpected_error then
153: ROLLBACK TO lock_access_hours_pub;
154: x_return_status := fnd_api.g_ret_sts_unexp_error;
153: ROLLBACK TO lock_access_hours_pub;
154: x_return_status := fnd_api.g_ret_sts_unexp_error;
155: /*x_msg_count := l_msg_count;
156: x_msg_data := l_msg_data;*/
157: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
158:
159: WHEN OTHERS then
160: ROLLBACK TO lock_access_hours_pub;
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
160: ROLLBACK TO lock_access_hours_pub;
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162: /*x_msg_count := l_msg_count;
163: x_msg_data := l_msg_data;*/
164: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
165:
166:
167:
168:
359: -- For PLANNED status task only description field can be entered when inserting a record for a task
360:
361: IF l_task_status ='W' or l_task_status='X' or (l_task_status='A' and p_calling_routine='DELETE_ROW') then
362: fnd_message.set_name('CSF','CSF_ACCESS_INVALID_STATUS');-- require message
363: fnd_msg_pub.add;
364: raise fnd_api.g_exc_error;
365: end if;
366:
367: IF l_task_status ='A' and p_CALLING_ROUTINE='INSERT_ROW' then
397: OR nvl(p_ACCESS_HOUR_REQD,'N')='Y'
398: OR nvl(p_AFTER_HOURS_FLAG,'N') ='Y'
399: then
400: fnd_message.set_name('CSF','CSF_ACCESS_INVALID_INSERT');---require message
401: fnd_msg_pub.add;
402: raise fnd_api.g_exc_error;
403: end if;
404: end if;
405:
451: -- both flags should not be set to Y together
452:
453: if nvl(p_ACCESS_HOUR_REQD,'N') ='Y' and nvl(p_AFTER_HOURS_FLAG,'N') ='Y' then
454: fnd_message.set_name('CSF','CSF_ACCESS_BOTH_FLAGS_INV');-- require message
455: fnd_msg_pub.add;
456: raise fnd_api.g_exc_error;
457: end if;
458:
459:
476: OR (p_SUNDAY_SECOND_START is not null and p_SUNDAY_SECOND_END is null)
477:
478: then
479: fnd_message.set_name('CSF','CSF_INV_START_END_NOT_NULL');
480: fnd_msg_pub.add;
481: raise fnd_api.g_exc_error;
482: end if;
483:
484: -- when access_hours flag is set atleast one slot should be entered
492: and p_SATURDAY_FIRST_START is null
493: and p_SUNDAY_FIRST_START is null
494: then
495: fnd_message.set_name('CSF','CSF_ENTER_ATLEAST_ONE_SLOT');-- require message here
496: fnd_msg_pub.add;
497: raise fnd_api.g_exc_error;
498: end if;
499:
500: -- start to be enetered first and then the end
515: OR (p_SUNDAY_SECOND_START is null and p_SUNDAY_SECOND_END is not null)
516:
517: then
518: fnd_message.set_name('CSF','CSF_ACCESS_START_FIRST');-- need new messgae for this
519: fnd_msg_pub.add;
520: raise fnd_api.g_exc_error;
521: end if;
522: -- second slots for a day to be entered only after end times are entered
523:
537: and (p_SUNDAY_SECOND_START is not null and p_SUNDAY_SECOND_END is not null))
538:
539: then
540: fnd_message.set_name('CSF','CSF_SECOND_SLOT_FIRST_SLOT');-- need new messgae for this
541: fnd_msg_pub.add;
542: raise fnd_api.g_exc_error;
543: end if;
544:
545: --- start time should be less than the end time for each slot
560: OR (p_SUNDAY_SECOND_START >p_SUNDAY_SECOND_END)
561:
562: then
563: fnd_message.set_name('CSF','CSF_INV_START_END');
564: fnd_msg_pub.add;
565: raise fnd_api.g_exc_error;
566: end if;
567:
568: -- start time of the second slot should be greater than the end time of the first slot for a day
575: OR (p_SUNDAY_FIRST_END >p_SUNDAY_SECOND_START)
576:
577: then
578: fnd_message.set_name('CSF','CSF_INV_SLOTS');
579: fnd_msg_pub.add;
580: raise fnd_api.g_exc_error;
581: end if;
582:
583: /*-- both flags should not be set to Y together
583: /*-- both flags should not be set to Y together
584:
585: if nvl(p_ACCESS_HOUR_REQD,'N') ='Y' and nvl(p_AFTER_HOURS_FLAG,'N') ='Y' then
586: fnd_message.set_name('CSF','CSF_INV_SLOTS');-- require message
587: fnd_msg_pub.add;
588: raise fnd_api.g_exc_error;
589: end if;
590:
591: -- when access_hours flag is set atleast one slot should be entered
599: and p_SATURDAY_FIRST_START is null
600: and p_SUNDAY_FIRST_START is null
601: then
602: fnd_message.set_name('CSF','CSF_INV_START_END_NOT_NULL');-- require message here
603: fnd_msg_pub.add;
604: raise fnd_api.g_exc_error;
605: end if;*/
606:
607: end if;
608:
609: EXCEPTION
610: WHEN fnd_api.g_exc_error then
611: x_return_status := fnd_api.g_ret_sts_error;
612: --fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
613:
614: WHEN fnd_api.g_exc_unexpected_error then
615: x_return_status :=fnd_api.g_ret_sts_unexp_error;
616: --fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
612: --fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
613:
614: WHEN fnd_api.g_exc_unexpected_error then
615: x_return_status :=fnd_api.g_ret_sts_unexp_error;
616: --fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
617:
618: WHEN others then
619: x_return_status :=fnd_api.g_ret_sts_unexp_error;
620: --fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
616: --fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
617:
618: WHEN others then
619: x_return_status :=fnd_api.g_ret_sts_unexp_error;
620: --fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
621:
622:
623: END CHECK_PARAMETERS;
624:
700: raise fnd_Api.g_exc_unexpected_error;
701: end if;
702:
703: IF fnd_api.to_boolean( nvl(p_init_msg_list,fnd_Api.g_false)) then
704: fnd_msg_pub.initialize;
705: end if;
706:
707: If p_task_id is NULL then
708: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required
705: end if;
706:
707: If p_task_id is NULL then
708: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required
709: fnd_msg_pub.add;
710: raise fnd_api.g_exc_error;
711: end if;
712:
713: open c_exists(p_task_id);
716: close c_exists;
717: else
718: close c_exists;
719: fnd_message.set_name('CSF','CSF_ACCESS_ROW_EXISTS');
720: fnd_msg_pub.add;
721: raise fnd_api.g_exc_error;
722: end if;
723:
724: check_parameters
823: If l_return_status = fnd_api.g_ret_sts_unexp_error then
824: raise fnd_Api.g_exc_unexpected_error;
825: end if;
826:
827: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
828:
829: EXCEPTION
830: WHEN fnd_api.g_exc_error then
831: ROLLBACK TO create_access_hours_pub;
831: ROLLBACK TO create_access_hours_pub;
832: x_return_status := fnd_api.g_ret_sts_error;
833: /*x_msg_count := l_msg_count;
834: x_msg_data := l_msg_data;*/
835: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
836:
837: WHEN fnd_api.g_exc_unexpected_error then
838: ROLLBACK TO create_access_hours_pub;
839: x_return_status :=fnd_api.g_ret_sts_unexp_error ;
838: ROLLBACK TO create_access_hours_pub;
839: x_return_status :=fnd_api.g_ret_sts_unexp_error ;
840: /*x_msg_count := l_msg_count;
841: x_msg_data := l_msg_data;*/
842: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
843:
844: WHEN OTHERS then
845: ROLLBACK TO create_task_assignment_pub;
846: x_return_status := fnd_api.g_ret_sts_unexp_error;
845: ROLLBACK TO create_task_assignment_pub;
846: x_return_status := fnd_api.g_ret_sts_unexp_error;
847: /*x_msg_count := l_msg_count;
848: x_msg_data := l_msg_data;*/
849: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
850:
851:
852: End CREATE_ACCESS_HOURS;
853:
1003: raise fnd_Api.g_exc_unexpected_error;
1004: end if;
1005:
1006: IF fnd_api.to_boolean(nvl(p_init_msg_list,fnd_Api.g_false)) then
1007: fnd_msg_pub.initialize;
1008: end if;
1009:
1010:
1011: If p_task_id is NULL or p_ACCESS_HOUR_ID is NULL then
1009:
1010:
1011: If p_task_id is NULL or p_ACCESS_HOUR_ID is NULL then
1012: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required
1013: fnd_msg_pub.add;
1014: raise fnd_api.g_exc_error;
1015: end if;
1016:
1017: open c_exists(p_task_id);
1018: fetch c_exists into l_temp;
1019: if c_exists%notfound then
1020: close c_exists;
1021: fnd_message.set_name('CSF','CSF_ACCESS_NO_ROW_EXISTS');
1022: fnd_msg_pub.add;
1023: raise fnd_api.g_exc_error;
1024: else
1025: close c_exists;
1026: end if;
1066: IF ((l_ACCESS_HOUR_REQD ='N' and p_ACCESS_HOUR_REQD ='Y')
1067: OR (l_AFTER_HOURS_FLAG ='N' and p_AFTER_HOURS_FLAG='Y'))
1068: then
1069: fnd_message.set_name ('CSF','CSF_INV_FLAG_CHANGE');--message required
1070: fnd_msg_pub.add;
1071: raise fnd_api.g_exc_error;
1072: end if;
1073:
1074: IF p_MONDAY_FIRST_START is not null
1100: OR p_SUNDAY_SECOND_START is not null
1101: OR p_SUNDAY_SECOND_END is not null then
1102:
1103: fnd_message.set_name ('CSF','CSF_INV_DATE_CHANGE');--message required
1104: fnd_msg_pub.add;
1105: raise fnd_api.g_exc_error;
1106: end if;
1107: end if;
1108:
1360: If l_return_status = fnd_api.g_ret_sts_unexp_error then
1361: raise fnd_api.g_exc_unexpected_error;
1362: end if;
1363:
1364: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1365:
1366:
1367: EXCEPTION
1368: WHEN fnd_api.g_exc_error then
1369: ROLLBACK TO update_access_hours_pub;
1370: x_return_status := fnd_api.g_ret_sts_error;
1371: /*x_msg_count := l_msg_count;
1372: x_msg_data := l_msg_data;*/
1373: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1374:
1375: WHEN fnd_api.g_exc_unexpected_error then
1376: ROLLBACK TO update_access_hours_pub;
1377: x_return_status := fnd_api.g_ret_sts_unexp_error;
1376: ROLLBACK TO update_access_hours_pub;
1377: x_return_status := fnd_api.g_ret_sts_unexp_error;
1378: /*x_msg_count := l_msg_count;
1379: x_msg_data := l_msg_data;*/
1380: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1381:
1382: WHEN OTHERS then
1383: ROLLBACK TO update_access_hours_pub;
1384: x_return_status := fnd_api.g_ret_sts_unexp_error;
1383: ROLLBACK TO update_access_hours_pub;
1384: x_return_status := fnd_api.g_ret_sts_unexp_error;
1385: /*x_msg_count := l_msg_count;
1386: x_msg_data := l_msg_data;*/
1387: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1388:
1389:
1390: END UPDATE_ACCESS_HOURS;
1391:
1426: raise fnd_Api.g_exc_unexpected_error;
1427: end if;
1428:
1429: IF fnd_api.to_boolean( nvl(p_init_msg_list,fnd_Api.g_false)) then
1430: fnd_msg_pub.initialize;
1431: end if;
1432:
1433: If p_task_id is NULL or p_ACCESS_HOUR_ID is NULL then
1434: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required
1431: end if;
1432:
1433: If p_task_id is NULL or p_ACCESS_HOUR_ID is NULL then
1434: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required
1435: fnd_msg_pub.add;
1436: raise fnd_api.g_exc_error;
1437: end if;
1438:
1439: open c_exists(p_task_id);
1440: fetch c_exists into l_temp;
1441: if c_exists%notfound then
1442: close c_exists;
1443: fnd_message.set_name('CSF','CSF_ACCESS_NO_ROW_EXISTS');
1444: fnd_msg_pub.add;
1445: raise fnd_api.g_exc_error;
1446: else
1447: close c_exists;
1448: end if;
1494: If l_return_status = fnd_api.g_ret_sts_unexp_error then
1495: raise fnd_Api.g_exc_unexpected_error;
1496: end if;
1497:
1498: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1499:
1500: EXCEPTION
1501: WHEN fnd_api.g_exc_error then
1502: ROLLBACK TO delete_access_hours_pub;
1502: ROLLBACK TO delete_access_hours_pub;
1503: x_return_status := fnd_api.g_ret_sts_error;
1504: /*x_msg_count := l_msg_count;
1505: x_msg_data := l_msg_data;*/
1506: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1507:
1508: WHEN fnd_api.g_exc_unexpected_error then
1509: ROLLBACK TO delete_access_hours_pub;
1510: x_return_status := fnd_api.g_ret_sts_unexp_error;
1509: ROLLBACK TO delete_access_hours_pub;
1510: x_return_status := fnd_api.g_ret_sts_unexp_error;
1511: /*x_msg_count := l_msg_count;
1512: x_msg_data := l_msg_data;*/
1513: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1514:
1515: WHEN OTHERS then
1516: ROLLBACK TO delete_access_hours_pub;
1517: x_return_status := fnd_api.g_ret_sts_unexp_error;
1516: ROLLBACK TO delete_access_hours_pub;
1517: x_return_status := fnd_api.g_ret_sts_unexp_error;
1518: /*x_msg_count := l_msg_count;
1519: x_msg_data := l_msg_data;*/
1520: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1521:
1522: END DELETE_ACCESS_HOURS;
1523:
1524: PROCEDURE update_access_hours(
1570: then
1571: raise fnd_Api.g_exc_unexpected_error;
1572: end if;
1573: IF fnd_api.to_boolean(nvl(p_init_msg_list,fnd_api.g_false)) then
1574: fnd_msg_pub.initialize;
1575: end if;
1576:
1577:
1578: If p_task_id is NULL then
1576:
1577:
1578: If p_task_id is NULL then
1579: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required
1580: fnd_msg_pub.add;
1581: raise fnd_api.g_exc_error;
1582: end if;
1583:
1584:
1587: fetch c_existing_values into l_rec;
1588: if c_existing_values%notfound then
1589: close c_existing_values;
1590: fnd_message.set_name('CSF','CSF_ACCESS_NO_ROW_EXISTS');
1591: fnd_msg_pub.add;
1592: raise fnd_api.g_exc_error;
1593: end if;
1594: close c_existing_values;
1595:
1644: ROLLBACK TO update_access_hours_pub2;
1645: x_return_status := fnd_api.g_ret_sts_error;
1646: /*x_msg_count := l_msg_count;
1647: x_msg_data := l_msg_data;*/
1648: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1649:
1650: WHEN fnd_api.g_exc_unexpected_error then
1651: ROLLBACK TO update_access_hours_pub2;
1652: x_return_status := fnd_api.g_ret_sts_unexp_error;
1651: ROLLBACK TO update_access_hours_pub2;
1652: x_return_status := fnd_api.g_ret_sts_unexp_error;
1653: /*x_msg_count := l_msg_count;
1654: x_msg_data := l_msg_data;*/
1655: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1656:
1657: WHEN OTHERS then
1658: ROLLBACK TO update_access_hours_pub2;
1659: x_return_status := fnd_api.g_ret_sts_unexp_error;
1658: ROLLBACK TO update_access_hours_pub2;
1659: x_return_status := fnd_api.g_ret_sts_unexp_error;
1660: /*x_msg_count := l_msg_count;
1661: x_msg_data := l_msg_data;*/
1662: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1663:
1664:
1665: END UPDATE_ACCESS_HOURS;
1666: