eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CAC_SYNC_TASK_COMMON dependencies on CAC_SYNC_TASK_COMMON

Line 1: PACKAGE BODY CAC_SYNC_TASK_COMMON AS

1: PACKAGE BODY CAC_SYNC_TASK_COMMON AS
2: /* $Header: cacvstcb.pls 120.63.12010000.1 2008/07/24 18:03:24 appldev ship $ */
3: /*======================================================================+
4: | Copyright (c) 1995 Oracle Corporation Redwood Shores, California, USA|
5: | All rights reserved. |

Line 447: -- fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.IS_THIS_NEW_TASK');

443: --fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
444: -- fnd_msg_pub.add;
445:
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;

Line 633: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_TASK_ID');

629: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
630: fnd_msg_pub.add;
631:
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:

Line 651: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_TASK_ID');

647: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
648: fnd_msg_pub.add;
649:
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

Line 663: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_TASK_ID');

659: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
660: fnd_msg_pub.add;
661:
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;

Line 695: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_TASK_ID');

691: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
692: fnd_msg_pub.add;
693:
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;

Line 727: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_TASK_TIMEZONE_ID');

723: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
724: fnd_msg_pub.add;
725:
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:

Line 767: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_OVN');

763: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
764: fnd_msg_pub.add;
765:
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;

Line 799: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_OVN');

795: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
796: fnd_msg_pub.add;
797:
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;

Line 831: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_RESOURCE_DETAILS');

827: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
828: fnd_msg_pub.add;
829:
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;

Line 1253: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_MAX_ENDDATE');

1249: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1250: fnd_msg_pub.add;
1251:
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;

Line 1267: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_MAX_ENDDATE');

1263: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1264: fnd_msg_pub.add;
1265:
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;

Line 1852: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_ASSIGNMENT_ID');

1848: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1849: fnd_msg_pub.add;
1850:
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;

Line 1888: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_ASSIGNMENT_STATUS_ID');

1884: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1885: fnd_msg_pub.add;
1886:
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;

Line 1924: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_OWNER_INFO');

1920: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1921: fnd_msg_pub.add;
1922:
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;

Line 1988: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_ASSIGNMENT_INFO');

1984: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1985: fnd_msg_pub.add;
1986:
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;

Line 2042: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_ACCESS');

2038: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
2039: fnd_msg_pub.add;
2040:
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;

Line 2074: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_SOURCE_OBJECT_TYPE');

2070: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
2071: fnd_msg_pub.add;
2072:
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;

Line 2154: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_SYNC_TYPE');

2150: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
2151: fnd_msg_pub.add;
2152:
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;

Line 2312: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task_common.compare_task_rec', ' description didnt match ');

2308: IF (task_info.task_name<>p_task_rec.subject) THEN RETURN FALSE; END IF; --code changed for bug # 5396599
2309:
2310: if (NVL(task_info.description, 'A')<>NVL(p_task_rec.description, 'A')) then return false; end if; --code changed for bug # 5264362
2311: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2312: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task_common.compare_task_rec', ' description didnt match ');
2313:
2314: end if;
2315: if (task_info.private_flag<>p_task_rec.privateflag) then return false;end if;
2316: -- if (task_info.occurs_which<>p_task_rec.occurs_which) then return false;end if;

Line 2318: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task_common.compare_task_rec', ' private flag didnt match ');

2314: end if;
2315: if (task_info.private_flag<>p_task_rec.privateflag) then return false;end if;
2316: -- if (task_info.occurs_which<>p_task_rec.occurs_which) then return false;end if;
2317: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2318: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task_common.compare_task_rec', ' private flag didnt match ');
2319:
2320: end if;
2321: if (task_info.locations<>p_task_rec.locations) then return false;end if;
2322: if (NVL(task_info.locations,'AaBb')<>NVL(p_task_rec.locations,'AaBb')) then return false;end if;

Line 2325: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task_common.compare_task_rec', ' location didnt match ');

2321: if (task_info.locations<>p_task_rec.locations) then return false;end if;
2322: if (NVL(task_info.locations,'AaBb')<>NVL(p_task_rec.locations,'AaBb')) then return false;end if;
2323:
2324: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2325: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task_common.compare_task_rec', ' location didnt match ');
2326:
2327: end if;
2328:
2329: g_fb_type_changed := false;

Line 2341: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task_common.compare_task_rec', 'alarm didnt match ');

2337: if ((NVL(task_info.alarm_on,'N')<>NVL(p_task_rec.alarmFlag,'N')) or
2338: (NVL(task_info.alarm_start,0) <> NVL(l_alarm_start,0)))
2339: then
2340: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2341: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task_common.compare_task_rec', 'alarm didnt match ');
2342: end if;
2343: return false;
2344: end if;
2345:

Line 2385: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task_common.compare_task_rec', ' start date active didnt match ');

2381: x_saturday => l_saturday);
2382:
2383: if (TO_CHAR(l_start_date, 'DD-MON-YYYY')<>TO_CHAR(p_task_rec.start_date, 'DD-MON-YYYY')) then return false;end if;
2384: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2385: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task_common.compare_task_rec', ' start date active didnt match ');
2386:
2387: end if;
2388: if (TO_CHAR(l_end_date, 'DD-MON-YYYY')<>TO_CHAR(p_task_rec.end_date, 'DD-MON-YYYY')) then return false;end if;
2389: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2390: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task_common.compare_task_rec', ' end date active didnt match ');

2386:
2387: end if;
2388: if (TO_CHAR(l_end_date, 'DD-MON-YYYY')<>TO_CHAR(p_task_rec.end_date, 'DD-MON-YYYY')) then return false;end if;
2389: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2390: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task_common.compare_task_rec', ' end date active didnt match ');
2391:
2392: end if;
2393: /*if (l_sunday<>p_task_rec.sunday) then return false;end if;
2394: if (l_monday<>p_task_rec.monday) then return false;end if;

Line 3849: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.create_new_data', 'point 1 p_task_rec.syncid '||p_task_rec.syncid);

3845: open get_task_info('ASSIGNEE',l_task_id);
3846: fetch get_task_info into task_info;
3847:
3848: /* if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3849: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.create_new_data', 'point 1 p_task_rec.syncid '||p_task_rec.syncid);
3850: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.create_new_data', 'point 1 l_task_id '|| l_task_id);
3851: end if;*/
3852:
3853: if ( get_task_info%FOUND) then

Line 3850: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.create_new_data', 'point 1 l_task_id '|| l_task_id);

3846: fetch get_task_info into task_info;
3847:
3848: /* if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3849: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.create_new_data', 'point 1 p_task_rec.syncid '||p_task_rec.syncid);
3850: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.create_new_data', 'point 1 l_task_id '|| l_task_id);
3851: end if;*/
3852:
3853: if ( get_task_info%FOUND) then
3854:

Line 3982: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.create_new_data', 'point 1 p_task_rec.subject '||p_task_rec.subject);

3978:
3979: p_task_rec.subject := task_info.task_name;
3980:
3981: /* if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3982: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.create_new_data', 'point 1 p_task_rec.subject '||p_task_rec.subject);
3983: end if;*/
3984: end if;
3985:
3986: if (get_task_info%ISOPEN) then

Line 4164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task_common.create_new_data', ' Converting repeating into non-repeating ' );

4160: repeat_to_nonrepeat:=true;
4161:
4162: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4163:
4164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task_common.create_new_data', ' Converting repeating into non-repeating ' );
4165:
4166: end if;
4167:
4168: elsif ((l_rec_rule_id is null) and (p_task_rec.unit_of_measure is not null) ) then

Line 4174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task_common.create_new_data', ' Converting non-repeating into repeating ' );

4170: nonrepeat_to_repeat:=true;
4171:
4172: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4173:
4174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task_common.create_new_data', ' Converting non-repeating into repeating ' );
4175:
4176: end if;
4177:
4178: end if;

Line 4199: l_changed_rule := cac_sync_task_common.changed_repeat_rule(p_task_rec => p_task_rec);

4195: p_repeating_task_id => l_task_id,
4196: p_task_rec => p_task_rec
4197: );
4198: ELSE -- p_exclusion_tbl.COUNT = 0 and check change rule
4199: l_changed_rule := cac_sync_task_common.changed_repeat_rule(p_task_rec => p_task_rec);
4200:
4201: IF l_changed_rule AND
4202: l_update_type = cac_sync_task_common.g_update_all
4203: THEN -- Changed Repeating Rule

Line 4202: l_update_type = cac_sync_task_common.g_update_all

4198: ELSE -- p_exclusion_tbl.COUNT = 0 and check change rule
4199: l_changed_rule := cac_sync_task_common.changed_repeat_rule(p_task_rec => p_task_rec);
4200:
4201: IF l_changed_rule AND
4202: l_update_type = cac_sync_task_common.g_update_all
4203: THEN -- Changed Repeating Rule
4204:
4205:
4206: -- include open end dates also

Line 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);

4681: ELSE--IF --(l_update_type=g_do_nothing) then
4682: /*
4683:
4684: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
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 (

Line 5038: x_operation := cac_sync_task_common.g_delete;

5034: IF (p_task_status_id = 8)
5035: OR (p_task_status_id = 4)
5036: OR (p_task_status_id = 7)
5037: THEN
5038: x_operation := cac_sync_task_common.g_delete;
5039: END IF;
5040:
5041: IF (p_task_status_id = 12)
5042: OR (p_task_status_id = 15)

Line 5058: x_operation := cac_sync_task_common.g_delete;

5054: OR (NVL (l_rejected_flag, 'N') = 'Y')
5055: OR (NVL (l_completed_flag, 'N') = 'Y')
5056: OR (NVL (l_cancelled_flag, 'N') = 'Y')
5057: THEN
5058: x_operation := cac_sync_task_common.g_delete;
5059: END IF;
5060: CLOSE c_task_status;
5061: END IF;
5062:

Line 5076: x_operation := cac_sync_task_common.g_delete;

5072: OR (NVL (l_rejected_flag, 'N') = 'Y')
5073: OR (NVL (l_completed_flag, 'N') = 'Y')
5074: OR (NVL (l_cancelled_flag, 'N') = 'Y')
5075: THEN
5076: x_operation := cac_sync_task_common.g_delete;
5077: ELSIF (NVL (l_assigned_flag, 'N') = 'Y')
5078: THEN p_task_status_id := 12;
5079: ELSIF (NVL (l_working_flag, 'N') = 'Y')
5080: THEN p_task_status_id := 15;

Line 5090: x_operation := cac_sync_task_common.g_modify;

5086: THEN p_task_status_id := 16;
5087: ELSIF (NVL (l_approved_flag, 'N') = 'Y')
5088: THEN p_task_status_id := 15;
5089: END IF;
5090: x_operation := cac_sync_task_common.g_modify;
5091:
5092: CLOSE c_task_status;
5093:
5094: END IF;

Line 5174: fnd_message.set_token('PROC_NAME','cac_sync_task_COMMON.GET_TASK_ID');

5170: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
5171: fnd_msg_pub.add;
5172:
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;

Line 5290: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.delete_booking', 'no booking is found for the principal id ' || p_principal_id);

5286: fetch getBookings into p_getBookings ;
5287:
5288: /* if (getBookings%NOTFOUND) then
5289: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5290: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.delete_booking', 'no booking is found for the principal id ' || p_principal_id);
5291: end if;
5292: else
5293:
5294: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 5295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.delete_booking', 'booking is found for the principal id ' || p_principal_id);

5291: end if;
5292: else
5293:
5294: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.delete_booking', 'booking is found for the principal id ' || p_principal_id);
5296: end if;
5297:
5298: end if;*/
5299:

Line 5314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.delete_booking', 'success from cac_bookings_pub.delete_booking');

5310: cac_sync_task_map_pkg.delete_row (
5311: p_task_sync_id => p_getBookings.task_sync_id);
5312:
5313: /* if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.delete_booking', 'success from cac_bookings_pub.delete_booking');
5315: end if;
5316:
5317: else --failure from delete_booking API
5318:

Line 5320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.delete_booking', 'failure from cac_bookings_pub.delete_booking');

5316:
5317: else --failure from delete_booking API
5318:
5319: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_sync_task_common.delete_booking', 'failure from cac_bookings_pub.delete_booking');
5321: end if;
5322: */
5323:
5324: END IF;

Line 5364: cac_sync_task_common.get_resource_details (l_resource_id, l_resource_type);

5360:
5361: BEGIN
5362:
5363: l_task_id:=get_task_id (p_sync_id=>p_task_rec.syncid );
5364: cac_sync_task_common.get_resource_details (l_resource_id, l_resource_type);
5365:
5366: l_update_type := get_update_type (
5367: p_task_id => l_task_id,
5368: p_resource_id => l_resource_id,

Line 5574: END CAC_SYNC_TASK_COMMON ;

5570:
5571: END is_appointment_existing;
5572:
5573:
5574: END CAC_SYNC_TASK_COMMON ;