295: /*
296: ** Build the message string.
297: */
298:
299: fnd_message.set_name ('RLM', x_message_name);
300:
301: /*
302: ** Replace the tokens.
303: */
305: IF (x_token1 is NULL) THEN
306: null;
307:
308: ELSIF (x_token2 is NULL) THEN
309: fnd_message.set_token (x_token1, SUBSTR(x_value1,1,2000));
310: null;
311:
312: ELSIF (x_token3 is NULL) THEN
313: fnd_message.set_token (x_token1, x_value1);
309: fnd_message.set_token (x_token1, SUBSTR(x_value1,1,2000));
310: null;
311:
312: ELSIF (x_token3 is NULL) THEN
313: fnd_message.set_token (x_token1, x_value1);
314: null;
315: fnd_message.set_token (x_token2, x_value2);
316:
317: ELSIF (x_token4 is NULL) THEN
311:
312: ELSIF (x_token3 is NULL) THEN
313: fnd_message.set_token (x_token1, x_value1);
314: null;
315: fnd_message.set_token (x_token2, x_value2);
316:
317: ELSIF (x_token4 is NULL) THEN
318: fnd_message.set_token (x_token1, x_value1);
319: fnd_message.set_token (x_token2, x_value2);
314: null;
315: fnd_message.set_token (x_token2, x_value2);
316:
317: ELSIF (x_token4 is NULL) THEN
318: fnd_message.set_token (x_token1, x_value1);
319: fnd_message.set_token (x_token2, x_value2);
320: fnd_message.set_token (x_token3, x_value3);
321: null;
322:
315: fnd_message.set_token (x_token2, x_value2);
316:
317: ELSIF (x_token4 is NULL) THEN
318: fnd_message.set_token (x_token1, x_value1);
319: fnd_message.set_token (x_token2, x_value2);
320: fnd_message.set_token (x_token3, x_value3);
321: null;
322:
323: ELSIF (x_token5 is NULL) THEN
316:
317: ELSIF (x_token4 is NULL) THEN
318: fnd_message.set_token (x_token1, x_value1);
319: fnd_message.set_token (x_token2, x_value2);
320: fnd_message.set_token (x_token3, x_value3);
321: null;
322:
323: ELSIF (x_token5 is NULL) THEN
324: fnd_message.set_token (x_token1, x_value1);
320: fnd_message.set_token (x_token3, x_value3);
321: null;
322:
323: ELSIF (x_token5 is NULL) THEN
324: fnd_message.set_token (x_token1, x_value1);
325: fnd_message.set_token (x_token2, x_value2);
326: fnd_message.set_token (x_token3, x_value3);
327: fnd_message.set_token (x_token4, x_value4);
328: null;
321: null;
322:
323: ELSIF (x_token5 is NULL) THEN
324: fnd_message.set_token (x_token1, x_value1);
325: fnd_message.set_token (x_token2, x_value2);
326: fnd_message.set_token (x_token3, x_value3);
327: fnd_message.set_token (x_token4, x_value4);
328: null;
329:
322:
323: ELSIF (x_token5 is NULL) THEN
324: fnd_message.set_token (x_token1, x_value1);
325: fnd_message.set_token (x_token2, x_value2);
326: fnd_message.set_token (x_token3, x_value3);
327: fnd_message.set_token (x_token4, x_value4);
328: null;
329:
330: ELSIF (x_token6 is NULL) THEN
323: ELSIF (x_token5 is NULL) THEN
324: fnd_message.set_token (x_token1, x_value1);
325: fnd_message.set_token (x_token2, x_value2);
326: fnd_message.set_token (x_token3, x_value3);
327: fnd_message.set_token (x_token4, x_value4);
328: null;
329:
330: ELSIF (x_token6 is NULL) THEN
331: fnd_message.set_token (x_token1, x_value1);
327: fnd_message.set_token (x_token4, x_value4);
328: null;
329:
330: ELSIF (x_token6 is NULL) THEN
331: fnd_message.set_token (x_token1, x_value1);
332: fnd_message.set_token (x_token2, x_value2);
333: fnd_message.set_token (x_token3, x_value3);
334: fnd_message.set_token (x_token4, x_value4);
335: fnd_message.set_token (x_token5, x_value5);
328: null;
329:
330: ELSIF (x_token6 is NULL) THEN
331: fnd_message.set_token (x_token1, x_value1);
332: fnd_message.set_token (x_token2, x_value2);
333: fnd_message.set_token (x_token3, x_value3);
334: fnd_message.set_token (x_token4, x_value4);
335: fnd_message.set_token (x_token5, x_value5);
336: null;
329:
330: ELSIF (x_token6 is NULL) THEN
331: fnd_message.set_token (x_token1, x_value1);
332: fnd_message.set_token (x_token2, x_value2);
333: fnd_message.set_token (x_token3, x_value3);
334: fnd_message.set_token (x_token4, x_value4);
335: fnd_message.set_token (x_token5, x_value5);
336: null;
337: -- Bug 4297984
330: ELSIF (x_token6 is NULL) THEN
331: fnd_message.set_token (x_token1, x_value1);
332: fnd_message.set_token (x_token2, x_value2);
333: fnd_message.set_token (x_token3, x_value3);
334: fnd_message.set_token (x_token4, x_value4);
335: fnd_message.set_token (x_token5, x_value5);
336: null;
337: -- Bug 4297984
338: ELSIF (x_token7 is NULL) THEN
331: fnd_message.set_token (x_token1, x_value1);
332: fnd_message.set_token (x_token2, x_value2);
333: fnd_message.set_token (x_token3, x_value3);
334: fnd_message.set_token (x_token4, x_value4);
335: fnd_message.set_token (x_token5, x_value5);
336: null;
337: -- Bug 4297984
338: ELSIF (x_token7 is NULL) THEN
339: fnd_message.set_token (x_token1, x_value1);
335: fnd_message.set_token (x_token5, x_value5);
336: null;
337: -- Bug 4297984
338: ELSIF (x_token7 is NULL) THEN
339: fnd_message.set_token (x_token1, x_value1);
340: fnd_message.set_token (x_token2, x_value2);
341: fnd_message.set_token (x_token3, x_value3);
342: fnd_message.set_token (x_token4, x_value4);
343: fnd_message.set_token (x_token5, x_value5);
336: null;
337: -- Bug 4297984
338: ELSIF (x_token7 is NULL) THEN
339: fnd_message.set_token (x_token1, x_value1);
340: fnd_message.set_token (x_token2, x_value2);
341: fnd_message.set_token (x_token3, x_value3);
342: fnd_message.set_token (x_token4, x_value4);
343: fnd_message.set_token (x_token5, x_value5);
344: fnd_message.set_token (x_token6, x_value6);
337: -- Bug 4297984
338: ELSIF (x_token7 is NULL) THEN
339: fnd_message.set_token (x_token1, x_value1);
340: fnd_message.set_token (x_token2, x_value2);
341: fnd_message.set_token (x_token3, x_value3);
342: fnd_message.set_token (x_token4, x_value4);
343: fnd_message.set_token (x_token5, x_value5);
344: fnd_message.set_token (x_token6, x_value6);
345: null;
338: ELSIF (x_token7 is NULL) THEN
339: fnd_message.set_token (x_token1, x_value1);
340: fnd_message.set_token (x_token2, x_value2);
341: fnd_message.set_token (x_token3, x_value3);
342: fnd_message.set_token (x_token4, x_value4);
343: fnd_message.set_token (x_token5, x_value5);
344: fnd_message.set_token (x_token6, x_value6);
345: null;
346:
339: fnd_message.set_token (x_token1, x_value1);
340: fnd_message.set_token (x_token2, x_value2);
341: fnd_message.set_token (x_token3, x_value3);
342: fnd_message.set_token (x_token4, x_value4);
343: fnd_message.set_token (x_token5, x_value5);
344: fnd_message.set_token (x_token6, x_value6);
345: null;
346:
347: ELSIF (x_token8 is NULL) THEN
340: fnd_message.set_token (x_token2, x_value2);
341: fnd_message.set_token (x_token3, x_value3);
342: fnd_message.set_token (x_token4, x_value4);
343: fnd_message.set_token (x_token5, x_value5);
344: fnd_message.set_token (x_token6, x_value6);
345: null;
346:
347: ELSIF (x_token8 is NULL) THEN
348: fnd_message.set_token (x_token1, x_value1);
344: fnd_message.set_token (x_token6, x_value6);
345: null;
346:
347: ELSIF (x_token8 is NULL) THEN
348: fnd_message.set_token (x_token1, x_value1);
349: fnd_message.set_token (x_token2, x_value2);
350: fnd_message.set_token (x_token3, x_value3);
351: fnd_message.set_token (x_token4, x_value4);
352: fnd_message.set_token (x_token5, x_value5);
345: null;
346:
347: ELSIF (x_token8 is NULL) THEN
348: fnd_message.set_token (x_token1, x_value1);
349: fnd_message.set_token (x_token2, x_value2);
350: fnd_message.set_token (x_token3, x_value3);
351: fnd_message.set_token (x_token4, x_value4);
352: fnd_message.set_token (x_token5, x_value5);
353: fnd_message.set_token (x_token6, x_value6);
346:
347: ELSIF (x_token8 is NULL) THEN
348: fnd_message.set_token (x_token1, x_value1);
349: fnd_message.set_token (x_token2, x_value2);
350: fnd_message.set_token (x_token3, x_value3);
351: fnd_message.set_token (x_token4, x_value4);
352: fnd_message.set_token (x_token5, x_value5);
353: fnd_message.set_token (x_token6, x_value6);
354: fnd_message.set_token (x_token7, x_value7);
347: ELSIF (x_token8 is NULL) THEN
348: fnd_message.set_token (x_token1, x_value1);
349: fnd_message.set_token (x_token2, x_value2);
350: fnd_message.set_token (x_token3, x_value3);
351: fnd_message.set_token (x_token4, x_value4);
352: fnd_message.set_token (x_token5, x_value5);
353: fnd_message.set_token (x_token6, x_value6);
354: fnd_message.set_token (x_token7, x_value7);
355: null;
348: fnd_message.set_token (x_token1, x_value1);
349: fnd_message.set_token (x_token2, x_value2);
350: fnd_message.set_token (x_token3, x_value3);
351: fnd_message.set_token (x_token4, x_value4);
352: fnd_message.set_token (x_token5, x_value5);
353: fnd_message.set_token (x_token6, x_value6);
354: fnd_message.set_token (x_token7, x_value7);
355: null;
356:
349: fnd_message.set_token (x_token2, x_value2);
350: fnd_message.set_token (x_token3, x_value3);
351: fnd_message.set_token (x_token4, x_value4);
352: fnd_message.set_token (x_token5, x_value5);
353: fnd_message.set_token (x_token6, x_value6);
354: fnd_message.set_token (x_token7, x_value7);
355: null;
356:
357: ELSIF (x_token9 is NULL) THEN
350: fnd_message.set_token (x_token3, x_value3);
351: fnd_message.set_token (x_token4, x_value4);
352: fnd_message.set_token (x_token5, x_value5);
353: fnd_message.set_token (x_token6, x_value6);
354: fnd_message.set_token (x_token7, x_value7);
355: null;
356:
357: ELSIF (x_token9 is NULL) THEN
358: fnd_message.set_token (x_token1, x_value1);
354: fnd_message.set_token (x_token7, x_value7);
355: null;
356:
357: ELSIF (x_token9 is NULL) THEN
358: fnd_message.set_token (x_token1, x_value1);
359: fnd_message.set_token (x_token2, x_value2);
360: fnd_message.set_token (x_token3, x_value3);
361: fnd_message.set_token (x_token4, x_value4);
362: fnd_message.set_token (x_token5, x_value5);
355: null;
356:
357: ELSIF (x_token9 is NULL) THEN
358: fnd_message.set_token (x_token1, x_value1);
359: fnd_message.set_token (x_token2, x_value2);
360: fnd_message.set_token (x_token3, x_value3);
361: fnd_message.set_token (x_token4, x_value4);
362: fnd_message.set_token (x_token5, x_value5);
363: fnd_message.set_token (x_token6, x_value6);
356:
357: ELSIF (x_token9 is NULL) THEN
358: fnd_message.set_token (x_token1, x_value1);
359: fnd_message.set_token (x_token2, x_value2);
360: fnd_message.set_token (x_token3, x_value3);
361: fnd_message.set_token (x_token4, x_value4);
362: fnd_message.set_token (x_token5, x_value5);
363: fnd_message.set_token (x_token6, x_value6);
364: fnd_message.set_token (x_token7, x_value7);
357: ELSIF (x_token9 is NULL) THEN
358: fnd_message.set_token (x_token1, x_value1);
359: fnd_message.set_token (x_token2, x_value2);
360: fnd_message.set_token (x_token3, x_value3);
361: fnd_message.set_token (x_token4, x_value4);
362: fnd_message.set_token (x_token5, x_value5);
363: fnd_message.set_token (x_token6, x_value6);
364: fnd_message.set_token (x_token7, x_value7);
365: fnd_message.set_token (x_token8, x_value8);
358: fnd_message.set_token (x_token1, x_value1);
359: fnd_message.set_token (x_token2, x_value2);
360: fnd_message.set_token (x_token3, x_value3);
361: fnd_message.set_token (x_token4, x_value4);
362: fnd_message.set_token (x_token5, x_value5);
363: fnd_message.set_token (x_token6, x_value6);
364: fnd_message.set_token (x_token7, x_value7);
365: fnd_message.set_token (x_token8, x_value8);
366: null;
359: fnd_message.set_token (x_token2, x_value2);
360: fnd_message.set_token (x_token3, x_value3);
361: fnd_message.set_token (x_token4, x_value4);
362: fnd_message.set_token (x_token5, x_value5);
363: fnd_message.set_token (x_token6, x_value6);
364: fnd_message.set_token (x_token7, x_value7);
365: fnd_message.set_token (x_token8, x_value8);
366: null;
367:
360: fnd_message.set_token (x_token3, x_value3);
361: fnd_message.set_token (x_token4, x_value4);
362: fnd_message.set_token (x_token5, x_value5);
363: fnd_message.set_token (x_token6, x_value6);
364: fnd_message.set_token (x_token7, x_value7);
365: fnd_message.set_token (x_token8, x_value8);
366: null;
367:
368: ELSIF (x_token10 is NULL) THEN
361: fnd_message.set_token (x_token4, x_value4);
362: fnd_message.set_token (x_token5, x_value5);
363: fnd_message.set_token (x_token6, x_value6);
364: fnd_message.set_token (x_token7, x_value7);
365: fnd_message.set_token (x_token8, x_value8);
366: null;
367:
368: ELSIF (x_token10 is NULL) THEN
369: fnd_message.set_token (x_token1, x_value1);
365: fnd_message.set_token (x_token8, x_value8);
366: null;
367:
368: ELSIF (x_token10 is NULL) THEN
369: fnd_message.set_token (x_token1, x_value1);
370: fnd_message.set_token (x_token2, x_value2);
371: fnd_message.set_token (x_token3, x_value3);
372: fnd_message.set_token (x_token4, x_value4);
373: fnd_message.set_token (x_token5, x_value5);
366: null;
367:
368: ELSIF (x_token10 is NULL) THEN
369: fnd_message.set_token (x_token1, x_value1);
370: fnd_message.set_token (x_token2, x_value2);
371: fnd_message.set_token (x_token3, x_value3);
372: fnd_message.set_token (x_token4, x_value4);
373: fnd_message.set_token (x_token5, x_value5);
374: fnd_message.set_token (x_token6, x_value6);
367:
368: ELSIF (x_token10 is NULL) THEN
369: fnd_message.set_token (x_token1, x_value1);
370: fnd_message.set_token (x_token2, x_value2);
371: fnd_message.set_token (x_token3, x_value3);
372: fnd_message.set_token (x_token4, x_value4);
373: fnd_message.set_token (x_token5, x_value5);
374: fnd_message.set_token (x_token6, x_value6);
375: fnd_message.set_token (x_token7, x_value7);
368: ELSIF (x_token10 is NULL) THEN
369: fnd_message.set_token (x_token1, x_value1);
370: fnd_message.set_token (x_token2, x_value2);
371: fnd_message.set_token (x_token3, x_value3);
372: fnd_message.set_token (x_token4, x_value4);
373: fnd_message.set_token (x_token5, x_value5);
374: fnd_message.set_token (x_token6, x_value6);
375: fnd_message.set_token (x_token7, x_value7);
376: fnd_message.set_token (x_token8, x_value8);
369: fnd_message.set_token (x_token1, x_value1);
370: fnd_message.set_token (x_token2, x_value2);
371: fnd_message.set_token (x_token3, x_value3);
372: fnd_message.set_token (x_token4, x_value4);
373: fnd_message.set_token (x_token5, x_value5);
374: fnd_message.set_token (x_token6, x_value6);
375: fnd_message.set_token (x_token7, x_value7);
376: fnd_message.set_token (x_token8, x_value8);
377: fnd_message.set_token (x_token9, x_value9);
370: fnd_message.set_token (x_token2, x_value2);
371: fnd_message.set_token (x_token3, x_value3);
372: fnd_message.set_token (x_token4, x_value4);
373: fnd_message.set_token (x_token5, x_value5);
374: fnd_message.set_token (x_token6, x_value6);
375: fnd_message.set_token (x_token7, x_value7);
376: fnd_message.set_token (x_token8, x_value8);
377: fnd_message.set_token (x_token9, x_value9);
378: null;
371: fnd_message.set_token (x_token3, x_value3);
372: fnd_message.set_token (x_token4, x_value4);
373: fnd_message.set_token (x_token5, x_value5);
374: fnd_message.set_token (x_token6, x_value6);
375: fnd_message.set_token (x_token7, x_value7);
376: fnd_message.set_token (x_token8, x_value8);
377: fnd_message.set_token (x_token9, x_value9);
378: null;
379:
372: fnd_message.set_token (x_token4, x_value4);
373: fnd_message.set_token (x_token5, x_value5);
374: fnd_message.set_token (x_token6, x_value6);
375: fnd_message.set_token (x_token7, x_value7);
376: fnd_message.set_token (x_token8, x_value8);
377: fnd_message.set_token (x_token9, x_value9);
378: null;
379:
380: ELSE
373: fnd_message.set_token (x_token5, x_value5);
374: fnd_message.set_token (x_token6, x_value6);
375: fnd_message.set_token (x_token7, x_value7);
376: fnd_message.set_token (x_token8, x_value8);
377: fnd_message.set_token (x_token9, x_value9);
378: null;
379:
380: ELSE
381: fnd_message.set_token (x_token1, x_value1);
377: fnd_message.set_token (x_token9, x_value9);
378: null;
379:
380: ELSE
381: fnd_message.set_token (x_token1, x_value1);
382: fnd_message.set_token (x_token2, x_value2);
383: fnd_message.set_token (x_token3, x_value3);
384: fnd_message.set_token (x_token4, x_value4);
385: fnd_message.set_token (x_token5, x_value5);
378: null;
379:
380: ELSE
381: fnd_message.set_token (x_token1, x_value1);
382: fnd_message.set_token (x_token2, x_value2);
383: fnd_message.set_token (x_token3, x_value3);
384: fnd_message.set_token (x_token4, x_value4);
385: fnd_message.set_token (x_token5, x_value5);
386: fnd_message.set_token (x_token6, x_value6);
379:
380: ELSE
381: fnd_message.set_token (x_token1, x_value1);
382: fnd_message.set_token (x_token2, x_value2);
383: fnd_message.set_token (x_token3, x_value3);
384: fnd_message.set_token (x_token4, x_value4);
385: fnd_message.set_token (x_token5, x_value5);
386: fnd_message.set_token (x_token6, x_value6);
387: fnd_message.set_token (x_token7, x_value7);
380: ELSE
381: fnd_message.set_token (x_token1, x_value1);
382: fnd_message.set_token (x_token2, x_value2);
383: fnd_message.set_token (x_token3, x_value3);
384: fnd_message.set_token (x_token4, x_value4);
385: fnd_message.set_token (x_token5, x_value5);
386: fnd_message.set_token (x_token6, x_value6);
387: fnd_message.set_token (x_token7, x_value7);
388: fnd_message.set_token (x_token8, x_value8);
381: fnd_message.set_token (x_token1, x_value1);
382: fnd_message.set_token (x_token2, x_value2);
383: fnd_message.set_token (x_token3, x_value3);
384: fnd_message.set_token (x_token4, x_value4);
385: fnd_message.set_token (x_token5, x_value5);
386: fnd_message.set_token (x_token6, x_value6);
387: fnd_message.set_token (x_token7, x_value7);
388: fnd_message.set_token (x_token8, x_value8);
389: fnd_message.set_token (x_token9, x_value9);
382: fnd_message.set_token (x_token2, x_value2);
383: fnd_message.set_token (x_token3, x_value3);
384: fnd_message.set_token (x_token4, x_value4);
385: fnd_message.set_token (x_token5, x_value5);
386: fnd_message.set_token (x_token6, x_value6);
387: fnd_message.set_token (x_token7, x_value7);
388: fnd_message.set_token (x_token8, x_value8);
389: fnd_message.set_token (x_token9, x_value9);
390: fnd_message.set_token (x_token10, x_value10);
383: fnd_message.set_token (x_token3, x_value3);
384: fnd_message.set_token (x_token4, x_value4);
385: fnd_message.set_token (x_token5, x_value5);
386: fnd_message.set_token (x_token6, x_value6);
387: fnd_message.set_token (x_token7, x_value7);
388: fnd_message.set_token (x_token8, x_value8);
389: fnd_message.set_token (x_token9, x_value9);
390: fnd_message.set_token (x_token10, x_value10);
391: null;
384: fnd_message.set_token (x_token4, x_value4);
385: fnd_message.set_token (x_token5, x_value5);
386: fnd_message.set_token (x_token6, x_value6);
387: fnd_message.set_token (x_token7, x_value7);
388: fnd_message.set_token (x_token8, x_value8);
389: fnd_message.set_token (x_token9, x_value9);
390: fnd_message.set_token (x_token10, x_value10);
391: null;
392:
385: fnd_message.set_token (x_token5, x_value5);
386: fnd_message.set_token (x_token6, x_value6);
387: fnd_message.set_token (x_token7, x_value7);
388: fnd_message.set_token (x_token8, x_value8);
389: fnd_message.set_token (x_token9, x_value9);
390: fnd_message.set_token (x_token10, x_value10);
391: null;
392:
393: END IF;
386: fnd_message.set_token (x_token6, x_value6);
387: fnd_message.set_token (x_token7, x_value7);
388: fnd_message.set_token (x_token8, x_value8);
389: fnd_message.set_token (x_token9, x_value9);
390: fnd_message.set_token (x_token10, x_value10);
391: null;
392:
393: END IF;
394:
395: /*
396: ** Retrieve the error message.
397: */
398:
399: x_text := fnd_message.get;
400:
401: EXCEPTION
402: WHEN OTHERS THEN
403: RAISE;
634: */
635: --
636: IF (x_ExceptionLevel = g_error) THEN
637: --
638: fnd_message.set_name ('RLM', 'RLM_ERROR');
639: v_error_txt := fnd_message.get;
640: v_MessageText := v_error_txt ||': ' || x_ErrorText;
641: g_error_flag := 'Y';
642: --
635: --
636: IF (x_ExceptionLevel = g_error) THEN
637: --
638: fnd_message.set_name ('RLM', 'RLM_ERROR');
639: v_error_txt := fnd_message.get;
640: v_MessageText := v_error_txt ||': ' || x_ErrorText;
641: g_error_flag := 'Y';
642: --
643: ELSIF (x_ExceptionLevel = g_warn) THEN
641: g_error_flag := 'Y';
642: --
643: ELSIF (x_ExceptionLevel = g_warn) THEN
644: --
645: fnd_message.set_name ('RLM', 'RLM_WARNING');
646: v_warn_txt := fnd_message.get;
647: v_MessageText := v_warn_txt ||': '|| x_ErrorText;
648: g_warn_flag := 'Y';
649: --
642: --
643: ELSIF (x_ExceptionLevel = g_warn) THEN
644: --
645: fnd_message.set_name ('RLM', 'RLM_WARNING');
646: v_warn_txt := fnd_message.get;
647: v_MessageText := v_warn_txt ||': '|| x_ErrorText;
648: g_warn_flag := 'Y';
649: --
650: ELSIF (x_ExceptionLevel = g_info) THEN
648: g_warn_flag := 'Y';
649: --
650: ELSIF (x_ExceptionLevel = g_info) THEN
651: --
652: fnd_message.set_name ('RLM', 'RLM_INFORMATION');
653: v_info_txt := fnd_message.get;
654: v_MessageText := v_info_txt ||': ' || x_ErrorText;
655: g_info_flag := 'Y';
656: --
649: --
650: ELSIF (x_ExceptionLevel = g_info) THEN
651: --
652: fnd_message.set_name ('RLM', 'RLM_INFORMATION');
653: v_info_txt := fnd_message.get;
654: v_MessageText := v_info_txt ||': ' || x_ErrorText;
655: g_info_flag := 'Y';
656: --
657: END IF;
961: */
962:
963:
964: IF (x_ExceptionLevel = g_error) THEN
965: fnd_message.set_name ('RLM', 'RLM_ERROR');
966: v_error_txt := fnd_message.get;
967: v_MessageText := v_error_txt ||': ' || x_ErrorText;
968: g_error_flag := 'Y';
969:
962:
963:
964: IF (x_ExceptionLevel = g_error) THEN
965: fnd_message.set_name ('RLM', 'RLM_ERROR');
966: v_error_txt := fnd_message.get;
967: v_MessageText := v_error_txt ||': ' || x_ErrorText;
968: g_error_flag := 'Y';
969:
970:
968: g_error_flag := 'Y';
969:
970:
971: ELSIF (x_ExceptionLevel = g_warn) THEN
972: fnd_message.set_name ('RLM', 'RLM_WARNING');
973: v_warn_txt := fnd_message.get;
974: v_MessageText := v_warn_txt ||': '|| x_ErrorText;
975: g_warn_flag := 'Y';
976:
969:
970:
971: ELSIF (x_ExceptionLevel = g_warn) THEN
972: fnd_message.set_name ('RLM', 'RLM_WARNING');
973: v_warn_txt := fnd_message.get;
974: v_MessageText := v_warn_txt ||': '|| x_ErrorText;
975: g_warn_flag := 'Y';
976:
977:
975: g_warn_flag := 'Y';
976:
977:
978: ELSIF (x_ExceptionLevel = g_info) THEN
979: fnd_message.set_name ('RLM', 'RLM_INFORMATION');
980: v_info_txt := fnd_message.get;
981: v_MessageText := v_info_txt ||': ' || x_ErrorText;
982: g_info_flag := 'Y';
983:
976:
977:
978: ELSIF (x_ExceptionLevel = g_info) THEN
979: fnd_message.set_name ('RLM', 'RLM_INFORMATION');
980: v_info_txt := fnd_message.get;
981: v_MessageText := v_info_txt ||': ' || x_ErrorText;
982: g_info_flag := 'Y';
983:
984: END IF;
1119: END IF;
1120: /*
1121: ** Build the message string.
1122: */
1123: fnd_message.set_name ('RLM', 'RLM_ALL_SQL_ERROR');
1124: fnd_message.set_token ('ROUTINE', g_routine);
1125: fnd_message.set_token ('ERR_NUMBER', g_location);
1126: fnd_message.set_token ('SQL_ERR', substr(sqlerrm,1,300));
1127: --
1120: /*
1121: ** Build the message string.
1122: */
1123: fnd_message.set_name ('RLM', 'RLM_ALL_SQL_ERROR');
1124: fnd_message.set_token ('ROUTINE', g_routine);
1125: fnd_message.set_token ('ERR_NUMBER', g_location);
1126: fnd_message.set_token ('SQL_ERR', substr(sqlerrm,1,300));
1127: --
1128: v_message_rec.exception_level := rlm_message_sv.k_error_level;
1121: ** Build the message string.
1122: */
1123: fnd_message.set_name ('RLM', 'RLM_ALL_SQL_ERROR');
1124: fnd_message.set_token ('ROUTINE', g_routine);
1125: fnd_message.set_token ('ERR_NUMBER', g_location);
1126: fnd_message.set_token ('SQL_ERR', substr(sqlerrm,1,300));
1127: --
1128: v_message_rec.exception_level := rlm_message_sv.k_error_level;
1129: v_message_rec.message_name := 'RLM_ALL_SQL_ERROR';
1122: */
1123: fnd_message.set_name ('RLM', 'RLM_ALL_SQL_ERROR');
1124: fnd_message.set_token ('ROUTINE', g_routine);
1125: fnd_message.set_token ('ERR_NUMBER', g_location);
1126: fnd_message.set_token ('SQL_ERR', substr(sqlerrm,1,300));
1127: --
1128: v_message_rec.exception_level := rlm_message_sv.k_error_level;
1129: v_message_rec.message_name := 'RLM_ALL_SQL_ERROR';
1130: v_message_rec.error_text := fnd_message.get;
1126: fnd_message.set_token ('SQL_ERR', substr(sqlerrm,1,300));
1127: --
1128: v_message_rec.exception_level := rlm_message_sv.k_error_level;
1129: v_message_rec.message_name := 'RLM_ALL_SQL_ERROR';
1130: v_message_rec.error_text := fnd_message.get;
1131: --
1132: v_incr := g_message_tab.COUNT + 1;
1133: --
1134: -- set the message in the table
1167: /*
1168: ** Build the message string.
1169: */
1170:
1171: fnd_message.set_name ('RLM', 'RLM_ALL_PROC_ERROR');
1172: fnd_message.set_token ('ROUTINE', g_routine);
1173: fnd_message.set_token ('ERR_NUMBER', g_location);
1174:
1175: EXCEPTION
1168: ** Build the message string.
1169: */
1170:
1171: fnd_message.set_name ('RLM', 'RLM_ALL_PROC_ERROR');
1172: fnd_message.set_token ('ROUTINE', g_routine);
1173: fnd_message.set_token ('ERR_NUMBER', g_location);
1174:
1175: EXCEPTION
1176: WHEN OTHERS THEN
1169: */
1170:
1171: fnd_message.set_name ('RLM', 'RLM_ALL_PROC_ERROR');
1172: fnd_message.set_token ('ROUTINE', g_routine);
1173: fnd_message.set_token ('ERR_NUMBER', g_location);
1174:
1175: EXCEPTION
1176: WHEN OTHERS THEN
1177: RAISE;
1194:
1195: /*
1196: ** Retrieve the message from the stack.
1197: */
1198: --return (fnd_message.get);
1199: return ('ERROR');
1200:
1201: EXCEPTION
1202: WHEN OTHERS THEN