APPS.WIP_UTILITIES dependencies on FND_MSG_PUB

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

313: l_curMsg VARCHAR2(2000) := '';
314: l_msgCount NUMBER;
315: l_separator VARCHAR2(30) := nvl(p_separator,' ');
316: begin
317: fnd_msg_pub.Count_And_Get(p_encoded => fnd_api.g_false,
318: p_count => l_msgCount,
319: p_data => p_msg);
320:
321: IF(l_msgCount > 1) THEN

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

319: p_data => p_msg);
320:
321: IF(l_msgCount > 1) THEN
322: FOR i IN 1..l_msgCount LOOP
323: l_curMsg := fnd_msg_pub.get(p_msg_index => l_msgCount - i + 1,
324: p_encoded => FND_API.g_false);
325: if(nvl(length(p_msg), 0) + length(l_curMsg) + length(l_separator) < 2000) then
326: p_msg := p_msg || l_separator || l_curMsg;
327: end if;

Line 332: fnd_msg_pub.delete_msg;

328: END LOOP;
329: END IF;
330:
331: if(fnd_api.to_boolean(nvl(p_delete_stack,fnd_api.g_true))) then
332: fnd_msg_pub.delete_msg;
333: end if;
334:
335: EXCEPTION
336: WHEN OTHERS THEN

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

333: end if;
334:
335: EXCEPTION
336: WHEN OTHERS THEN
337: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_utilities',
338: p_procedure_name => 'get_message_stack',
339: p_error_text => SQLERRM);
340: p_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
341: if(fnd_api.to_boolean(nvl(p_delete_stack,fnd_api.g_true))) then

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

336: WHEN OTHERS THEN
337: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_utilities',
338: p_procedure_name => 'get_message_stack',
339: p_error_text => SQLERRM);
340: p_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
341: if(fnd_api.to_boolean(nvl(p_delete_stack,fnd_api.g_true))) then
342: fnd_msg_pub.delete_msg;
343: end if;
344: END get_message_stack;

Line 342: fnd_msg_pub.delete_msg;

338: p_procedure_name => 'get_message_stack',
339: p_error_text => SQLERRM);
340: p_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
341: if(fnd_api.to_boolean(nvl(p_delete_stack,fnd_api.g_true))) then
342: fnd_msg_pub.delete_msg;
343: end if;
344: END get_message_stack;
345:
346: /* Deletes transaction records from the mtl temp tables */

Line 545: fnd_msg_pub.add;

541: when wip_constants.records_locked then
542: rollback to wipupdserial0;
543: x_return_status := fnd_api.g_ret_sts_unexp_error;
544: fnd_message.set_name('WIP', 'SERIAL_NUMBERS_LOCKED');
545: fnd_msg_pub.add;
546: when fnd_api.g_exc_unexpected_error then
547: rollback to wipupdserial0;
548: --status and message should have been set by inv api. set status
549: --just in case.

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

551:
552: when others then
553: rollback to wipupdserial0;
554: x_return_status := fnd_api.g_ret_sts_unexp_error;
555: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_utilities',
556: p_procedure_name => 'update_serial',
557: p_error_text => SQLERRM);
558: end update_serial;
559:

Line 607: fnd_msg_pub.add;

603: x_proc_msg => x_err_msg);
604: if(l_qty <> p_qty AND
605: l_status = 0) then
606: fnd_message.set_name('INV', 'INVALID_SERIAL_NUMBER');
607: fnd_msg_pub.add;
608: get_message_stack(p_msg => x_err_msg,
609: p_delete_stack => fnd_api.g_false,
610: p_separator => ' ');
611: end if;