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

Line 84: hr_utility.set_location('going for deleting matrix values row',100);

80: p_rate_matrix_node_id in number,
81: p_mode in varchar2
82: ) is
83: begin
84: hr_utility.set_location('going for deleting matrix values row',100);
85: /*
86: if p_mode = 'CREATE' then
87: delete from ben_copy_entity_results where INFORMATION161 = p_rate_matrix_node_id and copy_entity_txn_id = p_copy_entity_txn_id and table_alias = 'RMV';
88: else

Line 98: hr_utility.set_location('issues in deleting matrix values row',100);

94: update ben_copy_entity_results set dml_operation = 'DELETE',datetrack_mode = 'DELETE' where INFORMATION161 = p_rate_matrix_node_id and copy_entity_txn_id = p_copy_entity_txn_id and table_alias = 'RMV' and dml_operation in ('UPDATE','COPIED');
95:
96: exception
97: when others then
98: hr_utility.set_location('issues in deleting matrix values row',100);
99: raise;
100: end delete_matrix_values;
101:
102: procedure delete_matrix_rates(p_copy_entity_txn_id in number,

Line 107: hr_utility.set_location('going for deleting matrix rates row',100);

103: p_rate_matrix_node_id in number,
104: p_mode in varchar2
105: ) is
106: begin
107: hr_utility.set_location('going for deleting matrix rates row',100);
108: /*
109: if p_mode = 'CREATE' then
110: delete from ben_copy_entity_results where INFORMATION161 = p_rate_matrix_node_id and copy_entity_txn_id = p_copy_entity_txn_id and table_alias = 'RMR';
111: else

Line 121: hr_utility.set_location('issues in deleting matrix rates row',100);

117:
118:
119: exception
120: when others then
121: hr_utility.set_location('issues in deleting matrix rates row',100);
122: raise;
123: end delete_matrix_rates;
124:
125:

Line 144: hr_utility.set_location('going for deleting matrix nodes row',100);

140: information13 = p_short_code and
141: Information261 = p_pl_id and
142: TABLE_ALIAS = 'RMN';
143: begin
144: hr_utility.set_location('going for deleting matrix nodes row',100);
145:
146: -- USE THIS IF YOU ARE NOT CALLING VOROW.REMOVE IN AM
147: delete from ben_copy_entity_results where
148: Copy_entity_txn_id = p_copy_entity_txn_id and

Line 163: hr_utility.set_location('deleting hgrid criteria rows',110);

159: Information261 = p_pl_id and
160: TABLE_ALIAS = 'RBC_CRIT' and
161: dml_operation in ('UPDATE','COPIED');
162:
163: hr_utility.set_location('deleting hgrid criteria rows',110);
164:
165: open c1;
166: fetch c1 into l_rate_matrix_node_id;
167: if c1%notfound then

Line 195: hr_utility.set_location('issues in deleting matrix nodes row',100);

191: dml_operation in ('UPDATE','COPIED');
192:
193: exception
194: when others then
195: hr_utility.set_location('issues in deleting matrix nodes row',100);
196: raise;
197: end delete_matrix_nodes;
198:
199:

Line 282: hr_utility.set_location('going for creating cet row',100);

278: p_copy_entity_txn_id out nocopy number) is
279: l_rbc_txn_cat number;
280: l_ovn number;
281: begin
282: hr_utility.set_location('going for creating cet row',100);
283: begin
284: select transaction_category_id
285: into l_rbc_txn_cat
286: from pqh_transaction_categories

Line 289: hr_utility.set_location('txn_cat is'||l_rbc_txn_cat,100);

285: into l_rbc_txn_cat
286: from pqh_transaction_categories
287: where short_name ='CRITERIA'
288: and business_group_id is null;
289: hr_utility.set_location('txn_cat is'||l_rbc_txn_cat,100);
290: exception
291: when others then
292: hr_utility.set_location('txn_cat doesnot exist',100);
293: raise;

Line 292: hr_utility.set_location('txn_cat doesnot exist',100);

288: and business_group_id is null;
289: hr_utility.set_location('txn_cat is'||l_rbc_txn_cat,100);
290: exception
291: when others then
292: hr_utility.set_location('txn_cat doesnot exist',100);
293: raise;
294: end;
295: if l_rbc_txn_cat is not null then
296: pqh_copy_entity_txns_api.create_COPY_ENTITY_TXN

Line 313: hr_utility.set_location('issues in creating CET row',100);

309: ) ;
310: end if;
311: exception
312: when others then
313: hr_utility.set_location('issues in creating CET row',100);
314: raise;
315: end create_criteria_txn;
316: /*
317: procedure create_criteria_cer (p_copy_entity_txn_id in number,

Line 407: hr_utility.set_location('table route is'||l_egl_tr_name,10);

403: pqh_gsp_hr_to_stage.get_table_route_details
404: (p_table_alias => 'EGL',
405: p_table_route_id => l_egl_tr_id,
406: p_table_name => l_egl_tr_name);
407: hr_utility.set_location('table route is'||l_egl_tr_name,10);
408:
409:
410: for l_egl_rec in c1 loop
411: if l_egl_rec.col1_value_set_id is not null then

Line 416: hr_utility.set_location('value set name is'||l_flex_value_set_name,10);

412: SELECT flex_value_set_name
413: into l_flex_value_set_name
414: FROM fnd_flex_value_sets
415: WHERE flex_value_set_id = l_egl_rec.col1_value_set_id;
416: hr_utility.set_location('value set name is'||l_flex_value_set_name,10);
417: else
418: hr_utility.set_location('value set is not used',10);
419: end if;
420:

Line 418: hr_utility.set_location('value set is not used',10);

414: FROM fnd_flex_value_sets
415: WHERE flex_value_set_id = l_egl_rec.col1_value_set_id;
416: hr_utility.set_location('value set name is'||l_flex_value_set_name,10);
417: else
418: hr_utility.set_location('value set is not used',10);
419: end if;
420:
421: -- copy every thing similar to copy_egl_row but keep our business_group_id instead
422:

Line 521: hr_utility.set_location('table route is'||l_egl_tr_name,10);

517: pqh_gsp_hr_to_stage.get_table_route_details
518: (p_table_alias => 'EGL',
519: p_table_route_id => l_egl_tr_id,
520: p_table_name => l_egl_tr_name);
521: hr_utility.set_location('table route is'||l_egl_tr_name,10);
522: for l_egl_rec in c1 loop
523: if l_egl_rec.col1_value_set_id is not null then
524: SELECT flex_value_set_name
525: into l_flex_value_set_name

Line 528: hr_utility.set_location('value set name is'||l_flex_value_set_name,10);

524: SELECT flex_value_set_name
525: into l_flex_value_set_name
526: FROM fnd_flex_value_sets
527: WHERE flex_value_set_id = l_egl_rec.col1_value_set_id;
528: hr_utility.set_location('value set name is'||l_flex_value_set_name,10);
529: else
530: hr_utility.set_location('value set is not used',10);
531: end if;
532: ben_copy_entity_results_api.create_copy_entity_results (

Line 530: hr_utility.set_location('value set is not used',10);

526: FROM fnd_flex_value_sets
527: WHERE flex_value_set_id = l_egl_rec.col1_value_set_id;
528: hr_utility.set_location('value set name is'||l_flex_value_set_name,10);
529: else
530: hr_utility.set_location('value set is not used',10);
531: end if;
532: ben_copy_entity_results_api.create_copy_entity_results (
533: p_copy_entity_result_id => l_egl_cer_id,
534: p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 835: hr_utility.set_location('creating cet row',10);

831: l_eligy_criteria_id_new number;
832: begin
833:
834: if p_mode ='CREATE' and p_copy_entity_txn_id is null then
835: hr_utility.set_location('creating cet row',10);
836: create_criteria_txn(p_mode => p_mode,
837: p_business_area => p_business_area,
838: p_business_group_id => p_business_group_id,
839: p_effective_date => p_effective_date,

Line 843: hr_utility.set_location('populate out params',10);

839: p_effective_date => p_effective_date,
840: p_copy_entity_txn_id => l_cet_id);
841:
842: if l_cet_id is not null then
843: hr_utility.set_location('populate out params',10);
844: p_copy_entity_txn_id := l_cet_id;
845: else
846: hr_utility.set_location('cet row is not there',10);
847: end if;

Line 846: hr_utility.set_location('cet row is not there',10);

842: if l_cet_id is not null then
843: hr_utility.set_location('populate out params',10);
844: p_copy_entity_txn_id := l_cet_id;
845: else
846: hr_utility.set_location('cet row is not there',10);
847: end if;
848:
849: elsif p_mode ='UPDATE' and p_copy_entity_txn_id is null then
850: -- create the copy entity txn row

Line 852: hr_utility.set_location('creating cet row for update',10);

848:
849: elsif p_mode ='UPDATE' and p_copy_entity_txn_id is null then
850: -- create the copy entity txn row
851: -- copy the EGL data into staging area and set dml_operation to 'UPDATE'
852: hr_utility.set_location('creating cet row for update',10);
853: create_criteria_txn(p_mode => p_mode,
854: p_business_area => p_business_area,
855: p_business_group_id => p_business_group_id,
856: p_effective_date => p_effective_date,

Line 865: hr_utility.set_location('copying criteria row',10);

861: if l_cet_id is not null then
862:
863: if p_criteria_type = 'USER' then -- USER DEFINED CRITERIA TYPE
864: -- we have to pull eligy criteria into cer row
865: hr_utility.set_location('copying criteria row',10);
866: copy_egl_row(p_eligy_criteria_id => p_eligy_criteria_id,
867: p_copy_entity_txn_id => l_cet_id,
868: p_effective_date => p_effective_date,
869: p_copy_entity_result_id => l_cer_id,

Line 875: hr_utility.set_location('Value returned from check_criteria_in_busgrp:'||l_eligy_criteria_id_new ,10);

871: else -- WE HAVE TO PULL STANDARD CRITERIA AND ADD BUSINESS GRP ID
872:
873: check_criteria_in_busgrp(p_eligy_criteria_id,p_business_group_id,l_eligy_criteria_id_new);
874:
875: hr_utility.set_location('Value returned from check_criteria_in_busgrp:'||l_eligy_criteria_id_new ,10);
876:
877: if p_eligy_criteria_id <> l_eligy_criteria_id_new then
878: -- we have to pull eligy criteria into cer row
879: hr_utility.set_location('copying criteria row',10);

Line 879: hr_utility.set_location('copying criteria row',10);

875: hr_utility.set_location('Value returned from check_criteria_in_busgrp:'||l_eligy_criteria_id_new ,10);
876:
877: if p_eligy_criteria_id <> l_eligy_criteria_id_new then
878: -- we have to pull eligy criteria into cer row
879: hr_utility.set_location('copying criteria row',10);
880: copy_egl_row(p_eligy_criteria_id => l_eligy_criteria_id_new,
881: p_copy_entity_txn_id => l_cet_id,
882: p_effective_date => p_effective_date,
883: p_copy_entity_result_id => l_cer_id,

Line 886: hr_utility.set_location('copying criteria std row',10);

882: p_effective_date => p_effective_date,
883: p_copy_entity_result_id => l_cer_id,
884: p_copy_entity_result_ovn => l_cer_ovn);
885: else
886: hr_utility.set_location('copying criteria std row',10);
887: copy_criteria_std(p_eligy_criteria_id => p_eligy_criteria_id,
888: p_copy_entity_txn_id => l_cet_id,
889: p_effective_date => p_effective_date,
890: p_business_group_id => p_business_group_id,

Line 897: hr_utility.set_location('populate out params',10);

893: end if;
894: end if;
895:
896: if l_cer_id is not null then
897: hr_utility.set_location('populate out params',10);
898: p_copy_entity_txn_id := l_cet_id;
899: p_copy_entity_result_id := l_cer_id;
900: p_copy_entity_result_ovn := l_cer_ovn;
901: else

Line 902: hr_utility.set_location('cer row not there',10);

898: p_copy_entity_txn_id := l_cet_id;
899: p_copy_entity_result_id := l_cer_id;
900: p_copy_entity_result_ovn := l_cer_ovn;
901: else
902: hr_utility.set_location('cer row not there',10);
903: end if;
904:
905: end if;
906:

Line 909: hr_utility.set_location('invalid mode passed',10);

905: end if;
906:
907:
908: else
909: hr_utility.set_location('invalid mode passed',10);
910: end if;
911: end create_update_criteria;
912:
913:

Line 927: hr_utility.set_location('going for update operation ',10);

923: begin
924: FND_MSG_PUB.initialize;
925: for r_egl in c1 loop
926: if r_egl.dml_operation ='UPDATE' then
927: hr_utility.set_location('going for update operation ',10);
928: l_eligy_ovn := r_egl.information265;
929: l_eligy_criteria_id := r_egl.information1;
930:
931: ben_eligy_criteria_api.update_eligy_criteria(

Line 1001: hr_utility.set_location('going for create operation ',10);

997: p_time_access_calc_rule1 => r_egl.information270,
998: p_time_access_calc_rule2 => r_egl.information271
999: );
1000: elsif r_egl.dml_operation = 'CREATE' then
1001: hr_utility.set_location('going for create operation ',10);
1002:
1003: ben_eligy_criteria_api.create_eligy_criteria(
1004: p_validate => FALSE,
1005: p_eligy_criteria_id => l_eligy_criteria_id,

Line 1072: hr_utility.set_location('invalid mode of operation passed',10);

1068: p_time_access_calc_rule1 => r_egl.information270,
1069: p_time_access_calc_rule2 => r_egl.information271);
1070:
1071: else
1072: hr_utility.set_location('invalid mode of operation passed',10);
1073: end if;
1074: p_eligy_criteria_id := l_eligy_criteria_id;
1075: end loop;
1076: exception

Line 1078: hr_utility.set_location('issues in writing criteria ',10);

1074: p_eligy_criteria_id := l_eligy_criteria_id;
1075: end loop;
1076: exception
1077: when others then
1078: hr_utility.set_location('issues in writing criteria ',10);
1079: raise;
1080: end stage_to_criteria;
1081:
1082:

Line 1174: hr_utility.set_location('Rate Id'||to_char(rateId), 5);

1170: where upper(short_name) = upper(sname)
1171: and CRITERIA_RATE_DEFN_ID <> rateId
1172: and business_group_id = bgId;
1173: begin
1174: hr_utility.set_location('Rate Id'||to_char(rateId), 5);
1175: hr_utility.set_location('name'||sname, 10);
1176: open c11;
1177: fetch c11 into l_name;
1178: close c11;

Line 1175: hr_utility.set_location('name'||sname, 10);

1171: and CRITERIA_RATE_DEFN_ID <> rateId
1172: and business_group_id = bgId;
1173: begin
1174: hr_utility.set_location('Rate Id'||to_char(rateId), 5);
1175: hr_utility.set_location('name'||sname, 10);
1176: open c11;
1177: fetch c11 into l_name;
1178: close c11;
1179:

Line 1181: hr_utility.set_location('l_name'||l_name, 20);

1177: fetch c11 into l_name;
1178: close c11;
1179:
1180: if l_name is null then
1181: hr_utility.set_location('l_name'||l_name, 20);
1182: isValid := 'valid';
1183: else
1184: isValid := 'invalid';
1185: end if;

Line 1262: hr_utility.set_location('Entering',5);

1258: l_curr_rate_matrix_id ben_copy_entity_results.information1%type;
1259: --
1260: Begin
1261: --
1262: hr_utility.set_location('Entering',5);
1263: l_criteria_rate_defn_name := null;
1264: p_removed_crd_name := null;
1265: l_curr_rate_matrix_id := null;
1266:

Line 1297: hr_utility.set_location('Removing:'||p_removed_crd_name,5);

1293: End if;
1294: --
1295: End if;
1296:
1297: hr_utility.set_location('Removing:'||p_removed_crd_name,5);
1298: --
1299: -- 1) set the RMR rows for this removed criteria rate definition to deleted.
1300: -- Check if this criteria rate defintion was added as part of this transaction.
1301: -- If rates for rate matrix nodes exist for this criteria rate definition in the

Line 1334: hr_utility.set_location('Deleting:'||to_char(l_copy_entity_result_id),15);

1330: Close csr_exist_crd;
1331: --
1332: -- Delete RCR row.
1333: --
1334: hr_utility.set_location('Deleting:'||to_char(l_copy_entity_result_id),15);
1335: Delete from ben_copy_entity_results
1336: Where copy_entity_txn_id = p_copy_entity_txn_id
1337: and table_alias = 'RCR'
1338: and copy_entity_result_id = l_copy_entity_result_id;

Line 1398: hr_utility.set_location('Entering rebuild_rbr_rows',5);

1394: and information1 = p_parent;
1395: --
1396: Begin
1397: --
1398: hr_utility.set_location('Entering rebuild_rbr_rows',5);
1399: --
1400: /**
1401: l_curr_rate_matrix_id := null;
1402:

Line 1409: hr_utility.set_location('null rate matrix',5);

1405: Close csr_rm;
1406: --
1407: If l_curr_rate_matrix_id is null then
1408: l_curr_rate_matrix_id := -1;
1409: hr_utility.set_location('null rate matrix',5);
1410: End if;
1411: --
1412: --
1413: -- Validate if any criteria_rate_defn is dependent on another and if so, if the parent has

Line 1426: hr_utility.set_location('crd ='||to_char(l_criteria_rate_defn_id),5);

1422: l_parent:= null;
1423: --
1424: l_criteria_rate_defn_id := added_rcr_rec.information1;
1425: --
1426: hr_utility.set_location('crd ='||to_char(l_criteria_rate_defn_id),5);
1427: -- Find its parent
1428: --
1429: For parent_rec in csr_find_parent(l_curr_rate_matrix_id,l_criteria_rate_defn_id) loop
1430: l_parent:= parent_rec.parent_id;

Line 1433: hr_utility.set_location('parent id ='||to_char(l_parent),5);

1429: For parent_rec in csr_find_parent(l_curr_rate_matrix_id,l_criteria_rate_defn_id) loop
1430: l_parent:= parent_rec.parent_id;
1431: l_criteria_rate_defn_name := parent_rec.parent_name;
1432: -- Is parent added
1433: hr_utility.set_location('parent id ='||to_char(l_parent),5);
1434: hr_utility.set_location('parent name ='||l_criteria_rate_defn_name,5);
1435: Open csr_is_parent_added(l_parent);
1436: Fetch csr_is_parent_added into l_dummy;
1437: If csr_is_parent_added%notfound then

Line 1434: hr_utility.set_location('parent name ='||l_criteria_rate_defn_name,5);

1430: l_parent:= parent_rec.parent_id;
1431: l_criteria_rate_defn_name := parent_rec.parent_name;
1432: -- Is parent added
1433: hr_utility.set_location('parent id ='||to_char(l_parent),5);
1434: hr_utility.set_location('parent name ='||l_criteria_rate_defn_name,5);
1435: Open csr_is_parent_added(l_parent);
1436: Fetch csr_is_parent_added into l_dummy;
1437: If csr_is_parent_added%notfound then
1438: hr_utility.set_location('parent not found',5);

Line 1438: hr_utility.set_location('parent not found',5);

1434: hr_utility.set_location('parent name ='||l_criteria_rate_defn_name,5);
1435: Open csr_is_parent_added(l_parent);
1436: Fetch csr_is_parent_added into l_dummy;
1437: If csr_is_parent_added%notfound then
1438: hr_utility.set_location('parent not found',5);
1439: hr_utility.set_message(8302,'PQH_RBC_REENTER_PLAN_INFO');
1440: hr_multi_message.add;
1441: End if;
1442: Close csr_is_parent_added;

Line 1439: hr_utility.set_message(8302,'PQH_RBC_REENTER_PLAN_INFO');

1435: Open csr_is_parent_added(l_parent);
1436: Fetch csr_is_parent_added into l_dummy;
1437: If csr_is_parent_added%notfound then
1438: hr_utility.set_location('parent not found',5);
1439: hr_utility.set_message(8302,'PQH_RBC_REENTER_PLAN_INFO');
1440: hr_multi_message.add;
1441: End if;
1442: Close csr_is_parent_added;
1443:

Line 1677: hr_utility.set_location('going for deleting entire rate matrix txn',100);

1673: end if;
1674:
1675:
1676:
1677: hr_utility.set_location('going for deleting entire rate matrix txn',100);
1678: delete from ben_copy_entity_results where copy_entity_txn_id = p_copy_entity_txn_id;
1679: delete from pqh_copy_entity_txns where copy_entity_txn_id = p_copy_entity_txn_id;
1680: hr_utility.set_location('deleting entire rate matrix txn done',110);
1681: exception

Line 1680: hr_utility.set_location('deleting entire rate matrix txn done',110);

1676:
1677: hr_utility.set_location('going for deleting entire rate matrix txn',100);
1678: delete from ben_copy_entity_results where copy_entity_txn_id = p_copy_entity_txn_id;
1679: delete from pqh_copy_entity_txns where copy_entity_txn_id = p_copy_entity_txn_id;
1680: hr_utility.set_location('deleting entire rate matrix txn done',110);
1681: exception
1682: when others then
1683: hr_utility.set_location('issues in deleting matrix txn',100);
1684: raise;

Line 1683: hr_utility.set_location('issues in deleting matrix txn',100);

1679: delete from pqh_copy_entity_txns where copy_entity_txn_id = p_copy_entity_txn_id;
1680: hr_utility.set_location('deleting entire rate matrix txn done',110);
1681: exception
1682: when others then
1683: hr_utility.set_location('issues in deleting matrix txn',100);
1684: raise;
1685: end cancel_rate_matrix_txn;
1686:
1687: procedure rate_columns_in_sync(critId in number,