DBA Data[Home] [Help]

APPS.JTA_SYNC_TASK_COMMON dependencies on JTA_SYNC_TASK_COMMON

Line 1: PACKAGE BODY jta_sync_task_common AS

1: PACKAGE BODY jta_sync_task_common AS
2: /* $Header: jtavstcb.pls 120.2 2005/12/28 22:19:48 deeprao ship $ */
3: /*======================================================================+
4: | Copyright (c) 1995 Oracle Corporation Redwood Shores, California, USA|
5: | All rights reserved. |

Line 342: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.IS_THIS_NEW_TASK');

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;

Line 527: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');

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:

Line 545: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');

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

Line 557: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');

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;

Line 589: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');

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;

Line 621: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_TIMEZONE_ID');

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:

Line 661: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OVN');

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;

Line 693: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OVN');

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;

Line 725: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_RESOURCE_DETAILS');

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;

Line 1131: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_MAX_ENDDATE');

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;

Line 1145: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_MAX_ENDDATE');

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;

Line 1527: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_ID');

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;

Line 1563: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_STATUS_ID');

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;

Line 1599: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OWNER_INFO');

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;

Line 1663: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_INFO');

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;

Line 1717: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ACCESS');

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;

Line 1749: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_SOURCE_OBJECT_TYPE');

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;

Line 1829: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_SYNC_TYPE');

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;

Line 2877: l_changed_rule := jta_sync_task_common.changed_repeat_rule(p_task_rec => p_task_rec);

2873: p_repeating_task_id => l_task_id,
2874: p_task_rec => p_task_rec
2875: );
2876: ELSE -- p_exclusion_tbl.COUNT = 0 and check change rule
2877: l_changed_rule := jta_sync_task_common.changed_repeat_rule(p_task_rec => p_task_rec);
2878:
2879: IF l_changed_rule AND
2880: l_update_type = jta_sync_task_common.g_update_all
2881: THEN -- Changed Repeating Rule

Line 2880: l_update_type = jta_sync_task_common.g_update_all

2876: ELSE -- p_exclusion_tbl.COUNT = 0 and check change rule
2877: l_changed_rule := jta_sync_task_common.changed_repeat_rule(p_task_rec => p_task_rec);
2878:
2879: IF l_changed_rule AND
2880: l_update_type = jta_sync_task_common.g_update_all
2881: THEN -- Changed Repeating Rule
2882: IF p_task_rec.unit_of_measure = 'YER' THEN
2883: l_occurs_month := to_number(to_char(p_task_rec.start_date, 'MM'));
2884: END IF;

Line 3368: x_operation := jta_sync_task_common.g_delete;

3364: IF (p_task_status_id = 8)
3365: OR (p_task_status_id = 4)
3366: OR (p_task_status_id = 7)
3367: THEN
3368: x_operation := jta_sync_task_common.g_delete;
3369: END IF;
3370:
3371: IF (p_task_status_id = 12)
3372: OR (p_task_status_id = 15)

Line 3388: x_operation := jta_sync_task_common.g_delete;

3384: OR (NVL (l_rejected_flag, 'N') = 'Y')
3385: OR (NVL (l_completed_flag, 'N') = 'Y')
3386: OR (NVL (l_cancelled_flag, 'N') = 'Y')
3387: THEN
3388: x_operation := jta_sync_task_common.g_delete;
3389: END IF;
3390: CLOSE c_task_status;
3391: END IF;
3392:

Line 3406: x_operation := jta_sync_task_common.g_delete;

3402: OR (NVL (l_rejected_flag, 'N') = 'Y')
3403: OR (NVL (l_completed_flag, 'N') = 'Y')
3404: OR (NVL (l_cancelled_flag, 'N') = 'Y')
3405: THEN
3406: x_operation := jta_sync_task_common.g_delete;
3407: ELSIF (NVL (l_assigned_flag, 'N') = 'Y')
3408: THEN p_task_status_id := 12;
3409: ELSIF (NVL (l_working_flag, 'N') = 'Y')
3410: THEN p_task_status_id := 15;

Line 3420: x_operation := jta_sync_task_common.g_modify;

3416: THEN p_task_status_id := 16;
3417: ELSIF (NVL (l_approved_flag, 'N') = 'Y')
3418: THEN p_task_status_id := 15;
3419: END IF;
3420: x_operation := jta_sync_task_common.g_modify;
3421:
3422: CLOSE c_task_status;
3423:
3424: END IF;

Line 3503: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');

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;

Line 3521: END jta_sync_task_common;

3517:
3518: RETURN l_valid;
3519: END validate_syncid;
3520:
3521: END jta_sync_task_common;