DBA Data[Home] [Help]

APPS.CAC_SYNC_TASK_COMMON dependencies on FND_LOG

Line 2311: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2307:
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;

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 2317: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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 2324: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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 2340: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2336:
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;

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 2384: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2380: x_friday => l_friday,
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;

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 2389: 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
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;

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 3848: /* if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3844: l_task_id := get_task_id (p_sync_id => 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:

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 3981: /* if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3977: );
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:

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 4162: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4158: if ((l_rec_rule_id is not null) and (p_task_rec.unit_of_measure IS NULL) ) then
4159:
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;

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 4172: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4168: elsif ((l_rec_rule_id is null) and (p_task_rec.unit_of_measure is not null) ) then
4169:
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;

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 4684: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4680: --check when user cant update the appointment as he is the invitee not the owner
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:

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 5289: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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 5294: 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
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;*/

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 5313: /* if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5309: THEN
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

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 5319: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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;