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.HR_ORGANIZATION_UNITS_PKG dependencies on HR_UTILITY

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

36: l_constituency_total_seats NUMBER :=0;
37: --
38: BEGIN
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: IF p_org_information_context = 'Representative Body' Then
43: --
44: l_repbody_max_seats := p_org_information6;

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

50: CLOSE repbody_max_seats;
51: --
52: END IF;
53: --
54: hr_utility.set_location(l_proc,20);
55: --
56: IF l_repbody_max_seats IS NOT NULL THEN
57: --
58: IF p_rowid is NULL THEN

Line 72: hr_utility.set_location(l_proc,30);

68: CLOSE constituency_total_seats1;
69: --
70: END IF;
71: --
72: hr_utility.set_location(l_proc,30);
73: --
74: l_constituency_total_seats := NVL(l_constituency_total_seats,0) + NVL(p_org_information2,0);
75: --
76: IF l_constituency_total_seats > l_repbody_max_seats THEN

Line 78: hr_utility.set_message(800,'HR_289048_CON_INV_SEAT_NUM');

74: l_constituency_total_seats := NVL(l_constituency_total_seats,0) + NVL(p_org_information2,0);
75: --
76: IF l_constituency_total_seats > l_repbody_max_seats THEN
77: --
78: hr_utility.set_message(800,'HR_289048_CON_INV_SEAT_NUM');
79: hr_utility.raise_error;
80: --
81: END IF;
82: --

Line 79: hr_utility.raise_error;

75: --
76: IF l_constituency_total_seats > l_repbody_max_seats THEN
77: --
78: hr_utility.set_message(800,'HR_289048_CON_INV_SEAT_NUM');
79: hr_utility.raise_error;
80: --
81: END IF;
82: --
83: END IF;

Line 85: hr_utility.set_location('Leaving:'|| l_proc, 10);

81: END IF;
82: --
83: END IF;
84: --
85: hr_utility.set_location('Leaving:'|| l_proc, 10);
86: --
87: EXCEPTION
88: WHEN OTHERS THEN
89: RAISE;

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

121: l_proc VARCHAR2(72) := g_package||'Is_Org_A_Node';
122: --
123: BEGIN
124: --
125: hr_utility.set_location('Entering:'|| l_proc, 10);
126: --
127: OPEN c_get_structure_version;
128: FETCH c_get_structure_version INTO v_version_id;
129: CLOSE c_get_structure_version;

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

127: OPEN c_get_structure_version;
128: FETCH c_get_structure_version INTO v_version_id;
129: CLOSE c_get_structure_version;
130: --
131: hr_utility.set_location(l_proc,20);
132: --
133: FOR c_rec IN c_orgs_in_hierarchy(v_version_id) LOOP
134: --
135: IF c_rec.org_id = p_search_org_id THEN

Line 145: hr_utility.set_location(l_proc,30);

141: EXIT WHEN v_org_in_hierarchy;
142: --
143: END LOOP;
144: --
145: hr_utility.set_location(l_proc,30);
146: --
147: IF v_org_in_hierarchy THEN
148: --
149: v_return_message := 'TRUE';

Line 151: hr_utility.set_location(l_proc,40);

147: IF v_org_in_hierarchy THEN
148: --
149: v_return_message := 'TRUE';
150: --
151: hr_utility.set_location(l_proc,40);
152: --
153: ELSIF NOT v_org_in_hierarchy THEN
154: --
155: v_return_message := 'FALSE';

Line 157: hr_utility.set_location(l_proc,50);

153: ELSIF NOT v_org_in_hierarchy THEN
154: --
155: v_return_message := 'FALSE';
156: --
157: hr_utility.set_location(l_proc,50);
158: --
159: END IF;
160: --
161: hr_utility.set_location('Leaving'|| l_proc, 60);

Line 161: hr_utility.set_location('Leaving'|| l_proc, 60);

157: hr_utility.set_location(l_proc,50);
158: --
159: END IF;
160: --
161: hr_utility.set_location('Leaving'|| l_proc, 60);
162: --
163: RETURN(v_return_message);
164: --
165: END Is_Org_A_Node;

Line 246: hr_utility.set_message(801,'HR_6612_ORG_LEGAL_NO_LOCATION');

242: open test_loc('HR_LEGAL');
243: fetch test_loc into l_dummy;
244: if test_loc%FOUND then
245: close test_loc;
246: hr_utility.set_message(801,'HR_6612_ORG_LEGAL_NO_LOCATION');
247: hr_utility.raise_error;
248: end if;
249: close test_loc;
250: --

Line 247: hr_utility.raise_error;

243: fetch test_loc into l_dummy;
244: if test_loc%FOUND then
245: close test_loc;
246: hr_utility.set_message(801,'HR_6612_ORG_LEGAL_NO_LOCATION');
247: hr_utility.raise_error;
248: end if;
249: close test_loc;
250: --
251: open test_loc('HR_ESTAB');

Line 255: hr_utility.set_message(801,'HR_7342_ORG_RE_NO_LOC');

251: open test_loc('HR_ESTAB');
252: fetch test_loc into l_dummy;
253: if test_loc%FOUND then
254: close test_loc;
255: hr_utility.set_message(801,'HR_7342_ORG_RE_NO_LOC');
256: hr_utility.raise_error;
257: end if;
258: close test_loc;
259:

Line 256: hr_utility.raise_error;

252: fetch test_loc into l_dummy;
253: if test_loc%FOUND then
254: close test_loc;
255: hr_utility.set_message(801,'HR_7342_ORG_RE_NO_LOC');
256: hr_utility.raise_error;
257: end if;
258: close test_loc;
259:
260: end;

Line 484: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

480: OPEN C;
481: FETCH C INTO X_Rowid;
482: if (C%NOTFOUND) then
483: CLOSE C;
484: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
485: hr_utility.set_message_token('PROCEDURE','Insert_row');
486: hr_utility.set_message_token('STEP','1');
487: hr_utility.raise_error;
488: end if;

Line 485: hr_utility.set_message_token('PROCEDURE','Insert_row');

481: FETCH C INTO X_Rowid;
482: if (C%NOTFOUND) then
483: CLOSE C;
484: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
485: hr_utility.set_message_token('PROCEDURE','Insert_row');
486: hr_utility.set_message_token('STEP','1');
487: hr_utility.raise_error;
488: end if;
489: CLOSE C;

Line 486: hr_utility.set_message_token('STEP','1');

482: if (C%NOTFOUND) then
483: CLOSE C;
484: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
485: hr_utility.set_message_token('PROCEDURE','Insert_row');
486: hr_utility.set_message_token('STEP','1');
487: hr_utility.raise_error;
488: end if;
489: CLOSE C;
490:

Line 487: hr_utility.raise_error;

483: CLOSE C;
484: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
485: hr_utility.set_message_token('PROCEDURE','Insert_row');
486: hr_utility.set_message_token('STEP','1');
487: hr_utility.raise_error;
488: end if;
489: CLOSE C;
490:
491: if X_View_All_Orgs <> 'Y' then

Line 573: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

569: OPEN C;
570: FETCH C INTO Recinfo;
571: if (C%NOTFOUND) then
572: CLOSE C;
573: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
574: hr_utility.set_message_token('PROCEDURE','Lock_row');
575: hr_utility.set_message_token('STEP','1');
576: hr_utility.raise_error;
577: end if;

Line 574: hr_utility.set_message_token('PROCEDURE','Lock_row');

570: FETCH C INTO Recinfo;
571: if (C%NOTFOUND) then
572: CLOSE C;
573: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
574: hr_utility.set_message_token('PROCEDURE','Lock_row');
575: hr_utility.set_message_token('STEP','1');
576: hr_utility.raise_error;
577: end if;
578: CLOSE C;

Line 575: hr_utility.set_message_token('STEP','1');

571: if (C%NOTFOUND) then
572: CLOSE C;
573: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
574: hr_utility.set_message_token('PROCEDURE','Lock_row');
575: hr_utility.set_message_token('STEP','1');
576: hr_utility.raise_error;
577: end if;
578: CLOSE C;
579: --

Line 576: hr_utility.raise_error;

572: CLOSE C;
573: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
574: hr_utility.set_message_token('PROCEDURE','Lock_row');
575: hr_utility.set_message_token('STEP','1');
576: hr_utility.raise_error;
577: end if;
578: CLOSE C;
579: --
580: Recinfo.name_tl := rtrim(Recinfo.name_tl);

Line 816: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

812: -- WHERE BUSINESS_GROUP_ID = X_Business_Group_Id
813: -- AND ORGANIZATION_ID = X_Organization_Id;
814:
815: if (SQL%NOTFOUND) then
816: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
817: hr_utility.set_message_token('PROCEDURE','Update_Row');
818: hr_utility.set_message_token('STEP','1');
819: hr_utility.raise_error;
820: end if;

Line 817: hr_utility.set_message_token('PROCEDURE','Update_Row');

813: -- AND ORGANIZATION_ID = X_Organization_Id;
814:
815: if (SQL%NOTFOUND) then
816: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
817: hr_utility.set_message_token('PROCEDURE','Update_Row');
818: hr_utility.set_message_token('STEP','1');
819: hr_utility.raise_error;
820: end if;
821: --

Line 818: hr_utility.set_message_token('STEP','1');

814:
815: if (SQL%NOTFOUND) then
816: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
817: hr_utility.set_message_token('PROCEDURE','Update_Row');
818: hr_utility.set_message_token('STEP','1');
819: hr_utility.raise_error;
820: end if;
821: --
822: update HR_ALL_ORGANIZATION_UNITS_TL set

Line 819: hr_utility.raise_error;

815: if (SQL%NOTFOUND) then
816: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
817: hr_utility.set_message_token('PROCEDURE','Update_Row');
818: hr_utility.set_message_token('STEP','1');
819: hr_utility.raise_error;
820: end if;
821: --
822: update HR_ALL_ORGANIZATION_UNITS_TL set
823: NAME = X_Name,

Line 916: hr_utility.set_message(800,'PER_52852_ORG_DEL_CAGR');

912: -- Close Cursor added a part of fix for bug 1858597
913: --
914: close csr_employer;
915: --
916: hr_utility.set_message(800,'PER_52852_ORG_DEL_CAGR');
917: hr_utility.raise_error;
918: --
919: end if;
920: --

Line 917: hr_utility.raise_error;

913: --
914: close csr_employer;
915: --
916: hr_utility.set_message(800,'PER_52852_ORG_DEL_CAGR');
917: hr_utility.raise_error;
918: --
919: end if;
920: --
921: close csr_employer;

Line 935: hr_utility.set_message(800,'PER_52852_ORG_DEL_CAGR');

931: --
932: -- Close Cursor added a part of fix for bug 1858597
933: --
934: close csr_barg_units;
935: hr_utility.set_message(800,'PER_52852_ORG_DEL_CAGR');
936: hr_utility.raise_error;
937: --
938: end if;
939: --

Line 936: hr_utility.raise_error;

932: -- Close Cursor added a part of fix for bug 1858597
933: --
934: close csr_barg_units;
935: hr_utility.set_message(800,'PER_52852_ORG_DEL_CAGR');
936: hr_utility.raise_error;
937: --
938: end if;
939: --
940: close csr_barg_units;

Line 1046: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1042: WHERE BUSINESS_GROUP_ID = X_Business_Group_Id
1043: AND ORGANIZATION_ID = X_Organization_Id;
1044: --
1045: if (SQL%NOTFOUND) then
1046: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1047: hr_utility.set_message_token('PROCEDURE','Delete_Row');
1048: hr_utility.set_message_token('STEP','1');
1049: hr_utility.raise_error;
1050: end if;

Line 1047: hr_utility.set_message_token('PROCEDURE','Delete_Row');

1043: AND ORGANIZATION_ID = X_Organization_Id;
1044: --
1045: if (SQL%NOTFOUND) then
1046: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1047: hr_utility.set_message_token('PROCEDURE','Delete_Row');
1048: hr_utility.set_message_token('STEP','1');
1049: hr_utility.raise_error;
1050: end if;
1051: END Delete_Row;

Line 1048: hr_utility.set_message_token('STEP','1');

1044: --
1045: if (SQL%NOTFOUND) then
1046: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1047: hr_utility.set_message_token('PROCEDURE','Delete_Row');
1048: hr_utility.set_message_token('STEP','1');
1049: hr_utility.raise_error;
1050: end if;
1051: END Delete_Row;
1052: --

Line 1049: hr_utility.raise_error;

1045: if (SQL%NOTFOUND) then
1046: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1047: hr_utility.set_message_token('PROCEDURE','Delete_Row');
1048: hr_utility.set_message_token('STEP','1');
1049: hr_utility.raise_error;
1050: end if;
1051: END Delete_Row;
1052: --
1053: PROCEDURE zoom_forms(X_destination IN VARCHAR2

Line 1296: hr_utility.set_location (l_package_name,10);

1292: l_package_name VARCHAR2(80) := 'HR_ORGANIZATION_UNITS_PKG.VALIDATE_TRANSLATION';
1293: l_business_group_id NUMBER := nvl(p_business_group_id, g_business_group_id);
1294:
1295: BEGIN
1296: hr_utility.set_location (l_package_name,10);
1297: OPEN c_translation(language, name,organization_id,
1298: l_business_group_id);
1299: hr_utility.set_location (l_package_name,50);
1300: FETCH c_translation INTO g_dummy;

Line 1299: hr_utility.set_location (l_package_name,50);

1295: BEGIN
1296: hr_utility.set_location (l_package_name,10);
1297: OPEN c_translation(language, name,organization_id,
1298: l_business_group_id);
1299: hr_utility.set_location (l_package_name,50);
1300: FETCH c_translation INTO g_dummy;
1301:
1302: IF c_translation%NOTFOUND THEN
1303: hr_utility.set_location (l_package_name,60);

Line 1303: hr_utility.set_location (l_package_name,60);

1299: hr_utility.set_location (l_package_name,50);
1300: FETCH c_translation INTO g_dummy;
1301:
1302: IF c_translation%NOTFOUND THEN
1303: hr_utility.set_location (l_package_name,60);
1304: CLOSE c_translation;
1305: ELSE
1306: hr_utility.set_location (l_package_name,70);
1307: CLOSE c_translation;

Line 1306: hr_utility.set_location (l_package_name,70);

1302: IF c_translation%NOTFOUND THEN
1303: hr_utility.set_location (l_package_name,60);
1304: CLOSE c_translation;
1305: ELSE
1306: hr_utility.set_location (l_package_name,70);
1307: CLOSE c_translation;
1308: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
1309: fnd_message.raise_error;
1310: END IF;

Line 1311: hr_utility.set_location ('Leaving:'||l_package_name,80);

1307: CLOSE c_translation;
1308: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
1309: fnd_message.raise_error;
1310: END IF;
1311: hr_utility.set_location ('Leaving:'||l_package_name,80);
1312: END validate_translation;
1313: --------------------------------------------------------------------------------
1314: END HR_ORGANIZATION_UNITS_PKG;