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

Line 47: hr_utility.set_location('Entering:'|| l_proc, 10);

43: l_legislation_code varchar2(150);
44: --
45: begin
46: --
47: hr_utility.set_location('Entering:'|| l_proc, 10);
48: --
49: -- Ensure that all the mandatory parameter are not null
50: --
51: hr_api.mandatory_arg_error

Line 87: hr_utility.set_location(' Leaving:'|| l_proc, 20);

83: --
84: hr_api.set_legislation_context(l_legislation_code);
85: end if;
86: --
87: hr_utility.set_location(' Leaving:'|| l_proc, 20);
88: --
89: end set_security_group_id;
90: --
91: -- ---------------------------------------------------------------------------

Line 116: hr_utility.set_location('Entering:'|| l_proc, 10);

112: l_proc varchar2(72) := g_package||'return_legislation_code';
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'|| l_proc, 10);
117: --
118: -- Ensure that all the mandatory parameter are not null
119: --
120: hr_api.mandatory_arg_error

Line 134: hr_utility.set_location(l_proc, 20);

130: -- call to this function. Just return the value in the global
131: -- variable.
132: --
133: l_legislation_code := pay_frr_bus.g_legislation_code;
134: hr_utility.set_location(l_proc, 20);
135: else
136: --
137: -- The ID is different to the last call to this function
138: -- or this is the first call to this function.

Line 151: hr_utility.set_location(l_proc,30);

147: close csr_leg_code;
148: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
149: fnd_message.raise_error;
150: end if;
151: hr_utility.set_location(l_proc,30);
152: --
153: -- Set the global variables so the values are
154: -- available for the next call to this function.
155: --

Line 160: hr_utility.set_location(' Leaving:'|| l_proc, 40);

156: close csr_leg_code;
157: pay_frr_bus.g_formula_result_rule_id := p_formula_result_rule_id;
158: pay_frr_bus.g_legislation_code := l_legislation_code;
159: end if;
160: hr_utility.set_location(' Leaving:'|| l_proc, 40);
161: return l_legislation_code;
162: end return_legislation_code;
163: --
164: -- ----------------------------------------------------------------------------

Line 464: hr_utility.set_location('Entering:'||l_proc, 5);

460: from fnd_territories
461: where territory_code = p_legislation_code;
462: --
463: Begin
464: hr_utility.set_location('Entering:'||l_proc, 5);
465: --
466: If p_legislation_code is not null then
467:
468: Open c_chk_leg_code;

Line 483: hr_utility.set_location('Leaving:'||l_proc, 10);

479: Close c_chk_leg_code;
480:
481: End If;
482: --
483: hr_utility.set_location('Leaving:'||l_proc, 10);
484: End;
485: --
486: -- ----------------------------------------------------------------------------
487: -- |------------------------< chk_element_type_id >---------------------------|

Line 525: hr_utility.set_location('Entering:'||l_proc, 5);

521: and pet.legislation_code = p_legislation_code
522: ));
523: --
524: Begin
525: hr_utility.set_location('Entering:'||l_proc, 5);
526: --
527: open c_chk_element_type;
528: fetch c_chk_element_type into g_exists;
529: if c_chk_element_type%notfound then

Line 537: hr_utility.set_location('Leaving:'||l_proc, 10);

533: fnd_message.raise_error;
534: end if;
535: close c_chk_element_type;
536: --
537: hr_utility.set_location('Leaving:'||l_proc, 10);
538: End;
539: --
540: -- ----------------------------------------------------------------------------
541: -- |--------------------< chk_status_processing_rule_id >---------------------|

Line 579: hr_utility.set_location('Entering:'||l_proc, 5);

575: (spr.legislation_code = p_legislation_code)
576: ));
577: --
578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);
580: --
581: open c_chk_spr;
582: fetch c_chk_spr into g_exists;
583: if c_chk_spr%notfound then

Line 591: hr_utility.set_location('Leaving:'||l_proc, 10);

587: fnd_message.raise_error;
588: end if;
589: close c_chk_spr;
590: --
591: hr_utility.set_location('Leaving:'||l_proc, 10);
592: End;
593: --
594: -- ----------------------------------------------------------------------------
595: -- |---------------------------< chk_result_name >----------------------------|

Line 627: hr_utility.set_location('Entering:'||l_proc, 5);

623: and p_effective_date between fdu.effective_start_date
624: and fdu.effective_end_date;
625: --
626: Begin
627: hr_utility.set_location('Entering:'||l_proc, 5);
628: --
629: open c_chk_result_name;
630: fetch c_chk_result_name into g_exists;
631: if c_chk_result_name%notfound then

Line 637: hr_utility.trace('PAY_34156_FRR_NAME_INVALID Warning in startup mode: formula result_name:'

633: IF hr_startup_data_api_support.g_startup_mode NOT IN ('STARTUP') THEN
634: close c_chk_result_name;
635: fnd_message.raise_error;
636: ELSE
637: hr_utility.trace('PAY_34156_FRR_NAME_INVALID Warning in startup mode: formula result_name:'
638: ||p_result_name|| ' not found for spr_id:'
639: ||to_char(p_status_processing_rule_id)
640: ||' effective_date:'||to_char(p_effective_date));
641: hr_utility.trace('SQLERRM:'||SQLERRM);

Line 641: hr_utility.trace('SQLERRM:'||SQLERRM);

637: hr_utility.trace('PAY_34156_FRR_NAME_INVALID Warning in startup mode: formula result_name:'
638: ||p_result_name|| ' not found for spr_id:'
639: ||to_char(p_status_processing_rule_id)
640: ||' effective_date:'||to_char(p_effective_date));
641: hr_utility.trace('SQLERRM:'||SQLERRM);
642: END IF;
643: end if;
644: close c_chk_result_name;
645: --

Line 646: hr_utility.set_location('Leaving:'||l_proc, 10);

642: END IF;
643: end if;
644: close c_chk_result_name;
645: --
646: hr_utility.set_location('Leaving:'||l_proc, 10);
647: End;
648: --
649: --
650: -- ----------------------------------------------------------------------------

Line 669: hr_utility.set_location('Entering:'||l_proc, 5);

665: --
666: l_proc varchar2(72) := g_package||'chk_common_rules';
667: --
668: Begin
669: hr_utility.set_location('Entering:'||l_proc, 5);
670: --
671: If p_result_rule_type <> 'M' then -- message
672: --
673: -- severity must be entered

Line 733: hr_utility.set_location('Leaving:'||l_proc, 10);

729: End If;
730: --
731: End If;
732: --
733: hr_utility.set_location('Leaving:'||l_proc, 10);
734: End;
735: --
736: -- ----------------------------------------------------------------------------
737: -- |-------------------------< chk_result_rule_type >-------------------------|

Line 781: hr_utility.set_location('Entering:'||l_proc, 5);

777: l_spr_element_dets c_element_dets%rowtype;
778: --
779:
780: Begin
781: hr_utility.set_location('Entering:'||l_proc, 5);
782: --
783: If hr_api.not_exists_in_hr_lookups
784: (p_effective_date
785: ,'RESULT_RULE_TYPE'

Line 844: hr_utility.trace('PAY_34160_FRR_INDIRECT_RULE Warning in startup mode: p_element_type_id:'

840: IF hr_startup_data_api_support.g_startup_mode NOT IN ('STARTUP') THEN
841: fnd_message.set_name('PAY','PAY_34160_FRR_INDIRECT_RULE');
842: fnd_message.raise_error;
843: ELSE
844: hr_utility.trace('PAY_34160_FRR_INDIRECT_RULE Warning in startup mode: p_element_type_id:'
845: ||p_element_type_id|| ' has processing_type:'
846: ||l_element_dets.processing_type);
847: --
848: End if;

Line 896: hr_utility.set_location('Leaving:'||l_proc, 10);

892: End If;
893: --
894: End If;
895: --
896: hr_utility.set_location('Leaving:'||l_proc, 10);
897: End;
898: --
899: -- ----------------------------------------------------------------------------
900: -- |-------------------------< chk_severity_level >---------------------------|

Line 916: hr_utility.set_location('Entering:'||l_proc, 5);

912: --
913: l_proc varchar2(72) := g_package||'chk_severity_level';
914: --
915: Begin
916: hr_utility.set_location('Entering:'||l_proc, 5);
917: --
918: If hr_api.not_exists_in_hr_lookups
919: (p_effective_date
920: ,'FORMULA_RESULT_MESSAGE_LEVEL'

Line 930: hr_utility.set_location('Leaving:'||l_proc, 10);

926: fnd_message.raise_error;
927: --
928: End If;
929: --
930: hr_utility.set_location('Leaving:'||l_proc, 10);
931: End;
932: --
933: -- ----------------------------------------------------------------------------
934: -- |-------------------------< chk_input_value_id >---------------------------|

Line 976: hr_utility.set_location('Entering:'||l_proc, 5);

972: and p_effective_date between fdu.effective_start_date
973: and fdu.effective_end_date;
974: --
975: Begin
976: hr_utility.set_location('Entering:'||l_proc, 5);
977: --
978: Open c_result_dtype;
979: Fetch c_result_dtype into l_op_datatype;
980: Close c_result_dtype;

Line 1033: hr_utility.set_location('Leaving:'||l_proc, 10);

1029: fnd_message.raise_error;
1030: --
1031: End If;
1032: --
1033: hr_utility.set_location('Leaving:'||l_proc, 10);
1034: End;
1035: --
1036: -- ----------------------------------------------------------------------------
1037: -- |-------------------------< chk_unique_rules >-----------------------------|

Line 1077: hr_utility.set_location('Entering:'||l_proc, 2);

1073: and formula_result_rule_id <> nvl(p_formula_result_rule_id,-1);
1074: --
1075: begin
1076: --
1077: hr_utility.set_location('Entering:'||l_proc, 2);
1078: --
1079: open c_duplicate_rule;
1080: fetch c_duplicate_rule into g_exists;
1081: v_duplicate_found := c_duplicate_rule%found;

Line 1084: hr_utility.set_location('Leaving:'||l_proc, 3);

1080: fetch c_duplicate_rule into g_exists;
1081: v_duplicate_found := c_duplicate_rule%found;
1082: close c_duplicate_rule;
1083: --
1084: hr_utility.set_location('Leaving:'||l_proc, 3);
1085: --
1086: return v_duplicate_found;
1087: --
1088: end message_rule_not_unique;

Line 1113: hr_utility.set_location('Entering:'||l_proc, 4);

1109: and formula_result_rule_id <> nvl(p_formula_result_rule_id,-1);
1110: --
1111: begin
1112: --
1113: hr_utility.set_location('Entering:'||l_proc, 4);
1114: --
1115: open c_duplicate_rule;
1116: fetch c_duplicate_rule into g_exists;
1117: v_duplicate_found := c_duplicate_rule%found;

Line 1120: hr_utility.set_location('Leaving:'||l_proc, 5);

1116: fetch c_duplicate_rule into g_exists;
1117: v_duplicate_found := c_duplicate_rule%found;
1118: close c_duplicate_rule;
1119: --
1120: hr_utility.set_location('Leaving:'||l_proc, 5);
1121: --
1122: return v_duplicate_found;
1123: --
1124: end recurring_rule_not_unique;

Line 1148: hr_utility.set_location('Entering:'||l_proc, 6);

1144: and formula_result_rule_id <> nvl(p_formula_result_rule_id,-1);
1145: --
1146: begin
1147: --
1148: hr_utility.set_location('Entering:'||l_proc, 6);
1149: --
1150: open c_duplicate_rule;
1151: fetch c_duplicate_rule into g_exists;
1152: v_duplicate_found := c_duplicate_rule%found;

Line 1155: hr_utility.set_location('Leaving:'||l_proc, 7);

1151: fetch c_duplicate_rule into g_exists;
1152: v_duplicate_found := c_duplicate_rule%found;
1153: close c_duplicate_rule;
1154: --
1155: hr_utility.set_location('Leaving:'||l_proc, 7);
1156: --
1157: return v_duplicate_found;
1158: --
1159: end other_rule_type_not_unique;

Line 1164: hr_utility.set_location('Entering:'||l_proc, 1);

1160: --
1161: -- Main procedure starts
1162: --
1163: Begin
1164: hr_utility.set_location('Entering:'||l_proc, 1);
1165: --
1166: If (p_result_rule_type = 'M' and message_rule_not_unique)
1167: or (p_result_rule_type in ('S','U') and recurring_rule_not_unique)
1168: or (p_result_rule_type in ('I','D') and other_rule_type_not_unique) then

Line 1175: hr_utility.set_location('Leaving:'||l_proc, 10);

1171: fnd_message.raise_error;
1172: --
1173: End If;
1174: --
1175: hr_utility.set_location('Leaving:'||l_proc, 10);
1176: End;
1177: --
1178: -- ----------------------------------------------------------------------------
1179: -- |------------------------< set_effective_end_date >------------------------|

Line 1215: hr_utility.set_location('Entering:'||l_proc, 5);

1211: and p_effective_date between spr.effective_start_date
1212: and spr.effective_end_date;
1213: --
1214: Begin
1215: hr_utility.set_location('Entering:'||l_proc, 5);
1216: --
1217: open c_spr_element;
1218: fetch c_spr_element into l_spr_formula_id, l_spr_element_type_id;
1219: close c_spr_element;

Line 1226: hr_utility.set_location('l_max_spr_end_date '||to_char(l_max_spr_end_date),6);

1222: --
1223: l_max_spr_end_date := pay_status_rules_pkg.spr_end_date
1224: (p_status_processing_rule_id
1225: ,l_spr_formula_id);
1226: hr_utility.set_location('l_max_spr_end_date '||to_char(l_max_spr_end_date),6);
1227: --
1228: -- get the maximum end date of the source element type
1229: --
1230: l_max_end_date_of_element := pay_element_types_pkg.element_end_date

Line 1232: hr_utility.set_location('l_max_end_date_of_element '||to_char(l_max_end_date_of_element),7);

1228: -- get the maximum end date of the source element type
1229: --
1230: l_max_end_date_of_element := pay_element_types_pkg.element_end_date
1231: (l_spr_element_type_id);
1232: hr_utility.set_location('l_max_end_date_of_element '||to_char(l_max_end_date_of_element),7);
1233: --
1234: -- get the maximum end date of the target element type
1235: --
1236: l_max_end_date_of_target := pay_element_types_pkg.element_end_date

Line 1238: hr_utility.set_location('l_max_end_date_of_target '||to_char(l_max_end_date_of_target),8);

1234: -- get the maximum end date of the target element type
1235: --
1236: l_max_end_date_of_target := pay_element_types_pkg.element_end_date
1237: (p_element_type_id);
1238: hr_utility.set_location('l_max_end_date_of_target '||to_char(l_max_end_date_of_target),8);
1239: --
1240: -- get the maximum end date of a similar rule if it exists in the future.
1241: --
1242: l_future_rule_end_date := pay_formula_result_rules_pkg.result_rule_end_date

Line 1251: hr_utility.set_location('l_future_rule_end_date '||to_char(l_future_rule_end_date),8);

1247: ,p_element_type_id
1248: ,p_input_value_id
1249: ,p_effective_date
1250: ,l_max_spr_end_date);
1251: hr_utility.set_location('l_future_rule_end_date '||to_char(l_future_rule_end_date),8);
1252: --
1253: hr_utility.set_location('before set-p_validation_end_date '||to_char(p_validation_end_date),9);
1254: --
1255: if (p_result_rule_type in ('I','U','S'))

Line 1253: hr_utility.set_location('before set-p_validation_end_date '||to_char(p_validation_end_date),9);

1249: ,p_effective_date
1250: ,l_max_spr_end_date);
1251: hr_utility.set_location('l_future_rule_end_date '||to_char(l_future_rule_end_date),8);
1252: --
1253: hr_utility.set_location('before set-p_validation_end_date '||to_char(p_validation_end_date),9);
1254: --
1255: if (p_result_rule_type in ('I','U','S'))
1256: or (p_datetrack_mode = hr_api.g_delete_next_change) then
1257: p_validation_end_date := least (l_max_end_date_of_element

Line 1267: hr_utility.set_location('after set-p_validation_end_date '||to_char(p_validation_end_date),10);

1263: ,l_max_spr_end_date
1264: ,l_future_rule_end_date);
1265: end if;
1266: --
1267: hr_utility.set_location('after set-p_validation_end_date '||to_char(p_validation_end_date),10);
1268: --
1269: hr_utility.set_location('Leaving:'||l_proc, 10);
1270: End;
1271: --

Line 1269: hr_utility.set_location('Leaving:'||l_proc, 10);

1265: end if;
1266: --
1267: hr_utility.set_location('after set-p_validation_end_date '||to_char(p_validation_end_date),10);
1268: --
1269: hr_utility.set_location('Leaving:'||l_proc, 10);
1270: End;
1271: --
1272: -- ----------------------------------------------------------------------------
1273: -- |----------------------< chk_startup_action >------------------------------|

Line 1327: hr_utility.set_location('Entering:'||l_proc, 5);

1323: --
1324: l_proc varchar2(72) := g_package||'insert_validate';
1325: --
1326: Begin
1327: hr_utility.set_location('Entering:'||l_proc, 5);
1328: --
1329: -- Call all supporting business operations
1330: --
1331: --

Line 1420: hr_utility.set_location(' Leaving:'||l_proc, 10);

1416: ,p_input_value_id => p_rec.input_value_id
1417: );
1418: --
1419: --
1420: hr_utility.set_location(' Leaving:'||l_proc, 10);
1421: End insert_validate;
1422: --
1423: -- ----------------------------------------------------------------------------
1424: -- |---------------------------< update_validate >----------------------------|

Line 1437: hr_utility.set_location('Entering:'||l_proc, 5);

1433: --
1434: l_proc varchar2(72) := g_package||'update_validate';
1435: --
1436: Begin
1437: hr_utility.set_location('Entering:'||l_proc, 5);
1438: --
1439: -- Call all supporting business operations
1440: --
1441: --

Line 1524: hr_utility.set_location(' Leaving:'||l_proc, 10);

1520: ,p_rec => p_rec
1521: );
1522: --
1523: --
1524: hr_utility.set_location(' Leaving:'||l_proc, 10);
1525: End update_validate;
1526: --
1527: -- ----------------------------------------------------------------------------
1528: -- |---------------------------< delete_validate >----------------------------|

Line 1541: hr_utility.set_location('Entering:'||l_proc, 5);

1537: --
1538: l_proc varchar2(72) := g_package||'delete_validate';
1539: --
1540: Begin
1541: hr_utility.set_location('Entering:'||l_proc, 5);
1542: --
1543: --
1544: chk_startup_action(false
1545: ,pay_frr_shd.g_old_rec.business_group_id

Line 1570: hr_utility.set_location(' Leaving:'||l_proc, 10);

1566: ,p_validation_end_date => p_validation_end_date
1567: ,p_formula_result_rule_id => p_rec.formula_result_rule_id
1568: );
1569: --
1570: hr_utility.set_location(' Leaving:'||l_proc, 10);
1571: End delete_validate;
1572: --
1573: end pay_frr_bus;