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 533: g_debug := PQP_GB_PSI_FUNCTIONS.check_debug(p_business_group_id);

529: -- clear cache
530: clear_cache;
531:
532: -- for trace switching ON/OFF
533: g_debug := PQP_GB_PSI_FUNCTIONS.check_debug(p_business_group_id);
534: -- setting shared globals
535: -- 1) paypoint
536: -- 2) cutover date
537: -- 3) extract def id

Line 538: PQP_GB_PSI_FUNCTIONS.set_shared_globals

534: -- setting shared globals
535: -- 1) paypoint
536: -- 2) cutover date
537: -- 3) extract def id
538: PQP_GB_PSI_FUNCTIONS.set_shared_globals
539: (p_business_group_id => p_business_group_id
540: ,p_paypoint => g_paypoint -- OUT
541: ,p_cutover_date => g_cutover_date -- OUT
542: ,p_ext_dfn_id => g_ext_dfn_id -- OUT

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

553: g_legislation_code := 'GB';
554:
555: debug('now raise setup exceptions ...',15);
556: -- raise setup errors and warnings
557: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions(p_extract_type => 'S');
558:
559: END IF; --IF g_business_group_id IS NULL
560:
561: g_current_run := 'PERIODIC';

Line 569: PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria

565:
566: debug('calling the basic criteria for this person assignment');
567: -- calling the basic criteria for this person assignment
568: l_return :=
569: PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria
570: (p_business_group_id => p_business_group_id
571: ,p_effective_date => p_effective_date
572: ,p_assignment_id => p_assignment_id
573: ,p_person_dtl => g_person_dtl

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

603: -- For Bug 6082338
604: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
605: l_chg_column_name := g_pay_proc_evt_tab(l_curr_evt_index).column_name;
606: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
607: l_chg_table_name := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);
608:
609: IF (l_chg_table_name = 'PER_ASSIGNMENT_BUDGET_VALUES_F'
610: AND
611: l_chg_column_name = 'EFFECTIVE_END_DATE'

Line 697: l_return := pqp_gb_psi_functions.include_event

693: debug_exit(l_proc_name);
694: return l_return;
695: END IF;
696:
697: l_return := pqp_gb_psi_functions.include_event
698: (p_actual_date => g_pay_proc_evt_tab(l_curr_evt_index).actual_date
699: ,p_effective_date => g_pay_proc_evt_tab(l_curr_evt_index).effective_date
700: );
701:

Line 702: pqp_gb_psi_functions.process_retro_event();

698: (p_actual_date => g_pay_proc_evt_tab(l_curr_evt_index).actual_date
699: ,p_effective_date => g_pay_proc_evt_tab(l_curr_evt_index).effective_date
700: );
701:
702: pqp_gb_psi_functions.process_retro_event();
703:
704: debug ('p_assignment_id:'||p_assignment_id);
705: debug('include_event returned: '||l_return);
706:

Line 711: pqp_gb_psi_functions.g_effective_date := p_effective_date;

707: END IF;
708:
709:
710: -- IF l_return <> 'N' THEN
711: pqp_gb_psi_functions.g_effective_date := p_effective_date;
712:
713: -- set assignment globals
714: IF g_assignment_id IS NULL
715: OR p_assignment_id <> nvl(g_assignment_id,0) THEN

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

756: l_return NUMBER;
757: BEGIN
758: debug_enter(l_proc_name);
759:
760: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id) THEN
761: g_allowance_code
762: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).eei_information2;
763: ELSE
764: g_allowance_code := ' ';

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

758: debug_enter(l_proc_name);
759:
760: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id) THEN
761: g_allowance_code
762: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).eei_information2;
763: ELSE
764: g_allowance_code := ' ';
765: END IF;
766:

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

763: ELSE
764: g_allowance_code := ' ';
765: END IF;
766:
767: IF NOT pqp_gb_psi_functions.is_alphanumeric(g_allowance_code) THEN
768: debug('ERROR: the allowance code is non-alphanumeric',20);
769: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
770: (p_error_number => 94557
771: ,p_error_text => 'BEN_94557_INVALID_CODE'

Line 769: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error

765: END IF;
766:
767: IF NOT pqp_gb_psi_functions.is_alphanumeric(g_allowance_code) THEN
768: debug('ERROR: the allowance code is non-alphanumeric',20);
769: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
770: (p_error_number => 94557
771: ,p_error_text => 'BEN_94557_INVALID_CODE'
772: ,p_token1 => 'Allowance'
773: ,p_token2 =>

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

770: (p_error_number => 94557
771: ,p_error_text => 'BEN_94557_INVALID_CODE'
772: ,p_token1 => 'Allowance'
773: ,p_token2 =>
774: PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name
775: ,p_token3 => g_allowance_code
776: );
777: END IF;
778:

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

815: from pay_element_entries_f pee, pay_element_type_extra_info petei
816: where pee.assignment_id = p_assignment_id
817: and pee.element_type_id = petei.element_type_id
818: and p_effective_date between pee.effective_start_date and pee.effective_end_date
819: and pee.element_entry_id <> PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id
820: and petei.information_type = 'PQP_GB_PENSERV_ALLOWANCE_INFO'
821: and petei.eei_information2 = g_allowance_code
822: and rownum=1;
823:

Line 841: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

837:
838: IF l_result = 1
839: THEN
840: debug('WARNING: Duplicate Allowance Type on same date');
841: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
842: (p_error_number => 94595
843: ,p_error_text => 'BEN_94595_DUP_ALLOW_TYPE'
844: ,p_token1 => to_char(p_effective_date,'dd/mm/yyyy')
845: );

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

875: l_proc_name varchar2(72) := g_proc_name||'get_allowance_ind_flag';
876: BEGIN
877: debug_enter(l_proc_name);
878:
879: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id) THEN
880: p_output
881: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).eei_information5;
882: END IF;
883:

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

877: debug_enter(l_proc_name);
878:
879: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id) THEN
880: p_output
881: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).eei_information5;
882: END IF;
883:
884: IF p_output IS NULL
885: THEN

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

922: l_custom_function VARCHAR2(100) := 'get_user_notional_pay';
923: BEGIN
924: debug_enter(l_proc_name);
925:
926: debug('PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id : '||PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id,10);
927:
928: IF g_is_spread_bonus_yn = 'N' THEN
929: IF g_allowance_end_dated_today <> 'Y'
930: THEN

Line 931: l_include := PQP_GB_PSI_FUNCTIONS.get_notional_pay

927:
928: IF g_is_spread_bonus_yn = 'N' THEN
929: IF g_allowance_end_dated_today <> 'Y'
930: THEN
931: l_include := PQP_GB_PSI_FUNCTIONS.get_notional_pay
932: (p_assignment_id => p_assignment_id -- IN NUMBER
933: ,p_business_group_id => p_business_group_id -- IN NUMBER
934: ,p_effective_date => p_effective_date -- IN DATE
935: ,p_name =>

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

932: (p_assignment_id => p_assignment_id -- IN NUMBER
933: ,p_business_group_id => p_business_group_id -- IN NUMBER
934: ,p_effective_date => p_effective_date -- IN DATE
935: ,p_name =>
936: PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name
937: -- IN VARCHAR2
938: ,p_rt_element => 'E'
939: ,p_rate => p_output -- OUT
940: ,p_custom_function => g_user_rate_function -- IN VARCHAR2 DEFAULT NULL

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

938: ,p_rt_element => 'E'
939: ,p_rate => p_output -- OUT
940: ,p_custom_function => g_user_rate_function -- IN VARCHAR2 DEFAULT NULL
941: ,p_allowance_code => g_allowance_code -- IN VARCHAR2 DEFAULT NULL
942: ,p_allowance_pet_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id -- IN NUMBER DEFAULT NULL
943: );
944:
945: ELSE
946: p_output := '0';

Line 949: p_output := pqp_gb_psi_functions.get_element_payment

945: ELSE
946: p_output := '0';
947: END IF;
948: ELSE
949: p_output := pqp_gb_psi_functions.get_element_payment
950: (p_assignment_id => p_assignment_id
951: ,p_element_entry_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id
952: ,p_element_type_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id
953: ,p_effective_date => p_effective_date

Line 951: ,p_element_entry_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id

947: END IF;
948: ELSE
949: p_output := pqp_gb_psi_functions.get_element_payment
950: (p_assignment_id => p_assignment_id
951: ,p_element_entry_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id
952: ,p_element_type_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id
953: ,p_effective_date => p_effective_date
954: );
955:

Line 952: ,p_element_type_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id

948: ELSE
949: p_output := pqp_gb_psi_functions.get_element_payment
950: (p_assignment_id => p_assignment_id
951: ,p_element_entry_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id
952: ,p_element_type_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id
953: ,p_effective_date => p_effective_date
954: );
955:
956: END IF;

Line 1001: l_include := PQP_GB_PSI_FUNCTIONS.get_actual_pay

997:
998: IF g_is_spread_bonus_yn = 'N' THEN
999: IF g_allowance_end_dated_today <> 'Y'
1000: THEN
1001: l_include := PQP_GB_PSI_FUNCTIONS.get_actual_pay
1002: (
1003: p_assignment_id => p_assignment_id -- IN NUMBER
1004: ,p_notional_pay => g_notional_rate -- IN NUMBER
1005: ,p_effective_date => p_effective_date -- IN DATE

Line 1055: IF PQP_GB_PSI_FUNCTIONS.g_salary_ended_today = 'Y'

1051: BEGIN
1052: debug_enter(l_proc_name);
1053:
1054:
1055: IF PQP_GB_PSI_FUNCTIONS.g_salary_ended_today = 'Y'
1056: OR PQP_GB_PSI_FUNCTIONS.g_allowance_has_end_dated = 'Y'
1057: THEN
1058: g_allowance_end_dated_today := 'Y';
1059: ELSE

Line 1056: OR PQP_GB_PSI_FUNCTIONS.g_allowance_has_end_dated = 'Y'

1052: debug_enter(l_proc_name);
1053:
1054:
1055: IF PQP_GB_PSI_FUNCTIONS.g_salary_ended_today = 'Y'
1056: OR PQP_GB_PSI_FUNCTIONS.g_allowance_has_end_dated = 'Y'
1057: THEN
1058: g_allowance_end_dated_today := 'Y';
1059: ELSE
1060: g_allowance_end_dated_today := 'N';

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

1059: ELSE
1060: g_allowance_end_dated_today := 'N';
1061: END IF;
1062:
1063: debug('PQP_GB_PSI_FUNCTIONS.g_salary_ended_today :' || PQP_GB_PSI_FUNCTIONS.g_salary_ended_today,20);
1064: debug('PQP_GB_PSI_FUNCTIONS.g_allowance_has_end_dated :' || PQP_GB_PSI_FUNCTIONS.g_allowance_has_end_dated,20);
1065: debug('g_allowance_end_dated_today :' || g_allowance_end_dated_today,20);
1066: debug('p_effective_date :' || p_effective_date,20);
1067:

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

1060: g_allowance_end_dated_today := 'N';
1061: END IF;
1062:
1063: debug('PQP_GB_PSI_FUNCTIONS.g_salary_ended_today :' || PQP_GB_PSI_FUNCTIONS.g_salary_ended_today,20);
1064: debug('PQP_GB_PSI_FUNCTIONS.g_allowance_has_end_dated :' || PQP_GB_PSI_FUNCTIONS.g_allowance_has_end_dated,20);
1065: debug('g_allowance_end_dated_today :' || g_allowance_end_dated_today,20);
1066: debug('p_effective_date :' || p_effective_date,20);
1067:
1068:

Line 1090: (p_element_entry_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id

1086: END IF;
1087: --For Bug 7149468:End
1088: ELSE
1089: OPEN csr_get_start_date_cut
1090: (p_element_entry_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id
1091: );
1092: FETCH csr_get_start_date_cut INTO l_start_date;
1093: IF csr_get_start_date_cut%NOTFOUND
1094: THEN

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

1225: IF p_rule_parameter = 'AllowanceStartDate' THEN
1226: -- setting some globals which need to be set for the 1st data element
1227: -- and to be used by later data elements
1228:
1229: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id) THEN
1230: g_is_spread_bonus_yn
1231: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).eei_information6;
1232: END IF;
1233:

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

1227: -- and to be used by later data elements
1228:
1229: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id) THEN
1230: g_is_spread_bonus_yn
1231: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).eei_information6;
1232: END IF;
1233:
1234: IF g_is_spread_bonus_yn IS NULL
1235: THEN

Line 1242: ,c_element_entry_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id

1238:
1239: IF g_is_spread_bonus_yn = 'Y' THEN
1240: OPEN csr_get_entry_value
1241: (c_effective_date => p_effective_date
1242: ,c_element_entry_id => PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id
1243: ,c_input_value => 'CLAIM DATE' -- DEFAULT 'PAY VALUE'
1244: );
1245: FETCH csr_get_entry_value INTO g_claim_date;
1246: IF csr_get_entry_value%NOTFOUND

Line 1249: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1245: FETCH csr_get_entry_value INTO g_claim_date;
1246: IF csr_get_entry_value%NOTFOUND
1247: OR g_claim_date IS NULL
1248: THEN
1249: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1250: (p_error_number => 94532
1251: ,p_error_text => 'BEN_94532_NO_ENTRY_VALUE'
1252: ,p_token1 =>
1253: pqp_gb_psi_functions.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name

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

1249: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1250: (p_error_number => 94532
1251: ,p_error_text => 'BEN_94532_NO_ENTRY_VALUE'
1252: ,p_token1 =>
1253: pqp_gb_psi_functions.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name
1254: || '(Spread Bonus)'
1255: ,p_token2 => 'CLAIM DATE'
1256: ,p_token3 => to_char(p_effective_date,'DD/MM/YYYY')
1257: );

Line 1295: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1291: -- !!! IMP - new error message
1292: IF p_output IS NULL THEN
1293: -- raise error that the bonus amount is null and value will not be reported.
1294: debug('ERROR: No Allowance Amount');
1295: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1296: (p_error_number => 94566
1297: ,p_error_text => 'BEN_94566_NO_ALLOWANCE_AMOUNT'
1298: ,p_token1 =>
1299: PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name

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

1295: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1296: (p_error_number => 94566
1297: ,p_error_text => 'BEN_94566_NO_ALLOWANCE_AMOUNT'
1298: ,p_token1 =>
1299: PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name
1300: ,p_token2 => to_char(p_effective_date,'dd/mm/yyyy')
1301: );
1302:
1303: -- bugfix 5055150

Line 1310: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1306:
1307: ELSIF NOT ( l_output_value >= -999999.99 AND l_output_value <= 9999999.99 ) THEN
1308: -- raise error that the bonus amount is out of range
1309: debug('ERROR: Allowance Amount out of range: '||p_output,20);
1310: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1311: (p_error_number => 94568
1312: ,p_error_text => 'BEN_94568_INV_ALLOWANCE_AMOUNT'
1313: ,p_token1 =>
1314: PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name

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

1310: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1311: (p_error_number => 94568
1312: ,p_error_text => 'BEN_94568_INV_ALLOWANCE_AMOUNT'
1313: ,p_token1 =>
1314: PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(PQP_GB_PSI_FUNCTIONS.g_curr_element_type_id).element_name
1315: ,p_token2 => to_char(p_effective_date,'dd/mm/yyyy')
1316: ,p_token3 => p_output
1317: );
1318: END IF;

Line 1355: p_output := PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id;

1351: p_output := rtrim(ltrim(to_char(l_output_value,'099999999D99')));
1352: END IF;
1353:
1354: ELSIF p_rule_parameter = 'AllowanceEEId' THEN
1355: p_output := PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id;
1356:
1357: ELSE
1358: p_output := '';
1359: END IF;

Line 1398: PQP_GB_PSI_FUNCTIONS.common_post_process(g_business_group_id);

1394: BEGIN -- basic_data_post_proc_rule
1395:
1396: debug_enter(l_proc_name);
1397:
1398: PQP_GB_PSI_FUNCTIONS.common_post_process(g_business_group_id);
1399:
1400: debug_exit(l_proc_name);
1401: RETURN 'Y';
1402: