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_PSI_ALLOWANCE_HISTORY dependencies on PQP_GB_PSI_FUNCTIONS

Line 189: PQP_GB_PSI_FUNCTIONS.get_elements_of_info_type

185: debug ('p_business_group_id:'||p_business_group_id);
186: debug ('p_effective_date:'||p_effective_date);
187: debug ('p_assignment_id:'||p_assignment_id);
188:
189: PQP_GB_PSI_FUNCTIONS.get_elements_of_info_type
190: (p_information_type => 'PQP_GB_PENSERV_ALLOWANCE_INFO' -- IN VARCHAR2
191: --,p_input_value => 'CLAIM DATE' -- IN VARCHAR2 DEFAULT 'PAY VALUE'
192: );
193:

Line 196: pqp_gb_psi_functions.get_rate_usr_func_name

192: );
193:
194: debug('p_business_group_id: '||p_business_group_id,10);
195:
196: pqp_gb_psi_functions.get_rate_usr_func_name
197: (
198: p_business_group_id => p_business_group_id
199: ,p_legislation_code => 'GB' -- g_legislation_code
200: ,p_interface_name => 'ALLOWANCE'

Line 262: g_person_id := PQP_GB_PSI_FUNCTIONS.get_current_extract_person

258: -- set global assignment_id
259: g_assignment_id := p_assignment_id;
260: debug('g_assignment_id: '||g_assignment_id,10);
261:
262: g_person_id := PQP_GB_PSI_FUNCTIONS.get_current_extract_person
263: (
264: p_assignment_id => p_assignment_id
265: );
266:

Line 272: PQP_GB_PSI_FUNCTIONS.init_st_end_date_glob();

268: OPEN csr_start_date;
269: FETCH csr_start_date INTO g_assg_start_date;
270: CLOSE csr_start_date;
271:
272: PQP_GB_PSI_FUNCTIONS.init_st_end_date_glob();
273:
274: debug_exit(l_proc_name);
275: EXCEPTION
276: WHEN others THEN

Line 382: g_debug := pqp_gb_psi_functions.check_debug(p_business_group_id);

378:
379: clear_cache;
380:
381: -- set the global debug value
382: g_debug := pqp_gb_psi_functions.check_debug(p_business_group_id);
383:
384: debug('Inputs are: ');
385: debug('p_business_group_id: '||p_business_group_id);
386: debug('p_assignment_id: '||p_assignment_id);

Line 389: PQP_GB_PSI_FUNCTIONS.set_shared_globals

385: debug('p_business_group_id: '||p_business_group_id);
386: debug('p_assignment_id: '||p_assignment_id);
387: debug('p_effective_date: '||to_char(p_effective_date,'dd/mm/yyyy'));
388:
389: PQP_GB_PSI_FUNCTIONS.set_shared_globals
390: (p_business_group_id => p_business_group_id
391: ,p_paypoint => g_paypoint
392: ,p_cutover_date => g_cutover_date
393: ,p_ext_dfn_id => g_ext_dfn_id

Line 408: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions(p_extract_type => 'S');

404: g_legislation_code := 'GB';
405:
406: --Raise extract exceptions which are stored while checking for the setup
407: debug('Raising the set-up errors, with input parameter as S',10);
408: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions(p_extract_type => 'S');
409:
410: END IF;
411:
412: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria

Line 412: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria

408: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions(p_extract_type => 'S');
409:
410: END IF;
411:
412: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria
413: (p_business_group_id => p_business_group_id
414: ,p_effective_date => p_effective_date
415: ,p_assignment_id => p_assignment_id
416: ,p_person_dtl => g_curr_person_dtls

Line 665: g_debug := PQP_GB_PSI_FUNCTIONS.check_debug(p_business_group_id);

661: -- clear cache
662: clear_cache;
663:
664: -- for trace switching ON/OFF
665: g_debug := PQP_GB_PSI_FUNCTIONS.check_debug(p_business_group_id);
666: -- setting shared globals
667: -- 1) paypoint
668: -- 2) cutover date
669: -- 3) extract def id

Line 670: PQP_GB_PSI_FUNCTIONS.set_shared_globals

666: -- setting shared globals
667: -- 1) paypoint
668: -- 2) cutover date
669: -- 3) extract def id
670: PQP_GB_PSI_FUNCTIONS.set_shared_globals
671: (p_business_group_id => p_business_group_id
672: ,p_paypoint => g_paypoint -- OUT
673: ,p_cutover_date => g_cutover_date -- OUT
674: ,p_ext_dfn_id => g_ext_dfn_id -- OUT

Line 689: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions(p_extract_type => 'S');

685: g_legislation_code := 'GB';
686:
687: debug('now raise setup exceptions ...',15);
688: -- raise setup errors and warnings
689: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions(p_extract_type => 'S');
690:
691: END IF; --IF g_business_group_id IS NULL
692:
693: g_current_run := 'PERIODIC';

Line 701: PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria

697:
698: debug('calling the basic criteria for this person assignment');
699: -- calling the basic criteria for this person assignment
700: l_return :=
701: PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria
702: (p_business_group_id => p_business_group_id
703: ,p_effective_date => p_effective_date
704: ,p_assignment_id => p_assignment_id
705: ,p_person_dtl => g_person_dtl

Line 739: l_chg_table_name := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);

735: -- For Bug 6082338
736: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
737: l_chg_column_name := g_pay_proc_evt_tab(l_curr_evt_index).column_name;
738: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
739: l_chg_table_name := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);
740:
741: IF (l_chg_table_name = 'PER_ASSIGNMENT_BUDGET_VALUES_F'
742: AND
743: l_chg_column_name = 'EFFECTIVE_END_DATE'

Line 842: l_return := pqp_gb_psi_functions.include_event

838: debug_exit(l_proc_name);
839: return l_return;
840: END IF;
841:
842: l_return := pqp_gb_psi_functions.include_event
843: (p_actual_date => g_pay_proc_evt_tab(l_curr_evt_index).actual_date
844: ,p_effective_date => g_pay_proc_evt_tab(l_curr_evt_index).effective_date
845: );
846:

Line 847: pqp_gb_psi_functions.process_retro_event();

843: (p_actual_date => g_pay_proc_evt_tab(l_curr_evt_index).actual_date
844: ,p_effective_date => g_pay_proc_evt_tab(l_curr_evt_index).effective_date
845: );
846:
847: pqp_gb_psi_functions.process_retro_event();
848:
849: debug ('p_assignment_id:'||p_assignment_id);
850: debug('include_event returned: '||l_return);
851:

Line 856: pqp_gb_psi_functions.g_effective_date := p_effective_date;

852: END IF;
853:
854:
855: -- IF l_return <> 'N' THEN
856: pqp_gb_psi_functions.g_effective_date := p_effective_date;
857:
858: -- set assignment globals
859: IF g_assignment_id IS NULL
860: OR p_assignment_id <> nvl(g_assignment_id,0) THEN

Line 905: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id) THEN

901: l_return NUMBER;
902: BEGIN
903: debug_enter(l_proc_name);
904:
905: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id) THEN
906: g_allowance_code
907: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).eei_information2;
908: ELSE
909: g_allowance_code := ' ';

Line 907: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).eei_information2;

903: debug_enter(l_proc_name);
904:
905: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id) THEN
906: g_allowance_code
907: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).eei_information2;
908: ELSE
909: g_allowance_code := ' ';
910: END IF;
911:

Line 912: IF NOT pqp_gb_psi_functions.is_alphanumeric(g_allowance_code) THEN

908: ELSE
909: g_allowance_code := ' ';
910: END IF;
911:
912: IF NOT pqp_gb_psi_functions.is_alphanumeric(g_allowance_code) THEN
913: debug('ERROR: the allowance code is non-alphanumeric',20);
914: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
915: (p_error_number => 94557
916: ,p_error_text => 'BEN_94557_INVALID_CODE'

Line 914: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error

910: END IF;
911:
912: IF NOT pqp_gb_psi_functions.is_alphanumeric(g_allowance_code) THEN
913: debug('ERROR: the allowance code is non-alphanumeric',20);
914: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
915: (p_error_number => 94557
916: ,p_error_text => 'BEN_94557_INVALID_CODE'
917: ,p_token1 => 'Allowance'
918: ,p_token2 =>

Line 919: PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name

915: (p_error_number => 94557
916: ,p_error_text => 'BEN_94557_INVALID_CODE'
917: ,p_token1 => 'Allowance'
918: ,p_token2 =>
919: PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name
920: ,p_token3 => g_allowance_code
921: );
922: END IF;
923:

Line 964: and pee.element_entry_id <> PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id

960: from pay_element_entries_f pee, pay_element_type_extra_info petei
961: where pee.assignment_id = p_assignment_id
962: and pee.element_type_id = petei.element_type_id
963: and p_effective_date between pee.effective_start_date and pee.effective_end_date
964: and pee.element_entry_id <> PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id
965: and petei.information_type = 'PQP_GB_PENSERV_ALLOWANCE_INFO'
966: and petei.eei_information2 = g_allowance_code
967: and rownum=1;
968:

Line 986: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

982:
983: IF l_result = 1
984: THEN
985: debug('WARNING: Duplicate Allowance Type on same date');
986: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
987: (p_error_number => 94595
988: ,p_error_text => 'BEN_94595_DUP_ALLOW_TYPE'
989: ,p_token1 => to_char(p_effective_date,'dd/mm/yyyy')
990: );

Line 1024: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id) THEN

1020: l_proc_name varchar2(72) := g_proc_name||'get_allowance_ind_flag';
1021: BEGIN
1022: debug_enter(l_proc_name);
1023:
1024: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id) THEN
1025: p_output
1026: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).eei_information5;
1027: END IF;
1028:

Line 1026: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).eei_information5;

1022: debug_enter(l_proc_name);
1023:
1024: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id) THEN
1025: p_output
1026: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).eei_information5;
1027: END IF;
1028:
1029: IF p_output IS NULL
1030: THEN

Line 1071: debug('PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id : '||PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id,10);

1067: l_custom_function VARCHAR2(100) := 'get_user_notional_pay';
1068: BEGIN
1069: debug_enter(l_proc_name);
1070:
1071: debug('PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id : '||PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id,10);
1072:
1073: IF g_is_spread_bonus_yn = 'N' THEN
1074: IF g_allowance_end_dated_today <> 'Y'
1075: THEN

Line 1076: l_include := PQP_GB_PSI_FUNCTIONS.get_notional_pay

1072:
1073: IF g_is_spread_bonus_yn = 'N' THEN
1074: IF g_allowance_end_dated_today <> 'Y'
1075: THEN
1076: l_include := PQP_GB_PSI_FUNCTIONS.get_notional_pay
1077: (p_assignment_id => p_assignment_id -- IN NUMBER
1078: ,p_business_group_id => p_business_group_id -- IN NUMBER
1079: ,p_effective_date => p_effective_date -- IN DATE
1080: ,p_name =>

Line 1081: PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name

1077: (p_assignment_id => p_assignment_id -- IN NUMBER
1078: ,p_business_group_id => p_business_group_id -- IN NUMBER
1079: ,p_effective_date => p_effective_date -- IN DATE
1080: ,p_name =>
1081: PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name
1082: -- IN VARCHAR2
1083: ,p_rt_element => 'E'
1084: ,p_rate => p_output -- OUT
1085: ,p_custom_function => g_user_rate_function -- IN VARCHAR2 DEFAULT NULL

Line 1087: ,p_allowance_pet_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id -- IN NUMBER DEFAULT NULL

1083: ,p_rt_element => 'E'
1084: ,p_rate => p_output -- OUT
1085: ,p_custom_function => g_user_rate_function -- IN VARCHAR2 DEFAULT NULL
1086: ,p_allowance_code => g_allowance_code -- IN VARCHAR2 DEFAULT NULL
1087: ,p_allowance_pet_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id -- IN NUMBER DEFAULT NULL
1088: );
1089:
1090: ELSE
1091: p_output := '0';

Line 1094: p_output := pqp_gb_psi_functions.get_element_payment

1090: ELSE
1091: p_output := '0';
1092: END IF;
1093: ELSE
1094: p_output := pqp_gb_psi_functions.get_element_payment
1095: (p_assignment_id => p_assignment_id
1096: ,p_element_entry_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id
1097: ,p_element_type_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id
1098: ,p_effective_date => p_effective_date

Line 1096: ,p_element_entry_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id

1092: END IF;
1093: ELSE
1094: p_output := pqp_gb_psi_functions.get_element_payment
1095: (p_assignment_id => p_assignment_id
1096: ,p_element_entry_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id
1097: ,p_element_type_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id
1098: ,p_effective_date => p_effective_date
1099: );
1100:

Line 1097: ,p_element_type_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id

1093: ELSE
1094: p_output := pqp_gb_psi_functions.get_element_payment
1095: (p_assignment_id => p_assignment_id
1096: ,p_element_entry_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id
1097: ,p_element_type_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id
1098: ,p_effective_date => p_effective_date
1099: );
1100:
1101: END IF;

Line 1146: l_include := PQP_GB_PSI_FUNCTIONS.get_actual_pay

1142:
1143: IF g_is_spread_bonus_yn = 'N' THEN
1144: IF g_allowance_end_dated_today <> 'Y'
1145: THEN
1146: l_include := PQP_GB_PSI_FUNCTIONS.get_actual_pay
1147: (
1148: p_assignment_id => p_assignment_id -- IN NUMBER
1149: ,p_notional_pay => g_notional_rate -- IN NUMBER
1150: ,p_effective_date => p_effective_date -- IN DATE

Line 1200: IF PQP_GB_PSI_FUNCTIONS.g_salary_ended_today = 'Y'

1196: BEGIN
1197: debug_enter(l_proc_name);
1198:
1199:
1200: IF PQP_GB_PSI_FUNCTIONS.g_salary_ended_today = 'Y'
1201: OR PQP_GB_PSI_FUNCTIONS.g_allowance_has_end_dated = 'Y'
1202: THEN
1203: g_allowance_end_dated_today := 'Y';
1204: ELSE

Line 1201: OR PQP_GB_PSI_FUNCTIONS.g_allowance_has_end_dated = 'Y'

1197: debug_enter(l_proc_name);
1198:
1199:
1200: IF PQP_GB_PSI_FUNCTIONS.g_salary_ended_today = 'Y'
1201: OR PQP_GB_PSI_FUNCTIONS.g_allowance_has_end_dated = 'Y'
1202: THEN
1203: g_allowance_end_dated_today := 'Y';
1204: ELSE
1205: g_allowance_end_dated_today := 'N';

Line 1208: debug('PQP_GB_PSI_FUNCTIONS.g_salary_ended_today :' || PQP_GB_PSI_FUNCTIONS.g_salary_ended_today,20);

1204: ELSE
1205: g_allowance_end_dated_today := 'N';
1206: END IF;
1207:
1208: debug('PQP_GB_PSI_FUNCTIONS.g_salary_ended_today :' || PQP_GB_PSI_FUNCTIONS.g_salary_ended_today,20);
1209: debug('PQP_GB_PSI_FUNCTIONS.g_allowance_has_end_dated :' || PQP_GB_PSI_FUNCTIONS.g_allowance_has_end_dated,20);
1210: debug('g_allowance_end_dated_today :' || g_allowance_end_dated_today,20);
1211: debug('p_effective_date :' || p_effective_date,20);
1212:

Line 1209: debug('PQP_GB_PSI_FUNCTIONS.g_allowance_has_end_dated :' || PQP_GB_PSI_FUNCTIONS.g_allowance_has_end_dated,20);

1205: g_allowance_end_dated_today := 'N';
1206: END IF;
1207:
1208: debug('PQP_GB_PSI_FUNCTIONS.g_salary_ended_today :' || PQP_GB_PSI_FUNCTIONS.g_salary_ended_today,20);
1209: debug('PQP_GB_PSI_FUNCTIONS.g_allowance_has_end_dated :' || PQP_GB_PSI_FUNCTIONS.g_allowance_has_end_dated,20);
1210: debug('g_allowance_end_dated_today :' || g_allowance_end_dated_today,20);
1211: debug('p_effective_date :' || p_effective_date,20);
1212:
1213:

Line 1235: (p_element_entry_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id

1231: END IF;
1232: --For Bug 7149468:End
1233: ELSE
1234: OPEN csr_get_start_date_cut
1235: (p_element_entry_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id
1236: );
1237: FETCH csr_get_start_date_cut INTO l_start_date;
1238: IF csr_get_start_date_cut%NOTFOUND
1239: THEN

Line 1378: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id) THEN

1374: IF p_rule_parameter = 'AllowanceStartDate' THEN
1375: -- setting some globals which need to be set for the 1st data element
1376: -- and to be used by later data elements
1377:
1378: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id) THEN
1379: g_is_spread_bonus_yn
1380: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).eei_information6;
1381: END IF;
1382:

Line 1380: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).eei_information6;

1376: -- and to be used by later data elements
1377:
1378: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id) THEN
1379: g_is_spread_bonus_yn
1380: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).eei_information6;
1381: END IF;
1382:
1383: IF g_is_spread_bonus_yn IS NULL
1384: THEN

Line 1391: ,c_element_entry_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id

1387:
1388: IF g_is_spread_bonus_yn = 'Y' THEN
1389: OPEN csr_get_entry_value
1390: (c_effective_date => p_effective_date
1391: ,c_element_entry_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id
1392: ,c_input_value => 'CLAIM DATE' -- DEFAULT 'PAY VALUE'
1393: );
1394: FETCH csr_get_entry_value INTO g_claim_date;
1395: IF csr_get_entry_value%NOTFOUND

Line 1398: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1394: FETCH csr_get_entry_value INTO g_claim_date;
1395: IF csr_get_entry_value%NOTFOUND
1396: OR g_claim_date IS NULL
1397: THEN
1398: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1399: (p_error_number => 94532
1400: ,p_error_text => 'BEN_94532_NO_ENTRY_VALUE'
1401: ,p_token1 =>
1402: pqp_gb_psi_functions.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name

Line 1402: pqp_gb_psi_functions.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name

1398: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1399: (p_error_number => 94532
1400: ,p_error_text => 'BEN_94532_NO_ENTRY_VALUE'
1401: ,p_token1 =>
1402: pqp_gb_psi_functions.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name
1403: || '(Spread Bonus)'
1404: ,p_token2 => 'CLAIM DATE'
1405: ,p_token3 => to_char(p_effective_date,'DD/MM/YYYY')
1406: );

Line 1444: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1440: -- !!! IMP - new error message
1441: IF p_output IS NULL THEN
1442: -- raise error that the bonus amount is null and value will not be reported.
1443: debug('ERROR: No Allowance Amount');
1444: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1445: (p_error_number => 94566
1446: ,p_error_text => 'BEN_94566_NO_ALLOWANCE_AMOUNT'
1447: ,p_token1 =>
1448: PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name

Line 1448: PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name

1444: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1445: (p_error_number => 94566
1446: ,p_error_text => 'BEN_94566_NO_ALLOWANCE_AMOUNT'
1447: ,p_token1 =>
1448: PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name
1449: ,p_token2 => to_char(p_effective_date,'dd/mm/yyyy')
1450: );
1451:
1452: -- bugfix 5055150

Line 1459: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1455:
1456: ELSIF NOT ( l_output_value >= -999999.99 AND l_output_value <= 9999999.99 ) THEN
1457: -- raise error that the bonus amount is out of range
1458: debug('ERROR: Allowance Amount out of range: '||p_output,20);
1459: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1460: (p_error_number => 94568
1461: ,p_error_text => 'BEN_94568_INV_ALLOWANCE_AMOUNT'
1462: ,p_token1 =>
1463: PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name

Line 1463: PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name

1459: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1460: (p_error_number => 94568
1461: ,p_error_text => 'BEN_94568_INV_ALLOWANCE_AMOUNT'
1462: ,p_token1 =>
1463: PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name
1464: ,p_token2 => to_char(p_effective_date,'dd/mm/yyyy')
1465: ,p_token3 => p_output
1466: );
1467: END IF;

Line 1504: p_output := PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id;

1500: p_output := rtrim(ltrim(to_char(l_output_value,'099999999D99')));
1501: END IF;
1502:
1503: ELSIF p_rule_parameter = 'AllowanceEEId' THEN
1504: p_output := PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id;
1505:
1506: ELSE
1507: p_output := '';
1508: END IF;

Line 1547: PQP_GB_PSI_FUNCTIONS.common_post_process(g_business_group_id);

1543: BEGIN -- basic_data_post_proc_rule
1544:
1545: debug_enter(l_proc_name);
1546:
1547: PQP_GB_PSI_FUNCTIONS.common_post_process(g_business_group_id);
1548:
1549: debug_exit(l_proc_name);
1550: RETURN 'Y';
1551: