DBA Data[Home] [Help]

APPS.PAY_IN_TERMINATION_PKG dependencies on HR_UTILITY

Line 244: g_debug := hr_utility.debug_enabled ;

240: l_dummy_amount VARCHAR2(10);
241: l_dummy_reason VARCHAR2(10);
242:
243: BEGIN
244: g_debug := hr_utility.debug_enabled ;
245: l_procedure := g_package||'check_gratuity' ;
246: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
247: p_message_name := 'SUCCESS';
248: pay_in_utils.null_message(p_token_name, p_token_value);

Line 315: g_debug := hr_utility.debug_enabled ;

311:
312: --
313: BEGIN
314: --
315: g_debug := hr_utility.debug_enabled ;
316: l_procedure := g_package || 'years_of_service' ;
317: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
318:
319: l_years := months_between(p_end_date, p_start_date)/12 ;

Line 481: g_debug := hr_utility.debug_enabled ;

477:
478:
479:
480: BEGIN
481: g_debug := hr_utility.debug_enabled ;
482: l_procedure := g_package || 'get_average_salary' ;
483: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
484:
485: IF g_debug THEN

Line 629: g_debug := hr_utility.debug_enabled ;

625:
626: l_procedure VARCHAR2(100);
627:
628: BEGIN
629: g_debug := hr_utility.debug_enabled ;
630: l_procedure := g_package ||'get_pos_dtls' ;
631: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
632:
633: IF g_debug THEN

Line 704: g_debug := hr_utility.debug_enabled ;

700: l_procedure VARCHAR2(100);
701: l_count NUMBER;
702:
703: BEGIN
704: g_debug := hr_utility.debug_enabled ;
705: l_procedure := g_package ||'get_input_value_ids' ;
706:
707: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
708:

Line 800: g_debug := hr_utility.debug_enabled ;

796: l_procedure VARCHAR2(100);
797: l_link_flag VARCHAR2(100);
798:
799: BEGIN
800: g_debug := hr_utility.debug_enabled ;
801: l_procedure := g_package ||'get_entry_details' ;
802: p_message_name := 'SUCCESS';
803: pay_in_utils.null_message (p_token_name, p_token_value);
804:

Line 1087: g_debug := hr_utility.debug_enabled;

1083:
1084: BEGIN
1085: p_element_entry_id := NULL;
1086: p_ee_ovn := NULL;
1087: g_debug := hr_utility.debug_enabled;
1088:
1089: OPEN csr_asg_details;
1090: FETCH csr_asg_details
1091: INTO l_business_group_id, l_payroll_id;

Line 1228: g_debug := hr_utility.debug_enabled;

1224:
1225: BEGIN
1226: p_element_entry_id := NULL;
1227: p_ee_ovn := NULL;
1228: g_debug := hr_utility.debug_enabled;
1229:
1230: OPEN csr_asg_details;
1231: FETCH csr_asg_details
1232: INTO l_business_group_id, l_payroll_id;

Line 1327: g_debug := hr_utility.debug_enabled ;

1323:
1324:
1325: --
1326: BEGIN
1327: g_debug := hr_utility.debug_enabled ;
1328: l_procedure := g_package || 'is_element_processed' ;
1329: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1330:
1331: OPEN csr_element_proc;

Line 1421: g_debug := hr_utility.debug_enabled;

1417:
1418: BEGIN
1419: p_element_entry_id := NULL;
1420: p_ee_ovn := NULL;
1421: g_debug := hr_utility.debug_enabled;
1422:
1423: OPEN csr_asg_details;
1424: FETCH csr_asg_details
1425: INTO l_business_group_id, l_payroll_id;

Line 1496: g_debug := hr_utility.debug_enabled ;

1492: l_e_date CONSTANT DATE := to_date('01-04-2004','DD-MM-YYYY');
1493: l_coverage_flag hr_soft_coding_keyflex.segment8%TYPE;
1494:
1495: BEGIN
1496: g_debug := hr_utility.debug_enabled ;
1497: l_procedure := g_package ||'get_gratuity_ivs' ;
1498: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1499:
1500: pay_in_utils.set_location(g_debug,l_procedure,20);

Line 1582: g_debug := hr_utility.debug_enabled ;

1578: l_create_ee BOOLEAN;
1579: l_element_processed BOOLEAN;
1580:
1581: BEGIN
1582: g_debug := hr_utility.debug_enabled ;
1583: l_procedure := g_package || 'create_gratuity_entry' ;
1584: p_message_name := 'SUCCESS';
1585: pay_in_utils.null_message (p_token_name, p_token_value);
1586:

Line 1696: g_debug := hr_utility.debug_enabled ;

1692: l_start_date DATE;
1693: l_delete_warning BOOLEAN;
1694:
1695: BEGIN
1696: g_debug := hr_utility.debug_enabled ;
1697: l_procedure := g_package || 'delete_gratuity_entry' ;
1698: p_message_name := 'SUCCESS';
1699: pay_in_utils.null_message (p_token_name, p_token_value);
1700:

Line 1788: g_debug := hr_utility.debug_enabled ;

1784: l_shortfall NUMBER;
1785: l_message VARCHAR2(1000);
1786:
1787: BEGIN
1788: g_debug := hr_utility.debug_enabled ;
1789: l_procedure := g_package ||'get_notice_ivs' ;
1790: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1791:
1792: --

Line 1889: g_debug := hr_utility.debug_enabled ;

1885: l_ee_exists BOOLEAN;
1886: l_element_processed BOOLEAN;
1887:
1888: BEGIN
1889: g_debug := hr_utility.debug_enabled ;
1890: l_procedure := g_package || 'create_notice_entry' ;
1891: p_message_name := 'SUCCESS';
1892: pay_in_utils.null_message (p_token_name, p_token_value);
1893:

Line 2002: g_debug := hr_utility.debug_enabled ;

1998: l_start_date DATE;
1999: l_delete_warning BOOLEAN;
2000:
2001: BEGIN
2002: g_debug := hr_utility.debug_enabled ;
2003: l_procedure := g_package || 'delete_notice_entry' ;
2004: p_message_name := 'SUCCESS';
2005: pay_in_utils.null_message (p_token_name, p_token_value);
2006:

Line 2081: g_debug := hr_utility.debug_enabled ;

2077: l_ee_exists BOOLEAN;
2078: l_element_processed BOOLEAN;
2079:
2080: BEGIN
2081: g_debug := hr_utility.debug_enabled ;
2082: l_procedure := g_package || 'create_retrenchment_entry' ;
2083: p_message_name := 'SUCCESS';
2084: pay_in_utils.null_message (p_token_name, p_token_value);
2085:

Line 2184: g_debug := hr_utility.debug_enabled ;

2180: l_payroll_id NUMBER;
2181: l_hire_date DATE;
2182:
2183: BEGIN
2184: g_debug := hr_utility.debug_enabled ;
2185: l_procedure := g_package || 'delete_retrenchment_entry' ;
2186: p_message_name := 'SUCCESS';
2187: pay_in_utils.null_message (p_token_name, p_token_value);
2188:

Line 2295: g_debug := hr_utility.debug_enabled ;

2291: l_prev_sec_and_he_cess NUMBER;
2292:
2293:
2294: BEGIN
2295: g_debug := hr_utility.debug_enabled ;
2296: l_procedure := g_package || 'create_vrs_entry' ;
2297: p_message_name := 'SUCCESS';
2298: pay_in_utils.null_message (p_token_name, p_token_value);
2299:

Line 2458: g_debug := hr_utility.debug_enabled ;

2454: l_payroll_id NUMBER;
2455: l_hire_date DATE;
2456:
2457: BEGIN
2458: g_debug := hr_utility.debug_enabled ;
2459: l_procedure := g_package || 'delete_vrs_entry' ;
2460: p_message_name := 'SUCCESS';
2461: pay_in_utils.null_message (p_token_name, p_token_value);
2462:

Line 2544: g_debug := hr_utility.debug_enabled ;

2540: l_ee_exists BOOLEAN;
2541: l_element_processed BOOLEAN;
2542:
2543: BEGIN
2544: g_debug := hr_utility.debug_enabled ;
2545: l_procedure := g_package || 'create_pension_entry' ;
2546: p_message_name := 'SUCCESS';
2547: pay_in_utils.null_message (p_token_name, p_token_value);
2548:

Line 2649: g_debug := hr_utility.debug_enabled ;

2645: l_payroll_id NUMBER;
2646: l_hire_date DATE;
2647:
2648: BEGIN
2649: g_debug := hr_utility.debug_enabled ;
2650: l_procedure := g_package || 'delete_pension_entry' ;
2651: p_message_name := 'SUCCESS';
2652: pay_in_utils.null_message (p_token_name, p_token_value);
2653:

Line 2798: g_debug := hr_utility.debug_enabled ;

2794: AND ppa.action_status = 'C' ;
2795:
2796:
2797: BEGIN
2798: g_debug := hr_utility.debug_enabled ;
2799: l_procedure := g_package || 'create_advances_entry' ;
2800: p_message_name := 'SUCCESS';
2801: pay_in_utils.null_message (p_token_name, p_token_value);
2802:

Line 2933: g_debug := hr_utility.debug_enabled ;

2929: and p_actual_termination_date between pet.effective_start_date and pet.effective_end_date;
2930:
2931:
2932: BEGIN
2933: g_debug := hr_utility.debug_enabled ;
2934: l_procedure := g_package || 'delete_advances_entry' ;
2935: p_message_name := 'SUCCESS';
2936: pay_in_utils.null_message (p_token_name, p_token_value);
2937:

Line 3020: g_debug := hr_utility.debug_enabled ;

3016: l_ee_exists BOOLEAN;
3017: l_element_processed BOOLEAN;
3018:
3019: BEGIN
3020: g_debug := hr_utility.debug_enabled ;
3021: l_procedure := g_package || 'create_pf_entry' ;
3022: p_message_name := 'SUCCESS';
3023: pay_in_utils.null_message (p_token_name, p_token_value);
3024:

Line 3129: g_debug := hr_utility.debug_enabled ;

3125: l_payroll_id NUMBER;
3126: l_hire_date DATE;
3127:
3128: BEGIN
3129: g_debug := hr_utility.debug_enabled ;
3130: l_procedure := g_package || 'delete_pf_entry' ;
3131: p_message_name := 'SUCCESS';
3132: pay_in_utils.null_message (p_token_name, p_token_value);
3133:

Line 3263: g_debug := hr_utility.debug_enabled ;

3259: AND ppa.action_status = 'C' ;
3260:
3261: l_asact_id pay_assignment_actions.assignment_action_id%TYPE;
3262: BEGIN
3263: g_debug := hr_utility.debug_enabled ;
3264: l_procedure := g_package || 'create_loan_entry' ;
3265: p_message_name := 'SUCCESS';
3266: pay_in_utils.null_message (p_token_name, p_token_value);
3267:

Line 3445: g_debug := hr_utility.debug_enabled ;

3441: l_loan_type pay_element_entry_values_f.screen_entry_value%TYPE;
3442:
3443:
3444: BEGIN
3445: g_debug := hr_utility.debug_enabled ;
3446: l_procedure := g_package || 'delete_loan_entry' ;
3447: p_message_name := 'SUCCESS';
3448: pay_in_utils.null_message (p_token_name, p_token_value);
3449:

Line 3572: g_debug := hr_utility.debug_enabled ;

3568: l_print_leav_reas VARCHAR2(50);
3569: l_efile_leav_reas VARCHAR2 (50);
3570:
3571: BEGIN
3572: g_debug := hr_utility.debug_enabled ;
3573: l_procedure := g_package || 'check_PF_leav_reasons' ;
3574: p_message_name := 'SUCCESS';
3575: pay_in_utils.null_message (p_token_name, p_token_value);
3576: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

Line 3638: g_debug := hr_utility.debug_enabled ;

3634: IS
3635: l_procedure VARCHAR2(100);
3636:
3637: BEGIN
3638: g_debug := hr_utility.debug_enabled ;
3639: l_procedure := g_package || 'create_termination_elements' ;
3640: p_message_name := 'SUCCESS';
3641: pay_in_utils.null_message (p_token_name, p_token_value);
3642:

Line 3838: g_debug := hr_utility.debug_enabled ;

3834: IS
3835: l_procedure VARCHAR2(100);
3836:
3837: BEGIN
3838: g_debug := hr_utility.debug_enabled ;
3839: l_procedure := g_package || 'delete_termination_elements' ;
3840: p_message_name := 'SUCCESS';
3841: pay_in_utils.null_message (p_token_name, p_token_value);
3842:

Line 4020: g_debug := hr_utility.debug_enabled;

4016: g_package VARCHAR2(100);
4017:
4018: BEGIN
4019: --
4020: g_debug := hr_utility.debug_enabled;
4021: l_procedure := g_package||'get_value_on_termination';
4022: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
4023:
4024: l_def_bal_id := pay_in_tax_utils.get_defined_balance(p_balance_name, p_dimension_name);