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_UTILITY

Line 32: hr_utility.set_location('Entering '||l_proc,10);

28: corps_extra_info_id <> p_corps_extra_info_id) );
29: l_dup_org varchar2(10) := 'N';
30: l_proc varchar2(72) := g_package||'.validate_corps_org_info';
31: BEGIN
32: hr_utility.set_location('Entering '||l_proc,10);
33: IF p_organization_id IS NOT NULL THEN
34: OPEN csr_chk_valid_org;
35: FETCH csr_chk_valid_org INTO l_valid_org;
36: CLOSE csr_chk_valid_org;

Line 38: hr_utility.set_message(8302,'PQH_FR_INVALID_ORG_FOR_CORPS');

34: OPEN csr_chk_valid_org;
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;

Line 45: hr_utility.set_message(8302,'PQH_FR_DUP_ORG_FOR_CORPS');

41: OPEN csr_dup_org_chk;
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);

Line 49: hr_utility.set_location('Leaving '||l_proc,20);

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;
51: ------------------------------------------------------------------------------
52: -- |------------------------------------------------|
53: -- ----------------------------------------------------------------------------

Line 77: hr_utility.set_location('Entering '||l_proc,10);

73: AND information3 = p_field_of_prof_activity_id
74: AND (p_corps_extra_info_id IS NULL OR corps_extra_info_id <> p_corps_extra_info_id));
75: l_dup_prof_field varchar2(10) := 'N';
76: BEGIN
77: hr_utility.set_location('Entering '||l_proc,10);
78: IF p_field_of_prof_activity_id IS NOT NULL THEN
79: OPEN csr_chk_valid_prof_field;
80: FETCH csr_chk_valid_prof_field INTO l_valid_prof_field;
81: CLOSE csr_chk_valid_prof_field;

Line 83: hr_utility.set_message(8302,'PQH_FR_INVALID_FIELD_OF_PROF');

79: OPEN csr_chk_valid_prof_field;
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;

Line 90: hr_utility.set_message(8302,'PQH_FR_DUP_FIELD_OF_PROF');

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;
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);

Line 94: hr_utility.set_location('Leaving '||l_proc,20);

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;
96: ------------------------------------------------------------------------------
97: -- |------------------------------------------------|
98: -- ----------------------------------------------------------------------------

Line 130: hr_utility.set_location('Entering '||l_proc,10);

126: AND (p_corps_extra_info_id IS NULL OR corps_extra_info_id <> p_corps_extra_info_id));
127: l_dup_exam varchar2(10) := 'N';
128: l_proc varchar2(72) := g_package||'.validate_corps_exam_info';
129: BEGIN
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');

Line 133: hr_utility.set_message(8302,'PQH_FR_INVALID_EXAM_TYPE');

129: BEGIN
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

Line 142: hr_utility.set_message(8302,'PQH_FR_INVALID_INSTITUTION');

138: OPEN csr_valid_institution;
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

Line 148: hr_utility.set_message(8302,'PQH_FR_INVALID_WAY_FOR_CORPS');

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
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;

Line 157: hr_utility.set_message(8302,'PQH_FR_DUP_EXAM_FOR_CORPS');

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
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;

Line 160: hr_utility.set_location('Leaving '||l_proc,20);

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:
163: ------------------------------------------------------------------------------
164: -- |------------------------------------------------|

Line 207: hr_utility.set_location('Entering '||l_proc,10);

203: corps_extra_info_id <> p_corps_extra_info_id) );
204: l_dup_train_dtls varchar2(10) := 'N';
205: l_proc varchar2(72) := g_package||'.validate_corps_training_info';
206: BEGIN
207: hr_utility.set_location('Entering '||l_proc,10);
208: IF p_qualification_id IS NOT NULL THEN
209: OPEN csr_valid_qualification;
210: FETCH csr_valid_qualification INTO l_valid_qualification;
211: CLOSE csr_valid_qualification;

Line 213: hr_utility.set_message(8302,'PQH_FR_INVALID_QUALIFICATION');

209: OPEN csr_valid_qualification;
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

Line 222: hr_utility.set_message(8302,'PQH_FR_INVALID_INSTITUTION');

218: OPEN csr_valid_institution;
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 )

Line 231: hr_utility.set_message(8302,'PQH_FR_INVALID_DURATION');

227: IF p_training_duration IS NOT NULL THEN
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: --

Line 240: hr_utility.set_message(8302,'PQH_FR_INVALID_DURATION_UNITS');

236: End if;
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

Line 246: hr_utility.set_message(8302,'PQH_FR_INVALID_WAY_FOR_CORPS');

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
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;

Line 255: hr_utility.set_message(8302,'PQH_FR_DUP_TRAINING_FOR_CORPS');

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
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;

Line 258: hr_utility.set_location('Leaving '||l_proc,20);

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:
261:
262: ------------------------------------------------------------------------------

Line 279: hr_utility.set_location('Entering '||l_proc,10);

275: AND corps_extra_info_id = p_corps_extra_info_id);
276: l_primary_flag varchar2(10) := 'N';
277: l_proc varchar2(72) := g_package||'.chk_prim_field_for_corps';
278: BEGIN
279: hr_utility.set_location('Entering '||l_proc,10);
280: OPEN csr_prim_field_for_corps;
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

Line 284: hr_utility.set_message(8302,'PQH_FR_CANNOT_DEL_PRIM_FIELD');

280: OPEN csr_prim_field_for_corps;
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;

Line 287: hr_utility.set_location('Leaving '||l_proc,20);

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:
290: --
291: -- ----------------------------------------------------------------------------

Line 464: hr_utility.set_location('Entering:'|| l_proc, 10);

460: l_object_version_number pqh_corps_extra_info.object_version_number%TYPE;
461: --
462: begin
463: --
464: hr_utility.set_location('Entering:'|| l_proc, 10);
465: --
466: -- Issue a savepoint if operating in validation only mode
467: --
468: savepoint create_corps_extra_info;

Line 470: hr_utility.set_location(l_proc, 20);

466: -- Issue a savepoint if operating in validation only mode
467: --
468: savepoint create_corps_extra_info;
469: --
470: hr_utility.set_location(l_proc, 20);
471: --
472: -- Process Logic
473: --
474: begin

Line 743: hr_utility.set_location(l_proc, 60);

739: --
740: end;
741:
742: --
743: hr_utility.set_location(l_proc, 60);
744: --
745: -- When in validation only mode raise the Validate_Enabled exception
746: --
747: if p_validate then

Line 756: hr_utility.set_location(' Leaving:'||l_proc, 70);

752: --
753: p_corps_extra_info_id := l_corps_extra_info_id;
754: p_object_version_number := l_object_version_number;
755: --
756: hr_utility.set_location(' Leaving:'||l_proc, 70);
757: --
758: exception
759: --
760: when hr_api.validate_enabled then

Line 773: hr_utility.set_location(' Leaving:'||l_proc, 80);

769: -- when validation only mode is being used.)
770: --
771: p_corps_extra_info_id := null;
772: p_object_version_number := null;
773: hr_utility.set_location(' Leaving:'||l_proc, 80);
774: --
775: when others then
776: p_corps_extra_info_id := null;
777: p_object_version_number := null;

Line 958: hr_utility.set_location('Entering:'|| l_proc, 10);

954: l_object_version_number pqh_corps_extra_info.object_version_number%TYPE;
955: --
956: begin
957: --
958: hr_utility.set_location('Entering:'|| l_proc, 10);
959: --
960: -- Issue a savepoint if operating in validation only mode
961: --
962: savepoint update_corps_extra_info;

Line 964: hr_utility.set_location(l_proc, 20);

960: -- Issue a savepoint if operating in validation only mode
961: --
962: savepoint update_corps_extra_info;
963: --
964: hr_utility.set_location(l_proc, 20);
965: l_object_version_number := p_object_version_number;
966: --
967: -- Process Logic
968: --

Line 1246: hr_utility.set_location(l_proc, 60);

1242: --
1243: end;
1244:
1245: --
1246: hr_utility.set_location(l_proc, 60);
1247: --
1248: -- When in validation only mode raise the Validate_Enabled exception
1249: --
1250: if p_validate then

Line 1258: hr_utility.set_location(' Leaving:'||l_proc, 70);

1254: -- Set all output arguments
1255: --
1256: p_object_version_number := l_object_version_number;
1257: --
1258: hr_utility.set_location(' Leaving:'||l_proc, 70);
1259: --
1260: exception
1261: --
1262: when hr_api.validate_enabled then

Line 1273: hr_utility.set_location(' Leaving:'||l_proc, 80);

1269: -- Only set output warning arguments
1270: -- (Any key or derived arguments must be set to null
1271: -- when validation only mode is being used.)
1272: --
1273: hr_utility.set_location(' Leaving:'||l_proc, 80);
1274: --
1275: when others then
1276: p_object_version_number := l_object_version_number;
1277: --

Line 1328: hr_utility.set_location('Entering:'|| l_proc, 10);

1324: l_object_version_number pqh_corps_extra_info.object_version_number%TYPE;
1325: --
1326: begin
1327: --
1328: hr_utility.set_location('Entering:'|| l_proc, 10);
1329: --
1330: -- Issue a savepoint if operating in validation only mode
1331: --
1332: savepoint delete_corps_extra_info;

Line 1334: hr_utility.set_location(l_proc, 20);

1330: -- Issue a savepoint if operating in validation only mode
1331: --
1332: savepoint delete_corps_extra_info;
1333: --
1334: hr_utility.set_location(l_proc, 20);
1335: --
1336: -- Process Logic
1337: --
1338: l_object_version_number := p_object_version_number;

Line 1393: hr_utility.set_location(l_proc, 60);

1389: -- End of API User Hook for the after hook of delete_corps_extra_info
1390: --
1391: end;
1392: --
1393: hr_utility.set_location(l_proc, 60);
1394: --
1395: -- When in validation only mode raise the Validate_Enabled exception
1396: --
1397: if p_validate then

Line 1401: hr_utility.set_location(' Leaving:'||l_proc, 70);

1397: if p_validate then
1398: raise hr_api.validate_enabled;
1399: end if;
1400: --
1401: hr_utility.set_location(' Leaving:'||l_proc, 70);
1402: --
1403: exception
1404: --
1405: when hr_api.validate_enabled then

Line 1445: hr_utility.set_location('Entering:'|| l_proc, 10);

1441: l_proc varchar2(72) := g_package||'lck';
1442: --
1443: begin
1444: --
1445: hr_utility.set_location('Entering:'|| l_proc, 10);
1446: --
1447: PQH_CEI_shd.lck
1448: (
1449: p_corps_extra_info_id => p_corps_extra_info_id

Line 1453: hr_utility.set_location(' Leaving:'||l_proc, 70);

1449: p_corps_extra_info_id => p_corps_extra_info_id
1450: ,p_object_version_number => p_object_version_number
1451: );
1452: --
1453: hr_utility.set_location(' Leaving:'||l_proc, 70);
1454: --
1455: end lck;
1456: --
1457: end pqh_corps_extra_info_api;