DBA Data[Home] [Help]

APPS.AHL_UTILITY_PVT dependencies on FND_MESSAGE

Line 63: Fnd_Message.set_name('AHL', 'AHL_UTIL_NO_WHERE_OPERATOR');

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

Line 326: Fnd_Message.set_name('AHL', p_message_name);

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;

Line 328: Fnd_Message.set_token(p_token_name, p_token_value);

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;

Line 416: Fnd_Message.set_name('AHL', 'AHL_COM_RECORD_FOUND');

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

Line 424: Fnd_Message.set_name('AHL', 'AHL_COM_RECORD_FOUND');

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

Line 498: Fnd_Message.set_name('AHL', 'AHL_INVALID_STATUS');

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;

Line 566: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');

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;