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 651: l_requested_by_user_id := fnd_api.g_miss_num;

647:
648: if (p_user_id = l_requested_by_user_id) then
649: -- User requested his own account, we need to make the
650: -- requested_by_user_id to null.
651: l_requested_by_user_id := fnd_api.g_miss_num;
652: end if;
653:
654: UMX_REG_REQUESTS_PKG.update_row (
655: X_REG_REQUEST_ID => p_reg_request_id,

Line 657: X_REQUESTED_FOR_USER_ID => fnd_api.g_miss_num,

653:
654: UMX_REG_REQUESTS_PKG.update_row (
655: X_REG_REQUEST_ID => p_reg_request_id,
656: X_STATUS_CODE => p_status_code,
657: X_REQUESTED_FOR_USER_ID => fnd_api.g_miss_num,
658: X_REQUESTED_BY_USER_ID => l_requested_by_user_id);
659:
660: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
661: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,