334: BEGIN
335: IF p_sync_id IS NULL OR
336: p_sync_id < 1
337: THEN
338: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
339: fnd_msg_pub.add;
340:
341: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
342: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.IS_THIS_NEW_TASK');
337: THEN
338: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
339: fnd_msg_pub.add;
340:
341: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
342: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.IS_THIS_NEW_TASK');
343: fnd_msg_pub.add;
344:
345: raise_application_error (-20100,jta_sync_common.get_messages);
338: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
339: fnd_msg_pub.add;
340:
341: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
342: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.IS_THIS_NEW_TASK');
343: fnd_msg_pub.add;
344:
345: raise_application_error (-20100,jta_sync_common.get_messages);
346: END IF;
519: BEGIN
520: IF p_sync_id IS NULL
521: OR p_sync_id < 1
522: THEN
523: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
524: fnd_msg_pub.add;
525:
526: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
527: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
522: THEN
523: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
524: fnd_msg_pub.add;
525:
526: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
527: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
528: fnd_msg_pub.add;
529:
530: raise_application_error (-20100,jta_sync_common.get_messages);
523: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
524: fnd_msg_pub.add;
525:
526: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
527: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
528: fnd_msg_pub.add;
529:
530: raise_application_error (-20100,jta_sync_common.get_messages);
531:
537: IF c_task_sync%NOTFOUND
538: THEN
539: CLOSE c_task_sync;
540:
541: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
542: fnd_msg_pub.add;
543:
544: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
545: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
540:
541: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
542: fnd_msg_pub.add;
543:
544: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
545: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
546: fnd_msg_pub.add;
547:
548: raise_application_error (-20100,jta_sync_common.get_messages);
541: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
542: fnd_msg_pub.add;
543:
544: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
545: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
546: fnd_msg_pub.add;
547:
548: raise_application_error (-20100,jta_sync_common.get_messages);
549: ELSIF l_task_id IS NULL
549: ELSIF l_task_id IS NULL
550: THEN
551: CLOSE c_task_sync;
552:
553: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
554: fnd_msg_pub.add;
555:
556: fnd_message.set_name('JTF', 'JTA_SYNC_NULL_TASKID');
557: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
552:
553: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
554: fnd_msg_pub.add;
555:
556: fnd_message.set_name('JTF', 'JTA_SYNC_NULL_TASKID');
557: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
558: fnd_msg_pub.add;
559:
560: raise_application_error (-20100,jta_sync_common.get_messages);
553: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
554: fnd_msg_pub.add;
555:
556: fnd_message.set_name('JTF', 'JTA_SYNC_NULL_TASKID');
557: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
558: fnd_msg_pub.add;
559:
560: raise_application_error (-20100,jta_sync_common.get_messages);
561: END IF;
581: IF c_task%NOTFOUND
582: THEN
583: CLOSE c_task;
584:
585: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
586: fnd_msg_pub.add;
587:
588: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
589: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
584:
585: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
586: fnd_msg_pub.add;
587:
588: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
589: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
590: fnd_msg_pub.add;
591:
592: raise_application_error (-20100,jta_sync_common.get_messages);
585: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
586: fnd_msg_pub.add;
587:
588: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
589: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
590: fnd_msg_pub.add;
591:
592: raise_application_error (-20100,jta_sync_common.get_messages);
593: END IF;
613: IF c_task_timezone%NOTFOUND
614: THEN
615: CLOSE c_task_timezone;
616:
617: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
618: fnd_msg_pub.add;
619:
620: fnd_message.set_name('JTF', 'JTA_SYNC_TIMEZONEID_NOTFOUND');
621: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_TIMEZONE_ID');
616:
617: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
618: fnd_msg_pub.add;
619:
620: fnd_message.set_name('JTF', 'JTA_SYNC_TIMEZONEID_NOTFOUND');
621: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_TIMEZONE_ID');
622: fnd_msg_pub.add;
623:
624: raise_application_error (-20100,jta_sync_common.get_messages);
617: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
618: fnd_msg_pub.add;
619:
620: fnd_message.set_name('JTF', 'JTA_SYNC_TIMEZONEID_NOTFOUND');
621: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_TIMEZONE_ID');
622: fnd_msg_pub.add;
623:
624: raise_application_error (-20100,jta_sync_common.get_messages);
625:
653: IF c_tasks_ovn%NOTFOUND
654: THEN
655: CLOSE c_tasks_ovn;
656:
657: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
658: fnd_msg_pub.add;
659:
660: fnd_message.set_name('JTF', 'JTA_SYNC_TASK_OVN_NOTFOUND');
661: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OVN');
656:
657: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
658: fnd_msg_pub.add;
659:
660: fnd_message.set_name('JTF', 'JTA_SYNC_TASK_OVN_NOTFOUND');
661: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OVN');
662: fnd_msg_pub.add;
663:
664: raise_application_error (-20100,jta_sync_common.get_messages);
657: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
658: fnd_msg_pub.add;
659:
660: fnd_message.set_name('JTF', 'JTA_SYNC_TASK_OVN_NOTFOUND');
661: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OVN');
662: fnd_msg_pub.add;
663:
664: raise_application_error (-20100,jta_sync_common.get_messages);
665: END IF;
685: IF c_assignment_ovn%NOTFOUND
686: THEN
687: CLOSE c_assignment_ovn;
688:
689: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
690: fnd_msg_pub.add;
691:
692: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMT_OVN_NOTFOUND');
693: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OVN');
688:
689: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
690: fnd_msg_pub.add;
691:
692: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMT_OVN_NOTFOUND');
693: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OVN');
694: fnd_msg_pub.add;
695:
696: raise_application_error (-20100,jta_sync_common.get_messages);
689: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
690: fnd_msg_pub.add;
691:
692: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMT_OVN_NOTFOUND');
693: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OVN');
694: fnd_msg_pub.add;
695:
696: raise_application_error (-20100,jta_sync_common.get_messages);
697: END IF;
717: IF c_resource%NOTFOUND
718: THEN
719: CLOSE c_resource;
720:
721: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
722: fnd_msg_pub.add;
723:
724: fnd_message.set_name('JTF', 'JTA_SYNC_RESOURCE_NOTFOUND');
725: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_RESOURCE_DETAILS');
720:
721: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
722: fnd_msg_pub.add;
723:
724: fnd_message.set_name('JTF', 'JTA_SYNC_RESOURCE_NOTFOUND');
725: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_RESOURCE_DETAILS');
726: fnd_msg_pub.add;
727:
728: raise_application_error (-20100,jta_sync_common.get_messages);
721: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
722: fnd_msg_pub.add;
723:
724: fnd_message.set_name('JTF', 'JTA_SYNC_RESOURCE_NOTFOUND');
725: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_RESOURCE_DETAILS');
726: fnd_msg_pub.add;
727:
728: raise_application_error (-20100,jta_sync_common.get_messages);
729: END IF;
1123: IF c_recur_tasks%NOTFOUND
1124: THEN
1125: CLOSE c_recur_tasks;
1126:
1127: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1128: fnd_msg_pub.add;
1129:
1130: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_RECUR_RULE_ID');
1131: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_MAX_ENDDATE');
1126:
1127: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1128: fnd_msg_pub.add;
1129:
1130: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_RECUR_RULE_ID');
1131: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_MAX_ENDDATE');
1132: fnd_msg_pub.add;
1133:
1134: raise_application_error (-20100,jta_sync_common.get_messages);
1127: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1128: fnd_msg_pub.add;
1129:
1130: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_RECUR_RULE_ID');
1131: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_MAX_ENDDATE');
1132: fnd_msg_pub.add;
1133:
1134: raise_application_error (-20100,jta_sync_common.get_messages);
1135: END IF;
1137: CLOSE c_recur_tasks;
1138:
1139: IF l_date IS NULL
1140: THEN
1141: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1142: fnd_msg_pub.add;
1143:
1144: fnd_message.set_name('JTF', 'JTA_SYNC_NULL_CALENDAR_ENDDATE');
1145: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_MAX_ENDDATE');
1140: THEN
1141: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1142: fnd_msg_pub.add;
1143:
1144: fnd_message.set_name('JTF', 'JTA_SYNC_NULL_CALENDAR_ENDDATE');
1145: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_MAX_ENDDATE');
1146: fnd_msg_pub.add;
1147:
1148: raise_application_error (-20100,jta_sync_common.get_messages);
1141: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1142: fnd_msg_pub.add;
1143:
1144: fnd_message.set_name('JTF', 'JTA_SYNC_NULL_CALENDAR_ENDDATE');
1145: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_MAX_ENDDATE');
1146: fnd_msg_pub.add;
1147:
1148: raise_application_error (-20100,jta_sync_common.get_messages);
1149: END IF;
1519: IF c_assignment%NOTFOUND
1520: THEN
1521: CLOSE c_assignment;
1522:
1523: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1524: fnd_msg_pub.add;
1525:
1526: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1527: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_ID');
1522:
1523: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1524: fnd_msg_pub.add;
1525:
1526: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1527: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_ID');
1528: fnd_msg_pub.add;
1529:
1530: raise_application_error (-20100,jta_sync_common.get_messages);
1523: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1524: fnd_msg_pub.add;
1525:
1526: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1527: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_ID');
1528: fnd_msg_pub.add;
1529:
1530: raise_application_error (-20100,jta_sync_common.get_messages);
1531: END IF;
1555: IF c_assignment%NOTFOUND
1556: THEN
1557: CLOSE c_assignment;
1558:
1559: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1560: fnd_msg_pub.add;
1561:
1562: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGN_STSID_NOTFOUND');
1563: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_STATUS_ID');
1558:
1559: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1560: fnd_msg_pub.add;
1561:
1562: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGN_STSID_NOTFOUND');
1563: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_STATUS_ID');
1564: fnd_msg_pub.add;
1565:
1566: raise_application_error (-20100,jta_sync_common.get_messages);
1559: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1560: fnd_msg_pub.add;
1561:
1562: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGN_STSID_NOTFOUND');
1563: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_STATUS_ID');
1564: fnd_msg_pub.add;
1565:
1566: raise_application_error (-20100,jta_sync_common.get_messages);
1567: END IF;
1591: IF c_task%NOTFOUND
1592: THEN
1593: CLOSE c_task;
1594:
1595: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1596: fnd_msg_pub.add;
1597:
1598: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
1599: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OWNER_INFO');
1594:
1595: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1596: fnd_msg_pub.add;
1597:
1598: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
1599: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OWNER_INFO');
1600: fnd_msg_pub.add;
1601:
1602: raise_application_error (-20100,jta_sync_common.get_messages);
1595: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1596: fnd_msg_pub.add;
1597:
1598: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
1599: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OWNER_INFO');
1600: fnd_msg_pub.add;
1601:
1602: raise_application_error (-20100,jta_sync_common.get_messages);
1603: END IF;
1655: IF c_assignment%NOTFOUND
1656: THEN
1657: CLOSE c_assignment;
1658:
1659: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1660: fnd_msg_pub.add;
1661:
1662: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1663: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_INFO');
1658:
1659: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1660: fnd_msg_pub.add;
1661:
1662: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1663: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_INFO');
1664: fnd_msg_pub.add;
1665:
1666: raise_application_error (-20100,jta_sync_common.get_messages);
1659: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1660: fnd_msg_pub.add;
1661:
1662: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1663: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_INFO');
1664: fnd_msg_pub.add;
1665:
1666: raise_application_error (-20100,jta_sync_common.get_messages);
1667: END IF;
1709: IF c_access%NOTFOUND
1710: THEN
1711: CLOSE c_access;
1712:
1713: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1714: fnd_msg_pub.add;
1715:
1716: fnd_message.set_name('JTF', 'JTA_SYNC_ACCESS_PRIV_NOTFOUND');
1717: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ACCESS');
1712:
1713: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1714: fnd_msg_pub.add;
1715:
1716: fnd_message.set_name('JTF', 'JTA_SYNC_ACCESS_PRIV_NOTFOUND');
1717: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ACCESS');
1718: fnd_msg_pub.add;
1719:
1720: raise_application_error (-20100,jta_sync_common.get_messages);
1713: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1714: fnd_msg_pub.add;
1715:
1716: fnd_message.set_name('JTF', 'JTA_SYNC_ACCESS_PRIV_NOTFOUND');
1717: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ACCESS');
1718: fnd_msg_pub.add;
1719:
1720: raise_application_error (-20100,jta_sync_common.get_messages);
1721: END IF;
1741: IF c_source%NOTFOUND
1742: THEN
1743: CLOSE c_source;
1744:
1745: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1746: fnd_msg_pub.add;
1747:
1748: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
1749: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_SOURCE_OBJECT_TYPE');
1744:
1745: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1746: fnd_msg_pub.add;
1747:
1748: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
1749: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_SOURCE_OBJECT_TYPE');
1750: fnd_msg_pub.add;
1751:
1752: raise_application_error (-20100,jta_sync_common.get_messages);
1745: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1746: fnd_msg_pub.add;
1747:
1748: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
1749: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_SOURCE_OBJECT_TYPE');
1750: fnd_msg_pub.add;
1751:
1752: raise_application_error (-20100,jta_sync_common.get_messages);
1753: END IF;
1821: IF c_resource%NOTFOUND
1822: THEN
1823: CLOSE c_resource;
1824:
1825: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1826: fnd_msg_pub.add;
1827:
1828: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1829: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_SYNC_TYPE');
1824:
1825: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1826: fnd_msg_pub.add;
1827:
1828: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1829: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_SYNC_TYPE');
1830: fnd_msg_pub.add;
1831:
1832: raise_application_error (-20100,jta_sync_common.get_messages);
1825: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1826: fnd_msg_pub.add;
1827:
1828: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1829: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_SYNC_TYPE');
1830: fnd_msg_pub.add;
1831:
1832: raise_application_error (-20100,jta_sync_common.get_messages);
1833: END IF;
3495: ---------------------------------
3496: -- Fix Bug# 2395004
3497: IF NVL(p_syncid,-1) < 1
3498: THEN
3499: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
3500: fnd_msg_pub.add;
3501:
3502: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
3503: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
3498: THEN
3499: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
3500: fnd_msg_pub.add;
3501:
3502: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
3503: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
3504: fnd_msg_pub.add;
3505:
3506: raise_application_error (-20100,jta_sync_common.get_messages);
3499: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
3500: fnd_msg_pub.add;
3501:
3502: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
3503: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
3504: fnd_msg_pub.add;
3505:
3506: raise_application_error (-20100,jta_sync_common.get_messages);
3507: END IF;