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.22 2008/01/12 17:12:23 lnagaraj noship $ */
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 1440: l_message := pay_in_utils.get_pay_message

1436:
1437: EXCEPTION
1438: WHEN OTHERS THEN
1439: set_location(g_debug, 'Leaving: '||l_procedure,30);
1440: l_message := pay_in_utils.get_pay_message
1441: ('PER_IN_ORACLE_GENERIC_ERROR',
1442: 'FUNCTION:'||l_procedure,
1443: 'SQLERRMC:'||SQLERRM);
1444: trace('SQLERRM',l_message);

Line 1488: l_message := pay_in_utils.get_pay_message

1484:
1485: EXCEPTION
1486: WHEN OTHERS THEN
1487: set_location(g_debug, 'Leaving: '||l_procedure,30);
1488: l_message := pay_in_utils.get_pay_message
1489: ('PER_IN_ORACLE_GENERIC_ERROR',
1490: 'FUNCTION:'||l_procedure,
1491: 'SQLERRMC:'||SQLERRM);
1492: trace('SQLERRM',l_message);

Line 1534: l_message := pay_in_utils.get_pay_message

1530:
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: set_location(g_debug, 'Leaving: '||l_procedure,30);
1534: l_message := pay_in_utils.get_pay_message
1535: ('PER_IN_ORACLE_GENERIC_ERROR',
1536: 'FUNCTION:'||l_procedure,
1537: 'SQLERRMC:'||SQLERRM);
1538: trace('SQLERRM',l_message);

Line 1594: l_message := pay_in_utils.get_pay_message

1590:
1591: EXCEPTION
1592: WHEN OTHERS THEN
1593: set_location(g_debug, 'Leaving: '||l_procedure,30);
1594: l_message := pay_in_utils.get_pay_message
1595: ('PER_IN_ORACLE_GENERIC_ERROR',
1596: 'FUNCTION:'||l_procedure,
1597: 'SQLERRMC:'||SQLERRM);
1598: trace('SQLERRM',l_message);

Line 1644: l_message := pay_in_utils.get_pay_message

1640:
1641: EXCEPTION
1642: WHEN OTHERS THEN
1643: set_location(g_debug, 'Leaving: '||l_procedure,30);
1644: l_message := pay_in_utils.get_pay_message
1645: ('PER_IN_ORACLE_GENERIC_ERROR',
1646: 'FUNCTION:'||l_procedure,
1647: 'SQLERRMC:'||SQLERRM);
1648: trace('SQLERRM',l_message);

Line 1692: l_message := pay_in_utils.get_pay_message

1688: WHEN NO_DATA_FOUND THEN
1689: RETURN TO_NUMBER(NULL);
1690: WHEN OTHERS THEN
1691: set_location(g_debug, 'Leaving: '||l_procedure,30);
1692: l_message := pay_in_utils.get_pay_message
1693: ('PER_IN_ORACLE_GENERIC_ERROR',
1694: 'FUNCTION:'||l_procedure,
1695: 'SQLERRMC:'||SQLERRM);
1696: trace('SQLERRM',l_message);

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

2598: l_message VARCHAR2(250);
2599: BEGIN
2600: g_debug := hr_utility.debug_enabled;
2601: l_procedure := g_package ||'get_age';
2602: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2603: IF (g_debug)
2604: THEN
2605: pay_in_utils.trace('**************************************************','********************');
2606: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

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

2601: l_procedure := g_package ||'get_age';
2602: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2603: IF (g_debug)
2604: THEN
2605: pay_in_utils.trace('**************************************************','********************');
2606: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
2607: pay_in_utils.trace('p_person_id',p_person_id);
2608: pay_in_utils.trace('p_effective_date',p_effective_date);
2609: END IF;

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

2602: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2603: IF (g_debug)
2604: THEN
2605: pay_in_utils.trace('**************************************************','********************');
2606: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
2607: pay_in_utils.trace('p_person_id',p_person_id);
2608: pay_in_utils.trace('p_effective_date',p_effective_date);
2609: END IF;
2610:

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

2603: IF (g_debug)
2604: THEN
2605: pay_in_utils.trace('**************************************************','********************');
2606: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
2607: pay_in_utils.trace('p_person_id',p_person_id);
2608: pay_in_utils.trace('p_effective_date',p_effective_date);
2609: END IF;
2610:
2611:

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

2604: THEN
2605: pay_in_utils.trace('**************************************************','********************');
2606: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
2607: pay_in_utils.trace('p_person_id',p_person_id);
2608: pay_in_utils.trace('p_effective_date',p_effective_date);
2609: END IF;
2610:
2611:
2612: Open c_dob;

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

2617: l_age := trunc((p_effective_date - l_dob)/365);
2618:
2619: IF (g_debug)
2620: THEN
2621: pay_in_utils.trace('l_age',l_age);
2622: END IF;
2623:
2624: pay_in_utils.trace('**************************************************','********************');
2625: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

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

2620: THEN
2621: pay_in_utils.trace('l_age',l_age);
2622: END IF;
2623:
2624: pay_in_utils.trace('**************************************************','********************');
2625: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
2626:
2627: Return l_age;
2628:

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

2621: pay_in_utils.trace('l_age',l_age);
2622: END IF;
2623:
2624: pay_in_utils.trace('**************************************************','********************');
2625: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
2626:
2627: Return l_age;
2628:
2629: END get_age;

Line 2703: g_package := 'pay_in_utils.';

2699:
2700: END get_prev_ltc_block;
2701:
2702: BEGIN
2703: g_package := 'pay_in_utils.';
2704:
2705: END pay_in_utils;

Line 2705: END pay_in_utils;

2701:
2702: BEGIN
2703: g_package := 'pay_in_utils.';
2704:
2705: END pay_in_utils;