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_NL_PENSION_EXTRACTS dependencies on BEN_EXT_FMT

Line 2012: :ben_ext_fmt.apply_format_mask',50);

2008: l_ff_value IS NOT NULL THEN
2009: IF Substr(i.frmt_mask_lookup_cd,1,1) = 'N' THEN
2010: IF g_debug THEN
2011: Hr_Utility.set_location('..Applying NUMBER format mask
2012: :ben_ext_fmt.apply_format_mask',50);
2013: END IF;
2014: l_ff_value_fmt := Ben_Ext_Fmt.apply_format_mask(To_Number(l_ff_value), i.frmt_mask_cd);
2015: l_ff_value := l_ff_value_fmt;
2016: ELSIF Substr(i.frmt_mask_lookup_cd,1,1) = 'D' THEN

Line 2014: l_ff_value_fmt := Ben_Ext_Fmt.apply_format_mask(To_Number(l_ff_value), i.frmt_mask_cd);

2010: IF g_debug THEN
2011: Hr_Utility.set_location('..Applying NUMBER format mask
2012: :ben_ext_fmt.apply_format_mask',50);
2013: END IF;
2014: l_ff_value_fmt := Ben_Ext_Fmt.apply_format_mask(To_Number(l_ff_value), i.frmt_mask_cd);
2015: l_ff_value := l_ff_value_fmt;
2016: ELSIF Substr(i.frmt_mask_lookup_cd,1,1) = 'D' THEN
2017: IF g_debug THEN
2018: Hr_Utility.set_location('..Applying Date format mask

Line 2019: :ben_ext_fmt.apply_format_mask',55);

2015: l_ff_value := l_ff_value_fmt;
2016: ELSIF Substr(i.frmt_mask_lookup_cd,1,1) = 'D' THEN
2017: IF g_debug THEN
2018: Hr_Utility.set_location('..Applying Date format mask
2019: :ben_ext_fmt.apply_format_mask',55);
2020: END IF;
2021: l_ff_value_fmt := Ben_Ext_Fmt.apply_format_mask(Fnd_Date.canonical_to_date(l_ff_value),
2022: i.frmt_mask_cd);
2023: l_ff_value := l_ff_value_fmt;

Line 2021: l_ff_value_fmt := Ben_Ext_Fmt.apply_format_mask(Fnd_Date.canonical_to_date(l_ff_value),

2017: IF g_debug THEN
2018: Hr_Utility.set_location('..Applying Date format mask
2019: :ben_ext_fmt.apply_format_mask',55);
2020: END IF;
2021: l_ff_value_fmt := Ben_Ext_Fmt.apply_format_mask(Fnd_Date.canonical_to_date(l_ff_value),
2022: i.frmt_mask_cd);
2023: l_ff_value := l_ff_value_fmt;
2024: END IF;
2025: END IF;

Line 6381: ,Ben_Ext_Fmt.g_elmt_name)||'. '||

6377: IF l_ext_rslt_id <> -1 THEN
6378: IF p_error_NUMBER IS NULL THEN
6379: l_error_text:= 'Warning raised in data element '||
6380: Nvl(Ben_Ext_Person.g_elmt_name
6381: ,Ben_Ext_Fmt.g_elmt_name)||'. '||
6382: p_error_text;
6383: ELSE
6384: Ben_Ext_Thread.g_err_num := p_error_NUMBER;
6385: Ben_Ext_Thread.g_err_name := p_error_text;

Line 6387: Ben_Ext_Fmt.get_error_msg(To_Number(Substr(p_error_text, 5, 5)),

6383: ELSE
6384: Ben_Ext_Thread.g_err_num := p_error_NUMBER;
6385: Ben_Ext_Thread.g_err_name := p_error_text;
6386: l_error_text :=
6387: Ben_Ext_Fmt.get_error_msg(To_Number(Substr(p_error_text, 5, 5)),
6388: p_error_text,Nvl(Ben_Ext_Person.g_elmt_name,Ben_Ext_Fmt.g_elmt_name) );
6389:
6390: END IF;
6391: l_person_id:= Nvl(get_current_extract_person(p_assignment_id)

Line 6388: p_error_text,Nvl(Ben_Ext_Person.g_elmt_name,Ben_Ext_Fmt.g_elmt_name) );

6384: Ben_Ext_Thread.g_err_num := p_error_NUMBER;
6385: Ben_Ext_Thread.g_err_name := p_error_text;
6386: l_error_text :=
6387: Ben_Ext_Fmt.get_error_msg(To_Number(Substr(p_error_text, 5, 5)),
6388: p_error_text,Nvl(Ben_Ext_Person.g_elmt_name,Ben_Ext_Fmt.g_elmt_name) );
6389:
6390: END IF;
6391: l_person_id:= Nvl(get_current_extract_person(p_assignment_id)
6392: ,Ben_Ext_Person.g_person_id);

Line 7892: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

7888:
7889: IF (l_pen_part_start_dt IS NOT NULL AND l_start_date_yr IS NOT NULL) THEN
7890:
7891: IF ( l_pen_part_start_dt > l_start_date_yr ) THEN
7892: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7893: (l_pen_part_start_dt,'YYYYMMDD');
7894: ELSE
7895: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7896: (l_start_date_yr,'YYYYMMDD');

Line 7895: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

7891: IF ( l_pen_part_start_dt > l_start_date_yr ) THEN
7892: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7893: (l_pen_part_start_dt,'YYYYMMDD');
7894: ELSE
7895: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7896: (l_start_date_yr,'YYYYMMDD');
7897: END IF;
7898: Hr_Utility.set_location('p_data_element_value'||p_data_element_value,50);
7899: l_ret_val := 0;

Line 7907: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

7903: CLOSE c_get_override_start_date;
7904: IF (l_assign_start_dt IS NOT NULL AND l_start_date_yr IS NOT NULL) THEN
7905:
7906: IF ( l_assign_start_dt > l_start_date_yr ) THEN
7907: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7908: (l_assign_start_dt,'YYYYMMDD');
7909: ELSE
7910: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7911: (l_start_date_yr,'YYYYMMDD');

Line 7910: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

7906: IF ( l_assign_start_dt > l_start_date_yr ) THEN
7907: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7908: (l_assign_start_dt,'YYYYMMDD');
7909: ELSE
7910: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7911: (l_start_date_yr,'YYYYMMDD');
7912: END IF;
7913: l_ret_val := 0;
7914:

Line 7972: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

7968: END IF;
7969: END IF;
7970:
7971: IF p_data_element_value <> ' ' THEN
7972: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7973: (Fnd_Date.canonical_to_date(p_data_element_value),
7974: 'YYYY');
7975: ELSE
7976: p_data_element_value := '0000';

Line 8031: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

8027: END IF;
8028: END IF;
8029:
8030: IF p_data_element_value <> ' ' THEN
8031: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
8032: (Fnd_Date.canonical_to_date(p_data_element_value),
8033: 'MM');
8034: ELSE
8035: p_data_element_value := '00';

Line 8071: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

8067: j := l_rec_12_values.FIRST;
8068: IF l_rec_12_values.EXISTS(j) THEN
8069: p_data_element_value := l_rec_12_values(j).date_earned;
8070: IF p_data_element_value <> ' ' THEN
8071: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
8072: (Fnd_Date.canonical_to_date(p_data_element_value),
8073: 'YYYY');
8074: ELSE
8075: p_data_element_value := '0000';

Line 8085: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

8081: j := l_rec_41_contrib_values.FIRST;
8082: IF l_rec_41_contrib_values.EXISTS(j) THEN
8083: p_data_element_value := l_rec_41_contrib_values(j).date_earned;
8084: IF p_data_element_value <> ' ' THEN
8085: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
8086: (Fnd_Date.canonical_to_date(p_data_element_value),
8087: 'YYYY');
8088: ELSE
8089: p_data_element_value := '0000';

Line 8127: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

8123: j := l_rec_12_values.FIRST;
8124: IF l_rec_12_values.EXISTS(j) THEN
8125: p_data_element_value := l_rec_12_values(j).date_earned;
8126: IF p_data_element_value <> ' ' THEN
8127: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
8128: (Fnd_Date.canonical_to_date(p_data_element_value),
8129: 'MM');
8130: ELSE
8131: p_data_element_value := '00';

Line 8142: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

8138: j := l_rec_41_contrib_values.FIRST;
8139: IF l_rec_41_contrib_values.EXISTS(j) THEN
8140: p_data_element_value := l_rec_41_contrib_values(j).date_earned;
8141: IF p_data_element_value <> ' ' THEN
8142: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
8143: (Fnd_Date.canonical_to_date(p_data_element_value),
8144: 'MM');
8145: ELSE
8146: p_data_element_value := '00';

Line 10191: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

10187: p_data_element_value := g_fur_dates(g_index_fur).old_end;
10188: END IF;
10189:
10190: -- p_data_element_value := substr(p_data_element_value,1,10);
10191: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
10192: (Fnd_Date.canonical_to_date(p_data_element_value),
10193: 'YYYYMMDD');
10194:
10195: ELSE

Line 12078: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

12074: -- Depending on the fetch code, set the data element value
12075: --
12076: IF p_fetch_code = 'NEW_ST' THEN
12077: p_data_element_value := g_rec05_rows(g_index_05).new_start;
12078: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
12079: (Fnd_Date.canonical_to_date(p_data_element_value),
12080: 'YYYYMMDD');
12081: ELSIF p_fetch_code = 'OLD_ST' THEN
12082: p_data_element_value := g_rec05_rows(g_index_05).old_start;

Line 12083: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

12079: (Fnd_Date.canonical_to_date(p_data_element_value),
12080: 'YYYYMMDD');
12081: ELSIF p_fetch_code = 'OLD_ST' THEN
12082: p_data_element_value := g_rec05_rows(g_index_05).old_start;
12083: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
12084: (Fnd_Date.canonical_to_date(p_data_element_value),
12085: 'YYYYMMDD');
12086: ELSIF p_fetch_code = 'NEW_ED' THEN
12087: IF g_rec05_rows(g_index_05).new_end IS NOT NULL THEN

Line 12092: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

12088: g_rec05_rows(g_index_05).new_end :=
12089: fnd_date.date_to_canonical(fnd_date.canonical_to_date(g_rec05_rows(g_index_05).new_end) + 1);
12090: END IF;
12091: p_data_element_value := g_rec05_rows(g_index_05).new_end;
12092: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
12093: (Fnd_Date.canonical_to_date(p_data_element_value),
12094: 'YYYYMMDD');
12095: ELSIF p_fetch_code = 'OLD_ED' THEN
12096: IF g_rec05_rows(g_index_05).old_end IS NOT NULL THEN

Line 12101: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

12097: g_rec05_rows(g_index_05).old_end :=
12098: fnd_date.date_to_canonical(fnd_date.canonical_to_date(g_rec05_rows(g_index_05).old_end) + 1);
12099: END IF;
12100: p_data_element_value := g_rec05_rows(g_index_05).old_end;
12101: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
12102: (Fnd_Date.canonical_to_date(p_data_element_value),
12103: 'YYYYMMDD');
12104: ELSIF p_fetch_code = 'P_KIND' THEN
12105: p_data_element_value := g_rec05_rows(g_index_05).partn_kind;

Line 12123: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

12119: hr_utility.set_location('....age < 65 and not on political leave',112);
12120: END IF;
12121: ELSIF p_fetch_code = 'DT_CHG' THEN
12122: p_data_element_value := g_rec05_rows(g_index_05).dt_chg;
12123: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
12124: (Fnd_Date.canonical_to_date(p_data_element_value),
12125: 'YYYYMMDD');
12126: ELSIF p_fetch_code = 'EDDT_CHG' THEN
12127:

Line 12140: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

12136: g_rec05_rows(g_index_05).eddt_chg :=
12137: fnd_date.date_to_canonical(fnd_date.canonical_to_date(g_rec05_rows(g_index_05).eddt_chg) + 1);
12138: END IF;
12139: p_data_element_value := g_rec05_rows(g_index_05).eddt_chg;
12140: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
12141: (Fnd_Date.canonical_to_date(p_data_element_value),
12142: 'YYYYMMDD');
12143: ELSIF p_fetch_code = 'END_REASON' THEN
12144: p_data_element_value := g_rec05_rows(g_index_05).end_reason;

Line 12579: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

12575: p_data_element_value := g_ipap_dates(g_index_ipap).old_end;
12576: END IF;
12577:
12578: -- p_data_element_value := substr(p_data_element_value,1,10);
12579: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
12580: (Fnd_Date.canonical_to_date(p_data_element_value),
12581: 'YYYYMMDD');
12582:
12583: ELSE

Line 12992: l_pension_yr_char := Ben_Ext_Fmt.apply_format_mask

12988: l_pension_sal_char := Trim(To_Char(ABS(Nvl(l_lh_or_pen_sal,0))
12989: ,'0999999V99'));
12990: END IF;
12991:
12992: l_pension_yr_char := Ben_Ext_Fmt.apply_format_mask
12993: (l_lh_or_date,'YYYYMMDD');
12994:
12995: END IF;
12996:

Line 17304: --l_trailer_new_rec.val_05 := Lpad(Ben_Ext_Fmt.apply_format_mask(To_Number(l_R95_Contri),'9999999999999V99'),10,0);

17300: -- Start of trailer record95
17301: IF g_rcd_dtls(95).ext_rcd_id = csr_rcd_rec.ext_rcd_id THEN
17302:
17303: l_trailer_new_rec.val_04 := Trim(To_Char(l_record95_count,'0999999'));
17304: --l_trailer_new_rec.val_05 := Lpad(Ben_Ext_Fmt.apply_format_mask(To_Number(l_R95_Contri),'9999999999999V99'),10,0);
17305: l_trailer_new_rec.val_05 := Trim(To_Char(ABS(l_R95_Contri),'09999999999'));
17306: l_trailer_new_rec.val_06 := Get_Trailer_Amount_Sign(l_R95_Contri);
17307:
17308: --force an insert of this trailer record only if the count is > 0