[Home] [Help]
97: p_return boolean ;
98: begin
99: -- If the given user ethnic origin is already mapped
100: -- then user should not be able to map it again
101: pqp_gb_swf_validations.chk_single_unique_mapping(p_configuration_value_id => p_configuration_value_id
102: , p_business_group_id => p_business_group_id
103: , p_pcv_information_category => p_pcv_information_category
104: , p_information_column => 'PCV_INFORMATION1'
105: , p_value => p_pcv_information1
137: begin
138:
139: -- 1) While creating multiple configuration records for this oconfiguration type
140: -- user should not be able to create records with different lookup names
141: pqp_gb_swf_validations.chk_unique_lookup_name(p_configuration_value_id => p_configuration_value_id
142: , p_business_group_id => p_business_group_id
143: , p_pcv_information_category => p_pcv_information_category
144: , p_information_column => 'PCV_INFORMATION1'
145: , p_value => p_pcv_information1
183:
184:
185: -- 4) While creating multiple configuration records for this oconfiguration type
186: -- user should not be able to map same segment value twice
187: pqp_gb_swf_validations.chk_range_unique_mapping(p_configuration_value_id => p_configuration_value_id
188: , p_business_group_id => p_business_group_id
189: , p_pcv_information_category => p_pcv_information_category
190: , p_information_start_column => 'PCV_INFORMATION2'
191: , p_information_end_column => 'PCV_INFORMATION3'
298: p_return boolean ;
299: begin
300: -- 1) While creating multiple configuration records for this oconfiguration type
301: -- user should not be able to create records with different lookup names
302: pqp_gb_swf_validations.chk_unique_lookup_name( p_configuration_value_id => p_configuration_value_id
303: , p_business_group_id => p_business_group_id
304: , p_pcv_information_category => p_pcv_information_category
305: , p_information_column => 'PCV_INFORMATION1'
306: , p_value => p_pcv_information1
312:
313: --
314: -- 2) If the given user segment value is already mapped
315: -- Then user should not be able to map it again
316: pqp_gb_swf_validations.chk_single_unique_mapping(p_configuration_value_id => p_configuration_value_id
317: , p_business_group_id => p_business_group_id
318: , p_pcv_information_category => p_pcv_information_category
319: , p_information_column => 'PCV_INFORMATION2'
320: , p_value => p_pcv_information2
370: p_return boolean;
371: begin
372: -- 1) While creating multiple configuration records for this oconfiguration type
373: -- user should not be able to create records with different source names
374: pqp_gb_swf_validations.chk_unique_lookup_name(p_configuration_value_id => p_configuration_value_id
375: , p_business_group_id => p_business_group_id
376: , p_pcv_information_category => p_pcv_information_category
377: , p_information_column => 'PCV_INFORMATION1'
378: , p_value => p_pcv_information1
412: --
413: -- 4) If the given user value(Assignment Category or PQP contract type) is already mapped
414: -- Then user should not be able to map it again
415: if p_pcv_information1 = 'ASG_CAT' then
416: pqp_gb_swf_validations.chk_single_unique_mapping(p_configuration_value_id => p_configuration_value_id
417: , p_business_group_id => p_business_group_id
418: , p_pcv_information_category => p_pcv_information_category
419: , p_information_column => 'PCV_INFORMATION3'
420: , p_value => p_pcv_information3
425: fnd_message.set_token('DCSF_CODE', 'DCSF Contract Type Value');
426: fnd_message.raise_error;
427: end if ;
428: elsif p_pcv_information1 = 'CNTRCT_TYPE' then
429: pqp_gb_swf_validations.chk_single_unique_mapping(p_configuration_value_id => p_configuration_value_id
430: , p_business_group_id => p_business_group_id
431: , p_pcv_information_category => p_pcv_information_category
432: , p_information_column => 'PCV_INFORMATION4'
433: , p_value => p_pcv_information4
461: begin
462:
463: -- 1) While creating multiple configuration records for this oconfiguration type
464: -- user should not be able to create records with different lookup names
465: pqp_gb_swf_validations.chk_unique_lookup_name(p_configuration_value_id => p_configuration_value_id
466: , p_business_group_id => p_business_group_id
467: , p_pcv_information_category => p_pcv_information_category
468: , p_information_column => 'PCV_INFORMATION1'
469: , p_value => p_pcv_information1
474: end if ;
475:
476: -- 2) If the given user origin value is already mapped
477: -- then user should not be able to map it again
478: pqp_gb_swf_validations.chk_single_unique_mapping(p_configuration_value_id => p_configuration_value_id
479: , p_business_group_id => p_business_group_id
480: , p_pcv_information_category => p_pcv_information_category
481: , p_information_column => 'PCV_INFORMATION2'
482: , p_value => p_pcv_information2
507: begin
508:
509: -- 1) While creating multiple configuration records for this oconfiguration type
510: -- user should not be able to create records with different lookup names
511: pqp_gb_swf_validations.chk_unique_lookup_name(p_configuration_value_id => p_configuration_value_id
512: , p_business_group_id => p_business_group_id
513: , p_pcv_information_category => p_pcv_information_category
514: , p_information_column => 'PCV_INFORMATION1'
515: , p_value => p_pcv_information1
520: end if ;
521:
522: -- 2) If the given user Destination value is already mapped
523: -- then user should not be able to map it again
524: pqp_gb_swf_validations.chk_single_unique_mapping(p_configuration_value_id => p_configuration_value_id
525: , p_business_group_id => p_business_group_id
526: , p_pcv_information_category => p_pcv_information_category
527: , p_information_column => 'PCV_INFORMATION2'
528: , p_value => p_pcv_information2
677: end if ;
678: --
679: -- 2) While creating multiple configuration records for this oconfiguration type
680: -- user should not be able to create records with different lookup names
681: pqp_gb_swf_validations.chk_unique_lookup_name(p_configuration_value_id => p_configuration_value_id
682: , p_business_group_id => p_business_group_id
683: , p_pcv_information_category => p_pcv_information_category
684: , p_information_column => 'PCV_INFORMATION1'
685: , p_value => p_pcv_information1
702:
703:
704: -- 4) While creating multiple configuration records for this oconfiguration type
705: -- user should not be able to map same segment value twice
706: pqp_gb_swf_validations.chk_range_unique_mapping(
707: p_configuration_value_id => p_configuration_value_id
708: , p_business_group_id => p_business_group_id
709: , p_pcv_information_category => p_pcv_information_category
710: , p_information_start_column => 'PCV_INFORMATION2'
735: p_return boolean;
736: begin
737: -- If the given user payscale is already mapped
738: -- then user should not be able to map it again
739: pqp_gb_swf_validations.chk_single_unique_mapping(p_configuration_value_id => p_configuration_value_id
740: , p_business_group_id => p_business_group_id
741: , p_pcv_information_category => p_pcv_information_category
742: , p_information_column => 'PCV_INFORMATION1'
743: , p_value => p_pcv_information1
811: l_count number;
812: begin
813: -- 1) While creating multiple configuration records for this oconfiguration type
814: -- user should not be able to create records with different lookup names
815: pqp_gb_swf_validations.chk_unique_lookup_name(
816: p_configuration_value_id => p_configuration_value_id
817: , p_business_group_id => p_business_group_id
818: , p_pcv_information_category => p_pcv_information_category
819: , p_information_column => 'PCV_INFORMATION1'
850:
851:
852: -- 4) While creating multiple configuration records for this oconfiguration type
853: -- user should not be able to map same segment value twice
854: pqp_gb_swf_validations.chk_range_unique_mapping(
855: p_configuration_value_id => p_configuration_value_id
856: , p_business_group_id => p_business_group_id
857: , p_pcv_information_category => p_pcv_information_category
858: , p_information_start_column => 'PCV_INFORMATION2'
920: end if ;
921:
922: -- 2) While creating multiple configuration records for this oconfiguration type
923: -- user should not be able to map same spine point value twice
924: pqp_gb_swf_validations.chk_spine_pt_unique_mapping(
925: p_configuration_value_id => p_configuration_value_id
926: , p_business_group_id => p_business_group_id
927: , p_pcv_information_category => p_pcv_information_category
928: , p_payscale_column => 'PCV_INFORMATION1'
957: p_return boolean;
958: begin
959: -- If the given user spine point is already mapped
960: -- then user should not be able to map it again
961: pqp_gb_swf_validations.chk_single_unique_mapping(
962: p_configuration_value_id => p_configuration_value_id
963: , p_business_group_id => p_business_group_id
964: , p_pcv_information_category => p_pcv_information_category
965: , p_information_column => 'PCV_INFORMATION2'
997: l_message_token varchar2(50);
998: begin
999: -- 1) While creating multiple configuration records for this oconfiguration type
1000: -- user should not be able to create records with different source names
1001: pqp_gb_swf_validations.chk_unique_lookup_name(
1002: p_configuration_value_id => p_configuration_value_id
1003: , p_business_group_id => p_business_group_id
1004: , p_pcv_information_category => p_pcv_information_category
1005: , p_information_column => 'PCV_INFORMATION1'
1049: l_value := p_pcv_information4;
1050: l_message_token := 'Absence Type Value';
1051: end if ;
1052:
1053: pqp_gb_swf_validations.chk_single_unique_mapping(
1054: p_configuration_value_id => p_configuration_value_id
1055: , p_business_group_id => p_business_group_id
1056: , p_pcv_information_category => p_pcv_information_category
1057: , p_information_column => l_information_column
1088: l_message_token varchar2(50);
1089: begin
1090: -- 1) While creating multiple configuration records for this oconfiguration type
1091: -- user should not be able to create records with different source names
1092: pqp_gb_swf_validations.chk_unique_lookup_name(
1093: p_configuration_value_id => p_configuration_value_id
1094: , p_business_group_id => p_business_group_id
1095: , p_pcv_information_category => p_pcv_information_category
1096: , p_information_column => 'PCV_INFORMATION1'
1131: l_value := p_pcv_information4;
1132: l_message_token := 'Qualification Type Value';
1133: end if ;
1134:
1135: pqp_gb_swf_validations.chk_single_unique_mapping(
1136: p_configuration_value_id => p_configuration_value_id
1137: , p_business_group_id => p_business_group_id
1138: , p_pcv_information_category => p_pcv_information_category
1139: , p_information_column => l_information_column
1163: p_return boolean ;
1164: begin
1165: -- If the given user subject code is already mapped
1166: -- then user should not be able to map it again
1167: pqp_gb_swf_validations.chk_single_unique_mapping(p_configuration_value_id => p_configuration_value_id
1168: , p_business_group_id => p_business_group_id
1169: , p_pcv_information_category => p_pcv_information_category
1170: , p_information_column => 'PCV_INFORMATION1'
1171: , p_value => p_pcv_information1
1203: p_return boolean;
1204: begin
1205: -- 1) While creating multiple configuration records for this oconfiguration type
1206: -- user should not be able to create records with different source names
1207: pqp_gb_swf_validations.chk_unique_lookup_name(
1208: p_configuration_value_id => p_configuration_value_id
1209: , p_business_group_id => p_business_group_id
1210: , p_pcv_information_category => p_pcv_information_category
1211: , p_information_column => 'PCV_INFORMATION1'
1261:
1262: -- 3) When source is PQP Contract Types, then user should not be able to map
1263: -- same contract type twice
1264: if p_pcv_information1 = 'CONTRACT_TYPE' then
1265: pqp_gb_swf_validations.chk_hours_cntrct_tp_unq_map(
1266: p_configuration_value_id => p_configuration_value_id
1267: , p_business_group_id => p_business_group_id
1268: , p_pcv_information_category => p_pcv_information_category
1269: , p_information_column => 'PCV_INFORMATION2'
1278: end if ;
1279:
1280: -- 4) When source is Assignment Hours, then user should not be able to map
1281: -- same Staff Category twice
1282: pqp_gb_swf_validations.chk_single_unique_mapping(
1283: p_configuration_value_id => p_configuration_value_id
1284: , p_business_group_id => p_business_group_id
1285: , p_pcv_information_category => p_pcv_information_category
1286: , p_information_column => 'PCV_INFORMATION7'