DBA Data[Home] [Help]

APPS.PER_IN_DISABILITY_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_disability_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_disability_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 : EMP_DISABILITY_INT --

Line 53: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

49: ,p_degree IN NUMBER
50: ,p_dis_information1 IN VARCHAR2
51: ,p_calling_procedure IN VARCHAR2
52: ,p_message_name OUT NOCOPY VARCHAR2
53: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
54: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
55: IS
56:
57: --

Line 54: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)

50: ,p_dis_information1 IN VARCHAR2
51: ,p_calling_procedure IN VARCHAR2
52: ,p_message_name OUT NOCOPY VARCHAR2
53: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
54: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
55: IS
56:
57: --
58: l_procedure VARCHAR2(100);

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

86: BEGIN
87: --
88: g_debug := hr_utility.debug_enabled;
89: l_procedure := g_package || 'emp_disability_int';
90: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
91:
92: IF g_debug THEN
93: pay_in_utils.trace('**************************************************','********************');
94: pay_in_utils.trace('p_effective_date',p_effective_date);

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

89: l_procedure := g_package || 'emp_disability_int';
90: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
91:
92: IF g_debug THEN
93: pay_in_utils.trace('**************************************************','********************');
94: pay_in_utils.trace('p_effective_date',p_effective_date);
95: pay_in_utils.trace('p_person_id',p_person_id);
96: pay_in_utils.trace('p_category',p_category);
97: pay_in_utils.trace('p_status',p_status);

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

90: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
91:
92: IF g_debug THEN
93: pay_in_utils.trace('**************************************************','********************');
94: pay_in_utils.trace('p_effective_date',p_effective_date);
95: pay_in_utils.trace('p_person_id',p_person_id);
96: pay_in_utils.trace('p_category',p_category);
97: pay_in_utils.trace('p_status',p_status);
98: pay_in_utils.trace('p_degree',p_degree);

Line 95: pay_in_utils.trace('p_person_id',p_person_id);

91:
92: IF g_debug THEN
93: pay_in_utils.trace('**************************************************','********************');
94: pay_in_utils.trace('p_effective_date',p_effective_date);
95: pay_in_utils.trace('p_person_id',p_person_id);
96: pay_in_utils.trace('p_category',p_category);
97: pay_in_utils.trace('p_status',p_status);
98: pay_in_utils.trace('p_degree',p_degree);
99: pay_in_utils.trace('p_dis_information1',p_dis_information1);

Line 96: pay_in_utils.trace('p_category',p_category);

92: IF g_debug THEN
93: pay_in_utils.trace('**************************************************','********************');
94: pay_in_utils.trace('p_effective_date',p_effective_date);
95: pay_in_utils.trace('p_person_id',p_person_id);
96: pay_in_utils.trace('p_category',p_category);
97: pay_in_utils.trace('p_status',p_status);
98: pay_in_utils.trace('p_degree',p_degree);
99: pay_in_utils.trace('p_dis_information1',p_dis_information1);
100: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);

Line 97: pay_in_utils.trace('p_status',p_status);

93: pay_in_utils.trace('**************************************************','********************');
94: pay_in_utils.trace('p_effective_date',p_effective_date);
95: pay_in_utils.trace('p_person_id',p_person_id);
96: pay_in_utils.trace('p_category',p_category);
97: pay_in_utils.trace('p_status',p_status);
98: pay_in_utils.trace('p_degree',p_degree);
99: pay_in_utils.trace('p_dis_information1',p_dis_information1);
100: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
101: pay_in_utils.trace('**************************************************','********************');

Line 98: pay_in_utils.trace('p_degree',p_degree);

94: pay_in_utils.trace('p_effective_date',p_effective_date);
95: pay_in_utils.trace('p_person_id',p_person_id);
96: pay_in_utils.trace('p_category',p_category);
97: pay_in_utils.trace('p_status',p_status);
98: pay_in_utils.trace('p_degree',p_degree);
99: pay_in_utils.trace('p_dis_information1',p_dis_information1);
100: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
101: pay_in_utils.trace('**************************************************','********************');
102: END IF;

Line 99: pay_in_utils.trace('p_dis_information1',p_dis_information1);

95: pay_in_utils.trace('p_person_id',p_person_id);
96: pay_in_utils.trace('p_category',p_category);
97: pay_in_utils.trace('p_status',p_status);
98: pay_in_utils.trace('p_degree',p_degree);
99: pay_in_utils.trace('p_dis_information1',p_dis_information1);
100: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
101: pay_in_utils.trace('**************************************************','********************');
102: END IF;
103:

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

96: pay_in_utils.trace('p_category',p_category);
97: pay_in_utils.trace('p_status',p_status);
98: pay_in_utils.trace('p_degree',p_degree);
99: pay_in_utils.trace('p_dis_information1',p_dis_information1);
100: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
101: pay_in_utils.trace('**************************************************','********************');
102: END IF;
103:
104: pay_in_utils.null_message(p_token_name, p_token_value);

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

97: pay_in_utils.trace('p_status',p_status);
98: pay_in_utils.trace('p_degree',p_degree);
99: pay_in_utils.trace('p_dis_information1',p_dis_information1);
100: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
101: pay_in_utils.trace('**************************************************','********************');
102: END IF;
103:
104: pay_in_utils.null_message(p_token_name, p_token_value);
105: p_message_name := 'SUCCESS';

Line 104: pay_in_utils.null_message(p_token_name, p_token_value);

100: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
101: pay_in_utils.trace('**************************************************','********************');
102: END IF;
103:
104: pay_in_utils.null_message(p_token_name, p_token_value);
105: p_message_name := 'SUCCESS';
106: --
107: pay_in_utils.set_location(g_debug, l_procedure, 20);
108: --

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

103:
104: pay_in_utils.null_message(p_token_name, p_token_value);
105: p_message_name := 'SUCCESS';
106: --
107: pay_in_utils.set_location(g_debug, l_procedure, 20);
108: --
109: OPEN c_asg_details;
110: FETCH c_asg_details INTO l_assignment_id;
111: CLOSE c_asg_details;

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

109: OPEN c_asg_details;
110: FETCH c_asg_details INTO l_assignment_id;
111: CLOSE c_asg_details;
112: --
113: pay_in_utils.set_location(g_debug, l_procedure, 30);
114: --
115:
116: IF p_dis_information1 = 'Y' AND
117: p_degree >= 40 AND

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

117: p_degree >= 40 AND
118: p_category IN ('BLIND','SA_VIS_IMP','LC','SA_HEA_IMP','LD','07','MI','AU','CP','MD')
119: THEN
120: --
121: pay_in_utils.set_location(g_debug, l_procedure, 50);
122: --
123:
124: pay_in_tax_declaration.declare_section80u
125: (p_assignment_id => l_assignment_id

Line 130: pay_in_utils.set_location(g_debug, l_procedure, 60);

126: ,p_effective_date => p_effective_date
127: ,p_warnings => l_warning
128: );
129: --
130: pay_in_utils.set_location(g_debug, l_procedure, 60);
131: --
132: END IF;
133: pay_in_utils.set_location(g_debug, 'Leaving: '||l_procedure, 100);
134:

Line 133: pay_in_utils.set_location(g_debug, 'Leaving: '||l_procedure, 100);

129: --
130: pay_in_utils.set_location(g_debug, l_procedure, 60);
131: --
132: END IF;
133: pay_in_utils.set_location(g_debug, 'Leaving: '||l_procedure, 100);
134:
135: END emp_disability_int;
136:
137: --------------------------------------------------------------------------

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

175: --
176: g_debug := hr_utility.debug_enabled ;
177:
178: l_procedure := g_package || 'emp_disability_create' ;
179: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
180: g_message_name := 'SUCCESS';
181: pay_in_utils.null_message (g_token_name, g_token_value);
182:
183: IF g_debug THEN

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

177:
178: l_procedure := g_package || 'emp_disability_create' ;
179: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
180: g_message_name := 'SUCCESS';
181: pay_in_utils.null_message (g_token_name, g_token_value);
182:
183: IF g_debug THEN
184: pay_in_utils.trace('**************************************************','********************');
185: pay_in_utils.trace('p_effective_date',p_effective_date);

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

180: g_message_name := 'SUCCESS';
181: pay_in_utils.null_message (g_token_name, g_token_value);
182:
183: IF g_debug THEN
184: pay_in_utils.trace('**************************************************','********************');
185: pay_in_utils.trace('p_effective_date',p_effective_date);
186: pay_in_utils.trace('p_person_id',p_person_id);
187: pay_in_utils.trace('p_category',p_category);
188: pay_in_utils.trace('p_status',p_status);

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

181: pay_in_utils.null_message (g_token_name, g_token_value);
182:
183: IF g_debug THEN
184: pay_in_utils.trace('**************************************************','********************');
185: pay_in_utils.trace('p_effective_date',p_effective_date);
186: pay_in_utils.trace('p_person_id',p_person_id);
187: pay_in_utils.trace('p_category',p_category);
188: pay_in_utils.trace('p_status',p_status);
189: pay_in_utils.trace('p_degree',p_degree);

Line 186: pay_in_utils.trace('p_person_id',p_person_id);

182:
183: IF g_debug THEN
184: pay_in_utils.trace('**************************************************','********************');
185: pay_in_utils.trace('p_effective_date',p_effective_date);
186: pay_in_utils.trace('p_person_id',p_person_id);
187: pay_in_utils.trace('p_category',p_category);
188: pay_in_utils.trace('p_status',p_status);
189: pay_in_utils.trace('p_degree',p_degree);
190: pay_in_utils.trace('p_dis_information1',p_dis_information1);

Line 187: pay_in_utils.trace('p_category',p_category);

183: IF g_debug THEN
184: pay_in_utils.trace('**************************************************','********************');
185: pay_in_utils.trace('p_effective_date',p_effective_date);
186: pay_in_utils.trace('p_person_id',p_person_id);
187: pay_in_utils.trace('p_category',p_category);
188: pay_in_utils.trace('p_status',p_status);
189: pay_in_utils.trace('p_degree',p_degree);
190: pay_in_utils.trace('p_dis_information1',p_dis_information1);
191: pay_in_utils.trace('**************************************************','********************');

Line 188: pay_in_utils.trace('p_status',p_status);

184: pay_in_utils.trace('**************************************************','********************');
185: pay_in_utils.trace('p_effective_date',p_effective_date);
186: pay_in_utils.trace('p_person_id',p_person_id);
187: pay_in_utils.trace('p_category',p_category);
188: pay_in_utils.trace('p_status',p_status);
189: pay_in_utils.trace('p_degree',p_degree);
190: pay_in_utils.trace('p_dis_information1',p_dis_information1);
191: pay_in_utils.trace('**************************************************','********************');
192: END IF;

Line 189: pay_in_utils.trace('p_degree',p_degree);

185: pay_in_utils.trace('p_effective_date',p_effective_date);
186: pay_in_utils.trace('p_person_id',p_person_id);
187: pay_in_utils.trace('p_category',p_category);
188: pay_in_utils.trace('p_status',p_status);
189: pay_in_utils.trace('p_degree',p_degree);
190: pay_in_utils.trace('p_dis_information1',p_dis_information1);
191: pay_in_utils.trace('**************************************************','********************');
192: END IF;
193: --

Line 190: pay_in_utils.trace('p_dis_information1',p_dis_information1);

186: pay_in_utils.trace('p_person_id',p_person_id);
187: pay_in_utils.trace('p_category',p_category);
188: pay_in_utils.trace('p_status',p_status);
189: pay_in_utils.trace('p_degree',p_degree);
190: pay_in_utils.trace('p_dis_information1',p_dis_information1);
191: pay_in_utils.trace('**************************************************','********************');
192: END IF;
193: --
194: -- Check if PAY is installed for India Localization

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

187: pay_in_utils.trace('p_category',p_category);
188: pay_in_utils.trace('p_status',p_status);
189: pay_in_utils.trace('p_degree',p_degree);
190: pay_in_utils.trace('p_dis_information1',p_dis_information1);
191: pay_in_utils.trace('**************************************************','********************');
192: END IF;
193: --
194: -- Check if PAY is installed for India Localization
195: --

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

194: -- Check if PAY is installed for India Localization
195: --
196: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
197:
198: pay_in_utils.set_location(g_debug,l_procedure,20);
199:
200: emp_disability_int
201: (p_effective_date => p_effective_date
202: ,p_person_id => p_person_id

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

211: );
212:
213: --
214: END IF ;
215: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
216: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
217: --
218: END emp_disability_create;
219:

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

212:
213: --
214: END IF ;
215: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
216: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
217: --
218: END emp_disability_create;
219:
220: --------------------------------------------------------------------------

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

269: --
270: g_debug := hr_utility.debug_enabled ;
271:
272: l_procedure := g_package || 'emp_disability_update' ;
273: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
274: g_message_name := 'SUCCESS';
275: pay_in_utils.null_message (g_token_name, g_token_value);
276:
277: IF g_debug THEN

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

271:
272: l_procedure := g_package || 'emp_disability_update' ;
273: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
274: g_message_name := 'SUCCESS';
275: pay_in_utils.null_message (g_token_name, g_token_value);
276:
277: IF g_debug THEN
278: pay_in_utils.trace('**************************************************','********************');
279: pay_in_utils.trace('p_effective_date',p_effective_date);

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

274: g_message_name := 'SUCCESS';
275: pay_in_utils.null_message (g_token_name, g_token_value);
276:
277: IF g_debug THEN
278: pay_in_utils.trace('**************************************************','********************');
279: pay_in_utils.trace('p_effective_date',p_effective_date);
280: pay_in_utils.trace('p_disability_id',p_disability_id);
281: pay_in_utils.trace('p_category',p_category);
282: pay_in_utils.trace('p_status',p_status);

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

275: pay_in_utils.null_message (g_token_name, g_token_value);
276:
277: IF g_debug THEN
278: pay_in_utils.trace('**************************************************','********************');
279: pay_in_utils.trace('p_effective_date',p_effective_date);
280: pay_in_utils.trace('p_disability_id',p_disability_id);
281: pay_in_utils.trace('p_category',p_category);
282: pay_in_utils.trace('p_status',p_status);
283: pay_in_utils.trace('p_degree',p_degree);

Line 280: pay_in_utils.trace('p_disability_id',p_disability_id);

276:
277: IF g_debug THEN
278: pay_in_utils.trace('**************************************************','********************');
279: pay_in_utils.trace('p_effective_date',p_effective_date);
280: pay_in_utils.trace('p_disability_id',p_disability_id);
281: pay_in_utils.trace('p_category',p_category);
282: pay_in_utils.trace('p_status',p_status);
283: pay_in_utils.trace('p_degree',p_degree);
284: pay_in_utils.trace('p_dis_information1',p_dis_information1);

Line 281: pay_in_utils.trace('p_category',p_category);

277: IF g_debug THEN
278: pay_in_utils.trace('**************************************************','********************');
279: pay_in_utils.trace('p_effective_date',p_effective_date);
280: pay_in_utils.trace('p_disability_id',p_disability_id);
281: pay_in_utils.trace('p_category',p_category);
282: pay_in_utils.trace('p_status',p_status);
283: pay_in_utils.trace('p_degree',p_degree);
284: pay_in_utils.trace('p_dis_information1',p_dis_information1);
285: pay_in_utils.trace('**************************************************','********************');

Line 282: pay_in_utils.trace('p_status',p_status);

278: pay_in_utils.trace('**************************************************','********************');
279: pay_in_utils.trace('p_effective_date',p_effective_date);
280: pay_in_utils.trace('p_disability_id',p_disability_id);
281: pay_in_utils.trace('p_category',p_category);
282: pay_in_utils.trace('p_status',p_status);
283: pay_in_utils.trace('p_degree',p_degree);
284: pay_in_utils.trace('p_dis_information1',p_dis_information1);
285: pay_in_utils.trace('**************************************************','********************');
286: END IF;

Line 283: pay_in_utils.trace('p_degree',p_degree);

279: pay_in_utils.trace('p_effective_date',p_effective_date);
280: pay_in_utils.trace('p_disability_id',p_disability_id);
281: pay_in_utils.trace('p_category',p_category);
282: pay_in_utils.trace('p_status',p_status);
283: pay_in_utils.trace('p_degree',p_degree);
284: pay_in_utils.trace('p_dis_information1',p_dis_information1);
285: pay_in_utils.trace('**************************************************','********************');
286: END IF;
287: --

Line 284: pay_in_utils.trace('p_dis_information1',p_dis_information1);

280: pay_in_utils.trace('p_disability_id',p_disability_id);
281: pay_in_utils.trace('p_category',p_category);
282: pay_in_utils.trace('p_status',p_status);
283: pay_in_utils.trace('p_degree',p_degree);
284: pay_in_utils.trace('p_dis_information1',p_dis_information1);
285: pay_in_utils.trace('**************************************************','********************');
286: END IF;
287: --
288: -- Check if PAY is installed for India Localization

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

281: pay_in_utils.trace('p_category',p_category);
282: pay_in_utils.trace('p_status',p_status);
283: pay_in_utils.trace('p_degree',p_degree);
284: pay_in_utils.trace('p_dis_information1',p_dis_information1);
285: pay_in_utils.trace('**************************************************','********************');
286: END IF;
287: --
288: -- Check if PAY is installed for India Localization
289: --

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

288: -- Check if PAY is installed for India Localization
289: --
290: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
291:
292: pay_in_utils.set_location(g_debug,l_procedure,20);
293:
294: OPEN c_person_id;
295: FETCH c_person_id INTO l_person_id,l_category,l_status,l_degree,l_dis_information1;
296: CLOSE c_person_id;

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

294: OPEN c_person_id;
295: FETCH c_person_id INTO l_person_id,l_category,l_status,l_degree,l_dis_information1;
296: CLOSE c_person_id;
297:
298: pay_in_utils.set_location(g_debug,l_procedure,30);
299:
300: IF p_category <> hr_api.g_varchar2 THEN
301: l_category := p_category;
302: END IF;

Line 333: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

329:
330: --
331: END IF ;
332:
333: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
334: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
335: --
336: END emp_disability_update;
337:

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

330: --
331: END IF ;
332:
333: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
334: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
335: --
336: END emp_disability_update;
337:
338: END per_in_disability_leg_hook;