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 76: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id

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

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

206: fnd_msg_pub.initialize; --13767307
207: g_debug := hr_utility.debug_enabled;
208: p_warnings := 'TRUE';
209: l_procedure := g_package ||'create_ltc_element';
210: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
211: IF (g_debug)
212: THEN
213: pay_in_utils.trace('**************************************************','********************');
214: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

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

209: l_procedure := g_package ||'create_ltc_element';
210: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
211: IF (g_debug)
212: THEN
213: pay_in_utils.trace('**************************************************','********************');
214: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
215: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
216: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
217: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));

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

210: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
211: IF (g_debug)
212: THEN
213: pay_in_utils.trace('**************************************************','********************');
214: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
215: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
216: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
217: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
218: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));

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

211: IF (g_debug)
212: THEN
213: pay_in_utils.trace('**************************************************','********************');
214: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
215: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
216: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
217: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
218: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
219: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));

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

212: THEN
213: pay_in_utils.trace('**************************************************','********************');
214: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
215: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
216: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
217: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
218: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
219: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
220: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));

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

213: pay_in_utils.trace('**************************************************','********************');
214: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
215: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
216: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
217: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
218: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
219: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
220: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
221: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));

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

214: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
215: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
216: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
217: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
218: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
219: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
220: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
221: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
222: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));

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

215: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
216: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
217: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
218: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
219: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
220: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
221: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
222: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
223: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));

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

216: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
217: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
218: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
219: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
220: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
221: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
222: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
223: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
224: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));

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

217: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
218: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
219: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
220: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
221: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
222: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
223: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
224: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
225: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));

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

218: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
219: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
220: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
221: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
222: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
223: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
224: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
225: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
226: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));

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

219: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
220: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
221: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
222: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
223: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
224: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
225: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
226: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
227: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));

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

220: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
221: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
222: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
223: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
224: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
225: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
226: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
227: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
228: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));

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

221: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
222: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
223: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
224: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
225: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
226: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
227: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
228: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
229: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));

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

222: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
223: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
224: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
225: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
226: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
227: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
228: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
229: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
230: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));

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

223: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
224: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
225: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
226: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
227: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
228: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
229: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
230: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
231: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));

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

224: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
225: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
226: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
227: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
228: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
229: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
230: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
231: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));
232: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));

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

225: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
226: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
227: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
228: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
229: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
230: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
231: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));
232: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));
233:

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

226: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
227: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
228: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
229: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
230: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
231: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));
232: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));
233:
234:

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

227: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
228: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
229: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
230: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
231: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));
232: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));
233:
234:
235: END IF;

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

228: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
229: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
230: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
231: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));
232: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));
233:
234:
235: END IF;
236:

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

237: l_business_group_id := pay_in_med_web_adi.get_bg_id();
238:
239: IF (g_debug)
240: THEN
241: pay_in_utils.trace('l_business_group_id',TO_CHAR (l_business_group_id));
242: END IF;
243:
244: BEGIN
245: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;

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

251:
252: IF ((p_element_entry_id IS NOT NULL))
253: THEN
254:
255: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);
256:
257: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);
258: pay_in_utils.trace('P_ENTRY_DATE',P_ENTRY_DATE);
259: OPEN c_get_ele_object_version(p_element_entry_id) ;

Line 257: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);

253: THEN
254:
255: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);
256:
257: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);
258: pay_in_utils.trace('P_ENTRY_DATE',P_ENTRY_DATE);
259: OPEN c_get_ele_object_version(p_element_entry_id) ;
260: FETCH c_get_ele_object_version INTO l_object_version_no,l_effective_start_date ;
261: pay_in_utils.trace('l_object_version_no',l_object_version_no);

Line 258: pay_in_utils.trace('P_ENTRY_DATE',P_ENTRY_DATE);

254:
255: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);
256:
257: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);
258: pay_in_utils.trace('P_ENTRY_DATE',P_ENTRY_DATE);
259: OPEN c_get_ele_object_version(p_element_entry_id) ;
260: FETCH c_get_ele_object_version INTO l_object_version_no,l_effective_start_date ;
261: pay_in_utils.trace('l_object_version_no',l_object_version_no);
262: pay_in_utils.trace('l_effective_start_date',l_effective_start_date);

Line 261: pay_in_utils.trace('l_object_version_no',l_object_version_no);

257: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);
258: pay_in_utils.trace('P_ENTRY_DATE',P_ENTRY_DATE);
259: OPEN c_get_ele_object_version(p_element_entry_id) ;
260: FETCH c_get_ele_object_version INTO l_object_version_no,l_effective_start_date ;
261: pay_in_utils.trace('l_object_version_no',l_object_version_no);
262: pay_in_utils.trace('l_effective_start_date',l_effective_start_date);
263: CLOSE c_get_ele_object_version ;
264:
265: OPEN c_get_ele_type_id(p_element_entry_id);

Line 262: pay_in_utils.trace('l_effective_start_date',l_effective_start_date);

258: pay_in_utils.trace('P_ENTRY_DATE',P_ENTRY_DATE);
259: OPEN c_get_ele_object_version(p_element_entry_id) ;
260: FETCH c_get_ele_object_version INTO l_object_version_no,l_effective_start_date ;
261: pay_in_utils.trace('l_object_version_no',l_object_version_no);
262: pay_in_utils.trace('l_effective_start_date',l_effective_start_date);
263: CLOSE c_get_ele_object_version ;
264:
265: OPEN c_get_ele_type_id(p_element_entry_id);
266: FETCH c_get_ele_type_id INTO l_ltc_element_type_id ;

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

274: l_input_values_rec(l_count).value := c_rec.value;
275:
276: IF (g_debug)
277: THEN
278: pay_in_utils.trace('Input Value Name'||l_count,TO_CHAR (c_rec.name));
279: END IF;
280:
281: l_count := l_count + 1;
282: END LOOP;

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

287: CLOSE c_get_screen_value ;
288:
289: IF (g_debug)
290: THEN
291: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));
292: END IF;
293:
294:
295: OPEN c_get_screen_value(p_element_entry_id, l_input_values_rec(5).input_value_id);

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

297: CLOSE c_get_screen_value ;
298:
299: IF (g_debug)
300: THEN
301: pay_in_utils.trace('l_entry_information5',TO_CHAR (l_entry_information5));
302: END IF;
303:
304: OPEN c_get_prev_amts ;
305: FETCH c_get_prev_amts INTO l_prev_submitted, l_prev_exempted_amount;

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

306: CLOSE c_get_prev_amts ;
307:
308: IF (g_debug)
309: THEN
310: pay_in_utils.trace('l_prev_submitted',TO_CHAR (l_prev_submitted));
311: pay_in_utils.trace('l_prev_exempted_amount',TO_CHAR (l_prev_exempted_amount));
312: END IF;
313:
314:

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

307:
308: IF (g_debug)
309: THEN
310: pay_in_utils.trace('l_prev_submitted',TO_CHAR (l_prev_submitted));
311: pay_in_utils.trace('l_prev_exempted_amount',TO_CHAR (l_prev_exempted_amount));
312: END IF;
313:
314:
315: l_submitted := NVL(P_EXEMPTED,0) + NVL(l_entry_information3,0) - NVL(l_prev_exempted_amount,0) ;

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

369: CLOSE c_element_name ;
370:
371: IF (g_debug)
372: THEN
373: pay_in_utils.trace('l_ltc_element ',TO_CHAR (l_ltc_element));
374: END IF;
375:
376:
377: OPEN csr_element_details(p_assignment_id, p_entry_date, l_ltc_element) ;

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

380:
381:
382: IF (g_debug)
383: THEN
384: pay_in_utils.trace('l_ltc_element_type_id ',TO_CHAR (l_ltc_element_type_id));
385: pay_in_utils.trace('l_ltc_element_link_id ',TO_CHAR (l_ltc_element_link_id));
386: pay_in_utils.trace('p_entry_date ',TO_CHAR (p_entry_date));
387: END IF;
388:

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

381:
382: IF (g_debug)
383: THEN
384: pay_in_utils.trace('l_ltc_element_type_id ',TO_CHAR (l_ltc_element_type_id));
385: pay_in_utils.trace('l_ltc_element_link_id ',TO_CHAR (l_ltc_element_link_id));
386: pay_in_utils.trace('p_entry_date ',TO_CHAR (p_entry_date));
387: END IF;
388:
389: OPEN c_check_element_entry(l_ltc_element_type_id, p_entry_date);

Line 386: pay_in_utils.trace('p_entry_date ',TO_CHAR (p_entry_date));

382: IF (g_debug)
383: THEN
384: pay_in_utils.trace('l_ltc_element_type_id ',TO_CHAR (l_ltc_element_type_id));
385: pay_in_utils.trace('l_ltc_element_link_id ',TO_CHAR (l_ltc_element_link_id));
386: pay_in_utils.trace('p_entry_date ',TO_CHAR (p_entry_date));
387: END IF;
388:
389: OPEN c_check_element_entry(l_ltc_element_type_id, p_entry_date);
390: FETCH c_check_element_entry INTO l_element_entry_id ;

Line 391: pay_in_utils.trace('l_element_entry_id',l_element_entry_id);

387: END IF;
388:
389: OPEN c_check_element_entry(l_ltc_element_type_id, p_entry_date);
390: FETCH c_check_element_entry INTO l_element_entry_id ;
391: pay_in_utils.trace('l_element_entry_id',l_element_entry_id);
392: CLOSE c_check_element_entry ;
393:
394:
395: OPEN c_ltc_carry_over(l_element_entry_id);

Line 397: pay_in_utils.trace('l_carry_over',l_carry_over);

393:
394:
395: OPEN c_ltc_carry_over(l_element_entry_id);
396: FETCH c_ltc_carry_over INTO l_carry_over;
397: pay_in_utils.trace('l_carry_over',l_carry_over);
398:
399: CLOSE c_ltc_carry_over;
400:
401: IF (l_element_entry_id IS NOT NULL AND l_carry_over = nvl(P_CARRY_OVER,'N'))THEN

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

399: CLOSE c_ltc_carry_over;
400:
401: IF (l_element_entry_id IS NOT NULL AND l_carry_over = nvl(P_CARRY_OVER,'N'))THEN
402:
403: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,40);
404: pay_in_utils.trace('l_element_entry_id',l_element_entry_id);
405: pay_in_utils.trace('P_ENTRY_DATE',P_ENTRY_DATE);
406: OPEN c_get_ele_object_version(l_element_entry_id) ;
407: FETCH c_get_ele_object_version INTO l_object_version_no,l_effective_start_date ;

Line 404: pay_in_utils.trace('l_element_entry_id',l_element_entry_id);

400:
401: IF (l_element_entry_id IS NOT NULL AND l_carry_over = nvl(P_CARRY_OVER,'N'))THEN
402:
403: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,40);
404: pay_in_utils.trace('l_element_entry_id',l_element_entry_id);
405: pay_in_utils.trace('P_ENTRY_DATE',P_ENTRY_DATE);
406: OPEN c_get_ele_object_version(l_element_entry_id) ;
407: FETCH c_get_ele_object_version INTO l_object_version_no,l_effective_start_date ;
408: pay_in_utils.trace('l_object_version_no',l_object_version_no);

Line 405: pay_in_utils.trace('P_ENTRY_DATE',P_ENTRY_DATE);

401: IF (l_element_entry_id IS NOT NULL AND l_carry_over = nvl(P_CARRY_OVER,'N'))THEN
402:
403: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,40);
404: pay_in_utils.trace('l_element_entry_id',l_element_entry_id);
405: pay_in_utils.trace('P_ENTRY_DATE',P_ENTRY_DATE);
406: OPEN c_get_ele_object_version(l_element_entry_id) ;
407: FETCH c_get_ele_object_version INTO l_object_version_no,l_effective_start_date ;
408: pay_in_utils.trace('l_object_version_no',l_object_version_no);
409: pay_in_utils.trace('l_effective_start_date',l_effective_start_date);

Line 408: pay_in_utils.trace('l_object_version_no',l_object_version_no);

404: pay_in_utils.trace('l_element_entry_id',l_element_entry_id);
405: pay_in_utils.trace('P_ENTRY_DATE',P_ENTRY_DATE);
406: OPEN c_get_ele_object_version(l_element_entry_id) ;
407: FETCH c_get_ele_object_version INTO l_object_version_no,l_effective_start_date ;
408: pay_in_utils.trace('l_object_version_no',l_object_version_no);
409: pay_in_utils.trace('l_effective_start_date',l_effective_start_date);
410: CLOSE c_get_ele_object_version ;
411:
412:

Line 409: pay_in_utils.trace('l_effective_start_date',l_effective_start_date);

405: pay_in_utils.trace('P_ENTRY_DATE',P_ENTRY_DATE);
406: OPEN c_get_ele_object_version(l_element_entry_id) ;
407: FETCH c_get_ele_object_version INTO l_object_version_no,l_effective_start_date ;
408: pay_in_utils.trace('l_object_version_no',l_object_version_no);
409: pay_in_utils.trace('l_effective_start_date',l_effective_start_date);
410: CLOSE c_get_ele_object_version ;
411:
412:
413:

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

420: l_input_values_rec(l_count).value := c_rec.value;
421:
422: IF (g_debug)
423: THEN
424: pay_in_utils.trace('Input Value Name'||l_count,TO_CHAR (c_rec.name));
425: END IF;
426:
427: l_count := l_count + 1;
428: END LOOP;

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

432: CLOSE c_get_screen_value ;
433:
434: IF (g_debug)
435: THEN
436: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));
437: END IF;
438:
439:
440: OPEN c_get_screen_value(l_element_entry_id, l_input_values_rec(5).input_value_id);

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

442: CLOSE c_get_screen_value ;
443:
444: IF (g_debug)
445: THEN
446: pay_in_utils.trace('l_entry_information5',TO_CHAR (l_entry_information5));
447: END IF;
448:
449:
450:

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

449:
450:
451: IF (g_debug)
452: THEN
453: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
454: END IF;
455:
456: l_submitted := NVL(P_EXEMPTED,0) + NVL(l_entry_information3,0) ;
457: l_submitted := GREATEST (l_submitted,0);

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

529: l_ben_input_values_rec(l_count).value := c_rec.value;
530:
531: IF (g_debug)
532: THEN
533: pay_in_utils.trace('Input Value Name:'||l_count,TO_CHAR (c_rec.name));
534: END IF;
535:
536: l_count := l_count + 1;
537: END LOOP;

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

535:
536: l_count := l_count + 1;
537: END LOOP;
538:
539: pay_in_utils.set_location(g_debug,'Creating Benefit Element Entries: '||l_procedure,50);
540:
541:
542:
543: IF (P_EXEMPTED IS NOT NULL) THEN

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

573: ,p_create_warning => l_warnings
574: );
575: l_create_flag :='Y';
576: END IF;
577: pay_in_utils.set_location(g_debug,'Benefit Element Creation Completed'||l_procedure,60);
578:
579:
580:
581: END IF ;

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

581: END IF ;
582: END IF;
583:
584:
585: pay_in_utils.set_location(g_debug,'Updating Assignment_Extra_Info: '||l_procedure,70);
586:
587: IF P_EMPLOYEE_ID <> 0 THEN /* To prevent this from Self Service page and execute only for web adi*/
588:
589: UPDATE per_assignment_extra_info

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

596: p_element_entry_id := nvl(l_element_entry_id,p_element_entry_id);
597:
598:
599:
600: pay_in_utils.trace('**************************************************','********************');
601: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
602: p_warnings := 'FALSE';
603: EXCEPTION
604: WHEN OTHERS THEN

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

597:
598:
599:
600: pay_in_utils.trace('**************************************************','********************');
601: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
602: p_warnings := 'FALSE';
603: EXCEPTION
604: WHEN OTHERS THEN
605: fnd_msg_pub.add_exc_msg

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

1083: --
1084: BEGIN
1085: --
1086: l_procedure := g_package || 'get_last_updated_date';
1087: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1088:
1089: IF g_debug THEN
1090: pay_in_utils.trace('**************************************************','********************');
1091: pay_in_utils.trace('p_assignment_id ',p_assignment_id);

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

1086: l_procedure := g_package || 'get_last_updated_date';
1087: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1088:
1089: IF g_debug THEN
1090: pay_in_utils.trace('**************************************************','********************');
1091: pay_in_utils.trace('p_assignment_id ',p_assignment_id);
1092: pay_in_utils.trace('p_block ', p_block);
1093: pay_in_utils.trace('p_asg_info_type Date: ', p_asg_info_type);
1094: pay_in_utils.trace('**************************************************','********************');

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

1087: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1088:
1089: IF g_debug THEN
1090: pay_in_utils.trace('**************************************************','********************');
1091: pay_in_utils.trace('p_assignment_id ',p_assignment_id);
1092: pay_in_utils.trace('p_block ', p_block);
1093: pay_in_utils.trace('p_asg_info_type Date: ', p_asg_info_type);
1094: pay_in_utils.trace('**************************************************','********************');
1095: END IF;

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

1088:
1089: IF g_debug THEN
1090: pay_in_utils.trace('**************************************************','********************');
1091: pay_in_utils.trace('p_assignment_id ',p_assignment_id);
1092: pay_in_utils.trace('p_block ', p_block);
1093: pay_in_utils.trace('p_asg_info_type Date: ', p_asg_info_type);
1094: pay_in_utils.trace('**************************************************','********************');
1095: END IF;
1096:

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

1089: IF g_debug THEN
1090: pay_in_utils.trace('**************************************************','********************');
1091: pay_in_utils.trace('p_assignment_id ',p_assignment_id);
1092: pay_in_utils.trace('p_block ', p_block);
1093: pay_in_utils.trace('p_asg_info_type Date: ', p_asg_info_type);
1094: pay_in_utils.trace('**************************************************','********************');
1095: END IF;
1096:
1097: --

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

1090: pay_in_utils.trace('**************************************************','********************');
1091: pay_in_utils.trace('p_assignment_id ',p_assignment_id);
1092: pay_in_utils.trace('p_block ', p_block);
1093: pay_in_utils.trace('p_asg_info_type Date: ', p_asg_info_type);
1094: pay_in_utils.trace('**************************************************','********************');
1095: END IF;
1096:
1097: --
1098:

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

1126: l_updated_date := GREATEST(l_upd_date_appr,l_upd_date_unappr);
1127: END IF;
1128: --
1129: IF g_debug THEN
1130: pay_in_utils.trace('**************************************************','********************');
1131: pay_in_utils.trace('l_updated_date',l_updated_date);
1132: pay_in_utils.trace('**************************************************','********************');
1133: END IF;
1134:

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

1127: END IF;
1128: --
1129: IF g_debug THEN
1130: pay_in_utils.trace('**************************************************','********************');
1131: pay_in_utils.trace('l_updated_date',l_updated_date);
1132: pay_in_utils.trace('**************************************************','********************');
1133: END IF;
1134:
1135: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,90);

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

1128: --
1129: IF g_debug THEN
1130: pay_in_utils.trace('**************************************************','********************');
1131: pay_in_utils.trace('l_updated_date',l_updated_date);
1132: pay_in_utils.trace('**************************************************','********************');
1133: END IF;
1134:
1135: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,90);
1136: --

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

1131: pay_in_utils.trace('l_updated_date',l_updated_date);
1132: pay_in_utils.trace('**************************************************','********************');
1133: END IF;
1134:
1135: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,90);
1136: --
1137: RETURN l_updated_date;
1138:
1139:

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

1308: CLOSE csr_get_ovn;
1309:
1310: IF (g_debug)
1311: THEN
1312: pay_in_utils.trace('**************************************************','********************');
1313: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1314: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1315: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));
1316: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));

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

1309:
1310: IF (g_debug)
1311: THEN
1312: pay_in_utils.trace('**************************************************','********************');
1313: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1314: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1315: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));
1316: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
1317: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));

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

1310: IF (g_debug)
1311: THEN
1312: pay_in_utils.trace('**************************************************','********************');
1313: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1314: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1315: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));
1316: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
1317: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));
1318: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));

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

1311: THEN
1312: pay_in_utils.trace('**************************************************','********************');
1313: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1314: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1315: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));
1316: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
1317: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));
1318: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));
1319: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));

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

1312: pay_in_utils.trace('**************************************************','********************');
1313: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1314: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1315: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));
1316: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
1317: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));
1318: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));
1319: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));
1320: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));

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

1313: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1314: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1315: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));
1316: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
1317: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));
1318: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));
1319: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));
1320: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));
1321: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));

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

1314: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1315: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));
1316: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
1317: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));
1318: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));
1319: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));
1320: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));
1321: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));
1322: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));

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

1315: pay_in_utils.trace('p_financial_yr',TO_CHAR (p_financial_yr));
1316: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
1317: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));
1318: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));
1319: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));
1320: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));
1321: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));
1322: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1323: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));

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

1316: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
1317: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));
1318: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));
1319: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));
1320: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));
1321: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));
1322: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1323: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1324: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));

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

1317: pay_in_utils.trace('p_person_id',TO_CHAR (p_person_id));
1318: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));
1319: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));
1320: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));
1321: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));
1322: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1323: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1324: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));
1325: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));

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

1318: pay_in_utils.trace('p_con_person_id',TO_CHAR (p_con_person_id));
1319: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));
1320: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));
1321: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));
1322: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1323: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1324: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));
1325: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));
1326: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));

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

1319: pay_in_utils.trace('p_old_bill_amt',TO_CHAR (p_old_bill_amt));
1320: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));
1321: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));
1322: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1323: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1324: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));
1325: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));
1326: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));
1327: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));

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

1320: pay_in_utils.trace('p_old_exempt_amt',TO_CHAR (p_old_exempt_amt));
1321: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));
1322: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1323: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1324: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));
1325: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));
1326: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));
1327: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));
1328: pay_in_utils.trace('p_super_user',TO_CHAR (p_super_user));

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

1321: pay_in_utils.trace('p_new_exempt_amt',TO_CHAR (p_new_exempt_amt));
1322: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1323: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1324: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));
1325: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));
1326: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));
1327: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));
1328: pay_in_utils.trace('p_super_user',TO_CHAR (p_super_user));
1329: pay_in_utils.trace('p_ee_comments',TO_CHAR(p_ee_comments));

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

1322: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1323: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1324: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));
1325: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));
1326: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));
1327: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));
1328: pay_in_utils.trace('p_super_user',TO_CHAR (p_super_user));
1329: pay_in_utils.trace('p_ee_comments',TO_CHAR(p_ee_comments));
1330: pay_in_utils.trace('p_er_comments',TO_CHAR(p_er_comments));

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

1323: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1324: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));
1325: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));
1326: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));
1327: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));
1328: pay_in_utils.trace('p_super_user',TO_CHAR (p_super_user));
1329: pay_in_utils.trace('p_ee_comments',TO_CHAR(p_ee_comments));
1330: pay_in_utils.trace('p_er_comments',TO_CHAR(p_er_comments));
1331:

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

1324: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR (p_asg_extra_info_id));
1325: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));
1326: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));
1327: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));
1328: pay_in_utils.trace('p_super_user',TO_CHAR (p_super_user));
1329: pay_in_utils.trace('p_ee_comments',TO_CHAR(p_ee_comments));
1330: pay_in_utils.trace('p_er_comments',TO_CHAR(p_er_comments));
1331:
1332: END IF;

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

1325: pay_in_utils.trace('p_ovn',TO_CHAR (p_ovn));
1326: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));
1327: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));
1328: pay_in_utils.trace('p_super_user',TO_CHAR (p_super_user));
1329: pay_in_utils.trace('p_ee_comments',TO_CHAR(p_ee_comments));
1330: pay_in_utils.trace('p_er_comments',TO_CHAR(p_er_comments));
1331:
1332: END IF;
1333:

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

1326: pay_in_utils.trace('p_business_group_id',TO_CHAR (p_business_group_id));
1327: pay_in_utils.trace('p_element_entry_date',TO_CHAR (p_element_entry_date));
1328: pay_in_utils.trace('p_super_user',TO_CHAR (p_super_user));
1329: pay_in_utils.trace('p_ee_comments',TO_CHAR(p_ee_comments));
1330: pay_in_utils.trace('p_er_comments',TO_CHAR(p_er_comments));
1331:
1332: END IF;
1333:
1334: IF p_super_user ='Y'

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

1356: select fnd_profile.value('PER_BUSINESS_GROUP_ID') into l_bg_profile_id from dual;
1357:
1358: IF (g_debug)
1359: THEN
1360: pay_in_utils.set_location(g_debug,'PER_PERSON_ID'||TO_CHAR(l_person_profile_id),20);
1361: pay_in_utils.set_location(g_debug,'PER_BUSINESS_GROUP_ID'||TO_CHAR(l_bg_profile_id),20);
1362: END IF;
1363:
1364:

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

1357:
1358: IF (g_debug)
1359: THEN
1360: pay_in_utils.set_location(g_debug,'PER_PERSON_ID'||TO_CHAR(l_person_profile_id),20);
1361: pay_in_utils.set_location(g_debug,'PER_BUSINESS_GROUP_ID'||TO_CHAR(l_bg_profile_id),20);
1362: END IF;
1363:
1364:
1365:

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

1368:
1369: IF p_asg_extra_info_id is null THEN
1370: IF (g_debug)
1371: THEN
1372: pay_in_utils.set_location(g_debug,'Creating new assignment extra information',20);
1373: END IF;
1374:
1375: hr_assignment_extra_info_api.create_assignment_extra_info(
1376: p_assignment_id => p_asg_id,

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

1393: ELSE
1394:
1395: IF (g_debug)
1396: THEN
1397: pay_in_utils.set_location(g_debug,'Updating AEI'||TO_CHAR(p_asg_extra_info_id),20);
1398: END IF;
1399:
1400: hr_assignment_extra_info_api.update_assignment_extra_info(
1401: p_aei_information1 => p_financial_yr,

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

1450: BEGIN
1451:
1452: g_debug := hr_utility.debug_enabled;
1453: l_procedure := g_package ||'ltc_bill_entry';
1454: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1455:
1456: p_warnings := 'TRUE';
1457:
1458: IF (p_element_entry_id =0) THEN

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

1460: END IF;
1461:
1462: IF (g_debug)
1463: THEN
1464: pay_in_utils.trace('**************************************************','********************');
1465: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1466: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1467: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));
1468: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));

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

1461:
1462: IF (g_debug)
1463: THEN
1464: pay_in_utils.trace('**************************************************','********************');
1465: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1466: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1467: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));
1468: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));
1469: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));

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

1462: IF (g_debug)
1463: THEN
1464: pay_in_utils.trace('**************************************************','********************');
1465: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1466: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1467: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));
1468: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));
1469: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));
1470: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));

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

1463: THEN
1464: pay_in_utils.trace('**************************************************','********************');
1465: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1466: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1467: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));
1468: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));
1469: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));
1470: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1471: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));

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

1464: pay_in_utils.trace('**************************************************','********************');
1465: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1466: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1467: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));
1468: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));
1469: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));
1470: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1471: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));
1472: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));

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

1465: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
1466: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1467: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));
1468: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));
1469: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));
1470: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1471: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));
1472: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));
1473: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));

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

1466: pay_in_utils.trace('p_asg_id',TO_CHAR (p_asg_id));
1467: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));
1468: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));
1469: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));
1470: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1471: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));
1472: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));
1473: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));
1474: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));

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

1467: pay_in_utils.trace('p_ltc_block',TO_CHAR (p_ltc_block));
1468: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));
1469: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));
1470: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1471: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));
1472: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));
1473: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));
1474: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));
1475: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));

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

1468: pay_in_utils.trace('p_ben_name',TO_CHAR (p_ben_name));
1469: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));
1470: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1471: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));
1472: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));
1473: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));
1474: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));
1475: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));
1476: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));

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

1469: pay_in_utils.trace('p_place_from',TO_CHAR (p_place_from));
1470: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1471: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));
1472: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));
1473: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));
1474: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));
1475: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));
1476: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));
1477: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));

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

1470: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
1471: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));
1472: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));
1473: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));
1474: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));
1475: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));
1476: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));
1477: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1478: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));

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

1471: pay_in_utils.trace('p_ee_comments',TO_CHAR (p_ee_comments));
1472: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));
1473: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));
1474: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));
1475: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));
1476: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));
1477: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1478: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1479: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));

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

1472: pay_in_utils.trace('p_er_comments',TO_CHAR (p_er_comments));
1473: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));
1474: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));
1475: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));
1476: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));
1477: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1478: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1479: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));
1480: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));

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

1473: pay_in_utils.trace('p_place_to',TO_CHAR (p_place_to));
1474: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));
1475: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));
1476: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));
1477: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1478: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1479: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));
1480: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));
1481: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));

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

1474: pay_in_utils.trace('p_travel_mode',TO_CHAR (p_travel_mode));
1475: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));
1476: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));
1477: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1478: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1479: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));
1480: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));
1481: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));
1482: pay_in_utils.trace('p_element_entry_date',TO_CHAR(p_element_entry_date));

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

1475: pay_in_utils.trace('p_bill_amt',TO_CHAR (p_bill_amt));
1476: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));
1477: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1478: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1479: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));
1480: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));
1481: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));
1482: pay_in_utils.trace('p_element_entry_date',TO_CHAR(p_element_entry_date));
1483: pay_in_utils.trace('p_super_user',TO_CHAR(p_super_user));

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

1476: pay_in_utils.trace('p_exempt_amt',TO_CHAR (p_exempt_amt));
1477: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1478: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1479: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));
1480: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));
1481: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));
1482: pay_in_utils.trace('p_element_entry_date',TO_CHAR(p_element_entry_date));
1483: pay_in_utils.trace('p_super_user',TO_CHAR(p_super_user));
1484: pay_in_utils.trace('p_person_id',TO_CHAR(p_person_id));

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

1477: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
1478: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1479: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));
1480: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));
1481: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));
1482: pay_in_utils.trace('p_element_entry_date',TO_CHAR(p_element_entry_date));
1483: pay_in_utils.trace('p_super_user',TO_CHAR(p_super_user));
1484: pay_in_utils.trace('p_person_id',TO_CHAR(p_person_id));
1485:

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

1478: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1479: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));
1480: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));
1481: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));
1482: pay_in_utils.trace('p_element_entry_date',TO_CHAR(p_element_entry_date));
1483: pay_in_utils.trace('p_super_user',TO_CHAR(p_super_user));
1484: pay_in_utils.trace('p_person_id',TO_CHAR(p_person_id));
1485:
1486: END IF;

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

1479: pay_in_utils.trace('p_end_date',TO_CHAR (p_end_date));
1480: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));
1481: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));
1482: pay_in_utils.trace('p_element_entry_date',TO_CHAR(p_element_entry_date));
1483: pay_in_utils.trace('p_super_user',TO_CHAR(p_super_user));
1484: pay_in_utils.trace('p_person_id',TO_CHAR(p_person_id));
1485:
1486: END IF;
1487:

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

1480: pay_in_utils.trace('p_carry_over_flag',TO_CHAR (p_carry_over_flag));
1481: pay_in_utils.trace('p_asg_extra_info_id',TO_CHAR(p_asg_extra_info_id));
1482: pay_in_utils.trace('p_element_entry_date',TO_CHAR(p_element_entry_date));
1483: pay_in_utils.trace('p_super_user',TO_CHAR(p_super_user));
1484: pay_in_utils.trace('p_person_id',TO_CHAR(p_person_id));
1485:
1486: END IF;
1487:
1488:

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

1520: END IF;
1521:
1522:
1523:
1524: pay_in_utils.trace('l_warnings',l_warnings);
1525:
1526: pay_in_utils.trace('**************************************************','********************');
1527: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
1528: p_warnings := l_warnings;

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

1522:
1523:
1524: pay_in_utils.trace('l_warnings',l_warnings);
1525:
1526: pay_in_utils.trace('**************************************************','********************');
1527: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
1528: p_warnings := l_warnings;
1529: pay_in_utils.trace('p_warnings',p_warnings);
1530:

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

1523:
1524: pay_in_utils.trace('l_warnings',l_warnings);
1525:
1526: pay_in_utils.trace('**************************************************','********************');
1527: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
1528: p_warnings := l_warnings;
1529: pay_in_utils.trace('p_warnings',p_warnings);
1530:
1531: END ltc_bill_entry;

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

1525:
1526: pay_in_utils.trace('**************************************************','********************');
1527: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
1528: p_warnings := l_warnings;
1529: pay_in_utils.trace('p_warnings',p_warnings);
1530:
1531: END ltc_bill_entry;
1532:
1533:

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

1792: --
1793: BEGIN
1794: --
1795: l_procedure := g_package || 'is_locked';
1796: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1797:
1798: IF g_debug THEN
1799: pay_in_utils.trace('**************************************************','********************');
1800: pay_in_utils.trace('p_person_id',p_person_id);

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

1795: l_procedure := g_package || 'is_locked';
1796: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1797:
1798: IF g_debug THEN
1799: pay_in_utils.trace('**************************************************','********************');
1800: pay_in_utils.trace('p_person_id',p_person_id);
1801: pay_in_utils.trace('**************************************************','********************');
1802: END IF;
1803: p_locked := 'N';

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

1796: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1797:
1798: IF g_debug THEN
1799: pay_in_utils.trace('**************************************************','********************');
1800: pay_in_utils.trace('p_person_id',p_person_id);
1801: pay_in_utils.trace('**************************************************','********************');
1802: END IF;
1803: p_locked := 'N';
1804: --

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

1797:
1798: IF g_debug THEN
1799: pay_in_utils.trace('**************************************************','********************');
1800: pay_in_utils.trace('p_person_id',p_person_id);
1801: pay_in_utils.trace('**************************************************','********************');
1802: END IF;
1803: p_locked := 'N';
1804: --
1805:

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

1807: OPEN lock_dtls;
1808: FETCH lock_dtls INTO p_locked;
1809: CLOSE lock_dtls;
1810: --
1811: pay_in_utils.set_location(g_debug, l_proc, 20);
1812: --
1813:
1814:
1815: IF g_debug THEN

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

1812: --
1813:
1814:
1815: IF g_debug THEN
1816: pay_in_utils.trace('**************************************************','********************');
1817: pay_in_utils.trace('p_locked ',p_locked);
1818: pay_in_utils.trace('**************************************************','********************');
1819: END IF;
1820:

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

1813:
1814:
1815: IF g_debug THEN
1816: pay_in_utils.trace('**************************************************','********************');
1817: pay_in_utils.trace('p_locked ',p_locked);
1818: pay_in_utils.trace('**************************************************','********************');
1819: END IF;
1820:
1821: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

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

1814:
1815: IF g_debug THEN
1816: pay_in_utils.trace('**************************************************','********************');
1817: pay_in_utils.trace('p_locked ',p_locked);
1818: pay_in_utils.trace('**************************************************','********************');
1819: END IF;
1820:
1821: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
1822:

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

1817: pay_in_utils.trace('p_locked ',p_locked);
1818: pay_in_utils.trace('**************************************************','********************');
1819: END IF;
1820:
1821: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
1822:
1823: --
1824:
1825: END is_locked;

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

1921: fnd_msg_pub.initialize; --13767307
1922: p_warnings := 'TRUE';
1923: g_debug := hr_utility.debug_enabled;
1924: l_procedure := g_package ||'update_ltc_element';
1925: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1926: IF (g_debug)
1927: THEN
1928: pay_in_utils.trace('**************************************************','********************');
1929: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

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

1924: l_procedure := g_package ||'update_ltc_element';
1925: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1926: IF (g_debug)
1927: THEN
1928: pay_in_utils.trace('**************************************************','********************');
1929: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1930: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1931: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1932: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));

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

1925: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1926: IF (g_debug)
1927: THEN
1928: pay_in_utils.trace('**************************************************','********************');
1929: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1930: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1931: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1932: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1933: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));

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

1926: IF (g_debug)
1927: THEN
1928: pay_in_utils.trace('**************************************************','********************');
1929: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1930: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1931: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1932: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1933: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1934: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));

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

1927: THEN
1928: pay_in_utils.trace('**************************************************','********************');
1929: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1930: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1931: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1932: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1933: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1934: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1935: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));

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

1928: pay_in_utils.trace('**************************************************','********************');
1929: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1930: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1931: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1932: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1933: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1934: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1935: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1936: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));

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

1929: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1930: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1931: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1932: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1933: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1934: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1935: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1936: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1937: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));

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

1930: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1931: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1932: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1933: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1934: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1935: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1936: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1937: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1938: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));

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

1931: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1932: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1933: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1934: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1935: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1936: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1937: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1938: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1939: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));

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

1932: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1933: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1934: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1935: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1936: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1937: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1938: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1939: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));
1940:

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

1933: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1934: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1935: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1936: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1937: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1938: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1939: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));
1940:
1941: END IF;

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

1934: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1935: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1936: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1937: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1938: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1939: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));
1940:
1941: END IF;
1942:

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

1935: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1936: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1937: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1938: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1939: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));
1940:
1941: END IF;
1942:
1943: BEGIN

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

1950: l_business_group_id := pay_in_med_web_adi.get_bg_id();
1951:
1952: IF (g_debug)
1953: THEN
1954: pay_in_utils.trace('Business Group:',TO_CHAR (l_business_group_id));
1955: END IF;
1956:
1957:
1958: IF ((p_element_entry_id IS NOT NULL))

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

1957:
1958: IF ((p_element_entry_id IS NOT NULL))
1959: THEN
1960:
1961: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);
1962:
1963: OPEN c_get_ele_object_version(p_element_entry_id) ;
1964: FETCH c_get_ele_object_version INTO l_object_version_no ;
1965: CLOSE c_get_ele_object_version ;

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

1976: l_input_values_rec(l_count).value := c_rec.value;
1977:
1978: IF (g_debug)
1979: THEN
1980: pay_in_utils.trace('Input Values Name:'||l_count,TO_CHAR (c_rec.name));
1981: END IF;
1982:
1983: l_count := l_count + 1;
1984: END LOOP;

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

2023: where AEI_INFORMATION11 = p_element_entry_id
2024: and assignment_id = p_assignment_id;
2025:
2026: p_warnings := 'FALSE';
2027: pay_in_utils.trace('**************************************************','********************');
2028: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
2029: EXCEPTION
2030: WHEN OTHERS THEN
2031: fnd_msg_pub.add_exc_msg

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

2024: and assignment_id = p_assignment_id;
2025:
2026: p_warnings := 'FALSE';
2027: pay_in_utils.trace('**************************************************','********************');
2028: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
2029: EXCEPTION
2030: WHEN OTHERS THEN
2031: fnd_msg_pub.add_exc_msg
2032: (p_pkg_name => g_package