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 517: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');

513: -- Check for the length
514: IF NOT length(p_pan) = 10 THEN
515: p_message_name := 'PER_IN_INVALID_FORMAT';
516: p_token_name(1) := 'FIELD';
517: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
518: p_token_name(2) := 'FORMAT';
519: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
520: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
521:

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

515: p_message_name := 'PER_IN_INVALID_FORMAT';
516: p_token_name(1) := 'FIELD';
517: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
518: p_token_name(2) := 'FORMAT';
519: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
520: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
521:
522: IF g_debug THEN
523: pay_in_utils.trace('**************************************************','********************');

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

539: -- Check for the numeric part.
540: IF NOT ascii(substr(l_char6_9_string, l_count, 1) ) BETWEEN ASCII('0') AND ASCII('9') THEN
541: p_message_name := 'PER_IN_INVALID_FORMAT';
542: p_token_name(1) := 'FIELD';
543: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
544: p_token_name(2) := 'FORMAT';
545: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
546:
547: IF g_debug THEN

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

541: p_message_name := 'PER_IN_INVALID_FORMAT';
542: p_token_name(1) := 'FIELD';
543: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
544: p_token_name(2) := 'FORMAT';
545: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
546:
547: IF g_debug THEN
548: pay_in_utils.trace('**************************************************','********************');
549: pay_in_utils.trace('p_message_name ',p_message_name);

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

558: EXCEPTION
559: WHEN OTHERS THEN
560: p_message_name := 'PER_IN_INVALID_FORMAT';
561: p_token_name(1) := 'FIELD';
562: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
563: p_token_name(2) := 'FORMAT';
564: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
565:
566: IF g_debug THEN

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

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

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

578: l_char_string := substr(p_pan, 10, 1) ;
579: IF NOT ascii(l_char_string) BETWEEN ASCII('A') AND ASCII('Z') THEN
580: p_message_name := 'PER_IN_INVALID_FORMAT';
581: p_token_name(1) := 'FIELD';
582: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
583: p_token_name(2) := 'FORMAT';
584: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
585:
586: IF g_debug THEN

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

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

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

599: -- Check for the first 5 alphabats
600: IF NOT ascii( substr(l_char_string, l_count, 1) ) BETWEEN ASCII('A') AND ASCII('Z') THEN
601: p_message_name := 'PER_IN_INVALID_FORMAT';
602: p_token_name(1) := 'FIELD';
603: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
604: p_token_name(2) := 'FORMAT';
605: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
606:
607: IF g_debug THEN

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

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

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

618: --Checks that either the PAN field or the PAN Applied For field is null.
619: IF p_pan IS NOT NULL AND p_pan_af IS NOT NULL THEN
620: p_message_name := 'PER_IN_TWO_FIELD_MISMATCH';
621: p_token_name(1) := 'FIELD1';
622: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
623: p_token_name(2) := 'FIELD2';
624: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_AF');
625:
626: IF g_debug THEN

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

620: p_message_name := 'PER_IN_TWO_FIELD_MISMATCH';
621: p_token_name(1) := 'FIELD1';
622: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
623: p_token_name(2) := 'FIELD2';
624: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_AF');
625:
626: IF g_debug THEN
627: pay_in_utils.trace('**************************************************','********************');
628: pay_in_utils.trace('p_message_name ',p_message_name);

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

636: --Checks that either the PAN field or the PAN Ref Number For field is null.
637: IF p_pan IS NOT NULL AND p_panref_number IS NOT NULL THEN
638: p_message_name := 'PER_IN_TWO_FIELD_MISMATCH';
639: p_token_name(1) := 'FIELD1';
640: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
641: p_token_name(2) := 'FIELD2';
642: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_REF');
643:
644: IF g_debug THEN

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

638: p_message_name := 'PER_IN_TWO_FIELD_MISMATCH';
639: p_token_name(1) := 'FIELD1';
640: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
641: p_token_name(2) := 'FIELD2';
642: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_REF');
643:
644: IF g_debug THEN
645: pay_in_utils.trace('**************************************************','********************');
646: pay_in_utils.trace('p_message_name ',p_message_name);

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

806: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
807: p_token_name(1) := 'VALUE';
808: p_token_value(1) := p_person_type_id;
809: p_token_name(2) := 'FIELD';
810: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PERSON_TYPE');
811:
812: IF g_debug THEN
813: pay_in_utils.trace('p_message_name ',p_message_name);
814: END IF;

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

844: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
845: p_token_name(1) := 'VALUE';
846: p_token_value(1) := p_person_type_id;
847: p_token_name(2) := 'FIELD';
848: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PERSON_TYPE');
849:
850: IF g_debug THEN
851: pay_in_utils.trace('**************************************************','********************');
852: pay_in_utils.trace('p_message_name ',p_message_name);

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

901: --
902: -- Check valid value from lookup
903:
904: IF (p_pan_af IS NOT NULL )THEN
905: l_value := hr_general.decode_lookup('YES_NO',p_pan_af);
906: IF l_value IS NULL THEN
907:
908: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
909: p_token_name(1) := 'VALUE';

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

908: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
909: p_token_name(1) := 'VALUE';
910: p_token_value(1) := p_pan_af;
911: p_token_name(2) := 'FIELD';
912: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_AF');
913:
914: IF g_debug THEN
915: pay_in_utils.trace('**************************************************','********************');
916: pay_in_utils.trace('p_message_name ',p_message_name);

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

924:
925:
926:
927: IF (p_military_status IS NOT NULL )THEN
928: l_value := hr_general.decode_lookup('YES_NO',p_military_status);
929: IF l_value IS NULL THEN
930:
931: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
932: p_token_name(1) := 'VALUE';

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

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

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

945: END IF;
946: END IF;
947:
948:
949: l_value := hr_general.decode_lookup('IN_RESIDENTIAL_STATUS',p_resident_status);
950:
951: IF l_value IS NULL THEN
952: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
953: p_token_name(1) := 'VALUE';

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

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

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

993: -- Check for the NSSN Format
994: IF NOT length(p_NSSN) = 14 THEN
995: p_message_name := 'PER_IN_INVALID_FORMAT';
996: p_token_name(1) := 'FIELD';
997: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN');
998: p_token_name(2) := 'FORMAT';
999: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');
1000: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1001:

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

995: p_message_name := 'PER_IN_INVALID_FORMAT';
996: p_token_name(1) := 'FIELD';
997: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN');
998: p_token_name(2) := 'FORMAT';
999: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');
1000: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1001:
1002: IF g_debug THEN
1003: pay_in_utils.trace('**************************************************','********************');

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

1009: END IF;
1010: IF instr(p_NSSN,'.') > 0 THEN
1011: p_message_name := 'PER_IN_INVALID_FORMAT';
1012: p_token_name(1) := 'FIELD';
1013: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN');
1014: p_token_name(2) := 'FORMAT';
1015: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');
1016: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1017:

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

1011: p_message_name := 'PER_IN_INVALID_FORMAT';
1012: p_token_name(1) := 'FIELD';
1013: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN');
1014: p_token_name(2) := 'FORMAT';
1015: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');
1016: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1017:
1018: IF g_debug THEN
1019: pay_in_utils.trace('**************************************************','********************');