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.PQH_ATTRIBUTE_RANGES_PKG dependencies on HR_UTILITY

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

94: l_att_tab att_tab := p_att_tab;
95: --
96: Begin
97: --
98: hr_utility.set_location('Entering:'||l_proc, 5);
99: --
100: -- If primary flag is 'Y' , return list identifiers
101: --
102: if primary_flag = 'Y' then

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

147: -- Decrement no_attr by 1 to account for the last fetch that failed.
148: --
149: no_attr := no_attr - 1;
150: --
151: hr_utility.set_location('Leaving:'||l_proc, 10);
152: --
153: exception when others then
154: p_att_tab := l_att_tab;
155: no_attr := null;

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

180: l_proc varchar2(72) := g_package||'fetch_ranges';
181: --
182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: sql_stmt := 'select attribute_range_id,attribute_id,from_char,to_char,from_date,to_date,from_number,to_number,object_version_number from pqh_attribute_ranges where routing_category_id = :p and range_name = :r and ';
187:
188: if p_primary_flag = 'Y' then

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

225: close ranges_cur;
226: --
227: cnt := cnt - 1;
228: --
229: hr_utility.set_location('Leaving:'||l_proc, 10);
230: --
231: exception when others then
232: p_att_ranges_tab := l_att_ranges_tab;
233: raise;

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

266: l_proc varchar2(72) := g_package||'chk_routing_range_overlap';
267: --
268: Begin
269: --
270: hr_utility.set_location('Entering:'||l_proc, 5);
271: --
272: p_attr_tab1 := tab1;
273: p_attr_tab2 := tab2;
274: --

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

311: End if;
312: --
313: End if;
314: --
315: hr_utility.set_location('Leaving:'||l_proc, 10);
316: --
317: End chk_routing_range_overlap;
318: --
319: --

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

345: l_proc varchar2(72) := g_package||'chk_member_range_overlap';
346: --
347: Begin
348: --
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: p_attr_tab1 := tab1;
352: p_attr_tab2 := tab2;
353: --

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

384: End if;
385: --
386: End if;
387: --
388: hr_utility.set_location('Leaving:'||l_proc, 10);
389: --
390: RETURN 0;
391: --
392: End chk_member_range_overlap;

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

418: --
419: --
420: Begin
421: --
422: hr_utility.set_location('Entering:'||l_proc, 5);
423: --
424: sql_stmt := 'Select a.routing_category_id,a.range_name,a.attribute_id,a.from_char,a.to_char,a.from_number,a.to_number,a.from_date,a.to_date '
425: ||' from pqh_attribute_ranges a,pqh_routing_categories b '
426: ||' where a.routing_category_id = :p_routing_category_id AND a.routing_category_id = b.routing_category_id AND b.transaction_category_id = :p_transaction_category_id and a.attribute_id IS NOT NULL'

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

471: p_db_rows := p_db_rows - 1;
472: --
473: close other_ranges_cur;
474: --
475: hr_utility.set_location('Leaving:'||l_proc, 10);
476: --
477: exception when others then
478: p_db_ranges := l_db_ranges;
479: p_db_rows := null;

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

500: l_proc varchar2(72) := g_package||'select_other_routing_rules';
501: --
502: Begin
503: --
504: hr_utility.set_location('Entering:'||l_proc, 5);
505: --
506: -- The foll cursor selects all other routing rules under the transcation
507: -- category against which the current rule will be checked for overlap.
508: --

Line 554: hr_utility.set_location('Other rcat :'||to_char( p_db_ranges(p_db_rows).routing_category_id),9);

550: p_db_ranges(p_db_rows).to_date;
551:
552: Exit when other_ranges_cur%notfound;
553: --
554: hr_utility.set_location('Other rcat :'||to_char( p_db_ranges(p_db_rows).routing_category_id),9);
555: hr_utility.set_location('Other Rule :'||p_db_ranges(p_db_rows).range_name,9);
556: p_db_rows := p_db_rows + 1;
557: --
558: End loop;

Line 555: hr_utility.set_location('Other Rule :'||p_db_ranges(p_db_rows).range_name,9);

551:
552: Exit when other_ranges_cur%notfound;
553: --
554: hr_utility.set_location('Other rcat :'||to_char( p_db_ranges(p_db_rows).routing_category_id),9);
555: hr_utility.set_location('Other Rule :'||p_db_ranges(p_db_rows).range_name,9);
556: p_db_rows := p_db_rows + 1;
557: --
558: End loop;
559: --

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

560: p_db_rows := p_db_rows - 1;
561: --
562: close other_ranges_cur;
563: --
564: hr_utility.set_location('Leaving:'||l_proc, 10);
565: --
566: exception when others then
567: p_db_ranges := l_db_ranges;
568: p_db_rows := null;

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

592: l_proc varchar2(72) := g_package||'form_db_table';
593: --
594: begin
595: --
596: hr_utility.set_location('Entering:'||l_proc, 5);
597: --
598: prev_rcat_id := p_db_ranges(1).routing_category_id;
599: prev_range_name := p_db_ranges(1).range_name;
600:

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

689: p_error_range_name := prev_range_name;
690: return 1;
691: end if;
692:
693: hr_utility.set_location('Leaving:'||l_proc,10);
694: --
695: Return 0;
696: End form_db_table;
697: --

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

711: l_proc varchar2(72) := g_package||'check_unique_rules';
712: --
713: Begin
714: --
715: hr_utility.set_location('Entering:'||l_proc, 5);
716: --
717: tab1 := p_table1;
718: tab2 := p_table2;
719:

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

764: If unique_flag = p_no_attributes then
765: return 1;
766: End if;
767: return 0;
768: hr_utility.set_location('Leaving:'||l_proc, 10);
769: --
770: End check_unique_rules;
771: --
772: -- ----------------------------------------------------------------------------

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

789: l_proc varchar2(72) := g_package||'assign_right_values';
790: --
791: Begin
792: --
793: hr_utility.set_location('Entering:'||l_proc, 5);
794: --
795: p_dest_from_char := p_src_from_char;
796: p_dest_to_char := p_src_to_char;
797: p_dest_from_number := p_src_from_number;

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

798: p_dest_to_number := p_src_to_number;
799: p_dest_from_date := p_src_from_date;
800: p_dest_to_date := p_src_to_date ;
801: --
802: hr_utility.set_location('Leaving:'||l_proc, 10);
803: --
804: End assign_right_values;
805: -- ----------------------------------------------------------------------------
806: -- | Delete_attribute_ranges

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

840: l_proc varchar2(72) := g_package||'Delete_atrribute_ranges';
841: --
842: Begin
843: --
844: hr_utility.set_location('Entering:'||l_proc, 5);
845: --
846: if p_primary_flag = 'Y' then
847: --
848: Open c1;

Line 872: hr_utility.set_message(8302,'PQH_CANNOT_UNCHECK_LIST_IDENT');

868: --
869: Elsif p_delete_attr_ranges_flag = 'N' then
870: --
871: Close c1;
872: hr_utility.set_message(8302,'PQH_CANNOT_UNCHECK_LIST_IDENT');
873: hr_utility.raise_error;
874: --
875: Elsif p_delete_attr_ranges_flag = 'I' then
876: --

Line 873: hr_utility.raise_error;

869: Elsif p_delete_attr_ranges_flag = 'N' then
870: --
871: Close c1;
872: hr_utility.set_message(8302,'PQH_CANNOT_UNCHECK_LIST_IDENT');
873: hr_utility.raise_error;
874: --
875: Elsif p_delete_attr_ranges_flag = 'I' then
876: --
877: -- Ignore.

Line 913: hr_utility.set_message(8302,'PQH_CANNOT_UNCHECK_MEM_IDENT');

909: --
910: Elsif p_delete_attr_ranges_flag = 'N' then
911: --
912: Close c2;
913: hr_utility.set_message(8302,'PQH_CANNOT_UNCHECK_MEM_IDENT');
914: hr_utility.raise_error;
915: --
916: Elsif p_delete_attr_ranges_flag = 'I' then
917: --

Line 914: hr_utility.raise_error;

910: Elsif p_delete_attr_ranges_flag = 'N' then
911: --
912: Close c2;
913: hr_utility.set_message(8302,'PQH_CANNOT_UNCHECK_MEM_IDENT');
914: hr_utility.raise_error;
915: --
916: Elsif p_delete_attr_ranges_flag = 'I' then
917: --
918: -- Ignore.

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

929: --
930: End if;
931: --
932: --
933: hr_utility.set_location('Leaving:'||l_proc, 10);
934: --
935: End;
936: --
937: ----------Wrapper for DML's for PQH_ATTRIBUTE_RANGES--------------------------

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

964: l_proc varchar2(72) := g_package||'on_insert_atrribute_ranges';
965: --
966: Begin
967: --
968: hr_utility.set_location('Entering:'||l_proc, 5);
969: --
970: -- Concatenate all attribute_range_id 's in ins_attr_ranges_table
971: -- into attribute_range_id_list;
972: --

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

1022: );
1023: --
1024: End loop;
1025: --
1026: hr_utility.set_location('Leaving:'||l_proc, 10);
1027: --
1028: exception when others then
1029: ins_attr_ranges_table := l_ins_attr_ranges_table;
1030: raise;

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

1051: --
1052: l_proc varchar2(72) := g_package||'insert_update_delete_ranges';
1053: --
1054: Begin
1055: hr_utility.set_location('Entering:'||l_proc, 5);
1056:
1057: for ctr in 1..p_no_attributes loop
1058: if ctr = 1 then
1059: attribute_id_list := '(';

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

1138: End if;
1139: --
1140: End loop;
1141: --
1142: hr_utility.set_location('Leaving:'||l_proc, 10);
1143: exception when others then
1144: p_attr_ranges_table := l_attr_ranges_table;
1145: raise;
1146: --

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

1159: --
1160: l_proc varchar2(72) := g_package||'on_delete_attribute_ranges';
1161: --
1162: Begin
1163: hr_utility.set_location('Entering:'||l_proc, 5);
1164: --
1165: for ctr in 1..p_no_attributes loop
1166:
1167: if del_attr_ranges_table(ctr).attribute_range_id IS NOT NULL then

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

1175: End if;
1176:
1177: End loop;
1178: --
1179: hr_utility.set_location('Leaving:'||l_proc, 10);
1180: --
1181: exception when others then
1182: del_attr_ranges_table := l_del_attr_ranges_table;
1183: raise;

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

1205: exist_range_name pqh_attribute_ranges.range_name%type;
1206:
1207: Begin
1208: --
1209: hr_utility.set_location('Entering:'||l_proc, 5);
1210: --
1211: sql_stmt := 'Select distinct range_name from pqh_attribute_ranges where routing_category_id = :r AND attribute_id IS NOT NULL AND attribute_range_id not in '||p_attribute_id_list;
1212:
1213: if p_primary_flag = 'Y' then

Line 1225: hr_utility.set_message(8302, 'PQH_DUPLICATE_RANGE_NAME');

1221: Loop
1222: Fetch range_name_cur into exist_range_name;
1223: exit when range_name_cur%notfound;
1224: if exist_range_name = p_range_name then
1225: hr_utility.set_message(8302, 'PQH_DUPLICATE_RANGE_NAME');
1226: hr_utility.raise_error;
1227: end if;
1228: End loop;
1229: --

Line 1226: hr_utility.raise_error;

1222: Fetch range_name_cur into exist_range_name;
1223: exit when range_name_cur%notfound;
1224: if exist_range_name = p_range_name then
1225: hr_utility.set_message(8302, 'PQH_DUPLICATE_RANGE_NAME');
1226: hr_utility.raise_error;
1227: end if;
1228: End loop;
1229: --
1230: hr_utility.set_location('Leaving:'||l_proc, 10);

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

1226: hr_utility.raise_error;
1227: end if;
1228: End loop;
1229: --
1230: hr_utility.set_location('Leaving:'||l_proc, 10);
1231: --
1232: End;
1233: --
1234: -----------------------------------------------------------------------------

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

1286: l_proc varchar2(72) := g_package||'chk_enable_routing_category';
1287: --
1288: Begin
1289: --
1290: hr_utility.set_location('Entering:'||l_proc, 5);
1291: --
1292: Open csr_list_ident_cnt;
1293: Fetch csr_list_ident_cnt into l_no_list_identifiers;
1294: Close csr_list_ident_cnt;

Line 1344: hr_utility.set_location('Closing cursor',100);

1340: l_from_char,l_to_char,
1341: l_from_number,l_to_number,
1342: l_from_date,l_to_date;
1343: If csr_enable_routing%notfound then
1344: hr_utility.set_location('Closing cursor',100);
1345: Close csr_enable_routing;
1346: exit;
1347: End if;
1348: --

Line 1353: hr_utility.set_location('New rule:'||l_range_name ||l_proc, 6);

1349: --
1350: -- Check if there is a change in rule name
1351: --
1352: If nvl(l_range_name,'xXx') <> nvl(l_prev_range_name,hr_api.g_varchar2) then
1353: hr_utility.set_location('New rule:'||l_range_name ||l_proc, 6);
1354: --
1355: If cnt > 0 then
1356: hr_utility.set_location('Rules exist '||l_proc, 6);
1357: --

Line 1356: hr_utility.set_location('Rules exist '||l_proc, 6);

1352: If nvl(l_range_name,'xXx') <> nvl(l_prev_range_name,hr_api.g_varchar2) then
1353: hr_utility.set_location('New rule:'||l_range_name ||l_proc, 6);
1354: --
1355: If cnt > 0 then
1356: hr_utility.set_location('Rules exist '||l_proc, 6);
1357: --
1358: -- call chk_routing_range_overlap procedure to check if this rule
1359: -- overlaps with any other routing rules under that
1360: -- transaction category.

Line 1362: hr_utility.set_location('Calling chk_routing_range_overlap:'||to_char(l_no_list_identifiers), 100);

1358: -- call chk_routing_range_overlap procedure to check if this rule
1359: -- overlaps with any other routing rules under that
1360: -- transaction category.
1361: --
1362: hr_utility.set_location('Calling chk_routing_range_overlap:'||to_char(l_no_list_identifiers), 100);
1363: chk_routing_range_overlap
1364: (tab1 => all_routing_rules ,
1365: tab2 => all_attributes_tab,
1366: p_routing_type => l_routing_type,

Line 1382: hr_utility.set_location('Reset counter'||l_proc, 6);

1378: End if;
1379: --
1380: End if;
1381: -- Reset counters
1382: hr_utility.set_location('Reset counter'||l_proc, 6);
1383: --
1384: cnt := 1;
1385: l_prev_range_name := l_range_name;
1386: --

Line 1393: hr_utility.set_location('Increment counter'||l_proc, 6);

1389: p_error_range_name := NULL;
1390: l_attribute_range_id_list := NULL;
1391: --
1392: Else
1393: hr_utility.set_location('Increment counter'||l_proc, 6);
1394: -- If we are processing same rule , increment counter
1395: cnt := cnt + 1;
1396: l_attribute_range_id_list := l_attribute_range_id_list || ',';
1397:

Line 1418: hr_utility.set_location('Rules exist '||l_proc, 6);

1414: End loop;
1415: --
1416: If cnt > 0 then
1417: --
1418: hr_utility.set_location('Rules exist '||l_proc, 6);
1419: --
1420: -- call chk_routing_range_overlap procedure to check if this rule
1421: -- overlaps with any other routing rules under that
1422: -- transaction category.

Line 1424: hr_utility.set_location('Calling chk_routing_range_overlap:'||to_char(l_no_list_identifiers), 100);

1420: -- call chk_routing_range_overlap procedure to check if this rule
1421: -- overlaps with any other routing rules under that
1422: -- transaction category.
1423: --
1424: hr_utility.set_location('Calling chk_routing_range_overlap:'||to_char(l_no_list_identifiers), 100);
1425: --
1426: chk_routing_range_overlap
1427: (tab1 => all_routing_rules ,
1428: tab2 => all_attributes_tab,

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

1442: End if;
1443: --
1444: End if;
1445: --
1446: hr_utility.set_location('Leaving'||l_proc, 10);
1447: --
1448: RETURN 0;
1449: --
1450: End;

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

1480: l_proc varchar2(72) := g_package||'chk_overlap_on_freeze_cat';
1481: --
1482: Begin
1483: --
1484: hr_utility.set_location('Entering:'||l_proc, 5);
1485: --
1486: -- Obtain the routing type of the transaction category
1487: --
1488: open csr_routing_type;

Line 1546: hr_utility.set_message(8302,'PQH_ROUT_OVERLAP_ON_CAT_FREEZE');

1542: pqh_tct_bus.get_routing_category_name
1543: (p_routing_category_id => l_routing_category_id,
1544: p_routing_category_name => l_overlap_routing_category);
1545: --
1546: hr_utility.set_message(8302,'PQH_ROUT_OVERLAP_ON_CAT_FREEZE');
1547: hr_utility.set_message_token('ROUT1',l_overlap_routing_category);
1548: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1549: hr_utility.set_message_token('ROUT2',l_error_routing_category);
1550: hr_utility.set_message_token('RULE2',l_error_range_name);

Line 1547: hr_utility.set_message_token('ROUT1',l_overlap_routing_category);

1543: (p_routing_category_id => l_routing_category_id,
1544: p_routing_category_name => l_overlap_routing_category);
1545: --
1546: hr_utility.set_message(8302,'PQH_ROUT_OVERLAP_ON_CAT_FREEZE');
1547: hr_utility.set_message_token('ROUT1',l_overlap_routing_category);
1548: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1549: hr_utility.set_message_token('ROUT2',l_error_routing_category);
1550: hr_utility.set_message_token('RULE2',l_error_range_name);
1551: hr_utility.raise_error;

Line 1548: hr_utility.set_message_token('RULE1',l_overlap_range_name);

1544: p_routing_category_name => l_overlap_routing_category);
1545: --
1546: hr_utility.set_message(8302,'PQH_ROUT_OVERLAP_ON_CAT_FREEZE');
1547: hr_utility.set_message_token('ROUT1',l_overlap_routing_category);
1548: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1549: hr_utility.set_message_token('ROUT2',l_error_routing_category);
1550: hr_utility.set_message_token('RULE2',l_error_range_name);
1551: hr_utility.raise_error;
1552: --

Line 1549: hr_utility.set_message_token('ROUT2',l_error_routing_category);

1545: --
1546: hr_utility.set_message(8302,'PQH_ROUT_OVERLAP_ON_CAT_FREEZE');
1547: hr_utility.set_message_token('ROUT1',l_overlap_routing_category);
1548: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1549: hr_utility.set_message_token('ROUT2',l_error_routing_category);
1550: hr_utility.set_message_token('RULE2',l_error_range_name);
1551: hr_utility.raise_error;
1552: --
1553: End if;

Line 1550: hr_utility.set_message_token('RULE2',l_error_range_name);

1546: hr_utility.set_message(8302,'PQH_ROUT_OVERLAP_ON_CAT_FREEZE');
1547: hr_utility.set_message_token('ROUT1',l_overlap_routing_category);
1548: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1549: hr_utility.set_message_token('ROUT2',l_error_routing_category);
1550: hr_utility.set_message_token('RULE2',l_error_range_name);
1551: hr_utility.raise_error;
1552: --
1553: End if;
1554: --

Line 1551: hr_utility.raise_error;

1547: hr_utility.set_message_token('ROUT1',l_overlap_routing_category);
1548: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1549: hr_utility.set_message_token('ROUT2',l_error_routing_category);
1550: hr_utility.set_message_token('RULE2',l_error_range_name);
1551: hr_utility.raise_error;
1552: --
1553: End if;
1554: --
1555: End loop;

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

1553: End if;
1554: --
1555: End loop;
1556: --
1557: hr_utility.set_location('Leaving:'||l_proc, 10);
1558: --
1559: End;
1560: --
1561: ----------------------------------------------------------------------------

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

1571: l_proc varchar2(72) := g_package||'get_member_name';
1572: --
1573: Begin
1574: --
1575: hr_utility.set_location('Entering:'||l_proc, 5);
1576: --
1577: If p_routing_type = 'R' then
1578: --
1579: sql_stmt := 'Select decode(RLM.user_id,NULL,RLM.role_name,RLM.user_name'

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

1598: p_member_name := pqh_utility.decode_assignment_name( p_member_id);
1599: --
1600: End if;
1601: --
1602: hr_utility.set_location('Leaving:'||l_proc, 10);
1603: exception when others then
1604: p_member_name := null;
1605: raise;
1606: --

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

1667: l_proc varchar2(72) := g_package||'chk_mem_overlap_on_freeze';
1668: --
1669: Begin
1670: --
1671: hr_utility.set_location('Entering:'||l_proc, 5);
1672: --
1673: Open csr_mem_ident_cnt;
1674: Fetch csr_mem_ident_cnt into l_no_mem_identifiers;
1675: Close csr_mem_ident_cnt;

Line 1759: hr_utility.set_location('Closing cursor',100);

1755: l_from_char,l_to_char,
1756: l_from_number,l_to_number,
1757: l_from_date,l_to_date;
1758: If csr_mem_overlap%notfound then
1759: hr_utility.set_location('Closing cursor',100);
1760: Close csr_mem_overlap;
1761: exit;
1762: End if;
1763: --

Line 1770: hr_utility.set_location('New rule:'||l_range_name ||l_proc, 6);

1766: --
1767: If l_routing_category_id <> l_prev_routing_category_id OR
1768: nvl(l_range_name,'xXx') <> nvl(l_prev_range_name,hr_api.g_varchar2) then
1769: --
1770: hr_utility.set_location('New rule:'||l_range_name ||l_proc, 6);
1771: --
1772: If cnt > 0 then
1773: hr_utility.set_location('Rules exist '||l_proc, 6);
1774: --

Line 1773: hr_utility.set_location('Rules exist '||l_proc, 6);

1769: --
1770: hr_utility.set_location('New rule:'||l_range_name ||l_proc, 6);
1771: --
1772: If cnt > 0 then
1773: hr_utility.set_location('Rules exist '||l_proc, 6);
1774: --
1775: -- call chk_routing_range_overlap procedure to check if this rule
1776: -- overlaps with any other routing rules under that
1777: -- transaction category.

Line 1779: hr_utility.set_location('Calling chk_member_range_overlap:'||l_proc, 6);

1775: -- call chk_routing_range_overlap procedure to check if this rule
1776: -- overlaps with any other routing rules under that
1777: -- transaction category.
1778: --
1779: hr_utility.set_location('Calling chk_member_range_overlap:'||l_proc, 6);
1780: l_error_code := chk_member_range_overlap
1781: (tab1 => all_routing_rules ,
1782: tab2 => all_attributes_tab,
1783: p_transaction_category_id => p_transaction_category_id,

Line 1807: hr_utility.set_message(8302,'PQH_MEM_OVERLAP_ON_CAT_FREEZE');

1803: get_member_name(p_member_id => l_prev_member_id,
1804: p_routing_type => l_routing_type,
1805: p_member_name => l_member_name);
1806: --
1807: hr_utility.set_message(8302,'PQH_MEM_OVERLAP_ON_CAT_FREEZE');
1808: hr_utility.set_message_token('ROUT1',l_error_routing_category);
1809: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1810: hr_utility.set_message_token('RULE2',l_error_range_name);
1811: hr_utility.set_message_token('MEMBER_NAME',l_member_name);

Line 1808: hr_utility.set_message_token('ROUT1',l_error_routing_category);

1804: p_routing_type => l_routing_type,
1805: p_member_name => l_member_name);
1806: --
1807: hr_utility.set_message(8302,'PQH_MEM_OVERLAP_ON_CAT_FREEZE');
1808: hr_utility.set_message_token('ROUT1',l_error_routing_category);
1809: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1810: hr_utility.set_message_token('RULE2',l_error_range_name);
1811: hr_utility.set_message_token('MEMBER_NAME',l_member_name);
1812: hr_utility.raise_error;

Line 1809: hr_utility.set_message_token('RULE1',l_overlap_range_name);

1805: p_member_name => l_member_name);
1806: --
1807: hr_utility.set_message(8302,'PQH_MEM_OVERLAP_ON_CAT_FREEZE');
1808: hr_utility.set_message_token('ROUT1',l_error_routing_category);
1809: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1810: hr_utility.set_message_token('RULE2',l_error_range_name);
1811: hr_utility.set_message_token('MEMBER_NAME',l_member_name);
1812: hr_utility.raise_error;
1813: --

Line 1810: hr_utility.set_message_token('RULE2',l_error_range_name);

1806: --
1807: hr_utility.set_message(8302,'PQH_MEM_OVERLAP_ON_CAT_FREEZE');
1808: hr_utility.set_message_token('ROUT1',l_error_routing_category);
1809: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1810: hr_utility.set_message_token('RULE2',l_error_range_name);
1811: hr_utility.set_message_token('MEMBER_NAME',l_member_name);
1812: hr_utility.raise_error;
1813: --
1814: End if;

Line 1811: hr_utility.set_message_token('MEMBER_NAME',l_member_name);

1807: hr_utility.set_message(8302,'PQH_MEM_OVERLAP_ON_CAT_FREEZE');
1808: hr_utility.set_message_token('ROUT1',l_error_routing_category);
1809: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1810: hr_utility.set_message_token('RULE2',l_error_range_name);
1811: hr_utility.set_message_token('MEMBER_NAME',l_member_name);
1812: hr_utility.raise_error;
1813: --
1814: End if;
1815: --

Line 1812: hr_utility.raise_error;

1808: hr_utility.set_message_token('ROUT1',l_error_routing_category);
1809: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1810: hr_utility.set_message_token('RULE2',l_error_range_name);
1811: hr_utility.set_message_token('MEMBER_NAME',l_member_name);
1812: hr_utility.raise_error;
1813: --
1814: End if;
1815: --
1816: End if;

Line 1818: hr_utility.set_location('Reset counter'||l_proc, 6);

1814: End if;
1815: --
1816: End if;
1817: -- Reset counters
1818: hr_utility.set_location('Reset counter'||l_proc, 6);
1819: --
1820: cnt := 1;
1821: l_prev_routing_category_id := l_routing_category_id;
1822: l_prev_range_name := l_range_name;

Line 1831: hr_utility.set_location('Increment counter'||l_proc, 6);

1827: l_error_range_name := NULL;
1828: l_attribute_range_id_list := NULL;
1829: --
1830: Else
1831: hr_utility.set_location('Increment counter'||l_proc, 6);
1832: -- If we are processing same rule , increment counter
1833: cnt := cnt + 1;
1834: l_attribute_range_id_list := l_attribute_range_id_list || ',';
1835:

Line 1855: hr_utility.set_location('Rules exist '||l_proc, 6);

1851: End loop;
1852: --
1853: If cnt > 0 then
1854: --
1855: hr_utility.set_location('Rules exist '||l_proc, 6);
1856: --
1857: -- call chk_routing_range_overlap procedure to check if this rule
1858: -- overlaps with any other routing rules under that
1859: -- transaction category.

Line 1861: hr_utility.set_location('Calling chk_routing_range_overlap:'||l_proc, 6);

1857: -- call chk_routing_range_overlap procedure to check if this rule
1858: -- overlaps with any other routing rules under that
1859: -- transaction category.
1860: --
1861: hr_utility.set_location('Calling chk_routing_range_overlap:'||l_proc, 6);
1862: --
1863: l_error_code := chk_member_range_overlap
1864: (tab1 => all_routing_rules ,
1865: tab2 => all_attributes_tab,

Line 1892: hr_utility.set_message(8302,'PQH_MEM_OVERLAP_ON_CAT_FREEZE');

1888: p_routing_type => l_routing_type,
1889: p_member_name => l_member_name);
1890: --
1891: --
1892: hr_utility.set_message(8302,'PQH_MEM_OVERLAP_ON_CAT_FREEZE');
1893: hr_utility.set_message_token('ROUT1',l_error_routing_category);
1894: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1895: hr_utility.set_message_token('RULE2',l_error_range_name);
1896: hr_utility.set_message_token('MEMBER_NAME',l_member_name);

Line 1893: hr_utility.set_message_token('ROUT1',l_error_routing_category);

1889: p_member_name => l_member_name);
1890: --
1891: --
1892: hr_utility.set_message(8302,'PQH_MEM_OVERLAP_ON_CAT_FREEZE');
1893: hr_utility.set_message_token('ROUT1',l_error_routing_category);
1894: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1895: hr_utility.set_message_token('RULE2',l_error_range_name);
1896: hr_utility.set_message_token('MEMBER_NAME',l_member_name);
1897: hr_utility.raise_error;

Line 1894: hr_utility.set_message_token('RULE1',l_overlap_range_name);

1890: --
1891: --
1892: hr_utility.set_message(8302,'PQH_MEM_OVERLAP_ON_CAT_FREEZE');
1893: hr_utility.set_message_token('ROUT1',l_error_routing_category);
1894: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1895: hr_utility.set_message_token('RULE2',l_error_range_name);
1896: hr_utility.set_message_token('MEMBER_NAME',l_member_name);
1897: hr_utility.raise_error;
1898: --

Line 1895: hr_utility.set_message_token('RULE2',l_error_range_name);

1891: --
1892: hr_utility.set_message(8302,'PQH_MEM_OVERLAP_ON_CAT_FREEZE');
1893: hr_utility.set_message_token('ROUT1',l_error_routing_category);
1894: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1895: hr_utility.set_message_token('RULE2',l_error_range_name);
1896: hr_utility.set_message_token('MEMBER_NAME',l_member_name);
1897: hr_utility.raise_error;
1898: --
1899: End if;

Line 1896: hr_utility.set_message_token('MEMBER_NAME',l_member_name);

1892: hr_utility.set_message(8302,'PQH_MEM_OVERLAP_ON_CAT_FREEZE');
1893: hr_utility.set_message_token('ROUT1',l_error_routing_category);
1894: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1895: hr_utility.set_message_token('RULE2',l_error_range_name);
1896: hr_utility.set_message_token('MEMBER_NAME',l_member_name);
1897: hr_utility.raise_error;
1898: --
1899: End if;
1900: --

Line 1897: hr_utility.raise_error;

1893: hr_utility.set_message_token('ROUT1',l_error_routing_category);
1894: hr_utility.set_message_token('RULE1',l_overlap_range_name);
1895: hr_utility.set_message_token('RULE2',l_error_range_name);
1896: hr_utility.set_message_token('MEMBER_NAME',l_member_name);
1897: hr_utility.raise_error;
1898: --
1899: End if;
1900: --
1901: End if;

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

1899: End if;
1900: --
1901: End if;
1902: --
1903: hr_utility.set_location('Leaving'||l_proc, 10);
1904: --
1905: --
1906: End;
1907: --