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_EIN dependencies on HR_UTILITY

Line 4: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_DK_ARCHIVE_EIN AS
2: /* $Header: pydkeina.pkb 120.49.12020000.5 2012/12/18 12:40:40 rsahai ship $ */
3:
4: g_debug BOOLEAN := hr_utility.debug_enabled;
5: g_package VARCHAR2(33) := ' PAY_DK_ARCHIVE_EIN.';
6: g_payroll_action_id NUMBER ;
7: g_le_assignment_action_id NUMBER ;
8: g_business_group_id NUMBER;

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

102: l_proc VARCHAR2(40):= g_package||' get parameter ';
103: BEGIN
104: --
105: IF g_debug THEN
106: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
107: END IF;
108: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
109: --
110: IF l_start_pos = 0 THEN

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

128: END IF;
129: END IF;
130: --
131: IF g_debug THEN
132: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
133: END IF;
134:
135: RETURN l_parameter;
136:

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

186: ,p_effective_date
187: ,p_business_group_id;
188: CLOSE csr_parameter_info;
189: --
190: hr_utility.set_location(' get paramerters:p_start_date ' || p_start_date,30);
191: hr_utility.set_location(' get paramerters:p_end_date ' || p_end_date,30);
192: hr_utility.set_location(' get paramerters:p_payroll_type ' || p_payroll_type,30);
193: IF g_debug THEN
194: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);

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

187: ,p_business_group_id;
188: CLOSE csr_parameter_info;
189: --
190: hr_utility.set_location(' get paramerters:p_start_date ' || p_start_date,30);
191: hr_utility.set_location(' get paramerters:p_end_date ' || p_end_date,30);
192: hr_utility.set_location(' get paramerters:p_payroll_type ' || p_payroll_type,30);
193: IF g_debug THEN
194: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
195: END IF;

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

188: CLOSE csr_parameter_info;
189: --
190: hr_utility.set_location(' get paramerters:p_start_date ' || p_start_date,30);
191: hr_utility.set_location(' get paramerters:p_end_date ' || p_end_date,30);
192: hr_utility.set_location(' get paramerters:p_payroll_type ' || p_payroll_type,30);
193: IF g_debug THEN
194: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
195: END IF;
196:

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

190: hr_utility.set_location(' get paramerters:p_start_date ' || p_start_date,30);
191: hr_utility.set_location(' get paramerters:p_end_date ' || p_end_date,30);
192: hr_utility.set_location(' get paramerters:p_payroll_type ' || p_payroll_type,30);
193: IF g_debug THEN
194: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
195: END IF;
196:
197: END GET_ALL_PARAMETERS;
198:

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

314:
315: /* End of Cursors */
316: BEGIN
317:
318: hr_utility.set_location(' Entering Procedure RANGE_CODE',1);
319:
320: IF g_debug THEN
321: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
322: END IF;

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

317:
318: hr_utility.set_location(' Entering Procedure RANGE_CODE',1);
319:
320: IF g_debug THEN
321: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
322: END IF;
323:
324: 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';
325:

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

334: g_test_submission:=NULL;
335: g_company_terminating:=NULL;
336: g_sender_id:=NULL;
337:
338: hr_utility.set_location('RANGE_CODE:Before Calling all parameters',2);
339:
340: PAY_DK_ARCHIVE_EIN.GET_ALL_PARAMETERS(
341: p_payroll_action_id
342: ,l_business_group_id

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

350: ,g_test_submission
351: ,g_company_terminating
352: ,g_sender_id) ;
353:
354: hr_utility.set_location('RANGE_CODE:After Calling all parameters',2);
355:
356: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);
357: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);
358: SELECT count(*)

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

365: -- fnd_file.put_line(fnd_file.log,'Range Code 6');
366:
367: IF l_count < 1 then
368:
369: hr_utility.set_location('Entered Procedure GETDATA',10);
370:
371:
372: -- fnd_file.put_line(fnd_file.log,'g_legal_employer_id : '||g_legal_employer_id);
373: -- fnd_file.put_line(fnd_file.log,'l_business_group_id : '||l_business_group_id);

Line 562: hr_utility.set_location('RANGE_CODE: Before loop l_unique_id '|| l_unique_id,50);

558: /* Bug fix 7579265 */
559: /* 8861878 p_payroll_action_id */
560: -- l_unique_id:=l_unique_id||lpad(nvl(substr(g_payroll_id,-4),g_payroll_id),4,'0')||to_char(rg_csr_pay_periods.start_date,'mmyy');
561: l_unique_id:=lpad(substr(to_char(p_payroll_action_id), -least(length(p_payroll_action_id),8)),8,0);
562: hr_utility.set_location('RANGE_CODE: Before loop l_unique_id '|| l_unique_id,50);
563: FOR csr_rec in csr_le_payrolls /* 9489806 */
564: LOOP
565: l_unique_id1:=l_unique_id|| lpad( substr(to_char(csr_rec.TIME_PERIOD_ID),-least(length(csr_rec.TIME_PERIOD_ID),5)),5,0) || '00'||'0'; /* 5 digits of time period id 2 digits of employemtn code, 1 digit for correcctin record , */
566: if(g_company_terminating='N') then

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

662:
663: END IF;
664:
665: IF g_debug THEN
666: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
667: END IF;
668:
669: EXCEPTION
670: WHEN others THEN

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

668:
669: EXCEPTION
670: WHEN others THEN
671: IF g_debug THEN
672: hr_utility.set_location('error raised assignment_action_code ',5);
673: END if;
674: RAISE;
675: END RANGE_CODE;
676:

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

754: if(g_flag=0) then
755: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 1');
756:
757: IF g_debug THEN
758: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
759: END IF;
760:
761: PAY_DK_ARCHIVE_EIN.GET_ALL_PARAMETERS(
762: p_payroll_action_id

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

823: l_prev_assg_id := rec_prepaid_assignments.assignment_id;
824: END LOOP;
825:
826: IF g_debug THEN
827: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
828: END IF;
829: end if; -- end g_flag condition.
830:
831: EXCEPTION

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

830:
831: EXCEPTION
832: WHEN others THEN
833: IF g_debug THEN
834: hr_utility.set_location('error raised assignment_action_code ',5);
835: END if;
836: RAISE;
837: END ASSIGNMENT_ACTION_CODE;
838:

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

842: IS
843:
844: BEGIN
845: IF g_debug THEN
846: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
847: END IF;
848: -- fnd_file.put_line(fnd_file.log,'INITIALIZATION_CODE 1');
849: IF g_debug THEN
850: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);

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

846: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
847: END IF;
848: -- fnd_file.put_line(fnd_file.log,'INITIALIZATION_CODE 1');
849: IF g_debug THEN
850: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
851: END IF;
852:
853: EXCEPTION
854: WHEN others THEN

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

852:
853: EXCEPTION
854: WHEN others THEN
855: IF g_debug THEN
856: hr_utility.set_location('error raised initialization code ',5);
857: END if;
858: RAISE;
859: END INITIALIZATION_CODE;
860:

Line 1500: hr_utility.set_location(' Entered Procedure rec_5000',500);

1496: l_action_info_id NUMBER;
1497: l_ovn NUMBER;
1498: l_unique_id VARCHAR2(16);
1499: BEGIN
1500: hr_utility.set_location(' Entered Procedure rec_5000',500);
1501: hr_utility.set_location('rec_5000:p_payroll_action_id'|| p_payroll_action_id ,501);
1502: hr_utility.set_location('rec_5000:p_payroll_id'|| p_payroll_id ,501);
1503: hr_utility.set_location('rec_5000:p_employement_type'|| p_employement_type ,501);
1504: hr_utility.set_location('rec_5000:p_green_land_code'|| p_green_land_code ,501); /* 8847591 */

Line 1501: hr_utility.set_location('rec_5000:p_payroll_action_id'|| p_payroll_action_id ,501);

1497: l_ovn NUMBER;
1498: l_unique_id VARCHAR2(16);
1499: BEGIN
1500: hr_utility.set_location(' Entered Procedure rec_5000',500);
1501: hr_utility.set_location('rec_5000:p_payroll_action_id'|| p_payroll_action_id ,501);
1502: hr_utility.set_location('rec_5000:p_payroll_id'|| p_payroll_id ,501);
1503: hr_utility.set_location('rec_5000:p_employement_type'|| p_employement_type ,501);
1504: hr_utility.set_location('rec_5000:p_green_land_code'|| p_green_land_code ,501); /* 8847591 */
1505: OPEN csr_chk_5000_emp;

Line 1502: hr_utility.set_location('rec_5000:p_payroll_id'|| p_payroll_id ,501);

1498: l_unique_id VARCHAR2(16);
1499: BEGIN
1500: hr_utility.set_location(' Entered Procedure rec_5000',500);
1501: hr_utility.set_location('rec_5000:p_payroll_action_id'|| p_payroll_action_id ,501);
1502: hr_utility.set_location('rec_5000:p_payroll_id'|| p_payroll_id ,501);
1503: hr_utility.set_location('rec_5000:p_employement_type'|| p_employement_type ,501);
1504: hr_utility.set_location('rec_5000:p_green_land_code'|| p_green_land_code ,501); /* 8847591 */
1505: OPEN csr_chk_5000_emp;
1506: FETCH csr_chk_5000_emp into l_flag;

Line 1503: hr_utility.set_location('rec_5000:p_employement_type'|| p_employement_type ,501);

1499: BEGIN
1500: hr_utility.set_location(' Entered Procedure rec_5000',500);
1501: hr_utility.set_location('rec_5000:p_payroll_action_id'|| p_payroll_action_id ,501);
1502: hr_utility.set_location('rec_5000:p_payroll_id'|| p_payroll_id ,501);
1503: hr_utility.set_location('rec_5000:p_employement_type'|| p_employement_type ,501);
1504: hr_utility.set_location('rec_5000:p_green_land_code'|| p_green_land_code ,501); /* 8847591 */
1505: OPEN csr_chk_5000_emp;
1506: FETCH csr_chk_5000_emp into l_flag;
1507: CLOSE csr_chk_5000_emp;

Line 1504: hr_utility.set_location('rec_5000:p_green_land_code'|| p_green_land_code ,501); /* 8847591 */

1500: hr_utility.set_location(' Entered Procedure rec_5000',500);
1501: hr_utility.set_location('rec_5000:p_payroll_action_id'|| p_payroll_action_id ,501);
1502: hr_utility.set_location('rec_5000:p_payroll_id'|| p_payroll_id ,501);
1503: hr_utility.set_location('rec_5000:p_employement_type'|| p_employement_type ,501);
1504: hr_utility.set_location('rec_5000:p_green_land_code'|| p_green_land_code ,501); /* 8847591 */
1505: OPEN csr_chk_5000_emp;
1506: FETCH csr_chk_5000_emp into l_flag;
1507: CLOSE csr_chk_5000_emp;
1508: hr_utility.set_location('rec_5000:After fetch l_flag'|| l_flag ,501);

Line 1508: hr_utility.set_location('rec_5000:After fetch l_flag'|| l_flag ,501);

1504: hr_utility.set_location('rec_5000:p_green_land_code'|| p_green_land_code ,501); /* 8847591 */
1505: OPEN csr_chk_5000_emp;
1506: FETCH csr_chk_5000_emp into l_flag;
1507: CLOSE csr_chk_5000_emp;
1508: hr_utility.set_location('rec_5000:After fetch l_flag'|| l_flag ,501);
1509:
1510: IF l_flag<>1 THEN
1511: hr_utility.set_location('rec_5000:Entered l_flag IF'|| l_flag ,501);
1512: OPEN csr_chk_5000;

Line 1511: hr_utility.set_location('rec_5000:Entered l_flag IF'|| l_flag ,501);

1507: CLOSE csr_chk_5000_emp;
1508: hr_utility.set_location('rec_5000:After fetch l_flag'|| l_flag ,501);
1509:
1510: IF l_flag<>1 THEN
1511: hr_utility.set_location('rec_5000:Entered l_flag IF'|| l_flag ,501);
1512: OPEN csr_chk_5000;
1513: FETCH csr_chk_5000 INTO rec_csr_chk_5000;
1514: CLOSE csr_chk_5000;
1515: IF p_green_land_code='000' THEN /* 8847591 */

Line 1561: hr_utility.set_location('rec_5000:Last statement l_flag IF'|| l_flag ,501);

1557: ,p_action_information27 => null
1558: ,p_action_information28 => null
1559: ,p_action_information29 => null
1560: ,p_action_information30 => null);
1561: hr_utility.set_location('rec_5000:Last statement l_flag IF'|| l_flag ,501);
1562:
1563:
1564: END IF;
1565: hr_utility.set_location(' Leaving Procedure rec_5000',500);

Line 1565: hr_utility.set_location(' Leaving Procedure rec_5000',500);

1561: hr_utility.set_location('rec_5000:Last statement l_flag IF'|| l_flag ,501);
1562:
1563:
1564: END IF;
1565: hr_utility.set_location(' Leaving Procedure rec_5000',500);
1566:
1567: END;
1568:
1569: PROCEDURE rec_5000R(

Line 1607: hr_utility.set_location(' Entered Procedure rec_5000R',500);

1603: l_action_info_id NUMBER;
1604: l_ovn NUMBER;
1605: l_unique_id VARCHAR2(16);
1606: BEGIN
1607: hr_utility.set_location(' Entered Procedure rec_5000R',500);
1608: hr_utility.set_location('rec_5000R:p_payroll_action_id'|| p_payroll_action_id ,501);
1609: hr_utility.set_location('rec_5000R:p_payroll_id'|| p_payroll_id ,501);
1610: hr_utility.set_location('rec_5000R:p_employement_type'|| p_employement_type ,501);
1611: hr_utility.set_location('rec_5000R:p_green_land_code'|| p_green_land_code ,501); /* 8847591 */

Line 1608: hr_utility.set_location('rec_5000R:p_payroll_action_id'|| p_payroll_action_id ,501);

1604: l_ovn NUMBER;
1605: l_unique_id VARCHAR2(16);
1606: BEGIN
1607: hr_utility.set_location(' Entered Procedure rec_5000R',500);
1608: hr_utility.set_location('rec_5000R:p_payroll_action_id'|| p_payroll_action_id ,501);
1609: hr_utility.set_location('rec_5000R:p_payroll_id'|| p_payroll_id ,501);
1610: hr_utility.set_location('rec_5000R:p_employement_type'|| p_employement_type ,501);
1611: hr_utility.set_location('rec_5000R:p_green_land_code'|| p_green_land_code ,501); /* 8847591 */
1612: OPEN csr_chk_5000_emp;

Line 1609: hr_utility.set_location('rec_5000R:p_payroll_id'|| p_payroll_id ,501);

1605: l_unique_id VARCHAR2(16);
1606: BEGIN
1607: hr_utility.set_location(' Entered Procedure rec_5000R',500);
1608: hr_utility.set_location('rec_5000R:p_payroll_action_id'|| p_payroll_action_id ,501);
1609: hr_utility.set_location('rec_5000R:p_payroll_id'|| p_payroll_id ,501);
1610: hr_utility.set_location('rec_5000R:p_employement_type'|| p_employement_type ,501);
1611: hr_utility.set_location('rec_5000R:p_green_land_code'|| p_green_land_code ,501); /* 8847591 */
1612: OPEN csr_chk_5000_emp;
1613: FETCH csr_chk_5000_emp into l_flag;

Line 1610: hr_utility.set_location('rec_5000R:p_employement_type'|| p_employement_type ,501);

1606: BEGIN
1607: hr_utility.set_location(' Entered Procedure rec_5000R',500);
1608: hr_utility.set_location('rec_5000R:p_payroll_action_id'|| p_payroll_action_id ,501);
1609: hr_utility.set_location('rec_5000R:p_payroll_id'|| p_payroll_id ,501);
1610: hr_utility.set_location('rec_5000R:p_employement_type'|| p_employement_type ,501);
1611: hr_utility.set_location('rec_5000R:p_green_land_code'|| p_green_land_code ,501); /* 8847591 */
1612: OPEN csr_chk_5000_emp;
1613: FETCH csr_chk_5000_emp into l_flag;
1614: CLOSE csr_chk_5000_emp;

Line 1611: hr_utility.set_location('rec_5000R:p_green_land_code'|| p_green_land_code ,501); /* 8847591 */

1607: hr_utility.set_location(' Entered Procedure rec_5000R',500);
1608: hr_utility.set_location('rec_5000R:p_payroll_action_id'|| p_payroll_action_id ,501);
1609: hr_utility.set_location('rec_5000R:p_payroll_id'|| p_payroll_id ,501);
1610: hr_utility.set_location('rec_5000R:p_employement_type'|| p_employement_type ,501);
1611: hr_utility.set_location('rec_5000R:p_green_land_code'|| p_green_land_code ,501); /* 8847591 */
1612: OPEN csr_chk_5000_emp;
1613: FETCH csr_chk_5000_emp into l_flag;
1614: CLOSE csr_chk_5000_emp;
1615: hr_utility.set_location('rec_5000R:After fetch l_flag'|| l_flag ,501);

Line 1615: hr_utility.set_location('rec_5000R:After fetch l_flag'|| l_flag ,501);

1611: hr_utility.set_location('rec_5000R:p_green_land_code'|| p_green_land_code ,501); /* 8847591 */
1612: OPEN csr_chk_5000_emp;
1613: FETCH csr_chk_5000_emp into l_flag;
1614: CLOSE csr_chk_5000_emp;
1615: hr_utility.set_location('rec_5000R:After fetch l_flag'|| l_flag ,501);
1616:
1617: IF l_flag<>1 THEN
1618: hr_utility.set_location('rec_5000:Entered l_flag IF'|| l_flag ,501);
1619: OPEN csr_chk_5000;

Line 1618: hr_utility.set_location('rec_5000:Entered l_flag IF'|| l_flag ,501);

1614: CLOSE csr_chk_5000_emp;
1615: hr_utility.set_location('rec_5000R:After fetch l_flag'|| l_flag ,501);
1616:
1617: IF l_flag<>1 THEN
1618: hr_utility.set_location('rec_5000:Entered l_flag IF'|| l_flag ,501);
1619: OPEN csr_chk_5000;
1620: FETCH csr_chk_5000 INTO rec_csr_chk_5000;
1621: CLOSE csr_chk_5000;
1622: IF p_green_land_code='000' THEN /* 8847591 */

Line 1668: hr_utility.set_location('rec_5000R:Last statement l_flag IF'|| l_flag ,501);

1664: ,p_action_information27 => null
1665: ,p_action_information28 => null
1666: ,p_action_information29 => null
1667: ,p_action_information30 => null);
1668: hr_utility.set_location('rec_5000R:Last statement l_flag IF'|| l_flag ,501);
1669:
1670:
1671: END IF;
1672: hr_utility.set_location(' Leaving Procedure rec_5000R',500);

Line 1672: hr_utility.set_location(' Leaving Procedure rec_5000R',500);

1668: hr_utility.set_location('rec_5000R:Last statement l_flag IF'|| l_flag ,501);
1669:
1670:
1671: END IF;
1672: hr_utility.set_location(' Leaving Procedure rec_5000R',500);
1673:
1674: END;
1675: PROCEDURE rec_6000R(
1676: p_assignment_action_id NUMBER

Line 1712: hr_utility.set_location(' Entered Procedure rec_6000R',500);

1708: l_flag NUMBER:=0;
1709: l_action_info_id NUMBER;
1710: l_ovn NUMBER;
1711: BEGIN
1712: hr_utility.set_location(' Entered Procedure rec_6000R',500);
1713: hr_utility.set_location('rec_6000R:p_assignment_action_id'|| p_assignment_action_id ,501);
1714: hr_utility.set_location('rec_6000R:p_payroll_id'|| p_payroll_id ,501);
1715: hr_utility.set_location('rec_6000R:p_employement_type'|| p_employement_type ,501);
1716: hr_utility.set_location('rec_6000R:p_green_land_code'|| p_green_land_code ,501);

Line 1713: hr_utility.set_location('rec_6000R:p_assignment_action_id'|| p_assignment_action_id ,501);

1709: l_action_info_id NUMBER;
1710: l_ovn NUMBER;
1711: BEGIN
1712: hr_utility.set_location(' Entered Procedure rec_6000R',500);
1713: hr_utility.set_location('rec_6000R:p_assignment_action_id'|| p_assignment_action_id ,501);
1714: hr_utility.set_location('rec_6000R:p_payroll_id'|| p_payroll_id ,501);
1715: hr_utility.set_location('rec_6000R:p_employement_type'|| p_employement_type ,501);
1716: hr_utility.set_location('rec_6000R:p_green_land_code'|| p_green_land_code ,501);
1717: OPEN csr_chk_6000_emp;

Line 1714: hr_utility.set_location('rec_6000R:p_payroll_id'|| p_payroll_id ,501);

1710: l_ovn NUMBER;
1711: BEGIN
1712: hr_utility.set_location(' Entered Procedure rec_6000R',500);
1713: hr_utility.set_location('rec_6000R:p_assignment_action_id'|| p_assignment_action_id ,501);
1714: hr_utility.set_location('rec_6000R:p_payroll_id'|| p_payroll_id ,501);
1715: hr_utility.set_location('rec_6000R:p_employement_type'|| p_employement_type ,501);
1716: hr_utility.set_location('rec_6000R:p_green_land_code'|| p_green_land_code ,501);
1717: OPEN csr_chk_6000_emp;
1718: FETCH csr_chk_6000_emp into l_flag;

Line 1715: hr_utility.set_location('rec_6000R:p_employement_type'|| p_employement_type ,501);

1711: BEGIN
1712: hr_utility.set_location(' Entered Procedure rec_6000R',500);
1713: hr_utility.set_location('rec_6000R:p_assignment_action_id'|| p_assignment_action_id ,501);
1714: hr_utility.set_location('rec_6000R:p_payroll_id'|| p_payroll_id ,501);
1715: hr_utility.set_location('rec_6000R:p_employement_type'|| p_employement_type ,501);
1716: hr_utility.set_location('rec_6000R:p_green_land_code'|| p_green_land_code ,501);
1717: OPEN csr_chk_6000_emp;
1718: FETCH csr_chk_6000_emp into l_flag;
1719: CLOSE csr_chk_6000_emp;

Line 1716: hr_utility.set_location('rec_6000R:p_green_land_code'|| p_green_land_code ,501);

1712: hr_utility.set_location(' Entered Procedure rec_6000R',500);
1713: hr_utility.set_location('rec_6000R:p_assignment_action_id'|| p_assignment_action_id ,501);
1714: hr_utility.set_location('rec_6000R:p_payroll_id'|| p_payroll_id ,501);
1715: hr_utility.set_location('rec_6000R:p_employement_type'|| p_employement_type ,501);
1716: hr_utility.set_location('rec_6000R:p_green_land_code'|| p_green_land_code ,501);
1717: OPEN csr_chk_6000_emp;
1718: FETCH csr_chk_6000_emp into l_flag;
1719: CLOSE csr_chk_6000_emp;
1720: hr_utility.set_location('rec_6000R:After fetch l_flag'|| l_flag ,501);

Line 1720: hr_utility.set_location('rec_6000R:After fetch l_flag'|| l_flag ,501);

1716: hr_utility.set_location('rec_6000R:p_green_land_code'|| p_green_land_code ,501);
1717: OPEN csr_chk_6000_emp;
1718: FETCH csr_chk_6000_emp into l_flag;
1719: CLOSE csr_chk_6000_emp;
1720: hr_utility.set_location('rec_6000R:After fetch l_flag'|| l_flag ,501);
1721:
1722: IF l_flag<>1 THEN
1723: hr_utility.set_location('rec_6000:Entered l_flag IF'|| l_flag ,501);
1724: OPEN csr_chk_6000;

Line 1723: hr_utility.set_location('rec_6000:Entered l_flag IF'|| l_flag ,501);

1719: CLOSE csr_chk_6000_emp;
1720: hr_utility.set_location('rec_6000R:After fetch l_flag'|| l_flag ,501);
1721:
1722: IF l_flag<>1 THEN
1723: hr_utility.set_location('rec_6000:Entered l_flag IF'|| l_flag ,501);
1724: OPEN csr_chk_6000;
1725: FETCH csr_chk_6000 INTO rec_csr_chk_6000;
1726: CLOSE csr_chk_6000;
1727: pay_action_information_api.create_action_information (

Line 1766: hr_utility.set_location('rec_6000R:Last statement l_flag IF'|| l_flag ,501);

1762: ,p_action_information27 => p_green_land_code /* 8847591 */
1763: ,p_action_information28 => null
1764: ,p_action_information29 => null
1765: ,p_action_information30 => null);
1766: hr_utility.set_location('rec_6000R:Last statement l_flag IF'|| l_flag ,501);
1767:
1768:
1769: END IF;
1770: hr_utility.set_location(' Leaving Procedure rec_6000R',500);

Line 1770: hr_utility.set_location(' Leaving Procedure rec_6000R',500);

1766: hr_utility.set_location('rec_6000R:Last statement l_flag IF'|| l_flag ,501);
1767:
1768:
1769: END IF;
1770: hr_utility.set_location(' Leaving Procedure rec_6000R',500);
1771:
1772: END;
1773: PROCEDURE rec_8001R(
1774: p_assignment_action_id NUMBER

Line 1810: hr_utility.set_location(' Entered Procedure rec_8001R',500);

1806: l_flag NUMBER:=0;
1807: l_action_info_id NUMBER;
1808: l_ovn NUMBER;
1809: BEGIN
1810: hr_utility.set_location(' Entered Procedure rec_8001R',500);
1811: hr_utility.set_location('rec_8001R:p_assignment_action_id'|| p_assignment_action_id ,501);
1812: hr_utility.set_location('rec_8001R:p_payroll_id'|| p_payroll_id ,501);
1813: hr_utility.set_location('rec_8001R:p_employement_type'|| p_employement_type ,501);
1814: hr_utility.set_location('rec_8001R:p_green_land_code'|| p_green_land_code ,501);

Line 1811: hr_utility.set_location('rec_8001R:p_assignment_action_id'|| p_assignment_action_id ,501);

1807: l_action_info_id NUMBER;
1808: l_ovn NUMBER;
1809: BEGIN
1810: hr_utility.set_location(' Entered Procedure rec_8001R',500);
1811: hr_utility.set_location('rec_8001R:p_assignment_action_id'|| p_assignment_action_id ,501);
1812: hr_utility.set_location('rec_8001R:p_payroll_id'|| p_payroll_id ,501);
1813: hr_utility.set_location('rec_8001R:p_employement_type'|| p_employement_type ,501);
1814: hr_utility.set_location('rec_8001R:p_green_land_code'|| p_green_land_code ,501);
1815: OPEN csr_chk_8001_emp;

Line 1812: hr_utility.set_location('rec_8001R:p_payroll_id'|| p_payroll_id ,501);

1808: l_ovn NUMBER;
1809: BEGIN
1810: hr_utility.set_location(' Entered Procedure rec_8001R',500);
1811: hr_utility.set_location('rec_8001R:p_assignment_action_id'|| p_assignment_action_id ,501);
1812: hr_utility.set_location('rec_8001R:p_payroll_id'|| p_payroll_id ,501);
1813: hr_utility.set_location('rec_8001R:p_employement_type'|| p_employement_type ,501);
1814: hr_utility.set_location('rec_8001R:p_green_land_code'|| p_green_land_code ,501);
1815: OPEN csr_chk_8001_emp;
1816: FETCH csr_chk_8001_emp into l_flag;

Line 1813: hr_utility.set_location('rec_8001R:p_employement_type'|| p_employement_type ,501);

1809: BEGIN
1810: hr_utility.set_location(' Entered Procedure rec_8001R',500);
1811: hr_utility.set_location('rec_8001R:p_assignment_action_id'|| p_assignment_action_id ,501);
1812: hr_utility.set_location('rec_8001R:p_payroll_id'|| p_payroll_id ,501);
1813: hr_utility.set_location('rec_8001R:p_employement_type'|| p_employement_type ,501);
1814: hr_utility.set_location('rec_8001R:p_green_land_code'|| p_green_land_code ,501);
1815: OPEN csr_chk_8001_emp;
1816: FETCH csr_chk_8001_emp into l_flag;
1817: CLOSE csr_chk_8001_emp;

Line 1814: hr_utility.set_location('rec_8001R:p_green_land_code'|| p_green_land_code ,501);

1810: hr_utility.set_location(' Entered Procedure rec_8001R',500);
1811: hr_utility.set_location('rec_8001R:p_assignment_action_id'|| p_assignment_action_id ,501);
1812: hr_utility.set_location('rec_8001R:p_payroll_id'|| p_payroll_id ,501);
1813: hr_utility.set_location('rec_8001R:p_employement_type'|| p_employement_type ,501);
1814: hr_utility.set_location('rec_8001R:p_green_land_code'|| p_green_land_code ,501);
1815: OPEN csr_chk_8001_emp;
1816: FETCH csr_chk_8001_emp into l_flag;
1817: CLOSE csr_chk_8001_emp;
1818: hr_utility.set_location('rec_8001R:After fetch l_flag'|| l_flag ,501);

Line 1818: hr_utility.set_location('rec_8001R:After fetch l_flag'|| l_flag ,501);

1814: hr_utility.set_location('rec_8001R:p_green_land_code'|| p_green_land_code ,501);
1815: OPEN csr_chk_8001_emp;
1816: FETCH csr_chk_8001_emp into l_flag;
1817: CLOSE csr_chk_8001_emp;
1818: hr_utility.set_location('rec_8001R:After fetch l_flag'|| l_flag ,501);
1819:
1820: IF l_flag<>1 THEN
1821: hr_utility.set_location('rec_8001:Entered l_flag IF'|| l_flag ,501);
1822: OPEN csr_chk_8001;

Line 1821: hr_utility.set_location('rec_8001:Entered l_flag IF'|| l_flag ,501);

1817: CLOSE csr_chk_8001_emp;
1818: hr_utility.set_location('rec_8001R:After fetch l_flag'|| l_flag ,501);
1819:
1820: IF l_flag<>1 THEN
1821: hr_utility.set_location('rec_8001:Entered l_flag IF'|| l_flag ,501);
1822: OPEN csr_chk_8001;
1823: FETCH csr_chk_8001 INTO rec_csr_chk_8001;
1824: CLOSE csr_chk_8001;
1825: pay_action_information_api.create_action_information (

Line 1864: hr_utility.set_location('rec_8001R:Last statement l_flag IF'|| l_flag ,501);

1860: ,p_action_information27 => p_green_land_code /* 8847591 */
1861: ,p_action_information28 => null
1862: ,p_action_information29 => null
1863: ,p_action_information30 => null);
1864: hr_utility.set_location('rec_8001R:Last statement l_flag IF'|| l_flag ,501);
1865:
1866:
1867: END IF;
1868: hr_utility.set_location(' Leaving Procedure rec_8001R',500);

Line 1868: hr_utility.set_location(' Leaving Procedure rec_8001R',500);

1864: hr_utility.set_location('rec_8001R:Last statement l_flag IF'|| l_flag ,501);
1865:
1866:
1867: END IF;
1868: hr_utility.set_location(' Leaving Procedure rec_8001R',500);
1869:
1870: END;
1871:
1872:

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

1935: WHERE assignment_action_id=p_assignment_action_id;
1936: END;
1937:
1938: IF g_debug THEN
1939: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
1940: END IF;
1941:
1942: /* Fetching report parameters */
1943: PAY_DK_ARCHIVE_EIN.GET_ALL_PARAMETERS(

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

1973: if(g_company_terminating='N') then
1974:
1975: fnd_file.put_line(fnd_file.log,'Fetched report parameters');
1976:
1977: hr_utility.set_location('ARCHIVE_CODE: l_assignment_id '|| l_ass_id,380);
1978: hr_utility.set_location('ARCHIVE_CODE: Before For loop csr_asg_payroll ',380);
1979:
1980: For csr_asg_payroll_rec IN csr_asg_payroll(l_canonical_start_date,l_canonical_end_date,l_ass_id)
1981: LOOP

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

1974:
1975: fnd_file.put_line(fnd_file.log,'Fetched report parameters');
1976:
1977: hr_utility.set_location('ARCHIVE_CODE: l_assignment_id '|| l_ass_id,380);
1978: hr_utility.set_location('ARCHIVE_CODE: Before For loop csr_asg_payroll ',380);
1979:
1980: For csr_asg_payroll_rec IN csr_asg_payroll(l_canonical_start_date,l_canonical_end_date,l_ass_id)
1981: LOOP
1982: --FETCH csr_asg_payroll INTO l_payroll_id,l_period_id;

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

1980: For csr_asg_payroll_rec IN csr_asg_payroll(l_canonical_start_date,l_canonical_end_date,l_ass_id)
1981: LOOP
1982: --FETCH csr_asg_payroll INTO l_payroll_id,l_period_id;
1983: --CLOSE csr_asg_payroll;
1984: hr_utility.set_location('ARCHIVE_CODE: Payroll Name ' || csr_asg_payroll_rec.payroll_name,380);
1985: hr_utility.set_location('ARCHIVE_CODE: l_payroll_id ' || csr_asg_payroll_rec.payroll_id,380);
1986: hr_utility.set_location('ARCHIVE_CODE: Period Name ' || csr_asg_payroll_rec.period_name,380);
1987: hr_utility.set_location('ARCHIVE_CODE: time_period_id ' || csr_asg_payroll_rec.time_period_id,380);
1988: l_employment_type :='00';

Line 1985: hr_utility.set_location('ARCHIVE_CODE: l_payroll_id ' || csr_asg_payroll_rec.payroll_id,380);

1981: LOOP
1982: --FETCH csr_asg_payroll INTO l_payroll_id,l_period_id;
1983: --CLOSE csr_asg_payroll;
1984: hr_utility.set_location('ARCHIVE_CODE: Payroll Name ' || csr_asg_payroll_rec.payroll_name,380);
1985: hr_utility.set_location('ARCHIVE_CODE: l_payroll_id ' || csr_asg_payroll_rec.payroll_id,380);
1986: hr_utility.set_location('ARCHIVE_CODE: Period Name ' || csr_asg_payroll_rec.period_name,380);
1987: hr_utility.set_location('ARCHIVE_CODE: time_period_id ' || csr_asg_payroll_rec.time_period_id,380);
1988: l_employment_type :='00';
1989: l_green_land_code :='000';

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

1982: --FETCH csr_asg_payroll INTO l_payroll_id,l_period_id;
1983: --CLOSE csr_asg_payroll;
1984: hr_utility.set_location('ARCHIVE_CODE: Payroll Name ' || csr_asg_payroll_rec.payroll_name,380);
1985: hr_utility.set_location('ARCHIVE_CODE: l_payroll_id ' || csr_asg_payroll_rec.payroll_id,380);
1986: hr_utility.set_location('ARCHIVE_CODE: Period Name ' || csr_asg_payroll_rec.period_name,380);
1987: hr_utility.set_location('ARCHIVE_CODE: time_period_id ' || csr_asg_payroll_rec.time_period_id,380);
1988: l_employment_type :='00';
1989: l_green_land_code :='000';
1990: l_payroll_id:= csr_asg_payroll_rec.payroll_id;

Line 1987: hr_utility.set_location('ARCHIVE_CODE: time_period_id ' || csr_asg_payroll_rec.time_period_id,380);

1983: --CLOSE csr_asg_payroll;
1984: hr_utility.set_location('ARCHIVE_CODE: Payroll Name ' || csr_asg_payroll_rec.payroll_name,380);
1985: hr_utility.set_location('ARCHIVE_CODE: l_payroll_id ' || csr_asg_payroll_rec.payroll_id,380);
1986: hr_utility.set_location('ARCHIVE_CODE: Period Name ' || csr_asg_payroll_rec.period_name,380);
1987: hr_utility.set_location('ARCHIVE_CODE: time_period_id ' || csr_asg_payroll_rec.time_period_id,380);
1988: l_employment_type :='00';
1989: l_green_land_code :='000';
1990: l_payroll_id:= csr_asg_payroll_rec.payroll_id;
1991: l_period_id:= csr_asg_payroll_rec.time_period_id;

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

1989: l_green_land_code :='000';
1990: l_payroll_id:= csr_asg_payroll_rec.payroll_id;
1991: l_period_id:= csr_asg_payroll_rec.time_period_id;
1992:
1993: hr_utility.set_location('ARCHIVE_CODE:After assign l_payroll_id ' || l_payroll_id,380);
1994: hr_utility.set_location('ARCHIVE_CODE:After assign l_period_id ' || l_period_id,380);
1995: hr_utility.set_location('ARCHIVE_CODE:p_effective_date ' || p_effective_date,380);
1996:
1997: OPEN csr_pay_periods(l_payroll_id,l_period_id);

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

1990: l_payroll_id:= csr_asg_payroll_rec.payroll_id;
1991: l_period_id:= csr_asg_payroll_rec.time_period_id;
1992:
1993: hr_utility.set_location('ARCHIVE_CODE:After assign l_payroll_id ' || l_payroll_id,380);
1994: hr_utility.set_location('ARCHIVE_CODE:After assign l_period_id ' || l_period_id,380);
1995: hr_utility.set_location('ARCHIVE_CODE:p_effective_date ' || p_effective_date,380);
1996:
1997: OPEN csr_pay_periods(l_payroll_id,l_period_id);
1998: FETCH csr_pay_periods into rg_csr_pay_periods;

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

1991: l_period_id:= csr_asg_payroll_rec.time_period_id;
1992:
1993: hr_utility.set_location('ARCHIVE_CODE:After assign l_payroll_id ' || l_payroll_id,380);
1994: hr_utility.set_location('ARCHIVE_CODE:After assign l_period_id ' || l_period_id,380);
1995: hr_utility.set_location('ARCHIVE_CODE:p_effective_date ' || p_effective_date,380);
1996:
1997: OPEN csr_pay_periods(l_payroll_id,l_period_id);
1998: FETCH csr_pay_periods into rg_csr_pay_periods;
1999: l_bal_date:= rg_csr_pay_periods.end_date;

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

2000: CLOSE csr_pay_periods;
2001: l_start_date:=rg_csr_pay_periods.start_date;
2002: l_end_date:=rg_csr_pay_periods.end_date;
2003:
2004: hr_utility.set_location('ARCHIVE_CODE: l_bal_date ' || l_bal_date,380);
2005: hr_utility.set_location('ARCHIVE_CODE: l_start_date ' || l_start_date,380);
2006: hr_utility.set_location('ARCHIVE_CODE: l_end_date ' || l_end_date,380);
2007:
2008:

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

2001: l_start_date:=rg_csr_pay_periods.start_date;
2002: l_end_date:=rg_csr_pay_periods.end_date;
2003:
2004: hr_utility.set_location('ARCHIVE_CODE: l_bal_date ' || l_bal_date,380);
2005: hr_utility.set_location('ARCHIVE_CODE: l_start_date ' || l_start_date,380);
2006: hr_utility.set_location('ARCHIVE_CODE: l_end_date ' || l_end_date,380);
2007:
2008:
2009: OPEN csr_get_person_details(p_assignment_action_id, l_end_date ); -- p_effective_date 9489806

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

2002: l_end_date:=rg_csr_pay_periods.end_date;
2003:
2004: hr_utility.set_location('ARCHIVE_CODE: l_bal_date ' || l_bal_date,380);
2005: hr_utility.set_location('ARCHIVE_CODE: l_start_date ' || l_start_date,380);
2006: hr_utility.set_location('ARCHIVE_CODE: l_end_date ' || l_end_date,380);
2007:
2008:
2009: OPEN csr_get_person_details(p_assignment_action_id, l_end_date ); -- p_effective_date 9489806
2010: FETCH csr_get_person_details into rg_csr_get_person_details;

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

2077: else
2078: l_tax_card_type:='2';
2079: end if;
2080: l_present_flag:=0;
2081: hr_utility.set_location('ARCHIVE_CODE:Before fetch l_present_flag: ' || l_present_flag,380);
2082: OPEN csr_prepaid_actions_present(l_payroll_action_id,
2083: g_legal_employer_id,
2084: l_payroll_id,
2085: l_period_id,

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

2087: l_end_date,
2088: l_ass_id);
2089: FETCH csr_prepaid_actions_present INTO l_present_flag;
2090: CLOSE csr_prepaid_actions_present;
2091: hr_utility.set_location('ARCHIVE_CODE:After fetch l_present_flag: ' || l_present_flag,380);
2092: IF (l_present_flag=1) THEN
2093: -- Comment For Bug 9011035
2094: /* OPEN csr_latest_hire_date(rg_csr_get_person_details.person_id, l_end_date);
2095: FETCH csr_latest_hire_date into rg_csr_latest_hire_date;

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

3816: end if; -- g_flag
3817:
3818: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 16');
3819: IF g_debug THEN
3820: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
3821: END IF;
3822:
3823: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE END');
3824:

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

3824:
3825: EXCEPTION
3826: WHEN others THEN
3827: IF g_debug THEN
3828: hr_utility.set_location('error raised in archive code ',5);
3829: END if;
3830: RAISE;
3831: END ARCHIVE_CODE;
3832:

Line 4007: hr_utility.set_location('DEINIT:rg_csr_all_rec.action_information3: ' || rg_csr_all_rec_2001.action_information3,390);

4003:
4004: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 3');
4005: fnd_file.put_line(fnd_file.log,'payroll action id:'||p_payroll_action_id);
4006: fnd_file.put_line(fnd_file.log,'action info 4:'||rg_csr_all_rec_2001.action_information4);
4007: hr_utility.set_location('DEINIT:rg_csr_all_rec.action_information3: ' || rg_csr_all_rec_2001.action_information3,390);
4008: hr_utility.set_location('DEINIT:rg_csr_all_rec.action_information25: ' || rg_csr_all_rec_2001.action_information25,390);
4009: IF rg_csr_all_rec_2001.action_information3='2001' THEN
4010: l_end_code:=l_end_code + 1 ;
4011: UPDATE pay_action_information pai

Line 4008: hr_utility.set_location('DEINIT:rg_csr_all_rec.action_information25: ' || rg_csr_all_rec_2001.action_information25,390);

4004: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 3');
4005: fnd_file.put_line(fnd_file.log,'payroll action id:'||p_payroll_action_id);
4006: fnd_file.put_line(fnd_file.log,'action info 4:'||rg_csr_all_rec_2001.action_information4);
4007: hr_utility.set_location('DEINIT:rg_csr_all_rec.action_information3: ' || rg_csr_all_rec_2001.action_information3,390);
4008: hr_utility.set_location('DEINIT:rg_csr_all_rec.action_information25: ' || rg_csr_all_rec_2001.action_information25,390);
4009: IF rg_csr_all_rec_2001.action_information3='2001' THEN
4010: l_end_code:=l_end_code + 1 ;
4011: UPDATE pay_action_information pai
4012: SET pai.action_information30 =LPAD(l_end_code,7,'0')

Line 4043: hr_utility.set_location('DEINIT:entered csr_all_rec_6000: ' || rg_csr_all_rec_6000.action_information4,390);

4039: l_end_code:=l_end_code + 1 ;
4040: UPDATE pay_action_information pai
4041: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4042: WHERE CURRENT OF csr_all_rec_6000;
4043: hr_utility.set_location('DEINIT:entered csr_all_rec_6000: ' || rg_csr_all_rec_6000.action_information4,390);
4044: /* bug 7613211 start*/
4045: /* 9001660 */
4046: l_6000_count:=l_6000_count+1;
4047: fnd_file.put_line(fnd_file.log,'l_foreign_flag :'|| l_foreign_flag);

Line 4241: hr_utility.set_location(' Leaving Procedure DEINITIALIZATION_CODE',390);

4237:
4238: end if; -- g_flag
4239: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 7');
4240: IF g_debug THEN
4241: hr_utility.set_location(' Leaving Procedure DEINITIALIZATION_CODE',390);
4242: END IF;
4243:
4244: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 8');
4245: EXCEPTION

Line 4255: hr_utility.set_location('error raised in DEINITIALIZATION_CODE ',5);

4251: fnd_file.put_line(fnd_file.log,'Error raised in DEINITIALIZATION_CODE :'|| fnd_message.get_string('PER','HR_377071_DK_FORIEGN_BINCOME'));
4252: RAISE;
4253: WHEN others THEN
4254: IF g_debug THEN
4255: hr_utility.set_location('error raised in DEINITIALIZATION_CODE ',5);
4256: END if;
4257: RAISE;
4258: END;
4259: