159:
160: ELSE
161:
162:
163: l_error_msg := substr(bis_utilities_pvt.Get_FND_Message (
164: p_message_name => 'BISPMF_SCRTY_UPLD_FAIL'
165: , p_msg_param1 => 'RESP_KEY'
166: , p_msg_param1_val => p_responsibility_short_name
167: , p_msg_param2 => 'SUM_LVL'
177: EXCEPTION
178:
179: WHEN OTHERS THEN
180:
181: l_error_msg := bis_utilities_pvt.Get_FND_Message (
182: p_message_name => 'BISPMF_SCRTY_ERR_UNHNDLD'
183: , p_msg_param1 => 'RESP_KEY'
184: , p_msg_param1_val => p_responsibility_short_name
185: , p_msg_param2 => 'SUM_LVL'
256: EXCEPTION
257:
258: WHEN NO_DATA_FOUND THEN
259:
260: l_error_msg := bis_utilities_pvt.Get_FND_Message (
261: p_message_name => 'BISPMF_SCRTY_RESP_NO_EXIST'
262: , p_msg_param1 => 'RESP_KEY'
263: , p_msg_param1_val => p_responsibility_key
264: ) ;
269: x_return_status := 'E';
270:
271: WHEN OTHERS THEN
272:
273: l_error_msg := bis_utilities_pvt.Get_FND_Message (
274: p_message_name => 'BISPMF_SCRTY_RESP_NO_EXIST'
275: , p_msg_param1 => 'RESP_KEY'
276: , p_msg_param1_val => p_responsibility_key
277: ) ;
311: EXCEPTION
312:
313: WHEN NO_DATA_FOUND THEN
314:
315: l_error_msg := substr(bis_utilities_pvt.Get_FND_Message (
316: p_message_name => 'BISPMF_SCRTY_SUMLVL_NO_EXIST'
317: , p_msg_param1 => 'SUM_LVL'
318: , p_msg_param1_val => p_target_level_short_name
319: ),1,80) ;
324: x_return_status := 'E';
325:
326: WHEN OTHERS THEN
327:
328: l_error_msg := bis_utilities_pvt.Get_FND_Message (
329: p_message_name => 'BISPMF_SCRTY_SUMLVL_NO_EXIST'
330: , p_msg_param1 => 'SUM_LVL'
331: , p_msg_param1_val => p_target_level_short_name
332: ) ;