DBA Data[Home] [Help]

APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on FND_MESSAGE

Line 257: fnd_message.set_name(''BEN'',''BEN_93353_PDC_MAX_LENGTH'');

253: l_column '||table_name||'.'||column_type||'%type ;
254: begin
255: l_column := :1;
256: exception when others then
257: fnd_message.set_name(''BEN'',''BEN_93353_PDC_MAX_LENGTH'');
258: fnd_message.raise_error ;
259: end;'
260: USING l_var;
261: END ben_chk_col_len;

Line 258: fnd_message.raise_error ;

254: begin
255: l_column := :1;
256: exception when others then
257: fnd_message.set_name(''BEN'',''BEN_93353_PDC_MAX_LENGTH'');
258: fnd_message.raise_error ;
259: end;'
260: USING l_var;
261: END ben_chk_col_len;
262:

Line 277: l_message := substr(nvl(fnd_message.get,sqlerrm),1,1999) ;

273: and tr.from_clause = 'OAB' ;
274: --
275: begin
276: --
277: l_message := substr(nvl(fnd_message.get,sqlerrm),1,1999) ;
278: --
279: fnd_message.clear;
280: --
281: open c_display_name;

Line 279: fnd_message.clear;

275: begin
276: --
277: l_message := substr(nvl(fnd_message.get,sqlerrm),1,1999) ;
278: --
279: fnd_message.clear;
280: --
281: open c_display_name;
282: fetch c_display_name into l_display_name ;
283: close c_display_name;

Line 285: fnd_message.set_name('BEN','BEN_93256_PDC_ERROR_STACK');

281: open c_display_name;
282: fetch c_display_name into l_display_name ;
283: close c_display_name;
284: --
285: fnd_message.set_name('BEN','BEN_93256_PDC_ERROR_STACK');
286: fnd_message.set_token('DISPLAY_NAME',l_display_name||' - '||p_object_name );
287: fnd_message.set_token('DETAILS',l_message);
288: fnd_message.raise_error ;
289: end raise_error_message ;

Line 286: fnd_message.set_token('DISPLAY_NAME',l_display_name||' - '||p_object_name );

282: fetch c_display_name into l_display_name ;
283: close c_display_name;
284: --
285: fnd_message.set_name('BEN','BEN_93256_PDC_ERROR_STACK');
286: fnd_message.set_token('DISPLAY_NAME',l_display_name||' - '||p_object_name );
287: fnd_message.set_token('DETAILS',l_message);
288: fnd_message.raise_error ;
289: end raise_error_message ;
290: --

Line 287: fnd_message.set_token('DETAILS',l_message);

283: close c_display_name;
284: --
285: fnd_message.set_name('BEN','BEN_93256_PDC_ERROR_STACK');
286: fnd_message.set_token('DISPLAY_NAME',l_display_name||' - '||p_object_name );
287: fnd_message.set_token('DETAILS',l_message);
288: fnd_message.raise_error ;
289: end raise_error_message ;
290: --
291:

Line 288: fnd_message.raise_error ;

284: --
285: fnd_message.set_name('BEN','BEN_93256_PDC_ERROR_STACK');
286: fnd_message.set_token('DISPLAY_NAME',l_display_name||' - '||p_object_name );
287: fnd_message.set_token('DETAILS',l_message);
288: fnd_message.raise_error ;
289: end raise_error_message ;
290: --
291:
292: --

Line 9868: fnd_message.set_name('BEN','BEN_93364_PDC_DUP_LE_OPER_CD');

9864: p_target_business_group_id, nvl(l_ler_id, -999)) ;
9865: fetch c_lf_evt_oper_cd_exists into l_target_ler_name;
9866: if c_lf_evt_oper_cd_exists%found then
9867: close c_lf_evt_oper_cd_exists;
9868: fnd_message.set_name('BEN','BEN_93364_PDC_DUP_LE_OPER_CD');
9869: fnd_message.set_token('NAME',l_target_ler_name);
9870: fnd_message.set_token('OPER_CD',hr_general.decode_lookup('BEN_LF_EVT_OPER',r_LER_unique.lf_evt_oper_cd));
9871: fnd_message.raise_error;
9872: end if;

Line 9869: fnd_message.set_token('NAME',l_target_ler_name);

9865: fetch c_lf_evt_oper_cd_exists into l_target_ler_name;
9866: if c_lf_evt_oper_cd_exists%found then
9867: close c_lf_evt_oper_cd_exists;
9868: fnd_message.set_name('BEN','BEN_93364_PDC_DUP_LE_OPER_CD');
9869: fnd_message.set_token('NAME',l_target_ler_name);
9870: fnd_message.set_token('OPER_CD',hr_general.decode_lookup('BEN_LF_EVT_OPER',r_LER_unique.lf_evt_oper_cd));
9871: fnd_message.raise_error;
9872: end if;
9873: close c_lf_evt_oper_cd_exists ;

Line 9870: fnd_message.set_token('OPER_CD',hr_general.decode_lookup('BEN_LF_EVT_OPER',r_LER_unique.lf_evt_oper_cd));

9866: if c_lf_evt_oper_cd_exists%found then
9867: close c_lf_evt_oper_cd_exists;
9868: fnd_message.set_name('BEN','BEN_93364_PDC_DUP_LE_OPER_CD');
9869: fnd_message.set_token('NAME',l_target_ler_name);
9870: fnd_message.set_token('OPER_CD',hr_general.decode_lookup('BEN_LF_EVT_OPER',r_LER_unique.lf_evt_oper_cd));
9871: fnd_message.raise_error;
9872: end if;
9873: close c_lf_evt_oper_cd_exists ;
9874: end if;

Line 9871: fnd_message.raise_error;

9867: close c_lf_evt_oper_cd_exists;
9868: fnd_message.set_name('BEN','BEN_93364_PDC_DUP_LE_OPER_CD');
9869: fnd_message.set_token('NAME',l_target_ler_name);
9870: fnd_message.set_token('OPER_CD',hr_general.decode_lookup('BEN_LF_EVT_OPER',r_LER_unique.lf_evt_oper_cd));
9871: fnd_message.raise_error;
9872: end if;
9873: close c_lf_evt_oper_cd_exists ;
9874: end if;
9875: end if;