57: close csr_sec_grp;
58: --
59: -- The primary key is invalid therefore we must error
60: --
61: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
62: hr_multi_message.add
63: (p_associated_column1
64: => nvl(p_associated_column1,'BALANCE_FEED_ID')
65: );
139: --
140: -- The primary key is invalid therefore we must error
141: --
142: close csr_leg_code;
143: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
144: fnd_message.raise_error;
145: end if;
146: hr_utility.set_location(l_proc,30);
147: --
140: -- The primary key is invalid therefore we must error
141: --
142: close csr_leg_code;
143: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
144: fnd_message.raise_error;
145: end if;
146: hr_utility.set_location(l_proc,30);
147: --
148: -- Set the global variables so the values are
202: (p_balance_feed_id => p_rec.balance_feed_id
203: ,p_effective_date => p_effective_date
204: ,p_object_version_number => p_rec.object_version_number
205: ) THEN
206: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
207: fnd_message.set_token('PROCEDURE ', l_proc);
208: fnd_message.set_token('STEP ', '5');
209: fnd_message.raise_error;
210: END IF;
203: ,p_effective_date => p_effective_date
204: ,p_object_version_number => p_rec.object_version_number
205: ) THEN
206: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
207: fnd_message.set_token('PROCEDURE ', l_proc);
208: fnd_message.set_token('STEP ', '5');
209: fnd_message.raise_error;
210: END IF;
211: --
204: ,p_object_version_number => p_rec.object_version_number
205: ) THEN
206: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
207: fnd_message.set_token('PROCEDURE ', l_proc);
208: fnd_message.set_token('STEP ', '5');
209: fnd_message.raise_error;
210: END IF;
211: --
212: hr_utility.set_location('Entering:'||l_proc, 6);
205: ) THEN
206: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
207: fnd_message.set_token('PROCEDURE ', l_proc);
208: fnd_message.set_token('STEP ', '5');
209: fnd_message.raise_error;
210: END IF;
211: --
212: hr_utility.set_location('Entering:'||l_proc, 6);
213:
329: --
330: -- An unhandled or unexpected error has occurred which
331: -- we must report
332: --
333: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
334: fnd_message.set_token('PROCEDURE', l_proc);
335: fnd_message.set_token('STEP','15');
336: fnd_message.raise_error;
337: End dt_update_validate;
330: -- An unhandled or unexpected error has occurred which
331: -- we must report
332: --
333: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
334: fnd_message.set_token('PROCEDURE', l_proc);
335: fnd_message.set_token('STEP','15');
336: fnd_message.raise_error;
337: End dt_update_validate;
338: --
331: -- we must report
332: --
333: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
334: fnd_message.set_token('PROCEDURE', l_proc);
335: fnd_message.set_token('STEP','15');
336: fnd_message.raise_error;
337: End dt_update_validate;
338: --
339: -- ----------------------------------------------------------------------------
332: --
333: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
334: fnd_message.set_token('PROCEDURE', l_proc);
335: fnd_message.set_token('STEP','15');
336: fnd_message.raise_error;
337: End dt_update_validate;
338: --
339: -- ----------------------------------------------------------------------------
340: -- |--------------------------< dt_delete_validate >--------------------------|
426: --
427: -- An unhandled or unexpected error has occurred which
428: -- we must report
429: --
430: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
431: fnd_message.set_token('PROCEDURE', l_proc);
432: fnd_message.set_token('STEP','15');
433: fnd_message.raise_error;
434: --
427: -- An unhandled or unexpected error has occurred which
428: -- we must report
429: --
430: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
431: fnd_message.set_token('PROCEDURE', l_proc);
432: fnd_message.set_token('STEP','15');
433: fnd_message.raise_error;
434: --
435: End dt_delete_validate;
428: -- we must report
429: --
430: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
431: fnd_message.set_token('PROCEDURE', l_proc);
432: fnd_message.set_token('STEP','15');
433: fnd_message.raise_error;
434: --
435: End dt_delete_validate;
436: --
429: --
430: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
431: fnd_message.set_token('PROCEDURE', l_proc);
432: fnd_message.set_token('STEP','15');
433: fnd_message.raise_error;
434: --
435: End dt_delete_validate;
436: --
437: -- ----------------------------------------------------------------------------
527: Fetch c_chk_bg_id into l_exists;
528: If c_chk_bg_id%notfound Then
529: --
530: Close c_chk_bg_id;
531: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
532: fnd_message.set_token('COLUMN','BUSINESS_GROUP_ID');
533: fnd_message.set_token('TABLE','HR_ORGANIZATION_UNITS');
534: fnd_message.raise_error;
535: --
528: If c_chk_bg_id%notfound Then
529: --
530: Close c_chk_bg_id;
531: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
532: fnd_message.set_token('COLUMN','BUSINESS_GROUP_ID');
533: fnd_message.set_token('TABLE','HR_ORGANIZATION_UNITS');
534: fnd_message.raise_error;
535: --
536: End If;
529: --
530: Close c_chk_bg_id;
531: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
532: fnd_message.set_token('COLUMN','BUSINESS_GROUP_ID');
533: fnd_message.set_token('TABLE','HR_ORGANIZATION_UNITS');
534: fnd_message.raise_error;
535: --
536: End If;
537: Close c_chk_bg_id;
530: Close c_chk_bg_id;
531: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
532: fnd_message.set_token('COLUMN','BUSINESS_GROUP_ID');
533: fnd_message.set_token('TABLE','HR_ORGANIZATION_UNITS');
534: fnd_message.raise_error;
535: --
536: End If;
537: Close c_chk_bg_id;
538: End If;
570: Fetch c_chk_leg_code into l_exists;
571: If c_chk_leg_code%notfound Then
572: --
573: Close c_chk_leg_code;
574: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
575: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
576: fnd_message.set_token('TABLE','FND_TERRITORIES');
577: fnd_message.raise_error;
578: --
571: If c_chk_leg_code%notfound Then
572: --
573: Close c_chk_leg_code;
574: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
575: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
576: fnd_message.set_token('TABLE','FND_TERRITORIES');
577: fnd_message.raise_error;
578: --
579: End If;
572: --
573: Close c_chk_leg_code;
574: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
575: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
576: fnd_message.set_token('TABLE','FND_TERRITORIES');
577: fnd_message.raise_error;
578: --
579: End If;
580: Close c_chk_leg_code;
573: Close c_chk_leg_code;
574: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
575: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
576: fnd_message.set_token('TABLE','FND_TERRITORIES');
577: fnd_message.raise_error;
578: --
579: End If;
580: Close c_chk_leg_code;
581:
629: Fetch csr_ipv_id into l_exists;
630: If csr_ipv_id%notfound Then
631: --
632: Close csr_ipv_id;
633: fnd_message.set_name('PAY','PAY_34154_LEG_BUS_MISMATCH');
634: fnd_message.set_token('ENTITY1','INITIAL BALANCE FEED');
635: fnd_message.set_token('ENTITY2','INPUT VALUE');
636: fnd_message.raise_error;
637: --
630: If csr_ipv_id%notfound Then
631: --
632: Close csr_ipv_id;
633: fnd_message.set_name('PAY','PAY_34154_LEG_BUS_MISMATCH');
634: fnd_message.set_token('ENTITY1','INITIAL BALANCE FEED');
635: fnd_message.set_token('ENTITY2','INPUT VALUE');
636: fnd_message.raise_error;
637: --
638: End If;
631: --
632: Close csr_ipv_id;
633: fnd_message.set_name('PAY','PAY_34154_LEG_BUS_MISMATCH');
634: fnd_message.set_token('ENTITY1','INITIAL BALANCE FEED');
635: fnd_message.set_token('ENTITY2','INPUT VALUE');
636: fnd_message.raise_error;
637: --
638: End If;
639: Close csr_ipv_id;
632: Close csr_ipv_id;
633: fnd_message.set_name('PAY','PAY_34154_LEG_BUS_MISMATCH');
634: fnd_message.set_token('ENTITY1','INITIAL BALANCE FEED');
635: fnd_message.set_token('ENTITY2','INPUT VALUE');
636: fnd_message.raise_error;
637: --
638: End If;
639: Close csr_ipv_id;
640:
648:
649: if csr_ipv_multiple_feeds%found then
650:
651: close csr_ipv_multiple_feeds;
652: fnd_message.set_name('PAY','PAY_33245_BIFEED_IPV_MUL_FEEDS');
653: fnd_message.raise_error;
654:
655: end if;
656:
649: if csr_ipv_multiple_feeds%found then
650:
651: close csr_ipv_multiple_feeds;
652: fnd_message.set_name('PAY','PAY_33245_BIFEED_IPV_MUL_FEEDS');
653: fnd_message.raise_error;
654:
655: end if;
656:
657: close csr_ipv_multiple_feeds;
703: Fetch csr_bal_type_id into l_exists;
704: If csr_bal_type_id%notfound Then
705: --
706: Close csr_bal_type_id;
707: fnd_message.set_name('PAY','PAY_34154_LEG_BUS_MISMATCH');
708: fnd_message.set_token('ENTITY1','INITIAL BALANCE FEED');
709: fnd_message.set_token('ENTITY2','BALANCE');
710: fnd_message.raise_error;
711: --
704: If csr_bal_type_id%notfound Then
705: --
706: Close csr_bal_type_id;
707: fnd_message.set_name('PAY','PAY_34154_LEG_BUS_MISMATCH');
708: fnd_message.set_token('ENTITY1','INITIAL BALANCE FEED');
709: fnd_message.set_token('ENTITY2','BALANCE');
710: fnd_message.raise_error;
711: --
712: End If;
705: --
706: Close csr_bal_type_id;
707: fnd_message.set_name('PAY','PAY_34154_LEG_BUS_MISMATCH');
708: fnd_message.set_token('ENTITY1','INITIAL BALANCE FEED');
709: fnd_message.set_token('ENTITY2','BALANCE');
710: fnd_message.raise_error;
711: --
712: End If;
713: Close csr_bal_type_id;
706: Close csr_bal_type_id;
707: fnd_message.set_name('PAY','PAY_34154_LEG_BUS_MISMATCH');
708: fnd_message.set_token('ENTITY1','INITIAL BALANCE FEED');
709: fnd_message.set_token('ENTITY2','BALANCE');
710: fnd_message.raise_error;
711: --
712: End If;
713: Close csr_bal_type_id;
714: --
777: if csr_classifications_exist%found then
778: close csr_classifications_exist;
779: if not (get_balance_init_flag(p_input_value_id))
780: and not l_allow_adjust_feed then --Bug # 10427303/ 10352801
781: fnd_message.set_name('PAY','HR_7444_BAL_FEED_READ_ONLY');
782: fnd_message.raise_error;
783: end if;
784: else
785: close csr_classifications_exist;
778: close csr_classifications_exist;
779: if not (get_balance_init_flag(p_input_value_id))
780: and not l_allow_adjust_feed then --Bug # 10427303/ 10352801
781: fnd_message.set_name('PAY','HR_7444_BAL_FEED_READ_ONLY');
782: fnd_message.raise_error;
783: end if;
784: else
785: close csr_classifications_exist;
786: end if;
852: open csr_initial_feed_exist;
853: fetch csr_initial_feed_exist into l_balance_initialization_flag;
854: if csr_initial_feed_exist%found then
855: close csr_initial_feed_exist;
856: fnd_message.set_name('PAY','HR_7875_BAL_FEED_HAS_INIT_FEED');
857: fnd_message.raise_error;
858: else
859: close csr_initial_feed_exist;
860: end if;
853: fetch csr_initial_feed_exist into l_balance_initialization_flag;
854: if csr_initial_feed_exist%found then
855: close csr_initial_feed_exist;
856: fnd_message.set_name('PAY','HR_7875_BAL_FEED_HAS_INIT_FEED');
857: fnd_message.raise_error;
858: else
859: close csr_initial_feed_exist;
860: end if;
861: --
917: fetch csr_ipv_uom into l_ipv_uom;
918: close csr_ipv_uom;
919: --
920: if substr(l_bal_uom,1,1) <> substr(l_ipv_uom,1,1) then
921: fnd_message.set_name('PAY','HR_6553_BAL_WRONG_UOM');
922: fnd_message.raise_error;
923: end if;
924: --
925: hr_utility.set_location(' Leaving:'||l_proc, 10);
918: close csr_ipv_uom;
919: --
920: if substr(l_bal_uom,1,1) <> substr(l_ipv_uom,1,1) then
921: fnd_message.set_name('PAY','HR_6553_BAL_WRONG_UOM');
922: fnd_message.raise_error;
923: end if;
924: --
925: hr_utility.set_location(' Leaving:'||l_proc, 10);
926: --
983: open csr_currency_match;
984: fetch csr_currency_match into l_exists;
985: if csr_currency_match%notfound then
986: close csr_currency_match;
987: fnd_message.set_name('PAY','PAY_33246_BF_CUR_MISMATCH');
988: fnd_message.raise_error;
989: else
990: close csr_currency_match;
991: end if;
984: fetch csr_currency_match into l_exists;
985: if csr_currency_match%notfound then
986: close csr_currency_match;
987: fnd_message.set_name('PAY','PAY_33246_BF_CUR_MISMATCH');
988: fnd_message.raise_error;
989: else
990: close csr_currency_match;
991: end if;
992: end if;
1038: ,p_lookup_type => 'ADD_SUBTRACT'
1039: ,p_lookup_code => p_scale
1040: )
1041: then
1042: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1043: fnd_message.raise_error;
1044: end if;
1045:
1046: --
1039: ,p_lookup_code => p_scale
1040: )
1041: then
1042: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1043: fnd_message.raise_error;
1044: end if;
1045:
1046: --
1047: hr_api.mandatory_arg_error
1053:
1054: -- Scale value must only be 1 when initial balance feed is being created
1055:
1056: if get_balance_init_flag (p_input_value_id => p_input_value_id) and p_scale <> 1 then
1057: fnd_message.set_name('PAY','PAY_33242_BIFEED_INV_SCALE');
1058: fnd_message.raise_error;
1059: end if;
1060: --
1061: hr_utility.set_location(' Leaving:'||l_proc, 10);
1054: -- Scale value must only be 1 when initial balance feed is being created
1055:
1056: if get_balance_init_flag (p_input_value_id => p_input_value_id) and p_scale <> 1 then
1057: fnd_message.set_name('PAY','PAY_33242_BIFEED_INV_SCALE');
1058: fnd_message.raise_error;
1059: end if;
1060: --
1061: hr_utility.set_location(' Leaving:'||l_proc, 10);
1062:
1109: open csr_bal_feed_unique;
1110: fetch csr_bal_feed_unique into l_exists;
1111: if csr_bal_feed_unique%found then
1112: close csr_bal_feed_unique;
1113: fnd_message.set_name('PAY','HR_6109_BAL_UNI_FEED');
1114: fnd_message.raise_error;
1115: else
1116: close csr_bal_feed_unique;
1117: end if;
1110: fetch csr_bal_feed_unique into l_exists;
1111: if csr_bal_feed_unique%found then
1112: close csr_bal_feed_unique;
1113: fnd_message.set_name('PAY','HR_6109_BAL_UNI_FEED');
1114: fnd_message.raise_error;
1115: else
1116: close csr_bal_feed_unique;
1117: end if;
1118: --
1165:
1166: if(csr_feed_ipv_value%notfound) then
1167: close csr_feed_ipv_value;
1168: --raise error since balance feed is outside the life-time of the input value
1169: fnd_message.set_name('PAY','HR_7048_BAL_FEED_PAST_INP_VAL');
1170: fnd_message.raise_error;
1171: else
1172: close csr_feed_ipv_value;
1173: end if;
1166: if(csr_feed_ipv_value%notfound) then
1167: close csr_feed_ipv_value;
1168: --raise error since balance feed is outside the life-time of the input value
1169: fnd_message.set_name('PAY','HR_7048_BAL_FEED_PAST_INP_VAL');
1170: fnd_message.raise_error;
1171: else
1172: close csr_feed_ipv_value;
1173: end if;
1174: --
1222:
1223: if get_balance_init_flag (p_input_value_id => p_input_value_id) and
1224: p_datetrack_mode <> hr_api.g_correction then
1225:
1226: fnd_message.set_name('PAY','PAY_33244_BIFEED_INV_ACTION');
1227: fnd_message.set_token('ACTION', 'UPDATE');
1228: fnd_message.set_token('MODE', p_datetrack_mode);
1229: fnd_message.raise_error;
1230:
1223: if get_balance_init_flag (p_input_value_id => p_input_value_id) and
1224: p_datetrack_mode <> hr_api.g_correction then
1225:
1226: fnd_message.set_name('PAY','PAY_33244_BIFEED_INV_ACTION');
1227: fnd_message.set_token('ACTION', 'UPDATE');
1228: fnd_message.set_token('MODE', p_datetrack_mode);
1229: fnd_message.raise_error;
1230:
1231: end if;
1224: p_datetrack_mode <> hr_api.g_correction then
1225:
1226: fnd_message.set_name('PAY','PAY_33244_BIFEED_INV_ACTION');
1227: fnd_message.set_token('ACTION', 'UPDATE');
1228: fnd_message.set_token('MODE', p_datetrack_mode);
1229: fnd_message.raise_error;
1230:
1231: end if;
1232: --
1225:
1226: fnd_message.set_name('PAY','PAY_33244_BIFEED_INV_ACTION');
1227: fnd_message.set_token('ACTION', 'UPDATE');
1228: fnd_message.set_token('MODE', p_datetrack_mode);
1229: fnd_message.raise_error;
1230:
1231: end if;
1232: --
1233: hr_utility.set_location(' Leaving:'||l_proc, 10);
1281:
1282: if get_balance_init_flag( p_input_value_id => p_input_value_id)
1283: and p_datetrack_mode <> hr_api.g_zap then
1284:
1285: fnd_message.set_name('PAY','PAY_33244_BIFEED_INV_ACTION');
1286: fnd_message.set_token('ACTION', 'DELETE');
1287: fnd_message.set_token('MODE', p_datetrack_mode);
1288: fnd_message.raise_error;
1289:
1282: if get_balance_init_flag( p_input_value_id => p_input_value_id)
1283: and p_datetrack_mode <> hr_api.g_zap then
1284:
1285: fnd_message.set_name('PAY','PAY_33244_BIFEED_INV_ACTION');
1286: fnd_message.set_token('ACTION', 'DELETE');
1287: fnd_message.set_token('MODE', p_datetrack_mode);
1288: fnd_message.raise_error;
1289:
1290: end if;
1283: and p_datetrack_mode <> hr_api.g_zap then
1284:
1285: fnd_message.set_name('PAY','PAY_33244_BIFEED_INV_ACTION');
1286: fnd_message.set_token('ACTION', 'DELETE');
1287: fnd_message.set_token('MODE', p_datetrack_mode);
1288: fnd_message.raise_error;
1289:
1290: end if;
1291: --
1284:
1285: fnd_message.set_name('PAY','PAY_33244_BIFEED_INV_ACTION');
1286: fnd_message.set_token('ACTION', 'DELETE');
1287: fnd_message.set_token('MODE', p_datetrack_mode);
1288: fnd_message.raise_error;
1289:
1290: end if;
1291: --
1292: hr_utility.set_location(' Leaving:'||l_proc, 10);
1439: p_rec.input_value_id,
1440: p_validation_start_date,
1441: l_validation_end_date) then
1442:
1443: fnd_message.set_name('PAY','HR_7876_BAL_FEED_RESULTS_EXIST');
1444: p_exist_run_result_warning :=TRUE;
1445:
1446: end if;
1447: END IF; -- Bug 10427303
1453: -- hr_api.g_eot.
1454:
1455: if get_balance_init_flag (p_input_value_id => p_rec.input_value_id)
1456: and l_validation_end_date <> hr_api.g_eot then
1457: fnd_message.set_name('PAY','PAY_33243_BIFEED_INV_EDATE');
1458: fnd_message.raise_error;
1459: end if;
1460:
1461: END IF; -- added for Bug #8721639
1454:
1455: if get_balance_init_flag (p_input_value_id => p_rec.input_value_id)
1456: and l_validation_end_date <> hr_api.g_eot then
1457: fnd_message.set_name('PAY','PAY_33243_BIFEED_INV_EDATE');
1458: fnd_message.raise_error;
1459: end if;
1460:
1461: END IF; -- added for Bug #8721639
1462:
1544: ,null, null
1545: ,p_validation_start_date
1546: ,p_validation_end_date
1547: ) then
1548: fnd_message.set_name('PAY','HR_7876_BAL_FEED_RESULTS_EXIST');
1549: p_exist_run_result_warning :=TRUE;
1550: end if;
1551: --
1552: -- Validate Dependent Attributes
1645: null, null,
1646: p_validation_start_date,
1647: l_validation_end_date) then
1648:
1649: fnd_message.set_name('PAY','HR_7876_BAL_FEED_RESULTS_EXIST');
1650: p_exist_run_result_warning :=TRUE;
1651:
1652: end if;
1653: --