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;
67: ELSIF l_eq_pos > 0 AND l_not_pos = 0 THEN
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;
330: Fnd_Msg_Pub.ADD;
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;
330: Fnd_Msg_Pub.ADD;
331: END IF;
332: END error_message;
412: -- get currant system status code
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
420: -- get system status code for new status code
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
494: p_current_status,
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;
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;
570: RETURN;