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

Line 89: hr_utility.set_location('Entering:'||l_proc, 5);

85: AND a.message_name = p_message_name;
86: --
87: Begin
88: --
89: hr_utility.set_location('Entering:'||l_proc, 5);
90: --
91: -- Chk if the message_name is valid in fnd_messages.
92: --
93: Chk_message_name(p_application_id => p_application_id,

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

205: --
206: End if;
207: --
208: --
209: hr_utility.set_location(' Leaving:'||l_proc, 10);
210: exception
211: when others then
212: p_rule_level_cd := null;
213: End;

Line 229: hr_utility.set_location('Entering:'||l_proc, 5);

225: l_proc varchar2(72) := g_package||'chk_message_name';
226: l_dummy varchar2(1);
227: --
228: Begin
229: hr_utility.set_location('Entering:'||l_proc, 5);
230: --
231: -- Check if the message_name supplied is a valid message in fnd_messages
232: --
233: Open c1;

Line 239: hr_utility.set_message(8302,'PQH_INVALID_MESSAGE_NAME');

235: Fetch c1 into l_dummy;
236: --
237: If c1%notfound then
238: Close c1;
239: hr_utility.set_message(8302,'PQH_INVALID_MESSAGE_NAME');
240: hr_utility.raise_error;
241: End if;
242: --
243: Close c1;

Line 240: hr_utility.raise_error;

236: --
237: If c1%notfound then
238: Close c1;
239: hr_utility.set_message(8302,'PQH_INVALID_MESSAGE_NAME');
240: hr_utility.raise_error;
241: End if;
242: --
243: Close c1;
244: --

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

242: --
243: Close c1;
244: --
245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 10);
247: End;
248: --
249: ---------------------------get_rule_set_id-------------------------------------
250: --

Line 264: hr_utility.set_location('Entering:'||l_proc, 5);

260: l_proc varchar2(72) := g_package||'get_rule_set_id';
261: --
262: Begin
263: --
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: --
266: -- Fetch the rule_set_id , if the message name exists in pqh_rules.
267: --
268: Open c1;

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

270: Fetch c1 into p_rule_set_id;
271: --
272: Close c1;
273: --
274: hr_utility.set_location(' Leaving:'||l_proc, 10);
275: exception
276: when others then
277: p_rule_set_id := null;
278: End;

Line 306: hr_utility.set_location('Entering:'||l_proc, 5);

302: --
303: l_proc varchar2(72) := g_package||'get_org_business_group_id';
304: --
305: Begin
306: hr_utility.set_location('Entering:'||l_proc, 5);
307: --
308: --
309: Open c1;
310: --

Line 319: hr_utility.set_message(8302,'PQH_INVALID_ORGANISATION');

315: --
316: /**
317: If c1%notfound then
318: Close c1;
319: hr_utility.set_message(8302,'PQH_INVALID_ORGANISATION');
320: hr_utility.raise_error;
321: End if;
322: **/
323: --

Line 320: hr_utility.raise_error;

316: /**
317: If c1%notfound then
318: Close c1;
319: hr_utility.set_message(8302,'PQH_INVALID_ORGANISATION');
320: hr_utility.raise_error;
321: End if;
322: **/
323: --
324: Close c1;

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

323: --
324: Close c1;
325: --
326: --
327: hr_utility.set_location(' Leaving:'||l_proc, 10);
328: exception
329: when others then
330: p_business_group_id := null;
331: End;

Line 427: hr_utility.set_location('Entering:'||l_proc, 5);

423: l_rule_level_cd varchar2(30);
424: --
425: Begin
426: --
427: hr_utility.set_location('Entering:'||l_proc, 5);
428: --
429: -- Check if the rule has been configured for the organization alone
430: --
431: Open csr_org_config;

Line 436: hr_utility.set_location('Rule is defined for the org'||l_proc, 10);

432: --
433: Fetch csr_org_config into p_rule_level_cd;
434: --
435: If csr_org_config%found then
436: hr_utility.set_location('Rule is defined for the org'||l_proc, 10);
437: Close csr_org_config;
438: RETURN TRUE;
439: End if;
440: --

Line 474: hr_utility.set_location('node is '||l_parent_node, 30);

470: loop
471: --
472: Fetch csr_parent_nodes into l_hierarchy_level,l_parent_node;
473: --
474: hr_utility.set_location('node is '||l_parent_node, 30);
475: hr_utility.set_location('hierarchy_level is '||l_hierarchy_level, 40);
476: If csr_parent_nodes%notfound then
477: exit;
478: End if;

Line 475: hr_utility.set_location('hierarchy_level is '||l_hierarchy_level, 40);

471: --
472: Fetch csr_parent_nodes into l_hierarchy_level,l_parent_node;
473: --
474: hr_utility.set_location('node is '||l_parent_node, 30);
475: hr_utility.set_location('hierarchy_level is '||l_hierarchy_level, 40);
476: If csr_parent_nodes%notfound then
477: exit;
478: End if;
479: --

Line 487: hr_utility.set_location('found a rule for node'||l_parent_node||' and rule is'||l_rule_level_cd, 30);

483: p_starting_organization_id => l_parent_node,
484: p_business_group_id => p_business_group_id,
485: p_referenced_rule_set_id => p_ref_rule_set_id);
486: if l_rule_level_cd is not null then
487: hr_utility.set_location('found a rule for node'||l_parent_node||' and rule is'||l_rule_level_cd, 30);
488: l_oh_rule := TRUE;
489: if l_rule_level_cd ='E' then
490: p_rule_level_cd := 'E' ;
491: Close csr_org_struct;

Line 495: hr_utility.set_location('did not found a E'||l_proc, 40);

491: Close csr_org_struct;
492: Close csr_parent_nodes;
493: RETURN TRUE;
494: else
495: hr_utility.set_location('did not found a E'||l_proc, 40);
496: -- severest rule not found so far, should go for next hierarchy, if any
497: if nvl(p_rule_level_cd,'I') ='I' then
498: p_rule_level_cd := l_rule_level_cd;
499: end if;

Line 514: hr_utility.set_location('OH rule is being returned'||p_rule_level_cd, 50);

510: End loop;
511: --
512: Close csr_org_struct;
513: if l_oh_rule then
514: hr_utility.set_location('OH rule is being returned'||p_rule_level_cd, 50);
515: RETURN TRUE;
516: end if;
517: --
518: --bg check

Line 525: hr_utility.set_location('BG rule is being returned'||p_rule_level_cd, 50);

521: --
522: Fetch csr_bg_config into p_rule_level_cd;
523: --
524: If csr_bg_config%found then
525: hr_utility.set_location('BG rule is being returned'||p_rule_level_cd, 50);
526: Close csr_bg_config;
527: RETURN TRUE;
528: End if;
529: --

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

527: RETURN TRUE;
528: End if;
529: --
530: Close csr_bg_config;
531: hr_utility.set_location(' Leaving:'||l_proc, 10);
532: RETURN FALSE;
533: --
534: exception
535: when others then

Line 563: hr_utility.set_location('Entering:'||l_proc, 5);

559: --
560: l_proc varchar2(72) := g_package||'g_org_structure_version_id';
561: --
562: Begin
563: hr_utility.set_location('Entering:'||l_proc, 5);
564: --
565: Open c1;
566: Fetch c1 into p_org_structure_version_id;
567: If c1%notfound then

Line 568: hr_utility.set_message(8302, 'PQH_ORG_STRUCT_VER_NOT_FOUND');

564: --
565: Open c1;
566: Fetch c1 into p_org_structure_version_id;
567: If c1%notfound then
568: hr_utility.set_message(8302, 'PQH_ORG_STRUCT_VER_NOT_FOUND');
569: hr_utility.raise_error;
570: End if;
571: Close c1;
572: --

Line 569: hr_utility.raise_error;

565: Open c1;
566: Fetch c1 into p_org_structure_version_id;
567: If c1%notfound then
568: hr_utility.set_message(8302, 'PQH_ORG_STRUCT_VER_NOT_FOUND');
569: hr_utility.raise_error;
570: End if;
571: Close c1;
572: --
573: --

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

570: End if;
571: Close c1;
572: --
573: --
574: hr_utility.set_location(' Leaving:'||l_proc, 10);
575: exception
576: when others then
577: p_org_structure_version_id := null;
578: End;

Line 599: hr_utility.set_location('Entering:'||l_proc, 5);

595: l_proc varchar2(72) := g_package||'get_rule_set_level_cd';
596: --
597: Begin
598: --
599: hr_utility.set_location('Entering:'||l_proc, 5);
600: --
601: Open c1;
602: Fetch c1 into p_rule_level_cd;
603: If c1%NOTFOUND then

Line 606: hr_utility.set_message(8302, 'PQH_INVALID_RULE_SET_ID');

602: Fetch c1 into p_rule_level_cd;
603: If c1%NOTFOUND then
604: p_rule_level_cd := NULL;
605: Close c1;
606: hr_utility.set_message(8302, 'PQH_INVALID_RULE_SET_ID');
607: hr_utility.raise_error;
608: End if;
609: Close c1;
610: --

Line 607: hr_utility.raise_error;

603: If c1%NOTFOUND then
604: p_rule_level_cd := NULL;
605: Close c1;
606: hr_utility.set_message(8302, 'PQH_INVALID_RULE_SET_ID');
607: hr_utility.raise_error;
608: End if;
609: Close c1;
610: --
611: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

607: hr_utility.raise_error;
608: End if;
609: Close c1;
610: --
611: hr_utility.set_location(' Leaving:'||l_proc, 10);
612: --
613: exception
614: when others then
615: p_rule_level_cd := null;

Line 634: hr_utility.set_location('Entering:'||l_proc, 5);

630: --
631: l_proc varchar2(72) := g_package||'get_language_code';
632: --
633: Begin
634: hr_utility.set_location('Entering:'||l_proc, 5);
635: --
636: --
637: Open c1;
638: Fetch c1 into p_language_code;

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

640: p_language_code := 'US';
641: End if;
642: Close c1;
643: --
644: hr_utility.set_location(' Leaving:'||l_proc, 10);
645: --
646: exception
647: when others then
648: p_language_code := null;

Line 657: hr_utility.set_location('Entering:'||l_proc, 5);

653: --
654: l_proc varchar2(72) := g_package||'init_query_date';
655: --
656: Begin
657: hr_utility.set_location('Entering:'||l_proc, 5);
658: --
659: g_query_date := null;
660: --
661: hr_utility.set_location('Leaving:'||l_proc, 10);

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

657: hr_utility.set_location('Entering:'||l_proc, 5);
658: --
659: g_query_date := null;
660: --
661: hr_utility.set_location('Leaving:'||l_proc, 10);
662: --
663: end;
664: --
665: Procedure set_query_date(p_effective_date in date) is

Line 670: hr_utility.set_location('Entering:'||l_proc, 5);

666: --
667: l_proc varchar2(72) := g_package||'set_query_date';
668: --
669: Begin
670: hr_utility.set_location('Entering:'||l_proc, 5);
671: --
672: g_query_date := p_effective_date;
673: --
674: hr_utility.set_location('Leaving:'||l_proc, 10);

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

670: hr_utility.set_location('Entering:'||l_proc, 5);
671: --
672: g_query_date := p_effective_date;
673: --
674: hr_utility.set_location('Leaving:'||l_proc, 10);
675: --
676: end;
677: --
678: --

Line 684: hr_utility.set_location('Entering:'||l_proc, 5);

680: --
681: l_proc varchar2(72) := g_package||'get_query_date';
682: --
683: Begin
684: hr_utility.set_location('Entering:'||l_proc, 5);
685: --
686: --
687: return nvl(g_query_date, trunc(sysdate));
688: --

Line 701: hr_utility.set_location('Entering:'||l_proc, 5);

697: dummy_table warnings_tab;
698: l_proc varchar2(72) := g_package||'init_warnings_table';
699: --
700: Begin
701: hr_utility.set_location('Entering:'||l_proc, 5);
702: --
703: --
704: g_warning_no := 0;
705: g_next_warning_no := 0;

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

710: --
711: -- g_warnings_table := dummy_table;
712: g_warnings_table.DELETE;
713: --
714: hr_utility.set_location('Leaving:'||l_proc, 10);
715: --
716: end;
717: --
718: -- ----------------------------------------------------------------------------

Line 729: hr_utility.set_location('Entering:'||l_proc, 5);

725: cnt number(10);
726: l_proc varchar2(72) := g_package||'insert_warning';
727: --
728: Begin
729: hr_utility.set_location('Entering:'||l_proc, 5);
730: --
731: -- Check if this warning is already in table .
732: --
733: If g_warning_no > 0 then

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

758: g_warnings_table(g_warning_no).message_text := p_warnings_rec.message_text;
759: --
760: End if;
761: --
762: hr_utility.set_location('Leaving:'||l_proc, 10);
763: --
764: End;
765: --
766: -- ----------------------------------------------------------------------------

Line 775: hr_utility.set_location('Entering:'||l_proc, 5);

771: --
772: l_proc varchar2(72) := g_package||'get_next_warning';
773: --
774: Begin
775: hr_utility.set_location('Entering:'||l_proc, 5);
776: --
777: g_next_warning_no := g_next_warning_no + 1;
778: --
779: -- Raise error if the next warning no exceeds the actual number of warnings

Line 784: hr_utility.set_message(8302,'PQH_INVALID_WARNING_NO');

780: -- in the table.
781: --
782: If g_next_warning_no > g_warning_no then
783: --
784: hr_utility.set_message(8302,'PQH_INVALID_WARNING_NO');
785: hr_utility.raise_error;
786: --
787: End if;
788: --

Line 785: hr_utility.raise_error;

781: --
782: If g_next_warning_no > g_warning_no then
783: --
784: hr_utility.set_message(8302,'PQH_INVALID_WARNING_NO');
785: hr_utility.raise_error;
786: --
787: End if;
788: --
789: -- Return the next warning.

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

789: -- Return the next warning.
790: --
791: p_warnings_rec.message_text := g_warnings_table(g_next_warning_no).message_text ;
792: --
793: hr_utility.set_location('Leaving:'||l_proc, 10);
794: --
795: exception
796: when others then
797: p_warnings_rec := null;

Line 810: hr_utility.set_location('Entering:'||l_proc, 5);

806: --
807: l_proc varchar2(72) := g_package||'get_all_warnings';
808: --
809: Begin
810: hr_utility.set_location('Entering:'||l_proc, 5);
811: --
812: --
813: p_warnings_tab := g_warnings_table;
814: --

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

814: --
815: --
816: p_no_warnings := g_warning_no;
817: --
818: hr_utility.set_location('Leaving:'||l_proc, 10);
819: --
820: exception
821: when others then
822: p_no_warnings := null;

Line 825: -- Rewriting hr_utility functions

821: when others then
822: p_no_warnings := null;
823: End;
824:
825: -- Rewriting hr_utility functions
826:
827: -----------------------------------set_message --------------------------------
828: --
829: -- NAME

Line 845: hr_utility.set_location('Entering:'||l_proc, 5);

841: --
842: l_proc varchar2(72) := g_package||'set_message';
843: --
844: begin
845: hr_utility.set_location('Entering:'||l_proc, 5);
846: --
847: --
848: --
849: get_message_level_cd(p_application_id => applid,

Line 856: hr_utility.set_message(applid,l_message_name);

852: p_rule_level_cd => l_rule_level_cd);
853: --
854: g_rule_level_cd := l_rule_level_cd;
855: --
856: hr_utility.set_message(applid,l_message_name);
857: --
858: --
859: hr_utility.set_location('Leaving:'||l_proc, 10);
860: --

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

855: --
856: hr_utility.set_message(applid,l_message_name);
857: --
858: --
859: hr_utility.set_location('Leaving:'||l_proc, 10);
860: --
861: end set_message;
862: --
863: -----------------------------------set_warning_message --------------------------------

Line 881: hr_utility.set_location('Entering:'||l_proc, 5);

877: --
878: l_proc varchar2(72) := g_package||'set_message';
879: --
880: begin
881: hr_utility.set_location('Entering:'||l_proc, 5);
882: --
883: --
884: --
885: g_rule_level_cd := 'W';

Line 887: hr_utility.set_message(applid,l_message_name);

883: --
884: --
885: g_rule_level_cd := 'W';
886: --
887: hr_utility.set_message(applid,l_message_name);
888: --
889: --
890: hr_utility.set_location('Leaving:'||l_proc, 10);
891: --

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

886: --
887: hr_utility.set_message(applid,l_message_name);
888: --
889: --
890: hr_utility.set_location('Leaving:'||l_proc, 10);
891: --
892: end set_warning_message;
893: --
894: ------------------------------ set_message_token ------------------------------

Line 907: hr_utility.set_location('Entering:'||l_proc, 5);

903: --
904: l_proc varchar2(72) := g_package||'set_message_token';
905: --
906: begin
907: hr_utility.set_location('Entering:'||l_proc, 5);
908: --
909: --
910: hr_utility.set_message_token(l_token_name,l_token_value);
911: --

Line 910: hr_utility.set_message_token(l_token_name,l_token_value);

906: begin
907: hr_utility.set_location('Entering:'||l_proc, 5);
908: --
909: --
910: hr_utility.set_message_token(l_token_name,l_token_value);
911: --
912: --
913: hr_utility.set_location('Leaving:'||l_proc, 10);
914: --

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

909: --
910: hr_utility.set_message_token(l_token_name,l_token_value);
911: --
912: --
913: hr_utility.set_location('Leaving:'||l_proc, 10);
914: --
915: end set_message_token;
916:
917: ------------------------------ set_message_token ------------------------------

Line 933: hr_utility.set_location('Entering:'||l_proc, 5);

929: --
930: l_proc varchar2(72) := g_package||'set_message_token';
931: --
932: begin
933: hr_utility.set_location('Entering:'||l_proc, 5);
934: --
935: --
936: hr_utility.set_message_token(l_applid,l_token_name,l_token_message);
937: --

Line 936: hr_utility.set_message_token(l_applid,l_token_name,l_token_message);

932: begin
933: hr_utility.set_location('Entering:'||l_proc, 5);
934: --
935: --
936: hr_utility.set_message_token(l_applid,l_token_name,l_token_message);
937: --
938: --
939: hr_utility.set_location('Leaving:'||l_proc, 10);
940: --

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

935: --
936: hr_utility.set_message_token(l_applid,l_token_name,l_token_message);
937: --
938: --
939: hr_utility.set_location('Leaving:'||l_proc, 10);
940: --
941: end set_message_token;
942: ------------------------------raise_error---------------------------------------
943: -- NAME

Line 956: hr_utility.set_location('Entering:'||l_proc, 5);

952: --
953: l_proc varchar2(72) := g_package||'raise_error';
954: --
955: begin
956: hr_utility.set_location('Entering:'||l_proc, 5);
957: --
958: --
959: If g_rule_level_cd = 'E' then
960: hr_utility.raise_error;

Line 960: hr_utility.raise_error;

956: hr_utility.set_location('Entering:'||l_proc, 5);
957: --
958: --
959: If g_rule_level_cd = 'E' then
960: hr_utility.raise_error;
961: Elsif g_rule_level_cd = 'W' then
962: l_warnings_rec.message_text := hr_utility.get_message;
963: insert_warning(p_warnings_rec => l_warnings_rec);
964: End if;

Line 962: l_warnings_rec.message_text := hr_utility.get_message;

958: --
959: If g_rule_level_cd = 'E' then
960: hr_utility.raise_error;
961: Elsif g_rule_level_cd = 'W' then
962: l_warnings_rec.message_text := hr_utility.get_message;
963: insert_warning(p_warnings_rec => l_warnings_rec);
964: End if;
965: --
966: --

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

963: insert_warning(p_warnings_rec => l_warnings_rec);
964: End if;
965: --
966: --
967: hr_utility.set_location('Leaving:'||l_proc, 10);
968: --
969: End raise_error;
970: --
971: --

Line 995: hr_utility.set_location('Entering:'||l_proc, 5);

991: and ses.session_id = userenv('sessionid')
992: and ses.effective_date between ppl.effective_start_date and ppl.effective_end_date
993: and ses.effective_date between asg.effective_start_date and asg.effective_end_date;
994: Begin
995: hr_utility.set_location('Entering:'||l_proc, 5);
996: --
997: Open assignment_name;
998: Fetch assignment_name into ret_assignment_name;
999: Close assignment_name;

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

997: Open assignment_name;
998: Fetch assignment_name into ret_assignment_name;
999: Close assignment_name;
1000: --
1001: hr_utility.set_location('Leaving:'||l_proc, 10);
1002: --
1003: Return ret_assignment_name;
1004: End;
1005: --

Line 1011: hr_utility.set_location('Entering:'||l_proc, 5);

1007: function get_message_type_cd return varchar2 is
1008: l_proc varchar2(72) := g_package||'get_message_type_cd';
1009: --
1010: begin
1011: hr_utility.set_location('Entering:'||l_proc, 5);
1012: --
1013: return g_rule_level_cd;
1014: --
1015: hr_utility.set_location('Leaving:'||l_proc, 10);

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

1011: hr_utility.set_location('Entering:'||l_proc, 5);
1012: --
1013: return g_rule_level_cd;
1014: --
1015: hr_utility.set_location('Leaving:'||l_proc, 10);
1016: end;
1017: --
1018: --
1019: function get_message return varchar2 is

Line 1022: hr_utility.set_location('Entering:'||l_proc, 5);

1018: --
1019: function get_message return varchar2 is
1020: l_proc varchar2(72) := g_package||'get_message';
1021: begin
1022: hr_utility.set_location('Entering:'||l_proc, 5);
1023: --
1024: return hr_utility.get_message;
1025: --
1026: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 1024: return hr_utility.get_message;

1020: l_proc varchar2(72) := g_package||'get_message';
1021: begin
1022: hr_utility.set_location('Entering:'||l_proc, 5);
1023: --
1024: return hr_utility.get_message;
1025: --
1026: hr_utility.set_location('Leaving:'||l_proc, 10);
1027: end;
1028: --

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

1022: hr_utility.set_location('Entering:'||l_proc, 5);
1023: --
1024: return hr_utility.get_message;
1025: --
1026: hr_utility.set_location('Leaving:'||l_proc, 10);
1027: end;
1028: --
1029: --
1030: procedure save_point is

Line 1072: hr_utility.set_location('Entering:'||l_proc, 5);

1068: l_proc varchar2(72) := g_package||'get_pos_budget_values';
1069: --
1070: Begin
1071: --
1072: hr_utility.set_location('Entering:'||l_proc, 5);
1073: --
1074: --
1075: -- Obtain the business group and position_name of the position.
1076: --

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

1091: p_end_date => p_period_end_dt ,
1092: p_actual_val => NULL
1093: );
1094: --
1095: hr_utility.set_location('Leaving:'||l_proc, 10);
1096: --
1097: RETURN l_pbv;
1098: --
1099: Exception When others then

Line 1101: hr_utility.set_location('Exception:'||l_proc, 15);

1097: RETURN l_pbv;
1098: --
1099: Exception When others then
1100: --
1101: hr_utility.set_location('Exception:'||l_proc, 15);
1102: raise;
1103: --
1104: End;
1105: --

Line 1128: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');

1124: l_budget_unit1_id,l_budget_unit2_id,l_budget_unit3_id;
1125: close c1;
1126: exception
1127: when others then
1128: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
1129: hr_utility.raise_error;
1130: end;
1131: p_unit1_desc := get_unit_desc(l_budget_unit1_id);
1132: if l_budget_unit2_id is not null then

Line 1129: hr_utility.raise_error;

1125: close c1;
1126: exception
1127: when others then
1128: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
1129: hr_utility.raise_error;
1130: end;
1131: p_unit1_desc := get_unit_desc(l_budget_unit1_id);
1132: if l_budget_unit2_id is not null then
1133: p_unit2_desc := get_unit_desc(l_budget_unit2_id);

Line 1143: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');

1139: else
1140: p_unit3_desc := null;
1141: end if;
1142: else
1143: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
1144: hr_utility.raise_error;
1145: end if;
1146: exception
1147: when others then

Line 1144: hr_utility.raise_error;

1140: p_unit3_desc := null;
1141: end if;
1142: else
1143: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
1144: hr_utility.raise_error;
1145: end if;
1146: exception
1147: when others then
1148: p_unit1_desc := null;

Line 1151: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');

1147: when others then
1148: p_unit1_desc := null;
1149: p_unit2_desc := null;
1150: p_unit3_desc := null;
1151: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
1152: hr_utility.raise_error;
1153: end get_all_unit_desc;
1154:
1155:

Line 1152: hr_utility.raise_error;

1148: p_unit1_desc := null;
1149: p_unit2_desc := null;
1150: p_unit3_desc := null;
1151: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
1152: hr_utility.raise_error;
1153: end get_all_unit_desc;
1154:
1155:
1156: function get_unit_desc(p_unit_id in number) return varchar2 is

Line 1169: hr_utility.set_message(8302,'PQH_INVALID_UNIT_ENTERED');

1165: close c1;
1166: return l_shared_type_name;
1167: exception
1168: when others then
1169: hr_utility.set_message(8302,'PQH_INVALID_UNIT_ENTERED');
1170: hr_utility.raise_error;
1171: end get_unit_desc;
1172: --
1173: function chk_pos_pending_txns(p_position_id in number, p_position_transaction_id in number default null) return varchar2 is

Line 1170: hr_utility.raise_error;

1166: return l_shared_type_name;
1167: exception
1168: when others then
1169: hr_utility.set_message(8302,'PQH_INVALID_UNIT_ENTERED');
1170: hr_utility.raise_error;
1171: end get_unit_desc;
1172: --
1173: function chk_pos_pending_txns(p_position_id in number, p_position_transaction_id in number default null) return varchar2 is
1174: l_count_pending_txns number:=0;

Line 1237: hr_utility.set_location('p_status '||p_transaction_status||'l_review_flag '||l_review_flag, 15);

1233: p_position_transaction_id => p_position_transaction_id
1234: ,p_object_version_number => l_object_version_number
1235: );
1236:
1237: hr_utility.set_location('p_status '||p_transaction_status||'l_review_flag '||l_review_flag, 15);
1238: -- If condition added for Bug 6112905 / Modified for bug 6524175
1239: if p_transaction_status in ('REJECT','TERMINATE','SUBMITTED') then
1240: l_review_flag := 'N';
1241: end if;

Line 1242: hr_utility.set_location('p_status '||p_transaction_status||'l_review_flag '||l_review_flag, 25);

1238: -- If condition added for Bug 6112905 / Modified for bug 6524175
1239: if p_transaction_status in ('REJECT','TERMINATE','SUBMITTED') then
1240: l_review_flag := 'N';
1241: end if;
1242: hr_utility.set_location('p_status '||p_transaction_status||'l_review_flag '||l_review_flag, 25);
1243:
1244: -- Update the position transaction
1245: pqh_position_transactions_api.update_position_transaction
1246: (

Line 1641: hr_utility.set_location('before '||l_stmt,10);

1637: 'where '||l_id_column_name||'='||''''||p_value||'''',
1638: ' ');
1639: END IF;
1640:
1641: hr_utility.set_location('before '||l_stmt,10);
1642: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1643: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1644: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1645: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);

Line 1642: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);

1638: ' ');
1639: END IF;
1640:
1641: hr_utility.set_location('before '||l_stmt,10);
1642: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1643: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1644: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1645: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1646: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);

Line 1643: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);

1639: END IF;
1640:
1641: hr_utility.set_location('before '||l_stmt,10);
1642: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1643: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1644: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1645: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1646: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1647: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);

Line 1644: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);

1640:
1641: hr_utility.set_location('before '||l_stmt,10);
1642: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1643: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1644: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1645: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1646: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1647: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1648: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);

Line 1645: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);

1641: hr_utility.set_location('before '||l_stmt,10);
1642: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1643: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1644: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1645: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1646: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1647: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1648: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1649: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);

Line 1646: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);

1642: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1643: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1644: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1645: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1646: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1647: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1648: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1649: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1650: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);

Line 1647: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);

1643: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1644: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1645: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1646: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1647: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1648: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1649: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1650: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1651: hr_utility.set_location('zzzzzzzzzzzzzzzzzzzzzzzzzzzz',11);

Line 1648: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);

1644: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1645: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1646: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1647: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1648: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1649: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1650: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1651: hr_utility.set_location('zzzzzzzzzzzzzzzzzzzzzzzzzzzz',11);
1652: -- Added by DN for CBR Enhancements

Line 1649: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);

1645: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1646: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1647: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1648: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1649: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1650: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1651: hr_utility.set_location('zzzzzzzzzzzzzzzzzzzzzzzzzzzz',11);
1652: -- Added by DN for CBR Enhancements
1653: IF INSTR(UPPER(l_stmt), ':1') <> 0 THEN

Line 1650: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);

1646: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1647: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1648: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1649: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1650: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1651: hr_utility.set_location('zzzzzzzzzzzzzzzzzzzzzzzzzzzz',11);
1652: -- Added by DN for CBR Enhancements
1653: IF INSTR(UPPER(l_stmt), ':1') <> 0 THEN
1654: -- Replace :1 with business_group_id;

Line 1651: hr_utility.set_location('zzzzzzzzzzzzzzzzzzzzzzzzzzzz',11);

1647: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1648: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1649: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1650: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1651: hr_utility.set_location('zzzzzzzzzzzzzzzzzzzzzzzzzzzz',11);
1652: -- Added by DN for CBR Enhancements
1653: IF INSTR(UPPER(l_stmt), ':1') <> 0 THEN
1654: -- Replace :1 with business_group_id;
1655: l_stmt := REPLACE(l_stmt, ':1', 'BUSINESS_GROUP_ID');

Line 1662: hr_utility.set_location('inside bg pattern',11);

1658: l_stmt := REPLACE(l_stmt, 'FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')', 'BUSINESS_GROUP_ID');
1659: END IF;
1660: -- FOR RBC
1661: if instr(upper(l_stmt),':$PROFILES$.PER_BUSINESS_GROUP_ID') > 0 then
1662: hr_utility.set_location('inside bg pattern',11);
1663: l_stmt := REPLACE(l_stmt,':$PROFILES$.PER_BUSINESS_GROUP_ID','FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')');
1664:
1665: end if;
1666: if instr(upper(l_stmt),':$FLEX$.PER_DATES_STANDARD') > 0 then

Line 1667: hr_utility.set_location('inside date pattern',11);

1663: l_stmt := REPLACE(l_stmt,':$PROFILES$.PER_BUSINESS_GROUP_ID','FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')');
1664:
1665: end if;
1666: if instr(upper(l_stmt),':$FLEX$.PER_DATES_STANDARD') > 0 then
1667: hr_utility.set_location('inside date pattern',11);
1668: /**
1669: l_stmt := REPLACE(l_stmt,'TO_DATE(:$FLEX$.PER_DATES_STANDARD,''YYYY/MM/DD HH24:MI:SS'')','trunc(sysdate)');
1670: **/
1671: l_stmt := REPLACE(l_stmt,'TO_DATE(:$FLEX$.PER_DATES_STANDARD,''YYYY/MM/DD HH24:MI:SS'')','pqh_utility.get_query_date');

Line 1673: hr_utility.set_location(' Now executing :'||l_stmt,909);

1669: l_stmt := REPLACE(l_stmt,'TO_DATE(:$FLEX$.PER_DATES_STANDARD,''YYYY/MM/DD HH24:MI:SS'')','trunc(sysdate)');
1670: **/
1671: l_stmt := REPLACE(l_stmt,'TO_DATE(:$FLEX$.PER_DATES_STANDARD,''YYYY/MM/DD HH24:MI:SS'')','pqh_utility.get_query_date');
1672: end if;
1673: hr_utility.set_location(' Now executing :'||l_stmt,909);
1674:
1675: EXECUTE IMMEDIATE l_stmt INTO l_display;
1676: ELSE
1677: -- If validation type is not table then return entered value as result.

Line 1688: hr_utility.set_location(sqlerrm,10);

1684: END IF;
1685: RETURN l_display;
1686: EXCEPTION
1687: WHEN OTHERS THEN
1688: hr_utility.set_location(sqlerrm,10);
1689: hr_utility.set_location('in exception stmt executed is',10);
1690: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1691: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1692: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);

Line 1689: hr_utility.set_location('in exception stmt executed is',10);

1685: RETURN l_display;
1686: EXCEPTION
1687: WHEN OTHERS THEN
1688: hr_utility.set_location(sqlerrm,10);
1689: hr_utility.set_location('in exception stmt executed is',10);
1690: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1691: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1692: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1693: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);

Line 1690: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);

1686: EXCEPTION
1687: WHEN OTHERS THEN
1688: hr_utility.set_location(sqlerrm,10);
1689: hr_utility.set_location('in exception stmt executed is',10);
1690: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1691: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1692: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1693: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1694: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);

Line 1691: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);

1687: WHEN OTHERS THEN
1688: hr_utility.set_location(sqlerrm,10);
1689: hr_utility.set_location('in exception stmt executed is',10);
1690: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1691: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1692: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1693: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1694: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1695: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);

Line 1692: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);

1688: hr_utility.set_location(sqlerrm,10);
1689: hr_utility.set_location('in exception stmt executed is',10);
1690: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1691: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1692: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1693: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1694: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1695: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1696: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);

Line 1693: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);

1689: hr_utility.set_location('in exception stmt executed is',10);
1690: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1691: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1692: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1693: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1694: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1695: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1696: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1697: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);

Line 1694: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);

1690: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1691: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1692: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1693: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1694: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1695: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1696: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1697: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1698: l_display := p_value;

Line 1695: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);

1691: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1692: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1693: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1694: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1695: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1696: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1697: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1698: l_display := p_value;
1699: RETURN l_display;

Line 1696: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);

1692: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1693: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1694: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1695: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1696: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1697: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1698: l_display := p_value;
1699: RETURN l_display;
1700: END;

Line 1697: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);

1693: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1694: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1695: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1696: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1697: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1698: l_display := p_value;
1699: RETURN l_display;
1700: END;
1701: --

Line 1748: hr_utility.set_location('before replace stmt is ',10);

1744: 'where '||l_id_column_name||'='||''''||p_value||'''',
1745: ' ');
1746: END IF;
1747:
1748: hr_utility.set_location('before replace stmt is ',10);
1749: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1750: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1751: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1752: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);

Line 1749: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);

1745: ' ');
1746: END IF;
1747:
1748: hr_utility.set_location('before replace stmt is ',10);
1749: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1750: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1751: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1752: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1753: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);

Line 1750: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);

1746: END IF;
1747:
1748: hr_utility.set_location('before replace stmt is ',10);
1749: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1750: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1751: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1752: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1753: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1754: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);

Line 1751: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);

1747:
1748: hr_utility.set_location('before replace stmt is ',10);
1749: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1750: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1751: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1752: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1753: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1754: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1755: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);

Line 1752: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);

1748: hr_utility.set_location('before replace stmt is ',10);
1749: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1750: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1751: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1752: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1753: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1754: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1755: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1756: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);

Line 1753: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);

1749: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1750: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1751: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1752: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1753: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1754: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1755: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1756: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1757: hr_utility.set_location('zzzzzzzzzzzzzzzzzzzzzzzzzzzz',11);

Line 1754: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);

1750: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1751: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1752: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1753: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1754: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1755: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1756: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1757: hr_utility.set_location('zzzzzzzzzzzzzzzzzzzzzzzzzzzz',11);
1758: -- Added by DN for CBR Enhancements

Line 1755: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);

1751: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1752: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1753: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1754: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1755: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1756: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1757: hr_utility.set_location('zzzzzzzzzzzzzzzzzzzzzzzzzzzz',11);
1758: -- Added by DN for CBR Enhancements
1759: IF INSTR(UPPER(l_stmt), ':1') <> 0 THEN

Line 1756: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);

1752: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1753: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1754: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1755: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1756: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1757: hr_utility.set_location('zzzzzzzzzzzzzzzzzzzzzzzzzzzz',11);
1758: -- Added by DN for CBR Enhancements
1759: IF INSTR(UPPER(l_stmt), ':1') <> 0 THEN
1760: -- Replace :1 with business_group_id;

Line 1757: hr_utility.set_location('zzzzzzzzzzzzzzzzzzzzzzzzzzzz',11);

1753: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1754: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1755: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1756: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1757: hr_utility.set_location('zzzzzzzzzzzzzzzzzzzzzzzzzzzz',11);
1758: -- Added by DN for CBR Enhancements
1759: IF INSTR(UPPER(l_stmt), ':1') <> 0 THEN
1760: -- Replace :1 with business_group_id;
1761: l_stmt := REPLACE(l_stmt, ':1', 'BUSINESS_GROUP_ID');

Line 1767: hr_utility.set_location('inside bg pattern',11);

1763: -- Replace FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') with business_group_id;
1764: l_stmt := REPLACE(l_stmt, 'FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')', 'BUSINESS_GROUP_ID');
1765: END IF;
1766: if instr(upper(l_stmt),':$PROFILES$.PER_BUSINESS_GROUP_ID') > 0 then
1767: hr_utility.set_location('inside bg pattern',11);
1768: l_stmt := REPLACE(l_stmt,':$PROFILES$.PER_BUSINESS_GROUP_ID','FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')');
1769: end if;
1770: if instr(upper(l_stmt),':$FLEX$.PER_DATES_STANDARD') > 0 then
1771: hr_utility.set_location('inside date pattern',11);

Line 1771: hr_utility.set_location('inside date pattern',11);

1767: hr_utility.set_location('inside bg pattern',11);
1768: l_stmt := REPLACE(l_stmt,':$PROFILES$.PER_BUSINESS_GROUP_ID','FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')');
1769: end if;
1770: if instr(upper(l_stmt),':$FLEX$.PER_DATES_STANDARD') > 0 then
1771: hr_utility.set_location('inside date pattern',11);
1772: l_stmt := REPLACE(l_stmt,'TO_DATE(:$FLEX$.PER_DATES_STANDARD,''YYYY/MM/DD HH24:MI:SS'')','trunc(sysdate)');
1773: end if;
1774: if instr(upper(l_stmt),':$FLEX$.'||p_prnt_valset_nm) > 0 then
1775: hr_utility.set_location('inside date pattern',11);

Line 1775: hr_utility.set_location('inside date pattern',11);

1771: hr_utility.set_location('inside date pattern',11);
1772: l_stmt := REPLACE(l_stmt,'TO_DATE(:$FLEX$.PER_DATES_STANDARD,''YYYY/MM/DD HH24:MI:SS'')','trunc(sysdate)');
1773: end if;
1774: if instr(upper(l_stmt),':$FLEX$.'||p_prnt_valset_nm) > 0 then
1775: hr_utility.set_location('inside date pattern',11);
1776: l_stmt := REPLACE(l_stmt,':$FLEX$.'||p_prnt_valset_nm,p_prnt_value);
1777: end if;
1778: EXECUTE IMMEDIATE l_stmt INTO l_display;
1779: ELSE

Line 1791: hr_utility.set_location('in exception stmt executed is',10);

1787: END IF;
1788: RETURN l_display;
1789: EXCEPTION
1790: WHEN OTHERS THEN
1791: hr_utility.set_location('in exception stmt executed is',10);
1792: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1793: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1794: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1795: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);

Line 1792: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);

1788: RETURN l_display;
1789: EXCEPTION
1790: WHEN OTHERS THEN
1791: hr_utility.set_location('in exception stmt executed is',10);
1792: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1793: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1794: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1795: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1796: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);

Line 1793: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);

1789: EXCEPTION
1790: WHEN OTHERS THEN
1791: hr_utility.set_location('in exception stmt executed is',10);
1792: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1793: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1794: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1795: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1796: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1797: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);

Line 1794: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);

1790: WHEN OTHERS THEN
1791: hr_utility.set_location('in exception stmt executed is',10);
1792: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1793: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1794: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1795: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1796: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1797: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1798: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);

Line 1795: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);

1791: hr_utility.set_location('in exception stmt executed is',10);
1792: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1793: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1794: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1795: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1796: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1797: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1798: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1799: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);

Line 1796: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);

1792: hr_utility.set_location('1 -> '||substr(l_stmt,1,50),11);
1793: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1794: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1795: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1796: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1797: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1798: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1799: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1800: l_display := p_value;

Line 1797: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);

1793: hr_utility.set_location('2 -> '||substr(l_stmt,51,50),11);
1794: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1795: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1796: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1797: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1798: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1799: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1800: l_display := p_value;
1801: RETURN l_display;

Line 1798: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);

1794: hr_utility.set_location('3 -> '||substr(l_stmt,101,50),11);
1795: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1796: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1797: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1798: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1799: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1800: l_display := p_value;
1801: RETURN l_display;
1802: END;

Line 1799: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);

1795: hr_utility.set_location('4 -> '||substr(l_stmt,151,50),11);
1796: hr_utility.set_location('5 -> '||substr(l_stmt,201,50),11);
1797: hr_utility.set_location('6 -> '||substr(l_stmt,251,50),11);
1798: hr_utility.set_location('7 -> '||substr(l_stmt,301,50),11);
1799: hr_utility.set_location('8 -> '||substr(l_stmt,351,50),11);
1800: l_display := p_value;
1801: RETURN l_display;
1802: END;
1803: --

Line 1962: return hr_utility.chk_product_install('PQH',p_legislation_code);

1958: /* function is_pqh_installed(p_legislation_code IN VARCHAR2) return boolean is
1959: --
1960: begin
1961: --
1962: return hr_utility.chk_product_install('PQH',p_legislation_code);
1963: --
1964: end is_pqh_installed;*/
1965: --
1966: function is_pqh_installed(p_business_group_id IN NUMBER) return boolean is