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

Line 91: hr_utility.set_message(8302,'PQH_RBC_CRIT_DOESNT_EXIST');

87: open c3(l_short_code);
88: fetch c3 into l_name;
89: if c3%notfound then
90: l_status := 'NO';
91: hr_utility.set_message(8302,'PQH_RBC_CRIT_DOESNT_EXIST');
92: hr_utility.set_message_token('SHORT_CODE',l_short_code);
93: hr_multi_message.add;
94: end if;
95: close c3;

Line 92: hr_utility.set_message_token('SHORT_CODE',l_short_code);

88: fetch c3 into l_name;
89: if c3%notfound then
90: l_status := 'NO';
91: hr_utility.set_message(8302,'PQH_RBC_CRIT_DOESNT_EXIST');
92: hr_utility.set_message_token('SHORT_CODE',l_short_code);
93: hr_multi_message.add;
94: end if;
95: close c3;
96:

Line 101: hr_utility.set_message(8302,'PQH_RBC_NODES_ADD_ONE');

97: open c2(l_short_code,l_level_number);
98: fetch c2 into l_copy_entity_result_id;
99: if c2%notfound then
100: l_status := 'NO';
101: hr_utility.set_message(8302,'PQH_RBC_NODES_ADD_ONE');
102: hr_utility.set_message_token('CRIT_NAME',l_name);
103: hr_multi_message.add;
104: end if;
105: close c2;

Line 102: hr_utility.set_message_token('CRIT_NAME',l_name);

98: fetch c2 into l_copy_entity_result_id;
99: if c2%notfound then
100: l_status := 'NO';
101: hr_utility.set_message(8302,'PQH_RBC_NODES_ADD_ONE');
102: hr_utility.set_message_token('CRIT_NAME',l_name);
103: hr_multi_message.add;
104: end if;
105: close c2;
106: end loop;

Line 166: hr_utility.set_message(8302,'PQH_RBC_MATRIX_NAME_EXISTS');

162: if c1%notfound then
163: RETURN 'NO';
164: else
165: --dbms_output.put_line('name already exists'||l_name);
166: hr_utility.set_message(8302,'PQH_RBC_MATRIX_NAME_EXISTS');
167: hr_utility.set_message_token('MATRIX_NAME',l_name);
168: hr_multi_message.add;
169: RETURN 'YES';
170: end if;

Line 167: hr_utility.set_message_token('MATRIX_NAME',l_name);

163: RETURN 'NO';
164: else
165: --dbms_output.put_line('name already exists'||l_name);
166: hr_utility.set_message(8302,'PQH_RBC_MATRIX_NAME_EXISTS');
167: hr_utility.set_message_token('MATRIX_NAME',l_name);
168: hr_multi_message.add;
169: RETURN 'YES';
170: end if;
171: close c1;

Line 190: hr_utility.set_message(8302,'PQH_RBC_PLN_SHORT_CODE_EXISTS');

186: if c1%notfound then
187: RETURN 'NO';
188: else
189: --dbms_output.put_line('short code already exists'||p_short_code);
190: hr_utility.set_message(8302,'PQH_RBC_PLN_SHORT_CODE_EXISTS');
191: hr_utility.set_message_token('SHORT_CODE',l_short_code);
192: hr_multi_message.add;
193: RETURN 'YES';
194: end if;

Line 191: hr_utility.set_message_token('SHORT_CODE',l_short_code);

187: RETURN 'NO';
188: else
189: --dbms_output.put_line('short code already exists'||p_short_code);
190: hr_utility.set_message(8302,'PQH_RBC_PLN_SHORT_CODE_EXISTS');
191: hr_utility.set_message_token('SHORT_CODE',l_short_code);
192: hr_multi_message.add;
193: RETURN 'YES';
194: end if;
195: close c1;

Line 212: hr_utility.set_message(8302,'PQH_RBC_PLN_SHORT_NAME_EXISTS');

208: if c1%notfound then
209: RETURN 'NO';
210: else
211: --dbms_output.put_line('short name already exists'||p_short_name);
212: hr_utility.set_message(8302,'PQH_RBC_PLN_SHORT_NAME_EXISTS');
213: hr_utility.set_message_token('SHORT_NAME',l_short_name);
214: hr_multi_message.add;
215: RETURN 'YES';
216: end if;

Line 213: hr_utility.set_message_token('SHORT_NAME',l_short_name);

209: RETURN 'NO';
210: else
211: --dbms_output.put_line('short name already exists'||p_short_name);
212: hr_utility.set_message(8302,'PQH_RBC_PLN_SHORT_NAME_EXISTS');
213: hr_utility.set_message_token('SHORT_NAME',l_short_name);
214: hr_multi_message.add;
215: RETURN 'YES';
216: end if;
217: close c1;

Line 239: hr_utility.set_message(8302,'PQH_RBC_INVALID_ENTITY_TXN');

235: open c1;
236: fetch c1 into l_pl_id,l_plan_name, l_short_code, l_short_name, l_business_group_id;
237:
238: if(c1%notfound) then
239: hr_utility.set_message(8302,'PQH_RBC_INVALID_ENTITY_TXN');
240: hr_multi_message.add;
241: l_status := 'YES';
242: else
243: if(plan_name_exists(l_pl_id,l_plan_name,l_business_group_id) = 'YES') then

Line 525: hr_utility.set_message(8302,'PQH_RBC_RATES_ADD_ONE');

521: --/*
522: --dbms_output.put_line('matrix_has_rates:');
523: if( matrix_has_rates(p_copy_entity_txn_id) = 'NO') then
524: -- add exception(matrix has no rates added)
525: hr_utility.set_message(8302,'PQH_RBC_RATES_ADD_ONE');
526: hr_multi_message.add;
527: l_status := 'NO';
528: end if;
529: --*/

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

532: --dbms_output.put_line('check_plan_duplicate:');
533: if( check_plan_duplicate(p_copy_entity_txn_id) = 'YES') then
534: --dbms_output.put_line('plan already exist');
535: -- add exception(matrix plan is duplicated)
536: hr_utility.set_message(8302,'PQH_RBC_REENTER_PLAN_INFO');
537: hr_multi_message.add;
538: l_status := 'NO';
539: end if;
540: --*/

Line 547: hr_utility.set_message(8302,'PQH_RBC_CRIT_ADD_ONE');

543: --dbms_output.put_line('matrix_has_criteria:');
544: if( matrix_has_criteria(p_copy_entity_txn_id) = 'NO') then
545: --dbms_output.put_line('matrix has no criteria added and criteria dup not being checked');
546: -- add exception(matrix has no criteria added)
547: hr_utility.set_message(8302,'PQH_RBC_CRIT_ADD_ONE');
548: hr_multi_message.add;
549: l_status := 'NO';
550: else
551: if( matrix_has_criteria_dup(p_copy_entity_txn_id) = 'YES') then

Line 554: hr_utility.set_message(8302,'PQH_RBC_MATRIX_CRITERIA_DUP');

550: else
551: if( matrix_has_criteria_dup(p_copy_entity_txn_id) = 'YES') then
552: --dbms_output.put_line('matrix has duplicate criteria added');
553: -- add exception(matrix has duplicate criteria added)
554: hr_utility.set_message(8302,'PQH_RBC_MATRIX_CRITERIA_DUP');
555: hr_multi_message.add;
556: l_status := 'NO';
557: end if;
558: end if;

Line 567: hr_utility.set_message(8302,'PQH_RBC_RATE_TYPE_ADD_ONE');

563: --dbms_output.put_line('matrix_has_rate_type:');
564: if( matrix_has_rate_type(p_copy_entity_txn_id) = 'NO') then
565: --dbms_output.put_line('matrix has no rate type added and not checking dup for it');
566: -- add exception(matrix has no rate type added)
567: hr_utility.set_message(8302,'PQH_RBC_RATE_TYPE_ADD_ONE');
568: hr_multi_message.add;
569: l_status := 'NO';
570: else
571: if( matrix_has_ratetype_dup(p_copy_entity_txn_id) = 'YES') then

Line 574: hr_utility.set_message(8302,'PQH_RBC_MATRIX_RATE_TYPE_DUP');

570: else
571: if( matrix_has_ratetype_dup(p_copy_entity_txn_id) = 'YES') then
572: --dbms_output.put_line('matrix has duplicate rate type');
573: -- add exception(matrix has duplicate rate type)
574: hr_utility.set_message(8302,'PQH_RBC_MATRIX_RATE_TYPE_DUP');
575: hr_multi_message.add;
576: l_status := 'NO';
577: end if;
578: end if;

Line 593: hr_utility.set_message(8302,'PQH_RBC_CRIT_VAL_ADD_ONE');

589: --dbms_output.put_line('matrix_has_criteria_values:');
590: if( matrix_has_criteria_values(p_copy_entity_txn_id) = 'NO') then
591: --dbms_output.put_line('matrix has no criteria values and not checking dup for it');
592: -- add exception(matrix has no criteria values)
593: hr_utility.set_message(8302,'PQH_RBC_CRIT_VAL_ADD_ONE');
594: hr_multi_message.add;
595: l_status := 'NO';
596: else
597: -- matrix has criteria values so proceed to check duplicates

Line 602: hr_utility.set_message(8302,'PQH_RBC_CRIT_VAL_DUP_IN_PAGE');

598: --dbms_output.put_line('matrix_has_criteria_values and checking duplicates:');
599: if( check_critval_dup_in_txn(p_copy_entity_txn_id) = 'YES') then
600: --dbms_output.put_line('matrix has duplicate criteria values');
601: -- add exception(matrix has duplicate criteria values)
602: hr_utility.set_message(8302,'PQH_RBC_CRIT_VAL_DUP_IN_PAGE');
603: hr_multi_message.add;
604: l_status := 'NO';
605: end if;
606: end if;

Line 629: hr_utility.set_message(8302,'PQH_RBC_CRIT_ADD_ONE');

625: --dbms_output.put_line('matrix_has_criteria:');
626: if( matrix_has_criteria(p_copy_entity_txn_id) = 'NO') then
627: --dbms_output.put_line('matrix has no criteria added and criteria dup not being checked');
628: -- add exception(matrix has no criteria added)
629: hr_utility.set_message(8302,'PQH_RBC_CRIT_ADD_ONE');
630: hr_multi_message.add;
631: l_status := 'NO';
632: end if;
633:

Line 641: hr_utility.set_message(8302,'PQH_RBC_RATE_TYPE_ADD_ONE');

637: --dbms_output.put_line('matrix_has_rate_type:');
638: if( matrix_has_rate_type(p_copy_entity_txn_id) = 'NO') then
639: --dbms_output.put_line('matrix has no rate type added and not checking dup for it');
640: -- add exception(matrix has no rate type added)
641: hr_utility.set_message(8302,'PQH_RBC_RATE_TYPE_ADD_ONE');
642: hr_multi_message.add;
643: l_status := 'NO';
644: end if;
645: --*/

Line 659: hr_utility.set_message(8302,'PQH_RBC_CRIT_VAL_ADD_ONE');

655: --dbms_output.put_line('matrix_has_criteria_values:');
656: if( matrix_has_criteria_values(p_copy_entity_txn_id) = 'NO') then
657: --dbms_output.put_line('matrix has no criteria values and not checking dup for it');
658: -- add exception(matrix has no criteria values)
659: hr_utility.set_message(8302,'PQH_RBC_CRIT_VAL_ADD_ONE');
660: hr_multi_message.add;
661: l_status := 'NO';
662: end if;
663:

Line 668: hr_utility.set_message(8302,'PQH_RBC_RATES_ADD_ONE');

664: --/*
665: --dbms_output.put_line('matrix_has_rates:');
666: if( matrix_has_rates(p_copy_entity_txn_id) = 'NO') then
667: -- add exception(matrix has no rates added)
668: hr_utility.set_message(8302,'PQH_RBC_RATES_ADD_ONE');
669: hr_multi_message.add;
670: l_status := 'NO';
671: end if;
672: --*/

Line 726: hr_utility.set_message(8302,'PQH_RBC_RATE_DEFN_RATES_WARN');

722: end loop;
723: close c1;
724:
725: if l_status = 'NO' then
726: hr_utility.set_message(8302,'PQH_RBC_RATE_DEFN_RATES_WARN');
727: hr_utility.set_message_token('NAME',l_crit_rate_defn_names);
728: p_warning_message := hr_utility.get_message;
729: else
730: p_warning_message := '';

Line 727: hr_utility.set_message_token('NAME',l_crit_rate_defn_names);

723: close c1;
724:
725: if l_status = 'NO' then
726: hr_utility.set_message(8302,'PQH_RBC_RATE_DEFN_RATES_WARN');
727: hr_utility.set_message_token('NAME',l_crit_rate_defn_names);
728: p_warning_message := hr_utility.get_message;
729: else
730: p_warning_message := '';
731: end if;

Line 728: p_warning_message := hr_utility.get_message;

724:
725: if l_status = 'NO' then
726: hr_utility.set_message(8302,'PQH_RBC_RATE_DEFN_RATES_WARN');
727: hr_utility.set_message_token('NAME',l_crit_rate_defn_names);
728: p_warning_message := hr_utility.get_message;
729: else
730: p_warning_message := '';
731: end if;
732:

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

746: --dbms_output.put_line('check_plan_duplicate:');
747: if( check_plan_duplicate(p_copy_entity_txn_id) = 'YES') then
748: --dbms_output.put_line('plan already exist');
749: -- add exception(matrix plan is duplicated)
750: hr_utility.set_message(8302,'PQH_RBC_REENTER_PLAN_INFO');
751: hr_multi_message.add;
752: l_status := 'NO';
753: end if;
754: --*/

Line 761: -- hr_utility.set_message(8302,'PQH_RBC_CRIT_ADD_ONE');

757: -- --dbms_output.put_line('matrix_has_criteria:');
758: -- if( matrix_has_criteria(p_copy_entity_txn_id) = 'NO') then
759: -- --dbms_output.put_line('matrix has no criteria added and criteria dup not being checked');
760: -- -- add exception(matrix has no criteria added)
761: -- hr_utility.set_message(8302,'PQH_RBC_CRIT_ADD_ONE');
762: -- hr_multi_message.add;
763: -- l_status := 'NO';
764: -- else
765: if( matrix_has_criteria_dup(p_copy_entity_txn_id) = 'YES') then

Line 768: hr_utility.set_message(8302,'PQH_RBC_MATRIX_CRITERIA_DUP');

764: -- else
765: if( matrix_has_criteria_dup(p_copy_entity_txn_id) = 'YES') then
766: --dbms_output.put_line('matrix has duplicate criteria added');
767: -- add exception(matrix has duplicate criteria added)
768: hr_utility.set_message(8302,'PQH_RBC_MATRIX_CRITERIA_DUP');
769: hr_multi_message.add;
770: l_status := 'NO';
771: end if;
772: -- end if;

Line 781: -- hr_utility.set_message(8302,'PQH_RBC_RATE_TYPE_ADD_ONE');

777: -- --dbms_output.put_line('matrix_has_rate_type:');
778: -- if( matrix_has_rate_type(p_copy_entity_txn_id) = 'NO') then
779: -- --dbms_output.put_line('matrix has no rate type added and not checking dup for it');
780: -- -- add exception(matrix has no rate type added)
781: -- hr_utility.set_message(8302,'PQH_RBC_RATE_TYPE_ADD_ONE');
782: -- hr_multi_message.add;
783: -- l_status := 'NO';
784: -- else
785: if( matrix_has_ratetype_dup(p_copy_entity_txn_id) = 'YES') then

Line 788: hr_utility.set_message(8302,'PQH_RBC_MATRIX_RATE_TYPE_DUP');

784: -- else
785: if( matrix_has_ratetype_dup(p_copy_entity_txn_id) = 'YES') then
786: --dbms_output.put_line('matrix has duplicate rate type');
787: -- add exception(matrix has duplicate rate type)
788: hr_utility.set_message(8302,'PQH_RBC_MATRIX_RATE_TYPE_DUP');
789: hr_multi_message.add;
790: l_status := 'NO';
791: end if;
792: -- end if;

Line 801: -- hr_utility.set_message(8302,'PQH_RBC_CRIT_VAL_ADD_ONE');

797: -- --dbms_output.put_line('matrix_has_criteria_values:');
798: -- if( matrix_has_criteria_values(p_copy_entity_txn_id) = 'NO') then
799: -- --dbms_output.put_line('matrix has no criteria values and not checking dup for it');
800: -- -- add exception(matrix has no criteria values)
801: -- hr_utility.set_message(8302,'PQH_RBC_CRIT_VAL_ADD_ONE');
802: -- hr_multi_message.add;
803: -- l_status := 'NO';
804: -- else
805: -- We may not need to check duplicate criteria values because we do in pages

Line 810: -- hr_utility.set_message(8302,'PQH_RBC_CRIT_VAL_DUP_IN_PAGE');

806: -- dbms_output.put_line('matrix_has_criteria_values and checking duplicates:');
807: -- if( check_critval_dup_in_txn(p_copy_entity_txn_id) = 'YES') then
808: -- dbms_output.put_line('matrix has duplicate criteria values');
809: -- add exception(matrix has duplicate criteria values)
810: -- hr_utility.set_message(8302,'PQH_RBC_CRIT_VAL_DUP_IN_PAGE');
811: -- hr_multi_message.add;
812: -- l_status := 'NO';
813: -- end if;
814: -- end if;