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 370: hr_utility.set_location('pay_no_rules.get_source_context',1);

366: BEGIN
367: --
368: l_local_unit:= null;
369: --
370: hr_utility.set_location('pay_no_rules.get_source_context',1);
371: --
372: OPEN csr_get_local_unit(p_asg_act_id);
373: FETCH csr_get_local_unit INTO l_local_unit;
374: CLOSE csr_get_local_unit;

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

374: CLOSE csr_get_local_unit;
375: --
376: p_source_id := NVL(l_local_unit,' ');
377: --
378: hr_utility.set_location('pay_no_rules.get_source_context='|| p_source_id,2);
379: --
380: END get_source_context;
381: --
382: */

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

406: BEGIN
407: --
408: l_local_unit:= null;
409: --
410: hr_utility.set_location('pay_no_rules.get_main_local_unit_id',1);
411: --
412: OPEN csr_get_local_unit(p_assignment_id);
413: FETCH csr_get_local_unit INTO l_local_unit;
414: CLOSE csr_get_local_unit;

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

414: CLOSE csr_get_local_unit;
415: --
416: p_local_unit_id := NVL(l_local_unit,0);
417: --
418: hr_utility.set_location('pay_no_rules.get_main_local_unit_id='|| p_local_unit_id,2);
419: --
420: END get_main_local_unit_id;
421: ------------------------------------------------------------------------------------------
422: PROCEDURE get_default_jurisdiction(p_asg_act_id NUMBER,

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

566: BEGIN
567: --
568: l_tax_municipality := null;
569: --
570: hr_utility.set_location('pay_no_rules.get_default_jurisdiction',1);
571: --
572: -- BUG fix 4474253, commenting old cursor call
573: /*
574: OPEN csr_get_tax_municipality(p_asg_act_id);

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

615: --
616: p_jurisdiction := NVL(l_tax_municipality,' ');
617:
618: --
619: hr_utility.set_location('pay_no_rules.get_default_jurisdiction='|| p_jurisdiction,2);
620: --
621: END get_default_jurisdiction;
622: --
623: --------------------------------------------------------------------------------

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

977: ----------------
978:
979: BEGIN
980:
981: --hr_utility.trace_on(null,'no_payslip');
982: hr_utility.trace('Entering Pay_NO_RULES.add_custom_xml');
983: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
984: hr_utility.trace('p_action_information_category '|| p_action_information_category);
985: hr_utility.trace('p_document_type '|| p_document_type);

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

978:
979: BEGIN
980:
981: --hr_utility.trace_on(null,'no_payslip');
982: hr_utility.trace('Entering Pay_NO_RULES.add_custom_xml');
983: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
984: hr_utility.trace('p_action_information_category '|| p_action_information_category);
985: hr_utility.trace('p_document_type '|| p_document_type);
986:

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

979: BEGIN
980:
981: --hr_utility.trace_on(null,'no_payslip');
982: hr_utility.trace('Entering Pay_NO_RULES.add_custom_xml');
983: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
984: hr_utility.trace('p_action_information_category '|| p_action_information_category);
985: hr_utility.trace('p_document_type '|| p_document_type);
986:
987:

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

980:
981: --hr_utility.trace_on(null,'no_payslip');
982: hr_utility.trace('Entering Pay_NO_RULES.add_custom_xml');
983: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
984: hr_utility.trace('p_action_information_category '|| p_action_information_category);
985: hr_utility.trace('p_document_type '|| p_document_type);
986:
987:
988: if ( (p_document_type = 'PAYSLIP') AND (p_action_information_category is null) ) then

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

981: --hr_utility.trace_on(null,'no_payslip');
982: hr_utility.trace('Entering Pay_NO_RULES.add_custom_xml');
983: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
984: hr_utility.trace('p_action_information_category '|| p_action_information_category);
985: hr_utility.trace('p_document_type '|| p_document_type);
986:
987:
988: if ( (p_document_type = 'PAYSLIP') AND (p_action_information_category is null) ) then
989:

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

986:
987:
988: if ( (p_document_type = 'PAYSLIP') AND (p_action_information_category is null) ) then
989:
990: hr_utility.trace('doc type is PAYSLIP and category is NULL ');
991:
992: -- ELEMENT DETAILS
993:
994: hr_utility.trace('ELEMENT DEATILS : start ');

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

990: hr_utility.trace('doc type is PAYSLIP and category is NULL ');
991:
992: -- ELEMENT DETAILS
993:
994: hr_utility.trace('ELEMENT DEATILS : start ');
995:
996: -- Main Elements
997:
998: hr_utility.trace('Main Elements : start ');

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

994: hr_utility.trace('ELEMENT DEATILS : start ');
995:
996: -- Main Elements
997:
998: hr_utility.trace('Main Elements : start ');
999:
1000: FOR csr_element_info_rec IN csr_element_info (p_assignment_action_id,'NO ELEMENT DEFINITION','NO ELEMENT INFO') LOOP
1001: --
1002: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=

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

1140: --
1141: END LOOP;
1142: -- --
1143:
1144: hr_utility.trace('Main Elements : end ');
1145:
1146: -- Additional Elements
1147:
1148: hr_utility.trace('Additional Elements : start ');

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

1144: hr_utility.trace('Main Elements : end ');
1145:
1146: -- Additional Elements
1147:
1148: hr_utility.trace('Additional Elements : start ');
1149:
1150: FOR csr_element_info_rec IN csr_add_element_info (p_assignment_action_id,'NO ELEMENT DEFINITION','NO ELEMENT INFO') LOOP
1151: --
1152: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=

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

1202: END LOOP;
1203: -- --
1204:
1205:
1206: hr_utility.trace('Additional Elements : end ');
1207:
1208: hr_utility.trace('ELEMENT DEATILS : end ');
1209:
1210: -- PAYROLL PROCESSING INFORMATION

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

1204:
1205:
1206: hr_utility.trace('Additional Elements : end ');
1207:
1208: hr_utility.trace('ELEMENT DEATILS : end ');
1209:
1210: -- PAYROLL PROCESSING INFORMATION
1211:
1212: hr_utility.trace('PAYROLL PROCESSING INFORMATION : start ');

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

1208: hr_utility.trace('ELEMENT DEATILS : end ');
1209:
1210: -- PAYROLL PROCESSING INFORMATION
1211:
1212: hr_utility.trace('PAYROLL PROCESSING INFORMATION : start ');
1213:
1214:
1215: FOR payroll_info_rec IN csr_payroll_info(p_assignment_action_id , 'EMPLOYEE DETAILS' )
1216: LOOP

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

1241: --
1242:
1243: END LOOP;
1244:
1245: hr_utility.trace('PAYROLL PROCESSING INFORMATION : end ');
1246:
1247: -- SUMMARY OF PAYMENTS
1248:
1249: -- l_total_pay := l_total_earnings - l_total_deductions ;

Line 1338: --hr_utility.trace_off();

1334: ret := DBMS_SQL.EXECUTE(csr);
1335: DBMS_SQL.CLOSE_CURSOR(csr);
1336: --
1337: end if;
1338: --hr_utility.trace_off();
1339:
1340: END add_custom_xml;
1341:
1342: -----

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

1361:
1362: l_source_text VARCHAR2(150);
1363: BEGIN
1364:
1365: hr_utility.set_location('in pay_no_rules',10);
1366:
1367: IF pay_no_ssb_codes.g_next_ssb_code IS NULL THEN
1368: OPEN csr_ssb_codes;
1369: FETCH csr_ssb_codes INTO l_source_text;

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

1435:
1436: --
1437: l_tax_municipality := null;
1438: --
1439: hr_utility.set_location('pay_no_rules.get_source_text2_context',1);
1440: --
1441:
1442: OPEN csr_get_prim_asg_id(p_asg_act_id) ;
1443: FETCH csr_get_prim_asg_id INTO prim_asg_id , pay_act_id ;

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

1450: --
1451: p_source_text2 := NVL(l_tax_municipality,' ');
1452:
1453: --
1454: hr_utility.set_location('pay_no_rules.get_source_text2_context='|| p_source_text2,2);
1455:
1456: EXCEPTION
1457: WHEN others THEN
1458: NULL;

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

1468: l_sort_flag VARCHAR2(2);
1469: BEGIN
1470: --
1471: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_bg_id);
1472: hr_utility.set_location('### get_payslip_sort_order1',1);
1473: --
1474: BEGIN
1475: SELECT org_information1 --Local Unit ID flag
1476: INTO l_sort_flag

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

1481: EXCEPTION WHEN OTHERS THEN
1482: l_sort_flag := 'N';
1483: END;
1484: --
1485: hr_utility.set_location('### get_payslip_sort_order1',10);
1486: --
1487: IF l_sort_flag = 'Y' THEN
1488: return 'SEGMENT2'; -- Local Unit ID
1489: ELSE

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

1501: l_sort_flag VARCHAR2(2);
1502: BEGIN
1503: --
1504: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_bg_id);
1505: hr_utility.set_location('### get_payslip_sort_order2',1);
1506: --
1507: BEGIN
1508: SELECT org_information2 --Org ID flag
1509: INTO l_sort_flag

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

1514: EXCEPTION WHEN OTHERS THEN
1515: l_sort_flag := 'N';
1516: END;
1517: --
1518: hr_utility.set_location('### get_payslip_sort_order2',10);
1519: --
1520: IF l_sort_flag = 'Y' THEN
1521: return 'ORGANIZATION_ID';
1522: ELSE