DBA Data[Home] [Help]

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PQP_GB_TP_EXTRACT_FUNCTIONS

Line 957: pqp_gb_tp_extract_functions.raise_extract_warning (

953: IF l_error_number = 93343
954: THEN
955: -- Raise just a warning message
956: l_return :=
957: pqp_gb_tp_extract_functions.raise_extract_warning (
958: p_assignment_id=> p_assignment_id,
959: p_error_text=> l_error_text,
960: p_error_number=> l_error_number
961: );

Line 2812: l_value := pqp_gb_tp_extract_functions.raise_extract_error

2808: IF l_rate > 999999
2809: THEN
2810: l_rate := 999999;
2811: ELSIF l_rate < 0 THEN
2812: l_value := pqp_gb_tp_extract_functions.raise_extract_error
2813: (p_business_group_id => g_business_group_id
2814: ,p_assignment_id => p_assignment_id
2815: ,p_error_text => 'BEN_94556_EXT_VALUE_ERROR'
2816: ,p_error_number => 94556

Line 4074: l_value := pqp_gb_tp_extract_functions.raise_extract_error

4070: );
4071: -- Bug Fix 5021075
4072: IF TO_NUMBER(l_actual_rem) < 0
4073: THEN
4074: l_value := pqp_gb_tp_extract_functions.raise_extract_error
4075: (p_business_group_id => g_business_group_id
4076: ,p_assignment_id => p_assignment_id
4077: ,p_error_text => 'BEN_94556_EXT_VALUE_ERROR'
4078: ,p_error_number => 94556

Line 4128: l_value := pqp_gb_tp_extract_functions.raise_extract_error

4124: );
4125: -- Bug Fix 5021075
4126: IF TO_NUMBER(l_pensionable_rem) < 0
4127: THEN
4128: l_value := pqp_gb_tp_extract_functions.raise_extract_error
4129: (p_business_group_id => g_business_group_id
4130: ,p_assignment_id => p_assignment_id
4131: ,p_error_text => 'BEN_94556_EXT_VALUE_ERROR'
4132: ,p_error_number => 94556

Line 4349: l_value := pqp_gb_tp_extract_functions.raise_extract_error

4345: THEN
4346: l_total_value := 999999999999;
4347: ELSIF l_total_value < 0
4348: THEN
4349: l_value := pqp_gb_tp_extract_functions.raise_extract_error
4350: (p_business_group_id => g_business_group_id
4351: ,p_assignment_id => NULL
4352: ,p_error_text => 'BEN_94556_EXT_VALUE_ERROR'
4353: ,p_error_number => 94556

Line 4700: l_return := pqp_gb_tp_extract_functions.raise_extract_error

4696: IF l_value > 99999999999
4697: THEN
4698: l_value := 99999999999;
4699: ELSIF l_value < 0 THEN
4700: l_return := pqp_gb_tp_extract_functions.raise_extract_error
4701: (p_business_group_id => g_business_group_id
4702: ,p_assignment_id => p_assignment_id
4703: ,p_error_text => 'BEN_94556_EXT_VALUE_ERROR'
4704: ,p_error_number => 94556

Line 4725: l_return := pqp_gb_tp_extract_functions.raise_extract_error

4721: p_effective_end_date=> g_effective_end_date
4722: );
4723: IF TO_NUMBER(l_member_contributions) < 0
4724: THEN
4725: l_return := pqp_gb_tp_extract_functions.raise_extract_error
4726: (p_business_group_id => g_business_group_id
4727: ,p_assignment_id => p_assignment_id
4728: ,p_error_text => 'BEN_94556_EXT_VALUE_ERROR'
4729: ,p_error_number => 94556

Line 4976: l_return := pqp_gb_tp_extract_functions.raise_extract_error

4972: THEN
4973: l_total_value := 99999999999;
4974: ELSIF l_total_value < 0
4975: THEN
4976: l_return := pqp_gb_tp_extract_functions.raise_extract_error
4977: (p_business_group_id => g_business_group_id
4978: ,p_assignment_id => p_assignment_id
4979: ,p_error_text => 'BEN_94556_EXT_VALUE_ERROR'
4980: ,p_error_number => 94556

Line 5037: l_value := pqp_gb_tp_extract_functions.raise_extract_error

5033: p_effective_end_date=> g_effective_end_date
5034: );
5035: -- Bug Fix 5021075
5036: IF TO_NUMBER(l_add_contributions) < 0 THEN
5037: l_value := pqp_gb_tp_extract_functions.raise_extract_error
5038: (p_business_group_id => g_business_group_id
5039: ,p_assignment_id => p_assignment_id
5040: ,p_error_text => 'BEN_94556_EXT_VALUE_ERROR'
5041: ,p_error_number => 94556

Line 5092: l_value := pqp_gb_tp_extract_functions.raise_extract_error

5088: p_effective_end_date=> g_effective_end_date
5089: );
5090: -- Bug Fix 5021075
5091: IF TO_NUMBER(l_buyback_contributions) < 0 THEN
5092: l_value := pqp_gb_tp_extract_functions.raise_extract_error
5093: (p_business_group_id => g_business_group_id
5094: ,p_assignment_id => p_assignment_id
5095: ,p_error_text => 'BEN_94556_EXT_VALUE_ERROR'
5096: ,p_error_number => 94556

Line 5417: l_return_value := pqp_gb_tp_extract_functions.raise_extract_error

5413: DEBUG ( 'Value before formatting : '
5414: || TO_CHAR (l_value));
5415: -- Bug Fix 5021075
5416: IF l_value < 0 THEN
5417: l_return_value := pqp_gb_tp_extract_functions.raise_extract_error
5418: (p_business_group_id => g_business_group_id
5419: ,p_assignment_id => p_assignment_id
5420: ,p_error_text => 'BEN_94556_EXT_VALUE_ERROR'
5421: ,p_error_number => 94556