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_US_PAYROLL_UTILS dependencies on HR_UTILITY

Line 279: hr_utility.set_location(gv_package || lv_procedure_name, 1);

275: /********** Bug Number:2973119 End ***************************/
276:
277: BEGIN
278: ln_step := 1;
279: hr_utility.set_location(gv_package || lv_procedure_name, 1);
280: /***************************************************************
281: ** Build a PL/SQL table which has federal tax info
282: ***************************************************************/
283: if p_get_federal = 'Y' and

Line 327: hr_utility.set_location(gv_package || lv_procedure_name, 300);

323:
324: /***************************************************************
325: ** Build a PL/SQL table which has state tax info for all states
326: ***************************************************************/
327: hr_utility.set_location(gv_package || lv_procedure_name, 300);
328: ln_step := 10;
329: hr_utility.set_location(p_get_state,310);
330: hr_utility.set_location(to_char( pay_us_payroll_utils.ltr_state_tax_info.count),320);
331: if p_get_state = 'Y' and

Line 329: hr_utility.set_location(p_get_state,310);

325: ** Build a PL/SQL table which has state tax info for all states
326: ***************************************************************/
327: hr_utility.set_location(gv_package || lv_procedure_name, 300);
328: ln_step := 10;
329: hr_utility.set_location(p_get_state,310);
330: hr_utility.set_location(to_char( pay_us_payroll_utils.ltr_state_tax_info.count),320);
331: if p_get_state = 'Y' and
332: pay_us_payroll_utils.ltr_state_tax_info.count < 1 then
333: open c_get_states_jit(p_effective_date);

Line 330: hr_utility.set_location(to_char( pay_us_payroll_utils.ltr_state_tax_info.count),320);

326: ***************************************************************/
327: hr_utility.set_location(gv_package || lv_procedure_name, 300);
328: ln_step := 10;
329: hr_utility.set_location(p_get_state,310);
330: hr_utility.set_location(to_char( pay_us_payroll_utils.ltr_state_tax_info.count),320);
331: if p_get_state = 'Y' and
332: pay_us_payroll_utils.ltr_state_tax_info.count < 1 then
333: open c_get_states_jit(p_effective_date);
334: loop

Line 341: hr_utility.set_location(gv_package || lv_procedure_name, 310);

337: ln_sdi_ee_limit, ln_sdi_er_limit,
338: lv_steic_exists, ln_state_futa_rate,
339: ln_sdi1_ee_limit;
340: if c_get_states_jit%notfound then
341: hr_utility.set_location(gv_package || lv_procedure_name, 310);
342: exit;
343: end if;
344: hr_utility.set_location(gv_package || lv_procedure_name, 320);
345: hr_utility.trace('lv_state_code = ' || lv_state_code);

Line 344: hr_utility.set_location(gv_package || lv_procedure_name, 320);

340: if c_get_states_jit%notfound then
341: hr_utility.set_location(gv_package || lv_procedure_name, 310);
342: exit;
343: end if;
344: hr_utility.set_location(gv_package || lv_procedure_name, 320);
345: hr_utility.trace('lv_state_code = ' || lv_state_code);
346: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
347: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);
348: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);

Line 345: hr_utility.trace('lv_state_code = ' || lv_state_code);

341: hr_utility.set_location(gv_package || lv_procedure_name, 310);
342: exit;
343: end if;
344: hr_utility.set_location(gv_package || lv_procedure_name, 320);
345: hr_utility.trace('lv_state_code = ' || lv_state_code);
346: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
347: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);
348: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);
349: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);

Line 346: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);

342: exit;
343: end if;
344: hr_utility.set_location(gv_package || lv_procedure_name, 320);
345: hr_utility.trace('lv_state_code = ' || lv_state_code);
346: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
347: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);
348: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);
349: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);
350: hr_utility.trace('ln_sdi1_ee_limit = ' || ln_sdi1_ee_limit);

Line 347: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);

343: end if;
344: hr_utility.set_location(gv_package || lv_procedure_name, 320);
345: hr_utility.trace('lv_state_code = ' || lv_state_code);
346: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
347: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);
348: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);
349: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);
350: hr_utility.trace('ln_sdi1_ee_limit = ' || ln_sdi1_ee_limit);
351: hr_utility.trace('ln_sdi_er_limit = ' || ln_sdi_er_limit);

Line 348: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);

344: hr_utility.set_location(gv_package || lv_procedure_name, 320);
345: hr_utility.trace('lv_state_code = ' || lv_state_code);
346: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
347: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);
348: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);
349: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);
350: hr_utility.trace('ln_sdi1_ee_limit = ' || ln_sdi1_ee_limit);
351: hr_utility.trace('ln_sdi_er_limit = ' || ln_sdi_er_limit);
352: hr_utility.trace('lv_steic_exists = ' || lv_steic_exists);

Line 349: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);

345: hr_utility.trace('lv_state_code = ' || lv_state_code);
346: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
347: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);
348: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);
349: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);
350: hr_utility.trace('ln_sdi1_ee_limit = ' || ln_sdi1_ee_limit);
351: hr_utility.trace('ln_sdi_er_limit = ' || ln_sdi_er_limit);
352: hr_utility.trace('lv_steic_exists = ' || lv_steic_exists);
353: hr_utility.trace('ln_state_futa_rate= '|| ln_state_futa_rate);

Line 350: hr_utility.trace('ln_sdi1_ee_limit = ' || ln_sdi1_ee_limit);

346: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
347: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);
348: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);
349: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);
350: hr_utility.trace('ln_sdi1_ee_limit = ' || ln_sdi1_ee_limit);
351: hr_utility.trace('ln_sdi_er_limit = ' || ln_sdi_er_limit);
352: hr_utility.trace('lv_steic_exists = ' || lv_steic_exists);
353: hr_utility.trace('ln_state_futa_rate= '|| ln_state_futa_rate);
354:

Line 351: hr_utility.trace('ln_sdi_er_limit = ' || ln_sdi_er_limit);

347: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);
348: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);
349: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);
350: hr_utility.trace('ln_sdi1_ee_limit = ' || ln_sdi1_ee_limit);
351: hr_utility.trace('ln_sdi_er_limit = ' || ln_sdi_er_limit);
352: hr_utility.trace('lv_steic_exists = ' || lv_steic_exists);
353: hr_utility.trace('ln_state_futa_rate= '|| ln_state_futa_rate);
354:
355: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists

Line 352: hr_utility.trace('lv_steic_exists = ' || lv_steic_exists);

348: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);
349: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);
350: hr_utility.trace('ln_sdi1_ee_limit = ' || ln_sdi1_ee_limit);
351: hr_utility.trace('ln_sdi_er_limit = ' || ln_sdi_er_limit);
352: hr_utility.trace('lv_steic_exists = ' || lv_steic_exists);
353: hr_utility.trace('ln_state_futa_rate= '|| ln_state_futa_rate);
354:
355: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists
356: := lv_sit_exists;

Line 353: hr_utility.trace('ln_state_futa_rate= '|| ln_state_futa_rate);

349: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);
350: hr_utility.trace('ln_sdi1_ee_limit = ' || ln_sdi1_ee_limit);
351: hr_utility.trace('ln_sdi_er_limit = ' || ln_sdi_er_limit);
352: hr_utility.trace('lv_steic_exists = ' || lv_steic_exists);
353: hr_utility.trace('ln_state_futa_rate= '|| ln_state_futa_rate);
354:
355: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists
356: := lv_sit_exists;
357: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_ee_limit

Line 375: hr_utility.set_location(gv_package || lv_procedure_name, 350);

371:
372: end loop;
373: close c_get_states_jit;
374: end if;
375: hr_utility.set_location(gv_package || lv_procedure_name, 350);
376:
377: ln_step := 55;
378: if p_get_county = 'Y' and
379: pay_us_payroll_utils.ltr_county_tax_info.count < 1 then

Line 387: hr_utility.set_location(gv_package || lv_procedure_name, 360);

383: lv_county_tax_exists,
384: lv_county_head_tax_exists,
385: lv_county_sd_tax_exists;
386: if c_get_county_jit%notfound then
387: hr_utility.set_location(gv_package || lv_procedure_name, 360);
388: exit;
389: end if;
390: hr_utility.set_location(gv_package || lv_procedure_name, 370);
391: hr_utility.trace('lv_jurisdiction_code = ' || lv_jurisdiction_code);

Line 390: hr_utility.set_location(gv_package || lv_procedure_name, 370);

386: if c_get_county_jit%notfound then
387: hr_utility.set_location(gv_package || lv_procedure_name, 360);
388: exit;
389: end if;
390: hr_utility.set_location(gv_package || lv_procedure_name, 370);
391: hr_utility.trace('lv_jurisdiction_code = ' || lv_jurisdiction_code);
392:
393: /****************** Start ****************************************************/
394: lv_temp_state_code := substr(lv_jurisdiction_code,1,2);

Line 391: hr_utility.trace('lv_jurisdiction_code = ' || lv_jurisdiction_code);

387: hr_utility.set_location(gv_package || lv_procedure_name, 360);
388: exit;
389: end if;
390: hr_utility.set_location(gv_package || lv_procedure_name, 370);
391: hr_utility.trace('lv_jurisdiction_code = ' || lv_jurisdiction_code);
392:
393: /****************** Start ****************************************************/
394: lv_temp_state_code := substr(lv_jurisdiction_code,1,2);
395: lv_county_code := substr(lv_jurisdiction_code,4,3);

Line 415: hr_utility.set_location(gv_package || lv_procedure_name, 400);

411: end loop;
412: close c_get_county_jit;
413: end if;
414:
415: hr_utility.set_location(gv_package || lv_procedure_name, 400);
416: ln_step := 60;
417:
418: /*********************** Bug Number:2973119 Changes Start *********************/
419:

Line 424: hr_utility.set_location(gv_package || lv_procedure_name, 450);

420: ln_step := 65;
421: if p_get_city = 'Y' then
422:
423: ln_step := 70 ;
424: hr_utility.set_location(gv_package || lv_procedure_name, 450);
425:
426: lv_temp_state_code := substr(p_jurisdiction_code,1,2);
427: lv_county_code := substr(p_jurisdiction_code,4,3);
428: lv_city_code := substr(p_jurisdiction_code,8,4);

Line 438: hr_utility.set_location(gv_package || lv_procedure_name, 460);

434: lv_city_tax_exists,
435: lv_city_head_tax_exists,
436: lv_city_sd_tax_exists;
437: if c_get_city_jit%notfound then
438: hr_utility.set_location(gv_package || lv_procedure_name, 460);
439: pay_us_payroll_utils.ltr_city_tax_info(ln_index).jurisdiction_code
440: := p_jurisdiction_code;
441: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_tax_exists
442: := NULL;

Line 448: hr_utility.set_location(gv_package || lv_procedure_name, 470);

444: := NULL;
445: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_sd_tax_exists
446: := NULL;
447: else
448: hr_utility.set_location(gv_package || lv_procedure_name, 470);
449: hr_utility.trace('lv_jurisdiction_code = ' || lv_city_jurisdiction_code);
450:
451: pay_us_payroll_utils.ltr_city_tax_info(ln_index).jurisdiction_code
452: := lv_city_jurisdiction_code;

Line 449: hr_utility.trace('lv_jurisdiction_code = ' || lv_city_jurisdiction_code);

445: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_sd_tax_exists
446: := NULL;
447: else
448: hr_utility.set_location(gv_package || lv_procedure_name, 470);
449: hr_utility.trace('lv_jurisdiction_code = ' || lv_city_jurisdiction_code);
450:
451: pay_us_payroll_utils.ltr_city_tax_info(ln_index).jurisdiction_code
452: := lv_city_jurisdiction_code;
453: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_tax_exists

Line 464: hr_utility.set_location(gv_package || lv_procedure_name, 480);

460:
461: close c_get_city_jit;
462: end if;
463:
464: hr_utility.set_location(gv_package || lv_procedure_name, 480);
465: ln_step := 75;
466:
467: /*********************** Bug Number:2973119 Changes End **********************/
468:

Line 471: hr_utility.set_location(gv_package || lv_procedure_name, 500);

467: /*********************** Bug Number:2973119 Changes End **********************/
468:
469: exception
470: when others then
471: hr_utility.set_location(gv_package || lv_procedure_name, 500);
472: lv_error_message := 'Error at step ' || ln_step ||
473: ' in ' || gv_package || lv_procedure_name;
474: hr_utility.trace(lv_error_message || '-' || sqlerrm);
475:

Line 474: hr_utility.trace(lv_error_message || '-' || sqlerrm);

470: when others then
471: hr_utility.set_location(gv_package || lv_procedure_name, 500);
472: lv_error_message := 'Error at step ' || ln_step ||
473: ' in ' || gv_package || lv_procedure_name;
474: hr_utility.trace(lv_error_message || '-' || sqlerrm);
475:
476: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
477: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
478: hr_utility.raise_error;

Line 476: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

472: lv_error_message := 'Error at step ' || ln_step ||
473: ' in ' || gv_package || lv_procedure_name;
474: hr_utility.trace(lv_error_message || '-' || sqlerrm);
475:
476: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
477: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
478: hr_utility.raise_error;
479:
480: END populate_jit_information;

Line 477: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

473: ' in ' || gv_package || lv_procedure_name;
474: hr_utility.trace(lv_error_message || '-' || sqlerrm);
475:
476: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
477: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
478: hr_utility.raise_error;
479:
480: END populate_jit_information;
481:

Line 478: hr_utility.raise_error;

474: hr_utility.trace(lv_error_message || '-' || sqlerrm);
475:
476: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
477: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
478: hr_utility.raise_error;
479:
480: END populate_jit_information;
481:
482: /********************************************************************

Line 547: hr_utility.trace('p_jurisdiction_code is : '|| p_jurisdiction_code);

543: lv_return_value VARCHAR2(1);
544:
545: BEGIN
546:
547: hr_utility.trace('p_jurisdiction_code is : '|| p_jurisdiction_code);
548: hr_utility.trace('p_tax_type is : '|| p_tax_type);
549: hr_utility.trace('p_effective_date is : '|| p_effective_date);
550:
551: lv_state_code := substr(p_jurisdiction_code,1,2);

Line 548: hr_utility.trace('p_tax_type is : '|| p_tax_type);

544:
545: BEGIN
546:
547: hr_utility.trace('p_jurisdiction_code is : '|| p_jurisdiction_code);
548: hr_utility.trace('p_tax_type is : '|| p_tax_type);
549: hr_utility.trace('p_effective_date is : '|| p_effective_date);
550:
551: lv_state_code := substr(p_jurisdiction_code,1,2);
552:

Line 549: hr_utility.trace('p_effective_date is : '|| p_effective_date);

545: BEGIN
546:
547: hr_utility.trace('p_jurisdiction_code is : '|| p_jurisdiction_code);
548: hr_utility.trace('p_tax_type is : '|| p_tax_type);
549: hr_utility.trace('p_effective_date is : '|| p_effective_date);
550:
551: lv_state_code := substr(p_jurisdiction_code,1,2);
552:
553: /********************* Bug Number:2973119 Start *****************/

Line 614: hr_utility.set_location(lv_value,230);

610: if p_tax_type = 'SUI EE' then
611: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_ee_limit;
612: elsif p_tax_type = 'SUI ER' then
613: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_er_limit;
614: hr_utility.set_location(lv_value,230);
615: elsif p_tax_type = 'SDI EE' then
616: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_ee_limit;
617: elsif p_tax_type = 'SDI1 EE' then
618: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi1_ee_limit;

Line 681: hr_utility.trace('lv_temp_code : '|| lv_temp_code);

677: ,p_jurisdiction_code => p_jurisdiction_code);
678: end if;
679:
680: lv_temp_code := lv_state_code||lv_county_code||lv_city_code;
681: hr_utility.trace('lv_temp_code : '|| lv_temp_code);
682: hr_utility.trace(' B4 ln_index_code');
683: ln_index_code := to_number(lv_temp_code);
684: hr_utility.trace(' A4 ln_index_code');
685:

Line 682: hr_utility.trace(' B4 ln_index_code');

678: end if;
679:
680: lv_temp_code := lv_state_code||lv_county_code||lv_city_code;
681: hr_utility.trace('lv_temp_code : '|| lv_temp_code);
682: hr_utility.trace(' B4 ln_index_code');
683: ln_index_code := to_number(lv_temp_code);
684: hr_utility.trace(' A4 ln_index_code');
685:
686: if p_tax_type = 'CITY' then

Line 684: hr_utility.trace(' A4 ln_index_code');

680: lv_temp_code := lv_state_code||lv_county_code||lv_city_code;
681: hr_utility.trace('lv_temp_code : '|| lv_temp_code);
682: hr_utility.trace(' B4 ln_index_code');
683: ln_index_code := to_number(lv_temp_code);
684: hr_utility.trace(' A4 ln_index_code');
685:
686: if p_tax_type = 'CITY' then
687: if pay_us_payroll_utils.ltr_city_tax_info.exists(ln_index_code) then
688:

Line 689: hr_utility.trace(' CITY found in PLSQL table');

685:
686: if p_tax_type = 'CITY' then
687: if pay_us_payroll_utils.ltr_city_tax_info.exists(ln_index_code) then
688:
689: hr_utility.trace(' CITY found in PLSQL table');
690: null;
691: else
692: hr_utility.trace(' CITY NOT found in PLSQL table');
693:

Line 692: hr_utility.trace(' CITY NOT found in PLSQL table');

688:
689: hr_utility.trace(' CITY found in PLSQL table');
690: null;
691: else
692: hr_utility.trace(' CITY NOT found in PLSQL table');
693:
694: populate_jit_information(p_effective_date => p_effective_date
695: ,p_get_city => 'Y'
696: ,p_jurisdiction_code => p_jurisdiction_code);

Line 704: hr_utility.trace(' HT found in PLSQL table');

700: end if;
701:
702: if p_tax_type = 'HT' then
703: if pay_us_payroll_utils.ltr_city_tax_info.exists(ln_index_code) then
704: hr_utility.trace(' HT found in PLSQL table');
705: null;
706: else
707: hr_utility.trace(' HT NOT found in PLSQL table');
708: populate_jit_information(p_effective_date => p_effective_date

Line 707: hr_utility.trace(' HT NOT found in PLSQL table');

703: if pay_us_payroll_utils.ltr_city_tax_info.exists(ln_index_code) then
704: hr_utility.trace(' HT found in PLSQL table');
705: null;
706: else
707: hr_utility.trace(' HT NOT found in PLSQL table');
708: populate_jit_information(p_effective_date => p_effective_date
709: ,p_get_city => 'Y'
710: ,p_jurisdiction_code => p_jurisdiction_code);
711: end if;

Line 806: hr_utility.trace('Start of Procedure '||lv_package_stage);

802: l_valid_count number;
803: l_trunc_date date; /* Bug 3258868 */
804:
805: BEGIN
806: hr_utility.trace('Start of Procedure '||lv_package_stage);
807: hr_utility.set_location(lv_package_stage,10);
808:
809: l_trunc_date := trunc(p_start_date,'Y'); -- Bug 3258868
810:

Line 807: hr_utility.set_location(lv_package_stage,10);

803: l_trunc_date date; /* Bug 3258868 */
804:
805: BEGIN
806: hr_utility.trace('Start of Procedure '||lv_package_stage);
807: hr_utility.set_location(lv_package_stage,10);
808:
809: l_trunc_date := trunc(p_start_date,'Y'); -- Bug 3258868
810:
811: -- Validate if the attribute passed as parameter exists

Line 815: hr_utility.set_location(lv_package_stage,20);

811: -- Validate if the attribute passed as parameter exists
812: open c_attribute_exists(p_attribute_name);
813: fetch c_attribute_exists INTO ln_attribute_exists;
814: if c_attribute_exists%notfound then
815: hr_utility.set_location(lv_package_stage,20);
816: lv_return_status := 'N';
817: hr_utility.trace('Invalid Attribute Name');
818: raise_application_error(-20101, 'Error in pay_us_.check_balance_status');
819: end if;

Line 817: hr_utility.trace('Invalid Attribute Name');

813: fetch c_attribute_exists INTO ln_attribute_exists;
814: if c_attribute_exists%notfound then
815: hr_utility.set_location(lv_package_stage,20);
816: lv_return_status := 'N';
817: hr_utility.trace('Invalid Attribute Name');
818: raise_application_error(-20101, 'Error in pay_us_.check_balance_status');
819: end if;
820: close c_attribute_exists ;
821:

Line 822: hr_utility.set_location(lv_package_stage,30);

818: raise_application_error(-20101, 'Error in pay_us_.check_balance_status');
819: end if;
820: close c_attribute_exists ;
821:
822: hr_utility.set_location(lv_package_stage,30);
823:
824: open c_get_valid_count(l_trunc_date, -- Bug 3258868
825: p_business_group_id,
826: p_attribute_name );

Line 830: hr_utility.trace('Valid Count for '||p_attribute_name||' is '||to_char(l_valid_count));

826: p_attribute_name );
827: fetch c_get_valid_count into l_valid_count;
828: close c_get_valid_count;
829:
830: hr_utility.trace('Valid Count for '||p_attribute_name||' is '||to_char(l_valid_count));
831:
832: /* Do following check only if the attribute count > zero */
833:
834: IF l_valid_count > 0 THEN

Line 842: hr_utility.trace('Attribute Count for '||p_attribute_name||' is '||to_char(l_attribute_count));

838: p_attribute_name );
839: fetch c_get_attribute_count into l_attribute_count;
840: close c_get_attribute_count;
841:
842: hr_utility.trace('Attribute Count for '||p_attribute_name||' is '||to_char(l_attribute_count));
843:
844: if l_valid_count = l_attribute_count then
845:
846: hr_utility.set_location(lv_package_stage,40);

Line 846: hr_utility.set_location(lv_package_stage,40);

842: hr_utility.trace('Attribute Count for '||p_attribute_name||' is '||to_char(l_attribute_count));
843:
844: if l_valid_count = l_attribute_count then
845:
846: hr_utility.set_location(lv_package_stage,40);
847: lv_return_status := 'Y';
848: else
849:
850: -- Bug 3312482 Push statements are deleted.

Line 851: hr_utility.set_location(lv_package_stage,50);

847: lv_return_status := 'Y';
848: else
849:
850: -- Bug 3312482 Push statements are deleted.
851: hr_utility.set_location(lv_package_stage,50);
852:
853: -- Bug 3340952 Push statements are added again.
854: pay_core_utils.push_message(801,'PAY_EXCEPTION','A');
855: pay_core_utils.push_token('description','Warning Invalid Balance Status . ,In Attribute -> ' ||p_attribute_name);

Line 857: hr_utility.trace('Balance Status is Invalid for Attribute -> ' ||p_attribute_name);

853: -- Bug 3340952 Push statements are added again.
854: pay_core_utils.push_message(801,'PAY_EXCEPTION','A');
855: pay_core_utils.push_token('description','Warning Invalid Balance Status . ,In Attribute -> ' ||p_attribute_name);
856:
857: hr_utility.trace('Balance Status is Invalid for Attribute -> ' ||p_attribute_name);
858:
859: lv_return_status := 'N';
860: end if;
861: end if; /* IF l_valid_count > 0 */

Line 862: hr_utility.trace('End of Procedure ' || lv_package_stage);

858:
859: lv_return_status := 'N';
860: end if;
861: end if; /* IF l_valid_count > 0 */
862: hr_utility.trace('End of Procedure ' || lv_package_stage);
863: return(lv_return_status);
864:
865:
866: EXCEPTION

Line 868: hr_utility.set_location(lv_package_stage,60);

864:
865:
866: EXCEPTION
867: WHEN others THEN
868: hr_utility.set_location(lv_package_stage,60);
869: hr_utility.trace('Invalid Attribute Name');
870: raise_application_error(-20101, 'Error in pay_us_.check_balance_status');
871: raise;
872: END check_balance_status;

Line 869: hr_utility.trace('Invalid Attribute Name');

865:
866: EXCEPTION
867: WHEN others THEN
868: hr_utility.set_location(lv_package_stage,60);
869: hr_utility.trace('Invalid Attribute Name');
870: raise_application_error(-20101, 'Error in pay_us_.check_balance_status');
871: raise;
872: END check_balance_status;
873:

Line 894: hr_utility.set_location(gv_package || '.formated_header_string', 10);

890:
891: lv_format VARCHAR2(1000);
892:
893: BEGIN
894: hr_utility.set_location(gv_package || '.formated_header_string', 10);
895: IF p_output_file_type = 'CSV' THEN
896: hr_utility.set_location(gv_package || '.formated_header_string', 20);
897: lv_format := p_input_string;
898: ELSIF p_output_file_type = 'HTML' THEN

Line 896: hr_utility.set_location(gv_package || '.formated_header_string', 20);

892:
893: BEGIN
894: hr_utility.set_location(gv_package || '.formated_header_string', 10);
895: IF p_output_file_type = 'CSV' THEN
896: hr_utility.set_location(gv_package || '.formated_header_string', 20);
897: lv_format := p_input_string;
898: ELSIF p_output_file_type = 'HTML' THEN
899: hr_utility.set_location(gv_package || '.formated_header_string', 30);
900: lv_format := '

' || p_input_string ||

Line 899: hr_utility.set_location(gv_package || '.formated_header_string', 30);

895: IF p_output_file_type = 'CSV' THEN
896: hr_utility.set_location(gv_package || '.formated_header_string', 20);
897: lv_format := p_input_string;
898: ELSIF p_output_file_type = 'HTML' THEN
899: hr_utility.set_location(gv_package || '.formated_header_string', 30);
900: lv_format := '

' || p_input_string ||
901: '
';
902: END IF;
903:

Line 904: hr_utility.set_location(gv_package || '.formated_header_string', 40);

900: lv_format := '

' || p_input_string ||
901: '
';
902: END IF;
903:
904: hr_utility.set_location(gv_package || '.formated_header_string', 40);
905: return lv_format;
906:
907: END formated_header_string;
908:

Line 936: hr_utility.set_location(gv_package || '.formated_data_string', 10);

932: lv_format VARCHAR2(1000);
933: lv_bold VARCHAR2(10);
934: BEGIN
935: lv_bold := nvl(p_bold,'N');
936: hr_utility.set_location(gv_package || '.formated_data_string', 10);
937: IF p_output_file_type = 'CSV' THEN
938: hr_utility.set_location(gv_package || '.formated_data_string', 20);
939: lv_format := gc_csv_data_delimiter || p_input_string ||
940: gc_csv_data_delimiter || gc_csv_delimiter;

Line 938: hr_utility.set_location(gv_package || '.formated_data_string', 20);

934: BEGIN
935: lv_bold := nvl(p_bold,'N');
936: hr_utility.set_location(gv_package || '.formated_data_string', 10);
937: IF p_output_file_type = 'CSV' THEN
938: hr_utility.set_location(gv_package || '.formated_data_string', 20);
939: lv_format := gc_csv_data_delimiter || p_input_string ||
940: gc_csv_data_delimiter || gc_csv_delimiter;
941: ELSIF p_output_file_type = 'HTML' THEN
942: IF p_input_string is null THEN

Line 943: hr_utility.set_location(gv_package || '.formated_data_string', 30);

939: lv_format := gc_csv_data_delimiter || p_input_string ||
940: gc_csv_data_delimiter || gc_csv_delimiter;
941: ELSIF p_output_file_type = 'HTML' THEN
942: IF p_input_string is null THEN
943: hr_utility.set_location(gv_package || '.formated_data_string', 30);
944: lv_format := gv_html_start_data || ' ' || gv_html_end_data; -- Bug 3179050
945: ELSE
946: IF lv_bold = 'Y' THEN
947: hr_utility.set_location(gv_package || '.formated_data_string', 40);

Line 947: hr_utility.set_location(gv_package || '.formated_data_string', 40);

943: hr_utility.set_location(gv_package || '.formated_data_string', 30);
944: lv_format := gv_html_start_data || ' ' || gv_html_end_data; -- Bug 3179050
945: ELSE
946: IF lv_bold = 'Y' THEN
947: hr_utility.set_location(gv_package || '.formated_data_string', 40);
948: lv_format := gv_html_start_data || ' ' || p_input_string
949: || '' || gv_html_end_data;
950: ELSE
951: hr_utility.set_location(gv_package || '.formated_data_string', 50);

Line 951: hr_utility.set_location(gv_package || '.formated_data_string', 50);

947: hr_utility.set_location(gv_package || '.formated_data_string', 40);
948: lv_format := gv_html_start_data || ' ' || p_input_string
949: || '' || gv_html_end_data;
950: ELSE
951: hr_utility.set_location(gv_package || '.formated_data_string', 50);
952: lv_format := gv_html_start_data || p_input_string || gv_html_end_data;
953: END IF;
954: END IF;
955: END IF;

Line 957: hr_utility.set_location(gv_package || '.formated_data_string', 60);

953: END IF;
954: END IF;
955: END IF;
956:
957: hr_utility.set_location(gv_package || '.formated_data_string', 60);
958: return lv_format;
959:
960: END formated_data_string;
961:

Line 1181: hr_utility.set_location(gv_package || '.' || l_procedure_name, 10);

1177: FROM fnd_application
1178: WHERE application_short_name = 'AU';
1179:
1180: BEGIN
1181: hr_utility.set_location(gv_package || '.' || l_procedure_name, 10);
1182:
1183: /* Derive Owner_Id for Owner Name ORACLE /
1184: l_app_user := fnd_load_util.owner_id('ORACLE');
1185:

Line 1186: hr_utility.set_location(gv_package || '.' || l_procedure_name, 20);

1182:
1183: / Derive Owner_Id for Owner Name ORACLE /
1184: l_app_user := fnd_load_util.owner_id('ORACLE');
1185:
1186: hr_utility.set_location(gv_package || '.' || l_procedure_name, 20);
1187:
1188: IF p_state_or_local_tax_form = 'STATE' THEN
1189:
1190: hr_utility.set_location(gv_package || '.' || l_procedure_name, 30);

Line 1190: hr_utility.set_location(gv_package || '.' || l_procedure_name, 30);

1186: hr_utility.set_location(gv_package || '.' || l_procedure_name, 20);
1187:
1188: IF p_state_or_local_tax_form = 'STATE' THEN
1189:
1190: hr_utility.set_location(gv_package || '.' || l_procedure_name, 30);
1191:
1192: / Get the Lookup Details /
1193: OPEN get_lookup_value_cur(p_state, 'PAY_US_OTF_PDF_LINK_W4');
1194: FETCH get_lookup_value_cur INTO l_lookup_type, l_view_application_id,

Line 1199: hr_utility.set_location(gv_package || '.' || l_procedure_name, 40);

1195: l_lookup_code, l_security_group_id,
1196: l_language;
1197:
1198: IF get_lookup_value_cur%FOUND THEN
1199: hr_utility.set_location(gv_package || '.' || l_procedure_name, 40);
1200:
1201: / Update the State Link for the Lookup /
1202: UPDATE fnd_lookup_values
1203: SET description = p_link,

Line 1216: hr_utility.set_location(gv_package || '.' || l_procedure_name, 50);

1212: END IF;
1213:
1214: CLOSE get_lookup_value_cur;
1215:
1216: hr_utility.set_location(gv_package || '.' || l_procedure_name, 50);
1217:
1218: ELSIF p_state_or_local_tax_form = 'LOCAL' THEN
1219:
1220: hr_utility.set_location(gv_package || '.' || l_procedure_name, 60);

Line 1220: hr_utility.set_location(gv_package || '.' || l_procedure_name, 60);

1216: hr_utility.set_location(gv_package || '.' || l_procedure_name, 50);
1217:
1218: ELSIF p_state_or_local_tax_form = 'LOCAL' THEN
1219:
1220: hr_utility.set_location(gv_package || '.' || l_procedure_name, 60);
1221:
1222: / Get the Lookup Details /
1223: OPEN get_lookup_value_cur(p_state, 'PAY_US_LOCAL_PDF_LINK_W4');
1224: FETCH get_lookup_value_cur INTO l_lookup_type, l_view_application_id,

Line 1230: hr_utility.set_location(gv_package || '.' || l_procedure_name, 70);

1226: l_language;
1227:
1228: IF get_lookup_value_cur%NOTFOUND THEN
1229:
1230: hr_utility.set_location(gv_package || '.' || l_procedure_name, 70);
1231:
1232: / Get the State Name /
1233: OPEN get_state_name_cur(p_state);
1234: FETCH get_state_name_cur into l_state_name;

Line 1237: hr_utility.set_location(gv_package || '.' || l_procedure_name, 80);

1233: OPEN get_state_name_cur(p_state);
1234: FETCH get_state_name_cur into l_state_name;
1235: CLOSE get_state_name_cur;
1236:
1237: hr_utility.set_location(gv_package || '.' || l_procedure_name, 80);
1238:
1239: / Get the Application Id /
1240: OPEN get_application_id_cur;
1241: FETCH get_application_id_cur into l_application_id;

Line 1244: hr_utility.set_location(gv_package || '.' || l_procedure_name, 90);

1240: OPEN get_application_id_cur;
1241: FETCH get_application_id_cur into l_application_id;
1242: CLOSE get_application_id_cur;
1243:
1244: hr_utility.set_location(gv_package || '.' || l_procedure_name, 90);
1245:
1246: / Get the Security Group Id /
1247: OPEN get_security_group_id_cur(l_application_id);
1248: FETCH get_security_group_id_cur into l_security_group_id1;

Line 1283: hr_utility.set_location(gv_package || '.' || l_procedure_name, 100);

1279: ,'US'
1280: ,l_security_group_id1
1281: ,l_application_id );
1282:
1283: hr_utility.set_location(gv_package || '.' || l_procedure_name, 100);
1284:
1285: ELSE
1286: hr_utility.set_location(gv_package || '.' || l_procedure_name, 110);
1287:

Line 1286: hr_utility.set_location(gv_package || '.' || l_procedure_name, 110);

1282:
1283: hr_utility.set_location(gv_package || '.' || l_procedure_name, 100);
1284:
1285: ELSE
1286: hr_utility.set_location(gv_package || '.' || l_procedure_name, 110);
1287:
1288: / Update the Local Link for the Lookup */
1289: UPDATE fnd_lookup_values
1290: SET description = p_link,

Line 1302: hr_utility.set_location(gv_package || '.' || l_procedure_name, 120);

1298:
1299: END IF;
1300:
1301: CLOSE get_lookup_value_cur;
1302: hr_utility.set_location(gv_package || '.' || l_procedure_name, 120);
1303:
1304: END IF;
1305: COMMIT;
1306: hr_utility.set_location(gv_package || '.' || l_procedure_name, 130);

Line 1306: hr_utility.set_location(gv_package || '.' || l_procedure_name, 130);

1302: hr_utility.set_location(gv_package || '.' || l_procedure_name, 120);
1303:
1304: END IF;
1305: COMMIT;
1306: hr_utility.set_location(gv_package || '.' || l_procedure_name, 130);
1307:
1308:
1309: EXCEPTION
1310: when others then

Line 1311: hr_utility.set_location(gv_package || '.' || l_procedure_name, 130);

1307:
1308:
1309: EXCEPTION
1310: when others then
1311: hr_utility.set_location(gv_package || '.' || l_procedure_name, 130);
1312: raise_application_error(-20101, 'Error while updating the Link');
1313: raise;
1314: END update_state_or_local_wh_link;
1315: