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 1516: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);

1512: p_token_value(1) := l_pao_ddo_code;
1513: p_token_name(2) := 'TOKEN2';
1514: p_token_value(2) := 'Employer Classification for Form 24Q/QC';
1515: p_token_name(3) := 'TOKEN3';
1516: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);
1517:
1518: IF g_debug THEN
1519: pay_in_utils.trace('**************************************************','********************');
1520: pay_in_utils.trace('p_message_name',p_message_name);

Line 1547: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);

1543: p_token_value(1) := l_pao_ddo_code;
1544: p_token_name(2) := 'TOKEN2';
1545: p_token_value(2) := 'Employer Classification for Form 24Q/QC';
1546: p_token_name(3) := 'TOKEN3';
1547: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);
1548:
1549: IF g_debug THEN
1550: pay_in_utils.trace('**************************************************','********************');
1551: pay_in_utils.trace('p_message_name',p_message_name);

Line 1569: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);

1565: p_token_value(1) := 'Ministry Name';
1566: p_token_name(2) := 'TOKEN2';
1567: p_token_value(2) := 'Employer Classification for Form 24Q/QC';
1568: p_token_name(3) := 'TOKEN3';
1569: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);
1570: IF g_debug THEN
1571: pay_in_utils.trace('**************************************************','********************');
1572: pay_in_utils.trace('p_message_name',p_message_name);
1573: pay_in_utils.trace('**************************************************','********************');

Line 1585: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);

1581: p_token_value(1) := 'Ministry Name';
1582: p_token_name(2) := 'TOKEN2';
1583: p_token_value(2) := 'Employer Classification for Form 24Q/QC';
1584: p_token_name(3) := 'TOKEN3';
1585: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);
1586: IF g_debug THEN
1587: pay_in_utils.trace('**************************************************','********************');
1588: pay_in_utils.trace('p_message_name',p_message_name);
1589: pay_in_utils.trace('**************************************************','********************');

Line 1607: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);

1603: p_token_value(1) := 'State';
1604: p_token_name(2) := 'TOKEN2';
1605: p_token_value(2) := 'Employer Classification for Form 24Q/QC';
1606: p_token_name(3) := 'TOKEN3';
1607: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);
1608: IF g_debug THEN
1609: pay_in_utils.trace('**************************************************','********************');
1610: pay_in_utils.trace('p_message_name',p_message_name);
1611: pay_in_utils.trace('**************************************************','********************');

Line 1624: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);

1620: p_token_value(1) := 'State';
1621: p_token_name(2) := 'TOKEN2';
1622: p_token_value(2) := 'Employer Classification for Form 24Q/QC';
1623: p_token_name(3) := 'TOKEN3';
1624: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);
1625: IF g_debug THEN
1626: pay_in_utils.trace('**************************************************','********************');
1627: pay_in_utils.trace('p_message_name',p_message_name);
1628: pay_in_utils.trace('**************************************************','********************');

Line 1990: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);

1986: p_token_value(1) := l_pao_ddo_code;
1987: p_token_name(2) := 'TOKEN2';
1988: p_token_value(2) := 'Employer Classification for Form 24Q/QC';
1989: p_token_name(3) := 'TOKEN3';
1990: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);
1991:
1992: IF g_debug THEN
1993: pay_in_utils.trace('**************************************************','********************');
1994: pay_in_utils.trace('p_message_name',p_message_name);

Line 2021: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);

2017: p_token_value(1) := l_pao_ddo_code;
2018: p_token_name(2) := 'TOKEN2';
2019: p_token_value(2) := 'Employer Classification for Form 24Q/QC';
2020: p_token_name(3) := 'TOKEN3';
2021: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);
2022:
2023: IF g_debug THEN
2024: pay_in_utils.trace('**************************************************','********************');
2025: pay_in_utils.trace('p_message_name',p_message_name||l_pao_ddo_code);

Line 2043: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);

2039: p_token_value(1) := 'Ministry Name';
2040: p_token_name(2) := 'TOKEN2';
2041: p_token_value(2) := 'Employer Classification for Form 24Q/QC';
2042: p_token_name(3) := 'TOKEN3';
2043: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);
2044: IF g_debug THEN
2045: pay_in_utils.trace('**************************************************','********************');
2046: pay_in_utils.trace('p_message_name',p_message_name);
2047: pay_in_utils.trace('**************************************************','********************');

Line 2060: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);

2056: p_token_value(1) := 'Ministry Name';
2057: p_token_name(2) := 'TOKEN2';
2058: p_token_value(2) := 'Employer Classification for Form 24Q/QC';
2059: p_token_name(3) := 'TOKEN3';
2060: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);
2061: IF g_debug THEN
2062: pay_in_utils.trace('**************************************************','********************');
2063: pay_in_utils.trace('p_message_name',p_message_name);
2064: pay_in_utils.trace('**************************************************','********************');

Line 2082: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);

2078: p_token_value(1) := 'State';
2079: p_token_name(2) := 'TOKEN2';
2080: p_token_value(2) := 'Employer Classification for Form 24Q/QC';
2081: p_token_name(3) := 'TOKEN3';
2082: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);
2083: IF g_debug THEN
2084: pay_in_utils.trace('**************************************************','********************');
2085: pay_in_utils.trace('p_message_name',p_message_name);
2086: pay_in_utils.trace('**************************************************','********************');

Line 2099: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);

2095: p_token_value(1) := 'State';
2096: p_token_name(2) := 'TOKEN2';
2097: p_token_value(2) := 'Employer Classification for Form 24Q/QC';
2098: p_token_name(3) := 'TOKEN3';
2099: p_token_value(3) := hr_general.decode_lookup('IN_24Q_ER_CLASS',p_org_information6);
2100: IF g_debug THEN
2101: pay_in_utils.trace('**************************************************','********************');
2102: pay_in_utils.trace('p_message_name',p_message_name);
2103: pay_in_utils.trace('**************************************************','********************');

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

3446: IF (p_org_information5 IS NOT NULL) THEN
3447: -- For transfer through book entry, do not enter Challan bank
3448: p_message_name:='PER_IN_BOOK_ENTRY';
3449: p_token_name(1) := 'FIELD';
3450: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','CHALLAN_BANK');
3451: IF g_debug THEN
3452: pay_in_utils.trace('**************************************************','********************');
3453: pay_in_utils.trace('p_message_name',p_message_name);
3454: pay_in_utils.trace('**************************************************','********************');

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

3458: ELSIF (p_org_information11 IS NOT NULL) THEN
3459: -- For transfer through book entry, do not enter DD/Cheque number
3460: p_message_name:='PER_IN_BOOK_ENTRY';
3461: p_token_name(1) := 'FIELD';
3462: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','DD_CHQ_NO');
3463: IF g_debug THEN
3464: pay_in_utils.trace('**************************************************','********************');
3465: pay_in_utils.trace('p_message_name',p_message_name);
3466: pay_in_utils.trace('**************************************************','********************');

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

3473: IF (p_org_information5 IS NULL ) THEN
3474: -- For payment through challans, Challan bank and DD/Cheque number is mandatory
3475: p_message_name:='PER_IN_CHALLAN_DETAILS';
3476: p_token_name(1) := 'FIELD';
3477: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','CHALLAN_BANK');
3478: IF g_debug THEN
3479: pay_in_utils.trace('**************************************************','********************');
3480: pay_in_utils.trace('p_message_name',p_message_name);
3481: pay_in_utils.trace('**************************************************','********************');

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

3485: ELSIF (p_org_information11 IS NULL) THEN
3486: -- For payment through challans, Challan bank and DD/Cheque number is mandatory
3487: p_message_name:='PER_IN_CHALLAN_DETAILS';
3488: p_token_name(1) := 'FIELD';
3489: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','DD_CHQ_NO');
3490: IF g_debug THEN
3491: pay_in_utils.trace('**************************************************','********************');
3492: pay_in_utils.trace('p_message_name',p_message_name);
3493: pay_in_utils.trace('**************************************************','********************');

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

3673: THEN
3674: IF p_org_information9 IS NULL THEN
3675: p_message_name := 'PER_IN_PF_BUSINESS_NUMBER';
3676: p_token_name(1) := 'FIELD1';
3677: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BASE_BUSINESS_NUM');
3678: p_token_name(2) := 'FIELD2';
3679: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BUSINESS_NUMBER');
3680: ELSIF p_org_information10 IS NULL THEN
3681: p_message_name := 'PER_IN_PF_BUSINESS_NUMBER';

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

3675: p_message_name := 'PER_IN_PF_BUSINESS_NUMBER';
3676: p_token_name(1) := 'FIELD1';
3677: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BASE_BUSINESS_NUM');
3678: p_token_name(2) := 'FIELD2';
3679: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BUSINESS_NUMBER');
3680: ELSIF p_org_information10 IS NULL THEN
3681: p_message_name := 'PER_IN_PF_BUSINESS_NUMBER';
3682: p_token_name(1) := 'FIELD1';
3683: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BUSINESS_NUMBER');

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

3679: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BUSINESS_NUMBER');
3680: ELSIF p_org_information10 IS NULL THEN
3681: p_message_name := 'PER_IN_PF_BUSINESS_NUMBER';
3682: p_token_name(1) := 'FIELD1';
3683: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BUSINESS_NUMBER');
3684: p_token_name(2) := 'FIELD2';
3685: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BASE_BUSINESS_NUM');
3686: END IF;
3687: IF g_debug THEN

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

3681: p_message_name := 'PER_IN_PF_BUSINESS_NUMBER';
3682: p_token_name(1) := 'FIELD1';
3683: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BUSINESS_NUMBER');
3684: p_token_name(2) := 'FIELD2';
3685: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','BASE_BUSINESS_NUM');
3686: END IF;
3687: IF g_debug THEN
3688: pay_in_utils.trace('*******VALIDATION OF BASE BUSINESS NUMBER AND BUSINESS NUMBER ******','********************');
3689: pay_in_utils.trace('**************************************************','********************');