DBA Data[Home] [Help]

APPS.PQH_STS_BUS dependencies on HR_MULTI_MESSAGE

Line 71: hr_multi_message.add

67: --
68: -- The primary key is invalid therefore we must error
69: --
70: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
71: hr_multi_message.add
72: (p_associated_column1
73: => nvl(p_associated_column1,'STATUTORY_SITUATION_ID')
74: );
75: --

Line 349: hr_multi_message.add(p_associated_column1=> 'MAX_NO_OF_RENEWALS',

345:
346: fnd_message.set_name('PQH','PQH_FR_VALUE_NOT_ALLOWED');
347: fnd_message.set_token('ATTRIBUTE','MAX_NO_OF_RENEWALS');
348:
349: hr_multi_message.add(p_associated_column1=> 'MAX_NO_OF_RENEWALS',
350: p_associated_column2=> 'MAX_DURATION_PER_RENEWAL');
351: end if;
352: end if;
353:

Line 376: hr_multi_message.add(p_associated_column1=> 'FREQUENCY_NAME');

372: if (p_rec.FREQUENCY is null ) then
373: --
374: fnd_message.set_name('PQH','PQH_FR_FREQUENCY_MUST_SELECT');
375:
376: hr_multi_message.add(p_associated_column1=> 'FREQUENCY_NAME');
377: end if;
378: --
379: end if;
380:

Line 411: hr_multi_message.add(p_associated_column1=> 'FREQUENCY_NAME');

407: --
408: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
409: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','FREQUENCY'));
410:
411: hr_multi_message.add(p_associated_column1=> 'FREQUENCY_NAME');
412: end if;
413: --
414: Close csr_frequency;
415: --

Line 440: hr_multi_message.add(p_associated_column1=> 'REMUNERATION_PAID');

436: --
437: fnd_message.set_name('PQH','PQH_FR_VALUE_NOT_ALLOWED');
438: fnd_message.set_token('ATTRIBUTE','PAY_SHARE');
439:
440: hr_multi_message.add(p_associated_column1=> 'REMUNERATION_PAID');
441: end if;
442: --
443: end if;
444:

Line 463: hr_multi_message.add(p_associated_column1=> 'DATE_TO');

459: if (trunc(p_date_from) > trunc(p_date_to)) then
460: --
461: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE_DATE_FROM');
462:
463: hr_multi_message.add(p_associated_column1=> 'DATE_TO');
464:
465: --
466: end if;
467: --

Line 502: hr_multi_message.add

498: --
499: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
500: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','REASON'));
501:
502: hr_multi_message.add
503: (p_associated_column1=> 'REASON');
504: end if;
505: --
506: Close csr_reason;

Line 540: hr_multi_message.add

536: --
537: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
538: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','LOCATION'));
539:
540: hr_multi_message.add
541: (p_associated_column1
542: => 'LOCATION');
543: end if;
544: --

Line 581: hr_multi_message.add

577: --
578: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
579: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','SOURCE'));
580:
581: hr_multi_message.add
582: (p_associated_column1
583: => 'SOURCE');
584: end if;
585: --

Line 621: hr_multi_message.add

617: If csr_sub_type%NOTFOUND then
618: --
619: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
620: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','SUB_TYPE'));
621: hr_multi_message.add
622: (p_associated_column1
623: => 'SUB_TYPE_NAME');
624: --
625: End If;

Line 644: hr_multi_message.add

640: if (p_pay_share < 0 or p_pay_share >100) then
641: --
642: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
643: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','PAY_SHARE'));
644: hr_multi_message.add
645: (p_associated_column1
646: => 'PAY_SHARE');
647: --
648: elsif (p_pay_share >0 and p_remuneration_paid = 'N') then

Line 652: hr_multi_message.add

648: elsif (p_pay_share >0 and p_remuneration_paid = 'N') then
649: --
650: fnd_message.set_name('PQH','PQH_FR_STAT_CHECK_REMUNERATION');
651: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','PAY_SHARE'));
652: hr_multi_message.add
653: (p_associated_column1=> 'REMUNERATION_PAID');
654:
655: hr_multi_message.end_validation_set;
656: --

Line 655: hr_multi_message.end_validation_set;

651: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','PAY_SHARE'));
652: hr_multi_message.add
653: (p_associated_column1=> 'REMUNERATION_PAID');
654:
655: hr_multi_message.end_validation_set;
656: --
657: end if;
658:
659:

Line 675: hr_multi_message.add

671: if (p_pay_periods < 0) then
672: --
673: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
674: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','PAY_PERIODS'));
675: hr_multi_message.add
676: (p_associated_column1
677: => 'PAY_PERIODS');
678: --
679: elsif (p_pay_periods >0 and p_remuneration_paid = 'N') then

Line 683: hr_multi_message.add

679: elsif (p_pay_periods >0 and p_remuneration_paid = 'N') then
680: --
681: fnd_message.set_name('PQH','PQH_FR_STAT_CHECK_REMUNERATION');
682: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','PAY_PERIODS'));
683: hr_multi_message.add
684: (p_associated_column1=> 'REMUNERATION_PAID');
685: --
686: end if;
687: --

Line 704: hr_multi_message.add

700: if (p_first_period_max_duration < 0) then
701: --
702: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
703: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','FIRST_PERIOD_MAX_DURATION'));
704: hr_multi_message.add
705: (p_associated_column1
706: => 'FIRST_PERIOD_MAX_DURATION');
707: --
708: end if;

Line 725: hr_multi_message.add

721: if (p_min_duration_per_request < 0) then
722: --
723: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
724: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MIN_DURATION_PER_REQUEST'));
725: hr_multi_message.add
726: (p_associated_column1
727: => 'MIN_DURATION_PER_REQUEST');
728: --
729: end if;

Line 746: hr_multi_message.add

742: if (p_max_duration_per_request < 0) then
743: --
744: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
745: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_DURATION_PER_REQUEST'));
746: hr_multi_message.add
747: (p_associated_column1
748: => 'MAX_DURATION_PER_REQUEST');
749: --
750: end if;

Line 767: hr_multi_message.add

763: if (p_max_duration_whole_career < 0) then
764: --
765: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
766: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_DURATION_WHOLE_CAREER'));
767: hr_multi_message.add
768: (p_associated_column1
769: => 'MAX_DURATION_WHOLE_CAREER');
770: --
771: end if;

Line 789: hr_multi_message.add

785: if (p_max_no_of_renewals < 0) then
786: --
787: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
788: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_NO_OF_RENEWALS'));
789: hr_multi_message.add
790: (p_associated_column1
791: => 'MAX_NO_OF_RENEWALS');
792: --
793: elsif (p_max_no_of_renewals > 0 and p_renewable_allowed = 'N' ) then

Line 798: hr_multi_message.add

794: --
795: --
796: fnd_message.set_name('PQH','PQH_FR_STAT_RENEWABLE_ALLOWED');
797: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_NO_OF_RENEWALS'));
798: hr_multi_message.add
799: (p_associated_column1
800: => 'RENEWABLE_ALLOWED');
801:
802: hr_multi_message.end_validation_set;

Line 802: hr_multi_message.end_validation_set;

798: hr_multi_message.add
799: (p_associated_column1
800: => 'RENEWABLE_ALLOWED');
801:
802: hr_multi_message.end_validation_set;
803: --
804: end if;
805:
806: --

Line 824: hr_multi_message.add

820: if (p_max_duration_per_renewal < 0) then
821: --
822: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
823: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_DURATION_PER_RENEWAL'));
824: hr_multi_message.add
825: (p_associated_column1
826: => 'MAX_DURATION_PER_RENEWAL');
827: --
828: elsif (p_max_duration_per_renewal > 0 and p_renewable_allowed = 'N' ) then

Line 833: hr_multi_message.add

829: --
830: --
831: fnd_message.set_name('PQH','PQH_FR_STAT_RENEWABLE_ALLOWED');
832: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_DURATION_PER_RENEWAL'));
833: hr_multi_message.add
834: (p_associated_column1
835: => 'RENEWABLE_ALLOWED');
836: --
837: end if;

Line 855: hr_multi_message.add

851: and p_max_tot_continuous_duration < 0 ) then
852: --
853: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
854: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_TOT_CONTINUOUS_DURATION'));
855: hr_multi_message.add
856: (p_associated_column1
857: => ' MAX_TOT_CONTINUOUS_DURATION');
858: --
859: end if;

Line 898: hr_multi_message.add

894:
895: if csr_chk_default%FOUND then
896: --
897: fnd_message.set_name('PQH','PQH_FR_STAT_DUP_DEFAULT');
898: hr_multi_message.add
899: (p_associated_column1 => 'DEFAULT_FLAG');
900:
901: end if;
902: --

Line 937: hr_multi_message.add

933: if csr_type_of_ps%NOTFOUND then
934: --
935: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
936: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','TYPE_OF_PS'));
937: hr_multi_message.add
938: (p_associated_column1 => 'TYPE_OF_PS');
939:
940: end if;
941: --

Line 976: hr_multi_message.add

972: if csr_situation_type%NOTFOUND then
973: --
974: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
975: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','SITUATION_TYPE'));
976: hr_multi_message.add
977: (p_associated_column1 => 'SITUATION_TYPE');
978:
979: end if;
980: --

Line 1014: hr_multi_message.add

1010:
1011: if csr_situation_name%found then
1012: --
1013: fnd_message.set_name('PQH','PQH_FR_UNIQUE_STAT_SIT_NAME');
1014: hr_multi_message.add
1015: (p_associated_column1
1016: => 'SITUATION_NAME');
1017:
1018:

Line 1062: hr_multi_message.add

1058:
1059: if csr_unique_situation%FOUND then
1060: --
1061: fnd_message.set_name('PQH','PQH_FR_UNIQUE_COMBINATION');
1062: hr_multi_message.add
1063: (p_associated_column1
1064: => 'SITUATION_NAME');
1065:
1066: --

Line 1089: hr_multi_message.add

1085: nvl(p_max_duration_per_request,0) then
1086: --
1087: --
1088: fnd_message.set_name('PQH','PQH_FR_STAT_MIN_MAX_PER_RQST');
1089: hr_multi_message.add
1090: (p_associated_column1=> 'MIN_DURATION_PER_REQUEST');
1091: --
1092: end if;
1093: --

Line 1111: hr_multi_message.add

1107: --
1108: if nvl(p_max_duration_whole_career,0) < nvl(p_first_period_max_duration,0) then
1109: --
1110: fnd_message.set_name('PQH','PQH_FR_STAT_DURATION_WHOLE');
1111: hr_multi_message.add
1112: (p_associated_column1=> 'FIRST_PERIOD_MAX_DURATION');
1113: --
1114: end if;
1115: --

Line 1146: hr_multi_message.end_validation_set;

1142: ,p_associated_column1 => pqh_sts_shd.g_tab_nam
1143: || '.BUSINESS_GROUP_ID');
1144: --
1145: --
1146: hr_multi_message.end_validation_set;
1147:
1148: chk_unique_sitaution_name(p_rec);
1149:
1150: chk_type_of_ps(p_rec.type_of_ps);

Line 1166: hr_multi_message.end_validation_set;

1162: chk_location(p_rec.location);
1163:
1164: chk_frequency (p_rec.frequency);
1165:
1166: hr_multi_message.end_validation_set;
1167:
1168: chk_unique_sitaution(p_rec);
1169:
1170: hr_multi_message.end_validation_set;

Line 1170: hr_multi_message.end_validation_set;

1166: hr_multi_message.end_validation_set;
1167:
1168: chk_unique_sitaution(p_rec);
1169:
1170: hr_multi_message.end_validation_set;
1171:
1172: chk_duration_limits(p_rec);
1173:
1174:

Line 1175: hr_multi_message.end_validation_set;

1171:
1172: chk_duration_limits(p_rec);
1173:
1174:
1175: hr_multi_message.end_validation_set;
1176:
1177: -- Number filed checks
1178: chk_min_max_duration_rqst(p_rec.MIN_DURATION_PER_REQUEST,p_rec.MAX_DURATION_PER_REQUEST);
1179:

Line 1182: hr_multi_message.end_validation_set;

1178: chk_min_max_duration_rqst(p_rec.MIN_DURATION_PER_REQUEST,p_rec.MAX_DURATION_PER_REQUEST);
1179:
1180: chk_max_duration_in_whole(p_rec.FIRST_PERIOD_MAX_DURATION,p_rec.MAX_DURATION_WHOLE_CAREER);
1181:
1182: hr_multi_message.end_validation_set;
1183:
1184: chk_date(p_rec.date_from , p_rec.date_to);
1185:
1186: chk_pay_share(p_rec.pay_share,p_rec.remuneration_paid);

Line 1205: hr_multi_message.end_validation_set;

1201:
1202: chk_max_tot_continuous_dur(p_rec.max_tot_continuous_duration,p_rec.frequency);
1203:
1204: --
1205: hr_multi_message.end_validation_set;
1206: --
1207: -- Validate Dependent Attributes
1208: --
1209: --

Line 1241: hr_multi_message.end_validation_set;

1237: hr_api.validate_bus_grp_id
1238: (p_business_group_id => p_rec.business_group_id
1239: ,p_associated_column1 => pqh_sts_shd.g_tab_nam
1240: || '.BUSINESS_GROUP_ID');
1241: hr_multi_message.end_validation_set;
1242:
1243: chk_unique_sitaution_name(p_rec);
1244: chk_default(p_rec);
1245: chk_date(p_rec.date_from , p_rec.date_to);

Line 1251: hr_multi_message.end_validation_set;

1247: -- Number filed checks
1248:
1249: chk_duration_limits(p_rec);
1250:
1251: hr_multi_message.end_validation_set;
1252:
1253: chk_min_max_duration_rqst(p_rec.MIN_DURATION_PER_REQUEST,p_rec.MAX_DURATION_PER_REQUEST);
1254:
1255: chk_max_duration_in_whole(p_rec.FIRST_PERIOD_MAX_DURATION,p_rec.MAX_DURATION_WHOLE_CAREER);

Line 1277: hr_multi_message.end_validation_set;

1273: chk_max_tot_continuous_dur(p_rec.max_tot_continuous_duration,p_rec.frequency);
1274:
1275:
1276: --
1277: hr_multi_message.end_validation_set;
1278: --
1279: -- Validate Dependent Attributes
1280: --
1281: chk_non_updateable_args

Line 1286: hr_multi_message.end_validation_set;

1282: (p_effective_date => p_effective_date
1283: ,p_rec => p_rec
1284: );
1285: --
1286: hr_multi_message.end_validation_set;
1287: --
1288: if g_debug then
1289: --
1290: hr_utility.set_location(' Leaving:'||l_proc, 10);