DBA Data[Home] [Help]

APPS.HR_DELTA_SYNC_MESSAGES dependencies on HR_DELTA_SYNC_MESSAGES

Line 1: PACKAGE BODY HR_DELTA_SYNC_MESSAGES as

1: PACKAGE BODY HR_DELTA_SYNC_MESSAGES as
2: /* $Header: perhrhdrir.pkb 120.13 2008/03/19 09:50:29 sathkris noship $ */
3:
4: /*Procedure to update the record into hr_psft_sync_run table begins*/
5: PROCEDURE update_psft_sync_run

Line 167: hr_delta_sync_messages.insert_psft_sync_run(2,'COUNTRY_DELTA_SYNC',errbuf,retcode);

163: if l_dummy = 0
164: then
165: FND_FILE.NEW_LINE(FND_FILE.log, 1);
166: FND_FILE.put_line(fnd_file.log,'Country Delta synch Data Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
167: hr_delta_sync_messages.insert_psft_sync_run(2,'COUNTRY_DELTA_SYNC',errbuf,retcode);
168:
169:
170:
171: open fet_psft_run_dt;

Line 268: hr_delta_sync_messages.update_psft_sync_run(1,'COUNTRY_DELTA_SYNC',p_effective_date,errbuf,retcode);

264: end if;
265: end loop;
266: close fet_cntry_fsync;
267:
268: hr_delta_sync_messages.update_psft_sync_run(1,'COUNTRY_DELTA_SYNC',p_effective_date,errbuf,retcode);
269: FND_FILE.NEW_LINE(FND_FILE.log, 1);
270: FND_FILE.put_line(fnd_file.log,'Country Delta Synch Data Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
271: end if;
272:

Line 275: hr_delta_sync_messages.update_psft_sync_run(3,'COUNTRY_DELTA_SYNC',p_effective_date,errbuf,retcode);

271: end if;
272:
273: exception
274: when OTHERS then
275: hr_delta_sync_messages.update_psft_sync_run(3,'COUNTRY_DELTA_SYNC',p_effective_date,errbuf,retcode);
276: errbuf := errbuf||SQLERRM;
277: retcode := '1';
278: FND_FILE.put_line(fnd_file.log, 'Error in Country Delta Synch Extraction: '||SQLCODE);
279: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 375: hr_delta_sync_messages.insert_psft_sync_run(2,'STATE_DELTA_SYNC',errbuf,retcode);

371: if l_dummy = 0
372: then
373: FND_FILE.NEW_LINE(FND_FILE.log, 1);
374: FND_FILE.put_line(fnd_file.log,'State Delta synch Data Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
375: hr_delta_sync_messages.insert_psft_sync_run(2,'STATE_DELTA_SYNC',errbuf,retcode);
376:
377: open fet_psft_run_dt;
378: fetch fet_psft_run_dt into p_max_run_date;
379: close fet_psft_run_dt;

Line 474: hr_delta_sync_messages.update_psft_sync_run(1,'STATE_DELTA_SYNC',p_effective_date,errbuf,retcode);

470: end loop;
471:
472: close fet_state_sync;
473:
474: hr_delta_sync_messages.update_psft_sync_run(1,'STATE_DELTA_SYNC',p_effective_date,errbuf,retcode);
475: FND_FILE.NEW_LINE(FND_FILE.log, 1);
476: FND_FILE.put_line(fnd_file.log,'State Delta Synch Data Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
477:
478: end if;

Line 485: hr_delta_sync_messages.update_psft_sync_run(3,'STATE_DELTA_SYNC',p_effective_date,errbuf,retcode);

481: exception
482:
483:
484: when others then
485: hr_delta_sync_messages.update_psft_sync_run(3,'STATE_DELTA_SYNC',p_effective_date,errbuf,retcode);
486: errbuf := errbuf||SQLERRM;
487: retcode := '1';
488: FND_FILE.put_line(fnd_file.log, 'Error in State Delta Synch Extraction: '||SQLCODE);
489: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 677: hr_delta_sync_messages.insert_psft_sync_run(2,'LOC_DELTA_SYNC',errbuf,retcode);

673:
674:
675: FND_FILE.NEW_LINE(FND_FILE.log, 1);
676: FND_FILE.put_line(fnd_file.log,'Location Delta synch Data Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
677: hr_delta_sync_messages.insert_psft_sync_run(2,'LOC_DELTA_SYNC',errbuf,retcode);
678:
679: open fet_psft_run_dt;
680: fetch fet_psft_run_dt into p_max_run_date;
681: close fet_psft_run_dt;

Line 852: hr_delta_sync_messages.update_psft_sync_run(1,'LOC_DELTA_SYNC',p_effective_date,errbuf,retcode);

848: end if;
849: end loop;
850: close fet_loc_sync;
851:
852: hr_delta_sync_messages.update_psft_sync_run(1,'LOC_DELTA_SYNC',p_effective_date,errbuf,retcode);
853: FND_FILE.NEW_LINE(FND_FILE.log, 1);
854: FND_FILE.put_line(fnd_file.log,'Location Delta Synch Data Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
855:
856: end if;

Line 862: hr_delta_sync_messages.update_psft_sync_run(3,'LOC_DELTA_SYNC',p_effective_date,errbuf,retcode);

858: exception
859:
860: when OTHERS then
861:
862: hr_delta_sync_messages.update_psft_sync_run(3,'LOC_DELTA_SYNC',p_effective_date,errbuf,retcode);
863: errbuf := errbuf||SQLERRM;
864: retcode := '1';
865: FND_FILE.put_line(fnd_file.log, 'Error in Location Delta Synch Extraction: '||SQLCODE);
866: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 1176: hr_delta_sync_messages.insert_psft_sync_run(2,'PERSON_DELTA_SYNC',errbuf,retcode);

1172:
1173:
1174: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1175: FND_FILE.put_line(fnd_file.log,'Person Delta synch Data Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
1176: hr_delta_sync_messages.insert_psft_sync_run(2,'PERSON_DELTA_SYNC',errbuf,retcode);
1177:
1178: open csr_psft_sync;
1179: fetch csr_psft_sync into l_sync_date;
1180: close csr_psft_sync;

Line 1345: hr_delta_sync_messages.update_psft_sync_run(1,'PERSON_DELTA_SYNC',p_effective_date,errbuf,retcode);

1341:
1342: end loop;
1343: close csr_person_delta_sync;
1344:
1345: hr_delta_sync_messages.update_psft_sync_run(1,'PERSON_DELTA_SYNC',p_effective_date,errbuf,retcode);
1346: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1347: FND_FILE.put_line(fnd_file.log,'Person Delta Synch Data Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
1348: end if;
1349:

Line 1354: hr_delta_sync_messages.update_psft_sync_run(3,'PERSON_DELTA_SYNC',p_effective_date,errbuf,retcode);

1350: exception
1351:
1352: when OTHERS then
1353:
1354: hr_delta_sync_messages.update_psft_sync_run(3,'PERSON_DELTA_SYNC',p_effective_date,errbuf,retcode);
1355: errbuf := errbuf||SQLERRM;
1356: retcode := '1';
1357: FND_FILE.put_line(fnd_file.log, 'Error in Person Delta Synch Extraction: '||SQLCODE);
1358: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 1483: hr_delta_sync_messages.insert_psft_sync_run(2,'WORKFORCE_DELTA_SYNC',errbuf,retcode);

1479: if l_dummy = 0
1480: then
1481: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1482: FND_FILE.put_line(fnd_file.log,'Work Force Delta synch Data Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
1483: hr_delta_sync_messages.insert_psft_sync_run(2,'WORKFORCE_DELTA_SYNC',errbuf,retcode);
1484:
1485:
1486:
1487: open fet_psft_run_dt;

Line 1802: hr_delta_sync_messages.update_psft_sync_run(1,'WORKFORCE_DELTA_SYNC',p_effective_date,errbuf,retcode);

1798: close csr_gen_msg;
1799:
1800:
1801: END Loop;
1802: hr_delta_sync_messages.update_psft_sync_run(1,'WORKFORCE_DELTA_SYNC',p_effective_date,errbuf,retcode);
1803: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1804: FND_FILE.put_line(fnd_file.log,'Work Force Delta Synch Data Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
1805:
1806: End if;

Line 1810: hr_delta_sync_messages.update_psft_sync_run(3,'WORKFORCE_DELTA_SYNC',p_effective_date,errbuf,retcode);

1806: End if;
1807:
1808: exception
1809: when OTHERS then
1810: hr_delta_sync_messages.update_psft_sync_run(3,'WORKFORCE_DELTA_SYNC',p_effective_date,errbuf,retcode);
1811: errbuf := errbuf||SQLERRM;
1812: retcode := '1';
1813: FND_FILE.put_line(fnd_file.log, 'Error in Work Force Delta Synch Extraction: '||SQLCODE);
1814: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 1905: hr_delta_sync_messages.insert_psft_sync_run(2,'JOBCODE_DELTA_SYNC',errbuf,retcode);

1901: then
1902:
1903: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1904: FND_FILE.put_line(fnd_file.log,'JobCode Delta synch Data Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
1905: hr_delta_sync_messages.insert_psft_sync_run(2,'JOBCODE_DELTA_SYNC',errbuf,retcode);
1906: /* Fetching the jobcode data for delta Sync */
1907:
1908: open fet_psft_run_dt;
1909: fetch fet_psft_run_dt into run_date;

Line 2118: hr_delta_sync_messages.update_psft_sync_run(1,'JOBCODE_DELTA_SYNC',p_effective_date,errbuf,retcode);

2114: close csr_gen_msg;
2115:
2116: END loop;
2117:
2118: hr_delta_sync_messages.update_psft_sync_run(1,'JOBCODE_DELTA_SYNC',p_effective_date,errbuf,retcode);
2119: FND_FILE.NEW_LINE(FND_FILE.log, 1);
2120: FND_FILE.put_line(fnd_file.log,'Jobcode Delta Synch Data Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
2121: end if;
2122:

Line 2125: hr_delta_sync_messages.update_psft_sync_run(3,'JOBCODE_DELTA_SYNC',p_effective_date,errbuf,retcode);

2121: end if;
2122:
2123: EXCEPTION
2124: WHEN OTHERS THEN
2125: hr_delta_sync_messages.update_psft_sync_run(3,'JOBCODE_DELTA_SYNC',p_effective_date,errbuf,retcode);
2126: errbuf := errbuf||SQLERRM;
2127: retcode := '1';
2128: FND_FILE.put_line(fnd_file.log, 'Error in Jobcode Delta Synch Extraction: '||SQLCODE);
2129: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 2260: hr_delta_sync_messages.insert_psft_sync_run(2,'ORG_DELTA_SYNC',errbuf,retcode);

2256: if l_dummy = 0
2257: then
2258: FND_FILE.NEW_LINE(FND_FILE.log, 1);
2259: FND_FILE.put_line(fnd_file.log,'Organization Delta synch Data Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
2260: hr_delta_sync_messages.insert_psft_sync_run(2,'ORG_DELTA_SYNC',errbuf,retcode);
2261:
2262:
2263:
2264: open fet_psft_run_dt;

Line 2388: hr_delta_sync_messages.update_psft_sync_run(1,'ORG_DELTA_SYNC',p_effective_date,errbuf,retcode);

2384: end if;
2385: end loop;
2386: close fet_orgn_fsync;
2387:
2388: hr_delta_sync_messages.update_psft_sync_run(1,'ORG_DELTA_SYNC',p_effective_date,errbuf,retcode);
2389: FND_FILE.NEW_LINE(FND_FILE.log, 1);
2390: FND_FILE.put_line(fnd_file.log,'Organization Delta Synch Data Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
2391: end if;
2392:

Line 2395: hr_delta_sync_messages.update_psft_sync_run(3,'ORG_DELTA_SYNC',p_effective_date,errbuf,retcode);

2391: end if;
2392:
2393: exception
2394: when OTHERS then
2395: hr_delta_sync_messages.update_psft_sync_run(3,'ORG_DELTA_SYNC',p_effective_date,errbuf,retcode);
2396: errbuf := errbuf||SQLERRM;
2397: retcode := '1';
2398: FND_FILE.put_line(fnd_file.log, 'Error in Organization Delta Synch Extraction: '||SQLCODE);
2399: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 2500: hr_delta_sync_messages.insert_psft_sync_run(2,'BG_DELTA_SYNC',errbuf,retcode);

2496: if l_dummy = 0
2497: then
2498: FND_FILE.NEW_LINE(FND_FILE.log, 1);
2499: FND_FILE.put_line(fnd_file.log,'Business Group Delta synch Data Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
2500: hr_delta_sync_messages.insert_psft_sync_run(2,'BG_DELTA_SYNC',errbuf,retcode);
2501:
2502:
2503:
2504: open fet_psft_run_dt;

Line 2604: hr_delta_sync_messages.update_psft_sync_run(1,'BG_DELTA_SYNC',p_effective_date,errbuf,retcode);

2600: end if;
2601: end loop;
2602: close fet_bg_fsync;
2603:
2604: hr_delta_sync_messages.update_psft_sync_run(1,'BG_DELTA_SYNC',p_effective_date,errbuf,retcode);
2605: FND_FILE.NEW_LINE(FND_FILE.log, 1);
2606: FND_FILE.put_line(fnd_file.log,'Business Group Delta Synch Data Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
2607: end if;
2608:

Line 2611: hr_delta_sync_messages.update_psft_sync_run(3,'BG_DELTA_SYNC',p_effective_date,errbuf,retcode);

2607: end if;
2608:
2609: exception
2610: when OTHERS then
2611: hr_delta_sync_messages.update_psft_sync_run(3,'BG_DELTA_SYNC',p_effective_date,errbuf,retcode);
2612: errbuf := errbuf||SQLERRM;
2613: retcode := '1';
2614: FND_FILE.put_line(fnd_file.log, 'Error in Business Group Delta Synch Extraction: '||SQLCODE);
2615: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 2728: hr_delta_sync_messages.insert_psft_sync_run(2,'PYRL_DELTA_SYNC',errbuf,retcode);

2724: if l_dummy = 0
2725: then
2726: FND_FILE.NEW_LINE(FND_FILE.log, 1);
2727: FND_FILE.put_line(fnd_file.log,'Payroll Delta synch Data Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
2728: hr_delta_sync_messages.insert_psft_sync_run(2,'PYRL_DELTA_SYNC',errbuf,retcode);
2729:
2730:
2731:
2732: open fet_psft_run_dt;

Line 2846: hr_delta_sync_messages.update_psft_sync_run(1,'PYRL_DELTA_SYNC',p_effective_date,errbuf,retcode);

2842: end if;
2843: end loop;
2844: close fet_pyrl_fsync;
2845:
2846: hr_delta_sync_messages.update_psft_sync_run(1,'PYRL_DELTA_SYNC',p_effective_date,errbuf,retcode);
2847: FND_FILE.NEW_LINE(FND_FILE.log, 1);
2848: FND_FILE.put_line(fnd_file.log,'Payroll Delta Synch Data Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
2849: end if;
2850:

Line 2853: hr_delta_sync_messages.update_psft_sync_run(3,'PYRL_DELTA_SYNC',p_effective_date,errbuf,retcode);

2849: end if;
2850:
2851: exception
2852: when OTHERS then
2853: hr_delta_sync_messages.update_psft_sync_run(3,'PYRL_DELTA_SYNC',p_effective_date,errbuf,retcode);
2854: errbuf := errbuf||SQLERRM;
2855: retcode := '1';
2856: FND_FILE.put_line(fnd_file.log, 'Error in Payroll Delta Synch Extraction: '||SQLCODE);
2857: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 2874: hr_delta_sync_messages.hr_state_delta_sync(ERRBUF,RETCODE,p_party_site_id);

2870: FND_FILE.NEW_LINE(FND_FILE.log, 1);
2871: FND_FILE.put_line(fnd_file.log,'Delta synch Data Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
2872: if p_process_name = 'STATE_DELTA_SYNCH'
2873: then
2874: hr_delta_sync_messages.hr_state_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2875: elsif p_process_name = 'COUNTRY_DELTA_SYNCH'
2876: then
2877:
2878: hr_delta_sync_messages.hr_country_delta_sync(ERRBUF,RETCODE,p_party_site_id);

Line 2878: hr_delta_sync_messages.hr_country_delta_sync(ERRBUF,RETCODE,p_party_site_id);

2874: hr_delta_sync_messages.hr_state_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2875: elsif p_process_name = 'COUNTRY_DELTA_SYNCH'
2876: then
2877:
2878: hr_delta_sync_messages.hr_country_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2879: elsif p_process_name = 'LOCATION_DELTA_SYNCH'
2880: then
2881: hr_delta_sync_messages.hr_location_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2882: elsif p_process_name = 'PERSON_DELTA_SYNCH'

Line 2881: hr_delta_sync_messages.hr_location_delta_sync(ERRBUF,RETCODE,p_party_site_id);

2877:
2878: hr_delta_sync_messages.hr_country_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2879: elsif p_process_name = 'LOCATION_DELTA_SYNCH'
2880: then
2881: hr_delta_sync_messages.hr_location_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2882: elsif p_process_name = 'PERSON_DELTA_SYNCH'
2883: then
2884: hr_delta_sync_messages.hr_person_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2885: elsif p_process_name = 'WORKFORCE_DELTA_SYNCH'

Line 2884: hr_delta_sync_messages.hr_person_delta_sync(ERRBUF,RETCODE,p_party_site_id);

2880: then
2881: hr_delta_sync_messages.hr_location_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2882: elsif p_process_name = 'PERSON_DELTA_SYNCH'
2883: then
2884: hr_delta_sync_messages.hr_person_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2885: elsif p_process_name = 'WORKFORCE_DELTA_SYNCH'
2886: then
2887: hr_delta_sync_messages.hr_workforce_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2888: elsif p_process_name = 'JOBCODE_DELTA_SYNCH' then

Line 2887: hr_delta_sync_messages.hr_workforce_delta_sync(ERRBUF,RETCODE,p_party_site_id);

2883: then
2884: hr_delta_sync_messages.hr_person_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2885: elsif p_process_name = 'WORKFORCE_DELTA_SYNCH'
2886: then
2887: hr_delta_sync_messages.hr_workforce_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2888: elsif p_process_name = 'JOBCODE_DELTA_SYNCH' then
2889: hr_delta_sync_messages.hr_jobcode_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2890: elsif p_process_name = 'ORGANIZATION_DELTA_SYNCH' then
2891: hr_delta_sync_messages.hr_organizaton_delta_sync(ERRBUF,RETCODE,p_party_site_id);

Line 2889: hr_delta_sync_messages.hr_jobcode_delta_sync(ERRBUF,RETCODE,p_party_site_id);

2885: elsif p_process_name = 'WORKFORCE_DELTA_SYNCH'
2886: then
2887: hr_delta_sync_messages.hr_workforce_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2888: elsif p_process_name = 'JOBCODE_DELTA_SYNCH' then
2889: hr_delta_sync_messages.hr_jobcode_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2890: elsif p_process_name = 'ORGANIZATION_DELTA_SYNCH' then
2891: hr_delta_sync_messages.hr_organizaton_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2892: elsif p_process_name = 'BUSINESSGROUP_DELTA_SYNCH' then
2893: hr_delta_sync_messages.hr_businessgrp_delta_sync(ERRBUF,RETCODE,p_party_site_id);

Line 2891: hr_delta_sync_messages.hr_organizaton_delta_sync(ERRBUF,RETCODE,p_party_site_id);

2887: hr_delta_sync_messages.hr_workforce_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2888: elsif p_process_name = 'JOBCODE_DELTA_SYNCH' then
2889: hr_delta_sync_messages.hr_jobcode_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2890: elsif p_process_name = 'ORGANIZATION_DELTA_SYNCH' then
2891: hr_delta_sync_messages.hr_organizaton_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2892: elsif p_process_name = 'BUSINESSGROUP_DELTA_SYNCH' then
2893: hr_delta_sync_messages.hr_businessgrp_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2894: elsif p_process_name = 'PAYROLL_DELTA_SYNCH' then
2895: hr_delta_sync_messages.hr_payroll_delta_sync(ERRBUF,RETCODE,p_party_site_id);

Line 2893: hr_delta_sync_messages.hr_businessgrp_delta_sync(ERRBUF,RETCODE,p_party_site_id);

2889: hr_delta_sync_messages.hr_jobcode_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2890: elsif p_process_name = 'ORGANIZATION_DELTA_SYNCH' then
2891: hr_delta_sync_messages.hr_organizaton_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2892: elsif p_process_name = 'BUSINESSGROUP_DELTA_SYNCH' then
2893: hr_delta_sync_messages.hr_businessgrp_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2894: elsif p_process_name = 'PAYROLL_DELTA_SYNCH' then
2895: hr_delta_sync_messages.hr_payroll_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2896: end if;
2897: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 2895: hr_delta_sync_messages.hr_payroll_delta_sync(ERRBUF,RETCODE,p_party_site_id);

2891: hr_delta_sync_messages.hr_organizaton_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2892: elsif p_process_name = 'BUSINESSGROUP_DELTA_SYNCH' then
2893: hr_delta_sync_messages.hr_businessgrp_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2894: elsif p_process_name = 'PAYROLL_DELTA_SYNCH' then
2895: hr_delta_sync_messages.hr_payroll_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2896: end if;
2897: FND_FILE.NEW_LINE(FND_FILE.log, 1);
2898: FND_FILE.put_line(fnd_file.log,'Delta synch Data Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
2899: end hr_delta_sync;

Line 2970: end hr_delta_sync_messages;

2966: end;
2967:
2968: /*common procedure to update the status of the sync data from message designer ends here*/
2969:
2970: end hr_delta_sync_messages;
2971: