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

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

38: BEGIN
39:
40: g_debug := hr_utility.debug_enabled;
41: l_procedure := g_package ||'replace_comma';
42: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
43:
44: IF g_template = 'PAYINPFEF'
45: THEN
46: l_string := REPLACE(p_string,',',' ');

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

46: l_string := REPLACE(p_string,',',' ');
47: ELSE
48: l_string := p_string ;
49: END IF ;
50: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
51:
52: RETURN l_string;
53:
54: EXCEPTION

Line 56: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);

52: RETURN l_string;
53:
54: EXCEPTION
55: WHEN OTHERS THEN
56: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);
57: RAISE;
58: END replace_comma;
59:
60: --------------------------------------------------------------------------

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

84: BEGIN
85:
86: g_debug := hr_utility.debug_enabled;
87: l_procedure := g_package ||'format_number';
88: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
89:
90: IF g_template = 'PAYINPFPC'
91: THEN
92: RETURN pay_us_employee_payslip_web.get_format_value(g_bg_id,p_number) ;

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

93: ELSE
94: RETURN p_number;
95: END IF ;
96:
97: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
98:
99: EXCEPTION
100: WHEN OTHERS THEN
101: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);

Line 101: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);

97: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
98:
99: EXCEPTION
100: WHEN OTHERS THEN
101: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);
102: RAISE;
103: END format_number;
104:
105: --------------------------------------------------------------------------

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

245:
246: BEGIN
247: g_debug := hr_utility.debug_enabled;
248: l_procedure := g_package ||'create_level2_3_xml';
249: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
250:
251: l_total_pf_wages := 0;
252: l_total_epf := 0;
253: l_epf_admin := 0;

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

550: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
551:
552: -- Level3 Ends.
553:
554: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
555:
556: EXCEPTION
557:
558: WHEN OTHERS THEN

Line 559: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);

555:
556: EXCEPTION
557:
558: WHEN OTHERS THEN
559: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);
560: RAISE;
561:
562: END create_level2_3_xml;
563:

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

629: BEGIN
630:
631: g_debug := hr_utility.debug_enabled;
632: l_procedure := g_package ||'create_level4_xml';
633: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
634:
635: l_tag := '';
636: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
637:

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

690:
691: l_tag := '';
692: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
693:
694: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
695:
696: EXCEPTION
697:
698: WHEN OTHERS THEN

Line 699: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);

695:
696: EXCEPTION
697:
698: WHEN OTHERS THEN
699: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);
700: RAISE;
701:
702: END create_level4_xml ;
703:

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

765: BEGIN
766:
767: g_debug := hr_utility.debug_enabled;
768: l_procedure := g_package ||'create_level5_xml';
769: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
770:
771: l_tag := '';
772: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
773:

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

807: l_tag := '';
808: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
809:
810:
811: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
812:
813: EXCEPTION
814:
815: WHEN OTHERS THEN

Line 816: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);

812:
813: EXCEPTION
814:
815: WHEN OTHERS THEN
816: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);
817: RAISE;
818: END create_level5_xml ;
819:
820:

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

880: BEGIN
881:
882: g_debug := hr_utility.debug_enabled;
883: l_procedure := g_package ||'create_level6_xml';
884: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
885:
886:
887: l_tag := '';
888: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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

923: l_tag := '';
924: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
925:
926:
927: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
928:
929: EXCEPTION
930:
931: WHEN OTHERS THEN

Line 932: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);

928:
929: EXCEPTION
930:
931: WHEN OTHERS THEN
932: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);
933: RAISE;
934:
935: END create_level6_xml ;
936:

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

999: BEGIN
1000:
1001: g_debug := hr_utility.debug_enabled;
1002: l_procedure := g_package ||'create_level7_xml';
1003: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1004:
1005:
1006: l_tag := '';
1007: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 1055: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,20);

1051: l_tag := '';
1052: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1053:
1054:
1055: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,20);
1056:
1057: EXCEPTION
1058:
1059: WHEN OTHERS THEN

Line 1060: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);

1056:
1057: EXCEPTION
1058:
1059: WHEN OTHERS THEN
1060: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);
1061: RAISE;
1062:
1063: END create_level7_xml ;
1064:

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

1121:
1122: BEGIN
1123: g_debug := hr_utility.debug_enabled;
1124: l_procedure := g_package ||'create_level8_xml';
1125: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1126:
1127:
1128: OPEN csr_filer_id ;
1129: FETCH csr_filer_id INTO l_filer_license_id ;

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

1167: l_tag := '';
1168: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1169:
1170:
1171: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1172:
1173: EXCEPTION
1174:
1175: WHEN OTHERS THEN

Line 1176: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);

1172:
1173: EXCEPTION
1174:
1175: WHEN OTHERS THEN
1176: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);
1177: RAISE;
1178:
1179: END create_level8_xml ;
1180:

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

1274:
1275: BEGIN
1276: g_debug := hr_utility.debug_enabled;
1277: l_procedure := g_package ||'create_level1_xml';
1278: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1279:
1280:
1281: l_tag := '';
1282: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 1330: pay_in_utils.set_location(g_debug,'Calling : create_level2_3_xml',1);

1326:
1327: l_tag := pay_in_xml_utils.getTag('c_1_pup',l_pup);
1328: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1329:
1330: pay_in_utils.set_location(g_debug,'Calling : create_level2_3_xml',1);
1331: create_level2_3_xml(p_business_number => p_business_number
1332: ,p_pf_arc_ref_no => p_pf_arc_ref_no
1333: ,p_action_context_id => l_action_context_id
1334: ,p_year => p_year

Line 1340: pay_in_utils.set_location(g_debug,'Calling : create_level4_xml',2);

1336: ,p_nssn => p_nssn
1337: ,p_sort_by => p_sort_by
1338: ,p_total_ncp => l_total_ncp
1339: );
1340: pay_in_utils.set_location(g_debug,'Calling : create_level4_xml',2);
1341: create_level4_xml(p_business_number => p_business_number
1342: ,p_action_context_id => l_action_context_id
1343: ,p_year => p_year
1344: ,p_month => p_month

Line 1347: pay_in_utils.set_location(g_debug,'Calling : create_level5_xml',3);

1343: ,p_year => p_year
1344: ,p_month => p_month
1345: );
1346:
1347: pay_in_utils.set_location(g_debug,'Calling : create_level5_xml',3);
1348: create_level5_xml(p_business_number => p_business_number
1349: ,p_action_context_id => l_action_context_id
1350: );
1351:

Line 1352: pay_in_utils.set_location(g_debug,'Calling : create_level6_xml',4);

1348: create_level5_xml(p_business_number => p_business_number
1349: ,p_action_context_id => l_action_context_id
1350: );
1351:
1352: pay_in_utils.set_location(g_debug,'Calling : create_level6_xml',4);
1353: create_level6_xml(p_business_number => p_business_number
1354: ,p_action_context_id => l_action_context_id
1355: );
1356:

Line 1357: pay_in_utils.set_location(g_debug,'Calling : create_level7_xml',5);

1353: create_level6_xml(p_business_number => p_business_number
1354: ,p_action_context_id => l_action_context_id
1355: );
1356:
1357: pay_in_utils.set_location(g_debug,'Calling : create_level7_xml',5);
1358: create_level7_xml(p_business_number => p_business_number
1359: ,p_action_context_id => l_action_context_id
1360: );
1361:

Line 1362: pay_in_utils.set_location(g_debug,'Calling : create_level8_xml',6);

1358: create_level7_xml(p_business_number => p_business_number
1359: ,p_action_context_id => l_action_context_id
1360: );
1361:
1362: pay_in_utils.set_location(g_debug,'Calling : create_level8_xml',6);
1363: create_level8_xml(p_business_number => p_business_number
1364: ,p_action_context_id => l_action_context_id
1365: ,p_total_ncp => l_total_ncp
1366: ,p_filer_license_no => p_filer_license_no

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

1370: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1371:
1372:
1373:
1374: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1375: EXCEPTION
1376:
1377: WHEN OTHERS THEN
1378: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);

Line 1378: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);

1374: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1375: EXCEPTION
1376:
1377: WHEN OTHERS THEN
1378: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);
1379: RAISE;
1380:
1381: END create_level1_xml;
1382:

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

1450: BEGIN
1451: --
1452: g_debug := hr_utility.debug_enabled;
1453: l_procedure := g_package ||'init_code';
1454: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1455:
1456: g_template := p_template_name ;
1457:
1458: g_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');

Line 1461: pay_in_utils.trace('p_pf_business_no ',p_pf_business_no );

1457:
1458: g_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
1459:
1460: IF g_debug THEN
1461: pay_in_utils.trace('p_pf_business_no ',p_pf_business_no );
1462: pay_in_utils.trace('p_pf_arc_ref_no ',p_pf_arc_ref_no );
1463: pay_in_utils.trace('p_return_type ',p_return_type );
1464: pay_in_utils.trace('p_year ',p_year );
1465: pay_in_utils.trace('p_month ',p_month );

Line 1462: pay_in_utils.trace('p_pf_arc_ref_no ',p_pf_arc_ref_no );

1458: g_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
1459:
1460: IF g_debug THEN
1461: pay_in_utils.trace('p_pf_business_no ',p_pf_business_no );
1462: pay_in_utils.trace('p_pf_arc_ref_no ',p_pf_arc_ref_no );
1463: pay_in_utils.trace('p_return_type ',p_return_type );
1464: pay_in_utils.trace('p_year ',p_year );
1465: pay_in_utils.trace('p_month ',p_month );
1466: pay_in_utils.trace('p_filer_license_no ',p_filer_license_no);

Line 1463: pay_in_utils.trace('p_return_type ',p_return_type );

1459:
1460: IF g_debug THEN
1461: pay_in_utils.trace('p_pf_business_no ',p_pf_business_no );
1462: pay_in_utils.trace('p_pf_arc_ref_no ',p_pf_arc_ref_no );
1463: pay_in_utils.trace('p_return_type ',p_return_type );
1464: pay_in_utils.trace('p_year ',p_year );
1465: pay_in_utils.trace('p_month ',p_month );
1466: pay_in_utils.trace('p_filer_license_no ',p_filer_license_no);
1467: pay_in_utils.trace('p_nssn ',p_nssn );

Line 1464: pay_in_utils.trace('p_year ',p_year );

1460: IF g_debug THEN
1461: pay_in_utils.trace('p_pf_business_no ',p_pf_business_no );
1462: pay_in_utils.trace('p_pf_arc_ref_no ',p_pf_arc_ref_no );
1463: pay_in_utils.trace('p_return_type ',p_return_type );
1464: pay_in_utils.trace('p_year ',p_year );
1465: pay_in_utils.trace('p_month ',p_month );
1466: pay_in_utils.trace('p_filer_license_no ',p_filer_license_no);
1467: pay_in_utils.trace('p_nssn ',p_nssn );
1468: pay_in_utils.trace('p_sort_by ',p_sort_by );

Line 1465: pay_in_utils.trace('p_month ',p_month );

1461: pay_in_utils.trace('p_pf_business_no ',p_pf_business_no );
1462: pay_in_utils.trace('p_pf_arc_ref_no ',p_pf_arc_ref_no );
1463: pay_in_utils.trace('p_return_type ',p_return_type );
1464: pay_in_utils.trace('p_year ',p_year );
1465: pay_in_utils.trace('p_month ',p_month );
1466: pay_in_utils.trace('p_filer_license_no ',p_filer_license_no);
1467: pay_in_utils.trace('p_nssn ',p_nssn );
1468: pay_in_utils.trace('p_sort_by ',p_sort_by );
1469: pay_in_utils.trace('g_bg_id ',g_bg_id );

Line 1466: pay_in_utils.trace('p_filer_license_no ',p_filer_license_no);

1462: pay_in_utils.trace('p_pf_arc_ref_no ',p_pf_arc_ref_no );
1463: pay_in_utils.trace('p_return_type ',p_return_type );
1464: pay_in_utils.trace('p_year ',p_year );
1465: pay_in_utils.trace('p_month ',p_month );
1466: pay_in_utils.trace('p_filer_license_no ',p_filer_license_no);
1467: pay_in_utils.trace('p_nssn ',p_nssn );
1468: pay_in_utils.trace('p_sort_by ',p_sort_by );
1469: pay_in_utils.trace('g_bg_id ',g_bg_id );
1470: END IF;

Line 1467: pay_in_utils.trace('p_nssn ',p_nssn );

1463: pay_in_utils.trace('p_return_type ',p_return_type );
1464: pay_in_utils.trace('p_year ',p_year );
1465: pay_in_utils.trace('p_month ',p_month );
1466: pay_in_utils.trace('p_filer_license_no ',p_filer_license_no);
1467: pay_in_utils.trace('p_nssn ',p_nssn );
1468: pay_in_utils.trace('p_sort_by ',p_sort_by );
1469: pay_in_utils.trace('g_bg_id ',g_bg_id );
1470: END IF;
1471:

Line 1468: pay_in_utils.trace('p_sort_by ',p_sort_by );

1464: pay_in_utils.trace('p_year ',p_year );
1465: pay_in_utils.trace('p_month ',p_month );
1466: pay_in_utils.trace('p_filer_license_no ',p_filer_license_no);
1467: pay_in_utils.trace('p_nssn ',p_nssn );
1468: pay_in_utils.trace('p_sort_by ',p_sort_by );
1469: pay_in_utils.trace('g_bg_id ',g_bg_id );
1470: END IF;
1471:
1472: l_month := TO_NUMBER(p_month) + 3 ;

Line 1469: pay_in_utils.trace('g_bg_id ',g_bg_id );

1465: pay_in_utils.trace('p_month ',p_month );
1466: pay_in_utils.trace('p_filer_license_no ',p_filer_license_no);
1467: pay_in_utils.trace('p_nssn ',p_nssn );
1468: pay_in_utils.trace('p_sort_by ',p_sort_by );
1469: pay_in_utils.trace('g_bg_id ',g_bg_id );
1470: END IF;
1471:
1472: l_month := TO_NUMBER(p_month) + 3 ;
1473: l_year := SUBSTR(p_year,1,4);

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

1509:
1510:
1511: p_xml := g_xml_data;
1512:
1513: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
1514:
1515: EXCEPTION
1516:
1517: WHEN OTHERS THEN

Line 1518: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);

1514:
1515: EXCEPTION
1516:
1517: WHEN OTHERS THEN
1518: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);
1519: RAISE;
1520:
1521:
1522: END init_code;