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_UTILS dependencies on PAY_IN_UTILS

Line 1: PACKAGE BODY pay_in_utils AS

1: PACKAGE BODY pay_in_utils AS
2: /* $Header: pyinutil.pkb 120.24.12020000.2 2013/04/02 11:07:17 pthummal ship $ */
3: g_debug BOOLEAN;
4: g_package VARCHAR2(20);
5:

Line 59: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

55: RETURN l_max_act_seq;
56:
57: EXCEPTION
58: WHEN OTHERS THEN
59: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
60: set_location(g_debug,' Leaving : '||l_procedure, 40);
61: trace(l_message,null);
62: RAISE;
63: END get_max_act_sequence;

Line 243: (p_token_name IN OUT NOCOPY pay_in_utils.char_tab_type

239: --------------------------------------------------------------------------
240: -- 1.0 28-AUG-04 statkar Created this function --
241: --------------------------------------------------------------------------
242: PROCEDURE null_message
243: (p_token_name IN OUT NOCOPY pay_in_utils.char_tab_type
244: ,p_token_value IN OUT NOCOPY pay_in_utils.char_tab_type)
245: IS
246:
247: BEGIN

Line 244: ,p_token_value IN OUT NOCOPY pay_in_utils.char_tab_type)

240: -- 1.0 28-AUG-04 statkar Created this function --
241: --------------------------------------------------------------------------
242: PROCEDURE null_message
243: (p_token_name IN OUT NOCOPY pay_in_utils.char_tab_type
244: ,p_token_value IN OUT NOCOPY pay_in_utils.char_tab_type)
245: IS
246:
247: BEGIN
248: p_token_name.delete;

Line 268: ,p_token_name IN OUT NOCOPY pay_in_utils.char_tab_type

264: --------------------------------------------------------------------------
265: PROCEDURE raise_message
266: (p_application_id IN NUMBER
267: ,p_message_name IN VARCHAR2
268: ,p_token_name IN OUT NOCOPY pay_in_utils.char_tab_type
269: ,p_token_value IN OUT NOCOPY pay_in_utils.char_tab_type)
270: IS
271: cnt NUMBER;
272: BEGIN

Line 269: ,p_token_value IN OUT NOCOPY pay_in_utils.char_tab_type)

265: PROCEDURE raise_message
266: (p_application_id IN NUMBER
267: ,p_message_name IN VARCHAR2
268: ,p_token_name IN OUT NOCOPY pay_in_utils.char_tab_type
269: ,p_token_value IN OUT NOCOPY pay_in_utils.char_tab_type)
270: IS
271: cnt NUMBER;
272: BEGIN
273: IF p_message_name IS NOT NULL AND p_message_name <> 'SUCCESS' THEN

Line 973: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

969: set_location(g_debug,'Leaving : '||l_procedure, 30);
970:
971: EXCEPTION
972: WHEN OTHERS THEN
973: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
974: set_location(g_debug,' Leaving : '||l_procedure, 30);
975: trace(l_message,null);
976: RETURN NULL;
977:

Line 1455: l_message := pay_in_utils.get_pay_message

1451:
1452: EXCEPTION
1453: WHEN OTHERS THEN
1454: set_location(g_debug, 'Leaving: '||l_procedure,30);
1455: l_message := pay_in_utils.get_pay_message
1456: ('PER_IN_ORACLE_GENERIC_ERROR',
1457: 'FUNCTION:'||l_procedure,
1458: 'SQLERRMC:'||SQLERRM);
1459: trace('SQLERRM',l_message);

Line 1503: l_message := pay_in_utils.get_pay_message

1499:
1500: EXCEPTION
1501: WHEN OTHERS THEN
1502: set_location(g_debug, 'Leaving: '||l_procedure,30);
1503: l_message := pay_in_utils.get_pay_message
1504: ('PER_IN_ORACLE_GENERIC_ERROR',
1505: 'FUNCTION:'||l_procedure,
1506: 'SQLERRMC:'||SQLERRM);
1507: trace('SQLERRM',l_message);

Line 1549: l_message := pay_in_utils.get_pay_message

1545:
1546: EXCEPTION
1547: WHEN OTHERS THEN
1548: set_location(g_debug, 'Leaving: '||l_procedure,30);
1549: l_message := pay_in_utils.get_pay_message
1550: ('PER_IN_ORACLE_GENERIC_ERROR',
1551: 'FUNCTION:'||l_procedure,
1552: 'SQLERRMC:'||SQLERRM);
1553: trace('SQLERRM',l_message);

Line 1609: l_message := pay_in_utils.get_pay_message

1605:
1606: EXCEPTION
1607: WHEN OTHERS THEN
1608: set_location(g_debug, 'Leaving: '||l_procedure,30);
1609: l_message := pay_in_utils.get_pay_message
1610: ('PER_IN_ORACLE_GENERIC_ERROR',
1611: 'FUNCTION:'||l_procedure,
1612: 'SQLERRMC:'||SQLERRM);
1613: trace('SQLERRM',l_message);

Line 1659: l_message := pay_in_utils.get_pay_message

1655:
1656: EXCEPTION
1657: WHEN OTHERS THEN
1658: set_location(g_debug, 'Leaving: '||l_procedure,30);
1659: l_message := pay_in_utils.get_pay_message
1660: ('PER_IN_ORACLE_GENERIC_ERROR',
1661: 'FUNCTION:'||l_procedure,
1662: 'SQLERRMC:'||SQLERRM);
1663: trace('SQLERRM',l_message);

Line 1707: l_message := pay_in_utils.get_pay_message

1703: WHEN NO_DATA_FOUND THEN
1704: RETURN TO_NUMBER(NULL);
1705: WHEN OTHERS THEN
1706: set_location(g_debug, 'Leaving: '||l_procedure,30);
1707: l_message := pay_in_utils.get_pay_message
1708: ('PER_IN_ORACLE_GENERIC_ERROR',
1709: 'FUNCTION:'||l_procedure,
1710: 'SQLERRMC:'||SQLERRM);
1711: trace('SQLERRM',l_message);

Line 2617: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

2613: l_message VARCHAR2(250);
2614: BEGIN
2615: g_debug := hr_utility.debug_enabled;
2616: l_procedure := g_package ||'get_age';
2617: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2618: IF (g_debug)
2619: THEN
2620: pay_in_utils.trace('**************************************************','********************');
2621: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

Line 2620: pay_in_utils.trace('******************************','');

2616: l_procedure := g_package ||'get_age';
2617: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2618: IF (g_debug)
2619: THEN
2620: pay_in_utils.trace('**************************************************','********************');
2621: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
2622: pay_in_utils.trace('p_person_id',p_person_id);
2623: pay_in_utils.trace('p_effective_date',p_effective_date);
2624: END IF;

Line 2621: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

2617: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2618: IF (g_debug)
2619: THEN
2620: pay_in_utils.trace('**************************************************','********************');
2621: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
2622: pay_in_utils.trace('p_person_id',p_person_id);
2623: pay_in_utils.trace('p_effective_date',p_effective_date);
2624: END IF;
2625:

Line 2622: pay_in_utils.trace('p_person_id',p_person_id);

2618: IF (g_debug)
2619: THEN
2620: pay_in_utils.trace('**************************************************','********************');
2621: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
2622: pay_in_utils.trace('p_person_id',p_person_id);
2623: pay_in_utils.trace('p_effective_date',p_effective_date);
2624: END IF;
2625:
2626:

Line 2623: pay_in_utils.trace('p_effective_date',p_effective_date);

2619: THEN
2620: pay_in_utils.trace('**************************************************','********************');
2621: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
2622: pay_in_utils.trace('p_person_id',p_person_id);
2623: pay_in_utils.trace('p_effective_date',p_effective_date);
2624: END IF;
2625:
2626:
2627: Open c_dob;

Line 2636: pay_in_utils.trace('l_age',l_age);

2632: l_age := trunc((p_effective_date - l_dob)/365);
2633:
2634: IF (g_debug)
2635: THEN
2636: pay_in_utils.trace('l_age',l_age);
2637: END IF;
2638:
2639: pay_in_utils.trace('**************************************************','********************');
2640: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

Line 2639: pay_in_utils.trace('******************************','');

2635: THEN
2636: pay_in_utils.trace('l_age',l_age);
2637: END IF;
2638:
2639: pay_in_utils.trace('**************************************************','********************');
2640: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
2641:
2642: Return l_age;
2643:

Line 2640: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

2636: pay_in_utils.trace('l_age',l_age);
2637: END IF;
2638:
2639: pay_in_utils.trace('**************************************************','********************');
2640: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
2641:
2642: Return l_age;
2643:
2644: END get_age;

Line 2746: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);

2742:
2743: BEGIN
2744:
2745: l_procedure := g_package ||'UPD_PUBLIC_SECTOR_PAY_PERIODS';
2746: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
2747: g_debug := hr_utility.debug_enabled;
2748:
2749: if g_debug then
2750: hr_utility.trace('---------------------------------------');

Line 2763: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 20);

2759: and action_type in ('R', 'Q', 'B', 'V');
2760:
2761: if l_payroll_actions > 0 then
2762:
2763: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 20);
2764: hr_utility.set_location('Leaving: '||l_procedure,25);
2765:
2766: fnd_message.set_name('PER','PER_IN_PAYROLL_ACTIONS_EXIST');
2767: fnd_message.set_token('PAYROLL_ID', p_payroll_id);

Line 2779: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 30);

2775: and sysdate between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
2776:
2777: if l_public_sector_flag ='Y' then
2778:
2779: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 30);
2780:
2781: if l_date_offset =0 then
2782: update per_time_periods
2783: set PERIOD_NAME= decode(to_char(end_date,'MM'),'03',1,'04',2,'05',3,'06',4,'07',5,'08',6,'09',7,'10',8,'11',9,'12',10,'01',11,'02',12)||' '||to_char(end_date,'YYYY')||' Calendar Month',

Line 2797: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 40);

2793:
2794: fnd_message.set_name('PER','PER_IN_PUBLIC_PAYROLL_SUCCESS');
2795: fnd_message.set_token('PAYROLL_ID', p_payroll_id);
2796: fnd_file.put(fnd_file.log, FND_MESSAGE.GET);
2797: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 40);
2798: RETURN;
2799: else
2800: if g_debug then
2801: hr_utility.trace('---------------------------------------');

Line 2806: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 45);

2802: hr_utility.trace('Period Definition is not modified for Public Sector Requirement for payroll id -'||p_payroll_id);
2803: hr_utility.trace('as offset is non-zero value for the payroll.');
2804: end if ;
2805:
2806: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 45);
2807: fnd_message.set_name('PER','PER_IN_DISALLOW_PERIOD_MODIFY');
2808: fnd_message.set_token('PAYROLL_ID', p_payroll_id);
2809: fnd_file.put(fnd_file.log, FND_MESSAGE.GET);
2810: hr_utility.raise_error;

Line 2813: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 50);

2809: fnd_file.put(fnd_file.log, FND_MESSAGE.GET);
2810: hr_utility.raise_error;
2811: end if;
2812: else
2813: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 50);
2814:
2815: fnd_message.set_name('PER','PER_IN_PUBLIC_FLAG_UNSELECTED');
2816: fnd_message.set_token('PAYROLL_ID', p_payroll_id);
2817: fnd_file.put(fnd_file.log, FND_MESSAGE.GET);

Line 2821: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 60);

2817: fnd_file.put(fnd_file.log, FND_MESSAGE.GET);
2818: hr_utility.raise_error;
2819: end if;
2820:
2821: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 60);
2822:
2823: EXCEPTION
2824: WHEN OTHERS THEN
2825: p_errbuf := hr_utility.get_message;

Line 2830: g_package := 'pay_in_utils.';

2826: p_retcode := 2;
2827: END UPD_PUBLIC_SECTOR_PAY_PERIODS;
2828:
2829: BEGIN
2830: g_package := 'pay_in_utils.';
2831:
2832: END pay_in_utils;

Line 2832: END pay_in_utils;

2828:
2829: BEGIN
2830: g_package := 'pay_in_utils.';
2831:
2832: END pay_in_utils;