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.

[Home] [Help]

APPS.PAY_US_PAYROLL_UTILS dependencies on HR_UTILITY

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

267: /********** Bug Number:2973119 End ***************************/
268:
269: BEGIN
270: ln_step := 1;
271: hr_utility.set_location(gv_package || lv_procedure_name, 1);
272: /***************************************************************
273: ** Build a PL/SQL table which has federal tax info
274: ***************************************************************/
275: if p_get_federal = 'Y' and

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

315:
316: /***************************************************************
317: ** Build a PL/SQL table which has state tax info for all states
318: ***************************************************************/
319: hr_utility.set_location(gv_package || lv_procedure_name, 300);
320: ln_step := 10;
321: hr_utility.set_location(p_get_state,310);
322: hr_utility.set_location(to_char( pay_us_payroll_utils.ltr_state_tax_info.count),320);
323: if p_get_state = 'Y' and

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

317: ** Build a PL/SQL table which has state tax info for all states
318: ***************************************************************/
319: hr_utility.set_location(gv_package || lv_procedure_name, 300);
320: ln_step := 10;
321: hr_utility.set_location(p_get_state,310);
322: hr_utility.set_location(to_char( pay_us_payroll_utils.ltr_state_tax_info.count),320);
323: if p_get_state = 'Y' and
324: pay_us_payroll_utils.ltr_state_tax_info.count < 1 then
325: open c_get_states_jit(p_effective_date);

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

318: ***************************************************************/
319: hr_utility.set_location(gv_package || lv_procedure_name, 300);
320: ln_step := 10;
321: hr_utility.set_location(p_get_state,310);
322: hr_utility.set_location(to_char( pay_us_payroll_utils.ltr_state_tax_info.count),320);
323: if p_get_state = 'Y' and
324: pay_us_payroll_utils.ltr_state_tax_info.count < 1 then
325: open c_get_states_jit(p_effective_date);
326: loop

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

328: ln_sui_ee_limit, ln_sui_er_limit ,
329: ln_sdi_ee_limit, ln_sdi_er_limit,
330: lv_steic_exists, ln_state_futa_rate ;
331: if c_get_states_jit%notfound then
332: hr_utility.set_location(gv_package || lv_procedure_name, 310);
333: exit;
334: end if;
335: hr_utility.set_location(gv_package || lv_procedure_name, 320);
336: hr_utility.trace('lv_state_code = ' || lv_state_code);

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

331: if c_get_states_jit%notfound then
332: hr_utility.set_location(gv_package || lv_procedure_name, 310);
333: exit;
334: end if;
335: hr_utility.set_location(gv_package || lv_procedure_name, 320);
336: hr_utility.trace('lv_state_code = ' || lv_state_code);
337: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
338: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);
339: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);

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

332: hr_utility.set_location(gv_package || lv_procedure_name, 310);
333: exit;
334: end if;
335: hr_utility.set_location(gv_package || lv_procedure_name, 320);
336: hr_utility.trace('lv_state_code = ' || lv_state_code);
337: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
338: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);
339: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);
340: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);

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

333: exit;
334: end if;
335: hr_utility.set_location(gv_package || lv_procedure_name, 320);
336: hr_utility.trace('lv_state_code = ' || lv_state_code);
337: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
338: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);
339: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);
340: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);
341: hr_utility.trace('ln_sdi_er_limit = ' || ln_sdi_er_limit);

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

334: end if;
335: hr_utility.set_location(gv_package || lv_procedure_name, 320);
336: hr_utility.trace('lv_state_code = ' || lv_state_code);
337: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
338: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);
339: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);
340: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);
341: hr_utility.trace('ln_sdi_er_limit = ' || ln_sdi_er_limit);
342: hr_utility.trace('lv_steic_exists = ' || lv_steic_exists);

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

335: hr_utility.set_location(gv_package || lv_procedure_name, 320);
336: hr_utility.trace('lv_state_code = ' || lv_state_code);
337: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
338: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);
339: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);
340: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);
341: hr_utility.trace('ln_sdi_er_limit = ' || ln_sdi_er_limit);
342: hr_utility.trace('lv_steic_exists = ' || lv_steic_exists);
343: hr_utility.trace('ln_state_futa_rate= '|| ln_state_futa_rate);

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

336: hr_utility.trace('lv_state_code = ' || lv_state_code);
337: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
338: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);
339: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);
340: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);
341: hr_utility.trace('ln_sdi_er_limit = ' || ln_sdi_er_limit);
342: hr_utility.trace('lv_steic_exists = ' || lv_steic_exists);
343: hr_utility.trace('ln_state_futa_rate= '|| ln_state_futa_rate);
344:

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

337: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
338: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);
339: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);
340: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);
341: hr_utility.trace('ln_sdi_er_limit = ' || ln_sdi_er_limit);
342: hr_utility.trace('lv_steic_exists = ' || lv_steic_exists);
343: hr_utility.trace('ln_state_futa_rate= '|| ln_state_futa_rate);
344:
345: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists

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

338: hr_utility.trace('ln_sui_ee_limit = ' || ln_sui_ee_limit);
339: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);
340: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);
341: hr_utility.trace('ln_sdi_er_limit = ' || ln_sdi_er_limit);
342: hr_utility.trace('lv_steic_exists = ' || lv_steic_exists);
343: hr_utility.trace('ln_state_futa_rate= '|| ln_state_futa_rate);
344:
345: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists
346: := lv_sit_exists;

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

339: hr_utility.trace('ln_sui_er_limit = ' || ln_sui_er_limit);
340: hr_utility.trace('ln_sdi_ee_limit = ' || ln_sdi_ee_limit);
341: hr_utility.trace('ln_sdi_er_limit = ' || ln_sdi_er_limit);
342: hr_utility.trace('lv_steic_exists = ' || lv_steic_exists);
343: hr_utility.trace('ln_state_futa_rate= '|| ln_state_futa_rate);
344:
345: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists
346: := lv_sit_exists;
347: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_ee_limit

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

359:
360: end loop;
361: close c_get_states_jit;
362: end if;
363: hr_utility.set_location(gv_package || lv_procedure_name, 350);
364:
365: ln_step := 55;
366: if p_get_county = 'Y' and
367: pay_us_payroll_utils.ltr_county_tax_info.count < 1 then

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

371: lv_county_tax_exists,
372: lv_county_head_tax_exists,
373: lv_county_sd_tax_exists;
374: if c_get_county_jit%notfound then
375: hr_utility.set_location(gv_package || lv_procedure_name, 360);
376: exit;
377: end if;
378: hr_utility.set_location(gv_package || lv_procedure_name, 370);
379: hr_utility.trace('lv_jurisdiction_code = ' || lv_jurisdiction_code);

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

374: if c_get_county_jit%notfound then
375: hr_utility.set_location(gv_package || lv_procedure_name, 360);
376: exit;
377: end if;
378: hr_utility.set_location(gv_package || lv_procedure_name, 370);
379: hr_utility.trace('lv_jurisdiction_code = ' || lv_jurisdiction_code);
380:
381: /****************** Start ****************************************************/
382: lv_temp_state_code := substr(lv_jurisdiction_code,1,2);

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

375: hr_utility.set_location(gv_package || lv_procedure_name, 360);
376: exit;
377: end if;
378: hr_utility.set_location(gv_package || lv_procedure_name, 370);
379: hr_utility.trace('lv_jurisdiction_code = ' || lv_jurisdiction_code);
380:
381: /****************** Start ****************************************************/
382: lv_temp_state_code := substr(lv_jurisdiction_code,1,2);
383: lv_county_code := substr(lv_jurisdiction_code,4,3);

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

399: end loop;
400: close c_get_county_jit;
401: end if;
402:
403: hr_utility.set_location(gv_package || lv_procedure_name, 400);
404: ln_step := 60;
405:
406: /*********************** Bug Number:2973119 Changes Start *********************/
407:

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

408: ln_step := 65;
409: if p_get_city = 'Y' then
410:
411: ln_step := 70 ;
412: hr_utility.set_location(gv_package || lv_procedure_name, 450);
413:
414: lv_temp_state_code := substr(p_jurisdiction_code,1,2);
415: lv_county_code := substr(p_jurisdiction_code,4,3);
416: lv_city_code := substr(p_jurisdiction_code,8,4);

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

422: lv_city_tax_exists,
423: lv_city_head_tax_exists,
424: lv_city_sd_tax_exists;
425: if c_get_city_jit%notfound then
426: hr_utility.set_location(gv_package || lv_procedure_name, 460);
427: pay_us_payroll_utils.ltr_city_tax_info(ln_index).jurisdiction_code
428: := p_jurisdiction_code;
429: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_tax_exists
430: := NULL;

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

432: := NULL;
433: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_sd_tax_exists
434: := NULL;
435: else
436: hr_utility.set_location(gv_package || lv_procedure_name, 470);
437: hr_utility.trace('lv_jurisdiction_code = ' || lv_city_jurisdiction_code);
438:
439: pay_us_payroll_utils.ltr_city_tax_info(ln_index).jurisdiction_code
440: := lv_city_jurisdiction_code;

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

433: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_sd_tax_exists
434: := NULL;
435: else
436: hr_utility.set_location(gv_package || lv_procedure_name, 470);
437: hr_utility.trace('lv_jurisdiction_code = ' || lv_city_jurisdiction_code);
438:
439: pay_us_payroll_utils.ltr_city_tax_info(ln_index).jurisdiction_code
440: := lv_city_jurisdiction_code;
441: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_tax_exists

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

448:
449: close c_get_city_jit;
450: end if;
451:
452: hr_utility.set_location(gv_package || lv_procedure_name, 480);
453: ln_step := 75;
454:
455: /*********************** Bug Number:2973119 Changes End **********************/
456:

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

455: /*********************** Bug Number:2973119 Changes End **********************/
456:
457: exception
458: when others then
459: hr_utility.set_location(gv_package || lv_procedure_name, 500);
460: lv_error_message := 'Error at step ' || ln_step ||
461: ' in ' || gv_package || lv_procedure_name;
462: hr_utility.trace(lv_error_message || '-' || sqlerrm);
463:

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

458: when others then
459: hr_utility.set_location(gv_package || lv_procedure_name, 500);
460: lv_error_message := 'Error at step ' || ln_step ||
461: ' in ' || gv_package || lv_procedure_name;
462: hr_utility.trace(lv_error_message || '-' || sqlerrm);
463:
464: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
465: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
466: hr_utility.raise_error;

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

460: lv_error_message := 'Error at step ' || ln_step ||
461: ' in ' || gv_package || lv_procedure_name;
462: hr_utility.trace(lv_error_message || '-' || sqlerrm);
463:
464: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
465: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
466: hr_utility.raise_error;
467:
468: END populate_jit_information;

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

461: ' in ' || gv_package || lv_procedure_name;
462: hr_utility.trace(lv_error_message || '-' || sqlerrm);
463:
464: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
465: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
466: hr_utility.raise_error;
467:
468: END populate_jit_information;
469:

Line 466: hr_utility.raise_error;

462: hr_utility.trace(lv_error_message || '-' || sqlerrm);
463:
464: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
465: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
466: hr_utility.raise_error;
467:
468: END populate_jit_information;
469:
470: /********************************************************************

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

531: lv_return_value VARCHAR2(1);
532:
533: BEGIN
534:
535: hr_utility.trace('p_jurisdiction_code is : '|| p_jurisdiction_code);
536: hr_utility.trace('p_tax_type is : '|| p_tax_type);
537: hr_utility.trace('p_effective_date is : '|| p_effective_date);
538:
539: lv_state_code := substr(p_jurisdiction_code,1,2);

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

532:
533: BEGIN
534:
535: hr_utility.trace('p_jurisdiction_code is : '|| p_jurisdiction_code);
536: hr_utility.trace('p_tax_type is : '|| p_tax_type);
537: hr_utility.trace('p_effective_date is : '|| p_effective_date);
538:
539: lv_state_code := substr(p_jurisdiction_code,1,2);
540:

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

533: BEGIN
534:
535: hr_utility.trace('p_jurisdiction_code is : '|| p_jurisdiction_code);
536: hr_utility.trace('p_tax_type is : '|| p_tax_type);
537: hr_utility.trace('p_effective_date is : '|| p_effective_date);
538:
539: lv_state_code := substr(p_jurisdiction_code,1,2);
540:
541: /********************* Bug Number:2973119 Start *****************/

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

598: if p_tax_type = 'SUI EE' then
599: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_ee_limit;
600: elsif p_tax_type = 'SUI ER' then
601: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_er_limit;
602: hr_utility.set_location(lv_value,230);
603: elsif p_tax_type = 'SDI EE' then
604: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_ee_limit;
605: elsif p_tax_type = 'SDI ER' then
606: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit;

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

663: ,p_jurisdiction_code => p_jurisdiction_code);
664: end if;
665:
666: lv_temp_code := lv_state_code||lv_county_code||lv_city_code;
667: hr_utility.trace('lv_temp_code : '|| lv_temp_code);
668: hr_utility.trace(' B4 ln_index_code');
669: ln_index_code := to_number(lv_temp_code);
670: hr_utility.trace(' A4 ln_index_code');
671:

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

664: end if;
665:
666: lv_temp_code := lv_state_code||lv_county_code||lv_city_code;
667: hr_utility.trace('lv_temp_code : '|| lv_temp_code);
668: hr_utility.trace(' B4 ln_index_code');
669: ln_index_code := to_number(lv_temp_code);
670: hr_utility.trace(' A4 ln_index_code');
671:
672: if p_tax_type = 'CITY' then

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

666: lv_temp_code := lv_state_code||lv_county_code||lv_city_code;
667: hr_utility.trace('lv_temp_code : '|| lv_temp_code);
668: hr_utility.trace(' B4 ln_index_code');
669: ln_index_code := to_number(lv_temp_code);
670: hr_utility.trace(' A4 ln_index_code');
671:
672: if p_tax_type = 'CITY' then
673: if pay_us_payroll_utils.ltr_city_tax_info.exists(ln_index_code) then
674:

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

671:
672: if p_tax_type = 'CITY' then
673: if pay_us_payroll_utils.ltr_city_tax_info.exists(ln_index_code) then
674:
675: hr_utility.trace(' CITY found in PLSQL table');
676: null;
677: else
678: hr_utility.trace(' CITY NOT found in PLSQL table');
679:

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

674:
675: hr_utility.trace(' CITY found in PLSQL table');
676: null;
677: else
678: hr_utility.trace(' CITY NOT found in PLSQL table');
679:
680: populate_jit_information(p_effective_date => p_effective_date
681: ,p_get_city => 'Y'
682: ,p_jurisdiction_code => p_jurisdiction_code);

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

686: end if;
687:
688: if p_tax_type = 'HT' then
689: if pay_us_payroll_utils.ltr_city_tax_info.exists(ln_index_code) then
690: hr_utility.trace(' HT found in PLSQL table');
691: null;
692: else
693: hr_utility.trace(' HT NOT found in PLSQL table');
694: populate_jit_information(p_effective_date => p_effective_date

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

689: if pay_us_payroll_utils.ltr_city_tax_info.exists(ln_index_code) then
690: hr_utility.trace(' HT found in PLSQL table');
691: null;
692: else
693: hr_utility.trace(' HT NOT found in PLSQL table');
694: populate_jit_information(p_effective_date => p_effective_date
695: ,p_get_city => 'Y'
696: ,p_jurisdiction_code => p_jurisdiction_code);
697: end if;

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

788: l_valid_count number;
789: l_trunc_date date; /* Bug 3258868 */
790:
791: BEGIN
792: hr_utility.trace('Start of Procedure '||lv_package_stage);
793: hr_utility.set_location(lv_package_stage,10);
794:
795: l_trunc_date := trunc(p_start_date,'Y'); -- Bug 3258868
796:

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

789: l_trunc_date date; /* Bug 3258868 */
790:
791: BEGIN
792: hr_utility.trace('Start of Procedure '||lv_package_stage);
793: hr_utility.set_location(lv_package_stage,10);
794:
795: l_trunc_date := trunc(p_start_date,'Y'); -- Bug 3258868
796:
797: -- Validate if the attribute passed as parameter exists

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

797: -- Validate if the attribute passed as parameter exists
798: open c_attribute_exists(p_attribute_name);
799: fetch c_attribute_exists INTO ln_attribute_exists;
800: if c_attribute_exists%notfound then
801: hr_utility.set_location(lv_package_stage,20);
802: lv_return_status := 'N';
803: hr_utility.trace('Invalid Attribute Name');
804: raise_application_error(-20101, 'Error in pay_us_.check_balance_status');
805: end if;

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

799: fetch c_attribute_exists INTO ln_attribute_exists;
800: if c_attribute_exists%notfound then
801: hr_utility.set_location(lv_package_stage,20);
802: lv_return_status := 'N';
803: hr_utility.trace('Invalid Attribute Name');
804: raise_application_error(-20101, 'Error in pay_us_.check_balance_status');
805: end if;
806: close c_attribute_exists ;
807:

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

804: raise_application_error(-20101, 'Error in pay_us_.check_balance_status');
805: end if;
806: close c_attribute_exists ;
807:
808: hr_utility.set_location(lv_package_stage,30);
809:
810: open c_get_valid_count(l_trunc_date, -- Bug 3258868
811: p_business_group_id,
812: p_attribute_name );

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

812: p_attribute_name );
813: fetch c_get_valid_count into l_valid_count;
814: close c_get_valid_count;
815:
816: hr_utility.trace('Valid Count for '||p_attribute_name||' is '||to_char(l_valid_count));
817:
818: /* Do following check only if the attribute count > zero */
819:
820: IF l_valid_count > 0 THEN

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

824: p_attribute_name );
825: fetch c_get_attribute_count into l_attribute_count;
826: close c_get_attribute_count;
827:
828: hr_utility.trace('Attribute Count for '||p_attribute_name||' is '||to_char(l_attribute_count));
829:
830: if l_valid_count = l_attribute_count then
831:
832: hr_utility.set_location(lv_package_stage,40);

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

828: hr_utility.trace('Attribute Count for '||p_attribute_name||' is '||to_char(l_attribute_count));
829:
830: if l_valid_count = l_attribute_count then
831:
832: hr_utility.set_location(lv_package_stage,40);
833: lv_return_status := 'Y';
834: else
835:
836: -- Bug 3312482 Push statements are deleted.

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

833: lv_return_status := 'Y';
834: else
835:
836: -- Bug 3312482 Push statements are deleted.
837: hr_utility.set_location(lv_package_stage,50);
838:
839: -- Bug 3340952 Push statements are added again.
840: pay_core_utils.push_message(801,'PAY_EXCEPTION','A');
841: pay_core_utils.push_token('description','Warning Invalid Balance Status . ,In Attribute -> ' ||p_attribute_name);

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

839: -- Bug 3340952 Push statements are added again.
840: pay_core_utils.push_message(801,'PAY_EXCEPTION','A');
841: pay_core_utils.push_token('description','Warning Invalid Balance Status . ,In Attribute -> ' ||p_attribute_name);
842:
843: hr_utility.trace('Balance Status is Invalid for Attribute -> ' ||p_attribute_name);
844:
845: lv_return_status := 'N';
846: end if;
847: end if; /* IF l_valid_count > 0 */

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

844:
845: lv_return_status := 'N';
846: end if;
847: end if; /* IF l_valid_count > 0 */
848: hr_utility.trace('End of Procedure ' || lv_package_stage);
849: return(lv_return_status);
850:
851:
852: EXCEPTION

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

850:
851:
852: EXCEPTION
853: WHEN others THEN
854: hr_utility.set_location(lv_package_stage,60);
855: hr_utility.trace('Invalid Attribute Name');
856: raise_application_error(-20101, 'Error in pay_us_.check_balance_status');
857: raise;
858: END check_balance_status;

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

851:
852: EXCEPTION
853: WHEN others THEN
854: hr_utility.set_location(lv_package_stage,60);
855: hr_utility.trace('Invalid Attribute Name');
856: raise_application_error(-20101, 'Error in pay_us_.check_balance_status');
857: raise;
858: END check_balance_status;
859:

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

876:
877: lv_format VARCHAR2(1000);
878:
879: BEGIN
880: hr_utility.set_location(gv_package || '.formated_header_string', 10);
881: IF p_output_file_type = 'CSV' THEN
882: hr_utility.set_location(gv_package || '.formated_header_string', 20);
883: lv_format := p_input_string;
884: ELSIF p_output_file_type = 'HTML' THEN

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

878:
879: BEGIN
880: hr_utility.set_location(gv_package || '.formated_header_string', 10);
881: IF p_output_file_type = 'CSV' THEN
882: hr_utility.set_location(gv_package || '.formated_header_string', 20);
883: lv_format := p_input_string;
884: ELSIF p_output_file_type = 'HTML' THEN
885: hr_utility.set_location(gv_package || '.formated_header_string', 30);
886: lv_format := '

' || p_input_string ||

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

881: IF p_output_file_type = 'CSV' THEN
882: hr_utility.set_location(gv_package || '.formated_header_string', 20);
883: lv_format := p_input_string;
884: ELSIF p_output_file_type = 'HTML' THEN
885: hr_utility.set_location(gv_package || '.formated_header_string', 30);
886: lv_format := '

' || p_input_string ||
887: '
';
888: END IF;
889:

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

886: lv_format := '

' || p_input_string ||
887: '
';
888: END IF;
889:
890: hr_utility.set_location(gv_package || '.formated_header_string', 40);
891: return lv_format;
892:
893: END formated_header_string;
894:

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

918: lv_format VARCHAR2(1000);
919: lv_bold VARCHAR2(10);
920: BEGIN
921: lv_bold := nvl(p_bold,'N');
922: hr_utility.set_location(gv_package || '.formated_data_string', 10);
923: IF p_output_file_type = 'CSV' THEN
924: hr_utility.set_location(gv_package || '.formated_data_string', 20);
925: lv_format := gc_csv_data_delimiter || p_input_string ||
926: gc_csv_data_delimiter || gc_csv_delimiter;

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

920: BEGIN
921: lv_bold := nvl(p_bold,'N');
922: hr_utility.set_location(gv_package || '.formated_data_string', 10);
923: IF p_output_file_type = 'CSV' THEN
924: hr_utility.set_location(gv_package || '.formated_data_string', 20);
925: lv_format := gc_csv_data_delimiter || p_input_string ||
926: gc_csv_data_delimiter || gc_csv_delimiter;
927: ELSIF p_output_file_type = 'HTML' THEN
928: IF p_input_string is null THEN

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

925: lv_format := gc_csv_data_delimiter || p_input_string ||
926: gc_csv_data_delimiter || gc_csv_delimiter;
927: ELSIF p_output_file_type = 'HTML' THEN
928: IF p_input_string is null THEN
929: hr_utility.set_location(gv_package || '.formated_data_string', 30);
930: lv_format := gv_html_start_data || ' ' || gv_html_end_data; -- Bug 3179050
931: ELSE
932: IF lv_bold = 'Y' THEN
933: hr_utility.set_location(gv_package || '.formated_data_string', 40);

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

929: hr_utility.set_location(gv_package || '.formated_data_string', 30);
930: lv_format := gv_html_start_data || ' ' || gv_html_end_data; -- Bug 3179050
931: ELSE
932: IF lv_bold = 'Y' THEN
933: hr_utility.set_location(gv_package || '.formated_data_string', 40);
934: lv_format := gv_html_start_data || ' ' || p_input_string
935: || '' || gv_html_end_data;
936: ELSE
937: hr_utility.set_location(gv_package || '.formated_data_string', 50);

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

933: hr_utility.set_location(gv_package || '.formated_data_string', 40);
934: lv_format := gv_html_start_data || ' ' || p_input_string
935: || '' || gv_html_end_data;
936: ELSE
937: hr_utility.set_location(gv_package || '.formated_data_string', 50);
938: lv_format := gv_html_start_data || p_input_string || gv_html_end_data;
939: END IF;
940: END IF;
941: END IF;

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

939: END IF;
940: END IF;
941: END IF;
942:
943: hr_utility.set_location(gv_package || '.formated_data_string', 60);
944: return lv_format;
945:
946: END formated_data_string;
947: