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

Line 133: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions

129:
130: ELSE
131: debug('ERROR: Configration value is not present',20);
132: -- raise error
133: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions
134: (p_extract_type => 'BONUS HISTORY'
135: ,p_error_number => 94639
136: ,p_error_text => 'BEN_94639_NO_BON_BAL_CONFIG'
137: ,p_error_warning_flag => 'E'

Line 182: PQP_GB_PSI_FUNCTIONS.get_elements_of_info_type

178: -- set the bonus balance type id from the configuration
179: set_bonus_balance_type;
180:
181: -- set the globals in pqp_gb_psi_function for all valid bonus types.
182: PQP_GB_PSI_FUNCTIONS.get_elements_of_info_type
183: (p_information_type => 'PQP_GB_PENSERV_BONUS_INFO'
184: ,p_input_value_mandatory_yn => 'N'
185: );
186:

Line 248: g_person_id := PQP_GB_PSI_FUNCTIONS.get_current_extract_person

244:
245: -- set global assignment_id
246: g_assignment_id := p_assignment_id;
247: debug('g_assignment_id: '||g_assignment_id,10);
248: g_person_id := PQP_GB_PSI_FUNCTIONS.get_current_extract_person
249: (
250: p_assignment_id => p_assignment_id
251: );
252: --set the assignment start date

Line 293: l_curr_bon_code := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).eei_information2;

289: debug_enter(l_proc);
290:
291: -----
292: l_effective_date_no := to_char(p_effective_date,'ddmmyyyy');
293: l_curr_bon_code := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).eei_information2;
294:
295: debug('l_effective_date_no: '||l_effective_date_no);
296: debug('l_curr_bon_code: '||l_curr_bon_code);
297: debug('g_curr_element_entry_id: '||g_curr_element_entry_id);

Line 315: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

311: -- found a similar bonus code with for a different element entry
312: -- raise a warning;
313: debug('found a similar bonus code with for a different element entry');
314: debug('WARNING: Duplicate Bonus Type on same date');
315: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
316: (p_error_number => 94526
317: ,p_error_text => 'BEN_94526_DUP_BON_TYPE'
318: ,p_token1 => to_char(p_effective_date,'dd/mm/yyyy')
319: );

Line 438: PQP_GB_PSI_FUNCTIONS.check_if_element_qualifies

434: debug('g_curr_ee_start_date: '||g_curr_ee_start_date,10);
435: debug('g_curr_ee_end_date: '||g_curr_ee_end_date,10);
436:
437: IF g_current_layout = 'PERIODIC' THEN
438: PQP_GB_PSI_FUNCTIONS.check_if_element_qualifies
439: (p_element_entry_id => g_curr_element_entry_id
440: ,p_element_type_id => g_curr_element_type_id
441: ,p_include => l_include
442: );

Line 450: -- use to check before the call pqp_gb_psi_functions.process_retro_event

446: debug('Returning FALSE',30);
447:
448: --For BUG 5998129
449: -- Setting the No flag for the elements of non bonus type
450: -- use to check before the call pqp_gb_psi_functions.process_retro_event
451: l_element_of_bonus_type := 'N';
452: --END For BUG 5998129
453:
454: debug_exit(l_proc);

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

455: RETURN FALSE;
456: END IF;
457: END IF; --g_current_layout = 'PERIODIC' THEN
458:
459: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(g_curr_element_type_id) THEN
460:
461: g_curr_element_type_name
462: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).element_name;
463: --check if non-recurring element

Line 462: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).element_name;

458:
459: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(g_curr_element_type_id) THEN
460:
461: g_curr_element_type_name
462: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).element_name;
463: --check if non-recurring element
464: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).processing_type = 'R' THEN
465: debug('ERROR: Recurring element, will not be processed.',30);
466: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error --Bug fix 5015173

Line 464: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).processing_type = 'R' THEN

460:
461: g_curr_element_type_name
462: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).element_name;
463: --check if non-recurring element
464: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).processing_type = 'R' THEN
465: debug('ERROR: Recurring element, will not be processed.',30);
466: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error --Bug fix 5015173
467: (p_error_number => 94530
468: ,p_error_text => 'BEN_94530_REC_BON_ELEMENT'

Line 466: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error --Bug fix 5015173

462: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).element_name;
463: --check if non-recurring element
464: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).processing_type = 'R' THEN
465: debug('ERROR: Recurring element, will not be processed.',30);
466: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error --Bug fix 5015173
467: (p_error_number => 94530
468: ,p_error_text => 'BEN_94530_REC_BON_ELEMENT'
469: ,p_token1 =>
470: pqp_gb_psi_functions.g_elements_of_info_type(g_curr_element_type_id).element_name

Line 470: pqp_gb_psi_functions.g_elements_of_info_type(g_curr_element_type_id).element_name

466: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error --Bug fix 5015173
467: (p_error_number => 94530
468: ,p_error_text => 'BEN_94530_REC_BON_ELEMENT'
469: ,p_token1 =>
470: pqp_gb_psi_functions.g_elements_of_info_type(g_curr_element_type_id).element_name
471: );
472: debug('Returning FALSE',30);
473: debug_exit(l_proc);
474: RETURN FALSE;

Line 480: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).eei_information4 <> 'Y' THEN

476: debug('Is a non-recurring element',20);
477: END IF;
478:
479: --check if pensionable bonus
480: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).eei_information4 <> 'Y' THEN
481: debug('ERROR: Not a Pensionable Bonus, will not be processed.',30);
482: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
483: (p_error_number => 94527
484: ,p_error_text => 'BEN_94527_NOT_PEN_BONUS'

Line 482: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error

478:
479: --check if pensionable bonus
480: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).eei_information4 <> 'Y' THEN
481: debug('ERROR: Not a Pensionable Bonus, will not be processed.',30);
482: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
483: (p_error_number => 94527
484: ,p_error_text => 'BEN_94527_NOT_PEN_BONUS'
485: ,p_token1 =>
486: pqp_gb_psi_functions.g_elements_of_info_type(g_curr_element_type_id).element_name

Line 486: pqp_gb_psi_functions.g_elements_of_info_type(g_curr_element_type_id).element_name

482: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
483: (p_error_number => 94527
484: ,p_error_text => 'BEN_94527_NOT_PEN_BONUS'
485: ,p_token1 =>
486: pqp_gb_psi_functions.g_elements_of_info_type(g_curr_element_type_id).element_name
487: );
488: debug('Returning FALSE',30);
489: debug_exit(l_proc);
490: RETURN FALSE;

Line 552: g_debug := pqp_gb_psi_functions.check_debug(to_char(g_business_group_id));

548: OR p_business_group_id <> nvl(g_business_group_id,0) THEN
549:
550: g_business_group_id := p_business_group_id;
551: -- set the global debug value
552: g_debug := pqp_gb_psi_functions.check_debug(to_char(g_business_group_id));
553: debug_enter(l_proc);
554: debug('Inputs are: ');
555: debug('p_business_group_id: '||p_business_group_id);
556: debug('p_assignment_id: '||p_assignment_id);

Line 559: PQP_GB_PSI_FUNCTIONS.set_shared_globals

555: debug('p_business_group_id: '||p_business_group_id);
556: debug('p_assignment_id: '||p_assignment_id);
557: debug('p_effective_date: '||to_char(p_effective_date,'dd/mm/yyyy'));
558:
559: PQP_GB_PSI_FUNCTIONS.set_shared_globals
560: (p_business_group_id => p_business_group_id
561: ,p_paypoint => g_paypoint
562: ,p_cutover_date => l_cutover_date
563: ,p_ext_dfn_id => g_ext_dfn_id

Line 577: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions('S');

573: );
574:
575: --Raise extract exceptions which are stored while checking for the setup
576: debug('Raising the set-up errors, with input parameter as S',10);
577: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions('S');
578: END IF; --IF g_business_group_id IS NULL
579:
580: IF l_include <> 'N' THEN
581:

Line 586: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria

582: IF g_assignment_id IS NULL
583: OR p_assignment_id <> nvl(g_assignment_id,0) THEN
584:
585: -- dummy call to basic criteria to set the globals in common package.
586: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria
587: (p_business_group_id => p_business_group_id
588: ,p_effective_date => p_effective_date
589: ,p_assignment_id => p_assignment_id
590: ,p_person_dtl => g_curr_person_dtls

Line 606: pqp_gb_psi_functions.g_effective_date := p_effective_date;

602: END IF;
603:
604: END IF; --IF l_include <> 'N' THEN
605:
606: pqp_gb_psi_functions.g_effective_date := p_effective_date;
607:
608: debug('l_include: '||l_include);
609: debug_exit(l_proc);
610: RETURN l_include;

Line 669: g_debug := pqp_gb_psi_functions.check_debug(to_char(g_business_group_id));

665: OR p_business_group_id <> nvl(g_business_group_id,0) THEN
666:
667: g_business_group_id := p_business_group_id;
668: -- set the global debug value
669: g_debug := pqp_gb_psi_functions.check_debug(to_char(g_business_group_id));
670: debug_enter(l_proc);
671: debug('Inputs are: ');
672: debug('p_business_group_id: '||p_business_group_id);
673: debug('p_assignment_id: '||p_assignment_id);

Line 676: PQP_GB_PSI_FUNCTIONS.set_shared_globals

672: debug('p_business_group_id: '||p_business_group_id);
673: debug('p_assignment_id: '||p_assignment_id);
674: debug('p_effective_date: '||to_char(p_effective_date,'dd/mm/yyyy'));
675:
676: PQP_GB_PSI_FUNCTIONS.set_shared_globals
677: (p_business_group_id => p_business_group_id
678: ,p_paypoint => g_paypoint
679: ,p_cutover_date => l_cutover_date
680: ,p_ext_dfn_id => g_ext_dfn_id

Line 691: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions('S');

687: ,p_effective_date => p_effective_date
688: );
689: --Raise extract exceptions which are stored while checking for the setup
690: debug('Raising the set-up errors, with input parameter as S',10);
691: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions('S');
692: END IF; --IF g_business_group_id IS NULL
693:
694: IF l_include <> 'N' THEN
695:

Line 700: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria

696: IF g_assignment_id IS NULL
697: OR p_assignment_id <> nvl(g_assignment_id,0) THEN
698:
699: -- dummy call to basic criteria to set the globals in common package.
700: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria
701: (p_business_group_id => p_business_group_id
702: ,p_effective_date => p_effective_date
703: ,p_assignment_id => p_assignment_id
704: ,p_person_dtl => g_curr_person_dtls

Line 732: l_include := pqp_gb_psi_functions.include_event

728: debug('l_bon_curr_evt_index : '||l_bon_curr_evt_index);
729:
730: FOR i in l_bon_curr_evt_index..g_pay_proc_evt_tab.count
731: LOOP
732: l_include := pqp_gb_psi_functions.include_event
733: (p_actual_date => g_pay_proc_evt_tab(i).actual_date
734: ,p_effective_date => g_pay_proc_evt_tab(i).effective_date
735: );
736:

Line 737: IF l_include = 'Y' -- AND PQP_GB_PSI_FUNCTIONS.g_min_eff_date_exists = 'Y'

733: (p_actual_date => g_pay_proc_evt_tab(i).actual_date
734: ,p_effective_date => g_pay_proc_evt_tab(i).effective_date
735: );
736:
737: IF l_include = 'Y' -- AND PQP_GB_PSI_FUNCTIONS.g_min_eff_date_exists = 'Y'
738: THEN
739:
740: -- if retro event was found, store retro date details in globals
741: IF PQP_GB_PSI_FUNCTIONS.g_min_eff_date_exists = 'Y'

Line 741: IF PQP_GB_PSI_FUNCTIONS.g_min_eff_date_exists = 'Y'

737: IF l_include = 'Y' -- AND PQP_GB_PSI_FUNCTIONS.g_min_eff_date_exists = 'Y'
738: THEN
739:
740: -- if retro event was found, store retro date details in globals
741: IF PQP_GB_PSI_FUNCTIONS.g_min_eff_date_exists = 'Y'
742: THEN
743: debug('first retro event found');
744: -- retro event
745: l_bon_effective_date := g_pay_proc_evt_tab(i).effective_date; --p_effective_date;

Line 798: PQP_GB_PSI_FUNCTIONS.g_min_effective_date(g_assignment_id) := g_first_retro_event_start;

794: IF g_first_retro_event IS NOT NULL
795: THEN
796:
797: -- for use by process_retro_event function
798: PQP_GB_PSI_FUNCTIONS.g_min_effective_date(g_assignment_id) := g_first_retro_event_start;
799:
800: -- reject all events till start of retro-event-month
801: IF (g_pay_proc_evt_tab(l_curr_evt_index).effective_date < g_first_retro_event_start)
802: THEN

Line 810: l_include := pqp_gb_psi_functions.include_event

806: l_include := 'Y';
807: ELSE -- include event has to be called here onwards
808:
809: debug('Calling the common include event proc');
810: l_include := pqp_gb_psi_functions.include_event
811: (p_actual_date => g_pay_proc_evt_tab(l_curr_evt_index).actual_date
812: ,p_effective_date => g_pay_proc_evt_tab(l_curr_evt_index).effective_date
813: );
814: debug('include_event returned: '||l_include);

Line 832: l_include := pqp_gb_psi_functions.include_event

828:
829: ELSE -- include event has to be called here onwards
830:
831: debug('Calling the common include event proc');
832: l_include := pqp_gb_psi_functions.include_event
833: (p_actual_date => g_pay_proc_evt_tab(l_curr_evt_index).actual_date
834: ,p_effective_date => g_pay_proc_evt_tab(l_curr_evt_index).effective_date
835: );
836: debug('include_event returned: '||l_include);

Line 873: pqp_gb_psi_functions.g_effective_date := p_effective_date;

869: --END For BUG 5998129
870:
871: END IF; --IF l_include <> 'N' THEN
872:
873: pqp_gb_psi_functions.g_effective_date := p_effective_date;
874:
875: --For BUG 5998129
876: debug('l_element_of_bonus_type: '||l_element_of_bonus_type);
877: IF g_first_retro_event_start IS NOT NULL

Line 881: pqp_gb_psi_functions.process_retro_event(l_include);

877: IF g_first_retro_event_start IS NOT NULL
878: THEN
879: IF l_element_of_bonus_type = 'Y' AND p_effective_date >= g_first_retro_event_start
880: THEN
881: pqp_gb_psi_functions.process_retro_event(l_include);
882: END IF;
883: END IF;
884: --END For BUG 5998129
885:

Line 956: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error

952: CLOSE csr_get_claim_date;
953:
954: IF l_date_char IS null THEN
955: -- raise error - no claim date value
956: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
957: (p_error_number => 94683
958: ,p_error_text => 'BEN_94683_BON_NO_CLM_DT_VAL'
959: ,p_token1 =>
960: pqp_gb_psi_functions.g_elements_of_info_type(g_curr_element_type_id).element_name

Line 960: pqp_gb_psi_functions.g_elements_of_info_type(g_curr_element_type_id).element_name

956: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
957: (p_error_number => 94683
958: ,p_error_text => 'BEN_94683_BON_NO_CLM_DT_VAL'
959: ,p_token1 =>
960: pqp_gb_psi_functions.g_elements_of_info_type(g_curr_element_type_id).element_name
961: ,p_token2 => to_char(g_effective_date,'dd/mm/yyyy')
962: );
963: ELSE
964: --

Line 966: IF pqp_gb_psi_functions.is_proper_claim_date

962: );
963: ELSE
964: --
965: l_claim_date := fnd_date.canonical_to_date(l_date_char);
966: IF pqp_gb_psi_functions.is_proper_claim_date
967: (l_claim_date
968: ,g_curr_element_type_name
969: ,g_curr_element_entry_id
970: ,g_assg_start_date

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

1007: l_return NUMBER;
1008: BEGIN
1009: debug_enter(l_proc);
1010:
1011: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(g_curr_element_type_id) THEN
1012: p_output_value
1013: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).eei_information2;
1014: END IF;
1015:

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

1009: debug_enter(l_proc);
1010:
1011: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(g_curr_element_type_id) THEN
1012: p_output_value
1013: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).eei_information2;
1014: END IF;
1015:
1016: IF NOT pqp_gb_psi_functions.is_alphanumeric(p_output_value) THEN
1017: -- Bug Fix 5015236

Line 1016: IF NOT pqp_gb_psi_functions.is_alphanumeric(p_output_value) THEN

1012: p_output_value
1013: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).eei_information2;
1014: END IF;
1015:
1016: IF NOT pqp_gb_psi_functions.is_alphanumeric(p_output_value) THEN
1017: -- Bug Fix 5015236
1018: debug('ERROR: the bonus code is non-alphanumeric',20);
1019: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1020: (p_error_number => 94557

Line 1019: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1015:
1016: IF NOT pqp_gb_psi_functions.is_alphanumeric(p_output_value) THEN
1017: -- Bug Fix 5015236
1018: debug('ERROR: the bonus code is non-alphanumeric',20);
1019: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1020: (p_error_number => 94557
1021: ,p_error_text => 'BEN_94557_INVALID_CODE'
1022: ,p_token1 => 'Bonus'
1023: ,p_token2 =>

Line 1024: pqp_gb_psi_functions.g_elements_of_info_type(g_curr_element_type_id).element_name

1020: (p_error_number => 94557
1021: ,p_error_text => 'BEN_94557_INVALID_CODE'
1022: ,p_token1 => 'Bonus'
1023: ,p_token2 =>
1024: pqp_gb_psi_functions.g_elements_of_info_type(g_curr_element_type_id).element_name
1025: ,p_token3 => p_output_value
1026: );
1027: END IF;
1028:

Line 1062: l_bonus_amount := pqp_gb_psi_functions.get_element_payment_balance

1058: l_bonus_amount NUMBER;
1059: BEGIN
1060: debug_enter(l_proc);
1061:
1062: l_bonus_amount := pqp_gb_psi_functions.get_element_payment_balance
1063: (p_assignment_id => g_assignment_id
1064: ,p_element_entry_id => g_curr_element_entry_id
1065: ,p_element_type_id => g_curr_element_type_id
1066: ,p_balance_type_id => g_bon_bal_type_id

Line 1069: /*l_bonus_amount := pqp_gb_psi_functions.get_element_payment

1065: ,p_element_type_id => g_curr_element_type_id
1066: ,p_balance_type_id => g_bon_bal_type_id
1067: ,p_effective_date => g_effective_date
1068: );
1069: /*l_bonus_amount := pqp_gb_psi_functions.get_element_payment
1070: (p_assignment_id => g_assignment_id
1071: ,p_element_entry_id => g_curr_element_entry_id
1072: ,p_element_type_id => g_curr_element_type_id
1073: ,p_effective_date => g_effective_date

Line 1078: l_include := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1074: );*/
1075: IF l_bonus_amount IS NULL THEN
1076: -- raise error that the bonus amount is null and value will not be reported.
1077: debug('ERROR: No Bonus Amount',20);
1078: l_include := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1079: (p_error_number => 94531
1080: ,p_error_text => 'BEN_94531_NO_BONUS_AMOUNT'
1081: ,p_token1 => g_curr_element_type_name
1082: ||'('||g_curr_element_entry_id||')'

Line 1089: l_include := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1085: ELSIF NOT ( l_bonus_amount >= -99999999.99 AND l_bonus_amount <= 999999999.99 ) THEN
1086: -- raise error that the bonus amount is out of range
1087: -- bug fix 4998232
1088: debug('ERROR: Bonus Amount out of range: '||l_bonus_amount,20);
1089: l_include := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1090: (p_error_number => 94567
1091: ,p_error_text => 'BEN_94567_INVALID_BONUS_AMOUNT'
1092: ,p_token1 => g_curr_element_type_name
1093: ||'('||g_curr_element_entry_id||')'

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

1134: l_proc varchar2(72) := g_package||'.get_ind_flag';
1135: BEGIN
1136: debug_enter(l_proc);
1137:
1138: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(g_curr_element_type_id) THEN
1139: p_output_value
1140: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).eei_information5;
1141: END IF;
1142:

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

1136: debug_enter(l_proc);
1137:
1138: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(g_curr_element_type_id) THEN
1139: p_output_value
1140: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).eei_information5;
1141: END IF;
1142:
1143: debug_exit(l_proc);
1144: return 0;

Line 1284: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();

1280: BEGIN
1281: debug_enter(l_proc);
1282:
1283: --Raise extract exceptions which are stored while processing the data elements
1284: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();
1285:
1286: PQP_GB_PSI_FUNCTIONS.common_post_process(g_business_group_id);
1287:
1288: debug_exit(l_proc);

Line 1286: PQP_GB_PSI_FUNCTIONS.common_post_process(g_business_group_id);

1282:
1283: --Raise extract exceptions which are stored while processing the data elements
1284: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();
1285:
1286: PQP_GB_PSI_FUNCTIONS.common_post_process(g_business_group_id);
1287:
1288: debug_exit(l_proc);
1289: return 'Y';
1290: EXCEPTION