DBA Data[Home] [Help]

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PQP_GB_TP_EXTRACT_FUNCTIONS

Line 958: pqp_gb_tp_extract_functions.raise_extract_warning (

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

Line 2813: l_value := pqp_gb_tp_extract_functions.raise_extract_error

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

Line 4075: l_value := pqp_gb_tp_extract_functions.raise_extract_error

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

Line 4129: l_value := pqp_gb_tp_extract_functions.raise_extract_error

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

Line 4350: l_value := pqp_gb_tp_extract_functions.raise_extract_error

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

Line 4701: l_return := pqp_gb_tp_extract_functions.raise_extract_error

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

Line 4726: l_return := pqp_gb_tp_extract_functions.raise_extract_error

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

Line 5003: l_return := pqp_gb_tp_extract_functions.raise_extract_error

4999: THEN
5000: l_total_value := 99999999999;
5001: ELSIF l_total_value < 0
5002: THEN
5003: l_return := pqp_gb_tp_extract_functions.raise_extract_error
5004: (p_business_group_id => g_business_group_id
5005: ,p_assignment_id => p_assignment_id
5006: ,p_error_text => 'BEN_94556_EXT_VALUE_ERROR'
5007: ,p_error_number => 94556

Line 5064: l_value := pqp_gb_tp_extract_functions.raise_extract_error

5060: p_effective_end_date=> g_effective_end_date
5061: );
5062: -- Bug Fix 5021075
5063: IF TO_NUMBER(l_add_contributions) < 0 THEN
5064: l_value := pqp_gb_tp_extract_functions.raise_extract_error
5065: (p_business_group_id => g_business_group_id
5066: ,p_assignment_id => p_assignment_id
5067: ,p_error_text => 'BEN_94556_EXT_VALUE_ERROR'
5068: ,p_error_number => 94556

Line 5119: l_value := pqp_gb_tp_extract_functions.raise_extract_error

5115: p_effective_end_date=> g_effective_end_date
5116: );
5117: -- Bug Fix 5021075
5118: IF TO_NUMBER(l_buyback_contributions) < 0 THEN
5119: l_value := pqp_gb_tp_extract_functions.raise_extract_error
5120: (p_business_group_id => g_business_group_id
5121: ,p_assignment_id => p_assignment_id
5122: ,p_error_text => 'BEN_94556_EXT_VALUE_ERROR'
5123: ,p_error_number => 94556

Line 5444: l_return_value := pqp_gb_tp_extract_functions.raise_extract_error

5440: DEBUG ( 'Value before formatting : '
5441: || TO_CHAR (l_value));
5442: -- Bug Fix 5021075
5443: IF l_value < 0 THEN
5444: l_return_value := pqp_gb_tp_extract_functions.raise_extract_error
5445: (p_business_group_id => g_business_group_id
5446: ,p_assignment_id => p_assignment_id
5447: ,p_error_text => 'BEN_94556_EXT_VALUE_ERROR'
5448: ,p_error_number => 94556