[Home] [Help]
105: raise fnd_Api.g_exc_unexpected_error;
106: end if;
107:
108: IF fnd_api.to_boolean( nvl(p_init_msg_list,fnd_api.g_false)) then
109: fnd_msg_pub.initialize;
110: end if;
111:
112:
113:
112:
113:
114: If p_ACCESS_HOUR_ID is NULL then
115: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required
116: fnd_msg_pub.add;
117: raise fnd_api.g_exc_error;
118: end if;
119:
120: CSF_ACCESS_HOURS_PVT.LOCK_ACCESS_HOURS(
135: If l_return_status = fnd_api.g_ret_sts_unexp_error then
136: raise fnd_Api.g_exc_unexpected_error;
137: end if;
138:
139: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
140:
141: EXCEPTION
142:
143: WHEN fnd_api.g_exc_error then
144: ROLLBACK TO lock_access_hours_pub;
145: x_return_status :=fnd_api.g_ret_sts_error;
146: /*x_msg_count := l_msg_count;
147: x_msg_data := l_msg_data;*/
148: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
149:
150: WHEN fnd_api.g_exc_unexpected_error then
151: ROLLBACK TO lock_access_hours_pub;
152: x_return_status := fnd_api.g_ret_sts_unexp_error;
151: ROLLBACK TO lock_access_hours_pub;
152: x_return_status := fnd_api.g_ret_sts_unexp_error;
153: /*x_msg_count := l_msg_count;
154: x_msg_data := l_msg_data;*/
155: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
156:
157: WHEN OTHERS then
158: ROLLBACK TO lock_access_hours_pub;
159: x_return_status := fnd_api.g_ret_sts_unexp_error;
158: ROLLBACK TO lock_access_hours_pub;
159: x_return_status := fnd_api.g_ret_sts_unexp_error;
160: /*x_msg_count := l_msg_count;
161: x_msg_data := l_msg_data;*/
162: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
163:
164:
165:
166:
363: -- For PLANNED status task only description field can be entered when inserting a record for a task
364:
365: IF l_task_status ='W' or l_task_status='X' or (l_task_status='A' and p_calling_routine='DELETE_ROW') then
366: fnd_message.set_name('CSF','CSF_ACCESS_INVALID_STATUS');-- require message
367: fnd_msg_pub.add;
368: raise fnd_api.g_exc_error;
369: end if;
370:
371: IF l_task_status ='A' and p_CALLING_ROUTINE='INSERT_ROW' then
401: OR nvl(p_ACCESS_HOUR_REQD,'N')='Y'
402: OR nvl(p_AFTER_HOURS_FLAG,'N') ='Y'
403: then
404: fnd_message.set_name('CSF','CSF_ACCESS_INVALID_INSERT');---require message
405: fnd_msg_pub.add;
406: raise fnd_api.g_exc_error;
407: end if;
408: end if;
409:
455: -- both flags should not be set to Y together
456:
457: if nvl(p_ACCESS_HOUR_REQD,'N') ='Y' and nvl(p_AFTER_HOURS_FLAG,'N') ='Y' then
458: fnd_message.set_name('CSF','CSF_ACCESS_BOTH_FLAGS_INV');-- require message
459: fnd_msg_pub.add;
460: raise fnd_api.g_exc_error;
461: end if;
462:
463:
480: OR (p_SUNDAY_SECOND_START is not null and p_SUNDAY_SECOND_END is null)
481:
482: then
483: fnd_message.set_name('CSF','CSF_INV_START_END_NOT_NULL');
484: fnd_msg_pub.add;
485: raise fnd_api.g_exc_error;
486: end if;
487:
488: -- when access_hours flag is set atleast one slot should be entered
496: and p_SATURDAY_FIRST_START is null
497: and p_SUNDAY_FIRST_START is null
498: then
499: fnd_message.set_name('CSF','CSF_ENTER_ATLEAST_ONE_SLOT');-- require message here
500: fnd_msg_pub.add;
501: raise fnd_api.g_exc_error;
502: end if;
503:
504: -- start to be enetered first and then the end
519: OR (p_SUNDAY_SECOND_START is null and p_SUNDAY_SECOND_END is not null)
520:
521: then
522: fnd_message.set_name('CSF','CSF_ACCESS_START_FIRST');-- need new messgae for this
523: fnd_msg_pub.add;
524: raise fnd_api.g_exc_error;
525: end if;
526: -- second slots for a day to be entered only after end times are entered
527:
541: and (p_SUNDAY_SECOND_START is not null and p_SUNDAY_SECOND_END is not null))
542:
543: then
544: fnd_message.set_name('CSF','CSF_SECOND_SLOT_FIRST_SLOT');-- need new messgae for this
545: fnd_msg_pub.add;
546: raise fnd_api.g_exc_error;
547: end if;
548:
549: --- start time should be less than the end time for each slot
564: OR (p_SUNDAY_SECOND_START >p_SUNDAY_SECOND_END)
565:
566: then
567: fnd_message.set_name('CSF','CSF_INV_START_END');
568: fnd_msg_pub.add;
569: raise fnd_api.g_exc_error;
570: end if;
571:
572: -- start time of the second slot should be greater than the end time of the first slot for a day
579: OR (p_SUNDAY_FIRST_END >p_SUNDAY_SECOND_START)
580:
581: then
582: fnd_message.set_name('CSF','CSF_INV_SLOTS');
583: fnd_msg_pub.add;
584: raise fnd_api.g_exc_error;
585: end if;
586:
587: /*-- both flags should not be set to Y together
587: /*-- both flags should not be set to Y together
588:
589: if nvl(p_ACCESS_HOUR_REQD,'N') ='Y' and nvl(p_AFTER_HOURS_FLAG,'N') ='Y' then
590: fnd_message.set_name('CSF','CSF_INV_SLOTS');-- require message
591: fnd_msg_pub.add;
592: raise fnd_api.g_exc_error;
593: end if;
594:
595: -- when access_hours flag is set atleast one slot should be entered
603: and p_SATURDAY_FIRST_START is null
604: and p_SUNDAY_FIRST_START is null
605: then
606: fnd_message.set_name('CSF','CSF_INV_START_END_NOT_NULL');-- require message here
607: fnd_msg_pub.add;
608: raise fnd_api.g_exc_error;
609: end if;*/
610:
611: end if;
612:
613: EXCEPTION
614: WHEN fnd_api.g_exc_error then
615: x_return_status := fnd_api.g_ret_sts_error;
616: --fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
617:
618: WHEN fnd_api.g_exc_unexpected_error 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 fnd_api.g_exc_unexpected_error 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: WHEN others then
623: x_return_status :=fnd_api.g_ret_sts_unexp_error;
624: --fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
620: --fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
621:
622: WHEN others then
623: x_return_status :=fnd_api.g_ret_sts_unexp_error;
624: --fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
625:
626:
627: END CHECK_PARAMETERS;
628:
704: raise fnd_Api.g_exc_unexpected_error;
705: end if;
706:
707: IF fnd_api.to_boolean( nvl(p_init_msg_list,fnd_Api.g_false)) then
708: fnd_msg_pub.initialize;
709: end if;
710:
711: If p_task_id is NULL then
712: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required
709: end if;
710:
711: If p_task_id is NULL then
712: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required
713: fnd_msg_pub.add;
714: raise fnd_api.g_exc_error;
715: end if;
716:
717: open c_exists(p_task_id);
720: close c_exists;
721: else
722: close c_exists;
723: fnd_message.set_name('CSF','CSF_ACCESS_ROW_EXISTS');
724: fnd_msg_pub.add;
725: raise fnd_api.g_exc_error;
726: end if;
727:
728: check_parameters
827: If l_return_status = fnd_api.g_ret_sts_unexp_error then
828: raise fnd_Api.g_exc_unexpected_error;
829: end if;
830:
831: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
832:
833: EXCEPTION
834: WHEN fnd_api.g_exc_error then
835: ROLLBACK TO create_access_hours_pub;
835: ROLLBACK TO create_access_hours_pub;
836: x_return_status := fnd_api.g_ret_sts_error;
837: /*x_msg_count := l_msg_count;
838: x_msg_data := l_msg_data;*/
839: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
840:
841: WHEN fnd_api.g_exc_unexpected_error then
842: ROLLBACK TO create_access_hours_pub;
843: x_return_status :=fnd_api.g_ret_sts_unexp_error ;
842: ROLLBACK TO create_access_hours_pub;
843: x_return_status :=fnd_api.g_ret_sts_unexp_error ;
844: /*x_msg_count := l_msg_count;
845: x_msg_data := l_msg_data;*/
846: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
847:
848: WHEN OTHERS then
849: ROLLBACK TO create_task_assignment_pub;
850: x_return_status := fnd_api.g_ret_sts_unexp_error;
849: ROLLBACK TO create_task_assignment_pub;
850: x_return_status := fnd_api.g_ret_sts_unexp_error;
851: /*x_msg_count := l_msg_count;
852: x_msg_data := l_msg_data;*/
853: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
854:
855:
856: End CREATE_ACCESS_HOURS;
857:
1007: raise fnd_Api.g_exc_unexpected_error;
1008: end if;
1009:
1010: IF fnd_api.to_boolean(nvl(p_init_msg_list,fnd_Api.g_false)) then
1011: fnd_msg_pub.initialize;
1012: end if;
1013:
1014:
1015: If p_task_id is NULL or p_ACCESS_HOUR_ID is NULL then
1013:
1014:
1015: If p_task_id is NULL or p_ACCESS_HOUR_ID is NULL then
1016: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required
1017: fnd_msg_pub.add;
1018: raise fnd_api.g_exc_error;
1019: end if;
1020:
1021: open c_exists(p_task_id);
1022: fetch c_exists into l_temp;
1023: if c_exists%notfound then
1024: close c_exists;
1025: fnd_message.set_name('CSF','CSF_ACCESS_NO_ROW_EXISTS');
1026: fnd_msg_pub.add;
1027: raise fnd_api.g_exc_error;
1028: else
1029: close c_exists;
1030: end if;
1070: IF ((l_ACCESS_HOUR_REQD ='N' and p_ACCESS_HOUR_REQD ='Y')
1071: OR (l_AFTER_HOURS_FLAG ='N' and p_AFTER_HOURS_FLAG='Y'))
1072: then
1073: fnd_message.set_name ('CSF','CSF_INV_FLAG_CHANGE');--message required
1074: fnd_msg_pub.add;
1075: raise fnd_api.g_exc_error;
1076: end if;
1077:
1078: IF p_MONDAY_FIRST_START is not null
1104: OR p_SUNDAY_SECOND_START is not null
1105: OR p_SUNDAY_SECOND_END is not null then
1106:
1107: fnd_message.set_name ('CSF','CSF_INV_DATE_CHANGE');--message required
1108: fnd_msg_pub.add;
1109: raise fnd_api.g_exc_error;
1110: end if;
1111: end if;
1112:
1364: If l_return_status = fnd_api.g_ret_sts_unexp_error then
1365: raise fnd_api.g_exc_unexpected_error;
1366: end if;
1367:
1368: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1369:
1370:
1371: EXCEPTION
1372: WHEN fnd_api.g_exc_error then
1373: ROLLBACK TO update_access_hours_pub;
1374: x_return_status := fnd_api.g_ret_sts_error;
1375: /*x_msg_count := l_msg_count;
1376: x_msg_data := l_msg_data;*/
1377: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1378:
1379: WHEN fnd_api.g_exc_unexpected_error then
1380: ROLLBACK TO update_access_hours_pub;
1381: x_return_status := fnd_api.g_ret_sts_unexp_error;
1380: ROLLBACK TO update_access_hours_pub;
1381: x_return_status := fnd_api.g_ret_sts_unexp_error;
1382: /*x_msg_count := l_msg_count;
1383: x_msg_data := l_msg_data;*/
1384: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1385:
1386: WHEN OTHERS then
1387: ROLLBACK TO update_access_hours_pub;
1388: x_return_status := fnd_api.g_ret_sts_unexp_error;
1387: ROLLBACK TO update_access_hours_pub;
1388: x_return_status := fnd_api.g_ret_sts_unexp_error;
1389: /*x_msg_count := l_msg_count;
1390: x_msg_data := l_msg_data;*/
1391: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1392:
1393:
1394: END UPDATE_ACCESS_HOURS;
1395:
1430: raise fnd_Api.g_exc_unexpected_error;
1431: end if;
1432:
1433: IF fnd_api.to_boolean( nvl(p_init_msg_list,fnd_Api.g_false)) then
1434: fnd_msg_pub.initialize;
1435: end if;
1436:
1437: If p_task_id is NULL or p_ACCESS_HOUR_ID is NULL then
1438: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required
1435: end if;
1436:
1437: If p_task_id is NULL or p_ACCESS_HOUR_ID is NULL then
1438: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required
1439: fnd_msg_pub.add;
1440: raise fnd_api.g_exc_error;
1441: end if;
1442:
1443: open c_exists(p_task_id);
1444: fetch c_exists into l_temp;
1445: if c_exists%notfound then
1446: close c_exists;
1447: fnd_message.set_name('CSF','CSF_ACCESS_NO_ROW_EXISTS');
1448: fnd_msg_pub.add;
1449: raise fnd_api.g_exc_error;
1450: else
1451: close c_exists;
1452: end if;
1498: If l_return_status = fnd_api.g_ret_sts_unexp_error then
1499: raise fnd_Api.g_exc_unexpected_error;
1500: end if;
1501:
1502: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1503:
1504: EXCEPTION
1505: WHEN fnd_api.g_exc_error then
1506: ROLLBACK TO delete_access_hours_pub;
1506: ROLLBACK TO delete_access_hours_pub;
1507: x_return_status := fnd_api.g_ret_sts_error;
1508: /*x_msg_count := l_msg_count;
1509: x_msg_data := l_msg_data;*/
1510: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1511:
1512: WHEN fnd_api.g_exc_unexpected_error then
1513: ROLLBACK TO delete_access_hours_pub;
1514: x_return_status := fnd_api.g_ret_sts_unexp_error;
1513: ROLLBACK TO delete_access_hours_pub;
1514: x_return_status := fnd_api.g_ret_sts_unexp_error;
1515: /*x_msg_count := l_msg_count;
1516: x_msg_data := l_msg_data;*/
1517: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1518:
1519: WHEN OTHERS then
1520: ROLLBACK TO delete_access_hours_pub;
1521: x_return_status := fnd_api.g_ret_sts_unexp_error;
1520: ROLLBACK TO delete_access_hours_pub;
1521: x_return_status := fnd_api.g_ret_sts_unexp_error;
1522: /*x_msg_count := l_msg_count;
1523: x_msg_data := l_msg_data;*/
1524: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1525:
1526: END DELETE_ACCESS_HOURS;
1527:
1528: PROCEDURE update_access_hours(
1574: then
1575: raise fnd_Api.g_exc_unexpected_error;
1576: end if;
1577: IF fnd_api.to_boolean(nvl(p_init_msg_list,fnd_api.g_false)) then
1578: fnd_msg_pub.initialize;
1579: end if;
1580:
1581:
1582: If p_task_id is NULL then
1580:
1581:
1582: If p_task_id is NULL then
1583: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required
1584: fnd_msg_pub.add;
1585: raise fnd_api.g_exc_error;
1586: end if;
1587:
1588:
1591: fetch c_existing_values into l_rec;
1592: if c_existing_values%notfound then
1593: close c_existing_values;
1594: fnd_message.set_name('CSF','CSF_ACCESS_NO_ROW_EXISTS');
1595: fnd_msg_pub.add;
1596: raise fnd_api.g_exc_error;
1597: end if;
1598: close c_existing_values;
1599:
1648: ROLLBACK TO update_access_hours_pub2;
1649: x_return_status := fnd_api.g_ret_sts_error;
1650: /*x_msg_count := l_msg_count;
1651: x_msg_data := l_msg_data;*/
1652: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1653:
1654: WHEN fnd_api.g_exc_unexpected_error then
1655: ROLLBACK TO update_access_hours_pub2;
1656: x_return_status := fnd_api.g_ret_sts_unexp_error;
1655: ROLLBACK TO update_access_hours_pub2;
1656: x_return_status := fnd_api.g_ret_sts_unexp_error;
1657: /*x_msg_count := l_msg_count;
1658: x_msg_data := l_msg_data;*/
1659: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1660:
1661: WHEN OTHERS then
1662: ROLLBACK TO update_access_hours_pub2;
1663: x_return_status := fnd_api.g_ret_sts_unexp_error;
1662: ROLLBACK TO update_access_hours_pub2;
1663: x_return_status := fnd_api.g_ret_sts_unexp_error;
1664: /*x_msg_count := l_msg_count;
1665: x_msg_data := l_msg_data;*/
1666: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1667:
1668:
1669: END UPDATE_ACCESS_HOURS;
1670: