148: RETURN VARCHAR2 IS
149:
150: BEGIN
151: --
152: fnd_message.set_name('HRI', p_message);
153: IF is_token_exist(p_message,'PRODUCT_NAME')
154: THEN
155: fnd_message.set_token('PRODUCT_NAME'
156: ,get_product_name(g_object_name));
151: --
152: fnd_message.set_name('HRI', p_message);
153: IF is_token_exist(p_message,'PRODUCT_NAME')
154: THEN
155: fnd_message.set_token('PRODUCT_NAME'
156: ,get_product_name(g_object_name));
157: END IF;
158:
159: RETURN trim_msg(fnd_message.get);
155: fnd_message.set_token('PRODUCT_NAME'
156: ,get_product_name(g_object_name));
157: END IF;
158:
159: RETURN trim_msg(fnd_message.get);
160: --
161: END get_message;
162:
163: -------------------------------------------------------------------------------
170: l_exists BOOLEAN := FALSE;
171: --
172: BEGIN
173: --
174: IF instr(fnd_message.get_string('HRI',p_message),p_token_name,1) > 0 THEN
175: --
176: l_exists := TRUE ;
177: --
178: END IF;
197: AND g_prd_type_tab_v(p_object_name).obiee_ind = 0
198: AND g_prd_type_tab_v(p_object_name).all_ind = 0)
199: OR ( p_object_name = 'HRI_IMPL_DBI')) THEN
200: --
201: l_product_name :=fnd_message.GET_STRING('HRI', 'HRI_407494_HRI_PRODUCT_NAME');
202: --
203: ELSIF ((g_prd_type_tab_v(p_object_name).dbi_ind = 0
204: AND g_prd_type_tab_v(p_object_name).obiee_ind = 1
205: AND g_prd_type_tab_v(p_object_name).all_ind = 0)
204: AND g_prd_type_tab_v(p_object_name).obiee_ind = 1
205: AND g_prd_type_tab_v(p_object_name).all_ind = 0)
206: OR (p_object_name = 'HRI_IMPL_OBIEE')) THEN
207: --
208: l_product_name :=fnd_message.GET_STRING('HRI', 'HRI_407493_OBIEE_PRODUCT_NAME');
209: --
210: ELSIF g_prd_type_tab_v(p_object_name).all_ind = 1 then
211:
212: l_product_name :=fnd_message.GET_STRING('HRI', 'HRI_407493_OBIEE_PRODUCT_NAME')||' & '||
208: l_product_name :=fnd_message.GET_STRING('HRI', 'HRI_407493_OBIEE_PRODUCT_NAME');
209: --
210: ELSIF g_prd_type_tab_v(p_object_name).all_ind = 1 then
211:
212: l_product_name :=fnd_message.GET_STRING('HRI', 'HRI_407493_OBIEE_PRODUCT_NAME')||' & '||
213: fnd_message.GET_STRING('HRI', 'HRI_407494_HRI_PRODUCT_NAME');
214: ELSE
215: l_product_name :=fnd_message.GET_STRING('HRI', 'HRI_407493_OBIEE_PRODUCT_NAME')||'/'||
216: fnd_message.GET_STRING('HRI', 'HRI_407494_HRI_PRODUCT_NAME');
209: --
210: ELSIF g_prd_type_tab_v(p_object_name).all_ind = 1 then
211:
212: l_product_name :=fnd_message.GET_STRING('HRI', 'HRI_407493_OBIEE_PRODUCT_NAME')||' & '||
213: fnd_message.GET_STRING('HRI', 'HRI_407494_HRI_PRODUCT_NAME');
214: ELSE
215: l_product_name :=fnd_message.GET_STRING('HRI', 'HRI_407493_OBIEE_PRODUCT_NAME')||'/'||
216: fnd_message.GET_STRING('HRI', 'HRI_407494_HRI_PRODUCT_NAME');
217: END IF;
211:
212: l_product_name :=fnd_message.GET_STRING('HRI', 'HRI_407493_OBIEE_PRODUCT_NAME')||' & '||
213: fnd_message.GET_STRING('HRI', 'HRI_407494_HRI_PRODUCT_NAME');
214: ELSE
215: l_product_name :=fnd_message.GET_STRING('HRI', 'HRI_407493_OBIEE_PRODUCT_NAME')||'/'||
216: fnd_message.GET_STRING('HRI', 'HRI_407494_HRI_PRODUCT_NAME');
217: END IF;
218:
219: dbg('Exiting get_product_name');
212: l_product_name :=fnd_message.GET_STRING('HRI', 'HRI_407493_OBIEE_PRODUCT_NAME')||' & '||
213: fnd_message.GET_STRING('HRI', 'HRI_407494_HRI_PRODUCT_NAME');
214: ELSE
215: l_product_name :=fnd_message.GET_STRING('HRI', 'HRI_407493_OBIEE_PRODUCT_NAME')||'/'||
216: fnd_message.GET_STRING('HRI', 'HRI_407494_HRI_PRODUCT_NAME');
217: END IF;
218:
219: dbg('Exiting get_product_name');
220: RETURN l_product_name;
231:
232: l_product_name VARCHAR2(1000);
233: BEGIN
234:
235: fnd_message.set_name('HRI', p_message);
236: fnd_message.set_token('PROFILE_NAME',p_user_profile_name);
237:
238: IF is_token_exist(p_message,'PRODUCT_NAME') THEN
239: l_product_name:= get_product_name(p_object_name => g_object_name);
232: l_product_name VARCHAR2(1000);
233: BEGIN
234:
235: fnd_message.set_name('HRI', p_message);
236: fnd_message.set_token('PROFILE_NAME',p_user_profile_name);
237:
238: IF is_token_exist(p_message,'PRODUCT_NAME') THEN
239: l_product_name:= get_product_name(p_object_name => g_object_name);
240: fnd_message.set_token('PRODUCT_NAME',l_product_name);
236: fnd_message.set_token('PROFILE_NAME',p_user_profile_name);
237:
238: IF is_token_exist(p_message,'PRODUCT_NAME') THEN
239: l_product_name:= get_product_name(p_object_name => g_object_name);
240: fnd_message.set_token('PRODUCT_NAME',l_product_name);
241: END IF;
242:
243: RETURN trim_msg(fnd_message.get);
244:
239: l_product_name:= get_product_name(p_object_name => g_object_name);
240: fnd_message.set_token('PRODUCT_NAME',l_product_name);
241: END IF;
242:
243: RETURN trim_msg(fnd_message.get);
244:
245: END get_profile_message;
246:
247:
254: RETURN VARCHAR2 IS
255:
256: BEGIN
257:
258: fnd_message.set_name('HRI', p_message);
259:
260: -- Set the Fast Formula name
261: fnd_message.set_token('FF_NAME',p_ff_name);
262:
257:
258: fnd_message.set_name('HRI', p_message);
259:
260: -- Set the Fast Formula name
261: fnd_message.set_token('FF_NAME',p_ff_name);
262:
263: IF is_token_exist(p_message,'PRODUCT_NAME')
264: THEN
265: fnd_message.set_token('PRODUCT_NAME',get_product_name(p_object_name => g_object_name));
261: fnd_message.set_token('FF_NAME',p_ff_name);
262:
263: IF is_token_exist(p_message,'PRODUCT_NAME')
264: THEN
265: fnd_message.set_token('PRODUCT_NAME',get_product_name(p_object_name => g_object_name));
266: END IF;
267:
268:
269: RETURN trim_msg(fnd_message.get);
265: fnd_message.set_token('PRODUCT_NAME',get_product_name(p_object_name => g_object_name));
266: END IF;
267:
268:
269: RETURN trim_msg(fnd_message.get);
270:
271: END get_ff_message;
272:
273: -- ----------------------------------------------------------------------------
905: IF (fnd_profile.value('HR_BIS_JOB_FAMILY') IS NULL AND
906: fnd_profile.value('HR_BIS_JOB_FUNCTION') IS NULL) THEN
907:
908: -- Set the message up
909: fnd_message.set_name
910: ('HRI','HRI_407183_UNSET_JOB_PRF_IMPCT');
911:
912: -- Set the Profile names
913: fnd_message.set_token
909: fnd_message.set_name
910: ('HRI','HRI_407183_UNSET_JOB_PRF_IMPCT');
911:
912: -- Set the Profile names
913: fnd_message.set_token
914: ('PROFILE_NAME1',get_user_profile_name('BIS_GLOBAL_START_DATE'));
915: fnd_message.set_token
916: ('PROFILE_NAME2',get_user_profile_name('HR_BIS_JOB_FAMILY'));
917: fnd_message.set_token
911:
912: -- Set the Profile names
913: fnd_message.set_token
914: ('PROFILE_NAME1',get_user_profile_name('BIS_GLOBAL_START_DATE'));
915: fnd_message.set_token
916: ('PROFILE_NAME2',get_user_profile_name('HR_BIS_JOB_FAMILY'));
917: fnd_message.set_token
918: ('PROFILE_NAME3',get_user_profile_name('HR_BIS_JOB_FUNCTION'));
919:
913: fnd_message.set_token
914: ('PROFILE_NAME1',get_user_profile_name('BIS_GLOBAL_START_DATE'));
915: fnd_message.set_token
916: ('PROFILE_NAME2',get_user_profile_name('HR_BIS_JOB_FAMILY'));
917: fnd_message.set_token
918: ('PROFILE_NAME3',get_user_profile_name('HR_BIS_JOB_FUNCTION'));
919:
920: -- Store the general impact message
921: p_impact := TRUE;
918: ('PROFILE_NAME3',get_user_profile_name('HR_BIS_JOB_FUNCTION'));
919:
920: -- Store the general impact message
921: p_impact := TRUE;
922: p_impact_msg := trim_msg(fnd_message.get);
923:
924: ELSE
925:
926: -- Find the profile value for Job Family and Job Function