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_PENSION_EXTRACTS dependencies on BEN_EXT_THREAD

Line 267: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id -- The extract executing currently

263: SELECT rcd.ext_rcd_id
264: FROM ben_ext_rcd rcd
265: ,ben_ext_rcd_in_file rin
266: ,ben_ext_dfn dfn
267: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id -- The extract executing currently
268: AND rin.ext_file_id = dfn.ext_file_id
269: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden
270: AND rin.ext_rcd_id = rcd.ext_rcd_id
271: AND rcd.rcd_type_cd = c_rcd_type_cd; -- D=Detail,H=Header,F=Footer

Line 736: ben_ext_thread.process

732: -- Call the actual benefit extract process with the effective date as the
733: -- extract end date along with the ext def. id and business group id.
734: --
735: hr_utility.set_location('..Calling Benefit Ext Process'||l_proc_name, 6);
736: ben_ext_thread.process
737: (errbuf => l_errbuff,
738: retcode => l_retcode,
739: p_benefit_action_id => NULL,
740: p_ext_dfn_id => p_ext_dfn_id,

Line 1460: IF l_err_num >= ben_ext_thread.g_max_errors_allowed THEN

1456: OPEN err_cnt_c;
1457: FETCH err_cnt_c INTO l_err_num;
1458: CLOSE err_cnt_c;
1459: --
1460: IF l_err_num >= ben_ext_thread.g_max_errors_allowed THEN
1461: --
1462: ben_ext_thread.g_err_num := 91947;
1463: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';
1464: RAISE ben_ext_thread.g_job_failure_error;

Line 1462: ben_ext_thread.g_err_num := 91947;

1458: CLOSE err_cnt_c;
1459: --
1460: IF l_err_num >= ben_ext_thread.g_max_errors_allowed THEN
1461: --
1462: ben_ext_thread.g_err_num := 91947;
1463: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';
1464: RAISE ben_ext_thread.g_job_failure_error;
1465: --
1466: END IF;

Line 1463: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';

1459: --
1460: IF l_err_num >= ben_ext_thread.g_max_errors_allowed THEN
1461: --
1462: ben_ext_thread.g_err_num := 91947;
1463: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';
1464: RAISE ben_ext_thread.g_job_failure_error;
1465: --
1466: END IF;
1467:

Line 1464: RAISE ben_ext_thread.g_job_failure_error;

1460: IF l_err_num >= ben_ext_thread.g_max_errors_allowed THEN
1461: --
1462: ben_ext_thread.g_err_num := 91947;
1463: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';
1464: RAISE ben_ext_thread.g_job_failure_error;
1465: --
1466: END IF;
1467:
1468: IF g_business_group_id IS NOT NULL THEN

Line 1591: RAISE; -- such that the error processing in ben_ext_thread occurs.

1587: WHEN Others THEN
1588: Fnd_File.put_line(Fnd_File.Log,
1589: 'Error in Advanced Conditions while processing this dynamic sql statement: ');
1590: Fnd_File.put_line(Fnd_File.Log, l_dynamic_condition);
1591: RAISE; -- such that the error processing in ben_ext_thread occurs.
1592: END;
1593: --
1594: IF l_condition = 'T' THEN
1595: IF p_sprs_cd = 'A' THEN

Line 1746: RAISE; -- such that the error processing in ben_ext_thread occurs.

1742: -- this needs replaced with a message for translation.
1743: Fnd_File.put_line(Fnd_File.Log,
1744: 'Error in Advanced Conditions while processing this dynamic sql statement: ');
1745: Fnd_File.put_line(Fnd_File.Log, l_dynamic_condition);
1746: RAISE; -- such that the error processing in ben_ext_thread occurs.
1747: END;
1748: --
1749: --
1750: IF l_condition = 'T' THEN

Line 2071: ,p_param1_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_dfn_id, -1))

2067: ,p_organization_id => p_organization_id
2068: ,p_business_group_id => g_business_group_id
2069: ,p_jurisdiction_code => NULL
2070: ,p_param1 => 'EXT_DFN_ID'
2071: ,p_param1_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_dfn_id, -1))
2072: ,p_param2 => 'EXT_RSLT_ID'
2073: ,p_param2_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_rslt_id, -1))
2074: );
2075: l_ff_value := l_outputs(l_outputs.FIRST).VALUE;

Line 2073: ,p_param2_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_rslt_id, -1))

2069: ,p_jurisdiction_code => NULL
2070: ,p_param1 => 'EXT_DFN_ID'
2071: ,p_param1_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_dfn_id, -1))
2072: ,p_param2 => 'EXT_RSLT_ID'
2073: ,p_param2_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_rslt_id, -1))
2074: );
2075: l_ff_value := l_outputs(l_outputs.FIRST).VALUE;
2076: IF l_ff_value IS NULL THEN
2077: l_ff_value := i.dflt_val;

Line 2145: ,c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id )

2141:
2142: -- Check the Adv. Conditions for records in file
2143: FOR rif IN csr_xrif
2144: (c_rcd_id => p_rslt_rec.ext_rcd_id
2145: ,c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id )
2146: LOOP
2147: Rcd_In_File
2148: (p_ext_rcd_in_file_id => rif.ext_rcd_in_file_id
2149: ,p_sprs_cd => rif.sprs_cd

Line 2178: OPEN csr_ben (c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id

2174: END IF; --IF g_total_dtl_lines
2175:
2176: ELSIF l_exclude_this_rcd_flag THEN
2177:
2178: OPEN csr_ben (c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id
2179: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
2180: ,c_business_group_id => g_business_group_id);
2181: FETCH csr_ben INTO l_ben_params;
2182: CLOSE csr_ben;

Line 2179: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

2175:
2176: ELSIF l_exclude_this_rcd_flag THEN
2177:
2178: OPEN csr_ben (c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id
2179: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
2180: ,c_business_group_id => g_business_group_id);
2181: FETCH csr_ben INTO l_ben_params;
2182: CLOSE csr_ben;
2183:

Line 2227: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

2223: LOOP
2224: g_ext_dtl_rcd_id := csr_rcd_rec.ext_rcd_id;
2225: OPEN csr_rslt_dtl
2226: (c_person_id => p_person_id
2227: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
2228: ,c_ext_dtl_rcd_id => g_ext_dtl_rcd_id
2229: );
2230: FETCH csr_rslt_dtl INTO l_main_rec;
2231: CLOSE csr_rslt_dtl;

Line 2555: ,c_ext_rslt_id => ben_ext_thread.g_ext_rslt_id

2551: CLOSE csr_ext_rcd_id;
2552: --
2553: OPEN csr_rslt_dtl
2554: (c_person_id => l_person_id
2555: ,c_ext_rslt_id => ben_ext_thread.g_ext_rslt_id
2556: ,c_ext_dtl_rcd_id => g_ext_dtl_rcd_id
2557: );
2558: FETCH csr_rslt_dtl INTO l_main_rec;
2559: CLOSE csr_rslt_dtl;

Line 4147: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;

4143: BEGIN
4144:
4145: hr_utility.set_location('Entering: '||l_proc_name, 5);
4146: i := p_business_group_id;
4147: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
4148: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;
4149:
4150: IF NOT g_extract_params.EXISTS(i) THEN
4151: hr_utility.set_location('..Exract Params. PL/SQL not populated ', 6);

Line 4148: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;

4144:
4145: hr_utility.set_location('Entering: '||l_proc_name, 5);
4146: i := p_business_group_id;
4147: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
4148: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;
4149:
4150: IF NOT g_extract_params.EXISTS(i) THEN
4151: hr_utility.set_location('..Exract Params. PL/SQL not populated ', 6);
4152: -- Get the extract type, Changes extract or Full Profile

Line 4496: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

4492: -- Delete all hidden detail records for the all persons
4493: DELETE
4494: FROM ben_ext_rslt_dtl
4495: WHERE ext_rcd_id = csr_rcd_rec.ext_rcd_id
4496: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
4497: AND business_group_id = p_business_group_id;
4498: END LOOP;
4499:
4500: -- Get the benefit action id for the extract

Line 4501: OPEN csr_ben (c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id

4497: AND business_group_id = p_business_group_id;
4498: END LOOP;
4499:
4500: -- Get the benefit action id for the extract
4501: OPEN csr_ben (c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id
4502: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
4503: ,c_business_group_id => p_business_group_id);
4504: FETCH csr_ben INTO l_ben_params;
4505: CLOSE csr_ben;

Line 4502: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

4498: END LOOP;
4499:
4500: -- Get the benefit action id for the extract
4501: OPEN csr_ben (c_ext_dfn_id => Ben_Ext_Thread.g_ext_dfn_id
4502: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
4503: ,c_business_group_id => p_business_group_id);
4504: FETCH csr_ben INTO l_ben_params;
4505: CLOSE csr_ben;
4506:

Line 4510: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id)

4506:
4507: -- Flag the person in ben_person_actions and ben_batch_ranges
4508: -- as Unporcessed and errored.
4509: FOR err_rec IN csr_err(c_bg_id => p_business_group_id
4510: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id)
4511: LOOP
4512: Exclude_Person
4513: (p_person_id => err_rec.person_id
4514: ,p_business_group_id => p_business_group_id

Line 4519: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

4515: ,p_benefit_action_id => l_ben_params.benefit_action_id
4516: ,p_flag_thread => 'Y');
4517: DELETE
4518: FROM ben_ext_rslt_dtl dtl
4519: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
4520: AND dtl.person_id = err_rec.person_id
4521: AND dtl.business_group_id = p_business_group_id;
4522:
4523: END LOOP;

Line 4575: ben_ext_thread.g_err_num := p_error_NUMBER;

4571: NVL(ben_ext_fmt.g_elmt_name
4572: ,ben_ext_person.g_elmt_name)||'. '||
4573: p_error_text;
4574: ELSE
4575: ben_ext_thread.g_err_num := p_error_NUMBER;
4576: ben_ext_thread.g_err_name := p_error_text;
4577: l_error_text :=
4578: ben_ext_fmt.get_error_msg(TO_NUMBER(SUBSTR(p_error_text, 5, 5)),
4579: p_error_text,NVL(ben_ext_fmt.g_elmt_name,ben_ext_person.g_elmt_name) );

Line 4576: ben_ext_thread.g_err_name := p_error_text;

4572: ,ben_ext_person.g_elmt_name)||'. '||
4573: p_error_text;
4574: ELSE
4575: ben_ext_thread.g_err_num := p_error_NUMBER;
4576: ben_ext_thread.g_err_name := p_error_text;
4577: l_error_text :=
4578: ben_ext_fmt.get_error_msg(TO_NUMBER(SUBSTR(p_error_text, 5, 5)),
4579: p_error_text,NVL(ben_ext_fmt.g_elmt_name,ben_ext_person.g_elmt_name) );
4580:

Line 4632: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;

4628: l_ext_rslt_id NUMBER;
4629:
4630: BEGIN
4631:
4632: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
4633: RETURN l_ext_rslt_id;
4634:
4635: EXCEPTION
4636: