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

Line 28: g_debug := hr_utility.debug_enabled;

24: l_procedure VARCHAR2(250);
25: l_message VARCHAR2(250);
26: BEGIN
27:
28: g_debug := hr_utility.debug_enabled;
29: l_procedure := g_package || '.trace_pl_sql_table_data ';
30: pay_in_utils.set_location(g_debug,'Entering: '|| l_procedure,10);
31:
32: pay_in_utils.set_location(g_debug,'************************************************************ ',3);

Line 314: g_debug := hr_utility.debug_enabled;

310: l_flag NUMBER := 0;
311: l_procedure VARCHAR2(250);
312: l_message VARCHAR2(250);
313: BEGIN
314: g_debug := hr_utility.debug_enabled;
315: l_procedure := g_package ||'.check_archival_status';
316: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
317:
318: IF (p_act_inf_category = 'IN_24QC_DEDUCTEE')

Line 390: g_debug := hr_utility.debug_enabled;

386: l_procedure VARCHAR2(100);
387: l_message VARCHAR2(250);
388:
389: BEGIN
390: g_debug := hr_utility.debug_enabled;
391: l_procedure := g_package||'.get_parameters';
392:
393: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
394:

Line 464: g_debug := hr_utility.debug_enabled;

460: E_NON_UNIQUE_ARCH_REF_NO EXCEPTION;
461: --
462: BEGIN
463: --
464: g_debug := hr_utility.debug_enabled;
465: l_procedure := g_package || '.initialization_code';
466:
467: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
468:

Line 564: g_debug := hr_utility.debug_enabled;

560: l_date DATE;
561: l_procedure VARCHAR2(250);
562: l_message VARCHAR2(250);
563: BEGIN
564: g_debug := hr_utility.debug_enabled;
565: l_procedure := g_package ||'.assignment_end_date';
566: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
567: OPEN c_termination_check;
568: FETCH c_termination_check INTO l_date;

Line 607: g_debug := hr_utility.debug_enabled;

603: l_message VARCHAR2(250);
604: --
605: BEGIN
606: --
607: g_debug := hr_utility.debug_enabled;
608: l_procedure := g_package || '.range_code';
609:
610: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
611:

Line 665: g_debug := hr_utility.debug_enabled;

661: l_last_sum VARCHAR2(2500);
662: l_procedure VARCHAR2(250);
663: l_message VARCHAR2(250);
664: BEGIN
665: g_debug := hr_utility.debug_enabled;
666: l_procedure := g_package ||'.update_challans';
667: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
668: pay_in_utils.set_location(g_debug,'g_24q_payroll_act_id ' || g_24q_payroll_act_id ,1);
669: pay_in_utils.set_location(g_debug,'g_24qc_payroll_act_id ' || g_24qc_payroll_act_id,1);

Line 1383: g_debug := hr_utility.debug_enabled;

1379:
1380: --
1381: BEGIN
1382: --
1383: g_debug := hr_utility.debug_enabled;
1384: l_procedure := g_package || '.generate_employee_data';
1385:
1386: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
1387:

Line 1614: g_debug := hr_utility.debug_enabled;

1610: l_value VARCHAR2(20);
1611: l_procedure VARCHAR2(100);
1612:
1613: BEGIN
1614: g_debug := hr_utility.debug_enabled;
1615: l_procedure := g_package ||'.get_format_value';
1616: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1617: IF g_debug THEN
1618: pay_in_utils.trace('p_value',p_value);

Line 1673: g_debug := hr_utility.debug_enabled;

1669: l_value1 VARCHAR2(20);
1670: l_procedure varchar2(100);
1671:
1672: BEGIN
1673: g_debug := hr_utility.debug_enabled;
1674: l_procedure := g_package ||'.get_24Q_values';
1675: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1676:
1677: IF g_debug THEN

Line 2477: g_debug := hr_utility.debug_enabled;

2473:
2474: --
2475: BEGIN
2476: --
2477: g_debug := hr_utility.debug_enabled;
2478: l_procedure := g_package || '.generate_salary_data';
2479:
2480: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
2481:

Line 2813: g_debug := hr_utility.debug_enabled;

2809: l_rep_person_id per_all_people_f.person_id%TYPE;
2810: l_procedure VARCHAR2(250);
2811: l_message VARCHAR2(250);
2812: BEGIN
2813: g_debug := hr_utility.debug_enabled;
2814: l_procedure := g_package ||'.get_org_details';
2815: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2816: pay_in_utils.set_location(g_debug,'Fetching Live Details ',2);
2817: OPEN c_org_inc_tax_df_details;

Line 3003: g_debug := hr_utility.debug_enabled;

2999: l_rep_std_code per_phones.phone_number%TYPE;
3000: l_procedure VARCHAR2(250);
3001: l_message VARCHAR2(250);
3002: BEGIN
3003: g_debug := hr_utility.debug_enabled;
3004: l_procedure := g_package ||'.generate_organization_data';
3005: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3006:
3007: FOR c_rec IN c_chk_organization

Line 3395: g_debug := hr_utility.debug_enabled;

3391: l_dummy NUMBER;
3392: l_procedure VARCHAR2(250);
3393: l_message VARCHAR2(250);
3394: BEGIN
3395: g_debug := hr_utility.debug_enabled;
3396: l_procedure := g_package ||'.generate_challan_data';
3397: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3398: -- First Search for those challans that have been added since Form 24Q
3399: -- Last generation but were not reported in Form 24Q Correction.

Line 3921: g_debug := hr_utility.debug_enabled;

3917: l_action_information_id NUMBER;
3918: l_procedure VARCHAR2(250);
3919: l_message VARCHAR2(250);
3920: BEGIN
3921: g_debug := hr_utility.debug_enabled;
3922: l_procedure := g_package ||'.get_element_entry_values';
3923: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3924: pay_in_utils.set_location(g_debug,'Fetching Live Data ' ,2);
3925: OPEN c_get_ee_from_live_data;

Line 4090: g_debug := hr_utility.debug_enabled;

4086: l_q4_others_total NUMBER;
4087: l_cess NUMBER;
4088:
4089: BEGIN
4090: g_debug := hr_utility.debug_enabled;
4091: l_proc := g_package||'.get_live_balances';
4092:
4093: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
4094:

Line 4481: g_debug := hr_utility.debug_enabled;

4477: t_balance_name t_bal_name_tab;
4478:
4479: BEGIN
4480:
4481: g_debug := hr_utility.debug_enabled;
4482: l_procedure := g_package ||'.get_balance_values';
4483: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
4484: pay_in_utils.set_location(g_debug,'Fetching Live Data ' ,2);
4485:

Line 4777: g_debug := hr_utility.debug_enabled;

4773: t_person_24q_data t_person_data_rec;
4774: l_procedure VARCHAR2(250);
4775: l_message VARCHAR2(250);
4776: BEGIN
4777: g_debug := hr_utility.debug_enabled;
4778: l_procedure := g_package ||'.check_c5_change_only';
4779: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
4780: pay_in_utils.set_location(g_debug,'Fetching Live Data',2);
4781: get_element_entry_values

Line 5174: g_debug := hr_utility.debug_enabled;

5170: l_prev_pay BOOLEAN;
5171:
5172: BEGIN
5173:
5174: g_debug := hr_utility.debug_enabled;
5175: l_procedure := g_package ||'.archive_salary_data';
5176: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
5177: pay_in_utils.set_location(g_debug,'Fetching Salary Data ', 1);
5178:

Line 6403: g_debug := hr_utility.debug_enabled;

6399: l_category pay_action_information.action_information_category%TYPE;
6400: l_procedure VARCHAR2(250);
6401: l_message VARCHAR2(250);
6402: BEGIN
6403: g_debug := hr_utility.debug_enabled;
6404: l_procedure := g_package ||'.archive_deductee_data';
6405: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
6406: pay_in_utils.set_location(g_debug,'Fetching Deductee Data ', 1);
6407: pay_in_utils.set_location(g_debug,'Value of g_count_ee_delete : '|| g_count_ee_delete, 1);

Line 6944: g_debug := hr_utility.debug_enabled;

6940: l_flag_number NUMBER := -1;
6941: l_procedure VARCHAR2(250);
6942: l_message VARCHAR2(250);
6943: BEGIN
6944: g_debug := hr_utility.debug_enabled;
6945: l_procedure := g_package ||'.archive_no_change_challan';
6946: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
6947: FOR c_rec IN c_populate_no_change_data
6948: LOOP

Line 7152: g_debug := hr_utility.debug_enabled;

7148: l_flag NUMBER := -1;
7149: l_procedure VARCHAR2(250);
7150: l_message VARCHAR2(250);
7151: BEGIN
7152: g_debug := hr_utility.debug_enabled;
7153: l_procedure := g_package ||'.archive_challan_data';
7154: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
7155: pay_in_utils.set_location(g_debug,'Fetching Challan Data ', 1);
7156: BEGIN

Line 7450: g_debug := hr_utility.debug_enabled;

7446: l_ovn NUMBER;
7447: l_procedure VARCHAR2(250);
7448: l_message VARCHAR2(250);
7449: BEGIN
7450: g_debug := hr_utility.debug_enabled;
7451: l_procedure := g_package ||'.archive_cancellation_data';
7452: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
7453: pay_in_utils.set_location(g_debug,'In this procedure archive only Name ',2);
7454: pay_in_utils.set_location(g_debug,'and Deductor type and that too as per ',3);

Line 7590: g_debug := hr_utility.debug_enabled;

7586: l_flag NUMBER := -1;
7587: l_procedure VARCHAR2(250);
7588: l_message VARCHAR2(250);
7589: BEGIN
7590: g_debug := hr_utility.debug_enabled;
7591: l_procedure := g_package ||'.archive_organization_data';
7592: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
7593: pay_in_utils.set_location(g_debug,'Fetching Organization Data ', 1);
7594: get_org_details(g_gre_id,

Line 8102: g_debug := hr_utility.debug_enabled;

8098:
8099: l_procedure VARCHAR2(250);
8100: l_message VARCHAR2(250);
8101: BEGIN
8102: g_debug := hr_utility.debug_enabled;
8103: l_procedure := g_package ||'.archive_c5_data_only';
8104: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
8105:
8106: pay_in_utils.set_location(g_debug,'Checking Challan Data', 1);

Line 8369: g_debug := hr_utility.debug_enabled;

8365: BEGIN
8366: --
8367:
8368: l_procedure := g_package || '.assignment_action_code';
8369: g_debug := hr_utility.debug_enabled;
8370: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
8371:
8372: pay_in_utils.set_location(g_debug,'Archival for C4,C5 Modes Starts : '||l_procedure,12);
8373: