20:
21: -- 1) If Qualified Teacher Status = Yes,
22: -- then Qualified Teacher Status Date must be provided
23: if p_pei_information1 = 'Y' and p_pei_information2 is null then
24: fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');
25: fnd_message.set_token('FIELD', 'Qualified Teacher Status Date');
26: fnd_message.raise_error;
27: end if ;
28:
21: -- 1) If Qualified Teacher Status = Yes,
22: -- then Qualified Teacher Status Date must be provided
23: if p_pei_information1 = 'Y' and p_pei_information2 is null then
24: fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');
25: fnd_message.set_token('FIELD', 'Qualified Teacher Status Date');
26: fnd_message.raise_error;
27: end if ;
28:
29: -- 2) If Qualified Teacher Status = Yes,
22: -- then Qualified Teacher Status Date must be provided
23: if p_pei_information1 = 'Y' and p_pei_information2 is null then
24: fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');
25: fnd_message.set_token('FIELD', 'Qualified Teacher Status Date');
26: fnd_message.raise_error;
27: end if ;
28:
29: -- 2) If Qualified Teacher Status = Yes,
30: -- then Teacher Number must be provided
28:
29: -- 2) If Qualified Teacher Status = Yes,
30: -- then Teacher Number must be provided
31: if p_pei_information1 = 'Y' and p_pei_information2 is null then
32: fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');
33: fnd_message.set_token('FIELD', 'Teacher Number');
34: fnd_message.raise_error;
35: end if ;
36:
29: -- 2) If Qualified Teacher Status = Yes,
30: -- then Teacher Number must be provided
31: if p_pei_information1 = 'Y' and p_pei_information2 is null then
32: fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');
33: fnd_message.set_token('FIELD', 'Teacher Number');
34: fnd_message.raise_error;
35: end if ;
36:
37: -- 3) If Override Absent on Census Day Indicator is provided
30: -- then Teacher Number must be provided
31: if p_pei_information1 = 'Y' and p_pei_information2 is null then
32: fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');
33: fnd_message.set_token('FIELD', 'Teacher Number');
34: fnd_message.raise_error;
35: end if ;
36:
37: -- 3) If Override Absent on Census Day Indicator is provided
38: -- then Override Absent on Census Day Year and Term are mandatory
37: -- 3) If Override Absent on Census Day Indicator is provided
38: -- then Override Absent on Census Day Year and Term are mandatory
39: if p_pei_information6 is not null then
40: if p_pei_information7 is null or p_pei_information8 is null then
41: fnd_message.set_name('PQP', 'PQP_230251_ENTER_ABS_YR_TERM');
42: fnd_message.raise_error;
43: end if ;
44: end if;
45:
38: -- then Override Absent on Census Day Year and Term are mandatory
39: if p_pei_information6 is not null then
40: if p_pei_information7 is null or p_pei_information8 is null then
41: fnd_message.set_name('PQP', 'PQP_230251_ENTER_ABS_YR_TERM');
42: fnd_message.raise_error;
43: end if ;
44: end if;
45:
46: end if ;
66:
67: -- 1) If Qualified Teacher Status = Yes,
68: -- then Qualified Teacher Status Date must be provided
69: if p_pei_information1 = 'Y' and p_pei_information2 is null then
70: fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');
71: fnd_message.set_token('FIELD', 'Qualified Teacher Status Date');
72: fnd_message.raise_error;
73: end if ;
74:
67: -- 1) If Qualified Teacher Status = Yes,
68: -- then Qualified Teacher Status Date must be provided
69: if p_pei_information1 = 'Y' and p_pei_information2 is null then
70: fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');
71: fnd_message.set_token('FIELD', 'Qualified Teacher Status Date');
72: fnd_message.raise_error;
73: end if ;
74:
75: -- 2) If Qualified Teacher Status = Yes,
68: -- then Qualified Teacher Status Date must be provided
69: if p_pei_information1 = 'Y' and p_pei_information2 is null then
70: fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');
71: fnd_message.set_token('FIELD', 'Qualified Teacher Status Date');
72: fnd_message.raise_error;
73: end if ;
74:
75: -- 2) If Qualified Teacher Status = Yes,
76: -- then Teacher Number must be provided
74:
75: -- 2) If Qualified Teacher Status = Yes,
76: -- then Teacher Number must be provided
77: if p_pei_information1 = 'Y' and p_pei_information4 is null then
78: fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');
79: fnd_message.set_token('FIELD', 'Teacher Number');
80: fnd_message.raise_error;
81: end if ;
82:
75: -- 2) If Qualified Teacher Status = Yes,
76: -- then Teacher Number must be provided
77: if p_pei_information1 = 'Y' and p_pei_information4 is null then
78: fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');
79: fnd_message.set_token('FIELD', 'Teacher Number');
80: fnd_message.raise_error;
81: end if ;
82:
83: -- 3) If Override Absent on Census Day Indicator is provided
76: -- then Teacher Number must be provided
77: if p_pei_information1 = 'Y' and p_pei_information4 is null then
78: fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');
79: fnd_message.set_token('FIELD', 'Teacher Number');
80: fnd_message.raise_error;
81: end if ;
82:
83: -- 3) If Override Absent on Census Day Indicator is provided
84: -- then Override Absent on Census Day Year and Term are mandatory
83: -- 3) If Override Absent on Census Day Indicator is provided
84: -- then Override Absent on Census Day Year and Term are mandatory
85: if p_pei_information6 is not null then
86: if p_pei_information7 is null or p_pei_information8 is null then
87: fnd_message.set_name('PQP', 'PQP_230251_ENTER_ABS_YR_TERM');
88: fnd_message.raise_error;
89: end if ;
90: end if;
91:
84: -- then Override Absent on Census Day Year and Term are mandatory
85: if p_pei_information6 is not null then
86: if p_pei_information7 is null or p_pei_information8 is null then
87: fnd_message.set_name('PQP', 'PQP_230251_ENTER_ABS_YR_TERM');
88: fnd_message.raise_error;
89: end if ;
90: end if;
91:
92: end if ;