DBA Data[Home] [Help]

APPS.CSF_ACCESS_HOURS_PUB dependencies on FND_MESSAGE

Line 117: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required

113:
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:

Line 362: fnd_message.set_name('CSF','CSF_ACCESS_INVALID_STATUS');-- require message

358: -- Insertion of a new record is allowed only when the status of the task is IN PLANNING or ON HOLD or PLANNED
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:

Line 400: fnd_message.set_name('CSF','CSF_ACCESS_INVALID_INSERT');---require message

396: OR p_DESCRIPTION is null
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;

Line 454: fnd_message.set_name('CSF','CSF_ACCESS_BOTH_FLAGS_INV');-- require message

450:
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:

Line 479: fnd_message.set_name('CSF','CSF_INV_START_END_NOT_NULL');

475: OR (p_SUNDAY_FIRST_START is not null and p_SUNDAY_FIRST_END is null)
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:

Line 495: fnd_message.set_name('CSF','CSF_ENTER_ATLEAST_ONE_SLOT');-- require message here

491: and p_FRIDAY_FIRST_START is null
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:

Line 518: fnd_message.set_name('CSF','CSF_ACCESS_START_FIRST');-- need new messgae for this

514: OR (p_SUNDAY_FIRST_START is null and p_SUNDAY_FIRST_END is not null)
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

Line 540: fnd_message.set_name('CSF','CSF_SECOND_SLOT_FIRST_SLOT');-- need new messgae for this

536: OR( (p_SUNDAY_FIRST_START is null and p_SUNDAY_FIRST_END is null)
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:

Line 563: fnd_message.set_name('CSF','CSF_INV_START_END');

559: OR (p_SUNDAY_FIRST_START >p_SUNDAY_FIRST_END )
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:

Line 578: fnd_message.set_name('CSF','CSF_INV_SLOTS');

574: OR (p_SATURDAY_FIRST_END > p_SATURDAY_SECOND_START)
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:

Line 586: fnd_message.set_name('CSF','CSF_INV_SLOTS');-- require message

582:
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:

Line 602: fnd_message.set_name('CSF','CSF_INV_START_END_NOT_NULL');-- require message here

598: and p_FRIDAY_FIRST_START is null
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:

Line 708: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required

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
709: fnd_msg_pub.add;
710: raise fnd_api.g_exc_error;
711: end if;
712:

Line 719: fnd_message.set_name('CSF','CSF_ACCESS_ROW_EXISTS');

715: if c_exists%notfound then
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:

Line 1012: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required

1008: end if;
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:

Line 1021: fnd_message.set_name('CSF','CSF_ACCESS_NO_ROW_EXISTS');

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;

Line 1069: fnd_message.set_name ('CSF','CSF_INV_FLAG_CHANGE');--message required

1065:
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:

Line 1103: fnd_message.set_name ('CSF','CSF_INV_DATE_CHANGE');--message required

1099: OR p_SATURDAY_SECOND_END 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;

Line 1434: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required

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
1435: fnd_msg_pub.add;
1436: raise fnd_api.g_exc_error;
1437: end if;
1438:

Line 1443: fnd_message.set_name('CSF','CSF_ACCESS_NO_ROW_EXISTS');

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;

Line 1579: fnd_message.set_name ('CSF','CSF_ACCESS_INVALID_PARAMETER');--message required

1575: end if;
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:

Line 1590: fnd_message.set_name('CSF','CSF_ACCESS_NO_ROW_EXISTS');

1586: open c_existing_values(p_TASK_ID);
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;