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 638: hr_utility.set_location('Leaving:'||l_proc, 10);

634: fnd_message.raise_error;
635: end if;
636: close c_chk_result_name;
637: --
638: hr_utility.set_location('Leaving:'||l_proc, 10);
639: End;
640: --
641: --
642: -- ----------------------------------------------------------------------------

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

657: --
658: l_proc varchar2(72) := g_package||'chk_common_rules';
659: --
660: Begin
661: hr_utility.set_location('Entering:'||l_proc, 5);
662: --
663: If p_result_rule_type <> 'M' then -- message
664: --
665: -- severity must be entered

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

721: End If;
722: --
723: End If;
724: --
725: hr_utility.set_location('Leaving:'||l_proc, 10);
726: End;
727: --
728: -- ----------------------------------------------------------------------------
729: -- |-------------------------< chk_result_rule_type >-------------------------|

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

769: l_spr_element_dets c_element_dets%rowtype;
770: --
771:
772: Begin
773: hr_utility.set_location('Entering:'||l_proc, 5);
774: --
775: If hr_api.not_exists_in_hr_lookups
776: (p_effective_date
777: ,'RESULT_RULE_TYPE'

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

873: End If;
874: --
875: End If;
876: --
877: hr_utility.set_location('Leaving:'||l_proc, 10);
878: End;
879: --
880: -- ----------------------------------------------------------------------------
881: -- |-------------------------< chk_severity_level >---------------------------|

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

893: --
894: l_proc varchar2(72) := g_package||'chk_severity_level';
895: --
896: Begin
897: hr_utility.set_location('Entering:'||l_proc, 5);
898: --
899: If hr_api.not_exists_in_hr_lookups
900: (p_effective_date
901: ,'FORMULA_RESULT_MESSAGE_LEVEL'

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

907: fnd_message.raise_error;
908: --
909: End If;
910: --
911: hr_utility.set_location('Leaving:'||l_proc, 10);
912: End;
913: --
914: -- ----------------------------------------------------------------------------
915: -- |-------------------------< chk_input_value_id >---------------------------|

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

953: and p_effective_date between fdu.effective_start_date
954: and fdu.effective_end_date;
955: --
956: Begin
957: hr_utility.set_location('Entering:'||l_proc, 5);
958: --
959: Open c_result_dtype;
960: Fetch c_result_dtype into l_op_datatype;
961: Close c_result_dtype;

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

1010: fnd_message.raise_error;
1011: --
1012: End If;
1013: --
1014: hr_utility.set_location('Leaving:'||l_proc, 10);
1015: End;
1016: --
1017: -- ----------------------------------------------------------------------------
1018: -- |-------------------------< chk_unique_rules >-----------------------------|

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

1054: and formula_result_rule_id <> nvl(p_formula_result_rule_id,-1);
1055: --
1056: begin
1057: --
1058: hr_utility.set_location('Entering:'||l_proc, 2);
1059: --
1060: open c_duplicate_rule;
1061: fetch c_duplicate_rule into g_exists;
1062: v_duplicate_found := c_duplicate_rule%found;

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

1061: fetch c_duplicate_rule into g_exists;
1062: v_duplicate_found := c_duplicate_rule%found;
1063: close c_duplicate_rule;
1064: --
1065: hr_utility.set_location('Leaving:'||l_proc, 3);
1066: --
1067: return v_duplicate_found;
1068: --
1069: end message_rule_not_unique;

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

1090: and formula_result_rule_id <> nvl(p_formula_result_rule_id,-1);
1091: --
1092: begin
1093: --
1094: hr_utility.set_location('Entering:'||l_proc, 4);
1095: --
1096: open c_duplicate_rule;
1097: fetch c_duplicate_rule into g_exists;
1098: v_duplicate_found := c_duplicate_rule%found;

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

1097: fetch c_duplicate_rule into g_exists;
1098: v_duplicate_found := c_duplicate_rule%found;
1099: close c_duplicate_rule;
1100: --
1101: hr_utility.set_location('Leaving:'||l_proc, 5);
1102: --
1103: return v_duplicate_found;
1104: --
1105: end recurring_rule_not_unique;

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

1125: and formula_result_rule_id <> nvl(p_formula_result_rule_id,-1);
1126: --
1127: begin
1128: --
1129: hr_utility.set_location('Entering:'||l_proc, 6);
1130: --
1131: open c_duplicate_rule;
1132: fetch c_duplicate_rule into g_exists;
1133: v_duplicate_found := c_duplicate_rule%found;

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

1132: fetch c_duplicate_rule into g_exists;
1133: v_duplicate_found := c_duplicate_rule%found;
1134: close c_duplicate_rule;
1135: --
1136: hr_utility.set_location('Leaving:'||l_proc, 7);
1137: --
1138: return v_duplicate_found;
1139: --
1140: end other_rule_type_not_unique;

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

1141: --
1142: -- Main procedure starts
1143: --
1144: Begin
1145: hr_utility.set_location('Entering:'||l_proc, 1);
1146: --
1147: If (p_result_rule_type = 'M' and message_rule_not_unique)
1148: or (p_result_rule_type in ('S','U') and recurring_rule_not_unique)
1149: or (p_result_rule_type in ('I','D') and other_rule_type_not_unique) then

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

1152: fnd_message.raise_error;
1153: --
1154: End If;
1155: --
1156: hr_utility.set_location('Leaving:'||l_proc, 10);
1157: End;
1158: --
1159: -- ----------------------------------------------------------------------------
1160: -- |------------------------< set_effective_end_date >------------------------|

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

1192: and p_effective_date between spr.effective_start_date
1193: and spr.effective_end_date;
1194: --
1195: Begin
1196: hr_utility.set_location('Entering:'||l_proc, 5);
1197: --
1198: open c_spr_element;
1199: fetch c_spr_element into l_spr_formula_id, l_spr_element_type_id;
1200: close c_spr_element;

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

1203: --
1204: l_max_spr_end_date := pay_status_rules_pkg.spr_end_date
1205: (p_status_processing_rule_id
1206: ,l_spr_formula_id);
1207: hr_utility.set_location('l_max_spr_end_date '||to_char(l_max_spr_end_date),6);
1208: --
1209: -- get the maximum end date of the source element type
1210: --
1211: l_max_end_date_of_element := pay_element_types_pkg.element_end_date

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

1209: -- get the maximum end date of the source element type
1210: --
1211: l_max_end_date_of_element := pay_element_types_pkg.element_end_date
1212: (l_spr_element_type_id);
1213: hr_utility.set_location('l_max_end_date_of_element '||to_char(l_max_end_date_of_element),7);
1214: --
1215: -- get the maximum end date of the target element type
1216: --
1217: l_max_end_date_of_target := pay_element_types_pkg.element_end_date

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

1215: -- get the maximum end date of the target element type
1216: --
1217: l_max_end_date_of_target := pay_element_types_pkg.element_end_date
1218: (p_element_type_id);
1219: hr_utility.set_location('l_max_end_date_of_target '||to_char(l_max_end_date_of_target),8);
1220: --
1221: -- get the maximum end date of a similar rule if it exists in the future.
1222: --
1223: l_future_rule_end_date := pay_formula_result_rules_pkg.result_rule_end_date

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

1228: ,p_element_type_id
1229: ,p_input_value_id
1230: ,p_effective_date
1231: ,l_max_spr_end_date);
1232: hr_utility.set_location('l_future_rule_end_date '||to_char(l_future_rule_end_date),8);
1233: --
1234: hr_utility.set_location('before set-p_validation_end_date '||to_char(p_validation_end_date),9);
1235: --
1236: if (p_result_rule_type in ('I','U','S'))

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

1230: ,p_effective_date
1231: ,l_max_spr_end_date);
1232: hr_utility.set_location('l_future_rule_end_date '||to_char(l_future_rule_end_date),8);
1233: --
1234: hr_utility.set_location('before set-p_validation_end_date '||to_char(p_validation_end_date),9);
1235: --
1236: if (p_result_rule_type in ('I','U','S'))
1237: or (p_datetrack_mode = hr_api.g_delete_next_change) then
1238: p_validation_end_date := least (l_max_end_date_of_element

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

1244: ,l_max_spr_end_date
1245: ,l_future_rule_end_date);
1246: end if;
1247: --
1248: hr_utility.set_location('after set-p_validation_end_date '||to_char(p_validation_end_date),10);
1249: --
1250: hr_utility.set_location('Leaving:'||l_proc, 10);
1251: End;
1252: --

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

1246: end if;
1247: --
1248: hr_utility.set_location('after set-p_validation_end_date '||to_char(p_validation_end_date),10);
1249: --
1250: hr_utility.set_location('Leaving:'||l_proc, 10);
1251: End;
1252: --
1253: -- ----------------------------------------------------------------------------
1254: -- |----------------------< chk_startup_action >------------------------------|

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

1304: --
1305: l_proc varchar2(72) := g_package||'insert_validate';
1306: --
1307: Begin
1308: hr_utility.set_location('Entering:'||l_proc, 5);
1309: --
1310: -- Call all supporting business operations
1311: --
1312: --

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

1397: ,p_input_value_id => p_rec.input_value_id
1398: );
1399: --
1400: --
1401: hr_utility.set_location(' Leaving:'||l_proc, 10);
1402: End insert_validate;
1403: --
1404: -- ----------------------------------------------------------------------------
1405: -- |---------------------------< update_validate >----------------------------|

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

1414: --
1415: l_proc varchar2(72) := g_package||'update_validate';
1416: --
1417: Begin
1418: hr_utility.set_location('Entering:'||l_proc, 5);
1419: --
1420: -- Call all supporting business operations
1421: --
1422: --

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

1501: ,p_rec => p_rec
1502: );
1503: --
1504: --
1505: hr_utility.set_location(' Leaving:'||l_proc, 10);
1506: End update_validate;
1507: --
1508: -- ----------------------------------------------------------------------------
1509: -- |---------------------------< delete_validate >----------------------------|

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

1518: --
1519: l_proc varchar2(72) := g_package||'delete_validate';
1520: --
1521: Begin
1522: hr_utility.set_location('Entering:'||l_proc, 5);
1523: --
1524: --
1525: chk_startup_action(false
1526: ,pay_frr_shd.g_old_rec.business_group_id

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

1547: ,p_validation_end_date => p_validation_end_date
1548: ,p_formula_result_rule_id => p_rec.formula_result_rule_id
1549: );
1550: --
1551: hr_utility.set_location(' Leaving:'||l_proc, 10);
1552: End delete_validate;
1553: --
1554: end pay_frr_bus;