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

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

Line 2461: g_debug := hr_utility.debug_enabled ;

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

Line 2547: g_debug := hr_utility.debug_enabled ;

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

Line 2652: g_debug := hr_utility.debug_enabled ;

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

Line 2801: g_debug := hr_utility.debug_enabled ;

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

Line 2936: g_debug := hr_utility.debug_enabled ;

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

Line 3023: g_debug := hr_utility.debug_enabled ;

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

Line 3132: g_debug := hr_utility.debug_enabled ;

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

Line 3266: g_debug := hr_utility.debug_enabled ;

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

Line 3448: g_debug := hr_utility.debug_enabled ;

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

Line 3575: g_debug := hr_utility.debug_enabled ;

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

Line 3641: g_debug := hr_utility.debug_enabled ;

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

Line 3841: g_debug := hr_utility.debug_enabled ;

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

Line 4023: g_debug := hr_utility.debug_enabled;

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