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 434: PQP_GB_PSI_FUNCTIONS.check_if_element_qualifies

430: debug('g_curr_ee_start_date: '||g_curr_ee_start_date,10);
431: debug('g_curr_ee_end_date: '||g_curr_ee_end_date,10);
432:
433: IF g_current_layout = 'PERIODIC' THEN
434: PQP_GB_PSI_FUNCTIONS.check_if_element_qualifies
435: (p_element_entry_id => g_curr_element_entry_id
436: ,p_element_type_id => g_curr_element_type_id
437: ,p_include => l_include
438: );

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

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

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

451: RETURN FALSE;
452: END IF;
453: END IF; --g_current_layout = 'PERIODIC' THEN
454:
455: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(g_curr_element_type_id) THEN
456:
457: g_curr_element_type_name
458: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).element_name;
459: --check if non-recurring element

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

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

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

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

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

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

Line 466: pqp_gb_psi_functions.g_elements_of_info_type(g_curr_element_type_id).element_name

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

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

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

Line 478: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error

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

Line 482: pqp_gb_psi_functions.g_elements_of_info_type(g_curr_element_type_id).element_name

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

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

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

Line 555: PQP_GB_PSI_FUNCTIONS.set_shared_globals

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

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

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

Line 582: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria

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

Line 602: pqp_gb_psi_functions.g_effective_date := p_effective_date;

598: END IF;
599:
600: END IF; --IF l_include <> 'N' THEN
601:
602: pqp_gb_psi_functions.g_effective_date := p_effective_date;
603:
604: debug('l_include: '||l_include);
605: debug_exit(l_proc);
606: RETURN l_include;

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

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

Line 672: PQP_GB_PSI_FUNCTIONS.set_shared_globals

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

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

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

Line 696: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria

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

Line 728: l_include := pqp_gb_psi_functions.include_event

724: debug('l_bon_curr_evt_index : '||l_bon_curr_evt_index);
725:
726: FOR i in l_bon_curr_evt_index..g_pay_proc_evt_tab.count
727: LOOP
728: l_include := pqp_gb_psi_functions.include_event
729: (p_actual_date => g_pay_proc_evt_tab(i).actual_date
730: ,p_effective_date => g_pay_proc_evt_tab(i).effective_date
731: );
732:

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

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

Line 737: IF PQP_GB_PSI_FUNCTIONS.g_min_eff_date_exists = 'Y'

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

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

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

Line 806: l_include := pqp_gb_psi_functions.include_event

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

Line 828: l_include := pqp_gb_psi_functions.include_event

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

Line 869: pqp_gb_psi_functions.g_effective_date := p_effective_date;

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

Line 877: pqp_gb_psi_functions.process_retro_event(l_include);

873: IF g_first_retro_event_start IS NOT NULL
874: THEN
875: IF l_element_of_bonus_type = 'Y' AND p_effective_date >= g_first_retro_event_start
876: THEN
877: pqp_gb_psi_functions.process_retro_event(l_include);
878: END IF;
879: END IF;
880: --END For BUG 5998129
881:

Line 952: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error

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

Line 956: pqp_gb_psi_functions.g_elements_of_info_type(g_curr_element_type_id).element_name

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

Line 962: IF pqp_gb_psi_functions.is_proper_claim_date

958: );
959: ELSE
960: --
961: l_claim_date := fnd_date.canonical_to_date(l_date_char);
962: IF pqp_gb_psi_functions.is_proper_claim_date
963: (l_claim_date
964: ,g_curr_element_type_name
965: ,g_curr_element_entry_id
966: ,g_assg_start_date

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

1003: l_return NUMBER;
1004: BEGIN
1005: debug_enter(l_proc);
1006:
1007: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(g_curr_element_type_id) THEN
1008: p_output_value
1009: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).eei_information2;
1010: END IF;
1011:

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

1005: debug_enter(l_proc);
1006:
1007: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(g_curr_element_type_id) THEN
1008: p_output_value
1009: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).eei_information2;
1010: END IF;
1011:
1012: IF NOT pqp_gb_psi_functions.is_alphanumeric(p_output_value) THEN
1013: -- Bug Fix 5015236

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

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

Line 1015: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error

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

Line 1020: pqp_gb_psi_functions.g_elements_of_info_type(g_curr_element_type_id).element_name

1016: (p_error_number => 94557
1017: ,p_error_text => 'BEN_94557_INVALID_CODE'
1018: ,p_token1 => 'Bonus'
1019: ,p_token2 =>
1020: pqp_gb_psi_functions.g_elements_of_info_type(g_curr_element_type_id).element_name
1021: ,p_token3 => p_output_value
1022: );
1023: END IF;
1024:

Line 1058: l_bonus_amount := pqp_gb_psi_functions.get_element_payment_balance

1054: l_bonus_amount NUMBER;
1055: BEGIN
1056: debug_enter(l_proc);
1057:
1058: l_bonus_amount := pqp_gb_psi_functions.get_element_payment_balance
1059: (p_assignment_id => g_assignment_id
1060: ,p_element_entry_id => g_curr_element_entry_id
1061: ,p_element_type_id => g_curr_element_type_id
1062: ,p_balance_type_id => g_bon_bal_type_id

Line 1065: /*l_bonus_amount := pqp_gb_psi_functions.get_element_payment

1061: ,p_element_type_id => g_curr_element_type_id
1062: ,p_balance_type_id => g_bon_bal_type_id
1063: ,p_effective_date => g_effective_date
1064: );
1065: /*l_bonus_amount := pqp_gb_psi_functions.get_element_payment
1066: (p_assignment_id => g_assignment_id
1067: ,p_element_entry_id => g_curr_element_entry_id
1068: ,p_element_type_id => g_curr_element_type_id
1069: ,p_effective_date => g_effective_date

Line 1074: l_include := PQP_GB_PSI_FUNCTIONS.raise_extract_error

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

Line 1085: l_include := PQP_GB_PSI_FUNCTIONS.raise_extract_error

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

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

1130: l_proc varchar2(72) := g_package||'.get_ind_flag';
1131: BEGIN
1132: debug_enter(l_proc);
1133:
1134: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(g_curr_element_type_id) THEN
1135: p_output_value
1136: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).eei_information5;
1137: END IF;
1138:

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

1132: debug_enter(l_proc);
1133:
1134: IF PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type.exists(g_curr_element_type_id) THEN
1135: p_output_value
1136: := PQP_GB_PSI_FUNCTIONS.g_elements_of_info_type(g_curr_element_type_id).eei_information5;
1137: END IF;
1138:
1139: debug_exit(l_proc);
1140: return 0;

Line 1280: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();

1276: BEGIN
1277: debug_enter(l_proc);
1278:
1279: --Raise extract exceptions which are stored while processing the data elements
1280: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();
1281:
1282: PQP_GB_PSI_FUNCTIONS.common_post_process(g_business_group_id);
1283:
1284: debug_exit(l_proc);

Line 1282: PQP_GB_PSI_FUNCTIONS.common_post_process(g_business_group_id);

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