55: l_procedure VARCHAR2(100);
56: BEGIN
57:
58: l_procedure := g_package||'check_ee_phf_si_setup';
59: g_debug := hr_utility.debug_enabled;
60: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
61:
62: IF g_debug THEN
63: hr_utility.trace('====================================================================');
59: g_debug := hr_utility.debug_enabled;
60: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
61:
62: IF g_debug THEN
63: hr_utility.trace('====================================================================');
64: hr_utility.trace('p_message_name '||p_message_name);
65: hr_utility.trace('====================================================================');
66: END IF;
67:
60: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
61:
62: IF g_debug THEN
63: hr_utility.trace('====================================================================');
64: hr_utility.trace('p_message_name '||p_message_name);
65: hr_utility.trace('====================================================================');
66: END IF;
67:
68: IF g_debug THEN
61:
62: IF g_debug THEN
63: hr_utility.trace('====================================================================');
64: hr_utility.trace('p_message_name '||p_message_name);
65: hr_utility.trace('====================================================================');
66: END IF;
67:
68: IF g_debug THEN
69: hr_utility.trace('====================================================================');
65: hr_utility.trace('====================================================================');
66: END IF;
67:
68: IF g_debug THEN
69: hr_utility.trace('====================================================================');
70: hr_utility.trace('p_entry_information2 '||p_entry_information2);
71: hr_utility.trace('p_entry_information3 '||p_entry_information3);
72: hr_utility.trace('p_entry_information4 '||p_entry_information4);
73: hr_utility.trace('p_entry_information5 '||p_entry_information5);
66: END IF;
67:
68: IF g_debug THEN
69: hr_utility.trace('====================================================================');
70: hr_utility.trace('p_entry_information2 '||p_entry_information2);
71: hr_utility.trace('p_entry_information3 '||p_entry_information3);
72: hr_utility.trace('p_entry_information4 '||p_entry_information4);
73: hr_utility.trace('p_entry_information5 '||p_entry_information5);
74: hr_utility.trace('p_entry_information6 '||p_entry_information6);
67:
68: IF g_debug THEN
69: hr_utility.trace('====================================================================');
70: hr_utility.trace('p_entry_information2 '||p_entry_information2);
71: hr_utility.trace('p_entry_information3 '||p_entry_information3);
72: hr_utility.trace('p_entry_information4 '||p_entry_information4);
73: hr_utility.trace('p_entry_information5 '||p_entry_information5);
74: hr_utility.trace('p_entry_information6 '||p_entry_information6);
75: hr_utility.trace('p_entry_information7 '||p_entry_information7);
68: IF g_debug THEN
69: hr_utility.trace('====================================================================');
70: hr_utility.trace('p_entry_information2 '||p_entry_information2);
71: hr_utility.trace('p_entry_information3 '||p_entry_information3);
72: hr_utility.trace('p_entry_information4 '||p_entry_information4);
73: hr_utility.trace('p_entry_information5 '||p_entry_information5);
74: hr_utility.trace('p_entry_information6 '||p_entry_information6);
75: hr_utility.trace('p_entry_information7 '||p_entry_information7);
76: hr_utility.trace('p_entry_information8 '||p_entry_information8);
69: hr_utility.trace('====================================================================');
70: hr_utility.trace('p_entry_information2 '||p_entry_information2);
71: hr_utility.trace('p_entry_information3 '||p_entry_information3);
72: hr_utility.trace('p_entry_information4 '||p_entry_information4);
73: hr_utility.trace('p_entry_information5 '||p_entry_information5);
74: hr_utility.trace('p_entry_information6 '||p_entry_information6);
75: hr_utility.trace('p_entry_information7 '||p_entry_information7);
76: hr_utility.trace('p_entry_information8 '||p_entry_information8);
77: hr_utility.trace('p_entry_information9 '||p_entry_information9);
70: hr_utility.trace('p_entry_information2 '||p_entry_information2);
71: hr_utility.trace('p_entry_information3 '||p_entry_information3);
72: hr_utility.trace('p_entry_information4 '||p_entry_information4);
73: hr_utility.trace('p_entry_information5 '||p_entry_information5);
74: hr_utility.trace('p_entry_information6 '||p_entry_information6);
75: hr_utility.trace('p_entry_information7 '||p_entry_information7);
76: hr_utility.trace('p_entry_information8 '||p_entry_information8);
77: hr_utility.trace('p_entry_information9 '||p_entry_information9);
78: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
71: hr_utility.trace('p_entry_information3 '||p_entry_information3);
72: hr_utility.trace('p_entry_information4 '||p_entry_information4);
73: hr_utility.trace('p_entry_information5 '||p_entry_information5);
74: hr_utility.trace('p_entry_information6 '||p_entry_information6);
75: hr_utility.trace('p_entry_information7 '||p_entry_information7);
76: hr_utility.trace('p_entry_information8 '||p_entry_information8);
77: hr_utility.trace('p_entry_information9 '||p_entry_information9);
78: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
79: hr_utility.trace('====================================================================');
72: hr_utility.trace('p_entry_information4 '||p_entry_information4);
73: hr_utility.trace('p_entry_information5 '||p_entry_information5);
74: hr_utility.trace('p_entry_information6 '||p_entry_information6);
75: hr_utility.trace('p_entry_information7 '||p_entry_information7);
76: hr_utility.trace('p_entry_information8 '||p_entry_information8);
77: hr_utility.trace('p_entry_information9 '||p_entry_information9);
78: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
79: hr_utility.trace('====================================================================');
80: END IF;
73: hr_utility.trace('p_entry_information5 '||p_entry_information5);
74: hr_utility.trace('p_entry_information6 '||p_entry_information6);
75: hr_utility.trace('p_entry_information7 '||p_entry_information7);
76: hr_utility.trace('p_entry_information8 '||p_entry_information8);
77: hr_utility.trace('p_entry_information9 '||p_entry_information9);
78: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
79: hr_utility.trace('====================================================================');
80: END IF;
81:
74: hr_utility.trace('p_entry_information6 '||p_entry_information6);
75: hr_utility.trace('p_entry_information7 '||p_entry_information7);
76: hr_utility.trace('p_entry_information8 '||p_entry_information8);
77: hr_utility.trace('p_entry_information9 '||p_entry_information9);
78: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
79: hr_utility.trace('====================================================================');
80: END IF;
81:
82: IF (p_entry_information2 IS NOT NULL AND p_entry_information3 IS NULL) THEN
75: hr_utility.trace('p_entry_information7 '||p_entry_information7);
76: hr_utility.trace('p_entry_information8 '||p_entry_information8);
77: hr_utility.trace('p_entry_information9 '||p_entry_information9);
78: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
79: hr_utility.trace('====================================================================');
80: END IF;
81:
82: IF (p_entry_information2 IS NOT NULL AND p_entry_information3 IS NULL) THEN
83: hr_cn_api.set_location(g_debug,l_procedure,20);
87: p_token_name(2) := 'FIELD2';
88: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
89:
90: IF g_debug THEN
91: hr_utility.trace('====================================================================');
92: hr_utility.trace('p_message_name '||p_message_name);
93: hr_utility.trace('====================================================================');
94: END IF;
95: /* Raised error message for bug 8838185 */
88: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
89:
90: IF g_debug THEN
91: hr_utility.trace('====================================================================');
92: hr_utility.trace('p_message_name '||p_message_name);
93: hr_utility.trace('====================================================================');
94: END IF;
95: /* Raised error message for bug 8838185 */
96: hr_cn_api.raise_message(800
89:
90: IF g_debug THEN
91: hr_utility.trace('====================================================================');
92: hr_utility.trace('p_message_name '||p_message_name);
93: hr_utility.trace('====================================================================');
94: END IF;
95: /* Raised error message for bug 8838185 */
96: hr_cn_api.raise_message(800
97: ,p_message_name
107: p_token_name(2) := 'FIELD2';
108: 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');
109:
110: IF g_debug THEN
111: hr_utility.trace('====================================================================');
112: hr_utility.trace('p_message_name '||p_message_name);
113: hr_utility.trace('====================================================================');
114: END IF;
115: /* Raised error message for bug 8838185 */
108: 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');
109:
110: IF g_debug THEN
111: hr_utility.trace('====================================================================');
112: hr_utility.trace('p_message_name '||p_message_name);
113: hr_utility.trace('====================================================================');
114: END IF;
115: /* Raised error message for bug 8838185 */
116: hr_cn_api.raise_message(800
109:
110: IF g_debug THEN
111: hr_utility.trace('====================================================================');
112: hr_utility.trace('p_message_name '||p_message_name);
113: hr_utility.trace('====================================================================');
114: END IF;
115: /* Raised error message for bug 8838185 */
116: hr_cn_api.raise_message(800
117: ,p_message_name
127: p_token_name(2) := 'FIELD2';
128: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
129:
130: IF g_debug THEN
131: hr_utility.trace('====================================================================');
132: hr_utility.trace('p_message_name '||p_message_name);
133: hr_utility.trace('====================================================================');
134: END IF;
135: /* Raised error message for bug 8838185 */
128: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
129:
130: IF g_debug THEN
131: hr_utility.trace('====================================================================');
132: hr_utility.trace('p_message_name '||p_message_name);
133: hr_utility.trace('====================================================================');
134: END IF;
135: /* Raised error message for bug 8838185 */
136: hr_cn_api.raise_message(800
129:
130: IF g_debug THEN
131: hr_utility.trace('====================================================================');
132: hr_utility.trace('p_message_name '||p_message_name);
133: hr_utility.trace('====================================================================');
134: END IF;
135: /* Raised error message for bug 8838185 */
136: hr_cn_api.raise_message(800
137: ,p_message_name
147: p_token_name(2) := 'FIELD2';
148: 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');
149:
150: IF g_debug THEN
151: hr_utility.trace('====================================================================');
152: hr_utility.trace('p_message_name '||p_message_name);
153: hr_utility.trace('====================================================================');
154: END IF;
155: /* Raised error message for bug 8838185 */
148: 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');
149:
150: IF g_debug THEN
151: hr_utility.trace('====================================================================');
152: hr_utility.trace('p_message_name '||p_message_name);
153: hr_utility.trace('====================================================================');
154: END IF;
155: /* Raised error message for bug 8838185 */
156: hr_cn_api.raise_message(800
149:
150: IF g_debug THEN
151: hr_utility.trace('====================================================================');
152: hr_utility.trace('p_message_name '||p_message_name);
153: hr_utility.trace('====================================================================');
154: END IF;
155: /* Raised error message for bug 8838185 */
156: hr_cn_api.raise_message(800
157: ,p_message_name
167: p_token_name(2) := 'FIELD2';
168: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
169:
170: IF g_debug THEN
171: hr_utility.trace('====================================================================');
172: hr_utility.trace('p_message_name '||p_message_name);
173: hr_utility.trace('====================================================================');
174: END IF;
175: /* Raised error message for bug 8838185 */
168: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
169:
170: IF g_debug THEN
171: hr_utility.trace('====================================================================');
172: hr_utility.trace('p_message_name '||p_message_name);
173: hr_utility.trace('====================================================================');
174: END IF;
175: /* Raised error message for bug 8838185 */
176: hr_cn_api.raise_message(800
169:
170: IF g_debug THEN
171: hr_utility.trace('====================================================================');
172: hr_utility.trace('p_message_name '||p_message_name);
173: hr_utility.trace('====================================================================');
174: END IF;
175: /* Raised error message for bug 8838185 */
176: hr_cn_api.raise_message(800
177: ,p_message_name
187: p_token_name(2) := 'FIELD2';
188: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
189:
190: IF g_debug THEN
191: hr_utility.trace('====================================================================');
192: hr_utility.trace('p_message_name '||p_message_name);
193: hr_utility.trace('====================================================================');
194: END IF;
195: /* Raised error message for bug 8838185 */
188: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
189:
190: IF g_debug THEN
191: hr_utility.trace('====================================================================');
192: hr_utility.trace('p_message_name '||p_message_name);
193: hr_utility.trace('====================================================================');
194: END IF;
195: /* Raised error message for bug 8838185 */
196: hr_cn_api.raise_message(800
189:
190: IF g_debug THEN
191: hr_utility.trace('====================================================================');
192: hr_utility.trace('p_message_name '||p_message_name);
193: hr_utility.trace('====================================================================');
194: END IF;
195: /* Raised error message for bug 8838185 */
196: hr_cn_api.raise_message(800
197: ,p_message_name
207: p_token_name(2) := 'FIELD2';
208: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
209:
210: IF g_debug THEN
211: hr_utility.trace('====================================================================');
212: hr_utility.trace('p_message_name '||p_message_name);
213: hr_utility.trace('====================================================================');
214: END IF;
215: /* Raised error message for bug 8838185 */
208: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
209:
210: IF g_debug THEN
211: hr_utility.trace('====================================================================');
212: hr_utility.trace('p_message_name '||p_message_name);
213: hr_utility.trace('====================================================================');
214: END IF;
215: /* Raised error message for bug 8838185 */
216: hr_cn_api.raise_message(800
209:
210: IF g_debug THEN
211: hr_utility.trace('====================================================================');
212: hr_utility.trace('p_message_name '||p_message_name);
213: hr_utility.trace('====================================================================');
214: END IF;
215: /* Raised error message for bug 8838185 */
216: hr_cn_api.raise_message(800
217: ,p_message_name
227: p_token_name(2) := 'FIELD2';
228: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
229:
230: IF g_debug THEN
231: hr_utility.trace('====================================================================');
232: hr_utility.trace('p_message_name '||p_message_name);
233: hr_utility.trace('====================================================================');
234: END IF;
235: /* Raised error message for bug 8838185 */
228: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
229:
230: IF g_debug THEN
231: hr_utility.trace('====================================================================');
232: hr_utility.trace('p_message_name '||p_message_name);
233: hr_utility.trace('====================================================================');
234: END IF;
235: /* Raised error message for bug 8838185 */
236: hr_cn_api.raise_message(800
229:
230: IF g_debug THEN
231: hr_utility.trace('====================================================================');
232: hr_utility.trace('p_message_name '||p_message_name);
233: hr_utility.trace('====================================================================');
234: END IF;
235: /* Raised error message for bug 8838185 */
236: hr_cn_api.raise_message(800
237: ,p_message_name
249: p_token_name(3) := 'FIELD2';
250: p_token_value(3) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
251:
252: IF g_debug THEN
253: hr_utility.trace('====================================================================');
254: hr_utility.trace('p_message_name '||p_message_name);
255: hr_utility.trace('====================================================================');
256: END IF;
257: /* Raised error message for bug 8838185 */
250: p_token_value(3) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
251:
252: IF g_debug THEN
253: hr_utility.trace('====================================================================');
254: hr_utility.trace('p_message_name '||p_message_name);
255: hr_utility.trace('====================================================================');
256: END IF;
257: /* Raised error message for bug 8838185 */
258: hr_cn_api.raise_message(800
251:
252: IF g_debug THEN
253: hr_utility.trace('====================================================================');
254: hr_utility.trace('p_message_name '||p_message_name);
255: hr_utility.trace('====================================================================');
256: END IF;
257: /* Raised error message for bug 8838185 */
258: hr_cn_api.raise_message(800
259: ,p_message_name
271: p_token_name(3) := 'FIELD2';
272: p_token_value(3) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
273:
274: IF g_debug THEN
275: hr_utility.trace('====================================================================');
276: hr_utility.trace('p_message_name '||p_message_name);
277: hr_utility.trace('====================================================================');
278: END IF;
279: /* Raised error message for bug 8838185 */
272: p_token_value(3) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
273:
274: IF g_debug THEN
275: hr_utility.trace('====================================================================');
276: hr_utility.trace('p_message_name '||p_message_name);
277: hr_utility.trace('====================================================================');
278: END IF;
279: /* Raised error message for bug 8838185 */
280: hr_cn_api.raise_message(800
273:
274: IF g_debug THEN
275: hr_utility.trace('====================================================================');
276: hr_utility.trace('p_message_name '||p_message_name);
277: hr_utility.trace('====================================================================');
278: END IF;
279: /* Raised error message for bug 8838185 */
280: hr_cn_api.raise_message(800
281: ,p_message_name
336: l_stat_upd_eff_date DATE := TO_DATE('01-01-2006', 'DD-MM-YYYY');
337:
338: BEGIN
339: l_procedure := g_package||'check_eff_date';
340: g_debug := hr_utility.debug_enabled;
341: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
342:
343: IF g_debug THEN
344: hr_utility.trace('====================================================================');
340: g_debug := hr_utility.debug_enabled;
341: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
342:
343: IF g_debug THEN
344: hr_utility.trace('====================================================================');
345: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
346: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
347: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
348: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
341: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
342:
343: IF g_debug THEN
344: hr_utility.trace('====================================================================');
345: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
346: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
347: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
348: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
349: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
342:
343: IF g_debug THEN
344: hr_utility.trace('====================================================================');
345: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
346: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
347: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
348: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
349: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
350: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
343: IF g_debug THEN
344: hr_utility.trace('====================================================================');
345: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
346: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
347: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
348: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
349: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
350: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
351: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
344: hr_utility.trace('====================================================================');
345: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
346: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
347: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
348: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
349: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
350: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
351: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
352: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
345: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
346: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
347: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
348: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
349: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
350: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
351: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
352: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
353: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
346: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
347: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
348: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
349: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
350: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
351: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
352: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
353: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
354: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
347: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
348: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
349: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
350: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
351: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
352: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
353: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
354: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
355: hr_utility.trace('====================================================================');
348: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
349: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
350: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
351: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
352: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
353: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
354: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
355: hr_utility.trace('====================================================================');
356: END IF;
349: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
350: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
351: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
352: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
353: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
354: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
355: hr_utility.trace('====================================================================');
356: END IF;
357:
350: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
351: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
352: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
353: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
354: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
355: hr_utility.trace('====================================================================');
356: END IF;
357:
358: IF ((p_entry_information2 IS NOT NULL OR
351: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
352: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
353: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
354: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
355: hr_utility.trace('====================================================================');
356: END IF;
357:
358: IF ((p_entry_information2 IS NOT NULL OR
359: p_entry_information3 IS NOT NULL OR
370: p_token_name(1) := 'DATE';
371: p_token_value(1) := fnd_date.date_to_displaydate(l_stat_upd_eff_date);
372:
373: IF g_debug THEN
374: hr_utility.trace('====================================================================');
375: hr_utility.trace('p_message_name '||p_message_name);
376: hr_utility.trace('====================================================================');
377: END IF;
378:
371: p_token_value(1) := fnd_date.date_to_displaydate(l_stat_upd_eff_date);
372:
373: IF g_debug THEN
374: hr_utility.trace('====================================================================');
375: hr_utility.trace('p_message_name '||p_message_name);
376: hr_utility.trace('====================================================================');
377: END IF;
378:
379: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,40);
372:
373: IF g_debug THEN
374: hr_utility.trace('====================================================================');
375: hr_utility.trace('p_message_name '||p_message_name);
376: hr_utility.trace('====================================================================');
377: END IF;
378:
379: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,40);
380: RETURN;
464: l_element_name VARCHAR2(100);
465:
466: BEGIN
467: l_procedure := g_package||'check_entry_value_int';
468: g_debug := hr_utility.debug_enabled;
469: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
470:
471: IF g_debug THEN
472: hr_utility.trace('====================================================================');
468: g_debug := hr_utility.debug_enabled;
469: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
470:
471: IF g_debug THEN
472: hr_utility.trace('====================================================================');
473: hr_utility.trace('p_effective_date '||p_effective_date );
474: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
475: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
476: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
469: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
470:
471: IF g_debug THEN
472: hr_utility.trace('====================================================================');
473: hr_utility.trace('p_effective_date '||p_effective_date );
474: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
475: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
476: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
477: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
470:
471: IF g_debug THEN
472: hr_utility.trace('====================================================================');
473: hr_utility.trace('p_effective_date '||p_effective_date );
474: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
475: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
476: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
477: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
478: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
471: IF g_debug THEN
472: hr_utility.trace('====================================================================');
473: hr_utility.trace('p_effective_date '||p_effective_date );
474: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
475: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
476: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
477: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
478: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
479: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
472: hr_utility.trace('====================================================================');
473: hr_utility.trace('p_effective_date '||p_effective_date );
474: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
475: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
476: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
477: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
478: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
479: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
480: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
473: hr_utility.trace('p_effective_date '||p_effective_date );
474: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
475: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
476: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
477: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
478: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
479: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
480: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
481: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
474: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
475: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
476: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
477: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
478: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
479: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
480: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
481: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
482: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
475: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
476: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
477: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
478: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
479: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
480: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
481: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
482: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
483: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
476: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
477: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
478: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
479: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
480: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
481: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
482: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
483: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
484: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
477: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
478: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
479: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
480: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
481: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
482: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
483: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
484: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
485: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
478: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
479: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
480: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
481: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
482: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
483: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
484: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
485: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
486: hr_utility.trace('====================================================================');
479: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
480: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
481: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
482: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
483: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
484: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
485: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
486: hr_utility.trace('====================================================================');
487: END IF;
480: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
481: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
482: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
483: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
484: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
485: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
486: hr_utility.trace('====================================================================');
487: END IF;
488: --
481: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
482: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
483: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
484: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
485: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
486: hr_utility.trace('====================================================================');
487: END IF;
488: --
489: -- Code to check if the element will have phf and si further element info enabled
482: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
483: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
484: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
485: hr_utility.trace('p_calling_procedure '||p_calling_procedure );
486: hr_utility.trace('====================================================================');
487: END IF;
488: --
489: -- Code to check if the element will have phf and si further element info enabled
490: --
515: p_token_name(1) := 'ELEMENT';
516: p_token_value(1) := l_element_name;
517:
518: IF g_debug THEN
519: hr_utility.trace('====================================================================');
520: hr_utility.trace('p_message_name '||p_message_name);
521: hr_utility.trace('====================================================================');
522: END IF;
523: END IF;
516: p_token_value(1) := l_element_name;
517:
518: IF g_debug THEN
519: hr_utility.trace('====================================================================');
520: hr_utility.trace('p_message_name '||p_message_name);
521: hr_utility.trace('====================================================================');
522: END IF;
523: END IF;
524:
517:
518: IF g_debug THEN
519: hr_utility.trace('====================================================================');
520: hr_utility.trace('p_message_name '||p_message_name);
521: hr_utility.trace('====================================================================');
522: END IF;
523: END IF;
524:
525: ELSIF (l_check_element = 1) THEN
538: ,p_token_name => p_token_name
539: ,p_token_value => p_token_value
540: );
541: IF g_debug THEN
542: hr_utility.trace('====================================================================');
543: hr_utility.trace('p_message_name '||p_message_name);
544: hr_utility.trace('====================================================================');
545: END IF;
546:
539: ,p_token_value => p_token_value
540: );
541: IF g_debug THEN
542: hr_utility.trace('====================================================================');
543: hr_utility.trace('p_message_name '||p_message_name);
544: hr_utility.trace('====================================================================');
545: END IF;
546:
547: check_eff_date(
540: );
541: IF g_debug THEN
542: hr_utility.trace('====================================================================');
543: hr_utility.trace('p_message_name '||p_message_name);
544: hr_utility.trace('====================================================================');
545: END IF;
546:
547: check_eff_date(
548: p_effective_date => p_effective_date
560: ,p_token_name => p_token_name
561: ,p_token_value => p_token_value
562: );
563: IF g_debug THEN
564: hr_utility.trace('====================================================================');
565: hr_utility.trace('p_message_name '||p_message_name);
566: hr_utility.trace('====================================================================');
567: END IF;
568:
561: ,p_token_value => p_token_value
562: );
563: IF g_debug THEN
564: hr_utility.trace('====================================================================');
565: hr_utility.trace('p_message_name '||p_message_name);
566: hr_utility.trace('====================================================================');
567: END IF;
568:
569: END IF;
562: );
563: IF g_debug THEN
564: hr_utility.trace('====================================================================');
565: hr_utility.trace('p_message_name '||p_message_name);
566: hr_utility.trace('====================================================================');
567: END IF;
568:
569: END IF;
570: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,40);
619: --
620: BEGIN
621: --
622: l_procedure := g_package||'check_entry_value';
623: g_debug := hr_utility.debug_enabled;
624: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
625:
626: IF g_debug THEN
627: hr_utility.trace('====================================================================');
623: g_debug := hr_utility.debug_enabled;
624: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
625:
626: IF g_debug THEN
627: hr_utility.trace('====================================================================');
628: hr_utility.trace('p_effective_date '||p_effective_date );
629: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
630: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
631: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
624: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
625:
626: IF g_debug THEN
627: hr_utility.trace('====================================================================');
628: hr_utility.trace('p_effective_date '||p_effective_date );
629: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
630: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
631: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
632: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
625:
626: IF g_debug THEN
627: hr_utility.trace('====================================================================');
628: hr_utility.trace('p_effective_date '||p_effective_date );
629: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
630: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
631: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
632: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
633: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
626: IF g_debug THEN
627: hr_utility.trace('====================================================================');
628: hr_utility.trace('p_effective_date '||p_effective_date );
629: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
630: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
631: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
632: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
633: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
634: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
627: hr_utility.trace('====================================================================');
628: hr_utility.trace('p_effective_date '||p_effective_date );
629: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
630: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
631: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
632: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
633: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
634: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
635: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
628: hr_utility.trace('p_effective_date '||p_effective_date );
629: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
630: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
631: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
632: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
633: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
634: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
635: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
636: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
629: hr_utility.trace('p_element_entry_id '||p_element_entry_id );
630: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
631: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
632: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
633: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
634: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
635: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
636: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
637: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
630: hr_utility.trace('p_effective_start_date'||p_effective_start_date);
631: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
632: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
633: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
634: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
635: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
636: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
637: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
638: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
631: hr_utility.trace('p_effective_end_date '||p_effective_end_date );
632: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
633: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
634: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
635: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
636: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
637: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
638: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
639: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
632: hr_utility.trace('p_entry_information2 '||p_entry_information2 );
633: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
634: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
635: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
636: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
637: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
638: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
639: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
640: hr_utility.trace('====================================================================');
633: hr_utility.trace('p_entry_information3 '||p_entry_information3 );
634: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
635: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
636: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
637: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
638: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
639: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
640: hr_utility.trace('====================================================================');
641: END IF;
634: hr_utility.trace('p_entry_information4 '||p_entry_information4 );
635: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
636: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
637: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
638: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
639: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
640: hr_utility.trace('====================================================================');
641: END IF;
642:
635: hr_utility.trace('p_entry_information5 '||p_entry_information5 );
636: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
637: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
638: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
639: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
640: hr_utility.trace('====================================================================');
641: END IF;
642:
643: g_message_name := 'SUCCESS';
636: hr_utility.trace('p_entry_information6 '||p_entry_information6 );
637: hr_utility.trace('p_entry_information7 '||p_entry_information7 );
638: hr_utility.trace('p_entry_information8 '||p_entry_information8 );
639: hr_utility.trace('p_entry_information9 '||p_entry_information9 );
640: hr_utility.trace('====================================================================');
641: END IF;
642:
643: g_message_name := 'SUCCESS';
644: --
643: g_message_name := 'SUCCESS';
644: --
645: -- Check whether PAY is installed for China Localization
646: --
647: IF hr_utility.chk_product_install('Oracle Payroll','CN') THEN
648:
649: hr_cn_api.set_location(g_debug,l_procedure,20);
650:
651: check_entry_value_int(p_effective_date => p_effective_date
666: ,p_token_value => g_token_value
667: );
668: --
669: IF g_debug THEN
670: hr_utility.trace('====================================================================');
671: hr_utility.trace('g_message_name '||g_message_name );
672: hr_utility.trace('====================================================================');
673: END IF;
674:
667: );
668: --
669: IF g_debug THEN
670: hr_utility.trace('====================================================================');
671: hr_utility.trace('g_message_name '||g_message_name );
672: hr_utility.trace('====================================================================');
673: END IF;
674:
675: IF g_message_name <> 'SUCCESS' THEN
668: --
669: IF g_debug THEN
670: hr_utility.trace('====================================================================');
671: hr_utility.trace('g_message_name '||g_message_name );
672: hr_utility.trace('====================================================================');
673: END IF;
674:
675: IF g_message_name <> 'SUCCESS' THEN
676: hr_cn_api.set_location(g_debug,l_procedure,30);