DBA Data[Home] [Help]

APPS.PAY_IN_FF_PKG dependencies on HR_UTILITY

Line 46: g_debug:= hr_utility.debug_enabled;

42: l_emp_cat VARCHAR2(10);
43: l_procedure VARCHAR2(100);
44: l_message VARCHAR2(1000);
45: BEGIN
46: g_debug:= hr_utility.debug_enabled;
47: l_procedure:= g_package ||'check_retainer';
48:
49: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
50:

Line 77: hr_utility.trace(l_message);

73: EXCEPTION
74: WHEN OTHERS THEN
75: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
76: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
77: hr_utility.trace(l_message);
78: RETURN NULL;
79: END check_retainer;
80:
81: --------------------------------------------------------------------------

Line 116: g_debug:= hr_utility.debug_enabled;

112: l_procedure VARCHAR2(100);
113: l_edli VARCHAR2(1);
114: l_message VARCHAR2(1000);
115: BEGIN
116: g_debug:= hr_utility.debug_enabled;
117: l_procedure:= g_package ||'check_retainer';
118:
119: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
120:

Line 142: hr_utility.trace(l_message);

138: EXCEPTION
139: WHEN OTHERS THEN
140: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
141: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
142: hr_utility.trace(l_message);
143: RETURN NULL;
144: END check_edli;
145:
146: --------------------------------------------------------------------------

Line 235: g_debug:= hr_utility.debug_enabled;

231: l_virtual_asact_id NUMBER;
232: l_message VARCHAR2(1000);
233:
234: BEGIN
235: g_debug:= hr_utility.debug_enabled;
236: l_procedure := g_package ||'get_esi_cont_amt';
237: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
238:
239: l_half_year_start1:='01-04-';

Line 336: hr_utility.trace(l_message);

332: EXCEPTION
333: WHEN OTHERS THEN
334: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
335: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 100);
336: hr_utility.trace(l_message);
337: RETURN NULL;
338: END get_esi_cont_amt;
339:
340:

Line 395: g_debug := hr_utility.debug_enabled;

391: l_procedure VARCHAR2(250);
392: l_message VARCHAR2(250);
393:
394: BEGIN
395: g_debug := hr_utility.debug_enabled;
396: l_procedure := g_package ||'get_esi_disability_details';
397: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
398:
399: l_half_year_start1:='01-04-';

Line 485: g_debug := hr_utility.debug_enabled;

481: n NUMBER;
482: l_number NUMBER;
483: l_procedure VARCHAR2(100);
484: BEGIN
485: g_debug := hr_utility.debug_enabled;
486: l_procedure := g_package ||'round_to_5paise';
487: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
488:
489:

Line 557: g_debug := hr_utility.debug_enabled;

553: AND pap.accrual_plan_element_type_id = pet.element_type_id
554: AND pap.accrual_category = p_plan_category ;
555:
556: BEGIN
557: g_debug := hr_utility.debug_enabled;
558: l_procedure := g_package ||'get_accrual_plan';
559: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
560:
561:

Line 597: hr_utility.trace(l_message);

593: EXCEPTION
594: WHEN OTHERS THEN
595: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
596: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
597: hr_utility.trace(l_message);
598: RETURN NULL;
599:
600: END get_accrual_plan;
601:

Line 642: g_debug:= hr_utility.debug_enabled;

638: l_message VARCHAR2(1000);
639:
640: BEGIN
641:
642: g_debug:= hr_utility.debug_enabled;
643: l_procedure := g_package ||'get_net_accrual';
644: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
645:
646: IF g_debug THEN

Line 687: hr_utility.trace(l_message);

683: EXCEPTION
684: WHEN OTHERS THEN
685: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
686: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
687: hr_utility.trace(l_message);
688: RETURN NULL;
689:
690:
691: END get_net_accrual;

Line 729: g_debug := hr_utility.debug_enabled;

725: l_procedure VARCHAR2(100);
726: l_message VARCHAR2(1000);
727:
728: BEGIN
729: g_debug := hr_utility.debug_enabled;
730: l_procedure := g_package ||'get_period_number';
731: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
732:
733:

Line 759: hr_utility.trace(l_message);

755: EXCEPTION
756: WHEN OTHERS THEN
757: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
758: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
759: hr_utility.trace(l_message);
760: RETURN NULL;
761:
762:
763: END get_period_number;

Line 810: g_debug := hr_utility.debug_enabled;

806: l_80_percent number;
807: l_procedure varchar2(100);
808:
809: BEGIN
810: g_debug := hr_utility.debug_enabled;
811: l_procedure := g_package ||'sec_80dd_percent';
812: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
813:
814:

Line 897: g_debug := hr_utility.debug_enabled ;

893: l_spouse_exists NUMBER;
894:
895: BEGIN
896:
897: g_debug := hr_utility.debug_enabled ;
898: l_procedure := g_package||'check_father_husband_name' ;
899: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
900:
901: IF g_debug THEN

Line 1062: g_debug := hr_utility.debug_enabled;

1058: l_asg_start_date DATE;
1059: l_procedure varchar2(100);
1060:
1061: BEGIN
1062: g_debug := hr_utility.debug_enabled;
1063: l_procedure := g_package ||'check_gre_update';
1064: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1065:
1066:

Line 1132: hr_utility.trace('ven_Inside ESI Error message condition');

1128: p_token_name(1) := 'ORG';
1129: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PF_ORG');
1130: ELSIF (p_esi IS NOT NULL) AND (p_esi <> l_esi_org_id)
1131: THEN
1132: hr_utility.trace('ven_Inside ESI Error message condition');
1133: p_message := 'PER_IN_SCL_CHANGE_FORBIDDEN';
1134: p_token_name(1) := 'ORG';
1135: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','ESI_ORG');
1136: ELSE

Line 1224: g_debug := hr_utility.debug_enabled;

1220: l_message_name VARCHAR2(100);
1221: l_token_value VARCHAR2(10);
1222:
1223: BEGIN
1224: g_debug := hr_utility.debug_enabled;
1225: l_procedure := g_package ||'check_pf_update';
1226: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
1227:
1228: IF g_debug THEN

Line 1252: hr_utility.set_message(800, 'PER_IN_CONTACT_DETAILS');

1248: ,p_message_name =>l_message_name
1249: ,p_token_value =>l_token_value
1250: );
1251: IF l_message_name = 'PER_IN_CONTACT_DETAILS' THEN
1252: hr_utility.set_message(800, 'PER_IN_CONTACT_DETAILS');
1253: hr_utility.set_message_token('RELATION',l_token_value);
1254: hr_utility.raise_error;
1255: ELSIF l_message_name <> 'SUCCESS' THEN
1256: hr_utility.set_message(800, l_message_name);

Line 1253: hr_utility.set_message_token('RELATION',l_token_value);

1249: ,p_token_value =>l_token_value
1250: );
1251: IF l_message_name = 'PER_IN_CONTACT_DETAILS' THEN
1252: hr_utility.set_message(800, 'PER_IN_CONTACT_DETAILS');
1253: hr_utility.set_message_token('RELATION',l_token_value);
1254: hr_utility.raise_error;
1255: ELSIF l_message_name <> 'SUCCESS' THEN
1256: hr_utility.set_message(800, l_message_name);
1257: hr_utility.raise_error;

Line 1254: hr_utility.raise_error;

1250: );
1251: IF l_message_name = 'PER_IN_CONTACT_DETAILS' THEN
1252: hr_utility.set_message(800, 'PER_IN_CONTACT_DETAILS');
1253: hr_utility.set_message_token('RELATION',l_token_value);
1254: hr_utility.raise_error;
1255: ELSIF l_message_name <> 'SUCCESS' THEN
1256: hr_utility.set_message(800, l_message_name);
1257: hr_utility.raise_error;
1258: END IF;

Line 1256: hr_utility.set_message(800, l_message_name);

1252: hr_utility.set_message(800, 'PER_IN_CONTACT_DETAILS');
1253: hr_utility.set_message_token('RELATION',l_token_value);
1254: hr_utility.raise_error;
1255: ELSIF l_message_name <> 'SUCCESS' THEN
1256: hr_utility.set_message(800, l_message_name);
1257: hr_utility.raise_error;
1258: END IF;
1259: */
1260: check_gre_update

Line 1257: hr_utility.raise_error;

1253: hr_utility.set_message_token('RELATION',l_token_value);
1254: hr_utility.raise_error;
1255: ELSIF l_message_name <> 'SUCCESS' THEN
1256: hr_utility.set_message(800, l_message_name);
1257: hr_utility.raise_error;
1258: END IF;
1259: */
1260: check_gre_update
1261: (p_effective_date => p_effective_date

Line 1376: g_debug := hr_utility.debug_enabled;

1372: l_warning BOOLEAN;
1373: l_procedure varchar2(100);
1374:
1375: BEGIN
1376: g_debug := hr_utility.debug_enabled;
1377: l_procedure := g_package ||'in_reset_input_values';
1378: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1379:
1380:

Line 1463: g_debug := hr_utility.debug_enabled;

1459:
1460: l_location_id hr_all_organization_units.location_id%TYPE;
1461:
1462: BEGIN
1463: g_debug := hr_utility.debug_enabled;
1464: l_procedure := g_package ||'check_pf_location';
1465: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1466:
1467: p_message_name := 'SUCCESS';

Line 1541: g_debug := hr_utility.debug_enabled;

1537: l_state hr_lookups.lookup_code%TYPE;
1538: l_procedure VARCHAR2(100);
1539: BEGIN
1540: l_procedure := g_package||'get_lwf_state';
1541: g_debug := hr_utility.debug_enabled;
1542: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure, 10);
1543: OPEN csr_state ;
1544: FETCH csr_state INTO l_state;
1545: pay_in_utils.set_location (g_debug,'l_state = '||l_state,20);

Line 1553: hr_utility.trace(l_message);

1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1552: pay_in_utils.set_location(g_debug,' Leaving : '||l_procedure, 40);
1553: hr_utility.trace(l_message);
1554: RETURN NULL;
1555: END get_lwf_state;
1556:
1557: --------------------------------------------------------------------------

Line 1604: g_debug := hr_utility.debug_enabled;

1600:
1601: BEGIN
1602:
1603: l_procedure := g_package||'get_org_id';
1604: g_debug := hr_utility.debug_enabled;
1605: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure, 10);
1606:
1607: IF g_debug THEN
1608: pay_in_utils.trace('**************************************************','********************');

Line 1641: hr_utility.trace(l_message);

1637: EXCEPTION
1638: WHEN OTHERS THEN
1639: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1640: pay_in_utils.set_location(g_debug,' Leaving : '||l_procedure, 30);
1641: hr_utility.trace(l_message);
1642: RETURN NULL;
1643:
1644:
1645: END get_org_id;