DBA Data[Home] [Help]

APPS.HXC_ALIAS_UTILS_PKG dependencies on HR_UTILITY

Line 19: 09-Sep-05 sechandr 115.6 4573414 Conditionally enabling hr_utility calls

15:
16: History
17: 01-Nov-00 RAMURTHY 115.0 Date created.
18: 09-JUN-02 MHANDA 115.4 added SET VERIFY OFF
19: 09-Sep-05 sechandr 115.6 4573414 Conditionally enabling hr_utility calls
20: ============================================================================*/
21:
22: g_debug boolean :=hr_utility.debug_enabled;
23: --------------------------------------------------------------------------------

Line 22: g_debug boolean :=hr_utility.debug_enabled;

18: 09-JUN-02 MHANDA 115.4 added SET VERIFY OFF
19: 09-Sep-05 sechandr 115.6 4573414 Conditionally enabling hr_utility calls
20: ============================================================================*/
21:
22: g_debug boolean :=hr_utility.debug_enabled;
23: --------------------------------------------------------------------------------
24: PROCEDURE validate_defn_translation (p_alias_definition_id IN number,
25: p_language IN varchar2,
26: p_alias_definition_name IN varchar2,

Line 62: g_debug:=hr_utility.debug_enabled;

58: l_dummy varchar2(100);
59: l_dummy_number number;
60:
61: BEGIN
62: g_debug:=hr_utility.debug_enabled;
63: if g_debug then
64: l_package_name := 'hxc_alias_utils_pkg.validate_defn_translation';
65: hr_utility.set_location (l_package_name,1);
66: end if;

Line 65: hr_utility.set_location (l_package_name,1);

61: BEGIN
62: g_debug:=hr_utility.debug_enabled;
63: if g_debug then
64: l_package_name := 'hxc_alias_utils_pkg.validate_defn_translation';
65: hr_utility.set_location (l_package_name,1);
66: end if;
67:
68: /*
69: BEGIN

Line 74: hr_utility.set_location (l_package_name,2);

70: hr_chkfmt.checkformat (l_name,
71: 'PAY_NAME',
72: l_dummy, null, null, 'N', l_dummy, null);
73: if g_debug then
74: hr_utility.set_location (l_package_name,2);
75: end if;
76:
77: EXCEPTION
78: when app_exception.application_exception then

Line 80: hr_utility.set_location (l_package_name,3);

76:
77: EXCEPTION
78: when app_exception.application_exception then
79: if g_debug then
80: hr_utility.set_location (l_package_name,3);
81: end if;
82: fnd_message.set_name ('PAY','PAY_6365_ELEMENT_NO_DB_NAME'); -- check
83: format failure
84: fnd_message.raise_error;

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

84: fnd_message.raise_error;
85: END;
86:
87: if g_debug then
88: hr_utility.set_location (l_package_name,10);
89: end if;
90: */
91: OPEN c_translation(p_language
92: ,p_alias_definition_name

Line 96: hr_utility.set_location (l_package_name,20);

92: ,p_alias_definition_name
93: ,p_alias_definition_id);
94:
95: if g_debug then
96: hr_utility.set_location (l_package_name,20);
97: end if;
98:
99: FETCH c_translation INTO l_dummy_number;
100: if g_debug then

Line 101: hr_utility.set_location (l_package_name,25);

97: end if;
98:
99: FETCH c_translation INTO l_dummy_number;
100: if g_debug then
101: hr_utility.set_location (l_package_name,25);
102: end if;
103:
104: IF c_translation%NOTFOUND THEN
105: if g_debug then

Line 106: hr_utility.set_location (l_package_name,30);

102: end if;
103:
104: IF c_translation%NOTFOUND THEN
105: if g_debug then
106: hr_utility.set_location (l_package_name,30);
107: end if;
108: CLOSE c_translation;
109: ELSE
110: if g_debug then

Line 111: hr_utility.set_location (l_package_name,40);

107: end if;
108: CLOSE c_translation;
109: ELSE
110: if g_debug then
111: hr_utility.set_location (l_package_name,40);
112: end if;
113: CLOSE c_translation;
114: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
115: fnd_message.raise_error;

Line 119: hr_utility.set_location ('Leaving: '||l_package_name,140);

115: fnd_message.raise_error;
116: END IF;
117:
118: if g_debug then
119: hr_utility.set_location ('Leaving: '||l_package_name,140);
120: end if;
121: END validate_defn_translation;
122:
123:

Line 160: g_debug:=hr_utility.debug_enabled;

156: l_dummy varchar2(100);
157: l_dummy_number number;
158:
159: BEGIN
160: g_debug:=hr_utility.debug_enabled;
161: if g_debug then
162: l_package_name := 'hxc_alias_utils_pkg.validate_name_translation';
163: hr_utility.set_location (l_package_name,1);
164: end if;

Line 163: hr_utility.set_location (l_package_name,1);

159: BEGIN
160: g_debug:=hr_utility.debug_enabled;
161: if g_debug then
162: l_package_name := 'hxc_alias_utils_pkg.validate_name_translation';
163: hr_utility.set_location (l_package_name,1);
164: end if;
165:
166: /*
167: BEGIN

Line 172: hr_utility.set_location (l_package_name,2);

168: hr_chkfmt.checkformat (l_name,
169: 'PAY_NAME',
170: l_dummy, null, null, 'N', l_dummy, null);
171: if g_debug then
172: hr_utility.set_location (l_package_name,2);
173: end if;
174:
175: EXCEPTION
176: when app_exception.application_exception then

Line 178: hr_utility.set_location (l_package_name,3);

174:
175: EXCEPTION
176: when app_exception.application_exception then
177: if g_debug then
178: hr_utility.set_location (l_package_name,3);
179: end if;
180: fnd_message.set_name ('PAY','PAY_6365_ELEMENT_NO_DB_NAME'); -- check
181: format failure
182: fnd_message.raise_error;

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

182: fnd_message.raise_error;
183: END;
184:
185: if g_debug then
186: hr_utility.set_location (l_package_name,10);
187: end if;
188: */
189: OPEN c_translation(p_language
190: ,p_alias_value_name

Line 194: hr_utility.set_location (l_package_name,20);

190: ,p_alias_value_name
191: ,p_alias_value_id);
192:
193: if g_debug then
194: hr_utility.set_location (l_package_name,20);
195: end if;
196:
197: FETCH c_translation INTO l_dummy_number;
198: if g_debug then

Line 199: hr_utility.set_location (l_package_name,25);

195: end if;
196:
197: FETCH c_translation INTO l_dummy_number;
198: if g_debug then
199: hr_utility.set_location (l_package_name,25);
200: end if;
201:
202: IF c_translation%NOTFOUND THEN
203: if g_debug then

Line 204: hr_utility.set_location (l_package_name,30);

200: end if;
201:
202: IF c_translation%NOTFOUND THEN
203: if g_debug then
204: hr_utility.set_location (l_package_name,30);
205: end if;
206: CLOSE c_translation;
207: ELSE
208: if g_debug then

Line 209: hr_utility.set_location (l_package_name,40);

205: end if;
206: CLOSE c_translation;
207: ELSE
208: if g_debug then
209: hr_utility.set_location (l_package_name,40);
210: end if;
211: CLOSE c_translation;
212: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
213: fnd_message.raise_error;

Line 217: hr_utility.set_location ('Leaving: '||l_package_name,140);

213: fnd_message.raise_error;
214: END IF;
215:
216: if g_debug then
217: hr_utility.set_location ('Leaving: '||l_package_name,140);
218: end if;
219: END validate_name_translation;
220:
221: