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.BEN_CWB_WEBADI_UTILS dependencies on HR_UTILITY

Line 12: g_debug boolean := hr_utility.debug_enabled;

8: l_layout_lock_time VARCHAR2(5) := FND_PROFILE.VALUE('BEN_CWB_LAYOUT_LOCK_TIME');
9: key_string VARCHAR2(16) := substr(FND_PROFILE.VALUE('BEN_CWB_ENCRYPT_KEY'),1,16);
10:
11: g_package Varchar2(30) := 'BEN_CWB_WEBADI_UTILS.';
12: g_debug boolean := hr_utility.debug_enabled;
13:
14: --
15: --------------------------create_cwb_layout_row----------------------
16: --

Line 325: hr_utility.set_location('Entering '||l_proc,10);

321: WHERE blc.application_id = p_application_id
322: AND blc.layout_code = p_layout_code;
323:
324: BEGIN
325: hr_utility.set_location('Entering '||l_proc,10);
326: For l_layout_col_rec In c_layout_cols
327: LOOP
328: hr_utility.set_location('Seq Num :'||l_layout_col_rec.sequence_num,25);
329: bne_layout_cols_pkg.delete_row

Line 328: hr_utility.set_location('Seq Num :'||l_layout_col_rec.sequence_num,25);

324: BEGIN
325: hr_utility.set_location('Entering '||l_proc,10);
326: For l_layout_col_rec In c_layout_cols
327: LOOP
328: hr_utility.set_location('Seq Num :'||l_layout_col_rec.sequence_num,25);
329: bne_layout_cols_pkg.delete_row
330: (x_application_id => l_layout_col_rec.application_id
331: ,x_layout_code => l_layout_col_rec.layout_code
332: ,x_block_id => l_layout_col_rec.block_id

Line 335: hr_utility.set_location('Leaving '||l_proc,100);

331: ,x_layout_code => l_layout_col_rec.layout_code
332: ,x_block_id => l_layout_col_rec.block_id
333: ,x_sequence_num => l_layout_col_rec.sequence_num);
334: END LOOP;
335: hr_utility.set_location('Leaving '||l_proc,100);
336: EXCEPTION
337: WHEN OTHERS THEN
338: hr_utility.set_location('ERROR occured',30);
339: Null;

Line 338: hr_utility.set_location('ERROR occured',30);

334: END LOOP;
335: hr_utility.set_location('Leaving '||l_proc,100);
336: EXCEPTION
337: WHEN OTHERS THEN
338: hr_utility.set_location('ERROR occured',30);
339: Null;
340: END delete_cwb_layout_cols;
341:
342: --

Line 494: hr_utility.set_location('Options Exists',50);

490: If (l_group_opt_exists_rec.IdCount <> 0 OR l_actual_opt_exists_rec.IdCount <> 0) Then
491:
492: -- If Group Options Exists
493: Begin
494: hr_utility.set_location('Options Exists',50);
495: Open opt1_exists;
496: Fetch opt1_exists into l_opt1_exists_rec;
497: Close opt1_exists;
498:

Line 517: hr_utility.set_location('Opt1 Exists .. Count :'||l_count,100);

513: If (l_opt1_exists_rec.IdCount <> 0) then
514: l_show_hide_data(l_count).p_type := 'OPT1';
515: l_show_hide_data(l_count).p_opt_defined := 'Y';
516:
517: hr_utility.set_location('Opt1 Exists .. Count :'||l_count,100);
518: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_type,105);
519:
520:
521: If l_opt1_exists_rec.ws_abr_id is not Null Then

Line 518: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_type,105);

514: l_show_hide_data(l_count).p_type := 'OPT1';
515: l_show_hide_data(l_count).p_opt_defined := 'Y';
516:
517: hr_utility.set_location('Opt1 Exists .. Count :'||l_count,100);
518: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_type,105);
519:
520:
521: If l_opt1_exists_rec.ws_abr_id is not Null Then
522: l_show_hide_data(l_count).p_ws_defined := 'Y';

Line 538: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_type,105);

534: l_show_hide_data(l_count).p_nnmntry_uom := 'Y';
535: Else
536: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
537: End if;
538: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_type,105);
539: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_ws_defined,115);
540: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,120);
541: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_nnmntry_uom,125);
542:

Line 539: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_ws_defined,115);

535: Else
536: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
537: End if;
538: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_type,105);
539: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_ws_defined,115);
540: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,120);
541: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_nnmntry_uom,125);
542:
543: Else

Line 540: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,120);

536: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
537: End if;
538: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_type,105);
539: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_ws_defined,115);
540: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,120);
541: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_nnmntry_uom,125);
542:
543: Else
544: l_show_hide_data(l_count).p_type := 'OPT1';

Line 541: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_nnmntry_uom,125);

537: End if;
538: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_type,105);
539: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_ws_defined,115);
540: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,120);
541: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_nnmntry_uom,125);
542:
543: Else
544: l_show_hide_data(l_count).p_type := 'OPT1';
545: l_show_hide_data(l_count).p_opt_defined := 'N';

Line 546: hr_utility.set_location('Opt1 Not Exists',120);

542:
543: Else
544: l_show_hide_data(l_count).p_type := 'OPT1';
545: l_show_hide_data(l_count).p_opt_defined := 'N';
546: hr_utility.set_location('Opt1 Not Exists',120);
547: End If;
548:
549: ----------------------------- Option 2 ------------------------------------------
550: l_count := l_show_hide_data.count +1 ;

Line 555: hr_utility.set_location('Opt2 Exists... Count :'||l_count,170);

551: If (l_opt2_exists_rec.IdCount <> 0) then
552: l_show_hide_data(l_count).p_type := 'OPT2';
553: l_show_hide_data(l_count).p_opt_defined := 'Y';
554:
555: hr_utility.set_location('Opt2 Exists... Count :'||l_count,170);
556: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_type,175);
557:
558: If l_opt2_exists_rec.ws_abr_id is not Null Then
559: l_show_hide_data(l_count).p_ws_defined := 'Y';

Line 556: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_type,175);

552: l_show_hide_data(l_count).p_type := 'OPT2';
553: l_show_hide_data(l_count).p_opt_defined := 'Y';
554:
555: hr_utility.set_location('Opt2 Exists... Count :'||l_count,170);
556: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_type,175);
557:
558: If l_opt2_exists_rec.ws_abr_id is not Null Then
559: l_show_hide_data(l_count).p_ws_defined := 'Y';
560: Else

Line 575: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_type,250);

571: l_show_hide_data(l_count).p_nnmntry_uom := 'Y';
572: Else
573: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
574: End if;
575: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_type,250);
576: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_ws_defined,255);
577: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,260);
578: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_nnmntry_uom,265);
579:

Line 576: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_ws_defined,255);

572: Else
573: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
574: End if;
575: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_type,250);
576: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_ws_defined,255);
577: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,260);
578: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_nnmntry_uom,265);
579:
580: Else

Line 577: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,260);

573: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
574: End if;
575: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_type,250);
576: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_ws_defined,255);
577: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,260);
578: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_nnmntry_uom,265);
579:
580: Else
581: hr_utility.set_location('Opt2 Not Exists',240);

Line 578: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_nnmntry_uom,265);

574: End if;
575: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_type,250);
576: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_ws_defined,255);
577: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,260);
578: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_nnmntry_uom,265);
579:
580: Else
581: hr_utility.set_location('Opt2 Not Exists',240);
582: l_show_hide_data(l_count).p_type := 'OPT2';

Line 581: hr_utility.set_location('Opt2 Not Exists',240);

577: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,260);
578: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_nnmntry_uom,265);
579:
580: Else
581: hr_utility.set_location('Opt2 Not Exists',240);
582: l_show_hide_data(l_count).p_type := 'OPT2';
583: l_show_hide_data(l_count).p_opt_defined := 'N';
584: End If;
585:

Line 594: hr_utility.set_location('Opt3 Exists...Count :'||l_count,300);

590:
591: l_show_hide_data(l_count).p_type := 'OPT3';
592: l_show_hide_data(l_count).p_opt_defined := 'Y';
593:
594: hr_utility.set_location('Opt3 Exists...Count :'||l_count,300);
595: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_type,305);
596: If l_opt3_exists_rec.ws_abr_id is not Null Then
597: l_show_hide_data(l_count).p_ws_defined := 'Y';
598: Else

Line 595: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_type,305);

591: l_show_hide_data(l_count).p_type := 'OPT3';
592: l_show_hide_data(l_count).p_opt_defined := 'Y';
593:
594: hr_utility.set_location('Opt3 Exists...Count :'||l_count,300);
595: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_type,305);
596: If l_opt3_exists_rec.ws_abr_id is not Null Then
597: l_show_hide_data(l_count).p_ws_defined := 'Y';
598: Else
599: l_show_hide_data(l_count).p_ws_defined := 'N';

Line 613: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_type,355);

609: l_show_hide_data(l_count).p_nnmntry_uom := 'Y';
610: Else
611: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
612: End if;
613: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_type,355);
614: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_ws_defined,360);
615: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,365);
616: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_nnmntry_uom,370);
617:

Line 614: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_ws_defined,360);

610: Else
611: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
612: End if;
613: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_type,355);
614: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_ws_defined,360);
615: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,365);
616: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_nnmntry_uom,370);
617:
618: Else

Line 615: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,365);

611: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
612: End if;
613: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_type,355);
614: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_ws_defined,360);
615: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,365);
616: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_nnmntry_uom,370);
617:
618: Else
619: l_show_hide_data(l_count).p_type := 'OPT3';

Line 616: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_nnmntry_uom,370);

612: End if;
613: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_type,355);
614: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_ws_defined,360);
615: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,365);
616: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_nnmntry_uom,370);
617:
618: Else
619: l_show_hide_data(l_count).p_type := 'OPT3';
620: l_show_hide_data(l_count).p_opt_defined := 'N';

Line 621: hr_utility.set_location('Opt3 Not Exists',350);

617:
618: Else
619: l_show_hide_data(l_count).p_type := 'OPT3';
620: l_show_hide_data(l_count).p_opt_defined := 'N';
621: hr_utility.set_location('Opt3 Not Exists',350);
622: End If;
623:
624: ----------------------------- Option 4 ------------------------------------------
625: l_count := l_show_hide_data.count +1 ;

Line 631: hr_utility.set_location('Opt4 Exists...Count :'||l_count,400);

627:
628: l_show_hide_data(l_count).p_type := 'OPT4';
629: l_show_hide_data(l_count).p_opt_defined := 'Y';
630:
631: hr_utility.set_location('Opt4 Exists...Count :'||l_count,400);
632: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_type,405);
633: If l_opt4_exists_rec.ws_abr_id is not Null Then
634: l_show_hide_data(l_count).p_ws_defined := 'Y';
635: Else

Line 632: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_type,405);

628: l_show_hide_data(l_count).p_type := 'OPT4';
629: l_show_hide_data(l_count).p_opt_defined := 'Y';
630:
631: hr_utility.set_location('Opt4 Exists...Count :'||l_count,400);
632: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_type,405);
633: If l_opt4_exists_rec.ws_abr_id is not Null Then
634: l_show_hide_data(l_count).p_ws_defined := 'Y';
635: Else
636: l_show_hide_data(l_count).p_ws_defined := 'N';

Line 650: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_type,555);

646: l_show_hide_data(l_count).p_nnmntry_uom := 'Y';
647: Else
648: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
649: End if;
650: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_type,555);
651: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_ws_defined,560);
652: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,565);
653: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_nnmntry_uom,570);
654:

Line 651: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_ws_defined,560);

647: Else
648: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
649: End if;
650: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_type,555);
651: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_ws_defined,560);
652: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,565);
653: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_nnmntry_uom,570);
654:
655: Else

Line 652: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,565);

648: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
649: End if;
650: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_type,555);
651: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_ws_defined,560);
652: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,565);
653: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_nnmntry_uom,570);
654:
655: Else
656: l_show_hide_data(l_count).p_type := 'OPT4';

Line 653: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_nnmntry_uom,570);

649: End if;
650: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_type,555);
651: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_ws_defined,560);
652: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,565);
653: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_nnmntry_uom,570);
654:
655: Else
656: l_show_hide_data(l_count).p_type := 'OPT4';
657: l_show_hide_data(l_count).p_opt_defined := 'N';

Line 658: hr_utility.set_location('Opt4 Not Exists',500);

654:
655: Else
656: l_show_hide_data(l_count).p_type := 'OPT4';
657: l_show_hide_data(l_count).p_opt_defined := 'N';
658: hr_utility.set_location('Opt4 Not Exists',500);
659: End If;
660: End;
661:
662: Else

Line 670: hr_utility.set_location('Options Not Exists ...Count :'||l_count,560);

666: -- If Group Options not exists
667: l_count := l_show_hide_data.count +1 ;
668: l_show_hide_data(l_count).p_type := 'PLOY';
669: l_show_hide_data(l_count).p_opt_defined := 'N';
670: hr_utility.set_location('Options Not Exists ...Count :'||l_count,560);
671: If (l_actual_plans_rec.ws_abr_id is not Null OR
672: l_group_plan_rec.ws_abr_id is not Null )Then
673: l_show_hide_data(l_count).p_ws_defined := 'Y';
674: Else

Line 702: hr_utility.set_location('Final count'||l_count, 500);

698:
699:
700: End;
701: End If;
702: hr_utility.set_location('Final count'||l_count, 500);
703:
704: For i in l_show_hide_data.first..l_show_hide_data.last
705: Loop
706: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 500);

Line 706: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 500);

702: hr_utility.set_location('Final count'||l_count, 500);
703:
704: For i in l_show_hide_data.first..l_show_hide_data.last
705: Loop
706: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 500);
707: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 510);
708: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 520);
709: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 530);
710: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 540);

Line 707: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 510);

703:
704: For i in l_show_hide_data.first..l_show_hide_data.last
705: Loop
706: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 500);
707: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 510);
708: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 520);
709: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 530);
710: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 540);
711: hr_utility.set_location('ws_sub_acty_typ_cd('||i||') :'||l_show_hide_data(i).p_ws_sub_acty_typ_cd, 541);

Line 708: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 520);

704: For i in l_show_hide_data.first..l_show_hide_data.last
705: Loop
706: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 500);
707: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 510);
708: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 520);
709: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 530);
710: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 540);
711: hr_utility.set_location('ws_sub_acty_typ_cd('||i||') :'||l_show_hide_data(i).p_ws_sub_acty_typ_cd, 541);
712:

Line 709: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 530);

705: Loop
706: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 500);
707: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 510);
708: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 520);
709: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 530);
710: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 540);
711: hr_utility.set_location('ws_sub_acty_typ_cd('||i||') :'||l_show_hide_data(i).p_ws_sub_acty_typ_cd, 541);
712:
713: End Loop;

Line 710: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 540);

706: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 500);
707: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 510);
708: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 520);
709: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 530);
710: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 540);
711: hr_utility.set_location('ws_sub_acty_typ_cd('||i||') :'||l_show_hide_data(i).p_ws_sub_acty_typ_cd, 541);
712:
713: End Loop;
714: p_show_hide_data := l_show_hide_data;

Line 711: hr_utility.set_location('ws_sub_acty_typ_cd('||i||') :'||l_show_hide_data(i).p_ws_sub_acty_typ_cd, 541);

707: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 510);
708: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 520);
709: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 530);
710: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 540);
711: hr_utility.set_location('ws_sub_acty_typ_cd('||i||') :'||l_show_hide_data(i).p_ws_sub_acty_typ_cd, 541);
712:
713: End Loop;
714: p_show_hide_data := l_show_hide_data;
715: Exception

Line 717: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);

713: End Loop;
714: p_show_hide_data := l_show_hide_data;
715: Exception
716: when others then
717: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
718: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
719: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
720:
721: end check_hidden_worksheet_columns;

Line 718: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);

714: p_show_hide_data := l_show_hide_data;
715: Exception
716: when others then
717: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
718: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
719: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
720:
721: end check_hidden_worksheet_columns;
722: --

Line 719: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);

715: Exception
716: when others then
717: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
718: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
719: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
720:
721: end check_hidden_worksheet_columns;
722: --
723: ------------------------ decide_insert_rec-----------------------

Line 811: hr_utility.set_location('Entering :'||l_proc,10);

807:
808:
809: Begin
810:
811: hr_utility.set_location('Entering :'||l_proc,10);
812: hr_utility.set_location('** p_inf_seq :'||p_inf_seq,20);
813:
814: check_hidden_worksheet_columns( p_group_pl_id => p_group_pl_id
815: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt

Line 812: hr_utility.set_location('** p_inf_seq :'||p_inf_seq,20);

808:
809: Begin
810:
811: hr_utility.set_location('Entering :'||l_proc,10);
812: hr_utility.set_location('** p_inf_seq :'||p_inf_seq,20);
813:
814: check_hidden_worksheet_columns( p_group_pl_id => p_group_pl_id
815: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
816: ,p_show_hide_data => l_show_hide_data);

Line 820: hr_utility.set_location('l_show_hide_data.count :'||l_show_hide_data.count,785);

816: ,p_show_hide_data => l_show_hide_data);
817:
818:
819:
820: hr_utility.set_location('l_show_hide_data.count :'||l_show_hide_data.count,785);
821: hr_utility.set_location('l_show_hide_data.first :'||l_show_hide_data.first,786);
822: hr_utility.set_location('l_show_hide_data.last :'||l_show_hide_data.last,787);
823:
824:

Line 821: hr_utility.set_location('l_show_hide_data.first :'||l_show_hide_data.first,786);

817:
818:
819:
820: hr_utility.set_location('l_show_hide_data.count :'||l_show_hide_data.count,785);
821: hr_utility.set_location('l_show_hide_data.first :'||l_show_hide_data.first,786);
822: hr_utility.set_location('l_show_hide_data.last :'||l_show_hide_data.last,787);
823:
824:
825: /*open csr_promotions;

Line 822: hr_utility.set_location('l_show_hide_data.last :'||l_show_hide_data.last,787);

818:
819:
820: hr_utility.set_location('l_show_hide_data.count :'||l_show_hide_data.count,785);
821: hr_utility.set_location('l_show_hide_data.first :'||l_show_hide_data.first,786);
822: hr_utility.set_location('l_show_hide_data.last :'||l_show_hide_data.last,787);
823:
824:
825: /*open csr_promotions;
826: fetch csr_promotions into l_option;

Line 834: hr_utility.set_location('Assignment Update Effective Date Not defined for the plan :' || p_group_pl_id,785);

830: fetch csr_asg_updt_date into l_option;
831: close csr_asg_updt_date;
832: if l_option is null then
833: l_insert_rec := 'N';
834: hr_utility.set_location('Assignment Update Effective Date Not defined for the plan :' || p_group_pl_id,785);
835: end if;
836: End if;*/
837:
838:

Line 841: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 4900);

837:
838:
839: For i in l_show_hide_data.first..l_show_hide_data.last
840: Loop
841: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 4900);
842: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 500);
843: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 510);
844: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 520);
845: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 530);

Line 842: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 500);

838:
839: For i in l_show_hide_data.first..l_show_hide_data.last
840: Loop
841: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 4900);
842: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 500);
843: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 510);
844: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 520);
845: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 530);
846:

Line 843: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 510);

839: For i in l_show_hide_data.first..l_show_hide_data.last
840: Loop
841: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 4900);
842: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 500);
843: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 510);
844: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 520);
845: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 530);
846:
847: if (l_show_hide_data(i).p_type = 'PLOY') then

Line 844: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 520);

840: Loop
841: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 4900);
842: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 500);
843: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 510);
844: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 520);
845: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 530);
846:
847: if (l_show_hide_data(i).p_type = 'PLOY') then
848: l_PLOY_index := i;

Line 845: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 530);

841: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 4900);
842: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 500);
843: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 510);
844: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 520);
845: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 530);
846:
847: if (l_show_hide_data(i).p_type = 'PLOY') then
848: l_PLOY_index := i;
849: end if;

Line 867: hr_utility.set_location('l_PLOY_index :'||l_PLOY_index,540);

863: if (l_show_hide_data(i).p_type = 'OPT4') then
864: l_OPT4_index := i;
865: end if;
866: End Loop;
867: hr_utility.set_location('l_PLOY_index :'||l_PLOY_index,540);
868: hr_utility.set_location('l_OPT1_index :'||l_OPT1_index,541);
869: hr_utility.set_location('l_OPT2_index :'||l_OPT2_index,542);
870: hr_utility.set_location('l_OPT3_index :'||l_OPT3_index,543);
871: hr_utility.set_location('l_OPT4_index :'||l_OPT4_index,544);

Line 868: hr_utility.set_location('l_OPT1_index :'||l_OPT1_index,541);

864: l_OPT4_index := i;
865: end if;
866: End Loop;
867: hr_utility.set_location('l_PLOY_index :'||l_PLOY_index,540);
868: hr_utility.set_location('l_OPT1_index :'||l_OPT1_index,541);
869: hr_utility.set_location('l_OPT2_index :'||l_OPT2_index,542);
870: hr_utility.set_location('l_OPT3_index :'||l_OPT3_index,543);
871: hr_utility.set_location('l_OPT4_index :'||l_OPT4_index,544);
872:

Line 869: hr_utility.set_location('l_OPT2_index :'||l_OPT2_index,542);

865: end if;
866: End Loop;
867: hr_utility.set_location('l_PLOY_index :'||l_PLOY_index,540);
868: hr_utility.set_location('l_OPT1_index :'||l_OPT1_index,541);
869: hr_utility.set_location('l_OPT2_index :'||l_OPT2_index,542);
870: hr_utility.set_location('l_OPT3_index :'||l_OPT3_index,543);
871: hr_utility.set_location('l_OPT4_index :'||l_OPT4_index,544);
872:
873:

Line 870: hr_utility.set_location('l_OPT3_index :'||l_OPT3_index,543);

866: End Loop;
867: hr_utility.set_location('l_PLOY_index :'||l_PLOY_index,540);
868: hr_utility.set_location('l_OPT1_index :'||l_OPT1_index,541);
869: hr_utility.set_location('l_OPT2_index :'||l_OPT2_index,542);
870: hr_utility.set_location('l_OPT3_index :'||l_OPT3_index,543);
871: hr_utility.set_location('l_OPT4_index :'||l_OPT4_index,544);
872:
873:
874: --------------------------------Start of Plan Only--------------------------------

Line 871: hr_utility.set_location('l_OPT4_index :'||l_OPT4_index,544);

867: hr_utility.set_location('l_PLOY_index :'||l_PLOY_index,540);
868: hr_utility.set_location('l_OPT1_index :'||l_OPT1_index,541);
869: hr_utility.set_location('l_OPT2_index :'||l_OPT2_index,542);
870: hr_utility.set_location('l_OPT3_index :'||l_OPT3_index,543);
871: hr_utility.set_location('l_OPT4_index :'||l_OPT4_index,544);
872:
873:
874: --------------------------------Start of Plan Only--------------------------------
875: IF (l_PLOY_index <> 0 and l_show_hide_data(l_PLOY_index).p_type = 'PLOY' ) THEN

Line 877: hr_utility.set_location('Start of Plan Only',545);

873:
874: --------------------------------Start of Plan Only--------------------------------
875: IF (l_PLOY_index <> 0 and l_show_hide_data(l_PLOY_index).p_type = 'PLOY' ) THEN
876: Begin
877: hr_utility.set_location('Start of Plan Only',545);
878: -- If No Options Exists then disable all Option Columns
879: Open csr_is_options;
880: Fetch csr_is_options into l_option;
881: Close csr_is_options;

Line 888: hr_utility.set_location('Plan WS Aount Not defined....',800);

884: End if;
885:
886: -- Plan Level Checks
887: If l_show_hide_data(l_PLOY_index).p_ws_defined = 'N' And (p_inf_seq in (12,7,159,165,9,5,164) ) then
888: hr_utility.set_location('Plan WS Aount Not defined....',800);
889: hr_utility.set_location('p_inf_seq : (12,7,159,165,9,5,164)'||p_inf_seq,820);
890: l_insert_rec := 'N';
891: End if;
892:

Line 889: hr_utility.set_location('p_inf_seq : (12,7,159,165,9,5,164)'||p_inf_seq,820);

885:
886: -- Plan Level Checks
887: If l_show_hide_data(l_PLOY_index).p_ws_defined = 'N' And (p_inf_seq in (12,7,159,165,9,5,164) ) then
888: hr_utility.set_location('Plan WS Aount Not defined....',800);
889: hr_utility.set_location('p_inf_seq : (12,7,159,165,9,5,164)'||p_inf_seq,820);
890: l_insert_rec := 'N';
891: End if;
892:
893: If l_show_hide_data(l_PLOY_index).p_eligy_sal_defined = 'N' And (p_inf_seq in (165,9,5,164) ) then

Line 894: hr_utility.set_location( 'Plan Eligible Sal Not Defined...',820);

890: l_insert_rec := 'N';
891: End if;
892:
893: If l_show_hide_data(l_PLOY_index).p_eligy_sal_defined = 'N' And (p_inf_seq in (165,9,5,164) ) then
894: hr_utility.set_location( 'Plan Eligible Sal Not Defined...',820);
895: hr_utility.set_location('p_inf_seq : (165,9,5,164)'||p_inf_seq,850);
896: l_insert_rec := 'N';
897: End if;
898:

Line 895: hr_utility.set_location('p_inf_seq : (165,9,5,164)'||p_inf_seq,850);

891: End if;
892:
893: If l_show_hide_data(l_PLOY_index).p_eligy_sal_defined = 'N' And (p_inf_seq in (165,9,5,164) ) then
894: hr_utility.set_location( 'Plan Eligible Sal Not Defined...',820);
895: hr_utility.set_location('p_inf_seq : (165,9,5,164)'||p_inf_seq,850);
896: l_insert_rec := 'N';
897: End if;
898:
899: /* If l_show_hide_data(l_PLOY_index).p_nnmntry_uom = 'Y' And( p_inf_seq in (7,159,165,9,5,164)) then

Line 900: hr_utility.set_location( 'Plan is Non monetory Unit...',860);

896: l_insert_rec := 'N';
897: End if;
898:
899: /* If l_show_hide_data(l_PLOY_index).p_nnmntry_uom = 'Y' And( p_inf_seq in (7,159,165,9,5,164)) then
900: hr_utility.set_location( 'Plan is Non monetory Unit...',860);
901: hr_utility.set_location('p_inf_seq : (7,159,165,9,5,164)'||p_inf_seq,850);
902: l_insert_rec := 'N';
903: End if;
904: */

Line 901: hr_utility.set_location('p_inf_seq : (7,159,165,9,5,164)'||p_inf_seq,850);

897: End if;
898:
899: /* If l_show_hide_data(l_PLOY_index).p_nnmntry_uom = 'Y' And( p_inf_seq in (7,159,165,9,5,164)) then
900: hr_utility.set_location( 'Plan is Non monetory Unit...',860);
901: hr_utility.set_location('p_inf_seq : (7,159,165,9,5,164)'||p_inf_seq,850);
902: l_insert_rec := 'N';
903: End if;
904: */
905: ----------------------------------

Line 941: hr_utility.set_location( 'Plan is Salary ...',870);

937:
938: ----------------------------------
939:
940: If (l_show_hide_data(l_PLOY_index).p_ws_sub_acty_typ_cd = 'N' And p_inf_seq = 164) then
941: hr_utility.set_location( 'Plan is Salary ...',870);
942: hr_utility.set_location('(p_inf_seq = 164) :'||p_inf_seq,890);
943: l_insert_rec := 'N';
944: End if;
945:

Line 942: hr_utility.set_location('(p_inf_seq = 164) :'||p_inf_seq,890);

938: ----------------------------------
939:
940: If (l_show_hide_data(l_PLOY_index).p_ws_sub_acty_typ_cd = 'N' And p_inf_seq = 164) then
941: hr_utility.set_location( 'Plan is Salary ...',870);
942: hr_utility.set_location('(p_inf_seq = 164) :'||p_inf_seq,890);
943: l_insert_rec := 'N';
944: End if;
945:
946: End;

Line 957: hr_utility.set_location( 'Option 1 is not defined...',900);

953: -- Option1
954: IF (l_OPT1_index <> 0 And l_show_hide_data(l_OPT1_index).p_type = 'OPT1' ) THEN
955: Begin
956: If l_show_hide_data(l_OPT1_index).p_opt_defined = 'N' then
957: hr_utility.set_location( 'Option 1 is not defined...',900);
958: -- Disable all Option1 Columns
959: Open csr_opt1;
960: Fetch csr_opt1 into l_option;
961: Close csr_opt1;

Line 966: hr_utility.set_location( 'Option 1 is defined...',910);

962: If l_option is not null then
963: l_insert_rec := 'N';
964: End if;
965: Else
966: hr_utility.set_location( 'Option 1 is defined...',910);
967: -- Option1 Level Checks
968: If l_show_hide_data(l_OPT1_index).p_ws_defined = 'N' And (p_inf_seq in (30,25,160,166,27) ) then
969: hr_utility.set_location( 'Option 1 worksheet Amount is not defined...',920);
970: hr_utility.set_location('p_inf_seq : (30,25,160,166,27)'||p_inf_seq,950);

Line 969: hr_utility.set_location( 'Option 1 worksheet Amount is not defined...',920);

965: Else
966: hr_utility.set_location( 'Option 1 is defined...',910);
967: -- Option1 Level Checks
968: If l_show_hide_data(l_OPT1_index).p_ws_defined = 'N' And (p_inf_seq in (30,25,160,166,27) ) then
969: hr_utility.set_location( 'Option 1 worksheet Amount is not defined...',920);
970: hr_utility.set_location('p_inf_seq : (30,25,160,166,27)'||p_inf_seq,950);
971: l_insert_rec := 'N';
972: End if;
973:

Line 970: hr_utility.set_location('p_inf_seq : (30,25,160,166,27)'||p_inf_seq,950);

966: hr_utility.set_location( 'Option 1 is defined...',910);
967: -- Option1 Level Checks
968: If l_show_hide_data(l_OPT1_index).p_ws_defined = 'N' And (p_inf_seq in (30,25,160,166,27) ) then
969: hr_utility.set_location( 'Option 1 worksheet Amount is not defined...',920);
970: hr_utility.set_location('p_inf_seq : (30,25,160,166,27)'||p_inf_seq,950);
971: l_insert_rec := 'N';
972: End if;
973:
974: If l_show_hide_data(l_OPT1_index).p_eligy_sal_defined = 'N' And (p_inf_seq in (166,27) ) then

Line 975: hr_utility.set_location( 'Option 1 Eligibile Sal is not defined...',970);

971: l_insert_rec := 'N';
972: End if;
973:
974: If l_show_hide_data(l_OPT1_index).p_eligy_sal_defined = 'N' And (p_inf_seq in (166,27) ) then
975: hr_utility.set_location( 'Option 1 Eligibile Sal is not defined...',970);
976: hr_utility.set_location('p_inf_seq : (166,27)'||p_inf_seq,1000);
977: l_insert_rec := 'N';
978: End if;
979:

Line 976: hr_utility.set_location('p_inf_seq : (166,27)'||p_inf_seq,1000);

972: End if;
973:
974: If l_show_hide_data(l_OPT1_index).p_eligy_sal_defined = 'N' And (p_inf_seq in (166,27) ) then
975: hr_utility.set_location( 'Option 1 Eligibile Sal is not defined...',970);
976: hr_utility.set_location('p_inf_seq : (166,27)'||p_inf_seq,1000);
977: l_insert_rec := 'N';
978: End if;
979:
980: /* If l_show_hide_data(l_OPT1_index).p_nnmntry_uom = 'Y' And( p_inf_seq in (25,160,166,27)) then

Line 981: hr_utility.set_location( 'Option 1 is Non Monetory Unit...',1010);

977: l_insert_rec := 'N';
978: End if;
979:
980: /* If l_show_hide_data(l_OPT1_index).p_nnmntry_uom = 'Y' And( p_inf_seq in (25,160,166,27)) then
981: hr_utility.set_location( 'Option 1 is Non Monetory Unit...',1010);
982: hr_utility.set_location('p_inf_seq : (25,160,166,27)'||p_inf_seq,1020);
983: l_insert_rec := 'N';
984: End if;
985: */

Line 982: hr_utility.set_location('p_inf_seq : (25,160,166,27)'||p_inf_seq,1020);

978: End if;
979:
980: /* If l_show_hide_data(l_OPT1_index).p_nnmntry_uom = 'Y' And( p_inf_seq in (25,160,166,27)) then
981: hr_utility.set_location( 'Option 1 is Non Monetory Unit...',1010);
982: hr_utility.set_location('p_inf_seq : (25,160,166,27)'||p_inf_seq,1020);
983: l_insert_rec := 'N';
984: End if;
985: */
986: ----------------------------------

Line 1275: hr_utility.set_location('Entering '||l_proc,10);

1271: l_display_width NUMBER := NULL;
1272:
1273: Begin
1274:
1275: hr_utility.set_location('Entering '||l_proc,10);
1276: hr_utility.set_location('p_group_pl_id :'||p_group_pl_id,20);
1277: hr_utility.set_location('p_lf_evt_ocrd_dt :'||p_lf_evt_ocrd_dt,30);
1278:
1279: If substr(p_base_layout_code,1,16) <> 'BEN_CWB_WS_LYT1_'

Line 1276: hr_utility.set_location('p_group_pl_id :'||p_group_pl_id,20);

1272:
1273: Begin
1274:
1275: hr_utility.set_location('Entering '||l_proc,10);
1276: hr_utility.set_location('p_group_pl_id :'||p_group_pl_id,20);
1277: hr_utility.set_location('p_lf_evt_ocrd_dt :'||p_lf_evt_ocrd_dt,30);
1278:
1279: If substr(p_base_layout_code,1,16) <> 'BEN_CWB_WS_LYT1_'
1280: AND p_base_layout_code <> 'BEN_CWB_WRK_SHT_BASE_LYT' then

Line 1277: hr_utility.set_location('p_lf_evt_ocrd_dt :'||p_lf_evt_ocrd_dt,30);

1273: Begin
1274:
1275: hr_utility.set_location('Entering '||l_proc,10);
1276: hr_utility.set_location('p_group_pl_id :'||p_group_pl_id,20);
1277: hr_utility.set_location('p_lf_evt_ocrd_dt :'||p_lf_evt_ocrd_dt,30);
1278:
1279: If substr(p_base_layout_code,1,16) <> 'BEN_CWB_WS_LYT1_'
1280: AND p_base_layout_code <> 'BEN_CWB_WRK_SHT_BASE_LYT' then
1281: l_insert_rec := 'Y';

Line 1287: hr_utility.set_location('p_inf_seq #: '||p_inf_seq||' l_insert_rec #:'||l_insert_rec,60);

1283: l_insert_rec := decide_insert_rec (p_inf_seq => p_inf_seq
1284: ,p_group_pl_id => p_group_pl_id
1285: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt);
1286: End If;
1287: hr_utility.set_location('p_inf_seq #: '||p_inf_seq||' l_insert_rec #:'||l_insert_rec,60);
1288:
1289: OPEN csr_layout_cols_row;
1290: FETCH csr_layout_cols_row INTO l_layout_cols_row;
1291: if csr_layout_cols_row%NOTFOUND then

Line 1293: hr_utility.set_location('Base Layout Does Not Have Item Checked:'||l_proc, 70);

1289: OPEN csr_layout_cols_row;
1290: FETCH csr_layout_cols_row INTO l_layout_cols_row;
1291: if csr_layout_cols_row%NOTFOUND then
1292: l_insert_rec := 'N';
1293: hr_utility.set_location('Base Layout Does Not Have Item Checked:'||l_proc, 70);
1294: end if;
1295: CLOSE csr_layout_cols_row;
1296:
1297: open csr_layout_cols_promotion;

Line 1332: hr_utility.set_location('p_inf_seq '||p_inf_seq,10);

1328: l_read_only_flag := l_layout_cols_row.read_only_flag;
1329: /* IF(l_read_only_flag = 'N') THEN
1330: for l_interface_cols_row in csr_interface_cols_row loop
1331: l_read_only_flag := l_interface_cols_row.read_only_flag;
1332: hr_utility.set_location('p_inf_seq '||p_inf_seq,10);
1333: hr_utility.set_location('l_read_only_flag '||l_read_only_flag,10);
1334: end loop;
1335: end if;*/
1336: END IF;

Line 1333: hr_utility.set_location('l_read_only_flag '||l_read_only_flag,10);

1329: /* IF(l_read_only_flag = 'N') THEN
1330: for l_interface_cols_row in csr_interface_cols_row loop
1331: l_read_only_flag := l_interface_cols_row.read_only_flag;
1332: hr_utility.set_location('p_inf_seq '||p_inf_seq,10);
1333: hr_utility.set_location('l_read_only_flag '||l_read_only_flag,10);
1334: end loop;
1335: end if;*/
1336: END IF;
1337: END IF;

Line 1338: hr_utility.set_location('p_inf_seq '||p_inf_seq||' l_read_only_flag '||l_read_only_flag,10);

1334: end loop;
1335: end if;*/
1336: END IF;
1337: END IF;
1338: hr_utility.set_location('p_inf_seq '||p_inf_seq||' l_read_only_flag '||l_read_only_flag,10);
1339: bne_layout_cols_pkg.insert_row
1340: (x_rowid => l_rowid
1341: ,x_application_id => l_layout_cols_row.application_id
1342: ,x_layout_code => p_act_layout_code

Line 1366: hr_utility.set_location('Leaving '||l_proc,100);

1362: ,x_read_only_flag => l_read_only_flag
1363: ,x_display_width => l_display_width);
1364: end if;
1365:
1366: hr_utility.set_location('Leaving '||l_proc,100);
1367: End insert_cwb_layout_cols_row;
1368:
1369: --
1370: --------------------------update_cwb_layout----------------------

Line 1501: hr_utility.set_location('parameter : '||param_val||' '||interface_seq_val,20);

1497:
1498: l_params := SUBSTR(l_params, param_loc + 1, param_len);
1499: l_interface_seq := SUBSTR(l_interface_seq, interface_seq_loc + 1, interface_seq_len);
1500: If g_debug then
1501: hr_utility.set_location('parameter : '||param_val||' '||interface_seq_val,20);
1502: END IF;
1503: LIST.EXTEND;
1504: list_rec.p_sequence := TO_NUMBER(param_val);
1505: list_rec.p_interface_seq := TO_NUMBER(interface_seq_val);

Line 1523: hr_utility.set_location('Seq Num :'||l_layout_col_rec.sequence_num,25);

1519: FETCH c_layout_cols INTO l_layout_col_rec;
1520: EXIT WHEN c_layout_cols%NOTFOUND;
1521:
1522: -- DBMS_OUTPUT.put_line('## Seq Num :'||l_layout_col_rec.sequence_num);
1523: hr_utility.set_location('Seq Num :'||l_layout_col_rec.sequence_num,25);
1524: bne_layout_cols_pkg.delete_row
1525: (x_application_id => l_layout_col_rec.application_id
1526: ,x_layout_code => l_layout_col_rec.layout_code
1527: ,x_block_id => l_layout_col_rec.block_id

Line 1536: hr_utility.set_location('ERROR occured',30);

1532: EXCEPTION
1533: WHEN OTHERS
1534: THEN
1535: Null;
1536: hr_utility.set_location('ERROR occured',30);
1537: -- DBMS_OUTPUT.put_line('ERROR WHILE DELETING');
1538: END;
1539: */
1540:

Line 1650: hr_utility.set_location('Sequence :'||LIST(k).p_sequence||'Inf Seq : '||l_layout_cols_row.interface_seq_num ,50);

1646: CLOSE c_layout_cols_row;
1647:
1648: -- DBMS_OUTPUT.put_line('Sequence :'||LIST(k).p_sequence ||'Inf Seq :'|| l_layout_cols_row.interface_seq_num);
1649:
1650: hr_utility.set_location('Sequence :'||LIST(k).p_sequence||'Inf Seq : '||l_layout_cols_row.interface_seq_num ,50);
1651: bne_layout_cols_pkg.insert_row
1652: (x_rowid => l_rowid
1653: ,x_application_id => l_layout_cols_row.application_id
1654: ,x_layout_code => p_layout_code

Line 1873: hr_utility.set_location('Entering '||l_proc,10);

1869: l_col_prompt bne_interface_cols_tl.prompt_left%Type;
1870:
1871: Begin
1872: if g_debug then
1873: hr_utility.set_location('Entering '||l_proc,10);
1874: hr_utility.set_location('p_key :'||p_key,30);
1875: hr_utility.set_location('p_integrator_code :'||p_integrator_code,40);
1876: hr_utility.set_location('p_interface_code :'||p_interface_code,50);
1877: end if;

Line 1874: hr_utility.set_location('p_key :'||p_key,30);

1870:
1871: Begin
1872: if g_debug then
1873: hr_utility.set_location('Entering '||l_proc,10);
1874: hr_utility.set_location('p_key :'||p_key,30);
1875: hr_utility.set_location('p_integrator_code :'||p_integrator_code,40);
1876: hr_utility.set_location('p_interface_code :'||p_interface_code,50);
1877: end if;
1878:

Line 1875: hr_utility.set_location('p_integrator_code :'||p_integrator_code,40);

1871: Begin
1872: if g_debug then
1873: hr_utility.set_location('Entering '||l_proc,10);
1874: hr_utility.set_location('p_key :'||p_key,30);
1875: hr_utility.set_location('p_integrator_code :'||p_integrator_code,40);
1876: hr_utility.set_location('p_interface_code :'||p_interface_code,50);
1877: end if;
1878:
1879: Open csr_col_prompt;

Line 1876: hr_utility.set_location('p_interface_code :'||p_interface_code,50);

1872: if g_debug then
1873: hr_utility.set_location('Entering '||l_proc,10);
1874: hr_utility.set_location('p_key :'||p_key,30);
1875: hr_utility.set_location('p_integrator_code :'||p_integrator_code,40);
1876: hr_utility.set_location('p_interface_code :'||p_interface_code,50);
1877: end if;
1878:
1879: Open csr_col_prompt;
1880: Fetch csr_col_prompt into l_col_prompt;

Line 1905: hr_utility.set_location('Entering '||l_proc,10);

1901: ,l_col_prompt -- interface_prompt_above
1902: ,p_display_seq -- Display Order
1903: );
1904:
1905: hr_utility.set_location('Entering '||l_proc,10);
1906: Exception
1907: When Others then
1908: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);
1909: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);

Line 1908: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);

1904:
1905: hr_utility.set_location('Entering '||l_proc,10);
1906: Exception
1907: When Others then
1908: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);
1909: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);
1910: raise;
1911:
1912: End create_custom_row;

Line 1909: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);

1905: hr_utility.set_location('Entering '||l_proc,10);
1906: Exception
1907: When Others then
1908: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);
1909: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);
1910: raise;
1911:
1912: End create_custom_row;
1913:

Line 1940: hr_utility.set_location('Entering '||l_proc,10);

1936: l_return_val Varchar2(1) := 'N';
1937: l_proc Varchar2(72) := g_package||'chk_entry_in_custom_table';
1938:
1939: BEGIN
1940: hr_utility.set_location('Entering '||l_proc,10);
1941:
1942: Open Csr_entry;
1943: Fetch Csr_entry into l_exists;
1944: Close Csr_entry;

Line 1953: hr_utility.set_location('Entry Exists (Y/N) : '||l_return_val,100);

1949: Else
1950: l_return_val := 'Y';
1951: End if;
1952:
1953: hr_utility.set_location('Entry Exists (Y/N) : '||l_return_val,100);
1954: hr_utility.set_location('Leaving '||l_proc,200);
1955:
1956: return l_return_val;
1957:

Line 1954: hr_utility.set_location('Leaving '||l_proc,200);

1950: l_return_val := 'Y';
1951: End if;
1952:
1953: hr_utility.set_location('Entry Exists (Y/N) : '||l_return_val,100);
1954: hr_utility.set_location('Leaving '||l_proc,200);
1955:
1956: return l_return_val;
1957:
1958: EXCEPTION

Line 1960: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);

1956: return l_return_val;
1957:
1958: EXCEPTION
1959: WHEN OTHERS THEN
1960: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);
1961: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);
1962: return 'N';
1963:
1964: END chk_entry_in_custom_table;

Line 1961: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);

1957:
1958: EXCEPTION
1959: WHEN OTHERS THEN
1960: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);
1961: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);
1962: return 'N';
1963:
1964: END chk_entry_in_custom_table;
1965:

Line 1984: hr_utility.set_location('Entering '||l_proc,10);

1980: l_proc Varchar2(72) := g_package||'chk_entry_in_custom_table';
1981:
1982:
1983: Begin
1984: hr_utility.set_location('Entering '||l_proc,10);
1985:
1986: -- If data not exists in the Custom Table insert data
1987:
1988:

Line 1996: hr_utility.set_location('Leaving '||l_proc,200);

1992: ,p_interface_code => p_interface_code
1993: ,p_interface_col_code => p_interface_col_code
1994: ,p_display_seq => p_display_seq);
1995:
1996: hr_utility.set_location('Leaving '||l_proc,200);
1997: EXCEPTION
1998: WHEN OTHERS THEN
1999: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);
2000: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);

Line 1999: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);

1995:
1996: hr_utility.set_location('Leaving '||l_proc,200);
1997: EXCEPTION
1998: WHEN OTHERS THEN
1999: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);
2000: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);
2001: raise;
2002: End manipulate_selected_data;
2003:

Line 2000: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);

1996: hr_utility.set_location('Leaving '||l_proc,200);
1997: EXCEPTION
1998: WHEN OTHERS THEN
1999: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);
2000: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);
2001: raise;
2002: End manipulate_selected_data;
2003:
2004: --

Line 2017: hr_utility.set_location('l_exist_in_table :'||l_exist_in_table,20);

2013: l_exist_in_table := chk_entry_in_custom_table( p_key => p_key
2014: ,p_region_key => p_region_key
2015: ,p_integrator_code => p_integrator_code);
2016:
2017: hr_utility.set_location('l_exist_in_table :'||l_exist_in_table,20);
2018:
2019:
2020: If l_exist_in_table = 'Y' Then
2021: hr_utility.set_location('Data Not exists in custom Table ',25);

Line 2021: hr_utility.set_location('Data Not exists in custom Table ',25);

2017: hr_utility.set_location('l_exist_in_table :'||l_exist_in_table,20);
2018:
2019:
2020: If l_exist_in_table = 'Y' Then
2021: hr_utility.set_location('Data Not exists in custom Table ',25);
2022: Delete From BEN_CUSTOM_REGION_ITEMS
2023: Where CUSTOM_KEY = p_key
2024: And REGION_CODE = p_region_key
2025: And CUSTOM_TYPE = p_integrator_code;

Line 2388: hr_utility.set_location('Entering '||l_proc,10);

2384: l_proc Varchar2(72) := g_package||'update_cwb_custom_layout';
2385:
2386: BEGIN
2387: If g_debug then
2388: hr_utility.set_location('Entering '||l_proc,10);
2389: End if;
2390: g_interface_code := p_interface_code;
2391: --
2392: delete_cwb_layout_cols(p_layout_code => p_act_layout_code

Line 2399: hr_utility.set_location('l_exist_in_table :'||l_exist_in_table,20);

2395: l_exist_in_table := chk_entry_in_custom_table( p_key => p_key
2396: ,p_region_key => p_region_key
2397: ,p_integrator_code => p_integrator_code);
2398: If g_debug then
2399: hr_utility.set_location('l_exist_in_table :'||l_exist_in_table,20);
2400: End if;
2401:
2402: -- If data not exists in the custom table
2403: If l_exist_in_table = 'N' Then

Line 2815: hr_utility.set_location('Leaving '||l_proc,10);

2811: p_download_switch := REPLACE(REPLACE(p_download_switch,'1','0'),'2','1');
2812: p_download_switch := nvl(lpad(int2hex(bin2int(substr(p_download_switch,1,28))),7,0)||
2813: int2hex(bin2int(rpad(substr(p_download_switch,29),28,0))),'0000000');
2814: If g_debug then
2815: hr_utility.set_location('Leaving '||l_proc,10);
2816: END IF;
2817: Exception
2818: When others then
2819: Null;

Line 2969: hr_utility.set_location('Entering '||l_proc,10);

2965: l_return_msg varchar2(500) := null;
2966:
2967: BEGIN
2968: If g_debug then
2969: hr_utility.set_location('Entering '||l_proc,10);
2970: End if;
2971: IF (P_PL_PERSON_RATE_ID IS NULL
2972: AND P_P_OPT1_PERSON_RATE_ID IS NULL
2973: AND P_P_OPT2_PERSON_RATE_ID IS NULL

Line 2978: hr_utility.set_location('No rates found '||l_proc,11);

2974: AND P_P_OPT3_PERSON_RATE_ID IS NULL
2975: AND P_P_OPT4_PERSON_RATE_ID IS NULL) THEN
2976:
2977: If g_debug then
2978: hr_utility.set_location('No rates found '||l_proc,11);
2979: End if;
2980: END IF;
2981: IF (P_PL_PERSON_RATE_ID IS NOT NULL) THEN
2982: l_PL_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_PL_PERSON_RATE_ID);

Line 2984: hr_utility.set_location('l_PL_PERSON_RATE_ID :'||l_PL_PERSON_RATE_ID,20);

2980: END IF;
2981: IF (P_PL_PERSON_RATE_ID IS NOT NULL) THEN
2982: l_PL_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_PL_PERSON_RATE_ID);
2983: If g_debug then
2984: hr_utility.set_location('l_PL_PERSON_RATE_ID :'||l_PL_PERSON_RATE_ID,20);
2985: End if;
2986: END IF;
2987:
2988: IF (P_P_OPT1_PERSON_RATE_ID IS NOT NULL) THEN

Line 2991: hr_utility.set_location('l_OPT1_PERSON_RATE_ID :'||l_OPT1_PERSON_RATE_ID,30);

2987:
2988: IF (P_P_OPT1_PERSON_RATE_ID IS NOT NULL) THEN
2989: l_OPT1_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_P_OPT1_PERSON_RATE_ID);
2990: If g_debug then
2991: hr_utility.set_location('l_OPT1_PERSON_RATE_ID :'||l_OPT1_PERSON_RATE_ID,30);
2992: End if;
2993: END IF;
2994:
2995: IF (P_P_OPT2_PERSON_RATE_ID IS NOT NULL) THEN

Line 2998: hr_utility.set_location('l_OPT2_PERSON_RATE_ID :'||l_OPT2_PERSON_RATE_ID,40);

2994:
2995: IF (P_P_OPT2_PERSON_RATE_ID IS NOT NULL) THEN
2996: l_OPT2_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_P_OPT2_PERSON_RATE_ID);
2997: If g_debug then
2998: hr_utility.set_location('l_OPT2_PERSON_RATE_ID :'||l_OPT2_PERSON_RATE_ID,40);
2999: End if;
3000: END IF;
3001:
3002: IF (P_P_OPT3_PERSON_RATE_ID IS NOT NULL) THEN

Line 3005: hr_utility.set_location('l_OPT3_PERSON_RATE_ID :'||l_OPT3_PERSON_RATE_ID,50);

3001:
3002: IF (P_P_OPT3_PERSON_RATE_ID IS NOT NULL) THEN
3003: l_OPT3_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_P_OPT3_PERSON_RATE_ID);
3004: If g_debug then
3005: hr_utility.set_location('l_OPT3_PERSON_RATE_ID :'||l_OPT3_PERSON_RATE_ID,50);
3006: End if;
3007: END IF;
3008:
3009: IF (P_P_OPT4_PERSON_RATE_ID IS NOT NULL) THEN

Line 3012: hr_utility.set_location('l_OPT4_PERSON_RATE_ID :'||l_OPT4_PERSON_RATE_ID,60);

3008:
3009: IF (P_P_OPT4_PERSON_RATE_ID IS NOT NULL) THEN
3010: l_OPT4_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_P_OPT4_PERSON_RATE_ID);
3011: If g_debug then
3012: hr_utility.set_location('l_OPT4_PERSON_RATE_ID :'||l_OPT4_PERSON_RATE_ID,60);
3013: End if;
3014: END IF;
3015:
3016: l_group_per_in_ler_id := get_group_per_in_ler_id(l_PL_PERSON_RATE_ID,

Line 3021: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,70);

3017: l_OPT1_PERSON_RATE_ID,
3018: l_OPT2_PERSON_RATE_ID,
3019: l_OPT3_PERSON_RATE_ID,
3020: l_OPT4_PERSON_RATE_ID);
3021: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,70);
3022:
3023: for l_plan_validation in c_plan_validation(l_group_per_in_ler_id) loop
3024: for l_grade_range in c_grade_range(l_group_per_in_ler_id) loop
3025: l_base_salary := l_grade_range.base_salary;

Line 3044: hr_utility.set_location('l_new_salary :'||l_new_salary,80);

3040: l_opt4_ws_val := l_option_salary.ws_val;
3041: end loop;
3042: l_new_salary := l_base_salary + l_opt1_ws_val + l_opt2_ws_val + l_opt3_ws_val + l_opt4_ws_val;
3043: If g_debug then
3044: hr_utility.set_location('l_new_salary :'||l_new_salary,80);
3045: hr_utility.set_location('l_grd_min :'||l_grd_min,80);
3046: hr_utility.set_location('l_grd_max :'||l_grd_max,80);
3047: End if;
3048: if((l_new_salary < l_grd_min) or (l_new_salary > l_grd_max) )then

Line 3045: hr_utility.set_location('l_grd_min :'||l_grd_min,80);

3041: end loop;
3042: l_new_salary := l_base_salary + l_opt1_ws_val + l_opt2_ws_val + l_opt3_ws_val + l_opt4_ws_val;
3043: If g_debug then
3044: hr_utility.set_location('l_new_salary :'||l_new_salary,80);
3045: hr_utility.set_location('l_grd_min :'||l_grd_min,80);
3046: hr_utility.set_location('l_grd_max :'||l_grd_max,80);
3047: End if;
3048: if((l_new_salary < l_grd_min) or (l_new_salary > l_grd_max) )then
3049: If g_debug then

Line 3046: hr_utility.set_location('l_grd_max :'||l_grd_max,80);

3042: l_new_salary := l_base_salary + l_opt1_ws_val + l_opt2_ws_val + l_opt3_ws_val + l_opt4_ws_val;
3043: If g_debug then
3044: hr_utility.set_location('l_new_salary :'||l_new_salary,80);
3045: hr_utility.set_location('l_grd_min :'||l_grd_min,80);
3046: hr_utility.set_location('l_grd_max :'||l_grd_max,80);
3047: End if;
3048: if((l_new_salary < l_grd_min) or (l_new_salary > l_grd_max) )then
3049: If g_debug then
3050: hr_utility.set_location('Leaving'||l_proc,90);

Line 3050: hr_utility.set_location('Leaving'||l_proc,90);

3046: hr_utility.set_location('l_grd_max :'||l_grd_max,80);
3047: End if;
3048: if((l_new_salary < l_grd_min) or (l_new_salary > l_grd_max) )then
3049: If g_debug then
3050: hr_utility.set_location('Leaving'||l_proc,90);
3051: End if;
3052: -- l_return_msg := fnd_message.get_string('BEN','');
3053: l_return_msg := l_plan_validation.grade_range_validation;
3054: return l_return_msg;

Line 3061: hr_utility.set_location('Leaving'||l_proc,100);

3057: for l_plan_salary in c_plan_salary(l_group_per_in_ler_id,P_PL_WS_VAL) loop
3058: l_new_salary := l_base_salary + l_plan_salary.ws_val;
3059: if((l_new_salary < l_grd_min) or (l_new_salary > l_grd_max) )then
3060: If g_debug then
3061: hr_utility.set_location('Leaving'||l_proc,100);
3062: End if;
3063: -- l_return_msg := fnd_message.get_string('BEN','');
3064: l_return_msg := l_plan_validation.grade_range_validation;
3065: return l_return_msg;

Line 3072: hr_utility.set_location('Leaving'||l_proc,110);

3068: end if;
3069: end loop;
3070: end loop;
3071: If g_debug then
3072: hr_utility.set_location('Leaving'||l_proc,110);
3073: End if;
3074: return null;
3075:
3076: END;

Line 3170: hr_utility.set_location('Entering '||l_proc,10);

3166: l_grd_max Number := null;
3167:
3168: BEGIN
3169: If g_debug then
3170: hr_utility.set_location('Entering '||l_proc,10);
3171: End if;
3172: IF (P_PL_PERSON_RATE_ID IS NULL
3173: AND P_P_OPT1_PERSON_RATE_ID IS NULL
3174: AND P_P_OPT2_PERSON_RATE_ID IS NULL

Line 3179: hr_utility.set_location('No rates found '||l_proc,11);

3175: AND P_P_OPT3_PERSON_RATE_ID IS NULL
3176: AND P_P_OPT4_PERSON_RATE_ID IS NULL) THEN
3177:
3178: If g_debug then
3179: hr_utility.set_location('No rates found '||l_proc,11);
3180: End if;
3181: END IF;
3182: IF (P_PL_PERSON_RATE_ID IS NOT NULL) THEN
3183: l_PL_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_PL_PERSON_RATE_ID);

Line 3185: hr_utility.set_location('l_PL_PERSON_RATE_ID :'||l_PL_PERSON_RATE_ID,20);

3181: END IF;
3182: IF (P_PL_PERSON_RATE_ID IS NOT NULL) THEN
3183: l_PL_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_PL_PERSON_RATE_ID);
3184: If g_debug then
3185: hr_utility.set_location('l_PL_PERSON_RATE_ID :'||l_PL_PERSON_RATE_ID,20);
3186: End if;
3187: END IF;
3188:
3189: IF (P_P_OPT1_PERSON_RATE_ID IS NOT NULL) THEN

Line 3192: hr_utility.set_location('l_OPT1_PERSON_RATE_ID :'||l_OPT1_PERSON_RATE_ID,30);

3188:
3189: IF (P_P_OPT1_PERSON_RATE_ID IS NOT NULL) THEN
3190: l_OPT1_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_P_OPT1_PERSON_RATE_ID);
3191: If g_debug then
3192: hr_utility.set_location('l_OPT1_PERSON_RATE_ID :'||l_OPT1_PERSON_RATE_ID,30);
3193: End if;
3194: END IF;
3195:
3196: IF (P_P_OPT2_PERSON_RATE_ID IS NOT NULL) THEN

Line 3199: hr_utility.set_location('l_OPT2_PERSON_RATE_ID :'||l_OPT2_PERSON_RATE_ID,40);

3195:
3196: IF (P_P_OPT2_PERSON_RATE_ID IS NOT NULL) THEN
3197: l_OPT2_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_P_OPT2_PERSON_RATE_ID);
3198: If g_debug then
3199: hr_utility.set_location('l_OPT2_PERSON_RATE_ID :'||l_OPT2_PERSON_RATE_ID,40);
3200: End if;
3201: END IF;
3202:
3203: IF (P_P_OPT3_PERSON_RATE_ID IS NOT NULL) THEN

Line 3206: hr_utility.set_location('l_OPT3_PERSON_RATE_ID :'||l_OPT3_PERSON_RATE_ID,50);

3202:
3203: IF (P_P_OPT3_PERSON_RATE_ID IS NOT NULL) THEN
3204: l_OPT3_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_P_OPT3_PERSON_RATE_ID);
3205: If g_debug then
3206: hr_utility.set_location('l_OPT3_PERSON_RATE_ID :'||l_OPT3_PERSON_RATE_ID,50);
3207: End if;
3208: END IF;
3209:
3210: IF (P_P_OPT4_PERSON_RATE_ID IS NOT NULL) THEN

Line 3213: hr_utility.set_location('l_OPT4_PERSON_RATE_ID :'||l_OPT4_PERSON_RATE_ID,60);

3209:
3210: IF (P_P_OPT4_PERSON_RATE_ID IS NOT NULL) THEN
3211: l_OPT4_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_P_OPT4_PERSON_RATE_ID);
3212: If g_debug then
3213: hr_utility.set_location('l_OPT4_PERSON_RATE_ID :'||l_OPT4_PERSON_RATE_ID,60);
3214: End if;
3215: END IF;
3216:
3217: l_group_per_in_ler_id := get_group_per_in_ler_id(l_PL_PERSON_RATE_ID,

Line 3222: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,70);

3218: l_OPT1_PERSON_RATE_ID,
3219: l_OPT2_PERSON_RATE_ID,
3220: l_OPT3_PERSON_RATE_ID,
3221: l_OPT4_PERSON_RATE_ID);
3222: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,70);
3223:
3224: for l_grade_range in c_grade_range(l_group_per_in_ler_id) loop
3225: l_base_salary := l_grade_range.base_salary;
3226: l_grd_min := l_grade_range.grd_min;

Line 3243: hr_utility.set_location('1..l_new_salary :'||l_new_salary,80);

3239: l_opt4_ws_val := l_option_salary.ws_val;
3240: end loop;
3241: l_new_salary := l_base_salary + l_opt1_ws_val + l_opt2_ws_val + l_opt3_ws_val + l_opt4_ws_val;
3242: If g_debug then
3243: hr_utility.set_location('1..l_new_salary :'||l_new_salary,80);
3244: End if;
3245:
3246: for l_plan_salary in c_plan_salary(l_group_per_in_ler_id,P_PL_WS_VAL) loop
3247: l_new_salary := l_base_salary + l_plan_salary.ws_val;

Line 3250: hr_utility.set_location('2..l_new_salary :'||l_new_salary,90);

3246: for l_plan_salary in c_plan_salary(l_group_per_in_ler_id,P_PL_WS_VAL) loop
3247: l_new_salary := l_base_salary + l_plan_salary.ws_val;
3248: end loop;
3249: If g_debug then
3250: hr_utility.set_location('2..l_new_salary :'||l_new_salary,90);
3251: End if;
3252: end loop;
3253:
3254: If g_debug then

Line 3255: hr_utility.set_location(' return l_new_salary :'||l_new_salary,90);

3251: End if;
3252: end loop;
3253:
3254: If g_debug then
3255: hr_utility.set_location(' return l_new_salary :'||l_new_salary,90);
3256: hr_utility.set_location('Leaving'||l_proc,110);
3257: End if;
3258: return l_new_salary;
3259: END;

Line 3256: hr_utility.set_location('Leaving'||l_proc,110);

3252: end loop;
3253:
3254: If g_debug then
3255: hr_utility.set_location(' return l_new_salary :'||l_new_salary,90);
3256: hr_utility.set_location('Leaving'||l_proc,110);
3257: End if;
3258: return l_new_salary;
3259: END;
3260:

Line 3327: hr_utility.set_location('Entering '||l_proc,10);

3323: l_base_salary Number := null;
3324:
3325: BEGIN
3326: If g_debug then
3327: hr_utility.set_location('Entering '||l_proc,10);
3328: End if;
3329:
3330: hr_utility.set_location('p_group_per_in_ler_id :'||p_group_per_in_ler_id,20);
3331:

Line 3330: hr_utility.set_location('p_group_per_in_ler_id :'||p_group_per_in_ler_id,20);

3326: If g_debug then
3327: hr_utility.set_location('Entering '||l_proc,10);
3328: End if;
3329:
3330: hr_utility.set_location('p_group_per_in_ler_id :'||p_group_per_in_ler_id,20);
3331:
3332: for l_grade_range in c_grade_range loop
3333: l_base_salary := l_grade_range.base_salary;
3334: l_new_salary := 0;

Line 3349: hr_utility.set_location('1..l_new_salary :'||l_new_salary,30);

3345: l_opt4_ws_val := l_option_salary.ws_val;
3346: end loop;
3347: l_new_salary := l_base_salary + l_opt1_ws_val + l_opt2_ws_val + l_opt3_ws_val + l_opt4_ws_val;
3348: If g_debug then
3349: hr_utility.set_location('1..l_new_salary :'||l_new_salary,30);
3350: End if;
3351:
3352: for l_plan_salary in c_plan_salary loop
3353: l_new_salary := l_base_salary + l_plan_salary.ws_val;

Line 3356: hr_utility.set_location('2..l_new_salary :'||l_new_salary,40);

3352: for l_plan_salary in c_plan_salary loop
3353: l_new_salary := l_base_salary + l_plan_salary.ws_val;
3354: end loop;
3355: If g_debug then
3356: hr_utility.set_location('2..l_new_salary :'||l_new_salary,40);
3357: End if;
3358: end loop;
3359:
3360: If g_debug then

Line 3361: hr_utility.set_location(' return l_new_salary :'||l_new_salary,50);

3357: End if;
3358: end loop;
3359:
3360: If g_debug then
3361: hr_utility.set_location(' return l_new_salary :'||l_new_salary,50);
3362: hr_utility.set_location('Leaving'||l_proc,60);
3363: End if;
3364: if(l_new_salary = 0) then
3365: l_new_salary := null;

Line 3362: hr_utility.set_location('Leaving'||l_proc,60);

3358: end loop;
3359:
3360: If g_debug then
3361: hr_utility.set_location(' return l_new_salary :'||l_new_salary,50);
3362: hr_utility.set_location('Leaving'||l_proc,60);
3363: End if;
3364: if(l_new_salary = 0) then
3365: l_new_salary := null;
3366: end if;

Line 3455: hr_utility.set_location('Entering :'||l_proc,10);

3451:
3452:
3453: BEGIN
3454:
3455: hr_utility.set_location('Entering :'||l_proc,10);
3456:
3457: If P_PERSON_RATE_ID IS NOT NULL then
3458: l_rate_id := P_PERSON_RATE_ID;
3459: Elsif P_OPT1_PERSON_RATE_ID IS NOT NULL then

Line 3469: hr_utility.set_location('l_rate_id :'||l_rate_id,20);

3465: Elsif P_OPT4_PERSON_RATE_ID IS NOT NULL then
3466: l_rate_id := P_OPT4_PERSON_RATE_ID;
3467: End if;
3468:
3469: hr_utility.set_location('l_rate_id :'||l_rate_id,20);
3470:
3471: Open csr_group_per_in_ler_id(l_rate_id);
3472: Fetch csr_group_per_in_ler_id into l_group_per_in_ler_id;
3473: Close csr_group_per_in_ler_id;

Line 3475: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,40);

3471: Open csr_group_per_in_ler_id(l_rate_id);
3472: Fetch csr_group_per_in_ler_id into l_group_per_in_ler_id;
3473: Close csr_group_per_in_ler_id;
3474:
3475: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,40);
3476: hr_utility.set_location('Leaving :'||l_proc,100);
3477:
3478: return l_group_per_in_ler_id;
3479:

Line 3476: hr_utility.set_location('Leaving :'||l_proc,100);

3472: Fetch csr_group_per_in_ler_id into l_group_per_in_ler_id;
3473: Close csr_group_per_in_ler_id;
3474:
3475: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,40);
3476: hr_utility.set_location('Leaving :'||l_proc,100);
3477:
3478: return l_group_per_in_ler_id;
3479:
3480: End get_group_per_in_ler_id;

Line 3499: hr_utility.set_location('int2bin:'||int, 300);

3495:
3496: FUNCTION int2bin(int PLS_INTEGER)
3497: RETURN VARCHAR2 IS
3498: BEGIN
3499: hr_utility.set_location('int2bin:'||int, 300);
3500: IF int > 0 THEN
3501: RETURN int2bin(TRUNC(int/2))||
3502: SUBSTR('01',MOD(int,2)+1,1);
3503: ELSE

Line 3512: hr_utility.set_location('hex2int:'||hex, 300);

3508: FUNCTION hex2int(hex VARCHAR2)
3509: RETURN PLS_INTEGER IS
3510: len PLS_INTEGER := LENGTH(hex);
3511: BEGIN
3512: hr_utility.set_location('hex2int:'||hex, 300);
3513: IF NVL(len,1) = 1 THEN
3514: RETURN INSTR('0123456789ABCDEF',hex) - 1;
3515: ELSE
3516: hr_utility.set_location('hex2int length:'||len, 300);

Line 3516: hr_utility.set_location('hex2int length:'||len, 300);

3512: hr_utility.set_location('hex2int:'||hex, 300);
3513: IF NVL(len,1) = 1 THEN
3514: RETURN INSTR('0123456789ABCDEF',hex) - 1;
3515: ELSE
3516: hr_utility.set_location('hex2int length:'||len, 300);
3517: RETURN 16 * hex2int(SUBSTR(hex,1,len-1)) +
3518: INSTR('0123456789ABCDEF',SUBSTR(hex,-1)) - 1;
3519: END IF;
3520: END hex2int;