APPS.BEN_CWB_WEBADI_UTILS dependencies on HR_UTILITY

Line 10: g_debug boolean := hr_utility.debug_enabled;

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

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

314: WHERE blc.application_id = p_application_id
315: AND blc.layout_code = p_layout_code;
316:
317: BEGIN
318: hr_utility.set_location('Entering '||l_proc,10);
319: For l_layout_col_rec In c_layout_cols
320: LOOP
321: hr_utility.set_location('Seq Num :'||l_layout_col_rec.sequence_num,25);
322: bne_layout_cols_pkg.delete_row

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

317: BEGIN
318: hr_utility.set_location('Entering '||l_proc,10);
319: For l_layout_col_rec In c_layout_cols
320: LOOP
321: hr_utility.set_location('Seq Num :'||l_layout_col_rec.sequence_num,25);
322: bne_layout_cols_pkg.delete_row
323: (x_application_id => l_layout_col_rec.application_id
324: ,x_layout_code => l_layout_col_rec.layout_code
325: ,x_block_id => l_layout_col_rec.block_id

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

324: ,x_layout_code => l_layout_col_rec.layout_code
325: ,x_block_id => l_layout_col_rec.block_id
326: ,x_sequence_num => l_layout_col_rec.sequence_num);
327: END LOOP;
328: hr_utility.set_location('Leaving '||l_proc,100);
329: EXCEPTION
330: WHEN OTHERS THEN
331: hr_utility.set_location('ERROR occured',30);
332: Null;

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

327: END LOOP;
328: hr_utility.set_location('Leaving '||l_proc,100);
329: EXCEPTION
330: WHEN OTHERS THEN
331: hr_utility.set_location('ERROR occured',30);
332: Null;
333: END delete_cwb_layout_cols;
334:
335: --

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

483: If (l_group_opt_exists_rec.IdCount <> 0 OR l_actual_opt_exists_rec.IdCount <> 0) Then
484:
485: -- If Group Options Exists
486: Begin
487: hr_utility.set_location('Options Exists',50);
488: Open opt1_exists;
489: Fetch opt1_exists into l_opt1_exists_rec;
490: Close opt1_exists;
491:

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

506: If (l_opt1_exists_rec.IdCount <> 0) then
507: l_show_hide_data(l_count).p_type := 'OPT1';
508: l_show_hide_data(l_count).p_opt_defined := 'Y';
509:
510: hr_utility.set_location('Opt1 Exists .. Count :'||l_count,100);
511: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_type,105);
512:
513:
514: If l_opt1_exists_rec.ws_abr_id is not Null Then

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

507: l_show_hide_data(l_count).p_type := 'OPT1';
508: l_show_hide_data(l_count).p_opt_defined := 'Y';
509:
510: hr_utility.set_location('Opt1 Exists .. Count :'||l_count,100);
511: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_type,105);
512:
513:
514: If l_opt1_exists_rec.ws_abr_id is not Null Then
515: l_show_hide_data(l_count).p_ws_defined := 'Y';

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

527: l_show_hide_data(l_count).p_nnmntry_uom := 'Y';
528: Else
529: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
530: End if;
531: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_type,105);
532: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_ws_defined,115);
533: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,120);
534: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_nnmntry_uom,125);
535:

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

528: Else
529: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
530: End if;
531: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_type,105);
532: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_ws_defined,115);
533: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,120);
534: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_nnmntry_uom,125);
535:
536: Else

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

529: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
530: End if;
531: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_type,105);
532: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_ws_defined,115);
533: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,120);
534: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_nnmntry_uom,125);
535:
536: Else
537: l_show_hide_data(l_count).p_type := 'OPT1';

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

530: End if;
531: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_type,105);
532: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_ws_defined,115);
533: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,120);
534: hr_utility.set_location('OPT1 ...'||l_show_hide_data(l_count).p_nnmntry_uom,125);
535:
536: Else
537: l_show_hide_data(l_count).p_type := 'OPT1';
538: l_show_hide_data(l_count).p_opt_defined := 'N';

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

535:
536: Else
537: l_show_hide_data(l_count).p_type := 'OPT1';
538: l_show_hide_data(l_count).p_opt_defined := 'N';
539: hr_utility.set_location('Opt1 Not Exists',120);
540: End If;
541:
542: ----------------------------- Option 2 ------------------------------------------
543: l_count := l_show_hide_data.count +1 ;

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

544: If (l_opt2_exists_rec.IdCount <> 0) then
545: l_show_hide_data(l_count).p_type := 'OPT2';
546: l_show_hide_data(l_count).p_opt_defined := 'Y';
547:
548: hr_utility.set_location('Opt2 Exists... Count :'||l_count,170);
549: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_type,175);
550:
551: If l_opt2_exists_rec.ws_abr_id is not Null Then
552: l_show_hide_data(l_count).p_ws_defined := 'Y';

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

545: l_show_hide_data(l_count).p_type := 'OPT2';
546: l_show_hide_data(l_count).p_opt_defined := 'Y';
547:
548: hr_utility.set_location('Opt2 Exists... Count :'||l_count,170);
549: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_type,175);
550:
551: If l_opt2_exists_rec.ws_abr_id is not Null Then
552: l_show_hide_data(l_count).p_ws_defined := 'Y';
553: Else

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

564: l_show_hide_data(l_count).p_nnmntry_uom := 'Y';
565: Else
566: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
567: End if;
568: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_type,250);
569: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_ws_defined,255);
570: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,260);
571: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_nnmntry_uom,265);
572:

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

565: Else
566: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
567: End if;
568: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_type,250);
569: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_ws_defined,255);
570: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,260);
571: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_nnmntry_uom,265);
572:
573: Else

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

566: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
567: End if;
568: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_type,250);
569: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_ws_defined,255);
570: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,260);
571: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_nnmntry_uom,265);
572:
573: Else
574: hr_utility.set_location('Opt2 Not Exists',240);

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

567: End if;
568: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_type,250);
569: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_ws_defined,255);
570: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,260);
571: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_nnmntry_uom,265);
572:
573: Else
574: hr_utility.set_location('Opt2 Not Exists',240);
575: l_show_hide_data(l_count).p_type := 'OPT2';

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

570: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,260);
571: hr_utility.set_location('OPT2 ...'||l_show_hide_data(l_count).p_nnmntry_uom,265);
572:
573: Else
574: hr_utility.set_location('Opt2 Not Exists',240);
575: l_show_hide_data(l_count).p_type := 'OPT2';
576: l_show_hide_data(l_count).p_opt_defined := 'N';
577: End If;
578:

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

583:
584: l_show_hide_data(l_count).p_type := 'OPT3';
585: l_show_hide_data(l_count).p_opt_defined := 'Y';
586:
587: hr_utility.set_location('Opt3 Exists...Count :'||l_count,300);
588: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_type,305);
589: If l_opt3_exists_rec.ws_abr_id is not Null Then
590: l_show_hide_data(l_count).p_ws_defined := 'Y';
591: Else

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

584: l_show_hide_data(l_count).p_type := 'OPT3';
585: l_show_hide_data(l_count).p_opt_defined := 'Y';
586:
587: hr_utility.set_location('Opt3 Exists...Count :'||l_count,300);
588: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_type,305);
589: If l_opt3_exists_rec.ws_abr_id is not Null Then
590: l_show_hide_data(l_count).p_ws_defined := 'Y';
591: Else
592: l_show_hide_data(l_count).p_ws_defined := 'N';

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

602: l_show_hide_data(l_count).p_nnmntry_uom := 'Y';
603: Else
604: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
605: End if;
606: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_type,355);
607: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_ws_defined,360);
608: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,365);
609: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_nnmntry_uom,370);
610:

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

603: Else
604: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
605: End if;
606: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_type,355);
607: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_ws_defined,360);
608: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,365);
609: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_nnmntry_uom,370);
610:
611: Else

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

604: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
605: End if;
606: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_type,355);
607: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_ws_defined,360);
608: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,365);
609: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_nnmntry_uom,370);
610:
611: Else
612: l_show_hide_data(l_count).p_type := 'OPT3';

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

605: End if;
606: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_type,355);
607: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_ws_defined,360);
608: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,365);
609: hr_utility.set_location('OPT3 ...'||l_show_hide_data(l_count).p_nnmntry_uom,370);
610:
611: Else
612: l_show_hide_data(l_count).p_type := 'OPT3';
613: l_show_hide_data(l_count).p_opt_defined := 'N';

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

610:
611: Else
612: l_show_hide_data(l_count).p_type := 'OPT3';
613: l_show_hide_data(l_count).p_opt_defined := 'N';
614: hr_utility.set_location('Opt3 Not Exists',350);
615: End If;
616:
617: ----------------------------- Option 4 ------------------------------------------
618: l_count := l_show_hide_data.count +1 ;

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

620:
621: l_show_hide_data(l_count).p_type := 'OPT4';
622: l_show_hide_data(l_count).p_opt_defined := 'Y';
623:
624: hr_utility.set_location('Opt4 Exists...Count :'||l_count,400);
625: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_type,405);
626: If l_opt4_exists_rec.ws_abr_id is not Null Then
627: l_show_hide_data(l_count).p_ws_defined := 'Y';
628: Else

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

621: l_show_hide_data(l_count).p_type := 'OPT4';
622: l_show_hide_data(l_count).p_opt_defined := 'Y';
623:
624: hr_utility.set_location('Opt4 Exists...Count :'||l_count,400);
625: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_type,405);
626: If l_opt4_exists_rec.ws_abr_id is not Null Then
627: l_show_hide_data(l_count).p_ws_defined := 'Y';
628: Else
629: l_show_hide_data(l_count).p_ws_defined := 'N';

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

639: l_show_hide_data(l_count).p_nnmntry_uom := 'Y';
640: Else
641: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
642: End if;
643: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_type,555);
644: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_ws_defined,560);
645: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,565);
646: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_nnmntry_uom,570);
647:

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

640: Else
641: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
642: End if;
643: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_type,555);
644: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_ws_defined,560);
645: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,565);
646: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_nnmntry_uom,570);
647:
648: Else

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

641: l_show_hide_data(l_count).p_nnmntry_uom := 'N';
642: End if;
643: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_type,555);
644: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_ws_defined,560);
645: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,565);
646: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_nnmntry_uom,570);
647:
648: Else
649: l_show_hide_data(l_count).p_type := 'OPT4';

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

642: End if;
643: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_type,555);
644: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_ws_defined,560);
645: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_eligy_sal_defined,565);
646: hr_utility.set_location('OPT4 ...'||l_show_hide_data(l_count).p_nnmntry_uom,570);
647:
648: Else
649: l_show_hide_data(l_count).p_type := 'OPT4';
650: l_show_hide_data(l_count).p_opt_defined := 'N';

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

647:
648: Else
649: l_show_hide_data(l_count).p_type := 'OPT4';
650: l_show_hide_data(l_count).p_opt_defined := 'N';
651: hr_utility.set_location('Opt4 Not Exists',500);
652: End If;
653: End;
654:
655: Else

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

659: -- If Group Options not exists
660: l_count := l_show_hide_data.count +1 ;
661: l_show_hide_data(l_count).p_type := 'PLOY';
662: l_show_hide_data(l_count).p_opt_defined := 'N';
663: hr_utility.set_location('Options Not Exists ...Count :'||l_count,560);
664: If (l_actual_plans_rec.ws_abr_id is not Null OR
665: l_group_plan_rec.ws_abr_id is not Null )Then
666: l_show_hide_data(l_count).p_ws_defined := 'Y';
667: Else

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

691:
692:
693: End;
694: End If;
695: hr_utility.set_location('Final count'||l_count, 500);
696:
697: For i in l_show_hide_data.first..l_show_hide_data.last
698: Loop
699: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 500);

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

695: hr_utility.set_location('Final count'||l_count, 500);
696:
697: For i in l_show_hide_data.first..l_show_hide_data.last
698: Loop
699: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 500);
700: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 510);
701: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 520);
702: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 530);
703: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 540);

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

696:
697: For i in l_show_hide_data.first..l_show_hide_data.last
698: Loop
699: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 500);
700: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 510);
701: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 520);
702: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 530);
703: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 540);
704: hr_utility.set_location('ws_sub_acty_typ_cd('||i||') :'||l_show_hide_data(i).p_ws_sub_acty_typ_cd, 541);

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

697: For i in l_show_hide_data.first..l_show_hide_data.last
698: Loop
699: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 500);
700: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 510);
701: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 520);
702: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 530);
703: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 540);
704: hr_utility.set_location('ws_sub_acty_typ_cd('||i||') :'||l_show_hide_data(i).p_ws_sub_acty_typ_cd, 541);
705:

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

698: Loop
699: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 500);
700: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 510);
701: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 520);
702: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 530);
703: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 540);
704: hr_utility.set_location('ws_sub_acty_typ_cd('||i||') :'||l_show_hide_data(i).p_ws_sub_acty_typ_cd, 541);
705:
706: End Loop;

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

699: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 500);
700: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 510);
701: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 520);
702: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 530);
703: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 540);
704: hr_utility.set_location('ws_sub_acty_typ_cd('||i||') :'||l_show_hide_data(i).p_ws_sub_acty_typ_cd, 541);
705:
706: End Loop;
707: p_show_hide_data := l_show_hide_data;

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

700: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 510);
701: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 520);
702: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 530);
703: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 540);
704: hr_utility.set_location('ws_sub_acty_typ_cd('||i||') :'||l_show_hide_data(i).p_ws_sub_acty_typ_cd, 541);
705:
706: End Loop;
707: p_show_hide_data := l_show_hide_data;
708: Exception

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

706: End Loop;
707: p_show_hide_data := l_show_hide_data;
708: Exception
709: when others then
710: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
711: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
712: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
713:
714: end check_hidden_worksheet_columns;

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

707: p_show_hide_data := l_show_hide_data;
708: Exception
709: when others then
710: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
711: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
712: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
713:
714: end check_hidden_worksheet_columns;
715: --

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

708: Exception
709: when others then
710: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
711: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
712: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
713:
714: end check_hidden_worksheet_columns;
715: --
716: ------------------------ decide_insert_rec-----------------------

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

773:
774:
775: Begin
776:
777: hr_utility.set_location('Entering :'||l_proc,10);
778: hr_utility.set_location('** p_inf_seq :'||p_inf_seq,20);
779:
780: check_hidden_worksheet_columns( p_group_pl_id => p_group_pl_id
781: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt

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

774:
775: Begin
776:
777: hr_utility.set_location('Entering :'||l_proc,10);
778: hr_utility.set_location('** p_inf_seq :'||p_inf_seq,20);
779:
780: check_hidden_worksheet_columns( p_group_pl_id => p_group_pl_id
781: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
782: ,p_show_hide_data => l_show_hide_data);

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

782: ,p_show_hide_data => l_show_hide_data);
783:
784:
785:
786: hr_utility.set_location('l_show_hide_data.count :'||l_show_hide_data.count,785);
787: hr_utility.set_location('l_show_hide_data.first :'||l_show_hide_data.first,786);
788: hr_utility.set_location('l_show_hide_data.last :'||l_show_hide_data.last,787);
789: For i in l_show_hide_data.first..l_show_hide_data.last
790: Loop

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

783:
784:
785:
786: hr_utility.set_location('l_show_hide_data.count :'||l_show_hide_data.count,785);
787: hr_utility.set_location('l_show_hide_data.first :'||l_show_hide_data.first,786);
788: hr_utility.set_location('l_show_hide_data.last :'||l_show_hide_data.last,787);
789: For i in l_show_hide_data.first..l_show_hide_data.last
790: Loop
791: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 4900);

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

784:
785:
786: hr_utility.set_location('l_show_hide_data.count :'||l_show_hide_data.count,785);
787: hr_utility.set_location('l_show_hide_data.first :'||l_show_hide_data.first,786);
788: hr_utility.set_location('l_show_hide_data.last :'||l_show_hide_data.last,787);
789: For i in l_show_hide_data.first..l_show_hide_data.last
790: Loop
791: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 4900);
792: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 500);

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

787: hr_utility.set_location('l_show_hide_data.first :'||l_show_hide_data.first,786);
788: hr_utility.set_location('l_show_hide_data.last :'||l_show_hide_data.last,787);
789: For i in l_show_hide_data.first..l_show_hide_data.last
790: Loop
791: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 4900);
792: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 500);
793: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 510);
794: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 520);
795: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 530);

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

788: hr_utility.set_location('l_show_hide_data.last :'||l_show_hide_data.last,787);
789: For i in l_show_hide_data.first..l_show_hide_data.last
790: Loop
791: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 4900);
792: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 500);
793: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 510);
794: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 520);
795: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 530);
796:

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

789: For i in l_show_hide_data.first..l_show_hide_data.last
790: Loop
791: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 4900);
792: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 500);
793: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 510);
794: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 520);
795: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 530);
796:
797: if (l_show_hide_data(i).p_type = 'PLOY') then

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

790: Loop
791: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 4900);
792: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 500);
793: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 510);
794: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 520);
795: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 530);
796:
797: if (l_show_hide_data(i).p_type = 'PLOY') then
798: l_PLOY_index := i;

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

791: hr_utility.set_location('p_type('||i||') :'||l_show_hide_data(i).p_type, 4900);
792: hr_utility.set_location('p_opt_defined('||i||') :'||l_show_hide_data(i).p_opt_defined, 500);
793: hr_utility.set_location('p_ws_defined('||i||') :'||l_show_hide_data(i).p_ws_defined, 510);
794: hr_utility.set_location('p_eligy_sal_defined('||i||') :'||l_show_hide_data(i).p_eligy_sal_defined, 520);
795: hr_utility.set_location('p_nnmntry_uom('||i||') :'||l_show_hide_data(i).p_nnmntry_uom, 530);
796:
797: if (l_show_hide_data(i).p_type = 'PLOY') then
798: l_PLOY_index := i;
799: end if;

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

813: if (l_show_hide_data(i).p_type = 'OPT4') then
814: l_OPT4_index := i;
815: end if;
816: End Loop;
817: hr_utility.set_location('l_PLOY_index :'||l_PLOY_index,540);
818: hr_utility.set_location('l_OPT1_index :'||l_OPT1_index,541);
819: hr_utility.set_location('l_OPT2_index :'||l_OPT2_index,542);
820: hr_utility.set_location('l_OPT3_index :'||l_OPT3_index,543);
821: hr_utility.set_location('l_OPT4_index :'||l_OPT4_index,544);

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

814: l_OPT4_index := i;
815: end if;
816: End Loop;
817: hr_utility.set_location('l_PLOY_index :'||l_PLOY_index,540);
818: hr_utility.set_location('l_OPT1_index :'||l_OPT1_index,541);
819: hr_utility.set_location('l_OPT2_index :'||l_OPT2_index,542);
820: hr_utility.set_location('l_OPT3_index :'||l_OPT3_index,543);
821: hr_utility.set_location('l_OPT4_index :'||l_OPT4_index,544);
822:

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

815: end if;
816: End Loop;
817: hr_utility.set_location('l_PLOY_index :'||l_PLOY_index,540);
818: hr_utility.set_location('l_OPT1_index :'||l_OPT1_index,541);
819: hr_utility.set_location('l_OPT2_index :'||l_OPT2_index,542);
820: hr_utility.set_location('l_OPT3_index :'||l_OPT3_index,543);
821: hr_utility.set_location('l_OPT4_index :'||l_OPT4_index,544);
822:
823:

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

816: End Loop;
817: hr_utility.set_location('l_PLOY_index :'||l_PLOY_index,540);
818: hr_utility.set_location('l_OPT1_index :'||l_OPT1_index,541);
819: hr_utility.set_location('l_OPT2_index :'||l_OPT2_index,542);
820: hr_utility.set_location('l_OPT3_index :'||l_OPT3_index,543);
821: hr_utility.set_location('l_OPT4_index :'||l_OPT4_index,544);
822:
823:
824: --------------------------------Start of Plan Only--------------------------------

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

817: hr_utility.set_location('l_PLOY_index :'||l_PLOY_index,540);
818: hr_utility.set_location('l_OPT1_index :'||l_OPT1_index,541);
819: hr_utility.set_location('l_OPT2_index :'||l_OPT2_index,542);
820: hr_utility.set_location('l_OPT3_index :'||l_OPT3_index,543);
821: hr_utility.set_location('l_OPT4_index :'||l_OPT4_index,544);
822:
823:
824: --------------------------------Start of Plan Only--------------------------------
825: IF (l_PLOY_index <> 0 and l_show_hide_data(l_PLOY_index).p_type = 'PLOY' ) THEN

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

823:
824: --------------------------------Start of Plan Only--------------------------------
825: IF (l_PLOY_index <> 0 and l_show_hide_data(l_PLOY_index).p_type = 'PLOY' ) THEN
826: Begin
827: hr_utility.set_location('Start of Plan Only',545);
828: -- If No Options Exists then disable all Option Columns
829: Open csr_is_options;
830: Fetch csr_is_options into l_option;
831: Close csr_is_options;

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

834: End if;
835:
836: -- Plan Level Checks
837: 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
838: hr_utility.set_location('Plan WS Aount Not defined....',800);
839: hr_utility.set_location('p_inf_seq : (12,7,159,165,9,5,164)'||p_inf_seq,820);
840: l_insert_rec := 'N';
841: End if;
842:

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

835:
836: -- Plan Level Checks
837: 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
838: hr_utility.set_location('Plan WS Aount Not defined....',800);
839: hr_utility.set_location('p_inf_seq : (12,7,159,165,9,5,164)'||p_inf_seq,820);
840: l_insert_rec := 'N';
841: End if;
842:
843: If l_show_hide_data(l_PLOY_index).p_eligy_sal_defined = 'N' And (p_inf_seq in (165,9,5,164) ) then

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

840: l_insert_rec := 'N';
841: End if;
842:
843: If l_show_hide_data(l_PLOY_index).p_eligy_sal_defined = 'N' And (p_inf_seq in (165,9,5,164) ) then
844: hr_utility.set_location( 'Plan Eligible Sal Not Defined...',820);
845: hr_utility.set_location('p_inf_seq : (165,9,5,164)'||p_inf_seq,850);
846: l_insert_rec := 'N';
847: End if;
848:

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

841: End if;
842:
843: If l_show_hide_data(l_PLOY_index).p_eligy_sal_defined = 'N' And (p_inf_seq in (165,9,5,164) ) then
844: hr_utility.set_location( 'Plan Eligible Sal Not Defined...',820);
845: hr_utility.set_location('p_inf_seq : (165,9,5,164)'||p_inf_seq,850);
846: l_insert_rec := 'N';
847: End if;
848:
849: /* 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 850: hr_utility.set_location( 'Plan is Non monetory Unit...',860);

846: l_insert_rec := 'N';
847: End if;
848:
849: /* If l_show_hide_data(l_PLOY_index).p_nnmntry_uom = 'Y' And( p_inf_seq in (7,159,165,9,5,164)) then
850: hr_utility.set_location( 'Plan is Non monetory Unit...',860);
851: hr_utility.set_location('p_inf_seq : (7,159,165,9,5,164)'||p_inf_seq,850);
852: l_insert_rec := 'N';
853: End if;
854: */

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

847: End if;
848:
849: /* If l_show_hide_data(l_PLOY_index).p_nnmntry_uom = 'Y' And( p_inf_seq in (7,159,165,9,5,164)) then
850: hr_utility.set_location( 'Plan is Non monetory Unit...',860);
851: hr_utility.set_location('p_inf_seq : (7,159,165,9,5,164)'||p_inf_seq,850);
852: l_insert_rec := 'N';
853: End if;
854: */
855: ----------------------------------

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

887:
888: ----------------------------------
889:
890: If (l_show_hide_data(l_PLOY_index).p_ws_sub_acty_typ_cd = 'N' And p_inf_seq = 164) then
891: hr_utility.set_location( 'Plan is Salary ...',870);
892: hr_utility.set_location('(p_inf_seq = 164) :'||p_inf_seq,890);
893: l_insert_rec := 'N';
894: End if;
895:

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

888: ----------------------------------
889:
890: If (l_show_hide_data(l_PLOY_index).p_ws_sub_acty_typ_cd = 'N' And p_inf_seq = 164) then
891: hr_utility.set_location( 'Plan is Salary ...',870);
892: hr_utility.set_location('(p_inf_seq = 164) :'||p_inf_seq,890);
893: l_insert_rec := 'N';
894: End if;
895:
896: End;

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

903: -- Option1
904: IF (l_OPT1_index <> 0 And l_show_hide_data(l_OPT1_index).p_type = 'OPT1' ) THEN
905: Begin
906: If l_show_hide_data(l_OPT1_index).p_opt_defined = 'N' then
907: hr_utility.set_location( 'Option 1 is not defined...',900);
908: -- Disable all Option1 Columns
909: Open csr_opt1;
910: Fetch csr_opt1 into l_option;
911: Close csr_opt1;

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

912: If l_option is not null then
913: l_insert_rec := 'N';
914: End if;
915: Else
916: hr_utility.set_location( 'Option 1 is defined...',910);
917: -- Option1 Level Checks
918: If l_show_hide_data(l_OPT1_index).p_ws_defined = 'N' And (p_inf_seq in (30,25,160,166,27) ) then
919: hr_utility.set_location( 'Option 1 worksheet Amount is not defined...',920);
920: hr_utility.set_location('p_inf_seq : (30,25,160,166,27)'||p_inf_seq,950);

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

915: Else
916: hr_utility.set_location( 'Option 1 is defined...',910);
917: -- Option1 Level Checks
918: If l_show_hide_data(l_OPT1_index).p_ws_defined = 'N' And (p_inf_seq in (30,25,160,166,27) ) then
919: hr_utility.set_location( 'Option 1 worksheet Amount is not defined...',920);
920: hr_utility.set_location('p_inf_seq : (30,25,160,166,27)'||p_inf_seq,950);
921: l_insert_rec := 'N';
922: End if;
923:

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

916: hr_utility.set_location( 'Option 1 is defined...',910);
917: -- Option1 Level Checks
918: If l_show_hide_data(l_OPT1_index).p_ws_defined = 'N' And (p_inf_seq in (30,25,160,166,27) ) then
919: hr_utility.set_location( 'Option 1 worksheet Amount is not defined...',920);
920: hr_utility.set_location('p_inf_seq : (30,25,160,166,27)'||p_inf_seq,950);
921: l_insert_rec := 'N';
922: End if;
923:
924: If l_show_hide_data(l_OPT1_index).p_eligy_sal_defined = 'N' And (p_inf_seq in (166,27) ) then

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

921: l_insert_rec := 'N';
922: End if;
923:
924: If l_show_hide_data(l_OPT1_index).p_eligy_sal_defined = 'N' And (p_inf_seq in (166,27) ) then
925: hr_utility.set_location( 'Option 1 Eligibile Sal is not defined...',970);
926: hr_utility.set_location('p_inf_seq : (166,27)'||p_inf_seq,1000);
927: l_insert_rec := 'N';
928: End if;
929:

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

922: End if;
923:
924: If l_show_hide_data(l_OPT1_index).p_eligy_sal_defined = 'N' And (p_inf_seq in (166,27) ) then
925: hr_utility.set_location( 'Option 1 Eligibile Sal is not defined...',970);
926: hr_utility.set_location('p_inf_seq : (166,27)'||p_inf_seq,1000);
927: l_insert_rec := 'N';
928: End if;
929:
930: /* If l_show_hide_data(l_OPT1_index).p_nnmntry_uom = 'Y' And( p_inf_seq in (25,160,166,27)) then

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

927: l_insert_rec := 'N';
928: End if;
929:
930: /* If l_show_hide_data(l_OPT1_index).p_nnmntry_uom = 'Y' And( p_inf_seq in (25,160,166,27)) then
931: hr_utility.set_location( 'Option 1 is Non Monetory Unit...',1010);
932: hr_utility.set_location('p_inf_seq : (25,160,166,27)'||p_inf_seq,1020);
933: l_insert_rec := 'N';
934: End if;
935: */

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

928: End if;
929:
930: /* If l_show_hide_data(l_OPT1_index).p_nnmntry_uom = 'Y' And( p_inf_seq in (25,160,166,27)) then
931: hr_utility.set_location( 'Option 1 is Non Monetory Unit...',1010);
932: hr_utility.set_location('p_inf_seq : (25,160,166,27)'||p_inf_seq,1020);
933: l_insert_rec := 'N';
934: End if;
935: */
936: ----------------------------------

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

1201: l_display_width NUMBER := NULL;
1202:
1203: Begin
1204:
1205: hr_utility.set_location('Entering '||l_proc,10);
1206: hr_utility.set_location('p_group_pl_id :'||p_group_pl_id,20);
1207: hr_utility.set_location('p_lf_evt_ocrd_dt :'||p_lf_evt_ocrd_dt,30);
1208:
1209: If p_base_layout_code <> 'BEN_CWB_WRK_SHT_BASE_LYT' then

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

1202:
1203: Begin
1204:
1205: hr_utility.set_location('Entering '||l_proc,10);
1206: hr_utility.set_location('p_group_pl_id :'||p_group_pl_id,20);
1207: hr_utility.set_location('p_lf_evt_ocrd_dt :'||p_lf_evt_ocrd_dt,30);
1208:
1209: If p_base_layout_code <> 'BEN_CWB_WRK_SHT_BASE_LYT' then
1210: l_insert_rec := 'Y';

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

1203: Begin
1204:
1205: hr_utility.set_location('Entering '||l_proc,10);
1206: hr_utility.set_location('p_group_pl_id :'||p_group_pl_id,20);
1207: hr_utility.set_location('p_lf_evt_ocrd_dt :'||p_lf_evt_ocrd_dt,30);
1208:
1209: If p_base_layout_code <> 'BEN_CWB_WRK_SHT_BASE_LYT' then
1210: l_insert_rec := 'Y';
1211: Else

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

1212: l_insert_rec := decide_insert_rec (p_inf_seq => p_inf_seq
1213: ,p_group_pl_id => p_group_pl_id
1214: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt);
1215: End If;
1216: hr_utility.set_location('p_inf_seq #: '||p_inf_seq||' l_insert_rec #:'||l_insert_rec,60);
1217:
1218: OPEN csr_layout_cols_row;
1219: FETCH csr_layout_cols_row INTO l_layout_cols_row;
1220: if csr_layout_cols_row%NOTFOUND then

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

1218: OPEN csr_layout_cols_row;
1219: FETCH csr_layout_cols_row INTO l_layout_cols_row;
1220: if csr_layout_cols_row%NOTFOUND then
1221: l_insert_rec := 'N';
1222: hr_utility.set_location('Base Layout Does Not Have Item Checked:'||l_proc, 70);
1223: end if;
1224: CLOSE csr_layout_cols_row;
1225:
1226: If l_insert_rec = 'Y' then

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

1272: ,x_read_only_flag => l_read_only_flag
1273: ,x_display_width => l_display_width);
1274: end if;
1275:
1276: hr_utility.set_location('Leaving '||l_proc,100);
1277: End insert_cwb_layout_cols_row;
1278:
1279: --
1280: --------------------------update_cwb_layout----------------------

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

1400:
1401: l_params := SUBSTR(l_params, param_loc + 1, param_len);
1402: l_interface_seq := SUBSTR(l_interface_seq, interface_seq_loc + 1, interface_seq_len);
1403: If g_debug then
1404: hr_utility.set_location('parameter : '||param_val||' '||interface_seq_val,20);
1405: END IF;
1406: LIST.EXTEND;
1407: list_rec.p_sequence := TO_NUMBER(param_val);
1408: list_rec.p_interface_seq := TO_NUMBER(interface_seq_val);

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

1422: FETCH c_layout_cols INTO l_layout_col_rec;
1423: EXIT WHEN c_layout_cols%NOTFOUND;
1424:
1425: -- DBMS_OUTPUT.put_line('## Seq Num :'||l_layout_col_rec.sequence_num);
1426: hr_utility.set_location('Seq Num :'||l_layout_col_rec.sequence_num,25);
1427: bne_layout_cols_pkg.delete_row
1428: (x_application_id => l_layout_col_rec.application_id
1429: ,x_layout_code => l_layout_col_rec.layout_code
1430: ,x_block_id => l_layout_col_rec.block_id

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

1435: EXCEPTION
1436: WHEN OTHERS
1437: THEN
1438: Null;
1439: hr_utility.set_location('ERROR occured',30);
1440: -- DBMS_OUTPUT.put_line('ERROR WHILE DELETING');
1441: END;
1442: */
1443:

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

1537: CLOSE c_layout_cols_row;
1538:
1539: -- DBMS_OUTPUT.put_line('Sequence :'||LIST(k).p_sequence ||'Inf Seq :'|| l_layout_cols_row.interface_seq_num);
1540:
1541: hr_utility.set_location('Sequence :'||LIST(k).p_sequence||'Inf Seq : '||l_layout_cols_row.interface_seq_num ,50);
1542: bne_layout_cols_pkg.insert_row
1543: (x_rowid => l_rowid
1544: ,x_application_id => l_layout_cols_row.application_id
1545: ,x_layout_code => p_layout_code

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

1752: l_col_prompt bne_interface_cols_tl.prompt_left%Type;
1753:
1754: Begin
1755: if g_debug then
1756: hr_utility.set_location('Entering '||l_proc,10);
1757: hr_utility.set_location('p_key :'||p_key,30);
1758: hr_utility.set_location('p_integrator_code :'||p_integrator_code,40);
1759: hr_utility.set_location('p_interface_code :'||p_interface_code,50);
1760: end if;

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

1753:
1754: Begin
1755: if g_debug then
1756: hr_utility.set_location('Entering '||l_proc,10);
1757: hr_utility.set_location('p_key :'||p_key,30);
1758: hr_utility.set_location('p_integrator_code :'||p_integrator_code,40);
1759: hr_utility.set_location('p_interface_code :'||p_interface_code,50);
1760: end if;
1761:

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

1754: Begin
1755: if g_debug then
1756: hr_utility.set_location('Entering '||l_proc,10);
1757: hr_utility.set_location('p_key :'||p_key,30);
1758: hr_utility.set_location('p_integrator_code :'||p_integrator_code,40);
1759: hr_utility.set_location('p_interface_code :'||p_interface_code,50);
1760: end if;
1761:
1762: Open csr_col_prompt;

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

1755: if g_debug then
1756: hr_utility.set_location('Entering '||l_proc,10);
1757: hr_utility.set_location('p_key :'||p_key,30);
1758: hr_utility.set_location('p_integrator_code :'||p_integrator_code,40);
1759: hr_utility.set_location('p_interface_code :'||p_interface_code,50);
1760: end if;
1761:
1762: Open csr_col_prompt;
1763: Fetch csr_col_prompt into l_col_prompt;

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

1784: ,l_col_prompt -- interface_prompt_above
1785: ,p_display_seq -- Display Order
1786: );
1787:
1788: hr_utility.set_location('Entering '||l_proc,10);
1789: Exception
1790: When Others then
1791: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);
1792: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);

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

1787:
1788: hr_utility.set_location('Entering '||l_proc,10);
1789: Exception
1790: When Others then
1791: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);
1792: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);
1793: raise;
1794:
1795: End create_custom_row;

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

1788: hr_utility.set_location('Entering '||l_proc,10);
1789: Exception
1790: When Others then
1791: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);
1792: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);
1793: raise;
1794:
1795: End create_custom_row;
1796:

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

1818: l_return_val Varchar2(1) := 'N';
1819: l_proc Varchar2(72) := g_package||'chk_entry_in_custom_table';
1820:
1821: BEGIN
1822: hr_utility.set_location('Entering '||l_proc,10);
1823:
1824: Open Csr_entry;
1825: Fetch Csr_entry into l_exists;
1826: Close Csr_entry;

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

1831: Else
1832: l_return_val := 'Y';
1833: End if;
1834:
1835: hr_utility.set_location('Entry Exists (Y/N) : '||l_return_val,100);
1836: hr_utility.set_location('Leaving '||l_proc,200);
1837:
1838: return l_return_val;
1839:

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

1832: l_return_val := 'Y';
1833: End if;
1834:
1835: hr_utility.set_location('Entry Exists (Y/N) : '||l_return_val,100);
1836: hr_utility.set_location('Leaving '||l_proc,200);
1837:
1838: return l_return_val;
1839:
1840: EXCEPTION

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

1838: return l_return_val;
1839:
1840: EXCEPTION
1841: WHEN OTHERS THEN
1842: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);
1843: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);
1844: return 'N';
1845:
1846: END chk_entry_in_custom_table;

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

1839:
1840: EXCEPTION
1841: WHEN OTHERS THEN
1842: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);
1843: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);
1844: return 'N';
1845:
1846: END chk_entry_in_custom_table;
1847:

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

1861: l_proc Varchar2(72) := g_package||'chk_entry_in_custom_table';
1862:
1863:
1864: Begin
1865: hr_utility.set_location('Entering '||l_proc,10);
1866:
1867: -- If data not exists in the Custom Table insert data
1868:
1869:

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

1872: ,p_interface_code => p_interface_code
1873: ,p_interface_col_code => p_interface_col_code
1874: ,p_display_seq => p_display_seq);
1875:
1876: hr_utility.set_location('Leaving '||l_proc,200);
1877: EXCEPTION
1878: WHEN OTHERS THEN
1879: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);
1880: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);

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

1875:
1876: hr_utility.set_location('Leaving '||l_proc,200);
1877: EXCEPTION
1878: WHEN OTHERS THEN
1879: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);
1880: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);
1881: raise;
1882: End manipulate_selected_data;
1883:

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

1876: hr_utility.set_location('Leaving '||l_proc,200);
1877: EXCEPTION
1878: WHEN OTHERS THEN
1879: hr_utility.set_location('Error :'||substr(sqlerrm,1,50),100);
1880: hr_utility.set_location('Error :'||substr(sqlerrm,51,100),110);
1881: raise;
1882: End manipulate_selected_data;
1883:
1884: --

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

1891: BEGIN
1892: l_exist_in_table := chk_entry_in_custom_table( p_key => p_key
1893: ,p_integrator_code => p_integrator_code);
1894:
1895: hr_utility.set_location('l_exist_in_table :'||l_exist_in_table,20);
1896:
1897:
1898: If l_exist_in_table = 'Y' Then
1899: hr_utility.set_location('Data Not exists in custom Table ',25);

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

1895: hr_utility.set_location('l_exist_in_table :'||l_exist_in_table,20);
1896:
1897:
1898: If l_exist_in_table = 'Y' Then
1899: hr_utility.set_location('Data Not exists in custom Table ',25);
1900: Delete From BEN_CUSTOM_REGION_ITEMS
1901: Where CUSTOM_KEY = p_key
1902: And REGION_CODE = p_integrator_code
1903: And CUSTOM_TYPE = p_integrator_code;

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

2184: l_proc Varchar2(72) := g_package||'update_cwb_custom_layout';
2185:
2186: BEGIN
2187: If g_debug then
2188: hr_utility.set_location('Entering '||l_proc,10);
2189: End if;
2190:
2191: delete_cwb_layout_cols(p_layout_code => p_act_layout_code
2192: ,p_application_id => 800);

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

2193:
2194: l_exist_in_table := chk_entry_in_custom_table( p_key => p_key
2195: ,p_integrator_code => p_integrator_code);
2196: If g_debug then
2197: hr_utility.set_location('l_exist_in_table :'||l_exist_in_table,20);
2198: End if;
2199:
2200: -- If data not exists in the custom table
2201: If l_exist_in_table = 'N' Then

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

2537: p_download_switch := REPLACE(REPLACE(p_download_switch,'1','0'),'2','1');
2538: p_download_switch := nvl(lpad(int2hex(bin2int(substr(p_download_switch,1,28))),7,0)||
2539: int2hex(bin2int(rpad(substr(p_download_switch,29),28,0))),'0000000');
2540: If g_debug then
2541: hr_utility.set_location('Leaving '||l_proc,10);
2542: END IF;
2543: Exception
2544: When others then
2545: Null;

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

2602:
2603: FUNCTION int2bin(int PLS_INTEGER)
2604: RETURN VARCHAR2 IS
2605: BEGIN
2606: hr_utility.set_location('int2bin:'||int, 300);
2607: IF int > 0 THEN
2608: RETURN int2bin(TRUNC(int/2))||
2609: SUBSTR('01',MOD(int,2)+1,1);
2610: ELSE

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

2615: FUNCTION hex2int(hex VARCHAR2)
2616: RETURN PLS_INTEGER IS
2617: len PLS_INTEGER := LENGTH(hex);
2618: BEGIN
2619: hr_utility.set_location('hex2int:'||hex, 300);
2620: IF NVL(len,1) = 1 THEN
2621: RETURN INSTR('0123456789ABCDEF',hex) - 1;
2622: ELSE
2623: hr_utility.set_location('hex2int length:'||len, 300);

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

2619: hr_utility.set_location('hex2int:'||hex, 300);
2620: IF NVL(len,1) = 1 THEN
2621: RETURN INSTR('0123456789ABCDEF',hex) - 1;
2622: ELSE
2623: hr_utility.set_location('hex2int length:'||len, 300);
2624: RETURN 16 * hex2int(SUBSTR(hex,1,len-1)) +
2625: INSTR('0123456789ABCDEF',SUBSTR(hex,-1)) - 1;
2626: END IF;
2627: END hex2int;