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 1991: :ben_ext_fmt.apply_format_mask',50);

1987: l_ff_value IS NOT NULL THEN
1988: IF Substr(i.frmt_mask_lookup_cd,1,1) = 'N' THEN
1989: IF g_debug THEN
1990: Hr_Utility.set_location('..Applying NUMBER format mask
1991: :ben_ext_fmt.apply_format_mask',50);
1992: END IF;
1993: l_ff_value_fmt := Ben_Ext_Fmt.apply_format_mask(To_Number(l_ff_value), i.frmt_mask_cd);
1994: l_ff_value := l_ff_value_fmt;
1995: ELSIF Substr(i.frmt_mask_lookup_cd,1,1) = 'D' THEN

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

1989: IF g_debug THEN
1990: Hr_Utility.set_location('..Applying NUMBER format mask
1991: :ben_ext_fmt.apply_format_mask',50);
1992: END IF;
1993: l_ff_value_fmt := Ben_Ext_Fmt.apply_format_mask(To_Number(l_ff_value), i.frmt_mask_cd);
1994: l_ff_value := l_ff_value_fmt;
1995: ELSIF Substr(i.frmt_mask_lookup_cd,1,1) = 'D' THEN
1996: IF g_debug THEN
1997: Hr_Utility.set_location('..Applying Date format mask

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

1994: l_ff_value := l_ff_value_fmt;
1995: ELSIF Substr(i.frmt_mask_lookup_cd,1,1) = 'D' THEN
1996: IF g_debug THEN
1997: Hr_Utility.set_location('..Applying Date format mask
1998: :ben_ext_fmt.apply_format_mask',55);
1999: END IF;
2000: l_ff_value_fmt := Ben_Ext_Fmt.apply_format_mask(Fnd_Date.canonical_to_date(l_ff_value),
2001: i.frmt_mask_cd);
2002: l_ff_value := l_ff_value_fmt;

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

1996: IF g_debug THEN
1997: Hr_Utility.set_location('..Applying Date format mask
1998: :ben_ext_fmt.apply_format_mask',55);
1999: END IF;
2000: l_ff_value_fmt := Ben_Ext_Fmt.apply_format_mask(Fnd_Date.canonical_to_date(l_ff_value),
2001: i.frmt_mask_cd);
2002: l_ff_value := l_ff_value_fmt;
2003: END IF;
2004: END IF;

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

6039: IF l_ext_rslt_id <> -1 THEN
6040: IF p_error_NUMBER IS NULL THEN
6041: l_error_text:= 'Warning raised in data element '||
6042: Nvl(Ben_Ext_Person.g_elmt_name
6043: ,Ben_Ext_Fmt.g_elmt_name)||'. '||
6044: p_error_text;
6045: ELSE
6046: Ben_Ext_Thread.g_err_num := p_error_NUMBER;
6047: Ben_Ext_Thread.g_err_name := p_error_text;

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

6045: ELSE
6046: Ben_Ext_Thread.g_err_num := p_error_NUMBER;
6047: Ben_Ext_Thread.g_err_name := p_error_text;
6048: l_error_text :=
6049: Ben_Ext_Fmt.get_error_msg(To_Number(Substr(p_error_text, 5, 5)),
6050: p_error_text,Nvl(Ben_Ext_Person.g_elmt_name,Ben_Ext_Fmt.g_elmt_name) );
6051:
6052: END IF;
6053: l_person_id:= Nvl(get_current_extract_person(p_assignment_id)

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

6046: Ben_Ext_Thread.g_err_num := p_error_NUMBER;
6047: Ben_Ext_Thread.g_err_name := p_error_text;
6048: l_error_text :=
6049: Ben_Ext_Fmt.get_error_msg(To_Number(Substr(p_error_text, 5, 5)),
6050: p_error_text,Nvl(Ben_Ext_Person.g_elmt_name,Ben_Ext_Fmt.g_elmt_name) );
6051:
6052: END IF;
6053: l_person_id:= Nvl(get_current_extract_person(p_assignment_id)
6054: ,Ben_Ext_Person.g_person_id);

Line 7553: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

7549:
7550: IF (l_pen_part_start_dt IS NOT NULL AND l_start_date_yr IS NOT NULL) THEN
7551:
7552: IF ( l_pen_part_start_dt > l_start_date_yr ) THEN
7553: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7554: (l_pen_part_start_dt,'YYYYMMDD');
7555: ELSE
7556: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7557: (l_start_date_yr,'YYYYMMDD');

Line 7556: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

7552: IF ( l_pen_part_start_dt > l_start_date_yr ) THEN
7553: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7554: (l_pen_part_start_dt,'YYYYMMDD');
7555: ELSE
7556: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7557: (l_start_date_yr,'YYYYMMDD');
7558: END IF;
7559: Hr_Utility.set_location('p_data_element_value'||p_data_element_value,50);
7560: l_ret_val := 0;

Line 7568: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

7564: CLOSE c_get_override_start_date;
7565: IF (l_assign_start_dt IS NOT NULL AND l_start_date_yr IS NOT NULL) THEN
7566:
7567: IF ( l_assign_start_dt > l_start_date_yr ) THEN
7568: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7569: (l_assign_start_dt,'YYYYMMDD');
7570: ELSE
7571: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7572: (l_start_date_yr,'YYYYMMDD');

Line 7571: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

7567: IF ( l_assign_start_dt > l_start_date_yr ) THEN
7568: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7569: (l_assign_start_dt,'YYYYMMDD');
7570: ELSE
7571: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7572: (l_start_date_yr,'YYYYMMDD');
7573: END IF;
7574: l_ret_val := 0;
7575:

Line 7633: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

7629: END IF;
7630: END IF;
7631:
7632: IF p_data_element_value <> ' ' THEN
7633: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7634: (Fnd_Date.canonical_to_date(p_data_element_value),
7635: 'YYYY');
7636: ELSE
7637: p_data_element_value := '0000';

Line 7692: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

7688: END IF;
7689: END IF;
7690:
7691: IF p_data_element_value <> ' ' THEN
7692: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7693: (Fnd_Date.canonical_to_date(p_data_element_value),
7694: 'MM');
7695: ELSE
7696: p_data_element_value := '00';

Line 7732: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

7728: j := l_rec_12_values.FIRST;
7729: IF l_rec_12_values.EXISTS(j) THEN
7730: p_data_element_value := l_rec_12_values(j).date_earned;
7731: IF p_data_element_value <> ' ' THEN
7732: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7733: (Fnd_Date.canonical_to_date(p_data_element_value),
7734: 'YYYY');
7735: ELSE
7736: p_data_element_value := '0000';

Line 7746: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

7742: j := l_rec_41_contrib_values.FIRST;
7743: IF l_rec_41_contrib_values.EXISTS(j) THEN
7744: p_data_element_value := l_rec_41_contrib_values(j).date_earned;
7745: IF p_data_element_value <> ' ' THEN
7746: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7747: (Fnd_Date.canonical_to_date(p_data_element_value),
7748: 'YYYY');
7749: ELSE
7750: p_data_element_value := '0000';

Line 7788: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

7784: j := l_rec_12_values.FIRST;
7785: IF l_rec_12_values.EXISTS(j) THEN
7786: p_data_element_value := l_rec_12_values(j).date_earned;
7787: IF p_data_element_value <> ' ' THEN
7788: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7789: (Fnd_Date.canonical_to_date(p_data_element_value),
7790: 'MM');
7791: ELSE
7792: p_data_element_value := '00';

Line 7803: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

7799: j := l_rec_41_contrib_values.FIRST;
7800: IF l_rec_41_contrib_values.EXISTS(j) THEN
7801: p_data_element_value := l_rec_41_contrib_values(j).date_earned;
7802: IF p_data_element_value <> ' ' THEN
7803: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
7804: (Fnd_Date.canonical_to_date(p_data_element_value),
7805: 'MM');
7806: ELSE
7807: p_data_element_value := '00';

Line 9852: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

9848: p_data_element_value := g_fur_dates(g_index_fur).old_end;
9849: END IF;
9850:
9851: -- p_data_element_value := substr(p_data_element_value,1,10);
9852: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
9853: (Fnd_Date.canonical_to_date(p_data_element_value),
9854: 'YYYYMMDD');
9855:
9856: ELSE

Line 11709: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

11705: -- Depending on the fetch code, set the data element value
11706: --
11707: IF p_fetch_code = 'NEW_ST' THEN
11708: p_data_element_value := g_rec05_rows(g_index_05).new_start;
11709: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
11710: (Fnd_Date.canonical_to_date(p_data_element_value),
11711: 'YYYYMMDD');
11712: ELSIF p_fetch_code = 'OLD_ST' THEN
11713: p_data_element_value := g_rec05_rows(g_index_05).old_start;

Line 11714: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

11710: (Fnd_Date.canonical_to_date(p_data_element_value),
11711: 'YYYYMMDD');
11712: ELSIF p_fetch_code = 'OLD_ST' THEN
11713: p_data_element_value := g_rec05_rows(g_index_05).old_start;
11714: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
11715: (Fnd_Date.canonical_to_date(p_data_element_value),
11716: 'YYYYMMDD');
11717: ELSIF p_fetch_code = 'NEW_ED' THEN
11718: IF g_rec05_rows(g_index_05).new_end IS NOT NULL THEN

Line 11723: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

11719: g_rec05_rows(g_index_05).new_end :=
11720: fnd_date.date_to_canonical(fnd_date.canonical_to_date(g_rec05_rows(g_index_05).new_end) + 1);
11721: END IF;
11722: p_data_element_value := g_rec05_rows(g_index_05).new_end;
11723: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
11724: (Fnd_Date.canonical_to_date(p_data_element_value),
11725: 'YYYYMMDD');
11726: ELSIF p_fetch_code = 'OLD_ED' THEN
11727: IF g_rec05_rows(g_index_05).old_end IS NOT NULL THEN

Line 11732: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

11728: g_rec05_rows(g_index_05).old_end :=
11729: fnd_date.date_to_canonical(fnd_date.canonical_to_date(g_rec05_rows(g_index_05).old_end) + 1);
11730: END IF;
11731: p_data_element_value := g_rec05_rows(g_index_05).old_end;
11732: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
11733: (Fnd_Date.canonical_to_date(p_data_element_value),
11734: 'YYYYMMDD');
11735: ELSIF p_fetch_code = 'P_KIND' THEN
11736: p_data_element_value := g_rec05_rows(g_index_05).partn_kind;

Line 11754: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

11750: hr_utility.set_location('....age < 65 and not on political leave',112);
11751: END IF;
11752: ELSIF p_fetch_code = 'DT_CHG' THEN
11753: p_data_element_value := g_rec05_rows(g_index_05).dt_chg;
11754: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
11755: (Fnd_Date.canonical_to_date(p_data_element_value),
11756: 'YYYYMMDD');
11757: ELSIF p_fetch_code = 'EDDT_CHG' THEN
11758:

Line 11771: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

11767: g_rec05_rows(g_index_05).eddt_chg :=
11768: fnd_date.date_to_canonical(fnd_date.canonical_to_date(g_rec05_rows(g_index_05).eddt_chg) + 1);
11769: END IF;
11770: p_data_element_value := g_rec05_rows(g_index_05).eddt_chg;
11771: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
11772: (Fnd_Date.canonical_to_date(p_data_element_value),
11773: 'YYYYMMDD');
11774: ELSIF p_fetch_code = 'END_REASON' THEN
11775: p_data_element_value := g_rec05_rows(g_index_05).end_reason;

Line 12210: p_data_element_value := Ben_Ext_Fmt.apply_format_mask

12206: p_data_element_value := g_ipap_dates(g_index_ipap).old_end;
12207: END IF;
12208:
12209: -- p_data_element_value := substr(p_data_element_value,1,10);
12210: p_data_element_value := Ben_Ext_Fmt.apply_format_mask
12211: (Fnd_Date.canonical_to_date(p_data_element_value),
12212: 'YYYYMMDD');
12213:
12214: ELSE

Line 12623: l_pension_yr_char := Ben_Ext_Fmt.apply_format_mask

12619: l_pension_sal_char := Trim(To_Char(ABS(Nvl(l_lh_or_pen_sal,0))
12620: ,'0999999V99'));
12621: END IF;
12622:
12623: l_pension_yr_char := Ben_Ext_Fmt.apply_format_mask
12624: (l_lh_or_date,'YYYYMMDD');
12625:
12626: END IF;
12627:

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

16842: -- Start of trailer record95
16843: IF g_rcd_dtls(95).ext_rcd_id = csr_rcd_rec.ext_rcd_id THEN
16844:
16845: l_trailer_new_rec.val_04 := Trim(To_Char(l_record95_count,'0999999'));
16846: --l_trailer_new_rec.val_05 := Lpad(Ben_Ext_Fmt.apply_format_mask(To_Number(l_R95_Contri),'9999999999999V99'),10,0);
16847: l_trailer_new_rec.val_05 := Trim(To_Char(ABS(l_R95_Contri),'09999999999'));
16848: l_trailer_new_rec.val_06 := Get_Trailer_Amount_Sign(l_R95_Contri);
16849:
16850: --force an insert of this trailer record only if the count is > 0