283: WHEN OTHERS THEN RAISE;
284: END SQL_SHOW_ERROR;
285:
286:
287: -- Bug 3516763: created function get_fnd_msg_pub_last
288: --------------------------------------------------------------------------------
289: --Start of Comments
290: --Name: get_fnd_msg_pub_last
291: --Pre-reqs:
286:
287: -- Bug 3516763: created function get_fnd_msg_pub_last
288: --------------------------------------------------------------------------------
289: --Start of Comments
290: --Name: get_fnd_msg_pub_last
291: --Pre-reqs:
292: -- N/A
293: --Modifies:
294: -- N/A
295: --Locks:
296: -- N/A
297: --Function:
298: -- This function gets the string value of the last message on the
299: -- API message list [fnd_msg_pub].
300: --Parameters:
301: --IN:
302: -- N/A
303: --Testing:
303: --Testing:
304: --
305: --End of Comments
306: -------------------------------------------------------------------------------
307: FUNCTION GET_FND_MSG_PUB_LAST RETURN varchar2
308: IS
309: BEGIN
310: return FND_MSG_PUB.get( p_encoded => FND_API.G_FALSE
311: , p_msg_index => FND_MSG_PUB.G_LAST
306: -------------------------------------------------------------------------------
307: FUNCTION GET_FND_MSG_PUB_LAST RETURN varchar2
308: IS
309: BEGIN
310: return FND_MSG_PUB.get( p_encoded => FND_API.G_FALSE
311: , p_msg_index => FND_MSG_PUB.G_LAST
312: );
313: EXCEPTION
314: WHEN OTHERS THEN RAISE;
307: FUNCTION GET_FND_MSG_PUB_LAST RETURN varchar2
308: IS
309: BEGIN
310: return FND_MSG_PUB.get( p_encoded => FND_API.G_FALSE
311: , p_msg_index => FND_MSG_PUB.G_LAST
312: );
313: EXCEPTION
314: WHEN OTHERS THEN RAISE;
315: END GET_FND_MSG_PUB_LAST;
311: , p_msg_index => FND_MSG_PUB.G_LAST
312: );
313: EXCEPTION
314: WHEN OTHERS THEN RAISE;
315: END GET_FND_MSG_PUB_LAST;
316:
317:
318:
319: --------------------------------------------------------------------------------
325: -- N/A
326: --Locks:
327: -- N/A
328: --Function:
329: -- Wrapper to FND_MSG_PUB.add_exc_msg. This procedure logs the same msg
330: -- we are putting to FND msg stack
331: --Parameters:
332: --IN:
333: --p_pkg_name
351: l_msg FND_NEW_MESSAGES.message_text%TYPE;
352:
353: BEGIN
354:
355: FND_MSG_PUB.add_exc_msg
356: ( p_pkg_name => p_pkg_name
357: , p_procedure_name => p_procedure_name
358: , p_error_text => p_error_text
359: );
358: , p_error_text => p_error_text
359: );
360:
361: -- get the message just inserted
362: l_msg := FND_MSG_PUB.get
363: ( p_msg_index => FND_MSG_PUB.count_msg
364: , p_encoded => FND_API.G_FALSE
365: );
366:
359: );
360:
361: -- get the message just inserted
362: l_msg := FND_MSG_PUB.get
363: ( p_msg_index => FND_MSG_PUB.count_msg
364: , p_encoded => FND_API.G_FALSE
365: );
366:
367: -- no need to specify progress because d_module should have included it
381: -- N/A
382: --Locks:
383: -- N/A
384: --Function:
385: -- Concatenates all messages in FND_MSG_PUB stack with the max size specified
386: -- as parameter
387: --Parameters:
388: --IN:
389: --p_max_size
401:
402: l_msg_temp VARCHAR2(2000);
403:
404: BEGIN
405: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
406: l_msg_temp := FND_MSG_PUB.get
407: ( p_msg_index => i,
408: p_encoded => 'F'
409: );
402: l_msg_temp VARCHAR2(2000);
403:
404: BEGIN
405: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
406: l_msg_temp := FND_MSG_PUB.get
407: ( p_msg_index => i,
408: p_encoded => 'F'
409: );
410: