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.PQH_CORPS_EXTRA_INFO_API dependencies on HR_MULTI_MESSAGE

Line 39: hr_multi_message.add(p_associated_column1 => 'INFORMATION3');

35: FETCH csr_chk_valid_org INTO l_valid_org;
36: CLOSE csr_chk_valid_org;
37: IF l_valid_org = 'N' THEN
38: hr_utility.set_message(8302,'PQH_FR_INVALID_ORG_FOR_CORPS');
39: hr_multi_message.add(p_associated_column1 => 'INFORMATION3');
40: END IF;
41: OPEN csr_dup_org_chk;
42: FETCH csr_dup_org_chk INTO l_dup_org;
43: CLOSE csr_dup_org_chk;

Line 46: hr_multi_message.add(p_associated_column1 => 'INFORMATION3');

42: FETCH csr_dup_org_chk INTO l_dup_org;
43: CLOSE csr_dup_org_chk;
44: IF l_dup_org = 'Y' THEN
45: hr_utility.set_message(8302,'PQH_FR_DUP_ORG_FOR_CORPS');
46: hr_multi_message.add(p_associated_column1 => 'INFORMATION3');
47: END IF;
48: END IF;
49: hr_utility.set_location('Leaving '||l_proc,20);
50: END validate_corps_org_info;

Line 84: hr_multi_message.add(p_associated_column1 => 'INFORMATION3');

80: FETCH csr_chk_valid_prof_field INTO l_valid_prof_field;
81: CLOSE csr_chk_valid_prof_field;
82: IF l_valid_prof_field = 'N' THEN
83: hr_utility.set_message(8302,'PQH_FR_INVALID_FIELD_OF_PROF');
84: hr_multi_message.add(p_associated_column1 => 'INFORMATION3');
85: END IF;
86: OPEN csr_dup_prof_field_chk;
87: FETCH csr_dup_prof_field_chk INTO l_dup_prof_field;
88: CLOSE csr_dup_prof_field_chk;

Line 91: hr_multi_message.add(p_associated_column1 => 'INFORMATION3');

87: FETCH csr_dup_prof_field_chk INTO l_dup_prof_field;
88: CLOSE csr_dup_prof_field_chk;
89: IF l_dup_prof_field = 'Y' THEN
90: hr_utility.set_message(8302,'PQH_FR_DUP_FIELD_OF_PROF');
91: hr_multi_message.add(p_associated_column1 => 'INFORMATION3');
92: END IF;
93: END IF;
94: hr_utility.set_location('Leaving '||l_proc,20);
95: END validate_corps_prof_field_info;

Line 134: hr_multi_message.add(p_associated_column1 => 'INFORMATION3');

130: hr_utility.set_location('Entering '||l_proc,10);
131: IF p_examination_type_cd IS NOT NULL THEN
132: IF hr_api.not_exists_in_hr_lookups(p_effective_date,'PQH_CORPS_EXAM_TYPE',p_examination_type_cd) THEN
133: hr_utility.set_message(8302,'PQH_FR_INVALID_EXAM_TYPE');
134: hr_multi_message.add(p_associated_column1 => 'INFORMATION3');
135: END IF;
136: END IF;
137: IF p_institution_id IS NOT NULL THEN
138: OPEN csr_valid_institution;

Line 143: hr_multi_message.add(p_associated_column1 => 'INFORMATION4');

139: FETCH csr_valid_institution INTO l_valid_institution;
140: CLOSE csr_valid_institution;
141: IF l_valid_institution = 'N' THEN
142: hr_utility.set_message(8302,'PQH_FR_INVALID_INSTITUTION');
143: hr_multi_message.add(p_associated_column1 => 'INFORMATION4');
144: END IF;
145: END IF;
146: IF p_joining_way_cd IS NOT NULL THEN
147: IF hr_api.not_exists_in_hr_lookups(p_effective_date,'PQH_CORPS_WAYS',p_joining_way_cd) THEN

Line 149: hr_multi_message.add(p_associated_column1 => 'INFORMATION5');

145: END IF;
146: IF p_joining_way_cd IS NOT NULL THEN
147: IF hr_api.not_exists_in_hr_lookups(p_effective_date,'PQH_CORPS_WAYS',p_joining_way_cd) THEN
148: hr_utility.set_message(8302,'PQH_FR_INVALID_WAY_FOR_CORPS');
149: hr_multi_message.add(p_associated_column1 => 'INFORMATION5');
150: END IF;
151: END IF;
152: hr_multi_message.end_validation_set;
153: OPEN csr_chk_dup_exam;

Line 152: hr_multi_message.end_validation_set;

148: hr_utility.set_message(8302,'PQH_FR_INVALID_WAY_FOR_CORPS');
149: hr_multi_message.add(p_associated_column1 => 'INFORMATION5');
150: END IF;
151: END IF;
152: hr_multi_message.end_validation_set;
153: OPEN csr_chk_dup_exam;
154: FETCH csr_chk_dup_exam INTO l_dup_exam;
155: CLOSE csr_chk_dup_exam;
156: IF l_dup_exam = 'Y' THEN

Line 158: hr_multi_message.add;

154: FETCH csr_chk_dup_exam INTO l_dup_exam;
155: CLOSE csr_chk_dup_exam;
156: IF l_dup_exam = 'Y' THEN
157: hr_utility.set_message(8302,'PQH_FR_DUP_EXAM_FOR_CORPS');
158: hr_multi_message.add;
159: END IF;
160: hr_utility.set_location('Leaving '||l_proc,20);
161: END validate_corps_exam_info;
162:

Line 214: hr_multi_message.add(p_associated_column1 => 'INFORMATION3');

210: FETCH csr_valid_qualification INTO l_valid_qualification;
211: CLOSE csr_valid_qualification;
212: IF l_valid_qualification = 'N' THEN
213: hr_utility.set_message(8302,'PQH_FR_INVALID_QUALIFICATION');
214: hr_multi_message.add(p_associated_column1 => 'INFORMATION3');
215: END IF;
216: END IF;
217: IF p_institution_id IS NOT NULL THEN
218: OPEN csr_valid_institution;

Line 223: hr_multi_message.add(p_associated_column1 => 'INFORMATION4');

219: FETCH csr_valid_institution INTO l_valid_institution;
220: CLOSE csr_valid_institution;
221: IF l_valid_institution = 'N' THEN
222: hr_utility.set_message(8302,'PQH_FR_INVALID_INSTITUTION');
223: hr_multi_message.add(p_associated_column1 => 'INFORMATION4');
224: END IF;
225: END IF;
226: -- Added validation for training duration ( +ve value )
227: IF p_training_duration IS NOT NULL THEN

Line 232: hr_multi_message.add(p_associated_column1 => 'INFORMATION5');

228: -- Added = for bug fix 3344339
229: if (p_training_duration <= 0) then
230: --
231: hr_utility.set_message(8302,'PQH_FR_INVALID_DURATION');
232: hr_multi_message.add(p_associated_column1 => 'INFORMATION5');
233: --
234: end if;
235: --
236: End if;

Line 241: hr_multi_message.add(p_associated_column1 => 'INFORMATION6');

237:
238: IF p_training_duration_uom IS NOT NULL THEN
239: IF hr_api.not_exists_in_hr_lookups(p_effective_date,'FREQUENCY',p_training_duration_uom) THEN
240: hr_utility.set_message(8302,'PQH_FR_INVALID_DURATION_UNITS');
241: hr_multi_message.add(p_associated_column1 => 'INFORMATION6');
242: END IF;
243: END IF;
244: IF p_joining_way_cd IS NOT NULL THEN
245: IF hr_api.not_exists_in_hr_lookups(p_effective_date,'PQH_CORPS_WAYS',p_joining_way_cd) THEN

Line 247: hr_multi_message.add(p_associated_column1 => 'INFORMATION7');

243: END IF;
244: IF p_joining_way_cd IS NOT NULL THEN
245: IF hr_api.not_exists_in_hr_lookups(p_effective_date,'PQH_CORPS_WAYS',p_joining_way_cd) THEN
246: hr_utility.set_message(8302,'PQH_FR_INVALID_WAY_FOR_CORPS');
247: hr_multi_message.add(p_associated_column1 => 'INFORMATION7');
248: END IF;
249: END IF;
250: hr_multi_message.end_validation_set;
251: OPEN csr_dup_train_dtls ;

Line 250: hr_multi_message.end_validation_set;

246: hr_utility.set_message(8302,'PQH_FR_INVALID_WAY_FOR_CORPS');
247: hr_multi_message.add(p_associated_column1 => 'INFORMATION7');
248: END IF;
249: END IF;
250: hr_multi_message.end_validation_set;
251: OPEN csr_dup_train_dtls ;
252: FETCH csr_dup_train_dtls INTO l_dup_train_dtls ;
253: CLOSE csr_dup_train_dtls ;
254: IF l_dup_train_dtls = 'Y' THEN

Line 256: hr_multi_message.add;

252: FETCH csr_dup_train_dtls INTO l_dup_train_dtls ;
253: CLOSE csr_dup_train_dtls ;
254: IF l_dup_train_dtls = 'Y' THEN
255: hr_utility.set_message(8302,'PQH_FR_DUP_TRAINING_FOR_CORPS');
256: hr_multi_message.add;
257: END IF;
258: hr_utility.set_location('Leaving '||l_proc,20);
259: END validate_corps_training_info;
260:

Line 285: hr_multi_message.add;

281: FETCH csr_prim_field_for_corps INTO l_primary_flag;
282: CLOSE csr_prim_field_for_corps;
283: IF l_primary_flag = 'Y' THEN
284: hr_utility.set_message(8302,'PQH_FR_CANNOT_DEL_PRIM_FIELD');
285: hr_multi_message.add;
286: END IF;
287: hr_utility.set_location('Leaving '||l_proc,20);
288: END chk_prim_field_for_corps;
289:

Line 585: hr_multi_message.end_validation_set;

581: ,p_training_duration_uom => p_information6
582: ,p_joining_way_cd => p_information7
583: ,p_mandatory_flag => p_information8);
584: END IF;
585: hr_multi_message.end_validation_set;
586: --
587: --
588: pqh_cei_ins.ins
589: (

Line 1086: hr_multi_message.end_validation_set;

1082: ,p_joining_way_cd => p_information7
1083: ,p_mandatory_flag => p_information8
1084: ,p_corps_extra_info_id => p_corps_extra_info_id);
1085: END IF;
1086: hr_multi_message.end_validation_set;
1087: --
1088: --
1089: pqh_cei_upd.upd
1090: (

Line 1365: hr_multi_message.end_validation_set;

1361: --
1362: -- Validation in addition to Row Handlers
1363: --
1364: chk_prim_field_for_corps(p_corps_extra_info_id => p_corps_extra_info_id);
1365: hr_multi_message.end_validation_set;
1366: --
1367: PQH_CEI_del.del
1368: (
1369: p_corps_extra_info_id => p_corps_extra_info_id