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_NO_RULES dependencies on HR_UTILITY

Line 88: hr_utility.set_location('pay_no_rules.get_source_text_context',1);

84: BEGIN
85: --
86: l_tax_municipality := null;
87: --
88: hr_utility.set_location('pay_no_rules.get_source_text_context',1);
89: --
90: OPEN csr_get_tax_municipality(p_asg_act_id);
91: FETCH csr_get_tax_municipality INTO l_tax_municipality;
92: CLOSE csr_get_tax_municipality;

Line 96: hr_utility.set_location('pay_no_rules.get_source_text_context='|| p_source_text,2);

92: CLOSE csr_get_tax_municipality;
93: --
94: p_source_text := NVL(l_tax_municipality,' ');
95: --
96: hr_utility.set_location('pay_no_rules.get_source_text_context='|| p_source_text,2);
97: --
98: END get_source_text_context;
99: */
100:

Line 376: hr_utility.set_location('pay_no_rules.get_source_context',1);

372: BEGIN
373: --
374: l_local_unit:= null;
375: --
376: hr_utility.set_location('pay_no_rules.get_source_context',1);
377: --
378: OPEN csr_get_local_unit(p_asg_act_id);
379: FETCH csr_get_local_unit INTO l_local_unit;
380: CLOSE csr_get_local_unit;

Line 384: hr_utility.set_location('pay_no_rules.get_source_context='|| p_source_id,2);

380: CLOSE csr_get_local_unit;
381: --
382: p_source_id := NVL(l_local_unit,' ');
383: --
384: hr_utility.set_location('pay_no_rules.get_source_context='|| p_source_id,2);
385: --
386: END get_source_context;
387: --
388: */

Line 416: hr_utility.set_location('pay_no_rules.get_main_local_unit_id',1);

412: BEGIN
413: --
414: l_local_unit:= null;
415: --
416: hr_utility.set_location('pay_no_rules.get_main_local_unit_id',1);
417: --
418: OPEN csr_get_local_unit(p_assignment_id);
419: FETCH csr_get_local_unit INTO l_local_unit;
420: CLOSE csr_get_local_unit;

Line 424: hr_utility.set_location('pay_no_rules.get_main_local_unit_id='|| p_local_unit_id,2);

420: CLOSE csr_get_local_unit;
421: --
422: p_local_unit_id := NVL(l_local_unit,0);
423: --
424: hr_utility.set_location('pay_no_rules.get_main_local_unit_id='|| p_local_unit_id,2);
425: --
426: END get_main_local_unit_id;
427: ------------------------------------------------------------------------------------------
428: PROCEDURE get_default_jurisdiction(p_asg_act_id NUMBER,

Line 576: hr_utility.set_location('pay_no_rules.get_default_jurisdiction',1);

572: BEGIN
573: --
574: l_tax_municipality := null;
575: --
576: hr_utility.set_location('pay_no_rules.get_default_jurisdiction',1);
577: --
578: -- BUG fix 4474253, commenting old cursor call
579: /*
580: OPEN csr_get_tax_municipality(p_asg_act_id);

Line 625: hr_utility.set_location('pay_no_rules.get_default_jurisdiction='|| p_jurisdiction,2);

621: --
622: p_jurisdiction := NVL(l_tax_municipality,' ');
623:
624: --
625: hr_utility.set_location('pay_no_rules.get_default_jurisdiction='|| p_jurisdiction,2);
626: --
627: END get_default_jurisdiction;
628: --
629: --------------------------------------------------------------------------------

Line 994: --hr_utility.trace_on(null,'no_payslip');

990: ----------------
991:
992: BEGIN
993:
994: --hr_utility.trace_on(null,'no_payslip');
995: hr_utility.trace('Entering Pay_NO_RULES.add_custom_xml');
996: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
997: hr_utility.trace('p_action_information_category '|| p_action_information_category);
998: hr_utility.trace('p_document_type '|| p_document_type);

Line 995: hr_utility.trace('Entering Pay_NO_RULES.add_custom_xml');

991:
992: BEGIN
993:
994: --hr_utility.trace_on(null,'no_payslip');
995: hr_utility.trace('Entering Pay_NO_RULES.add_custom_xml');
996: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
997: hr_utility.trace('p_action_information_category '|| p_action_information_category);
998: hr_utility.trace('p_document_type '|| p_document_type);
999:

Line 996: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);

992: BEGIN
993:
994: --hr_utility.trace_on(null,'no_payslip');
995: hr_utility.trace('Entering Pay_NO_RULES.add_custom_xml');
996: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
997: hr_utility.trace('p_action_information_category '|| p_action_information_category);
998: hr_utility.trace('p_document_type '|| p_document_type);
999:
1000:

Line 997: hr_utility.trace('p_action_information_category '|| p_action_information_category);

993:
994: --hr_utility.trace_on(null,'no_payslip');
995: hr_utility.trace('Entering Pay_NO_RULES.add_custom_xml');
996: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
997: hr_utility.trace('p_action_information_category '|| p_action_information_category);
998: hr_utility.trace('p_document_type '|| p_document_type);
999:
1000:
1001: if ( (p_document_type = 'PAYSLIP') AND (p_action_information_category is null) ) then

Line 998: hr_utility.trace('p_document_type '|| p_document_type);

994: --hr_utility.trace_on(null,'no_payslip');
995: hr_utility.trace('Entering Pay_NO_RULES.add_custom_xml');
996: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
997: hr_utility.trace('p_action_information_category '|| p_action_information_category);
998: hr_utility.trace('p_document_type '|| p_document_type);
999:
1000:
1001: if ( (p_document_type = 'PAYSLIP') AND (p_action_information_category is null) ) then
1002:

Line 1003: hr_utility.trace('doc type is PAYSLIP and category is NULL ');

999:
1000:
1001: if ( (p_document_type = 'PAYSLIP') AND (p_action_information_category is null) ) then
1002:
1003: hr_utility.trace('doc type is PAYSLIP and category is NULL ');
1004:
1005: -- ELEMENT DETAILS
1006:
1007: hr_utility.trace('ELEMENT DEATILS : start ');

Line 1007: hr_utility.trace('ELEMENT DEATILS : start ');

1003: hr_utility.trace('doc type is PAYSLIP and category is NULL ');
1004:
1005: -- ELEMENT DETAILS
1006:
1007: hr_utility.trace('ELEMENT DEATILS : start ');
1008:
1009: -- Main Elements
1010:
1011: hr_utility.trace('Main Elements : start ');

Line 1011: hr_utility.trace('Main Elements : start ');

1007: hr_utility.trace('ELEMENT DEATILS : start ');
1008:
1009: -- Main Elements
1010:
1011: hr_utility.trace('Main Elements : start ');
1012:
1013: FOR csr_element_info_rec IN csr_element_info (p_assignment_action_id,'NO ELEMENT DEFINITION','NO ELEMENT INFO') LOOP
1014: --
1015: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=

Line 1157: hr_utility.trace('Main Elements : end ');

1153: --
1154: END LOOP;
1155: -- --
1156:
1157: hr_utility.trace('Main Elements : end ');
1158:
1159: -- Additional Elements
1160:
1161: hr_utility.trace('Additional Elements : start ');

Line 1161: hr_utility.trace('Additional Elements : start ');

1157: hr_utility.trace('Main Elements : end ');
1158:
1159: -- Additional Elements
1160:
1161: hr_utility.trace('Additional Elements : start ');
1162:
1163: FOR csr_element_info_rec IN csr_add_element_info (p_assignment_action_id,'NO ELEMENT DEFINITION','NO ELEMENT INFO') LOOP
1164: --
1165: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=

Line 1219: hr_utility.trace('Additional Elements : end ');

1215: END LOOP;
1216: -- --
1217:
1218:
1219: hr_utility.trace('Additional Elements : end ');
1220:
1221: hr_utility.trace('ELEMENT DEATILS : end ');
1222:
1223: -- PAYROLL PROCESSING INFORMATION

Line 1221: hr_utility.trace('ELEMENT DEATILS : end ');

1217:
1218:
1219: hr_utility.trace('Additional Elements : end ');
1220:
1221: hr_utility.trace('ELEMENT DEATILS : end ');
1222:
1223: -- PAYROLL PROCESSING INFORMATION
1224:
1225: hr_utility.trace('PAYROLL PROCESSING INFORMATION : start ');

Line 1225: hr_utility.trace('PAYROLL PROCESSING INFORMATION : start ');

1221: hr_utility.trace('ELEMENT DEATILS : end ');
1222:
1223: -- PAYROLL PROCESSING INFORMATION
1224:
1225: hr_utility.trace('PAYROLL PROCESSING INFORMATION : start ');
1226:
1227:
1228: FOR payroll_info_rec IN csr_payroll_info(p_assignment_action_id , 'EMPLOYEE DETAILS' )
1229: LOOP

Line 1258: hr_utility.trace('PAYROLL PROCESSING INFORMATION : end ');

1254: --
1255:
1256: END LOOP;
1257:
1258: hr_utility.trace('PAYROLL PROCESSING INFORMATION : end ');
1259:
1260: -- SUMMARY OF PAYMENTS
1261:
1262: -- l_total_pay := l_total_earnings - l_total_deductions ;

Line 1351: --hr_utility.trace_off();

1347: ret := DBMS_SQL.EXECUTE(csr);
1348: DBMS_SQL.CLOSE_CURSOR(csr);
1349: --
1350: end if;
1351: --hr_utility.trace_off();
1352:
1353: END add_custom_xml;
1354:
1355: -----

Line 1378: hr_utility.set_location('in pay_no_rules',10);

1374:
1375: l_source_text VARCHAR2(150);
1376: BEGIN
1377:
1378: hr_utility.set_location('in pay_no_rules',10);
1379:
1380: IF pay_no_ssb_codes.g_next_ssb_code IS NULL THEN
1381: OPEN csr_ssb_codes;
1382: FETCH csr_ssb_codes INTO l_source_text;

Line 1452: hr_utility.set_location('pay_no_rules.get_source_text2_context',1);

1448:
1449: --
1450: l_tax_municipality := null;
1451: --
1452: hr_utility.set_location('pay_no_rules.get_source_text2_context',1);
1453: --
1454:
1455: OPEN csr_get_prim_asg_id(p_asg_act_id) ;
1456: FETCH csr_get_prim_asg_id INTO prim_asg_id , pay_act_id ;

Line 1467: hr_utility.set_location('pay_no_rules.get_source_text2_context='|| p_source_text2,2);

1463: --
1464: p_source_text2 := NVL(l_tax_municipality,' ');
1465:
1466: --
1467: hr_utility.set_location('pay_no_rules.get_source_text2_context='|| p_source_text2,2);
1468:
1469: EXCEPTION
1470: WHEN others THEN
1471: NULL;

Line 1485: hr_utility.set_location('### get_payslip_sort_order1',1);

1481: l_sort_flag VARCHAR2(2);
1482: BEGIN
1483: --
1484: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_bg_id);
1485: hr_utility.set_location('### get_payslip_sort_order1',1);
1486: --
1487: BEGIN
1488: SELECT org_information1 --Local Unit ID flag
1489: INTO l_sort_flag

Line 1498: hr_utility.set_location('### get_payslip_sort_order1',10);

1494: EXCEPTION WHEN OTHERS THEN
1495: l_sort_flag := 'N';
1496: END;
1497: --
1498: hr_utility.set_location('### get_payslip_sort_order1',10);
1499: --
1500: IF l_sort_flag = 'Y' THEN
1501: return 'SEGMENT2'; -- Local Unit ID
1502: ELSE

Line 1518: hr_utility.set_location('### get_payslip_sort_order2',1);

1514: l_sort_flag VARCHAR2(2);
1515: BEGIN
1516: --
1517: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_bg_id);
1518: hr_utility.set_location('### get_payslip_sort_order2',1);
1519: --
1520: BEGIN
1521: SELECT org_information2 --Org ID flag
1522: INTO l_sort_flag

Line 1531: hr_utility.set_location('### get_payslip_sort_order2',10);

1527: EXCEPTION WHEN OTHERS THEN
1528: l_sort_flag := 'N';
1529: END;
1530: --
1531: hr_utility.set_location('### get_payslip_sort_order2',10);
1532: --
1533: IF l_sort_flag = 'Y' THEN
1534: return 'ORGANIZATION_ID';
1535: ELSE