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.PAY_DK_ARCHIVE_EHOL dependencies on HR_UTILITY

Line 4: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_DK_ARCHIVE_EHOL AS
2: /* $Header: pydkeholca.pkb 120.0.12020000.2 2012/07/18 05:29:44 rsahai noship $ */
3:
4: g_debug BOOLEAN := hr_utility.debug_enabled;
5: g_package VARCHAR2(33) := ' PAY_DK_ARCHIVE_EHOL.';
6: g_payroll_action_id NUMBER ;
7: g_le_assignment_action_id NUMBER ;
8: g_business_group_id NUMBER;

Line 43: hr_utility.set_location(' Entering Function PAY_DK_ARCHIVE_EHOL.GET_COUNTRY_NAME',111);

39:
40: BEGIN
41:
42: IF g_debug THEN
43: hr_utility.set_location(' Entering Function PAY_DK_ARCHIVE_EHOL.GET_COUNTRY_NAME',111);
44: END IF;
45:
46: OPEN csr_get_territory_name(p_territory_code);
47: FETCH csr_get_territory_name into l_country;

Line 53: hr_utility.set_location(' Leaving Function PAY_DK_ARCHIVE_EHOL.GET_COUNTRY_NAME',112);

49:
50: RETURN l_country;
51:
52: IF g_debug THEN
53: hr_utility.set_location(' Leaving Function PAY_DK_ARCHIVE_EHOL.GET_COUNTRY_NAME',112);
54: END IF;
55:
56: END GET_COUNTRY_NAME;
57: --

Line 142: hr_utility.set_location(' Entering Function GET_PARAMETER',10);

138: l_proc VARCHAR2(40):= g_package||' get parameter ';
139: BEGIN
140: --
141: IF g_debug THEN
142: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
143: END IF;
144: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
145: --
146: IF l_start_pos = 0 THEN

Line 173: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);

169: END IF;
170: END IF;
171: --
172: IF g_debug THEN
173: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
174: END IF;
175:
176: RETURN l_parameter;
177:

Line 231: hr_utility.set_location(' get paramerters:p_start_date ' || p_start_date,30);

227: ,p_effective_date
228: ,p_business_group_id;
229: CLOSE csr_parameter_info;
230: --
231: hr_utility.set_location(' get paramerters:p_start_date ' || p_start_date,30);
232: hr_utility.set_location(' get paramerters:p_end_date ' || p_end_date,30);
233: hr_utility.set_location(' get paramerters:p_payroll_type ' || p_payroll_type,30);
234: IF g_debug THEN
235: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);

Line 232: hr_utility.set_location(' get paramerters:p_end_date ' || p_end_date,30);

228: ,p_business_group_id;
229: CLOSE csr_parameter_info;
230: --
231: hr_utility.set_location(' get paramerters:p_start_date ' || p_start_date,30);
232: hr_utility.set_location(' get paramerters:p_end_date ' || p_end_date,30);
233: hr_utility.set_location(' get paramerters:p_payroll_type ' || p_payroll_type,30);
234: IF g_debug THEN
235: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
236: END IF;

Line 233: hr_utility.set_location(' get paramerters:p_payroll_type ' || p_payroll_type,30);

229: CLOSE csr_parameter_info;
230: --
231: hr_utility.set_location(' get paramerters:p_start_date ' || p_start_date,30);
232: hr_utility.set_location(' get paramerters:p_end_date ' || p_end_date,30);
233: hr_utility.set_location(' get paramerters:p_payroll_type ' || p_payroll_type,30);
234: IF g_debug THEN
235: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
236: END IF;
237:

Line 235: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);

231: hr_utility.set_location(' get paramerters:p_start_date ' || p_start_date,30);
232: hr_utility.set_location(' get paramerters:p_end_date ' || p_end_date,30);
233: hr_utility.set_location(' get paramerters:p_payroll_type ' || p_payroll_type,30);
234: IF g_debug THEN
235: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
236: END IF;
237:
238: END GET_ALL_PARAMETERS;
239:

Line 413: hr_utility.set_location(' Entering Procedure RANGE_CODE',1);

409: l_uhc_payroll_1 VARCHAR2(10);
410:
411: BEGIN
412:
413: hr_utility.set_location(' Entering Procedure RANGE_CODE',1);
414:
415: IF g_debug THEN
416: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
417: END IF;

Line 416: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);

412:
413: hr_utility.set_location(' Entering Procedure RANGE_CODE',1);
414:
415: IF g_debug THEN
416: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
417: END IF;
418:
419: p_sql := 'SELECT DISTINCT person_id FROM per_people_f ppf,pay_payroll_actions ppa WHERE ppa.payroll_action_id = :payroll_action_id AND ppa.business_group_id = ppf.business_group_id ORDER BY ppf.person_id';
420:

Line 434: hr_utility.set_location('RANGE_CODE:Before Calling all parameters',2);

430: g_year:= NULL;
431: g_company_terminating:= NULL;
432: g_msg_txt:= NULL;
433:
434: hr_utility.set_location('RANGE_CODE:Before Calling all parameters',2);
435:
436: PAY_DK_ARCHIVE_EHOL.GET_ALL_PARAMETERS(
437: p_payroll_action_id
438: ,l_business_group_id

Line 450: hr_utility.set_location('RANGE_CODE:After Calling all parameters',2);

446: ,g_test_submission
447: ,g_company_terminating
448: ,g_msg_txt) ;
449:
450: hr_utility.set_location('RANGE_CODE:After Calling all parameters',2);
451:
452: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);
453: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);
454:

Line 509: hr_utility.set_location('Entered Procedure GETDATA',10);

505:
506:
507: IF l_count < 1 then
508:
509: hr_utility.set_location('Entered Procedure GETDATA',10);
510:
511:
512: -- fnd_file.put_line(fnd_file.log,'g_legal_employer_id : '||g_legal_employer_id);
513: -- fnd_file.put_line(fnd_file.log,'l_business_group_id : '||l_business_group_id);

Line 638: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);

634: Raise l_ehc_exception;
635: END IF;
636:
637: IF g_debug THEN
638: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
639: END IF;
640:
641: EXCEPTION
642: WHEN l_ehc_exception THEN

Line 643: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,410);

639: END IF;
640:
641: EXCEPTION
642: WHEN l_ehc_exception THEN
643: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,410);
644: Fnd_file.put_line(FND_FILE.LOG,'Process completed with error(s). Please check the output file.' );
645: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Process completed with error(s). Please check the output file.');
646: WHEN others THEN
647: IF g_debug THEN

Line 648: hr_utility.set_location('error raised assignment_action_code ',5);

644: Fnd_file.put_line(FND_FILE.LOG,'Process completed with error(s). Please check the output file.' );
645: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Process completed with error(s). Please check the output file.');
646: WHEN others THEN
647: IF g_debug THEN
648: hr_utility.set_location('error raised assignment_action_code ',5);
649: END if;
650: RAISE;
651: END RANGE_CODE;
652:

Line 778: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);

774: if(g_flag=0) then
775: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 1');
776:
777: IF g_debug THEN
778: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
779: END IF;
780:
781: PAY_DK_ARCHIVE_EHOL.GET_ALL_PARAMETERS(
782: p_payroll_action_id

Line 925: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);

921:
922: END LOOP;
923:
924: IF g_debug THEN
925: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
926: END IF;
927: end if; -- end g_flag condition.
928:
929: EXCEPTION

Line 932: hr_utility.set_location('error raised assignment_action_code ',5);

928:
929: EXCEPTION
930: WHEN others THEN
931: IF g_debug THEN
932: hr_utility.set_location('error raised assignment_action_code ',5);
933: END if;
934: RAISE;
935: END ASSIGNMENT_ACTION_CODE;
936:

Line 944: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);

940: IS
941:
942: BEGIN
943: IF g_debug THEN
944: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
945: END IF;
946: -- fnd_file.put_line(fnd_file.log,'INITIALIZATION_CODE 1');
947: IF g_debug THEN
948: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);

Line 948: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);

944: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
945: END IF;
946: -- fnd_file.put_line(fnd_file.log,'INITIALIZATION_CODE 1');
947: IF g_debug THEN
948: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
949: END IF;
950:
951: EXCEPTION
952: WHEN others THEN

Line 954: hr_utility.set_location('error raised initialization code ',5);

950:
951: EXCEPTION
952: WHEN others THEN
953: IF g_debug THEN
954: hr_utility.set_location('error raised initialization code ',5);
955: END if;
956: RAISE;
957: END INITIALIZATION_CODE;
958:

Line 1835: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);

1831: WHERE assignment_action_id=p_assignment_action_id;
1832: END;
1833:
1834: IF g_debug THEN
1835: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
1836: END IF;
1837:
1838: /* Fetching report parameters */
1839: PAY_DK_ARCHIVE_EHOL.GET_ALL_PARAMETERS(

Line 1893: hr_utility.set_location('ARCHIVE_CODE: l_assignment_id '|| l_ass_id,380);

1889: --if(g_company_terminating='N') then
1890:
1891: fnd_file.put_line(fnd_file.log,'Fetched report parameters');
1892:
1893: hr_utility.set_location('ARCHIVE_CODE: l_assignment_id '|| l_ass_id,380);
1894: hr_utility.set_location('ARCHIVE_CODE: Before For loop csr_asg_payroll ',380);
1895:
1896: --
1897: IF g_payroll_id IS NULL THEN

Line 1894: hr_utility.set_location('ARCHIVE_CODE: Before For loop csr_asg_payroll ',380);

1890:
1891: fnd_file.put_line(fnd_file.log,'Fetched report parameters');
1892:
1893: hr_utility.set_location('ARCHIVE_CODE: l_assignment_id '|| l_ass_id,380);
1894: hr_utility.set_location('ARCHIVE_CODE: Before For loop csr_asg_payroll ',380);
1895:
1896: --
1897: IF g_payroll_id IS NULL THEN
1898: l_where_clause := ' and 1=1 ';

Line 1955: --hr_utility.set_location('ARCHIVE_CODE: Payroll Name ' || csr_asg_payroll_rec.payroll_name,380);

1951: FETCH csr_asg_payroll INTO l_payroll_id,l_period_id;
1952: EXIT WHEN csr_asg_payroll%NOTFOUND;
1953:
1954: --CLOSE csr_asg_payroll;
1955: --hr_utility.set_location('ARCHIVE_CODE: Payroll Name ' || csr_asg_payroll_rec.payroll_name,380);
1956: hr_utility.set_location('ARCHIVE_CODE: l_payroll_id ' || l_payroll_id,380);
1957: --hr_utility.set_location('ARCHIVE_CODE: Period Name ' || csr_asg_payroll_rec.period_name,380);
1958: hr_utility.set_location('ARCHIVE_CODE: time_period_id ' || l_period_id,380);
1959: l_employment_type :='00';

Line 1956: hr_utility.set_location('ARCHIVE_CODE: l_payroll_id ' || l_payroll_id,380);

1952: EXIT WHEN csr_asg_payroll%NOTFOUND;
1953:
1954: --CLOSE csr_asg_payroll;
1955: --hr_utility.set_location('ARCHIVE_CODE: Payroll Name ' || csr_asg_payroll_rec.payroll_name,380);
1956: hr_utility.set_location('ARCHIVE_CODE: l_payroll_id ' || l_payroll_id,380);
1957: --hr_utility.set_location('ARCHIVE_CODE: Period Name ' || csr_asg_payroll_rec.period_name,380);
1958: hr_utility.set_location('ARCHIVE_CODE: time_period_id ' || l_period_id,380);
1959: l_employment_type :='00';
1960: l_green_land_code :='000';

Line 1957: --hr_utility.set_location('ARCHIVE_CODE: Period Name ' || csr_asg_payroll_rec.period_name,380);

1953:
1954: --CLOSE csr_asg_payroll;
1955: --hr_utility.set_location('ARCHIVE_CODE: Payroll Name ' || csr_asg_payroll_rec.payroll_name,380);
1956: hr_utility.set_location('ARCHIVE_CODE: l_payroll_id ' || l_payroll_id,380);
1957: --hr_utility.set_location('ARCHIVE_CODE: Period Name ' || csr_asg_payroll_rec.period_name,380);
1958: hr_utility.set_location('ARCHIVE_CODE: time_period_id ' || l_period_id,380);
1959: l_employment_type :='00';
1960: l_green_land_code :='000';
1961: --l_payroll_id:= csr_asg_payroll_rec.payroll_id;

Line 1958: hr_utility.set_location('ARCHIVE_CODE: time_period_id ' || l_period_id,380);

1954: --CLOSE csr_asg_payroll;
1955: --hr_utility.set_location('ARCHIVE_CODE: Payroll Name ' || csr_asg_payroll_rec.payroll_name,380);
1956: hr_utility.set_location('ARCHIVE_CODE: l_payroll_id ' || l_payroll_id,380);
1957: --hr_utility.set_location('ARCHIVE_CODE: Period Name ' || csr_asg_payroll_rec.period_name,380);
1958: hr_utility.set_location('ARCHIVE_CODE: time_period_id ' || l_period_id,380);
1959: l_employment_type :='00';
1960: l_green_land_code :='000';
1961: --l_payroll_id:= csr_asg_payroll_rec.payroll_id;
1962: --l_period_id:= csr_asg_payroll_rec.time_period_id;

Line 1964: hr_utility.set_location('ARCHIVE_CODE:After assign l_payroll_id ' || l_payroll_id,380);

1960: l_green_land_code :='000';
1961: --l_payroll_id:= csr_asg_payroll_rec.payroll_id;
1962: --l_period_id:= csr_asg_payroll_rec.time_period_id;
1963:
1964: hr_utility.set_location('ARCHIVE_CODE:After assign l_payroll_id ' || l_payroll_id,380);
1965: hr_utility.set_location('ARCHIVE_CODE:After assign l_period_id ' || l_period_id,380);
1966: hr_utility.set_location('ARCHIVE_CODE:p_effective_date ' || p_effective_date,380);
1967:
1968: OPEN csr_pay_periods(l_payroll_id,l_period_id);

Line 1965: hr_utility.set_location('ARCHIVE_CODE:After assign l_period_id ' || l_period_id,380);

1961: --l_payroll_id:= csr_asg_payroll_rec.payroll_id;
1962: --l_period_id:= csr_asg_payroll_rec.time_period_id;
1963:
1964: hr_utility.set_location('ARCHIVE_CODE:After assign l_payroll_id ' || l_payroll_id,380);
1965: hr_utility.set_location('ARCHIVE_CODE:After assign l_period_id ' || l_period_id,380);
1966: hr_utility.set_location('ARCHIVE_CODE:p_effective_date ' || p_effective_date,380);
1967:
1968: OPEN csr_pay_periods(l_payroll_id,l_period_id);
1969: FETCH csr_pay_periods into rg_csr_pay_periods;

Line 1966: hr_utility.set_location('ARCHIVE_CODE:p_effective_date ' || p_effective_date,380);

1962: --l_period_id:= csr_asg_payroll_rec.time_period_id;
1963:
1964: hr_utility.set_location('ARCHIVE_CODE:After assign l_payroll_id ' || l_payroll_id,380);
1965: hr_utility.set_location('ARCHIVE_CODE:After assign l_period_id ' || l_period_id,380);
1966: hr_utility.set_location('ARCHIVE_CODE:p_effective_date ' || p_effective_date,380);
1967:
1968: OPEN csr_pay_periods(l_payroll_id,l_period_id);
1969: FETCH csr_pay_periods into rg_csr_pay_periods;
1970: l_bal_date:= rg_csr_pay_periods.end_date;

Line 1975: hr_utility.set_location('ARCHIVE_CODE: l_bal_date ' || l_bal_date,380);

1971: CLOSE csr_pay_periods;
1972: l_start_date:=rg_csr_pay_periods.start_date;
1973: l_end_date:=rg_csr_pay_periods.end_date;
1974:
1975: hr_utility.set_location('ARCHIVE_CODE: l_bal_date ' || l_bal_date,380);
1976: hr_utility.set_location('ARCHIVE_CODE: l_start_date ' || l_start_date,380);
1977: hr_utility.set_location('ARCHIVE_CODE: l_end_date ' || l_end_date,380);
1978:
1979: OPEN csr_get_person_details(p_assignment_action_id, l_start_date ); -- p_effective_date 9489806 --14078879

Line 1976: hr_utility.set_location('ARCHIVE_CODE: l_start_date ' || l_start_date,380);

1972: l_start_date:=rg_csr_pay_periods.start_date;
1973: l_end_date:=rg_csr_pay_periods.end_date;
1974:
1975: hr_utility.set_location('ARCHIVE_CODE: l_bal_date ' || l_bal_date,380);
1976: hr_utility.set_location('ARCHIVE_CODE: l_start_date ' || l_start_date,380);
1977: hr_utility.set_location('ARCHIVE_CODE: l_end_date ' || l_end_date,380);
1978:
1979: OPEN csr_get_person_details(p_assignment_action_id, l_start_date ); -- p_effective_date 9489806 --14078879
1980: FETCH csr_get_person_details into rg_csr_get_person_details;

Line 1977: hr_utility.set_location('ARCHIVE_CODE: l_end_date ' || l_end_date,380);

1973: l_end_date:=rg_csr_pay_periods.end_date;
1974:
1975: hr_utility.set_location('ARCHIVE_CODE: l_bal_date ' || l_bal_date,380);
1976: hr_utility.set_location('ARCHIVE_CODE: l_start_date ' || l_start_date,380);
1977: hr_utility.set_location('ARCHIVE_CODE: l_end_date ' || l_end_date,380);
1978:
1979: OPEN csr_get_person_details(p_assignment_action_id, l_start_date ); -- p_effective_date 9489806 --14078879
1980: FETCH csr_get_person_details into rg_csr_get_person_details;
1981: CLOSE csr_get_person_details;

Line 2108: hr_utility.set_location('ARCHIVE_CODE:Before fetch l_present_flag: ' || l_present_flag,380);

2104:
2105: fnd_file.put_line(fnd_file.log,'Fetched emp DA codes.');
2106:
2107: l_present_flag:=0;
2108: hr_utility.set_location('ARCHIVE_CODE:Before fetch l_present_flag: ' || l_present_flag,380);
2109:
2110: OPEN csr_prepaid_actions_present(l_payroll_action_id,
2111: g_legal_employer_id,
2112: l_payroll_id,

Line 2120: hr_utility.set_location('ARCHIVE_CODE:After fetch l_present_flag: ' || l_present_flag,380);

2116: l_ass_id);
2117: FETCH csr_prepaid_actions_present INTO l_present_flag;
2118: CLOSE csr_prepaid_actions_present;
2119:
2120: hr_utility.set_location('ARCHIVE_CODE:After fetch l_present_flag: ' || l_present_flag,380);
2121:
2122: fnd_file.put_line(fnd_file.log,'ARCHIVE_CODE:After fetch l_present_flag: ' || l_present_flag);
2123:
2124: IF (l_present_flag=1) THEN

Line 3227: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);

3223: --end if; -- g_flag
3224:
3225: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 16');
3226: IF g_debug THEN
3227: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
3228: END IF;
3229:
3230: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE END');
3231:

Line 3235: hr_utility.set_location('error raised in archive code ',5);

3231:
3232: EXCEPTION
3233: WHEN others THEN
3234: IF g_debug THEN
3235: hr_utility.set_location('error raised in archive code ',5);
3236: END if;
3237: RAISE;
3238: END ARCHIVE_CODE;
3239:

Line 3257: hr_utility.set_location('error raised in DEINITIALIZATION_CODE ',999);

3253: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE END 2');
3254: EXCEPTION
3255: WHEN others THEN
3256: IF g_debug THEN
3257: hr_utility.set_location('error raised in DEINITIALIZATION_CODE ',999);
3258: END if;
3259: RAISE;
3260: END;
3261: