56: --
57: -- The primary key is invalid therefore we must error
58: --
59: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
61: hr_multi_message.add
62: (p_associated_column1
63: =>'EXCEPTION_REPORT_ID' );
64:
61: hr_multi_message.add
62: (p_associated_column1
63: =>'EXCEPTION_REPORT_ID' );
64:
65: fnd_message.raise_error;
66: END IF;
67: --
68: end if;
69: close csr_sec_grp;
125: -- The primary key is invalid therefore we must error
126: --
127: close csr_leg_code;
128: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
129: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
130: fnd_message.raise_error;
131: END IF;
132: end if;
133: hr_utility.set_location(l_proc,30);
126: --
127: close csr_leg_code;
128: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
129: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
130: fnd_message.raise_error;
131: END IF;
132: end if;
133: hr_utility.set_location(l_proc,30);
134: --
194: -- The primary key is invalid therefore we must error
195: --
196: close csr_leg_code;
197: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
198: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
199: fnd_message.raise_error;
200: END IF;
201: end if;
202: hr_utility.set_location(l_proc,30);
195: --
196: close csr_leg_code;
197: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
198: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
199: fnd_message.raise_error;
200: END IF;
201: end if;
202: hr_utility.set_location(l_proc,30);
203: --
261: IF NOT pqp_exr_shd.api_updating
262: (p_exception_report_id => p_rec.exception_report_id
263: ,p_object_version_number => p_rec.object_version_number
264: ) THEN
265: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
266: fnd_message.set_token('PROCEDURE ', l_proc);
267: fnd_message.set_token('STEP ', '5');
268: fnd_message.raise_error;
269: END IF;
262: (p_exception_report_id => p_rec.exception_report_id
263: ,p_object_version_number => p_rec.object_version_number
264: ) THEN
265: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
266: fnd_message.set_token('PROCEDURE ', l_proc);
267: fnd_message.set_token('STEP ', '5');
268: fnd_message.raise_error;
269: END IF;
270:
263: ,p_object_version_number => p_rec.object_version_number
264: ) THEN
265: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
266: fnd_message.set_token('PROCEDURE ', l_proc);
267: fnd_message.set_token('STEP ', '5');
268: fnd_message.raise_error;
269: END IF;
270:
271: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
264: ) THEN
265: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
266: fnd_message.set_token('PROCEDURE ', l_proc);
267: fnd_message.set_token('STEP ', '5');
268: fnd_message.raise_error;
269: END IF;
270:
271: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
272: nvl (pqp_exr_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
406:
407: -- Raise error as the input currency code is not equal
408: -- to the default currency for the BG
409:
410: fnd_message.set_name('PQP','PQP_230520_CUR_CODE_MISMATCH' );
411: fnd_message.raise_error;
412: --hr_utility.set_message(8303,'PQP_230520_CUR_CODE_MISMATCH' );
413: --hr_utility.raise_error;
414:
407: -- Raise error as the input currency code is not equal
408: -- to the default currency for the BG
409:
410: fnd_message.set_name('PQP','PQP_230520_CUR_CODE_MISMATCH' );
411: fnd_message.raise_error;
412: --hr_utility.set_message(8303,'PQP_230520_CUR_CODE_MISMATCH' );
413: --hr_utility.raise_error;
414:
415: END IF; -- end if of currency code check ...
518: IF csr_bal_type%NOTFOUND THEN
519:
520: -- Raise an error
521:
522: fnd_message.set_name('PQP','PQP_230549_BAL_TYPE_NOT_FOUND' );
523: fnd_message.raise_error;
524: -- hr_utility.set_message(8303,'PQP_230549_BAL_TYPE_NOT_FOUND' );
525: --hr_utility.raise_error;
526:
519:
520: -- Raise an error
521:
522: fnd_message.set_name('PQP','PQP_230549_BAL_TYPE_NOT_FOUND' );
523: fnd_message.raise_error;
524: -- hr_utility.set_message(8303,'PQP_230549_BAL_TYPE_NOT_FOUND' );
525: --hr_utility.raise_error;
526:
527: END IF; -- end if of balance type id check ...
620: IF csr_bal_dim%NOTFOUND THEN
621:
622: -- Raise an error
623:
624: fnd_message.set_name('PQP','PQP_230550_BAL_DIM_NOT_FOUND' );
625: fnd_message.raise_error;
626: --hr_utility.set_message(8303,'PQP_230550_BAL_DIM_NOT_FOUND' );
627: --hr_utility.raise_error;
628:
621:
622: -- Raise an error
623:
624: fnd_message.set_name('PQP','PQP_230550_BAL_DIM_NOT_FOUND' );
625: fnd_message.raise_error;
626: --hr_utility.set_message(8303,'PQP_230550_BAL_DIM_NOT_FOUND' );
627: --hr_utility.raise_error;
628:
629: END IF; -- end if of balance dimension check...
708: IF p_variance_type NOT IN ('A', 'P') THEN
709:
710: -- Raise error as the variance type is not 'A' or 'P'
711:
712: fnd_message.set_name('PQP','PQP_230551_VARIANCE_MISMATCH' );
713: fnd_message.raise_error;
714: -- hr_utility.set_message(8303,'PQP_230551_VARIANCE_MISMATCH' );
715: -- hr_utility.raise_error;
716:
709:
710: -- Raise error as the variance type is not 'A' or 'P'
711:
712: fnd_message.set_name('PQP','PQP_230551_VARIANCE_MISMATCH' );
713: fnd_message.raise_error;
714: -- hr_utility.set_message(8303,'PQP_230551_VARIANCE_MISMATCH' );
715: -- hr_utility.raise_error;
716:
717: END IF; -- end if of variance type check ...
723: END IF; -- end if of api updating check ...
724: --
725: --added by pjavaji
726: IF p_comparison_type ='PC' AND p_variance_type='P' THEN
727: fnd_message.set_name('PQP','PQP_230583_INVALID_VAR_TYPE' );
728: fnd_message.raise_error;
729: -- hr_utility.set_message(8303,'PQP_230583_INVALID_VAR_TYPE' );
730: -- hr_utility.raise_error;
731: END IF;
724: --
725: --added by pjavaji
726: IF p_comparison_type ='PC' AND p_variance_type='P' THEN
727: fnd_message.set_name('PQP','PQP_230583_INVALID_VAR_TYPE' );
728: fnd_message.raise_error;
729: -- hr_utility.set_message(8303,'PQP_230583_INVALID_VAR_TYPE' );
730: -- hr_utility.raise_error;
731: END IF;
732: --
816: hr_utility.set_location(l_proc, 30);
817:
818: IF p_business_group_id is not null THEN
819: IF p_output_format_type='TXT' THEN
820: fnd_message.set_name('PQP','PQP_230444_BACKCOMP_SUPPORT');
821: fnd_message.raise_error;
822: END IF;
823: /* IF hr_api.not_exists_in_hr_lookups
824: (p_lookup_type => 'PQP_OUTPUT_FORMAT_TYPES'
817:
818: IF p_business_group_id is not null THEN
819: IF p_output_format_type='TXT' THEN
820: fnd_message.set_name('PQP','PQP_230444_BACKCOMP_SUPPORT');
821: fnd_message.raise_error;
822: END IF;
823: /* IF hr_api.not_exists_in_hr_lookups
824: (p_lookup_type => 'PQP_OUTPUT_FORMAT_TYPES'
825: ,p_lookup_code => p_output_format_type
826: ,p_effective_date => l_effective_date ) THEN
827:
828: -- Raise error as the value does not exist as a lookup
829:
830: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
831: fnd_message.set_token('COLUMN','output_format_TYPE' );
832: fnd_message.set_token('LOOKUP_TYPE', 'PQP_output_format_TYPES' );
833: fnd_message.raise_error;
834: END IF; */ -- End if of lookup check ...
827:
828: -- Raise error as the value does not exist as a lookup
829:
830: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
831: fnd_message.set_token('COLUMN','output_format_TYPE' );
832: fnd_message.set_token('LOOKUP_TYPE', 'PQP_output_format_TYPES' );
833: fnd_message.raise_error;
834: END IF; */ -- End if of lookup check ...
835: hr_utility.set_location(l_proc, 40);
828: -- Raise error as the value does not exist as a lookup
829:
830: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
831: fnd_message.set_token('COLUMN','output_format_TYPE' );
832: fnd_message.set_token('LOOKUP_TYPE', 'PQP_output_format_TYPES' );
833: fnd_message.raise_error;
834: END IF; */ -- End if of lookup check ...
835: hr_utility.set_location(l_proc, 40);
836: /* ELSE
829:
830: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
831: fnd_message.set_token('COLUMN','output_format_TYPE' );
832: fnd_message.set_token('LOOKUP_TYPE', 'PQP_output_format_TYPES' );
833: fnd_message.raise_error;
834: END IF; */ -- End if of lookup check ...
835: hr_utility.set_location(l_proc, 40);
836: /* ELSE
837: IF hr_api.not_exists_in_hrstanlookups
840: ,p_effective_date => l_effective_date ) THEN
841:
842: -- Raise error as the value does not exist as a lookup
843:
844: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
845: fnd_message.set_token('COLUMN','output_format_TYPE' );
846: fnd_message.set_token('LOOKUP_TYPE', 'PQP_OUTPUT_FORMAT_TYPES' );
847: fnd_message.raise_error;
848:
841:
842: -- Raise error as the value does not exist as a lookup
843:
844: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
845: fnd_message.set_token('COLUMN','output_format_TYPE' );
846: fnd_message.set_token('LOOKUP_TYPE', 'PQP_OUTPUT_FORMAT_TYPES' );
847: fnd_message.raise_error;
848:
849: END IF; */ -- End if of lookup check ...
842: -- Raise error as the value does not exist as a lookup
843:
844: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
845: fnd_message.set_token('COLUMN','output_format_TYPE' );
846: fnd_message.set_token('LOOKUP_TYPE', 'PQP_OUTPUT_FORMAT_TYPES' );
847: fnd_message.raise_error;
848:
849: END IF; */ -- End if of lookup check ...
850: hr_utility.set_location(l_proc, 50);
843:
844: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
845: fnd_message.set_token('COLUMN','output_format_TYPE' );
846: fnd_message.set_token('LOOKUP_TYPE', 'PQP_OUTPUT_FORMAT_TYPES' );
847: fnd_message.raise_error;
848:
849: END IF; */ -- End if of lookup check ...
850: hr_utility.set_location(l_proc, 50);
851: END IF; -- End if of business group check...
931: IF p_variance_value > 100 THEN
932:
933: --Raise error as the variance value exceeded 100
934:
935: fnd_message.set_name('PQP','PQP_230552_VARIANCE_VALUE_MORE' );
936: fnd_message.raise_error;
937: --hr_utility.set_message(8303,'PQP_230552_VARIANCE_VALUE_MORE' );
938: --hr_utility.raise_error;
939:
932:
933: --Raise error as the variance value exceeded 100
934:
935: fnd_message.set_name('PQP','PQP_230552_VARIANCE_VALUE_MORE' );
936: fnd_message.raise_error;
937: --hr_utility.set_message(8303,'PQP_230552_VARIANCE_VALUE_MORE' );
938: --hr_utility.raise_error;
939:
940: END IF; -- end if of variance value check ...
1048: ,p_effective_date => l_effective_date ) THEN
1049:
1050: -- Raise error as the value does not exist as a lookup
1051:
1052: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
1053: fnd_message.set_token('COLUMN','COMPARISON_TYPE' );
1054: fnd_message.set_token('LOOKUP_TYPE', 'PQP_COMPARISON_TYPE' );
1055: fnd_message.raise_error;
1056: END IF; -- End if of lookup check ...
1049:
1050: -- Raise error as the value does not exist as a lookup
1051:
1052: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
1053: fnd_message.set_token('COLUMN','COMPARISON_TYPE' );
1054: fnd_message.set_token('LOOKUP_TYPE', 'PQP_COMPARISON_TYPE' );
1055: fnd_message.raise_error;
1056: END IF; -- End if of lookup check ...
1057: hr_utility.set_location(l_proc, 40);
1050: -- Raise error as the value does not exist as a lookup
1051:
1052: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
1053: fnd_message.set_token('COLUMN','COMPARISON_TYPE' );
1054: fnd_message.set_token('LOOKUP_TYPE', 'PQP_COMPARISON_TYPE' );
1055: fnd_message.raise_error;
1056: END IF; -- End if of lookup check ...
1057: hr_utility.set_location(l_proc, 40);
1058: ELSE
1051:
1052: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
1053: fnd_message.set_token('COLUMN','COMPARISON_TYPE' );
1054: fnd_message.set_token('LOOKUP_TYPE', 'PQP_COMPARISON_TYPE' );
1055: fnd_message.raise_error;
1056: END IF; -- End if of lookup check ...
1057: hr_utility.set_location(l_proc, 40);
1058: ELSE
1059: IF hr_api.not_exists_in_hrstanlookups
1062: ,p_effective_date => l_effective_date ) THEN
1063:
1064: -- Raise error as the value does not exist as a lookup
1065:
1066: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
1067: fnd_message.set_token('COLUMN','COMPARISON_TYPE' );
1068: fnd_message.set_token('LOOKUP_TYPE', 'PQP_COMPARISON_TYPE' );
1069: fnd_message.raise_error;
1070:
1063:
1064: -- Raise error as the value does not exist as a lookup
1065:
1066: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
1067: fnd_message.set_token('COLUMN','COMPARISON_TYPE' );
1068: fnd_message.set_token('LOOKUP_TYPE', 'PQP_COMPARISON_TYPE' );
1069: fnd_message.raise_error;
1070:
1071: END IF; -- End if of lookup check ...
1064: -- Raise error as the value does not exist as a lookup
1065:
1066: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
1067: fnd_message.set_token('COLUMN','COMPARISON_TYPE' );
1068: fnd_message.set_token('LOOKUP_TYPE', 'PQP_COMPARISON_TYPE' );
1069: fnd_message.raise_error;
1070:
1071: END IF; -- End if of lookup check ...
1072: hr_utility.set_location(l_proc, 50);
1065:
1066: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
1067: fnd_message.set_token('COLUMN','COMPARISON_TYPE' );
1068: fnd_message.set_token('LOOKUP_TYPE', 'PQP_COMPARISON_TYPE' );
1069: fnd_message.raise_error;
1070:
1071: END IF; -- End if of lookup check ...
1072: hr_utility.set_location(l_proc, 50);
1073: END IF; -- End if of business group check...
1082: -- and balance dimension
1083: --
1084: FOR c_rec IN c_dim_suffix LOOP
1085: IF upper(c_rec.db_suffix) <> upper(substr(p_comparison_type,1,1)) THEN
1086: fnd_message.set_name('PQP','PQP_230567_DIM_COM_TYP_INVALID');
1087: fnd_message.raise_error;
1088: --hr_utility.set_message(8303,'PQP_230567_DIM_COM_TYP_INVALID');
1089: --hr_utility.raise_error;
1090: END IF;
1083: --
1084: FOR c_rec IN c_dim_suffix LOOP
1085: IF upper(c_rec.db_suffix) <> upper(substr(p_comparison_type,1,1)) THEN
1086: fnd_message.set_name('PQP','PQP_230567_DIM_COM_TYP_INVALID');
1087: fnd_message.raise_error;
1088: --hr_utility.set_message(8303,'PQP_230567_DIM_COM_TYP_INVALID');
1089: --hr_utility.raise_error;
1090: END IF;
1091: END LOOP;
1183: ,p_effective_date => l_effective_date ) THEN
1184:
1185: -- Raise error as the value does not exist as a lookup
1186:
1187: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
1188: fnd_message.set_token('COLUMN','variance_operator_TYPE' );
1189: fnd_message.set_token('LOOKUP_TYPE', 'PQP_VARIANCE_OPERATOR_TYPES' );
1190: fnd_message.raise_error;
1191: END IF; -- End if of lookup check ...
1184:
1185: -- Raise error as the value does not exist as a lookup
1186:
1187: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
1188: fnd_message.set_token('COLUMN','variance_operator_TYPE' );
1189: fnd_message.set_token('LOOKUP_TYPE', 'PQP_VARIANCE_OPERATOR_TYPES' );
1190: fnd_message.raise_error;
1191: END IF; -- End if of lookup check ...
1192: hr_utility.set_location(l_proc, 40);
1185: -- Raise error as the value does not exist as a lookup
1186:
1187: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
1188: fnd_message.set_token('COLUMN','variance_operator_TYPE' );
1189: fnd_message.set_token('LOOKUP_TYPE', 'PQP_VARIANCE_OPERATOR_TYPES' );
1190: fnd_message.raise_error;
1191: END IF; -- End if of lookup check ...
1192: hr_utility.set_location(l_proc, 40);
1193: ELSE
1186:
1187: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
1188: fnd_message.set_token('COLUMN','variance_operator_TYPE' );
1189: fnd_message.set_token('LOOKUP_TYPE', 'PQP_VARIANCE_OPERATOR_TYPES' );
1190: fnd_message.raise_error;
1191: END IF; -- End if of lookup check ...
1192: hr_utility.set_location(l_proc, 40);
1193: ELSE
1194: IF hr_api.not_exists_in_hrstanlookups
1197: ,p_effective_date => l_effective_date ) THEN
1198:
1199: -- Raise error as the value does not exist as a lookup
1200:
1201: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
1202: fnd_message.set_token('COLUMN','variance_operator_TYPE' );
1203: fnd_message.set_token('LOOKUP_TYPE', 'PQP_VARIANCE_OPERATOR_TYPES' );
1204: fnd_message.raise_error;
1205:
1198:
1199: -- Raise error as the value does not exist as a lookup
1200:
1201: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
1202: fnd_message.set_token('COLUMN','variance_operator_TYPE' );
1203: fnd_message.set_token('LOOKUP_TYPE', 'PQP_VARIANCE_OPERATOR_TYPES' );
1204: fnd_message.raise_error;
1205:
1206: END IF; -- End if of lookup check ...
1199: -- Raise error as the value does not exist as a lookup
1200:
1201: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
1202: fnd_message.set_token('COLUMN','variance_operator_TYPE' );
1203: fnd_message.set_token('LOOKUP_TYPE', 'PQP_VARIANCE_OPERATOR_TYPES' );
1204: fnd_message.raise_error;
1205:
1206: END IF; -- End if of lookup check ...
1207: hr_utility.set_location(l_proc, 50);
1200:
1201: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
1202: fnd_message.set_token('COLUMN','variance_operator_TYPE' );
1203: fnd_message.set_token('LOOKUP_TYPE', 'PQP_VARIANCE_OPERATOR_TYPES' );
1204: fnd_message.raise_error;
1205:
1206: END IF; -- End if of lookup check ...
1207: hr_utility.set_location(l_proc, 50);
1208: END IF; -- End if of business group check...
1283:
1284: -- Raise error as the input comparison value is not equal
1285: -- to one
1286:
1287: fnd_message.set_name('PQP','PQP_230553_COMPARISON_VAL_QUAL' );
1288: fnd_message.raise_error;
1289: --hr_utility.set_message(8303,'PQP_230553_COMPARISON_VAL_QUAL' );
1290: --hr_utility.raise_error;
1291:
1284: -- Raise error as the input comparison value is not equal
1285: -- to one
1286:
1287: fnd_message.set_name('PQP','PQP_230553_COMPARISON_VAL_QUAL' );
1288: fnd_message.raise_error;
1289: --hr_utility.set_message(8303,'PQP_230553_COMPARISON_VAL_QUAL' );
1290: --hr_utility.raise_error;
1291:
1292: END IF; -- end if of comparison value check ...
1314:
1315: -- Raise error as the input comparison value is not equal
1316: -- to one
1317:
1318: fnd_message.set_name('PQP','PQP_230553_COMPARISON_VAL_QUAL' );
1319: fnd_message.raise_error;
1320: --hr_utility.set_message(8303,'PQP_230553_COMPARISON_VAL_QUAL' );
1321: --hr_utility.raise_error;
1322:
1315: -- Raise error as the input comparison value is not equal
1316: -- to one
1317:
1318: fnd_message.set_name('PQP','PQP_230553_COMPARISON_VAL_QUAL' );
1319: fnd_message.raise_error;
1320: --hr_utility.set_message(8303,'PQP_230553_COMPARISON_VAL_QUAL' );
1321: --hr_utility.raise_error;
1322:
1323: END IF; -- end if of comparison value check ...
1432: IF csr_report_name%FOUND THEN
1433:
1434: -- Raise an error
1435:
1436: fnd_message.set_name('PQP','PQP_230554_REPORT_NAME_UNIQUE' );
1437: fnd_message.raise_error;
1438: --hr_utility.set_message(8303,'PQP_230554_REPORT_NAME_UNIQUE' );
1439: --hr_utility.raise_error;
1440:
1433:
1434: -- Raise an error
1435:
1436: fnd_message.set_name('PQP','PQP_230554_REPORT_NAME_UNIQUE' );
1437: fnd_message.raise_error;
1438: --hr_utility.set_message(8303,'PQP_230554_REPORT_NAME_UNIQUE' );
1439: --hr_utility.raise_error;
1440:
1441: END IF; -- end if of report name check ...
1502: IF csr_rep_grp%FOUND THEN
1503:
1504: -- Raise error
1505:
1506: fnd_message.set_name('PQP','PQP_230555_CHILD_REPORT_GRP' );
1507: fnd_message.raise_error;
1508: --hr_utility.set_message(8303,'PQP_230555_CHILD_REPORT_GRP' );
1509: --hr_utility.raise_error;
1510:
1503:
1504: -- Raise error
1505:
1506: fnd_message.set_name('PQP','PQP_230555_CHILD_REPORT_GRP' );
1507: fnd_message.raise_error;
1508: --hr_utility.set_message(8303,'PQP_230555_CHILD_REPORT_GRP' );
1509: --hr_utility.raise_error;
1510:
1511: END IF; -- end if of report group row check...
1525: BEGIN
1526:
1527: IF p_rec.business_group_id IS NULL THEN
1528:
1529: fnd_message.set_name('PQP','PQP_230919_SEED_DEL_CHK' );
1530: fnd_message.raise_error;
1531:
1532: END IF;
1533:
1526:
1527: IF p_rec.business_group_id IS NULL THEN
1528:
1529: fnd_message.set_name('PQP','PQP_230919_SEED_DEL_CHK' );
1530: fnd_message.raise_error;
1531:
1532: END IF;
1533:
1534: END;
1540: BEGIN
1541: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1542: IF p_rec.business_group_id IS NULL THEN
1543:
1544: fnd_message.set_name('PQP','PQP_230584_SEED_UPD_CHK' );
1545: fnd_message.raise_error;
1546:
1547: END IF;
1548: END IF;
1541: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1542: IF p_rec.business_group_id IS NULL THEN
1543:
1544: fnd_message.set_name('PQP','PQP_230584_SEED_UPD_CHK' );
1545: fnd_message.raise_error;
1546:
1547: END IF;
1548: END IF;
1549: