DBA Data[Home] [Help]

APPS.PER_GB_EXTRA_PERSON_CHECKS dependencies on FND_MESSAGE

Line 24: fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');

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:

Line 25: fnd_message.set_token('FIELD', 'Qualified Teacher Status Date');

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,

Line 26: fnd_message.raise_error;

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

Line 32: fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');

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:

Line 33: fnd_message.set_token('FIELD', 'Teacher Number');

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

Line 34: fnd_message.raise_error;

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

Line 41: fnd_message.set_name('PQP', 'PQP_230251_ENTER_ABS_YR_TERM');

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:

Line 42: fnd_message.raise_error;

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 ;

Line 70: fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');

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:

Line 71: fnd_message.set_token('FIELD', 'Qualified Teacher Status Date');

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,

Line 72: fnd_message.raise_error;

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

Line 78: fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');

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:

Line 79: fnd_message.set_token('FIELD', 'Teacher Number');

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

Line 80: fnd_message.raise_error;

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

Line 87: fnd_message.set_name('PQP', 'PQP_230251_ENTER_ABS_YR_TERM');

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:

Line 88: fnd_message.raise_error;

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 ;