DBA Data[Home] [Help]

APPS.UMX_REG_REQUESTS_PVT dependencies on FND_API

Line 165: IF (p_column_value IS NOT NULL AND p_column_value <> fnd_api.g_miss_char ) THEN

161: ' | column: ' || p_column ||
162: ' | columnValue: ' || p_column_value);
163: end if;
164:
165: IF (p_column_value IS NOT NULL AND p_column_value <> fnd_api.g_miss_char ) THEN
166: OPEN c1;
167: FETCH c1 INTO l_exist;
168: IF c1%NOTFOUND THEN
169: CLOSE c1;

Line 174: x_return_status := fnd_api.g_ret_sts_error;

170: fnd_message.set_name('AR','HZ_API_INVALID_LOOKUP');
171: fnd_message.set_token('COLUMN',p_column);
172: fnd_message.set_token('LOOKUP_TYPE',p_lookup_type);
173: fnd_msg_pub.add;
174: x_return_status := fnd_api.g_ret_sts_error;
175: END IF;
176: CLOSE c1;
177: END IF;
178:

Line 799: l_requested_by_user_id := fnd_api.g_miss_num;

795:
796: if (p_user_id = l_requested_by_user_id) then
797: -- User requested his own account, we need to make the
798: -- requested_by_user_id to null.
799: l_requested_by_user_id := fnd_api.g_miss_num;
800: end if;
801:
802: UMX_REG_REQUESTS_PKG.update_row (
803: X_REG_REQUEST_ID => p_reg_request_id,

Line 805: X_REQUESTED_FOR_USER_ID => fnd_api.g_miss_num,

801:
802: UMX_REG_REQUESTS_PKG.update_row (
803: X_REG_REQUEST_ID => p_reg_request_id,
804: X_STATUS_CODE => p_status_code,
805: X_REQUESTED_FOR_USER_ID => fnd_api.g_miss_num,
806: X_REQUESTED_BY_USER_ID => l_requested_by_user_id);
807:
808: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
809: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,