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.PER_IN_PERSON_LEG_HOOK dependencies on HR_GENERAL

Line 539: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');

535: -- Check for the length
536: IF NOT length(p_pan) = 10 THEN
537: p_message_name := 'PER_IN_INVALID_FORMAT';
538: p_token_name(1) := 'FIELD';
539: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
540: p_token_name(2) := 'FORMAT';
541: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
542: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
543:

Line 541: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');

537: p_message_name := 'PER_IN_INVALID_FORMAT';
538: p_token_name(1) := 'FIELD';
539: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
540: p_token_name(2) := 'FORMAT';
541: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
542: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
543:
544: IF g_debug THEN
545: pay_in_utils.trace('**************************************************','********************');

Line 565: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');

561: -- Check for the numeric part.
562: IF NOT ascii(substr(l_char6_9_string, l_count, 1) ) BETWEEN ASCII('0') AND ASCII('9') THEN
563: p_message_name := 'PER_IN_INVALID_FORMAT';
564: p_token_name(1) := 'FIELD';
565: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
566: p_token_name(2) := 'FORMAT';
567: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
568:
569: IF g_debug THEN

Line 567: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');

563: p_message_name := 'PER_IN_INVALID_FORMAT';
564: p_token_name(1) := 'FIELD';
565: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
566: p_token_name(2) := 'FORMAT';
567: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
568:
569: IF g_debug THEN
570: pay_in_utils.trace('**************************************************','********************');
571: pay_in_utils.trace('p_message_name ',p_message_name);

Line 584: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');

580: EXCEPTION
581: WHEN OTHERS THEN
582: p_message_name := 'PER_IN_INVALID_FORMAT';
583: p_token_name(1) := 'FIELD';
584: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
585: p_token_name(2) := 'FORMAT';
586: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
587:
588: IF g_debug THEN

Line 586: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');

582: p_message_name := 'PER_IN_INVALID_FORMAT';
583: p_token_name(1) := 'FIELD';
584: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
585: p_token_name(2) := 'FORMAT';
586: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
587:
588: IF g_debug THEN
589: pay_in_utils.trace('**************************************************','********************');
590: pay_in_utils.trace('p_message_name ',p_message_name);

Line 604: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');

600: l_char_string := substr(p_pan, 10, 1) ;
601: IF NOT ascii(l_char_string) BETWEEN ASCII('A') AND ASCII('Z') THEN
602: p_message_name := 'PER_IN_INVALID_FORMAT';
603: p_token_name(1) := 'FIELD';
604: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
605: p_token_name(2) := 'FORMAT';
606: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
607:
608: IF g_debug THEN

Line 606: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');

602: p_message_name := 'PER_IN_INVALID_FORMAT';
603: p_token_name(1) := 'FIELD';
604: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
605: p_token_name(2) := 'FORMAT';
606: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
607:
608: IF g_debug THEN
609: pay_in_utils.trace('**************************************************','********************');
610: pay_in_utils.trace('p_message_name ',p_message_name);

Line 625: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');

621: -- Check for the first 5 alphabats
622: IF NOT ascii( substr(l_char_string, l_count, 1) ) BETWEEN ASCII('A') AND ASCII('Z') THEN
623: p_message_name := 'PER_IN_INVALID_FORMAT';
624: p_token_name(1) := 'FIELD';
625: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
626: p_token_name(2) := 'FORMAT';
627: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
628:
629: IF g_debug THEN

Line 627: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');

623: p_message_name := 'PER_IN_INVALID_FORMAT';
624: p_token_name(1) := 'FIELD';
625: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
626: p_token_name(2) := 'FORMAT';
627: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
628:
629: IF g_debug THEN
630: pay_in_utils.trace('**************************************************','********************');
631: pay_in_utils.trace('p_message_name ',p_message_name);

Line 644: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');

640: --Checks that either the PAN field or the PAN Applied For field is null.
641: IF p_pan IS NOT NULL AND p_pan_af IS NOT NULL THEN
642: p_message_name := 'PER_IN_TWO_FIELD_MISMATCH';
643: p_token_name(1) := 'FIELD1';
644: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
645: p_token_name(2) := 'FIELD2';
646: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_AF');
647:
648: IF g_debug THEN

Line 646: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_AF');

642: p_message_name := 'PER_IN_TWO_FIELD_MISMATCH';
643: p_token_name(1) := 'FIELD1';
644: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
645: p_token_name(2) := 'FIELD2';
646: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_AF');
647:
648: IF g_debug THEN
649: pay_in_utils.trace('**************************************************','********************');
650: pay_in_utils.trace('p_message_name ',p_message_name);

Line 662: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');

658: --Checks that either the PAN field or the PAN Ref Number For field is null.
659: IF p_pan IS NOT NULL AND p_panref_number IS NOT NULL THEN
660: p_message_name := 'PER_IN_TWO_FIELD_MISMATCH';
661: p_token_name(1) := 'FIELD1';
662: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
663: p_token_name(2) := 'FIELD2';
664: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_REF');
665:
666: IF g_debug THEN

Line 664: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_REF');

660: p_message_name := 'PER_IN_TWO_FIELD_MISMATCH';
661: p_token_name(1) := 'FIELD1';
662: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
663: p_token_name(2) := 'FIELD2';
664: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_REF');
665:
666: IF g_debug THEN
667: pay_in_utils.trace('**************************************************','********************');
668: pay_in_utils.trace('p_message_name ',p_message_name);

Line 832: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PERSON_TYPE');

828: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
829: p_token_name(1) := 'VALUE';
830: p_token_value(1) := p_person_type_id;
831: p_token_name(2) := 'FIELD';
832: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PERSON_TYPE');
833:
834: IF g_debug THEN
835: pay_in_utils.trace('p_message_name ',p_message_name);
836: END IF;

Line 870: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PERSON_TYPE');

866: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
867: p_token_name(1) := 'VALUE';
868: p_token_value(1) := p_person_type_id;
869: p_token_name(2) := 'FIELD';
870: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PERSON_TYPE');
871:
872: IF g_debug THEN
873: pay_in_utils.trace('**************************************************','********************');
874: pay_in_utils.trace('p_message_name ',p_message_name);

Line 927: l_value := hr_general.decode_lookup('YES_NO',p_pan_af);

923: --
924: -- Check valid value from lookup
925:
926: IF (p_pan_af IS NOT NULL )THEN
927: l_value := hr_general.decode_lookup('YES_NO',p_pan_af);
928: IF l_value IS NULL THEN
929:
930: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
931: p_token_name(1) := 'VALUE';

Line 934: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_AF');

930: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
931: p_token_name(1) := 'VALUE';
932: p_token_value(1) := p_pan_af;
933: p_token_name(2) := 'FIELD';
934: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_AF');
935:
936: IF g_debug THEN
937: pay_in_utils.trace('**************************************************','********************');
938: pay_in_utils.trace('p_message_name ',p_message_name);

Line 950: l_value := hr_general.decode_lookup('YES_NO',p_military_status);

946:
947:
948:
949: IF (p_military_status IS NOT NULL )THEN
950: l_value := hr_general.decode_lookup('YES_NO',p_military_status);
951: IF l_value IS NULL THEN
952:
953: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
954: p_token_name(1) := 'VALUE';

Line 957: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','EX_SERVICE');

953: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
954: p_token_name(1) := 'VALUE';
955: p_token_value(1) := p_military_status;
956: p_token_name(2) := 'FIELD';
957: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','EX_SERVICE');
958:
959: IF g_debug THEN
960: pay_in_utils.trace('**************************************************','********************');
961: pay_in_utils.trace('p_message_name ',p_message_name);

Line 971: l_value := hr_general.decode_lookup('IN_RESIDENTIAL_STATUS',p_resident_status);

967: END IF;
968: END IF;
969:
970:
971: l_value := hr_general.decode_lookup('IN_RESIDENTIAL_STATUS',p_resident_status);
972:
973: IF l_value IS NULL THEN
974: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
975: p_token_name(1) := 'VALUE';

Line 978: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','RESIDENTIAL_STATUS');

974: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
975: p_token_name(1) := 'VALUE';
976: p_token_value(1) := p_resident_status;
977: p_token_name(2) := 'FIELD';
978: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','RESIDENTIAL_STATUS');
979:
980: IF g_debug THEN
981: pay_in_utils.trace('**************************************************','********************');
982: pay_in_utils.trace('p_message_name ',p_message_name);

Line 1019: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN');

1015: -- Check for the NSSN Format
1016: IF NOT length(p_NSSN) = 14 THEN
1017: p_message_name := 'PER_IN_INVALID_FORMAT';
1018: p_token_name(1) := 'FIELD';
1019: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN');
1020: p_token_name(2) := 'FORMAT';
1021: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');
1022: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1023:

Line 1021: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');

1017: p_message_name := 'PER_IN_INVALID_FORMAT';
1018: p_token_name(1) := 'FIELD';
1019: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN');
1020: p_token_name(2) := 'FORMAT';
1021: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');
1022: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1023:
1024: IF g_debug THEN
1025: pay_in_utils.trace('**************************************************','********************');

Line 1035: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN');

1031: END IF;
1032: IF instr(p_NSSN,'.') > 0 THEN
1033: p_message_name := 'PER_IN_INVALID_FORMAT';
1034: p_token_name(1) := 'FIELD';
1035: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN');
1036: p_token_name(2) := 'FORMAT';
1037: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');
1038: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1039:

Line 1037: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');

1033: p_message_name := 'PER_IN_INVALID_FORMAT';
1034: p_token_name(1) := 'FIELD';
1035: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN');
1036: p_token_name(2) := 'FORMAT';
1037: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');
1038: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1039:
1040: IF g_debug THEN
1041: pay_in_utils.trace('**************************************************','********************');