[Home] [Help]
676: --
677: debug_exit(l_proc_name);
678: --
679: -- Raise an error for element does not exist
680: l_return := pqp_gb_tp_extract_functions.raise_extract_error
681: (p_business_group_id => g_business_group_id
682: ,p_assignment_id => p_assignment_id
683: ,p_error_text =>'BEN_93026_EXT_TP1_ELE_NOTEXIST'
684: ,p_error_number => 93026
815: */
816:
817: --
818: -- Raise an error for failure to get element_type_extra_info_id
819: l_return := pqp_gb_tp_extract_functions.raise_extract_error
820: (p_business_group_id => g_business_group_id
821: ,p_assignment_id => p_assignment_id
822: -- RET1.a : Added error BEN_94155_EXT_TP1_ERR_RET_ALL
823: ,p_error_text =>'BEN_94155_EXT_TP1_ERR_RET_ALL'
843:
844: -- Raise an error for no element are associated
845: -- with this rate type
846:
847: l_return := pqp_gb_tp_extract_functions.raise_extract_error
848: (p_business_group_id => g_business_group_id
849: ,p_assignment_id => p_assignment_id
850: ,p_error_text =>'BEN_93640_EXT_TP_NO_ELE_FOR_RT'
851: ,p_error_number => 93640 );
989: -- Raise an error as one cannot enter a value
990: -- for both rate type and element type for the
991: -- same salary scale
992:
993: l_return := pqp_gb_tp_extract_functions.raise_extract_error
994: (p_business_group_id => g_business_group_id
995: ,p_assignment_id => p_assignment_id
996: ,p_error_text =>'BEN_93639_EXT_TP_ELE_RT_EXISTS'
997: ,p_error_number => 93639
1075: -- Raise an error as one cannot enter a value
1076: -- for both rate type and element type for the
1077: -- same salary scale
1078:
1079: l_return := pqp_gb_tp_extract_functions.raise_extract_error
1080: (p_business_group_id => g_business_group_id
1081: ,p_assignment_id => p_assignment_id
1082: ,p_error_text =>'BEN_93639_EXT_TP_ELE_RT_EXISTS'
1083: ,p_error_number => 93639
1112: debug('l_element_type_extra_info_id not found');
1113: debug_exit(l_proc_name);
1114: --
1115: -- Raise an error for failure to get element_type_extra_info_id
1116: l_return := pqp_gb_tp_extract_functions.raise_extract_error
1117: (p_business_group_id => g_business_group_id
1118: ,p_assignment_id => p_assignment_id
1119: -- RET1.a : Added error BEN_94155_EXT_TP1_ERR_RET_ALL
1120: ,p_error_text =>'BEN_94155_EXT_TP1_ERR_RET_ALL'
1201: -- Raise an error as one cannot enter a value
1202: -- for both rate type and element type for the
1203: -- same salary scale
1204:
1205: l_return := pqp_gb_tp_extract_functions.raise_extract_error
1206: (p_business_group_id => g_business_group_id
1207: ,p_assignment_id => p_assignment_id
1208: ,p_error_text =>'BEN_93639_EXT_TP_ELE_RT_EXISTS'
1209: ,p_error_number => 93639
1375: IF csr_estb_details_by_loc%notfound THEN
1376:
1377: debug ('inside csr_estb_details_by_loc%notfound ', 110);
1378:
1379: l_error := pqp_gb_tp_extract_functions.raise_extract_error
1380: (p_business_group_id => p_business_group_id
1381: ,p_assignment_id => p_assignment_id
1382: ,p_error_text => 'BEN_93008_EXT_TP4_INVALID_LOC'
1383: ,p_error_number => 93008
1490: -- Close both cursors
1491: CLOSE csr_lea_details;
1492: -- Error out as the current BG is not set up as an LEA
1493:
1494: l_error := pqp_gb_tp_extract_functions.raise_extract_error
1495: (p_business_group_id => p_business_group_id
1496: ,p_assignment_id => p_assignment_id
1497: ,p_error_text => 'BEN_94017_CURR_BG_NOT_LEA_ERR'
1498: ,p_error_number => 94017
1534: -- IF no LEA details are found , RAISE an ERROR and EXIT.
1535: -- The case can arise only if The Extract Process is Run
1536: -- and there is no LEA defined at BG level at all.
1537: IF (csr_lea_details%NOTFOUND OR l_lea_details.lea_number IS NULL) THEN
1538: l_error := pqp_gb_tp_extract_functions.raise_extract_error
1539: (p_business_group_id => g_business_group_id
1540: ,p_assignment_id => p_assignment_id
1541: ,p_error_text => 'BEN_94017_CURR_BG_NOT_LEA_ERR'
1542: ,p_error_number => 94017
1976: -- and the earliest start date is correct.
1977: debug ('l_prev_start_date IS NULL', 340) ;
1978: ELSIF l_prev_start_date <= l_earliest_start_date THEN
1979: --raise a warning : "Already reported with start_date = l_prev_start_date"
1980: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
1981: (p_assignment_id => p_assignment_id
1982: ,p_error_text => 'BEN_94018_TPA_ALREADY_REPORTED'
1983: ,p_error_number => 94018
1984: ,p_token1 => fnd_date.date_to_displaydate(l_prev_start_date)
1986: debug ('raised warning for Already reported with start_date:'||l_error,350);
1987: l_inclusion_flag := 'Y' ;
1988: ELSIF l_prev_start_date > l_earliest_start_date THEN
1989: --raise a warning : "Already reported with start_date = l_prev_start_date, new starter found at date = l_earliest_start_date".
1990: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
1991: (p_assignment_id => p_assignment_id
1992: ,p_error_text => 'BEN_94019_TPA_RPRTD_NEW_FOUND'
1993: ,p_error_number => 94019
1994: ,p_token1 => fnd_date.date_to_displaydate(l_prev_start_date)
4017: --fnd_message.set_token ('TOKEN1',g_lea_number);
4018: --fnd_message.set_token ('TOKEN2',g_token_org_name);
4019: --More than one organizations have been set up with the LEA Number
4020: --The organization
4021: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
4022: (p_assignment_id => p_assignment_id
4023: ,p_error_text => 'BEN_94006_TPA_MANY_LEA'
4024: ,p_error_number => 94006
4025: ,p_token1 => g_lea_number
4054: -- Raise Warning here
4055: --fnd_message.set_name ('PQP', 'PQP_230151_NO_LOC_MAP_ON_LEA');
4056: --fnd_message.set_token ('TOKEN1',g_lea_number);
4057: -- These is no Location defined for LEA
4058: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
4059: (p_assignment_id => p_assignment_id
4060: ,p_error_text => 'BEN_94007_NO_LOC_MAP_ON_LEA'
4061: ,p_error_number => 94007
4062: ,p_token1 => g_lea_number
4253:
4254: -- Raise an error for no element are associated
4255: -- with this rate type
4256:
4257: l_return := pqp_gb_tp_extract_functions.raise_extract_error
4258: (p_business_group_id => g_business_group_id
4259: ,p_assignment_id => p_assignment_id
4260: ,p_error_text =>'BEN_93640_EXT_TP_NO_ELE_FOR_RT'
4261: ,p_error_number => 93640 );