eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_CONFIGURATION_VALUE dependencies on FND_MESSAGE

Line 60: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

56: -- If Person EIT or Person DFF is selected as source
57: -- then Context and Segment names are mandatory
58: if p_pcv_information1 = 'PER_PEOPLE' then
59: if p_pcv_information3 is null then
60: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
61: fnd_message.set_token('FIELD', 'Context Name');
62: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
63: fnd_message.raise_error;
64: elsif p_pcv_information4 is null then

Line 61: fnd_message.set_token('FIELD', 'Context Name');

57: -- then Context and Segment names are mandatory
58: if p_pcv_information1 = 'PER_PEOPLE' then
59: if p_pcv_information3 is null then
60: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
61: fnd_message.set_token('FIELD', 'Context Name');
62: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
63: fnd_message.raise_error;
64: elsif p_pcv_information4 is null then
65: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

Line 62: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');

58: if p_pcv_information1 = 'PER_PEOPLE' then
59: if p_pcv_information3 is null then
60: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
61: fnd_message.set_token('FIELD', 'Context Name');
62: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
63: fnd_message.raise_error;
64: elsif p_pcv_information4 is null then
65: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
66: fnd_message.set_token('FIELD', 'Segment Column');

Line 63: fnd_message.raise_error;

59: if p_pcv_information3 is null then
60: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
61: fnd_message.set_token('FIELD', 'Context Name');
62: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
63: fnd_message.raise_error;
64: elsif p_pcv_information4 is null then
65: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
66: fnd_message.set_token('FIELD', 'Segment Column');
67: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');

Line 65: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

61: fnd_message.set_token('FIELD', 'Context Name');
62: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
63: fnd_message.raise_error;
64: elsif p_pcv_information4 is null then
65: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
66: fnd_message.set_token('FIELD', 'Segment Column');
67: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
68: fnd_message.raise_error;
69: end if ;

Line 66: fnd_message.set_token('FIELD', 'Segment Column');

62: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
63: fnd_message.raise_error;
64: elsif p_pcv_information4 is null then
65: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
66: fnd_message.set_token('FIELD', 'Segment Column');
67: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
68: fnd_message.raise_error;
69: end if ;
70: elsif p_pcv_information1 = 'Extra Person Info DDF' then

Line 67: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');

63: fnd_message.raise_error;
64: elsif p_pcv_information4 is null then
65: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
66: fnd_message.set_token('FIELD', 'Segment Column');
67: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
68: fnd_message.raise_error;
69: end if ;
70: elsif p_pcv_information1 = 'Extra Person Info DDF' then
71: if p_pcv_information3 is null then

Line 68: fnd_message.raise_error;

64: elsif p_pcv_information4 is null then
65: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
66: fnd_message.set_token('FIELD', 'Segment Column');
67: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
68: fnd_message.raise_error;
69: end if ;
70: elsif p_pcv_information1 = 'Extra Person Info DDF' then
71: if p_pcv_information3 is null then
72: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

Line 72: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

68: fnd_message.raise_error;
69: end if ;
70: elsif p_pcv_information1 = 'Extra Person Info DDF' then
71: if p_pcv_information3 is null then
72: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
73: fnd_message.set_token('FIELD', 'Context Name');
74: fnd_message.set_token('SOURCE', 'Person EIT (Extra Person Information Flexfield)');
75: fnd_message.raise_error;
76: elsif p_pcv_information4 is null then

Line 73: fnd_message.set_token('FIELD', 'Context Name');

69: end if ;
70: elsif p_pcv_information1 = 'Extra Person Info DDF' then
71: if p_pcv_information3 is null then
72: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
73: fnd_message.set_token('FIELD', 'Context Name');
74: fnd_message.set_token('SOURCE', 'Person EIT (Extra Person Information Flexfield)');
75: fnd_message.raise_error;
76: elsif p_pcv_information4 is null then
77: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

Line 74: fnd_message.set_token('SOURCE', 'Person EIT (Extra Person Information Flexfield)');

70: elsif p_pcv_information1 = 'Extra Person Info DDF' then
71: if p_pcv_information3 is null then
72: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
73: fnd_message.set_token('FIELD', 'Context Name');
74: fnd_message.set_token('SOURCE', 'Person EIT (Extra Person Information Flexfield)');
75: fnd_message.raise_error;
76: elsif p_pcv_information4 is null then
77: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
78: fnd_message.set_token('FIELD', 'Segment Column');

Line 75: fnd_message.raise_error;

71: if p_pcv_information3 is null then
72: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
73: fnd_message.set_token('FIELD', 'Context Name');
74: fnd_message.set_token('SOURCE', 'Person EIT (Extra Person Information Flexfield)');
75: fnd_message.raise_error;
76: elsif p_pcv_information4 is null then
77: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
78: fnd_message.set_token('FIELD', 'Segment Column');
79: fnd_message.set_token('SOURCE', 'Person EIT (Extra Person Information Flexfield)');

Line 77: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

73: fnd_message.set_token('FIELD', 'Context Name');
74: fnd_message.set_token('SOURCE', 'Person EIT (Extra Person Information Flexfield)');
75: fnd_message.raise_error;
76: elsif p_pcv_information4 is null then
77: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
78: fnd_message.set_token('FIELD', 'Segment Column');
79: fnd_message.set_token('SOURCE', 'Person EIT (Extra Person Information Flexfield)');
80: fnd_message.raise_error;
81: end if ;

Line 78: fnd_message.set_token('FIELD', 'Segment Column');

74: fnd_message.set_token('SOURCE', 'Person EIT (Extra Person Information Flexfield)');
75: fnd_message.raise_error;
76: elsif p_pcv_information4 is null then
77: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
78: fnd_message.set_token('FIELD', 'Segment Column');
79: fnd_message.set_token('SOURCE', 'Person EIT (Extra Person Information Flexfield)');
80: fnd_message.raise_error;
81: end if ;
82: end if ;

Line 79: fnd_message.set_token('SOURCE', 'Person EIT (Extra Person Information Flexfield)');

75: fnd_message.raise_error;
76: elsif p_pcv_information4 is null then
77: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
78: fnd_message.set_token('FIELD', 'Segment Column');
79: fnd_message.set_token('SOURCE', 'Person EIT (Extra Person Information Flexfield)');
80: fnd_message.raise_error;
81: end if ;
82: end if ;
83: --

Line 80: fnd_message.raise_error;

76: elsif p_pcv_information4 is null then
77: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
78: fnd_message.set_token('FIELD', 'Segment Column');
79: fnd_message.set_token('SOURCE', 'Person EIT (Extra Person Information Flexfield)');
80: fnd_message.raise_error;
81: end if ;
82: end if ;
83: --
84: end chk_teacher_number ;

Line 108: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');

104: , p_information_column => 'PCV_INFORMATION1'
105: , p_value => p_pcv_information1
106: , p_return => p_return);
107: if (p_return = false) then
108: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
109: fnd_message.set_token('VALUE', 'Ethnic Origin Value');
110: fnd_message.set_token('DCSF_CODE', 'DCSF Ethnic Code');
111: fnd_message.raise_error;
112: end if ;

Line 109: fnd_message.set_token('VALUE', 'Ethnic Origin Value');

105: , p_value => p_pcv_information1
106: , p_return => p_return);
107: if (p_return = false) then
108: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
109: fnd_message.set_token('VALUE', 'Ethnic Origin Value');
110: fnd_message.set_token('DCSF_CODE', 'DCSF Ethnic Code');
111: fnd_message.raise_error;
112: end if ;
113: --

Line 110: fnd_message.set_token('DCSF_CODE', 'DCSF Ethnic Code');

106: , p_return => p_return);
107: if (p_return = false) then
108: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
109: fnd_message.set_token('VALUE', 'Ethnic Origin Value');
110: fnd_message.set_token('DCSF_CODE', 'DCSF Ethnic Code');
111: fnd_message.raise_error;
112: end if ;
113: --
114: end chk_ethnic_origin ;

Line 111: fnd_message.raise_error;

107: if (p_return = false) then
108: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
109: fnd_message.set_token('VALUE', 'Ethnic Origin Value');
110: fnd_message.set_token('DCSF_CODE', 'DCSF Ethnic Code');
111: fnd_message.raise_error;
112: end if ;
113: --
114: end chk_ethnic_origin ;
115:

Line 148: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');

144: , p_information_column => 'PCV_INFORMATION1'
145: , p_value => p_pcv_information1
146: , p_return => p_return);
147: if (p_return = false) then
148: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');
149: fnd_message.raise_error;
150: end if ;
151:
152: -- 2) If the user has given seeded QTS/QTS Route lookup name

Line 149: fnd_message.raise_error;

145: , p_value => p_pcv_information1
146: , p_return => p_return);
147: if (p_return = false) then
148: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');
149: fnd_message.raise_error;
150: end if ;
151:
152: -- 2) If the user has given seeded QTS/QTS Route lookup name
153: -- Then he should not be required to give the mapping

Line 166: fnd_message.set_name('PQP', 'PQP_230241_ENTER_MAPPING');

162: end if ;
163:
164: if p_pcv_information1 <> p_seeded_lookup_name then
165: if p_pcv_information2 is null or p_pcv_information4 is null then
166: fnd_message.set_name('PQP', 'PQP_230241_ENTER_MAPPING');
167: fnd_message.set_token('DCSF_CODE', l_field_name);
168: fnd_message.set_token('LOOKUP_NAME', p_seeded_lookup_name);
169: fnd_message.raise_error;
170: end if;

Line 167: fnd_message.set_token('DCSF_CODE', l_field_name);

163:
164: if p_pcv_information1 <> p_seeded_lookup_name then
165: if p_pcv_information2 is null or p_pcv_information4 is null then
166: fnd_message.set_name('PQP', 'PQP_230241_ENTER_MAPPING');
167: fnd_message.set_token('DCSF_CODE', l_field_name);
168: fnd_message.set_token('LOOKUP_NAME', p_seeded_lookup_name);
169: fnd_message.raise_error;
170: end if;
171: end if;

Line 168: fnd_message.set_token('LOOKUP_NAME', p_seeded_lookup_name);

164: if p_pcv_information1 <> p_seeded_lookup_name then
165: if p_pcv_information2 is null or p_pcv_information4 is null then
166: fnd_message.set_name('PQP', 'PQP_230241_ENTER_MAPPING');
167: fnd_message.set_token('DCSF_CODE', l_field_name);
168: fnd_message.set_token('LOOKUP_NAME', p_seeded_lookup_name);
169: fnd_message.raise_error;
170: end if;
171: end if;
172:

Line 169: fnd_message.raise_error;

165: if p_pcv_information2 is null or p_pcv_information4 is null then
166: fnd_message.set_name('PQP', 'PQP_230241_ENTER_MAPPING');
167: fnd_message.set_token('DCSF_CODE', l_field_name);
168: fnd_message.set_token('LOOKUP_NAME', p_seeded_lookup_name);
169: fnd_message.raise_error;
170: end if;
171: end if;
172:
173: -- 3) If Segment End Value is provided

Line 178: fnd_message.set_name('PQP', 'PQP_230242_WRONG_END_VAL');

174: -- Then Segment Start Value should not be less than Segment End Value
175: if p_pcv_information1 <> p_seeded_lookup_name then
176: if p_pcv_information3 is not null then
177: if p_pcv_information3 < p_pcv_information2 then
178: fnd_message.set_name('PQP', 'PQP_230242_WRONG_END_VAL');
179: fnd_message.set_token('TYPE', 'Segment');
180: fnd_message.raise_error;
181: end if;
182: end if ;

Line 179: fnd_message.set_token('TYPE', 'Segment');

175: if p_pcv_information1 <> p_seeded_lookup_name then
176: if p_pcv_information3 is not null then
177: if p_pcv_information3 < p_pcv_information2 then
178: fnd_message.set_name('PQP', 'PQP_230242_WRONG_END_VAL');
179: fnd_message.set_token('TYPE', 'Segment');
180: fnd_message.raise_error;
181: end if;
182: end if ;
183:

Line 180: fnd_message.raise_error;

176: if p_pcv_information3 is not null then
177: if p_pcv_information3 < p_pcv_information2 then
178: fnd_message.set_name('PQP', 'PQP_230242_WRONG_END_VAL');
179: fnd_message.set_token('TYPE', 'Segment');
180: fnd_message.raise_error;
181: end if;
182: end if ;
183:
184:

Line 196: fnd_message.set_name('PQP', 'PQP_230244_DUP_RANGE_MAP');

192: , p_value_start => p_pcv_information2
193: , p_value_end => p_pcv_information3
194: , p_return => p_return);
195: if (p_return = false) then
196: fnd_message.set_name('PQP', 'PQP_230244_DUP_RANGE_MAP');
197: fnd_message.raise_error;
198: end if ;
199: else
200: -- seeded lookup used

Line 197: fnd_message.raise_error;

193: , p_value_end => p_pcv_information3
194: , p_return => p_return);
195: if (p_return = false) then
196: fnd_message.set_name('PQP', 'PQP_230244_DUP_RANGE_MAP');
197: fnd_message.raise_error;
198: end if ;
199: else
200: -- seeded lookup used
201: -- check if there already exists a row with seeded lookup

Line 218: fnd_message.set_name('PQP', 'PQP_230240_DUPLICATE_MAPPING');

214: null ;
215: end;
216:
217: if l_count is not null then
218: fnd_message.set_name('PQP', 'PQP_230240_DUPLICATE_MAPPING');
219: fnd_message.raise_error;
220: end if;
221: end if;
222: --

Line 219: fnd_message.raise_error;

215: end;
216:
217: if l_count is not null then
218: fnd_message.set_name('PQP', 'PQP_230240_DUPLICATE_MAPPING');
219: fnd_message.raise_error;
220: end if;
221: end if;
222: --
223: end chk_qts_mapping ;

Line 246: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

242: begin
243: -- 1) If Job Key Flexfield is selected as source
244: -- Then Job Key Flexfield segment must be entered
245: if p_pcv_information1 = 'JOB' and p_pcv_information3 is null then
246: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
247: fnd_message.set_token('FIELD', 'Job Key Flexfield Segment Column');
248: fnd_message.set_token('SOURCE', 'Job Key Flexfield');
249: fnd_message.raise_error;
250:

Line 247: fnd_message.set_token('FIELD', 'Job Key Flexfield Segment Column');

243: -- 1) If Job Key Flexfield is selected as source
244: -- Then Job Key Flexfield segment must be entered
245: if p_pcv_information1 = 'JOB' and p_pcv_information3 is null then
246: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
247: fnd_message.set_token('FIELD', 'Job Key Flexfield Segment Column');
248: fnd_message.set_token('SOURCE', 'Job Key Flexfield');
249: fnd_message.raise_error;
250:
251: end if ;

Line 248: fnd_message.set_token('SOURCE', 'Job Key Flexfield');

244: -- Then Job Key Flexfield segment must be entered
245: if p_pcv_information1 = 'JOB' and p_pcv_information3 is null then
246: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
247: fnd_message.set_token('FIELD', 'Job Key Flexfield Segment Column');
248: fnd_message.set_token('SOURCE', 'Job Key Flexfield');
249: fnd_message.raise_error;
250:
251: end if ;
252:

Line 249: fnd_message.raise_error;

245: if p_pcv_information1 = 'JOB' and p_pcv_information3 is null then
246: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
247: fnd_message.set_token('FIELD', 'Job Key Flexfield Segment Column');
248: fnd_message.set_token('SOURCE', 'Job Key Flexfield');
249: fnd_message.raise_error;
250:
251: end if ;
252:
253: -- 2) If Person/Assignment DFF is selected as source

Line 257: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

253: -- 2) If Person/Assignment DFF is selected as source
254: -- Then Person/Assignment Context and Segment must be provided
255: if p_pcv_information1 = 'PER_PEOPLE' then
256: if p_pcv_information4 is null then
257: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
258: fnd_message.set_token('FIELD', 'Person/Assignment Context Name');
259: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
260: fnd_message.raise_error;
261: elsif p_pcv_information5 is null then

Line 258: fnd_message.set_token('FIELD', 'Person/Assignment Context Name');

254: -- Then Person/Assignment Context and Segment must be provided
255: if p_pcv_information1 = 'PER_PEOPLE' then
256: if p_pcv_information4 is null then
257: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
258: fnd_message.set_token('FIELD', 'Person/Assignment Context Name');
259: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
260: fnd_message.raise_error;
261: elsif p_pcv_information5 is null then
262: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

Line 259: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');

255: if p_pcv_information1 = 'PER_PEOPLE' then
256: if p_pcv_information4 is null then
257: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
258: fnd_message.set_token('FIELD', 'Person/Assignment Context Name');
259: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
260: fnd_message.raise_error;
261: elsif p_pcv_information5 is null then
262: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
263: fnd_message.set_token('FIELD', 'Person/Assignment Segment Column');

Line 260: fnd_message.raise_error;

256: if p_pcv_information4 is null then
257: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
258: fnd_message.set_token('FIELD', 'Person/Assignment Context Name');
259: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
260: fnd_message.raise_error;
261: elsif p_pcv_information5 is null then
262: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
263: fnd_message.set_token('FIELD', 'Person/Assignment Segment Column');
264: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');

Line 262: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

258: fnd_message.set_token('FIELD', 'Person/Assignment Context Name');
259: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
260: fnd_message.raise_error;
261: elsif p_pcv_information5 is null then
262: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
263: fnd_message.set_token('FIELD', 'Person/Assignment Segment Column');
264: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
265: fnd_message.raise_error;
266: end if;

Line 263: fnd_message.set_token('FIELD', 'Person/Assignment Segment Column');

259: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
260: fnd_message.raise_error;
261: elsif p_pcv_information5 is null then
262: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
263: fnd_message.set_token('FIELD', 'Person/Assignment Segment Column');
264: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
265: fnd_message.raise_error;
266: end if;
267: elsif p_pcv_information1 = 'PER_ASSIGNMENTS' then

Line 264: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');

260: fnd_message.raise_error;
261: elsif p_pcv_information5 is null then
262: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
263: fnd_message.set_token('FIELD', 'Person/Assignment Segment Column');
264: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
265: fnd_message.raise_error;
266: end if;
267: elsif p_pcv_information1 = 'PER_ASSIGNMENTS' then
268: if p_pcv_information4 is null then

Line 265: fnd_message.raise_error;

261: elsif p_pcv_information5 is null then
262: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
263: fnd_message.set_token('FIELD', 'Person/Assignment Segment Column');
264: fnd_message.set_token('SOURCE', 'Person DFF (Additional Personal Details Flexfield)');
265: fnd_message.raise_error;
266: end if;
267: elsif p_pcv_information1 = 'PER_ASSIGNMENTS' then
268: if p_pcv_information4 is null then
269: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

Line 269: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

265: fnd_message.raise_error;
266: end if;
267: elsif p_pcv_information1 = 'PER_ASSIGNMENTS' then
268: if p_pcv_information4 is null then
269: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
270: fnd_message.set_token('FIELD', 'Person/Assignment Context Name');
271: fnd_message.set_token('SOURCE', 'Assignment DFF (Additional Assignment Details DFF)');
272: fnd_message.raise_error;
273: elsif p_pcv_information5 is null then

Line 270: fnd_message.set_token('FIELD', 'Person/Assignment Context Name');

266: end if;
267: elsif p_pcv_information1 = 'PER_ASSIGNMENTS' then
268: if p_pcv_information4 is null then
269: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
270: fnd_message.set_token('FIELD', 'Person/Assignment Context Name');
271: fnd_message.set_token('SOURCE', 'Assignment DFF (Additional Assignment Details DFF)');
272: fnd_message.raise_error;
273: elsif p_pcv_information5 is null then
274: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

Line 271: fnd_message.set_token('SOURCE', 'Assignment DFF (Additional Assignment Details DFF)');

267: elsif p_pcv_information1 = 'PER_ASSIGNMENTS' then
268: if p_pcv_information4 is null then
269: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
270: fnd_message.set_token('FIELD', 'Person/Assignment Context Name');
271: fnd_message.set_token('SOURCE', 'Assignment DFF (Additional Assignment Details DFF)');
272: fnd_message.raise_error;
273: elsif p_pcv_information5 is null then
274: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
275: fnd_message.set_token('FIELD', 'Person/Assignment Segment Column');

Line 272: fnd_message.raise_error;

268: if p_pcv_information4 is null then
269: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
270: fnd_message.set_token('FIELD', 'Person/Assignment Context Name');
271: fnd_message.set_token('SOURCE', 'Assignment DFF (Additional Assignment Details DFF)');
272: fnd_message.raise_error;
273: elsif p_pcv_information5 is null then
274: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
275: fnd_message.set_token('FIELD', 'Person/Assignment Segment Column');
276: fnd_message.set_token('SOURCE', 'Assignment DFF (Additional Assignment Details DFF)');

Line 274: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

270: fnd_message.set_token('FIELD', 'Person/Assignment Context Name');
271: fnd_message.set_token('SOURCE', 'Assignment DFF (Additional Assignment Details DFF)');
272: fnd_message.raise_error;
273: elsif p_pcv_information5 is null then
274: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
275: fnd_message.set_token('FIELD', 'Person/Assignment Segment Column');
276: fnd_message.set_token('SOURCE', 'Assignment DFF (Additional Assignment Details DFF)');
277: fnd_message.raise_error;
278: end if;

Line 275: fnd_message.set_token('FIELD', 'Person/Assignment Segment Column');

271: fnd_message.set_token('SOURCE', 'Assignment DFF (Additional Assignment Details DFF)');
272: fnd_message.raise_error;
273: elsif p_pcv_information5 is null then
274: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
275: fnd_message.set_token('FIELD', 'Person/Assignment Segment Column');
276: fnd_message.set_token('SOURCE', 'Assignment DFF (Additional Assignment Details DFF)');
277: fnd_message.raise_error;
278: end if;
279: end if;

Line 276: fnd_message.set_token('SOURCE', 'Assignment DFF (Additional Assignment Details DFF)');

272: fnd_message.raise_error;
273: elsif p_pcv_information5 is null then
274: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
275: fnd_message.set_token('FIELD', 'Person/Assignment Segment Column');
276: fnd_message.set_token('SOURCE', 'Assignment DFF (Additional Assignment Details DFF)');
277: fnd_message.raise_error;
278: end if;
279: end if;
280: --

Line 277: fnd_message.raise_error;

273: elsif p_pcv_information5 is null then
274: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
275: fnd_message.set_token('FIELD', 'Person/Assignment Segment Column');
276: fnd_message.set_token('SOURCE', 'Assignment DFF (Additional Assignment Details DFF)');
277: fnd_message.raise_error;
278: end if;
279: end if;
280: --
281: end chk_hlta_source;

Line 309: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');

305: , p_information_column => 'PCV_INFORMATION1'
306: , p_value => p_pcv_information1
307: , p_return => p_return);
308: if (p_return = false) then
309: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');
310: fnd_message.raise_error;
311: end if ;
312:
313: --

Line 310: fnd_message.raise_error;

306: , p_value => p_pcv_information1
307: , p_return => p_return);
308: if (p_return = false) then
309: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');
310: fnd_message.raise_error;
311: end if ;
312:
313: --
314: -- 2) If the given user segment value is already mapped

Line 323: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');

319: , p_information_column => 'PCV_INFORMATION2'
320: , p_value => p_pcv_information2
321: , p_return => p_return);
322: if (p_return = false) then
323: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
324: fnd_message.set_token('VALUE', 'User Segment Value');
325: fnd_message.set_token('DCSF_CODE', 'HLTA Status Value');
326: fnd_message.raise_error;
327: end if ;

Line 324: fnd_message.set_token('VALUE', 'User Segment Value');

320: , p_value => p_pcv_information2
321: , p_return => p_return);
322: if (p_return = false) then
323: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
324: fnd_message.set_token('VALUE', 'User Segment Value');
325: fnd_message.set_token('DCSF_CODE', 'HLTA Status Value');
326: fnd_message.raise_error;
327: end if ;
328: --

Line 325: fnd_message.set_token('DCSF_CODE', 'HLTA Status Value');

321: , p_return => p_return);
322: if (p_return = false) then
323: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
324: fnd_message.set_token('VALUE', 'User Segment Value');
325: fnd_message.set_token('DCSF_CODE', 'HLTA Status Value');
326: fnd_message.raise_error;
327: end if ;
328: --
329: end chk_hlta_mapping;

Line 326: fnd_message.raise_error;

322: if (p_return = false) then
323: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
324: fnd_message.set_token('VALUE', 'User Segment Value');
325: fnd_message.set_token('DCSF_CODE', 'HLTA Status Value');
326: fnd_message.raise_error;
327: end if ;
328: --
329: end chk_hlta_mapping;
330:

Line 346: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

342: , p_pcv_information2 in varchar2
343: ) as
344: begin
345: if p_pcv_information1 = 'CAL' and p_pcv_information2 is null then
346: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
347: fnd_message.set_token('FIELD', 'User Formula Name');
348: fnd_message.set_token('SOURCE', 'Calculated');
349: fnd_message.raise_error;
350: end if ;

Line 347: fnd_message.set_token('FIELD', 'User Formula Name');

343: ) as
344: begin
345: if p_pcv_information1 = 'CAL' and p_pcv_information2 is null then
346: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
347: fnd_message.set_token('FIELD', 'User Formula Name');
348: fnd_message.set_token('SOURCE', 'Calculated');
349: fnd_message.raise_error;
350: end if ;
351: --

Line 348: fnd_message.set_token('SOURCE', 'Calculated');

344: begin
345: if p_pcv_information1 = 'CAL' and p_pcv_information2 is null then
346: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
347: fnd_message.set_token('FIELD', 'User Formula Name');
348: fnd_message.set_token('SOURCE', 'Calculated');
349: fnd_message.raise_error;
350: end if ;
351: --
352: end chk_arrival_date;

Line 349: fnd_message.raise_error;

345: if p_pcv_information1 = 'CAL' and p_pcv_information2 is null then
346: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
347: fnd_message.set_token('FIELD', 'User Formula Name');
348: fnd_message.set_token('SOURCE', 'Calculated');
349: fnd_message.raise_error;
350: end if ;
351: --
352: end chk_arrival_date;
353:

Line 381: fnd_message.set_name('PQP', 'PQP_230245_USE_SAME_SOURCE');

377: , p_information_column => 'PCV_INFORMATION1'
378: , p_value => p_pcv_information1
379: , p_return => p_return);
380: if (p_return = false) then
381: fnd_message.set_name('PQP', 'PQP_230245_USE_SAME_SOURCE');
382: fnd_message.raise_error;
383: end if ;
384:
385:

Line 382: fnd_message.raise_error;

378: , p_value => p_pcv_information1
379: , p_return => p_return);
380: if (p_return = false) then
381: fnd_message.set_name('PQP', 'PQP_230245_USE_SAME_SOURCE');
382: fnd_message.raise_error;
383: end if ;
384:
385:
386: --

Line 391: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

387: -- 2) Assignment Category Value must be provided if assignment category
388: -- is selected as source
389: if p_pcv_information1 = 'ASG_CAT' then
390: if p_pcv_information3 is null then
391: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
392: fnd_message.set_token('FIELD', 'Assignment Category Value');
393: fnd_message.set_token('SOURCE', 'Assignment Category');
394: fnd_message.raise_error;
395: end if ;

Line 392: fnd_message.set_token('FIELD', 'Assignment Category Value');

388: -- is selected as source
389: if p_pcv_information1 = 'ASG_CAT' then
390: if p_pcv_information3 is null then
391: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
392: fnd_message.set_token('FIELD', 'Assignment Category Value');
393: fnd_message.set_token('SOURCE', 'Assignment Category');
394: fnd_message.raise_error;
395: end if ;
396: end if ;

Line 393: fnd_message.set_token('SOURCE', 'Assignment Category');

389: if p_pcv_information1 = 'ASG_CAT' then
390: if p_pcv_information3 is null then
391: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
392: fnd_message.set_token('FIELD', 'Assignment Category Value');
393: fnd_message.set_token('SOURCE', 'Assignment Category');
394: fnd_message.raise_error;
395: end if ;
396: end if ;
397:

Line 394: fnd_message.raise_error;

390: if p_pcv_information3 is null then
391: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
392: fnd_message.set_token('FIELD', 'Assignment Category Value');
393: fnd_message.set_token('SOURCE', 'Assignment Category');
394: fnd_message.raise_error;
395: end if ;
396: end if ;
397:
398:

Line 404: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

400: -- 3) PQP Contract Type Value must be provided if PQP contract type
401: -- is selected as source
402: if p_pcv_information1 = 'CNTRCT_TYPE' then
403: if p_pcv_information4 is null then
404: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
405: fnd_message.set_token('FIELD', 'PQP Contract Type Value');
406: fnd_message.set_token('SOURCE', 'PQP Contract Type');
407: fnd_message.raise_error;
408: end if ;

Line 405: fnd_message.set_token('FIELD', 'PQP Contract Type Value');

401: -- is selected as source
402: if p_pcv_information1 = 'CNTRCT_TYPE' then
403: if p_pcv_information4 is null then
404: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
405: fnd_message.set_token('FIELD', 'PQP Contract Type Value');
406: fnd_message.set_token('SOURCE', 'PQP Contract Type');
407: fnd_message.raise_error;
408: end if ;
409: end if ;

Line 406: fnd_message.set_token('SOURCE', 'PQP Contract Type');

402: if p_pcv_information1 = 'CNTRCT_TYPE' then
403: if p_pcv_information4 is null then
404: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
405: fnd_message.set_token('FIELD', 'PQP Contract Type Value');
406: fnd_message.set_token('SOURCE', 'PQP Contract Type');
407: fnd_message.raise_error;
408: end if ;
409: end if ;
410:

Line 407: fnd_message.raise_error;

403: if p_pcv_information4 is null then
404: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
405: fnd_message.set_token('FIELD', 'PQP Contract Type Value');
406: fnd_message.set_token('SOURCE', 'PQP Contract Type');
407: fnd_message.raise_error;
408: end if ;
409: end if ;
410:
411:

Line 423: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');

419: , p_information_column => 'PCV_INFORMATION3'
420: , p_value => p_pcv_information3
421: , p_return => p_return);
422: if (p_return = false) then
423: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
424: fnd_message.set_token('VALUE', 'Assignment Category');
425: fnd_message.set_token('DCSF_CODE', 'DCSF Contract Type Value');
426: fnd_message.raise_error;
427: end if ;

Line 424: fnd_message.set_token('VALUE', 'Assignment Category');

420: , p_value => p_pcv_information3
421: , p_return => p_return);
422: if (p_return = false) then
423: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
424: fnd_message.set_token('VALUE', 'Assignment Category');
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

Line 425: fnd_message.set_token('DCSF_CODE', 'DCSF Contract Type Value');

421: , p_return => p_return);
422: if (p_return = false) then
423: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
424: fnd_message.set_token('VALUE', 'Assignment Category');
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

Line 426: fnd_message.raise_error;

422: if (p_return = false) then
423: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
424: fnd_message.set_token('VALUE', 'Assignment Category');
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

Line 436: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');

432: , p_information_column => 'PCV_INFORMATION4'
433: , p_value => p_pcv_information4
434: , p_return => p_return);
435: if (p_return = false) then
436: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
437: fnd_message.set_token('VALUE', 'PQP Contract Type Value');
438: fnd_message.set_token('DCSF_CODE', 'DCSF Contract Type Value');
439: fnd_message.raise_error;
440: end if ;

Line 437: fnd_message.set_token('VALUE', 'PQP Contract Type Value');

433: , p_value => p_pcv_information4
434: , p_return => p_return);
435: if (p_return = false) then
436: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
437: fnd_message.set_token('VALUE', 'PQP Contract Type Value');
438: fnd_message.set_token('DCSF_CODE', 'DCSF Contract Type Value');
439: fnd_message.raise_error;
440: end if ;
441: end if ;

Line 438: fnd_message.set_token('DCSF_CODE', 'DCSF Contract Type Value');

434: , p_return => p_return);
435: if (p_return = false) then
436: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
437: fnd_message.set_token('VALUE', 'PQP Contract Type Value');
438: fnd_message.set_token('DCSF_CODE', 'DCSF Contract Type Value');
439: fnd_message.raise_error;
440: end if ;
441: end if ;
442:

Line 439: fnd_message.raise_error;

435: if (p_return = false) then
436: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
437: fnd_message.set_token('VALUE', 'PQP Contract Type Value');
438: fnd_message.set_token('DCSF_CODE', 'DCSF Contract Type Value');
439: fnd_message.raise_error;
440: end if ;
441: end if ;
442:
443:

Line 472: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');

468: , p_information_column => 'PCV_INFORMATION1'
469: , p_value => p_pcv_information1
470: , p_return => p_return);
471: if (p_return = false) then
472: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');
473: fnd_message.raise_error;
474: end if ;
475:
476: -- 2) If the given user origin value is already mapped

Line 473: fnd_message.raise_error;

469: , p_value => p_pcv_information1
470: , p_return => p_return);
471: if (p_return = false) then
472: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');
473: fnd_message.raise_error;
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

Line 485: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');

481: , p_information_column => 'PCV_INFORMATION2'
482: , p_value => p_pcv_information2
483: , p_return => p_return);
484: if (p_return = false) then
485: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
486: fnd_message.set_token('VALUE', 'Origin Value');
487: fnd_message.set_token('DCSF_CODE', 'DCSF Origin Code');
488: fnd_message.raise_error;
489: end if ;

Line 486: fnd_message.set_token('VALUE', 'Origin Value');

482: , p_value => p_pcv_information2
483: , p_return => p_return);
484: if (p_return = false) then
485: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
486: fnd_message.set_token('VALUE', 'Origin Value');
487: fnd_message.set_token('DCSF_CODE', 'DCSF Origin Code');
488: fnd_message.raise_error;
489: end if ;
490: end chk_origin_mapping;

Line 487: fnd_message.set_token('DCSF_CODE', 'DCSF Origin Code');

483: , p_return => p_return);
484: if (p_return = false) then
485: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
486: fnd_message.set_token('VALUE', 'Origin Value');
487: fnd_message.set_token('DCSF_CODE', 'DCSF Origin Code');
488: fnd_message.raise_error;
489: end if ;
490: end chk_origin_mapping;
491:

Line 488: fnd_message.raise_error;

484: if (p_return = false) then
485: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
486: fnd_message.set_token('VALUE', 'Origin Value');
487: fnd_message.set_token('DCSF_CODE', 'DCSF Origin Code');
488: fnd_message.raise_error;
489: end if ;
490: end chk_origin_mapping;
491:
492: --

Line 518: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');

514: , p_information_column => 'PCV_INFORMATION1'
515: , p_value => p_pcv_information1
516: , p_return => p_return);
517: if (p_return = false) then
518: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');
519: fnd_message.raise_error;
520: end if ;
521:
522: -- 2) If the given user Destination value is already mapped

Line 519: fnd_message.raise_error;

515: , p_value => p_pcv_information1
516: , p_return => p_return);
517: if (p_return = false) then
518: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');
519: fnd_message.raise_error;
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

Line 531: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');

527: , p_information_column => 'PCV_INFORMATION2'
528: , p_value => p_pcv_information2
529: , p_return => p_return);
530: if (p_return = false) then
531: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
532: fnd_message.set_token('VALUE', 'Destination Value');
533: fnd_message.set_token('DCSF_CODE', 'DCSF Destination Code');
534: fnd_message.raise_error;
535: end if ;

Line 532: fnd_message.set_token('VALUE', 'Destination Value');

528: , p_value => p_pcv_information2
529: , p_return => p_return);
530: if (p_return = false) then
531: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
532: fnd_message.set_token('VALUE', 'Destination Value');
533: fnd_message.set_token('DCSF_CODE', 'DCSF Destination Code');
534: fnd_message.raise_error;
535: end if ;
536: --

Line 533: fnd_message.set_token('DCSF_CODE', 'DCSF Destination Code');

529: , p_return => p_return);
530: if (p_return = false) then
531: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
532: fnd_message.set_token('VALUE', 'Destination Value');
533: fnd_message.set_token('DCSF_CODE', 'DCSF Destination Code');
534: fnd_message.raise_error;
535: end if ;
536: --
537: end chk_destination_mapping;

Line 534: fnd_message.raise_error;

530: if (p_return = false) then
531: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
532: fnd_message.set_token('VALUE', 'Destination Value');
533: fnd_message.set_token('DCSF_CODE', 'DCSF Destination Code');
534: fnd_message.raise_error;
535: end if ;
536: --
537: end chk_destination_mapping;
538:

Line 586: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');

582: hr_utility.trace('p_pcv_information1='||p_pcv_information1);
583:
584: if p_pcv_information1 = 'EMP_CAT' and l_mapping_lookup <> 'EMP_CAT' then
585: hr_utility.trace('Raising error for EMP_CAT');
586: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
587: fnd_message.set_token('LOOKUP_NAME', 'EMP_CAT');
588: fnd_message.set_token('SOURCE', 'Assignment Category');
589: fnd_message.raise_error;
590: elsif p_pcv_information1 = 'EMPLOYEE_CATG' and l_mapping_lookup <> 'EMPLOYEE_CATG' then

Line 587: fnd_message.set_token('LOOKUP_NAME', 'EMP_CAT');

583:
584: if p_pcv_information1 = 'EMP_CAT' and l_mapping_lookup <> 'EMP_CAT' then
585: hr_utility.trace('Raising error for EMP_CAT');
586: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
587: fnd_message.set_token('LOOKUP_NAME', 'EMP_CAT');
588: fnd_message.set_token('SOURCE', 'Assignment Category');
589: fnd_message.raise_error;
590: elsif p_pcv_information1 = 'EMPLOYEE_CATG' and l_mapping_lookup <> 'EMPLOYEE_CATG' then
591: hr_utility.trace('Raising error for EMPLOYEE_CATG');

Line 588: fnd_message.set_token('SOURCE', 'Assignment Category');

584: if p_pcv_information1 = 'EMP_CAT' and l_mapping_lookup <> 'EMP_CAT' then
585: hr_utility.trace('Raising error for EMP_CAT');
586: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
587: fnd_message.set_token('LOOKUP_NAME', 'EMP_CAT');
588: fnd_message.set_token('SOURCE', 'Assignment Category');
589: fnd_message.raise_error;
590: elsif p_pcv_information1 = 'EMPLOYEE_CATG' and l_mapping_lookup <> 'EMPLOYEE_CATG' then
591: hr_utility.trace('Raising error for EMPLOYEE_CATG');
592: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');

Line 589: fnd_message.raise_error;

585: hr_utility.trace('Raising error for EMP_CAT');
586: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
587: fnd_message.set_token('LOOKUP_NAME', 'EMP_CAT');
588: fnd_message.set_token('SOURCE', 'Assignment Category');
589: fnd_message.raise_error;
590: elsif p_pcv_information1 = 'EMPLOYEE_CATG' and l_mapping_lookup <> 'EMPLOYEE_CATG' then
591: hr_utility.trace('Raising error for EMPLOYEE_CATG');
592: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
593: fnd_message.set_token('LOOKUP_NAME', 'EMPLOYEE_CATG');

Line 592: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');

588: fnd_message.set_token('SOURCE', 'Assignment Category');
589: fnd_message.raise_error;
590: elsif p_pcv_information1 = 'EMPLOYEE_CATG' and l_mapping_lookup <> 'EMPLOYEE_CATG' then
591: hr_utility.trace('Raising error for EMPLOYEE_CATG');
592: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
593: fnd_message.set_token('LOOKUP_NAME', 'EMPLOYEE_CATG');
594: fnd_message.set_token('SOURCE', 'Employee Category');
595: fnd_message.raise_error;
596: end if;

Line 593: fnd_message.set_token('LOOKUP_NAME', 'EMPLOYEE_CATG');

589: fnd_message.raise_error;
590: elsif p_pcv_information1 = 'EMPLOYEE_CATG' and l_mapping_lookup <> 'EMPLOYEE_CATG' then
591: hr_utility.trace('Raising error for EMPLOYEE_CATG');
592: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
593: fnd_message.set_token('LOOKUP_NAME', 'EMPLOYEE_CATG');
594: fnd_message.set_token('SOURCE', 'Employee Category');
595: fnd_message.raise_error;
596: end if;
597:

Line 594: fnd_message.set_token('SOURCE', 'Employee Category');

590: elsif p_pcv_information1 = 'EMPLOYEE_CATG' and l_mapping_lookup <> 'EMPLOYEE_CATG' then
591: hr_utility.trace('Raising error for EMPLOYEE_CATG');
592: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
593: fnd_message.set_token('LOOKUP_NAME', 'EMPLOYEE_CATG');
594: fnd_message.set_token('SOURCE', 'Employee Category');
595: fnd_message.raise_error;
596: end if;
597:
598: hr_utility.trace('Outside error raising section');

Line 595: fnd_message.raise_error;

591: hr_utility.trace('Raising error for EMPLOYEE_CATG');
592: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
593: fnd_message.set_token('LOOKUP_NAME', 'EMPLOYEE_CATG');
594: fnd_message.set_token('SOURCE', 'Employee Category');
595: fnd_message.raise_error;
596: end if;
597:
598: hr_utility.trace('Outside error raising section');
599: --

Line 603: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

599: --
600: -- 1) Segment Name must be provided if Job/Position/Grade KFF
601: -- is selected as source
602: if p_pcv_information1 = 'JOB' and p_pcv_information3 is null then
603: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
604: fnd_message.set_token('FIELD', 'Segment Column');
605: fnd_message.set_token('SOURCE', 'Job Key Flexfield');
606: fnd_message.raise_error;
607: elsif p_pcv_information1 = 'POS' and p_pcv_information3 is null then

Line 604: fnd_message.set_token('FIELD', 'Segment Column');

600: -- 1) Segment Name must be provided if Job/Position/Grade KFF
601: -- is selected as source
602: if p_pcv_information1 = 'JOB' and p_pcv_information3 is null then
603: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
604: fnd_message.set_token('FIELD', 'Segment Column');
605: fnd_message.set_token('SOURCE', 'Job Key Flexfield');
606: fnd_message.raise_error;
607: elsif p_pcv_information1 = 'POS' and p_pcv_information3 is null then
608: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

Line 605: fnd_message.set_token('SOURCE', 'Job Key Flexfield');

601: -- is selected as source
602: if p_pcv_information1 = 'JOB' and p_pcv_information3 is null then
603: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
604: fnd_message.set_token('FIELD', 'Segment Column');
605: fnd_message.set_token('SOURCE', 'Job Key Flexfield');
606: fnd_message.raise_error;
607: elsif p_pcv_information1 = 'POS' and p_pcv_information3 is null then
608: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
609: fnd_message.set_token('FIELD', 'Segment Column');

Line 606: fnd_message.raise_error;

602: if p_pcv_information1 = 'JOB' and p_pcv_information3 is null then
603: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
604: fnd_message.set_token('FIELD', 'Segment Column');
605: fnd_message.set_token('SOURCE', 'Job Key Flexfield');
606: fnd_message.raise_error;
607: elsif p_pcv_information1 = 'POS' and p_pcv_information3 is null then
608: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
609: fnd_message.set_token('FIELD', 'Segment Column');
610: fnd_message.set_token('SOURCE', 'Position Key Flexfield');

Line 608: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

604: fnd_message.set_token('FIELD', 'Segment Column');
605: fnd_message.set_token('SOURCE', 'Job Key Flexfield');
606: fnd_message.raise_error;
607: elsif p_pcv_information1 = 'POS' and p_pcv_information3 is null then
608: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
609: fnd_message.set_token('FIELD', 'Segment Column');
610: fnd_message.set_token('SOURCE', 'Position Key Flexfield');
611: fnd_message.raise_error;
612: elsif p_pcv_information1 = 'GRD' and p_pcv_information3 is null then

Line 609: fnd_message.set_token('FIELD', 'Segment Column');

605: fnd_message.set_token('SOURCE', 'Job Key Flexfield');
606: fnd_message.raise_error;
607: elsif p_pcv_information1 = 'POS' and p_pcv_information3 is null then
608: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
609: fnd_message.set_token('FIELD', 'Segment Column');
610: fnd_message.set_token('SOURCE', 'Position Key Flexfield');
611: fnd_message.raise_error;
612: elsif p_pcv_information1 = 'GRD' and p_pcv_information3 is null then
613: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

Line 610: fnd_message.set_token('SOURCE', 'Position Key Flexfield');

606: fnd_message.raise_error;
607: elsif p_pcv_information1 = 'POS' and p_pcv_information3 is null then
608: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
609: fnd_message.set_token('FIELD', 'Segment Column');
610: fnd_message.set_token('SOURCE', 'Position Key Flexfield');
611: fnd_message.raise_error;
612: elsif p_pcv_information1 = 'GRD' and p_pcv_information3 is null then
613: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
614: fnd_message.set_token('FIELD', 'Segment Column');

Line 611: fnd_message.raise_error;

607: elsif p_pcv_information1 = 'POS' and p_pcv_information3 is null then
608: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
609: fnd_message.set_token('FIELD', 'Segment Column');
610: fnd_message.set_token('SOURCE', 'Position Key Flexfield');
611: fnd_message.raise_error;
612: elsif p_pcv_information1 = 'GRD' and p_pcv_information3 is null then
613: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
614: fnd_message.set_token('FIELD', 'Segment Column');
615: fnd_message.set_token('SOURCE', 'Grade Key Flexfield');

Line 613: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

609: fnd_message.set_token('FIELD', 'Segment Column');
610: fnd_message.set_token('SOURCE', 'Position Key Flexfield');
611: fnd_message.raise_error;
612: elsif p_pcv_information1 = 'GRD' and p_pcv_information3 is null then
613: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
614: fnd_message.set_token('FIELD', 'Segment Column');
615: fnd_message.set_token('SOURCE', 'Grade Key Flexfield');
616: fnd_message.raise_error;
617: end if ;

Line 614: fnd_message.set_token('FIELD', 'Segment Column');

610: fnd_message.set_token('SOURCE', 'Position Key Flexfield');
611: fnd_message.raise_error;
612: elsif p_pcv_information1 = 'GRD' and p_pcv_information3 is null then
613: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
614: fnd_message.set_token('FIELD', 'Segment Column');
615: fnd_message.set_token('SOURCE', 'Grade Key Flexfield');
616: fnd_message.raise_error;
617: end if ;
618: hr_utility.trace('Leaving Post source checks');

Line 615: fnd_message.set_token('SOURCE', 'Grade Key Flexfield');

611: fnd_message.raise_error;
612: elsif p_pcv_information1 = 'GRD' and p_pcv_information3 is null then
613: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
614: fnd_message.set_token('FIELD', 'Segment Column');
615: fnd_message.set_token('SOURCE', 'Grade Key Flexfield');
616: fnd_message.raise_error;
617: end if ;
618: hr_utility.trace('Leaving Post source checks');
619: --

Line 616: fnd_message.raise_error;

612: elsif p_pcv_information1 = 'GRD' and p_pcv_information3 is null then
613: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
614: fnd_message.set_token('FIELD', 'Segment Column');
615: fnd_message.set_token('SOURCE', 'Grade Key Flexfield');
616: fnd_message.raise_error;
617: end if ;
618: hr_utility.trace('Leaving Post source checks');
619: --
620: end chk_role_post_source;

Line 666: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');

662:
663: --
664: -- 1) If source = Assignment/Employee Category, then lookup name must be 'EMP_CAT'/'EMPLOYEE_CATG'
665: if l_source = 'EMP_CAT' and p_pcv_information1 <> 'EMP_CAT' then
666: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
667: fnd_message.set_token('LOOKUP_NAME', 'EMP_CAT');
668: fnd_message.set_token('SOURCE', 'Assignment Category');
669: fnd_message.raise_error;
670: end if ;

Line 667: fnd_message.set_token('LOOKUP_NAME', 'EMP_CAT');

663: --
664: -- 1) If source = Assignment/Employee Category, then lookup name must be 'EMP_CAT'/'EMPLOYEE_CATG'
665: if l_source = 'EMP_CAT' and p_pcv_information1 <> 'EMP_CAT' then
666: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
667: fnd_message.set_token('LOOKUP_NAME', 'EMP_CAT');
668: fnd_message.set_token('SOURCE', 'Assignment Category');
669: fnd_message.raise_error;
670: end if ;
671:

Line 668: fnd_message.set_token('SOURCE', 'Assignment Category');

664: -- 1) If source = Assignment/Employee Category, then lookup name must be 'EMP_CAT'/'EMPLOYEE_CATG'
665: if l_source = 'EMP_CAT' and p_pcv_information1 <> 'EMP_CAT' then
666: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
667: fnd_message.set_token('LOOKUP_NAME', 'EMP_CAT');
668: fnd_message.set_token('SOURCE', 'Assignment Category');
669: fnd_message.raise_error;
670: end if ;
671:
672: if l_source = 'EMPLOYEE_CATG' and p_pcv_information1 <> 'EMPLOYEE_CATG' then

Line 669: fnd_message.raise_error;

665: if l_source = 'EMP_CAT' and p_pcv_information1 <> 'EMP_CAT' then
666: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
667: fnd_message.set_token('LOOKUP_NAME', 'EMP_CAT');
668: fnd_message.set_token('SOURCE', 'Assignment Category');
669: fnd_message.raise_error;
670: end if ;
671:
672: if l_source = 'EMPLOYEE_CATG' and p_pcv_information1 <> 'EMPLOYEE_CATG' then
673: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');

Line 673: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');

669: fnd_message.raise_error;
670: end if ;
671:
672: if l_source = 'EMPLOYEE_CATG' and p_pcv_information1 <> 'EMPLOYEE_CATG' then
673: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
674: fnd_message.set_token('LOOKUP_NAME', 'EMPLOYEE_CATG');
675: fnd_message.set_token('SOURCE', 'Employee Category');
676: fnd_message.raise_error;
677: end if ;

Line 674: fnd_message.set_token('LOOKUP_NAME', 'EMPLOYEE_CATG');

670: end if ;
671:
672: if l_source = 'EMPLOYEE_CATG' and p_pcv_information1 <> 'EMPLOYEE_CATG' then
673: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
674: fnd_message.set_token('LOOKUP_NAME', 'EMPLOYEE_CATG');
675: fnd_message.set_token('SOURCE', 'Employee Category');
676: fnd_message.raise_error;
677: end if ;
678: --

Line 675: fnd_message.set_token('SOURCE', 'Employee Category');

671:
672: if l_source = 'EMPLOYEE_CATG' and p_pcv_information1 <> 'EMPLOYEE_CATG' then
673: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
674: fnd_message.set_token('LOOKUP_NAME', 'EMPLOYEE_CATG');
675: fnd_message.set_token('SOURCE', 'Employee Category');
676: fnd_message.raise_error;
677: end if ;
678: --
679: -- 2) While creating multiple configuration records for this oconfiguration type

Line 676: fnd_message.raise_error;

672: if l_source = 'EMPLOYEE_CATG' and p_pcv_information1 <> 'EMPLOYEE_CATG' then
673: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
674: fnd_message.set_token('LOOKUP_NAME', 'EMPLOYEE_CATG');
675: fnd_message.set_token('SOURCE', 'Employee Category');
676: fnd_message.raise_error;
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

Line 688: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');

684: , p_information_column => 'PCV_INFORMATION1'
685: , p_value => p_pcv_information1
686: , p_return => p_return);
687: if (p_return = false) then
688: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');
689: fnd_message.raise_error;
690: end if ;
691:
692: --

Line 689: fnd_message.raise_error;

685: , p_value => p_pcv_information1
686: , p_return => p_return);
687: if (p_return = false) then
688: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');
689: fnd_message.raise_error;
690: end if ;
691:
692: --
693: -- 3) If source = Grade KFF, and Segment End Value is provided

Line 697: fnd_message.set_name('PQP', 'PQP_230242_WRONG_END_VAL');

693: -- 3) If source = Grade KFF, and Segment End Value is provided
694: -- Then Segment End Value should not be less than Segment Start Value
695: if l_source = 'GRD' and p_pcv_information3 is not null then
696: if p_pcv_information3 < p_pcv_information2 then
697: fnd_message.set_name('PQP', 'PQP_230242_WRONG_END_VAL');
698: fnd_message.set_token('TYPE', 'Segment');
699: fnd_message.raise_error;
700: end if ;
701: end if ;

Line 698: fnd_message.set_token('TYPE', 'Segment');

694: -- Then Segment End Value should not be less than Segment Start Value
695: if l_source = 'GRD' and p_pcv_information3 is not null then
696: if p_pcv_information3 < p_pcv_information2 then
697: fnd_message.set_name('PQP', 'PQP_230242_WRONG_END_VAL');
698: fnd_message.set_token('TYPE', 'Segment');
699: fnd_message.raise_error;
700: end if ;
701: end if ;
702:

Line 699: fnd_message.raise_error;

695: if l_source = 'GRD' and p_pcv_information3 is not null then
696: if p_pcv_information3 < p_pcv_information2 then
697: fnd_message.set_name('PQP', 'PQP_230242_WRONG_END_VAL');
698: fnd_message.set_token('TYPE', 'Segment');
699: fnd_message.raise_error;
700: end if ;
701: end if ;
702:
703:

Line 716: fnd_message.set_name('PQP', 'PQP_230244_DUP_RANGE_MAP');

712: , p_value_start => p_pcv_information2
713: , p_value_end => p_pcv_information3
714: , p_return => p_return);
715: if (p_return = false) then
716: fnd_message.set_name('PQP', 'PQP_230244_DUP_RANGE_MAP');
717: fnd_message.raise_error;
718: end if ;
719: --
720: end chk_role_post_mapping;

Line 717: fnd_message.raise_error;

713: , p_value_end => p_pcv_information3
714: , p_return => p_return);
715: if (p_return = false) then
716: fnd_message.set_name('PQP', 'PQP_230244_DUP_RANGE_MAP');
717: fnd_message.raise_error;
718: end if ;
719: --
720: end chk_role_post_mapping;
721:

Line 746: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');

742: , p_information_column => 'PCV_INFORMATION1'
743: , p_value => p_pcv_information1
744: , p_return => p_return);
745: if (p_return = false) then
746: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
747: fnd_message.set_token('Value', 'Pay Scale Value');
748: fnd_message.set_token('DCSF_CODE', 'DCSF Pay Scale Code');
749: fnd_message.raise_error;
750: end if ;

Line 747: fnd_message.set_token('Value', 'Pay Scale Value');

743: , p_value => p_pcv_information1
744: , p_return => p_return);
745: if (p_return = false) then
746: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
747: fnd_message.set_token('Value', 'Pay Scale Value');
748: fnd_message.set_token('DCSF_CODE', 'DCSF Pay Scale Code');
749: fnd_message.raise_error;
750: end if ;
751: --

Line 748: fnd_message.set_token('DCSF_CODE', 'DCSF Pay Scale Code');

744: , p_return => p_return);
745: if (p_return = false) then
746: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
747: fnd_message.set_token('Value', 'Pay Scale Value');
748: fnd_message.set_token('DCSF_CODE', 'DCSF Pay Scale Code');
749: fnd_message.raise_error;
750: end if ;
751: --
752: end chk_payscale_mapping;

Line 749: fnd_message.raise_error;

745: if (p_return = false) then
746: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
747: fnd_message.set_token('Value', 'Pay Scale Value');
748: fnd_message.set_token('DCSF_CODE', 'DCSF Pay Scale Code');
749: fnd_message.raise_error;
750: end if ;
751: --
752: end chk_payscale_mapping;
753:

Line 776: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

772: --
773: -- 1) Grade Flexfield Segment Name must be provided if Grade KFF
774: -- is selected as source
775: if p_pcv_information1 = 'GRD' and p_pcv_information2 is null then
776: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
777: fnd_message.set_token('Field', 'Grade Flexfield Segment Column');
778: fnd_message.set_token('SOURCE', 'Grade Key Flexfield');
779: fnd_message.raise_error;
780: end if ;

Line 777: fnd_message.set_token('Field', 'Grade Flexfield Segment Column');

773: -- 1) Grade Flexfield Segment Name must be provided if Grade KFF
774: -- is selected as source
775: if p_pcv_information1 = 'GRD' and p_pcv_information2 is null then
776: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
777: fnd_message.set_token('Field', 'Grade Flexfield Segment Column');
778: fnd_message.set_token('SOURCE', 'Grade Key Flexfield');
779: fnd_message.raise_error;
780: end if ;
781:

Line 778: fnd_message.set_token('SOURCE', 'Grade Key Flexfield');

774: -- is selected as source
775: if p_pcv_information1 = 'GRD' and p_pcv_information2 is null then
776: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
777: fnd_message.set_token('Field', 'Grade Flexfield Segment Column');
778: fnd_message.set_token('SOURCE', 'Grade Key Flexfield');
779: fnd_message.raise_error;
780: end if ;
781:
782: --

Line 779: fnd_message.raise_error;

775: if p_pcv_information1 = 'GRD' and p_pcv_information2 is null then
776: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
777: fnd_message.set_token('Field', 'Grade Flexfield Segment Column');
778: fnd_message.set_token('SOURCE', 'Grade Key Flexfield');
779: fnd_message.raise_error;
780: end if ;
781:
782: --
783: -- 2) Default Value must be provided if Default is selected as source

Line 785: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

781:
782: --
783: -- 2) Default Value must be provided if Default is selected as source
784: if p_pcv_information1 = 'DEFAULT' and p_pcv_information3 is null then
785: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
786: fnd_message.set_token('Field', 'Default Value');
787: fnd_message.set_token('SOURCE', 'Default');
788: fnd_message.raise_error;
789: end if ;

Line 786: fnd_message.set_token('Field', 'Default Value');

782: --
783: -- 2) Default Value must be provided if Default is selected as source
784: if p_pcv_information1 = 'DEFAULT' and p_pcv_information3 is null then
785: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
786: fnd_message.set_token('Field', 'Default Value');
787: fnd_message.set_token('SOURCE', 'Default');
788: fnd_message.raise_error;
789: end if ;
790: --

Line 787: fnd_message.set_token('SOURCE', 'Default');

783: -- 2) Default Value must be provided if Default is selected as source
784: if p_pcv_information1 = 'DEFAULT' and p_pcv_information3 is null then
785: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
786: fnd_message.set_token('Field', 'Default Value');
787: fnd_message.set_token('SOURCE', 'Default');
788: fnd_message.raise_error;
789: end if ;
790: --
791: end chk_regional_spine_source;

Line 788: fnd_message.raise_error;

784: if p_pcv_information1 = 'DEFAULT' and p_pcv_information3 is null then
785: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
786: fnd_message.set_token('Field', 'Default Value');
787: fnd_message.set_token('SOURCE', 'Default');
788: fnd_message.raise_error;
789: end if ;
790: --
791: end chk_regional_spine_source;
792:

Line 823: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');

819: , p_information_column => 'PCV_INFORMATION1'
820: , p_value => p_pcv_information1
821: , p_return => p_return);
822: if (p_return = false) then
823: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');
824: fnd_message.raise_error;
825: end if ;
826:
827: -- 2) If the user has given seeded Regional Spine lookup name

Line 824: fnd_message.raise_error;

820: , p_value => p_pcv_information1
821: , p_return => p_return);
822: if (p_return = false) then
823: fnd_message.set_name('PQP', 'PQP_230243_USE_SAME_LOOKUP');
824: fnd_message.raise_error;
825: end if ;
826:
827: -- 2) If the user has given seeded Regional Spine lookup name
828: -- Then he should not be required to give the mapping

Line 833: fnd_message.set_name('PQP', 'PQP_230241_ENTER_MAPPING');

829: -- Else Segment Start Value and DCSF Regional Spine Code are mandatory
830:
831: if p_pcv_information1 <> g_REG_SPINE_LOOKUP_NAME then
832: if p_pcv_information2 is null or p_pcv_information4 is null then
833: fnd_message.set_name('PQP', 'PQP_230241_ENTER_MAPPING');
834: fnd_message.set_token('DCSF_CODE', 'DCSF Regional Spine Code');
835: fnd_message.set_token('LOOKUP_NAME', g_REG_SPINE_LOOKUP_NAME);
836: fnd_message.raise_error;
837: end if;

Line 834: fnd_message.set_token('DCSF_CODE', 'DCSF Regional Spine Code');

830:
831: if p_pcv_information1 <> g_REG_SPINE_LOOKUP_NAME then
832: if p_pcv_information2 is null or p_pcv_information4 is null then
833: fnd_message.set_name('PQP', 'PQP_230241_ENTER_MAPPING');
834: fnd_message.set_token('DCSF_CODE', 'DCSF Regional Spine Code');
835: fnd_message.set_token('LOOKUP_NAME', g_REG_SPINE_LOOKUP_NAME);
836: fnd_message.raise_error;
837: end if;
838: end if;

Line 835: fnd_message.set_token('LOOKUP_NAME', g_REG_SPINE_LOOKUP_NAME);

831: if p_pcv_information1 <> g_REG_SPINE_LOOKUP_NAME then
832: if p_pcv_information2 is null or p_pcv_information4 is null then
833: fnd_message.set_name('PQP', 'PQP_230241_ENTER_MAPPING');
834: fnd_message.set_token('DCSF_CODE', 'DCSF Regional Spine Code');
835: fnd_message.set_token('LOOKUP_NAME', g_REG_SPINE_LOOKUP_NAME);
836: fnd_message.raise_error;
837: end if;
838: end if;
839:

Line 836: fnd_message.raise_error;

832: if p_pcv_information2 is null or p_pcv_information4 is null then
833: fnd_message.set_name('PQP', 'PQP_230241_ENTER_MAPPING');
834: fnd_message.set_token('DCSF_CODE', 'DCSF Regional Spine Code');
835: fnd_message.set_token('LOOKUP_NAME', g_REG_SPINE_LOOKUP_NAME);
836: fnd_message.raise_error;
837: end if;
838: end if;
839:
840: -- 3) If Segment End Value is provided

Line 845: fnd_message.set_name('PQP', 'PQP_230242_WRONG_END_VAL');

841: -- Then Segment Start Value should not be less than Segment End Value
842: if p_pcv_information1 <> g_REG_SPINE_LOOKUP_NAME then
843: if p_pcv_information3 is not null then
844: if p_pcv_information3 < p_pcv_information2 then
845: fnd_message.set_name('PQP', 'PQP_230242_WRONG_END_VAL');
846: fnd_message.set_token('TYPE', 'Segment');
847: fnd_message.raise_error;
848: end if;
849: end if ;

Line 846: fnd_message.set_token('TYPE', 'Segment');

842: if p_pcv_information1 <> g_REG_SPINE_LOOKUP_NAME then
843: if p_pcv_information3 is not null then
844: if p_pcv_information3 < p_pcv_information2 then
845: fnd_message.set_name('PQP', 'PQP_230242_WRONG_END_VAL');
846: fnd_message.set_token('TYPE', 'Segment');
847: fnd_message.raise_error;
848: end if;
849: end if ;
850:

Line 847: fnd_message.raise_error;

843: if p_pcv_information3 is not null then
844: if p_pcv_information3 < p_pcv_information2 then
845: fnd_message.set_name('PQP', 'PQP_230242_WRONG_END_VAL');
846: fnd_message.set_token('TYPE', 'Segment');
847: fnd_message.raise_error;
848: end if;
849: end if ;
850:
851:

Line 864: fnd_message.set_name('PQP', 'PQP_230244_DUP_RANGE_MAP');

860: , p_value_start => p_pcv_information2
861: , p_value_end => p_pcv_information3
862: , p_return => p_return);
863: if (p_return = false) then
864: fnd_message.set_name('PQP', 'PQP_230244_DUP_RANGE_MAP');
865: fnd_message.raise_error;
866: end if ;
867: else
868: -- seeded lookup used

Line 865: fnd_message.raise_error;

861: , p_value_end => p_pcv_information3
862: , p_return => p_return);
863: if (p_return = false) then
864: fnd_message.set_name('PQP', 'PQP_230244_DUP_RANGE_MAP');
865: fnd_message.raise_error;
866: end if ;
867: else
868: -- seeded lookup used
869: -- check if there already exists a row with seeded lookup

Line 886: fnd_message.set_name('PQP', 'PQP_230240_DUPLICATE_MAPPING');

882: null ;
883: end;
884:
885: if l_count is not null then
886: fnd_message.set_name('PQP', 'PQP_230240_DUPLICATE_MAPPING');
887: fnd_message.raise_error;
888: end if;
889: end if ;
890: --

Line 887: fnd_message.raise_error;

883: end;
884:
885: if l_count is not null then
886: fnd_message.set_name('PQP', 'PQP_230240_DUPLICATE_MAPPING');
887: fnd_message.raise_error;
888: end if;
889: end if ;
890: --
891: end chk_regional_spine_map_grade ;

Line 916: fnd_message.set_name('PQP', 'PQP_230242_WRONG_END_VAL');

912: -- 1) If Spine Point End Value is provided
913: -- Then Spine Point Start Value should not be less than Spine Point End Value
914: if p_pcv_information3 is not null then
915: if p_pcv_information3 < p_pcv_information2 then
916: fnd_message.set_name('PQP', 'PQP_230242_WRONG_END_VAL');
917: fnd_message.set_token('TYPE', 'Spine Point');
918: fnd_message.raise_error;
919: end if;
920: end if ;

Line 917: fnd_message.set_token('TYPE', 'Spine Point');

913: -- Then Spine Point Start Value should not be less than Spine Point End Value
914: if p_pcv_information3 is not null then
915: if p_pcv_information3 < p_pcv_information2 then
916: fnd_message.set_name('PQP', 'PQP_230242_WRONG_END_VAL');
917: fnd_message.set_token('TYPE', 'Spine Point');
918: fnd_message.raise_error;
919: end if;
920: end if ;
921:

Line 918: fnd_message.raise_error;

914: if p_pcv_information3 is not null then
915: if p_pcv_information3 < p_pcv_information2 then
916: fnd_message.set_name('PQP', 'PQP_230242_WRONG_END_VAL');
917: fnd_message.set_token('TYPE', 'Spine Point');
918: fnd_message.raise_error;
919: end if;
920: end if ;
921:
922: -- 2) While creating multiple configuration records for this oconfiguration type

Line 937: fnd_message.set_name('PQP', 'PQP_230249_DUP_SPINE_MAP');

933: , p_value_end => p_pcv_information3
934: , p_return => p_return);
935:
936: if (p_return = false) then
937: fnd_message.set_name('PQP', 'PQP_230249_DUP_SPINE_MAP');
938: fnd_message.raise_error;
939: end if ;
940: --
941: end chk_regional_spine_map_pyscl ;

Line 938: fnd_message.raise_error;

934: , p_return => p_return);
935:
936: if (p_return = false) then
937: fnd_message.set_name('PQP', 'PQP_230249_DUP_SPINE_MAP');
938: fnd_message.raise_error;
939: end if ;
940: --
941: end chk_regional_spine_map_pyscl ;
942:

Line 969: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');

965: , p_information_column => 'PCV_INFORMATION2'
966: , p_value => p_pcv_information2
967: , p_return => p_return);
968: if (p_return = false) then
969: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
970: fnd_message.set_token('VALUE', 'Spine Point Value');
971: fnd_message.set_token('DCSF_CODE', 'DCSF Spine Point Code');
972: fnd_message.raise_error;
973: end if ;

Line 970: fnd_message.set_token('VALUE', 'Spine Point Value');

966: , p_value => p_pcv_information2
967: , p_return => p_return);
968: if (p_return = false) then
969: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
970: fnd_message.set_token('VALUE', 'Spine Point Value');
971: fnd_message.set_token('DCSF_CODE', 'DCSF Spine Point Code');
972: fnd_message.raise_error;
973: end if ;
974:

Line 971: fnd_message.set_token('DCSF_CODE', 'DCSF Spine Point Code');

967: , p_return => p_return);
968: if (p_return = false) then
969: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
970: fnd_message.set_token('VALUE', 'Spine Point Value');
971: fnd_message.set_token('DCSF_CODE', 'DCSF Spine Point Code');
972: fnd_message.raise_error;
973: end if ;
974:
975: --

Line 972: fnd_message.raise_error;

968: if (p_return = false) then
969: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
970: fnd_message.set_token('VALUE', 'Spine Point Value');
971: fnd_message.set_token('DCSF_CODE', 'DCSF Spine Point Code');
972: fnd_message.raise_error;
973: end if ;
974:
975: --
976: end chk_spine_point_mapping ;

Line 1009: fnd_message.set_name('PQP', 'PQP_230245_USE_SAME_SOURCE');

1005: , p_information_column => 'PCV_INFORMATION1'
1006: , p_value => p_pcv_information1
1007: , p_return => p_return);
1008: if (p_return = false) then
1009: fnd_message.set_name('PQP', 'PQP_230245_USE_SAME_SOURCE');
1010: fnd_message.raise_error;
1011: end if ;
1012:
1013:

Line 1010: fnd_message.raise_error;

1006: , p_value => p_pcv_information1
1007: , p_return => p_return);
1008: if (p_return = false) then
1009: fnd_message.set_name('PQP', 'PQP_230245_USE_SAME_SOURCE');
1010: fnd_message.raise_error;
1011: end if ;
1012:
1013:
1014: -- 2) If Absence Category/Reason is selected as source

Line 1017: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

1013:
1014: -- 2) If Absence Category/Reason is selected as source
1015: -- Then Absence Category/Reason Value must be provided
1016: if p_pcv_information1 = 'ABSENCE_CATEGORY' and p_pcv_information3 is null then
1017: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1018: fnd_message.set_token('FIELD', 'Absence Category/Reason Value');
1019: fnd_message.set_token('SOURCE', 'Absence Category');
1020: fnd_message.raise_error;
1021: elsif p_pcv_information1 = 'ABSENCE_REASON' and p_pcv_information3 is null then

Line 1018: fnd_message.set_token('FIELD', 'Absence Category/Reason Value');

1014: -- 2) If Absence Category/Reason is selected as source
1015: -- Then Absence Category/Reason Value must be provided
1016: if p_pcv_information1 = 'ABSENCE_CATEGORY' and p_pcv_information3 is null then
1017: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1018: fnd_message.set_token('FIELD', 'Absence Category/Reason Value');
1019: fnd_message.set_token('SOURCE', 'Absence Category');
1020: fnd_message.raise_error;
1021: elsif p_pcv_information1 = 'ABSENCE_REASON' and p_pcv_information3 is null then
1022: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

Line 1019: fnd_message.set_token('SOURCE', 'Absence Category');

1015: -- Then Absence Category/Reason Value must be provided
1016: if p_pcv_information1 = 'ABSENCE_CATEGORY' and p_pcv_information3 is null then
1017: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1018: fnd_message.set_token('FIELD', 'Absence Category/Reason Value');
1019: fnd_message.set_token('SOURCE', 'Absence Category');
1020: fnd_message.raise_error;
1021: elsif p_pcv_information1 = 'ABSENCE_REASON' and p_pcv_information3 is null then
1022: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1023: fnd_message.set_token('FIELD', 'Absence Category/Reason Value');

Line 1020: fnd_message.raise_error;

1016: if p_pcv_information1 = 'ABSENCE_CATEGORY' and p_pcv_information3 is null then
1017: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1018: fnd_message.set_token('FIELD', 'Absence Category/Reason Value');
1019: fnd_message.set_token('SOURCE', 'Absence Category');
1020: fnd_message.raise_error;
1021: elsif p_pcv_information1 = 'ABSENCE_REASON' and p_pcv_information3 is null then
1022: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1023: fnd_message.set_token('FIELD', 'Absence Category/Reason Value');
1024: fnd_message.set_token('SOURCE', 'Absence Reason');

Line 1022: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

1018: fnd_message.set_token('FIELD', 'Absence Category/Reason Value');
1019: fnd_message.set_token('SOURCE', 'Absence Category');
1020: fnd_message.raise_error;
1021: elsif p_pcv_information1 = 'ABSENCE_REASON' and p_pcv_information3 is null then
1022: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1023: fnd_message.set_token('FIELD', 'Absence Category/Reason Value');
1024: fnd_message.set_token('SOURCE', 'Absence Reason');
1025: fnd_message.raise_error;
1026: end if ;

Line 1023: fnd_message.set_token('FIELD', 'Absence Category/Reason Value');

1019: fnd_message.set_token('SOURCE', 'Absence Category');
1020: fnd_message.raise_error;
1021: elsif p_pcv_information1 = 'ABSENCE_REASON' and p_pcv_information3 is null then
1022: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1023: fnd_message.set_token('FIELD', 'Absence Category/Reason Value');
1024: fnd_message.set_token('SOURCE', 'Absence Reason');
1025: fnd_message.raise_error;
1026: end if ;
1027:

Line 1024: fnd_message.set_token('SOURCE', 'Absence Reason');

1020: fnd_message.raise_error;
1021: elsif p_pcv_information1 = 'ABSENCE_REASON' and p_pcv_information3 is null then
1022: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1023: fnd_message.set_token('FIELD', 'Absence Category/Reason Value');
1024: fnd_message.set_token('SOURCE', 'Absence Reason');
1025: fnd_message.raise_error;
1026: end if ;
1027:
1028: -- 3) If Absence Type is selected as source

Line 1025: fnd_message.raise_error;

1021: elsif p_pcv_information1 = 'ABSENCE_REASON' and p_pcv_information3 is null then
1022: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1023: fnd_message.set_token('FIELD', 'Absence Category/Reason Value');
1024: fnd_message.set_token('SOURCE', 'Absence Reason');
1025: fnd_message.raise_error;
1026: end if ;
1027:
1028: -- 3) If Absence Type is selected as source
1029: -- Then Absence Type Value must be provided

Line 1031: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

1027:
1028: -- 3) If Absence Type is selected as source
1029: -- Then Absence Type Value must be provided
1030: if p_pcv_information1 = 'ABSENCE_TYPE' and p_pcv_information4 is null then
1031: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1032: fnd_message.set_token('FIELD', 'Absence Type Value');
1033: fnd_message.set_token('SOURCE', 'Absence Type');
1034: fnd_message.raise_error;
1035: end if ;

Line 1032: fnd_message.set_token('FIELD', 'Absence Type Value');

1028: -- 3) If Absence Type is selected as source
1029: -- Then Absence Type Value must be provided
1030: if p_pcv_information1 = 'ABSENCE_TYPE' and p_pcv_information4 is null then
1031: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1032: fnd_message.set_token('FIELD', 'Absence Type Value');
1033: fnd_message.set_token('SOURCE', 'Absence Type');
1034: fnd_message.raise_error;
1035: end if ;
1036:

Line 1033: fnd_message.set_token('SOURCE', 'Absence Type');

1029: -- Then Absence Type Value must be provided
1030: if p_pcv_information1 = 'ABSENCE_TYPE' and p_pcv_information4 is null then
1031: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1032: fnd_message.set_token('FIELD', 'Absence Type Value');
1033: fnd_message.set_token('SOURCE', 'Absence Type');
1034: fnd_message.raise_error;
1035: end if ;
1036:
1037: -- 4) If the given user Absence Category/Type/reason value is already mapped

Line 1034: fnd_message.raise_error;

1030: if p_pcv_information1 = 'ABSENCE_TYPE' and p_pcv_information4 is null then
1031: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1032: fnd_message.set_token('FIELD', 'Absence Type Value');
1033: fnd_message.set_token('SOURCE', 'Absence Type');
1034: fnd_message.raise_error;
1035: end if ;
1036:
1037: -- 4) If the given user Absence Category/Type/reason value is already mapped
1038: -- then user should not be able to map it again

Line 1061: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');

1057: , p_information_column => l_information_column
1058: , p_value => l_value
1059: , p_return => p_return);
1060: if (p_return = false) then
1061: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1062: fnd_message.set_token('VALUE', l_message_token);
1063: fnd_message.set_token('DCSF_CODE', 'DCSF Absence category');
1064: fnd_message.raise_error;
1065: end if ;

Line 1062: fnd_message.set_token('VALUE', l_message_token);

1058: , p_value => l_value
1059: , p_return => p_return);
1060: if (p_return = false) then
1061: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1062: fnd_message.set_token('VALUE', l_message_token);
1063: fnd_message.set_token('DCSF_CODE', 'DCSF Absence category');
1064: fnd_message.raise_error;
1065: end if ;
1066:

Line 1063: fnd_message.set_token('DCSF_CODE', 'DCSF Absence category');

1059: , p_return => p_return);
1060: if (p_return = false) then
1061: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1062: fnd_message.set_token('VALUE', l_message_token);
1063: fnd_message.set_token('DCSF_CODE', 'DCSF Absence category');
1064: fnd_message.raise_error;
1065: end if ;
1066:
1067: --

Line 1064: fnd_message.raise_error;

1060: if (p_return = false) then
1061: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1062: fnd_message.set_token('VALUE', l_message_token);
1063: fnd_message.set_token('DCSF_CODE', 'DCSF Absence category');
1064: fnd_message.raise_error;
1065: end if ;
1066:
1067: --
1068: end chk_absence_code_mapping ;

Line 1100: fnd_message.set_name('PQP', 'PQP_230245_USE_SAME_SOURCE');

1096: , p_information_column => 'PCV_INFORMATION1'
1097: , p_value => p_pcv_information1
1098: , p_return => p_return);
1099: if (p_return = false) then
1100: fnd_message.set_name('PQP', 'PQP_230245_USE_SAME_SOURCE');
1101: fnd_message.raise_error;
1102: end if ;
1103:
1104:

Line 1101: fnd_message.raise_error;

1097: , p_value => p_pcv_information1
1098: , p_return => p_return);
1099: if (p_return = false) then
1100: fnd_message.set_name('PQP', 'PQP_230245_USE_SAME_SOURCE');
1101: fnd_message.raise_error;
1102: end if ;
1103:
1104:
1105: -- 2) If Qualification Category is selected as source

Line 1108: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

1104:
1105: -- 2) If Qualification Category is selected as source
1106: -- Then Qualification Category Value must be provided
1107: if p_pcv_information1 = 'QUALIFICATION_CATEGORY' and p_pcv_information3 is null then
1108: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1109: fnd_message.set_token('FIELD', 'Qualification Category Value');
1110: fnd_message.set_token('SOURCE', 'Qualification Category');
1111: fnd_message.raise_error;
1112: end if ;

Line 1109: fnd_message.set_token('FIELD', 'Qualification Category Value');

1105: -- 2) If Qualification Category is selected as source
1106: -- Then Qualification Category Value must be provided
1107: if p_pcv_information1 = 'QUALIFICATION_CATEGORY' and p_pcv_information3 is null then
1108: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1109: fnd_message.set_token('FIELD', 'Qualification Category Value');
1110: fnd_message.set_token('SOURCE', 'Qualification Category');
1111: fnd_message.raise_error;
1112: end if ;
1113:

Line 1110: fnd_message.set_token('SOURCE', 'Qualification Category');

1106: -- Then Qualification Category Value must be provided
1107: if p_pcv_information1 = 'QUALIFICATION_CATEGORY' and p_pcv_information3 is null then
1108: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1109: fnd_message.set_token('FIELD', 'Qualification Category Value');
1110: fnd_message.set_token('SOURCE', 'Qualification Category');
1111: fnd_message.raise_error;
1112: end if ;
1113:
1114: -- 3) If Qualification Type is selected as source

Line 1111: fnd_message.raise_error;

1107: if p_pcv_information1 = 'QUALIFICATION_CATEGORY' and p_pcv_information3 is null then
1108: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1109: fnd_message.set_token('FIELD', 'Qualification Category Value');
1110: fnd_message.set_token('SOURCE', 'Qualification Category');
1111: fnd_message.raise_error;
1112: end if ;
1113:
1114: -- 3) If Qualification Type is selected as source
1115: -- Then Qualification Type Value must be provided

Line 1117: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

1113:
1114: -- 3) If Qualification Type is selected as source
1115: -- Then Qualification Type Value must be provided
1116: if p_pcv_information1 = 'QUALIFICATION_TYPE' and p_pcv_information4 is null then
1117: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1118: fnd_message.set_token('FIELD', 'Qualification Type Value');
1119: fnd_message.set_token('SOURCE', 'Qualification Type');
1120: fnd_message.raise_error;
1121: end if ;

Line 1118: fnd_message.set_token('FIELD', 'Qualification Type Value');

1114: -- 3) If Qualification Type is selected as source
1115: -- Then Qualification Type Value must be provided
1116: if p_pcv_information1 = 'QUALIFICATION_TYPE' and p_pcv_information4 is null then
1117: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1118: fnd_message.set_token('FIELD', 'Qualification Type Value');
1119: fnd_message.set_token('SOURCE', 'Qualification Type');
1120: fnd_message.raise_error;
1121: end if ;
1122:

Line 1119: fnd_message.set_token('SOURCE', 'Qualification Type');

1115: -- Then Qualification Type Value must be provided
1116: if p_pcv_information1 = 'QUALIFICATION_TYPE' and p_pcv_information4 is null then
1117: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1118: fnd_message.set_token('FIELD', 'Qualification Type Value');
1119: fnd_message.set_token('SOURCE', 'Qualification Type');
1120: fnd_message.raise_error;
1121: end if ;
1122:
1123: -- 4) If the given user Qualification Category/Type value is already mapped

Line 1120: fnd_message.raise_error;

1116: if p_pcv_information1 = 'QUALIFICATION_TYPE' and p_pcv_information4 is null then
1117: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1118: fnd_message.set_token('FIELD', 'Qualification Type Value');
1119: fnd_message.set_token('SOURCE', 'Qualification Type');
1120: fnd_message.raise_error;
1121: end if ;
1122:
1123: -- 4) If the given user Qualification Category/Type value is already mapped
1124: -- then user should not be able to map it again

Line 1143: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');

1139: , p_information_column => l_information_column
1140: , p_value => l_value
1141: , p_return => p_return);
1142: if (p_return = false) then
1143: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1144: fnd_message.set_token('VALUE', l_message_token);
1145: fnd_message.set_token('DCSF_CODE', 'DCSF Qualification Code');
1146: fnd_message.raise_error;
1147: end if ;

Line 1144: fnd_message.set_token('VALUE', l_message_token);

1140: , p_value => l_value
1141: , p_return => p_return);
1142: if (p_return = false) then
1143: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1144: fnd_message.set_token('VALUE', l_message_token);
1145: fnd_message.set_token('DCSF_CODE', 'DCSF Qualification Code');
1146: fnd_message.raise_error;
1147: end if ;
1148:

Line 1145: fnd_message.set_token('DCSF_CODE', 'DCSF Qualification Code');

1141: , p_return => p_return);
1142: if (p_return = false) then
1143: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1144: fnd_message.set_token('VALUE', l_message_token);
1145: fnd_message.set_token('DCSF_CODE', 'DCSF Qualification Code');
1146: fnd_message.raise_error;
1147: end if ;
1148:
1149: --

Line 1146: fnd_message.raise_error;

1142: if (p_return = false) then
1143: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1144: fnd_message.set_token('VALUE', l_message_token);
1145: fnd_message.set_token('DCSF_CODE', 'DCSF Qualification Code');
1146: fnd_message.raise_error;
1147: end if ;
1148:
1149: --
1150: end chk_qualification_code_map ;

Line 1174: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');

1170: , p_information_column => 'PCV_INFORMATION1'
1171: , p_value => p_pcv_information1
1172: , p_return => p_return);
1173: if (p_return = false) then
1174: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1175: fnd_message.set_token('VALUE', 'Subject Code');
1176: fnd_message.set_token('DCSF_CODE', 'DCSF Subject Code');
1177: fnd_message.raise_error;
1178: end if ;

Line 1175: fnd_message.set_token('VALUE', 'Subject Code');

1171: , p_value => p_pcv_information1
1172: , p_return => p_return);
1173: if (p_return = false) then
1174: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1175: fnd_message.set_token('VALUE', 'Subject Code');
1176: fnd_message.set_token('DCSF_CODE', 'DCSF Subject Code');
1177: fnd_message.raise_error;
1178: end if ;
1179: --

Line 1176: fnd_message.set_token('DCSF_CODE', 'DCSF Subject Code');

1172: , p_return => p_return);
1173: if (p_return = false) then
1174: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1175: fnd_message.set_token('VALUE', 'Subject Code');
1176: fnd_message.set_token('DCSF_CODE', 'DCSF Subject Code');
1177: fnd_message.raise_error;
1178: end if ;
1179: --
1180: end chk_subject_code_map ;

Line 1177: fnd_message.raise_error;

1173: if (p_return = false) then
1174: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1175: fnd_message.set_token('VALUE', 'Subject Code');
1176: fnd_message.set_token('DCSF_CODE', 'DCSF Subject Code');
1177: fnd_message.raise_error;
1178: end if ;
1179: --
1180: end chk_subject_code_map ;
1181:

Line 1215: fnd_message.set_name('PQP', 'PQP_230245_USE_SAME_SOURCE');

1211: , p_information_column => 'PCV_INFORMATION1'
1212: , p_value => p_pcv_information1
1213: , p_return => p_return);
1214: if (p_return = false) then
1215: fnd_message.set_name('PQP', 'PQP_230245_USE_SAME_SOURCE');
1216: fnd_message.raise_error;
1217: end if ;
1218:
1219: -- 2) Check for mandatory columns as per selected source columns

Line 1216: fnd_message.raise_error;

1212: , p_value => p_pcv_information1
1213: , p_return => p_return);
1214: if (p_return = false) then
1215: fnd_message.set_name('PQP', 'PQP_230245_USE_SAME_SOURCE');
1216: fnd_message.raise_error;
1217: end if ;
1218:
1219: -- 2) Check for mandatory columns as per selected source columns
1220: if p_pcv_information1 = 'CONTRACT_TYPE' then

Line 1222: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

1218:
1219: -- 2) Check for mandatory columns as per selected source columns
1220: if p_pcv_information1 = 'CONTRACT_TYPE' then
1221: if p_pcv_information3 is null then
1222: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1223: fnd_message.set_token('FIELD', 'Hours Per Week formula name');
1224: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1225: fnd_message.raise_error;
1226: elsif p_pcv_information4 is null then

Line 1223: fnd_message.set_token('FIELD', 'Hours Per Week formula name');

1219: -- 2) Check for mandatory columns as per selected source columns
1220: if p_pcv_information1 = 'CONTRACT_TYPE' then
1221: if p_pcv_information3 is null then
1222: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1223: fnd_message.set_token('FIELD', 'Hours Per Week formula name');
1224: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1225: fnd_message.raise_error;
1226: elsif p_pcv_information4 is null then
1227: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

Line 1224: fnd_message.set_token('SOURCE', 'PQP Contract Type');

1220: if p_pcv_information1 = 'CONTRACT_TYPE' then
1221: if p_pcv_information3 is null then
1222: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1223: fnd_message.set_token('FIELD', 'Hours Per Week formula name');
1224: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1225: fnd_message.raise_error;
1226: elsif p_pcv_information4 is null then
1227: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1228: fnd_message.set_token('FIELD', 'Weeks Per Year source');

Line 1225: fnd_message.raise_error;

1221: if p_pcv_information3 is null then
1222: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1223: fnd_message.set_token('FIELD', 'Hours Per Week formula name');
1224: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1225: fnd_message.raise_error;
1226: elsif p_pcv_information4 is null then
1227: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1228: fnd_message.set_token('FIELD', 'Weeks Per Year source');
1229: fnd_message.set_token('SOURCE', 'PQP Contract Type');

Line 1227: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

1223: fnd_message.set_token('FIELD', 'Hours Per Week formula name');
1224: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1225: fnd_message.raise_error;
1226: elsif p_pcv_information4 is null then
1227: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1228: fnd_message.set_token('FIELD', 'Weeks Per Year source');
1229: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1230: fnd_message.raise_error;
1231: end if;

Line 1228: fnd_message.set_token('FIELD', 'Weeks Per Year source');

1224: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1225: fnd_message.raise_error;
1226: elsif p_pcv_information4 is null then
1227: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1228: fnd_message.set_token('FIELD', 'Weeks Per Year source');
1229: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1230: fnd_message.raise_error;
1231: end if;
1232:

Line 1229: fnd_message.set_token('SOURCE', 'PQP Contract Type');

1225: fnd_message.raise_error;
1226: elsif p_pcv_information4 is null then
1227: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1228: fnd_message.set_token('FIELD', 'Weeks Per Year source');
1229: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1230: fnd_message.raise_error;
1231: end if;
1232:
1233: if p_pcv_information4 = 'FORMULA' then

Line 1230: fnd_message.raise_error;

1226: elsif p_pcv_information4 is null then
1227: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1228: fnd_message.set_token('FIELD', 'Weeks Per Year source');
1229: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1230: fnd_message.raise_error;
1231: end if;
1232:
1233: if p_pcv_information4 = 'FORMULA' then
1234: if p_pcv_information5 is null then

Line 1235: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

1231: end if;
1232:
1233: if p_pcv_information4 = 'FORMULA' then
1234: if p_pcv_information5 is null then
1235: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1236: fnd_message.set_token('FIELD', 'Weeks Per Year formula name');
1237: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1238: fnd_message.raise_error;
1239: end if;

Line 1236: fnd_message.set_token('FIELD', 'Weeks Per Year formula name');

1232:
1233: if p_pcv_information4 = 'FORMULA' then
1234: if p_pcv_information5 is null then
1235: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1236: fnd_message.set_token('FIELD', 'Weeks Per Year formula name');
1237: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1238: fnd_message.raise_error;
1239: end if;
1240: else

Line 1237: fnd_message.set_token('SOURCE', 'PQP Contract Type');

1233: if p_pcv_information4 = 'FORMULA' then
1234: if p_pcv_information5 is null then
1235: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1236: fnd_message.set_token('FIELD', 'Weeks Per Year formula name');
1237: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1238: fnd_message.raise_error;
1239: end if;
1240: else
1241: if p_pcv_information6 is null then

Line 1238: fnd_message.raise_error;

1234: if p_pcv_information5 is null then
1235: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1236: fnd_message.set_token('FIELD', 'Weeks Per Year formula name');
1237: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1238: fnd_message.raise_error;
1239: end if;
1240: else
1241: if p_pcv_information6 is null then
1242: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

Line 1242: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

1238: fnd_message.raise_error;
1239: end if;
1240: else
1241: if p_pcv_information6 is null then
1242: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1243: fnd_message.set_token('FIELD', 'Weeks Per Year column name');
1244: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1245: fnd_message.raise_error;
1246: end if ;

Line 1243: fnd_message.set_token('FIELD', 'Weeks Per Year column name');

1239: end if;
1240: else
1241: if p_pcv_information6 is null then
1242: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1243: fnd_message.set_token('FIELD', 'Weeks Per Year column name');
1244: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1245: fnd_message.raise_error;
1246: end if ;
1247: end if ;

Line 1244: fnd_message.set_token('SOURCE', 'PQP Contract Type');

1240: else
1241: if p_pcv_information6 is null then
1242: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1243: fnd_message.set_token('FIELD', 'Weeks Per Year column name');
1244: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1245: fnd_message.raise_error;
1246: end if ;
1247: end if ;
1248: elsif p_pcv_information1 = 'ASG' then

Line 1245: fnd_message.raise_error;

1241: if p_pcv_information6 is null then
1242: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1243: fnd_message.set_token('FIELD', 'Weeks Per Year column name');
1244: fnd_message.set_token('SOURCE', 'PQP Contract Type');
1245: fnd_message.raise_error;
1246: end if ;
1247: end if ;
1248: elsif p_pcv_information1 = 'ASG' then
1249: if p_pcv_information7 is null then

Line 1250: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

1246: end if ;
1247: end if ;
1248: elsif p_pcv_information1 = 'ASG' then
1249: if p_pcv_information7 is null then
1250: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1251: fnd_message.set_token('FIELD', 'Staff Category');
1252: fnd_message.set_token('SOURCE', 'Assignment Hours');
1253: fnd_message.raise_error;
1254: elsif p_pcv_information8 is null then

Line 1251: fnd_message.set_token('FIELD', 'Staff Category');

1247: end if ;
1248: elsif p_pcv_information1 = 'ASG' then
1249: if p_pcv_information7 is null then
1250: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1251: fnd_message.set_token('FIELD', 'Staff Category');
1252: fnd_message.set_token('SOURCE', 'Assignment Hours');
1253: fnd_message.raise_error;
1254: elsif p_pcv_information8 is null then
1255: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

Line 1252: fnd_message.set_token('SOURCE', 'Assignment Hours');

1248: elsif p_pcv_information1 = 'ASG' then
1249: if p_pcv_information7 is null then
1250: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1251: fnd_message.set_token('FIELD', 'Staff Category');
1252: fnd_message.set_token('SOURCE', 'Assignment Hours');
1253: fnd_message.raise_error;
1254: elsif p_pcv_information8 is null then
1255: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1256: fnd_message.set_token('FIELD', 'Default Weeks Per Year');

Line 1253: fnd_message.raise_error;

1249: if p_pcv_information7 is null then
1250: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1251: fnd_message.set_token('FIELD', 'Staff Category');
1252: fnd_message.set_token('SOURCE', 'Assignment Hours');
1253: fnd_message.raise_error;
1254: elsif p_pcv_information8 is null then
1255: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1256: fnd_message.set_token('FIELD', 'Default Weeks Per Year');
1257: fnd_message.set_token('SOURCE', 'Assignment Hours');

Line 1255: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

1251: fnd_message.set_token('FIELD', 'Staff Category');
1252: fnd_message.set_token('SOURCE', 'Assignment Hours');
1253: fnd_message.raise_error;
1254: elsif p_pcv_information8 is null then
1255: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1256: fnd_message.set_token('FIELD', 'Default Weeks Per Year');
1257: fnd_message.set_token('SOURCE', 'Assignment Hours');
1258: fnd_message.raise_error;
1259: end if;

Line 1256: fnd_message.set_token('FIELD', 'Default Weeks Per Year');

1252: fnd_message.set_token('SOURCE', 'Assignment Hours');
1253: fnd_message.raise_error;
1254: elsif p_pcv_information8 is null then
1255: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1256: fnd_message.set_token('FIELD', 'Default Weeks Per Year');
1257: fnd_message.set_token('SOURCE', 'Assignment Hours');
1258: fnd_message.raise_error;
1259: end if;
1260: end if ;

Line 1257: fnd_message.set_token('SOURCE', 'Assignment Hours');

1253: fnd_message.raise_error;
1254: elsif p_pcv_information8 is null then
1255: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1256: fnd_message.set_token('FIELD', 'Default Weeks Per Year');
1257: fnd_message.set_token('SOURCE', 'Assignment Hours');
1258: fnd_message.raise_error;
1259: end if;
1260: end if ;
1261:

Line 1258: fnd_message.raise_error;

1254: elsif p_pcv_information8 is null then
1255: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1256: fnd_message.set_token('FIELD', 'Default Weeks Per Year');
1257: fnd_message.set_token('SOURCE', 'Assignment Hours');
1258: fnd_message.raise_error;
1259: end if;
1260: end if ;
1261:
1262: -- 3) When source is PQP Contract Types, then user should not be able to map

Line 1273: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');

1269: , p_information_column => 'PCV_INFORMATION2'
1270: , p_value => p_pcv_information2
1271: , p_return => p_return);
1272: if (p_return = false) then
1273: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1274: fnd_message.set_token('VALUE', 'Contract Type');
1275: fnd_message.set_token('DCSF_CODE', 'PQP_CONTRACT_TYPES UDT Column Name');
1276: fnd_message.raise_error;
1277: end if ;

Line 1274: fnd_message.set_token('VALUE', 'Contract Type');

1270: , p_value => p_pcv_information2
1271: , p_return => p_return);
1272: if (p_return = false) then
1273: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1274: fnd_message.set_token('VALUE', 'Contract Type');
1275: fnd_message.set_token('DCSF_CODE', 'PQP_CONTRACT_TYPES UDT Column Name');
1276: fnd_message.raise_error;
1277: end if ;
1278: end if ;

Line 1275: fnd_message.set_token('DCSF_CODE', 'PQP_CONTRACT_TYPES UDT Column Name');

1271: , p_return => p_return);
1272: if (p_return = false) then
1273: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1274: fnd_message.set_token('VALUE', 'Contract Type');
1275: fnd_message.set_token('DCSF_CODE', 'PQP_CONTRACT_TYPES UDT Column Name');
1276: fnd_message.raise_error;
1277: end if ;
1278: end if ;
1279:

Line 1276: fnd_message.raise_error;

1272: if (p_return = false) then
1273: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1274: fnd_message.set_token('VALUE', 'Contract Type');
1275: fnd_message.set_token('DCSF_CODE', 'PQP_CONTRACT_TYPES UDT Column Name');
1276: fnd_message.raise_error;
1277: end if ;
1278: end if ;
1279:
1280: -- 4) When source is Assignment Hours, then user should not be able to map

Line 1290: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');

1286: , p_information_column => 'PCV_INFORMATION7'
1287: , p_value => p_pcv_information7
1288: , p_return => p_return);
1289: if (p_return = false) then
1290: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1291: fnd_message.set_token('VALUE', 'Staff Category');
1292: fnd_message.set_token('DCSF_CODE', 'Default Weeks Per Year Value');
1293: fnd_message.raise_error;
1294: end if ;

Line 1291: fnd_message.set_token('VALUE', 'Staff Category');

1287: , p_value => p_pcv_information7
1288: , p_return => p_return);
1289: if (p_return = false) then
1290: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1291: fnd_message.set_token('VALUE', 'Staff Category');
1292: fnd_message.set_token('DCSF_CODE', 'Default Weeks Per Year Value');
1293: fnd_message.raise_error;
1294: end if ;
1295: end chk_hours;

Line 1292: fnd_message.set_token('DCSF_CODE', 'Default Weeks Per Year Value');

1288: , p_return => p_return);
1289: if (p_return = false) then
1290: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1291: fnd_message.set_token('VALUE', 'Staff Category');
1292: fnd_message.set_token('DCSF_CODE', 'Default Weeks Per Year Value');
1293: fnd_message.raise_error;
1294: end if ;
1295: end chk_hours;
1296:

Line 1293: fnd_message.raise_error;

1289: if (p_return = false) then
1290: fnd_message.set_name('PQP', 'PQP_230239_DUPLICATE_MAPPING');
1291: fnd_message.set_token('VALUE', 'Staff Category');
1292: fnd_message.set_token('DCSF_CODE', 'Default Weeks Per Year Value');
1293: fnd_message.raise_error;
1294: end if ;
1295: end chk_hours;
1296:
1297:

Line 1311: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');

1307: , p_pcv_information2 in varchar2
1308: ) as
1309: begin
1310: if p_pcv_information1 = 'CAL' and p_pcv_information2 is null then
1311: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1312: fnd_message.set_token('FIELD', 'User Formula Name');
1313: fnd_message.set_token('SOURCE', 'Calculated');
1314: fnd_message.raise_error;
1315: end if ;

Line 1312: fnd_message.set_token('FIELD', 'User Formula Name');

1308: ) as
1309: begin
1310: if p_pcv_information1 = 'CAL' and p_pcv_information2 is null then
1311: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1312: fnd_message.set_token('FIELD', 'User Formula Name');
1313: fnd_message.set_token('SOURCE', 'Calculated');
1314: fnd_message.raise_error;
1315: end if ;
1316: --

Line 1313: fnd_message.set_token('SOURCE', 'Calculated');

1309: begin
1310: if p_pcv_information1 = 'CAL' and p_pcv_information2 is null then
1311: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1312: fnd_message.set_token('FIELD', 'User Formula Name');
1313: fnd_message.set_token('SOURCE', 'Calculated');
1314: fnd_message.raise_error;
1315: end if ;
1316: --
1317: end chk_fte_hours;

Line 1314: fnd_message.raise_error;

1310: if p_pcv_information1 = 'CAL' and p_pcv_information2 is null then
1311: fnd_message.set_name('PQP', 'PQP_230238_FIELD_MANDATORY');
1312: fnd_message.set_token('FIELD', 'User Formula Name');
1313: fnd_message.set_token('SOURCE', 'Calculated');
1314: fnd_message.raise_error;
1315: end if ;
1316: --
1317: end chk_fte_hours;
1318: --