DBA Data[Home] [Help]

APPS.PER_IN_ORG_INFO_LEG_HOOK dependencies on HR_GENERAL

Line 351: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','REG_CERT_NO');

347: pay_in_utils.trace('Check valid value from lookup=>Registraion Certificate number',NULL);
348: END IF;
349: p_message_name := 'PER_IN_DUPLICATE_VALUES';
350: p_token_name(1) := 'FIELD';
351: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','REG_CERT_NO');
352: IF g_debug THEN
353: pay_in_utils.trace('**************************************************','********************');
354: pay_in_utils.trace('p_message_name',p_message_name);
355: pay_in_utils.trace('**************************************************','********************');

Line 372: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','LICENSE_NO');

368: pay_in_utils.trace('Check valid value from lookup=>license number',NULL);
369: END IF;
370: p_message_name := 'PER_IN_DUPLICATE_VALUES';
371: p_token_name(1) := 'FIELD';
372: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','LICENSE_NO');
373: IF g_debug THEN
374: pay_in_utils.trace('**************************************************','********************');
375: pay_in_utils.trace('p_message_name',p_message_name);
376: pay_in_utils.trace('**************************************************','********************');

Line 396: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','PF_NO');

392: p_message_name := 'PER_IN_DUPLICATE_VALUES';
393: -- p_token_name(1) := 'VALUE';
394: -- p_token_value(1):= p_org_information3;
395: p_token_name(1) := 'FIELD';
396: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','PF_NO');
397: IF g_debug THEN
398: pay_in_utils.trace('**************************************************','********************');
399: pay_in_utils.trace('p_message_name',p_message_name);
400: pay_in_utils.trace('**************************************************','********************');

Line 420: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','ESI_NO');

416: pay_in_utils.trace('Check valid value from lookup=>ESI number',NULL);
417: END IF;
418: p_message_name := 'PER_IN_DUPLICATE_VALUES';
419: p_token_name(1) := 'FIELD';
420: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','ESI_NO');
421: IF g_debug THEN
422: pay_in_utils.trace('**************************************************','********************');
423: pay_in_utils.trace('p_message_name',p_message_name);
424: pay_in_utils.trace('**************************************************','********************');

Line 468: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_NO');

464: pay_in_utils.trace('Check valid value from lookup=>PAN number',NULL);
465: END IF;
466: p_message_name := 'PER_IN_DUPLICATE_VALUES';
467: p_token_name(1) := 'FIELD';
468: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_NO');
469: IF g_debug THEN
470: pay_in_utils.trace('**************************************************','********************');
471: pay_in_utils.trace('p_message_name',p_message_name);
472: pay_in_utils.trace('**************************************************','********************');

Line 496: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','ARCH_REF_NUM');

492: pay_in_utils.trace('Check valid value for Archive Ref Number',NULL);
493: END IF;
494: p_message_name := 'PER_IN_NON_UNIQUE_VALUE';
495: p_token_name(1) := 'NUMBER_CATEGORY';
496: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','ARCH_REF_NUM');
497: IF g_debug THEN
498: pay_in_utils.trace('**************************************************','********************');
499: pay_in_utils.trace('p_message_name',p_message_name);
500: pay_in_utils.trace('**************************************************','********************');

Line 518: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','RCPT_NUMBER');

514: pay_in_utils.trace('Check valid Receipt Number',NULL);
515: END IF;
516: p_message_name := 'PER_IN_NON_UNIQUE_VALUE';
517: p_token_name(1) := 'NUMBER_CATEGORY';
518: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','RCPT_NUMBER');
519: IF g_debug THEN
520: pay_in_utils.trace('**************************************************','********************');
521: pay_in_utils.trace('p_message_name',p_message_name);
522: pay_in_utils.trace('**************************************************','********************');

Line 566: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','BASE_BUSINESS_NUM');

562: pay_in_utils.trace('Check valid value for Business Number',NULL);
563: END IF;
564: p_message_name := 'PER_IN_NON_UNIQUE_VALUE';
565: p_token_name(1) := 'NUMBER_CATEGORY';
566: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','BASE_BUSINESS_NUM');
567: IF g_debug THEN
568: pay_in_utils.trace('**************************************************','********************');
569: pay_in_utils.trace('p_message_name',p_message_name);
570: pay_in_utils.trace('**************************************************','********************');

Line 611: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','PF_CHALLAN_NO');

607: pay_in_utils.trace('Check valid value for Challan Reference Number for'|| p_org_info_type_code,NULL);
608: END IF;
609: p_message_name := 'PER_IN_NON_UNIQUE_VALUE';
610: p_token_name(1) := 'NUMBER_CATEGORY';
611: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','PF_CHALLAN_NO');
612: IF g_debug THEN
613: pay_in_utils.trace('**************************************************','********************');
614: pay_in_utils.trace('p_message_name',p_message_name);
615: pay_in_utils.trace('**************************************************','********************');

Line 634: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','DD_CHQ_NO');

630: pay_in_utils.trace('Check valid value for Cheque/ DD Number',NULL);
631: END IF;
632: p_message_name := 'PER_IN_NON_UNIQUE_VALUE';
633: p_token_name(1) := 'NUMBER_CATEGORY';
634: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','DD_CHQ_NO');
635: IF g_debug THEN
636: pay_in_utils.trace('**************************************************','********************');
637: pay_in_utils.trace('p_message_name',p_message_name);
638: pay_in_utils.trace('**************************************************','********************');

Line 875: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','REG_CERT_NO');

871: pay_in_utils.trace('Check valid value from lookup=>Registraion Certificate number',NULL);
872: END IF;
873: p_message_name := 'PER_IN_DUPLICATE_VALUES';
874: p_token_name(1) := 'FIELD';
875: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','REG_CERT_NO');
876: IF g_debug THEN
877: pay_in_utils.trace('**************************************************','********************');
878: pay_in_utils.trace('p_message_name',p_message_name);
879: pay_in_utils.trace('**************************************************','********************');

Line 896: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','LICENSE_NO');

892: pay_in_utils.trace('Check valid value from lookup=>license number',NULL);
893: END IF;
894: p_message_name := 'PER_IN_DUPLICATE_VALUES';
895: p_token_name(1) := 'FIELD';
896: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','LICENSE_NO');
897: IF g_debug THEN
898: pay_in_utils.trace('**************************************************','********************');
899: pay_in_utils.trace('p_message_name',p_message_name);
900: pay_in_utils.trace('**************************************************','********************');

Line 918: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','PF_NO');

914: pay_in_utils.trace('Check valid value from lookup=>PF Number',NULL);
915: END IF;
916: p_message_name := 'PER_IN_DUPLICATE_VALUES';
917: p_token_name(1) := 'FIELD';
918: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','PF_NO');
919: IF g_debug THEN
920: pay_in_utils.trace('**************************************************','********************');
921: pay_in_utils.trace('p_message_name',p_message_name);
922: pay_in_utils.trace('**************************************************','********************');

Line 942: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','ESI_NO');

938: pay_in_utils.trace('Check valid value from lookup=>ESI number',NULL);
939: END IF;
940: p_message_name := 'PER_IN_DUPLICATE_VALUES';
941: p_token_name(1) := 'FIELD';
942: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','ESI_NO');
943: IF g_debug THEN
944: pay_in_utils.trace('**************************************************','********************');
945: pay_in_utils.trace('p_message_name',p_message_name);
946: pay_in_utils.trace('**************************************************','********************');

Line 990: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_NO');

986: pay_in_utils.trace('Check valid value from lookup=>PAN number',NULL);
987: END IF;
988: p_message_name := 'PER_IN_DUPLICATE_VALUES';
989: p_token_name(1) := 'FIELD';
990: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_NO');
991: IF g_debug THEN
992: pay_in_utils.trace('**************************************************','********************');
993: pay_in_utils.trace('p_message_name',p_message_name);
994: pay_in_utils.trace('**************************************************','********************');

Line 1016: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','ARCH_REF_NUM');

1012: /* Check for Request Id */
1013: IF l_ref_num = 'X' THEN
1014: p_message_name := 'PER_IN_NON_UNIQUE_VALUE';
1015: p_token_name(1) := 'NUMBER_CATEGORY';
1016: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','ARCH_REF_NUM');
1017: IF g_debug THEN
1018: pay_in_utils.trace('**************************************************','********************');
1019: pay_in_utils.trace('p_message_name',p_message_name);
1020: pay_in_utils.trace('**************************************************','********************');

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

1031:
1032: IF l_receipt_num = 'X' THEN
1033: p_message_name := 'PER_IN_NON_UNIQUE_VALUE';
1034: p_token_name(1) := 'NUMBER_CATEGORY';
1035: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','RCPT_NUMBER');
1036: IF g_debug THEN
1037: pay_in_utils.trace('**************************************************','********************');
1038: pay_in_utils.trace('p_message_name',p_message_name);
1039: pay_in_utils.trace('**************************************************','********************');

Line 1083: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','BASE_BUSINESS_NUM');

1079: pay_in_utils.trace('Check valid value for Base Business Number',NULL);
1080: END IF;
1081: p_message_name := 'PER_IN_NON_UNIQUE_VALUE';
1082: p_token_name(1) := 'NUMBER_CATEGORY';
1083: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','BASE_BUSINESS_NUM');
1084: IF g_debug THEN
1085: pay_in_utils.trace('**************************************************','********************');
1086: pay_in_utils.trace('p_message_name',p_message_name);
1087: pay_in_utils.trace('**************************************************','********************');

Line 1126: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','PF_CHALLAN_NO');

1122: pay_in_utils.trace('Check valid value for Challan Reference Number for'|| p_org_info_type_code,NULL);
1123: END IF;
1124: p_message_name := 'PER_IN_NON_UNIQUE_VALUE';
1125: p_token_name(1) := 'NUMBER_CATEGORY';
1126: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','PF_CHALLAN_NO');
1127: IF g_debug THEN
1128: pay_in_utils.trace('**************************************************','********************');
1129: pay_in_utils.trace('p_message_name',p_message_name);
1130: pay_in_utils.trace('**************************************************','********************');

Line 1149: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','DD_CHQ_NO');

1145: pay_in_utils.trace('Check valid value for Cheque/ DD Number',NULL);
1146: END IF;
1147: p_message_name := 'PER_IN_NON_UNIQUE_VALUE';
1148: p_token_name(1) := 'NUMBER_CATEGORY';
1149: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','DD_CHQ_NO');
1150: IF g_debug THEN
1151: pay_in_utils.trace('**************************************************','********************');
1152: pay_in_utils.trace('p_message_name',p_message_name);
1153: pay_in_utils.trace('**************************************************','********************');

Line 1297: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','CORP_ID_NO');

1293: p_message_name := 'PER_IN_ALPHANUMERIC_VALUE';
1294: p_token_name(1) := 'VALUE';
1295: p_token_value(1) := p_org_information2;
1296: p_token_name(2) := 'FIELD';
1297: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','CORP_ID_NO');
1298: IF g_debug THEN
1299: pay_in_utils.trace('**************************************************','********************');
1300: pay_in_utils.trace('p_message_name',p_message_name);
1301: pay_in_utils.trace('**************************************************','********************');

Line 3060: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','CHALLAN_BANK');

3056: IF (p_org_information5 IS NOT NULL) THEN
3057: -- For transfer through book entry, do not enter Challan bank
3058: p_message_name:='PER_IN_BOOK_ENTRY';
3059: p_token_name(1) := 'FIELD';
3060: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','CHALLAN_BANK');
3061: IF g_debug THEN
3062: pay_in_utils.trace('**************************************************','********************');
3063: pay_in_utils.trace('p_message_name',p_message_name);
3064: pay_in_utils.trace('**************************************************','********************');

Line 3072: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','DD_CHQ_NO');

3068: ELSIF (p_org_information11 IS NOT NULL) THEN
3069: -- For transfer through book entry, do not enter DD/Cheque number
3070: p_message_name:='PER_IN_BOOK_ENTRY';
3071: p_token_name(1) := 'FIELD';
3072: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','DD_CHQ_NO');
3073: IF g_debug THEN
3074: pay_in_utils.trace('**************************************************','********************');
3075: pay_in_utils.trace('p_message_name',p_message_name);
3076: pay_in_utils.trace('**************************************************','********************');

Line 3087: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','CHALLAN_BANK');

3083: IF (p_org_information5 IS NULL ) THEN
3084: -- For payment through challans, Challan bank and DD/Cheque number is mandatory
3085: p_message_name:='PER_IN_CHALLAN_DETAILS';
3086: p_token_name(1) := 'FIELD';
3087: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','CHALLAN_BANK');
3088: IF g_debug THEN
3089: pay_in_utils.trace('**************************************************','********************');
3090: pay_in_utils.trace('p_message_name',p_message_name);
3091: pay_in_utils.trace('**************************************************','********************');

Line 3099: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','DD_CHQ_NO');

3095: ELSIF (p_org_information11 IS NULL) THEN
3096: -- For payment through challans, Challan bank and DD/Cheque number is mandatory
3097: p_message_name:='PER_IN_CHALLAN_DETAILS';
3098: p_token_name(1) := 'FIELD';
3099: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','DD_CHQ_NO');
3100: IF g_debug THEN
3101: pay_in_utils.trace('**************************************************','********************');
3102: pay_in_utils.trace('p_message_name',p_message_name);
3103: pay_in_utils.trace('**************************************************','********************');

Line 3287: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BASE_BUSINESS_NUM');

3283: THEN
3284: IF p_org_information9 IS NULL THEN
3285: p_message_name := 'PER_IN_PF_BUSINESS_NUMBER';
3286: p_token_name(1) := 'FIELD1';
3287: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BASE_BUSINESS_NUM');
3288: p_token_name(2) := 'FIELD2';
3289: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BUSINESS_NUMBER');
3290: ELSIF p_org_information10 IS NULL THEN
3291: p_message_name := 'PER_IN_PF_BUSINESS_NUMBER';

Line 3289: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BUSINESS_NUMBER');

3285: p_message_name := 'PER_IN_PF_BUSINESS_NUMBER';
3286: p_token_name(1) := 'FIELD1';
3287: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BASE_BUSINESS_NUM');
3288: p_token_name(2) := 'FIELD2';
3289: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BUSINESS_NUMBER');
3290: ELSIF p_org_information10 IS NULL THEN
3291: p_message_name := 'PER_IN_PF_BUSINESS_NUMBER';
3292: p_token_name(1) := 'FIELD1';
3293: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BUSINESS_NUMBER');

Line 3293: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BUSINESS_NUMBER');

3289: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BUSINESS_NUMBER');
3290: ELSIF p_org_information10 IS NULL THEN
3291: p_message_name := 'PER_IN_PF_BUSINESS_NUMBER';
3292: p_token_name(1) := 'FIELD1';
3293: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BUSINESS_NUMBER');
3294: p_token_name(2) := 'FIELD2';
3295: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BASE_BUSINESS_NUM');
3296: END IF;
3297: IF g_debug THEN

Line 3295: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BASE_BUSINESS_NUM');

3291: p_message_name := 'PER_IN_PF_BUSINESS_NUMBER';
3292: p_token_name(1) := 'FIELD1';
3293: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BUSINESS_NUMBER');
3294: p_token_name(2) := 'FIELD2';
3295: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BASE_BUSINESS_NUM');
3296: END IF;
3297: IF g_debug THEN
3298: pay_in_utils.trace('*******VALIDATION OF BASE BUSINESS NUMBER AND BUSINESS NUMBER ******','********************');
3299: pay_in_utils.trace('**************************************************','********************');