[Home] [Help]
1450: IF g_udt_element_LondAll.COUNT = 0 THEN
1451: debug(' --------- No LARP entries found in UDT ---------', 55);
1452:
1453: -- 4336613 : LARP_SPAP_3A : new error message for LARP
1454: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
1455: (p_assignment_id => p_assignment_id
1456: ,p_error_text => 'BEN_94227_T1_LARP_ELE_NOTEXIST'
1457: ,p_error_number => 94227
1458: );
1577: IF g_udt_element_SpcAll.COUNT = 0 THEN
1578: debug(' --------- No SPAP entries found in UDT ---------', 95);
1579:
1580: -- 4336613 : LARP_SPAP_3A : new error message for SPAP
1581: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
1582: (p_assignment_id => p_assignment_id
1583: ,p_error_text => 'BEN_94228_T1_SPAP_ELE_NOTEXIST'
1584: ,p_error_number => 94228
1585: );
1695: and p_error_text IS NOT NULL -- don't raise an error, as in OSLA case.
1696: then
1697:
1698: debug(l_proc_name, 30);
1699: l_error := pqp_gb_tp_extract_functions.raise_extract_error
1700: (p_business_group_id => g_business_group_id
1701: ,p_assignment_id => p_assignment_id
1702: ,p_error_text => p_error_text
1703: ,p_error_number => p_error_number
1881: l_error_text := 'BEN_94246_EXT_TP1_DEF_BAL_ERR';
1882: l_error_number := 94246;
1883: END IF;
1884:
1885: l_error := pqp_gb_tp_extract_functions.raise_extract_error
1886: (p_business_group_id => g_business_group_id
1887: ,p_assignment_id => p_assignment_id
1888: ,p_error_text => l_error_text
1889: ,p_error_number => l_error_number
2167: -- Raise a warning if no element is feeding the
2168: -- OSLA balance.
2169: IF g_tab_osla_ele_ids.COUNT = 0 THEN
2170: debug(l_proc_name,80 ) ;
2171: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
2172: (p_assignment_id => p_assignment_id
2173: ,p_error_text => 'BEN_94240_T1_OSLA_ELE_NOTEXIST'
2174: ,p_error_number => 94240
2175: );
2180: -- Teachers OSLA Claims Balance is applicable only when Date Worked mode is Used
2181: if g_date_work_mode = 'Y' then
2182: IF g_tab_osla_cl_ele_ids.COUNT = 0 THEN
2183: debug(l_proc_name,80 ) ;
2184: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
2185: (p_assignment_id => p_assignment_id
2186: ,p_error_text => 'BEN_94240_T1_OSLA_ELE_NOTEXIST'
2187: ,p_error_number => 94240
2188: );
2317: -- Raise error only for "Salary" rate type
2318:
2319: if l_tab_rate_name(i) is null and l_tab_rate_type(i) = 'Salary' then
2320:
2321: l_error := pqp_gb_tp_extract_functions.raise_extract_error
2322: (p_business_group_id => g_business_group_id
2323: ,p_assignment_id => p_assignment_id
2324: ,p_error_text => 'BEN_93023_EXT_TP1_NO_RATE_TYPE'
2325: ,p_error_number => 93023
2338:
2339: if csr_rate_type_check%notfound then
2340:
2341: close csr_rate_type_check;
2342: l_error := pqp_gb_tp_extract_functions.raise_extract_error
2343: (p_business_group_id => g_business_group_id
2344: ,p_assignment_id => p_assignment_id
2345: ,p_error_text => 'BEN_93046_EXT_TP1_INV_RATE_TYP'
2346: ,p_error_number => 93046
2752:
2753: debug('--- Raise error : invalid switch values in UDT ---',25);
2754:
2755: -- new error message for invalid values in UDT
2756: l_error := pqp_gb_tp_extract_functions.raise_extract_error
2757: (p_business_group_id => g_business_group_id
2758: ,p_assignment_id => p_assignment_id
2759: ,p_error_text => 'BEN_94231_TP1_INVALID_UDT_VAL'
2760: ,p_error_number => 94231
2792:
2793: debug('--- Raise error : invalid switch values in UDT ---',25);
2794:
2795: -- new error message for invalid values in UDT
2796: l_error := pqp_gb_tp_extract_functions.raise_extract_error
2797: (p_business_group_id => g_business_group_id
2798: ,p_assignment_id => p_assignment_id
2799: ,p_error_text => 'BEN_94231_TP1_INVALID_UDT_VAL'
2800: ,p_error_number => 94231
2823:
2824: debug('--- Raise error : invalid switch values in UDT ---',25);
2825:
2826: -- new error message for invalid values in UDT
2827: l_error := pqp_gb_tp_extract_functions.raise_extract_error
2828: (p_business_group_id => g_business_group_id
2829: ,p_assignment_id => p_assignment_id
2830: ,p_error_text => 'BEN_94231_TP1_INVALID_UDT_VAL'
2831: ,p_error_number => 94231
4788: AND -- Full time
4789: p_ext_emp_cat_code = 'F' THEN
4790:
4791: debug(l_proc_name, 20);
4792: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
4793: (p_assignment_id => p_assignment_id
4794: ,p_error_text => 'BEN_93655_SUPPLY_TCHR_FULLTIME'
4795: ,p_error_number => 93655
4796: );
6054: l_larp_spap_count := g_udt_element_LondAll.COUNT;
6055: ELSIF p_allowance_type = 'SPECIAL_ALLOWANCE_RULE' THEN
6056: l_larp_spap_count := g_udt_element_SpcAll.COUNT;
6057: ELSE
6058: l_error_value := pqp_gb_tp_extract_functions.raise_extract_error
6059: (p_business_group_id => g_business_group_id
6060: ,p_assignment_id => p_assignment_id
6061: ,p_error_text =>'BEN_93024_EXT_TP1_INVALID_ALOW'
6062: ,p_error_number => 93024 );
6082: Fetch csr_ele_type_id Into l_element_type_id;
6083:
6084: If csr_ele_type_id%NOTFOUND Then
6085: Close csr_ele_type_id;
6086: l_error_value := pqp_gb_tp_extract_functions.raise_extract_error
6087: (p_business_group_id => g_business_group_id
6088: ,p_assignment_id => p_assignment_id
6089: ,p_error_text => 'BEN_93026_EXT_TP1_ELE_NOTEXIST'
6090: ,p_error_number => 93026
6638: -- BUG 4431495 : raising a warning message, which is being caught as an exception
6639: -- from pqp_rates_history_calc in SQLERRM, and passed on as token in dummy BEN messg
6640: -- having text as only a TOKEN
6641:
6642: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
6643: (p_assignment_id => p_assignment_id
6644: ,p_error_text => 'BEN_94268_DUMMY_MESSAGE'
6645: ,p_error_number => 94268
6646: ,p_token1 => SQLERRM
6947:
6948: -- Check whether retention allowance rate has exceeded the 4 digit limit ...
6949: IF l_total_rert_allowance_rate > 99999 THEN
6950:
6951: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
6952: (p_assignment_id => p_assignment_id
6953: ,p_error_text => 'BEN_93041_EXT_TP1_ANN_VAL_EXC'
6954: ,p_error_number => 93041
6955: -- RET: token introduced in error message
7862: -- 4336613 : SAL_VALIDAT_3A : Check whether annual sal rate has exceeded the 5 digit limit
7863: -- If yes, raise warning.
7864: IF l_actual_ann_sal_rate > 999999 THEN
7865:
7866: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
7867: (p_assignment_id => p_assignment_id
7868: ,p_error_text => 'BEN_93041_EXT_TP1_ANN_VAL_EXC'
7869: ,p_error_number => 93041
7870: -- token introduced in error message
7883: debug('l_warn_for_sal_rate: '||l_warn_for_sal_rate,520) ;
7884: -- Check for the Warning flag
7885: -- Disable this warning as a part of fix#9487206
7886: /*IF l_warn_for_sal_rate = 'Y' THEN
7887: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
7888: (p_assignment_id => p_assignment_id
7889: ,p_error_text => 'BEN_94044_ZERO_SAL_RATE'
7890: ,p_error_number => 94044
7891: ,p_token1 => fnd_date.date_to_displaydate(p_effective_start_date)
7894:
7895: debug('l_warn_for_sal_paid: '||l_warn_for_sal_paid,530) ;
7896: -- Check for the Warning flag
7897: IF l_warn_for_sal_paid = 'Y' THEN
7898: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
7899: (p_assignment_id => p_assignment_id
7900: ,p_error_text => 'BEN_94045_ZERO_PT_SAL_PAID'
7901: ,p_error_number => 94045
7902: ,p_token1 => fnd_date.date_to_displaydate(p_effective_start_date)
9699: -- 4336613 : SAL_VALIDAT_3A : Check whether part time sal value has exceeeded 5 digit limit
9700: -- If yes, raise warning.
9701: if l_part_time_sal > 999999 then
9702:
9703: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
9704: (p_assignment_id => p_assignment_id
9705: ,p_error_text => 'BEN_93042_EXT_TP1_PT_SAL_EXC'
9706: ,p_error_number => 93042
9707: ,p_token1 => TO_CHAR(l_part_time_sal) -- bug : 4336613
11802: -- Bugfix 3073562:GAP9b
11803: -- If this person has more than one supply assignments
11804: -- then raise a warning.
11805: IF g_supply_asg_count > 1 THEN
11806: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
11807: (p_assignment_id => p_assignment_id
11808: ,p_error_text => 'BEN_93656_SUPPLY_TCHR_MULTIASG'
11809: ,p_error_number => 93656
11810: );
12236: -- Bugfix 3073562:GAP9b
12237: -- If this person has more than one supply assignments
12238: -- then raise a warning.
12239: IF g_supply_asg_count > 1 THEN
12240: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
12241: (p_assignment_id => p_assignment_id
12242: ,p_error_text => 'BEN_93656_SUPPLY_TCHR_MULTIASG'
12243: ,p_error_number => 93656
12244: );
12991: debug('Other Allowance : '||to_char(g_other_allowance(p_assignment_id)),15);
12992:
12993: if g_other_allowance(p_assignment_id) > 99999 then
12994:
12995: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
12996: (p_assignment_id => p_assignment_id
12997: ,p_error_text => 'BEN_93043_EXT_TP1_OTH_VAL_EXC'
12998: ,p_error_number => 93043
12999: ,p_token1 => TO_CHAR(g_other_allowance(p_assignment_id)) -- bug : 4336613
14359: g_ext_asg_details(p_assignment_id).teacher_start_date:= l_temp_date_primary;
14360:
14361: IF l_new_sfgrade = 'INVALID' THEN
14362:
14363: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14364: (p_assignment_id => p_assignment_id
14365: ,p_error_text => 'BEN_93037_EXT_TP1_INV_SAL_SCL'
14366: ,p_error_number => 93037
14367: );
14367: );
14368:
14369: ELSIF l_new_sfgrade = 'UNKNOWN' THEN
14370:
14371: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14372: (p_assignment_id => p_assignment_id
14373: ,p_error_text => 'BEN_93038_EXT_TP1_UNK_SAL_SCL'
14374: ,p_error_number => 93038
14375: );
14375: );
14376:
14377: ELSIF l_new_sfgrade = 'TOOMANY' THEN
14378:
14379: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14380: (p_assignment_id => p_assignment_id
14381: ,p_error_text => 'BEN_93039_EXT_TP1_TOOMANY_VALS'
14382: ,p_error_number => 93039
14383: );
14504: pqp_gb_tp_pension_extracts.g_nested_level := 0;
14505:
14506: IF l_new_sfgrade = 'INVALID' THEN
14507:
14508: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14509: (p_assignment_id => p_assignment_id
14510: ,p_error_text => 'BEN_93037_EXT_TP1_INV_SAL_SCL'
14511: ,p_error_number => 93037
14512: );
14512: );
14513:
14514: ELSIF l_new_sfgrade = 'UNKNOWN' THEN
14515:
14516: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14517: (p_assignment_id => p_assignment_id
14518: ,p_error_text => 'BEN_93038_EXT_TP1_UNK_SAL_SCL'
14519: ,p_error_number => 93038
14520: );
14520: );
14521:
14522: ELSIF l_new_sfgrade = 'TOOMANY' THEN
14523:
14524: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14525: (p_assignment_id => p_assignment_id
14526: ,p_error_text => 'BEN_93039_EXT_TP1_TOOMANY_VALS'
14527: ,p_error_number => 93039
14528: );
14703: ELSIF l_london_allowance = 'TOOMANY' THEN
14704:
14705: l_london_allowance := ' ';
14706: -- Bugfix 3516282 : Now passing assignment_id
14707: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14708: (p_assignment_id => p_assignment_id
14709: ,p_error_text => 'BEN_93032_EXT_TP1_LON_ALL_MANY'
14710: ,p_error_number => 93032
14711: );
14737: ELSIF l_sp_allowance = 'TOOMANY' THEN
14738:
14739: l_sp_allowance := '0';
14740: -- Bugfix 3516282 : Now passing assignment_id
14741: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14742: (p_assignment_id => p_assignment_id
14743: ,p_error_text => 'BEN_93034_EXT_TP1_SP_ALL_MANY'
14744: ,p_error_number => 93034
14745: );
14765: ELSIF l_contract_indicator = 'INVALID' THEN
14766:
14767: l_contract_indicator := '0';
14768: -- Bugfix 3516282 : Now passing assignment_id
14769: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14770: (p_assignment_id => p_assignment_id
14771: ,p_error_text => 'BEN_93036_EXT_TP1_INV_EMP_CAT'
14772: ,p_error_number => 93036
14773: );
14787: -- 4336613 : SAL_VALIDAT_3A : Check whether Other_All value has exceeeded 4 digit limit
14788: -- If yes, raise warning.
14789: if g_other_allowance(p_assignment_id) > 99999 then
14790:
14791: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14792: (p_assignment_id => p_assignment_id
14793: ,p_error_text => 'BEN_93043_EXT_TP1_OTH_VAL_EXC'
14794: ,p_error_number => 93043
14795: ,p_token1 => TO_CHAR(g_other_allowance(p_assignment_id)) -- bug : 4336613
14842: -- Raise a warning here if both Prorated/Retro payments exist
14843: -- for the LoS.
14844:
14845: debug('Raising Warning for RETRO/PRORATION', 260);
14846: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14847: (p_assignment_id => p_assignment_id
14848: ,p_error_text => 'BEN_94159_EXT_TP_RETRO_PAY'
14849: ,p_error_number => 94159
14850: --,p_token1 => fnd_date.string_to_canonical(p_dtl_rec.val_13,'DDMMYY')
17414:
17415: -- Raise a warning if Cross person enable = N and
17416: -- there are multiple person records.
17417: IF (g_cross_per_enabled = 'N' AND g_person_count > 0) THEN
17418: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
17419: (p_assignment_id => p_assignment_id
17420: ,p_error_text => 'BEN_94022_TP1_ANTHR_TCHR_ASG'
17421: ,p_error_number => 94022
17422: );
17744: IF l_return_value IS NOT NULL THEN
17745: return l_return_value;
17746: END IF;
17747: ELSE
17748: l_error_value := pqp_gb_tp_extract_functions.raise_extract_error
17749: (p_business_group_id => g_business_group_id
17750: ,p_assignment_id => p_assignment_id
17751: ,p_error_text =>'BEN_93024_EXT_TP1_INVALID_ALOW'
17752: ,p_error_number => 93024 );