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.PAY_IN_INDIA_BENEFITS dependencies on PAY_IN_UTILS

Line 72: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id

68: FROM per_assignments_f assgn
69: , pay_element_links_f link
70: , pay_element_types_f types
71: WHERE assgn.assignment_id = p_assignment_id
72: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id
73: ,P_ENTRY_DATE
74: ,types.element_type_id
75: )
76: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

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

198:
199: g_debug := hr_utility.debug_enabled;
200: p_warnings := 'TRUE';
201: l_procedure := g_package ||'create_ltc_element';
202: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
203: IF (g_debug)
204: THEN
205: pay_in_utils.trace('**************************************************','********************');
206: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

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

201: l_procedure := g_package ||'create_ltc_element';
202: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
203: IF (g_debug)
204: THEN
205: pay_in_utils.trace('**************************************************','********************');
206: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
207: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
208: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
209: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));

Line 206: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

202: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
203: IF (g_debug)
204: THEN
205: pay_in_utils.trace('**************************************************','********************');
206: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
207: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
208: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
209: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
210: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));

Line 207: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));

203: IF (g_debug)
204: THEN
205: pay_in_utils.trace('**************************************************','********************');
206: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
207: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
208: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
209: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
210: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
211: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));

Line 208: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));

204: THEN
205: pay_in_utils.trace('**************************************************','********************');
206: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
207: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
208: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
209: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
210: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
211: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
212: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));

Line 209: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));

205: pay_in_utils.trace('**************************************************','********************');
206: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
207: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
208: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
209: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
210: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
211: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
212: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
213: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));

Line 210: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));

206: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
207: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
208: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
209: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
210: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
211: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
212: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
213: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
214: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));

Line 211: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));

207: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
208: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
209: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
210: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
211: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
212: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
213: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
214: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
215: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));

Line 212: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));

208: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
209: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
210: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
211: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
212: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
213: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
214: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
215: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
216: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));

Line 213: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));

209: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
210: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
211: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
212: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
213: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
214: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
215: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
216: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
217: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));

Line 214: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));

210: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
211: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
212: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
213: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
214: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
215: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
216: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
217: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
218: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));

Line 215: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));

211: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
212: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
213: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
214: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
215: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
216: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
217: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
218: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
219: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));

Line 216: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));

212: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
213: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
214: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
215: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
216: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
217: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
218: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
219: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
220: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));

Line 217: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));

213: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
214: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
215: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
216: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
217: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
218: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
219: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
220: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
221: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));

Line 218: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));

214: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
215: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
216: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
217: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
218: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
219: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
220: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
221: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
222: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));

Line 219: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));

215: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
216: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
217: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
218: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
219: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
220: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
221: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
222: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
223: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));

Line 220: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));

216: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
217: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
218: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
219: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
220: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
221: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
222: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
223: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));
224: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));

Line 221: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));

217: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
218: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
219: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
220: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
221: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
222: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
223: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));
224: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));
225:

Line 222: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));

218: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
219: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
220: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
221: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
222: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
223: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));
224: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));
225:
226:

Line 223: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));

219: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
220: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
221: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
222: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
223: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));
224: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));
225:
226:
227: END IF;

Line 224: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));

220: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
221: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
222: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
223: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));
224: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));
225:
226:
227: END IF;
228:

Line 233: pay_in_utils.trace('l_business_group_id',TO_CHAR (l_business_group_id));

229: l_business_group_id := pay_in_med_web_adi.get_bg_id();
230:
231: IF (g_debug)
232: THEN
233: pay_in_utils.trace('l_business_group_id',TO_CHAR (l_business_group_id));
234: END IF;
235:
236: BEGIN
237: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;

Line 247: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);

243:
244: IF ((p_element_entry_id IS NOT NULL))
245: THEN
246:
247: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);
248:
249: OPEN c_get_ele_object_version(p_element_entry_id) ;
250: FETCH c_get_ele_object_version INTO l_object_version_no,l_effective_start_date ;
251: CLOSE c_get_ele_object_version ;

Line 266: pay_in_utils.trace('Input Value Name'||l_count,TO_CHAR (c_rec.name));

262: l_input_values_rec(l_count).value := c_rec.value;
263:
264: IF (g_debug)
265: THEN
266: pay_in_utils.trace('Input Value Name'||l_count,TO_CHAR (c_rec.name));
267: END IF;
268:
269: l_count := l_count + 1;
270: END LOOP;

Line 279: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));

275: CLOSE c_get_screen_value ;
276:
277: IF (g_debug)
278: THEN
279: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));
280: END IF;
281:
282:
283: OPEN c_get_screen_value(p_element_entry_id, l_input_values_rec(5).input_value_id);

Line 293: pay_in_utils.trace('l_prev_submitted',TO_CHAR (l_prev_submitted));

289: CLOSE c_get_prev_amts ;
290:
291: IF (g_debug)
292: THEN
293: pay_in_utils.trace('l_prev_submitted',TO_CHAR (l_prev_submitted));
294: pay_in_utils.trace('l_prev_exempted_amount',TO_CHAR (l_prev_exempted_amount));
295: END IF;
296:
297:

Line 294: pay_in_utils.trace('l_prev_exempted_amount',TO_CHAR (l_prev_exempted_amount));

290:
291: IF (g_debug)
292: THEN
293: pay_in_utils.trace('l_prev_submitted',TO_CHAR (l_prev_submitted));
294: pay_in_utils.trace('l_prev_exempted_amount',TO_CHAR (l_prev_exempted_amount));
295: END IF;
296:
297:
298: l_submitted := NVL(P_EXEMPTED,0) + NVL(l_entry_information3,0) - NVL(l_prev_exempted_amount,0) ;

Line 347: pay_in_utils.trace('l_ltc_element ',TO_CHAR (l_ltc_element));

343: CLOSE c_element_name ;
344:
345: IF (g_debug)
346: THEN
347: pay_in_utils.trace('l_ltc_element ',TO_CHAR (l_ltc_element));
348: END IF;
349:
350:
351: OPEN csr_element_details(p_assignment_id, p_entry_date, l_ltc_element) ;

Line 358: pay_in_utils.trace('l_ltc_element_type_id ',TO_CHAR (l_ltc_element_type_id));

354:
355:
356: IF (g_debug)
357: THEN
358: pay_in_utils.trace('l_ltc_element_type_id ',TO_CHAR (l_ltc_element_type_id));
359: pay_in_utils.trace('l_ltc_element_link_id ',TO_CHAR (l_ltc_element_link_id));
360: END IF;
361:
362: OPEN c_check_element_entry(l_ltc_element_type_id, p_entry_date);

Line 359: pay_in_utils.trace('l_ltc_element_link_id ',TO_CHAR (l_ltc_element_link_id));

355:
356: IF (g_debug)
357: THEN
358: pay_in_utils.trace('l_ltc_element_type_id ',TO_CHAR (l_ltc_element_type_id));
359: pay_in_utils.trace('l_ltc_element_link_id ',TO_CHAR (l_ltc_element_link_id));
360: END IF;
361:
362: OPEN c_check_element_entry(l_ltc_element_type_id, p_entry_date);
363: FETCH c_check_element_entry INTO l_element_entry_id ;

Line 373: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,40);

369: CLOSE c_ltc_carry_over;
370:
371: IF (l_element_entry_id IS NOT NULL AND l_carry_over = nvl(P_CARRY_OVER,'N'))THEN
372:
373: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,40);
374:
375: OPEN c_get_ele_object_version(l_element_entry_id) ;
376: FETCH c_get_ele_object_version INTO l_object_version_no,l_effective_start_date ;
377: CLOSE c_get_ele_object_version ;

Line 391: pay_in_utils.trace('Input Value Name'||l_count,TO_CHAR (c_rec.name));

387: l_input_values_rec(l_count).value := c_rec.value;
388:
389: IF (g_debug)
390: THEN
391: pay_in_utils.trace('Input Value Name'||l_count,TO_CHAR (c_rec.name));
392: END IF;
393:
394: l_count := l_count + 1;
395: END LOOP;

Line 403: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));

399: CLOSE c_get_screen_value ;
400:
401: IF (g_debug)
402: THEN
403: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));
404: END IF;
405:
406:
407: OPEN c_get_screen_value(l_element_entry_id, l_input_values_rec(5).input_value_id);

Line 413: pay_in_utils.trace('l_entry_information5',TO_CHAR (l_entry_information5));

409: CLOSE c_get_screen_value ;
410:
411: IF (g_debug)
412: THEN
413: pay_in_utils.trace('l_entry_information5',TO_CHAR (l_entry_information5));
414: END IF;
415:
416:
417:

Line 485: pay_in_utils.trace('Input Value Name:'||l_count,TO_CHAR (c_rec.name));

481: l_ben_input_values_rec(l_count).value := c_rec.value;
482:
483: IF (g_debug)
484: THEN
485: pay_in_utils.trace('Input Value Name:'||l_count,TO_CHAR (c_rec.name));
486: END IF;
487:
488: l_count := l_count + 1;
489: END LOOP;

Line 491: pay_in_utils.set_location(g_debug,'Creating Benefit Element Entries: '||l_procedure,50);

487:
488: l_count := l_count + 1;
489: END LOOP;
490:
491: pay_in_utils.set_location(g_debug,'Creating Benefit Element Entries: '||l_procedure,50);
492:
493:
494:
495: IF (P_EXEMPTED IS NOT NULL) THEN

Line 528: pay_in_utils.set_location(g_debug,'Benefit Element Creation Completed'||l_procedure,60);

524: ,p_create_warning => l_warnings
525: );
526:
527: END IF;
528: pay_in_utils.set_location(g_debug,'Benefit Element Creation Completed'||l_procedure,60);
529:
530:
531:
532: END IF ;

Line 536: pay_in_utils.set_location(g_debug,'Updating Assignment_Extra_Info: '||l_procedure,70);

532: END IF ;
533: END IF;
534:
535:
536: pay_in_utils.set_location(g_debug,'Updating Assignment_Extra_Info: '||l_procedure,70);
537:
538: IF P_EMPLOYEE_ID <> 0 THEN /* To prevent this from Self Service page and execute only for web adi*/
539:
540: UPDATE per_assignment_extra_info

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

547: p_element_entry_id := nvl(l_element_entry_id,p_element_entry_id);
548:
549:
550:
551: pay_in_utils.trace('**************************************************','********************');
552: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
553: p_warnings := 'FALSE';
554: EXCEPTION
555: WHEN OTHERS THEN

Line 552: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);

548:
549:
550:
551: pay_in_utils.trace('**************************************************','********************');
552: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
553: p_warnings := 'FALSE';
554: EXCEPTION
555: WHEN OTHERS THEN
556: fnd_msg_pub.add_exc_msg

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

1034: --
1035: BEGIN
1036: --
1037: l_procedure := g_package || 'get_last_updated_date';
1038: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1039:
1040: IF g_debug THEN
1041: pay_in_utils.trace('**************************************************','********************');
1042: pay_in_utils.trace('p_assignment_id ',p_assignment_id);

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

1037: l_procedure := g_package || 'get_last_updated_date';
1038: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1039:
1040: IF g_debug THEN
1041: pay_in_utils.trace('**************************************************','********************');
1042: pay_in_utils.trace('p_assignment_id ',p_assignment_id);
1043: pay_in_utils.trace('p_block ', p_block);
1044: pay_in_utils.trace('p_asg_info_type Date: ', p_asg_info_type);
1045: pay_in_utils.trace('**************************************************','********************');

Line 1042: pay_in_utils.trace('p_assignment_id ',p_assignment_id);

1038: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1039:
1040: IF g_debug THEN
1041: pay_in_utils.trace('**************************************************','********************');
1042: pay_in_utils.trace('p_assignment_id ',p_assignment_id);
1043: pay_in_utils.trace('p_block ', p_block);
1044: pay_in_utils.trace('p_asg_info_type Date: ', p_asg_info_type);
1045: pay_in_utils.trace('**************************************************','********************');
1046: END IF;

Line 1043: pay_in_utils.trace('p_block ', p_block);

1039:
1040: IF g_debug THEN
1041: pay_in_utils.trace('**************************************************','********************');
1042: pay_in_utils.trace('p_assignment_id ',p_assignment_id);
1043: pay_in_utils.trace('p_block ', p_block);
1044: pay_in_utils.trace('p_asg_info_type Date: ', p_asg_info_type);
1045: pay_in_utils.trace('**************************************************','********************');
1046: END IF;
1047:

Line 1044: pay_in_utils.trace('p_asg_info_type Date: ', p_asg_info_type);

1040: IF g_debug THEN
1041: pay_in_utils.trace('**************************************************','********************');
1042: pay_in_utils.trace('p_assignment_id ',p_assignment_id);
1043: pay_in_utils.trace('p_block ', p_block);
1044: pay_in_utils.trace('p_asg_info_type Date: ', p_asg_info_type);
1045: pay_in_utils.trace('**************************************************','********************');
1046: END IF;
1047:
1048: --

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

1041: pay_in_utils.trace('**************************************************','********************');
1042: pay_in_utils.trace('p_assignment_id ',p_assignment_id);
1043: pay_in_utils.trace('p_block ', p_block);
1044: pay_in_utils.trace('p_asg_info_type Date: ', p_asg_info_type);
1045: pay_in_utils.trace('**************************************************','********************');
1046: END IF;
1047:
1048: --
1049:

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

1077: l_updated_date := GREATEST(l_upd_date_appr,l_upd_date_unappr);
1078: END IF;
1079: --
1080: IF g_debug THEN
1081: pay_in_utils.trace('**************************************************','********************');
1082: pay_in_utils.trace('l_updated_date',l_updated_date);
1083: pay_in_utils.trace('**************************************************','********************');
1084: END IF;
1085:

Line 1082: pay_in_utils.trace('l_updated_date',l_updated_date);

1078: END IF;
1079: --
1080: IF g_debug THEN
1081: pay_in_utils.trace('**************************************************','********************');
1082: pay_in_utils.trace('l_updated_date',l_updated_date);
1083: pay_in_utils.trace('**************************************************','********************');
1084: END IF;
1085:
1086: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,90);

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

1079: --
1080: IF g_debug THEN
1081: pay_in_utils.trace('**************************************************','********************');
1082: pay_in_utils.trace('l_updated_date',l_updated_date);
1083: pay_in_utils.trace('**************************************************','********************');
1084: END IF;
1085:
1086: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,90);
1087: --

Line 1086: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,90);

1082: pay_in_utils.trace('l_updated_date',l_updated_date);
1083: pay_in_utils.trace('**************************************************','********************');
1084: END IF;
1085:
1086: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,90);
1087: --
1088: RETURN l_updated_date;
1089:
1090:

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

1259: CLOSE csr_get_ovn;
1260:
1261: IF (g_debug)
1262: THEN
1263: pay_in_utils.trace('**************************************************','********************');
1264: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1265: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1266: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));
1267: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));

Line 1264: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);

1260:
1261: IF (g_debug)
1262: THEN
1263: pay_in_utils.trace('**************************************************','********************');
1264: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1265: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1266: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));
1267: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
1268: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));

Line 1265: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));

1261: IF (g_debug)
1262: THEN
1263: pay_in_utils.trace('**************************************************','********************');
1264: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1265: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1266: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));
1267: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
1268: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));
1269: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));

Line 1266: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));

1262: THEN
1263: pay_in_utils.trace('**************************************************','********************');
1264: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1265: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1266: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));
1267: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
1268: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));
1269: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));
1270: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));

Line 1267: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));

1263: pay_in_utils.trace('**************************************************','********************');
1264: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1265: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1266: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));
1267: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
1268: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));
1269: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));
1270: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));
1271: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));

Line 1268: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));

1264: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1265: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1266: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));
1267: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
1268: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));
1269: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));
1270: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));
1271: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));
1272: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));

Line 1269: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));

1265: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1266: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));
1267: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
1268: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));
1269: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));
1270: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));
1271: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));
1272: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));
1273: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));

Line 1270: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));

1266: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));
1267: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
1268: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));
1269: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));
1270: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));
1271: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));
1272: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));
1273: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1274: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));

Line 1271: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));

1267: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
1268: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));
1269: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));
1270: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));
1271: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));
1272: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));
1273: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1274: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1275: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));

Line 1272: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));

1268: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));
1269: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));
1270: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));
1271: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));
1272: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));
1273: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1274: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1275: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));
1276: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));

Line 1273: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));

1269: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));
1270: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));
1271: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));
1272: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));
1273: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1274: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1275: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));
1276: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));
1277: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));

Line 1274: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));

1270: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));
1271: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));
1272: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));
1273: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1274: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1275: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));
1276: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));
1277: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));
1278: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));

Line 1275: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));

1271: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));
1272: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));
1273: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1274: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1275: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));
1276: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));
1277: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));
1278: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));
1279: pay_in_utils.trace('p_super_user',TO_CHAR (p_super_user));

Line 1276: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));

1272: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));
1273: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1274: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1275: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));
1276: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));
1277: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));
1278: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));
1279: pay_in_utils.trace('p_super_user',TO_CHAR (p_super_user));
1280: pay_in_utils.trace('p_ee_comments',TO_CHAR(p_ee_comments));

Line 1277: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));

1273: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1274: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1275: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));
1276: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));
1277: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));
1278: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));
1279: pay_in_utils.trace('p_super_user',TO_CHAR (p_super_user));
1280: pay_in_utils.trace('p_ee_comments',TO_CHAR(p_ee_comments));
1281: pay_in_utils.trace('p_er_comments',TO_CHAR(p_er_comments));

Line 1278: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));

1274: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1275: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));
1276: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));
1277: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));
1278: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));
1279: pay_in_utils.trace('p_super_user',TO_CHAR (p_super_user));
1280: pay_in_utils.trace('p_ee_comments',TO_CHAR(p_ee_comments));
1281: pay_in_utils.trace('p_er_comments',TO_CHAR(p_er_comments));
1282:

Line 1279: pay_in_utils.trace('p_super_user',TO_CHAR (p_super_user));

1275: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));
1276: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));
1277: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));
1278: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));
1279: pay_in_utils.trace('p_super_user',TO_CHAR (p_super_user));
1280: pay_in_utils.trace('p_ee_comments',TO_CHAR(p_ee_comments));
1281: pay_in_utils.trace('p_er_comments',TO_CHAR(p_er_comments));
1282:
1283: END IF;

Line 1280: pay_in_utils.trace('p_ee_comments',TO_CHAR(p_ee_comments));

1276: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));
1277: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));
1278: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));
1279: pay_in_utils.trace('p_super_user',TO_CHAR (p_super_user));
1280: pay_in_utils.trace('p_ee_comments',TO_CHAR(p_ee_comments));
1281: pay_in_utils.trace('p_er_comments',TO_CHAR(p_er_comments));
1282:
1283: END IF;
1284:

Line 1281: pay_in_utils.trace('p_er_comments',TO_CHAR(p_er_comments));

1277: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));
1278: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));
1279: pay_in_utils.trace('p_super_user',TO_CHAR (p_super_user));
1280: pay_in_utils.trace('p_ee_comments',TO_CHAR(p_ee_comments));
1281: pay_in_utils.trace('p_er_comments',TO_CHAR(p_er_comments));
1282:
1283: END IF;
1284:
1285: IF p_super_user ='Y'

Line 1311: pay_in_utils.set_location(g_debug,'PER_PERSON_ID'||TO_CHAR(l_person_profile_id),20);

1307: select fnd_profile.value('PER_BUSINESS_GROUP_ID') into l_bg_profile_id from dual;
1308:
1309: IF (g_debug)
1310: THEN
1311: pay_in_utils.set_location(g_debug,'PER_PERSON_ID'||TO_CHAR(l_person_profile_id),20);
1312: pay_in_utils.set_location(g_debug,'PER_BUSINESS_GROUP_ID'||TO_CHAR(l_bg_profile_id),20);
1313: END IF;
1314:
1315:

Line 1312: pay_in_utils.set_location(g_debug,'PER_BUSINESS_GROUP_ID'||TO_CHAR(l_bg_profile_id),20);

1308:
1309: IF (g_debug)
1310: THEN
1311: pay_in_utils.set_location(g_debug,'PER_PERSON_ID'||TO_CHAR(l_person_profile_id),20);
1312: pay_in_utils.set_location(g_debug,'PER_BUSINESS_GROUP_ID'||TO_CHAR(l_bg_profile_id),20);
1313: END IF;
1314:
1315:
1316:

Line 1323: pay_in_utils.set_location(g_debug,'Creating new assignment extra information',20);

1319:
1320: IF p_asg_extra_info_id is null THEN
1321: IF (g_debug)
1322: THEN
1323: pay_in_utils.set_location(g_debug,'Creating new assignment extra information',20);
1324: END IF;
1325:
1326: hr_assignment_extra_info_api.create_assignment_extra_info(
1327: p_assignment_id => p_asg_id,

Line 1348: pay_in_utils.set_location(g_debug,'Updating AEI'||TO_CHAR(p_asg_extra_info_id),20);

1344: ELSE
1345:
1346: IF (g_debug)
1347: THEN
1348: pay_in_utils.set_location(g_debug,'Updating AEI'||TO_CHAR(p_asg_extra_info_id),20);
1349: END IF;
1350:
1351: hr_assignment_extra_info_api.update_assignment_extra_info(
1352: p_aei_information1 => p_financial_yr,

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

1397:
1398:
1399: g_debug := hr_utility.debug_enabled;
1400: l_procedure := g_package ||'ltc_bill_entry';
1401: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1402:
1403: p_warnings := 'TRUE';
1404:
1405: IF (p_element_entry_id =0) THEN

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

1407: END IF;
1408:
1409: IF (g_debug)
1410: THEN
1411: pay_in_utils.trace('**************************************************','********************');
1412: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1413: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1414: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));
1415: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));

Line 1412: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);

1408:
1409: IF (g_debug)
1410: THEN
1411: pay_in_utils.trace('**************************************************','********************');
1412: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1413: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1414: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));
1415: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));
1416: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));

Line 1413: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));

1409: IF (g_debug)
1410: THEN
1411: pay_in_utils.trace('**************************************************','********************');
1412: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1413: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1414: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));
1415: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));
1416: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));
1417: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));

Line 1414: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));

1410: THEN
1411: pay_in_utils.trace('**************************************************','********************');
1412: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1413: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1414: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));
1415: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));
1416: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));
1417: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1418: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));

Line 1415: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));

1411: pay_in_utils.trace('**************************************************','********************');
1412: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1413: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1414: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));
1415: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));
1416: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));
1417: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1418: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));
1419: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));

Line 1416: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));

1412: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1413: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1414: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));
1415: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));
1416: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));
1417: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1418: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));
1419: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));
1420: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));

Line 1417: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));

1413: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1414: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));
1415: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));
1416: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));
1417: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1418: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));
1419: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));
1420: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));
1421: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));

Line 1418: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));

1414: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));
1415: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));
1416: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));
1417: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1418: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));
1419: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));
1420: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));
1421: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));
1422: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));

Line 1419: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));

1415: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));
1416: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));
1417: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1418: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));
1419: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));
1420: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));
1421: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));
1422: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));
1423: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));

Line 1420: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));

1416: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));
1417: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1418: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));
1419: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));
1420: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));
1421: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));
1422: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));
1423: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));
1424: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));

Line 1421: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));

1417: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1418: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));
1419: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));
1420: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));
1421: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));
1422: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));
1423: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));
1424: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1425: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));

Line 1422: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));

1418: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));
1419: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));
1420: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));
1421: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));
1422: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));
1423: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));
1424: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1425: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1426: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));

Line 1423: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));

1419: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));
1420: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));
1421: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));
1422: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));
1423: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));
1424: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1425: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1426: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));
1427: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));

Line 1424: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));

1420: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));
1421: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));
1422: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));
1423: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));
1424: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1425: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1426: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));
1427: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));
1428: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));

Line 1425: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));

1421: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));
1422: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));
1423: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));
1424: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1425: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1426: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));
1427: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));
1428: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));
1429: pay_in_utils.trace('p_element_entry_date',TO_CHAR(p_element_entry_date));

Line 1426: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));

1422: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));
1423: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));
1424: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1425: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1426: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));
1427: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));
1428: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));
1429: pay_in_utils.trace('p_element_entry_date',TO_CHAR(p_element_entry_date));
1430: pay_in_utils.trace('p_super_user',TO_CHAR(p_super_user));

Line 1427: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));

1423: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));
1424: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1425: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1426: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));
1427: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));
1428: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));
1429: pay_in_utils.trace('p_element_entry_date',TO_CHAR(p_element_entry_date));
1430: pay_in_utils.trace('p_super_user',TO_CHAR(p_super_user));
1431: pay_in_utils.trace('p_person_id',TO_CHAR(p_person_id));

Line 1428: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));

1424: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1425: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1426: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));
1427: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));
1428: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));
1429: pay_in_utils.trace('p_element_entry_date',TO_CHAR(p_element_entry_date));
1430: pay_in_utils.trace('p_super_user',TO_CHAR(p_super_user));
1431: pay_in_utils.trace('p_person_id',TO_CHAR(p_person_id));
1432:

Line 1429: pay_in_utils.trace('p_element_entry_date',TO_CHAR(p_element_entry_date));

1425: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1426: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));
1427: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));
1428: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));
1429: pay_in_utils.trace('p_element_entry_date',TO_CHAR(p_element_entry_date));
1430: pay_in_utils.trace('p_super_user',TO_CHAR(p_super_user));
1431: pay_in_utils.trace('p_person_id',TO_CHAR(p_person_id));
1432:
1433: END IF;

Line 1430: pay_in_utils.trace('p_super_user',TO_CHAR(p_super_user));

1426: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));
1427: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));
1428: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));
1429: pay_in_utils.trace('p_element_entry_date',TO_CHAR(p_element_entry_date));
1430: pay_in_utils.trace('p_super_user',TO_CHAR(p_super_user));
1431: pay_in_utils.trace('p_person_id',TO_CHAR(p_person_id));
1432:
1433: END IF;
1434:

Line 1431: pay_in_utils.trace('p_person_id',TO_CHAR(p_person_id));

1427: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));
1428: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));
1429: pay_in_utils.trace('p_element_entry_date',TO_CHAR(p_element_entry_date));
1430: pay_in_utils.trace('p_super_user',TO_CHAR(p_super_user));
1431: pay_in_utils.trace('p_person_id',TO_CHAR(p_person_id));
1432:
1433: END IF;
1434:
1435:

Line 1467: pay_in_utils.trace('l_warnings',l_warnings);

1463: END IF;
1464:
1465:
1466:
1467: pay_in_utils.trace('l_warnings',l_warnings);
1468:
1469: pay_in_utils.trace('**************************************************','********************');
1470: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
1471: p_warnings := l_warnings;

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

1465:
1466:
1467: pay_in_utils.trace('l_warnings',l_warnings);
1468:
1469: pay_in_utils.trace('**************************************************','********************');
1470: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
1471: p_warnings := l_warnings;
1472: pay_in_utils.trace('p_warnings',p_warnings);
1473:

Line 1470: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);

1466:
1467: pay_in_utils.trace('l_warnings',l_warnings);
1468:
1469: pay_in_utils.trace('**************************************************','********************');
1470: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
1471: p_warnings := l_warnings;
1472: pay_in_utils.trace('p_warnings',p_warnings);
1473:
1474: END ltc_bill_entry;

Line 1472: pay_in_utils.trace('p_warnings',p_warnings);

1468:
1469: pay_in_utils.trace('**************************************************','********************');
1470: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
1471: p_warnings := l_warnings;
1472: pay_in_utils.trace('p_warnings',p_warnings);
1473:
1474: END ltc_bill_entry;
1475:
1476:

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

1735: --
1736: BEGIN
1737: --
1738: l_procedure := g_package || 'is_locked';
1739: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1740:
1741: IF g_debug THEN
1742: pay_in_utils.trace('**************************************************','********************');
1743: pay_in_utils.trace('p_person_id',p_person_id);

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

1738: l_procedure := g_package || 'is_locked';
1739: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1740:
1741: IF g_debug THEN
1742: pay_in_utils.trace('**************************************************','********************');
1743: pay_in_utils.trace('p_person_id',p_person_id);
1744: pay_in_utils.trace('**************************************************','********************');
1745: END IF;
1746: p_locked := 'N';

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

1739: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1740:
1741: IF g_debug THEN
1742: pay_in_utils.trace('**************************************************','********************');
1743: pay_in_utils.trace('p_person_id',p_person_id);
1744: pay_in_utils.trace('**************************************************','********************');
1745: END IF;
1746: p_locked := 'N';
1747: --

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

1740:
1741: IF g_debug THEN
1742: pay_in_utils.trace('**************************************************','********************');
1743: pay_in_utils.trace('p_person_id',p_person_id);
1744: pay_in_utils.trace('**************************************************','********************');
1745: END IF;
1746: p_locked := 'N';
1747: --
1748:

Line 1754: pay_in_utils.set_location(g_debug, l_proc, 20);

1750: OPEN lock_dtls;
1751: FETCH lock_dtls INTO p_locked;
1752: CLOSE lock_dtls;
1753: --
1754: pay_in_utils.set_location(g_debug, l_proc, 20);
1755: --
1756:
1757:
1758: IF g_debug THEN

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

1755: --
1756:
1757:
1758: IF g_debug THEN
1759: pay_in_utils.trace('**************************************************','********************');
1760: pay_in_utils.trace('p_locked ',p_locked);
1761: pay_in_utils.trace('**************************************************','********************');
1762: END IF;
1763:

Line 1760: pay_in_utils.trace('p_locked ',p_locked);

1756:
1757:
1758: IF g_debug THEN
1759: pay_in_utils.trace('**************************************************','********************');
1760: pay_in_utils.trace('p_locked ',p_locked);
1761: pay_in_utils.trace('**************************************************','********************');
1762: END IF;
1763:
1764: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

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

1757:
1758: IF g_debug THEN
1759: pay_in_utils.trace('**************************************************','********************');
1760: pay_in_utils.trace('p_locked ',p_locked);
1761: pay_in_utils.trace('**************************************************','********************');
1762: END IF;
1763:
1764: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
1765:

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

1760: pay_in_utils.trace('p_locked ',p_locked);
1761: pay_in_utils.trace('**************************************************','********************');
1762: END IF;
1763:
1764: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
1765:
1766: --
1767:
1768: END is_locked;

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

1847:
1848: p_warnings := 'TRUE';
1849: g_debug := hr_utility.debug_enabled;
1850: l_procedure := g_package ||'update_ltc_element';
1851: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1852: IF (g_debug)
1853: THEN
1854: pay_in_utils.trace('**************************************************','********************');
1855: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

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

1850: l_procedure := g_package ||'update_ltc_element';
1851: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1852: IF (g_debug)
1853: THEN
1854: pay_in_utils.trace('**************************************************','********************');
1855: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1856: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1857: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1858: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));

Line 1855: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

1851: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1852: IF (g_debug)
1853: THEN
1854: pay_in_utils.trace('**************************************************','********************');
1855: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1856: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1857: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1858: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1859: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));

Line 1856: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));

1852: IF (g_debug)
1853: THEN
1854: pay_in_utils.trace('**************************************************','********************');
1855: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1856: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1857: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1858: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1859: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1860: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));

Line 1857: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));

1853: THEN
1854: pay_in_utils.trace('**************************************************','********************');
1855: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1856: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1857: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1858: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1859: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1860: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1861: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));

Line 1858: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));

1854: pay_in_utils.trace('**************************************************','********************');
1855: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1856: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1857: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1858: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1859: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1860: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1861: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1862: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));

Line 1859: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));

1855: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1856: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1857: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1858: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1859: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1860: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1861: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1862: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1863: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));

Line 1860: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));

1856: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1857: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1858: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1859: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1860: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1861: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1862: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1863: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1864: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));

Line 1861: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));

1857: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1858: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1859: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1860: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1861: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1862: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1863: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1864: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1865: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));

Line 1862: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));

1858: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1859: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1860: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1861: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1862: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1863: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1864: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1865: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));
1866:

Line 1863: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));

1859: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1860: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1861: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1862: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1863: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1864: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1865: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));
1866:
1867: END IF;

Line 1864: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));

1860: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1861: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1862: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1863: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1864: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1865: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));
1866:
1867: END IF;
1868:

Line 1865: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));

1861: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1862: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1863: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1864: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1865: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));
1866:
1867: END IF;
1868:
1869: BEGIN

Line 1880: pay_in_utils.trace('Business Group:',TO_CHAR (l_business_group_id));

1876: l_business_group_id := pay_in_med_web_adi.get_bg_id();
1877:
1878: IF (g_debug)
1879: THEN
1880: pay_in_utils.trace('Business Group:',TO_CHAR (l_business_group_id));
1881: END IF;
1882:
1883:
1884: IF ((p_element_entry_id IS NOT NULL))

Line 1887: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);

1883:
1884: IF ((p_element_entry_id IS NOT NULL))
1885: THEN
1886:
1887: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);
1888:
1889: OPEN c_get_ele_object_version(p_element_entry_id) ;
1890: FETCH c_get_ele_object_version INTO l_object_version_no ;
1891: CLOSE c_get_ele_object_version ;

Line 1906: pay_in_utils.trace('Input Values Name:'||l_count,TO_CHAR (c_rec.name));

1902: l_input_values_rec(l_count).value := c_rec.value;
1903:
1904: IF (g_debug)
1905: THEN
1906: pay_in_utils.trace('Input Values Name:'||l_count,TO_CHAR (c_rec.name));
1907: END IF;
1908:
1909: l_count := l_count + 1;
1910: END LOOP;

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

1948: where AEI_INFORMATION11 = p_element_entry_id
1949: and assignment_id = p_assignment_id;
1950:
1951: p_warnings := 'FALSE';
1952: pay_in_utils.trace('**************************************************','********************');
1953: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
1954: EXCEPTION
1955: WHEN OTHERS THEN
1956: fnd_msg_pub.add_exc_msg

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

1949: and assignment_id = p_assignment_id;
1950:
1951: p_warnings := 'FALSE';
1952: pay_in_utils.trace('**************************************************','********************');
1953: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
1954: EXCEPTION
1955: WHEN OTHERS THEN
1956: fnd_msg_pub.add_exc_msg
1957: (p_pkg_name => g_package