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_MULTI_MESSAGE

Line 93: hr_multi_message.add;

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:
97: open c2(l_short_code,l_level_number);

Line 103: hr_multi_message.add;

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;
107: close c1;

Line 168: hr_multi_message.add;

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;
172: END plan_name_exists;

Line 192: hr_multi_message.add;

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;
196: END plan_short_code_exists;

Line 214: hr_multi_message.add;

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;
218: END plan_short_name_exists;

Line 240: hr_multi_message.add;

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
244: l_status := 'YES';

Line 519: hr_multi_message.enable_message_list;

515: l_status varchar2(10);
516: begin
517: l_status := 'YES';
518:
519: hr_multi_message.enable_message_list;
520:
521: --/*
522: --dbms_output.put_line('matrix_has_rates:');
523: if( matrix_has_rates(p_copy_entity_txn_id) = 'NO') then

Line 526: hr_multi_message.add;

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: --*/
530:

Line 537: hr_multi_message.add;

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: --*/
541:

Line 548: hr_multi_message.add;

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
552: --dbms_output.put_line('matrix has duplicate criteria added');

Line 555: hr_multi_message.add;

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;
559:

Line 568: hr_multi_message.add;

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
572: --dbms_output.put_line('matrix has duplicate rate type');

Line 575: hr_multi_message.add;

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;
579: --*/

Line 594: hr_multi_message.add;

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
598: --dbms_output.put_line('matrix_has_criteria_values and checking duplicates:');

Line 603: hr_multi_message.add;

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;
607: --*/

Line 621: hr_multi_message.enable_message_list;

617: l_status varchar2(10);
618: begin
619: l_status := 'YES';
620: FND_MSG_PUB.initialize;
621: hr_multi_message.enable_message_list;
622:
623:
624: --/*
625: --dbms_output.put_line('matrix_has_criteria:');

Line 630: hr_multi_message.add;

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:
634: --*/

Line 642: hr_multi_message.add;

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: --*/
646:

Line 660: hr_multi_message.add;

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:
664: --/*

Line 669: hr_multi_message.add;

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: --*/
673:

Line 744: hr_multi_message.enable_message_list;

740: l_status varchar2(10);
741: begin
742: l_status := 'YES';
743: FND_MSG_PUB.initialize;
744: hr_multi_message.enable_message_list;
745: --/*
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');

Line 751: hr_multi_message.add;

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: --*/
755:

Line 762: -- hr_multi_message.add;

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
766: --dbms_output.put_line('matrix has duplicate criteria added');

Line 769: hr_multi_message.add;

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;
773:

Line 782: -- hr_multi_message.add;

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
786: --dbms_output.put_line('matrix has duplicate rate type');

Line 789: hr_multi_message.add;

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;
793: --*/

Line 802: -- hr_multi_message.add;

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
806: -- dbms_output.put_line('matrix_has_criteria_values and checking duplicates:');

Line 811: -- hr_multi_message.add;

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;
815: --*/