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 482: g_debug := hr_utility.debug_enabled;

478: l_previous_deductor_type hr_organization_information.org_information3%TYPE;
479: --
480: BEGIN
481: --
482: g_debug := hr_utility.debug_enabled;
483: l_procedure := g_package || '.initialization_code';
484:
485: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
486:

Line 629: g_debug := hr_utility.debug_enabled;

625: l_date DATE;
626: l_procedure VARCHAR2(250);
627: l_message VARCHAR2(250);
628: BEGIN
629: g_debug := hr_utility.debug_enabled;
630: l_procedure := g_package ||'.assignment_end_date';
631: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
632: OPEN c_termination_check;
633: FETCH c_termination_check INTO l_date;

Line 672: g_debug := hr_utility.debug_enabled;

668: l_message VARCHAR2(250);
669: --
670: BEGIN
671: --
672: g_debug := hr_utility.debug_enabled;
673: l_procedure := g_package || '.range_code';
674:
675: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
676:

Line 730: g_debug := hr_utility.debug_enabled;

726: l_last_sum VARCHAR2(2500);
727: l_procedure VARCHAR2(250);
728: l_message VARCHAR2(250);
729: BEGIN
730: g_debug := hr_utility.debug_enabled;
731: l_procedure := g_package ||'.update_challans';
732: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
733: pay_in_utils.set_location(g_debug,'g_24q_payroll_act_id ' || g_24q_payroll_act_id ,1);
734: pay_in_utils.set_location(g_debug,'g_24qc_payroll_act_id ' || g_24qc_payroll_act_id,1);

Line 1490: g_debug := hr_utility.debug_enabled;

1486:
1487: --
1488: BEGIN
1489: --
1490: g_debug := hr_utility.debug_enabled;
1491: l_procedure := g_package || '.generate_employee_data';
1492:
1493: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
1494:

Line 1721: g_debug := hr_utility.debug_enabled;

1717: l_value VARCHAR2(20);
1718: l_procedure VARCHAR2(100);
1719:
1720: BEGIN
1721: g_debug := hr_utility.debug_enabled;
1722: l_procedure := g_package ||'.get_format_value';
1723: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1724: IF g_debug THEN
1725: pay_in_utils.trace('p_value',p_value);

Line 1780: g_debug := hr_utility.debug_enabled;

1776: l_value1 VARCHAR2(20);
1777: l_procedure varchar2(100);
1778:
1779: BEGIN
1780: g_debug := hr_utility.debug_enabled;
1781: l_procedure := g_package ||'.get_24Q_values';
1782: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1783:
1784: IF g_debug THEN

Line 2584: g_debug := hr_utility.debug_enabled;

2580:
2581: --
2582: BEGIN
2583: --
2584: g_debug := hr_utility.debug_enabled;
2585: l_procedure := g_package || '.generate_salary_data';
2586:
2587: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
2588:

Line 2937: g_debug := hr_utility.debug_enabled;

2933: l_emplr_type_24Q hr_organization_information.org_information6%TYPE;
2934: l_procedure VARCHAR2(250);
2935: l_message VARCHAR2(250);
2936: BEGIN
2937: g_debug := hr_utility.debug_enabled;
2938: l_procedure := g_package ||'.get_org_details';
2939: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2940: pay_in_utils.set_location(g_debug,'Fetching Live Details ',2);
2941: OPEN c_org_inc_tax_df_details;

Line 3223: g_debug := hr_utility.debug_enabled;

3219: l_rep_std_code per_phones.phone_number%TYPE;
3220: l_procedure VARCHAR2(250);
3221: l_message VARCHAR2(250);
3222: BEGIN
3223: g_debug := hr_utility.debug_enabled;
3224: l_procedure := g_package ||'.generate_organization_data';
3225: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3226:
3227: FOR c_rec IN c_chk_organization

Line 3712: g_debug := hr_utility.debug_enabled;

3708: l_dummy hr_organization_information.org_information3%TYPE;
3709: l_procedure VARCHAR2(250);
3710: l_message VARCHAR2(250);
3711: BEGIN
3712: g_debug := hr_utility.debug_enabled;
3713: l_procedure := g_package ||'.generate_challan_data';
3714: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3715: -- First Search for those challans that have been added since Form 24Q
3716: -- Last generation but were not reported in Form 24Q Correction.

Line 4245: g_debug := hr_utility.debug_enabled;

4241: l_action_information_id NUMBER;
4242: l_procedure VARCHAR2(250);
4243: l_message VARCHAR2(250);
4244: BEGIN
4245: g_debug := hr_utility.debug_enabled;
4246: l_procedure := g_package ||'.get_element_entry_values';
4247: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
4248: pay_in_utils.set_location(g_debug,'Fetching Live Data ' ,2);
4249: OPEN c_get_ee_from_live_data;

Line 4414: g_debug := hr_utility.debug_enabled;

4410: l_q4_others_total NUMBER;
4411: l_cess NUMBER;
4412:
4413: BEGIN
4414: g_debug := hr_utility.debug_enabled;
4415: l_proc := g_package||'.get_live_balances';
4416:
4417: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
4418:

Line 4805: g_debug := hr_utility.debug_enabled;

4801: t_balance_name t_bal_name_tab;
4802:
4803: BEGIN
4804:
4805: g_debug := hr_utility.debug_enabled;
4806: l_procedure := g_package ||'.get_balance_values';
4807: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
4808: pay_in_utils.set_location(g_debug,'Fetching Live Data ' ,2);
4809:

Line 5101: g_debug := hr_utility.debug_enabled;

5097: t_person_24q_data t_person_data_rec;
5098: l_procedure VARCHAR2(250);
5099: l_message VARCHAR2(250);
5100: BEGIN
5101: g_debug := hr_utility.debug_enabled;
5102: l_procedure := g_package ||'.check_c5_change_only';
5103: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
5104: pay_in_utils.set_location(g_debug,'Fetching Live Data',2);
5105: get_element_entry_values

Line 5498: g_debug := hr_utility.debug_enabled;

5494: l_prev_pay BOOLEAN;
5495:
5496: BEGIN
5497:
5498: g_debug := hr_utility.debug_enabled;
5499: l_procedure := g_package ||'.archive_salary_data';
5500: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
5501: pay_in_utils.set_location(g_debug,'Fetching Salary Data ', 1);
5502:

Line 6727: g_debug := hr_utility.debug_enabled;

6723: l_category pay_action_information.action_information_category%TYPE;
6724: l_procedure VARCHAR2(250);
6725: l_message VARCHAR2(250);
6726: BEGIN
6727: g_debug := hr_utility.debug_enabled;
6728: l_procedure := g_package ||'.archive_deductee_data';
6729: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
6730: pay_in_utils.set_location(g_debug,'Fetching Deductee Data ', 1);
6731: pay_in_utils.set_location(g_debug,'Value of g_count_ee_delete : '|| g_count_ee_delete, 1);

Line 7268: g_debug := hr_utility.debug_enabled;

7264: l_flag_number NUMBER := -1;
7265: l_procedure VARCHAR2(250);
7266: l_message VARCHAR2(250);
7267: BEGIN
7268: g_debug := hr_utility.debug_enabled;
7269: l_procedure := g_package ||'.archive_no_change_challan';
7270: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
7271: FOR c_rec IN c_populate_no_change_data
7272: LOOP

Line 7476: g_debug := hr_utility.debug_enabled;

7472: l_flag NUMBER := -1;
7473: l_procedure VARCHAR2(250);
7474: l_message VARCHAR2(250);
7475: BEGIN
7476: g_debug := hr_utility.debug_enabled;
7477: l_procedure := g_package ||'.archive_challan_data';
7478: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
7479: pay_in_utils.set_location(g_debug,'Fetching Challan Data ', 1);
7480: BEGIN

Line 7777: g_debug := hr_utility.debug_enabled;

7773: l_ovn NUMBER;
7774: l_procedure VARCHAR2(250);
7775: l_message VARCHAR2(250);
7776: BEGIN
7777: g_debug := hr_utility.debug_enabled;
7778: l_procedure := g_package ||'.archive_cancellation_data';
7779: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
7780: pay_in_utils.set_location(g_debug,'In this procedure archive only Name ',2);
7781: pay_in_utils.set_location(g_debug,'and Deductor type and that too as per ',3);

Line 7941: g_debug := hr_utility.debug_enabled;

7937: l_flag NUMBER := -1;
7938: l_procedure VARCHAR2(250);
7939: l_message VARCHAR2(250);
7940: BEGIN
7941: g_debug := hr_utility.debug_enabled;
7942: l_procedure := g_package ||'.archive_organization_data';
7943: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
7944: pay_in_utils.set_location(g_debug,'Fetching Organization Data ', 1);
7945: get_org_details(g_gre_id,

Line 8491: g_debug := hr_utility.debug_enabled;

8487:
8488: l_procedure VARCHAR2(250);
8489: l_message VARCHAR2(250);
8490: BEGIN
8491: g_debug := hr_utility.debug_enabled;
8492: l_procedure := g_package ||'.archive_c5_data_only';
8493: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
8494:
8495: pay_in_utils.set_location(g_debug,'Checking Challan Data', 1);

Line 8771: g_debug := hr_utility.debug_enabled;

8767: BEGIN
8768: --
8769:
8770: l_procedure := g_package || '.assignment_action_code';
8771: g_debug := hr_utility.debug_enabled;
8772: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
8773:
8774: pay_in_utils.set_location(g_debug,'Archival for C4,C5 Modes Starts : '||l_procedure,12);
8775: