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

Line 3: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_FI_ARCHIVE_PYSA AS
2: /* $Header: pyfipysa.pkb 120.7.12000000.2 2007/07/07 07:02:03 dbehera noship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4: TYPE element_rec IS RECORD (
5: classification_name VARCHAR2(60)
6: ,element_name VARCHAR2(60)
7: ,element_type_id NUMBER

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

52: l_proc VARCHAR2(40):= g_package||' get parameter ';
53: BEGIN
54: --
55: IF g_debug THEN
56: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
57: END IF;
58: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
59: --
60: IF l_start_pos = 0 THEN

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

78: END IF;
79: --
80: RETURN l_parameter;
81: IF g_debug THEN
82: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
83: END IF;
84: END;
85: /* GET ALL PARAMETERS */
86: PROCEDURE GET_ALL_PARAMETERS(

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

113: ,p_business_group_id;
114: CLOSE csr_parameter_info;
115: --
116: IF g_debug THEN
117: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
118: END IF;
119: END GET_ALL_PARAMETERS;
120: /* RANGE CODE */
121: PROCEDURE RANGE_CODE (p_payroll_action_id IN NUMBER

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

214: l_flag NUMBER := 0;
215: l_element_context VARCHAR2(5);
216: BEGIN
217: IF g_debug THEN
218: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
219: END IF;
220: PAY_FI_ARCHIVE_PYSA.GET_ALL_PARAMETERS(p_payroll_action_id
221: ,l_business_group_id
222: ,l_start_date

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

336: WHERE ppa.payroll_action_id = :payroll_action_id
337: AND ppa.business_group_id = ppf.business_group_id
338: ORDER BY ppf.person_id';
339: IF g_debug THEN
340: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
341: END IF;
342: EXCEPTION
343: WHEN OTHERS THEN
344: -- Return cursor that selects no rows

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

433: l_action_info_id NUMBER;
434: l_ovn NUMBER;
435: BEGIN
436: IF g_debug THEN
437: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
438: END IF;
439: PAY_FI_ARCHIVE_PYSA.GET_ALL_PARAMETERS(p_payroll_action_id
440: ,l_business_group_id
441: ,l_start_date

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

474: hr_nonrun_asact.insint(l_actid,rec_prepaid_assignments.run_action_id);
475: l_prepay_action_id := rec_prepaid_assignments.prepaid_action_id;
476: END LOOP;
477: IF g_debug THEN
478: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
479: END IF;
480: END ASSIGNMENT_ACTION_CODE;
481: /* INITIALIZATION CODE */
482: PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER)

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

536: l_consolidation_set NUMBER;
537: l_prev_prepay NUMBER := 0;
538: BEGIN
539: IF g_debug THEN
540: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
541: END IF;
542: /*fnd_file.put_line(fnd_file.log,'In INIT_CODE 0');*/
543: GET_ALL_PARAMETERS(p_payroll_action_id
544: ,l_business_group_id

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

583: p_date_earned => NULL,
584: p_archive_flag => 'N');
585:
586: IF g_debug THEN
587: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
588: END IF;
589: EXCEPTION WHEN OTHERS THEN
590: g_err_num := SQLCODE;
591: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE');*/

Line 593: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);

589: EXCEPTION WHEN OTHERS THEN
590: g_err_num := SQLCODE;
591: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE');*/
592: IF g_debug THEN
593: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);
594: END IF;
595: END INITIALIZATION_CODE;
596: PROCEDURE SETUP_ELEMENT_DEFINITIONS( p_classification_name IN VARCHAR2
597: ,p_element_name IN VARCHAR2

Line 606: hr_utility.set_location(' Entering Procedure SETUP_ELEMENT_DEFINITIONS',100);

602: ,p_archive_flag IN VARCHAR2)
603: IS
604: BEGIN
605: IF g_debug THEN
606: hr_utility.set_location(' Entering Procedure SETUP_ELEMENT_DEFINITIONS',100);
607: END IF;
608: g_index := g_index + 1;
609: /* Initialize global tables that hold Additional Element details */
610: g_element_table(g_index).classification_name := p_classification_name;

Line 618: hr_utility.set_location(' Leaving Procedure SETUP_ELEMENT_DEFINITIONS',110);

614: g_element_table(g_index).input_value_id := p_input_value_id;
615: g_element_table(g_index).uom := p_uom;
616: g_element_table(g_index).archive_flag := p_archive_flag;
617: IF g_debug THEN
618: hr_utility.set_location(' Leaving Procedure SETUP_ELEMENT_DEFINITIONS',110);
619: END IF;
620: END SETUP_ELEMENT_DEFINITIONS;
621: PROCEDURE SETUP_BALANCE_DEFINITIONS(p_balance_name IN VARCHAR2
622: ,p_defined_balance_id IN NUMBER

Line 627: hr_utility.set_location(' Entering Procedure SETUP_BALANCE_DEFINITIONS',120);

623: ,p_balance_type_id IN NUMBER)
624: IS
625: BEGIN
626: IF g_debug THEN
627: hr_utility.set_location(' Entering Procedure SETUP_BALANCE_DEFINITIONS',120);
628: END IF;
629: g_index_bal := g_index_bal + 1;
630: /* Initialize global tables that hold Other Balances details */
631: g_user_balance_table(g_index_bal).balance_name := p_balance_name;

Line 636: hr_utility.set_location(' Leaving Procedure SETUP_BALANCE_DEFINITIONS',130);

632: g_user_balance_table(g_index_bal).defined_balance_id := p_defined_balance_id;
633: g_user_balance_table(g_index_bal).balance_type_id := p_balance_type_id;
634: /*fnd_file.put_line(fnd_file.log,'SETUP_BALANCE_DEFINITIONS ' ||p_balance_name); */
635: IF g_debug THEN
636: hr_utility.set_location(' Leaving Procedure SETUP_BALANCE_DEFINITIONS',130);
637: END IF;
638: END SETUP_BALANCE_DEFINITIONS;
639: /* GET COUNTRY NAME FROM CODE */
640: FUNCTION GET_COUNTRY_NAME(p_territory_code VARCHAR2)

Line 650: hr_utility.set_location(' Entering Function GET_COUNTRY_NAME',140);

646: WHERE territory_code = p_territory_code;
647: l_country fnd_territories_vl.territory_short_name%TYPE;
648: BEGIN
649: IF g_debug THEN
650: hr_utility.set_location(' Entering Function GET_COUNTRY_NAME',140);
651: END IF;
652: OPEN csr_get_territory_name(p_territory_code);
653: FETCH csr_get_territory_name into l_country;
654: CLOSE csr_get_territory_name;

Line 657: hr_utility.set_location(' Leaving Function GET_COUNTRY_NAME',150);

653: FETCH csr_get_territory_name into l_country;
654: CLOSE csr_get_territory_name;
655: RETURN l_country;
656: IF g_debug THEN
657: hr_utility.set_location(' Leaving Function GET_COUNTRY_NAME',150);
658: END IF;
659: END GET_COUNTRY_NAME;
660: /* EMPLOYEE DETAILS REGION */
661: PROCEDURE ARCHIVE_EMPLOYEE_DETAILS (p_archive_assact_id IN NUMBER

Line 845: hr_utility.set_location(' Entering Procedure ARCHIVE_EMPLOYEE_DETAILS',160);

841: -- l_lower_base NUMBER :=0;
842: -- l_upper_base NUMBER :=0;
843: BEGIN
844: IF g_debug THEN
845: hr_utility.set_location(' Entering Procedure ARCHIVE_EMPLOYEE_DETAILS',160);
846: END IF;
847: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS');*/
848: /* PERSON AND ADDRESS DETAILS */
849: OPEN csr_person_details(p_assignment_id);

Line 1048: hr_utility.set_location(' Leaving Procedure ARCHIVE_EMPLOYEE_DETAILS',170);

1044: */
1045: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 10');*/
1046: --
1047: IF g_debug THEN
1048: hr_utility.set_location(' Leaving Procedure ARCHIVE_EMPLOYEE_DETAILS',170);
1049: END IF;
1050: --
1051: EXCEPTION WHEN OTHERS THEN
1052: g_err_num := SQLCODE;

Line 1055: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS',180);

1051: EXCEPTION WHEN OTHERS THEN
1052: g_err_num := SQLCODE;
1053: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS');*/
1054: IF g_debug THEN
1055: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS',180);
1056: END IF;
1057: END ARCHIVE_EMPLOYEE_DETAILS;
1058: /* EARNINGS REGION, DEDUCTIONS REGION */
1059: PROCEDURE ARCHIVE_ELEMENT_INFO(p_payroll_action_id IN NUMBER

Line 1126: hr_utility.set_location(' Entering Procedure ARCHIVE_ELEMENT_INFO',210);

1122: l_ovn NUMBER;
1123: l_flag NUMBER := 0;
1124: BEGIN
1125: IF g_debug THEN
1126: hr_utility.set_location(' Entering Procedure ARCHIVE_ELEMENT_INFO',210);
1127: END IF;
1128: /* EARNINGS ELEMENT */
1129: FOR rec_earnings IN csr_ear_element_info LOOP
1130: BEGIN

Line 1191: hr_utility.set_location(' Leaving Procedure ARCHIVE_ELEMENT_INFO',220);

1187: NULL;*/
1188: END;
1189: END LOOP;
1190: IF g_debug THEN
1191: hr_utility.set_location(' Leaving Procedure ARCHIVE_ELEMENT_INFO',220);
1192: END IF;
1193: EXCEPTION WHEN OTHERS THEN
1194: g_err_num := SQLCODE;
1195: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ELEMENT_INFO');*/

Line 1197: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'ARCHIVE_ELEMENT_INFO',230);

1193: EXCEPTION WHEN OTHERS THEN
1194: g_err_num := SQLCODE;
1195: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ELEMENT_INFO');*/
1196: IF g_debug THEN
1197: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'ARCHIVE_ELEMENT_INFO',230);
1198: END IF;
1199: END ARCHIVE_ELEMENT_INFO;
1200: /* GET DEFINED BALANCE ID */
1201: FUNCTION GET_DEFINED_BALANCE_ID(p_user_name IN VARCHAR2) RETURN NUMBER

Line 1216: hr_utility.set_location(' Entering Function GET_DEFINED_BALANCE_ID',240);

1212: AND u.creator_type = 'B';
1213: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1214: BEGIN
1215: IF g_debug THEN
1216: hr_utility.set_location(' Entering Function GET_DEFINED_BALANCE_ID',240);
1217: END IF;
1218: OPEN csr_def_bal_id(p_user_name);
1219: FETCH csr_def_bal_id INTO l_defined_balance_id;
1220: CLOSE csr_def_bal_id;

Line 1223: hr_utility.set_location(' Leaving Function GET_DEFINED_BALANCE_ID',250);

1219: FETCH csr_def_bal_id INTO l_defined_balance_id;
1220: CLOSE csr_def_bal_id;
1221: RETURN l_defined_balance_id;
1222: IF g_debug THEN
1223: hr_utility.set_location(' Leaving Function GET_DEFINED_BALANCE_ID',250);
1224: END IF;
1225: END GET_DEFINED_BALANCE_ID;
1226: /* PAYMENT INFORMATION REGION */
1227: PROCEDURE ARCHIVE_PAYMENT_INFO(p_archive_assact_id IN NUMBER,

Line 1308: hr_utility.set_location(' Entering Procedure ARCHIVE_PAYMENT_INFO',260);

1304: rec_chk csr_chk%ROWTYPE;
1305: l_pay_value VARCHAR2(50) := NULL;
1306: BEGIN
1307: IF g_debug THEN
1308: hr_utility.set_location(' Entering Procedure ARCHIVE_PAYMENT_INFO',260);
1309: END IF;
1310: OPEN csr_chk(p_prepay_assact_id);
1311: LOOP
1312: FETCH csr_chk INTO rec_chk;

Line 1423: hr_utility.set_location(' Leaving Procedure ARCHIVE_PAYMENT_INFO',270);

1419: END LOOP;
1420: CLOSE csr_chk;
1421:
1422: IF g_debug THEN
1423: hr_utility.set_location(' Leaving Procedure ARCHIVE_PAYMENT_INFO',270);
1424: END IF;
1425: EXCEPTION WHEN OTHERS THEN
1426: g_err_num := SQLCODE;
1427: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO');*/

Line 1429: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO',280);

1425: EXCEPTION WHEN OTHERS THEN
1426: g_err_num := SQLCODE;
1427: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO');*/
1428: IF g_debug THEN
1429: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO',280);
1430: END IF;
1431: END ARCHIVE_PAYMENT_INFO;
1432: /* ACCRUALS REGION */
1433: /* PROCEDURE ARCHIVE_ACCRUAL_PLAN ( p_assignment_id IN NUMBER

Line 1496: hr_utility.set_location(' Entering Procedure ARCHIVE_ACCRUAL_PLAN',290);

1492: --
1493: BEGIN
1494: --
1495: IF g_debug THEN
1496: hr_utility.set_location(' Entering Procedure ARCHIVE_ACCRUAL_PLAN',290);
1497: END IF;
1498: OPEN csr_leave_balance;
1499: FETCH csr_leave_balance INTO
1500: l_accrual_plan_name

Line 1558: hr_utility.set_location(' Leaving Procedure ARCHIVE_ACCRUAL_PLAN',300);

1554: END IF;
1555: --
1556: CLOSE csr_leave_balance;
1557: IF g_debug THEN
1558: hr_utility.set_location(' Leaving Procedure ARCHIVE_ACCRUAL_PLAN',300);
1559: END IF;
1560: --
1561: EXCEPTION
1562: WHEN OTHERS THEN

Line 1572: hr_utility.set_location('ORA_ERR: ' || g_err_num || ' In ARCHIVE_ACCRUAL_PLAN',310);

1568: --
1569: g_err_num := SQLCODE;
1570: --fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ACCRUAL_PLAN');
1571: IF g_debug THEN
1572: hr_utility.set_location('ORA_ERR: ' || g_err_num || ' In ARCHIVE_ACCRUAL_PLAN',310);
1573: END IF;
1574: RAISE;
1575: END ARCHIVE_ACCRUAL_PLAN;*/
1576: /* ADDITIONAL ELEMENTS REGION */

Line 1631: hr_utility.set_location(' Entering Procedure ARCHIVE_ADD_ELEMENT',320);

1627: l_formatted_value VARCHAR2(50) := NULL;
1628: l_flag NUMBER := 0;
1629: BEGIN
1630: IF g_debug THEN
1631: hr_utility.set_location(' Entering Procedure ARCHIVE_ADD_ELEMENT',320);
1632: END IF;
1633: IF p_archive_flag = 'N' THEN
1634: ---------------------------------------------------
1635: --Check if global table has already been populated

Line 1683: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT',330);

1679: EXCEPTION WHEN OTHERS THEN
1680: g_err_num := SQLCODE;
1681: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT');*/
1682: IF g_debug THEN
1683: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT',330);
1684: END IF;
1685: END;
1686: END LOOP;
1687: END IF;

Line 1689: hr_utility.set_location(' Leaving Procedure ARCHIVE_ADD_ELEMENT',340);

1685: END;
1686: END LOOP;
1687: END IF;
1688: IF g_debug THEN
1689: hr_utility.set_location(' Leaving Procedure ARCHIVE_ADD_ELEMENT',340);
1690: END IF;
1691: END ARCHIVE_ADD_ELEMENT;
1692: /* OTHER BALANCES REGION */
1693: PROCEDURE ARCHIVE_OTH_BALANCE (p_archive_assact_id IN NUMBER,

Line 1733: hr_utility.set_location(' Entering Procedure ARCHIVE_OTH_BALANCE',350);

1729: l_formatted_value VARCHAR2(50) := NULL;
1730: l_flag NUMBER := 0;
1731: BEGIN
1732: IF g_debug THEN
1733: hr_utility.set_location(' Entering Procedure ARCHIVE_OTH_BALANCE',350);
1734: END IF;
1735:
1736: /*fnd_file.put_line(fnd_file.log,'Entering In ARCHIVE_OTH_BALANCE global');*/
1737: IF p_archive_flag = 'N' THEN

Line 1794: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE',360);

1790: EXCEPTION WHEN OTHERS THEN
1791: g_err_num := SQLCODE;
1792: fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE'||SQLERRM);
1793: IF g_debug THEN
1794: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE',360);
1795: END IF;
1796: END ARCHIVE_OTH_BALANCE;
1797: /*Additional Employee Details*/
1798: PROCEDURE ARCHIVE_ADDL_EMP_DETAILS(p_archive_assact_id IN NUMBER

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

2602: l_fnd_session NUMBER := 0;
2603: l_prev_prepay NUMBER := 0;
2604: BEGIN
2605: IF g_debug THEN
2606: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
2607: END IF;
2608:
2609:
2610: OPEN csr_archive_payact(p_assignment_action_id);

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

2700:
2701: l_record_count := l_record_count + 1;
2702: END LOOP;
2703: IF g_debug THEN
2704: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
2705: END IF;
2706: END ARCHIVE_CODE;
2707:
2708: PROCEDURE ARCHIVE_MAIN_ELEMENTS

Line 2810: hr_utility.set_location(' Entering Procedure ARCHIVE_MAIN_ELEMENTS',320);

2806:
2807: BEGIN
2808:
2809: IF g_debug THEN
2810: hr_utility.set_location(' Entering Procedure ARCHIVE_MAIN_ELEMENTS',320);
2811: END IF;
2812:
2813: -- Archiving Earnings Elements
2814: FOR csr_rec IN csr_ear_element_info LOOP

Line 2846: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS',330);

2842: g_err_num := SQLCODE;
2843: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS');*/
2844:
2845: IF g_debug THEN
2846: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS',330);
2847: END IF;
2848: END;
2849: END LOOP;
2850:

Line 2889: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS',330);

2885: g_err_num := SQLCODE;
2886: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS');*/
2887:
2888: IF g_debug THEN
2889: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS',330);
2890: END IF;
2891: END;
2892: END LOOP;
2893:

Line 2896: hr_utility.set_location(' Leaving Procedure ARCHIVE_MAIN_ELEMENTS',340);

2892: END LOOP;
2893:
2894:
2895: IF g_debug THEN
2896: hr_utility.set_location(' Leaving Procedure ARCHIVE_MAIN_ELEMENTS',340);
2897: END IF;
2898:
2899: END ARCHIVE_MAIN_ELEMENTS;
2900:

Line 2961: hr_utility.set_location(' Entering Procedure DEINITIALIZATION_CODE',380);

2957:
2958:
2959: BEGIN
2960: IF g_debug THEN
2961: hr_utility.set_location(' Entering Procedure DEINITIALIZATION_CODE',380);
2962: END IF;
2963:
2964: OPEN csr_effective_date(p_payroll_action_id);
2965: FETCH csr_effective_date INTO l_effective_date ;

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

3029: END LOOP;
3030:
3031: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 10');*/
3032: IF g_debug THEN
3033: hr_utility.set_location(' Leaving Procedure DEINITIALIZATION_CODE',390);
3034: END IF;
3035:
3036: EXCEPTION
3037: WHEN others THEN

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

3035:
3036: EXCEPTION
3037: WHEN others THEN
3038: IF g_debug THEN
3039: hr_utility.set_location('error raised in DEINITIALIZATION_CODE ',5);
3040: END if;
3041: RAISE;
3042: END;
3043: