[Home] [Help]
111:
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:
362: -- Insertion of a new record is allowed only when the status of the task is IN PLANNING or ON HOLD or PLANNED
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:
400: OR p_DESCRIPTION is null
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;
454:
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:
479: OR (p_SUNDAY_FIRST_START is not null and p_SUNDAY_FIRST_END is null)
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:
495: and p_FRIDAY_FIRST_START is null
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:
518: OR (p_SUNDAY_FIRST_START is null and p_SUNDAY_FIRST_END is not null)
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
540: OR( (p_SUNDAY_FIRST_START is null and p_SUNDAY_FIRST_END is null)
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:
563: OR (p_SUNDAY_FIRST_START >p_SUNDAY_FIRST_END )
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:
578: OR (p_SATURDAY_FIRST_END > p_SATURDAY_SECOND_START)
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:
586:
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:
602: and p_FRIDAY_FIRST_START is null
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:
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
713: fnd_msg_pub.add;
714: raise fnd_api.g_exc_error;
715: end if;
716:
719: if c_exists%notfound then
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:
1012: end if;
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;
1069:
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:
1103: OR p_SATURDAY_SECOND_END 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;
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
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;
1579: end if;
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:
1590: open c_existing_values(p_TASK_ID);
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;