APPS.AHL_UTILITY_PVT dependencies on FND_MSG_PUB

Line 62: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN

58: -----------------------------------
59: IF l_eq_pos = 0 AND l_not_pos = 0 THEN
60: -- Could not find either an = or an <>
61: -- operator.
62: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
63: Fnd_Message.set_name('AHL', 'AHL_UTIL_NO_WHERE_OPERATOR');
64: Fnd_Msg_Pub.ADD;
65: RAISE Fnd_Api.g_exc_unexpected_error;
66: END IF;

Line 64: Fnd_Msg_Pub.ADD;

60: -- Could not find either an = or an <>
61: -- operator.
62: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
63: Fnd_Message.set_name('AHL', 'AHL_UTIL_NO_WHERE_OPERATOR');
64: Fnd_Msg_Pub.ADD;
65: RAISE Fnd_Api.g_exc_unexpected_error;
66: END IF;
67: ELSIF l_eq_pos > 0 AND l_not_pos = 0 THEN
68: l_curr_pos := l_eq_pos;

Line 298: p_message_level IN NUMBER := Fnd_Msg_Pub.g_msg_lvl_debug_high --Not used

294: --
295: ---------------------------------------------------------------------
296: PROCEDURE debug_message(
297: p_message_text IN VARCHAR2,
298: p_message_level IN NUMBER := Fnd_Msg_Pub.g_msg_lvl_debug_high --Not used
299: )
300: IS
301: BEGIN
302:

Line 325: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

321: P_token_value VARCHAR2 := NULL
322: )
323: IS
324: BEGIN
325: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
326: Fnd_Message.set_name('AHL', p_message_name);
327: IF p_token_name IS NOT NULL THEN
328: Fnd_Message.set_token(p_token_name, p_token_value);
329: END IF;

Line 330: Fnd_Msg_Pub.ADD;

326: Fnd_Message.set_name('AHL', p_message_name);
327: IF p_token_name IS NOT NULL THEN
328: Fnd_Message.set_token(p_token_name, p_token_value);
329: END IF;
330: Fnd_Msg_Pub.ADD;
331: END IF;
332: END error_message;
333:
334: --======================================================================

Line 417: Fnd_Msg_Pub.ADD;

413: OPEN cur_user_stat(p_status_type,p_current_status);
414: FETCH cur_user_stat INTO l_c_system_status;
415: IF cur_user_stat%NOTFOUND THEN
416: Fnd_Message.set_name('AHL', 'AHL_COM_RECORD_FOUND');
417: Fnd_Msg_Pub.ADD;
418: END IF;
419: CLOSE cur_user_stat;
420: -- get system status code for new status code
421: OPEN cur_user_stat(p_status_type,p_next_status);

Line 425: Fnd_Msg_Pub.ADD;

421: OPEN cur_user_stat(p_status_type,p_next_status);
422: FETCH cur_user_stat INTO l_n_system_status;
423: IF cur_user_stat%NOTFOUND THEN
424: Fnd_Message.set_name('AHL', 'AHL_COM_RECORD_FOUND');
425: Fnd_Msg_Pub.ADD;
426: END IF;
427: CLOSE cur_user_stat;
428: -- System status is same then return
429: IF l_c_system_status = l_n_system_status THEN

Line 499: Fnd_Msg_Pub.ADD;

495: p_next_status);
496: FETCH cur_stat_det INTO l_dummy;
497: IF l_dummy IS NULL THEN
498: Fnd_Message.set_name('AHL', 'AHL_INVALID_STATUS');
499: Fnd_Msg_Pub.ADD;
500: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
501: ELSE
502: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
503: END IF;

Line 565: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

561: OPEN chk_appl_usg_code;
562: FETCH chk_appl_usg_code INTO l_count;
563: IF chk_appl_usg_code%NOTFOUND THEN
564: CLOSE chk_appl_usg_code;
565: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
566: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');
567: Fnd_Msg_Pub.ADD;
568: END IF;
569: x_return_status := Fnd_Api.g_ret_sts_error;

Line 567: Fnd_Msg_Pub.ADD;

563: IF chk_appl_usg_code%NOTFOUND THEN
564: CLOSE chk_appl_usg_code;
565: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
566: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');
567: Fnd_Msg_Pub.ADD;
568: END IF;
569: x_return_status := Fnd_Api.g_ret_sts_error;
570: RETURN;
571: ELSE

Line 608: Fnd_Msg_Pub.count_and_get (

604: RETURN;
605: END IF;
606: END IF;
607:
608: Fnd_Msg_Pub.count_and_get (
609: p_encoded => Fnd_Api.g_false,
610: p_count => x_msg_count,
611: p_data => x_msg_data
612: );