eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PQP_GB_TP_EXTRACT_FUNCTIONS

Line 1455: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

1451: IF g_udt_element_LondAll.COUNT = 0 THEN
1452: debug(' --------- No LARP entries found in UDT ---------', 55);
1453:
1454: -- 4336613 : LARP_SPAP_3A : new error message for LARP
1455: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
1456: (p_assignment_id => p_assignment_id
1457: ,p_error_text => 'BEN_94227_T1_LARP_ELE_NOTEXIST'
1458: ,p_error_number => 94227
1459: );

Line 1582: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

1578: IF g_udt_element_SpcAll.COUNT = 0 THEN
1579: debug(' --------- No SPAP entries found in UDT ---------', 95);
1580:
1581: -- 4336613 : LARP_SPAP_3A : new error message for SPAP
1582: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
1583: (p_assignment_id => p_assignment_id
1584: ,p_error_text => 'BEN_94228_T1_SPAP_ELE_NOTEXIST'
1585: ,p_error_number => 94228
1586: );

Line 1700: l_error := pqp_gb_tp_extract_functions.raise_extract_error

1696: and p_error_text IS NOT NULL -- don't raise an error, as in OSLA case.
1697: then
1698:
1699: debug(l_proc_name, 30);
1700: l_error := pqp_gb_tp_extract_functions.raise_extract_error
1701: (p_business_group_id => g_business_group_id
1702: ,p_assignment_id => p_assignment_id
1703: ,p_error_text => p_error_text
1704: ,p_error_number => p_error_number

Line 1886: l_error := pqp_gb_tp_extract_functions.raise_extract_error

1882: l_error_text := 'BEN_94246_EXT_TP1_DEF_BAL_ERR';
1883: l_error_number := 94246;
1884: END IF;
1885:
1886: l_error := pqp_gb_tp_extract_functions.raise_extract_error
1887: (p_business_group_id => g_business_group_id
1888: ,p_assignment_id => p_assignment_id
1889: ,p_error_text => l_error_text
1890: ,p_error_number => l_error_number

Line 2144: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

2140: -- Raise a warning if no element is feeding the
2141: -- OSLA balance.
2142: IF g_tab_osla_ele_ids.COUNT = 0 THEN
2143: debug(l_proc_name,80 ) ;
2144: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
2145: (p_assignment_id => p_assignment_id
2146: ,p_error_text => 'BEN_94240_T1_OSLA_ELE_NOTEXIST'
2147: ,p_error_number => 94240
2148: );

Line 2157: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

2153: -- Teachers OSLA Claims Balance is applicable only when Date Worked mode is Used
2154: if g_date_work_mode = 'Y' then
2155: IF g_tab_osla_cl_ele_ids.COUNT = 0 THEN
2156: debug(l_proc_name,80 ) ;
2157: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
2158: (p_assignment_id => p_assignment_id
2159: ,p_error_text => 'BEN_94240_T1_OSLA_ELE_NOTEXIST'
2160: ,p_error_number => 94240
2161: );

Line 2293: l_error := pqp_gb_tp_extract_functions.raise_extract_error

2289: -- Raise error only for "Salary" rate type
2290:
2291: if l_tab_rate_name(i) is null and l_tab_rate_type(i) = 'Salary' then
2292:
2293: l_error := pqp_gb_tp_extract_functions.raise_extract_error
2294: (p_business_group_id => g_business_group_id
2295: ,p_assignment_id => p_assignment_id
2296: ,p_error_text => 'BEN_93023_EXT_TP1_NO_RATE_TYPE'
2297: ,p_error_number => 93023

Line 2314: l_error := pqp_gb_tp_extract_functions.raise_extract_error

2310:
2311: if csr_rate_type_check%notfound then
2312:
2313: close csr_rate_type_check;
2314: l_error := pqp_gb_tp_extract_functions.raise_extract_error
2315: (p_business_group_id => g_business_group_id
2316: ,p_assignment_id => p_assignment_id
2317: ,p_error_text => 'BEN_93046_EXT_TP1_INV_RATE_TYP'
2318: ,p_error_number => 93046

Line 2728: l_error := pqp_gb_tp_extract_functions.raise_extract_error

2724:
2725: debug('--- Raise error : invalid switch values in UDT ---',25);
2726:
2727: -- new error message for invalid values in UDT
2728: l_error := pqp_gb_tp_extract_functions.raise_extract_error
2729: (p_business_group_id => g_business_group_id
2730: ,p_assignment_id => p_assignment_id
2731: ,p_error_text => 'BEN_94231_TP1_INVALID_UDT_VAL'
2732: ,p_error_number => 94231

Line 2768: l_error := pqp_gb_tp_extract_functions.raise_extract_error

2764:
2765: debug('--- Raise error : invalid switch values in UDT ---',25);
2766:
2767: -- new error message for invalid values in UDT
2768: l_error := pqp_gb_tp_extract_functions.raise_extract_error
2769: (p_business_group_id => g_business_group_id
2770: ,p_assignment_id => p_assignment_id
2771: ,p_error_text => 'BEN_94231_TP1_INVALID_UDT_VAL'
2772: ,p_error_number => 94231

Line 2799: l_error := pqp_gb_tp_extract_functions.raise_extract_error

2795:
2796: debug('--- Raise error : invalid switch values in UDT ---',25);
2797:
2798: -- new error message for invalid values in UDT
2799: l_error := pqp_gb_tp_extract_functions.raise_extract_error
2800: (p_business_group_id => g_business_group_id
2801: ,p_assignment_id => p_assignment_id
2802: ,p_error_text => 'BEN_94231_TP1_INVALID_UDT_VAL'
2803: ,p_error_number => 94231

Line 4764: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

4760: AND -- Full time
4761: p_ext_emp_cat_code = 'F' THEN
4762:
4763: debug(l_proc_name, 20);
4764: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
4765: (p_assignment_id => p_assignment_id
4766: ,p_error_text => 'BEN_93655_SUPPLY_TCHR_FULLTIME'
4767: ,p_error_number => 93655
4768: );

Line 6030: l_error_value := pqp_gb_tp_extract_functions.raise_extract_error

6026: l_larp_spap_count := g_udt_element_LondAll.COUNT;
6027: ELSIF p_allowance_type = 'SPECIAL_ALLOWANCE_RULE' THEN
6028: l_larp_spap_count := g_udt_element_SpcAll.COUNT;
6029: ELSE
6030: l_error_value := pqp_gb_tp_extract_functions.raise_extract_error
6031: (p_business_group_id => g_business_group_id
6032: ,p_assignment_id => p_assignment_id
6033: ,p_error_text =>'BEN_93024_EXT_TP1_INVALID_ALOW'
6034: ,p_error_number => 93024 );

Line 6058: l_error_value := pqp_gb_tp_extract_functions.raise_extract_error

6054: Fetch csr_ele_type_id Into l_element_type_id;
6055:
6056: If csr_ele_type_id%NOTFOUND Then
6057: Close csr_ele_type_id;
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_93026_EXT_TP1_ELE_NOTEXIST'
6062: ,p_error_number => 93026

Line 6614: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

6610: -- BUG 4431495 : raising a warning message, which is being caught as an exception
6611: -- from pqp_rates_history_calc in SQLERRM, and passed on as token in dummy BEN messg
6612: -- having text as only a TOKEN
6613:
6614: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
6615: (p_assignment_id => p_assignment_id
6616: ,p_error_text => 'BEN_94268_DUMMY_MESSAGE'
6617: ,p_error_number => 94268
6618: ,p_token1 => SQLERRM

Line 6923: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

6919:
6920: -- Check whether retention allowance rate has exceeded the 4 digit limit ...
6921: IF l_total_rert_allowance_rate > 99999 THEN
6922:
6923: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
6924: (p_assignment_id => p_assignment_id
6925: ,p_error_text => 'BEN_93041_EXT_TP1_ANN_VAL_EXC'
6926: ,p_error_number => 93041
6927: -- RET: token introduced in error message

Line 7816: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

7812: -- 4336613 : SAL_VALIDAT_3A : Check whether annual sal rate has exceeded the 5 digit limit
7813: -- If yes, raise warning.
7814: IF l_actual_ann_sal_rate > 999999 THEN
7815:
7816: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
7817: (p_assignment_id => p_assignment_id
7818: ,p_error_text => 'BEN_93041_EXT_TP1_ANN_VAL_EXC'
7819: ,p_error_number => 93041
7820: -- token introduced in error message

Line 7836: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

7832:
7833: debug('l_warn_for_sal_rate: '||l_warn_for_sal_rate,520) ;
7834: -- Check for the Warning flag
7835: IF l_warn_for_sal_rate = 'Y' THEN
7836: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
7837: (p_assignment_id => p_assignment_id
7838: ,p_error_text => 'BEN_94044_ZERO_SAL_RATE'
7839: ,p_error_number => 94044
7840: ,p_token1 => fnd_date.date_to_displaydate(p_effective_start_date)

Line 7847: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

7843:
7844: debug('l_warn_for_sal_paid: '||l_warn_for_sal_paid,530) ;
7845: -- Check for the Warning flag
7846: IF l_warn_for_sal_paid = 'Y' THEN
7847: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
7848: (p_assignment_id => p_assignment_id
7849: ,p_error_text => 'BEN_94045_ZERO_PT_SAL_PAID'
7850: ,p_error_number => 94045
7851: ,p_token1 => fnd_date.date_to_displaydate(p_effective_start_date)

Line 9583: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

9579: -- 4336613 : SAL_VALIDAT_3A : Check whether part time sal value has exceeeded 5 digit limit
9580: -- If yes, raise warning.
9581: if l_part_time_sal > 999999 then
9582:
9583: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
9584: (p_assignment_id => p_assignment_id
9585: ,p_error_text => 'BEN_93042_EXT_TP1_PT_SAL_EXC'
9586: ,p_error_number => 93042
9587: ,p_token1 => TO_CHAR(l_part_time_sal) -- bug : 4336613

Line 11608: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

11604: -- Bugfix 3073562:GAP9b
11605: -- If this person has more than one supply assignments
11606: -- then raise a warning.
11607: IF g_supply_asg_count > 1 THEN
11608: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
11609: (p_assignment_id => p_assignment_id
11610: ,p_error_text => 'BEN_93656_SUPPLY_TCHR_MULTIASG'
11611: ,p_error_number => 93656
11612: );

Line 12042: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

12038: -- Bugfix 3073562:GAP9b
12039: -- If this person has more than one supply assignments
12040: -- then raise a warning.
12041: IF g_supply_asg_count > 1 THEN
12042: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
12043: (p_assignment_id => p_assignment_id
12044: ,p_error_text => 'BEN_93656_SUPPLY_TCHR_MULTIASG'
12045: ,p_error_number => 93656
12046: );

Line 12796: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

12792: debug('Other Allowance : '||to_char(g_other_allowance(p_assignment_id)),15);
12793:
12794: if g_other_allowance(p_assignment_id) > 99999 then
12795:
12796: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
12797: (p_assignment_id => p_assignment_id
12798: ,p_error_text => 'BEN_93043_EXT_TP1_OTH_VAL_EXC'
12799: ,p_error_number => 93043
12800: ,p_token1 => TO_CHAR(g_other_allowance(p_assignment_id)) -- bug : 4336613

Line 14164: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

14160: g_ext_asg_details(p_assignment_id).teacher_start_date:= l_temp_date_primary;
14161:
14162: IF l_new_sfgrade = 'INVALID' THEN
14163:
14164: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14165: (p_assignment_id => p_assignment_id
14166: ,p_error_text => 'BEN_93037_EXT_TP1_INV_SAL_SCL'
14167: ,p_error_number => 93037
14168: );

Line 14172: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

14168: );
14169:
14170: ELSIF l_new_sfgrade = 'UNKNOWN' THEN
14171:
14172: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14173: (p_assignment_id => p_assignment_id
14174: ,p_error_text => 'BEN_93038_EXT_TP1_UNK_SAL_SCL'
14175: ,p_error_number => 93038
14176: );

Line 14180: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

14176: );
14177:
14178: ELSIF l_new_sfgrade = 'TOOMANY' THEN
14179:
14180: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14181: (p_assignment_id => p_assignment_id
14182: ,p_error_text => 'BEN_93039_EXT_TP1_TOOMANY_VALS'
14183: ,p_error_number => 93039
14184: );

Line 14309: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

14305: pqp_gb_tp_pension_extracts.g_nested_level := 0;
14306:
14307: IF l_new_sfgrade = 'INVALID' THEN
14308:
14309: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14310: (p_assignment_id => p_assignment_id
14311: ,p_error_text => 'BEN_93037_EXT_TP1_INV_SAL_SCL'
14312: ,p_error_number => 93037
14313: );

Line 14317: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

14313: );
14314:
14315: ELSIF l_new_sfgrade = 'UNKNOWN' THEN
14316:
14317: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14318: (p_assignment_id => p_assignment_id
14319: ,p_error_text => 'BEN_93038_EXT_TP1_UNK_SAL_SCL'
14320: ,p_error_number => 93038
14321: );

Line 14325: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

14321: );
14322:
14323: ELSIF l_new_sfgrade = 'TOOMANY' THEN
14324:
14325: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14326: (p_assignment_id => p_assignment_id
14327: ,p_error_text => 'BEN_93039_EXT_TP1_TOOMANY_VALS'
14328: ,p_error_number => 93039
14329: );

Line 14508: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

14504: ELSIF l_london_allowance = 'TOOMANY' THEN
14505:
14506: l_london_allowance := ' ';
14507: -- Bugfix 3516282 : Now passing assignment_id
14508: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14509: (p_assignment_id => p_assignment_id
14510: ,p_error_text => 'BEN_93032_EXT_TP1_LON_ALL_MANY'
14511: ,p_error_number => 93032
14512: );

Line 14542: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

14538: ELSIF l_sp_allowance = 'TOOMANY' THEN
14539:
14540: l_sp_allowance := '0';
14541: -- Bugfix 3516282 : Now passing assignment_id
14542: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14543: (p_assignment_id => p_assignment_id
14544: ,p_error_text => 'BEN_93034_EXT_TP1_SP_ALL_MANY'
14545: ,p_error_number => 93034
14546: );

Line 14570: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

14566: ELSIF l_contract_indicator = 'INVALID' THEN
14567:
14568: l_contract_indicator := '0';
14569: -- Bugfix 3516282 : Now passing assignment_id
14570: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14571: (p_assignment_id => p_assignment_id
14572: ,p_error_text => 'BEN_93036_EXT_TP1_INV_EMP_CAT'
14573: ,p_error_number => 93036
14574: );

Line 14592: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

14588: -- 4336613 : SAL_VALIDAT_3A : Check whether Other_All value has exceeeded 4 digit limit
14589: -- If yes, raise warning.
14590: if g_other_allowance(p_assignment_id) > 99999 then
14591:
14592: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14593: (p_assignment_id => p_assignment_id
14594: ,p_error_text => 'BEN_93043_EXT_TP1_OTH_VAL_EXC'
14595: ,p_error_number => 93043
14596: ,p_token1 => TO_CHAR(g_other_allowance(p_assignment_id)) -- bug : 4336613

Line 14647: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

14643: -- Raise a warning here if both Prorated/Retro payments exist
14644: -- for the LoS.
14645:
14646: debug('Raising Warning for RETRO/PRORATION', 260);
14647: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
14648: (p_assignment_id => p_assignment_id
14649: ,p_error_text => 'BEN_94159_EXT_TP_RETRO_PAY'
14650: ,p_error_number => 94159
14651: --,p_token1 => fnd_date.string_to_canonical(p_dtl_rec.val_13,'DDMMYY')

Line 17049: l_error := pqp_gb_tp_extract_functions.raise_extract_warning

17045:
17046: -- Raise a warning if Cross person enable = N and
17047: -- there are multiple person records.
17048: IF (g_cross_per_enabled = 'N' AND g_person_count > 0) THEN
17049: l_error := pqp_gb_tp_extract_functions.raise_extract_warning
17050: (p_assignment_id => p_assignment_id
17051: ,p_error_text => 'BEN_94022_TP1_ANTHR_TCHR_ASG'
17052: ,p_error_number => 94022
17053: );

Line 17379: l_error_value := pqp_gb_tp_extract_functions.raise_extract_error

17375: IF l_return_value IS NOT NULL THEN
17376: return l_return_value;
17377: END IF;
17378: ELSE
17379: l_error_value := pqp_gb_tp_extract_functions.raise_extract_error
17380: (p_business_group_id => g_business_group_id
17381: ,p_assignment_id => p_assignment_id
17382: ,p_error_text =>'BEN_93024_EXT_TP1_INVALID_ALOW'
17383: ,p_error_number => 93024 );