eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_IN_PERSON_TERM_LEG_HOOK dependencies on PAY_IN_UTILS

Line 10: g_token_name pay_in_utils.char_tab_type;

6: --
7: g_package constant VARCHAR2(100) := 'per_in_person_term_leg_hook.' ;
8: g_debug BOOLEAN ;
9: g_message_name VARCHAR2(30);
10: g_token_name pay_in_utils.char_tab_type;
11: g_token_value pay_in_utils.char_tab_type;
12:
13: --------------------------------------------------------------------------
14: -- --

Line 11: g_token_value pay_in_utils.char_tab_type;

7: g_package constant VARCHAR2(100) := 'per_in_person_term_leg_hook.' ;
8: g_debug BOOLEAN ;
9: g_message_name VARCHAR2(30);
10: g_token_name pay_in_utils.char_tab_type;
11: g_token_value pay_in_utils.char_tab_type;
12:
13: --------------------------------------------------------------------------
14: -- --
15: -- Name : ACTUAL_TERMINATION_EMP_INT --

Line 39: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

35: ,p_actual_termination_date IN DATE
36: ,p_business_group_id IN NUMBER
37: ,p_calling_procedure IN VARCHAR2
38: ,p_message_name OUT NOCOPY VARCHAR2
39: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
40: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
41: IS
42:
43: --

Line 40: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)

36: ,p_business_group_id IN NUMBER
37: ,p_calling_procedure IN VARCHAR2
38: ,p_message_name OUT NOCOPY VARCHAR2
39: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
40: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
41: IS
42:
43: --
44: l_procedure VARCHAR2(100);

Line 52: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

48: BEGIN
49: --
50: g_debug := hr_utility.debug_enabled ;
51: l_procedure := g_package || 'actual_termination_emp_int' ;
52: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
53:
54: if g_debug then
55: pay_in_utils.trace('******************************','********************');
56: pay_in_utils.trace('p_effective_date : ',p_effective_date);

Line 55: pay_in_utils.trace('**********','');

51: l_procedure := g_package || 'actual_termination_emp_int' ;
52: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
53:
54: if g_debug then
55: pay_in_utils.trace('******************************','********************');
56: pay_in_utils.trace('p_effective_date : ',p_effective_date);
57: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
58: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
59: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);

Line 56: pay_in_utils.trace('p_effective_date : ',p_effective_date);

52: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
53:
54: if g_debug then
55: pay_in_utils.trace('******************************','********************');
56: pay_in_utils.trace('p_effective_date : ',p_effective_date);
57: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
58: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
59: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
60: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);

Line 57: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);

53:
54: if g_debug then
55: pay_in_utils.trace('******************************','********************');
56: pay_in_utils.trace('p_effective_date : ',p_effective_date);
57: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
58: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
59: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
60: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
61: pay_in_utils.trace('******************************','********************');

Line 58: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);

54: if g_debug then
55: pay_in_utils.trace('******************************','********************');
56: pay_in_utils.trace('p_effective_date : ',p_effective_date);
57: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
58: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
59: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
60: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
61: pay_in_utils.trace('******************************','********************');
62: end if;

Line 59: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);

55: pay_in_utils.trace('******************************','********************');
56: pay_in_utils.trace('p_effective_date : ',p_effective_date);
57: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
58: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
59: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
60: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
61: pay_in_utils.trace('******************************','********************');
62: end if;
63:

Line 60: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);

56: pay_in_utils.trace('p_effective_date : ',p_effective_date);
57: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
58: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
59: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
60: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
61: pay_in_utils.trace('******************************','********************');
62: end if;
63:
64: pay_in_utils.null_message(g_token_name, g_token_value);

Line 61: pay_in_utils.trace('**********','');

57: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
58: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
59: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
60: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
61: pay_in_utils.trace('******************************','********************');
62: end if;
63:
64: pay_in_utils.null_message(g_token_name, g_token_value);
65: g_message_name := 'SUCCESS';

Line 64: pay_in_utils.null_message(g_token_name, g_token_value);

60: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
61: pay_in_utils.trace('******************************','********************');
62: end if;
63:
64: pay_in_utils.null_message(g_token_name, g_token_value);
65: g_message_name := 'SUCCESS';
66:
67: pay_in_termination_pkg.create_termination_elements
68: (p_period_of_service_id => p_period_of_service_id

Line 77: pay_in_utils.trace('**********','');

73: ,p_token_name => p_token_name
74: ,p_token_value => p_token_value);
75:
76: if g_debug then
77: pay_in_utils.trace('******************************','********************');
78: pay_in_utils.trace('p_message_name : ',p_message_name);
79: pay_in_utils.trace('******************************','********************');
80: end if;
81:

Line 78: pay_in_utils.trace('p_message_name : ',p_message_name);

74: ,p_token_value => p_token_value);
75:
76: if g_debug then
77: pay_in_utils.trace('******************************','********************');
78: pay_in_utils.trace('p_message_name : ',p_message_name);
79: pay_in_utils.trace('******************************','********************');
80: end if;
81:
82: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

Line 79: pay_in_utils.trace('**********','');

75:
76: if g_debug then
77: pay_in_utils.trace('******************************','********************');
78: pay_in_utils.trace('p_message_name : ',p_message_name);
79: pay_in_utils.trace('******************************','********************');
80: end if;
81:
82: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
83:

Line 82: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

78: pay_in_utils.trace('p_message_name : ',p_message_name);
79: pay_in_utils.trace('******************************','********************');
80: end if;
81:
82: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
83:
84: --
85: END actual_termination_emp_int ;
86:

Line 113: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

109: ,p_actual_termination_date IN DATE
110: ,p_business_group_id IN NUMBER
111: ,p_calling_procedure IN VARCHAR2
112: ,p_message_name OUT NOCOPY VARCHAR2
113: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
114: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
115: )
116: IS
117: l_procedure VARCHAR2(100);

Line 114: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type

110: ,p_business_group_id IN NUMBER
111: ,p_calling_procedure IN VARCHAR2
112: ,p_message_name OUT NOCOPY VARCHAR2
113: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
114: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
115: )
116: IS
117: l_procedure VARCHAR2(100);
118: l_message VARCHAR2(255);

Line 124: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

120: BEGIN
121: --
122: g_debug := hr_utility.debug_enabled ;
123: l_procedure := g_package || 'reverse_termination_emp_int' ;
124: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
125:
126: if g_debug then
127: pay_in_utils.trace('******************************','********************');
128: pay_in_utils.trace('p_effective_date : ',p_effective_date);

Line 127: pay_in_utils.trace('**********','');

123: l_procedure := g_package || 'reverse_termination_emp_int' ;
124: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
125:
126: if g_debug then
127: pay_in_utils.trace('******************************','********************');
128: pay_in_utils.trace('p_effective_date : ',p_effective_date);
129: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
130: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
131: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);

Line 128: pay_in_utils.trace('p_effective_date : ',p_effective_date);

124: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
125:
126: if g_debug then
127: pay_in_utils.trace('******************************','********************');
128: pay_in_utils.trace('p_effective_date : ',p_effective_date);
129: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
130: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
131: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
132: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);

Line 129: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);

125:
126: if g_debug then
127: pay_in_utils.trace('******************************','********************');
128: pay_in_utils.trace('p_effective_date : ',p_effective_date);
129: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
130: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
131: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
132: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
133: pay_in_utils.trace('******************************','********************');

Line 130: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);

126: if g_debug then
127: pay_in_utils.trace('******************************','********************');
128: pay_in_utils.trace('p_effective_date : ',p_effective_date);
129: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
130: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
131: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
132: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
133: pay_in_utils.trace('******************************','********************');
134: end if;

Line 131: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);

127: pay_in_utils.trace('******************************','********************');
128: pay_in_utils.trace('p_effective_date : ',p_effective_date);
129: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
130: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
131: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
132: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
133: pay_in_utils.trace('******************************','********************');
134: end if;
135:

Line 132: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);

128: pay_in_utils.trace('p_effective_date : ',p_effective_date);
129: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
130: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
131: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
132: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
133: pay_in_utils.trace('******************************','********************');
134: end if;
135:
136: pay_in_utils.null_message(g_token_name, g_token_value);

Line 133: pay_in_utils.trace('**********','');

129: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
130: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
131: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
132: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
133: pay_in_utils.trace('******************************','********************');
134: end if;
135:
136: pay_in_utils.null_message(g_token_name, g_token_value);
137: g_message_name := 'SUCCESS';

Line 136: pay_in_utils.null_message(g_token_name, g_token_value);

132: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
133: pay_in_utils.trace('******************************','********************');
134: end if;
135:
136: pay_in_utils.null_message(g_token_name, g_token_value);
137: g_message_name := 'SUCCESS';
138:
139: pay_in_termination_pkg.delete_termination_elements
140: (p_period_of_service_id => p_period_of_service_id

Line 149: pay_in_utils.trace('**********','');

145: ,p_token_name => p_token_name
146: ,p_token_value => p_token_value);
147:
148: if g_debug then
149: pay_in_utils.trace('******************************','********************');
150: pay_in_utils.trace('p_message_name : ',p_message_name);
151: pay_in_utils.trace('******************************','********************');
152: end if;
153:

Line 150: pay_in_utils.trace('p_message_name : ',p_message_name);

146: ,p_token_value => p_token_value);
147:
148: if g_debug then
149: pay_in_utils.trace('******************************','********************');
150: pay_in_utils.trace('p_message_name : ',p_message_name);
151: pay_in_utils.trace('******************************','********************');
152: end if;
153:
154: --

Line 151: pay_in_utils.trace('**********','');

147:
148: if g_debug then
149: pay_in_utils.trace('******************************','********************');
150: pay_in_utils.trace('p_message_name : ',p_message_name);
151: pay_in_utils.trace('******************************','********************');
152: end if;
153:
154: --
155: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

Line 155: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

151: pay_in_utils.trace('******************************','********************');
152: end if;
153:
154: --
155: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
156:
157: --
158: END reverse_termination_emp_int ;
159:

Line 209: pay_in_utils.set_location(g_debug,'Entering: '|| l_procedure,10);

205: --
206:
207: g_debug := hr_utility.debug_enabled ;
208: l_procedure := g_package || 'actual_termination_emp';
209: pay_in_utils.set_location(g_debug,'Entering: '|| l_procedure,10);
210:
211: IF g_debug
212: THEN
213: pay_in_utils.trace('******************************','********************');

Line 213: pay_in_utils.trace('**********','');

209: pay_in_utils.set_location(g_debug,'Entering: '|| l_procedure,10);
210:
211: IF g_debug
212: THEN
213: pay_in_utils.trace('******************************','********************');
214: pay_in_utils.trace('p_effective_date : ',p_effective_date);
215: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
216: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
217: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);

Line 214: pay_in_utils.trace('p_effective_date : ',p_effective_date);

210:
211: IF g_debug
212: THEN
213: pay_in_utils.trace('******************************','********************');
214: pay_in_utils.trace('p_effective_date : ',p_effective_date);
215: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
216: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
217: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
218: pay_in_utils.trace('******************************','********************');

Line 215: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);

211: IF g_debug
212: THEN
213: pay_in_utils.trace('******************************','********************');
214: pay_in_utils.trace('p_effective_date : ',p_effective_date);
215: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
216: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
217: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
218: pay_in_utils.trace('******************************','********************');
219: END IF;

Line 216: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);

212: THEN
213: pay_in_utils.trace('******************************','********************');
214: pay_in_utils.trace('p_effective_date : ',p_effective_date);
215: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
216: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
217: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
218: pay_in_utils.trace('******************************','********************');
219: END IF;
220:

Line 217: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);

213: pay_in_utils.trace('******************************','********************');
214: pay_in_utils.trace('p_effective_date : ',p_effective_date);
215: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
216: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
217: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
218: pay_in_utils.trace('******************************','********************');
219: END IF;
220:
221: OPEN c_pds_details;

Line 218: pay_in_utils.trace('**********','');

214: pay_in_utils.trace('p_effective_date : ',p_effective_date);
215: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
216: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
217: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
218: pay_in_utils.trace('******************************','********************');
219: END IF;
220:
221: OPEN c_pds_details;
222: FETCH c_pds_details INTO l_final_process_date,l_actual_termination_date;

Line 225: pay_in_utils.trace('l_final_process_date : ',l_final_process_date);

221: OPEN c_pds_details;
222: FETCH c_pds_details INTO l_final_process_date,l_actual_termination_date;
223: CLOSE c_pds_details;
224:
225: pay_in_utils.trace('l_final_process_date : ',l_final_process_date);
226: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
227:
228: g_message_name := 'SUCCESS';
229: pay_in_utils.null_message (g_token_name, g_token_value);

Line 226: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);

222: FETCH c_pds_details INTO l_final_process_date,l_actual_termination_date;
223: CLOSE c_pds_details;
224:
225: pay_in_utils.trace('l_final_process_date : ',l_final_process_date);
226: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
227:
228: g_message_name := 'SUCCESS';
229: pay_in_utils.null_message (g_token_name, g_token_value);
230: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN

Line 229: pay_in_utils.null_message (g_token_name, g_token_value);

225: pay_in_utils.trace('l_final_process_date : ',l_final_process_date);
226: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
227:
228: g_message_name := 'SUCCESS';
229: pay_in_utils.null_message (g_token_name, g_token_value);
230: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
231: IF (l_final_process_date IS NULL)
232: THEN
233: actual_termination_emp_int

Line 245: pay_in_utils.set_location(g_debug,'Leaving: '|| l_procedure,30);

241: ,p_token_value => g_token_value
242: ) ;
243: END IF;
244: END IF;
245: pay_in_utils.set_location(g_debug,'Leaving: '|| l_procedure,30);
246: RETURN;
247: END actual_termination_emp ;
248:
249: --------------------------------------------------------------------------

Line 293: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

289: --
290: g_debug := hr_utility.debug_enabled ;
291:
292: l_procedure := g_package || 'final_process_emp' ;
293: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
294:
295: if g_debug then
296: pay_in_utils.trace('******************************','********************');
297: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);

Line 296: pay_in_utils.trace('**********','');

292: l_procedure := g_package || 'final_process_emp' ;
293: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
294:
295: if g_debug then
296: pay_in_utils.trace('******************************','********************');
297: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
298: pay_in_utils.trace('******************************','********************');
299: end if;
300:

Line 297: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);

293: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
294:
295: if g_debug then
296: pay_in_utils.trace('******************************','********************');
297: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
298: pay_in_utils.trace('******************************','********************');
299: end if;
300:
301: g_message_name := 'SUCCESS';

Line 298: pay_in_utils.trace('**********','');

294:
295: if g_debug then
296: pay_in_utils.trace('******************************','********************');
297: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
298: pay_in_utils.trace('******************************','********************');
299: end if;
300:
301: g_message_name := 'SUCCESS';
302: pay_in_utils.null_message (g_token_name, g_token_value);

Line 302: pay_in_utils.null_message (g_token_name, g_token_value);

298: pay_in_utils.trace('******************************','********************');
299: end if;
300:
301: g_message_name := 'SUCCESS';
302: pay_in_utils.null_message (g_token_name, g_token_value);
303: --
304: -- Check if PAY is installed for India Localization
305: --
306: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN

Line 308: pay_in_utils.set_location(g_debug,l_procedure,20);

304: -- Check if PAY is installed for India Localization
305: --
306: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
307:
308: pay_in_utils.set_location(g_debug,l_procedure,20);
309:
310: OPEN c_pos_dtls;
311: FETCH c_pos_dtls
312: INTO l_business_group_id, l_actual_termination_date;

Line 317: pay_in_utils.trace('l_effective_date : ',l_effective_date);

313: CLOSE c_pos_dtls;
314:
315:
316: if g_debug then
317: pay_in_utils.trace('l_effective_date : ',l_effective_date);
318: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
319: pay_in_utils.trace('l_business_group_id : ',l_business_group_id);
320: end if;
321:

Line 318: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);

314:
315:
316: if g_debug then
317: pay_in_utils.trace('l_effective_date : ',l_effective_date);
318: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
319: pay_in_utils.trace('l_business_group_id : ',l_business_group_id);
320: end if;
321:
322: pay_in_utils.set_location(g_debug,l_procedure,25);

Line 319: pay_in_utils.trace('l_business_group_id : ',l_business_group_id);

315:
316: if g_debug then
317: pay_in_utils.trace('l_effective_date : ',l_effective_date);
318: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
319: pay_in_utils.trace('l_business_group_id : ',l_business_group_id);
320: end if;
321:
322: pay_in_utils.set_location(g_debug,l_procedure,25);
323:

Line 322: pay_in_utils.set_location(g_debug,l_procedure,25);

318: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
319: pay_in_utils.trace('l_business_group_id : ',l_business_group_id);
320: end if;
321:
322: pay_in_utils.set_location(g_debug,l_procedure,25);
323:
324: actual_termination_emp_int
325: (p_effective_date => l_effective_date
326: ,p_period_of_service_id => p_period_of_service_id

Line 338: pay_in_utils.trace('**********','');

334: --
335: END IF ;
336:
337: if g_debug then
338: pay_in_utils.trace('******************************','********************');
339: pay_in_utils.trace('g_message_name : ',g_message_name);
340: pay_in_utils.trace('******************************','********************');
341: end if;
342:

Line 339: pay_in_utils.trace('g_message_name : ',g_message_name);

335: END IF ;
336:
337: if g_debug then
338: pay_in_utils.trace('******************************','********************');
339: pay_in_utils.trace('g_message_name : ',g_message_name);
340: pay_in_utils.trace('******************************','********************');
341: end if;
342:
343: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

Line 340: pay_in_utils.trace('**********','');

336:
337: if g_debug then
338: pay_in_utils.trace('******************************','********************');
339: pay_in_utils.trace('g_message_name : ',g_message_name);
340: pay_in_utils.trace('******************************','********************');
341: end if;
342:
343: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
344: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);

Line 343: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

339: pay_in_utils.trace('g_message_name : ',g_message_name);
340: pay_in_utils.trace('******************************','********************');
341: end if;
342:
343: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
344: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
345: --
346: END final_process_emp ;
347:

Line 344: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);

340: pay_in_utils.trace('******************************','********************');
341: end if;
342:
343: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
344: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
345: --
346: END final_process_emp ;
347:
348: --------------------------------------------------------------------------

Line 382: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

378: --
379: g_debug := hr_utility.debug_enabled ;
380:
381: l_procedure := g_package || 'reverse_termination_emp' ;
382: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
383:
384: if g_debug then
385: pay_in_utils.trace('******************************','********************');
386: pay_in_utils.trace('p_effective_date : ',p_effective_date);

Line 385: pay_in_utils.trace('**********','');

381: l_procedure := g_package || 'reverse_termination_emp' ;
382: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
383:
384: if g_debug then
385: pay_in_utils.trace('******************************','********************');
386: pay_in_utils.trace('p_effective_date : ',p_effective_date);
387: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
388: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
389: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);

Line 386: pay_in_utils.trace('p_effective_date : ',p_effective_date);

382: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
383:
384: if g_debug then
385: pay_in_utils.trace('******************************','********************');
386: pay_in_utils.trace('p_effective_date : ',p_effective_date);
387: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
388: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
389: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
390: pay_in_utils.trace('******************************','********************');

Line 387: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);

383:
384: if g_debug then
385: pay_in_utils.trace('******************************','********************');
386: pay_in_utils.trace('p_effective_date : ',p_effective_date);
387: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
388: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
389: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
390: pay_in_utils.trace('******************************','********************');
391: end if;

Line 388: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);

384: if g_debug then
385: pay_in_utils.trace('******************************','********************');
386: pay_in_utils.trace('p_effective_date : ',p_effective_date);
387: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
388: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
389: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
390: pay_in_utils.trace('******************************','********************');
391: end if;
392:

Line 389: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);

385: pay_in_utils.trace('******************************','********************');
386: pay_in_utils.trace('p_effective_date : ',p_effective_date);
387: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
388: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
389: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
390: pay_in_utils.trace('******************************','********************');
391: end if;
392:
393: g_message_name := 'SUCCESS';

Line 390: pay_in_utils.trace('**********','');

386: pay_in_utils.trace('p_effective_date : ',p_effective_date);
387: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
388: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
389: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
390: pay_in_utils.trace('******************************','********************');
391: end if;
392:
393: g_message_name := 'SUCCESS';
394: pay_in_utils.null_message (g_token_name, g_token_value);

Line 394: pay_in_utils.null_message (g_token_name, g_token_value);

390: pay_in_utils.trace('******************************','********************');
391: end if;
392:
393: g_message_name := 'SUCCESS';
394: pay_in_utils.null_message (g_token_name, g_token_value);
395: --
396: -- Check if PAY is installed for India Localization
397: --
398: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN

Line 400: pay_in_utils.set_location(g_debug,l_procedure,20);

396: -- Check if PAY is installed for India Localization
397: --
398: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
399:
400: pay_in_utils.set_location(g_debug,l_procedure,20);
401:
402: reverse_termination_emp_int
403: (p_effective_date => p_effective_date
404: ,p_period_of_service_id => p_period_of_service_id

Line 416: pay_in_utils.trace('**********','');

412: --
413: END IF ;
414:
415: if g_debug then
416: pay_in_utils.trace('******************************','********************');
417: pay_in_utils.trace('g_message_name : ',g_message_name);
418: pay_in_utils.trace('******************************','********************');
419: end if;
420:

Line 417: pay_in_utils.trace('g_message_name : ',g_message_name);

413: END IF ;
414:
415: if g_debug then
416: pay_in_utils.trace('******************************','********************');
417: pay_in_utils.trace('g_message_name : ',g_message_name);
418: pay_in_utils.trace('******************************','********************');
419: end if;
420:
421: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

Line 418: pay_in_utils.trace('**********','');

414:
415: if g_debug then
416: pay_in_utils.trace('******************************','********************');
417: pay_in_utils.trace('g_message_name : ',g_message_name);
418: pay_in_utils.trace('******************************','********************');
419: end if;
420:
421: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
422: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);

Line 421: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

417: pay_in_utils.trace('g_message_name : ',g_message_name);
418: pay_in_utils.trace('******************************','********************');
419: end if;
420:
421: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
422: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
423:
424: --
425: END reverse_termination_emp ;

Line 422: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);

418: pay_in_utils.trace('******************************','********************');
419: end if;
420:
421: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
422: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
423:
424: --
425: END reverse_termination_emp ;
426:

Line 477: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

473: BEGIN
474: --
475: g_debug := hr_utility.debug_enabled ;
476: l_procedure := g_package || 'update_pds_details' ;
477: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
478:
479: if g_debug then
480: pay_in_utils.trace('******************************','********************');
481: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);

Line 480: pay_in_utils.trace('**********','');

476: l_procedure := g_package || 'update_pds_details' ;
477: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
478:
479: if g_debug then
480: pay_in_utils.trace('******************************','********************');
481: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
482: pay_in_utils.trace('p_effective_date : ',p_effective_date);
483: pay_in_utils.trace('p_leaving_reason : ',p_leaving_reason);
484: pay_in_utils.trace('******************************','********************');

Line 481: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);

477: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
478:
479: if g_debug then
480: pay_in_utils.trace('******************************','********************');
481: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
482: pay_in_utils.trace('p_effective_date : ',p_effective_date);
483: pay_in_utils.trace('p_leaving_reason : ',p_leaving_reason);
484: pay_in_utils.trace('******************************','********************');
485: end if;

Line 482: pay_in_utils.trace('p_effective_date : ',p_effective_date);

478:
479: if g_debug then
480: pay_in_utils.trace('******************************','********************');
481: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
482: pay_in_utils.trace('p_effective_date : ',p_effective_date);
483: pay_in_utils.trace('p_leaving_reason : ',p_leaving_reason);
484: pay_in_utils.trace('******************************','********************');
485: end if;
486:

Line 483: pay_in_utils.trace('p_leaving_reason : ',p_leaving_reason);

479: if g_debug then
480: pay_in_utils.trace('******************************','********************');
481: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
482: pay_in_utils.trace('p_effective_date : ',p_effective_date);
483: pay_in_utils.trace('p_leaving_reason : ',p_leaving_reason);
484: pay_in_utils.trace('******************************','********************');
485: end if;
486:
487: g_message_name := 'SUCCESS';

Line 484: pay_in_utils.trace('**********','');

480: pay_in_utils.trace('******************************','********************');
481: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
482: pay_in_utils.trace('p_effective_date : ',p_effective_date);
483: pay_in_utils.trace('p_leaving_reason : ',p_leaving_reason);
484: pay_in_utils.trace('******************************','********************');
485: end if;
486:
487: g_message_name := 'SUCCESS';
488:

Line 491: pay_in_utils.null_message (g_token_name, g_token_value);

487: g_message_name := 'SUCCESS';
488:
489: pay_in_termination_pkg.g_leaving_reason := p_leaving_reason;
490:
491: pay_in_utils.null_message (g_token_name, g_token_value);
492: --
493: -- Check if PAY is installed for India Localization
494: --
495:

Line 498: pay_in_utils.set_location(g_debug,l_procedure,20);

494: --
495:
496: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
497:
498: pay_in_utils.set_location(g_debug,l_procedure,20);
499: OPEN c_pos_dtls;
500: FETCH c_pos_dtls
501: INTO l_actual_termination_date, l_business_group_id;
502: CLOSE c_pos_dtls;

Line 505: pay_in_utils.trace('l_business_group_id : ',l_business_group_id);

501: INTO l_actual_termination_date, l_business_group_id;
502: CLOSE c_pos_dtls;
503:
504: if g_debug then
505: pay_in_utils.trace('l_business_group_id : ',l_business_group_id);
506: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
507: end if;
508:
509: pay_in_utils.set_location(g_debug,l_procedure,30);

Line 506: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);

502: CLOSE c_pos_dtls;
503:
504: if g_debug then
505: pay_in_utils.trace('l_business_group_id : ',l_business_group_id);
506: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
507: end if;
508:
509: pay_in_utils.set_location(g_debug,l_procedure,30);
510: pay_in_termination_pkg.delete_gratuity_entry

Line 509: pay_in_utils.set_location(g_debug,l_procedure,30);

505: pay_in_utils.trace('l_business_group_id : ',l_business_group_id);
506: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
507: end if;
508:
509: pay_in_utils.set_location(g_debug,l_procedure,30);
510: pay_in_termination_pkg.delete_gratuity_entry
511: (p_period_of_service_id => p_period_of_service_id
512: ,p_business_group_id => l_business_group_id
513: ,p_actual_termination_date => l_actual_termination_date

Line 521: pay_in_utils.trace('**********','');

517: ,p_token_value => g_token_value
518: );
519:
520: if g_debug then
521: pay_in_utils.trace('******************************','********************');
522: pay_in_utils.trace('g_message_name : ',g_message_name);
523: pay_in_utils.trace('******************************','********************');
524: end if;
525:

Line 522: pay_in_utils.trace('g_message_name : ',g_message_name);

518: );
519:
520: if g_debug then
521: pay_in_utils.trace('******************************','********************');
522: pay_in_utils.trace('g_message_name : ',g_message_name);
523: pay_in_utils.trace('******************************','********************');
524: end if;
525:
526: pay_in_utils.set_location(g_debug,l_procedure,40);

Line 523: pay_in_utils.trace('**********','');

519:
520: if g_debug then
521: pay_in_utils.trace('******************************','********************');
522: pay_in_utils.trace('g_message_name : ',g_message_name);
523: pay_in_utils.trace('******************************','********************');
524: end if;
525:
526: pay_in_utils.set_location(g_debug,l_procedure,40);
527: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);

Line 526: pay_in_utils.set_location(g_debug,l_procedure,40);

522: pay_in_utils.trace('g_message_name : ',g_message_name);
523: pay_in_utils.trace('******************************','********************');
524: end if;
525:
526: pay_in_utils.set_location(g_debug,l_procedure,40);
527: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
528: g_message_name := 'SUCCESS';
529: pay_in_utils.null_message (g_token_name, g_token_value);
530:

Line 527: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);

523: pay_in_utils.trace('******************************','********************');
524: end if;
525:
526: pay_in_utils.set_location(g_debug,l_procedure,40);
527: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
528: g_message_name := 'SUCCESS';
529: pay_in_utils.null_message (g_token_name, g_token_value);
530:
531:

Line 529: pay_in_utils.null_message (g_token_name, g_token_value);

525:
526: pay_in_utils.set_location(g_debug,l_procedure,40);
527: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
528: g_message_name := 'SUCCESS';
529: pay_in_utils.null_message (g_token_name, g_token_value);
530:
531:
532:
533: pay_in_termination_pkg.create_gratuity_entry

Line 544: pay_in_utils.trace('**********','');

540: ,p_token_value => g_token_value
541: );
542:
543: if g_debug then
544: pay_in_utils.trace('******************************','********************');
545: pay_in_utils.trace('g_message_name : ',g_message_name);
546: pay_in_utils.trace('******************************','********************');
547: end if;
548:

Line 545: pay_in_utils.trace('g_message_name : ',g_message_name);

541: );
542:
543: if g_debug then
544: pay_in_utils.trace('******************************','********************');
545: pay_in_utils.trace('g_message_name : ',g_message_name);
546: pay_in_utils.trace('******************************','********************');
547: end if;
548:
549: pay_in_utils.set_location(g_debug,l_procedure,50);

Line 546: pay_in_utils.trace('**********','');

542:
543: if g_debug then
544: pay_in_utils.trace('******************************','********************');
545: pay_in_utils.trace('g_message_name : ',g_message_name);
546: pay_in_utils.trace('******************************','********************');
547: end if;
548:
549: pay_in_utils.set_location(g_debug,l_procedure,50);
550: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);

Line 549: pay_in_utils.set_location(g_debug,l_procedure,50);

545: pay_in_utils.trace('g_message_name : ',g_message_name);
546: pay_in_utils.trace('******************************','********************');
547: end if;
548:
549: pay_in_utils.set_location(g_debug,l_procedure,50);
550: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
551:
552: END IF ;
553:

Line 550: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);

546: pay_in_utils.trace('******************************','********************');
547: end if;
548:
549: pay_in_utils.set_location(g_debug,l_procedure,50);
550: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
551:
552: END IF ;
553:
554: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);

Line 554: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);

550: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
551:
552: END IF ;
553:
554: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);
555:
556: END update_pds_details;
557:
558: END per_in_person_term_leg_hook;