DBA Data[Home] [Help]

APPS.CAC_SYNC_TASK_COMMON dependencies on CAC_SYNC_COMMON

Line 362: IF NOT cac_sync_common.is_success (l_return_status)

358: x_msg_data =>l_msg_data
359: ) ;
360:
361:
362: IF NOT cac_sync_common.is_success (l_return_status)
363: THEN-- Failed to update a task
364:
365: cac_sync_common.put_message_to_excl_record (
366: p_exclusion_rec=>p_exclusion,

Line 365: cac_sync_common.put_message_to_excl_record (

361:
362: IF NOT cac_sync_common.is_success (l_return_status)
363: THEN-- Failed to update a task
364:
365: cac_sync_common.put_message_to_excl_record (
366: p_exclusion_rec=>p_exclusion,
367: p_status => 2,
368: p_user_message => 'JTA_SYNC_UPDATE_TASK_FAIL'
369: );

Line 450: -- raise_application_error (-20100,cac_sync_common.get_messages);

446: -- fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
447: -- fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.IS_THIS_NEW_TASK');
448: -- fnd_msg_pub.add;
449:
450: -- raise_application_error (-20100,cac_sync_common.get_messages);
451: RETURN TRUE;
452: END IF;
453:
454: OPEN c_synctask;

Line 636: raise_application_error (-20100,cac_sync_common.get_messages);

632: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
633: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_TASK_ID');
634: fnd_msg_pub.add;
635:
636: raise_application_error (-20100,cac_sync_common.get_messages);
637:
638: END IF;
639:
640: OPEN c_task_sync;

Line 654: raise_application_error (-20100,cac_sync_common.get_messages);

650: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
651: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_TASK_ID');
652: fnd_msg_pub.add;
653:
654: raise_application_error (-20100,cac_sync_common.get_messages);
655: ELSIF l_task_id IS NULL
656: THEN
657: CLOSE c_task_sync;
658:

Line 666: raise_application_error (-20100,cac_sync_common.get_messages);

662: fnd_message.set_name('JTF', 'JTA_SYNC_NULL_TASKID');
663: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_TASK_ID');
664: fnd_msg_pub.add;
665:
666: raise_application_error (-20100,cac_sync_common.get_messages);
667: END IF;
668:
669: CLOSE c_task_sync;
670: RETURN l_task_id;

Line 698: raise_application_error (-20100,cac_sync_common.get_messages);

694: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
695: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_TASK_ID');
696: fnd_msg_pub.add;
697:
698: raise_application_error (-20100,cac_sync_common.get_messages);
699: END IF;
700:
701: CLOSE c_task;
702: RETURN l_task_id;

Line 730: raise_application_error (-20100,cac_sync_common.get_messages);

726: fnd_message.set_name('JTF', 'JTA_SYNC_TIMEZONEID_NOTFOUND');
727: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_TASK_TIMEZONE_ID');
728: fnd_msg_pub.add;
729:
730: raise_application_error (-20100,cac_sync_common.get_messages);
731:
732: END IF;
733:
734: CLOSE c_task_timezone;

Line 770: raise_application_error (-20100,cac_sync_common.get_messages);

766: fnd_message.set_name('JTF', 'cac_sync_task_OVN_NOTFOUND');
767: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_OVN');
768: fnd_msg_pub.add;
769:
770: raise_application_error (-20100,cac_sync_common.get_messages);
771: END IF;
772:
773: CLOSE c_tasks_ovn;
774: RETURN l_object_version_number;

Line 802: raise_application_error (-20100,cac_sync_common.get_messages);

798: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMT_OVN_NOTFOUND');
799: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_OVN');
800: fnd_msg_pub.add;
801:
802: raise_application_error (-20100,cac_sync_common.get_messages);
803: END IF;
804:
805: CLOSE c_assignment_ovn;
806: RETURN l_object_version_number;

Line 834: raise_application_error (-20100,cac_sync_common.get_messages);

830: fnd_message.set_name('JTF', 'JTA_SYNC_RESOURCE_NOTFOUND');
831: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_RESOURCE_DETAILS');
832: fnd_msg_pub.add;
833:
834: raise_application_error (-20100,cac_sync_common.get_messages);
835: END IF;
836:
837: CLOSE c_resource;
838:

Line 1256: raise_application_error (-20100,cac_sync_common.get_messages);

1252: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_RECUR_RULE_ID');
1253: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_MAX_ENDDATE');
1254: fnd_msg_pub.add;
1255:
1256: raise_application_error (-20100,cac_sync_common.get_messages);
1257: END IF;
1258:
1259: CLOSE c_recur_tasks;
1260:

Line 1270: raise_application_error (-20100,cac_sync_common.get_messages);

1266: fnd_message.set_name('JTF', 'JTA_SYNC_NULL_CALENDAR_ENDDATE');
1267: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_MAX_ENDDATE');
1268: fnd_msg_pub.add;
1269:
1270: raise_application_error (-20100,cac_sync_common.get_messages);
1271: END IF;
1272:
1273: RETURN l_date;
1274: END get_max_enddate;

Line 1855: raise_application_error (-20100,cac_sync_common.get_messages);

1851: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1852: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_ASSIGNMENT_ID');
1853: fnd_msg_pub.add;
1854:
1855: raise_application_error (-20100,cac_sync_common.get_messages);
1856: END IF;
1857:
1858: CLOSE c_assignment;
1859: RETURN l_task_assignment_id;

Line 1891: raise_application_error (-20100,cac_sync_common.get_messages);

1887: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGN_STSID_NOTFOUND');
1888: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_ASSIGNMENT_STATUS_ID');
1889: fnd_msg_pub.add;
1890:
1891: raise_application_error (-20100,cac_sync_common.get_messages);
1892: END IF;
1893:
1894: CLOSE c_assignment;
1895: RETURN l_assignment_status_id;

Line 1927: raise_application_error (-20100,cac_sync_common.get_messages);

1923: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
1924: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_OWNER_INFO');
1925: fnd_msg_pub.add;
1926:
1927: raise_application_error (-20100,cac_sync_common.get_messages);
1928: END IF;
1929:
1930: CLOSE c_task;
1931: x_task_name := rec_task.task_name;

Line 1991: raise_application_error (-20100,cac_sync_common.get_messages);

1987: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1988: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_ASSIGNMENT_INFO');
1989: fnd_msg_pub.add;
1990:
1991: raise_application_error (-20100,cac_sync_common.get_messages);
1992: END IF;
1993:
1994: CLOSE c_assignment;
1995:

Line 2045: raise_application_error (-20100,cac_sync_common.get_messages);

2041: fnd_message.set_name('JTF', 'JTA_SYNC_ACCESS_PRIV_NOTFOUND');
2042: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_ACCESS');
2043: fnd_msg_pub.add;
2044:
2045: raise_application_error (-20100,cac_sync_common.get_messages);
2046: END IF;
2047:
2048: CLOSE c_access;
2049: RETURN l_menu_name;

Line 2077: raise_application_error (-20100,cac_sync_common.get_messages);

2073: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
2074: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_SOURCE_OBJECT_TYPE');
2075: fnd_msg_pub.add;
2076:
2077: raise_application_error (-20100,cac_sync_common.get_messages);
2078: END IF;
2079:
2080: CLOSE c_source;
2081: RETURN l_source_object_type_code;

Line 2157: raise_application_error (-20100,cac_sync_common.get_messages);

2153: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
2154: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_SYNC_TYPE');
2155: fnd_msg_pub.add;
2156:
2157: raise_application_error (-20100,cac_sync_common.get_messages);
2158: END IF;
2159: CLOSE c_resource;
2160:
2161: END get_sync_info;

Line 3503: if (cac_sync_common.is_success (l_return_status)=false) then

3499:
3500:
3501: --checking if the update status is false and if yes, write to message stack.
3502:
3503: if (cac_sync_common.is_success (l_return_status)=false) then
3504:
3505: cac_sync_common.put_messages_to_result (
3506: p_task_rec,
3507: p_status => 2,

Line 3505: cac_sync_common.put_messages_to_result (

3501: --checking if the update status is false and if yes, write to message stack.
3502:
3503: if (cac_sync_common.is_success (l_return_status)=false) then
3504:
3505: cac_sync_common.put_messages_to_result (
3506: p_task_rec,
3507: p_status => 2,
3508: p_user_message => 'JTA_SYNC_UPDATE_TASK_FAIL'
3509: );

Line 3510: END IF; -- of (cac_sync_common.is_success (l_return_status))

3506: p_task_rec,
3507: p_status => 2,
3508: p_user_message => 'JTA_SYNC_UPDATE_TASK_FAIL'
3509: );
3510: END IF; -- of (cac_sync_common.is_success (l_return_status))
3511:
3512:
3513: ELSE -- for (doesBookingExists%FOUND)
3514:

Line 3565: IF cac_sync_common.is_success (l_return_status)

3561: END IF;
3562:
3563: END IF; -- for p_task_rec.objectcode = G_APPOINTMENT
3564:
3565: IF cac_sync_common.is_success (l_return_status)
3566: THEN
3567: --------------------------------------------
3568: -- Check whether it has a repeating information
3569: -- If it has, then create a recurrence

Line 3659: IF cac_sync_common.is_success (l_return_status)

3655: );
3656:
3657:
3658:
3659: IF cac_sync_common.is_success (l_return_status)
3660: THEN
3661: -------------------------------------------------------
3662: -- Recurrences are successfully created.
3663: -------------------------------------------------------

Line 3685: cac_sync_common.put_messages_to_result (

3681: ELSE
3682: -------------------------------------------------------
3683: -- There are no exclusion tasks.
3684: -------------------------------------------------------
3685: cac_sync_common.put_messages_to_result (
3686: p_task_rec,
3687: p_status => g_sync_success,
3688: p_user_message => 'JTA_SYNC_SUCCESS'
3689: );

Line 3695: cac_sync_common.put_messages_to_result (

3691: ELSE
3692: -------------------------------------------------------
3693: -- Failed to create a task recurrence
3694: -------------------------------------------------------
3695: cac_sync_common.put_messages_to_result (
3696: p_task_rec,
3697: p_status => 2,
3698: p_user_message => 'JTA_RECURRENCE_CREATION_FAIL'
3699: );

Line 3706: cac_sync_common.put_messages_to_result (

3702: ELSE
3703: --------------------------------------------------------------------
3704: -- This is a Single Task and succeeded to create a single task
3705: --------------------------------------------------------------------
3706: cac_sync_common.put_messages_to_result (
3707: p_task_rec,
3708: p_status => g_sync_success,
3709: p_user_message => 'JTA_SYNC_SUCCESS'
3710: );

Line 3732: cac_sync_common.put_messages_to_result (

3728: ---------------------------------------------
3729: -- Failed to create a task
3730: ---------------------------------------------
3731:
3732: cac_sync_common.put_messages_to_result (
3733: p_task_rec,
3734: p_status => 2,
3735: p_user_message => 'cac_sync_task_CREATION_FAILED'
3736: );

Line 4280: IF NOT cac_sync_common.is_success (l_return_status)

4276: );
4277:
4278:
4279:
4280: IF NOT cac_sync_common.is_success (l_return_status)
4281: THEN-- Failed to update a task
4282:
4283: l_task_id := get_task_id (p_sync_id => p_task_rec.syncid);
4284: l_ovn := get_ovn (p_task_id => l_task_id);

Line 4288: cac_sync_common.put_messages_to_result (

4284: l_ovn := get_ovn (p_task_id => l_task_id);
4285: l_rec_rule_id := get_recurrence_rule_id (p_task_id => l_task_id);
4286:
4287:
4288: cac_sync_common.put_messages_to_result (
4289: p_task_rec,
4290: p_status => 2,
4291: p_user_message => 'JTA_SYNC_UPDATE_RECUR_FAIL'
4292: );

Line 4615: IF NOT cac_sync_common.is_success (l_return_status)

4611: END IF;
4612:
4613: if ((repeat_to_nonrepeat=false) and (nonrepeat_to_repeat=false) ) then
4614:
4615: IF NOT cac_sync_common.is_success (l_return_status)
4616: THEN-- Failed to update a task
4617:
4618: cac_sync_common.put_messages_to_result (
4619: p_task_rec,

Line 4618: cac_sync_common.put_messages_to_result (

4614:
4615: IF NOT cac_sync_common.is_success (l_return_status)
4616: THEN-- Failed to update a task
4617:
4618: cac_sync_common.put_messages_to_result (
4619: p_task_rec,
4620: p_status => 2,
4621: p_user_message => 'JTA_SYNC_UPDATE_TASK_FAIL'
4622: ); -- l_return_status

Line 4630: cac_sync_common.put_messages_to_result (

4626: ELSIF ((l_update_type = g_update_status)) --and (compare_task_rec(p_task_rec)=true))
4627: THEN
4628: if not (compare_task_rec(p_task_rec)) then
4629:
4630: cac_sync_common.put_messages_to_result (
4631: p_task_rec,
4632: p_status => 2,
4633: p_user_message => 'CAC_SYNC_APPT_PERMISSION_DENY',
4634: p_token_name=>'P_APPOINTMENT_SUBJECT',

Line 4666: IF NOT cac_sync_common.is_success (l_return_status)

4662: x_msg_count => l_msg_count,
4663: x_msg_data => l_msg_data
4664: );
4665:
4666: IF NOT cac_sync_common.is_success (l_return_status)
4667: THEN
4668: cac_sync_common.put_messages_to_result (
4669: p_task_rec,
4670: p_status => 2,

Line 4668: cac_sync_common.put_messages_to_result (

4664: );
4665:
4666: IF NOT cac_sync_common.is_success (l_return_status)
4667: THEN
4668: cac_sync_common.put_messages_to_result (
4669: p_task_rec,
4670: p_status => 2,
4671: p_user_message => 'JTA_SYNC_UPDATE_STS_FAIL'
4672: );

Line 4689: cac_sync_common.put_messages_to_result (

4685: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.create_new_data', ' When l_update_type=g_do_nothing for task '|| p_task_rec.subject);
4686: end if;*/
4687: if not (compare_task_rec(p_task_rec)) then -- code added for bug 5264362
4688:
4689: cac_sync_common.put_messages_to_result (
4690: p_task_rec,
4691: p_status => 2,
4692: p_user_message => 'CAC_SYNC_APPT_PERMISSION_DENY',
4693: p_token_name=>'P_APPOINTMENT_SUBJECT',

Line 4736: cac_sync_common.put_messages_to_result (

4732:
4733: -- Check the current status and update if it's succeeded
4734: IF nvl(p_task_rec.resultId,0) < 2
4735: THEN
4736: cac_sync_common.put_messages_to_result (
4737: p_task_rec,
4738: p_status => g_sync_success,
4739: p_user_message => 'JTA_SYNC_SUCCESS'
4740: );

Line 4787: IF cac_sync_common.is_success (l_return_status)

4783: x_msg_data => l_msg_data
4784: );
4785: END IF;
4786:
4787: IF cac_sync_common.is_success (l_return_status)
4788: THEN
4789: x_task_rec.syncanchor := convert_server_to_gmt (SYSDATE);
4790:
4791: cac_sync_common.put_messages_to_result (

Line 4791: cac_sync_common.put_messages_to_result (

4787: IF cac_sync_common.is_success (l_return_status)
4788: THEN
4789: x_task_rec.syncanchor := convert_server_to_gmt (SYSDATE);
4790:
4791: cac_sync_common.put_messages_to_result (
4792: x_task_rec,
4793: p_status => g_sync_success,
4794: p_user_message => 'JTA_SYNC_SUCCESS'
4795: );

Line 4797: cac_sync_common.put_messages_to_result (

4793: p_status => g_sync_success,
4794: p_user_message => 'JTA_SYNC_SUCCESS'
4795: );
4796: ELSE
4797: cac_sync_common.put_messages_to_result (
4798: x_task_rec,
4799: p_status => 2,
4800: p_user_message => 'JTA_SYNC_DELETE_EXCLUSION_FAIL'
4801: );

Line 4824: If cac_sync_common.is_success (l_return_status)

4820: delete_tasks(p_task_id => l_task_id,
4821: x_return_status => l_return_status);
4822:
4823:
4824: If cac_sync_common.is_success (l_return_status)
4825: THEN
4826: p_task_rec.syncanchor := convert_server_to_gmt (SYSDATE + 1 / (24 * 60 * 60));
4827:
4828: IF p_delete_map_flag

Line 4836: cac_sync_common.put_messages_to_result (

4832: p_task_sync_id => p_task_rec.syncid
4833: );
4834: END IF;
4835:
4836: cac_sync_common.put_messages_to_result (
4837: p_task_rec,
4838: p_status => g_sync_success,
4839: p_user_message => 'JTA_SYNC_SUCCESS'
4840: );

Line 4842: cac_sync_common.put_messages_to_result (

4838: p_status => g_sync_success,
4839: p_user_message => 'JTA_SYNC_SUCCESS'
4840: );
4841: ELSE
4842: cac_sync_common.put_messages_to_result (
4843: p_task_rec,
4844: p_status => 2,
4845: p_user_message => 'JTA_SYNC_DELETE_TASK_FAILED'
4846: );

Line 4909: IF cac_sync_common.is_success (l_return_status)

4905: --p_enable_workflow => 'N',
4906: --p_abort_workflow => 'N'
4907: );
4908:
4909: IF cac_sync_common.is_success (l_return_status)
4910: THEN
4911: p_task_rec.syncanchor := convert_server_to_gmt(SYSDATE);
4912:
4913: cac_sync_common.put_messages_to_result (

Line 4913: cac_sync_common.put_messages_to_result (

4909: IF cac_sync_common.is_success (l_return_status)
4910: THEN
4911: p_task_rec.syncanchor := convert_server_to_gmt(SYSDATE);
4912:
4913: cac_sync_common.put_messages_to_result (
4914: p_task_rec,
4915: p_status => g_sync_success,
4916: p_user_message => 'JTA_SYNC_SUCCESS'
4917: );

Line 4921: cac_sync_common.put_messages_to_result (

4917: );
4918:
4919: cac_sync_task_map_pkg.delete_row(p_task_sync_id => p_task_rec.syncid);
4920: ELSE
4921: cac_sync_common.put_messages_to_result (
4922: p_task_rec,
4923: p_status => 2,
4924: p_user_message => 'JTA_SYNC_UPDATE_STS_FAIL'
4925: );

Line 5177: raise_application_error (-20100,cac_sync_common.get_messages);

5173: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
5174: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_TASK_ID');
5175: fnd_msg_pub.add;
5176:
5177: raise_application_error (-20100,cac_sync_common.get_messages);
5178: END IF;
5179: ---------------------------------
5180:
5181: OPEN c_mapping (p_syncid);

Line 5308: IF cac_sync_common.is_success (l_return_status)

5304: delete_tasks(p_task_id => p_getBookings.task_id,
5305: x_return_status => l_return_status);
5306:
5307:
5308: IF cac_sync_common.is_success (l_return_status)
5309: THEN
5310: cac_sync_task_map_pkg.delete_row (
5311: p_task_sync_id => p_getBookings.task_sync_id);
5312:

Line 5491: IF cac_sync_common.is_success (x_return_status) then

5487: x_msg_count => l_msg_count,
5488: x_msg_data => l_msg_data
5489: );
5490:
5491: IF cac_sync_common.is_success (x_return_status) then
5492: ---deleting all exclusions....
5493: if (l_recurrence_rule_id is not null) then
5494:
5495: open get_tasks_ids(l_recurrence_rule_id);

Line 5523: end if;-- for IF cac_sync_common.is_success (x_return_status)

5519: end if;
5520:
5521: end if;
5522:
5523: end if;-- for IF cac_sync_common.is_success (x_return_status)
5524: --end deleting all exclusions.....
5525:
5526: END delete_tasks;
5527: