DBA Data[Home] [Help]

APPS.PAY_FR_GENERAL dependencies on FND_MESSAGE

Line 248: fnd_message.set_name('PAY','PAY_74938_SD_NO_BASE_DUCT_GRP');

244: return l_base_type;
245:
246: exception
247: when no_data_found then
248: fnd_message.set_name('PAY','PAY_74938_SD_NO_BASE_DUCT_GRP');
249: fnd_message.set_token('DEDUCTION_GROUP',p_group_code);
250: fnd_message.raise_error;
251: end get_base_name;
252: ------------------------------------------------------------------------

Line 249: fnd_message.set_token('DEDUCTION_GROUP',p_group_code);

245:
246: exception
247: when no_data_found then
248: fnd_message.set_name('PAY','PAY_74938_SD_NO_BASE_DUCT_GRP');
249: fnd_message.set_token('DEDUCTION_GROUP',p_group_code);
250: fnd_message.raise_error;
251: end get_base_name;
252: ------------------------------------------------------------------------
253: -- Function GET_BASE_NAME_CU

Line 250: fnd_message.raise_error;

246: exception
247: when no_data_found then
248: fnd_message.set_name('PAY','PAY_74938_SD_NO_BASE_DUCT_GRP');
249: fnd_message.set_token('DEDUCTION_GROUP',p_group_code);
250: fnd_message.raise_error;
251: end get_base_name;
252: ------------------------------------------------------------------------
253: -- Function GET_BASE_NAME_CU
254: -- This function will be used to determine the name of a base

Line 283: fnd_message.set_name('PAY','PAY_74938_SD_NO_BASE_DUCT_GRP');

279: hr_utility.set_location('Leaving '||l_proc,25);
280: return l_base_type;
281: exception
282: when no_data_found then
283: fnd_message.set_name('PAY','PAY_74938_SD_NO_BASE_DUCT_GRP');
284: fnd_message.set_token('DEDUCTION_GROUP',l_group_code);
285: fnd_message.raise_error;
286: end get_base_name_CU;
287: ------------------------------------------------------------------------

Line 284: fnd_message.set_token('DEDUCTION_GROUP',l_group_code);

280: return l_base_type;
281: exception
282: when no_data_found then
283: fnd_message.set_name('PAY','PAY_74938_SD_NO_BASE_DUCT_GRP');
284: fnd_message.set_token('DEDUCTION_GROUP',l_group_code);
285: fnd_message.raise_error;
286: end get_base_name_CU;
287: ------------------------------------------------------------------------
288: -- Function GET_GROUP_CODE

Line 285: fnd_message.raise_error;

281: exception
282: when no_data_found then
283: fnd_message.set_name('PAY','PAY_74938_SD_NO_BASE_DUCT_GRP');
284: fnd_message.set_token('DEDUCTION_GROUP',l_group_code);
285: fnd_message.raise_error;
286: end get_base_name_CU;
287: ------------------------------------------------------------------------
288: -- Function GET_GROUP_CODE
289: -- This function will be used to determine the group code of a given

Line 336: fnd_message.set_name('PAY','PAY_74937_SD_NO_BASE_VALUE');

332:
333: return l_base_value;
334: exception
335: when no_data_found then
336: fnd_message.set_name('PAY','PAY_74937_SD_NO_BASE_VALUE');
337: fnd_message.set_token('TYPE',p_base_type);
338: fnd_message.raise_error;
339:
340: end get_base_value;

Line 337: fnd_message.set_token('TYPE',p_base_type);

333: return l_base_value;
334: exception
335: when no_data_found then
336: fnd_message.set_name('PAY','PAY_74937_SD_NO_BASE_VALUE');
337: fnd_message.set_token('TYPE',p_base_type);
338: fnd_message.raise_error;
339:
340: end get_base_value;
341:

Line 338: fnd_message.raise_error;

334: exception
335: when no_data_found then
336: fnd_message.set_name('PAY','PAY_74937_SD_NO_BASE_VALUE');
337: fnd_message.set_token('TYPE',p_base_type);
338: fnd_message.raise_error;
339:
340: end get_base_value;
341:
342: ------------------------------------------------------------------------

Line 369: fnd_message.set_name('PAY','PAY_74935_SD_NO_RATE');

365:
366: return l_rate_value;
367: exception
368: when no_data_found then
369: fnd_message.set_name('PAY','PAY_74935_SD_NO_RATE');
370: fnd_message.set_token('RATE_TYPE',p_rate_type);
371: fnd_message.raise_error;
372: end get_rate_value;
373:

Line 370: fnd_message.set_token('RATE_TYPE',p_rate_type);

366: return l_rate_value;
367: exception
368: when no_data_found then
369: fnd_message.set_name('PAY','PAY_74935_SD_NO_RATE');
370: fnd_message.set_token('RATE_TYPE',p_rate_type);
371: fnd_message.raise_error;
372: end get_rate_value;
373:
374:

Line 371: fnd_message.raise_error;

367: exception
368: when no_data_found then
369: fnd_message.set_name('PAY','PAY_74935_SD_NO_RATE');
370: fnd_message.set_token('RATE_TYPE',p_rate_type);
371: fnd_message.raise_error;
372: end get_rate_value;
373:
374:
375: -- +********************************************************************+

Line 429: fnd_message.set_name('PAY','PAY_74918_SD_NO_CNU_DATA');

425: when no_data_found then
426: begin
427: hr_utility.set_location('ERROR: Contribution Usage missing for:'||p_element_name,100);
428: hr_utility.set_location('. Process Type:'||p_process_type||', Usage:'||p_usage_type,110);
429: fnd_message.set_name('PAY','PAY_74918_SD_NO_CNU_DATA');
430: fnd_message.set_token('ET',p_element_name);
431: fnd_message.set_token('PT',p_process_type);
432: fnd_message.set_token('UT',p_usage_type);
433: fnd_message.raise_error;

Line 430: fnd_message.set_token('ET',p_element_name);

426: begin
427: hr_utility.set_location('ERROR: Contribution Usage missing for:'||p_element_name,100);
428: hr_utility.set_location('. Process Type:'||p_process_type||', Usage:'||p_usage_type,110);
429: fnd_message.set_name('PAY','PAY_74918_SD_NO_CNU_DATA');
430: fnd_message.set_token('ET',p_element_name);
431: fnd_message.set_token('PT',p_process_type);
432: fnd_message.set_token('UT',p_usage_type);
433: fnd_message.raise_error;
434: end;

Line 431: fnd_message.set_token('PT',p_process_type);

427: hr_utility.set_location('ERROR: Contribution Usage missing for:'||p_element_name,100);
428: hr_utility.set_location('. Process Type:'||p_process_type||', Usage:'||p_usage_type,110);
429: fnd_message.set_name('PAY','PAY_74918_SD_NO_CNU_DATA');
430: fnd_message.set_token('ET',p_element_name);
431: fnd_message.set_token('PT',p_process_type);
432: fnd_message.set_token('UT',p_usage_type);
433: fnd_message.raise_error;
434: end;
435: end get_contribution_usage;

Line 432: fnd_message.set_token('UT',p_usage_type);

428: hr_utility.set_location('. Process Type:'||p_process_type||', Usage:'||p_usage_type,110);
429: fnd_message.set_name('PAY','PAY_74918_SD_NO_CNU_DATA');
430: fnd_message.set_token('ET',p_element_name);
431: fnd_message.set_token('PT',p_process_type);
432: fnd_message.set_token('UT',p_usage_type);
433: fnd_message.raise_error;
434: end;
435: end get_contribution_usage;
436:

Line 433: fnd_message.raise_error;

429: fnd_message.set_name('PAY','PAY_74918_SD_NO_CNU_DATA');
430: fnd_message.set_token('ET',p_element_name);
431: fnd_message.set_token('PT',p_process_type);
432: fnd_message.set_token('UT',p_usage_type);
433: fnd_message.raise_error;
434: end;
435: end get_contribution_usage;
436:
437: ------------------------------------------------------------------------

Line 600: fnd_message.set_name('PAY', 'PAY_74909_CNU_BAD_CONT_TYPE');

596: return l_full_code;
597:
598: ELSE
599: /* Contribution Type was not one of the four valid values */
600: fnd_message.set_name('PAY', 'PAY_74909_CNU_BAD_CONT_TYPE');
601: fnd_message.raise_error;
602: END IF;
603: end if;
604: exception

Line 601: fnd_message.raise_error;

597:
598: ELSE
599: /* Contribution Type was not one of the four valid values */
600: fnd_message.set_name('PAY', 'PAY_74909_CNU_BAD_CONT_TYPE');
601: fnd_message.raise_error;
602: END IF;
603: end if;
604: exception
605: when no_data_found then

Line 606: fnd_message.set_name('PAY','PAY_74914_SD_NO_BASE_CODE_VAL');

602: END IF;
603: end if;
604: exception
605: when no_data_found then
606: fnd_message.set_name('PAY','PAY_74914_SD_NO_BASE_CODE_VAL');
607: fnd_message.set_token('TYPE',p_contribution_type);
608: fnd_message.raise_error;
609:
610: end sub_contrib_code;

Line 607: fnd_message.set_token('TYPE',p_contribution_type);

603: end if;
604: exception
605: when no_data_found then
606: fnd_message.set_name('PAY','PAY_74914_SD_NO_BASE_CODE_VAL');
607: fnd_message.set_token('TYPE',p_contribution_type);
608: fnd_message.raise_error;
609:
610: end sub_contrib_code;
611:

Line 608: fnd_message.raise_error;

604: exception
605: when no_data_found then
606: fnd_message.set_name('PAY','PAY_74914_SD_NO_BASE_CODE_VAL');
607: fnd_message.set_token('TYPE',p_contribution_type);
608: fnd_message.raise_error;
609:
610: end sub_contrib_code;
611:
612: ------------------------------------------------------------------------

Line 636: fnd_message.set_name('PAY', p_message_name);

632: --
633: hr_utility.set_location('Entered '||l_proc,5);
634: hr_utility.set_location('. Message Name: '||p_message_name,40);
635:
636: fnd_message.set_name('PAY', p_message_name);
637:
638: if p_token1 is not null then
639: /* Obtain token 1 name and value */
640: l_colon_position := instr(p_token1,':');

Line 643: fnd_message.set_token(l_token_name, l_token_value);

639: /* Obtain token 1 name and value */
640: l_colon_position := instr(p_token1,':');
641: l_token_name := substr(p_token1,1,l_colon_position-1);
642: l_token_value := substr(p_token1,l_colon_position+1,length(p_token1));
643: fnd_message.set_token(l_token_name, l_token_value);
644: hr_utility.set_location('. Token1: '||l_token_name||'. Value: '||l_token_value,50);
645: end if;
646:
647: if p_token2 is not null then

Line 652: fnd_message.set_token(l_token_name, l_token_value);

648: /* Obtain token 2 name and value */
649: l_colon_position := instr(p_token2,':');
650: l_token_name := substr(p_token2,1,l_colon_position-1);
651: l_token_value := substr(p_token2,l_colon_position+1,length(p_token2));
652: fnd_message.set_token(l_token_name, l_token_value);
653: hr_utility.set_location('. Token2: '||l_token_name||'. Value: '||l_token_value,60);
654: end if;
655:
656: if p_token3 is not null then

Line 661: fnd_message.set_token(l_token_name, l_token_value);

657: /* Obtain token 3 name and value */
658: l_colon_position := instr(p_token3,':');
659: l_token_name := substr(p_token3,1,l_colon_position-1);
660: l_token_value := substr(p_token3,l_colon_position+1,length(p_token3));
661: fnd_message.set_token(l_token_name, l_token_value);
662: hr_utility.set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);
663: end if;
664:
665: l_message := substrb(fnd_message.get,1,250);

Line 665: l_message := substrb(fnd_message.get,1,250);

661: fnd_message.set_token(l_token_name, l_token_value);
662: hr_utility.set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);
663: end if;
664:
665: l_message := substrb(fnd_message.get,1,250);
666:
667: hr_utility.set_location('leaving '||l_proc,100);
668:
669: return l_message;

Line 804: fnd_message.set_name('PAY','PAY_74915_SD_NON_UNIQUE_INDEX');

800: l_existing_row := g_base_code_table(l_index);
801:
802: /* If a no_data_found exception did not occur then the index is
803: already in use and hence an error has occured */
804: fnd_message.set_name('PAY','PAY_74915_SD_NON_UNIQUE_INDEX');
805: fnd_message.set_token('NAME','URSSAF');
806: fnd_message.raise_error;
807:
808: exception

Line 805: fnd_message.set_token('NAME','URSSAF');

801:
802: /* If a no_data_found exception did not occur then the index is
803: already in use and hence an error has occured */
804: fnd_message.set_name('PAY','PAY_74915_SD_NON_UNIQUE_INDEX');
805: fnd_message.set_token('NAME','URSSAF');
806: fnd_message.raise_error;
807:
808: exception
809: when no_data_found then null; -- success, the index number has not been used

Line 806: fnd_message.raise_error;

802: /* If a no_data_found exception did not occur then the index is
803: already in use and hence an error has occured */
804: fnd_message.set_name('PAY','PAY_74915_SD_NON_UNIQUE_INDEX');
805: fnd_message.set_token('NAME','URSSAF');
806: fnd_message.raise_error;
807:
808: exception
809: when no_data_found then null; -- success, the index number has not been used
810: end;

Line 866: fnd_message.set_name('PAY','PAY_74915_SD_NON_UNIQUE_INDEX');

862: l_existing_row := g_base_code_table(l_index);
863:
864: /* If a no_data_found exception did not occur then the index is
865: already in use and hence an error has occured */
866: fnd_message.set_name('PAY','PAY_74915_SD_NON_UNIQUE_INDEX');
867: fnd_message.set_token('NAME','ASSEDIC');
868: fnd_message.raise_error;
869:
870: exception

Line 867: fnd_message.set_token('NAME','ASSEDIC');

863:
864: /* If a no_data_found exception did not occur then the index is
865: already in use and hence an error has occured */
866: fnd_message.set_name('PAY','PAY_74915_SD_NON_UNIQUE_INDEX');
867: fnd_message.set_token('NAME','ASSEDIC');
868: fnd_message.raise_error;
869:
870: exception
871: when no_data_found then null; -- success, the index number has not been used

Line 868: fnd_message.raise_error;

864: /* If a no_data_found exception did not occur then the index is
865: already in use and hence an error has occured */
866: fnd_message.set_name('PAY','PAY_74915_SD_NON_UNIQUE_INDEX');
867: fnd_message.set_token('NAME','ASSEDIC');
868: fnd_message.raise_error;
869:
870: exception
871: when no_data_found then null; -- success, the index number has not been used
872: end;

Line 950: fnd_message.set_name('PAY','PAY_74926_SD_BAD_PEN_PRVS');

946: fetch estab_pen_prvs_csr into l_order_number;
947:
948: if estab_pen_prvs_csr%notfound then
949: close estab_pen_prvs_csr;
950: fnd_message.set_name('PAY','PAY_74926_SD_BAD_PEN_PRVS');
951: fnd_message.set_token('TYPE',p_provider_type);
952: fnd_message.raise_error;
953: else
954: close estab_pen_prvs_csr;

Line 951: fnd_message.set_token('TYPE',p_provider_type);

947:
948: if estab_pen_prvs_csr%notfound then
949: close estab_pen_prvs_csr;
950: fnd_message.set_name('PAY','PAY_74926_SD_BAD_PEN_PRVS');
951: fnd_message.set_token('TYPE',p_provider_type);
952: fnd_message.raise_error;
953: else
954: close estab_pen_prvs_csr;
955: end if;

Line 952: fnd_message.raise_error;

948: if estab_pen_prvs_csr%notfound then
949: close estab_pen_prvs_csr;
950: fnd_message.set_name('PAY','PAY_74926_SD_BAD_PEN_PRVS');
951: fnd_message.set_token('TYPE',p_provider_type);
952: fnd_message.raise_error;
953: else
954: close estab_pen_prvs_csr;
955: end if;
956: hr_utility.set_location('Order Number Found:'||l_order_number,20);

Line 968: fnd_message.set_name('PAY','PAY_74917_SD_NO_DFLT_PEN_PRVS');

964:
965: if estab_default_pen_prvs_csr%notfound then
966: close estab_default_pen_prvs_csr;
967: /* Raise Application error as no default provider could be found */
968: fnd_message.set_name('PAY','PAY_74917_SD_NO_DFLT_PEN_PRVS');
969: fnd_message.set_token('TYPE',p_provider_type);
970: fnd_message.raise_error;
971: else
972: /* Check that only one default was set - i.e. no more records should be found */

Line 969: fnd_message.set_token('TYPE',p_provider_type);

965: if estab_default_pen_prvs_csr%notfound then
966: close estab_default_pen_prvs_csr;
967: /* Raise Application error as no default provider could be found */
968: fnd_message.set_name('PAY','PAY_74917_SD_NO_DFLT_PEN_PRVS');
969: fnd_message.set_token('TYPE',p_provider_type);
970: fnd_message.raise_error;
971: else
972: /* Check that only one default was set - i.e. no more records should be found */
973: fetch estab_default_pen_prvs_csr into l_order_number;

Line 970: fnd_message.raise_error;

966: close estab_default_pen_prvs_csr;
967: /* Raise Application error as no default provider could be found */
968: fnd_message.set_name('PAY','PAY_74917_SD_NO_DFLT_PEN_PRVS');
969: fnd_message.set_token('TYPE',p_provider_type);
970: fnd_message.raise_error;
971: else
972: /* Check that only one default was set - i.e. no more records should be found */
973: fetch estab_default_pen_prvs_csr into l_order_number;
974:

Line 978: fnd_message.set_name('PAY','PAY_74916_SD_BAD_DFLT_PEN_PRVS');

974:
975: if estab_default_pen_prvs_csr%found then
976: close estab_default_pen_prvs_csr;
977: /* If a row was found then an error has occured */
978: fnd_message.set_name('PAY','PAY_74916_SD_BAD_DFLT_PEN_PRVS');
979: fnd_message.set_token('TYPE',p_provider_type);
980: fnd_message.raise_error;
981: ELSE
982: hr_utility.set_location('Order Number Found:'||l_order_number,39);

Line 979: fnd_message.set_token('TYPE',p_provider_type);

975: if estab_default_pen_prvs_csr%found then
976: close estab_default_pen_prvs_csr;
977: /* If a row was found then an error has occured */
978: fnd_message.set_name('PAY','PAY_74916_SD_BAD_DFLT_PEN_PRVS');
979: fnd_message.set_token('TYPE',p_provider_type);
980: fnd_message.raise_error;
981: ELSE
982: hr_utility.set_location('Order Number Found:'||l_order_number,39);
983: close estab_default_pen_prvs_csr;

Line 980: fnd_message.raise_error;

976: close estab_default_pen_prvs_csr;
977: /* If a row was found then an error has occured */
978: fnd_message.set_name('PAY','PAY_74916_SD_BAD_DFLT_PEN_PRVS');
979: fnd_message.set_token('TYPE',p_provider_type);
980: fnd_message.raise_error;
981: ELSE
982: hr_utility.set_location('Order Number Found:'||l_order_number,39);
983: close estab_default_pen_prvs_csr;
984: end if;

Line 1001: fnd_message.set_name('PAY','PAY_74915_SD_NON_UNIQUE_INDEX');

997: l_existing_row := g_base_code_table(l_index);
998:
999: /* If a no_data_found exception did not occur then the index is
1000: already in use and hence an error has occured */
1001: fnd_message.set_name('PAY','PAY_74915_SD_NON_UNIQUE_INDEX');
1002: fnd_message.set_token('NAME',p_provider_type);
1003: fnd_message.raise_error;
1004:
1005: exception

Line 1002: fnd_message.set_token('NAME',p_provider_type);

998:
999: /* If a no_data_found exception did not occur then the index is
1000: already in use and hence an error has occured */
1001: fnd_message.set_name('PAY','PAY_74915_SD_NON_UNIQUE_INDEX');
1002: fnd_message.set_token('NAME',p_provider_type);
1003: fnd_message.raise_error;
1004:
1005: exception
1006: when no_data_found then null; -- success, the index number has not been used before

Line 1003: fnd_message.raise_error;

999: /* If a no_data_found exception did not occur then the index is
1000: already in use and hence an error has occured */
1001: fnd_message.set_name('PAY','PAY_74915_SD_NON_UNIQUE_INDEX');
1002: fnd_message.set_token('NAME',p_provider_type);
1003: fnd_message.raise_error;
1004:
1005: exception
1006: when no_data_found then null; -- success, the index number has not been used before
1007: end;

Line 1182: fnd_message.set_name('PAY','PAY_74915_SD_NON_UNIQUE_INDEX');

1178: l_existing_row := g_band_table(l_index);
1179:
1180: /* If a no_data_found exception did not occur then the index is
1181: already in use and hence an error has occured */
1182: fnd_message.set_name('PAY','PAY_74915_SD_NON_UNIQUE_INDEX');
1183: fnd_message.set_token('NAME',p_name);
1184: fnd_message.raise_error;
1185:
1186: return 1; --Return 1 to indicate an error occured

Line 1183: fnd_message.set_token('NAME',p_name);

1179:
1180: /* If a no_data_found exception did not occur then the index is
1181: already in use and hence an error has occured */
1182: fnd_message.set_name('PAY','PAY_74915_SD_NON_UNIQUE_INDEX');
1183: fnd_message.set_token('NAME',p_name);
1184: fnd_message.raise_error;
1185:
1186: return 1; --Return 1 to indicate an error occured
1187:

Line 1184: fnd_message.raise_error;

1180: /* If a no_data_found exception did not occur then the index is
1181: already in use and hence an error has occured */
1182: fnd_message.set_name('PAY','PAY_74915_SD_NON_UNIQUE_INDEX');
1183: fnd_message.set_token('NAME',p_name);
1184: fnd_message.raise_error;
1185:
1186: return 1; --Return 1 to indicate an error occured
1187:
1188: exception

Line 1683: fnd_message.set_name('PAY','PAY_74933_SD_NO_WRK_ACC_RATE');

1679: ,p_user_column_instance_id => l_user_column_instance_id
1680: ,p_user_row_id => l_user_row_id);
1681: exception
1682: when no_data_found then
1683: fnd_message.set_name('PAY','PAY_74933_SD_NO_WRK_ACC_RATE');
1684: fnd_message.set_token('RISK_CODE',l_risk_code);
1685: fnd_message.raise_error;
1686: end;
1687: maintain_rate_cache(l_contribution_usage_id, p_tax_unit_id, l_contribution_code,

Line 1684: fnd_message.set_token('RISK_CODE',l_risk_code);

1680: ,p_user_row_id => l_user_row_id);
1681: exception
1682: when no_data_found then
1683: fnd_message.set_name('PAY','PAY_74933_SD_NO_WRK_ACC_RATE');
1684: fnd_message.set_token('RISK_CODE',l_risk_code);
1685: fnd_message.raise_error;
1686: end;
1687: maintain_rate_cache(l_contribution_usage_id, p_tax_unit_id, l_contribution_code,
1688: l_rate_value,l_user_column_instance_id, l_risk_code);

Line 1685: fnd_message.raise_error;

1681: exception
1682: when no_data_found then
1683: fnd_message.set_name('PAY','PAY_74933_SD_NO_WRK_ACC_RATE');
1684: fnd_message.set_token('RISK_CODE',l_risk_code);
1685: fnd_message.raise_error;
1686: end;
1687: maintain_rate_cache(l_contribution_usage_id, p_tax_unit_id, l_contribution_code,
1688: l_rate_value,l_user_column_instance_id, l_risk_code);
1689: end if; -- } no cached rate

Line 1812: fnd_message.set_name('PAY','PAY_74934_SD_NO_TRNS_TAX_RATE');

1808: ,p_user_row_id => l_user_row_id
1809: ,p_user_column_instance_id => l_user_column_instance_id);
1810: exception
1811: when no_data_found then
1812: fnd_message.set_name('PAY','PAY_74934_SD_NO_TRNS_TAX_RATE');
1813: fnd_message.set_token('TRNS_TAX_REGION',p_transport_tax_region);
1814: fnd_message.raise_error;
1815: end;
1816: maintain_rate_cache(l_contribution_usage_id, p_tax_unit_id, l_contribution_code,

Line 1813: fnd_message.set_token('TRNS_TAX_REGION',p_transport_tax_region);

1809: ,p_user_column_instance_id => l_user_column_instance_id);
1810: exception
1811: when no_data_found then
1812: fnd_message.set_name('PAY','PAY_74934_SD_NO_TRNS_TAX_RATE');
1813: fnd_message.set_token('TRNS_TAX_REGION',p_transport_tax_region);
1814: fnd_message.raise_error;
1815: end;
1816: maintain_rate_cache(l_contribution_usage_id, p_tax_unit_id, l_contribution_code,
1817: l_rate_value,l_user_column_instance_id, l_transport_tax_region);

Line 1814: fnd_message.raise_error;

1810: exception
1811: when no_data_found then
1812: fnd_message.set_name('PAY','PAY_74934_SD_NO_TRNS_TAX_RATE');
1813: fnd_message.set_token('TRNS_TAX_REGION',p_transport_tax_region);
1814: fnd_message.raise_error;
1815: end;
1816: maintain_rate_cache(l_contribution_usage_id, p_tax_unit_id, l_contribution_code,
1817: l_rate_value,l_user_column_instance_id, l_transport_tax_region);
1818: end if; -- } no cached rate

Line 2121: fnd_message.set_name('PAY','PAY_74922_SD_BAD_CONV_HRS_FREQ');

2117: l_hours_in_months := l_hours_in_years*l_months_in_year;
2118: l_hours_in_weeks := l_hours_in_months/l_weeks_in_month;
2119: l_hours_in_days := l_hours_in_weeks/l_days_in_week;
2120: else
2121: fnd_message.set_name('PAY','PAY_74922_SD_BAD_CONV_HRS_FREQ');
2122: fnd_message.set_token('FREQ',p_from_freq_code);
2123: fnd_message.raise_error;
2124: hr_utility.set_location('Error - p_from_freq_code not recognised',10);
2125: end if;

Line 2122: fnd_message.set_token('FREQ',p_from_freq_code);

2118: l_hours_in_weeks := l_hours_in_months/l_weeks_in_month;
2119: l_hours_in_days := l_hours_in_weeks/l_days_in_week;
2120: else
2121: fnd_message.set_name('PAY','PAY_74922_SD_BAD_CONV_HRS_FREQ');
2122: fnd_message.set_token('FREQ',p_from_freq_code);
2123: fnd_message.raise_error;
2124: hr_utility.set_location('Error - p_from_freq_code not recognised',10);
2125: end if;
2126: --

Line 2123: fnd_message.raise_error;

2119: l_hours_in_days := l_hours_in_weeks/l_days_in_week;
2120: else
2121: fnd_message.set_name('PAY','PAY_74922_SD_BAD_CONV_HRS_FREQ');
2122: fnd_message.set_token('FREQ',p_from_freq_code);
2123: fnd_message.raise_error;
2124: hr_utility.set_location('Error - p_from_freq_code not recognised',10);
2125: end if;
2126: --
2127: End If;

Line 2374: fnd_message.set_name('PAY','PAY_HOURLY_RATE_NOT_DERIVED');

2370: if l_hourly_rate is not null then
2371: return l_hourly_rate;
2372: else
2373: hr_utility.set_location(l_proc,100);
2374: fnd_message.set_name('PAY','PAY_HOURLY_RATE_NOT_DERIVED');
2375: fnd_message.raise_error;
2376: end if;
2377: end get_pay_rate;
2378: --

Line 2375: fnd_message.raise_error;

2371: return l_hourly_rate;
2372: else
2373: hr_utility.set_location(l_proc,100);
2374: fnd_message.set_name('PAY','PAY_HOURLY_RATE_NOT_DERIVED');
2375: fnd_message.raise_error;
2376: end if;
2377: end get_pay_rate;
2378: --
2379: ------------------------------------------------------------------------

Line 2483: fnd_message.set_name('PAY',l_code_error_mesg);

2479: if l_code_error_mesg = 'VALID' then
2480: return l_contrib_code;
2481: else
2482: hr_utility.set_location('Error:'||l_code_error_mesg,100);
2483: fnd_message.set_name('PAY',l_code_error_mesg);
2484: fnd_message.raise_error;
2485: end if;
2486:
2487: end substitute_code;

Line 2484: fnd_message.raise_error;

2480: return l_contrib_code;
2481: else
2482: hr_utility.set_location('Error:'||l_code_error_mesg,100);
2483: fnd_message.set_name('PAY',l_code_error_mesg);
2484: fnd_message.raise_error;
2485: end if;
2486:
2487: end substitute_code;
2488: --

Line 2705: fnd_message.set_name('PAY','PAY_75069_NO_CODE_RATE_ID');

2701: elsif p_rate_category not in ('T','W') then -- { code_rate_id deductions
2702: hr_utility.set_location('Entering:'|| l_proc, 30);
2703: if p_code_rate_id is null then
2704: hr_utility.trace('No CODE_RATE_ID for p_contribution_usage_id:'||to_char(p_contribution_usage_id));
2705: fnd_message.set_name('PAY','PAY_75069_NO_CODE_RATE_ID');
2706: fnd_message.set_token('ELEMENT_NAME',p_element_name);
2707: fnd_message.raise_error;
2708: else -- { all columns exists
2709: --FOR 1 to nvl(g_summary_deductions.last,0)

Line 2706: fnd_message.set_token('ELEMENT_NAME',p_element_name);

2702: hr_utility.set_location('Entering:'|| l_proc, 30);
2703: if p_code_rate_id is null then
2704: hr_utility.trace('No CODE_RATE_ID for p_contribution_usage_id:'||to_char(p_contribution_usage_id));
2705: fnd_message.set_name('PAY','PAY_75069_NO_CODE_RATE_ID');
2706: fnd_message.set_token('ELEMENT_NAME',p_element_name);
2707: fnd_message.raise_error;
2708: else -- { all columns exists
2709: --FOR 1 to nvl(g_summary_deductions.last,0)
2710: if g_summary_deductions.FIRST is not null then -- { empty table

Line 2707: fnd_message.raise_error;

2703: if p_code_rate_id is null then
2704: hr_utility.trace('No CODE_RATE_ID for p_contribution_usage_id:'||to_char(p_contribution_usage_id));
2705: fnd_message.set_name('PAY','PAY_75069_NO_CODE_RATE_ID');
2706: fnd_message.set_token('ELEMENT_NAME',p_element_name);
2707: fnd_message.raise_error;
2708: else -- { all columns exists
2709: --FOR 1 to nvl(g_summary_deductions.last,0)
2710: if g_summary_deductions.FIRST is not null then -- { empty table
2711: LOOP