54: l_procedure VARCHAR2(100);
55: BEGIN
56:
57: l_procedure := g_package||'check_ee_phf_si_setup';
58: g_debug := hr_utility.debug_enabled;
59: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
60:
61: IF g_debug THEN
62: hr_utility.trace('====================================================================');
58: g_debug := hr_utility.debug_enabled;
59: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
60:
61: IF g_debug THEN
62: hr_utility.trace('====================================================================');
63: hr_utility.trace('p_message_name '||p_message_name);
64: hr_utility.trace('====================================================================');
65: END IF;
66:
59: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
60:
61: IF g_debug THEN
62: hr_utility.trace('====================================================================');
63: hr_utility.trace('p_message_name '||p_message_name);
64: hr_utility.trace('====================================================================');
65: END IF;
66:
67: IF g_debug THEN
60:
61: IF g_debug THEN
62: hr_utility.trace('====================================================================');
63: hr_utility.trace('p_message_name '||p_message_name);
64: hr_utility.trace('====================================================================');
65: END IF;
66:
67: IF g_debug THEN
68: hr_utility.trace('====================================================================');
64: hr_utility.trace('====================================================================');
65: END IF;
66:
67: IF g_debug THEN
68: hr_utility.trace('====================================================================');
69: hr_utility.trace('p_entry_information2 '||p_entry_information2);
70: hr_utility.trace('p_entry_information3 '||p_entry_information3);
71: hr_utility.trace('p_entry_information4 '||p_entry_information4);
72: hr_utility.trace('p_entry_information5 '||p_entry_information5);
65: END IF;
66:
67: IF g_debug THEN
68: hr_utility.trace('====================================================================');
69: hr_utility.trace('p_entry_information2 '||p_entry_information2);
70: hr_utility.trace('p_entry_information3 '||p_entry_information3);
71: hr_utility.trace('p_entry_information4 '||p_entry_information4);
72: hr_utility.trace('p_entry_information5 '||p_entry_information5);
73: hr_utility.trace('p_entry_information6 '||p_entry_information6);
66:
67: IF g_debug THEN
68: hr_utility.trace('====================================================================');
69: hr_utility.trace('p_entry_information2 '||p_entry_information2);
70: hr_utility.trace('p_entry_information3 '||p_entry_information3);
71: hr_utility.trace('p_entry_information4 '||p_entry_information4);
72: hr_utility.trace('p_entry_information5 '||p_entry_information5);
73: hr_utility.trace('p_entry_information6 '||p_entry_information6);
74: hr_utility.trace('p_entry_information7 '||p_entry_information7);
67: IF g_debug THEN
68: hr_utility.trace('====================================================================');
69: hr_utility.trace('p_entry_information2 '||p_entry_information2);
70: hr_utility.trace('p_entry_information3 '||p_entry_information3);
71: hr_utility.trace('p_entry_information4 '||p_entry_information4);
72: hr_utility.trace('p_entry_information5 '||p_entry_information5);
73: hr_utility.trace('p_entry_information6 '||p_entry_information6);
74: hr_utility.trace('p_entry_information7 '||p_entry_information7);
75: hr_utility.trace('p_entry_information8 '||p_entry_information8);
68: hr_utility.trace('====================================================================');
69: hr_utility.trace('p_entry_information2 '||p_entry_information2);
70: hr_utility.trace('p_entry_information3 '||p_entry_information3);
71: hr_utility.trace('p_entry_information4 '||p_entry_information4);
72: hr_utility.trace('p_entry_information5 '||p_entry_information5);
73: hr_utility.trace('p_entry_information6 '||p_entry_information6);
74: hr_utility.trace('p_entry_information7 '||p_entry_information7);
75: hr_utility.trace('p_entry_information8 '||p_entry_information8);
76: hr_utility.trace('p_entry_information9 '||p_entry_information9);
69: hr_utility.trace('p_entry_information2 '||p_entry_information2);
70: hr_utility.trace('p_entry_information3 '||p_entry_information3);
71: hr_utility.trace('p_entry_information4 '||p_entry_information4);
72: hr_utility.trace('p_entry_information5 '||p_entry_information5);
73: hr_utility.trace('p_entry_information6 '||p_entry_information6);
74: hr_utility.trace('p_entry_information7 '||p_entry_information7);
75: hr_utility.trace('p_entry_information8 '||p_entry_information8);
76: hr_utility.trace('p_entry_information9 '||p_entry_information9);
77: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
70: hr_utility.trace('p_entry_information3 '||p_entry_information3);
71: hr_utility.trace('p_entry_information4 '||p_entry_information4);
72: hr_utility.trace('p_entry_information5 '||p_entry_information5);
73: hr_utility.trace('p_entry_information6 '||p_entry_information6);
74: hr_utility.trace('p_entry_information7 '||p_entry_information7);
75: hr_utility.trace('p_entry_information8 '||p_entry_information8);
76: hr_utility.trace('p_entry_information9 '||p_entry_information9);
77: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
78: hr_utility.trace('====================================================================');
71: hr_utility.trace('p_entry_information4 '||p_entry_information4);
72: hr_utility.trace('p_entry_information5 '||p_entry_information5);
73: hr_utility.trace('p_entry_information6 '||p_entry_information6);
74: hr_utility.trace('p_entry_information7 '||p_entry_information7);
75: hr_utility.trace('p_entry_information8 '||p_entry_information8);
76: hr_utility.trace('p_entry_information9 '||p_entry_information9);
77: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
78: hr_utility.trace('====================================================================');
79: END IF;
72: hr_utility.trace('p_entry_information5 '||p_entry_information5);
73: hr_utility.trace('p_entry_information6 '||p_entry_information6);
74: hr_utility.trace('p_entry_information7 '||p_entry_information7);
75: hr_utility.trace('p_entry_information8 '||p_entry_information8);
76: hr_utility.trace('p_entry_information9 '||p_entry_information9);
77: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
78: hr_utility.trace('====================================================================');
79: END IF;
80:
73: hr_utility.trace('p_entry_information6 '||p_entry_information6);
74: hr_utility.trace('p_entry_information7 '||p_entry_information7);
75: hr_utility.trace('p_entry_information8 '||p_entry_information8);
76: hr_utility.trace('p_entry_information9 '||p_entry_information9);
77: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
78: hr_utility.trace('====================================================================');
79: END IF;
80:
81: IF (p_entry_information2 IS NOT NULL AND p_entry_information3 IS NULL) THEN
74: hr_utility.trace('p_entry_information7 '||p_entry_information7);
75: hr_utility.trace('p_entry_information8 '||p_entry_information8);
76: hr_utility.trace('p_entry_information9 '||p_entry_information9);
77: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
78: hr_utility.trace('====================================================================');
79: END IF;
80:
81: IF (p_entry_information2 IS NOT NULL AND p_entry_information3 IS NULL) THEN
82: hr_cn_api.set_location(g_debug,l_procedure,20);
86: p_token_name(2) := 'FIELD2';
87: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
88:
89: IF g_debug THEN
90: hr_utility.trace('====================================================================');
91: hr_utility.trace('p_message_name '||p_message_name);
92: hr_utility.trace('====================================================================');
93: END IF;
94:
87: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
88:
89: IF g_debug THEN
90: hr_utility.trace('====================================================================');
91: hr_utility.trace('p_message_name '||p_message_name);
92: hr_utility.trace('====================================================================');
93: END IF;
94:
95: RETURN;
88:
89: IF g_debug THEN
90: hr_utility.trace('====================================================================');
91: hr_utility.trace('p_message_name '||p_message_name);
92: hr_utility.trace('====================================================================');
93: END IF;
94:
95: RETURN;
96: END IF;
103: p_token_name(2) := 'FIELD2';
104: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
105:
106: IF g_debug THEN
107: hr_utility.trace('====================================================================');
108: hr_utility.trace('p_message_name '||p_message_name);
109: hr_utility.trace('====================================================================');
110: END IF;
111:
104: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
105:
106: IF g_debug THEN
107: hr_utility.trace('====================================================================');
108: hr_utility.trace('p_message_name '||p_message_name);
109: hr_utility.trace('====================================================================');
110: END IF;
111:
112: RETURN;
105:
106: IF g_debug THEN
107: hr_utility.trace('====================================================================');
108: hr_utility.trace('p_message_name '||p_message_name);
109: hr_utility.trace('====================================================================');
110: END IF;
111:
112: RETURN;
113: END IF;
120: p_token_name(2) := 'FIELD2';
121: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
122:
123: IF g_debug THEN
124: hr_utility.trace('====================================================================');
125: hr_utility.trace('p_message_name '||p_message_name);
126: hr_utility.trace('====================================================================');
127: END IF;
128:
121: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
122:
123: IF g_debug THEN
124: hr_utility.trace('====================================================================');
125: hr_utility.trace('p_message_name '||p_message_name);
126: hr_utility.trace('====================================================================');
127: END IF;
128:
129: RETURN;
122:
123: IF g_debug THEN
124: hr_utility.trace('====================================================================');
125: hr_utility.trace('p_message_name '||p_message_name);
126: hr_utility.trace('====================================================================');
127: END IF;
128:
129: RETURN;
130: END IF;
137: p_token_name(2) := 'FIELD2';
138: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
139:
140: IF g_debug THEN
141: hr_utility.trace('====================================================================');
142: hr_utility.trace('p_message_name '||p_message_name);
143: hr_utility.trace('====================================================================');
144: END IF;
145:
138: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
139:
140: IF g_debug THEN
141: hr_utility.trace('====================================================================');
142: hr_utility.trace('p_message_name '||p_message_name);
143: hr_utility.trace('====================================================================');
144: END IF;
145:
146: RETURN;
139:
140: IF g_debug THEN
141: hr_utility.trace('====================================================================');
142: hr_utility.trace('p_message_name '||p_message_name);
143: hr_utility.trace('====================================================================');
144: END IF;
145:
146: RETURN;
147: END IF;
154: p_token_name(2) := 'FIELD2';
155: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
156:
157: IF g_debug THEN
158: hr_utility.trace('====================================================================');
159: hr_utility.trace('p_message_name '||p_message_name);
160: hr_utility.trace('====================================================================');
161: END IF;
162:
155: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
156:
157: IF g_debug THEN
158: hr_utility.trace('====================================================================');
159: hr_utility.trace('p_message_name '||p_message_name);
160: hr_utility.trace('====================================================================');
161: END IF;
162:
163: RETURN;
156:
157: IF g_debug THEN
158: hr_utility.trace('====================================================================');
159: hr_utility.trace('p_message_name '||p_message_name);
160: hr_utility.trace('====================================================================');
161: END IF;
162:
163: RETURN;
164: END IF;
171: p_token_name(2) := 'FIELD2';
172: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
173:
174: IF g_debug THEN
175: hr_utility.trace('====================================================================');
176: hr_utility.trace('p_message_name '||p_message_name);
177: hr_utility.trace('====================================================================');
178: END IF;
179:
172: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
173:
174: IF g_debug THEN
175: hr_utility.trace('====================================================================');
176: hr_utility.trace('p_message_name '||p_message_name);
177: hr_utility.trace('====================================================================');
178: END IF;
179:
180: RETURN;
173:
174: IF g_debug THEN
175: hr_utility.trace('====================================================================');
176: hr_utility.trace('p_message_name '||p_message_name);
177: hr_utility.trace('====================================================================');
178: END IF;
179:
180: RETURN;
181: END IF;
188: p_token_name(2) := 'FIELD2';
189: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
190:
191: IF g_debug THEN
192: hr_utility.trace('====================================================================');
193: hr_utility.trace('p_message_name '||p_message_name);
194: hr_utility.trace('====================================================================');
195: END IF;
196:
189: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
190:
191: IF g_debug THEN
192: hr_utility.trace('====================================================================');
193: hr_utility.trace('p_message_name '||p_message_name);
194: hr_utility.trace('====================================================================');
195: END IF;
196:
197: RETURN;
190:
191: IF g_debug THEN
192: hr_utility.trace('====================================================================');
193: hr_utility.trace('p_message_name '||p_message_name);
194: hr_utility.trace('====================================================================');
195: END IF;
196:
197: RETURN;
198: END IF;
205: p_token_name(2) := 'FIELD2';
206: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
207:
208: IF g_debug THEN
209: hr_utility.trace('====================================================================');
210: hr_utility.trace('p_message_name '||p_message_name);
211: hr_utility.trace('====================================================================');
212: END IF;
213:
206: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
207:
208: IF g_debug THEN
209: hr_utility.trace('====================================================================');
210: hr_utility.trace('p_message_name '||p_message_name);
211: hr_utility.trace('====================================================================');
212: END IF;
213:
214: RETURN;
207:
208: IF g_debug THEN
209: hr_utility.trace('====================================================================');
210: hr_utility.trace('p_message_name '||p_message_name);
211: hr_utility.trace('====================================================================');
212: END IF;
213:
214: RETURN;
215: END IF;
224: p_token_name(3) := 'FIELD2';
225: p_token_value(3) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
226:
227: IF g_debug THEN
228: hr_utility.trace('====================================================================');
229: hr_utility.trace('p_message_name '||p_message_name);
230: hr_utility.trace('====================================================================');
231: END IF;
232:
225: p_token_value(3) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
226:
227: IF g_debug THEN
228: hr_utility.trace('====================================================================');
229: hr_utility.trace('p_message_name '||p_message_name);
230: hr_utility.trace('====================================================================');
231: END IF;
232:
233: RETURN;
226:
227: IF g_debug THEN
228: hr_utility.trace('====================================================================');
229: hr_utility.trace('p_message_name '||p_message_name);
230: hr_utility.trace('====================================================================');
231: END IF;
232:
233: RETURN;
234: END IF;
243: p_token_name(3) := 'FIELD2';
244: p_token_value(3) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
245:
246: IF g_debug THEN
247: hr_utility.trace('====================================================================');
248: hr_utility.trace('p_message_name '||p_message_name);
249: hr_utility.trace('====================================================================');
250: END IF;
251:
244: p_token_value(3) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
245:
246: IF g_debug THEN
247: hr_utility.trace('====================================================================');
248: hr_utility.trace('p_message_name '||p_message_name);
249: hr_utility.trace('====================================================================');
250: END IF;
251:
252: RETURN;
245:
246: IF g_debug THEN
247: hr_utility.trace('====================================================================');
248: hr_utility.trace('p_message_name '||p_message_name);
249: hr_utility.trace('====================================================================');
250: END IF;
251:
252: RETURN;
253: END IF;
305: l_stat_upd_eff_date DATE := TO_DATE('01-01-2006', 'DD-MM-YYYY');
306:
307: BEGIN
308: l_procedure := g_package||'check_eff_date';
309: g_debug := hr_utility.debug_enabled;
310: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
311:
312: IF g_debug THEN
313: hr_utility.trace('====================================================================');
309: g_debug := hr_utility.debug_enabled;
310: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
311:
312: IF g_debug THEN
313: hr_utility.trace('====================================================================');
314: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
315: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
316: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
317: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
310: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
311:
312: IF g_debug THEN
313: hr_utility.trace('====================================================================');
314: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
315: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
316: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
317: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
318: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
311:
312: IF g_debug THEN
313: hr_utility.trace('====================================================================');
314: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
315: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
316: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
317: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
318: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
319: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
312: IF g_debug THEN
313: hr_utility.trace('====================================================================');
314: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
315: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
316: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
317: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
318: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
319: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
320: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
313: hr_utility.trace('====================================================================');
314: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
315: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
316: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
317: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
318: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
319: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
320: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
321: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
314: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
315: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
316: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
317: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
318: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
319: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
320: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
321: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
322: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
315: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
316: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
317: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
318: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
319: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
320: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
321: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
322: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
323: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
316: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
317: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
318: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
319: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
320: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
321: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
322: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
323: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
324: hr_utility.trace('====================================================================');
317: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
318: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
319: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
320: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
321: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
322: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
323: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
324: hr_utility.trace('====================================================================');
325: END IF;
318: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
319: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
320: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
321: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
322: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
323: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
324: hr_utility.trace('====================================================================');
325: END IF;
326:
319: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
320: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
321: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
322: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
323: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
324: hr_utility.trace('====================================================================');
325: END IF;
326:
327: IF ((p_entry_information2 IS NOT NULL OR
320: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
321: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
322: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
323: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
324: hr_utility.trace('====================================================================');
325: END IF;
326:
327: IF ((p_entry_information2 IS NOT NULL OR
328: p_entry_information3 IS NOT NULL OR
339: p_token_name(1) := 'DATE';
340: p_token_value(1) := fnd_date.date_to_displaydate(l_stat_upd_eff_date);
341:
342: IF g_debug THEN
343: hr_utility.trace('====================================================================');
344: hr_utility.trace('p_message_name '||p_message_name);
345: hr_utility.trace('====================================================================');
346: END IF;
347:
340: p_token_value(1) := fnd_date.date_to_displaydate(l_stat_upd_eff_date);
341:
342: IF g_debug THEN
343: hr_utility.trace('====================================================================');
344: hr_utility.trace('p_message_name '||p_message_name);
345: hr_utility.trace('====================================================================');
346: END IF;
347:
348: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,40);
341:
342: IF g_debug THEN
343: hr_utility.trace('====================================================================');
344: hr_utility.trace('p_message_name '||p_message_name);
345: hr_utility.trace('====================================================================');
346: END IF;
347:
348: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,40);
349: RETURN;
433: l_element_name VARCHAR2(100);
434:
435: BEGIN
436: l_procedure := g_package||'check_entry_value_int';
437: g_debug := hr_utility.debug_enabled;
438: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
439:
440: IF g_debug THEN
441: hr_utility.trace('====================================================================');
437: g_debug := hr_utility.debug_enabled;
438: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
439:
440: IF g_debug THEN
441: hr_utility.trace('====================================================================');
442: hr_utility.trace('p_effective_date '||p_effective_date );
443: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
444: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
445: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
438: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
439:
440: IF g_debug THEN
441: hr_utility.trace('====================================================================');
442: hr_utility.trace('p_effective_date '||p_effective_date );
443: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
444: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
445: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
446: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
439:
440: IF g_debug THEN
441: hr_utility.trace('====================================================================');
442: hr_utility.trace('p_effective_date '||p_effective_date );
443: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
444: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
445: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
446: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
447: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
440: IF g_debug THEN
441: hr_utility.trace('====================================================================');
442: hr_utility.trace('p_effective_date '||p_effective_date );
443: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
444: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
445: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
446: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
447: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
448: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
441: hr_utility.trace('====================================================================');
442: hr_utility.trace('p_effective_date '||p_effective_date );
443: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
444: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
445: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
446: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
447: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
448: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
449: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
442: hr_utility.trace('p_effective_date '||p_effective_date );
443: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
444: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
445: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
446: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
447: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
448: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
449: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
450: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
443: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
444: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
445: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
446: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
447: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
448: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
449: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
450: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
451: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
444: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
445: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
446: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
447: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
448: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
449: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
450: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
451: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
452: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
445: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
446: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
447: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
448: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
449: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
450: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
451: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
452: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
453: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
446: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
447: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
448: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
449: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
450: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
451: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
452: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
453: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
454: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
447: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
448: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
449: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
450: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
451: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
452: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
453: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
454: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
455: hr_utility.trace('====================================================================');
448: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
449: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
450: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
451: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
452: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
453: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
454: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
455: hr_utility.trace('====================================================================');
456: END IF;
449: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
450: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
451: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
452: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
453: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
454: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
455: hr_utility.trace('====================================================================');
456: END IF;
457: --
450: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
451: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
452: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
453: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
454: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
455: hr_utility.trace('====================================================================');
456: END IF;
457: --
458: -- Code to check if the element will have phf and si further element info enabled
451: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
452: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
453: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
454: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
455: hr_utility.trace('====================================================================');
456: END IF;
457: --
458: -- Code to check if the element will have phf and si further element info enabled
459: --
484: p_token_name(1) := 'ELEMENT';
485: p_token_value(1) := l_element_name;
486:
487: IF g_debug THEN
488: hr_utility.trace('====================================================================');
489: hr_utility.trace('p_message_name '||p_message_name);
490: hr_utility.trace('====================================================================');
491: END IF;
492: END IF;
485: p_token_value(1) := l_element_name;
486:
487: IF g_debug THEN
488: hr_utility.trace('====================================================================');
489: hr_utility.trace('p_message_name '||p_message_name);
490: hr_utility.trace('====================================================================');
491: END IF;
492: END IF;
493:
486:
487: IF g_debug THEN
488: hr_utility.trace('====================================================================');
489: hr_utility.trace('p_message_name '||p_message_name);
490: hr_utility.trace('====================================================================');
491: END IF;
492: END IF;
493:
494: ELSIF (l_check_element = 1) THEN
507: ,p_token_name => p_token_name
508: ,p_token_value => p_token_value
509: );
510: IF g_debug THEN
511: hr_utility.trace('====================================================================');
512: hr_utility.trace('p_message_name '||p_message_name);
513: hr_utility.trace('====================================================================');
514: END IF;
515:
508: ,p_token_value => p_token_value
509: );
510: IF g_debug THEN
511: hr_utility.trace('====================================================================');
512: hr_utility.trace('p_message_name '||p_message_name);
513: hr_utility.trace('====================================================================');
514: END IF;
515:
516: check_eff_date(
509: );
510: IF g_debug THEN
511: hr_utility.trace('====================================================================');
512: hr_utility.trace('p_message_name '||p_message_name);
513: hr_utility.trace('====================================================================');
514: END IF;
515:
516: check_eff_date(
517: p_effective_date => p_effective_date
529: ,p_token_name => p_token_name
530: ,p_token_value => p_token_value
531: );
532: IF g_debug THEN
533: hr_utility.trace('====================================================================');
534: hr_utility.trace('p_message_name '||p_message_name);
535: hr_utility.trace('====================================================================');
536: END IF;
537:
530: ,p_token_value => p_token_value
531: );
532: IF g_debug THEN
533: hr_utility.trace('====================================================================');
534: hr_utility.trace('p_message_name '||p_message_name);
535: hr_utility.trace('====================================================================');
536: END IF;
537:
538: END IF;
531: );
532: IF g_debug THEN
533: hr_utility.trace('====================================================================');
534: hr_utility.trace('p_message_name '||p_message_name);
535: hr_utility.trace('====================================================================');
536: END IF;
537:
538: END IF;
539: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,40);
588: --
589: BEGIN
590: --
591: l_procedure := g_package||'check_entry_value';
592: g_debug := hr_utility.debug_enabled;
593: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
594:
595: IF g_debug THEN
596: hr_utility.trace('====================================================================');
592: g_debug := hr_utility.debug_enabled;
593: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
594:
595: IF g_debug THEN
596: hr_utility.trace('====================================================================');
597: hr_utility.trace('p_effective_date '||p_effective_date );
598: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
599: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
600: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
593: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
594:
595: IF g_debug THEN
596: hr_utility.trace('====================================================================');
597: hr_utility.trace('p_effective_date '||p_effective_date );
598: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
599: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
600: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
601: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
594:
595: IF g_debug THEN
596: hr_utility.trace('====================================================================');
597: hr_utility.trace('p_effective_date '||p_effective_date );
598: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
599: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
600: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
601: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
602: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
595: IF g_debug THEN
596: hr_utility.trace('====================================================================');
597: hr_utility.trace('p_effective_date '||p_effective_date );
598: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
599: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
600: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
601: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
602: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
603: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
596: hr_utility.trace('====================================================================');
597: hr_utility.trace('p_effective_date '||p_effective_date );
598: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
599: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
600: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
601: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
602: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
603: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
604: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
597: hr_utility.trace('p_effective_date '||p_effective_date );
598: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
599: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
600: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
601: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
602: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
603: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
604: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
605: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
598: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
599: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
600: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
601: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
602: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
603: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
604: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
605: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
606: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
599: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
600: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
601: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
602: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
603: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
604: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
605: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
606: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
607: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
600: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
601: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
602: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
603: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
604: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
605: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
606: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
607: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
608: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
601: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
602: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
603: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
604: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
605: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
606: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
607: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
608: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
609: hr_utility.trace('====================================================================');
602: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
603: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
604: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
605: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
606: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
607: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
608: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
609: hr_utility.trace('====================================================================');
610: END IF;
603: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
604: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
605: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
606: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
607: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
608: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
609: hr_utility.trace('====================================================================');
610: END IF;
611:
604: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
605: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
606: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
607: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
608: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
609: hr_utility.trace('====================================================================');
610: END IF;
611:
612: g_message_name := 'SUCCESS';
605: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
606: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
607: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
608: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
609: hr_utility.trace('====================================================================');
610: END IF;
611:
612: g_message_name := 'SUCCESS';
613: --
612: g_message_name := 'SUCCESS';
613: --
614: -- Check whether PAY is installed for China Localization
615: --
616: IF hr_utility.chk_product_install('Oracle Payroll','CN') THEN
617:
618: hr_cn_api.set_location(g_debug,l_procedure,20);
619:
620: check_entry_value_int(p_effective_date => p_effective_date
635: ,p_token_value => g_token_value
636: );
637: --
638: IF g_debug THEN
639: hr_utility.trace('====================================================================');
640: hr_utility.trace('g_message_name '||g_message_name );
641: hr_utility.trace('====================================================================');
642: END IF;
643:
636: );
637: --
638: IF g_debug THEN
639: hr_utility.trace('====================================================================');
640: hr_utility.trace('g_message_name '||g_message_name );
641: hr_utility.trace('====================================================================');
642: END IF;
643:
644: IF g_message_name <> 'SUCCESS' THEN
637: --
638: IF g_debug THEN
639: hr_utility.trace('====================================================================');
640: hr_utility.trace('g_message_name '||g_message_name );
641: hr_utility.trace('====================================================================');
642: END IF;
643:
644: IF g_message_name <> 'SUCCESS' THEN
645: hr_cn_api.set_location(g_debug,l_procedure,30);