APPS.WIP_UTILITIES dependencies on FND_MSG_PUB

Line 374: fnd_msg_pub.Count_And_Get(p_encoded => fnd_api.g_false,

370: l_curMsg VARCHAR2(2000) := '';
371: l_msgCount NUMBER;
372: l_separator VARCHAR2(30) := nvl(p_separator,' ');
373: begin
374: fnd_msg_pub.Count_And_Get(p_encoded => fnd_api.g_false,
375: p_count => l_msgCount,
376: p_data => p_msg);
377:
378: IF(l_msgCount > 1) THEN

Line 380: l_curMsg := fnd_msg_pub.get(p_msg_index => l_msgCount - i + 1,

376: p_data => p_msg);
377:
378: IF(l_msgCount > 1) THEN
379: FOR i IN 1..l_msgCount LOOP
380: l_curMsg := fnd_msg_pub.get(p_msg_index => l_msgCount - i + 1,
381: p_encoded => FND_API.g_false);
382: if(nvl(length(p_msg), 0) + length(l_curMsg) + length(l_separator) < 2000) then
383: p_msg := p_msg || l_separator || l_curMsg;
384: end if;

Line 389: fnd_msg_pub.delete_msg;

385: END LOOP;
386: END IF;
387:
388: if(fnd_api.to_boolean(nvl(p_delete_stack,fnd_api.g_true))) then
389: fnd_msg_pub.delete_msg;
390: end if;
391:
392: EXCEPTION
393: WHEN OTHERS THEN

Line 394: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_utilities',

390: end if;
391:
392: EXCEPTION
393: WHEN OTHERS THEN
394: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_utilities',
395: p_procedure_name => 'get_message_stack',
396: p_error_text => SQLERRM);
397: p_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
398: if(fnd_api.to_boolean(nvl(p_delete_stack,fnd_api.g_true))) then

Line 397: p_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

393: WHEN OTHERS THEN
394: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_utilities',
395: p_procedure_name => 'get_message_stack',
396: p_error_text => SQLERRM);
397: p_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
398: if(fnd_api.to_boolean(nvl(p_delete_stack,fnd_api.g_true))) then
399: fnd_msg_pub.delete_msg;
400: end if;
401: END get_message_stack;

Line 399: fnd_msg_pub.delete_msg;

395: p_procedure_name => 'get_message_stack',
396: p_error_text => SQLERRM);
397: p_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
398: if(fnd_api.to_boolean(nvl(p_delete_stack,fnd_api.g_true))) then
399: fnd_msg_pub.delete_msg;
400: end if;
401: END get_message_stack;
402:
403: /* Deletes transaction records from the mtl temp tables */

Line 603: fnd_msg_pub.add;

599: when wip_constants.records_locked then
600: rollback to wipupdserial0;
601: x_return_status := fnd_api.g_ret_sts_unexp_error;
602: fnd_message.set_name('WIP', 'SERIAL_NUMBERS_LOCKED');
603: fnd_msg_pub.add;
604: when fnd_api.g_exc_unexpected_error then
605: rollback to wipupdserial0;
606: --status and message should have been set by inv api. set status
607: --just in case.

Line 613: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_utilities',

609:
610: when others then
611: rollback to wipupdserial0;
612: x_return_status := fnd_api.g_ret_sts_unexp_error;
613: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_utilities',
614: p_procedure_name => 'update_serial',
615: p_error_text => SQLERRM);
616: end update_serial;
617:

Line 665: fnd_msg_pub.add;

661: x_proc_msg => x_err_msg);
662: if(l_qty <> p_qty AND
663: l_status = 0) then
664: fnd_message.set_name('INV', 'INVALID_SERIAL_NUMBER');
665: fnd_msg_pub.add;
666: get_message_stack(p_msg => x_err_msg,
667: p_delete_stack => fnd_api.g_false,
668: p_separator => ' ');
669: end if;